08/11/2024 00:01:06.4846 1680 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/11/2024 00:11:12.9886 708 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/11/2024 00:13:08.0143 1137 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/11/2024 00:16:28.7690 1488 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/11/2024 00:17:02.1802 4807 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/11/2024 00:24:28.8408 803 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/11/2024 00:26:04.2363 546 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/11/2024 00:32:14.5030 1429 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/11/2024 00:32:54.3475 740 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 3 OR lnsTerId=3) 08/11/2024 00:32:56.0507 1593 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/11/2024 00:33:05.2658 584 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/11/2024 00:40:52.6642 973 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/11/2024 00:45:50.9429 1270 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 3 08/11/2024 00:57:54.7770 504 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 5 and terStatus='V' 08/11/2024 00:58:56.2760 598 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/11/2024 01:02:53.6441 504 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/11/2024 01:03:41.0417 741 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/11/2024 01:05:26.1057 554 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/11/2024 01:08:43.4031 1469 ms. EXECSCALAR: select count(0) as vTot from tabParameters where parPlateReading<>0 nr: 0 08/11/2024 01:16:36.5373 938 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/11/2024 01:17:08.3665 4999 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/11/2024 01:17:56.5246 865 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 08/11/2024 01:18:39.9085 2237 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 3 and terStatus='V' 08/11/2024 01:23:16.4187 778 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/11/2024 01:23:17.3183 543 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/11/2024 01:31:37.2373 1679 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/11/2024 01:31:44.0138 2079 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 5 08/11/2024 01:40:49.9125 2161 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 2 08/11/2024 01:41:59.6269 861 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/11/2024 01:49:14.7017 557 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 08/11/2024 01:49:42.9395 655 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/11/2024 01:51:50.6756 3368 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2024-11-08 01:51:47',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'; 08/11/2024 01:52:07.5749 893 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/11/2024 01:57:12.8102 1030 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 08/11/2024 01:59:26.2501 606 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/11/2024 02:02:37.2233 558 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 3 08/11/2024 02:07:15.7008 671 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 08/11/2024 02:12:21.4875 728 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/11/2024 02:23:10.6940 673 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/11/2024 02:26:02.5645 623 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/11/2024 02:27:10.2476 2088 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 2 and terStatus='V' 08/11/2024 02:27:23.4154 654 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/11/2024 02:36:58.0852 636 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 16 OR lnsTerId=16) 08/11/2024 02:38:02.2059 515 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/11/2024 02:40:44.3799 877 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/11/2024 02:41:55.6874 578 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/11/2024 02:42:24.6167 1052 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/11/2024 02:50:54.1231 1227 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/11/2024 02:56:24.7143 746 ms. OPEN: select * from tabArea where areStatus='V' and areEnabled = 1 AND areId = 1 08/11/2024 02:57:11.6776 552 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/11/2024 02:57:23.1242 520 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 2 OR lnsTerId=2) 08/11/2024 02:57:44.0822 910 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 2 08/11/2024 03:00:10.9961 662 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/11/2024 03:00:14.3493 648 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/11/2024 03:00:36.9874 760 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/11/2024 03:01:12.1208 615 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/11/2024 03:04:40.6447 511 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/11/2024 03:06:33.9362 547 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/11/2024 03:06:39.6790 633 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/11/2024 03:11:48.0034 586 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 08/11/2024 03:16:12.1213 1033 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/11/2024 03:17:47.7900 709 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/11/2024 03:19:02.6629 633 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 08/11/2024 03:19:13.0318 1027 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 08/11/2024 03:21:10.8453 947 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 1 08/11/2024 03:21:12.9257 1156 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/11/2024 03:22:30.3142 1822 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/11/2024 03:30:19.6409 1859 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/11/2024 03:30:29.9938 650 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/11/2024 03:30:47.6125 624 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/11/2024 03:30:59.4244 2348 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/11/2024 03:31:04.3317 528 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/11/2024 03:42:18.0364 751 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/11/2024 03:48:38.6290 991 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 08/11/2024 04:06:45.9923 690 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/11/2024 04:21:52.0749 1429 ms. EXEC: update paycash set casCreation = '2024-11-08 04:21:50',casModify = '2024-11-08 04:21:50',casUseId=0,casStatus='V' where casId = 193708 08/11/2024 04:23:10.7433 1648 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/11/2024 04:26:01.6482 656 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2024-11-08 04:26:00' where payTraUID = 4754511296229910 and payStatus='V' and payEnabled=1 08/11/2024 04:27:16.1038 1145 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2024-11-08 04:27:14' where payTraUID = 5267271708954620 and payStatus='V' and payEnabled=1 08/11/2024 04:27:16.9743 867 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2024-11-08 04:27:14' where traUID = 5267271708954620 and traStatus='V' and traEnabled=1 08/11/2024 04:31:59.4465 602 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/11/2024 04:33:42.7743 524 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 1 and terStatus='V' 08/11/2024 04:34:52.7319 795 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/11/2024 04:38:13.4647 635 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/11/2024 04:39:55.2455 672 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/11/2024 04:42:04.2084 1041 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/11/2024 04:48:02.9784 505 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/11/2024 04:48:11.2259 1021 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/11/2024 05:01:53.6988 750 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/11/2024 05:04:41.4055 900 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/11/2024 05:05:19.0616 3632 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/11/2024 05:05:40.8451 545 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/11/2024 05:08:12.6852 1688 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/11/2024 05:10:17.5344 906 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 5 and terStatus='V' 08/11/2024 05:10:18.0767 605 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/11/2024 05:11:08.4213 511 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/11/2024 05:15:09.9352 501 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/11/2024 05:15:47.6353 1954 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/11/2024 05:20:44.1688 1049 ms. EXEC: insert into payPayment (payCreation,payUseId,payStatus,payUID,payTraUID,payYear,payDateTime,payIdTerminal,payEnabled,payDisableTime,payTarId,payTimeLimit,payType,payCurrency,payAmount,payPayed,payChange,payCardType,payPAN,paySTAN,payIdEvent,payAmountCalc,payDiscountValue,payDiscount,payDiscountType,payVatPercent,payVatAmount) VALUES ('2024-11-08 05:18:15',1,'V',4652265149057180,4728602182803180,2024,'2024-11-08 05:18:15',4,1,0,4,'2024-11-08 05:33:15','P','KES',100,100,0,'','','',1,100,0,0,'',0,0) 08/11/2024 05:20:46.3433 1876 ms. EXEC: insert into payReceipt (recTraUID,recPayUID,recYear,recDateTime,recText,recInvalid) VALUES (4728602182803180,4652265149057180,2024,'2024-11-08 05:20:44',' Date: 11/8/2024 5:18:15 AM Code: 456021194000327005012999 Entry Date: 11/8/2024 3:19:00 AM Plate: Class: Cars Park: The Mall Gate: Entry 2 ______________________________ Total: 100.00 KES ______________________________ Paid: 100.00 KES __________ Change: 0.00 KES Type: Credit Card Dispozitiv: Manual Cashier 1 # 2400415745 ',0) 08/11/2024 05:22:21.4146 649 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/11/2024 05:34:51.1370 678 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/11/2024 05:36:16.5769 774 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/11/2024 05:50:35.2079 634 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 1 OR lnsTerId=1) 08/11/2024 05:54:10.4153 743 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/11/2024 06:02:10.7442 514 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/11/2024 06:05:32.6467 540 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 08/11/2024 06:08:03.1890 522 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 4 08/11/2024 06:09:53.2053 522 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/11/2024 06:15:33.2879 702 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/11/2024 06:27:08.8152 989 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/11/2024 06:30:53.7760 506 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/11/2024 06:36:14.6418 1138 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/11/2024 06:37:00.9907 1025 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/11/2024 06:41:51.4472 971 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/11/2024 06:42:08.6146 1148 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/11/2024 06:42:16.0696 548 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/11/2024 06:43:42.8584 1491 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/11/2024 06:49:04.8879 663 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 08/11/2024 06:50:16.9849 2321 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/11/2024 06:50:59.0609 797 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/11/2024 06:51:09.6350 546 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/11/2024 06:54:07.3564 552 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/11/2024 06:57:51.0014 1430 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/11/2024 06:58:53.6161 679 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2024-11-08 06:58:52' where traUID = 4802579943751140 and traStatus='V' and traEnabled=1 08/11/2024 07:05:33.0912 527 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/11/2024 07:06:10.2369 828 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2024-11-08 07:06:09' where traUID = 5295898881574630 and traStatus='V' and traEnabled=1 08/11/2024 07:06:55.9244 573 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/11/2024 07:18:14.5724 602 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 08/11/2024 07:21:16.9780 726 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/11/2024 07:25:50.1569 1394 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/11/2024 07:27:07.0622 894 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/11/2024 07:27:24.9491 1869 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/11/2024 07:30:03.7288 818 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/11/2024 07:31:03.5217 1109 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/11/2024 07:31:34.2572 1329 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/11/2024 07:31:52.4413 2686 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/11/2024 07:32:13.4563 509 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/11/2024 07:32:31.0100 690 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/11/2024 07:33:13.7865 994 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/11/2024 07:33:13.8015 1080 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 2 OR lnsTerId=2) 08/11/2024 07:33:21.7988 947 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/11/2024 07:33:23.3238 841 ms. EXEC: insert into movtransit (traUseId,traCreation,traStatus,traUID,traYear,traDateTime,traCode,traType,traClass,traIdTerminal,traDirection,traPlate,traEnabled,traDisableTime,traAreId,traNotes,traBadge,traTarId) VALUES (0,'2024-11-08 07:33:22','V',5542636254594890,2024,'2024-11-08 07:33:21','456022720100327005012999',1,2,16,'I','',1,0,1,'','',4) 08/11/2024 07:34:25.0249 535 ms. OPEN: select * from tabArea where areStatus='V' and areEnabled = 1 AND areId = 1 08/11/2024 07:36:37.0779 1075 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/11/2024 07:37:34.9054 702 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/11/2024 07:38:50.8580 1013 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/11/2024 07:39:57.8936 516 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/11/2024 07:41:57.8996 592 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/11/2024 07:43:18.8405 1144 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 08/11/2024 07:43:50.8839 631 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 5 and terStatus='V' 08/11/2024 07:48:55.2066 576 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/11/2024 07:51:00.6011 599 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 08/11/2024 07:51:07.3396 984 ms. EXEC: insert into movtransit (traUseId,traCreation,traStatus,traUID,traYear,traDateTime,traCode,traType,traClass,traIdTerminal,traDirection,traPlate,traEnabled,traDisableTime,traAreId,traNotes,traBadge,traCarId,traTarId) VALUES (0,'2024-11-08 07:51:06','V',4745016079186740,2024,'2024-11-08 07:51:04','456022826400327005012999',1,2,16,'I','',1,0,1,'','0560008512164',186,0) 08/11/2024 07:52:48.9723 525 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 08/11/2024 07:52:54.2798 539 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); (WAIT TIME 8 ms.) 08/11/2024 07:52:57.2608 861 ms. EXEC: INSERT INTO movOperator (opeCreation,opeUseId,opeTerId,opeDateTime,opeCode,opeDescription) VALUES ('2024-11-08 07:52:56',0,16,'2024-11-08 07:52:56','','Unauthorized Transit Entry 2') 08/11/2024 07:53:43.5877 590 ms. EXEC: INSERT INTO movOperator (opeCreation,opeUseId,opeTerId,opeDateTime,opeCode,opeDescription) VALUES ('2024-11-08 07:53:42',0,3,'2024-11-08 07:53:42','0230003944086','POF - User Transit Supervisor Supervisor') 08/11/2024 07:53:50.2911 680 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/11/2024 07:54:51.9092 595 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/11/2024 07:56:24.9752 534 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/11/2024 07:57:39.7720 778 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 08/11/2024 08:01:22.2512 1390 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/11/2024 08:01:59.1898 612 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 08/11/2024 08:02:02.6561 2021 ms. EXEC: insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2024-11-08 08:01:46',5,3,42101,0,50,-13,-650,1,'O','N'); insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2024-11-08 08:01:46',5,3,42101,0,50,13,650,2,'I','N'); insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2024-11-08 08:01:46',5,3,42101,0,100,-50,-5000,1,'O','N'); insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2024-11-08 08:01:46',5,3,42101,0,100,50,5000,2,'I','N'); insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2024-11-08 08:01:46',5,3,42101,0,200,-4,-800,1,'O','N'); insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2024-11-08 08:01:46',5,3,42101,0,200,4,800,2,'I','N'); insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2024-11-08 08:01:46',5,3,42101,0,500,-2,-1000,1,'O','N'); insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2024-11-08 08:01:46',5,3,42101,0,500,2,1000,2,'I','N'); insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2024-11-08 08:01:46',5,3,42101,0,1000,-1,-1000,1,'O','N'); insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2024-11-08 08:01:46',5,3,42101,0,1000,1,1000,2,'I','N'); insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2024-11-08 08:01:46',5,3,42101,1,0,0,0,1,'O',''); update payCurInventory set curQuantity=0,curAmount=0 where curQuantity<0; 08/11/2024 08:02:04.1561 1121 ms. EXEC: insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2024-11-08 08:01:57',5,3,42101,0,50,-13,-650,2,'O','N'); insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2024-11-08 08:01:57',5,3,42101,0,100,-51,-5100,2,'O','N'); insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2024-11-08 08:01:57',5,3,42101,0,200,-4,-800,2,'O','N'); insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2024-11-08 08:01:57',5,3,42101,0,500,-3,-1500,2,'O','N'); insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2024-11-08 08:01:57',5,3,42101,0,1000,-1,-1000,2,'O','N'); insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2024-11-08 08:01:57',5,3,42101,1,0,0,0,2,'O',''); update payCurInventory set curQuantity=0,curAmount=0 where curQuantity<0; 08/11/2024 08:04:19.3242 698 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/11/2024 08:04:25.3282 2550 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/11/2024 08:06:03.9409 517 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 08/11/2024 08:06:05.0086 1041 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2024-11-08 08:06:03' where payTraUID = 5575219918259080 and payStatus='V' and payEnabled=1 08/11/2024 08:07:13.4001 507 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 08/11/2024 08:08:50.1966 822 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/11/2024 08:11:27.0431 536 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/11/2024 08:15:11.4526 516 ms. EXEC: insert into payPayment (payCreation,payUseId,payStatus,payUID,payTraUID,payYear,payDateTime,payIdTerminal,payEnabled,payDisableTime,payTarId,payTimeLimit,payType,payCurrency,payAmount,payPayed,payChange,payCardType,payPAN,paySTAN,payIdEvent,payAmountCalc,payDiscountValue,payDiscount,payDiscountType,payVatPercent,payVatAmount) VALUES ('2024-11-08 08:15:10',0,'V',5543795689717490,4859538206174750,2024,'2024-11-08 08:15:10',3,1,0,4,'2024-11-08 08:30:10','C','KES',50,50,0,'',' ',' ',1,50,0,0,'',0,0) 08/11/2024 08:16:41.2074 960 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 16 OR lnsTerId=16) 08/11/2024 08:17:52.0196 1811 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/11/2024 08:18:00.4802 1340 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/11/2024 08:18:10.9071 1055 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/11/2024 08:18:12.4001 735 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 1 and terStatus='V' 08/11/2024 08:18:27.1390 2475 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/11/2024 08:18:36.8344 549 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/11/2024 08:18:49.3337 1229 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/11/2024 08:18:52.9481 1629 ms. OPEN: select traId,traDateTime,traEnabled,traDisableTime,traCode,traBadge,traCarId,traAreId,traIdTerminal from movtransit where traStatus='V' and traDirection = 'I' and traCarId = 10 order by traDateTime desc,traId desc 08/11/2024 08:24:26.9877 812 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/11/2024 08:24:43.4176 516 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/11/2024 08:25:29.9596 1693 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/11/2024 08:26:10.6557 639 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/11/2024 08:29:21.3818 3918 ms. EXEC: insert into payPayment (payCreation,payUseId,payStatus,payUID,payTraUID,payYear,payDateTime,payIdTerminal,payEnabled,payDisableTime,payTarId,payTimeLimit,payType,payCurrency,payAmount,payPayed,payChange,payCardType,payPAN,paySTAN,payIdEvent,payAmountCalc,payDiscountValue,payDiscount,payDiscountType,payVatPercent,payVatAmount) VALUES ('2024-11-08 08:29:17',0,'V',5747144929937860,4942181511968030,2024,'2024-11-08 08:29:17',18,1,0,4,'2024-11-08 08:44:17','C','KES',50,50,0,'','','',1,50,0,0,'',0,0) 08/11/2024 08:29:21.4018 3831 ms. EXEC: insert into movtransit (traUseId,traCreation,traStatus,traUID,traYear,traDateTime,traCode,traType,traClass,traIdTerminal,traDirection,traPlate,traEnabled,traDisableTime,traAreId,traNotes,traBadge,traTarId) VALUES (0,'2024-11-08 08:29:17','V',4985446462367630,2024,'2024-11-08 08:29:16','456023055600327005012999',1,2,16,'I','',1,0,1,'','',4) 08/11/2024 08:29:34.7087 743 ms. EXEC: insert into payPayment (payCreation,payUseId,payStatus,payUID,payTraUID,payYear,payDateTime,payIdTerminal,payEnabled,payDisableTime,payTarId,payTimeLimit,payType,payCurrency,payAmount,payPayed,payChange,payCardType,payPAN,paySTAN,payIdEvent,payAmountCalc,payDiscountValue,payDiscount,payDiscountType,payVatPercent,payVatAmount) VALUES ('2024-11-08 08:27:05',1,'V',5286861518329480,4770701244180640,2024,'2024-11-08 08:27:05',4,1,0,4,'2024-11-08 08:42:05','P','KES',100,100,0,'','','',1,100,0,0,'',0,0) 08/11/2024 08:30:29.8854 515 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 08/11/2024 08:30:36.6989 1675 ms. EXEC: insert into movtransit (traUseId,traCreation,traStatus,traUID,traYear,traDateTime,traCode,traType,traClass,traIdTerminal,traDirection,traPlate,traEnabled,traDisableTime,traAreId,traNotes,traBadge,traTarId) VALUES (0,'2024-11-08 08:30:35','V',5424958405326750,2024,'2024-11-08 08:30:24','456023062400327005012999',1,2,16,'I','',1,0,1,'','',4) 08/11/2024 08:32:48.9450 1360 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2024-11-08 08:32:47' where payTraUID = 5224654421417530 and payStatus='V' and payEnabled=1 08/11/2024 08:33:31.3143 1176 ms. EXEC: update tabTerminalReceipt set trcProgressive = 15754, trcLastPrinted = '2400415754', trcLastDate = '2024-11-08 08:33:30' where trcStatus='V' and trcTerId = 4 08/11/2024 08:33:33.9040 1742 ms. OPEN: select trauid from movtransit where traStatus='V' and traDirection='I' and traCode='456022859100327005012999' 08/11/2024 08:33:33.9040 518 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/11/2024 08:35:19.0560 2723 ms. EXEC: insert into movtransit (traUseId,traCreation,traStatus,traUID,traYear,traDateTime,traCode,traType,traClass,traIdTerminal,traDirection,traPlate,traEnabled,traDisableTime,traAreId,traNotes,traBadge,traTarId) VALUES (0,'2024-11-08 08:35:16','V',4664768883000860,2024,'2024-11-08 08:35:14','456023091400327005012999',1,2,16,'I','',1,0,1,'','',4) 08/11/2024 08:35:25.8346 519 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/11/2024 08:35:44.1027 1148 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/11/2024 08:37:21.2955 530 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/11/2024 08:39:55.1029 624 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/11/2024 08:45:56.3756 1026 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/11/2024 08:48:43.6921 976 ms. EXECSCALAR: select count(*) from information_schema.tables where table_schema= 'wisepark_0327' and table_name= 'payInvoiceFtp' nr: 1 08/11/2024 08:48:49.8902 1540 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 2 08/11/2024 08:49:09.2811 649 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 08/11/2024 08:51:45.4771 592 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/11/2024 08:51:50.3754 1409 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/11/2024 08:56:44.5544 844 ms. EXEC: insert into movtransit (traUseId,traCreation,traStatus,traUID,traYear,traDateTime,traCode,traType,traClass,traIdTerminal,traDirection,traPlate,traEnabled,traDisableTime,traAreId,traNotes,traBadge,traTarId) VALUES (0,'2024-11-08 08:56:43','V',5165651830624010,2024,'2024-11-08 08:56:40','456023125000327005012999',2,2,2,'O','',0,'2024-11-08 08:56:43',1,'','',0) 08/11/2024 08:56:45.4610 895 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 08/11/2024 09:07:54.7868 569 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 08/11/2024 09:07:55.1281 794 ms. EXECSCALAR: select count(*) from information_schema.tables where table_schema= 'wisepark_0327' and table_name= 'payInvoiceFtp' nr: 1 08/11/2024 09:08:15.1374 659 ms. EXEC: update tabTerminalReceipt set trcProgressive = 48776, trcLastPrinted = '2400748776', trcLastDate = '2024-11-08 09:08:14' where trcStatus='V' and trcTerId = 18 08/11/2024 09:09:19.7184 958 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2024-11-08 09:09:18' where traUID = 5381906440577190 and traStatus='V' and traEnabled=1 08/11/2024 09:09:47.2167 669 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 08/11/2024 09:14:21.8927 1562 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/11/2024 09:14:53.5218 736 ms. EXEC: insert into payReceipt (recTraUID,recPayUID,recYear,recDateTime,recText,recInvalid) VALUES (5314701511127900,5656541224674900,2024,'2024-11-08 09:14:52','---------------------------------- %The Mall P0006032390 End of payment ---------------------------------- POF Entry : 11/8/2024 8:47:33 AM Date : 11/8/2024 9:14:51 AM Code : 456023165300327005012999 Total : 50.00 KES VAT 16% : 6.90 KES ---------------------------------- Paid : 50.00 KES Coin changed : 0.00 KES Note changed : 0.00 KES',0) 08/11/2024 09:17:34.5761 693 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 08/11/2024 09:18:07.0727 682 ms. EXECSCALAR: SELECT traId FROM movTransit WHERE traStatus='V' AND traCode = @traCode nr: 771945 08/11/2024 09:18:13.5300 652 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 08/11/2024 09:18:13.6521 673 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 08/11/2024 09:18:13.7972 648 ms. EXECSCALAR: select count(*) from information_schema.tables where table_schema= 'wisepark_0327' and table_name= 'payInvoiceFtp' nr: 1 08/11/2024 09:22:11.6146 608 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 5 08/11/2024 09:24:18.1949 803 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/11/2024 09:27:12.0307 609 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 08/11/2024 09:34:01.6456 972 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2024-11-08 09:34: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'; 08/11/2024 09:34:02.6843 1037 ms. EXEC: update payInventory set invCreation = '2024-11-08 09:34:01',invModify = '2024-11-08 09:34:01',invUseId=0,invStatus='V' where invId = 217897 08/11/2024 09:35:46.6656 1061 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 4 OR lnsTerId=4) 08/11/2024 09:35:57.3657 1117 ms. EXEC: insert into payReceipt (recTraUID,recPayUID,recYear,recDateTime,recText,recInvalid) VALUES (5071811023781490,5441518017827680,2024,'2024-11-08 09:35:56',' Date: 11/8/2024 9:33:28 AM Code: 456023430400327005012999 Entry Date: 11/8/2024 9:31:44 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 # 2400415756 ',0) 08/11/2024 09:36:32.5862 640 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 1 08/11/2024 09:36:32.5872 568 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/11/2024 09:36:53.6442 2319 ms. OPEN: select sum(crc32(terDescription)) as vCheck from tabTerminal 08/11/2024 09:38:07.0681 1744 ms. EXEC: update tabTerminalReceipt set trcProgressive = 15757, trcLastPrinted = '2400415757', trcLastDate = '2024-11-08 09:38:05' where trcStatus='V' and trcTerId = 4 08/11/2024 09:39:57.3396 1012 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/11/2024 09:40:02.2919 1658 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/11/2024 09:40:05.8322 1507 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/11/2024 09:40:11.5340 1258 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/11/2024 09:40:14.8222 1048 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 (WAIT TIME 4 ms.) 08/11/2024 09:40:19.9086 2622 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/11/2024 09:42:22.5283 645 ms. EXEC: insert into movtransit (traUseId,traCreation,traStatus,traUID,traYear,traDateTime,traCode,traType,traClass,traIdTerminal,traDirection,traPlate,traEnabled,traDisableTime,traAreId,traNotes,traBadge,traTarId) VALUES (0,'2024-11-08 09:42:21','V',5581169127000530,2024,'2024-11-08 09:42:20','456023494000327005012999',1,2,16,'I','',1,0,1,'','',4) 08/11/2024 09:42:47.8942 800 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2024-11-08 09:42:47' where payTraUID = 5071811023781490 and payStatus='V' and payEnabled=1 08/11/2024 09:42:48.4265 532 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2024-11-08 09:42:47' where traUID = 5071811023781490 and traStatus='V' and traEnabled=1 08/11/2024 09:42:54.2394 558 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 08/11/2024 09:42:59.9892 667 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/11/2024 09:43:12.6136 537 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 08/11/2024 09:43:21.8928 570 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 16 OR lnsTerId=16) 08/11/2024 09:43:41.7460 863 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/11/2024 09:44:21.1643 776 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/11/2024 09:45:41.2136 617 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/11/2024 09:46:53.9751 2629 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/11/2024 09:47:16.0838 1581 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 3 OR lnsTerId=3) 08/11/2024 09:47:21.3984 578 ms. EXEC: insert into movtransit (traUseId,traCreation,traStatus,traUID,traYear,traDateTime,traCode,traType,traClass,traIdTerminal,traDirection,traPlate,traEnabled,traDisableTime,traAreId,traNotes,traBadge,traCarId,traTarId) VALUES (0,'2024-11-08 09:47:20','V',5534808816650470,2024,'2024-11-08 09:47:19','456023523900327005012999',1,2,16,'I','',1,0,1,'','0560008529778',171,0) 08/11/2024 09:47:27.9988 750 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/11/2024 09:47:37.0228 2405 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 08/11/2024 09:47:37.0228 1467 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/11/2024 09:48:59.0824 987 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/11/2024 09:52:56.2294 2266 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 5 and terStatus='V' 08/11/2024 09:52:59.6927 1754 ms. EXEC: insert into movtransit (traUseId,traCreation,traStatus,traUID,traYear,traDateTime,traCode,traType,traClass,traIdTerminal,traDirection,traPlate,traEnabled,traDisableTime,traAreId,traNotes,traBadge,traCarId,traTarId) VALUES (0,'2024-11-08 09:52:57','V',4799691976052350,2024,'2024-11-08 09:52:56','456023557600327005012999',1,2,16,'I','',1,0,1,'','0810007086215',125,0) 08/11/2024 09:53:43.5029 696 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 08/11/2024 09:53:52.0236 3450 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 08/11/2024 09:57:02.2493 1382 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/11/2024 09:57:11.3123 529 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/11/2024 09:57:25.1516 3387 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/11/2024 10:01:40.0784 543 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 08/11/2024 10:01:50.5634 653 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 08/11/2024 10:02:02.9536 671 ms. EXECSCALAR: select count(*) from tabTerminalExtraMem where extStatus='V' and extTerId = 16 nr: 1 08/11/2024 10:02:22.1944 1262 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 3 08/11/2024 10:02:42.4379 640 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 08/11/2024 10:02:43.3966 1494 ms. EXECSCALAR: select count(*) from information_schema.tables where table_schema= 'wisepark_0327' and table_name= 'payInvoiceFtp' nr: 1 08/11/2024 10:02:55.0273 560 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 08/11/2024 10:03:00.3909 590 ms. OPEN: select count(useId) as vTot from tabUser where useStatus='V' and useBadId<>'' 08/11/2024 10:03:10.3845 852 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/11/2024 10:03:17.2021 810 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 08/11/2024 10:03:34.7768 753 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/11/2024 10:05:19.1333 562 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 08/11/2024 10:05:24.3007 547 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 08/11/2024 10:06:21.1256 593 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 08/11/2024 10:06:29.9865 739 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 5 and terStatus='V' 08/11/2024 10:07:05.4972 2080 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 16 OR lnsTerId=16) 08/11/2024 10:07:51.0725 2034 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/11/2024 10:09:24.7229 515 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 08/11/2024 10:09:29.9494 660 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/11/2024 10:11:01.5294 2415 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 5 08/11/2024 10:13:16.9126 557 ms. EXEC: insert into movtransit (traUseId,traCreation,traStatus,traUID,traYear,traDateTime,traCode,traType,traClass,traIdTerminal,traDirection,traPlate,traEnabled,traDisableTime,traAreId,traNotes,traBadge,traTarId) VALUES (0,'2024-11-08 10:13:16','V',5144217267551850,2024,'2024-11-08 10:13:15','456023155700327005012999',2,2,2,'O','',0,'2024-11-08 10:13:16',1,'','',0) 08/11/2024 10:16:03.5666 611 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 08/11/2024 10:16:24.7757 989 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2024-11-08 10:16:23' where payTraUID = 5728603866609920 and payStatus='V' and payEnabled=1 08/11/2024 10:16:25.4672 583 ms. EXECSCALAR: SELECT traId FROM movTransit WHERE traStatus='V' AND traCode = @traCode nr: 771983 08/11/2024 10:16:25.5042 575 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/11/2024 10:19:31.1909 1354 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/11/2024 10:20:45.7456 543 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 08/11/2024 10:21:40.8593 836 ms. EXEC: insert into payPayment (payCreation,payUseId,payStatus,payUID,payTraUID,payYear,payDateTime,payIdTerminal,payEnabled,payDisableTime,payTarId,payTimeLimit,payType,payCurrency,payAmount,payPayed,payChange,payCardType,payPAN,paySTAN,payIdEvent,payAmountCalc,payDiscountValue,payDiscount,payDiscountType,payVatPercent,payVatAmount) VALUES ('2024-11-08 10:19:41',12,'V',4671369910082780,4720790253160300,2024,'2024-11-08 10:19:41',17,1,0,4,'2024-11-08 10:34:41','C','KES',50,50,0,'','','',1,50,0,0,'',0,0) 08/11/2024 10:24:30.5233 1844 ms. EXEC: insert into movtransit (traUseId,traCreation,traStatus,traUID,traYear,traDateTime,traCode,traType,traClass,traIdTerminal,traDirection,traPlate,traEnabled,traDisableTime,traAreId,traNotes,traBadge,traTarId) VALUES (0,'2024-11-08 10:24:28','V',4991820336664730,2024,'2024-11-08 10:24:28','456023746800327005012999',1,2,16,'I','',1,0,1,'','',4) 08/11/2024 10:27:54.2708 504 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 3 and terStatus='V' 08/11/2024 10:28:24.7851 633 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 08/11/2024 10:35:33.7783 779 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 08/11/2024 10:35:39.4881 567 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 08/11/2024 10:37:09.4590 748 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 08/11/2024 10:37:17.4954 590 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 08/11/2024 10:37:24.1048 572 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/11/2024 10:38:57.2548 785 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 08/11/2024 10:38:58.9740 898 ms. OPEN: show columns from abbCards where Field = 'carUHFCode' 08/11/2024 10:39:14.3942 537 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 08/11/2024 10:44:44.4961 794 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 08/11/2024 10:47:07.7255 3475 ms. OPEN: select 1 as Tot,payUID,payPayed,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)) order by traUIDGroup,payAmount, traType, traDiscountValue, traDiscountType 08/11/2024 10:47:17.6362 1660 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2024-11-08 10:47:15',3,42101,0,200,1,200,1,'I','N'); update payCurInventory set curQuantity=round(curQuantity+1,5),curAmount=round(curAmount+200,5) where curTerId = 3 and curDevCode = 42101 and curChannelId = 1 and curValue = 200 and curType = 'N'; 08/11/2024 10:47:19.4984 978 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2024-11-08 10:47:17',3,42101,0,50,-1,-50,1,'O','N'); update payCurInventory set curQuantity=round(curQuantity+-1,5),curAmount=round(curAmount+-50,5) where curTerId = 3 and curDevCode = 42101 and curChannelId = 1 and curValue = 50 and curType = 'N'; Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2024-11-08 10:47:17',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'; 08/11/2024 10:49:10.5994 906 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2024-11-08 10:49:08' where traUID = 4749707569542350 and traStatus='V' and traEnabled=1 08/11/2024 10:50:37.8525 783 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 08/11/2024 10:54:52.7383 969 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 08/11/2024 10:55:21.9328 515 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 08/11/2024 10:56:09.6676 675 ms. EXEC: insert into movtransit (traUseId,traCreation,traStatus,traUID,traYear,traDateTime,traCode,traType,traClass,traIdTerminal,traDirection,traPlate,traEnabled,traDisableTime,traAreId,traNotes,traBadge,traTarId) VALUES (0,'2024-11-08 10:56:08','V',4716732452283150,2024,'2024-11-08 10:56:08','456023936800327005012999',1,2,16,'I','',1,0,1,'','',4) 08/11/2024 10:56:30.3764 719 ms. EXEC: update tabTerminalReceipt set trcProgressive = 48784, trcLastPrinted = '2400748784', trcLastDate = '2024-11-08 10:56:29' where trcStatus='V' and trcTerId = 18 08/11/2024 10:57:50.8930 670 ms. EXEC: update tabTerminalReceipt set trcProgressive = 15764, trcLastPrinted = '2400415764', trcLastDate = '2024-11-08 10:57:50' where trcStatus='V' and trcTerId = 4 08/11/2024 10:58:21.2402 1075 ms. EXEC: update payInventory set invCreation = '2024-11-08 10:58:20',invModify = '2024-11-08 10:58:20',invUseId=0,invStatus='V' where invId = 217917 08/11/2024 11:00:01.8022 608 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 08/11/2024 11:00:58.6281 551 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/11/2024 11:02:16.0646 664 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 2 08/11/2024 11:02:29.6877 667 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/11/2024 11:07:36.1979 758 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2024-11-08 11:07:35' where traUID = 4649225830811040 and traStatus='V' and traEnabled=1 08/11/2024 11:08:51.8693 777 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 2 08/11/2024 11:09:20.8616 522 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 08/11/2024 11:09:48.7692 856 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/11/2024 11:12:24.3298 1061 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 5 08/11/2024 11:16:43.8817 579 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/11/2024 11:16:59.2640 726 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/11/2024 11:23:05.9382 1262 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/11/2024 11:26:04.7373 524 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/11/2024 11:26:18.7307 602 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 08/11/2024 11:26:19.1610 1560 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 08/11/2024 11:26:48.2473 1553 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 2 08/11/2024 11:27:05.7640 864 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 08/11/2024 11:27:05.9441 1110 ms. OPEN: show columns from tabParameters where Field = 'parReentrySeconds' 08/11/2024 11:27:12.6696 538 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 08/11/2024 11:27:12.7697 535 ms. EXECSCALAR: select count(*) from information_schema.tables where table_schema= 'wisepark_0327' and table_name= 'payInvoiceFtp' nr: 1 08/11/2024 11:29:49.9123 761 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/11/2024 11:30:14.1765 1042 ms. EXEC: update payReceipt set recCreation = '2024-11-08 11:30:13',recModify = '2024-11-08 11:30:13',recUseId=0,recStatus='V' where recId = 320370 08/11/2024 11:31:47.1184 2459 ms. EXEC: update payReceipt set recCreation = '2024-11-08 11:31:44',recModify = '2024-11-08 11:31:44',recUseId=0,recStatus='V' where recId = 320372 08/11/2024 11:31:49.4210 1663 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2024-11-08 11:31:47',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'; 08/11/2024 11:32:19.6811 644 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 08/11/2024 11:32:34.1798 913 ms. EXEC: UPDATE payInventory SET invType='N' WHERE invType<>'N' AND invValue IN (100,200,500) AND invDevice IN (42102,42101,42001); 08/11/2024 11:32:39.4063 2337 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 5 08/11/2024 11:32:55.2848 1471 ms. EXEC: insert into movtransit (traUseId,traCreation,traStatus,traUID,traYear,traDateTime,traCode,traType,traClass,traIdTerminal,traDirection,traPlate,traEnabled,traDisableTime,traAreId,traNotes,traBadge,traTarId) VALUES (0,'2024-11-08 11:32:53','V',5497459209618670,2024,'2024-11-08 11:32:52','456024157200327001012999',1,2,1,'I','',1,0,1,'','',4) 08/11/2024 11:32:55.8142 521 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 08/11/2024 11:32:56.8889 971 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/11/2024 11:33:33.2391 840 ms. EXEC: insert into payPayment (payCreation,payUseId,payStatus,payUID,payTraUID,payYear,payDateTime,payIdTerminal,payEnabled,payDisableTime,payTarId,payTimeLimit,payType,payCurrency,payAmount,payPayed,payChange,payCardType,payPAN,paySTAN,payIdEvent,payAmountCalc,payDiscountValue,payDiscount,payDiscountType,payVatPercent,payVatAmount) VALUES ('2024-11-08 11:33:32',0,'V',4949418924422240,5306647048667270,2024,'2024-11-08 11:33:32',18,1,0,4,'2024-11-08 11:48:32','C','KES',50,50,0,'','','',1,50,0,0,'',0,0) 08/11/2024 11:33:34.1267 749 ms. EXEC: insert into payReceipt (recTraUID,recPayUID,recYear,recDateTime,recText,recInvalid) VALUES (5306647048667270,4949418924422240,2024,'2024-11-08 11:33:33',' Date: 11/8/2024 11:33:32 AM Code: 456024063300327005012999 Entry Date: 11/8/2024 11:17:13 AM 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 # 2400748787 ',0) 08/11/2024 11:34:26.4135 1132 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/11/2024 11:35:12.3011 660 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 08/11/2024 11:37:24.0389 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,'2024-11-08 11:37:23','V',5460262237645470,2024,'2024-11-08 11:37:21','456024184100327005012999',1,2,16,'I','',1,0,1,'','',4) 08/11/2024 11:37:31.0385 657 ms. EXEC: insert into movtransit (traUseId,traCreation,traStatus,traUID,traYear,traDateTime,traCode,traType,traClass,traIdTerminal,traDirection,traPlate,traEnabled,traDisableTime,traAreId,traNotes,traBadge,traCarId,traTarId) VALUES (0,'2024-11-08 11:37:30','V',4720249852469520,2024,'2024-11-08 11:37:29','456023868100327005012999',2,2,2,'O','',0,'2024-11-08 11:37:30',1,'','0810007145851',106,0) 08/11/2024 11:37:32.3474 547 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 08/11/2024 11:37:33.3431 944 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2024-11-08 11:37:32' where payTraUID = 5503379666908590 and payStatus='V' and payEnabled=1 08/11/2024 11:37:39.8194 712 ms. EXECSCALAR: select count(*) from information_schema.tables where table_schema= 'wisepark_0327' and table_name= 'payInvoiceFtp' nr: 1 08/11/2024 11:38:34.6379 533 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/11/2024 11:41:32.7515 595 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 08/11/2024 11:41:39.0107 665 ms. EXEC: insert into movtransit (traUseId,traCreation,traStatus,traUID,traYear,traDateTime,traCode,traType,traClass,traIdTerminal,traDirection,traPlate,traEnabled,traDisableTime,traAreId,traNotes,traBadge,traTarId) VALUES (0,'2024-11-08 11:41:38','V',4890559669104420,2024,'2024-11-08 11:41:37','456024209700327005012999',1,2,16,'I','',1,0,1,'','',4) 08/11/2024 11:41:40.7739 1236 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 08/11/2024 11:41:56.9347 4221 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/11/2024 11:42:38.8196 538 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/11/2024 11:42:40.8669 640 ms. EXEC: insert into movtransit (traUseId,traCreation,traStatus,traUID,traYear,traDateTime,traCode,traType,traClass,traIdTerminal,traDirection,traPlate,traEnabled,traDisableTime,traAreId,traNotes,traBadge,traTarId) VALUES (0,'2024-11-08 11:42:40','V',5087906418526980,2024,'2024-11-08 11:42:36','456024215600327005012999',1,2,16,'I','',1,0,1,'','',4) 08/11/2024 11:43:45.8242 553 ms. EXEC: insert into movtransit (traUseId,traCreation,traStatus,traUID,traYear,traDateTime,traCode,traType,traClass,traIdTerminal,traDirection,traPlate,traEnabled,traDisableTime,traAreId,traNotes,traBadge,traTarId) VALUES (0,'2024-11-08 11:43:45','V',4856001019089230,2024,'2024-11-08 11:43:44','456024222400327005012999',1,2,16,'I','',1,0,1,'','',4) 08/11/2024 11:45:09.0416 676 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 08/11/2024 11:45:25.6167 671 ms. EXEC: insert into movtransit (traUseId,traCreation,traStatus,traUID,traYear,traDateTime,traCode,traType,traClass,traIdTerminal,traDirection,traPlate,traEnabled,traDisableTime,traAreId,traNotes,traBadge,traTarId) VALUES (0,'2024-11-08 11:45:24','V',5213586090207410,2024,'2024-11-08 11:45:20','456024033300327005012999',2,2,2,'O','',0,'2024-11-08 11:45:24',1,'','',0) 08/11/2024 11:45:35.4792 543 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 08/11/2024 11:45:38.9566 1892 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 17 OR lnsTerId=17) 08/11/2024 11:46:00.5770 505 ms. EXEC: update opeActivities set acvFstPayId = (case acvFstPayId when 0 then 368607 else acvFstPayId end),acvLstPayId = 368607 where acvSftId = 823 and acvCodeId = 3 08/11/2024 11:46:47.0009 567 ms. EXECSCALAR: select count(*) from tabTerminalExtraMem where extStatus='V' and extTerId = 2 nr: 1 08/11/2024 11:46:47.1080 691 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 08/11/2024 11:46:55.5986 1040 ms. EXEC: insert into payPayment (payCreation,payUseId,payStatus,payUID,payTraUID,payYear,payDateTime,payIdTerminal,payEnabled,payDisableTime,payTarId,payTimeLimit,payType,payCurrency,payAmount,payPayed,payChange,payCardType,payPAN,paySTAN,payIdEvent,payAmountCalc,payDiscountValue,payDiscount,payDiscountType,payVatPercent,payVatAmount) VALUES ('2024-11-08 11:44:27',1,'V',5570967290128860,5008399890186620,2024,'2024-11-08 11:44:27',4,1,0,4,'2024-11-08 11:59:27','P','KES',50,50,0,'','','',1,50,0,0,'',0,0) 08/11/2024 11:47:41.1900 1300 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 08/11/2024 11:48:49.4314 1178 ms. EXEC: insert into payReceipt (recTraUID,recPayUID,recYear,recDateTime,recText,recInvalid) VALUES (5261811912823080,4866496732168100,2024,'2024-11-08 11:48:48','---------------------------------- %The Mall P0006032390 End of payment ---------------------------------- POF Entry : 11/8/2024 11:10:33 AM Date : 11/8/2024 11:48:46 AM Code : 456024023300327001012999 Total : 50.00 KES VAT 16% : 6.90 KES ---------------------------------- Paid : 50.00 KES Coin changed : 0.00 KES Note changed : 0.00 KES',0) 08/11/2024 11:48:50.3701 860 ms. EXEC: insert into paycash (casCreation,casModify,casUseId,casStatus,casUID,casTraUID,casYear,casDateTime,casIdTerminal,casCurrency,casNumber,casSingleAmount,casTotAmount,casType,casDescription) VALUES ('2024-11-08 11:48:49',0,0,'V',4967238968420780,5261811912823080,2024,'2024-11-08 11:48:49',3,'KES',1,50,50,'N',''); 08/11/2024 11:49:08.0338 614 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 08/11/2024 11:51:38.8793 1096 ms. EXEC: insert into payPayment (payCreation,payUseId,payStatus,payUID,payTraUID,payYear,payDateTime,payIdTerminal,payEnabled,payDisableTime,payTarId,payTimeLimit,payType,payCurrency,payAmount,payPayed,payChange,payCardType,payPAN,paySTAN,payIdEvent,payAmountCalc,payDiscountValue,payDiscount,payDiscountType,payVatPercent,payVatAmount) VALUES ('2024-11-08 11:49:39',12,'V',4843566745834730,5460262237645470,2024,'2024-11-08 11:49:39',17,1,0,4,'2024-11-08 12:04:39','C','KES',50,50,0,'','','',1,50,0,0,'',0,0) 08/11/2024 11:52:05.0117 1361 ms. EXEC: insert into payReceipt (recTraUID,recPayUID,recYear,recDateTime,recText,recInvalid) VALUES (5341571883320850,5092583053700210,2024,'2024-11-08 11:52:03',' Date: 11/8/2024 11:52:03 AM Code: 456024218700327005012999 Entry Date: 11/8/2024 11:43:07 AM 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 # 2400748790 ',0) 08/11/2024 11:52:40.9697 501 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 08/11/2024 11:52:55.7725 1482 ms. EXEC: insert into movtransit (traUseId,traCreation,traStatus,traUID,traYear,traDateTime,traCode,traType,traClass,traIdTerminal,traDirection,traPlate,traEnabled,traDisableTime,traAreId,traNotes,traBadge,traTarId) VALUES (0,'2024-11-08 11:52:54','V',5437325905558430,2024,'2024-11-08 11:52:52','456024025400327005012999',2,2,2,'O','',0,'2024-11-08 11:52:54',1,'','',0) 08/11/2024 11:53:15.5887 1169 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/11/2024 11:54:04.2772 718 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 08/11/2024 11:55:06.5146 1012 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 08/11/2024 11:55:42.4236 596 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2024-11-08 11:55:41' where traUID = 5156242494270080 and traStatus='V' and traEnabled=1 08/11/2024 11:55:42.8098 680 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/11/2024 11:55:51.0973 517 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 08/11/2024 11:57:56.5619 620 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 08/11/2024 11:59:53.9581 1374 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/11/2024 12:02:20.0314 2718 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 08/11/2024 12:02:51.3973 510 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2024-11-08 12:02:50',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'; 08/11/2024 12:05:56.6447 588 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 08/11/2024 12:05:56.9959 970 ms. EXECSCALAR: select count(*) from information_schema.tables where table_schema= 'wisepark_0327' and table_name= 'payInvoiceFtp' nr: 1 08/11/2024 12:07:45.0669 542 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2024-11-08 12:07:44',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'; 08/11/2024 12:07:45.8244 756 ms. EXEC: update payInventory set invCreation = '2024-11-08 12:07:45',invModify = '2024-11-08 12:07:45',invUseId=0,invStatus='V' where invId = 217934 08/11/2024 12:07:46.5509 602 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2024-11-08 12:07:45',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'; 08/11/2024 12:07:46.9252 600 ms. EXEC: update tabTerminalReceipt set trcProgressive = 48792, trcLastPrinted = '2400748792', trcLastDate = '2024-11-08 12:07:46' where trcStatus='V' and trcTerId = 18 08/11/2024 12:09:43.6990 606 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 16 OR lnsTerId=16) 08/11/2024 12:09:57.5492 546 ms. EXEC: insert into movtransit (traUseId,traCreation,traStatus,traUID,traYear,traDateTime,traCode,traType,traClass,traIdTerminal,traDirection,traPlate,traEnabled,traDisableTime,traAreId,traNotes,traBadge,traTarId) VALUES (0,'2024-11-08 12:09:57','V',5523233028070190,2024,'2024-11-08 12:09:56','456024379600327005012999',1,2,16,'I','',1,0,1,'','',4) 08/11/2024 12:10:08.8187 519 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 5 and terStatus='V' 08/11/2024 12:10:49.5158 949 ms. EXEC: insert into movtransit (traUseId,traCreation,traStatus,traUID,traYear,traDateTime,traCode,traType,traClass,traIdTerminal,traDirection,traPlate,traEnabled,traDisableTime,traAreId,traNotes,traBadge,traTarId) VALUES (0,'2024-11-08 12:10:48','V',4668264234025640,2024,'2024-11-08 12:10:46','456024253600327005012999',2,2,2,'O','',0,'2024-11-08 12:10:48',1,'','',0) 08/11/2024 12:10:51.4191 1564 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2024-11-08 12:10:49' where traUID = 4730618603712250 and traStatus='V' and traEnabled=1 08/11/2024 12:10:55.9471 642 ms. OPEN: select sum(crc32(terDescription)) as vCheck from tabTerminal 08/11/2024 12:11:18.9604 574 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 08/11/2024 12:11:57.6622 1835 ms. OPEN: select * from tabCurrency where curStatus='V' and curCode = 'KES' 08/11/2024 12:11:59.9858 1627 ms. EXEC: insert into movtransit (traUseId,traCreation,traStatus,traUID,traYear,traDateTime,traCode,traType,traClass,traIdTerminal,traDirection,traPlate,traEnabled,traDisableTime,traAreId,traNotes,traBadge,traTarId) VALUES (0,'2024-11-08 12:11:58','V',5747875761037240,2024,'2024-11-08 12:11:57','456023888500327005012999',2,2,2,'O','',0,'2024-11-08 12:11:58',1,'','',0) 08/11/2024 12:13:35.2782 1796 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/11/2024 12:14:46.0033 928 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/11/2024 12:16:40.4506 522 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 08/11/2024 12:18:44.4602 581 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 08/11/2024 12:19:50.1900 836 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/11/2024 12:20:55.5355 874 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 2 and terStatus='V' 08/11/2024 12:21:46.9878 1302 ms. OPEN: select sum(crc32(devDescription)) as vCheck from tabDevice 08/11/2024 12:22:49.8346 2331 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2024-11-08 12:22:47' where traUID = 5686876772894450 and traStatus='V' and traEnabled=1 08/11/2024 12:22:49.8957 1898 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/11/2024 12:22:52.6125 527 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 08/11/2024 12:22:59.0138 554 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 08/11/2024 12:24:55.2052 1042 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2024-11-08 12:24:54' where payTraUID = 5635020035463310 and payStatus='V' and payEnabled=1 08/11/2024 12:30:10.1870 1473 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 5 08/11/2024 12:30:10.7304 1533 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/11/2024 12:30:11.1056 917 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 08/11/2024 12:30:31.9375 1098 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/11/2024 12:30:42.8037 721 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/11/2024 12:33:48.1612 636 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 08/11/2024 12:34:44.0434 678 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/11/2024 12:36:26.6458 698 ms. EXEC: insert into movtransit (traUseId,traCreation,traStatus,traUID,traYear,traDateTime,traCode,traType,traClass,traIdTerminal,traDirection,traPlate,traEnabled,traDisableTime,traAreId,traNotes,traBadge,traTarId) VALUES (0,'2024-11-08 12:36:25','V',4922390949163440,2024,'2024-11-08 12:36:24','456024538400327001012999',1,2,1,'I','',1,0,1,'','',4) 08/11/2024 12:36:27.3913 618 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 08/11/2024 12:37:16.9853 2420 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/11/2024 12:38:24.2731 543 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 08/11/2024 12:39:15.4002 1490 ms. EXECSCALAR: SELECT traId FROM movTransit WHERE traStatus='V' AND traCode = @traCode nr: 772116 08/11/2024 12:39:21.9385 743 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 08/11/2024 12:40:41.7347 1098 ms. OPEN: select sum(crc32(terDescription)) as vCheck from tabTerminal 08/11/2024 12:40:41.7917 743 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 08/11/2024 12:40:57.4422 1050 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/11/2024 12:42:44.1993 914 ms. EXEC: insert into movtransit (traUseId,traCreation,traStatus,traUID,traYear,traDateTime,traCode,traType,traClass,traIdTerminal,traDirection,traPlate,traEnabled,traDisableTime,traAreId,traNotes,traBadge,traTarId) VALUES (0,'2024-11-08 12:42:43','V',4758982529416740,2024,'2024-11-08 12:42:42','456024251600327005012999',2,2,2,'O','',0,'2024-11-08 12:42:43',1,'','',0) 08/11/2024 12:42:49.8881 620 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 08/11/2024 12:45:20.1201 559 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 08/11/2024 12:46:34.1545 1709 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 08/11/2024 12:48:02.3952 3598 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/11/2024 12:48:55.2675 637 ms. EXEC: insert into movtransit (traUseId,traCreation,traStatus,traUID,traYear,traDateTime,traCode,traType,traClass,traIdTerminal,traDirection,traPlate,traEnabled,traDisableTime,traAreId,traNotes,traBadge,traTarId) VALUES (0,'2024-11-08 12:48:54','V',5696631169285510,2024,'2024-11-08 12:48:53','456024413900327005012999',2,2,2,'O','',0,'2024-11-08 12:48:54',1,'','',0) 08/11/2024 12:50:45.0556 2055 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 4 OR lnsTerId=4) 08/11/2024 12:51:05.2981 845 ms. EXECSCALAR: select sum(parAllowNegativePlaces) from tabParameters where parStatus='V' order by parId desc limit 1 nr: 0 08/11/2024 12:51:05.5422 757 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 08/11/2024 12:52:43.0452 923 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/11/2024 12:53:37.3204 568 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 08/11/2024 12:53:39.0775 1107 ms. EXEC: update abbCards set carLastDate = '2024-11-08 12:53:37',carLastDirection='I' where carStatus='V' and carId = 14 08/11/2024 12:53:45.0805 591 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 08/11/2024 12:54:34.8177 1310 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 1 and terStatus='V' 08/11/2024 12:55:21.4647 564 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/11/2024 12:56:09.6518 1667 ms. OPEN: SELECT * FROM movLinks INNER JOIN movTransit on traUID = mliTraUID WHERE mliRFIDCode = '456024538400327001012999' AND mliStatus='V' ORDER BY mliId DESC LIMIT 1 08/11/2024 12:56:28.1592 527 ms. EXEC: insert into movtransit (traUseId,traCreation,traStatus,traUID,traYear,traDateTime,traCode,traType,traClass,traIdTerminal,traDirection,traPlate,traEnabled,traDisableTime,traAreId,traNotes,traBadge,traTarId) VALUES (0,'2024-11-08 12:56:27','V',5495610174022250,2024,'2024-11-08 12:56:27','456024658700327005012999',1,2,16,'I','',1,0,1,'','',4) 08/11/2024 12:56:58.0201 635 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/11/2024 12:57:33.5027 580 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 08/11/2024 12:57:35.2068 652 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 08/11/2024 13:01:06.5386 1021 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 08/11/2024 13:14:25.6169 1798 ms. EXECSCALAR: select count(*) from information_schema.tables where table_schema= 'wisepark_0327' and table_name= 'payInvoiceFtp' nr: 1 08/11/2024 13:14:26.6226 616 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 08/11/2024 13:14:35.0992 1194 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/11/2024 13:14:36.4101 602 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/11/2024 13:15:19.7840 807 ms. EXEC: insert into payPayment (payCreation,payUseId,payStatus,payUID,payTraUID,payYear,payDateTime,payIdTerminal,payEnabled,payDisableTime,payTarId,payTimeLimit,payType,payCurrency,payAmount,payPayed,payChange,payCardType,payPAN,paySTAN,payIdEvent,payAmountCalc,payDiscountValue,payDiscount,payDiscountType,payVatPercent,payVatAmount) VALUES ('2024-11-08 13:15:17',0,'V',5395179306003900,5059365955700760,2024,'2024-11-08 13:15:17',3,1,0,4,'2024-11-08 13:30:17','C','KES',50,50,0,'',' ',' ',1,50,0,0,'',0,0) 08/11/2024 13:15:54.7953 1479 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/11/2024 13:16:17.3653 887 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2024-11-08 13:16:16',3,42101,0,50,-1,-50,1,'O','N'); update payCurInventory set curQuantity=round(curQuantity+-1,5),curAmount=round(curAmount+-50,5) where curTerId = 3 and curDevCode = 42101 and curChannelId = 1 and curValue = 50 and curType = 'N'; Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2024-11-08 13:16:16',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'; 08/11/2024 13:17:09.2969 514 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 08/11/2024 13:17:58.3666 518 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 1 and terStatus='V' 08/11/2024 13:17:58.3946 691 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 5 08/11/2024 13:18:54.6221 524 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 2 08/11/2024 13:19:14.7905 1050 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 08/11/2024 13:19:42.6871 1201 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/11/2024 13:19:48.5740 640 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2024-11-08 13:19:47' where traUID = 5271911486541960 and traStatus='V' and traEnabled=1 08/11/2024 13:20:02.1311 542 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 08/11/2024 13:20:18.2958 3809 ms. EXEC: insert into payPayment (payCreation,payUseId,payStatus,payUID,payTraUID,payYear,payDateTime,payIdTerminal,payEnabled,payDisableTime,payTarId,payTimeLimit,payType,payCurrency,payAmount,payPayed,payChange,payCardType,payPAN,paySTAN,payIdEvent,payAmountCalc,payDiscountValue,payDiscount,payDiscountType,payVatPercent,payVatAmount) VALUES ('2024-11-08 13:20:13',0,'V',5031228635822910,5406939102185800,2024,'2024-11-08 13:20:13',18,1,0,4,'2024-11-08 13:35:13','C','KES',100,100,0,'','','',1,100,0,0,'',0,0) 08/11/2024 13:20:55.1624 1663 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 2 08/11/2024 13:21:58.3165 2226 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 2 08/11/2024 13:22:15.6360 987 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 2 OR lnsTerId=2) 08/11/2024 13:22:27.7191 707 ms. OPEN: select devId from tabDevice where devStatus='V' and devCode = 1 08/11/2024 13:23:14.2110 1232 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 08/11/2024 13:24:14.7534 693 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 08/11/2024 13:24:56.8854 648 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 08/11/2024 13:25:13.3144 596 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 08/11/2024 13:25:28.3904 1175 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/11/2024 13:26:30.9771 890 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 08/11/2024 13:26:42.4347 1533 ms. EXECSCALAR: select count(*) from information_schema.tables where table_schema= 'wisepark_0327' and table_name= 'payInvoiceFtp' nr: 1 08/11/2024 13:27:15.2986 768 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/11/2024 13:27:47.4470 809 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/11/2024 13:31:28.7405 766 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 08/11/2024 13:31:29.4860 1391 ms. EXECSCALAR: select count(*) from information_schema.tables where table_schema= 'wisepark_0327' and table_name= 'payInvoiceFtp' nr: 1 08/11/2024 13:32:13.1280 559 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/11/2024 13:33:12.4485 547 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 08/11/2024 13:33:51.7357 1620 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/11/2024 13:33:58.8194 3233 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/11/2024 13:34:03.9178 979 ms. EXEC: insert into payPayment (payCreation,payUseId,payStatus,payUID,payTraUID,payYear,payDateTime,payIdTerminal,payEnabled,payDisableTime,payTarId,payTimeLimit,payType,payCurrency,payAmount,payPayed,payChange,payCardType,payPAN,paySTAN,payIdEvent,payAmountCalc,payDiscountValue,payDiscount,payDiscountType,payVatPercent,payVatAmount) VALUES ('2024-11-08 13:32:06',12,'V',5084575451652500,4815216802708270,2024,'2024-11-08 13:32:06',17,1,0,4,'2024-11-08 13:47:06','C','KES',200,200,0,'','','',1,200,0,0,'',0,0) 08/11/2024 13:34:55.0159 1778 ms. EXECSCALAR: select count(0) as vTot from tabParameters where parPlateReading<>0 nr: 0 08/11/2024 13:35:52.7994 596 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 08/11/2024 13:35:53.2947 723 ms. EXECSCALAR: select count(*) from information_schema.tables where table_schema= 'wisepark_0327' and table_name= 'payInvoiceFtp' nr: 1 08/11/2024 13:37:56.6729 625 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 08/11/2024 13:38:16.1208 966 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 08/11/2024 13:38:16.1829 813 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/11/2024 13:40:15.9246 2626 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2024-11-08 13:40:13',3,42101,0,1000,1,1000,1,'I','N'); update payCurInventory set curQuantity=round(curQuantity+1,5),curAmount=round(curAmount+1000,5) where curTerId = 3 and curDevCode = 42101 and curChannelId = 1 and curValue = 1000 and curType = 'N'; 08/11/2024 13:42:01.7261 608 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/11/2024 13:42:01.7341 533 ms. EXECSCALAR: select count(resId) as Tot from movReservation where resStatus = 'V' and resTypeRes = 'B' AND ((resConfirmed IN (0,2,3) AND resCreation>'2024-11-08 12:42:01') OR resConfirmed IN (4,5)) and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) <= '2024-11-08 13:42:00' and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) >= '2024-11-08 13:42:00' and (resAreId = 1 or resAreId <= 0) nr: 0 08/11/2024 13:42:44.1964 1842 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2024-11-08 13:42:42' where traUID = 5571920268796880 and traStatus='V' and traEnabled=1 08/11/2024 13:44:29.7647 650 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 08/11/2024 13:45:01.4068 526 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 08/11/2024 13:45:01.7971 937 ms. EXECSCALAR: select count(*) from information_schema.tables where table_schema= 'wisepark_0327' and table_name= 'payInvoiceFtp' nr: 1 08/11/2024 13:45:59.6476 1529 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 16 OR lnsTerId=16) 08/11/2024 13:49:27.8093 634 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2024-11-08 13:49:27',3,42101,0,200,1,200,1,'I','N'); update payCurInventory set curQuantity=round(curQuantity+1,5),curAmount=round(curAmount+200,5) where curTerId = 3 and curDevCode = 42101 and curChannelId = 1 and curValue = 200 and curType = 'N'; 08/11/2024 13:49:29.1061 759 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2024-11-08 13:49:28',3,42101,0,50,-1,-50,1,'O','N'); update payCurInventory set curQuantity=round(curQuantity+-1,5),curAmount=round(curAmount+-50,5) where curTerId = 3 and curDevCode = 42101 and curChannelId = 1 and curValue = 50 and curType = 'N'; Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2024-11-08 13:49:28',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'; 08/11/2024 13:49:44.5564 655 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 08/11/2024 13:49:51.0678 577 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/11/2024 13:52:13.0924 567 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 08/11/2024 13:52:40.7728 689 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/11/2024 13:55:30.4899 612 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 08/11/2024 13:56:22.7877 659 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 08/11/2024 13:56:23.7524 1162 ms. EXEC: insert into payReceipt (recTraUID,recPayUID,recYear,recDateTime,recText,recInvalid) VALUES (5028941128643630,5268214381856110,2024,'2024-11-08 13:56:22','---------------------------------- %The Mall P0006032390 End of payment ---------------------------------- POF Entry : 11/8/2024 12:45:22 PM Date : 11/8/2024 1:56:17 PM Code : 456024592200327005012999 Total : 100.00 KES VAT 16% : 13.79 KES ---------------------------------- Paid : 100.00 KES Coin changed : 0.00 KES Note changed : 0.00 KES',0) 08/11/2024 13:57:07.1853 1167 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/11/2024 13:59:12.1555 1332 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/11/2024 14:01:17.1928 3157 ms. EXEC: insert into payReceipt (recTraUID,recPayUID,recYear,recDateTime,recText,recInvalid) VALUES (5719952287095180,4705478781445570,2024,'2024-11-08 14:01:14',' Date: 11/8/2024 2:01:13 PM Code: 456025025000327005012999 Entry Date: 11/8/2024 1:57:30 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 # 2400748808 ',0) 08/11/2024 14:03:02.4369 1680 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/11/2024 14:03:02.4840 2013 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2024-11-08 14:03:00' where traUID = 4987303358469840 and traStatus='V' and traEnabled=1 08/11/2024 14:03:35.3629 721 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 08/11/2024 14:04:24.8689 598 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/11/2024 14:05:13.8435 552 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 08/11/2024 14:05:43.4912 786 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 08/11/2024 14:05:51.8088 945 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/11/2024 14:07:44.8311 658 ms. OPEN: select sum(payPayed) as vTot,sum(payChange) as vChange from movTransit inner join payPayment on payPayment.payTraUID = movTransit.traUID LEFT JOIN tabTerminal on terId = payIdTerminal WHERE traCode = '456025086300327001012999' AND traStatus='V' AND payStatus='V' and (terType IS NULL OR terType<>3 OR (terType=3 and payType='P')) 08/11/2024 14:07:45.4575 596 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 08/11/2024 14:08:16.3100 809 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/11/2024 14:11:48.3633 542 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/11/2024 14:15:10.9532 502 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/11/2024 14:15:32.6117 781 ms. EXEC: insert into movtransit (traUseId,traCreation,traStatus,traUID,traYear,traDateTime,traCode,traType,traClass,traIdTerminal,traDirection,traPlate,traEnabled,traDisableTime,traAreId,traNotes,traBadge,traTarId) VALUES (0,'2024-11-08 14:15:31','V',5377883346493090,2024,'2024-11-08 14:15:30','456025074200327005012999',2,2,2,'O','',0,'2024-11-08 14:15:31',1,'','',0) 08/11/2024 14:15:42.2751 524 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 08/11/2024 14:16:42.8144 1369 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/11/2024 14:16:51.2401 636 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2024-11-08 14:16:50',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'; 08/11/2024 14:17:04.4028 514 ms. EXEC: insert into movtransit (traUseId,traCreation,traStatus,traUID,traYear,traDateTime,traCode,traType,traClass,traIdTerminal,traDirection,traPlate,traEnabled,traDisableTime,traAreId,traNotes,traBadge,traTarId) VALUES (0,'2024-11-08 14:17:03','V',5719343118930970,2024,'2024-11-08 14:17:02','456024658700327005012999',2,2,2,'O','',0,'2024-11-08 14:17:03',1,'','',0) 08/11/2024 14:17:05.9048 1386 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 08/11/2024 14:17:11.9368 1224 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 08/11/2024 14:17:56.3144 587 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 08/11/2024 14:18:15.2170 1052 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 08/11/2024 14:18:15.8914 549 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2024-11-08 14:18:15' where payTraUID = 4762657904484170 and payStatus='V' and payEnabled=1 08/11/2024 14:19:11.7757 787 ms. EXEC: insert into movtransit (traUseId,traCreation,traStatus,traUID,traYear,traDateTime,traCode,traType,traClass,traIdTerminal,traDirection,traPlate,traEnabled,traDisableTime,traAreId,traNotes,traBadge,traTarId) VALUES (0,'2024-11-08 14:19:10','V',4799494435171220,2024,'2024-11-08 14:19:10','456024424200327005012999',2,2,2,'O','',0,'2024-11-08 14:19:10',1,'','',0) 08/11/2024 14:19:19.7520 717 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 08/11/2024 14:19:43.9881 578 ms. OPEN: select sum(crc32(terDescription)) as vCheck from tabTerminal 08/11/2024 14:19:44.2983 536 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/11/2024 14:19:44.5495 1073 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 08/11/2024 14:23:05.9176 980 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 08/11/2024 14:24:53.3342 618 ms. OPEN: select * from opeShifts where sftId = 823 and sftStatus = 'V' 08/11/2024 14:25:12.4710 629 ms. EXEC: update opeActivities set acvFstPayId = (case acvFstPayId when 0 then 368706 else acvFstPayId end),acvLstPayId = 368706 where acvSftId = 823 and acvCodeId = 3 08/11/2024 14:27:29.8355 860 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 08/11/2024 14:27:46.2544 622 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 08/11/2024 14:27:47.2621 1123 ms. EXEC: insert into payPayment (payCreation,payUseId,payStatus,payUID,payTraUID,payYear,payDateTime,payIdTerminal,payEnabled,payDisableTime,payTarId,payTimeLimit,payType,payCurrency,payAmount,payPayed,payChange,payCardType,payPAN,paySTAN,payIdEvent,payAmountCalc,payDiscountValue,payDiscount,payDiscountType,payVatPercent,payVatAmount) VALUES ('2024-11-08 14:27:40',0,'V',4812829865779270,5463802172601000,2024,'2024-11-08 14:27:40',3,1,0,4,'2024-11-08 14:42:40','C','KES',50,50,0,'',' ',' ',1,50,0,0,'',0,0) 08/11/2024 14:28:57.4268 854 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 08/11/2024 14:29:07.4335 1188 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/11/2024 14:29:39.8290 1032 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 08/11/2024 14:30:16.0832 593 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2024-11-08 14:30:15',3,42101,0,100,1,100,1,'I','N'); update payCurInventory set curQuantity=round(curQuantity+1,5),curAmount=round(curAmount+100,5) where curTerId = 3 and curDevCode = 42101 and curChannelId = 1 and curValue = 100 and curType = 'N'; 08/11/2024 14:30:40.4895 637 ms. EXEC: insert into payReceipt (recTraUID,recPayUID,recYear,recDateTime,recText,recInvalid) VALUES (5152537359490670,5441358152655510,2024,'2024-11-08 14:30:39',' Data: 11/8/2024 2:28:41 PM Codice: 456024996100327005012999 Ingresso: 11/8/2024 1:52:41 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 # 2400606958 ',0) 08/11/2024 14:30:56.2089 730 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 08/11/2024 14:31:03.2936 503 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 08/11/2024 14:31:10.2263 515 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 2 OR lnsTerId=2) 08/11/2024 14:31:56.2079 2675 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/11/2024 14:31:59.2229 1840 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2024-11-08 14:31:57' where payTraUID = 5332422085830640 and payStatus='V' and payEnabled=1 08/11/2024 14:32:12.3637 1258 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/11/2024 14:33:18.6548 1364 ms. EXEC: insert into movtransit (traUseId,traCreation,traStatus,traUID,traYear,traDateTime,traCode,traType,traClass,traIdTerminal,traDirection,traPlate,traEnabled,traDisableTime,traAreId,traNotes,traBadge,traTarId) VALUES (0,'2024-11-08 14:33:17','V',5193788073943400,2024,'2024-11-08 14:33:15','456024572700327005012999',2,2,2,'O','',0,'2024-11-08 14:33:17',1,'','',0) 08/11/2024 14:35:12.1334 873 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 1 08/11/2024 14:35:34.9016 570 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/11/2024 14:35:46.5844 548 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/11/2024 14:35:55.2021 1463 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/11/2024 14:36:21.2254 529 ms. EXEC: INSERT INTO movOperator (opeCreation,opeUseId,opeTerId,opeDateTime,opeCode,opeDescription) VALUES ('2024-11-08 14:36:20',0,16,'2024-11-08 14:36:20','','Unauthorized Transit Entry 2') (WAIT TIME 78 ms.) 08/11/2024 14:38:43.7584 782 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 08/11/2024 14:39:09.9028 573 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/11/2024 14:39:19.8174 811 ms. EXEC: insert into movtransit (traUseId,traCreation,traStatus,traUID,traYear,traDateTime,traCode,traType,traClass,traIdTerminal,traDirection,traPlate,traEnabled,traDisableTime,traAreId,traNotes,traBadge,traCarId,traTarId) VALUES (0,'2024-11-08 14:39:19','V',5339615644481150,2024,'2024-11-08 14:39:18','456025275800327005012999',1,2,16,'I','',1,0,1,'','0750009518612',99,0) 08/11/2024 14:40:36.4865 594 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 08/11/2024 14:40:40.3661 1724 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/11/2024 14:40:58.6823 505 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/11/2024 14:42:24.0741 690 ms. EXEC: insert into movtransit (traUseId,traCreation,traStatus,traUID,traYear,traDateTime,traCode,traType,traClass,traIdTerminal,traDirection,traPlate,traEnabled,traDisableTime,traAreId,traNotes,traBadge,traTarId) VALUES (0,'2024-11-08 14:42:23','V',4675190147879620,2024,'2024-11-08 14:42:21','456025294100327005012999',1,2,16,'I','',1,0,1,'','',4) 08/11/2024 14:43:32.1155 1233 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/11/2024 14:43:33.9237 763 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/11/2024 14:43:48.2282 792 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2024-11-08 14:43:47' where traUID = 5432769724041340 and traStatus='V' and traEnabled=1 08/11/2024 14:44:19.0217 615 ms. EXEC: insert into payReceipt (recTraUID,recPayUID,recYear,recDateTime,recText,recInvalid) VALUES (4974578479647460,4628705825234330,2024,'2024-11-08 14:44:18','---------------------------------- %The Mall P0006032390 End of payment ---------------------------------- POF Entry : 11/8/2024 2:02:12 PM Date : 11/8/2024 2:44:17 PM Code : 456025053200327005012999 Total : 50.00 KES VAT 16% : 6.90 KES ---------------------------------- Paid : 50.00 KES Coin changed : 0.00 KES Note changed : 0.00 KES',0) 08/11/2024 14:44:40.8383 516 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 08/11/2024 14:47:18.1991 618 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 08/11/2024 14:47:59.1744 801 ms. EXECSCALAR: select count(*) from tabTerminalExtraMem where extStatus='V' and extTerId = 16 nr: 1 08/11/2024 14:48:51.0499 1797 ms. EXEC: insert into movtransit (traUseId,traCreation,traStatus,traUID,traYear,traDateTime,traCode,traType,traClass,traIdTerminal,traDirection,traPlate,traEnabled,traDisableTime,traAreId,traNotes,traBadge,traTarId) VALUES (0,'2024-11-08 14:48:49','V',5167904735962890,2024,'2024-11-08 14:48:47','456025185900327005012999',2,2,2,'O','',0,'2024-11-08 14:48:49',1,'','',0) 08/11/2024 14:48:55.8982 999 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 08/11/2024 14:49:16.8551 1015 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2024-11-08 14:49:15' where traUID = 5626596518726170 and traStatus='V' and traEnabled=1 08/11/2024 14:49:16.8561 570 ms. EXEC: insert into payPayment (payCreation,payUseId,payStatus,payUID,payTraUID,payYear,payDateTime,payIdTerminal,payEnabled,payDisableTime,payTarId,payTimeLimit,payType,payCurrency,payAmount,payPayed,payChange,payCardType,payPAN,paySTAN,payIdEvent,payAmountCalc,payDiscountValue,payDiscount,payDiscountType,payVatPercent,payVatAmount) VALUES ('2024-11-08 14:49:15',0,'V',5126416890293900,5231066993784860,2024,'2024-11-08 14:49:15',3,1,0,4,'2024-11-08 15:04:15','C','KES',50,100,50,'',' ',' ',1,50,0,0,'',0,0) 08/11/2024 14:49:29.3474 560 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 08/11/2024 14:49:57.9965 546 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); (WAIT TIME 6 ms.) 08/11/2024 14:51:09.3230 578 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 08/11/2024 14:52:55.8760 641 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 08/11/2024 14:52:56.5805 514 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2024-11-08 14:52:56' where traUID = 5708004463002940 and traStatus='V' and traEnabled=1 08/11/2024 14:53:19.3847 662 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 08/11/2024 14:54:02.5634 665 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2024-11-08 14:54:01' where traUID = 5465878079231460 and traStatus='V' and traEnabled=1 08/11/2024 14:54:49.6298 966 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 08/11/2024 14:54:49.6358 1103 ms. EXEC: UPDATE payInventory SET invType='N' WHERE invType<>'N' AND invValue IN (100,200,500) AND invDevice IN (42102,42101,42001); 08/11/2024 14:54:49.6378 657 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 08/11/2024 14:54:49.7419 1087 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 08/11/2024 14:55:01.8850 1059 ms. EXEC: insert into movtransit (traUseId,traCreation,traStatus,traUID,traYear,traDateTime,traCode,traType,traClass,traIdTerminal,traDirection,traPlate,traEnabled,traDisableTime,traAreId,traNotes,traBadge,traTarId) VALUES (0,'2024-11-08 14:55:00','V',5241290814955410,2024,'2024-11-08 14:54:58','456025156000327001012999',2,2,2,'O','',0,'2024-11-08 14:55:00',1,'','',0) 08/11/2024 14:55:04.6268 559 ms. EXEC: INSERT INTO movOperator (opeCreation,opeUseId,opeTerId,opeDateTime,opeCode,opeDescription) VALUES ('2024-11-08 14:55:04',0,16,'2024-11-08 14:55:04','','Unauthorized Transit Entry 2') 08/11/2024 14:55:30.7532 582 ms. EXEC: insert into movtransit (traUseId,traCreation,traStatus,traUID,traYear,traDateTime,traCode,traType,traClass,traIdTerminal,traDirection,traPlate,traEnabled,traDisableTime,traAreId,traNotes,traBadge,traTarId) VALUES (0,'2024-11-08 14:55:30','V',4885442112043740,2024,'2024-11-08 14:55:28','456025372800327005012999',1,2,16,'I','',1,0,1,'','',4) 08/11/2024 14:55:57.5100 2521 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 08/11/2024 14:56:37.5927 617 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 08/11/2024 14:58:55.6007 957 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/11/2024 15:01:47.0429 2446 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/11/2024 15:01:54.3948 700 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 08/11/2024 15:02:05.2000 503 ms. EXEC: insert into movtransit (traUseId,traCreation,traStatus,traUID,traYear,traDateTime,traCode,traType,traClass,traIdTerminal,traDirection,traPlate,traEnabled,traDisableTime,traAreId,traNotes,traBadge,traTarId) VALUES (0,'2024-11-08 15:02:04','V',4943434290527310,2024,'2024-11-08 15:02:02','456025243300327005012999',2,2,2,'O','',0,'2024-11-08 15:02:04',1,'','',0) 08/11/2024 15:02:07.6876 849 ms. EXECSCALAR: SELECT traId FROM movTransit WHERE traStatus='V' AND traCode = @traCode nr: 772366 08/11/2024 15:03:49.6475 1225 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 08/11/2024 15:04:49.8616 1205 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/11/2024 15:05:35.9163 1097 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 3 08/11/2024 15:07:18.7508 667 ms. EXEC: insert into payPayment (payCreation,payUseId,payStatus,payUID,payTraUID,payYear,payDateTime,payIdTerminal,payEnabled,payDisableTime,payTarId,payTimeLimit,payType,payCurrency,payAmount,payPayed,payChange,payCardType,payPAN,paySTAN,payIdEvent,payVatPercent,payVatAmount) VALUES ('2024-11-08 15:07:18',0,'V',5511254974304160,5678924350028770,2024,'2024-11-08 15:07:18',2,1,0,-1,'2024-11-08 16:07:18','S','KES',0,0,0,'','','',3,0,0) 08/11/2024 15:07:19.6945 748 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 08/11/2024 15:07:26.6861 793 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 08/11/2024 15:07:37.8516 560 ms. EXEC: insert into movtransit (traUseId,traCreation,traStatus,traUID,traYear,traDateTime,traCode,traType,traClass,traIdTerminal,traDirection,traPlate,traEnabled,traDisableTime,traAreId,traNotes,traBadge,traTarId) VALUES (0,'2024-11-08 15:07:37','V',4918548477752820,2024,'2024-11-08 15:07:37','456025445700327005012999',1,2,16,'I','',1,0,1,'','',4) 08/11/2024 15:07:56.5570 540 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/11/2024 15:08:10.4593 768 ms. EXEC: insert into payPayment (payCreation,payUseId,payStatus,payUID,payTraUID,payYear,payDateTime,payIdTerminal,payEnabled,payDisableTime,payTarId,payTimeLimit,payType,payCurrency,payAmount,payPayed,payChange,payCardType,payPAN,paySTAN,payIdEvent,payAmountCalc,payDiscountValue,payDiscount,payDiscountType,payVatPercent,payVatAmount) VALUES ('2024-11-08 15:06:12',12,'V',4796402414468450,5645551837937720,2024,'2024-11-08 15:06:12',17,1,0,4,'2024-11-08 15:21:12','C','KES',100,100,0,'','','',1,100,0,0,'',0,0) 08/11/2024 15:08:21.1794 511 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 08/11/2024 15:08:23.5660 1082 ms. EXEC: update paycash set casCreation = '2024-11-08 15:08:22',casModify = '2024-11-08 15:08:22',casUseId=0,casStatus='V' where casId = 193808 08/11/2024 15:09:34.9255 516 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 08/11/2024 15:10:53.6660 1867 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 08/11/2024 15:13:01.2480 546 ms. OPEN: select * from tabArea where areStatus='V' and areEnabled = 1 AND areId = 1 08/11/2024 15:13:08.5749 544 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 5 08/11/2024 15:13:19.4671 620 ms. EXEC: INSERT INTO movOperator (opeCreation,opeUseId,opeTerId,opeDateTime,opeCode,opeDescription) VALUES ('2024-11-08 15:13:18',0,16,'2024-11-08 15:13:18','','Unauthorized Transit Entry 2') 08/11/2024 15:13:22.9184 539 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/11/2024 15:15:49.1298 568 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 08/11/2024 15:15:50.0364 1128 ms. EXECSCALAR: select count(*) from information_schema.tables where table_schema= 'wisepark_0327' and table_name= 'payInvoiceFtp' nr: 1 08/11/2024 15:16:18.5534 728 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 5 and terStatus='V' 08/11/2024 15:16:40.2809 763 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 08/11/2024 15:17:39.1471 683 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 08/11/2024 15:18:09.4713 509 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2024-11-08 15:18:08' where payTraUID = 4737773187848640 and payStatus='V' and payEnabled=1 08/11/2024 15:18:16.2828 1574 ms. OPEN: show columns from tabTerminalReceipt where Field = 'trcForced' 08/11/2024 15:18:42.6914 906 ms. EXEC: insert into payReceipt (recTraUID,recPayUID,recYear,recDateTime,recText,recInvalid) VALUES (4822836490839090,5157641542230070,2024,'2024-11-08 15:18:41',' Date: 11/8/2024 3:18:41 PM Code: 456025396000327005012999 Entry Date: 11/8/2024 2:59:20 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 # 2400748822 ',0) 08/11/2024 15:18:52.1147 683 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 08/11/2024 15:18:53.7838 1579 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2024-11-08 15:18:52' where traUID = 5270848187021970 and traStatus='V' and traEnabled=1 08/11/2024 15:19:24.4122 587 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 08/11/2024 15:20:18.2011 601 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/11/2024 15:20:46.3828 1166 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2024-11-08 15:20:44' where traUID = 5146870787115750 and traStatus='V' and traEnabled=1 08/11/2024 15:20:52.4239 806 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 08/11/2024 15:21:00.7334 1715 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 08/11/2024 15:21:09.2120 634 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 08/11/2024 15:22:59.9408 709 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/11/2024 15:24:54.9474 664 ms. EXEC: insert into payPayment (payCreation,payUseId,payStatus,payUID,payTraUID,payYear,payDateTime,payIdTerminal,payEnabled,payDisableTime,payTarId,payTimeLimit,payType,payCurrency,payAmount,payPayed,payChange,payCardType,payPAN,paySTAN,payIdEvent,payAmountCalc,payDiscountValue,payDiscount,payDiscountType,payVatPercent,payVatAmount) VALUES ('2024-11-08 15:24:54',0,'V',5135032883579420,5639168277742030,2024,'2024-11-08 15:24:54',18,1,0,4,'2024-11-08 15:39:54','C','KES',100,100,0,'','','',1,100,0,0,'',0,0) 08/11/2024 15:25:24.1519 544 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 08/11/2024 15:27:40.8269 1971 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2024-11-08 15:27:38' where payTraUID = 4792457068084900 and payStatus='V' and payEnabled=1 08/11/2024 15:28:58.1014 617 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 08/11/2024 15:31:32.2141 671 ms. EXEC: insert into movtransit (traUseId,traCreation,traStatus,traUID,traYear,traDateTime,traCode,traType,traClass,traIdTerminal,traDirection,traPlate,traEnabled,traDisableTime,traAreId,traNotes,traBadge,traTarId) VALUES (0,'2024-11-08 15:31:31','V',4675305601612020,2024,'2024-11-08 15:31:29','456025588900327005012999',1,2,16,'I','',1,0,1,'','',4) 08/11/2024 15:33:14.4061 919 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2024-11-08 15:33:13',3,42101,0,50,-1,-50,1,'O','N'); update payCurInventory set curQuantity=round(curQuantity+-1,5),curAmount=round(curAmount+-50,5) where curTerId = 3 and curDevCode = 42101 and curChannelId = 1 and curValue = 50 and curType = 'N'; Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2024-11-08 15:33:13',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'; 08/11/2024 15:41:33.9929 1858 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2024-11-08 15:41:31',3,42101,0,50,-1,-50,1,'O','N'); update payCurInventory set curQuantity=round(curQuantity+-1,5),curAmount=round(curAmount+-50,5) where curTerId = 3 and curDevCode = 42101 and curChannelId = 1 and curValue = 50 and curType = 'N'; Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2024-11-08 15:41:31',3,42101,0,200,-2,-400,1,'O','N'); update payCurInventory set curQuantity=round(curQuantity+-2,5),curAmount=round(curAmount+-400,5) where curTerId = 3 and curDevCode = 42101 and curChannelId = 1 and curValue = 200 and curType = 'N'; 08/11/2024 15:41:43.2961 571 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 08/11/2024 15:43:05.6680 560 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/11/2024 15:43:06.8218 1554 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 08/11/2024 15:44:35.0115 818 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/11/2024 15:46:08.0605 843 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/11/2024 15:46:20.6349 587 ms. EXEC: insert into movtransit (traUseId,traCreation,traStatus,traUID,traYear,traDateTime,traCode,traType,traClass,traIdTerminal,traDirection,traPlate,traEnabled,traDisableTime,traAreId,traNotes,traBadge,traTarId) VALUES (0,'2024-11-08 15:46:20','V',5199635276277610,2024,'2024-11-08 15:46:18','456025339500327001012999',2,2,2,'O','',0,'2024-11-08 15:46:20',1,'','',0) 08/11/2024 15:46:21.1902 551 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 08/11/2024 15:46:26.8810 738 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 08/11/2024 15:47:41.9571 569 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 5 (WAIT TIME 4 ms.) 08/11/2024 15:47:42.6135 658 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2024-11-08 15:47:41' where payTraUID = 5302983741338340 and payStatus='V' and payEnabled=1 08/11/2024 15:47:48.9307 567 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 08/11/2024 15:47:49.2229 701 ms. EXECSCALAR: select count(*) from information_schema.tables where table_schema= 'wisepark_0327' and table_name= 'payInvoiceFtp' nr: 1 08/11/2024 15:49:20.2535 1016 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/11/2024 15:50:09.2942 1869 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/11/2024 15:50:25.1638 1855 ms. OPEN: SELECT traCode FROM movTransit WHERE traId = '772278' and traDirection='I' order by traId DESC LIMIT 1 08/11/2024 15:53:29.0162 522 ms. EXEC: insert into movtransit (traUseId,traCreation,traStatus,traUID,traYear,traDateTime,traCode,traType,traClass,traIdTerminal,traDirection,traPlate,traEnabled,traDisableTime,traAreId,traNotes,traBadge,traTarId) VALUES (0,'2024-11-08 15:53:28','V',5741901366916250,2024,'2024-11-08 15:53:27','456025720700327005012999',1,2,16,'I','',1,0,1,'','',4) 08/11/2024 15:53:43.3468 1493 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 08/11/2024 15:53:44.1783 619 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2024-11-08 15:53:43' where traUID = 4918548477752820 and traStatus='V' and traEnabled=1 08/11/2024 15:53:56.3585 690 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/11/2024 15:54:17.8738 589 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 08/11/2024 15:56:46.0925 905 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 08/11/2024 16:00:23.7865 604 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2024-11-08 16:00:23',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'; 08/11/2024 16:01:32.2471 1128 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/11/2024 16:03:07.1163 618 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 08/11/2024 16:03:19.2584 1515 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 1 OR lnsTerId=1) 08/11/2024 16:05:41.9195 653 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/11/2024 16:05:41.9205 918 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 08/11/2024 16:06:21.5729 799 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 08/11/2024 16:06:22.2023 572 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2024-11-08 16:06:21' where traUID = 4969517131999010 and traStatus='V' and traEnabled=1 08/11/2024 16:06:55.4084 764 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/11/2024 16:07:59.1799 585 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 08/11/2024 16:08:11.2930 889 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 5 08/11/2024 16:08:28.2293 1757 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/11/2024 16:09:46.6855 1002 ms. EXEC: update abbSubscriptions set subCredit = round(subCredit-0,5),subLastDebit = '2024-11-08 16:09:45' where subId = 12 08/11/2024 16:10:08.4390 1827 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 08/11/2024 16:11:03.2585 1029 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2024-11-08 16:11:02',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'; 08/11/2024 16:11:06.1815 565 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 08/11/2024 16:11:36.2015 657 ms. EXEC: insert into movtransit (traUseId,traCreation,traStatus,traUID,traYear,traDateTime,traCode,traType,traClass,traIdTerminal,traDirection,traPlate,traEnabled,traDisableTime,traAreId,traNotes,traBadge,traTarId) VALUES (0,'2024-11-08 16:11:35','V',5743038808559480,2024,'2024-11-08 16:11:32','456024211700327005012999',2,2,2,'O','',0,'2024-11-08 16:11:35',1,'','',0) 08/11/2024 16:11:37.0831 681 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 08/11/2024 16:16:52.0679 612 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 08/11/2024 16:20:50.1325 686 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/11/2024 16:22:05.3136 1571 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 08/11/2024 16:22:20.2615 592 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 16 OR lnsTerId=16) 08/11/2024 16:22:59.5457 522 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 08/11/2024 16:24:51.1971 516 ms. OPEN: SELECT SUM(vTot) as vTot,payTimeLimit FROM (SELECT SUM(payPayed)-SUM(payChange) AS vTot,MAX(payTimeLimit) AS payTimeLimit FROM payPayment INNER JOIN movtransit ON movtransit.traUID=payPayment.payTraUID WHERE traCode = '456025793900327005012999' AND traStatus='V' AND payStatus='V' AND payIdEvent<90 GROUP BY payId ORDER BY payEnabled DESC, payTimeLimit DESC) as v1 08/11/2024 16:25:14.5306 597 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2024-11-08 16:25:13',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'; 08/11/2024 16:26:37.9922 1608 ms. EXEC: update abbCards set carLastDate = '2024-11-08 16:26:36',carLastDirection='O' where carStatus='V' and carId = 9 08/11/2024 16:29:41.1442 508 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/11/2024 16:29:56.6525 3404 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/11/2024 16:31:40.1265 1237 ms. EXEC: insert into payPayment (payCreation,payUseId,payStatus,payUID,payTraUID,payYear,payDateTime,payIdTerminal,payEnabled,payDisableTime,payTarId,payTimeLimit,payType,payCurrency,payAmount,payPayed,payChange,payCardType,payPAN,paySTAN,payIdEvent,payAmountCalc,payDiscountValue,payDiscount,payDiscountType,payVatPercent,payVatAmount) VALUES ('2024-11-08 16:31:38',0,'V',5053552286419690,4818578273113350,2024,'2024-11-08 16:31:38',18,1,0,4,'2024-11-08 16:46:38','C','KES',50,50,0,'','','',1,50,0,0,'',0,0) 08/11/2024 16:31:55.4126 2889 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 08/11/2024 16:32:37.1845 526 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 08/11/2024 16:32:45.0387 581 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 08/11/2024 16:37:28.6606 691 ms. EXEC: insert into movtransit (traUseId,traCreation,traStatus,traUID,traYear,traDateTime,traCode,traType,traClass,traIdTerminal,traDirection,traPlate,traEnabled,traDisableTime,traAreId,traNotes,traBadge,traTarId) VALUES (0,'2024-11-08 16:37:27','V',5279058351633870,2024,'2024-11-08 16:37:27','456025984700327005012999',1,2,16,'I','',1,0,1,'','',4) 08/11/2024 16:37:43.0883 1729 ms. EXECSCALAR: select count(*) from tabTerminalExtraMem where extStatus='V' and extTerId = 16 nr: 1 08/11/2024 16:38:26.8014 683 ms. EXEC: insert into payReceipt (recTraUID,recPayUID,recYear,recDateTime,recText,recInvalid) VALUES (5741901366916250,5445439231509970,2024,'2024-11-08 16:38:26',' Date: 11/8/2024 4:38:25 PM Code: 456025720700327005012999 Entry Date: 11/8/2024 3:53:27 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 # 2400748845 ',0) 08/11/2024 16:38:31.9258 556 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 08/11/2024 16:40:32.1859 741 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/11/2024 16:40:33.6529 988 ms. EXEC: insert into payPayment (payCreation,payUseId,payStatus,payUID,payTraUID,payYear,payDateTime,payIdTerminal,payEnabled,payDisableTime,payTarId,payTimeLimit,payType,payCurrency,payAmount,payPayed,payChange,payCardType,payPAN,paySTAN,payIdEvent,payAmountCalc,payDiscountValue,payDiscount,payDiscountType,payVatPercent,payVatAmount) VALUES ('2024-11-08 16:40:32',0,'V',4988900543017520,5065439616976450,2024,'2024-11-08 16:40:32',18,1,0,4,'2024-11-08 16:55:32','C','KES',50,50,0,'','','',1,50,0,0,'',0,0) 08/11/2024 16:40:33.9431 2691 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2024-11-08 16:40:30',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'; 08/11/2024 16:41:03.1925 1214 ms. EXECSCALAR: select count(*) from information_schema.tables where table_schema= 'wisepark_0327' and table_name= 'payInvoiceFtp' nr: 1 08/11/2024 16:42:16.9167 1728 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 08/11/2024 16:42:22.1752 954 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 2 OR lnsTerId=2) 08/11/2024 16:42:24.7199 847 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/11/2024 16:42:25.4944 507 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/11/2024 16:42:31.7145 628 ms. EXEC: drop temporary table if exists temp_tariff 08/11/2024 16:42:44.1198 531 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/11/2024 16:43:03.3206 514 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 08/11/2024 16:43:13.1611 1121 ms. EXEC: update payReceipt set recCreation = '2024-11-08 16:43:12',recModify = '2024-11-08 16:43:12',recUseId=0,recStatus='V' where recId = 320575 08/11/2024 16:43:59.2168 594 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 08/11/2024 16:44:28.7845 634 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 08/11/2024 16:45:14.2438 511 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/11/2024 16:51:28.1108 548 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/11/2024 16:52:00.4894 814 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/11/2024 16:53:13.5951 3993 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/11/2024 16:54:28.0387 524 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 08/11/2024 16:54:45.5354 548 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 2 08/11/2024 16:55:02.0073 661 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 08/11/2024 16:56:36.1831 731 ms. OPEN: select sum(casTotAmount) as vTot from payCash where casStatus='V' and casTraUID = 4977756994690850 08/11/2024 16:56:36.6143 727 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 08/11/2024 16:57:11.9979 1383 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/11/2024 16:58:59.1713 653 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 08/11/2024 17:00:21.9034 605 ms. EXEC: insert into movtransit (traUseId,traCreation,traStatus,traUID,traYear,traDateTime,traCode,traType,traClass,traIdTerminal,traDirection,traPlate,traEnabled,traDisableTime,traAreId,traNotes,traBadge,traTarId) VALUES (0,'2024-11-08 17:00:21','V',5257851351251390,2024,'2024-11-08 17:00:20','456025984700327005012999',2,2,2,'O','',0,'2024-11-08 17:00:21',1,'','',0) 08/11/2024 17:01:22.9051 598 ms. EXEC: update payReceipt set recCreation = '2024-11-08 17:01:22',recModify = '2024-11-08 17:01:22',recUseId=0,recStatus='V' where recId = 320584 08/11/2024 17:04:43.8269 1376 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/11/2024 17:08:30.5970 712 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 08/11/2024 17:14:29.4640 598 ms. EXEC: update payReceipt set recCreation = '2024-11-08 17:14:28',recModify = '2024-11-08 17:14:28',recUseId=0,recStatus='V' where recId = 320589 08/11/2024 17:20:18.7617 646 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/11/2024 17:20:42.0232 713 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 08/11/2024 17:20:54.8317 681 ms. EXEC: update payReceipt set recCreation = '2024-11-08 17:20:54',recModify = '2024-11-08 17:20:54',recUseId=0,recStatus='V' where recId = 320593 08/11/2024 17:21:28.6343 779 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 08/11/2024 17:23:27.8977 528 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2024-11-08 17:23:27',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'; 08/11/2024 17:23:53.8840 724 ms. EXEC: insert into payPayment (payCreation,payUseId,payStatus,payUID,payTraUID,payYear,payDateTime,payIdTerminal,payEnabled,payDisableTime,payTarId,payTimeLimit,payType,payCurrency,payAmount,payPayed,payChange,payCardType,payPAN,paySTAN,payIdEvent,payAmountCalc,payDiscountValue,payDiscount,payDiscountType,payVatPercent,payVatAmount) VALUES ('2024-11-08 17:23:53',0,'V',4871871035496020,5414732240379240,2024,'2024-11-08 17:23:53',18,1,0,4,'2024-11-08 17:38:53','C','KES',50,50,0,'','','',1,50,0,0,'',0,0) 08/11/2024 17:24:43.1178 609 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 08/11/2024 17:26:42.4643 582 ms. EXEC: update abbCards set carLastDate = '2024-11-08 17:26:41',carLastDirection='O' where carStatus='V' and carId = 144 08/11/2024 17:27:02.9680 582 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 08/11/2024 17:27:11.6678 571 ms. EXECSCALAR: select count(*) from information_schema.tables where table_schema= 'wisepark_0327' and table_name= 'tabCardConversionRules' nr: 1 08/11/2024 17:30:42.8685 551 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 08/11/2024 17:30:55.1266 947 ms. EXEC: insert into payReceipt (recTraUID,recPayUID,recYear,recDateTime,recText,recInvalid) VALUES (5129886497957100,5402935208852260,2024,'2024-11-08 17:30:54',' Date: 11/8/2024 5:28:27 PM Code: 456026100600327005012999 Entry Date: 11/8/2024 4:56:46 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 # 2400415811 ',0) 08/11/2024 17:31:24.3361 569 ms. EXEC: insert into payReceipt (recTraUID,recPayUID,recYear,recDateTime,recText,recInvalid) VALUES (5543195378421190,5126433553577540,2024,'2024-11-08 17:31:23',' Date: 11/8/2024 5:31:22 PM Code: 456025460600327001012999 Entry Date: 11/8/2024 3:10:06 PM Plate: Class: Cars Park: The Mall Gate: Entry 1 ______________________________ Total: 100.00 KES ______________________________ Paid: 100.00 KES __________ Change: 0.00 KES Type: Cash Dispozitiv: MPESA # 2400748861 ',0) 08/11/2024 17:32:49.7760 533 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 08/11/2024 17:33:33.7133 759 ms. EXEC: insert into payReceipt (recTraUID,recPayUID,recYear,recDateTime,recText,recInvalid) VALUES (4733182671018840,5016066956624460,2024,'2024-11-08 17:33:32',' Date: 11/8/2024 5:33:32 PM Code: 456025368500327005012999 Entry Date: 11/8/2024 2:54:45 PM Plate: Class: Cars Park: The Mall Gate: Entry 2 ______________________________ Total: 100.00 KES ______________________________ Paid: 100.00 KES __________ Change: 0.00 KES Type: Cash Dispozitiv: MPESA # 2400748863 ',0) 08/11/2024 17:34:46.4127 519 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 08/11/2024 17:36:01.3816 539 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 08/11/2024 17:37:03.8052 1634 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/11/2024 17:38:34.1404 788 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/11/2024 17:39:44.1530 566 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/11/2024 17:41:36.3608 1778 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/11/2024 17:41:44.6373 699 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 08/11/2024 17:41:58.7287 769 ms. EXEC: update payReceipt set recCreation = '2024-11-08 17:41:57',recModify = '2024-11-08 17:41:57',recUseId=0,recStatus='V' where recId = 320609 08/11/2024 17:42:21.4868 913 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2024-11-08 17:42:20' where traUID = 5250529749760000 and traStatus='V' and traEnabled=1 08/11/2024 17:42:58.2053 567 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 08/11/2024 17:43:49.1192 505 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 1 08/11/2024 17:45:23.0268 853 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 08/11/2024 17:52:36.9628 1371 ms. EXEC: insert into movtransit (traUseId,traCreation,traStatus,traUID,traYear,traDateTime,traCode,traType,traClass,traIdTerminal,traDirection,traPlate,traEnabled,traDisableTime,traAreId,traNotes,traBadge,traTarId) VALUES (0,'2024-11-08 17:52:35','V',5003991452118910,2024,'2024-11-08 17:52:34','456026435400327005012999',1,2,16,'I','',1,0,1,'','',4) 08/11/2024 17:53:24.3864 936 ms. EXECSCALAR: select count(*) from information_schema.tables where table_schema= 'wisepark_0327' and table_name= 'payInvoiceFtp' nr: 1 08/11/2024 17:56:34.0148 504 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 08/11/2024 17:59:09.8736 571 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 08/11/2024 18:01:59.4255 2459 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/11/2024 18:02:22.8181 649 ms. EXEC: insert into payPayment (payCreation,payUseId,payStatus,payUID,payTraUID,payYear,payDateTime,payIdTerminal,payEnabled,payDisableTime,payTarId,payTimeLimit,payType,payCurrency,payAmount,payPayed,payChange,payCardType,payPAN,paySTAN,payIdEvent,payAmountCalc,payDiscountValue,payDiscount,payDiscountType,payVatPercent,payVatAmount) VALUES ('2024-11-08 18:02:22',0,'V',5008903106426620,5005933072672030,2024,'2024-11-08 18:02:22',18,1,0,4,'2024-11-08 18:17:22','C','KES',50,50,0,'','','',1,50,0,0,'',0,0) 08/11/2024 18:03:11.0923 782 ms. EXEC: insert into movtransit (traUseId,traCreation,traStatus,traUID,traYear,traDateTime,traCode,traType,traClass,traIdTerminal,traDirection,traPlate,traEnabled,traDisableTime,traAreId,traNotes,traBadge,traTarId) VALUES (0,'2024-11-08 18:03:10','V',5529895913147970,2024,'2024-11-08 18:03:09','456025398900327005012999',2,2,2,'O','',0,'2024-11-08 18:03:10',1,'','',0) 08/11/2024 18:03:34.5449 550 ms. OPEN: show columns from tabParameters where Field = 'parReentrySeconds' 08/11/2024 18:03:36.8714 1139 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 08/11/2024 18:03:38.3794 1124 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2024-11-08 18:03:37' where traUID = 4930216349665350 and traStatus='V' and traEnabled=1 08/11/2024 18:03:39.6803 842 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/11/2024 18:05:38.9878 655 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 1 08/11/2024 18:06:34.4157 517 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/11/2024 18:07:53.7486 1110 ms. EXEC: insert into movtransit (traUseId,traCreation,traStatus,traUID,traYear,traDateTime,traCode,traType,traClass,traIdTerminal,traDirection,traPlate,traEnabled,traDisableTime,traAreId,traNotes,traBadge,traTarId) VALUES (0,'2024-11-08 18:07:52','V',5317812433107290,2024,'2024-11-08 18:07:52','456025981800327005012999',2,2,2,'O','',0,'2024-11-08 18:07:52',1,'','',0) 08/11/2024 18:08:18.5691 570 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 08/11/2024 18:09:09.5871 616 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 08/11/2024 18:10:41.9146 672 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2024-11-08 18:10:41',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'; 08/11/2024 18:11:50.5523 556 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 08/11/2024 18:12:06.6720 640 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2024-11-08 18:12:05' where traUID = 5526869821431410 and traStatus='V' and traEnabled=1 08/11/2024 18:13:47.0569 689 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 08/11/2024 18:14:51.1806 863 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 08/11/2024 18:15:21.4238 576 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2024-11-08 18:15:20',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'; 08/11/2024 18:16:31.6856 628 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 08/11/2024 18:18:30.2366 1140 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/11/2024 18:21:02.2418 510 ms. EXEC: INSERT INTO movOperator (opeCreation,opeUseId,opeTerId,opeDateTime,opeCode,opeDescription) VALUES ('2024-11-08 18:21:01',0,16,'2024-11-08 18:21:01','','Unauthorized Transit Entry 2') 08/11/2024 18:21:22.7835 1067 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/11/2024 18:21:29.1788 549 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/11/2024 18:22:40.2661 1014 ms. EXEC: update payInventory set invCreation = '2024-11-08 18:22:39',invModify = '2024-11-08 18:22:39',invUseId=0,invStatus='V' where invId = 218050 08/11/2024 18:26:57.9177 737 ms. EXEC: UPDATE payInventory SET invType='N' WHERE invType<>'N' AND invValue IN (100,200,500) AND invDevice IN (42102,42101,42001); 08/11/2024 18:27:46.6412 1586 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 08/11/2024 18:31:03.1341 1716 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/11/2024 18:31:06.8686 1683 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/11/2024 18:32:42.2631 595 ms. EXEC: insert into payPayment (payCreation,payUseId,payStatus,payUID,payTraUID,payYear,payDateTime,payIdTerminal,payEnabled,payDisableTime,payTarId,payTimeLimit,payType,payCurrency,payAmount,payPayed,payChange,payCardType,payPAN,paySTAN,payIdEvent,payAmountCalc,payDiscountValue,payDiscount,payDiscountType,payVatPercent,payVatAmount) VALUES ('2024-11-08 18:32:41',0,'V',5032772798173750,5449492691029970,2024,'2024-11-08 18:32:41',18,1,0,4,'2024-11-08 18:47:41','C','KES',500,500,0,'','','',1,500,0,0,'',0,0) 08/11/2024 18:33:06.4082 1452 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/11/2024 18:37:07.5008 4432 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/11/2024 18:38:58.9331 574 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2024-11-08 18:38:58' where traUID = 4857269572130490 and traStatus='V' and traEnabled=1 08/11/2024 18:39:06.1379 635 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 08/11/2024 18:39:47.6745 593 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 1 OR lnsTerId=1) 08/11/2024 18:39:47.9057 582 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 08/11/2024 18:39:48.3099 866 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/11/2024 18:40:16.5668 536 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2024-11-08 18:40: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'; 08/11/2024 18:41:06.9673 505 ms. OPEN: select * from tabUserMessage where useMesDescr = 'msg_welcome' and (useLanCode = 'en-US' or mid(useLanCode,1,2) = 'en') 08/11/2024 18:41:07.7369 716 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 08/11/2024 18:50:31.1572 670 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 08/11/2024 18:54:27.6487 662 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/11/2024 18:56:07.5983 590 ms. EXEC: insert into payPayment (payCreation,payUseId,payStatus,payUID,payTraUID,payYear,payDateTime,payIdTerminal,payEnabled,payDisableTime,payTarId,payTimeLimit,payType,payCurrency,payAmount,payPayed,payChange,payCardType,payPAN,paySTAN,payIdEvent,payAmountCalc,payDiscountValue,payDiscount,payDiscountType,payVatPercent,payVatAmount) VALUES ('2024-11-08 18:56:06',0,'V',5444991470954220,4755042651606680,2024,'2024-11-08 18:56:06',3,1,0,4,'2024-11-08 19:11:06','C','KES',100,100,0,'',' ',' ',1,100,0,0,'',0,0) 08/11/2024 18:56:08.5679 792 ms. EXEC: insert into payReceipt (recTraUID,recPayUID,recYear,recDateTime,recText,recInvalid) VALUES (4755042651606680,5444991470954220,2024,'2024-11-08 18:56:07','---------------------------------- %The Mall P0006032390 End of payment ---------------------------------- POF Entry : 11/8/2024 5:36:52 PM Date : 11/8/2024 6:56:06 PM Code : 456026341200327005012999 Total : 100.00 KES VAT 16% : 13.79 KES ---------------------------------- Paid : 100.00 KES Coin changed : 0.00 KES Note changed : 0.00 KES',0) 08/11/2024 18:58:16.6102 508 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/11/2024 18:58:32.9201 553 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 08/11/2024 19:05:00.1941 643 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 08/11/2024 19:09:45.1769 695 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/11/2024 19:11:02.0371 1879 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/11/2024 19:11:24.2970 581 ms. OPEN: select * from payCurInventory where curTerId = 3 and curQuantity>0 and curType in ('C','N') order by curDevCode,curChannelId,curValue 08/11/2024 19:13:01.7819 582 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 08/11/2024 19:16:21.8262 609 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/11/2024 19:23:25.4083 606 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 08/11/2024 19:26:08.7892 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,'2024-11-08 19:26:08','V',5484306319084100,2024,'2024-11-08 19:26:07','456026996700327005012999',1,2,16,'I','',1,0,1,'','',4) 08/11/2024 19:28:59.9021 536 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 08/11/2024 19:31:21.7596 1478 ms. EXEC: insert into payPayment (payCreation,payUseId,payStatus,payUID,payTraUID,payYear,payDateTime,payIdTerminal,payEnabled,payDisableTime,payTarId,payTimeLimit,payType,payCurrency,payAmount,payPayed,payChange,payCardType,payPAN,paySTAN,payIdEvent,payAmountCalc,payDiscountValue,payDiscount,payDiscountType,payVatPercent,payVatAmount) VALUES ('2024-11-08 19:31:20',0,'V',5022120143334350,5010579084871920,2024,'2024-11-08 19:31:20',18,1,0,4,'2024-11-08 19:46:20','C','KES',50,50,0,'','','',1,50,0,0,'',0,0) 08/11/2024 19:31:56.4317 842 ms. EXECSCALAR: select count(*) from tabTerminalExtraMem where extStatus='V' and extTerId = 16 nr: 1 08/11/2024 19:32:13.7853 696 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/11/2024 19:33:45.7546 749 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 08/11/2024 19:33:47.0835 598 ms. EXEC: insert into paycash (casCreation,casModify,casUseId,casStatus,casUID,casTraUID,casYear,casDateTime,casIdTerminal,casCurrency,casNumber,casSingleAmount,casTotAmount,casType,casDescription) VALUES ('2024-11-08 19:33:46',0,0,'V',4815935509146800,4903594262086370,2024,'2024-11-08 19:33:46',3,'KES',1,100,100,'N',''); 08/11/2024 19:34:17.0404 646 ms. EXEC: update abbCards set carLastDate = '2024-11-08 19:34:16',carLastDirection='O' where carStatus='V' and carId = 13 08/11/2024 19:34:18.3022 912 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2024-11-08 19:34:17' where traUID = 4727676621846690 and traStatus='V' and traEnabled=1 08/11/2024 19:34:24.7055 751 ms. EXEC: UPDATE payInventory SET invType='N' WHERE invType<>'N' AND invValue IN (100,200,500) AND invDevice IN (42102,42101,42001); 08/11/2024 19:35:25.9543 1475 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/11/2024 19:37:31.6170 1331 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/11/2024 19:40:46.1006 537 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/11/2024 19:41:57.0889 1747 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/11/2024 19:42:16.0035 529 ms. EXECSCALAR: select count(*) from information_schema.tables where table_schema= 'wisepark_0327' and table_name= 'payInvoiceFtp' nr: 1 08/11/2024 19:42:16.1266 710 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 08/11/2024 19:43:36.4821 588 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 08/11/2024 19:45:18.0788 1247 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 08/11/2024 19:45:19.0424 890 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 08/11/2024 19:45:53.0290 637 ms. EXEC: insert into movtransit (traUseId,traCreation,traStatus,traUID,traYear,traDateTime,traCode,traType,traClass,traIdTerminal,traDirection,traPlate,traEnabled,traDisableTime,traAreId,traNotes,traBadge,traTarId) VALUES (0,'2024-11-08 19:45:52','V',4755542644397600,2024,'2024-11-08 19:45:51','456026631600327005012999',2,2,2,'O','',0,'2024-11-08 19:45:52',1,'','',0) 08/11/2024 19:45:59.4753 895 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 08/11/2024 19:48:12.6070 1033 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/11/2024 19:48:22.2024 768 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 08/11/2024 19:48:35.3812 728 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 1 OR lnsTerId=1) 08/11/2024 19:48:35.5023 768 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 16 OR lnsTerId=16) 08/11/2024 19:49:26.2931 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,'2024-11-08 19:49:25','V',5588261694460040,2024,'2024-11-08 19:49:23','456027136300327005012999',1,2,16,'I','',1,0,1,'','',4) 08/11/2024 19:49:27.0756 746 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 08/11/2024 19:49:43.6417 862 ms. EXEC: insert into movtransit (traUseId,traCreation,traStatus,traUID,traYear,traDateTime,traCode,traType,traClass,traIdTerminal,traDirection,traPlate,traEnabled,traDisableTime,traAreId,traNotes,traBadge,traTarId) VALUES (0,'2024-11-08 19:49:42','V',5475301317864550,2024,'2024-11-08 19:49:41','456027138100327005012999',1,2,16,'I','',1,0,1,'','',4) 08/11/2024 19:49:44.2791 632 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 08/11/2024 19:51:24.1536 523 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/11/2024 19:51:50.6192 590 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/11/2024 19:52:17.8194 501 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/11/2024 19:52:51.8671 554 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 08/11/2024 19:53:21.2106 562 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 2 and terStatus='V' 08/11/2024 19:54:56.3119 502 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/11/2024 19:55:31.6925 501 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/11/2024 19:58:30.3335 502 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/11/2024 19:58:43.3362 501 ms. OPEN: select * from tabArea where areStatus='V' and areEnabled = 1 AND areId = 1 08/11/2024 19:59:25.9095 971 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/11/2024 19:59:25.9796 921 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 2 08/11/2024 20:00:06.7497 615 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/11/2024 20:00:44.5399 725 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/11/2024 20:00:50.9812 949 ms. EXEC: insert into movtransit (traUseId,traCreation,traStatus,traUID,traYear,traDateTime,traCode,traType,traClass,traIdTerminal,traDirection,traPlate,traEnabled,traDisableTime,traAreId,traNotes,traBadge,traTarId) VALUES (0,'2024-11-08 20:00:50','V',4701565468309730,2024,'2024-11-08 20:00:49','456027204900327005012999',1,2,16,'I','',1,0,1,'','',4) 08/11/2024 20:01:02.4929 1206 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/11/2024 20:01:05.0646 1561 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/11/2024 20:02:21.2894 580 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 08/11/2024 20:02:51.3354 870 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/11/2024 20:03:44.6819 660 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/11/2024 20:03:52.3901 1179 ms. OPEN: select trauid from movtransit where traStatus='V' and traDirection='I' and traCode='456026670900327005012999' 08/11/2024 20:08:04.4650 612 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/11/2024 20:10:18.5523 1040 ms. EXEC: insert into movtransit (traUseId,traCreation,traStatus,traUID,traYear,traDateTime,traCode,traType,traClass,traIdTerminal,traDirection,traPlate,traEnabled,traDisableTime,traAreId,traNotes,traBadge,traTarId) VALUES (0,'2024-11-08 20:10:17','V',4630059817894930,2024,'2024-11-08 20:10:15','456026937300327005012999',2,2,2,'O','',0,'2024-11-08 20:10:17',1,'','',0) 08/11/2024 20:11:51.9405 610 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 3 and terStatus='V' 08/11/2024 20:14:08.2473 576 ms. EXEC: insert into movtransit (traUseId,traCreation,traStatus,traUID,traYear,traDateTime,traCode,traType,traClass,traIdTerminal,traDirection,traPlate,traEnabled,traDisableTime,traAreId,traNotes,traBadge,traTarId) VALUES (0,'2024-11-08 20:14:07','V',5052038452017340,2024,'2024-11-08 20:14:05','456027284500327005012999',1,2,16,'I','',1,0,1,'','',4) 08/11/2024 20:16:33.6622 979 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/11/2024 20:18:47.5524 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,'2024-11-08 20:18:46','V',5562664107437480,2024,'2024-11-08 20:18:45','456027124600327005012999',2,2,2,'O','',0,'2024-11-08 20:18:46',1,'','',0) 08/11/2024 20:18:48.3429 621 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2024-11-08 20:18:47' where traUID = 5030448856913200 and traStatus='V' and traEnabled=1 08/11/2024 20:18:49.7408 1355 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/11/2024 20:22:14.1610 568 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 08/11/2024 20:22:22.4285 650 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 08/11/2024 20:23:19.8187 1177 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 08/11/2024 20:25:13.4344 1162 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/11/2024 20:26:34.4974 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 ('2024-11-08 20:26:30',0,'V',5575511513636990,5000592745077450,2024,'2024-11-08 20:26:30',3,1,0,4,'2024-11-08 20:41:30','C','KES',50,100,50,'',' ',' ',1,50,0,0,'',0,0) 08/11/2024 20:26:35.8964 634 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 08/11/2024 20:27:52.5314 521 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/11/2024 20:28:12.1355 590 ms. EXEC: insert into movtransit (traUseId,traCreation,traStatus,traUID,traYear,traDateTime,traCode,traType,traClass,traIdTerminal,traDirection,traPlate,traEnabled,traDisableTime,traAreId,traNotes,traBadge,traTarId) VALUES (0,'2024-11-08 20:28:11','V',5363048744593420,2024,'2024-11-08 20:28:10','456026926500327005012999',2,2,2,'O','',0,'2024-11-08 20:28:11',1,'','',0) 08/11/2024 20:29:51.0954 786 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/11/2024 20:34:14.2267 580 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/11/2024 20:34:19.8244 550 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 08/11/2024 20:38:28.9524 535 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/11/2024 20:38:29.3877 703 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 08/11/2024 20:39:43.5190 1031 ms. EXEC: update tabTerminalReceipt set trcProgressive = 15824, trcLastPrinted = '2400415824', trcLastDate = '2024-11-08 20:39:42' where trcStatus='V' and trcTerId = 4 08/11/2024 20:42:49.1537 724 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 08/11/2024 20:43:22.7181 1249 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/11/2024 20:44:03.9365 640 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/11/2024 20:48:47.9817 672 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 08/11/2024 20:49:47.5734 622 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2024-11-08 20:49:46',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'; 08/11/2024 20:50:32.7115 767 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2024-11-08 20:50:31',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'; 08/11/2024 20:50:59.1721 525 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 08/11/2024 20:51:02.6785 715 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/11/2024 20:52:47.3682 1044 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2024-11-08 20:52:46' where payTraUID = 5333954563202080 and payStatus='V' and payEnabled=1 08/11/2024 20:53:48.3198 674 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/11/2024 20:54:03.2587 878 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 08/11/2024 20:55:02.7744 751 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/11/2024 21:01:21.3606 656 ms. EXEC: insert into movtransit (traUseId,traCreation,traStatus,traUID,traYear,traDateTime,traCode,traType,traClass,traIdTerminal,traDirection,traPlate,traEnabled,traDisableTime,traAreId,traNotes,traBadge,traTarId) VALUES (0,'2024-11-08 21:01:20','V',5467695493773130,2024,'2024-11-08 21:01:17','456027120600327005012999',2,2,2,'O','',0,'2024-11-08 21:01:20',1,'','',0) 08/11/2024 21:09:24.0011 853 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 08/11/2024 21:10:46.4220 951 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 08/11/2024 21:10:47.3566 696 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 08/11/2024 21:11:27.4784 678 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/11/2024 21:11:44.3486 530 ms. EXEC: update opeActivities set acvFstPayId = (case acvFstPayId when 0 then 368960 else acvFstPayId end),acvLstPayId = 368960 where acvSftId = 822 and acvCodeId = 3 08/11/2024 21:13:41.1964 797 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 1 08/11/2024 21:17:18.1309 647 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 08/11/2024 21:20:25.9851 576 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 08/11/2024 21:24:53.2171 1115 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/11/2024 21:24:56.1000 644 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/11/2024 21:28:27.1046 802 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2024-11-08 21:28: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'; 08/11/2024 21:31:42.3386 630 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 08/11/2024 21:35:34.4322 1281 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/11/2024 21:35:49.9856 594 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 08/11/2024 21:35:53.4299 813 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/11/2024 21:38:18.2634 646 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 08/11/2024 21:39:38.1966 701 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/11/2024 21:40:56.5438 1285 ms. EXEC: UPDATE payInventory SET invType='N' WHERE invType<>'N' AND invValue IN (100,200,500) AND invDevice IN (42102,42101,42001); 08/11/2024 21:44:04.1528 502 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 08/11/2024 21:44:35.7248 2112 ms. EXEC: update tabTerminalReceipt set trcProgressive = 15829, trcLastPrinted = '2400415829', trcLastDate = '2024-11-08 21:44:33' where trcStatus='V' and trcTerId = 4 08/11/2024 21:45:33.0920 1240 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2024-11-08 21:45:31' where traUID = 4701565468309730 and traStatus='V' and traEnabled=1 08/11/2024 21:46:38.2995 524 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/11/2024 21:49:08.2854 512 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 3 and terStatus='V' 08/11/2024 21:49:24.3311 1375 ms. EXEC: update tabTerminalReceipt set trcProgressive = 48904, trcLastPrinted = '2400748904', trcLastDate = '2024-11-08 21:49:22' where trcStatus='V' and trcTerId = 18 08/11/2024 21:56:24.5670 788 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2024-11-08 21:56:23' where payTraUID = 5358325864597000 and payStatus='V' and payEnabled=1 08/11/2024 22:00:40.8087 613 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/11/2024 22:02:36.0195 541 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2024-11-08 22:02:35' where traUID = 4860738354572820 and traStatus='V' and traEnabled=1 08/11/2024 22:03:38.9274 1296 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 08/11/2024 22:03:45.2496 910 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/11/2024 22:06:55.3622 522 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 08/11/2024 22:11:27.6396 651 ms. EXECSCALAR: select count(*) from information_schema.tables where table_schema= 'wisepark_0327' and table_name= 'payInvoiceFtp' nr: 1 08/11/2024 22:11:29.6059 735 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 08/11/2024 22:12:19.7353 593 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/11/2024 22:14:57.1141 1027 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 5 and terStatus='V' 08/11/2024 22:15:48.8146 596 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/11/2024 22:16:01.6341 1052 ms. EXEC: update tabTerminalReceipt set trcProgressive = 15831, trcLastPrinted = '2400415831', trcLastDate = '2024-11-08 22:16:00' where trcStatus='V' and trcTerId = 4 08/11/2024 22:16:03.4673 1829 ms. EXEC: insert into payReceipt (recTraUID,recPayUID,recYear,recDateTime,recText,recInvalid) VALUES (4809497377293510,4974446127411170,2024,'2024-11-08 22:16:01',' Date: 11/8/2024 10:13:34 PM Code: 456027637300327005012999 Entry Date: 11/8/2024 9:12:53 PM Plate: Class: Cars Park: The Mall Gate: Entry 2 ______________________________ Total: 150.00 KES ______________________________ Paid: 150.00 KES __________ Change: 0.00 KES Type: Credit Card Dispozitiv: Manual Cashier 1 # 2400415831 ',0) 08/11/2024 22:16:04.5951 929 ms. OPEN: select * from payCurInventory where curTerId = 4 and curQuantity>0 and curType in ('C','N') order by curDevCode,curChannelId,curValue 08/11/2024 22:19:06.0250 511 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/11/2024 22:21:04.9582 512 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 5 08/11/2024 22:21:34.1987 799 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 08/11/2024 22:21:36.5963 880 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/11/2024 22:22:59.5665 636 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 08/11/2024 22:24:23.7066 609 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 08/11/2024 22:24:32.2142 1240 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 08/11/2024 22:26:02.7956 520 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 08/11/2024 22:26:58.7128 2004 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/11/2024 22:28:34.8869 691 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 08/11/2024 22:28:55.1274 1387 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/11/2024 22:31:17.3491 549 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 08/11/2024 22:32:03.0696 593 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 08/11/2024 22:32:03.9101 807 ms. OPEN: select * from tabArea where areId = 1 and areStatus='V' and areEnabled = 1 08/11/2024 22:33:05.9955 637 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/11/2024 22:33:34.0172 704 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 08/11/2024 22:33:56.8664 701 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 08/11/2024 22:35:02.5692 624 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); (WAIT TIME 1 ms.) 08/11/2024 22:36:05.5481 750 ms. EXEC: insert into movOperator (opeCreation,opeTerId,opeUseId,opeDateTime,opeCode,opeDescription) VALUES ('2024-11-08 22:36:04',17,12,'2024-11-08 22:36:04','456027136300327005012999','Pagato (Contanti ) Biglietto ') 08/11/2024 22:37:19.8136 1071 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 08/11/2024 22:37:20.4360 608 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2024-11-08 22:37:19' where payTraUID = 5556374710262800 and payStatus='V' and payEnabled=1 08/11/2024 22:37:23.7082 615 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 08/11/2024 22:38:10.1461 683 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 08/11/2024 22:42:15.6386 580 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/11/2024 22:42:15.8808 841 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 08/11/2024 22:44:31.7083 519 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 08/11/2024 22:44:55.2700 740 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 7 08/11/2024 22:46:30.8597 632 ms. OPEN: select * from tabArea where areStatus='V' and areEnabled = 1 AND areId = 1 08/11/2024 22:48:39.1021 587 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 08/11/2024 22:49:56.8679 749 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2024-11-08 22:49:56' where payTraUID = 5513137115999280 and payStatus='V' and payEnabled=1 08/11/2024 22:51:51.5683 1364 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/11/2024 22:52:59.4855 829 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 08/11/2024 22:57:43.5027 662 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 08/11/2024 22:58:46.3546 578 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 08/11/2024 22:59:54.6911 587 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 08/11/2024 23:00:38.2592 562 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 16 OR lnsTerId=16) 08/11/2024 23:01:21.1968 895 ms. EXEC: insert into movtransit (traUseId,traCreation,traStatus,traUID,traYear,traDateTime,traCode,traType,traClass,traIdTerminal,traDirection,traPlate,traEnabled,traDisableTime,traAreId,traNotes,traBadge,traTarId) VALUES (0,'2024-11-08 23:01:20','V',4747102285618500,2024,'2024-11-08 23:01:19','456027004100327005012999',2,2,2,'O','',0,'2024-11-08 23:01:20',1,'','',0) 08/11/2024 23:04:41.3151 1979 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/11/2024 23:04:53.1620 617 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/11/2024 23:05:04.7026 668 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 08/11/2024 23:05:29.7263 735 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/11/2024 23:05:45.2887 577 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/11/2024 23:06:15.0825 648 ms. EXEC: insert into payReceipt (recTraUID,recPayUID,recYear,recDateTime,recText,recInvalid) VALUES (5433184040484200,5541652346807090,2024,'2024-11-08 23:06:14',' Data: 11/8/2024 11:04:18 PM Codice: 456027384300327005012999 Ingresso: 11/8/2024 8:30:43 PM Targa: Categoria: Cars Area: The Mall Varco: Entry 2 ______________________________ Da Pagare: 100.00 KES ______________________________ Pagato: 100.00 KES __________ Resto: 0.00 KES Tipo: Contanti Pagato su: Manual Cashier 2 # 2400607003 ',0) 08/11/2024 23:09:38.0958 658 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/11/2024 23:09:49.2462 518 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 08/11/2024 23:09:50.4990 1666 ms. EXECSCALAR: select count(*) from information_schema.tables where table_schema= 'wisepark_0327' and table_name= 'payInvoiceFtp' nr: 1 08/11/2024 23:09:50.6491 1366 ms. EXEC: UPDATE payInventory SET invType='N' WHERE invType<>'N' AND invValue IN (100,200,500) AND invDevice IN (42102,42101,42001); 08/11/2024 23:10:24.4947 666 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/11/2024 23:10:24.5387 877 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 2 OR lnsTerId=2) 08/11/2024 23:10:51.8089 665 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/11/2024 23:11:48.9429 1602 ms. EXEC: insert into movtransit (traUseId,traCreation,traStatus,traUID,traYear,traDateTime,traCode,traType,traClass,traIdTerminal,traDirection,traPlate,traEnabled,traDisableTime,traAreId,traNotes,traBadge,traTarId) VALUES (0,'2024-11-08 23:11:47','V',4977094263371740,2024,'2024-11-08 23:11:45','456027061100327005012999',2,2,2,'O','',0,'2024-11-08 23:11:47',1,'','',0) 08/11/2024 23:11:56.2638 789 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 08/11/2024 23:15:48.5746 534 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 08/11/2024 23:16:29.2987 586 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2024-11-08 23:16:28' where traUID = 4827252205483580 and traStatus='V' and traEnabled=1 08/11/2024 23:18:19.2720 545 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 08/11/2024 23:18:35.5158 644 ms. EXEC: update abbSubscriptions set subCredit = round(subCredit-0,5),subLastDebit = '2024-11-08 23:18:34' where subId = 43 08/11/2024 23:18:36.1212 603 ms. OPEN: show columns from abbPayment where Field = 'payCarId' 08/11/2024 23:18:36.6715 547 ms. EXEC: insert into abbPayment (payCreation,payCode,payAmount,payCredit,payPayUID,payCarId,payDateFrom,payDateTo) VALUES ('2024-11-08 23:18:36','0230003943530',0,0,5405275161631930,44,'0000-00-00 00:00:00','0000-00-00 00:00:00') 08/11/2024 23:18:38.3807 1531 ms. EXEC: insert into payPayment (payCreation,payUseId,payStatus,payUID,payTraUID,payYear,payDateTime,payIdTerminal,payEnabled,payDisableTime,payTarId,payTimeLimit,payType,payCurrency,payAmount,payPayed,payChange,payCardType,payPAN,paySTAN,payIdEvent,payVatPercent,payVatAmount) VALUES ('2024-11-08 23:18:36',0,'V',5405275161631930,5763623849685150,2024,'2024-11-08 23:18:36',2,1,0,-1,'2024-11-09 00:18:36','S','KES',0,0,0,'','','',3,0,0) 08/11/2024 23:18:39.9237 759 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2024-11-08 23:18:39' where payTraUID = 5763623849685150 and payStatus='V' and payEnabled=1 08/11/2024 23:18:43.1509 781 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 08/11/2024 23:21:06.8816 597 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 08/11/2024 23:21:07.1278 696 ms. EXECSCALAR: select count(*) from information_schema.tables where table_schema= 'wisepark_0327' and table_name= 'payInvoiceFtp' nr: 1 08/11/2024 23:22:03.1231 621 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 08/11/2024 23:26:08.0973 810 ms. EXEC: update abbCards set carLastDate = '2024-11-08 23:26:07',carLastDirection='I' where carStatus='V' and carId = 44 08/11/2024 23:26:08.2213 949 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 08/11/2024 23:26:17.7267 610 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 08/11/2024 23:26:20.9098 593 ms. EXECSCALAR: select count(*) from tabTerminalExtraMem where extStatus='V' and extTerId = 16 nr: 1 08/11/2024 23:26:22.4438 960 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2024-11-08 23:26:21',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 73 ms.) 08/11/2024 23:26:23.3664 918 ms. EXEC: update payInventory set invCreation = '2024-11-08 23:26:22',invModify = '2024-11-08 23:26:22',invUseId=0,invStatus='V' where invId = 218092 08/11/2024 23:26:49.2377 593 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/11/2024 23:27:15.2320 505 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 08/11/2024 23:27:56.4524 578 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 2 OR lnsTerId=2) 08/11/2024 23:28:04.4238 785 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2024-11-08 23:28:03' where traUID = 5288124780546420 and traStatus='V' and traEnabled=1 08/11/2024 23:28:09.9294 726 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 08/11/2024 23:32:55.3786 1250 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/11/2024 23:32:56.8275 1436 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 3 08/11/2024 23:33:51.5090 983 ms. OPEN: select * from tabTerminal where terId = 2 08/11/2024 23:33:54.8832 577 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 08/11/2024 23:42:18.0394 686 ms. EXEC: insert into paycash (casCreation,casModify,casUseId,casStatus,casUID,casTraUID,casYear,casDateTime,casIdTerminal,casCurrency,casNumber,casSingleAmount,casTotAmount,casType,casDescription) VALUES ('2024-11-08 23:42:17',0,0,'V',5321654422363380,5475301317864550,2024,'2024-11-08 23:42:17',3,'KES',1,200,200,'N',''); 08/11/2024 23:42:19.3393 1247 ms. EXEC: insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2024-11-08 23:42:17',3,42101,0,200,1,200,2,'I','N'); update payCurInventory set curQuantity=round(curQuantity+1,5),curAmount=round(curAmount+200,5) where curTerId = 3 and curDevCode = 42101 and curChannelId = 2 and curValue = 200 and curType = 'N';