17/08/2025 00:46:10.2309   633 ms.           EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2025-08-17 00.46.09',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';

17/08/2025 02:47:39.8533 20023 ms.           OPEN: select * from tablanguages where lanStatus='V' order by lannumber limit 1
17/08/2025 02:47:39.8543 20027 ms.           OPEN: show columns from tabParameters where Field = 'parAllowNegativePlaces' (WAIT TIME 19 ms.)
17/08/2025 02:47:41.7816   647 ms.     EXECSCALAR: select count(*) from information_schema.tables where table_schema= 'wisepark_0327' and table_name= 'tabTerminalExtraMem' nr: 1
17/08/2025 02:47:41.9317  1171 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
17/08/2025 02:47:41.9317  1170 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
17/08/2025 02:47:41.9337  1172 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
17/08/2025 02:47:41.9357  1175 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
17/08/2025 02:47:41.9367  1175 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
17/08/2025 02:47:41.9377  1176 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
17/08/2025 02:47:48.9680  8007 ms.     EXECSCALAR: SELECT count(*) FROM payinventory WHERE invValue<>0 AND invType='' nr: 0
17/08/2025 02:47:53.7056  4733 ms.           EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40);
17/08/2025 02:47:55.3717  1666 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);
17/08/2025 03:03:16.6162 19855 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
17/08/2025 03:03:39.8444   547 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
17/08/2025 07:10:03.1930   689 ms.           OPEN: select traId,traDateTime,traEnabled,traDisableTime,traCode,traBadge,traCarId,traAreId,traIdTerminal from movtransit where traStatus='V' and traDirection = 'I' and traCarId = 165 order by traDateTime desc,traId desc
17/08/2025 09:12:12.7337   615 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
17/08/2025 09:38:50.6036  2050 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
17/08/2025 10:22:10.5597  1972 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
17/08/2025 11:14:33.8695  2949 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
17/08/2025 17:03:59.1381  1803 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
17/08/2025 21:26:44.4950   842 ms.           OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 2
17/08/2025 21:26:44.5200  1100 ms.           OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 5 (WAIT TIME 35 ms.)
17/08/2025 21:26:44.5230  1348 ms.           OPEN: select * from tabTerminal where terStatus = 'V' and terAddress = 3 (WAIT TIME 32 ms.)
17/08/2025 21:26:44.5270  2334 ms.           OPEN: select * from tabTerminal where terStatus = 'V' and terAddress = 3 (WAIT TIME 32 ms.)
17/08/2025 21:26:44.5280  1334 ms.           OPEN: select * from tabTerminal where terStatus = 'V' and terAddress = 3 (WAIT TIME 28 ms.)
17/08/2025 21:26:44.5290  1225 ms.           OPEN: select * from tabTerminal where terStatus = 'V' and terAddress = 3 (WAIT TIME 11 ms.)
17/08/2025 21:26:44.5300   703 ms.           OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 5 (WAIT TIME 17 ms.)
17/08/2025 21:26:44.5390   839 ms.           OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 5 (WAIT TIME 33 ms.)
17/08/2025 21:26:44.5430   866 ms.           OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 1 (WAIT TIME 36 ms.)
17/08/2025 21:26:44.5730   825 ms.           OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 2
17/08/2025 21:26:44.5730   836 ms.           OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 5
17/08/2025 21:26:44.5740   849 ms.           OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 1
17/08/2025 21:26:44.5740  1284 ms.           OPEN: select * from tabTerminal where terStatus = 'V' and terAddress = 4
17/08/2025 21:26:44.5750  1067 ms.           OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 4
17/08/2025 21:26:44.5750   775 ms.           OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 1
17/08/2025 21:26:44.6651  2485 ms.           OPEN: select * from tabCurrency where curStatus='V' and curCode = 'EUR'
17/08/2025 21:26:44.6761  1510 ms.           EXEC: CREATE TABLE IF NOT EXISTS tabTimeZones(timId int(11) not null auto_increment,timCreation DATETIME not null default '0000-00-00',timModify TIMESTAMP not null,timUseId int(11) not null default 0,timStatus varchar(1) not null default 'V',timRegion varchar(5) not null default '',timIdWindows varchar(100) not null default '',timIdLinux varchar(100) not null default '', PRIMARY KEY (timId)) ENGINE=InnoDB DEFAULT CHARSET=utf8;
17/08/2025 21:26:45.4306   762 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'
17/08/2025 21:26:45.4326   761 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'
17/08/2025 21:26:46.5564   512 ms.           OPEN: select * from tabUser where useStatus='V' and useBadId<>'' and useParkAccess<>0 order by useSuperUser desc,useId
17/08/2025 21:26:46.8005   804 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-17 20.26.45') OR resConfirmed IN (4,5)) and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) <= '2025-08-17 21.26.45' and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) >= '2025-08-17 21.26.45' and (resAreId = 1 or resAreId <= 0) nr: 0
17/08/2025 21:26:46.8035   797 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-17 20.26.46') OR resConfirmed IN (4,5)) and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) <= '2025-08-17 21.26.45' and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) >= '2025-08-17 21.26.45' and (resAreId = 1 or resAreId <= 0) nr: 0
17/08/2025 21:26:46.8045   800 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-17 20.26.46') OR resConfirmed IN (4,5)) and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) <= '2025-08-17 21.26.45' and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) >= '2025-08-17 21.26.45' and (resAreId = 1 or resAreId <= 0) nr: 0
17/08/2025 21:26:46.8055   805 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-17 20.26.46') OR resConfirmed IN (4,5)) and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) <= '2025-08-17 21.26.45' and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) >= '2025-08-17 21.26.45' and (resAreId = 1 or resAreId <= 0) nr: 0
17/08/2025 21:26:46.8065   798 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-17 20.26.46') OR resConfirmed IN (4,5)) and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) <= '2025-08-17 21.26.45' and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) >= '2025-08-17 21.26.45' and (resAreId = 1 or resAreId <= 0) nr: 0
17/08/2025 21:26:46.8085   797 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-17 20.26.46') OR resConfirmed IN (4,5)) and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) <= '2025-08-17 21.26.45' and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) >= '2025-08-17 21.26.45' and (resAreId = 1 or resAreId <= 0) nr: 0
17/08/2025 21:26:46.8085   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-17 20.26.45') OR resConfirmed IN (4,5)) and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) <= '2025-08-17 21.26.45' and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) >= '2025-08-17 21.26.45' and (resAreId = 1 or resAreId <= 0) nr: 0
17/08/2025 21:26:46.8105   813 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-17 20.26.45') OR resConfirmed IN (4,5)) and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) <= '2025-08-17 21.26.45' and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) >= '2025-08-17 21.26.45' and (resAreId = 1 or resAreId <= 0) nr: 0
17/08/2025 21:26:46.8105   802 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-17 20.26.46') OR resConfirmed IN (4,5)) and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) <= '2025-08-17 21.26.45' and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) >= '2025-08-17 21.26.45' and (resAreId = 1 or resAreId <= 0) nr: 0
17/08/2025 21:26:46.8125   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-17 20.26.46') OR resConfirmed IN (4,5)) and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) <= '2025-08-17 21.26.45' and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) >= '2025-08-17 21.26.45' and (resAreId = 1 or resAreId <= 0) nr: 0
17/08/2025 21:26:46.8165   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-17 20.26.46') OR resConfirmed IN (4,5)) and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) <= '2025-08-17 21.26.45' and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) >= '2025-08-17 21.26.45' and (resAreId = 1 or resAreId <= 0) nr: 0
17/08/2025 21:26:46.8175   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-17 20.26.46') OR resConfirmed IN (4,5)) and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) <= '2025-08-17 21.26.45' and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) >= '2025-08-17 21.26.45' and (resAreId = 1 or resAreId <= 0) nr: 0
17/08/2025 21:26:47.5231  1267 ms.           OPEN: show columns from abbCards where Field = 'carUHFCode'
17/08/2025 21:26:49.2574  1733 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
17/08/2025 21:27:39.2691 26145 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
17/08/2025 21:27:57.0295   538 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
17/08/2025 21:29:06.1341   594 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
17/08/2025 21:35:17.9183  1161 ms.           OPEN: show columns from movLinks where Field = 'mliReceiptMessage'
17/08/2025 21:35:18.0073  2261 ms.           OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 3
17/08/2025 21:35:19.1961   516 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-17 20.35.18') OR resConfirmed IN (4,5)) and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) <= '2025-08-17 21.35.18' and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) >= '2025-08-17 21.35.18' and (resAreId = 1 or resAreId <= 0) nr: 0
17/08/2025 21:35:19.1981   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-17 20.35.18') OR resConfirmed IN (4,5)) and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) <= '2025-08-17 21.35.18' and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) >= '2025-08-17 21.35.18' and (resAreId = 1 or resAreId <= 0) nr: 0
17/08/2025 21:35:19.2111   532 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-17 20.35.18') OR resConfirmed IN (4,5)) and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) <= '2025-08-17 21.35.18' and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) >= '2025-08-17 21.35.18' and (resAreId = 1 or resAreId <= 0) nr: 0
17/08/2025 21:35:19.2151   538 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-17 20.35.18') OR resConfirmed IN (4,5)) and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) <= '2025-08-17 21.35.18' and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) >= '2025-08-17 21.35.18' and (resAreId = 1 or resAreId <= 0) nr: 0
17/08/2025 21:35:27.9740   888 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
17/08/2025 21:35:32.5761 14398 ms.     EXECSCALAR: SELECT count(*) FROM payinventory WHERE invValue<>0 AND invType='' nr: 0
17/08/2025 21:35:33.2175 12553 ms.           OPEN: SELECT * FROM movLinks INNER JOIN movTransit on traUID = mliTraUID WHERE mliRFIDCode = '458847754600327005031999' AND mliStatus='V' ORDER BY mliId DESC LIMIT 1
17/08/2025 21:35:35.7942  1692 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-17 21.35.34','V',5684855027871010,2025,'2025-08-17 21.32.26','458847754600327005031999',1,2,16,'I','',1,0,1,'','',4)
17/08/2025 21:35:37.3482  4567 ms.           EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40);
17/08/2025 21:35:37.5113  1706 ms.           EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage)
17/08/2025 21:35:40.0901  2740 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);
17/08/2025 21:40:48.1579 19218 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
17/08/2025 21:41:15.4910   546 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
17/08/2025 21:41:26.7220   706 ms.     EXECSCALAR: select count(payId) from paypayment where payStatus='V' and payIdTerminal = 4 and payDateTime = '2014-01-01 00.11.44' nr: 0
17/08/2025 22:12:22.3617  2098 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