29/01/2025 00:04:46.8538 633 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 29/01/2025 00:06:26.9178 612 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 29/01/2025 00:10:27.1229 640 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 29/01/2025 00:10:45.8224 876 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 29/01/2025 00:13:59.0649 533 ms. EXEC: insert into paycash (casCreation,casModify,casUseId,casStatus,casUID,casTraUID,casYear,casDateTime,casIdTerminal,casCurrency,casNumber,casSingleAmount,casTotAmount,casType,casDescription) VALUES ('2025-01-29 00:13:58',0,0,'V',4745818323170160,5255316854258310,2025,'2025-01-29 00:13:58',3,'KES',1,100,100,'N',''); 29/01/2025 00:18:02.9353 1433 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-29 00:18:01','V',4730184341061150,2025,'2025-01-29 00:18:00','456837076800327005012999',2,2,2,'O','',0,'2025-01-29 00:18:01',1,'','',0) 29/01/2025 00:18:09.6969 541 ms. EXECSCALAR: select count(*) from information_schema.tables where table_schema= 'wisepark_0327' and table_name= 'payInvoiceFtp' nr: 1 29/01/2025 00:20:06.8715 1123 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 29/01/2025 00:21:59.9925 779 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 29/01/2025 00:22:50.7375 1257 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 29/01/2025 00:23:34.1867 580 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 29/01/2025 00:39:02.3407 524 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 29/01/2025 00:42:12.0007 588 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 29/01/2025 01:02:02.1802 1180 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 29/01/2025 01:20:37.8505 697 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 29/01/2025 01:23:33.8224 688 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 29/01/2025 01:23:33.8234 687 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 5 29/01/2025 01:32:02.9577 1009 ms. EXEC: UPDATE payCash SET casType='N' WHERE casType<>'N' AND ABS(casSingleAmount) IN (100,200,500); 29/01/2025 01:38:17.5536 2384 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 29/01/2025 01:51:12.3851 887 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 29/01/2025 01:53:11.6019 558 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 1 OR lnsTerId=1) 29/01/2025 02:02:13.1726 517 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 29/01/2025 02:25:51.8722 852 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 29/01/2025 02:47:11.9878 832 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 29/01/2025 02:49:59.3509 1050 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 29/01/2025 02:50:05.2768 970 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 29/01/2025 02:55:47.8183 731 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 29/01/2025 02:58:37.8273 993 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 29/01/2025 03:06:04.5349 1256 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 29/01/2025 03:08:18.9739 1087 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 29/01/2025 03:19:20.8012 531 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 29/01/2025 03:23:15.6682 901 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 16 OR lnsTerId=16) 29/01/2025 03:31:10.7312 642 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 29/01/2025 03:33:26.0256 537 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 5 29/01/2025 03:39:47.6676 688 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 29/01/2025 03:40:05.5826 674 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 29/01/2025 03:41:35.2615 765 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 29/01/2025 03:43:26.2907 873 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 29/01/2025 03:43:51.6607 667 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 29/01/2025 03:44:31.9086 572 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 29/01/2025 03:52:39.7996 534 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 2 OR lnsTerId=2) 29/01/2025 03:54:03.0452 557 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 29/01/2025 03:59:45.0371 896 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 29/01/2025 04:16:19.0273 768 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 29/01/2025 04:25:13.3133 521 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 29/01/2025 04:25:30.8951 1253 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 29/01/2025 04:25:38.5342 575 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 29/01/2025 04:32:40.7323 503 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 29/01/2025 04:34:24.3546 561 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 29/01/2025 04:36:02.1639 849 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 29/01/2025 04:42:22.5551 1370 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 2 OR lnsTerId=2) 29/01/2025 04:43:28.7573 514 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 29/01/2025 04:43:57.8508 647 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 29/01/2025 04:49:44.1455 616 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 29/01/2025 05:05:13.0068 610 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 29/01/2025 05:17:19.9775 757 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 29/01/2025 05:18:15.5337 529 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 29/01/2025 05:21:56.1681 1246 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 29/01/2025 05:23:47.2593 946 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 29/01/2025 05:30:04.7986 832 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 29/01/2025 05:30:55.9658 838 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 29/01/2025 05:33:25.2600 541 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 29/01/2025 05:50:33.0268 590 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 29/01/2025 05:50:51.7183 869 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 29/01/2025 05:57:08.1548 720 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 29/01/2025 05:58:54.1887 555 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 2 and terStatus='V' 29/01/2025 06:00:13.3846 643 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 29/01/2025 06:03:06.3052 632 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 29/01/2025 06:29:20.7898 723 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 2 29/01/2025 06:40:21.8776 1325 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 29/01/2025 06:47:29.4033 584 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 29/01/2025 06:48:19.6208 979 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 29/01/2025 06:52:31.6102 1257 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 29/01/2025 06:59:11.8197 686 ms. OPEN: show columns from tabTerminalExtraMem where Field = 'extCode' (WAIT TIME 21 ms.) 29/01/2025 07:05:14.5284 669 ms. EXEC: insert into paycash (casCreation,casModify,casUseId,casStatus,casUID,casTraUID,casYear,casDateTime,casIdTerminal,casCurrency,casNumber,casSingleAmount,casTotAmount,casType,casDescription) VALUES ('2025-01-29 07:05:13',0,0,'V',4792480842706180,5569367854857840,2025,'2025-01-29 07:05:13',3,'KES',1,1000,1000,'N',''); 29/01/2025 07:05:15.9564 1336 ms. EXEC: insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2025-01-29 07:05:13',3,42101,0,1000,1,1000,2,'I','N'); update payCurInventory set curQuantity=round(curQuantity+1,5),curAmount=round(curAmount+1000,5) where curTerId = 3 and curDevCode = 42101 and curChannelId = 2 and curValue = 1000 and curType = 'N'; 29/01/2025 07:05:32.9277 578 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 (WAIT TIME 4 ms.) 29/01/2025 07:06:17.3774 1300 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 29/01/2025 07:06:26.8477 678 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 29/01/2025 07:11:43.6474 664 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-29 07:11:42','V',5022024416484120,2025,'2025-01-29 07:11:42','456842590200327005012999',1,2,16,'I','',1,0,1,'','0560008336057',179,0) 29/01/2025 07:11:46.1871 1356 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 29/01/2025 07:11:58.7585 829 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 29/01/2025 07:12:32.1789 522 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 29/01/2025 07:13:25.8157 1133 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 29/01/2025 07:13:39.0776 1240 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 29/01/2025 07:14:48.1197 596 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 29/01/2025 07:15:18.6471 1644 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 2 and terStatus='V' 29/01/2025 07:17:20.1193 611 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 5 29/01/2025 07:18:42.9078 641 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 29/01/2025 07:19:00.2344 528 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 29/01/2025 07:19:24.8348 572 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 29/01/2025 07:19:35.3809 890 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 29/01/2025 07:19:45.7308 515 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 29/01/2025 07:21:38.9875 716 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 29/01/2025 07:44:48.1215 1079 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 29/01/2025 07:45:28.7176 860 ms. EXEC: UPDATE payInventory SET invType='N' WHERE invType<>'N' AND invValue IN (100,200,500) AND invDevice IN (42102,42101,42001); 29/01/2025 07:46:13.2754 1217 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 29/01/2025 07:47:36.6801 653 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 29/01/2025 07:48:51.3320 742 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 29/01/2025 07:55:22.9247 567 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 5 29/01/2025 08:00:17.8168 743 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 29/01/2025 08:04:24.1724 1042 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 29/01/2025 08:04:30.1764 768 ms. EXECSCALAR: select count(0) as vTot from tabParameters where parPlateReading<>0 nr: 0 29/01/2025 08:07:07.6836 624 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 29/01/2025 08:07:38.0149 534 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 29/01/2025 08:09:52.3707 537 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 29/01/2025 08:10:07.3147 1587 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 29/01/2025 08:13:37.4261 817 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 29/01/2025 08:13:38.0355 609 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); 29/01/2025 08:18:05.9107 729 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 29/01/2025 08:23:04.7955 599 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-29 08:23:04',0,'V',5510107894654190,5110758538976460,2025,'2025-01-29 08:23:04',18,1,0,4,'2025-01-29 08:38:04','C','KES',50,50,0,'','','',1,50,0,0,'',0,0) 29/01/2025 08:24:11.6071 640 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 29/01/2025 08:24:20.1028 2193 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 29/01/2025 08:25:43.4675 593 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-29 08:25:42',0,'V',5097390410524490,5325332842543670,2025,'2025-01-29 08:25:42',18,1,0,4,'2025-01-29 08:40:42','C','KES',50,50,0,'','','',1,50,0,0,'',0,0) 29/01/2025 08:27:09.0467 662 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 29/01/2025 08:27:47.4163 566 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2025-01-29 08:27:46' where payTraUID = 5325332842543670 and payStatus='V' and payEnabled=1 29/01/2025 08:27:49.1375 1716 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 29/01/2025 08:30:04.0356 638 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 29/01/2025 08:31:48.0421 1467 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 29/01/2025 08:32:58.7474 2265 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 29/01/2025 08:35:18.1135 526 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 1 OR lnsTerId=1) 29/01/2025 08:36:04.1352 656 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 29/01/2025 08:37:16.2824 634 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-29 08:37:15','V',4773361321107810,2025,'2025-01-29 08:37:14','456843103400327005012999',1,2,16,'I','',1,0,1,'','0810007103066',82,0) 29/01/2025 08:38:42.4963 1070 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 5 and terStatus='V' 29/01/2025 08:39:54.5414 1196 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 3 OR lnsTerId=3) 29/01/2025 08:40:27.8237 2278 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 29/01/2025 08:43:48.4367 514 ms. EXEC: INSERT INTO movOperator (opeCreation,opeUseId,opeTerId,opeDateTime,opeCode,opeDescription) VALUES ('2025-01-29 08:43:47',0,2,'2025-01-29 08:43:47','','Unauthorized Transit Exit 1') 29/01/2025 08:43:57.5808 868 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 29/01/2025 08:43:58.9287 1224 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2025-01-29 08:43:57' where traUID = 5631373749985650 and traStatus='V' and traEnabled=1 29/01/2025 08:44:02.4361 602 ms. EXEC: UPDATE payInventory SET invType='N' WHERE invType<>'N' AND invValue IN (100,200,500) AND invDevice IN (42102,42101,42001); 29/01/2025 08:50:17.8558 805 ms. EXEC: INSERT INTO movOperator (opeCreation,opeUseId,opeTerId,opeDateTime,opeCode,opeDescription) VALUES ('2025-01-29 08:50:17',0,2,'2025-01-29 08:50:17','','Unauthorized Transit Exit 1') 29/01/2025 09:01:29.4526 614 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2025-01-29 09:01:28' where payTraUID = 4833800999070570 and payStatus='V' and payEnabled=1 29/01/2025 09:02:05.3926 879 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 29/01/2025 09:02:30.9697 631 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 29/01/2025 09:02:51.2393 709 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 29/01/2025 09:05:04.6144 863 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-29 09:05:03',0,'V',5740417423695770,5402433374681610,2025,'2025-01-29 09:05:03',18,1,0,4,'2025-01-29 09:20:03','C','KES',50,50,0,'','','',1,50,0,0,'',0,0) 29/01/2025 09:06:39.7860 523 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 29/01/2025 09:07:09.2497 768 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-29 09:07:08','V',5072155701458650,2025,'2025-01-29 09:07:07','456842380600327005012999',2,2,2,'O','',0,'2025-01-29 09:07:08',1,'','',0) 29/01/2025 09:07:13.6406 1283 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 29/01/2025 09:11:12.8054 572 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 29/01/2025 09:12:22.5971 572 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 16 OR lnsTerId=16) 29/01/2025 09:15:50.9753 668 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 16 OR lnsTerId=16) 29/01/2025 09:16:30.8309 941 ms. OPEN: select * from tabTariff left join tabtlkTariff on tlkTarId = tarId where (tarValidFrom <= '2025-01-29' and tarValidTo >= '2025-01-29' and tarStatus='V' and tlkAreId = 1 and tlkStatus='V') and (((tarIdClass = 2 or tarIdClass <=0) and tarEnabled <> 0) or tarDefault<>0) order by tarModify desc,tarId desc 29/01/2025 09:16:34.6865 866 ms. OPEN: select * from tabCurrency where curStatus='V' and curCode = 'KES' 29/01/2025 09:16:38.1568 821 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 29/01/2025 09:16:52.9667 4493 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 29/01/2025 09:19:53.5791 1451 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 29/01/2025 09:20:55.9978 1806 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 29/01/2025 09:21:39.0417 612 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-29 09:21:38','V',5224094243317260,2025,'2025-01-29 09:21:37','456843266000327005012999',2,2,2,'O','',0,'2025-01-29 09:21:38',1,'','',0) 29/01/2025 09:23:08.3968 1012 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 29/01/2025 09:24:22.6745 1189 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 29/01/2025 09:25:21.1365 678 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 29/01/2025 09:33:01.4917 664 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 29/01/2025 09:37:46.7568 603 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 29/01/2025 09:37:46.8669 577 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 16 OR lnsTerId=16) 29/01/2025 09:37:47.0510 843 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 29/01/2025 09:41:10.2691 575 ms. OPEN: show columns from tabTerminalExtraMem where Field = 'extCode' 29/01/2025 09:46:26.2763 1237 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 29/01/2025 09:48:09.5423 530 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-29 09:48:07',0,'V',5002465561026130,5642308733406020,2025,'2025-01-29 09:48:07',3,1,0,4,'2025-01-29 10:03:07','C','KES',50,50,0,'',' ',' ',1,50,0,0,'',0,0) 29/01/2025 09:49:55.8953 1465 ms. OPEN: show columns from tabParameters where Field = 'parUseCulture' 29/01/2025 09:53:47.4751 1083 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 29/01/2025 09:54:38.4862 659 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 29/01/2025 09:55:21.2037 1055 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 29/01/2025 09:56:14.6644 737 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 29/01/2025 09:58:50.2304 566 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 29/01/2025 09:59:06.5893 1247 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 29/01/2025 10:01:56.3310 572 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-29 10:01:24',9,'V',4982591862135290,5640295641837980,2025,'2025-01-29 10:01:24',4,1,0,4,'2025-01-29 10:16:24','P','KES',50,50,0,'','','',1,50,0,0,'',0,0) 29/01/2025 10:04:13.5647 581 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-29 10:04:12','V',5566158864327640,2025,'2025-01-29 10:04:11','456843511900327005012999',2,2,2,'O','',0,'2025-01-29 10:04:12',1,'','',0) 29/01/2025 10:11:06.7793 549 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 29/01/2025 10:13:06.1732 728 ms. EXECSCALAR: select count(0) as vTot from tabParameters where parPlateReading<>0 nr: 0 29/01/2025 10:17:37.1439 530 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 29/01/2025 10:19:39.3846 4219 ms. EXEC: insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2025-01-29 10:19:20',5,3,42101,0,50,-25,-1250,1,'O','N'); insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2025-01-29 10:19:20',5,3,42101,0,50,25,1250,2,'I','N'); insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2025-01-29 10:19:20',5,3,42101,0,100,-26,-2600,1,'O','N'); insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2025-01-29 10:19:20',5,3,42101,0,100,26,2600,2,'I','N'); insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2025-01-29 10:19:20',5,3,42101,0,200,-8,-1600,1,'O','N'); insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2025-01-29 10:19:20',5,3,42101,0,200,8,1600,2,'I','N'); insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2025-01-29 10:19:20',5,3,42101,0,500,-1,-500,1,'O','N'); insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2025-01-29 10:19:20',5,3,42101,0,500,1,500,2,'I','N'); insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2025-01-29 10:19:20',5,3,42101,1,0,0,0,1,'O',''); update payCurInventory set curQuantity=0,curAmount=0 where curQuantity<0; 29/01/2025 10:19:41.5601 534 ms. EXEC: insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2025-01-29 10:19:30',5,3,42101,0,50,-30,-1500,2,'O','N'); insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2025-01-29 10:19:30',5,3,42101,0,100,-33,-3300,2,'O','N'); insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2025-01-29 10:19:30',5,3,42101,0,200,-8,-1600,2,'O','N'); insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2025-01-29 10:19:30',5,3,42101,0,500,-1,-500,2,'O','N'); insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2025-01-29 10:19:30',5,3,42101,0,1000,-1,-1000,2,'O','N'); insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2025-01-29 10:19:30',5,3,42101,1,0,0,0,2,'O',''); update payCurInventory set curQuantity=0,curAmount=0 where curQuantity<0; 29/01/2025 10:21:34.0222 744 ms. EXEC: UPDATE payInventory SET invType='N' WHERE invType<>'N' AND invValue IN (100,200,500) AND invDevice IN (42102,42101,42001); 29/01/2025 10:21:46.2274 1544 ms. EXECSCALAR: select count(*) from information_schema.tables where table_schema= 'wisepark_0327' and table_name= 'payInvoiceFtp' nr: 1 29/01/2025 10:21:46.2504 1566 ms. OPEN: show columns from tabParameters where Field = 'parAllowNegativePlaces' 29/01/2025 10:23:50.0912 785 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 29/01/2025 10:23:51.5021 1354 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2025-01-29 10:23:50' where traUID = 5564033213785520 and traStatus='V' and traEnabled=1 29/01/2025 10:24:14.8967 722 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 29/01/2025 10:26:16.9953 545 ms. EXEC: insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2025-01-29 10:26:12',5,3,42101,0,50,18,900,1,'I','N'); update payCurInventory set curQuantity=round(curQuantity+18,5),curAmount=round(curAmount+900,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 ('2025-01-29 10:26:12',5,3,42101,0,200,2,400,1,'I','N'); update payCurInventory set curQuantity=round(curQuantity+2,5),curAmount=round(curAmount+400,5) where curTerId = 3 and curDevCode = 42101 and curChannelId = 1 and curValue = 200 and curType = 'N'; insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2025-01-29 10:26:12',5,3,42101,0,100,7,700,1,'I','N'); update payCurInventory set curQuantity=round(curQuantity+7,5),curAmount=round(curAmount+700,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; 29/01/2025 10:26:23.1274 610 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-29 10:26:22','V',5755502704140090,2025,'2025-01-29 10:26:19','456840000200327003229999',22,22,3,'I','',1,0,1,'','',2) 29/01/2025 10:26:51.3142 528 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 29/01/2025 10:27:02.2015 695 ms. EXEC: update payReceipt set recCreation = '2025-01-29 10:27:01',recModify = '2025-01-29 10:27:01',recUseId=0,recStatus='V' where recId = 346866 29/01/2025 10:29:20.4099 514 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 29/01/2025 10:29:23.3078 1326 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 29/01/2025 10:31:05.4711 1761 ms. EXEC: update tabTerminalReceipt set trcProgressive = 1250, trcLastPrinted = '2500401250', trcLastDate = '2025-01-29 10:31:03' where trcStatus='V' and trcTerId = 4 29/01/2025 10:32:34.3445 1892 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 29/01/2025 10:33:29.9256 646 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 29/01/2025 10:35:42.0579 915 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 5 29/01/2025 10:36:37.6250 625 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 29/01/2025 10:36:42.9176 635 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 29/01/2025 10:39:40.5042 1148 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 29/01/2025 10:42:19.3534 3270 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 29/01/2025 10:45:02.1749 978 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 29/01/2025 10:48:17.6035 593 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-29 10:48:17','V',5267884609659260,2025,'2025-01-29 10:48:15','456840000300327003229999',22,22,3,'I','',1,0,1,'','',2) 29/01/2025 10:49:16.2307 501 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2025-01-29 10:49:15',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'; 29/01/2025 10:49:34.9252 596 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 29/01/2025 10:50:36.9346 1043 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 29/01/2025 10:50:41.0314 603 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 29/01/2025 10:50:48.9377 502 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-29 10:50:48','V',5721541467513960,2025,'2025-01-29 10:50:47','456843904700327005012999',1,2,16,'I','',1,0,1,'','0230003944081',15,0) 29/01/2025 10:51:50.1369 2030 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 29/01/2025 10:53:06.7481 1720 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 29/01/2025 10:53:07.4095 595 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2025-01-29 10:53:06' where payTraUID = 4805312219714930 and payStatus='V' and payEnabled=1 29/01/2025 10:53:11.9956 772 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 29/01/2025 10:54:01.3066 764 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-29 10:54:00','V',5627954123511350,2025,'2025-01-29 10:53:59','456843923900327005012999',1,2,16,'I','',1,0,1,'','',4) 29/01/2025 10:55:32.7046 769 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 29/01/2025 11:00:12.8208 2000 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-29 11:00:10','V',5004138991373520,2025,'2025-01-29 11:00:10','456843961000327005012999',1,2,16,'I','',1,0,1,'','',4) 29/01/2025 11:00:40.1221 2027 ms. EXEC: update payReceipt set recCreation = '2025-01-29 11:00:38',recModify = '2025-01-29 11:00:38',recUseId=0,recStatus='V' where recId = 346880 29/01/2025 11:04:32.5403 678 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 29/01/2025 11:09:57.7276 676 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 29/01/2025 11:11:25.0739 700 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 29/01/2025 11:11:37.2531 549 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 29/01/2025 11:11:50.8752 656 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 29/01/2025 11:12:26.1888 663 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 29/01/2025 11:12:27.2215 1006 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 29/01/2025 11:12:28.1211 948 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 29/01/2025 11:13:33.3136 644 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 29/01/2025 11:15:22.8208 648 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 29/01/2025 11:15:23.4662 553 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2025-01-29 11:15:22' where payTraUID = 5568204793037000 and payStatus='V' and payEnabled=1 29/01/2025 11:16:02.4563 553 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 29/01/2025 11:17:16.3847 842 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 29/01/2025 11:18:27.4082 591 ms. OPEN: select count(payId) as Tot,0 as payUID,sum(payPayed) as payPayed,sum(payChange) as payChange,payAmount,traUIDGroup,traType,traClass,traIdTerminal,traDiscountValue,traDiscountType,traCarId,payIdEvent,payType,payCardType from payPayment LEFT join movtransit on trauid = payTraUID LEFT JOIN payReport ON repPayUID = payUID AND repStatus='V' where payStatus = 'V' and (payType='C' or payType='P') and payUseId = 1 and payIdEvent<90 and repPayUID IS NULL and (traCarId is null or traCarId=0 or traCarId in (select carId from abbCards inner join abbsubscriptions on subId= carSubId where carStatus='V' and subStatus='V' and subAbbType<>5)) group by traUIDGroup,payAmount,payIdEvent,payType,payCardType,traType,traIdTerminal,traDiscountValue,traDiscountType,traCarId order by traUIDGroup,payAmount, traType, traDiscountValue, traDiscountType 29/01/2025 11:20:14.7699 746 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 29/01/2025 11:20:29.9380 777 ms. EXEC: insert into payReceipt (recTraUID,recPayUID,recYear,recDateTime,recText,recInvalid) VALUES (4716568604484550,5338926234700690,2025,'2025-01-29 11:20:29',' Date: 1/29/2025 11:19:57 AM Code: 456843876000327005012999 Entry Date: 1/29/2025 10:46:00 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 # 2500401259 ',0) 29/01/2025 11:22:23.4539 571 ms. OPEN: select sum(crc32(terDescription)) as vCheck from tabTerminal 29/01/2025 11:22:23.6210 598 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 29/01/2025 11:23:22.9596 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-29 11:23:22','V',4802456231297330,2025,'2025-01-29 11:23:21','456844100100327005012999',1,2,16,'I','',1,0,1,'','',4) 29/01/2025 11:30:53.8722 825 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 29/01/2025 11:30:54.6247 651 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 29/01/2025 11:30:55.2962 570 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 29/01/2025 11:31:11.5330 543 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 29/01/2025 11:31:14.4820 1047 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 29/01/2025 11:43:43.4475 510 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2025-01-29 11:43:42' where traUID = 4671585679281840 and traStatus='V' and traEnabled=1 29/01/2025 11:43:49.7697 637 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 29/01/2025 11:46:58.9191 524 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 3 29/01/2025 11:47:15.2720 3342 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 29/01/2025 11:47:18.0799 1642 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 29/01/2025 11:48:49.8852 2201 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 2 OR lnsTerId=2) 29/01/2025 11:49:47.4857 531 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 29/01/2025 11:50:46.7083 961 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 2 OR lnsTerId=2) 29/01/2025 11:51:09.1463 841 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 29/01/2025 11:55:52.3295 1849 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2025-01-29 11:55:50' where traUID = 5285237479655800 and traStatus='V' and traEnabled=1 29/01/2025 11:56:22.6668 529 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 29/01/2025 11:59:15.4613 1077 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 29/01/2025 11:59:47.1715 654 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2025-01-29 11:59:46',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'; 29/01/2025 12:00:04.9383 518 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 16 OR lnsTerId=16) 29/01/2025 12:01:06.4394 679 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 29/01/2025 12:02:48.4606 559 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 29/01/2025 12:03:05.4449 833 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-29 12:03:04','V',4960904380122450,2025,'2025-01-29 12:03:02','456844338200327001012999',1,2,1,'I','',1,0,1,'','',4) 29/01/2025 12:03:05.4449 787 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-29 12:03:04',0,'V',5666421104842430,5004138991373520,2025,'2025-01-29 12:03:04',18,1,0,4,'2025-01-29 12:18:04','C','KES',100,100,0,'','','',1,100,0,0,'',0,0) 29/01/2025 12:03:57.5318 522 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 29/01/2025 12:08:54.7273 573 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-29 12:08:54','V',4895679532709100,2025,'2025-01-29 12:08:52','456844373200327005012999',1,2,16,'I','',1,0,1,'','',4) 29/01/2025 12:11:46.5412 628 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 29/01/2025 12:11:47.1256 571 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 29/01/2025 12:11:47.7490 632 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 29/01/2025 12:11:52.8053 900 ms. EXEC: UPDATE payInventory SET invType='N' WHERE invType<>'N' AND invValue IN (100,200,500) AND invDevice IN (42102,42101,42001); 29/01/2025 12:12:29.8001 628 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 29/01/2025 12:12:35.4749 1492 ms. OPEN: select * from tabArea where areStatus='V' and areEnabled = 1 AND areId = 1 29/01/2025 12:15:00.5958 1222 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 29/01/2025 12:15:10.1002 613 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 29/01/2025 12:15:38.6893 610 ms. OPEN: show columns from tabTariff where Field = 'tarTimeControlTimeBegin' (WAIT TIME 1 ms.) 29/01/2025 12:16:13.7297 527 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 2 29/01/2025 12:17:10.7358 589 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 16 OR lnsTerId=16) 29/01/2025 12:17:45.1458 2888 ms. EXEC: update paycash set casCreation = '2025-01-29 12:17:42',casModify = '2025-01-29 12:17:42',casUseId=0,casStatus='V' where casId = 207008 29/01/2025 12:18:30.0078 875 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-29 12:18:29','V',4675485658662580,2025,'2025-01-29 12:18:27','456844306400327005012999',2,2,2,'O','',0,'2025-01-29 12:18:29',1,'','',0) 29/01/2025 12:18:30.9964 636 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2025-01-29 12:18:30' where payTraUID = 5410501055499760 and payStatus='V' and payEnabled=1 29/01/2025 12:18:37.7379 690 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 29/01/2025 12:20:18.3752 706 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2025-01-29 12:20:17' where traUID = 5452392088148830 and traStatus='V' and traEnabled=1 29/01/2025 12:20:40.7902 593 ms. OPEN: show columns from tmpPay where Field = 'tmpVatType' 29/01/2025 12:22:55.9705 552 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 29/01/2025 12:25:01.1471 636 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 29/01/2025 12:29:43.9641 2001 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 29/01/2025 12:29:44.0362 2469 ms. EXEC: update payInventory set invCreation = '2025-01-29 12:29:41',invModify = '2025-01-29 12:29:41',invUseId=0,invStatus='V' where invId = 233802 29/01/2025 12:29:45.0158 677 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2025-01-29 12:29:44',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'; 29/01/2025 12:30:54.2901 587 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 29/01/2025 12:31:13.8242 701 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2025-01-29 12:31:13' where payTraUID = 5601877754953550 and payStatus='V' and payEnabled=1 29/01/2025 12:31:14.9960 1156 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2025-01-29 12:31:13' where traUID = 5601877754953550 and traStatus='V' and traEnabled=1 29/01/2025 12:31:51.4753 1080 ms. EXEC: update abbAreaGroup set argNrInside = argNrInside - 1 where argStatus='V' and argAreId = 1 and argAbgId = 99999 29/01/2025 12:31:54.9166 658 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 29/01/2025 12:31:55.5881 623 ms. EXEC: UPDATE payInventory SET invType='N' WHERE invType<>'N' AND invValue IN (100,200,500) AND invDevice IN (42102,42101,42001); 29/01/2025 12:32:57.0862 710 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-29 12:32:56','V',4634806257546990,2025,'2025-01-29 12:32:54','456844370100327005012999',2,2,2,'O','',0,'2025-01-29 12:32:56',1,'','',0) 29/01/2025 12:32:57.8807 690 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 29/01/2025 12:33:00.8777 2856 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2025-01-29 12:32:57' where traUID = 5003770639701120 and traStatus='V' and traEnabled=1 29/01/2025 12:36:01.9457 1002 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 3 29/01/2025 12:36:08.6662 1055 ms. EXEC: insert into abbPayment (payCreation,payCode,payAmount,payCredit,payPayUID,payCarId,payDateFrom,payDateTo) VALUES ('2025-01-29 12:36:07','0230003944081',0,0,5730475402387030,15,'0000-00-00 00:00:00','0000-00-00 00:00:00') 29/01/2025 12:36:10.1402 691 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2025-01-29 12:36:09' where payTraUID = 4648175511944300 and payStatus='V' and payEnabled=1 29/01/2025 12:36:13.3203 549 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 29/01/2025 12:36:14.7342 866 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 29/01/2025 12:36:26.5632 907 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2025-01-29 12:36:25' where payTraUID = 5243223705585020 and payStatus='V' and payEnabled=1 29/01/2025 12:36:38.3370 547 ms. EXEC: update abbCards set carLastDate = '2025-01-29 12:36:37',carLastDirection='O' where carStatus='V' and carId = 21 29/01/2025 12:39:40.2376 561 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 29/01/2025 12:39:56.1272 691 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-29 12:39:55',0,'V',5050895246922110,4910473469865880,2025,'2025-01-29 12:39:55',2,1,0,-1,'2025-01-29 13:39:55','S','KES',0,0,0,'','','',3,0,0) 29/01/2025 12:39:57.8323 514 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 29/01/2025 12:39:58.5208 530 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2025-01-29 12:39:57' where payTraUID = 4910473469865880 and payStatus='V' and payEnabled=1 29/01/2025 12:43:58.5192 645 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 29/01/2025 12:44:08.9671 1096 ms. EXECSCALAR: select count(0) as vTot from tabParameters where parPlateReading<>0 nr: 0 29/01/2025 12:45:03.9989 1334 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 (WAIT TIME 527 ms.) 29/01/2025 12:47:00.3276 534 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 29/01/2025 12:47:08.6872 533 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 5 and terStatus='V' 29/01/2025 12:48:22.4595 1078 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 29/01/2025 12:49:31.8709 1197 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 29/01/2025 12:52:38.8759 731 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 29/01/2025 12:54:24.0401 707 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 29/01/2025 12:57:01.9116 578 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 3 and terStatus='V' 29/01/2025 12:59:42.4139 575 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 29/01/2025 13:00:29.7115 558 ms. EXEC: update paycash set casCreation = '2025-01-29 13:00:29',casModify = '2025-01-29 13:00:29',casUseId=0,casStatus='V' where casId = 207026 29/01/2025 13:01:27.6722 621 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2025-01-29 13:01:26',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-29 13:01:26',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'; 29/01/2025 13:02:22.2980 635 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2025-01-29 13:02:21' where traUID = 5288161617282720 and traStatus='V' and traEnabled=1 29/01/2025 13:02:27.4535 2686 ms. EXEC: UPDATE payInventory SET invType='N' WHERE invType<>'N' AND invValue IN (100,200,500) AND invDevice IN (42102,42101,42001); 29/01/2025 13:04:53.2619 1054 ms. OPEN: select * from tabArea where areStatus='V' and areEnabled = 1 AND areId = 1 29/01/2025 13:07:34.9339 1182 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 29/01/2025 13:13:32.3498 531 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 29/01/2025 13:13:43.5232 1467 ms. EXEC: insert into payReceipt (recTraUID,recPayUID,recYear,recDateTime,recText,recInvalid) VALUES (0,4951229313650550,2025,'2025-01-29 13:13:42',' Date: 1/29/2025 1:13:41 PM Code: 0810007108790 Name: EVANCE MUTUMA Current Credit: 6000.00 KES Valid From: 1/1/2024 Expiration Date: 12/31/2025 ______________________________ Total: 2000.00 KES ______________________________ Paid: 2000.00 KES __________ Change: 0.00 KES Type: Cash Device: WEB # 2500000006 ',0) 29/01/2025 13:14:54.4361 891 ms. EXEC: insert into payReceipt (recTraUID,recPayUID,recYear,recDateTime,recText,recInvalid) VALUES (4992114712053500,4821907548156310,2025,'2025-01-29 13:14:53','---------------------------------- %The Mall P0006032390 End of payment ---------------------------------- POF Entry : 1/29/2025 12:01:30 PM Date : 1/29/2025 1:14:51 PM Code : 456844329000327005012999 Total : 100.00 KES VAT 16% : 13.79 KES ---------------------------------- Paid : 100.00 KES Coin changed : 0.00 KES Note changed : 0.00 KES',0) 29/01/2025 13:14:54.9514 513 ms. EXEC: update payReceipt set recCreation = '2025-01-29 13:14:54',recModify = '2025-01-29 13:14:54',recUseId=0,recStatus='V' where recId = 346945 29/01/2025 13:15:31.6820 1064 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-29 13:15:30',0,'V',4988994197906180,5007714814096590,2025,'2025-01-29 13:15:30',2,1,0,-1,'2025-01-29 14:15:30','S','KES',0,0,0,'','','',3,0,0) 29/01/2025 13:15:32.8718 888 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-29 13:15:31','V',4677229078853090,2025,'2025-01-29 13:15:28','456844024900327005012999',2,2,2,'O','',0,'2025-01-29 13:15:31',1,'','0230004100967',12,0) 29/01/2025 13:15:38.3254 588 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 29/01/2025 13:15:46.5109 738 ms. EXEC: update opeActivities set acvFstPayId = (case acvFstPayId when 0 then 399718 else acvFstPayId end),acvLstPayId = 399718 where acvSftId = 872 and acvCodeId = 3 29/01/2025 13:17:49.6362 767 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2025-01-29 13:17:48' where payTraUID = 5692942358096860 and payStatus='V' and payEnabled=1 29/01/2025 13:22:23.7703 978 ms. EXEC: update paycash set casCreation = '2025-01-29 13:22:22',casModify = '2025-01-29 13:22:22',casUseId=0,casStatus='V' where casId = 207035 29/01/2025 13:22:24.2807 510 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2025-01-29 13:22:22',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'; 29/01/2025 13:22:53.0979 1259 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 29/01/2025 13:23:20.0359 886 ms. EXEC: update opeActivities set acvFstPayId = (case acvFstPayId when 0 then 399722 else acvFstPayId end),acvLstPayId = 399722 where acvSftId = 889 and acvCodeId = 3 29/01/2025 13:23:31.6427 752 ms. EXEC: insert into payReceipt (recTraUID,recPayUID,recYear,recDateTime,recText,recInvalid) VALUES (5632525669982120,5371400129211280,2025,'2025-01-29 13:23:30',' Date: 1/29/2025 1:22:59 PM Code: 456844620800327005012999 Entry Date: 1/29/2025 12:50:08 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 # 2500401269 ',0) 29/01/2025 13:25:21.1249 550 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 29/01/2025 13:25:58.2957 547 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 29/01/2025 13:29:20.5033 585 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 29/01/2025 13:30:43.5007 1213 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2025-01-29 13:30:42',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'; 29/01/2025 13:31:37.9521 1236 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 29/01/2025 13:32:51.1340 712 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 29/01/2025 13:32:59.7728 937 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 29/01/2025 13:36:16.3712 815 ms. EXEC: insert into payReceipt (recTraUID,recPayUID,recYear,recDateTime,recText,recInvalid) VALUES (5097509260399380,5152395901189520,2025,'2025-01-29 13:36:15','---------------------------------- %The Mall P0006032390 End of payment ---------------------------------- POF Entry : 1/29/2025 10:51:02 AM Date : 1/29/2025 1:36:13 PM Code : 456843906200327005012999 Total : 100.00 KES VAT 16% : 13.79 KES ---------------------------------- Paid : 100.00 KES Coin changed : 0.00 KES Note changed : 0.00 KES',0) 29/01/2025 13:37:11.2869 1349 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 29/01/2025 13:40:39.8182 1447 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 29/01/2025 13:42:27.0028 1557 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 29/01/2025 13:42:39.5942 1222 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 29/01/2025 13:43:49.5940 1066 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2025-01-29 13:43:48' where traUID = 5593233623494170 and traStatus='V' and traEnabled=1 29/01/2025 13:43:53.6807 1067 ms. EXEC: UPDATE payInventory SET invType='N' WHERE invType<>'N' AND invValue IN (100,200,500) AND invDevice IN (42102,42101,42001); 29/01/2025 13:47:10.6864 706 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 29/01/2025 13:49:04.0591 925 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 29/01/2025 14:00:34.4585 772 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-29 14:00:33','V',4757407649349840,2025,'2025-01-29 14:00:32','456845043200327001012999',1,2,1,'I','',1,0,1,'','0230003944081',15,0) 29/01/2025 14:00:36.7971 601 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 29/01/2025 14:02:37.9550 587 ms. EXEC: update payReceipt set recCreation = '2025-01-29 14:02:37',recModify = '2025-01-29 14:02:37',recUseId=0,recStatus='V' where recId = 346964 29/01/2025 14:02:44.7576 683 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-29 13:59:18',1,'V',4762546450158550,4699318959291420,2025,'2025-01-29 13:59:18',17,1,0,4,'2025-01-29 14:14:18','C','KES',100,100,0,'','','',1,100,0,0,'',0,0) 29/01/2025 14:03:03.4040 1379 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-29 14:03:02','V',5641758825691060,2025,'2025-01-29 14:03:01','456844849700327001012999',2,2,2,'O','',0,'2025-01-29 14:03:02',1,'','',0) 29/01/2025 14:03:04.8170 1160 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 29/01/2025 14:05:07.0967 1381 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-29 14:05:05','V',5216594223556010,2025,'2025-01-29 14:05:04','456845070400327005012999',1,2,16,'I','',1,0,1,'','',4) 29/01/2025 14:10:13.5845 546 ms. EXEC: insert into payReceipt (recTraUID,recPayUID,recYear,recDateTime,recText,recInvalid) VALUES (5731102741137420,5480394037496970,2025,'2025-01-29 14:10:13','---------------------------------- %The Mall P0006032390 End of payment ---------------------------------- POF Entry : 1/29/2025 12:53:18 PM Date : 1/29/2025 2:10:11 PM Code : 456844639800327005012999 Total : 100.00 KES VAT 16% : 13.79 KES ---------------------------------- Paid : 100.00 KES Coin changed : 0.00 KES Note changed : 0.00 KES Not changed Note : 0.00 KES Coin : 0.00 KES Unavailable : 0.00 KES',0) 29/01/2025 14:10:21.4417 1245 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 29/01/2025 14:10:48.0385 680 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 29/01/2025 14:12:20.2041 1747 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-29 14:12:18','V',5335859508746580,2025,'2025-01-29 14:12:17','456844873900327005012999',2,2,2,'O','',0,'2025-01-29 14:12:18',1,'','',0) 29/01/2025 14:12:20.8225 549 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 29/01/2025 14:12:25.1974 680 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 29/01/2025 14:12:27.7721 802 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2025-01-29 14:12:26',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'; 29/01/2025 14:12:55.4817 721 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 29/01/2025 14:15:23.9869 1087 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2025-01-29 14:15:22',3,42101,0,50,2,100,1,'I','N'); update payCurInventory set curQuantity=round(curQuantity+2,5),curAmount=round(curAmount+100,5) where curTerId = 3 and curDevCode = 42101 and curChannelId = 1 and curValue = 50 and curType = 'N'; 29/01/2025 14:15:25.3778 1389 ms. EXEC: update payInventory set invCreation = '2025-01-29 14:15:23',invModify = '2025-01-29 14:15:23',invUseId=0,invStatus='V' where invId = 233834 29/01/2025 14:16:17.7688 1655 ms. OPEN: select * from payCurInventory where curTerId = 3 and curQuantity>0 and curType in ('C','N') order by curDevCode,curChannelId,curValue 29/01/2025 14:21:35.6242 581 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 29/01/2025 14:22:47.0570 567 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2025-01-29 14:22:46',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'; 29/01/2025 14:24:42.4151 1166 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 29/01/2025 14:28:21.6065 986 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 3 29/01/2025 14:31:21.5948 3498 ms. EXECSCALAR: select count(*) from information_schema.tables where table_schema= 'wisepark_0327' and table_name= 'payInvoiceFtp' nr: 1 29/01/2025 14:31:22.7516 632 ms. EXEC: UPDATE payInventory SET invType='N' WHERE invType<>'N' AND invValue IN (100,200,500) AND invDevice IN (42102,42101,42001); 29/01/2025 14:32:53.9515 858 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 29/01/2025 14:33:07.9879 1223 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 29/01/2025 14:35:27.9504 1083 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 29/01/2025 14:36:27.1550 722 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 29/01/2025 14:36:28.2597 558 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 29/01/2025 14:36:30.3501 833 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 29/01/2025 14:36:31.7080 839 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 29/01/2025 14:36:39.1860 667 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 29/01/2025 14:36:41.3315 1435 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 29/01/2025 14:38:36.2562 860 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 29/01/2025 14:39:33.6136 1442 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 29/01/2025 14:43:01.9068 622 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 29/01/2025 14:43:55.4565 2159 ms. EXEC: update payInventory set invCreation = '2025-01-29 14:43:53',invModify = '2025-01-29 14:43:53',invUseId=0,invStatus='V' where invId = 233843 29/01/2025 14:44:38.1881 1174 ms. EXEC: UPDATE payInventory SET invType='N' WHERE invType<>'N' AND invValue IN (100,200,500) AND invDevice IN (42102,42101,42001); 29/01/2025 14:44:38.2461 856 ms. EXEC: update tabTerminalReceipt set trcProgressive = 4116, trcLastPrinted = '2500704116', trcLastDate = '2025-01-29 14:44:37' where trcStatus='V' and trcTerId = 18 29/01/2025 14:44:50.7275 1306 ms. EXEC: UPDATE payInventory SET invType='N' WHERE invType<>'N' AND invValue IN (100,200,500) AND invDevice IN (42102,42101,42001); 29/01/2025 14:45:16.4617 613 ms. EXEC: update payReceipt set recCreation = '2025-01-29 14:45:15',recModify = '2025-01-29 14:45:15',recUseId=0,recStatus='V' where recId = 346989 29/01/2025 14:45:41.6045 743 ms. EXEC: insert into paycash (casCreation,casModify,casUseId,casStatus,casUID,casTraUID,casYear,casDateTime,casIdTerminal,casCurrency,casNumber,casSingleAmount,casTotAmount,casType,casDescription) VALUES ('2025-01-29 14:45:40',0,0,'V',4809332003942520,5044147872724400,2025,'2025-01-29 14:45:40',3,'KES',-1,50,-50,'N',''); insert into paycash (casCreation,casModify,casUseId,casStatus,casUID,casTraUID,casYear,casDateTime,casIdTerminal,casCurrency,casNumber,casSingleAmount,casTotAmount,casType,casDescription) VALUES ('2025-01-29 14:45:40',0,0,'V',4809332003942520,5044147872724400,2025,'2025-01-29 14:45:40',3,'KES',-1,100,-100,'N',''); insert into paycash (casCreation,casModify,casUseId,casStatus,casUID,casTraUID,casYear,casDateTime,casIdTerminal,casCurrency,casNumber,casSingleAmount,casTotAmount,casType,casDescription) VALUES ('2025-01-29 14:45:40',0,0,'V',4809332003942520,5044147872724400,2025,'2025-01-29 14:45:40',3,'KES',-4,200,-800,'N',''); 29/01/2025 14:45:43.5228 1774 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2025-01-29 14:45:40',3,42101,0,50,-1,-50,1,'O','N'); update payCurInventory set curQuantity=round(curQuantity+-1,5),curAmount=round(curAmount+-50,5) where curTerId = 3 and curDevCode = 42101 and curChannelId = 1 and curValue = 50 and curType = 'N'; Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2025-01-29 14:45:40',3,42101,0,100,-1,-100,1,'O','N'); update payCurInventory set curQuantity=round(curQuantity+-1,5),curAmount=round(curAmount+-100,5) where curTerId = 3 and curDevCode = 42101 and curChannelId = 1 and curValue = 100 and curType = 'N'; Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2025-01-29 14:45:40',3,42101,0,200,-4,-800,1,'O','N'); update payCurInventory set curQuantity=round(curQuantity+-4,5),curAmount=round(curAmount+-800,5) where curTerId = 3 and curDevCode = 42101 and curChannelId = 1 and curValue = 200 and curType = 'N'; 29/01/2025 14:45:59.2983 707 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 29/01/2025 14:46:36.8424 788 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-29 14:46:36','V',5443757016261700,2025,'2025-01-29 14:46:34','456845202700327005012999',2,2,2,'O','',0,'2025-01-29 14:46:36',1,'','',0) 29/01/2025 14:46:49.7900 4038 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 29/01/2025 14:47:29.2694 1146 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2025-01-29 14:47:28' where payTraUID = 5044147872724400 and payStatus='V' and payEnabled=1 29/01/2025 14:47:33.0580 546 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 29/01/2025 14:48:22.6481 515 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-29 14:48:22','V',5707330690963260,2025,'2025-01-29 14:48:21','456845236000327005012999',2,2,2,'O','',0,'2025-01-29 14:48:22',1,'','',0) 29/01/2025 14:48:27.5864 1405 ms. EXEC: UPDATE payInventory SET invType='N' WHERE invType<>'N' AND invValue IN (100,200,500) AND invDevice IN (42102,42101,42001); 29/01/2025 14:49:14.5868 838 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 2 29/01/2025 14:49:14.6178 1417 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-29 14:49:13','V',4633887776198720,2025,'2025-01-29 14:49:12','456845335200327005012999',1,2,16,'I','',1,0,1,'','0750009518612',99,0) 29/01/2025 14:49:22.1418 512 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 29/01/2025 14:51:35.4419 622 ms. EXECSCALAR: select count(*) from information_schema.tables where table_schema= 'wisepark_0327' and table_name= 'payInvoiceFtp' nr: 1 29/01/2025 14:51:36.7458 625 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 29/01/2025 14:52:28.5314 1179 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 2 OR lnsTerId=2) 29/01/2025 14:52:46.8837 1655 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 29/01/2025 14:54:21.3118 947 ms. EXECSCALAR: select count(*) from information_schema.tables where table_schema= 'wisepark_0327' and table_name= 'payInvoiceFtp' nr: 1 29/01/2025 14:54:21.9462 539 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 29/01/2025 14:56:00.5961 523 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 29/01/2025 14:56:26.7476 947 ms. OPEN: show columns from tabParameters where Field = 'parUseFloorCounter' 29/01/2025 14:56:36.1459 667 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 29/01/2025 14:57:13.0685 639 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 1 29/01/2025 15:00:23.8590 908 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 29/01/2025 15:00:35.2446 1606 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 16 OR lnsTerId=16) 29/01/2025 15:03:58.5765 825 ms. EXEC: insert into paycash (casCreation,casModify,casUseId,casStatus,casUID,casTraUID,casYear,casDateTime,casIdTerminal,casCurrency,casNumber,casSingleAmount,casTotAmount,casType,casDescription) VALUES ('2025-01-29 15:03:57',0,0,'V',5450310294067240,5549645485754320,2025,'2025-01-29 15:03:57',3,'KES',1,100,100,'N',''); 29/01/2025 15:03:59.5061 813 ms. EXEC: insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2025-01-29 15:03:57',3,42101,0,100,1,100,2,'I','N'); update payCurInventory set curQuantity=round(curQuantity+1,5),curAmount=round(curAmount+100,5) where curTerId = 3 and curDevCode = 42101 and curChannelId = 2 and curValue = 100 and curType = 'N'; 29/01/2025 15:05:49.4026 1066 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 29/01/2025 15:09:17.3415 839 ms. EXEC: INSERT INTO movOperator (opeCreation,opeUseId,opeTerId,opeDateTime,opeCode,opeDescription) VALUES ('2025-01-29 15:09:16',0,16,'2025-01-29 15:09:16','','Unauthorized Transit Entry 2') 29/01/2025 15:09:31.5150 525 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2025-01-29 15:09:30' where payTraUID = 5549538699682680 and payStatus='V' and payEnabled=1 29/01/2025 15:09:35.8929 904 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 29/01/2025 15:09:35.9570 1669 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 29/01/2025 15:11:16.8744 783 ms. EXEC: insert into abbPayment (payCreation,payCode,payAmount,payCredit,payPayUID,payCarId,payDateFrom,payDateTo) VALUES ('2025-01-29 15:11:16','0230004101194',0,0,4945866732786620,30,'0000-00-00 00:00:00','0000-00-00 00:00:00') 29/01/2025 15:11:24.2123 582 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 29/01/2025 15:11:28.9304 543 ms. EXEC: update tabTerminalReceipt set trcProgressive = 4123, trcLastPrinted = '2500704123', trcLastDate = '2025-01-29 15:11:28' where trcStatus='V' and trcTerId = 18 29/01/2025 15:17:46.3577 1343 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 29/01/2025 15:17:51.2519 549 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 29/01/2025 15:19:49.1217 515 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 29/01/2025 15:21:22.6112 538 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2025-01-29 15:21:21' where traUID = 5601479865614370 and traStatus='V' and traEnabled=1 29/01/2025 15:21:30.8727 1822 ms. EXEC: UPDATE payInventory SET invType='N' WHERE invType<>'N' AND invValue IN (100,200,500) AND invDevice IN (42102,42101,42001); 29/01/2025 15:23:03.0293 769 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 29/01/2025 15:24:32.9393 759 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 29/01/2025 15:26:46.1774 686 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 29/01/2025 15:29:14.4344 692 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 29/01/2025 15:30:23.4245 529 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 29/01/2025 15:30:23.4255 515 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 5 29/01/2025 15:33:42.8518 525 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 29/01/2025 15:34:00.2294 779 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 29/01/2025 15:34:34.3392 689 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 29/01/2025 15:34:37.9326 1267 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 29/01/2025 15:35:49.9597 698 ms. EXEC: update payReceipt set recCreation = '2025-01-29 15:35:49',recModify = '2025-01-29 15:35:49',recUseId=0,recStatus='V' where recId = 347011 29/01/2025 15:36:49.3735 543 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 29/01/2025 15:36:58.6376 2276 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 29/01/2025 15:37:24.5600 1416 ms. EXEC: update payReceipt set recCreation = '2025-01-29 15:37:23',recModify = '2025-01-29 15:37:23',recUseId=0,recStatus='V' where recId = 347012 29/01/2025 15:37:41.1581 542 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 29/01/2025 15:39:31.0705 643 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 29/01/2025 15:39:34.6739 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 ('2025-01-29 15:36:09',1,'V',5211203487441420,5183378813684050,2025,'2025-01-29 15:36:09',17,1,0,4,'2025-01-29 15:51:09','C','KES',100,100,0,'','','',1,100,0,0,'',0,0) 29/01/2025 15:40:42.6653 3076 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 16 OR lnsTerId=16) 29/01/2025 15:40:45.4252 2095 ms. EXEC: insert into payReceipt (recTraUID,recPayUID,recYear,recDateTime,recText,recInvalid) VALUES (4818866427542660,4959502348697340,2025,'2025-01-29 15:40:43',' Data: 1/29/2025 3:37:18 PM Codice: 456845531900327005012999 Ingresso: 1/29/2025 3:21:59 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 # 2500600685 ',0) 29/01/2025 15:42:26.9180 577 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 29/01/2025 15:43:01.8634 851 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2025-01-29 15:43:00' where traUID = 5183378813684050 and traStatus='V' and traEnabled=1 29/01/2025 15:43:07.5442 515 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 29/01/2025 15:43:11.5608 685 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 29/01/2025 15:43:11.5628 596 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 17 OR lnsTerId=17) 29/01/2025 15:43:12.5915 1035 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 29/01/2025 15:43:24.8147 698 ms. EXECSCALAR: select count(*) from information_schema.tables where table_schema= 'wisepark_0327' and table_name= 'movInside' nr: 1 29/01/2025 15:43:32.3847 1169 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 29/01/2025 15:43:48.4425 557 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 29/01/2025 15:44:16.6703 1282 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 29/01/2025 15:45:41.9143 605 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 29/01/2025 15:45:56.3049 1665 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 29/01/2025 15:46:23.0888 763 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 29/01/2025 15:47:23.6733 1635 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2025-01-29 15:47:21' where traUID = 4947266536840250 and traStatus='V' and traEnabled=1 29/01/2025 15:47:31.5216 583 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 29/01/2025 15:49:12.1738 3532 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 29/01/2025 15:50:38.4395 1285 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 29/01/2025 15:50:50.0112 682 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 29/01/2025 15:50:51.3431 1346 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-29 15:50:49','V',4952177136646030,2025,'2025-01-29 15:50:46','456845564300327005012999',2,2,2,'O','',0,'2025-01-29 15:50:49',1,'','',0) 29/01/2025 15:50:51.8794 501 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 29/01/2025 15:51:11.7797 567 ms. EXEC: update abbSubscriptions set subCredit = round(subCredit-0,5),subLastDebit = '2025-01-29 15:51:11' where subId = 198 29/01/2025 15:51:12.5953 711 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-29 15:51:11',0,'V',4614185439150070,4953342869685900,2025,'2025-01-29 15:51:11',2,1,0,-1,'2025-01-29 16:51:11','S','KES',0,0,0,'','','',3,0,0) 29/01/2025 15:52:05.9229 591 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 29/01/2025 15:56:13.8736 864 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 29/01/2025 16:00:12.3710 566 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 29/01/2025 16:00:33.6922 787 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 29/01/2025 16:01:26.0702 615 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 29/01/2025 16:02:01.9162 1591 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 3 OR lnsTerId=3) 29/01/2025 16:08:02.3640 1332 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2025-01-29 16:08:00' where traUID = 5522348556633170 and traStatus='V' and traEnabled=1 29/01/2025 16:08:30.4678 794 ms. EXECSCALAR: SELECT count(*) FROM payinventory WHERE invValue<>0 AND invType='' nr: 0 29/01/2025 16:08:31.3964 926 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 29/01/2025 16:11:09.9874 659 ms. OPEN: select * from movTransit where traStatus='V' and traEnabled = 1 and traCode = '456845383100327001012999' 29/01/2025 16:11:10.5798 502 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2025-01-29 16:11:09' where traUID = 5452791638340230 and traStatus='V' and traEnabled=1 29/01/2025 16:11:13.8560 831 ms. EXECSCALAR: select count(*) from information_schema.tables where table_schema= 'wisepark_0327' and table_name= 'payInvoiceFtp' nr: 1 29/01/2025 16:15:28.9455 530 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 29/01/2025 16:16:33.4956 533 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 29/01/2025 16:22:07.2006 561 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2025-01-29 16:22:06',3,42101,0,100,2,200,1,'I','N'); update payCurInventory set curQuantity=round(curQuantity+2,5),curAmount=round(curAmount+200,5) where curTerId = 3 and curDevCode = 42101 and curChannelId = 1 and curValue = 100 and curType = 'N'; 29/01/2025 16:22:31.3217 555 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-29 16:22:30',0,'V',5732838268757090,5760564833630370,2025,'2025-01-29 16:22:30',18,1,0,4,'2025-01-29 16:37:30','C','KES',50,50,0,'','','',1,50,0,0,'',0,0) 29/01/2025 16:23:52.7151 527 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 29/01/2025 16:25:22.7282 726 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 29/01/2025 16:33:30.2481 578 ms. EXEC: INSERT INTO movOperator (opeCreation,opeUseId,opeTerId,opeDateTime,opeCode,opeDescription) VALUES ('2025-01-29 16:33:29',0,16,'2025-01-29 16:33:29','','Unauthorized Transit Entry 2') 29/01/2025 16:33:55.6561 1295 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 29/01/2025 16:37:31.2151 566 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 29/01/2025 16:38:49.4284 556 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 29/01/2025 16:38:49.7956 757 ms. EXECSCALAR: select count(*) from information_schema.tables where table_schema= 'wisepark_0327' and table_name= 'payInvoiceFtp' nr: 1 29/01/2025 16:38:59.3400 1143 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 29/01/2025 16:40:23.5533 1121 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 29/01/2025 16:40:47.1451 866 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-29 16:40:46','V',5395017357643730,2025,'2025-01-29 16:40:45','456845675200327005012999',2,2,2,'O','',0,'2025-01-29 16:40:46',1,'','',0) 29/01/2025 16:40:54.4339 625 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 29/01/2025 16:42:45.4681 1397 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 29/01/2025 16:45:02.1456 784 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 29/01/2025 16:45:17.5949 503 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 29/01/2025 16:46:27.9239 1954 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 29/01/2025 16:49:58.1814 1128 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 29/01/2025 16:50:31.6017 644 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 29/01/2025 16:54:14.6698 1126 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 29/01/2025 16:56:06.5976 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-29 16:56:06','V',4628323051493250,2025,'2025-01-29 16:56:05','456845642500327005012999',2,2,2,'O','',0,'2025-01-29 16:56:06',1,'','',0) 29/01/2025 16:56:07.3651 738 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 29/01/2025 16:56:55.9776 1008 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-29 16:56:54',0,'V',5325744715456550,4723270647814230,2025,'2025-01-29 16:56:54',18,1,0,4,'2025-01-29 17:11:54','C','KES',50,50,0,'','','',1,50,0,0,'',0,0) 29/01/2025 16:57:01.6644 756 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2025-01-29 16:57:00',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'; 29/01/2025 16:58:02.7392 989 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 29/01/2025 16:58:21.7849 1773 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 29/01/2025 17:02:01.0755 692 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 29/01/2025 17:10:29.6333 570 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 29/01/2025 17:10:45.9202 1102 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-29 17:10:43',0,'V',4758885638430320,5556729195178820,2025,'2025-01-29 17:10:43',3,1,0,4,'2025-01-29 17:25:43','C','KES',50,50,0,'',' ',' ',1,50,0,0,'',0,0) 29/01/2025 17:11:29.2692 2349 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 29/01/2025 17:13:35.4114 635 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 29/01/2025 17:13:40.9862 580 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 29/01/2025 17:16:00.3586 1195 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 16 OR lnsTerId=16) 29/01/2025 17:17:56.4422 579 ms. EXEC: insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2025-01-29 17:17:55',3,42101,0,100,1,100,2,'I','N'); update payCurInventory set curQuantity=round(curQuantity+1,5),curAmount=round(curAmount+100,5) where curTerId = 3 and curDevCode = 42101 and curChannelId = 2 and curValue = 100 and curType = 'N'; 29/01/2025 17:20:49.3507 657 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2025-01-29 17:20:48' where payTraUID = 5728440526371420 and payStatus='V' and payEnabled=1 29/01/2025 17:20:56.0692 646 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 29/01/2025 17:21:49.8141 763 ms. EXEC: update payReceipt set recCreation = '2025-01-29 17:21:49',recModify = '2025-01-29 17:21:49',recUseId=0,recStatus='V' where recId = 347051 29/01/2025 17:26:19.9496 1052 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 29/01/2025 17:26:26.4540 524 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-29 17:26:25',0,'V',5177664824020720,5234066940343080,2025,'2025-01-29 17:26:25',18,1,0,4,'2025-01-29 17:41:25','C','KES',100,100,0,'','','',1,100,0,0,'',0,0) 29/01/2025 17:26:27.3926 790 ms. EXEC: update tabTerminalReceipt set trcProgressive = 4141, trcLastPrinted = '2500704141', trcLastDate = '2025-01-29 17:26:26' where trcStatus='V' and trcTerId = 18 29/01/2025 17:26:29.2058 949 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 29/01/2025 17:26:30.3576 590 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2025-01-29 17:26:29' where traUID = 5688131807471170 and traStatus='V' and traEnabled=1 29/01/2025 17:29:47.2562 587 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 29/01/2025 17:30:13.0534 592 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-29 17:30:12','V',4621774245476150,2025,'2025-01-29 17:30:11','456845908300327005012999',2,2,2,'O','',0,'2025-01-29 17:30:12',1,'','',0) 29/01/2025 17:30:13.8429 785 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 29/01/2025 17:30:14.8946 574 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2025-01-29 17:30:14' where traUID = 5234066940343080 and traStatus='V' and traEnabled=1 29/01/2025 17:30:17.4373 1026 ms. EXEC: UPDATE payCash SET casType='N' WHERE casType<>'N' AND ABS(casSingleAmount) IN (100,200,500); 29/01/2025 17:30:21.0938 837 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 29/01/2025 17:31:42.9415 1499 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 29/01/2025 17:31:43.8171 632 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2025-01-29 17:31:42' where traUID = 4645373390983370 and traStatus='V' and traEnabled=1 29/01/2025 17:33:50.0424 555 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-29 17:33:49','V',5380357348452850,2025,'2025-01-29 17:33:47','456842948400327005012999',2,2,2,'O','',0,'2025-01-29 17:33:49',1,'','0560008512164',186,0) 29/01/2025 17:33:55.5801 502 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 29/01/2025 17:34:11.8870 667 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 29/01/2025 17:34:31.6622 1816 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-29 17:34:29','V',5653629242072240,2025,'2025-01-29 17:34:29','456846326900327001012999',1,2,1,'I','',1,0,1,'','0230004101216',10,0) (WAIT TIME 139 ms.) 29/01/2025 17:38:53.9385 690 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 29/01/2025 17:44:23.0444 605 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 29/01/2025 17:44:23.6408 590 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 29/01/2025 17:44:50.4567 1168 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 29/01/2025 17:47:37.4003 633 ms. EXEC: insert into abbPayment (payCreation,payCode,payAmount,payCredit,payPayUID,payCarId,payDateFrom,payDateTo) VALUES ('2025-01-29 17:47:36','0230004100099',0,0,5303349325738350,144,'0000-00-00 00:00:00','0000-00-00 00:00:00') 29/01/2025 17:51:40.5227 1697 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-29 17:51:38','V',5433652908507380,2025,'2025-01-29 17:51:37','456842230900327005012999',2,2,2,'O','',0,'2025-01-29 17:51:38',1,'','0560008516054',163,0) 29/01/2025 17:51:41.6495 867 ms. EXEC: update abbCards set carLastDate = '2025-01-29 17:51:40',carLastDirection='O' where carStatus='V' and carId = 163 29/01/2025 17:54:38.4452 778 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 29/01/2025 17:56:24.5180 537 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 29/01/2025 18:00:30.6955 544 ms. EXEC: update abbCards set carLastDate = '2025-01-29 18:00:30',carLastDirection='I' where carStatus='V' and carId = 15 29/01/2025 18:00:37.1679 583 ms. EXEC: insert into payPayment (payCreation,payUseId,payStatus,payUID,payTraUID,payYear,payDateTime,payIdTerminal,payEnabled,payDisableTime,payTarId,payTimeLimit,payType,payCurrency,payAmount,payPayed,payChange,payCardType,payPAN,paySTAN,payIdEvent,payAmountCalc,payDiscountValue,payDiscount,payDiscountType,payVatPercent,payVatAmount) VALUES ('2025-01-29 18:00:34',0,'V',4956307169510110,5235211859345470,2025,'2025-01-29 18:00:34',3,1,0,4,'2025-01-29 18:15:34','C','KES',100,100,0,'',' ',' ',1,100,0,0,'',0,0) 29/01/2025 18:00:41.4137 646 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 4 29/01/2025 18:02:46.0827 544 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 29/01/2025 18:02:52.5981 589 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 29/01/2025 18:03:04.9634 930 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 1 29/01/2025 18:03:36.5275 537 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 29/01/2025 18:04:14.6629 540 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 29/01/2025 18:05:06.7317 726 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2025-01-29 18:05: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'; Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2025-01-29 18:05:05',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'; 29/01/2025 18:06:49.9497 960 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-29 18:06:48','V',4862687945564340,2025,'2025-01-29 18:06:47','456846240800327005012999',2,2,2,'O','',0,'2025-01-29 18:06:48',1,'','',0) 29/01/2025 18:07:39.1686 1631 ms. EXEC: update abbCards set carLastDate = '2025-01-29 18:07:37',carLastDirection='O' where carStatus='V' and carId = 44 29/01/2025 18:07:52.5365 3268 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 29/01/2025 18:07:57.1256 843 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-29 18:07:56','V',5273636255874150,2025,'2025-01-29 18:07:55','456842796000327005012999',2,2,2,'O','',0,'2025-01-29 18:07:56',1,'','0230004100104',151,0) 29/01/2025 18:08:02.4281 602 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 29/01/2025 18:09:46.5977 520 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 29/01/2025 18:12:00.0189 2212 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 29/01/2025 18:12:06.9125 577 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 29/01/2025 18:12:34.4169 1517 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-29 18:12:32','V',5528364500871070,2025,'2025-01-29 18:12:32','456846555200327005012999',1,2,16,'I','',1,0,1,'','',4) 29/01/2025 18:12:51.2171 650 ms. EXEC: insert into movtransit (traUseId,traCreation,traStatus,traUID,traYear,traDateTime,traCode,traType,traClass,traIdTerminal,traDirection,traPlate,traEnabled,traDisableTime,traAreId,traNotes,traBadge,traTarId) VALUES (0,'2025-01-29 18:12:50','V',5619966914446600,2025,'2025-01-29 18:12:48','456846387700327005012999',2,2,2,'O','',0,'2025-01-29 18:12:50',1,'','',0) 29/01/2025 18:12:52.7671 1189 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 29/01/2025 18:12:57.1331 574 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 29/01/2025 18:14:34.5612 519 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 29/01/2025 18:16:55.5644 603 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 29/01/2025 18:17:46.1132 1161 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 16 OR lnsTerId=16) 29/01/2025 18:17:46.7406 711 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 29/01/2025 18:18:18.8931 771 ms. EXEC: insert into payReceipt (recTraUID,recPayUID,recYear,recDateTime,recText,recInvalid) VALUES (5430512388147070,5033521371181400,2025,'2025-01-29 18:18:18','---------------------------------- %The Mall P0006032390 End of payment ---------------------------------- POF Entry : 1/29/2025 5:36:04 PM Date : 1/29/2025 6:18:16 PM Code : 456846336400327005012999 Total : 50.00 KES VAT 16% : 6.90 KES ---------------------------------- Paid : 50.00 KES Coin changed : 0.00 KES Note changed : 0.00 KES',0) 29/01/2025 18:18:19.8777 593 ms. EXEC: insert into paycash (casCreation,casModify,casUseId,casStatus,casUID,casTraUID,casYear,casDateTime,casIdTerminal,casCurrency,casNumber,casSingleAmount,casTotAmount,casType,casDescription) VALUES ('2025-01-29 18:18:19',0,0,'V',5051272131173040,5430512388147070,2025,'2025-01-29 18:18:19',3,'KES',1,50,50,'N',''); 29/01/2025 18:21:02.9277 875 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 (WAIT TIME 217 ms.) 29/01/2025 18:24:09.8196 1057 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-29 18:24:08',0,'V',5449396918314850,4696658642379460,2025,'2025-01-29 18:24:08',18,1,0,4,'2025-01-29 18:39:08','C','KES',50,50,0,'','','',1,50,0,0,'',0,0) 29/01/2025 18:24:12.0591 2126 ms. EXEC: insert into payReceipt (recTraUID,recPayUID,recYear,recDateTime,recText,recInvalid) VALUES (4696658642379460,5449396918314850,2025,'2025-01-29 18:24:09',' Date: 1/29/2025 6:24:08 PM Code: 456846559200327005012999 Entry Date: 1/29/2025 6:13:12 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 # 2500704150 ',0) 29/01/2025 18:25:13.3430 562 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 29/01/2025 18:26:21.2144 3459 ms. EXEC: update abbSubscriptions set subCredit = round(subCredit-0,5),subLastDebit = '2025-01-29 18:26:17' where subId = 20 29/01/2025 18:26:23.3668 1914 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-29 18:26:21','V',5064335538578500,2025,'2025-01-29 18:26:16','456842645800327005012999',2,2,2,'O','',0,'2025-01-29 18:26:21',1,'','0230003950907',19,0) (WAIT TIME 12 ms.) 29/01/2025 18:26:25.2145 1069 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2025-01-29 18:26:24' where payTraUID = 5474976739657950 and payStatus='V' and payEnabled=1 29/01/2025 18:26:44.1591 1430 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2025-01-29 18:26:42' where payTraUID = 5503062820266200 and payStatus='V' and payEnabled=1 29/01/2025 18:26:59.0971 721 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 29/01/2025 18:26:59.8336 835 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 29/01/2025 18:26:59.8846 834 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 29/01/2025 18:27:13.0775 601 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-29 18:27:12',0,'V',4910295676681490,5249246093902050,2025,'2025-01-29 18:27:12',18,1,0,4,'2025-01-29 18:42:12','C','KES',100,100,0,'','','',1,100,0,0,'',0,0) 29/01/2025 18:29:07.2888 510 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2025-01-29 18:29:06' where traUID = 5249246093902050 and traStatus='V' and traEnabled=1 29/01/2025 18:29:18.6133 1454 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 29/01/2025 18:33:01.5843 682 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 29/01/2025 18:33:23.6741 833 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 29/01/2025 18:33:45.7889 559 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 29/01/2025 18:37:51.7362 648 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 29/01/2025 18:38:00.5541 1266 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 29/01/2025 18:38:03.6452 554 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 29/01/2025 18:40:39.1471 795 ms. EXECSCALAR: select count(*) from information_schema.tables where table_schema= 'wisepark_0327' and table_name= 'payInvoiceFtp' nr: 1 29/01/2025 18:41:18.7596 625 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 29/01/2025 18:41:20.2035 532 ms. EXECSCALAR: select count(*) from information_schema.tables where table_schema= 'wisepark_0327' and table_name= 'movTransitSecondary' nr: 1 29/01/2025 18:41:59.5128 565 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-29 18:41:56',0,'V',5050974847601640,4994682262734570,2025,'2025-01-29 18:41:56',3,1,0,4,'2025-01-29 18:56:56','C','KES',50,50,0,'',' ',' ',1,50,0,0,'',0,0) 29/01/2025 18:42:00.9107 635 ms. EXEC: update paycash set casCreation = '2025-01-29 18:42:00',casModify = '2025-01-29 18:42:00',casUseId=0,casStatus='V' where casId = 207091 29/01/2025 18:42:29.7830 743 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 29/01/2025 18:43:03.2034 624 ms. OPEN: select * from opeShifts where sftId = 872 and sftStatus = 'V' 29/01/2025 18:44:55.8431 715 ms. OPEN: select * from tabArea where areStatus='V' and areEnabled = 1 AND areId = 1 29/01/2025 18:45:01.9562 809 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-29 18:45:01',0,'V',5757994694831500,5238918537475610,2025,'2025-01-29 18:45:01',18,1,0,4,'2025-01-29 19:00:01','C','KES',400,400,0,'','','',1,400,0,0,'',0,0) 29/01/2025 18:45:48.7545 586 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 29/01/2025 18:47:36.2233 631 ms. EXECSCALAR: select count(*) from information_schema.tables where table_schema= 'wisepark_0327' and table_name= 'payInvoiceFtp' nr: 1 (WAIT TIME 78 ms.) 29/01/2025 18:47:42.4775 721 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-29 18:47:38',0,'V',4997186319495350,5733634979415070,2025,'2025-01-29 18:47:38',3,1,0,4,'2025-01-29 19:02:38','C','KES',50,50,0,'',' ',' ',1,50,0,0,'',0,0) 29/01/2025 18:47:54.5365 1255 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 1 (WAIT TIME 31 ms.) 29/01/2025 18:49:04.3482 1409 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 29/01/2025 18:49:06.6768 2321 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 29/01/2025 18:50:00.1125 3554 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 29/01/2025 18:51:00.9661 639 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 29/01/2025 18:51:12.6749 802 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-29 18:51:11',0,'V',5375788624797770,4773361321107810,2025,'2025-01-29 18:51:11',2,1,0,-1,'2025-01-29 19:51:11','S','KES',0,0,0,'','','',3,0,0) 29/01/2025 18:51:13.8057 835 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2025-01-29 18:51:12' where payTraUID = 4773361321107810 and payStatus='V' and payEnabled=1 29/01/2025 18:51:37.9609 535 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 (WAIT TIME 9 ms.) 29/01/2025 18:52:18.0666 2980 ms. OPEN: select * from tabTerminal where terId = 2 29/01/2025 18:52:24.9573 648 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 29/01/2025 18:52:53.0280 510 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 29/01/2025 18:55:44.7147 532 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 29/01/2025 18:57:39.7106 551 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 29/01/2025 18:57:40.6632 566 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2025-01-29 18:57:39' where traUID = 4750172350229580 and traStatus='V' and traEnabled=1 29/01/2025 18:57:47.5478 528 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 29/01/2025 18:57:48.2263 633 ms. EXEC: UPDATE payInventory SET invType='N' WHERE invType<>'N' AND invValue IN (100,200,500) AND invDevice IN (42102,42101,42001); 29/01/2025 19:03:34.2625 845 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-29 19:03:33',0,'V',4992803572429990,4617988048046750,2025,'2025-01-29 19:03:33',18,1,0,4,'2025-01-29 19:18:33','C','KES',50,50,0,'','','',1,50,0,0,'',0,0) 29/01/2025 19:03:34.9380 597 ms. EXEC: update tabTerminalReceipt set trcProgressive = 4163, trcLastPrinted = '2500704163', trcLastDate = '2025-01-29 19:03:34' where trcStatus='V' and trcTerId = 18 29/01/2025 19:05:47.2628 1583 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-29 19:05:45','V',5554150689286610,2025,'2025-01-29 19:05:44','456846608300327005012999',2,2,2,'O','',0,'2025-01-29 19:05:45',1,'','',0) 29/01/2025 19:05:50.0957 549 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 29/01/2025 19:06:10.9557 735 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 29/01/2025 19:13:48.1231 4018 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 29/01/2025 19:14:31.5792 528 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 29/01/2025 19:15:11.5559 1279 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 29/01/2025 19:17:47.5862 617 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 29/01/2025 19:23:42.5484 822 ms. EXEC: insert into abbPayment (payCreation,payCode,payAmount,payCredit,payPayUID,payCarId,payDateFrom,payDateTo) VALUES ('2025-01-29 19:23:41','0230004100082',0,0,5090472384415850,142,'0000-00-00 00:00:00','0000-00-00 00:00:00') 29/01/2025 19:26:28.1940 1277 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2025-01-29 19:26:26',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'; (WAIT TIME 5 ms.) 29/01/2025 19:27:40.6124 771 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 29/01/2025 19:29:37.8318 951 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 29/01/2025 19:31:14.0130 687 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 29/01/2025 19:31:14.0601 947 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 2 OR lnsTerId=2) 29/01/2025 19:31:24.7372 599 ms. EXEC: insert into payReceipt (recTraUID,recPayUID,recYear,recDateTime,recText,recInvalid) VALUES (5286167285431920,5424858178861910,2025,'2025-01-29 19:31:24',' Date: 1/29/2025 7:31:23 PM Code: 456846888200327005012999 Entry Date: 1/29/2025 7:08:02 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 # 2500704168 ',0) 29/01/2025 19:32:05.0291 1485 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 29/01/2025 19:32:10.8000 1576 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 29/01/2025 19:33:54.7454 697 ms. OPEN: select * from tabTerminal where terId = 16 29/01/2025 19:35:48.4935 1220 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 29/01/2025 19:36:30.4355 528 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 29/01/2025 19:38:37.5774 1110 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 29/01/2025 19:43:15.1539 1063 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 2 29/01/2025 19:45:34.3920 784 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 29/01/2025 19:48:52.4883 501 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 29/01/2025 19:49:40.6355 2413 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 1 and terStatus='V' 29/01/2025 19:53:02.3093 812 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 29/01/2025 19:55:24.6372 654 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 29/01/2025 19:56:53.4725 561 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 29/01/2025 19:57:04.9532 522 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 29/01/2025 19:57:38.1714 683 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 29/01/2025 20:02:17.5151 674 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 2 OR lnsTerId=2) 29/01/2025 20:03:13.6976 1058 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 29/01/2025 20:04:48.2408 506 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 29/01/2025 20:05:37.8630 551 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 29/01/2025 20:09:58.3680 891 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 29/01/2025 20:11:02.5299 2801 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 29/01/2025 20:14:16.3344 2151 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 29/01/2025 20:14:52.7738 683 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 29/01/2025 20:14:53.1970 986 ms. EXECSCALAR: select count(*) from information_schema.tables where table_schema= 'wisepark_0327' and table_name= 'payInvoiceFtp' nr: 1 29/01/2025 20:19:08.8649 615 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 29/01/2025 20:29:42.6842 691 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 29/01/2025 20:32:10.9443 743 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 29/01/2025 20:34:55.4422 751 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-29 20:34:54','V',4825554950746560,2025,'2025-01-29 20:34:54','456846598000327001012999',2,2,2,'O','',0,'2025-01-29 20:34:54',1,'','',0) 29/01/2025 20:35:00.4695 622 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 29/01/2025 20:35:35.9723 710 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 29/01/2025 20:46:35.4619 777 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2025-01-29 20:46:34' where payTraUID = 5559932772142380 and payStatus='V' and payEnabled=1 29/01/2025 20:46:42.9289 501 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 29/01/2025 20:47:24.2135 1613 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 29/01/2025 20:53:34.3708 907 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 29/01/2025 21:01:28.1504 1564 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-29 21:01:26',0,'V',4766046305670490,5232767531404610,2025,'2025-01-29 21:01:26',2,1,0,-1,'2025-01-29 22:01:26','S','KES',0,0,0,'','','',3,0,0) 29/01/2025 21:08:52.9687 1552 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 29/01/2025 21:16:06.7737 504 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-29 21:16:06','V',4655764426435850,2025,'2025-01-29 21:16:04','456843587000327005012999',2,2,2,'O','',0,'2025-01-29 21:16:06',1,'','0810007127724',111,0) 29/01/2025 21:16:08.1306 1022 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2025-01-29 21:16:07' where payTraUID = 5304765809322890 and payStatus='V' and payEnabled=1 29/01/2025 21:16:21.9599 695 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 2 OR lnsTerId=2) 29/01/2025 21:16:50.4379 632 ms. EXEC: insert into abbPayment (payCreation,payCode,payAmount,payCredit,payPayUID,payCarId,payDateFrom,payDateTo) VALUES ('2025-01-29 21:16:49','0750009372622',0,0,4930153188250290,112,'0000-00-00 00:00:00','0000-00-00 00:00:00') 29/01/2025 21:16:57.0813 945 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 29/01/2025 21:17:03.4756 815 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 29/01/2025 21:27:22.4665 2070 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2025-01-29 21:27:20' where payTraUID = 4625652619040020 and payStatus='V' and payEnabled=1 29/01/2025 21:27:53.7334 983 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 29/01/2025 21:29:35.5555 735 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 29/01/2025 21:30:33.8904 1111 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-29 21:27:08',1,'V',5353906279939810,5291302734636330,2025,'2025-01-29 21:27:08',17,1,0,4,'2025-01-29 21:42:08','C','KES',100,100,0,'','','',1,100,0,0,'',0,0) 29/01/2025 21:30:35.9338 662 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2025-01-29 21:30:35' where traUID = 4739828379199930 and traStatus='V' and traEnabled=1 29/01/2025 21:30:39.7083 829 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 29/01/2025 21:33:45.5835 744 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 29/01/2025 21:33:46.8844 1288 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2025-01-29 21:33:45' where payTraUID = 4887054142733740 and payStatus='V' and payEnabled=1 29/01/2025 21:33:47.8410 956 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2025-01-29 21:33:45' where traUID = 4887054142733740 and traStatus='V' and traEnabled=1 29/01/2025 21:34:15.1853 1205 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 29/01/2025 21:35:42.1654 632 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 29/01/2025 21:44:44.9496 900 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-29 21:44:44','V',5292160393631320,2025,'2025-01-29 21:44:42','456847828200327001012999',1,2,1,'I','',1,0,1,'','0230004101216',10,0) 29/01/2025 21:44:52.3986 595 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 29/01/2025 21:48:49.1588 546 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 29/01/2025 21:49:12.0260 728 ms. EXEC: insert into movtransit (traUseId,traCreation,traStatus,traUID,traYear,traDateTime,traCode,traType,traClass,traIdTerminal,traDirection,traPlate,traEnabled,traDisableTime,traAreId,traNotes,traBadge,traTarId) VALUES (0,'2025-01-29 21:49:11','V',5685151762121630,2025,'2025-01-29 21:49:09','456846819400327005012999',2,2,2,'O','',0,'2025-01-29 21:49:11',1,'','',0) 29/01/2025 21:51:29.7371 526 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-29 21:51:29','V',4938535853900750,2025,'2025-01-29 21:51:28','456847227700327005012999',2,2,2,'O','',0,'2025-01-29 21:51:29',1,'','',0) 29/01/2025 21:51:40.2651 718 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 29/01/2025 21:51:56.4930 1411 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 29/01/2025 21:53:10.4083 511 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 29/01/2025 21:55:01.1413 631 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 29/01/2025 21:55:02.2361 755 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-29 21:55:01','V',5486617712032430,2025,'2025-01-29 21:54:59','456846836400327005012999',2,2,2,'O','',0,'2025-01-29 21:55:01',1,'','',0) 29/01/2025 21:55:38.0460 652 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 29/01/2025 21:56:54.0348 910 ms. EXEC: insert into movOperator (opeCreation,opeTerId,opeUseId,opeDateTime,opeCode,opeDescription) VALUES ('2025-01-29 21:56:53',17,1,'2025-01-29 21:56:53','456846824700327005012999','Pagato (Contanti ) Biglietto ') 29/01/2025 21:57:13.6469 592 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 29/01/2025 21:59:08.7318 528 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 29/01/2025 21:59:11.3836 639 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 29/01/2025 22:00:24.2202 582 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 29/01/2025 22:02:05.4249 756 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 29/01/2025 22:06:25.6888 1129 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2025-01-29 22:06:24' where payTraUID = 5099839665718400 and payStatus='V' and payEnabled=1 29/01/2025 22:06:49.3826 511 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 29/01/2025 22:06:49.8209 841 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 29/01/2025 22:08:47.7877 931 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 29/01/2025 22:09:38.4796 625 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-29 22:09:37','V',4959745375413550,2025,'2025-01-29 22:09:37','456847736700327005012999',2,2,2,'O','',0,'2025-01-29 22:09:37',1,'','',0) 29/01/2025 22:10:19.2208 1958 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 29/01/2025 22:10:33.3263 575 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2025-01-29 22:10:32' where payTraUID = 5617625840119450 and payStatus='V' and payEnabled=1 29/01/2025 22:10:43.0337 552 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 29/01/2025 22:12:08.0666 932 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 29/01/2025 22:19:13.1086 525 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 29/01/2025 22:19:15.9675 619 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 29/01/2025 22:19:49.1987 604 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 29/01/2025 22:19:51.5303 561 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 29/01/2025 22:40:38.1425 637 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 29/01/2025 22:42:30.8559 1343 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-29 22:42:29',0,'V',5367151431995090,5455637717489340,2025,'2025-01-29 22:42:29',2,1,0,-1,'2025-01-29 23:42:29','S','KES',0,0,0,'','','',3,0,0) 29/01/2025 22:42:31.4743 607 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-29 22:42:30','V',4675819503558900,2025,'2025-01-29 22:42:29','456843561900327005012999',2,2,2,'O','',0,'2025-01-29 22:42:30',1,'','0560008419314',195,0) 29/01/2025 22:50:27.8286 911 ms. EXEC: insert into payPayment (payCreation,payUseId,payStatus,payUID,payTraUID,payYear,payDateTime,payIdTerminal,payEnabled,payDisableTime,payTarId,payTimeLimit,payType,payCurrency,payAmount,payPayed,payChange,payCardType,payPAN,paySTAN,payIdEvent,payAmountCalc,payDiscountValue,payDiscount,payDiscountType,payVatPercent,payVatAmount) VALUES ('2025-01-29 22:49:55',9,'V',4680478034004040,5073689091562810,2025,'2025-01-29 22:49:55',4,1,0,4,'2025-01-29 23:04:55','P','KES',150,150,0,'','','',1,150,0,0,'',0,0) 29/01/2025 22:50:55.2499 510 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-29 22:50:54','V',4753866377594450,2025,'2025-01-29 22:50:53','456848140900327005012999',2,2,2,'O','',0,'2025-01-29 22:50:54',1,'','0230003944081',15,0) 29/01/2025 22:51:00.8326 902 ms. EXEC: UPDATE payInventory SET invType='N' WHERE invType<>'N' AND invValue IN (100,200,500) AND invDevice IN (42102,42101,42001); 29/01/2025 22:51:13.5661 1425 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 29/01/2025 22:52:35.5739 555 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 29/01/2025 22:54:14.2379 573 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 29/01/2025 22:54:58.2593 814 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2025-01-29 22:54:57' where payTraUID = 5621148078254330 and payStatus='V' and payEnabled=1 29/01/2025 22:55:16.0122 1238 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 29/01/2025 22:58:12.4461 788 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 29/01/2025 22:58:22.3196 1995 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 29/01/2025 22:58:27.0838 1029 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 1 OR lnsTerId=1) 29/01/2025 22:58:31.4528 677 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 29/01/2025 22:58:59.7647 1100 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 2 29/01/2025 22:59:06.6012 2288 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 29/01/2025 23:02:16.2640 542 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 29/01/2025 23:03:28.6033 532 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 29/01/2025 23:03:29.3628 758 ms. OPEN: select * from movTransit where traStatus='V' and traEnabled = 1 and traCode = '456847013600327005012999' 29/01/2025 23:14:54.0628 709 ms. EXEC: insert into paycash (casCreation,casModify,casUseId,casStatus,casUID,casTraUID,casYear,casDateTime,casIdTerminal,casCurrency,casNumber,casSingleAmount,casTotAmount,casType,casDescription) VALUES ('2025-01-29 23:14:53',0,0,'V',5234632903727730,5730186195333310,2025,'2025-01-29 23:14:53',3,'KES',1,100,100,'N',''); 29/01/2025 23:15:37.9922 976 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 29/01/2025 23:30:39.9145 539 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 29/01/2025 23:32:21.3143 1056 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 29/01/2025 23:40:32.0782 510 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 29/01/2025 23:44:14.0934 791 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 3 OR lnsTerId=3) 29/01/2025 23:44:45.9467 894 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 29/01/2025 23:56:11.0481 1273 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1