13/01/2024 08:58:17.4478   609 ms.           EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2024-01-13 08:58:16',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';

13/01/2024 09:46:19.4273  1093 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
13/01/2024 12:18:19.8932   657 ms.           EXEC: update payReceipt set recCreation = '2024-01-13 12:18:19',recModify = '2024-01-13 12:18:19',recUseId=0,recStatus='V' where recId = 217252
13/01/2024 12:26:23.7237   531 ms.           EXEC: update paycash set casCreation = '2024-01-13 12:26:23',casModify = '2024-01-13 12:26:23',casUseId=0,casStatus='V' where casId = 140940
13/01/2024 12:26:24.4268   703 ms.           EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2024-01-13 12:26:23',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';

13/01/2024 12:34:58.7328   593 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,'2024-01-13 12:34:58','V',5599086778604190,2024,'2024-01-13 12:34:56','453024529600327005012999',1,2,16,'I','',1,0,1,'','0230003944059',13,0)
13/01/2024 13:23:12.7253   530 ms.           EXEC: insert into movBarrier (barUseId,barCreation,barTerId,barAction,barDescription,barPlate) VALUES (1,'2024-01-13 13:23:12',9999,'open','Send command to entry/exit units: Command OPEN on Device Exit 1 ','')
13/01/2024 13:35:12.8616   562 ms.           EXEC: update payPayment set payEnabled=0, payDisableTime = '2024-01-13 13:35:12' where payTraUID = 5059727001953430 and payStatus='V' and payEnabled=1
13/01/2024 14:31:34.9674   531 ms.           EXEC: INSERT INTO movOperator (opeCreation,opeUseId,opeTerId,opeDateTime,opeCode,opeDescription) VALUES ('2024-01-13 14:31:34',0,2,'2024-01-13 14:31:34','','Manual Open Barrier  Exit 1')
13/01/2024 16:31:38.4261   531 ms.           EXEC: update payPayment set payEnabled=0, payDisableTime = '2024-01-13 16:31:37' where payTraUID = 4644853379391320 and payStatus='V' and payEnabled=1
13/01/2024 17:05:34.8543   515 ms.           EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2024-01-13 17:05:34',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';

13/01/2024 17:47:44.9046   609 ms.           EXEC: update movTransit set traEnabled=0, traDisableTime = '2024-01-13 17:47:44' where traUID = 5010243575248610 and traStatus='V' and traEnabled=1
13/01/2024 18:37:17.4022   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,'2024-01-13 18:37:16','V',4960593706150070,2024,'2024-01-13 18:37:15','453026703500327005012999',1,2,16,'I','',1,0,1,'','',4)
13/01/2024 18:38:13.0954   703 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 = 1 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
13/01/2024 20:43:43.7266   548 ms.           EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2024-01-13 20:43:43',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';