14/04/2025 12:54:42.9013 11134 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 5 14/04/2025 12:54:42.9033 11130 ms. OPEN: show columns from tabParameters where Field = 'parUseCulture' 14/04/2025 12:54:42.9063 11135 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 2 14/04/2025 12:54:42.9063 11136 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 2 14/04/2025 12:54:42.9084 11141 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 5 14/04/2025 12:54:42.9084 11141 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 3 14/04/2025 12:54:42.9114 11142 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 2 14/04/2025 12:54:42.9114 11146 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 1 14/04/2025 12:54:42.9124 11146 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 5 14/04/2025 12:54:42.9134 11145 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 1 14/04/2025 12:54:42.9134 11143 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 2 14/04/2025 12:54:42.9134 11145 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 1 14/04/2025 12:54:42.9164 11150 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 2 14/04/2025 12:54:42.9184 11148 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 5 14/04/2025 12:54:42.9184 11151 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 3 14/04/2025 12:54:42.9194 11145 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 3 14/04/2025 12:54:42.9194 11148 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 5 14/04/2025 12:54:42.9204 12904 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 7 14/04/2025 12:54:42.9224 11132 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 3 14/04/2025 12:54:42.9234 11151 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 5 14/04/2025 12:54:42.9234 11151 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 3 14/04/2025 12:54:42.9264 11138 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 3 (WAIT TIME 17 ms.) 14/04/2025 12:54:42.9384 25079 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 6 14/04/2025 12:54:43.8620 607 ms. OPEN: show columns from movLinks where Field = 'mliReceiptMessage' 14/04/2025 12:54:44.5344 513 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 3 and terStatus='V' 14/04/2025 12:54:44.5434 543 ms. EXECSCALAR: select count(*) from tabTerminalExtraMem where extStatus='V' and extTerId = 16 nr: 1 14/04/2025 12:54:44.5494 530 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 3 and terStatus='V' 14/04/2025 12:54:44.8486 631 ms. OPEN: select * from tabTicketType where ticStatus='V' and ticOption='S' order by ticType,ticId 14/04/2025 12:54:44.8506 645 ms. OPEN: select * from tabTicketType where ticStatus='V' and ticOption='S' order by ticType,ticId 14/04/2025 12:54:58.9453 11969 ms. OPEN: SELECT * FROM movLinks INNER JOIN movTransit on traUID = mliTraUID WHERE mliRFIDCode = '457594623700327001031999' AND mliStatus='V' ORDER BY mliId DESC LIMIT 1 14/04/2025 12:54:59.3746 15562 ms. OPEN: SELECT traCode FROM movTransit WHERE traId = '906450' and traDirection='I' order by traId DESC LIMIT 1 14/04/2025 12:55:01.3499 1036 ms. OPEN: select * from tabUserMessage where useMesDescr = 'err_ticketnotfound' and (useLanCode = 'en-US' or mid(useLanCode,1,2) = 'en') 14/04/2025 12:55:02.7208 17775 ms. EXECSCALAR: SELECT count(*) FROM payinventory WHERE invValue<>0 AND invType='' nr: 0 14/04/2025 12:55:04.1467 1036 ms. OPEN: select * from tabcustomer inner join abbsubscriptions on subCusId = cusId inner join abbcards on subId = carSubId where carId = 0 14/04/2025 12:55:04.8842 2420 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-14 12:55:02','V',5560413552711270,2025,'2025-04-14 12:50:37','457594623700327001031999',1,2,1,'I','',1,0,1,'','',4) 14/04/2025 12:55:05.3966 1224 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 = '457594285600327005012999' and traStatus='V' and casStatus='V' and terType=3 and casTotAmount>0 14/04/2025 12:55:06.8225 1925 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 14/04/2025 12:55:09.2531 3854 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 = '457594285600327005012999' AND traStatus='V' AND payStatus='V' and (terType IS NULL OR terType<>3 OR (terType=3 and payType='P')) 14/04/2025 12:55:10.0937 7090 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 14/04/2025 12:55:12.8095 2715 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); 14/04/2025 12:55:13.6841 829 ms. EXEC: UPDATE payInventory SET invType='N' WHERE invType<>'N' AND invValue IN (100,200,500) AND invDevice IN (42102,42101,42001); 14/04/2025 13:00:49.3568 721 ms. EXECSCALAR: select count(payId) from paypayment where payStatus='V' and payIdTerminal = 17 and payDateTime = '2025-04-14 12:59:19' nr: 0 14/04/2025 13:03:33.2804 3017 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 14/04/2025 13:08:01.0367 2205 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 14/04/2025 13:15:08.5039 1894 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 14/04/2025 13:15:23.5447 972 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 14/04/2025 13:18:13.6318 2191 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 14/04/2025 13:30:23.5301 821 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2025-04-14 13:30:22',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'; 14/04/2025 13:39:03.5119 6899 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 14/04/2025 13:39:03.5129 14899 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 14/04/2025 13:45:42.8962 505 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 14/04/2025 15:16:10.9389 27490 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 6 14/04/2025 15:16:10.9779 27496 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 4 (WAIT TIME 39 ms.) 14/04/2025 15:16:10.9789 27496 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 6 (WAIT TIME 39 ms.) 14/04/2025 15:16:10.9799 10176 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 4 (WAIT TIME 39 ms.) 14/04/2025 15:16:11.0429 30320 ms. OPEN: show columns from tabParameters where Field = 'parAllowNegativePlaces' 14/04/2025 15:16:13.4478 1978 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 14/04/2025 15:16:13.4508 1952 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 14/04/2025 15:16:13.7620 841 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-14 14:16:12') OR resConfirmed IN (4,5)) and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) <= '2025-04-14 15:16:11' and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) >= '2025-04-14 15:16:11' and (resAreId = 1 or resAreId <= 0) nr: 0 14/04/2025 15:16:13.7630 1106 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-14 14:16:12') OR resConfirmed IN (4,5)) and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) <= '2025-04-14 15:16:11' and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) >= '2025-04-14 15:16:11' and (resAreId = 1 or resAreId <= 0) nr: 0 14/04/2025 15:16:13.7640 1110 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-14 14:16:12') OR resConfirmed IN (4,5)) and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) <= '2025-04-14 15:16:11' and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) >= '2025-04-14 15:16:11' and (resAreId = 1 or resAreId <= 0) nr: 0 14/04/2025 15:16:13.7650 1109 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-14 14:16:12') OR resConfirmed IN (4,5)) and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) <= '2025-04-14 15:16:11' and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) >= '2025-04-14 15:16:11' and (resAreId = 1 or resAreId <= 0) nr: 0 (WAIT TIME 1 ms.) 14/04/2025 15:16:13.7670 1113 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-14 14:16:12') OR resConfirmed IN (4,5)) and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) <= '2025-04-14 15:16:11' and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) >= '2025-04-14 15:16:11' and (resAreId = 1 or resAreId <= 0) nr: 0 14/04/2025 15:16:13.7700 1112 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-14 14:16:12') OR resConfirmed IN (4,5)) and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) <= '2025-04-14 15:16:11' and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) >= '2025-04-14 15:16:11' and (resAreId = 1 or resAreId <= 0) nr: 0 (WAIT TIME 4 ms.) 14/04/2025 15:16:13.7740 843 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-14 14:16:12') OR resConfirmed IN (4,5)) and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) <= '2025-04-14 15:16:11' and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) >= '2025-04-14 15:16:11' and (resAreId = 1 or resAreId <= 0) nr: 0 (WAIT TIME 8 ms.) 14/04/2025 15:16:19.9582 7489 ms. EXECSCALAR: SELECT count(*) FROM payinventory WHERE invValue<>0 AND invType='' nr: 0 14/04/2025 15:16:21.4663 6518 ms. OPEN: SELECT * FROM movLinks INNER JOIN movTransit on traUID = mliTraUID WHERE mliRFIDCode = '457595481800327005031999' AND mliStatus='V' ORDER BY mliId DESC LIMIT 1 14/04/2025 15:16:24.1931 4034 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 14/04/2025 15:16:24.3514 1525 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-14 15:16:22','V',4937201840796940,2025,'2025-04-14 15:13:38','457595481800327005031999',1,2,16,'I','',1,0,1,'','',4) 14/04/2025 15:16:25.3350 972 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 14/04/2025 15:16:25.8013 1607 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); 14/04/2025 15:16:34.4016 841 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-14 15:16:33','V',4631494842400370,2025,'2025-04-14 15:13:55','457595483500327005031999',1,2,16,'I','',1,0,1,'','',4) 14/04/2025 15:16:58.3772 2418 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 = '457594936200327005012999' AND traStatus='V' AND payStatus='V' and (terType IS NULL OR terType<>3 OR (terType=3 and payType='P')) 14/04/2025 15:17:25.8775 26649 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 14/04/2025 15:24:45.1704 3875 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 14/04/2025 16:10:58.0750 855 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 14/04/2025 16:15:01.4268 1129 ms. OPEN: select traId,traDateTime,traEnabled,traDisableTime,traCode,traBadge,traCarId,traAreId,traIdTerminal from movtransit where traStatus='V' and traDirection = 'I' and traCarId = 8 order by traDateTime desc,traId desc 14/04/2025 16:25:25.3570 727 ms. OPEN: select traId,traDateTime,traEnabled,traDisableTime,traCode,traBadge,traCarId,traAreId,traIdTerminal from movtransit where traStatus='V' and traDirection = 'I' and traCarId = 20 order by traDateTime desc,traId desc 14/04/2025 16:33:50.9794 1550 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 14/04/2025 16:42:15.9742 1574 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