07/05/2025 14:05:37.7625 32864 ms. OPEN: show columns from tabParameters where Field = 'parAllowNegativePlaces' 07/05/2025 14:05:39.5757 573 ms. EXECSCALAR: select count(*) from information_schema.tables where table_schema= 'wisepark_0327' and table_name= 'tabTerminalExtraMem' nr: 1 07/05/2025 14:05:39.6637 700 ms. OPEN: show columns from abbCards where Field = 'carUHFCode' 07/05/2025 14:05:40.5981 932 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 07/05/2025 14:05:45.9972 7098 ms. EXECSCALAR: SELECT count(*) FROM payinventory WHERE invValue<>0 AND invType='' nr: 0 07/05/2025 14:05:48.5721 6268 ms. OPEN: SELECT * FROM movLinks INNER JOIN movTransit on traUID = mliTraUID WHERE mliRFIDCode = '457824939800327005031999' AND mliStatus='V' ORDER BY mliId DESC LIMIT 1 07/05/2025 14:05:48.5721 9478 ms. OPEN: SELECT * FROM movLinks INNER JOIN movTransit on traUID = mliTraUID WHERE mliRFIDCode = '457823867800327005031999' AND mliStatus='V' ORDER BY mliId DESC LIMIT 1 07/05/2025 14:05:48.5741 7855 ms. OPEN: SELECT * FROM movLinks INNER JOIN movTransit on traUID = mliTraUID WHERE mliRFIDCode = '0098788191894' AND mliStatus='V' ORDER BY mliId DESC LIMIT 1 07/05/2025 14:05:48.7111 1815 ms. OPEN: select traCode from movTransit where traCode ='457825074500327005012999' 07/05/2025 14:05:50.1123 1090 ms. OPEN: select * from movTransit where traStatus='V' and traCode = '0098788191894' and traDirection='I' order by traId desc limit 1 07/05/2025 14:05:51.0237 900 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-05-07 14:05:50','V',5012425976927500,2025,'2025-05-07 13:42:00','0098788191894',2,1,2,'O','',1,0,1,'','',0) 07/05/2025 14:05:51.0237 1408 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-05-07 14:05:49','V',4995469955693200,2025,'2025-05-07 14:05:45','457825074500327005012999',1,2,16,'I','',1,0,1,'','',4) 07/05/2025 14:05:51.0247 1408 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-05-07 14:05:49','V',4611932975759130,2025,'2025-05-07 13:38:09','457823867800327005031999',3,2,16,'I','',1,0,1,'','',0) 07/05/2025 14:05:51.0297 1413 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-05-07 14:05:49','V',5741700051281750,2025,'2025-05-07 13:43:18','457824939800327005031999',1,2,16,'I','',1,0,1,'','',4) 07/05/2025 14:05:51.7662 5497 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 07/05/2025 14:05:52.2322 1197 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 07/05/2025 14:05:52.2332 1197 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 07/05/2025 14:05:52.2392 1204 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 07/05/2025 14:05:52.2432 1108 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 07/05/2025 14:05:54.2353 2468 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); 07/05/2025 14:05:54.8364 2493 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 = '457823867800327005031999' AND traStatus='V' AND payStatus='V' and (terType IS NULL OR terType<>3 OR (terType=3 and payType='P')) 07/05/2025 14:05:54.8484 2575 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 = '457825074500327005012999' AND traStatus='V' AND payStatus='V' and (terType IS NULL OR terType<>3 OR (terType=3 and payType='P')) 07/05/2025 14:05:57.2320 1130 ms. EXEC: insert into movOperator (opeCreation,opeTerId,opeUseId,opeDateTime,opeCode,opeDescription) VALUES ('2025-05-07 14:05:56',4,9,'2025-05-07 14:05:56','457823867800327005031999','Payed (Cash ) Ticket ') 07/05/2025 14:05:58.9901 1503 ms. EXEC: insert into payReceipt (recTraUID,recPayUID,recYear,recDateTime,recText,recInvalid) VALUES (4611932975759130,5521416138969840,2025,'2025-05-07 14:05:57',' Date: 5/7/2025 1:38:09 PM Code: 457823867800327005031999 Entry Date: 5/7/2025 1:38:09 PM Plate: Class: Cars Park: The Mall Gate: Entry 2 ______________________________ Total: 0.00 KES ______________________________ Paid: 0.00 KES __________ Change: 0.00 KES Type: Cash Dispozitiv: Manual Cashier 1 ',1) 07/05/2025 14:34:37.1619 1320 ms. OPEN: select traId,traDateTime,traEnabled,traDisableTime,traCode,traBadge,traCarId,traAreId,traIdTerminal from movtransit where traStatus='V' and traDirection = 'I' and traCarId = 9 order by traDateTime desc,traId desc 07/05/2025 14:39:29.1956 562 ms. OPEN: select traId,traDateTime,traEnabled,traDisableTime,traCode,traBadge,traCarId,traAreId,traIdTerminal from movtransit where traStatus='V' and traDirection = 'I' and traCarId = 183 order by traDateTime desc,traId desc 07/05/2025 14:57:40.7329 510 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 07/05/2025 15:08:34.0917 2253 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 07/05/2025 16:23:46.9497 1092 ms. OPEN: select traId,traDateTime,traEnabled,traDisableTime,traCode,traBadge,traCarId,traAreId,traIdTerminal from movtransit where traStatus='V' and traDirection = 'I' and traCarId = 103 order by traDateTime desc,traId desc 07/05/2025 16:26:10.1084 856 ms. OPEN: select traId,traDateTime,traEnabled,traDisableTime,traCode,traBadge,traCarId,traAreId,traIdTerminal from movtransit where traStatus='V' and traDirection = 'I' and traCarId = 41 order by traDateTime desc,traId desc 07/05/2025 16:43:17.4707 1705 ms. OPEN: select traId,traDateTime,traEnabled,traDisableTime,traCode,traBadge,traCarId,traAreId,traIdTerminal from movtransit where traStatus='V' and traDirection = 'I' and traCarId = 30 order by traDateTime desc,traId desc 07/05/2025 16:45:47.0498 1629 ms. OPEN: select traId,traDateTime,traEnabled,traDisableTime,traCode,traBadge,traCarId,traAreId,traIdTerminal from movtransit where traStatus='V' and traDirection = 'I' and traCarId = 8 order by traDateTime desc,traId desc 07/05/2025 16:45:47.7423 563 ms. EXECSCALAR: select traId from movTransit where traId>921573 and traIdTerminal = 2 and traDirection = 'O' and traCarId = 8 order by traId desc nr: 922057 07/05/2025 16:53:32.8629 615 ms. OPEN: select traId,traDateTime,traEnabled,traDisableTime,traCode,traBadge,traCarId,traAreId,traIdTerminal from movtransit where traStatus='V' and traDirection = 'I' and traCarId = 111 order by traDateTime desc,traId desc 07/05/2025 17:19:45.9472 908 ms. OPEN: select traId,traDateTime,traEnabled,traDisableTime,traCode,traBadge,traCarId,traAreId,traIdTerminal from movtransit where traStatus='V' and traDirection = 'I' and traCarId = 26 order by traDateTime desc,traId desc 07/05/2025 17:38:52.6926 552 ms. OPEN: select traId,traDateTime,traEnabled,traDisableTime,traCode,traBadge,traCarId,traAreId,traIdTerminal from movtransit where traStatus='V' and traDirection = 'I' and traCarId = 31 order by traDateTime desc,traId desc 07/05/2025 17:43:04.5341 13343 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 = 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)) order by traUIDGroup,payAmount, traType, traDiscountValue, traDiscountType 07/05/2025 18:07:08.7910 623 ms. OPEN: select traId,traDateTime,traEnabled,traDisableTime,traCode,traBadge,traCarId,traAreId,traIdTerminal from movtransit where traStatus='V' and traDirection = 'I' and traCarId = 19 order by traDateTime desc,traId desc 07/05/2025 18:12:56.7359 688 ms. OPEN: select traId,traDateTime,traEnabled,traDisableTime,traCode,traBadge,traCarId,traAreId,traIdTerminal from movtransit where traStatus='V' and traDirection = 'I' and traCarId = 11 order by traDateTime desc,traId desc 07/05/2025 18:21:50.1996 1279 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 07/05/2025 18:22:40.1735 845 ms. OPEN: select traId,traDateTime,traEnabled,traDisableTime,traCode,traBadge,traCarId,traAreId,traIdTerminal from movtransit where traStatus='V' and traDirection = 'I' and traCarId = 25 order by traDateTime desc,traId desc 07/05/2025 18:23:49.7449 1646 ms. OPEN: select traId,traDateTime,traEnabled,traDisableTime,traCode,traBadge,traCarId,traAreId,traIdTerminal from movtransit where traStatus='V' and traDirection = 'I' and traCarId = 44 order by traDateTime desc,traId desc 07/05/2025 18:33:42.2836 952 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 = '457820076400327005029999' and traStatus='V' and casStatus='V' and terType=3 and casTotAmount>0 07/05/2025 18:33:42.9040 594 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 = '457820076400327005029999' AND traStatus='V' AND payStatus='V' and (terType IS NULL OR terType<>3 OR (terType=3 and payType='P')) 07/05/2025 20:00:56.8024 804 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 07/05/2025 21:46:24.6504 2573 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 07/05/2025 21:46:41.1505 6237 ms. OPEN: SELECT COUNT(traId) as Total,terId,terDescription FROM movTransit INNER JOIN tabterminal on traIdTerminal = terId AND terType IN (1,3,19,4) LEFT JOIN payPayment on payTrauid = traUID WHERE traCreation>'2022-08-24 13:51:00' AND traStatus='V' and traDirection='I' AND payTraUID IS NULL GROUP BY traIdTerminal