20/08/2025 06:57:35.2517 691 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 20/08/2025 07:48:38.8380 1133 ms. OPEN: select traId,traDateTime,traEnabled,traDisableTime,traCode,traBadge,traCarId,traAreId,traIdTerminal from movtransit where traStatus='V' and traDirection = 'I' and traCarId = 31 order by traDateTime desc,traId desc 20/08/2025 08:00:31.9911 847 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 20/08/2025 09:01:49.8392 579 ms. OPEN: select traId,traDateTime,traEnabled,traDisableTime,traCode,traBadge,traCarId,traAreId,traIdTerminal from movtransit where traStatus='V' and traDirection = 'I' and traCarId = 30 order by traDateTime desc,traId desc 20/08/2025 21:23:55.2445 2501 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 2 20/08/2025 21:23:55.3425 2310 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 1 (WAIT TIME 97 ms.) 20/08/2025 21:23:55.3425 697 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 3 (WAIT TIME 96 ms.) 20/08/2025 21:23:55.3435 2447 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 1 (WAIT TIME 94 ms.) 20/08/2025 21:23:55.3435 2116 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 5 (WAIT TIME 93 ms.) 20/08/2025 21:23:55.3455 540 ms. EXECSCALAR: select count(0) as vTot from tabParameters where parPlateReading<>0 nr: 0 (WAIT TIME 90 ms.) 20/08/2025 21:23:55.3475 2191 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 5 (WAIT TIME 91 ms.) 20/08/2025 21:23:55.3475 1917 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 3 (WAIT TIME 90 ms.) 20/08/2025 21:23:55.3475 1961 ms. OPEN: show columns from tabParameters where Field = 'parVatShowMode' (WAIT TIME 89 ms.) 20/08/2025 21:23:55.3485 791 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 2 (WAIT TIME 89 ms.) 20/08/2025 21:23:55.3485 782 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 5 (WAIT TIME 88 ms.) 20/08/2025 21:23:55.3576 2561 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 3 (WAIT TIME 94 ms.) 20/08/2025 21:23:55.3616 2436 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 5 (WAIT TIME 112 ms.) 20/08/2025 21:23:55.3626 2133 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 2 (WAIT TIME 115 ms.) 20/08/2025 21:23:55.3636 2482 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 2 (WAIT TIME 118 ms.) 20/08/2025 21:23:55.3646 2002 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 3 (WAIT TIME 118 ms.) 20/08/2025 21:23:55.3656 2129 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 1 (WAIT TIME 106 ms.) 20/08/2025 21:23:55.3666 2619 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 5 (WAIT TIME 105 ms.) 20/08/2025 21:23:55.4036 2591 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 1 (WAIT TIME 45 ms.) 20/08/2025 21:23:57.1257 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-08-20 20.23.56') OR resConfirmed IN (4,5)) and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) <= '2025-08-20 21.23.55' and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) >= '2025-08-20 21.23.55' and (resAreId = 1 or resAreId <= 0) nr: 0 20/08/2025 21:23:57.1297 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-08-20 20.23.56') OR resConfirmed IN (4,5)) and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) <= '2025-08-20 21.23.55' and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) >= '2025-08-20 21.23.55' and (resAreId = 1 or resAreId <= 0) nr: 0 20/08/2025 21:23:57.1297 504 ms. EXECSCALAR: select count(resId) as Tot from movReservation where resStatus = 'V' and resTypeRes = 'B' AND ((resConfirmed IN (0,2,3) AND resCreation>'2025-08-20 20.23.56') OR resConfirmed IN (4,5)) and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) <= '2025-08-20 21.23.55' and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) >= '2025-08-20 21.23.55' and (resAreId = 1 or resAreId <= 0) nr: 0 20/08/2025 21:23:57.1347 506 ms. EXECSCALAR: select count(resId) as Tot from movReservation where resStatus = 'V' and resTypeRes = 'B' AND ((resConfirmed IN (0,2,3) AND resCreation>'2025-08-20 20.23.56') OR resConfirmed IN (4,5)) and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) <= '2025-08-20 21.23.55' and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) >= '2025-08-20 21.23.55' and (resAreId = 1 or resAreId <= 0) nr: 0 20/08/2025 21:23:57.1377 504 ms. EXECSCALAR: select count(resId) as Tot from movReservation where resStatus = 'V' and resTypeRes = 'B' AND ((resConfirmed IN (0,2,3) AND resCreation>'2025-08-20 20.23.56') OR resConfirmed IN (4,5)) and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) <= '2025-08-20 21.23.55' and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) >= '2025-08-20 21.23.55' and (resAreId = 1 or resAreId <= 0) nr: 0 (WAIT TIME 7 ms.) 20/08/2025 21:23:57.1487 502 ms. EXECSCALAR: select count(resId) as Tot from movReservation where resStatus = 'V' and resTypeRes = 'B' AND ((resConfirmed IN (0,2,3) AND resCreation>'2025-08-20 20.23.56') OR resConfirmed IN (4,5)) and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) <= '2025-08-20 21.23.55' and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) >= '2025-08-20 21.23.55' and (resAreId = 1 or resAreId <= 0) nr: 0 (WAIT TIME 15 ms.) 20/08/2025 21:23:57.1507 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-08-20 20.23.56') OR resConfirmed IN (4,5)) and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) <= '2025-08-20 21.23.55' and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) >= '2025-08-20 21.23.55' and (resAreId = 1 or resAreId <= 0) nr: 0 (WAIT TIME 18 ms.) 20/08/2025 21:24:05.3436 542 ms. OPEN: select * from abbSubscriptions inner join abbCards on subId = carSubId inner join tabCustomer on cusId = subCusId where carStatus = 'V' and subStatus='V' and carCode = '458877102900327005012999' AND subAbbType <> 6 20/08/2025 21:24:06.0931 8083 ms. OPEN: SELECT * FROM movLinks INNER JOIN movTransit on traUID = mliTraUID WHERE mliRFIDCode = '458877679600327005031999' AND mliStatus='V' ORDER BY mliId DESC LIMIT 1 20/08/2025 21:24:06.2472 11714 ms. OPEN: select * from movtransit where trastatus='V' and (traCode = '1006065') and traDirection='I' order by traId desc limit 1 20/08/2025 21:24:06.2482 11729 ms. OPEN: select * from movtransit where trastatus='V' and (traCode = '1005117') and traDirection='I' order by traId desc limit 1 20/08/2025 21:24:06.4133 655 ms. OPEN: select * from tabUserMessage where useMesDescr = 'err_invalidcode' and (useLanCode = 'it-IT' or mid(useLanCode,1,2) = 'it') 20/08/2025 21:24:08.1835 1932 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 = '1005117' and traStatus='V' and casStatus='V' and terType=3 and casTotAmount>0 20/08/2025 21:24:08.1835 1932 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 = '1006065' and traStatus='V' and casStatus='V' and terType=3 and casTotAmount>0 20/08/2025 21:24:08.3136 1817 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 = '458877102900327005012999' and traStatus='V' and casStatus='V' and terType=3 and casTotAmount>0 20/08/2025 21:24:08.6288 1400 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-08-20 21.24.07','V',4865480512766680,2025,'2025-08-20 21.19.56','458877679600327005031999',1,2,16,'I','',1,0,1,'','',4) 20/08/2025 21:24:11.7229 3538 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 = '1005117' AND traStatus='V' AND payStatus='V' and (terType IS NULL OR terType<>3 OR (terType=3 and payType='P')) 20/08/2025 21:24:11.7239 3539 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 = '1006065' AND traStatus='V' AND payStatus='V' and (terType IS NULL OR terType<>3 OR (terType=3 and payType='P')) 20/08/2025 21:24:11.7529 3438 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 = '458877102900327005012999' AND traStatus='V' AND payStatus='V' and (terType IS NULL OR terType<>3 OR (terType=3 and payType='P')) 20/08/2025 21:24:33.6032 922 ms. EXEC: insert into movOperator (opeCreation,opeTerId,opeUseId,opeDateTime,opeCode,opeDescription) VALUES ('2025-08-20 21.24.32',17,12,'2025-08-20 21.24.32','458877102900327005012999','Pagato (Contanti ) Biglietto ') 20/08/2025 21:24:34.4617 606 ms. EXEC: insert into payReceipt (recTraUID,recPayUID,recYear,recDateTime,recText,recInvalid) VALUES (4713499568966560,4900408628143780,2025,'2025-08-20 21.24.33',' Data: 8/20/2025 9:24:26 PM Codice: 458877102900327005012999 Ingresso: 8/20/2025 7:43:49 PM Targa: Categoria: Cars Area: The Mall Varco: Entry 2 ______________________________ Da Pagare: 100.00 EUR ______________________________ Pagato: 100.00 EUR __________ Resto: 0.00 EUR Tipo: Contanti Pagato su: Manual Cashier 2 # 2500606309 ',0) 20/08/2025 21:24:42.7624 29449 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 20/08/2025 21:43:17.4856 1805 ms. OPEN: select traId,traDateTime,traEnabled,traDisableTime,traCode,traBadge,traCarId,traAreId,traIdTerminal from movtransit where traStatus='V' and traDirection = 'I' and traCarId = 66 order by traDateTime desc,traId desc 20/08/2025 22:00:09.2096 4619 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 20/08/2025 22:05:45.5435 2016 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 20/08/2025 22:30:13.7068 1851 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 20/08/2025 23:57:59.9101 742 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 1 20/08/2025 23:57:59.9181 1066 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 5 20/08/2025 23:57:59.9221 593 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 1 (WAIT TIME 11 ms.) 20/08/2025 23:57:59.9261 1821 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 1 (WAIT TIME 10 ms.) 20/08/2025 23:57:59.9531 1008 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 5 20/08/2025 23:58:00.0722 1519 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 1 20/08/2025 23:58:00.0862 1011 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 5 20/08/2025 23:58:02.2430 807 ms. EXECSCALAR: select count(resId) as Tot from movReservation where resStatus = 'V' and resTypeRes = 'B' AND ((resConfirmed IN (0,2,3) AND resCreation>'2025-08-20 22.58.01') OR resConfirmed IN (4,5)) and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) <= '2025-08-20 23.58.00' and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) >= '2025-08-20 23.58.00' and (resAreId = 1 or resAreId <= 0) nr: 0 20/08/2025 23:58:02.2440 809 ms. EXECSCALAR: select count(resId) as Tot from movReservation where resStatus = 'V' and resTypeRes = 'B' AND ((resConfirmed IN (0,2,3) AND resCreation>'2025-08-20 22.58.01') OR resConfirmed IN (4,5)) and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) <= '2025-08-20 23.58.00' and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) >= '2025-08-20 23.58.00' and (resAreId = 1 or resAreId <= 0) nr: 0 20/08/2025 23:58:02.2450 810 ms. EXECSCALAR: select count(resId) as Tot from movReservation where resStatus = 'V' and resTypeRes = 'B' AND ((resConfirmed IN (0,2,3) AND resCreation>'2025-08-20 22.58.01') OR resConfirmed IN (4,5)) and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) <= '2025-08-20 23.58.00' and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) >= '2025-08-20 23.58.00' and (resAreId = 1 or resAreId <= 0) nr: 0 20/08/2025 23:58:02.2490 808 ms. EXECSCALAR: select count(resId) as Tot from movReservation where resStatus = 'V' and resTypeRes = 'B' AND ((resConfirmed IN (0,2,3) AND resCreation>'2025-08-20 22.58.01') OR resConfirmed IN (4,5)) and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) <= '2025-08-20 23.58.00' and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) >= '2025-08-20 23.58.00' and (resAreId = 1 or resAreId <= 0) nr: 0 (WAIT TIME 3 ms.) 20/08/2025 23:58:02.2500 814 ms. EXECSCALAR: select count(resId) as Tot from movReservation where resStatus = 'V' and resTypeRes = 'B' AND ((resConfirmed IN (0,2,3) AND resCreation>'2025-08-20 22.58.01') OR resConfirmed IN (4,5)) and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) <= '2025-08-20 23.58.00' and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) >= '2025-08-20 23.58.00' and (resAreId = 1 or resAreId <= 0) nr: 0 20/08/2025 23:58:02.2510 810 ms. EXECSCALAR: select count(resId) as Tot from movReservation where resStatus = 'V' and resTypeRes = 'B' AND ((resConfirmed IN (0,2,3) AND resCreation>'2025-08-20 22.58.01') OR resConfirmed IN (4,5)) and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) <= '2025-08-20 23.58.00' and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) >= '2025-08-20 23.58.00' and (resAreId = 1 or resAreId <= 0) nr: 0 (WAIT TIME 5 ms.) 20/08/2025 23:58:02.2530 818 ms. EXECSCALAR: select count(resId) as Tot from movReservation where resStatus = 'V' and resTypeRes = 'B' AND ((resConfirmed IN (0,2,3) AND resCreation>'2025-08-20 22.58.01') OR resConfirmed IN (4,5)) and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) <= '2025-08-20 23.58.00' and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) >= '2025-08-20 23.58.00' and (resAreId = 1 or resAreId <= 0) nr: 0 20/08/2025 23:58:02.2560 811 ms. EXECSCALAR: select count(resId) as Tot from movReservation where resStatus = 'V' and resTypeRes = 'B' AND ((resConfirmed IN (0,2,3) AND resCreation>'2025-08-20 22.58.01') OR resConfirmed IN (4,5)) and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) <= '2025-08-20 23.58.00' and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) >= '2025-08-20 23.58.00' and (resAreId = 1 or resAreId <= 0) nr: 0 (WAIT TIME 9 ms.) 20/08/2025 23:58:02.2600 808 ms. EXECSCALAR: select count(resId) as Tot from movReservation where resStatus = 'V' and resTypeRes = 'B' AND ((resConfirmed IN (0,2,3) AND resCreation>'2025-08-20 22.58.01') OR resConfirmed IN (4,5)) and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) <= '2025-08-20 23.58.00' and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) >= '2025-08-20 23.58.00' and (resAreId = 1 or resAreId <= 0) nr: 0 (WAIT TIME 15 ms.)