16/07/2025 23:22:10.6613 15950 ms. OPEN: select * from tablanguages where lanStatus='V' order by lannumber limit 1 16/07/2025 23:22:10.6613 2492 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 5 16/07/2025 23:22:10.6623 2379 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 2 16/07/2025 23:22:10.6673 2712 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 2 16/07/2025 23:22:10.6683 1349 ms. EXECSCALAR: select count(0) as vTot from tabParameters where parPlateReading<>0 nr: 0 16/07/2025 23:22:10.6693 1298 ms. EXECSCALAR: select count(0) as vTot from tabParameters where parPlateReading<>0 nr: 0 16/07/2025 23:22:10.6703 2518 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 2 16/07/2025 23:22:10.6713 2656 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 2 16/07/2025 23:22:10.6723 2707 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 5 16/07/2025 23:22:10.6733 2524 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 2 16/07/2025 23:22:10.6783 2601 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 5 16/07/2025 23:22:10.6793 2808 ms. OPEN: select parcurrency,parcurrencySymbol from tabParameters where parStatus='V' order by parId desc limit 1 16/07/2025 23:22:10.9625 15326 ms. OPEN: select * from tablanguages where lanStatus='V' order by lannumber limit 1 16/07/2025 23:22:11.0415 2699 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 5 (WAIT TIME 79 ms.) 16/07/2025 23:22:11.0425 2646 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 5 (WAIT TIME 79 ms.) 16/07/2025 23:22:11.9211 878 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 16/07/2025 23:22:12.3024 1630 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 16/07/2025 23:22:12.3034 1639 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 16/07/2025 23:22:12.3104 1637 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 16/07/2025 23:22:12.3114 1644 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 16/07/2025 23:22:12.3124 1644 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 16/07/2025 23:22:12.3134 1635 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 16/07/2025 23:22:12.3234 1650 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 16/07/2025 23:22:12.3254 1651 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 16/07/2025 23:22:12.3274 1654 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 16/07/2025 23:22:12.3284 1285 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 16/07/2025 23:22:12.3304 1650 ms. OPEN: select * from tabCurrency where curStatus='V' and curCode = 'KES' 16/07/2025 23:22:12.7267 2023 ms. EXECSCALAR: select count(resId) as Tot from movReservation where resStatus = 'V' and resTypeRes = 'B' AND ((resConfirmed IN (0,2,3) AND resCreation>'2025-07-16 22.22.10') OR resConfirmed IN (4,5)) and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) <= '2025-07-16 23.22.03' and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) >= '2025-07-16 23.22.03' and (resAreId = 1 or resAreId <= 0) nr: 0 16/07/2025 23:22:12.7287 806 ms. OPEN: show columns from tabArea where Field = 'areType' 16/07/2025 23:22:12.7667 2096 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 16/07/2025 23:22:13.0439 5803 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<>'') AND subAbbType NOT IN (6,-1) ORDER BY carCode 16/07/2025 23:22:13.0469 2379 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<>'') AND subAbbType NOT IN (6,-1) ORDER BY carCode 16/07/2025 23:22:13.9945 941 ms. OPEN: select * from tabuser where useStatus='V' order by useId 16/07/2025 23:22:13.9955 938 ms. OPEN: select * from tabuser where useStatus='V' order by useId 16/07/2025 23:22:14.0275 1256 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 2 OR lnsTerId=2) 16/07/2025 23:22:14.0285 1255 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 16 OR lnsTerId=16) 16/07/2025 23:22:14.0325 1259 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 2 OR lnsTerId=2) 16/07/2025 23:22:14.0325 1263 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 16 OR lnsTerId=16) 16/07/2025 23:22:14.0335 1265 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 16 OR lnsTerId=16) 16/07/2025 23:22:14.0335 1264 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 16 OR lnsTerId=16) 16/07/2025 23:22:14.0355 1265 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 2 OR lnsTerId=2) 16/07/2025 23:22:14.0355 1262 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 16 OR lnsTerId=16) 16/07/2025 23:22:14.0365 1264 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 2 OR lnsTerId=2) 16/07/2025 23:22:14.0385 1270 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 2 OR lnsTerId=2) 16/07/2025 23:22:14.0385 1265 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 2 OR lnsTerId=2) 16/07/2025 23:22:14.0405 1270 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 16 OR lnsTerId=16) 16/07/2025 23:22:15.5636 683 ms. OPEN: select sum(crc32(terDescription)) as vCheck from tabTerminal 16/07/2025 23:22:25.6715 10396 ms. OPEN: SELECT * FROM movLinks INNER JOIN movTransit on traUID = mliTraUID WHERE mliRFIDCode = '458528322300327005031999' AND mliStatus='V' ORDER BY mliId DESC LIMIT 1 16/07/2025 23:22:27.9291 15595 ms. EXECSCALAR: SELECT count(*) FROM payinventory WHERE invValue<>0 AND invType='' nr: 0 16/07/2025 23:22:29.2990 1799 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-16 23.22.27','V',4641949311545220,2025,'2025-07-16 23.07.03','458528322300327005031999',1,2,16,'I','',1,0,1,'','',4) 16/07/2025 23:22:33.5258 5347 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 16/07/2025 23:22:37.4184 3892 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); 16/07/2025 23:32:04.3337 714 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 = '4585283864003270050031999' AND traStatus='V' AND payStatus='V' and (terType IS NULL OR terType<>3 OR (terType=3 and payType='P'))