11/02/2025 00:08:04.1415 2632 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/02/2025 00:13:02.7304 1401 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/02/2025 00:17:28.2210 586 ms. EXEC: insert into movtransit (traUseId,traCreation,traStatus,traUID,traYear,traDateTime,traCode,traType,traClass,traIdTerminal,traDirection,traPlate,traEnabled,traDisableTime,traAreId,traNotes,traBadge,traTarId) VALUES (0,'2025-02-11 00:17:27','V',4732296360537050,2025,'2025-02-11 00:17:26','456968575200327005012999',2,2,2,'O','',0,'2025-02-11 00:17:27',1,'','',0) 11/02/2025 00:29:26.6515 697 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/02/2025 00:33:57.0744 2306 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 2 11/02/2025 00:45:04.6937 1228 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/02/2025 00:54:21.2430 758 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/02/2025 00:57:20.7808 571 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/02/2025 01:02:30.4292 2098 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/02/2025 01:04:28.7428 1570 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/02/2025 01:13:33.9937 2282 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/02/2025 01:23:12.8102 664 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/02/2025 01:27:19.2520 828 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/02/2025 01:45:36.5654 884 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/02/2025 01:48:00.0169 524 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/02/2025 01:50:28.7910 584 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 11/02/2025 02:27:34.9761 2075 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/02/2025 02:30:43.7341 881 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/02/2025 02:38:07.5667 672 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/02/2025 02:44:07.1957 503 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/02/2025 02:55:16.7193 769 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/02/2025 03:03:09.3383 734 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 3 and terStatus='V' 11/02/2025 03:31:09.5106 655 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/02/2025 03:39:58.3125 762 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/02/2025 03:46:22.1998 807 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/02/2025 03:53:47.4804 1502 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/02/2025 03:58:32.8645 910 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/02/2025 04:02:28.2171 986 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/02/2025 04:12:18.8576 1540 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/02/2025 04:18:05.2076 501 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/02/2025 04:30:18.5841 1025 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/02/2025 04:38:10.6708 533 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 11/02/2025 04:39:03.5164 515 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/02/2025 04:41:03.0218 530 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 3 11/02/2025 04:43:42.2419 1190 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/02/2025 04:45:41.9525 1181 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/02/2025 04:47:42.8298 1896 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/02/2025 04:52:58.4142 539 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/02/2025 04:54:59.1614 526 ms. EXEC: insert into movOperator (opeCreation,opeTerId,opeUseId,opeDateTime,opeCode,opeDescription) VALUES ('2025-02-11 04:54:58',4,9,'2025-02-11 04:54:58','456971477600327005012999','Payed (Credit Card ) Ticket ') 11/02/2025 04:55:33.2564 854 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/02/2025 04:58:43.9997 2010 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/02/2025 05:07:42.8443 608 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 2 11/02/2025 05:08:26.0954 643 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 3 11/02/2025 05:11:19.0688 538 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/02/2025 05:14:45.2995 742 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/02/2025 05:17:52.8988 683 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/02/2025 05:18:21.0857 678 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 3 OR lnsTerId=3) 11/02/2025 05:21:14.4134 553 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/02/2025 05:34:37.8600 551 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/02/2025 05:51:54.3185 615 ms. EXEC: update payReceipt set recCreation = '2025-02-11 05:51:53',recModify = '2025-02-11 05:51:53',recUseId=0,recStatus='V' where recId = 351268 11/02/2025 05:51:57.2714 814 ms. EXEC: update tabTerminalReceipt set trcProgressive = 6072, trcLastPrinted = '2500706072', trcLastDate = '2025-02-11 05:51:56' where trcStatus='V' and trcTerId = 18 11/02/2025 05:52:26.0258 772 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/02/2025 05:52:27.0425 635 ms. EXEC: update tabTerminalReceipt set trcProgressive = 6073, trcLastPrinted = '2500706073', trcLastDate = '2025-02-11 05:52:26' where trcStatus='V' and trcTerId = 18 11/02/2025 05:52:55.8709 696 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 5 11/02/2025 05:53:49.3279 504 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 11/02/2025 05:57:10.4542 576 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 11/02/2025 06:01:29.6236 1206 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/02/2025 06:01:47.2965 1262 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/02/2025 06:07:46.9215 522 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/02/2025 06:19:21.2797 506 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/02/2025 06:19:37.3706 3562 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 11/02/2025 06:38:59.5016 2768 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/02/2025 06:42:07.0017 515 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/02/2025 06:50:47.5610 1876 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/02/2025 07:06:30.5386 597 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/02/2025 07:22:54.3416 673 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 11/02/2025 07:24:03.3310 592 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/02/2025 07:31:16.0782 1401 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 5 11/02/2025 07:31:55.1145 640 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/02/2025 07:36:17.1098 1085 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/02/2025 07:38:29.7480 775 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/02/2025 07:41:53.2109 626 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 11/02/2025 07:45:13.4517 1274 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/02/2025 07:47:00.1105 741 ms. OPEN: show columns from tabParameters where Field = 'parUseCulture' 11/02/2025 07:47:01.3953 544 ms. EXECSCALAR: select count(*) from tabTerminalExtraMem where extStatus='V' and extTerId = 1 nr: 1 11/02/2025 07:47:01.6275 765 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 11/02/2025 07:52:44.5332 625 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 11/02/2025 07:52:52.9109 552 ms. EXEC: insert into payPayment (payCreation,payUseId,payStatus,payUID,payTraUID,payYear,payDateTime,payIdTerminal,payEnabled,payDisableTime,payTarId,payTimeLimit,payType,payCurrency,payAmount,payPayed,payChange,payCardType,payPAN,paySTAN,payIdEvent,payAmountCalc,payDiscountValue,payDiscount,payDiscountType,payVatPercent,payVatAmount) VALUES ('2025-02-11 07:52:52',0,'V',5066895636041750,5299672611836050,2025,'2025-02-11 07:52:52',18,1,0,4,'2025-02-11 08:07:52','C','KES',50,50,0,'','','',1,50,0,0,'',0,0) 11/02/2025 07:56:46.2799 559 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/02/2025 07:56:54.2803 984 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/02/2025 08:00:19.7626 2383 ms. EXEC: insert into payPayment (payCreation,payUseId,payStatus,payUID,payTraUID,payYear,payDateTime,payIdTerminal,payEnabled,payDisableTime,payTarId,payTimeLimit,payType,payCurrency,payAmount,payPayed,payChange,payCardType,payPAN,paySTAN,payIdEvent,payVatPercent,payVatAmount) VALUES ('2025-02-11 08:00:16',0,'V',5104874437351460,5220807802375270,2025,'2025-02-11 08:00:16',2,1,0,-1,'2025-02-11 09:00:16','S','KES',0,0,0,'','','',3,0,0) 11/02/2025 08:00:44.6393 635 ms. EXEC: insert into movtransit (traUseId,traCreation,traStatus,traUID,traYear,traDateTime,traCode,traType,traClass,traIdTerminal,traDirection,traPlate,traEnabled,traDisableTime,traAreId,traNotes,traBadge,traCarId,traTarId) VALUES (0,'2025-02-11 08:00:44','V',4997113543051070,2025,'2025-02-11 08:00:43','456972884300327005012999',1,2,16,'I','',1,0,1,'','0810007115885',167,0) 11/02/2025 08:00:45.8931 584 ms. EXEC: update abbCards set carLastDate = '2025-02-11 08:00:45',carLastDirection='I' where carStatus='V' and carId = 167 11/02/2025 08:00:50.7604 504 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 11/02/2025 08:02:46.9396 2098 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 11/02/2025 08:02:47.7011 678 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 11/02/2025 08:03:23.3291 619 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 11/02/2025 08:03:26.2000 996 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/02/2025 08:04:02.6355 1254 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 11/02/2025 08:05:34.1961 1483 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/02/2025 08:08:00.4165 502 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 11/02/2025 08:18:12.4782 850 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 11/02/2025 08:20:14.0870 2918 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2025-02-11 08:20:11',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'; 11/02/2025 08:20:15.0617 970 ms. EXEC: update payInventory set invCreation = '2025-02-11 08:20:14',invModify = '2025-02-11 08:20:14',invUseId=0,invStatus='V' where invId = 236198 11/02/2025 08:20:41.4504 3471 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/02/2025 08:22:41.4472 655 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/02/2025 08:28:13.5887 629 ms. EXEC: insert into movtransit (traUseId,traCreation,traStatus,traUID,traYear,traDateTime,traCode,traType,traClass,traIdTerminal,traDirection,traPlate,traEnabled,traDisableTime,traAreId,traNotes,traBadge,traCarId,traTarId) VALUES (0,'2025-02-11 08:28:12','V',4665176942189070,2025,'2025-02-11 08:28:10','456973049000327005012999',1,2,16,'I','',1,0,1,'','0230004101194',30,0) 11/02/2025 08:30:29.8584 933 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/02/2025 08:31:43.3899 599 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 11/02/2025 08:34:32.3255 601 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 11/02/2025 08:34:34.7632 503 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/02/2025 08:34:35.2635 1015 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 11/02/2025 08:35:36.9550 958 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/02/2025 08:38:43.6587 1129 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/02/2025 08:39:13.2646 896 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/02/2025 08:41:41.7245 559 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/02/2025 08:43:15.4306 906 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/02/2025 08:44:32.0361 1339 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/02/2025 08:48:06.9817 1125 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/02/2025 08:52:43.2336 542 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 11/02/2025 08:55:53.7829 891 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 1 OR lnsTerId=1) 11/02/2025 08:58:06.3000 560 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 5 and terStatus='V' 11/02/2025 08:58:10.3217 1848 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/02/2025 08:59:46.0772 547 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/02/2025 09:01:55.6153 529 ms. EXEC: insert into paycash (casCreation,casModify,casUseId,casStatus,casUID,casTraUID,casYear,casDateTime,casIdTerminal,casCurrency,casNumber,casSingleAmount,casTotAmount,casType,casDescription) VALUES ('2025-02-11 09:01:55',0,0,'V',5128450663000140,5620436625159230,2025,'2025-02-11 09:01:55',3,'KES',1,100,100,'N',''); 11/02/2025 09:01:57.3655 1370 ms. EXEC: update payInventory set invCreation = '2025-02-11 09:01:55',invModify = '2025-02-11 09:01:55',invUseId=0,invStatus='V' where invId = 236199 11/02/2025 09:03:50.5757 622 ms. EXEC: insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2025-02-11 09:03:49',5,3,0,2,0,0,0,0,'2','') 11/02/2025 09:04:46.9176 975 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/02/2025 09:05:43.2485 582 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 11/02/2025 09:05:58.4017 907 ms. EXEC: insert into movtransit (traUseId,traCreation,traStatus,traUID,traYear,traDateTime,traCode,traType,traClass,traIdTerminal,traDirection,traPlate,traEnabled,traDisableTime,traAreId,traNotes,traBadge,traCarId,traTarId) VALUES (0,'2025-02-11 09:05:57','V',5720633516826480,2025,'2025-02-11 09:05:56','456973275600327005012999',1,2,16,'I','',1,0,1,'','0750009437080',92,4) 11/02/2025 09:06:09.4531 649 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 11/02/2025 09:13:19.0012 595 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 11/02/2025 09:14:22.1857 1826 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/02/2025 09:15:28.7475 603 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/02/2025 09:16:39.1239 1126 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/02/2025 09:16:39.1239 648 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 11/02/2025 09:16:41.8747 1440 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/02/2025 09:16:41.9838 926 ms. OPEN: select * from tabParameters where parStatus='V' order by parId desc limit 1 11/02/2025 09:16:48.1549 555 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 11/02/2025 09:16:53.3694 2049 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/02/2025 09:16:59.4165 3011 ms. EXEC: insert into movtransit (traUseId,traCreation,traStatus,traUID,traYear,traDateTime,traCode,traType,traClass,traIdTerminal,traDirection,traPlate,traEnabled,traDisableTime,traAreId,traNotes,traBadge,traTarId) VALUES (0,'2025-02-11 09:16:56','V',5082188589936850,2025,'2025-02-11 09:16:55','456973341500327005012999',1,2,16,'I','',1,0,1,'','',4) 11/02/2025 09:17:41.4578 572 ms. EXEC: insert into payPayment (payCreation,payUseId,payStatus,payUID,payTraUID,payYear,payDateTime,payIdTerminal,payEnabled,payDisableTime,payTarId,payTimeLimit,payType,payCurrency,payAmount,payPayed,payChange,payCardType,payPAN,paySTAN,payIdEvent,payAmountCalc,payDiscountValue,payDiscount,payDiscountType,payVatPercent,payVatAmount) VALUES ('2025-02-11 09:16:50',9,'V',5114562390334420,5485010185077070,2025,'2025-02-11 09:16:50',4,1,0,4,'2025-02-11 09:31:50','P','KES',50,50,0,'','','',1,50,0,0,'',0,0) 11/02/2025 09:17:42.4124 504 ms. EXEC: update opeActivities set acvFstPayId = (case acvFstPayId when 0 then 404818 else acvFstPayId end),acvLstPayId = 404818 where acvSftId = 872 and acvCodeId = 3 11/02/2025 09:18:56.1020 1131 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/02/2025 09:20:20.8931 535 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/02/2025 09:21:02.7693 7447 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/02/2025 09:21:54.3800 1677 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/02/2025 09:22:03.3991 605 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/02/2025 09:22:44.0804 540 ms. EXEC: update abbCards set carLastDate = '2025-02-11 09:22:43',carLastDirection='I' where carStatus='V' and carId = 142 11/02/2025 09:24:17.4833 779 ms. EXEC: insert into movtransit (traUseId,traCreation,traStatus,traUID,traYear,traDateTime,traCode,traType,traClass,traIdTerminal,traDirection,traPlate,traEnabled,traDisableTime,traAreId,traNotes,traBadge,traTarId) VALUES (0,'2025-02-11 09:24:16','V',4934425204641590,2025,'2025-02-11 09:24:15','456972912500327001012999',2,2,2,'O','',0,'2025-02-11 09:24:16',1,'','',0) 11/02/2025 09:24:19.5347 772 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 16 OR lnsTerId=16) 11/02/2025 09:26:24.4497 828 ms. EXEC: update payReceipt set recCreation = '2025-02-11 09:26:23',recModify = '2025-02-11 09:26:23',recUseId=0,recStatus='V' where recId = 351295 11/02/2025 09:26:34.4104 758 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/02/2025 09:28:45.7218 638 ms. EXEC: insert into movtransit (traUseId,traCreation,traStatus,traUID,traYear,traDateTime,traCode,traType,traClass,traIdTerminal,traDirection,traPlate,traEnabled,traDisableTime,traAreId,traNotes,traBadge,traTarId) VALUES (0,'2025-02-11 09:28:45','V',4840897684970780,2025,'2025-02-11 09:28:44','456973233300327005012999',2,2,2,'O','',0,'2025-02-11 09:28:45',1,'','',0) 11/02/2025 09:29:35.3822 624 ms. EXEC: insert into movtransit (traUseId,traCreation,traStatus,traUID,traYear,traDateTime,traCode,traType,traClass,traIdTerminal,traDirection,traPlate,traEnabled,traDisableTime,traAreId,traNotes,traBadge,traCarId,traTarId) VALUES (0,'2025-02-11 09:29:34','V',5224101805878570,2025,'2025-02-11 09:29:33','456973417300327005012999',1,2,16,'I','',1,0,1,'','0810007113876',103,0) 11/02/2025 09:31:15.7437 755 ms. EXEC: update abbSubscriptions set subCredit = round(subCredit-50,5),subLastDebit = '2025-02-11 09:31:14' where subId = 94 11/02/2025 09:31:16.4862 742 ms. EXEC: insert into abbPayment (payCreation,payCode,payAmount,payCredit,payPayUID,payCarId,payDateFrom,payDateTo) VALUES ('2025-02-11 09:31:15','0750009437080',-50,9400,4909177042685850,92,'0000-00-00 00:00:00','0000-00-00 00:00:00') 11/02/2025 09:31:18.6287 1280 ms. OPEN: select * from tabArea where areId = 1 and areStatus='V' and areEnabled = 1 11/02/2025 09:31:38.0518 1687 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 2 and terStatus='V' 11/02/2025 09:36:59.9594 592 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/02/2025 09:38:58.5602 558 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/02/2025 09:39:04.7503 1143 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 11/02/2025 09:39:21.1554 673 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/02/2025 09:45:58.8600 984 ms. EXECSCALAR: select count(resId) as Tot from movReservation where resStatus = 'V' and resTypeRes = 'B' AND ((resConfirmed IN (0,2,3) AND resCreation>'2025-02-11 08:45:57') OR resConfirmed IN (4,5)) and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) <= '2025-02-11 09:45:57' and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) >= '2025-02-11 09:45:57' and (resAreId = 1 or resAreId <= 0) nr: 0 11/02/2025 09:46:02.9277 540 ms. EXEC: insert into movtransit (traUseId,traCreation,traStatus,traUID,traYear,traDateTime,traCode,traType,traClass,traIdTerminal,traDirection,traPlate,traEnabled,traDisableTime,traAreId,traNotes,traBadge,traTarId) VALUES (0,'2025-02-11 09:46:02','V',5684714057929570,2025,'2025-02-11 09:46:01','456973516100327005012999',1,2,16,'I','',1,0,1,'','',4) 11/02/2025 09:51:29.3494 1078 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/02/2025 09:55:14.1887 1135 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/02/2025 09:56:18.9233 634 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 11/02/2025 09:57:23.7669 1694 ms. EXEC: insert into payPayment (payCreation,payUseId,payStatus,payUID,payTraUID,payYear,payDateTime,payIdTerminal,payEnabled,payDisableTime,payTarId,payTimeLimit,payType,payCurrency,payAmount,payPayed,payChange,payCardType,payPAN,paySTAN,payIdEvent,payAmountCalc,payDiscountValue,payDiscount,payDiscountType,payVatPercent,payVatAmount) VALUES ('2025-02-11 09:57:20',0,'V',4691399944039210,5247387886920990,2025,'2025-02-11 09:57:20',3,1,0,4,'2025-02-11 10:12:20','C','KES',50,50,0,'',' ',' ',1,50,0,0,'',0,0) 11/02/2025 10:00:01.1898 715 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/02/2025 10:01:03.2146 680 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/02/2025 10:02:28.7791 647 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 11/02/2025 10:02:46.1989 2966 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/02/2025 10:03:08.1176 1900 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/02/2025 10:04:08.4382 1699 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/02/2025 10:04:36.2509 1460 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 11/02/2025 10:06:00.1414 550 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/02/2025 10:06:25.6575 594 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/02/2025 10:06:31.4434 1492 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/02/2025 10:09:59.3343 2753 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/02/2025 10:11:11.9492 646 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 11/02/2025 10:11:12.2464 994 ms. OPEN: show columns from tabParameters where Field = 'parAllowNegativePlaces' 11/02/2025 10:13:00.2260 1034 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/02/2025 10:14:34.7567 967 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/02/2025 10:14:46.5746 631 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 11/02/2025 10:18:51.9597 1397 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/02/2025 10:19:51.6909 1857 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/02/2025 10:23:32.8447 1601 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 11/02/2025 10:27:19.8775 2643 ms. EXEC: insert into movtransit (traUseId,traCreation,traStatus,traUID,traYear,traDateTime,traCode,traType,traClass,traIdTerminal,traDirection,traPlate,traEnabled,traDisableTime,traAreId,traNotes,traBadge,traCarId,traTarId) VALUES (0,'2025-02-11 10:27:17','V',5693023192980650,2025,'2025-02-11 10:27:15','456973763500327005012999',1,2,16,'I','',1,0,1,'','0230003944081',15,0) 11/02/2025 10:27:20.7881 522 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 11/02/2025 10:27:31.7445 737 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 11/02/2025 10:27:34.8876 681 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 11/02/2025 10:32:04.7412 2041 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/02/2025 10:32:07.2269 664 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 11/02/2025 10:32:07.2789 635 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/02/2025 10:32:17.6169 624 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 16 OR lnsTerId=16) 11/02/2025 10:32:17.6409 554 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/02/2025 10:32:27.9678 582 ms. EXEC: update abbSubscriptions set subCredit = round(subCredit-0,5),subLastDebit = '2025-02-11 10:32:27' where subId = 181 11/02/2025 10:32:55.8086 1845 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/02/2025 10:36:14.8805 1161 ms. EXEC: insert into abbPayment (payCreation,payCode,payAmount,payCredit,payPayUID,payCarId,payDateFrom,payDateTo) VALUES ('2025-02-11 10:36:13','0230003944059',0,0,4655666728107160,13,'0000-00-00 00:00:00','0000-00-00 00:00:00') 11/02/2025 10:36:15.7821 606 ms. EXEC: insert into movtransit (traUseId,traCreation,traStatus,traUID,traYear,traDateTime,traCode,traType,traClass,traIdTerminal,traDirection,traPlate,traEnabled,traDisableTime,traAreId,traNotes,traBadge,traCarId,traTarId) VALUES (0,'2025-02-11 10:36:15','V',5572734492153280,2025,'2025-02-11 10:36:12','456973598300327005012999',2,2,2,'O','',0,'2025-02-11 10:36:15',1,'','0230003944059',13,0) 11/02/2025 10:36:22.8479 2159 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/02/2025 10:37:45.9358 550 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2025-02-11 10:37:45' where traUID = 5361781183276840 and traStatus='V' and traEnabled=1 11/02/2025 10:46:29.1879 777 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/02/2025 10:47:11.4193 1068 ms. EXEC: insert into movtransit (traUseId,traCreation,traStatus,traUID,traYear,traDateTime,traCode,traType,traClass,traIdTerminal,traDirection,traPlate,traEnabled,traDisableTime,traAreId,traNotes,traBadge,traTarId) VALUES (0,'2025-02-11 10:47:10','V',5030006082485950,2025,'2025-02-11 10:47:09','456973882900327005012999',1,2,16,'I','',1,0,1,'','',4) 11/02/2025 10:48:15.2012 527 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/02/2025 10:48:39.5286 543 ms. EXEC: update paycash set casCreation = '2025-02-11 10:48:38',casModify = '2025-02-11 10:48:38',casUseId=0,casStatus='V' where casId = 209054 11/02/2025 10:49:28.1413 1045 ms. EXEC: insert into payPayment (payCreation,payUseId,payStatus,payUID,payTraUID,payYear,payDateTime,payIdTerminal,payEnabled,payDisableTime,payTarId,payTimeLimit,payType,payCurrency,payAmount,payPayed,payChange,payCardType,payPAN,paySTAN,payIdEvent,payAmountCalc,payDiscountValue,payDiscount,payDiscountType,payVatPercent,payVatAmount) VALUES ('2025-02-11 10:49:25',0,'V',5328050497240060,5360957015787940,2025,'2025-02-11 10:49:25',3,1,0,4,'2025-02-11 11:04:25','C','KES',100,100,0,'',' ',' ',1,100,0,0,'',0,0) 11/02/2025 10:50:02.7306 804 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/02/2025 10:50:02.8277 786 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 2 11/02/2025 10:51:06.6916 548 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 11/02/2025 10:51:14.8451 676 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 11/02/2025 10:51:27.0754 1324 ms. EXEC: insert into payPayment (payCreation,payUseId,payStatus,payUID,payTraUID,payYear,payDateTime,payIdTerminal,payEnabled,payDisableTime,payTarId,payTimeLimit,payType,payCurrency,payAmount,payPayed,payChange,payCardType,payPAN,paySTAN,payIdEvent,payAmountCalc,payDiscountValue,payDiscount,payDiscountType,payVatPercent,payVatAmount) VALUES ('2025-02-11 10:51:25',0,'V',5215257518899230,5329567766777820,2025,'2025-02-11 10:51:25',18,1,0,4,'2025-02-11 11:06:25','C','KES',50,50,0,'','','',1,50,0,0,'',0,0) 11/02/2025 10:51:47.0278 561 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 11/02/2025 10:52:01.5816 677 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 11/02/2025 10:53:24.5894 726 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 11/02/2025 10:55:24.3530 553 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 11/02/2025 10:59:15.8818 761 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/02/2025 11:01:12.0910 604 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 11/02/2025 11:02:01.9085 1164 ms. OPEN: select * from tabArea where areStatus='V' and areEnabled = 1 AND areId = 1 11/02/2025 11:02:58.1074 1332 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 11/02/2025 11:03:07.6678 880 ms. OPEN: select * from tabArea where areStatus='V' and areEnabled = 1 AND areId = 1 11/02/2025 11:03:15.7262 848 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/02/2025 11:03:22.4988 2092 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 5 11/02/2025 11:05:39.1287 2781 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/02/2025 11:05:47.0210 1650 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/02/2025 11:05:52.4907 1891 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 5 11/02/2025 11:06:02.7326 786 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/02/2025 11:06:13.8701 2000 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/02/2025 11:06:28.3889 1958 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 2 OR lnsTerId=2) 11/02/2025 11:06:45.2572 584 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 11/02/2025 11:07:34.2081 1087 ms. EXEC: insert into payPayment (payCreation,payUseId,payStatus,payUID,payTraUID,payYear,payDateTime,payIdTerminal,payEnabled,payDisableTime,payTarId,payTimeLimit,payType,payCurrency,payAmount,payPayed,payChange,payCardType,payPAN,paySTAN,payIdEvent,payAmountCalc,payDiscountValue,payDiscount,payDiscountType,payVatPercent,payVatAmount) VALUES ('2025-02-11 11:07:33',0,'V',5194856934606860,5494168961099710,2025,'2025-02-11 11:07:33',18,1,0,4,'2025-02-11 11:22:33','C','KES',100,100,0,'','','',1,100,0,0,'',0,0) 11/02/2025 11:07:35.0477 820 ms. EXEC: update tabTerminalReceipt set trcProgressive = 6097, trcLastPrinted = '2500706097', trcLastDate = '2025-02-11 11:07:34' where trcStatus='V' and trcTerId = 18 11/02/2025 11:07:36.5887 1020 ms. OPEN: select * from payCurInventory where curTerId = 18 and curQuantity>0 and curType in ('C','N') order by curDevCode,curChannelId,curValue 11/02/2025 11:08:55.4118 753 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2025-02-11 11:08:54' where traUID = 5494168961099710 and traStatus='V' and traEnabled=1 (WAIT TIME 68 ms.) 11/02/2025 11:09:23.8960 512 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 11/02/2025 11:16:00.8221 2951 ms. EXEC: insert into payPayment (payCreation,payUseId,payStatus,payUID,payTraUID,payYear,payDateTime,payIdTerminal,payEnabled,payDisableTime,payTarId,payTimeLimit,payType,payCurrency,payAmount,payPayed,payChange,payCardType,payPAN,paySTAN,payIdEvent,payAmountCalc,payDiscountValue,payDiscount,payDiscountType,payVatPercent,payVatAmount) VALUES ('2025-02-11 11:15:46',1,'V',5350735320936740,5007400761813270,2025,'2025-02-11 11:15:46',17,1,0,4,'2025-02-11 11:30:46','C','KES',100,100,0,'','','',1,100,0,0,'',0,0) 11/02/2025 11:16:02.2100 1230 ms. EXEC: update opeActivities set acvFstPayId = (case acvFstPayId when 0 then 404873 else acvFstPayId end),acvLstPayId = 404873 where acvSftId = 889 and acvCodeId = 3 11/02/2025 11:17:01.7290 2366 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/02/2025 11:17:01.8541 4355 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2025-02-11 11:16:57' where payTraUID = 5007400761813270 and payStatus='V' and payEnabled=1 11/02/2025 11:17:34.9504 614 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2025-02-11 11:17:34' where payTraUID = 4650629762995340 and payStatus='V' and payEnabled=1 11/02/2025 11:19:32.1392 1846 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/02/2025 11:21:31.7317 1292 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/02/2025 11:25:12.3952 646 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/02/2025 11:25:12.3952 592 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 11/02/2025 11:27:28.3527 926 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/02/2025 11:31:42.8970 781 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 11/02/2025 11:31:43.8206 1594 ms. EXECSCALAR: select count(*) from information_schema.tables where table_schema= 'wisepark_0327' and table_name= 'payInvoiceFtp' nr: 1 11/02/2025 11:33:02.9719 562 ms. EXEC: insert into movtransit (traUseId,traCreation,traStatus,traUID,traYear,traDateTime,traCode,traType,traClass,traIdTerminal,traDirection,traPlate,traEnabled,traDisableTime,traAreId,traNotes,traBadge,traTarId) VALUES (0,'2025-02-11 11:33:02','V',5522683508134770,2025,'2025-02-11 11:33:01','456974060200327005012999',2,2,2,'O','',0,'2025-02-11 11:33:02',1,'','',0) 11/02/2025 11:33:10.5450 610 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 11/02/2025 11:33:24.6915 813 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 11/02/2025 11:34:41.1719 529 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 11/02/2025 11:35:11.9387 517 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/02/2025 11:35:29.5515 1053 ms. EXEC: update opeActivities set acvFstPayId = (case acvFstPayId when 0 then 404880 else acvFstPayId end),acvLstPayId = 404880 where acvSftId = 872 and acvCodeId = 3 11/02/2025 11:35:41.9629 949 ms. EXEC: insert into payPayment (payCreation,payUseId,payStatus,payUID,payTraUID,payYear,payDateTime,payIdTerminal,payEnabled,payDisableTime,payTarId,payTimeLimit,payType,payCurrency,payAmount,payPayed,payChange,payCardType,payPAN,paySTAN,payIdEvent,payAmountCalc,payDiscountValue,payDiscount,payDiscountType,payVatPercent,payVatAmount) VALUES ('2025-02-11 11:34:51',9,'V',5282958807575580,5736409855598570,2025,'2025-02-11 11:34:51',4,1,0,4,'2025-02-11 11:49:51','P','KES',100,100,0,'','','',1,100,0,0,'',0,0) 11/02/2025 11:36:12.0291 2274 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/02/2025 11:38:03.5782 601 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 11/02/2025 11:40:04.1283 523 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 5 and terStatus='V' 11/02/2025 11:42:32.4131 726 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 11/02/2025 11:42:33.3457 915 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/02/2025 11:42:37.6846 553 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 11/02/2025 11:46:00.1929 507 ms. OPEN: select * from tabArea where areStatus='V' and areEnabled = 1 AND areId = 1 11/02/2025 11:46:09.5962 1233 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 (WAIT TIME 34 ms.) 11/02/2025 11:50:43.1463 1748 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/02/2025 11:50:52.5516 989 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/02/2025 11:53:55.2418 1161 ms. EXEC: update payReceipt set recCreation = '2025-02-11 11:53:54',recModify = '2025-02-11 11:53:54',recUseId=0,recStatus='V' where recId = 351348 11/02/2025 11:55:47.6065 743 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 11/02/2025 12:00:30.5559 814 ms. EXEC: update opeActivities set acvFstPayId = (case acvFstPayId when 0 then 404892 else acvFstPayId end),acvLstPayId = 404892 where acvSftId = 889 and acvCodeId = 3 11/02/2025 12:00:43.8038 614 ms. EXEC: update tabTerminalReceipt set trcProgressive = 6106, trcLastPrinted = '2500706106', trcLastDate = '2025-02-11 12:00:43' where trcStatus='V' and trcTerId = 18 11/02/2025 12:00:44.6113 623 ms. EXEC: update payReceipt set recCreation = '2025-02-11 12:00:43',recModify = '2025-02-11 12:00:43',recUseId=0,recStatus='V' where recId = 351353 11/02/2025 12:01:38.9229 581 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/02/2025 12:02:49.6014 656 ms. EXEC: UPDATE payInventory SET invType='N' WHERE invType<>'N' AND invValue IN (100,200,500) AND invDevice IN (42102,42101,42001); 11/02/2025 12:03:13.2864 783 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 11/02/2025 12:03:13.4555 1303 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 6 11/02/2025 12:03:28.2114 883 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/02/2025 12:04:33.3592 985 ms. EXEC: insert into payPayment (payCreation,payUseId,payStatus,payUID,payTraUID,payYear,payDateTime,payIdTerminal,payEnabled,payDisableTime,payTarId,payTimeLimit,payType,payCurrency,payAmount,payPayed,payChange,payCardType,payPAN,paySTAN,payIdEvent,payAmountCalc,payDiscountValue,payDiscount,payDiscountType,payVatPercent,payVatAmount) VALUES ('2025-02-11 12:03:42',9,'V',5673746081998830,5143529913357870,2025,'2025-02-11 12:03:42',4,1,0,4,'2025-02-11 12:18:42','P','KES',50,50,0,'','','',1,50,0,0,'',0,0) 11/02/2025 12:05:00.2343 544 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/02/2025 12:07:26.5498 540 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 11/02/2025 12:08:45.6740 1021 ms. EXEC: insert into movtransit (traUseId,traCreation,traStatus,traUID,traYear,traDateTime,traCode,traType,traClass,traIdTerminal,traDirection,traPlate,traEnabled,traDisableTime,traAreId,traNotes,traBadge,traTarId) VALUES (0,'2025-02-11 12:08:44','V',4963398515151880,2025,'2025-02-11 12:08:44','456973611800327005012999',2,2,2,'O','',0,'2025-02-11 12:08:44',1,'','',0) 11/02/2025 12:09:27.4451 671 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 16 OR lnsTerId=16) 11/02/2025 12:09:50.3636 524 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 11/02/2025 12:11:28.9589 708 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 4 OR lnsTerId=4) 11/02/2025 12:12:07.7920 518 ms. OPEN: select * from tabArea where areStatus='V' and areEnabled = 1 AND areId = 1 11/02/2025 12:15:18.5454 1376 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 11/02/2025 12:17:11.9707 501 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 11/02/2025 12:19:23.8965 785 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/02/2025 12:20:29.5567 1696 ms. EXEC: insert into payPayment (payCreation,payUseId,payStatus,payUID,payTraUID,payYear,payDateTime,payIdTerminal,payEnabled,payDisableTime,payTarId,payTimeLimit,payType,payCurrency,payAmount,payPayed,payChange,payCardType,payPAN,paySTAN,payIdEvent,payAmountCalc,payDiscountValue,payDiscount,payDiscountType,payVatPercent,payVatAmount) VALUES ('2025-02-11 12:20:26',0,'V',4956201215559580,5550631049329550,2025,'2025-02-11 12:20:26',3,1,0,4,'2025-02-11 12:35:26','C','KES',50,500,400,'',' ',' ',2,50,0,0,'',0,0) 11/02/2025 12:20:30.6464 1021 ms. EXEC: insert into payReceipt (recTraUID,recPayUID,recYear,recDateTime,recText,recInvalid) VALUES (5550631049329550,4956201215559580,2025,'2025-02-11 12:20:29','---------------------------------- %The Mall P0006032390 End of payment ---------------------------------- POF Entry : 2/11/2025 11:58:32 AM Date : 2/11/2025 12:20:26 PM Code : 456974311200327005012999 Total : 50.00 KES VAT 16% : 6.90 KES ---------------------------------- Paid : 500.00 KES Coin changed : 0.00 KES Note changed : 400.00 KES Not changed Note : 50.00 KES Coin : 0.00 KES Unavailable : 0.00 KES',0) 11/02/2025 12:20:31.4980 570 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2025-02-11 12:20:30',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'; 11/02/2025 12:20:32.8119 1142 ms. EXEC: insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2025-02-11 12:20: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'; insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2025-02-11 12:20:31',3,42101,0,50,1,50,2,'I','N'); update payCurInventory set curQuantity=round(curQuantity+1,5),curAmount=round(curAmount+50,5) where curTerId = 3 and curDevCode = 42101 and curChannelId = 2 and curValue = 50 and curType = 'N'; Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2025-02-11 12:20:31',3,42101,0,100,-2,-200,1,'O','N'); update payCurInventory set curQuantity=round(curQuantity+-2,5),curAmount=round(curAmount+-200,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 ('2025-02-11 12:20:31',3,42101,0,200,-1,-200,1,'O','N'); update payCurInventory set curQuantity=round(curQuantity+-1,5),curAmount=round(curAmount+-200,5) where curTerId = 3 and curDevCode = 42101 and curChannelId = 1 and curValue = 200 and curType = 'N'; 11/02/2025 12:21:43.3894 2124 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 11/02/2025 12:21:43.3924 979 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/02/2025 12:25:55.5190 540 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 11/02/2025 12:26:46.8195 1681 ms. EXEC: insert into movtransit (traUseId,traCreation,traStatus,traUID,traYear,traDateTime,traCode,traType,traClass,traIdTerminal,traDirection,traPlate,traEnabled,traDisableTime,traAreId,traNotes,traBadge,traTarId) VALUES (0,'2025-02-11 12:26:45','V',5139646461801860,2025,'2025-02-11 12:26:43','456974000300327001012999',2,2,2,'O','',0,'2025-02-11 12:26:45',1,'','',0) 11/02/2025 12:31:45.0973 635 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/02/2025 12:31:47.4178 1653 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/02/2025 12:32:54.2538 3615 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2025-02-11 12:32:50',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'; 11/02/2025 12:34:14.7570 567 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/02/2025 12:34:28.0429 787 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 11/02/2025 12:36:14.7987 728 ms. EXEC: update payReceipt set recCreation = '2025-02-11 12:36:14',recModify = '2025-02-11 12:36:14',recUseId=0,recStatus='V' where recId = 351369 11/02/2025 12:36:39.6074 1542 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 11/02/2025 12:37:48.5728 2149 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/02/2025 12:38:26.2522 771 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 5 11/02/2025 12:38:30.1188 569 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 11/02/2025 12:42:31.4722 1116 ms. OPEN: show columns from tabParameters where Field = 'parUseCulture' 11/02/2025 12:42:31.4822 643 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 6 11/02/2025 12:42:31.4872 671 ms. EXECSCALAR: select count(*) from information_schema.tables where table_schema= 'wisepark_0327' and table_name= 'payInvoiceFtp' nr: 1 11/02/2025 12:42:32.2437 532 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 11/02/2025 12:42:36.1594 1371 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/02/2025 12:42:44.7992 557 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 11/02/2025 12:42:51.6408 550 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 11/02/2025 12:44:40.4040 542 ms. OPEN: select sum(payPayed) as vTot,sum(payChange) as vChange from movTransit inner join payPayment on payPayment.payTraUID = movTransit.traUID LEFT JOIN tabTerminal on terId = payIdTerminal WHERE traCode = '456974587700327005012999' AND traStatus='V' AND payStatus='V' and (terType IS NULL OR terType<>3 OR (terType=3 and payType='P')) 11/02/2025 12:44:41.0704 1194 ms. EXEC: insert into movtransit (traUseId,traCreation,traStatus,traUID,traYear,traDateTime,traCode,traType,traClass,traIdTerminal,traDirection,traPlate,traEnabled,traDisableTime,traAreId,traNotes,traBadge,traTarId) VALUES (0,'2025-02-11 12:44:39','V',4970727043862520,2025,'2025-02-11 12:44:39','456974587900327001012999',1,2,1,'I','',1,0,1,'','',4) (WAIT TIME 214 ms.) 11/02/2025 12:44:42.7345 1467 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 11/02/2025 12:44:51.8707 1344 ms. EXECSCALAR: select count(*) from tabTerminalExtraMem where extStatus='V' and extTerId = 16 nr: 1 11/02/2025 12:44:52.6362 507 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/02/2025 12:49:36.5493 1772 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 3 11/02/2025 12:49:37.4078 968 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 11/02/2025 12:49:52.2808 1445 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/02/2025 12:50:34.3992 1181 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/02/2025 12:51:04.7726 997 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/02/2025 12:51:51.3580 590 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 11/02/2025 12:54:28.3016 572 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 11/02/2025 12:55:45.4065 1176 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 11/02/2025 12:55:45.4435 758 ms. EXEC: UPDATE payCash SET casType='N' WHERE casType<>'N' AND ABS(casSingleAmount) IN (100,200,500); 11/02/2025 12:56:33.3167 714 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2025-02-11 12:56:32' where payTraUID = 5024677636790210 and payStatus='V' and payEnabled=1 11/02/2025 12:56:34.6786 1360 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2025-02-11 12:56:32' where traUID = 5024677636790210 and traStatus='V' and traEnabled=1 11/02/2025 12:56:50.7434 507 ms. EXEC: insert into movtransit (traUseId,traCreation,traStatus,traUID,traYear,traDateTime,traCode,traType,traClass,traIdTerminal,traDirection,traPlate,traEnabled,traDisableTime,traAreId,traNotes,traBadge,traTarId) VALUES (0,'2025-02-11 12:56:50','V',5568560912660320,2025,'2025-02-11 12:56:49','456974660900327005012999',1,2,16,'I','',1,0,1,'','',4) 11/02/2025 12:56:51.2778 519 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 11/02/2025 12:57:00.8172 824 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2025-02-11 12:56:59' where traUID = 4731648058172610 and traStatus='V' and traEnabled=1 11/02/2025 12:57:08.6165 503 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 11/02/2025 12:57:21.8944 1349 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 11/02/2025 12:57:24.8384 521 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 11/02/2025 12:58:21.8547 750 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/02/2025 12:59:15.5649 573 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 11/02/2025 13:00:31.6381 688 ms. OPEN: select * from tabArea where areStatus='V' and areEnabled = 1 AND areId = 1 11/02/2025 13:00:33.4663 908 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 16 OR lnsTerId=16) 11/02/2025 13:02:24.6151 506 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 11/02/2025 13:03:40.7233 721 ms. OPEN: select * from tabArea where areStatus='V' and areEnabled = 1 AND areId = 1 11/02/2025 13:06:18.1843 573 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/02/2025 13:06:21.9718 2570 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 1 OR lnsTerId=1) 11/02/2025 13:07:00.6589 982 ms. EXECSCALAR: select count(*) from information_schema.tables where table_schema= 'wisepark_0327' and table_name= 'payInvoiceFtp' nr: 1 11/02/2025 13:09:28.4813 1480 ms. EXEC: insert into payPayment (payCreation,payUseId,payStatus,payUID,payTraUID,payYear,payDateTime,payIdTerminal,payEnabled,payDisableTime,payTarId,payTimeLimit,payType,payCurrency,payAmount,payPayed,payChange,payCardType,payPAN,paySTAN,payIdEvent,payAmountCalc,payDiscountValue,payDiscount,payDiscountType,payVatPercent,payVatAmount) VALUES ('2025-02-11 13:09:26',0,'V',5087207358023240,4970727043862520,2025,'2025-02-11 13:09:26',18,1,0,4,'2025-02-11 13:24:26','C','KES',50,50,0,'','','',1,50,0,0,'',0,0) 11/02/2025 13:10:09.4149 731 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 11/02/2025 13:10:09.8061 1061 ms. EXECSCALAR: select count(*) from information_schema.tables where table_schema= 'wisepark_0327' and table_name= 'payInvoiceFtp' nr: 1 11/02/2025 13:10:47.3174 994 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 11/02/2025 13:15:00.1175 666 ms. EXEC: insert into movtransit (traUseId,traCreation,traStatus,traUID,traYear,traDateTime,traCode,traType,traClass,traIdTerminal,traDirection,traPlate,traEnabled,traDisableTime,traAreId,traNotes,traBadge,traTarId) VALUES (0,'2025-02-11 13:14:59','V',5122341467800640,2025,'2025-02-11 13:14:59','456974283300327005012999',2,2,2,'O','',0,'2025-02-11 13:14:59',1,'','',0) 11/02/2025 13:17:08.8201 1207 ms. EXEC: insert into movtransit (traUseId,traCreation,traStatus,traUID,traYear,traDateTime,traCode,traType,traClass,traIdTerminal,traDirection,traPlate,traEnabled,traDisableTime,traAreId,traNotes,traBadge,traTarId) VALUES (0,'2025-02-11 13:17:07','V',4958216732768190,2025,'2025-02-11 13:17:07','456974782700327005012999',1,2,16,'I','',1,0,1,'','',4) 11/02/2025 13:17:58.0982 2047 ms. EXEC: UPDATE payInventory SET invType='N' WHERE invType<>'N' AND invValue IN (100,200,500) AND invDevice IN (42102,42101,42001); 11/02/2025 13:18:43.9271 543 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 11/02/2025 13:19:36.0912 723 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 11/02/2025 13:19:52.5693 735 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/02/2025 13:20:20.0988 741 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 11/02/2025 13:20:25.9137 1450 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 11/02/2025 13:23:40.4046 558 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/02/2025 13:26:01.1423 622 ms. EXEC: update tabTerminalReceipt set trcProgressive = 1092, trcLastPrinted = '2500601092', trcLastDate = '2025-02-11 13:26:00' where trcStatus='V' and trcTerId = 17 11/02/2025 13:26:02.0969 725 ms. EXEC: update payReceipt set recCreation = '2025-02-11 13:26:01',recModify = '2025-02-11 13:26:01',recUseId=0,recStatus='V' where recId = 351395 11/02/2025 13:27:36.8096 738 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 1 11/02/2025 13:27:37.1919 679 ms. EXEC: UPDATE payInventory SET invType='N' WHERE invType<>'N' AND invValue IN (100,200,500) AND invDevice IN (42102,42101,42001); 11/02/2025 13:28:02.6931 874 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 5 11/02/2025 13:32:19.3698 683 ms. EXEC: insert into movtransit (traUseId,traCreation,traStatus,traUID,traYear,traDateTime,traCode,traType,traClass,traIdTerminal,traDirection,traPlate,traEnabled,traDisableTime,traAreId,traNotes,traBadge,traTarId) VALUES (0,'2025-02-11 13:32:18','V',5501070199875670,2025,'2025-02-11 13:32:17','456974873700327005012999',1,2,16,'I','',1,0,1,'','',4) 11/02/2025 13:36:35.8143 713 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 16 OR lnsTerId=16) 11/02/2025 13:39:27.4448 571 ms. EXEC: insert into payPayment (payCreation,payUseId,payStatus,payUID,payTraUID,payYear,payDateTime,payIdTerminal,payEnabled,payDisableTime,payTarId,payTimeLimit,payType,payCurrency,payAmount,payPayed,payChange,payCardType,payPAN,paySTAN,payIdEvent,payAmountCalc,payDiscountValue,payDiscount,payDiscountType,payVatPercent,payVatAmount) VALUES ('2025-02-11 13:39:26',0,'V',5245193125989700,5591863136149740,2025,'2025-02-11 13:39:26',18,1,0,4,'2025-02-11 13:54:26','C','KES',50,50,0,'','','',1,50,0,0,'',0,0) 11/02/2025 13:40:00.0008 1879 ms. EXEC: insert into movtransit (traUseId,traCreation,traStatus,traUID,traYear,traDateTime,traCode,traType,traClass,traIdTerminal,traDirection,traPlate,traEnabled,traDisableTime,traAreId,traNotes,traBadge,traTarId) VALUES (0,'2025-02-11 13:39:58','V',4911672507999660,2025,'2025-02-11 13:39:57','456973882900327005012999',2,2,2,'O','',0,'2025-02-11 13:39:58',1,'','',0) 11/02/2025 13:40:01.7739 1683 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 11/02/2025 13:40:07.5819 1257 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 11/02/2025 13:40:11.4354 656 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/02/2025 13:42:42.4991 513 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 11/02/2025 13:45:20.0621 555 ms. EXEC: insert into payPayment (payCreation,payUseId,payStatus,payUID,payTraUID,payYear,payDateTime,payIdTerminal,payEnabled,payDisableTime,payTarId,payTimeLimit,payType,payCurrency,payAmount,payPayed,payChange,payCardType,payPAN,paySTAN,payIdEvent,payAmountCalc,payDiscountValue,payDiscount,payDiscountType,payVatPercent,payVatAmount) VALUES ('2025-02-11 13:45:19',0,'V',5323704639151700,4705967496030420,2025,'2025-02-11 13:45:19',18,1,0,4,'2025-02-11 14:00:19','C','KES',100,100,0,'','','',1,100,0,0,'',0,0) 11/02/2025 13:46:06.4663 927 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 11/02/2025 13:46:10.0077 512 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/02/2025 13:47:32.3031 540 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 11/02/2025 13:47:58.8490 1179 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/02/2025 13:48:11.4835 532 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); (WAIT TIME 147 ms.) 11/02/2025 13:48:22.2457 798 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2025-02-11 13:48:21' where payTraUID = 4705967496030420 and payStatus='V' and payEnabled=1 11/02/2025 13:50:27.3099 1031 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/02/2025 13:50:55.3117 1252 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 2 11/02/2025 13:52:17.3599 772 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/02/2025 13:52:17.6351 947 ms. OPEN: select * from tabArea where areStatus='V' and areEnabled = 1 AND areId = 1 11/02/2025 13:53:59.7508 1237 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 11/02/2025 13:54:20.2676 1044 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/02/2025 13:54:39.3655 948 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/02/2025 13:54:44.1267 593 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 11/02/2025 13:55:11.5021 869 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2025-02-11 13:55:10',3,42101,0,50,-1,-50,1,'O','N'); update payCurInventory set curQuantity=round(curQuantity+-1,5),curAmount=round(curAmount+-50,5) where curTerId = 3 and curDevCode = 42101 and curChannelId = 1 and curValue = 50 and curType = 'N'; 11/02/2025 13:55:36.9522 1061 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 11/02/2025 13:55:38.0760 761 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2025-02-11 13:55:37' where traUID = 5101000271757280 and traStatus='V' and traEnabled=1 11/02/2025 13:55:41.0690 1147 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 11/02/2025 13:56:51.2913 501 ms. EXEC: insert into payPayment (payCreation,payUseId,payStatus,payUID,payTraUID,payYear,payDateTime,payIdTerminal,payEnabled,payDisableTime,payTarId,payTimeLimit,payType,payCurrency,payAmount,payPayed,payChange,payCardType,payPAN,paySTAN,payIdEvent,payAmountCalc,payDiscountValue,payDiscount,payDiscountType,payVatPercent,payVatAmount) VALUES ('2025-02-11 13:55:57',9,'V',5617776031263270,4704829322095790,2025,'2025-02-11 13:55:57',4,1,0,4,'2025-02-11 14:10:57','P','KES',300,300,0,'','','',1,300,0,0,'',0,0) 11/02/2025 14:00:42.5669 683 ms. EXEC: insert into payPayment (payCreation,payUseId,payStatus,payUID,payTraUID,payYear,payDateTime,payIdTerminal,payEnabled,payDisableTime,payTarId,payTimeLimit,payType,payCurrency,payAmount,payPayed,payChange,payCardType,payPAN,paySTAN,payIdEvent,payAmountCalc,payDiscountValue,payDiscount,payDiscountType,payVatPercent,payVatAmount) VALUES ('2025-02-11 14:00:41',0,'V',4841729409791110,4634321190094210,2025,'2025-02-11 14:00:41',3,1,0,4,'2025-02-11 14:15:41','C','KES',50,50,0,'',' ',' ',1,50,0,0,'',0,0) 11/02/2025 14:00:43.7697 736 ms. EXEC: update payReceipt set recCreation = '2025-02-11 14:00:43',recModify = '2025-02-11 14:00:43',recUseId=0,recStatus='V' where recId = 351419 11/02/2025 14:00:44.5062 733 ms. EXEC: DELETE FROM tmppay WHERE tmpCode = '456974984100327005012999' 11/02/2025 14:00:46.2624 1046 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2025-02-11 14:00:44',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'; 11/02/2025 14:01:29.5235 1230 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 11/02/2025 14:01:30.5402 885 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 11/02/2025 14:02:41.6600 650 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 11/02/2025 14:03:20.8194 1243 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/02/2025 14:04:12.2400 1838 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 11/02/2025 14:04:34.0787 651 ms. EXEC: insert into payPayment (payCreation,payUseId,payStatus,payUID,payTraUID,payYear,payDateTime,payIdTerminal,payEnabled,payDisableTime,payTarId,payTimeLimit,payType,payCurrency,payAmount,payPayed,payChange,payCardType,payPAN,paySTAN,payIdEvent,payAmountCalc,payDiscountValue,payDiscount,payDiscountType,payVatPercent,payVatAmount) VALUES ('2025-02-11 14:04:33',0,'V',5489156527802060,5231852615031910,2025,'2025-02-11 14:04:33',3,1,0,4,'2025-02-11 14:19:33','C','KES',50,500,450,'',' ',' ',1,50,0,0,'',0,0) 11/02/2025 14:06:40.5198 1515 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 2 11/02/2025 14:06:43.0064 626 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2025-02-11 14:06:42' where payTraUID = 5231852615031910 and payStatus='V' and payEnabled=1 11/02/2025 14:11:43.8889 685 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 11/02/2025 14:11:55.1385 589 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/02/2025 14:12:36.8005 1571 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 11/02/2025 14:12:44.6398 622 ms. EXEC: update payInventory set invCreation = '2025-02-11 14:12:44',invModify = '2025-02-11 14:12:44',invUseId=0,invStatus='V' where invId = 236280 11/02/2025 14:12:46.3079 591 ms. EXEC: update payInventory set invCreation = '2025-02-11 14:12:45',invModify = '2025-02-11 14:12:45',invUseId=0,invStatus='V' where invId = 236281 11/02/2025 14:15:22.8342 804 ms. EXEC: UPDATE payInventory SET invType='N' WHERE invType<>'N' AND invValue IN (100,200,500) AND invDevice IN (42102,42101,42001); 11/02/2025 14:15:59.5209 790 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 11/02/2025 14:16:11.6991 538 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/02/2025 14:18:37.9986 677 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/02/2025 14:20:27.2371 747 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2025-02-11 14:20:26' where payTraUID = 4788134565095540 and payStatus='V' and payEnabled=1 11/02/2025 14:21:44.0347 4089 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/02/2025 14:24:52.3765 646 ms. EXEC: UPDATE payInventory SET invType='N' WHERE invType<>'N' AND invValue IN (100,200,500) AND invDevice IN (42102,42101,42001); 11/02/2025 14:25:02.5593 1087 ms. EXEC: insert into movtransit (traUseId,traCreation,traStatus,traUID,traYear,traDateTime,traCode,traType,traClass,traIdTerminal,traDirection,traPlate,traEnabled,traDisableTime,traAreId,traNotes,traBadge,traTarId) VALUES (0,'2025-02-11 14:25:01','V',5305897346096970,2025,'2025-02-11 14:24:59','456975189900327001012999',1,2,1,'I','',1,0,1,'','',4) 11/02/2025 14:26:04.1668 1029 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 11/02/2025 14:26:55.4343 563 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/02/2025 14:28:11.0282 991 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2025-02-11 14:28:09' where traUID = 5261482252830440 and traStatus='V' and traEnabled=1 11/02/2025 14:33:59.4161 580 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 11/02/2025 14:34:05.7233 710 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 11/02/2025 14:35:09.1170 672 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 11/02/2025 14:38:14.0815 610 ms. EXEC: update payReceipt set recCreation = '2025-02-11 14:38:13',recModify = '2025-02-11 14:38:13',recUseId=0,recStatus='V' where recId = 351438 11/02/2025 14:38:27.2283 986 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/02/2025 14:40:16.1066 593 ms. EXEC: insert into movtransit (traUseId,traCreation,traStatus,traUID,traYear,traDateTime,traCode,traType,traClass,traIdTerminal,traDirection,traPlate,traEnabled,traDisableTime,traAreId,traNotes,traBadge,traTarId) VALUES (0,'2025-02-11 14:40:15','V',4953661692014900,2025,'2025-02-11 14:40:15','456975281500327001012999',1,2,1,'I','',1,0,1,'','',4) 11/02/2025 14:41:23.7571 2125 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 11/02/2025 14:41:30.8319 639 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 11/02/2025 14:41:31.5974 526 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/02/2025 14:41:57.8290 586 ms. OPEN: select traId,traDateTime,traEnabled,traDisableTime,traCode,traBadge,traCarId,traAreId,traIdTerminal from movtransit where traStatus='V' and traDirection = 'O' and traCarId = 15 order by traDateTime desc,traId desc 11/02/2025 14:42:01.5045 3152 ms. EXEC: insert into movtransit (traUseId,traCreation,traStatus,traUID,traYear,traDateTime,traCode,traType,traClass,traIdTerminal,traDirection,traPlate,traEnabled,traDisableTime,traAreId,traNotes,traBadge,traCarId,traTarId) VALUES (0,'2025-02-11 14:41:58','V',4936926110100310,2025,'2025-02-11 14:41:56','456975291600327001012999',1,2,1,'I','',1,0,1,'','0230003944081',15,0) 11/02/2025 14:42:04.1193 2290 ms. EXEC: insert into movtransit (traUseId,traCreation,traStatus,traUID,traYear,traDateTime,traCode,traType,traClass,traIdTerminal,traDirection,traPlate,traEnabled,traDisableTime,traAreId,traNotes,traBadge,traTarId) VALUES (0,'2025-02-11 14:42:01','V',5349790102155350,2025,'2025-02-11 14:41:58','456975195200327005012999',2,2,2,'O','',0,'2025-02-11 14:42:01',1,'','',0) 11/02/2025 14:42:04.1193 2536 ms. EXEC: update abbCards set carLastDate = '2025-02-11 14:42:01',carLastDirection='I' where carStatus='V' and carId = 15 11/02/2025 14:42:13.0753 804 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 11/02/2025 14:42:17.0440 826 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 11/02/2025 14:42:17.3181 945 ms. EXEC: insert into movtransit (traUseId,traCreation,traStatus,traUID,traYear,traDateTime,traCode,traType,traClass,traIdTerminal,traDirection,traPlate,traEnabled,traDisableTime,traAreId,traNotes,traBadge,traTarId) VALUES (0,'2025-02-11 14:42:16','V',5096920878967280,2025,'2025-02-11 14:42:11','456975293100327005012999',1,2,16,'I','',1,0,1,'','',4) 11/02/2025 14:42:18.6660 1336 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 11/02/2025 14:42:19.4626 718 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 11/02/2025 14:42:26.8305 2300 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/02/2025 14:44:37.0872 601 ms. EXEC: insert into payPayment (payCreation,payUseId,payStatus,payUID,payTraUID,payYear,payDateTime,payIdTerminal,payEnabled,payDisableTime,payTarId,payTimeLimit,payType,payCurrency,payAmount,payPayed,payChange,payCardType,payPAN,paySTAN,payIdEvent,payAmountCalc,payDiscountValue,payDiscount,payDiscountType,payVatPercent,payVatAmount) VALUES ('2025-02-11 14:44:36',0,'V',4709005782530810,4710742213038690,2025,'2025-02-11 14:44:36',3,1,0,4,'2025-02-11 14:59:36','C','KES',50,100,50,'',' ',' ',1,50,0,0,'',0,0) 11/02/2025 14:44:39.2646 666 ms. OPEN: select last_insert_id() as vLast 11/02/2025 14:46:14.5248 534 ms. OPEN: select * from tabArea where areStatus='V' and areEnabled = 1 AND areId = 1 11/02/2025 14:46:41.0896 559 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 11/02/2025 14:49:48.4977 638 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/02/2025 14:52:41.3220 1137 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/02/2025 14:53:04.9269 2748 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/02/2025 14:54:03.5974 1869 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 11/02/2025 14:54:13.8843 1353 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/02/2025 15:00:59.1730 663 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 11/02/2025 15:04:17.7447 699 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/02/2025 15:04:40.8222 653 ms. EXEC: insert into movtransit (traUseId,traCreation,traStatus,traUID,traYear,traDateTime,traCode,traType,traClass,traIdTerminal,traDirection,traPlate,traEnabled,traDisableTime,traAreId,traNotes,traBadge,traTarId) VALUES (0,'2025-02-11 15:04:40','V',5530669587444130,2025,'2025-02-11 15:04:39','456975427900327001012999',1,2,1,'I','',1,0,1,'','',4) 11/02/2025 15:04:51.5334 515 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/02/2025 15:05:09.7447 713 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/02/2025 15:06:13.8698 514 ms. EXEC: update paycash set casCreation = '2025-02-11 15:06:13',casModify = '2025-02-11 15:06:13',casUseId=0,casStatus='V' where casId = 209097 11/02/2025 15:06:16.3335 2117 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2025-02-11 15:06:14',3,42101,0,50,-1,-50,1,'O','N'); update payCurInventory set curQuantity=round(curQuantity+-1,5),curAmount=round(curAmount+-50,5) where curTerId = 3 and curDevCode = 42101 and curChannelId = 1 and curValue = 50 and curType = 'N'; Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2025-02-11 15:06:14',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'; 11/02/2025 15:06:46.1745 1046 ms. EXEC: update abbSubscriptions set subCredit = round(subCredit-0,5),subLastDebit = '2025-02-11 15:06:45' where subId = 198 11/02/2025 15:06:47.0561 731 ms. EXEC: insert into abbPayment (payCreation,payCode,payAmount,payCredit,payPayUID,payCarId,payDateFrom,payDateTo) VALUES ('2025-02-11 15:06:46','0230004098588',0,0,5576660242971320,183,'0000-00-00 00:00:00','0000-00-00 00:00:00') 11/02/2025 15:06:48.1939 608 ms. EXEC: update abbCards set carLastDate = '2025-02-11 15:06:47',carLastDirection='O' where carStatus='V' and carId = 183 11/02/2025 15:07:23.4917 1561 ms. EXECSCALAR: select count(0) as vTot from tabParameters where parPlateReading<>0 nr: 0 11/02/2025 15:08:30.3787 1209 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/02/2025 15:08:46.8217 945 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 11/02/2025 15:08:55.7217 1048 ms. OPEN: select * from tabArea where areStatus='V' and areEnabled = 1 AND areId = 1 11/02/2025 15:09:22.0574 2019 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/02/2025 15:09:44.2934 626 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 11/02/2025 15:13:48.4907 976 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 2 OR lnsTerId=2) 11/02/2025 15:14:37.7939 1479 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 1 and terStatus='V' 11/02/2025 15:14:51.2410 600 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 5 11/02/2025 15:14:52.0165 770 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 16 OR lnsTerId=16) 11/02/2025 15:15:59.8992 1645 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/02/2025 15:16:05.8602 644 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/02/2025 15:16:25.5174 759 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 5 11/02/2025 15:18:22.4111 567 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 11/02/2025 15:19:19.0592 1342 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2025-02-11 15:19:17',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'; 11/02/2025 15:20:29.1724 708 ms. EXEC: insert into movtransit (traUseId,traCreation,traStatus,traUID,traYear,traDateTime,traCode,traType,traClass,traIdTerminal,traDirection,traPlate,traEnabled,traDisableTime,traAreId,traNotes,traBadge,traTarId) VALUES (0,'2025-02-11 15:20:28','V',5036551811958680,2025,'2025-02-11 15:20:26','456975214900327005012999',2,2,2,'O','',0,'2025-02-11 15:20:28',1,'','',0) 11/02/2025 15:20:30.1420 578 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) (WAIT TIME 389 ms.) 11/02/2025 15:21:09.6956 555 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2025-02-11 15:21:08' where traUID = 5149830317576270 and traStatus='V' and traEnabled=1 11/02/2025 15:21:36.0423 1108 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 3 and terStatus='V' 11/02/2025 15:21:42.8209 635 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 11/02/2025 15:21:46.8917 2747 ms. EXEC: insert into movtransit (traUseId,traCreation,traStatus,traUID,traYear,traDateTime,traCode,traType,traClass,traIdTerminal,traDirection,traPlate,traEnabled,traDisableTime,traAreId,traNotes,traBadge,traTarId) VALUES (0,'2025-02-11 15:21:44','V',5421114074145180,2025,'2025-02-11 15:21:41','456975316000327005012999',2,2,2,'O','',0,'2025-02-11 15:21:44',1,'','',0) 11/02/2025 15:24:15.8149 926 ms. EXEC: update abbSubscriptions set subCredit = round(subCredit-0,5),subLastDebit = '2025-02-11 15:24:14' where subId = 16 11/02/2025 15:27:37.4395 547 ms. EXEC: insert into movtransit (traUseId,traCreation,traStatus,traUID,traYear,traDateTime,traCode,traType,traClass,traIdTerminal,traDirection,traPlate,traEnabled,traDisableTime,traAreId,traNotes,traBadge,traTarId) VALUES (0,'2025-02-11 15:27:36','V',5309691971274900,2025,'2025-02-11 15:27:35','456975427900327001012999',2,2,2,'O','',0,'2025-02-11 15:27:36',1,'','',0) 11/02/2025 15:28:01.4727 549 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2025-02-11 15:28:00' where payTraUID = 4824960411614720 and payStatus='V' and payEnabled=1 11/02/2025 15:28:10.0515 1630 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 11/02/2025 15:28:21.4622 774 ms. EXEC: insert into movtransit (traUseId,traCreation,traStatus,traUID,traYear,traDateTime,traCode,traType,traClass,traIdTerminal,traDirection,traPlate,traEnabled,traDisableTime,traAreId,traNotes,traBadge,traTarId) VALUES (0,'2025-02-11 15:28:20','V',5397165330364160,2025,'2025-02-11 15:28:19','456974914800327005012999',2,2,2,'O','',0,'2025-02-11 15:28:20',1,'','',0) 11/02/2025 15:29:56.4881 728 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 11/02/2025 15:30:15.3368 4158 ms. EXEC: insert into movtransit (traUseId,traCreation,traStatus,traUID,traYear,traDateTime,traCode,traType,traClass,traIdTerminal,traDirection,traPlate,traEnabled,traDisableTime,traAreId,traNotes,traBadge,traTarId) VALUES (0,'2025-02-11 15:30:11','V',5074660233350060,2025,'2025-02-11 15:30:10','456975581000327005012999',1,2,16,'I','',1,0,1,'','',4) 11/02/2025 15:30:31.5877 601 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 1 and terStatus='V' 11/02/2025 15:32:37.6736 1376 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 5 11/02/2025 15:34:20.6158 1084 ms. EXEC: insert into movtransit (traUseId,traCreation,traStatus,traUID,traYear,traDateTime,traCode,traType,traClass,traIdTerminal,traDirection,traPlate,traEnabled,traDisableTime,traAreId,traNotes,traBadge,traTarId) VALUES (0,'2025-02-11 15:34:19','V',5026709212103320,2025,'2025-02-11 15:34:19','456975605900327005012999',1,2,16,'I','',1,0,1,'','',4) 11/02/2025 15:34:21.7976 1172 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 11/02/2025 15:39:25.7672 889 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/02/2025 15:40:10.9946 1828 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2025-02-11 15:40:08',3,42101,0,50,-1,-50,1,'O','N'); update payCurInventory set curQuantity=round(curQuantity+-1,5),curAmount=round(curAmount+-50,5) where curTerId = 3 and curDevCode = 42101 and curChannelId = 1 and curValue = 50 and curType = 'N'; Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2025-02-11 15:40:08',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 ('2025-02-11 15:40:08',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'; 11/02/2025 15:40:42.5629 510 ms. EXEC: insert into payReceipt (recTraUID,recPayUID,recYear,recDateTime,recText,recInvalid) VALUES (4662625517848530,5193580801251350,2025,'2025-02-11 15:40:42','---------------------------------- %The Mall P0006032390 End of payment ---------------------------------- POF Entry : 2/11/2025 2:46:19 PM Date : 2/11/2025 3:40:40 PM Code : 456975317900327005012999 Total : 50.00 KES VAT 16% : 6.90 KES ---------------------------------- Paid : 50.00 KES Coin changed : 0.00 KES Note changed : 0.00 KES',0) 11/02/2025 15:45:30.1754 777 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 11/02/2025 15:49:27.0388 591 ms. EXEC: insert into movtransit (traUseId,traCreation,traStatus,traUID,traYear,traDateTime,traCode,traType,traClass,traIdTerminal,traDirection,traPlate,traEnabled,traDisableTime,traAreId,traNotes,traBadge,traTarId) VALUES (0,'2025-02-11 15:49:26','V',5349975783469670,2025,'2025-02-11 15:49:25','456975605900327005012999',2,2,2,'O','',0,'2025-02-11 15:49:26',1,'','',0) 11/02/2025 15:49:27.9184 525 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2025-02-11 15:49:27' where traUID = 5026709212103320 and traStatus='V' and traEnabled=1 11/02/2025 15:49:35.4865 658 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 11/02/2025 15:51:18.4868 651 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 1 11/02/2025 15:54:39.4520 764 ms. EXECSCALAR: select count(*) from information_schema.tables where table_schema= 'wisepark_0327' and table_name= 'payInvoiceFtp' nr: 1 11/02/2025 15:55:35.3846 558 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/02/2025 15:57:30.1058 595 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 11/02/2025 15:58:23.0305 1067 ms. EXEC: insert into movtransit (traUseId,traCreation,traStatus,traUID,traYear,traDateTime,traCode,traType,traClass,traIdTerminal,traDirection,traPlate,traEnabled,traDisableTime,traAreId,traNotes,traBadge,traTarId) VALUES (0,'2025-02-11 15:58:21','V',4625318098238580,2025,'2025-02-11 15:58:20','456975557500327005012999',2,2,2,'O','',0,'2025-02-11 15:58:21',1,'','',0) 11/02/2025 15:58:23.5518 517 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 11/02/2025 16:00:27.2621 521 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 11/02/2025 16:06:09.0871 843 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/02/2025 16:06:57.2615 719 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 11/02/2025 16:09:53.7512 541 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/02/2025 16:12:40.4364 747 ms. EXEC: update payInventory set invCreation = '2025-02-11 16:12:39',invModify = '2025-02-11 16:12:39',invUseId=0,invStatus='V' where invId = 236311 11/02/2025 16:13:32.5345 514 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/02/2025 16:14:07.8823 799 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/02/2025 16:14:46.6143 702 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 11/02/2025 16:16:57.3263 1045 ms. EXEC: update payReceipt set recCreation = '2025-02-11 16:16:56',recModify = '2025-02-11 16:16:56',recUseId=0,recStatus='V' where recId = 351489 11/02/2025 16:17:37.9046 664 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/02/2025 16:17:48.8530 603 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 11/02/2025 16:18:10.5816 1074 ms. EXEC: insert into movtransit (traUseId,traCreation,traStatus,traUID,traYear,traDateTime,traCode,traType,traClass,traIdTerminal,traDirection,traPlate,traEnabled,traDisableTime,traAreId,traNotes,traBadge,traTarId) VALUES (0,'2025-02-11 16:18:09','V',5608760906100660,2025,'2025-02-11 16:18:08','456975354500327005012999',2,2,2,'O','',0,'2025-02-11 16:18:09',1,'','',0) 11/02/2025 16:18:36.3399 668 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 11/02/2025 16:18:56.8857 531 ms. EXEC: insert into movtransit (traUseId,traCreation,traStatus,traUID,traYear,traDateTime,traCode,traType,traClass,traIdTerminal,traDirection,traPlate,traEnabled,traDisableTime,traAreId,traNotes,traBadge,traTarId) VALUES (0,'2025-02-11 16:18:56','V',5622647349638430,2025,'2025-02-11 16:18:52','456975873200327005012999',1,2,16,'I','',1,0,1,'','',4) 11/02/2025 16:19:16.6781 1413 ms. EXEC: update tabTerminalReceipt set trcProgressive = 6164, trcLastPrinted = '2500706164', trcLastDate = '2025-02-11 16:19:15' where trcStatus='V' and trcTerId = 18 11/02/2025 16:19:31.6952 519 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 11/02/2025 16:20:23.5941 1792 ms. EXEC: update paycash set casCreation = '2025-02-11 16:20:21',casModify = '2025-02-11 16:20:21',casUseId=0,casStatus='V' where casId = 209120 11/02/2025 16:20:25.2752 1681 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2025-02-11 16:20:21',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'; 11/02/2025 16:20:27.9300 1009 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 3 11/02/2025 16:20:41.4131 542 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 11/02/2025 16:20:54.8691 747 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/02/2025 16:20:55.0793 1602 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 11/02/2025 16:21:18.6631 590 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2025-02-11 16:21:17' where traUID = 5744594447282840 and traStatus='V' and traEnabled=1 11/02/2025 16:21:40.6139 1731 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/02/2025 16:21:52.8892 784 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); (WAIT TIME 381 ms.) 11/02/2025 16:24:13.7269 534 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 11/02/2025 16:29:23.7406 752 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/02/2025 16:29:31.5018 653 ms. EXEC: insert into paycash (casCreation,casModify,casUseId,casStatus,casUID,casTraUID,casYear,casDateTime,casIdTerminal,casCurrency,casNumber,casSingleAmount,casTotAmount,casType,casDescription) VALUES ('2025-02-11 16:29:30',0,0,'V',5394035348576970,5624014415894940,2025,'2025-02-11 16:29:30',3,'KES',1,50,50,'N',''); 11/02/2025 16:29:32.4704 781 ms. EXEC: insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2025-02-11 16:29:30',3,42101,0,50,1,50,2,'I','N'); update payCurInventory set curQuantity=round(curQuantity+1,5),curAmount=round(curAmount+50,5) where curTerId = 3 and curDevCode = 42101 and curChannelId = 2 and curValue = 50 and curType = 'N'; 11/02/2025 16:29:58.3478 951 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 1 11/02/2025 16:30:37.4482 689 ms. EXEC: insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2025-02-11 16:30:36',3,42101,0,100,1,100,2,'I','N'); update payCurInventory set curQuantity=round(curQuantity+1,5),curAmount=round(curAmount+100,5) where curTerId = 3 and curDevCode = 42101 and curChannelId = 2 and curValue = 100 and curType = 'N'; 11/02/2025 16:31:16.0521 559 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 11/02/2025 16:33:49.9897 950 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/02/2025 16:38:13.1268 848 ms. EXEC: update abbSubscriptions set subCredit = round(subCredit-0,5),subLastDebit = '2025-02-11 16:38:12' where subId = 18 11/02/2025 16:38:14.5798 627 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2025-02-11 16:38:13' where payTraUID = 5309775662344160 and payStatus='V' and payEnabled=1 11/02/2025 16:38:19.4530 1264 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/02/2025 16:41:17.2837 750 ms. EXEC: insert into movtransit (traUseId,traCreation,traStatus,traUID,traYear,traDateTime,traCode,traType,traClass,traIdTerminal,traDirection,traPlate,traEnabled,traDisableTime,traAreId,traNotes,traBadge,traTarId) VALUES (0,'2025-02-11 16:41:16','V',5361413952506060,2025,'2025-02-11 16:41:15','456975896300327001012999',2,2,2,'O','',0,'2025-02-11 16:41:16',1,'','',0) 11/02/2025 16:41:18.8968 611 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/02/2025 16:41:18.9208 1122 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2025-02-11 16:41:17' where traUID = 5696298499966300 and traStatus='V' and traEnabled=1 11/02/2025 16:42:50.0301 1246 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 3 OR lnsTerId=3) 11/02/2025 16:44:09.5656 640 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/02/2025 16:44:16.2181 517 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 11/02/2025 16:44:16.6224 740 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/02/2025 16:45:39.3871 842 ms. OPEN: select paypayment.payClosePeriod from movtransit inner join paypayment on movtransit.traUID=paypayment.payTraUID where paypayment.payStatus='V' and movtransit.traCode=@TRACODE and paypayment.payClosePeriod is not null order by paypayment.payClosePeriod desc 11/02/2025 16:45:40.1956 767 ms. EXEC: insert into movtransit (traUseId,traCreation,traStatus,traUID,traYear,traDateTime,traCode,traType,traClass,traIdTerminal,traDirection,traPlate,traEnabled,traDisableTime,traAreId,traNotes,traBadge,traTarId) VALUES (0,'2025-02-11 16:45:39','V',5302711913512100,2025,'2025-02-11 16:45:35','456975861200327005012999',2,2,2,'O','',0,'2025-02-11 16:45:39',1,'','',0) 11/02/2025 16:45:41.9888 1593 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2025-02-11 16:45:40' where traUID = 5720259584248170 and traStatus='V' and traEnabled=1 11/02/2025 16:45:48.7604 551 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 11/02/2025 16:46:25.0958 635 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 5 11/02/2025 16:46:25.1899 750 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/02/2025 16:49:15.0012 644 ms. EXEC: insert into movtransit (traUseId,traCreation,traStatus,traUID,traYear,traDateTime,traCode,traType,traClass,traIdTerminal,traDirection,traPlate,traEnabled,traDisableTime,traAreId,traNotes,traBadge,traTarId) VALUES (0,'2025-02-11 16:49:14','V',4925230088695480,2025,'2025-02-11 16:49:13','456975598500327001012999',2,2,2,'O','',0,'2025-02-11 16:49:14',1,'','',0) 11/02/2025 16:49:21.8818 514 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); (WAIT TIME 39 ms.) 11/02/2025 16:49:23.3588 545 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/02/2025 16:50:17.4152 563 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/02/2025 16:59:58.1860 520 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/02/2025 17:00:02.7410 573 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 11/02/2025 17:00:41.1149 779 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); 11/02/2025 17:00:41.6882 550 ms. EXEC: UPDATE payInventory SET invType='N' WHERE invType<>'N' AND invValue IN (100,200,500) AND invDevice IN (42102,42101,42001); 11/02/2025 17:01:57.4222 1091 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/02/2025 17:04:52.6361 696 ms. EXEC: insert into movtransit (traUseId,traCreation,traStatus,traUID,traYear,traDateTime,traCode,traType,traClass,traIdTerminal,traDirection,traPlate,traEnabled,traDisableTime,traAreId,traNotes,traBadge,traCarId,traTarId) VALUES (0,'2025-02-11 17:04:51','V',5056645833919780,2025,'2025-02-11 17:04:49','456973825300327005012999',2,2,2,'O','',0,'2025-02-11 17:04:51',1,'','0230003930028',28,0) 11/02/2025 17:06:46.5788 1378 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/02/2025 17:08:41.6102 767 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 3 11/02/2025 17:09:13.5417 547 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/02/2025 17:12:04.9160 561 ms. OPEN: show columns from tabParameters where Field = 'parAllowNegativePlaces' 11/02/2025 17:13:56.7613 867 ms. EXEC: UPDATE payInventory SET invType='N' WHERE invType<>'N' AND invValue IN (100,200,500) AND invDevice IN (42102,42101,42001); 11/02/2025 17:20:59.5267 648 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 3 and terStatus='V' 11/02/2025 17:21:08.3217 1747 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/02/2025 17:21:25.5302 589 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 11/02/2025 17:24:49.7056 837 ms. EXEC: UPDATE payInventory SET invType='N' WHERE invType<>'N' AND invValue IN (100,200,500) AND invDevice IN (42102,42101,42001); 11/02/2025 17:25:07.1354 612 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/02/2025 17:28:23.0932 812 ms. OPEN: SELECT * FROM movLinks INNER JOIN movTransit on traUID = mliTraUID WHERE mliRFIDCode = '456976177300327005012999' AND mliStatus='V' ORDER BY mliId DESC LIMIT 1 11/02/2025 17:29:04.8903 1808 ms. EXEC: insert into payPayment (payCreation,payUseId,payStatus,payUID,payTraUID,payYear,payDateTime,payIdTerminal,payEnabled,payDisableTime,payTarId,payTimeLimit,payType,payCurrency,payAmount,payPayed,payChange,payCardType,payPAN,paySTAN,payIdEvent,payAmountCalc,payDiscountValue,payDiscount,payDiscountType,payVatPercent,payVatAmount) VALUES ('2025-02-11 17:29:02',0,'V',5746051658216690,5431489920714330,2025,'2025-02-11 17:29:02',18,1,0,4,'2025-02-11 17:44:02','C','KES',100,100,0,'','','',1,100,0,0,'',0,0) 11/02/2025 17:29:06.7646 1860 ms. EXEC: update tabTerminalReceipt set trcProgressive = 6185, trcLastPrinted = '2500706185', trcLastDate = '2025-02-11 17:29:04' where trcStatus='V' and trcTerId = 18 11/02/2025 17:30:02.8934 509 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 11/02/2025 17:30:02.8944 501 ms. OPEN: select * from tabArea where areStatus='V' and areEnabled = 1 AND areId = 1 11/02/2025 17:30:03.0905 623 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 11/02/2025 17:30:13.4875 1038 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 11/02/2025 17:30:36.9233 821 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 11/02/2025 17:30:42.8012 983 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 3 OR lnsTerId=3) 11/02/2025 17:30:42.9343 929 ms. EXEC: UPDATE payInventory SET invType='N' WHERE invType<>'N' AND invValue IN (100,200,500) AND invDevice IN (42102,42101,42001); 11/02/2025 17:33:57.6704 563 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/02/2025 17:34:03.8305 1616 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/02/2025 17:37:42.0233 1023 ms. EXEC: UPDATE payInventory SET invType='N' WHERE invType<>'N' AND invValue IN (100,200,500) AND invDevice IN (42102,42101,42001); 11/02/2025 17:40:01.5102 542 ms. EXEC: update payReceipt set recCreation = '2025-02-11 17:40:00',recModify = '2025-02-11 17:40:00',recUseId=0,recStatus='V' where recId = 351528 11/02/2025 17:40:31.0721 2139 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/02/2025 17:44:13.6919 1086 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 11/02/2025 17:47:21.3522 572 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 11/02/2025 17:47:52.2119 888 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/02/2025 17:48:18.0523 889 ms. OPEN: select * from tabArea where areStatus='V' and areEnabled = 1 AND areId = 1 11/02/2025 17:50:58.4262 945 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 11/02/2025 17:53:45.7023 600 ms. EXEC: update tabTerminalReceipt set trcProgressive = 1944, trcLastPrinted = '2500401944', trcLastDate = '2025-02-11 17:53:45' where trcStatus='V' and trcTerId = 4 11/02/2025 17:54:01.0036 744 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/02/2025 17:55:26.4521 840 ms. EXEC: insert into payPayment (payCreation,payUseId,payStatus,payUID,payTraUID,payYear,payDateTime,payIdTerminal,payEnabled,payDisableTime,payTarId,payTimeLimit,payType,payCurrency,payAmount,payPayed,payChange,payCardType,payPAN,paySTAN,payIdEvent,payVatPercent,payVatAmount) VALUES ('2025-02-11 17:55:25',0,'V',5675539604319300,4620297721316330,2025,'2025-02-11 17:55:25',2,1,0,-1,'2025-02-11 18:55:25','S','KES',0,0,0,'','','',3,0,0) 11/02/2025 17:56:25.4728 1152 ms. EXEC: UPDATE payInventory SET invType='N' WHERE invType<>'N' AND invValue IN (100,200,500) AND invDevice IN (42102,42101,42001); 11/02/2025 17:56:31.6660 1036 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/02/2025 17:56:32.6396 691 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/02/2025 17:56:32.6406 813 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 2 OR lnsTerId=2) 11/02/2025 18:00:04.7183 757 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/02/2025 18:00:55.6406 1694 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 11/02/2025 18:01:30.1618 1629 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/02/2025 18:07:12.9395 784 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/02/2025 18:10:04.0046 551 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 11/02/2025 18:14:07.5788 538 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/02/2025 18:15:20.9592 609 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 11/02/2025 18:20:10.2611 1334 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/02/2025 18:20:21.1204 501 ms. EXEC: update abbCards set carLastDate = '2025-02-11 18:20:20',carLastDirection='O' where carStatus='V' and carId = 31 11/02/2025 18:20:27.8249 760 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 11/02/2025 18:21:43.0135 1099 ms. EXECSCALAR: select count(0) as vTot from tabParameters where parPlateReading<>0 nr: 0 11/02/2025 18:21:49.6379 1058 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/02/2025 18:22:02.1474 768 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 11/02/2025 18:22:02.8949 712 ms. EXEC: UPDATE payInventory SET invType='N' WHERE invType<>'N' AND invValue IN (100,200,500) AND invDevice IN (42102,42101,42001); 11/02/2025 18:22:22.7412 615 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2025-02-11 18:22:21' where traUID = 4993957456004310 and traStatus='V' and traEnabled=1 11/02/2025 18:24:18.1619 556 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 11/02/2025 18:31:56.3152 629 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/02/2025 18:33:30.7197 571 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 11/02/2025 18:34:25.9329 741 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/02/2025 18:38:37.8274 527 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 11/02/2025 18:39:18.2576 875 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 11/02/2025 18:48:07.3406 1527 ms. EXEC: insert into payPayment (payCreation,payUseId,payStatus,payUID,payTraUID,payYear,payDateTime,payIdTerminal,payEnabled,payDisableTime,payTarId,payTimeLimit,payType,payCurrency,payAmount,payPayed,payChange,payCardType,payPAN,paySTAN,payIdEvent,payVatPercent,payVatAmount) VALUES ('2025-02-11 18:48:05',0,'V',5116111880859000,4716611768584830,2025,'2025-02-11 18:48:05',2,1,0,-1,'2025-02-11 19:48:05','S','KES',0,0,0,'','','',3,0,0) 11/02/2025 18:48:31.8481 582 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 2 11/02/2025 18:56:59.7559 761 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 11/02/2025 18:57:29.7370 511 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/02/2025 19:00:43.0481 569 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 11/02/2025 19:01:40.9121 704 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 11/02/2025 19:03:47.1920 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,'2025-02-11 19:03:46','V',5726465925189750,2025,'2025-02-11 19:03:45','456976862500327005012999',1,2,16,'I','',1,0,1,'','',4) 11/02/2025 19:05:14.3237 566 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/02/2025 19:11:18.7299 722 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/02/2025 19:15:52.1799 640 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 11/02/2025 19:23:23.0083 990 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 11/02/2025 19:23:49.0688 797 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2025-02-11 19:23:48' where payTraUID = 5166923792057370 and payStatus='V' and payEnabled=1 11/02/2025 19:25:57.5462 694 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 3 OR lnsTerId=3) 11/02/2025 19:26:04.5249 862 ms. EXECSCALAR: select count(*) from information_schema.tables where table_schema= 'wisepark_0327' and table_name= 'payInvoiceFtp' nr: 1 11/02/2025 19:26:05.2404 579 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 11/02/2025 19:27:39.3538 618 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 3 OR lnsTerId=3) 11/02/2025 19:35:01.8855 586 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 11/02/2025 19:35:04.4132 1525 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/02/2025 19:35:12.5697 737 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 3 11/02/2025 19:37:26.9472 1220 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/02/2025 19:37:59.7882 534 ms. EXEC: update abbSubscriptions set subCredit = round(subCredit-0,5),subLastDebit = '2025-02-11 19:37:59' where subId = 185 11/02/2025 19:38:00.4137 582 ms. EXEC: insert into abbPayment (payCreation,payCode,payAmount,payCredit,payPayUID,payCarId,payDateFrom,payDateTo) VALUES ('2025-02-11 19:37:59','0560008529778',0,0,5606768244128710,171,'0000-00-00 00:00:00','0000-00-00 00:00:00') 11/02/2025 19:38:01.5024 1020 ms. OPEN: select * from movtransit where traUID = 4882780113646880 and traStatus='V' 11/02/2025 19:38:05.9504 513 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 11/02/2025 19:41:08.1340 2775 ms. EXEC: insert into payPayment (payCreation,payUseId,payStatus,payUID,payTraUID,payYear,payDateTime,payIdTerminal,payEnabled,payDisableTime,payTarId,payTimeLimit,payType,payCurrency,payAmount,payPayed,payChange,payCardType,payPAN,paySTAN,payIdEvent,payAmountCalc,payDiscountValue,payDiscount,payDiscountType,payVatPercent,payVatAmount) VALUES ('2025-02-11 19:41:05',0,'V',5720963125602800,5638825429914730,2025,'2025-02-11 19:41:05',18,1,0,4,'2025-02-11 19:56:05','C','KES',50,50,0,'','','',1,50,0,0,'',0,0) 11/02/2025 19:42:41.4798 769 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/02/2025 19:43:14.5511 1535 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/02/2025 19:45:01.4480 996 ms. EXEC: insert into payPayment (payCreation,payUseId,payStatus,payUID,payTraUID,payYear,payDateTime,payIdTerminal,payEnabled,payDisableTime,payTarId,payTimeLimit,payType,payCurrency,payAmount,payPayed,payChange,payCardType,payPAN,paySTAN,payIdEvent,payAmountCalc,payDiscountValue,payDiscount,payDiscountType,payVatPercent,payVatAmount) VALUES ('2025-02-11 19:44:48',1,'V',5710725385849750,4742755025244920,2025,'2025-02-11 19:44:48',17,1,0,4,'2025-02-11 19:59:48','C','KES',100,100,0,'','','',1,100,0,0,'',0,0) 11/02/2025 19:45:17.5138 1132 ms. EXEC: insert into movtransit (traUseId,traCreation,traStatus,traUID,traYear,traDateTime,traCode,traType,traClass,traIdTerminal,traDirection,traPlate,traEnabled,traDisableTime,traAreId,traNotes,traBadge,traTarId) VALUES (0,'2025-02-11 19:45:16','V',5700028867206260,2025,'2025-02-11 19:45:14','456970001000327003229999',22,22,3,'I','',1,0,1,'','',2) 11/02/2025 19:45:53.1998 863 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 2 OR lnsTerId=2) 11/02/2025 19:47:06.4851 886 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 1 11/02/2025 19:47:12.5972 630 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/02/2025 19:48:01.4661 554 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 11/02/2025 19:48:17.0826 709 ms. OPEN: SELECT traCode FROM movTransit WHERE traId = '846398' and traDirection='I' order by traId DESC LIMIT 1 11/02/2025 19:48:18.5456 821 ms. EXEC: update payReceipt set recCreation = '2025-02-11 19:48:17',recModify = '2025-02-11 19:48:17',recUseId=0,recStatus='V' where recId = 351557 11/02/2025 19:48:48.1455 786 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/02/2025 19:51:19.7345 671 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 11/02/2025 19:51:25.5294 786 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/02/2025 19:53:34.8455 1506 ms. EXEC: insert into payPayment (payCreation,payUseId,payStatus,payUID,payTraUID,payYear,payDateTime,payIdTerminal,payEnabled,payDisableTime,payTarId,payTimeLimit,payType,payCurrency,payAmount,payPayed,payChange,payCardType,payPAN,paySTAN,payIdEvent,payAmountCalc,payDiscountValue,payDiscount,payDiscountType,payVatPercent,payVatAmount) VALUES ('2025-02-11 19:53:31',0,'V',5417208271606930,5258210654144730,2025,'2025-02-11 19:53:31',3,1,0,4,'2025-02-11 20:08:31','C','KES',50,50,0,'',' ',' ',1,50,0,0,'',0,0) 11/02/2025 19:55:50.3166 530 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 11/02/2025 19:58:26.4877 843 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/02/2025 19:59:18.2736 922 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/02/2025 20:00:17.4254 794 ms. EXEC: insert into movtransit (traUseId,traCreation,traStatus,traUID,traYear,traDateTime,traCode,traType,traClass,traIdTerminal,traDirection,traPlate,traEnabled,traDisableTime,traAreId,traNotes,traBadge,traTarId) VALUES (0,'2025-02-11 20:00:16','V',5629437547138250,2025,'2025-02-11 20:00:15','456976880200327001012999',2,2,2,'O','',0,'2025-02-11 20:00:16',1,'','',0) 11/02/2025 20:03:53.1305 854 ms. EXEC: update paycash set casCreation = '2025-02-11 20:03:52',casModify = '2025-02-11 20:03:52',casUseId=0,casStatus='V' where casId = 209144 11/02/2025 20:05:38.4744 510 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 11/02/2025 20:05:43.5068 558 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 11/02/2025 20:05:44.7396 1884 ms. EXECSCALAR: select sum(parAllowNegativePlaces) from tabParameters where parStatus='V' order by parId desc limit 1 nr: 0 11/02/2025 20:11:14.2934 1026 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/02/2025 20:11:43.7442 1029 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 16 OR lnsTerId=16) 11/02/2025 20:12:29.4710 671 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/02/2025 20:12:49.2193 551 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/02/2025 20:16:33.1179 521 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 11/02/2025 20:16:41.5326 1389 ms. OPEN: select * from tabArea where areStatus='V' and areEnabled = 1 AND areId = 1 11/02/2025 20:16:44.0172 530 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 2 and terStatus='V' 11/02/2025 20:17:14.2085 595 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 2 OR lnsTerId=2) 11/02/2025 20:17:58.9326 728 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/02/2025 20:18:50.9747 924 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 11/02/2025 20:18:55.3886 656 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/02/2025 20:20:10.1469 642 ms. OPEN: show columns from tabTerminalExtraMem where Field = 'extVehicleData' 11/02/2025 20:24:19.0544 1424 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/02/2025 20:26:59.8566 1664 ms. EXEC: insert into movtransit (traUseId,traCreation,traStatus,traUID,traYear,traDateTime,traCode,traType,traClass,traIdTerminal,traDirection,traPlate,traEnabled,traDisableTime,traAreId,traNotes,traBadge,traTarId) VALUES (0,'2025-02-11 20:26:58','V',4827113679825470,2025,'2025-02-11 20:26:57','456977361700327001012999',1,2,1,'I','',1,0,1,'','',4) 11/02/2025 20:28:08.7900 739 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/02/2025 20:28:24.7037 602 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/02/2025 20:28:37.9496 2860 ms. OPEN: select * from tabArea where areStatus='V' and areEnabled = 1 AND areId = 1 11/02/2025 20:28:37.9496 1173 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/02/2025 20:29:13.3054 881 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/02/2025 20:31:07.8875 841 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 3 and terStatus='V' 11/02/2025 20:34:39.3178 622 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/02/2025 20:36:15.5436 678 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/02/2025 20:42:25.8693 661 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 11/02/2025 20:45:44.2588 962 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/02/2025 20:46:41.7625 871 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/02/2025 20:46:51.8242 545 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 11/02/2025 20:51:00.0343 513 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/02/2025 20:51:10.9666 515 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/02/2025 20:52:11.8836 583 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 11/02/2025 21:02:30.8741 1237 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/02/2025 21:02:55.6478 957 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/02/2025 21:07:19.7635 840 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/02/2025 21:07:56.2831 690 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/02/2025 21:09:32.8331 555 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/02/2025 21:14:40.3450 539 ms. EXEC: insert into movOperator (opeCreation,opeTerId,opeUseId,opeDateTime,opeCode,opeDescription) VALUES ('2025-02-11 21:14:39',17,1,'2025-02-11 21:14:39','456977024100327005012999','Pagato (Contanti ) Biglietto ') 11/02/2025 21:16:51.5943 569 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/02/2025 21:17:44.9562 752 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 11/02/2025 21:17:58.2882 723 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 11/02/2025 21:19:36.3692 886 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 5 and terStatus='V' 11/02/2025 21:21:15.0356 3039 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/02/2025 21:23:52.7347 748 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 3 and terStatus='V' 11/02/2025 21:25:25.0408 543 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/02/2025 21:26:12.0114 1199 ms. EXEC: update payInventory set invCreation = '2025-02-11 21:26:10',invModify = '2025-02-11 21:26:10',invUseId=0,invStatus='V' where invId = 236347 11/02/2025 21:26:19.1242 558 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/02/2025 21:33:59.1928 1089 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/02/2025 21:35:25.6930 543 ms. OPEN: select * from tabArea where areStatus='V' and areEnabled = 1 AND areId = 1 11/02/2025 21:35:54.6715 1517 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/02/2025 21:36:08.5799 1617 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/02/2025 21:37:52.2266 2062 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/02/2025 21:38:51.2013 573 ms. EXEC: insert into payPayment (payCreation,payUseId,payStatus,payUID,payTraUID,payYear,payDateTime,payIdTerminal,payEnabled,payDisableTime,payTarId,payTimeLimit,payType,payCurrency,payAmount,payPayed,payChange,payCardType,payPAN,paySTAN,payIdEvent,payAmountCalc,payDiscountValue,payDiscount,payDiscountType,payVatPercent,payVatAmount) VALUES ('2025-02-11 21:38:48',0,'V',4980536175463410,5226175099415370,2025,'2025-02-11 21:38:48',3,1,0,4,'2025-02-11 21:53:48','C','KES',50,100,50,'',' ',' ',1,50,0,0,'',0,0) 11/02/2025 21:40:26.2593 1342 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/02/2025 21:41:00.5053 725 ms. EXEC: insert into movtransit (traUseId,traCreation,traStatus,traUID,traYear,traDateTime,traCode,traType,traClass,traIdTerminal,traDirection,traPlate,traEnabled,traDisableTime,traAreId,traNotes,traBadge,traTarId) VALUES (0,'2025-02-11 21:40:59','V',5764096706745870,2025,'2025-02-11 21:40:59','456977531100327001012999',2,2,2,'O','',0,'2025-02-11 21:40:59',1,'','',0) 11/02/2025 21:41:02.1184 873 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2025-02-11 21:41:00' where traUID = 5226175099415370 and traStatus='V' and traEnabled=1 11/02/2025 21:41:07.8833 524 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 11/02/2025 21:41:08.4296 518 ms. EXEC: UPDATE payInventory SET invType='N' WHERE invType<>'N' AND invValue IN (100,200,500) AND invDevice IN (42102,42101,42001); 11/02/2025 21:41:50.5250 617 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 4 OR lnsTerId=4) 11/02/2025 21:42:25.0862 1113 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/02/2025 21:42:51.4730 2158 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/02/2025 21:43:13.5929 593 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 2 and terStatus='V' 11/02/2025 21:44:15.8207 706 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/02/2025 21:45:31.7879 608 ms. OPEN: select traId,traDateTime,traEnabled,traDisableTime,traCode,traBadge,traCarId,traAreId,traIdTerminal from movtransit where traStatus='V' and traDirection = 'O' and traCarId = 15 order by traDateTime desc,traId desc 11/02/2025 21:45:37.2315 542 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 11/02/2025 21:49:29.9521 1902 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/02/2025 21:51:05.9967 523 ms. EXEC: update tabTerminalReceipt set trcProgressive = 6218, trcLastPrinted = '2500706218', trcLastDate = '2025-02-11 21:51:05' where trcStatus='V' and trcTerId = 18 11/02/2025 21:52:12.4134 563 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 11/02/2025 22:02:22.1577 543 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/02/2025 22:05:29.2366 565 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 11/02/2025 22:08:20.5849 709 ms. OPEN: select * from tabArea where areStatus='V' and areEnabled = 1 AND areId = 1 11/02/2025 22:11:47.8914 882 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/02/2025 22:14:57.0847 591 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/02/2025 22:17:23.8135 518 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/02/2025 22:18:41.6839 567 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/02/2025 22:21:14.1305 540 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2025-02-11 22:21:13' where payTraUID = 5502202741349510 and payStatus='V' and payEnabled=1 11/02/2025 22:21:53.0617 834 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/02/2025 22:21:59.7372 818 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 5 11/02/2025 22:22:11.0057 556 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/02/2025 22:22:26.5362 622 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/02/2025 22:47:39.6455 592 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 11/02/2025 22:54:46.9781 1847 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2025-02-11 22:54:44' where traUID = 5101343973088950 and traStatus='V' and traEnabled=1 11/02/2025 22:56:16.0941 772 ms. EXECSCALAR: select count(*) from information_schema.tables where table_schema= 'wisepark_0327' and table_name= 'payInvoiceFtp' nr: 1 11/02/2025 22:56:19.4693 842 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/02/2025 23:03:40.9324 980 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/02/2025 23:10:59.7588 761 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/02/2025 23:12:19.6046 748 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/02/2025 23:17:44.0669 1008 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 11/02/2025 23:22:25.9286 1267 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/02/2025 23:29:41.4806 909 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/02/2025 23:31:12.5669 706 ms. OPEN: select * from tabArea where areStatus='V' and areEnabled = 1 AND areId = 1 11/02/2025 23:34:34.6409 1942 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/02/2025 23:34:43.0606 2440 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/02/2025 23:35:23.7259 1542 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/02/2025 23:36:49.6958 1342 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/02/2025 23:41:10.2701 1392 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 11/02/2025 23:41:25.0231 1468 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/02/2025 23:51:26.6439 567 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/02/2025 23:57:02.8291 544 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1