16/08/2025 21:52:47.3971 733 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 2 16/08/2025 21:52:47.3981 595 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 2 16/08/2025 21:52:47.4012 1022 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 5 16/08/2025 21:52:47.4162 729 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 1 16/08/2025 21:52:47.4162 832 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 2 16/08/2025 21:52:47.4172 654 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 5 16/08/2025 21:52:47.5933 875 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 2 16/08/2025 21:52:47.5933 1019 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 5 16/08/2025 21:52:47.5963 910 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 5 16/08/2025 21:52:47.6103 985 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 1 (WAIT TIME 12 ms.) 16/08/2025 21:52:47.6383 848 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 1 (WAIT TIME 32 ms.) 16/08/2025 21:52:47.6843 2224 ms. OPEN: select * from tabUser where useStatus='V' and useBadId<>'' and useParkAccess<>0 order by useSuperUser desc,useId 16/08/2025 21:52:47.6853 2235 ms. OPEN: select * from tabUser where useStatus='V' and useBadId<>'' and useParkAccess<>0 order by useSuperUser desc,useId 16/08/2025 21:52:47.6873 1213 ms. EXEC: update tabTerminal set terVersion = 'Parking_project V.1.6.2 (BETA 44) Jul 25 2017 12:08:13.31061.20170725082637' where terId = 0 16/08/2025 21:52:47.6873 1164 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 1 16/08/2025 21:52:47.6883 2199 ms. OPEN: select * from tabTerminal where terStatus = 'V' and terAddress = 3 16/08/2025 21:52:47.7314 2282 ms. OPEN: select * from tabUser where useStatus='V' and useBadId<>'' and useParkAccess<>0 order by useSuperUser desc,useId 16/08/2025 21:52:47.7324 2273 ms. OPEN: select * from tabUser where useStatus='V' and useBadId<>'' and useParkAccess<>0 order by useSuperUser desc,useId 16/08/2025 21:52:47.9825 1429 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 = 0))) order by tagName 16/08/2025 21:52:48.3988 546 ms. OPEN: SELECT * FROM tabCardConversionRules WHERE ccrStatus=@ccrStatus AND (ccrTerId = @ccrTerId OR ccrTerId=0) AND (ccrDevId = @ccrDevId OR ccrDevId=0) AND (ccrSubId = @ccrSubId OR ccrSubId=0) ORDER BY ccrTerId DESC, ccrDevId DESC, ccrSubId DESC, ccrId DESC LIMIT 1 16/08/2025 21:52:48.3998 548 ms. OPEN: SELECT * FROM tabCardConversionRules WHERE ccrStatus=@ccrStatus AND (ccrTerId = @ccrTerId OR ccrTerId=0) AND (ccrDevId = @ccrDevId OR ccrDevId=0) AND (ccrSubId = @ccrSubId OR ccrSubId=0) ORDER BY ccrTerId DESC, ccrDevId DESC, ccrSubId DESC, ccrId DESC LIMIT 1 16/08/2025 21:52:48.4008 550 ms. OPEN: SELECT * FROM tabCardConversionRules WHERE ccrStatus=@ccrStatus AND (ccrTerId = @ccrTerId OR ccrTerId=0) AND (ccrDevId = @ccrDevId OR ccrDevId=0) AND (ccrSubId = @ccrSubId OR ccrSubId=0) ORDER BY ccrTerId DESC, ccrDevId DESC, ccrSubId DESC, ccrId DESC LIMIT 1 16/08/2025 21:52:48.4008 546 ms. OPEN: SELECT * FROM tabCardConversionRules WHERE ccrStatus=@ccrStatus AND (ccrTerId = @ccrTerId OR ccrTerId=0) AND (ccrDevId = @ccrDevId OR ccrDevId=0) AND (ccrSubId = @ccrSubId OR ccrSubId=0) ORDER BY ccrTerId DESC, ccrDevId DESC, ccrSubId DESC, ccrId DESC LIMIT 1 16/08/2025 21:52:48.4018 546 ms. OPEN: SELECT * FROM tabCardConversionRules WHERE ccrStatus=@ccrStatus AND (ccrTerId = @ccrTerId OR ccrTerId=0) AND (ccrDevId = @ccrDevId OR ccrDevId=0) AND (ccrSubId = @ccrSubId OR ccrSubId=0) ORDER BY ccrTerId DESC, ccrDevId DESC, ccrSubId DESC, ccrId DESC LIMIT 1 16/08/2025 21:52:52.4259 1496 ms. OPEN: show columns from abbCards where Field = 'carUHFCode' 16/08/2025 21:52:52.9943 566 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 16/08/2025 21:53:00.7146 14239 ms. EXECSCALAR: select count(*) from payInventory where invChannel=2 and invCode=2 and invDevice=41101 nr: 0 16/08/2025 21:53:03.5107 13492 ms. OPEN: SELECT * FROM movLinks INNER JOIN movTransit on traUID = mliTraUID WHERE mliRFIDCode = '458837857000327005031999' AND mliStatus='V' ORDER BY mliId DESC LIMIT 1 16/08/2025 21:53:06.0875 1793 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-16 21.53.04','V',5604592937057540,2025,'2025-08-16 21.49.30','458837857000327005031999',1,2,16,'I','',1,0,1,'','',4) 16/08/2025 21:53:45.8207 533 ms. OPEN: show columns from movRoutes where Field = 'rtsCarId' 16/08/2025 21:53:47.0935 702 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 = '458837232400327005012999' and traStatus='V' and casStatus='V' and terType=3 and casTotAmount>0 16/08/2025 21:54:07.1950 1437 ms. EXEC: insert into payReceipt (recTraUID,recPayUID,recYear,recDateTime,recText,recInvalid) VALUES (5349492543236140,5734707449910380,2025,'2025-08-16 21.54.05',' Date: 8/16/2025 9:54:05 PM Code: 458837232400327005012999 Entry Date: 8/16/2025 8:05:24 PM Plate: Class: Cars Park: The Mall Gate: Entry 2 ______________________________ Total: 100.00 EUR ______________________________ Paid: 100.00 EUR __________ Change: 0.00 EUR Type: Cash Dispozitiv: MPESA # 2500730365 ',0) 16/08/2025 21:54:16.3806 43186 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 16/08/2025 21:54:16.3806 11558 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 16/08/2025 21:54:27.7485 605 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 16/08/2025 21:55:53.3523 503 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 16/08/2025 22:01:56.4343 2851 ms. OPEN: select * from tablanguages where lanStatus='V' order by lannumber limit 1 16/08/2025 22:01:56.4823 2850 ms. OPEN: select * from tablanguages where lanStatus='V' order by lannumber limit 1 (WAIT TIME 69 ms.) 16/08/2025 22:01:56.4823 2850 ms. OPEN: select * from tablanguages where lanStatus='V' order by lannumber limit 1 (WAIT TIME 68 ms.) 16/08/2025 22:01:56.4833 2863 ms. OPEN: select * from tablanguages where lanStatus='V' order by lannumber limit 1 (WAIT TIME 68 ms.) 16/08/2025 22:01:56.4843 19443 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 2 (WAIT TIME 68 ms.) 16/08/2025 22:01:56.4843 19444 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 3 (WAIT TIME 67 ms.) 16/08/2025 22:01:56.4853 19445 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 5 (WAIT TIME 67 ms.) 16/08/2025 22:01:56.4863 19446 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 2 (WAIT TIME 65 ms.) 16/08/2025 22:01:56.4873 19449 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 3 (WAIT TIME 65 ms.) 16/08/2025 22:01:56.5374 19449 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 5 (WAIT TIME 65 ms.) 16/08/2025 22:01:56.5384 1835 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 2 (WAIT TIME 114 ms.) 16/08/2025 22:01:56.5384 19480 ms. OPEN: show columns from tabParameters where Field = 'parUseCulture' (WAIT TIME 92 ms.) 16/08/2025 22:01:56.5404 1818 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 5 (WAIT TIME 124 ms.) 16/08/2025 22:01:56.5414 19449 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 2 (WAIT TIME 119 ms.) 16/08/2025 22:01:56.5434 2847 ms. OPEN: select * from tablanguages where lanStatus='V' order by lannumber limit 1 (WAIT TIME 131 ms.) 16/08/2025 22:01:56.5464 2853 ms. OPEN: select * from tablanguages where lanStatus='V' order by lannumber limit 1 (WAIT TIME 133 ms.) 16/08/2025 22:01:56.5474 2846 ms. OPEN: select * from tablanguages where lanStatus='V' order by lannumber limit 1 (WAIT TIME 133 ms.) 16/08/2025 22:01:56.5484 19440 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 3 (WAIT TIME 133 ms.) 16/08/2025 22:01:56.5494 19444 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 3 (WAIT TIME 132 ms.) 16/08/2025 22:01:56.5574 19444 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 5 (WAIT TIME 138 ms.) 16/08/2025 22:01:56.5604 1829 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 3 (WAIT TIME 139 ms.) 16/08/2025 22:01:56.5624 1827 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 1 (WAIT TIME 139 ms.) 16/08/2025 22:01:56.5634 2842 ms. OPEN: select * from tablanguages where lanStatus='V' order by lannumber limit 1 (WAIT TIME 145 ms.) 16/08/2025 22:01:56.7195 3133 ms. OPEN: select * from tabUserMessage where useMesDescr = 'err_invaliduser' and (useLanCode = 'en-US' or mid(useLanCode,1,2) = 'en') 16/08/2025 22:01:57.6621 770 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 1 and terStatus='V' 16/08/2025 22:01:57.6811 586 ms. OPEN: select * from tabArea where areStatus='V' and areEnabled = 1 AND areId = 1 16/08/2025 22:01:57.6851 685 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 1 16/08/2025 22:01:57.8432 843 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 2 OR lnsTerId=2) 16/08/2025 22:01:57.8432 843 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 3 OR lnsTerId=3)