31/03/2025 14:39:30.4028 15274 ms.           OPEN: show columns from tabParameters where Field = 'parUseCulture'
31/03/2025 14:39:30.4078 15279 ms.           OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 3
31/03/2025 14:39:30.4078 15280 ms.           OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 2
31/03/2025 14:39:30.4088 15281 ms.           OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 5
31/03/2025 14:39:30.4098 15282 ms.           OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 2
31/03/2025 14:39:30.4108 15283 ms.           OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 2
31/03/2025 14:39:30.4108 15283 ms.           OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 1
31/03/2025 14:39:30.4108 15283 ms.           OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 1
31/03/2025 14:39:30.4128 15285 ms.           OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 1
31/03/2025 14:39:30.4138 15285 ms.           OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 3
31/03/2025 14:39:30.4138 15286 ms.           OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 5
31/03/2025 14:39:30.4148 15287 ms.           OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 3
31/03/2025 14:39:30.4148 15287 ms.           OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 3
31/03/2025 14:39:30.4158 15288 ms.           OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 3
31/03/2025 14:39:30.4158 15288 ms.           OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 5
31/03/2025 14:39:30.4168 15289 ms.           OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 1
31/03/2025 14:39:30.4168 15289 ms.           OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 5
31/03/2025 14:39:30.4168 15289 ms.           OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 5
31/03/2025 14:39:30.4178 15289 ms.           OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 2
31/03/2025 14:39:30.4178 15290 ms.           OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 2
31/03/2025 14:39:30.4198 15292 ms.           OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 1
31/03/2025 14:39:30.4208 15293 ms.           OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 5
31/03/2025 14:39:30.4218 15294 ms.           OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 1
31/03/2025 14:39:30.4578 15330 ms.           OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 2
31/03/2025 14:39:31.2103   512 ms.           OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 1 OR lnsTerId=1)
31/03/2025 14:39:31.2183   507 ms.           OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 3 OR lnsTerId=3)
31/03/2025 14:39:31.2183   518 ms.           OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 16 OR lnsTerId=16)
31/03/2025 14:39:31.2553   536 ms.           OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 16 OR lnsTerId=16)
31/03/2025 14:39:31.2593   533 ms.           OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 16 OR lnsTerId=16)
31/03/2025 14:39:31.2603   532 ms.           OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 2 OR lnsTerId=2)
31/03/2025 14:39:31.2653   566 ms.           OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 16 OR lnsTerId=16)
31/03/2025 14:39:32.3621   588 ms.           OPEN: show columns from abbCards where Field = 'carUHFCode'
31/03/2025 14:39:43.8763 12309 ms.     EXECSCALAR: SELECT count(*) FROM payinventory WHERE invValue<>0 AND invType='' nr: 0
31/03/2025 14:39:44.8511 11272 ms.           OPEN: SELECT * FROM movLinks INNER JOIN movTransit on traUID = mliTraUID WHERE mliRFIDCode = '0240526504678' AND mliStatus='V' ORDER BY mliId DESC LIMIT 1
31/03/2025 14:39:44.9392 10684 ms.           OPEN: SELECT * FROM movLinks INNER JOIN movTransit on traUID = mliTraUID WHERE mliRFIDCode = '457455272500327001031999' AND mliStatus='V' ORDER BY mliId DESC LIMIT 1
31/03/2025 14:39:46.6435   520 ms.           OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 18 OR lnsTerId=18)
31/03/2025 14:39:46.8557  1088 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-31 14:39:45','V',4857007867772210,2025,'2025-03-31 14:36:10','457455075900327005029999',2,2,16,'I','',1,0,1,'','1301662587622',185,0)
31/03/2025 14:39:49.2824  2418 ms.           EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage)
31/03/2025 14:39:49.2824  2412 ms.           EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage)
31/03/2025 14:39:49.3324  5300 ms.           EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40);
31/03/2025 14:39:53.3291  3996 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);
31/03/2025 14:39:54.2537  3127 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 = '457455183800327001012999' AND traStatus='V' AND payStatus='V' and (terType IS NULL OR terType<>3 OR (terType=3 and payType='P'))
31/03/2025 14:41:47.0878  3346 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
31/03/2025 14:53:55.0640  1629 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
31/03/2025 15:37:41.3167   557 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-03-31 15:37:40','V',4856493168227440,2025,'2025-03-31 15:37:40','457455626000327005012999',1,2,16,'I','',1,0,1,'','',4)
31/03/2025 17:12:44.9993  1245 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
31/03/2025 17:14:45.2218 14363 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 = 1 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
31/03/2025 17:33:29.5290  1276 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
31/03/2025 21:46:46.2182   636 ms.           EXEC: insert into paycash (casCreation,casModify,casUseId,casStatus,casUID,casTraUID,casYear,casDateTime,casIdTerminal,casCurrency,casNumber,casSingleAmount,casTotAmount,casType,casDescription) VALUES ('2025-03-31 21:46:45',0,0,'V',5072636262478660,5321244764382440,2025,'2025-03-31 21:46:45',3,'KES',1,500,500,'N','');