01/02/2025 00:07:27.4875 643 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 2 01/02/2025 00:07:37.2452 524 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 01/02/2025 00:08:04.0783 791 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 01/02/2025 00:10:41.8742 688 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 01/02/2025 00:10:52.9597 683 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 5 and terStatus='V' 01/02/2025 00:14:05.1099 685 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 01/02/2025 00:17:06.3026 894 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 01/02/2025 00:23:51.8653 1314 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 01/02/2025 00:27:56.9953 505 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 01/02/2025 00:35:40.9426 586 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 4 OR lnsTerId=4) 01/02/2025 00:46:19.8974 1294 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 01/02/2025 00:53:39.0278 652 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 01/02/2025 00:55:59.9963 546 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 01/02/2025 00:56:07.2702 1380 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 01/02/2025 01:05:30.6088 637 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 01/02/2025 01:10:32.7014 661 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 01/02/2025 01:17:48.9399 875 ms. EXEC: UPDATE payInventory SET invType='N' WHERE invType<>'N' AND invValue IN (100,200,500) AND invDevice IN (42102,42101,42001); 01/02/2025 01:18:30.7662 834 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 01/02/2025 01:31:10.0916 654 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 01/02/2025 01:36:12.2002 910 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 01/02/2025 01:38:15.3466 832 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 01/02/2025 01:38:52.2376 1031 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 01/02/2025 02:06:24.2506 791 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 01/02/2025 02:13:14.6455 543 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 5 01/02/2025 02:18:39.9969 783 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 01/02/2025 02:24:14.4264 681 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 01/02/2025 02:25:52.6720 562 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 01/02/2025 02:26:34.2842 1324 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 01/02/2025 02:30:44.4936 981 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 01/02/2025 02:30:49.0147 1317 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 01/02/2025 02:40:49.3903 585 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 01/02/2025 02:42:34.5106 556 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 01/02/2025 02:54:14.3726 1051 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 01/02/2025 02:57:33.4584 1409 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 01/02/2025 03:02:07.9003 599 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 01/02/2025 03:02:45.8410 1199 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 01/02/2025 03:05:34.6364 1779 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 01/02/2025 03:05:56.0309 2336 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 01/02/2025 03:07:17.8463 1668 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 4 OR lnsTerId=4) 01/02/2025 03:08:17.3296 970 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 4 01/02/2025 03:09:47.2865 808 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 01/02/2025 03:09:49.9823 984 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 01/02/2025 03:11:48.7468 539 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 01/02/2025 03:18:18.3477 569 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 01/02/2025 03:21:16.1611 1357 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 01/02/2025 03:25:06.5542 1024 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 01/02/2025 03:32:28.7947 2028 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 01/02/2025 03:33:51.9440 1539 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 5 and terStatus='V' 01/02/2025 03:41:21.6997 3596 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 01/02/2025 03:42:34.2118 669 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 01/02/2025 03:43:55.5088 3756 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 01/02/2025 03:45:02.6913 1099 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 01/02/2025 03:45:36.0209 919 ms. OPEN: select sum(crc32(terDescription)) as vCheck from tabTerminal 01/02/2025 03:50:38.9761 593 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 01/02/2025 03:50:59.1408 589 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 01/02/2025 03:51:00.5928 675 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 01/02/2025 04:00:10.6603 872 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 5 01/02/2025 04:00:26.3380 508 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 01/02/2025 04:00:26.4610 518 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 01/02/2025 04:08:27.9952 905 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 01/02/2025 04:10:46.8383 1607 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 01/02/2025 04:26:15.6133 584 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 5 and terStatus='V' 01/02/2025 04:26:33.2653 1964 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 01/02/2025 04:27:29.6875 571 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 01/02/2025 04:34:31.4242 1576 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 01/02/2025 04:39:38.8784 572 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 01/02/2025 04:39:49.6157 1976 ms. EXEC: update payReceipt set recCreation = '2025-02-01 04:39:47',recModify = '2025-02-01 04:39:47',recUseId=0,recStatus='V' where recId = 347897 01/02/2025 04:40:18.2601 1054 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 16 OR lnsTerId=16) 01/02/2025 04:40:59.2419 690 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 01/02/2025 04:41:48.8435 608 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 01/02/2025 04:50:25.0901 773 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 01/02/2025 04:57:16.6039 656 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 01/02/2025 05:02:45.1124 2384 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 01/02/2025 05:03:01.4554 1401 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 1 01/02/2025 05:03:01.4554 1308 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 01/02/2025 05:03:22.3866 869 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 01/02/2025 05:04:02.1556 604 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 01/02/2025 05:04:42.3698 1097 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 01/02/2025 05:05:37.0919 751 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 01/02/2025 05:13:40.8085 743 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 01/02/2025 05:14:15.9793 1245 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 1 01/02/2025 05:15:42.9893 525 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 01/02/2025 05:18:10.7453 1511 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 01/02/2025 05:21:45.1976 862 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 1 and terStatus='V' 01/02/2025 05:32:57.3118 837 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 01/02/2025 05:38:00.9445 646 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 01/02/2025 05:45:04.6605 1816 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 01/02/2025 05:55:36.8487 1672 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 01/02/2025 05:59:23.9175 1749 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 01/02/2025 05:59:59.3895 549 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 01/02/2025 06:01:53.9892 1113 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 01/02/2025 06:08:44.2380 1462 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 2 OR lnsTerId=2) 01/02/2025 06:14:17.3597 652 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 01/02/2025 06:15:04.3795 1082 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 01/02/2025 06:15:07.3035 1162 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 01/02/2025 06:15:11.4343 605 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 01/02/2025 06:35:08.2560 660 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 01/02/2025 06:38:55.2217 537 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 01/02/2025 06:39:15.3123 729 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 01/02/2025 06:46:01.4774 513 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 01/02/2025 06:48:39.3343 680 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 01/02/2025 06:54:07.1864 679 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 01/02/2025 06:56:48.6267 597 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 01/02/2025 07:04:14.2196 617 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 1 and terStatus='V' 01/02/2025 07:11:16.3425 540 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 01/02/2025 07:22:09.6180 894 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 2 01/02/2025 07:29:57.8821 1749 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 01/02/2025 07:32:09.5473 689 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 01/02/2025 07:33:14.8496 745 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 01/02/2025 07:35:12.3902 593 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 01/02/2025 07:36:06.3087 1926 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 01/02/2025 07:52:09.6982 1282 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 01/02/2025 07:54:54.9031 575 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 01/02/2025 08:00:16.4579 539 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 01/02/2025 08:07:06.9019 941 ms. EXEC: INSERT INTO movOperator (opeCreation,opeUseId,opeTerId,opeDateTime,opeCode,opeDescription) VALUES ('2025-02-01 08:07:05',0,2,'2025-02-01 08:07:05','0230003944086','Exit 1 - User Transit Supervisor Supervisor') 01/02/2025 08:07:31.2955 706 ms. EXEC: UPDATE payInventory SET invType='N' WHERE invType<>'N' AND invValue IN (100,200,500) AND invDevice IN (42102,42101,42001); 01/02/2025 08:08:19.6362 852 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 01/02/2025 08:10:18.0794 591 ms. EXEC: insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2025-02-01 08:10:07',5,3,42101,0,50,-18,-900,1,'O','N'); insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2025-02-01 08:10:07',5,3,42101,0,50,18,900,2,'I','N'); insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2025-02-01 08:10:07',5,3,42101,0,100,-45,-4500,1,'O','N'); insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2025-02-01 08:10:07',5,3,42101,0,100,45,4500,2,'I','N'); insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2025-02-01 08:10:07',5,3,42101,0,200,-2,-400,1,'O','N'); insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2025-02-01 08:10:07',5,3,42101,0,200,2,400,2,'I','N'); insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2025-02-01 08:10:07',5,3,42101,0,500,-1,-500,1,'O','N'); insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2025-02-01 08:10:07',5,3,42101,0,500,1,500,2,'I','N'); insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2025-02-01 08:10:07',5,3,42101,0,1000,-2,-2000,1,'O','N'); insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2025-02-01 08:10:07',5,3,42101,0,1000,2,2000,2,'I','N'); insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2025-02-01 08:10:07',5,3,42101,1,0,0,0,1,'O',''); update payCurInventory set curQuantity=0,curAmount=0 where curQuantity<0; 01/02/2025 08:10:20.1188 1299 ms. EXEC: insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2025-02-01 08:10:13',5,3,42101,0,50,-24,-1200,2,'O','N'); insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2025-02-01 08:10:13',5,3,42101,0,100,-54,-5400,2,'O','N'); insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2025-02-01 08:10:13',5,3,42101,0,200,-3,-600,2,'O','N'); insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2025-02-01 08:10:13',5,3,42101,0,500,-6,-3000,2,'O','N'); insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2025-02-01 08:10:13',5,3,42101,0,1000,-2,-2000,2,'O','N'); insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2025-02-01 08:10:13',5,3,42101,1,0,0,0,2,'O',''); update payCurInventory set curQuantity=0,curAmount=0 where curQuantity<0; 01/02/2025 08:11:24.5335 771 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 01/02/2025 08:16:48.6610 654 ms. OPEN: select sum(crc32(terDescription)) as vCheck from tabTerminal 01/02/2025 08:16:49.5816 617 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 01/02/2025 08:17:27.7575 1134 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 01/02/2025 08:17:34.7472 628 ms. OPEN: select * from payCurInventory where curTerId = 3 and curType='D' and curQuantity>0 order by curValue 01/02/2025 08:17:47.2207 673 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-01 08:17:46',0,'V',5461937083664430,5029298434554090,2025,'2025-02-01 08:17:46',18,1,0,4,'2025-02-01 08:32:46','C','KES',50,50,0,'','','',1,50,0,0,'',0,0) 01/02/2025 08:26:54.5064 2312 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 01/02/2025 08:29:05.2819 635 ms. EXEC: insert into payReceipt (recTraUID,recPayUID,recYear,recDateTime,recText,recInvalid) VALUES (5001221815804980,5218796393323090,2025,'2025-02-01 08:29:04',' Date: 2/1/2025 8:28:29 AM Code: 456872861100327005012999 Entry Date: 2/1/2025 7:56:51 AM Plate: Class: Cars Park: The Mall Gate: Entry 2 ______________________________ Total: 50.00 KES ______________________________ Paid: 50.00 KES __________ Change: 0.00 KES Type: Credit Card Dispozitiv: Manual Cashier 1 # 2500401402 ',0) 01/02/2025 08:29:54.0880 564 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 01/02/2025 08:29:58.8232 677 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 01/02/2025 08:30:24.2304 748 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 01/02/2025 08:34:00.0666 895 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 01/02/2025 08:38:24.1445 786 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 01/02/2025 08:45:22.8771 1792 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 01/02/2025 08:51:43.3188 734 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 01/02/2025 08:52:43.5726 793 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 01/02/2025 08:56:15.5372 654 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 01/02/2025 08:58:10.4420 539 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 01/02/2025 08:58:58.0703 699 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 01/02/2025 08:59:32.5476 674 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 01/02/2025 09:05:27.8863 679 ms. EXEC: insert into payReceipt (recTraUID,recPayUID,recYear,recDateTime,recText,recInvalid) VALUES (4847666695870840,4673419983600760,2025,'2025-02-01 09:05:27','---------------------------------- %The Mall P0006032390 End of payment ---------------------------------- POF Entry : 2/1/2025 8:37:24 AM Date : 2/1/2025 9:05:25 AM Code : 456873104400327001012999 Total : 50.00 KES VAT 16% : 6.90 KES ---------------------------------- Paid : 100.00 KES Coin changed : 0.00 KES Note changed : 50.00 KES',0) 01/02/2025 09:07:59.4840 550 ms. EXEC: UPDATE payInventory SET invType='N' WHERE invType<>'N' AND invValue IN (100,200,500) AND invDevice IN (42102,42101,42001); 01/02/2025 09:08:51.5082 501 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 01/02/2025 09:09:42.6899 591 ms. EXEC: insert into movOperator (opeCreation,opeTerId,opeUseId,opeDateTime,opeCode,opeDescription) VALUES ('2025-02-01 09:09:42',4,6,'2025-02-01 09:09:42','456873219700327005012999','Payed (Credit Card ) Ticket ') 01/02/2025 09:11:01.7825 832 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2025-02-01 09:11:00' where traUID = 4779484327084650 and traStatus='V' and traEnabled=1 01/02/2025 09:11:13.4934 1251 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-01 09:11:12','V',5335889900462050,2025,'2025-02-01 09:11:11','456870000200327003229999',22,22,3,'I','',1,0,1,'','',2) 01/02/2025 09:15:50.0047 672 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 01/02/2025 09:17:27.1315 1254 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 01/02/2025 09:17:33.1696 927 ms. OPEN: select * from tabArea where areStatus='V' and areEnabled = 1 AND areId = 1 01/02/2025 09:18:54.9710 635 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 01/02/2025 09:23:36.7108 1025 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 01/02/2025 09:25:43.5467 612 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 01/02/2025 09:31:45.9642 820 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 01/02/2025 09:32:27.1391 601 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 01/02/2025 09:38:05.3832 1370 ms. OPEN: select * from tabArea where areStatus='V' and areEnabled = 1 AND areId = 1 01/02/2025 09:39:39.3158 1050 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-01 09:39:37',0,'V',5416368677227500,4642758376094820,2025,'2025-02-01 09:39:37',3,1,0,4,'2025-02-01 09:54:37','C','KES',50,100,50,'',' ',' ',1,50,0,0,'',0,0) 01/02/2025 09:39:40.4536 934 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2025-02-01 09:39:39',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'; 01/02/2025 09:42:27.0014 633 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 01/02/2025 09:46:50.5599 692 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 01/02/2025 09:47:37.4427 1373 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-01 09:47:35',0,'V',5414936085910100,5476867307465260,2025,'2025-02-01 09:47:35',3,1,0,4,'2025-02-01 10:02:35','C','KES',50,50,0,'',' ',' ',1,50,0,0,'',0,0) 01/02/2025 09:47:39.0468 1178 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2025-02-01 09:47:37',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'; 01/02/2025 09:47:58.7901 1271 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 1 01/02/2025 09:48:04.9153 649 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 2 and terStatus='V' 01/02/2025 09:48:05.2405 980 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 01/02/2025 09:48:06.2362 975 ms. EXEC: UPDATE payCash SET casType='N' WHERE casType<>'N' AND ABS(casSingleAmount) IN (100,200,500); 01/02/2025 09:48:22.9315 1189 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-01 09:48:21','V',4988833115533130,2025,'2025-02-01 09:48:19','456873440400327005012999',2,2,2,'O','',0,'2025-02-01 09:48:21',1,'','',0) 01/02/2025 09:48:30.2795 1771 ms. EXECSCALAR: select count(*) from information_schema.tables where table_schema= 'wisepark_0327' and table_name= 'payInvoiceFtp' nr: 1 01/02/2025 09:48:39.8239 983 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 01/02/2025 09:49:33.5023 585 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2025-02-01 09:49:32' where traUID = 5476867307465260 and traStatus='V' and traEnabled=1 01/02/2025 09:49:39.7805 610 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 01/02/2025 09:51:07.3609 1046 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 01/02/2025 09:52:57.4384 550 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 01/02/2025 09:53:30.0215 582 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-01 09:53:29','V',5094362209254030,2025,'2025-02-01 09:53:29','456873380600327005012999',2,2,2,'O','',0,'2025-02-01 09:53:29',1,'','',0) 01/02/2025 09:53:50.4994 902 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 2 OR lnsTerId=2) 01/02/2025 09:55:31.4898 534 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 01/02/2025 09:55:55.4520 594 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 01/02/2025 09:57:38.7980 896 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-01 09:57:37','V',5623985344765040,2025,'2025-02-01 09:57:35','456873585500327005012999',1,2,16,'I','',1,0,1,'','0750009518612',99,0) 01/02/2025 10:03:29.9769 1010 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 01/02/2025 10:07:06.2994 567 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-01 10:07:05',0,'V',5529953144741020,4680709947324490,2025,'2025-02-01 10:07:05',18,1,0,4,'2025-02-01 10:22:05','C','KES',50,50,0,'','','',1,50,0,0,'',0,0) 01/02/2025 10:07:16.3642 569 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 01/02/2025 10:07:28.9077 705 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-01 10:07:28','V',4916867822165740,2025,'2025-02-01 10:07:27','456873644700327005012999',1,2,16,'I','',1,0,1,'','',4) 01/02/2025 10:08:31.0808 1462 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 01/02/2025 10:12:21.2517 1045 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2025-02-01 10:12:19' where traUID = 5357833604184810 and traStatus='V' and traEnabled=1 01/02/2025 10:12:24.7971 663 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 01/02/2025 10:13:44.9314 961 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 01/02/2025 10:15:55.6559 2132 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 01/02/2025 10:16:17.2726 581 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 01/02/2025 10:17:34.2697 506 ms. EXEC: update paycash set casCreation = '2025-02-01 10:17:33',casModify = '2025-02-01 10:17:33',casUseId=0,casStatus='V' where casId = 207503 01/02/2025 10:18:57.2729 926 ms. EXEC: update paycash set casCreation = '2025-02-01 10:18:56',casModify = '2025-02-01 10:18:56',casUseId=0,casStatus='V' where casId = 207504 01/02/2025 10:19:32.3497 749 ms. EXEC: update abbCards set carLastDate = '2025-02-01 10:19:31',carLastDirection='O' where carStatus='V' and carId = 10 01/02/2025 10:20:24.4410 635 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-01 10:20:23','V',4651915517671380,2025,'2025-02-01 10:20:23','456873722300327005012999',1,2,16,'I','',1,0,1,'','',4) 01/02/2025 10:20:25.1605 566 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 01/02/2025 10:24:52.9128 527 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 01/02/2025 10:29:27.0175 657 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 01/02/2025 10:30:36.0312 646 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 01/02/2025 10:30:42.1674 826 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 01/02/2025 10:31:56.7759 1649 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-01 09:31:55') OR resConfirmed IN (4,5)) and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) <= '2025-02-01 10:31:55' and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) >= '2025-02-01 10:31:55' and (resAreId = 1 or resAreId <= 0) nr: 0 01/02/2025 10:32:04.3431 1043 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-01 10:32:03','V',4855750508140520,2025,'2025-02-01 10:31:59','456873791900327005012999',1,2,16,'I','',1,0,1,'','',4) 01/02/2025 10:32:24.7879 1711 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-01 10:31:48',6,'V',4899077899765790,5562275820725300,2025,'2025-02-01 10:31:48',4,1,0,4,'2025-02-01 10:46:48','P','KES',50,50,0,'','','',1,50,0,0,'',0,0) 01/02/2025 10:32:26.7452 953 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 01/02/2025 10:32:26.8153 1180 ms. EXEC: insert into payReceipt (recTraUID,recPayUID,recYear,recDateTime,recText,recInvalid) VALUES (5562275820725300,4899077899765790,2025,'2025-02-01 10:32:25',' Date: 2/1/2025 10:31:48 AM Code: 456873771900327005012999 Entry Date: 2/1/2025 10:28:39 AM Plate: Class: Cars Park: The Mall Gate: Entry 2 ______________________________ Total: 50.00 KES ______________________________ Paid: 50.00 KES __________ Change: 0.00 KES Type: Credit Card Dispozitiv: Manual Cashier 1 # 2500401414 ',0) 01/02/2025 10:35:47.9745 543 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 01/02/2025 10:35:48.5379 560 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 01/02/2025 10:35:49.8888 1347 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2025-02-01 10:35:48' where payTraUID = 5485431358489500 and payStatus='V' and payEnabled=1 01/02/2025 10:35:53.4543 645 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 01/02/2025 10:35:56.7835 691 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 01/02/2025 10:35:56.8495 848 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) (WAIT TIME 54 ms.) 01/02/2025 10:35:57.0527 718 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 01/02/2025 10:36:08.6866 686 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 01/02/2025 10:44:00.8544 699 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-01 10:44:00','V',5681691265160370,2025,'2025-02-01 10:44:00','456873493300327005012999',2,2,2,'O','',0,'2025-02-01 10:44:00',1,'','',0) 01/02/2025 10:44:01.8901 995 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 01/02/2025 10:44:07.2507 509 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 01/02/2025 10:48:07.8527 630 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-01 10:48:07','V',4894042514683280,2025,'2025-02-01 10:48:05','456873888500327005012999',1,2,16,'I','',1,0,1,'','',4) 01/02/2025 10:48:36.3650 734 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2025-02-01 10:48:35' where payTraUID = 5452853611036110 and payStatus='V' and payEnabled=1 01/02/2025 10:48:42.2070 550 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 01/02/2025 10:50:00.5870 1012 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 5 and terStatus='V' 01/02/2025 10:51:54.1770 783 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 01/02/2025 10:52:16.1779 574 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 01/02/2025 10:52:28.2671 570 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 5 01/02/2025 10:52:33.5607 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-01 10:52:32','V',4666695886190310,2025,'2025-02-01 10:52:32','456873915200327005012999',1,2,16,'I','',1,0,1,'','',4) 01/02/2025 10:52:34.2731 678 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 01/02/2025 10:52:35.3028 986 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 01/02/2025 10:55:27.5735 775 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-01 10:55:26',0,'V',4678582397399270,4946466415831140,2025,'2025-02-01 10:55:26',18,1,0,4,'2025-02-01 11:10:26','C','KES',100,100,0,'','','',1,100,0,0,'',0,0) 01/02/2025 10:55:29.1866 1596 ms. EXEC: update tabTerminalReceipt set trcProgressive = 4561, trcLastPrinted = '2500704561', trcLastDate = '2025-02-01 10:55:27' where trcStatus='V' and trcTerId = 18 01/02/2025 10:55:30.7717 1504 ms. EXEC: insert into payReceipt (recTraUID,recPayUID,recYear,recDateTime,recText,recInvalid) VALUES (4946466415831140,4678582397399270,2025,'2025-02-01 10:55:29',' Date: 2/1/2025 10:55:26 AM Code: 456873353300327001012999 Entry Date: 2/1/2025 9:18:53 AM Plate: Class: Cars Park: The Mall Gate: Entry 1 ______________________________ Total: 100.00 KES ______________________________ Paid: 100.00 KES __________ Change: 0.00 KES Type: Cash Dispozitiv: MPESA # 2500704561 ',0) 01/02/2025 10:58:13.1687 1566 ms. EXEC: UPDATE payCash SET casType='N' WHERE casType<>'N' AND ABS(casSingleAmount) IN (100,200,500); 01/02/2025 11:00:26.2248 1683 ms. EXEC: insert into payReceipt (recTraUID,recPayUID,recYear,recDateTime,recText,recInvalid) VALUES (5013558335126610,5195130619788200,2025,'2025-02-01 11:00:24',' Date: 2/1/2025 11:00:24 AM Code: 456872972600327005012999 Entry Date: 2/1/2025 8:15:26 AM Plate: Class: Cars Park: The Mall Gate: Entry 2 ______________________________ Total: 100.00 KES ______________________________ Paid: 100.00 KES __________ Change: 0.00 KES Type: Cash Dispozitiv: MPESA # 2500704565 ',0) 01/02/2025 11:02:17.2750 965 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2025-02-01 11:02:16',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'; 01/02/2025 11:02:18.0305 661 ms. EXEC: insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2025-02-01 11:02:17',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-01 11:02:17',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'; 01/02/2025 11:02:23.4152 1774 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 2 OR lnsTerId=2) 01/02/2025 11:03:03.3993 657 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-01 11:03:02','V',5682625980386580,2025,'2025-02-01 11:03:02','456872972600327005012999',2,2,2,'O','',0,'2025-02-01 11:03:02',1,'','',0) 01/02/2025 11:04:24.3741 791 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 01/02/2025 11:05:46.3837 607 ms. EXEC: INSERT INTO opeActivities (acvCreation,acvUseId,acvTerId,acvOpeUseId,acvSuperUseId,acvCodeId,acvTypeId,acvDateTime,acvSftId,acvCausal) VALUES (@ACVCREATION,@ACVUSEID,@ACVTERID,@ACVOPEUSEID,@ACVSUPERUSEID,@ACVCODEID,@ACVTYPEID,@ACVDATETIME,@ACVSFTID,@ACVCAUSAL) 01/02/2025 11:07:43.6361 1073 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-01 11:07:42',0,'V',5070533338081650,4986531296682370,2025,'2025-02-01 11:07:42',3,1,0,4,'2025-02-01 11:22:42','C','KES',100,200,100,'',' ',' ',1,100,0,0,'',0,0) 01/02/2025 11:08:58.7990 1536 ms. EXECSCALAR: select count(*) from tabTerminalExtraMem where extStatus='V' and extTerId = 2 nr: 1 01/02/2025 11:15:44.4388 526 ms. EXEC: insert into movOperator (opeCreation,opeTerId,opeUseId,opeDateTime,opeCode,opeDescription) VALUES ('2025-02-01 11:15:43',4,6,'2025-02-01 11:15:43','456873945400327005012999','Payed (Credit Card ) Ticket ') 01/02/2025 11:16:09.3526 532 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 01/02/2025 11:18:00.7601 824 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 01/02/2025 11:18:44.2105 547 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 01/02/2025 11:19:54.9715 728 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-01 11:19:54','V',4655700867978760,2025,'2025-02-01 11:19:52','456874079200327005012999',1,2,16,'I','',1,0,1,'','',4) 01/02/2025 11:20:40.0750 692 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-01 11:20:39','V',4657728648856770,2025,'2025-02-01 11:20:37','456874083700327005012999',1,2,16,'I','',1,0,1,'','',4) 01/02/2025 11:22:37.6386 573 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 01/02/2025 11:23:20.2565 717 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 01/02/2025 11:23:55.0771 698 ms. EXEC: insert into payReceipt (recTraUID,recPayUID,recYear,recDateTime,recText,recInvalid) VALUES (4855750508140520,4965491076756330,2025,'2025-02-01 11:23:54',' Date: 2/1/2025 11:23:54 AM Code: 456873791900327005012999 Entry Date: 2/1/2025 10:31:59 AM Plate: Class: Cars Park: The Mall Gate: Entry 2 ______________________________ Total: 50.00 KES ______________________________ Paid: 50.00 KES __________ Change: 0.00 KES Type: Cash Dispozitiv: MPESA # 2500704566 ',0) 01/02/2025 11:30:59.0583 628 ms. EXEC: insert into paycash (casCreation,casModify,casUseId,casStatus,casUID,casTraUID,casYear,casDateTime,casIdTerminal,casCurrency,casNumber,casSingleAmount,casTotAmount,casType,casDescription) VALUES ('2025-02-01 11:30:58',0,0,'V',5415143718648360,4967277794203030,2025,'2025-02-01 11:30:58',3,'KES',-1,50,-50,'N',''); insert into paycash (casCreation,casModify,casUseId,casStatus,casUID,casTraUID,casYear,casDateTime,casIdTerminal,casCurrency,casNumber,casSingleAmount,casTotAmount,casType,casDescription) VALUES ('2025-02-01 11:30:58',0,0,'V',5415143718648360,4967277794203030,2025,'2025-02-01 11:30:58',3,'KES',-1,100,-100,'N',''); 01/02/2025 11:31:00.0940 1035 ms. EXEC: update paycash set casCreation = '2025-02-01 11:30:59',casModify = '2025-02-01 11:30:59',casUseId=0,casStatus='V' where casId = 207519 01/02/2025 11:31:00.8275 733 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2025-02-01 11:30:58',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-01 11:30:58',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'; 01/02/2025 11:31:21.6406 645 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 01/02/2025 11:31:24.6996 572 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 01/02/2025 11:35:23.5864 719 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 01/02/2025 11:35:47.6217 633 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-01 11:35:46','V',4637000926595800,2025,'2025-02-01 11:35:45','456874174500327005012999',1,2,16,'I','',1,0,1,'','',4) 01/02/2025 11:36:11.8001 852 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 01/02/2025 11:37:22.9253 1384 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 2 01/02/2025 11:38:20.7354 1753 ms. OPEN: select * from tabArea where areStatus='V' and areEnabled = 1 AND areId = 1 01/02/2025 11:39:13.1559 565 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 2 OR lnsTerId=2) 01/02/2025 11:39:27.9239 612 ms. EXEC: update abbSubscriptions set subCredit = round(subCredit-0,5),subLastDebit = '2025-02-01 11:39:27' where subId = 198 01/02/2025 11:39:40.9127 878 ms. EXEC: UPDATE payInventory SET invType='N' WHERE invType<>'N' AND invValue IN (100,200,500) AND invDevice IN (42102,42101,42001); 01/02/2025 11:41:07.8746 2341 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 01/02/2025 11:42:31.0920 1032 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 01/02/2025 11:44:36.4589 729 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 01/02/2025 11:45:18.1281 1412 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 2 and terStatus='V' 01/02/2025 11:46:49.6902 1005 ms. EXECSCALAR: select count(*) from information_schema.tables where table_schema= 'wisepark_0327' and table_name= 'payInvoiceFtp' nr: 1 01/02/2025 11:50:09.3454 549 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 01/02/2025 11:51:10.5579 535 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 01/02/2025 11:51:57.6267 611 ms. EXEC: insert into payReceipt (recTraUID,recPayUID,recYear,recDateTime,recText,recInvalid) VALUES (5050948494465440,5551601005445350,2025,'2025-02-01 11:51:57','---------------------------------- %The Mall P0006032390 End of payment ---------------------------------- POF Entry : 2/1/2025 11:34:08 AM Date : 2/1/2025 11:51:55 AM Code : 456874164800327005012999 Total : 50.00 KES VAT 16% : 6.90 KES ---------------------------------- Paid : 50.00 KES Coin changed : 0.00 KES Note changed : 0.00 KES',0) 01/02/2025 11:52:27.9973 649 ms. EXEC: insert into payReceipt (recTraUID,recPayUID,recYear,recDateTime,recText,recInvalid) VALUES (5180426939678790,5502016233980700,2025,'2025-02-01 11:52:27','---------------------------------- %The Mall P0006032390 End of payment ---------------------------------- POF Entry : 2/1/2025 11:10:00 AM Date : 2/1/2025 11:52:26 AM Code : 456874020000327005012999 Total : 50.00 KES VAT 16% : 6.90 KES ---------------------------------- Paid : 50.00 KES Coin changed : 0.00 KES Note changed : 0.00 KES',0) 01/02/2025 11:53:32.8412 1318 ms. EXEC: UPDATE payInventory SET invType='N' WHERE invType<>'N' AND invValue IN (100,200,500) AND invDevice IN (42102,42101,42001); 01/02/2025 11:53:43.2513 852 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 2 OR lnsTerId=2) 01/02/2025 11:53:47.0719 1307 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-01 11:53:45','V',4766657660972390,2025,'2025-02-01 11:53:44','456874020000327005012999',2,2,2,'O','',0,'2025-02-01 11:53:45',1,'','',0) 01/02/2025 11:53:55.3565 710 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 01/02/2025 11:56:35.3609 1762 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 01/02/2025 11:58:31.7137 1547 ms. EXEC: UPDATE payCash SET casType='N' WHERE casType<>'N' AND ABS(casSingleAmount) IN (100,200,500); 01/02/2025 11:58:35.1920 1322 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 1 OR lnsTerId=1) 01/02/2025 11:58:57.8153 568 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 2 OR lnsTerId=2) 01/02/2025 12:01:23.7192 668 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 01/02/2025 12:01:56.1401 1006 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 01/02/2025 12:02:00.4190 1501 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 01/02/2025 12:03:24.0757 1596 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 01/02/2025 12:04:30.0314 615 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2025-02-01 12:04:29' where payTraUID = 4899988189936260 and payStatus='V' and payEnabled=1 01/02/2025 12:04:49.5836 701 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2025-02-01 12:04:48' where payTraUID = 4738422816203920 and payStatus='V' and payEnabled=1 01/02/2025 12:04:51.5439 1960 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2025-02-01 12:04:48' where traUID = 4738422816203920 and traStatus='V' and traEnabled=1 01/02/2025 12:04:55.8599 1684 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 01/02/2025 12:04:57.2498 1255 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2025-02-01 12:04:55',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-01 12:04:55',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'; Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2025-02-01 12:04:55',3,42101,0,200,-4,-800,1,'O','N'); update payCurInventory set curQuantity=round(curQuantity+-4,5),curAmount=round(curAmount+-800,5) where curTerId = 3 and curDevCode = 42101 and curChannelId = 1 and curValue = 200 and curType = 'N'; 01/02/2025 12:05:06.7522 571 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 01/02/2025 12:09:26.6083 575 ms. EXEC: update tabTerminalReceipt set trcProgressive = 4575, trcLastPrinted = '2500704575', trcLastDate = '2025-02-01 12:09:26' where trcStatus='V' and trcTerId = 18 01/02/2025 12:10:19.2349 525 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 01/02/2025 12:13:21.0380 518 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 01/02/2025 12:16:08.1262 826 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-01 12:16:07','V',5454947065253390,2025,'2025-02-01 12:16:05','456874416500327005012999',1,2,16,'I','',1,0,1,'','',4) 01/02/2025 12:18:20.8681 580 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 01/02/2025 12:19:09.6622 568 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 01/02/2025 12:21:17.7539 521 ms. OPEN: select traId,traDateTime,traEnabled,traDisableTime,traCode,traBadge,traCarId,traAreId,traIdTerminal from movtransit where traStatus='V' and traDirection = 'I' and traCarId = 14 order by traDateTime desc,traId desc 01/02/2025 12:21:19.4701 579 ms. EXEC: update abbCards set carLastDate = '2025-02-01 12:21:18',carLastDirection='I' where carStatus='V' and carId = 14 01/02/2025 12:23:44.5274 613 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-01 12:23:10',6,'V',5744890320396620,5737863554129270,2025,'2025-02-01 12:23:10',4,1,0,4,'2025-02-01 12:38:10','P','KES',100,100,0,'','','',1,100,0,0,'',0,0) 01/02/2025 12:28:06.8240 873 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 01/02/2025 12:28:39.9264 522 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 01/02/2025 12:28:40.0795 635 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 01/02/2025 12:28:51.2981 1077 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 01/02/2025 12:28:59.6738 585 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-01 12:28:59',0,'V',5015161232959760,5020442968256580,2025,'2025-02-01 12:28:59',2,1,0,-1,'2025-02-01 13:28:59','S','KES',0,0,0,'','','',3,0,0) 01/02/2025 12:29:35.0007 589 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 01/02/2025 12:30:54.2214 569 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-01 12:30:53','V',4705141526021880,2025,'2025-02-01 12:30:53','456874505300327005012999',1,2,16,'I','',1,0,1,'','',4) 01/02/2025 12:35:14.4076 618 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-01 12:35:13',0,'V',4618703770295070,5413157783567320,2025,'2025-02-01 12:35:13',2,1,0,-1,'2025-02-01 13:35:13','S','KES',0,0,0,'','','',3,0,0) 01/02/2025 12:35:15.0751 653 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-01 12:35:14','V',5516407339669830,2025,'2025-02-01 12:35:13','456874357700327005012999',2,2,2,'O','',0,'2025-02-01 12:35:14',1,'','0230003939927',164,0) 01/02/2025 12:35:16.0507 675 ms. EXEC: update abbCards set carLastDate = '2025-02-01 12:35:15',carLastDirection='O' where carStatus='V' and carId = 164 01/02/2025 12:35:16.6992 645 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 01/02/2025 12:35:17.4617 661 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2025-02-01 12:35:16' where traUID = 5413157783567320 and traStatus='V' and traEnabled=1 01/02/2025 12:36:41.8369 753 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 01/02/2025 12:37:46.2215 920 ms. OPEN: show columns from tabParameters where Field = 'parUseCulture' 01/02/2025 12:37:47.3152 734 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 01/02/2025 12:38:33.1833 512 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 01/02/2025 12:40:07.2580 705 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 01/02/2025 12:40:43.5035 861 ms. EXEC: insert into payReceipt (recTraUID,recPayUID,recYear,recDateTime,recText,recInvalid) VALUES (5544058913261250,5749794780277590,2025,'2025-02-01 12:40:42',' Date: 2/1/2025 12:40:42 PM Code: 456873542300327005012999 Entry Date: 2/1/2025 9:50:23 AM Plate: Class: Cars Park: The Mall Gate: Entry 2 ______________________________ Total: 100.00 KES ______________________________ Paid: 100.00 KES __________ Change: 0.00 KES Type: Cash Dispozitiv: MPESA # 2500704583 ',0) 01/02/2025 12:40:44.1610 1188 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-01 12:40:42','V',4887390998866450,2025,'2025-02-01 12:40:42','456874487800327005012999',2,2,2,'O','',0,'2025-02-01 12:40:42',1,'','',0) 01/02/2025 12:40:44.3171 803 ms. EXEC: update payReceipt set recCreation = '2025-02-01 12:40:43',recModify = '2025-02-01 12:40:43',recUseId=0,recStatus='V' where recId = 348010 01/02/2025 12:40:45.3578 890 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2025-02-01 12:40:44' where traUID = 4768276548425250 and traStatus='V' and traEnabled=1 01/02/2025 12:40:51.1948 523 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 01/02/2025 12:41:21.6414 685 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 01/02/2025 12:41:47.8441 1255 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 01/02/2025 12:41:55.4663 539 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-01 12:41:54',0,'V',5511029491115220,5702061838329350,2025,'2025-02-01 12:41:54',2,1,0,-1,'2025-02-01 13:41:54','S','KES',0,0,0,'','','',3,0,0) 01/02/2025 12:42:02.3449 634 ms. OPEN: show columns from tabParameters where Field = 'parAllowNegativePlaces' 01/02/2025 12:42:15.6269 571 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-01 12:42:15','V',5632985810216970,2025,'2025-02-01 12:42:14','456874501600327005012999',2,2,2,'O','',0,'2025-02-01 12:42:15',1,'','',0) 01/02/2025 12:50:11.5193 861 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2025-02-01 12:50:10' where traUID = 5478757583439890 and traStatus='V' and traEnabled=1 01/02/2025 12:50:18.1418 527 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 01/02/2025 12:51:14.2488 646 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 01/02/2025 12:52:50.8082 527 ms. EXECSCALAR: select count(0) as vTot from tabParameters where parPlateReading<>0 nr: 0 01/02/2025 12:55:42.2253 571 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 5 and terStatus='V' 01/02/2025 12:56:01.2802 1031 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-01 12:56:00','V',5531229778121490,2025,'2025-02-01 12:55:59','456874655900327005012999',1,2,16,'I','',1,0,1,'','',4) 01/02/2025 12:57:41.5801 610 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 01/02/2025 13:00:39.5927 1123 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 01/02/2025 13:00:58.6216 624 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2025-02-01 13:00:57' where traUID = 4802341733395170 and traStatus='V' and traEnabled=1 01/02/2025 13:01:05.9546 512 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 01/02/2025 13:01:12.7532 750 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 01/02/2025 13:03:37.4892 1177 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 01/02/2025 13:03:37.5272 528 ms. EXEC: UPDATE payInventory SET invType='N' WHERE invType<>'N' AND invValue IN (100,200,500) AND invDevice IN (42102,42101,42001); 01/02/2025 13:03:48.4967 637 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2025-02-01 13:03:47' where traUID = 5502229719614630 and traStatus='V' and traEnabled=1 01/02/2025 13:04:35.4595 554 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 01/02/2025 13:06:17.7027 705 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 01/02/2025 13:06:57.2615 1285 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 01/02/2025 13:08:26.8592 564 ms. EXEC: insert into payReceipt (recTraUID,recPayUID,recYear,recDateTime,recText,recInvalid) VALUES (5610316183988900,5529740283458530,2025,'2025-02-01 13:08:26','---------------------------------- %The Mall P0006032390 Canceled payment ---------------------------------- POF Entry : 2/1/2025 12:25:18 PM Date : 2/1/2025 1:08:25 PM Code : 456874471800327005012999 Total : 50.00 KES VAT 16% : 6.90 KES ---------------------------------- Paid : 0.00 KES Coin changed : 0.00 KES Note changed : 0.00 KES Not changed Note : 0.00 KES Coin : 0.00 KES Unavailable : 0.00 KES',1) 01/02/2025 13:10:48.1699 1064 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 01/02/2025 13:12:31.2467 746 ms. EXEC: update tabTerminalReceipt set trcProgressive = 4594, trcLastPrinted = '2500704594', trcLastDate = '2025-02-01 13:12:30' where trcStatus='V' and trcTerId = 18 01/02/2025 13:13:05.8962 590 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 01/02/2025 13:14:21.4304 621 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 01/02/2025 13:15:14.4193 648 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 01/02/2025 13:15:28.0475 671 ms. EXEC: update abbSubscriptions set subCredit = round(subCredit-0,5),subLastDebit = '2025-02-01 13:15:27' where subId = 43 01/02/2025 13:15:48.8956 665 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 01/02/2025 13:15:57.2132 1134 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 01/02/2025 13:19:48.5349 660 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 01/02/2025 13:21:10.8077 627 ms. EXEC: update payInventory set invCreation = '2025-02-01 13:21:10',invModify = '2025-02-01 13:21:10',invUseId=0,invStatus='V' where invId = 234411 01/02/2025 13:25:33.9859 662 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 01/02/2025 13:27:30.2677 1089 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 01/02/2025 13:30:35.8064 549 ms. OPEN: select * from tabArea where areStatus='V' and areEnabled = 1 AND areId = 1 01/02/2025 13:30:36.3417 871 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 01/02/2025 13:30:46.3965 586 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 01/02/2025 13:32:46.3147 807 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 01/02/2025 13:32:57.4893 557 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 01/02/2025 13:33:21.2234 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-01 13:33:20','V',5018292432433530,2025,'2025-02-01 13:33:20','456874880000327005012999',1,2,16,'I','',1,0,1,'','',4) 01/02/2025 13:33:22.9636 1737 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 01/02/2025 13:33:49.6136 1422 ms. EXEC: UPDATE payInventory SET invType='N' WHERE invType<>'N' AND invValue IN (100,200,500) AND invDevice IN (42102,42101,42001); 01/02/2025 13:33:49.7007 1321 ms. EXEC: insert into payReceipt (recTraUID,recPayUID,recYear,recDateTime,recText,recInvalid) VALUES (4757089637161320,4964284057536890,2025,'2025-02-01 13:33:48',' Date: 2/1/2025 1:33:47 PM Code: 456874696500327005012999 Entry Date: 2/1/2025 1:02:45 PM Plate: Class: Cars Park: The Mall Gate: Entry 2 ______________________________ Total: 50.00 KES ______________________________ Paid: 50.00 KES __________ Change: 0.00 KES Type: Cash Dispozitiv: MPESA # 2500704601 ',0) (WAIT TIME 2 ms.) 01/02/2025 13:34:02.0210 530 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 01/02/2025 13:34:23.7067 2517 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-01 13:34:19',0,'V',5704697427921150,5577895110617870,2025,'2025-02-01 13:34:19',3,1,0,4,'2025-02-01 13:49:19','C','KES',50,50,0,'',' ',' ',1,50,0,0,'',0,0) 01/02/2025 13:34:26.2564 1578 ms. EXEC: update paycash set casCreation = '2025-02-01 13:34:24',casModify = '2025-02-01 13:34:24',casUseId=0,casStatus='V' where casId = 207539 01/02/2025 13:35:10.7356 531 ms. EXEC: update payReceipt set recCreation = '2025-02-01 13:35:10',recModify = '2025-02-01 13:35:10',recUseId=0,recStatus='V' where recId = 348052 01/02/2025 13:35:11.4711 764 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-01 13:35:10',0,'V',5576015400199250,5457822716289240,2025,'2025-02-01 13:35:10',18,1,0,4,'2025-02-01 13:50:10','C','KES',100,100,0,'','','',1,100,0,0,'',0,0) 01/02/2025 13:35:11.6222 875 ms. EXEC: insert into paycash (casCreation,casModify,casUseId,casStatus,casUID,casTraUID,casYear,casDateTime,casIdTerminal,casCurrency,casNumber,casSingleAmount,casTotAmount,casType,casDescription) VALUES ('2025-02-01 13:35:10',0,0,'V',4645112159578050,5531229778121490,2025,'2025-02-01 13:35:10',3,'KES',1,100,100,'N',''); 01/02/2025 13:35:12.2416 628 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 1 01/02/2025 13:35:12.8600 693 ms. EXEC: update payInventory set invCreation = '2025-02-01 13:35:12',invModify = '2025-02-01 13:35:12',invUseId=0,invStatus='V' where invId = 234415 01/02/2025 13:35:12.8610 611 ms. EXEC: update tabTerminalReceipt set trcProgressive = 4603, trcLastPrinted = '2500704603', trcLastDate = '2025-02-01 13:35:12' where trcStatus='V' and trcTerId = 18 01/02/2025 13:35:14.0988 626 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 01/02/2025 13:35:14.9774 871 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 01/02/2025 13:35:15.6799 691 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2025-02-01 13:35:14' where payTraUID = 4757089637161320 and payStatus='V' and payEnabled=1 01/02/2025 13:35:17.8624 810 ms. OPEN: select * from tabArea where areStatus='V' and areEnabled = 1 AND areId = 1 01/02/2025 13:37:29.3194 773 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 16 OR lnsTerId=16) 01/02/2025 13:40:13.4386 796 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 01/02/2025 13:41:20.1308 613 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 01/02/2025 13:46:23.2701 944 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 01/02/2025 13:46:23.2711 848 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-01 13:46:22','V',5012228388166660,2025,'2025-02-01 13:46:21','456874800400327005012999',2,2,2,'O','',0,'2025-02-01 13:46:22',1,'','',0) 01/02/2025 13:46:24.9482 657 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 01/02/2025 13:46:24.9873 1272 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2025-02-01 13:46:23' where traUID = 5578010225244090 and traStatus='V' and traEnabled=1 01/02/2025 13:46:27.5050 624 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 01/02/2025 13:49:24.2597 637 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 2 and terStatus='V' 01/02/2025 13:49:24.3347 599 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 01/02/2025 13:49:47.3203 717 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-01 13:49:46','V',5238609388680600,2025,'2025-02-01 13:49:46','456874978600327005012999',1,2,16,'I','',1,0,1,'','',4) 01/02/2025 13:51:05.4012 821 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 01/02/2025 13:51:10.3836 1489 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-01 13:51:08','V',5254235364606310,2025,'2025-02-01 13:51:07','456874986700327005012999',1,2,16,'I','',1,0,1,'','0810007127724',111,0) 01/02/2025 13:51:18.5661 523 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 01/02/2025 13:54:17.4183 538 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 01/02/2025 13:55:17.6771 1133 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 01/02/2025 13:55:22.1241 550 ms. EXEC: UPDATE payCash SET casType='N' WHERE casType<>'N' AND ABS(casSingleAmount) IN (100,200,500); 01/02/2025 13:55:39.7070 1708 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2025-02-01 13:55:37' where traUID = 4637000926595800 and traStatus='V' and traEnabled=1 01/02/2025 13:55:44.7064 582 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 01/02/2025 13:56:00.6352 1100 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2025-02-01 13:55:59',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'; 01/02/2025 13:57:14.1019 958 ms. EXEC: insert into movtransit (traUseId,traCreation,traStatus,traUID,traYear,traDateTime,traCode,traType,traClass,traIdTerminal,traDirection,traPlate,traEnabled,traDisableTime,traAreId,traNotes,traBadge,traTarId) VALUES (0,'2025-02-01 13:57:13','V',5231264208033850,2025,'2025-02-01 13:57:12','456875023200327005012999',1,2,16,'I','',1,0,1,'','',4) 01/02/2025 13:57:22.3225 619 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 01/02/2025 14:07:51.6548 589 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 01/02/2025 14:07:58.8527 575 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-01 14:07:58','V',5318080501624060,2025,'2025-02-01 14:07:57','456875087700327005012999',1,2,16,'I','',1,0,1,'','',4) 01/02/2025 14:08:29.4604 1017 ms. EXEC: update tabTerminalReceipt set trcProgressive = 4609, trcLastPrinted = '2500704609', trcLastDate = '2025-02-01 14:08:28' where trcStatus='V' and trcTerId = 18 01/02/2025 14:09:38.8444 727 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 01/02/2025 14:10:50.5469 558 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 01/02/2025 14:10:51.1774 1194 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 01/02/2025 14:11:28.0413 683 ms. OPEN: select * from payCurInventory where curTerId = 3 and curQuantity>0 and curType in ('C','N') order by curDevCode,curChannelId,curValue 01/02/2025 14:11:34.9110 1562 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-01 14:11:33',0,'V',5598161089153440,5000532767809460,2025,'2025-02-01 14:11:33',18,1,0,4,'2025-02-01 14:26:33','C','KES',50,50,0,'','','',1,50,0,0,'',0,0) 01/02/2025 14:11:36.1468 630 ms. EXEC: update payReceipt set recCreation = '2025-02-01 14:11:35',recModify = '2025-02-01 14:11:35',recUseId=0,recStatus='V' where recId = 348068 01/02/2025 14:14:39.3849 512 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 01/02/2025 14:17:48.0327 605 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 01/02/2025 14:25:39.1748 569 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 01/02/2025 14:25:56.0493 530 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 2 01/02/2025 14:26:14.0805 1417 ms. OPEN: select * from abbAreaGroup left join abbGroupSlots on grsArgId = argId where argStatus='V' and argAbgId = 99999 and (grsDate='1970-01-01' or (grsDate = '2025-02-01' and grsRecurrency=0) or (month(grsDate) = 2 and day(grsDate)=1 and grsRecurrency=1)) order by grsDOW,grsRecurrency,grsDate,grsTimeFrom 01/02/2025 14:26:51.7350 833 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 01/02/2025 14:27:07.8169 1478 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 2 01/02/2025 14:27:24.8264 689 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 5 01/02/2025 14:32:01.6339 514 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 01/02/2025 14:32:25.4570 601 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 01/02/2025 14:35:21.9556 838 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 01/02/2025 14:36:27.8732 787 ms. EXEC: update paycash set casCreation = '2025-02-01 14:36:27',casModify = '2025-02-01 14:36:27',casUseId=0,casStatus='V' where casId = 207554 01/02/2025 14:36:35.9857 595 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 01/02/2025 14:36:40.5178 588 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 01/02/2025 14:36:49.0626 933 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 01/02/2025 14:39:07.6635 689 ms. OPEN: show columns from tabTariff where Field = 'tarCustomMessage' 01/02/2025 14:40:26.3268 530 ms. EXEC: insert into abbPayment (payCreation,payCode,payAmount,payCredit,payPayUID,payCarId,payDateFrom,payDateTo) VALUES ('2025-02-01 14:40:25','0230003944081',0,0,4713619222211730,15,'0000-00-00 00:00:00','0000-00-00 00:00:00') 01/02/2025 14:40:27.5386 809 ms. EXECSCALAR: select count(parId) from tabParameters where parFiscalPrinter <> 0 and parStatus='V' nr: 0 01/02/2025 14:40:27.6426 682 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 01/02/2025 14:40:34.3752 766 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 01/02/2025 14:40:40.0841 722 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 01/02/2025 14:41:28.5839 1212 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-01 14:41:27','V',4934118960972980,2025,'2025-02-01 14:41:26','456875288600327005012999',1,2,16,'I','',1,0,1,'','',4) 01/02/2025 14:42:07.7955 599 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-01 14:42:07','V',4823347740624670,2025,'2025-02-01 14:42:05','456875078500327005012999',2,2,2,'O','',0,'2025-02-01 14:42:07',1,'','0230004098567',165,0) 01/02/2025 14:42:33.2567 665 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 01/02/2025 14:43:02.1113 1027 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-01 14:43:01','V',5333666898786860,2025,'2025-02-01 14:42:58','456875097900327005012999',2,2,2,'O','',0,'2025-02-01 14:43:01',1,'','',0) 01/02/2025 14:43:30.8697 756 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 01/02/2025 14:43:31.5892 586 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 01/02/2025 14:46:22.6531 548 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 01/02/2025 14:47:08.4671 605 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 01/02/2025 14:47:40.5038 518 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 01/02/2025 14:48:31.4523 929 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 2 OR lnsTerId=2) 01/02/2025 14:49:16.9221 507 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2025-02-01 14:49:16',3,42101,0,50,1,50,1,'I','N'); update payCurInventory set curQuantity=round(curQuantity+1,5),curAmount=round(curAmount+50,5) where curTerId = 3 and curDevCode = 42101 and curChannelId = 1 and curValue = 50 and curType = 'N'; 01/02/2025 14:49:19.0276 1998 ms. OPEN: select * from tabCurrency where curStatus='V' and curCode = 'KES' 01/02/2025 14:50:19.7347 1085 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 01/02/2025 14:51:09.3113 519 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 01/02/2025 14:51:56.4292 629 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2025-02-01 14:51:55' where payTraUID = 4921652420838820 and payStatus='V' and payEnabled=1 01/02/2025 14:53:06.0323 537 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 5 and terStatus='V' 01/02/2025 14:55:36.3862 526 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 01/02/2025 14:55:58.9875 570 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 01/02/2025 15:00:39.2073 671 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2025-02-01 15:00:38' where payTraUID = 5613713196886610 and payStatus='V' and payEnabled=1 01/02/2025 15:00:54.1514 589 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 01/02/2025 15:02:20.5079 571 ms. EXECSCALAR: select count(*) from information_schema.tables where table_schema= 'wisepark_0327' and table_name= 'payInvoiceFtp' nr: 1 01/02/2025 15:03:34.1128 583 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-01 15:03:33',0,'V',5167050804553940,5100617902332570,2025,'2025-02-01 15:03:33',18,1,0,4,'2025-02-01 15:18:33','C','KES',50,50,0,'','','',1,50,0,0,'',0,0) 01/02/2025 15:04:51.0749 568 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 01/02/2025 15:05:05.8359 659 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-01 15:05:05','V',5351102103624590,2025,'2025-02-01 15:05:03','456875277300327005012999',2,2,2,'O','',0,'2025-02-01 15:05:05',1,'','',0) 01/02/2025 15:05:06.4173 507 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 01/02/2025 15:07:31.2564 892 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 01/02/2025 15:10:15.0013 572 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 01/02/2025 15:11:36.6376 596 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-01 15:11:36',0,'V',4769483120822970,5489165707689300,2025,'2025-02-01 15:11:36',18,1,0,4,'2025-02-01 15:26:36','C','KES',100,100,0,'','','',1,100,0,0,'',0,0) 01/02/2025 15:12:46.2838 604 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 01/02/2025 15:14:49.0889 1732 ms. EXEC: update payReceipt set recCreation = '2025-02-01 15:14:47',recModify = '2025-02-01 15:14:47',recUseId=0,recStatus='V' where recId = 348102 01/02/2025 15:15:25.0283 661 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 01/02/2025 15:15:45.2870 901 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 01/02/2025 15:16:44.5091 815 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 01/02/2025 15:27:44.4671 695 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 01/02/2025 15:28:36.4263 1703 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 01/02/2025 15:31:16.8610 501 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 01/02/2025 15:31:27.5963 634 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-01 15:31:26',0,'V',4740305076512190,4944443004124060,2025,'2025-02-01 15:31:26',18,1,0,4,'2025-02-01 15:46:26','C','KES',50,50,0,'','','',1,50,0,0,'',0,0) 01/02/2025 15:32:08.5500 838 ms. EXEC: INSERT INTO movOperator (opeCreation,opeUseId,opeTerId,opeDateTime,opeCode,opeDescription) VALUES ('2025-02-01 15:32:07',0,16,'2025-02-01 15:32:07','','Unauthorized Transit Entry 2') 01/02/2025 15:32:21.3397 605 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2025-02-01 15:32:20' where payTraUID = 4837541111312460 and payStatus='V' and payEnabled=1 01/02/2025 15:32:27.5299 943 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 01/02/2025 15:33:23.9361 660 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2025-02-01 15:33:23' where payTraUID = 4944443004124060 and payStatus='V' and payEnabled=1 01/02/2025 15:33:25.8634 1926 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2025-02-01 15:33:23' where traUID = 4944443004124060 and traStatus='V' and traEnabled=1 01/02/2025 15:33:28.8904 584 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 01/02/2025 15:42:29.5616 522 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2025-02-01 15:42:28',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-01 15:42:28',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'; 01/02/2025 15:43:34.4816 636 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 01/02/2025 15:43:37.9039 781 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 01/02/2025 15:45:00.8861 760 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 01/02/2025 15:47:41.0016 922 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2025-02-01 15:47:40' where payTraUID = 5581668190953760 and payStatus='V' and payEnabled=1 01/02/2025 15:47:44.3208 682 ms. EXEC: UPDATE payInventory SET invType='N' WHERE invType<>'N' AND invValue IN (100,200,500) AND invDevice IN (42102,42101,42001); 01/02/2025 15:49:11.8081 2179 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 01/02/2025 15:49:55.4857 577 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 01/02/2025 15:50:14.9058 1007 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 01/02/2025 15:50:21.6904 771 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 2 OR lnsTerId=2) 01/02/2025 15:50:26.2465 622 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 01/02/2025 15:51:33.6131 604 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-01 15:51:32',0,'V',5630066172817990,4723525588715510,2025,'2025-02-01 15:51:32',18,1,0,4,'2025-02-01 16:06:32','C','KES',100,100,0,'','','',1,100,0,0,'',0,0) 01/02/2025 15:53:03.6001 622 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 2 and terStatus='V' 01/02/2025 15:53:10.1986 1163 ms. EXECSCALAR: SELECT traId FROM movTransit WHERE traStatus='V' AND traCode = @traCode nr: 838281 01/02/2025 15:58:16.6952 610 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 01/02/2025 16:00:56.1071 509 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 01/02/2025 16:01:54.8199 581 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 01/02/2025 16:06:17.0005 670 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-01 16:06:16','V',5257921795928090,2025,'2025-02-01 16:06:15','456875587600327005012999',2,2,2,'O','',0,'2025-02-01 16:06:16',1,'','',0) 01/02/2025 16:06:59.2281 1629 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 01/02/2025 16:07:57.3745 540 ms. EXEC: update abbSubscriptions set subCredit = round(subCredit-0,5),subLastDebit = '2025-02-01 16:07:56' where subId = 196 01/02/2025 16:10:31.5119 528 ms. OPEN: select * from tabArea where areStatus='V' and areEnabled = 1 AND areId = 1 01/02/2025 16:11:05.9592 1093 ms. EXECSCALAR: select count(*) from information_schema.tables where table_schema= 'wisepark_0327' and table_name= 'payInvoiceFtp' nr: 1 01/02/2025 16:16:02.6412 945 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 01/02/2025 16:17:06.3233 1121 ms. EXEC: insert into payReceipt (recTraUID,recPayUID,recYear,recDateTime,recText,recInvalid) VALUES (5118155035347970,5034762068737330,2025,'2025-02-01 16:17:05','---------------------------------- %The Mall P0006032390 End of payment ---------------------------------- POF Entry : 2/1/2025 3:48:16 PM Date : 2/1/2025 4:17:03 PM Code : 456875689600327005012999 Total : 50.00 KES VAT 16% : 6.90 KES ---------------------------------- Paid : 50.00 KES Coin changed : 0.00 KES Note changed : 0.00 KES',0) 01/02/2025 16:17:08.0615 1048 ms. EXEC: update payInventory set invCreation = '2025-02-01 16:17:07',invModify = '2025-02-01 16:17:07',invUseId=0,invStatus='V' where invId = 234455 01/02/2025 16:17:08.0865 653 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 01/02/2025 16:18:42.9127 872 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 01/02/2025 16:18:56.7641 785 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 01/02/2025 16:18:57.4025 569 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 01/02/2025 16:22:32.8135 877 ms. EXEC: insert into movtransit (traUseId,traCreation,traStatus,traUID,traYear,traDateTime,traCode,traType,traClass,traIdTerminal,traDirection,traPlate,traEnabled,traDisableTime,traAreId,traNotes,traBadge,traTarId) VALUES (0,'2025-02-01 16:22:31','V',4712674820668850,2025,'2025-02-01 16:22:30','456875895000327005012999',1,2,16,'I','',1,0,1,'','',4) 01/02/2025 16:22:55.6399 555 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 01/02/2025 16:23:06.7805 747 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 01/02/2025 16:23:31.1240 560 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 01/02/2025 16:23:50.6682 1409 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-01 16:23:49',0,'V',5220813463006680,5363145166714590,2025,'2025-02-01 16:23:49',18,1,0,4,'2025-02-01 16:38:49','C','KES',100,100,0,'','','',1,100,0,0,'',0,0) 01/02/2025 16:24:22.1965 1631 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 01/02/2025 16:25:10.6564 630 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 01/02/2025 16:31:59.5393 568 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 01/02/2025 16:33:00.7618 840 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-01 16:32:59','V',4611686966758440,2025,'2025-02-01 16:32:57','456875626700327005012999',2,2,2,'O','',0,'2025-02-01 16:32:59',1,'','',0) 01/02/2025 16:34:55.1423 576 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 01/02/2025 16:37:30.9178 2476 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 01/02/2025 16:40:10.3147 616 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2025-02-01 16:40:09',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-01 16:40:09',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'; 01/02/2025 16:41:28.8409 560 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 01/02/2025 16:43:33.1982 527 ms. EXEC: insert into movtransit (traUseId,traCreation,traStatus,traUID,traYear,traDateTime,traCode,traType,traClass,traIdTerminal,traDirection,traPlate,traEnabled,traDisableTime,traAreId,traNotes,traBadge,traTarId) VALUES (0,'2025-02-01 16:43:32','V',4954032501852870,2025,'2025-02-01 16:43:31','456875591500327005012999',2,2,2,'O','',0,'2025-02-01 16:43:32',1,'','',0) 01/02/2025 16:45:01.6611 557 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 01/02/2025 16:45:15.3023 723 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-01 16:45:14','V',4662537244904340,2025,'2025-02-01 16:45:13','456876031300327001012999',1,2,1,'I','',1,0,1,'','',4) 01/02/2025 16:49:10.0633 689 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 01/02/2025 16:57:08.3603 855 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 01/02/2025 17:03:53.2516 750 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 01/02/2025 17:04:18.1044 735 ms. EXEC: insert into payReceipt (recTraUID,recPayUID,recYear,recDateTime,recText,recInvalid) VALUES (4642187224324000,5231518582047600,2025,'2025-02-01 17:04:17','---------------------------------- %The Mall P0006032390 End of payment ---------------------------------- POF Entry : 2/1/2025 4:09:17 PM Date : 2/1/2025 5:04:16 PM Code : 456875815700327005012999 Total : 50.00 KES VAT 16% : 6.90 KES ---------------------------------- Paid : 100.00 KES Coin changed : 0.00 KES Note changed : 50.00 KES',0) 01/02/2025 17:05:22.3579 1113 ms. EXEC: UPDATE payCash SET casType='N' WHERE casType<>'N' AND ABS(casSingleAmount) IN (100,200,500); 01/02/2025 17:06:24.8312 612 ms. EXEC: insert into movOperator (opeCreation,opeTerId,opeUseId,opeDateTime,opeCode,opeDescription) VALUES ('2025-02-01 17:06:24',4,6,'2025-02-01 17:06:24','456876017800327005012999','Payed (Credit Card ) Ticket ') 01/02/2025 17:07:31.4513 639 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-01 17:07:30','V',4751802908295020,2025,'2025-02-01 17:07:29','456876164900327005012999',1,2,16,'I','',1,0,1,'','0810007086215',125,0) 01/02/2025 17:07:32.5151 1059 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 01/02/2025 17:07:44.5502 1063 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 01/02/2025 17:14:55.9284 674 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 01/02/2025 17:15:57.1469 503 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 01/02/2025 17:21:18.2494 1822 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 3 OR lnsTerId=3) 01/02/2025 17:21:19.5452 566 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 01/02/2025 17:21:24.0073 526 ms. EXEC: insert into payReceipt (recTraUID,recPayUID,recYear,recDateTime,recText,recInvalid) VALUES (5426506813864430,5664027349957340,2025,'2025-02-01 17:21:23','---------------------------------- %The Mall P0006032390 End of payment ---------------------------------- POF Entry : 2/1/2025 3:53:07 PM Date : 2/1/2025 5:21:22 PM Code : 456875718700327005012999 Total : 100.00 KES VAT 16% : 13.79 KES ---------------------------------- Paid : 100.00 KES Coin changed : 0.00 KES Note changed : 0.00 KES',0) 01/02/2025 17:21:43.2813 624 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 01/02/2025 17:21:53.9315 1328 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-01 17:21:52','V',4962124280187640,2025,'2025-02-01 17:21:51','456876251100327005012999',1,2,16,'I','',1,0,1,'','',4) 01/02/2025 17:23:04.2492 723 ms. EXEC: insert into payReceipt (recTraUID,recPayUID,recYear,recDateTime,recText,recInvalid) VALUES (4850240606509980,5398806561232960,2025,'2025-02-01 17:23:03',' Date: 2/1/2025 5:23:03 PM Code: 456876050100327001012999 Entry Date: 2/1/2025 4:48:21 PM Plate: Class: Cars Park: The Mall Gate: Entry 1 ______________________________ Total: 50.00 KES ______________________________ Paid: 50.00 KES __________ Change: 0.00 KES Type: Cash Dispozitiv: MPESA # 2500704654 ',0) 01/02/2025 17:23:22.7737 538 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 01/02/2025 17:30:44.2708 685 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-01 17:30:42',0,'V',5757635238856530,5246778156353840,2025,'2025-02-01 17:30:42',3,1,0,4,'2025-02-01 17:45:42','C','KES',50,50,0,'',' ',' ',1,50,0,0,'',0,0) 01/02/2025 17:31:17.8985 591 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 01/02/2025 17:31:37.5588 519 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-01 17:31:37','V',5616145180657650,2025,'2025-02-01 17:31:35','456876309500327005012999',1,2,16,'I','',1,0,1,'','',4) 01/02/2025 17:31:38.5525 519 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 01/02/2025 17:33:11.2523 654 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 01/02/2025 17:34:38.9047 1669 ms. EXEC: UPDATE payInventory SET invType='N' WHERE invType<>'N' AND invValue IN (100,200,500) AND invDevice IN (42102,42101,42001); 01/02/2025 17:34:51.3401 573 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 4 and terStatus='V' 01/02/2025 17:35:27.1704 509 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 01/02/2025 17:36:31.3569 1183 ms. EXEC: insert into payReceipt (recTraUID,recPayUID,recYear,recDateTime,recText,recInvalid) VALUES (5616145180657650,5324769702587200,2025,'2025-02-01 17:36:30','---------------------------------- %The Mall P0006032390 End of payment ---------------------------------- POF Entry : 2/1/2025 5:31:35 PM Date : 2/1/2025 5:36:28 PM Code : 456876309500327005012999 Total : 50.00 KES VAT 16% : 6.90 KES ---------------------------------- Paid : 100.00 KES Coin changed : 0.00 KES Note changed : 50.00 KES',0) 01/02/2025 17:37:31.4606 805 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 01/02/2025 17:38:25.7413 588 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 01/02/2025 17:39:00.1016 813 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2025-02-01 17:38:59',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-01 17:38:59',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'; 01/02/2025 17:44:08.5045 912 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 01/02/2025 17:45:09.5989 537 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-01 17:45:08',0,'V',5233573147250450,4662537244904340,2025,'2025-02-01 17:45:08',18,1,0,4,'2025-02-01 18:00:08','C','KES',50,50,0,'','','',1,50,0,0,'',0,0) 01/02/2025 17:45:16.3665 518 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 01/02/2025 17:45:58.0297 608 ms. OPEN: show columns from tabTariff where Field = 'tarTimeControlTimeEnd' 01/02/2025 17:45:59.1534 1015 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-01 17:45:58','V',5275152091824710,2025,'2025-02-01 17:45:56','456876031300327001012999',2,2,2,'O','',0,'2025-02-01 17:45:58',1,'','',0) 01/02/2025 17:46:00.4653 1147 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 01/02/2025 17:46:06.4004 695 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 01/02/2025 17:50:25.5159 520 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 01/02/2025 17:50:26.0112 1150 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 01/02/2025 17:54:39.8041 640 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 01/02/2025 17:56:02.9424 577 ms. EXEC: UPDATE payInventory SET invType='N' WHERE invType<>'N' AND invValue IN (100,200,500) AND invDevice IN (42102,42101,42001); 01/02/2025 17:56:26.3733 504 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-01 17:56:25','V',5451036439386950,2025,'2025-02-01 17:56:24','456876458400327005012999',1,2,16,'I','',1,0,1,'','',4) 01/02/2025 17:57:38.6282 582 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 01/02/2025 17:59:28.0844 581 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 01/02/2025 18:00:56.3361 888 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-01 18:00:55',0,'V',5664171918696600,5147930401096210,2025,'2025-02-01 18:00:55',18,1,0,4,'2025-02-01 18:15:55','C','KES',50,50,0,'','','',1,50,0,0,'',0,0) 01/02/2025 18:01:17.6796 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-01 18:01:17','V',5235888374515130,2025,'2025-02-01 18:01:16','456876487600327005012999',1,2,16,'I','',1,0,1,'','',4) 01/02/2025 18:03:31.8985 968 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2025-02-01 18:03:30' where traUID = 5147930401096210 and traStatus='V' and traEnabled=1 01/02/2025 18:06:24.6905 650 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 01/02/2025 18:07:06.5529 508 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 1 01/02/2025 18:07:28.3497 1102 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 01/02/2025 18:08:56.5274 676 ms. EXEC: update abbSubscriptions set subCredit = round(subCredit-0,5),subLastDebit = '2025-02-01 18:08:55' where subId = 179 01/02/2025 18:08:58.3516 1200 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 01/02/2025 18:09:11.3654 574 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 01/02/2025 18:11:07.2639 511 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-01 18:11:06',0,'V',5666220083748920,5540255285941280,2025,'2025-02-01 18:11:06',18,1,0,4,'2025-02-01 18:26:06','C','KES',100,100,0,'','','',1,100,0,0,'',0,0) 01/02/2025 18:12:36.2132 529 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 01/02/2025 18:13:18.1956 724 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 01/02/2025 18:15:23.8257 2039 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-01 18:15:21','V',4979702259718410,2025,'2025-02-01 18:15:21','456876572100327001012999',1,2,1,'I','',1,0,1,'','',4) 01/02/2025 18:15:35.7738 511 ms. EXEC: INSERT INTO movOperator (opeCreation,opeUseId,opeTerId,opeDateTime,opeCode,opeDescription) VALUES ('2025-02-01 18:15:35',0,1,'2025-02-01 18:15:35','','Unauthorized Transit Entry 1') 01/02/2025 18:16:17.0398 513 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 3 and terStatus='V' 01/02/2025 18:19:05.1747 1193 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 5 and terStatus='V' 01/02/2025 18:19:24.1055 774 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 01/02/2025 18:19:38.9575 901 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 01/02/2025 18:19:43.4646 1632 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 01/02/2025 18:20:10.5609 744 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-01 18:20:09','V',5562795934828070,2025,'2025-02-01 18:20:09','456876455700327005012999',2,2,2,'O','',0,'2025-02-01 18:20:09',1,'','',0) 01/02/2025 18:22:02.4177 3469 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 2 01/02/2025 18:22:56.7955 546 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-01 18:22:56','V',4808537944398740,2025,'2025-02-01 18:22:54','456876480700327005012999',2,2,2,'O','',0,'2025-02-01 18:22:56',1,'','',0) 01/02/2025 18:22:57.4120 548 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 01/02/2025 18:23:02.8616 554 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 01/02/2025 18:23:30.8456 726 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 01/02/2025 18:28:08.9750 1008 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2025-02-01 18:28:07',3,42101,0,50,-1,-50,1,'O','N'); update payCurInventory set curQuantity=round(curQuantity+-1,5),curAmount=round(curAmount+-50,5) where curTerId = 3 and curDevCode = 42101 and curChannelId = 1 and curValue = 50 and curType = 'N'; 01/02/2025 18:32:03.6079 1610 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 01/02/2025 18:32:05.8094 541 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 01/02/2025 18:40:30.4552 720 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-01 18:40:29','V',4616871639695380,2025,'2025-02-01 18:40:29','456876722900327005012999',1,2,16,'I','',1,0,1,'','',4) 01/02/2025 18:43:36.0539 603 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 1 OR lnsTerId=1) 01/02/2025 18:45:03.4211 580 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 01/02/2025 18:45:11.4876 721 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 01/02/2025 18:45:59.1959 568 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 01/02/2025 18:46:58.0558 681 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 01/02/2025 18:51:37.0417 823 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-01 18:51:36','V',4900114873254390,2025,'2025-02-01 18:51:35','456876589300327005012999',2,2,2,'O','',0,'2025-02-01 18:51:36',1,'','',0) 01/02/2025 18:51:37.0747 871 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 01/02/2025 18:51:38.0704 728 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 01/02/2025 18:52:06.6438 877 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 01/02/2025 18:54:12.7222 592 ms. EXEC: update payInventory set invCreation = '2025-02-01 18:54:12',invModify = '2025-02-01 18:54:12',invUseId=0,invStatus='V' where invId = 234502 01/02/2025 18:54:48.4053 1080 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 01/02/2025 18:55:51.4631 893 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2025-02-01 18:55:50' where payTraUID = 4984805184404820 and payStatus='V' and payEnabled=1 01/02/2025 18:55:52.3126 849 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2025-02-01 18:55:50' where traUID = 4984805184404820 and traStatus='V' and traEnabled=1 01/02/2025 18:55:55.6709 541 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 01/02/2025 18:55:56.1983 723 ms. EXECSCALAR: select count(*) from information_schema.tables where table_schema= 'wisepark_0327' and table_name= 'payInvoiceFtp' nr: 1 01/02/2025 18:59:40.4542 640 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 01/02/2025 18:59:43.2010 963 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-01 18:59:42','V',5625403629728000,2025,'2025-02-01 18:59:40','456876838000327005012999',1,2,16,'I','',1,0,1,'','',4) 01/02/2025 19:01:20.8692 1105 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 01/02/2025 19:03:01.5464 1203 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 01/02/2025 19:04:23.6630 665 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 01/02/2025 19:06:48.0738 559 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 01/02/2025 19:08:54.4154 602 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2025-02-01 19:08:53' where traUID = 5327501512868200 and traStatus='V' and traEnabled=1 01/02/2025 19:09:01.4882 1414 ms. EXEC: UPDATE payInventory SET invType='N' WHERE invType<>'N' AND invValue IN (100,200,500) AND invDevice IN (42102,42101,42001); 01/02/2025 19:13:40.2040 618 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 01/02/2025 19:13:40.5732 904 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 01/02/2025 19:14:05.0218 575 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 01/02/2025 19:16:36.0170 570 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 01/02/2025 19:17:49.5548 512 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 01/02/2025 19:19:23.8207 1027 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 01/02/2025 19:25:36.7803 509 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 01/02/2025 19:26:33.6458 686 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2025-02-01 19:26:32',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'; 01/02/2025 19:27:06.5031 678 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 01/02/2025 19:30:47.7269 633 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 01/02/2025 19:31:00.2114 1581 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 3 OR lnsTerId=3) 01/02/2025 19:33:33.8375 803 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 01/02/2025 19:38:34.9374 580 ms. EXEC: delete from movInside where insTraUID = 5744739449654220 01/02/2025 19:38:34.9374 562 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 01/02/2025 19:38:38.9041 896 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 01/02/2025 19:38:39.5105 560 ms. EXEC: UPDATE payInventory SET invType='N' WHERE invType<>'N' AND invValue IN (100,200,500) AND invDevice IN (42102,42101,42001); 01/02/2025 19:39:01.1662 933 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 01/02/2025 19:40:15.2133 585 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 01/02/2025 19:40:27.0313 860 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 01/02/2025 19:45:10.0310 686 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 01/02/2025 19:45:44.2612 727 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 01/02/2025 19:49:24.2752 843 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 01/02/2025 19:49:33.3834 959 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 01/02/2025 19:56:00.8528 591 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 01/02/2025 19:59:56.8887 544 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 01/02/2025 20:07:30.6040 1794 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 01/02/2025 20:12:25.6068 662 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 01/02/2025 20:12:34.8161 640 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 01/02/2025 20:12:37.1737 1240 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 01/02/2025 20:15:51.5814 835 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 01/02/2025 20:16:03.4554 1080 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 01/02/2025 20:19:06.7956 1506 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-01 20:19:05','V',5463556398217870,2025,'2025-02-01 20:19:05','456877163400327005012999',2,2,2,'O','',0,'2025-02-01 20:19:05',1,'','',0) 01/02/2025 20:22:48.5828 811 ms. EXEC: update paycash set casCreation = '2025-02-01 20:22:47',casModify = '2025-02-01 20:22:47',casUseId=0,casStatus='V' where casId = 207635 01/02/2025 20:23:20.4044 570 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 01/02/2025 20:26:21.6071 736 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 01/02/2025 20:26:22.2886 645 ms. EXEC: UPDATE payInventory SET invType='N' WHERE invType<>'N' AND invValue IN (100,200,500) AND invDevice IN (42102,42101,42001); 01/02/2025 20:26:56.3056 942 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 01/02/2025 20:26:59.7059 686 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2025-02-01 20:26:58' where traUID = 5572501854054110 and traStatus='V' and traEnabled=1 01/02/2025 20:36:09.3012 509 ms. EXECSCALAR: select count(0) as vTot from tabParameters where parPlateReading<>0 nr: 0 01/02/2025 20:37:38.3235 577 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-01 20:37:36',12,'V',5745171681085500,5232209934512490,2025,'2025-02-01 20:37:36',17,1,0,4,'2025-02-01 20:52:36','C','KES',100,100,0,'','','',1,100,0,0,'',0,0) 01/02/2025 20:40:54.8596 545 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-01 20:40:54','V',4748100614537390,2025,'2025-02-01 20:40:54','456876871600327005012999',2,2,2,'O','',0,'2025-02-01 20:40:54',1,'','',0) 01/02/2025 20:41:30.6648 868 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 01/02/2025 20:42:45.7847 591 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-01 20:42:45',0,'V',5255008219013860,4850138705812600,2025,'2025-02-01 20:42:45',2,1,0,-1,'2025-02-01 21:42:45','S','KES',0,0,0,'','','',3,0,0) 01/02/2025 20:42:50.9342 606 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 01/02/2025 20:54:05.7213 1311 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-01 20:54:04','V',5432600946519540,2025,'2025-02-01 20:54:04','456877524400327005012999',1,2,16,'I','',1,0,1,'','',4) 01/02/2025 20:55:41.6883 533 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 01/02/2025 20:55:41.7333 865 ms. EXEC: insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2025-02-01 20:55:40',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-01 20:55:40',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'; 01/02/2025 20:56:24.1100 530 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 01/02/2025 20:57:59.2234 1430 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 01/02/2025 21:06:03.5305 636 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 01/02/2025 21:08:13.8387 1033 ms. EXEC: update payReceipt set recCreation = '2025-02-01 21:08:12',recModify = '2025-02-01 21:08:12',recUseId=0,recStatus='V' where recId = 348233 01/02/2025 21:09:35.1628 647 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 01/02/2025 21:17:44.8095 1990 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 01/02/2025 21:20:51.6310 913 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 01/02/2025 21:22:26.5263 591 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 01/02/2025 21:27:54.2162 664 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-01 21:27:52',0,'V',5599057192154330,5474649796207970,2025,'2025-02-01 21:27:52',3,1,0,4,'2025-02-01 21:42:52','C','KES',50,50,0,'',' ',' ',1,50,0,0,'',0,0) 01/02/2025 21:29:16.5380 526 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 01/02/2025 21:34:08.7369 1259 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 01/02/2025 21:34:58.4076 517 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 01/02/2025 21:36:41.3403 504 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 01/02/2025 21:38:01.7287 686 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 01/02/2025 21:38:34.6971 581 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 01/02/2025 21:39:22.4964 693 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 01/02/2025 21:41:11.1310 526 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 01/02/2025 21:42:09.9549 930 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 01/02/2025 21:44:40.3688 545 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 01/02/2025 21:55:03.5579 1227 ms. EXECSCALAR: select count(*) from information_schema.tables where table_schema= 'wisepark_0327' and table_name= 'payInvoiceFtp' nr: 1 01/02/2025 21:55:04.3434 520 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 01/02/2025 21:55:06.8801 1488 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 01/02/2025 21:55:07.9959 2432 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 01/02/2025 21:55:09.4679 2384 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 01/02/2025 21:55:09.4949 1125 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 01/02/2025 21:55:09.5149 809 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 2 01/02/2025 21:55:43.8161 549 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 01/02/2025 21:56:14.4969 572 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 01/02/2025 22:00:36.4694 731 ms. EXEC: update payReceipt set recCreation = '2025-02-01 22:00:35',recModify = '2025-02-01 22:00:35',recUseId=0,recStatus='V' where recId = 348251 01/02/2025 22:02:07.7642 980 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 01/02/2025 22:02:13.0958 1896 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 01/02/2025 22:02:13.4360 1939 ms. EXECSCALAR: select count(0) as vTot from tabParameters where parPlateReading<>0 nr: 0 01/02/2025 22:02:33.7398 1443 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 2 01/02/2025 22:03:21.3510 1009 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 01/02/2025 22:04:52.4147 1310 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 5 01/02/2025 22:05:18.2942 528 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 01/02/2025 22:06:36.8104 577 ms. EXECSCALAR: select count(0) as vTot from tabParameters where parPlateReading<>0 nr: 0 01/02/2025 22:07:03.8838 898 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 01/02/2025 22:10:47.8515 878 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 3 01/02/2025 22:10:58.0744 561 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 01/02/2025 22:14:18.5172 833 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 01/02/2025 22:17:13.0934 530 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 01/02/2025 22:20:04.2473 787 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2025-02-01 22:20:03',3,42101,0,50,-1,-50,1,'O','N'); update payCurInventory set curQuantity=round(curQuantity+-1,5),curAmount=round(curAmount+-50,5) where curTerId = 3 and curDevCode = 42101 and curChannelId = 1 and curValue = 50 and curType = 'N'; Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2025-02-01 22:20:03',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'; 01/02/2025 22:20:04.9508 703 ms. EXEC: update payInventory set invCreation = '2025-02-01 22:20:04',invModify = '2025-02-01 22:20:04',invUseId=0,invStatus='V' where invId = 234541 01/02/2025 22:20:51.5644 606 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 01/02/2025 22:25:59.7311 826 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 2 01/02/2025 22:28:19.3587 636 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 01/02/2025 22:28:40.5130 730 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 01/02/2025 22:30:00.1930 1000 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 01/02/2025 22:30:02.2154 546 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 01/02/2025 22:30:28.2300 560 ms. EXEC: insert into payPayment (payCreation,payUseId,payStatus,payUID,payTraUID,payYear,payDateTime,payIdTerminal,payEnabled,payDisableTime,payTarId,payTimeLimit,payType,payCurrency,payAmount,payPayed,payChange,payCardType,payPAN,paySTAN,payIdEvent,payAmountCalc,payDiscountValue,payDiscount,payDiscountType,payVatPercent,payVatAmount) VALUES ('2025-02-01 22:30:26',0,'V',5470153569441430,4813756921908920,2025,'2025-02-01 22:30:26',3,1,0,4,'2025-02-01 22:45:26','C','KES',150,1000,700,'',' ',' ',2,150,0,0,'',0,0) 01/02/2025 22:30:31.7264 1925 ms. EXEC: insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2025-02-01 22:30:29',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'; insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2025-02-01 22:30:29',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'; Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2025-02-01 22:30:29',3,42101,0,200,-1,-200,1,'O','N'); update payCurInventory set curQuantity=round(curQuantity+-1,5),curAmount=round(curAmount+-200,5) where curTerId = 3 and curDevCode = 42101 and curChannelId = 1 and curValue = 200 and curType = 'N'; Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2025-02-01 22:30:29',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'; 01/02/2025 22:31:34.1376 539 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-01 22:31:33','V',5353704015772580,2025,'2025-02-01 22:31:32','456877527900327005012999',2,2,2,'O','',0,'2025-02-01 22:31:33',1,'','',0) 01/02/2025 22:33:13.2998 577 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 01/02/2025 22:40:47.1672 564 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 01/02/2025 22:42:36.0470 870 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 2 01/02/2025 22:44:48.4887 569 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 01/02/2025 22:46:18.9950 562 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 01/02/2025 22:49:20.7741 891 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 01/02/2025 22:53:51.5245 1718 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2025-02-01 22:53:49' where traUID = 4691011773589560 and traStatus='V' and traEnabled=1 01/02/2025 23:15:30.2762 1940 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 01/02/2025 23:16:05.3129 1505 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 17 OR lnsTerId=17) 01/02/2025 23:17:15.0872 1367 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 1 01/02/2025 23:20:37.6454 2367 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 2 OR lnsTerId=2) 01/02/2025 23:21:52.6762 524 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 01/02/2025 23:28:43.7737 553 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 (WAIT TIME 479 ms.) 01/02/2025 23:33:20.5221 2090 ms. EXEC: UPDATE payInventory SET invType='N' WHERE invType<>'N' AND invValue IN (100,200,500) AND invDevice IN (42102,42101,42001); 01/02/2025 23:36:17.4149 1561 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 01/02/2025 23:44:03.3045 1168 ms. OPEN: select * from tabArea where areStatus='V' and areEnabled = 1 AND areId = 1