21/08/2025 01:51:17.8753 17102 ms. OPEN: show columns from tabParameters where Field = 'parUseCulture' 21/08/2025 01:51:18.0674 17291 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 2 21/08/2025 01:51:18.0684 17290 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 3 21/08/2025 01:51:18.0694 17291 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 3 21/08/2025 01:51:18.0694 17294 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 2 21/08/2025 01:51:18.0694 17294 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 2 21/08/2025 01:51:18.0704 17292 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 2 21/08/2025 01:51:18.0714 17294 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 3 21/08/2025 01:51:18.0714 17295 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 5 21/08/2025 01:51:18.0724 17297 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 1 21/08/2025 01:51:18.0724 17295 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 1 21/08/2025 01:51:18.0734 17297 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 2 21/08/2025 01:51:18.0744 17299 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 3 21/08/2025 01:51:18.0754 17299 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 1 21/08/2025 01:51:18.1795 777 ms. OPEN: select * from tablanguages where lanStatus='V' order by lannumber limit 1 21/08/2025 01:51:18.1815 17406 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 5 21/08/2025 01:51:18.1815 784 ms. OPEN: select * from tablanguages where lanStatus='V' order by lannumber limit 1 21/08/2025 01:51:18.1825 769 ms. OPEN: select * from tablanguages where lanStatus='V' order by lannumber limit 1 21/08/2025 01:51:18.1825 770 ms. OPEN: select * from tablanguages where lanStatus='V' order by lannumber limit 1 21/08/2025 01:51:18.1855 776 ms. OPEN: select * from tablanguages where lanStatus='V' order by lannumber limit 1 21/08/2025 01:51:19.9949 519 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-21 00:51:19') OR resConfirmed IN (4,5)) and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) <= '2025-08-21 01:51:18' and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) >= '2025-08-21 01:51:18' and (resAreId = 1 or resAreId <= 0) nr: 0 21/08/2025 01:51:19.9959 519 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-21 00:51:19') OR resConfirmed IN (4,5)) and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) <= '2025-08-21 01:51:19' and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) >= '2025-08-21 01:51:19' and (resAreId = 1 or resAreId <= 0) nr: 0 21/08/2025 01:51:19.9969 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-08-21 00:51:19') OR resConfirmed IN (4,5)) and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) <= '2025-08-21 01:51:18' and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) >= '2025-08-21 01:51:18' and (resAreId = 1 or resAreId <= 0) nr: 0 21/08/2025 01:51:20.0019 518 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-21 00:51:19') OR resConfirmed IN (4,5)) and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) <= '2025-08-21 01:51:18' and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) >= '2025-08-21 01:51:18' and (resAreId = 1 or resAreId <= 0) nr: 0 (WAIT TIME 4 ms.) 21/08/2025 01:51:20.0039 526 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-21 00:51:19') OR resConfirmed IN (4,5)) and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) <= '2025-08-21 01:51:18' and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) >= '2025-08-21 01:51:18' and (resAreId = 1 or resAreId <= 0) nr: 0 21/08/2025 01:51:20.0039 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-08-21 00:51:19') OR resConfirmed IN (4,5)) and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) <= '2025-08-21 01:51:18' and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) >= '2025-08-21 01:51:18' and (resAreId = 1 or resAreId <= 0) nr: 0 (WAIT TIME 7 ms.) 21/08/2025 01:51:20.0169 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-08-21 00:51:19') OR resConfirmed IN (4,5)) and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) <= '2025-08-21 01:51:18' and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) >= '2025-08-21 01:51:18' and (resAreId = 1 or resAreId <= 0) nr: 0 (WAIT TIME 18 ms.) 21/08/2025 01:51:20.0209 524 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-21 00:51:19') OR resConfirmed IN (4,5)) and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) <= '2025-08-21 01:51:19' and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) >= '2025-08-21 01:51:19' and (resAreId = 1 or resAreId <= 0) nr: 0 (WAIT TIME 22 ms.) 21/08/2025 01:51:20.0249 526 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-21 00:51:19') OR resConfirmed IN (4,5)) and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) <= '2025-08-21 01:51:18' and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) >= '2025-08-21 01:51:18' and (resAreId = 1 or resAreId <= 0) nr: 0 (WAIT TIME 25 ms.) 21/08/2025 01:51:20.0259 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-08-21 00:51:19') OR resConfirmed IN (4,5)) and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) <= '2025-08-21 01:51:19' and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) >= '2025-08-21 01:51:19' and (resAreId = 1 or resAreId <= 0) nr: 0 (WAIT TIME 25 ms.) 21/08/2025 01:51:20.0359 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-08-21 00:51:19') OR resConfirmed IN (4,5)) and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) <= '2025-08-21 01:51:18' and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) >= '2025-08-21 01:51:18' and (resAreId = 1 or resAreId <= 0) nr: 0 (WAIT TIME 36 ms.) 21/08/2025 01:51:26.3112 7542 ms. EXECSCALAR: SELECT count(*) FROM payinventory WHERE invValue<>0 AND invType='' nr: 0 21/08/2025 01:51:30.3450 3978 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 21/08/2025 01:51:32.5247 2179 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); 21/08/2025 03:05:32.9119 1262 ms. OPEN: select traCode from movTransit where traCode ='458881113100327005012999' 21/08/2025 03:05:34.6690 711 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 = '458881113100327005012999' AND traStatus='V' AND payStatus='V' and (terType IS NULL OR terType<>3 OR (terType=3 and payType='P')) 21/08/2025 04:57:47.7470 22702 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 21/08/2025 06:37:16.9617 539 ms. OPEN: select traId,traDateTime,traEnabled,traDisableTime,traCode,traBadge,traCarId,traAreId,traIdTerminal from movtransit where traStatus='V' and traDirection = 'I' and traCarId = 190 order by traDateTime desc,traId desc 21/08/2025 06:53:19.1170 1697 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 2 21/08/2025 06:53:19.1511 1800 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 5 21/08/2025 06:53:19.1521 1717 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 5 21/08/2025 06:53:19.1531 1842 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 2 21/08/2025 06:53:19.1541 1750 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 1 21/08/2025 06:53:19.1541 1783 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 1 21/08/2025 06:53:19.1551 1660 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 5 21/08/2025 06:53:19.1551 1666 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 1 (WAIT TIME 5 ms.) 21/08/2025 06:53:19.1561 2605 ms. OPEN: select * from tabArea where areId = 0 (WAIT TIME 33 ms.) 21/08/2025 06:53:19.1711 1560 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 1 (WAIT TIME 53 ms.) 21/08/2025 06:53:19.1781 1682 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 2 (WAIT TIME 61 ms.) 21/08/2025 06:53:19.1851 1822 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 1 (WAIT TIME 62 ms.) 21/08/2025 06:53:19.2021 1504 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 2 (WAIT TIME 79 ms.) 21/08/2025 06:53:19.2021 1903 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 5 (WAIT TIME 81 ms.) 21/08/2025 06:53:19.2351 1498 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 5 (WAIT TIME 115 ms.) 21/08/2025 06:53:19.2361 2569 ms. OPEN: select * from tabParameters order by parId desc limit 1 (WAIT TIME 117 ms.) 21/08/2025 06:53:19.2371 2578 ms. OPEN: show columns from tabParameters where Field = 'parVatShowMode' (WAIT TIME 119 ms.) 21/08/2025 06:53:19.2601 1710 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 5 (WAIT TIME 135 ms.) 21/08/2025 06:53:19.2601 1643 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 2 (WAIT TIME 143 ms.) 21/08/2025 06:53:20.3238 587 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 16 OR lnsTerId=16) 21/08/2025 06:53:20.3248 587 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 1 OR lnsTerId=1) 21/08/2025 06:53:20.3248 587 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 3 OR lnsTerId=3) 21/08/2025 06:53:20.3258 579 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 1 OR lnsTerId=1) 21/08/2025 06:53:20.3268 581 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 2 OR lnsTerId=2) 21/08/2025 06:53:20.3278 576 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 3 OR lnsTerId=3) 21/08/2025 06:53:20.3278 586 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 1 OR lnsTerId=1) 21/08/2025 06:53:20.3308 592 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 1 OR lnsTerId=1) 21/08/2025 06:53:20.4809 582 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 16 OR lnsTerId=16) (WAIT TIME 150 ms.) 21/08/2025 06:53:20.4819 584 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 150 ms.) 21/08/2025 06:53:20.4839 585 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 151 ms.) 21/08/2025 06:53:20.4859 588 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 1 OR lnsTerId=1) (WAIT TIME 152 ms.) 21/08/2025 06:53:20.4859 590 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 146 ms.) 21/08/2025 06:53:20.4869 595 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 147 ms.) 21/08/2025 06:53:20.4889 593 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 148 ms.) 21/08/2025 06:53:20.4950 594 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 1 OR lnsTerId=1) (WAIT TIME 160 ms.) 21/08/2025 06:53:20.5310 590 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 200 ms.) 21/08/2025 06:53:20.6220 594 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 286 ms.) 21/08/2025 06:53:20.6240 591 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 16 OR lnsTerId=16) (WAIT TIME 291 ms.) 21/08/2025 06:53:20.6270 600 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 16 OR lnsTerId=16) (WAIT TIME 285 ms.) 21/08/2025 06:53:20.6270 599 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 16 OR lnsTerId=16) (WAIT TIME 290 ms.) 21/08/2025 06:53:20.6300 597 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 16 OR lnsTerId=16) (WAIT TIME 292 ms.) 21/08/2025 06:53:20.6380 872 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 (WAIT TIME 110 ms.) 21/08/2025 06:53:21.2194 566 ms. OPEN: select * from tabArea where areStatus='V' and areEnabled = 1 AND areId = 1 21/08/2025 06:53:21.2204 540 ms. OPEN: select * from tabArea where areStatus='V' and areEnabled = 1 AND areId = 1 21/08/2025 06:53:21.2214 570 ms. OPEN: select * from tabArea where areStatus='V' and areEnabled = 1 AND areId = 1 21/08/2025 06:53:21.3936 741 ms. OPEN: select * from tabArea where areStatus='V' and areEnabled = 1 AND areId = 1 21/08/2025 06:53:21.3956 741 ms. OPEN: select * from tabArea where areStatus='V' and areEnabled = 1 AND areId = 1 21/08/2025 06:53:21.3966 758 ms. OPEN: select * from tabArea where areStatus='V' and areEnabled = 1 AND areId = 1 21/08/2025 06:53:21.3966 743 ms. OPEN: select * from tabArea where areStatus='V' and areEnabled = 1 AND areId = 1 21/08/2025 06:53:21.3976 745 ms. OPEN: select * from tabArea where areStatus='V' and areEnabled = 1 AND areId = 1 21/08/2025 06:53:21.3996 750 ms. OPEN: select * from tabArea where areStatus='V' and areEnabled = 1 AND areId = 1 21/08/2025 06:53:21.4006 753 ms. OPEN: select * from tabuser where useStatus='V' order by useId 21/08/2025 06:53:21.4036 722 ms. OPEN: select * from tabArea where areStatus='V' and areEnabled = 1 AND areId = 1 21/08/2025 06:53:21.4046 749 ms. OPEN: select * from tabArea where areStatus='V' and areEnabled = 1 AND areId = 1 21/08/2025 06:53:21.4076 771 ms. OPEN: select * from tabArea where areStatus='V' and areEnabled = 1 AND areId = 1 21/08/2025 06:53:21.4086 732 ms. OPEN: select parcurrency,parcurrencySymbol from tabParameters where parStatus='V' order by parId desc limit 1 21/08/2025 06:53:21.5447 909 ms. OPEN: select distinct tagName from tabtag where tagstatus='V' and tagMandatory=1 and tagDevCode in (select devCode from tabDevice where devStatus='V' and devId in (select lnkSubId from tabLnkDevice where lnkStatus='V' and lnkDevId = (select devId from tabDevice inner join tabTerminal on terType = devCode where terId = 3))) order by tagName 21/08/2025 06:53:21.5497 905 ms. OPEN: select distinct tagName from tabtag where tagstatus='V' and tagMandatory=1 and tagDevCode in (select devCode from tabDevice where devStatus='V' and devId in (select lnkSubId from tabLnkDevice where lnkStatus='V' and lnkDevId = (select devId from tabDevice inner join tabTerminal on terType = devCode where terId = 3))) order by tagName 21/08/2025 06:53:21.5537 883 ms. OPEN: select distinct tagName from tabtag where tagstatus='V' and tagMandatory=1 and tagDevCode in (select devCode from tabDevice where devStatus='V' and devId in (select lnkSubId from tabLnkDevice where lnkStatus='V' and lnkDevId = (select devId from tabDevice inner join tabTerminal on terType = devCode where terId = 3))) order by tagName 21/08/2025 06:53:21.5537 884 ms. OPEN: select distinct tagName from tabtag where tagstatus='V' and tagMandatory=1 and tagDevCode in (select devCode from tabDevice where devStatus='V' and devId in (select lnkSubId from tabLnkDevice where lnkStatus='V' and lnkDevId = (select devId from tabDevice inner join tabTerminal on terType = devCode where terId = 3))) order by tagName 21/08/2025 06:53:21.5587 925 ms. OPEN: select distinct tagName from tabtag where tagstatus='V' and tagMandatory=1 and tagDevCode in (select devCode from tabDevice where devStatus='V' and devId in (select lnkSubId from tabLnkDevice where lnkStatus='V' and lnkDevId = (select devId from tabDevice inner join tabTerminal on terType = devCode where terId = 3))) order by tagName 21/08/2025 06:53:23.4860 1334 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-21 05.53.22') OR resConfirmed IN (4,5)) and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) <= '2025-08-21 06.53.20' and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) >= '2025-08-21 06.53.20' and (resAreId = 1 or resAreId <= 0) nr: 0 21/08/2025 06:53:23.4890 1334 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-21 05.53.22') OR resConfirmed IN (4,5)) and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) <= '2025-08-21 06.53.20' and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) >= '2025-08-21 06.53.20' and (resAreId = 1 or resAreId <= 0) nr: 0 21/08/2025 06:53:23.4920 971 ms. OPEN: select * from tabDevInstalled inner join tabTerminal on terId = insTerId inner join tabDevice on devId = insDevId where terId = 3 and devCode>40001 and devCode<49999 and devStatus='V' and insStatus='V' 21/08/2025 06:53:23.4920 1220 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-21 05.53.22') OR resConfirmed IN (4,5)) and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) <= '2025-08-21 06.53.20' and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) >= '2025-08-21 06.53.20' and (resAreId = 1 or resAreId <= 0) nr: 0 21/08/2025 06:53:23.4940 985 ms. OPEN: select * from tabDevInstalled inner join tabTerminal on terId = insTerId inner join tabDevice on devId = insDevId where terId = 3 and devCode>40001 and devCode<49999 and devStatus='V' and insStatus='V' 21/08/2025 06:53:23.4940 1340 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-21 05.53.22') OR resConfirmed IN (4,5)) and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) <= '2025-08-21 06.53.20' and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) >= '2025-08-21 06.53.20' and (resAreId = 1 or resAreId <= 0) nr: 0 21/08/2025 06:53:23.4950 983 ms. OPEN: select * from tabDevInstalled inner join tabTerminal on terId = insTerId inner join tabDevice on devId = insDevId where terId = 3 and devCode>40001 and devCode<49999 and devStatus='V' and insStatus='V' 21/08/2025 06:53:23.4950 1356 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-21 05.53.22') OR resConfirmed IN (4,5)) and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) <= '2025-08-21 06.53.20' and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) >= '2025-08-21 06.53.20' and (resAreId = 1 or resAreId <= 0) nr: 0 21/08/2025 06:53:23.4960 1346 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-21 05.53.22') OR resConfirmed IN (4,5)) and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) <= '2025-08-21 06.53.20' and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) >= '2025-08-21 06.53.20' and (resAreId = 1 or resAreId <= 0) nr: 0 21/08/2025 06:53:23.5000 1350 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-21 05.53.22') OR resConfirmed IN (4,5)) and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) <= '2025-08-21 06.53.20' and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) >= '2025-08-21 06.53.20' and (resAreId = 1 or resAreId <= 0) nr: 0 21/08/2025 06:53:23.5060 1348 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-21 05.53.22') OR resConfirmed IN (4,5)) and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) <= '2025-08-21 06.53.20' and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) >= '2025-08-21 06.53.20' and (resAreId = 1 or resAreId <= 0) nr: 0 (WAIT TIME 7 ms.) 21/08/2025 06:53:23.5160 983 ms. OPEN: select * from tabDevInstalled inner join tabTerminal on terId = insTerId inner join tabDevice on devId = insDevId where terId = 3 and devCode>40001 and devCode<49999 and devStatus='V' and insStatus='V' (WAIT TIME 19 ms.) 21/08/2025 06:53:23.5180 1350 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-21 05.53.22') OR resConfirmed IN (4,5)) and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) <= '2025-08-21 06.53.20' and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) >= '2025-08-21 06.53.20' and (resAreId = 1 or resAreId <= 0) nr: 0 (WAIT TIME 19 ms.) 21/08/2025 06:53:23.5220 997 ms. OPEN: select * from tabDevInstalled inner join tabTerminal on terId = insTerId inner join tabDevice on devId = insDevId where terId = 3 and devCode>40001 and devCode<49999 and devStatus='V' and insStatus='V' (WAIT TIME 14 ms.) 21/08/2025 06:53:23.5220 1348 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-21 05.53.22') OR resConfirmed IN (4,5)) and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) <= '2025-08-21 06.53.20' and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) >= '2025-08-21 06.53.20' and (resAreId = 1 or resAreId <= 0) nr: 0 (WAIT TIME 21 ms.) 21/08/2025 06:53:23.5260 1351 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-21 05.53.22') OR resConfirmed IN (4,5)) and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) <= '2025-08-21 06.53.20' and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) >= '2025-08-21 06.53.20' and (resAreId = 1 or resAreId <= 0) nr: 0 (WAIT TIME 25 ms.) 21/08/2025 06:53:23.5290 1353 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-21 05.53.22') OR resConfirmed IN (4,5)) and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) <= '2025-08-21 06.53.20' and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) >= '2025-08-21 06.53.20' and (resAreId = 1 or resAreId <= 0) nr: 0 (WAIT TIME 27 ms.) 21/08/2025 06:53:24.3055 725 ms. EXEC: insert into payCurInventory (curTerId,curDevCode,curDevDescription,curChannelId,curChannelDescr,curValue,curType) SELECT * FROM (SELECT 3,42101,'Notes Escrow',1 as c1,'Payout',100 as v1,'N') as tmp WHERE NOT EXISTS ( SELECT curDevCode,curTerId,curChannelId,curValue FROM payCurInventory WHERE curDevCode = 42101 and curChannelId = 1 and curTerId = 3 and curValue = 100 and curType = 'N' LIMIT 1) (WAIT TIME 50 ms.) 21/08/2025 06:53:24.3215 725 ms. EXEC: insert into payCurInventory (curTerId,curDevCode,curDevDescription,curChannelId,curChannelDescr,curValue,curType) SELECT * FROM (SELECT 3,42101,'Notes Escrow',1 as c1,'Payout',100 as v1,'N') as tmp WHERE NOT EXISTS ( SELECT curDevCode,curTerId,curChannelId,curValue FROM payCurInventory WHERE curDevCode = 42101 and curChannelId = 1 and curTerId = 3 and curValue = 100 and curType = 'N' LIMIT 1) (WAIT TIME 65 ms.) 21/08/2025 06:53:24.3245 727 ms. EXEC: insert into payCurInventory (curTerId,curDevCode,curDevDescription,curChannelId,curChannelDescr,curValue,curType) SELECT * FROM (SELECT 3,42101,'Notes Escrow',1 as c1,'Payout',100 as v1,'N') as tmp WHERE NOT EXISTS ( SELECT curDevCode,curTerId,curChannelId,curValue FROM payCurInventory WHERE curDevCode = 42101 and curChannelId = 1 and curTerId = 3 and curValue = 100 and curType = 'N' LIMIT 1) (WAIT TIME 67 ms.) 21/08/2025 06:53:24.3315 727 ms. EXEC: insert into payCurInventory (curTerId,curDevCode,curDevDescription,curChannelId,curChannelDescr,curValue,curType) SELECT * FROM (SELECT 3,42101,'Notes Escrow',1 as c1,'Payout',100 as v1,'N') as tmp WHERE NOT EXISTS ( SELECT curDevCode,curTerId,curChannelId,curValue FROM payCurInventory WHERE curDevCode = 42101 and curChannelId = 1 and curTerId = 3 and curValue = 100 and curType = 'N' LIMIT 1) (WAIT TIME 75 ms.) 21/08/2025 06:53:24.3475 738 ms. EXEC: insert into payCurInventory (curTerId,curDevCode,curDevDescription,curChannelId,curChannelDescr,curValue,curType) SELECT * FROM (SELECT 3,42101,'Notes Escrow',1 as c1,'Payout',100 as v1,'N') as tmp WHERE NOT EXISTS ( SELECT curDevCode,curTerId,curChannelId,curValue FROM payCurInventory WHERE curDevCode = 42101 and curChannelId = 1 and curTerId = 3 and curValue = 100 and curType = 'N' LIMIT 1) (WAIT TIME 82 ms.) 21/08/2025 06:53:32.3901 7918 ms. OPEN: SELECT * FROM movLinks INNER JOIN movTransit on traUID = mliTraUID WHERE mliRFIDCode = '0240526684630' AND mliStatus='V' ORDER BY mliId DESC LIMIT 1 21/08/2025 06:53:32.9875 11405 ms. EXECSCALAR: SELECT count(*) FROM payinventory WHERE invValue<>0 AND invType='' nr: 0 21/08/2025 06:53:35.0088 1641 ms. EXEC: insert into movtransit (traUseId,traCreation,traStatus,traUID,traYear,traDateTime,traCode,traType,traClass,traIdTerminal,traDirection,traPlate,traEnabled,traDisableTime,traAreId,traNotes,traBadge,traCarId,traTarId) VALUES (0,'2025-08-21 06.53.33','V',4795848598046540,2025,'2025-08-21 06.46.00','458882070300327005029999',2,2,16,'I','',1,0,1,'','1301662767574',163,0) 21/08/2025 06:53:36.8251 1806 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 21/08/2025 06:53:37.8269 4836 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 21/08/2025 06:53:39.9723 2145 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); 21/08/2025 06:54:11.4264 27528 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 21/08/2025 06:54:11.4264 1853 ms. OPEN: select 1 as Tot,payUID,payPayed,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)) order by traUIDGroup,payAmount, traType, traDiscountValue, traDiscountType 21/08/2025 06:55:17.7188 682 ms. EXECSCALAR: select count(rulId) from tabTicketRules where rulStatus='V' and rulTerId = 3 and rulDevId = 1 and rulTicId = 2 nr: 0