18/11/2024 13:21:14.0880 3009 ms. OPEN: show columns from tabParameters where Field = 'parAllowNegativePlaces' 18/11/2024 22:24:34.9715 21283 ms. OPEN: show columns from tabParameters where Field = 'parAllowNegativePlaces' 18/11/2024 22:24:36.7777 671 ms. OPEN: select * from tabCurrency where curStatus='V' and curCode = 'KES' 18/11/2024 22:24:38.0735 1142 ms. EXECSCALAR: select count(resId) as Tot from movReservation where resStatus = 'V' and resTypeRes = 'B' AND ((resConfirmed IN (0,2,3) AND resCreation>'2024-11-18 21:24:36') OR resConfirmed IN (4,5)) and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) <= '2024-11-18 22:24:36' and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) >= '2024-11-18 22:24:36' and (resAreId = 1 or resAreId <= 0) nr: 0 18/11/2024 22:24:38.0745 1141 ms. EXECSCALAR: select count(resId) as Tot from movReservation where resStatus = 'V' and resTypeRes = 'B' AND ((resConfirmed IN (0,2,3) AND resCreation>'2024-11-18 21:24:36') OR resConfirmed IN (4,5)) and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) <= '2024-11-18 22:24:36' and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) >= '2024-11-18 22:24:36' and (resAreId = 1 or resAreId <= 0) nr: 0 18/11/2024 22:24:38.0775 1143 ms. EXECSCALAR: select count(resId) as Tot from movReservation where resStatus = 'V' and resTypeRes = 'B' AND ((resConfirmed IN (0,2,3) AND resCreation>'2024-11-18 21:24:36') OR resConfirmed IN (4,5)) and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) <= '2024-11-18 22:24:36' and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) >= '2024-11-18 22:24:36' and (resAreId = 1 or resAreId <= 0) nr: 0 18/11/2024 22:24:38.0805 1142 ms. EXECSCALAR: select count(resId) as Tot from movReservation where resStatus = 'V' and resTypeRes = 'B' AND ((resConfirmed IN (0,2,3) AND resCreation>'2024-11-18 21:24:36') OR resConfirmed IN (4,5)) and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) <= '2024-11-18 22:24:36' and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) >= '2024-11-18 22:24:36' and (resAreId = 1 or resAreId <= 0) nr: 0 18/11/2024 22:24:38.0906 1146 ms. EXECSCALAR: select count(resId) as Tot from movReservation where resStatus = 'V' and resTypeRes = 'B' AND ((resConfirmed IN (0,2,3) AND resCreation>'2024-11-18 21:24:36') OR resConfirmed IN (4,5)) and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) <= '2024-11-18 22:24:36' and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) >= '2024-11-18 22:24:36' and (resAreId = 1 or resAreId <= 0) nr: 0 (WAIT TIME 10 ms.) 18/11/2024 22:24:38.0916 1143 ms. EXECSCALAR: select count(resId) as Tot from movReservation where resStatus = 'V' and resTypeRes = 'B' AND ((resConfirmed IN (0,2,3) AND resCreation>'2024-11-18 21:24:36') OR resConfirmed IN (4,5)) and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) <= '2024-11-18 22:24:36' and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) >= '2024-11-18 22:24:36' and (resAreId = 1 or resAreId <= 0) nr: 0 (WAIT TIME 10 ms.) 18/11/2024 22:24:38.0956 1146 ms. EXECSCALAR: select count(resId) as Tot from movReservation where resStatus = 'V' and resTypeRes = 'B' AND ((resConfirmed IN (0,2,3) AND resCreation>'2024-11-18 21:24:36') OR resConfirmed IN (4,5)) and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) <= '2024-11-18 22:24:36' and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) >= '2024-11-18 22:24:36' and (resAreId = 1 or resAreId <= 0) nr: 0 (WAIT TIME 14 ms.) 18/11/2024 22:24:38.0986 1145 ms. EXECSCALAR: select count(resId) as Tot from movReservation where resStatus = 'V' and resTypeRes = 'B' AND ((resConfirmed IN (0,2,3) AND resCreation>'2024-11-18 21:24:36') OR resConfirmed IN (4,5)) and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) <= '2024-11-18 22:24:36' and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) >= '2024-11-18 22:24:36' and (resAreId = 1 or resAreId <= 0) nr: 0 (WAIT TIME 15 ms.) 18/11/2024 22:24:38.1006 1149 ms. EXECSCALAR: select count(resId) as Tot from movReservation where resStatus = 'V' and resTypeRes = 'B' AND ((resConfirmed IN (0,2,3) AND resCreation>'2024-11-18 21:24:36') OR resConfirmed IN (4,5)) and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) <= '2024-11-18 22:24:36' and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) >= '2024-11-18 22:24:36' and (resAreId = 1 or resAreId <= 0) nr: 0 (WAIT TIME 17 ms.) 18/11/2024 22:24:38.1026 1144 ms. EXECSCALAR: select count(resId) as Tot from movReservation where resStatus = 'V' and resTypeRes = 'B' AND ((resConfirmed IN (0,2,3) AND resCreation>'2024-11-18 21:24:36') OR resConfirmed IN (4,5)) and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) <= '2024-11-18 22:24:36' and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) >= '2024-11-18 22:24:36' and (resAreId = 1 or resAreId <= 0) nr: 0 (WAIT TIME 18 ms.) 18/11/2024 22:24:38.1246 1141 ms. EXECSCALAR: select count(resId) as Tot from movReservation where resStatus = 'V' and resTypeRes = 'B' AND ((resConfirmed IN (0,2,3) AND resCreation>'2024-11-18 21:24:36') OR resConfirmed IN (4,5)) and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) <= '2024-11-18 22:24:36' and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) >= '2024-11-18 22:24:36' and (resAreId = 1 or resAreId <= 0) nr: 0 (WAIT TIME 47 ms.) 18/11/2024 22:24:38.1286 1145 ms. EXECSCALAR: select count(resId) as Tot from movReservation where resStatus = 'V' and resTypeRes = 'B' AND ((resConfirmed IN (0,2,3) AND resCreation>'2024-11-18 21:24:36') OR resConfirmed IN (4,5)) and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) <= '2024-11-18 22:24:36' and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) >= '2024-11-18 22:24:36' and (resAreId = 1 or resAreId <= 0) nr: 0 (WAIT TIME 50 ms.) 18/11/2024 22:24:52.4974 13276 ms. OPEN: SELECT * FROM movLinks INNER JOIN movTransit on traUID = mliTraUID WHERE mliRFIDCode = '456128063800327005031999' AND mliStatus='V' ORDER BY mliId DESC LIMIT 1 18/11/2024 22:24:54.0184 658 ms. OPEN: select * from tabUserMessage where useMesDescr = 'err_ticketnotfound' and (useLanCode = 'en-US' or mid(useLanCode,1,2) = 'en') 18/11/2024 22:24:55.0151 587 ms. OPEN: show columns from tabTariff where Field = 'tarTimeControlTimeBegin' 18/11/2024 22:24:56.9927 586 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 4 OR lnsTerId=4) 18/11/2024 22:24:56.9947 20213 ms. EXECSCALAR: SELECT count(*) FROM payinventory WHERE invValue<>0 AND invType='' nr: 0 18/11/2024 22:24:57.2178 1957 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,'2024-11-18 22:24:55','V',5673541041061420,2024,'2024-11-18 22:23:58','456128063800327005031999',1,2,16,'I','',1,0,1,'','',4) 18/11/2024 22:24:59.6414 2412 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 18/11/2024 22:25:02.6355 5356 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 18/11/2024 22:25:06.2362 3600 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); 18/11/2024 22:27:56.5102 864 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 = '456127900100327005012999' AND traStatus='V' AND payStatus='V' and (terType IS NULL OR terType<>3 OR (terType=3 and payType='P')) 18/11/2024 22:28:19.7861 1706 ms. EXECSCALAR: select count(payId) from paypayment where payStatus='V' and payIdTerminal = 18 and payDateTime = '2024-11-18 22:28:18' nr: 0 18/11/2024 22:28:20.6727 859 ms. OPEN: select * from movtransit where traUID = 5534354608628090 and traStatus='V' 18/11/2024 22:28:26.1139 4412 ms. EXEC: insert into payReceipt (recTraUID,recPayUID,recYear,recDateTime,recText,recInvalid) VALUES (5534354608628090,5202929400092340,2024,'2024-11-18 22:28:21',' Date: 11/18/2024 10:28:18 PM Code: 456127900100327005012999 Entry Date: 11/18/2024 9:56:41 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 # 2400750207 ',0) 18/11/2024 22:29:45.1647 2701 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