25/11/2024 07:17:46.4195 988 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 25/11/2024 07:18:34.6374 850 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 25/11/2024 07:21:33.9631 613 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 25/11/2024 07:36:28.3156 702 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 25/11/2024 07:49:48.2457 567 ms. OPEN: show columns from tabArea where Field = 'areType' 25/11/2024 07:49:48.3498 655 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 25/11/2024 08:07:39.2209 674 ms. EXEC: insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2024-11-25 08:07:34',5,3,42101,0,50,12,600,1,'I','N'); update payCurInventory set curQuantity=round(curQuantity+12,5),curAmount=round(curAmount+600,5) where curTerId = 3 and curDevCode = 42101 and curChannelId = 1 and curValue = 50 and curType = 'N'; insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2024-11-25 08:07:34',5,3,42101,0,100,4,400,1,'I','N'); update payCurInventory set curQuantity=round(curQuantity+4,5),curAmount=round(curAmount+400,5) where curTerId = 3 and curDevCode = 42101 and curChannelId = 1 and curValue = 100 and curType = 'N'; update payCurInventory set curQuantity=0,curAmount=0 where curQuantity<0; 25/11/2024 08:34:24.8818 581 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 25/11/2024 08:46:45.8968 876 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 25/11/2024 08:57:28.2458 1430 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 25/11/2024 08:58:50.2068 708 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 25/11/2024 09:05:42.9286 520 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 25/11/2024 09:08:02.3232 615 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-25 09:08:01','V',5063912460886240,2024,'2024-11-25 09:08:00','456193288000327001012999',1,2,1,'I','',1,0,1,'','',4) 25/11/2024 09:17:31.3979 654 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 25/11/2024 09:35:08.8901 503 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 25/11/2024 09:45:08.7954 530 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 25/11/2024 09:47:58.4889 1230 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 25/11/2024 09:47:58.7150 836 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 25/11/2024 09:54:04.8926 559 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 25/11/2024 09:58:53.8504 527 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 25/11/2024 10:00:43.2988 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-25 10:00:42',0,'V',5484883283435350,5170206259789390,2024,'2024-11-25 10:00:42',18,1,0,4,'2024-11-25 10:15:42','C','KES',50,50,0,'','','',1,50,0,0,'',0,0) 25/11/2024 10:00:43.3388 540 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-25 10:00:42','V',5377202675634140,2024,'2024-11-25 10:00:42','456193604200327005012999',1,2,16,'I','',1,0,1,'','',4) 25/11/2024 10:01:28.4511 561 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 25/11/2024 10:07:13.6796 944 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 25/11/2024 10:07:21.5869 725 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2024-11-25 10:07:20' where traUID = 5254696790015720 and traStatus='V' and traEnabled=1 25/11/2024 10:07:38.4492 632 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2024-11-25 10:07:37' where traUID = 4989881852110240 and traStatus='V' and traEnabled=1 25/11/2024 10:09:36.8136 1236 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 25/11/2024 10:14:39.9829 2038 ms. EXEC: UPDATE payInventory SET invType='N' WHERE invType<>'N' AND invValue IN (100,200,500) AND invDevice IN (42102,42101,42001); 25/11/2024 10:14:45.6397 709 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 25/11/2024 10:25:21.7143 884 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 25/11/2024 10:27:36.0724 743 ms. EXECSCALAR: select count(*) from information_schema.tables where table_schema= 'wisepark_0327' and table_name= 'payInvoiceFtp' nr: 1 25/11/2024 10:31:14.9342 1080 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 25/11/2024 10:32:59.6394 509 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 25/11/2024 10:33:44.7347 567 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2024-11-25 10:33:44' where traUID = 5377202675634140 and traStatus='V' and traEnabled=1 25/11/2024 10:33:51.5462 663 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 25/11/2024 10:59:04.7151 642 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 25/11/2024 11:00:47.1558 1022 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-25 11:00:46','V',5432280628095630,2024,'2024-11-25 11:00:45','456193964500327005012999',1,2,16,'I','',1,0,1,'','',4) 25/11/2024 11:07:40.3569 671 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 25/11/2024 11:17:32.3859 575 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 25/11/2024 11:19:47.5986 1310 ms. EXEC: update payInventory set invCreation = '2024-11-25 11:19:46',invModify = '2024-11-25 11:19:46',invUseId=0,invStatus='V' where invId = 221268 25/11/2024 11:19:52.2487 633 ms. EXEC: UPDATE payInventory SET invType='N' WHERE invType<>'N' AND invValue IN (100,200,500) AND invDevice IN (42102,42101,42001); 25/11/2024 11:21:53.9754 615 ms. EXECSCALAR: select count(*) from information_schema.tables where table_schema= 'wisepark_0327' and table_name= 'payInvoiceFtp' nr: 1 (WAIT TIME 67 ms.) 25/11/2024 11:25:11.6409 551 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-25 11:25:11','V',5402571674574250,2024,'2024-11-25 11:25:10','456193954600327005012999',2,2,2,'O','',0,'2024-11-25 11:25:11',1,'','',0) 25/11/2024 11:26:02.8943 574 ms. EXEC: update opeActivities set acvFstPayId = (case acvFstPayId when 0 then 375032 else acvFstPayId end),acvLstPayId = 375032 where acvSftId = 829 and acvCodeId = 3 25/11/2024 11:28:17.7367 676 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 2 25/11/2024 11:30:18.0374 557 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 25/11/2024 11:34:37.8397 535 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 25/11/2024 11:35:52.8140 1081 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2024-11-25 11:35:51' where traUID = 4935180066049520 and traStatus='V' and traEnabled=1 25/11/2024 11:36:50.1364 914 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 25/11/2024 11:39:08.9305 739 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 25/11/2024 11:41:56.7080 1293 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 16 OR lnsTerId=16) 25/11/2024 11:42:53.6492 583 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 1 OR lnsTerId=1) 25/11/2024 11:42:53.6552 570 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 25/11/2024 11:51:14.2469 849 ms. EXEC: UPDATE payInventory SET invType='N' WHERE invType<>'N' AND invValue IN (100,200,500) AND invDevice IN (42102,42101,42001); 25/11/2024 11:51:26.9224 589 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 25/11/2024 11:55:42.9091 1105 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 25/11/2024 12:00:22.7768 1130 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 25/11/2024 12:01:30.4712 1407 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-25 12:01:29','V',5762730585595020,2024,'2024-11-25 12:01:27','456194212400327005012999',2,2,2,'O','',0,'2024-11-25 12:01:29',1,'','',0) 25/11/2024 12:01:31.0966 503 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 25/11/2024 12:04:35.7535 681 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 25/11/2024 12:07:02.0056 543 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 25/11/2024 12:08:19.0062 646 ms. EXEC: insert into payReceipt (recTraUID,recPayUID,recYear,recDateTime,recText,recInvalid) VALUES (4728802347759280,4893538354893900,2024,'2024-11-25 12:08:18','---------------------------------- %The Mall P0006032390 End of payment ---------------------------------- POF Entry : 11/25/2024 11:58:01 AM Date : 11/25/2024 12:08:16 PM Code : 456194308100327005012999 Total : 50.00 KES VAT 16% : 6.90 KES ---------------------------------- Paid : 100.00 KES Coin changed : 0.00 KES Note changed : 0.00 KES Not changed Note : 50.00 KES Coin : 0.00 KES Unavailable : 0.00 KES',0) 25/11/2024 12:14:14.1974 666 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 25/11/2024 12:14:37.8863 641 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-25 12:14:37','V',4656733357629070,2024,'2024-11-25 12:14:36','456194207700327001012999',2,2,2,'O','',0,'2024-11-25 12:14:37',1,'','',0) 25/11/2024 12:14:38.5267 591 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 25/11/2024 12:17:56.2033 958 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-25 12:17:55','V',4648447084143030,2024,'2024-11-25 12:17:54','456194345600327005012999',2,2,2,'O','',0,'2024-11-25 12:17:55',1,'','',0) 25/11/2024 12:19:04.3330 737 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 25/11/2024 12:24:00.9950 807 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 25/11/2024 12:29:08.0419 747 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2024-11-25 12:29:07' where payTraUID = 5530938146708570 and payStatus='V' and payEnabled=1 25/11/2024 12:32:38.4810 592 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 5 25/11/2024 12:32:38.6862 750 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 25/11/2024 12:38:56.0262 516 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 25/11/2024 12:38:59.3014 579 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 25/11/2024 12:41:13.4754 619 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 16 OR lnsTerId=16) 25/11/2024 12:43:57.2833 750 ms. EXEC: update tabTerminalReceipt set trcProgressive = 50950, trcLastPrinted = '2400750950', trcLastDate = '2024-11-25 12:43:56' where trcStatus='V' and trcTerId = 18 25/11/2024 12:45:54.8361 1064 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 2 OR lnsTerId=2) 25/11/2024 12:46:58.7059 520 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 25/11/2024 12:49:25.5704 635 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 25/11/2024 12:50:34.5247 690 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 25/11/2024 12:53:36.3776 539 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 25/11/2024 12:55:13.5888 619 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2024-11-25 12:55:12',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'; 25/11/2024 12:55:14.4124 822 ms. EXEC: update payInventory set invCreation = '2024-11-25 12:55:13',invModify = '2024-11-25 12:55:13',invUseId=0,invStatus='V' where invId = 221294 25/11/2024 12:55:16.0035 918 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 25/11/2024 12:55:16.0395 1455 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2024-11-25 12:55:14',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'; 25/11/2024 12:55:17.7906 1101 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 25/11/2024 12:55:35.4495 1981 ms. EXEC: update tabTerminalReceipt set trcProgressive = 7456, trcLastPrinted = '2400607456', trcLastDate = '2024-11-25 12:55:33' where trcStatus='V' and trcTerId = 17 25/11/2024 12:55:37.5129 780 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 25/11/2024 13:01:29.4349 702 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 25/11/2024 13:02:17.7393 747 ms. EXEC: UPDATE payInventory SET invType='N' WHERE invType<>'N' AND invValue IN (100,200,500) AND invDevice IN (42102,42101,42001); 25/11/2024 13:07:19.4747 725 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 2 and terStatus='V' 25/11/2024 13:07:47.8537 1801 ms. EXEC: UPDATE payInventory SET invType='N' WHERE invType<>'N' AND invValue IN (100,200,500) AND invDevice IN (42102,42101,42001); 25/11/2024 13:18:08.3899 539 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-25 13:18:07',0,'V',4629156523512350,5448777794787390,2024,'2024-11-25 13:18:07',18,1,0,4,'2024-11-25 13:33:07','C','KES',50,50,0,'','','',1,50,0,0,'',0,0) 25/11/2024 13:18:15.5240 671 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 25/11/2024 13:31:07.2563 551 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2024-11-25 13:31:06' where payTraUID = 4701280963114120 and payStatus='V' and payEnabled=1 25/11/2024 13:32:07.9214 518 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2024-11-25 13:32:07' where traUID = 5420779215237440 and traStatus='V' and traEnabled=1 25/11/2024 13:36:11.4908 835 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2024-11-25 13:36:10' where traUID = 5075713130897870 and traStatus='V' and traEnabled=1 25/11/2024 13:36:11.6118 559 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 25/11/2024 13:36:48.3739 766 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 25/11/2024 13:40:09.7019 997 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 25/11/2024 13:41:31.3358 749 ms. EXEC: insert into payReceipt (recTraUID,recPayUID,recYear,recDateTime,recText,recInvalid) VALUES (5009909957658500,5301405637772320,2024,'2024-11-25 13:41:30','---------------------------------- %The Mall P0006032390 End of payment ---------------------------------- POF Entry : 11/25/2024 1:35:04 PM Date : 11/25/2024 1:41:28 PM Code : 456194890400327005012999 Total : 50.00 KES VAT 16% : 6.90 KES ---------------------------------- Paid : 50.00 KES Coin changed : 0.00 KES Note changed : 0.00 KES',0) 25/11/2024 13:41:32.9088 604 ms. OPEN: select * from tabCurrency where curStatus='V' and curCode = 'KES' 25/11/2024 13:41:33.5343 614 ms. OPEN: select trauid from movtransit where traStatus='V' and traDirection='I' and traCode='456194890400327005012999' 25/11/2024 13:42:04.4850 541 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-25 13:42:03',0,'V',4651276291690970,5300412073248080,2024,'2024-11-25 13:42:03',18,1,0,4,'2024-11-25 13:57:03','C','KES',50,50,0,'','','',1,50,0,0,'',0,0) 25/11/2024 13:45:30.3271 541 ms. EXEC: UPDATE payInventory SET invType='N' WHERE invType<>'N' AND invValue IN (100,200,500) AND invDevice IN (42102,42101,42001); 25/11/2024 13:47:34.8756 1412 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-25 13:47:33','V',5506763719564680,2024,'2024-11-25 13:47:33','456194965300327001012999',1,2,1,'I','',1,0,1,'','',4) 25/11/2024 13:50:46.8103 1064 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 25/11/2024 14:06:22.6992 741 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 25/11/2024 14:06:24.0891 676 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 25/11/2024 14:13:57.3171 691 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 25/11/2024 14:13:58.7621 1412 ms. EXEC: UPDATE payInventory SET invType='N' WHERE invType<>'N' AND invValue IN (100,200,500) AND invDevice IN (42102,42101,42001); 25/11/2024 14:15:35.2008 536 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 25/11/2024 14:18:29.5557 981 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 25/11/2024 14:18:47.1715 789 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 25/11/2024 14:34:11.3924 671 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 25/11/2024 14:38:33.3633 783 ms. EXEC: update paycash set casCreation = '2024-11-25 14:38:32',casModify = '2024-11-25 14:38:32',casUseId=0,casStatus='V' where casId = 196713 25/11/2024 14:39:22.4520 580 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-25 14:37:00',12,'V',5225971744742450,5435704560337660,2024,'2024-11-25 14:37:00',17,1,0,4,'2024-11-25 14:52:00','C','KES',100,100,0,'','','',1,100,0,0,'',0,0) 25/11/2024 14:44:13.8195 620 ms. EXEC: update tabTerminalReceipt set trcProgressive = 50967, trcLastPrinted = '2400750967', trcLastDate = '2024-11-25 14:44:13' where trcStatus='V' and trcTerId = 18 25/11/2024 14:44:14.3619 539 ms. EXEC: insert into payReceipt (recTraUID,recPayUID,recYear,recDateTime,recText,recInvalid) VALUES (5123763332610530,5198714351043230,2024,'2024-11-25 14:44:13',' Date: 11/25/2024 2:44:13 PM Code: 456194777200327005012999 Entry Date: 11/25/2024 1:16:12 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 # 2400750967 ',0) 25/11/2024 14:45:21.8845 914 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 25/11/2024 14:46:05.1541 873 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 25/11/2024 14:47:41.8670 671 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 25/11/2024 14:49:50.3520 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-25 14:49:49','V',5079247960668370,2024,'2024-11-25 14:49:48','456195118300327005012999',2,2,2,'O','',0,'2024-11-25 14:49:49',1,'','',0) 25/11/2024 14:49:58.5514 618 ms. EXEC: insert into paycash (casCreation,casModify,casUseId,casStatus,casUID,casTraUID,casYear,casDateTime,casIdTerminal,casCurrency,casNumber,casSingleAmount,casTotAmount,casType,casDescription) VALUES ('2024-11-25 14:49:57',0,0,'V',5671155888179100,4766897480981210,2024,'2024-11-25 14:49:57',3,'KES',2,100,200,'N',''); 25/11/2024 14:51:44.0001 524 ms. EXEC: UPDATE payInventory SET invType='N' WHERE invType<>'N' AND invValue IN (100,200,500) AND invDevice IN (42102,42101,42001); 25/11/2024 14:54:34.9761 653 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2024-11-25 14:54:33' where traUID = 4996912121220450 and traStatus='V' and traEnabled=1 25/11/2024 14:54:35.9257 565 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 25/11/2024 15:10:14.0146 623 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2024-11-25 15:10:13' where payTraUID = 5238679546130430 and payStatus='V' and payEnabled=1 25/11/2024 15:12:35.1590 663 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 25/11/2024 15:16:44.3584 819 ms. EXEC: insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2024-11-25 15:16:43',3,42101,0,100,1,100,2,'I','N'); update payCurInventory set curQuantity=round(curQuantity+1,5),curAmount=round(curAmount+100,5) where curTerId = 3 and curDevCode = 42101 and curChannelId = 2 and curValue = 100 and curType = 'N'; 25/11/2024 15:18:02.9761 628 ms. EXECSCALAR: select count(*) from information_schema.tables where table_schema= 'wisepark_0327' and table_name= 'payInvoiceFtp' nr: 1 25/11/2024 15:19:57.2634 795 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 2 OR lnsTerId=2) 25/11/2024 15:20:00.1233 674 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2024-11-25 15:19:59' where traUID = 4629823030968080 and traStatus='V' and traEnabled=1 25/11/2024 15:20:01.2170 947 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-25 15:19:58',0,'V',5346256405610760,5373915062510510,2024,'2024-11-25 15:19:58',3,1,0,4,'2024-11-25 15:34:58','C','KES',100,500,400,'',' ',' ',1,100,0,0,'',0,0) 25/11/2024 15:22:03.9552 620 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 25/11/2024 15:22:30.9760 632 ms. EXEC: insert into paycash (casCreation,casModify,casUseId,casStatus,casUID,casTraUID,casYear,casDateTime,casIdTerminal,casCurrency,casNumber,casSingleAmount,casTotAmount,casType,casDescription) VALUES ('2024-11-25 15:22:30',0,0,'V',4970327035720870,5438195874275670,2024,'2024-11-25 15:22:30',3,'KES',1,50,50,'N',''); 25/11/2024 15:24:54.1459 1120 ms. EXEC: insert into payReceipt (recTraUID,recPayUID,recYear,recDateTime,recText,recInvalid) VALUES (4982467558436790,4864158184213400,2024,'2024-11-25 15:24:53','---------------------------------- %The Mall P0006032390 End of payment ---------------------------------- POF Entry : 11/25/2024 3:22:01 PM Date : 11/25/2024 3:24:51 PM Code : 456195532100327001012999 Total : 50.00 KES VAT 16% : 6.90 KES ---------------------------------- Paid : 50.00 KES Coin changed : 0.00 KES Note changed : 0.00 KES',0) 25/11/2024 15:25:11.3873 866 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 25/11/2024 15:29:00.6430 550 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-25 15:29:00','V',5247972716671350,2024,'2024-11-25 15:28:59','456195294900327005012999',2,2,2,'O','',0,'2024-11-25 15:29:00',1,'','',0) 25/11/2024 15:34:56.4385 582 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 25/11/2024 15:39:47.2029 928 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2024-11-25 15:39:46' where traUID = 4694725533429470 and traStatus='V' and traEnabled=1 25/11/2024 15:44:34.1280 854 ms. OPEN: select sum(casTotAmount) as vTot from movTransit inner join payCash on payCash.casTraUID = movTransit.traUID inner join tabTerminal on terId = casIdTerminal where traCode = '456174625400327005012999' and traStatus='V' and casStatus='V' and terType=3 and casTotAmount>0 25/11/2024 15:44:34.7974 605 ms. EXEC: update abbSubscriptions set subCredit = round(subCredit-0,5),subLastDebit = '2024-11-25 15:44:34' where subId = 13 25/11/2024 15:44:38.4228 582 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 25/11/2024 15:51:17.7147 586 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-25 15:51:17',0,'V',4703284663994730,4686131907564510,2024,'2024-11-25 15:51:17',18,1,0,4,'2024-11-25 16:06:17','C','KES',100,100,0,'','','',1,100,0,0,'',0,0) 25/11/2024 15:52:38.4515 728 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2024-11-25 15:52:37' where payTraUID = 5691265385410110 and payStatus='V' and payEnabled=1 25/11/2024 15:59:31.7404 505 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2024-11-25 15:59:31',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'; 25/11/2024 15:59:49.4711 655 ms. EXEC: INSERT INTO movOperator (opeCreation,opeUseId,opeTerId,opeDateTime,opeCode,opeDescription) VALUES ('2024-11-25 15:59:48',0,16,'2024-11-25 15:59:48','','Unauthorized Transit Entry 2') 25/11/2024 16:00:14.9410 1110 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 25/11/2024 16:01:02.3324 1054 ms. EXEC: update tabTerminalReceipt set trcProgressive = 16641, trcLastPrinted = '2400416641', trcLastDate = '2024-11-25 16:01:01' where trcStatus='V' and trcTerId = 4 25/11/2024 16:03:35.9392 501 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 3 25/11/2024 16:06:15.9904 831 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2024-11-25 16:06:15',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'; 25/11/2024 16:07:22.4863 1355 ms. EXEC: UPDATE payInventory SET invType='N' WHERE invType<>'N' AND invValue IN (100,200,500) AND invDevice IN (42102,42101,42001); 25/11/2024 16:10:34.6160 2380 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 25/11/2024 16:11:07.9084 1024 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 2 OR lnsTerId=2) 25/11/2024 16:11:07.9414 1037 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 25/11/2024 16:13:23.5026 559 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2024-11-25 16:13:22' where traUID = 5680424903890150 and traStatus='V' and traEnabled=1 25/11/2024 16:14:16.1549 581 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 25/11/2024 16:16:52.3742 1172 ms. EXEC: insert into paycash (casCreation,casModify,casUseId,casStatus,casUID,casTraUID,casYear,casDateTime,casIdTerminal,casCurrency,casNumber,casSingleAmount,casTotAmount,casType,casDescription) VALUES ('2024-11-25 16:16:51',0,0,'V',4846421689616410,5692248076177260,2024,'2024-11-25 16:16:51',3,'KES',1,50,50,'N',''); 25/11/2024 16:18:08.4257 981 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 2 OR lnsTerId=2) 25/11/2024 16:19:20.7515 799 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 25/11/2024 16:19:52.3630 520 ms. OPEN: select * from opeShifts where sftId = 818 and sftStatus = 'V' 25/11/2024 16:19:59.9831 751 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 25/11/2024 16:20:08.7589 668 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 2 OR lnsTerId=2) 25/11/2024 16:20:19.1648 1267 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 25/11/2024 16:21:04.8823 867 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 2 OR lnsTerId=2) 25/11/2024 16:42:03.9121 737 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 25/11/2024 16:43:30.7388 1092 ms. EXEC: update tabTerminalReceipt set trcProgressive = 16650, trcLastPrinted = '2400416650', trcLastDate = '2024-11-25 16:43:29' where trcStatus='V' and trcTerId = 4 25/11/2024 16:43:31.7445 737 ms. EXEC: insert into payReceipt (recTraUID,recPayUID,recYear,recDateTime,recText,recInvalid) VALUES (4964817353348520,5197149882065330,2024,'2024-11-25 16:43:31',' Date: 11/25/2024 4:40:33 PM Code: 456195718000327005012999 Entry Date: 11/25/2024 3:53:00 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 # 2400416650 ',0) 25/11/2024 16:43:34.5574 505 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 2 OR lnsTerId=2) 25/11/2024 16:44:58.7613 684 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 25/11/2024 16:58:46.3350 1479 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 25/11/2024 17:06:09.2154 817 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 25/11/2024 17:14:17.0840 831 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 25/11/2024 17:17:32.1436 605 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2024-11-25 17:17: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'; 25/11/2024 17:27:50.2139 562 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 25/11/2024 17:29:04.1841 553 ms. EXEC: INSERT INTO movOperator (opeCreation,opeUseId,opeTerId,opeDateTime,opeCode,opeDescription) VALUES ('2024-11-25 17:29:03',0,1,'2024-11-25 17:29:03','','Unauthorized Transit Entry 1') 25/11/2024 17:47:10.0887 1235 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 25/11/2024 17:51:16.1388 667 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2024-11-25 17:51:15' where payTraUID = 5143432471196600 and payStatus='V' and payEnabled=1 25/11/2024 17:51:16.8153 676 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2024-11-25 17:51:15' where traUID = 5143432471196600 and traStatus='V' and traEnabled=1 25/11/2024 17:54:51.6205 555 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 25/11/2024 18:04:59.4896 856 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 25/11/2024 18:05:31.9037 596 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 25/11/2024 18:09:21.5021 593 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 25/11/2024 18:18:11.8989 764 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 25/11/2024 18:19:26.4416 632 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 25/11/2024 18:20:10.9562 1050 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 25/11/2024 18:34:50.8398 917 ms. EXEC: UPDATE payInventory SET invType='N' WHERE invType<>'N' AND invValue IN (100,200,500) AND invDevice IN (42102,42101,42001); 25/11/2024 18:34:50.8408 837 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 25/11/2024 18:39:22.5179 1108 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 5 25/11/2024 18:45:56.5478 544 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 25/11/2024 18:46:55.5581 1043 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 25/11/2024 19:00:59.0649 1717 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 25/11/2024 19:00:59.0659 1807 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 25/11/2024 19:10:05.3833 684 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2024-11-25 19:10:04',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'; 25/11/2024 19:10:13.0684 1167 ms. EXECSCALAR: select count(*) from information_schema.tables where table_schema= 'wisepark_0327' and table_name= 'payInvoiceFtp' nr: 1 25/11/2024 19:15:18.1292 1457 ms. OPEN: select * from tabArea where areStatus='V' and areEnabled = 1 AND areId = 1 25/11/2024 19:19:39.4967 720 ms. EXEC: insert into abbPayment (payCreation,payCode,payAmount,payCredit,payPayUID,payCarId,payDateFrom,payDateTo) VALUES ('2024-11-25 19:19:38','0230003944064',0,0,5377022906345960,14,'0000-00-00 00:00:00','0000-00-00 00:00:00') 25/11/2024 19:26:54.0327 713 ms. EXECSCALAR: select count(*) from information_schema.tables where table_schema= 'wisepark_0327' and table_name= 'payInvoiceFtp' nr: 1 25/11/2024 19:30:07.6980 892 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 25/11/2024 19:31:46.8182 541 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 25/11/2024 19:46:14.4032 762 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 16 OR lnsTerId=16) 25/11/2024 19:51:30.4224 505 ms. OPEN: select * from tabCurrency where curStatus='V' and curCode = 'KES' 25/11/2024 19:52:12.3154 860 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 25/11/2024 19:53:11.3968 785 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 25/11/2024 19:53:13.4062 1018 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 25/11/2024 19:54:45.0314 521 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 25/11/2024 19:56:15.9742 780 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 2 and terStatus='V' 25/11/2024 20:00:31.2337 731 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-25 20:00:30','V',5564422095977820,2024,'2024-11-25 20:00:28','456197014300327005012999',2,2,2,'O','',0,'2024-11-25 20:00:30',1,'','',0) 25/11/2024 20:00:32.1483 567 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2024-11-25 20:00:31' where traUID = 5008882055540550 and traStatus='V' and traEnabled=1 25/11/2024 20:00:35.3445 1164 ms. EXEC: UPDATE payInventory SET invType='N' WHERE invType<>'N' AND invValue IN (100,200,500) AND invDevice IN (42102,42101,42001); 25/11/2024 20:06:00.4347 514 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-25 20:05:59','V',5297076911592580,2024,'2024-11-25 20:05:58','456197235800327001012999',1,2,1,'I','',1,0,1,'','0230004098566',157,0) 25/11/2024 20:06:56.3630 559 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 25/11/2024 20:08:42.9593 2161 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 25/11/2024 20:21:02.8082 710 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 25/11/2024 20:29:22.1539 721 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 25/11/2024 20:36:59.7357 899 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 2 OR lnsTerId=2) 25/11/2024 20:37:22.0957 833 ms. EXEC: insert into movtransit (traUseId,traCreation,traStatus,traUID,traYear,traDateTime,traCode,traType,traClass,traIdTerminal,traDirection,traPlate,traEnabled,traDisableTime,traAreId,traNotes,traBadge,traTarId) VALUES (0,'2024-11-25 20:37:21','V',5161579405882940,2024,'2024-11-25 20:37:20','456197201900327005012999',2,2,2,'O','',0,'2024-11-25 20:37:21',1,'','',0) 25/11/2024 20:37:27.1661 710 ms. EXECSCALAR: select count(*) from information_schema.tables where table_schema= 'wisepark_0327' and table_name= 'payInvoiceFtp' nr: 1 25/11/2024 20:37:27.2501 887 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 25/11/2024 20:39:39.2083 841 ms. EXEC: UPDATE payInventory SET invType='N' WHERE invType<>'N' AND invValue IN (100,200,500) AND invDevice IN (42102,42101,42001); 25/11/2024 20:40:17.1127 506 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-25 20:40:16','V',4871211247036640,2024,'2024-11-25 20:40:16','456197441600327001012999',1,2,1,'I','',1,0,1,'','',4) 25/11/2024 20:44:45.5238 971 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-25 20:44:43',0,'V',5203625858703570,4848702526744920,2024,'2024-11-25 20:44:43',3,1,0,4,'2024-11-25 20:59:43','C','KES',50,50,0,'',' ',' ',1,50,0,0,'',0,0) 25/11/2024 20:53:55.4736 1444 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 25/11/2024 20:55:46.3350 1155 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 25/11/2024 20:58:30.6464 531 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 25/11/2024 21:04:36.5481 707 ms. OPEN: select * from tabArea where areStatus='V' and areEnabled = 1 AND areId = 1 25/11/2024 21:05:39.7007 643 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 25/11/2024 21:20:08.0895 1925 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 25/11/2024 21:21:05.4876 881 ms. EXEC: UPDATE payInventory SET invType='N' WHERE invType<>'N' AND invValue IN (100,200,500) AND invDevice IN (42102,42101,42001); 25/11/2024 21:37:43.3390 743 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 25/11/2024 21:42:16.2349 549 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 25/11/2024 21:58:58.0601 1052 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 25/11/2024 22:24:03.7383 558 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 25/11/2024 22:30:53.3358 2060 ms. EXECSCALAR: select count(*) from information_schema.tables where table_schema= 'wisepark_0327' and table_name= 'payInvoiceFtp' nr: 1 25/11/2024 22:35:08.2203 724 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 25/11/2024 22:44:28.4862 941 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 25/11/2024 22:53:24.9739 568 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 2 OR lnsTerId=2) 25/11/2024 23:01:39.3157 924 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 25/11/2024 23:07:52.9897 1321 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 25/11/2024 23:11:43.2828 549 ms. EXEC: update tabTerminalReceipt set trcProgressive = 51018, trcLastPrinted = '2400751018', trcLastDate = '2024-11-25 23:11:42' where trcStatus='V' and trcTerId = 18 25/11/2024 23:15:26.4846 1219 ms. EXEC: update paycash set casCreation = '2024-11-25 23:15:25',casModify = '2024-11-25 23:15:25',casUseId=0,casStatus='V' where casId = 196794 25/11/2024 23:15:27.9156 1429 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2024-11-25 23:15:25',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'; 25/11/2024 23:15:29.3185 792 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 25/11/2024 23:21:44.0254 733 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 25/11/2024 23:27:25.5432 1579 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 25/11/2024 23:36:24.1616 1389 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 25/11/2024 23:40:03.2315 650 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 1 OR lnsTerId=1) (WAIT TIME 607 ms.) 25/11/2024 23:42:30.4612 1231 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 25/11/2024 23:50:44.7736 653 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 25/11/2024 23:52:07.9854 627 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1