28/12/2024 00:02:31.1775 1808 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 28/12/2024 00:13:59.2618 594 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 5 and terStatus='V' 28/12/2024 00:35:11.9514 544 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 28/12/2024 00:35:15.0524 1651 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 28/12/2024 00:35:33.1305 941 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 28/12/2024 00:37:23.6004 619 ms. EXECSCALAR: select count(*) from information_schema.tables where table_schema= 'wisepark_0327' and table_name= 'payInvoiceFtp' nr: 1 28/12/2024 00:37:37.4466 1067 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 28/12/2024 00:43:12.4210 514 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 4 OR lnsTerId=4) 28/12/2024 00:49:41.1102 703 ms. EXECSCALAR: select count(0) as vTot from tabParameters where parPlateReading<>0 nr: 0 28/12/2024 00:57:09.1048 1165 ms. EXEC: update paycash set casCreation = '2024-12-28 00:57:07',casModify = '2024-12-28 00:57:07',casUseId=0,casStatus='V' where casId = 202242 28/12/2024 00:57:09.6081 503 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2024-12-28 00:57:07',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'; 28/12/2024 00:59:21.0899 597 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 28/12/2024 00:59:21.7843 660 ms. EXEC: UPDATE payInventory SET invType='N' WHERE invType<>'N' AND invValue IN (100,200,500) AND invDevice IN (42102,42101,42001); 28/12/2024 01:07:42.1222 947 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 28/12/2024 01:13:35.6826 725 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 28/12/2024 01:19:39.9290 702 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 28/12/2024 01:24:01.4155 620 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 5 and terStatus='V' 28/12/2024 01:52:33.3231 962 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-28 01:52:30',0,'V',4935963836962640,5332484596106440,2024,'2024-12-28 01:52:30',3,1,0,4,'2024-12-28 02:07:30','C','KES',100,500,400,'',' ',' ',1,100,0,0,'',0,0) 28/12/2024 02:05:29.8250 574 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 28/12/2024 02:36:29.2194 872 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 28/12/2024 02:43:46.7523 1158 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 28/12/2024 02:52:20.7844 572 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 28/12/2024 02:58:49.5194 1200 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 28/12/2024 03:15:03.7002 579 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 28/12/2024 03:18:07.3674 1069 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 28/12/2024 03:18:41.9115 733 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2024-12-28 03:18:41' where payTraUID = 5516796498402800 and payStatus='V' and payEnabled=1 28/12/2024 03:21:01.7323 784 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 28/12/2024 03:21:15.5045 604 ms. EXEC: UPDATE payInventory SET invType='N' WHERE invType<>'N' AND invValue IN (100,200,500) AND invDevice IN (42102,42101,42001); 28/12/2024 03:21:15.9713 798 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 28/12/2024 03:22:09.9695 509 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 5 28/12/2024 03:29:56.5848 602 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 28/12/2024 03:29:57.0531 623 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 28/12/2024 03:38:08.8263 739 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 28/12/2024 03:38:14.5781 988 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 28/12/2024 03:44:44.9766 520 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 28/12/2024 03:44:47.0864 878 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 28/12/2024 03:48:31.1841 556 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 28/12/2024 03:48:31.1961 659 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 2 OR lnsTerId=2) 28/12/2024 03:48:32.9643 509 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 28/12/2024 04:13:46.2630 763 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-28 04:13:45',0,'V',5544709091493220,5667251388176580,2024,'2024-12-28 04:13:45',18,1,0,4,'2024-12-28 04:28:45','C','KES',100,100,0,'','','',1,100,0,0,'',0,0) 28/12/2024 04:17:39.0739 515 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 28/12/2024 04:28:22.8624 730 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 28/12/2024 04:56:07.2051 644 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 28/12/2024 04:58:16.2572 792 ms. EXEC: UPDATE payInventory SET invType='N' WHERE invType<>'N' AND invValue IN (100,200,500) AND invDevice IN (42102,42101,42001); 28/12/2024 04:58:21.5888 546 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 28/12/2024 04:58:21.7379 576 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 2 28/12/2024 04:59:36.4028 640 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 28/12/2024 05:02:13.9621 925 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 28/12/2024 05:03:39.9766 536 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 28/12/2024 05:04:59.1956 540 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 28/12/2024 06:00:00.1004 794 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 28/12/2024 06:19:05.9981 640 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 28/12/2024 06:20:14.4899 565 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 3 28/12/2024 06:20:52.3712 589 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 28/12/2024 06:23:53.1801 1643 ms. EXEC: UPDATE payInventory SET invType='N' WHERE invType<>'N' AND invValue IN (100,200,500) AND invDevice IN (42102,42101,42001); 28/12/2024 06:28:01.5671 612 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 28/12/2024 06:34:12.7465 539 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 28/12/2024 06:59:38.4418 1757 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 28/12/2024 07:05:44.3233 1115 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 28/12/2024 07:05:58.0735 1216 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-28 07:05:56',0,'V',5722134073265620,5186206848443720,2024,'2024-12-28 07:05:56',18,1,0,4,'2024-12-28 07:20:56','C','KES',50,50,0,'','','',1,50,0,0,'',0,0) 28/12/2024 07:07:00.2875 518 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 28/12/2024 07:11:35.6879 546 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 28/12/2024 07:25:26.8866 790 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 28/12/2024 07:29:44.9375 887 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 28/12/2024 07:35:45.5961 1147 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 28/12/2024 07:44:05.7218 931 ms. EXEC: update payInventory set invCreation = '2024-12-28 07:44:04',invModify = '2024-12-28 07:44:04',invUseId=0,invStatus='V' where invId = 227959 28/12/2024 07:57:00.0896 547 ms. EXEC: insert into payReceipt (recTraUID,recPayUID,recYear,recDateTime,recText,recInvalid) VALUES (4809884560887740,4788992610229460,2024,'2024-12-28 07:56:59','---------------------------------- %The Mall P0006032390 End of payment ---------------------------------- POF Entry : 12/28/2024 7:24:27 AM Date : 12/28/2024 7:56:58 AM Code : 456522666700327005012999 Total : 50.00 KES VAT 16% : 6.90 KES ---------------------------------- Paid : 100.00 KES Coin changed : 0.00 KES Note changed : 50.00 KES',0) 28/12/2024 07:58:46.5431 796 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2024-12-28 07:58:45' where payTraUID = 4809884560887740 and payStatus='V' and payEnabled=1 28/12/2024 08:02:05.6217 575 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 28/12/2024 08:03:00.9967 675 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 28/12/2024 08:03:37.8113 561 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 28/12/2024 08:13:46.3431 518 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 28/12/2024 08:14:59.8012 518 ms. EXEC: insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2024-12-28 08:14:48',5,3,42101,0,50,-9,-450,1,'O','N'); insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2024-12-28 08:14:48',5,3,42101,0,50,9,450,2,'I','N'); insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2024-12-28 08:14:48',5,3,42101,0,100,-28,-2800,1,'O','N'); insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2024-12-28 08:14:48',5,3,42101,0,100,28,2800,2,'I','N'); insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2024-12-28 08:14:48',5,3,42101,0,200,-3,-600,1,'O','N'); insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2024-12-28 08:14:48',5,3,42101,0,200,3,600,2,'I','N'); insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2024-12-28 08:14:48',5,3,42101,0,500,-3,-1500,1,'O','N'); insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2024-12-28 08:14:48',5,3,42101,0,500,3,1500,2,'I','N'); insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2024-12-28 08:14:48',5,3,42101,0,1000,-1,-1000,1,'O','N'); insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2024-12-28 08:14:48',5,3,42101,0,1000,1,1000,2,'I','N'); insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2024-12-28 08:14:48',5,3,42101,1,0,0,0,1,'O',''); update payCurInventory set curQuantity=0,curAmount=0 where curQuantity<0; 28/12/2024 08:19:44.1378 617 ms. EXEC: insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2024-12-28 08:19:40',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-28 08:19:40',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; 28/12/2024 08:34:18.4067 765 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 28/12/2024 08:34:28.2212 669 ms. EXEC: insert into movOperator (opeCreation,opeTerId,opeUseId,opeDateTime,opeCode,opeDescription) VALUES ('2024-12-28 08:34:27',4,6,'2024-12-28 08:34:27','456522998900327005012999','Payed (Credit Card ) Ticket ') 28/12/2024 08:46:54.7827 561 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2024-12-28 08:46:54',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'; 28/12/2024 08:47:15.9139 605 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 28/12/2024 09:12:02.5812 647 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2024-12-28 09:12:01' where traUID = 4763025166324920 and traStatus='V' and traEnabled=1 28/12/2024 09:12:08.8334 739 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 28/12/2024 09:13:46.2287 818 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 28/12/2024 09:20:18.9703 567 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 28/12/2024 09:21:36.4441 557 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2024-12-28 09:21:35' where traUID = 5005456461816680 and traStatus='V' and traEnabled=1 28/12/2024 09:21:50.2303 692 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 2 OR lnsTerId=2) 28/12/2024 09:21:50.2343 688 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 28/12/2024 09:26:44.4337 1120 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 28/12/2024 09:41:06.3793 791 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2024-12-28 09:41:05' where payTraUID = 4992040753622300 and payStatus='V' and payEnabled=1 28/12/2024 09:41:12.5254 720 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 28/12/2024 09:41:13.5280 972 ms. EXEC: UPDATE payInventory SET invType='N' WHERE invType<>'N' AND invValue IN (100,200,500) AND invDevice IN (42102,42101,42001); 28/12/2024 09:43:07.8965 778 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 3 28/12/2024 10:34:27.4165 790 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 28/12/2024 10:35:00.6628 670 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-28 10:34:59','V',4965361942320020,2024,'2024-12-28 10:34:58','456523606800327005012999',2,2,2,'O','',0,'2024-12-28 10:34:59',1,'','',0) 28/12/2024 10:35:01.7015 615 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2024-12-28 10:35:00' where traUID = 5249084322958690 and traStatus='V' and traEnabled=1 28/12/2024 10:35:22.0941 680 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2024-12-28 10:35:21' where payTraUID = 5698980413417520 and payStatus='V' and payEnabled=1 28/12/2024 10:35:23.0377 884 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2024-12-28 10:35:21' where traUID = 5698980413417520 and traStatus='V' and traEnabled=1 28/12/2024 10:35:25.6415 1412 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 28/12/2024 10:40:59.0190 970 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-28 10:40:58','V',5564812776366490,2024,'2024-12-28 10:40:57','456523845700327005012999',1,2,16,'I','',1,0,1,'','',4) 28/12/2024 10:41:21.6651 931 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2024-12-28 10:41:20' where traUID = 4764011336271750 and traStatus='V' and traEnabled=1 28/12/2024 10:43:06.0688 548 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2024-12-28 10:43:05' where traUID = 5627759580709910 and traStatus='V' and traEnabled=1 28/12/2024 10:56:03.5599 517 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 28/12/2024 10:56:18.7914 690 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 28/12/2024 10:57:51.7193 837 ms. EXECSCALAR: select count(*) from information_schema.tables where table_schema= 'wisepark_0327' and table_name= 'payInvoiceFtp' nr: 1 28/12/2024 10:57:52.2326 512 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 28/12/2024 10:57:53.1102 776 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 28/12/2024 10:59:41.1934 517 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 28/12/2024 11:03:09.6296 1247 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 28/12/2024 11:07:52.1308 684 ms. OPEN: select * from tabUserMessage where useMesDescr = 'msg_welcome' and (useLanCode = 'it-IT' or mid(useLanCode,1,2) = 'it') 28/12/2024 11:11:12.1375 566 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 28/12/2024 11:12:00.0585 609 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2024-12-28 11:11:59' where traUID = 5742206789625170 and traStatus='V' and traEnabled=1 28/12/2024 11:15:53.4002 1007 ms. EXEC: insert into movOperator (opeCreation,opeTerId,opeUseId,opeDateTime,opeCode,opeDescription) VALUES ('2024-12-28 11:15:52',4,6,'2024-12-28 11:15:52','456523957900327005012999','Payed (Credit Card ) Ticket ') 28/12/2024 11:19:10.1780 1314 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-28 11:19:08','V',5611864661180700,2024,'2024-12-28 11:19:08','456523957900327005012999',2,2,2,'O','',0,'2024-12-28 11:19:08',1,'','',0) 28/12/2024 11:19:47.4529 594 ms. EXECSCALAR: select count(*) from information_schema.tables where table_schema= 'wisepark_0327' and table_name= 'payInvoiceFtp' nr: 1 28/12/2024 11:19:48.0043 502 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 28/12/2024 11:21:25.8477 622 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 28/12/2024 11:22:32.7274 608 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-28 11:22:32','V',5066315322799150,2024,'2024-12-28 11:22:31','456523952600327005012999',2,2,2,'O','',0,'2024-12-28 11:22:32',1,'','',0) 28/12/2024 11:25:48.3231 684 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 2 OR lnsTerId=2) 28/12/2024 11:26:38.3699 12912 ms. OPEN: SELECT COUNT(traId) as Total,terId,terDescription FROM movTransit INNER JOIN tabterminal on traIdTerminal = terId AND terType IN (1,3,19,4) LEFT JOIN payPayment on payTrauid = traUID WHERE traCreation>'2022-08-24 13:51:00' AND traStatus='V' and traDirection='I' AND payTraUID IS NULL GROUP BY traIdTerminal 28/12/2024 11:27:45.0945 541 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 2 28/12/2024 11:29:47.0280 533 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 28/12/2024 11:30:05.3172 865 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-28 11:30:04','V',4808819739748110,2024,'2024-12-28 11:30:02','456524140200327005012999',1,2,16,'I','',1,0,1,'','0230004101179',8,0) 28/12/2024 11:33:20.5253 1930 ms. OPEN: select * from movtransit where traUID = 5568802004627310 and traStatus='V' 28/12/2024 11:33:20.8726 2327 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 28/12/2024 11:33:21.2368 3079 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 28/12/2024 11:37:18.1873 552 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 28/12/2024 11:38:44.2454 507 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2024-12-28 11:38:43',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'; 28/12/2024 11:38:48.4452 511 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 28/12/2024 11:38:53.7258 1031 ms. EXEC: UPDATE payInventory SET invType='N' WHERE invType<>'N' AND invValue IN (100,200,500) AND invDevice IN (42102,42101,42001); 28/12/2024 11:40:35.5280 605 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 28/12/2024 11:41:15.0284 576 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 28/12/2024 11:41:17.5991 727 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 28/12/2024 11:41:39.5848 584 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2024-12-28 11:41:38',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'; 28/12/2024 11:41:40.1092 524 ms. EXEC: update payInventory set invCreation = '2024-12-28 11:41:39',invModify = '2024-12-28 11:41:39',invUseId=0,invStatus='V' where invId = 228016 28/12/2024 11:43:24.4405 1369 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 28/12/2024 11:45:02.9774 595 ms. EXEC: update opeActivities set acvFstPayId = (case acvFstPayId when 0 then 387921 else acvFstPayId end),acvLstPayId = 387921 where acvSftId = 870 and acvCodeId = 3 28/12/2024 11:46:35.7454 796 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 28/12/2024 11:46:49.3295 529 ms. EXECSCALAR: select count(*) from information_schema.tables where table_schema= 'wisepark_0327' and table_name= 'payInvoiceFtp' nr: 1 28/12/2024 11:46:50.1310 512 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 28/12/2024 11:48:27.8624 1579 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-28 11:48:26','V',5366866658773750,2024,'2024-12-28 11:48:25','456524250500327005012999',1,2,16,'I','',1,0,1,'','',4) 28/12/2024 11:49:07.8111 651 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 28/12/2024 11:50:11.6228 1070 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 28/12/2024 11:50:16.8412 639 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2024-12-28 11:50:16' where payTraUID = 4808819739748110 and payStatus='V' and payEnabled=1 28/12/2024 11:52:28.7204 1095 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 28/12/2024 11:57:02.0352 715 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 28/12/2024 11:59:38.1476 812 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 28/12/2024 12:02:41.6553 728 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 28/12/2024 12:04:26.2091 1058 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 28/12/2024 12:04:38.3983 555 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 28/12/2024 12:05:13.9601 712 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 28/12/2024 12:09:08.2297 1589 ms. EXEC: insert into movOperator (opeCreation,opeTerId,opeUseId,opeDateTime,opeCode,opeDescription) VALUES ('2024-12-28 12:09:06',17,1,'2024-12-28 12:09:06','456524254100327005012999','Pagato (Contanti ) Biglietto ') 28/12/2024 12:10:37.1201 820 ms. EXEC: UPDATE payInventory SET invType='N' WHERE invType<>'N' AND invValue IN (100,200,500) AND invDevice IN (42102,42101,42001); 28/12/2024 12:18:04.6177 508 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-28 12:18:04',0,'V',4983887899159360,4846960839220870,2024,'2024-12-28 12:18:04',18,1,0,4,'2024-12-28 12:33:04','C','KES',50,50,0,'','','',1,50,0,0,'',0,0) 28/12/2024 12:18:10.9170 524 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2024-12-28 12:18:10' where traUID = 5464199278773480 and traStatus='V' and traEnabled=1 28/12/2024 12:19:54.6903 582 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 28/12/2024 12:19:55.3848 547 ms. EXEC: UPDATE payInventory SET invType='N' WHERE invType<>'N' AND invValue IN (100,200,500) AND invDevice IN (42102,42101,42001); 28/12/2024 12:27:30.1896 662 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 28/12/2024 12:27:59.7584 641 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 28/12/2024 12:32:07.9385 673 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 5 and terStatus='V' 28/12/2024 12:35:04.0485 1076 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-28 12:35:02',0,'V',4778647431396690,5720768940383580,2024,'2024-12-28 12:35:02',18,1,0,4,'2024-12-28 12:50:02','C','KES',50,50,0,'','','',1,50,0,0,'',0,0) 28/12/2024 12:48:12.2713 618 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 28/12/2024 12:49:28.9536 892 ms. EXEC: update abbCards set carLastDate = '2024-12-28 12:49:28',carLastDirection='I' where carStatus='V' and carId = 14 28/12/2024 12:49:32.8882 627 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 28/12/2024 12:55:11.2525 557 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-28 12:55:10','V',5231228238439070,2024,'2024-12-28 12:55:06','456524183400327005012999',2,2,2,'O','',0,'2024-12-28 12:55:10',1,'','0230003944081',15,0) 28/12/2024 12:55:12.6625 672 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2024-12-28 12:55:11' where traUID = 5138948378924390 and traStatus='V' and traEnabled=1 28/12/2024 13:05:49.4734 1340 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-28 13:05:48',0,'V',5737376509842020,5339714685550830,2024,'2024-12-28 13:05:48',2,1,0,-1,'2024-12-28 14:05:48','S','KES',0,0,0,'','','',3,0,0) 28/12/2024 13:10:36.8434 1156 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 28/12/2024 13:10:58.8521 561 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 28/12/2024 13:11:21.5673 632 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-28 13:11:20',0,'V',4694523550941970,4999702290154870,2024,'2024-12-28 13:11:20',18,1,0,4,'2024-12-28 13:26:20','C','KES',50,50,0,'','','',1,50,0,0,'',0,0) 28/12/2024 13:12:33.0291 1069 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2024-12-28 13:12:31' where payTraUID = 5292157455452330 and payStatus='V' and payEnabled=1 28/12/2024 13:14:07.6453 678 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 28/12/2024 13:27:37.8924 615 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2024-12-28 13:27:37' where payTraUID = 4848321661022690 and payStatus='V' and payEnabled=1 28/12/2024 13:32:47.9889 553 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 28/12/2024 13:32:48.1250 653 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 28/12/2024 13:33:35.0833 1457 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 28/12/2024 13:38:48.4848 714 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 28/12/2024 13:39:39.5660 980 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 28/12/2024 13:41:12.6482 554 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 28/12/2024 13:43:14.8539 553 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 28/12/2024 13:43:42.2722 733 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 28/12/2024 13:44:01.9854 511 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 28/12/2024 13:46:12.1572 844 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 28/12/2024 13:50:03.2026 1802 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 28/12/2024 13:51:19.1355 696 ms. EXEC: insert into payReceipt (recTraUID,recPayUID,recYear,recDateTime,recText,recInvalid) VALUES (4925352549233110,5157783165133300,2024,'2024-12-28 13:51:18',' Date: 12/28/2024 1:51:18 PM Code: 456524541800327005012999 Entry Date: 12/28/2024 12:36:58 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 # 2400755408 ',0) 28/12/2024 13:53:43.5141 814 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 2 28/12/2024 13:53:46.5262 1223 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 28/12/2024 13:54:05.5329 553 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 28/12/2024 14:00:02.9430 546 ms. OPEN: show columns from tabParameters where Field = 'parUseCulture' 28/12/2024 14:00:03.7575 692 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 28/12/2024 14:02:49.6102 512 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 28/12/2024 14:02:49.7993 534 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 28/12/2024 14:05:13.8297 526 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 28/12/2024 14:10:55.0808 548 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 28/12/2024 14:15:25.3877 1520 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 28/12/2024 14:15:27.0868 684 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-28 14:15:26','V',5630317158941480,2024,'2024-12-28 14:15:24','456525132400327005012999',1,2,16,'I','',1,0,1,'','0560008304916',190,0) 28/12/2024 14:16:36.4788 514 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 16 OR lnsTerId=16) 28/12/2024 14:25:25.5265 2749 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-28 14:25:22','V',5490604073594600,2024,'2024-12-28 14:25:21','456525192100327005012999',1,2,16,'I','',1,0,1,'','',4) 28/12/2024 14:25:27.5288 1926 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 28/12/2024 14:28:08.3205 784 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 28/12/2024 14:28:35.2025 710 ms. OPEN: select traId,traDateTime,traEnabled,traDisableTime,traCode,traBadge,traCarId,traAreId,traIdTerminal from movtransit where traStatus='V' and traDirection = 'O' and traCarId = 15 order by traDateTime desc,traId desc 28/12/2024 14:30:10.5302 1363 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 28/12/2024 14:32:38.3450 545 ms. EXEC: update opeActivities set acvFstPayId = (case acvFstPayId when 0 then 387998 else acvFstPayId end),acvLstPayId = 387998 where acvSftId = 870 and acvCodeId = 3 28/12/2024 14:34:47.5054 1529 ms. EXECSCALAR: select count(*) from information_schema.tables where table_schema= 'wisepark_0327' and table_name= 'payInvoiceFtp' nr: 1 28/12/2024 14:34:48.6491 519 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 4 28/12/2024 14:34:48.7912 678 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 28/12/2024 14:41:29.2499 641 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 28/12/2024 14:41:36.1986 939 ms. EXEC: insert into abbPayment (payCreation,payCode,payAmount,payCredit,payPayUID,payCarId,payDateFrom,payDateTo) VALUES ('2024-12-28 14:41:35','0230003944064',0,0,5236673619328150,14,'0000-00-00 00:00:00','0000-00-00 00:00:00') 28/12/2024 14:42:41.5438 564 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 5 28/12/2024 14:49:32.7355 584 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2024-12-28 14:49:32' where payTraUID = 5266522133410470 and payStatus='V' and payEnabled=1 28/12/2024 14:55:10.6427 693 ms. EXECSCALAR: select count(*) from tabTerminalExtraMem where extStatus='V' and extTerId = 16 nr: 1 28/12/2024 15:00:15.1814 511 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 28/12/2024 15:01:12.8080 648 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 28/12/2024 15:04:10.1630 541 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 28/12/2024 15:07:39.6860 2057 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 2 28/12/2024 15:12:13.8703 510 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 28/12/2024 15:13:11.3517 933 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 28/12/2024 15:14:06.6917 786 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 2 28/12/2024 15:17:44.1913 591 ms. OPEN: select * from movTransit where traStatus='V' and traEnabled = 1 and traCode = '456525349800327005012999' 28/12/2024 15:19:34.6760 847 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 28/12/2024 15:30:46.6502 1086 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2024-12-28 15:30:45' where traUID = 5048554126791430 and traStatus='V' and traEnabled=1 28/12/2024 15:30:51.4084 627 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 28/12/2024 15:30:51.6976 750 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 5 28/12/2024 15:30:52.4211 1015 ms. EXECSCALAR: select count(*) from information_schema.tables where table_schema= 'wisepark_0327' and table_name= 'payInvoiceFtp' nr: 1 28/12/2024 15:31:13.9154 805 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 28/12/2024 15:43:09.7056 520 ms. EXEC: update tabTerminalReceipt set trcProgressive = 55428, trcLastPrinted = '2400755428', trcLastDate = '2024-12-28 15:43:09' where trcStatus='V' and trcTerId = 18 28/12/2024 15:44:52.5374 507 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 28/12/2024 15:46:01.1653 1609 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 28/12/2024 15:49:18.8376 594 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 28/12/2024 15:50:33.5496 1794 ms. EXEC: insert into paycash (casCreation,casModify,casUseId,casStatus,casUID,casTraUID,casYear,casDateTime,casIdTerminal,casCurrency,casNumber,casSingleAmount,casTotAmount,casType,casDescription) VALUES ('2024-12-28 15:50:31',0,0,'V',5090290733273490,4952306138426790,2024,'2024-12-28 15:50:31',3,'KES',1,100,100,'N',''); 28/12/2024 15:51:03.7008 524 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2024-12-28 15:51:03',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'; 28/12/2024 15:52:23.7073 724 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 28/12/2024 15:52:31.5905 506 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2024-12-28 15:52:30',3,42101,0,50,1,50,1,'I','N'); update payCurInventory set curQuantity=round(curQuantity+1,5),curAmount=round(curAmount+50,5) where curTerId = 3 and curDevCode = 42101 and curChannelId = 1 and curValue = 50 and curType = 'N'; 28/12/2024 15:53:00.1907 968 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 28/12/2024 15:53:21.0136 617 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 28/12/2024 15:53:54.5610 618 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-28 15:53:53',0,'V',5454446578845740,5753588995842190,2024,'2024-12-28 15:53:53',2,1,0,-1,'2024-12-28 16:53:53','S','KES',0,0,0,'','','',3,0,0) 28/12/2024 16:07:15.1552 1175 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 28/12/2024 16:08:10.1920 987 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-28 16:08:09','V',4901380676670570,2024,'2024-12-28 16:08:06','456525627900327005012999',2,2,2,'O','',0,'2024-12-28 16:08:09',1,'','0230003944081',15,0) 28/12/2024 16:33:10.9684 829 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 28/12/2024 16:43:45.0800 1231 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 28/12/2024 16:44:54.8399 517 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 28/12/2024 16:45:22.0433 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-12-28 16:45:21','V',5336129954710510,2024,'2024-12-28 16:45:20','456526032000327005012999',1,2,16,'I','',1,0,1,'','',4) 28/12/2024 16:45:39.0347 1081 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 28/12/2024 16:48:44.3444 747 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 28/12/2024 16:53:18.6492 840 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 28/12/2024 16:54:17.5561 793 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2024-12-28 16:54:16' where payTraUID = 5477049336372880 and payStatus='V' and payEnabled=1 28/12/2024 16:54:24.2065 517 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 28/12/2024 16:58:19.0133 1055 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-28 16:58:17','V',5368287963925640,2024,'2024-12-28 16:58:17','456525600700327005012999',2,2,2,'O','',0,'2024-12-28 16:58:17',1,'','',0) 28/12/2024 16:58:19.9109 628 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2024-12-28 16:58:19' where traUID = 5039513089018410 and traStatus='V' and traEnabled=1 28/12/2024 16:58:22.8208 1340 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 28/12/2024 16:58:50.5513 514 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 28/12/2024 17:00:29.2913 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-12-28 17:00:28','V',4954999517854460,2024,'2024-12-28 17:00:27','456526122700327005012999',1,2,16,'I','',1,0,1,'','',4) (WAIT TIME 5 ms.) 28/12/2024 17:01:08.3755 1015 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 28/12/2024 17:05:40.9367 2222 ms. EXEC: insert into movOperator (opeCreation,opeTerId,opeUseId,opeDateTime,opeCode,opeDescription) VALUES ('2024-12-28 17:05:38',4,6,'2024-12-28 17:05:38','456524897000327005012999','Payed (Credit Card ) Ticket ') 28/12/2024 17:08:50.2932 677 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 28/12/2024 17:11:13.4429 557 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 28/12/2024 17:11:20.3986 756 ms. EXEC: insert into movOperator (opeCreation,opeTerId,opeUseId,opeDateTime,opeCode,opeDescription) VALUES ('2024-12-28 17:11:19',4,6,'2024-12-28 17:11:19','456526122700327005012999','Payed (Credit Card ) Ticket ') 28/12/2024 17:12:03.1928 593 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 28/12/2024 17:12:03.8783 534 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 28/12/2024 17:12:08.9467 527 ms. EXEC: update payInventory set invCreation = '2024-12-28 17:12:08',invModify = '2024-12-28 17:12:08',invUseId=0,invStatus='V' where invId = 228052 28/12/2024 17:16:04.0851 629 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-28 17:16:03','V',4838787410912510,2024,'2024-12-28 17:16:00','456526032000327005012999',2,2,2,'O','',0,'2024-12-28 17:16:03',1,'','',0) (WAIT TIME 38 ms.) 28/12/2024 17:16:07.5484 3130 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2024-12-28 17:16:04' where payTraUID = 5336129954710510 and payStatus='V' and payEnabled=1 28/12/2024 17:16:08.2889 3797 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 28/12/2024 17:16:08.3139 765 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2024-12-28 17:16:04' where traUID = 5336129954710510 and traStatus='V' and traEnabled=1 28/12/2024 17:23:03.2210 2303 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 28/12/2024 17:23:19.0126 592 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2024-12-28 17:23:18',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'; 28/12/2024 17:23:19.8721 534 ms. EXEC: update paycash set casCreation = '2024-12-28 17:23:19',casModify = '2024-12-28 17:23:19',casUseId=0,casStatus='V' where casId = 202320 28/12/2024 17:23:21.1460 1273 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2024-12-28 17:23:19',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'; 28/12/2024 17:23:53.6988 603 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 28/12/2024 17:24:52.0855 633 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 28/12/2024 17:25:19.0934 661 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-28 17:25:18','V',5198112936645210,2024,'2024-12-28 17:25:15','456526191200327005012999',2,2,2,'O','',0,'2024-12-28 17:25:18',1,'','',0) 28/12/2024 17:25:43.4517 725 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 28/12/2024 17:27:12.9055 532 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 28/12/2024 17:29:58.6847 699 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 28/12/2024 17:30:23.1612 548 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2024-12-28 17:30:22' where payTraUID = 5322444796160610 and payStatus='V' and payEnabled=1 28/12/2024 17:38:13.4275 630 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 28/12/2024 17:40:58.8186 596 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 28/12/2024 17:41:23.2349 663 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 28/12/2024 17:41:30.7289 754 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 28/12/2024 17:46:00.0738 549 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 28/12/2024 17:54:55.8827 1478 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 28/12/2024 17:57:57.7843 1160 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 28/12/2024 18:01:49.2162 570 ms. EXEC: insert into abbPayment (payCreation,payCode,payAmount,payCredit,payPayUID,payCarId,payDateFrom,payDateTo) VALUES ('2024-12-28 18:01:48','0230004098588',0,0,4789006968898930,183,'0000-00-00 00:00:00','0000-00-00 00:00:00') 28/12/2024 18:04:17.3073 993 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-28 18:04:13',0,'V',5085190465201240,4872903409007710,2024,'2024-12-28 18:04:13',3,1,0,4,'2024-12-28 18:19:13','C','KES',100,100,0,'',' ',' ',1,100,0,0,'',0,0) 28/12/2024 18:04:18.0528 693 ms. EXEC: insert into payReceipt (recTraUID,recPayUID,recYear,recDateTime,recText,recInvalid) VALUES (4872903409007710,5085190465201240,2024,'2024-12-28 18:04:17','---------------------------------- %The Mall P0006032390 End of payment ---------------------------------- POF Entry : 12/28/2024 4:15:34 PM Date : 12/28/2024 6:04:13 PM Code : 456525853400327005012999 Total : 100.00 KES VAT 16% : 13.79 KES ---------------------------------- Paid : 100.00 KES Coin changed : 0.00 KES Note changed : 0.00 KES',0) 28/12/2024 18:04:18.7253 671 ms. EXEC: update payReceipt set recCreation = '2024-12-28 18:04:18',recModify = '2024-12-28 18:04:18',recUseId=0,recStatus='V' where recId = 336969 28/12/2024 18:04:36.8925 921 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 28/12/2024 18:04:45.0860 875 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 28/12/2024 18:05:28.5725 953 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 28/12/2024 18:05:29.4180 823 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2024-12-28 18:05:28' where payTraUID = 5649803093769980 and payStatus='V' and payEnabled=1 28/12/2024 18:06:39.7661 589 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 28/12/2024 18:06:46.9899 561 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 28/12/2024 18:15:44.5272 1120 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 28/12/2024 18:21:00.0250 1827 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 28/12/2024 18:21:24.8866 1590 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 28/12/2024 18:30:52.3569 1190 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 28/12/2024 18:30:59.2665 542 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 28/12/2024 18:34:38.9624 672 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 28/12/2024 18:34:49.0251 606 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 28/12/2024 18:38:49.5814 506 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 28/12/2024 18:38:56.8342 705 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 28/12/2024 18:40:56.1910 735 ms. EXEC: INSERT INTO movOperator (opeCreation,opeUseId,opeTerId,opeDateTime,opeCode,opeDescription) VALUES ('2024-12-28 18:40:55',0,16,'2024-12-28 18:40:55','','Unauthorized Transit Entry 2') 28/12/2024 18:42:25.8140 751 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 28/12/2024 18:44:05.3430 513 ms. EXECSCALAR: select count(*) from information_schema.tables where table_schema= 'wisepark_0327' and table_name= 'payInvoiceFtp' nr: 1 28/12/2024 18:44:06.2206 570 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 28/12/2024 18:44:14.9815 548 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 28/12/2024 18:47:50.5206 883 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 28/12/2024 18:56:04.0777 525 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 28/12/2024 19:02:43.3784 992 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 28/12/2024 19:08:26.7919 1810 ms. EXEC: update abbSubscriptions set subCredit = round(subCredit-0,5),subLastDebit = '2024-12-28 19:08:24' where subId = 206 28/12/2024 19:08:28.4030 1416 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-28 19:08:26','V',4980748204754060,2024,'2024-12-28 19:08:23','456526852400327005012999',2,2,2,'O','',0,'2024-12-28 19:08:26',1,'','0560008304916',190,0) 28/12/2024 19:12:49.9915 635 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 28/12/2024 19:13:34.8155 535 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 28/12/2024 19:14:11.3199 532 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 28/12/2024 19:14:59.9855 526 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 28/12/2024 19:15:37.9979 1024 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 28/12/2024 19:25:39.7358 509 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 28/12/2024 19:27:01.6296 597 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 28/12/2024 19:31:04.7701 926 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 28/12/2024 19:53:35.1283 1217 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 28/12/2024 19:55:03.5914 972 ms. EXEC: UPDATE payInventory SET invType='N' WHERE invType<>'N' AND invValue IN (100,200,500) AND invDevice IN (42102,42101,42001); 28/12/2024 19:55:08.1765 599 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 28/12/2024 19:55:38.2606 512 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-28 19:55:37','V',5438357583599160,2024,'2024-12-28 19:55:36','456527173600327005012999',1,2,16,'I','',1,0,1,'','',4) 28/12/2024 19:57:21.1524 507 ms. EXEC: update opeActivities set acvFstPayId = (case acvFstPayId when 0 then 388106 else acvFstPayId end),acvLstPayId = 388106 where acvSftId = 869 and acvCodeId = 3 (WAIT TIME 113 ms.) 28/12/2024 20:05:18.6914 805 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 28/12/2024 20:07:13.0800 1174 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 28/12/2024 20:08:55.9619 1541 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 28/12/2024 20:10:23.7716 1436 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 28/12/2024 20:10:37.6368 877 ms. EXECSCALAR: select count(*) from tabTerminalExtraMem where extStatus='V' and extTerId = 16 nr: 1 28/12/2024 20:12:17.0059 769 ms. EXEC: update tabTerminalReceipt set trcProgressive = 55472, trcLastPrinted = '2400755472', trcLastDate = '2024-12-28 20:12:16' where trcStatus='V' and trcTerId = 18 28/12/2024 20:13:22.3097 537 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 28/12/2024 20:20:55.1959 936 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 28/12/2024 20:26:20.1031 689 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 28/12/2024 20:28:37.0066 1577 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 28/12/2024 20:28:40.1397 1098 ms. EXECSCALAR: select count(0) as vTot from tabParameters where parPlateReading<>0 nr: 0 28/12/2024 20:28:48.6294 865 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 28/12/2024 20:30:04.6852 1460 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 28/12/2024 20:41:46.1732 685 ms. EXEC: insert into abbPayment (payCreation,payCode,payAmount,payCredit,payPayUID,payCarId,payDateFrom,payDateTo) VALUES ('2024-12-28 20:41:45','0230003944081',0,0,4776549378453860,15,'0000-00-00 00:00:00','0000-00-00 00:00:00') 28/12/2024 20:41:54.7229 658 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 28/12/2024 20:45:10.1881 2081 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 28/12/2024 20:47:16.8451 681 ms. EXEC: INSERT INTO movOperator (opeCreation,opeUseId,opeTerId,opeDateTime,opeCode,opeDescription) VALUES ('2024-12-28 20:47:16',0,16,'2024-12-28 20:47:16','','Unauthorized Transit Entry 2') 28/12/2024 20:55:10.0815 600 ms. EXECSCALAR: select count(*) from tabTerminalExtraMem where extStatus='V' and extTerId = 16 nr: 1 28/12/2024 20:58:50.1170 516 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 28/12/2024 21:10:05.4361 508 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2024-12-28 21:10:04',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-28 21:10:04',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'; 28/12/2024 21:29:37.2556 832 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 28/12/2024 21:35:25.9927 961 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 28/12/2024 21:36:13.5045 662 ms. EXEC: insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2024-12-28 21:36:12',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-28 21:36:12',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'; 28/12/2024 21:36:56.2110 714 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-28 21:36:55',0,'V',4709063967212980,5248726349126030,2024,'2024-12-28 21:36:55',18,1,0,4,'2024-12-28 21:51:55','C','KES',50,50,0,'','','',1,50,0,0,'',0,0) 28/12/2024 21:39:28.9073 1439 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2024-12-28 21:39:27' where traUID = 5079054423694750 and traStatus='V' and traEnabled=1 28/12/2024 21:39:59.7509 523 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2024-12-28 21:39:59' where traUID = 5248726349126030 and traStatus='V' and traEnabled=1 28/12/2024 21:40:32.4548 571 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 28/12/2024 21:49:04.4565 620 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 28/12/2024 21:49:23.0890 616 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 28/12/2024 21:49:49.5947 732 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 28/12/2024 21:49:49.6467 895 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2024-12-28 21:49:48' where traUID = 4707707812364860 and traStatus='V' and traEnabled=1 28/12/2024 21:52:37.6250 547 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 28/12/2024 22:05:30.0579 889 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 28/12/2024 22:06:26.0358 622 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 28/12/2024 22:10:31.4327 1038 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 28/12/2024 22:10:36.5481 537 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 28/12/2024 22:13:09.8386 692 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 28/12/2024 22:14:02.2536 667 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 28/12/2024 22:14:20.4558 1116 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 28/12/2024 22:14:38.3137 1276 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 28/12/2024 22:26:50.6735 1166 ms. EXEC: insert into movOperator (opeCreation,opeTerId,opeUseId,opeDateTime,opeCode,opeDescription) VALUES ('2024-12-28 22:26:49',4,6,'2024-12-28 22:26:49','456527008700327005012999','Payed (Credit Card ) Ticket ') 28/12/2024 22:26:51.6531 793 ms. EXEC: update tabTerminalReceipt set trcProgressive = 18544, trcLastPrinted = '2400418544', trcLastDate = '2024-12-28 22:26:50' where trcStatus='V' and trcTerId = 4 28/12/2024 22:27:41.3614 1397 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 2 28/12/2024 22:32:30.4426 821 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 28/12/2024 22:39:43.5701 635 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-28 22:39:42','V',5465533366692660,2024,'2024-12-28 22:39:41','456527530000327005012999',2,2,2,'O','',0,'2024-12-28 22:39:42',1,'','',0) 28/12/2024 22:42:51.6927 616 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 28/12/2024 22:56:49.8039 618 ms. EXECSCALAR: select count(*) from information_schema.tables where table_schema= 'wisepark_0327' and table_name= 'payInvoiceFtp' nr: 1 28/12/2024 22:56:51.3539 950 ms. EXEC: UPDATE payInventory SET invType='N' WHERE invType<>'N' AND invValue IN (100,200,500) AND invDevice IN (42102,42101,42001); 28/12/2024 23:12:04.6616 557 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 28/12/2024 23:15:31.3928 770 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 28/12/2024 23:18:03.5687 650 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 28/12/2024 23:25:53.0450 809 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); (WAIT TIME 64 ms.) 28/12/2024 23:25:54.0227 948 ms. EXEC: UPDATE payInventory SET invType='N' WHERE invType<>'N' AND invValue IN (100,200,500) AND invDevice IN (42102,42101,42001); 28/12/2024 23:27:24.8615 645 ms. EXEC: insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2024-12-28 23:27:24',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'; 28/12/2024 23:28:07.6867 942 ms. EXEC: update paycash set casCreation = '2024-12-28 23:28:06',casModify = '2024-12-28 23:28:06',casUseId=0,casStatus='V' where casId = 202351 28/12/2024 23:30:23.0717 1321 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 28/12/2024 23:34:15.4270 762 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 28/12/2024 23:36:45.7927 539 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 28/12/2024 23:55:05.1592 846 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 28/12/2024 23:59:46.2191 655 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1