01/08/2025 09:32:46.7237 562 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-08-01 09:32:46','V',5683460133855290,2025,'2025-08-01 09:32:44','458683436400327005012999',1,2,16,'I','',1,0,1,'','',4) 01/08/2025 12:19:45.3185 515 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-08-01 12:19:44','V',4695452904110640,2025,'2025-08-01 12:19:43','458684438300327005012999',1,2,16,'I','',1,0,1,'','',4) 01/08/2025 15:30:21.8641 656 ms. EXEC: update opeActivities set acvFstPayId = (case acvFstPayId when 0 then 465459 else acvFstPayId end),acvLstPayId = 465459 where acvSftId = 1156 and acvCodeId = 3 01/08/2025 16:15:20.3250 515 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-08-01 16:15:13',1,'V',4980442958312120,5429116232491310,2025,'2025-08-01 16:15:13',4,1,0,4,'2025-08-01 16:30:13','P','KES',50,50,0,'','','',1,50,0,0,'',0,0) 01/08/2025 18:29:17.5678 3609 ms. EXECSCALAR: select count(traId) as Tot from movTransit where traStatus='V' and traEnabled=1 and traCarId=0 and traAreId = 1 and traUID not in (select payTraUID from paypayment where payStatus='V') nr: 28554 01/08/2025 18:29:18.5366 968 ms. OPEN: select * from movTransit where traStatus='V' and traEnabled=1 and traCarId=0 and traAreId = 1 and traUID not in (select payTraUID from paypayment where payStatus='V') order by traId 01/08/2025 22:03:58.9875 546 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2025-08-01 22:03:58' where payTraUID = 4793242245025150 and payStatus='V' and payEnabled=1