30/05/2025 11:16:25.3967 651 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 30/05/2025 11:33:52.9592 570 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2025-05-30 11:33:52' where payTraUID = 5738762551044670 and payStatus='V' and payEnabled=1 30/05/2025 12:43:35.2564 15968 ms. OPEN: select * from tablanguages where lanStatus='V' order by lannumber limit 1 30/05/2025 12:43:35.2564 15969 ms. OPEN: show columns from tabParameters where Field = 'parAllowNegativePlaces' (WAIT TIME 4 ms.) 30/05/2025 12:43:35.2664 15968 ms. OPEN: select * from tablanguages where lanStatus='V' order by lannumber limit 1 30/05/2025 12:43:37.6870 1231 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 30/05/2025 12:43:44.9364 6923 ms. OPEN: SELECT * FROM movLinks INNER JOIN movTransit on traUID = mliTraUID WHERE mliRFIDCode = '0098788191894' AND mliStatus='V' ORDER BY mliId DESC LIMIT 1 30/05/2025 12:43:44.9364 5894 ms. OPEN: SELECT * FROM movLinks INNER JOIN movTransit on traUID = mliTraUID WHERE mliRFIDCode = '458054536400327001031999' AND mliStatus='V' ORDER BY mliId DESC LIMIT 1 30/05/2025 12:43:44.9904 5556 ms. OPEN: SELECT * FROM movLinks INNER JOIN movTransit on traUID = mliTraUID WHERE mliRFIDCode = '458054540900327005031999' AND mliStatus='V' ORDER BY mliId DESC LIMIT 1 30/05/2025 12:43:46.7696 10075 ms. EXECSCALAR: SELECT count(*) FROM payinventory WHERE invValue<>0 AND invType='' nr: 0 30/05/2025 12:43:48.3536 2826 ms. OPEN: select * from movTransit where traStatus='V' and traCode = '0098788191894' and traDirection='I' order by traId desc limit 1 30/05/2025 12:43:48.5578 2135 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-30 12.43.46','V',5681885679698030,2025,'2025-05-30 12.36.04','458054536400327001031999',1,2,1,'I','',1,0,1,'','',4) 30/05/2025 12:43:48.5578 2134 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-30 12.43.46','V',4618565323077670,2025,'2025-05-30 12.36.49','458054540900327005031999',1,2,16,'I','',1,0,1,'','',4) 30/05/2025 12:43:49.9977 1426 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 30/05/2025 12:43:50.0388 1393 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 30/05/2025 12:43:50.0398 1468 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 30/05/2025 12:43:51.5618 4520 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 30/05/2025 12:43:52.7285 1166 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); 30/05/2025 12:45:03.1632 923 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 = '458054590200327005012999' AND traStatus='V' AND payStatus='V' and (terType IS NULL OR terType<>3 OR (terType=3 and payType='P')) 30/05/2025 12:50:38.5569 2582 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 30/05/2025 12:55:49.7099 570 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 30/05/2025 13:30:11.8437 1488 ms. OPEN: select traId,traDateTime,traEnabled,traDisableTime,traCode,traBadge,traCarId,traAreId,traIdTerminal from movtransit where traStatus='V' and traDirection = 'I' and traCarId = 12 order by traDateTime desc,traId desc 30/05/2025 13:58:44.2529 1683 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 30/05/2025 14:01:28.2846 734 ms. OPEN: select traId,traDateTime,traEnabled,traDisableTime,traCode,traBadge,traCarId,traAreId,traIdTerminal from movtransit where traStatus='V' and traDirection = 'I' and traCarId = 99 order by traDateTime desc,traId desc 30/05/2025 14:04:17.2047 1925 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 30/05/2025 14:16:37.5191 13961 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 30/05/2025 14:34:58.5351 538 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-30 14.34.57','V',5020769070341150,2025,'2025-05-30 14.34.57','458055105000327001012999',2,2,2,'O','',0,'2025-05-30 14.34.57',1,'','',0) (WAIT TIME 8 ms.) 30/05/2025 15:16:43.1741 555 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2025-05-30 15.16.42' where payTraUID = 5557335994631870 and payStatus='V' and payEnabled=1 30/05/2025 15:16:43.6904 516 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2025-05-30 15.16.42' where traUID = 5557335994631870 and traStatus='V' and traEnabled=1 30/05/2025 16:09:07.4660 690 ms. EXEC: insert into paycash (casCreation,casModify,casUseId,casStatus,casUID,casTraUID,casYear,casDateTime,casIdTerminal,casCurrency,casNumber,casSingleAmount,casTotAmount,casType,casDescription) VALUES ('2025-05-30 16.09.06',0,0,'V',5573262078909390,5196332095825480,2025,'2025-05-30 16.09.06',3,'KES',-1,50,-50,'N',''); insert into paycash (casCreation,casModify,casUseId,casStatus,casUID,casTraUID,casYear,casDateTime,casIdTerminal,casCurrency,casNumber,casSingleAmount,casTotAmount,casType,casDescription) VALUES ('2025-05-30 16.09.06',0,0,'V',5573262078909390,5196332095825480,2025,'2025-05-30 16.09.06',3,'KES',-1,100,-100,'N',''); 30/05/2025 19:00:30.5619 1235 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 30/05/2025 19:46:19.2629 895 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-30 19:46:18','V',5109697170138870,2025,'2025-05-30 19:46:18','458057026500327005012999',2,2,2,'O','',0,'2025-05-30 19:46:18',1,'','',0)