22/08/2025 05:18:18.6636 3737 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 22/08/2025 05:18:35.1306 4334 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 22/08/2025 05:19:03.7935 7879 ms. EXECSCALAR: select count(0) as vTot from tabParameters where parPlateReading<>0 nr: 0 22/08/2025 05:19:14.5207 10648 ms. EXECSCALAR: select count(0) as vTot from tabParameters where parPlateReading<>0 nr: 0 22/08/2025 05:19:26.8289 2689 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-08-22 05:19:24','V',5677786792057490,2025,'2025-08-22 05:19:17','458891828300327005012999',2,2,2,'O','',0,'2025-08-22 05:19:24',1,'','',0) 22/08/2025 05:19:35.7504 763 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 22/08/2025 05:19:58.2328 4750 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 22/08/2025 05:20:08.1275 2225 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 22/08/2025 05:20:53.7742 11364 ms. OPEN: select * from tabClass where claPosition = 2 22/08/2025 05:21:05.5642 7183 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 22/08/2025 05:22:19.4640 7494 ms. EXECSCALAR: select count(resId) as Tot from movReservation where resStatus = 'V' and resTypeRes = 'B' AND ((resConfirmed IN (0,2,3) AND resCreation>'2025-08-22 04:22:09') OR resConfirmed IN (4,5)) and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) <= '2025-08-22 05:22:08' and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) >= '2025-08-22 05:22:08' and (resAreId = 1 or resAreId <= 0) nr: 0 22/08/2025 05:22:20.3536 9791 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 (WAIT TIME 1281 ms.) 22/08/2025 05:22:22.2887 1253 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 (WAIT TIME 277 ms.) 22/08/2025 05:22:22.6350 1536 ms. OPEN: select * from tabDevice where devId = 2 and devStatus = 'V' (WAIT TIME 624 ms.) 22/08/2025 05:22:23.3475 611 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 22/08/2025 05:22:23.7348 1090 ms. OPEN: SELECT * FROM tabCardConversionRules WHERE ccrStatus=@ccrStatus AND (ccrTerId = @ccrTerId OR ccrTerId=0) AND (ccrDevId = @ccrDevId OR ccrDevId=0) AND (ccrSubId = @ccrSubId OR ccrSubId=0) ORDER BY ccrTerId DESC, ccrDevId DESC, ccrSubId DESC, ccrId DESC LIMIT 1 22/08/2025 05:22:28.4394 5744 ms. EXECSCALAR: select count(0) as vTot from tabParameters where parPlateReading<>0 nr: 0 22/08/2025 05:22:32.3854 2693 ms. EXECSCALAR: SELECT traId FROM movTransit WHERE traStatus='V' AND traCode = @traCode nr: 1005937 22/08/2025 05:22:32.4204 2613 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 1 22/08/2025 05:22:37.3510 2579 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 22/08/2025 05:22:38.0656 613 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 22/08/2025 05:22:38.5930 6207 ms. OPEN: select * from movtransit where trastatus='V' and (traCode = '458891828300327005012999') and traDirection='I' order by traId desc limit 1 22/08/2025 05:22:38.5930 6012 ms. EXECSCALAR: select count(resId) as Tot from movReservation where resStatus = 'V' and resTypeRes = 'B' AND ((resConfirmed IN (0,2,3) AND resCreation>'2025-08-22 04:22:32') OR resConfirmed IN (4,5)) and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) <= '2025-08-22 05:22:32' and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) >= '2025-08-22 05:22:32' and (resAreId = 1 or resAreId <= 0) nr: 0 22/08/2025 05:22:38.7171 4547 ms. OPEN: select sum(crc32(devDescription)) as vCheck from tabDevice (WAIT TIME 122 ms.) 22/08/2025 05:23:00.8868 22101 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 22/08/2025 05:23:01.9888 10911 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 2 (WAIT TIME 614 ms.) 22/08/2025 05:23:01.9898 22653 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 (WAIT TIME 642 ms.) 22/08/2025 05:23:02.0228 1162 ms. EXECSCALAR: select count(0) as vTot from tabParameters where parPlateReading<>0 nr: 0 (WAIT TIME 190 ms.) 22/08/2025 05:23:02.0248 877 ms. EXECSCALAR: select count(0) as vTot from tabParameters where parPlateReading<>0 nr: 0 (WAIT TIME 224 ms.) 22/08/2025 05:23:02.6702 15920 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 (WAIT TIME 226 ms.) 22/08/2025 05:23:02.6712 15909 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 2 (WAIT TIME 871 ms.) 22/08/2025 05:23:02.6712 23025 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 (WAIT TIME 858 ms.) 22/08/2025 05:23:02.6722 23260 ms. OPEN: select sum(casTotAmount) as vTot from movTransit inner join payCash on payCash.casTraUID = movTransit.traUID inner join tabTerminal on terId = casIdTerminal where traCode = '458891828300327005012999' and traStatus='V' and casStatus='V' and terType=3 and casTotAmount>0 (WAIT TIME 702 ms.) 22/08/2025 05:23:02.7363 679 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 (WAIT TIME 67 ms.) 22/08/2025 05:23:02.9184 521 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 (WAIT TIME 104 ms.) 22/08/2025 05:23:03.4500 776 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 2 OR lnsTerId=2) 22/08/2025 05:23:03.4860 1496 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 3 22/08/2025 05:23:05.9297 2183 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 2 and terStatus='V' 22/08/2025 05:23:05.9798 3118 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 2 OR lnsTerId=2) (WAIT TIME 48 ms.) 22/08/2025 05:23:05.9818 2402 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 (WAIT TIME 51 ms.) 22/08/2025 05:23:05.9818 27182 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 (WAIT TIME 15 ms.) 22/08/2025 05:23:06.5595 2552 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 2 OR lnsTerId=2) (WAIT TIME 197 ms.) 22/08/2025 05:23:06.8827 3433 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 6 (WAIT TIME 690 ms.) 22/08/2025 05:23:07.1629 3510 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 1 (WAIT TIME 978 ms.) 22/08/2025 05:23:08.0585 3452 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 = '458891828300327005012999' AND traStatus='V' AND payStatus='V' and (terType IS NULL OR terType<>3 OR (terType=3 and payType='P')) (WAIT TIME 1603 ms.) 22/08/2025 05:23:08.0595 3047 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 (WAIT TIME 1525 ms.) 22/08/2025 05:23:08.2936 5644 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 2 OR lnsTerId=2) (WAIT TIME 1759 ms.) 22/08/2025 05:23:08.2946 27798 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 3 OR lnsTerId=3) (WAIT TIME 1709 ms.) 22/08/2025 05:23:08.6869 3915 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 16 OR lnsTerId=16) (WAIT TIME 1910 ms.) 22/08/2025 05:23:09.0351 507 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 (WAIT TIME 1601 ms.) 22/08/2025 05:23:09.0842 983 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 2 (WAIT TIME 1216 ms.) 22/08/2025 05:23:09.0842 704 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 (WAIT TIME 1216 ms.) 22/08/2025 05:23:09.3013 667 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 (WAIT TIME 552 ms.) 22/08/2025 05:23:11.9311 1833 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 5 22/08/2025 05:23:12.0091 2415 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 22/08/2025 05:23:14.7070 5097 ms. EXEC: update tabTerminalExtraMem SET extLoop2 = 0 where extStatus='V' and extTerId = 2 AND extPlateWaitOperator=0 (WAIT TIME 299 ms.) 22/08/2025 05:23:14.7080 5149 ms. EXECSCALAR: select count(resId) as Tot from movReservation where resStatus = 'V' and resTypeRes = 'B' AND ((resConfirmed IN (0,2,3) AND resCreation>'2025-08-22 04:23:09') OR resConfirmed IN (4,5)) and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) <= '2025-08-22 05:23:05' and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) >= '2025-08-22 05:23:05' and (resAreId = 1 or resAreId <= 0) nr: 0 (WAIT TIME 250 ms.) 22/08/2025 05:23:15.2094 910 ms. EXECSCALAR: select count(0) as vTot from tabParameters where parPlateReading<>0 nr: 0 22/08/2025 05:23:18.2472 2534 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 22/08/2025 05:23:19.4170 3776 ms. EXECSCALAR: select count(resId) as Tot from movReservation where resStatus = 'V' and resTypeRes = 'B' AND ((resConfirmed IN (0,2,3) AND resCreation>'2025-08-22 04:23:15') OR resConfirmed IN (4,5)) and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) <= '2025-08-22 05:23:12' and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) >= '2025-08-22 05:23:12' and (resAreId = 1 or resAreId <= 0) nr: 0 22/08/2025 05:23:21.1703 1649 ms. OPEN: select ticId from tabTicketType where ticStatus='V' and ticType = 1 22/08/2025 05:23:21.2873 656 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 (WAIT TIME 100 ms.) 22/08/2025 05:23:21.2883 697 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 5 and terStatus='V' (WAIT TIME 51 ms.) 22/08/2025 05:23:22.7483 1287 ms. EXECSCALAR: select count(rulId) from tabTicketRules where rulStatus='V' and rulTerId = 2 and rulDevId = 5 and rulTicId = 1 nr: 0 (WAIT TIME 72 ms.) 22/08/2025 05:23:23.1646 3743 ms. EXECSCALAR: select count(resId) as Tot from movReservation where resStatus = 'V' and resTypeRes = 'B' AND ((resConfirmed IN (0,2,3) AND resCreation>'2025-08-22 04:23:19') OR resConfirmed IN (4,5)) and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) <= '2025-08-22 05:23:18' and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) >= '2025-08-22 05:23:18' and (resAreId = 1 or resAreId <= 0) nr: 0 22/08/2025 05:23:28.5425 553 ms. OPEN: select * from movExtraRules where exrTraId in (select traId from movtransit where traCode = '458891828300327005012999') 22/08/2025 05:23:29.8818 5871 ms. OPEN: show columns from movoperator where Field = 'opeQuery' 22/08/2025 05:23:31.6864 1682 ms. EXEC: INSERT INTO movOperator (opeCreation,opeUseId,opeTerId,opeDateTime,opeCode,opeDescription) VALUES ('2025-08-22 05:23:30',0,2,'2025-08-22 05:23:30','','Unauthorized Transit Exit 1') 22/08/2025 05:23:31.9756 1507 ms. EXECSCALAR: select count(resId) as Tot from movReservation where resStatus = 'V' and resTypeRes = 'B' AND ((resConfirmed IN (0,2,3) AND resCreation>'2025-08-22 04:23:30') OR resConfirmed IN (4,5)) and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) <= '2025-08-22 05:23:26' and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) >= '2025-08-22 05:23:26' and (resAreId = 1 or resAreId <= 0) nr: 0 22/08/2025 05:23:32.2758 1112 ms. EXECSCALAR: select count(resId) as Tot from movReservation where resStatus = 'V' and resTypeRes = 'B' AND ((resConfirmed IN (0,2,3) AND resCreation>'2025-08-22 04:23:31') OR resConfirmed IN (4,5)) and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) <= '2025-08-22 05:23:30' and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) >= '2025-08-22 05:23:30' and (resAreId = 1 or resAreId <= 0) nr: 0 22/08/2025 05:23:33.7924 829 ms. OPEN: select * from abbCards inner join abbSubscriptions on carSubId = subId inner join tabCustomer on cusId = subCusId left join tabAbbGroups on cusAbgId = abgId where carStatus='V' and subStatus='V' and cusStatus='V' and (carCode = '458891828300327005012999') 22/08/2025 05:23:34.7560 504 ms. OPEN: select paypayment.payClosePeriod from movtransit inner join paypayment on movtransit.traUID=paypayment.payTraUID where paypayment.payStatus='V' and movtransit.traCode=@TRACODE and paypayment.payClosePeriod is not null order by paypayment.payClosePeriod desc 22/08/2025 05:24:10.1668 4893 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 22/08/2025 05:25:29.0805 2052 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 22/08/2025 05:26:00.4795 1630 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 22/08/2025 05:26:22.0519 1471 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 2 OR lnsTerId=2) 22/08/2025 05:26:36.2924 7956 ms. OPEN: select distinct tagName from tabtag where tagstatus='V' and tagMandatory=1 and tagDevCode in (select devCode from tabDevice where devStatus='V' and devId in (select lnkSubId from tabLnkDevice where lnkStatus='V' and lnkDevId = (select devId from tabDevice inner join tabTerminal on terType = devCode where terId = 2))) order by tagName 22/08/2025 05:26:36.8367 503 ms. OPEN: select * from tabUser where useStatus='V' and useBadId<>'' and useParkAccess<>0 order by useSuperUser desc,useId 22/08/2025 05:26:36.8377 501 ms. OPEN: select * from tabUser where useStatus='V' and useBadId<>'' and useParkAccess<>0 order by useSuperUser desc,useId 22/08/2025 05:26:45.1032 8268 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 22/08/2025 05:26:45.1213 8278 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 22/08/2025 05:26:45.5896 8751 ms. OPEN: select * from tabDevice where devId = 2 and devStatus = 'V' 22/08/2025 05:26:45.5896 8751 ms. OPEN: select * from tabDevice where devId = 2 and devStatus = 'V' 22/08/2025 05:26:50.2447 3975 ms. OPEN: select * from payCurInventory where curTerId = 2 order by curDevCode,curChannelId,curValue,curType,curAmount desc 22/08/2025 05:26:50.2467 3973 ms. OPEN: select * from payCurInventory where curTerId = 2 order by curDevCode,curChannelId,curValue,curType,curAmount desc 22/08/2025 05:26:50.2477 3970 ms. OPEN: select * from payCurInventory where curTerId = 2 order by curDevCode,curChannelId,curValue,curType,curAmount desc 22/08/2025 05:26:50.2497 3970 ms. OPEN: select * from tabTerminal where terStatus = 'V' and terAddress = 2 22/08/2025 05:27:14.7810 6799 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 22/08/2025 05:27:27.1303 4974 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 22/08/2025 05:27:27.1413 4989 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 22/08/2025 05:27:27.1503 4995 ms. EXECSCALAR: select count(0) as vTot from tabParameters where parPlateReading<>0 nr: 0 22/08/2025 05:27:27.1563 5009 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 2 22/08/2025 05:27:27.1773 5028 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 6 22/08/2025 05:27:35.9542 529 ms. EXECSCALAR: select count(resId) as Tot from movReservation where resStatus = 'V' and resTypeRes = 'B' AND ((resConfirmed IN (0,2,3) AND resCreation>'2025-08-22 04:27:35') OR resConfirmed IN (4,5)) and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) <= '2025-08-22 05:27:35' and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) >= '2025-08-22 05:27:35' and (resAreId = 1 or resAreId <= 0) nr: 0 (WAIT TIME 287 ms.) 22/08/2025 05:27:40.2030 4124 ms. OPEN: select * from tabArea where areStatus='V' and areEnabled = 1 AND areId = 1 22/08/2025 05:27:40.2070 4126 ms. EXECSCALAR: select count(0) as vTot from tabParameters where parPlateReading<>0 nr: 0 22/08/2025 05:27:40.2410 4173 ms. EXECSCALAR: select count(resId) as Tot from movReservation where resStatus = 'V' and resTypeRes = 'B' AND ((resConfirmed IN (0,2,3) AND resCreation>'2025-08-22 04:27:36') OR resConfirmed IN (4,5)) and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) <= '2025-08-22 05:27:35' and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) >= '2025-08-22 05:27:35' and (resAreId = 1 or resAreId <= 0) nr: 0 22/08/2025 05:29:31.1170 3955 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 22/08/2025 05:29:53.2117 3690 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 22/08/2025 05:30:37.2641 5336 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 22/08/2025 05:31:24.2204 9590 ms. OPEN: SELECT * FROM tabTerminalExtraMem WHERE extStatus=@extStatus AND extTerId = @extTerId 22/08/2025 05:31:29.2638 5015 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-08-22 05:31:24','V',5272504799545230,2025,'2025-08-22 05:31:02','458891986200327005012999',1,2,16,'I','',1,0,1,'','',4) 22/08/2025 05:31:29.3739 4604 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 5 22/08/2025 05:31:29.3909 4637 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 1 22/08/2025 05:31:50.1057 15195 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 22/08/2025 05:31:55.2672 5072 ms. EXECSCALAR: select count(*) from tabTerminalExtraMem where extStatus='V' and extTerId = 16 nr: 1 22/08/2025 05:32:28.0490 637 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 22/08/2025 05:32:34.2117 721 ms. EXECSCALAR: select count(0) as vTot from tabParameters where parPlateReading<>0 nr: 0 (WAIT TIME 6161 ms.) 22/08/2025 05:32:34.9482 8512 ms. EXECSCALAR: select count(resId) as Tot from movReservation where resStatus = 'V' and resTypeRes = 'B' AND ((resConfirmed IN (0,2,3) AND resCreation>'2025-08-22 04:32:25') OR resConfirmed IN (4,5)) and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) <= '2025-08-22 05:32:25' and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) >= '2025-08-22 05:32:25' and (resAreId = 1 or resAreId <= 0) nr: 0 (WAIT TIME 243 ms.) 22/08/2025 05:32:40.8398 3449 ms. EXECSCALAR: select count(resId) as Tot from movReservation where resStatus = 'V' and resTypeRes = 'B' AND ((resConfirmed IN (0,2,3) AND resCreation>'2025-08-22 04:32:37') OR resConfirmed IN (4,5)) and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) <= '2025-08-22 05:32:36' and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) >= '2025-08-22 05:32:36' and (resAreId = 1 or resAreId <= 0) nr: 0 22/08/2025 05:32:40.8729 2064 ms. EXECSCALAR: select count(resId) as Tot from movReservation where resStatus = 'V' and resTypeRes = 'B' AND ((resConfirmed IN (0,2,3) AND resCreation>'2025-08-22 04:32:38') OR resConfirmed IN (4,5)) and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) <= '2025-08-22 05:32:38' and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) >= '2025-08-22 05:32:38' and (resAreId = 1 or resAreId <= 0) nr: 0 (WAIT TIME 32 ms.) 22/08/2025 05:32:50.7437 2720 ms. EXECSCALAR: select count(resId) as Tot from movReservation where resStatus = 'V' and resTypeRes = 'B' AND ((resConfirmed IN (0,2,3) AND resCreation>'2025-08-22 04:32:48') OR resConfirmed IN (4,5)) and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) <= '2025-08-22 05:32:48' and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) >= '2025-08-22 05:32:48' and (resAreId = 1 or resAreId <= 0) nr: 0 22/08/2025 05:32:51.2061 788 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 3 (WAIT TIME 461 ms.) 22/08/2025 05:32:51.2071 865 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 (WAIT TIME 461 ms.) 22/08/2025 05:33:12.0436 6817 ms. EXECSCALAR: select count(resId) as Tot from movReservation where resStatus = 'V' and resTypeRes = 'B' AND ((resConfirmed IN (0,2,3) AND resCreation>'2025-08-22 04:33:05') OR resConfirmed IN (4,5)) and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) <= '2025-08-22 05:33:05' and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) >= '2025-08-22 05:33:05' and (resAreId = 1 or resAreId <= 0) nr: 0 22/08/2025 05:33:19.2144 3516 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 (WAIT TIME 249 ms.) 22/08/2025 05:33:19.2154 4010 ms. EXECSCALAR: select count(resId) as Tot from movReservation where resStatus = 'V' and resTypeRes = 'B' AND ((resConfirmed IN (0,2,3) AND resCreation>'2025-08-22 04:33:14') OR resConfirmed IN (4,5)) and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) <= '2025-08-22 05:33:14' and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) >= '2025-08-22 05:33:14' and (resAreId = 1 or resAreId <= 0) nr: 0 (WAIT TIME 251 ms.) 22/08/2025 05:33:27.0231 1015 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 22/08/2025 05:33:28.3970 1156 ms. EXECSCALAR: select count(0) as vTot from tabParameters where parPlateReading<>0 nr: 0 22/08/2025 05:33:28.3980 1072 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 22/08/2025 05:33:28.7183 2776 ms. EXECSCALAR: select count(resId) as Tot from movReservation where resStatus = 'V' and resTypeRes = 'B' AND ((resConfirmed IN (0,2,3) AND resCreation>'2025-08-22 04:33:25') OR resConfirmed IN (4,5)) and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) <= '2025-08-22 05:33:24' and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) >= '2025-08-22 05:33:24' and (resAreId = 1 or resAreId <= 0) nr: 0 22/08/2025 05:33:35.8396 1361 ms. EXECSCALAR: select count(resId) as Tot from movReservation where resStatus = 'V' and resTypeRes = 'B' AND ((resConfirmed IN (0,2,3) AND resCreation>'2025-08-22 04:33:34') OR resConfirmed IN (4,5)) and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) <= '2025-08-22 05:33:34' and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) >= '2025-08-22 05:33:34' and (resAreId = 1 or resAreId <= 0) nr: 0 22/08/2025 05:33:41.0084 772 ms. EXECSCALAR: select count(resId) as Tot from movReservation where resStatus = 'V' and resTypeRes = 'B' AND ((resConfirmed IN (0,2,3) AND resCreation>'2025-08-22 04:33:40') OR resConfirmed IN (4,5)) and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) <= '2025-08-22 05:33:40' and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) >= '2025-08-22 05:33:40' and (resAreId = 1 or resAreId <= 0) nr: 0 22/08/2025 05:38:28.7729 54907 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 22/08/2025 06:53:42.9624 1000 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 22/08/2025 07:37:40.8099 687 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 22/08/2025 07:42:35.6845 812 ms. OPEN: select traId,traDateTime,traEnabled,traDisableTime,traCode,traBadge,traCarId,traAreId,traIdTerminal from movtransit where traStatus='V' and traDirection = 'I' and traCarId = 102 order by traDateTime desc,traId desc 22/08/2025 07:51:52.6768 1594 ms. OPEN: select traId,traDateTime,traEnabled,traDisableTime,traCode,traBadge,traCarId,traAreId,traIdTerminal from movtransit where traStatus='V' and traDirection = 'I' and traCarId = 21 order by traDateTime desc,traId desc 22/08/2025 08:11:28.7460 1562 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 22/08/2025 08:28:45.8473 4031 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 22/08/2025 08:37:24.7658 3720 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 22/08/2025 09:29:10.9036 641 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 22/08/2025 09:50:19.5689 2891 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 22/08/2025 09:59:16.2793 1438 ms. OPEN: select traId,traDateTime,traEnabled,traDisableTime,traCode,traBadge,traCarId,traAreId,traIdTerminal from movtransit where traStatus='V' and traDirection = 'I' and traCarId = 14 order by traDateTime desc,traId desc 22/08/2025 10:20:06.0636 609 ms. OPEN: select traId,traDateTime,traEnabled,traDisableTime,traCode,traBadge,traCarId,traAreId,traIdTerminal from movtransit where traStatus='V' and traDirection = 'I' and traCarId = 111 order by traDateTime desc,traId desc 22/08/2025 10:23:13.6727 515 ms. OPEN: select traId,traDateTime,traEnabled,traDisableTime,traCode,traBadge,traCarId,traAreId,traIdTerminal from movtransit where traStatus='V' and traDirection = 'I' and traCarId = 9 order by traDateTime desc,traId desc 22/08/2025 10:25:15.5640 1171 ms. OPEN: select traId,traDateTime,traEnabled,traDisableTime,traCode,traBadge,traCarId,traAreId,traIdTerminal from movtransit where traStatus='V' and traDirection = 'I' and traCarId = 41 order by traDateTime desc,traId desc 22/08/2025 10:28:51.2380 1484 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 22/08/2025 10:58:31.3552 641 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-08-22 10:58:27',12,'V',4678158660990900,4620484087421950,2025,'2025-08-22 10:58:27',17,1,0,4,'2025-08-22 11:13:27','C','KES',50,50,0,'','','',1,50,0,0,'',0,0) 22/08/2025 11:00:18.6637 828 ms. OPEN: select traId,traDateTime,traEnabled,traDisableTime,traCode,traBadge,traCarId,traAreId,traIdTerminal from movtransit where traStatus='V' and traDirection = 'I' and traCarId = 20 order by traDateTime desc,traId desc 22/08/2025 11:18:17.0304 2688 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 22/08/2025 11:18:17.5785 532 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 22/08/2025 13:10:32.5490 1250 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 22/08/2025 14:09:11.6726 6063 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 22/08/2025 14:19:33.8110 1359 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 22/08/2025 14:42:06.2034 610 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 22/08/2025 18:06:54.2698 531 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2025-08-22 18:06:53',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'; 22/08/2025 19:38:14.1129 1656 ms. EXECSCALAR: SELECT count(*) FROM payinventory WHERE invValue<>0 AND invType='' nr: 0 22/08/2025 19:38:15.2067 1093 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 22/08/2025 20:52:57.2336 671 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-08-22 20:52:51',6,'V',4614306671400320,5533130526321700,2025,'2025-08-22 20:52:51',4,1,0,4,'2025-08-22 21:07:51','P','KES',100,100,0,'','','',1,100,0,0,'',0,0)