20/08/2025 09:45:29.7818 949 ms. OPEN: select traId,traDateTime,traEnabled,traDisableTime,traCode,traBadge,traCarId,traAreId,traIdTerminal from movtransit where traStatus='V' and traDirection = 'I' and traCarId = 82 order by traDateTime desc,traId desc 20/08/2025 10:23:42.4890 894 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 20/08/2025 10:29:02.8788 624 ms. EXEC: INSERT INTO opeActivities (acvCreation,acvUseId,acvTerId,acvOpeUseId,acvSuperUseId,acvCodeId,acvTypeId,acvDateTime,acvSftId,acvCausal) VALUES (@ACVCREATION,@ACVUSEID,@ACVTERID,@ACVOPEUSEID,@ACVSUPERUSEID,@ACVCODEID,@ACVTYPEID,@ACVDATETIME,@ACVSFTID,@ACVCAUSAL) 20/08/2025 10:29:05.0225 2084 ms. EXEC: INSERT INTO opeActivities (acvCreation,acvUseId,acvTerId,acvOpeUseId,acvSuperUseId,acvCodeId,acvTypeId,acvDateTime,acvSftId,acvCausal) VALUES (@ACVCREATION,@ACVUSEID,@ACVTERID,@ACVOPEUSEID,@ACVSUPERUSEID,@ACVCODEID,@ACVTYPEID,@ACVDATETIME,@ACVSFTID,@ACVCAUSAL) 20/08/2025 11:18:44.6074 549 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-20 11:19:33',1,'V',4978243887417870,4755234265072260,2025,'2025-08-20 11:19:33',4,1,0,4,'2025-08-20 11:34:33','P','KES',100,100,0,'','','',1,100,0,0,'',0,0) 20/08/2025 11:18:45.8335 1217 ms. EXEC: insert into movOperator (opeCreation,opeTerId,opeUseId,opeDateTime,opeCode,opeDescription) VALUES ('2025-08-20 11:18:44',4,1,'2025-08-20 11:18:44','458873222800327005012999','Payed (Credit Card ) Ticket ') 20/08/2025 11:23:27.2377 520 ms. EXEC: insert into payReceipt (recTraUID,recPayUID,recYear,recDateTime,recText,recInvalid) VALUES (4939824744475440,5455963689040370,2025,'2025-08-20 11:23:26','---------------------------------- %The Mall P0006032390 Canceled payment ---------------------------------- POF Entry : 8/20/2025 10:58:26 AM Date : 8/20/2025 11:23:25 AM Code : 458873950600327005012999 Total : 50.00 KES VAT 16% : 6.90 KES ---------------------------------- Paid : 0.00 KES Coin changed : 0.00 KES Note changed : 0.00 KES Not changed Note : 0.00 KES Coin : 0.00 KES Unavailable : 0.00 KES',1) 20/08/2025 11:41:55.2195 1296 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 20/08/2025 11:47:13.6544 630 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 (WAIT TIME 1 ms.) 20/08/2025 11:57:01.4744 761 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2025-08-20 11:57:00' where payTraUID = 4709435395597560 and payStatus='V' and payEnabled=1 20/08/2025 12:47:47.4835 761 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 20/08/2025 13:49:57.0585 4711 ms. EXECSCALAR: select count(traId) as Tot from movTransit where traStatus='V' and traEnabled=1 and traCarId=0 and traAreId = 1 and traUID not in (select payTraUID from paypayment where payStatus='V') nr: 28848 20/08/2025 13:49:58.1672 1107 ms. OPEN: select * from movTransit where traStatus='V' and traEnabled=1 and traCarId=0 and traAreId = 1 and traUID not in (select payTraUID from paypayment where payStatus='V') order by traId 20/08/2025 14:32:44.7050 512 ms. OPEN: select traId,traDateTime,traEnabled,traDisableTime,traCode,traBadge,traCarId,traAreId,traIdTerminal from movtransit where traStatus='V' and traDirection = 'I' and traCarId = 41 order by traDateTime desc,traId desc 20/08/2025 14:49:08.5021 672 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 20/08/2025 15:10:06.9990 2012 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 20/08/2025 15:10:08.3712 1358 ms. OPEN: select traId,traDateTime,traEnabled,traDisableTime,traCode,traBadge,traCarId,traAreId,traIdTerminal from movtransit where traStatus='V' and traDirection = 'O' and traCarId = 15 order by traDateTime desc,traId desc 20/08/2025 15:10:32.1662 558 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2025-08-20 15:10:31' where traUID = 5155294373967270 and traStatus='V' and traEnabled=1 20/08/2025 15:45:22.7478 707 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 20/08/2025 16:09:06.9666 19324 ms. OPEN: select * from tablanguages where lanStatus='V' order by lannumber limit 1 20/08/2025 16:09:07.0057 19317 ms. OPEN: show columns from tabParameters where Field = 'parAllowNegativePlaces' (WAIT TIME 39 ms.) 20/08/2025 16:09:07.9743 803 ms. OPEN: show columns from movLinks where Field = 'mliReceiptMessage' 20/08/2025 16:09:07.9763 783 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; 20/08/2025 16:09:15.0150 6157 ms. EXECSCALAR: SELECT count(*) FROM payinventory WHERE invValue<>0 AND invType='' nr: 0 20/08/2025 16:09:16.8216 6550 ms. OPEN: SELECT * FROM movLinks INNER JOIN movTransit on traUID = mliTraUID WHERE mliRFIDCode = '0347899501593' AND mliStatus='V' ORDER BY mliId DESC LIMIT 1 20/08/2025 16:09:16.8246 5352 ms. OPEN: SELECT * FROM movLinks INNER JOIN movTransit on traUID = mliTraUID WHERE mliRFIDCode = '458875796300327005031999' AND mliStatus='V' ORDER BY mliId DESC LIMIT 1 20/08/2025 16:09:18.0134 504 ms. OPEN: select * from tabUserMessage where useMesDescr = 'err_ticketDisabled' and (useLanCode = 'en-US' or mid(useLanCode,1,2) = 'en') 20/08/2025 16:09:20.3419 5323 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 20/08/2025 16:09:20.4960 1717 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 16:09:18','V',4869724916721190,2025,'2025-08-20 16:06:04','458875796300327005031999',1,2,16,'I','',1,0,1,'','',4) 20/08/2025 16:09:20.4980 2253 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-20 16:09:18','V',5181245668236700,2025,'2025-08-20 16:05:19','458875609500327002029999',2,1,2,'O','',1,0,1,'','1882553298969',107,0) 20/08/2025 16:09:22.0781 1564 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 20/08/2025 16:09:22.0781 1564 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 20/08/2025 16:09:23.3619 3019 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); 20/08/2025 16:09:48.5188 717 ms. EXECSCALAR: select count(payId) from paypayment where payStatus='V' and payIdTerminal = 4 and payDateTime = '2014-01-01 00:03:41' nr: 0 20/08/2025 16:22:31.4340 748 ms. OPEN: select traId,traDateTime,traEnabled,traDisableTime,traCode,traBadge,traCarId,traAreId,traIdTerminal from movtransit where traStatus='V' and traDirection = 'I' and traCarId = 160 order by traDateTime desc,traId desc 20/08/2025 16:25:15.7166 3491 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 20/08/2025 16:25:26.0356 2024 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 16:39:53.4777 981 ms. OPEN: select traId,traDateTime,traEnabled,traDisableTime,traCode,traBadge,traCarId,traAreId,traIdTerminal from movtransit where traStatus='V' and traDirection = 'I' and traCarId = 19 order by traDateTime desc,traId desc 20/08/2025 16:39:54.1672 558 ms. EXEC: insert into abbPayment (payCreation,payCode,payAmount,payCredit,payPayUID,payCarId,payDateFrom,payDateTo) VALUES ('2025-08-20 16:39:53','0230003950907',0,0,5051192008122350,19,'0000-00-00 00:00:00','0000-00-00 00:00:00') 20/08/2025 16:53:17.8574 806 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 17:11:53.3816 15529 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 20/08/2025 17:15:24.7534 504 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 20/08/2025 17:17:12.3618 612 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 20/08/2025 17:36:10.0721 1909 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 17:40:20.3964 665 ms. EXEC: insert into payReceipt (recTraUID,recPayUID,recYear,recDateTime,recText,recInvalid) VALUES (5675519536982060,5288245286943640,2025,'2025-08-20 17:40:19',' Date: 1/1/2014 1:36:26 AM Code: 458876205100327005012999 Entry Date: 8/20/2025 5:14:11 PM Plate: Class: Cars Park: The Mall Gate: Entry 2 ______________________________ Total: 50.00 KES ______________________________ Paid: 50.00 KES __________ Change: 0.00 KES Type: Credit Card Dispozitiv: Manual Cashier 1 # 2500411869 ',0) 20/08/2025 17:43:19.8061 602 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 20/08/2025 19:19:51.9102 2333 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 21:09:00.6089 3207 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 1 20/08/2025 21:09:00.7830 3196 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 2 20/08/2025 21:09:00.7840 2195 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 20/08/2025 21:09:00.7880 2548 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 20/08/2025 21:09:00.7890 2477 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 20/08/2025 21:09:00.7910 2503 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 20/08/2025 21:09:00.8141 2911 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 1 20/08/2025 21:09:00.8151 2926 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 1 20/08/2025 21:09:00.8161 2015 ms. OPEN: select * from tabuser where useStatus='V' order by useId 20/08/2025 21:09:00.8161 2327 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 1 20/08/2025 21:09:00.8171 2800 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 1 20/08/2025 21:09:00.8191 3118 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 2 20/08/2025 21:09:01.0702 2761 ms. OPEN: select * from tabArea where areId = 0 20/08/2025 21:09:01.2534 3554 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 20/08/2025 21:09:01.2574 3669 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 20/08/2025 21:09:01.8277 532 ms. EXEC: insert into payCurInventory (curTerId,curDevCode,curDevDescription,curChannelId,curChannelDescr,curValue,curType) SELECT * FROM (SELECT 3,42101,'Notes Escrow',1 as c1,'Payout',5 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 = 5 and curType = 'N' LIMIT 1) 20/08/2025 21:09:02.6483 773 ms. EXECSCALAR: select count(0) as vTot from tabParameters where parPlateReading<>0 nr: 0 20/08/2025 21:09:02.8564 510 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; 20/08/2025 21:09:13.1298 14042 ms. OPEN: SELECT * FROM movLinks INNER JOIN movTransit on traUID = mliTraUID WHERE mliRFIDCode = '0098788346375' AND mliStatus='V' ORDER BY mliId DESC LIMIT 1 20/08/2025 21:09:13.2488 14217 ms. OPEN: select * from movtransit where trastatus='V' and (traCode = '1005114') and traDirection='I' order by traId desc limit 1 20/08/2025 21:09:15.0270 1774 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 = '1005114' and traStatus='V' and casStatus='V' and terType=3 and casTotAmount>0 20/08/2025 21:09:16.3811 1942 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-20 21.09.14','V',5037483095737130,2025,'2025-08-20 21.06.52','458877304500327002029999',2,1,2,'O','',1,0,1,'','0532370831879',165,0) 20/08/2025 21:09:18.7087 3680 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 = '1005114' AND traStatus='V' AND payStatus='V' and (terType IS NULL OR terType<>3 OR (terType=3 and payType='P')) 20/08/2025 21:09:58.8872 28326 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:10:00.7594 28909 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:59:11.5522 1604 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 2 20/08/2025 22:59:11.5732 1856 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 1 (WAIT TIME 20 ms.) 20/08/2025 22:59:11.5742 1669 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 1 (WAIT TIME 19 ms.) 20/08/2025 22:59:11.5752 1814 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 2 (WAIT TIME 18 ms.) 20/08/2025 22:59:11.5752 1775 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 1 (WAIT TIME 18 ms.) 20/08/2025 22:59:11.5762 1675 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 2 (WAIT TIME 1 ms.) 20/08/2025 22:59:11.5762 1733 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 5 (WAIT TIME 18 ms.) 20/08/2025 22:59:11.5762 1547 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 5 (WAIT TIME 17 ms.) 20/08/2025 22:59:11.5762 1843 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 2 (WAIT TIME 16 ms.) 20/08/2025 22:59:11.5762 1583 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 1 (WAIT TIME 24 ms.) 20/08/2025 22:59:11.5782 1726 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 1 (WAIT TIME 20 ms.) 20/08/2025 22:59:11.5822 1757 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 2 (WAIT TIME 23 ms.) 20/08/2025 22:59:11.5832 1765 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 5 (WAIT TIME 23 ms.) 20/08/2025 22:59:11.5872 1799 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 1 (WAIT TIME 26 ms.) 20/08/2025 22:59:11.5882 1850 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 2 (WAIT TIME 36 ms.) 20/08/2025 22:59:11.5882 1637 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 5 (WAIT TIME 35 ms.) 20/08/2025 22:59:11.5892 1832 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 5 (WAIT TIME 35 ms.) 20/08/2025 22:59:11.5892 1820 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 5 (WAIT TIME 32 ms.) 20/08/2025 22:59:11.6732 2019 ms. OPEN: show columns from movLinks where Field = 'mliReceiptMessage' 20/08/2025 22:59:12.5227 677 ms. OPEN: select * from tabLanguages where lanStatus='V' order by lanNumber 20/08/2025 22:59:12.7759 835 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 20/08/2025 22:59:12.7769 555 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 20/08/2025 22:59:13.3642 576 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 20/08/2025 22:59:13.7434 1422 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 16 OR lnsTerId=16) 20/08/2025 22:59:13.7444 1423 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 2 OR lnsTerId=2) 20/08/2025 22:59:13.7444 1424 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 16 OR lnsTerId=16) 20/08/2025 22:59:13.7514 1430 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 1 ms.) 20/08/2025 22:59:13.7775 1211 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 3 OR lnsTerId=3) 20/08/2025 22:59:13.7775 1457 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 16 OR lnsTerId=16) 20/08/2025 22:59:13.7795 1457 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 2 OR lnsTerId=2) 20/08/2025 22:59:13.7795 1459 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 1 OR lnsTerId=1) 20/08/2025 22:59:13.7805 1460 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 1 OR lnsTerId=1) 20/08/2025 22:59:13.7865 1024 ms. OPEN: select * from tabCurrency where curStatus='V' and curCode = 'EUR' 20/08/2025 22:59:14.2197 1474 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 3 OR lnsTerId=3) 20/08/2025 22:59:14.3228 537 ms. EXEC: update tabTerminal set terVersion = 'Parking_project V.1.6.2 (BETA 44) Jul 25 2017 12:08:13.31061.20170725082637' where terId = 3 20/08/2025 22:59:14.3238 522 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; 20/08/2025 22:59:14.4478 1083 ms. OPEN: select * from tabUser where useStatus='V' and useBadId<>'' and useParkAccess<>0 order by useSuperUser desc,useId 20/08/2025 22:59:14.6129 881 ms. OPEN: select * from payCurInventory where curTerId = 0 and curQuantity>0 and curType in ('C','N') order by curDevCode,curChannelId,curValue 20/08/2025 22:59:14.6600 872 ms. OPEN: select * from tabDevInstalled inner join tabTerminal on terId = insTerId inner join tabDevice on devId = insDevId where terId = 0 and devCode>40001 and devCode<49999 and devStatus='V' and insStatus='V' 20/08/2025 22:59:14.6720 806 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 21.59.13') OR resConfirmed IN (4,5)) and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) <= '2025-08-20 22.59.12' and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) >= '2025-08-20 22.59.12' and (resAreId = 1 or resAreId <= 0) nr: 0 20/08/2025 22:59:14.6750 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 21.59.13') OR resConfirmed IN (4,5)) and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) <= '2025-08-20 22.59.12' and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) >= '2025-08-20 22.59.12' and (resAreId = 1 or resAreId <= 0) nr: 0 20/08/2025 22:59:14.6770 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 21.59.13') OR resConfirmed IN (4,5)) and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) <= '2025-08-20 22.59.12' and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) >= '2025-08-20 22.59.12' and (resAreId = 1 or resAreId <= 0) nr: 0 20/08/2025 22:59:14.6860 815 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 21.59.13') OR resConfirmed IN (4,5)) and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) <= '2025-08-20 22.59.12' and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) >= '2025-08-20 22.59.12' and (resAreId = 1 or resAreId <= 0) nr: 0 (WAIT TIME 7 ms.) 20/08/2025 23:00:50.8575 21244 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 20/08/2025 23:01:02.6753 548 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 20/08/2025 23:01:40.3337 2257 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:01:41.0096 511 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 = '458877114800327005012999' and traStatus='V' and casStatus='V' and terType=3 and casTotAmount>0