08/06/2024 10:24:58.0102   651 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 ('2024-06-08 10:24:56',0,'V',5163657782074920,4914540822054590,2024,'2024-06-08 10:24:56',3,1,0,4,'2024-06-08 10:39:56','C','KES',50,50,0,'',' ',' ',1,50,0,0,'',0,0)
08/06/2024 11:33:01.5529   508 ms.           EXEC: INSERT INTO opeActivities (acvCreation,acvUseId,acvTerId,acvOpeUseId,acvSuperUseId,acvCodeId,acvTypeId,acvDateTime,acvSftId,acvCausal) VALUES (@ACVCREATION,@ACVUSEID,@ACVTERID,@ACVOPEUSEID,@ACVSUPERUSEID,@ACVCODEID,@ACVTYPEID,@ACVDATETIME,@ACVSFTID,@ACVCAUSAL)
08/06/2024 11:33:04.4966  2113 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 = 12 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
08/06/2024 11:39:26.1223   523 ms.           EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1
08/06/2024 11:45:50.0936   507 ms.           EXEC: update payPayment set payEnabled=0, payDisableTime = '2024-06-08 11:45:49' where payTraUID = 5631017154777580 and payStatus='V' and payEnabled=1
08/06/2024 12:15:39.0743   563 ms.           EXEC: update payPayment set payEnabled=0, payDisableTime = '2024-06-08 12:15:38' where payTraUID = 5008998308453850 and payStatus='V' and payEnabled=1
08/06/2024 12:44:01.2727   506 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 ('2024-06-08 12:42:51',6,'V',5611632705172860,5443363730016640,2024,'2024-06-08 12:42:51',4,1,0,4,'2024-06-08 12:57:51','P','KES',50,50,0,'','','',1,50,0,0,'',0,0)
08/06/2024 14:42:31.4558   565 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-06-08 14:42:30','V',4989726032956780,2024,'2024-06-08 14:42:30','454495295000327005012999',1,2,16,'I','',1,0,1,'','',4)
08/06/2024 19:07:53.1156   934 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
08/06/2024 19:49:41.4048   538 ms.           EXEC: update payPayment set payEnabled=0, payDisableTime = '2024-06-08 19:49:40' where payTraUID = 5123363271375800 and payStatus='V' and payEnabled=1