18/08/2025 10:23:44.8448 26319 ms. OPEN: select * from tablanguages where lanStatus='V' order by lannumber limit 1 18/08/2025 10:23:44.8598 26318 ms. OPEN: select * from tablanguages where lanStatus='V' order by lannumber limit 1 18/08/2025 10:23:44.8788 26353 ms. OPEN: show columns from tabParameters where Field = 'parAllowNegativePlaces' 18/08/2025 10:23:45.4732 564 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 5 18/08/2025 10:23:45.4732 561 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 3 18/08/2025 10:23:45.4742 565 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 3 18/08/2025 10:23:45.4742 562 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 2 18/08/2025 10:23:45.4752 566 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 2 18/08/2025 10:23:45.4752 560 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 1 18/08/2025 10:23:45.4772 565 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 1 18/08/2025 10:23:45.4772 561 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 2 18/08/2025 10:23:45.4792 562 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 1 18/08/2025 10:23:45.4802 565 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 1 18/08/2025 10:23:45.4802 570 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 2 18/08/2025 10:23:45.4822 572 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 1 18/08/2025 10:23:45.4822 558 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 3 18/08/2025 10:23:54.1650 6882 ms. OPEN: SELECT * FROM movLinks INNER JOIN movTransit on traUID = mliTraUID WHERE mliRFIDCode = '0098788191894' AND mliStatus='V' ORDER BY mliId DESC LIMIT 1 18/08/2025 10:23:54.2281 6446 ms. OPEN: SELECT * FROM movLinks INNER JOIN movTransit on traUID = mliTraUID WHERE mliRFIDCode = '0098788346375' AND mliStatus='V' ORDER BY mliId DESC LIMIT 1 18/08/2025 10:23:54.2291 6641 ms. OPEN: SELECT * FROM movLinks INNER JOIN movTransit on traUID = mliTraUID WHERE mliRFIDCode = '458853726100327001031999' AND mliStatus='V' ORDER BY mliId DESC LIMIT 1 18/08/2025 10:23:54.4903 8732 ms. EXECSCALAR: SELECT count(*) FROM payinventory WHERE invValue<>0 AND invType='' nr: 0 18/08/2025 10:23:55.5881 997 ms. OPEN: select * from tabUserMessage where useMesDescr = 'err_ticketnotfound' and (useLanCode = 'en-US' or mid(useLanCode,1,2) = 'en') 18/08/2025 10:23:55.8022 916 ms. OPEN: select * from abbCards inner join abbSubscriptions on carSubId = subId inner join tabCustomer on cusId = subCusId left join tabAbbGroups on cusAbgId = abgId where carStatus='V' and carId = 165 18/08/2025 10:23:57.7175 1909 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,'2025-08-18 10.23.55','V',4797509798551160,2025,'2025-08-18 10.19.58','458853569300327005029999',2,2,16,'I','',1,0,1,'','0532370831879',165,0) 18/08/2025 10:23:57.7175 1374 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,'2025-08-18 10.23.56','V',4720706888716760,2025,'2025-08-18 10.21.01','458853726100327001031999',1,2,1,'I','',1,0,1,'','',4) 18/08/2025 10:23:58.0177 3462 ms. OPEN: select * from movTransit where traStatus='V' and traCode = '0098788191894' and traDirection='I' order by traId desc limit 1 18/08/2025 10:23:58.9853 1255 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 18/08/2025 10:23:59.0344 940 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 18/08/2025 10:23:59.0354 979 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 18/08/2025 10:23:59.8649 5293 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 18/08/2025 10:24:00.9506 1085 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); 18/08/2025 10:25:20.6810 525 ms. EXEC: insert into payReceipt (recTraUID,recPayUID,recYear,recDateTime,recText,recInvalid) VALUES (4978368257166860,4852406535985960,2025,'2025-08-18 10.25.20',' Date: 18/08/2025 10.25.19 Code: 458853473800327005012999 Entry Date: 18/08/2025 9.38.58 Plate: Class: Cars Park: The Mall Gate: Entry 2 ______________________________ Total: 50.00 KES ______________________________ Paid: 50.00 KES __________ Change: 0.00 KES Type: Cash Dispozitiv: MPESA # 2500730469 ',0) 18/08/2025 10:25:22.4492 35975 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 = 6 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 18/08/2025 10:26:02.5396 795 ms. OPEN: select 1 as Tot,payUID,payPayed,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 = 6 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)) order by traUIDGroup,payAmount, traType, traDiscountValue, traDiscountType 18/08/2025 10:32:56.9952 2851 ms. OPEN: select 1 as Tot,payUID,payPayed,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 = 12 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)) order by traUIDGroup,payAmount, traType, traDiscountValue, traDiscountType 18/08/2025 10:35:23.5145 1393 ms. OPEN: select traId,traDateTime,traEnabled,traDisableTime,traCode,traBadge,traCarId,traAreId,traIdTerminal from movtransit where traStatus='V' and traDirection = 'I' and traCarId = 13 order by traDateTime desc,traId desc 18/08/2025 10:38:42.8375 1667 ms. OPEN: select traId,traDateTime,traEnabled,traDisableTime,traCode,traBadge,traCarId,traAreId,traIdTerminal from movtransit where traStatus='V' and traDirection = 'I' and traCarId = 15 order by traDateTime desc,traId desc 18/08/2025 10:59:00.0216 511 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,'2025-08-18 10.58.59','V',5469389101745340,2025,'2025-08-18 10.58.59','458853153800327005012999',2,2,2,'O','',0,'2025-08-18 10.58.59',1,'','',0) 18/08/2025 11:02:45.4408 550 ms. EXEC: update paycash set casCreation = '2025-08-18 11.02.44',casModify = '2025-08-18 11.02.44',casUseId=0,casStatus='V' where casId = 234078 18/08/2025 11:04:13.2968 527 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 18/08/2025 11:06:06.4157 684 ms. EXEC: insert into payReceipt (recTraUID,recPayUID,recYear,recDateTime,recText,recInvalid) VALUES (5536487286974120,4663298074531990,2025,'2025-08-18 11.06.05',' Date: 01/01/2014 0.47.37 Code: 458853841000327005012999 Entry Date: 18/08/2025 10.40.10 Plate: Class: Cars Park: The Mall Gate: Entry 2 ______________________________ Total: 50.00 KES ______________________________ Paid: 50.00 KES __________ Change: 0.00 KES Type: Credit Card Dispozitiv: Manual Cashier 1 # 2500411694 ',0) 18/08/2025 11:18:32.2311 624 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 18/08/2025 11:57:11.3874 502 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 = 6 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 18/08/2025 12:41:37.6586 513 ms. EXEC: update tabTerminalReceipt set trcProgressive = 6234, trcLastPrinted = '2500606234', trcLastDate = '2025-08-18 12.41.37' where trcStatus='V' and trcTerId = 17 18/08/2025 13:37:05.9979 7131 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 2 18/08/2025 13:37:06.0989 7128 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 5 (WAIT TIME 100 ms.) 18/08/2025 13:37:06.1009 7132 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 5 (WAIT TIME 103 ms.) 18/08/2025 13:37:06.1019 7131 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 1 (WAIT TIME 103 ms.) 18/08/2025 13:37:06.1019 7132 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 5 (WAIT TIME 101 ms.) 18/08/2025 13:37:06.1029 7137 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 1 (WAIT TIME 96 ms.) 18/08/2025 13:37:06.1069 7138 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 1 (WAIT TIME 99 ms.) 18/08/2025 13:37:06.1079 7143 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 2 (WAIT TIME 98 ms.) 18/08/2025 13:37:06.1169 7142 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 2 (WAIT TIME 108 ms.) 18/08/2025 13:37:06.1179 7143 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 2 (WAIT TIME 107 ms.) 18/08/2025 13:37:06.1200 7134 ms. OPEN: show columns from tabParameters where Field = 'parVatMethod' (WAIT TIME 115 ms.) 18/08/2025 13:37:06.1210 7140 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 5 (WAIT TIME 114 ms.) 18/08/2025 13:37:06.1220 7140 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 5 (WAIT TIME 113 ms.) 18/08/2025 13:37:06.1300 7128 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 1 18/08/2025 13:37:06.1410 7130 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 1 (WAIT TIME 15 ms.) 18/08/2025 13:37:06.1480 7131 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 2 (WAIT TIME 33 ms.) 18/08/2025 13:37:07.6282 694 ms. OPEN: select * from tabTicketType where ticStatus='V' and ticOption='S' order by ticType,ticId 18/08/2025 13:37:08.1646 537 ms. OPEN: select * from tabUser where useStatus='V' and useBadId<>'' and useParkAccess<>0 order by useSuperUser desc,useId 18/08/2025 13:37:08.1666 539 ms. OPEN: select * from tabUser where useStatus='V' and useBadId<>'' and useParkAccess<>0 order by useSuperUser desc,useId 18/08/2025 13:37:08.9801 813 ms. EXECSCALAR: select count(*) from information_schema.tables where table_schema= 'wisepark_0327' and table_name= 'tabCardConversionRules' nr: 1 18/08/2025 13:37:09.0101 1785 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 18/08/2025 13:37:09.0131 1789 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 18/08/2025 13:37:09.0201 1795 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 18/08/2025 13:37:09.0612 1837 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 18/08/2025 13:37:10.4293 502 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) 18/08/2025 13:37:10.4303 503 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) 18/08/2025 13:37:10.4313 503 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) 18/08/2025 13:37:10.4313 502 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) 18/08/2025 13:37:10.4313 502 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) 18/08/2025 13:37:10.4454 519 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) 18/08/2025 13:37:17.0142 677 ms. OPEN: SELECT * FROM abbsubscriptions INNER JOIN abbcards ON carSubId=subId INNER JOIN tabcustomer ON subCusId=cusId WHERE carStatus='V' AND subStatus='V' AND (carCode<>'' OR carUHFCode<>'') AND subAbbType NOT IN (6,-1) ORDER BY carCode 18/08/2025 13:37:19.0330 10867 ms. EXECSCALAR: SELECT count(*) FROM payinventory WHERE invValue<>0 AND invType='' nr: 0 18/08/2025 13:37:20.2578 9755 ms. OPEN: SELECT * FROM movLinks INNER JOIN movTransit on traUID = mliTraUID WHERE mliRFIDCode = '458854880500327005031999' AND mliStatus='V' ORDER BY mliId DESC LIMIT 1 18/08/2025 13:37:20.2578 9988 ms. OPEN: SELECT * FROM movLinks INNER JOIN movTransit on traUID = mliTraUID WHERE mliRFIDCode = '458854887200327001031999' AND mliStatus='V' ORDER BY mliId DESC LIMIT 1 18/08/2025 13:37:24.1421 2090 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,'2025-08-18 13.37.22','V',5353998210515290,2025,'2025-08-18 13.33.25','458854880500327005031999',1,2,16,'I','',1,0,1,'','',4) 18/08/2025 13:37:24.1431 2089 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,'2025-08-18 13.37.22','V',5233544811390510,2025,'2025-08-18 13.34.32','458854887200327001031999',1,2,1,'I','',1,0,1,'','',4) 18/08/2025 13:37:24.1431 2090 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,'2025-08-18 13.37.22','V',4840757778291740,2025,'2025-08-18 13.33.25','458854880500327005031999',1,2,16,'I','',1,0,1,'','',4) 18/08/2025 13:37:24.3382 5298 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 18/08/2025 13:37:25.6594 1346 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 18/08/2025 13:37:25.6604 1505 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 18/08/2025 13:37:25.6604 1506 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 18/08/2025 13:37:28.0380 3699 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); 18/08/2025 13:37:28.6494 533 ms. EXEC: UPDATE payInventory SET invType='N' WHERE invType<>'N' AND invValue IN (100,200,500) AND invDevice IN (42102,42101,42001); 18/08/2025 13:37:43.1255 14356 ms. OPEN: select traId,traDateTime,traEnabled,traDisableTime,traCode,traBadge,traCarId,traAreId,traIdTerminal from movtransit where traStatus='V' and traDirection = 'I' and traCarId = 15 order by traDateTime desc,traId desc 18/08/2025 13:37:44.5425 994 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 = '458846143700327001012999' AND traStatus='V' AND payStatus='V' and (terType IS NULL OR terType<>3 OR (terType=3 and payType='P')) 18/08/2025 13:38:05.6672 17886 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 = 12 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 18/08/2025 13:38:47.2847 1533 ms. EXECSCALAR: select count(payId) from paypayment where payStatus='V' and payIdTerminal = 17 and payDateTime = '2025-08-18 13.38.42' nr: 0 18/08/2025 13:38:48.8498 1243 ms. EXEC: insert into movOperator (opeCreation,opeTerId,opeUseId,opeDateTime,opeCode,opeDescription) VALUES ('2025-08-18 13.38.47',17,12,'2025-08-18 13.38.47','458854735300327005012999','Pagato (Contanti ) Biglietto ') 18/08/2025 13:40:19.4808 3405 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 = 6 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 18/08/2025 13:40:59.5233 902 ms. OPEN: select traId,traDateTime,traEnabled,traDisableTime,traCode,traBadge,traCarId,traAreId,traIdTerminal from movtransit where traStatus='V' and traDirection = 'I' and traCarId = 17 order by traDateTime desc,traId desc 18/08/2025 13:47:51.0902 1155 ms. OPEN: select traId,traDateTime,traEnabled,traDisableTime,traCode,traBadge,traCarId,traAreId,traIdTerminal from movtransit where traStatus='V' and traDirection = 'I' and traCarId = 13 order by traDateTime desc,traId desc 18/08/2025 14:03:30.7325 826 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 = 6 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 18/08/2025 14:07:33.0244 542 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 = 6 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 18/08/2025 15:15:39.0460 670 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 18/08/2025 15:19:44.0934 556 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2025-08-18 15.19.43' where traUID = 4623173944822600 and traStatus='V' and traEnabled=1 18/08/2025 16:24:10.2705 619 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 18/08/2025 20:26:04.8748 30348 ms. OPEN: show columns from tabParameters where Field = 'parAllowNegativePlaces' 18/08/2025 20:26:04.8818 30375 ms. OPEN: select * from tablanguages where lanStatus='V' order by lannumber limit 1 (WAIT TIME 7 ms.) 18/08/2025 20:26:06.7151 505 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 3 and terStatus='V' (WAIT TIME 87 ms.) 18/08/2025 20:26:06.7221 503 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 1 and terStatus='V' (WAIT TIME 95 ms.) 18/08/2025 20:26:06.7351 501 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 3 and terStatus='V' (WAIT TIME 111 ms.) 18/08/2025 20:26:07.4867 539 ms. OPEN: select * from tabArea where areId = 1 18/08/2025 20:26:07.5408 586 ms. OPEN: show columns from abbCards where Field = 'carUHFCode' 18/08/2025 20:26:08.7085 1167 ms. OPEN: SELECT * FROM abbsubscriptions INNER JOIN abbcards ON carSubId=subId INNER JOIN tabcustomer ON subCusId=cusId WHERE carStatus='V' AND subStatus='V' AND (carCode<>'' OR carUHFCode<>'') AND subAbbType NOT IN (6,-1) ORDER BY carCode 18/08/2025 20:26:09.5961 1352 ms. EXECSCALAR: select count(resId) as Tot from movReservation where resStatus = 'V' and resTypeRes = 'B' AND ((resConfirmed IN (0,2,3) AND resCreation>'2025-08-18 19:26:08') OR resConfirmed IN (4,5)) and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) <= '2025-08-18 20:26:06' and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) >= '2025-08-18 20:26:06' and (resAreId = 1 or resAreId <= 0) nr: 0 18/08/2025 20:26:09.5981 1352 ms. EXECSCALAR: select count(resId) as Tot from movReservation where resStatus = 'V' and resTypeRes = 'B' AND ((resConfirmed IN (0,2,3) AND resCreation>'2025-08-18 19:26:08') OR resConfirmed IN (4,5)) and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) <= '2025-08-18 20:26:06' and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) >= '2025-08-18 20:26:06' and (resAreId = 1 or resAreId <= 0) nr: 0 18/08/2025 20:26:09.5981 1349 ms. EXECSCALAR: select count(resId) as Tot from movReservation where resStatus = 'V' and resTypeRes = 'B' AND ((resConfirmed IN (0,2,3) AND resCreation>'2025-08-18 19:26:08') OR resConfirmed IN (4,5)) and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) <= '2025-08-18 20:26:06' and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) >= '2025-08-18 20:26:06' and (resAreId = 1 or resAreId <= 0) nr: 0 18/08/2025 20:26:09.6001 1357 ms. EXECSCALAR: select count(resId) as Tot from movReservation where resStatus = 'V' and resTypeRes = 'B' AND ((resConfirmed IN (0,2,3) AND resCreation>'2025-08-18 19:26:08') OR resConfirmed IN (4,5)) and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) <= '2025-08-18 20:26:06' and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) >= '2025-08-18 20:26:06' and (resAreId = 1 or resAreId <= 0) nr: 0 18/08/2025 20:26:09.6001 1356 ms. EXECSCALAR: select count(resId) as Tot from movReservation where resStatus = 'V' and resTypeRes = 'B' AND ((resConfirmed IN (0,2,3) AND resCreation>'2025-08-18 19:26:08') OR resConfirmed IN (4,5)) and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) <= '2025-08-18 20:26:06' and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) >= '2025-08-18 20:26:06' and (resAreId = 1 or resAreId <= 0) nr: 0 18/08/2025 20:26:09.6011 1353 ms. EXECSCALAR: select count(resId) as Tot from movReservation where resStatus = 'V' and resTypeRes = 'B' AND ((resConfirmed IN (0,2,3) AND resCreation>'2025-08-18 19:26:08') OR resConfirmed IN (4,5)) and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) <= '2025-08-18 20:26:06' and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) >= '2025-08-18 20:26:06' and (resAreId = 1 or resAreId <= 0) nr: 0 18/08/2025 20:26:09.6021 1359 ms. EXECSCALAR: select count(resId) as Tot from movReservation where resStatus = 'V' and resTypeRes = 'B' AND ((resConfirmed IN (0,2,3) AND resCreation>'2025-08-18 19:26:08') OR resConfirmed IN (4,5)) and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) <= '2025-08-18 20:26:06' and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) >= '2025-08-18 20:26:06' and (resAreId = 1 or resAreId <= 0) nr: 0 18/08/2025 20:26:09.6051 1360 ms. EXECSCALAR: select count(resId) as Tot from movReservation where resStatus = 'V' and resTypeRes = 'B' AND ((resConfirmed IN (0,2,3) AND resCreation>'2025-08-18 19:26:08') OR resConfirmed IN (4,5)) and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) <= '2025-08-18 20:26:06' and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) >= '2025-08-18 20:26:06' and (resAreId = 1 or resAreId <= 0) nr: 0 18/08/2025 20:26:09.6061 1358 ms. EXECSCALAR: select count(resId) as Tot from movReservation where resStatus = 'V' and resTypeRes = 'B' AND ((resConfirmed IN (0,2,3) AND resCreation>'2025-08-18 19:26:08') OR resConfirmed IN (4,5)) and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) <= '2025-08-18 20:26:06' and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) >= '2025-08-18 20:26:06' and (resAreId = 1 or resAreId <= 0) nr: 0 18/08/2025 20:26:09.6071 1362 ms. EXECSCALAR: select count(resId) as Tot from movReservation where resStatus = 'V' and resTypeRes = 'B' AND ((resConfirmed IN (0,2,3) AND resCreation>'2025-08-18 19:26:08') OR resConfirmed IN (4,5)) and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) <= '2025-08-18 20:26:06' and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) >= '2025-08-18 20:26:06' and (resAreId = 1 or resAreId <= 0) nr: 0 18/08/2025 20:26:09.6111 1363 ms. EXECSCALAR: select count(resId) as Tot from movReservation where resStatus = 'V' and resTypeRes = 'B' AND ((resConfirmed IN (0,2,3) AND resCreation>'2025-08-18 19:26:08') OR resConfirmed IN (4,5)) and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) <= '2025-08-18 20:26:06' and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) >= '2025-08-18 20:26:06' and (resAreId = 1 or resAreId <= 0) nr: 0 18/08/2025 20:26:09.6182 1358 ms. EXECSCALAR: select count(resId) as Tot from movReservation where resStatus = 'V' and resTypeRes = 'B' AND ((resConfirmed IN (0,2,3) AND resCreation>'2025-08-18 19:26:08') OR resConfirmed IN (4,5)) and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) <= '2025-08-18 20:26:06' and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) >= '2025-08-18 20:26:06' and (resAreId = 1 or resAreId <= 0) nr: 0 (WAIT TIME 11 ms.) 18/08/2025 20:26:26.7844 15499 ms. OPEN: SELECT * FROM movLinks INNER JOIN movTransit on traUID = mliTraUID WHERE mliRFIDCode = '458857293400327005031999' AND mliStatus='V' ORDER BY mliId DESC LIMIT 1 18/08/2025 20:26:26.7844 1385 ms. OPEN: SELECT * FROM movLinks INNER JOIN movTransit on traUID = mliTraUID WHERE mliRFIDCode = '0098788191894' AND mliStatus='V' ORDER BY mliId DESC LIMIT 1 18/08/2025 20:26:28.5556 655 ms. OPEN: select * from tabUserMessage where useMesDescr = 'err_ticketnotfound' and (useLanCode = 'en-US' or mid(useLanCode,1,2) = 'en') 18/08/2025 20:26:31.4136 25312 ms. EXECSCALAR: SELECT count(*) FROM payinventory WHERE invValue<>0 AND invType='' nr: 0 18/08/2025 20:26:32.0600 4206 ms. OPEN: select * from movTransit where traStatus='V' and traCode = '0098788191894' and traDirection='I' order by traId desc limit 1 18/08/2025 20:26:32.4113 2815 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,'2025-08-18 20:26:29','V',4851774218017610,2025,'2025-08-18 20:15:34','458857293400327005031999',1,2,16,'I','',1,0,1,'','',4) 18/08/2025 20:26:32.4123 2815 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,'2025-08-18 20:26:29','V',4652482728919360,2025,'2025-08-18 20:15:34','458857293400327005031999',1,2,16,'I','',1,0,1,'','',4) 18/08/2025 20:26:34.3035 1869 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 18/08/2025 20:26:34.3035 1679 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 18/08/2025 20:26:34.3035 1866 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 18/08/2025 20:26:37.3986 5500 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 18/08/2025 20:26:40.6388 3239 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); 18/08/2025 20:26:45.3629 2568 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 = '458853229400327005012999' AND traStatus='V' AND payStatus='V' and (terType IS NULL OR terType<>3 OR (terType=3 and payType='P')) 18/08/2025 20:27:30.8180 25568 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 18/08/2025 20:28:03.1430 613 ms. EXEC: insert into payReceipt (recTraUID,recPayUID,recYear,recDateTime,recText,recInvalid) VALUES (5309523720011380,5068853346389380,2025,'2025-08-18 20:28:02',' Date: 8/18/2025 8:28:02 PM Code: 458853229400327005012999 Entry Date: 8/18/2025 8:58:14 AM Plate: Class: Cars Park: The Mall Gate: Entry 2 ______________________________ Total: 1000.00 KES ______________________________ Paid: 1000.00 KES __________ Change: 0.00 KES Type: Cash Dispozitiv: MPESA # 2500730564 ',0) 18/08/2025 20:28:18.3029 4575 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 = 1 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 18/08/2025 21:08:22.1638 1508 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 5 18/08/2025 21:08:22.2259 1387 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 5 (WAIT TIME 62 ms.) 18/08/2025 21:08:22.2259 1373 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 1 (WAIT TIME 57 ms.) 18/08/2025 21:08:22.2269 1474 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 2 (WAIT TIME 57 ms.) 18/08/2025 21:08:22.2769 1846 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 3 (WAIT TIME 103 ms.) 18/08/2025 21:08:22.2769 1153 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 1 (WAIT TIME 98 ms.) 18/08/2025 21:08:22.2769 1364 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 2 (WAIT TIME 97 ms.) 18/08/2025 21:08:22.2779 1641 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 1 (WAIT TIME 97 ms.) 18/08/2025 21:08:22.2779 1573 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 2 (WAIT TIME 102 ms.) 18/08/2025 21:08:22.2789 1248 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 1 (WAIT TIME 102 ms.) 18/08/2025 21:08:22.2799 1173 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 5 (WAIT TIME 101 ms.) 18/08/2025 21:08:22.2819 1323 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 5 (WAIT TIME 113 ms.) 18/08/2025 21:08:22.2829 1185 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 2 (WAIT TIME 109 ms.) 18/08/2025 21:08:22.2839 1302 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 1 (WAIT TIME 106 ms.) 18/08/2025 21:08:22.2899 1435 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 1 (WAIT TIME 119 ms.) 18/08/2025 21:08:22.2909 1286 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 2 (WAIT TIME 116 ms.) 18/08/2025 21:08:22.2919 932 ms. OPEN: select * from payCurInventory where curTerId = 0 order by curDevCode,curChannelId,curValue,curType,curAmount desc (WAIT TIME 21 ms.) 18/08/2025 21:08:22.2969 976 ms. OPEN: select * from tabDevInstalled inner join tabTerminal on terId = insTerId inner join tabDevice on devId = insDevId where terId = 0 and devCode>40001 and devCode<49999 and devStatus='V' and insStatus='V' (WAIT TIME 15 ms.) 18/08/2025 21:08:22.3549 1953 ms. OPEN: select * from payCurInventory where curTerId = 0 and curQuantity>0 and curType in ('C','N') order by curDevCode,curChannelId,curValue (WAIT TIME 53 ms.) 18/08/2025 21:08:22.3559 1965 ms. OPEN: select * from payCurInventory where curTerId = 0 and curQuantity>0 and curType in ('C','N') order by curDevCode,curChannelId,curValue (WAIT TIME 54 ms.) 18/08/2025 21:08:22.4870 1985 ms. OPEN: select * from payCurInventory where curTerId = 0 and curQuantity>0 and curType in ('C','N') order by curDevCode,curChannelId,curValue (WAIT TIME 174 ms.) 18/08/2025 21:08:23.2965 693 ms. EXEC: CREATE TABLE IF NOT EXISTS tabTimeZones(timId int(11) not null auto_increment,timCreation DATETIME not null default '0000-00-00',timModify TIMESTAMP not null,timUseId int(11) not null default 0,timStatus varchar(1) not null default 'V',timRegion varchar(5) not null default '',timIdWindows varchar(100) not null default '',timIdLinux varchar(100) not null default '', PRIMARY KEY (timId)) ENGINE=InnoDB DEFAULT CHARSET=utf8; 18/08/2025 21:08:29.1208 5771 ms. OPEN: show columns from opeActivities where Field = 'acvCausal' 18/08/2025 21:08:29.7151 544 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 18/08/2025 21:08:29.7191 549 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 18/08/2025 21:08:29.7271 578 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 18/08/2025 21:08:35.2456 12642 ms. OPEN: SELECT * FROM movLinks INNER JOIN movTransit on traUID = mliTraUID WHERE mliRFIDCode = '0240526473492' AND mliStatus='V' ORDER BY mliId DESC LIMIT 1 18/08/2025 21:08:35.2456 3018 ms. OPEN: SELECT traCode FROM movTransit WHERE traId = '1003676' and traDirection='I' order by traId DESC LIMIT 1 18/08/2025 21:08:35.2686 6106 ms. OPEN: SELECT * FROM movLinks INNER JOIN movTransit on traUID = mliTraUID WHERE mliRFIDCode = '0098788349024' AND mliStatus='V' ORDER BY mliId DESC LIMIT 1 18/08/2025 21:08:36.6395 655 ms. OPEN: select max(traCode) as vCode from movTransit where traCode >='45885 ' and traCode < '45886 ' and traType = 2 18/08/2025 21:08:36.6655 650 ms. OPEN: select * from tabUserMessage where useMesDescr = 'err_ticketDisabled' and (useLanCode = 'en-US' or mid(useLanCode,1,2) = 'en') 18/08/2025 21:08:37.2559 588 ms. OPEN: select * from abbCards inner join abbSubscriptions on carSubId = subId inner join tabCustomer on cusId = subCusId left join tabAbbGroups on cusAbgId = abgId where carStatus='V' and carId = 190 18/08/2025 21:08:39.0949 1834 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,'2025-08-18 21.08.37','V',4698237456797540,2025,'2025-08-18 21.06.47','458857475300327005029999',2,2,16,'I','',1,0,1,'','1301662556436',190,0) 18/08/2025 21:08:39.0949 2414 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,'2025-08-18 21.08.36','V',5266342437012230,2025,'2025-08-18 21.04.16','458857475300327002029999',2,1,2,'O','',1,0,1,'','0532370834528',10,0) 18/08/2025 21:08:41.3832 2168 ms. OPEN: select sum(casTotAmount) as vTot from movTransit inner join payCash on payCash.casTraUID = movTransit.traUID inner join tabTerminal on terId = casIdTerminal where traCode = '458857443500327005012999' and traStatus='V' and casStatus='V' and terType=3 and casTotAmount>0 18/08/2025 21:09:14.3256 26967 ms. OPEN: select 1 as Tot,payUID,payPayed,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 = 1 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)) order by traUIDGroup,payAmount, traType, traDiscountValue, traDiscountType 18/08/2025 21:09:14.3256 45204 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 = 1 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 18/08/2025 21:09:29.9787 2040 ms. OPEN: select * from movTransit where traStatus='V' and traCode = '0098788191894' and traDirection='I' order by traId desc limit 1 18/08/2025 21:40:26.5798 26324 ms. OPEN: select * from tablanguages where lanStatus='V' order by lannumber limit 1 18/08/2025 21:40:26.5918 26308 ms. OPEN: show columns from tabParameters where Field = 'parAllowNegativePlaces' (WAIT TIME 12 ms.) 18/08/2025 21:40:34.3980 6176 ms. EXECSCALAR: SELECT count(*) FROM payinventory WHERE invValue<>0 AND invType='' nr: 0 18/08/2025 21:40:35.5908 5360 ms. OPEN: SELECT * FROM movLinks INNER JOIN movTransit on traUID = mliTraUID WHERE mliRFIDCode = '458857785200327005031999' AND mliStatus='V' ORDER BY mliId DESC LIMIT 1 18/08/2025 21:40:35.5918 6010 ms. OPEN: SELECT * FROM movLinks INNER JOIN movTransit on traUID = mliTraUID WHERE mliRFIDCode = '0240526590393' AND mliStatus='V' ORDER BY mliId DESC LIMIT 1 18/08/2025 21:40:38.8819 1797 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,'2025-08-18 21.40.37','V',4881264985282820,2025,'2025-08-18 21.37.32','458857785200327005031999',1,2,16,'I','',1,0,1,'','',4) 18/08/2025 21:40:38.8819 1907 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,'2025-08-18 21.40.36','V',5749090499096710,2025,'2025-08-18 21.36.49','458857526000327002029999',2,1,2,'O','',1,0,1,'','1301662673337',203,0) 18/08/2025 21:40:39.9486 5278 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 18/08/2025 21:40:40.9012 2005 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 18/08/2025 21:40:40.9022 2004 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 18/08/2025 21:40:43.8961 3947 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); 18/08/2025 21:40:44.7367 1890 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 = '458857517900327005012999' AND traStatus='V' AND payStatus='V' and (terType IS NULL OR terType<>3 OR (terType=3 and payType='P')) 18/08/2025 21:41:08.3330 736 ms. EXEC: insert into payReceipt (recTraUID,recPayUID,recYear,recDateTime,recText,recInvalid) VALUES (5295525633852310,5516151632419080,2025,'2025-08-18 21.41.07',' Date: 18/08/2025 21.41.07 Code: 458857517900327005012999 Entry Date: 18/08/2025 20.52.59 Plate: Class: Cars Park: The Mall Gate: Entry 2 ______________________________ Total: 50.00 KES ______________________________ Paid: 50.00 KES __________ Change: 0.00 KES Type: Cash Dispozitiv: MPESA # 2500730571 ',0) 18/08/2025 21:41:52.8922 31695 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 = 1 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 18/08/2025 21:43:24.7294 641 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 = 1 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 18/08/2025 21:58:34.0632 2181 ms. OPEN: select traId,traDateTime,traEnabled,traDisableTime,traCode,traBadge,traCarId,traAreId,traIdTerminal from movtransit where traStatus='V' and traDirection = 'I' and traCarId = 13 order by traDateTime desc,traId desc 18/08/2025 22:04:57.6788 726 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2025-08-18 22.04.56',3,42101,0,50,-1,-50,1,'O','N'); update payCurInventory set curQuantity=round(curQuantity+-1,5),curAmount=round(curAmount+-50,5) where curTerId = 3 and curDevCode = 42101 and curChannelId = 1 and curValue = 50 and curType = 'N'; 18/08/2025 22:27:50.8286 25485 ms. OPEN: select * from tablanguages where lanStatus='V' order by lannumber limit 1 18/08/2025 22:27:50.9156 25459 ms. OPEN: show columns from tabParameters where Field = 'parAllowNegativePlaces' (WAIT TIME 86 ms.) 18/08/2025 22:27:51.8812 846 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 18/08/2025 22:27:52.4055 969 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 1 and terStatus='V' 18/08/2025 22:27:52.6586 1590 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 18/08/2025 22:27:52.6586 1606 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 18/08/2025 22:27:52.6586 1622 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 18/08/2025 22:27:52.6596 1610 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 18/08/2025 22:27:52.6596 1593 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 18/08/2025 22:27:52.6606 1278 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 3 18/08/2025 22:27:52.8337 749 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 1 and terStatus='V' 18/08/2025 22:27:53.0488 1701 ms. EXEC: CREATE TABLE IF NOT EXISTS tabTimeZones(timId int(11) not null auto_increment,timCreation DATETIME not null default '0000-00-00',timModify TIMESTAMP not null,timUseId int(11) not null default 0,timStatus varchar(1) not null default 'V',timRegion varchar(5) not null default '',timIdWindows varchar(100) not null default '',timIdLinux varchar(100) not null default '', PRIMARY KEY (timId)) ENGINE=InnoDB DEFAULT CHARSET=utf8; 18/08/2025 22:27:53.0488 1702 ms. EXEC: CREATE TABLE IF NOT EXISTS tabTimeZones(timId int(11) not null auto_increment,timCreation DATETIME not null default '0000-00-00',timModify TIMESTAMP not null,timUseId int(11) not null default 0,timStatus varchar(1) not null default 'V',timRegion varchar(5) not null default '',timIdWindows varchar(100) not null default '',timIdLinux varchar(100) not null default '', PRIMARY KEY (timId)) ENGINE=InnoDB DEFAULT CHARSET=utf8; 18/08/2025 22:27:53.0498 1704 ms. EXEC: CREATE TABLE IF NOT EXISTS tabTimeZones(timId int(11) not null auto_increment,timCreation DATETIME not null default '0000-00-00',timModify TIMESTAMP not null,timUseId int(11) not null default 0,timStatus varchar(1) not null default 'V',timRegion varchar(5) not null default '',timIdWindows varchar(100) not null default '',timIdLinux varchar(100) not null default '', PRIMARY KEY (timId)) ENGINE=InnoDB DEFAULT CHARSET=utf8; 18/08/2025 22:27:53.2189 1505 ms. EXEC: update tabTerminal set terVersion = 'Parking_project V.1.6.2 (BETA 44) Jul 25 2017 12:08:13.31061.20170725082637' where terId = 3 18/08/2025 22:27:53.5391 808 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 18/08/2025 22:27:53.5411 833 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 2 OR lnsTerId=2) 18/08/2025 22:27:53.5421 2101 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 = 0))) order by tagName 18/08/2025 22:27:53.5471 888 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 2 OR lnsTerId=2) 18/08/2025 22:27:53.5871 1881 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 16 OR lnsTerId=16) 18/08/2025 22:27:53.9403 656 ms. EXECSCALAR: select count(resId) as Tot from movReservation where resStatus = 'V' and resTypeRes = 'B' AND ((resConfirmed IN (0,2,3) AND resCreation>'2025-08-18 21.27.53') OR resConfirmed IN (4,5)) and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) <= '2025-08-18 22.27.51' and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) >= '2025-08-18 22.27.51' and (resAreId = 1 or resAreId <= 0) nr: 0 (WAIT TIME 24 ms.) 18/08/2025 22:27:53.9514 641 ms. EXECSCALAR: select count(resId) as Tot from movReservation where resStatus = 'V' and resTypeRes = 'B' AND ((resConfirmed IN (0,2,3) AND resCreation>'2025-08-18 21.27.53') OR resConfirmed IN (4,5)) and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) <= '2025-08-18 22.27.52' and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) >= '2025-08-18 22.27.52' and (resAreId = 1 or resAreId <= 0) nr: 0 (WAIT TIME 35 ms.) 18/08/2025 22:27:53.9534 689 ms. EXECSCALAR: select count(resId) as Tot from movReservation where resStatus = 'V' and resTypeRes = 'B' AND ((resConfirmed IN (0,2,3) AND resCreation>'2025-08-18 21.27.53') OR resConfirmed IN (4,5)) and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) <= '2025-08-18 22.27.52' and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) >= '2025-08-18 22.27.52' and (resAreId = 1 or resAreId <= 0) nr: 0 (WAIT TIME 36 ms.) 18/08/2025 22:27:57.0231 5580 ms. EXECSCALAR: SELECT count(*) FROM payinventory WHERE invValue<>0 AND invType='' nr: 0 18/08/2025 22:28:02.3338 5307 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 18/08/2025 22:28:04.5786 2244 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); 18/08/2025 22:32:48.7263 1741 ms. OPEN: SELECT traCode FROM movTransit WHERE traId = '1003710' and traDirection='I' order by traId DESC LIMIT 1 18/08/2025 22:32:50.0390 677 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 = '458858006500327005012999' AND traStatus='V' AND payStatus='V' and (terType IS NULL OR terType<>3 OR (terType=3 and payType='P')) 18/08/2025 22:43:33.1223 18776 ms. OPEN: select * from tablanguages where lanStatus='V' order by lannumber limit 1 18/08/2025 22:43:33.1293 18723 ms. OPEN: show columns from tabParameters where Field = 'parAllowNegativePlaces' (WAIT TIME 6 ms.) 18/08/2025 22:43:33.7167 517 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 3 18/08/2025 22:43:33.7307 538 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 5 18/08/2025 22:43:33.7307 532 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 1 18/08/2025 22:43:33.7317 537 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 2 18/08/2025 22:43:33.7327 540 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 1 18/08/2025 22:43:33.7337 540 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 5 18/08/2025 22:43:33.7347 538 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 2 18/08/2025 22:43:33.7357 542 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 3 18/08/2025 22:43:33.7357 542 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 2 18/08/2025 22:43:33.7367 542 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 1 18/08/2025 22:43:33.7367 544 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 2 18/08/2025 22:43:33.7377 543 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 3 18/08/2025 22:43:33.7387 508 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 5 18/08/2025 22:43:33.7397 543 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 2 18/08/2025 22:43:33.7407 547 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 5 18/08/2025 22:43:33.7427 545 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 1 18/08/2025 22:43:33.7427 550 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 3 18/08/2025 22:43:33.7437 547 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 1 18/08/2025 22:43:33.7457 551 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 5 18/08/2025 22:43:41.7983 7471 ms. EXECSCALAR: SELECT count(*) FROM payinventory WHERE invValue<>0 AND invType='' nr: 0 18/08/2025 22:43:43.8325 6455 ms. OPEN: SELECT * FROM movLinks INNER JOIN movTransit on traUID = mliTraUID WHERE mliRFIDCode = '458858172200327005031999' AND mliStatus='V' ORDER BY mliId DESC LIMIT 1 18/08/2025 22:43:45.3524 603 ms. OPEN: select * from tabUserMessage where useMesDescr = 'err_ticketnotfound' and (useLanCode = 'en-US' or mid(useLanCode,1,2) = 'en') 18/08/2025 22:43:47.1464 5224 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 18/08/2025 22:43:47.5426 1591 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,'2025-08-18 22.43.45','V',5161279954081000,2025,'2025-08-18 22.42.02','458858172200327005031999',1,2,16,'I','',1,0,1,'','',4) 18/08/2025 22:43:48.8183 1264 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 18/08/2025 22:43:49.6978 2551 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); 18/08/2025 22:54:22.9994 38261 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 = 1 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 18/08/2025 23:03:50.2845 2062 ms. OPEN: select traId,traDateTime,traEnabled,traDisableTime,traCode,traBadge,traCarId,traAreId,traIdTerminal from movtransit where traStatus='V' and traDirection = 'I' and traCarId = 13 order by traDateTime desc,traId desc