22/11/2024 00:13:10.4255 580 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 22/11/2024 00:20:40.2576 982 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 22/11/2024 00:22:16.3309 743 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 22/11/2024 00:31:46.0412 715 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 22/11/2024 01:04:41.9545 1037 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 22/11/2024 01:04:46.9398 1019 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 22/11/2024 01:10:57.8831 910 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 22/11/2024 01:11:44.7064 618 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 22/11/2024 01:14:11.4626 1455 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 22/11/2024 01:14:41.4096 995 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 22/11/2024 01:16:53.7902 724 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 22/11/2024 01:17:13.7796 813 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 22/11/2024 01:17:23.7083 509 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 16 OR lnsTerId=16) 22/11/2024 01:23:41.9084 990 ms. OPEN: select * from tabArea where areStatus='V' and areEnabled = 1 AND areId = 1 22/11/2024 01:24:24.2888 814 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 22/11/2024 01:24:25.2964 718 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 22/11/2024 01:24:36.9092 669 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 22/11/2024 01:24:37.0903 604 ms. OPEN: select * from tabArea where areStatus='V' and areEnabled = 1 AND areId = 1 22/11/2024 01:29:00.4096 822 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 22/11/2024 01:30:53.5914 557 ms. OPEN: select * from tabArea where areStatus='V' and areEnabled = 1 AND areId = 1 22/11/2024 01:38:53.9861 1237 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 22/11/2024 01:42:34.2216 939 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 22/11/2024 01:54:55.7021 1639 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 22/11/2024 01:57:58.8197 591 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 22/11/2024 02:16:17.3313 562 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 22/11/2024 02:23:30.9136 548 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 22/11/2024 02:28:26.6006 610 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 22/11/2024 02:33:11.4233 879 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 22/11/2024 02:37:31.7056 1033 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 22/11/2024 02:44:56.2772 1375 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 22/11/2024 02:51:38.1964 1061 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 22/11/2024 03:02:45.0382 1008 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 22/11/2024 03:06:44.4546 751 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 22/11/2024 03:10:50.7334 1006 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 22/11/2024 03:16:03.9051 1043 ms. EXECSCALAR: select count(0) as vTot from tabParameters where parPlateReading<>0 nr: 0 22/11/2024 03:29:02.0030 3044 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 22/11/2024 03:30:16.6350 2145 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 22/11/2024 03:38:03.9266 754 ms. EXEC: UPDATE payInventory SET invType='N' WHERE invType<>'N' AND invValue IN (100,200,500) AND invDevice IN (42102,42101,42001); 22/11/2024 03:46:27.3336 526 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 22/11/2024 03:47:45.8432 536 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 22/11/2024 04:03:24.0734 593 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 22/11/2024 04:03:37.0841 539 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 22/11/2024 04:09:40.8346 1180 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 22/11/2024 04:10:07.5035 1076 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 22/11/2024 04:14:47.3148 715 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 22/11/2024 04:41:12.8008 2567 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 22/11/2024 04:49:24.5102 2421 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 22/11/2024 04:57:00.6548 534 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 22/11/2024 05:09:39.0908 534 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 22/11/2024 05:21:26.4686 1463 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 22/11/2024 05:22:18.7006 580 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 22/11/2024 05:26:03.8364 1115 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 1 and terStatus='V' 22/11/2024 05:44:09.0714 565 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 22/11/2024 05:51:05.7355 514 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 22/11/2024 05:51:23.1431 888 ms. EXEC: update abbSubscriptions set subCredit = round(subCredit-0,5),subLastDebit = '2024-11-22 05:51:22' where subId = 108 22/11/2024 06:20:48.3493 641 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 22/11/2024 06:21:14.8770 1786 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 22/11/2024 06:22:09.1504 965 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 22/11/2024 06:31:29.2994 909 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 22/11/2024 06:33:14.7660 1535 ms. EXEC: insert into movtransit (traUseId,traCreation,traStatus,traUID,traYear,traDateTime,traCode,traType,traClass,traIdTerminal,traDirection,traPlate,traEnabled,traDisableTime,traAreId,traNotes,traBadge,traTarId) VALUES (0,'2024-11-22 06:33:13','V',4710004280063860,2024,'2024-11-22 06:33:12','456162359200327005012999',1,2,16,'I','',1,0,1,'','',4) 22/11/2024 06:33:50.4559 527 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 2 and terStatus='V' 22/11/2024 06:35:12.1956 1778 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-22 06:35:10','V',4741298959222590,2024,'2024-11-22 06:35:07','456162370700327005012999',1,2,16,'I','',1,0,1,'','',4) 22/11/2024 06:36:48.1959 739 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 22/11/2024 06:37:16.4318 2658 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 22/11/2024 06:47:00.6529 552 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 22/11/2024 06:47:58.8519 1720 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 22/11/2024 06:48:03.2728 2192 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 22/11/2024 06:48:14.2482 2088 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 22/11/2024 06:48:17.5764 511 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 22/11/2024 06:48:56.8087 987 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 22/11/2024 06:52:40.4094 859 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 2 and terStatus='V' 22/11/2024 06:57:10.1751 1209 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 22/11/2024 07:00:02.8527 561 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 22/11/2024 07:00:04.1686 1012 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 22/11/2024 07:00:07.1236 737 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 22/11/2024 07:01:00.8075 731 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 22/11/2024 07:07:17.4127 749 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2024-11-22 07:07:16' where payTraUID = 4741298959222590 and payStatus='V' and payEnabled=1 22/11/2024 07:14:18.4196 1426 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 22/11/2024 07:17:12.7043 507 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 22/11/2024 07:17:32.2824 989 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-22 07:17:31','V',5600027230150300,2024,'2024-11-22 07:17:30','456162625000327005012999',1,2,16,'I','',1,0,1,'','0230003957444',26,0) 22/11/2024 07:18:17.7168 669 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 5 22/11/2024 07:29:51.5044 722 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 5 22/11/2024 07:37:06.1424 2732 ms. EXEC: UPDATE payInventory SET invType='N' WHERE invType<>'N' AND invValue IN (100,200,500) AND invDevice IN (42102,42101,42001); 22/11/2024 07:38:11.2560 756 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 22/11/2024 07:39:23.8726 1193 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 22/11/2024 07:41:16.3509 1024 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 3 22/11/2024 07:43:24.5428 779 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2024-11-22 07:43:23' where traUID = 5592998709410310 and traStatus='V' and traEnabled=1 22/11/2024 07:53:37.1631 1957 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-22 07:53:35','V',5267348249745060,2024,'2024-11-22 07:53:34','456162841400327005012999',1,2,16,'I','',1,0,1,'','0230004100104',151,0) 22/11/2024 07:53:41.2538 732 ms. EXEC: insert into movOperator (opeCreation,opeTerId,opeUseId,opeDateTime,opeCode,opeDescription) VALUES ('2024-11-22 07:53:40',4,6,'2024-11-22 07:53:40','456162675800327001012999','Payed (Credit Card ) Ticket ') 22/11/2024 07:53:59.4110 1243 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 22/11/2024 07:55:11.5333 651 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 22/11/2024 07:57:43.4440 630 ms. EXEC: UPDATE payInventory SET invType='N' WHERE invType<>'N' AND invValue IN (100,200,500) AND invDevice IN (42102,42101,42001); 22/11/2024 07:59:43.0141 861 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 22/11/2024 07:59:50.1809 2818 ms. EXEC: insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2024-11-22 07:59:41',5,3,42101,0,50,-12,-600,2,'O','N'); insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2024-11-22 07:59:41',5,3,42101,0,100,-12,-1200,2,'O','N'); insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2024-11-22 07:59:41',5,3,42101,0,200,-4,-800,2,'O','N'); insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2024-11-22 07:59:41',5,3,42101,0,500,-4,-2000,2,'O','N'); insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2024-11-22 07:59:41',5,3,42101,0,1000,-2,-2000,2,'O','N'); insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2024-11-22 07:59:41',5,3,42101,1,0,0,0,2,'O',''); update payCurInventory set curQuantity=0,curAmount=0 where curQuantity<0; 22/11/2024 08:03:05.8019 630 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 22/11/2024 08:03:49.2540 855 ms. EXEC: insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2024-11-22 08:03:45',5,3,42101,0,50,12,600,1,'I','N'); update payCurInventory set curQuantity=round(curQuantity+12,5),curAmount=round(curAmount+600,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-22 08:03:45',5,3,42101,0,100,4,400,1,'I','N'); update payCurInventory set curQuantity=round(curQuantity+4,5),curAmount=round(curAmount+400,5) where curTerId = 3 and curDevCode = 42101 and curChannelId = 1 and curValue = 100 and curType = 'N'; update payCurInventory set curQuantity=0,curAmount=0 where curQuantity<0; 22/11/2024 08:14:15.0810 995 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 22/11/2024 08:18:11.1711 848 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 22/11/2024 08:24:56.7307 564 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 22/11/2024 08:31:24.2642 522 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 22/11/2024 08:35:09.2709 620 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 22/11/2024 08:40:50.7936 612 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 22/11/2024 08:44:24.2745 1907 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 22/11/2024 08:45:19.8327 592 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 22/11/2024 08:45:32.7884 1258 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 22/11/2024 08:51:12.3618 1269 ms. EXECSCALAR: select count(*) from tabTerminalExtraMem where extStatus='V' and extTerId = 2 nr: 1 22/11/2024 08:51:12.4769 951 ms. EXEC: UPDATE payInventory SET invType='N' WHERE invType<>'N' AND invValue IN (100,200,500) AND invDevice IN (42102,42101,42001); 22/11/2024 08:52:36.3790 600 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 22/11/2024 08:55:35.7101 863 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 2 22/11/2024 08:55:35.7421 892 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 22/11/2024 08:55:44.8673 2433 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-22 08:55:42','V',4625294945655070,2024,'2024-11-22 08:55:41','456163214100327005012999',1,2,16,'I','',1,0,1,'','0230003944406',17,0) 22/11/2024 08:55:45.6608 568 ms. EXEC: update abbCards set carLastDate = '2024-11-22 08:55:45',carLastDirection='I' where carStatus='V' and carId = 17 22/11/2024 08:58:17.7977 736 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 22/11/2024 09:01:21.6488 617 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 2 OR lnsTerId=2) 22/11/2024 09:04:42.3121 1206 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 22/11/2024 09:04:53.6858 887 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-22 09:04:52','V',5140418242147860,2024,'2024-11-22 09:04:51','456163150800327005012999',2,2,2,'O','',0,'2024-11-22 09:04:52',1,'','',0) 22/11/2024 09:05:02.1094 1060 ms. EXEC: UPDATE payInventory SET invType='N' WHERE invType<>'N' AND invValue IN (100,200,500) AND invDevice IN (42102,42101,42001); 22/11/2024 09:06:35.2588 639 ms. EXEC: insert into payReceipt (recTraUID,recPayUID,recYear,recDateTime,recText,recInvalid) VALUES (5012035238820510,4682469212897690,2024,'2024-11-22 09:06:34','---------------------------------- %The Mall P0006032390 End of payment ---------------------------------- POF Entry : 11/22/2024 8:13:55 AM Date : 11/22/2024 9:06:31 AM Code : 456162963500327001012999 Total : 50.00 KES VAT 16% : 6.90 KES ---------------------------------- Paid : 50.00 KES Coin changed : 0.00 KES Note changed : 0.00 KES',0) 22/11/2024 09:06:36.9929 560 ms. OPEN: select * from payCurInventory where curTerId = 3 and curQuantity>0 and curType in ('C','N') order by curDevCode,curChannelId,curValue 22/11/2024 09:06:56.9093 595 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 22/11/2024 09:17:04.2159 980 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 22/11/2024 09:20:34.6449 1586 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 22/11/2024 09:22:13.3960 580 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 22/11/2024 09:24:17.2419 638 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 22/11/2024 09:28:12.7566 1149 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 22/11/2024 09:28:26.9541 958 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 22/11/2024 09:28:35.7330 1246 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 22/11/2024 09:31:54.0698 751 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 2 OR lnsTerId=2) 22/11/2024 09:33:31.8293 664 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 22/11/2024 09:34:37.8495 589 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2024-11-22 09:34:37' where traUID = 4713054941250260 and traStatus='V' and traEnabled=1 22/11/2024 09:43:05.8747 1280 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 22/11/2024 09:46:18.8550 2542 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 22/11/2024 09:49:30.0710 1093 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 22/11/2024 09:50:39.5545 750 ms. OPEN: select * from payCurInventory where curTerId = 3 and curQuantity>0 and curType in ('C','N') order by curDevCode,curChannelId,curValue 22/11/2024 09:54:05.9428 1094 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2024-11-22 09:54:04' where traUID = 5464918366230030 and traStatus='V' and traEnabled=1 22/11/2024 09:54:41.9559 1309 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-22 09:54:40','V',4847968934124060,2024,'2024-11-22 09:54:39','456163483600327005012999',2,2,2,'O','',0,'2024-11-22 09:54:40',1,'','0230003939927',164,0) 22/11/2024 09:54:44.8778 651 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 22/11/2024 09:57:28.2743 523 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2024-11-22 09:57:27',3,42101,0,50,-1,-50,1,'O','N'); update payCurInventory set curQuantity=round(curQuantity+-1,5),curAmount=round(curAmount+-50,5) where curTerId = 3 and curDevCode = 42101 and curChannelId = 1 and curValue = 50 and curType = 'N'; 22/11/2024 09:57:29.4731 1197 ms. EXEC: update payInventory set invCreation = '2024-11-22 09:57:28',invModify = '2024-11-22 09:57:28',invUseId=0,invStatus='V' where invId = 220710 22/11/2024 09:58:35.7485 664 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 22/11/2024 10:05:57.7995 1504 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 22/11/2024 10:08:23.0568 797 ms. EXEC: UPDATE payInventory SET invType='N' WHERE invType<>'N' AND invValue IN (100,200,500) AND invDevice IN (42102,42101,42001); 22/11/2024 10:09:32.6484 1010 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 22/11/2024 10:15:38.7026 766 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 22/11/2024 10:18:55.8137 730 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2024-11-22 10:18:54',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'; 22/11/2024 10:21:53.9931 1946 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 2 OR lnsTerId=2) 22/11/2024 10:23:52.0121 1014 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 22/11/2024 10:24:45.7432 2667 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 22/11/2024 10:27:27.9779 581 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 22/11/2024 10:28:50.0689 687 ms. EXEC: insert into movtransit (traUseId,traCreation,traStatus,traUID,traYear,traDateTime,traCode,traType,traClass,traIdTerminal,traDirection,traPlate,traEnabled,traDisableTime,traAreId,traNotes,traBadge,traTarId) VALUES (0,'2024-11-22 10:28:49','V',5059229556500550,2024,'2024-11-22 10:28:47','456163772700327005012999',1,2,16,'I','',1,0,1,'','',4) 22/11/2024 10:31:52.3200 588 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 22/11/2024 10:32:49.6934 819 ms. EXEC: insert into payReceipt (recTraUID,recPayUID,recYear,recDateTime,recText,recInvalid) VALUES (5182897996187490,5323271644791800,2024,'2024-11-22 10:32:48','---------------------------------- %The Mall P0006032390 End of payment ---------------------------------- POF Entry : 11/22/2024 10:16:47 AM Date : 11/22/2024 10:32:47 AM Code : 456163700700327001012999 Total : 50.00 KES VAT 16% : 6.90 KES ---------------------------------- Paid : 100.00 KES Coin changed : 0.00 KES Note changed : 50.00 KES',0) 22/11/2024 10:32:50.6141 817 ms. EXEC: update paycash set casCreation = '2024-11-22 10:32:49',casModify = '2024-11-22 10:32:49',casUseId=0,casStatus='V' where casId = 196189 22/11/2024 10:32:51.9349 709 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 22/11/2024 10:34:52.6098 721 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 22/11/2024 10:36:29.0975 818 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 22/11/2024 10:50:18.1740 773 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 5 and terStatus='V' 22/11/2024 10:52:16.8906 843 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 22/11/2024 10:54:45.5171 1904 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 22/11/2024 10:58:30.4879 580 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 22/11/2024 10:59:39.7643 846 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 22/11/2024 11:08:54.4520 523 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 2 OR lnsTerId=2) 22/11/2024 11:10:39.9887 640 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 22/11/2024 11:10:40.6131 620 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 22/11/2024 11:10:51.2212 1421 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 22/11/2024 11:16:32.0616 1046 ms. EXEC: update payInventory set invCreation = '2024-11-22 11:16:31',invModify = '2024-11-22 11:16:31',invUseId=0,invStatus='V' where invId = 220725 22/11/2024 11:24:10.9101 1047 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 22/11/2024 11:26:38.3859 589 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 22/11/2024 11:27:09.9751 1475 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 22/11/2024 11:28:35.7606 537 ms. EXEC: insert into paycash (casCreation,casModify,casUseId,casStatus,casUID,casTraUID,casYear,casDateTime,casIdTerminal,casCurrency,casNumber,casSingleAmount,casTotAmount,casType,casDescription) VALUES ('2024-11-22 11:28:35',0,0,'V',4912104299033760,5093662401517130,2024,'2024-11-22 11:28:35',3,'KES',1,100,100,'N',''); 22/11/2024 11:28:36.8603 907 ms. EXEC: update payInventory set invCreation = '2024-11-22 11:28:35',invModify = '2024-11-22 11:28:35',invUseId=0,invStatus='V' where invId = 220730 22/11/2024 11:28:37.5698 707 ms. EXEC: insert into paycash (casCreation,casModify,casUseId,casStatus,casUID,casTraUID,casYear,casDateTime,casIdTerminal,casCurrency,casNumber,casSingleAmount,casTotAmount,casType,casDescription) VALUES ('2024-11-22 11:28:36',0,0,'V',4912104299033760,5093662401517130,2024,'2024-11-22 11:28:36',3,'KES',-1,50,-50,'N',''); 22/11/2024 11:28:54.2009 860 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-22 11:28:53','V',4793356330781890,2024,'2024-11-22 11:28:52','456164133200327005012999',1,2,16,'I','',1,0,1,'','',4) 22/11/2024 11:31:40.6605 707 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-22 11:31:39','V',4836755599085790,2024,'2024-11-22 11:31:39','456163768400327005012999',2,2,2,'O','',0,'2024-11-22 11:31:39',1,'','',0) 22/11/2024 11:31:41.1008 525 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 22/11/2024 11:33:13.4116 681 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 3 and terStatus='V' 22/11/2024 11:33:35.0691 771 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 22/11/2024 11:39:18.3862 541 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 22/11/2024 11:40:13.2379 1350 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 22/11/2024 11:43:04.3476 576 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 22/11/2024 11:44:18.5693 677 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 3 22/11/2024 11:45:59.1097 588 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 22/11/2024 11:46:53.5972 735 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 22/11/2024 11:50:37.6253 690 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-22 11:50:36','V',4945717972203510,2024,'2024-11-22 11:50:35','456164088200327005012999',2,2,2,'O','',0,'2024-11-22 11:50:36',1,'','',0) 22/11/2024 11:51:59.0229 535 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2024-11-22 11:51:58' where payTraUID = 4699690805542190 and payStatus='V' and payEnabled=1 22/11/2024 11:54:14.4056 567 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 22/11/2024 11:54:36.8416 784 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 22/11/2024 11:58:00.9304 836 ms. EXEC: insert into movBarrier (barUseId,barCreation,barTerId,barAction,barDescription,barPlate) VALUES (1,'2024-11-22 11:58:00',9999,'open','Send command to entry/exit units: Command OPEN on Device Exit 1 ','') 22/11/2024 11:59:45.8907 900 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 22/11/2024 12:01:27.5118 685 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 22/11/2024 12:05:03.3054 699 ms. EXEC: update abbSubscriptions set subCredit = round(subCredit-0,5),subLastDebit = '2024-11-22 12:05:02' where subId = 21 22/11/2024 12:06:53.5533 576 ms. OPEN: select * from movtransit where trastatus='V' and (traCode = '456164166300327005012999') and traDirection='I' order by traId desc limit 1 22/11/2024 12:06:53.7474 1167 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 16 OR lnsTerId=16) 22/11/2024 12:08:36.7694 532 ms. EXEC: UPDATE payInventory SET invType='N' WHERE invType<>'N' AND invValue IN (100,200,500) AND invDevice IN (42102,42101,42001); 22/11/2024 12:17:42.6962 848 ms. EXEC: insert into movtransit (traUseId,traCreation,traStatus,traUID,traYear,traDateTime,traCode,traType,traClass,traIdTerminal,traDirection,traPlate,traEnabled,traDisableTime,traAreId,traNotes,traBadge,traTarId) VALUES (0,'2024-11-22 12:17:41','V',4909268834323090,2024,'2024-11-22 12:17:41','456163853700327005012999',2,2,2,'O','',0,'2024-11-22 12:17:41',1,'','',0) 22/11/2024 12:20:06.1163 874 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 22/11/2024 12:20:06.1173 1182 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 2 OR lnsTerId=2) 22/11/2024 12:20:37.8706 512 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 22/11/2024 12:21:29.1050 652 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 22/11/2024 12:22:18.4120 1124 ms. EXEC: UPDATE payInventory SET invType='N' WHERE invType<>'N' AND invValue IN (100,200,500) AND invDevice IN (42102,42101,42001); 22/11/2024 12:26:19.7237 605 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 22/11/2024 12:26:41.6844 641 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 22/11/2024 12:27:42.7343 565 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 22/11/2024 12:27:57.0639 1350 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 18 OR lnsTerId=18) 22/11/2024 12:28:04.0486 890 ms. EXEC: UPDATE payInventory SET invType='N' WHERE invType<>'N' AND invValue IN (100,200,500) AND invDevice IN (42102,42101,42001); 22/11/2024 12:28:06.1880 1053 ms. EXEC: update tabTerminalReceipt set trcProgressive = 7369, trcLastPrinted = '2400607369', trcLastDate = '2024-11-22 12:28:05' where trcStatus='V' and trcTerId = 17 22/11/2024 12:28:07.4519 924 ms. EXEC: update payReceipt set recCreation = '2024-11-22 12:28:06',recModify = '2024-11-22 12:28:06',recUseId=0,recStatus='V' where recId = 324914 22/11/2024 12:28:21.4132 708 ms. EXEC: insert into payReceipt (recTraUID,recPayUID,recYear,recDateTime,recText,recInvalid) VALUES (5718647751592370,4665385266400130,2024,'2024-11-22 12:28:20',' Date: 11/22/2024 12:25:29 PM Code: 456163965500327005012999 Entry Date: 11/22/2024 11:00:55 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 # 2400416519 ',0) 22/11/2024 12:28:35.4206 1386 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 2 22/11/2024 12:30:34.8416 2485 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 22/11/2024 12:33:59.1535 565 ms. OPEN: select * from tabArea where areStatus='V' and areEnabled = 1 AND areId = 1 22/11/2024 12:39:18.4405 700 ms. OPEN: show columns from tabTerminalReceipt where Field = 'trcHeader' 22/11/2024 12:40:26.7383 836 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 2 and terStatus='V' 22/11/2024 12:44:28.4702 660 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-22 12:44:27','V',5476971658420880,2024,'2024-11-22 12:44:26','456164360300327001012999',2,2,2,'O','',0,'2024-11-22 12:44:27',1,'','',0) 22/11/2024 12:47:54.1661 707 ms. EXEC: update tabTerminalReceipt set trcProgressive = 7371, trcLastPrinted = '2400607371', trcLastDate = '2024-11-22 12:47:53' where trcStatus='V' and trcTerId = 17 22/11/2024 12:47:54.2221 574 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-22 12:47:53',0,'V',4859734454160430,5667975330965490,2024,'2024-11-22 12:47:53',18,1,0,4,'2024-11-22 13:02:53','C','KES',100,100,0,'','','',1,100,0,0,'',0,0) 22/11/2024 12:49:00.4055 1537 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 22/11/2024 12:49:20.9562 2036 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 22/11/2024 12:49:25.3482 551 ms. EXEC: update abbSubscriptions set subCredit = round(subCredit-0,5),subLastDebit = '2024-11-22 12:49:24' where subId = 43 22/11/2024 12:50:47.1450 543 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 22/11/2024 12:52:54.9446 894 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-22 12:52:54','V',5476452490988380,2024,'2024-11-22 12:52:52','456164637200327005012999',1,2,16,'I','',1,0,1,'','',4) 22/11/2024 12:54:20.2418 515 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 22/11/2024 12:57:26.1854 676 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 22/11/2024 13:00:11.8314 717 ms. EXEC: insert into movtransit (traUseId,traCreation,traStatus,traUID,traYear,traDateTime,traCode,traType,traClass,traIdTerminal,traDirection,traPlate,traEnabled,traDisableTime,traAreId,traNotes,traBadge,traTarId) VALUES (0,'2024-11-22 13:00:11','V',5455587616247510,2024,'2024-11-22 13:00:10','456164681000327005012999',1,2,16,'I','',1,0,1,'','',4) 22/11/2024 13:01:23.4624 1148 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2024-11-22 13:01:22',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'; 22/11/2024 13:01:24.0037 510 ms. EXEC: insert into paycash (casCreation,casModify,casUseId,casStatus,casUID,casTraUID,casYear,casDateTime,casIdTerminal,casCurrency,casNumber,casSingleAmount,casTotAmount,casType,casDescription) VALUES ('2024-11-22 13:01:23',0,0,'V',4679192696813640,5516920887326590,2024,'2024-11-22 13:01:23',3,'KES',-1,50,-50,'N',''); 22/11/2024 13:01:24.8633 623 ms. EXEC: update payInventory set invCreation = '2024-11-22 13:01:24',invModify = '2024-11-22 13:01:24',invUseId=0,invStatus='V' where invId = 220754 22/11/2024 13:01:32.8056 548 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2024-11-22 13:01:32' where payTraUID = 5298285077699080 and payStatus='V' and payEnabled=1 22/11/2024 13:02:23.6997 609 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 17 OR lnsTerId=17) 22/11/2024 13:07:01.1166 519 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 22/11/2024 13:08:06.1362 746 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 22/11/2024 13:12:28.1317 625 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 22/11/2024 13:16:26.8697 1008 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2024-11-22 13:16:25',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'; 22/11/2024 13:22:04.1337 806 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 22/11/2024 13:22:04.6981 549 ms. EXECSCALAR: select count(0) as vTot from tabParameters where parPlateReading<>0 nr: 0 22/11/2024 13:24:44.3851 534 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 22/11/2024 13:24:48.8731 762 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-22 13:24:48',0,'V',5449507436924040,5758722737685530,2024,'2024-11-22 13:24:48',18,1,0,4,'2024-11-22 13:39:48','C','KES',50,50,0,'','','',1,50,0,0,'',0,0) 22/11/2024 13:26:10.2356 591 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 22/11/2024 13:26:15.2860 536 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 22/11/2024 13:26:34.3668 957 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-22 13:26:33',0,'V',5348460554514440,4849693817671220,2024,'2024-11-22 13:26:33',18,1,0,4,'2024-11-22 13:41:33','C','KES',200,200,0,'','','',1,200,0,0,'',0,0) 22/11/2024 13:27:11.4947 828 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 22/11/2024 13:28:37.7485 1554 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 22/11/2024 13:29:06.7619 805 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-22 13:29:05','V',5003264835864060,2024,'2024-11-22 13:29:05','456164854500327005012999',1,2,16,'I','',1,0,1,'','',4) 22/11/2024 13:29:37.9948 677 ms. EXEC: UPDATE payInventory SET invType='N' WHERE invType<>'N' AND invValue IN (100,200,500) AND invDevice IN (42102,42101,42001); 22/11/2024 13:30:07.8338 778 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 2 OR lnsTerId=2) 22/11/2024 13:30:50.6275 556 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 22/11/2024 13:30:52.6949 987 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 3 OR lnsTerId=3) 22/11/2024 13:31:41.8808 1822 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 22/11/2024 13:34:46.5926 706 ms. EXEC: UPDATE payInventory SET invType='N' WHERE invType<>'N' AND invValue IN (100,200,500) AND invDevice IN (42102,42101,42001); 22/11/2024 13:35:24.3029 1302 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 22/11/2024 13:35:44.4934 618 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 22/11/2024 13:35:45.3440 683 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 3 22/11/2024 13:36:53.1104 674 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 22/11/2024 13:36:53.9600 1111 ms. EXEC: UPDATE payInventory SET invType='N' WHERE invType<>'N' AND invValue IN (100,200,500) AND invDevice IN (42102,42101,42001); 22/11/2024 13:38:59.9614 646 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 22/11/2024 13:40:07.4386 595 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 22/11/2024 13:40:25.2245 541 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 1 22/11/2024 13:41:09.3061 513 ms. OPEN: select * from tabArea where areStatus='V' and areEnabled = 1 AND areId = 1 22/11/2024 13:41:48.6524 503 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 22/11/2024 13:44:10.1552 1743 ms. EXECSCALAR: select count(resId) as Tot from movReservation where resStatus = 'V' and resTypeRes = 'B' AND ((resConfirmed IN (0,2,3) AND resCreation>'2024-11-22 12:44:08') OR resConfirmed IN (4,5)) and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) <= '2024-11-22 13:44:08' and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) >= '2024-11-22 13:44:08' and (resAreId = 1 or resAreId <= 0) nr: 0 22/11/2024 13:44:10.2703 1624 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 22/11/2024 13:44:10.4324 2078 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 22/11/2024 13:44:57.3949 1422 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 3 22/11/2024 13:46:03.3891 1898 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 22/11/2024 13:46:35.0363 542 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 22/11/2024 13:47:13.4931 662 ms. EXEC: update payReceipt set recCreation = '2024-11-22 13:47:12',recModify = '2024-11-22 13:47:12',recUseId=0,recStatus='V' where recId = 324955 22/11/2024 13:47:33.7587 1141 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2024-11-22 13:47:32' where payTraUID = 5519973917547130 and payStatus='V' and payEnabled=1 22/11/2024 13:48:05.8031 950 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-22 13:48:04','V',5508526574999620,2024,'2024-11-22 13:48:04','456164968400327005012999',1,2,16,'I','',1,0,1,'','',4) 22/11/2024 13:48:06.5977 625 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 22/11/2024 13:50:49.8941 1236 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 22/11/2024 13:51:35.9540 1189 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 22/11/2024 13:52:41.5739 782 ms. EXEC: UPDATE payInventory SET invType='N' WHERE invType<>'N' AND invValue IN (100,200,500) AND invDevice IN (42102,42101,42001); 22/11/2024 13:52:44.1737 902 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-22 13:52:43','V',5226317873597650,2024,'2024-11-22 13:52:41','456164475300327005012999',2,2,2,'O','',0,'2024-11-22 13:52:43',1,'','',0) 22/11/2024 13:52:45.7467 1537 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 22/11/2024 13:52:47.3588 1600 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 22/11/2024 13:52:49.1600 566 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 22/11/2024 13:52:57.7668 1733 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-22 13:50:05',6,'V',5486329688133680,5372516346214230,2024,'2024-11-22 13:50:05',4,1,0,4,'2024-11-22 14:05:05','P','KES',50,50,0,'','','',1,50,0,0,'',0,0) 22/11/2024 13:52:57.9599 580 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-22 13:52:57','V',5620601109209290,2024,'2024-11-22 13:52:56','456164997600327005012999',1,2,16,'I','',1,0,1,'','',4) 22/11/2024 13:52:58.3462 504 ms. EXEC: insert into movOperator (opeCreation,opeTerId,opeUseId,opeDateTime,opeCode,opeDescription) VALUES ('2024-11-22 13:52:57',4,6,'2024-11-22 13:52:57','456164837400327005012999','Payed (Credit Card ) Ticket ') 22/11/2024 13:52:58.4903 522 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 22/11/2024 13:52:59.8021 716 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 (WAIT TIME 251 ms.) 22/11/2024 13:52:59.8041 717 ms. EXEC: insert into payReceipt (recTraUID,recPayUID,recYear,recDateTime,recText,recInvalid) VALUES (5372516346214230,5486329688133680,2024,'2024-11-22 13:52:59',' Date: 11/22/2024 1:50:05 PM Code: 456164837400327005012999 Entry Date: 11/22/2024 1:26:14 PM Plate: Class: Cars Park: The Mall Gate: Entry 2 ______________________________ Total: 50.00 KES ______________________________ Paid: 50.00 KES __________ Change: 0.00 KES Type: Credit Card Dispozitiv: Manual Cashier 1 # 2400416527 ',0) (WAIT TIME 76 ms.) 22/11/2024 13:53:00.0313 1613 ms. EXEC: insert into payReceipt (recTraUID,recPayUID,recYear,recDateTime,recText,recInvalid) VALUES (5739650059987750,4922163263538020,2024,'2024-11-22 13:52:58','---------------------------------- %The Mall P0006032390 End of payment ---------------------------------- POF Entry : 11/22/2024 1:46:01 PM Date : 11/22/2024 1:52:57 PM Code : 456164956100327005012999 Total : 50.00 KES VAT 16% : 6.90 KES ---------------------------------- Paid : 50.00 KES Coin changed : 0.00 KES Note changed : 0.00 KES',0) 22/11/2024 13:53:01.5183 626 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2024-11-22 13:53:00',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'; 22/11/2024 13:54:44.2541 539 ms. EXEC: insert into movtransit (traUseId,traCreation,traStatus,traUID,traYear,traDateTime,traCode,traType,traClass,traIdTerminal,traDirection,traPlate,traEnabled,traDisableTime,traAreId,traNotes,traBadge,traTarId) VALUES (0,'2024-11-22 13:54:43','V',5151314019155080,2024,'2024-11-22 13:54:41','456164956100327005012999',2,2,2,'O','',0,'2024-11-22 13:54:43',1,'','',0) 22/11/2024 13:54:48.3239 773 ms. EXEC: UPDATE payInventory SET invType='N' WHERE invType<>'N' AND invValue IN (100,200,500) AND invDevice IN (42102,42101,42001); 22/11/2024 13:55:09.8993 1620 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 22/11/2024 13:55:18.7933 974 ms. EXEC: insert into payReceipt (recTraUID,recPayUID,recYear,recDateTime,recText,recInvalid) VALUES (5585774676509360,4892741652320990,2024,'2024-11-22 13:55:17','---------------------------------- %The Mall P0006032390 End of payment ---------------------------------- POF Entry : 11/22/2024 12:12:37 PM Date : 11/22/2024 1:55:17 PM Code : 456164395700327005012999 Total : 100.00 KES VAT 16% : 13.79 KES ---------------------------------- Paid : 100.00 KES Coin changed : 0.00 KES Note changed : 0.00 KES',0) 22/11/2024 13:55:19.7960 634 ms. EXEC: update paycash set casCreation = '2024-11-22 13:55:19',casModify = '2024-11-22 13:55:19',casUseId=0,casStatus='V' where casId = 196235 22/11/2024 13:55:26.4324 1891 ms. EXEC: update payReceipt set recCreation = '2024-11-22 13:55:24',recModify = '2024-11-22 13:55:24',recUseId=0,recStatus='V' where recId = 324959 22/11/2024 13:55:53.6747 605 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 22/11/2024 13:55:56.2094 1277 ms. EXEC: insert into movtransit (traUseId,traCreation,traStatus,traUID,traYear,traDateTime,traCode,traType,traClass,traIdTerminal,traDirection,traPlate,traEnabled,traDisableTime,traAreId,traNotes,traBadge,traTarId) VALUES (0,'2024-11-22 13:55:54','V',4833823579581550,2024,'2024-11-22 13:55:53','456165015300327005012999',1,2,16,'I','',1,0,1,'','',4) 22/11/2024 13:56:13.9152 692 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 22/11/2024 13:56:51.3123 778 ms. EXEC: UPDATE payInventory SET invType='N' WHERE invType<>'N' AND invValue IN (100,200,500) AND invDevice IN (42102,42101,42001); 22/11/2024 13:58:39.5608 1063 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 22/11/2024 13:59:00.5749 1429 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 22/11/2024 13:59:30.1427 671 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2024-11-22 13:59:29' where traUID = 5544398714621430 and traStatus='V' and traEnabled=1 22/11/2024 13:59:57.4740 542 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 1 22/11/2024 14:01:39.2432 1112 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 22/11/2024 14:02:40.3301 2110 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 22/11/2024 14:09:50.6825 589 ms. EXEC: update paycash set casCreation = '2024-11-22 14:09:50',casModify = '2024-11-22 14:09:50',casUseId=0,casStatus='V' where casId = 196236 22/11/2024 14:16:12.1541 938 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 (WAIT TIME 1 ms.) 22/11/2024 14:20:23.5806 592 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 22/11/2024 14:23:11.5171 860 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 22/11/2024 14:27:49.2522 1214 ms. EXEC: insert into payReceipt (recTraUID,recPayUID,recYear,recDateTime,recText,recInvalid) VALUES (4760530418493020,4766136830875110,2024,'2024-11-22 14:27:48',' Date: 11/22/2024 2:27:47 PM Code: 456164119600327005012999 Entry Date: 11/22/2024 11:26:36 AM Plate: Class: Cars Park: The Mall Gate: Entry 2 ______________________________ Total: 200.00 KES ______________________________ Paid: 200.00 KES __________ Change: 0.00 KES Type: Cash Dispozitiv: MPESA # 2400750557 ',0) 22/11/2024 14:27:50.7222 1468 ms. EXEC: update payReceipt set recCreation = '2024-11-22 14:27:49',recModify = '2024-11-22 14:27:49',recUseId=0,recStatus='V' where recId = 324971 22/11/2024 14:27:57.9721 786 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 22/11/2024 14:29:57.3911 803 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 22/11/2024 14:30:08.3124 1031 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 22/11/2024 14:30:45.8536 687 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2024-11-22 14:30:45' where traUID = 5044127982143260 and traStatus='V' and traEnabled=1 22/11/2024 14:32:17.2668 1130 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 2 OR lnsTerId=2) 22/11/2024 14:32:17.6651 911 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 22/11/2024 14:32:36.7279 663 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 22/11/2024 14:33:22.4425 693 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 22/11/2024 14:33:43.9529 1053 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 22/11/2024 14:34:15.1428 519 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2024-11-22 14:34:14' where traUID = 5118662839062890 and traStatus='V' and traEnabled=1 22/11/2024 14:37:43.6816 615 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 22/11/2024 14:39:36.3701 1000 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-22 14:39:35','V',5582532198460650,2024,'2024-11-22 14:39:34','456164644100327005012999',2,2,2,'O','',0,'2024-11-22 14:39:35',1,'','',0) 22/11/2024 14:39:43.8751 1254 ms. EXECSCALAR: select count(*) from information_schema.tables where table_schema= 'wisepark_0327' and table_name= 'payInvoiceFtp' nr: 1 22/11/2024 14:39:52.8961 1145 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 22/11/2024 14:44:50.8878 980 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 22/11/2024 14:45:37.6582 655 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 22/11/2024 14:52:08.3129 732 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 22/11/2024 14:57:14.8083 695 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 22/11/2024 15:01:28.2852 1065 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 22/11/2024 15:01:55.3063 645 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 22/11/2024 15:03:38.0641 572 ms. EXEC: insert into paycash (casCreation,casModify,casUseId,casStatus,casUID,casTraUID,casYear,casDateTime,casIdTerminal,casCurrency,casNumber,casSingleAmount,casTotAmount,casType,casDescription) VALUES ('2024-11-22 15:03:37',0,0,'V',5025126317087000,5122337772896560,2024,'2024-11-22 15:03:37',3,'KES',1,100,100,'N',''); 22/11/2024 15:03:38.7115 647 ms. EXEC: update paycash set casCreation = '2024-11-22 15:03:38',casModify = '2024-11-22 15:03:38',casUseId=0,casStatus='V' where casId = 196248 22/11/2024 15:05:22.4100 766 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 22/11/2024 15:05:23.2636 682 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2024-11-22 15:05:22' where traUID = 5122337772896560 and traStatus='V' and traEnabled=1 22/11/2024 15:09:08.0022 947 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-22 15:09:07','V',5491519541357890,2024,'2024-11-22 15:09:06','456165454600327005012999',1,2,16,'I','',1,0,1,'','',4) 22/11/2024 15:09:08.9849 709 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 22/11/2024 15:10:05.7249 551 ms. EXECSCALAR: select count(*) from information_schema.tables where table_schema= 'wisepark_0327' and table_name= 'payInvoiceFtp' nr: 1 22/11/2024 15:11:12.0883 985 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 22/11/2024 15:11:54.8380 659 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 22/11/2024 15:13:14.1241 692 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 22/11/2024 15:15:20.3797 1835 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 22/11/2024 15:16:53.0418 787 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 22/11/2024 15:17:09.4758 2467 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 17 OR lnsTerId=17) 22/11/2024 15:17:09.4788 2360 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 22/11/2024 15:18:22.4057 579 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 22/11/2024 15:19:47.1074 734 ms. EXEC: update payReceipt set recCreation = '2024-11-22 15:19:46',recModify = '2024-11-22 15:19:46',recUseId=0,recStatus='V' where recId = 325002 22/11/2024 15:20:15.9758 772 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2024-11-22 15:20:14',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'; 22/11/2024 15:20:37.9105 795 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 16 OR lnsTerId=16) 22/11/2024 15:22:57.8813 1641 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 22/11/2024 15:23:58.9412 592 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 22/11/2024 15:24:04.0706 652 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 22/11/2024 15:26:32.8273 766 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 22/11/2024 15:28:11.2853 1230 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 22/11/2024 15:28:32.5415 907 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 22/11/2024 15:29:05.0123 915 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 22/11/2024 15:29:23.6458 596 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 22/11/2024 15:32:01.4935 2029 ms. EXEC: insert into payReceipt (recTraUID,recPayUID,recYear,recDateTime,recText,recInvalid) VALUES (5684354709201230,5562432985400590,2024,'2024-11-22 15:31:59','---------------------------------- %The Mall P0006032390 End of payment ---------------------------------- POF Entry : 11/22/2024 1:35:55 PM Date : 11/22/2024 3:31:56 PM Code : 456164895500327005012999 Total : 100.00 KES VAT 16% : 13.79 KES ---------------------------------- Paid : 100.00 KES Coin changed : 0.00 KES Note changed : 0.00 KES',0) 22/11/2024 15:33:27.0699 987 ms. EXEC: insert into payReceipt (recTraUID,recPayUID,recYear,recDateTime,recText,recInvalid) VALUES (5630767801372680,5257338421138150,2024,'2024-11-22 15:33:26','---------------------------------- %The Mall P0006032390 End of payment ---------------------------------- POF Entry : 11/22/2024 3:14:23 PM Date : 11/22/2024 3:33:24 PM Code : 456165486300327005012999 Total : 50.00 KES VAT 16% : 6.90 KES ---------------------------------- Paid : 100.00 KES Coin changed : 0.00 KES Note changed : 50.00 KES',0) 22/11/2024 15:33:36.9405 597 ms. EXEC: INSERT INTO movOperator (opeCreation,opeUseId,opeTerId,opeDateTime,opeCode,opeDescription) VALUES ('2024-11-22 15:33:36',0,16,'2024-11-22 15:33:36','','Unauthorized Transit Entry 2') 22/11/2024 15:35:22.2851 639 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 22/11/2024 15:35:52.2402 638 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 22/11/2024 15:37:04.1363 797 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 22/11/2024 15:37:33.9243 1284 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-22 15:37:32','V',5083102876140170,2024,'2024-11-22 15:37:31','456165391000327005012999',2,2,2,'O','',0,'2024-11-22 15:37:32',1,'','',0) 22/11/2024 15:39:18.4704 1037 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 22/11/2024 15:39:18.6855 1286 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 2 OR lnsTerId=2) 22/11/2024 15:46:57.9462 567 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 22/11/2024 15:46:59.2121 523 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 22/11/2024 15:48:11.9068 903 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 22/11/2024 15:49:29.3947 814 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 22/11/2024 15:49:57.1243 1199 ms. EXECSCALAR: select count(*) from information_schema.tables where table_schema= 'wisepark_0327' and table_name= 'payInvoiceFtp' nr: 1 22/11/2024 15:58:07.8081 882 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 2 OR lnsTerId=2) 22/11/2024 16:00:00.0353 996 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 22/11/2024 16:00:42.0314 1285 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 2 OR lnsTerId=2) 22/11/2024 16:02:09.8203 1394 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 22/11/2024 16:07:24.4261 606 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 22/11/2024 16:10:21.9180 1700 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 22/11/2024 16:12:07.0585 597 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-22 16:12:06',0,'V',5736796024912120,5059229556500550,2024,'2024-11-22 16:12:06',18,1,0,4,'2024-11-22 16:27:06','C','KES',400,400,0,'','','',1,400,0,0,'',0,0) 22/11/2024 16:12:07.7719 532 ms. EXEC: update payReceipt set recCreation = '2024-11-22 16:12:07',recModify = '2024-11-22 16:12:07',recUseId=0,recStatus='V' where recId = 325027 22/11/2024 16:12:30.0128 644 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 22/11/2024 16:14:47.7331 1428 ms. EXEC: UPDATE payInventory SET invType='N' WHERE invType<>'N' AND invValue IN (100,200,500) AND invDevice IN (42102,42101,42001); 22/11/2024 16:15:07.9987 964 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-22 16:15:06',0,'V',5103533497265860,5225285771075360,2024,'2024-11-22 16:15:06',18,1,0,4,'2024-11-22 16:30:06','C','KES',50,50,0,'','','',1,50,0,0,'',0,0) 22/11/2024 16:16:49.7959 1934 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 22/11/2024 16:16:49.7969 1994 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 2 OR lnsTerId=2) 22/11/2024 16:19:27.4866 641 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 22/11/2024 16:20:01.0150 511 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 22/11/2024 16:24:52.7022 726 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 22/11/2024 16:25:40.1660 880 ms. EXEC: insert into payReceipt (recTraUID,recPayUID,recYear,recDateTime,recText,recInvalid) VALUES (5427926231789030,4658559696444020,2024,'2024-11-22 16:25:39',' Data: 11/22/2024 4:23:12 PM Codice: 456165600200327005012999 Ingresso: 11/22/2024 3:33:22 PM Targa: Categoria: Cars Area: The Mall Varco: Entry 2 ______________________________ Da Pagare: 50.00 KES ______________________________ Pagato: 50.00 KES __________ Resto: 0.00 KES Tipo: Contanti Pagato su: Manual Cashier 2 # 2400607390 ',0) 22/11/2024 16:26:40.2313 1613 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 22/11/2024 16:26:53.5452 1507 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-22 16:26:51',0,'V',5362256522358130,5663874857935020,2024,'2024-11-22 16:26:51',3,1,0,4,'2024-11-22 16:41:51','C','KES',50,50,0,'',' ',' ',1,50,0,0,'',0,0) 22/11/2024 16:26:54.2286 663 ms. EXEC: insert into payReceipt (recTraUID,recPayUID,recYear,recDateTime,recText,recInvalid) VALUES (5663874857935020,5362256522358130,2024,'2024-11-22 16:26:53','---------------------------------- %The Mall P0006032390 End of payment ---------------------------------- POF Entry : 11/22/2024 3:57:57 PM Date : 11/22/2024 4:26:51 PM Code : 456165747700327005012999 Total : 50.00 KES VAT 16% : 6.90 KES ---------------------------------- Paid : 50.00 KES Coin changed : 0.00 KES Note changed : 0.00 KES',0) 22/11/2024 16:29:24.2322 802 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 5 and terStatus='V' 22/11/2024 16:29:41.1965 1496 ms. EXECSCALAR: select count(*) from information_schema.tables where table_schema= 'wisepark_0327' and table_name= 'payInvoiceFtp' nr: 1 22/11/2024 16:30:56.6411 518 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); 22/11/2024 16:31:29.1008 1002 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2024-11-22 16:31:28' where traUID = 4650180389426420 and traStatus='V' and traEnabled=1 22/11/2024 16:32:01.2083 504 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 22/11/2024 16:33:57.7494 1891 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2024-11-22 16:33:55' where traUID = 5434365858573830 and traStatus='V' and traEnabled=1 22/11/2024 16:35:04.4751 771 ms. EXEC: insert into abbPayment (payCreation,payCode,payAmount,payCredit,payPayUID,payCarId,payDateFrom,payDateTo) VALUES ('2024-11-22 16:35:03','0810007086215',0,0,5688149987175340,125,'0000-00-00 00:00:00','0000-00-00 00:00:00') 22/11/2024 16:36:03.0814 750 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 22/11/2024 16:44:07.1472 722 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 22/11/2024 16:47:04.3159 854 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 22/11/2024 16:48:29.4470 820 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 22/11/2024 16:48:35.1218 516 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 4 22/11/2024 16:51:32.0323 1569 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 22/11/2024 16:55:09.7172 829 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 22/11/2024 16:56:09.6543 586 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 22/11/2024 16:56:42.6504 560 ms. EXEC: update payReceipt set recCreation = '2024-11-22 16:56:42',recModify = '2024-11-22 16:56:42',recUseId=0,recStatus='V' where recId = 325050 22/11/2024 16:56:45.0451 1718 ms. EXEC: update paycash set casCreation = '2024-11-22 16:56:43',casModify = '2024-11-22 16:56:43',casUseId=0,casStatus='V' where casId = 196278 22/11/2024 16:59:11.5362 739 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 22/11/2024 16:59:11.5402 739 ms. OPEN: select * from tabArea where areStatus='V' and areEnabled = 1 AND areId = 1 22/11/2024 17:02:46.4562 714 ms. EXEC: insert into payPayment (payCreation,payUseId,payStatus,payUID,payTraUID,payYear,payDateTime,payIdTerminal,payEnabled,payDisableTime,payTarId,payTimeLimit,payType,payCurrency,payAmount,payPayed,payChange,payCardType,payPAN,paySTAN,payIdEvent,payAmountCalc,payDiscountValue,payDiscount,payDiscountType,payVatPercent,payVatAmount) VALUES ('2024-11-22 17:02:45',0,'V',4645387694991090,5429607939295850,2024,'2024-11-22 17:02:45',18,1,0,4,'2024-11-22 17:17:45','C','KES',50,50,0,'','','',1,50,0,0,'',0,0) 22/11/2024 17:03:57.1806 551 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 22/11/2024 17:06:10.8602 1364 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-22 17:06:09','V',5112681816330000,2024,'2024-11-22 17:06:08','456166156800327005012999',1,2,16,'I','',1,0,1,'','',4) 22/11/2024 17:10:26.9028 3494 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 (WAIT TIME 47 ms.) 22/11/2024 17:11:06.3782 2614 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-22 17:11:03','V',4917789258901950,2024,'2024-11-22 17:11:03','456166186300327005012999',1,2,16,'I','',1,0,1,'','',4) 22/11/2024 17:14:48.8133 512 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 1 22/11/2024 17:15:35.4015 2848 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 22/11/2024 17:15:54.6264 2577 ms. EXECSCALAR: select count(*) from information_schema.tables where table_schema= 'wisepark_0327' and table_name= 'payInvoiceFtp' nr: 1 22/11/2024 17:16:11.3926 4527 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-22 17:16:06','V',4620884512649180,2024,'2024-11-22 17:16:06','456166216600327005012999',1,2,16,'I','',1,0,1,'','',4) 22/11/2024 17:16:58.1659 1607 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 22/11/2024 17:17:46.6724 862 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 22/11/2024 17:19:18.8802 2135 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 22/11/2024 17:19:58.7670 1564 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 22/11/2024 17:22:11.9352 793 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 22/11/2024 17:22:49.8096 1823 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 22/11/2024 17:23:36.7030 1721 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 2 OR lnsTerId=2) 22/11/2024 17:26:10.7642 1374 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-22 17:26:09','V',4747922941851750,2024,'2024-11-22 17:26:08','456166276800327005012999',1,2,16,'I','',1,0,1,'','',4) 22/11/2024 17:26:14.1405 1921 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 5 22/11/2024 17:27:08.2998 2952 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 1 22/11/2024 17:31:40.2650 845 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 22/11/2024 17:33:13.9038 657 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 22/11/2024 17:40:09.9988 588 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 22/11/2024 17:43:25.3546 582 ms. EXECSCALAR: select count(0) as vTot from tabParameters where parPlateReading<>0 nr: 0 22/11/2024 17:51:07.0859 1007 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-22 17:51:06','V',5106759599118780,2024,'2024-11-22 17:51:04','456166240800327001012999',2,2,2,'O','',0,'2024-11-22 17:51:06',1,'','',0) 22/11/2024 17:54:33.7603 1167 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 22/11/2024 17:59:44.0512 1000 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 22/11/2024 18:03:27.8341 563 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 22/11/2024 18:03:41.5092 1101 ms. EXEC: update abbSubscriptions set subCredit = round(subCredit-0,5),subLastDebit = '2024-11-22 18:03:40' where subId = 16 22/11/2024 18:06:26.2316 599 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 22/11/2024 18:08:04.9387 1495 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 22/11/2024 18:12:51.8067 841 ms. EXEC: update payReceipt set recCreation = '2024-11-22 18:12:50',recModify = '2024-11-22 18:12:50',recUseId=0,recStatus='V' where recId = 325082 22/11/2024 18:18:32.2035 547 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 22/11/2024 18:22:28.5146 2167 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 22/11/2024 18:22:43.6437 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-22 18:22:42','V',5345112441198710,2024,'2024-11-22 18:22:42','456166616200327005012999',1,2,16,'I','',1,0,1,'','',4) 22/11/2024 18:23:56.6636 1020 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 22/11/2024 18:24:06.6783 831 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 22/11/2024 18:24:57.0630 2763 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 22/11/2024 18:27:31.8295 1599 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 1 22/11/2024 18:27:54.4707 1275 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 1 and terStatus='V' 22/11/2024 18:28:00.3817 1191 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 5 and terStatus='V' 22/11/2024 18:31:20.6228 1028 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 22/11/2024 18:31:21.7035 3621 ms. EXEC: INSERT INTO movOperator (opeCreation,opeUseId,opeTerId,opeDateTime,opeCode,opeDescription) VALUES ('2024-11-22 18:31:18',0,16,'2024-11-22 18:31:18','','Unauthorized Transit Entry 2') 22/11/2024 18:32:27.8588 645 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-22 18:32:27','V',5616123079370640,2024,'2024-11-22 18:32:24','456166674400327005012999',1,2,16,'I','',1,0,1,'','',4) 22/11/2024 18:33:31.1642 2502 ms. EXECSCALAR: select count(*) from information_schema.tables where table_schema= 'wisepark_0327' and table_name= 'payInvoiceFtp' nr: 1 22/11/2024 18:35:01.5988 1673 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 22/11/2024 18:35:02.0321 1863 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 5 22/11/2024 18:35:32.8517 670 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 22/11/2024 18:36:07.0166 690 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 22/11/2024 18:36:20.2775 1901 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 1 22/11/2024 18:38:17.5230 549 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 3 22/11/2024 18:38:32.6812 2481 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 22/11/2024 18:38:33.5938 613 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 22/11/2024 18:39:07.3994 1028 ms. EXEC: UPDATE payInventory SET invType='N' WHERE invType<>'N' AND invValue IN (100,200,500) AND invDevice IN (42102,42101,42001); 22/11/2024 18:40:02.9396 1938 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 22/11/2024 18:40:15.7072 2749 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 22/11/2024 18:48:44.3819 882 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 22/11/2024 18:53:01.4070 1248 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-22 18:53:00','V',5150857174052570,2024,'2024-11-22 18:52:59','456166628000327001012999',2,2,2,'O','',0,'2024-11-22 18:53:00',1,'','',0) 22/11/2024 18:53:04.0088 2597 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 22/11/2024 18:53:38.1827 723 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 22/11/2024 18:59:28.2071 762 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 22/11/2024 19:01:15.6151 948 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 22/11/2024 19:02:19.4498 523 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2024-11-22 19:02:18',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-22 19:02:18',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'; 22/11/2024 19:04:21.5485 871 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 22/11/2024 19:05:54.3367 501 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 22/11/2024 19:10:00.1132 529 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 22/11/2024 19:11:02.0607 630 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 22/11/2024 19:11:59.3690 714 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 22/11/2024 19:13:27.1938 504 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 22/11/2024 19:19:04.6918 1813 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 22/11/2024 19:20:45.3892 636 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 22/11/2024 19:21:18.6485 625 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 22/11/2024 19:22:14.6920 1255 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 22/11/2024 19:22:21.6156 740 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 22/11/2024 19:23:54.2857 698 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 22/11/2024 19:24:21.9912 677 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-22 19:24:21',0,'V',4871328576585170,5541875968523210,2024,'2024-11-22 19:24:21',2,1,0,-1,'2024-11-22 20:24:21','S','KES',0,0,0,'','','',3,0,0) 22/11/2024 19:33:01.2839 583 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 22/11/2024 19:37:08.7496 1455 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 22/11/2024 19:40:37.9196 528 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 22/11/2024 19:42:23.5824 1212 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 22/11/2024 19:44:18.2081 930 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-22 19:44:17','V',5316297437118610,2024,'2024-11-22 19:44:16','456162182600327005012999',2,2,2,'O','',0,'2024-11-22 19:44:17',1,'','0560008516054',163,0) 22/11/2024 19:47:10.4344 921 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 22/11/2024 19:53:48.3648 579 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 22/11/2024 19:54:50.9057 533 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 2 22/11/2024 19:55:17.2654 1036 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-22 19:55:16',0,'V',5211139023557950,5202704938330500,2024,'2024-11-22 19:55:16',18,1,0,4,'2024-11-22 20:10:16','C','KES',50,50,0,'','','',1,50,0,0,'',0,0) 22/11/2024 19:55:31.0036 529 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 2 and terStatus='V' 22/11/2024 19:55:31.2357 777 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 22/11/2024 19:56:05.2035 2059 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 2 OR lnsTerId=2) 22/11/2024 19:56:05.2065 1862 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 22/11/2024 19:56:39.7646 636 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 22/11/2024 19:56:46.1009 700 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 2 OR lnsTerId=2) 22/11/2024 19:56:46.2720 648 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 22/11/2024 19:57:21.4565 559 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-22 19:57:20',0,'V',5749675044485570,5451255922171160,2024,'2024-11-22 19:57:20',18,1,0,4,'2024-11-22 20:12:20','C','KES',100,100,0,'','','',1,100,0,0,'',0,0) 22/11/2024 19:57:59.4610 528 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 22/11/2024 19:58:21.9751 2351 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 22/11/2024 19:59:19.0313 676 ms. EXEC: insert into payReceipt (recTraUID,recPayUID,recYear,recDateTime,recText,recInvalid) VALUES (5704109841588210,5433934726717320,2024,'2024-11-22 19:59:18','---------------------------------- %The Mall P0006032390 End of payment ---------------------------------- POF Entry : 11/22/2024 7:08:07 PM Date : 11/22/2024 7:59:16 PM Code : 456166888700327005012999 Total : 50.00 KES VAT 16% : 6.90 KES ---------------------------------- Paid : 50.00 KES Coin changed : 0.00 KES Note changed : 0.00 KES',0) 22/11/2024 19:59:44.5393 677 ms. EXEC: UPDATE payInventory SET invType='N' WHERE invType<>'N' AND invValue IN (100,200,500) AND invDevice IN (42102,42101,42001); 22/11/2024 20:02:08.4957 738 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 22/11/2024 20:02:13.3620 760 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 22/11/2024 20:03:15.7178 997 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 22/11/2024 20:04:47.8875 787 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 22/11/2024 20:06:08.2073 566 ms. EXEC: update paycash set casCreation = '2024-11-22 20:06:07',casModify = '2024-11-22 20:06:07',casUseId=0,casStatus='V' where casId = 196310 22/11/2024 20:06:09.2459 1038 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2024-11-22 20:06:07',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'; 22/11/2024 20:06:28.7490 686 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 22/11/2024 20:06:36.7584 639 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 22/11/2024 20:06:39.3441 2259 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2024-11-22 20:06:37' where payTraUID = 5232642969782560 and payStatus='V' and payEnabled=1 22/11/2024 20:07:01.6260 716 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 22/11/2024 20:10:13.1893 876 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 22/11/2024 20:18:10.7181 552 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 22/11/2024 20:19:07.7663 552 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 16 OR lnsTerId=16) 22/11/2024 20:19:44.5719 1097 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 22/11/2024 20:21:54.0746 807 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 22/11/2024 20:22:51.8113 1480 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 22/11/2024 20:24:57.0201 516 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 22/11/2024 20:27:10.7457 534 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 22/11/2024 20:27:42.1958 836 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 22/11/2024 20:31:13.0050 1110 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 22/11/2024 20:35:34.5922 803 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 22/11/2024 20:38:59.0212 527 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 22/11/2024 20:43:02.2261 533 ms. EXEC: insert into payReceipt (recTraUID,recPayUID,recYear,recDateTime,recText,recInvalid) VALUES (4730131358024300,4856785638687670,2024,'2024-11-22 20:43:01','---------------------------------- %The Mall P0006032390 End of payment ---------------------------------- POF Entry : 11/22/2024 8:03:49 PM Date : 11/22/2024 8:42:59 PM Code : 456167222900327005012999 Total : 50.00 KES VAT 16% : 6.90 KES ---------------------------------- Paid : 100.00 KES Coin changed : 0.00 KES Note changed : 50.00 KES',0) 22/11/2024 20:43:14.1511 1670 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 22/11/2024 20:45:12.3322 1239 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 22/11/2024 20:46:25.2150 569 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 22/11/2024 20:50:49.8663 1654 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 22/11/2024 20:53:02.7974 2172 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-22 20:53:00','V',5303311871034360,2024,'2024-11-22 20:52:59','456166341400327005012999',2,2,2,'O','',0,'2024-11-22 20:53:00',1,'','0230004100121',147,0) 22/11/2024 20:53:07.1003 891 ms. EXEC: UPDATE payInventory SET invType='N' WHERE invType<>'N' AND invValue IN (100,200,500) AND invDevice IN (42102,42101,42001); 22/11/2024 20:53:31.5937 2246 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 22/11/2024 20:56:28.2860 565 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 22/11/2024 20:56:36.2634 2808 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 22/11/2024 20:58:22.8268 1831 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-22 20:58:20','V',5352236378258850,2024,'2024-11-22 20:58:17','456167452900327005012999',2,2,2,'O','',0,'2024-11-22 20:58:20',1,'','',0) 22/11/2024 21:01:22.3140 1229 ms. EXEC: insert into payReceipt (recTraUID,recPayUID,recYear,recDateTime,recText,recInvalid) VALUES (5670409916734060,4816435027657200,2024,'2024-11-22 21:01:21',' Date: 11/22/2024 9:01:20 PM Code: 456165435900327005012999 Entry Date: 11/22/2024 3:05:59 PM Plate: Class: Cars Park: The Mall Gate: Entry 2 ______________________________ Total: 400.00 KES ______________________________ Paid: 400.00 KES __________ Change: 0.00 KES Type: Cash Dispozitiv: MPESA # 2400750636 ',0) 22/11/2024 21:04:22.6858 1388 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 1 22/11/2024 21:08:56.1180 511 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 22/11/2024 21:09:30.4910 1989 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 22/11/2024 21:10:43.5779 509 ms. EXEC: update abbSubscriptions set subCredit = round(subCredit-0,5),subLastDebit = '2024-11-22 21:10:43' where subId = 194 22/11/2024 21:10:50.3855 609 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 22/11/2024 21:22:16.3690 986 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 22/11/2024 21:27:51.3313 597 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 22/11/2024 21:29:36.4407 518 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2024-11-22 21:29:35' where payTraUID = 5484115382169010 and payStatus='V' and payEnabled=1 22/11/2024 21:29:39.0575 569 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 22/11/2024 21:34:32.6601 544 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 22/11/2024 21:35:00.8630 572 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 22/11/2024 21:40:08.9993 857 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 22/11/2024 21:46:30.9821 889 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 22/11/2024 21:47:47.0911 512 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 22/11/2024 21:50:02.4197 610 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 22/11/2024 21:50:52.9876 927 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 22/11/2024 21:51:20.6571 1349 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 22/11/2024 21:58:12.3108 2118 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 22/11/2024 21:58:27.3089 624 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 22/11/2024 21:59:50.4566 603 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 22/11/2024 22:00:09.5814 807 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 22/11/2024 22:00:43.2520 1281 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 22/11/2024 22:05:49.2840 1356 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 22/11/2024 22:10:38.5527 957 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 22/11/2024 22:10:43.4540 1336 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 2 22/11/2024 22:12:10.1951 560 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 22/11/2024 22:14:32.8180 1173 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 5 and terStatus='V' 22/11/2024 22:16:23.5262 511 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 22/11/2024 22:16:38.1059 1046 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 1 22/11/2024 22:18:20.7337 1755 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 22/11/2024 22:19:50.8941 599 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 22/11/2024 22:24:13.4970 624 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 22/11/2024 22:25:36.4966 502 ms. OPEN: select * from tabArea where areStatus='V' and areEnabled = 1 AND areId = 1 22/11/2024 22:28:06.0749 1246 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 22/11/2024 22:28:06.1280 1148 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 22/11/2024 22:29:20.6168 1995 ms. EXEC: UPDATE payInventory SET invType='N' WHERE invType<>'N' AND invValue IN (100,200,500) AND invDevice IN (42102,42101,42001); 22/11/2024 22:30:00.5746 688 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 22/11/2024 22:32:45.1519 770 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 22/11/2024 22:34:22.7512 533 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2024-11-22 22:34:22' where traUID = 5763920735936610 and traStatus='V' and traEnabled=1 22/11/2024 22:40:45.7878 1098 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-22 22:40:44','V',5629900253718940,2024,'2024-11-22 22:40:42','456168164200327005012999',1,2,16,'I','',1,0,1,'','0230003944064',14,0) 22/11/2024 22:40:56.1758 890 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 22/11/2024 22:41:16.5204 564 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 22/11/2024 22:48:17.4874 735 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 22/11/2024 22:49:18.7013 533 ms. EXEC: update tabTerminalReceipt set trcProgressive = 50648, trcLastPrinted = '2400750648', trcLastDate = '2024-11-22 22:49:18' where trcStatus='V' and trcTerId = 18 22/11/2024 22:53:30.6801 698 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 22/11/2024 22:57:29.5451 540 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 22/11/2024 23:02:21.3645 751 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 16 OR lnsTerId=16) 22/11/2024 23:02:21.3715 708 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 22/11/2024 23:03:53.1680 522 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2024-11-22 23:03:52' where payTraUID = 5558463787101860 and payStatus='V' and payEnabled=1 22/11/2024 23:06:38.6908 805 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-22 23:06:37',0,'V',4659188766056920,4850832199851480,2024,'2024-11-22 23:06:37',2,1,0,-1,'2024-11-23 00:06:37','S','KES',0,0,0,'','','',3,0,0) 22/11/2024 23:09:32.5613 928 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 22/11/2024 23:10:39.8453 630 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2024-11-22 23:10:39' where traUID = 4622551186284100 and traStatus='V' and traEnabled=1 22/11/2024 23:10:40.6799 801 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 22/11/2024 23:13:57.8870 1307 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 22/11/2024 23:14:09.8259 2739 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 22/11/2024 23:15:58.2676 659 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2024-11-22 23:15:57' where traUID = 5134694449964340 and traStatus='V' and traEnabled=1 22/11/2024 23:16:06.3390 2181 ms. EXEC: UPDATE payInventory SET invType='N' WHERE invType<>'N' AND invValue IN (100,200,500) AND invDevice IN (42102,42101,42001); 22/11/2024 23:21:40.7069 537 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 22/11/2024 23:23:05.9781 3831 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 22/11/2024 23:23:23.4768 1276 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 22/11/2024 23:23:41.8791 1294 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 22/11/2024 23:23:49.9985 1431 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 22/11/2024 23:25:49.6337 508 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 22/11/2024 23:29:22.9846 1952 ms. OPEN: SELECT traCode FROM movTransit WHERE traId = '783725' and traDirection='I' order by traId DESC LIMIT 1 22/11/2024 23:30:16.0632 767 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 22/11/2024 23:30:23.3911 1400 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 22/11/2024 23:30:26.5382 614 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 22/11/2024 23:30:35.5282 1449 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 22/11/2024 23:31:24.8132 2375 ms. OPEN: select sum(crc32(mesDescription)) as vCheck from tabMessage 22/11/2024 23:36:58.1765 1267 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 22/11/2024 23:39:42.4485 2379 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-22 23:39:40','V',4885195453817420,2024,'2024-11-22 23:39:39','456165516700327005012999',2,2,2,'O','',0,'2024-11-22 23:39:40',1,'','',0) 22/11/2024 23:45:42.2635 610 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 16 OR lnsTerId=16) 22/11/2024 23:47:22.1634 962 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 22/11/2024 23:49:13.8212 565 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 22/11/2024 23:52:18.5359 744 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 22/11/2024 23:56:34.7164 605 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1