09/04/2025 05:13:25.1165 2998 ms. OPEN: show columns from tabParameters where Field = 'parAllowNegativePlaces' 09/04/2025 05:38:57.3223 690 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 09/04/2025 05:39:41.1756 793 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 09/04/2025 05:51:45.4584 817 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 09/04/2025 05:53:05.3014 508 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2025-04-09 05:53:04',3,42101,0,100,1,100,1,'I','N'); update payCurInventory set curQuantity=round(curQuantity+1,5),curAmount=round(curAmount+100,5) where curTerId = 3 and curDevCode = 42101 and curChannelId = 1 and curValue = 100 and curType = 'N'; 09/04/2025 05:59:08.0740 1315 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 09/04/2025 06:02:02.4968 1208 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 09/04/2025 06:02:50.7380 556 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 3 OR lnsTerId=3) 09/04/2025 17:10:57.7685 30459 ms. OPEN: show columns from tabParameters where Field = 'parAllowNegativePlaces' 09/04/2025 17:10:58.7092 507 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 09/04/2025 17:10:58.7092 512 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 09/04/2025 17:10:58.7102 511 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 09/04/2025 17:10:58.7112 503 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 09/04/2025 17:10:58.7112 514 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 09/04/2025 17:10:58.7132 514 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 09/04/2025 17:10:58.8613 664 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 09/04/2025 17:10:58.8623 661 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 09/04/2025 17:10:58.8633 652 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 09/04/2025 17:10:58.8683 661 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 09/04/2025 17:10:58.8743 677 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 09/04/2025 17:10:59.4757 766 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 3 OR lnsTerId=3) 09/04/2025 17:10:59.4767 613 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 2 OR lnsTerId=2) 09/04/2025 17:10:59.4787 954 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 3 OR lnsTerId=3) 09/04/2025 17:10:59.4837 620 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 3 OR lnsTerId=3) 09/04/2025 17:10:59.4837 609 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 16 OR lnsTerId=16) 09/04/2025 17:10:59.4847 771 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 16 OR lnsTerId=16) 09/04/2025 17:10:59.4847 962 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 2 OR lnsTerId=2) 09/04/2025 17:10:59.4847 772 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 16 OR lnsTerId=16) 09/04/2025 17:10:59.4857 775 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 2 OR lnsTerId=2) 09/04/2025 17:10:59.4857 962 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 16 OR lnsTerId=16) 09/04/2025 17:10:59.4867 776 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 2 OR lnsTerId=2) 09/04/2025 17:10:59.4887 779 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 2 OR lnsTerId=2) 09/04/2025 17:10:59.4887 962 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 2 ms.) 09/04/2025 17:10:59.4887 777 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 3 OR lnsTerId=3) 09/04/2025 17:10:59.4897 779 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 16 OR lnsTerId=16) 09/04/2025 17:10:59.4897 618 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 3 ms.) 09/04/2025 17:10:59.4897 625 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 1 ms.) 09/04/2025 17:11:01.1200 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-04-09 16:11:00') OR resConfirmed IN (4,5)) and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) <= '2025-04-09 17:10:59' and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) >= '2025-04-09 17:10:59' and (resAreId = 1 or resAreId <= 0) nr: 0 09/04/2025 17:11:01.1200 501 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-09 16:11:00') OR resConfirmed IN (4,5)) and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) <= '2025-04-09 17:10:59' and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) >= '2025-04-09 17:10:59' and (resAreId = 1 or resAreId <= 0) nr: 0 09/04/2025 17:11:01.1390 521 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-09 16:11:00') OR resConfirmed IN (4,5)) and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) <= '2025-04-09 17:11:00' and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) >= '2025-04-09 17:11:00' and (resAreId = 1 or resAreId <= 0) nr: 0 09/04/2025 17:11:01.1400 522 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-09 16:11:00') OR resConfirmed IN (4,5)) and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) <= '2025-04-09 17:10:59' and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) >= '2025-04-09 17:10:59' and (resAreId = 1 or resAreId <= 0) nr: 0 09/04/2025 17:11:01.1440 520 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-09 16:11:00') OR resConfirmed IN (4,5)) and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) <= '2025-04-09 17:11:00' and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) >= '2025-04-09 17:11:00' and (resAreId = 1 or resAreId <= 0) nr: 0 (WAIT TIME 5 ms.) 09/04/2025 17:11:06.2181 6700 ms. EXECSCALAR: SELECT count(*) FROM payinventory WHERE invValue<>0 AND invType='' nr: 0 09/04/2025 17:11:09.9966 3698 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 09/04/2025 17:11:12.1490 2151 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); 09/04/2025 17:12:25.9705 1168 ms. OPEN: select max(traCode) as vCode from movTransit where traCode >='45754 ' and traCode < '45755 ' and traType = 22 09/04/2025 17:12:27.6466 638 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 = '457540000500327003229999' AND traStatus='V' AND payStatus='V' and (terType IS NULL OR terType<>3 OR (terType=3 and payType='P')) 09/04/2025 17:22:08.4799 1858 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 09/04/2025 17:27:42.6331 1579 ms. OPEN: select traId,traDateTime,traEnabled,traDisableTime,traCode,traBadge,traCarId,traAreId,traIdTerminal from movtransit where traStatus='V' and traDirection = 'I' and traCarId = 82 order by traDateTime desc,traId desc 09/04/2025 17:32:17.6922 1135 ms. OPEN: select traId,traDateTime,traEnabled,traDisableTime,traCode,traBadge,traCarId,traAreId,traIdTerminal from movtransit where traStatus='V' and traDirection = 'I' and traCarId = 103 order by traDateTime desc,traId desc 09/04/2025 17:35:15.0818 2121 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 09/04/2025 17:37:37.0599 16107 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 09/04/2025 17:38:39.2392 519 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