19/03/2025 21:51:16.8093   876 ms.           OPEN: show columns from tabParameters where Field = 'parUseCulture'
19/03/2025 21:51:16.8143   879 ms.           OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 5
19/03/2025 21:51:16.8153   878 ms.           OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 3
19/03/2025 21:51:16.8163   881 ms.           OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 1
19/03/2025 21:51:16.8173   880 ms.           OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 3
19/03/2025 21:51:16.8173   881 ms.           OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 1
19/03/2025 21:51:16.8183   881 ms.           OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 5
19/03/2025 21:51:16.8183   883 ms.           OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 1
19/03/2025 21:51:16.8193   882 ms.           OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 2
19/03/2025 21:51:16.8193   884 ms.           OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 5
19/03/2025 21:51:16.8193   882 ms.           OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 3
19/03/2025 21:51:16.8204   883 ms.           OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 1
19/03/2025 21:51:16.8214   885 ms.           OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 5
19/03/2025 21:51:16.8224   886 ms.           OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 1
19/03/2025 21:51:16.8224   887 ms.           OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 3
19/03/2025 21:51:16.8234   888 ms.           OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 1
19/03/2025 21:51:16.8234   887 ms.           OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 2
19/03/2025 21:51:16.8244   888 ms.           OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 2
19/03/2025 21:51:16.8244   890 ms.           OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 3
19/03/2025 21:51:16.8244   889 ms.           OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 2
19/03/2025 21:51:16.8254   889 ms.           OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 2
19/03/2025 21:51:16.8254   888 ms.           OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 2
19/03/2025 21:51:16.8264   889 ms.           OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 3
19/03/2025 21:51:16.8274   891 ms.           OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 5
19/03/2025 21:51:19.3793   503 ms.     EXECSCALAR: select count(resId) as Tot from movReservation where resStatus = 'V' and resTypeRes = 'B' AND ((resConfirmed IN (0,2,3) AND resCreation>'2025-03-19 20:51:18') OR resConfirmed IN (4,5)) and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) <= '2025-03-19 21:51:18' and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) >= '2025-03-19 21:51:18' and (resAreId = 1 or resAreId <= 0) nr: 0
19/03/2025 21:51:19.3893   503 ms.     EXECSCALAR: select count(resId) as Tot from movReservation where resStatus = 'V' and resTypeRes = 'B' AND ((resConfirmed IN (0,2,3) AND resCreation>'2025-03-19 20:51:18') OR resConfirmed IN (4,5)) and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) <= '2025-03-19 21:51:18' and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) >= '2025-03-19 21:51:18' and (resAreId = 1 or resAreId <= 0) nr: 0
19/03/2025 21:51:19.3984   507 ms.     EXECSCALAR: select count(resId) as Tot from movReservation where resStatus = 'V' and resTypeRes = 'B' AND ((resConfirmed IN (0,2,3) AND resCreation>'2025-03-19 20:51:18') OR resConfirmed IN (4,5)) and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) <= '2025-03-19 21:51:17' and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) >= '2025-03-19 21:51:17' and (resAreId = 1 or resAreId <= 0) nr: 0 (WAIT TIME 15 ms.)
19/03/2025 21:51:23.3590  4878 ms.     EXECSCALAR: SELECT count(*) FROM payinventory WHERE invValue<>0 AND invType='' nr: 0
19/03/2025 21:51:29.0425  5439 ms.           EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40);
19/03/2025 21:51:30.0251  6087 ms.           OPEN: SELECT * FROM movLinks INNER JOIN movTransit on traUID = mliTraUID WHERE mliRFIDCode = '0098788193179' AND mliStatus='V' ORDER BY mliId DESC LIMIT 1
19/03/2025 21:51:32.1295  3086 ms.           EXEC: UPDATE payInventory SET invType='C' WHERE invType<>'C' AND invValue IN (5,10,20,40) AND invDevice IN (41003,41002,41001,41101,41102,41103);
19/03/2025 21:51:32.5138  1355 ms.           EXEC: insert into movtransit (traUseId,traCreation,traStatus,traUID,traYear,traDateTime,traCode,traType,traClass,traIdTerminal,traDirection,traPlate,traEnabled,traDisableTime,traAreId,traNotes,traBadge,traCarId,traTarId) VALUES (0,'2025-03-19 21:51:31','V',5178734909159650,2025,'2025-03-19 21:51:13','457337562100327005029999',2,2,16,'I','',1,0,1,'','0532370678683',208,0)
19/03/2025 21:51:33.5025   976 ms.           EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage)
19/03/2025 21:52:38.0517  1320 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 = '457337624700327005012999' AND traStatus='V' AND payStatus='V' and (terType IS NULL OR terType<>3 OR (terType=3 and payType='P'))
19/03/2025 21:59:55.9693 16623 ms.           OPEN: select count(payId) as Tot,0 as payUID,sum(payPayed) as payPayed,sum(payChange) as payChange,payAmount,traUIDGroup,traType,traClass,traIdTerminal,traDiscountValue,traDiscountType,traCarId,payIdEvent,payType,payCardType from payPayment LEFT join movtransit on trauid = payTraUID LEFT JOIN payReport ON repPayUID = payUID AND repStatus='V' where payStatus = 'V' and (payType='C' or payType='P') and payUseId = 9 and payIdEvent<90 and repPayUID IS NULL and (traCarId is null or traCarId=0 or traCarId in (select carId from abbCards inner join abbsubscriptions on subId= carSubId where carStatus='V' and subStatus='V' and subAbbType<>5)) group by traUIDGroup,payAmount,payIdEvent,payType,payCardType,traType,traIdTerminal,traDiscountValue,traDiscountType,traCarId order by traUIDGroup,payAmount, traType, traDiscountValue, traDiscountType
19/03/2025 22:10:15.1810  2085 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