11/11/2024 00:08:19.9177 982 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/11/2024 00:12:43.7074 553 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 5 and terStatus='V' 11/11/2024 00:12:45.4526 683 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/11/2024 00:12:54.5967 596 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 2 OR lnsTerId=2) 11/11/2024 00:13:53.4139 635 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 5 and terStatus='V' 11/11/2024 00:13:56.2298 1111 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 5 11/11/2024 00:13:57.0413 810 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 11/11/2024 00:24:09.2121 1838 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/11/2024 00:28:07.0846 977 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/11/2024 00:46:12.9039 770 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 11/11/2024 00:46:13.5143 608 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2024-11-11 00:46:12' where payTraUID = 5182569095157000 and payStatus='V' and payEnabled=1 11/11/2024 00:52:14.5818 3448 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/11/2024 00:58:12.4572 595 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/11/2024 00:58:26.8388 1855 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/11/2024 01:00:40.4668 687 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2024-11-11 01:00:39' where payTraUID = 5013901931738540 and payStatus='V' and payEnabled=1 11/11/2024 01:00:47.1142 665 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 11/11/2024 01:10:31.4916 1683 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/11/2024 01:10:53.5912 707 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 11/11/2024 01:15:52.5374 1040 ms. OPEN: select sum(crc32(terDescription)) as vCheck from tabTerminal 11/11/2024 01:29:29.1213 1321 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 2 11/11/2024 01:45:03.6789 829 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/11/2024 02:16:24.0565 1354 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/11/2024 02:20:31.0731 590 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/11/2024 02:30:17.6728 563 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/11/2024 02:31:36.6735 1168 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 16 OR lnsTerId=16) 11/11/2024 02:32:51.7675 1223 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/11/2024 02:41:29.1251 521 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/11/2024 02:42:22.2735 535 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/11/2024 02:43:08.2091 1118 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2024-11-11 02:43:06',3,42101,0,200,1,200,1,'I','N'); update payCurInventory set curQuantity=round(curQuantity+1,5),curAmount=round(curAmount+200,5) where curTerId = 3 and curDevCode = 42101 and curChannelId = 1 and curValue = 200 and curType = 'N'; 11/11/2024 03:01:08.4797 2372 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/11/2024 03:02:35.1064 568 ms. EXECSCALAR: select count(0) as vTot from tabParameters where parPlateReading<>0 nr: 0 11/11/2024 03:02:55.6651 1764 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/11/2024 03:15:10.2445 527 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/11/2024 03:24:28.2462 2669 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/11/2024 03:35:50.5307 680 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/11/2024 03:41:24.4161 516 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 16 OR lnsTerId=16) 11/11/2024 03:43:48.4170 837 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/11/2024 03:55:17.2849 522 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/11/2024 03:58:15.1824 640 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 11/11/2024 04:00:49.8074 556 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/11/2024 04:01:01.7374 518 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/11/2024 04:01:09.2454 819 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/11/2024 04:04:01.0749 583 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/11/2024 04:06:08.3126 912 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/11/2024 04:12:24.5793 746 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/11/2024 04:12:26.5025 661 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/11/2024 04:23:11.4982 744 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/11/2024 04:24:42.9611 601 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/11/2024 04:28:46.4293 789 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/11/2024 04:31:07.9716 606 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/11/2024 04:31:51.2474 1363 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/11/2024 04:33:35.3878 992 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/11/2024 04:35:20.6449 622 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 11/11/2024 04:47:02.3924 518 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/11/2024 04:57:19.9798 1702 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/11/2024 05:12:00.9767 1197 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/11/2024 05:14:32.8068 2079 ms. EXEC: insert into payPayment (payCreation,payUseId,payStatus,payUID,payTraUID,payYear,payDateTime,payIdTerminal,payEnabled,payDisableTime,payTarId,payTimeLimit,payType,payCurrency,payAmount,payPayed,payChange,payCardType,payPAN,paySTAN,payIdEvent,payAmountCalc,payDiscountValue,payDiscount,payDiscountType,payVatPercent,payVatAmount) VALUES ('2024-11-11 05:14:29',0,'V',5734435502978790,4841557682625270,2024,'2024-11-11 05:14:29',3,1,0,4,'2024-11-11 05:29:29','C','KES',100,100,0,'',' ',' ',1,100,0,0,'',0,0) 11/11/2024 05:14:34.7551 511 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2024-11-11 05:14:33',3,42101,0,100,1,100,1,'I','N'); update payCurInventory set curQuantity=round(curQuantity+1,5),curAmount=round(curAmount+100,5) where curTerId = 3 and curDevCode = 42101 and curChannelId = 1 and curValue = 100 and curType = 'N'; 11/11/2024 05:14:35.3905 631 ms. EXEC: update payInventory set invCreation = '2024-11-11 05:14:34',invModify = '2024-11-11 05:14:34',invUseId=0,invStatus='V' where invId = 218538 11/11/2024 05:33:25.3603 607 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 5 and terStatus='V' 11/11/2024 05:34:46.8215 521 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/11/2024 05:43:38.5992 614 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 5 and terStatus='V' 11/11/2024 05:47:06.1795 657 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 11/11/2024 05:54:16.2650 1436 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/11/2024 05:59:41.3885 598 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/11/2024 06:07:24.7402 1329 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/11/2024 06:08:26.6534 1065 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/11/2024 06:14:12.1786 786 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/11/2024 06:17:49.3973 559 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/11/2024 06:23:26.2887 503 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/11/2024 06:34:35.3374 751 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/11/2024 06:38:48.6892 711 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/11/2024 06:45:31.0943 518 ms. EXEC: insert into paycash (casCreation,casModify,casUseId,casStatus,casUID,casTraUID,casYear,casDateTime,casIdTerminal,casCurrency,casNumber,casSingleAmount,casTotAmount,casType,casDescription) VALUES ('2024-11-11 06:45:30',0,0,'V',5182164955791050,5225229017380300,2024,'2024-11-11 06:45:30',3,'KES',1,50,50,'N',''); 11/11/2024 07:17:20.4932 521 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 11/11/2024 07:20:11.2319 591 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/11/2024 07:27:51.4205 1424 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2024-11-11 07:27:49' where payTraUID = 5259720883005930 and payStatus='V' and payEnabled=1 11/11/2024 07:27:57.8398 517 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 11/11/2024 07:31:52.6782 2189 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/11/2024 07:32:58.7282 1186 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/11/2024 07:44:09.5050 667 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/11/2024 07:45:19.0574 2042 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/11/2024 07:47:25.8148 516 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/11/2024 07:51:51.3557 507 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 1 11/11/2024 07:51:53.5512 1278 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/11/2024 07:52:12.5919 580 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 11/11/2024 07:54:55.2962 573 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/11/2024 07:55:04.1181 992 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 1 and terStatus='V' 11/11/2024 07:58:40.4842 809 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/11/2024 07:59:32.4208 681 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 11/11/2024 08:03:47.2166 761 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/11/2024 08:03:47.2426 2103 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 2 OR lnsTerId=2) 11/11/2024 08:04:11.6008 1886 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 11/11/2024 08:04:16.7302 2518 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/11/2024 08:06:20.2965 570 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 11/11/2024 08:06:36.7025 1373 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/11/2024 08:09:57.7714 998 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/11/2024 08:11:08.8978 903 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 11/11/2024 08:12:36.7543 1164 ms. EXEC: insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2024-11-11 08:12:23',5,3,42101,0,50,-6,-300,1,'O','N'); insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2024-11-11 08:12:23',5,3,42101,0,50,6,300,2,'I','N'); insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2024-11-11 08:12:23',5,3,42101,0,100,-46,-4600,1,'O','N'); insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2024-11-11 08:12:23',5,3,42101,0,100,46,4600,2,'I','N'); insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2024-11-11 08:12:23',5,3,42101,0,200,-7,-1400,1,'O','N'); insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2024-11-11 08:12:23',5,3,42101,0,200,7,1400,2,'I','N'); insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2024-11-11 08:12:23',5,3,42101,0,1000,-1,-1000,1,'O','N'); insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2024-11-11 08:12:23',5,3,42101,0,1000,1,1000,2,'I','N'); insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2024-11-11 08:12:23',5,3,42101,1,0,0,0,1,'O',''); update payCurInventory set curQuantity=0,curAmount=0 where curQuantity<0; 11/11/2024 08:12:37.1586 964 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/11/2024 08:12:38.2873 562 ms. EXEC: insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2024-11-11 08:12:30',5,3,42101,0,50,-6,-300,2,'O','N'); insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2024-11-11 08:12:30',5,3,42101,0,100,-47,-4700,2,'O','N'); insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2024-11-11 08:12:30',5,3,42101,0,200,-7,-1400,2,'O','N'); insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2024-11-11 08:12:30',5,3,42101,0,1000,-1,-1000,2,'O','N'); insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2024-11-11 08:12:30',5,3,42101,1,0,0,0,2,'O',''); update payCurInventory set curQuantity=0,curAmount=0 where curQuantity<0; 11/11/2024 08:13:09.9995 713 ms. EXECSCALAR: select count(*) from information_schema.tables where table_schema= 'wisepark_0327' and table_name= 'payInvoiceFtp' nr: 1 11/11/2024 08:13:10.0745 641 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 11/11/2024 08:15:32.8696 657 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 11/11/2024 08:15:37.2706 1006 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 11/11/2024 08:17:00.0117 1420 ms. EXEC: insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2024-11-11 08:16:52',5,3,42101,0,50,14,700,1,'I','N'); update payCurInventory set curQuantity=round(curQuantity+14,5),curAmount=round(curAmount+700,5) where curTerId = 3 and curDevCode = 42101 and curChannelId = 1 and curValue = 50 and curType = 'N'; insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2024-11-11 08:16:52',5,3,42101,0,100,3,300,1,'I','N'); update payCurInventory set curQuantity=round(curQuantity+3,5),curAmount=round(curAmount+300,5) where curTerId = 3 and curDevCode = 42101 and curChannelId = 1 and curValue = 100 and curType = 'N'; update payCurInventory set curQuantity=0,curAmount=0 where curQuantity<0; 11/11/2024 08:17:41.1041 733 ms. OPEN: select terDefaultClass from tabTerminal where terStatus='V' and terId = 16 11/11/2024 08:17:42.0507 604 ms. EXEC: insert into movtransit (traUseId,traCreation,traStatus,traUID,traYear,traDateTime,traCode,traType,traClass,traIdTerminal,traDirection,traPlate,traEnabled,traDisableTime,traAreId,traNotes,traBadge,traCarId,traTarId) VALUES (0,'2024-11-11 08:17:41','V',4653330417445750,2024,'2024-11-11 08:17:36','456052985600327005012999',1,2,16,'I','',1,0,1,'','0230003939767',156,0) 11/11/2024 08:17:42.7151 637 ms. EXEC: update abbCards set carLastDate = '2024-11-11 08:17:42',carLastDirection='I' where carStatus='V' and carId = 156 11/11/2024 08:17:44.4313 1712 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 11/11/2024 08:19:03.2378 910 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 11/11/2024 08:20:31.1213 827 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2024-11-11 08:20:30' where traUID = 5542701950817870 and traStatus='V' and traEnabled=1 11/11/2024 08:20:36.4979 592 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 11/11/2024 08:22:24.1636 532 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/11/2024 08:22:36.8931 1116 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2024-11-11 08:22:35' where payTraUID = 5085172498821490 and payStatus='V' and payEnabled=1 11/11/2024 08:22:46.6066 919 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 11/11/2024 08:23:16.4344 1834 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/11/2024 08:27:50.9923 882 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/11/2024 08:30:38.6410 512 ms. EXEC: insert into movtransit (traUseId,traCreation,traStatus,traUID,traYear,traDateTime,traCode,traType,traClass,traIdTerminal,traDirection,traPlate,traEnabled,traDisableTime,traAreId,traNotes,traBadge,traTarId) VALUES (0,'2024-11-11 08:30:38','V',5416873356860370,2024,'2024-11-11 08:30:37','456053063700327001012999',1,2,1,'I','',1,0,1,'','',4) 11/11/2024 08:32:11.6100 583 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 11/11/2024 08:34:34.4871 2074 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 11/11/2024 08:48:27.4950 672 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 11/11/2024 08:49:55.1654 578 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 11/11/2024 08:50:13.4136 568 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 11/11/2024 08:50:26.8966 530 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 1 OR lnsTerId=1) 11/11/2024 09:04:58.2991 633 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 11/11/2024 09:06:41.6039 641 ms. EXEC: update abbCards set carLastDate = '2024-11-11 09:06:40',carLastDirection='I' where carStatus='V' and carId = 17 11/11/2024 09:10:48.9937 588 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 11/11/2024 09:12:59.5336 2482 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/11/2024 09:13:15.7975 836 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/11/2024 09:15:16.2767 539 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 11/11/2024 09:17:30.0518 634 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 11/11/2024 09:17:59.9528 672 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 11/11/2024 09:19:36.8403 2712 ms. EXECSCALAR: select count(parId) from tabParameters where parFiscalPrinter <> 0 and parStatus='V' nr: 0 11/11/2024 09:19:38.8236 928 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2024-11-11 09:19:37' where traUID = 5357408560632050 and traStatus='V' and traEnabled=1 11/11/2024 09:19:43.1885 1634 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 11/11/2024 09:19:53.4394 898 ms. EXEC: insert into movtransit (traUseId,traCreation,traStatus,traUID,traYear,traDateTime,traCode,traType,traClass,traIdTerminal,traDirection,traPlate,traEnabled,traDisableTime,traAreId,traNotes,traBadge,traTarId) VALUES (0,'2024-11-11 09:19:52','V',4676612069290990,2024,'2024-11-11 09:19:50','456053359000327005012999',1,2,16,'I','',1,0,1,'','',4) 11/11/2024 09:20:24.1048 592 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/11/2024 09:22:55.9139 589 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/11/2024 09:31:18.9760 1617 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/11/2024 09:32:24.2015 713 ms. EXEC: update paycash set casCreation = '2024-11-11 09:32:23',casModify = '2024-11-11 09:32:23',casUseId=0,casStatus='V' where casId = 194327 11/11/2024 09:32:25.5784 937 ms. EXEC: update payInventory set invCreation = '2024-11-11 09:32:24',invModify = '2024-11-11 09:32:24',invUseId=0,invStatus='V' where invId = 218576 11/11/2024 09:34:03.9970 1449 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/11/2024 09:34:33.5647 957 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/11/2024 09:36:04.2381 1493 ms. OPEN: select * from tabArea where areStatus='V' and areEnabled = 1 AND areId = 1 11/11/2024 09:37:24.7347 891 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 16 OR lnsTerId=16) 11/11/2024 09:41:01.2679 626 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 11/11/2024 09:42:26.3936 1230 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/11/2024 09:43:38.3095 559 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/11/2024 09:44:44.5126 645 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2024-11-11 09:44:43',3,42101,0,200,1,200,1,'I','N'); update payCurInventory set curQuantity=round(curQuantity+1,5),curAmount=round(curAmount+200,5) where curTerId = 3 and curDevCode = 42101 and curChannelId = 1 and curValue = 200 and curType = 'N'; 11/11/2024 09:46:21.8315 620 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 11/11/2024 09:49:07.8190 599 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/11/2024 09:51:37.2826 539 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/11/2024 09:51:55.2246 596 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/11/2024 09:52:44.7716 857 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 11/11/2024 09:57:20.9846 676 ms. EXEC: insert into movtransit (traUseId,traCreation,traStatus,traUID,traYear,traDateTime,traCode,traType,traClass,traIdTerminal,traDirection,traPlate,traEnabled,traDisableTime,traAreId,traNotes,traBadge,traTarId) VALUES (0,'2024-11-11 09:57:20','V',5174769488847350,2024,'2024-11-11 09:57:17','456053583700327005012999',1,2,16,'I','',1,0,1,'','',4) 11/11/2024 10:00:20.3190 608 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 11/11/2024 10:00:37.6366 742 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 11/11/2024 10:02:52.1101 1402 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 11/11/2024 10:03:10.0461 846 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/11/2024 10:03:30.5738 709 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 11/11/2024 10:04:12.2265 591 ms. OPEN: select * from tabArea where areStatus='V' and areEnabled = 1 AND areId = 1 11/11/2024 10:04:54.6438 915 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 11/11/2024 10:04:55.3002 655 ms. OPEN: select * from tabTerminal where terId = 16 11/11/2024 10:05:04.4803 581 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 11/11/2024 10:05:04.6444 708 ms. EXECSCALAR: select count(*) from information_schema.tables where table_schema= 'wisepark_0327' and table_name= 'payInvoiceFtp' nr: 1 11/11/2024 10:06:14.5920 1532 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/11/2024 10:09:11.2717 547 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/11/2024 10:14:21.8856 568 ms. EXEC: INSERT INTO movOperator (opeCreation,opeUseId,opeTerId,opeDateTime,opeCode,opeDescription) VALUES ('2024-11-11 10:14:21',0,16,'2024-11-11 10:14:21','','Unauthorized Transit Entry 2') 11/11/2024 10:15:00.4003 591 ms. EXEC: insert into movtransit (traUseId,traCreation,traStatus,traUID,traYear,traDateTime,traCode,traType,traClass,traIdTerminal,traDirection,traPlate,traEnabled,traDisableTime,traAreId,traNotes,traBadge,traTarId) VALUES (0,'2024-11-11 10:14:59','V',4853183490848930,2024,'2024-11-11 10:14:59','456053583700327005012999',2,2,2,'O','',0,'2024-11-11 10:14:59',1,'','',0) 11/11/2024 10:15:01.4190 989 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 11/11/2024 10:15:24.2252 1334 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/11/2024 10:16:12.7585 658 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 11/11/2024 10:16:31.6221 733 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/11/2024 10:17:36.1240 1061 ms. EXEC: insert into payReceipt (recTraUID,recPayUID,recYear,recDateTime,recText,recInvalid) VALUES (5013416698852320,5752684202463850,2024,'2024-11-11 10:17:35',' Date: 11/11/2024 10:17:34 AM Code: 456053187700327005012999 Entry Date: 11/11/2024 8:51:17 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 # 2400749218 ',0) 11/11/2024 10:18:29.0733 672 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 11/11/2024 10:18:54.9195 819 ms. EXEC: insert into movtransit (traUseId,traCreation,traStatus,traUID,traYear,traDateTime,traCode,traType,traClass,traIdTerminal,traDirection,traPlate,traEnabled,traDisableTime,traAreId,traNotes,traBadge,traTarId) VALUES (0,'2024-11-11 10:18:54','V',5570331959754360,2024,'2024-11-11 10:18:52','456053572400327001012999',2,2,2,'O','',0,'2024-11-11 10:18:54',1,'','',0) 11/11/2024 10:20:06.9835 669 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/11/2024 10:20:19.4038 1788 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/11/2024 10:20:30.9975 521 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 11/11/2024 10:20:53.4425 1597 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/11/2024 10:21:04.1036 506 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 11/11/2024 10:21:19.6129 1732 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/11/2024 10:22:55.6499 711 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 11/11/2024 10:28:28.2945 892 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/11/2024 10:36:19.7716 873 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 11/11/2024 10:36:24.9630 569 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 2 OR lnsTerId=2) 11/11/2024 10:40:58.0880 1038 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2024-11-11 10:40:56' where traUID = 5043876485442600 and traStatus='V' and traEnabled=1 11/11/2024 10:41:01.7894 613 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 11/11/2024 10:45:23.2906 1721 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 11/11/2024 10:45:24.7556 927 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2024-11-11 10:45:23' where traUID = 5106707072825250 and traStatus='V' and traEnabled=1 11/11/2024 10:47:00.3603 654 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/11/2024 10:47:49.3179 663 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/11/2024 10:50:47.8328 1010 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 2 OR lnsTerId=2) 11/11/2024 10:50:47.8438 643 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/11/2024 10:52:15.4912 846 ms. EXEC: insert into movtransit (traUseId,traCreation,traStatus,traUID,traYear,traDateTime,traCode,traType,traClass,traIdTerminal,traDirection,traPlate,traEnabled,traDisableTime,traAreId,traNotes,traBadge,traCarId,traTarId) VALUES (0,'2024-11-11 10:52:14','V',5120227650639700,2024,'2024-11-11 10:52:13','456053486600327005012999',2,2,2,'O','',0,'2024-11-11 10:52:14',1,'','0230003944064',14,0) 11/11/2024 10:52:16.2807 786 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 11/11/2024 10:52:18.9345 515 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 11/11/2024 10:53:42.9865 856 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 2 and terStatus='V' 11/11/2024 10:55:09.5802 859 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/11/2024 11:02:40.0963 1782 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/11/2024 11:04:01.7967 547 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/11/2024 11:04:51.1556 597 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 11/11/2024 11:05:10.4905 789 ms. EXECSCALAR: SELECT traId FROM movTransit WHERE traStatus='V' AND traCode = @traCode nr: 774706 11/11/2024 11:05:10.4915 1773 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 2 OR lnsTerId=2) 11/11/2024 11:05:14.2029 3599 ms. EXEC: insert into movtransit (traUseId,traCreation,traStatus,traUID,traYear,traDateTime,traCode,traType,traClass,traIdTerminal,traDirection,traPlate,traEnabled,traDisableTime,traAreId,traNotes,traBadge,traTarId) VALUES (0,'2024-11-11 11:05:10','V',5740680915595620,2024,'2024-11-11 11:05:08','456053779000327005012999',2,2,2,'O','',0,'2024-11-11 11:05:10',1,'','',0) 11/11/2024 11:05:15.0745 564 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 11/11/2024 11:06:10.8927 1618 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2024-11-11 11:06:09' where payTraUID = 5095059415416780 and payStatus='V' and payEnabled=1 11/11/2024 11:10:14.2838 1299 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/11/2024 11:12:01.5253 828 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 11/11/2024 11:13:20.5980 545 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 11/11/2024 11:13:58.3051 1369 ms. EXEC: update tabTerminalReceipt set trcProgressive = 15951, trcLastPrinted = '2400415951', trcLastDate = '2024-11-11 11:13:56' where trcStatus='V' and trcTerId = 4 11/11/2024 11:15:21.5775 580 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 11/11/2024 11:16:24.5895 508 ms. EXEC: insert into payPayment (payCreation,payUseId,payStatus,payUID,payTraUID,payYear,payDateTime,payIdTerminal,payEnabled,payDisableTime,payTarId,payTimeLimit,payType,payCurrency,payAmount,payPayed,payChange,payCardType,payPAN,paySTAN,payIdEvent,payAmountCalc,payDiscountValue,payDiscount,payDiscountType,payVatPercent,payVatAmount) VALUES ('2024-11-11 11:14:02',9,'V',4899001242256740,5434446950573770,2024,'2024-11-11 11:14:02',4,1,0,4,'2024-11-11 11:29:02','P','KES',50,50,0,'','','',1,50,0,0,'',0,0) 11/11/2024 11:18:19.6762 549 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 11/11/2024 11:18:20.4457 740 ms. EXEC: UPDATE payInventory SET invType='N' WHERE invType<>'N' AND invValue IN (100,200,500) AND invDevice IN (42102,42101,42001); 11/11/2024 11:28:03.8633 542 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/11/2024 11:29:23.2392 675 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/11/2024 11:29:34.8840 716 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2024-11-11 11:29:33' where traUID = 4698029070978950 and traStatus='V' and traEnabled=1 11/11/2024 11:29:41.6185 662 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 11/11/2024 11:30:36.7072 624 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 11/11/2024 11:30:54.7372 1806 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/11/2024 11:31:33.1648 967 ms. EXEC: insert into movtransit (traUseId,traCreation,traStatus,traUID,traYear,traDateTime,traCode,traType,traClass,traIdTerminal,traDirection,traPlate,traEnabled,traDisableTime,traAreId,traNotes,traBadge,traTarId) VALUES (0,'2024-11-11 11:31:32','V',5759626705441650,2024,'2024-11-11 11:31:31','456054149100327005012999',1,2,16,'I','',1,0,1,'','',4) 11/11/2024 11:31:39.2918 550 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/11/2024 11:31:55.3285 549 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 11/11/2024 11:32:34.9029 1496 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/11/2024 11:32:47.5383 1336 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 11/11/2024 11:33:09.4179 602 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 3 11/11/2024 11:34:11.7004 1644 ms. OPEN: select * from payCurInventory where curTerId = 3 and curQuantity>0 and curType in ('C','N') order by curDevCode,curChannelId,curValue 11/11/2024 11:34:45.7981 763 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/11/2024 11:35:17.3281 1426 ms. OPEN: select count(payId) as Tot,0 as payUID,sum(payPayed) as payPayed,sum(payChange) as payChange,payAmount,traUIDGroup,traType,traClass,traIdTerminal,traDiscountValue,traDiscountType,traCarId,payIdEvent,payType,payCardType from payPayment LEFT join movtransit on trauid = payTraUID LEFT JOIN payReport ON repPayUID = payUID AND repStatus='V' where payStatus = 'V' and (payType='C' or payType='P') and payUseId = 12 and payIdEvent<90 and repPayUID IS NULL and (traCarId is null or traCarId=0 or traCarId in (select carId from abbCards inner join abbsubscriptions on subId= carSubId where carStatus='V' and subStatus='V' and subAbbType<>5)) group by traUIDGroup,payAmount,payIdEvent,payType,payCardType,traType,traIdTerminal,traDiscountValue,traDiscountType,traCarId order by traUIDGroup,payAmount, traType, traDiscountValue, traDiscountType 11/11/2024 11:36:19.6926 1381 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/11/2024 11:37:16.7587 712 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 11/11/2024 11:37:57.5498 747 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/11/2024 11:39:08.8583 1303 ms. OPEN: select * from tabArea where areStatus='V' and areEnabled = 1 AND areId = 1 11/11/2024 11:39:09.4687 569 ms. EXECSCALAR: select count(*) from tabTerminalExtraMem where extStatus='V' and extTerId = 16 nr: 1 11/11/2024 11:39:33.4007 801 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/11/2024 11:39:38.5641 1812 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/11/2024 11:39:54.4437 691 ms. EXEC: insert into movtransit (traUseId,traCreation,traStatus,traUID,traYear,traDateTime,traCode,traType,traClass,traIdTerminal,traDirection,traPlate,traEnabled,traDisableTime,traAreId,traNotes,traBadge,traTarId) VALUES (0,'2024-11-11 11:39:53','V',5287248407300690,2024,'2024-11-11 11:39:52','456054199200327005012999',1,2,16,'I','',1,0,1,'','',4) 11/11/2024 11:41:15.8359 628 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 2 OR lnsTerId=2) 11/11/2024 11:42:16.6634 875 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2024-11-11 11:42:15',3,42101,0,100,1,100,1,'I','N'); update payCurInventory set curQuantity=round(curQuantity+1,5),curAmount=round(curAmount+100,5) where curTerId = 3 and curDevCode = 42101 and curChannelId = 1 and curValue = 100 and curType = 'N'; 11/11/2024 11:43:46.2611 520 ms. EXEC: insert into movtransit (traUseId,traCreation,traStatus,traUID,traYear,traDateTime,traCode,traType,traClass,traIdTerminal,traDirection,traPlate,traEnabled,traDisableTime,traAreId,traNotes,traBadge,traTarId) VALUES (0,'2024-11-11 11:43:45','V',4708338956625380,2024,'2024-11-11 11:43:45','456053926900327005012999',2,2,2,'O','',0,'2024-11-11 11:43:45',1,'','',0) 11/11/2024 11:44:33.2254 579 ms. EXEC: insert into movOperator (opeCreation,opeTerId,opeUseId,opeDateTime,opeCode,opeDescription) VALUES ('2024-11-11 11:44:32',4,9,'2024-11-11 11:44:32','456053692000327005012999','Payed (Credit Card ) Ticket ') 11/11/2024 11:45:17.7341 641 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/11/2024 11:45:49.5643 846 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/11/2024 11:45:49.8625 623 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2024-11-11 11:45:48',3,42101,0,50,-1,-50,1,'O','N'); update payCurInventory set curQuantity=round(curQuantity+-1,5),curAmount=round(curAmount+-50,5) where curTerId = 3 and curDevCode = 42101 and curChannelId = 1 and curValue = 50 and curType = 'N'; Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2024-11-11 11:45:48',3,42101,0,100,-1,-100,1,'O','N'); update payCurInventory set curQuantity=round(curQuantity+-1,5),curAmount=round(curAmount+-100,5) where curTerId = 3 and curDevCode = 42101 and curChannelId = 1 and curValue = 100 and curType = 'N'; 11/11/2024 11:46:33.7447 879 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2024-11-11 11:46:32' where payTraUID = 4915315886474740 and payStatus='V' and payEnabled=1 11/11/2024 11:46:37.7604 756 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 11/11/2024 11:47:18.3404 893 ms. EXEC: insert into movtransit (traUseId,traCreation,traStatus,traUID,traYear,traDateTime,traCode,traType,traClass,traIdTerminal,traDirection,traPlate,traEnabled,traDisableTime,traAreId,traNotes,traBadge,traTarId) VALUES (0,'2024-11-11 11:47:17','V',5408104234002940,2024,'2024-11-11 11:47:16','456054053800327001012999',2,2,2,'O','',0,'2024-11-11 11:47:17',1,'','',0) 11/11/2024 11:47:20.9601 2008 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) (WAIT TIME 608 ms.) 11/11/2024 11:52:56.6388 1096 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/11/2024 11:57:57.3661 1807 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/11/2024 11:58:06.2370 605 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/11/2024 11:59:15.8854 1125 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/11/2024 11:59:57.8553 1081 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/11/2024 12:00:18.9434 1491 ms. EXEC: insert into payPayment (payCreation,payUseId,payStatus,payUID,payTraUID,payYear,payDateTime,payIdTerminal,payEnabled,payDisableTime,payTarId,payTimeLimit,payType,payCurrency,payAmount,payPayed,payChange,payCardType,payPAN,paySTAN,payIdEvent,payAmountCalc,payDiscountValue,payDiscount,payDiscountType,payVatPercent,payVatAmount) VALUES ('2024-11-11 11:57:56',9,'V',5083130322069350,5461265187203100,2024,'2024-11-11 11:57:56',4,1,0,4,'2024-11-11 12:12:56','P','KES',100,100,0,'','','',1,100,0,0,'',0,0) 11/11/2024 12:00:19.6258 529 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/11/2024 12:00:21.2139 1062 ms. EXEC: update tabTerminalReceipt set trcProgressive = 15957, trcLastPrinted = '2400415957', trcLastDate = '2024-11-11 12:00:19' where trcStatus='V' and trcTerId = 4 11/11/2024 12:00:23.2623 2044 ms. EXEC: insert into payReceipt (recTraUID,recPayUID,recYear,recDateTime,recText,recInvalid) VALUES (5461265187203100,5083130322069350,2024,'2024-11-11 12:00:21',' Date: 11/11/2024 11:57:56 AM Code: 456053585900327005012999 Entry Date: 11/11/2024 9:57:39 AM Plate: Class: Cars Park: The Mall Gate: Entry 2 ______________________________ Total: 100.00 KES ______________________________ Paid: 100.00 KES __________ Change: 0.00 KES Type: Credit Card Dispozitiv: Manual Cashier 1 # 2400415957 ',0) 11/11/2024 12:00:34.5738 610 ms. EXEC: insert into movtransit (traUseId,traCreation,traStatus,traUID,traYear,traDateTime,traCode,traType,traClass,traIdTerminal,traDirection,traPlate,traEnabled,traDisableTime,traAreId,traNotes,traBadge,traCarId,traTarId) VALUES (0,'2024-11-11 12:00:33','V',5714129789206690,2024,'2024-11-11 12:00:33','456054323300327005012999',1,2,16,'I','',1,0,1,'','0230004098567',165,0) 11/11/2024 12:00:35.3083 725 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 11/11/2024 12:00:52.6679 1453 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/11/2024 12:01:02.6275 642 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 11/11/2024 12:01:22.5438 1161 ms. EXEC: insert into movtransit (traUseId,traCreation,traStatus,traUID,traYear,traDateTime,traCode,traType,traClass,traIdTerminal,traDirection,traPlate,traEnabled,traDisableTime,traAreId,traNotes,traBadge,traTarId) VALUES (0,'2024-11-11 12:01:21','V',5102559665225990,2024,'2024-11-11 12:01:20','456054328000327005012999',1,2,16,'I','',1,0,1,'','',4) 11/11/2024 12:01:23.1091 557 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 11/11/2024 12:02:04.6818 509 ms. EXEC: update opeActivities set acvFstPayId = (case acvFstPayId when 0 then 369906 else acvFstPayId end),acvLstPayId = 369906 where acvSftId = 824 and acvCodeId = 3 11/11/2024 12:02:23.0210 703 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 11/11/2024 12:02:24.4650 1125 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2024-11-11 12:02:23' where traUID = 5262042896120860 and traStatus='V' and traEnabled=1 11/11/2024 12:02:43.8229 576 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2024-11-11 12:02:43' where traUID = 4755420838374930 and traStatus='V' and traEnabled=1 11/11/2024 12:02:50.0981 629 ms. OPEN: select * from tabArea where areStatus='V' and areEnabled = 1 AND areId = 1 11/11/2024 12:05:45.0596 818 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/11/2024 12:05:58.0363 937 ms. EXEC: insert into movtransit (traUseId,traCreation,traStatus,traUID,traYear,traDateTime,traCode,traType,traClass,traIdTerminal,traDirection,traPlate,traEnabled,traDisableTime,traAreId,traNotes,traBadge,traTarId) VALUES (0,'2024-11-11 12:05:57','V',5373372392065090,2024,'2024-11-11 12:05:56','456054279900327001012999',2,2,2,'O','',0,'2024-11-11 12:05:57',1,'','',0) 11/11/2024 12:05:59.1850 574 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2024-11-11 12:05:58' where payTraUID = 5273649614234050 and payStatus='V' and payEnabled=1 11/11/2024 12:05:59.9185 733 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2024-11-11 12:05:58' where traUID = 5273649614234050 and traStatus='V' and traEnabled=1 11/11/2024 12:06:02.9746 593 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 11/11/2024 12:08:46.9428 1050 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 16 OR lnsTerId=16) 11/11/2024 12:10:01.7746 942 ms. EXEC: insert into abbPayment (payCreation,payCode,payAmount,payCredit,payPayUID,payCarId,payDateFrom,payDateTo) VALUES ('2024-11-11 12:10:00','0810007145851',0,0,5678277045181720,106,'0000-00-00 00:00:00','0000-00-00 00:00:00') 11/11/2024 12:10:07.1152 535 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 11/11/2024 12:10:52.9567 578 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 11/11/2024 12:12:48.2215 1102 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/11/2024 12:13:02.1278 1503 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/11/2024 12:16:48.9359 843 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/11/2024 12:17:57.7057 739 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/11/2024 12:20:43.6823 1028 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/11/2024 12:23:40.2269 630 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/11/2024 12:24:20.4817 939 ms. EXEC: insert into movtransit (traUseId,traCreation,traStatus,traUID,traYear,traDateTime,traCode,traType,traClass,traIdTerminal,traDirection,traPlate,traEnabled,traDisableTime,traAreId,traNotes,traBadge,traCarId,traTarId) VALUES (0,'2024-11-11 12:24:19','V',5378511750359900,2024,'2024-11-11 12:24:17','456054465700327001012999',1,2,1,'I','',1,0,1,'','0230003944081',15,0) 11/11/2024 12:26:10.8882 535 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 11/11/2024 12:26:40.8342 921 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2024-11-11 12:26:39',3,42101,0,50,1,50,1,'I','N'); update payCurInventory set curQuantity=round(curQuantity+1,5),curAmount=round(curAmount+50,5) where curTerId = 3 and curDevCode = 42101 and curChannelId = 1 and curValue = 50 and curType = 'N'; 11/11/2024 12:26:41.3815 536 ms. EXEC: update payInventory set invCreation = '2024-11-11 12:26:40',invModify = '2024-11-11 12:26:40',invUseId=0,invStatus='V' where invId = 218603 11/11/2024 12:26:45.0530 2912 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 5 11/11/2024 12:27:12.1610 706 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 2 OR lnsTerId=2) 11/11/2024 12:27:21.2221 509 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/11/2024 12:27:33.4692 3189 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/11/2024 12:28:04.0446 541 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/11/2024 12:28:23.8048 870 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 11/11/2024 12:29:11.5546 684 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2024-11-11 12:29:09' where traUID = 4636805546026030 and traStatus='V' and traEnabled=1 11/11/2024 12:29:11.6897 1770 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/11/2024 12:29:12.1940 623 ms. EXEC: delete from movRoutes where rtsStatus = 'V' and rtsEnabled = 1 and rtsCode = '456054342900327001012999' 11/11/2024 12:29:20.2113 676 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 11/11/2024 12:29:39.7934 800 ms. EXEC: insert into movBarrier (barUseId,barCreation,barTerId,barAction,barDescription,barPlate) VALUES (1,'2024-11-11 12:29:38',9999,'open','Send command to entry/exit units: Command OPEN on Device Exit 1 ','') 11/11/2024 12:33:12.3049 2011 ms. EXEC: insert into movtransit (traUseId,traCreation,traStatus,traUID,traYear,traDateTime,traCode,traType,traClass,traIdTerminal,traDirection,traPlate,traEnabled,traDisableTime,traAreId,traNotes,traBadge,traTarId) VALUES (0,'2024-11-11 12:33:10','V',4805328030678850,2024,'2024-11-11 12:33:08','456054141400327005012999',2,2,2,'O','',0,'2024-11-11 12:33:10',1,'','',0) 11/11/2024 12:33:13.4497 1136 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 11/11/2024 12:33:19.7439 546 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 11/11/2024 12:33:22.4337 2657 ms. EXEC: UPDATE payInventory SET invType='N' WHERE invType<>'N' AND invValue IN (100,200,500) AND invDevice IN (42102,42101,42001); 11/11/2024 12:33:41.9747 525 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 11/11/2024 12:34:04.6318 622 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/11/2024 12:34:24.7212 558 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/11/2024 12:34:44.5024 616 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/11/2024 12:35:10.3876 563 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/11/2024 12:38:34.5966 796 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 11/11/2024 12:38:41.7464 1444 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 11/11/2024 12:39:10.9569 1015 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 11/11/2024 12:41:58.8557 752 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 11/11/2024 12:43:01.5225 1029 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 16 OR lnsTerId=16) 11/11/2024 12:43:18.0034 520 ms. EXEC: insert into movtransit (traUseId,traCreation,traStatus,traUID,traYear,traDateTime,traCode,traType,traClass,traIdTerminal,traDirection,traPlate,traEnabled,traDisableTime,traAreId,traNotes,traBadge,traTarId) VALUES (0,'2024-11-11 12:43:17','V',5066963118767950,2024,'2024-11-11 12:43:16','456054579600327005012999',1,2,16,'I','',1,0,1,'','',4) 11/11/2024 12:43:39.5518 718 ms. EXEC: insert into movtransit (traUseId,traCreation,traStatus,traUID,traYear,traDateTime,traCode,traType,traClass,traIdTerminal,traDirection,traPlate,traEnabled,traDisableTime,traAreId,traNotes,traBadge,traTarId) VALUES (0,'2024-11-11 12:43:38','V',5016942152594440,2024,'2024-11-11 12:43:37','456054581700327005012999',1,2,16,'I','',1,0,1,'','',4) 11/11/2024 12:44:05.9394 560 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 5 11/11/2024 12:44:31.1301 520 ms. EXEC: insert into movtransit (traUseId,traCreation,traStatus,traUID,traYear,traDateTime,traCode,traType,traClass,traIdTerminal,traDirection,traPlate,traEnabled,traDisableTime,traAreId,traNotes,traBadge,traTarId) VALUES (0,'2024-11-11 12:44:30','V',4840082725515460,2024,'2024-11-11 12:44:30','456054587000327005012999',1,2,16,'I','',1,0,1,'','',4) 11/11/2024 12:45:21.3856 3287 ms. EXEC: insert into payPayment (payCreation,payUseId,payStatus,payUID,payTraUID,payYear,payDateTime,payIdTerminal,payEnabled,payDisableTime,payTarId,payTimeLimit,payType,payCurrency,payAmount,payPayed,payChange,payCardType,payPAN,paySTAN,payIdEvent,payAmountCalc,payDiscountValue,payDiscount,payDiscountType,payVatPercent,payVatAmount) VALUES ('2024-11-11 12:45:18',0,'V',5025921833921260,5102559665225990,2024,'2024-11-11 12:45:18',18,1,0,4,'2024-11-11 13:00:18','C','KES',50,50,0,'','','',1,50,0,0,'',0,0) 11/11/2024 12:45:28.2572 509 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 11/11/2024 12:45:39.2365 677 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 11/11/2024 12:45:49.1171 2447 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/11/2024 12:47:31.6804 1314 ms. EXEC: insert into movtransit (traUseId,traCreation,traStatus,traUID,traYear,traDateTime,traCode,traType,traClass,traIdTerminal,traDirection,traPlate,traEnabled,traDisableTime,traAreId,traNotes,traBadge,traTarId) VALUES (0,'2024-11-11 12:47:30','V',5064784040400820,2024,'2024-11-11 12:47:28','456054604800327005012999',1,2,16,'I','',1,0,1,'','',4) 11/11/2024 12:47:47.4659 544 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/11/2024 12:48:46.7154 6735 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 5 11/11/2024 12:48:58.4482 1716 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/11/2024 12:49:36.7127 1048 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/11/2024 12:49:55.8314 919 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/11/2024 12:50:43.8945 1000 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/11/2024 12:51:25.5442 812 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 16 OR lnsTerId=16) 11/11/2024 12:51:32.0776 1254 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 5 and terStatus='V' 11/11/2024 12:51:38.7820 1737 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/11/2024 12:52:31.6412 2520 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 6 11/11/2024 12:52:58.3190 3571 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/11/2024 12:53:34.6772 512 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2024-11-11 12:53:34',3,42101,0,100,1,100,1,'I','N'); update payCurInventory set curQuantity=round(curQuantity+1,5),curAmount=round(curAmount+100,5) where curTerId = 3 and curDevCode = 42101 and curChannelId = 1 and curValue = 100 and curType = 'N'; 11/11/2024 12:53:35.5378 616 ms. EXEC: insert into paycash (casCreation,casModify,casUseId,casStatus,casUID,casTraUID,casYear,casDateTime,casIdTerminal,casCurrency,casNumber,casSingleAmount,casTotAmount,casType,casDescription) VALUES ('2024-11-11 12:53:34',0,0,'V',5436917493799900,5503494427976910,2024,'2024-11-11 12:53:34',3,'KES',-1,50,-50,'N',''); 11/11/2024 12:53:51.3413 2475 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/11/2024 12:53:58.2139 609 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 11/11/2024 12:54:11.2416 662 ms. EXEC: insert into payPayment (payCreation,payUseId,payStatus,payUID,payTraUID,payYear,payDateTime,payIdTerminal,payEnabled,payDisableTime,payTarId,payTimeLimit,payType,payCurrency,payAmount,payPayed,payChange,payCardType,payPAN,paySTAN,payIdEvent,payAmountCalc,payDiscountValue,payDiscount,payDiscountType,payVatPercent,payVatAmount) VALUES ('2024-11-11 12:54:08',0,'V',5607307780787490,5407866838052710,2024,'2024-11-11 12:54:08',3,1,0,4,'2024-11-11 13:09:08','C','KES',100,100,0,'',' ',' ',1,100,0,0,'',0,0) 11/11/2024 12:54:33.5885 3228 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/11/2024 12:54:38.2216 1562 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/11/2024 12:54:48.5855 2651 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/11/2024 12:54:59.1625 4398 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/11/2024 12:55:01.4851 769 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/11/2024 12:55:06.7576 1222 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/11/2024 12:55:10.6001 1135 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/11/2024 12:55:33.7225 1584 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/11/2024 12:56:11.5117 4718 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/11/2024 12:57:54.5173 2316 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/11/2024 12:58:16.9052 740 ms. EXEC: insert into movtransit (traUseId,traCreation,traStatus,traUID,traYear,traDateTime,traCode,traType,traClass,traIdTerminal,traDirection,traPlate,traEnabled,traDisableTime,traAreId,traNotes,traBadge,traTarId) VALUES (0,'2024-11-11 12:58:16','V',5518836394070890,2024,'2024-11-11 12:58:14','456054189000327001012999',2,2,2,'O','',0,'2024-11-11 12:58:16',1,'','',0) 11/11/2024 12:58:26.2244 607 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 11/11/2024 12:59:29.7878 606 ms. EXEC: insert into paycash (casCreation,casModify,casUseId,casStatus,casUID,casTraUID,casYear,casDateTime,casIdTerminal,casCurrency,casNumber,casSingleAmount,casTotAmount,casType,casDescription) VALUES ('2024-11-11 12:59:28',0,0,'V',4683683163010790,5536185630459400,2024,'2024-11-11 12:59:28',3,'KES',1,50,50,'N',''); 11/11/2024 12:59:58.3818 622 ms. EXEC: update tabTerminalReceipt set trcProgressive = 15962, trcLastPrinted = '2400415962', trcLastDate = '2024-11-11 12:59:57' where trcStatus='V' and trcTerId = 4 11/11/2024 12:59:59.3815 3055 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/11/2024 13:01:37.5939 517 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 4 11/11/2024 13:01:53.3624 4156 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/11/2024 13:01:54.3821 1541 ms. EXECSCALAR: select parReentrySeconds from tabParameters where parStatus='V' order by parId desc limit 1 nr: 0 11/11/2024 13:01:54.8404 1372 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/11/2024 13:02:00.3361 847 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 16 OR lnsTerId=16) 11/11/2024 13:02:33.4942 1340 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/11/2024 13:02:54.6623 2477 ms. EXEC: update tabTerminalReceipt set trcProgressive = 49236, trcLastPrinted = '2400749236', trcLastDate = '2024-11-11 13:02:52' where trcStatus='V' and trcTerId = 18 11/11/2024 13:04:43.3006 2345 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 2 OR lnsTerId=2) 11/11/2024 13:05:44.7426 636 ms. EXEC: UPDATE payInventory SET invType='N' WHERE invType<>'N' AND invValue IN (100,200,500) AND invDevice IN (42102,42101,42001); 11/11/2024 13:07:58.8059 579 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 11/11/2024 13:09:14.6644 543 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/11/2024 13:09:22.7298 1069 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/11/2024 13:10:45.9572 598 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/11/2024 13:13:23.7974 767 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 11/11/2024 13:13:24.4698 631 ms. EXEC: UPDATE payInventory SET invType='N' WHERE invType<>'N' AND invValue IN (100,200,500) AND invDevice IN (42102,42101,42001); 11/11/2024 13:13:56.4111 1580 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 16 OR lnsTerId=16) 11/11/2024 13:14:05.2570 991 ms. EXEC: insert into payReceipt (recTraUID,recPayUID,recYear,recDateTime,recText,recInvalid) VALUES (5600423323764720,5679647384855000,2024,'2024-11-11 13:14:04','---------------------------------- %The Mall P0006032390 End of payment ---------------------------------- POF Entry : 11/11/2024 12:21:41 PM Date : 11/11/2024 1:14:01 PM Code : 456054450100327001012999 Total : 50.00 KES VAT 16% : 6.90 KES ---------------------------------- Paid : 500.00 KES Coin changed : 0.00 KES Note changed : 450.00 KES',0) 11/11/2024 13:14:28.8957 664 ms. EXEC: insert into movtransit (traUseId,traCreation,traStatus,traUID,traYear,traDateTime,traCode,traType,traClass,traIdTerminal,traDirection,traPlate,traEnabled,traDisableTime,traAreId,traNotes,traBadge,traTarId) VALUES (0,'2024-11-11 13:14:28','V',5674949168242850,2024,'2024-11-11 13:14:28','456054467000327005012999',2,2,2,'O','',0,'2024-11-11 13:14:28',1,'','',0) 11/11/2024 13:14:28.9017 1537 ms. EXEC: insert into payPayment (payCreation,payUseId,payStatus,payUID,payTraUID,payYear,payDateTime,payIdTerminal,payEnabled,payDisableTime,payTarId,payTimeLimit,payType,payCurrency,payAmount,payPayed,payChange,payCardType,payPAN,paySTAN,payIdEvent,payAmountCalc,payDiscountValue,payDiscount,payDiscountType,payVatPercent,payVatAmount) VALUES ('2024-11-11 13:14:27',0,'V',5264873069131740,5548495310707460,2024,'2024-11-11 13:14:27',18,1,0,4,'2024-11-11 13:29:27','C','KES',50,50,0,'','','',1,50,0,0,'',0,0) 11/11/2024 13:14:29.5992 686 ms. EXEC: update tabTerminalReceipt set trcProgressive = 49243, trcLastPrinted = '2400749243', trcLastDate = '2024-11-11 13:14:28' where trcStatus='V' and trcTerId = 18 11/11/2024 13:14:29.7943 509 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 11/11/2024 13:14:36.4358 985 ms. EXEC: UPDATE payInventory SET invType='N' WHERE invType<>'N' AND invValue IN (100,200,500) AND invDevice IN (42102,42101,42001); 11/11/2024 13:15:06.8870 647 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 11/11/2024 13:15:07.8507 642 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2024-11-11 13:15:07' where traUID = 5548495310707460 and traStatus='V' and traEnabled=1 11/11/2024 13:15:49.5184 723 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/11/2024 13:17:47.5911 558 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 11/11/2024 13:18:01.2342 2960 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/11/2024 13:19:57.3846 1989 ms. EXEC: update paycash set casCreation = '2024-11-11 13:19:55',casModify = '2024-11-11 13:19:55',casUseId=0,casStatus='V' where casId = 194370 11/11/2024 13:19:57.3856 2131 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2024-11-11 13:19:55' where payTraUID = 5016942152594440 and payStatus='V' and payEnabled=1 11/11/2024 13:19:58.6064 1220 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2024-11-11 13:19:55',3,42101,0,100,1,100,1,'I','N'); update payCurInventory set curQuantity=round(curQuantity+1,5),curAmount=round(curAmount+100,5) where curTerId = 3 and curDevCode = 42101 and curChannelId = 1 and curValue = 100 and curType = 'N'; 11/11/2024 13:20:43.1300 639 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/11/2024 13:21:05.6560 567 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 11/11/2024 13:21:18.5096 622 ms. EXEC: INSERT INTO movOperator (opeCreation,opeUseId,opeTerId,opeDateTime,opeCode,opeDescription) VALUES ('2024-11-11 13:21:17',0,16,'2024-11-11 13:21:17','','Unauthorized Transit Entry 2') 11/11/2024 13:21:39.0493 782 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 16 OR lnsTerId=16) 11/11/2024 13:23:08.0836 592 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/11/2024 13:23:34.0589 2467 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/11/2024 13:23:43.7994 718 ms. EXEC: INSERT INTO movOperator (opeCreation,opeUseId,opeTerId,opeDateTime,opeCode,opeDescription) VALUES ('2024-11-11 13:23:43',0,16,'2024-11-11 13:23:43','','Unauthorized Transit Entry 2') 11/11/2024 13:23:58.2490 549 ms. EXEC: insert into movtransit (traUseId,traCreation,traStatus,traUID,traYear,traDateTime,traCode,traType,traClass,traIdTerminal,traDirection,traPlate,traEnabled,traDisableTime,traAreId,traNotes,traBadge,traTarId) VALUES (0,'2024-11-11 13:23:57','V',5259446974598150,2024,'2024-11-11 13:23:56','456054727300327005012999',2,2,2,'O','',0,'2024-11-11 13:23:57',1,'','',0) 11/11/2024 13:24:04.5202 511 ms. EXEC: UPDATE payInventory SET invType='N' WHERE invType<>'N' AND invValue IN (100,200,500) AND invDevice IN (42102,42101,42001); 11/11/2024 13:24:38.4088 2777 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/11/2024 13:26:32.6509 1173 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/11/2024 13:26:51.7686 1010 ms. EXEC: insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2024-11-11 13:26:50',3,42101,0,50,-1,-50,1,'O','N'); update payCurInventory set curQuantity=round(curQuantity-1,5),curAmount=round(curAmount-50,5) where curTerId = 3 and curDevCode = 42101 and curChannelId = 1 and curValue = 50 and curType = 'N'; insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2024-11-11 13:26:50',3,42101,0,50,1,50,2,'I','N'); update payCurInventory set curQuantity=round(curQuantity+1,5),curAmount=round(curAmount+50,5) where curTerId = 3 and curDevCode = 42101 and curChannelId = 2 and curValue = 50 and curType = 'N'; 11/11/2024 13:30:41.0844 1576 ms. EXEC: update tabTerminalReceipt set trcProgressive = 15964, trcLastPrinted = '2400415964', trcLastDate = '2024-11-11 13:30:39' where trcStatus='V' and trcTerId = 4 11/11/2024 13:31:37.1687 552 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 11/11/2024 13:33:02.8458 577 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/11/2024 13:33:41.2103 876 ms. EXEC: update opeActivities set acvFstPayId = (case acvFstPayId when 0 then 369951 else acvFstPayId end),acvLstPayId = 369951 where acvSftId = 824 and acvCodeId = 3 11/11/2024 13:33:42.2180 858 ms. EXEC: update payReceipt set recCreation = '2024-11-11 13:33:41',recModify = '2024-11-11 13:33:41',recUseId=0,recStatus='V' where recId = 321572 11/11/2024 13:34:08.2754 1361 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/11/2024 13:36:22.5328 564 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/11/2024 13:38:09.8083 550 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 3 OR lnsTerId=3) 11/11/2024 13:38:35.4103 2978 ms. EXEC: insert into movtransit (traUseId,traCreation,traStatus,traUID,traYear,traDateTime,traCode,traType,traClass,traIdTerminal,traDirection,traPlate,traEnabled,traDisableTime,traAreId,traNotes,traBadge,traTarId) VALUES (0,'2024-11-11 13:38:32','V',4870747106015230,2024,'2024-11-11 13:38:28','456054910800327005012999',1,2,16,'I','',1,0,1,'','',4) 11/11/2024 13:39:11.4803 550 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 11/11/2024 13:40:57.9093 692 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); (WAIT TIME 556 ms.) 11/11/2024 13:41:23.8996 517 ms. EXECSCALAR: select count(0) as vTot from tabParameters where parPlateReading<>0 nr: 0 11/11/2024 13:42:26.0720 785 ms. EXEC: update payReceipt set recCreation = '2024-11-11 13:42:25',recModify = '2024-11-11 13:42:25',recUseId=0,recStatus='V' where recId = 321576 11/11/2024 13:45:10.3654 1015 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 11/11/2024 13:47:10.2403 573 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 11/11/2024 13:48:30.3937 549 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/11/2024 13:48:44.0678 530 ms. EXEC: insert into payReceipt (recTraUID,recPayUID,recYear,recDateTime,recText,recInvalid) VALUES (5037194756197260,4760383989808590,2024,'2024-11-11 13:48:43',' Date: 11/11/2024 1:48:43 PM Code: 456054330100327005012999 Entry Date: 11/11/2024 12:01:41 PM Plate: Class: Cars Park: The Mall Gate: Entry 2 ______________________________ Total: 100.00 KES ______________________________ Paid: 100.00 KES __________ Change: 0.00 KES Type: Cash Dispozitiv: MPESA # 2400749249 ',0) 11/11/2024 13:49:51.1285 638 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 11/11/2024 13:51:22.3762 820 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 1 OR lnsTerId=1) 11/11/2024 13:51:50.4489 637 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 11/11/2024 13:54:20.6560 697 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/11/2024 13:56:03.9928 644 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/11/2024 13:56:33.2563 602 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 11/11/2024 13:57:21.8897 1554 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/11/2024 13:59:41.9160 981 ms. EXEC: update payReceipt set recCreation = '2024-11-11 13:59:40',recModify = '2024-11-11 13:59:40',recUseId=0,recStatus='V' where recId = 321586 11/11/2024 14:00:44.1765 657 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 11/11/2024 14:00:44.5097 626 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/11/2024 14:01:03.0821 1072 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 11/11/2024 14:01:26.1024 602 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 11/11/2024 14:04:17.6847 1691 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 11/11/2024 14:05:24.5753 1516 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/11/2024 14:05:39.6443 650 ms. EXEC: insert into movtransit (traUseId,traCreation,traStatus,traUID,traYear,traDateTime,traCode,traType,traClass,traIdTerminal,traDirection,traPlate,traEnabled,traDisableTime,traAreId,traNotes,traBadge,traTarId) VALUES (0,'2024-11-11 14:05:38','V',5449019142891480,2024,'2024-11-11 14:05:38','456055073800327005012999',1,2,16,'I','',1,0,1,'','',4) 11/11/2024 14:05:41.3474 1494 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 11/11/2024 14:06:47.7817 627 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/11/2024 14:07:27.3531 640 ms. EXEC: insert into movtransit (traUseId,traCreation,traStatus,traUID,traYear,traDateTime,traCode,traType,traClass,traIdTerminal,traDirection,traPlate,traEnabled,traDisableTime,traAreId,traNotes,traBadge,traTarId) VALUES (0,'2024-11-11 14:07:26','V',5691094202442960,2024,'2024-11-11 14:07:25','456054910800327005012999',2,2,2,'O','',0,'2024-11-11 14:07:26',1,'','',0) 11/11/2024 14:07:35.4875 531 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 11/11/2024 14:07:46.4568 592 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/11/2024 14:08:47.1872 1174 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/11/2024 14:10:47.1752 1226 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/11/2024 14:11:03.6361 2592 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/11/2024 14:11:27.5030 655 ms. EXECSCALAR: select count(*) from information_schema.tables where table_schema= 'wisepark_0327' and table_name= 'payInvoiceFtp' nr: 1 11/11/2024 14:11:28.7429 507 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); (WAIT TIME 545 ms.) 11/11/2024 14:14:22.4426 618 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 11/11/2024 14:14:31.9049 834 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 2 11/11/2024 14:14:43.1604 1064 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 11/11/2024 14:15:40.5826 535 ms. EXECSCALAR: select count(*) from tabTerminalExtraMem where extStatus='V' and extTerId = @extTerId nr: 1 11/11/2024 14:15:47.8985 706 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 11/11/2024 14:15:47.9856 1088 ms. OPEN: select sum(crc32(terDescription)) as vCheck from tabTerminal 11/11/2024 14:16:01.5786 1895 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/11/2024 14:16:56.2140 1821 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/11/2024 14:18:42.8761 1766 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/11/2024 14:19:29.4941 1488 ms. EXEC: insert into movtransit (traUseId,traCreation,traStatus,traUID,traYear,traDateTime,traCode,traType,traClass,traIdTerminal,traDirection,traPlate,traEnabled,traDisableTime,traAreId,traNotes,traBadge,traTarId) VALUES (0,'2024-11-11 14:19:28','V',5441555639774310,2024,'2024-11-11 14:19:26','456054572900327005012999',2,2,2,'O','',0,'2024-11-11 14:19:28',1,'','',0) 11/11/2024 14:19:36.6709 551 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/11/2024 14:19:39.3637 947 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/11/2024 14:20:05.2489 1070 ms. EXEC: insert into movOperator (opeCreation,opeTerId,opeUseId,opeDateTime,opeCode,opeDescription) VALUES ('2024-11-11 14:20:04',17,12,'2024-11-11 14:20:04','456054914900327005012999','Pagato (Contanti ) Biglietto ') 11/11/2024 14:22:32.1558 2246 ms. EXECSCALAR: select count(*) from information_schema.tables where table_schema= 'wisepark_0327' and table_name= 'payInvoiceFtp' nr: 1 11/11/2024 14:24:34.1961 1350 ms. EXEC: insert into movtransit (traUseId,traCreation,traStatus,traUID,traYear,traDateTime,traCode,traType,traClass,traIdTerminal,traDirection,traPlate,traEnabled,traDisableTime,traAreId,traNotes,traBadge,traCarId,traTarId) VALUES (0,'2024-11-11 14:24:32','V',4931738163479960,2024,'2024-11-11 14:24:30','456055187000327001012999',1,2,1,'I','',1,0,1,'','0230003943530',44,0) 11/11/2024 14:24:34.7915 564 ms. EXEC: update abbCards set carLastDate = '2024-11-11 14:24:34',carLastDirection='I' where carStatus='V' and carId = 44 11/11/2024 14:24:44.8862 645 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 11/11/2024 14:26:35.2868 797 ms. EXEC: insert into payPayment (payCreation,payUseId,payStatus,payUID,payTraUID,payYear,payDateTime,payIdTerminal,payEnabled,payDisableTime,payTarId,payTimeLimit,payType,payCurrency,payAmount,payPayed,payChange,payCardType,payPAN,paySTAN,payIdEvent,payVatPercent,payVatAmount) VALUES ('2024-11-11 14:26:34',0,'V',5002111959083690,5372697859394850,2024,'2024-11-11 14:26:34',2,1,0,-1,'2024-11-11 15:26:34','S','KES',0,0,0,'','','',3,0,0) 11/11/2024 14:26:36.6166 703 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 11/11/2024 14:27:03.6777 2808 ms. EXEC: insert into movtransit (traUseId,traCreation,traStatus,traUID,traYear,traDateTime,traCode,traType,traClass,traIdTerminal,traDirection,traPlate,traEnabled,traDisableTime,traAreId,traNotes,traBadge,traTarId) VALUES (0,'2024-11-11 14:27:00','V',5137951310011890,2024,'2024-11-11 14:27:00','456055202000327005012999',1,2,16,'I','',1,0,1,'','',4) 11/11/2024 14:27:23.8301 578 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 11/11/2024 14:28:05.5739 3118 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/11/2024 14:28:26.1856 503 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/11/2024 14:28:29.3688 516 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/11/2024 14:29:44.9371 772 ms. OPEN: select * from movTransit where traStatus = 'V' and traBadge = '0750003253270' order by traId desc limit 1 11/11/2024 14:29:51.7847 512 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/11/2024 14:30:22.3630 710 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2024-11-11 14:30:21' where traUID = 5449019142891480 and traStatus='V' and traEnabled=1 11/11/2024 14:30:30.1742 2108 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 11/11/2024 14:30:35.3076 700 ms. EXEC: insert into payPayment (payCreation,payUseId,payStatus,payUID,payTraUID,payYear,payDateTime,payIdTerminal,payEnabled,payDisableTime,payTarId,payTimeLimit,payType,payCurrency,payAmount,payPayed,payChange,payCardType,payPAN,paySTAN,payIdEvent,payAmountCalc,payDiscountValue,payDiscount,payDiscountType,payVatPercent,payVatAmount) VALUES ('2024-11-11 14:30:31',0,'V',5459941297929920,5539460021807130,2024,'2024-11-11 14:30:31',3,1,0,4,'2024-11-11 14:45:31','C','KES',50,100,50,'',' ',' ',1,50,0,0,'',0,0) 11/11/2024 14:30:35.6889 994 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/11/2024 14:30:37.1969 513 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/11/2024 14:30:37.6062 1602 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2024-11-11 14:30:35',3,42101,0,100,1,100,1,'I','N'); update payCurInventory set curQuantity=round(curQuantity+1,5),curAmount=round(curAmount+100,5) where curTerId = 3 and curDevCode = 42101 and curChannelId = 1 and curValue = 100 and curType = 'N'; 11/11/2024 14:30:40.9464 1522 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 11/11/2024 14:30:45.0351 1106 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/11/2024 14:30:45.0661 1420 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 11/11/2024 14:30:51.4334 1318 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 11/11/2024 14:30:52.5231 516 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/11/2024 14:31:34.2299 627 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/11/2024 14:31:59.8009 1059 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 5 11/11/2024 14:32:13.1668 603 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 (WAIT TIME 263 ms.) 11/11/2024 14:32:17.2035 862 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/11/2024 14:32:17.2035 722 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 5 and terStatus='V' 11/11/2024 14:32:44.7189 701 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 11/11/2024 14:33:04.0307 941 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/11/2024 14:33:16.8372 560 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 11/11/2024 14:33:25.5881 685 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/11/2024 14:34:02.9139 572 ms. EXEC: insert into movtransit (traUseId,traCreation,traStatus,traUID,traYear,traDateTime,traCode,traType,traClass,traIdTerminal,traDirection,traPlate,traEnabled,traDisableTime,traAreId,traNotes,traBadge,traTarId) VALUES (0,'2024-11-11 14:34:02','V',5547989953134420,2024,'2024-11-11 14:34:01','456055023900327005012999',2,2,2,'O','',0,'2024-11-11 14:34:02',1,'','',0) 11/11/2024 14:34:03.6574 530 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2024-11-11 14:34:03' where traUID = 5539460021807130 and traStatus='V' and traEnabled=1 11/11/2024 14:34:04.3179 659 ms. EXECSCALAR: SELECT traId FROM movTransit WHERE traStatus='V' AND traCode = @traCode nr: 774924 11/11/2024 14:35:47.1364 1901 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/11/2024 14:36:06.3622 883 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/11/2024 14:37:25.6830 546 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/11/2024 14:39:23.9378 555 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/11/2024 14:39:46.6119 800 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 2 11/11/2024 14:39:48.8064 1035 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/11/2024 14:39:48.9555 884 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 3 11/11/2024 14:39:56.7567 704 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/11/2024 14:41:47.9637 621 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 5 11/11/2024 14:41:48.4210 649 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/11/2024 14:41:48.4991 529 ms. OPEN: select * from tabArea where areStatus='V' and areEnabled = 1 AND areId = 1 11/11/2024 14:42:03.5171 928 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 5 11/11/2024 14:42:18.3390 517 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/11/2024 14:42:33.1638 579 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/11/2024 14:42:50.3303 586 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 11/11/2024 14:44:10.7729 533 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 11/11/2024 14:44:46.4536 1067 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/11/2024 14:45:08.5844 1816 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/11/2024 14:45:11.0880 1424 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/11/2024 14:45:37.9659 1757 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 11/11/2024 14:45:43.2475 941 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 16 OR lnsTerId=16) 11/11/2024 14:46:01.6217 659 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/11/2024 14:46:18.9953 561 ms. EXEC: insert into payReceipt (recTraUID,recPayUID,recYear,recDateTime,recText,recInvalid) VALUES (5327969044679050,5717103752827060,2024,'2024-11-11 14:46:18','---------------------------------- %The Mall P0006032390 End of payment ---------------------------------- POF Entry : 11/11/2024 1:07:01 PM Date : 11/11/2024 2:46:16 PM Code : 456054722100327005012999 Total : 100.00 KES VAT 16% : 13.79 KES ---------------------------------- Paid : 100.00 KES Coin changed : 0.00 KES Note changed : 0.00 KES',0) 11/11/2024 14:46:26.7825 1114 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 (WAIT TIME 177 ms.) 11/11/2024 14:47:00.0917 617 ms. EXEC: insert into payPayment (payCreation,payUseId,payStatus,payUID,payTraUID,payYear,payDateTime,payIdTerminal,payEnabled,payDisableTime,payTarId,payTimeLimit,payType,payCurrency,payAmount,payPayed,payChange,payCardType,payPAN,paySTAN,payIdEvent,payAmountCalc,payDiscountValue,payDiscount,payDiscountType,payVatPercent,payVatAmount) VALUES ('2024-11-11 14:46:58',0,'V',5196412457892450,5142086580802800,2024,'2024-11-11 14:46:58',3,1,0,4,'2024-11-11 15:01:58','C','KES',100,100,0,'',' ',' ',1,100,0,0,'',0,0) 11/11/2024 14:47:00.6610 555 ms. EXEC: insert into payReceipt (recTraUID,recPayUID,recYear,recDateTime,recText,recInvalid) VALUES (5142086580802800,5196412457892450,2024,'2024-11-11 14:47:00','---------------------------------- %The Mall P0006032390 End of payment ---------------------------------- POF Entry : 11/11/2024 1:22:24 PM Date : 11/11/2024 2:46:58 PM Code : 456054814400327005012999 Total : 100.00 KES VAT 16% : 13.79 KES ---------------------------------- Paid : 100.00 KES Coin changed : 0.00 KES Note changed : 0.00 KES',0) 11/11/2024 14:48:26.8575 682 ms. OPEN: select * from tabArea where areStatus='V' and areEnabled = 1 AND areId = 1 11/11/2024 14:49:24.7020 1044 ms. EXEC: insert into movtransit (traUseId,traCreation,traStatus,traUID,traYear,traDateTime,traCode,traType,traClass,traIdTerminal,traDirection,traPlate,traEnabled,traDisableTime,traAreId,traNotes,traBadge,traTarId) VALUES (0,'2024-11-11 14:49:23','V',5175200637239270,2024,'2024-11-11 14:49:21','456055336100327005012999',1,2,16,'I','',1,0,1,'','',4) 11/11/2024 14:49:42.6600 850 ms. EXEC: insert into movtransit (traUseId,traCreation,traStatus,traUID,traYear,traDateTime,traCode,traType,traClass,traIdTerminal,traDirection,traPlate,traEnabled,traDisableTime,traAreId,traNotes,traBadge,traTarId) VALUES (0,'2024-11-11 14:49:41','V',4891043698272100,2024,'2024-11-11 14:49:40','456054722100327005012999',2,2,2,'O','',0,'2024-11-11 14:49:41',1,'','',0) 11/11/2024 14:49:57.9511 542 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/11/2024 14:50:16.7407 1644 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/11/2024 14:50:34.1693 519 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 11/11/2024 14:52:59.7312 2336 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/11/2024 14:53:57.7669 941 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/11/2024 14:54:21.1385 2288 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 11/11/2024 14:54:42.1044 1399 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 11/11/2024 14:55:14.5520 1418 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/11/2024 14:56:12.4826 581 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 11/11/2024 14:56:44.7811 901 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 5 11/11/2024 14:57:46.9065 1532 ms. EXEC: insert into movtransit (traUseId,traCreation,traStatus,traUID,traYear,traDateTime,traCode,traType,traClass,traIdTerminal,traDirection,traPlate,traEnabled,traDisableTime,traAreId,traNotes,traBadge,traTarId) VALUES (0,'2024-11-11 14:57:45','V',4664797434898780,2024,'2024-11-11 14:57:42','456055386200327005012999',1,2,16,'I','',1,0,1,'','',4) (WAIT TIME 27 ms.) 11/11/2024 14:58:47.6180 1774 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/11/2024 14:59:38.7600 628 ms. OPEN: select parcurrency,parcurrencySymbol from tabParameters where parStatus='V' order by parId desc limit 1 11/11/2024 14:59:40.0159 650 ms. EXEC: insert into payReceipt (recTraUID,recPayUID,recYear,recDateTime,recText,recInvalid) VALUES (5287248407300690,5715975295948160,2024,'2024-11-11 14:59:39','---------------------------------- %The Mall P0006032390 End of payment ---------------------------------- POF Entry : 11/11/2024 11:39:52 AM Date : 11/11/2024 2:59:36 PM Code : 456054199200327005012999 Total : 200.00 KES VAT 16% : 27.59 KES ---------------------------------- Paid : 200.00 KES Coin changed : 0.00 KES Note changed : 0.00 KES',0) 11/11/2024 14:59:43.2150 700 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/11/2024 15:00:16.5112 2149 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/11/2024 15:00:22.8794 1797 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/11/2024 15:00:58.5212 537 ms. OPEN: select * from tabArea where areStatus='V' and areEnabled = 1 AND areId = 1 11/11/2024 15:03:20.1715 669 ms. EXEC: update payReceipt set recCreation = '2024-11-11 15:03:19',recModify = '2024-11-11 15:03:19',recUseId=0,recStatus='V' where recId = 321624 11/11/2024 15:03:20.7109 535 ms. EXEC: insert into paycash (casCreation,casModify,casUseId,casStatus,casUID,casTraUID,casYear,casDateTime,casIdTerminal,casCurrency,casNumber,casSingleAmount,casTotAmount,casType,casDescription) VALUES ('2024-11-11 15:03:20',0,0,'V',5491194834533260,4780689680029070,2024,'2024-11-11 15:03:20',3,'KES',1,100,100,'N',''); 11/11/2024 15:03:22.5931 940 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2024-11-11 15:03:21',3,42101,0,50,-1,-50,1,'O','N'); update payCurInventory set curQuantity=round(curQuantity+-1,5),curAmount=round(curAmount+-50,5) where curTerId = 3 and curDevCode = 42101 and curChannelId = 1 and curValue = 50 and curType = 'N'; 11/11/2024 15:04:14.8550 635 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 11/11/2024 15:06:09.1851 895 ms. EXEC: insert into payPayment (payCreation,payUseId,payStatus,payUID,payTraUID,payYear,payDateTime,payIdTerminal,payEnabled,payDisableTime,payTarId,payTimeLimit,payType,payCurrency,payAmount,payPayed,payChange,payCardType,payPAN,paySTAN,payIdEvent,payAmountCalc,payDiscountValue,payDiscount,payDiscountType,payVatPercent,payVatAmount) VALUES ('2024-11-11 15:06:08',0,'V',5652268115443070,5533656352362940,2024,'2024-11-11 15:06:08',18,1,0,4,'2024-11-11 15:21:08','C','KES',50,50,0,'','','',1,50,0,0,'',0,0) 11/11/2024 15:07:25.7701 948 ms. EXEC: insert into movtransit (traUseId,traCreation,traStatus,traUID,traYear,traDateTime,traCode,traType,traClass,traIdTerminal,traDirection,traPlate,traEnabled,traDisableTime,traAreId,traNotes,traBadge,traTarId) VALUES (0,'2024-11-11 15:07:24','V',5620171711458610,2024,'2024-11-11 15:07:24','456055334300327001012999',2,2,2,'O','',0,'2024-11-11 15:07:24',1,'','',0) 11/11/2024 15:08:04.2338 758 ms. EXEC: insert into payPayment (payCreation,payUseId,payStatus,payUID,payTraUID,payYear,payDateTime,payIdTerminal,payEnabled,payDisableTime,payTarId,payTimeLimit,payType,payCurrency,payAmount,payPayed,payChange,payCardType,payPAN,paySTAN,payIdEvent,payAmountCalc,payDiscountValue,payDiscount,payDiscountType,payVatPercent,payVatAmount) VALUES ('2024-11-11 15:05:55',12,'V',4693365722112040,4771601789352010,2024,'2024-11-11 15:05:55',17,1,0,4,'2024-11-11 15:20:55','C','KES',50,50,0,'','','',1,50,0,0,'',0,0) 11/11/2024 15:08:19.7211 782 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/11/2024 15:08:27.6253 1155 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 11/11/2024 15:08:32.4255 550 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 11/11/2024 15:09:11.1353 3954 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 11/11/2024 15:09:13.0086 1843 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 11/11/2024 15:10:28.6240 532 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/11/2024 15:11:48.5412 513 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/11/2024 15:12:28.8190 637 ms. EXEC: insert into paycash (casCreation,casModify,casUseId,casStatus,casUID,casTraUID,casYear,casDateTime,casIdTerminal,casCurrency,casNumber,casSingleAmount,casTotAmount,casType,casDescription) VALUES ('2024-11-11 15:12:28',0,0,'V',4884550527548360,4937204626422740,2024,'2024-11-11 15:12:28',3,'KES',1,200,200,'N',''); 11/11/2024 15:12:34.1025 1234 ms. EXEC: update opeActivities set acvFstPayId = (case acvFstPayId when 0 then 370018 else acvFstPayId end),acvLstPayId = 370018 where acvSftId = 824 and acvCodeId = 3 11/11/2024 15:14:00.6022 595 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2024-11-11 15:14:00' where payTraUID = 5319992483017280 and payStatus='V' and payEnabled=1 11/11/2024 15:17:03.9953 548 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 11/11/2024 15:17:14.0200 1640 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 2 OR lnsTerId=2) 11/11/2024 15:17:14.0380 1640 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/11/2024 15:18:39.2178 573 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/11/2024 15:19:10.8038 664 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/11/2024 15:23:44.2009 889 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/11/2024 15:24:28.7306 804 ms. EXEC: update payReceipt set recCreation = '2024-11-11 15:24:27',recModify = '2024-11-11 15:24:27',recUseId=0,recStatus='V' where recId = 321634 11/11/2024 15:25:55.6685 1384 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 5 and terStatus='V' 11/11/2024 15:26:04.8826 813 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 5 11/11/2024 15:26:32.4510 748 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 11/11/2024 15:30:56.2788 580 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2024-11-11 15:30:55' where traUID = 4931738163479960 and traStatus='V' and traEnabled=1 11/11/2024 15:31:30.4545 537 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 11/11/2024 15:31:36.2554 1803 ms. EXEC: insert into movtransit (traUseId,traCreation,traStatus,traUID,traYear,traDateTime,traCode,traType,traClass,traIdTerminal,traDirection,traPlate,traEnabled,traDisableTime,traAreId,traNotes,traBadge,traTarId) VALUES (0,'2024-11-11 15:31:34','V',4868686321377430,2024,'2024-11-11 15:31:33','456055589300327005012999',1,2,16,'I','',1,0,1,'','',4) 11/11/2024 15:31:37.0199 522 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 11/11/2024 15:35:39.8366 1847 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/11/2024 15:38:11.4176 1239 ms. EXEC: insert into movtransit (traUseId,traCreation,traStatus,traUID,traYear,traDateTime,traCode,traType,traClass,traIdTerminal,traDirection,traPlate,traEnabled,traDisableTime,traAreId,traNotes,traBadge,traTarId) VALUES (0,'2024-11-11 15:38:10','V',5319697561157480,2024,'2024-11-11 15:38:09','456055316000327005012999',2,2,2,'O','',0,'2024-11-11 15:38:10',1,'','',0) 11/11/2024 15:39:55.3779 1732 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/11/2024 15:40:27.3822 609 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 11/11/2024 15:41:01.4349 741 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2024-11-11 15:41:00' where traUID = 5162954458074360 and traStatus='V' and traEnabled=1 11/11/2024 15:41:33.6103 780 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 (WAIT TIME 10 ms.) 11/11/2024 15:41:54.4422 964 ms. OPEN: show columns from tmpPay where Field = 'tmpInvoice' 11/11/2024 15:42:47.5886 578 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 11/11/2024 15:42:55.1456 1237 ms. EXEC: insert into payPayment (payCreation,payUseId,payStatus,payUID,payTraUID,payYear,payDateTime,payIdTerminal,payEnabled,payDisableTime,payTarId,payTimeLimit,payType,payCurrency,payAmount,payPayed,payChange,payCardType,payPAN,paySTAN,payIdEvent,payAmountCalc,payDiscountValue,payDiscount,payDiscountType,payVatPercent,payVatAmount) VALUES ('2024-11-11 15:42:53',0,'V',4974222634322030,5734231660110770,2024,'2024-11-11 15:42:53',18,1,0,4,'2024-11-11 15:57:53','C','KES',50,50,0,'','','',1,50,0,0,'',0,0) 11/11/2024 15:43:22.3898 1113 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/11/2024 15:43:28.8851 1016 ms. EXEC: insert into movtransit (traUseId,traCreation,traStatus,traUID,traYear,traDateTime,traCode,traType,traClass,traIdTerminal,traDirection,traPlate,traEnabled,traDisableTime,traAreId,traNotes,traBadge,traCarId,traTarId) VALUES (0,'2024-11-11 15:43:27','V',5253817797401350,2024,'2024-11-11 15:43:27','456053620100327005012999',2,2,2,'O','',0,'2024-11-11 15:43:27',1,'','0810007161513',102,0) 11/11/2024 15:43:39.0889 707 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/11/2024 15:44:12.1219 1307 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2024-11-11 15:44:10' where traUID = 5734231660110770 and traStatus='V' and traEnabled=1 11/11/2024 15:44:30.9514 1407 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 11/11/2024 15:44:31.3967 2237 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2024-11-11 15:44:28',3,42101,0,100,1,100,1,'I','N'); update payCurInventory set curQuantity=round(curQuantity+1,5),curAmount=round(curAmount+100,5) where curTerId = 3 and curDevCode = 42101 and curChannelId = 1 and curValue = 100 and curType = 'N'; 11/11/2024 15:45:17.5665 664 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 11/11/2024 15:45:30.8994 2603 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/11/2024 15:46:45.3940 2049 ms. EXEC: insert into movtransit (traUseId,traCreation,traStatus,traUID,traYear,traDateTime,traCode,traType,traClass,traIdTerminal,traDirection,traPlate,traEnabled,traDisableTime,traAreId,traNotes,traBadge,traTarId) VALUES (0,'2024-11-11 15:46:43','V',4659046509095770,2024,'2024-11-11 15:46:40','456055680000327005012999',1,2,16,'I','',1,0,1,'','',4) 11/11/2024 15:47:35.9397 2023 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/11/2024 15:48:13.9370 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,payAmountCalc,payDiscountValue,payDiscount,payDiscountType,payVatPercent,payVatAmount) VALUES ('2024-11-11 15:48:11',0,'V',5515508598523190,5395398794979310,2024,'2024-11-11 15:48:11',3,1,0,4,'2024-11-11 16:03:11','C','KES',50,50,0,'',' ',' ',1,50,0,0,'',0,0) 11/11/2024 15:48:15.1618 1226 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/11/2024 15:48:30.6281 655 ms. EXEC: insert into movtransit (traUseId,traCreation,traStatus,traUID,traYear,traDateTime,traCode,traType,traClass,traIdTerminal,traDirection,traPlate,traEnabled,traDisableTime,traAreId,traNotes,traBadge,traTarId) VALUES (0,'2024-11-11 15:48:29','V',5333224951893830,2024,'2024-11-11 15:48:28','456055248400327005012999',2,2,2,'O','',0,'2024-11-11 15:48:29',1,'','',0) 11/11/2024 15:48:32.1831 867 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/11/2024 15:48:32.2862 1053 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2024-11-11 15:48:31' where traUID = 5222732702231980 and traStatus='V' and traEnabled=1 11/11/2024 15:48:40.2515 951 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 11/11/2024 15:51:04.4716 550 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 11/11/2024 15:51:25.1884 592 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2024-11-11 15:51:24' where payTraUID = 5716918918855930 and payStatus='V' and payEnabled=1 11/11/2024 15:51:28.4105 603 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 11/11/2024 15:51:39.5339 1191 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/11/2024 15:52:27.5199 908 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 11/11/2024 15:53:29.9395 748 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/11/2024 15:55:31.9838 541 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/11/2024 15:57:45.2506 1265 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 11/11/2024 15:58:38.0938 663 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 11/11/2024 15:59:25.7125 1264 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2024-11-11 15:59:24' where payTraUID = 4887223895772160 and payStatus='V' and payEnabled=1 11/11/2024 15:59:46.1631 777 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/11/2024 16:00:14.9043 543 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 11/11/2024 16:04:41.3057 1749 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 11/11/2024 16:05:23.2387 564 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2024-11-11 16:05:22' where traUID = 5300364282583520 and traStatus='V' and traEnabled=1 11/11/2024 16:05:25.6973 630 ms. EXEC: insert into payPayment (payCreation,payUseId,payStatus,payUID,payTraUID,payYear,payDateTime,payIdTerminal,payEnabled,payDisableTime,payTarId,payTimeLimit,payType,payCurrency,payAmount,payPayed,payChange,payCardType,payPAN,paySTAN,payIdEvent,payAmountCalc,payDiscountValue,payDiscount,payDiscountType,payVatPercent,payVatAmount) VALUES ('2024-11-11 16:03:01',9,'V',5652286156236130,4659046509095770,2024,'2024-11-11 16:03:01',4,1,0,4,'2024-11-11 16:18:01','P','KES',50,50,0,'','','',1,50,0,0,'',0,0) 11/11/2024 16:05:27.7166 1251 ms. EXEC: update tabTerminalReceipt set trcProgressive = 15980, trcLastPrinted = '2400415980', trcLastDate = '2024-11-11 16:05:26' where trcStatus='V' and trcTerId = 4 11/11/2024 16:05:40.5332 685 ms. EXEC: insert into movtransit (traUseId,traCreation,traStatus,traUID,traYear,traDateTime,traCode,traType,traClass,traIdTerminal,traDirection,traPlate,traEnabled,traDisableTime,traAreId,traNotes,traBadge,traTarId) VALUES (0,'2024-11-11 16:05:39','V',5006510654558330,2024,'2024-11-11 16:05:39','456055677800327005012999',2,2,2,'O','',0,'2024-11-11 16:05:39',1,'','',0) 11/11/2024 16:05:44.9031 520 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 11/11/2024 16:07:50.5658 612 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 11/11/2024 16:07:56.2216 1345 ms. EXECSCALAR: select count(*) from information_schema.tables where table_schema= 'wisepark_0327' and table_name= 'payInvoiceFtp' nr: 1 11/11/2024 16:09:24.4223 2578 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 11/11/2024 16:09:40.0557 805 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/11/2024 16:09:47.2075 1189 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/11/2024 16:10:08.5857 717 ms. EXEC: insert into payPayment (payCreation,payUseId,payStatus,payUID,payTraUID,payYear,payDateTime,payIdTerminal,payEnabled,payDisableTime,payTarId,payTimeLimit,payType,payCurrency,payAmount,payPayed,payChange,payCardType,payPAN,paySTAN,payIdEvent,payAmountCalc,payDiscountValue,payDiscount,payDiscountType,payVatPercent,payVatAmount) VALUES ('2024-11-11 16:10:04',0,'V',4870750612811650,5710687677854450,2024,'2024-11-11 16:10:04',3,1,0,4,'2024-11-11 16:25:04','C','KES',50,100,50,'',' ',' ',1,50,0,0,'',0,0) 11/11/2024 16:10:10.1268 584 ms. EXEC: update payInventory set invCreation = '2024-11-11 16:10:09',invModify = '2024-11-11 16:10:09',invUseId=0,invStatus='V' where invId = 218669 11/11/2024 16:10:37.5140 1990 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/11/2024 16:12:13.1467 674 ms. EXECSCALAR: select count(*) from information_schema.tables where table_schema= 'wisepark_0327' and table_name= 'payInvoiceFtp' nr: 1 11/11/2024 16:14:11.4886 829 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 16 OR lnsTerId=16) 11/11/2024 16:14:49.5209 619 ms. EXEC: insert into movtransit (traUseId,traCreation,traStatus,traUID,traYear,traDateTime,traCode,traType,traClass,traIdTerminal,traDirection,traPlate,traEnabled,traDisableTime,traAreId,traNotes,traBadge,traTarId) VALUES (0,'2024-11-11 16:14:48','V',4894622829453950,2024,'2024-11-11 16:14:47','456055603000327005012999',2,2,2,'O','',0,'2024-11-11 16:14:48',1,'','',0) 11/11/2024 16:14:51.8204 950 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/11/2024 16:14:59.6676 519 ms. EXECSCALAR: select count(*) from information_schema.tables where table_schema= 'wisepark_0327' and table_name= 'payInvoiceFtp' nr: 1 11/11/2024 16:15:09.5092 1499 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 11/11/2024 16:15:17.1853 536 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 11/11/2024 16:15:46.4718 576 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 11/11/2024 16:16:55.2186 1866 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/11/2024 16:17:49.6349 517 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 2 11/11/2024 16:19:51.4540 539 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 2 11/11/2024 16:20:32.8716 866 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 11/11/2024 16:20:33.8322 954 ms. OPEN: select * from tabDevice where devId = 1 and devStatus = 'V' 11/11/2024 16:22:04.3445 509 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/11/2024 16:22:04.5847 1486 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 1 and terStatus='V' 11/11/2024 16:23:14.5793 744 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 11/11/2024 16:23:28.8048 543 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 11/11/2024 16:23:57.2958 2170 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2024-11-11 16:23:55',3,42101,0,50,1,50,1,'I','N'); update payCurInventory set curQuantity=round(curQuantity+1,5),curAmount=round(curAmount+50,5) where curTerId = 3 and curDevCode = 42101 and curChannelId = 1 and curValue = 50 and curType = 'N'; 11/11/2024 16:23:57.8822 585 ms. EXEC: update payInventory set invCreation = '2024-11-11 16:23:57',invModify = '2024-11-11 16:23:57',invUseId=0,invStatus='V' where invId = 218675 11/11/2024 16:24:39.1407 2303 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/11/2024 16:24:56.5913 575 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/11/2024 16:24:57.3538 503 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 1 11/11/2024 16:26:34.1453 1818 ms. EXEC: insert into payPayment (payCreation,payUseId,payStatus,payUID,payTraUID,payYear,payDateTime,payIdTerminal,payEnabled,payDisableTime,payTarId,payTimeLimit,payType,payCurrency,payAmount,payPayed,payChange,payCardType,payPAN,paySTAN,payIdEvent,payVatPercent,payVatAmount) VALUES ('2024-11-11 16:26:32',0,'V',5737094709210770,5134538785676450,2024,'2024-11-11 16:26:32',2,1,0,-1,'2024-11-11 17:26:32','S','KES',0,0,0,'','','',3,0,0) 11/11/2024 16:28:31.2303 1080 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/11/2024 16:28:35.6562 804 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 11/11/2024 16:29:16.5675 747 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/11/2024 16:29:23.2279 1158 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 11/11/2024 16:31:06.8079 714 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 5 11/11/2024 16:31:14.0958 1283 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/11/2024 16:33:10.1721 937 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 11/11/2024 16:33:57.5987 521 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 11/11/2024 16:35:59.0616 658 ms. EXEC: insert into payPayment (payCreation,payUseId,payStatus,payUID,payTraUID,payYear,payDateTime,payIdTerminal,payEnabled,payDisableTime,payTarId,payTimeLimit,payType,payCurrency,payAmount,payPayed,payChange,payCardType,payPAN,paySTAN,payIdEvent,payAmountCalc,payDiscountValue,payDiscount,payDiscountType,payVatPercent,payVatAmount) VALUES ('2024-11-11 16:35:58',0,'V',4627459865114800,5318062898210300,2024,'2024-11-11 16:35:58',18,1,0,4,'2024-11-11 16:50:58','C','KES',50,50,0,'','','',1,50,0,0,'',0,0) 11/11/2024 16:35:59.9042 712 ms. EXEC: update payReceipt set recCreation = '2024-11-11 16:35:59',recModify = '2024-11-11 16:35:59',recUseId=0,recStatus='V' where recId = 321674 11/11/2024 16:36:47.3798 733 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 11/11/2024 16:37:40.3681 724 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 11/11/2024 16:38:31.1779 688 ms. EXEC: insert into movtransit (traUseId,traCreation,traStatus,traUID,traYear,traDateTime,traCode,traType,traClass,traIdTerminal,traDirection,traPlate,traEnabled,traDisableTime,traAreId,traNotes,traBadge,traTarId) VALUES (0,'2024-11-11 16:38:30','V',5673370366157690,2024,'2024-11-11 16:38:29','456055633400327005012999',2,2,2,'O','',0,'2024-11-11 16:38:30',1,'','',0) 11/11/2024 16:38:32.4508 903 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 11/11/2024 16:38:37.6582 696 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 11/11/2024 16:39:49.5521 503 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 11/11/2024 16:39:49.8723 698 ms. EXECSCALAR: select count(*) from information_schema.tables where table_schema= 'wisepark_0327' and table_name= 'payInvoiceFtp' nr: 1 11/11/2024 16:42:31.5470 911 ms. EXEC: insert into payPayment (payCreation,payUseId,payStatus,payUID,payTraUID,payYear,payDateTime,payIdTerminal,payEnabled,payDisableTime,payTarId,payTimeLimit,payType,payCurrency,payAmount,payPayed,payChange,payCardType,payPAN,paySTAN,payIdEvent,payAmountCalc,payDiscountValue,payDiscount,payDiscountType,payVatPercent,payVatAmount) VALUES ('2024-11-11 16:40:07',9,'V',4931536711274090,4711918652502560,2024,'2024-11-11 16:40:07',4,1,0,4,'2024-11-11 16:55:07','P','KES',100,100,0,'','','',1,100,0,0,'',0,0) 11/11/2024 16:42:32.5607 530 ms. EXEC: update tabTerminalReceipt set trcProgressive = 15982, trcLastPrinted = '2400415982', trcLastDate = '2024-11-11 16:42:32' where trcStatus='V' and trcTerId = 4 11/11/2024 16:43:49.5990 645 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 11/11/2024 16:44:55.1027 577 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 11/11/2024 16:44:55.2318 532 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 4 OR lnsTerId=4) 11/11/2024 16:53:51.8062 909 ms. EXEC: insert into movtransit (traUseId,traCreation,traStatus,traUID,traYear,traDateTime,traCode,traType,traClass,traIdTerminal,traDirection,traPlate,traEnabled,traDisableTime,traAreId,traNotes,traBadge,traTarId) VALUES (0,'2024-11-11 16:53:50','V',5404763747699180,2024,'2024-11-11 16:53:47','456055861800327005012999',2,2,2,'O','',0,'2024-11-11 16:53:50',1,'','',0) 11/11/2024 16:54:52.3305 558 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/11/2024 16:57:08.6373 931 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 11/11/2024 16:57:09.3838 531 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 11/11/2024 16:57:09.3908 549 ms. EXEC: insert into movOperator (opeCreation,opeTerId,opeUseId,opeDateTime,opeCode,opeDescription) VALUES ('2024-11-11 16:57:08',4,9,'2024-11-11 16:57:08','456055595800327005012999','Payed (Credit Card ) Ticket ') 11/11/2024 16:58:26.4211 750 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/11/2024 17:04:04.0450 1215 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 11/11/2024 17:04:09.0194 512 ms. EXECSCALAR: select count(*) from information_schema.tables where table_schema= 'wisepark_0327' and table_name= 'payInvoiceFtp' nr: 1 11/11/2024 17:04:51.7638 706 ms. EXEC: UPDATE payInventory SET invType='N' WHERE invType<>'N' AND invValue IN (100,200,500) AND invDevice IN (42102,42101,42001); 11/11/2024 17:05:04.4253 657 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2024-11-11 17:05:03' where payTraUID = 5126837953843880 and payStatus='V' and payEnabled=1 11/11/2024 17:05:29.0937 546 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 11/11/2024 17:06:16.0490 550 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 11/11/2024 17:06:16.9806 845 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2024-11-11 17:06:16' where traUID = 5463719485827790 and traStatus='V' and traEnabled=1 11/11/2024 17:06:53.1427 2734 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/11/2024 17:07:44.9462 1235 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 11/11/2024 17:09:21.9188 802 ms. EXEC: insert into movtransit (traUseId,traCreation,traStatus,traUID,traYear,traDateTime,traCode,traType,traClass,traIdTerminal,traDirection,traPlate,traEnabled,traDisableTime,traAreId,traNotes,traBadge,traTarId) VALUES (0,'2024-11-11 17:09:21','V',4939691828806080,2024,'2024-11-11 17:09:20','456055714400327005012999',2,2,2,'O','',0,'2024-11-11 17:09:21',1,'','',0) 11/11/2024 17:09:22.9735 658 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2024-11-11 17:09:22' where payTraUID = 5015524935705830 and payStatus='V' and payEnabled=1 11/11/2024 17:09:31.1870 521 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/11/2024 17:10:17.5208 578 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/11/2024 17:10:57.5285 575 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 11/11/2024 17:11:01.7183 1482 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/11/2024 17:11:35.2746 1820 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2024-11-11 17:11:33',3,42101,0,100,1,100,1,'I','N'); update payCurInventory set curQuantity=round(curQuantity+1,5),curAmount=round(curAmount+100,5) where curTerId = 3 and curDevCode = 42101 and curChannelId = 1 and curValue = 100 and curType = 'N'; 11/11/2024 17:12:58.7993 551 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 11/11/2024 17:14:18.9026 699 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/11/2024 17:15:17.7078 831 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/11/2024 17:18:40.7371 559 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/11/2024 17:21:01.5679 1806 ms. EXEC: insert into payReceipt (recTraUID,recPayUID,recYear,recDateTime,recText,recInvalid) VALUES (5062351565625630,4967712803146550,2024,'2024-11-11 17:20:59',' Date: 11/11/2024 5:20:59 PM Code: 456055364800327005012999 Entry Date: 11/11/2024 2:54:08 PM Plate: Class: Cars Park: The Mall Gate: Entry 2 ______________________________ Total: 100.00 KES ______________________________ Paid: 100.00 KES __________ Change: 0.00 KES Type: Cash Dispozitiv: MPESA # 2400749292 ',0) 11/11/2024 17:25:11.0911 740 ms. EXEC: insert into movtransit (traUseId,traCreation,traStatus,traUID,traYear,traDateTime,traCode,traType,traClass,traIdTerminal,traDirection,traPlate,traEnabled,traDisableTime,traAreId,traNotes,traBadge,traTarId) VALUES (0,'2024-11-11 17:25:10','V',5259982442545910,2024,'2024-11-11 17:25:09','456056196000327005012999',2,2,2,'O','',0,'2024-11-11 17:25:10',1,'','',0) 11/11/2024 17:25:18.2138 811 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 11/11/2024 17:25:49.2355 690 ms. EXEC: insert into payPayment (payCreation,payUseId,payStatus,payUID,payTraUID,payYear,payDateTime,payIdTerminal,payEnabled,payDisableTime,payTarId,payTimeLimit,payType,payCurrency,payAmount,payPayed,payChange,payCardType,payPAN,paySTAN,payIdEvent,payAmountCalc,payDiscountValue,payDiscount,payDiscountType,payVatPercent,payVatAmount) VALUES ('2024-11-11 17:25:47',0,'V',4639939110162390,5058514857680880,2024,'2024-11-11 17:25:47',3,1,0,4,'2024-11-11 17:40:47','C','KES',50,50,0,'',' ',' ',1,50,0,0,'',0,0) 11/11/2024 17:26:02.4553 819 ms. OPEN: select sum(crc32(terDescription)) as vCheck from tabTerminal 11/11/2024 17:27:42.9623 526 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 2 and terStatus='V' 11/11/2024 17:27:57.2228 709 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 11/11/2024 17:28:52.3715 859 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 11/11/2024 17:29:03.4729 574 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 2 11/11/2024 17:29:45.3858 638 ms. EXEC: insert into abbPayment (payCreation,payCode,payAmount,payCredit,payPayUID,payCarId,payDateFrom,payDateTo) VALUES ('2024-11-11 17:29:44','0230003950863',0,0,5639855679215120,158,'0000-00-00 00:00:00','0000-00-00 00:00:00') 11/11/2024 17:31:22.9988 1006 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 5 11/11/2024 17:31:39.5959 1359 ms. EXECSCALAR: select count(0) as vTot from tabParameters where parPlateReading<>0 nr: 0 11/11/2024 17:32:08.9334 617 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 11/11/2024 17:32:23.9034 1539 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 2 OR lnsTerId=2) 11/11/2024 17:33:33.9100 557 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/11/2024 17:36:20.6541 1532 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/11/2024 17:37:14.1107 510 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 11/11/2024 17:37:26.0587 555 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/11/2024 17:37:28.0560 551 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 11/11/2024 17:40:00.4105 538 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 5 11/11/2024 17:40:48.7187 709 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 11/11/2024 17:41:21.0252 992 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2024-11-11 17:41:19' where traUID = 5101876260121560 and traStatus='V' and traEnabled=1 11/11/2024 17:43:38.1796 1690 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2024-11-11 17:43:36' where traUID = 5503681612960470 and traStatus='V' and traEnabled=1 11/11/2024 17:43:38.3867 1174 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/11/2024 17:44:15.1142 663 ms. EXEC: update abbSubscriptions set subCredit = round(subCredit-0,5),subLastDebit = '2024-11-11 17:44:14' where subId = 43 11/11/2024 17:44:20.4687 579 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 11/11/2024 17:46:43.7422 2063 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/11/2024 17:46:53.2525 782 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/11/2024 17:46:58.0567 2312 ms. EXEC: update abbSubscriptions set subCredit = round(subCredit-0,5),subLastDebit = '2024-11-11 17:46:55' where subId = 201 11/11/2024 17:50:50.4275 844 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 2 11/11/2024 17:50:59.9629 1735 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/11/2024 17:52:14.7217 2058 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 11/11/2024 17:52:18.6203 911 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 16 OR lnsTerId=16) 11/11/2024 17:52:57.3801 1089 ms. OPEN: select * from tabArea where areStatus='V' and areEnabled = 1 AND areId = 1 11/11/2024 17:56:03.2679 547 ms. EXEC: insert into abbPayment (payCreation,payCode,payAmount,payCredit,payPayUID,payCarId,payDateFrom,payDateTo) VALUES ('2024-11-11 17:56:02','0230003943861',0,0,5217048995224460,31,'0000-00-00 00:00:00','0000-00-00 00:00:00') 11/11/2024 17:56:22.8189 634 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 5 and terStatus='V' 11/11/2024 17:56:23.7716 665 ms. EXEC: INSERT INTO movOperator (opeCreation,opeUseId,opeTerId,opeDateTime,opeCode,opeDescription) VALUES ('2024-11-11 17:56:23',0,16,'2024-11-11 17:56:23','','Unauthorized Transit Entry 2') 11/11/2024 17:56:55.3156 2601 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 5 and terStatus='V' 11/11/2024 17:57:16.6958 784 ms. EXEC: insert into movtransit (traUseId,traCreation,traStatus,traUID,traYear,traDateTime,traCode,traType,traClass,traIdTerminal,traDirection,traPlate,traEnabled,traDisableTime,traAreId,traNotes,traBadge,traTarId) VALUES (0,'2024-11-11 17:57:15','V',5490282164847870,2024,'2024-11-11 17:57:14','456056125700327005012999',2,2,2,'O','',0,'2024-11-11 17:57:15',1,'','',0) 11/11/2024 17:57:17.6074 542 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2024-11-11 17:57:17' where payTraUID = 5576939556063850 and payStatus='V' and payEnabled=1 11/11/2024 17:57:38.1781 707 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 11/11/2024 17:57:56.1241 1220 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/11/2024 17:58:00.3239 655 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 3 OR lnsTerId=3) 11/11/2024 18:00:07.5216 1677 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/11/2024 18:01:20.8535 1358 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 1 and terStatus='V' 11/11/2024 18:01:32.9585 1022 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/11/2024 18:01:51.0766 1790 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/11/2024 18:02:05.3641 586 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/11/2024 18:03:54.0475 557 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 3 and terStatus='V' 11/11/2024 18:04:23.5802 665 ms. EXEC: INSERT INTO movOperator (opeCreation,opeUseId,opeTerId,opeDateTime,opeCode,opeDescription) VALUES ('2024-11-11 18:04:22',0,16,'2024-11-11 18:04:22','','Unauthorized Transit Entry 2') 11/11/2024 18:04:51.3727 634 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 11/11/2024 18:07:57.0024 595 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/11/2024 18:10:42.3595 1571 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/11/2024 18:10:52.5173 568 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 11/11/2024 18:10:59.9923 518 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 11/11/2024 18:14:11.5419 736 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/11/2024 18:15:02.4328 577 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/11/2024 18:15:06.3244 991 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 11/11/2024 18:15:07.3440 779 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/11/2024 18:15:08.6229 833 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/11/2024 18:16:40.8773 804 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/11/2024 18:18:41.1054 555 ms. EXECSCALAR: SELECT carId FROM abbCards WHERE carStatus='V' AND carCode = '0230003950907' nr: 19 11/11/2024 18:20:24.9266 1245 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/11/2024 18:20:51.6624 558 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 11/11/2024 18:21:20.1504 534 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 5 and terStatus='V' 11/11/2024 18:21:32.0233 515 ms. EXEC: update tabTerminalReceipt set trcProgressive = 49297, trcLastPrinted = '2400749297', trcLastDate = '2024-11-11 18:21:31' where trcStatus='V' and trcTerId = 18 11/11/2024 18:21:33.0710 671 ms. EXEC: update payReceipt set recCreation = '2024-11-11 18:21:32',recModify = '2024-11-11 18:21:32',recUseId=0,recStatus='V' where recId = 321708 11/11/2024 18:22:48.5943 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,'2024-11-11 18:22:48','V',4637520709285350,2024,'2024-11-11 18:22:46','456054139300327005012999',2,2,2,'O','',0,'2024-11-11 18:22:48',1,'','',0) 11/11/2024 18:22:56.9859 648 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 11/11/2024 18:24:54.9655 1834 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/11/2024 18:25:53.4014 2482 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/11/2024 18:27:19.9621 1020 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/11/2024 18:27:33.0588 608 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 11/11/2024 18:27:33.6102 538 ms. EXEC: UPDATE payInventory SET invType='C' WHERE invType<>'C' AND invValue IN (5,10,20,40) AND invDevice IN (41003,41002,41001,41101,41102,41103); 11/11/2024 18:28:03.4671 614 ms. EXEC: update abbSubscriptions set subCredit = round(subCredit-0,5),subLastDebit = '2024-11-11 18:28:02' where subId = 178 11/11/2024 18:28:04.3576 602 ms. EXEC: insert into payPayment (payCreation,payUseId,payStatus,payUID,payTraUID,payYear,payDateTime,payIdTerminal,payEnabled,payDisableTime,payTarId,payTimeLimit,payType,payCurrency,payAmount,payPayed,payChange,payCardType,payPAN,paySTAN,payIdEvent,payVatPercent,payVatAmount) VALUES ('2024-11-11 18:28:03',0,'V',5396377738742680,5071553372369290,2024,'2024-11-11 18:28:03',2,1,0,-1,'2024-11-11 19:28:03','S','KES',0,0,0,'','','',3,0,0) 11/11/2024 18:30:17.1111 718 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 11/11/2024 18:32:20.4432 2787 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 5 11/11/2024 18:32:47.5223 513 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 11/11/2024 18:32:57.8151 1154 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 (WAIT TIME 271 ms.) 11/11/2024 18:34:28.4365 980 ms. EXEC: update payReceipt set recCreation = '2024-11-11 18:34:27',recModify = '2024-11-11 18:34:27',recUseId=0,recStatus='V' where recId = 321712 11/11/2024 18:34:34.6907 573 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 11/11/2024 18:36:10.4775 508 ms. EXEC: update abbSubscriptions set subCredit = round(subCredit-0,5),subLastDebit = '2024-11-11 18:36:09' where subId = 206 11/11/2024 18:36:59.7593 3490 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 11/11/2024 18:37:01.1452 872 ms. EXEC: INSERT INTO movOperator (opeCreation,opeUseId,opeTerId,opeDateTime,opeCode,opeDescription) VALUES ('2024-11-11 18:37:00',0,16,'2024-11-11 18:37:00','','Unauthorized Transit Entry 2') 11/11/2024 18:37:14.4631 720 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2024-11-11 18:37:13' where payTraUID = 5103678828497320 and payStatus='V' and payEnabled=1 11/11/2024 18:37:18.0235 738 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 11/11/2024 18:38:01.4024 641 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 11/11/2024 18:38:49.5564 2650 ms. EXEC: update abbSubscriptions set subCredit = round(subCredit-0,5),subLastDebit = '2024-11-11 18:38:46' where subId = 12 11/11/2024 18:40:21.8739 631 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 3 11/11/2024 18:40:21.8739 528 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/11/2024 18:40:33.0374 1360 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 1 OR lnsTerId=1) 11/11/2024 18:41:34.3622 682 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 2 OR lnsTerId=2) 11/11/2024 18:43:11.2568 916 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/11/2024 18:44:26.0886 600 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 11/11/2024 18:44:27.4595 1328 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2024-11-11 18:44:26' where payTraUID = 5375759855183720 and payStatus='V' and payEnabled=1 11/11/2024 18:46:39.3334 1915 ms. EXEC: insert into movtransit (traUseId,traCreation,traStatus,traUID,traYear,traDateTime,traCode,traType,traClass,traIdTerminal,traDirection,traPlate,traEnabled,traDisableTime,traAreId,traNotes,traBadge,traTarId) VALUES (0,'2024-11-11 18:46:37','V',5656760947113240,2024,'2024-11-11 18:46:36','456056759600327005012999',1,2,16,'I','',1,0,1,'','',4) 11/11/2024 18:47:57.3737 860 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 1 OR lnsTerId=1) 11/11/2024 18:52:58.0741 533 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/11/2024 18:54:56.1847 1811 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/11/2024 18:55:48.6437 1459 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 3 11/11/2024 18:56:11.9242 2272 ms. EXECSCALAR: select count(*) from information_schema.tables where table_schema= 'wisepark_0327' and table_name= 'payInvoiceFtp' nr: 1 11/11/2024 18:56:28.7334 1135 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/11/2024 19:00:23.2026 575 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/11/2024 19:26:07.5433 1175 ms. OPEN: select * from tabArea where areStatus='V' and areEnabled = 1 AND areId = 1 11/11/2024 19:26:09.0193 2185 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 5 11/11/2024 19:26:10.8525 801 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 11/11/2024 19:26:28.2201 1251 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/11/2024 19:28:26.2667 3929 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 3 11/11/2024 19:28:26.5249 2749 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/11/2024 19:28:40.8445 1352 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 2 OR lnsTerId=2) 11/11/2024 19:28:46.3251 2306 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2024-11-11 19:28:41' where traUID = 5746997885680950 and traStatus='V' and traEnabled=1 11/11/2024 19:29:02.7871 560 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 11/11/2024 19:30:02.3988 738 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/11/2024 19:31:14.4238 1212 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 1 OR lnsTerId=1) 11/11/2024 19:32:48.1702 586 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/11/2024 19:33:47.1345 679 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 1 11/11/2024 19:34:01.1398 503 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/11/2024 19:34:02.9010 698 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 7 11/11/2024 19:34:06.9877 2143 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 1 OR lnsTerId=1) 11/11/2024 19:34:26.1105 1210 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/11/2024 19:34:26.1155 777 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 1 11/11/2024 19:34:33.6665 4384 ms. EXEC: DELETE FROM tmppay WHERE tmpCode = '456054774400327005012999' 11/11/2024 19:34:33.8116 2688 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/11/2024 19:34:45.8966 1166 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/11/2024 19:34:53.9440 1200 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/11/2024 19:35:13.6651 582 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/11/2024 19:35:19.0517 632 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/11/2024 19:35:27.2232 549 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/11/2024 19:35:46.3599 565 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 11/11/2024 19:35:49.3249 1411 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/11/2024 19:36:00.4923 1159 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/11/2024 19:37:05.6327 897 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/11/2024 19:38:52.9482 1614 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 5 and terStatus='V' 11/11/2024 19:39:15.3691 1145 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/11/2024 19:40:03.0099 913 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 5 and terStatus='V' 11/11/2024 19:40:07.2637 930 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 3 11/11/2024 19:40:14.0923 629 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2024-11-11 19:40:13',3,42101,0,50,1,50,1,'I','N'); update payCurInventory set curQuantity=round(curQuantity+1,5),curAmount=round(curAmount+50,5) where curTerId = 3 and curDevCode = 42101 and curChannelId = 1 and curValue = 50 and curType = 'N'; 11/11/2024 19:40:56.6616 907 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 2 and terStatus='V' 11/11/2024 19:40:56.9788 2508 ms. EXEC: update paycash set casCreation = '2024-11-11 19:40:54',casModify = '2024-11-11 19:40:54',casUseId=0,casStatus='V' where casId = 194453 11/11/2024 19:42:36.3230 1984 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 11/11/2024 19:42:36.3530 855 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/11/2024 19:43:07.1806 1639 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/11/2024 19:43:10.0895 1006 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/11/2024 19:43:21.8073 2037 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/11/2024 19:43:28.0315 540 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/11/2024 19:43:29.4124 523 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/11/2024 19:43:52.7689 3358 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/11/2024 19:44:00.2579 2687 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/11/2024 19:44:08.9097 540 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/11/2024 19:50:56.0269 684 ms. EXEC: insert into movtransit (traUseId,traCreation,traStatus,traUID,traYear,traDateTime,traCode,traType,traClass,traIdTerminal,traDirection,traPlate,traEnabled,traDisableTime,traAreId,traNotes,traBadge,traTarId) VALUES (0,'2024-11-11 19:50:55','V',5681221270869720,2024,'2024-11-11 19:50:54','456057145400327005012999',1,2,16,'I','',1,0,1,'','',4) 11/11/2024 19:51:57.8501 1249 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 11/11/2024 19:54:01.5415 3320 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 11/11/2024 19:56:16.8496 634 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 11/11/2024 19:58:07.7525 5262 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/11/2024 19:58:12.0964 529 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 16 OR lnsTerId=16) 11/11/2024 20:00:56.0646 1124 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/11/2024 20:01:42.8988 676 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2024-11-11 20:01:42',3,42101,0,50,1,50,1,'I','N'); update payCurInventory set curQuantity=round(curQuantity+1,5),curAmount=round(curAmount+50,5) where curTerId = 3 and curDevCode = 42101 and curChannelId = 1 and curValue = 50 and curType = 'N'; 11/11/2024 20:02:07.0859 576 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2024-11-11 20:02:06' where payTraUID = 5661483287950000 and payStatus='V' and payEnabled=1 11/11/2024 20:02:39.3264 1715 ms. EXEC: insert into movtransit (traUseId,traCreation,traStatus,traUID,traYear,traDateTime,traCode,traType,traClass,traIdTerminal,traDirection,traPlate,traEnabled,traDisableTime,traAreId,traNotes,traBadge,traCarId,traTarId) VALUES (0,'2024-11-11 20:02:37','V',5051321159541550,2024,'2024-11-11 20:02:29','456056596800327005012999',2,2,2,'O','',0,'2024-11-11 20:02:37',1,'','0230003944064',14,0) 11/11/2024 20:02:40.8234 509 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2024-11-11 20:02:40' where traUID = 4800803951381100 and traStatus='V' and traEnabled=1 11/11/2024 20:03:44.6039 999 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2024-11-11 20:03:43',3,42101,0,200,-2,-400,1,'O','N'); update payCurInventory set curQuantity=round(curQuantity+-2,5),curAmount=round(curAmount+-400,5) where curTerId = 3 and curDevCode = 42101 and curChannelId = 1 and curValue = 200 and curType = 'N'; 11/11/2024 20:05:40.9334 915 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/11/2024 20:05:43.3240 900 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/11/2024 20:05:47.6529 635 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 11/11/2024 20:05:47.6729 640 ms. EXECSCALAR: select count(*) from information_schema.tables where table_schema= 'wisepark_0327' and table_name= 'payInvoiceFtp' nr: 1 11/11/2024 20:05:50.5268 1151 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/11/2024 20:12:45.5302 958 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 11/11/2024 20:12:46.2947 607 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2024-11-11 20:12:45' where traUID = 5694359138642800 and traStatus='V' and traEnabled=1 11/11/2024 20:12:52.1606 544 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 11/11/2024 20:13:55.4458 719 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 11/11/2024 20:14:50.6586 705 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/11/2024 20:15:07.4818 2011 ms. EXEC: insert into payPayment (payCreation,payUseId,payStatus,payUID,payTraUID,payYear,payDateTime,payIdTerminal,payEnabled,payDisableTime,payTarId,payTimeLimit,payType,payCurrency,payAmount,payPayed,payChange,payCardType,payPAN,paySTAN,payIdEvent,payAmountCalc,payDiscountValue,payDiscount,payDiscountType,payVatPercent,payVatAmount) VALUES ('2024-11-11 20:15:05',0,'V',5297368506773900,5382435727044490,2024,'2024-11-11 20:15:05',18,1,0,4,'2024-11-11 20:30:05','C','KES',50,50,0,'','','',1,50,0,0,'',0,0) 11/11/2024 20:15:23.9968 2128 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2024-11-11 20:15:21' where traUID = 5382435727044490 and traStatus='V' and traEnabled=1 11/11/2024 20:16:17.0431 849 ms. EXECSCALAR: select count(*) from information_schema.tables where table_schema= 'wisepark_0327' and table_name= 'payInvoiceFtp' nr: 1 11/11/2024 20:16:27.7092 2025 ms. EXEC: update abbSubscriptions set subCredit = round(subCredit-0,5),subLastDebit = '2024-11-11 20:16:25' where subId = 205 11/11/2024 20:16:30.3480 2154 ms. EXEC: insert into payPayment (payCreation,payUseId,payStatus,payUID,payTraUID,payYear,payDateTime,payIdTerminal,payEnabled,payDisableTime,payTarId,payTimeLimit,payType,payCurrency,payAmount,payPayed,payChange,payCardType,payPAN,paySTAN,payIdEvent,payVatPercent,payVatAmount) VALUES ('2024-11-11 20:16:28',0,'V',5114727135967680,5150008380477810,2024,'2024-11-11 20:16:28',2,1,0,-1,'2024-11-11 21:16:28','S','KES',0,0,0,'','','',3,0,0) 11/11/2024 20:16:51.0288 1075 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/11/2024 20:16:53.2072 820 ms. EXEC: update abbCards set carLastDate = '2024-11-11 20:16:52',carLastDirection='O' where carStatus='V' and carId = 44 11/11/2024 20:17:26.7766 1211 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 11/11/2024 20:17:26.8316 1260 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/11/2024 20:18:05.1942 1179 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/11/2024 20:18:17.3793 587 ms. EXEC: insert into payPayment (payCreation,payUseId,payStatus,payUID,payTraUID,payYear,payDateTime,payIdTerminal,payEnabled,payDisableTime,payTarId,payTimeLimit,payType,payCurrency,payAmount,payPayed,payChange,payCardType,payPAN,paySTAN,payIdEvent,payAmountCalc,payDiscountValue,payDiscount,payDiscountType,payVatPercent,payVatAmount) VALUES ('2024-11-11 20:18:16',0,'V',5040563874550020,4840781026668260,2024,'2024-11-11 20:18:16',18,1,0,4,'2024-11-11 20:33:16','C','KES',50,50,0,'','','',1,50,0,0,'',0,0) 11/11/2024 20:18:18.1518 583 ms. EXEC: update tabTerminalReceipt set trcProgressive = 49315, trcLastPrinted = '2400749315', trcLastDate = '2024-11-11 20:18:17' where trcStatus='V' and trcTerId = 18 11/11/2024 20:18:48.3599 740 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/11/2024 20:26:43.5154 542 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 11/11/2024 20:28:58.7795 523 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/11/2024 20:29:55.5464 1198 ms. OPEN: select parVatRate,parVatName,parVatMethod,parVatRound,parVatDiscount from tabParameters where parStatus='V' order by parId desc limit 1 11/11/2024 20:31:28.1871 672 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 5 11/11/2024 20:43:55.3708 672 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/11/2024 20:48:11.8937 620 ms. EXEC: insert into movtransit (traUseId,traCreation,traStatus,traUID,traYear,traDateTime,traCode,traType,traClass,traIdTerminal,traDirection,traPlate,traEnabled,traDisableTime,traAreId,traNotes,traBadge,traTarId) VALUES (0,'2024-11-11 20:48:11','V',5287256571548630,2024,'2024-11-11 20:48:09','456057370700327005012999',2,2,2,'O','',0,'2024-11-11 20:48:11',1,'','',0) 11/11/2024 20:49:19.6929 915 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/11/2024 20:50:52.4477 934 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 11/11/2024 20:50:53.4573 677 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2024-11-11 20:50:52' where traUID = 4673214926474410 and traStatus='V' and traEnabled=1 11/11/2024 20:51:01.1314 3483 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/11/2024 20:51:10.3556 1725 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/11/2024 20:53:19.9159 717 ms. EXECSCALAR: select count(0) as vTot from tabParameters where parPlateReading<>0 nr: 0 11/11/2024 20:59:07.4684 585 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/11/2024 21:01:16.5714 1872 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/11/2024 21:03:46.5923 1061 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/11/2024 21:04:26.1157 542 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 11/11/2024 21:05:19.1470 600 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/11/2024 21:06:28.5662 1236 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/11/2024 21:07:09.1623 589 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 4 OR lnsTerId=4) 11/11/2024 21:08:02.8861 2730 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 11/11/2024 21:09:16.7573 502 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/11/2024 21:09:17.7940 836 ms. EXEC: insert into movtransit (traUseId,traCreation,traStatus,traUID,traYear,traDateTime,traCode,traType,traClass,traIdTerminal,traDirection,traPlate,traEnabled,traDisableTime,traAreId,traNotes,traBadge,traTarId) VALUES (0,'2024-11-11 21:09:16','V',4834674020916320,2024,'2024-11-11 21:09:14','456057145400327005012999',2,2,2,'O','',0,'2024-11-11 21:09:16',1,'','',0) 11/11/2024 21:09:18.4924 616 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 11/11/2024 21:09:27.0722 619 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 11/11/2024 21:10:20.7769 688 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 11/11/2024 21:10:52.2369 2109 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/11/2024 21:11:57.8676 897 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/11/2024 21:12:30.1491 900 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 11/11/2024 21:14:41.9719 1658 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/11/2024 21:17:52.8631 3528 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 11/11/2024 21:18:03.5972 671 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 11/11/2024 21:18:38.9968 2148 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/11/2024 21:18:49.1596 1137 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/11/2024 21:19:01.6669 1217 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/11/2024 21:19:18.5772 566 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/11/2024 21:23:35.1461 528 ms. EXEC: insert into payPayment (payCreation,payUseId,payStatus,payUID,payTraUID,payYear,payDateTime,payIdTerminal,payEnabled,payDisableTime,payTarId,payTimeLimit,payType,payCurrency,payAmount,payPayed,payChange,payCardType,payPAN,paySTAN,payIdEvent,payAmountCalc,payDiscountValue,payDiscount,payDiscountType,payVatPercent,payVatAmount) VALUES ('2024-11-11 21:23:34',0,'V',4637166208002970,5014638430502240,2024,'2024-11-11 21:23:34',18,1,0,4,'2024-11-11 21:38:34','C','KES',50,50,0,'','','',1,50,0,0,'',0,0) 11/11/2024 21:24:16.5747 1237 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/11/2024 21:25:29.9506 591 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/11/2024 21:26:09.4639 1682 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 11/11/2024 21:26:17.3892 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,'2024-11-11 21:26:16','V',5482171223516100,2024,'2024-11-11 21:26:16','456057506700327005012999',2,2,2,'O','',0,'2024-11-11 21:26:16',1,'','',0) 11/11/2024 21:26:21.5399 1031 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 11/11/2024 21:26:37.0493 612 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2024-11-11 21:26:36',3,42101,0,100,1,100,1,'I','N'); update payCurInventory set curQuantity=round(curQuantity+1,5),curAmount=round(curAmount+100,5) where curTerId = 3 and curDevCode = 42101 and curChannelId = 1 and curValue = 100 and curType = 'N'; 11/11/2024 21:27:21.2697 927 ms. EXEC: insert into movtransit (traUseId,traCreation,traStatus,traUID,traYear,traDateTime,traCode,traType,traClass,traIdTerminal,traDirection,traPlate,traEnabled,traDisableTime,traAreId,traNotes,traBadge,traTarId) VALUES (0,'2024-11-11 21:27:20','V',4689044220515730,2024,'2024-11-11 21:27:19','456057723900327005012999',1,2,16,'I','',1,0,1,'','',4) 11/11/2024 21:27:34.2904 943 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 16 OR lnsTerId=16) 11/11/2024 21:31:54.5768 570 ms. EXEC: update paycash set casCreation = '2024-11-11 21:31:54',casModify = '2024-11-11 21:31:54',casUseId=0,casStatus='V' where casId = 194466 11/11/2024 21:31:55.2623 644 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 11/11/2024 21:31:55.2763 699 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2024-11-11 21:31:53',3,42101,0,100,1,100,1,'I','N'); update payCurInventory set curQuantity=round(curQuantity+1,5),curAmount=round(curAmount+100,5) where curTerId = 3 and curDevCode = 42101 and curChannelId = 1 and curValue = 100 and curType = 'N'; 11/11/2024 21:32:21.0935 720 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 1 and terStatus='V' 11/11/2024 21:32:32.4810 600 ms. EXEC: insert into movtransit (traUseId,traCreation,traStatus,traUID,traYear,traDateTime,traCode,traType,traClass,traIdTerminal,traDirection,traPlate,traEnabled,traDisableTime,traAreId,traNotes,traBadge,traTarId) VALUES (0,'2024-11-11 21:32:31','V',4819573426339020,2024,'2024-11-11 21:32:31','456057571200327005012999',2,2,2,'O','',0,'2024-11-11 21:32:31',1,'','',0) 11/11/2024 21:32:40.0691 524 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 11/11/2024 21:33:40.7255 659 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/11/2024 21:33:45.3986 1266 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/11/2024 21:35:50.7982 797 ms. EXEC: insert into movtransit (traUseId,traCreation,traStatus,traUID,traYear,traDateTime,traCode,traType,traClass,traIdTerminal,traDirection,traPlate,traEnabled,traDisableTime,traAreId,traNotes,traBadge,traTarId) VALUES (0,'2024-11-11 21:35:50','V',4670487779056130,2024,'2024-11-11 21:35:49','456057610100327005012999',2,2,2,'O','',0,'2024-11-11 21:35:50',1,'','',0) 11/11/2024 21:38:51.2073 1035 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 11/11/2024 21:40:10.2610 733 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 11/11/2024 21:40:26.3147 818 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2024-11-11 21:40:25' where traUID = 5014870485038220 and traStatus='V' and traEnabled=1 11/11/2024 21:40:29.6759 1137 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 11/11/2024 21:44:16.9433 1243 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/11/2024 21:44:45.0450 550 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 11/11/2024 21:45:12.8035 713 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 11/11/2024 21:45:19.4690 557 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/11/2024 21:46:31.7361 640 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/11/2024 21:46:56.0293 589 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 5 11/11/2024 21:47:39.1490 818 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 11/11/2024 21:47:51.1250 636 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 11/11/2024 21:48:18.4532 1037 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/11/2024 21:49:04.8731 1481 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/11/2024 21:49:57.0799 1746 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/11/2024 21:50:36.2560 1671 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/11/2024 21:52:12.9724 811 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 11/11/2024 21:53:19.4987 1447 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 16 OR lnsTerId=16) 11/11/2024 21:53:49.3326 538 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/11/2024 21:56:28.2325 517 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/11/2024 21:56:28.2335 512 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 2 OR lnsTerId=2) 11/11/2024 21:57:13.7788 1427 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/11/2024 21:58:33.4979 1655 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 5 11/11/2024 21:59:09.9702 515 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/11/2024 22:01:35.8634 1519 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/11/2024 22:05:02.0287 529 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/11/2024 22:05:57.3956 571 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 11/11/2024 22:06:43.9316 757 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 11/11/2024 22:10:02.0326 2145 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/11/2024 22:12:29.4388 887 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 11/11/2024 22:17:07.3989 621 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 1 11/11/2024 22:28:08.3202 604 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/11/2024 22:28:10.7759 637 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/11/2024 22:28:17.8996 762 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 11/11/2024 22:34:09.7450 1375 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/11/2024 22:36:29.2619 1256 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 11/11/2024 22:36:38.1508 1578 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 1 11/11/2024 22:43:04.1860 977 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 2 11/11/2024 22:48:36.4423 663 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 11/11/2024 22:50:23.9219 528 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/11/2024 22:53:21.2721 959 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/11/2024 22:54:03.8704 795 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/11/2024 22:54:31.2837 658 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 16 OR lnsTerId=16) 11/11/2024 22:56:59.8707 504 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/11/2024 23:00:15.5620 838 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/11/2024 23:00:20.8396 943 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 3 and terStatus='V' 11/11/2024 23:03:57.8721 1844 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/11/2024 23:12:32.9332 623 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/11/2024 23:17:30.9818 532 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/11/2024 23:19:03.2803 560 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 11/11/2024 23:20:26.4997 553 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/11/2024 23:25:51.7224 1220 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/11/2024 23:26:45.6453 2611 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/11/2024 23:26:50.4405 1049 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/11/2024 23:26:52.8141 665 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/11/2024 23:26:55.6800 953 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/11/2024 23:27:06.9895 1932 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/11/2024 23:27:16.1906 1977 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/11/2024 23:33:52.8949 1067 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/11/2024 23:34:09.5880 548 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/11/2024 23:36:32.2741 1615 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/11/2024 23:39:09.9581 1496 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/11/2024 23:40:26.8864 1204 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/11/2024 23:41:28.3613 1734 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/11/2024 23:41:36.2676 534 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 11/11/2024 23:48:01.0449 1441 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/11/2024 23:51:59.2266 1476 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/11/2024 23:53:20.4206 1233 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/11/2024 23:59:11.2413 677 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1