26/03/2025 07:00:32.9736 756 ms. OPEN: select traId,traDateTime,traEnabled,traDisableTime,traCode,traBadge,traCarId,traAreId,traIdTerminal from movtransit where traStatus='V' and traDirection = 'I' and traCarId = 26 order by traDateTime desc,traId desc 26/03/2025 20:19:03.9788 3018 ms. OPEN: show columns from tabParameters where Field = 'parAllowNegativePlaces' 26/03/2025 20:25:02.2109 34473 ms. OPEN: show columns from tabParameters where Field = 'parAllowNegativePlaces' 26/03/2025 20:25:03.2306 688 ms. OPEN: select * from tablanguages where lanStatus='V' order by lannumber limit 1 26/03/2025 20:25:03.9080 1329 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 3 26/03/2025 20:25:03.9090 1329 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 2 26/03/2025 20:25:03.9100 1332 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 5 26/03/2025 20:25:03.9110 1331 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 3 26/03/2025 20:25:03.9120 1334 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 5 26/03/2025 20:25:03.9130 1335 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 3 26/03/2025 20:25:03.9150 670 ms. OPEN: show columns from movLinks where Field = 'mliReceiptMessage' (WAIT TIME 2 ms.) 26/03/2025 20:25:03.9180 1336 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 3 26/03/2025 20:25:03.9180 1338 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 5 26/03/2025 20:25:03.9190 1338 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 2 26/03/2025 20:25:03.9190 1341 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 1 26/03/2025 20:25:03.9200 1341 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 2 26/03/2025 20:25:03.9210 1339 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 3 26/03/2025 20:25:03.9220 1343 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 1 26/03/2025 20:25:03.9220 1341 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 2 26/03/2025 20:25:03.9240 1345 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 1 26/03/2025 20:25:03.9240 1344 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 3 26/03/2025 20:25:03.9260 1346 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 1 26/03/2025 20:25:03.9270 1348 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 5 26/03/2025 20:25:03.9270 1347 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 5 26/03/2025 20:25:03.9300 1349 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 1 26/03/2025 20:25:03.9320 1346 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 2 (WAIT TIME 6 ms.) 26/03/2025 20:25:03.9350 1344 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 2 (WAIT TIME 10 ms.) 26/03/2025 20:25:04.4095 1831 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 5 26/03/2025 20:25:04.7317 821 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 26/03/2025 20:25:04.7337 810 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 26/03/2025 20:25:04.7387 820 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 26/03/2025 20:25:05.0680 1149 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 26/03/2025 20:25:05.0680 1140 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 26/03/2025 20:25:05.0690 658 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 26/03/2025 20:25:05.0700 1159 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 26/03/2025 20:25:05.0720 1150 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 26/03/2025 20:25:05.0890 1161 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 26/03/2025 20:25:05.0900 1164 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 26/03/2025 20:25:05.0910 1179 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 26/03/2025 20:25:05.1040 1195 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 26/03/2025 20:25:05.1040 1179 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 26/03/2025 20:25:05.1130 1200 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 26/03/2025 20:25:05.1140 1182 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 26/03/2025 20:25:05.1150 1195 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 26/03/2025 20:25:05.1170 1181 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 26/03/2025 20:25:05.1450 1216 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 26/03/2025 20:25:05.1450 1225 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 26/03/2025 20:25:05.1480 1211 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 26/03/2025 20:25:05.1500 1229 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 26/03/2025 20:25:05.1640 1249 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 26/03/2025 20:25:05.1750 1253 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 26/03/2025 20:25:07.1483 1585 ms. OPEN: select * from tabTicketType where ticStatus='V' and ticOption='S' order by ticType,ticId 26/03/2025 20:25:07.7437 2266 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 1 OR lnsTerId=1) 26/03/2025 20:25:07.7437 2270 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 2 OR lnsTerId=2) 26/03/2025 20:25:07.7457 2262 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 2 OR lnsTerId=2) 26/03/2025 20:25:07.7517 2268 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 1 OR lnsTerId=1) 26/03/2025 20:25:07.7517 2273 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 3 OR lnsTerId=3) 26/03/2025 20:25:07.7527 2274 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 1 OR lnsTerId=1) 26/03/2025 20:25:07.7537 2271 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 3 OR lnsTerId=3) 26/03/2025 20:25:07.7557 2276 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 1 OR lnsTerId=1) 26/03/2025 20:25:07.7567 2282 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 16 OR lnsTerId=16) 26/03/2025 20:25:07.7587 2276 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 2 OR lnsTerId=2) 26/03/2025 20:25:07.7597 2279 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 1 OR lnsTerId=1) 26/03/2025 20:25:07.7597 2282 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 16 OR lnsTerId=16) 26/03/2025 20:25:07.7607 2278 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 3 OR lnsTerId=3) 26/03/2025 20:25:07.7617 2278 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 16 OR lnsTerId=16) 26/03/2025 20:25:07.7617 2284 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 16 OR lnsTerId=16) 26/03/2025 20:25:07.7617 2278 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 2 OR lnsTerId=2) 26/03/2025 20:25:07.7627 2281 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 16 OR lnsTerId=16) 26/03/2025 20:25:07.7627 2281 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 2 OR lnsTerId=2) 26/03/2025 20:25:07.7637 2284 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 3 OR lnsTerId=3) 26/03/2025 20:25:07.7647 2284 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 3 OR lnsTerId=3) 26/03/2025 20:25:07.7647 2285 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 16 OR lnsTerId=16) 26/03/2025 20:25:07.7657 2292 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 2 OR lnsTerId=2) 26/03/2025 20:25:07.7668 2293 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 3 OR lnsTerId=3) 26/03/2025 20:25:07.8168 651 ms. OPEN: select * from tabCurrency where curStatus='V' and curCode = 'KES' 26/03/2025 20:25:09.6620 548 ms. EXEC: update tabTerminalExtraMem SET extLoop1 = 1, extPlate = '', extPlateAccuracy=0, extPlateReadDate='1970-01-01', extPlateWaitOperator=0,extTrpId=0, extTag = '' where extStatus='V' and extTerId = 2 26/03/2025 20:25:09.6630 549 ms. EXEC: update tabTerminalExtraMem SET extLoop2 = 0 where extStatus='V' and extTerId = 1 AND extPlateWaitOperator=0 26/03/2025 20:25:09.6640 538 ms. EXECSCALAR: select count(*) from tabTerminalExtraMem where extStatus='V' and extTerId = 16 nr: 2 26/03/2025 20:25:13.8629 2945 ms. EXECSCALAR: select count(resId) as Tot from movReservation where resStatus = 'V' and resTypeRes = 'B' AND ((resConfirmed IN (0,2,3) AND resCreation>'2025-03-26 19:25:10') OR resConfirmed IN (4,5)) and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) <= '2025-03-26 20:25:09' and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) >= '2025-03-26 20:25:09' and (resAreId = 1 or resAreId <= 0) nr: 0 26/03/2025 20:25:13.8909 2951 ms. EXECSCALAR: select count(resId) as Tot from movReservation where resStatus = 'V' and resTypeRes = 'B' AND ((resConfirmed IN (0,2,3) AND resCreation>'2025-03-26 19:25:10') OR resConfirmed IN (4,5)) and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) <= '2025-03-26 20:25:09' and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) >= '2025-03-26 20:25:09' and (resAreId = 1 or resAreId <= 0) nr: 0 (WAIT TIME 28 ms.) 26/03/2025 20:25:13.8969 2948 ms. EXECSCALAR: select count(resId) as Tot from movReservation where resStatus = 'V' and resTypeRes = 'B' AND ((resConfirmed IN (0,2,3) AND resCreation>'2025-03-26 19:25:10') OR resConfirmed IN (4,5)) and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) <= '2025-03-26 20:25:09' and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) >= '2025-03-26 20:25:09' and (resAreId = 1 or resAreId <= 0) nr: 0 (WAIT TIME 32 ms.) 26/03/2025 20:25:13.9019 2954 ms. EXECSCALAR: select count(resId) as Tot from movReservation where resStatus = 'V' and resTypeRes = 'B' AND ((resConfirmed IN (0,2,3) AND resCreation>'2025-03-26 19:25:10') OR resConfirmed IN (4,5)) and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) <= '2025-03-26 20:25:09' and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) >= '2025-03-26 20:25:09' and (resAreId = 1 or resAreId <= 0) nr: 0 (WAIT TIME 37 ms.) 26/03/2025 20:25:13.9029 2949 ms. EXECSCALAR: select count(resId) as Tot from movReservation where resStatus = 'V' and resTypeRes = 'B' AND ((resConfirmed IN (0,2,3) AND resCreation>'2025-03-26 19:25:10') OR resConfirmed IN (4,5)) and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) <= '2025-03-26 20:25:09' and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) >= '2025-03-26 20:25:09' and (resAreId = 1 or resAreId <= 0) nr: 0 (WAIT TIME 36 ms.) 26/03/2025 20:25:13.9039 2966 ms. EXECSCALAR: select count(resId) as Tot from movReservation where resStatus = 'V' and resTypeRes = 'B' AND ((resConfirmed IN (0,2,3) AND resCreation>'2025-03-26 19:25:10') OR resConfirmed IN (4,5)) and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) <= '2025-03-26 20:25:09' and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) >= '2025-03-26 20:25:09' and (resAreId = 1 or resAreId <= 0) nr: 0 (WAIT TIME 35 ms.) 26/03/2025 20:25:13.9049 2954 ms. EXECSCALAR: select count(resId) as Tot from movReservation where resStatus = 'V' and resTypeRes = 'B' AND ((resConfirmed IN (0,2,3) AND resCreation>'2025-03-26 19:25:10') OR resConfirmed IN (4,5)) and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) <= '2025-03-26 20:25:09' and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) >= '2025-03-26 20:25:09' and (resAreId = 1 or resAreId <= 0) nr: 0 (WAIT TIME 35 ms.) 26/03/2025 20:25:13.9079 2948 ms. EXECSCALAR: select count(resId) as Tot from movReservation where resStatus = 'V' and resTypeRes = 'B' AND ((resConfirmed IN (0,2,3) AND resCreation>'2025-03-26 19:25:10') OR resConfirmed IN (4,5)) and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) <= '2025-03-26 20:25:09' and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) >= '2025-03-26 20:25:09' and (resAreId = 1 or resAreId <= 0) nr: 0 (WAIT TIME 45 ms.) 26/03/2025 20:25:13.9099 2947 ms. EXECSCALAR: select count(resId) as Tot from movReservation where resStatus = 'V' and resTypeRes = 'B' AND ((resConfirmed IN (0,2,3) AND resCreation>'2025-03-26 19:25:10') OR resConfirmed IN (4,5)) and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) <= '2025-03-26 20:25:09' and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) >= '2025-03-26 20:25:09' and (resAreId = 1 or resAreId <= 0) nr: 0 (WAIT TIME 44 ms.) 26/03/2025 20:25:13.9109 2948 ms. EXECSCALAR: select count(resId) as Tot from movReservation where resStatus = 'V' and resTypeRes = 'B' AND ((resConfirmed IN (0,2,3) AND resCreation>'2025-03-26 19:25:10') OR resConfirmed IN (4,5)) and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) <= '2025-03-26 20:25:09' and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) >= '2025-03-26 20:25:09' and (resAreId = 1 or resAreId <= 0) nr: 0 (WAIT TIME 44 ms.) 26/03/2025 20:25:13.9119 2951 ms. EXECSCALAR: select count(resId) as Tot from movReservation where resStatus = 'V' and resTypeRes = 'B' AND ((resConfirmed IN (0,2,3) AND resCreation>'2025-03-26 19:25:10') OR resConfirmed IN (4,5)) and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) <= '2025-03-26 20:25:09' and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) >= '2025-03-26 20:25:09' and (resAreId = 1 or resAreId <= 0) nr: 0 (WAIT TIME 43 ms.) 26/03/2025 20:25:26.6644 18843 ms. EXECSCALAR: SELECT count(*) FROM payinventory WHERE invValue<>0 AND invType='' nr: 0 26/03/2025 20:25:27.4850 12420 ms. OPEN: SELECT * FROM movLinks INNER JOIN movTransit on traUID = mliTraUID WHERE mliRFIDCode = '0098788191867' AND mliStatus='V' ORDER BY mliId DESC LIMIT 1 26/03/2025 20:25:28.8269 737 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 26/03/2025 20:25:31.5557 1886 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-03-26 20:25:29','V',5392188302390220,2025,'2025-03-26 20:22:43','457407180800327005029999',2,2,16,'I','',1,0,1,'','0532370677371',13,0) 26/03/2025 20:25:32.5564 5350 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 26/03/2025 20:25:32.9906 1423 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 26/03/2025 20:25:34.7778 2220 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); 26/03/2025 20:25:35.5283 701 ms. EXEC: UPDATE payInventory SET invType='N' WHERE invType<>'N' AND invValue IN (100,200,500) AND invDevice IN (42102,42101,42001); 26/03/2025 20:26:58.4751 652 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 = '457407361600327005012999' AND traStatus='V' AND payStatus='V' and (terType IS NULL OR terType<>3 OR (terType=3 and payType='P')) 26/03/2025 20:53:52.3928 1115 ms. OPEN: select traId,traDateTime,traEnabled,traDisableTime,traCode,traBadge,traCarId,traAreId,traIdTerminal from movtransit where traStatus='V' and traDirection = 'I' and traCarId = 125 order by traDateTime desc,traId desc 26/03/2025 21:53:29.4910 2959 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