06/07/2025 19:58:19.6420 8166 ms. EXECSCALAR: select count(*) from information_schema.tables where table_schema= 'wisepark_0327' and table_name= 'movTransitId' nr: 1 06/07/2025 19:58:19.8561 8380 ms. OPEN: show columns from tabParameters where Field = 'parUseCulture' 06/07/2025 19:58:19.8621 8399 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 3 06/07/2025 19:58:19.8621 8400 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 1 06/07/2025 19:58:19.8631 8410 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 2 06/07/2025 19:58:19.8651 8403 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 1 06/07/2025 19:58:19.8681 8415 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 5 06/07/2025 19:58:19.8691 8399 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 2 06/07/2025 19:58:19.8701 8412 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 1 06/07/2025 19:58:19.9972 8539 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 2 06/07/2025 19:58:19.9972 8522 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 5 06/07/2025 19:58:20.0052 8538 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 2 (WAIT TIME 3 ms.) 06/07/2025 19:58:20.0062 8529 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 2 (WAIT TIME 1 ms.) 06/07/2025 19:58:20.0072 8543 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 3 06/07/2025 19:58:20.0082 8532 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 3 06/07/2025 19:58:20.0092 8553 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 1 06/07/2025 19:58:20.0102 8545 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 3 06/07/2025 19:58:20.0102 8551 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 5 06/07/2025 19:58:20.0112 8554 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 1 06/07/2025 19:58:20.0112 8556 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 2 06/07/2025 19:58:20.0122 8535 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 5 (WAIT TIME 14 ms.) 06/07/2025 19:58:20.0122 8550 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 5 06/07/2025 19:58:20.0122 8535 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 1 (WAIT TIME 13 ms.) 06/07/2025 19:58:20.0132 8553 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 5 06/07/2025 19:58:21.4061 680 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; 06/07/2025 19:58:21.4061 675 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; 06/07/2025 19:58:22.3058 778 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 = 2))) order by tagName 06/07/2025 19:58:22.3068 779 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 = 2))) order by tagName 06/07/2025 19:58:22.3229 1147 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 06/07/2025 19:58:22.3779 588 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 = 2))) order by tagName 06/07/2025 19:58:29.0901 5213 ms. OPEN: SELECT * FROM movLinks INNER JOIN movTransit on traUID = mliTraUID WHERE mliRFIDCode = '458427175800327005031999' AND mliStatus='V' ORDER BY mliId DESC LIMIT 1 06/07/2025 19:58:29.0901 9446 ms. OPEN: SELECT traCode FROM movTransit WHERE traId = '973485' and traDirection='I' order by traId DESC LIMIT 1 06/07/2025 19:58:29.2184 5446 ms. OPEN: SELECT * FROM movLinks INNER JOIN movTransit on traUID = mliTraUID WHERE mliRFIDCode = '458426579500327005012999' AND mliStatus='V' ORDER BY mliId DESC LIMIT 1 06/07/2025 19:58:30.5864 963 ms. OPEN: select * from tabUserMessage where useMesDescr = 'err_ticketnotfound' and (useLanCode = 'en-US' or mid(useLanCode,1,2) = 'en') 06/07/2025 19:58:31.4983 10561 ms. EXECSCALAR: SELECT count(*) FROM payinventory WHERE invValue<>0 AND invType='' nr: 0 06/07/2025 19:58:31.9003 2171 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-07-06 19:58:29','V',5062603212175970,2025,'2025-07-06 15:34:58','458426579500327005012999',1,1,2,'O','',1,0,1,'','',0) 06/07/2025 19:58:31.9003 723 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-07-06 19:58:31','V',5702578601302130,2025,'2025-07-06 19:55:58','458427175800327005031999',1,2,16,'I','',1,0,1,'','',4) 06/07/2025 19:58:32.3968 793 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 = '458427069100327001012999' and traStatus='V' and casStatus='V' and terType=3 and casTotAmount>0 06/07/2025 19:58:33.2590 1348 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 06/07/2025 19:58:35.4949 3096 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 = '458427069100327001012999' AND traStatus='V' AND payStatus='V' and (terType IS NULL OR terType<>3 OR (terType=3 and payType='P')) 06/07/2025 19:58:36.1627 4661 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 06/07/2025 19:58:37.4994 1334 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); 06/07/2025 19:59:15.9312 824 ms. OPEN: select * from movTransit where traStatus='V' and traCode = '0098788191894' and traDirection='I' order by traId desc limit 1 06/07/2025 19:59:35.4492 1836 ms. EXEC: insert into payReceipt (recTraUID,recPayUID,recYear,recDateTime,recText,recInvalid) VALUES (5201599905367540,4752963165774270,2025,'2025-07-06 19:59:33',' Date: 7/6/2025 7:59:33 PM Code: 458427074400327005012999 Entry Date: 7/6/2025 7:39:04 PM Plate: Class: Cars Park: The Mall Gate: Entry 2 ______________________________ Total: 50.00 KES ______________________________ Paid: 50.00 KES __________ Change: 0.00 KES Type: Cash Dispozitiv: MPESA # 2500725566 ',0) 06/07/2025 20:02:28.6902 17782 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 06/07/2025 20:05:34.0696 1989 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 06/07/2025 20:07:57.1988 2339 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 06/07/2025 21:12:56.3448 1693 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 06/07/2025 21:15:46.3533 509 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2025-07-06 21:15:45',3,42101,0,50,1,50,1,'I','N'); update payCurInventory set curQuantity=round(curQuantity+1,5),curAmount=round(curAmount+50,5) where curTerId = 3 and curDevCode = 42101 and curChannelId = 1 and curValue = 50 and curType = 'N'; 06/07/2025 22:15:56.6871 2001 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