08/08/2025 12:38:56.7775 590 ms. EXEC: update abbCards set carLastDate = '2025-08-08 12:38:56',carLastDirection='O' where carStatus='V' and carId = 165 08/08/2025 13:32:17.9009 580 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 08/08/2025 13:44:11.8079 720 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2025-08-08 13:44:10',3,42101,0,50,-1,-50,1,'O','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'; Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2025-08-08 13:44:10',3,42101,0,100,-2,-200,1,'O','N'); update payCurInventory set curQuantity=round(curQuantity+-2,5),curAmount=round(curAmount+-200,5) where curTerId = 3 and curDevCode = 42101 and curChannelId = 1 and curValue = 100 and curType = 'N'; Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2025-08-08 13:44:10',3,42101,0,200,-1,-200,1,'O','N'); update payCurInventory set curQuantity=round(curQuantity+-1,5),curAmount=round(curAmount+-200,5) where curTerId = 3 and curDevCode = 42101 and curChannelId = 1 and curValue = 200 and curType = 'N'; 08/08/2025 17:14:30.9230 620 ms. EXEC: update opeActivities set acvFstPayId = (case acvFstPayId when 0 then 468016 else acvFstPayId end),acvLstPayId = 468016 where acvSftId = 1121 and acvCodeId = 3 08/08/2025 17:57:36.2567 1268 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-08 17:57:34','V',5667072065447290,2025,'2025-08-08 17:57:34','458756302000327005012999',2,2,2,'O','',0,'2025-08-08 17:57:34',1,'','',0) 08/08/2025 18:20:56.4955 30421 ms. OPEN: select * from tablanguages where lanStatus='V' order by lannumber limit 1 08/08/2025 18:20:56.5075 30412 ms. OPEN: show columns from tabParameters where Field = 'parAllowNegativePlaces' (WAIT TIME 3 ms.) 08/08/2025 18:20:58.4648 547 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-08 17.20.57') OR resConfirmed IN (4,5)) and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) <= '2025-08-08 18.20.57' and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) >= '2025-08-08 18.20.57' and (resAreId = 1 or resAreId <= 0) nr: 0 08/08/2025 18:20:58.4648 540 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-08 17.20.57') OR resConfirmed IN (4,5)) and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) <= '2025-08-08 18.20.57' and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) >= '2025-08-08 18.20.57' and (resAreId = 1 or resAreId <= 0) nr: 0 08/08/2025 18:20:58.4658 539 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-08 17.20.57') OR resConfirmed IN (4,5)) and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) <= '2025-08-08 18.20.57' and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) >= '2025-08-08 18.20.57' and (resAreId = 1 or resAreId <= 0) nr: 0 08/08/2025 18:20:58.4678 552 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-08 17.20.57') OR resConfirmed IN (4,5)) and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) <= '2025-08-08 18.20.57' and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) >= '2025-08-08 18.20.57' and (resAreId = 1 or resAreId <= 0) nr: 0 08/08/2025 18:20:58.4708 576 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-08 17.20.57') OR resConfirmed IN (4,5)) and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) <= '2025-08-08 18.20.57' and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) >= '2025-08-08 18.20.57' and (resAreId = 1 or resAreId <= 0) nr: 0 08/08/2025 18:20:58.4758 559 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-08 17.20.57') OR resConfirmed IN (4,5)) and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) <= '2025-08-08 18.20.57' and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) >= '2025-08-08 18.20.57' and (resAreId = 1 or resAreId <= 0) nr: 0 08/08/2025 18:20:58.4758 580 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-08 17.20.57') OR resConfirmed IN (4,5)) and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) <= '2025-08-08 18.20.57' and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) >= '2025-08-08 18.20.57' and (resAreId = 1 or resAreId <= 0) nr: 0 08/08/2025 18:20:58.4778 562 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-08 17.20.57') OR resConfirmed IN (4,5)) and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) <= '2025-08-08 18.20.57' and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) >= '2025-08-08 18.20.57' and (resAreId = 1 or resAreId <= 0) nr: 0 08/08/2025 18:20:58.4808 568 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-08 17.20.57') OR resConfirmed IN (4,5)) and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) <= '2025-08-08 18.20.57' and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) >= '2025-08-08 18.20.57' and (resAreId = 1 or resAreId <= 0) nr: 0 08/08/2025 18:20:58.4848 570 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-08 17.20.57') OR resConfirmed IN (4,5)) and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) <= '2025-08-08 18.20.57' and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) >= '2025-08-08 18.20.57' and (resAreId = 1 or resAreId <= 0) nr: 0 08/08/2025 18:20:58.4858 570 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-08 17.20.57') OR resConfirmed IN (4,5)) and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) <= '2025-08-08 18.20.57' and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) >= '2025-08-08 18.20.57' and (resAreId = 1 or resAreId <= 0) nr: 0 08/08/2025 18:20:58.4868 575 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-08 17.20.57') OR resConfirmed IN (4,5)) and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) <= '2025-08-08 18.20.57' and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) >= '2025-08-08 18.20.57' and (resAreId = 1 or resAreId <= 0) nr: 0 08/08/2025 18:21:12.1841 12248 ms. OPEN: SELECT * FROM movLinks INNER JOIN movTransit on traUID = mliTraUID WHERE mliRFIDCode = '458756591100327005031999' AND mliStatus='V' ORDER BY mliId DESC LIMIT 1 08/08/2025 18:21:12.3913 14224 ms. EXECSCALAR: SELECT count(*) FROM payinventory WHERE invValue<>0 AND invType='' nr: 0 08/08/2025 18:21:13.7562 628 ms. OPEN: select * from tabUserMessage where useMesDescr = 'err_ticketnotfound' and (useLanCode = 'en-US' or mid(useLanCode,1,2) = 'en') 08/08/2025 18:21:15.8846 1953 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-08 18.21.13','V',4924171086153800,2025,'2025-08-08 18.21.55','458756320500327002029999',2,1,2,'O','',1,0,1,'','0532370684453',218,0) 08/08/2025 18:21:15.9506 1356 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-08 18.21.14','V',5286306632122240,2025,'2025-08-08 18.18.31','458756591100327005031999',1,2,16,'I','',1,0,1,'','',4) 08/08/2025 18:21:17.5727 714 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 08/08/2025 18:21:17.7058 1749 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 08/08/2025 18:21:17.7088 5054 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 08/08/2025 18:21:17.7258 1826 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 08/08/2025 18:21:22.2253 4797 ms. EXECSCALAR: select count(payId) from paypayment where payStatus='V' and payIdTerminal = 4 and payDateTime = '2025-08-08 18.20.58' nr: 0 08/08/2025 18:21:22.2563 4547 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); 08/08/2025 18:21:22.9498 630 ms. EXEC: UPDATE payInventory SET invType='N' WHERE invType<>'N' AND invValue IN (100,200,500) AND invDevice IN (42102,42101,42001); 08/08/2025 18:21:24.7049 1577 ms. EXEC: insert into movOperator (opeCreation,opeTerId,opeUseId,opeDateTime,opeCode,opeDescription) VALUES ('2025-08-08 18.21.23',4,1,'2025-08-08 18.21.23','458756500600327005012999','Payed (Cash ) Ticket ') 08/08/2025 18:21:26.7633 6736 ms. OPEN: select traId,traDateTime,traEnabled,traDisableTime,traCode,traBadge,traCarId,traAreId,traIdTerminal from movtransit where traStatus='V' and traDirection = 'I' and traCarId = 186 order by traDateTime desc,traId desc 08/08/2025 18:21:28.2683 707 ms. OPEN: SELECT SUM(vTot) as vTot,payTimeLimit FROM (SELECT SUM(payPayed)-SUM(payChange) AS vTot,MAX(payTimeLimit) AS payTimeLimit FROM payPayment INNER JOIN movtransit ON movtransit.traUID=payPayment.payTraUID WHERE traCode = '0560008512164' AND traStatus='V' AND payStatus='V' AND payIdEvent<90 GROUP BY payId ORDER BY payEnabled DESC, payTimeLimit DESC) as v1 08/08/2025 18:21:29.0498 1623 ms. EXEC: insert into payReceipt (recTraUID,recPayUID,recYear,recDateTime,recText,recInvalid) VALUES (5670226001974690,4751883113470200,2025,'2025-08-08 18.21.27',' Date: 08/08/2025 18.20.58 Code: 458756500600327005012999 Entry Date: 08/08/2025 18.03.26 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) 08/08/2025 18:21:29.8306 1128 ms. OPEN: show columns from abbPayment where Field = 'payCarId' 08/08/2025 18:22:33.5701 737 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 08/08/2025 18:27:02.9220 2362 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 08/08/2025 19:09:14.1032 2837 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 08/08/2025 19:10:13.8340 3612 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 08/08/2025 19:10:19.4431 17450 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 = 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)) order by traUIDGroup,payAmount, traType, traDiscountValue, traDiscountType 08/08/2025 19:39:24.6798 590 ms. OPEN: select traId,traDateTime,traEnabled,traDisableTime,traCode,traBadge,traCarId,traAreId,traIdTerminal from movtransit where traStatus='V' and traDirection = 'I' and traCarId = 111 order by traDateTime desc,traId desc 08/08/2025 20:12:24.8214 652 ms. EXEC: insert into payReceipt (recTraUID,recPayUID,recYear,recDateTime,recText,recInvalid) VALUES (5629317335465480,5572285709460360,2025,'2025-08-08 20.12.24',' Data: 08/08/2025 20.11.45 Codice: 458756883800327005012999 Ingresso: 08/08/2025 19.07.18 Targa: Categoria: Cars Area: The Mall Varco: Entry 2 ______________________________ Da Pagare: 100.00 KES ______________________________ Pagato: 100.00 KES __________ Resto: 0.00 KES Tipo: Contanti Pagato su: Manual Cashier 2 # 2500606007 ',0) 08/08/2025 21:46:11.2864 521 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 08/08/2025 22:06:20.7299 2006 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