12/09/2025 05:13:27.3211 2271 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 12/09/2025 05:49:04.5409 578 ms. EXEC: update opeActivities set acvFstPayId = (case acvFstPayId when 0 then 480301 else acvFstPayId end),acvLstPayId = 480301 where acvSftId = 1224 and acvCodeId = 3 12/09/2025 06:15:39.9082 633 ms. OPEN: select traId,traDateTime,traEnabled,traDisableTime,traCode,traBadge,traCarId,traAreId,traIdTerminal from movtransit where traStatus='V' and traDirection = 'I' and traCarId = 165 order by traDateTime desc,traId desc 12/09/2025 07:13:10.9774 568 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 12/09/2025 07:15:04.6478 1520 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 12/09/2025 07:17:37.5007 1091 ms. EXEC: insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2025-09-12 07:17:25',5,3,42101,0,50,-21,-1050,1,'O','N'); insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2025-09-12 07:17:25',5,3,42101,0,50,21,1050,2,'I','N'); insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2025-09-12 07:17:25',5,3,42101,0,100,-26,-2600,1,'O','N'); insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2025-09-12 07:17:25',5,3,42101,0,100,26,2600,2,'I','N'); insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2025-09-12 07:17:25',5,3,42101,0,200,-3,-600,1,'O','N'); insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2025-09-12 07:17:25',5,3,42101,0,200,3,600,2,'I','N'); insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2025-09-12 07:17:25',5,3,42101,0,1000,-2,-2000,1,'O','N'); insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2025-09-12 07:17:25',5,3,42101,0,1000,2,2000,2,'I','N'); insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2025-09-12 07:17:25',5,3,42101,1,0,0,0,1,'O',''); update payCurInventory set curQuantity=0,curAmount=0 where curQuantity<0; 12/09/2025 07:35:18.1627 8877 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 = 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)) order by traUIDGroup,payAmount, traType, traDiscountValue, traDiscountType 12/09/2025 07:40:59.3212 689 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 12/09/2025 09:55:46.6807 624 ms. OPEN: select traId,traDateTime,traEnabled,traDisableTime,traCode,traBadge,traCarId,traAreId,traIdTerminal from movtransit where traStatus='V' and traDirection = 'I' and traCarId = 13 order by traDateTime desc,traId desc 12/09/2025 10:34:31.9080 596 ms. EXEC: insert into payReceipt (recTraUID,recPayUID,recYear,recDateTime,recText,recInvalid) VALUES (4866366147095670,5401007056650980,2025,'2025-09-12 10:34:31',' Date: 9/12/2025 10:34:46 AM Code: 459103123100327005012999 Entry Date: 9/12/2025 8:40:31 AM Plate: Class: Cars Park: The Mall Gate: Entry 2 ______________________________ Total: 100.00 KES ______________________________ Paid: 100.00 KES __________ Change: 0.00 KES Type: Credit Card Dispozitiv: Manual Cashier 1 # 2500413171 ',0) 12/09/2025 10:50:32.0576 2633 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 12/09/2025 11:09:38.6691 700 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2025-09-12 11:09:37',3,42101,0,200,1,200,1,'I','N'); update payCurInventory set curQuantity=round(curQuantity+1,5),curAmount=round(curAmount+200,5) where curTerId = 3 and curDevCode = 42101 and curChannelId = 1 and curValue = 200 and curType = 'N'; 12/09/2025 11:48:41.7762 595 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 12/09/2025 12:50:41.4283 610 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-09-12 12:50:40',0,'V',5328476216506520,5570298193921820,2025,'2025-09-12 12:50:40',18,1,0,4,'2025-09-12 13:05:40','C','KES',50,50,0,'','','',1,50,0,0,'',0,0) 12/09/2025 14:05:12.8672 568 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-09-12 14:05:12','V',5227710314577180,2025,'2025-09-12 14:05:12','459105071200327005012999',1,2,16,'I','',1,0,1,'','',4) 12/09/2025 14:10:06.9119 558 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 12/09/2025 14:35:30.7404 1461 ms. EXECSCALAR: SELECT count(*) FROM payinventory WHERE invValue<>0 AND invType='' nr: 0 12/09/2025 14:35:31.6723 929 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 12/09/2025 14:52:06.0117 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-09-12 14:52:05','V',5335063844666960,2025,'2025-09-12 14:52:05','459105352500327005012999',1,2,16,'I','',1,0,1,'','',4) (WAIT TIME 61 ms.) 12/09/2025 15:31:46.5294 705 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 12/09/2025 15:40:18.6176 564 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 12/09/2025 16:00:32.1255 648 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2025-09-12 16:00:31' where payTraUID = 4906599166538080 and payStatus='V' and payEnabled=1 (WAIT TIME 1 ms.) 12/09/2025 16:52:55.5731 716 ms. EXEC: update payReceipt set recCreation = '2025-09-12 16:52:54',recModify = '2025-09-12 16:52:54',recUseId=0,recStatus='V' where recId = 415368 12/09/2025 17:02:11.9738 517 ms. EXEC: insert into payReceipt (recTraUID,recPayUID,recYear,recDateTime,recText,recInvalid) VALUES (4836827001206010,5279548743820920,2025,'2025-09-12 17:02:11','---------------------------------- %The Mall P0006032390 End of payment ---------------------------------- POF Entry : 9/12/2025 4:22:55 PM Date : 9/12/2025 5:02:10 PM Code : 459105897500327005012999 Total : 50.00 KES VAT 16% : 6.90 KES ---------------------------------- Paid : 100.00 KES Coin changed : 0.00 KES Note changed : 50.00 KES',0) 12/09/2025 18:16:53.8719 513 ms. OPEN: show columns from tabParameters where Field = 'parUseCulture' 12/09/2025 18:16:54.9386 726 ms. EXECSCALAR: select sum(parAllowNegativePlaces) from tabParameters where parStatus='V' order by parId desc limit 1 nr: 0 (WAIT TIME 5 ms.) 12/09/2025 18:16:55.2058 900 ms. EXECSCALAR: select count(*) from tabTerminalExtraMem where extStatus='V' and extTerId = 17 nr: 1 12/09/2025 18:16:55.2378 899 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 12/09/2025 18:16:56.1804 865 ms. EXECSCALAR: select count(resId) as Tot from movReservation where resStatus = 'V' and resTypeRes = 'B' AND ((resConfirmed IN (0,2,3) AND resCreation>'2025-09-12 17:16:55') OR resConfirmed IN (4,5)) and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) <= '2025-09-12 18:16:54' and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) >= '2025-09-12 18:16:54' and (resAreId = 1 or resAreId <= 0) nr: 0 12/09/2025 18:16:56.5497 675 ms. EXECSCALAR: select count(resId) as Tot from movReservation where resStatus = 'V' and resTypeRes = 'B' AND ((resConfirmed IN (0,2,3) AND resCreation>'2025-09-12 17:16:55') OR resConfirmed IN (4,5)) and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) <= '2025-09-12 18:16:55' and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) >= '2025-09-12 18:16:55' and (resAreId = 1 or resAreId <= 0) nr: 0 12/09/2025 18:16:56.7648 685 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 12/09/2025 18:16:56.8029 517 ms. OPEN: select * from tabArea where areStatus='V' and areEnabled = 1 AND areId = 1 12/09/2025 18:16:56.8549 1073 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 12/09/2025 18:16:57.6785 756 ms. EXECSCALAR: select count(resId) as Tot from movReservation where resStatus = 'V' and resTypeRes = 'B' AND ((resConfirmed IN (0,2,3) AND resCreation>'2025-09-12 17:16:56') OR resConfirmed IN (4,5)) and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) <= '2025-09-12 18:16:56' and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) >= '2025-09-12 18:16:56' and (resAreId = 1 or resAreId <= 0) nr: 0 12/09/2025 18:16:57.7735 644 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 12/09/2025 18:17:00.9657 842 ms. EXECSCALAR: select count(resId) as Tot from movReservation where resStatus = 'V' and resTypeRes = 'B' AND ((resConfirmed IN (0,2,3) AND resCreation>'2025-09-12 17:17:00') OR resConfirmed IN (4,5)) and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) <= '2025-09-12 18:17:00' and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) >= '2025-09-12 18:17:00' and (resAreId = 1 or resAreId <= 0) nr: 0 12/09/2025 18:17:07.4617 732 ms. EXECSCALAR: select count(resId) as Tot from movReservation where resStatus = 'V' and resTypeRes = 'B' AND ((resConfirmed IN (0,2,3) AND resCreation>'2025-09-12 17:17:06') OR resConfirmed IN (4,5)) and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) <= '2025-09-12 18:17:06' and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) >= '2025-09-12 18:17:06' and (resAreId = 1 or resAreId <= 0) nr: 0 12/09/2025 18:17:08.2852 758 ms. EXECSCALAR: select count(resId) as Tot from movReservation where resStatus = 'V' and resTypeRes = 'B' AND ((resConfirmed IN (0,2,3) AND resCreation>'2025-09-12 17:17:07') OR resConfirmed IN (4,5)) and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) <= '2025-09-12 18:17:07' and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) >= '2025-09-12 18:17:07' and (resAreId = 1 or resAreId <= 0) nr: 0 12/09/2025 18:17:11.6318 1398 ms. EXECSCALAR: select count(resId) as Tot from movReservation where resStatus = 'V' and resTypeRes = 'B' AND ((resConfirmed IN (0,2,3) AND resCreation>'2025-09-12 17:17:10') OR resConfirmed IN (4,5)) and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) <= '2025-09-12 18:17:10' and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) >= '2025-09-12 18:17:10' and (resAreId = 1 or resAreId <= 0) nr: 0 12/09/2025 18:17:20.0435 1190 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 12/09/2025 18:17:20.0685 1781 ms. OPEN: select * from tabArea where areStatus='V' and areEnabled = 1 AND areId = 1 (WAIT TIME 33 ms.) 12/09/2025 18:17:26.1232 1213 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 12/09/2025 18:17:27.5061 6694 ms. EXEC: update tabTerminalExtraMem SET extBarrier = 0 where extStatus='V' and extTerId = 16 AND extPlateWaitOperator=0 12/09/2025 18:17:27.5081 1263 ms. EXECSCALAR: select count(*) from tabTerminalExtraMem where extStatus='V' and extTerId = 4 nr: 1 12/09/2025 18:17:41.2860 2902 ms. EXECSCALAR: select count(resId) as Tot from movReservation where resStatus = 'V' and resTypeRes = 'B' AND ((resConfirmed IN (0,2,3) AND resCreation>'2025-09-12 17:17:38') OR resConfirmed IN (4,5)) and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) <= '2025-09-12 18:17:38' and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) >= '2025-09-12 18:17:38' and (resAreId = 1 or resAreId <= 0) nr: 0 12/09/2025 18:17:43.2229 1493 ms. EXECSCALAR: select count(resId) as Tot from movReservation where resStatus = 'V' and resTypeRes = 'B' AND ((resConfirmed IN (0,2,3) AND resCreation>'2025-09-12 17:17:41') OR resConfirmed IN (4,5)) and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) <= '2025-09-12 18:17:41' and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) >= '2025-09-12 18:17:41' and (resAreId = 1 or resAreId <= 0) nr: 0 12/09/2025 18:17:50.0737 1530 ms. EXECSCALAR: select count(resId) as Tot from movReservation where resStatus = 'V' and resTypeRes = 'B' AND ((resConfirmed IN (0,2,3) AND resCreation>'2025-09-12 17:17:48') OR resConfirmed IN (4,5)) and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) <= '2025-09-12 18:17:48' and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) >= '2025-09-12 18:17:48' and (resAreId = 1 or resAreId <= 0) nr: 0 12/09/2025 18:17:52.7704 2063 ms. EXECSCALAR: select count(resId) as Tot from movReservation where resStatus = 'V' and resTypeRes = 'B' AND ((resConfirmed IN (0,2,3) AND resCreation>'2025-09-12 17:17:50') OR resConfirmed IN (4,5)) and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) <= '2025-09-12 18:17:50' and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) >= '2025-09-12 18:17:50' and (resAreId = 1 or resAreId <= 0) nr: 0 12/09/2025 18:17:59.7806 810 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 12/09/2025 18:18:02.5188 1165 ms. OPEN: select * from tabArea where areStatus='V' and areEnabled = 1 AND areId = 1 12/09/2025 18:18:03.1873 5101 ms. EXECSCALAR: select count(resId) as Tot from movReservation where resStatus = 'V' and resTypeRes = 'B' AND ((resConfirmed IN (0,2,3) AND resCreation>'2025-09-12 17:17:58') OR resConfirmed IN (4,5)) and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) <= '2025-09-12 18:17:58' and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) >= '2025-09-12 18:17:58' and (resAreId = 1 or resAreId <= 0) nr: 0 12/09/2025 18:18:04.6746 646 ms. OPEN: SELECT * FROM movTransit WHERE traStatus=@traStatus AND traCode=@traCode AND traDirection=@traDirection ORDER BY traDateTime,traId 12/09/2025 18:18:07.4676 2048 ms. OPEN: select * from movtransit where trastatus='V' and (traCode = '459106358000327005012999') and traDirection='I' order by traId desc limit 1 12/09/2025 18:18:15.5711 1099 ms. OPEN: SELECT traCode FROM movTransit WHERE traId = '1021954' and traDirection='I' order by traId DESC LIMIT 1 12/09/2025 18:18:16.5568 855 ms. OPEN: SELECT * FROM movTransit WHERE traStatus=@traStatus AND traCode=@traCode AND traDirection=@traDirection ORDER BY traDateTime,traId 12/09/2025 18:18:21.3630 86102 ms. EXECSCALAR: SELECT count(*) FROM payinventory WHERE invValue<>0 AND invType='' nr: 0 12/09/2025 18:18:23.2664 1872 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 12/09/2025 18:18:29.2210 5953 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); 12/09/2025 18:18:39.4385 10215 ms. EXEC: UPDATE payCash SET casType='N' WHERE casType<>'N' AND ABS(casSingleAmount) IN (100,200,500); 12/09/2025 18:18:50.0860 703 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 12/09/2025 18:18:50.0870 746 ms. EXECSCALAR: select count(resId) as Tot from movReservation where resStatus = 'V' and resTypeRes = 'B' AND ((resConfirmed IN (0,2,3) AND resCreation>'2025-09-12 17:18:49') OR resConfirmed IN (4,5)) and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) <= '2025-09-12 18:18:49' and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) >= '2025-09-12 18:18:49' and (resAreId = 1 or resAreId <= 0) nr: 0 12/09/2025 18:19:00.8089 819 ms. EXECSCALAR: select count(resId) as Tot from movReservation where resStatus = 'V' and resTypeRes = 'B' AND ((resConfirmed IN (0,2,3) AND resCreation>'2025-09-12 17:18:59') OR resConfirmed IN (4,5)) and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) <= '2025-09-12 18:18:59' and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) >= '2025-09-12 18:18:59' and (resAreId = 1 or resAreId <= 0) nr: 0 12/09/2025 18:19:02.0827 545 ms. EXECSCALAR: select count(resId) as Tot from movReservation where resStatus = 'V' and resTypeRes = 'B' AND ((resConfirmed IN (0,2,3) AND resCreation>'2025-09-12 17:19:01') OR resConfirmed IN (4,5)) and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) <= '2025-09-12 18:19:01' and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) >= '2025-09-12 18:19:01' and (resAreId = 1 or resAreId <= 0) nr: 0 12/09/2025 18:19:09.7770 1417 ms. EXECSCALAR: select count(resId) as Tot from movReservation where resStatus = 'V' and resTypeRes = 'B' AND ((resConfirmed IN (0,2,3) AND resCreation>'2025-09-12 17:19:08') OR resConfirmed IN (4,5)) and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) <= '2025-09-12 18:19:08' and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) >= '2025-09-12 18:19:08' and (resAreId = 1 or resAreId <= 0) nr: 0 12/09/2025 18:19:13.1804 1778 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 (WAIT TIME 8 ms.) 12/09/2025 18:19:13.9980 716 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 12/09/2025 18:19:15.3349 899 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 2 and terStatus='V' 12/09/2025 18:19:15.3779 977 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 (WAIT TIME 43 ms.) 12/09/2025 18:19:15.8742 2639 ms. EXECSCALAR: select count(resId) as Tot from movReservation where resStatus = 'V' and resTypeRes = 'B' AND ((resConfirmed IN (0,2,3) AND resCreation>'2025-09-12 17:19:13') OR resConfirmed IN (4,5)) and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) <= '2025-09-12 18:19:13' and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) >= '2025-09-12 18:19:13' and (resAreId = 1 or resAreId <= 0) nr: 0 12/09/2025 18:19:17.5462 1052 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 (WAIT TIME 404 ms.) 12/09/2025 18:19:18.0725 2030 ms. EXECSCALAR: select count(resId) as Tot from movReservation where resStatus = 'V' and resTypeRes = 'B' AND ((resConfirmed IN (0,2,3) AND resCreation>'2025-09-12 17:19:16') OR resConfirmed IN (4,5)) and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) <= '2025-09-12 18:19:15' and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) >= '2025-09-12 18:19:15' and (resAreId = 1 or resAreId <= 0) nr: 0 12/09/2025 18:19:18.0745 516 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 2 12/09/2025 18:19:19.5925 934 ms. OPEN: SELECT * FROM movLinks INNER JOIN movTransit on traUID = mliTraUID WHERE mliRFIDCode = '0098788198949' AND mliStatus='V' ORDER BY mliId DESC LIMIT 1 12/09/2025 18:19:20.3841 709 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 12/09/2025 18:19:21.6412 6219 ms. OPEN: SELECT * FROM abbsubscriptions INNER JOIN abbcards ON carSubId=subId INNER JOIN tabcustomer ON subCusId=cusId WHERE carStatus='V' AND subStatus='V' AND (carCode<>'' OR carUHFCode<>'') AND subAbbType NOT IN (6,-1) ORDER BY carCode 12/09/2025 18:19:23.7316 1889 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 12/09/2025 18:19:23.7356 3821 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 12/09/2025 18:19:25.5920 1849 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 5 12/09/2025 18:19:27.1968 1523 ms. OPEN: select * from tabcustomer inner join abbsubscriptions on subCusId = cusId inner join abbcards on subId = carSubId where carId = 218 12/09/2025 18:19:27.1988 1471 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 (WAIT TIME 2 ms.) 12/09/2025 18:19:27.1998 1528 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 4 ms.) 12/09/2025 18:19:28.0744 774 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 12/09/2025 18:19:34.0525 6853 ms. OPEN: show columns from tabCustomer where Field = 'cusComId' 12/09/2025 18:19:35.1063 546 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 12/09/2025 18:19:35.1063 594 ms. OPEN: select * from tabArea where areStatus='V' and areEnabled = 1 AND areId = 1 12/09/2025 18:19:36.5243 1336 ms. EXECSCALAR: select count(resId) as Tot from movReservation where resStatus = 'V' and resTypeRes = 'B' AND ((resConfirmed IN (0,2,3) AND resCreation>'2025-09-12 17:19:35') OR resConfirmed IN (4,5)) and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) <= '2025-09-12 18:19:34' and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) >= '2025-09-12 18:19:34' and (resAreId = 1 or resAreId <= 0) nr: 0 12/09/2025 18:19:41.1064 6245 ms. OPEN: select traId,traDateTime,traEnabled,traDisableTime,traCode,traBadge,traCarId,traAreId,traIdTerminal from movtransit where traStatus='V' and traDirection = 'I' and traCarId = 218 order by traDateTime desc,traId desc 12/09/2025 18:19:42.7121 695 ms. EXECSCALAR: select count(resId) as Tot from movReservation where resStatus = 'V' and resTypeRes = 'B' AND ((resConfirmed IN (0,2,3) AND resCreation>'2025-09-12 17:19:42') OR resConfirmed IN (4,5)) and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) <= '2025-09-12 18:19:41' and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) >= '2025-09-12 18:19:41' and (resAreId = 1 or resAreId <= 0) nr: 0 (WAIT TIME 2 ms.) 12/09/2025 18:19:43.8769 512 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 12/09/2025 18:19:44.6536 674 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 12/09/2025 18:19:44.6546 1474 ms. OPEN: select * from tabClass where claPosition = 1 and claStatus='V' 12/09/2025 18:19:44.9989 1840 ms. OPEN: select * from abbCards where carId = 218 12/09/2025 18:19:46.2188 1014 ms. OPEN: select max(traCode) as vCode from movTransit where traCode >='45910 ' and traCode < '45911 ' and traType = 2 12/09/2025 18:19:51.6990 1830 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 12/09/2025 18:19:51.6990 1710 ms. EXECSCALAR: select count(0) as vTot from tabParameters where parPlateReading<>0 nr: 0 12/09/2025 18:19:51.6990 2130 ms. EXEC: delete from movRoutes where rtsStatus = 'V' and rtsEnabled = 1 and rtsCarID = 218 12/09/2025 18:19:52.6348 528 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 12/09/2025 18:19:53.3118 575 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 12/09/2025 18:19:53.3128 676 ms. EXECSCALAR: select count(resId) as Tot from movReservation where resStatus = 'V' and resTypeRes = 'B' AND ((resConfirmed IN (0,2,3) AND resCreation>'2025-09-12 17:19:52') OR resConfirmed IN (4,5)) and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) <= '2025-09-12 18:19:51' and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) >= '2025-09-12 18:19:51' and (resAreId = 1 or resAreId <= 0) nr: 0 12/09/2025 18:19:53.8943 579 ms. EXECSCALAR: select count(0) as vTot from tabParameters where parPlateReading<>0 nr: 0 12/09/2025 18:19:54.1945 2492 ms. EXEC: update movAnomaly set anmPayed = 1 where anmStatus='V' and anmPayed=0 and anmTrauid in (4716425427928960,4860540206870550,5160372000970060,5051443089028690,4961300932237320,5663012520339770,5075652547763850,5491877114400100,4882322497193670,5740486438454420,4819928058677270,4874689036402590,5055656025511840,5556157006562760,5557204626849730,5595329639840130,5654626415643960,5374312260924070,5063194527857450,4930708452950800,5585395903931230,4863789544805670,5067848635270530,5535026177242480,4794515608341730,4781240310914500,5086846741426530,5275837395081780,5332050636743960,5110879146382530,5064346456084040,4775078027711020,5244707909195510,5260879872454020,5432749719390450,5452616625656280,5670407271234610,5215333259935290,4797239674623730,4799606426919570,4715324014103870,4881424584862050,4629886400362690,4619050497536790,4880860424721890,4656659298708750,4672687765745820,5619288027401050,5576703523857280,5332887501478720,4776172148995480,4805111202469540,5346457341153670,4724469774312830,4973666219675070,4625428907308300,5224687206676990,5129687121788290,5537131893888540,4746843091491490,4795639856298870,5222149571016280,4800997205363290,4877198415854650,4964641677702670,4912146107940200,5056352375373070,5523870483383640,5025169602690630,4735102399747270,4780350667359770,5692885463096190,4806526394854130,5500730156710750,4726750036822270,5217465363998030,5349869768284740,5080992946669970,5135465445131700,5613822048242840,5149541383060860,5329055170242670,5419258547316770,5122204135956150,5565055023152820,4938872953391620,5304342823159370,5275871145980060,5163306657938490,5737962197849610,5026087342940800,5629984818385330,5676260807270500,5640513399693830,5067022884037180,5199779378283470,5679187600269550,5228019371536270,5593055159763830,4875039785531620,4781840164553120,5726026000867990,5387437249551190,4991137861803340,5444213137122310,5427630869397670,4718989051297860,4775206929331020,5165871127602800,5149705450312720,4658955027725810,5272509449373480,5046738470684330,5238106937193560,4714741099994300,5266666534315760,5428008184613320,4798144984468220,4996689855021480,4830595691099800,5172680364686720,5258562793312700,4863257334224680,5627741542279530,4887626786002560,4994472035245570,5585798260864940,5509876182150930,5571787552571330,4794751023298860,5531074155708460,5208477244321620,4784600883316970,4688051300880460,5281865777773210,5174619659485940,4855490288864210,5427598627837870,5601701500285560,5023007193826490,5521733299006470,5203203477089510,5627675157035360,4745715577804320,5123418864902690,4833722099673060,5667738948085440,4924171086153800,4735871118397840,4820051744771860,4798202502887660,5086005898893420,5319388648382120,5612097134095610,5647202130791380,5086282042353120,4898867891903380,5489682181984130,4892502599882660,5499830652139400,4950918192979690,4931232199644350,4628624920100320,5108047124344870,5310974958187070,5089520257402700,5296323693342640,5127576262396820,4666802861893040,5572189750953990,4683688085643670,4857905923244850,5117257462975870,5381095563517810,5627775712420510,5387298177941650,5643488217450010,5045323054091920,5285724535844140,5104306685213990,5548854730272220,4965625905836960,5365619479115720,4893677575049580,4820340809540990,5266302335241850,5323990821478550,5347707720871710,5118902816052780,4796217502716340,4990615093096920,5202841302762820,5547758033477090,5069693343915610,5360708254341000,4898841780052980,5370774529534210,4694470676625680,5531977907723140,5212150147961830,4868292141792940,4639988797511130,5057354534828330,5480555841190910,4755355456424120,4778382595610470,4633101608811410,4808910006928770,5550474625402160,5505053416334630,5529464867977280,4892686366191830,4952518882484540,4845830735570790,5664727324851150,5318281675562240,5194961418516730,5261420862801520,5414310686488000,5644294352794150,4898587552684570,4909297857447070,5613988874237940,5122389846638770,4745358398341930,5326573283435850,4832212131624090,5220111727171720,5745704159971780,5377417679099390,4691946151224110,5161618310705490,4987236921585700,5408908272802570,5671978504604160,5083485236898880,5528192620865650,5506838049046150,4663782531057480,5754147905843440,4684198668376580,5439146860535790,4938363093451350,4643533872623830,4714100836077460) 12/09/2025 18:19:54.5117 2507 ms. EXECSCALAR: select count(resId) as Tot from movReservation where resStatus = 'V' and resTypeRes = 'B' AND ((resConfirmed IN (0,2,3) AND resCreation>'2025-09-12 17:19:52') OR resConfirmed IN (4,5)) and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) <= '2025-09-12 18:19:51' and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) >= '2025-09-12 18:19:51' and (resAreId = 1 or resAreId <= 0) nr: 0 12/09/2025 18:20:57.2886 813 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 12/09/2025 18:20:57.2896 792 ms. OPEN: SELECT traCode FROM movTransit WHERE traId = '1021966' and traDirection='I' order by traId DESC LIMIT 1 12/09/2025 18:20:59.3485 3133 ms. EXECSCALAR: select count(resId) as Tot from movReservation where resStatus = 'V' and resTypeRes = 'B' AND ((resConfirmed IN (0,2,3) AND resCreation>'2025-09-12 17:20:56') OR resConfirmed IN (4,5)) and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) <= '2025-09-12 18:20:56' and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) >= '2025-09-12 18:20:56' and (resAreId = 1 or resAreId <= 0) nr: 0 12/09/2025 18:20:59.8291 1526 ms. OPEN: select ticId from tabTicketType where ticStatus='V' and ticType = 1 12/09/2025 18:21:02.4738 1273 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 12/09/2025 18:21:03.0432 1776 ms. EXECSCALAR: select count(resId) as Tot from movReservation where resStatus = 'V' and resTypeRes = 'B' AND ((resConfirmed IN (0,2,3) AND resCreation>'2025-09-12 17:21:01') OR resConfirmed IN (4,5)) and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) <= '2025-09-12 18:21:00' and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) >= '2025-09-12 18:21:00' and (resAreId = 1 or resAreId <= 0) nr: 0 12/09/2025 18:21:05.5871 2124 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 12/09/2025 18:21:06.1615 2930 ms. EXECSCALAR: select count(resId) as Tot from movReservation where resStatus = 'V' and resTypeRes = 'B' AND ((resConfirmed IN (0,2,3) AND resCreation>'2025-09-12 17:21:03') OR resConfirmed IN (4,5)) and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) <= '2025-09-12 18:21:03' and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) >= '2025-09-12 18:21:03' and (resAreId = 1 or resAreId <= 0) nr: 0 12/09/2025 18:21:08.8961 513 ms. EXEC: insert into temp_tariff (tarId,tarDay,tarHourFrom,tarHourTo,tarNumber,tarAmount,tarPeriod,tarPeriodLength,tarPeriodCount,tarDisabled,rulAmountPeriod,rulAmountPeriodDay) VALUES (16,1,'2023-02-16 00:00:00','2023-02-16 05:59:59',1,100,1,1,1,0,0,0); insert into temp_tariff (tarId,tarDay,tarHourFrom,tarHourTo,tarNumber,tarAmount,tarPeriod,tarPeriodLength,tarPeriodCount,tarDisabled,rulAmountPeriod,rulAmountPeriodDay) VALUES (16,2,'2023-02-16 00:00:00','2023-02-16 05:59:59',1,100,1,1,1,0,0,0); insert into temp_tariff (tarId,tarDay,tarHourFrom,tarHourTo,tarNumber,tarAmount,tarPeriod,tarPeriodLength,tarPeriodCount,tarDisabled,rulAmountPeriod,rulAmountPeriodDay) VALUES (16,3,'2023-02-16 00:00:00','2023-02-16 05:59:59',1,100,1,1,1,0,0,0); insert into temp_tariff (tarId,tarDay,tarHourFrom,tarHourTo,tarNumber,tarAmount,tarPeriod,tarPeriodLength,tarPeriodCount,tarDisabled,rulAmountPeriod,rulAmountPeriodDay) VALUES (16,4,'2023-02-16 00:00:00','2023-02-16 05:59:59',1,100,1,1,1,0,0,0); insert into temp_tariff (tarId,tarDay,tarHourFrom,tarHourTo,tarNumber,tarAmount,tarPeriod,tarPeriodLength,tarPeriodCount,tarDisabled,rulAmountPeriod,rulAmountPeriodDay) VALUES (16,5,'2023-02-16 00:00:00','2023-02-16 05:59:59',1,100,1,1,1,0,0,0); insert into temp_tariff (tarId,tarDay,tarHourFrom,tarHourTo,tarNumber,tarAmount,tarPeriod,tarPeriodLength,tarPeriodCount,tarDisabled,rulAmountPeriod,rulAmountPeriodDay) VALUES (16,6,'2023-02-16 00:00:00','2023-02-16 05:59:59',1,100,1,1,1,0,0,0); insert into temp_tariff (tarId,tarDay,tarHourFrom,tarHourTo,tarNumber,tarAmount,tarPeriod,tarPeriodLength,tarPeriodCount,tarDisabled,rulAmountPeriod,rulAmountPeriodDay) VALUES (16,7,'2023-02-16 00:00:00','2023-02-16 05:59:59',1,100,1,1,1,0,0,0); insert into temp_tariff (tarId,tarDay,tarHourFrom,tarHourTo,tarNumber,tarAmount,tarPeriod,tarPeriodLength,tarPeriodCount,tarDisabled,rulAmountPeriod,rulAmountPeriodDay) VALUES (17,1,'2023-02-16 00:00:00','2023-02-16 05:59:59',2,0,1,0,0,0,0,0); insert into temp_tariff (tarId,tarDay,tarHourFrom,tarHourTo,tarNumber,tarAmount,tarPeriod,tarPeriodLength,tarPeriodCount,tarDisabled,rulAmountPeriod,rulAmountPeriodDay) VALUES (17,2,'2023-02-16 00:00:00','2023-02-16 05:59:59',2,0,1,0,0,0,0,0); insert into temp_tariff (tarId,tarDay,tarHourFrom,tarHourTo,tarNumber,tarAmount,tarPeriod,tarPeriodLength,tarPeriodCount,tarDisabled,rulAmountPeriod,rulAmountPeriodDay) VALUES (17,3,'2023-02-16 00:00:00','2023-02-16 05:59:59',2,0,1,0,0,0,0,0); insert into temp_tariff (tarId,tarDay,tarHourFrom,tarHourTo,tarNumber,tarAmount,tarPeriod,tarPeriodLength,tarPeriodCount,tarDisabled,rulAmountPeriod,rulAmountPeriodDay) VALUES (17,4,'2023-02-16 00:00:00','2023-02-16 05:59:59',2,0,1,0,0,0,0,0); insert into temp_tariff (tarId,tarDay,tarHourFrom,tarHourTo,tarNumber,tarAmount,tarPeriod,tarPeriodLength,tarPeriodCount,tarDisabled,rulAmountPeriod,rulAmountPeriodDay) VALUES (17,5,'2023-02-16 00:00:00','2023-02-16 05:59:59',2,0,1,0,0,0,0,0); insert into temp_tariff (tarId,tarDay,tarHourFrom,tarHourTo,tarNumber,tarAmount,tarPeriod,tarPeriodLength,tarPeriodCount,tarDisabled,rulAmountPeriod,rulAmountPeriodDay) VALUES (17,6,'2023-02-16 00:00:00','2023-02-16 05:59:59',2,0,1,0,0,0,0,0); insert into temp_tariff (tarId,tarDay,tarHourFrom,tarHourTo,tarNumber,tarAmount,tarPeriod,tarPeriodLength,tarPeriodCount,tarDisabled,rulAmountPeriod,rulAmountPeriodDay) VALUES (17,7,'2023-02-16 00:00:00','2023-02-16 05:59:59',2,0,1,0,0,0,0,0); insert into temp_tariff (tarId,tarDay,tarHourFrom,tarHourTo,tarNumber,tarAmount,tarPeriod,tarPeriodLength,tarPeriodCount,tarDisabled,rulAmountPeriod,rulAmountPeriodDay) VALUES (18,1,'2023-02-16 06:00:00','2023-02-16 21:59:59',3,50,1,1,1,0,0,0); insert into temp_tariff (tarId,tarDay,tarHourFrom,tarHourTo,tarNumber,tarAmount,tarPeriod,tarPeriodLength,tarPeriodCount,tarDisabled,rulAmountPeriod,rulAmountPeriodDay) VALUES (18,2,'2023-02-16 06:00:00','2023-02-16 21:59:59',3,50,1,1,1,0,0,0); insert into temp_tariff (tarId,tarDay,tarHourFrom,tarHourTo,tarNumber,tarAmount,tarPeriod,tarPeriodLength,tarPeriodCount,tarDisabled,rulAmountPeriod,rulAmountPeriodDay) VALUES (18,3,'2023-02-16 06:00:00','2023-02-16 21:59:59',3,50,1,1,1,0,0,0); insert into temp_tariff (tarId,tarDay,tarHourFrom,tarHourTo,tarNumber,tarAmount,tarPeriod,tarPeriodLength,tarPeriodCount,tarDisabled,rulAmountPeriod,rulAmountPeriodDay) VALUES (18,4,'2023-02-16 06:00:00','2023-02-16 21:59:59',3,50,1,1,1,0,0,0); insert into temp_tariff (tarId,tarDay,tarHourFrom,tarHourTo,tarNumber,tarAmount,tarPeriod,tarPeriodLength,tarPeriodCount,tarDisabled,rulAmountPeriod,rulAmountPeriodDay) VALUES (18,5,'2023-02-16 06:00:00','2023-02-16 21:59:59',3,50,1,1,1,0,0,0); insert into temp_tariff (tarId,tarDay,tarHourFrom,tarHourTo,tarNumber,tarAmount,tarPeriod,tarPeriodLength,tarPeriodCount,tarDisabled,rulAmountPeriod,rulAmountPeriodDay) VALUES (18,6,'2023-02-16 06:00:00','2023-02-16 21:59:59',3,50,1,1,1,0,0,0); insert into temp_tariff (tarId,tarDay,tarHourFrom,tarHourTo,tarNumber,tarAmount,tarPeriod,tarPeriodLength,tarPeriodCount,tarDisabled,rulAmountPeriod,rulAmountPeriodDay) VALUES (18,7,'2023-02-16 06:00:00','2023-02-16 21:59:59',3,50,1,1,1,0,0,0); insert into temp_tariff (tarId,tarDay,tarHourFrom,tarHourTo,tarNumber,tarAmount,tarPeriod,tarPeriodLength,tarPeriodCount,tarDisabled,rulAmountPeriod,rulAmountPeriodDay) VALUES (19,1,'2023-02-16 06:00:00','2023-02-16 21:59:59',4,0,59,59,1,0,0,0); insert into temp_tariff (tarId,tarDay,tarHourFrom,tarHourTo,tarNumber,tarAmount,tarPeriod,tarPeriodLength,tarPeriodCount,tarDisabled,rulAmountPeriod,rulAmountPeriodDay) VALUES (19,2,'2023-02-16 06:00:00','2023-02-16 21:59:59',4,0,59,59,1,0,0,0); insert into temp_tariff (tarId,tarDay,tarHourFrom,tarHourTo,tarNumber,tarAmount,tarPeriod,tarPeriodLength,tarPeriodCount,tarDisabled,rulAmountPeriod,rulAmountPeriodDay) VALUES (19,3,'2023-02-16 06:00:00','2023-02-16 21:59:59',4,0,59,59,1,0,0,0); insert into temp_tariff (tarId,tarDay,tarHourFrom,tarHourTo,tarNumber,tarAmount,tarPeriod,tarPeriodLength,tarPeriodCount,tarDisabled,rulAmountPeriod,rulAmountPeriodDay) VALUES (19,4,'2023-02-16 06:00:00','2023-02-16 21:59:59',4,0,59,59,1,0,0,0); insert into temp_tariff (tarId,tarDay,tarHourFrom,tarHourTo,tarNumber,tarAmount,tarPeriod,tarPeriodLength,tarPeriodCount,tarDisabled,rulAmountPeriod,rulAmountPeriodDay) VALUES (19,5,'2023-02-16 06:00:00','2023-02-16 21:59:59',4,0,59,59,1,0,0,0); insert into temp_tariff (tarId,tarDay,tarHourFrom,tarHourTo,tarNumber,tarAmount,tarPeriod,tarPeriodLength,tarPeriodCount,tarDisabled,rulAmountPeriod,rulAmountPeriodDay) VALUES (19,6,'2023-02-16 06:00:00','2023-02-16 21:59:59',4,0,59,59,1,0,0,0); insert into temp_tariff (tarId,tarDay,tarHourFrom,tarHourTo,tarNumber,tarAmount,tarPeriod,tarPeriodLength,tarPeriodCount,tarDisabled,rulAmountPeriod,rulAmountPeriodDay) VALUES (19,7,'2023-02-16 06:00:00','2023-02-16 21:59:59',4,0,59,59,1,0,0,0); insert into temp_tariff (tarId,tarDay,tarHourFrom,tarHourTo,tarNumber,tarAmount,tarPeriod,tarPeriodLength,tarPeriodCount,tarDisabled,rulAmountPeriod,rulAmountPeriodDay) VALUES (20,1,'2023-02-16 06:00:00','2023-02-16 21:59:59',5,50,1,1,1,0,0,0); insert into temp_tariff (tarId,tarDay,tarHourFrom,tarHourTo,tarNumber,tarAmount,tarPeriod,tarPeriodLength,tarPeriodCount,tarDisabled,rulAmountPeriod,rulAmountPeriodDay) VALUES (20,2,'2023-02-16 06:00:00','2023-02-16 21:59:59',5,50,1,1,1,0,0,0); insert into temp_tariff (tarId,tarDay,tarHourFrom,tarHourTo,tarNumber,tarAmount,tarPeriod,tarPeriodLength,tarPeriodCount,tarDisabled,rulAmountPeriod,rulAmountPeriodDay) VALUES (20,3,'2023-02-16 06:00:00','2023-02-16 21:59:59',5,50,1,1,1,0,0,0); insert into temp_tariff (tarId,tarDay,tarHourFrom,tarHourTo,tarNumber,tarAmount,tarPeriod,tarPeriodLength,tarPeriodCount,tarDisabled,rulAmountPeriod,rulAmountPeriodDay) VALUES (20,4,'2023-02-16 06:00:00','2023-02-16 21:59:59',5,50,1,1,1,0,0,0); insert into temp_tariff (tarId,tarDay,tarHourFrom,tarHourTo,tarNumber,tarAmount,tarPeriod,tarPeriodLength,tarPeriodCount,tarDisabled,rulAmountPeriod,rulAmountPeriodDay) VALUES (20,5,'2023-02-16 06:00:00','2023-02-16 21:59:59',5,50,1,1,1,0,0,0); insert into temp_tariff (tarId,tarDay,tarHourFrom,tarHourTo,tarNumber,tarAmount,tarPeriod,tarPeriodLength,tarPeriodCount,tarDisabled,rulAmountPeriod,rulAmountPeriodDay) VALUES (20,6,'2023-02-16 06:00:00','2023-02-16 21:59:59',5,50,1,1,1,0,0,0); insert into temp_tariff (tarId,tarDay,tarHourFrom,tarHourTo,tarNumber,tarAmount,tarPeriod,tarPeriodLength,tarPeriodCount,tarDisabled,rulAmountPeriod,rulAmountPeriodDay) VALUES (20,7,'2023-02-16 06:00:00','2023-02-16 21:59:59',5,50,1,1,1,0,0,0); insert into temp_tariff (tarId,tarDay,tarHourFrom,tarHourTo,tarNumber,tarAmount,tarPeriod,tarPeriodLength,tarPeriodCount,tarDisabled,rulAmountPeriod,rulAmountPeriodDay) VALUES (21,1,'2023-02-16 06:00:00','2023-02-16 21:59:59',6,0,119,119,1,0,0,0); insert into temp_tariff (tarId,tarDay,tarHourFrom,tarHourTo,tarNumber,tarAmount,tarPeriod,tarPeriodLength,tarPeriodCount,tarDisabled,rulAmountPeriod,rulAmountPeriodDay) VALUES (21,2,'2023-02-16 06:00:00','2023-02-16 21:59:59',6,0,119,119,1,0,0,0); insert into temp_tariff (tarId,tarDay,tarHourFrom,tarHourTo,tarNumber,tarAmount,tarPeriod,tarPeriodLength,tarPeriodCount,tarDisabled,rulAmountPeriod,rulAmountPeriodDay) VALUES (21,3,'2023-02-16 06:00:00','2023-02-16 21:59:59',6,0,119,119,1,0,0,0); insert into temp_tariff (tarId,tarDay,tarHourFrom,tarHourTo,tarNumber,tarAmount,tarPeriod,tarPeriodLength,tarPeriodCount,tarDisabled,rulAmountPeriod,rulAmountPeriodDay) VALUES (21,4,'2023-02-16 06:00:00','2023-02-16 21:59:59',6,0,119,119,1,0,0,0); insert into temp_tariff (tarId,tarDay,tarHourFrom,tarHourTo,tarNumber,tarAmount,tarPeriod,tarPeriodLength,tarPeriodCount,tarDisabled,rulAmountPeriod,rulAmountPeriodDay) VALUES (21,5,'2023-02-16 06:00:00','2023-02-16 21:59:59',6,0,119,119,1,0,0,0); insert into temp_tariff (tarId,tarDay,tarHourFrom,tarHourTo,tarNumber,tarAmount,tarPeriod,tarPeriodLength,tarPeriodCount,tarDisabled,rulAmountPeriod,rulAmountPeriodDay) VALUES (21,6,'2023-02-16 06:00:00','2023-02-16 21:59:59',6,0,119,119,1,0,0,0); insert into temp_tariff (tarId,tarDay,tarHourFrom,tarHourTo,tarNumber,tarAmount,tarPeriod,tarPeriodLength,tarPeriodCount,tarDisabled,rulAmountPeriod,rulAmountPeriodDay) VALUES (21,7,'2023-02-16 06:00:00','2023-02-16 21:59:59',6,0,119,119,1,0,0,0); insert into temp_tariff (tarId,tarDay,tarHourFrom,tarHourTo,tarNumber,tarAmount,tarPeriod,tarPeriodLength,tarPeriodCount,tarDisabled,rulAmountPeriod,rulAmountPeriodDay) VALUES (22,1,'2023-02-16 06:00:00','2023-02-16 21:59:59',7,100,1,1,1,0,0,0); insert into temp_tariff (tarId,tarDay,tarHourFrom,tarHourTo,tarNumber,tarAmount,tarPeriod,tarPeriodLength,tarPeriodCount,tarDisabled,rulAmountPeriod,rulAmountPeriodDay) VALUES (22,2,'2023-02-16 06:00:00','2023-02-16 21:59:59',7,100,1,1,1,0,0,0); insert into temp_tariff (tarId,tarDay,tarHourFrom,tarHourTo,tarNumber,tarAmount,tarPeriod,tarPeriodLength,tarPeriodCount,tarDisabled,rulAmountPeriod,rulAmountPeriodDay) VALUES (22,3,'2023-02-16 06:00:00','2023-02-16 21:59:59',7,100,1,1,1,0,0,0); insert into temp_tariff (tarId,tarDay,tarHourFrom,tarHourTo,tarNumber,tarAmount,tarPeriod,tarPeriodLength,tarPeriodCount,tarDisabled,rulAmountPeriod,rulAmountPeriodDay) VALUES (22,4,'2023-02-16 06:00:00','2023-02-16 21:59:59',7,100,1,1,1,0,0,0); insert into temp_tariff (tarId,tarDay,tarHourFrom,tarHourTo,tarNumber,tarAmount,tarPeriod,tarPeriodLength,tarPeriodCount,tarDisabled,rulAmountPeriod,rulAmountPeriodDay) VALUES (22,5,'2023-02-16 06:00:00','2023-02-16 21:59:59',7,100,1,1,1,0,0,0); insert into temp_tariff (tarId,tarDay,tarHourFrom,tarHourTo,tarNumber,tarAmount,tarPeriod,tarPeriodLength,tarPeriodCount,tarDisabled,rulAmountPeriod,rulAmountPeriodDay) VALUES (22,6,'2023-02-16 06:00:00','2023-02-16 21:59:59',7,100,1,1,1,0,0,0); insert into temp_tariff (tarId,tarDay,tarHourFrom,tarHourTo,tarNumber,tarAmount,tarPeriod,tarPeriodLength,tarPeriodCount,tarDisabled,rulAmountPeriod,rulAmountPeriodDay) VALUES (22,7,'2023-02-16 06:00:00','2023-02-16 21:59:59',7,100,1,1,1,0,0,0); insert into temp_tariff (tarId,tarDay,tarHourFrom,tarHourTo,tarNumber,tarAmount,tarPeriod,tarPeriodLength,tarPeriodCount,tarDisabled,rulAmountPeriod,rulAmountPeriodDay) VALUES (23,1,'2023-02-16 06:00:00','2023-02-16 21:59:59',8,0,59,59,1,0,0,0); insert into temp_tariff (tarId,tarDay,tarHourFrom,tarHourTo,tarNumber,tarAmount,tarPeriod,tarPeriodLength,tarPeriodCount,tarDisabled,rulAmountPeriod,rulAmountPeriodDay) VALUES (23,2,'2023-02-16 06:00:00','2023-02-16 21:59:59',8,0,59,59,1,0,0,0); insert into temp_tariff (tarId,tarDay,tarHourFrom,tarHourTo,tarNumber,tarAmount,tarPeriod,tarPeriodLength,tarPeriodCount,tarDisabled,rulAmountPeriod,rulAmountPeriodDay) VALUES (23,3,'2023-02-16 06:00:00','2023-02-16 21:59:59',8,0,59,59,1,0,0,0); insert into temp_tariff (tarId,tarDay,tarHourFrom,tarHourTo,tarNumber,tarAmount,tarPeriod,tarPeriodLength,tarPeriodCount,tarDisabled,rulAmountPeriod,rulAmountPeriodDay) VALUES (23,4,'2023-02-16 06:00:00','2023-02-16 21:59:59',8,0,59,59,1,0,0,0); insert into temp_tariff (tarId,tarDay,tarHourFrom,tarHourTo,tarNumber,tarAmount,tarPeriod,tarPeriodLength,tarPeriodCount,tarDisabled,rulAmountPeriod,rulAmountPeriodDay) VALUES (23,5,'2023-02-16 06:00:00','2023-02-16 21:59:59',8,0,59,59,1,0,0,0); insert into temp_tariff (tarId,tarDay,tarHourFrom,tarHourTo,tarNumber,tarAmount,tarPeriod,tarPeriodLength,tarPeriodCount,tarDisabled,rulAmountPeriod,rulAmountPeriodDay) VALUES (23,6,'2023-02-16 06:00:00','2023-02-16 21:59:59',8,0,59,59,1,0,0,0); insert into temp_tariff (tarId,tarDay,tarHourFrom,tarHourTo,tarNumber,tarAmount,tarPeriod,tarPeriodLength,tarPeriodCount,tarDisabled,rulAmountPeriod,rulAmountPeriodDay) VALUES (23,7,'2023-02-16 06:00:00','2023-02-16 21:59:59',8,0,59,59,1,0,0,0); insert into temp_tariff (tarId,tarDay,tarHourFrom,tarHourTo,tarNumber,tarAmount,tarPeriod,tarPeriodLength,tarPeriodCount,tarDisabled,rulAmountPeriod,rulAmountPeriodDay) VALUES (24,1,'2023-02-16 06:00:00','2023-02-16 21:59:59',9,100,60,0,0,0,0,0); insert into temp_tariff (tarId,tarDay,tarHourFrom,tarHourTo,tarNumber,tarAmount,tarPeriod,tarPeriodLength,tarPeriodCount,tarDisabled,rulAmountPeriod,rulAmountPeriodDay) VALUES (24,2,'2023-02-16 06:00:00','2023-02-16 21:59:59',9,100,60,0,0,0,0,0); insert into temp_tariff (tarId,tarDay,tarHourFrom,tarHourTo,tarNumber,tarAmount,tarPeriod,tarPeriodLength,tarPeriodCount,tarDisabled,rulAmountPeriod,rulAmountPeriodDay) VALUES (24,3,'2023-02-16 06:00:00','2023-02-16 21:59:59',9,100,60,0,0,0,0,0); insert into temp_tariff (tarId,tarDay,tarHourFrom,tarHourTo,tarNumber,tarAmount,tarPeriod,tarPeriodLength,tarPeriodCount,tarDisabled,rulAmountPeriod,rulAmountPeriodDay) VALUES (24,4,'2023-02-16 06:00:00','2023-02-16 21:59:59',9,100,60,0,0,0,0,0); insert into temp_tariff (tarId,tarDay,tarHourFrom,tarHourTo,tarNumber,tarAmount,tarPeriod,tarPeriodLength,tarPeriodCount,tarDisabled,rulAmountPeriod,rulAmountPeriodDay) VALUES (24,5,'2023-02-16 06:00:00','2023-02-16 21:59:59',9,100,60,0,0,0,0,0); insert into temp_tariff (tarId,tarDay,tarHourFrom,tarHourTo,tarNumber,tarAmount,tarPeriod,tarPeriodLength,tarPeriodCount,tarDisabled,rulAmountPeriod,rulAmountPeriodDay) VALUES (24,6,'2023-02-16 06:00:00','2023-02-16 21:59:59',9,100,60,0,0,0,0,0); insert into temp_tariff (tarId,tarDay,tarHourFrom,tarHourTo,tarNumber,tarAmount,tarPeriod,tarPeriodLength,tarPeriodCount,tarDisabled,rulAmountPeriod,rulAmountPeriodDay) VALUES (24,7,'2023-02-16 06:00:00','2023-02-16 21:59:59',9,100,60,0,0,0,0,0); insert into temp_tariff (tarId,tarDay,tarHourFrom,tarHourTo,tarNumber,tarAmount,tarPeriod,tarPeriodLength,tarPeriodCount,tarDisabled,rulAmountPeriod,rulAmountPeriodDay) VALUES (25,1,'2023-02-16 22:00:00','2023-02-16 23:57:59',10,100,57,57,1,0,0,0); insert into temp_tariff (tarId,tarDay,tarHourFrom,tarHourTo,tarNumber,tarAmount,tarPeriod,tarPeriodLength,tarPeriodCount,tarDisabled,rulAmountPeriod,rulAmountPeriodDay) VALUES (25,2,'2023-02-16 22:00:00','2023-02-16 23:57:59',10,100,57,57,1,0,0,0); insert into temp_tariff (tarId,tarDay,tarHourFrom,tarHourTo,tarNumber,tarAmount,tarPeriod,tarPeriodLength,tarPeriodCount,tarDisabled,rulAmountPeriod,rulAmountPeriodDay) VALUES (25,3,'2023-02-16 22:00:00','2023-02-16 23:57:59',10,100,57,57,1,0,0,0); insert into temp_tariff (tarId,tarDay,tarHourFrom,tarHourTo,tarNumber,tarAmount,tarPeriod,tarPeriodLength,tarPeriodCount,tarDisabled,rulAmountPeriod,rulAmountPeriodDay) VALUES (25,4,'2023-02-16 22:00:00','2023-02-16 23:57:59',10,100,57,57,1,0,0,0); insert into temp_tariff (tarId,tarDay,tarHourFrom,tarHourTo,tarNumber,tarAmount,tarPeriod,tarPeriodLength,tarPeriodCount,tarDisabled,rulAmountPeriod,rulAmountPeriodDay) VALUES (25,5,'2023-02-16 22:00:00','2023-02-16 23:57:59',10,100,57,57,1,0,0,0); insert into temp_tariff (tarId,tarDay,tarHourFrom,tarHourTo,tarNumber,tarAmount,tarPeriod,tarPeriodLength,tarPeriodCount,tarDisabled,rulAmountPeriod,rulAmountPeriodDay) VALUES (25,6,'2023-02-16 22:00:00','2023-02-16 23:57:59',10,100,57,57,1,0,0,0); insert into temp_tariff (tarId,tarDay,tarHourFrom,tarHourTo,tarNumber,tarAmount,tarPeriod,tarPeriodLength,tarPeriodCount,tarDisabled,rulAmountPeriod,rulAmountPeriodDay) VALUES (25,7,'2023-02-16 22:00:00','2023-02-16 23:57:59',10,100,57,57,1,0,0,0); insert into temp_tariff (tarId,tarDay,tarHourFrom,tarHourTo,tarNumber,tarAmount,tarPeriod,tarPeriodLength,tarPeriodCount,tarDisabled,rulAmountPeriod,rulAmountPeriodDay) VALUES (26,1,'2023-02-16 22:00:00','2023-02-16 23:57:59',11,0,1,0,0,0,0,0); insert into temp_tariff (tarId,tarDay,tarHourFrom,tarHourTo,tarNumber,tarAmount,tarPeriod,tarPeriodLength,tarPeriodCount,tarDisabled,rulAmountPeriod,rulAmountPeriodDay) VALUES (26,2,'2023-02-16 22:00:00','2023-02-16 23:57:59',11,0,1,0,0,0,0,0); insert into temp_tariff (tarId,tarDay,tarHourFrom,tarHourTo,tarNumber,tarAmount,tarPeriod,tarPeriodLength,tarPeriodCount,tarDisabled,rulAmountPeriod,rulAmountPeriodDay) VALUES (26,3,'2023-02-16 22:00:00','2023-02-16 23:57:59',11,0,1,0,0,0,0,0); insert into temp_tariff (tarId,tarDay,tarHourFrom,tarHourTo,tarNumber,tarAmount,tarPeriod,tarPeriodLength,tarPeriodCount,tarDisabled,rulAmountPeriod,rulAmountPeriodDay) VALUES (26,4,'2023-02-16 22:00:00','2023-02-16 23:57:59',11,0,1,0,0,0,0,0); insert into temp_tariff (tarId,tarDay,tarHourFrom,tarHourTo,tarNumber,tarAmount,tarPeriod,tarPeriodLength,tarPeriodCount,tarDisabled,rulAmountPeriod,rulAmountPeriodDay) VALUES (26,5,'2023-02-16 22:00:00','2023-02-16 23:57:59',11,0,1,0,0,0,0,0); insert into temp_tariff (tarId,tarDay,tarHourFrom,tarHourTo,tarNumber,tarAmount,tarPeriod,tarPeriodLength,tarPeriodCount,tarDisabled,rulAmountPeriod,rulAmountPeriodDay) VALUES (26,6,'2023-02-16 22:00:00','2023-02-16 23:57:59',11,0,1,0,0,0,0,0); insert into temp_tariff (tarId,tarDay,tarHourFrom,tarHourTo,tarNumber,tarAmount,tarPeriod,tarPeriodLength,tarPeriodCount,tarDisabled,rulAmountPeriod,rulAmountPeriodDay) VALUES (26,7,'2023-02-16 22:00:00','2023-02-16 23:57:59',11,0,1,0,0,0,0,0); insert into temp_tariff (tarId,tarDay,tarHourFrom,tarHourTo,tarNumber,tarAmount,tarPeriod,tarPeriodLength,tarPeriodCount,tarDisabled,rulAmountPeriod,rulAmountPeriodDay) VALUES (27,1,'2023-02-16 23:58:00','2023-02-16 23:59:59',12,-100,1,1,1,0,0,0); insert into temp_tariff (tarId,tarDay,tarHourFrom,tarHourTo,tarNumber,tarAmount,tarPeriod,tarPeriodLength,tarPeriodCount,tarDisabled,rulAmountPeriod,rulAmountPeriodDay) VALUES (27,2,'2023-02-16 23:58:00','2023-02-16 23:59:59',12,-100,1,1,1,0,0,0); insert into temp_tariff (tarId,tarDay,tarHourFrom,tarHourTo,tarNumber,tarAmount,tarPeriod,tarPeriodLength,tarPeriodCount,tarDisabled,rulAmountPeriod,rulAmountPeriodDay) VALUES (27,3,'2023-02-16 23:58:00','2023-02-16 23:59:59',12,-100,1,1,1,0,0,0); insert into temp_tariff (tarId,tarDay,tarHourFrom,tarHourTo,tarNumber,tarAmount,tarPeriod,tarPeriodLength,tarPeriodCount,tarDisabled,rulAmountPeriod,rulAmountPeriodDay) VALUES (27,4,'2023-02-16 23:58:00','2023-02-16 23:59:59',12,-100,1,1,1,0,0,0); insert into temp_tariff (tarId,tarDay,tarHourFrom,tarHourTo,tarNumber,tarAmount,tarPeriod,tarPeriodLength,tarPeriodCount,tarDisabled,rulAmountPeriod,rulAmountPeriodDay) VALUES (27,5,'2023-02-16 23:58:00','2023-02-16 23:59:59',12,-100,1,1,1,0,0,0); insert into temp_tariff (tarId,tarDay,tarHourFrom,tarHourTo,tarNumber,tarAmount,tarPeriod,tarPeriodLength,tarPeriodCount,tarDisabled,rulAmountPeriod,rulAmountPeriodDay) VALUES (27,6,'2023-02-16 23:58:00','2023-02-16 23:59:59',12,-100,1,1,1,0,0,0); insert into temp_tariff (tarId,tarDay,tarHourFrom,tarHourTo,tarNumber,tarAmount,tarPeriod,tarPeriodLength,tarPeriodCount,tarDisabled,rulAmountPeriod,rulAmountPeriodDay) VALUES (27,7,'2023-02-16 23:58:00','2023-02-16 23:59:59',12,-100,1,1,1,0,0,0); insert into temp_tariff (tarId,tarDay,tarHourFrom,tarHourTo,tarNumber,tarAmount,tarPeriod,tarPeriodLength,tarPeriodCount,tarDisabled,rulAmountPeriod,rulAmountPeriodDay) VALUES (28,1,'2023-02-16 23:58:00','2023-02-16 23:59:59',13,0,1,0,0,0,0,0); insert into temp_tariff (tarId,tarDay,tarHourFrom,tarHourTo,tarNumber,tarAmount,tarPeriod,tarPeriodLength,tarPeriodCount,tarDisabled,rulAmountPeriod,rulAmountPeriodDay) VALUES (28,2,'2023-02-16 23:58:00','2023-02-16 23:59:59',13,0,1,0,0,0,0,0); insert into temp_tariff (tarId,tarDay,tarHourFrom,tarHourTo,tarNumber,tarAmount,tarPeriod,tarPeriodLength,tarPeriodCount,tarDisabled,rulAmountPeriod,rulAmountPeriodDay) VALUES (28,3,'2023-02-16 23:58:00','2023-02-16 23:59:59',13,0,1,0,0,0,0,0); insert into temp_tariff (tarId,tarDay,tarHourFrom,tarHourTo,tarNumber,tarAmount,tarPeriod,tarPeriodLength,tarPeriodCount,tarDisabled,rulAmountPeriod,rulAmountPeriodDay) VALUES (28,4,'2023-02-16 23:58:00','2023-02-16 23:59:59',13,0,1,0,0,0,0,0); insert into temp_tariff (tarId,tarDay,tarHourFrom,tarHourTo,tarNumber,tarAmount,tarPeriod,tarPeriodLength,tarPeriodCount,tarDisabled,rulAmountPeriod,rulAmountPeriodDay) VALUES (28,5,'2023-02-16 23:58:00','2023-02-16 23:59:59',13,0,1,0,0,0,0,0); insert into temp_tariff (tarId,tarDay,tarHourFrom,tarHourTo,tarNumber,tarAmount,tarPeriod,tarPeriodLength,tarPeriodCount,tarDisabled,rulAmountPeriod,rulAmountPeriodDay) VALUES (28,6,'2023-02-16 23:58:00','2023-02-16 23:59:59',13,0,1,0,0,0,0,0); insert into temp_tariff (tarId,tarDay,tarHourFrom,tarHourTo,tarNumber,tarAmount,tarPeriod,tarPeriodLength,tarPeriodCount,tarDisabled,rulAmountPeriod,rulAmountPeriodDay) VALUES (28,7,'2023-02-16 23:58:00','2023-02-16 23:59:59',13,0,1,0,0,0,0,0); 12/09/2025 18:21:11.8976 2000 ms. EXEC: DELETE FROM tmppay WHERE tmpDatetime<@tmpDateTime 12/09/2025 18:21:11.8986 2103 ms. EXECSCALAR: select count(resId) as Tot from movReservation where resStatus = 'V' and resTypeRes = 'B' AND ((resConfirmed IN (0,2,3) AND resCreation>'2025-09-12 17:21:09') OR resConfirmed IN (4,5)) and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) <= '2025-09-12 18:21:09' and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) >= '2025-09-12 18:21:09' and (resAreId = 1 or resAreId <= 0) nr: 0 12/09/2025 18:21:31.5532 696 ms. EXECSCALAR: select count(resId) as Tot from movReservation where resStatus = 'V' and resTypeRes = 'B' AND ((resConfirmed IN (0,2,3) AND resCreation>'2025-09-12 17:21:30') OR resConfirmed IN (4,5)) and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) <= '2025-09-12 18:21:30' and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) >= '2025-09-12 18:21:30' and (resAreId = 1 or resAreId <= 0) nr: 0 12/09/2025 18:21:42.1917 1122 ms. EXECSCALAR: select count(resId) as Tot from movReservation where resStatus = 'V' and resTypeRes = 'B' AND ((resConfirmed IN (0,2,3) AND resCreation>'2025-09-12 17:21:41') OR resConfirmed IN (4,5)) and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) <= '2025-09-12 18:21:40' and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) >= '2025-09-12 18:21:40' and (resAreId = 1 or resAreId <= 0) nr: 0 12/09/2025 18:21:42.8531 657 ms. EXECSCALAR: select count(resId) as Tot from movReservation where resStatus = 'V' and resTypeRes = 'B' AND ((resConfirmed IN (0,2,3) AND resCreation>'2025-09-12 17:21:42') OR resConfirmed IN (4,5)) and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) <= '2025-09-12 18:21:41' and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) >= '2025-09-12 18:21:41' and (resAreId = 1 or resAreId <= 0) nr: 0 12/09/2025 18:21:44.3181 1056 ms. EXECSCALAR: select count(resId) as Tot from movReservation where resStatus = 'V' and resTypeRes = 'B' AND ((resConfirmed IN (0,2,3) AND resCreation>'2025-09-12 17:21:43') OR resConfirmed IN (4,5)) and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) <= '2025-09-12 18:21:43' and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) >= '2025-09-12 18:21:43' and (resAreId = 1 or resAreId <= 0) nr: 0 12/09/2025 18:21:54.1820 745 ms. EXEC: update tabTerminalExtraMem SET extCode = @extCode, extUseId = 0 WHERE extStatus='V' and extTerId = @extTerId 12/09/2025 18:21:54.3011 2245 ms. EXECSCALAR: select count(resId) as Tot from movReservation where resStatus = 'V' and resTypeRes = 'B' AND ((resConfirmed IN (0,2,3) AND resCreation>'2025-09-12 17:21:51') OR resConfirmed IN (4,5)) and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) <= '2025-09-12 18:21:51' and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) >= '2025-09-12 18:21:51' and (resAreId = 1 or resAreId <= 0) nr: 0 (WAIT TIME 118 ms.) 12/09/2025 18:21:55.6613 921 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-09-12 18:21:54','V',5245711575807940,2025,'2025-09-12 18:21:50','459106611000327005012999',1,2,16,'I','',1,0,1,'','',4) 12/09/2025 18:21:57.5947 552 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 12/09/2025 18:22:03.2596 1116 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 (WAIT TIME 8 ms.) 12/09/2025 18:22:03.5028 1857 ms. EXECSCALAR: select count(resId) as Tot from movReservation where resStatus = 'V' and resTypeRes = 'B' AND ((resConfirmed IN (0,2,3) AND resCreation>'2025-09-12 17:22:01') OR resConfirmed IN (4,5)) and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) <= '2025-09-12 18:22:01' and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) >= '2025-09-12 18:22:01' and (resAreId = 1 or resAreId <= 0) nr: 0 12/09/2025 18:22:04.9926 1112 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 12/09/2025 18:22:07.0983 670 ms. EXECSCALAR: select count(0) as vTot from tabParameters where parPlateReading<>0 nr: 0 12/09/2025 18:22:07.1574 3315 ms. EXECSCALAR: select count(resId) as Tot from movReservation where resStatus = 'V' and resTypeRes = 'B' AND ((resConfirmed IN (0,2,3) AND resCreation>'2025-09-12 17:22:03') OR resConfirmed IN (4,5)) and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) <= '2025-09-12 18:22:03' and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) >= '2025-09-12 18:22:03' and (resAreId = 1 or resAreId <= 0) nr: 0 (WAIT TIME 58 ms.) 12/09/2025 18:22:07.1574 1084 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 (WAIT TIME 58 ms.) 12/09/2025 18:22:10.5922 624 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 7 12/09/2025 18:22:10.7032 1118 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 12/09/2025 18:22:13.6282 2177 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 1 12/09/2025 18:22:13.6462 1836 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 12/09/2025 18:22:16.1735 2425 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 12/09/2025 18:22:16.1735 2445 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 1 OR lnsTerId=1) 12/09/2025 18:22:16.1755 4577 ms. EXECSCALAR: select count(rulId) from tabTicketRules where rulStatus='V' and rulTerId = 18 and rulDevId = 17 and rulTicId = 1 nr: 0 12/09/2025 18:22:16.1755 2546 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 5 12/09/2025 18:22:17.9751 750 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 12/09/2025 18:22:17.9751 832 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 227 ms.) 12/09/2025 18:22:17.9751 2891 ms. OPEN: SELECT * FROM abbsubscriptions INNER JOIN abbcards ON carSubId=subId INNER JOIN tabcustomer ON subCusId=cusId WHERE carStatus='V' AND subStatus='V' AND (carCode<>'' OR carUHFCode<>'') AND subAbbType NOT IN (6,-1) ORDER BY carCode (WAIT TIME 153 ms.) 12/09/2025 18:22:19.4631 1386 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 12/09/2025 18:22:19.4631 1385 ms. EXECSCALAR: select count(0) as vTot from tabParameters where parPlateReading<>0 nr: 0 12/09/2025 18:22:19.8286 3032 ms. EXEC: update tabTerminalExtraMem SET extBarrier = 0 where extStatus='V' and extTerId = 16 AND extPlateWaitOperator=0 12/09/2025 18:22:19.8316 10272 ms. EXECSCALAR: select count(resId) as Tot from movReservation where resStatus = 'V' and resTypeRes = 'B' AND ((resConfirmed IN (0,2,3) AND resCreation>'2025-09-12 17:22:09') OR resConfirmed IN (4,5)) and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) <= '2025-09-12 18:22:09' and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) >= '2025-09-12 18:22:09' and (resAreId = 1 or resAreId <= 0) nr: 0 12/09/2025 18:22:23.9359 2992 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 12/09/2025 18:22:23.9369 2944 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 3 OR lnsTerId=3) 12/09/2025 18:22:23.9369 2461 ms. EXECSCALAR: select count(0) as vTot from tabParameters where parPlateReading<>0 nr: 0 12/09/2025 18:22:23.9379 3092 ms. OPEN: select * from movtransit where trastatus='V' and (traCode = '459106440300327001012999') and traDirection='I' order by traId desc limit 1 12/09/2025 18:22:24.5852 4744 ms. EXECSCALAR: select count(resId) as Tot from movReservation where resStatus = 'V' and resTypeRes = 'B' AND ((resConfirmed IN (0,2,3) AND resCreation>'2025-09-12 17:22:19') OR resConfirmed IN (4,5)) and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) <= '2025-09-12 18:22:19' and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) >= '2025-09-12 18:22:19' and (resAreId = 1 or resAreId <= 0) nr: 0 12/09/2025 18:22:24.6082 671 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 3 and terStatus='V' 12/09/2025 18:22:28.8034 4269 ms. EXECSCALAR: select count(resId) as Tot from movReservation where resStatus = 'V' and resTypeRes = 'B' AND ((resConfirmed IN (0,2,3) AND resCreation>'2025-09-12 17:22:24') OR resConfirmed IN (4,5)) and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) <= '2025-09-12 18:22:24' and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) >= '2025-09-12 18:22:24' and (resAreId = 1 or resAreId <= 0) nr: 0 12/09/2025 18:22:32.6320 1053 ms. EXECSCALAR: select count(resId) as Tot from movReservation where resStatus = 'V' and resTypeRes = 'B' AND ((resConfirmed IN (0,2,3) AND resCreation>'2025-09-12 17:22:31') OR resConfirmed IN (4,5)) and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) <= '2025-09-12 18:22:31' and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) >= '2025-09-12 18:22:31' and (resAreId = 1 or resAreId <= 0) nr: 0 12/09/2025 18:22:38.2594 529 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 12/09/2025 18:22:43.6478 821 ms. EXECSCALAR: select count(resId) as Tot from movReservation where resStatus = 'V' and resTypeRes = 'B' AND ((resConfirmed IN (0,2,3) AND resCreation>'2025-09-12 17:22:42') OR resConfirmed IN (4,5)) and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) <= '2025-09-12 18:22:42' and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) >= '2025-09-12 18:22:42' and (resAreId = 1 or resAreId <= 0) nr: 0 12/09/2025 18:23:24.7460 515 ms. EXECSCALAR: select count(resId) as Tot from movReservation where resStatus = 'V' and resTypeRes = 'B' AND ((resConfirmed IN (0,2,3) AND resCreation>'2025-09-12 17:23:24') OR resConfirmed IN (4,5)) and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) <= '2025-09-12 18:23:24' and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) >= '2025-09-12 18:23:24' and (resAreId = 1 or resAreId <= 0) nr: 0 12/09/2025 18:24:07.8154 2290 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 12/09/2025 18:24:08.6509 506 ms. EXECSCALAR: select count(0) as vTot from tabParameters where parPlateReading<>0 nr: 0 12/09/2025 18:24:08.6509 595 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 12/09/2025 18:24:10.2063 646 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 12/09/2025 18:24:10.7357 529 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 2 12/09/2025 18:24:11.8395 1002 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 2 OR lnsTerId=2) 12/09/2025 18:24:11.8405 1003 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 12/09/2025 18:24:12.8271 7378 ms. EXECSCALAR: select count(resId) as Tot from movReservation where resStatus = 'V' and resTypeRes = 'B' AND ((resConfirmed IN (0,2,3) AND resCreation>'2025-09-12 17:24:05') OR resConfirmed IN (4,5)) and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) <= '2025-09-12 18:24:03' and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) >= '2025-09-12 18:24:03' and (resAreId = 1 or resAreId <= 0) nr: 0 12/09/2025 18:24:18.7041 768 ms. EXECSCALAR: select count(resId) as Tot from movReservation where resStatus = 'V' and resTypeRes = 'B' AND ((resConfirmed IN (0,2,3) AND resCreation>'2025-09-12 17:24:17') OR resConfirmed IN (4,5)) and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) <= '2025-09-12 18:24:17' and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) >= '2025-09-12 18:24:17' and (resAreId = 1 or resAreId <= 0) nr: 0 12/09/2025 18:24:26.5474 958 ms. EXECSCALAR: select count(resId) as Tot from movReservation where resStatus = 'V' and resTypeRes = 'B' AND ((resConfirmed IN (0,2,3) AND resCreation>'2025-09-12 17:24:25') OR resConfirmed IN (4,5)) and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) <= '2025-09-12 18:24:25' and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) >= '2025-09-12 18:24:25' and (resAreId = 1 or resAreId <= 0) nr: 0 12/09/2025 18:24:45.1512 965 ms. EXECSCALAR: select count(resId) as Tot from movReservation where resStatus = 'V' and resTypeRes = 'B' AND ((resConfirmed IN (0,2,3) AND resCreation>'2025-09-12 17:24:44') OR resConfirmed IN (4,5)) and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) <= '2025-09-12 18:24:42' and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) >= '2025-09-12 18:24:42' and (resAreId = 1 or resAreId <= 0) nr: 0 12/09/2025 18:24:46.9224 800 ms. EXECSCALAR: select count(resId) as Tot from movReservation where resStatus = 'V' and resTypeRes = 'B' AND ((resConfirmed IN (0,2,3) AND resCreation>'2025-09-12 17:24:46') OR resConfirmed IN (4,5)) and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) <= '2025-09-12 18:24:46' and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) >= '2025-09-12 18:24:46' and (resAreId = 1 or resAreId <= 0) nr: 0 12/09/2025 18:24:52.5389 1887 ms. EXECSCALAR: select count(resId) as Tot from movReservation where resStatus = 'V' and resTypeRes = 'B' AND ((resConfirmed IN (0,2,3) AND resCreation>'2025-09-12 17:24:50') OR resConfirmed IN (4,5)) and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) <= '2025-09-12 18:24:49' and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) >= '2025-09-12 18:24:49' and (resAreId = 1 or resAreId <= 0) nr: 0 12/09/2025 18:24:55.2381 660 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 12/09/2025 18:24:58.6423 1428 ms. OPEN: select * from tabParameters order by parId desc limit 1 12/09/2025 18:24:59.1357 4594 ms. EXECSCALAR: select count(resId) as Tot from movReservation where resStatus = 'V' and resTypeRes = 'B' AND ((resConfirmed IN (0,2,3) AND resCreation>'2025-09-12 17:24:54') OR resConfirmed IN (4,5)) and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) <= '2025-09-12 18:24:53' and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) >= '2025-09-12 18:24:53' and (resAreId = 1 or resAreId <= 0) nr: 0 12/09/2025 18:24:59.3748 731 ms. OPEN: SELECT * FROM movLinks INNER JOIN movTransit on traUID = mliTraUID WHERE mliRFIDCode = '0098788191894' AND mliStatus='V' ORDER BY mliId DESC LIMIT 1 12/09/2025 18:25:03.9757 1875 ms. EXECSCALAR: select count(resId) as Tot from movReservation where resStatus = 'V' and resTypeRes = 'B' AND ((resConfirmed IN (0,2,3) AND resCreation>'2025-09-12 17:25:02') OR resConfirmed IN (4,5)) and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) <= '2025-09-12 18:25:01' and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) >= '2025-09-12 18:25:01' and (resAreId = 1 or resAreId <= 0) nr: 0 12/09/2025 18:25:04.1729 2185 ms. OPEN: select * from movtransit where trastatus='V' and (traCode = '0230003944086') and traDirection='I' order by traId desc limit 1 12/09/2025 18:25:06.5523 1927 ms. EXECSCALAR: select count(resId) as Tot from movReservation where resStatus = 'V' and resTypeRes = 'B' AND ((resConfirmed IN (0,2,3) AND resCreation>'2025-09-12 17:25:04') OR resConfirmed IN (4,5)) and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) <= '2025-09-12 18:25:03' and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) >= '2025-09-12 18:25:03' and (resAreId = 1 or resAreId <= 0) nr: 0 (WAIT TIME 52 ms.) 12/09/2025 18:25:06.5533 1837 ms. OPEN: select * from movtransit where trastatus='V' and traCode = '0230003944086' order by traId desc limit 1 (WAIT TIME 542 ms.) 12/09/2025 18:25:08.6267 2072 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 = '0230003944086' and traStatus='V' and casStatus='V' and terType=3 and casTotAmount<0 12/09/2025 18:25:09.0284 2393 ms. EXECSCALAR: select count(resId) as Tot from movReservation where resStatus = 'V' and resTypeRes = 'B' AND ((resConfirmed IN (0,2,3) AND resCreation>'2025-09-12 17:25:06') OR resConfirmed IN (4,5)) and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) <= '2025-09-12 18:25:06' and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) >= '2025-09-12 18:25:06' and (resAreId = 1 or resAreId <= 0) nr: 0 12/09/2025 18:25:09.6612 633 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 6 12/09/2025 18:25:12.9936 577 ms. OPEN: SELECT traCode FROM movTransit WHERE traId = '1021927' and traDirection='I' order by traId DESC LIMIT 1 12/09/2025 18:25:13.1907 4110 ms. OPEN: select * from movTransit inner join paypayment on paypayment.payTraUID = movTransit.traUID where traCode = '0230003944086' and traStatus='V' and payStatus='V' order by payDateTime desc 12/09/2025 18:25:13.1917 4126 ms. EXECSCALAR: select count(resId) as Tot from movReservation where resStatus = 'V' and resTypeRes = 'B' AND ((resConfirmed IN (0,2,3) AND resCreation>'2025-09-12 17:25:09') OR resConfirmed IN (4,5)) and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) <= '2025-09-12 18:25:07' and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) >= '2025-09-12 18:25:07' and (resAreId = 1 or resAreId <= 0) nr: 0 (WAIT TIME 35 ms.) 12/09/2025 18:25:13.9064 561 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 18 OR lnsTerId=18) (WAIT TIME 115 ms.) 12/09/2025 18:25:17.4126 1642 ms. OPEN: select * from tabUserMessage where useMesDescr = 'msg_operator' and (useLanCode = 'en-US' or mid(useLanCode,1,2) = 'en') 12/09/2025 18:25:20.0449 2202 ms. EXEC: update tabTerminalExtraMem SET extBarrier = 1, extPlate = '', extPlateAccuracy=0, extPlateReadDate='1970-01-01', extPlateWaitOperator=0,extTrpId=0, extTag = '' where extStatus='V' and extTerId = 2 12/09/2025 18:25:20.1960 1224 ms. EXECSCALAR: select count(*) from tabTerminalExtraMem where extStatus='V' and extTerId = 1 nr: 1 12/09/2025 18:25:22.4830 1753 ms. EXEC: drop temporary table if exists temp_tariff 12/09/2025 18:25:22.5111 2191 ms. EXECSCALAR: select count(resId) as Tot from movReservation where resStatus = 'V' and resTypeRes = 'B' AND ((resConfirmed IN (0,2,3) AND resCreation>'2025-09-12 17:25:20') OR resConfirmed IN (4,5)) and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) <= '2025-09-12 18:25:20' and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) >= '2025-09-12 18:25:20' and (resAreId = 1 or resAreId <= 0) nr: 0 12/09/2025 18:25:22.7772 867 ms. OPEN: show columns from movoperator where Field = 'opeQuery' 12/09/2025 18:25:23.8791 733 ms. EXECSCALAR: select count(resId) as Tot from movReservation where resStatus = 'V' and resTypeRes = 'B' AND ((resConfirmed IN (0,2,3) AND resCreation>'2025-09-12 17:25:23') OR resConfirmed IN (4,5)) and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) <= '2025-09-12 18:25:23' and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) >= '2025-09-12 18:25:23' and (resAreId = 1 or resAreId <= 0) nr: 0 12/09/2025 18:25:23.9341 1156 ms. EXEC: INSERT INTO movOperator (opeCreation,opeUseId,opeTerId,opeDateTime,opeCode,opeDescription) VALUES ('2025-09-12 18:25:22',0,2,'2025-09-12 18:25:22','0230003944086','Exit 1 - User Transit Supervisor Supervisor') 12/09/2025 18:25:27.1501 551 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 12/09/2025 18:25:27.7766 1872 ms. EXECSCALAR: select count(resId) as Tot from movReservation where resStatus = 'V' and resTypeRes = 'B' AND ((resConfirmed IN (0,2,3) AND resCreation>'2025-09-12 17:25:25') OR resConfirmed IN (4,5)) and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) <= '2025-09-12 18:25:25' and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) >= '2025-09-12 18:25:25' and (resAreId = 1 or resAreId <= 0) nr: 0 12/09/2025 18:25:33.6759 611 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 12/09/2025 18:25:34.9211 1761 ms. EXECSCALAR: select count(resId) as Tot from movReservation where resStatus = 'V' and resTypeRes = 'B' AND ((resConfirmed IN (0,2,3) AND resCreation>'2025-09-12 17:25:33') OR resConfirmed IN (4,5)) and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) <= '2025-09-12 18:25:33' and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) >= '2025-09-12 18:25:33' and (resAreId = 1 or resAreId <= 0) nr: 0 12/09/2025 18:25:36.3715 818 ms. EXECSCALAR: select count(resId) as Tot from movReservation where resStatus = 'V' and resTypeRes = 'B' AND ((resConfirmed IN (0,2,3) AND resCreation>'2025-09-12 17:25:35') OR resConfirmed IN (4,5)) and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) <= '2025-09-12 18:25:35' and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) >= '2025-09-12 18:25:35' and (resAreId = 1 or resAreId <= 0) nr: 0 12/09/2025 18:25:43.9002 19671 ms. OPEN: select max(traCode) as vCode from movTransit where traCode >='45910 ' and traCode < '45911 ' and traType = 2 12/09/2025 18:25:46.4023 757 ms. EXECSCALAR: select count(resId) as Tot from movReservation where resStatus = 'V' and resTypeRes = 'B' AND ((resConfirmed IN (0,2,3) AND resCreation>'2025-09-12 17:25:45') OR resConfirmed IN (4,5)) and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) <= '2025-09-12 18:25:45' and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) >= '2025-09-12 18:25:45' and (resAreId = 1 or resAreId <= 0) nr: 0 12/09/2025 18:25:46.4023 2208 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 carCode = '0230003944086' 12/09/2025 18:25:50.7254 9018 ms. OPEN: select * from movTransit where traStatus='V' and traCode = '0098788191894' and traDirection='I' order by traId desc limit 1 12/09/2025 18:25:50.7264 22579 ms. OPEN: select * from movTransit where traStatus='V' and traCode = '0098788191894' and traDirection='I' order by traId desc limit 1 12/09/2025 18:26:02.1526 627 ms. OPEN: select traId,traDateTime,traEnabled,traDisableTime,traCode,traBadge,traCarId,traAreId,traIdTerminal from movtransit where traStatus='V' and traDirection = 'I' and traCarId = 216 order by traDateTime desc,traId desc 12/09/2025 18:27:06.1121 748 ms. EXECSCALAR: select count(resId) as Tot from movReservation where resStatus = 'V' and resTypeRes = 'B' AND ((resConfirmed IN (0,2,3) AND resCreation>'2025-09-12 17:27:05') OR resConfirmed IN (4,5)) and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) <= '2025-09-12 18:27:05' and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) >= '2025-09-12 18:27:05' and (resAreId = 1 or resAreId <= 0) nr: 0 12/09/2025 18:27:09.5694 1654 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2025-09-12 18:27:07',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-09-12 18:27:07',3,42101,0,100,-1,-100,1,'O','N'); update payCurInventory set curQuantity=round(curQuantity+-1,5),curAmount=round(curAmount+-100,5) where curTerId = 3 and curDevCode = 42101 and curChannelId = 1 and curValue = 100 and curType = 'N'; Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2025-09-12 18:27:07',3,42101,0,200,-4,-800,1,'O','N'); update payCurInventory set curQuantity=round(curQuantity+-4,5),curAmount=round(curAmount+-800,5) where curTerId = 3 and curDevCode = 42101 and curChannelId = 1 and curValue = 200 and curType = 'N'; 12/09/2025 18:27:27.4368 1108 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 12/09/2025 18:27:28.5529 551 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 12/09/2025 18:27:30.4522 4160 ms. EXECSCALAR: select count(resId) as Tot from movReservation where resStatus = 'V' and resTypeRes = 'B' AND ((resConfirmed IN (0,2,3) AND resCreation>'2025-09-12 17:27:26') OR resConfirmed IN (4,5)) and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) <= '2025-09-12 18:27:26' and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) >= '2025-09-12 18:27:26' and (resAreId = 1 or resAreId <= 0) nr: 0 12/09/2025 18:27:39.2707 543 ms. EXECSCALAR: select count(0) as vTot from tabParameters where parPlateReading<>0 nr: 0 12/09/2025 18:27:39.3317 502 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 (WAIT TIME 61 ms.) 12/09/2025 18:27:39.6519 3400 ms. EXECSCALAR: select count(resId) as Tot from movReservation where resStatus = 'V' and resTypeRes = 'B' AND ((resConfirmed IN (0,2,3) AND resCreation>'2025-09-12 17:27:36') OR resConfirmed IN (4,5)) and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) <= '2025-09-12 18:27:36' and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) >= '2025-09-12 18:27:36' and (resAreId = 1 or resAreId <= 0) nr: 0 12/09/2025 18:27:40.1773 505 ms. EXECSCALAR: select count(0) as vTot from tabParameters where parPlateReading<>0 nr: 0 12/09/2025 18:27:43.9352 1040 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 12/09/2025 18:27:43.9502 1138 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 2 12/09/2025 18:27:44.5306 580 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 12/09/2025 18:27:49.6913 928 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 4 OR lnsTerId=4) 12/09/2025 18:27:53.6954 720 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 (WAIT TIME 419 ms.) 12/09/2025 18:27:53.6954 4827 ms. EXECSCALAR: select count(resId) as Tot from movReservation where resStatus = 'V' and resTypeRes = 'B' AND ((resConfirmed IN (0,2,3) AND resCreation>'2025-09-12 17:27:48') OR resConfirmed IN (4,5)) and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) <= '2025-09-12 18:27:48' and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) >= '2025-09-12 18:27:48' and (resAreId = 1 or resAreId <= 0) nr: 0 (WAIT TIME 417 ms.) 12/09/2025 18:27:53.6964 716 ms. EXECSCALAR: select count(0) as vTot from tabParameters where parPlateReading<>0 nr: 0 (WAIT TIME 420 ms.) 12/09/2025 18:27:58.8350 1154 ms. EXECSCALAR: select count(resId) as Tot from movReservation where resStatus = 'V' and resTypeRes = 'B' AND ((resConfirmed IN (0,2,3) AND resCreation>'2025-09-12 17:27:57') OR resConfirmed IN (4,5)) and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) <= '2025-09-12 18:27:57' and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) >= '2025-09-12 18:27:57' and (resAreId = 1 or resAreId <= 0) nr: 0 12/09/2025 18:27:59.0272 3134 ms. EXECSCALAR: select count(resId) as Tot from movReservation where resStatus = 'V' and resTypeRes = 'B' AND ((resConfirmed IN (0,2,3) AND resCreation>'2025-09-12 17:27:55') OR resConfirmed IN (4,5)) and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) <= '2025-09-12 18:27:55' and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) >= '2025-09-12 18:27:55' and (resAreId = 1 or resAreId <= 0) nr: 0 12/09/2025 18:28:06.7327 852 ms. EXECSCALAR: select count(resId) as Tot from movReservation where resStatus = 'V' and resTypeRes = 'B' AND ((resConfirmed IN (0,2,3) AND resCreation>'2025-09-12 17:28:05') OR resConfirmed IN (4,5)) and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) <= '2025-09-12 18:28:05' and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) >= '2025-09-12 18:28:05' and (resAreId = 1 or resAreId <= 0) nr: 0 12/09/2025 18:28:09.6700 530 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 12/09/2025 18:28:11.3962 4018 ms. EXECSCALAR: select count(resId) as Tot from movReservation where resStatus = 'V' and resTypeRes = 'B' AND ((resConfirmed IN (0,2,3) AND resCreation>'2025-09-12 17:28:07') OR resConfirmed IN (4,5)) and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) <= '2025-09-12 18:28:07' and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) >= '2025-09-12 18:28:07' and (resAreId = 1 or resAreId <= 0) nr: 0 12/09/2025 18:28:13.2646 590 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 = '459106135700327005012999' AND traStatus='V' AND payStatus='V' and (terType IS NULL OR terType<>3 OR (terType=3 and payType='P')) 12/09/2025 18:28:16.7249 764 ms. EXECSCALAR: select count(resId) as Tot from movReservation where resStatus = 'V' and resTypeRes = 'B' AND ((resConfirmed IN (0,2,3) AND resCreation>'2025-09-12 17:28:15') OR resConfirmed IN (4,5)) and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) <= '2025-09-12 18:28:15' and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) >= '2025-09-12 18:28:15' and (resAreId = 1 or resAreId <= 0) nr: 0 12/09/2025 18:28:48.3389 2533 ms. EXECSCALAR: select count(resId) as Tot from movReservation where resStatus = 'V' and resTypeRes = 'B' AND ((resConfirmed IN (0,2,3) AND resCreation>'2025-09-12 17:28:45') OR resConfirmed IN (4,5)) and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) <= '2025-09-12 18:28:45' and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) >= '2025-09-12 18:28:45' and (resAreId = 1 or resAreId <= 0) nr: 0 12/09/2025 18:29:01.9108 2155 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 (WAIT TIME 215 ms.) 12/09/2025 18:29:02.4932 582 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 1 12/09/2025 18:29:02.5152 5394 ms. EXECSCALAR: select count(resId) as Tot from movReservation where resStatus = 'V' and resTypeRes = 'B' AND ((resConfirmed IN (0,2,3) AND resCreation>'2025-09-12 17:28:57') OR resConfirmed IN (4,5)) and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) <= '2025-09-12 18:28:57' and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) >= '2025-09-12 18:28:57' and (resAreId = 1 or resAreId <= 0) nr: 0 12/09/2025 18:29:03.9743 1978 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 3 (WAIT TIME 82 ms.) 12/09/2025 18:29:03.9743 1042 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 (WAIT TIME 82 ms.) 12/09/2025 18:29:03.9743 1144 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 1 and terStatus='V' (WAIT TIME 81 ms.) 12/09/2025 18:29:04.0453 4651 ms. OPEN: select sum(crc32(terDescription)) as vCheck from tabTerminal 12/09/2025 18:29:04.1394 1624 ms. EXEC: update tabTerminalExtraMem SET extLoop1 = 1, extPlate = '', extPlateAccuracy=0, extPlateReadDate='1970-01-01', extPlateWaitOperator=0,extTrpId=0, extTag = '' where extStatus='V' and extTerId = 1 12/09/2025 18:29:04.5942 518 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 12/09/2025 18:29:04.5952 620 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 1 12/09/2025 18:29:05.1157 655 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 384 ms.) 12/09/2025 18:29:05.6972 630 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 12/09/2025 18:29:05.7622 543 ms. OPEN: select terDefaultClass from tabTerminal where terStatus='V' and terId = 1 12/09/2025 18:29:06.0444 927 ms. OPEN: SELECT * FROM movTransit WHERE traStatus=@traStatus AND traCode=@traCode AND traDirection=@traDirection ORDER BY traDateTime,traId 12/09/2025 18:29:06.3906 596 ms. EXECSCALAR: select count(0) as vTot from tabParameters where parPlateReading<>0 nr: 0 12/09/2025 18:29:06.3906 858 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 2 OR lnsTerId=2) 12/09/2025 18:29:06.4447 593 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 (WAIT TIME 53 ms.) 12/09/2025 18:29:06.8480 2031 ms. OPEN: select sum(crc32(mesDescription)) as vCheck from tabMessage 12/09/2025 18:29:07.2856 2552 ms. EXECSCALAR: select count(resId) as Tot from movReservation where resStatus = 'V' and resTypeRes = 'B' AND ((resConfirmed IN (0,2,3) AND resCreation>'2025-09-12 17:29:04') OR resConfirmed IN (4,5)) and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) <= '2025-09-12 18:29:03' and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) >= '2025-09-12 18:29:03' and (resAreId = 1 or resAreId <= 0) nr: 0 (WAIT TIME 31 ms.) 12/09/2025 18:29:07.6912 1897 ms. OPEN: select * from tabClass where claPosition = 2 and claStatus='V' (WAIT TIME 30 ms.) 12/09/2025 18:29:09.7359 656 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 15 ms.) 12/09/2025 18:29:09.7359 546 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 (WAIT TIME 15 ms.) 12/09/2025 18:29:10.6111 875 ms. OPEN: select * from tabDevice where devId = 3 and devStatus = 'V' 12/09/2025 18:29:12.2518 1640 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 1 OR lnsTerId=1) (WAIT TIME 531 ms.) 12/09/2025 18:29:12.2518 2312 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 (WAIT TIME 93 ms.) 12/09/2025 18:29:12.2518 2203 ms. EXECSCALAR: select count(0) as vTot from tabParameters where parPlateReading<>0 nr: 0 (WAIT TIME 93 ms.) 12/09/2025 18:29:12.3299 4245 ms. EXECSCALAR: select count(resId) as Tot from movReservation where resStatus = 'V' and resTypeRes = 'B' AND ((resConfirmed IN (0,2,3) AND resCreation>'2025-09-12 17:29:07') OR resConfirmed IN (4,5)) and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) <= '2025-09-12 18:29:07' and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) >= '2025-09-12 18:29:07' and (resAreId = 1 or resAreId <= 0) nr: 0 (WAIT TIME 171 ms.) 12/09/2025 18:29:14.3457 2093 ms. OPEN: select traCode from movTransit where traCode ='459106654200327001012999' 12/09/2025 18:29:14.8613 515 ms. EXEC: update tabTerminalExtraMem SET extCode = @extCode, extUseId = 0 WHERE extStatus='V' and extTerId = @extTerId 12/09/2025 18:29:15.1738 531 ms. EXECSCALAR: select count(resId) as Tot from movReservation where resStatus = 'V' and resTypeRes = 'B' AND ((resConfirmed IN (0,2,3) AND resCreation>'2025-09-12 17:29:14') OR resConfirmed IN (4,5)) and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) <= '2025-09-12 18:29:12' and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) >= '2025-09-12 18:29:12' and (resAreId = 1 or resAreId <= 0) nr: 0 (WAIT TIME 296 ms.) 12/09/2025 18:29:15.1738 531 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 (WAIT TIME 296 ms.) 12/09/2025 18:29:15.9083 625 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 12/09/2025 18:29:15.9083 734 ms. EXECSCALAR: select count(0) as vTot from tabParameters where parPlateReading<>0 nr: 0 12/09/2025 18:29:15.9083 734 ms. EXECSCALAR: select claId from tabClass where claPosition = 2 and claStatus='V' nr: 2 12/09/2025 18:29:16.2051 5594 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 12/09/2025 18:29:17.0333 2015 ms. EXECSCALAR: select count(resId) as Tot from movReservation where resStatus = 'V' and resTypeRes = 'B' AND ((resConfirmed IN (0,2,3) AND resCreation>'2025-09-12 17:29:15') OR resConfirmed IN (4,5)) and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) <= '2025-09-12 18:29:13' and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) >= '2025-09-12 18:29:13' and (resAreId = 1 or resAreId <= 0) nr: 0 12/09/2025 18:29:19.0309 513 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 2 12/09/2025 18:29:19.4684 609 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 12/09/2025 18:29:19.4684 997 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 12/09/2025 18:29:19.9997 1093 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 12/09/2025 18:29:19.9997 531 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 1 OR lnsTerId=1) 12/09/2025 18:29:20.2653 1234 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 12/09/2025 18:29:20.4059 1685 ms. EXECSCALAR: SELECT traId FROM movTransit WHERE traStatus='V' AND traCode = @traCode nr: 1021895 12/09/2025 18:29:20.4059 687 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 5 and terStatus='V' 12/09/2025 18:29:20.4059 2950 ms. EXECSCALAR: select count(resId) as Tot from movReservation where resStatus = 'V' and resTypeRes = 'B' AND ((resConfirmed IN (0,2,3) AND resCreation>'2025-09-12 17:29:17') OR resConfirmed IN (4,5)) and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) <= '2025-09-12 18:29:16' and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) >= '2025-09-12 18:29:16' and (resAreId = 1 or resAreId <= 0) nr: 0 12/09/2025 18:29:21.4850 954 ms. OPEN: select * from movtransit where trastatus='V' and (traCode = '459105925100327005012999') and traDirection='I' order by traId desc limit 1 12/09/2025 18:29:21.6569 547 ms. EXECSCALAR: select count(0) as vTot from tabParameters where parPlateReading<>0 nr: 0 12/09/2025 18:29:23.6733 2031 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 6 and terStatus='V' 12/09/2025 18:29:23.6733 1844 ms. OPEN: select * from movtransit where trastatus='V' and traCode = '459105925100327005012999' order by traId desc limit 1 12/09/2025 18:29:23.6733 1844 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 12/09/2025 18:29:23.6733 2031 ms. EXECSCALAR: select count(resId) as Tot from movReservation where resStatus = 'V' and resTypeRes = 'B' AND ((resConfirmed IN (0,2,3) AND resCreation>'2025-09-12 17:29:21') OR resConfirmed IN (4,5)) and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) <= '2025-09-12 18:29:20' and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) >= '2025-09-12 18:29:20' and (resAreId = 1 or resAreId <= 0) nr: 0 12/09/2025 18:29:23.8608 2203 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 1 12/09/2025 18:29:25.1734 1031 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 1 OR lnsTerId=1) 12/09/2025 18:29:25.6421 1921 ms. EXECSCALAR: select count(0) as vTot from tabParameters where parPlateReading<>0 nr: 0 12/09/2025 18:29:25.6421 1843 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 12/09/2025 18:29:25.6421 4876 ms. EXECSCALAR: select count(resId) as Tot from movReservation where resStatus = 'V' and resTypeRes = 'B' AND ((resConfirmed IN (0,2,3) AND resCreation>'2025-09-12 17:29:20') OR resConfirmed IN (4,5)) and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) <= '2025-09-12 18:29:20' and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) >= '2025-09-12 18:29:20' and (resAreId = 1 or resAreId <= 0) nr: 0 12/09/2025 18:29:25.9078 2234 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 = '459105925100327005012999' and traStatus='V' and casStatus='V' and terType=3 and casTotAmount>0 12/09/2025 18:29:27.0953 984 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 = '459105925100327005012999' AND traStatus='V' AND payStatus='V' and (terType IS NULL OR terType<>3 OR (terType=3 and payType='P')) 12/09/2025 18:29:27.8922 2250 ms. EXECSCALAR: select count(resId) as Tot from movReservation where resStatus = 'V' and resTypeRes = 'B' AND ((resConfirmed IN (0,2,3) AND resCreation>'2025-09-12 17:29:25') OR resConfirmed IN (4,5)) and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) <= '2025-09-12 18:29:25' and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) >= '2025-09-12 18:29:25' and (resAreId = 1 or resAreId <= 0) nr: 0 12/09/2025 18:29:27.8922 1609 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 12/09/2025 18:29:28.8610 718 ms. EXEC: insert into temp_tariff (tarId,tarDay,tarHourFrom,tarHourTo,tarNumber,tarAmount,tarPeriod,tarPeriodLength,tarPeriodCount,tarDisabled,rulAmountPeriod,rulAmountPeriodDay) VALUES (16,1,'2023-02-16 00:00:00','2023-02-16 05:59:59',1,100,1,1,1,0,0,0); insert into temp_tariff (tarId,tarDay,tarHourFrom,tarHourTo,tarNumber,tarAmount,tarPeriod,tarPeriodLength,tarPeriodCount,tarDisabled,rulAmountPeriod,rulAmountPeriodDay) VALUES (16,2,'2023-02-16 00:00:00','2023-02-16 05:59:59',1,100,1,1,1,0,0,0); insert into temp_tariff (tarId,tarDay,tarHourFrom,tarHourTo,tarNumber,tarAmount,tarPeriod,tarPeriodLength,tarPeriodCount,tarDisabled,rulAmountPeriod,rulAmountPeriodDay) VALUES (16,3,'2023-02-16 00:00:00','2023-02-16 05:59:59',1,100,1,1,1,0,0,0); insert into temp_tariff (tarId,tarDay,tarHourFrom,tarHourTo,tarNumber,tarAmount,tarPeriod,tarPeriodLength,tarPeriodCount,tarDisabled,rulAmountPeriod,rulAmountPeriodDay) VALUES (16,4,'2023-02-16 00:00:00','2023-02-16 05:59:59',1,100,1,1,1,0,0,0); insert into temp_tariff (tarId,tarDay,tarHourFrom,tarHourTo,tarNumber,tarAmount,tarPeriod,tarPeriodLength,tarPeriodCount,tarDisabled,rulAmountPeriod,rulAmountPeriodDay) VALUES (16,5,'2023-02-16 00:00:00','2023-02-16 05:59:59',1,100,1,1,1,0,0,0); insert into temp_tariff (tarId,tarDay,tarHourFrom,tarHourTo,tarNumber,tarAmount,tarPeriod,tarPeriodLength,tarPeriodCount,tarDisabled,rulAmountPeriod,rulAmountPeriodDay) VALUES (16,6,'2023-02-16 00:00:00','2023-02-16 05:59:59',1,100,1,1,1,0,0,0); insert into temp_tariff (tarId,tarDay,tarHourFrom,tarHourTo,tarNumber,tarAmount,tarPeriod,tarPeriodLength,tarPeriodCount,tarDisabled,rulAmountPeriod,rulAmountPeriodDay) VALUES (16,7,'2023-02-16 00:00:00','2023-02-16 05:59:59',1,100,1,1,1,0,0,0); insert into temp_tariff (tarId,tarDay,tarHourFrom,tarHourTo,tarNumber,tarAmount,tarPeriod,tarPeriodLength,tarPeriodCount,tarDisabled,rulAmountPeriod,rulAmountPeriodDay) VALUES (17,1,'2023-02-16 00:00:00','2023-02-16 05:59:59',2,0,1,0,0,0,0,0); insert into temp_tariff (tarId,tarDay,tarHourFrom,tarHourTo,tarNumber,tarAmount,tarPeriod,tarPeriodLength,tarPeriodCount,tarDisabled,rulAmountPeriod,rulAmountPeriodDay) VALUES (17,2,'2023-02-16 00:00:00','2023-02-16 05:59:59',2,0,1,0,0,0,0,0); insert into temp_tariff (tarId,tarDay,tarHourFrom,tarHourTo,tarNumber,tarAmount,tarPeriod,tarPeriodLength,tarPeriodCount,tarDisabled,rulAmountPeriod,rulAmountPeriodDay) VALUES (17,3,'2023-02-16 00:00:00','2023-02-16 05:59:59',2,0,1,0,0,0,0,0); insert into temp_tariff (tarId,tarDay,tarHourFrom,tarHourTo,tarNumber,tarAmount,tarPeriod,tarPeriodLength,tarPeriodCount,tarDisabled,rulAmountPeriod,rulAmountPeriodDay) VALUES (17,4,'2023-02-16 00:00:00','2023-02-16 05:59:59',2,0,1,0,0,0,0,0); insert into temp_tariff (tarId,tarDay,tarHourFrom,tarHourTo,tarNumber,tarAmount,tarPeriod,tarPeriodLength,tarPeriodCount,tarDisabled,rulAmountPeriod,rulAmountPeriodDay) VALUES (17,5,'2023-02-16 00:00:00','2023-02-16 05:59:59',2,0,1,0,0,0,0,0); insert into temp_tariff (tarId,tarDay,tarHourFrom,tarHourTo,tarNumber,tarAmount,tarPeriod,tarPeriodLength,tarPeriodCount,tarDisabled,rulAmountPeriod,rulAmountPeriodDay) VALUES (17,6,'2023-02-16 00:00:00','2023-02-16 05:59:59',2,0,1,0,0,0,0,0); insert into temp_tariff (tarId,tarDay,tarHourFrom,tarHourTo,tarNumber,tarAmount,tarPeriod,tarPeriodLength,tarPeriodCount,tarDisabled,rulAmountPeriod,rulAmountPeriodDay) VALUES (17,7,'2023-02-16 00:00:00','2023-02-16 05:59:59',2,0,1,0,0,0,0,0); insert into temp_tariff (tarId,tarDay,tarHourFrom,tarHourTo,tarNumber,tarAmount,tarPeriod,tarPeriodLength,tarPeriodCount,tarDisabled,rulAmountPeriod,rulAmountPeriodDay) VALUES (18,1,'2023-02-16 06:00:00','2023-02-16 21:59:59',3,50,1,1,1,0,0,0); insert into temp_tariff (tarId,tarDay,tarHourFrom,tarHourTo,tarNumber,tarAmount,tarPeriod,tarPeriodLength,tarPeriodCount,tarDisabled,rulAmountPeriod,rulAmountPeriodDay) VALUES (18,2,'2023-02-16 06:00:00','2023-02-16 21:59:59',3,50,1,1,1,0,0,0); insert into temp_tariff (tarId,tarDay,tarHourFrom,tarHourTo,tarNumber,tarAmount,tarPeriod,tarPeriodLength,tarPeriodCount,tarDisabled,rulAmountPeriod,rulAmountPeriodDay) VALUES (18,3,'2023-02-16 06:00:00','2023-02-16 21:59:59',3,50,1,1,1,0,0,0); insert into temp_tariff (tarId,tarDay,tarHourFrom,tarHourTo,tarNumber,tarAmount,tarPeriod,tarPeriodLength,tarPeriodCount,tarDisabled,rulAmountPeriod,rulAmountPeriodDay) VALUES (18,4,'2023-02-16 06:00:00','2023-02-16 21:59:59',3,50,1,1,1,0,0,0); insert into temp_tariff (tarId,tarDay,tarHourFrom,tarHourTo,tarNumber,tarAmount,tarPeriod,tarPeriodLength,tarPeriodCount,tarDisabled,rulAmountPeriod,rulAmountPeriodDay) VALUES (18,5,'2023-02-16 06:00:00','2023-02-16 21:59:59',3,50,1,1,1,0,0,0); insert into temp_tariff (tarId,tarDay,tarHourFrom,tarHourTo,tarNumber,tarAmount,tarPeriod,tarPeriodLength,tarPeriodCount,tarDisabled,rulAmountPeriod,rulAmountPeriodDay) VALUES (18,6,'2023-02-16 06:00:00','2023-02-16 21:59:59',3,50,1,1,1,0,0,0); insert into temp_tariff (tarId,tarDay,tarHourFrom,tarHourTo,tarNumber,tarAmount,tarPeriod,tarPeriodLength,tarPeriodCount,tarDisabled,rulAmountPeriod,rulAmountPeriodDay) VALUES (18,7,'2023-02-16 06:00:00','2023-02-16 21:59:59',3,50,1,1,1,0,0,0); insert into temp_tariff (tarId,tarDay,tarHourFrom,tarHourTo,tarNumber,tarAmount,tarPeriod,tarPeriodLength,tarPeriodCount,tarDisabled,rulAmountPeriod,rulAmountPeriodDay) VALUES (19,1,'2023-02-16 06:00:00','2023-02-16 21:59:59',4,0,59,59,1,0,0,0); insert into temp_tariff (tarId,tarDay,tarHourFrom,tarHourTo,tarNumber,tarAmount,tarPeriod,tarPeriodLength,tarPeriodCount,tarDisabled,rulAmountPeriod,rulAmountPeriodDay) VALUES (19,2,'2023-02-16 06:00:00','2023-02-16 21:59:59',4,0,59,59,1,0,0,0); insert into temp_tariff (tarId,tarDay,tarHourFrom,tarHourTo,tarNumber,tarAmount,tarPeriod,tarPeriodLength,tarPeriodCount,tarDisabled,rulAmountPeriod,rulAmountPeriodDay) VALUES (19,3,'2023-02-16 06:00:00','2023-02-16 21:59:59',4,0,59,59,1,0,0,0); insert into temp_tariff (tarId,tarDay,tarHourFrom,tarHourTo,tarNumber,tarAmount,tarPeriod,tarPeriodLength,tarPeriodCount,tarDisabled,rulAmountPeriod,rulAmountPeriodDay) VALUES (19,4,'2023-02-16 06:00:00','2023-02-16 21:59:59',4,0,59,59,1,0,0,0); insert into temp_tariff (tarId,tarDay,tarHourFrom,tarHourTo,tarNumber,tarAmount,tarPeriod,tarPeriodLength,tarPeriodCount,tarDisabled,rulAmountPeriod,rulAmountPeriodDay) VALUES (19,5,'2023-02-16 06:00:00','2023-02-16 21:59:59',4,0,59,59,1,0,0,0); insert into temp_tariff (tarId,tarDay,tarHourFrom,tarHourTo,tarNumber,tarAmount,tarPeriod,tarPeriodLength,tarPeriodCount,tarDisabled,rulAmountPeriod,rulAmountPeriodDay) VALUES (19,6,'2023-02-16 06:00:00','2023-02-16 21:59:59',4,0,59,59,1,0,0,0); insert into temp_tariff (tarId,tarDay,tarHourFrom,tarHourTo,tarNumber,tarAmount,tarPeriod,tarPeriodLength,tarPeriodCount,tarDisabled,rulAmountPeriod,rulAmountPeriodDay) VALUES (19,7,'2023-02-16 06:00:00','2023-02-16 21:59:59',4,0,59,59,1,0,0,0); insert into temp_tariff (tarId,tarDay,tarHourFrom,tarHourTo,tarNumber,tarAmount,tarPeriod,tarPeriodLength,tarPeriodCount,tarDisabled,rulAmountPeriod,rulAmountPeriodDay) VALUES (20,1,'2023-02-16 06:00:00','2023-02-16 21:59:59',5,50,1,1,1,0,0,0); insert into temp_tariff (tarId,tarDay,tarHourFrom,tarHourTo,tarNumber,tarAmount,tarPeriod,tarPeriodLength,tarPeriodCount,tarDisabled,rulAmountPeriod,rulAmountPeriodDay) VALUES (20,2,'2023-02-16 06:00:00','2023-02-16 21:59:59',5,50,1,1,1,0,0,0); insert into temp_tariff (tarId,tarDay,tarHourFrom,tarHourTo,tarNumber,tarAmount,tarPeriod,tarPeriodLength,tarPeriodCount,tarDisabled,rulAmountPeriod,rulAmountPeriodDay) VALUES (20,3,'2023-02-16 06:00:00','2023-02-16 21:59:59',5,50,1,1,1,0,0,0); insert into temp_tariff (tarId,tarDay,tarHourFrom,tarHourTo,tarNumber,tarAmount,tarPeriod,tarPeriodLength,tarPeriodCount,tarDisabled,rulAmountPeriod,rulAmountPeriodDay) VALUES (20,4,'2023-02-16 06:00:00','2023-02-16 21:59:59',5,50,1,1,1,0,0,0); insert into temp_tariff (tarId,tarDay,tarHourFrom,tarHourTo,tarNumber,tarAmount,tarPeriod,tarPeriodLength,tarPeriodCount,tarDisabled,rulAmountPeriod,rulAmountPeriodDay) VALUES (20,5,'2023-02-16 06:00:00','2023-02-16 21:59:59',5,50,1,1,1,0,0,0); insert into temp_tariff (tarId,tarDay,tarHourFrom,tarHourTo,tarNumber,tarAmount,tarPeriod,tarPeriodLength,tarPeriodCount,tarDisabled,rulAmountPeriod,rulAmountPeriodDay) VALUES (20,6,'2023-02-16 06:00:00','2023-02-16 21:59:59',5,50,1,1,1,0,0,0); insert into temp_tariff (tarId,tarDay,tarHourFrom,tarHourTo,tarNumber,tarAmount,tarPeriod,tarPeriodLength,tarPeriodCount,tarDisabled,rulAmountPeriod,rulAmountPeriodDay) VALUES (20,7,'2023-02-16 06:00:00','2023-02-16 21:59:59',5,50,1,1,1,0,0,0); insert into temp_tariff (tarId,tarDay,tarHourFrom,tarHourTo,tarNumber,tarAmount,tarPeriod,tarPeriodLength,tarPeriodCount,tarDisabled,rulAmountPeriod,rulAmountPeriodDay) VALUES (21,1,'2023-02-16 06:00:00','2023-02-16 21:59:59',6,0,119,119,1,0,0,0); insert into temp_tariff (tarId,tarDay,tarHourFrom,tarHourTo,tarNumber,tarAmount,tarPeriod,tarPeriodLength,tarPeriodCount,tarDisabled,rulAmountPeriod,rulAmountPeriodDay) VALUES (21,2,'2023-02-16 06:00:00','2023-02-16 21:59:59',6,0,119,119,1,0,0,0); insert into temp_tariff (tarId,tarDay,tarHourFrom,tarHourTo,tarNumber,tarAmount,tarPeriod,tarPeriodLength,tarPeriodCount,tarDisabled,rulAmountPeriod,rulAmountPeriodDay) VALUES (21,3,'2023-02-16 06:00:00','2023-02-16 21:59:59',6,0,119,119,1,0,0,0); insert into temp_tariff (tarId,tarDay,tarHourFrom,tarHourTo,tarNumber,tarAmount,tarPeriod,tarPeriodLength,tarPeriodCount,tarDisabled,rulAmountPeriod,rulAmountPeriodDay) VALUES (21,4,'2023-02-16 06:00:00','2023-02-16 21:59:59',6,0,119,119,1,0,0,0); insert into temp_tariff (tarId,tarDay,tarHourFrom,tarHourTo,tarNumber,tarAmount,tarPeriod,tarPeriodLength,tarPeriodCount,tarDisabled,rulAmountPeriod,rulAmountPeriodDay) VALUES (21,5,'2023-02-16 06:00:00','2023-02-16 21:59:59',6,0,119,119,1,0,0,0); insert into temp_tariff (tarId,tarDay,tarHourFrom,tarHourTo,tarNumber,tarAmount,tarPeriod,tarPeriodLength,tarPeriodCount,tarDisabled,rulAmountPeriod,rulAmountPeriodDay) VALUES (21,6,'2023-02-16 06:00:00','2023-02-16 21:59:59',6,0,119,119,1,0,0,0); insert into temp_tariff (tarId,tarDay,tarHourFrom,tarHourTo,tarNumber,tarAmount,tarPeriod,tarPeriodLength,tarPeriodCount,tarDisabled,rulAmountPeriod,rulAmountPeriodDay) VALUES (21,7,'2023-02-16 06:00:00','2023-02-16 21:59:59',6,0,119,119,1,0,0,0); insert into temp_tariff (tarId,tarDay,tarHourFrom,tarHourTo,tarNumber,tarAmount,tarPeriod,tarPeriodLength,tarPeriodCount,tarDisabled,rulAmountPeriod,rulAmountPeriodDay) VALUES (22,1,'2023-02-16 06:00:00','2023-02-16 21:59:59',7,100,1,1,1,0,0,0); insert into temp_tariff (tarId,tarDay,tarHourFrom,tarHourTo,tarNumber,tarAmount,tarPeriod,tarPeriodLength,tarPeriodCount,tarDisabled,rulAmountPeriod,rulAmountPeriodDay) VALUES (22,2,'2023-02-16 06:00:00','2023-02-16 21:59:59',7,100,1,1,1,0,0,0); insert into temp_tariff (tarId,tarDay,tarHourFrom,tarHourTo,tarNumber,tarAmount,tarPeriod,tarPeriodLength,tarPeriodCount,tarDisabled,rulAmountPeriod,rulAmountPeriodDay) VALUES (22,3,'2023-02-16 06:00:00','2023-02-16 21:59:59',7,100,1,1,1,0,0,0); insert into temp_tariff (tarId,tarDay,tarHourFrom,tarHourTo,tarNumber,tarAmount,tarPeriod,tarPeriodLength,tarPeriodCount,tarDisabled,rulAmountPeriod,rulAmountPeriodDay) VALUES (22,4,'2023-02-16 06:00:00','2023-02-16 21:59:59',7,100,1,1,1,0,0,0); insert into temp_tariff (tarId,tarDay,tarHourFrom,tarHourTo,tarNumber,tarAmount,tarPeriod,tarPeriodLength,tarPeriodCount,tarDisabled,rulAmountPeriod,rulAmountPeriodDay) VALUES (22,5,'2023-02-16 06:00:00','2023-02-16 21:59:59',7,100,1,1,1,0,0,0); insert into temp_tariff (tarId,tarDay,tarHourFrom,tarHourTo,tarNumber,tarAmount,tarPeriod,tarPeriodLength,tarPeriodCount,tarDisabled,rulAmountPeriod,rulAmountPeriodDay) VALUES (22,6,'2023-02-16 06:00:00','2023-02-16 21:59:59',7,100,1,1,1,0,0,0); insert into temp_tariff (tarId,tarDay,tarHourFrom,tarHourTo,tarNumber,tarAmount,tarPeriod,tarPeriodLength,tarPeriodCount,tarDisabled,rulAmountPeriod,rulAmountPeriodDay) VALUES (22,7,'2023-02-16 06:00:00','2023-02-16 21:59:59',7,100,1,1,1,0,0,0); insert into temp_tariff (tarId,tarDay,tarHourFrom,tarHourTo,tarNumber,tarAmount,tarPeriod,tarPeriodLength,tarPeriodCount,tarDisabled,rulAmountPeriod,rulAmountPeriodDay) VALUES (23,1,'2023-02-16 06:00:00','2023-02-16 21:59:59',8,0,59,59,1,0,0,0); insert into temp_tariff (tarId,tarDay,tarHourFrom,tarHourTo,tarNumber,tarAmount,tarPeriod,tarPeriodLength,tarPeriodCount,tarDisabled,rulAmountPeriod,rulAmountPeriodDay) VALUES (23,2,'2023-02-16 06:00:00','2023-02-16 21:59:59',8,0,59,59,1,0,0,0); insert into temp_tariff (tarId,tarDay,tarHourFrom,tarHourTo,tarNumber,tarAmount,tarPeriod,tarPeriodLength,tarPeriodCount,tarDisabled,rulAmountPeriod,rulAmountPeriodDay) VALUES (23,3,'2023-02-16 06:00:00','2023-02-16 21:59:59',8,0,59,59,1,0,0,0); insert into temp_tariff (tarId,tarDay,tarHourFrom,tarHourTo,tarNumber,tarAmount,tarPeriod,tarPeriodLength,tarPeriodCount,tarDisabled,rulAmountPeriod,rulAmountPeriodDay) VALUES (23,4,'2023-02-16 06:00:00','2023-02-16 21:59:59',8,0,59,59,1,0,0,0); insert into temp_tariff (tarId,tarDay,tarHourFrom,tarHourTo,tarNumber,tarAmount,tarPeriod,tarPeriodLength,tarPeriodCount,tarDisabled,rulAmountPeriod,rulAmountPeriodDay) VALUES (23,5,'2023-02-16 06:00:00','2023-02-16 21:59:59',8,0,59,59,1,0,0,0); insert into temp_tariff (tarId,tarDay,tarHourFrom,tarHourTo,tarNumber,tarAmount,tarPeriod,tarPeriodLength,tarPeriodCount,tarDisabled,rulAmountPeriod,rulAmountPeriodDay) VALUES (23,6,'2023-02-16 06:00:00','2023-02-16 21:59:59',8,0,59,59,1,0,0,0); insert into temp_tariff (tarId,tarDay,tarHourFrom,tarHourTo,tarNumber,tarAmount,tarPeriod,tarPeriodLength,tarPeriodCount,tarDisabled,rulAmountPeriod,rulAmountPeriodDay) VALUES (23,7,'2023-02-16 06:00:00','2023-02-16 21:59:59',8,0,59,59,1,0,0,0); insert into temp_tariff (tarId,tarDay,tarHourFrom,tarHourTo,tarNumber,tarAmount,tarPeriod,tarPeriodLength,tarPeriodCount,tarDisabled,rulAmountPeriod,rulAmountPeriodDay) VALUES (24,1,'2023-02-16 06:00:00','2023-02-16 21:59:59',9,100,60,0,0,0,0,0); insert into temp_tariff (tarId,tarDay,tarHourFrom,tarHourTo,tarNumber,tarAmount,tarPeriod,tarPeriodLength,tarPeriodCount,tarDisabled,rulAmountPeriod,rulAmountPeriodDay) VALUES (24,2,'2023-02-16 06:00:00','2023-02-16 21:59:59',9,100,60,0,0,0,0,0); insert into temp_tariff (tarId,tarDay,tarHourFrom,tarHourTo,tarNumber,tarAmount,tarPeriod,tarPeriodLength,tarPeriodCount,tarDisabled,rulAmountPeriod,rulAmountPeriodDay) VALUES (24,3,'2023-02-16 06:00:00','2023-02-16 21:59:59',9,100,60,0,0,0,0,0); insert into temp_tariff (tarId,tarDay,tarHourFrom,tarHourTo,tarNumber,tarAmount,tarPeriod,tarPeriodLength,tarPeriodCount,tarDisabled,rulAmountPeriod,rulAmountPeriodDay) VALUES (24,4,'2023-02-16 06:00:00','2023-02-16 21:59:59',9,100,60,0,0,0,0,0); insert into temp_tariff (tarId,tarDay,tarHourFrom,tarHourTo,tarNumber,tarAmount,tarPeriod,tarPeriodLength,tarPeriodCount,tarDisabled,rulAmountPeriod,rulAmountPeriodDay) VALUES (24,5,'2023-02-16 06:00:00','2023-02-16 21:59:59',9,100,60,0,0,0,0,0); insert into temp_tariff (tarId,tarDay,tarHourFrom,tarHourTo,tarNumber,tarAmount,tarPeriod,tarPeriodLength,tarPeriodCount,tarDisabled,rulAmountPeriod,rulAmountPeriodDay) VALUES (24,6,'2023-02-16 06:00:00','2023-02-16 21:59:59',9,100,60,0,0,0,0,0); insert into temp_tariff (tarId,tarDay,tarHourFrom,tarHourTo,tarNumber,tarAmount,tarPeriod,tarPeriodLength,tarPeriodCount,tarDisabled,rulAmountPeriod,rulAmountPeriodDay) VALUES (24,7,'2023-02-16 06:00:00','2023-02-16 21:59:59',9,100,60,0,0,0,0,0); insert into temp_tariff (tarId,tarDay,tarHourFrom,tarHourTo,tarNumber,tarAmount,tarPeriod,tarPeriodLength,tarPeriodCount,tarDisabled,rulAmountPeriod,rulAmountPeriodDay) VALUES (25,1,'2023-02-16 22:00:00','2023-02-16 23:57:59',10,100,57,57,1,0,0,0); insert into temp_tariff (tarId,tarDay,tarHourFrom,tarHourTo,tarNumber,tarAmount,tarPeriod,tarPeriodLength,tarPeriodCount,tarDisabled,rulAmountPeriod,rulAmountPeriodDay) VALUES (25,2,'2023-02-16 22:00:00','2023-02-16 23:57:59',10,100,57,57,1,0,0,0); insert into temp_tariff (tarId,tarDay,tarHourFrom,tarHourTo,tarNumber,tarAmount,tarPeriod,tarPeriodLength,tarPeriodCount,tarDisabled,rulAmountPeriod,rulAmountPeriodDay) VALUES (25,3,'2023-02-16 22:00:00','2023-02-16 23:57:59',10,100,57,57,1,0,0,0); insert into temp_tariff (tarId,tarDay,tarHourFrom,tarHourTo,tarNumber,tarAmount,tarPeriod,tarPeriodLength,tarPeriodCount,tarDisabled,rulAmountPeriod,rulAmountPeriodDay) VALUES (25,4,'2023-02-16 22:00:00','2023-02-16 23:57:59',10,100,57,57,1,0,0,0); insert into temp_tariff (tarId,tarDay,tarHourFrom,tarHourTo,tarNumber,tarAmount,tarPeriod,tarPeriodLength,tarPeriodCount,tarDisabled,rulAmountPeriod,rulAmountPeriodDay) VALUES (25,5,'2023-02-16 22:00:00','2023-02-16 23:57:59',10,100,57,57,1,0,0,0); insert into temp_tariff (tarId,tarDay,tarHourFrom,tarHourTo,tarNumber,tarAmount,tarPeriod,tarPeriodLength,tarPeriodCount,tarDisabled,rulAmountPeriod,rulAmountPeriodDay) VALUES (25,6,'2023-02-16 22:00:00','2023-02-16 23:57:59',10,100,57,57,1,0,0,0); insert into temp_tariff (tarId,tarDay,tarHourFrom,tarHourTo,tarNumber,tarAmount,tarPeriod,tarPeriodLength,tarPeriodCount,tarDisabled,rulAmountPeriod,rulAmountPeriodDay) VALUES (25,7,'2023-02-16 22:00:00','2023-02-16 23:57:59',10,100,57,57,1,0,0,0); insert into temp_tariff (tarId,tarDay,tarHourFrom,tarHourTo,tarNumber,tarAmount,tarPeriod,tarPeriodLength,tarPeriodCount,tarDisabled,rulAmountPeriod,rulAmountPeriodDay) VALUES (26,1,'2023-02-16 22:00:00','2023-02-16 23:57:59',11,0,1,0,0,0,0,0); insert into temp_tariff (tarId,tarDay,tarHourFrom,tarHourTo,tarNumber,tarAmount,tarPeriod,tarPeriodLength,tarPeriodCount,tarDisabled,rulAmountPeriod,rulAmountPeriodDay) VALUES (26,2,'2023-02-16 22:00:00','2023-02-16 23:57:59',11,0,1,0,0,0,0,0); insert into temp_tariff (tarId,tarDay,tarHourFrom,tarHourTo,tarNumber,tarAmount,tarPeriod,tarPeriodLength,tarPeriodCount,tarDisabled,rulAmountPeriod,rulAmountPeriodDay) VALUES (26,3,'2023-02-16 22:00:00','2023-02-16 23:57:59',11,0,1,0,0,0,0,0); insert into temp_tariff (tarId,tarDay,tarHourFrom,tarHourTo,tarNumber,tarAmount,tarPeriod,tarPeriodLength,tarPeriodCount,tarDisabled,rulAmountPeriod,rulAmountPeriodDay) VALUES (26,4,'2023-02-16 22:00:00','2023-02-16 23:57:59',11,0,1,0,0,0,0,0); insert into temp_tariff (tarId,tarDay,tarHourFrom,tarHourTo,tarNumber,tarAmount,tarPeriod,tarPeriodLength,tarPeriodCount,tarDisabled,rulAmountPeriod,rulAmountPeriodDay) VALUES (26,5,'2023-02-16 22:00:00','2023-02-16 23:57:59',11,0,1,0,0,0,0,0); insert into temp_tariff (tarId,tarDay,tarHourFrom,tarHourTo,tarNumber,tarAmount,tarPeriod,tarPeriodLength,tarPeriodCount,tarDisabled,rulAmountPeriod,rulAmountPeriodDay) VALUES (26,6,'2023-02-16 22:00:00','2023-02-16 23:57:59',11,0,1,0,0,0,0,0); insert into temp_tariff (tarId,tarDay,tarHourFrom,tarHourTo,tarNumber,tarAmount,tarPeriod,tarPeriodLength,tarPeriodCount,tarDisabled,rulAmountPeriod,rulAmountPeriodDay) VALUES (26,7,'2023-02-16 22:00:00','2023-02-16 23:57:59',11,0,1,0,0,0,0,0); insert into temp_tariff (tarId,tarDay,tarHourFrom,tarHourTo,tarNumber,tarAmount,tarPeriod,tarPeriodLength,tarPeriodCount,tarDisabled,rulAmountPeriod,rulAmountPeriodDay) VALUES (27,1,'2023-02-16 23:58:00','2023-02-16 23:59:59',12,-100,1,1,1,0,0,0); insert into temp_tariff (tarId,tarDay,tarHourFrom,tarHourTo,tarNumber,tarAmount,tarPeriod,tarPeriodLength,tarPeriodCount,tarDisabled,rulAmountPeriod,rulAmountPeriodDay) VALUES (27,2,'2023-02-16 23:58:00','2023-02-16 23:59:59',12,-100,1,1,1,0,0,0); insert into temp_tariff (tarId,tarDay,tarHourFrom,tarHourTo,tarNumber,tarAmount,tarPeriod,tarPeriodLength,tarPeriodCount,tarDisabled,rulAmountPeriod,rulAmountPeriodDay) VALUES (27,3,'2023-02-16 23:58:00','2023-02-16 23:59:59',12,-100,1,1,1,0,0,0); insert into temp_tariff (tarId,tarDay,tarHourFrom,tarHourTo,tarNumber,tarAmount,tarPeriod,tarPeriodLength,tarPeriodCount,tarDisabled,rulAmountPeriod,rulAmountPeriodDay) VALUES (27,4,'2023-02-16 23:58:00','2023-02-16 23:59:59',12,-100,1,1,1,0,0,0); insert into temp_tariff (tarId,tarDay,tarHourFrom,tarHourTo,tarNumber,tarAmount,tarPeriod,tarPeriodLength,tarPeriodCount,tarDisabled,rulAmountPeriod,rulAmountPeriodDay) VALUES (27,5,'2023-02-16 23:58:00','2023-02-16 23:59:59',12,-100,1,1,1,0,0,0); insert into temp_tariff (tarId,tarDay,tarHourFrom,tarHourTo,tarNumber,tarAmount,tarPeriod,tarPeriodLength,tarPeriodCount,tarDisabled,rulAmountPeriod,rulAmountPeriodDay) VALUES (27,6,'2023-02-16 23:58:00','2023-02-16 23:59:59',12,-100,1,1,1,0,0,0); insert into temp_tariff (tarId,tarDay,tarHourFrom,tarHourTo,tarNumber,tarAmount,tarPeriod,tarPeriodLength,tarPeriodCount,tarDisabled,rulAmountPeriod,rulAmountPeriodDay) VALUES (27,7,'2023-02-16 23:58:00','2023-02-16 23:59:59',12,-100,1,1,1,0,0,0); insert into temp_tariff (tarId,tarDay,tarHourFrom,tarHourTo,tarNumber,tarAmount,tarPeriod,tarPeriodLength,tarPeriodCount,tarDisabled,rulAmountPeriod,rulAmountPeriodDay) VALUES (28,1,'2023-02-16 23:58:00','2023-02-16 23:59:59',13,0,1,0,0,0,0,0); insert into temp_tariff (tarId,tarDay,tarHourFrom,tarHourTo,tarNumber,tarAmount,tarPeriod,tarPeriodLength,tarPeriodCount,tarDisabled,rulAmountPeriod,rulAmountPeriodDay) VALUES (28,2,'2023-02-16 23:58:00','2023-02-16 23:59:59',13,0,1,0,0,0,0,0); insert into temp_tariff (tarId,tarDay,tarHourFrom,tarHourTo,tarNumber,tarAmount,tarPeriod,tarPeriodLength,tarPeriodCount,tarDisabled,rulAmountPeriod,rulAmountPeriodDay) VALUES (28,3,'2023-02-16 23:58:00','2023-02-16 23:59:59',13,0,1,0,0,0,0,0); insert into temp_tariff (tarId,tarDay,tarHourFrom,tarHourTo,tarNumber,tarAmount,tarPeriod,tarPeriodLength,tarPeriodCount,tarDisabled,rulAmountPeriod,rulAmountPeriodDay) VALUES (28,4,'2023-02-16 23:58:00','2023-02-16 23:59:59',13,0,1,0,0,0,0,0); insert into temp_tariff (tarId,tarDay,tarHourFrom,tarHourTo,tarNumber,tarAmount,tarPeriod,tarPeriodLength,tarPeriodCount,tarDisabled,rulAmountPeriod,rulAmountPeriodDay) VALUES (28,5,'2023-02-16 23:58:00','2023-02-16 23:59:59',13,0,1,0,0,0,0,0); insert into temp_tariff (tarId,tarDay,tarHourFrom,tarHourTo,tarNumber,tarAmount,tarPeriod,tarPeriodLength,tarPeriodCount,tarDisabled,rulAmountPeriod,rulAmountPeriodDay) VALUES (28,6,'2023-02-16 23:58:00','2023-02-16 23:59:59',13,0,1,0,0,0,0,0); insert into temp_tariff (tarId,tarDay,tarHourFrom,tarHourTo,tarNumber,tarAmount,tarPeriod,tarPeriodLength,tarPeriodCount,tarDisabled,rulAmountPeriod,rulAmountPeriodDay) VALUES (28,7,'2023-02-16 23:58:00','2023-02-16 23:59:59',13,0,1,0,0,0,0,0); 12/09/2025 18:29:29.0486 734 ms. OPEN: select * from movtransit where trastatus='V' and (traCode = '300033') and traDirection='I' order by traId desc limit 1 12/09/2025 18:29:29.7673 12437 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-09-12 18:29:17','V',5385001392754870,2025,'2025-09-12 18:29:02','459106654200327001012999',1,2,1,'I','',1,0,1,'','',4) 12/09/2025 18:29:29.9548 687 ms. EXECSCALAR: select count(resId) as Tot from movReservation where resStatus = 'V' and resTypeRes = 'B' AND ((resConfirmed IN (0,2,3) AND resCreation>'2025-09-12 17:29:29') OR resConfirmed IN (4,5)) and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) <= '2025-09-12 18:29:29' and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) >= '2025-09-12 18:29:29' and (resAreId = 1 or resAreId <= 0) nr: 0 12/09/2025 18:29:30.6580 625 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 12/09/2025 18:29:31.7368 781 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 12/09/2025 18:29:33.5807 578 ms. EXECSCALAR: select count(resId) as Tot from movReservation where resStatus = 'V' and resTypeRes = 'B' AND ((resConfirmed IN (0,2,3) AND resCreation>'2025-09-12 17:29:33') OR resConfirmed IN (4,5)) and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) <= '2025-09-12 18:29:33' and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) >= '2025-09-12 18:29:33' and (resAreId = 1 or resAreId <= 0) nr: 0 12/09/2025 18:29:36.0969 531 ms. EXECSCALAR: select count(resId) as Tot from movReservation where resStatus = 'V' and resTypeRes = 'B' AND ((resConfirmed IN (0,2,3) AND resCreation>'2025-09-12 17:29:35') OR resConfirmed IN (4,5)) and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) <= '2025-09-12 18:29:35' and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) >= '2025-09-12 18:29:35' and (resAreId = 1 or resAreId <= 0) nr: 0 12/09/2025 18:29:37.5036 797 ms. EXECSCALAR: select count(resId) as Tot from movReservation where resStatus = 'V' and resTypeRes = 'B' AND ((resConfirmed IN (0,2,3) AND resCreation>'2025-09-12 17:29:36') OR resConfirmed IN (4,5)) and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) <= '2025-09-12 18:29:36' and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) >= '2025-09-12 18:29:36' and (resAreId = 1 or resAreId <= 0) nr: 0 12/09/2025 18:29:37.9099 5751 ms. OPEN: SELECT * FROM abbsubscriptions INNER JOIN abbcards ON carSubId=subId INNER JOIN tabcustomer ON subCusId=cusId WHERE carStatus='V' AND subStatus='V' AND (carCode<>'' OR carUHFCode<>'') AND subAbbType NOT IN (6,-1) ORDER BY carCode 12/09/2025 18:29:41.0506 515 ms. EXECSCALAR: select count(resId) as Tot from movReservation where resStatus = 'V' and resTypeRes = 'B' AND ((resConfirmed IN (0,2,3) AND resCreation>'2025-09-12 17:29:40') OR resConfirmed IN (4,5)) and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) <= '2025-09-12 18:29:40' and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) >= '2025-09-12 18:29:40' and (resAreId = 1 or resAreId <= 0) nr: 0 12/09/2025 18:29:42.5507 1000 ms. EXECSCALAR: select count(resId) as Tot from movReservation where resStatus = 'V' and resTypeRes = 'B' AND ((resConfirmed IN (0,2,3) AND resCreation>'2025-09-12 17:29:41') OR resConfirmed IN (4,5)) and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) <= '2025-09-12 18:29:41' and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) >= '2025-09-12 18:29:41' and (resAreId = 1 or resAreId <= 0) nr: 0 12/09/2025 18:29:50.9433 515 ms. OPEN: select * from movTransit inner join paypayment on paypayment.payTraUID = movTransit.traUID where traCode = '300033' and traStatus='V' and payStatus='V' order by payDateTime desc 12/09/2025 18:29:54.6327 1219 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-09-12 18:29:53','V',4846638517115110,2025,'2025-09-12 18:29:36','459106657600327001031999',1,2,1,'I','',1,0,1,'','',4) 12/09/2025 18:29:55.6640 937 ms. OPEN: select * from movtransit where traUID = 5232352202821010 and traStatus='V' 12/09/2025 18:29:55.6640 937 ms. EXECSCALAR: select count(resId) as Tot from movReservation where resStatus = 'V' and resTypeRes = 'B' AND ((resConfirmed IN (0,2,3) AND resCreation>'2025-09-12 17:29:54') OR resConfirmed IN (4,5)) and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) <= '2025-09-12 18:29:54' and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) >= '2025-09-12 18:29:54' and (resAreId = 1 or resAreId <= 0) nr: 0 12/09/2025 18:29:55.9296 1296 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 12/09/2025 18:29:56.2265 515 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-09-12 18:29:52',0,'V',5715403978373700,5232352202821010,2025,'2025-09-12 18:29:52',3,1,0,4,'2025-09-12 18:44:52','C','KES',100,100,0,'',' ',' ',1,100,0,0,'',0,0) 12/09/2025 18:29:56.4453 734 ms. EXEC: INSERT INTO movOperator (opeCreation,opeUseId,opeTerId,opeDateTime,opeCode,opeDescription) VALUES ('2025-09-12 18:29:55',0,1,'2025-09-12 18:29:55','','Unauthorized Transit Entry 1') 12/09/2025 18:30:04.2902 516 ms. OPEN: select * from movtransit where trastatus='V' and (traCode = '459106440300327001012999') and traDirection='I' order by traId desc limit 1 12/09/2025 18:30:13.0094 546 ms. EXEC: update tabTerminalExtraMem SET extBarrier = 1, extPlate = '', extPlateAccuracy=0, extPlateReadDate='1970-01-01', extPlateWaitOperator=0,extTrpId=0, extTag = '' where extStatus='V' and extTerId = 2 12/09/2025 18:30:59.8170 765 ms. EXECSCALAR: select count(resId) as Tot from movReservation where resStatus = 'V' and resTypeRes = 'B' AND ((resConfirmed IN (0,2,3) AND resCreation>'2025-09-12 17:30:59') OR resConfirmed IN (4,5)) and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) <= '2025-09-12 18:30:59' and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) >= '2025-09-12 18:30:59' and (resAreId = 1 or resAreId <= 0) nr: 0 12/09/2025 18:33:01.0224 640 ms. EXECSCALAR: select count(resId) as Tot from movReservation where resStatus = 'V' and resTypeRes = 'B' AND ((resConfirmed IN (0,2,3) AND resCreation>'2025-09-12 17:33:00') OR resConfirmed IN (4,5)) and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) <= '2025-09-12 18:33:00' and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) >= '2025-09-12 18:33:00' and (resAreId = 1 or resAreId <= 0) nr: 0 12/09/2025 18:37:47.4912 7877 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 12/09/2025 18:37:48.1788 671 ms. OPEN: select traId,traDateTime,traEnabled,traDisableTime,traCode,traBadge,traCarId,traAreId,traIdTerminal from movtransit where traStatus='V' and traDirection = 'O' and traCarId = 111 order by traDateTime desc,traId desc 12/09/2025 18:38:11.6055 2125 ms. OPEN: select max(traCode) as vCode from movTransit where traCode >='45910 ' and traCode < '45911 ' and traType = 2 12/09/2025 18:55:53.0466 8281 ms. OPEN: select traId,traDateTime,traEnabled,traDisableTime,traCode,traBadge,traCarId,traAreId,traIdTerminal from movtransit where traStatus='V' and traDirection = 'I' and traCarId = 30 order by traDateTime desc,traId desc 12/09/2025 18:58:59.2090 1908 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-09-12 18:58:56',0,'V',4639754947904230,5002427739800470,2025,'2025-09-12 18:58:56',18,1,0,4,'2025-09-12 19:13:56','C','KES',100,100,0,'','','',1,100,0,0,'',0,0) 12/09/2025 19:02:34.6057 640 ms. OPEN: select traId,traDateTime,traEnabled,traDisableTime,traCode,traBadge,traCarId,traAreId,traIdTerminal from movtransit where traStatus='V' and traDirection = 'I' and traCarId = 169 order by traDateTime desc,traId desc 12/09/2025 19:05:50.6561 8985 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 12/09/2025 19:08:32.4645 21408 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 12/09/2025 19:09:22.1057 515 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 12/09/2025 19:35:32.4962 1115 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 12/09/2025 19:36:04.3854 1500 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 12/09/2025 19:55:11.7483 562 ms. OPEN: select traId,traDateTime,traEnabled,traDisableTime,traCode,traBadge,traCarId,traAreId,traIdTerminal from movtransit where traStatus='V' and traDirection = 'I' and traCarId = 31 order by traDateTime desc,traId desc