12/01/2025 04:32:41.7967 23173 ms. OPEN: show columns from tabParameters where Field = 'parAllowNegativePlaces' 12/01/2025 04:32:43.4009 1045 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 3 and terStatus='V' 12/01/2025 04:32:43.4039 1052 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 3 and terStatus='V' 12/01/2025 04:32:43.4059 1048 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 3 and terStatus='V' (WAIT TIME 4 ms.) 12/01/2025 04:32:43.9062 952 ms. EXECSCALAR: select count(*) from tabTerminalExtraMem where extStatus='V' and extTerId = 1 nr: 0 12/01/2025 04:32:44.3755 1419 ms. EXECSCALAR: select count(*) from tabTerminalExtraMem where extStatus='V' and extTerId = 2 nr: 0 12/01/2025 04:32:44.3765 1419 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 1 and terStatus='V' 12/01/2025 04:32:44.3775 1420 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 2 and terStatus='V' 12/01/2025 04:32:44.3795 1424 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 1 and terStatus='V' 12/01/2025 04:32:44.3835 1427 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 5 and terStatus='V' 12/01/2025 04:32:44.3955 947 ms. OPEN: select * from tabTicketType where ticStatus='V' and ticOption='S' order by ticType,ticId 12/01/2025 04:32:45.5163 680 ms. EXECSCALAR: select count(*) from tabTerminalExtraMem where extStatus='V' and extTerId = 2 nr: 3 12/01/2025 04:32:45.5173 854 ms. EXECSCALAR: select min(extId) from tabTerminalExtraMem where extTerId = 2 nr: 5 12/01/2025 04:32:45.5173 853 ms. EXECSCALAR: select min(extId) from tabTerminalExtraMem where extTerId = 2 nr: 5 12/01/2025 04:32:46.8071 886 ms. EXECSCALAR: select count(resId) as Tot from movReservation where resStatus = 'V' and resTypeRes = 'B' AND ((resConfirmed IN (0,2,3) AND resCreation>'2025-01-12 03:32:45') OR resConfirmed IN (4,5)) and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) <= '2025-01-12 04:32:43' and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) >= '2025-01-12 04:32:43' and (resAreId = 1 or resAreId <= 0) nr: 0 12/01/2025 04:32:46.8081 880 ms. EXECSCALAR: select count(resId) as Tot from movReservation where resStatus = 'V' and resTypeRes = 'B' AND ((resConfirmed IN (0,2,3) AND resCreation>'2025-01-12 03:32:45') OR resConfirmed IN (4,5)) and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) <= '2025-01-12 04:32:44' and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) >= '2025-01-12 04:32:44' and (resAreId = 1 or resAreId <= 0) nr: 0 12/01/2025 04:32:46.8081 882 ms. EXECSCALAR: select count(resId) as Tot from movReservation where resStatus = 'V' and resTypeRes = 'B' AND ((resConfirmed IN (0,2,3) AND resCreation>'2025-01-12 03:32:45') OR resConfirmed IN (4,5)) and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) <= '2025-01-12 04:32:44' and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) >= '2025-01-12 04:32:44' and (resAreId = 1 or resAreId <= 0) nr: 0 12/01/2025 04:32:46.8101 883 ms. EXECSCALAR: select count(resId) as Tot from movReservation where resStatus = 'V' and resTypeRes = 'B' AND ((resConfirmed IN (0,2,3) AND resCreation>'2025-01-12 03:32:45') OR resConfirmed IN (4,5)) and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) <= '2025-01-12 04:32:44' and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) >= '2025-01-12 04:32:44' and (resAreId = 1 or resAreId <= 0) nr: 0 12/01/2025 04:32:46.8121 887 ms. EXECSCALAR: select count(resId) as Tot from movReservation where resStatus = 'V' and resTypeRes = 'B' AND ((resConfirmed IN (0,2,3) AND resCreation>'2025-01-12 03:32:45') OR resConfirmed IN (4,5)) and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) <= '2025-01-12 04:32:44' and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) >= '2025-01-12 04:32:44' and (resAreId = 1 or resAreId <= 0) nr: 0 12/01/2025 04:32:46.8131 891 ms. EXECSCALAR: select count(resId) as Tot from movReservation where resStatus = 'V' and resTypeRes = 'B' AND ((resConfirmed IN (0,2,3) AND resCreation>'2025-01-12 03:32:45') OR resConfirmed IN (4,5)) and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) <= '2025-01-12 04:32:44' and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) >= '2025-01-12 04:32:44' and (resAreId = 1 or resAreId <= 0) nr: 0 12/01/2025 04:32:46.8151 891 ms. EXECSCALAR: select count(resId) as Tot from movReservation where resStatus = 'V' and resTypeRes = 'B' AND ((resConfirmed IN (0,2,3) AND resCreation>'2025-01-12 03:32:45') OR resConfirmed IN (4,5)) and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) <= '2025-01-12 04:32:44' and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) >= '2025-01-12 04:32:44' and (resAreId = 1 or resAreId <= 0) nr: 0 12/01/2025 04:32:46.8151 892 ms. EXECSCALAR: select count(resId) as Tot from movReservation where resStatus = 'V' and resTypeRes = 'B' AND ((resConfirmed IN (0,2,3) AND resCreation>'2025-01-12 03:32:45') OR resConfirmed IN (4,5)) and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) <= '2025-01-12 04:32:44' and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) >= '2025-01-12 04:32:44' and (resAreId = 1 or resAreId <= 0) nr: 0 12/01/2025 04:32:46.8211 888 ms. EXECSCALAR: select count(resId) as Tot from movReservation where resStatus = 'V' and resTypeRes = 'B' AND ((resConfirmed IN (0,2,3) AND resCreation>'2025-01-12 03:32:45') OR resConfirmed IN (4,5)) and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) <= '2025-01-12 04:32:44' and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) >= '2025-01-12 04:32:44' and (resAreId = 1 or resAreId <= 0) nr: 0 (WAIT TIME 8 ms.) 12/01/2025 04:32:46.8241 890 ms. EXECSCALAR: select count(resId) as Tot from movReservation where resStatus = 'V' and resTypeRes = 'B' AND ((resConfirmed IN (0,2,3) AND resCreation>'2025-01-12 03:32:45') OR resConfirmed IN (4,5)) and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) <= '2025-01-12 04:32:43' and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) >= '2025-01-12 04:32:43' and (resAreId = 1 or resAreId <= 0) nr: 0 (WAIT TIME 8 ms.) 12/01/2025 04:32:46.8312 894 ms. EXECSCALAR: select count(resId) as Tot from movReservation where resStatus = 'V' and resTypeRes = 'B' AND ((resConfirmed IN (0,2,3) AND resCreation>'2025-01-12 03:32:45') OR resConfirmed IN (4,5)) and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) <= '2025-01-12 04:32:44' and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) >= '2025-01-12 04:32:44' and (resAreId = 1 or resAreId <= 0) nr: 0 (WAIT TIME 15 ms.) 12/01/2025 04:32:59.2375 11084 ms. OPEN: SELECT * FROM movLinks INNER JOIN movTransit on traUID = mliTraUID WHERE mliRFIDCode = '456671628500327005031999' AND mliStatus='V' ORDER BY mliId DESC LIMIT 1 12/01/2025 04:33:00.5283 15873 ms. EXECSCALAR: SELECT count(*) FROM payinventory WHERE invValue<>0 AND invType='' nr: 0 12/01/2025 04:33:00.9026 818 ms. OPEN: select * from tabUserMessage where useMesDescr = 'err_ticketnotfound' and (useLanCode = 'en-US' or mid(useLanCode,1,2) = 'en') 12/01/2025 04:33:04.0817 2166 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-01-12 04:33:01','V',4767401862419490,2025,'2025-01-12 04:31:25','456671628500327005031999',1,2,16,'I','',1,0,1,'','',4) 12/01/2025 04:33:05.5228 1430 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 12/01/2025 04:33:06.0432 5194 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 12/01/2025 04:33:09.2515 3207 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/01/2025 04:35:05.5122 653 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 = '456670000100327003229999' AND traStatus='V' AND payStatus='V' and (terType IS NULL OR terType<>3 OR (terType=3 and payType='P')) 12/01/2025 04:43:24.1086 25326 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 12/01/2025 08:55:03.0888 658 ms. OPEN: select traId,traDateTime,traEnabled,traDisableTime,traCode,traBadge,traCarId,traAreId,traIdTerminal from movtransit where traStatus='V' and traDirection = 'I' and traCarId = 125 order by traDateTime desc,traId desc 12/01/2025 08:55:44.7785 1938 ms. OPEN: select traId,traDateTime,traEnabled,traDisableTime,traCode,traBadge,traCarId,traAreId,traIdTerminal from movtransit where traStatus='V' and traDirection = 'I' and traCarId = 44 order by traDateTime desc,traId desc 12/01/2025 09:39:54.6985 622 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2025-01-12 09:39:53',3,42101,0,100,1,100,1,'I','N'); update payCurInventory set curQuantity=round(curQuantity+1,5),curAmount=round(curAmount+100,5) where curTerId = 3 and curDevCode = 42101 and curChannelId = 1 and curValue = 100 and curType = 'N'; 12/01/2025 10:52:51.2992 1279 ms. OPEN: select traId,traDateTime,traEnabled,traDisableTime,traCode,traBadge,traCarId,traAreId,traIdTerminal from movtransit where traStatus='V' and traDirection = 'I' and traCarId = 25 order by traDateTime desc,traId desc 12/01/2025 10:56:22.5118 1225 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/01/2025 10:58:35.5102 1312 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/01/2025 11:04:15.7161 550 ms. EXEC: update payInventory set invCreation = '2025-01-12 11:04:15',invModify = '2025-01-12 11:04:15',invUseId=0,invStatus='V' where invId = 230838 12/01/2025 12:12:22.7891 641 ms. OPEN: select traId,traDateTime,traEnabled,traDisableTime,traCode,traBadge,traCarId,traAreId,traIdTerminal from movtransit where traStatus='V' and traDirection = 'I' and traCarId = 99 order by traDateTime desc,traId desc 12/01/2025 12:44:36.5510 2974 ms. OPEN: select count(payId) as Tot,0 as payUID,sum(payPayed) as payPayed,sum(payChange) as payChange,payAmount,traUIDGroup,traType,traClass,traIdTerminal,traDiscountValue,traDiscountType,traCarId,payIdEvent,payType,payCardType from payPayment LEFT join movtransit on trauid = payTraUID LEFT JOIN payReport ON repPayUID = payUID AND repStatus='V' where payStatus = 'V' and (payType='C' or payType='P') and payUseId = 6 and payIdEvent<90 and repPayUID IS NULL and (traCarId is null or traCarId=0 or traCarId in (select carId from abbCards inner join abbsubscriptions on subId= carSubId where carStatus='V' and subStatus='V' and subAbbType<>5)) group by traUIDGroup,payAmount,payIdEvent,payType,payCardType,traType,traIdTerminal,traDiscountValue,traDiscountType,traCarId order by traUIDGroup,payAmount, traType, traDiscountValue, traDiscountType 12/01/2025 13:00:18.8910 591 ms. EXEC: update payReceipt set recCreation = '2025-01-12 13:00:18',recModify = '2025-01-12 13:00:18',recUseId=0,recStatus='V' where recId = 341614 12/01/2025 15:44:41.4938 567 ms. OPEN: select count(payId) as Tot,0 as payUID,sum(payPayed) as payPayed,sum(payChange) as payChange,payAmount,traUIDGroup,traType,traClass,traIdTerminal,traDiscountValue,traDiscountType,traCarId,payIdEvent,payType,payCardType from payPayment LEFT join movtransit on trauid = payTraUID LEFT JOIN payReport ON repPayUID = payUID AND repStatus='V' where payStatus = 'V' and (payType='C' or payType='P') and payUseId = 6 and payIdEvent<90 and repPayUID IS NULL and (traCarId is null or traCarId=0 or traCarId in (select carId from abbCards inner join abbsubscriptions on subId= carSubId where carStatus='V' and subStatus='V' and subAbbType<>5)) group by traUIDGroup,payAmount,payIdEvent,payType,payCardType,traType,traIdTerminal,traDiscountValue,traDiscountType,traCarId order by traUIDGroup,payAmount, traType, traDiscountValue, traDiscountType 12/01/2025 16:43:45.8336 629 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2025-01-12 16:43:45' where traUID = 4968501836215530 and traStatus='V' and traEnabled=1 12/01/2025 17:06:35.3296 549 ms. EXEC: update opeActivities set acvFstPayId = (case acvFstPayId when 0 then 393554 else acvFstPayId end),acvLstPayId = 393554 where acvSftId = 885 and acvCodeId = 3 12/01/2025 19:14:34.1548 612 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/01/2025 19:52:07.1178 1001 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