14/02/2025 00:16:30.4718 533 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2025-02-14 00:16:29' where payTraUID = 5467239839600340 and payStatus='V' and payEnabled=1 14/02/2025 00:21:10.8324 589 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/02/2025 00:24:38.2990 1158 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 2 and terStatus='V' 14/02/2025 00:34:49.9715 1025 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/02/2025 00:37:15.6756 712 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 4 and terStatus='V' 14/02/2025 00:44:58.6241 573 ms. EXEC: insert into payReceipt (recTraUID,recPayUID,recYear,recDateTime,recText,recInvalid) VALUES (5323724373891640,5041195974235350,2025,'2025-02-14 00:44:58',' Date: 2/14/2025 12:44:57 AM Code: 456998612000327005012999 Entry Date: 2/13/2025 11:55:20 PM Plate: Class: Cars Park: The Mall Gate: Entry 2 ______________________________ Total: 100.00 KES ______________________________ Paid: 100.00 KES __________ Change: 0.00 KES Type: Cash Dispozitiv: MPESA # 2500706533 ',0) 14/02/2025 00:45:38.1827 531 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 14/02/2025 00:46:31.3105 689 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 16 OR lnsTerId=16) 14/02/2025 00:46:31.3235 697 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 3 OR lnsTerId=3) 14/02/2025 00:49:35.4504 1018 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/02/2025 01:06:39.6861 1998 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/02/2025 01:12:05.6684 754 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/02/2025 01:12:46.3768 1250 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/02/2025 01:13:35.7180 1010 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/02/2025 01:13:59.4240 557 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/02/2025 01:16:42.7869 2273 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/02/2025 01:17:16.7708 1390 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/02/2025 01:20:58.7131 649 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/02/2025 01:29:15.7720 743 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2025-02-14 01:29:15' where payTraUID = 4849342085380010 and payStatus='V' and payEnabled=1 14/02/2025 01:31:06.3094 1216 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/02/2025 01:33:40.8314 1625 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/02/2025 01:36:39.2945 2332 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/02/2025 01:38:11.0102 1677 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/02/2025 01:45:55.0867 915 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/02/2025 02:11:53.4760 646 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/02/2025 02:12:40.3976 978 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/02/2025 02:17:26.9184 1090 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/02/2025 02:23:35.1464 584 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/02/2025 02:25:08.2660 1749 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 1 OR lnsTerId=1) 14/02/2025 02:27:39.7800 557 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/02/2025 02:29:30.0061 742 ms. OPEN: select * from tabArea where areStatus='V' and areEnabled = 1 AND areId = 1 14/02/2025 02:55:27.7373 800 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/02/2025 02:57:39.6071 1749 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/02/2025 02:58:39.9457 559 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/02/2025 03:05:20.5342 1022 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 1 OR lnsTerId=1) 14/02/2025 03:10:54.3328 739 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/02/2025 03:11:41.8328 656 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/02/2025 03:11:49.5140 874 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/02/2025 03:17:37.4510 751 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/02/2025 03:18:41.4621 1089 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 3 OR lnsTerId=3) 14/02/2025 03:21:39.5129 1944 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 (WAIT TIME 45 ms.) 14/02/2025 03:29:45.8111 622 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 3 and terStatus='V' 14/02/2025 03:30:26.5725 2743 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/02/2025 03:38:18.3403 735 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 2 OR lnsTerId=2) 14/02/2025 03:47:14.1549 687 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/02/2025 03:49:55.4755 829 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/02/2025 03:50:44.0962 1264 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/02/2025 03:55:10.5415 1856 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/02/2025 04:02:51.8649 822 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/02/2025 04:02:54.5237 690 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/02/2025 04:14:27.9410 704 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 2 14/02/2025 04:17:47.7384 1969 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/02/2025 04:20:41.1241 1809 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/02/2025 04:42:07.2510 534 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 14/02/2025 04:46:12.8802 623 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/02/2025 04:48:29.7013 685 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/02/2025 04:49:48.3843 1159 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/02/2025 04:52:09.7834 551 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/02/2025 04:52:28.1608 529 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/02/2025 04:53:38.8994 1256 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/02/2025 04:58:56.7102 572 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 16 OR lnsTerId=16) 14/02/2025 05:08:55.7541 890 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/02/2025 05:11:19.9221 1379 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 1 OR lnsTerId=1) 14/02/2025 05:13:15.1456 3189 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/02/2025 05:17:16.6652 2972 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/02/2025 05:19:29.0082 2960 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 3 14/02/2025 05:36:37.2403 1224 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/02/2025 05:40:08.4504 1082 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/02/2025 05:41:51.2986 1016 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/02/2025 05:42:54.2370 543 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/02/2025 05:49:24.2504 1274 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/02/2025 05:49:33.0724 1219 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/02/2025 05:49:38.7642 2694 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/02/2025 05:49:44.8733 2866 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/02/2025 05:49:48.7779 1287 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/02/2025 05:49:57.5969 1345 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/02/2025 06:09:58.9363 609 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/02/2025 06:10:16.4160 711 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/02/2025 06:19:06.1374 912 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-02-14 06:19:05','V',5648017626393090,2025,'2025-02-14 06:19:04','457002274400327005012999',1,2,16,'I','',1,0,1,'','0230004098588',183,0) 14/02/2025 06:19:07.0640 685 ms. EXEC: update abbCards set carLastDate = '2025-02-14 06:19:06',carLastDirection='I' where carStatus='V' and carId = 183 14/02/2025 06:19:09.3416 655 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 14/02/2025 06:29:45.6616 577 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/02/2025 06:35:36.6408 1329 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/02/2025 06:41:01.0380 752 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2025-02-14 06:41:00' where traUID = 5270069219538280 and traStatus='V' and traEnabled=1 14/02/2025 06:45:06.2861 1619 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/02/2025 06:45:13.2237 3718 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/02/2025 06:45:26.2155 625 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/02/2025 06:47:53.0993 612 ms. EXEC: insert into movOperator (opeCreation,opeTerId,opeUseId,opeDateTime,opeCode,opeDescription) VALUES ('2025-02-14 06:47:52',4,9,'2025-02-14 06:47:52','457002301300327005012999','Payed (Credit Card ) Ticket ') 14/02/2025 06:49:57.7792 1003 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/02/2025 06:52:39.9681 744 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/02/2025 06:59:33.2222 1130 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/02/2025 07:00:56.0429 530 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2025-02-14 07:00:55' where traUID = 5560576164546200 and traStatus='V' and traEnabled=1 14/02/2025 07:04:28.4658 671 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/02/2025 07:04:32.3905 1247 ms. EXEC: INSERT INTO movOperator (opeCreation,opeUseId,opeTerId,opeDateTime,opeCode,opeDescription) VALUES ('2025-02-14 07:04:31',0,16,'2025-02-14 07:04:31','','Unauthorized Transit Entry 2') 14/02/2025 07:05:20.5499 1038 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-02-14 07:05:19',0,'V',4969564292082550,4673008504370690,2025,'2025-02-14 07:05:19',3,1,0,4,'2025-02-14 07:20:19','C','KES',50,100,50,'',' ',' ',1,50,0,0,'',0,0) 14/02/2025 07:06:38.4663 1949 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 5 14/02/2025 07:07:06.9054 735 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-02-14 07:07:06',0,'V',4871442971246410,4929504111168060,2025,'2025-02-14 07:07:06',18,1,0,4,'2025-02-14 07:22:06','C','KES',50,50,0,'','','',1,50,0,0,'',0,0) 14/02/2025 07:07:11.0232 4091 ms. EXEC: update tabTerminalReceipt set trcProgressive = 6543, trcLastPrinted = '2500706543', trcLastDate = '2025-02-14 07:07:06' where trcStatus='V' and trcTerId = 18 14/02/2025 07:07:11.5976 903 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-02-14 07:07:10','V',5483202492215360,2025,'2025-02-14 07:07:10','457002515500327005012999',2,2,2,'O','',0,'2025-02-14 07:07:10',1,'','',0) 14/02/2025 07:07:11.6306 604 ms. EXEC: insert into payReceipt (recTraUID,recPayUID,recYear,recDateTime,recText,recInvalid) VALUES (4929504111168060,4871442971246410,2025,'2025-02-14 07:07:11',' Date: 2/14/2025 7:07:06 AM Code: 457002513100327005012999 Entry Date: 2/14/2025 6:58:51 AM 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 # 2500706543 ',0) 14/02/2025 07:07:12.4412 763 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 14/02/2025 07:08:29.9954 1475 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-02-14 07:08:27',0,'V',5067800253786140,4755945520617210,2025,'2025-02-14 07:08:27',3,1,0,4,'2025-02-14 07:23:27','C','KES',50,100,50,'',' ',' ',1,50,0,0,'',0,0) 14/02/2025 07:08:31.5024 510 ms. EXEC: insert into movBarrier (barUseId,barCreation,barTerId,barAction,barDescription,barPlate) VALUES (1,'2025-02-14 07:08:30',9999,'open','Send command to entry/exit units: Command OPEN on Device Exit 1 ','') 14/02/2025 07:08:31.6255 569 ms. EXEC: insert into paycash (casCreation,casModify,casUseId,casStatus,casUID,casTraUID,casYear,casDateTime,casIdTerminal,casCurrency,casNumber,casSingleAmount,casTotAmount,casType,casDescription) VALUES ('2025-02-14 07:08:31',0,0,'V',5110510946364830,4755945520617210,2025,'2025-02-14 07:08:31',3,'KES',-1,50,-50,'N',''); 14/02/2025 07:09:17.6384 503 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2025-02-14 07:09:16',3,42101,0,50,1,50,1,'I','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'; 14/02/2025 07:14:04.2038 560 ms. EXECSCALAR: select count(0) as vTot from tabParameters where parPlateReading<>0 nr: 0 14/02/2025 07:23:04.6013 1032 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 2 OR lnsTerId=2) 14/02/2025 07:27:44.9920 631 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/02/2025 07:29:59.6636 904 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/02/2025 07:34:10.1021 1509 ms. EXEC: update tabTerminalReceipt set trcProgressive = 6544, trcLastPrinted = '2500706544', trcLastDate = '2025-02-14 07:34:08' where trcStatus='V' and trcTerId = 18 14/02/2025 07:35:08.7436 523 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 14/02/2025 07:35:18.3941 819 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 14/02/2025 07:36:40.1491 584 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/02/2025 07:45:36.9193 2810 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 14/02/2025 07:51:55.3284 2267 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-02-14 07:51:53','V',4967218150825840,2025,'2025-02-14 07:51:51','457002831100327005012999',1,2,16,'I','',1,0,1,'','',4) 14/02/2025 07:51:57.0686 1732 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 14/02/2025 07:52:11.1100 728 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 2 OR lnsTerId=2) 14/02/2025 07:56:17.5238 2857 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2025-02-14 07:56:14' where traUID = 5068760883326660 and traStatus='V' and traEnabled=1 14/02/2025 07:56:22.8124 602 ms. EXEC: UPDATE payInventory SET invType='N' WHERE invType<>'N' AND invValue IN (100,200,500) AND invDevice IN (42102,42101,42001); 14/02/2025 07:56:22.8484 614 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-02-14 07:56:20',0,'V',5701259921052930,5713396230441070,2025,'2025-02-14 07:56:20',3,1,0,4,'2025-02-14 08:11:20','C','KES',50,50,0,'',' ',' ',1,50,0,0,'',0,0) 14/02/2025 07:56:24.3544 1139 ms. EXEC: insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2025-02-14 07:56:23',3,42101,0,50,1,50,2,'I','N'); update payCurInventory set curQuantity=round(curQuantity+1,5),curAmount=round(curAmount+50,5) where curTerId = 3 and curDevCode = 42101 and curChannelId = 2 and curValue = 50 and curType = 'N'; 14/02/2025 07:57:53.9027 514 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/02/2025 07:59:34.6795 599 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/02/2025 08:00:27.6441 1136 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 5 and terStatus='V' 14/02/2025 08:00:55.1016 1243 ms. EXECSCALAR: select sum(parAllowNegativePlaces) from tabParameters where parStatus='V' order by parId desc limit 1 nr: 0 14/02/2025 08:00:55.2657 1334 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 14/02/2025 08:01:01.7411 668 ms. EXEC: INSERT INTO movOperator (opeCreation,opeUseId,opeTerId,opeDateTime,opeCode,opeDescription) VALUES ('2025-02-14 08:01:01',0,3,'2025-02-14 08:01:01','0230003944086','POF - User Transit Supervisor Supervisor') 14/02/2025 08:01:02.5466 640 ms. EXEC: INSERT INTO movOperator (opeCreation,opeUseId,opeTerId,opeDateTime,opeCode,opeDescription) VALUES ('2025-02-14 08:01:01',0,3,'2025-02-14 08:01:01','0230003944086','POF - User Transit Supervisor Supervisor') 14/02/2025 08:02:43.7287 885 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 14/02/2025 08:07:14.0282 577 ms. EXEC: UPDATE payInventory SET invType='N' WHERE invType<>'N' AND invValue IN (100,200,500) AND invDevice IN (42102,42101,42001); 14/02/2025 08:08:43.3093 557 ms. EXEC: insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2025-02-14 08:08:31',5,3,42101,0,50,-2,-100,1,'O','N'); insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2025-02-14 08:08:31',5,3,42101,0,50,2,100,2,'I','N'); insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2025-02-14 08:08:31',5,3,42101,0,100,-53,-5300,1,'O','N'); insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2025-02-14 08:08:31',5,3,42101,0,100,53,5300,2,'I','N'); insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2025-02-14 08:08:31',5,3,42101,0,200,-10,-2000,1,'O','N'); insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2025-02-14 08:08:31',5,3,42101,0,200,10,2000,2,'I','N'); insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2025-02-14 08:08:31',5,3,42101,0,500,-1,-500,1,'O','N'); insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2025-02-14 08:08:31',5,3,42101,0,500,1,500,2,'I','N'); insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2025-02-14 08:08:31',5,3,42101,0,1000,-1,-1000,1,'O','N'); insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2025-02-14 08:08:31',5,3,42101,0,1000,1,1000,2,'I','N'); insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2025-02-14 08:08:31',5,3,42101,1,0,0,0,1,'O',''); update payCurInventory set curQuantity=0,curAmount=0 where curQuantity<0; 14/02/2025 08:08:45.0665 934 ms. EXEC: insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2025-02-14 08:08:39',5,3,42101,0,50,-12,-600,2,'O','N'); insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2025-02-14 08:08:39',5,3,42101,0,100,-59,-5900,2,'O','N'); insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2025-02-14 08:08:39',5,3,42101,0,200,-12,-2400,2,'O','N'); insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2025-02-14 08:08:39',5,3,42101,0,500,-1,-500,2,'O','N'); insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2025-02-14 08:08:39',5,3,42101,0,1000,-1,-1000,2,'O','N'); insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2025-02-14 08:08:39',5,3,42101,1,0,0,0,2,'O',''); update payCurInventory set curQuantity=0,curAmount=0 where curQuantity<0; 14/02/2025 08:16:17.8465 542 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 14/02/2025 08:17:38.2616 823 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/02/2025 08:17:50.9261 924 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/02/2025 08:18:34.8097 2212 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/02/2025 08:19:56.7558 1851 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/02/2025 08:24:26.7635 868 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/02/2025 08:25:12.6934 673 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/02/2025 08:27:46.0296 812 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 3 14/02/2025 08:29:54.1698 532 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/02/2025 08:31:43.9787 1053 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/02/2025 08:32:39.6612 1239 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/02/2025 08:33:40.4241 1352 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/02/2025 08:34:17.6421 1044 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/02/2025 08:34:25.6485 822 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/02/2025 08:34:27.5858 745 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/02/2025 08:34:36.7620 590 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 14/02/2025 08:35:23.5334 561 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 14/02/2025 08:35:23.7106 701 ms. EXECSCALAR: select count(*) from information_schema.tables where table_schema= 'wisepark_0327' and table_name= 'payInvoiceFtp' nr: 1 14/02/2025 08:38:29.2814 537 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-02-14 08:38:28','V',4756190337832830,2025,'2025-02-14 08:38:28','457002831100327005012999',2,2,2,'O','',0,'2025-02-14 08:38:28',1,'','',0) 14/02/2025 08:39:37.4893 1206 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/02/2025 08:41:37.9004 742 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/02/2025 08:44:47.4757 6331 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 14/02/2025 08:46:18.6341 1972 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 1 14/02/2025 08:47:34.8011 1163 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/02/2025 08:48:08.4878 1176 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/02/2025 08:48:32.4999 845 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 5 and terStatus='V' 14/02/2025 08:49:51.8894 600 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/02/2025 08:49:56.9908 1486 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/02/2025 08:50:58.5342 1047 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/02/2025 08:53:21.0221 3576 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/02/2025 08:54:23.9544 550 ms. EXEC: update abbSubscriptions set subCredit = round(subCredit-0,5),subLastDebit = '2025-02-14 08:54:23' where subId = 16 14/02/2025 08:55:24.6913 548 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/02/2025 08:56:09.3113 514 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2025-02-14 08:56:08',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'; 14/02/2025 08:56:10.1629 851 ms. EXEC: update payInventory set invCreation = '2025-02-14 08:56:09',invModify = '2025-02-14 08:56:09',invUseId=0,invStatus='V' where invId = 236779 14/02/2025 08:56:48.6718 908 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) (WAIT TIME 157 ms.) 14/02/2025 08:56:49.5574 765 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 14/02/2025 08:56:49.5884 719 ms. EXEC: update abbSubscriptions set subCredit = round(subCredit-0,5),subLastDebit = '2025-02-14 08:56:48' where subId = 206 14/02/2025 08:56:50.9864 848 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 14/02/2025 08:56:56.7563 838 ms. OPEN: select sum(crc32(terDescription)) as vCheck from tabTerminal 14/02/2025 08:58:02.2663 1059 ms. EXEC: update payReceipt set recCreation = '2025-02-14 08:58:01',recModify = '2025-02-14 08:58:01',recUseId=0,recStatus='V' where recId = 352280 14/02/2025 08:58:23.7928 1341 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 14/02/2025 09:04:46.9527 1372 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/02/2025 09:10:26.6685 546 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 14/02/2025 09:10:34.9641 2193 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/02/2025 09:10:40.3767 1451 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/02/2025 09:13:08.2422 614 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/02/2025 09:13:57.0841 574 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/02/2025 09:15:13.5626 1267 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/02/2025 09:15:40.0904 501 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/02/2025 09:16:11.2994 546 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/02/2025 09:16:58.4211 569 ms. EXEC: update abbCards set carLastDate = '2025-02-14 09:16:57',carLastDirection='O' where carStatus='V' and carId = 29 14/02/2025 09:17:00.5546 2132 ms. OPEN: select * from tabDevice where devId = 2 and devStatus = 'V' 14/02/2025 09:19:14.1575 1484 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/02/2025 09:22:07.1609 4022 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/02/2025 09:22:31.9746 544 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/02/2025 09:24:50.7930 3265 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2025-02-14 09:24:47' where payTraUID = 4648027345516510 and payStatus='V' and payEnabled=1 14/02/2025 09:25:02.1576 1622 ms. EXECSCALAR: select count(*) from tabTerminalExtraMem where extStatus='V' and extTerId = 2 nr: 1 14/02/2025 09:25:36.7039 611 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-02-14 09:25:36','V',5607299544264340,2025,'2025-02-14 09:25:35','457003393500327005012999',1,2,16,'I','',1,0,1,'','',4) 14/02/2025 09:27:43.9805 1001 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/02/2025 09:29:34.9952 1629 ms. EXEC: UPDATE payInventory SET invType='N' WHERE invType<>'N' AND invValue IN (100,200,500) AND invDevice IN (42102,42101,42001); 14/02/2025 09:31:20.4402 2558 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/02/2025 09:32:09.5903 1978 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 2 and terStatus='V' 14/02/2025 09:32:55.6282 1515 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/02/2025 09:33:27.2856 1831 ms. OPEN: select * from tabArea where areStatus='V' and areEnabled = 1 AND areId = 1 14/02/2025 09:34:02.7154 2543 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/02/2025 09:34:07.9179 762 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/02/2025 09:35:03.0150 510 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 14/02/2025 09:35:04.3198 560 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/02/2025 09:35:18.3983 1105 ms. OPEN: select * from tabArea where areStatus='V' and areEnabled = 1 AND areId = 1 14/02/2025 09:36:53.6824 1790 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/02/2025 09:41:12.3874 519 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2025-02-14 09:41:11' where traUID = 5396469175478010 and traStatus='V' and traEnabled=1 14/02/2025 09:42:05.7873 787 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/02/2025 09:48:56.8289 639 ms. EXECSCALAR: select count(*) from information_schema.tables where table_schema= 'wisepark_0327' and table_name= 'payInvoiceFtp' nr: 1 14/02/2025 09:50:18.8291 890 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/02/2025 09:50:47.7656 987 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/02/2025 09:51:40.1188 769 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-02-14 09:51:39','V',5292388482278780,2025,'2025-02-14 09:51:38','457002893400327005012999',2,2,2,'O','',0,'2025-02-14 09:51:39',1,'','0230003943861',31,0) 14/02/2025 09:51:41.3366 1108 ms. EXEC: update abbCards set carLastDate = '2025-02-14 09:51:40',carLastDirection='O' where carStatus='V' and carId = 31 14/02/2025 09:55:07.7065 2122 ms. EXEC: update opeActivities set acvFstPayId = (case acvFstPayId when 0 then 406029 else acvFstPayId end),acvLstPayId = 406029 where acvSftId = 897 and acvCodeId = 3 14/02/2025 10:00:01.4351 931 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 1 14/02/2025 10:07:03.4153 2381 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/02/2025 10:07:22.7053 718 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2025-02-14 10:07:21' where payTraUID = 5338947814435230 and payStatus='V' and payEnabled=1 14/02/2025 10:07:23.2557 549 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2025-02-14 10:07:21' where traUID = 5338947814435230 and traStatus='V' and traEnabled=1 14/02/2025 10:07:27.0773 1961 ms. EXEC: UPDATE payInventory SET invType='N' WHERE invType<>'N' AND invValue IN (100,200,500) AND invDevice IN (42102,42101,42001); 14/02/2025 10:09:58.6973 1535 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-02-14 10:09:57','V',5476070353562530,2025,'2025-02-14 10:09:54','457003581100327005012999',2,2,2,'O','',0,'2025-02-14 10:09:57',1,'','',0) 14/02/2025 10:10:47.1389 643 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/02/2025 10:11:12.7411 710 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/02/2025 10:13:06.2045 549 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 3 and terStatus='V' 14/02/2025 10:13:29.4681 1044 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/02/2025 10:14:45.6724 2382 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-02-14 10:14:43','V',5012676524296980,2025,'2025-02-14 10:14:43','457003688300327005012999',1,2,16,'I','',1,0,1,'','',4) 14/02/2025 10:15:09.2252 1188 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-02-14 10:15:06',0,'V',5116803908131670,4747275195106070,2025,'2025-02-14 10:15:06',3,1,0,4,'2025-02-14 10:30:06','C','KES',100,200,100,'',' ',' ',1,100,0,0,'',0,0) 14/02/2025 10:15:11.5388 1863 ms. EXEC: update payInventory set invCreation = '2025-02-14 10:15:09',invModify = '2025-02-14 10:15:09',invUseId=0,invStatus='V' where invId = 236784 14/02/2025 10:15:12.6816 824 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2025-02-14 10:15:11',3,42101,0,100,-1,-100,1,'O','N'); update payCurInventory set curQuantity=round(curQuantity+-1,5),curAmount=round(curAmount+-100,5) where curTerId = 3 and curDevCode = 42101 and curChannelId = 1 and curValue = 100 and curType = 'N'; 14/02/2025 10:15:54.6028 1330 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 5 14/02/2025 10:18:45.0044 1561 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/02/2025 10:20:00.2771 1919 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/02/2025 10:20:16.3229 750 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 14/02/2025 10:20:17.4236 1087 ms. EXECSCALAR: SELECT traId FROM movTransit WHERE traCode = '457003721500327005012999' and traDirection='I' order by traId DESC LIMIT 1 nr: 848306 14/02/2025 10:22:25.4688 681 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-02-14 10:22:24','V',4696037044101650,2025,'2025-02-14 10:22:24','457003734400327005012999',1,2,16,'I','',1,0,1,'','',4) 14/02/2025 10:23:18.9870 540 ms. EXEC: insert into paycash (casCreation,casModify,casUseId,casStatus,casUID,casTraUID,casYear,casDateTime,casIdTerminal,casCurrency,casNumber,casSingleAmount,casTotAmount,casType,casDescription) VALUES ('2025-02-14 10:23:18',0,0,'V',5216329472689500,4743148214576830,2025,'2025-02-14 10:23:18',3,'KES',1,100,100,'N',''); 14/02/2025 10:25:30.9057 2593 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2025-02-14 10:25:28' where traUID = 4743148214576830 and traStatus='V' and traEnabled=1 14/02/2025 10:26:00.8394 1149 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 14/02/2025 10:26:10.9703 1653 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/02/2025 10:28:26.4454 636 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/02/2025 10:30:11.9214 524 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 14/02/2025 10:36:25.2121 2998 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/02/2025 10:37:04.4337 2980 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/02/2025 10:37:31.4939 725 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 14/02/2025 10:37:32.5096 708 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2025-02-14 10:37:31' where traUID = 5760415146938730 and traStatus='V' and traEnabled=1 14/02/2025 10:38:50.2409 531 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/02/2025 10:39:11.9996 802 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/02/2025 10:44:49.6928 645 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 14/02/2025 10:47:42.0178 1043 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/02/2025 10:47:50.5605 996 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 14/02/2025 10:48:24.6875 1271 ms. EXEC: insert into payReceipt (recTraUID,recPayUID,recYear,recDateTime,recText,recInvalid) VALUES (5212025864814280,5075205741195260,2025,'2025-02-14 10:48:23','---------------------------------- %The Mall P0006032390 End of payment ---------------------------------- POF Entry : 2/14/2025 10:20:15 AM Date : 2/14/2025 10:48:22 AM Code : 457003721500327005012999 Total : 50.00 KES VAT 16% : 6.90 KES ---------------------------------- Paid : 50.00 KES Coin changed : 0.00 KES Note changed : 0.00 KES',0) 14/02/2025 10:48:26.1885 1239 ms. EXEC: insert into paycash (casCreation,casModify,casUseId,casStatus,casUID,casTraUID,casYear,casDateTime,casIdTerminal,casCurrency,casNumber,casSingleAmount,casTotAmount,casType,casDescription) VALUES ('2025-02-14 10:48:24',0,0,'V',4738768117011540,5212025864814280,2025,'2025-02-14 10:48:24',3,'KES',1,50,50,'N',''); 14/02/2025 10:48:26.5758 859 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/02/2025 10:48:26.8440 520 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2025-02-14 10:48:24',3,42101,0,50,1,50,1,'I','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'; 14/02/2025 10:53:46.8262 1433 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/02/2025 10:54:52.8637 1246 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/02/2025 10:56:08.6537 518 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 14/02/2025 11:00:21.4258 617 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 14/02/2025 11:00:28.8838 1108 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 3 14/02/2025 11:01:54.9287 927 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2025-02-14 11:01:53' where traUID = 5607299544264340 and traStatus='V' and traEnabled=1 14/02/2025 11:02:11.6870 740 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2025-02-14 11.02.10',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'; Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2025-02-14 11.02.10',3,42101,0,100,-1,-100,1,'O','N'); update payCurInventory set curQuantity=round(curQuantity+-1,5),curAmount=round(curAmount+-100,5) where curTerId = 3 and curDevCode = 42101 and curChannelId = 1 and curValue = 100 and curType = 'N'; 14/02/2025 11:03:45.4220 2624 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 1 OR lnsTerId=1) 14/02/2025 11:06:11.9917 1144 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 3 14/02/2025 11:07:09.0951 1301 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 5 and terStatus='V' 14/02/2025 11:07:59.8803 602 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/02/2025 11:08:08.1909 1178 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/02/2025 11:08:17.8123 685 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 14/02/2025 11:08:18.4548 613 ms. EXEC: UPDATE payInventory SET invType='N' WHERE invType<>'N' AND invValue IN (100,200,500) AND invDevice IN (42102,42101,42001); 14/02/2025 11:12:02.2123 539 ms. EXEC: INSERT INTO opeActivities (acvCreation,acvUseId,acvTerId,acvOpeUseId,acvSuperUseId,acvCodeId,acvTypeId,acvDateTime,acvSftId,acvCausal) VALUES (@ACVCREATION,@ACVUSEID,@ACVTERID,@ACVOPEUSEID,@ACVSUPERUSEID,@ACVCODEID,@ACVTYPEID,@ACVDATETIME,@ACVSFTID,@ACVCAUSAL) 14/02/2025 11:15:52.2121 1268 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/02/2025 11:16:13.5625 864 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 16 OR lnsTerId=16) 14/02/2025 11:16:17.7693 1215 ms. EXEC: INSERT INTO movOperator (opeCreation,opeUseId,opeTerId,opeDateTime,opeCode,opeDescription) VALUES ('2025-02-14 11:16:16',0,16,'2025-02-14 11:16:16','','Unauthorized Transit Entry 2') 14/02/2025 11:16:22.7086 2600 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 14/02/2025 11:16:28.7897 1530 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 2 and terStatus='V' 14/02/2025 11:20:57.5806 819 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 14/02/2025 11:22:20.1594 1824 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/02/2025 11:23:09.7137 556 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 14/02/2025 11:24:02.4833 840 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 14/02/2025 11:24:09.4159 762 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 14/02/2025 11:32:33.5332 1171 ms. EXEC: update tabTerminalReceipt set trcProgressive = 6561, trcLastPrinted = '2500706561', trcLastDate = '2025-02-14 11:32:32' where trcStatus='V' and trcTerId = 18 14/02/2025 11:34:21.7811 626 ms. EXEC: insert into payReceipt (recTraUID,recPayUID,recYear,recDateTime,recText,recInvalid) VALUES (5530895338699500,5429872598792320,2025,'2025-02-14 11:34:21','---------------------------------- %The Mall P0006032390 End of payment ---------------------------------- POF Entry : 2/14/2025 11:24:07 AM Date : 2/14/2025 11:34:19 AM Code : 457004104700327001012999 Total : 50.00 KES VAT 16% : 6.90 KES ---------------------------------- Paid : 50.00 KES Coin changed : 0.00 KES Note changed : 0.00 KES',0) 14/02/2025 11:37:35.9144 607 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 14/02/2025 11:37:39.1676 1098 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/02/2025 11:43:07.0693 908 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/02/2025 11:44:47.4628 784 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 14/02/2025 11:46:36.6913 689 ms. EXEC: update payReceipt set recCreation = '2025-02-14 11:46:36',recModify = '2025-02-14 11:46:36',recUseId=0,recStatus='V' where recId = 352344 14/02/2025 11:47:03.8616 578 ms. EXEC: update payReceipt set recCreation = '2025-02-14 11:47:03',recModify = '2025-02-14 11:47:03',recUseId=0,recStatus='V' where recId = 352345 14/02/2025 11:49:47.8670 1829 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-02-14 11:49:45',0,'V',5614930677074690,4796454117991820,2025,'2025-02-14 11:49:45',18,1,0,4,'2025-02-14 12:04:45','C','KES',100,100,0,'','','',1,100,0,0,'',0,0) 14/02/2025 11:52:35.8160 1238 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 2 14/02/2025 11:54:56.8732 2691 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/02/2025 11:54:58.9816 1260 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/02/2025 11:54:59.5010 591 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2025-02-14 11:54:58' where payTraUID = 5518966357884750 and payStatus='V' and payEnabled=1 14/02/2025 11:55:21.6559 747 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-02-14 11:55:20','V',4951962583751950,2025,'2025-02-14 11:55:19','457004291900327005012999',1,2,16,'I','',1,0,1,'','',4) 14/02/2025 11:55:22.5255 834 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 14/02/2025 11:55:23.6562 943 ms. EXECSCALAR: SELECT traId FROM movTransit WHERE traCode = '457004291900327005012999' and traDirection='I' order by traId DESC LIMIT 1 nr: 848430 14/02/2025 11:56:54.9406 655 ms. EXEC: UPDATE payInventory SET invType='N' WHERE invType<>'N' AND invValue IN (100,200,500) AND invDevice IN (42102,42101,42001); 14/02/2025 11:57:49.2788 750 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 2 14/02/2025 11:58:33.9709 1097 ms. EXEC: insert into paycash (casCreation,casModify,casUseId,casStatus,casUID,casTraUID,casYear,casDateTime,casIdTerminal,casCurrency,casNumber,casSingleAmount,casTotAmount,casType,casDescription) VALUES ('2025-02-14 11:58:32',0,0,'V',4970069771757630,5596986084630420,2025,'2025-02-14 11:58:32',3,'KES',1,100,100,'N',''); 14/02/2025 11:58:39.1224 570 ms. EXEC: INSERT INTO movOperator (opeCreation,opeUseId,opeTerId,opeDateTime,opeCode,opeDescription) VALUES ('2025-02-14 11:58:38',0,16,'2025-02-14 11:58:38','','Unauthorized Transit Entry 2') 14/02/2025 11:59:26.1763 1132 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/02/2025 11:59:38.6459 585 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 14/02/2025 11:59:45.7087 1213 ms. EXEC: UPDATE payCash SET casType='N' WHERE casType<>'N' AND ABS(casSingleAmount) IN (100,200,500); 14/02/2025 11:59:50.2418 1699 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-02-14 11:59:48','V',5639157458658170,2025,'2025-02-14 11:59:48','457003304900327001012999',2,2,2,'O','',0,'2025-02-14 11:59:48',1,'','',0) 14/02/2025 11:59:51.0904 839 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 14/02/2025 12:00:00.4318 560 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-02-14 12:00:00',0,'V',4625993663753060,5158180045626900,2025,'2025-02-14 12:00:00',3,1,0,4,'2025-02-14 12:15:00','C','KES',50,100,0,'',' ',' ',2,50,0,0,'',0,0) 14/02/2025 12:00:01.7837 927 ms. EXEC: update payReceipt set recCreation = '2025-02-14 12:00:00',recModify = '2025-02-14 12:00:00',recUseId=0,recStatus='V' where recId = 352358 14/02/2025 12:00:52.8917 1094 ms. OPEN: select * from tabArea where areStatus='V' and areEnabled = 1 AND areId = 1 14/02/2025 12:01:53.7064 550 ms. EXECSCALAR: select count(*) from tabTerminalExtraMem where extStatus='V' and extTerId = 2 nr: 1 14/02/2025 12:02:36.2665 1069 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/02/2025 12:03:07.3247 788 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 14/02/2025 12:07:19.7221 725 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 14/02/2025 12:07:22.7692 554 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/02/2025 12:07:28.8873 782 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 3 14/02/2025 12:07:48.9090 533 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 14/02/2025 12:08:15.6081 518 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 14/02/2025 12:11:13.2522 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-02-14 12:11:11','V',5227786270384060,2025,'2025-02-14 12:11:13','457004387300327005012999',1,2,16,'I','',1,0,1,'','',4) 14/02/2025 12:11:31.8067 509 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-02-14 12:11:31','V',5013268518039110,2025,'2025-02-14 12:11:29','457002797900327005012999',2,2,2,'O','',0,'2025-02-14 12:11:31',1,'','',0) 14/02/2025 12:11:39.9662 1751 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/02/2025 12:11:45.5290 1026 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 3 OR lnsTerId=3) 14/02/2025 12:11:45.5320 694 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/02/2025 12:11:49.9220 997 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 14/02/2025 12:13:38.1961 745 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 14/02/2025 12:13:46.1135 1661 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-02-14 12:13:45',0,'V',5190984631912350,4725907541507790,2025,'2025-02-14 12:13:45',3,1,0,4,'2025-02-14 12:28:45','C','KES',100,100,0,'',' ',' ',1,100,0,0,'',0,0) 14/02/2025 12:17:29.1091 529 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 14/02/2025 12:18:16.8244 2251 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 14/02/2025 12:20:15.7947 2572 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-02-14 12:20:13',0,'V',5109968678792670,4937522371566770,2025,'2025-02-14 12:20:13',18,1,0,4,'2025-02-14 12:35:13','C','KES',100,100,0,'','','',1,100,0,0,'',0,0) 14/02/2025 12:22:18.3375 604 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/02/2025 12:22:49.1602 777 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 14/02/2025 12:23:02.9536 614 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 14/02/2025 12:28:50.9475 703 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); (WAIT TIME 143 ms.) 14/02/2025 12:28:50.9535 682 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-02-14 12:28:50',0,'V',4798889652891290,5396939158410150,2025,'2025-02-14 12:28:50',18,1,0,4,'2025-02-14 12:43:50','C','KES',50,50,0,'','','',1,50,0,0,'',0,0) (WAIT TIME 4 ms.) 14/02/2025 12:31:22.6315 693 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/02/2025 12:31:42.1537 576 ms. EXECSCALAR: select count(*) from information_schema.tables where table_schema= 'wisepark_0327' and table_name= 'payInvoiceFtp' nr: 1 14/02/2025 12:32:43.3959 511 ms. EXEC: update tabTerminalReceipt set trcProgressive = 6581, trcLastPrinted = '2500706581', trcLastDate = '2025-02-14 12:32:42' where trcStatus='V' and trcTerId = 18 14/02/2025 12:35:32.9910 660 ms. OPEN: select ticId from tabTicketType where ticStatus='V' and ticType = 1 14/02/2025 12:35:53.9471 1231 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-02-14 12:35:50',0,'V',5263208460848800,5341142777431040,2025,'2025-02-14 12:35:50',3,1,0,4,'2025-02-14 12:50:50','C','KES',50,50,0,'',' ',' ',1,50,0,0,'',0,0) 14/02/2025 12:35:56.7570 1162 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/02/2025 12:35:58.5382 1743 ms. EXEC: update opeActivities set acvFstPayId = (case acvFstPayId when 0 then 406128 else acvFstPayId end),acvLstPayId = 406128 where acvSftId = 894 and acvCodeId = 3 14/02/2025 12:36:11.7981 1384 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/02/2025 12:37:52.2046 689 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2025-02-14 12:37:51',3,42101,0,100,-1,-100,1,'O','N'); update payCurInventory set curQuantity=round(curQuantity+-1,5),curAmount=round(curAmount+-100,5) where curTerId = 3 and curDevCode = 42101 and curChannelId = 1 and curValue = 100 and curType = 'N'; 14/02/2025 12:39:32.2961 910 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2025-02-14 12:39:31' where payTraUID = 5227786270384060 and payStatus='V' and payEnabled=1 14/02/2025 12:45:00.8179 753 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 5 and terStatus='V' 14/02/2025 12:47:12.3643 1537 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-02-14 12:47:10','V',4812438248396130,2025,'2025-02-14 12:47:10','457004603000327005012999',1,2,16,'I','',1,0,1,'','',4) 14/02/2025 12:52:44.6525 791 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/02/2025 12:54:53.6582 2464 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 14/02/2025 12:55:10.6266 574 ms. EXECSCALAR: select count(*) from tabTerminalExtraMem where extStatus='V' and extTerId = 17 nr: 1 14/02/2025 12:55:10.7747 791 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 1 OR lnsTerId=1) 14/02/2025 12:55:42.1978 3263 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 16 OR lnsTerId=16) 14/02/2025 12:59:43.0305 3323 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-02-14 12:59:38',0,'V',5321739985706050,4915385136477960,2025,'2025-02-14 12:59:38',3,1,0,4,'2025-02-14 13:14:38','C','KES',50,200,150,'',' ',' ',1,50,0,0,'',0,0) 14/02/2025 12:59:45.7894 1879 ms. EXEC: update paycash set casCreation = '2025-02-14 12:59:43',casModify = '2025-02-14 12:59:43',casUseId=0,casStatus='V' where casId = 209543 14/02/2025 13:00:25.2639 1085 ms. OPEN: select * from tabArea where areStatus='V' and areEnabled = 1 AND areId = 1 14/02/2025 13:04:19.4562 545 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/02/2025 13:05:32.3862 623 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 14/02/2025 13:07:05.7329 558 ms. EXEC: insert into payReceipt (recTraUID,recPayUID,recYear,recDateTime,recText,recInvalid) VALUES (5534622211444210,5347435842638930,2025,'2025-02-14 13:07:05','---------------------------------- %The Mall P0006032390 End of payment ---------------------------------- POF Entry : 2/14/2025 12:46:20 PM Date : 2/14/2025 1:07:03 PM Code : 457004598000327001012999 Total : 50.00 KES VAT 16% : 6.90 KES ---------------------------------- Paid : 200.00 KES Coin changed : 0.00 KES Note changed : 150.00 KES',0) 14/02/2025 13:07:24.2683 877 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-02-14 13:07:23','V',5643179674433250,2025,'2025-02-14 13:07:21','457004603000327005012999',2,2,2,'O','',0,'2025-02-14 13:07:23',1,'','',0) 14/02/2025 13:07:25.0979 822 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 14/02/2025 13:07:52.4713 1434 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/02/2025 13:07:55.4342 858 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 4 14/02/2025 13:07:58.0070 557 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2025-02-14 13:07:57' where payTraUID = 4938719376339740 and payStatus='V' and payEnabled=1 14/02/2025 13:08:48.8491 1070 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2025-02-14 13.08.47' where payTraUID = 5156647431945590 and payStatus='V' and payEnabled=1 14/02/2025 13:11:33.9690 1469 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 14/02/2025 13:11:34.0561 556 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-02-14 13:10:37',6,'V',5375641726072190,4766688799258300,2025,'2025-02-14 13:10:37',4,1,0,4,'2025-02-14 13:25:37','P','KES',50,50,0,'','','',1,50,0,0,'',0,0) 14/02/2025 13:11:49.7727 920 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-02-14 13:10:53',6,'V',4970541524621410,5694982317494390,2025,'2025-02-14 13:10:53',4,1,0,4,'2025-02-14 13:25:53','P','KES',50,50,0,'','','',1,50,0,0,'',0,0) 14/02/2025 13:11:54.3948 534 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2025-02-14 13:11:53',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'; Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2025-02-14 13:11:53',3,42101,0,200,-2,-400,1,'O','N'); update payCurInventory set curQuantity=round(curQuantity+-2,5),curAmount=round(curAmount+-400,5) where curTerId = 3 and curDevCode = 42101 and curChannelId = 1 and curValue = 200 and curType = 'N'; 14/02/2025 13:12:11.7274 2198 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/02/2025 13:12:28.6688 706 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/02/2025 13:12:40.6368 882 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/02/2025 13:12:52.2126 578 ms. OPEN: SELECT SUM(vTot) as vTot,payTimeLimit FROM (SELECT SUM(payPayed)-SUM(payChange) AS vTot,MAX(payTimeLimit) AS payTimeLimit FROM payPayment INNER JOIN movtransit ON movtransit.traUID=payPayment.payTraUID WHERE traCode = '457003884200327001012999' AND traStatus='V' AND payStatus='V' AND payIdEvent<90 GROUP BY payId ORDER BY payEnabled DESC, payTimeLimit DESC) as v1 14/02/2025 13:13:08.2024 627 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-02-14 13:13:07','V',5723538394633180,2025,'2025-02-14 13:13:06','457004454800327005012999',2,2,2,'O','',0,'2025-02-14 13:13:07',1,'','',0) 14/02/2025 13:13:10.7941 2152 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2025-02-14 13:13:08' where traUID = 5425204365128240 and traStatus='V' and traEnabled=1 14/02/2025 13:13:31.8222 769 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2025-02-14 13:13:30' where traUID = 4788774133332980 and traStatus='V' and traEnabled=1 14/02/2025 13:15:07.6818 785 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-02-14 13:15:06','V',4850693131586360,2025,'2025-02-14 13:15:06','457004770600327005012999',1,2,16,'I','',1,0,1,'','',4) 14/02/2025 13:15:08.5684 660 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 14/02/2025 13:16:50.0946 1290 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2025-02-14 13:16:48' where traUID = 4766688799258300 and traStatus='V' and traEnabled=1 14/02/2025 13:23:14.8711 2946 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/02/2025 13:25:01.8720 991 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/02/2025 13:25:55.5261 853 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 2 OR lnsTerId=2) 14/02/2025 13:28:59.4055 510 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 14/02/2025 13:29:15.0020 775 ms. EXEC: update payReceipt set recCreation = '2025-02-14 13:29:14',recModify = '2025-02-14 13:29:14',recUseId=0,recStatus='V' where recId = 352416 14/02/2025 13:31:00.2746 793 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 5 and terStatus='V' 14/02/2025 13:35:02.1039 547 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-02-14 13:35:01',0,'V',4754889001627880,4721894386858080,2025,'2025-02-14 13:35:01',18,1,0,4,'2025-02-14 13:50:01','C','KES',50,50,0,'','','',1,50,0,0,'',0,0) 14/02/2025 13:36:48.0769 532 ms. OPEN: select * from tabArea where areStatus='V' and areEnabled = 1 AND areId = 1 14/02/2025 13:37:10.4239 590 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2025-02-14 13:37:09' where traUID = 5617236278590010 and traStatus='V' and traEnabled=1 14/02/2025 13:37:29.6438 2090 ms. EXEC: update tabTerminalReceipt set trcProgressive = 6600, trcLastPrinted = '2500706600', trcLastDate = '2025-02-14 13:37:27' where trcStatus='V' and trcTerId = 18 (WAIT TIME 97 ms.) 14/02/2025 13:38:55.7805 1034 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 14/02/2025 13:42:23.2526 744 ms. EXEC: INSERT INTO movOperator (opeCreation,opeUseId,opeTerId,opeDateTime,opeCode,opeDescription) VALUES ('2025-02-14 13:42:22',0,16,'2025-02-14 13:42:22','','Unauthorized Transit Entry 2') 14/02/2025 13:50:46.8423 674 ms. OPEN: select * from tabArea where areStatus='V' and areEnabled = 1 AND areId = 1 14/02/2025 13:50:47.2936 504 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/02/2025 13:51:02.4147 1359 ms. EXEC: UPDATE payInventory SET invType='N' WHERE invType<>'N' AND invValue IN (100,200,500) AND invDevice IN (42102,42101,42001); 14/02/2025 13:51:11.9051 568 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-02-14 13:51:11','V',5662664814209750,2025,'2025-02-14 13:51:10','457004677200327005012999',2,2,2,'O','',0,'2025-02-14 13:51:11',1,'','0230003943508',39,0) 14/02/2025 13:51:16.4731 673 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/02/2025 13:51:56.9683 681 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/02/2025 13:52:45.8231 1372 ms. EXEC: update paycash set casCreation = '2025-02-14 13:52:44',casModify = '2025-02-14 13:52:44',casUseId=0,casStatus='V' where casId = 209559 14/02/2025 13:52:48.4398 2406 ms. EXEC: insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2025-02-14 13:52:46',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'; insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2025-02-14 13:52:46',3,42101,0,50,1,50,2,'I','N'); update payCurInventory set curQuantity=round(curQuantity+1,5),curAmount=round(curAmount+50,5) where curTerId = 3 and curDevCode = 42101 and curChannelId = 2 and curValue = 50 and curType = 'N'; 14/02/2025 13:52:59.7754 599 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-02-14 13:52:59','V',5306666642263640,2025,'2025-02-14 13:52:58','457004487600327005012999',2,2,2,'O','',0,'2025-02-14 13:52:59',1,'','',0) 14/02/2025 13:53:01.2955 580 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2025-02-14 13:53:00' where traUID = 5755857478595470 and traStatus='V' and traEnabled=1 14/02/2025 13:57:33.7293 1043 ms. EXEC: update tabTerminalReceipt set trcProgressive = 6608, trcLastPrinted = '2500706608', trcLastDate = '2025-02-14 13:57:32' where trcStatus='V' and trcTerId = 18 14/02/2025 13:57:36.0688 1434 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/02/2025 14:00:26.1240 847 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/02/2025 14:00:45.5730 545 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-02-14 14:00:43',0,'V',4677467521128410,5408352531867640,2025,'2025-02-14 14:00:43',3,1,0,4,'2025-02-14 14:15:43','C','KES',50,50,0,'',' ',' ',1,50,0,0,'',0,0) 14/02/2025 14:03:34.2470 3026 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/02/2025 14:04:06.1064 814 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/02/2025 14:08:25.8205 668 ms. EXEC: update payReceipt set recCreation = '2025-02-14 14.08.25',recModify = '2025-02-14 14.08.25',recUseId=0,recStatus='V' where recId = 352443 14/02/2025 14:18:22.8354 911 ms. EXEC: UPDATE payInventory SET invType='N' WHERE invType<>'N' AND invValue IN (100,200,500) AND invDevice IN (42102,42101,42001); 14/02/2025 14:20:29.9406 880 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-02-14 14:20:29','V',4718666030449760,2025,'2025-02-14 14:20:22','457005162200327001012999',1,2,1,'I','',1,0,1,'','',4) (WAIT TIME 12 ms.) 14/02/2025 14:20:56.8106 560 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/02/2025 14:22:01.0537 1017 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 14/02/2025 14:22:13.6861 553 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 14/02/2025 14:24:01.1732 571 ms. EXEC: update paycash set casCreation = '2025-02-14 14:24:00',casModify = '2025-02-14 14:24:00',casUseId=0,casStatus='V' where casId = 209566 14/02/2025 14:24:03.4377 1723 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2025-02-14 14:24:01',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'; Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2025-02-14 14:24:01',3,42101,0,100,-1,-100,1,'O','N'); update payCurInventory set curQuantity=round(curQuantity+-1,5),curAmount=round(curAmount+-100,5) where curTerId = 3 and curDevCode = 42101 and curChannelId = 1 and curValue = 100 and curType = 'N'; 14/02/2025 14:24:15.4077 1172 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/02/2025 14:27:59.4260 627 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 14/02/2025 14:29:30.2549 4842 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2025-02-14 14:29:25' where payTraUID = 4929038084112590 and payStatus='V' and payEnabled=1 14/02/2025 14:29:30.3129 2161 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/02/2025 14:29:45.7313 684 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/02/2025 14:33:34.6400 671 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 3 and terStatus='V' 14/02/2025 14:35:26.2946 605 ms. EXEC: UPDATE payInventory SET invType='N' WHERE invType<>'N' AND invValue IN (100,200,500) AND invDevice IN (42102,42101,42001); 14/02/2025 14:35:27.1942 851 ms. OPEN: show columns from tabParameters where Field = 'parAllowNegativePlaces' 14/02/2025 14:35:32.1355 601 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 14/02/2025 14:35:43.9303 794 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-02-14 14:35:43',0,'V',5040519825166270,5051910181502250,2025,'2025-02-14 14:35:43',18,1,0,4,'2025-02-14 14:50:43','C','KES',100,100,0,'','','',1,100,0,0,'',0,0) 14/02/2025 14:35:43.9694 785 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 14/02/2025 14:35:45.0521 1040 ms. EXEC: update tabTerminalReceipt set trcProgressive = 6620, trcLastPrinted = '2500706620', trcLastDate = '2025-02-14 14:35:44' where trcStatus='V' and trcTerId = 18 14/02/2025 14:35:45.0551 1010 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 14/02/2025 14:37:08.8570 520 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/02/2025 14:37:21.3284 2262 ms. EXEC: update tabTerminalReceipt set trcProgressive = 6621, trcLastPrinted = '2500706621', trcLastDate = '2025-02-14 14:37:19' where trcStatus='V' and trcTerId = 18 14/02/2025 14:38:41.3398 935 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/02/2025 14:39:00.2284 3008 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-02-14 14:38:57','V',4689830359426670,2025,'2025-02-14 14:38:56','457004193900327005012999',2,2,2,'O','',0,'2025-02-14 14:38:57',1,'','',0) 14/02/2025 14:39:03.2675 3036 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 14/02/2025 14:39:04.3092 911 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 14/02/2025 14:39:17.4569 553 ms. EXEC: update payInventory set invCreation = '2025-02-14 14:39:16',invModify = '2025-02-14 14:39:16',invUseId=0,invStatus='V' where invId = 236876 14/02/2025 14:40:10.0081 883 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/02/2025 14:40:25.2573 532 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 14/02/2025 14:40:55.0412 4559 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-02-14 14:40:50','V',5709229767747830,2025,'2025-02-14 14:40:50','457005285000327005012999',1,2,16,'I','',1,0,1,'','',4) 14/02/2025 14:44:09.0288 599 ms. EXECSCALAR: select count(*) from information_schema.tables where table_schema= 'wisepark_0327' and table_name= 'payInvoiceFtp' nr: 1 14/02/2025 14:44:34.9272 1402 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/02/2025 14:45:08.9169 530 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 14/02/2025 14:47:30.1261 1107 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/02/2025 14:48:02.8810 2771 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/02/2025 14:48:04.8523 630 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 5 14/02/2025 14:48:26.7849 532 ms. OPEN: show columns from tmpPay where Field = 'tmpInvoice' 14/02/2025 14:48:29.7599 2929 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-02-14 14:48:11',12,'V',5172451858143930,5150812120162930,2025,'2025-02-14 14:48:11',17,1,0,4,'2025-02-14 15:03:11','C','KES',100,100,0,'','','',1,100,0,0,'',0,0) 14/02/2025 14:48:31.6632 1619 ms. EXEC: update tabTerminalReceipt set trcProgressive = 1183, trcLastPrinted = '2500601183', trcLastDate = '2025-02-14 14:48:30' where trcStatus='V' and trcTerId = 17 14/02/2025 14:51:45.5350 815 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 5 14/02/2025 14:51:45.7171 607 ms. EXEC: UPDATE payInventory SET invType='N' WHERE invType<>'N' AND invValue IN (100,200,500) AND invDevice IN (42102,42101,42001); 14/02/2025 14:51:52.3735 1655 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 2 OR lnsTerId=2) 14/02/2025 14:51:52.3795 1528 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/02/2025 14:52:06.6100 693 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 14/02/2025 14:55:51.3011 532 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/02/2025 15:04:28.0868 1145 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 3 14/02/2025 15:14:59.5306 760 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/02/2025 15:17:26.8007 1620 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 1 and terStatus='V' 14/02/2025 15:18:53.3845 1861 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/02/2025 15:19:39.1321 642 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 14/02/2025 15:23:01.5721 658 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/02/2025 15:23:06.5535 691 ms. EXECSCALAR: select count(*) from information_schema.tables where table_schema= 'wisepark_0327' and table_name= 'payInvoiceFtp' nr: 1 14/02/2025 15:26:21.9139 1475 ms. EXEC: INSERT INTO movOperator (opeCreation,opeUseId,opeTerId,opeDateTime,opeCode,opeDescription) VALUES ('2025-02-14 15:26:20',0,16,'2025-02-14 15:26:20','','Unauthorized Transit Entry 2') 14/02/2025 15:27:07.8867 612 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-02-14 15:27:07','V',5572248636814370,2025,'2025-02-14 15:27:05','457005562500327005012999',1,2,16,'I','',1,0,1,'','',4) 14/02/2025 15:28:31.8298 1913 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 5 and terStatus='V' 14/02/2025 15:28:32.6604 751 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-02-14 15:28:31','V',5435577805853880,2025,'2025-02-14 15:28:30','457005571000327005012999',1,2,16,'I','',1,0,1,'','',4) 14/02/2025 15:29:44.0411 554 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 14/02/2025 15:32:44.8702 721 ms. EXEC: UPDATE payInventory SET invType='N' WHERE invType<>'N' AND invValue IN (100,200,500) AND invDevice IN (42102,42101,42001); 14/02/2025 15:32:56.6160 3641 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 14/02/2025 15:35:20.1210 2675 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/02/2025 15:41:10.2887 529 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-02-14 15:41:09',0,'V',5229184260518660,4843578548802510,2025,'2025-02-14 15:41:09',18,1,0,4,'2025-02-14 15:56:09','C','KES',50,50,0,'','','',1,50,0,0,'',0,0) 14/02/2025 15:42:47.0085 587 ms. OPEN: select * from movtransit where traUID = 5278810473961830 and traStatus='V' 14/02/2025 15:43:07.9155 820 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 2 OR lnsTerId=2) 14/02/2025 15:43:15.4105 792 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2025-02-14 15:43:14' where traUID = 4843578548802510 and traStatus='V' and traEnabled=1 14/02/2025 15:43:24.8538 3396 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 14/02/2025 15:45:00.9772 586 ms. EXECSCALAR: select sum(parAllowNegativePlaces) from tabParameters where parStatus='V' order by parId desc limit 1 nr: 0 14/02/2025 15:48:39.8616 1109 ms. EXECSCALAR: select count(*) from information_schema.tables where table_schema= 'wisepark_0327' and table_name= 'payInvoiceFtp' nr: 1 14/02/2025 15:49:56.8551 2356 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 2 OR lnsTerId=2) 14/02/2025 15:49:57.1853 1185 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/02/2025 15:50:44.3950 842 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/02/2025 15:51:49.0310 569 ms. EXECSCALAR: select count(*) from tabTerminalExtraMem where extStatus='V' and extTerId = 2 nr: 1 14/02/2025 15:54:20.9286 1814 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 18 OR lnsTerId=18) 14/02/2025 15:57:14.1509 1005 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-02-14 15:56:17',6,'V',5611207344619470,5421260518181020,2025,'2025-02-14 15:56:17',4,1,0,4,'2025-02-14 16:11:17','P','KES',50,50,0,'','','',1,50,0,0,'',0,0) 14/02/2025 15:57:14.3050 1221 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 14/02/2025 15:57:15.1095 639 ms. EXEC: update opeActivities set acvFstPayId = (case acvFstPayId when 0 then 406277 else acvFstPayId end),acvLstPayId = 406277 where acvSftId = 897 and acvCodeId = 3 14/02/2025 15:57:16.2132 1260 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 14/02/2025 15:57:16.6405 1522 ms. EXEC: update tabTerminalReceipt set trcProgressive = 2066, trcLastPrinted = '2500402066', trcLastDate = '2025-02-14 15:57:15' where trcStatus='V' and trcTerId = 4 14/02/2025 15:57:18.0044 974 ms. EXEC: update payReceipt set recCreation = '2025-02-14 15:57:17',recModify = '2025-02-14 15:57:17',recUseId=0,recStatus='V' where recId = 352520 14/02/2025 15:57:29.8504 660 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 5 and terStatus='V' 14/02/2025 15:57:56.7324 956 ms. OPEN: select * from tabArea where areStatus='V' and areEnabled = 1 AND areId = 1 14/02/2025 15:59:03.4302 1397 ms. EXEC: update abbCards set carLastDate = '2025-02-14 15:59:02',carLastDirection='I' where carStatus='V' and carId = 29 14/02/2025 15:59:15.3702 534 ms. EXEC: insert into payReceipt (recTraUID,recPayUID,recYear,recDateTime,recText,recInvalid) VALUES (5759511763899120,5517024846463040,2025,'2025-02-14 15:59:14',' Date: 2/14/2025 3:59:13 PM Code: 457004766500327005012999 Entry Date: 2/14/2025 1:14:25 PM Plate: Class: Cars Park: The Mall Gate: Entry 2 ______________________________ Total: 100.00 KES ______________________________ Paid: 100.00 KES __________ Change: 0.00 KES Type: Cash Dispozitiv: MPESA # 2500706652 ',0) 14/02/2025 15:59:16.6300 1258 ms. EXEC: update payReceipt set recCreation = '2025-02-14 15:59:15',recModify = '2025-02-14 15:59:15',recUseId=0,recStatus='V' where recId = 352522 14/02/2025 15:59:40.6382 967 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-02-14 15:59:39','V',5623546242503960,2025,'2025-02-14 15:59:39','457005757900327005012999',1,2,16,'I','',1,0,1,'','',4) 14/02/2025 15:59:50.5068 2177 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/02/2025 16:01:12.1075 501 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/02/2025 16:01:15.4708 620 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/02/2025 16:04:38.2343 555 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2025-02-14 16:04:37',3,42101,0,500,1,500,1,'I','N'); update payCurInventory set curQuantity=round(curQuantity+1,5),curAmount=round(curAmount+500,5) where curTerId = 3 and curDevCode = 42101 and curChannelId = 1 and curValue = 500 and curType = 'N'; 14/02/2025 16:04:47.4865 1950 ms. EXEC: UPDATE payInventory SET invType='N' WHERE invType<>'N' AND invValue IN (100,200,500) AND invDevice IN (42102,42101,42001); 14/02/2025 16:04:56.4205 592 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-02-14 16:04:55','V',4812366632135890,2025,'2025-02-14 16:04:54','457005593900327001012999',2,2,2,'O','',0,'2025-02-14 16:04:55',1,'','',0) 14/02/2025 16:04:57.6253 665 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2025-02-14 16:04:56' where traUID = 5752358745281770 and traStatus='V' and traEnabled=1 14/02/2025 16:05:13.7611 716 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/02/2025 16:05:23.6638 1790 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/02/2025 16:06:57.4347 2447 ms. EXECSCALAR: select count(*) from information_schema.tables where table_schema= 'wisepark_0327' and table_name= 'payInvoiceFtp' nr: 1 14/02/2025 16:10:03.2505 607 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2025-02-14 16:10:02' where traUID = 5456365926274230 and traStatus='V' and traEnabled=1 14/02/2025 16:10:12.8970 610 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 14/02/2025 16:10:21.4687 906 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 14/02/2025 16:10:23.9183 644 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2025-02-14 16:10:23' where traUID = 5022314659109430 and traStatus='V' and traEnabled=1 14/02/2025 16:10:29.1499 1362 ms. EXECSCALAR: select count(*) from information_schema.tables where table_schema= 'wisepark_0327' and table_name= 'payInvoiceFtp' nr: 1 14/02/2025 16:10:31.8597 1488 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/02/2025 16:11:03.3018 540 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 14/02/2025 16:11:57.6592 1301 ms. EXEC: update payReceipt set recCreation = '2025-02-14 16:11:56',recModify = '2025-02-14 16:11:56',recUseId=0,recStatus='V' where recId = 352536 14/02/2025 16:11:57.6812 1226 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 14/02/2025 16:14:36.7179 3601 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-02-14 16:14:33','V',5088793641728390,2025,'2025-02-14 16:14:32','457005847200327005012999',1,2,16,'I','',1,0,1,'','',4) 14/02/2025 16:15:07.4895 650 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 14/02/2025 16:15:36.7411 7718 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 2 14/02/2025 16:15:40.6387 1092 ms. OPEN: select * from tabTerminal where terStatus='V' and terType=4 14/02/2025 16:16:01.3296 691 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 5 and terStatus='V' 14/02/2025 16:21:34.0038 521 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 16 OR lnsTerId=16) 14/02/2025 16:26:31.0048 2337 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-02-14 16.26.28','V',5099274213137700,2025,'2025-02-14 16.26.28','457005918800327005012999',1,2,16,'I','',1,0,1,'','',4) 14/02/2025 16:26:32.3097 1299 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 14/02/2025 16:28:32.3689 1616 ms. EXEC: UPDATE payInventory SET invType='N' WHERE invType<>'N' AND invValue IN (100,200,500) AND invDevice IN (42102,42101,42001); 14/02/2025 16:28:41.0277 616 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-02-14 16:28:40',0,'V',5602335554819560,5639867765357660,2025,'2025-02-14 16:28:40',18,1,0,4,'2025-02-14 16:43:40','C','KES',50,50,0,'','','',1,50,0,0,'',0,0) 14/02/2025 16:30:14.8914 1949 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/02/2025 16:32:51.5113 1684 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 14/02/2025 16:34:00.6515 503 ms. EXEC: update abbCards set carLastDate = '2025-02-14 16:34:00',carLastDirection='I' where carStatus='V' and carId = 66 14/02/2025 16:34:01.6692 1016 ms. OPEN: select * from tabDevice where devId = 1 and devStatus = 'V' 14/02/2025 16:34:02.2305 1455 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/02/2025 16:34:19.8833 1122 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2025-02-14 16:34:18',3,42101,0,200,-1,-200,1,'O','N'); update payCurInventory set curQuantity=round(curQuantity+-1,5),curAmount=round(curAmount+-200,5) where curTerId = 3 and curDevCode = 42101 and curChannelId = 1 and curValue = 200 and curType = 'N'; insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2025-02-14 16:34:18',3,42101,0,200,-1,-200,1,'O','N'); update payCurInventory set curQuantity=round(curQuantity-1,5),curAmount=round(curAmount-200,5) where curTerId = 3 and curDevCode = 42101 and curChannelId = 1 and curValue = 200 and curType = 'N'; insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2025-02-14 16:34:18',3,42101,0,200,1,200,2,'I','N'); update payCurInventory set curQuantity=round(curQuantity+1,5),curAmount=round(curAmount+200,5) where curTerId = 3 and curDevCode = 42101 and curChannelId = 2 and curValue = 200 and curType = 'N'; 14/02/2025 16:39:38.0587 1120 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 14/02/2025 16:39:41.3659 849 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-02-14 16:39:40',0,'V',4984205861220230,5090765922728690,2025,'2025-02-14 16:39:40',18,1,0,4,'2025-02-14 16:54:40','C','KES',50,50,0,'','','',1,50,0,0,'',0,0) 14/02/2025 16:39:42.2635 807 ms. EXEC: update tabTerminalReceipt set trcProgressive = 6674, trcLastPrinted = '2500706674', trcLastDate = '2025-02-14 16:39:41' where trcStatus='V' and trcTerId = 18 14/02/2025 16:41:47.9025 929 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2025-02-14 16:41:46' where traUID = 5090765922728690 and traStatus='V' and traEnabled=1 14/02/2025 16:41:54.0266 3164 ms. EXECSCALAR: select count(*) from information_schema.tables where table_schema= 'wisepark_0327' and table_name= 'payInvoiceFtp' nr: 1 14/02/2025 16:43:03.8974 1054 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 2 OR lnsTerId=2) 14/02/2025 16:43:22.1546 1456 ms. EXECSCALAR: select count(0) as vTot from tabParameters where parPlateReading<>0 nr: 0 14/02/2025 16:43:48.8204 600 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-02-14 16:43:48','V',4807556790411620,2025,'2025-02-14 16:43:47','457005932000327005012999',2,2,2,'O','',0,'2025-02-14 16:43:48',1,'','',0) 14/02/2025 16:48:07.1639 672 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-02-14 16:48:06','V',5597650029113350,2025,'2025-02-14 16:48:06','457005632000327001012999',2,2,2,'O','',0,'2025-02-14 16:48:06',1,'','',0) 14/02/2025 16:48:22.8824 1051 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 2 OR lnsTerId=2) 14/02/2025 16:48:22.8874 910 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/02/2025 16:51:00.9573 538 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 14/02/2025 16:52:19.3147 570 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/02/2025 16:56:19.9117 506 ms. EXEC: UPDATE payInventory SET invType='N' WHERE invType<>'N' AND invValue IN (100,200,500) AND invDevice IN (42102,42101,42001); 14/02/2025 16:57:43.6028 1391 ms. EXEC: update abbCards set carLastDate = '2025-02-14 16:57:42',carLastDirection='O' where carStatus='V' and carId = 165 14/02/2025 16:57:45.2459 644 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 14/02/2025 17:01:31.7959 1042 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2025-02-14 17.01.30' where traUID = 5051125752272150 and traStatus='V' and traEnabled=1 14/02/2025 17:02:11.2713 811 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/02/2025 17:03:33.1542 1319 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/02/2025 17:03:40.1348 709 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/02/2025 17:07:06.8874 963 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 16 OR lnsTerId=16) 14/02/2025 17:07:22.1156 672 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/02/2025 17:07:36.2931 1048 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 (WAIT TIME 70 ms.) 14/02/2025 17:08:53.6409 890 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-02-14 17.08.52','V',4855947433441620,2025,'2025-02-14 17.08.51','457006173100327005012999',1,2,16,'I','',1,0,1,'','',4) 14/02/2025 17:10:36.4447 1825 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 14/02/2025 17:16:16.4415 1454 ms. EXEC: UPDATE payInventory SET invType='N' WHERE invType<>'N' AND invValue IN (100,200,500) AND invDevice IN (42102,42101,42001); 14/02/2025 17:18:49.8021 1739 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1