21/01/2025 02:04:42.1832 522 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 21/01/2025 02:05:19.8306 790 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 21/01/2025 02:05:41.3712 574 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 21/01/2025 02:22:24.7132 626 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 21/01/2025 02:31:12.7001 981 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 21/01/2025 02:38:42.2981 704 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 21/01/2025 03:02:24.6671 899 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 21/01/2025 03:32:29.9687 695 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 21/01/2025 03:43:50.1942 936 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 21/01/2025 03:44:03.5981 1574 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 21/01/2025 04:03:25.2630 830 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 21/01/2025 04:48:14.4370 661 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 21/01/2025 04:51:35.8128 756 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 21/01/2025 05:06:08.9243 1496 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 21/01/2025 05:07:14.2190 820 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 21/01/2025 05:16:15.3690 525 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 21/01/2025 05:16:53.8188 540 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 21/01/2025 05:32:27.0105 617 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 21/01/2025 05:32:40.6837 598 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 21/01/2025 05:46:04.8574 542 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 21/01/2025 05:52:39.8011 922 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 21/01/2025 05:55:25.2852 1032 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 3 21/01/2025 05:56:23.7613 1446 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 21/01/2025 05:59:11.8349 524 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 21/01/2025 05:59:21.3362 559 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2025-01-21 05:59:20' where traUID = 4943966717684540 and traStatus='V' and traEnabled=1 21/01/2025 06:03:45.9401 618 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 21/01/2025 06:03:51.4738 572 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 21/01/2025 06:06:04.3297 778 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 21/01/2025 06:16:03.8370 636 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 21/01/2025 06:16:59.0189 980 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 21/01/2025 06:28:20.9479 893 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2025-01-21 06:28:19' where traUID = 5427411565635620 and traStatus='V' and traEnabled=1 21/01/2025 06:55:19.2097 930 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 21/01/2025 07:02:43.9264 542 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 21/01/2025 07:05:55.4487 894 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 21/01/2025 07:09:10.3875 637 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 21/01/2025 07:21:31.4583 570 ms. EXEC: insert into movtransit (traUseId,traCreation,traStatus,traUID,traYear,traDateTime,traCode,traType,traClass,traIdTerminal,traDirection,traPlate,traEnabled,traDisableTime,traAreId,traNotes,traBadge,traTarId) VALUES (0,'2025-01-21 07:21:30','V',5219742024821090,2025,'2025-01-21 07:21:29','456762648900327005012999',1,2,16,'I','',1,0,1,'','',4) 21/01/2025 07:35:20.8373 520 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 16 OR lnsTerId=16) 21/01/2025 07:43:24.1394 578 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 21/01/2025 07:57:59.3812 646 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 21/01/2025 08:06:16.9245 1035 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 21/01/2025 08:07:18.9200 1145 ms. OPEN: select * from tabArea where areStatus='V' and areEnabled = 1 AND areId = 1 21/01/2025 08:45:31.6871 933 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 21/01/2025 08:46:37.5131 520 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 21/01/2025 08:48:19.5304 1107 ms. EXEC: INSERT INTO movOperator (opeCreation,opeUseId,opeTerId,opeDateTime,opeCode,opeDescription) VALUES ('2025-01-21 08:48:18',0,16,'2025-01-21 08:48:18','','Unauthorized Transit Entry 2') 21/01/2025 08:48:31.1792 532 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 21/01/2025 08:53:06.5296 1356 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 21/01/2025 08:54:26.2790 616 ms. EXEC: update payInventory set invCreation = '2025-01-21 08:54:25',invModify = '2025-01-21 08:54:25',invUseId=0,invStatus='V' where invId = 232403 21/01/2025 08:59:26.8332 1260 ms. EXEC: insert into movtransit (traUseId,traCreation,traStatus,traUID,traYear,traDateTime,traCode,traType,traClass,traIdTerminal,traDirection,traPlate,traEnabled,traDisableTime,traAreId,traNotes,traBadge,traCarId,traTarId) VALUES (0,'2025-01-21 08:59:25','V',5049899201069370,2025,'2025-01-21 08:59:23','456763236300327005012999',1,2,16,'I','',1,0,1,'','0810007145851',106,0) 21/01/2025 09:02:19.4888 615 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 21/01/2025 09:09:04.0997 507 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 21/01/2025 09:10:24.0422 818 ms. EXEC: insert into paycash (casCreation,casModify,casUseId,casStatus,casUID,casTraUID,casYear,casDateTime,casIdTerminal,casCurrency,casNumber,casSingleAmount,casTotAmount,casType,casDescription) VALUES ('2025-01-21 09:10:23',0,0,'V',5154262864940510,5468151358371550,2025,'2025-01-21 09:10:23',3,'KES',1,50,50,'N',''); 21/01/2025 09:10:25.0379 968 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2025-01-21 09:10:23',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'; 21/01/2025 09:14:48.0710 1038 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 21/01/2025 09:14:48.1450 504 ms. EXEC: update payReceipt set recCreation = '2025-01-21 09:14:47',recModify = '2025-01-21 09:14:47',recUseId=0,recStatus='V' where recId = 344370 21/01/2025 09:19:38.7176 776 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 21/01/2025 09:26:30.2676 692 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 21/01/2025 09:33:25.9380 580 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 21/01/2025 09:33:26.9587 580 ms. EXEC: INSERT INTO movOperator (opeCreation,opeUseId,opeTerId,opeDateTime,opeCode,opeDescription) VALUES ('2025-01-21 09:33:26',0,16,'2025-01-21 09:33:26','','Unauthorized Transit Entry 2') 21/01/2025 09:33:37.7129 529 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 21/01/2025 09:33:52.9701 524 ms. EXEC: insert into payReceipt (recTraUID,recPayUID,recYear,recDateTime,recText,recInvalid) VALUES (5376047622181000,4693659525344700,2025,'2025-01-21 09:33:52',' Date: 1/21/2025 9:33:52 AM Code: 456763352600327005012999 Entry Date: 1/21/2025 9:18:46 AM Plate: Class: Cars Park: The Mall Gate: Entry 2 ______________________________ Total: 50.00 KES ______________________________ Paid: 50.00 KES __________ Change: 0.00 KES Type: Credit Card Dispozitiv: Manual Cashier 1 # 2500400880 ',0) 21/01/2025 09:34:15.7534 702 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 5 21/01/2025 09:36:28.4602 554 ms. EXEC: insert into movtransit (traUseId,traCreation,traStatus,traUID,traYear,traDateTime,traCode,traType,traClass,traIdTerminal,traDirection,traPlate,traEnabled,traDisableTime,traAreId,traNotes,traBadge,traCarId,traTarId) VALUES (0,'2025-01-21 09:36:27','V',5509451058670140,2025,'2025-01-21 09:36:27','456763458700327005012999',1,2,16,'I','',1,0,1,'','0230004100082',142,0) 21/01/2025 09:36:32.2518 625 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 21/01/2025 09:38:22.9827 1228 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2025-01-21 09:38:21' where payTraUID = 4823585875593030 and payStatus='V' and payEnabled=1 21/01/2025 09:39:21.4531 2008 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 21/01/2025 09:41:55.7842 606 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 21/01/2025 09:43:24.1283 1006 ms. EXEC: insert into movtransit (traUseId,traCreation,traStatus,traUID,traYear,traDateTime,traCode,traType,traClass,traIdTerminal,traDirection,traPlate,traEnabled,traDisableTime,traAreId,traNotes,traBadge,traTarId) VALUES (0,'2025-01-21 09:43:23','V',5489020285501340,2025,'2025-01-21 09:43:22','456762966700327005012999',2,2,2,'O','',0,'2025-01-21 09:43:23',1,'','',0) 21/01/2025 09:43:25.7844 1279 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2025-01-21 09:43:24' where traUID = 4965420727841060 and traStatus='V' and traEnabled=1 21/01/2025 09:43:30.1504 546 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 21/01/2025 09:43:31.2101 1485 ms. EXECSCALAR: select count(*) from information_schema.tables where table_schema= 'wisepark_0327' and table_name= 'payInvoiceFtp' nr: 1 21/01/2025 09:46:01.0714 598 ms. EXEC: insert into abbPayment (payCreation,payCode,payAmount,payCredit,payPayUID,payCarId,payDateFrom,payDateTo) VALUES ('2025-01-21 09:46:00','0230003939927',0,0,5141354179153220,164,'0000-00-00 00:00:00','0000-00-00 00:00:00') 21/01/2025 09:46:11.1532 943 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 21/01/2025 09:51:23.3031 566 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 21/01/2025 09:52:19.6244 567 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2025-01-21 09:52:19' where traUID = 5216446172039950 and traStatus='V' and traEnabled=1 21/01/2025 10:07:27.8674 557 ms. EXECSCALAR: select count(*) from information_schema.tables where table_schema= 'wisepark_0327' and table_name= 'payInvoiceFtp' nr: 1 21/01/2025 10:07:28.8231 561 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 21/01/2025 10:15:13.3672 545 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 21/01/2025 10:16:59.8085 552 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 21/01/2025 10:18:50.3785 513 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 21/01/2025 10:20:16.5892 653 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 21/01/2025 10:20:25.7774 705 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 21/01/2025 10:21:26.2609 1007 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 21/01/2025 10:26:37.2151 1229 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 21/01/2025 10:38:19.7945 980 ms. EXEC: update paycash set casCreation = '2025-01-21 10:38:18',casModify = '2025-01-21 10:38:18',casUseId=0,casStatus='V' where casId = 205880 21/01/2025 10:39:53.2430 742 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2025-01-21 10:39:52' where payTraUID = 5433855048004630 and payStatus='V' and payEnabled=1 21/01/2025 10:41:15.2699 880 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 21/01/2025 10:45:09.9220 586 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 21/01/2025 10:48:50.6348 652 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 1 OR lnsTerId=1) 21/01/2025 10:48:50.6428 556 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 21/01/2025 10:55:59.7410 808 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 21/01/2025 10:58:07.1303 778 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 21/01/2025 11:05:30.6238 580 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 21/01/2025 11:05:32.2499 800 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 21/01/2025 11:08:36.8213 682 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 21/01/2025 11:09:03.7283 637 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2025-01-21 11:09:03' where traUID = 5439578552119890 and traStatus='V' and traEnabled=1 21/01/2025 11:09:26.4125 501 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 21/01/2025 11:17:35.8121 833 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 21/01/2025 11:17:38.5449 1568 ms. EXEC: insert into movtransit (traUseId,traCreation,traStatus,traUID,traYear,traDateTime,traCode,traType,traClass,traIdTerminal,traDirection,traPlate,traEnabled,traDisableTime,traAreId,traNotes,traBadge,traTarId) VALUES (0,'2025-01-21 11:17:36','V',5438223653242920,2025,'2025-01-21 11:17:36','456764065600327005012999',1,2,16,'I','',1,0,1,'','',4) 21/01/2025 11:17:41.1717 760 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 21/01/2025 11:18:03.8268 1102 ms. EXEC: insert into movtransit (traUseId,traCreation,traStatus,traUID,traYear,traDateTime,traCode,traType,traClass,traIdTerminal,traDirection,traPlate,traEnabled,traDisableTime,traAreId,traNotes,traBadge,traTarId) VALUES (0,'2025-01-21 11:18:02','V',4851302981839690,2025,'2025-01-21 11:18:03','456764068300327001012999',1,2,1,'I','',1,0,1,'','',4) 21/01/2025 11:18:30.6676 740 ms. EXEC: insert into payPayment (payCreation,payUseId,payStatus,payUID,payTraUID,payYear,payDateTime,payIdTerminal,payEnabled,payDisableTime,payTarId,payTimeLimit,payType,payCurrency,payAmount,payPayed,payChange,payCardType,payPAN,paySTAN,payIdEvent,payAmountCalc,payDiscountValue,payDiscount,payDiscountType,payVatPercent,payVatAmount) VALUES ('2025-01-21 11:18:29',0,'V',4623987551399260,4880934966696320,2025,'2025-01-21 11:18:29',18,1,0,4,'2025-01-21 11:33:29','C','KES',100,100,0,'','','',1,100,0,0,'',0,0) 21/01/2025 11:18:41.2056 1789 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 21/01/2025 11:19:24.9099 519 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 21/01/2025 11:19:26.1867 1016 ms. EXEC: UPDATE payInventory SET invType='N' WHERE invType<>'N' AND invValue IN (100,200,500) AND invDevice IN (42102,42101,42001); 21/01/2025 11:22:07.0993 542 ms. EXEC: insert into movtransit (traUseId,traCreation,traStatus,traUID,traYear,traDateTime,traCode,traType,traClass,traIdTerminal,traDirection,traPlate,traEnabled,traDisableTime,traAreId,traNotes,traBadge,traTarId) VALUES (0,'2025-01-21 11:22:06','V',4848165182957290,2025,'2025-01-21 11:22:04','456763805800327005012999',2,2,2,'O','',0,'2025-01-21 11:22:06',1,'','',0) 21/01/2025 11:25:12.8010 658 ms. EXEC: update abbCards set carLastDate = '2025-01-21 11:25:12',carLastDirection='I' where carStatus='V' and carId = 12 21/01/2025 11:25:21.1986 958 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 21/01/2025 11:27:28.5039 790 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 21/01/2025 11:30:08.9171 1811 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 21/01/2025 11:31:55.5998 1104 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 21/01/2025 11:34:24.3354 1031 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 21/01/2025 11:34:37.8905 612 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 21/01/2025 11:36:03.0345 603 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 21/01/2025 11:40:40.3309 758 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2025-01-21 11:40:39' where traUID = 5588482379988170 and traStatus='V' and traEnabled=1 21/01/2025 11:42:00.9689 1292 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 21/01/2025 11:49:01.2124 567 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 21/01/2025 11:57:56.8584 549 ms. OPEN: select * from tabDevice where devId = 2 and devStatus = 'V' 21/01/2025 11:58:04.3494 609 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 21/01/2025 11:59:16.9175 630 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 21/01/2025 11:59:17.9742 1011 ms. EXEC: UPDATE payInventory SET invType='N' WHERE invType<>'N' AND invValue IN (100,200,500) AND invDevice IN (42102,42101,42001); 21/01/2025 12:00:05.5879 600 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 21/01/2025 12:00:07.7374 1642 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 21/01/2025 12:04:23.9909 599 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 21/01/2025 12:04:32.5206 590 ms. EXEC: update payInventory set invCreation = '2025-01-21 12:04:31',invModify = '2025-01-21 12:04:31',invUseId=0,invStatus='V' where invId = 232460 21/01/2025 12:09:27.6098 641 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 21/01/2025 12:11:34.6829 992 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 21/01/2025 12:12:31.6140 539 ms. OPEN: select * from tabUserMessage where useMesDescr = 'msg_welcome' and (useLanCode = 'en-US' or mid(useLanCode,1,2) = 'en') 21/01/2025 12:13:56.7200 668 ms. EXEC: insert into movtransit (traUseId,traCreation,traStatus,traUID,traYear,traDateTime,traCode,traType,traClass,traIdTerminal,traDirection,traPlate,traEnabled,traDisableTime,traAreId,traNotes,traBadge,traTarId) VALUES (0,'2025-01-21 12:13:56','V',5484194241924760,2025,'2025-01-21 12:13:54','456764403400327005012999',1,2,16,'I','',1,0,1,'','',4) 21/01/2025 12:13:57.4424 541 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 21/01/2025 12:14:30.1273 961 ms. EXEC: update payReceipt set recCreation = '2025-01-21 12:14:29',recModify = '2025-01-21 12:14:29',recUseId=0,recStatus='V' where recId = 344430 21/01/2025 12:15:25.9247 827 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 21/01/2025 12:15:34.0351 688 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 21/01/2025 12:16:20.7884 604 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2025-01-21 12:16:20' where traUID = 5552474815242920 and traStatus='V' and traEnabled=1 21/01/2025 12:16:28.0583 1939 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 21/01/2025 12:19:20.9020 835 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2025-01-21 12:19:19' where traUID = 4692011992267810 and traStatus='V' and traEnabled=1 21/01/2025 12:19:51.9018 694 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 21/01/2025 12:22:15.6650 696 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2025-01-21 12:22:14',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'; 21/01/2025 12:22:19.4055 514 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 21/01/2025 12:23:48.5672 539 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 2 and terStatus='V' 21/01/2025 12:23:48.5742 541 ms. OPEN: select * from tabArea where areStatus='V' and areEnabled = 1 AND areId = 1 21/01/2025 12:24:33.2501 517 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 21/01/2025 12:25:20.9340 539 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 21/01/2025 12:26:15.4886 795 ms. EXEC: insert into movtransit (traUseId,traCreation,traStatus,traUID,traYear,traDateTime,traCode,traType,traClass,traIdTerminal,traDirection,traPlate,traEnabled,traDisableTime,traAreId,traNotes,traBadge,traTarId) VALUES (0,'2025-01-21 12:26:14','V',4768006171019130,2025,'2025-01-21 12:26:13','456764192500327005012999',2,2,2,'O','',0,'2025-01-21 12:26:14',1,'','',0) 21/01/2025 12:28:19.2744 925 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 21/01/2025 12:29:51.1009 685 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 21/01/2025 12:31:38.2678 582 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 21/01/2025 12:31:53.4119 525 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 21/01/2025 12:33:18.5970 750 ms. EXEC: update payInventory set invCreation = '2025-01-21 12:33:17',invModify = '2025-01-21 12:33:17',invUseId=0,invStatus='V' where invId = 232474 21/01/2025 12:34:59.0532 840 ms. EXEC: insert into payReceipt (recTraUID,recPayUID,recYear,recDateTime,recText,recInvalid) VALUES (5280334295227110,5481926776203270,2025,'2025-01-21 12:34:58',' Data: 1/21/2025 12:31:38 PM Codice: 456764365000327005012999 Ingresso: 1/21/2025 12:07:30 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 # 2500600453 ',0) 21/01/2025 12:34:59.7897 1062 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 21/01/2025 12:36:05.4437 550 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 21/01/2025 12:36:06.1822 694 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2025-01-21 12:36:05' where payTraUID = 5065182700757900 and payStatus='V' and payEnabled=1 21/01/2025 12:37:02.6069 561 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 21/01/2025 12:40:06.0398 772 ms. EXEC: insert into movtransit (traUseId,traCreation,traStatus,traUID,traYear,traDateTime,traCode,traType,traClass,traIdTerminal,traDirection,traPlate,traEnabled,traDisableTime,traAreId,traNotes,traBadge,traTarId) VALUES (0,'2025-01-21 12:40:05','V',4712595619535720,2025,'2025-01-21 12:40:17','456764561700327001012999',1,2,1,'I','',1,0,1,'','',4) 21/01/2025 12:40:20.1132 597 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 1 21/01/2025 12:41:50.1495 517 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 21/01/2025 12:45:01.7077 672 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 21/01/2025 12:47:02.0433 582 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 21/01/2025 12:47:02.5516 1094 ms. EXEC: insert into payPayment (payCreation,payUseId,payStatus,payUID,payTraUID,payYear,payDateTime,payIdTerminal,payEnabled,payDisableTime,payTarId,payTimeLimit,payType,payCurrency,payAmount,payPayed,payChange,payCardType,payPAN,paySTAN,payIdEvent,payVatPercent,payVatAmount) VALUES ('2025-01-21 12:47:01',0,'V',4793835665026690,5660994104872690,2025,'2025-01-21 12:47:01',2,1,0,-1,'2025-01-21 13:47:01','S','KES',0,0,0,'','','',3,0,0) 21/01/2025 12:48:43.3761 865 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 21/01/2025 12:50:28.4274 1095 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 21/01/2025 12:52:16.0995 924 ms. EXEC: update payInventory set invCreation = '2025-01-21 12:52:15',invModify = '2025-01-21 12:52:15',invUseId=0,invStatus='V' where invId = 232484 21/01/2025 12:55:14.5140 540 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 21/01/2025 12:58:06.3318 824 ms. EXEC: insert into payPayment (payCreation,payUseId,payStatus,payUID,payTraUID,payYear,payDateTime,payIdTerminal,payEnabled,payDisableTime,payTarId,payTimeLimit,payType,payCurrency,payAmount,payPayed,payChange,payCardType,payPAN,paySTAN,payIdEvent,payAmountCalc,payDiscountValue,payDiscount,payDiscountType,payVatPercent,payVatAmount) VALUES ('2025-01-21 12:58:03',0,'V',4992698768804690,5440705477931760,2025,'2025-01-21 12:58:03',3,1,0,4,'2025-01-21 13:13:03','C','KES',100,100,0,'',' ',' ',1,100,0,0,'',0,0) 21/01/2025 12:58:41.5464 992 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 21/01/2025 12:58:47.7115 531 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 21/01/2025 12:58:47.7355 527 ms. EXEC: update tabTerminalReceipt set trcProgressive = 2985, trcLastPrinted = '2500702985', trcLastDate = '2025-01-21 12:58:47' where trcStatus='V' and trcTerId = 18 21/01/2025 12:58:53.4694 2025 ms. EXECSCALAR: select count(*) from information_schema.tables where table_schema= 'wisepark_0327' and table_name= 'payInvoiceFtp' nr: 1 21/01/2025 12:58:54.2509 583 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 21/01/2025 12:59:17.8523 552 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 21/01/2025 13:00:31.3539 541 ms. EXEC: insert into movtransit (traUseId,traCreation,traStatus,traUID,traYear,traDateTime,traCode,traType,traClass,traIdTerminal,traDirection,traPlate,traEnabled,traDisableTime,traAreId,traNotes,traBadge,traTarId) VALUES (0,'2025-01-21 13:00:30','V',5150848907497950,2025,'2025-01-21 13:00:29','456764347200327005012999',2,2,2,'O','',0,'2025-01-21 13:00:30',1,'','',0) 21/01/2025 13:00:36.1991 593 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 21/01/2025 13:05:10.4268 606 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 21/01/2025 13:05:12.0980 1077 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 21/01/2025 13:06:07.4720 1122 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 21/01/2025 13:06:48.2033 983 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 21/01/2025 13:11:49.0530 538 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 21/01/2025 13:14:00.8831 514 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 21/01/2025 13:14:16.6014 675 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 21/01/2025 13:15:32.0649 566 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 21/01/2025 13:18:50.4097 1065 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 21/01/2025 13:19:01.1699 989 ms. EXEC: insert into paycash (casCreation,casModify,casUseId,casStatus,casUID,casTraUID,casYear,casDateTime,casIdTerminal,casCurrency,casNumber,casSingleAmount,casTotAmount,casType,casDescription) VALUES ('2025-01-21 13:19:00',0,0,'V',4819457927591280,5313622791531620,2025,'2025-01-21 13:19:00',3,'KES',-1,100,-100,'N',''); 21/01/2025 13:19:15.5595 635 ms. EXEC: insert into payReceipt (recTraUID,recPayUID,recYear,recDateTime,recText,recInvalid) VALUES (4833468329964480,5174356095696290,2025,'2025-01-21 13:19:14',' Date: 1/21/2025 1:19:14 PM Code: 456763563200327005012999 Entry Date: 1/21/2025 9:53:52 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 # 2500702987 ',0) 21/01/2025 13:19:16.1479 587 ms. EXEC: update payReceipt set recCreation = '2025-01-21 13:19:15',recModify = '2025-01-21 13:19:15',recUseId=0,recStatus='V' where recId = 344464 21/01/2025 13:20:31.8486 797 ms. EXEC: insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2025-01-21 13:20:30',3,42101,0,50,-1,-50,1,'O','N'); update payCurInventory set curQuantity=round(curQuantity-1,5),curAmount=round(curAmount-50,5) where curTerId = 3 and curDevCode = 42101 and curChannelId = 1 and curValue = 50 and curType = 'N'; insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2025-01-21 13:20:30',3,42101,0,50,1,50,2,'I','N'); update payCurInventory set curQuantity=round(curQuantity+1,5),curAmount=round(curAmount+50,5) where curTerId = 3 and curDevCode = 42101 and curChannelId = 2 and curValue = 50 and curType = 'N'; Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2025-01-21 13:20:30',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'; 21/01/2025 13:22:05.0400 838 ms. OPEN: show columns from payPayment where Field = 'payClosePeriod' 21/01/2025 13:25:01.3169 760 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2025-01-21 13:25:00',3,42101,0,50,-1,-50,1,'O','N'); update payCurInventory set curQuantity=round(curQuantity+-1,5),curAmount=round(curAmount+-50,5) where curTerId = 3 and curDevCode = 42101 and curChannelId = 1 and curValue = 50 and curType = 'N'; Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2025-01-21 13:25:00',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'; 21/01/2025 13:25:36.3564 542 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2025-01-21 13:25:35',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'; 21/01/2025 13:25:39.2073 588 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 3 21/01/2025 13:25:59.1646 595 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 21/01/2025 13:26:15.8918 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,'2025-01-21 13:26:14','V',5143854265556070,2025,'2025-01-21 13:26:03','456764836300327005031999',1,2,16,'I','',1,0,1,'','',4) 21/01/2025 13:26:16.4272 514 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 21/01/2025 13:26:18.1814 691 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 21/01/2025 13:27:03.8169 678 ms. EXEC: insert into movtransit (traUseId,traCreation,traStatus,traUID,traYear,traDateTime,traCode,traType,traClass,traIdTerminal,traDirection,traPlate,traEnabled,traDisableTime,traAreId,traNotes,traBadge,traTarId) VALUES (0,'2025-01-21 13:27:03','V',4722485002521970,2025,'2025-01-21 13:27:02','456764675900327005012999',2,2,2,'O','',0,'2025-01-21 13:27:03',1,'','',0) 21/01/2025 13:28:09.9122 702 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 21/01/2025 13:28:32.0060 538 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 2 OR lnsTerId=2) 21/01/2025 13:30:01.6480 522 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 21/01/2025 13:30:24.1210 814 ms. EXEC: delete from movRoutes where rtsStatus = 'V' and rtsEnabled = 1 and rtsCarID = 47 21/01/2025 13:30:32.5237 541 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 21/01/2025 13:32:51.5617 2085 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2025-01-21 13:32:49' where traUID = 5664414980783330 and traStatus='V' and traEnabled=1 21/01/2025 13:33:13.8497 599 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 21/01/2025 13:35:04.4627 2286 ms. EXEC: insert into payReceipt (recTraUID,recPayUID,recYear,recDateTime,recText,recInvalid) VALUES (5379164863755920,5373851925032020,2025,'2025-01-21 13:35:02','---------------------------------- %The Mall P0006032390 End of payment ---------------------------------- POF Entry : 1/21/2025 12:56:39 PM Date : 1/21/2025 1:35:01 PM Code : 456764659900327005012999 Total : 50.00 KES VAT 16% : 6.90 KES ---------------------------------- Paid : 100.00 KES Coin changed : 0.00 KES Note changed : 50.00 KES',0) 21/01/2025 13:35:06.6132 1429 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2025-01-21 13:35:05',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'; 21/01/2025 13:36:19.4529 515 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 21/01/2025 13:40:11.1951 623 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 21/01/2025 13:41:02.5625 790 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2025-01-21 13:41:01',3,42101,0,50,-1,-50,1,'O','N'); update payCurInventory set curQuantity=round(curQuantity+-1,5),curAmount=round(curAmount+-50,5) where curTerId = 3 and curDevCode = 42101 and curChannelId = 1 and curValue = 50 and curType = 'N'; Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2025-01-21 13:41:01',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'; 21/01/2025 13:41:21.3011 639 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 21/01/2025 13:41:43.5860 2195 ms. EXEC: insert into payReceipt (recTraUID,recPayUID,recYear,recDateTime,recText,recInvalid) VALUES (5221182181607500,5150904044472710,2025,'2025-01-21 13:41:41','---------------------------------- %The Mall P0006032390 End of payment ---------------------------------- POF Entry : 1/21/2025 1:31:04 PM Date : 1/21/2025 1:41:39 PM Code : 456764866400327001012999 Total : 50.00 KES VAT 16% : 6.90 KES ---------------------------------- Paid : 50.00 KES Coin changed : 0.00 KES Note changed : 0.00 KES',0) 21/01/2025 13:41:44.8198 934 ms. EXEC: update paycash set casCreation = '2025-01-21 13:41:43',casModify = '2025-01-21 13:41:43',casUseId=0,casStatus='V' where casId = 205943 21/01/2025 13:41:46.7101 1234 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 21/01/2025 13:48:18.4150 512 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 21/01/2025 13:48:52.6988 1069 ms. EXECSCALAR: select count(*) from information_schema.tables where table_schema= 'wisepark_0327' and table_name= 'payInvoiceFtp' nr: 1 21/01/2025 13:48:53.6675 912 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 21/01/2025 13:49:08.6465 906 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2025-01-21 13:49:07' where traUID = 4684380834183620 and traStatus='V' and traEnabled=1 21/01/2025 13:49:31.9131 736 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 21/01/2025 13:51:37.9684 614 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 21/01/2025 13:52:10.5722 1148 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 21/01/2025 14:01:36.7371 810 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 21/01/2025 14:01:58.0144 557 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 21/01/2025 14:02:02.3613 768 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 21/01/2025 14:02:09.5391 794 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 21/01/2025 14:02:22.0565 611 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 21/01/2025 14:02:22.2216 578 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 4 21/01/2025 14:02:42.5912 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 ('2025-01-21 14:02:41',0,'V',5115765489809260,5472514641174350,2025,'2025-01-21 14:02:41',18,1,0,4,'2025-01-21 14:17:41','C','KES',50,50,0,'','','',1,50,0,0,'',0,0) 21/01/2025 14:15:19.4555 1371 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 5 21/01/2025 14:15:20.2240 524 ms. EXEC: insert into movtransit (traUseId,traCreation,traStatus,traUID,traYear,traDateTime,traCode,traType,traClass,traIdTerminal,traDirection,traPlate,traEnabled,traDisableTime,traAreId,traNotes,traBadge,traTarId) VALUES (0,'2025-01-21 14:15:19','V',4805268928351010,2025,'2025-01-21 14:15:18','456765131800327005012999',1,2,16,'I','',1,0,1,'','',4) 21/01/2025 14:15:49.7247 1526 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2025-01-21 14:15:47' where traUID = 4819970119430580 and traStatus='V' and traEnabled=1 21/01/2025 14:16:12.3499 1453 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2025-01-21 14:16:10' where payTraUID = 5143854265556070 and payStatus='V' and payEnabled=1 21/01/2025 14:20:33.2542 624 ms. OPEN: select sum(crc32(terDescription)) as vCheck from tabTerminal 21/01/2025 14:20:33.8717 617 ms. OPEN: select sum(crc32(devDescription)) as vCheck from tabDevice 21/01/2025 14:20:34.5431 671 ms. OPEN: select sum(crc32(mesDescription)) as vCheck from tabMessage 21/01/2025 14:23:31.7728 2854 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2025-01-21 14:23:28' where traUID = 5628697984098370 and traStatus='V' and traEnabled=1 21/01/2025 14:25:24.5533 781 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 21/01/2025 14:30:34.1175 533 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 16 OR lnsTerId=16) 21/01/2025 14:36:05.6305 523 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2025-01-21 14:36:04' where traUID = 5151803913618440 and traStatus='V' and traEnabled=1 21/01/2025 14:36:35.2733 601 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 21/01/2025 14:39:33.1564 767 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 21/01/2025 14:44:46.9315 716 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 21/01/2025 14:48:59.5658 636 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 21/01/2025 14:49:35.7130 623 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 21/01/2025 14:51:24.3767 510 ms. EXEC: insert into payReceipt (recTraUID,recPayUID,recYear,recDateTime,recText,recInvalid) VALUES (5597437644676820,4929507197010160,2025,'2025-01-21 14:51:23','---------------------------------- %The Mall P0006032390 End of payment ---------------------------------- POF Entry : 1/21/2025 2:26:54 PM Date : 1/21/2025 2:51:22 PM Code : 456765201400327005012999 Total : 50.00 KES VAT 16% : 6.90 KES ---------------------------------- Paid : 50.00 KES Coin changed : 0.00 KES Note changed : 0.00 KES',0) 21/01/2025 15:02:36.9206 621 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 21/01/2025 15:02:50.1024 626 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 21/01/2025 15:05:23.1296 509 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 21/01/2025 15:05:28.3411 662 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 21/01/2025 15:07:58.7725 862 ms. EXEC: insert into paycash (casCreation,casModify,casUseId,casStatus,casUID,casTraUID,casYear,casDateTime,casIdTerminal,casCurrency,casNumber,casSingleAmount,casTotAmount,casType,casDescription) VALUES ('2025-01-21 15:07:57',0,0,'V',4796835125572410,5312000701597480,2025,'2025-01-21 15:07:57',3,'KES',1,200,200,'N',''); 21/01/2025 15:13:38.5060 628 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 21/01/2025 15:14:54.4321 1340 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 21/01/2025 15:16:20.9802 650 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2025-01-21 15:16:20' where payTraUID = 4876782113591260 and payStatus='V' and payEnabled=1 21/01/2025 15:18:52.2495 962 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 21/01/2025 15:18:52.9790 973 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 21/01/2025 15:23:22.6465 580 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 21/01/2025 15:23:52.4595 971 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 21/01/2025 15:24:41.2802 789 ms. EXEC: UPDATE payInventory SET invType='N' WHERE invType<>'N' AND invValue IN (100,200,500) AND invDevice IN (42102,42101,42001); 21/01/2025 15:24:55.6018 914 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 21/01/2025 15:28:33.9168 595 ms. EXEC: update tabTerminalReceipt set trcProgressive = 3020, trcLastPrinted = '2500703020', trcLastDate = '2025-01-21 15:28:33' where trcStatus='V' and trcTerId = 18 21/01/2025 15:29:05.3218 510 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 21/01/2025 15:29:17.4229 713 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 21/01/2025 15:31:33.7272 1025 ms. OPEN: select * from tabArea where areStatus='V' and areEnabled = 1 AND areId = 1 21/01/2025 15:36:37.9375 1000 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 21/01/2025 15:40:04.7206 940 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 21/01/2025 15:40:38.6213 632 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 21/01/2025 15:40:39.0186 854 ms. EXECSCALAR: select count(*) from information_schema.tables where table_schema= 'wisepark_0327' and table_name= 'payInvoiceFtp' nr: 1 21/01/2025 15:50:08.4121 1513 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 21/01/2025 15:54:56.9582 771 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 21/01/2025 15:55:19.6885 800 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 21/01/2025 15:56:19.3194 795 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2025-01-21 15:56:18' where payTraUID = 5123778149471780 and payStatus='V' and payEnabled=1 21/01/2025 15:56:22.8137 970 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 21/01/2025 16:01:16.5381 580 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 21/01/2025 16:01:53.8210 775 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 21/01/2025 16:04:50.7239 640 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2025-01-21 16:04:49',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'; 21/01/2025 16:05:26.0155 521 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 21/01/2025 16:05:39.5396 668 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 21/01/2025 16:07:18.0265 592 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 21/01/2025 16:08:18.3319 700 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 21/01/2025 16:11:16.8174 819 ms. EXEC: insert into payPayment (payCreation,payUseId,payStatus,payUID,payTraUID,payYear,payDateTime,payIdTerminal,payEnabled,payDisableTime,payTarId,payTimeLimit,payType,payCurrency,payAmount,payPayed,payChange,payCardType,payPAN,paySTAN,payIdEvent,payAmountCalc,payDiscountValue,payDiscount,payDiscountType,payVatPercent,payVatAmount) VALUES ('2025-01-21 16:11:14',0,'V',5506607772573030,5194176814885790,2025,'2025-01-21 16:11:14',3,1,0,4,'2025-01-21 16:26:14','C','KES',50,100,50,'',' ',' ',1,50,0,0,'',0,0) 21/01/2025 16:11:17.6609 710 ms. EXEC: update payReceipt set recCreation = '2025-01-21 16:11:16',recModify = '2025-01-21 16:11:16',recUseId=0,recStatus='V' where recId = 344561 21/01/2025 16:11:50.3188 540 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 21/01/2025 16:11:54.3755 960 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 21/01/2025 16:12:45.5368 934 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 21/01/2025 16:13:08.5151 617 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 21/01/2025 16:14:50.7066 856 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2025-01-21 16:14:49' where traUID = 5006015280504240 and traStatus='V' and traEnabled=1 21/01/2025 16:16:12.2371 605 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 21/01/2025 16:18:20.7802 623 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 21/01/2025 16:19:34.3915 786 ms. EXEC: insert into movtransit (traUseId,traCreation,traStatus,traUID,traYear,traDateTime,traCode,traType,traClass,traIdTerminal,traDirection,traPlate,traEnabled,traDisableTime,traAreId,traNotes,traBadge,traTarId) VALUES (0,'2025-01-21 16:19:33','V',4762388072608260,2025,'2025-01-21 16:19:32','456765587000327005012999',2,2,2,'O','',0,'2025-01-21 16:19:33',1,'','',0) 21/01/2025 16:22:25.4890 507 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 21/01/2025 16:24:31.5344 584 ms. EXECSCALAR: select count(*) from information_schema.tables where table_schema= 'wisepark_0327' and table_name= 'payInvoiceFtp' nr: 1 21/01/2025 16:24:32.4210 669 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 21/01/2025 16:29:21.6767 616 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 21/01/2025 16:32:42.9815 1173 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 21/01/2025 16:32:54.6727 744 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 21/01/2025 16:34:10.2737 1113 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2025-01-21 16:34:09' where payTraUID = 5691465286808050 and payStatus='V' and payEnabled=1 21/01/2025 16:34:21.5573 1083 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 21/01/2025 16:35:08.0084 616 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 21/01/2025 16:40:38.3469 642 ms. EXEC: insert into payPayment (payCreation,payUseId,payStatus,payUID,payTraUID,payYear,payDateTime,payIdTerminal,payEnabled,payDisableTime,payTarId,payTimeLimit,payType,payCurrency,payAmount,payPayed,payChange,payCardType,payPAN,paySTAN,payIdEvent,payAmountCalc,payDiscountValue,payDiscount,payDiscountType,payVatPercent,payVatAmount) VALUES ('2025-01-21 16:37:19',1,'V',5144699215991260,4811510155698050,2025,'2025-01-21 16:37:19',17,1,0,4,'2025-01-21 16:52:19','C','KES',50,50,0,'','','',1,50,0,0,'',0,0) 21/01/2025 16:47:22.7352 585 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2025-01-21 16:47:22' where payTraUID = 5627654801566610 and payStatus='V' and payEnabled=1 21/01/2025 16:47:29.6508 552 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 21/01/2025 16:53:32.8184 829 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2025-01-21 16:53:31' where traUID = 5509451058670140 and traStatus='V' and traEnabled=1 21/01/2025 16:53:36.7820 676 ms. OPEN: select sum(crc32(terDescription)) as vCheck from tabTerminal 21/01/2025 16:53:42.2877 1127 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 21/01/2025 16:55:22.1875 626 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 21/01/2025 16:55:25.2015 633 ms. EXECSCALAR: select count(*) from tabTerminalExtraMem where extStatus='V' and extTerId = 16 nr: 1 21/01/2025 16:55:59.4347 544 ms. EXEC: update opeActivities set acvFstPayId = (case acvFstPayId when 0 then 396937 else acvFstPayId end),acvLstPayId = 396937 where acvSftId = 886 and acvCodeId = 3 21/01/2025 16:56:17.6449 514 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 21/01/2025 17:00:15.0214 536 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 21/01/2025 17:01:16.5201 653 ms. EXEC: delete from movInside where insTraUID = 5229903795848550 21/01/2025 17:01:51.0594 558 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 21/01/2025 17:02:59.0479 535 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 21/01/2025 17:03:13.3595 615 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 21/01/2025 17:05:45.7595 518 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 21/01/2025 17:07:23.1287 598 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 21/01/2025 17:11:28.5263 803 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 21/01/2025 17:11:42.0524 639 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 21/01/2025 17:18:28.5238 830 ms. EXEC: update abbCards set carLastDate = '2025-01-21 17:18:27',carLastDirection='O' where carStatus='V' and carId = 17 21/01/2025 17:18:29.4885 962 ms. OPEN: select * from tabArea where areId = 1 and areStatus='V' and areEnabled = 1 21/01/2025 17:23:35.3138 593 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2025-01-21 17:23:34' where payTraUID = 5116650236824710 and payStatus='V' and payEnabled=1 21/01/2025 17:23:43.1945 825 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 21/01/2025 17:29:14.7282 647 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 21/01/2025 17:38:09.8424 922 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 21/01/2025 17:38:54.2912 738 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 21/01/2025 17:42:24.2037 865 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 21/01/2025 17:43:21.9974 1392 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 21/01/2025 17:46:48.2115 698 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 21/01/2025 17:49:36.9854 598 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2025-01-21 17:49:36' where traUID = 5060142128984030 and traStatus='V' and traEnabled=1 21/01/2025 17:49:44.6776 1046 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 21/01/2025 17:49:58.9702 540 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 21/01/2025 17:50:04.0536 1053 ms. EXECSCALAR: select count(*) from information_schema.tables where table_schema= 'wisepark_0327' and table_name= 'payInvoiceFtp' nr: 1 21/01/2025 17:50:05.2824 593 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 21/01/2025 17:52:28.6844 647 ms. EXEC: insert into payReceipt (recTraUID,recPayUID,recYear,recDateTime,recText,recInvalid) VALUES (4763511351431070,4896507988039390,2025,'2025-01-21 17:52:28',' Date: 1/21/2025 5:52:27 PM Code: 456766188600327005012999 Entry Date: 1/21/2025 5:11:26 PM Plate: Class: Cars Park: The Mall Gate: Entry 2 ______________________________ Total: 50.00 KES ______________________________ Paid: 50.00 KES __________ Change: 0.00 KES Type: Cash Dispozitiv: MPESA # 2500703046 ',0) 21/01/2025 17:56:26.6857 829 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 21/01/2025 17:56:59.5878 907 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 (WAIT TIME 13 ms.) 21/01/2025 17:58:42.6297 1011 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2025-01-21 17:58:41',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'; 21/01/2025 18:01:32.0962 874 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 21/01/2025 18:07:23.7747 718 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 21/01/2025 18:07:23.8627 630 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 21/01/2025 18:07:24.1349 763 ms. EXECSCALAR: select count(*) from information_schema.tables where table_schema= 'wisepark_0327' and table_name= 'payInvoiceFtp' nr: 1 21/01/2025 18:09:42.0312 533 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 21/01/2025 18:11:42.2647 1100 ms. EXECSCALAR: select count(resId) as Tot from movReservation where resStatus = 'V' and resTypeRes = 'B' AND ((resConfirmed IN (0,2,3) AND resCreation>'2025-01-21 17:11:41') OR resConfirmed IN (4,5)) and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) <= '2025-01-21 18:11:41' and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) >= '2025-01-21 18:11:41' and (resAreId = 1 or resAreId <= 0) nr: 0 21/01/2025 18:20:14.0978 525 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 21/01/2025 18:20:42.2925 637 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 16 OR lnsTerId=16) 21/01/2025 18:23:28.0726 715 ms. EXECSCALAR: select count(*) from information_schema.tables where table_schema= 'wisepark_0327' and table_name= 'payInvoiceFtp' nr: 1 21/01/2025 18:23:28.9021 683 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 21/01/2025 18:27:17.3057 808 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 21/01/2025 18:32:08.4419 596 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 21/01/2025 18:41:30.0607 569 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 21/01/2025 18:41:31.3386 817 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2025-01-21 18:41:30' where payTraUID = 5301503611937560 and payStatus='V' and payEnabled=1 21/01/2025 18:41:33.2449 1906 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2025-01-21 18:41:30' where traUID = 5301503611937560 and traStatus='V' and traEnabled=1 21/01/2025 18:41:49.2916 1526 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 21/01/2025 18:56:36.4953 1003 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 21/01/2025 19:05:51.2602 534 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2025-01-21 19:05:50' where traUID = 5334029372132700 and traStatus='V' and traEnabled=1 21/01/2025 19:09:11.7915 742 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 3 21/01/2025 19:18:58.9148 724 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 2 and terStatus='V' 21/01/2025 19:33:15.5544 528 ms. EXEC: update paycash set casCreation = '2025-01-21 19:33:15',casModify = '2025-01-21 19:33:15',casUseId=0,casStatus='V' where casId = 206003 21/01/2025 19:37:39.2440 595 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 21/01/2025 19:38:55.7642 637 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 21/01/2025 19:51:15.8667 793 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 21/01/2025 19:53:42.7040 510 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 21/01/2025 19:53:44.4942 617 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 21/01/2025 19:53:45.1577 562 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 21/01/2025 19:53:45.9162 636 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 21/01/2025 19:53:49.3735 3352 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 21/01/2025 19:55:40.0826 1960 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 21/01/2025 20:03:45.6987 1929 ms. OPEN: select * from payCurInventory where curTerId = 3 and curQuantity>0 and curType in ('C','N') order by curDevCode,curChannelId,curValue 21/01/2025 20:03:55.8905 1050 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 21/01/2025 20:08:24.1171 693 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 5 and terStatus='V' 21/01/2025 20:14:21.1137 701 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2025-01-21 20:14:20' where payTraUID = 5083743517286050 and payStatus='V' and payEnabled=1 21/01/2025 20:14:29.7226 929 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 21/01/2025 20:18:14.7928 631 ms. EXEC: insert into payPayment (payCreation,payUseId,payStatus,payUID,payTraUID,payYear,payDateTime,payIdTerminal,payEnabled,payDisableTime,payTarId,payTimeLimit,payType,payCurrency,payAmount,payPayed,payChange,payCardType,payPAN,paySTAN,payIdEvent,payAmountCalc,payDiscountValue,payDiscount,payDiscountType,payVatPercent,payVatAmount) VALUES ('2025-01-21 20:18:14',0,'V',5133218527921210,5219474018925040,2025,'2025-01-21 20:18:14',18,1,0,4,'2025-01-21 20:33:14','C','KES',50,50,0,'','','',1,50,0,0,'',0,0) 21/01/2025 20:18:17.3696 2433 ms. EXEC: update tabTerminalReceipt set trcProgressive = 3059, trcLastPrinted = '2500703059', trcLastDate = '2025-01-21 20:18:14' where trcStatus='V' and trcTerId = 18 21/01/2025 20:31:53.4766 718 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 21/01/2025 20:33:31.8959 1280 ms. EXEC: insert into abbPayment (payCreation,payCode,payAmount,payCredit,payPayUID,payCarId,payDateFrom,payDateTo) VALUES ('2025-01-21 20:33:30','0230004098567',0,0,5634490408196380,165,'0000-00-00 00:00:00','0000-00-00 00:00:00') 21/01/2025 20:37:43.2800 501 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 21/01/2025 20:45:31.0383 1962 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 21/01/2025 20:49:46.6935 613 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 21/01/2025 20:56:34.3280 1695 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 21/01/2025 21:05:19.2298 539 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 21/01/2025 21:20:31.9599 640 ms. EXEC: update opeActivities set acvFstPayId = (case acvFstPayId when 0 then 397010 else acvFstPayId end),acvLstPayId = 397010 where acvSftId = 889 and acvCodeId = 3 21/01/2025 21:22:11.9268 907 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2025-01-21 21:22:11' where payTraUID = 4796929995236980 and payStatus='V' and payEnabled=1 21/01/2025 21:22:16.8942 686 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 21/01/2025 21:23:19.6662 854 ms. EXEC: insert into movtransit (traUseId,traCreation,traStatus,traUID,traYear,traDateTime,traCode,traType,traClass,traIdTerminal,traDirection,traPlate,traEnabled,traDisableTime,traAreId,traNotes,traBadge,traTarId) VALUES (0,'2025-01-21 21:23:18','V',5726132925086720,2025,'2025-01-21 21:23:18','456767605500327005012999',2,2,2,'O','',0,'2025-01-21 21:23:18',1,'','',0) 21/01/2025 21:24:55.9367 534 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 21/01/2025 21:28:13.6230 579 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 21/01/2025 21:31:46.9548 713 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 21/01/2025 21:39:30.2735 864 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 21/01/2025 21:45:19.0252 1077 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 21/01/2025 21:55:56.2891 641 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 21/01/2025 21:58:25.0827 713 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 21/01/2025 21:58:25.1367 601 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 5 21/01/2025 21:58:28.3329 806 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 21/01/2025 21:58:42.2652 1103 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 21/01/2025 21:59:06.0661 1710 ms. EXEC: insert into movBarrier (barUseId,barCreation,barTerId,barAction,barDescription,barPlate) VALUES (1,'2025-01-21 21:59:04',9999,'open','Send command to entry/exit units: Command OPEN on Device Exit 1 ','') 21/01/2025 21:59:10.4181 697 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 21/01/2025 21:59:47.4779 556 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 2 and terStatus='V' 21/01/2025 21:59:47.9462 1012 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 21/01/2025 22:05:50.2078 534 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 21/01/2025 22:11:22.1117 625 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 21/01/2025 22:25:52.1467 917 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 4 21/01/2025 22:25:52.4238 1209 ms. OPEN: show columns from tabParameters where Field = 'parUseCulture' 21/01/2025 22:25:53.1023 952 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 21/01/2025 22:25:54.1730 627 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 21/01/2025 22:27:32.7670 749 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 21/01/2025 22:27:44.2587 1970 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 21/01/2025 22:37:58.1996 760 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 21/01/2025 23:01:37.4458 882 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 21/01/2025 23:05:57.7908 636 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 21/01/2025 23:11:38.9532 1112 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 1 21/01/2025 23:21:29.1369 593 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 21/01/2025 23:32:08.9152 812 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 21/01/2025 23:36:09.6073 1099 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 21/01/2025 23:51:25.1223 992 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1