28/03/2025 01:23:54.4185 790 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 28/03/2025 06:24:14.5435 942 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 28/03/2025 07:46:02.5783 528 ms. OPEN: select traId,traDateTime,traEnabled,traDisableTime,traCode,traBadge,traCarId,traAreId,traIdTerminal from movtransit where traStatus='V' and traDirection = 'I' and traCarId = 29 order by traDateTime desc,traId desc 28/03/2025 07:49:29.5963 525 ms. OPEN: select traId,traDateTime,traEnabled,traDisableTime,traCode,traBadge,traCarId,traAreId,traIdTerminal from movtransit where traStatus='V' and traDirection = 'I' and traCarId = 19 order by traDateTime desc,traId desc 28/03/2025 09:12:41.2320 7501 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 28/03/2025 09:59:25.3770 1838 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 28/03/2025 10:00:36.8874 1964 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 = 1 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 28/03/2025 13:12:51.3434 606 ms. OPEN: select traId,traDateTime,traEnabled,traDisableTime,traCode,traBadge,traCarId,traAreId,traIdTerminal from movtransit where traStatus='V' and traDirection = 'I' and traCarId = 44 order by traDateTime desc,traId desc 28/03/2025 15:30:43.4287 523 ms. EXEC: update payReceipt set recCreation = '2025-03-28 15:30:42',recModify = '2025-03-28 15:30:42',recUseId=0,recStatus='V' where recId = 365148 28/03/2025 15:39:46.3117 507 ms. EXEC: update payInventory set invCreation = '2025-03-28 15:39:45',invModify = '2025-03-28 15:39:45',invUseId=0,invStatus='V' where invId = 243825 28/03/2025 15:58:26.0653 602 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2025-03-28 15:58:25',3,42101,0,100,1,100,1,'I','N'); update payCurInventory set curQuantity=round(curQuantity+1,5),curAmount=round(curAmount+100,5) where curTerId = 3 and curDevCode = 42101 and curChannelId = 1 and curValue = 100 and curType = 'N'; 28/03/2025 16:42:51.5231 527 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2025-03-28 16:42:50',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'; (WAIT TIME 1 ms.) 28/03/2025 17:33:51.5831 679 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2025-03-28 17:33:50' where traUID = 4771637707946430 and traStatus='V' and traEnabled=1 28/03/2025 17:34:46.9725 600 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 28/03/2025 17:34:47.0756 520 ms. OPEN: show columns from tabParameters where Field = 'parUseFloorCounter' 28/03/2025 17:43:10.4829 1241 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 28/03/2025 17:50:46.1172 541 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 28/03/2025 17:52:16.5208 628 ms. EXEC: insert into payPayment (payCreation,payUseId,payStatus,payUID,payTraUID,payYear,payDateTime,payIdTerminal,payEnabled,payDisableTime,payTarId,payTimeLimit,payType,payCurrency,payAmount,payPayed,payChange,payCardType,payPAN,paySTAN,payIdEvent,payAmountCalc,payDiscountValue,payDiscount,payDiscountType,payVatPercent,payVatAmount) VALUES ('2025-03-28 17:52:15',0,'V',4864125808741780,4776940711019200,2025,'2025-03-28 17:52:15',18,1,0,4,'2025-03-28 18:07:15','C','KES',50,50,0,'','','',1,50,0,0,'',0,0) 28/03/2025 18:00:03.1260 2419 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 28/03/2025 18:00:14.3096 4826 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 28/03/2025 18:00:45.6230 1097 ms. EXEC: UPDATE payInventory SET invType='N' WHERE invType<>'N' AND invValue IN (100,200,500) AND invDevice IN (42102,42101,42001); 28/03/2025 18:01:50.7204 559 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 28/03/2025 18:05:17.3820 999 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 28/03/2025 18:05:49.6830 688 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 2 and terStatus='V' 28/03/2025 18:27:05.0692 515 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 28/03/2025 18:29:42.2524 550 ms. EXEC: INSERT INTO movOperator (opeCreation,opeUseId,opeTerId,opeDateTime,opeCode,opeDescription) VALUES ('2025-03-28 18:29:41',0,2,'2025-03-28 18:29:41','','Manual Open Barrier Exit 1') 28/03/2025 18:37:51.4300 638 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-03-28 18:37:49',0,'V',5538545908568050,4897033197072410,2025,'2025-03-28 18:37:49',3,1,0,4,'2025-03-28 18:52:49','C','KES',50,50,0,'',' ',' ',1,50,0,0,'',0,0) 28/03/2025 18:38:05.7617 879 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 28/03/2025 18:42:01.8213 501 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-03-28 18:42:01',0,'V',4833418395817700,4837550342336990,2025,'2025-03-28 18:42:01',18,1,0,4,'2025-03-28 18:57:01','C','KES',50,50,0,'','','',1,50,0,0,'',0,0) 28/03/2025 18:42:18.7789 1207 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 28/03/2025 18:43:19.8815 552 ms. EXEC: update tabTerminalReceipt set trcProgressive = 12561, trcLastPrinted = '2500712561', trcLastDate = '2025-03-28 18:43:19' where trcStatus='V' and trcTerId = 18 28/03/2025 18:43:21.3495 749 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 28/03/2025 18:48:47.6180 1151 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 3 OR lnsTerId=3) 28/03/2025 18:51:46.8852 1146 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 28/03/2025 18:52:12.7519 725 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 28/03/2025 18:53:39.4920 1061 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 28/03/2025 18:57:21.5106 814 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-03-28 18:57:20','V',5562781440771680,2025,'2025-03-28 18:57:19','457426175500327005012999',2,2,2,'O','',0,'2025-03-28 18:57:20',1,'','',0) 28/03/2025 19:09:34.4166 546 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 28/03/2025 19:13:21.9468 772 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2025-03-28 19:13:21' where traUID = 5742669697572880 and traStatus='V' and traEnabled=1 28/03/2025 19:13:23.9271 523 ms. EXEC: UPDATE payCash SET casType='N' WHERE casType<>'N' AND ABS(casSingleAmount) IN (100,200,500); 28/03/2025 19:14:26.2946 804 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-03-28 19:14:25','V',4681967223834110,2025,'2025-03-28 19:14:24','457426926400327005012999',1,2,16,'I','',1,0,1,'','',4) 28/03/2025 19:17:14.0981 3150 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 28/03/2025 19:18:01.5074 563 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 28/03/2025 19:18:13.7247 817 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 16 OR lnsTerId=16) 28/03/2025 19:19:03.5437 1513 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-03-28 19:19:02',0,'V',4649277286380370,5312076660399240,2025,'2025-03-28 19:19:02',18,1,0,4,'2025-03-28 19:34:02','C','KES',50,50,0,'','','',1,50,0,0,'',0,0) 28/03/2025 19:19:06.1114 2555 ms. EXEC: update tabTerminalReceipt set trcProgressive = 12569, trcLastPrinted = '2500712569', trcLastDate = '2025-03-28 19:19:03' where trcStatus='V' and trcTerId = 18 28/03/2025 19:21:14.8233 608 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2025-03-28 19:21:14' where traUID = 5312076660399240 and traStatus='V' and traEnabled=1 28/03/2025 19:23:17.3109 530 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-03-28 19:23:16','V',4879993506168000,2025,'2025-03-28 19:23:15','457426697500327001012999',2,2,2,'O','',0,'2025-03-28 19:23:16',1,'','',0) 28/03/2025 19:23:23.4280 570 ms. EXEC: UPDATE payInventory SET invType='N' WHERE invType<>'N' AND invValue IN (100,200,500) AND invDevice IN (42102,42101,42001); 28/03/2025 19:34:40.8356 1329 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-03-28 19:34:39','V',4681197084934910,2025,'2025-03-28 19:34:38','457426897500327005012999',2,2,2,'O','',0,'2025-03-28 19:34:39',1,'','',0) 28/03/2025 19:38:17.5404 524 ms. EXECSCALAR: select count(*) from tabTerminalExtraMem where extStatus='V' and extTerId = @extTerId nr: 0 28/03/2025 19:39:39.0740 632 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2025-03-28 19:39:37',3,42101,0,100,1,100,1,'I','N'); update payCurInventory set curQuantity=round(curQuantity+1,5),curAmount=round(curAmount+100,5) where curTerId = 3 and curDevCode = 42101 and curChannelId = 1 and curValue = 100 and curType = 'N'; 28/03/2025 19:39:46.0728 1221 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-03-28 19:39:44',0,'V',5517581610223930,5273556185582640,2025,'2025-03-28 19:39:44',18,1,0,4,'2025-03-28 19:54:44','C','KES',200,200,0,'','','',1,200,0,0,'',0,0) 28/03/2025 19:40:42.5983 787 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 28/03/2025 19:44:16.2670 750 ms. EXECSCALAR: select count(*) from tabTerminalExtraMem where extStatus='V' and extTerId = 2 nr: 1 28/03/2025 19:44:20.4889 561 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 28/03/2025 19:44:54.8253 904 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 28/03/2025 19:45:53.4473 1204 ms. EXEC: UPDATE payInventory SET invType='N' WHERE invType<>'N' AND invValue IN (100,200,500) AND invDevice IN (42102,42101,42001); 28/03/2025 19:53:24.8611 520 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 28/03/2025 19:55:03.1261 532 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 28/03/2025 19:56:07.9653 527 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 28/03/2025 19:56:53.4093 577 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-03-28 19:56:52','V',5526266103221860,2025,'2025-03-28 19:56:51','457425953000327005012999',2,2,2,'O','',0,'2025-03-28 19:56:52',1,'','',0) 28/03/2025 19:56:58.0735 749 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 28/03/2025 20:05:43.4697 1536 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 28/03/2025 20:07:38.2530 575 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2025-03-28 20:07:37' where traUID = 5509020347043660 and traStatus='V' and traEnabled=1 28/03/2025 20:07:44.1981 549 ms. OPEN: show columns from tabParameters where Field = 'parAllowNegativePlaces' 28/03/2025 20:09:50.7754 612 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 28/03/2025 20:09:57.3689 582 ms. EXEC: INSERT INTO movOperator (opeCreation,opeUseId,opeTerId,opeDateTime,opeCode,opeDescription) VALUES ('2025-03-28 20:09:56',0,16,'2025-03-28 20:09:56','','Unauthorized Transit Entry 2') 28/03/2025 20:12:39.4334 945 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 28/03/2025 20:32:30.6724 1194 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 28/03/2025 20:32:46.5172 1433 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 28/03/2025 20:35:10.7656 970 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2025-03-28 20:35:09',3,42101,0,50,1,50,1,'I','N'); update payCurInventory set curQuantity=round(curQuantity+1,5),curAmount=round(curAmount+50,5) where curTerId = 3 and curDevCode = 42101 and curChannelId = 1 and curValue = 50 and curType = 'N'; 28/03/2025 20:41:35.0356 1142 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 28/03/2025 20:41:38.5570 2944 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 28/03/2025 20:45:06.3740 819 ms. EXEC: insert into paycash (casCreation,casModify,casUseId,casStatus,casUID,casTraUID,casYear,casDateTime,casIdTerminal,casCurrency,casNumber,casSingleAmount,casTotAmount,casType,casDescription) VALUES ('2025-03-28 20:45:05',0,0,'V',4910825321099050,5453587404001060,2025,'2025-03-28 20:45:05',3,'KES',-1,50,-50,'N',''); insert into paycash (casCreation,casModify,casUseId,casStatus,casUID,casTraUID,casYear,casDateTime,casIdTerminal,casCurrency,casNumber,casSingleAmount,casTotAmount,casType,casDescription) VALUES ('2025-03-28 20:45:05',0,0,'V',4910825321099050,5453587404001060,2025,'2025-03-28 20:45:05',3,'KES',-1,100,-100,'N',''); 28/03/2025 20:45:07.4818 611 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2025-03-28 20:45:05',3,42101,0,50,-1,-50,1,'O','N'); update payCurInventory set curQuantity=round(curQuantity+-1,5),curAmount=round(curAmount+-50,5) where curTerId = 3 and curDevCode = 42101 and curChannelId = 1 and curValue = 50 and curType = 'N'; Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2025-03-28 20:45:05',3,42101,0,100,-1,-100,1,'O','N'); update payCurInventory set curQuantity=round(curQuantity+-1,5),curAmount=round(curAmount+-100,5) where curTerId = 3 and curDevCode = 42101 and curChannelId = 1 and curValue = 100 and curType = 'N'; 28/03/2025 20:48:31.9092 1786 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 28/03/2025 20:48:50.0806 1860 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 28/03/2025 20:49:59.6500 855 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 28/03/2025 20:51:50.4085 767 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 1 OR lnsTerId=1) 28/03/2025 20:51:50.4155 812 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 28/03/2025 20:52:06.3124 753 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2025-03-28 20:52:05' where traUID = 5368661112189670 and traStatus='V' and traEnabled=1 28/03/2025 20:52:27.2166 521 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 28/03/2025 20:54:51.7152 967 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-03-28 20:54:50','V',4794967063657140,2025,'2025-03-28 20:54:49','457427162100327005012999',2,2,2,'O','',0,'2025-03-28 20:54:50',1,'','0230003945386',205,0) 28/03/2025 20:55:24.7507 918 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 28/03/2025 20:57:56.7183 692 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 28/03/2025 21:01:29.0391 1252 ms. EXEC: UPDATE payCash SET casType='N' WHERE casType<>'N' AND ABS(casSingleAmount) IN (100,200,500); 28/03/2025 21:04:54.1860 779 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 28/03/2025 21:04:58.8071 1531 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 1 OR lnsTerId=1) 28/03/2025 21:06:40.6916 668 ms. EXEC: UPDATE payInventory SET invType='N' WHERE invType<>'N' AND invValue IN (100,200,500) AND invDevice IN (42102,42101,42001); 28/03/2025 21:07:15.4453 546 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 28/03/2025 21:09:26.7168 783 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 3 28/03/2025 21:10:47.8551 1093 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 28/03/2025 21:10:51.9789 526 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 28/03/2025 21:11:45.8717 532 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 28/03/2025 21:11:56.4669 2711 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-03-28 21:11:53',0,'V',4810820805436660,4654499236511350,2025,'2025-03-28 21:11:53',18,1,0,4,'2025-03-28 21:26:53','C','KES',100,100,0,'','','',1,100,0,0,'',0,0) 28/03/2025 21:12:43.4970 517 ms. EXEC: update payReceipt set recCreation = '2025-03-28 21:12:42',recModify = '2025-03-28 21:12:42',recUseId=0,recStatus='V' where recId = 365296 28/03/2025 21:14:28.8078 670 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2025-03-28 21:14:28' where traUID = 5733431703557160 and traStatus='V' and traEnabled=1 28/03/2025 21:14:31.6097 516 ms. EXECSCALAR: select count(*) from information_schema.tables where table_schema= 'wisepark_0327' and table_name= 'payInvoiceFtp' nr: 1 28/03/2025 21:15:32.3421 684 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2025-03-28 21:15:31' where payTraUID = 4791026575044270 and payStatus='V' and payEnabled=1 28/03/2025 21:20:07.0795 536 ms. EXEC: update tabTerminalReceipt set trcProgressive = 12599, trcLastPrinted = '2500712599', trcLastDate = '2025-03-28 21:20:06' where trcStatus='V' and trcTerId = 18 28/03/2025 21:20:09.6122 3272 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 28/03/2025 21:21:12.4971 630 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 28/03/2025 21:29:28.6700 673 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 28/03/2025 21:32:51.4898 939 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2025-03-28 21:32:50',3,42101,0,50,-1,-50,1,'O','N'); update payCurInventory set curQuantity=round(curQuantity+-1,5),curAmount=round(curAmount+-50,5) where curTerId = 3 and curDevCode = 42101 and curChannelId = 1 and curValue = 50 and curType = 'N'; 28/03/2025 21:34:17.0742 601 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2025-03-28 21:34:16' where traUID = 5574986609404910 and traStatus='V' and traEnabled=1 28/03/2025 21:37:30.7034 634 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 28/03/2025 21:40:08.1157 534 ms. OPEN: SELECT traCode FROM movTransit WHERE traId = '893865' and traDirection='I' order by traId DESC LIMIT 1 28/03/2025 21:41:14.0537 563 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 28/03/2025 21:52:04.2680 1191 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 2 OR lnsTerId=2) 28/03/2025 21:52:07.1730 3047 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 28/03/2025 21:59:07.3513 625 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 2 28/03/2025 22:05:07.2284 515 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 28/03/2025 22:13:34.3694 526 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 28/03/2025 22:20:30.9134 548 ms. EXEC: insert into movtransit (traUseId,traCreation,traStatus,traUID,traYear,traDateTime,traCode,traType,traClass,traIdTerminal,traDirection,traPlate,traEnabled,traDisableTime,traAreId,traNotes,traBadge,traTarId) VALUES (0,'2025-03-28 22:20:30','V',5025771835342350,2025,'2025-03-28 22:20:29','457427912600327005012999',2,2,2,'O','',0,'2025-03-28 22:20:30',1,'','',0) 28/03/2025 22:23:18.2159 791 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 5 28/03/2025 22:32:31.5664 913 ms. OPEN: show columns from tabParameters where Field = 'parAllowNegativePlaces' 28/03/2025 22:32:53.4933 569 ms. EXECSCALAR: select count(payId) from paypayment where payStatus='V' and payIdTerminal = 3 and payDateTime = '2025-03-28 22:32:51' nr: 0 28/03/2025 22:34:32.2967 1686 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-03-28 22:34:27',0,'V',5016594559545960,5196046987395600,2025,'2025-03-28 22:34:27',3,1,0,4,'2025-03-28 22:49:27','C','KES',50,100,50,'',' ',' ',1,50,0,0,'',0,0) 28/03/2025 22:36:09.2148 704 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-03-28 22:36:08','V',4999565300067120,2025,'2025-03-28 22:36:06','457428136600327005012999',1,2,16,'I','',1,0,1,'','',4) 28/03/2025 22:36:51.0423 898 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 4 OR lnsTerId=4) 28/03/2025 22:40:16.7256 980 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2025-03-28 22:40:15' where traUID = 4685972054385890 and traStatus='V' and traEnabled=1 28/03/2025 22:44:15.2442 987 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2025-03-28 22:44:14' where traUID = 5322573161458550 and traStatus='V' and traEnabled=1 28/03/2025 22:45:19.2538 629 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-03-28 22:45:18',0,'V',5033572816794200,5624575562086600,2025,'2025-03-28 22:45:18',18,1,0,4,'2025-03-28 23:00:18','C','KES',50,50,0,'','','',1,50,0,0,'',0,0) 28/03/2025 22:48:36.1518 2458 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 28/03/2025 22:48:43.7590 1076 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-03-28 22:48:42','V',4664685046222660,2025,'2025-03-28 22:48:41','457426511900327005012999',2,2,2,'O','',0,'2025-03-28 22:48:42',1,'','',0) 28/03/2025 22:49:04.9405 766 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 28/03/2025 22:49:11.0356 747 ms. EXEC: UPDATE payInventory SET invType='N' WHERE invType<>'N' AND invValue IN (100,200,500) AND invDevice IN (42102,42101,42001); 28/03/2025 22:49:29.3561 528 ms. EXECSCALAR: select count(*) from tabTerminalExtraMem where extStatus='V' and extTerId = 2 nr: 1 28/03/2025 22:49:47.5645 509 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 28/03/2025 22:54:26.1855 771 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-03-28 22:54:25','V',5249185689309880,2025,'2025-03-28 22:54:24','457428246400327005012999',1,2,16,'I','',1,0,1,'','0230003944059',13,0) 28/03/2025 23:04:33.6226 559 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 1 and terStatus='V' 28/03/2025 23:15:01.2524 833 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 28/03/2025 23:15:14.7696 834 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 28/03/2025 23:15:19.9572 856 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 2 28/03/2025 23:34:49.0206 1013 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 28/03/2025 23:36:19.8057 737 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 28/03/2025 23:38:38.6054 682 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-03-28 23:38:37',0,'V',5437793180331380,5007828570264110,2025,'2025-03-28 23:38:37',18,1,0,4,'2025-03-28 23:53:37','C','KES',100,100,0,'','','',1,100,0,0,'',0,0) 28/03/2025 23:40:09.4593 916 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 28/03/2025 23:57:48.0571 938 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40);