31/01/2025 06:29:18.8147 787 ms. OPEN: select traId,traDateTime,traEnabled,traDisableTime,traCode,traBadge,traCarId,traAreId,traIdTerminal from movtransit where traStatus='V' and traDirection = 'I' and traCarId = 26 order by traDateTime desc,traId desc 31/01/2025 09:31:00.1119 599 ms. OPEN: select traId,traDateTime,traEnabled,traDisableTime,traCode,traBadge,traCarId,traAreId,traIdTerminal from movtransit where traStatus='V' and traDirection = 'I' and traCarId = 25 order by traDateTime desc,traId desc 31/01/2025 09:50:12.6816 732 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2025-01-31 09:50:11',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'; 31/01/2025 09:51:59.1127 2513 ms. EXECSCALAR: SELECT count(*) FROM payinventory WHERE invValue<>0 AND invType='' nr: 0 31/01/2025 09:52:01.5204 2404 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 31/01/2025 09:52:02.5060 985 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); 31/01/2025 09:53:46.7236 1736 ms. OPEN: select traId,traDateTime,traEnabled,traDisableTime,traCode,traBadge,traCarId,traAreId,traIdTerminal from movtransit where traStatus='V' and traDirection = 'I' and traCarId = 92 order by traDateTime desc,traId desc 31/01/2025 09:59:41.7090 640 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 31/01/2025 10:01:10.0258 3983 ms. OPEN: select traId,traDateTime,traEnabled,traDisableTime,traCode,traBadge,traCarId,traAreId,traIdTerminal from movtransit where traStatus='V' and traDirection = 'I' and traCarId = 10 order by traDateTime desc,traId desc 31/01/2025 10:02:07.2936 602 ms. OPEN: select traId,traDateTime,traEnabled,traDisableTime,traCode,traBadge,traCarId,traAreId,traIdTerminal from movtransit where traStatus='V' and traDirection = 'I' and traCarId = 103 order by traDateTime desc,traId desc 31/01/2025 10:06:25.7177 2092 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 2 31/01/2025 10:06:25.9328 1548 ms. EXEC: UPDATE payInventory SET invType='N' WHERE invType<>'N' AND invValue IN (100,200,500) AND invDevice IN (42102,42101,42001); 31/01/2025 10:08:18.1388 1466 ms. OPEN: select traId,traDateTime,traEnabled,traDisableTime,traCode,traBadge,traCarId,traAreId,traIdTerminal from movtransit where traStatus='V' and traDirection = 'I' and traCarId = 8 order by traDateTime desc,traId desc 31/01/2025 10:08:59.0975 2317 ms. OPEN: select traId,traDateTime,traEnabled,traDisableTime,traCode,traBadge,traCarId,traAreId,traIdTerminal from movtransit where traStatus='V' and traDirection = 'I' and traCarId = 99 order by traDateTime desc,traId desc 31/01/2025 10:10:23.8820 582 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 31/01/2025 10:10:32.2526 686 ms. OPEN: show columns from tabParameters where Field = 'parAllowNegativePlaces' 31/01/2025 10:10:33.1362 554 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 31/01/2025 10:11:48.4172 524 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 31/01/2025 10:14:04.0731 560 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 31/01/2025 10:19:13.0543 10047 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 31/01/2025 10:21:45.0953 594 ms. OPEN: show columns from tabParameters where Field = 'parUseCulture' 31/01/2025 10:22:13.1273 7379 ms. OPEN: select traId,traDateTime,traEnabled,traDisableTime,traCode,traBadge,traCarId,traAreId,traIdTerminal from movtransit where traStatus='V' and traDirection = 'I' and traCarId = 15 order by traDateTime desc,traId desc 31/01/2025 10:27:38.3396 522 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 31/01/2025 10:27:38.3696 598 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 31/01/2025 10:29:44.3379 26588 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 = 12 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 31/01/2025 10:30:12.9353 563 ms. OPEN: select 1 as Tot,payUID,payPayed,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 = 12 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)) order by traUIDGroup,payAmount, traType, traDiscountValue, traDiscountType 31/01/2025 10:32:09.8995 625 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 31/01/2025 10:36:21.8311 516 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 31/01/2025 10:37:51.1986 534 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 31/01/2025 10:42:48.3999 551 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 31/01/2025 10:43:27.4333 1079 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 16 OR lnsTerId=16) 31/01/2025 10:47:56.6967 573 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 31/01/2025 10:48:13.3100 888 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 31/01/2025 10:49:18.4931 646 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 31/01/2025 10:51:44.9143 1251 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 31/01/2025 10:53:07.6913 705 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 ('2025-01-31 10:52:33',9,'V',5310055056817860,4675525976973740,2025,'2025-01-31 10:52:33',4,1,0,4,'2025-01-31 11:07:33','P','KES',100,100,0,'','','',1,100,0,0,'',0,0) 31/01/2025 10:53:08.6910 686 ms. EXEC: update opeActivities set acvFstPayId = (case acvFstPayId when 0 then 400475 else acvFstPayId end),acvLstPayId = 400475 where acvSftId = 872 and acvCodeId = 3 31/01/2025 10:54:15.4232 580 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 31/01/2025 10:56:39.9171 1203 ms. EXEC: update paycash set casCreation = '2025-01-31 10:56:38',casModify = '2025-01-31 10:56:38',casUseId=0,casStatus='V' where casId = 207294 31/01/2025 10:56:53.7915 607 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 31/01/2025 10:57:05.6165 836 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 31/01/2025 10:57:22.1937 1617 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 31/01/2025 10:57:25.8982 506 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 31/01/2025 10:57:46.9755 560 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 31/01/2025 10:57:47.2967 616 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 31/01/2025 10:58:04.9166 673 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 31/01/2025 10:59:21.0862 727 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 31/01/2025 10:59:26.2177 717 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 31/01/2025 11:00:14.2552 530 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 31/01/2025 11:00:16.5228 1217 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 (WAIT TIME 1 ms.) 31/01/2025 11:00:51.1502 607 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 ('2025-01-31 11:00:50',0,'V',5456040752023210,4703480563044730,2025,'2025-01-31 11:00:50',18,1,0,4,'2025-01-31 11:15:50','C','KES',50,50,0,'','','',1,50,0,0,'',0,0) 31/01/2025 11:00:54.3754 2583 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 31/01/2025 11:02:13.6041 606 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 31/01/2025 11:02:14.2455 578 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 31/01/2025 11:03:31.6930 648 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,'2025-01-31 11:03:31','V',5208858226017770,2025,'2025-01-31 11:03:30','456863825000327005012999',2,2,2,'O','',0,'2025-01-31 11:03:31',1,'','',0) 31/01/2025 11:04:44.6213 833 ms. EXEC: insert into movtransit (traUseId,traCreation,traStatus,traUID,traYear,traDateTime,traCode,traType,traClass,traIdTerminal,traDirection,traPlate,traEnabled,traDisableTime,traAreId,traNotes,traBadge,traTarId) VALUES (0,'2025-01-31 11:04:43','V',5366519589388010,2025,'2025-01-31 11:04:43','456863269800327005012999',2,2,2,'O','',0,'2025-01-31 11:04:43',1,'','',0) 31/01/2025 11:04:45.6060 750 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 31/01/2025 11:05:57.9480 1191 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 1 OR lnsTerId=1) 31/01/2025 11:06:31.1355 989 ms. EXEC: insert into movtransit (traUseId,traCreation,traStatus,traUID,traYear,traDateTime,traCode,traType,traClass,traIdTerminal,traDirection,traPlate,traEnabled,traDisableTime,traAreId,traNotes,traBadge,traTarId) VALUES (0,'2025-01-31 11:06:30','V',5361488234993540,2025,'2025-01-31 11:06:29','456863854200327001012999',2,2,2,'O','',0,'2025-01-31 11:06:30',1,'','',0) 31/01/2025 11:07:13.0839 707 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 31/01/2025 11:07:18.1083 840 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,'2025-01-31 11:07:17','V',5197715575457280,2025,'2025-01-31 11:07:15','456863668700327005012999',2,2,2,'O','',0,'2025-01-31 11:07:17',1,'','',0) 31/01/2025 11:07:35.0107 924 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 31/01/2025 11:07:35.0117 919 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 6 31/01/2025 11:08:18.6263 1570 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 31/01/2025 11:10:01.6330 908 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 31/01/2025 11:10:32.6511 730 ms. EXECSCALAR: select count(*) from information_schema.tables where table_schema= 'wisepark_0327' and table_name= 'payInvoiceFtp' nr: 1 31/01/2025 11:10:33.4826 629 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 31/01/2025 11:12:00.5776 516 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 31/01/2025 11:12:58.1276 518 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2025-01-31 11:12:57' where traUID = 4854957345858040 and traStatus='V' and traEnabled=1 31/01/2025 11:13:04.3958 613 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 31/01/2025 11:15:16.3972 2099 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2025-01-31 11:15:13',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 ('2025-01-31 11:15:13',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'; 31/01/2025 11:15:25.4694 725 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 2 and terStatus='V' 31/01/2025 11:15:30.5578 1216 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,'2025-01-31 11:15:29','V',5155090647412480,2025,'2025-01-31 11:15:28','456863918000327005012999',2,2,2,'O','',0,'2025-01-31 11:15:29',1,'','',0) 31/01/2025 11:15:31.5655 609 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 31/01/2025 11:15:35.8834 571 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 31/01/2025 11:17:05.6752 587 ms. EXEC: insert into movtransit (traUseId,traCreation,traStatus,traUID,traYear,traDateTime,traCode,traType,traClass,traIdTerminal,traDirection,traPlate,traEnabled,traDisableTime,traAreId,traNotes,traBadge,traTarId) VALUES (0,'2025-01-31 11:17:05','V',4918483675256490,2025,'2025-01-31 11:17:02','456864062200327005012999',1,2,16,'I','',1,0,1,'','',4) 31/01/2025 11:18:07.9744 560 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 31/01/2025 11:21:52.7297 543 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 31/01/2025 11:21:52.7857 645 ms. EXEC: insert into movOperator (opeCreation,opeTerId,opeUseId,opeDateTime,opeCode,opeDescription) VALUES ('2025-01-31 11:21:52',17,12,'2025-01-31 11:21:52','456863852800327005012999','Pagato (Contanti ) Biglietto ') 31/01/2025 11:22:50.1485 1367 ms. EXECSCALAR: select count(*) from information_schema.tables where table_schema= 'wisepark_0327' and table_name= 'payInvoiceFtp' nr: 1 31/01/2025 11:22:52.1409 1053 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 31/01/2025 11:22:53.2616 867 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 31/01/2025 11:22:55.6863 624 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 31/01/2025 11:23:15.8179 1072 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,'2025-01-31 11:23:14','V',5334121823426990,2025,'2025-01-31 11:23:13','456863852800327005012999',2,2,2,'O','',0,'2025-01-31 11:23:14',1,'','',0) 31/01/2025 11:23:22.0381 592 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 31/01/2025 11:23:22.3654 684 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 31/01/2025 11:23:41.3682 980 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 31/01/2025 11:26:00.4354 753 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,'2025-01-31 11:25:59','V',5112549294771050,2025,'2025-01-31 11:25:58','456864115800327005012999',1,2,16,'I','',1,0,1,'','0230003939786',160,0) 31/01/2025 11:26:05.6800 619 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 31/01/2025 11:26:46.7418 938 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 ('2025-01-31 11:26:43',0,'V',5286969188769620,5214028116021680,2025,'2025-01-31 11:26:43',3,1,0,4,'2025-01-31 11:41:43','C','KES',50,50,0,'',' ',' ',1,50,0,0,'',0,0) 31/01/2025 11:28:05.3320 520 ms. EXEC: update abbCards set carLastDate = '2025-01-31 11:28:04',carLastDirection='I' where carStatus='V' and carId = 92 31/01/2025 11:28:18.0836 791 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2025-01-31 11:28:17',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'; 31/01/2025 11:28:35.6946 798 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 31/01/2025 11:29:03.8516 850 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 ('2025-01-31 11:29:00',0,'V',5467287735646540,5681168456318830,2025,'2025-01-31 11:29:00',3,1,0,4,'2025-01-31 11:44:00','C','KES',50,100,50,'',' ',' ',1,50,0,0,'',0,0) 31/01/2025 11:29:06.6796 1062 ms. EXEC: insert into payReceipt (recTraUID,recPayUID,recYear,recDateTime,recText,recInvalid) VALUES (4676431659369760,5251611034197950,2025,'2025-01-31 11:29:05',' Date: 1/31/2025 11:28:30 AM Code: 456863694500327005012999 Entry Date: 1/31/2025 10:15:45 AM 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 # 2500401374 ',0) 31/01/2025 11:29:44.9565 588 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 31/01/2025 11:30:11.2403 811 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 31/01/2025 11:31:22.2494 745 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 31/01/2025 11:31:44.1522 704 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2025-01-31 11:31:43',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 ('2025-01-31 11:31:43',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'; 31/01/2025 11:34:09.1734 516 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 31/01/2025 11:34:32.8805 765 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2025-01-31 11:34:31' where traUID = 5317790306003050 and traStatus='V' and traEnabled=1 31/01/2025 11:34:56.0712 1231 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 31/01/2025 11:36:07.0162 528 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 31/01/2025 11:39:09.0835 845 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2025-01-31 11:39:07' where traUID = 5282976080216180 and traStatus='V' and traEnabled=1 31/01/2025 11:39:17.4362 754 ms. EXECSCALAR: select count(*) from information_schema.tables where table_schema= 'wisepark_0327' and table_name= 'payInvoiceFtp' nr: 1 31/01/2025 11:39:53.3865 1715 ms. OPEN: show columns from tabParameters where Field = 'parPlatePercentCustomers' 31/01/2025 11:39:54.6844 715 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 31/01/2025 11:40:10.4541 538 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 31/01/2025 11:41:45.6576 730 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 31/01/2025 11:42:50.9468 581 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 2 OR lnsTerId=2) 31/01/2025 11:44:49.4721 1002 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 31/01/2025 11:44:55.4001 1472 ms. EXECSCALAR: select count(*) from information_schema.tables where table_schema= 'wisepark_0327' and table_name= 'payInvoiceFtp' nr: 1 31/01/2025 11:45:07.3102 1039 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 ('2025-01-31 11:45:06',0,'V',5305632221105110,4993242179288870,2025,'2025-01-31 11:45:06',2,1,0,-1,'2025-01-31 12:45:06','S','KES',50,50,0,'','','',3,50,0,0,'',0,0) 31/01/2025 11:45:11.9623 874 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 1 OR lnsTerId=1) 31/01/2025 11:45:22.5695 538 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 5 and terStatus='V' 31/01/2025 11:46:13.6301 3207 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2025-01-31 11:46:10' where payTraUID = 5222037149507980 and payStatus='V' and payEnabled=1 31/01/2025 11:51:17.5149 1215 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 31/01/2025 11:51:55.6737 518 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,'2025-01-31 11:51:55','V',4660835613202620,2025,'2025-01-31 11:51:54','456864271400327005012999',1,2,16,'I','',1,0,1,'','',4) 31/01/2025 11:52:14.6016 580 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 31/01/2025 11:53:00.2124 760 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 31/01/2025 11:55:06.0136 1387 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2025-01-31 11:55:04' where payTraUID = 5336168377037990 and payStatus='V' and payEnabled=1 31/01/2025 11:55:16.9380 591 ms. EXEC: UPDATE payInventory SET invType='N' WHERE invType<>'N' AND invValue IN (100,200,500) AND invDevice IN (42102,42101,42001); 31/01/2025 11:57:11.9239 616 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,'2025-01-31 11:57:11','V',5479029672669480,2025,'2025-01-31 11:57:09','456863283600327005012999',2,2,2,'O','',0,'2025-01-31 11:57:11',1,'','',0) 31/01/2025 11:57:39.0963 755 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 ('2025-01-31 11:57:38',0,'V',5049537644296600,5582730860185030,2025,'2025-01-31 11:57:38',18,1,0,4,'2025-01-31 12:12:38','C','KES',50,50,0,'','','',1,50,0,0,'',0,0) 31/01/2025 11:57:44.2128 808 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 31/01/2025 12:02:54.9342 585 ms. OPEN: select * from tabArea where areStatus='V' and areEnabled = 1 AND areId = 1 31/01/2025 12:02:59.0770 1121 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 31/01/2025 12:02:59.8446 738 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2025-01-31 12:02:59' where payTraUID = 4743178014869870 and payStatus='V' and payEnabled=1 31/01/2025 12:03:05.4083 1092 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 31/01/2025 12:04:25.5916 535 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 31/01/2025 12:05:34.4653 880 ms. EXEC: update tabTerminalReceipt set trcProgressive = 1378, trcLastPrinted = '2500401378', trcLastDate = '2025-01-31 12:05:33' where trcStatus='V' and trcTerId = 4 31/01/2025 12:06:49.3750 719 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 ('2025-01-31 12:06:48',0,'V',5289117618847180,4913947645481680,2025,'2025-01-31 12:06:48',2,1,0,-1,'2025-01-31 13:06:48','S','KES',0,0,0,'','','',3,0,0) 31/01/2025 12:06:50.9251 1237 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2025-01-31 12:06:49' where traUID = 4913947645481680 and traStatus='V' and traEnabled=1 31/01/2025 12:07:17.5211 745 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 31/01/2025 12:07:39.9062 1395 ms. OPEN: select * from tabArea where areStatus='V' and areEnabled = 1 AND areId = 1 31/01/2025 12:08:27.6456 793 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 31/01/2025 12:11:00.8984 571 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 31/01/2025 12:11:16.5920 674 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 31/01/2025 12:14:06.1628 595 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 31/01/2025 12:16:02.0923 599 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 31/01/2025 12:17:15.9003 1109 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 ('2025-01-31 12:17:14',0,'V',5495878183865500,4644271941637020,2025,'2025-01-31 12:17:14',18,1,0,4,'2025-01-31 12:32:14','C','KES',50,50,0,'','','',1,50,0,0,'',0,0) 31/01/2025 12:17:16.8750 506 ms. EXEC: update payReceipt set recCreation = '2025-01-31 12:17:16',recModify = '2025-01-31 12:17:16',recUseId=0,recStatus='V' where recId = 347609 31/01/2025 12:19:13.8952 696 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 31/01/2025 12:19:47.6951 556 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 31/01/2025 12:22:34.7042 1239 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 16 OR lnsTerId=16) 31/01/2025 12:27:10.4270 678 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 31/01/2025 12:28:36.6084 745 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 31/01/2025 12:29:24.4427 731 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 ('2025-01-31 12:29:22',0,'V',4832269545615570,5717575273369210,2025,'2025-01-31 12:29:22',3,1,0,4,'2025-01-31 12:44:22','C','KES',50,50,0,'',' ',' ',1,50,0,0,'',0,0) 31/01/2025 12:29:25.3283 580 ms. EXEC: update payReceipt set recCreation = '2025-01-31 12:29:24',recModify = '2025-01-31 12:29:24',recUseId=0,recStatus='V' where recId = 347618 31/01/2025 12:31:20.3833 922 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2025-01-31 12:31:19' where traUID = 5376108185067510 and traStatus='V' and traEnabled=1 31/01/2025 12:31:27.8813 799 ms. EXEC: UPDATE payInventory SET invType='N' WHERE invType<>'N' AND invValue IN (100,200,500) AND invDevice IN (42102,42101,42001); 31/01/2025 12:32:51.3189 543 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 31/01/2025 12:33:03.3230 531 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 ('2025-01-31 12:33:01',0,'V',5627579348946540,5697596850865170,2025,'2025-01-31 12:33:01',3,1,0,4,'2025-01-31 12:48:01','C','KES',50,50,0,'',' ',' ',1,50,0,0,'',0,0) 31/01/2025 12:33:37.2590 648 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 31/01/2025 12:37:52.7890 531 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 31/01/2025 12:37:58.5710 823 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2025-01-31 12:37:57' where payTraUID = 5717575273369210 and payStatus='V' and payEnabled=1 31/01/2025 12:37:59.8178 1241 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2025-01-31 12:37:57' where traUID = 5717575273369210 and traStatus='V' and traEnabled=1 31/01/2025 12:38:18.7136 657 ms. EXEC: insert into abbPayment (payCreation,payCode,payAmount,payCredit,payPayUID,payCarId,payDateFrom,payDateTo) VALUES ('2025-01-31 12:38:18','0810007113876',0,0,5660058589188540,103,'0000-00-00 00:00:00','0000-00-00 00:00:00') 31/01/2025 12:38:19.9865 1068 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 ('2025-01-31 12:38:18',0,'V',5660058589188540,5063342288444610,2025,'2025-01-31 12:38:18',2,1,0,-1,'2025-01-31 13:38:18','S','KES',0,0,0,'','','',3,0,0) 31/01/2025 12:38:21.7747 668 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2025-01-31 12:38:21' where payTraUID = 5063342288444610 and payStatus='V' and payEnabled=1 31/01/2025 12:39:27.7584 794 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 31/01/2025 12:40:04.9596 2541 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 31/01/2025 12:42:50.3976 509 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2025-01-31 12:42:49',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'; 31/01/2025 12:46:35.8373 1125 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 31/01/2025 12:47:28.7211 1330 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,'2025-01-31 12:47:27','V',5609578236279720,2025,'2025-01-31 12:47:26','456864604600327005012999',1,2,16,'I','',1,0,1,'','',4) 31/01/2025 12:47:30.3052 595 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 ('2025-01-31 12:46:55',9,'V',4709744807184370,5419039402948340,2025,'2025-01-31 12:46:55',4,1,0,4,'2025-01-31 13:01:55','P','KES',50,50,0,'','','',1,50,0,0,'',0,0) 31/01/2025 12:47:39.4724 1443 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 31/01/2025 12:47:44.9761 566 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 5 31/01/2025 12:47:47.1956 772 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 2 and terStatus='V' 31/01/2025 12:49:15.8687 1370 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 31/01/2025 12:51:41.4673 836 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,'2025-01-31 12:51:40','V',4887655654059650,2025,'2025-01-31 12:51:39','456864453700327005012999',2,2,2,'O','',0,'2025-01-31 12:51:40',1,'','',0) 31/01/2025 12:54:36.1291 853 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 31/01/2025 12:55:10.5464 605 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 31/01/2025 12:55:26.8945 1162 ms. EXEC: update tabTerminalReceipt set trcProgressive = 4394, trcLastPrinted = '2500704394', trcLastDate = '2025-01-31 12:55:25' where trcStatus='V' and trcTerId = 18 31/01/2025 12:56:00.9346 533 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 31/01/2025 12:56:01.1527 759 ms. EXECSCALAR: select count(*) from information_schema.tables where table_schema= 'wisepark_0327' and table_name= 'movTransitId' nr: 1 31/01/2025 12:56:26.0135 14248 ms. OPEN: select count(payId) as Tot,0 as payUID,sum(payPayed) as payPayed,sum(payChange) as payChange,payAmount,traUIDGroup,traType,traClass,traIdTerminal,traDiscountValue,traDiscountType,traCarId,payIdEvent,payType,payCardType from payPayment LEFT join movtransit on trauid = payTraUID LEFT JOIN payReport ON repPayUID = payUID AND repStatus='V' where payStatus = 'V' and (payType='C' or payType='P') and payUseId = 6 and payIdEvent<90 and repPayUID IS NULL and (traCarId is null or traCarId=0 or traCarId in (select carId from abbCards inner join abbsubscriptions on subId= carSubId where carStatus='V' and subStatus='V' and subAbbType<>5)) group by traUIDGroup,payAmount,payIdEvent,payType,payCardType,traType,traIdTerminal,traDiscountValue,traDiscountType,traCarId order by traUIDGroup,payAmount, traType, traDiscountValue, traDiscountType 31/01/2025 12:58:11.7432 981 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 31/01/2025 12:58:29.2350 526 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 31/01/2025 12:59:18.0230 693 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 1 OR lnsTerId=1) 31/01/2025 12:59:26.3717 1126 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 31/01/2025 13:00:51.6755 692 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,'2025-01-31 13:00:50','V',5674293563335030,2025,'2025-01-31 13:00:50','456864685000327005012999',1,2,16,'I','',1,0,1,'','',4) 31/01/2025 13:01:42.7641 645 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,'2025-01-31 13:01:42','V',5412470386872640,2025,'2025-01-31 13:01:41','456864690100327005012999',1,2,16,'I','',1,0,1,'','',4) 31/01/2025 13:02:37.0859 733 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,'2025-01-31 13:02:36','V',4747743320168970,2025,'2025-01-31 13:02:36','456864695600327005012999',1,2,16,'I','',1,0,1,'','',4) 31/01/2025 13:05:10.9391 608 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2025-01-31 13:05:10' where traUID = 5114712175763520 and traStatus='V' and traEnabled=1 31/01/2025 13:06:01.1301 567 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 ('2025-01-31 13:06:00',0,'V',5763140957958480,4871021243546360,2025,'2025-01-31 13:06:00',18,1,0,4,'2025-01-31 13:21:00','C','KES',50,50,0,'','','',1,50,0,0,'',0,0) 31/01/2025 13:07:05.8289 743 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,'2025-01-31 13:07:05','V',4633984908742910,2025,'2025-01-31 13:07:04','456864599400327005012999',2,2,2,'O','',0,'2025-01-31 13:07:05',1,'','',0) 31/01/2025 13:07:07.8452 1401 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2025-01-31 13:07:06' where traUID = 4871021243546360 and traStatus='V' and traEnabled=1 31/01/2025 13:07:11.3546 720 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 31/01/2025 13:09:16.8406 911 ms. OPEN: select 1 as Tot,payUID,payPayed,payChange,payAmount,traUIDGroup,traType,traClass,traIdTerminal,traDiscountValue,traDiscountType,traCarId,payIdEvent,payType,payCardType from payPayment LEFT join movtransit on trauid = payTraUID LEFT JOIN payReport ON repPayUID = payUID AND repStatus='V' where payStatus = 'V' and (payType='C' or payType='P') and payUseId = 6 and payIdEvent<90 and repPayUID IS NULL and (traCarId is null or traCarId=0 or traCarId in (select carId from abbCards inner join abbsubscriptions on subId= carSubId where carStatus='V' and subStatus='V' and subAbbType<>5)) order by traUIDGroup,payAmount, traType, traDiscountValue, traDiscountType 31/01/2025 13:10:09.3141 604 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 31/01/2025 13:10:42.4266 568 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 31/01/2025 13:11:29.6746 921 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 31/01/2025 13:13:19.5220 754 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 31/01/2025 13:13:22.4269 653 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 31/01/2025 13:17:10.9647 1275 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2025-01-31 13:17:09' where traUID = 5326033601980630 and traStatus='V' and traEnabled=1 31/01/2025 13:17:40.0174 596 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 31/01/2025 13:17:50.7266 540 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 31/01/2025 13:18:58.8948 543 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 31/01/2025 13:19:49.7032 586 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 31/01/2025 13:20:54.8543 657 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 31/01/2025 13:21:16.8602 729 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 31/01/2025 13:28:57.5122 648 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2025-01-31 13:28:56',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 ('2025-01-31 13:28:56',3,42101,0,200,-1,-200,1,'O','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'; 31/01/2025 13:32:15.1991 804 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 31/01/2025 13:35:19.1084 1163 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 31/01/2025 13:37:18.7374 1125 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 ('2025-01-31 13:37:17',0,'V',5185796865015030,5480064467702610,2025,'2025-01-31 13:37:17',2,1,0,-1,'2025-01-31 14:37:17','S','KES',0,0,0,'','','',3,0,0) 31/01/2025 13:37:59.7362 569 ms. EXECSCALAR: select sum(parAllowNegativePlaces) from tabParameters where parStatus='V' order by parId desc limit 1 nr: 0 31/01/2025 13:38:59.9190 4273 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 ('2025-01-31 13:38:53',0,'V',5342414496411890,4866889689317190,2025,'2025-01-31 13:38:53',3,1,0,4,'2025-01-31 13:53:53','C','KES',50,100,50,'',' ',' ',1,50,0,0,'',0,0) (WAIT TIME 110 ms.) 31/01/2025 13:39:32.7542 583 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,'2025-01-31 13:39:32','V',5051973212447990,2025,'2025-01-31 13:39:31','456864834600327005012999',2,2,2,'O','',0,'2025-01-31 13:39:32',1,'','',0) 31/01/2025 13:40:24.2491 581 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 31/01/2025 13:40:31.6151 694 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 = '456864922900327005012999' AND traStatus='V' AND payStatus='V' and (terType IS NULL OR terType<>3 OR (terType=3 and payType='P')) 31/01/2025 13:43:25.5449 625 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 31/01/2025 13:52:50.4084 502 ms. OPEN: select * from tabArea where areStatus='V' and areEnabled = 1 AND areId = 1 31/01/2025 13:52:50.4134 502 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 3 OR lnsTerId=3) 31/01/2025 13:56:36.9298 809 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 31/01/2025 13:56:49.8246 880 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 31/01/2025 13:57:40.6870 544 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,'2025-01-31 13:57:40','V',4812417358068980,2025,'2025-01-31 13:57:39','456865025900327005012999',1,2,16,'I','',1,0,1,'','',4) 31/01/2025 13:58:57.7532 618 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 31/01/2025 14:00:09.4888 616 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 31/01/2025 14:01:01.6311 1063 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 31/01/2025 14:01:11.1185 559 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 2 and terStatus='V' 31/01/2025 14:01:55.9039 568 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2025-01-31 14:01:54',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 ('2025-01-31 14:01:54',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'; 31/01/2025 14:04:12.8046 741 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 31/01/2025 14:04:24.3074 1180 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 ('2025-01-31 14:03:48',6,'V',5743513245438440,5356565578014940,2025,'2025-01-31 14:03:48',4,1,0,4,'2025-01-31 14:18:48','P','KES',100,100,0,'','','',1,100,0,0,'',0,0) 31/01/2025 14:04:25.0929 552 ms. EXEC: update opeActivities set acvFstPayId = (case acvFstPayId when 0 then 400579 else acvFstPayId end),acvLstPayId = 400579 where acvSftId = 891 and acvCodeId = 3 31/01/2025 14:04:38.0337 666 ms. EXEC: update tabTerminalReceipt set trcProgressive = 1386, trcLastPrinted = '2500401386', trcLastDate = '2025-01-31 14:04:37' where trcStatus='V' and trcTerId = 4 31/01/2025 14:06:11.6497 608 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 31/01/2025 14:08:29.2338 2156 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,'2025-01-31 14:08:27','V',5442921619811260,2025,'2025-01-31 14:08:26','456864267900327005012999',2,2,2,'O','',0,'2025-01-31 14:08:27',1,'','',0) 31/01/2025 14:08:30.2915 888 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 31/01/2025 14:08:51.4268 2146 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 2 31/01/2025 14:10:00.8478 603 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 31/01/2025 14:10:06.0904 792 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 31/01/2025 14:13:12.1884 691 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 31/01/2025 14:14:37.9185 668 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 31/01/2025 14:14:41.1257 3073 ms. EXEC: UPDATE payCash SET casType='N' WHERE casType<>'N' AND ABS(casSingleAmount) IN (100,200,500); (WAIT TIME 99 ms.) 31/01/2025 14:14:52.6585 895 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 1 OR lnsTerId=1) 31/01/2025 14:15:34.4408 903 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 31/01/2025 14:16:00.5104 832 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 ('2025-01-31 14:15:58',0,'V',5416626567565780,5562199002482210,2025,'2025-01-31 14:15:58',3,1,0,4,'2025-01-31 14:30:58','C','KES',50,100,50,'',' ',' ',1,50,0,0,'',0,0) 31/01/2025 14:16:59.3303 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 ('2025-01-31 14:16:58',0,'V',5711632990838440,4799008853656740,2025,'2025-01-31 14:16:58',18,1,0,4,'2025-01-31 14:31:58','C','KES',50,50,0,'','','',1,50,0,0,'',0,0) 31/01/2025 14:16:59.8526 522 ms. EXEC: DELETE FROM tmppay WHERE tmpCode = '456864996300327005012999' 31/01/2025 14:17:18.7534 2041 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 31/01/2025 14:17:18.8425 727 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 31/01/2025 14:17:18.8695 670 ms. EXEC: insert into movtransit (traUseId,traCreation,traStatus,traUID,traYear,traDateTime,traCode,traType,traClass,traIdTerminal,traDirection,traPlate,traEnabled,traDisableTime,traAreId,traNotes,traBadge,traTarId) VALUES (0,'2025-01-31 14:17:18','V',5010575699202120,2025,'2025-01-31 14:17:16','456865143600327005012999',1,2,16,'I','',1,0,1,'','',4) 31/01/2025 14:18:01.8456 519 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,'2025-01-31 14:18:01','V',4944656737381050,2025,'2025-01-31 14:18:01','456865025900327005012999',2,2,2,'O','',0,'2025-01-31 14:18:01',1,'','',0) 31/01/2025 14:18:16.7437 1116 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 31/01/2025 14:18:25.6767 810 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,'2025-01-31 14:18:24','V',5710295524358880,2025,'2025-01-31 14:18:23','456864996300327005012999',2,2,2,'O','',0,'2025-01-31 14:18:24',1,'','',0) 31/01/2025 14:18:27.0397 656 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 31/01/2025 14:18:27.7101 569 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 31/01/2025 14:18:27.9813 2007 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 31/01/2025 14:18:28.6257 638 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2025-01-31 14:18:27' where payTraUID = 4799008853656740 and payStatus='V' and payEnabled=1 31/01/2025 14:24:11.3808 745 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 31/01/2025 14:24:18.9160 808 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 31/01/2025 14:24:46.6102 508 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 31/01/2025 14:24:47.3257 657 ms. EXEC: UPDATE payInventory SET invType='N' WHERE invType<>'N' AND invValue IN (100,200,500) AND invDevice IN (42102,42101,42001); 31/01/2025 14:24:55.9396 946 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 31/01/2025 14:25:31.1120 1750 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 31/01/2025 14:27:41.5021 541 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 31/01/2025 14:28:45.3631 614 ms. OPEN: select * from tabArea where areStatus='V' and areEnabled = 1 AND areId = 1 31/01/2025 14:29:24.8984 804 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 31/01/2025 14:29:37.6021 1485 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 31/01/2025 14:30:59.5506 1103 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2025-01-31 14:30:58' where payTraUID = 4864115691490810 and payStatus='V' and payEnabled=1 31/01/2025 14:31:29.3172 781 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 31/01/2025 14:35:26.6852 1300 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 ('2025-01-31 14:35:25',0,'V',4980705910009390,5133381479554650,2025,'2025-01-31 14:35:25',18,1,0,4,'2025-01-31 14:50:25','C','KES',50,50,0,'','','',1,50,0,0,'',0,0) 31/01/2025 14:35:29.4731 2773 ms. EXEC: update tabTerminalReceipt set trcProgressive = 4418, trcLastPrinted = '2500704418', trcLastDate = '2025-01-31 14:35:26' where trcStatus='V' and trcTerId = 18 31/01/2025 14:35:49.7139 564 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 31/01/2025 14:37:03.4452 524 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2025-01-31 14:37:02' where traUID = 5054809038427480 and traStatus='V' and traEnabled=1 31/01/2025 14:39:16.2936 1284 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2025-01-31 14:39:14',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'; 31/01/2025 14:43:56.6030 539 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 31/01/2025 14:52:33.7338 602 ms. EXEC: update abbCards set carLastDate = '2025-01-31 14:52:33',carLastDirection='O' where carStatus='V' and carId = 160 31/01/2025 14:54:13.5503 624 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 31/01/2025 14:55:41.4186 1503 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 31/01/2025 14:56:50.2771 518 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2025-01-31 14:56:49',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'; 31/01/2025 14:56:58.1454 713 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2025-01-31 14:56:57' where traUID = 5615924579610390 and traStatus='V' and traEnabled=1 31/01/2025 14:57:36.1121 685 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 31/01/2025 14:57:36.4503 834 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 31/01/2025 14:57:36.6044 1176 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 31/01/2025 14:57:44.3276 583 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 31/01/2025 14:58:49.4786 626 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,'2025-01-31 14:58:48','V',4803261704327560,2025,'2025-01-31 14:58:48','456865392800327005012999',1,2,16,'I','',1,0,1,'','',4) 31/01/2025 15:04:19.1522 565 ms. EXEC: UPDATE payInventory SET invType='N' WHERE invType<>'N' AND invValue IN (100,200,500) AND invDevice IN (42102,42101,42001); 31/01/2025 15:08:34.2756 580 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 31/01/2025 15:11:19.9633 1611 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 31/01/2025 15:11:19.9913 1579 ms. EXEC: insert into paycash (casCreation,casModify,casUseId,casStatus,casUID,casTraUID,casYear,casDateTime,casIdTerminal,casCurrency,casNumber,casSingleAmount,casTotAmount,casType,casDescription) VALUES ('2025-01-31 15:11:18',0,0,'V',4929617051122920,5622943025137400,2025,'2025-01-31 15:11:18',3,'KES',1,100,100,'N',''); 31/01/2025 15:12:42.3709 525 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 31/01/2025 15:13:41.0765 516 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 31/01/2025 15:13:47.5849 1105 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 31/01/2025 15:14:33.0315 1175 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 31/01/2025 15:14:33.0736 1110 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 (WAIT TIME 42 ms.) 31/01/2025 15:14:39.3888 551 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 31/01/2025 15:18:26.2497 546 ms. EXEC: insert into paycash (casCreation,casModify,casUseId,casStatus,casUID,casTraUID,casYear,casDateTime,casIdTerminal,casCurrency,casNumber,casSingleAmount,casTotAmount,casType,casDescription) VALUES ('2025-01-31 15:18:25',0,0,'V',4641916210211830,5004962092928660,2025,'2025-01-31 15:18:25',3,'KES',1,500,500,'N',''); 31/01/2025 15:18:26.8491 537 ms. EXEC: insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2025-01-31 15:18:25',3,42101,0,500,1,500,2,'I','N'); update payCurInventory set curQuantity=round(curQuantity+1,5),curAmount=round(curAmount+500,5) where curTerId = 3 and curDevCode = 42101 and curChannelId = 2 and curValue = 500 and curType = 'N'; 31/01/2025 15:18:28.2341 874 ms. EXEC: update paycash set casCreation = '2025-01-31 15:18:27',casModify = '2025-01-31 15:18:27',casUseId=0,casStatus='V' where casId = 207385 31/01/2025 15:19:01.1413 955 ms. EXEC: UPDATE payInventory SET invType='N' WHERE invType<>'N' AND invValue IN (100,200,500) AND invDevice IN (42102,42101,42001); 31/01/2025 15:20:03.9538 800 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 5 31/01/2025 15:22:41.3154 1264 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2025-01-31 15:22:39',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 ('2025-01-31 15:22:39',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'; 31/01/2025 15:25:26.0029 623 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 31/01/2025 15:27:29.0773 873 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2025-01-31 15:27:28' where payTraUID = 5545541442885700 and payStatus='V' and payEnabled=1 31/01/2025 15:27:53.6162 514 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2025-01-31 15:27:53' where payTraUID = 4838740852937650 and payStatus='V' and payEnabled=1 31/01/2025 15:28:09.3629 542 ms. EXEC: update payReceipt set recCreation = '2025-01-31 15:28:08',recModify = '2025-01-31 15:28:08',recUseId=0,recStatus='V' where recId = 347717 31/01/2025 15:28:33.3191 706 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 31/01/2025 15:32:46.9039 734 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 31/01/2025 15:36:40.8083 585 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 31/01/2025 15:49:08.7889 2110 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2025-01-31 15:49:06',3,42101,0,1000,1,1000,1,'I','N'); update payCurInventory set curQuantity=round(curQuantity+1,5),curAmount=round(curAmount+1000,5) where curTerId = 3 and curDevCode = 42101 and curChannelId = 1 and curValue = 1000 and curType = 'N'; 31/01/2025 15:49:10.3640 513 ms. OPEN: select sum(crc32(terDescription)) as vCheck from tabTerminal 31/01/2025 15:50:51.0182 700 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 31/01/2025 15:50:59.1897 679 ms. EXEC: insert into payReceipt (recTraUID,recPayUID,recYear,recDateTime,recText,recInvalid) VALUES (5651250819986890,5352099544677000,2025,'2025-01-31 15:50:58','---------------------------------- %The Mall P0006032390 End of payment ---------------------------------- POF Entry : 1/31/2025 3:28:53 PM Date : 1/31/2025 3:50:57 PM Code : 456865573300327005012999 Total : 50.00 KES VAT 16% : 6.90 KES ---------------------------------- Paid : 50.00 KES Coin changed : 0.00 KES Note changed : 0.00 KES',0) 31/01/2025 15:51:03.5937 605 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 31/01/2025 15:52:54.8430 627 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 3 31/01/2025 15:52:54.8570 637 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 31/01/2025 15:54:23.5811 1128 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 31/01/2025 15:58:07.8520 776 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 31/01/2025 15:59:48.6243 712 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 31/01/2025 16:00:20.8191 505 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 31/01/2025 16:01:39.4284 1091 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 31/01/2025 16:05:19.2803 1816 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 31/01/2025 16:07:05.7964 615 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 31/01/2025 16:09:25.6521 622 ms. EXECSCALAR: select count(*) from tabTerminalExtraMem where extStatus='V' and extTerId = 16 nr: 1 31/01/2025 16:09:25.9063 871 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 31/01/2025 16:13:50.2384 584 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 31/01/2025 16:15:13.6969 606 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2025-01-31 16:15:12',3,42101,0,50,-1,-50,1,'O','N'); update payCurInventory set curQuantity=round(curQuantity+-1,5),curAmount=round(curAmount+-50,5) where curTerId = 3 and curDevCode = 42101 and curChannelId = 1 and curValue = 50 and curType = 'N'; 31/01/2025 16:20:42.9029 802 ms. EXEC: insert into movOperator (opeCreation,opeTerId,opeUseId,opeDateTime,opeCode,opeDescription) VALUES ('2025-01-31 16:20:42',4,6,'2025-01-31 16:20:42','456864370100327005012999','Payed (Credit Card ) Ticket ') 31/01/2025 16:20:51.8219 620 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 31/01/2025 16:21:12.0706 1988 ms. EXEC: update payInventory set invCreation = '2025-01-31 16:21:10',invModify = '2025-01-31 16:21:10',invUseId=0,invStatus='V' where invId = 234255 31/01/2025 16:22:59.0531 1032 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2025-01-31 16:22:57' where traUID = 4848414072182370 and traStatus='V' and traEnabled=1 31/01/2025 16:23:02.0701 545 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 31/01/2025 16:26:06.4220 1065 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 31/01/2025 16:27:17.3190 591 ms. EXEC: UPDATE payInventory SET invType='N' WHERE invType<>'N' AND invValue IN (100,200,500) AND invDevice IN (42102,42101,42001); 31/01/2025 16:30:01.4912 556 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 31/01/2025 16:30:28.1983 518 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 31/01/2025 16:31:15.7465 2215 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 31/01/2025 16:31:21.5735 982 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 31/01/2025 16:35:57.5214 509 ms. EXECSCALAR: select count(*) from information_schema.tables where table_schema= 'wisepark_0327' and table_name= 'payInvoiceFtp' nr: 1 31/01/2025 16:37:04.6048 860 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 31/01/2025 16:38:22.3845 506 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 31/01/2025 16:38:41.9458 967 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 16 OR lnsTerId=16) 31/01/2025 16:38:44.2853 652 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 31/01/2025 16:40:24.6293 530 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 31/01/2025 16:42:59.9875 549 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 31/01/2025 16:47:00.2002 1392 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2025-01-31 16:46:58' where payTraUID = 5013764620784570 and payStatus='V' and payEnabled=1 31/01/2025 16:47:51.2918 773 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 31/01/2025 16:47:59.2072 1204 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 2 OR lnsTerId=2) 31/01/2025 16:48:36.1873 565 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 31/01/2025 16:48:47.5530 1026 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 ('2025-01-31 16:48:46',0,'V',5039007389710500,5248740056002640,2025,'2025-01-31 16:48:46',18,1,0,4,'2025-01-31 17:03:46','C','KES',100,100,0,'','','',1,100,0,0,'',0,0) 31/01/2025 16:49:40.3267 518 ms. EXEC: UPDATE payInventory SET invType='N' WHERE invType<>'N' AND invValue IN (100,200,500) AND invDevice IN (42102,42101,42001); 31/01/2025 16:54:17.3744 1679 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 31/01/2025 16:54:17.9878 2475 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 16 OR lnsTerId=16) 31/01/2025 16:54:19.0485 911 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,'2025-01-31 16:54:18','V',4784767717886260,2025,'2025-01-31 16:54:16','456865228700327001012999',2,2,2,'O','',0,'2025-01-31 16:54:18',1,'','',0) 31/01/2025 16:54:26.6536 641 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 31/01/2025 16:56:06.0460 654 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 31/01/2025 16:56:07.4239 886 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2025-01-31 16:56:06' where payTraUID = 5417276234924010 and payStatus='V' and payEnabled=1 31/01/2025 16:56:36.5786 894 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 31/01/2025 17:02:39.4154 566 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 31/01/2025 17:02:45.8428 548 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 31/01/2025 17:06:46.1315 944 ms. EXEC: UPDATE payCash SET casType='N' WHERE casType<>'N' AND ABS(casSingleAmount) IN (100,200,500); 31/01/2025 17:07:00.4212 863 ms. EXEC: insert into payReceipt (recTraUID,recPayUID,recYear,recDateTime,recText,recInvalid) VALUES (5489271930619870,5295640770282700,2025,'2025-01-31 17:06:59',' Date: 1/31/2025 5:06:59 PM Code: 456865992200327005012999 Entry Date: 1/31/2025 4:38:42 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 # 2500704465 ',0) 31/01/2025 17:07:50.1079 557 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 31/01/2025 17:08:21.9544 1173 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 16 OR lnsTerId=16) 31/01/2025 17:08:22.0215 1235 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 31/01/2025 17:08:22.0245 1242 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 31/01/2025 17:08:45.3803 520 ms. OPEN: show columns from tabParameters where Field = 'parUseFloorCounter' 31/01/2025 17:13:41.7218 558 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 31/01/2025 17:18:02.4234 812 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 31/01/2025 17:18:18.0089 577 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2025-01-31 17:18:17',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'; 31/01/2025 17:20:40.1202 855 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 31/01/2025 17:23:12.2202 579 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 31/01/2025 17:25:33.3848 628 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 31/01/2025 17:25:41.8706 1485 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 31/01/2025 17:29:24.8206 622 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2025-01-31 17:29:24' where payTraUID = 4700222119795900 and payStatus='V' and payEnabled=1 31/01/2025 17:29:26.5928 1770 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2025-01-31 17:29:24' where traUID = 4700222119795900 and traStatus='V' and traEnabled=1 31/01/2025 17:29:29.6088 801 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 31/01/2025 17:29:36.2203 1311 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,'2025-01-31 17:29:34','V',5062442390216000,2025,'2025-01-31 17:29:32','456866297200327005012999',1,2,16,'I','',1,0,1,'','',4) 31/01/2025 17:29:38.0295 1553 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 31/01/2025 17:29:40.6973 532 ms. EXEC: update payReceipt set recCreation = '2025-01-31 17:29:40',recModify = '2025-01-31 17:29:40',recUseId=0,recStatus='V' where recId = 347772 31/01/2025 17:29:53.0197 759 ms. EXEC: update payReceipt set recCreation = '2025-01-31 17:29:52',recModify = '2025-01-31 17:29:52',recUseId=0,recStatus='V' where recId = 347773 31/01/2025 17:31:10.1789 522 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); (WAIT TIME 38 ms.) 31/01/2025 17:31:37.3333 967 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 31/01/2025 17:31:45.6830 926 ms. OPEN: select * from movTransit where traStatus = 'V' and traCode='456855646300327005012999' and traBadge = '0230004100967' order by traId desc limit 1 31/01/2025 17:31:57.4309 1353 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 31/01/2025 17:33:59.8729 651 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 16 OR lnsTerId=16) 31/01/2025 17:34:18.2043 677 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 31/01/2025 17:35:45.7406 523 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 31/01/2025 17:37:07.7852 517 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 1 31/01/2025 17:37:07.7852 504 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 31/01/2025 17:41:32.4364 1307 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 16 OR lnsTerId=16) 31/01/2025 17:43:01.1025 855 ms. OPEN: select * from tabArea where areStatus='V' and areEnabled = 1 AND areId = 1 31/01/2025 17:47:48.9657 945 ms. EXEC: update abbSubscriptions set subCredit = round(subCredit-0,5),subLastDebit = '2025-01-31 17:47:48' where subId = 170 31/01/2025 17:47:55.1929 699 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 31/01/2025 17:48:18.9790 611 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 31/01/2025 17:51:08.2717 1754 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 2 31/01/2025 17:52:29.6977 2126 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,'2025-01-31 17:52:27','V',5293653975344680,2025,'2025-01-31 17:52:26','456866297200327005012999',2,2,2,'O','',0,'2025-01-31 17:52:27',1,'','',0) 31/01/2025 17:52:30.8314 626 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 31/01/2025 17:52:35.4255 565 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 31/01/2025 17:53:22.2733 641 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 31/01/2025 17:55:59.0294 565 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 31/01/2025 17:58:43.9101 703 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,'2025-01-31 17:58:43','V',5282569245404530,2025,'2025-01-31 17:58:42','456866472200327005012999',1,2,16,'I','',1,0,1,'','',4) 31/01/2025 17:58:44.4745 558 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 31/01/2025 17:59:04.5151 775 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 31/01/2025 18:04:36.8412 553 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 31/01/2025 18:06:05.0940 1614 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 31/01/2025 18:09:09.2457 531 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 31/01/2025 18:09:32.5054 1745 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 31/01/2025 18:10:41.3991 1805 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 31/01/2025 18:10:56.4753 514 ms. EXEC: update abbSubscriptions set subCredit = round(subCredit-0,5),subLastDebit = '2025-01-31 18:10:55' where subId = 26 31/01/2025 18:11:07.3337 563 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 2 OR lnsTerId=2) 31/01/2025 18:21:00.9007 512 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 31/01/2025 18:21:30.7079 510 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 31/01/2025 18:26:05.6491 1106 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2025-01-31 18:26:04',3,42101,0,100,-1,-100,1,'O','N'); update payCurInventory set curQuantity=round(curQuantity+-1,5),curAmount=round(curAmount+-100,5) where curTerId = 3 and curDevCode = 42101 and curChannelId = 1 and curValue = 100 and curType = 'N'; insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2025-01-31 18:26:04',3,42101,0,100,-1,-100,1,'O','N'); update payCurInventory set curQuantity=round(curQuantity-1,5),curAmount=round(curAmount-100,5) where curTerId = 3 and curDevCode = 42101 and curChannelId = 1 and curValue = 100 and curType = 'N'; insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2025-01-31 18:26:04',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'; Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2025-01-31 18:26:04',3,42101,0,200,-1,-200,1,'O','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'; 31/01/2025 18:27:18.2943 696 ms. EXEC: insert into payReceipt (recTraUID,recPayUID,recYear,recDateTime,recText,recInvalid) VALUES (5638282393180090,5601369694119740,2025,'2025-01-31 18:27:17','---------------------------------- %The Mall P0006032390 End of payment ---------------------------------- POF Entry : 1/31/2025 5:10:21 PM Date : 1/31/2025 6:27:16 PM Code : 456866182100327005012999 Total : 100.00 KES VAT 16% : 13.79 KES ---------------------------------- Paid : 100.00 KES Coin changed : 0.00 KES Note changed : 0.00 KES',0) 31/01/2025 18:28:10.0014 528 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 ('2025-01-31 18:28:05',0,'V',5301748811329070,5738446762230160,2025,'2025-01-31 18:28:05',3,1,0,4,'2025-01-31 18:43:05','C','KES',200,200,0,'',' ',' ',1,200,0,0,'',0,0) 31/01/2025 18:29:57.1169 1191 ms. OPEN: show columns from tabParameters where Field = 'parUseCulture' 31/01/2025 18:30:46.0350 552 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 31/01/2025 18:34:03.1816 794 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 31/01/2025 18:38:48.4110 874 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 31/01/2025 18:40:05.6383 2893 ms. EXEC: update abbSubscriptions set subCredit = round(subCredit-0,5),subLastDebit = '2025-01-31 18:40:02' where subId = 139 31/01/2025 18:40:06.0916 3129 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 ('2025-01-31 18:40:02',0,'V',5275393066133200,5048490114280850,2025,'2025-01-31 18:40:02',18,1,0,4,'2025-01-31 18:55:02','C','KES',50,50,0,'','','',1,50,0,0,'',0,0) 31/01/2025 18:40:06.1967 558 ms. EXEC: insert into abbPayment (payCreation,payCode,payAmount,payCredit,payPayUID,payCarId,payDateFrom,payDateTo) VALUES ('2025-01-31 18:40:05','0810007086215',0,0,5006828726739780,125,'0000-00-00 00:00:00','0000-00-00 00:00:00') 31/01/2025 18:40:11.8715 579 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 31/01/2025 18:40:22.1244 2715 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 2 31/01/2025 18:41:48.4769 703 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 31/01/2025 18:41:49.3936 1046 ms. EXEC: UPDATE payInventory SET invType='N' WHERE invType<>'N' AND invValue IN (100,200,500) AND invDevice IN (42102,42101,42001); 31/01/2025 18:43:57.9346 747 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 31/01/2025 18:46:24.5199 688 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 31/01/2025 18:53:01.5294 1075 ms. EXEC: update abbCards set carLastDate = '2025-01-31 18:53:00',carLastDirection='O' where carStatus='V' and carId = 28 31/01/2025 18:53:04.6975 827 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 31/01/2025 18:53:09.0805 910 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 31/01/2025 18:58:33.5373 532 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 31/01/2025 18:58:45.1011 534 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,'2025-01-31 18:58:44','V',4821282867805080,2025,'2025-01-31 18:58:42','456866832200327005012999',1,2,16,'I','',1,0,1,'','',4) 31/01/2025 18:59:01.4472 502 ms. EXEC: update payInventory set invCreation = '2025-01-31 18:59:00',invModify = '2025-01-31 18:59:00',invUseId=0,invStatus='V' where invId = 234279 31/01/2025 19:00:48.5387 574 ms. EXEC: update tabTerminalReceipt set trcProgressive = 4483, trcLastPrinted = '2500704483', trcLastDate = '2025-01-31 19:00:47' where trcStatus='V' and trcTerId = 18 31/01/2025 19:01:33.7413 689 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 31/01/2025 19:02:24.3326 503 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 2 OR lnsTerId=2) 31/01/2025 19:04:53.7418 597 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,'2025-01-31 19:04:53','V',4892767091664660,2025,'2025-01-31 19:04:48','456866696800327002029999',2,0,2,'O','',0,'2025-01-31 19:04:53',1,'','0560008431904',202,0) 31/01/2025 19:05:40.5505 754 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 31/01/2025 19:09:06.7332 571 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 31/01/2025 19:09:32.1684 990 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 31/01/2025 19:14:03.0389 525 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 31/01/2025 19:15:46.7591 548 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 31/01/2025 19:18:02.3866 1878 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 31/01/2025 19:20:41.5404 615 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 31/01/2025 19:21:18.9697 1912 ms. EXEC: INSERT INTO movOperator (opeCreation,opeUseId,opeTerId,opeDateTime,opeCode,opeDescription) VALUES ('2025-01-31 19:21:17',0,2,'2025-01-31 19:21:17','','Unauthorized Transit Exit 1') 31/01/2025 19:22:44.1724 595 ms. EXEC: update payInventory set invCreation = '2025-01-31 19:22:43',invModify = '2025-01-31 19:22:43',invUseId=0,invStatus='V' where invId = 234282 31/01/2025 19:24:56.5131 2004 ms. EXECSCALAR: select count(*) from information_schema.tables where table_schema= 'wisepark_0327' and table_name= 'payInvoiceFtp' nr: 1 31/01/2025 19:27:24.3192 521 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 2 and terStatus='V' 31/01/2025 19:29:45.5148 1383 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 31/01/2025 19:32:03.8365 613 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 1 31/01/2025 19:39:04.9798 595 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 31/01/2025 19:39:39.8324 631 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 31/01/2025 19:39:40.9481 603 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 31/01/2025 19:39:45.3171 567 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 31/01/2025 19:39:53.2919 576 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,'2025-01-31 19:39:52','V',4831219915389790,2025,'2025-01-31 19:39:52','456867079200327005012999',1,2,16,'I','',1,0,1,'','',4) 31/01/2025 19:41:16.1250 2217 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2025-01-31 19:41:13',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'; 31/01/2025 19:43:03.0264 772 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 31/01/2025 19:43:42.3080 800 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 ('2025-01-31 19:43:41',0,'V',5380283437478470,5608510181806080,2025,'2025-01-31 19:43:41',2,1,0,-1,'2025-01-31 20:43:41','S','KES',0,0,0,'','','',3,0,0) 31/01/2025 19:44:25.4513 597 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 3 31/01/2025 19:45:12.0919 1821 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 16 OR lnsTerId=16) 31/01/2025 19:46:07.2069 574 ms. OPEN: select traId,traDateTime,traEnabled,traDisableTime,traCode,traBadge,traCarId,traAreId,traIdTerminal from movtransit where traStatus='V' and traDirection = 'I' and traCarId = 10 order by traDateTime desc,traId desc 31/01/2025 19:47:42.4314 759 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 31/01/2025 19:49:29.8052 931 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 31/01/2025 19:50:06.0387 745 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 ('2025-01-31 19:50:05',0,'V',5333894584630510,4780363591027730,2025,'2025-01-31 19:50:05',2,1,0,-1,'2025-01-31 20:50:05','S','KES',0,0,0,'','','',3,0,0) 31/01/2025 19:50:08.1061 947 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2025-01-31 19:50:07' where traUID = 4780363591027730 and traStatus='V' and traEnabled=1 31/01/2025 19:52:20.0655 536 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 31/01/2025 19:56:16.7398 939 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 31/01/2025 20:00:17.9902 1535 ms. OPEN: SELECT * FROM movLinks INNER JOIN movTransit on traUID = mliTraUID WHERE mliRFIDCode = '456866952900327005012999' AND mliStatus='V' ORDER BY mliId DESC LIMIT 1 31/01/2025 20:01:48.5155 533 ms. OPEN: select * from payCurInventory where curTerId = 18 and curQuantity>0 and curType in ('C','N') order by curDevCode,curChannelId,curValue 31/01/2025 20:01:56.5309 961 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,'2025-01-31 20:01:55','V',5384013515704760,2025,'2025-01-31 20:01:53','456867211300327005012999',1,2,16,'I','',1,0,1,'','0230003944081',15,0) 31/01/2025 20:11:00.5184 1426 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 31/01/2025 20:15:53.9782 1210 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 31/01/2025 20:18:01.5946 583 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 31/01/2025 20:18:28.1346 821 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 31/01/2025 20:21:02.6633 1245 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 16 OR lnsTerId=16) 31/01/2025 20:21:02.6713 761 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 31/01/2025 20:23:29.8039 514 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 31/01/2025 20:24:08.4931 729 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 31/01/2025 20:24:20.3111 815 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 31/01/2025 20:24:20.5143 887 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 16 OR lnsTerId=16) 31/01/2025 20:27:27.6020 503 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 31/01/2025 20:31:36.6337 739 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 31/01/2025 20:31:37.3061 668 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 31/01/2025 20:31:44.0607 668 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 31/01/2025 20:33:42.8362 840 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 31/01/2025 20:35:22.9540 626 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 2 and terStatus='V' 31/01/2025 20:36:08.6379 650 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 31/01/2025 20:40:11.6885 582 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 31/01/2025 20:41:18.6319 574 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 16 OR lnsTerId=16) 31/01/2025 20:44:45.4940 679 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 31/01/2025 20:44:45.5520 923 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,'2025-01-31 20:44:44','V',4650288953539910,2025,'2025-01-31 20:44:44','456867468400327001012999',1,2,1,'I','',1,0,1,'','',4) 31/01/2025 20:46:19.6418 511 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 31/01/2025 20:49:03.7377 505 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 31/01/2025 20:51:31.6138 509 ms. EXECSCALAR: select count(0) as vTot from tabParameters where parPlateReading<>0 nr: 0 31/01/2025 21:03:50.4373 635 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 31/01/2025 21:03:57.5531 993 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 31/01/2025 21:10:19.8260 4222 ms. EXEC: UPDATE payInventory SET invType='N' WHERE invType<>'N' AND invValue IN (100,200,500) AND invDevice IN (42102,42101,42001); 31/01/2025 21:11:02.9662 609 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,'2025-01-31 21:11:02','V',5497516973554990,2025,'2025-01-31 21:11:01','456867216900327005012999',2,2,2,'O','',0,'2025-01-31 21:11:02',1,'','',0) 31/01/2025 21:13:42.1751 973 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2025-01-31 21:13:41' where traUID = 5467912378354140 and traStatus='V' and traEnabled=1 31/01/2025 21:13:47.8079 646 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 31/01/2025 21:14:17.9323 510 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 31/01/2025 21:14:49.2535 1174 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 31/01/2025 21:21:56.7681 746 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 31/01/2025 21:22:23.8584 673 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 ('2025-01-31 21:22:23',0,'V',5468799211149000,5679692045938190,2025,'2025-01-31 21:22:23',2,1,0,-1,'2025-01-31 22:22:23','S','KES',0,0,0,'','','',3,0,0) 31/01/2025 21:22:57.9125 727 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 2 31/01/2025 21:24:06.9833 1163 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 31/01/2025 21:26:34.9095 1302 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 ('2025-01-31 21:26:33',0,'V',5753689260640720,5296846238007280,2025,'2025-01-31 21:26:33',18,1,0,4,'2025-01-31 21:41:33','C','KES',50,50,0,'','','',1,50,0,0,'',0,0) 31/01/2025 21:27:13.6787 1375 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 31/01/2025 21:29:22.1798 624 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 31/01/2025 21:30:46.3748 809 ms. OPEN: SELECT traCode FROM movTransit WHERE traId = '837626' and traDirection='I' order by traId DESC LIMIT 1 31/01/2025 21:31:50.3531 527 ms. EXEC: UPDATE payInventory SET invType='N' WHERE invType<>'N' AND invValue IN (100,200,500) AND invDevice IN (42102,42101,42001); 31/01/2025 21:33:36.3559 543 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 16 OR lnsTerId=16) 31/01/2025 21:34:24.3625 562 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 31/01/2025 21:34:27.7978 1019 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 31/01/2025 21:37:38.4589 683 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 3 31/01/2025 21:37:48.4797 2386 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 5 31/01/2025 21:37:48.9961 990 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 31/01/2025 21:41:58.4040 891 ms. EXEC: update payReceipt set recCreation = '2025-01-31 21:41:57',recModify = '2025-01-31 21:41:57',recUseId=0,recStatus='V' where recId = 347838 31/01/2025 21:42:16.2831 529 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 31/01/2025 21:43:53.1978 1123 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2025-01-31 21:43:51',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'; 31/01/2025 21:44:23.7124 1100 ms. OPEN: show columns from tabParameters where Field = 'parAllowNegativePlaces' 31/01/2025 21:44:23.7595 1606 ms. EXECSCALAR: select count(*) from information_schema.tables where table_schema= 'wisepark_0327' and table_name= 'payInvoiceFtp' nr: 1 31/01/2025 21:44:24.7621 546 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 31/01/2025 21:46:20.9608 1161 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,'2025-01-31 21:46:19','V',4869315263299550,2025,'2025-01-31 21:46:19','456866560500327005012999',2,2,2,'O','',0,'2025-01-31 21:46:19',1,'','',0) 31/01/2025 21:46:44.2096 1948 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 31/01/2025 21:46:46.3921 566 ms. EXEC: INSERT INTO movOperator (opeCreation,opeUseId,opeTerId,opeDateTime,opeCode,opeDescription) VALUES ('2025-01-31 21:46:45',0,16,'2025-01-31 21:46:45','','Unauthorized Transit Entry 2') 31/01/2025 21:47:32.4813 577 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 ('2025-01-31 21:47:31',0,'V',4977198099780340,5008393168785620,2025,'2025-01-31 21:47:31',18,1,0,4,'2025-01-31 22:02:31','C','KES',50,50,0,'','','',1,50,0,0,'',0,0) 31/01/2025 21:47:33.7281 901 ms. EXEC: update payReceipt set recCreation = '2025-01-31 21:47:32',recModify = '2025-01-31 21:47:32',recUseId=0,recStatus='V' where recId = 347842 31/01/2025 21:48:45.6418 748 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 31/01/2025 21:49:08.7815 569 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 31/01/2025 21:49:39.1791 1573 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 31/01/2025 22:02:01.9892 1220 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 31/01/2025 22:02:35.9983 686 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 31/01/2025 22:02:47.2509 1226 ms. OPEN: select * from tabArea where areStatus='V' and areEnabled = 1 AND areId = 1 31/01/2025 22:03:30.4972 1576 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 31/01/2025 22:06:54.7745 661 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 31/01/2025 22:09:24.6831 998 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 31/01/2025 22:13:59.2701 560 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 31/01/2025 22:16:02.9779 514 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 31/01/2025 22:17:12.7491 699 ms. EXEC: update tabTerminalReceipt set trcProgressive = 4515, trcLastPrinted = '2500704515', trcLastDate = '2025-01-31 22:17:12' where trcStatus='V' and trcTerId = 18 31/01/2025 22:18:05.9352 619 ms. EXEC: update paycash set casCreation = '2025-01-31 22:18:05',casModify = '2025-01-31 22:18:05',casUseId=0,casStatus='V' where casId = 207461 31/01/2025 22:18:45.8602 837 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2025-01-31 22:18:44' where traUID = 5362828011913230 and traStatus='V' and traEnabled=1 31/01/2025 22:18:59.0581 1383 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 1 31/01/2025 22:20:42.9755 544 ms. OPEN: show columns from abbCards where Field = 'carUHFCode' 31/01/2025 22:20:49.7601 909 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); (WAIT TIME 7 ms.) 31/01/2025 22:22:20.7598 739 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2025-01-31 22:22:20' where payTraUID = 4921566598663170 and payStatus='V' and payEnabled=1 31/01/2025 22:22:25.7521 688 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 31/01/2025 22:24:17.8501 1032 ms. EXEC: update opeActivities set acvFstPayId = (case acvFstPayId when 0 then 400822 else acvFstPayId end),acvLstPayId = 400822 where acvSftId = 893 and acvCodeId = 3 31/01/2025 22:26:29.1430 558 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 31/01/2025 22:27:21.2523 972 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 1 31/01/2025 22:27:51.2446 873 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 1 and terStatus='V' 31/01/2025 22:30:35.3928 678 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2025-01-31 22:30:34' where payTraUID = 4818664506070720 and payStatus='V' and payEnabled=1 31/01/2025 22:30:40.6353 569 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 31/01/2025 22:30:42.4616 1802 ms. EXEC: UPDATE payCash SET casType='N' WHERE casType<>'N' AND ABS(casSingleAmount) IN (100,200,500); 31/01/2025 22:31:32.5285 1063 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 31/01/2025 22:31:43.6540 815 ms. EXEC: UPDATE payInventory SET invType='N' WHERE invType<>'N' AND invValue IN (100,200,500) AND invDevice IN (42102,42101,42001); 31/01/2025 22:32:04.5542 709 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 31/01/2025 22:32:21.9019 1359 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 31/01/2025 22:35:21.7628 625 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 31/01/2025 22:37:26.0039 722 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,'2025-01-31 22:37:25','V',5203414296799870,2025,'2025-01-31 22:37:24','456868144400327005012999',1,2,16,'I','',1,0,1,'','',4) 31/01/2025 22:39:17.5635 560 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 31/01/2025 22:41:16.9964 824 ms. EXEC: update payReceipt set recCreation = '2025-01-31 22:41:16',recModify = '2025-01-31 22:41:16',recUseId=0,recStatus='V' where recId = 347866 31/01/2025 22:42:08.4622 595 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 31/01/2025 22:42:21.7672 1062 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 31/01/2025 22:48:20.4562 537 ms. EXECSCALAR: select count(*) from information_schema.tables where table_schema= 'wisepark_0327' and table_name= 'payInvoiceFtp' nr: 1 31/01/2025 22:49:02.9130 530 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 31/01/2025 23:01:49.6523 949 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 31/01/2025 23:04:16.7319 520 ms. EXECSCALAR: SELECT traId FROM movTransit WHERE traStatus='V' AND traCode = @traCode nr: 837678 31/01/2025 23:04:22.4248 1926 ms. EXECSCALAR: select count(*) from information_schema.tables where table_schema= 'wisepark_0327' and table_name= 'payInvoiceFtp' nr: 1 31/01/2025 23:07:37.2798 862 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 31/01/2025 23:10:09.4138 851 ms. EXEC: update abbCards set carLastDate = '2025-01-31 23:10:08',carLastDirection='O' where carStatus='V' and carId = 15 31/01/2025 23:10:10.1603 660 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2025-01-31 23:10:09' where payTraUID = 5154580549738050 and payStatus='V' and payEnabled=1 31/01/2025 23:10:20.6904 1568 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 5 31/01/2025 23:14:22.1920 501 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 31/01/2025 23:15:23.8268 948 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 31/01/2025 23:18:30.9445 2467 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 31/01/2025 23:31:19.6792 590 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 31/01/2025 23:34:56.8603 620 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 31/01/2025 23:41:21.7900 1032 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 16 OR lnsTerId=16) 31/01/2025 23:41:25.4475 531 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 16 OR lnsTerId=16) 31/01/2025 23:45:42.1454 515 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 31/01/2025 23:48:30.0851 864 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1