16/11/2024 00:00:45.0152 677 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 16/11/2024 00:02:02.2978 1036 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 16/11/2024 00:06:50.9537 839 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 16/11/2024 00:22:30.9227 1254 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 16/11/2024 00:27:50.8835 629 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 16/11/2024 00:31:30.0639 520 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 16/11/2024 00:44:22.9203 1198 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 16/11/2024 00:44:32.2335 696 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 16/11/2024 01:04:32.4354 607 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 16/11/2024 01:04:37.4958 601 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 16/11/2024 01:08:30.9128 1159 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 16/11/2024 01:12:50.4231 576 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 16/11/2024 01:19:25.7803 1137 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 16/11/2024 01:19:25.8303 1194 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 2 OR lnsTerId=2) 16/11/2024 01:26:24.6031 824 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 16/11/2024 01:35:18.8671 577 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 16/11/2024 01:36:13.9459 843 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 16/11/2024 01:43:06.6196 1032 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 16/11/2024 01:45:15.6618 662 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 16/11/2024 01:47:10.0843 869 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 1 16/11/2024 01:55:15.7418 620 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 2 16/11/2024 02:03:01.8752 553 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 16/11/2024 02:03:15.4232 827 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 2 OR lnsTerId=2) 16/11/2024 02:07:23.1117 709 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 16/11/2024 02:22:59.8058 637 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 16/11/2024 02:26:15.4616 1630 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 16/11/2024 02:27:35.7022 567 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 16/11/2024 02:29:26.5322 758 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 16/11/2024 02:33:57.8015 653 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 16/11/2024 02:41:50.0940 589 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 16/11/2024 03:13:26.7652 576 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 16/11/2024 03:18:32.8207 789 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 16/11/2024 03:24:45.4657 1572 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 16/11/2024 03:26:16.0382 509 ms. OPEN: select * from tabArea where areStatus='V' and areEnabled = 1 AND areId = 1 16/11/2024 03:30:05.5045 831 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 16/11/2024 03:39:29.5284 537 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 16/11/2024 03:41:55.4109 586 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 16/11/2024 03:46:28.3892 971 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 16/11/2024 03:48:48.7020 607 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 16/11/2024 03:48:48.7020 592 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 16/11/2024 04:03:40.3667 694 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2024-11-16 04:03:39' where payTraUID = 5165137328929910 and payStatus='V' and payEnabled=1 16/11/2024 04:03:48.8274 1036 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 16/11/2024 04:04:31.1026 1020 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 16/11/2024 04:09:32.8452 1232 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 16/11/2024 04:10:26.4631 849 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 16/11/2024 04:11:48.4729 1843 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 16/11/2024 04:20:42.8379 1069 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 16/11/2024 04:23:37.9089 1627 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 16/11/2024 04:27:20.0843 704 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 16/11/2024 04:27:46.2658 533 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 16/11/2024 04:28:06.0050 1397 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 16/11/2024 04:37:50.3584 677 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 16/11/2024 04:48:49.4738 541 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 16/11/2024 04:51:38.0594 1086 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 16/11/2024 04:54:54.0904 1092 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 16/11/2024 04:57:34.9228 1118 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 16/11/2024 05:02:37.9353 589 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 16/11/2024 05:05:53.6110 520 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 16/11/2024 05:09:50.6394 729 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 16/11/2024 05:18:04.7045 673 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 16/11/2024 05:45:40.4187 751 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 16/11/2024 05:50:03.4335 2087 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 16/11/2024 05:52:45.5878 856 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 16/11/2024 08:29:24.4854 503 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 16/11/2024 10:10:05.1616 611 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-16 10:10:04',0,'V',5205552799849950,5649762070042170,2024,'2024-11-16 10:10:04',18,1,0,4,'2024-11-16 10:25:04','C','KES',50,50,0,'','','',1,50,0,0,'',0,0) 16/11/2024 12:45:38.6273 529 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 16/11/2024 13:03:11.2226 504 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 16/11/2024 13:05:02.7806 538 ms. EXEC: update paycash set casCreation = '2024-11-16 13:05:02',casModify = '2024-11-16 13:05:02',casUseId=0,casStatus='V' where casId = 195221 16/11/2024 13:18:25.4757 507 ms. EXEC: update payReceipt set recCreation = '2024-11-16 13:18:24',recModify = '2024-11-16 13:18:24',recUseId=0,recStatus='V' where recId = 323178 16/11/2024 14:15:55.8318 509 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2024-11-16 14:15:55',3,42101,0,50,1,50,1,'I','N'); update payCurInventory set curQuantity=round(curQuantity+1,5),curAmount=round(curAmount+50,5) where curTerId = 3 and curDevCode = 42101 and curChannelId = 1 and curValue = 50 and curType = 'N'; 16/11/2024 16:47:24.3033 664 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 16/11/2024 16:47:25.6154 1229 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 16/11/2024 20:16:51.3169 595 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-16 20:16:50','V',5679870547282570,2024,'2024-11-16 20:16:50','456107145900327001012999',2,2,2,'O','',0,'2024-11-16 20:16:50',1,'','',0) 16/11/2024 22:36:21.1099 997 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-16 22:36:20','V',4909520272294130,2024,'2024-11-16 22:36:19','456108081200327005012999',2,2,2,'O','',0,'2024-11-16 22:36:20',1,'','',0) 16/11/2024 22:36:21.9075 791 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 16/11/2024 22:36:23.3495 1438 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2024-11-16 22:36:21' where payTraUID = 5012261604560920 and payStatus='V' and payEnabled=1 16/11/2024 22:36:23.9437 594 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2024-11-16 22:36:21' where traUID = 5012261604560920 and traStatus='V' and traEnabled=1