12/09/2023 08:43:27.1775  1768 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
12/09/2023 10:09:59.4118   635 ms.           EXEC: update movTransit set traEnabled=0, traDisableTime = '2023-09-12 10:09:58' where traUID = 4885416197173980 and traStatus='V' and traEnabled=1
12/09/2023 11:40:19.6346   560 ms.           EXEC: update payInventory set invCreation = '2023-09-12 11:40:19',invModify = '2023-09-12 11:40:19',invUseId=0,invStatus='V' where invId = 123656
12/09/2023 11:40:20.4652   506 ms.           EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2023-09-12 11:40:19',3,42101,0,200,-1,-200,1,'O','N');
update payCurInventory set curQuantity=round(curQuantity+-1,5),curAmount=round(curAmount+-200,5) where curTerId = 3 and curDevCode = 42101 and curChannelId = 1 and curValue = 200 and curType = 'N';
insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2023-09-12 11:40:19',3,42101,0,200,-1,-200,1,'O','N');
update payCurInventory set curQuantity=round(curQuantity-1,5),curAmount=round(curAmount-200,5) where curTerId = 3 and curDevCode = 42101 and curChannelId = 1 and curValue = 200 and curType = 'N';
insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2023-09-12 11:40:19',3,42101,0,200,1,200,2,'I','N');
update payCurInventory set curQuantity=round(curQuantity+1,5),curAmount=round(curAmount+200,5) where curTerId = 3 and curDevCode = 42101 and curChannelId = 2 and curValue = 200 and curType = 'N';

12/09/2023 12:33:04.8744   621 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-09-12 12:33:04','V',4794562667013990,2023,'2023-09-12 12:33:03','451794424700327005012999',2,2,2,'O','',0,'2023-09-12 12:33:04',1,'','',0)
12/09/2023 13:03:13.0726   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,'2023-09-12 13:03:12','V',5461612578580040,2023,'2023-09-12 13:03:12','451794269100327005012999',2,2,2,'O','',0,'2023-09-12 13:03:12',1,'','',0)
12/09/2023 13:06:43.0276   519 ms.           EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1
12/09/2023 13:52:43.9396   570 ms.           EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1
12/09/2023 14:00:51.6225   516 ms.           EXEC: update movTransit set traEnabled=0, traDisableTime = '2023-09-12 14:00:51' where traUID = 5696285206594340 and traStatus='V' and traEnabled=1
12/09/2023 14:06:19.4729   543 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-09-12 14:06:18',0,'V',5207671876451570,4932913372031710,2023,'2023-09-12 14:06:18',2,1,0,-1,'2023-09-12 15:06:18','S','KES',0,0,0,'','','',3,0,0)
12/09/2023 14:28:54.2830   615 ms.           EXEC: update payPayment set payEnabled=0, payDisableTime = '2023-09-12 14:28:53' where payTraUID = 5522131073523700 and payStatus='V' and payEnabled=1
12/09/2023 15:41:41.7956   545 ms.           EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1
12/09/2023 15:49:21.9659   577 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-09-12 15:49:21','V',4630358590534950,2023,'2023-09-12 15:49:21','451795696100327005012999',1,2,16,'I','',1,0,1,'','',4)
12/09/2023 16:59:47.9542   704 ms.           EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2023-09-12 16:59:47',3,42101,0,100,-2,-200,1,'O','N');
update payCurInventory set curQuantity=round(curQuantity+-2,5),curAmount=round(curAmount+-200,5) where curTerId = 3 and curDevCode = 42101 and curChannelId = 1 and curValue = 100 and curType = 'N';
Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2023-09-12 16:59:47',3,42101,0,200,-1,-200,1,'O','N');
update payCurInventory set curQuantity=round(curQuantity+-1,5),curAmount=round(curAmount+-200,5) where curTerId = 3 and curDevCode = 42101 and curChannelId = 1 and curValue = 200 and curType = 'N';

12/09/2023 17:06:25.6178   610 ms.           EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1