22/02/2024 07:09:06.3020 1670 ms. EXEC: insert into movtransit (traUseId,traCreation,traStatus,traUID,traYear,traDateTime,traCode,traType,traClass,traIdTerminal,traDirection,traPlate,traEnabled,traDisableTime,traAreId,traNotes,traBadge,traTarId) VALUES (0,'2024-02-22 07:09:04','V',5352614831876530,2024,'2024-02-22 07:09:03','453422350500327005012999',2,2,2,'O','',0,'2024-02-22 07:09:04',1,'','',0) 22/02/2024 18:42:41.2150 5749 ms. EXECSCALAR: select count(*) from information_schema.tables where table_schema= 'wisepark_0327' and table_name= 'payInvoiceFtp' nr: 1 22/02/2024 18:42:41.2300 8495 ms. OPEN: show columns from tabParameters where Field = 'parAllowNegativePlaces' 22/02/2024 18:42:41.3341 5868 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 3 22/02/2024 18:42:41.3361 5871 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 3 22/02/2024 18:42:41.3371 5872 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 3 22/02/2024 18:42:41.3411 5872 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 3 22/02/2024 18:42:41.3431 5878 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 3 22/02/2024 18:42:41.3471 3920 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 3 22/02/2024 18:42:43.0332 724 ms. OPEN: select * from tabCurrency where curStatus='V' and curCode = 'KES' (WAIT TIME 21 ms.) 22/02/2024 18:42:43.2434 645 ms. EXECSCALAR: select count(*) from information_schema.tables where table_schema= 'wisepark_0327' and table_name= 'tabTerminalExtraMem' nr: 1 22/02/2024 18:42:43.8478 592 ms. EXECSCALAR: select count(*) from tabTerminalExtraMem where extStatus='V' and extTerId = 2 nr: 0 22/02/2024 18:42:43.8488 593 ms. EXECSCALAR: select count(*) from tabTerminalExtraMem where extStatus='V' and extTerId = 1 nr: 0 22/02/2024 18:42:43.8508 594 ms. EXECSCALAR: select count(*) from tabTerminalExtraMem where extStatus='V' and extTerId = 2 nr: 0 22/02/2024 18:42:43.8518 597 ms. EXECSCALAR: select count(*) from tabTerminalExtraMem where extStatus='V' and extTerId = 2 nr: 0 22/02/2024 18:42:43.8518 595 ms. EXECSCALAR: select count(*) from tabTerminalExtraMem where extStatus='V' and extTerId = 1 nr: 0 22/02/2024 18:42:43.8528 590 ms. EXECSCALAR: select count(*) from tabTerminalExtraMem where extStatus='V' and extTerId = 16 nr: 0 22/02/2024 18:42:43.8528 595 ms. EXECSCALAR: select count(*) from tabTerminalExtraMem where extStatus='V' and extTerId = 16 nr: 0 (WAIT TIME 1 ms.) 22/02/2024 18:42:43.8768 621 ms. EXECSCALAR: select count(*) from tabTerminalExtraMem where extStatus='V' and extTerId = 16 nr: 0 22/02/2024 18:42:43.8918 634 ms. EXECSCALAR: select count(*) from tabTerminalExtraMem where extStatus='V' and extTerId = 1 nr: 2 22/02/2024 18:42:44.5432 650 ms. EXEC: update tabTerminalExtraMem SET extBarrier = 0 where extStatus='V' and extTerId = 1 AND extPlateWaitOperator=0 22/02/2024 18:42:44.6493 1583 ms. OPEN: select distinct tagName from tabtag where tagstatus='V' and tagMandatory=1 and tagDevCode in (select devCode from tabDevice where devStatus='V' and devId in (select lnkSubId from tabLnkDevice where lnkStatus='V' and lnkDevId = (select devId from tabDevice inner join tabTerminal on terType = devCode where terId = 3))) order by tagName 22/02/2024 18:42:44.6503 1583 ms. OPEN: select distinct tagName from tabtag where tagstatus='V' and tagMandatory=1 and tagDevCode in (select devCode from tabDevice where devStatus='V' and devId in (select lnkSubId from tabLnkDevice where lnkStatus='V' and lnkDevId = (select devId from tabDevice inner join tabTerminal on terType = devCode where terId = 3))) order by tagName 22/02/2024 18:42:44.6513 1585 ms. OPEN: select distinct tagName from tabtag where tagstatus='V' and tagMandatory=1 and tagDevCode in (select devCode from tabDevice where devStatus='V' and devId in (select lnkSubId from tabLnkDevice where lnkStatus='V' and lnkDevId = (select devId from tabDevice inner join tabTerminal on terType = devCode where terId = 3))) order by tagName 22/02/2024 18:42:44.6553 1590 ms. OPEN: select distinct tagName from tabtag where tagstatus='V' and tagMandatory=1 and tagDevCode in (select devCode from tabDevice where devStatus='V' and devId in (select lnkSubId from tabLnkDevice where lnkStatus='V' and lnkDevId = (select devId from tabDevice inner join tabTerminal on terType = devCode where terId = 3))) order by tagName 22/02/2024 18:42:45.1286 2062 ms. OPEN: select distinct tagName from tabtag where tagstatus='V' and tagMandatory=1 and tagDevCode in (select devCode from tabDevice where devStatus='V' and devId in (select lnkSubId from tabLnkDevice where lnkStatus='V' and lnkDevId = (select devId from tabDevice inner join tabTerminal on terType = devCode where terId = 3))) order by tagName 22/02/2024 18:42:45.1577 502 ms. OPEN: select * from tabUser where useStatus='V' and useBadId<>'' and useParkAccess<>0 order by useSuperUser desc,useId 22/02/2024 18:42:45.1607 2093 ms. OPEN: select distinct tagName from tabtag where tagstatus='V' and tagMandatory=1 and tagDevCode in (select devCode from tabDevice where devStatus='V' and devId in (select lnkSubId from tabLnkDevice where lnkStatus='V' and lnkDevId = (select devId from tabDevice inner join tabTerminal on terType = devCode where terId = 3))) order by tagName 22/02/2024 18:42:45.7781 506 ms. EXECSCALAR: select count(resId) as Tot from movReservation where resStatus = 'V' and resTypeRes = 'B' AND ((resConfirmed IN (0,2,3) AND resCreation>'2024-02-22 17:42:45') OR resConfirmed IN (4,5)) and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) <= '2024-02-22 18:42:43' and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) >= '2024-02-22 18:42:43' and (resAreId = 1 or resAreId <= 0) nr: 0 (WAIT TIME 3 ms.) 22/02/2024 18:42:45.7941 501 ms. EXECSCALAR: select count(resId) as Tot from movReservation where resStatus = 'V' and resTypeRes = 'B' AND ((resConfirmed IN (0,2,3) AND resCreation>'2024-02-22 17:42:45') OR resConfirmed IN (4,5)) and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) <= '2024-02-22 18:42:43' and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) >= '2024-02-22 18:42:43' and (resAreId = 1 or resAreId <= 0) nr: 0 (WAIT TIME 26 ms.) 22/02/2024 18:42:45.9772 826 ms. OPEN: SELECT * FROM tabCardConversionRules WHERE ccrStatus=@ccrStatus AND (ccrTerId = @ccrTerId OR ccrTerId=0) AND (ccrDevId = @ccrDevId OR ccrDevId=0) AND (ccrSubId = @ccrSubId OR ccrSubId=0) ORDER BY ccrTerId DESC, ccrDevId DESC, ccrSubId DESC, ccrId DESC LIMIT 1 22/02/2024 18:42:45.9782 819 ms. OPEN: SELECT * FROM tabCardConversionRules WHERE ccrStatus=@ccrStatus AND (ccrTerId = @ccrTerId OR ccrTerId=0) AND (ccrDevId = @ccrDevId OR ccrDevId=0) AND (ccrSubId = @ccrSubId OR ccrSubId=0) ORDER BY ccrTerId DESC, ccrDevId DESC, ccrSubId DESC, ccrId DESC LIMIT 1 22/02/2024 18:42:45.9782 832 ms. OPEN: SELECT * FROM tabCardConversionRules WHERE ccrStatus=@ccrStatus AND (ccrTerId = @ccrTerId OR ccrTerId=0) AND (ccrDevId = @ccrDevId OR ccrDevId=0) AND (ccrSubId = @ccrSubId OR ccrSubId=0) ORDER BY ccrTerId DESC, ccrDevId DESC, ccrSubId DESC, ccrId DESC LIMIT 1 22/02/2024 18:42:45.9802 816 ms. OPEN: SELECT * FROM tabCardConversionRules WHERE ccrStatus=@ccrStatus AND (ccrTerId = @ccrTerId OR ccrTerId=0) AND (ccrDevId = @ccrDevId OR ccrDevId=0) AND (ccrSubId = @ccrSubId OR ccrSubId=0) ORDER BY ccrTerId DESC, ccrDevId DESC, ccrSubId DESC, ccrId DESC LIMIT 1 22/02/2024 18:42:45.9802 828 ms. OPEN: SELECT * FROM tabCardConversionRules WHERE ccrStatus=@ccrStatus AND (ccrTerId = @ccrTerId OR ccrTerId=0) AND (ccrDevId = @ccrDevId OR ccrDevId=0) AND (ccrSubId = @ccrSubId OR ccrSubId=0) ORDER BY ccrTerId DESC, ccrDevId DESC, ccrSubId DESC, ccrId DESC LIMIT 1 22/02/2024 18:42:45.9812 834 ms. OPEN: SELECT * FROM tabCardConversionRules WHERE ccrStatus=@ccrStatus AND (ccrTerId = @ccrTerId OR ccrTerId=0) AND (ccrDevId = @ccrDevId OR ccrDevId=0) AND (ccrSubId = @ccrSubId OR ccrSubId=0) ORDER BY ccrTerId DESC, ccrDevId DESC, ccrSubId DESC, ccrId DESC LIMIT 1 22/02/2024 18:42:47.5012 1051 ms. EXEC: insert into payCurInventory (curTerId,curDevCode,curDevDescription,curChannelId,curChannelDescr,curValue,curType) SELECT * FROM (SELECT 3,42101,'Notes Escrow',1 as c1,'Payout',100 as v1,'N') as tmp WHERE NOT EXISTS ( SELECT curDevCode,curTerId,curChannelId,curValue FROM payCurInventory WHERE curDevCode = 42101 and curChannelId = 1 and curTerId = 3 and curValue = 100 and curType = 'N' LIMIT 1) 22/02/2024 18:42:47.5012 1051 ms. EXEC: insert into payCurInventory (curTerId,curDevCode,curDevDescription,curChannelId,curChannelDescr,curValue,curType) SELECT * FROM (SELECT 3,42101,'Notes Escrow',1 as c1,'Payout',100 as v1,'N') as tmp WHERE NOT EXISTS ( SELECT curDevCode,curTerId,curChannelId,curValue FROM payCurInventory WHERE curDevCode = 42101 and curChannelId = 1 and curTerId = 3 and curValue = 100 and curType = 'N' LIMIT 1) 22/02/2024 18:42:47.5022 1051 ms. EXEC: insert into payCurInventory (curTerId,curDevCode,curDevDescription,curChannelId,curChannelDescr,curValue,curType) SELECT * FROM (SELECT 3,42101,'Notes Escrow',1 as c1,'Payout',100 as v1,'N') as tmp WHERE NOT EXISTS ( SELECT curDevCode,curTerId,curChannelId,curValue FROM payCurInventory WHERE curDevCode = 42101 and curChannelId = 1 and curTerId = 3 and curValue = 100 and curType = 'N' LIMIT 1) 22/02/2024 18:42:47.5032 1053 ms. EXEC: insert into payCurInventory (curTerId,curDevCode,curDevDescription,curChannelId,curChannelDescr,curValue,curType) SELECT * FROM (SELECT 3,42101,'Notes Escrow',1 as c1,'Payout',100 as v1,'N') as tmp WHERE NOT EXISTS ( SELECT curDevCode,curTerId,curChannelId,curValue FROM payCurInventory WHERE curDevCode = 42101 and curChannelId = 1 and curTerId = 3 and curValue = 100 and curType = 'N' LIMIT 1) 22/02/2024 18:42:47.5072 1057 ms. EXEC: insert into payCurInventory (curTerId,curDevCode,curDevDescription,curChannelId,curChannelDescr,curValue,curType) SELECT * FROM (SELECT 3,42101,'Notes Escrow',1 as c1,'Payout',100 as v1,'N') as tmp WHERE NOT EXISTS ( SELECT curDevCode,curTerId,curChannelId,curValue FROM payCurInventory WHERE curDevCode = 42101 and curChannelId = 1 and curTerId = 3 and curValue = 100 and curType = 'N' LIMIT 1) 22/02/2024 18:42:47.5112 1058 ms. EXEC: insert into payCurInventory (curTerId,curDevCode,curDevDescription,curChannelId,curChannelDescr,curValue,curType) SELECT * FROM (SELECT 3,42101,'Notes Escrow',1 as c1,'Payout',100 as v1,'N') as tmp WHERE NOT EXISTS ( SELECT curDevCode,curTerId,curChannelId,curValue FROM payCurInventory WHERE curDevCode = 42101 and curChannelId = 1 and curTerId = 3 and curValue = 100 and curType = 'N' LIMIT 1) 22/02/2024 18:42:57.1891 10844 ms. OPEN: SELECT * FROM movLinks INNER JOIN movTransit on traUID = mliTraUID WHERE mliRFIDCode = '453426698500327005031999' AND mliStatus='V' ORDER BY mliId DESC LIMIT 1 22/02/2024 18:42:57.1891 12580 ms. OPEN: SELECT * FROM movLinks INNER JOIN movTransit on traUID = mliTraUID WHERE mliRFIDCode = '0098788195000' AND mliStatus='V' ORDER BY mliId DESC LIMIT 1 22/02/2024 18:42:58.8046 570 ms. OPEN: select * from tabUserMessage where useMesDescr = 'err_ticketnotfound' and (useLanCode = 'en-US' or mid(useLanCode,1,2) = 'en') 22/02/2024 18:42:59.2889 16251 ms. EXECSCALAR: SELECT count(*) FROM payinventory WHERE invValue<>0 AND invType='' nr: 0 22/02/2024 18:43:01.9141 2785 ms. EXEC: insert into movtransit (traUseId,traCreation,traStatus,traUID,traYear,traDateTime,traCode,traType,traClass,traIdTerminal,traDirection,traPlate,traEnabled,traDisableTime,traAreId,traNotes,traBadge,traCarId,traTarId) VALUES (0,'2024-02-22 18:42:59','V',5230375481865410,2024,'2024-02-22 18:35:57','453426503600327002029999',2,1,2,'O','',1,0,1,'','0532370680504',141,0) 22/02/2024 18:43:01.9141 2263 ms. EXEC: insert into movtransit (traUseId,traCreation,traStatus,traUID,traYear,traDateTime,traCode,traType,traClass,traIdTerminal,traDirection,traPlate,traEnabled,traDisableTime,traAreId,traNotes,traBadge,traTarId) VALUES (0,'2024-02-22 18:42:59','V',4935194041394050,2024,'2024-02-22 18:36:25','453426698500327005031999',1,2,16,'I','',1,0,1,'','',4) 22/02/2024 18:43:03.1049 2393 ms. OPEN: show columns from movoperator where Field = 'opeQuery' 22/02/2024 18:43:04.0796 2155 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 22/02/2024 18:43:04.0796 884 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 22/02/2024 18:43:05.0872 5685 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 22/02/2024 18:43:08.6266 3539 ms. EXEC: UPDATE payInventory SET invType='C' WHERE invType<>'C' AND invValue IN (5,10,20,40) AND invDevice IN (41003,41002,41001,41101,41102,41103); 22/02/2024 18:43:46.5337 657 ms. OPEN: select sum(payPayed) as vTot,sum(payChange) as vChange from movTransit inner join payPayment on payPayment.payTraUID = movTransit.traUID LEFT JOIN tabTerminal on terId = payIdTerminal WHERE traCode = '453416553300327005012999' AND traStatus='V' AND payStatus='V' and (terType IS NULL OR terType<>3 OR (terType=3 and payType='P')) 22/02/2024 18:52:09.7059 738 ms. OPEN: select traId,traDateTime,traEnabled,traDisableTime,traCode,traBadge,traCarId,traAreId,traIdTerminal from movtransit where traStatus='V' and traDirection = 'I' and traCarId = 29 order by traDateTime desc,traId desc 22/02/2024 18:52:42.6099 5940 ms. OPEN: select count(payId) as Tot,0 as payUID,sum(payPayed) as payPayed,sum(payChange) as payChange,payAmount,traUIDGroup,traType,traClass,traIdTerminal,traDiscountValue,traDiscountType,traCarId,payIdEvent,payType,payCardType from payPayment LEFT join movtransit on trauid = payTraUID LEFT JOIN payReport ON repPayUID = payUID AND repStatus='V' where payStatus = 'V' and (payType='C' or payType='P') and payUseId = 10 and payIdEvent<90 and repPayUID IS NULL and (traCarId is null or traCarId=0 or traCarId in (select carId from abbCards inner join abbsubscriptions on subId= carSubId where carStatus='V' and subStatus='V' and subAbbType<>5)) group by traUIDGroup,payAmount,payIdEvent,payType,payCardType,traType,traIdTerminal,traDiscountValue,traDiscountType,traCarId order by traUIDGroup,payAmount, traType, traDiscountValue, traDiscountType 22/02/2024 18:52:43.4156 804 ms. OPEN: select * from payFiscalReport where fsrStatus='V' and fsrType = 2 and fsrUseId = 10 order by fsrDateTime desc 22/02/2024 18:58:24.1347 736 ms. OPEN: select traId,traDateTime,traEnabled,traDisableTime,traCode,traBadge,traCarId,traAreId,traIdTerminal from movtransit where traStatus='V' and traDirection = 'I' and traCarId = 82 order by traDateTime desc,traId desc 22/02/2024 19:12:29.1059 643 ms. OPEN: select traId,traDateTime,traEnabled,traDisableTime,traCode,traBadge,traCarId,traAreId,traIdTerminal from movtransit where traStatus='V' and traDirection = 'I' and traCarId = 97 order by traDateTime desc,traId desc 22/02/2024 19:20:30.2598 2070 ms. OPEN: select traId,traDateTime,traEnabled,traDisableTime,traCode,traBadge,traCarId,traAreId,traIdTerminal from movtransit where traStatus='V' and traDirection = 'I' and traCarId = 14 order by traDateTime desc,traId desc 22/02/2024 19:36:57.2055 2087 ms. OPEN: select count(payId) as Tot,0 as payUID,sum(payPayed) as payPayed,sum(payChange) as payChange,payAmount,traUIDGroup,traType,traClass,traIdTerminal,traDiscountValue,traDiscountType,traCarId,payIdEvent,payType,payCardType from payPayment LEFT join movtransit on trauid = payTraUID LEFT JOIN payReport ON repPayUID = payUID AND repStatus='V' where payStatus = 'V' and (payType='C' or payType='P') and payUseId = 9 and payIdEvent<90 and repPayUID IS NULL and (traCarId is null or traCarId=0 or traCarId in (select carId from abbCards inner join abbsubscriptions on subId= carSubId where carStatus='V' and subStatus='V' and subAbbType<>5)) group by traUIDGroup,payAmount,payIdEvent,payType,payCardType,traType,traIdTerminal,traDiscountValue,traDiscountType,traCarId order by traUIDGroup,payAmount, traType, traDiscountValue, traDiscountType 22/02/2024 20:01:54.7553 940 ms. OPEN: select traId,traDateTime,traEnabled,traDisableTime,traCode,traBadge,traCarId,traAreId,traIdTerminal from movtransit where traStatus='V' and traDirection = 'I' and traCarId = 10 order by traDateTime desc,traId desc