08/05/2023 06:13:08.0320 503 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,'2023-05-08 06:13:07','V',4639624960607390,2023,'2023-05-08 06:13:07','450522193700327005012999',2,2,2,'O','',0,'2023-05-08 06:13:07',1,'','',0) 08/05/2023 07:37:52.4352 528 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2023-05-08 07:37:51' where traUID = 5297068646332320 and traStatus='V' and traEnabled=1 08/05/2023 11:45:55.8786 549 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,payVatPercent,payVatAmount) VALUES ('2023-05-08 11:45:55',0,'V',5483555804404160,4786601604218590,2023,'2023-05-08 11:45:55',2,1,0,-1,'2023-05-08 12:45:55','S','KES',0,0,0,'','','',3,0,0) 08/05/2023 13:32:12.2610 585 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,'2023-05-08 13:32:11','V',5250199997752080,2023,'2023-05-08 13:32:11','450524448000327001012999',2,2,2,'O','',0,'2023-05-08 13:32:11',1,'','',0) 08/05/2023 13:35:54.4110 575 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2023-05-08 13:35:53',3,42101,0,50,1,50,1,'I','N'); update payCurInventory set curQuantity=round(curQuantity+1,5),curAmount=round(curAmount+50,5) where curTerId = 3 and curDevCode = 42101 and curChannelId = 1 and curValue = 50 and curType = 'N'; 08/05/2023 14:10:07.7357 572 ms. EXEC: update payInventory set invCreation = '2023-05-08 14:10:07',invModify = '2023-05-08 14:10:07',invUseId=0,invStatus='V' where invId = 83813 08/05/2023 14:17:06.7876 570 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 08/05/2023 17:11:06.5663 513 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,payVatPercent,payVatAmount) VALUES ('2023-05-08 17:11:06',0,'V',4925418419209340,5603112826753150,2023,'2023-05-08 17:11:06',2,1,0,-1,'2023-05-08 18:11:06','S','KES',0,0,0,'','','',3,0,0) 08/05/2023 19:35:28.4085 541 ms. EXEC: update payInventory set invCreation = '2023-05-08 19:35:27',invModify = '2023-05-08 19:35:27',invUseId=0,invStatus='V' where invId = 83946 08/05/2023 22:13:26.2132 1157 ms. OPEN: SELECT COUNT(traId) as Total,terId,terDescription FROM movTransit INNER JOIN tabterminal on traIdTerminal = terId AND terType IN (1,3,19,4) LEFT JOIN payPayment on payTrauid = traUID WHERE traCreation>'2022-08-24 13:51:00' AND traStatus='V' and traDirection='I' AND payTraUID IS NULL GROUP BY traIdTerminal