14/12/2024 06:51:24.0107 934 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 14/12/2024 07:07:30.2569 1507 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/12/2024 07:19:21.7909 517 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/12/2024 07:44:38.4959 609 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2024-12-14 07:44:37' where traUID = 4765550413427430 and traStatus='V' and traEnabled=1 14/12/2024 07:54:15.9045 1089 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/12/2024 07:54:38.1279 762 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 3 and terStatus='V' 14/12/2024 08:18:15.5682 1051 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-14 08:18:14','V',5612285502929460,2024,'2024-12-14 08:18:14','456382989400327005012999',1,2,16,'I','',1,0,1,'','',4) 14/12/2024 08:25:47.7634 533 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/12/2024 08:40:04.9368 798 ms. EXEC: update payReceipt set recCreation = '2024-12-14 08:40:04',recModify = '2024-12-14 08:40:04',recUseId=0,recStatus='V' where recId = 332157 14/12/2024 08:44:05.0373 721 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/12/2024 08:45:10.7658 891 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/12/2024 08:45:30.3170 757 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/12/2024 09:10:04.3257 600 ms. EXEC: insert into paycash (casCreation,casModify,casUseId,casStatus,casUID,casTraUID,casYear,casDateTime,casIdTerminal,casCurrency,casNumber,casSingleAmount,casTotAmount,casType,casDescription) VALUES ('2024-12-14 09:10:03',0,0,'V',4795095625562190,5725113595651680,2024,'2024-12-14 09:10:03',3,'KES',1,50,50,'N',''); 14/12/2024 09:12:52.9802 535 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/12/2024 09:15:16.7991 840 ms. EXEC: update payInventory set invCreation = '2024-12-14 09:15:15',invModify = '2024-12-14 09:15:15',invUseId=0,invStatus='V' where invId = 225120 14/12/2024 09:15:18.3138 1476 ms. EXEC: update paycash set casCreation = '2024-12-14 09:15:16',casModify = '2024-12-14 09:15:16',casUseId=0,casStatus='V' where casId = 199898 14/12/2024 09:15:19.3590 814 ms. EXEC: update payInventory set invCreation = '2024-12-14 09:15:18',invModify = '2024-12-14 09:15:18',invUseId=0,invStatus='V' where invId = 225121 14/12/2024 09:15:31.3265 519 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 14/12/2024 09:18:22.8856 1036 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 14/12/2024 09:19:30.1724 547 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 14/12/2024 09:29:13.6691 539 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 14/12/2024 09:37:23.8589 819 ms. EXEC: UPDATE payInventory SET invType='N' WHERE invType<>'N' AND invValue IN (100,200,500) AND invDevice IN (42102,42101,42001); 14/12/2024 09:37:28.1538 640 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/12/2024 09:37:28.1548 646 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 16 OR lnsTerId=16) 14/12/2024 09:40:44.3925 675 ms. EXEC: UPDATE payInventory SET invType='N' WHERE invType<>'N' AND invValue IN (100,200,500) AND invDevice IN (42102,42101,42001); 14/12/2024 09:45:27.7438 1035 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/12/2024 09:45:33.3021 967 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/12/2024 09:49:53.4743 985 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2024-12-14 09:49:52' where traUID = 5565688809505780 and traStatus='V' and traEnabled=1 14/12/2024 09:49:59.6212 912 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-14 09:49:58',0,'V',4760242346878010,4746563444042300,2024,'2024-12-14 09:49:58',18,1,0,4,'2024-12-14 10:04:58','C','KES',50,50,0,'','','',1,50,0,0,'',0,0) 14/12/2024 09:51:50.7989 563 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 14/12/2024 10:00:44.1174 588 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/12/2024 10:05:02.2566 645 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/12/2024 10:19:55.7410 996 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2024-12-14 10:19:54' where traUID = 5612285502929460 and traStatus='V' and traEnabled=1 14/12/2024 10:20:06.3930 970 ms. EXEC: insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2024-12-14 10:20:05',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-14 10:20:05',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'; 14/12/2024 10:20:11.1919 1034 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 2 OR lnsTerId=2) 14/12/2024 10:21:52.7652 528 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/12/2024 10:23:01.1193 1036 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/12/2024 10:25:56.2356 997 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2024-12-14 10:25:55' where payTraUID = 4728644783586960 and payStatus='V' and payEnabled=1 14/12/2024 10:26:00.5815 908 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/12/2024 10:26:13.2247 535 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/12/2024 10:26:45.8625 1141 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 5 14/12/2024 10:26:56.7047 565 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 16 OR lnsTerId=16) 14/12/2024 10:27:06.6039 687 ms. EXECSCALAR: select count(*) from tabTerminalExtraMem where extStatus='V' and extTerId = 1 nr: 1 14/12/2024 10:31:20.7479 534 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 2 OR lnsTerId=2) 14/12/2024 10:31:43.0230 1103 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-14 10:31:41','V',5296641861714490,2024,'2024-12-14 10:31:41','456383790100327005012999',1,2,16,'I','',1,0,1,'','',4) 14/12/2024 10:40:24.1003 606 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 14/12/2024 10:41:43.9913 2241 ms. EXEC: UPDATE payInventory SET invType='C' WHERE invType<>'C' AND invValue IN (5,10,20,40) AND invDevice IN (41003,41002,41001,41101,41102,41103); 14/12/2024 10:42:16.0764 631 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/12/2024 10:44:28.5407 852 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/12/2024 10:50:05.9935 606 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/12/2024 10:54:25.5128 617 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/12/2024 10:56:03.4979 954 ms. EXEC: update abbCards set carLastDate = '2024-12-14 10:56:02',carLastDirection='O' where carStatus='V' and carId = 14 14/12/2024 10:56:55.7162 504 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-14 10:56:55','V',4893148389521370,2024,'2024-12-14 10:56:54','456383774200327001012999',2,2,2,'O','',0,'2024-12-14 10:56:55',1,'','',0) 14/12/2024 11:06:44.2894 562 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2024-12-14 11:06:43' where payTraUID = 5318335963615130 and payStatus='V' and payEnabled=1 14/12/2024 11:23:15.3887 514 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 14/12/2024 11:31:41.4577 882 ms. EXEC: insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2024-12-14 11: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'; insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2024-12-14 11:31:40',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'; 14/12/2024 11:32:45.6497 872 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 14/12/2024 11:40:32.3189 631 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 14/12/2024 11:41:33.0702 531 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 2 14/12/2024 11:43:53.9589 798 ms. OPEN: select * from movTransit inner join paypayment on paypayment.payTraUID = movTransit.traUID where traCode = '456384223200327005012999' and traStatus='V' and payStatus='V' order by payDateTime desc 14/12/2024 11:43:53.9630 1014 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/12/2024 11:48:30.8863 775 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/12/2024 11:49:12.8906 811 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 3 OR lnsTerId=3) 14/12/2024 11:50:03.5968 628 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-14 11:50:01',0,'V',4625859161979880,5262359803049620,2024,'2024-12-14 11:50:01',3,1,0,4,'2024-12-14 12:05:01','C','KES',50,50,0,'',' ',' ',1,50,0,0,'',0,0) 14/12/2024 11:51:12.2907 784 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 14/12/2024 11:54:18.2130 825 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-14 11:54:16',0,'V',5451420179158040,4640322386539410,2024,'2024-12-14 11:54:16',3,1,0,4,'2024-12-14 12:09:16','C','KES',50,100,50,'',' ',' ',1,50,0,0,'',0,0) 14/12/2024 11:54:19.4203 733 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2024-12-14 11:54:18',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'; 14/12/2024 11:54:56.7324 732 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 14/12/2024 11:54:57.7085 778 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-14 11:54:56','V',4708092570899320,2024,'2024-12-14 11:54:55','456384198900327005012999',2,2,2,'O','',0,'2024-12-14 11:54:56',1,'','',0) 14/12/2024 11:55:09.7751 1378 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/12/2024 11:55:18.8083 546 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 14/12/2024 11:57:19.7265 756 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-14 11:57:18',0,'V',5261284399543090,5498879974607800,2024,'2024-12-14 11:57:18',18,1,0,4,'2024-12-14 12:12:18','C','KES',50,50,0,'','','',1,50,0,0,'',0,0) 14/12/2024 11:57:52.2121 600 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/12/2024 11:58:34.0863 1589 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2024-12-14 11:58:32' where traUID = 5498879974607800 and traStatus='V' and traEnabled=1 14/12/2024 12:18:02.8765 1205 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 14/12/2024 12:18:06.3454 525 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/12/2024 12:19:59.7522 966 ms. EXEC: update tabTerminalReceipt set trcProgressive = 53413, trcLastPrinted = '2400753413', trcLastDate = '2024-12-14 12:19:58' where trcStatus='V' and trcTerId = 18 14/12/2024 12:22:53.0715 1133 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 16 OR lnsTerId=16) 14/12/2024 12:22:53.1075 501 ms. EXECSCALAR: select count(*) from information_schema.tables where table_schema= 'wisepark_0327' and table_name= 'movTransitSecondary' nr: 1 14/12/2024 12:22:53.1516 643 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/12/2024 12:22:57.4665 602 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-14 12:22:56','V',4987337011323660,2024,'2024-12-14 12:22:53','456384457300327005012999',1,2,16,'I','',1,0,1,'','',4) 14/12/2024 12:23:18.1728 2415 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 14/12/2024 12:58:43.9869 689 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 14/12/2024 12:59:17.6758 631 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 14/12/2024 13:01:29.9454 1819 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2024-12-14 13:01:28' where traUID = 4961418973342400 and traStatus='V' and traEnabled=1 14/12/2024 13:01:52.5279 797 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 14/12/2024 13:14:27.9725 587 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 14/12/2024 13:19:39.0839 1499 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-14 13:19:37','V',4680249758819640,2024,'2024-12-14 13:19:36','456384797600327005012999',1,2,16,'I','',1,0,1,'','',4) 14/12/2024 13:21:18.9935 733 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 16 OR lnsTerId=16) 14/12/2024 13:23:12.8008 845 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 14/12/2024 13:24:10.4427 785 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-14 13:20:34',6,'V',5370912420400280,4739843164072040,2024,'2024-12-14 13:20:34',4,1,0,4,'2024-12-14 13:35:34','P','KES',100,100,0,'','','',1,100,0,0,'',0,0) 14/12/2024 13:26:02.5941 637 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/12/2024 13:28:59.6832 574 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 14/12/2024 13:33:24.9376 516 ms. EXEC: update paycash set casCreation = '2024-12-14 13:33:24',casModify = '2024-12-14 13:33:24',casUseId=0,casStatus='V' where casId = 199972 14/12/2024 13:34:40.4696 748 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-14 13:34:38',0,'V',4974073901755360,5339178362574970,2024,'2024-12-14 13:34:38',3,1,0,4,'2024-12-14 13:49:38','C','KES',50,100,50,'',' ',' ',1,50,0,0,'',0,0) 14/12/2024 13:36:43.6812 616 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/12/2024 13:37:17.1260 777 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/12/2024 13:37:28.9178 937 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 14/12/2024 13:37:37.1931 513 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 14/12/2024 13:37:38.6698 648 ms. EXEC: insert into payReceipt (recTraUID,recPayUID,recYear,recDateTime,recText,recInvalid) VALUES (5017419560839470,5575408268589400,2024,'2024-12-14 13:37:38',' Date: 12/14/2024 1:37:37 PM Code: 456384253400327005012999 Entry Date: 12/14/2024 11:48:54 AM 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 # 2400753429 ',0) 14/12/2024 13:38:20.6856 1045 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/12/2024 13:39:56.7503 920 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/12/2024 13:40:04.7984 558 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2024-12-14 13:40:04' where traUID = 4817279162115950 and traStatus='V' and traEnabled=1 14/12/2024 13:41:49.8046 1380 ms. EXEC: UPDATE payInventory SET invType='N' WHERE invType<>'N' AND invValue IN (100,200,500) AND invDevice IN (42102,42101,42001); 14/12/2024 13:42:28.1131 705 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 14/12/2024 13:47:18.3319 715 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 14/12/2024 13:47:43.0538 740 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2024-12-14 13:47:42',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'; 14/12/2024 13:47:56.4627 767 ms. EXEC: insert into payReceipt (recTraUID,recPayUID,recYear,recDateTime,recText,recInvalid) VALUES (5060016627442870,4619904824280530,2024,'2024-12-14 13:47:55',' Date: 12/14/2024 1:44:19 PM Code: 456384455800327005012999 Entry Date: 12/14/2024 12:22:38 PM Plate: Class: Cars Park: The Mall Gate: Entry 2 ______________________________ Total: 100.00 KES ______________________________ Paid: 100.00 KES __________ Change: 0.00 KES Type: Credit Card Dispozitiv: Manual Cashier 1 # 2400417807 ',0) 14/12/2024 13:50:24.9052 1062 ms. EXEC: update payReceipt set recCreation = '2024-12-14 13:50:23',recModify = '2024-12-14 13:50:23',recUseId=0,recStatus='V' where recId = 332306 14/12/2024 13:56:20.6703 698 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/12/2024 13:58:32.4739 912 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 14/12/2024 13:59:02.3167 603 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2024-12-14 13:59:01',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'; 14/12/2024 14:17:30.6126 762 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-14 14:17:29','V',5522009668666550,2024,'2024-12-14 14:17:28','456385019900327005012999',2,2,2,'O','',0,'2024-12-14 14:17:29',1,'','0810007108790',194,0) 14/12/2024 14:25:23.9760 543 ms. EXEC: UPDATE payInventory SET invType='N' WHERE invType<>'N' AND invValue IN (100,200,500) AND invDevice IN (42102,42101,42001); 14/12/2024 14:26:02.0427 1070 ms. EXEC: UPDATE payInventory SET invType='N' WHERE invType<>'N' AND invValue IN (100,200,500) AND invDevice IN (42102,42101,42001); 14/12/2024 14:26:31.1553 672 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/12/2024 14:27:01.3353 1017 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2024-12-14 14:27:00' where payTraUID = 5522958835816290 and payStatus='V' and payEnabled=1 14/12/2024 14:28:35.8000 637 ms. EXEC: update tabTerminalReceipt set trcProgressive = 53440, trcLastPrinted = '2400753440', trcLastDate = '2024-12-14 14:28:35' where trcStatus='V' and trcTerId = 18 14/12/2024 14:29:47.0633 580 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2024-12-14 14:29:46',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'; 14/12/2024 14:30:36.9184 528 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 14/12/2024 14:34:08.7842 507 ms. EXEC: insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2024-12-14 14:34:08',5,3,0,2,0,0,0,0,'2','') 14/12/2024 14:35:25.8440 1038 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-14 14:35:24','V',5660300494766680,2024,'2024-12-14 14:35:24','456385068400327005012999',2,2,2,'O','',0,'2024-12-14 14:35:24',1,'','',0) 14/12/2024 14:39:36.9147 844 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2024-12-14 14:39:35',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-14 14:39:35',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'; 14/12/2024 14:40:29.3498 595 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2024-12-14 14:40:28',3,42101,0,50,-1,-50,1,'O','N'); update payCurInventory set curQuantity=round(curQuantity+-1,5),curAmount=round(curAmount+-50,5) where curTerId = 3 and curDevCode = 42101 and curChannelId = 1 and curValue = 50 and curType = 'N'; 14/12/2024 14:43:11.0852 517 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/12/2024 14:48:39.5252 724 ms. EXEC: update abbAreaGroup set argNrInside = argNrInside + 1 where argStatus='V' and argAreId = 1 and argAbgId = 99999 14/12/2024 14:49:36.9571 1168 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 14/12/2024 14:51:55.7741 1073 ms. EXEC: update payInventory set invCreation = '2024-12-14 14:51:54',invModify = '2024-12-14 14:51:54',invUseId=0,invStatus='V' where invId = 225247 14/12/2024 14:51:57.0625 1128 ms. EXEC: update payInventory set invCreation = '2024-12-14 14:51:55',invModify = '2024-12-14 14:51:55',invUseId=0,invStatus='V' where invId = 225248 14/12/2024 14:51:57.2558 578 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/12/2024 14:53:09.6714 864 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 14/12/2024 14:55:09.3032 592 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-14 14:55:08','V',5532252381500940,2024,'2024-12-14 14:55:07','456385370700327001012999',1,2,1,'I','',1,0,1,'','',4) 14/12/2024 14:56:06.8861 810 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2024-12-14 14:56:05' where traUID = 4739055641546940 and traStatus='V' and traEnabled=1 14/12/2024 14:56:36.8368 731 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 14/12/2024 14:58:42.1186 673 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2024-12-14 14:58:41' where traUID = 5648170059743290 and traStatus='V' and traEnabled=1 14/12/2024 15:00:40.9799 828 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/12/2024 15:12:37.8397 711 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2024-12-14 15:12:37',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'; 14/12/2024 15:34:30.0760 723 ms. EXEC: update tabTerminalReceipt set trcProgressive = 17819, trcLastPrinted = '2400417819', trcLastDate = '2024-12-14 15:34:29' where trcStatus='V' and trcTerId = 4 14/12/2024 15:35:18.3254 523 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-14 15:35:16',0,'V',5576756878280970,5579936395825800,2024,'2024-12-14 15:35:16',3,1,0,4,'2024-12-14 15:50:16','C','KES',100,100,0,'',' ',' ',1,100,0,0,'',0,0) 14/12/2024 15:38:05.8622 786 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/12/2024 15:43:10.4115 753 ms. EXEC: UPDATE payInventory SET invType='N' WHERE invType<>'N' AND invValue IN (100,200,500) AND invDevice IN (42102,42101,42001); 14/12/2024 15:43:15.5583 1055 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/12/2024 15:43:24.9729 1756 ms. OPEN: select parVatRate,parVatName,parVatMethod,parVatRound,parVatDiscount from tabParameters where parStatus='V' order by parId desc limit 1 14/12/2024 15:43:28.0453 1267 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/12/2024 15:43:28.0563 665 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 16 OR lnsTerId=16) 14/12/2024 15:48:30.0654 608 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2024-12-14 15:48:29' where traUID = 5602859294512770 and traStatus='V' and traEnabled=1 14/12/2024 15:49:18.1864 524 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2024-12-14 15:49:17' where payTraUID = 5509918051837250 and payStatus='V' and payEnabled=1 14/12/2024 16:08:39.5864 749 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 14/12/2024 16:10:11.2545 1526 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2024-12-14 16:10:09' where traUID = 5728493556021530 and traStatus='V' and traEnabled=1 14/12/2024 16:23:24.7206 1145 ms. EXEC: update tabTerminalReceipt set trcProgressive = 53462, trcLastPrinted = '2400753462', trcLastDate = '2024-12-14 16:23:23' where trcStatus='V' and trcTerId = 18 14/12/2024 16:25:55.9350 561 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-14 16:25:55','V',4991863826132490,2024,'2024-12-14 16:25:53','456385758200327001012999',2,2,2,'O','',0,'2024-12-14 16:25:55',1,'','',0) 14/12/2024 16:27:22.9217 525 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2024-12-14 16:27:22' where payTraUID = 4757921752002410 and payStatus='V' and payEnabled=1 14/12/2024 16:27:24.7557 744 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 14/12/2024 16:31:38.9828 700 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-14 16:31:38','V',5744175127270340,2024,'2024-12-14 16:31:37','456385949700327005012999',1,2,16,'I','',1,0,1,'','',4) 14/12/2024 16:33:49.1198 564 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/12/2024 16:37:39.5222 653 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 16 OR lnsTerId=16) 14/12/2024 16:38:23.3084 669 ms. EXEC: update tabTerminalReceipt set trcProgressive = 53471, trcLastPrinted = '2400753471', trcLastDate = '2024-12-14 16:38:22' where trcStatus='V' and trcTerId = 18 14/12/2024 16:46:18.9161 703 ms. EXEC: update payReceipt set recCreation = '2024-12-14 16:46:18',recModify = '2024-12-14 16:46:18',recUseId=0,recStatus='V' where recId = 332387 14/12/2024 16:46:20.1635 1140 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2024-12-14 16:46:18',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'; 14/12/2024 16:49:45.5046 1468 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2024-12-14 16:49:43' where traUID = 5584883743317170 and traStatus='V' and traEnabled=1 14/12/2024 16:50:18.7138 1104 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 14/12/2024 16:53:22.3213 509 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/12/2024 16:53:32.0307 963 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-14 16:53:31','V',5486796556040740,2024,'2024-12-14 16:53:30','456386081000327005012999',1,2,16,'I','',1,0,1,'','',4) 14/12/2024 16:54:44.7716 512 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/12/2024 16:56:51.4127 1089 ms. EXEC: insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2024-12-14 16:56:50',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-14 16:56:50',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'; 14/12/2024 17:01:13.1565 1181 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/12/2024 17:01:55.0187 507 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 14/12/2024 17:04:35.9376 842 ms. EXEC: insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2024-12-14 17:04:35',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-14 17:04:35',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'; 14/12/2024 17:12:08.3451 530 ms. EXEC: insert into paycash (casCreation,casModify,casUseId,casStatus,casUID,casTraUID,casYear,casDateTime,casIdTerminal,casCurrency,casNumber,casSingleAmount,casTotAmount,casType,casDescription) VALUES ('2024-12-14 17:12:07',0,0,'V',5699451494726890,4883771188827200,2024,'2024-12-14 17:12:07',3,'KES',1,100,100,'N',''); 14/12/2024 17:15:36.5788 712 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2024-12-14 17:15:35' where traUID = 4735363904920750 and traStatus='V' and traEnabled=1 14/12/2024 17:16:29.8829 1397 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2024-12-14 17:16:28',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'; 14/12/2024 17:20:55.9629 825 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-14 17:20:55',0,'V',4998565981062870,5048340106830440,2024,'2024-12-14 17:20:55',2,1,0,-1,'2024-12-14 18:20:55','S','KES',0,0,0,'','','',3,0,0) 14/12/2024 17:22:58.5609 740 ms. EXEC: update payInventory set invCreation = '2024-12-14 17:22:57',invModify = '2024-12-14 17:22:57',invUseId=0,invStatus='V' where invId = 225286 14/12/2024 17:23:00.5732 503 ms. EXECSCALAR: select count(0) as vTot from tabParameters where parPlateReading<>0 nr: 0 14/12/2024 17:25:33.0153 880 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/12/2024 17:26:45.1556 773 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2024-12-14 17:26:44',3,42101,0,100,1,100,1,'I','N'); update payCurInventory set curQuantity=round(curQuantity+1,5),curAmount=round(curAmount+100,5) where curTerId = 3 and curDevCode = 42101 and curChannelId = 1 and curValue = 100 and curType = 'N'; 14/12/2024 17:26:46.7754 1040 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/12/2024 17:28:32.0130 876 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/12/2024 17:31:04.8182 607 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/12/2024 17:32:31.4062 873 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 14/12/2024 17:34:25.2532 684 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/12/2024 17:34:53.3992 509 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/12/2024 17:52:57.3707 531 ms. EXEC: insert into payReceipt (recTraUID,recPayUID,recYear,recDateTime,recText,recInvalid) VALUES (4819870302217990,5338024741775860,2024,'2024-12-14 17:52:56',' Date: 12/14/2024 5:52:56 PM Code: 456386320200327005012999 Entry Date: 12/14/2024 5:33:22 PM Plate: Class: Cars Park: The Mall Gate: Entry 2 ______________________________ Total: 50.00 KES ______________________________ Paid: 50.00 KES __________ Change: 0.00 KES Type: Cash Dispozitiv: MPESA # 2400753486 ',0) 14/12/2024 18:18:23.8393 662 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 14/12/2024 18:22:14.5106 997 ms. EXEC: insert into abbPayment (payCreation,payCode,payAmount,payCredit,payPayUID,payCarId,payDateFrom,payDateTo) VALUES ('2024-12-14 18:22:13','0230004101216',0,0,5206909885537720,10,'0000-00-00 00:00:00','0000-00-00 00:00:00') 14/12/2024 18:27:31.5266 648 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2024-12-14 18:27:30' where traUID = 4773818841369640 and traStatus='V' and traEnabled=1 14/12/2024 18:27:51.4751 707 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 14/12/2024 18:47:02.9996 586 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/12/2024 18:52:44.5588 857 ms. OPEN: select sum(payPayed) as vTot,sum(payChange) as vChange from movTransit inner join payPayment on payPayment.payTraUID = movTransit.traUID LEFT JOIN tabTerminal on terId = payIdTerminal WHERE traCode = '456386519000327001012999' AND traStatus='V' AND payStatus='V' and (terType IS NULL OR terType<>3 OR (terType=3 and payType='P')) 14/12/2024 18:54:28.3718 814 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/12/2024 18:55:52.2949 519 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 14/12/2024 18:58:12.9914 876 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-14 18:58:12','V',4865295781000020,2024,'2024-12-14 18:58:11','456386519000327001012999',2,2,2,'O','',0,'2024-12-14 18:58:12',1,'','',0) 14/12/2024 18:58:26.9611 1062 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/12/2024 18:59:34.5930 617 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-14 18:59:33','V',5549103671276590,2024,'2024-12-14 18:59:32','456386590200327001012999',2,2,2,'O','',0,'2024-12-14 18:59:33',1,'','',0) 14/12/2024 19:03:35.4220 749 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/12/2024 19:11:11.2118 649 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/12/2024 19:20:28.9214 1289 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 14/12/2024 19:22:40.9141 688 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/12/2024 19:23:50.1138 1163 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-14 19:23:48','V',5484815474412090,2024,'2024-12-14 19:23:47','456386784200327001012999',2,2,2,'O','',0,'2024-12-14 19:23:48',1,'','',0) 14/12/2024 19:26:25.2554 956 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 14/12/2024 19:29:19.4421 1129 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2024-12-14 19:29:18',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'; 14/12/2024 19:32:44.1906 571 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 5 14/12/2024 19:35:48.3439 1099 ms. OPEN: select * from tabArea where areStatus='V' and areEnabled = 1 AND areId = 1 14/12/2024 19:46:36.6932 575 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/12/2024 19:46:49.7840 616 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/12/2024 19:49:59.8582 615 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2024-12-14 19:49:59' where traUID = 5308643288041600 and traStatus='V' and traEnabled=1 14/12/2024 19:50:51.7877 559 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 14/12/2024 19:53:29.9097 647 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-14 19:53:29','V',5731846226092250,2024,'2024-12-14 19:53:28','456387054800327001012999',2,2,2,'O','',0,'2024-12-14 19:53:29',1,'','',0) 14/12/2024 19:53:31.0971 826 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2024-12-14 19:53:30' where payTraUID = 5014142284286430 and payStatus='V' and payEnabled=1 14/12/2024 19:59:30.0881 652 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 14/12/2024 19:59:36.8498 863 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 14/12/2024 20:04:05.7954 675 ms. EXEC: update payReceipt set recCreation = '2024-12-14 20:04:05',recModify = '2024-12-14 20:04:05',recUseId=0,recStatus='V' where recId = 332472 14/12/2024 20:04:07.4703 1284 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2024-12-14 20:04:05',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-14 20:04:05',3,42101,0,200,-2,-400,1,'O','N'); update payCurInventory set curQuantity=round(curQuantity+-2,5),curAmount=round(curAmount+-400,5) where curTerId = 3 and curDevCode = 42101 and curChannelId = 1 and curValue = 200 and curType = 'N'; 14/12/2024 20:06:43.9191 694 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-14 20:06:43','V',4972104286183690,2024,'2024-12-14 20:06:42','456387240200327005012999',1,2,16,'I','',1,0,1,'','',4) 14/12/2024 20:24:07.5284 686 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-14 20:24:06','V',4643113706018830,2024,'2024-12-14 20:24:06','456387344600327005012999',1,2,16,'I','',1,0,1,'','',4) 14/12/2024 20:24:08.4194 889 ms. OPEN: select last_insert_id() as vLast 14/12/2024 20:39:35.8492 970 ms. EXEC: UPDATE payInventory SET invType='N' WHERE invType<>'N' AND invValue IN (100,200,500) AND invDevice IN (42102,42101,42001); 14/12/2024 20:42:42.5400 725 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-14 20:42:41','V',5308729598498560,2024,'2024-12-14 20:42:40','456386807900327005012999',2,2,2,'O','',0,'2024-12-14 20:42:41',1,'','',0) 14/12/2024 20:44:53.5036 522 ms. EXEC: UPDATE payInventory SET invType='N' WHERE invType<>'N' AND invValue IN (100,200,500) AND invDevice IN (42102,42101,42001); 14/12/2024 20:45:12.2497 874 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 3 14/12/2024 20:46:15.0088 567 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 2 OR lnsTerId=2) 14/12/2024 20:48:19.4088 647 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-14 20:48:18',0,'V',5684467509425170,5519854691205370,2024,'2024-12-14 20:48:18',18,1,0,4,'2024-12-14 21:03:18','C','KES',600,600,0,'','','',1,600,0,0,'',0,0) 14/12/2024 20:55:49.8777 804 ms. EXEC: UPDATE payInventory SET invType='N' WHERE invType<>'N' AND invValue IN (100,200,500) AND invDevice IN (42102,42101,42001); 14/12/2024 21:01:28.9429 529 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 14/12/2024 21:01:34.3950 823 ms. EXEC: UPDATE payInventory SET invType='N' WHERE invType<>'N' AND invValue IN (100,200,500) AND invDevice IN (42102,42101,42001); 14/12/2024 21:02:20.3098 908 ms. EXEC: update payReceipt set recCreation = '2024-12-14 21:02:19',recModify = '2024-12-14 21:02:19',recUseId=0,recStatus='V' where recId = 332502 14/12/2024 21:08:17.3115 940 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-14 21:08:16','V',4851669408755060,2024,'2024-12-14 21:08:15','456387505300327005012999',2,2,2,'O','',0,'2024-12-14 21:08:16',1,'','',0) 14/12/2024 21:10:25.5784 668 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2024-12-14 21:10:24' where payTraUID = 4760498958846320 and payStatus='V' and payEnabled=1 14/12/2024 21:20:38.2837 527 ms. EXEC: insert into payReceipt (recTraUID,recPayUID,recYear,recDateTime,recText,recInvalid) VALUES (5028117306588190,5649659953873210,2024,'2024-12-14 21:20:37','---------------------------------- %The Mall P0006032390 End of payment ---------------------------------- POF Entry : 12/14/2024 8:29:29 PM Date : 12/14/2024 9:20:36 PM Code : 456387376900327005012999 Total : 50.00 KES VAT 16% : 6.90 KES ---------------------------------- Paid : 100.00 KES Coin changed : 0.00 KES Note changed : 0.00 KES Not changed Note : 50.00 KES Coin : 0.00 KES Unavailable : 0.00 KES',0) 14/12/2024 21:20:59.9074 535 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 14/12/2024 21:21:00.6042 667 ms. EXEC: UPDATE payInventory SET invType='N' WHERE invType<>'N' AND invValue IN (100,200,500) AND invDevice IN (42102,42101,42001); 14/12/2024 21:29:18.6773 596 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-14 21:29:18','V',4883568507252310,2024,'2024-12-14 21:29:17','456387502700327005012999',2,2,2,'O','',0,'2024-12-14 21:29:18',1,'','',0) 14/12/2024 21:33:26.2731 1047 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 14/12/2024 21:33:29.3226 680 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/12/2024 21:34:34.3848 1515 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/12/2024 21:37:42.5860 581 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-14 21:37:42','V',5449467540828890,2024,'2024-12-14 21:37:41','456387786100327005012999',1,2,16,'I','',1,0,1,'','',4) 14/12/2024 21:38:31.4635 552 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 14/12/2024 21:44:19.5555 545 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/12/2024 21:57:23.9257 522 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/12/2024 21:59:02.0068 706 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 5 and terStatus='V' 14/12/2024 21:59:28.9641 801 ms. EXEC: insert into payReceipt (recTraUID,recPayUID,recYear,recDateTime,recText,recInvalid) VALUES (5744836970171010,5290452292467350,2024,'2024-12-14 21:59:28',' Date: 12/14/2024 9:59:27 PM Code: 456387495500327005012999 Entry Date: 12/14/2024 8:49:15 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 # 2400753543 ',0) 14/12/2024 21:59:41.7930 795 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2024-12-14 21:59:40' where traUID = 5288425408942850 and traStatus='V' and traEnabled=1 14/12/2024 21:59:47.8428 2564 ms. EXEC: UPDATE payInventory SET invType='N' WHERE invType<>'N' AND invValue IN (100,200,500) AND invDevice IN (42102,42101,42001); 14/12/2024 22:01:06.9134 595 ms. EXEC: update tabTerminalReceipt set trcProgressive = 17850, trcLastPrinted = '2400417850', trcLastDate = '2024-12-14 22:01:06' where trcStatus='V' and trcTerId = 4 14/12/2024 22:01:07.6172 701 ms. EXEC: insert into payReceipt (recTraUID,recPayUID,recYear,recDateTime,recText,recInvalid) VALUES (4635712598055890,4860292597306830,2024,'2024-12-14 22:01:06',' Date: 12/14/2024 9:57:17 PM Code: 456387473600327005012999 Entry Date: 12/14/2024 8:45:36 PM Plate: Class: Cars Park: The Mall Gate: Entry 2 ______________________________ Total: 100.00 KES ______________________________ Paid: 100.00 KES __________ Change: 0.00 KES Type: Credit Card Dispozitiv: Manual Cashier 1 # 2400417850 ',0) 14/12/2024 22:02:30.0257 907 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/12/2024 22:02:50.2636 1320 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/12/2024 22:05:28.3653 732 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/12/2024 22:07:29.9344 1571 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 14/12/2024 22:09:23.7026 1258 ms. EXEC: update payReceipt set recCreation = '2024-12-14 22:09:22',recModify = '2024-12-14 22:09:22',recUseId=0,recStatus='V' where recId = 332539 14/12/2024 22:12:29.6758 689 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/12/2024 22:20:25.4112 625 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-14 22:20:24','V',5487449513546790,2024,'2024-12-14 22:20:23','456388042300327001012999',1,2,1,'I','',1,0,1,'','0230003944081',15,0) 14/12/2024 22:20:40.1699 1395 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/12/2024 22:24:54.8148 1128 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/12/2024 22:35:12.1021 849 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 14/12/2024 22:35:30.4528 1062 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/12/2024 22:38:09.1416 1123 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/12/2024 22:38:38.7180 657 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/12/2024 22:38:55.4008 798 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/12/2024 23:02:25.8119 833 ms. OPEN: select count(payId) as Tot,0 as payUID,sum(payPayed) as payPayed,sum(payChange) as payChange,payAmount,traUIDGroup,traType,traClass,traIdTerminal,traDiscountValue,traDiscountType,traCarId,payIdEvent,payType,payCardType from payPayment LEFT join movtransit on trauid = payTraUID LEFT JOIN payReport ON repPayUID = payUID AND repStatus='V' where payStatus = 'V' and (payType='C' or payType='P') and payUseId = 9 and payIdEvent<90 and repPayUID IS NULL and (traCarId is null or traCarId=0 or traCarId in (select carId from abbCards inner join abbsubscriptions on subId= carSubId where carStatus='V' and subStatus='V' and subAbbType<>5)) group by traUIDGroup,payAmount,payIdEvent,payType,payCardType,traType,traIdTerminal,traDiscountValue,traDiscountType,traCarId order by traUIDGroup,payAmount, traType, traDiscountValue, traDiscountType 14/12/2024 23:41:05.8763 1969 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/12/2024 23:52:17.4036 590 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2024-12-14 23:52:16' where traUID = 5294287637303290 and traStatus='V' and traEnabled=1