16/12/2023 00:21:59.6810   671 ms.           EXEC: insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2023-12-16 00:21:58',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';

16/12/2023 08:11:54.1449   796 ms.           EXEC: insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2023-12-16 08:11:48',5,3,42101,0,50,-3,-150,1,'O','N');
insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2023-12-16 08:11:48',5,3,42101,0,50,3,150,2,'I','N');
insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2023-12-16 08:11:48',5,3,42101,0,100,-48,-4800,1,'O','N');
insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2023-12-16 08:11:48',5,3,42101,0,100,48,4800,2,'I','N');
insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2023-12-16 08:11:48',5,3,42101,0,200,-6,-1200,1,'O','N');
insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2023-12-16 08:11:48',5,3,42101,0,200,6,1200,2,'I','N');
insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2023-12-16 08:11:48',5,3,42101,0,500,-1,-500,1,'O','N');
insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2023-12-16 08:11:48',5,3,42101,0,500,1,500,2,'I','N');
insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2023-12-16 08:11:48',5,3,42101,0,1000,-2,-2000,1,'O','N');
insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2023-12-16 08:11:48',5,3,42101,0,1000,2,2000,2,'I','N');
insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2023-12-16 08:11:48',5,3,42101,1,0,0,0,1,'O','');
update payCurInventory set curQuantity=0,curAmount=0 where curQuantity<0;

16/12/2023 08:19:22.5608   578 ms.           EXEC: insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2023-12-16 08:19:17',5,3,42101,0,50,20,1000,1,'I','N');
update payCurInventory set curQuantity=round(curQuantity+20,5),curAmount=round(curAmount+1000,5) where curTerId = 3 and curDevCode = 42101 and curChannelId = 1 and curValue = 50 and curType = 'N';
insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2023-12-16 08:19:17',5,3,42101,0,100,4,400,1,'I','N');
update payCurInventory set curQuantity=round(curQuantity+4,5),curAmount=round(curAmount+400,5) where curTerId = 3 and curDevCode = 42101 and curChannelId = 1 and curValue = 100 and curType = 'N';
update payCurInventory set curQuantity=0,curAmount=0 where curQuantity<0;

16/12/2023 08:43:37.3467   891 ms.           OPEN: select count(payId) as Tot,0 as payUID,sum(payPayed) as payPayed,sum(payChange) as payChange,payAmount,traUIDGroup,traType,traClass,traIdTerminal,traDiscountValue,traDiscountType,traCarId,payIdEvent,payType,payCardType from payPayment LEFT join movtransit on trauid = payTraUID LEFT JOIN payReport ON repPayUID = payUID AND repStatus='V' where payStatus = 'V' and (payType='C' or payType='P') and payUseId = 6 and payIdEvent<90 and repPayUID IS NULL and (traCarId is null or traCarId=0 or traCarId in (select carId from abbCards inner join abbsubscriptions on subId= carSubId where carStatus='V' and subStatus='V' and subAbbType<>5)) group by traUIDGroup,payAmount,payIdEvent,payType,payCardType,traType,traIdTerminal,traDiscountValue,traDiscountType,traCarId order by traUIDGroup,payAmount, traType, traDiscountValue, traDiscountType
16/12/2023 09:53:14.1532   531 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-12-16 09:53:13','V',5265000010162230,2023,'2023-12-16 09:53:12','452743387000327005012999',2,2,2,'O','',0,'2023-12-16 09:53:13',1,'','',0)
16/12/2023 10:50:53.8389   562 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-12-16 10:50:53','V',5545846836231740,2023,'2023-12-16 10:50:52','452743905200327005012999',1,2,16,'I','',1,0,1,'','',4)
16/12/2023 12:13:08.4533   578 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-12-16 12:16:23',6,'V',5615558039117540,5101622764450820,2023,'2023-12-16 12:16:23',4,1,0,4,'2023-12-16 12:31:23','P','KES',100,100,0,'','','',1,100,0,0,'',0,0)
16/12/2023 12:28:11.5514   610 ms.           EXEC: update movTransit set traEnabled=0, traDisableTime = '2023-12-16 12:28:10' where traUID = 5475286026511770 and traStatus='V' and traEnabled=1
16/12/2023 12:47:47.2775  1063 ms.           EXEC: insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2023-12-16 12:47:46',3,42101,0,50,1,50,2,'I','N');
update payCurInventory set curQuantity=round(curQuantity+1,5),curAmount=round(curAmount+50,5) where curTerId = 3 and curDevCode = 42101 and curChannelId = 2 and curValue = 50 and curType = 'N';

16/12/2023 12:58:29.3345   547 ms.           EXEC: update tabTerminalReceipt set trcProgressive = 22068, trcLastPrinted = '2300422068', trcLastDate = '2023-12-16 12:58:28' where trcStatus='V' and trcTerId = 4
16/12/2023 13:31:46.4115   547 ms.           EXEC: update movTransit set traEnabled=0, traDisableTime = '2023-12-16 13:31:45' where traUID = 5347043518506690 and traStatus='V' and traEnabled=1
16/12/2023 13:47:13.2921   593 ms.           EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2023-12-16 13:47: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';

16/12/2023 13:52:06.1991   515 ms.           EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1
16/12/2023 14:09:02.2714   609 ms.           EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2023-12-16 14:09:01',3,42101,0,500,1,500,1,'I','N');
update payCurInventory set curQuantity=round(curQuantity+1,5),curAmount=round(curAmount+500,5) where curTerId = 3 and curDevCode = 42101 and curChannelId = 1 and curValue = 500 and curType = 'N';

16/12/2023 14:21:57.9228   656 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-12-16 14:21:57','V',5467030266435520,2023,'2023-12-16 14:21:56','452744740300327005012999',2,2,2,'O','',0,'2023-12-16 14:21:57',1,'','',0)
16/12/2023 15:13:03.2020   531 ms.           EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2023-12-16 15:13:02',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';

16/12/2023 15:59:03.7854   546 ms.           EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1
16/12/2023 16:46:26.4803   633 ms.           EXEC: INSERT INTO movOperator (opeCreation,opeUseId,opeTerId,opeDateTime,opeCode,opeDescription) VALUES ('2023-12-16 16:46:25',1,2,'2023-12-16 16:46:25','','Send command to entry/exit units: Command OPEN on Device Exit 1 ')
16/12/2023 17:02:35.4237   609 ms.           EXEC: update movTransit set traEnabled=0, traDisableTime = '2023-12-16 17:02:34' where traUID = 5323889665607110 and traStatus='V' and traEnabled=1