08/03/2023 10:52:35.5566   578 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,'2023-03-08 10:52:34','V',4736171394014880,2023,'2023-03-08 10:52:34','449913915400327005012999',1,2,16,'I','',1,0,1,'','0230003944081',15,0)
08/03/2023 11:14:01.0881   908 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
08/03/2023 11:57:18.2928   772 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-03-08 11:57:17','V',5075892595764720,2023,'2023-03-08 11:57:17','449914055300327005012999',2,2,2,'O','',0,'2023-03-08 11:57:17',1,'','',0)
08/03/2023 14:22:13.4416   516 ms.           EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2023-03-08 14:22:12',3,42101,0,50,-1,-50,1,'O','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/03/2023 14:27:46.4730   534 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 ('2023-03-08 14:27:45',0,'V',5677300221632540,5450916677769680,2023,'2023-03-08 14:27:45',18,1,0,4,'2023-03-08 14:42:45','C','KES',100,100,0,'','','',1,100,0,0,'',0,0)
08/03/2023 16:06:43.2896   532 ms.           EXEC: update payInventory set invCreation = '2023-03-08 16:06:42',invModify = '2023-03-08 16:06:42',invUseId=0,invStatus='V' where invId = 65104
08/03/2023 16:25:55.1997   515 ms.           EXEC: update movTransit set traEnabled=0, traDisableTime = '2023-03-08 16:25:54' where traUID = 4703684639342090 and traStatus='V' and traEnabled=1
08/03/2023 16:26:27.9173   726 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 ('2023-03-08 16:26:26',0,'V',5644668767853530,5420670250529850,2023,'2023-03-08 16:26:26',3,1,0,4,'2023-03-08 16:41:26','C','KES',50,100,50,'',' ',' ',1,50,0,0,'',0,0)
08/03/2023 16:27:21.1586   683 ms.           EXEC: insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2023-03-08 16:27:20',3,42101,0,100,1,100,2,'I','N');
update payCurInventory set curQuantity=round(curQuantity+1,5),curAmount=round(curAmount+100,5) where curTerId = 3 and curDevCode = 42101 and curChannelId = 2 and curValue = 100 and curType = 'N';

08/03/2023 18:12:41.0824   537 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-03-08 18:12:40','V',4899648289050470,2023,'2023-03-08 18:12:40','449916556000327005012999',1,2,16,'I','',1,0,1,'','',4)
08/03/2023 18:29:18.7635   589 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-03-08 18:29:18','V',4830383441962390,2023,'2023-03-08 18:29:18','449914976400327005012999',2,2,2,'O','',0,'2023-03-08 18:29:18',1,'','',0)
08/03/2023 18:56:17.9799   551 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 ('2023-03-08 18:56:17',0,'V',5002131787161340,5069538374168110,2023,'2023-03-08 18:56:17',3,1,0,4,'2023-03-08 19:11:17','C','KES',50,50,0,'',' ',' ',1,50,0,0,'',0,0)
08/03/2023 22:14:15.2455   556 ms.           EXEC: update movTransit set traEnabled=0, traDisableTime = '2023-03-08 22:14:14' where traUID = 5481416581237400 and traStatus='V' and traEnabled=1
08/03/2023 22:20:28.0989   516 ms.           EXEC: update movTransit set traEnabled=0, traDisableTime = '2023-03-08 22:20:27' where traUID = 4701930909324370 and traStatus='V' and traEnabled=1
08/03/2023 22:54:21.1758   519 ms.           EXEC: update movTransit set traEnabled=0, traDisableTime = '2023-03-08 22:54:20' where traUID = 5453652207226900 and traStatus='V' and traEnabled=1