09/11/2024 00:00:01.4328 1400 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 09/11/2024 00:10:50.5021 614 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 09/11/2024 00:13:07.5594 1126 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 09/11/2024 00:17:09.7708 546 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 09/11/2024 00:17:19.7074 612 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 2 09/11/2024 00:18:26.7351 1115 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 09/11/2024 00:20:40.6082 527 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 09/11/2024 00:30:26.7907 839 ms. EXEC: update payReceipt set recCreation = '2024-11-09 00:30:25',recModify = '2024-11-09 00:30:25',recUseId=0,recStatus='V' where recId = 320753 09/11/2024 00:32:33.2520 963 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 09/11/2024 00:34:12.9124 706 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 09/11/2024 00:37:11.4743 567 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 09/11/2024 00:46:47.7522 2884 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 09/11/2024 01:01:00.1874 541 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 09/11/2024 01:03:13.5262 656 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 09/11/2024 01:05:35.5909 662 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 09/11/2024 01:05:45.5025 2212 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 09/11/2024 01:14:17.0863 516 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 09/11/2024 01:16:18.5562 1290 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 09/11/2024 01:21:31.2585 543 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 09/11/2024 01:23:36.4779 2042 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 09/11/2024 01:25:23.3281 743 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 09/11/2024 01:26:12.6970 1238 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 09/11/2024 01:33:10.2051 2153 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 09/11/2024 01:35:07.3901 699 ms. EXEC: insert into payPayment (payCreation,payUseId,payStatus,payUID,payTraUID,payYear,payDateTime,payIdTerminal,payEnabled,payDisableTime,payTarId,payTimeLimit,payType,payCurrency,payAmount,payPayed,payChange,payCardType,payPAN,paySTAN,payIdEvent,payVatPercent,payVatAmount) VALUES ('2024-11-09 01:35:06',0,'V',5192064258019530,5489880149703840,2024,'2024-11-09 01:35:06',2,1,0,-1,'2024-11-09 02:35:06','S','KES',0,0,0,'','','',3,0,0) 09/11/2024 01:39:33.9337 769 ms. OPEN: select * from tabArea where areStatus='V' and areEnabled = 1 AND areId = 1 09/11/2024 01:42:29.0323 1009 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,'2024-11-09 01:42:28','V',4797670854199650,2024,'2024-11-09 01:42:26','456030614600327005012999',1,2,16,'I','',1,0,1,'','',4) 09/11/2024 01:43:02.8859 564 ms. EXECSCALAR: select count(*) from information_schema.tables where table_schema= 'wisepark_0327' and table_name= 'payInvoiceFtp' nr: 1 09/11/2024 01:46:12.2080 618 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 09/11/2024 02:33:04.6959 869 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 09/11/2024 02:33:40.4987 1521 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 09/11/2024 02:34:04.8029 709 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 09/11/2024 02:42:17.8834 533 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 09/11/2024 02:43:00.7239 1847 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 09/11/2024 02:44:57.2325 568 ms. EXEC: insert into payReceipt (recTraUID,recPayUID,recYear,recDateTime,recText,recInvalid) VALUES (4797670854199650,5493192610200200,2024,'2024-11-09 02:44:56','---------------------------------- %The Mall P0006032390 End of payment ---------------------------------- POF Entry : 11/9/2024 1:42:26 AM Date : 11/9/2024 2:44:55 AM Code : 456030614600327005012999 Total : 100.00 KES VAT 16% : 13.79 KES ---------------------------------- Paid : 100.00 KES Coin changed : 0.00 KES Note changed : 0.00 KES',0) 09/11/2024 02:44:57.7689 534 ms. EXEC: update payReceipt set recCreation = '2024-11-09 02:44:57',recModify = '2024-11-09 02:44:57',recUseId=0,recStatus='V' where recId = 320758 09/11/2024 02:46:47.9233 1168 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 09/11/2024 02:46:56.3489 731 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 09/11/2024 02:51:50.0815 2526 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 09/11/2024 02:55:03.1281 501 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 09/11/2024 02:56:53.7949 533 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 09/11/2024 03:00:13.3558 842 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 09/11/2024 03:04:14.8947 515 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 09/11/2024 03:09:44.4012 608 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 09/11/2024 03:13:22.7657 823 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 09/11/2024 03:13:32.5252 744 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 09/11/2024 03:14:37.4154 1005 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 09/11/2024 03:17:30.1695 703 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,'2024-11-09 03:17:29','V',5517090014881020,2024,'2024-11-09 03:17:28','456030856600327005012999',2,2,2,'O','',0,'2024-11-09 03:17:29',1,'','',0) 09/11/2024 03:17:30.9690 790 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 09/11/2024 03:17:36.3666 786 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 09/11/2024 03:19:13.2922 1143 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 09/11/2024 03:37:40.0324 709 ms. OPEN: select * from tabArea where areStatus='V' and areEnabled = 1 AND areId = 1 09/11/2024 03:48:54.9050 764 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 09/11/2024 03:50:32.5891 601 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 09/11/2024 03:52:42.5796 530 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 09/11/2024 03:55:38.3187 598 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 09/11/2024 03:55:38.5929 608 ms. EXECSCALAR: select count(*) from information_schema.tables where table_schema= 'wisepark_0327' and table_name= 'payInvoiceFtp' nr: 1 09/11/2024 03:58:35.8890 626 ms. OPEN: select * from tabArea where areStatus='V' and areEnabled = 1 AND areId = 1 09/11/2024 04:08:18.0888 605 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 09/11/2024 04:15:58.5616 1008 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 09/11/2024 04:15:58.5636 1092 ms. OPEN: select useParkAccess from tabUser where (useBadId = '456030617600327005012999' or useBadId = '456030617600327005012999') 09/11/2024 04:15:59.2941 682 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2024-11-09 04:15:58' where payTraUID = 5131398105284010 and payStatus='V' and payEnabled=1 09/11/2024 04:16:06.7140 554 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 09/11/2024 04:19:36.3397 895 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 09/11/2024 04:20:20.0308 853 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 09/11/2024 04:31:05.6368 534 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 09/11/2024 04:31:51.4924 538 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 09/11/2024 04:39:23.0382 518 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 09/11/2024 04:40:32.9427 727 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 09/11/2024 04:41:56.4414 598 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 09/11/2024 04:42:53.3703 810 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 09/11/2024 04:46:24.1277 1184 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 09/11/2024 04:46:56.0519 1314 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 5 and terStatus='V' 09/11/2024 04:50:25.5275 578 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 09/11/2024 04:55:02.6481 2409 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 09/11/2024 04:57:45.5826 1256 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 09/11/2024 05:03:17.5618 541 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 09/11/2024 05:05:21.4983 519 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 09/11/2024 05:06:43.9733 684 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 09/11/2024 05:14:15.8363 639 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 09/11/2024 05:18:29.8325 534 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 09/11/2024 05:19:13.5106 686 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 09/11/2024 05:22:20.7533 765 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 09/11/2024 05:25:31.3333 1042 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 09/11/2024 05:43:00.0028 609 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 09/11/2024 05:53:04.5916 580 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 09/11/2024 05:56:22.0561 610 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 16 OR lnsTerId=16) 09/11/2024 05:56:28.8887 901 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,'2024-11-09 05:56:27','V',4765992861442200,2024,'2024-11-09 05:56:27','456032138700327005012999',1,2,16,'I','',1,0,1,'','0230004098567',165,0) 09/11/2024 05:56:34.6385 540 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 09/11/2024 05:58:56.4580 638 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 09/11/2024 06:00:29.7822 947 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 09/11/2024 06:05:43.3580 1548 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 09/11/2024 06:07:05.5088 711 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 09/11/2024 06:08:46.5171 1117 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 2 OR lnsTerId=2) 09/11/2024 06:08:48.3103 787 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 09/11/2024 06:11:48.8355 558 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 09/11/2024 06:17:18.2439 509 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 09/11/2024 06:17:20.1252 714 ms. EXEC: insert into payPayment (payCreation,payUseId,payStatus,payUID,payTraUID,payYear,payDateTime,payIdTerminal,payEnabled,payDisableTime,payTarId,payTimeLimit,payType,payCurrency,payAmount,payPayed,payChange,payCardType,payPAN,paySTAN,payIdEvent,payVatPercent,payVatAmount) VALUES ('2024-11-09 06:17:19',0,'V',5350635985238960,4765992861442200,2024,'2024-11-09 06:17:19',2,1,0,-1,'2024-11-09 07:17:19','S','KES',0,0,0,'','','',3,0,0) 09/11/2024 06:17:21.8353 825 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 09/11/2024 06:17:25.5038 746 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 09/11/2024 06:20:52.4446 576 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,'2024-11-09 06:20:51','V',5380801977519710,2024,'2024-11-09 06:20:50','456032285000327005012999',1,2,16,'I','',1,0,1,'','',4) 09/11/2024 06:23:19.2404 2367 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 09/11/2024 06:23:21.3748 524 ms. EXEC: update paycash set casCreation = '2024-11-09 06:23:20',casModify = '2024-11-09 06:23:20',casUseId=0,casStatus='V' where casId = 193919 09/11/2024 06:24:54.8651 707 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 09/11/2024 06:26:17.5572 834 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 09/11/2024 06:26:44.4081 999 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 09/11/2024 06:28:06.6109 1284 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 09/11/2024 06:28:53.8253 1237 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 09/11/2024 06:29:10.7636 577 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 09/11/2024 06:31:11.7672 525 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 09/11/2024 06:34:41.0936 2484 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 09/11/2024 06:36:51.0432 594 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 09/11/2024 06:37:00.5005 2019 ms. EXEC: insert into payReceipt (recTraUID,recPayUID,recYear,recDateTime,recText,recInvalid) VALUES (5380801977519710,5101796303292470,2024,'2024-11-09 06:36:58',' Date: 11/9/2024 6:34:32 AM Code: 456032285000327005012999 Entry Date: 11/9/2024 6:20:50 AM Plate: Class: Cars Park: The Mall Gate: Entry 2 ______________________________ Total: 50.00 KES ______________________________ Paid: 50.00 KES __________ Change: 0.00 KES Type: Credit Card Dispozitiv: Manual Cashier 1 # 2400415832 ',0) 09/11/2024 06:39:14.5898 1558 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,'2024-11-09 06:39:13','V',4980720427103870,2024,'2024-11-09 06:39:12','456032285000327005012999',2,2,2,'O','',0,'2024-11-09 06:39:13',1,'','',0) 09/11/2024 06:40:01.4650 770 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 09/11/2024 06:40:18.2472 541 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 09/11/2024 06:41:10.2649 1839 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 09/11/2024 06:48:08.2273 815 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 09/11/2024 06:48:08.2273 652 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 2 and terStatus='V' 09/11/2024 06:50:08.3483 3744 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 09/11/2024 06:50:59.6005 513 ms. EXEC: update payInventory set invCreation = '2024-11-09 06:50:59',invModify = '2024-11-09 06:50:59',invUseId=0,invStatus='V' where invId = 218102 09/11/2024 06:51:01.7689 555 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 09/11/2024 06:53:06.1898 567 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 09/11/2024 06:53:07.1484 889 ms. EXECSCALAR: select count(*) from payInventory where invChannel=2 and invCode=2 and invDevice=41101 nr: 0 09/11/2024 06:55:41.7704 1158 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 09/11/2024 06:58:12.8851 676 ms. EXEC: insert into payPayment (payCreation,payUseId,payStatus,payUID,payTraUID,payYear,payDateTime,payIdTerminal,payEnabled,payDisableTime,payTarId,payTimeLimit,payType,payCurrency,payAmount,payPayed,payChange,payCardType,payPAN,paySTAN,payIdEvent,payVatPercent,payVatAmount) VALUES ('2024-11-09 06:58:12',0,'V',5305521947396830,4914649626642760,2024,'2024-11-09 06:58:12',2,1,0,-1,'2024-11-09 07:58:12','S','KES',0,0,0,'','','',3,0,0) 09/11/2024 06:58:15.5088 1514 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2024-11-09 06:58:13' where traUID = 4914649626642760 and traStatus='V' and traEnabled=1 09/11/2024 06:58:18.8050 1015 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 09/11/2024 06:59:10.2143 609 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 09/11/2024 06:59:30.7119 977 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2024-11-09 06:59:29',3,42101,0,100,1,100,1,'I','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'; 09/11/2024 06:59:32.3881 1098 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2024-11-09 06:59:31',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'; 09/11/2024 06:59:32.9564 561 ms. EXEC: update payInventory set invCreation = '2024-11-09 06:59:32',invModify = '2024-11-09 06:59:32',invUseId=0,invStatus='V' where invId = 218107 09/11/2024 07:01:00.2036 1288 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 09/11/2024 07:01:28.0071 527 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,'2024-11-09 07:01:27','V',4925670975914310,2024,'2024-11-09 07:01:26','456032211100327005012999',2,2,2,'O','',0,'2024-11-09 07:01:27',1,'','',0) 09/11/2024 07:02:03.8850 1326 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 09/11/2024 07:02:40.2952 728 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 09/11/2024 07:04:39.6437 1134 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 09/11/2024 07:07:44.5639 568 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 09/11/2024 07:07:51.9498 1437 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 1 OR lnsTerId=1) 09/11/2024 07:08:30.3324 1436 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 09/11/2024 07:11:08.6018 1801 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 09/11/2024 07:11:29.6158 538 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 09/11/2024 07:12:34.4420 673 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 09/11/2024 07:15:51.9176 728 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 4 09/11/2024 07:33:41.3790 771 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 09/11/2024 07:39:59.1066 536 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 09/11/2024 07:46:22.7762 1132 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 ('2024-11-09 07:46:21',0,'V',4757286399254050,4895520508621330,2024,'2024-11-09 07:46:21',18,1,0,4,'2024-11-09 08:01:21','C','KES',50,50,0,'','','',1,50,0,0,'',0,0) 09/11/2024 07:53:30.2870 713 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 09/11/2024 07:54:52.6288 731 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 09/11/2024 08:03:35.9605 540 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 09/11/2024 08:04:06.9581 561 ms. EXEC: update payReceipt set recCreation = '2024-11-09 08:04:06',recModify = '2024-11-09 08:04:06',recUseId=0,recStatus='V' where recId = 320779 09/11/2024 08:06:44.5611 918 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 09/11/2024 08:08:35.3469 2992 ms. EXEC: insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2024-11-09 08:08:21',5,3,42101,0,50,-23,-1150,1,'O','N'); insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2024-11-09 08:08:21',5,3,42101,0,50,23,1150,2,'I','N'); insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2024-11-09 08:08:21',5,3,42101,0,100,-41,-4100,1,'O','N'); insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2024-11-09 08:08:21',5,3,42101,0,100,41,4100,2,'I','N'); insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2024-11-09 08:08:21',5,3,42101,0,200,-1,-200,1,'O','N'); insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2024-11-09 08:08:21',5,3,42101,0,200,1,200,2,'I','N'); insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2024-11-09 08:08:21',5,3,42101,0,1000,-2,-2000,1,'O','N'); insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2024-11-09 08:08:21',5,3,42101,0,1000,2,2000,2,'I','N'); insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2024-11-09 08:08:21',5,3,42101,1,0,0,0,1,'O',''); update payCurInventory set curQuantity=0,curAmount=0 where curQuantity<0; 09/11/2024 08:08:37.6714 1217 ms. EXEC: insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2024-11-09 08:08:36',5,3,0,3,0,0,0,0,'3','') 09/11/2024 08:09:03.1344 821 ms. EXEC: INSERT INTO movOperator (opeCreation,opeUseId,opeTerId,opeDateTime,opeCode,opeDescription) VALUES ('2024-11-09 08:09:02',0,3,'2024-11-09 08:09:02','0230003944086','POF - User Transit Supervisor Supervisor') 09/11/2024 08:10:28.3552 958 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 09/11/2024 08:10:34.5583 685 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 09/11/2024 08:17:53.0334 646 ms. EXECSCALAR: SELECT parLostTicketNoArea FROM tabParameters ORDER BY parId DESC LIMIT 1 nr: 0 09/11/2024 08:18:38.5297 1711 ms. EXECSCALAR: select count(resId) as Tot from movReservation where resStatus = 'V' and resTypeRes = 'B' AND ((resConfirmed IN (0,2,3) AND resCreation>'2024-11-09 07:18:36') OR resConfirmed IN (4,5)) and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) <= '2024-11-09 08:18:36' and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) >= '2024-11-09 08:18:36' and (resAreId = 1 or resAreId <= 0) nr: 0 09/11/2024 08:21:11.5096 947 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 09/11/2024 08:21:44.3015 520 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,'2024-11-09 08:21:43','V',5728775436500190,2024,'2024-11-09 08:21:42','456032835400327005012999',2,2,2,'O','',0,'2024-11-09 08:21:43',1,'','',0) 09/11/2024 08:25:51.5301 703 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 09/11/2024 08:26:28.8600 602 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 09/11/2024 08:26:52.8320 757 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 09/11/2024 08:29:34.8159 1268 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 09/11/2024 08:30:34.1294 511 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 09/11/2024 08:36:43.2603 793 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 09/11/2024 08:38:27.0564 502 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 09/11/2024 08:47:48.0922 747 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2024-11-09 08:47:47',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'; 09/11/2024 08:49:15.7546 675 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 3 and terStatus='V' 09/11/2024 08:49:57.5034 611 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 09/11/2024 08:50:00.7776 658 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,'2024-11-09 08:50:00','V',5636388698905430,2024,'2024-11-09 08:49:59','456033001600327005012999',2,2,2,'O','',0,'2024-11-09 08:50:00',1,'','',0) 09/11/2024 08:50:01.3409 609 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 09/11/2024 08:51:06.6094 753 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 09/11/2024 08:51:48.3962 580 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 2 OR lnsTerId=2) 09/11/2024 08:52:24.4343 944 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 09/11/2024 08:59:29.6895 541 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 09/11/2024 08:59:30.5721 787 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 09/11/2024 09:00:40.0834 663 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 09/11/2024 09:02:02.0540 987 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 09/11/2024 09:03:00.3239 604 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 09/11/2024 09:08:31.9948 698 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 09/11/2024 09:13:34.8786 533 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 09/11/2024 09:15:41.8581 2121 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 09/11/2024 09:21:35.6168 3361 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 09/11/2024 09:23:35.6748 2646 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 09/11/2024 09:24:36.1471 812 ms. EXECSCALAR: select count(*) from information_schema.tables where table_schema= 'wisepark_0327' and table_name= 'payInvoiceFtp' nr: 1 09/11/2024 09:24:38.2074 1903 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 09/11/2024 09:25:42.7314 546 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 09/11/2024 09:25:47.8018 563 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 ('2024-11-09 09:25:47',0,'V',5715712332221590,4771107565996750,2024,'2024-11-09 09:25:47',18,1,0,4,'2024-11-09 09:40:47','C','KES',50,50,0,'','','',1,50,0,0,'',0,0) 09/11/2024 09:25:48.6664 620 ms. EXEC: update payReceipt set recCreation = '2024-11-09 09:25:48',recModify = '2024-11-09 09:25:48',recUseId=0,recStatus='V' where recId = 320786 09/11/2024 09:28:14.8528 593 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 09/11/2024 09:29:19.0145 534 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,'2024-11-09 09:29:18','V',4683539671921440,2024,'2024-11-09 09:29:15','456033154000327001012999',2,2,2,'O','',0,'2024-11-09 09:29:18',1,'','',0) 09/11/2024 09:29:20.5795 937 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2024-11-09 09:29:19' where traUID = 4745616773055680 and traStatus='V' and traEnabled=1 09/11/2024 09:29:24.1679 780 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 09/11/2024 09:34:02.3813 811 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,'2024-11-09 09:34:01','V',5315924473489810,2024,'2024-11-09 09:34:01','456033444100327005012999',1,2,16,'I','',1,0,1,'','',4) 09/11/2024 09:34:21.9543 546 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 5 09/11/2024 09:37:44.2391 1436 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 09/11/2024 09:37:44.8545 593 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 09/11/2024 09:38:10.5156 849 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 09/11/2024 09:38:17.0129 1919 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 09/11/2024 09:43:07.2973 685 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 4 OR lnsTerId=4) 09/11/2024 09:43:39.4447 538 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 09/11/2024 09:43:48.8589 631 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 09/11/2024 09:44:06.6228 1981 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 16 OR lnsTerId=16) 09/11/2024 09:44:12.1505 755 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 09/11/2024 09:46:37.6944 666 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 09/11/2024 09:48:02.1797 867 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 09/11/2024 09:48:58.9365 560 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 09/11/2024 09:49:40.9645 966 ms. OPEN: select * from tabArea where areStatus='V' and areEnabled = 1 AND areId = 1 09/11/2024 09:50:06.7507 1177 ms. EXECSCALAR: select count(*) from tabTerminalExtraMem where extStatus='V' and extTerId = 16 nr: 1 09/11/2024 09:50:10.5982 1887 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 09/11/2024 09:50:17.4808 1053 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 09/11/2024 09:50:18.0782 594 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 09/11/2024 09:50:27.3144 675 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 09/11/2024 09:50:33.9778 564 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 09/11/2024 09:50:49.5332 718 ms. EXEC: insert into payReceipt (recTraUID,recPayUID,recYear,recDateTime,recText,recInvalid) VALUES (5200150539382190,5081330052889000,2024,'2024-11-09 09:50:48','---------------------------------- %The Mall P0006032390 End of payment ---------------------------------- POF Entry : 11/9/2024 9:22:56 AM Date : 11/9/2024 9:50:46 AM Code : 456033377600327001012999 Total : 50.00 KES VAT 16% : 6.90 KES ---------------------------------- Paid : 100.00 KES Coin changed : 0.00 KES Note changed : 0.00 KES Not changed Note : 0.00 KES Coin : 0.00 KES Unavailable : 50.00 KES',0) 09/11/2024 09:50:52.0859 853 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 09/11/2024 09:53:50.5728 535 ms. OPEN: show columns from tabParameters where Field = 'parAllowNegativePlaces' 09/11/2024 09:53:50.8850 611 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 09/11/2024 09:53:59.0664 828 ms. EXEC: insert into movOperator (opeCreation,opeTerId,opeUseId,opeDateTime,opeCode,opeDescription) VALUES ('2024-11-09 09:53:58',4,1,'2024-11-09 09:53:58','456033508100327005012999','Payed (Credit Card ) Ticket ') 09/11/2024 09:54:50.9870 2722 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 09/11/2024 09:57:33.5093 1072 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 09/11/2024 09:58:17.7007 796 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 1 09/11/2024 10:01:26.6836 949 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 09/11/2024 10:01:48.1429 779 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 09/11/2024 10:01:53.7947 1000 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 09/11/2024 10:02:20.8437 559 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,'2024-11-09 10:02:20','V',5740318021318200,2024,'2024-11-09 10:02:19','456033613900327005012999',1,2,16,'I','',1,0,1,'','0230003944064',14,0) 09/11/2024 10:02:21.4811 634 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 09/11/2024 10:02:23.3994 1917 ms. EXEC: update abbCards set carLastDate = '2024-11-09 10:02:21',carLastDirection='I' where carStatus='V' and carId = 14 09/11/2024 10:02:29.9027 667 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 09/11/2024 10:04:59.6865 541 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 09/11/2024 10:05:26.7986 622 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 ('2024-11-09 10:05:24',0,'V',5580021299243490,4873501894352130,2024,'2024-11-09 10:05:24',3,1,0,4,'2024-11-09 10:20:24','C','KES',50,100,50,'',' ',' ',1,50,0,0,'',0,0) 09/11/2024 10:05:49.0654 3766 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 09/11/2024 10:06:08.0601 3250 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 09/11/2024 10:07:13.9560 583 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 09/11/2024 10:09:05.0930 1628 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 5 and terStatus='V' 09/11/2024 10:09:12.8171 1231 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,'2024-11-09 10:09:11','V',5419613775867230,2024,'2024-11-09 10:09:11','456033655100327005012999',1,2,16,'I','',1,0,1,'','',4) 09/11/2024 10:09:18.7411 554 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 09/11/2024 10:09:21.7501 811 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 09/11/2024 10:10:39.2787 786 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 09/11/2024 10:13:46.5095 917 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,'2024-11-09 10:13:45','V',5252020852002460,2024,'2024-11-09 10:13:44','456033468900327005012999',2,2,2,'O','',0,'2024-11-09 10:13:45',1,'','',0) 09/11/2024 10:13:53.6932 543 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 09/11/2024 10:14:06.8370 894 ms. EXEC: update abbSubscriptions set subCredit = round(subCredit-0,5),subLastDebit = '2024-11-09 10:14:05' where subId = 15 09/11/2024 10:14:08.3720 572 ms. EXEC: update abbCards set carLastDate = '2024-11-09 10:14:07',carLastDirection='O' where carStatus='V' and carId = 14 09/11/2024 10:14:09.9441 1167 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2024-11-09 10:14:08' where payTraUID = 5740318021318200 and payStatus='V' and payEnabled=1 09/11/2024 10:15:02.8913 1368 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 09/11/2024 10:15:45.4597 560 ms. EXECSCALAR: SELECT traId FROM movTransit WHERE traStatus='V' AND traCode = @traCode nr: 773082 09/11/2024 10:15:53.4920 742 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 09/11/2024 10:16:02.4110 534 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 ('2024-11-09 10:16:01',0,'V',5460940695018560,5242765472587950,2024,'2024-11-09 10:16:01',18,1,0,4,'2024-11-09 10:31:01','C','KES',100,100,0,'','','',1,100,0,0,'',0,0) 09/11/2024 10:16:03.1004 623 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 2 OR lnsTerId=2) 09/11/2024 10:16:40.9727 1146 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 ('2024-11-09 10:14:14',1,'V',4945213118963040,4940887514214350,2024,'2024-11-09 10:14:14',4,1,0,4,'2024-11-09 10:29:14','P','KES',100,100,0,'','','',1,100,0,0,'',0,0) 09/11/2024 10:17:04.6044 722 ms. OPEN: select sum(crc32(terDescription)) as vCheck from tabTerminal 09/11/2024 10:17:05.7992 1905 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 09/11/2024 10:18:01.7765 597 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 3 09/11/2024 10:18:03.3345 746 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2024-11-09 10:18:02',3,42101,0,100,1,100,1,'I','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'; 09/11/2024 10:18:04.4863 736 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2024-11-09 10:18:03',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'; 09/11/2024 10:18:50.7061 536 ms. EXECSCALAR: select count(*) from information_schema.tables where table_schema= 'wisepark_0327' and table_name= 'payInvoiceFtp' nr: 1 09/11/2024 10:19:48.2604 769 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 09/11/2024 10:20:00.4185 679 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 09/11/2024 10:20:27.8088 802 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 09/11/2024 10:21:55.2130 821 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,'2024-11-09 10:21:54','V',5422320617500470,2024,'2024-11-09 10:21:53','456033731300327005012999',1,2,16,'I','',1,0,1,'','',4) 09/11/2024 10:25:21.0521 1096 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 09/11/2024 10:26:11.8249 569 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 2 OR lnsTerId=2) 09/11/2024 10:27:40.3309 965 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,'2024-11-09 10:27:39','V',5108119265839480,2024,'2024-11-09 10:27:38','456033634400327005012999',2,2,2,'O','',0,'2024-11-09 10:27:39',1,'','',0) 09/11/2024 10:27:45.4763 569 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 09/11/2024 10:28:19.3739 1116 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 09/11/2024 10:28:45.7695 661 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,'2024-11-09 10:28:45','V',5290003853757360,2024,'2024-11-09 10:28:43','456033772300327005012999',1,2,16,'I','',1,0,1,'','',4) 09/11/2024 10:29:41.1494 1052 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 09/11/2024 10:30:15.5753 673 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 09/11/2024 10:30:16.8932 972 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,'2024-11-09 10:30:15','V',4895369478118120,2024,'2024-11-09 10:30:06','456026025800327005012999',2,2,2,'O','',0,'2024-11-09 10:30:15',1,'','0230003950896',20,0) 09/11/2024 10:30:33.2271 684 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,'2024-11-09 10:30:32','V',5530968533034360,2024,'2024-11-09 10:30:21','456033634500327002029999',2,1,2,'O','',1,0,1,'','0532370684208',20,0) 09/11/2024 10:31:11.8348 792 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 09/11/2024 10:34:20.7617 1309 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 09/11/2024 10:35:36.1419 1974 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 09/11/2024 10:43:42.3497 566 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 09/11/2024 10:48:10.4413 949 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 09/11/2024 10:49:49.0000 663 ms. EXEC: UPDATE payInventory SET invType='N' WHERE invType<>'N' AND invValue IN (100,200,500) AND invDevice IN (42102,42101,42001); 09/11/2024 10:50:21.5567 1247 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 09/11/2024 10:51:52.4292 1988 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 09/11/2024 10:51:56.1727 676 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 16 OR lnsTerId=16) 09/11/2024 10:52:21.8518 735 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 09/11/2024 10:55:01.9725 679 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 09/11/2024 10:56:11.6249 563 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 09/11/2024 10:57:38.6468 579 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 09/11/2024 11:01:47.8789 761 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 09/11/2024 11:04:25.3918 1277 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,'2024-11-09 11:04:24','V',5589798476928610,2024,'2024-11-09 11:04:23','456033986300327005012999',1,2,16,'I','',1,0,1,'','',4) 09/11/2024 11:05:23.9248 1109 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,'2024-11-09 11:05:22','V',5020839404586690,2024,'2024-11-09 11:05:22','456033992200327005012999',1,2,16,'I','',1,0,1,'','0750009518612',99,0) 09/11/2024 11:05:57.1419 587 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 5 and terStatus='V' 09/11/2024 11:06:01.1716 585 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 09/11/2024 11:06:23.6976 739 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 09/11/2024 11:13:02.1921 2719 ms. EXEC: insert into abbPayment (payCreation,payCode,payAmount,payCredit,payPayUID,payCarId,payDateFrom,payDateTo) VALUES ('2024-11-09 11:12:59','0750009518612',0,0,5448030631520800,99,'0000-00-00 00:00:00','0000-00-00 00:00:00') 09/11/2024 11:13:03.6160 816 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2024-11-09 11:13:02' where payTraUID = 5020839404586690 and payStatus='V' and payEnabled=1 09/11/2024 11:13:10.0883 1204 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 09/11/2024 11:14:13.3265 629 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 09/11/2024 11:14:20.3511 621 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 09/11/2024 11:17:41.7013 891 ms. EXEC: update opeActivities set acvFstPayId = (case acvFstPayId when 0 then 369127 else acvFstPayId end),acvLstPayId = 369127 where acvSftId = 822 and acvCodeId = 3 09/11/2024 11:18:07.1012 503 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 09/11/2024 11:18:44.9444 577 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 09/11/2024 11:20:00.0915 767 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 09/11/2024 11:20:17.0998 635 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 ('2024-11-09 11:20:16',0,'V',4890270840211910,5162057460446940,2024,'2024-11-09 11:20:16',18,1,0,4,'2024-11-09 11:35:16','C','KES',50,50,0,'','','',1,50,0,0,'',0,0) 09/11/2024 11:21:44.5580 542 ms. OPEN: select * from payCurInventory where curTerId = 3 and curQuantity>0 and curType in ('C','N') order by curDevCode,curChannelId,curValue 09/11/2024 11:21:56.8442 2125 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 09/11/2024 11:23:13.9446 673 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2024-11-09 11:23:13' where payTraUID = 4862752734285550 and payStatus='V' and payEnabled=1 09/11/2024 11:24:10.5563 837 ms. EXEC: update tabTerminalReceipt set trcProgressive = 7015, trcLastPrinted = '2400607015', trcLastDate = '2024-11-09 11:24:09' where trcStatus='V' and trcTerId = 17 09/11/2024 11:25:34.8444 672 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 09/11/2024 11:25:54.2364 1240 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 09/11/2024 11:26:01.0419 564 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 09/11/2024 11:26:35.7460 624 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 09/11/2024 11:26:37.4462 1064 ms. OPEN: show columns from tabTariff where Field = 'tarCustomMessage' 09/11/2024 11:26:50.3337 2675 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2024-11-09 11:26:47',3,42101,0,100,1,100,1,'I','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'; 09/11/2024 11:27:07.0148 704 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 09/11/2024 11:27:31.4421 521 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 09/11/2024 11:27:32.0906 929 ms. EXECSCALAR: select count(*) from information_schema.tables where table_schema= 'wisepark_0327' and table_name= 'payInvoiceFtp' nr: 1 09/11/2024 11:27:36.5545 638 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 09/11/2024 11:27:48.9088 729 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 09/11/2024 11:28:19.6652 2514 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,'2024-11-09 11:28:17','V',4787176452791290,2024,'2024-11-09 11:28:15','456033930100327005012999',2,2,2,'O','',0,'2024-11-09 11:28:17',1,'','',0) 09/11/2024 11:28:30.0612 873 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 09/11/2024 11:28:31.1439 640 ms. EXEC: update payReceipt set recCreation = '2024-11-09 11:28:30',recModify = '2024-11-09 11:28:30',recUseId=0,recStatus='V' where recId = 320841 09/11/2024 11:30:14.2916 524 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 09/11/2024 11:30:14.5698 723 ms. EXECSCALAR: select count(*) from information_schema.tables where table_schema= 'wisepark_0327' and table_name= 'payInvoiceFtp' nr: 1 09/11/2024 11:30:33.9157 548 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,'2024-11-09 11:30:33','V',4878961781957720,2024,'2024-11-09 11:30:32','456034143200327005012999',1,2,16,'I','',1,0,1,'','',4) 09/11/2024 11:31:36.5304 957 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 09/11/2024 11:31:40.5931 639 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2024-11-09 11:31:39',3,42101,0,200,1,200,1,'I','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'; 09/11/2024 11:31:45.0551 1913 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 09/11/2024 11:32:28.6751 698 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 09/11/2024 11:32:30.2672 841 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 09/11/2024 11:32:50.9129 1131 ms. EXECSCALAR: select count(*) from information_schema.tables where table_schema= 'wisepark_0327' and table_name= 'payInvoiceFtp' nr: 1 09/11/2024 11:32:51.6764 628 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 09/11/2024 11:33:04.8062 780 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 09/11/2024 11:33:52.5360 1430 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 09/11/2024 11:34:10.2868 665 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,'2024-11-09 11:34:09','V',5683379918068330,2024,'2024-11-09 11:34:09','456034164900327005012999',1,2,16,'I','',1,0,1,'','',4) 09/11/2024 11:34:10.8432 550 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 09/11/2024 11:34:15.5373 703 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 09/11/2024 11:34:29.8939 1523 ms. OPEN: select sum(payPayed) as vTot from payPayment inner join tabTerminal on terId = payIdTerminal where payStatus='V' and terType=4 and terStatus='V' and payTraUID = 4958396230174890 09/11/2024 11:34:36.2741 595 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 09/11/2024 11:34:45.0940 992 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 ('2024-11-09 11:34:44',0,'V',5191788111764100,5720726474482130,2024,'2024-11-09 11:34:44',18,1,0,4,'2024-11-09 11:49:44','C','KES',50,50,0,'','','',1,50,0,0,'',0,0) 09/11/2024 11:35:56.8978 506 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 09/11/2024 11:36:00.0930 1109 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 09/11/2024 11:36:21.5372 571 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 09/11/2024 11:37:46.7870 669 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2024-11-09 11:37:45',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'; 09/11/2024 11:37:58.6920 898 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,'2024-11-09 11:37:57','V',4920428338736220,2024,'2024-11-09 11:37:57','456034187700327005012999',1,2,16,'I','',1,0,1,'','',4) 09/11/2024 11:37:59.8617 797 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 09/11/2024 11:41:18.9974 676 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 09/11/2024 11:41:30.5231 909 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 09/11/2024 11:41:39.9263 904 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 3 OR lnsTerId=3) 09/11/2024 11:42:05.8326 620 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 09/11/2024 11:44:37.6427 564 ms. EXEC: INSERT INTO movOperator (opeCreation,opeUseId,opeTerId,opeDateTime,opeCode,opeDescription) VALUES ('2024-11-09 11:44:37',0,2,'2024-11-09 11:44:37','0230003944086','Exit 1 - User Transit Supervisor Supervisor') 09/11/2024 11:45:22.9739 816 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 09/11/2024 11:45:23.7514 683 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2024-11-09 11:45:23' where payTraUID = 5022282067109390 and payStatus='V' and payEnabled=1 09/11/2024 11:45:35.5033 788 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 09/11/2024 11:47:00.7290 962 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 09/11/2024 11:47:51.7760 511 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 09/11/2024 11:48:25.3054 733 ms. EXEC: update paycash set casCreation = '2024-11-09 11:48:24',casModify = '2024-11-09 11:48:24',casUseId=0,casStatus='V' where casId = 193975 09/11/2024 11:48:26.6593 727 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2024-11-09 11:48:25',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'; 09/11/2024 11:49:19.4164 683 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 2 OR lnsTerId=2) 09/11/2024 11:49:19.4244 619 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 09/11/2024 11:50:34.9918 686 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 09/11/2024 11:52:05.2119 530 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 1 09/11/2024 11:53:57.1134 558 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2024-11-09 11:53:56',3,42101,0,100,1,100,1,'I','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'; 09/11/2024 11:54:28.8476 567 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 09/11/2024 11:54:32.1868 1477 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 09/11/2024 11:57:21.7117 617 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 09/11/2024 11:58:06.0242 894 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 09/11/2024 11:59:33.1653 851 ms. EXEC: update abbSubscriptions set subCredit = round(subCredit-0,5),subLastDebit = '2024-11-09 11:59:32' where subId = 27 09/11/2024 11:59:34.1950 535 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,'2024-11-09 11:59:33','V',4983310855288190,2024,'2024-11-09 11:59:30','456033109400327005012999',2,2,2,'O','',0,'2024-11-09 11:59:33',1,'','0230003957444',26,0) 09/11/2024 11:59:35.3297 519 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 6 09/11/2024 11:59:35.3307 519 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 09/11/2024 11:59:35.8711 1228 ms. EXEC: update abbCards set carLastDate = '2024-11-09 11:59:34',carLastDirection='O' where carStatus='V' and carId = 26 09/11/2024 11:59:36.0012 616 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 09/11/2024 11:59:36.6126 551 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2024-11-09 11:59:36' where payTraUID = 4659815067143150 and payStatus='V' and payEnabled=1 09/11/2024 12:02:13.6292 859 ms. EXEC: update abbCards set carLastDate = '2024-11-09 12:02:12',carLastDirection='I' where carStatus='V' and carId = 12 09/11/2024 12:03:37.2369 888 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 09/11/2024 12:03:46.6671 1677 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2024-11-09 12:03:44' where traUID = 4955482143421130 and traStatus='V' and traEnabled=1 09/11/2024 12:08:07.6120 625 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 09/11/2024 12:08:18.3421 512 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 09/11/2024 12:10:08.2173 2177 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 09/11/2024 12:13:47.6945 624 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 09/11/2024 12:15:05.7545 521 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 (WAIT TIME 1875 ms.) 09/11/2024 12:18:47.3101 609 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,'2024-11-09 12:18:46','V',4860829358343030,2024,'2024-11-09 12:18:45','456034432500327005012999',1,2,16,'I','',1,0,1,'','',4) 09/11/2024 12:21:53.7583 1013 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 09/11/2024 12:22:03.8590 577 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,'2024-11-09 12:22:03','V',4843702950945590,2024,'2024-11-09 12:21:59','456034451900327005012999',1,2,16,'I','',1,0,1,'','',4) 09/11/2024 12:22:10.7256 794 ms. EXEC: insert into payReceipt (recTraUID,recPayUID,recYear,recDateTime,recText,recInvalid) VALUES (4767786815240820,5107624554034400,2024,'2024-11-09 12:22:09',' Date: 11/9/2024 12:22:09 PM Code: 456034210800327005012999 Entry Date: 11/9/2024 11:41:48 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 # 2400748959 ',0) 09/11/2024 12:25:13.1541 565 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 09/11/2024 12:26:19.7955 620 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 17 OR lnsTerId=17) 09/11/2024 12:26:19.7995 627 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 4 09/11/2024 12:27:57.5286 745 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 09/11/2024 12:28:23.3248 671 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 09/11/2024 12:31:15.9648 609 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 5 09/11/2024 12:31:45.2994 633 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 09/11/2024 12:32:08.8471 622 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 09/11/2024 12:38:56.9959 1232 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 09/11/2024 12:39:48.4983 1552 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 09/11/2024 12:41:53.6396 1005 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 09/11/2024 12:42:21.6433 640 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 09/11/2024 12:42:34.1506 677 ms. EXEC: insert into payReceipt (recTraUID,recPayUID,recYear,recDateTime,recText,recInvalid) VALUES (4854911643636330,5066192873302190,2024,'2024-11-09 12:42:33','---------------------------------- %The Mall P0006032390 End of payment ---------------------------------- POF Entry : 11/9/2024 12:21:40 PM Date : 11/9/2024 12:42:31 PM Code : 456034450000327005012999 Total : 50.00 KES VAT 16% : 6.90 KES ---------------------------------- Paid : 50.00 KES Coin changed : 0.00 KES Note changed : 0.00 KES',0) 09/11/2024 12:43:47.1252 635 ms. EXEC: insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2024-11-09 12:43:46',5,3,0,2,0,0,0,0,'2','') 09/11/2024 12:45:14.5264 566 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 09/11/2024 12:45:19.2126 548 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 09/11/2024 12:45:37.9110 513 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 09/11/2024 12:45:54.2709 605 ms. EXEC: update payReceipt set recCreation = '2024-11-09 12:45:53',recModify = '2024-11-09 12:45:53',recUseId=0,recStatus='V' where recId = 320882 09/11/2024 12:47:08.6465 610 ms. EXEC: UPDATE payInventory SET invType='N' WHERE invType<>'N' AND invValue IN (100,200,500) AND invDevice IN (42102,42101,42001); 09/11/2024 12:47:40.5987 613 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,'2024-11-09 12:47:39','V',5232613308042420,2024,'2024-11-09 12:47:38','456034605800327005012999',1,2,16,'I','',1,0,1,'','0560008512164',186,0) 09/11/2024 12:47:51.3109 605 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 09/11/2024 12:48:01.1254 530 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2024-11-09 12:48:00',3,42101,0,100,1,100,1,'I','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'; 09/11/2024 12:49:44.4192 504 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 09/11/2024 12:49:56.1360 597 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 09/11/2024 12:50:34.2834 730 ms. EXEC: update payReceipt set recCreation = '2024-11-09 12:50:33',recModify = '2024-11-09 12:50:33',recUseId=0,recStatus='V' where recId = 320887 09/11/2024 12:50:35.1440 840 ms. EXEC: insert into paycash (casCreation,casModify,casUseId,casStatus,casUID,casTraUID,casYear,casDateTime,casIdTerminal,casCurrency,casNumber,casSingleAmount,casTotAmount,casType,casDescription) VALUES ('2024-11-09 12:50:34',0,0,'V',5091356107308060,5033971845366710,2024,'2024-11-09 12:50:34',3,'KES',1,50,50,'N',''); 09/11/2024 12:50:36.1567 575 ms. EXEC: update payInventory set invCreation = '2024-11-09 12:50:35',invModify = '2024-11-09 12:50:35',invUseId=0,invStatus='V' where invId = 218199 09/11/2024 12:50:37.5386 531 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 09/11/2024 12:52:19.3995 642 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 09/11/2024 12:54:30.8851 2438 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 09/11/2024 12:55:28.1372 2840 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 09/11/2024 12:56:04.7526 1573 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2024-11-09 12:56:03',3,42101,0,100,1,100,1,'I','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'; 09/11/2024 12:56:05.2899 536 ms. EXEC: update payInventory set invCreation = '2024-11-09 12:56:04',invModify = '2024-11-09 12:56:04',invUseId=0,invStatus='V' where invId = 218200 09/11/2024 12:56:13.4274 531 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 09/11/2024 12:57:33.7579 578 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 09/11/2024 12:58:22.9186 2762 ms. EXEC: update tabTerminalReceipt set trcProgressive = 48969, trcLastPrinted = '2400748969', trcLastDate = '2024-11-09 12:58:20' where trcStatus='V' and trcTerId = 18 09/11/2024 12:59:15.6698 664 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 09/11/2024 13:01:39.5446 2201 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 09/11/2024 13:04:05.8671 543 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 4 09/11/2024 13:04:57.7687 617 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 16 OR lnsTerId=16) 09/11/2024 13:07:51.0311 618 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 09/11/2024 13:10:08.4656 3610 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2024-11-09 13:10:04',3,42101,0,200,1,200,1,'I','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'; 09/11/2024 13:10:26.4616 626 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 09/11/2024 13:11:27.6984 718 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 6 09/11/2024 13:11:42.3071 636 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 09/11/2024 13:11:59.7057 3150 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 5 and terStatus='V' 09/11/2024 13:11:59.7628 2814 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 09/11/2024 13:12:08.2564 628 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 09/11/2024 13:12:08.8848 509 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 09/11/2024 13:12:37.0266 1343 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 09/11/2024 13:12:37.4469 1288 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 ('2024-11-09 13:12:34',0,'V',4728219408398010,5751472873250780,2024,'2024-11-09 13:12:34',3,1,0,4,'2024-11-09 13:27:34','C','KES',50,100,50,'',' ',' ',1,50,0,0,'',0,0) 09/11/2024 13:12:49.2737 570 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 09/11/2024 13:12:57.1350 679 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 09/11/2024 13:13:53.5646 3468 ms. EXEC: update paycash set casCreation = '2024-11-09 13:13:50',casModify = '2024-11-09 13:13:50',casUseId=0,casStatus='V' where casId = 194000 09/11/2024 13:13:57.3181 3753 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2024-11-09 13:13:49',3,42101,0,100,1,100,1,'I','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'; 09/11/2024 13:15:36.4831 1141 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 09/11/2024 13:15:39.6442 635 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 09/11/2024 13:15:49.2977 650 ms. EXEC: insert into payReceipt (recTraUID,recPayUID,recYear,recDateTime,recText,recInvalid) VALUES (4664741277500670,5489683815956450,2024,'2024-11-09 13:15:48','---------------------------------- %The Mall P0006032390 End of payment ---------------------------------- POF Entry : 11/9/2024 1:04:21 PM Date : 11/9/2024 1:15:47 PM Code : 456034706100327005012999 Total : 50.00 KES VAT 16% : 6.90 KES ---------------------------------- Paid : 100.00 KES Coin changed : 0.00 KES Note changed : 50.00 KES',0) 09/11/2024 13:15:50.2063 545 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2024-11-09 13:15:49',3,42101,0,100,1,100,1,'I','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'; 09/11/2024 13:15:52.3487 1212 ms. EXEC: update payInventory set invCreation = '2024-11-09 13:15:51',invModify = '2024-11-09 13:15:51',invUseId=0,invStatus='V' where invId = 218209 09/11/2024 13:16:14.0582 614 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 09/11/2024 13:16:40.7409 1807 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 09/11/2024 13:17:11.6285 502 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 09/11/2024 13:17:29.5875 1269 ms. EXEC: insert into payPayment (payCreation,payUseId,payStatus,payUID,payTraUID,payYear,payDateTime,payIdTerminal,payEnabled,payDisableTime,payTarId,payTimeLimit,payType,payCurrency,payAmount,payPayed,payChange,payCardType,payPAN,paySTAN,payIdEvent,payVatPercent,payVatAmount) VALUES ('2024-11-09 13:17:28',0,'V',5686294364688350,5232613308042420,2024,'2024-11-09 13:17:28',2,1,0,-1,'2024-11-09 14:17:28','S','KES',0,0,0,'','','',3,0,0) 09/11/2024 13:17:30.3110 716 ms. OPEN: select * from tabUserMessage where useMesDescr = 'msg_scadenza' and (useLanCode = 'en-US' or mid(useLanCode,1,2) = 'en') 09/11/2024 13:17:34.6919 560 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 09/11/2024 13:20:11.6634 1100 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 09/11/2024 13:23:26.6633 645 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 09/11/2024 13:24:03.8091 968 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2024-11-09 13:24:02',3,42101,0,50,2,100,1,'I','N'); update payCurInventory set curQuantity=round(curQuantity+2,5),curAmount=round(curAmount+100,5) where curTerId = 3 and curDevCode = 42101 and curChannelId = 1 and curValue = 50 and curType = 'N'; 09/11/2024 13:25:14.3120 601 ms. EXEC: insert into payReceipt (recTraUID,recPayUID,recYear,recDateTime,recText,recInvalid) VALUES (4913413573008950,5086248434113710,2024,'2024-11-09 13:25:13','---------------------------------- %The Mall P0006032390 End of payment ---------------------------------- POF Entry : 11/9/2024 12:37:32 PM Date : 11/9/2024 1:25:12 PM Code : 456034545200327005012999 Total : 50.00 KES VAT 16% : 6.90 KES ---------------------------------- Paid : 200.00 KES Coin changed : 0.00 KES Note changed : 150.00 KES',0) 09/11/2024 13:26:15.4788 992 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2024-11-09 13:26:14',3,42101,0,200,1,200,1,'I','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'; 09/11/2024 13:26:28.5265 2221 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 09/11/2024 13:26:43.5495 2064 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2024-11-09 13:26:41' where payTraUID = 5144928009825480 and payStatus='V' and payEnabled=1 09/11/2024 13:28:21.5638 506 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2024-11-09 13:28:21' where payTraUID = 4665801237612200 and payStatus='V' and payEnabled=1 09/11/2024 13:28:22.1272 563 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2024-11-09 13:28:21' where traUID = 4665801237612200 and traStatus='V' and traEnabled=1 09/11/2024 13:29:18.0894 1473 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 09/11/2024 13:30:45.2485 788 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 09/11/2024 13:30:45.2495 740 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 2 09/11/2024 13:31:23.9003 797 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 09/11/2024 13:33:25.5993 2620 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 ('2024-11-09 13:33:22',0,'V',4816009285571560,5591212744911930,2024,'2024-11-09 13:33:22',18,1,0,4,'2024-11-09 13:48:22','C','KES',50,50,0,'','','',1,50,0,0,'',0,0) 09/11/2024 13:33:25.6834 738 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 ('2024-11-09 13:33:24',0,'V',5420753084404730,5458479730307640,2024,'2024-11-09 13:33:24',3,1,0,4,'2024-11-09 13:48:24','C','KES',50,50,0,'',' ',' ',1,50,0,0,'',0,0) 09/11/2024 13:35:29.2897 2791 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,'2024-11-09 13:35:26','V',5174502023656810,2024,'2024-11-09 13:35:26','456034892600327005012999',1,2,16,'I','',1,0,1,'','',4) (WAIT TIME 4 ms.) 09/11/2024 13:36:05.3347 558 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 09/11/2024 13:36:17.0886 770 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 09/11/2024 13:36:17.1426 548 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 09/11/2024 13:36:27.0362 1001 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2024-11-09 13:36:25' where traUID = 5458479730307640 and traStatus='V' and traEnabled=1 09/11/2024 13:37:34.7963 1409 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 09/11/2024 13:38:23.9431 512 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 09/11/2024 13:38:46.4390 1023 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 2 OR lnsTerId=2) 09/11/2024 13:38:51.3383 667 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 09/11/2024 13:39:04.1038 593 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 09/11/2024 13:39:20.3446 775 ms. OPEN: select * from tabArea where areStatus='V' and areEnabled = 1 AND areId = 1 09/11/2024 13:39:44.0975 796 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 5 09/11/2024 13:40:38.6218 634 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 09/11/2024 13:40:57.8856 613 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 09/11/2024 13:42:10.4239 899 ms. EXEC: delete from movRoutes where rtsStatus = 'V' and rtsEnabled = 1 and rtsCode = '456034258100327005012999' 09/11/2024 13:42:19.7511 599 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 09/11/2024 13:42:23.6938 635 ms. EXECSCALAR: select count(*) from tabTerminalExtraMem where extStatus='V' and extTerId = 16 nr: 1 09/11/2024 13:42:25.5310 1784 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 2 OR lnsTerId=2) 09/11/2024 13:42:26.3776 658 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,'2024-11-09 13:42:25','V',5441733450597350,2024,'2024-11-09 13:42:24','456034934400327005012999',1,2,16,'I','',1,0,1,'','',4) 09/11/2024 13:43:48.4422 813 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,'2024-11-09 13:43:47','V',5333974253437800,2024,'2024-11-09 13:43:47','456034709900327005012999',2,2,2,'O','',0,'2024-11-09 13:43:47',1,'','',0) 09/11/2024 13:43:49.7991 860 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 09/11/2024 13:43:51.5073 1413 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2024-11-09 13:43:49' where traUID = 5435362663572350 and traStatus='V' and traEnabled=1 09/11/2024 13:43:59.1864 889 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 09/11/2024 13:45:48.1780 564 ms. OPEN: select * from tabTerminalReceipt where trcStatus='V' and trcTerId = 18 order by trcId desc limit 1 09/11/2024 13:47:03.5752 821 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 09/11/2024 13:47:03.7053 2073 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 09/11/2024 13:47:06.1449 740 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 09/11/2024 13:47:28.5539 615 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,'2024-11-09 13:47:27','V',4706383899572010,2024,'2024-11-09 13:47:25','456034528800327005012999',2,2,2,'O','',0,'2024-11-09 13:47:27',1,'','',0) 09/11/2024 13:48:04.9611 950 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 09/11/2024 13:52:08.2652 957 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 09/11/2024 13:52:08.9767 711 ms. EXEC: UPDATE payInventory SET invType='C' WHERE invType<>'C' AND invValue IN (5,10,20,40) AND invDevice IN (41003,41002,41001,41101,41102,41103); 09/11/2024 13:52:22.7128 927 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,'2024-11-09 13:52:21','V',4768449636202850,2024,'2024-11-09 13:52:19','456034993900327001012999',1,2,1,'I','',1,0,1,'','0230003943530',44,0) 09/11/2024 13:52:28.0233 1698 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 09/11/2024 13:52:30.4660 1288 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 09/11/2024 13:54:40.7398 540 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 09/11/2024 13:55:12.6200 574 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 09/11/2024 13:55:14.9125 607 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,'2024-11-09 13:55:14','V',5690796555302370,2024,'2024-11-09 13:55:13','456035011300327005012999',1,2,16,'I','',1,0,1,'','',4) 09/11/2024 13:55:34.9529 1221 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 09/11/2024 13:56:53.8804 794 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 09/11/2024 13:56:57.4188 968 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 09/11/2024 13:57:17.5442 531 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 09/11/2024 13:57:36.4558 585 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 2 09/11/2024 13:57:38.3110 630 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 09/11/2024 13:57:51.1826 1270 ms. EXEC: update paycash set casCreation = '2024-11-09 13:57:49',casModify = '2024-11-09 13:57:49',casUseId=0,casStatus='V' where casId = 194018 09/11/2024 14:00:08.4901 1300 ms. EXEC: update payReceipt set recCreation = '2024-11-09 14:00:07',recModify = '2024-11-09 14:00:07',recUseId=0,recStatus='V' where recId = 320922 09/11/2024 14:01:42.8589 997 ms. EXEC: UPDATE payInventory SET invType='N' WHERE invType<>'N' AND invValue IN (100,200,500) AND invDevice IN (42102,42101,42001); 09/11/2024 14:03:01.8245 668 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 09/11/2024 14:06:01.7814 741 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 09/11/2024 14:06:01.8195 817 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 09/11/2024 14:06:31.8715 745 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 09/11/2024 14:07:14.7901 549 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 09/11/2024 14:07:35.6219 979 ms. EXEC: INSERT INTO movOperator (opeCreation,opeUseId,opeTerId,opeDateTime,opeCode,opeDescription) VALUES ('2024-11-09 14:07:34',0,16,'2024-11-09 14:07:34','','Unauthorized Transit Entry 2') 09/11/2024 14:07:58.7283 929 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,'2024-11-09 14:07:57','V',5755437078598470,2024,'2024-11-09 14:07:57','456034810600327005012999',2,2,2,'O','',0,'2024-11-09 14:07:57',1,'','',0) 09/11/2024 14:09:28.9294 741 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 4 and terStatus='V' 09/11/2024 14:09:31.0328 902 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2024-11-09 14:09:30' where traUID = 4628610534990040 and traStatus='V' and traEnabled=1 09/11/2024 14:09:33.3103 1073 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 09/11/2024 14:09:38.2897 528 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 09/11/2024 14:13:34.8062 1143 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,'2024-11-09 14:13:33','V',5605011476347190,2024,'2024-11-09 14:13:31','456034760100327005012999',2,2,2,'O','',0,'2024-11-09 14:13:33',1,'','',0) 09/11/2024 14:27:46.8178 720 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 09/11/2024 14:31:25.4464 1015 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 09/11/2024 14:31:59.8704 515 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 09/11/2024 14:39:21.5736 536 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 09/11/2024 14:39:23.7971 779 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 5 09/11/2024 14:42:37.6942 629 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 09/11/2024 14:45:57.8536 515 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 09/11/2024 14:47:29.5917 647 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 09/11/2024 14:47:36.8145 2076 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 09/11/2024 14:48:15.1520 1380 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 09/11/2024 14:48:17.1334 1415 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2024-11-09 14:48:15' where traUID = 5495961132971630 and traStatus='V' and traEnabled=1 09/11/2024 14:48:19.7031 745 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 09/11/2024 14:48:58.5509 591 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 09/11/2024 14:49:23.4015 1651 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 09/11/2024 14:49:24.5272 864 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2024-11-09 14:49:23' where traUID = 5148686099925070 and traStatus='V' and traEnabled=1 09/11/2024 14:49:28.1477 557 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 09/11/2024 14:51:01.3588 1335 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 09/11/2024 14:52:46.0625 524 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 09/11/2024 14:56:51.6111 973 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 5 09/11/2024 14:56:52.1304 519 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 09/11/2024 14:57:05.3592 581 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 09/11/2024 14:57:18.2548 778 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 ('2024-11-09 14:57:16',0,'V',4774205934062740,5690796555302370,2024,'2024-11-09 14:57:16',3,1,0,4,'2024-11-09 15:12:16','C','KES',100,100,0,'',' ',' ',1,100,0,0,'',0,0) 09/11/2024 14:57:19.2535 816 ms. EXEC: update payReceipt set recCreation = '2024-11-09 14:57:18',recModify = '2024-11-09 14:57:18',recUseId=0,recStatus='V' where recId = 320949 09/11/2024 14:57:19.8519 501 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2024-11-09 14:57:19',3,42101,0,100,1,100,1,'I','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'; 09/11/2024 14:59:11.7394 591 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 09/11/2024 14:59:37.8288 1025 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2024-11-09 14:59:36',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'; 09/11/2024 15:01:04.5886 1221 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 09/11/2024 15:01:12.5919 603 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 09/11/2024 15:02:45.4978 687 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,'2024-11-09 15:02:44','V',5186016340523680,2024,'2024-11-09 15:02:41','456035416100327005012999',1,2,16,'I','',1,0,1,'','',4) 09/11/2024 15:02:59.5812 548 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 09/11/2024 15:04:30.1025 894 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 09/11/2024 15:04:32.7403 2128 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 5 09/11/2024 15:05:39.1755 931 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 09/11/2024 15:06:15.8239 750 ms. EXEC: update payReceipt set recCreation = '2024-11-09 15:06:15',recModify = '2024-11-09 15:06:15',recUseId=0,recStatus='V' where recId = 320956 09/11/2024 15:06:17.0277 725 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2024-11-09 15:06:15',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'; 09/11/2024 15:07:40.4133 794 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 09/11/2024 15:07:59.6001 772 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,'2024-11-09 15:07:58','V',5543675306457810,2024,'2024-11-09 15:07:58','456035300600327005012999',2,2,2,'O','',0,'2024-11-09 15:07:58',1,'','',0) 09/11/2024 15:08:07.0960 672 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 09/11/2024 15:08:21.0353 567 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2024-11-09 15:08:20' where payTraUID = 4783636573396050 and payStatus='V' and payEnabled=1 09/11/2024 15:08:21.6818 644 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2024-11-09 15:08:20' where traUID = 4783636573396050 and traStatus='V' and traEnabled=1 09/11/2024 15:10:53.7961 1108 ms. EXEC: update abbSubscriptions set subCredit = round(subCredit-0,5),subLastDebit = '2024-11-09 15:10:52' where subId = 16 09/11/2024 15:10:56.8191 551 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 09/11/2024 15:11:01.0789 517 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 09/11/2024 15:11:15.4775 1056 ms. EXEC: update abbSubscriptions set subCredit = round(subCredit-0,5),subLastDebit = '2024-11-09 15:11:14' where subId = 198 09/11/2024 15:11:17.2817 879 ms. EXEC: update abbCards set carLastDate = '2024-11-09 15:11:16',carLastDirection='O' where carStatus='V' and carId = 183 09/11/2024 15:13:55.0048 681 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 09/11/2024 15:14:33.7596 863 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,'2024-11-09 15:14:32','V',4758905013013890,2024,'2024-11-09 15:14:32','456035487200327005012999',1,2,16,'I','',1,0,1,'','',4) 09/11/2024 15:19:28.2128 1444 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 09/11/2024 15:22:19.5479 760 ms. EXEC: update tabTerminalReceipt set trcProgressive = 48995, trcLastPrinted = '2400748995', trcLastDate = '2024-11-09 15:22:18' where trcStatus='V' and trcTerId = 18 09/11/2024 15:22:43.7560 1487 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,'2024-11-09 15:22:42','V',4795613400577420,2024,'2024-11-09 15:22:42','456034967200327001012999',2,2,2,'O','',0,'2024-11-09 15:22:42',1,'','',0) 09/11/2024 15:22:53.2414 1124 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 09/11/2024 15:23:22.3567 2033 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,'2024-11-09 15:23:20','V',4840398934672380,2024,'2024-11-09 15:23:19','456035468500327005012999',2,2,2,'O','',0,'2024-11-09 15:23:20',1,'','',0) 09/11/2024 15:23:38.9418 524 ms. OPEN: select * from tabArea where areStatus='V' and areEnabled = 1 AND areId = 1 09/11/2024 15:23:39.1259 857 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 09/11/2024 15:24:04.5619 553 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 09/11/2024 15:25:00.5492 649 ms. OPEN: select * from tabArea where areStatus='V' and areEnabled = 1 AND areId = 1 09/11/2024 15:26:56.4254 597 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 1 OR lnsTerId=1) 09/11/2024 15:26:56.8887 1005 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,'2024-11-09 15:26:55','V',5496751253627880,2024,'2024-11-09 15:26:54','456035561400327005012999',1,2,16,'I','',1,0,1,'','',4) 09/11/2024 15:26:58.0034 604 ms. EXECSCALAR: select count(parId) from tabParameters where parFiscalPrinter <> 0 and parStatus='V' nr: 0 09/11/2024 15:32:00.3918 645 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 09/11/2024 15:34:53.7523 578 ms. EXEC: insert into payReceipt (recTraUID,recPayUID,recYear,recDateTime,recText,recInvalid) VALUES (5090238540035200,5162066574086570,2024,'2024-11-09 15:34:53',' Date: 11/9/2024 3:34:52 PM Code: 456035590600327001012999 Entry Date: 11/9/2024 3:31:46 PM Plate: Class: Cars Park: The Mall Gate: Entry 1 ______________________________ Total: 50.00 KES ______________________________ Paid: 50.00 KES __________ Change: 0.00 KES Type: Cash Dispozitiv: MPESA # 2400748996 ',0) 09/11/2024 15:34:54.8791 1126 ms. EXEC: update payReceipt set recCreation = '2024-11-09 15:34:53',recModify = '2024-11-09 15:34:53',recUseId=0,recStatus='V' where recId = 320963 09/11/2024 15:35:54.0175 717 ms. OPEN: select ticId from tabTicketType where ticStatus='V' and ticType = 1 09/11/2024 15:36:12.0595 1145 ms. EXECSCALAR: SELECT COUNT(*) FROM payPayment INNER JOIN movTransit ON traUID = payTrauid WHERE payStatus='V' AND payPayed=0 AND payAmount=0 AND payDiscount = 100 AND payDiscountType = 1 AND traStatus='V' AND traEnabled = 1 AND traCode = '456035427200327005012999' nr: 0 09/11/2024 15:36:12.1065 2235 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 09/11/2024 15:39:16.2602 514 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 09/11/2024 15:41:26.8512 1511 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 09/11/2024 15:41:28.0800 651 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 09/11/2024 15:41:30.7808 1476 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2024-11-09 15:41:29' where payTraUID = 4758905013013890 and payStatus='V' and payEnabled=1 09/11/2024 15:42:10.3772 987 ms. EXEC: update opeActivities set acvFstPayId = (case acvFstPayId when 0 then 369287 else acvFstPayId end),acvLstPayId = 369287 where acvSftId = 823 and acvCodeId = 3 09/11/2024 15:42:10.9836 511 ms. EXEC: update tabTerminalReceipt set trcProgressive = 7034, trcLastPrinted = '2400607034', trcLastDate = '2024-11-09 15:42:10' where trcStatus='V' and trcTerId = 17 09/11/2024 15:42:12.5656 747 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 09/11/2024 15:43:35.8001 639 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 09/11/2024 15:43:38.0776 1108 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 5 (WAIT TIME 1 ms.) 09/11/2024 15:43:54.7007 577 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 09/11/2024 15:45:12.0182 510 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 09/11/2024 15:45:18.2713 2520 ms. OPEN: show columns from tabParameters where Field = 'parUseCulture' 09/11/2024 15:45:18.2754 2125 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 6 09/11/2024 15:45:19.1029 685 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 09/11/2024 15:48:21.2783 655 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 09/11/2024 15:49:03.2152 520 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 09/11/2024 15:49:24.2692 1513 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 09/11/2024 15:51:48.9086 566 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 09/11/2024 15:55:13.4308 661 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 09/11/2024 15:55:30.3821 669 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 09/11/2024 15:58:08.6976 793 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 09/11/2024 16:00:43.2105 598 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,'2024-11-09 16:00:42','V',5332173239941090,2024,'2024-11-09 16:00:41','456034715700327005012999',2,2,2,'O','',0,'2024-11-09 16:00:42',1,'','',0) 09/11/2024 16:00:47.3242 657 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 09/11/2024 16:01:01.9099 1067 ms. EXEC: update payInventory set invCreation = '2024-11-09 16:01:00',invModify = '2024-11-09 16:01:00',invUseId=0,invStatus='V' where invId = 218251 09/11/2024 16:01:11.6374 1040 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2024-11-09 16:01:10' where payTraUID = 5496999593895940 and payStatus='V' and payEnabled=1 09/11/2024 16:01:15.2458 1173 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 09/11/2024 16:03:46.1564 545 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2024-11-09 16:03:45' where payTraUID = 5496751253627880 and payStatus='V' and payEnabled=1 09/11/2024 16:03:54.8722 718 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 09/11/2024 16:06:00.6440 1214 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 09/11/2024 16:07:41.3300 668 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,'2024-11-09 16:07:40','V',5596153551411040,2024,'2024-11-09 16:07:40','456035078600327005012999',2,2,2,'O','',0,'2024-11-09 16:07:40',1,'','',0) 09/11/2024 16:07:42.0245 684 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 09/11/2024 16:09:01.6956 679 ms. EXEC: insert into payReceipt (recTraUID,recPayUID,recYear,recDateTime,recText,recInvalid) VALUES (5583830700400600,4645198275005590,2024,'2024-11-09 16:09:01',' Date: 11/9/2024 4:09:00 PM Code: 456035563500327005012999 Entry Date: 11/9/2024 3:27:15 PM 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 # 2400749005 ',0) 09/11/2024 16:10:23.0668 588 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 09/11/2024 16:10:40.6405 558 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 09/11/2024 16:10:55.9126 566 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 09/11/2024 16:12:33.6367 631 ms. EXEC: update payReceipt set recCreation = '2024-11-09 16:12:33',recModify = '2024-11-09 16:12:33',recUseId=0,recStatus='V' where recId = 320985 09/11/2024 16:13:00.4706 891 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 09/11/2024 16:14:47.5079 858 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 09/11/2024 16:15:12.3275 844 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 16 OR lnsTerId=16) 09/11/2024 16:15:59.8741 529 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 09/11/2024 16:16:43.0399 505 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 09/11/2024 16:18:26.0295 664 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 09/11/2024 16:19:52.2359 710 ms. EXEC: update payInventory set invCreation = '2024-11-09 16:19:51',invModify = '2024-11-09 16:19:51',invUseId=0,invStatus='V' where invId = 218253 09/11/2024 16:20:53.3666 609 ms. EXECSCALAR: select count(*) from tabTerminalExtraMem where extStatus='V' and extTerId = 2 nr: 1 09/11/2024 16:20:53.7219 942 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 09/11/2024 16:20:53.7539 1072 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 09/11/2024 16:20:54.9077 625 ms. EXEC: update paycash set casCreation = '2024-11-09 16:20:54',casModify = '2024-11-09 16:20:54',casUseId=0,casStatus='V' where casId = 194050 09/11/2024 16:22:02.9790 615 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 6 09/11/2024 16:26:20.0343 858 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 09/11/2024 16:27:34.8981 954 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 09/11/2024 16:27:37.3628 1102 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2024-11-09 16:27:36',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 ('2024-11-09 16:27:36',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'; 09/11/2024 16:28:34.1336 678 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,'2024-11-09 16:28:33','V',5025369606074140,2024,'2024-11-09 16:28:32','456035931200327005012999',1,2,16,'I','',1,0,1,'','',4) 09/11/2024 16:29:03.7553 862 ms. EXEC: update payReceipt set recCreation = '2024-11-09 16:29:02',recModify = '2024-11-09 16:29:02',recUseId=0,recStatus='V' where recId = 320994 09/11/2024 16:30:06.5461 838 ms. OPEN: select * from tabTerminal where terId = 2 09/11/2024 16:30:11.1942 541 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 09/11/2024 16:30:32.3353 1167 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 09/11/2024 16:30:39.8783 723 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 ('2024-11-09 16:30:37',0,'V',5113013783707870,5239732383168070,2024,'2024-11-09 16:30:37',3,1,0,4,'2024-11-09 16:45:37','C','KES',100,100,0,'',' ',' ',1,100,0,0,'',0,0) 09/11/2024 16:35:52.5196 662 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 09/11/2024 16:39:47.9364 596 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 09/11/2024 16:39:58.5455 919 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 5 09/11/2024 16:41:43.6305 944 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2024-11-09 16:41:42',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'; 09/11/2024 16:41:53.6972 554 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 09/11/2024 16:44:22.3642 714 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,'2024-11-09 16:44:21','V',5633616964422730,2024,'2024-11-09 16:44:20','456036026000327005012999',1,2,16,'I','',1,0,1,'','',4) 09/11/2024 16:44:23.4139 1044 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 09/11/2024 16:44:35.9383 593 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 09/11/2024 16:44:37.4273 619 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2024-11-09 16:44:36',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'; 09/11/2024 16:45:36.5817 605 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 09/11/2024 16:45:56.2858 532 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 09/11/2024 16:50:33.0812 617 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 09/11/2024 16:51:42.1872 1976 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 09/11/2024 16:53:29.7869 988 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 09/11/2024 16:55:56.8919 624 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 09/11/2024 16:55:56.8919 610 ms. OPEN: select * from tabArea where areStatus='V' and areEnabled = 1 AND areId = 1 09/11/2024 16:57:54.7884 1174 ms. EXECSCALAR: select count(*) from information_schema.tables where table_schema= 'wisepark_0327' and table_name= 'payInvoiceFtp' nr: 1 09/11/2024 16:58:12.9986 589 ms. EXECSCALAR: select count(*) from information_schema.tables where table_schema= 'wisepark_0327' and table_name= 'tabTerminalReceipt' nr: 1 09/11/2024 17:00:11.5726 3711 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2024-11-09 17:00:07',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 ('2024-11-09 17:00:07',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'; 09/11/2024 17:03:20.8647 588 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 09/11/2024 17:05:19.7218 670 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 09/11/2024 17:05:52.3986 845 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 09/11/2024 17:05:54.3979 594 ms. EXEC: update abbSubscriptions set subCredit = round(subCredit-0,5),subLastDebit = '2024-11-09 17:05:53' where subId = 26 09/11/2024 17:08:53.3792 631 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 ('2024-11-09 17:08:52',0,'V',4632591044551930,5580542648898410,2024,'2024-11-09 17:08:52',18,1,0,4,'2024-11-09 17:23:52','C','KES',50,50,0,'','','',1,50,0,0,'',0,0) 09/11/2024 17:08:54.7961 584 ms. OPEN: select * from payCurInventory where curTerId = 18 and curQuantity>0 and curType in ('C','N') order by curDevCode,curChannelId,curValue 09/11/2024 17:12:50.0178 517 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,'2024-11-09 17:12:49','V',5505316258258380,2024,'2024-11-09 17:12:47','456036196700327005012999',1,2,16,'I','',1,0,1,'','',4) 09/11/2024 17:14:32.2359 926 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 09/11/2024 17:16:24.7438 546 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 09/11/2024 17:17:48.9860 691 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 09/11/2024 17:18:12.3595 639 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 09/11/2024 17:18:34.8515 770 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 09/11/2024 17:20:19.9835 1265 ms. EXEC: update paycash set casCreation = '2024-11-09 17:20:18',casModify = '2024-11-09 17:20:18',casUseId=0,casStatus='V' where casId = 194069 09/11/2024 17:20:21.1243 633 ms. EXEC: update payInventory set invCreation = '2024-11-09 17:20:20',invModify = '2024-11-09 17:20:20',invUseId=0,invStatus='V' where invId = 218275 09/11/2024 17:20:59.2907 548 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 5 09/11/2024 17:21:53.7770 1048 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 09/11/2024 17:24:23.9671 3618 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 ('2024-11-09 17:24:20',0,'V',5181589595286980,4939519966065060,2024,'2024-11-09 17:24:20',18,1,0,4,'2024-11-09 17:39:20','C','KES',400,400,0,'','','',1,400,0,0,'',0,0) 09/11/2024 17:25:28.6562 814 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2024-11-09 17:25:27',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 ('2024-11-09 17:25:27',3,42101,0,100,-4,-400,1,'O','N'); update payCurInventory set curQuantity=round(curQuantity+-4,5),curAmount=round(curAmount+-400,5) where curTerId = 3 and curDevCode = 42101 and curChannelId = 1 and curValue = 100 and curType = 'N'; Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2024-11-09 17:25:27',3,42101,0,500,-1,-500,1,'O','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'; 09/11/2024 17:25:57.2822 648 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,'2024-11-09 17:25:56','V',5528216105598520,2024,'2024-11-09 17:25:55','456035768100327005012999',2,2,2,'O','',0,'2024-11-09 17:25:56',1,'','',0) 09/11/2024 17:26:23.4957 711 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 09/11/2024 17:27:58.3229 598 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,'2024-11-09 17:27:57','V',5623822891182120,2024,'2024-11-09 17:27:57','456036287700327005012999',1,2,16,'I','',1,0,1,'','',4) 09/11/2024 17:28:27.4393 1659 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 09/11/2024 17:28:28.4870 733 ms. OPEN: select * from movTransit where traStatus='V' and traEnabled = 1 and traCode = '456036169400327005012999' 09/11/2024 17:28:33.5533 622 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 09/11/2024 17:28:33.8725 787 ms. EXECSCALAR: select count(*) from information_schema.tables where table_schema= 'wisepark_0327' and table_name= 'payInvoiceFtp' nr: 1 09/11/2024 17:29:08.6627 904 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 09/11/2024 17:32:33.9995 680 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 09/11/2024 17:34:08.3073 612 ms. EXEC: update abbAreaGroup set argNrInside = 0 where argStatus='V' and argNrInside < 0 09/11/2024 17:35:29.0621 956 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 09/11/2024 17:37:55.4276 618 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 09/11/2024 17:38:46.9650 871 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 09/11/2024 17:38:55.4416 827 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 09/11/2024 17:39:15.2438 659 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 09/11/2024 17:40:53.9095 1314 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 09/11/2024 17:41:32.8585 919 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2024-11-09 17:41:31',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'; 09/11/2024 17:42:17.5122 1221 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 09/11/2024 17:42:34.5396 846 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 09/11/2024 17:43:01.4125 515 ms. OPEN: select trauid from movtransit where traStatus='V' and traDirection='I' and traCode='456036224700327001012999' 09/11/2024 17:44:00.6599 630 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 09/11/2024 17:44:46.6756 860 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 2 OR lnsTerId=2) 09/11/2024 17:44:46.7166 900 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 09/11/2024 17:46:40.1842 635 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 16 OR lnsTerId=16) 09/11/2024 17:46:44.7662 570 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 09/11/2024 17:47:41.4020 681 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 09/11/2024 17:48:01.6815 887 ms. EXEC: insert into paycash (casCreation,casModify,casUseId,casStatus,casUID,casTraUID,casYear,casDateTime,casIdTerminal,casCurrency,casNumber,casSingleAmount,casTotAmount,casType,casDescription) VALUES ('2024-11-09 17:48:00',0,0,'V',5449791384216970,5323080948368430,2024,'2024-11-09 17:48:00',3,'KES',1,100,100,'N',''); 09/11/2024 17:48:02.5571 536 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2024-11-09 17:48:00',3,42101,0,100,1,100,1,'I','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'; 09/11/2024 17:48:03.1605 602 ms. EXEC: update payInventory set invCreation = '2024-11-09 17:48:02',invModify = '2024-11-09 17:48:02',invUseId=0,invStatus='V' where invId = 218291 09/11/2024 17:52:59.2417 603 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,'2024-11-09 17:52:58','V',5007258193642920,2024,'2024-11-09 17:52:56','456036437600327005012999',1,2,16,'I','',1,0,1,'','',4) 09/11/2024 17:55:44.8660 1458 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 09/11/2024 17:55:52.2580 684 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 09/11/2024 17:57:04.4781 1596 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 (WAIT TIME 1021 ms.) 09/11/2024 17:57:34.1048 688 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 09/11/2024 17:59:49.7612 984 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 ('2024-11-09 17:59:48',0,'V',4872790886234450,4718937995797540,2024,'2024-11-09 17:59:48',3,1,0,4,'2024-11-09 18:14:48','C','KES',50,200,150,'',' ',' ',1,50,0,0,'',0,0) 09/11/2024 17:59:50.6858 519 ms. EXEC: update paycash set casCreation = '2024-11-09 17:59:50',casModify = '2024-11-09 17:59:50',casUseId=0,casStatus='V' where casId = 194087 09/11/2024 17:59:51.2922 605 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2024-11-09 17:59:50',3,42101,0,200,1,200,1,'I','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'; 09/11/2024 18:01:23.3935 508 ms. EXECSCALAR: select count(resId) as Tot from movReservation where resStatus = 'V' and resTypeRes = 'B' AND ((resConfirmed IN (0,2,3) AND resCreation>'2024-11-09 17:01:22') OR resConfirmed IN (4,5)) and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) <= '2024-11-09 18:01:22' and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) >= '2024-11-09 18:01:22' and (resAreId = 1 or resAreId <= 0) nr: 0 09/11/2024 18:01:23.7488 947 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 09/11/2024 18:01:29.3675 815 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 09/11/2024 18:02:50.7788 1241 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 09/11/2024 18:03:34.8401 744 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 09/11/2024 18:05:33.8784 1317 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 09/11/2024 18:08:49.8339 662 ms. EXEC: insert into paycash (casCreation,casModify,casUseId,casStatus,casUID,casTraUID,casYear,casDateTime,casIdTerminal,casCurrency,casNumber,casSingleAmount,casTotAmount,casType,casDescription) VALUES ('2024-11-09 18:08:49',0,0,'V',5423190451623720,5007559051519300,2024,'2024-11-09 18:08:49',3,'KES',1,500,500,'N',''); 09/11/2024 18:09:18.4060 1116 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 2 OR lnsTerId=2) 09/11/2024 18:09:19.2846 707 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 1 09/11/2024 18:11:00.8942 601 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 09/11/2024 18:11:28.2995 784 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 09/11/2024 18:12:51.8522 1134 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 09/11/2024 18:12:56.0810 890 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 09/11/2024 18:14:05.5202 546 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 09/11/2024 18:14:13.9038 1255 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,'2024-11-09 18:14:12','V',5756902432249670,2024,'2024-11-09 18:14:11','456036565100327005012999',1,2,16,'I','',1,0,1,'','',4) 09/11/2024 18:14:26.1980 1377 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 09/11/2024 18:16:55.3794 1006 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 09/11/2024 18:17:52.7186 649 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 09/11/2024 18:20:40.2962 535 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 09/11/2024 18:24:46.4742 640 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 09/11/2024 18:24:59.7931 1398 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 ('2024-11-09 18:24:57',0,'V',4882459254779940,5299474108483030,2024,'2024-11-09 18:24:57',3,1,0,4,'2024-11-09 18:39:57','C','KES',100,100,0,'',' ',' ',1,100,0,0,'',0,0) 09/11/2024 18:25:19.5893 580 ms. OPEN: select * from tabArea where areStatus='V' and areEnabled = 1 AND areId = 1 09/11/2024 18:25:19.5903 531 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 09/11/2024 18:25:27.1473 624 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 09/11/2024 18:25:56.5029 640 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 09/11/2024 18:26:03.5505 685 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 09/11/2024 18:28:01.6922 6920 ms. OPEN: select count(payId) as Tot,0 as payUID,sum(payPayed) as payPayed,sum(payChange) as payChange,payAmount,traUIDGroup,traType,traClass,traIdTerminal,traDiscountValue,traDiscountType,traCarId,payIdEvent,payType,payCardType from payPayment LEFT join movtransit on trauid = payTraUID LEFT JOIN payReport ON repPayUID = payUID AND repStatus='V' where payStatus = 'V' and (payType='C' or payType='P') and payUseId = 1 and payIdEvent<90 and repPayUID IS NULL and (traCarId is null or traCarId=0 or traCarId in (select carId from abbCards inner join abbsubscriptions on subId= carSubId where carStatus='V' and subStatus='V' and subAbbType<>5)) group by traUIDGroup,payAmount,payIdEvent,payType,payCardType,traType,traIdTerminal,traDiscountValue,traDiscountType,traCarId order by traUIDGroup,payAmount, traType, traDiscountValue, traDiscountType 09/11/2024 18:28:54.8647 9375 ms. OPEN: select count(payId) as Tot,0 as payUID,sum(payPayed) as payPayed,sum(payChange) as payChange,payAmount,traUIDGroup,traType,traClass,traIdTerminal,traDiscountValue,traDiscountType,traCarId,payIdEvent,payType,payCardType from payPayment LEFT join movtransit on trauid = payTraUID LEFT JOIN payReport ON repPayUID = payUID AND repStatus='V' where payStatus = 'V' and (payType='C' or payType='P') and payUseId = 9 and payIdEvent<90 and repPayUID IS NULL and (traCarId is null or traCarId=0 or traCarId in (select carId from abbCards inner join abbsubscriptions on subId= carSubId where carStatus='V' and subStatus='V' and subAbbType<>5)) group by traUIDGroup,payAmount,payIdEvent,payType,payCardType,traType,traIdTerminal,traDiscountValue,traDiscountType,traCarId order by traUIDGroup,payAmount, traType, traDiscountValue, traDiscountType 09/11/2024 18:29:09.9437 919 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 1 OR lnsTerId=1) 09/11/2024 18:29:40.4791 1843 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 09/11/2024 18:31:34.3559 549 ms. OPEN: show columns from tabParameters where Field = 'parAllowNegativePlaces' 09/11/2024 18:31:34.6991 1021 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 09/11/2024 18:31:35.0764 927 ms. EXECSCALAR: select count(*) from information_schema.tables where table_schema= 'wisepark_0327' and table_name= 'payInvoiceFtp' nr: 1 09/11/2024 18:32:20.4356 739 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 09/11/2024 18:32:26.9299 845 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2024-11-09 18:32:25',3,42101,0,100,1,100,1,'I','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'; 09/11/2024 18:32:51.9996 686 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 1 and terStatus='V' 09/11/2024 18:34:13.6290 654 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,'2024-11-09 18:34:12','V',5224396716389270,2024,'2024-11-09 18:34:11','456036581400327001012999',2,2,2,'O','',0,'2024-11-09 18:34:12',1,'','',0) 09/11/2024 18:34:32.2364 1483 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 09/11/2024 18:36:04.5059 645 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 09/11/2024 18:40:38.2222 539 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 09/11/2024 18:41:03.5651 1479 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 09/11/2024 18:41:06.6361 677 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 09/11/2024 18:44:12.5880 852 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 09/11/2024 18:44:34.8859 617 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2024-11-09 18:44:33' where traUID = 5407749388291820 and traStatus='V' and traEnabled=1 09/11/2024 18:45:19.4896 4725 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 09/11/2024 18:45:23.4982 1169 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 09/11/2024 18:45:23.4992 719 ms. OPEN: select * from tabArea where areStatus='V' and areEnabled = 1 AND areId = 1 09/11/2024 18:45:38.0569 746 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 ('2024-11-09 18:45:37',0,'V',4979232364028810,4893768488026950,2024,'2024-11-09 18:45:37',18,1,0,4,'2024-11-09 19:00:37','C','KES',300,300,0,'','','',1,300,0,0,'',0,0) 09/11/2024 18:46:12.5759 597 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 09/11/2024 18:46:31.9769 608 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 09/11/2024 18:47:03.5629 1739 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 09/11/2024 18:47:06.7080 1037 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,'2024-11-09 18:47:05','V',5544230569170250,2024,'2024-11-09 18:46:58','456036581700327005012999',2,2,2,'O','',0,'2024-11-09 18:47:05',1,'','',0) 09/11/2024 18:48:24.2797 665 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 09/11/2024 18:49:21.8860 859 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 1 OR lnsTerId=1) 09/11/2024 18:50:42.8860 989 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 1 OR lnsTerId=1) 09/11/2024 18:53:53.9573 604 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 09/11/2024 18:55:18.8388 1970 ms. OPEN: select * from tabArea where areStatus='V' and areEnabled = 1 AND areId = 1 (WAIT TIME 93 ms.) 09/11/2024 18:55:38.5640 687 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,'2024-11-09 18:55:37','V',5611454634862560,2024,'2024-11-09 18:55:34','456036813400327005012999',1,2,16,'I','',1,0,1,'','0230003939927',164,0) 09/11/2024 18:55:43.5563 1031 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 3 and terStatus='V' 09/11/2024 18:57:02.4549 508 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2024-11-09 18:57:01' where traUID = 5530452449678490 and traStatus='V' and traEnabled=1 09/11/2024 19:00:16.1159 868 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 09/11/2024 19:02:40.1988 763 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,'2024-11-09 19:02:39','V',5280133655536210,2024,'2024-11-09 19:02:37','456036855700327001012999',1,2,1,'I','',1,0,1,'','',4) 09/11/2024 19:02:47.6678 624 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 09/11/2024 19:03:12.4383 646 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 4 and terStatus='V' 09/11/2024 19:03:57.6925 537 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 09/11/2024 19:04:48.6994 2407 ms. EXEC: insert into payReceipt (recTraUID,recPayUID,recYear,recDateTime,recText,recInvalid) VALUES (5585014136138040,5376262601922630,2024,'2024-11-09 19:04:46','---------------------------------- %The Mall P0006032390 End of payment ---------------------------------- POF Entry : 11/9/2024 6:28:45 PM Date : 11/9/2024 7:04:44 PM Code : 456036652500327001012999 Total : 50.00 KES VAT 16% : 6.90 KES ---------------------------------- Paid : 50.00 KES Coin changed : 0.00 KES Note changed : 0.00 KES',0) 09/11/2024 19:05:38.8909 739 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 ('2024-11-09 19:05:36',0,'V',5141269593898580,4744765725927910,2024,'2024-11-09 19:05:36',3,1,0,4,'2024-11-09 19:20:36','C','KES',50,100,50,'',' ',' ',1,50,0,0,'',0,0) 09/11/2024 19:06:17.9079 1313 ms. OPEN: select * from tabArea where areStatus='V' and areEnabled = 1 AND areId = 1 09/11/2024 19:06:39.9035 740 ms. EXEC: INSERT INTO movOperator (opeCreation,opeUseId,opeTerId,opeDateTime,opeCode,opeDescription) VALUES ('2024-11-09 19:06:39',0,16,'2024-11-09 19:06:39','','Unauthorized Transit Entry 2') (WAIT TIME 15 ms.) 09/11/2024 19:06:59.4085 924 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 09/11/2024 19:07:44.5936 978 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 09/11/2024 19:07:59.7847 548 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2024-11-09 19:07:59' where traUID = 5585014136138040 and traStatus='V' and traEnabled=1 09/11/2024 19:08:44.2293 834 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,'2024-11-09 19:08:43','V',5602106487077590,2024,'2024-11-09 19:08:42','456036745500327001012999',2,2,2,'O','',0,'2024-11-09 19:08:43',1,'','',0) 09/11/2024 19:08:50.9168 563 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 09/11/2024 19:09:08.4205 555 ms. OPEN: select * from tabArea where areStatus='V' and areEnabled = 1 AND areId = 1 09/11/2024 19:10:10.9101 640 ms. EXEC: insert into movtransit (traUseId,traCreation,traStatus,traUID,traYear,traDateTime,traCode,traType,traClass,traIdTerminal,traDirection,traPlate,traEnabled,traDisableTime,traAreId,traNotes,traBadge,traTarId) VALUES (0,'2024-11-09 19:10:10','V',5728190153708060,2024,'2024-11-09 19:10:09','456036900900327005012999',1,2,16,'I','',1,0,1,'','',4) 09/11/2024 19:10:11.9868 555 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 09/11/2024 19:12:16.1295 737 ms. EXEC: INSERT INTO movOperator (opeCreation,opeUseId,opeTerId,opeDateTime,opeCode,opeDescription) VALUES ('2024-11-09 19:12:15',0,1,'2024-11-09 19:12:15','','Unauthorized Transit Entry 1') 09/11/2024 19:12:57.4860 855 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 09/11/2024 19:16:10.2515 1184 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 09/11/2024 19:17:18.9682 610 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 09/11/2024 19:17:22.3655 2000 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 09/11/2024 19:17:42.0756 588 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 09/11/2024 19:18:03.4078 1566 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 09/11/2024 19:19:47.0809 626 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 09/11/2024 19:20:34.1062 1634 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 09/11/2024 19:21:22.9257 548 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 09/11/2024 19:21:32.4831 694 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 09/11/2024 19:25:30.0344 725 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 16 OR lnsTerId=16) 09/11/2024 19:26:20.3609 827 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 09/11/2024 19:28:38.0796 531 ms. EXEC: update payInventory set invCreation = '2024-11-09 19:28:37',invModify = '2024-11-09 19:28:37',invUseId=0,invStatus='V' where invId = 218311 (WAIT TIME 4 ms.) 09/11/2024 19:29:30.8188 560 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 09/11/2024 19:30:56.0215 667 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 09/11/2024 19:34:52.5521 1366 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 2 and terStatus='V' 09/11/2024 19:35:36.4563 1085 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,'2024-11-09 19:35:35','V',5759869337644650,2024,'2024-11-09 19:35:34','456037053400327005012999',1,2,16,'I','',1,0,1,'','',4) 09/11/2024 19:37:34.3949 1003 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 09/11/2024 19:37:35.2034 886 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,'2024-11-09 19:37:34','V',4814790069341800,2024,'2024-11-09 19:37:33','456037065300327005012999',1,2,16,'I','',1,0,1,'','',4) 09/11/2024 19:37:40.9973 1041 ms. OPEN: select * from tabArea where areStatus='V' and areEnabled = 1 AND areId = 1 09/11/2024 19:37:44.3956 2025 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 2 OR lnsTerId=2) 09/11/2024 19:37:45.0180 1377 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 09/11/2024 19:37:55.9072 683 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 09/11/2024 19:38:59.4596 962 ms. OPEN: select count(payId) as Tot,0 as payUID,sum(payPayed) as payPayed,sum(payChange) as payChange,payAmount,traUIDGroup,traType,traClass,traIdTerminal,traDiscountValue,traDiscountType,traCarId,payIdEvent,payType,payCardType from payPayment LEFT join movtransit on trauid = payTraUID LEFT JOIN payReport ON repPayUID = payUID AND repStatus='V' where payStatus = 'V' and (payType='C' or payType='P') and payUseId = 1 and payIdEvent<90 and repPayUID IS NULL and (traCarId is null or traCarId=0 or traCarId in (select carId from abbCards inner join abbsubscriptions on subId= carSubId where carStatus='V' and subStatus='V' and subAbbType<>5)) group by traUIDGroup,payAmount,payIdEvent,payType,payCardType,traType,traIdTerminal,traDiscountValue,traDiscountType,traCarId order by traUIDGroup,payAmount, traType, traDiscountValue, traDiscountType 09/11/2024 19:39:37.6320 598 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 09/11/2024 19:40:14.2374 619 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 09/11/2024 19:40:38.2944 894 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 09/11/2024 19:41:12.9745 568 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 09/11/2024 19:42:35.4985 958 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 09/11/2024 19:42:52.0855 576 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2024-11-09 19:42:51' where traUID = 5007258193642920 and traStatus='V' and traEnabled=1 09/11/2024 19:46:38.7385 1935 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 09/11/2024 19:48:07.4126 671 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 09/11/2024 19:48:31.6237 630 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 09/11/2024 19:49:47.9896 646 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 3 09/11/2024 19:50:51.2477 791 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2024-11-09 19:50:50',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'; 09/11/2024 19:53:17.5852 1048 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 09/11/2024 19:54:39.3186 659 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 09/11/2024 20:02:21.9678 1570 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 09/11/2024 20:03:34.1879 2592 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2024-11-09 20:03:31',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'; 09/11/2024 20:03:52.3841 674 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 09/11/2024 20:09:27.0320 943 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 09/11/2024 20:09:27.0640 681 ms. OPEN: select * from tabArea where areStatus='V' and areEnabled = 1 AND areId = 1 09/11/2024 20:16:16.4858 503 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 09/11/2024 20:16:22.4677 641 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 09/11/2024 20:17:53.0751 726 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 09/11/2024 20:18:46.8179 536 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 09/11/2024 20:21:39.4539 1669 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 ('2024-11-09 20:21:34',0,'V',4950922451429040,5759869337644650,2024,'2024-11-09 20:21:34',3,1,0,4,'2024-11-09 20:36:34','C','KES',50,100,50,'',' ',' ',1,50,0,0,'',0,0) 09/11/2024 20:21:40.1303 638 ms. EXEC: insert into payReceipt (recTraUID,recPayUID,recYear,recDateTime,recText,recInvalid) VALUES (5759869337644650,4950922451429040,2024,'2024-11-09 20:21:39','---------------------------------- %The Mall P0006032390 End of payment ---------------------------------- POF Entry : 11/9/2024 7:35:34 PM Date : 11/9/2024 8:21:34 PM Code : 456037053400327005012999 Total : 50.00 KES VAT 16% : 6.90 KES ---------------------------------- Paid : 100.00 KES Coin changed : 0.00 KES Note changed : 50.00 KES',0) 09/11/2024 20:21:41.7484 1144 ms. EXEC: update payInventory set invCreation = '2024-11-09 20:21:40',invModify = '2024-11-09 20:21:40',invUseId=0,invStatus='V' where invId = 218322 09/11/2024 20:23:32.8304 539 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 09/11/2024 20:24:00.6460 611 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 09/11/2024 20:24:16.5566 531 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 09/11/2024 20:24:17.7604 614 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 09/11/2024 20:24:39.6079 545 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 09/11/2024 20:24:43.4245 2762 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 09/11/2024 20:27:16.9957 1375 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 (WAIT TIME 266 ms.) 09/11/2024 20:28:30.0564 571 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 09/11/2024 20:28:30.3456 1096 ms. OPEN: select sum(crc32(terDescription)) as vCheck from tabTerminal 09/11/2024 20:29:07.9807 1006 ms. EXEC: insert into payReceipt (recTraUID,recPayUID,recYear,recDateTime,recText,recInvalid) VALUES (5028571621370090,4914779997293820,2024,'2024-11-09 20:29:06','---------------------------------- %The Mall P0006032390 End of payment ---------------------------------- POF Entry : 11/9/2024 4:47:30 PM Date : 11/9/2024 8:29:06 PM Code : 456036045000327005012999 Total : 200.00 KES VAT 16% : 27.59 KES ---------------------------------- Paid : 500.00 KES Coin changed : 0.00 KES Note changed : 300.00 KES',0) 09/11/2024 20:29:09.9870 1095 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 09/11/2024 20:29:29.0757 931 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 09/11/2024 20:31:31.2261 761 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 09/11/2024 20:36:53.0325 596 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 09/11/2024 20:36:53.5818 510 ms. EXEC: UPDATE payInventory SET invType='N' WHERE invType<>'N' AND invValue IN (100,200,500) AND invDevice IN (42102,42101,42001); 09/11/2024 20:37:08.1445 566 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 ('2024-11-09 20:37:07',0,'V',5690772751294610,5505316258258380,2024,'2024-11-09 20:37:07',18,1,0,4,'2024-11-09 20:52:07','C','KES',200,200,0,'','','',1,200,0,0,'',0,0) 09/11/2024 20:37:09.1112 752 ms. EXEC: update payReceipt set recCreation = '2024-11-09 20:37:08',recModify = '2024-11-09 20:37:08',recUseId=0,recStatus='V' where recId = 321089 09/11/2024 20:38:28.3270 1091 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 09/11/2024 20:38:50.1385 643 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,'2024-11-09 20:38:49','V',4974016474944960,2024,'2024-11-09 20:38:48','456037432800327005012999',1,2,16,'I','',1,0,1,'','',4) 09/11/2024 20:41:42.8826 866 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 09/11/2024 20:41:48.4333 5096 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2024-11-09 20:41:43' where payTraUID = 5505316258258380 and payStatus='V' and payEnabled=1 09/11/2024 20:41:49.2668 827 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2024-11-09 20:41:43' where traUID = 5505316258258380 and traStatus='V' and traEnabled=1 09/11/2024 20:41:53.4946 645 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 09/11/2024 20:43:25.6880 680 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 09/11/2024 20:46:08.2553 574 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 09/11/2024 20:46:20.3304 599 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 09/11/2024 20:47:43.4928 891 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 09/11/2024 20:48:40.3326 1048 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 ('2024-11-09 20:48:39',0,'V',5338485660797590,5742921940601440,2024,'2024-11-09 20:48:39',18,1,0,4,'2024-11-09 21:03:39','C','KES',50,50,0,'','','',1,50,0,0,'',0,0) 09/11/2024 20:49:22.2766 1986 ms. EXEC: insert into payReceipt (recTraUID,recPayUID,recYear,recDateTime,recText,recInvalid) VALUES (5173152534423750,4703848869113170,2024,'2024-11-09 20:49:20','---------------------------------- %The Mall P0006032390 End of payment ---------------------------------- POF Entry : 11/9/2024 8:26:36 PM Date : 11/9/2024 8:49:19 PM Code : 456037359600327001012999 Total : 50.00 KES VAT 16% : 6.90 KES ---------------------------------- Paid : 50.00 KES Coin changed : 0.00 KES Note changed : 0.00 KES',0) 09/11/2024 20:50:08.9807 1645 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,'2024-11-09 20:50:07','V',4886198042651760,2024,'2024-11-09 20:50:06','456037420800327001012999',2,2,2,'O','',0,'2024-11-09 20:50:07',1,'','',0) 09/11/2024 20:50:09.7442 636 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 09/11/2024 20:50:10.4727 713 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2024-11-09 20:50:09' where payTraUID = 5742921940601440 and payStatus='V' and payEnabled=1 09/11/2024 20:50:18.9523 638 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 09/11/2024 20:50:25.5417 1187 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 09/11/2024 20:50:34.1134 727 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 09/11/2024 20:51:06.1458 1104 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 09/11/2024 20:51:18.2669 849 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 09/11/2024 20:54:49.4515 1052 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 09/11/2024 20:54:51.3328 1881 ms. EXEC: UPDATE payInventory SET invType='C' WHERE invType<>'C' AND invValue IN (5,10,20,40) AND invDevice IN (41003,41002,41001,41101,41102,41103); 09/11/2024 20:54:58.8168 1228 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 5 09/11/2024 20:57:15.9031 798 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 09/11/2024 20:58:11.5422 947 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 09/11/2024 20:58:48.5968 1283 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 09/11/2024 20:59:03.7479 733 ms. OPEN: select * from tabArea where areStatus='V' and areEnabled = 1 AND areId = 1 09/11/2024 21:01:10.2842 551 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 09/11/2024 21:02:38.4830 605 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 09/11/2024 21:04:56.4029 693 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 09/11/2024 21:05:04.2421 662 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 09/11/2024 21:05:34.1560 531 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 09/11/2024 21:07:08.4588 501 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 5 and terStatus='V' 09/11/2024 21:09:44.1045 1161 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 09/11/2024 21:10:20.4327 552 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 09/11/2024 21:11:16.9634 602 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 09/11/2024 21:12:06.2672 586 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 09/11/2024 21:14:48.8145 937 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 09/11/2024 21:14:59.1814 987 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 09/11/2024 21:15:25.5009 687 ms. OPEN: select * from tabArea where areStatus='V' and areEnabled = 1 AND areId = 1 09/11/2024 21:18:54.8964 635 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2024-11-09 21:18:53',3,42101,0,100,1,100,1,'I','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'; 09/11/2024 21:18:55.9241 707 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2024-11-09 21:18:54',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'; 09/11/2024 21:18:57.3751 578 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 09/11/2024 21:18:58.6909 1259 ms. EXEC: UPDATE payInventory SET invType='N' WHERE invType<>'N' AND invValue IN (100,200,500) AND invDevice IN (42102,42101,42001); 09/11/2024 21:20:14.1812 4217 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 09/11/2024 21:21:14.1872 868 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2024-11-09 21:21:13' where payTraUID = 4726547794689870 and payStatus='V' and payEnabled=1 09/11/2024 21:21:14.7916 604 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2024-11-09 21:21:13' where traUID = 4726547794689870 and traStatus='V' and traEnabled=1 09/11/2024 21:21:19.8140 512 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 09/11/2024 21:22:26.1902 1235 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 09/11/2024 21:22:45.4810 521 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 09/11/2024 21:28:34.7757 568 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,'2024-11-09 21:28:34','V',4654728961110940,2024,'2024-11-09 21:28:30','456037467500327005012999',2,2,2,'O','',0,'2024-11-09 21:28:34',1,'','',0) 09/11/2024 21:28:35.3281 547 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 09/11/2024 21:28:39.3367 814 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 09/11/2024 21:32:12.0885 646 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 09/11/2024 21:32:28.4033 1163 ms. EXEC: update payReceipt set recCreation = '2024-11-09 21:32:27',recModify = '2024-11-09 21:32:27',recUseId=0,recStatus='V' where recId = 321105 09/11/2024 21:34:06.5277 592 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2024-11-09 21:34:05' where traUID = 4665450120670030 and traStatus='V' and traEnabled=1 09/11/2024 21:36:53.7251 1514 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 09/11/2024 21:37:47.9592 920 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 09/11/2024 21:37:54.2054 771 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 09/11/2024 21:37:57.6597 651 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); (WAIT TIME 2 ms.) 09/11/2024 21:38:19.2440 670 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 09/11/2024 21:38:53.5889 675 ms. EXEC: INSERT INTO movOperator (opeCreation,opeUseId,opeTerId,opeDateTime,opeCode,opeDescription) VALUES ('2024-11-09 21:38:52',0,16,'2024-11-09 21:38:52','','Unauthorized Transit Entry 2') 09/11/2024 21:38:55.0179 596 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 09/11/2024 21:39:49.0999 1001 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 2 09/11/2024 21:42:06.3243 603 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 09/11/2024 21:42:58.9664 677 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2024-11-09 21:42:58' where payTraUID = 4633911812342760 and payStatus='V' and payEnabled=1 09/11/2024 21:43:01.3370 582 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 09/11/2024 21:43:25.0428 548 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 09/11/2024 21:45:32.7078 776 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 09/11/2024 21:45:51.0680 666 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 09/11/2024 21:46:41.4336 798 ms. EXEC: update abbCards set carLastDate = '2024-11-09 21:46:40',carLastDirection='I' where carStatus='V' and carId = 147 09/11/2024 21:46:48.6654 1052 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 09/11/2024 21:47:14.2014 550 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 09/11/2024 21:51:06.6533 584 ms. EXEC: insert into abbPayment (payCreation,payCode,payAmount,payCredit,payPayUID,payCarId,payDateFrom,payDateTo) VALUES ('2024-11-09 21:51:06','0230004100121',0,0,4863576714077720,147,'0000-00-00 00:00:00','0000-00-00 00:00:00') 09/11/2024 21:51:08.1673 516 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2024-11-09 21:51:07' where payTraUID = 5070449593032340 and payStatus='V' and payEnabled=1 09/11/2024 21:54:18.8913 637 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 09/11/2024 21:56:38.8966 544 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 09/11/2024 21:56:40.7468 518 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 09/11/2024 21:56:53.0970 502 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 09/11/2024 21:57:11.3362 908 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 09/11/2024 21:57:48.0727 601 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2024-11-09 21:57:47' where payTraUID = 5317865220986000 and payStatus='V' and payEnabled=1 09/11/2024 21:59:40.6507 748 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2024-11-09 21:59:39' where payTraUID = 5560892879830350 and payStatus='V' and payEnabled=1 09/11/2024 21:59:44.1670 579 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 09/11/2024 22:03:48.4187 1252 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 09/11/2024 22:04:46.5614 2060 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 09/11/2024 22:07:17.1988 556 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 09/11/2024 22:08:37.9025 1263 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 09/11/2024 22:10:37.1510 813 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,'2024-11-09 22:10:36','V',4854275177839060,2024,'2024-11-09 22:10:35','456037983500327005012999',1,2,16,'I','',1,0,1,'','',4) 09/11/2024 22:12:01.9205 619 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 09/11/2024 22:12:21.9988 772 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 09/11/2024 22:18:05.9940 900 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 09/11/2024 22:18:44.8048 532 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 09/11/2024 22:19:42.0960 873 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 09/11/2024 22:23:37.1356 1860 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 09/11/2024 22:24:08.5555 2279 ms. EXEC: update abbSubscriptions set subCredit = round(subCredit-0,5),subLastDebit = '2024-11-09 22:24:06' where subId = 43 09/11/2024 22:24:24.4241 992 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 09/11/2024 22:24:45.0558 2321 ms. OPEN: SELECT traId,traCode,traDateTime,traEnabled FROM movTransitId INNER JOIN movTransit ON traId = tidTraId AND tidTraKey=@tidTraKey WHERE traStatus='V' AND traDirection = 'I' AND traCarId = 0 AND traEnabled = 1 ORDER BY traId DESC LIMIT 100 09/11/2024 22:26:59.2142 533 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 09/11/2024 22:27:00.8643 1196 ms. EXEC: insert into movBarrier (barUseId,barCreation,barTerId,barAction,barDescription,barPlate) VALUES (1,'2024-11-09 22:26:59',9999,'open','Send command to entry/exit units: Command OPEN on Device Exit 1 ','') 09/11/2024 22:27:48.6301 556 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 09/11/2024 22:29:05.3882 508 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 09/11/2024 22:29:15.9653 1456 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 ('2024-11-09 22:26:47',9,'V',4872485265858970,4797256068582300,2024,'2024-11-09 22:26:47',4,1,0,4,'2024-11-09 22:41:47','P','KES',200,200,0,'','','',1,200,0,0,'',0,0) 09/11/2024 22:29:16.8899 836 ms. EXEC: insert into movOperator (opeCreation,opeTerId,opeUseId,opeDateTime,opeCode,opeDescription) VALUES ('2024-11-09 22:29:16',4,9,'2024-11-09 22:29:16','456036959700327005012999','Payed (Credit Card ) Ticket ') 09/11/2024 22:30:19.7338 637 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 09/11/2024 22:30:46.1424 540 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 09/11/2024 22:30:50.1220 2652 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 09/11/2024 22:31:03.3798 744 ms. EXEC: update payReceipt set recCreation = '2024-11-09 22:31:02',recModify = '2024-11-09 22:31:02',recUseId=0,recStatus='V' where recId = 321123 09/11/2024 22:31:47.7494 626 ms. EXEC: insert into movOperator (opeCreation,opeTerId,opeUseId,opeDateTime,opeCode,opeDescription) VALUES ('2024-11-09 22:31:47',17,1,'2024-11-09 22:31:47','456037084300327005012999','Pagato (Contanti ) Biglietto ') 09/11/2024 22:32:13.3114 642 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 ('2024-11-09 22:30:06',1,'V',5714551555343980,5254391956015840,2024,'2024-11-09 22:30:06',17,1,0,4,'2024-11-09 22:45:06','C','KES',100,100,0,'','','',1,100,0,0,'',0,0) 09/11/2024 22:32:27.8711 523 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 09/11/2024 22:33:56.2641 1024 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 09/11/2024 22:33:57.8351 1182 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 09/11/2024 22:34:02.1660 560 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 09/11/2024 22:34:17.7324 547 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 09/11/2024 22:35:43.4685 664 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2024-11-09 22:35:42' where traUID = 5330732137393350 and traStatus='V' and traEnabled=1 09/11/2024 22:35:51.4738 839 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 09/11/2024 22:35:57.2036 1204 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 2 OR lnsTerId=2) 09/11/2024 22:35:59.6243 570 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 09/11/2024 22:36:07.4955 709 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 09/11/2024 22:38:07.2623 705 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 09/11/2024 22:38:24.2696 592 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2024-11-09 22:38:23' where payTraUID = 4676254530339530 and payStatus='V' and payEnabled=1 09/11/2024 22:40:11.2259 1021 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 09/11/2024 22:41:04.1241 1372 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 16 OR lnsTerId=16) 09/11/2024 22:42:21.6087 613 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 09/11/2024 22:43:28.2701 701 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 09/11/2024 22:44:54.5856 1831 ms. EXEC: update payReceipt set recCreation = '2024-11-09 22:44:52',recModify = '2024-11-09 22:44:52',recUseId=0,recStatus='V' where recId = 321128 09/11/2024 22:45:19.1620 571 ms. OPEN: select * from tabArea where areStatus='V' and areEnabled = 1 AND areId = 1 09/11/2024 22:45:36.8638 1683 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 5 and terStatus='V' 09/11/2024 22:45:41.2517 677 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,'2024-11-09 22:45:40','V',5659713740746980,2024,'2024-11-09 22:45:39','456038193900327005012999',1,2,16,'I','',1,0,1,'','',4) 09/11/2024 22:46:22.0719 891 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 09/11/2024 22:48:05.9991 703 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 09/11/2024 22:48:09.6416 541 ms. EXEC: INSERT INTO movOperator (opeCreation,opeUseId,opeTerId,opeDateTime,opeCode,opeDescription) VALUES ('2024-11-09 22:48:09',0,16,'2024-11-09 22:48:09','','Unauthorized Transit Entry 2') 09/11/2024 22:49:13.3390 1840 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 09/11/2024 22:49:20.1946 682 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 09/11/2024 22:50:45.7015 799 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 ('2024-11-09 22:50:44',0,'V',5064473940779300,5165686324461060,2024,'2024-11-09 22:50:44',18,1,0,4,'2024-11-09 23:05:44','C','KES',100,100,0,'','','',1,100,0,0,'',0,0) 09/11/2024 22:50:52.5381 533 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 09/11/2024 22:53:23.5046 866 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 09/11/2024 22:54:42.1620 741 ms. OPEN: select * from tabArea where areStatus='V' and areEnabled = 1 AND areId = 1 09/11/2024 22:58:20.2453 688 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 1 09/11/2024 22:58:24.1709 912 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 09/11/2024 22:59:35.7096 1533 ms. EXEC: update abbAreaGroup set argNrInside = argNrInside + 1 where argStatus='V' and argAreId = 1 and argAbgId = 99999 09/11/2024 23:00:02.1262 710 ms. OPEN: select * from tabArea where areStatus='V' and areEnabled = 1 AND areId = 1 09/11/2024 23:00:26.1832 917 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 09/11/2024 23:00:40.0935 545 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 09/11/2024 23:04:08.3002 960 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 09/11/2024 23:08:47.8424 575 ms. EXEC: update opeActivities set acvFstPayId = (case acvFstPayId when 0 then 369470 else acvFstPayId end),acvLstPayId = 369470 where acvSftId = 825 and acvCodeId = 3 09/11/2024 23:08:48.7460 858 ms. EXEC: update tabTerminalReceipt set trcProgressive = 7045, trcLastPrinted = '2400607045', trcLastDate = '2024-11-09 23:08:47' where trcStatus='V' and trcTerId = 17 09/11/2024 23:10:34.1892 603 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 09/11/2024 23:11:38.7412 694 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,'2024-11-09 23:11:38','V',5470144972112490,2024,'2024-11-09 23:11:37','456034888700327005012999',2,2,2,'O','',0,'2024-11-09 23:11:38',1,'','',0) 09/11/2024 23:11:39.6759 852 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 09/11/2024 23:11:43.1372 1167 ms. EXECSCALAR: select sum(parAllowNegativePlaces) from tabParameters where parStatus='V' order by parId desc limit 1 nr: 0 09/11/2024 23:17:20.8701 595 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 09/11/2024 23:19:03.8838 1232 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2024-11-09 23:19:02' where traUID = 4985336482933400 and traStatus='V' and traEnabled=1 09/11/2024 23:20:59.3737 869 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 ('2024-11-09 23:20:55',0,'V',4618157391922230,5196105972125620,2024,'2024-11-09 23:20:55',3,1,0,4,'2024-11-09 23:35:55','C','KES',150,100,100,'',' ',' ',98,150,0,0,'',0,0) 09/11/2024 23:24:23.3956 751 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 09/11/2024 23:24:28.7942 2820 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 16 OR lnsTerId=16) (WAIT TIME 70 ms.) 09/11/2024 23:27:10.5940 723 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2024-11-09 23:27:09' where payTraUID = 4913524218982880 and payStatus='V' and payEnabled=1 09/11/2024 23:27:21.4582 645 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 09/11/2024 23:27:54.1310 616 ms. EXEC: insert into payReceipt (recTraUID,recPayUID,recYear,recDateTime,recText,recInvalid) VALUES (4948447633953470,4979417142323360,2024,'2024-11-09 23:27:53',' Date: 11/9/2024 11:27:52 PM Code: 456038339900327001012999 Entry Date: 11/9/2024 11:09:59 PM Plate: Class: Cars Park: The Mall Gate: Entry 1 ______________________________ Total: 100.00 KES ______________________________ Paid: 100.00 KES __________ Change: 0.00 KES Type: Cash Dispozitiv: MPESA # 2400749072 ',0) 09/11/2024 23:28:03.4162 501 ms. OPEN: show columns from tabParameters where Field = 'parUseCulture' 09/11/2024 23:28:04.2647 582 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 09/11/2024 23:28:23.0843 601 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 09/11/2024 23:28:56.1403 609 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 09/11/2024 23:30:44.7767 661 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 09/11/2024 23:31:43.6319 577 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 4 and terStatus='V' 09/11/2024 23:34:49.7909 846 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 09/11/2024 23:37:21.4809 587 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 09/11/2024 23:39:28.1143 581 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 09/11/2024 23:43:24.5186 749 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 09/11/2024 23:44:37.3061 1115 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 09/11/2024 23:48:18.7586 626 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 09/11/2024 23:48:58.0938 562 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 09/11/2024 23:50:32.6378 1934 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 09/11/2024 23:55:43.7772 914 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 09/11/2024 23:55:45.4313 685 ms. EXEC: INSERT INTO movOperator (opeCreation,opeUseId,opeTerId,opeDateTime,opeCode,opeDescription) VALUES ('2024-11-09 23:55:44',0,16,'2024-11-09 23:55:44','','Unauthorized Transit Entry 2')