11/09/2025 09:36:47.8604 22082 ms. OPEN: show columns from tabParameters where Field = 'parUseCulture' 11/09/2025 09:36:48.0396 2566 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 3 11/09/2025 09:36:48.0396 22256 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 3 11/09/2025 09:36:48.0406 2031 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 2 11/09/2025 09:36:48.0406 22254 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 1 11/09/2025 09:36:48.0426 2050 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 1 11/09/2025 09:36:48.0426 22258 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 2 11/09/2025 09:36:48.0446 2036 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 2 11/09/2025 09:36:48.0446 22258 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 2 11/09/2025 09:36:48.0456 22259 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 3 11/09/2025 09:36:48.0466 22262 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 3 11/09/2025 09:36:48.0476 22262 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 2 11/09/2025 09:36:48.0476 2573 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 1 11/09/2025 09:36:48.0486 22264 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 3 11/09/2025 09:36:48.0506 22263 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 5 11/09/2025 09:36:48.0506 1978 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 1 11/09/2025 09:36:48.0516 22268 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 5 11/09/2025 09:36:48.0516 22266 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 5 11/09/2025 09:36:48.0526 22268 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 5 11/09/2025 09:36:48.0546 22270 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 3 11/09/2025 09:36:48.0836 22270 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 5 (WAIT TIME 28 ms.) 11/09/2025 09:36:48.0846 2096 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 2 (WAIT TIME 28 ms.) 11/09/2025 09:36:48.0896 1976 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 1 (WAIT TIME 35 ms.) 11/09/2025 09:36:48.0906 2586 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 5 (WAIT TIME 36 ms.) 11/09/2025 09:36:49.6306 718 ms. OPEN: select * from tabCurrency where curStatus='V' and curCode = 'KES' (WAIT TIME 28 ms.) 11/09/2025 09:36:50.3701 612 ms. EXECSCALAR: select count(resId) as Tot from movReservation where resStatus = 'V' and resTypeRes = 'B' AND ((resConfirmed IN (0,2,3) AND resCreation>'2025-09-11 08:36:49') OR resConfirmed IN (4,5)) and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) <= '2025-09-11 09:36:49' and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) >= '2025-09-11 09:36:49' and (resAreId = 1 or resAreId <= 0) nr: 0 11/09/2025 09:36:50.3791 616 ms. EXECSCALAR: select count(resId) as Tot from movReservation where resStatus = 'V' and resTypeRes = 'B' AND ((resConfirmed IN (0,2,3) AND resCreation>'2025-09-11 08:36:49') OR resConfirmed IN (4,5)) and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) <= '2025-09-11 09:36:48' and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) >= '2025-09-11 09:36:48' and (resAreId = 1 or resAreId <= 0) nr: 0 11/09/2025 09:36:50.3801 621 ms. EXECSCALAR: select count(resId) as Tot from movReservation where resStatus = 'V' and resTypeRes = 'B' AND ((resConfirmed IN (0,2,3) AND resCreation>'2025-09-11 08:36:49') OR resConfirmed IN (4,5)) and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) <= '2025-09-11 09:36:48' and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) >= '2025-09-11 09:36:48' and (resAreId = 1 or resAreId <= 0) nr: 0 11/09/2025 09:36:50.3831 623 ms. EXECSCALAR: select count(resId) as Tot from movReservation where resStatus = 'V' and resTypeRes = 'B' AND ((resConfirmed IN (0,2,3) AND resCreation>'2025-09-11 08:36:49') OR resConfirmed IN (4,5)) and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) <= '2025-09-11 09:36:49' and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) >= '2025-09-11 09:36:49' and (resAreId = 1 or resAreId <= 0) nr: 0 11/09/2025 09:36:50.3891 623 ms. EXECSCALAR: select count(resId) as Tot from movReservation where resStatus = 'V' and resTypeRes = 'B' AND ((resConfirmed IN (0,2,3) AND resCreation>'2025-09-11 08:36:49') OR resConfirmed IN (4,5)) and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) <= '2025-09-11 09:36:49' and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) >= '2025-09-11 09:36:49' and (resAreId = 1 or resAreId <= 0) nr: 0 (WAIT TIME 2 ms.) 11/09/2025 09:36:55.4565 1121 ms. OPEN: select * from tabClass where claPosition = 2 and claStatus='V' 11/09/2025 09:36:57.4200 6202 ms. OPEN: SELECT * FROM movLinks INNER JOIN movTransit on traUID = mliTraUID WHERE mliRFIDCode = '0098788346375' AND mliStatus='V' ORDER BY mliId DESC LIMIT 1 11/09/2025 09:36:57.4210 7080 ms. OPEN: SELECT * FROM movLinks INNER JOIN movTransit on traUID = mliTraUID WHERE mliRFIDCode = '0098788191894' AND mliStatus='V' ORDER BY mliId DESC LIMIT 1 11/09/2025 09:36:57.4280 5910 ms. OPEN: SELECT * FROM movLinks INNER JOIN movTransit on traUID = mliTraUID WHERE mliRFIDCode = '459093449300327001031999' AND mliStatus='V' ORDER BY mliId DESC LIMIT 1 11/09/2025 09:36:57.4690 1654 ms. OPEN: select traCode from movTransit where traCode ='459093461400327005012999' 11/09/2025 09:36:58.5467 8907 ms. EXECSCALAR: SELECT count(*) FROM payinventory WHERE invValue<>0 AND invType='' nr: 0 11/09/2025 09:36:58.8990 619 ms. OPEN: select * from tabUserMessage where useMesDescr = 'err_ticketnotfound' and (useLanCode = 'en-US' or mid(useLanCode,1,2) = 'en') 11/09/2025 09:36:59.6695 912 ms. OPEN: select * from abbCards inner join abbSubscriptions on carSubId = subId inner join tabCustomer on cusId = subCusId left join tabAbbGroups on cusAbgId = abgId where carStatus='V' and carId = 165 11/09/2025 09:37:00.3389 2233 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-09-11 09:36:58','V',4751816732871550,2025,'2025-09-11 09:36:54','459093461400327005012999',1,2,16,'I','',1,0,1,'','',4) 11/09/2025 09:37:00.3399 1311 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-09-11 09:36:59','V',4745474549674150,2025,'2025-09-11 09:34:53','459093449300327001031999',1,2,1,'I','',1,0,1,'','',4) 11/09/2025 09:37:00.3419 653 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-09-11 09:36:59','V',5396690208930650,2025,'2025-09-11 09:33:13','459093195800327005029999',2,2,16,'I','',1,0,1,'','0532370831879',165,0) 11/09/2025 09:37:01.5707 3292 ms. OPEN: select * from movTransit where traStatus='V' and traCode = '0098788191894' and traDirection='I' order by traId desc limit 1 11/09/2025 09:37:01.7719 1419 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 11/09/2025 09:37:01.7979 1445 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 11/09/2025 09:37:01.7979 1440 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 11/09/2025 09:37:01.8009 1444 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 11/09/2025 09:37:04.3366 5432 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 11/09/2025 09:37:04.6288 2710 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 = '459093461400327005012999' AND traStatus='V' AND payStatus='V' and (terType IS NULL OR terType<>3 OR (terType=3 and payType='P')) 11/09/2025 09:37:04.6398 2581 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 = '459090000200327003229999' AND traStatus='V' AND payStatus='V' and (terType IS NULL OR terType<>3 OR (terType=3 and payType='P')) 11/09/2025 09:37:06.0367 1699 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); 11/09/2025 09:37:11.0391 1284 ms. EXEC: insert into movOperator (opeCreation,opeTerId,opeUseId,opeDateTime,opeCode,opeDescription) VALUES ('2025-09-11 09:37:09',4,1,'2025-09-11 09:37:09','459093014800327005012999','Payed (Cash ) Ticket ') 11/09/2025 09:37:13.6468 811 ms. EXEC: insert into payReceipt (recTraUID,recPayUID,recYear,recDateTime,recText,recInvalid) VALUES (5594997865921130,5699229814697330,2025,'2025-09-11 09:37:12',' Date: 9/11/2025 9:33:02 AM Code: 459093014800327005012999 Entry Date: 9/11/2025 8:22:28 AM Plate: Class: Cars Park: The Mall Gate: Entry 2 ______________________________ Total: 0.00 KES ______________________________ Paid: 0.00 KES __________ Change: 0.00 KES Type: Cash Dispozitiv: Manual Cashier 1 ',1)