26/03/2025 07:24:04.2549 596 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2025-03-26 07:24:03' where traUID = 5171317688912350 and traStatus='V' and traEnabled=1 26/03/2025 07:26:58.2915 2029 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/03/2025 07:48:35.7117 721 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/03/2025 07:48:36.5973 504 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 26/03/2025 07:49:01.7091 545 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/03/2025 07:49:27.3983 994 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/03/2025 07:53:56.3621 2629 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 26/03/2025 07:53:59.6153 2376 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 26/03/2025 07:54:10.1514 1147 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 (WAIT TIME 125 ms.) 26/03/2025 07:55:28.6138 606 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 26/03/2025 07:55:53.7827 640 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-03-26 07:55:53','V',5057485650072460,2025,'2025-03-26 07:55:51','457402677600327005012999',2,2,2,'O','',0,'2025-03-26 07:55:53',1,'','',0) 26/03/2025 07:56:08.5956 878 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 26/03/2025 07:57:03.5264 528 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 1 and terStatus='V' 26/03/2025 08:04:04.5288 612 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 26/03/2025 08:06:50.3567 974 ms. OPEN: select * from tabArea where areStatus='V' and areEnabled = 1 AND areId = 1 26/03/2025 08:07:13.2730 677 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/03/2025 08:22:30.1755 733 ms. EXEC: insert into payPayment (payCreation,payUseId,payStatus,payUID,payTraUID,payYear,payDateTime,payIdTerminal,payEnabled,payDisableTime,payTarId,payTimeLimit,payType,payCurrency,payAmount,payPayed,payChange,payCardType,payPAN,paySTAN,payIdEvent,payAmountCalc,payDiscountValue,payDiscount,payDiscountType,payVatPercent,payVatAmount) VALUES ('2025-03-26 08:20:44',12,'V',5360081453277880,5642624563457550,2025,'2025-03-26 08:20:44',4,1,0,4,'2025-03-26 08:35:44','P','KES',50,50,0,'','','',1,50,0,0,'',0,0) 26/03/2025 08:23:59.8885 72159 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 26/03/2025 08:24:29.5393 768 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-03-26 08:24:28','V',4625507560993000,2025,'2025-03-26 08:24:28','457402913300327005012999',2,2,2,'O','',0,'2025-03-26 08:24:28',1,'','',0) 26/03/2025 08:24:35.7905 3388 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 26/03/2025 08:34:00.9756 1039 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-03-26 08:33:59','V',4867989753669870,2025,'2025-03-26 08:33:58','457402838400327005012999',2,2,2,'O','',0,'2025-03-26 08:33:59',1,'','',0) 26/03/2025 08:34:08.0213 884 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 26/03/2025 08:35:40.2440 1545 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/03/2025 08:36:23.4199 1432 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-03-26 08:36:21','V',5668173696195240,2025,'2025-03-26 08:36:19','457403097900327005012999',1,2,16,'I','',1,0,1,'','0230004100121',147,0) 26/03/2025 08:47:30.4339 767 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 26/03/2025 08:50:11.4888 641 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/03/2025 08:52:09.8862 569 ms. EXEC: insert into payPayment (payCreation,payUseId,payStatus,payUID,payTraUID,payYear,payDateTime,payIdTerminal,payEnabled,payDisableTime,payTarId,payTimeLimit,payType,payCurrency,payAmount,payPayed,payChange,payCardType,payPAN,paySTAN,payIdEvent,payAmountCalc,payDiscountValue,payDiscount,payDiscountType,payVatPercent,payVatAmount) VALUES ('2025-03-26 08:52:09',0,'V',5350489862302360,4824658230906960,2025,'2025-03-26 08:52:09',18,1,0,4,'2025-03-26 09:07:09','C','KES',50,50,0,'','','',1,50,0,0,'',0,0) 26/03/2025 08:54:05.8688 822 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-03-26 08:54:05','V',5050028880207750,2025,'2025-03-26 08:54:04','457403131100327005012999',2,2,2,'O','',0,'2025-03-26 08:54:05',1,'','',0) 26/03/2025 08:54:06.6223 506 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 26/03/2025 08:58:10.2908 544 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/03/2025 09:00:13.0161 1282 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/03/2025 09:00:27.2726 989 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 26/03/2025 09:01:53.8136 674 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-03-26 09:01:53','V',5301926530425930,2025,'2025-03-26 09:01:52','457403251200327005012999',1,2,16,'I','',1,0,1,'','0230004100099',144,0) 26/03/2025 09:01:54.6591 650 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 26/03/2025 09:02:06.8663 2195 ms. EXEC: INSERT INTO movOperator (opeCreation,opeUseId,opeTerId,opeDateTime,opeCode,opeDescription) VALUES ('2025-03-26 09:02:04',0,16,'2025-03-26 09:02:04','','Unauthorized Transit Entry 2') 26/03/2025 09:04:31.3170 2520 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/03/2025 09:04:44.5939 1984 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 26/03/2025 09:04:57.4605 1627 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 16 OR lnsTerId=16) 26/03/2025 09:05:50.3489 621 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 16 OR lnsTerId=16) 26/03/2025 09:06:02.9733 537 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/03/2025 09:09:13.4009 701 ms. EXEC: insert into payPayment (payCreation,payUseId,payStatus,payUID,payTraUID,payYear,payDateTime,payIdTerminal,payEnabled,payDisableTime,payTarId,payTimeLimit,payType,payCurrency,payAmount,payPayed,payChange,payCardType,payPAN,paySTAN,payIdEvent,payAmountCalc,payDiscountValue,payDiscount,payDiscountType,payVatPercent,payVatAmount) VALUES ('2025-03-26 09:07:28',12,'V',5269348817096450,5511706468723360,2025,'2025-03-26 09:07:28',4,1,0,4,'2025-03-26 09:22:28','P','KES',100,100,0,'','','',1,100,0,0,'',0,0) 26/03/2025 09:09:35.3276 813 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/03/2025 09:09:41.7879 689 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/03/2025 09:10:20.0045 1579 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/03/2025 09:10:28.1609 508 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/03/2025 09:10:59.8171 885 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-03-26 09:10:58','V',5232845190420930,2025,'2025-03-26 09:10:58','457403305800327005012999',1,2,16,'I','',1,0,1,'','',4) 26/03/2025 09:15:52.8324 565 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2025-03-26 09:15:51' where traUID = 4724287640185650 and traStatus='V' and traEnabled=1 26/03/2025 09:16:50.0678 1136 ms. EXEC: insert into payReceipt (recTraUID,recPayUID,recYear,recDateTime,recText,recInvalid) VALUES (5124774675265590,4846056485039460,2025,'2025-03-26 09:16:48','---------------------------------- %The Mall P0006032390 End of payment ---------------------------------- POF Entry : 3/26/2025 8:51:32 AM Date : 3/26/2025 9:16:48 AM Code : 457403189200327001012999 Total : 50.00 KES VAT 16% : 6.90 KES ---------------------------------- Paid : 50.00 KES Coin changed : 0.00 KES Note changed : 0.00 KES',0) 26/03/2025 09:17:52.1624 958 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-03-26 09:17:51','V',4816570590054330,2025,'2025-03-26 09:17:50','457403189200327001012999',2,2,2,'O','',0,'2025-03-26 09:17:51',1,'','',0) 26/03/2025 09:18:04.9460 510 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/03/2025 09:18:04.9500 647 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 2 OR lnsTerId=2) 26/03/2025 09:28:17.5214 604 ms. EXECSCALAR: select count(*) from tabTerminalExtraMem where extStatus='V' and extTerId = 16 nr: 1 26/03/2025 09:29:17.1633 546 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 5 and terStatus='V' 26/03/2025 09:31:38.9451 4364 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 26/03/2025 09:31:44.9121 895 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 26/03/2025 09:31:59.8841 14842 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 26/03/2025 11:05:03.8205 505 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-03-26 11:05:03','V',5563815084213540,2025,'2025-03-26 11:05:03','457403990300327005012999',1,2,16,'I','',1,0,1,'','',4) 26/03/2025 11:53:50.1763 622 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 26/03/2025 15:34:04.9627 9451 ms. EXEC: update abbSubscriptions set subCredit = round(subCredit-0,5),subLastDebit = '2025-03-26 15:33:55' where subId = 14 26/03/2025 15:34:09.7149 4575 ms. OPEN: select * from tmppay where tmpcode = '457405275500327001012999' 26/03/2025 15:34:14.5351 4755 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 2 26/03/2025 15:34:40.6255 26088 ms. OPEN: select * from movTransit where traStatus = 'V' and traCode='457405275500327001012999' and traBadge = '0230003944059' order by traId desc limit 1 26/03/2025 15:34:48.9621 7999 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2025-03-26 15:34:40' where traUID = 5573069170601420 and traStatus='V' and traEnabled=1 26/03/2025 15:34:53.6502 4407 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 4 OR lnsTerId=4) 26/03/2025 15:34:58.4014 4523 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-03-26 15:34:53','V',4742955738051840,2025,'2025-03-26 15:34:05','457405354300327002029999',2,1,2,'O','',1,0,1,'','0532370677371',13,0) 26/03/2025 15:35:07.9298 4695 ms. OPEN: SELECT * FROM tabuser WHERE useBadId<>'' AND (useBadId = '457405404100327005012999' OR useBadId = '457405404100327005012999') 26/03/2025 15:35:22.1503 4659 ms. OPEN: SELECT * FROM tabterminal LEFT JOIN movtransit ON movtransit.traIdTerminal = tabterminal.terId LEFT JOIN tabtariff ON tabtariff.tarId = movtransit.traTarId LEFT JOIN tabterminalinout ON tabterminalinout.tioin = tabterminal.terId WHERE tabterminal.terStatus ='V' AND tabterminalinout.tioOut = 2 AND movtransit.traStatus ='V' AND tabterminal.terDirection = 'I' AND movtransit.traCode = '457405404100327005012999' 26/03/2025 15:36:23.9537 16626 ms. OPEN: show columns from tabParameters where Field = 'parAllowNegativePlaces' 26/03/2025 15:36:25.7579 1789 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 26/03/2025 17:05:34.4983 808 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 26/03/2025 17:14:17.8261 533 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 26/03/2025 17:16:05.3775 572 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2025-03-26 17:16:04' where payTraUID = 5349561671058460 and payStatus='V' and payEnabled=1 26/03/2025 17:20:10.2372 1634 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 26/03/2025 17:31:58.8821 5011 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/03/2025 17:33:08.9440 4677 ms. OPEN: select * from tabcustomer inner join abbsubscriptions on subCusId = cusId inner join abbcards on subId = carSubId where carId = 181 26/03/2025 17:33:13.6951 4554 ms. OPEN: select * from movtransit where trastatus='V' and traCarId = 181 order by traId desc limit 1 26/03/2025 17:33:18.4443 4671 ms. OPEN: select * from tabCustomer inner join abbSubscriptions on subCusId = cusId left join tabAbbGroups on cusAbgId = abgId where subId = 196 and cusStatus='V' 26/03/2025 17:33:23.1935 4673 ms. EXEC: insert into payPayment (payCreation,payUseId,payStatus,payUID,payTraUID,payYear,payDateTime,payIdTerminal,payEnabled,payDisableTime,payTarId,payTimeLimit,payType,payCurrency,payAmount,payPayed,payChange,payCardType,payPAN,paySTAN,payIdEvent,payVatPercent,payVatAmount) VALUES ('2025-03-26 17:33:18',0,'V',5189489776673970,4718209950895160,2025,'2025-03-26 17:33:18',2,1,0,-1,'2025-03-26 18:33:18','S','KES',0,0,0,'','','',3,0,0) 26/03/2025 17:33:23.3136 4699 ms. EXECSCALAR: select count(*) from tabTerminalExtraMem where extStatus='V' and extTerId = 2 nr: 1 (WAIT TIME 82 ms.) 26/03/2025 17:33:47.0424 18900 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 (WAIT TIME 41 ms.) 26/03/2025 17:33:47.8860 841 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 26/03/2025 17:33:56.4417 8430 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2025-03-26 17:33:47' where payTraUID = 4718209950895160 and payStatus='V' and payEnabled=1 26/03/2025 17:33:57.7906 789 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/03/2025 17:33:58.8203 8732 ms. OPEN: show columns from tabParameters where Field = 'parAllowNegativePlaces' 26/03/2025 17:34:00.0321 1202 ms. OPEN: show columns from tabArea where Field = 'areType' 26/03/2025 17:34:00.1602 1459 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/03/2025 17:34:03.2103 3068 ms. EXECSCALAR: SELECT count(*) FROM payinventory WHERE invValue<>0 AND invType='' nr: 0 26/03/2025 17:34:04.1799 967 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 26/03/2025 17:36:05.2269 4523 ms. EXEC: insert into payReceipt (recTraUID,recPayUID,recYear,recDateTime,recText,recInvalid) VALUES (4653999157146770,4736922364367180,2025,'2025-03-26 17:36:00',' Date: 3/26/2025 5:33:52 PM Code: 457406192200327001012999 Entry Date: 3/26/2025 5:12:02 PM Plate: Class: Cars Park: The Mall Gate: Entry 1 ______________________________ Total: 50.00 KES ______________________________ Paid: 50.00 KES __________ Change: 0.00 KES Type: Credit Card Dispozitiv: Manual Cashier 1 # 2500403742 ',0) 26/03/2025 17:36:14.7262 1681 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/03/2025 17:37:07.3364 828 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/03/2025 17:37:12.1116 1572 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/03/2025 17:37:16.8388 4538 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 1 26/03/2025 17:37:54.5480 2260 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 2 OR lnsTerId=2) 26/03/2025 17:38:23.0671 2062 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/03/2025 17:38:37.2946 4372 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 26/03/2025 17:38:46.7919 4005 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 26/03/2025 17:39:10.5228 4458 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 26/03/2025 17:40:02.7718 4691 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-03-26 17:39:58','V',5002115778674470,2025,'2025-03-26 17:39:53','457406359300327005012999',1,2,16,'I','',1,0,1,'','',4) 26/03/2025 17:40:12.3031 2018 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 26/03/2025 17:40:36.0370 4716 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-03-26 17:40:31','V',5617988282101510,2025,'2025-03-26 17:40:09','457406360900327005031999',1,2,16,'I','',1,0,1,'','',4) 26/03/2025 17:40:59.4257 4798 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/03/2025 17:41:20.4777 1099 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/03/2025 17:41:48.9798 858 ms. OPEN: SELECT * FROM movTransit WHERE traStatus=@traStatus AND traCode=@traCode AND traDirection=@traDirection ORDER BY traDateTime,traId 26/03/2025 17:41:53.7640 3378 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/03/2025 17:42:07.9975 4689 ms. OPEN: select * from movExtraRules where exrTraId in (select traId from movtransit where traCode = '457405346400327005012999') 26/03/2025 17:42:17.4859 2561 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/03/2025 17:43:40.5297 1001 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 26/03/2025 18:05:24.6690 1615 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 26/03/2025 18:11:10.9456 758 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 26/03/2025 18:20:40.2257 508 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 26/03/2025 20:15:43.1057 5767 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1