19/12/2024 00:16:23.5750 610 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 19/12/2024 00:21:00.4276 868 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 19/12/2024 00:21:30.0984 510 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 19/12/2024 00:25:32.6856 915 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 19/12/2024 00:53:13.8392 580 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 19/12/2024 00:54:05.9931 549 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 19/12/2024 00:54:15.6325 538 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 19/12/2024 00:55:43.0610 1155 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 19/12/2024 00:57:46.9072 975 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 19/12/2024 01:04:20.6859 535 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 19/12/2024 01:39:13.4485 1073 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 2 and terStatus='V' 19/12/2024 02:13:53.0096 784 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 19/12/2024 02:59:04.6479 602 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 19/12/2024 04:07:22.0280 720 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 19/12/2024 04:09:50.7648 673 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 19/12/2024 04:34:06.5563 692 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 19/12/2024 05:27:26.9263 618 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 2 OR lnsTerId=2) 19/12/2024 05:30:19.8043 1115 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2024-12-19 05:30:18',3,42101,0,100,1,100,1,'I','N'); update payCurInventory set curQuantity=round(curQuantity+1,5),curAmount=round(curAmount+100,5) where curTerId = 3 and curDevCode = 42101 and curChannelId = 1 and curValue = 100 and curType = 'N'; 19/12/2024 05:37:03.8747 790 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 19/12/2024 05:44:34.9472 767 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 19/12/2024 05:44:57.6103 889 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 19/12/2024 05:49:23.0546 680 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 19/12/2024 06:01:34.2550 699 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 5 19/12/2024 06:10:53.5617 1275 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2024-12-19 06:10:52' where payTraUID = 5288476879099310 and payStatus='V' and payEnabled=1 19/12/2024 06:10:54.4283 710 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2024-12-19 06:10:52' where traUID = 5288476879099310 and traStatus='V' and traEnabled=1 19/12/2024 06:39:34.7577 1210 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 19/12/2024 06:41:04.3716 688 ms. EXECSCALAR: select count(0) as vTot from tabParameters where parPlateReading<>0 nr: 0 19/12/2024 06:42:11.8167 551 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 19/12/2024 06:58:04.3144 533 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 19/12/2024 07:16:00.8897 578 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 19/12/2024 07:16:00.9027 652 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 19/12/2024 07:26:20.0815 609 ms. EXEC: UPDATE payInventory SET invType='N' WHERE invType<>'N' AND invValue IN (100,200,500) AND invDevice IN (42102,42101,42001); 19/12/2024 07:41:27.8711 533 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 19/12/2024 07:55:53.3526 655 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 5 19/12/2024 08:00:58.9250 784 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 19/12/2024 08:17:46.4880 1850 ms. EXEC: insert into movtransit (traUseId,traCreation,traStatus,traUID,traYear,traDateTime,traCode,traType,traClass,traIdTerminal,traDirection,traPlate,traEnabled,traDisableTime,traAreId,traNotes,traBadge,traTarId) VALUES (0,'2024-12-19 08:17:44','V',5715749166031060,2024,'2024-12-19 08:17:44','456432986400327005012999',1,2,16,'I','',1,0,1,'','',4) 19/12/2024 08:30:05.0561 1484 ms. EXEC: UPDATE payInventory SET invType='N' WHERE invType<>'N' AND invValue IN (100,200,500) AND invDevice IN (42102,42101,42001); 19/12/2024 08:30:12.0999 797 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 19/12/2024 08:30:19.1075 670 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 19/12/2024 08:30:58.3701 715 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 2 OR lnsTerId=2) 19/12/2024 08:31:39.6056 1829 ms. EXEC: UPDATE payInventory SET invType='N' WHERE invType<>'N' AND invValue IN (100,200,500) AND invDevice IN (42102,42101,42001); 19/12/2024 08:32:12.6847 553 ms. OPEN: select traId,traDateTime,traEnabled,traDisableTime,traCode,traBadge,traCarId,traAreId,traIdTerminal from movtransit where traStatus='V' and traDirection = 'O' and traCarId = 15 order by traDateTime desc,traId desc 19/12/2024 08:32:13.8895 900 ms. EXEC: insert into movtransit (traUseId,traCreation,traStatus,traUID,traYear,traDateTime,traCode,traType,traClass,traIdTerminal,traDirection,traPlate,traEnabled,traDisableTime,traAreId,traNotes,traBadge,traCarId,traTarId) VALUES (0,'2024-12-19 08:32:12','V',5610530430752000,2024,'2024-12-19 08:32:10','456433073000327001012999',1,2,1,'I','',1,0,1,'','0230003944081',15,0) 19/12/2024 09:11:59.6621 503 ms. EXEC: update payInventory set invCreation = '2024-12-19 09:11:59',invModify = '2024-12-19 09:11:59',invUseId=0,invStatus='V' where invId = 226163 19/12/2024 09:16:51.5208 554 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 19/12/2024 09:21:10.3272 599 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 19/12/2024 09:35:59.3880 648 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 19/12/2024 09:39:16.8280 644 ms. EXEC: UPDATE payInventory SET invType='N' WHERE invType<>'N' AND invValue IN (100,200,500) AND invDevice IN (42102,42101,42001); 19/12/2024 09:48:56.8128 741 ms. EXEC: update abbCards set carLastDate = '2024-12-19 09:48:56',carLastDirection='O' where carStatus='V' and carId = 165 19/12/2024 09:49:07.3575 1049 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 19/12/2024 09:53:46.8145 1175 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 19/12/2024 10:04:28.3849 511 ms. EXEC: insert into movtransit (traUseId,traCreation,traStatus,traUID,traYear,traDateTime,traCode,traType,traClass,traIdTerminal,traDirection,traPlate,traEnabled,traDisableTime,traAreId,traNotes,traBadge,traTarId) VALUES (0,'2024-12-19 10:04:27','V',5496642539159830,2024,'2024-12-19 10:04:27','456433626700327001012999',1,2,1,'I','',1,0,1,'','',4) 19/12/2024 10:04:40.4329 517 ms. EXEC: insert into movOperator (opeCreation,opeTerId,opeUseId,opeDateTime,opeCode,opeDescription) VALUES ('2024-12-19 10:04:39',4,1,'2024-12-19 10:04:39','456433461500327005012999','Payed (Credit Card ) Ticket ') 19/12/2024 10:12:33.2217 870 ms. EXEC: insert into movtransit (traUseId,traCreation,traStatus,traUID,traYear,traDateTime,traCode,traType,traClass,traIdTerminal,traDirection,traPlate,traEnabled,traDisableTime,traAreId,traNotes,traBadge,traTarId) VALUES (0,'2024-12-19 10:12:32','V',4682319590646290,2024,'2024-12-19 10:12:31','456433675100327005012999',1,2,16,'I','',1,0,1,'','',4) (WAIT TIME 205 ms.) 19/12/2024 10:12:34.4065 1182 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 19/12/2024 10:12:50.6403 1141 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 19/12/2024 10:16:04.7027 513 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 19/12/2024 10:17:51.1138 779 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 19/12/2024 10:20:45.8958 1038 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2024-12-19 10:20:44' where payTraUID = 4911381249247580 and payStatus='V' and payEnabled=1 19/12/2024 10:35:54.6895 711 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 16 OR lnsTerId=16) 19/12/2024 10:42:08.9423 861 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 19/12/2024 10:48:56.1024 3785 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 19/12/2024 10:56:08.1757 504 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 19/12/2024 11:02:32.3092 1087 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 19/12/2024 11:04:00.0581 1267 ms. EXEC: insert into payPayment (payCreation,payUseId,payStatus,payUID,payTraUID,payYear,payDateTime,payIdTerminal,payEnabled,payDisableTime,payTarId,payTimeLimit,payType,payCurrency,payAmount,payPayed,payChange,payCardType,payPAN,paySTAN,payIdEvent,payAmountCalc,payDiscountValue,payDiscount,payDiscountType,payVatPercent,payVatAmount) VALUES ('2024-12-19 11:03:58',0,'V',4793205308618710,5218568884706760,2024,'2024-12-19 11:03:58',18,1,0,4,'2024-12-19 11:18:58','C','KES',100,100,0,'','','',1,100,0,0,'',0,0) 19/12/2024 11:05:31.4014 635 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2024-12-19 11:05:30' where payTraUID = 5604229283567360 and payStatus='V' and payEnabled=1 19/12/2024 11:05:46.3528 1067 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 19/12/2024 11:07:31.5076 789 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 19/12/2024 11:08:26.8246 1493 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 19/12/2024 11:11:34.2589 630 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 19/12/2024 11:12:31.8394 2127 ms. EXEC: insert into movtransit (traUseId,traCreation,traStatus,traUID,traYear,traDateTime,traCode,traType,traClass,traIdTerminal,traDirection,traPlate,traEnabled,traDisableTime,traAreId,traNotes,traBadge,traTarId) VALUES (0,'2024-12-19 11:12:29','V',4752813924081370,2024,'2024-12-19 11:12:28','456434034800327005012999',1,2,16,'I','',1,0,1,'','',4) 19/12/2024 11:12:33.9758 1619 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 (WAIT TIME 14 ms.) 19/12/2024 11:13:29.3669 1695 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 19/12/2024 11:15:37.0812 560 ms. EXEC: insert into payPayment (payCreation,payUseId,payStatus,payUID,payTraUID,payYear,payDateTime,payIdTerminal,payEnabled,payDisableTime,payTarId,payTimeLimit,payType,payCurrency,payAmount,payPayed,payChange,payCardType,payPAN,paySTAN,payIdEvent,payAmountCalc,payDiscountValue,payDiscount,payDiscountType,payVatPercent,payVatAmount) VALUES ('2024-12-19 11:12:06',1,'V',5106309664637420,4908779884695880,2024,'2024-12-19 11:12:06',4,1,0,4,'2024-12-19 11:27:06','P','KES',50,50,0,'','','',1,50,0,0,'',0,0) 19/12/2024 11:15:38.3791 557 ms. EXEC: insert into payReceipt (recTraUID,recPayUID,recYear,recDateTime,recText,recInvalid) VALUES (4908779884695880,5106309664637420,2024,'2024-12-19 11:15:37',' Date: 12/19/2024 11:12:06 AM Code: 456433853400327005012999 Entry Date: 12/19/2024 10:42:14 AM Plate: Class: Cars Park: The Mall Gate: Entry 2 ______________________________ Total: 50.00 KES ______________________________ Paid: 50.00 KES __________ Change: 0.00 KES Type: Credit Card Dispozitiv: Manual Cashier 1 # 2400418091 ',0) 19/12/2024 11:16:26.4392 604 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 19/12/2024 11:28:23.4593 735 ms. OPEN: SELECT traId,traCode,traDateTime,traEnabled FROM movTransitId INNER JOIN movTransit ON traId = tidTraId AND tidTraKey=@tidTraKey WHERE traStatus='V' AND traDirection = 'I' AND traCarId = 0 AND traEnabled = 1 ORDER BY traId DESC LIMIT 100 19/12/2024 11:32:26.1548 580 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 19/12/2024 11:32:32.7402 647 ms. EXEC: update tabTerminalReceipt set trcProgressive = 54060, trcLastPrinted = '2400754060', trcLastDate = '2024-12-19 11:32:32' where trcStatus='V' and trcTerId = 18 19/12/2024 11:51:01.3060 782 ms. EXEC: update paycash set casCreation = '2024-12-19 11:51:00',casModify = '2024-12-19 11:51:00',casUseId=0,casStatus='V' where casId = 200757 19/12/2024 11:51:59.2717 506 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2024-12-19 11:51:58',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'; 19/12/2024 11:52:22.9285 789 ms. EXEC: insert into payPayment (payCreation,payUseId,payStatus,payUID,payTraUID,payYear,payDateTime,payIdTerminal,payEnabled,payDisableTime,payTarId,payTimeLimit,payType,payCurrency,payAmount,payPayed,payChange,payCardType,payPAN,paySTAN,payIdEvent,payAmountCalc,payDiscountValue,payDiscount,payDiscountType,payVatPercent,payVatAmount) VALUES ('2024-12-19 11:52:22',0,'V',5194106149863550,5420600091709050,2024,'2024-12-19 11:52:22',18,1,0,4,'2024-12-19 12:07:22','C','KES',50,50,0,'','','',1,50,0,0,'',0,0) 19/12/2024 11:57:22.7962 541 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 2 OR lnsTerId=2) 19/12/2024 12:12:44.0722 2398 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 19/12/2024 12:12:44.9929 919 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); 19/12/2024 12:15:04.9934 1073 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 19/12/2024 12:16:05.4599 1570 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 19/12/2024 12:16:05.9922 529 ms. OPEN: select traId,traDateTime,traEnabled,traDisableTime,traCode,traBadge,traCarId,traAreId,traIdTerminal from movtransit where traStatus='V' and traDirection = 'O' and traCarId = 15 order by traDateTime desc,traId desc 19/12/2024 12:18:40.1144 1006 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 19/12/2024 12:25:33.8254 933 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 5 19/12/2024 12:26:16.0471 791 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 5 19/12/2024 12:39:54.3480 789 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 19/12/2024 12:48:52.1637 825 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 19/12/2024 12:51:16.8642 3030 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 19/12/2024 12:54:26.0293 953 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 19/12/2024 12:56:21.6206 501 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2024-12-19 12:56:20',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'; 19/12/2024 12:57:43.2916 851 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 19/12/2024 12:58:00.2059 578 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 19/12/2024 13:04:30.1870 742 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 19/12/2024 13:19:31.5799 600 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 19/12/2024 13:20:14.9509 797 ms. EXEC: update payReceipt set recCreation = '2024-12-19 13:20:14',recModify = '2024-12-19 13:20:14',recUseId=0,recStatus='V' where recId = 333910 19/12/2024 13:20:50.7058 985 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 19/12/2024 13:26:00.2417 991 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); 19/12/2024 13:27:38.2872 583 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 19/12/2024 13:27:39.1238 825 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2024-12-19 13:27:38' where payTraUID = 4739350027719640 and payStatus='V' and payEnabled=1 19/12/2024 13:31:31.7010 528 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 19/12/2024 13:31:31.7060 551 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 2 OR lnsTerId=2) 19/12/2024 13:31:51.3832 664 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 19/12/2024 13:34:39.7497 510 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 19/12/2024 13:34:43.2540 994 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 2 and terStatus='V' 19/12/2024 13:40:25.3294 1500 ms. EXEC: UPDATE payInventory SET invType='N' WHERE invType<>'N' AND invValue IN (100,200,500) AND invDevice IN (42102,42101,42001); 19/12/2024 13:42:39.1975 1450 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 19/12/2024 13:43:05.7252 1790 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 19/12/2024 13:43:22.1352 801 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 19/12/2024 13:43:45.3778 2735 ms. OPEN: select traId,traDateTime,traEnabled,traDisableTime,traCode,traBadge,traCarId,traAreId,traIdTerminal from movtransit where traStatus='V' and traDirection = 'I' and traCarId = 66 order by traDateTime desc,traId desc 19/12/2024 13:43:52.1663 1620 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 16 OR lnsTerId=16) 19/12/2024 13:45:00.7631 990 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 19/12/2024 13:50:18.1063 1217 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 19/12/2024 13:50:55.3101 738 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 19/12/2024 13:51:53.8493 1003 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2024-12-19 13:51:52' where payTraUID = 5262142786643540 and payStatus='V' and payEnabled=1 19/12/2024 13:52:22.8336 507 ms. EXEC: update tabTerminalReceipt set trcProgressive = 54091, trcLastPrinted = '2400754091', trcLastDate = '2024-12-19 13:52:22' where trcStatus='V' and trcTerId = 18 19/12/2024 14:09:01.9224 577 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 19/12/2024 14:25:48.6933 596 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 19/12/2024 14:26:20.3935 706 ms. OPEN: select traId,traDateTime,traEnabled,traDisableTime,traCode,traBadge,traCarId,traAreId,traIdTerminal from movtransit where traStatus='V' and traDirection = 'I' and traCarId = 106 order by traDateTime desc,traId desc 19/12/2024 14:27:31.6851 5745 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 19/12/2024 14:29:02.7630 545 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 19/12/2024 14:47:38.7255 1036 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 19/12/2024 14:48:12.9664 521 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 19/12/2024 14:48:25.7659 556 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 19/12/2024 14:48:42.5211 953 ms. EXEC: update paycash set casCreation = '2024-12-19 14:48:41',casModify = '2024-12-19 14:48:41',casUseId=0,casStatus='V' where casId = 200819 19/12/2024 14:48:43.3837 862 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2024-12-19 14:48:41',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'; 19/12/2024 14:48:44.4424 931 ms. EXEC: insert into paycash (casCreation,casModify,casUseId,casStatus,casUID,casTraUID,casYear,casDateTime,casIdTerminal,casCurrency,casNumber,casSingleAmount,casTotAmount,casType,casDescription) VALUES ('2024-12-19 14:48:43',0,0,'V',5503177310670100,5127564648459620,2024,'2024-12-19 14:48:43',3,'KES',-1,50,-50,'N',''); 19/12/2024 14:57:41.4393 823 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 19/12/2024 14:57:45.0787 570 ms. EXEC: insert into payPayment (payCreation,payUseId,payStatus,payUID,payTraUID,payYear,payDateTime,payIdTerminal,payEnabled,payDisableTime,payTarId,payTimeLimit,payType,payCurrency,payAmount,payPayed,payChange,payCardType,payPAN,paySTAN,payIdEvent,payAmountCalc,payDiscountValue,payDiscount,payDiscountType,payVatPercent,payVatAmount) VALUES ('2024-12-19 14:54:15',1,'V',5617700957145790,4714247349119170,2024,'2024-12-19 14:54:15',4,1,0,4,'2024-12-19 15:09:15','P','KES',50,50,0,'','','',1,50,0,0,'',0,0) 19/12/2024 15:01:02.1125 619 ms. EXEC: UPDATE payInventory SET invType='N' WHERE invType<>'N' AND invValue IN (100,200,500) AND invDevice IN (42102,42101,42001); 19/12/2024 15:13:14.6348 1281 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 19/12/2024 15:14:18.8855 507 ms. OPEN: select traId,traDateTime,traEnabled,traDisableTime,traCode,traBadge,traCarId,traAreId,traIdTerminal from movtransit where traStatus='V' and traDirection = 'I' and traCarId = 17 order by traDateTime desc,traId desc 19/12/2024 15:14:40.2419 612 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 19/12/2024 15:14:40.4150 827 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 16 OR lnsTerId=16) 19/12/2024 15:20:27.7788 677 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 19/12/2024 15:21:56.3495 607 ms. EXEC: insert into movtransit (traUseId,traCreation,traStatus,traUID,traYear,traDateTime,traCode,traType,traClass,traIdTerminal,traDirection,traPlate,traEnabled,traDisableTime,traAreId,traNotes,traBadge,traTarId) VALUES (0,'2024-12-19 15:21:55','V',5262277611212190,2024,'2024-12-19 15:21:55','456435480900327005012999',2,2,2,'O','',0,'2024-12-19 15:21:55',1,'','',0) 19/12/2024 15:22:22.3423 872 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2024-12-19 15:22:21' where payTraUID = 5273319136110920 and payStatus='V' and payEnabled=1 19/12/2024 15:24:11.7745 862 ms. EXEC: update payInventory set invCreation = '2024-12-19 15:24:10',invModify = '2024-12-19 15:24:10',invUseId=0,invStatus='V' where invId = 226270 19/12/2024 15:25:29.3311 1006 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2024-12-19 15:25:28' where payTraUID = 5481113342195230 and payStatus='V' and payEnabled=1 19/12/2024 15:26:11.7638 530 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2024-12-19 15:26:11' where traUID = 5052952136029270 and traStatus='V' and traEnabled=1 19/12/2024 15:32:49.7709 620 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 19/12/2024 15:45:14.3499 1356 ms. EXEC: insert into movtransit (traUseId,traCreation,traStatus,traUID,traYear,traDateTime,traCode,traType,traClass,traIdTerminal,traDirection,traPlate,traEnabled,traDisableTime,traAreId,traNotes,traBadge,traTarId) VALUES (0,'2024-12-19 15:45:12','V',5563021482648140,2024,'2024-12-19 15:45:11','456435226700327001012999',2,2,2,'O','',0,'2024-12-19 15:45:12',1,'','',0) 19/12/2024 15:46:47.3357 621 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 19/12/2024 15:50:37.8298 1682 ms. EXEC: UPDATE payInventory SET invType='N' WHERE invType<>'N' AND invValue IN (100,200,500) AND invDevice IN (42102,42101,42001); 19/12/2024 15:59:33.6476 527 ms. EXEC: insert into payReceipt (recTraUID,recPayUID,recYear,recDateTime,recText,recInvalid) VALUES (5736041513566970,5162853533204150,2024,'2024-12-19 15:59:33',' Date: 12/19/2024 3:56:04 PM Code: 456435664600327005012999 Entry Date: 12/19/2024 3:44:06 PM Plate: Class: Cars Park: The Mall Gate: Entry 2 ______________________________ Total: 50.00 KES ______________________________ Paid: 50.00 KES __________ Change: 0.00 KES Type: Credit Card Dispozitiv: Manual Cashier 1 # 2400418127 ',0) 19/12/2024 16:04:32.6192 923 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2024-12-19 16:04:31',3,42101,0,50,-1,-50,1,'O','N'); update payCurInventory set curQuantity=round(curQuantity+-1,5),curAmount=round(curAmount+-50,5) where curTerId = 3 and curDevCode = 42101 and curChannelId = 1 and curValue = 50 and curType = 'N'; Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2024-12-19 16:04:31',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'; 19/12/2024 16:04:34.5455 1181 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 19/12/2024 16:08:58.8175 534 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 19/12/2024 16:21:26.6142 1221 ms. EXEC: update opeActivities set acvFstPayId = (case acvFstPayId when 0 then 384688 else acvFstPayId end),acvLstPayId = 384688 where acvSftId = 855 and acvCodeId = 3 19/12/2024 16:22:09.2917 1075 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2024-12-19 16:22:08' where payTraUID = 5493825692526760 and payStatus='V' and payEnabled=1 19/12/2024 16:22:28.8548 511 ms. EXECSCALAR: select count(*) from information_schema.tables where table_schema= 'wisepark_0327' and table_name= 'payInvoiceFtp' nr: 1 19/12/2024 16:22:38.4372 690 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 19/12/2024 16:23:36.9353 939 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 19/12/2024 16:23:46.2335 1018 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 19/12/2024 16:25:28.8771 780 ms. EXEC: INSERT INTO movOperator (opeCreation,opeUseId,opeTerId,opeDateTime,opeCode,opeDescription) VALUES ('2024-12-19 16:25:28',0,16,'2024-12-19 16:25:28','','Unauthorized Transit Entry 2') 19/12/2024 16:26:25.9823 855 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 19/12/2024 17:02:29.4897 1249 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 19/12/2024 17:04:50.9002 917 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 19/12/2024 17:08:47.7152 1850 ms. EXEC: update opeActivities set acvFstPayId = (case acvFstPayId when 0 then 384708 else acvFstPayId end),acvLstPayId = 384708 where acvSftId = 855 and acvCodeId = 3 19/12/2024 17:10:35.8945 906 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 19/12/2024 17:10:52.1448 650 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 19/12/2024 17:20:22.6333 862 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 19/12/2024 17:41:02.5101 1358 ms. EXEC: update paycash set casCreation = '2024-12-19 17:41:01',casModify = '2024-12-19 17:41:01',casUseId=0,casStatus='V' where casId = 200858 19/12/2024 17:41:02.5181 900 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 19/12/2024 17:55:12.0168 554 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2024-12-19 17:55:11' where traUID = 5338869376864040 and traStatus='V' and traEnabled=1 19/12/2024 18:06:10.3546 520 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 2 OR lnsTerId=2) 19/12/2024 18:12:32.7206 689 ms. EXEC: insert into payPayment (payCreation,payUseId,payStatus,payUID,payTraUID,payYear,payDateTime,payIdTerminal,payEnabled,payDisableTime,payTarId,payTimeLimit,payType,payCurrency,payAmount,payPayed,payChange,payCardType,payPAN,paySTAN,payIdEvent,payVatPercent,payVatAmount) VALUES ('2024-12-19 18:12:32',0,'V',5561905249323660,4778599352398400,2024,'2024-12-19 18:12:32',2,1,0,-1,'2024-12-19 19:12:32','S','KES',0,0,0,'','','',3,0,0) 19/12/2024 18:12:55.3748 828 ms. EXEC: update abbCards set carLastDate = '2024-12-19 18:12:54',carLastDirection='O' where carStatus='V' and carId = 31 19/12/2024 18:13:25.0427 840 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 19/12/2024 18:16:57.9411 755 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 19/12/2024 18:21:51.8165 526 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 19/12/2024 18:23:15.6824 580 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 19/12/2024 18:25:16.7137 714 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 19/12/2024 18:26:53.6395 577 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 19/12/2024 18:28:33.7491 1733 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 19/12/2024 18:28:35.5003 1406 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2024-12-19 18:28:34' where payTraUID = 5459843720121500 and payStatus='V' and payEnabled=1 19/12/2024 18:29:30.1230 588 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 19/12/2024 18:31:06.5884 627 ms. EXEC: insert into payPayment (payCreation,payUseId,payStatus,payUID,payTraUID,payYear,payDateTime,payIdTerminal,payEnabled,payDisableTime,payTarId,payTimeLimit,payType,payCurrency,payAmount,payPayed,payChange,payCardType,payPAN,paySTAN,payIdEvent,payAmountCalc,payDiscountValue,payDiscount,payDiscountType,payVatPercent,payVatAmount) VALUES ('2024-12-19 18:31:05',0,'V',5182511088034830,4860532513683530,2024,'2024-12-19 18:31:05',18,1,0,4,'2024-12-19 18:46:05','C','KES',50,50,0,'','','',1,50,0,0,'',0,0) 19/12/2024 18:44:54.6096 578 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2024-12-19 18:44:53' where traUID = 5150061512778190 and traStatus='V' and traEnabled=1 19/12/2024 18:49:40.6538 1174 ms. EXEC: UPDATE payInventory SET invType='N' WHERE invType<>'N' AND invValue IN (100,200,500) AND invDevice IN (42102,42101,42001); 19/12/2024 18:50:33.1429 860 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 19/12/2024 19:06:37.2623 758 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 19/12/2024 19:20:40.2473 1081 ms. OPEN: select count(payId) as Tot,0 as payUID,sum(payPayed) as payPayed,sum(payChange) as payChange,payAmount,traUIDGroup,traType,traClass,traIdTerminal,traDiscountValue,traDiscountType,traCarId,payIdEvent,payType,payCardType from payPayment LEFT join movtransit on trauid = payTraUID LEFT JOIN payReport ON repPayUID = payUID AND repStatus='V' where payStatus = 'V' and (payType='C' or payType='P') and payUseId = 9 and payIdEvent<90 and repPayUID IS NULL and (traCarId is null or traCarId=0 or traCarId in (select carId from abbCards inner join abbsubscriptions on subId= carSubId where carStatus='V' and subStatus='V' and subAbbType<>5)) group by traUIDGroup,payAmount,payIdEvent,payType,payCardType,traType,traIdTerminal,traDiscountValue,traDiscountType,traCarId order by traUIDGroup,payAmount, traType, traDiscountValue, traDiscountType 19/12/2024 19:34:05.0384 790 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 19/12/2024 19:34:54.3232 921 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 5 19/12/2024 19:41:13.5674 601 ms. EXEC: insert into movtransit (traUseId,traCreation,traStatus,traUID,traYear,traDateTime,traCode,traType,traClass,traIdTerminal,traDirection,traPlate,traEnabled,traDisableTime,traAreId,traNotes,traBadge,traCarId,traTarId) VALUES (0,'2024-12-19 19:41:12','V',5695922516997360,2024,'2024-12-19 19:41:11','456437087100327005012999',1,2,16,'I','',1,0,1,'','0230004100967',12,0) 19/12/2024 19:44:46.8208 999 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 19/12/2024 19:56:22.8451 558 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 19/12/2024 20:00:25.3982 516 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2024-12-19 20:00:24',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'; 19/12/2024 20:07:55.1869 775 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 2 OR lnsTerId=2) 19/12/2024 20:07:55.3260 566 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 19/12/2024 20:32:04.7046 696 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 19/12/2024 20:54:46.8136 1547 ms. EXEC: UPDATE payInventory SET invType='N' WHERE invType<>'N' AND invValue IN (100,200,500) AND invDevice IN (42102,42101,42001); 19/12/2024 20:55:37.0135 621 ms. EXEC: UPDATE payInventory SET invType='N' WHERE invType<>'N' AND invValue IN (100,200,500) AND invDevice IN (42102,42101,42001); 19/12/2024 20:57:45.6493 766 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 19/12/2024 21:20:32.2883 1181 ms. EXEC: insert into payReceipt (recTraUID,recPayUID,recYear,recDateTime,recText,recInvalid) VALUES (5512290487577300,5113628636604680,2024,'2024-12-19 21:20:31',' Date: 12/19/2024 9:17:02 PM Code: 456437354000327005012999 Entry Date: 12/19/2024 8:25:40 PM Plate: Class: Cars Park: The Mall Gate: Entry 2 ______________________________ Total: 50.00 KES ______________________________ Paid: 50.00 KES __________ Change: 0.00 KES Type: Credit Card Dispozitiv: Manual Cashier 1 # 2400418148 ',0) 19/12/2024 21:21:34.9415 864 ms. EXEC: insert into movOperator (opeCreation,opeTerId,opeUseId,opeDateTime,opeCode,opeDescription) VALUES ('2024-12-19 21:21:34',4,1,'2024-12-19 21:21:34','456436829500327005012999','Payed (Credit Card ) Ticket ') 19/12/2024 21:21:36.1273 619 ms. EXEC: insert into payReceipt (recTraUID,recPayUID,recYear,recDateTime,recText,recInvalid) VALUES (4777475805409240,5470942834334520,2024,'2024-12-19 21:21:35',' Date: 12/19/2024 9:18:05 PM Code: 456436829500327005012999 Entry Date: 12/19/2024 6:58:15 PM Plate: Class: Cars Park: The Mall Gate: Entry 2 ______________________________ Total: 100.00 KES ______________________________ Paid: 100.00 KES __________ Change: 0.00 KES Type: Credit Card Dispozitiv: Manual Cashier 1 # 2400418149 ',0) 19/12/2024 21:21:36.8988 818 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 19/12/2024 21:21:37.2630 1133 ms. EXEC: update payReceipt set recCreation = '2024-12-19 21:21:36',recModify = '2024-12-19 21:21:36',recUseId=0,recStatus='V' where recId = 334122 19/12/2024 21:23:13.2938 624 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 19/12/2024 21:24:11.4800 518 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 4 OR lnsTerId=4) 19/12/2024 21:27:09.0770 553 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 19/12/2024 21:32:48.3001 1200 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 19/12/2024 21:32:59.8778 981 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 19/12/2024 21:33:07.0988 1084 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 19/12/2024 21:33:45.1839 1239 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 3 19/12/2024 21:33:48.3730 1234 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 19/12/2024 21:35:20.4068 1361 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 19/12/2024 22:02:33.5142 594 ms. EXEC: update abbCards set carLastDate = '2024-12-19 22:02:32',carLastDirection='O' where carStatus='V' and carId = 15 19/12/2024 22:04:53.7699 576 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 19/12/2024 22:08:24.2563 890 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 19/12/2024 22:11:06.2206 1897 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 19/12/2024 22:16:33.6392 631 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 19/12/2024 22:16:34.5589 577 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2024-12-19 22:16:33' where payTraUID = 4891553930448150 and payStatus='V' and payEnabled=1 19/12/2024 22:32:13.0932 953 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2024-12-19 22:32:12' where payTraUID = 4880916984993430 and payStatus='V' and payEnabled=1 19/12/2024 22:35:30.8060 780 ms. OPEN: show columns from tabParameters where Field = 'parForce24Hours' 19/12/2024 22:35:31.7206 1639 ms. EXECSCALAR: select count(*) from information_schema.tables where table_schema= 'wisepark_0327' and table_name= 'payInvoiceFtp' nr: 1 19/12/2024 22:38:35.9311 537 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 19/12/2024 22:59:43.0715 924 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 19/12/2024 22:59:45.9754 540 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 19/12/2024 23:02:46.1123 672 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 19/12/2024 23:58:21.8666 771 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 19/12/2024 23:58:24.1481 924 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1