18/04/2025 05:20:23.5855 1608 ms. OPEN: select * from tablanguages where lanStatus='V' order by lannumber limit 1 18/04/2025 05:20:23.5865 1611 ms. OPEN: show columns from tabParameters where Field = 'parAllowNegativePlaces' 18/04/2025 05:20:24.3070 516 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 18/04/2025 05:20:24.3080 506 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 18/04/2025 05:20:24.3090 511 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 18/04/2025 05:20:24.3100 511 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 18/04/2025 05:20:24.3110 515 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 18/04/2025 05:20:24.3110 513 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 18/04/2025 05:20:24.3130 514 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 18/04/2025 05:20:24.3140 517 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 18/04/2025 05:20:24.3160 523 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 18/04/2025 05:20:24.3160 523 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 18/04/2025 05:20:24.3170 520 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 18/04/2025 05:20:24.3180 521 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 18/04/2025 05:20:24.3180 522 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 18/04/2025 05:20:24.3190 521 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 18/04/2025 05:20:24.3200 527 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 18/04/2025 05:20:24.3210 530 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 18/04/2025 05:20:24.3240 523 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 18/04/2025 05:20:24.3260 528 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 18/04/2025 05:20:26.5415 569 ms. EXECSCALAR: select count(resId) as Tot from movReservation where resStatus = 'V' and resTypeRes = 'B' AND ((resConfirmed IN (0,2,3) AND resCreation>'2025-04-18 04:20:25') OR resConfirmed IN (4,5)) and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) <= '2025-04-18 05:20:25' and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) >= '2025-04-18 05:20:25' and (resAreId = 1 or resAreId <= 0) nr: 0 18/04/2025 05:20:26.5415 570 ms. EXECSCALAR: select count(resId) as Tot from movReservation where resStatus = 'V' and resTypeRes = 'B' AND ((resConfirmed IN (0,2,3) AND resCreation>'2025-04-18 04:20:25') OR resConfirmed IN (4,5)) and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) <= '2025-04-18 05:20:25' and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) >= '2025-04-18 05:20:25' and (resAreId = 1 or resAreId <= 0) nr: 0 18/04/2025 05:20:26.5455 568 ms. EXECSCALAR: select count(resId) as Tot from movReservation where resStatus = 'V' and resTypeRes = 'B' AND ((resConfirmed IN (0,2,3) AND resCreation>'2025-04-18 04:20:25') OR resConfirmed IN (4,5)) and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) <= '2025-04-18 05:20:25' and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) >= '2025-04-18 05:20:25' and (resAreId = 1 or resAreId <= 0) nr: 0 (WAIT TIME 2 ms.) 18/04/2025 05:20:26.5455 571 ms. EXECSCALAR: select count(resId) as Tot from movReservation where resStatus = 'V' and resTypeRes = 'B' AND ((resConfirmed IN (0,2,3) AND resCreation>'2025-04-18 04:20:25') OR resConfirmed IN (4,5)) and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) <= '2025-04-18 05:20:25' and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) >= '2025-04-18 05:20:25' and (resAreId = 1 or resAreId <= 0) nr: 0 18/04/2025 05:20:26.5485 567 ms. EXECSCALAR: select count(resId) as Tot from movReservation where resStatus = 'V' and resTypeRes = 'B' AND ((resConfirmed IN (0,2,3) AND resCreation>'2025-04-18 04:20:25') OR resConfirmed IN (4,5)) and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) <= '2025-04-18 05:20:25' and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) >= '2025-04-18 05:20:25' and (resAreId = 1 or resAreId <= 0) nr: 0 (WAIT TIME 5 ms.) 18/04/2025 05:20:26.5495 571 ms. EXECSCALAR: select count(resId) as Tot from movReservation where resStatus = 'V' and resTypeRes = 'B' AND ((resConfirmed IN (0,2,3) AND resCreation>'2025-04-18 04:20:25') OR resConfirmed IN (4,5)) and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) <= '2025-04-18 05:20:25' and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) >= '2025-04-18 05:20:25' and (resAreId = 1 or resAreId <= 0) nr: 0 (WAIT TIME 6 ms.) 18/04/2025 05:20:30.7784 6507 ms. EXECSCALAR: SELECT count(*) FROM payinventory WHERE invValue<>0 AND invType='' nr: 0 18/04/2025 05:20:34.6987 3716 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 18/04/2025 05:20:36.4709 1772 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); 18/04/2025 05:20:45.9879 1400 ms. OPEN: select traCode from movTransit where traCode ='457631924400327005012999' 18/04/2025 05:20:47.6701 618 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 = '457631924400327005012999' AND traStatus='V' AND payStatus='V' and (terType IS NULL OR terType<>3 OR (terType=3 and payType='P')) 18/04/2025 06:07:28.4220 686 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 18/04/2025 07:49:39.2454 806 ms. OPEN: select traId,traDateTime,traEnabled,traDisableTime,traCode,traBadge,traCarId,traAreId,traIdTerminal from movtransit where traStatus='V' and traDirection = 'I' and traCarId = 164 order by traDateTime desc,traId desc 18/04/2025 08:59:49.8001 513 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-04-18 08:59:49','V',4726249325729040,2025,'2025-04-18 08:59:48','457633238800327005012999',1,2,16,'I','',1,0,1,'','',4) 18/04/2025 09:17:43.7028 2875 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 18/04/2025 10:41:54.8465 1519 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 18/04/2025 10:58:10.7719 525 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-04-18 10:58:10','V',5233399497520270,2025,'2025-04-18 10:58:10','457633949000327005012999',1,2,16,'I','',1,0,1,'','',4) 18/04/2025 10:58:35.0614 11322 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 18/04/2025 11:36:49.0757 535 ms. EXEC: update payReceipt set recCreation = '2025-04-18 11:36:48',recModify = '2025-04-18 11:36:48',recUseId=0,recStatus='V' where recId = 371703 18/04/2025 11:45:35.6962 858 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 18/04/2025 12:21:29.1960 744 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 18/04/2025 19:14:41.1229 3046 ms. OPEN: select count(payId) as Tot,0 as payUID,sum(payPayed) as payPayed,sum(payChange) as payChange,payAmount,traUIDGroup,traType,traClass,traIdTerminal,traDiscountValue,traDiscountType,traCarId,payIdEvent,payType,payCardType from payPayment LEFT join movtransit on trauid = payTraUID LEFT JOIN payReport ON repPayUID = payUID AND repStatus='V' where payStatus = 'V' and (payType='C' or payType='P') and payUseId = 1 and payIdEvent<90 and repPayUID IS NULL and (traCarId is null or traCarId=0 or traCarId in (select carId from abbCards inner join abbsubscriptions on subId= carSubId where carStatus='V' and subStatus='V' and subAbbType<>5)) group by traUIDGroup,payAmount,payIdEvent,payType,payCardType,traType,traIdTerminal,traDiscountValue,traDiscountType,traCarId order by traUIDGroup,payAmount, traType, traDiscountValue, traDiscountType