25/12/2024 00:44:51.2361 556 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 25/12/2024 01:05:41.6677 607 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 25/12/2024 04:38:57.3496 639 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 25/12/2024 05:40:59.5521 797 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 25/12/2024 06:20:55.0327 791 ms. EXEC: update payReceipt set recCreation = '2024-12-25 06:20:54',recModify = '2024-12-25 06:20:54',recUseId=0,recStatus='V' where recId = 336185 25/12/2024 06:34:46.3252 744 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 25/12/2024 06:35:23.9460 738 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 25/12/2024 06:38:52.4127 534 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 25/12/2024 06:42:24.4599 1105 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 25/12/2024 06:46:36.4756 517 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 25/12/2024 06:47:38.7888 808 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 25/12/2024 06:50:06.5356 656 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 25/12/2024 07:02:58.4755 594 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 25/12/2024 07:45:12.0783 865 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 25/12/2024 07:52:37.7042 629 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 1 25/12/2024 07:54:44.9485 727 ms. EXEC: insert into payReceipt (recTraUID,recPayUID,recYear,recDateTime,recText,recInvalid) VALUES (5269024255247400,5455522851994670,2024,'2024-12-25 07:54:44',' Date: 12/25/2024 7:51:14 AM Code: 456492521900327005012999 Entry Date: 12/25/2024 7:00:19 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 # 2400418419 ',0) 25/12/2024 07:56:15.4002 1488 ms. EXEC: update payReceipt set recCreation = '2024-12-25 07:56:13',recModify = '2024-12-25 07:56:13',recUseId=0,recStatus='V' where recId = 336193 25/12/2024 08:11:54.1001 881 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 25/12/2024 08:15:55.8487 748 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2024-12-25 08:15:55' where traUID = 5186142940123070 and traStatus='V' and traEnabled=1 25/12/2024 08:22:43.9169 693 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 25/12/2024 08:23:01.6573 2101 ms. EXEC: insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2024-12-25 08:22:49',5,3,42101,0,50,-20,-1000,1,'O','N'); insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2024-12-25 08:22:49',5,3,42101,0,50,20,1000,2,'I','N'); insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2024-12-25 08:22:49',5,3,42101,0,100,-53,-5300,1,'O','N'); insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2024-12-25 08:22:49',5,3,42101,0,100,53,5300,2,'I','N'); insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2024-12-25 08:22:49',5,3,42101,0,200,-7,-1400,1,'O','N'); insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2024-12-25 08:22:49',5,3,42101,0,200,7,1400,2,'I','N'); insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2024-12-25 08:22:49',5,3,42101,0,500,-1,-500,1,'O','N'); insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2024-12-25 08:22:49',5,3,42101,0,500,1,500,2,'I','N'); insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2024-12-25 08:22:49',5,3,42101,1,0,0,0,1,'O',''); update payCurInventory set curQuantity=0,curAmount=0 where curQuantity<0; 25/12/2024 08:23:02.8991 532 ms. EXEC: insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2024-12-25 08:22:55',5,3,42101,0,50,-36,-1800,2,'O','N'); insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2024-12-25 08:22:55',5,3,42101,0,100,-62,-6200,2,'O','N'); insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2024-12-25 08:22:55',5,3,42101,0,200,-7,-1400,2,'O','N'); insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2024-12-25 08:22:55',5,3,42101,0,500,-1,-500,2,'O','N'); insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2024-12-25 08:22:55',5,3,42101,1,0,0,0,2,'O',''); update payCurInventory set curQuantity=0,curAmount=0 where curQuantity<0; 25/12/2024 08:23:04.1360 675 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 25/12/2024 08:23:04.1410 1227 ms. OPEN: select * from tabCurrency where curStatus='V' and curCode = 'KES' 25/12/2024 08:27:04.5617 1358 ms. EXEC: insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2024-12-25 08:26:57',5,3,42101,0,50,14,700,1,'I','N'); update payCurInventory set curQuantity=round(curQuantity+14,5),curAmount=round(curAmount+700,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-12-25 08:26:57',5,3,42101,0,100,3,300,1,'I','N'); update payCurInventory set curQuantity=round(curQuantity+3,5),curAmount=round(curAmount+300,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/12/2024 08:33:31.8748 619 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 25/12/2024 08:36:09.5452 843 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 25/12/2024 08:39:32.2447 546 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 25/12/2024 08:39:58.6159 707 ms. OPEN: select * from tabDevice where devId = 1 and devStatus = 'V' 25/12/2024 08:39:59.1272 504 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 25/12/2024 08:58:03.3321 506 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 25/12/2024 09:06:38.5210 1274 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 25/12/2024 09:17:09.5088 1099 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2024-12-25 09:17:08' where payTraUID = 4907518275916940 and payStatus='V' and payEnabled=1 25/12/2024 09:29:42.2621 614 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 25/12/2024 09:33:43.9301 788 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 25/12/2024 09:41:13.0354 973 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 25/12/2024 09:54:54.7035 1202 ms. EXEC: update tabTerminalReceipt set trcProgressive = 18422, trcLastPrinted = '2400418422', trcLastDate = '2024-12-25 09:54:53' where trcStatus='V' and trcTerId = 4 25/12/2024 09:55:44.6989 860 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 25/12/2024 09:56:08.2816 544 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 25/12/2024 10:01:31.7499 1171 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 25/12/2024 10:04:24.6728 511 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-12-25 10:04:24','V',5434684424293010,2024,'2024-12-25 10:04:22','456493626200327005012999',1,2,16,'I','',1,0,1,'','',4) 25/12/2024 10:06:58.7889 610 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 25/12/2024 10:07:31.9918 914 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 25/12/2024 10:08:48.2362 1673 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 25/12/2024 10:10:20.9807 653 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 25/12/2024 10:11:30.4754 782 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 25/12/2024 10:11:55.7273 768 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 25/12/2024 10:13:33.9129 581 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 5 and terStatus='V' 25/12/2024 10:14:15.1515 989 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-12-25 10:14:14','V',5567199346632600,2024,'2024-12-25 10:14:13','456493555000327005012999',2,2,2,'O','',0,'2024-12-25 10:14:14',1,'','',0) 25/12/2024 10:14:27.6708 757 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 25/12/2024 10:23:36.6523 1602 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 25/12/2024 10:24:01.1016 768 ms. EXEC: insert into movtransit (traUseId,traCreation,traStatus,traUID,traYear,traDateTime,traCode,traType,traClass,traIdTerminal,traDirection,traPlate,traEnabled,traDisableTime,traAreId,traNotes,traBadge,traTarId) VALUES (0,'2024-12-25 10:24:00','V',4937127742897080,2024,'2024-12-25 10:23:58','456493590300327005012999',2,2,2,'O','',0,'2024-12-25 10:24:00',1,'','',0) 25/12/2024 10:24:26.6547 1428 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 1 OR lnsTerId=1) 25/12/2024 10:24:49.0687 857 ms. EXEC: UPDATE payInventory SET invType='N' WHERE invType<>'N' AND invValue IN (100,200,500) AND invDevice IN (42102,42101,42001); 25/12/2024 10:26:25.7353 659 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 25/12/2024 10:33:04.1732 775 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 25/12/2024 10:35:10.4316 546 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 25/12/2024 10:39:40.3610 853 ms. EXEC: update abbSubscriptions set subCredit = round(subCredit-0,5),subLastDebit = '2024-12-25 10:39:39' where subId = 15 25/12/2024 10:39:44.6059 765 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 25/12/2024 11:02:27.9698 1391 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 25/12/2024 11:10:28.4503 926 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2024-12-25 11:10:27' where traUID = 5668743727568400 and traStatus='V' and traEnabled=1 25/12/2024 11:15:25.7926 1192 ms. EXEC: INSERT INTO movOperator (opeCreation,opeUseId,opeTerId,opeDateTime,opeCode,opeDescription) VALUES ('2024-12-25 11:15:24',0,1,'2024-12-25 11:15:24','','Manual Open Barrier Entry 1') 25/12/2024 11:19:34.3994 1625 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 25/12/2024 11:33:05.6169 1966 ms. OPEN: select count(payId) as Tot,0 as payUID,sum(payPayed) as payPayed,sum(payChange) as payChange,payAmount,traUIDGroup,traType,traClass,traIdTerminal,traDiscountValue,traDiscountType,traCarId,payIdEvent,payType,payCardType from payPayment LEFT join movtransit on trauid = payTraUID LEFT JOIN payReport ON repPayUID = payUID AND repStatus='V' where payStatus = 'V' and (payType='C' or payType='P') and payUseId = 6 and payIdEvent<90 and repPayUID IS NULL and (traCarId is null or traCarId=0 or traCarId in (select carId from abbCards inner join abbsubscriptions on subId= carSubId where carStatus='V' and subStatus='V' and subAbbType<>5)) group by traUIDGroup,payAmount,payIdEvent,payType,payCardType,traType,traIdTerminal,traDiscountValue,traDiscountType,traCarId order by traUIDGroup,payAmount, traType, traDiscountValue, traDiscountType 25/12/2024 11:33:55.8585 707 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 25/12/2024 11:34:01.4792 675 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 25/12/2024 11:35:56.6512 1068 ms. EXECSCALAR: select count(*) from information_schema.tables where table_schema= 'wisepark_0327' and table_name= 'payInvoiceFtp' nr: 1 25/12/2024 11:35:57.4407 590 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 25/12/2024 11:36:16.8227 617 ms. OPEN: select count(payId) as Tot,0 as payUID,sum(payPayed) as payPayed,sum(payChange) as payChange,payAmount,traUIDGroup,traType,traClass,traIdTerminal,traDiscountValue,traDiscountType,traCarId,payIdEvent,payType,payCardType from payPayment LEFT join movtransit on trauid = payTraUID LEFT JOIN payReport ON repPayUID = payUID AND repStatus='V' where payStatus = 'V' and (payType='C' or payType='P') and payUseId = 6 and payIdEvent<90 and repPayUID IS NULL and (traCarId is null or traCarId=0 or traCarId in (select carId from abbCards inner join abbsubscriptions on subId= carSubId where carStatus='V' and subStatus='V' and subAbbType<>5)) group by traUIDGroup,payAmount,payIdEvent,payType,payCardType,traType,traIdTerminal,traDiscountValue,traDiscountType,traCarId order by traUIDGroup,payAmount, traType, traDiscountValue, traDiscountType 25/12/2024 11:43:35.7151 896 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 1 25/12/2024 11:44:25.7215 1133 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 25/12/2024 11:57:23.8937 716 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-12-25 11:57:23','V',4728457281893920,2024,'2024-12-25 11:57:21','456494304100327005012999',1,2,16,'I','',1,0,1,'','',4) 25/12/2024 12:00:37.7042 562 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2024-12-25 12:00:37' where traUID = 4886795135964860 and traStatus='V' and traEnabled=1 25/12/2024 12:02:14.5185 1340 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 25/12/2024 12:08:11.1642 521 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 25/12/2024 12:08:40.5468 569 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 25/12/2024 12:14:57.2260 536 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 25/12/2024 12:16:12.2958 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,payVatPercent,payVatAmount) VALUES ('2024-12-25 12:16:11',0,'V',4949423821621770,5232186155978140,2024,'2024-12-25 12:16:11',2,1,0,-1,'2024-12-25 13:16:11','S','KES',0,0,0,'','','',3,0,0) 25/12/2024 12:19:24.2908 1492 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 25/12/2024 12:20:27.9344 736 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-12-25 12:20:27','V',4636556453221670,2024,'2024-12-25 12:20:26','456493976300327005012999',2,2,2,'O','',0,'2024-12-25 12:20:27',1,'','',0) 25/12/2024 12:20:44.1993 660 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 2 OR lnsTerId=2) 25/12/2024 12:23:28.0965 616 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 2 25/12/2024 12:24:06.8045 550 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 25/12/2024 12:29:17.3197 810 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 25/12/2024 12:33:25.8537 666 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 5 25/12/2024 12:38:52.9433 743 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 25/12/2024 12:41:36.8769 1711 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 25/12/2024 12:42:04.1361 705 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2024-12-25 12:42:03',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-12-25 12:42:03',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/12/2024 12:45:43.7495 534 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 25/12/2024 12:45:44.3008 523 ms. EXEC: UPDATE payInventory SET invType='N' WHERE invType<>'N' AND invValue IN (100,200,500) AND invDevice IN (42102,42101,42001); 25/12/2024 12:46:12.6198 1067 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 25/12/2024 12:47:47.5758 809 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 25/12/2024 12:48:02.0144 588 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 25/12/2024 12:49:36.2674 869 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 25/12/2024 12:49:42.5717 802 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 25/12/2024 12:49:42.6297 681 ms. EXEC: UPDATE payInventory SET invType='N' WHERE invType<>'N' AND invValue IN (100,200,500) AND invDevice IN (42102,42101,42001); 25/12/2024 12:51:49.2930 732 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 25/12/2024 12:51:54.4915 940 ms. OPEN: select devId from tabDevice where devStatus='V' and devCode = 10001 25/12/2024 12:52:26.1957 799 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2024-12-25 12:52:25',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/12/2024 12:54:19.1545 929 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 25/12/2024 12:57:59.0977 501 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 25/12/2024 13:03:11.3564 526 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 25/12/2024 13:06:21.5025 557 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 25/12/2024 13:06:35.1306 635 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 25/12/2024 13:07:53.7041 506 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 25/12/2024 13:08:05.6471 521 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 25/12/2024 13:08:08.8673 547 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 25/12/2024 13:22:51.7583 751 ms. EXEC: insert into movtransit (traUseId,traCreation,traStatus,traUID,traYear,traDateTime,traCode,traType,traClass,traIdTerminal,traDirection,traPlate,traEnabled,traDisableTime,traAreId,traNotes,traBadge,traTarId) VALUES (0,'2024-12-25 13:22:51','V',5463705639044590,2024,'2024-12-25 13:22:48','456494816800327005012999',1,2,16,'I','',1,0,1,'','',4) 25/12/2024 13:24:59.9763 536 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-12-25 13:24:59','V',5583548678768190,2024,'2024-12-25 13:24:58','456494640100327005012999',2,2,2,'O','',0,'2024-12-25 13:24:59',1,'','',0) 25/12/2024 13:25:01.1751 554 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2024-12-25 13:25:00' where traUID = 5734415278471230 and traStatus='V' and traEnabled=1 25/12/2024 13:25:09.0794 761 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 25/12/2024 13:31:17.1149 717 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-12-25 13:31:16','V',5602731536615060,2024,'2024-12-25 13:31:14','456494867400327005012999',1,2,16,'I','',1,0,1,'','',4) 25/12/2024 13:31:36.4208 548 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-12-25 13:31:35',0,'V',5724304863197800,4644573242378180,2024,'2024-12-25 13:31:35',18,1,0,4,'2024-12-25 13:46:35','C','KES',50,50,0,'','','',1,50,0,0,'',0,0) 25/12/2024 13:31:38.5913 1289 ms. EXEC: update payReceipt set recCreation = '2024-12-25 13:31:37',recModify = '2024-12-25 13:31:37',recUseId=0,recStatus='V' where recId = 336265 (WAIT TIME 38 ms.) 25/12/2024 13:32:28.7725 622 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 25/12/2024 13:34:46.6337 531 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 25/12/2024 13:36:05.5174 624 ms. EXEC: update tabTerminalReceipt set trcProgressive = 55122, trcLastPrinted = '2400755122', trcLastDate = '2024-12-25 13:36:04' where trcStatus='V' and trcTerId = 18 25/12/2024 13:36:40.3977 515 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 25/12/2024 13:37:25.1586 556 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 25/12/2024 13:37:32.2414 1372 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 25/12/2024 13:38:04.7731 1042 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 25/12/2024 13:44:10.9432 983 ms. EXEC: insert into movOperator (opeCreation,opeTerId,opeUseId,opeDateTime,opeCode,opeDescription) VALUES ('2024-12-25 13:44:09',4,6,'2024-12-25 13:44:09','456494702300327005012999','Payed (Credit Card ) Ticket ') 25/12/2024 13:45:29.1524 2507 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 25/12/2024 13:45:32.4025 2782 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-12-25 13:45:29','V',5719101637676600,2024,'2024-12-25 13:45:27','456494761700327005012999',2,2,2,'O','',0,'2024-12-25 13:45:29',1,'','',0) 25/12/2024 13:45:33.0410 632 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 25/12/2024 13:45:33.0490 548 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-12-25 13:45:32','V',5563722156927500,2024,'2024-12-25 13:45:28','456494952800327005012999',1,2,16,'I','',1,0,1,'','',4) 25/12/2024 13:46:47.7402 578 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-12-25 13:46:47',0,'V',4873379507100660,5463705639044590,2024,'2024-12-25 13:46:47',18,1,0,4,'2024-12-25 14:01:47','C','KES',50,50,0,'','','',1,50,0,0,'',0,0) 25/12/2024 13:46:48.8830 1026 ms. EXEC: update tabTerminalReceipt set trcProgressive = 55125, trcLastPrinted = '2400755125', trcLastDate = '2024-12-25 13:46:47' where trcStatus='V' and trcTerId = 18 25/12/2024 13:51:29.6909 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-12-25 13:51:29','V',5132724848850740,2024,'2024-12-25 13:51:27','456494988700327005012999',1,2,16,'I','',1,0,1,'','',4) 25/12/2024 13:51:32.8080 3097 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 25/12/2024 13:54:36.2126 594 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 25/12/2024 14:04:16.7516 1197 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 25/12/2024 14:05:10.8898 595 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 25/12/2024 14:06:19.8699 573 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 25/12/2024 14:23:24.7452 1045 ms. EXEC: insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2024-12-25 14:23:23',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-12-25 14:23:23',3,42101,0,50,1,50,2,'I','N'); update payCurInventory set curQuantity=round(curQuantity+1,5),curAmount=round(curAmount+50,5) where curTerId = 3 and curDevCode = 42101 and curChannelId = 2 and curValue = 50 and curType = 'N'; 25/12/2024 14:24:05.1803 886 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-12-25 14:24:04','V',4634616142895370,2024,'2024-12-25 14:24:03','456494983300327005012999',2,2,2,'O','',0,'2024-12-25 14:24:04',1,'','',0) 25/12/2024 14:24:06.7813 1020 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2024-12-25 14:24:05' where traUID = 5461914011575840 and traStatus='V' and traEnabled=1 25/12/2024 14:34:42.5320 1464 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 25/12/2024 14:36:29.6911 549 ms. OPEN: select * from tabArea where areStatus='V' and areEnabled = 1 AND areId = 1 25/12/2024 14:43:32.5661 669 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 25/12/2024 14:53:43.6878 897 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 25/12/2024 14:55:23.8818 1185 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 25/12/2024 14:55:24.6713 543 ms. EXEC: UPDATE payInventory SET invType='N' WHERE invType<>'N' AND invValue IN (100,200,500) AND invDevice IN (42102,42101,42001); 25/12/2024 14:55:25.4098 738 ms. EXECSCALAR: select count(*) from payInventory where invChannel=2 and invCode=2 and invDevice=41101 nr: 0 25/12/2024 15:00:41.8793 562 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 25/12/2024 15:00:44.0768 1370 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 25/12/2024 15:01:01.5385 811 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2024-12-25 15:01:00' where traUID = 4958614462600860 and traStatus='V' and traEnabled=1 25/12/2024 15:05:23.4082 628 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 25/12/2024 15:05:24.3848 947 ms. EXEC: UPDATE payInventory SET invType='N' WHERE invType<>'N' AND invValue IN (100,200,500) AND invDevice IN (42102,42101,42001); 25/12/2024 15:06:58.9496 727 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 25/12/2024 15:10:37.8543 675 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 25/12/2024 15:17:01.6655 512 ms. EXEC: update paycash set casCreation = '2024-12-25 15:17:01',casModify = '2024-12-25 15:17:01',casUseId=0,casStatus='V' where casId = 202003 25/12/2024 15:17:03.0834 1417 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2024-12-25 15:17:01',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/12/2024 15:25:05.7215 506 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 25/12/2024 15:31:08.6608 511 ms. EXEC: insert into movOperator (opeCreation,opeTerId,opeUseId,opeDateTime,opeCode,opeDescription) VALUES ('2024-12-25 15:31:08',4,6,'2024-12-25 15:31:08','456494988700327005012999','Payed (Credit Card ) Ticket ') 25/12/2024 15:31:09.3983 705 ms. EXEC: update opeActivities set acvFstPayId = (case acvFstPayId when 0 then 387288 else acvFstPayId end),acvLstPayId = 387288 where acvSftId = 869 and acvCodeId = 3 25/12/2024 15:33:27.2734 634 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 25/12/2024 15:34:01.1320 626 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 25/12/2024 15:45:41.4383 870 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-12-25 15:45:40','V',5099591300101780,2024,'2024-12-25 15:45:39','456494635700327005012999',2,2,2,'O','',0,'2024-12-25 15:45:40',1,'','',0) 25/12/2024 15:49:55.5633 576 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 25/12/2024 15:53:56.8300 614 ms. EXEC: UPDATE payInventory SET invType='N' WHERE invType<>'N' AND invValue IN (100,200,500) AND invDevice IN (42102,42101,42001); 25/12/2024 15:55:55.1130 1104 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 25/12/2024 15:56:11.5710 585 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 25/12/2024 16:02:28.2431 1499 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 25/12/2024 16:07:32.1253 623 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 25/12/2024 16:09:19.9174 733 ms. EXEC: UPDATE payCash SET casType='N' WHERE casType<>'N' AND ABS(casSingleAmount) IN (100,200,500); 25/12/2024 16:13:17.6526 677 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 25/12/2024 16:19:05.4533 810 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 25/12/2024 16:23:25.7934 781 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 25/12/2024 16:26:23.7593 607 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 25/12/2024 16:27:28.2885 599 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 25/12/2024 16:36:36.0033 675 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 25/12/2024 16:45:59.7738 547 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 25/12/2024 16:50:20.2995 509 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 25/12/2024 16:51:04.9573 578 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 25/12/2024 16:54:19.4167 658 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 25/12/2024 17:51:48.3149 776 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 25/12/2024 18:11:23.8984 805 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 25/12/2024 18:12:17.5603 924 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 25/12/2024 18:16:58.1078 798 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 25/12/2024 18:17:55.0479 706 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 25/12/2024 18:18:53.6200 1285 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 25/12/2024 18:29:17.8965 651 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 25/12/2024 18:30:25.1214 1273 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 25/12/2024 18:32:46.6529 704 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 25/12/2024 18:32:56.0181 942 ms. EXEC: UPDATE payInventory SET invType='N' WHERE invType<>'N' AND invValue IN (100,200,500) AND invDevice IN (42102,42101,42001); 25/12/2024 18:38:57.7577 762 ms. EXECSCALAR: select count(*) from information_schema.tables where table_schema= 'wisepark_0327' and table_name= 'payInvoiceFtp' nr: 1 25/12/2024 18:38:57.7588 707 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 25/12/2024 18:41:12.5159 1423 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 25/12/2024 18:41:21.3148 591 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 2 25/12/2024 18:41:58.3135 1189 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 2 and terStatus='V' 25/12/2024 18:47:06.6280 518 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 25/12/2024 18:49:09.4823 1311 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 25/12/2024 18:53:36.7371 663 ms. EXEC: update payReceipt set recCreation = '2024-12-25 18:53:36',recModify = '2024-12-25 18:53:36',recUseId=0,recStatus='V' where recId = 336342 25/12/2024 18:55:49.3344 1012 ms. EXEC: update tabTerminalReceipt set trcProgressive = 55156, trcLastPrinted = '2400755156', trcLastDate = '2024-12-25 18:55:48' where trcStatus='V' and trcTerId = 18 25/12/2024 18:55:57.3077 1555 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 2 and terStatus='V' 25/12/2024 18:58:46.1955 603 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2024-12-25 18:58:45' where traUID = 4899888818310650 and traStatus='V' and traEnabled=1 25/12/2024 18:58:47.3783 1440 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 25/12/2024 18:58:53.8086 583 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 25/12/2024 18:59:12.1959 606 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-12-25 18:59:11','V',5371196577166730,2024,'2024-12-25 18:58:55','456496833500327005031999',1,2,16,'I','',1,0,1,'','',4) 25/12/2024 19:02:49.6999 767 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 25/12/2024 19:04:41.4486 838 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 25/12/2024 19:16:04.1094 1461 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 16 OR lnsTerId=16) 25/12/2024 19:20:23.3687 699 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 25/12/2024 19:23:50.3822 1835 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 (WAIT TIME 45 ms.) 25/12/2024 19:27:59.6561 514 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 16 OR lnsTerId=16) 25/12/2024 19:37:17.1919 713 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 25/12/2024 19:37:45.3447 698 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 5 25/12/2024 19:38:48.0526 632 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 25/12/2024 19:39:51.8222 834 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-12-25 19:39:50','V',5687999914122220,2024,'2024-12-25 19:39:49','456497078900327005012999',1,2,16,'I','',1,0,1,'','',4) 25/12/2024 19:41:12.4812 2383 ms. EXEC: update tabTerminalReceipt set trcProgressive = 55157, trcLastPrinted = '2400755157', trcLastDate = '2024-12-25 19:41:10' where trcStatus='V' and trcTerId = 18 25/12/2024 19:43:03.2622 543 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2024-12-25 19:43:02' where payTraUID = 5262295790473780 and payStatus='V' and payEnabled=1 25/12/2024 19:55:11.1116 1282 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 25/12/2024 20:00:56.4584 620 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 25/12/2024 20:14:40.5725 701 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2024-12-25 20:14:39' where payTraUID = 5497153559940050 and payStatus='V' and payEnabled=1 25/12/2024 20:16:39.9644 685 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 25/12/2024 20:18:55.6931 1257 ms. EXEC: UPDATE payCash SET casType='N' WHERE casType<>'N' AND ABS(casSingleAmount) IN (100,200,500); 25/12/2024 20:22:16.2672 779 ms. OPEN: select * from tabArea where areStatus='V' and areEnabled = 1 AND areId = 1 25/12/2024 20:57:54.9301 632 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 25/12/2024 21:01:44.9389 639 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 25/12/2024 21:05:32.7890 1056 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 25/12/2024 21:09:50.2271 602 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 25/12/2024 21:10:21.9773 685 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2024-12-25 21:10:21',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/12/2024 21:11:26.5876 515 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 25/12/2024 21:11:39.5142 514 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 25/12/2024 21:12:31.3719 2224 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2024-12-25 21:12:28' where traUID = 5699078142876060 and traStatus='V' and traEnabled=1 25/12/2024 21:12:35.1144 522 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 25/12/2024 21:17:22.6502 758 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 25/12/2024 21:20:32.3752 533 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 25/12/2024 21:21:23.6990 664 ms. EXEC: insert into payReceipt (recTraUID,recPayUID,recYear,recDateTime,recText,recInvalid) VALUES (5194862910038850,5602435417312980,2024,'2024-12-25 21:21:23','---------------------------------- %The Mall P0006032390 End of payment ---------------------------------- POF Entry : 12/25/2024 9:11:45 PM Date : 12/25/2024 9:21:21 PM Code : 456497630500327001012999 Total : 50.00 KES VAT 16% : 6.90 KES ---------------------------------- Paid : 100.00 KES Coin changed : 0.00 KES Note changed : 50.00 KES',0) 25/12/2024 21:21:25.1840 623 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2024-12-25 21:21:24',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/12/2024 21:22:14.5788 685 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-12-25 21:22:13','V',5016980439731140,2024,'2024-12-25 21:22:10','456497693000327001012999',1,2,1,'I','',1,0,1,'','0230003944081',15,0) 25/12/2024 21:24:24.2231 1092 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 25/12/2024 21:28:46.4114 505 ms. EXEC: update abbCards set carLastDate = '2024-12-25 21:28:45',carLastDirection='O' where carStatus='V' and carId = 15 25/12/2024 21:28:47.2359 676 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 25/12/2024 21:28:50.8804 1218 ms. EXEC: UPDATE payInventory SET invType='N' WHERE invType<>'N' AND invValue IN (100,200,500) AND invDevice IN (42102,42101,42001); 25/12/2024 21:32:19.5549 1257 ms. EXEC: update payInventory set invCreation = '2024-12-25 21:32:18',invModify = '2024-12-25 21:32:18',invUseId=0,invStatus='V' where invId = 227686 25/12/2024 21:33:46.4039 1167 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 25/12/2024 21:47:03.5629 771 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 25/12/2024 21:47:05.0079 984 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 25/12/2024 21:50:28.5138 1265 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 25/12/2024 21:56:10.7466 1057 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 25/12/2024 22:00:25.1912 1208 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 25/12/2024 22:06:16.5741 757 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 25/12/2024 22:12:53.7530 564 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 3 25/12/2024 22:13:18.4405 641 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 25/12/2024 22:27:03.2309 1659 ms. EXEC: INSERT INTO movOperator (opeCreation,opeUseId,opeTerId,opeDateTime,opeCode,opeDescription) VALUES ('2024-12-25 22:27:01',1,2,'2024-12-25 22:27:01','','Send command to entry/exit units: Command OPEN on Device Exit 1 ') 25/12/2024 22:31:01.8344 565 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 25/12/2024 22:42:05.2775 1196 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 25/12/2024 22:49:32.0607 788 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 25/12/2024 22:53:15.1054 614 ms. EXEC: UPDATE payInventory SET invType='N' WHERE invType<>'N' AND invValue IN (100,200,500) AND invDevice IN (42102,42101,42001); 25/12/2024 22:54:50.9899 1021 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 25/12/2024 22:55:38.2436 694 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 25/12/2024 22:55:39.9908 1335 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 25/12/2024 23:11:15.9218 1383 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 25/12/2024 23:27:05.4611 719 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 25/12/2024 23:31:14.5295 1561 ms. OPEN: select trauid from movtransit where traStatus='V' and traDirection='I' and traCode='456498070200327005012999' 25/12/2024 23:35:17.9703 1585 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 25/12/2024 23:35:23.6390 1043 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 25/12/2024 23:38:08.7970 702 ms. EXECSCALAR: select count(0) as vTot from tabParameters where parPlateReading<>0 nr: 0 25/12/2024 23:44:14.1686 590 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1