01/03/2023 09:42:32.2336   579 ms.           EXEC: insert into paycash (casCreation,casModify,casUseId,casStatus,casUID,casTraUID,casYear,casDateTime,casIdTerminal,casCurrency,casNumber,casSingleAmount,casTotAmount,casType,casDescription) VALUES ('2023-03-01 09:42:31',0,0,'V',5066244139799950,5685345805749220,2023,'2023-03-01 09:42:31',3,'KES',1,100,100,'N','');

01/03/2023 09:42:32.8510   560 ms.           EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2023-03-01 09:42:31',3,42101,0,100,1,100,1,'I','N');
update payCurInventory set curQuantity=round(curQuantity+1,5),curAmount=round(curAmount+100,5) where curTerId = 3 and curDevCode = 42101 and curChannelId = 1 and curValue = 100 and curType = 'N';

01/03/2023 11:44:53.3300   680 ms.           EXEC: insert into paycash (casCreation,casModify,casUseId,casStatus,casUID,casTraUID,casYear,casDateTime,casIdTerminal,casCurrency,casNumber,casSingleAmount,casTotAmount,casType,casDescription) VALUES ('2023-03-01 11:44:52',0,0,'V',4775026457353260,4805444633890700,2023,'2023-03-01 11:44:52',3,'KES',-1,50,-50,'N','');
insert into paycash (casCreation,casModify,casUseId,casStatus,casUID,casTraUID,casYear,casDateTime,casIdTerminal,casCurrency,casNumber,casSingleAmount,casTotAmount,casType,casDescription) VALUES ('2023-03-01 11:44:52',0,0,'V',4775026457353260,4805444633890700,2023,'2023-03-01 11:44:52',3,'KES',-1,100,-100,'N','');

01/03/2023 11:44:53.9969   524 ms.           EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2023-03-01 11:44:52',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';
Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2023-03-01 11:44:52',3,42101,0,100,-1,-100,1,'O','N');
update payCurInventory set curQuantity=round(curQuantity+-1,5),curAmount=round(curAmount+-100,5) where curTerId = 3 and curDevCode = 42101 and curChannelId = 1 and curValue = 100 and curType = 'N';

01/03/2023 11:51:37.9769   621 ms.           EXEC: insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2023-03-01 11:51:37',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';

01/03/2023 12:46:47.0027   533 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-01 12:46:35',6,'V',5277944243423610,4765521279803370,2023,'2023-03-01 12:46:35',4,1,0,4,'2023-03-01 13:01:35','P','KES',50,50,0,'','','',1,50,0,0,'',0,0)
01/03/2023 13:06:02.0394   562 ms.           EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1
01/03/2023 13:27:00.3022  1353 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: 6403
01/03/2023 13:40:56.6301   533 ms.           EXEC: insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2023-03-01 13:40:55',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';

01/03/2023 14:08:00.8948   621 ms.           EXEC: insert into paycash (casCreation,casModify,casUseId,casStatus,casUID,casTraUID,casYear,casDateTime,casIdTerminal,casCurrency,casNumber,casSingleAmount,casTotAmount,casType,casDescription) VALUES ('2023-03-01 14:08:00',0,0,'V',5628783764178830,4919221635874440,2023,'2023-03-01 14:08:00',3,'KES',-1,50,-50,'N','');
insert into paycash (casCreation,casModify,casUseId,casStatus,casUID,casTraUID,casYear,casDateTime,casIdTerminal,casCurrency,casNumber,casSingleAmount,casTotAmount,casType,casDescription) VALUES ('2023-03-01 14:08:00',0,0,'V',5628783764178830,4919221635874440,2023,'2023-03-01 14:08:00',3,'KES',-1,100,-100,'N','');

01/03/2023 18:00:49.0964   632 ms.           EXEC: update movTransit set traEnabled=0, traDisableTime = '2023-03-01 18:00:48' where traUID = 4723737887291630 and traStatus='V' and traEnabled=1
01/03/2023 20:14:43.7287   549 ms.           EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1
01/03/2023 20:30:25.4789   530 ms.           EXEC: update movTransit set traEnabled=0, traDisableTime = '2023-03-01 20:30:24' where traUID = 5617138930015540 and traStatus='V' and traEnabled=1