04/03/2024 02:37:52.1532 667 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2024-03-04 02:37:51',3,42101,0,200,1,200,1,'I','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'; 04/03/2024 06:49:32.6857 623 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2024-03-04 06:49:31',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'; 04/03/2024 09:04:47.1765 715 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 04/03/2024 11:32:51.5247 579 ms. EXEC: INSERT INTO movOperator (opeCreation,opeUseId,opeTerId,opeDateTime,opeCode,opeDescription) VALUES ('2024-03-04 11:32:50',0,2,'2024-03-04 11:32:50','','Unauthorized Transit Exit 1') 04/03/2024 11:45:49.6088 665 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2024-03-04 11:45:48',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'; 04/03/2024 11:58:27.7475 645 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 04/03/2024 12:04:41.6741 532 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2024-03-04 12:04:41',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'; 04/03/2024 12:15:37.0902 798 ms. EXEC: update payReceipt set recCreation = '2024-03-04 12:15:36',recModify = '2024-03-04 12:15:36',recUseId=0,recStatus='V' where recId = 235311 04/03/2024 12:28:10.6285 792 ms. OPEN: select * from movTransit inner join paypayment on paypayment.payTraUID = movTransit.traUID where traCode = '453534129400327005012999' and traStatus='V' and payStatus='V' order by payDateTime desc 04/03/2024 12:28:11.7418 1062 ms. OPEN: select payClosePeriod from paypayment inner join movtransit on paypayment.payTraUID=movtransit.traUID where movtransit.traStatus='V' AND traCode=@traCode and paypayment.payStatus='V' and paypayment.payClosePeriod is not null order by paypayment.payClosePeriod desc limit 1 04/03/2024 12:28:12.8371 631 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2024-03-04 12:28:12' where payTraUID = 5408658776242980 and payStatus='V' and payEnabled=1 04/03/2024 12:28:35.3253 686 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 04/03/2024 12:39:12.3502 513 ms. EXEC: insert into paycash (casCreation,casModify,casUseId,casStatus,casUID,casTraUID,casYear,casDateTime,casIdTerminal,casCurrency,casNumber,casSingleAmount,casTotAmount,casType,casDescription) VALUES ('2024-03-04 12:39:11',0,0,'V',4874801018843550,4626389222402240,2024,'2024-03-04 12:39:11',3,'KES',1,50,50,'N',''); 04/03/2024 13:30:25.9489 557 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 ('2024-03-04 13:34:15',9,'V',4794201474873880,5221523018672920,2024,'2024-03-04 13:34:15',4,1,0,4,'2024-03-04 13:49:15','P','KES',50,50,0,'','','',1,50,0,0,'',0,0) 04/03/2024 17:12:59.6106 506 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2024-03-04 17:12:59' where traUID = 5246608790570510 and traStatus='V' and traEnabled=1 04/03/2024 20:07:38.9999 573 ms. EXEC: insert into paycash (casCreation,casModify,casUseId,casStatus,casUID,casTraUID,casYear,casDateTime,casIdTerminal,casCurrency,casNumber,casSingleAmount,casTotAmount,casType,casDescription) VALUES ('2024-03-04 20:07:38',0,0,'V',4691224954893930,5056110478776080,2024,'2024-03-04 20:07:38',3,'KES',1,50,50,'N',''); 04/03/2024 20:50:52.3180 1445 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,'2024-03-04 20:50:50','V',5362207321766600,2024,'2024-03-04 20:50:50','453537505000327005012999',1,2,16,'I','',1,0,1,'','',4)