11/04/2025 09:18:14.9440   529 ms.           EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage)
11/04/2025 10:01:01.2580  1766 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
11/04/2025 10:16:53.4707   616 ms.           EXEC: update paycash set casCreation = '2025-04-11 10:16:52',casModify = '2025-04-11 10:16:52',casUseId=0,casStatus='V' where casId = 217406
11/04/2025 11:00:03.8080  2490 ms.           EXEC: insert into payPayment (payCreation,payUseId,payStatus,payUID,payTraUID,payYear,payDateTime,payIdTerminal,payEnabled,payDisableTime,payTarId,payTimeLimit,payType,payCurrency,payAmount,payPayed,payChange,payCardType,payPAN,paySTAN,payIdEvent,payAmountCalc,payDiscountValue,payDiscount,payDiscountType,payVatPercent,payVatAmount) VALUES ('2025-04-11 10:59:59',0,'V',4798391512185520,4862482234965640,2025,'2025-04-11 10:59:59',18,1,0,4,'2025-04-11 11:14:59','C','KES',50,50,0,'','','',1,50,0,0,'',0,0) (WAIT TIME 1505 ms.)
11/04/2025 11:00:05.1454   630 ms.           EXEC: update payReceipt set recCreation = '2025-04-11 11:00:04',recModify = '2025-04-11 11:00:04',recUseId=0,recStatus='V' where recId = 369631
11/04/2025 11:11:38.6498  1154 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-04-11 11:11:37','V',5655991368518520,2025,'2025-04-11 11:01:10','457563967000327001031999',3,2,1,'I','',1,0,1,'','',0)
11/04/2025 14:52:53.7899   509 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-04-11 14:52:53','V',5287909191229550,2025,'2025-04-11 14:52:53','457565357300327005012999',1,2,16,'I','',1,0,1,'','',4)
11/04/2025 14:53:16.2734   502 ms.           EXEC: INSERT INTO movOperator (opeCreation,opeUseId,opeTerId,opeDateTime,opeCode,opeDescription) VALUES ('2025-04-11 14:53:15',0,2,'2025-04-11 14:53:15','','Unauthorized Transit  Exit 1')
11/04/2025 14:54:46.1536   501 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-04-11 14:54:45','V',4792158615467920,2025,'2025-04-11 14:54:45','457565225400327005012999',2,2,2,'O','',0,'2025-04-11 14:54:45',1,'','',0)
11/04/2025 15:07:17.2252   532 ms.           EXEC: insert into payPayment (payCreation,payUseId,payStatus,payUID,payTraUID,payYear,payDateTime,payIdTerminal,payEnabled,payDisableTime,payTarId,payTimeLimit,payType,payCurrency,payAmount,payPayed,payChange,payCardType,payPAN,paySTAN,payIdEvent,payAmountCalc,payDiscountValue,payDiscount,payDiscountType,payVatPercent,payVatAmount) VALUES ('2025-04-11 15:07:16',0,'V',4780947761497430,5088014041659070,2025,'2025-04-11 15:07:16',3,1,0,4,'2025-04-11 15:22:16','C','KES',50,50,0,'',' ',' ',1,50,0,0,'',0,0)
11/04/2025 15:10:22.1567  1184 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-04-11 15:10:20','V',5500032747145970,2025,'2025-04-11 15:10:20','457565317500327005012999',2,2,2,'O','',0,'2025-04-11 15:10:20',1,'','',0)
11/04/2025 15:10:24.1479  1987 ms.           EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1
11/04/2025 15:36:00.5904   613 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-04-11 15:35:59','V',5537739876256220,2025,'2025-04-11 15:35:59','457565615900327005012999',1,2,16,'I','',1,0,1,'','',4)
11/04/2025 18:22:14.6280   546 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-04-11 18:22:14','V',4705192526298630,2025,'2025-04-11 18:22:13','457566613300327001012999',1,2,1,'I','',1,0,1,'','0230003944059',13,0)
11/04/2025 20:12:18.6006   907 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 = 10 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
11/04/2025 22:09:39.2955   797 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