24/12/2024 00:24:24.2931 525 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 24/12/2024 01:01:05.5353 1368 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 24/12/2024 01:18:26.1593 645 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 24/12/2024 01:35:05.6629 517 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-24 01:35:05','V',5755006110823080,2024,'2024-12-24 01:35:04','456480570400327005012999',1,2,16,'I','',1,0,1,'','',4) 24/12/2024 01:51:30.3860 546 ms. EXEC: update abbAreaGroup set argNrInside = argNrInside + 1 where argStatus='V' and argAreId = 1 and argAbgId = 99999 24/12/2024 02:01:15.5839 793 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 24/12/2024 02:06:04.1315 1076 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 24/12/2024 02:43:06.6547 648 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 24/12/2024 03:27:10.3409 595 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 24/12/2024 03:31:18.4459 637 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 24/12/2024 04:37:38.0937 704 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 24/12/2024 05:23:17.0248 841 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 24/12/2024 05:23:35.8414 743 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 24/12/2024 05:53:06.1313 808 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 24/12/2024 07:01:38.6755 511 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 24/12/2024 07:08:23.6409 1289 ms. EXEC: UPDATE payInventory SET invType='N' WHERE invType<>'N' AND invValue IN (100,200,500) AND invDevice IN (42102,42101,42001); 24/12/2024 07:08:52.4273 774 ms. OPEN: select * from tabArea where areStatus='V' and areEnabled = 1 AND areId = 1 24/12/2024 07:11:58.9368 1393 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 24/12/2024 07:16:07.6196 515 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 24/12/2024 07:18:53.3921 994 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 24/12/2024 07:58:16.2531 505 ms. EXEC: update payReceipt set recCreation = '2024-12-24 07:58:15',recModify = '2024-12-24 07:58:15',recUseId=0,recStatus='V' where recId = 335749 24/12/2024 07:58:17.4899 703 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 24/12/2024 07:59:46.2243 574 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 24/12/2024 08:03:21.6584 557 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 24/12/2024 08:06:24.0570 588 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 24/12/2024 08:21:02.3711 752 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 24/12/2024 08:33:27.8884 838 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 24/12/2024 08:33:38.2185 839 ms. EXEC: UPDATE payInventory SET invType='N' WHERE invType<>'N' AND invValue IN (100,200,500) AND invDevice IN (42102,42101,42001); 24/12/2024 08:46:41.5694 691 ms. EXEC: insert into payReceipt (recTraUID,recPayUID,recYear,recDateTime,recText,recInvalid) VALUES (5157548292893150,5235447520820170,2024,'2024-12-24 08:46:40',' Date: 12/24/2024 8:43:09 AM Code: 456483069500327005012999 Entry Date: 12/24/2024 8:31:35 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 # 2400418363 ',0) 24/12/2024 08:47:17.3726 681 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 24/12/2024 08:54:04.4347 946 ms. EXECSCALAR: select count(*) from information_schema.tables where table_schema= 'wisepark_0327' and table_name= 'payInvoiceFtp' nr: 1 24/12/2024 08:54:08.6075 919 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 24/12/2024 08:54:08.6335 990 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 16 OR lnsTerId=16) 24/12/2024 08:59:42.0504 980 ms. EXEC: insert into paycash (casCreation,casModify,casUseId,casStatus,casUID,casTraUID,casYear,casDateTime,casIdTerminal,casCurrency,casNumber,casSingleAmount,casTotAmount,casType,casDescription) VALUES ('2024-12-24 08:59:41',0,0,'V',5469366269746150,5341053613557410,2024,'2024-12-24 08:59:41',3,'KES',1,50,50,'N',''); 24/12/2024 09:14:13.9878 614 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 24/12/2024 09:14:14.0268 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-24 09:10:41',1,'V',4835620205425200,4852723938695660,2024,'2024-12-24 09:10:41',4,1,0,4,'2024-12-24 09:25:41','P','KES',50,50,0,'','','',1,50,0,0,'',0,0) 24/12/2024 09:14:15.5168 1452 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2024-12-24 09:14:13' where traUID = 5045351553016390 and traStatus='V' and traEnabled=1 24/12/2024 09:14:15.6929 1441 ms. EXEC: update opeActivities set acvFstPayId = (case acvFstPayId when 0 then 386677 else acvFstPayId end),acvLstPayId = 386677 where acvSftId = 862 and acvCodeId = 3 24/12/2024 09:16:15.0168 664 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 24/12/2024 09:21:48.9411 666 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2024-12-24 09:21:48' where traUID = 5299955768438460 and traStatus='V' and traEnabled=1 24/12/2024 09:26:17.7777 553 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 24/12/2024 09:42:19.8641 636 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-24 09:42:19','V',5086493157955880,2024,'2024-12-24 09:42:18','456483435400327005012999',2,2,2,'O','',0,'2024-12-24 09:42:19',1,'','',0) 24/12/2024 09:51:06.2066 1348 ms. EXEC: UPDATE payInventory SET invType='N' WHERE invType<>'N' AND invValue IN (100,200,500) AND invDevice IN (42102,42101,42001); 24/12/2024 09:52:20.8695 840 ms. EXEC: UPDATE payInventory SET invType='N' WHERE invType<>'N' AND invValue IN (100,200,500) AND invDevice IN (42102,42101,42001); 24/12/2024 09:52:40.2794 684 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 24/12/2024 09:54:45.3461 968 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 24/12/2024 09:58:18.9889 1147 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 24/12/2024 10:39:48.9483 1527 ms. OPEN: select * from movTransit inner join paypayment on paypayment.payTraUID = movTransit.traUID where traCode = '456483759200327005012999' and traStatus='V' and payStatus='V' order by payDateTime desc 24/12/2024 10:41:58.5280 1127 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 24/12/2024 10:43:20.6350 756 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 24/12/2024 10:59:23.6219 896 ms. EXEC: UPDATE payInventory SET invType='N' WHERE invType<>'N' AND invValue IN (100,200,500) AND invDevice IN (42102,42101,42001); 24/12/2024 11:00:24.2534 662 ms. EXEC: insert into paycash (casCreation,casModify,casUseId,casStatus,casUID,casTraUID,casYear,casDateTime,casIdTerminal,casCurrency,casNumber,casSingleAmount,casTotAmount,casType,casDescription) VALUES ('2024-12-24 11:00:23',0,0,'V',4819633328640830,5341703780122400,2024,'2024-12-24 11:00:23',3,'KES',1,50,50,'N',''); 24/12/2024 11:10:23.8251 816 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2024-12-24 11:10:22',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'; 24/12/2024 11:18:25.6844 615 ms. EXEC: UPDATE payInventory SET invType='N' WHERE invType<>'N' AND invValue IN (100,200,500) AND invDevice IN (42102,42101,42001); 24/12/2024 11:41:08.3807 626 ms. EXEC: update payReceipt set recCreation = '2024-12-24 11:41:07',recModify = '2024-12-24 11:41:07',recUseId=0,recStatus='V' where recId = 335832 24/12/2024 11:42:58.5447 614 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2024-12-24 11:42:57' where traUID = 5255820984863820 and traStatus='V' and traEnabled=1 24/12/2024 11:45:47.6839 616 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 24/12/2024 11:59:33.3358 716 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 24/12/2024 11:59:45.9718 1001 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 24/12/2024 12:00:25.2375 849 ms. EXEC: update opeActivities set acvFstPayId = (case acvFstPayId when 0 then 386757 else acvFstPayId end),acvLstPayId = 386757 where acvSftId = 862 and acvCodeId = 3 24/12/2024 12:06:46.6028 987 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2024-12-24 12:06:45',3,42101,0,50,-1,-50,1,'O','N'); update payCurInventory set curQuantity=round(curQuantity+-1,5),curAmount=round(curAmount+-50,5) where curTerId = 3 and curDevCode = 42101 and curChannelId = 1 and curValue = 50 and curType = 'N'; 24/12/2024 12:07:43.1649 1521 ms. EXEC: UPDATE payInventory SET invType='N' WHERE invType<>'N' AND invValue IN (100,200,500) AND invDevice IN (42102,42101,42001); 24/12/2024 12:08:00.3764 786 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 24/12/2024 12:08:00.4344 1360 ms. EXEC: insert into paycash (casCreation,casModify,casUseId,casStatus,casUID,casTraUID,casYear,casDateTime,casIdTerminal,casCurrency,casNumber,casSingleAmount,casTotAmount,casType,casDescription) VALUES ('2024-12-24 12:07:59',0,0,'V',5605935418792670,5713126080823610,2024,'2024-12-24 12:07:59',3,'KES',1,100,100,'N',''); 24/12/2024 12:09:20.4379 591 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-24 12:05:49',6,'V',4818979810083330,5477956104052110,2024,'2024-12-24 12:05:49',4,1,0,4,'2024-12-24 12:20:49','P','KES',50,50,0,'','','',1,50,0,0,'',0,0) 24/12/2024 12:09:21.5096 597 ms. EXEC: update payReceipt set recCreation = '2024-12-24 12:09:20',recModify = '2024-12-24 12:09:20',recUseId=0,recStatus='V' where recId = 335845 24/12/2024 12:17:41.2373 553 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 24/12/2024 12:21:55.7444 549 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 24/12/2024 12:25:54.7156 741 ms. OPEN: show columns from tabParameters where Field = 'parUseCulture' 24/12/2024 12:27:34.5435 784 ms. EXECSCALAR: select count(*) from information_schema.tables where table_schema= 'wisepark_0327' and table_name= 'payInvoiceFtp' nr: 1 24/12/2024 12:30:11.2005 628 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 24/12/2024 12:31:06.8275 527 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 24/12/2024 12:31:24.1121 523 ms. EXEC: insert into payReceipt (recTraUID,recPayUID,recYear,recDateTime,recText,recInvalid) VALUES (5501196431601340,4654871826819360,2024,'2024-12-24 12:31:23',' Date: 12/24/2024 12:31:23 PM Code: 456484318400327005012999 Entry Date: 12/24/2024 11:59:44 AM Plate: Class: Cars Park: The Mall Gate: Entry 2 ______________________________ Total: 50.00 KES ______________________________ Paid: 50.00 KES __________ Change: 0.00 KES Type: Cash Dispozitiv: MPESA # 2400754905 ',0) 24/12/2024 12:31:38.5177 503 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 24/12/2024 12:31:40.1668 953 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 5 24/12/2024 12:31:40.1678 952 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 1 24/12/2024 12:31:40.9784 725 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2024-12-24 12:31:40',3,42101,0,50,-1,-50,1,'O','N'); update payCurInventory set curQuantity=round(curQuantity+-1,5),curAmount=round(curAmount+-50,5) where curTerId = 3 and curDevCode = 42101 and curChannelId = 1 and curValue = 50 and curType = 'N'; Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2024-12-24 12:31:40',3,42101,0,100,-1,-100,1,'O','N'); update payCurInventory set curQuantity=round(curQuantity+-1,5),curAmount=round(curAmount+-100,5) where curTerId = 3 and curDevCode = 42101 and curChannelId = 1 and curValue = 100 and curType = 'N'; 24/12/2024 12:38:10.3924 1215 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2024-12-24 12:38:09' where payTraUID = 5707394805409050 and payStatus='V' and payEnabled=1 24/12/2024 12:45:18.4511 765 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-24 12:45:17','V',4993958002456360,2024,'2024-12-24 12:45:15','456484511600327005012999',2,2,2,'O','',0,'2024-12-24 12:45:17',1,'','',0) 24/12/2024 12:57:37.3036 738 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 24/12/2024 13:17:46.8248 686 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 24/12/2024 13:19:36.0640 1162 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-24 13:16:04',6,'V',5354646018776080,4755528095007830,2024,'2024-12-24 13:16:04',4,1,0,4,'2024-12-24 13:31:04','P','KES',100,100,0,'','','',1,100,0,0,'',0,0) 24/12/2024 13:21:23.0230 802 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 24/12/2024 13:26:17.8146 530 ms. OPEN: select traId,traDateTime,traEnabled,traDisableTime,traCode,traBadge,traCarId,traAreId,traIdTerminal from movtransit where traStatus='V' and traDirection = 'I' and traCarId = 13 order by traDateTime desc,traId desc 24/12/2024 13:37:47.8977 702 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 24/12/2024 13:39:46.0494 814 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 24/12/2024 13:39:58.1275 562 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 24/12/2024 13:52:00.8982 1605 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-24 13:51:59','V',5407660412197490,2024,'2024-12-24 13:51:58','456484991800327005012999',1,2,16,'I','',1,0,1,'','',4) 24/12/2024 13:57:05.4043 528 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2024-12-24 13:57:04' where traUID = 5521913649486750 and traStatus='V' and traEnabled=1 24/12/2024 14:15:35.5125 1110 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 24/12/2024 14:17:15.1902 1178 ms. EXECSCALAR: select count(*) from information_schema.tables where table_schema= 'wisepark_0327' and table_name= 'payInvoiceFtp' nr: 1 24/12/2024 14:23:57.4033 1060 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 24/12/2024 14:24:19.9874 718 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2024-12-24 14:24:19' where traUID = 5427446239525710 and traStatus='V' and traEnabled=1 24/12/2024 14:24:47.0897 579 ms. EXEC: UPDATE payInventory SET invType='N' WHERE invType<>'N' AND invValue IN (100,200,500) AND invDevice IN (42102,42101,42001); 24/12/2024 14:28:12.0785 501 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 24/12/2024 14:29:57.4403 1601 ms. EXECSCALAR: select count(*) from information_schema.tables where table_schema= 'wisepark_0327' and table_name= 'payInvoiceFtp' nr: 1 24/12/2024 14:43:06.8790 758 ms. EXEC: insert into paycash (casCreation,casModify,casUseId,casStatus,casUID,casTraUID,casYear,casDateTime,casIdTerminal,casCurrency,casNumber,casSingleAmount,casTotAmount,casType,casDescription) VALUES ('2024-12-24 14:43:06',0,0,'V',5738602307667770,5206724581679600,2024,'2024-12-24 14:43:06',3,'KES',1,100,100,'N',''); 24/12/2024 14:43:08.0138 549 ms. EXEC: insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2024-12-24 14:43:07',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-24 14:43:07',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'; 24/12/2024 14:44:33.4793 637 ms. EXECSCALAR: select count(*) from information_schema.tables where table_schema= 'wisepark_0327' and table_name= 'payInvoiceFtp' nr: 1 24/12/2024 14:45:19.1193 686 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 24/12/2024 14:46:08.5033 762 ms. EXEC: update abbSubscriptions set subCredit = round(subCredit-0,5),subLastDebit = '2024-12-24 14:46:07' where subId = 18 24/12/2024 14:51:18.1592 593 ms. EXEC: insert into abbPayment (payCreation,payCode,payAmount,payCredit,payPayUID,payCarId,payDateFrom,payDateTo) VALUES ('2024-12-24 14:51:17','0810007113876',0,0,5470027676156720,103,'0000-00-00 00:00:00','0000-00-00 00:00:00') 24/12/2024 14:52:11.6829 661 ms. EXEC: update tabTerminalReceipt set trcProgressive = 18386, trcLastPrinted = '2400418386', trcLastDate = '2024-12-24 14:52:11' where trcStatus='V' and trcTerId = 4 24/12/2024 14:54:14.9674 969 ms. EXECSCALAR: select count(*) from information_schema.tables where table_schema= 'wisepark_0327' and table_name= 'payInvoiceFtp' nr: 1 24/12/2024 14:58:09.2683 888 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 24/12/2024 15:01:18.6469 1445 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 24/12/2024 15:01:59.7604 936 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2024-12-24 15:01:58' where traUID = 5219916582052130 and traStatus='V' and traEnabled=1 24/12/2024 15:02:04.9779 1100 ms. EXEC: UPDATE payInventory SET invType='N' WHERE invType<>'N' AND invValue IN (100,200,500) AND invDevice IN (42102,42101,42001); (WAIT TIME 42 ms.) 24/12/2024 15:02:58.4276 614 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 16 OR lnsTerId=16) 24/12/2024 15:07:52.9223 944 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 24/12/2024 15:08:14.5288 1488 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2024-12-24 15:08:13' where payTraUID = 5756601066690430 and payStatus='V' and payEnabled=1 24/12/2024 15:08:39.2763 586 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 24/12/2024 15:14:33.4057 831 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2024-12-24 15:14:32',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'; 24/12/2024 15:18:05.2335 664 ms. EXEC: insert into payPayment (payCreation,payUseId,payStatus,payUID,payTraUID,payYear,payDateTime,payIdTerminal,payEnabled,payDisableTime,payTarId,payTimeLimit,payType,payCurrency,payAmount,payPayed,payChange,payCardType,payPAN,paySTAN,payIdEvent,payVatPercent,payVatAmount) VALUES ('2024-12-24 15:18:04',0,'V',5193490640277170,5317768066165590,2024,'2024-12-24 15:18:04',2,1,0,-1,'2024-12-24 16:18:04','S','KES',0,0,0,'','','',3,0,0) 24/12/2024 15:18:06.7665 823 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2024-12-24 15:18:05' where payTraUID = 5317768066165590 and payStatus='V' and payEnabled=1 24/12/2024 15:18:51.1052 800 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 24/12/2024 15:36:39.5520 590 ms. EXEC: insert into payPayment (payCreation,payUseId,payStatus,payUID,payTraUID,payYear,payDateTime,payIdTerminal,payEnabled,payDisableTime,payTarId,payTimeLimit,payType,payCurrency,payAmount,payPayed,payChange,payCardType,payPAN,paySTAN,payIdEvent,payAmountCalc,payDiscountValue,payDiscount,payDiscountType,payVatPercent,payVatAmount) VALUES ('2024-12-24 15:36:38',0,'V',5695934086097000,5319198028731090,2024,'2024-12-24 15:36:38',18,1,0,4,'2024-12-24 15:51:38','C','KES',50,50,0,'','','',1,50,0,0,'',0,0) 24/12/2024 15:38:46.8904 542 ms. EXEC: update payReceipt set recCreation = '2024-12-24 15:38:46',recModify = '2024-12-24 15:38:46',recUseId=0,recStatus='V' where recId = 335981 24/12/2024 15:59:26.7120 507 ms. EXEC: update payReceipt set recCreation = '2024-12-24 15:59:26',recModify = '2024-12-24 15:59:26',recUseId=0,recStatus='V' where recId = 335992 24/12/2024 16:03:57.5475 661 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2024-12-24 16:03:56',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'; 24/12/2024 16:09:12.7626 575 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 24/12/2024 16:17:24.7630 1003 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2024-12-24 16:17:23' where traUID = 5651986948469750 and traStatus='V' and traEnabled=1 24/12/2024 16:26:29.1827 571 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 24/12/2024 16:27:41.9723 616 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-24 16:24:11',6,'V',5202164005630660,4978721464184900,2024,'2024-12-24 16:24:11',4,1,0,4,'2024-12-24 16:39:11','P','KES',50,50,0,'','','',1,50,0,0,'',0,0) 24/12/2024 16:34:25.5249 540 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 24/12/2024 16:39:02.7404 540 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-24 16:35:32',6,'V',4911035380195470,5464511507966690,2024,'2024-12-24 16:35:32',4,1,0,4,'2024-12-24 16:50:32','P','KES',50,50,0,'','','',1,50,0,0,'',0,0) 24/12/2024 17:37:38.0960 925 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-24 17:37:37','V',5745967523975960,2024,'2024-12-24 17:37:36','456486345600327005012999',1,2,16,'I','',1,0,1,'','',4) 24/12/2024 17:37:39.1156 556 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 24/12/2024 17:37:50.7414 808 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 24/12/2024 17:38:24.3469 863 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 24/12/2024 17:40:57.6854 883 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2024-12-24 17:40:56' where payTraUID = 5290722242536820 and payStatus='V' and payEnabled=1 24/12/2024 17:46:26.9316 596 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 24/12/2024 17:48:38.0544 581 ms. EXECSCALAR: select count(0) as vTot from tabParameters where parPlateReading<>0 nr: 0 24/12/2024 17:50:28.6635 1131 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 24/12/2024 17:50:29.8813 756 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2024-12-24 17:50:29' where traUID = 5006329905522100 and traStatus='V' and traEnabled=1 24/12/2024 17:50:30.9070 1360 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 24/12/2024 17:52:24.6271 661 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 24/12/2024 18:10:37.4500 669 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-24 18:10:36','V',5406060021693500,2024,'2024-12-24 18:10:35','456486543500327001012999',1,2,1,'I','',1,0,1,'','',4) 24/12/2024 18:13:09.9578 1248 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-24 18:13:08','V',5485423702949320,2024,'2024-12-24 18:13:08','456486558800327005012999',1,2,16,'I','',1,0,1,'','',4) 24/12/2024 18:16:18.3104 593 ms. EXEC: insert into payPayment (payCreation,payUseId,payStatus,payUID,payTraUID,payYear,payDateTime,payIdTerminal,payEnabled,payDisableTime,payTarId,payTimeLimit,payType,payCurrency,payAmount,payPayed,payChange,payCardType,payPAN,paySTAN,payIdEvent,payVatPercent,payVatAmount) VALUES ('2024-12-24 18:16:17',0,'V',4770502744552270,4980294770167760,2024,'2024-12-24 18:16:17',2,1,0,-1,'2024-12-24 19:16:17','S','KES',0,0,0,'','','',3,0,0) 24/12/2024 18:34:04.3627 972 ms. EXECSCALAR: select count(*) from information_schema.tables where table_schema= 'wisepark_0327' and table_name= 'payInvoiceFtp' nr: 1 24/12/2024 18:35:21.0578 529 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 24/12/2024 18:35:56.0470 625 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 24/12/2024 18:36:38.1670 549 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 24/12/2024 18:40:14.2805 990 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2024-12-24 18:40:13' where traUID = 4629522552095380 and traStatus='V' and traEnabled=1 24/12/2024 18:54:50.7752 531 ms. EXECSCALAR: select count(0) as vTot from tabParameters where parPlateReading<>0 nr: 0 24/12/2024 18:54:58.7725 1022 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 24/12/2024 18:55:56.8129 774 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 24/12/2024 19:10:40.6063 621 ms. EXEC: UPDATE payInventory SET invType='N' WHERE invType<>'N' AND invValue IN (100,200,500) AND invDevice IN (42102,42101,42001); 24/12/2024 19:18:30.3927 896 ms. EXEC: update payInventory set invCreation = '2024-12-24 19:18:29',invModify = '2024-12-24 19:18:29',invUseId=0,invStatus='V' where invId = 227537 24/12/2024 19:18:30.4027 668 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 24/12/2024 19:19:57.2986 519 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 24/12/2024 19:20:00.7301 517 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 24/12/2024 19:27:02.7519 936 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-24 19:27:01','V',5695963234550560,2024,'2024-12-24 19:27:01','456486750200327005012999',2,2,2,'O','',0,'2024-12-24 19:27:01',1,'','',0) 24/12/2024 19:27:04.3119 1558 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 24/12/2024 19:27:06.7806 761 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 24/12/2024 19:28:48.0186 724 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2024-12-24 19:28:47' where traUID = 4965030391563970 and traStatus='V' and traEnabled=1 24/12/2024 19:32:52.9124 970 ms. EXEC: insert into movBarrier (barUseId,barCreation,barTerId,barAction,barDescription,barPlate) VALUES (1,'2024-12-24 19:32:51',9999,'open','Send command to entry/exit units: Command OPEN on Device Entry 1 ','') 24/12/2024 19:43:40.2268 531 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 24/12/2024 19:43:40.7622 566 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-24 19:43:40','V',5215416234344670,2024,'2024-12-24 19:43:36','456487101600327005012999',1,2,16,'I','',1,0,1,'','',4) 24/12/2024 19:55:58.2679 531 ms. EXEC: update payReceipt set recCreation = '2024-12-24 19:55:57',recModify = '2024-12-24 19:55:57',recUseId=0,recStatus='V' where recId = 336106 24/12/2024 20:02:34.8218 572 ms. EXEC: update abbSubscriptions set subCredit = round(subCredit-0,5),subLastDebit = '2024-12-24 20:02:34' where subId = 179 24/12/2024 20:18:12.3784 747 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 24/12/2024 20:26:30.5408 1195 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 24/12/2024 20:33:32.6609 774 ms. EXEC: update abbCards set carLastDate = '2024-12-24 20:33:31',carLastDirection='O' where carStatus='V' and carId = 13 24/12/2024 20:33:35.9971 597 ms. OPEN: select * from tabArea where areStatus='V' and areEnabled = 1 AND areId = 1 24/12/2024 20:34:01.1941 549 ms. EXEC: update payReceipt set recCreation = '2024-12-24 20:34:00',recModify = '2024-12-24 20:34:00',recUseId=0,recStatus='V' where recId = 336117 24/12/2024 20:34:16.1010 924 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 24/12/2024 20:36:21.6589 530 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 5 and terStatus='V' 24/12/2024 21:12:34.9667 701 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2024-12-24 21:12:34' where traUID = 5192131437692890 and traStatus='V' and traEnabled=1 24/12/2024 21:15:10.1364 961 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 24/12/2024 21:32:42.8161 1049 ms. OPEN: show columns from tabParameters where Field = 'parUseCulture' 24/12/2024 21:32:43.6917 545 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-24 21:32:43','V',5752021656185020,2024,'2024-12-24 21:32:40','456487756000327005012999',1,2,16,'I','',1,0,1,'','',4) 24/12/2024 21:34:40.9305 570 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 24/12/2024 21:52:47.5779 1016 ms. EXECSCALAR: select count(*) from information_schema.tables where table_schema= 'wisepark_0327' and table_name= 'payInvoiceFtp' nr: 1 24/12/2024 21:57:45.5427 593 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 24/12/2024 22:01:23.4337 792 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 24/12/2024 22:08:02.0569 2528 ms. EXECSCALAR: select count(*) from information_schema.tables where table_schema= 'wisepark_0327' and table_name= 'payInvoiceFtp' nr: 1 24/12/2024 22:11:14.8432 525 ms. EXEC: update abbCards set carLastDate = '2024-12-24 22:11:14',carLastDirection='I' where carStatus='V' and carId = 13 24/12/2024 22:27:32.3105 662 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2024-12-24 22:27:31' where payTraUID = 4726933131784860 and payStatus='V' and payEnabled=1 24/12/2024 22:27:33.2301 918 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2024-12-24 22:27:31' where traUID = 4726933131784860 and traStatus='V' and traEnabled=1 24/12/2024 22:42:43.6009 541 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 24/12/2024 23:15:07.1510 1131 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-24 23:15:06','V',5201629844916190,2024,'2024-12-24 23:15:04','456488128100327005012999',2,2,2,'O','',0,'2024-12-24 23:15:06',1,'','',0) 24/12/2024 23:15:23.5101 777 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1