11/08/2025 05:53:14.4262 1726 ms. OPEN: select * from tabCurrency where curStatus='V' and curCode = 'EUR' 11/08/2025 05:53:14.5352 2636 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 5 11/08/2025 05:53:14.5362 2434 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 2 11/08/2025 05:53:14.5372 2527 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 5 11/08/2025 05:53:14.5372 2762 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 2 11/08/2025 05:53:14.5372 1834 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 3 11/08/2025 05:53:14.5382 2652 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 5 11/08/2025 05:53:14.5382 1870 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 3 11/08/2025 05:53:14.5382 1735 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 2 11/08/2025 05:53:14.5402 2544 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 1 11/08/2025 05:53:14.5402 2451 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 5 11/08/2025 05:53:14.5412 2705 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 1 11/08/2025 05:53:14.5412 2662 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 2 11/08/2025 05:53:14.5853 2474 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 1 11/08/2025 05:53:14.6073 1944 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 3 11/08/2025 05:53:14.6083 1925 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 3 11/08/2025 05:53:14.6093 1930 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 3 11/08/2025 05:53:14.6103 1906 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 3 11/08/2025 05:53:14.6103 2447 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 5 11/08/2025 05:53:14.6113 2651 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 2 11/08/2025 05:53:14.6113 2665 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 1 11/08/2025 05:53:16.1423 580 ms. OPEN: select * from tabArea where areStatus='V' and areEnabled = 1 AND areId = 1 11/08/2025 05:53:16.3076 746 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 11/08/2025 05:53:16.3086 744 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 11/08/2025 05:53:16.3136 750 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 11/08/2025 05:53:16.3177 757 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 11/08/2025 05:53:20.0573 5585 ms. EXECSCALAR: SELECT count(*) FROM payinventory WHERE invValue<>0 AND invType='' nr: 0 11/08/2025 05:53:24.9126 4851 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (.05,.1,.2,.5,1,2); 11/08/2025 05:53:26.7869 1874 ms. EXEC: UPDATE payInventory SET invType='C' WHERE invType<>'C' AND invValue IN (.05,.1,.2,.5,1,2) AND invDevice IN (41003,41002,41001,41101,41102,41103); 11/08/2025 05:53:28.0457 1258 ms. EXEC: UPDATE payCash SET casType='N' WHERE casType<>'N' AND ABS(casSingleAmount) IN (5,10,20,50,100,200,500); 11/08/2025 06:05:02.4198 19430 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 11/08/2025 06:29:47.1692 1049 ms. OPEN: select traId,traDateTime,traEnabled,traDisableTime,traCode,traBadge,traCarId,traAreId,traIdTerminal from movtransit where traStatus='V' and traDirection = 'I' and traCarId = 163 order by traDateTime desc,traId desc 11/08/2025 07:00:38.8071 1565 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 11/08/2025 07:06:06.4773 1719 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 11/08/2025 07:06:54.7051 532 ms. OPEN: select traId,traDateTime,traEnabled,traDisableTime,traCode,traBadge,traCarId,traAreId,traIdTerminal from movtransit where traStatus='V' and traDirection = 'I' and traCarId = 164 order by traDateTime desc,traId desc 11/08/2025 07:39:24.2853 959 ms. OPEN: select traId,traDateTime,traEnabled,traDisableTime,traCode,traBadge,traCarId,traAreId,traIdTerminal from movtransit where traStatus='V' and traDirection = 'I' and traCarId = 26 order by traDateTime desc,traId desc 11/08/2025 08:01:55.9141 3201 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 11/08/2025 08:27:20.9071 703 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 11/08/2025 08:59:18.8871 800 ms. OPEN: select traId,traDateTime,traEnabled,traDisableTime,traCode,traBadge,traCarId,traAreId,traIdTerminal from movtransit where traStatus='V' and traDirection = 'I' and traCarId = 103 order by traDateTime desc,traId desc 11/08/2025 09:37:10.4261 857 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 11/08/2025 09:48:41.8661 511 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 11/08/2025 10:13:06.0519 1689 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 11/08/2025 10:36:04.9931 2676 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 11/08/2025 10:37:43.9643 659 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 11/08/2025 13:39:08.3446 642 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 11/08/2025 14:28:36.9060 559 ms. EXEC: insert into payReceipt (recTraUID,recPayUID,recYear,recDateTime,recText,recInvalid) VALUES (5069129598485290,4922585370160860,2025,'2025-08-11 14.28.36',' Date: 8/11/2025 2:27:59 PM Code: 458784661600327005012999 Entry Date: 8/11/2025 12:56:56 PM Plate: Class: Cars Park: The Mall Gate: Entry 2 ______________________________ Total: 100.00 EUR ______________________________ Paid: 100.00 EUR __________ Change: 0.00 EUR Type: Credit Card Dispozitiv: Manual Cashier 1 # 2500411316 ',0) 11/08/2025 14:43:19.5616 655 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 (WAIT TIME 1 ms.) 11/08/2025 15:55:15.6160 625 ms. EXEC: insert into payPayment (payCreation,payUseId,payStatus,payUID,payTraUID,payYear,payDateTime,payIdTerminal,payEnabled,payDisableTime,payTarId,payTimeLimit,payType,payCurrency,payAmount,payPayed,payChange,payCardType,payPAN,paySTAN,payIdEvent,payAmountCalc,payDiscountValue,payDiscount,payDiscountType,payVatPercent,payVatAmount) VALUES ('2025-08-11 15.54.38',1,'V',4964896744032970,5470873883856040,2025,'2025-08-11 15.54.38',4,1,0,4,'2025-08-11 16.09.38','P','EUR',50,50,0,'','','',1,50,0,0,'',0,0) 11/08/2025 16:05:24.2515 625 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-11 16.05.23','V',5679581342582560,2025,'2025-08-11 16.05.23','458785792300327005012999',1,2,16,'I','',1,0,1,'','',4) 11/08/2025 16:07:50.4001 515 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