15/09/2023 07:50:27.4591 542 ms. EXEC: insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2023-09-15 07:50:15',5,3,42101,0,50,-26,-1300,1,'O','N'); insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2023-09-15 07:50:15',5,3,42101,0,50,26,1300,2,'I','N'); insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2023-09-15 07:50:15',5,3,42101,0,100,-43,-4300,1,'O','N'); insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2023-09-15 07:50:15',5,3,42101,0,100,43,4300,2,'I','N'); insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2023-09-15 07:50:15',5,3,42101,0,200,-10,-2000,1,'O','N'); insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2023-09-15 07:50:15',5,3,42101,0,200,10,2000,2,'I','N'); insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2023-09-15 07:50:15',5,3,42101,1,0,0,0,1,'O',''); update payCurInventory set curQuantity=0,curAmount=0 where curQuantity<0; 15/09/2023 08:50:43.7560 551 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-09-15 08:50:43','V',5485575956602520,2023,'2023-09-15 08:50:42','451823184200327005012999',1,2,16,'I','',1,0,1,'','',4) 15/09/2023 09:02:38.1887 4645 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 4 OR lnsTerId=4) 15/09/2023 09:02:52.9897 4715 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-09-15 09:02:48','V',5207502963938200,2023,'2023-09-15 09:02:46','451823256600327005012999',1,2,16,'I','',1,0,1,'','',4) 15/09/2023 09:03:02.5112 3814 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 16 OR lnsTerId=16) 15/09/2023 09:03:12.0806 4037 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 3 15/09/2023 09:03:39.7453 4632 ms. EXEC: insert into temp_tariff (tarId,tarDay,tarHourFrom,tarHourTo,tarNumber,tarAmount,tarPeriod,tarPeriodLength,tarPeriodCount,tarDisabled,rulAmountPeriod,rulAmountPeriodDay) VALUES (16,1,'2023-02-16 00:00:00','2023-02-16 05:59:59',1,100,1,1,1,0,0,0); insert into temp_tariff (tarId,tarDay,tarHourFrom,tarHourTo,tarNumber,tarAmount,tarPeriod,tarPeriodLength,tarPeriodCount,tarDisabled,rulAmountPeriod,rulAmountPeriodDay) VALUES (16,2,'2023-02-16 00:00:00','2023-02-16 05:59:59',1,100,1,1,1,0,0,0); insert into temp_tariff (tarId,tarDay,tarHourFrom,tarHourTo,tarNumber,tarAmount,tarPeriod,tarPeriodLength,tarPeriodCount,tarDisabled,rulAmountPeriod,rulAmountPeriodDay) VALUES (16,3,'2023-02-16 00:00:00','2023-02-16 05:59:59',1,100,1,1,1,0,0,0); insert into temp_tariff (tarId,tarDay,tarHourFrom,tarHourTo,tarNumber,tarAmount,tarPeriod,tarPeriodLength,tarPeriodCount,tarDisabled,rulAmountPeriod,rulAmountPeriodDay) VALUES (16,4,'2023-02-16 00:00:00','2023-02-16 05:59:59',1,100,1,1,1,0,0,0); insert into temp_tariff (tarId,tarDay,tarHourFrom,tarHourTo,tarNumber,tarAmount,tarPeriod,tarPeriodLength,tarPeriodCount,tarDisabled,rulAmountPeriod,rulAmountPeriodDay) VALUES (16,5,'2023-02-16 00:00:00','2023-02-16 05:59:59',1,100,1,1,1,0,0,0); insert into temp_tariff (tarId,tarDay,tarHourFrom,tarHourTo,tarNumber,tarAmount,tarPeriod,tarPeriodLength,tarPeriodCount,tarDisabled,rulAmountPeriod,rulAmountPeriodDay) VALUES (16,6,'2023-02-16 00:00:00','2023-02-16 05:59:59',1,100,1,1,1,0,0,0); insert into temp_tariff (tarId,tarDay,tarHourFrom,tarHourTo,tarNumber,tarAmount,tarPeriod,tarPeriodLength,tarPeriodCount,tarDisabled,rulAmountPeriod,rulAmountPeriodDay) VALUES (16,7,'2023-02-16 00:00:00','2023-02-16 05:59:59',1,100,1,1,1,0,0,0); insert into temp_tariff (tarId,tarDay,tarHourFrom,tarHourTo,tarNumber,tarAmount,tarPeriod,tarPeriodLength,tarPeriodCount,tarDisabled,rulAmountPeriod,rulAmountPeriodDay) VALUES (17,1,'2023-02-16 00:00:00','2023-02-16 05:59:59',2,0,1,0,0,0,0,0); insert into temp_tariff (tarId,tarDay,tarHourFrom,tarHourTo,tarNumber,tarAmount,tarPeriod,tarPeriodLength,tarPeriodCount,tarDisabled,rulAmountPeriod,rulAmountPeriodDay) VALUES (17,2,'2023-02-16 00:00:00','2023-02-16 05:59:59',2,0,1,0,0,0,0,0); insert into temp_tariff (tarId,tarDay,tarHourFrom,tarHourTo,tarNumber,tarAmount,tarPeriod,tarPeriodLength,tarPeriodCount,tarDisabled,rulAmountPeriod,rulAmountPeriodDay) VALUES (17,3,'2023-02-16 00:00:00','2023-02-16 05:59:59',2,0,1,0,0,0,0,0); insert into temp_tariff (tarId,tarDay,tarHourFrom,tarHourTo,tarNumber,tarAmount,tarPeriod,tarPeriodLength,tarPeriodCount,tarDisabled,rulAmountPeriod,rulAmountPeriodDay) VALUES (17,4,'2023-02-16 00:00:00','2023-02-16 05:59:59',2,0,1,0,0,0,0,0); insert into temp_tariff (tarId,tarDay,tarHourFrom,tarHourTo,tarNumber,tarAmount,tarPeriod,tarPeriodLength,tarPeriodCount,tarDisabled,rulAmountPeriod,rulAmountPeriodDay) VALUES (17,5,'2023-02-16 00:00:00','2023-02-16 05:59:59',2,0,1,0,0,0,0,0); insert into temp_tariff (tarId,tarDay,tarHourFrom,tarHourTo,tarNumber,tarAmount,tarPeriod,tarPeriodLength,tarPeriodCount,tarDisabled,rulAmountPeriod,rulAmountPeriodDay) VALUES (17,6,'2023-02-16 00:00:00','2023-02-16 05:59:59',2,0,1,0,0,0,0,0); insert into temp_tariff (tarId,tarDay,tarHourFrom,tarHourTo,tarNumber,tarAmount,tarPeriod,tarPeriodLength,tarPeriodCount,tarDisabled,rulAmountPeriod,rulAmountPeriodDay) VALUES (17,7,'2023-02-16 00:00:00','2023-02-16 05:59:59',2,0,1,0,0,0,0,0); insert into temp_tariff (tarId,tarDay,tarHourFrom,tarHourTo,tarNumber,tarAmount,tarPeriod,tarPeriodLength,tarPeriodCount,tarDisabled,rulAmountPeriod,rulAmountPeriodDay) VALUES (18,1,'2023-02-16 06:00:00','2023-02-16 21:59:59',3,50,1,1,1,0,0,0); insert into temp_tariff (tarId,tarDay,tarHourFrom,tarHourTo,tarNumber,tarAmount,tarPeriod,tarPeriodLength,tarPeriodCount,tarDisabled,rulAmountPeriod,rulAmountPeriodDay) VALUES (18,2,'2023-02-16 06:00:00','2023-02-16 21:59:59',3,50,1,1,1,0,0,0); insert into temp_tariff (tarId,tarDay,tarHourFrom,tarHourTo,tarNumber,tarAmount,tarPeriod,tarPeriodLength,tarPeriodCount,tarDisabled,rulAmountPeriod,rulAmountPeriodDay) VALUES (18,3,'2023-02-16 06:00:00','2023-02-16 21:59:59',3,50,1,1,1,0,0,0); insert into temp_tariff (tarId,tarDay,tarHourFrom,tarHourTo,tarNumber,tarAmount,tarPeriod,tarPeriodLength,tarPeriodCount,tarDisabled,rulAmountPeriod,rulAmountPeriodDay) VALUES (18,4,'2023-02-16 06:00:00','2023-02-16 21:59:59',3,50,1,1,1,0,0,0); insert into temp_tariff (tarId,tarDay,tarHourFrom,tarHourTo,tarNumber,tarAmount,tarPeriod,tarPeriodLength,tarPeriodCount,tarDisabled,rulAmountPeriod,rulAmountPeriodDay) VALUES (18,5,'2023-02-16 06:00:00','2023-02-16 21:59:59',3,50,1,1,1,0,0,0); insert into temp_tariff (tarId,tarDay,tarHourFrom,tarHourTo,tarNumber,tarAmount,tarPeriod,tarPeriodLength,tarPeriodCount,tarDisabled,rulAmountPeriod,rulAmountPeriodDay) VALUES (18,6,'2023-02-16 06:00:00','2023-02-16 21:59:59',3,50,1,1,1,0,0,0); insert into temp_tariff (tarId,tarDay,tarHourFrom,tarHourTo,tarNumber,tarAmount,tarPeriod,tarPeriodLength,tarPeriodCount,tarDisabled,rulAmountPeriod,rulAmountPeriodDay) VALUES (18,7,'2023-02-16 06:00:00','2023-02-16 21:59:59',3,50,1,1,1,0,0,0); insert into temp_tariff (tarId,tarDay,tarHourFrom,tarHourTo,tarNumber,tarAmount,tarPeriod,tarPeriodLength,tarPeriodCount,tarDisabled,rulAmountPeriod,rulAmountPeriodDay) VALUES (19,1,'2023-02-16 06:00:00','2023-02-16 21:59:59',4,0,59,59,1,0,0,0); insert into temp_tariff (tarId,tarDay,tarHourFrom,tarHourTo,tarNumber,tarAmount,tarPeriod,tarPeriodLength,tarPeriodCount,tarDisabled,rulAmountPeriod,rulAmountPeriodDay) VALUES (19,2,'2023-02-16 06:00:00','2023-02-16 21:59:59',4,0,59,59,1,0,0,0); insert into temp_tariff (tarId,tarDay,tarHourFrom,tarHourTo,tarNumber,tarAmount,tarPeriod,tarPeriodLength,tarPeriodCount,tarDisabled,rulAmountPeriod,rulAmountPeriodDay) VALUES (19,3,'2023-02-16 06:00:00','2023-02-16 21:59:59',4,0,59,59,1,0,0,0); insert into temp_tariff (tarId,tarDay,tarHourFrom,tarHourTo,tarNumber,tarAmount,tarPeriod,tarPeriodLength,tarPeriodCount,tarDisabled,rulAmountPeriod,rulAmountPeriodDay) VALUES (19,4,'2023-02-16 06:00:00','2023-02-16 21:59:59',4,0,59,59,1,0,0,0); insert into temp_tariff (tarId,tarDay,tarHourFrom,tarHourTo,tarNumber,tarAmount,tarPeriod,tarPeriodLength,tarPeriodCount,tarDisabled,rulAmountPeriod,rulAmountPeriodDay) VALUES (19,5,'2023-02-16 06:00:00','2023-02-16 21:59:59',4,0,59,59,1,0,0,0); insert into temp_tariff (tarId,tarDay,tarHourFrom,tarHourTo,tarNumber,tarAmount,tarPeriod,tarPeriodLength,tarPeriodCount,tarDisabled,rulAmountPeriod,rulAmountPeriodDay) VALUES (19,6,'2023-02-16 06:00:00','2023-02-16 21:59:59',4,0,59,59,1,0,0,0); insert into temp_tariff (tarId,tarDay,tarHourFrom,tarHourTo,tarNumber,tarAmount,tarPeriod,tarPeriodLength,tarPeriodCount,tarDisabled,rulAmountPeriod,rulAmountPeriodDay) VALUES (19,7,'2023-02-16 06:00:00','2023-02-16 21:59:59',4,0,59,59,1,0,0,0); insert into temp_tariff (tarId,tarDay,tarHourFrom,tarHourTo,tarNumber,tarAmount,tarPeriod,tarPeriodLength,tarPeriodCount,tarDisabled,rulAmountPeriod,rulAmountPeriodDay) VALUES (20,1,'2023-02-16 06:00:00','2023-02-16 21:59:59',5,50,1,1,1,0,0,0); insert into temp_tariff (tarId,tarDay,tarHourFrom,tarHourTo,tarNumber,tarAmount,tarPeriod,tarPeriodLength,tarPeriodCount,tarDisabled,rulAmountPeriod,rulAmountPeriodDay) VALUES (20,2,'2023-02-16 06:00:00','2023-02-16 21:59:59',5,50,1,1,1,0,0,0); insert into temp_tariff (tarId,tarDay,tarHourFrom,tarHourTo,tarNumber,tarAmount,tarPeriod,tarPeriodLength,tarPeriodCount,tarDisabled,rulAmountPeriod,rulAmountPeriodDay) VALUES (20,3,'2023-02-16 06:00:00','2023-02-16 21:59:59',5,50,1,1,1,0,0,0); insert into temp_tariff (tarId,tarDay,tarHourFrom,tarHourTo,tarNumber,tarAmount,tarPeriod,tarPeriodLength,tarPeriodCount,tarDisabled,rulAmountPeriod,rulAmountPeriodDay) VALUES (20,4,'2023-02-16 06:00:00','2023-02-16 21:59:59',5,50,1,1,1,0,0,0); insert into temp_tariff (tarId,tarDay,tarHourFrom,tarHourTo,tarNumber,tarAmount,tarPeriod,tarPeriodLength,tarPeriodCount,tarDisabled,rulAmountPeriod,rulAmountPeriodDay) VALUES (20,5,'2023-02-16 06:00:00','2023-02-16 21:59:59',5,50,1,1,1,0,0,0); insert into temp_tariff (tarId,tarDay,tarHourFrom,tarHourTo,tarNumber,tarAmount,tarPeriod,tarPeriodLength,tarPeriodCount,tarDisabled,rulAmountPeriod,rulAmountPeriodDay) VALUES (20,6,'2023-02-16 06:00:00','2023-02-16 21:59:59',5,50,1,1,1,0,0,0); insert into temp_tariff (tarId,tarDay,tarHourFrom,tarHourTo,tarNumber,tarAmount,tarPeriod,tarPeriodLength,tarPeriodCount,tarDisabled,rulAmountPeriod,rulAmountPeriodDay) VALUES (20,7,'2023-02-16 06:00:00','2023-02-16 21:59:59',5,50,1,1,1,0,0,0); insert into temp_tariff (tarId,tarDay,tarHourFrom,tarHourTo,tarNumber,tarAmount,tarPeriod,tarPeriodLength,tarPeriodCount,tarDisabled,rulAmountPeriod,rulAmountPeriodDay) VALUES (21,1,'2023-02-16 06:00:00','2023-02-16 21:59:59',6,0,119,119,1,0,0,0); insert into temp_tariff (tarId,tarDay,tarHourFrom,tarHourTo,tarNumber,tarAmount,tarPeriod,tarPeriodLength,tarPeriodCount,tarDisabled,rulAmountPeriod,rulAmountPeriodDay) VALUES (21,2,'2023-02-16 06:00:00','2023-02-16 21:59:59',6,0,119,119,1,0,0,0); insert into temp_tariff (tarId,tarDay,tarHourFrom,tarHourTo,tarNumber,tarAmount,tarPeriod,tarPeriodLength,tarPeriodCount,tarDisabled,rulAmountPeriod,rulAmountPeriodDay) VALUES (21,3,'2023-02-16 06:00:00','2023-02-16 21:59:59',6,0,119,119,1,0,0,0); insert into temp_tariff (tarId,tarDay,tarHourFrom,tarHourTo,tarNumber,tarAmount,tarPeriod,tarPeriodLength,tarPeriodCount,tarDisabled,rulAmountPeriod,rulAmountPeriodDay) VALUES (21,4,'2023-02-16 06:00:00','2023-02-16 21:59:59',6,0,119,119,1,0,0,0); insert into temp_tariff (tarId,tarDay,tarHourFrom,tarHourTo,tarNumber,tarAmount,tarPeriod,tarPeriodLength,tarPeriodCount,tarDisabled,rulAmountPeriod,rulAmountPeriodDay) VALUES (21,5,'2023-02-16 06:00:00','2023-02-16 21:59:59',6,0,119,119,1,0,0,0); insert into temp_tariff (tarId,tarDay,tarHourFrom,tarHourTo,tarNumber,tarAmount,tarPeriod,tarPeriodLength,tarPeriodCount,tarDisabled,rulAmountPeriod,rulAmountPeriodDay) VALUES (21,6,'2023-02-16 06:00:00','2023-02-16 21:59:59',6,0,119,119,1,0,0,0); insert into temp_tariff (tarId,tarDay,tarHourFrom,tarHourTo,tarNumber,tarAmount,tarPeriod,tarPeriodLength,tarPeriodCount,tarDisabled,rulAmountPeriod,rulAmountPeriodDay) VALUES (21,7,'2023-02-16 06:00:00','2023-02-16 21:59:59',6,0,119,119,1,0,0,0); insert into temp_tariff (tarId,tarDay,tarHourFrom,tarHourTo,tarNumber,tarAmount,tarPeriod,tarPeriodLength,tarPeriodCount,tarDisabled,rulAmountPeriod,rulAmountPeriodDay) VALUES (22,1,'2023-02-16 06:00:00','2023-02-16 21:59:59',7,100,1,1,1,0,0,0); insert into temp_tariff (tarId,tarDay,tarHourFrom,tarHourTo,tarNumber,tarAmount,tarPeriod,tarPeriodLength,tarPeriodCount,tarDisabled,rulAmountPeriod,rulAmountPeriodDay) VALUES (22,2,'2023-02-16 06:00:00','2023-02-16 21:59:59',7,100,1,1,1,0,0,0); insert into temp_tariff (tarId,tarDay,tarHourFrom,tarHourTo,tarNumber,tarAmount,tarPeriod,tarPeriodLength,tarPeriodCount,tarDisabled,rulAmountPeriod,rulAmountPeriodDay) VALUES (22,3,'2023-02-16 06:00:00','2023-02-16 21:59:59',7,100,1,1,1,0,0,0); insert into temp_tariff (tarId,tarDay,tarHourFrom,tarHourTo,tarNumber,tarAmount,tarPeriod,tarPeriodLength,tarPeriodCount,tarDisabled,rulAmountPeriod,rulAmountPeriodDay) VALUES (22,4,'2023-02-16 06:00:00','2023-02-16 21:59:59',7,100,1,1,1,0,0,0); insert into temp_tariff (tarId,tarDay,tarHourFrom,tarHourTo,tarNumber,tarAmount,tarPeriod,tarPeriodLength,tarPeriodCount,tarDisabled,rulAmountPeriod,rulAmountPeriodDay) VALUES (22,5,'2023-02-16 06:00:00','2023-02-16 21:59:59',7,100,1,1,1,0,0,0); insert into temp_tariff (tarId,tarDay,tarHourFrom,tarHourTo,tarNumber,tarAmount,tarPeriod,tarPeriodLength,tarPeriodCount,tarDisabled,rulAmountPeriod,rulAmountPeriodDay) VALUES (22,6,'2023-02-16 06:00:00','2023-02-16 21:59:59',7,100,1,1,1,0,0,0); insert into temp_tariff (tarId,tarDay,tarHourFrom,tarHourTo,tarNumber,tarAmount,tarPeriod,tarPeriodLength,tarPeriodCount,tarDisabled,rulAmountPeriod,rulAmountPeriodDay) VALUES (22,7,'2023-02-16 06:00:00','2023-02-16 21:59:59',7,100,1,1,1,0,0,0); insert into temp_tariff (tarId,tarDay,tarHourFrom,tarHourTo,tarNumber,tarAmount,tarPeriod,tarPeriodLength,tarPeriodCount,tarDisabled,rulAmountPeriod,rulAmountPeriodDay) VALUES (23,1,'2023-02-16 06:00:00','2023-02-16 21:59:59',8,0,59,59,1,0,0,0); insert into temp_tariff (tarId,tarDay,tarHourFrom,tarHourTo,tarNumber,tarAmount,tarPeriod,tarPeriodLength,tarPeriodCount,tarDisabled,rulAmountPeriod,rulAmountPeriodDay) VALUES (23,2,'2023-02-16 06:00:00','2023-02-16 21:59:59',8,0,59,59,1,0,0,0); insert into temp_tariff (tarId,tarDay,tarHourFrom,tarHourTo,tarNumber,tarAmount,tarPeriod,tarPeriodLength,tarPeriodCount,tarDisabled,rulAmountPeriod,rulAmountPeriodDay) VALUES (23,3,'2023-02-16 06:00:00','2023-02-16 21:59:59',8,0,59,59,1,0,0,0); insert into temp_tariff (tarId,tarDay,tarHourFrom,tarHourTo,tarNumber,tarAmount,tarPeriod,tarPeriodLength,tarPeriodCount,tarDisabled,rulAmountPeriod,rulAmountPeriodDay) VALUES (23,4,'2023-02-16 06:00:00','2023-02-16 21:59:59',8,0,59,59,1,0,0,0); insert into temp_tariff (tarId,tarDay,tarHourFrom,tarHourTo,tarNumber,tarAmount,tarPeriod,tarPeriodLength,tarPeriodCount,tarDisabled,rulAmountPeriod,rulAmountPeriodDay) VALUES (23,5,'2023-02-16 06:00:00','2023-02-16 21:59:59',8,0,59,59,1,0,0,0); insert into temp_tariff (tarId,tarDay,tarHourFrom,tarHourTo,tarNumber,tarAmount,tarPeriod,tarPeriodLength,tarPeriodCount,tarDisabled,rulAmountPeriod,rulAmountPeriodDay) VALUES (23,6,'2023-02-16 06:00:00','2023-02-16 21:59:59',8,0,59,59,1,0,0,0); insert into temp_tariff (tarId,tarDay,tarHourFrom,tarHourTo,tarNumber,tarAmount,tarPeriod,tarPeriodLength,tarPeriodCount,tarDisabled,rulAmountPeriod,rulAmountPeriodDay) VALUES (23,7,'2023-02-16 06:00:00','2023-02-16 21:59:59',8,0,59,59,1,0,0,0); insert into temp_tariff (tarId,tarDay,tarHourFrom,tarHourTo,tarNumber,tarAmount,tarPeriod,tarPeriodLength,tarPeriodCount,tarDisabled,rulAmountPeriod,rulAmountPeriodDay) VALUES (24,1,'2023-02-16 06:00:00','2023-02-16 21:59:59',9,100,60,0,0,0,0,0); insert into temp_tariff (tarId,tarDay,tarHourFrom,tarHourTo,tarNumber,tarAmount,tarPeriod,tarPeriodLength,tarPeriodCount,tarDisabled,rulAmountPeriod,rulAmountPeriodDay) VALUES (24,2,'2023-02-16 06:00:00','2023-02-16 21:59:59',9,100,60,0,0,0,0,0); insert into temp_tariff (tarId,tarDay,tarHourFrom,tarHourTo,tarNumber,tarAmount,tarPeriod,tarPeriodLength,tarPeriodCount,tarDisabled,rulAmountPeriod,rulAmountPeriodDay) VALUES (24,3,'2023-02-16 06:00:00','2023-02-16 21:59:59',9,100,60,0,0,0,0,0); insert into temp_tariff (tarId,tarDay,tarHourFrom,tarHourTo,tarNumber,tarAmount,tarPeriod,tarPeriodLength,tarPeriodCount,tarDisabled,rulAmountPeriod,rulAmountPeriodDay) VALUES (24,4,'2023-02-16 06:00:00','2023-02-16 21:59:59',9,100,60,0,0,0,0,0); insert into temp_tariff (tarId,tarDay,tarHourFrom,tarHourTo,tarNumber,tarAmount,tarPeriod,tarPeriodLength,tarPeriodCount,tarDisabled,rulAmountPeriod,rulAmountPeriodDay) VALUES (24,5,'2023-02-16 06:00:00','2023-02-16 21:59:59',9,100,60,0,0,0,0,0); insert into temp_tariff (tarId,tarDay,tarHourFrom,tarHourTo,tarNumber,tarAmount,tarPeriod,tarPeriodLength,tarPeriodCount,tarDisabled,rulAmountPeriod,rulAmountPeriodDay) VALUES (24,6,'2023-02-16 06:00:00','2023-02-16 21:59:59',9,100,60,0,0,0,0,0); insert into temp_tariff (tarId,tarDay,tarHourFrom,tarHourTo,tarNumber,tarAmount,tarPeriod,tarPeriodLength,tarPeriodCount,tarDisabled,rulAmountPeriod,rulAmountPeriodDay) VALUES (24,7,'2023-02-16 06:00:00','2023-02-16 21:59:59',9,100,60,0,0,0,0,0); insert into temp_tariff (tarId,tarDay,tarHourFrom,tarHourTo,tarNumber,tarAmount,tarPeriod,tarPeriodLength,tarPeriodCount,tarDisabled,rulAmountPeriod,rulAmountPeriodDay) VALUES (25,1,'2023-02-16 22:00:00','2023-02-16 23:57:59',10,100,57,57,1,0,0,0); insert into temp_tariff (tarId,tarDay,tarHourFrom,tarHourTo,tarNumber,tarAmount,tarPeriod,tarPeriodLength,tarPeriodCount,tarDisabled,rulAmountPeriod,rulAmountPeriodDay) VALUES (25,2,'2023-02-16 22:00:00','2023-02-16 23:57:59',10,100,57,57,1,0,0,0); insert into temp_tariff (tarId,tarDay,tarHourFrom,tarHourTo,tarNumber,tarAmount,tarPeriod,tarPeriodLength,tarPeriodCount,tarDisabled,rulAmountPeriod,rulAmountPeriodDay) VALUES (25,3,'2023-02-16 22:00:00','2023-02-16 23:57:59',10,100,57,57,1,0,0,0); insert into temp_tariff (tarId,tarDay,tarHourFrom,tarHourTo,tarNumber,tarAmount,tarPeriod,tarPeriodLength,tarPeriodCount,tarDisabled,rulAmountPeriod,rulAmountPeriodDay) VALUES (25,4,'2023-02-16 22:00:00','2023-02-16 23:57:59',10,100,57,57,1,0,0,0); insert into temp_tariff (tarId,tarDay,tarHourFrom,tarHourTo,tarNumber,tarAmount,tarPeriod,tarPeriodLength,tarPeriodCount,tarDisabled,rulAmountPeriod,rulAmountPeriodDay) VALUES (25,5,'2023-02-16 22:00:00','2023-02-16 23:57:59',10,100,57,57,1,0,0,0); insert into temp_tariff (tarId,tarDay,tarHourFrom,tarHourTo,tarNumber,tarAmount,tarPeriod,tarPeriodLength,tarPeriodCount,tarDisabled,rulAmountPeriod,rulAmountPeriodDay) VALUES (25,6,'2023-02-16 22:00:00','2023-02-16 23:57:59',10,100,57,57,1,0,0,0); insert into temp_tariff (tarId,tarDay,tarHourFrom,tarHourTo,tarNumber,tarAmount,tarPeriod,tarPeriodLength,tarPeriodCount,tarDisabled,rulAmountPeriod,rulAmountPeriodDay) VALUES (25,7,'2023-02-16 22:00:00','2023-02-16 23:57:59',10,100,57,57,1,0,0,0); insert into temp_tariff (tarId,tarDay,tarHourFrom,tarHourTo,tarNumber,tarAmount,tarPeriod,tarPeriodLength,tarPeriodCount,tarDisabled,rulAmountPeriod,rulAmountPeriodDay) VALUES (26,1,'2023-02-16 22:00:00','2023-02-16 23:57:59',11,0,1,0,0,0,0,0); insert into temp_tariff (tarId,tarDay,tarHourFrom,tarHourTo,tarNumber,tarAmount,tarPeriod,tarPeriodLength,tarPeriodCount,tarDisabled,rulAmountPeriod,rulAmountPeriodDay) VALUES (26,2,'2023-02-16 22:00:00','2023-02-16 23:57:59',11,0,1,0,0,0,0,0); insert into temp_tariff (tarId,tarDay,tarHourFrom,tarHourTo,tarNumber,tarAmount,tarPeriod,tarPeriodLength,tarPeriodCount,tarDisabled,rulAmountPeriod,rulAmountPeriodDay) VALUES (26,3,'2023-02-16 22:00:00','2023-02-16 23:57:59',11,0,1,0,0,0,0,0); insert into temp_tariff (tarId,tarDay,tarHourFrom,tarHourTo,tarNumber,tarAmount,tarPeriod,tarPeriodLength,tarPeriodCount,tarDisabled,rulAmountPeriod,rulAmountPeriodDay) VALUES (26,4,'2023-02-16 22:00:00','2023-02-16 23:57:59',11,0,1,0,0,0,0,0); insert into temp_tariff (tarId,tarDay,tarHourFrom,tarHourTo,tarNumber,tarAmount,tarPeriod,tarPeriodLength,tarPeriodCount,tarDisabled,rulAmountPeriod,rulAmountPeriodDay) VALUES (26,5,'2023-02-16 22:00:00','2023-02-16 23:57:59',11,0,1,0,0,0,0,0); insert into temp_tariff (tarId,tarDay,tarHourFrom,tarHourTo,tarNumber,tarAmount,tarPeriod,tarPeriodLength,tarPeriodCount,tarDisabled,rulAmountPeriod,rulAmountPeriodDay) VALUES (26,6,'2023-02-16 22:00:00','2023-02-16 23:57:59',11,0,1,0,0,0,0,0); insert into temp_tariff (tarId,tarDay,tarHourFrom,tarHourTo,tarNumber,tarAmount,tarPeriod,tarPeriodLength,tarPeriodCount,tarDisabled,rulAmountPeriod,rulAmountPeriodDay) VALUES (26,7,'2023-02-16 22:00:00','2023-02-16 23:57:59',11,0,1,0,0,0,0,0); insert into temp_tariff (tarId,tarDay,tarHourFrom,tarHourTo,tarNumber,tarAmount,tarPeriod,tarPeriodLength,tarPeriodCount,tarDisabled,rulAmountPeriod,rulAmountPeriodDay) VALUES (27,1,'2023-02-16 23:58:00','2023-02-16 23:59:59',12,-100,1,1,1,0,0,0); insert into temp_tariff (tarId,tarDay,tarHourFrom,tarHourTo,tarNumber,tarAmount,tarPeriod,tarPeriodLength,tarPeriodCount,tarDisabled,rulAmountPeriod,rulAmountPeriodDay) VALUES (27,2,'2023-02-16 23:58:00','2023-02-16 23:59:59',12,-100,1,1,1,0,0,0); insert into temp_tariff (tarId,tarDay,tarHourFrom,tarHourTo,tarNumber,tarAmount,tarPeriod,tarPeriodLength,tarPeriodCount,tarDisabled,rulAmountPeriod,rulAmountPeriodDay) VALUES (27,3,'2023-02-16 23:58:00','2023-02-16 23:59:59',12,-100,1,1,1,0,0,0); insert into temp_tariff (tarId,tarDay,tarHourFrom,tarHourTo,tarNumber,tarAmount,tarPeriod,tarPeriodLength,tarPeriodCount,tarDisabled,rulAmountPeriod,rulAmountPeriodDay) VALUES (27,4,'2023-02-16 23:58:00','2023-02-16 23:59:59',12,-100,1,1,1,0,0,0); insert into temp_tariff (tarId,tarDay,tarHourFrom,tarHourTo,tarNumber,tarAmount,tarPeriod,tarPeriodLength,tarPeriodCount,tarDisabled,rulAmountPeriod,rulAmountPeriodDay) VALUES (27,5,'2023-02-16 23:58:00','2023-02-16 23:59:59',12,-100,1,1,1,0,0,0); insert into temp_tariff (tarId,tarDay,tarHourFrom,tarHourTo,tarNumber,tarAmount,tarPeriod,tarPeriodLength,tarPeriodCount,tarDisabled,rulAmountPeriod,rulAmountPeriodDay) VALUES (27,6,'2023-02-16 23:58:00','2023-02-16 23:59:59',12,-100,1,1,1,0,0,0); insert into temp_tariff (tarId,tarDay,tarHourFrom,tarHourTo,tarNumber,tarAmount,tarPeriod,tarPeriodLength,tarPeriodCount,tarDisabled,rulAmountPeriod,rulAmountPeriodDay) VALUES (27,7,'2023-02-16 23:58:00','2023-02-16 23:59:59',12,-100,1,1,1,0,0,0); insert into temp_tariff (tarId,tarDay,tarHourFrom,tarHourTo,tarNumber,tarAmount,tarPeriod,tarPeriodLength,tarPeriodCount,tarDisabled,rulAmountPeriod,rulAmountPeriodDay) VALUES (28,1,'2023-02-16 23:58:00','2023-02-16 23:59:59',13,0,1,0,0,0,0,0); insert into temp_tariff (tarId,tarDay,tarHourFrom,tarHourTo,tarNumber,tarAmount,tarPeriod,tarPeriodLength,tarPeriodCount,tarDisabled,rulAmountPeriod,rulAmountPeriodDay) VALUES (28,2,'2023-02-16 23:58:00','2023-02-16 23:59:59',13,0,1,0,0,0,0,0); insert into temp_tariff (tarId,tarDay,tarHourFrom,tarHourTo,tarNumber,tarAmount,tarPeriod,tarPeriodLength,tarPeriodCount,tarDisabled,rulAmountPeriod,rulAmountPeriodDay) VALUES (28,3,'2023-02-16 23:58:00','2023-02-16 23:59:59',13,0,1,0,0,0,0,0); insert into temp_tariff (tarId,tarDay,tarHourFrom,tarHourTo,tarNumber,tarAmount,tarPeriod,tarPeriodLength,tarPeriodCount,tarDisabled,rulAmountPeriod,rulAmountPeriodDay) VALUES (28,4,'2023-02-16 23:58:00','2023-02-16 23:59:59',13,0,1,0,0,0,0,0); insert into temp_tariff (tarId,tarDay,tarHourFrom,tarHourTo,tarNumber,tarAmount,tarPeriod,tarPeriodLength,tarPeriodCount,tarDisabled,rulAmountPeriod,rulAmountPeriodDay) VALUES (28,5,'2023-02-16 23:58:00','2023-02-16 23:59:59',13,0,1,0,0,0,0,0); insert into temp_tariff (tarId,tarDay,tarHourFrom,tarHourTo,tarNumber,tarAmount,tarPeriod,tarPeriodLength,tarPeriodCount,tarDisabled,rulAmountPeriod,rulAmountPeriodDay) VALUES (28,6,'2023-02-16 23:58:00','2023-02-16 23:59:59',13,0,1,0,0,0,0,0); insert into temp_tariff (tarId,tarDay,tarHourFrom,tarHourTo,tarNumber,tarAmount,tarPeriod,tarPeriodLength,tarPeriodCount,tarDisabled,rulAmountPeriod,rulAmountPeriodDay) VALUES (28,7,'2023-02-16 23:58:00','2023-02-16 23:59:59',13,0,1,0,0,0,0,0); 15/09/2023 09:05:54.5072 4334 ms. OPEN: select * from abbCards where carStatus='V' and carCode='451823087100327005012999' 15/09/2023 09:06:04.1647 4553 ms. EXECSCALAR: select count(resId) as Tot from movReservation where resStatus = 'V' and resTypeRes = 'B' AND ((resConfirmed IN (0,2,3) AND resCreation>'2023-09-15 08:05:59') OR resConfirmed IN (4,5)) and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) <= '2023-09-15 09:05:59' and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) >= '2023-09-15 09:05:59' and (resAreId = 1 or resAreId <= 0) nr: 0 (WAIT TIME 80 ms.) 15/09/2023 09:06:24.9177 4645 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 (WAIT TIME 37 ms.) 15/09/2023 09:06:43.9305 2580 ms. OPEN: select * from tabUserMessage where useMesDescr = 'err_ticketDisabled' and (useLanCode = 'en-US' or mid(useLanCode,1,2) = 'en') 15/09/2023 09:06:44.1397 2275 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 1 OR lnsTerId=1) 15/09/2023 09:06:57.1314 1292 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 5 15/09/2023 09:07:06.4447 4617 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 5 15/09/2023 09:07:06.4507 4722 ms. OPEN: select sum(casTotAmount) as vTot from movTransit inner join payCash on payCash.casTraUID = movTransit.traUID inner join tabTerminal on terId = casIdTerminal where traCode = '451823184200327005012999' and traStatus='V' and casStatus='V' and terType=3 and casTotAmount<0 15/09/2023 09:07:15.9992 4721 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 15/09/2023 09:07:16.0222 4813 ms. OPEN: select * from tabArea where areStatus='V' and areEnabled = 1 AND areId = 1 15/09/2023 09:07:16.2944 4936 ms. EXECSCALAR: select count(0) as vTot from tabParameters where parPlateReading<>0 nr: 0 15/09/2023 09:07:39.7032 4590 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 2 OR lnsTerId=2) 15/09/2023 09:07:58.6960 4377 ms. EXEC: INSERT INTO movOperator (opeCreation,opeUseId,opeTerId,opeDateTime,opeCode,opeDescription) VALUES ('2023-09-15 09:07:54',0,2,'2023-09-15 09:07:54','','Manual Open Barrier Exit 1') 15/09/2023 09:08:08.1954 4666 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 2 OR lnsTerId=2) 15/09/2023 09:08:32.1616 4879 ms. EXECSCALAR: select count(0) as vTot from tabParameters where parPlateReading<>0 nr: 0 15/09/2023 09:08:51.0083 4756 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 15/09/2023 09:08:55.6974 4537 ms. EXECSCALAR: select traId from movtransit where traUID = 5460674694274940 and traStatus='V' nr: 398851 15/09/2023 09:09:00.5557 4781 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 15/09/2023 09:09:24.1957 4644 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 15/09/2023 09:09:57.4921 4438 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2023-09-15 09:09:53' where payTraUID = 5413125901178100 and payStatus='V' and payEnabled=1 15/09/2023 09:11:56.1952 4627 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 5 15/09/2023 09:12:00.9464 4737 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-09-15 09:11:56','V',4799065304563320,2023,'2023-09-15 09:11:27','451823308700327005031999',1,2,16,'I','',1,0,1,'','',4) 15/09/2023 09:12:24.6975 4503 ms. OPEN: select paypayment.payClosePeriod from movtransit inner join paypayment on movtransit.traUID=paypayment.payTraUID where paypayment.payStatus='V' and movtransit.traCode=@TRACODE and paypayment.payClosePeriod is not null order by paypayment.payClosePeriod desc 15/09/2023 09:12:29.5347 4197 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 16 OR lnsTerId=16) 15/09/2023 09:13:02.6971 4610 ms. OPEN: select * from movTransit inner join paypayment on paypayment.payTraUID = movTransit.traUID where traCode = '451823316800327005012999' and traStatus='V' and payStatus='V' order by payDateTime desc 15/09/2023 09:13:02.7241 4659 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 16 OR lnsTerId=16) 15/09/2023 09:14:23.4486 4568 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 15/09/2023 09:14:28.2738 4723 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 2 15/09/2023 09:16:20.6366 3977 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 4 15/09/2023 09:16:44.6308 4154 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 (WAIT TIME 243 ms.) 15/09/2023 09:16:54.1412 4287 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-09-15 09:16:49','V',5273879225611160,2023,'2023-09-15 09:16:31','451823339100327001012999',1,2,1,'I','',1,0,1,'','',4) 15/09/2023 09:17:18.8319 5463 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 15/09/2023 09:18:57.0492 4346 ms. OPEN: SELECT * FROM movTransit WHERE traStatus=@traStatus AND traCode=@traCode AND traDirection=@traDirection ORDER BY traDateTime,traId (WAIT TIME 80 ms.) 15/09/2023 09:19:01.6453 4587 ms. OPEN: select terDefaultClass from tabTerminal where terStatus='V' and terId = 16 15/09/2023 09:19:15.9890 4806 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 15/09/2023 09:19:25.3563 4612 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-09-15 09:19:20','V',5412105829930230,2023,'2023-09-15 09:19:16','451823355600327005012999',1,2,16,'I','',1,0,1,'','',4) 15/09/2023 09:19:49.3354 18549 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 (WAIT TIME 124 ms.) 15/09/2023 09:20:27.1570 4194 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 2 OR lnsTerId=2) (WAIT TIME 29 ms.) 15/09/2023 09:20:31.9782 4227 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 (WAIT TIME 72 ms.) 15/09/2023 09:20:50.9780 4514 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 (WAIT TIME 74 ms.) 15/09/2023 09:21:09.9168 4087 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 (WAIT TIME 34 ms.) 15/09/2023 09:21:25.2982 544 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2023-09-15 09:21:24' where traUID = 4630569669539690 and traStatus='V' and traEnabled=1 15/09/2023 09:21:38.3690 12920 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 15/09/2023 09:21:38.5511 1378 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 2 15/09/2023 09:21:44.3370 5684 ms. OPEN: select sum(casTotAmount) as vTot from movTransit inner join payCash on payCash.casTraUID = movTransit.traUID inner join tabTerminal on terId = casIdTerminal where traCode = '451823293700327005031999' and traStatus='V' and casStatus='V' and terType=3 and casTotAmount<0 15/09/2023 09:21:53.8034 4527 ms. OPEN: select * from movTransit inner join paypayment on paypayment.payTraUID = movTransit.traUID where traCode = '451822897200327005012999' and traStatus='V' and payStatus='V' order by payDateTime desc 15/09/2023 09:21:58.6217 4512 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-09-15 09:21:54','V',4794810735021830,2023,'2023-09-15 09:21:26','451823293700327005031999',2,2,2,'O','',0,'2023-09-15 09:21:54',1,'','',0) 15/09/2023 09:22:03.2968 4667 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 15/09/2023 09:22:12.9003 3726 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 15/09/2023 09:22:27.4211 1681 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 15/09/2023 09:22:41.7688 4709 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 15/09/2023 09:22:51.2302 9430 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 15/09/2023 09:22:55.9213 4602 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 15/09/2023 09:23:00.6705 4669 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 16 OR lnsTerId=16) 15/09/2023 09:23:00.7436 9415 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 5 15/09/2023 09:23:05.4968 9450 ms. EXEC: insert into movOperator (opeCreation,opeTerId,opeUseId,opeDateTime,opeCode,opeDescription) VALUES ('2023-09-15 09:22:51',4,1,'2023-09-15 09:22:51','451822897200327005012999','Payed (Credit Card ) Ticket ') (WAIT TIME 4737 ms.) 15/09/2023 09:23:15.0292 4178 ms. EXEC: update tabTerminalReceipt set trcProgressive = 16627, trcLastPrinted = '2300416627', trcLastDate = '2023-09-15 09:23:10' where trcStatus='V' and trcTerId = 4 (WAIT TIME 69 ms.) 15/09/2023 09:23:29.1998 3786 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-09-15 09:23:25','V',5380783430950440,2023,'2023-09-15 09:22:50','451823377000327005031999',1,2,16,'I','',1,0,1,'','',4) 15/09/2023 09:23:29.2698 3828 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 15/09/2023 09:23:33.9570 4624 ms. OPEN: select * from tabArea where areId = 1 and areStatus='V' and areEnabled = 1 15/09/2023 09:23:43.4214 4219 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-09-15 09:23:39','V',5243058455589520,2023,'2023-09-15 09:23:38','451823381800327005012999',1,2,16,'I','',1,0,1,'','',4) 15/09/2023 09:23:57.7300 3171 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 15/09/2023 09:24:07.1704 4289 ms. EXEC: update opeActivities set acvFstPayId = (case acvFstPayId when 0 then 191767 else acvFstPayId end),acvLstPayId = 191767 where acvSftId = 594 and acvCodeId = 3 15/09/2023 09:24:07.3285 4422 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 1 15/09/2023 09:24:54.7665 3865 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-09-15 09:24:50','V',5116352252952830,2023,'2023-09-15 09:24:07','451823384700327005012999',1,2,16,'I','',1,0,1,'','0230003944081',15,0) (WAIT TIME 93 ms.) 15/09/2023 09:24:54.7815 3906 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 (WAIT TIME 33 ms.) 15/09/2023 09:25:08.9211 4523 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 15/09/2023 09:25:09.0512 4628 ms. OPEN: select traCode from movTransit where traCode ='451823293900327005029999' 15/09/2023 09:25:13.6703 4611 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-09-15 09:25:09','V',4765013159512030,2023,'2023-09-15 09:24:26','451823293900327005029999',2,2,16,'I','',1,0,1,'','0532370677393',15,0) 15/09/2023 09:25:18.4245 752 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 15/09/2023 09:25:27.9549 3313 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 2 OR lnsTerId=2) (WAIT TIME 32 ms.) 15/09/2023 09:25:42.4057 1736 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 15/09/2023 09:26:11.0110 4675 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-09-15 09:26:06','V',4914215519664600,2023,'2023-09-15 09:25:47','451822897200327005012999',2,2,2,'O','',0,'2023-09-15 09:26:06',1,'','',0) (WAIT TIME 137 ms.) 15/09/2023 09:26:11.0820 4686 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 2 (WAIT TIME 151 ms.) 15/09/2023 09:26:20.4733 4569 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2023-09-15 09:26:15' where payTraUID = 5509477069877780 and payStatus='V' and payEnabled=1 (WAIT TIME 98 ms.) 15/09/2023 09:26:25.1675 4568 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2023-09-15 09:26:15' where traUID = 5509477069877780 and traStatus='V' and traEnabled=1 (WAIT TIME 43 ms.) 15/09/2023 09:26:31.2136 5761 ms. EXECSCALAR: select count(0) as vTot from tabParameters where parPlateReading<>0 nr: 0 (WAIT TIME 131 ms.) 15/09/2023 09:27:14.9401 1553 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 15/09/2023 09:27:19.6893 3007 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 15/09/2023 09:27:29.1887 2260 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 15/09/2023 09:27:48.9020 4682 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 15/09/2023 09:28:07.8288 4610 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 5 and terStatus='V' 15/09/2023 09:28:31.5768 4689 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-09-15 09:28:26','V',5419670475942720,2023,'2023-09-15 09:28:23','451823410300327005012999',1,2,16,'I','',1,0,1,'','',4) 15/09/2023 09:28:36.3280 4620 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 15/09/2023 09:28:36.3941 9476 ms. OPEN: select * from tabParameters where parStatus='V' order by parId desc 15/09/2023 09:29:09.6255 3317 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 2 OR lnsTerId=2) 15/09/2023 09:30:21.0196 1716 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 15/09/2023 09:30:46.1606 965 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 15/09/2023 09:31:19.4100 4287 ms. EXECSCALAR: select count(resId) as Tot from movReservation where resStatus = 'V' and resTypeRes = 'B' AND ((resConfirmed IN (0,2,3) AND resCreation>'2023-09-15 08:31:15') OR resConfirmed IN (4,5)) and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) <= '2023-09-15 09:31:15' and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) >= '2023-09-15 09:31:15' and (resAreId = 1 or resAreId <= 0) nr: 0 15/09/2023 09:31:43.1581 4449 ms. EXEC: update tabTerminalReceipt set trcProgressive = 16630, trcLastPrinted = '2300416630', trcLastDate = '2023-09-15 09:31:38' where trcStatus='V' and trcTerId = 4 15/09/2023 09:31:43.2761 4416 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 (WAIT TIME 86 ms.) 15/09/2023 09:32:07.0162 4213 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 (WAIT TIME 26 ms.) 15/09/2023 09:32:21.2167 9405 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 15/09/2023 09:32:35.4413 4280 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-09-15 09:32:31','V',5145101708305250,2023,'2023-09-15 09:32:10','451823433000327005031999',1,2,16,'I','',1,0,1,'','',4) 15/09/2023 09:32:48.4761 3565 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 2 15/09/2023 09:33:40.8625 4238 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 5 15/09/2023 09:33:50.2778 4743 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 5 and terStatus='V' 15/09/2023 09:35:09.9996 4800 ms. OPEN: select * from movTransit inner join paypayment on paypayment.payTraUID = movTransit.traUID where traCode = '451816459900327005012999' and traStatus='V' and payStatus='V' order by payDateTime desc 15/09/2023 09:36:46.1225 4052 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 2 OR lnsTerId=2) (WAIT TIME 139 ms.) 15/09/2023 09:37:35.5288 814 ms. EXEC: insert into temp_tariff (tarId,tarDay,tarHourFrom,tarHourTo,tarNumber,tarAmount,tarPeriod,tarPeriodLength,tarPeriodCount,tarDisabled,rulAmountPeriod,rulAmountPeriodDay) VALUES (16,1,'2023-02-16 00:00:00','2023-02-16 05:59:59',1,100,1,1,1,0,0,0); insert into temp_tariff (tarId,tarDay,tarHourFrom,tarHourTo,tarNumber,tarAmount,tarPeriod,tarPeriodLength,tarPeriodCount,tarDisabled,rulAmountPeriod,rulAmountPeriodDay) VALUES (16,2,'2023-02-16 00:00:00','2023-02-16 05:59:59',1,100,1,1,1,0,0,0); insert into temp_tariff (tarId,tarDay,tarHourFrom,tarHourTo,tarNumber,tarAmount,tarPeriod,tarPeriodLength,tarPeriodCount,tarDisabled,rulAmountPeriod,rulAmountPeriodDay) VALUES (16,3,'2023-02-16 00:00:00','2023-02-16 05:59:59',1,100,1,1,1,0,0,0); insert into temp_tariff (tarId,tarDay,tarHourFrom,tarHourTo,tarNumber,tarAmount,tarPeriod,tarPeriodLength,tarPeriodCount,tarDisabled,rulAmountPeriod,rulAmountPeriodDay) VALUES (16,4,'2023-02-16 00:00:00','2023-02-16 05:59:59',1,100,1,1,1,0,0,0); insert into temp_tariff (tarId,tarDay,tarHourFrom,tarHourTo,tarNumber,tarAmount,tarPeriod,tarPeriodLength,tarPeriodCount,tarDisabled,rulAmountPeriod,rulAmountPeriodDay) VALUES (16,5,'2023-02-16 00:00:00','2023-02-16 05:59:59',1,100,1,1,1,0,0,0); insert into temp_tariff (tarId,tarDay,tarHourFrom,tarHourTo,tarNumber,tarAmount,tarPeriod,tarPeriodLength,tarPeriodCount,tarDisabled,rulAmountPeriod,rulAmountPeriodDay) VALUES (16,6,'2023-02-16 00:00:00','2023-02-16 05:59:59',1,100,1,1,1,0,0,0); insert into temp_tariff (tarId,tarDay,tarHourFrom,tarHourTo,tarNumber,tarAmount,tarPeriod,tarPeriodLength,tarPeriodCount,tarDisabled,rulAmountPeriod,rulAmountPeriodDay) VALUES (16,7,'2023-02-16 00:00:00','2023-02-16 05:59:59',1,100,1,1,1,0,0,0); insert into temp_tariff (tarId,tarDay,tarHourFrom,tarHourTo,tarNumber,tarAmount,tarPeriod,tarPeriodLength,tarPeriodCount,tarDisabled,rulAmountPeriod,rulAmountPeriodDay) VALUES (17,1,'2023-02-16 00:00:00','2023-02-16 05:59:59',2,0,1,0,0,0,0,0); insert into temp_tariff (tarId,tarDay,tarHourFrom,tarHourTo,tarNumber,tarAmount,tarPeriod,tarPeriodLength,tarPeriodCount,tarDisabled,rulAmountPeriod,rulAmountPeriodDay) VALUES (17,2,'2023-02-16 00:00:00','2023-02-16 05:59:59',2,0,1,0,0,0,0,0); insert into temp_tariff (tarId,tarDay,tarHourFrom,tarHourTo,tarNumber,tarAmount,tarPeriod,tarPeriodLength,tarPeriodCount,tarDisabled,rulAmountPeriod,rulAmountPeriodDay) VALUES (17,3,'2023-02-16 00:00:00','2023-02-16 05:59:59',2,0,1,0,0,0,0,0); insert into temp_tariff (tarId,tarDay,tarHourFrom,tarHourTo,tarNumber,tarAmount,tarPeriod,tarPeriodLength,tarPeriodCount,tarDisabled,rulAmountPeriod,rulAmountPeriodDay) VALUES (17,4,'2023-02-16 00:00:00','2023-02-16 05:59:59',2,0,1,0,0,0,0,0); insert into temp_tariff (tarId,tarDay,tarHourFrom,tarHourTo,tarNumber,tarAmount,tarPeriod,tarPeriodLength,tarPeriodCount,tarDisabled,rulAmountPeriod,rulAmountPeriodDay) VALUES (17,5,'2023-02-16 00:00:00','2023-02-16 05:59:59',2,0,1,0,0,0,0,0); insert into temp_tariff (tarId,tarDay,tarHourFrom,tarHourTo,tarNumber,tarAmount,tarPeriod,tarPeriodLength,tarPeriodCount,tarDisabled,rulAmountPeriod,rulAmountPeriodDay) VALUES (17,6,'2023-02-16 00:00:00','2023-02-16 05:59:59',2,0,1,0,0,0,0,0); insert into temp_tariff (tarId,tarDay,tarHourFrom,tarHourTo,tarNumber,tarAmount,tarPeriod,tarPeriodLength,tarPeriodCount,tarDisabled,rulAmountPeriod,rulAmountPeriodDay) VALUES (17,7,'2023-02-16 00:00:00','2023-02-16 05:59:59',2,0,1,0,0,0,0,0); insert into temp_tariff (tarId,tarDay,tarHourFrom,tarHourTo,tarNumber,tarAmount,tarPeriod,tarPeriodLength,tarPeriodCount,tarDisabled,rulAmountPeriod,rulAmountPeriodDay) VALUES (18,1,'2023-02-16 06:00:00','2023-02-16 21:59:59',3,50,1,1,1,0,0,0); insert into temp_tariff (tarId,tarDay,tarHourFrom,tarHourTo,tarNumber,tarAmount,tarPeriod,tarPeriodLength,tarPeriodCount,tarDisabled,rulAmountPeriod,rulAmountPeriodDay) VALUES (18,2,'2023-02-16 06:00:00','2023-02-16 21:59:59',3,50,1,1,1,0,0,0); insert into temp_tariff (tarId,tarDay,tarHourFrom,tarHourTo,tarNumber,tarAmount,tarPeriod,tarPeriodLength,tarPeriodCount,tarDisabled,rulAmountPeriod,rulAmountPeriodDay) VALUES (18,3,'2023-02-16 06:00:00','2023-02-16 21:59:59',3,50,1,1,1,0,0,0); insert into temp_tariff (tarId,tarDay,tarHourFrom,tarHourTo,tarNumber,tarAmount,tarPeriod,tarPeriodLength,tarPeriodCount,tarDisabled,rulAmountPeriod,rulAmountPeriodDay) VALUES (18,4,'2023-02-16 06:00:00','2023-02-16 21:59:59',3,50,1,1,1,0,0,0); insert into temp_tariff (tarId,tarDay,tarHourFrom,tarHourTo,tarNumber,tarAmount,tarPeriod,tarPeriodLength,tarPeriodCount,tarDisabled,rulAmountPeriod,rulAmountPeriodDay) VALUES (18,5,'2023-02-16 06:00:00','2023-02-16 21:59:59',3,50,1,1,1,0,0,0); insert into temp_tariff (tarId,tarDay,tarHourFrom,tarHourTo,tarNumber,tarAmount,tarPeriod,tarPeriodLength,tarPeriodCount,tarDisabled,rulAmountPeriod,rulAmountPeriodDay) VALUES (18,6,'2023-02-16 06:00:00','2023-02-16 21:59:59',3,50,1,1,1,0,0,0); insert into temp_tariff (tarId,tarDay,tarHourFrom,tarHourTo,tarNumber,tarAmount,tarPeriod,tarPeriodLength,tarPeriodCount,tarDisabled,rulAmountPeriod,rulAmountPeriodDay) VALUES (18,7,'2023-02-16 06:00:00','2023-02-16 21:59:59',3,50,1,1,1,0,0,0); insert into temp_tariff (tarId,tarDay,tarHourFrom,tarHourTo,tarNumber,tarAmount,tarPeriod,tarPeriodLength,tarPeriodCount,tarDisabled,rulAmountPeriod,rulAmountPeriodDay) VALUES (19,1,'2023-02-16 06:00:00','2023-02-16 21:59:59',4,0,59,59,1,0,0,0); insert into temp_tariff (tarId,tarDay,tarHourFrom,tarHourTo,tarNumber,tarAmount,tarPeriod,tarPeriodLength,tarPeriodCount,tarDisabled,rulAmountPeriod,rulAmountPeriodDay) VALUES (19,2,'2023-02-16 06:00:00','2023-02-16 21:59:59',4,0,59,59,1,0,0,0); insert into temp_tariff (tarId,tarDay,tarHourFrom,tarHourTo,tarNumber,tarAmount,tarPeriod,tarPeriodLength,tarPeriodCount,tarDisabled,rulAmountPeriod,rulAmountPeriodDay) VALUES (19,3,'2023-02-16 06:00:00','2023-02-16 21:59:59',4,0,59,59,1,0,0,0); insert into temp_tariff (tarId,tarDay,tarHourFrom,tarHourTo,tarNumber,tarAmount,tarPeriod,tarPeriodLength,tarPeriodCount,tarDisabled,rulAmountPeriod,rulAmountPeriodDay) VALUES (19,4,'2023-02-16 06:00:00','2023-02-16 21:59:59',4,0,59,59,1,0,0,0); insert into temp_tariff (tarId,tarDay,tarHourFrom,tarHourTo,tarNumber,tarAmount,tarPeriod,tarPeriodLength,tarPeriodCount,tarDisabled,rulAmountPeriod,rulAmountPeriodDay) VALUES (19,5,'2023-02-16 06:00:00','2023-02-16 21:59:59',4,0,59,59,1,0,0,0); insert into temp_tariff (tarId,tarDay,tarHourFrom,tarHourTo,tarNumber,tarAmount,tarPeriod,tarPeriodLength,tarPeriodCount,tarDisabled,rulAmountPeriod,rulAmountPeriodDay) VALUES (19,6,'2023-02-16 06:00:00','2023-02-16 21:59:59',4,0,59,59,1,0,0,0); insert into temp_tariff (tarId,tarDay,tarHourFrom,tarHourTo,tarNumber,tarAmount,tarPeriod,tarPeriodLength,tarPeriodCount,tarDisabled,rulAmountPeriod,rulAmountPeriodDay) VALUES (19,7,'2023-02-16 06:00:00','2023-02-16 21:59:59',4,0,59,59,1,0,0,0); insert into temp_tariff (tarId,tarDay,tarHourFrom,tarHourTo,tarNumber,tarAmount,tarPeriod,tarPeriodLength,tarPeriodCount,tarDisabled,rulAmountPeriod,rulAmountPeriodDay) VALUES (20,1,'2023-02-16 06:00:00','2023-02-16 21:59:59',5,50,1,1,1,0,0,0); insert into temp_tariff (tarId,tarDay,tarHourFrom,tarHourTo,tarNumber,tarAmount,tarPeriod,tarPeriodLength,tarPeriodCount,tarDisabled,rulAmountPeriod,rulAmountPeriodDay) VALUES (20,2,'2023-02-16 06:00:00','2023-02-16 21:59:59',5,50,1,1,1,0,0,0); insert into temp_tariff (tarId,tarDay,tarHourFrom,tarHourTo,tarNumber,tarAmount,tarPeriod,tarPeriodLength,tarPeriodCount,tarDisabled,rulAmountPeriod,rulAmountPeriodDay) VALUES (20,3,'2023-02-16 06:00:00','2023-02-16 21:59:59',5,50,1,1,1,0,0,0); insert into temp_tariff (tarId,tarDay,tarHourFrom,tarHourTo,tarNumber,tarAmount,tarPeriod,tarPeriodLength,tarPeriodCount,tarDisabled,rulAmountPeriod,rulAmountPeriodDay) VALUES (20,4,'2023-02-16 06:00:00','2023-02-16 21:59:59',5,50,1,1,1,0,0,0); insert into temp_tariff (tarId,tarDay,tarHourFrom,tarHourTo,tarNumber,tarAmount,tarPeriod,tarPeriodLength,tarPeriodCount,tarDisabled,rulAmountPeriod,rulAmountPeriodDay) VALUES (20,5,'2023-02-16 06:00:00','2023-02-16 21:59:59',5,50,1,1,1,0,0,0); insert into temp_tariff (tarId,tarDay,tarHourFrom,tarHourTo,tarNumber,tarAmount,tarPeriod,tarPeriodLength,tarPeriodCount,tarDisabled,rulAmountPeriod,rulAmountPeriodDay) VALUES (20,6,'2023-02-16 06:00:00','2023-02-16 21:59:59',5,50,1,1,1,0,0,0); insert into temp_tariff (tarId,tarDay,tarHourFrom,tarHourTo,tarNumber,tarAmount,tarPeriod,tarPeriodLength,tarPeriodCount,tarDisabled,rulAmountPeriod,rulAmountPeriodDay) VALUES (20,7,'2023-02-16 06:00:00','2023-02-16 21:59:59',5,50,1,1,1,0,0,0); insert into temp_tariff (tarId,tarDay,tarHourFrom,tarHourTo,tarNumber,tarAmount,tarPeriod,tarPeriodLength,tarPeriodCount,tarDisabled,rulAmountPeriod,rulAmountPeriodDay) VALUES (21,1,'2023-02-16 06:00:00','2023-02-16 21:59:59',6,0,119,119,1,0,0,0); insert into temp_tariff (tarId,tarDay,tarHourFrom,tarHourTo,tarNumber,tarAmount,tarPeriod,tarPeriodLength,tarPeriodCount,tarDisabled,rulAmountPeriod,rulAmountPeriodDay) VALUES (21,2,'2023-02-16 06:00:00','2023-02-16 21:59:59',6,0,119,119,1,0,0,0); insert into temp_tariff (tarId,tarDay,tarHourFrom,tarHourTo,tarNumber,tarAmount,tarPeriod,tarPeriodLength,tarPeriodCount,tarDisabled,rulAmountPeriod,rulAmountPeriodDay) VALUES (21,3,'2023-02-16 06:00:00','2023-02-16 21:59:59',6,0,119,119,1,0,0,0); insert into temp_tariff (tarId,tarDay,tarHourFrom,tarHourTo,tarNumber,tarAmount,tarPeriod,tarPeriodLength,tarPeriodCount,tarDisabled,rulAmountPeriod,rulAmountPeriodDay) VALUES (21,4,'2023-02-16 06:00:00','2023-02-16 21:59:59',6,0,119,119,1,0,0,0); insert into temp_tariff (tarId,tarDay,tarHourFrom,tarHourTo,tarNumber,tarAmount,tarPeriod,tarPeriodLength,tarPeriodCount,tarDisabled,rulAmountPeriod,rulAmountPeriodDay) VALUES (21,5,'2023-02-16 06:00:00','2023-02-16 21:59:59',6,0,119,119,1,0,0,0); insert into temp_tariff (tarId,tarDay,tarHourFrom,tarHourTo,tarNumber,tarAmount,tarPeriod,tarPeriodLength,tarPeriodCount,tarDisabled,rulAmountPeriod,rulAmountPeriodDay) VALUES (21,6,'2023-02-16 06:00:00','2023-02-16 21:59:59',6,0,119,119,1,0,0,0); insert into temp_tariff (tarId,tarDay,tarHourFrom,tarHourTo,tarNumber,tarAmount,tarPeriod,tarPeriodLength,tarPeriodCount,tarDisabled,rulAmountPeriod,rulAmountPeriodDay) VALUES (21,7,'2023-02-16 06:00:00','2023-02-16 21:59:59',6,0,119,119,1,0,0,0); insert into temp_tariff (tarId,tarDay,tarHourFrom,tarHourTo,tarNumber,tarAmount,tarPeriod,tarPeriodLength,tarPeriodCount,tarDisabled,rulAmountPeriod,rulAmountPeriodDay) VALUES (22,1,'2023-02-16 06:00:00','2023-02-16 21:59:59',7,100,1,1,1,0,0,0); insert into temp_tariff (tarId,tarDay,tarHourFrom,tarHourTo,tarNumber,tarAmount,tarPeriod,tarPeriodLength,tarPeriodCount,tarDisabled,rulAmountPeriod,rulAmountPeriodDay) VALUES (22,2,'2023-02-16 06:00:00','2023-02-16 21:59:59',7,100,1,1,1,0,0,0); insert into temp_tariff (tarId,tarDay,tarHourFrom,tarHourTo,tarNumber,tarAmount,tarPeriod,tarPeriodLength,tarPeriodCount,tarDisabled,rulAmountPeriod,rulAmountPeriodDay) VALUES (22,3,'2023-02-16 06:00:00','2023-02-16 21:59:59',7,100,1,1,1,0,0,0); insert into temp_tariff (tarId,tarDay,tarHourFrom,tarHourTo,tarNumber,tarAmount,tarPeriod,tarPeriodLength,tarPeriodCount,tarDisabled,rulAmountPeriod,rulAmountPeriodDay) VALUES (22,4,'2023-02-16 06:00:00','2023-02-16 21:59:59',7,100,1,1,1,0,0,0); insert into temp_tariff (tarId,tarDay,tarHourFrom,tarHourTo,tarNumber,tarAmount,tarPeriod,tarPeriodLength,tarPeriodCount,tarDisabled,rulAmountPeriod,rulAmountPeriodDay) VALUES (22,5,'2023-02-16 06:00:00','2023-02-16 21:59:59',7,100,1,1,1,0,0,0); insert into temp_tariff (tarId,tarDay,tarHourFrom,tarHourTo,tarNumber,tarAmount,tarPeriod,tarPeriodLength,tarPeriodCount,tarDisabled,rulAmountPeriod,rulAmountPeriodDay) VALUES (22,6,'2023-02-16 06:00:00','2023-02-16 21:59:59',7,100,1,1,1,0,0,0); insert into temp_tariff (tarId,tarDay,tarHourFrom,tarHourTo,tarNumber,tarAmount,tarPeriod,tarPeriodLength,tarPeriodCount,tarDisabled,rulAmountPeriod,rulAmountPeriodDay) VALUES (22,7,'2023-02-16 06:00:00','2023-02-16 21:59:59',7,100,1,1,1,0,0,0); insert into temp_tariff (tarId,tarDay,tarHourFrom,tarHourTo,tarNumber,tarAmount,tarPeriod,tarPeriodLength,tarPeriodCount,tarDisabled,rulAmountPeriod,rulAmountPeriodDay) VALUES (23,1,'2023-02-16 06:00:00','2023-02-16 21:59:59',8,0,59,59,1,0,0,0); insert into temp_tariff (tarId,tarDay,tarHourFrom,tarHourTo,tarNumber,tarAmount,tarPeriod,tarPeriodLength,tarPeriodCount,tarDisabled,rulAmountPeriod,rulAmountPeriodDay) VALUES (23,2,'2023-02-16 06:00:00','2023-02-16 21:59:59',8,0,59,59,1,0,0,0); insert into temp_tariff (tarId,tarDay,tarHourFrom,tarHourTo,tarNumber,tarAmount,tarPeriod,tarPeriodLength,tarPeriodCount,tarDisabled,rulAmountPeriod,rulAmountPeriodDay) VALUES (23,3,'2023-02-16 06:00:00','2023-02-16 21:59:59',8,0,59,59,1,0,0,0); insert into temp_tariff (tarId,tarDay,tarHourFrom,tarHourTo,tarNumber,tarAmount,tarPeriod,tarPeriodLength,tarPeriodCount,tarDisabled,rulAmountPeriod,rulAmountPeriodDay) VALUES (23,4,'2023-02-16 06:00:00','2023-02-16 21:59:59',8,0,59,59,1,0,0,0); insert into temp_tariff (tarId,tarDay,tarHourFrom,tarHourTo,tarNumber,tarAmount,tarPeriod,tarPeriodLength,tarPeriodCount,tarDisabled,rulAmountPeriod,rulAmountPeriodDay) VALUES (23,5,'2023-02-16 06:00:00','2023-02-16 21:59:59',8,0,59,59,1,0,0,0); insert into temp_tariff (tarId,tarDay,tarHourFrom,tarHourTo,tarNumber,tarAmount,tarPeriod,tarPeriodLength,tarPeriodCount,tarDisabled,rulAmountPeriod,rulAmountPeriodDay) VALUES (23,6,'2023-02-16 06:00:00','2023-02-16 21:59:59',8,0,59,59,1,0,0,0); insert into temp_tariff (tarId,tarDay,tarHourFrom,tarHourTo,tarNumber,tarAmount,tarPeriod,tarPeriodLength,tarPeriodCount,tarDisabled,rulAmountPeriod,rulAmountPeriodDay) VALUES (23,7,'2023-02-16 06:00:00','2023-02-16 21:59:59',8,0,59,59,1,0,0,0); insert into temp_tariff (tarId,tarDay,tarHourFrom,tarHourTo,tarNumber,tarAmount,tarPeriod,tarPeriodLength,tarPeriodCount,tarDisabled,rulAmountPeriod,rulAmountPeriodDay) VALUES (24,1,'2023-02-16 06:00:00','2023-02-16 21:59:59',9,100,60,0,0,0,0,0); insert into temp_tariff (tarId,tarDay,tarHourFrom,tarHourTo,tarNumber,tarAmount,tarPeriod,tarPeriodLength,tarPeriodCount,tarDisabled,rulAmountPeriod,rulAmountPeriodDay) VALUES (24,2,'2023-02-16 06:00:00','2023-02-16 21:59:59',9,100,60,0,0,0,0,0); insert into temp_tariff (tarId,tarDay,tarHourFrom,tarHourTo,tarNumber,tarAmount,tarPeriod,tarPeriodLength,tarPeriodCount,tarDisabled,rulAmountPeriod,rulAmountPeriodDay) VALUES (24,3,'2023-02-16 06:00:00','2023-02-16 21:59:59',9,100,60,0,0,0,0,0); insert into temp_tariff (tarId,tarDay,tarHourFrom,tarHourTo,tarNumber,tarAmount,tarPeriod,tarPeriodLength,tarPeriodCount,tarDisabled,rulAmountPeriod,rulAmountPeriodDay) VALUES (24,4,'2023-02-16 06:00:00','2023-02-16 21:59:59',9,100,60,0,0,0,0,0); insert into temp_tariff (tarId,tarDay,tarHourFrom,tarHourTo,tarNumber,tarAmount,tarPeriod,tarPeriodLength,tarPeriodCount,tarDisabled,rulAmountPeriod,rulAmountPeriodDay) VALUES (24,5,'2023-02-16 06:00:00','2023-02-16 21:59:59',9,100,60,0,0,0,0,0); insert into temp_tariff (tarId,tarDay,tarHourFrom,tarHourTo,tarNumber,tarAmount,tarPeriod,tarPeriodLength,tarPeriodCount,tarDisabled,rulAmountPeriod,rulAmountPeriodDay) VALUES (24,6,'2023-02-16 06:00:00','2023-02-16 21:59:59',9,100,60,0,0,0,0,0); insert into temp_tariff (tarId,tarDay,tarHourFrom,tarHourTo,tarNumber,tarAmount,tarPeriod,tarPeriodLength,tarPeriodCount,tarDisabled,rulAmountPeriod,rulAmountPeriodDay) VALUES (24,7,'2023-02-16 06:00:00','2023-02-16 21:59:59',9,100,60,0,0,0,0,0); insert into temp_tariff (tarId,tarDay,tarHourFrom,tarHourTo,tarNumber,tarAmount,tarPeriod,tarPeriodLength,tarPeriodCount,tarDisabled,rulAmountPeriod,rulAmountPeriodDay) VALUES (25,1,'2023-02-16 22:00:00','2023-02-16 23:57:59',10,100,57,57,1,0,0,0); insert into temp_tariff (tarId,tarDay,tarHourFrom,tarHourTo,tarNumber,tarAmount,tarPeriod,tarPeriodLength,tarPeriodCount,tarDisabled,rulAmountPeriod,rulAmountPeriodDay) VALUES (25,2,'2023-02-16 22:00:00','2023-02-16 23:57:59',10,100,57,57,1,0,0,0); insert into temp_tariff (tarId,tarDay,tarHourFrom,tarHourTo,tarNumber,tarAmount,tarPeriod,tarPeriodLength,tarPeriodCount,tarDisabled,rulAmountPeriod,rulAmountPeriodDay) VALUES (25,3,'2023-02-16 22:00:00','2023-02-16 23:57:59',10,100,57,57,1,0,0,0); insert into temp_tariff (tarId,tarDay,tarHourFrom,tarHourTo,tarNumber,tarAmount,tarPeriod,tarPeriodLength,tarPeriodCount,tarDisabled,rulAmountPeriod,rulAmountPeriodDay) VALUES (25,4,'2023-02-16 22:00:00','2023-02-16 23:57:59',10,100,57,57,1,0,0,0); insert into temp_tariff (tarId,tarDay,tarHourFrom,tarHourTo,tarNumber,tarAmount,tarPeriod,tarPeriodLength,tarPeriodCount,tarDisabled,rulAmountPeriod,rulAmountPeriodDay) VALUES (25,5,'2023-02-16 22:00:00','2023-02-16 23:57:59',10,100,57,57,1,0,0,0); insert into temp_tariff (tarId,tarDay,tarHourFrom,tarHourTo,tarNumber,tarAmount,tarPeriod,tarPeriodLength,tarPeriodCount,tarDisabled,rulAmountPeriod,rulAmountPeriodDay) VALUES (25,6,'2023-02-16 22:00:00','2023-02-16 23:57:59',10,100,57,57,1,0,0,0); insert into temp_tariff (tarId,tarDay,tarHourFrom,tarHourTo,tarNumber,tarAmount,tarPeriod,tarPeriodLength,tarPeriodCount,tarDisabled,rulAmountPeriod,rulAmountPeriodDay) VALUES (25,7,'2023-02-16 22:00:00','2023-02-16 23:57:59',10,100,57,57,1,0,0,0); insert into temp_tariff (tarId,tarDay,tarHourFrom,tarHourTo,tarNumber,tarAmount,tarPeriod,tarPeriodLength,tarPeriodCount,tarDisabled,rulAmountPeriod,rulAmountPeriodDay) VALUES (26,1,'2023-02-16 22:00:00','2023-02-16 23:57:59',11,0,1,0,0,0,0,0); insert into temp_tariff (tarId,tarDay,tarHourFrom,tarHourTo,tarNumber,tarAmount,tarPeriod,tarPeriodLength,tarPeriodCount,tarDisabled,rulAmountPeriod,rulAmountPeriodDay) VALUES (26,2,'2023-02-16 22:00:00','2023-02-16 23:57:59',11,0,1,0,0,0,0,0); insert into temp_tariff (tarId,tarDay,tarHourFrom,tarHourTo,tarNumber,tarAmount,tarPeriod,tarPeriodLength,tarPeriodCount,tarDisabled,rulAmountPeriod,rulAmountPeriodDay) VALUES (26,3,'2023-02-16 22:00:00','2023-02-16 23:57:59',11,0,1,0,0,0,0,0); insert into temp_tariff (tarId,tarDay,tarHourFrom,tarHourTo,tarNumber,tarAmount,tarPeriod,tarPeriodLength,tarPeriodCount,tarDisabled,rulAmountPeriod,rulAmountPeriodDay) VALUES (26,4,'2023-02-16 22:00:00','2023-02-16 23:57:59',11,0,1,0,0,0,0,0); insert into temp_tariff (tarId,tarDay,tarHourFrom,tarHourTo,tarNumber,tarAmount,tarPeriod,tarPeriodLength,tarPeriodCount,tarDisabled,rulAmountPeriod,rulAmountPeriodDay) VALUES (26,5,'2023-02-16 22:00:00','2023-02-16 23:57:59',11,0,1,0,0,0,0,0); insert into temp_tariff (tarId,tarDay,tarHourFrom,tarHourTo,tarNumber,tarAmount,tarPeriod,tarPeriodLength,tarPeriodCount,tarDisabled,rulAmountPeriod,rulAmountPeriodDay) VALUES (26,6,'2023-02-16 22:00:00','2023-02-16 23:57:59',11,0,1,0,0,0,0,0); insert into temp_tariff (tarId,tarDay,tarHourFrom,tarHourTo,tarNumber,tarAmount,tarPeriod,tarPeriodLength,tarPeriodCount,tarDisabled,rulAmountPeriod,rulAmountPeriodDay) VALUES (26,7,'2023-02-16 22:00:00','2023-02-16 23:57:59',11,0,1,0,0,0,0,0); insert into temp_tariff (tarId,tarDay,tarHourFrom,tarHourTo,tarNumber,tarAmount,tarPeriod,tarPeriodLength,tarPeriodCount,tarDisabled,rulAmountPeriod,rulAmountPeriodDay) VALUES (27,1,'2023-02-16 23:58:00','2023-02-16 23:59:59',12,-100,1,1,1,0,0,0); insert into temp_tariff (tarId,tarDay,tarHourFrom,tarHourTo,tarNumber,tarAmount,tarPeriod,tarPeriodLength,tarPeriodCount,tarDisabled,rulAmountPeriod,rulAmountPeriodDay) VALUES (27,2,'2023-02-16 23:58:00','2023-02-16 23:59:59',12,-100,1,1,1,0,0,0); insert into temp_tariff (tarId,tarDay,tarHourFrom,tarHourTo,tarNumber,tarAmount,tarPeriod,tarPeriodLength,tarPeriodCount,tarDisabled,rulAmountPeriod,rulAmountPeriodDay) VALUES (27,3,'2023-02-16 23:58:00','2023-02-16 23:59:59',12,-100,1,1,1,0,0,0); insert into temp_tariff (tarId,tarDay,tarHourFrom,tarHourTo,tarNumber,tarAmount,tarPeriod,tarPeriodLength,tarPeriodCount,tarDisabled,rulAmountPeriod,rulAmountPeriodDay) VALUES (27,4,'2023-02-16 23:58:00','2023-02-16 23:59:59',12,-100,1,1,1,0,0,0); insert into temp_tariff (tarId,tarDay,tarHourFrom,tarHourTo,tarNumber,tarAmount,tarPeriod,tarPeriodLength,tarPeriodCount,tarDisabled,rulAmountPeriod,rulAmountPeriodDay) VALUES (27,5,'2023-02-16 23:58:00','2023-02-16 23:59:59',12,-100,1,1,1,0,0,0); insert into temp_tariff (tarId,tarDay,tarHourFrom,tarHourTo,tarNumber,tarAmount,tarPeriod,tarPeriodLength,tarPeriodCount,tarDisabled,rulAmountPeriod,rulAmountPeriodDay) VALUES (27,6,'2023-02-16 23:58:00','2023-02-16 23:59:59',12,-100,1,1,1,0,0,0); insert into temp_tariff (tarId,tarDay,tarHourFrom,tarHourTo,tarNumber,tarAmount,tarPeriod,tarPeriodLength,tarPeriodCount,tarDisabled,rulAmountPeriod,rulAmountPeriodDay) VALUES (27,7,'2023-02-16 23:58:00','2023-02-16 23:59:59',12,-100,1,1,1,0,0,0); insert into temp_tariff (tarId,tarDay,tarHourFrom,tarHourTo,tarNumber,tarAmount,tarPeriod,tarPeriodLength,tarPeriodCount,tarDisabled,rulAmountPeriod,rulAmountPeriodDay) VALUES (28,1,'2023-02-16 23:58:00','2023-02-16 23:59:59',13,0,1,0,0,0,0,0); insert into temp_tariff (tarId,tarDay,tarHourFrom,tarHourTo,tarNumber,tarAmount,tarPeriod,tarPeriodLength,tarPeriodCount,tarDisabled,rulAmountPeriod,rulAmountPeriodDay) VALUES (28,2,'2023-02-16 23:58:00','2023-02-16 23:59:59',13,0,1,0,0,0,0,0); insert into temp_tariff (tarId,tarDay,tarHourFrom,tarHourTo,tarNumber,tarAmount,tarPeriod,tarPeriodLength,tarPeriodCount,tarDisabled,rulAmountPeriod,rulAmountPeriodDay) VALUES (28,3,'2023-02-16 23:58:00','2023-02-16 23:59:59',13,0,1,0,0,0,0,0); insert into temp_tariff (tarId,tarDay,tarHourFrom,tarHourTo,tarNumber,tarAmount,tarPeriod,tarPeriodLength,tarPeriodCount,tarDisabled,rulAmountPeriod,rulAmountPeriodDay) VALUES (28,4,'2023-02-16 23:58:00','2023-02-16 23:59:59',13,0,1,0,0,0,0,0); insert into temp_tariff (tarId,tarDay,tarHourFrom,tarHourTo,tarNumber,tarAmount,tarPeriod,tarPeriodLength,tarPeriodCount,tarDisabled,rulAmountPeriod,rulAmountPeriodDay) VALUES (28,5,'2023-02-16 23:58:00','2023-02-16 23:59:59',13,0,1,0,0,0,0,0); insert into temp_tariff (tarId,tarDay,tarHourFrom,tarHourTo,tarNumber,tarAmount,tarPeriod,tarPeriodLength,tarPeriodCount,tarDisabled,rulAmountPeriod,rulAmountPeriodDay) VALUES (28,6,'2023-02-16 23:58:00','2023-02-16 23:59:59',13,0,1,0,0,0,0,0); insert into temp_tariff (tarId,tarDay,tarHourFrom,tarHourTo,tarNumber,tarAmount,tarPeriod,tarPeriodLength,tarPeriodCount,tarDisabled,rulAmountPeriod,rulAmountPeriodDay) VALUES (28,7,'2023-02-16 23:58:00','2023-02-16 23:59:59',13,0,1,0,0,0,0,0); (WAIT TIME 55 ms.) 15/09/2023 09:38:00.9540 23887 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 3 (WAIT TIME 100 ms.) 15/09/2023 09:40:04.2882 3739 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 4 15/09/2023 09:40:04.3262 3942 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-09-15 09:40:00','V',5043661125950650,2023,'2023-09-15 09:38:41','451823472100327005031999',1,2,16,'I','',1,0,1,'','',4) 15/09/2023 09:40:13.8666 4248 ms. OPEN: select * from tabArea where areId = 1 (WAIT TIME 63 ms.) 15/09/2023 09:41:20.2884 19563 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,payVatPercent,payVatAmount) VALUES ('2023-09-15 09:37:36',1,'V',5022781826832880,4712706497672150,2023,'2023-09-15 09:37:36',4,1,0,4,'2023-09-15 09:52:36','C','KES',0,0,0,'','','',1,0,0) 15/09/2023 09:41:34.6281 4347 ms. EXEC: insert into payReceipt (recTraUID,recPayUID,recYear,recDateTime,recText,recInvalid) VALUES (4712706497672150,5022781826832880,2023,'2023-09-15 09:41:30',' Date: 9/15/2023 9:37:36 AM Code: 451823091800327005012999 Entry Date: 9/15/2023 8:35:18 AM Plate: Class: Cars Park: The Mall Gate: Entry 2 ______________________________ Total: 0.00 KES ______________________________ Paid: 0.00 KES __________ Change: 0.00 KES Type: Cash Dispozitiv: Manual Cashier 1 ',1) 15/09/2023 09:41:34.6381 33875 ms. OPEN: select * from tabDevice where devId = 2 and devStatus = 'V' 15/09/2023 09:43:14.5205 10150 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 (WAIT TIME 222 ms.) 15/09/2023 09:43:19.2787 3989 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 (WAIT TIME 212 ms.) 15/09/2023 09:43:23.9429 4537 ms. EXEC: INSERT INTO movOperator (opeCreation,opeUseId,opeTerId,opeDateTime,opeCode,opeDescription) VALUES ('2023-09-15 09:43:19',0,2,'2023-09-15 09:43:19','','Manual Open Barrier Exit 1') (WAIT TIME 100 ms.) 15/09/2023 09:43:23.9509 4543 ms. EXECSCALAR: select count(*) from tabTerminalExtraMem where extStatus='V' and extTerId = 2 nr: 1 (WAIT TIME 84 ms.) 15/09/2023 09:43:45.1642 4216 ms. EXECSCALAR: select count(0) as vTot from tabParameters where parPlateReading<>0 nr: 0 15/09/2023 09:43:45.4444 4530 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,payVatPercent,payVatAmount) VALUES ('2023-09-15 09:43:40',0,'V',5608605121235100,5125028353791240,2023,'2023-09-15 09:43:40',2,1,0,-1,'2023-09-15 10:43:40','S','KES',0,0,0,'','','',3,0,0) 15/09/2023 09:43:45.5835 4645 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 15/09/2023 09:44:06.6077 1555 ms. OPEN: select * from tabArea where areStatus='V' and areEnabled = 1 AND areId = 1 (WAIT TIME 4804 ms.) 15/09/2023 09:44:06.7137 6301 ms. OPEN: select * from tabDevice where devId = 2 and devStatus = 'V' (WAIT TIME 163 ms.) 15/09/2023 09:46:05.2917 4576 ms. OPEN: SELECT * FROM abbsubscriptions INNER JOIN abbcards ON carSubId=subId INNER JOIN tabcustomer ON subCusId=cusId WHERE carStatus='V' AND subStatus='V' AND (carCode<>'' OR carUHFCode<>'') AND subAbbType NOT IN (6,-1) ORDER BY carCode 15/09/2023 09:46:48.1046 4424 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 15/09/2023 09:46:52.8208 4716 ms. EXEC: update abbCards set carLastDate = '2023-09-15 09:46:48',carLastDirection='I' where carStatus='V' and carId = 25 15/09/2023 09:47:02.2892 4608 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 1 OR lnsTerId=1) 15/09/2023 09:47:21.2940 1835 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 15/09/2023 09:47:26.0422 1291 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 15/09/2023 09:47:45.1291 3605 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 (WAIT TIME 81 ms.) 15/09/2023 09:48:18.9329 4686 ms. EXECSCALAR: select count(*) from tabTerminalExtraMem where extStatus='V' and extTerId = 16 nr: 1 15/09/2023 09:48:23.6801 4655 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 3 OR lnsTerId=3) 15/09/2023 09:48:28.5614 4784 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 5 (WAIT TIME 4757 ms.) 15/09/2023 09:48:28.5614 4620 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 4 (WAIT TIME 131 ms.) 15/09/2023 09:48:33.3977 4616 ms. OPEN: select * from tabUserMessage where useMesDescr = 'msg_cash' and (useLanCode = 'en-US' or mid(useLanCode,1,2) = 'en') (WAIT TIME 217 ms.) 15/09/2023 09:48:37.9517 4658 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 (WAIT TIME 4732 ms.) 15/09/2023 09:48:47.4832 4271 ms. EXECSCALAR: select count(*) from tabTerminalExtraMem where extStatus='V' and extTerId = @extTerId nr: 1 15/09/2023 09:48:47.5992 4328 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-09-15 09:48:43','V',5046453892711160,2023,'2023-09-15 09:48:02','451823528200327005031999',1,2,16,'I','',1,0,1,'','',4) (WAIT TIME 110 ms.) 15/09/2023 09:48:47.6603 4460 ms. EXEC: update payReceipt set recCreation = '2023-09-15 09:48:43',recModify = '2023-09-15 09:48:43',recUseId=0,recStatus='V' where recId = 166484 (WAIT TIME 153 ms.) 15/09/2023 09:48:52.2224 3975 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-09-15 09:48:48','V',4976208230604950,2023,'2023-09-15 09:48:17','451823529700327005031999',1,2,16,'I','',1,0,1,'','',4) 15/09/2023 09:48:52.2264 3984 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-09-15 09:48:48','V',5085062096401990,2023,'2023-09-15 09:48:17','451823529700327005031999',1,2,16,'I','',1,0,1,'','',4) 15/09/2023 09:49:16.1075 4752 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 7 (WAIT TIME 93 ms.) 15/09/2023 09:49:20.8957 4576 ms. OPEN: select * from movTransit inner join paypayment on paypayment.payTraUID = movTransit.traUID where traCode = '451823350800327005012999' and traStatus='V' and payStatus='V' order by payDateTime desc (WAIT TIME 121 ms.) 15/09/2023 09:49:50.4216 24003 ms. OPEN: select * from movtransit t where traCode = '451823411700327005031999' and t.traStatus='V' and t.traDirection='I' order by t.traId desc limit 1 (WAIT TIME 53 ms.) 15/09/2023 09:50:04.6803 4256 ms. OPEN: SELECT SUM(vTot) as vTot,payTimeLimit FROM (SELECT SUM(payPayed)-SUM(payChange) AS vTot,MAX(payTimeLimit) AS payTimeLimit FROM payPayment INNER JOIN movtransit ON movtransit.traUID=payPayment.payTraUID WHERE traCode = '451823191300327005012999' AND traStatus='V' AND payStatus='V' AND payIdEvent<90 GROUP BY payId ORDER BY payEnabled DESC, payTimeLimit DESC) as v1 15/09/2023 09:51:19.7279 4068 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 5 15/09/2023 09:51:51.8295 21516 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 (WAIT TIME 25 ms.) 15/09/2023 09:52:25.2281 4480 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 2 (WAIT TIME 128 ms.) 15/09/2023 09:52:30.0403 4468 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 16 OR lnsTerId=16) (WAIT TIME 247 ms.) 15/09/2023 09:52:34.6594 4470 ms. OPEN: select terDefaultClass from tabTerminal where terStatus='V' and terId = 16 (WAIT TIME 75 ms.) 15/09/2023 09:52:44.1278 4213 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 3 (WAIT TIME 83 ms.) 15/09/2023 09:52:53.5422 4257 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 4 OR lnsTerId=4) 15/09/2023 09:52:53.6182 4293 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 5 (WAIT TIME 45 ms.) 15/09/2023 09:52:58.2924 4421 ms. OPEN: select * from movtransit where trastatus='V' and (traCode = '451823131200327005012999') and traDirection='I' order by traId desc limit 1 15/09/2023 09:52:58.2934 4484 ms. EXEC: update payReceipt set recCreation = '2023-09-15 09:52:53',recModify = '2023-09-15 09:52:53',recUseId=0,recStatus='V' where recId = 166485 15/09/2023 09:53:03.0476 4709 ms. EXEC: insert into temp_tariff (tarId,tarDay,tarHourFrom,tarHourTo,tarNumber,tarAmount,tarPeriod,tarPeriodLength,tarPeriodCount,tarDisabled,rulAmountPeriod,rulAmountPeriodDay) VALUES (16,1,'2023-02-16 00:00:00','2023-02-16 05:59:59',1,100,1,1,1,0,0,0); insert into temp_tariff (tarId,tarDay,tarHourFrom,tarHourTo,tarNumber,tarAmount,tarPeriod,tarPeriodLength,tarPeriodCount,tarDisabled,rulAmountPeriod,rulAmountPeriodDay) VALUES (16,2,'2023-02-16 00:00:00','2023-02-16 05:59:59',1,100,1,1,1,0,0,0); insert into temp_tariff (tarId,tarDay,tarHourFrom,tarHourTo,tarNumber,tarAmount,tarPeriod,tarPeriodLength,tarPeriodCount,tarDisabled,rulAmountPeriod,rulAmountPeriodDay) VALUES (16,3,'2023-02-16 00:00:00','2023-02-16 05:59:59',1,100,1,1,1,0,0,0); insert into temp_tariff (tarId,tarDay,tarHourFrom,tarHourTo,tarNumber,tarAmount,tarPeriod,tarPeriodLength,tarPeriodCount,tarDisabled,rulAmountPeriod,rulAmountPeriodDay) VALUES (16,4,'2023-02-16 00:00:00','2023-02-16 05:59:59',1,100,1,1,1,0,0,0); insert into temp_tariff (tarId,tarDay,tarHourFrom,tarHourTo,tarNumber,tarAmount,tarPeriod,tarPeriodLength,tarPeriodCount,tarDisabled,rulAmountPeriod,rulAmountPeriodDay) VALUES (16,5,'2023-02-16 00:00:00','2023-02-16 05:59:59',1,100,1,1,1,0,0,0); insert into temp_tariff (tarId,tarDay,tarHourFrom,tarHourTo,tarNumber,tarAmount,tarPeriod,tarPeriodLength,tarPeriodCount,tarDisabled,rulAmountPeriod,rulAmountPeriodDay) VALUES (16,6,'2023-02-16 00:00:00','2023-02-16 05:59:59',1,100,1,1,1,0,0,0); insert into temp_tariff (tarId,tarDay,tarHourFrom,tarHourTo,tarNumber,tarAmount,tarPeriod,tarPeriodLength,tarPeriodCount,tarDisabled,rulAmountPeriod,rulAmountPeriodDay) VALUES (16,7,'2023-02-16 00:00:00','2023-02-16 05:59:59',1,100,1,1,1,0,0,0); insert into temp_tariff (tarId,tarDay,tarHourFrom,tarHourTo,tarNumber,tarAmount,tarPeriod,tarPeriodLength,tarPeriodCount,tarDisabled,rulAmountPeriod,rulAmountPeriodDay) VALUES (17,1,'2023-02-16 00:00:00','2023-02-16 05:59:59',2,0,1,0,0,0,0,0); insert into temp_tariff (tarId,tarDay,tarHourFrom,tarHourTo,tarNumber,tarAmount,tarPeriod,tarPeriodLength,tarPeriodCount,tarDisabled,rulAmountPeriod,rulAmountPeriodDay) VALUES (17,2,'2023-02-16 00:00:00','2023-02-16 05:59:59',2,0,1,0,0,0,0,0); insert into temp_tariff (tarId,tarDay,tarHourFrom,tarHourTo,tarNumber,tarAmount,tarPeriod,tarPeriodLength,tarPeriodCount,tarDisabled,rulAmountPeriod,rulAmountPeriodDay) VALUES (17,3,'2023-02-16 00:00:00','2023-02-16 05:59:59',2,0,1,0,0,0,0,0); insert into temp_tariff (tarId,tarDay,tarHourFrom,tarHourTo,tarNumber,tarAmount,tarPeriod,tarPeriodLength,tarPeriodCount,tarDisabled,rulAmountPeriod,rulAmountPeriodDay) VALUES (17,4,'2023-02-16 00:00:00','2023-02-16 05:59:59',2,0,1,0,0,0,0,0); insert into temp_tariff (tarId,tarDay,tarHourFrom,tarHourTo,tarNumber,tarAmount,tarPeriod,tarPeriodLength,tarPeriodCount,tarDisabled,rulAmountPeriod,rulAmountPeriodDay) VALUES (17,5,'2023-02-16 00:00:00','2023-02-16 05:59:59',2,0,1,0,0,0,0,0); insert into temp_tariff (tarId,tarDay,tarHourFrom,tarHourTo,tarNumber,tarAmount,tarPeriod,tarPeriodLength,tarPeriodCount,tarDisabled,rulAmountPeriod,rulAmountPeriodDay) VALUES (17,6,'2023-02-16 00:00:00','2023-02-16 05:59:59',2,0,1,0,0,0,0,0); insert into temp_tariff (tarId,tarDay,tarHourFrom,tarHourTo,tarNumber,tarAmount,tarPeriod,tarPeriodLength,tarPeriodCount,tarDisabled,rulAmountPeriod,rulAmountPeriodDay) VALUES (17,7,'2023-02-16 00:00:00','2023-02-16 05:59:59',2,0,1,0,0,0,0,0); insert into temp_tariff (tarId,tarDay,tarHourFrom,tarHourTo,tarNumber,tarAmount,tarPeriod,tarPeriodLength,tarPeriodCount,tarDisabled,rulAmountPeriod,rulAmountPeriodDay) VALUES (18,1,'2023-02-16 06:00:00','2023-02-16 21:59:59',3,50,1,1,1,0,0,0); insert into temp_tariff (tarId,tarDay,tarHourFrom,tarHourTo,tarNumber,tarAmount,tarPeriod,tarPeriodLength,tarPeriodCount,tarDisabled,rulAmountPeriod,rulAmountPeriodDay) VALUES (18,2,'2023-02-16 06:00:00','2023-02-16 21:59:59',3,50,1,1,1,0,0,0); insert into temp_tariff (tarId,tarDay,tarHourFrom,tarHourTo,tarNumber,tarAmount,tarPeriod,tarPeriodLength,tarPeriodCount,tarDisabled,rulAmountPeriod,rulAmountPeriodDay) VALUES (18,3,'2023-02-16 06:00:00','2023-02-16 21:59:59',3,50,1,1,1,0,0,0); insert into temp_tariff (tarId,tarDay,tarHourFrom,tarHourTo,tarNumber,tarAmount,tarPeriod,tarPeriodLength,tarPeriodCount,tarDisabled,rulAmountPeriod,rulAmountPeriodDay) VALUES (18,4,'2023-02-16 06:00:00','2023-02-16 21:59:59',3,50,1,1,1,0,0,0); insert into temp_tariff (tarId,tarDay,tarHourFrom,tarHourTo,tarNumber,tarAmount,tarPeriod,tarPeriodLength,tarPeriodCount,tarDisabled,rulAmountPeriod,rulAmountPeriodDay) VALUES (18,5,'2023-02-16 06:00:00','2023-02-16 21:59:59',3,50,1,1,1,0,0,0); insert into temp_tariff (tarId,tarDay,tarHourFrom,tarHourTo,tarNumber,tarAmount,tarPeriod,tarPeriodLength,tarPeriodCount,tarDisabled,rulAmountPeriod,rulAmountPeriodDay) VALUES (18,6,'2023-02-16 06:00:00','2023-02-16 21:59:59',3,50,1,1,1,0,0,0); insert into temp_tariff (tarId,tarDay,tarHourFrom,tarHourTo,tarNumber,tarAmount,tarPeriod,tarPeriodLength,tarPeriodCount,tarDisabled,rulAmountPeriod,rulAmountPeriodDay) VALUES (18,7,'2023-02-16 06:00:00','2023-02-16 21:59:59',3,50,1,1,1,0,0,0); insert into temp_tariff (tarId,tarDay,tarHourFrom,tarHourTo,tarNumber,tarAmount,tarPeriod,tarPeriodLength,tarPeriodCount,tarDisabled,rulAmountPeriod,rulAmountPeriodDay) VALUES (19,1,'2023-02-16 06:00:00','2023-02-16 21:59:59',4,0,59,59,1,0,0,0); insert into temp_tariff (tarId,tarDay,tarHourFrom,tarHourTo,tarNumber,tarAmount,tarPeriod,tarPeriodLength,tarPeriodCount,tarDisabled,rulAmountPeriod,rulAmountPeriodDay) VALUES (19,2,'2023-02-16 06:00:00','2023-02-16 21:59:59',4,0,59,59,1,0,0,0); insert into temp_tariff (tarId,tarDay,tarHourFrom,tarHourTo,tarNumber,tarAmount,tarPeriod,tarPeriodLength,tarPeriodCount,tarDisabled,rulAmountPeriod,rulAmountPeriodDay) VALUES (19,3,'2023-02-16 06:00:00','2023-02-16 21:59:59',4,0,59,59,1,0,0,0); insert into temp_tariff (tarId,tarDay,tarHourFrom,tarHourTo,tarNumber,tarAmount,tarPeriod,tarPeriodLength,tarPeriodCount,tarDisabled,rulAmountPeriod,rulAmountPeriodDay) VALUES (19,4,'2023-02-16 06:00:00','2023-02-16 21:59:59',4,0,59,59,1,0,0,0); insert into temp_tariff (tarId,tarDay,tarHourFrom,tarHourTo,tarNumber,tarAmount,tarPeriod,tarPeriodLength,tarPeriodCount,tarDisabled,rulAmountPeriod,rulAmountPeriodDay) VALUES (19,5,'2023-02-16 06:00:00','2023-02-16 21:59:59',4,0,59,59,1,0,0,0); insert into temp_tariff (tarId,tarDay,tarHourFrom,tarHourTo,tarNumber,tarAmount,tarPeriod,tarPeriodLength,tarPeriodCount,tarDisabled,rulAmountPeriod,rulAmountPeriodDay) VALUES (19,6,'2023-02-16 06:00:00','2023-02-16 21:59:59',4,0,59,59,1,0,0,0); insert into temp_tariff (tarId,tarDay,tarHourFrom,tarHourTo,tarNumber,tarAmount,tarPeriod,tarPeriodLength,tarPeriodCount,tarDisabled,rulAmountPeriod,rulAmountPeriodDay) VALUES (19,7,'2023-02-16 06:00:00','2023-02-16 21:59:59',4,0,59,59,1,0,0,0); insert into temp_tariff (tarId,tarDay,tarHourFrom,tarHourTo,tarNumber,tarAmount,tarPeriod,tarPeriodLength,tarPeriodCount,tarDisabled,rulAmountPeriod,rulAmountPeriodDay) VALUES (20,1,'2023-02-16 06:00:00','2023-02-16 21:59:59',5,50,1,1,1,0,0,0); insert into temp_tariff (tarId,tarDay,tarHourFrom,tarHourTo,tarNumber,tarAmount,tarPeriod,tarPeriodLength,tarPeriodCount,tarDisabled,rulAmountPeriod,rulAmountPeriodDay) VALUES (20,2,'2023-02-16 06:00:00','2023-02-16 21:59:59',5,50,1,1,1,0,0,0); insert into temp_tariff (tarId,tarDay,tarHourFrom,tarHourTo,tarNumber,tarAmount,tarPeriod,tarPeriodLength,tarPeriodCount,tarDisabled,rulAmountPeriod,rulAmountPeriodDay) VALUES (20,3,'2023-02-16 06:00:00','2023-02-16 21:59:59',5,50,1,1,1,0,0,0); insert into temp_tariff (tarId,tarDay,tarHourFrom,tarHourTo,tarNumber,tarAmount,tarPeriod,tarPeriodLength,tarPeriodCount,tarDisabled,rulAmountPeriod,rulAmountPeriodDay) VALUES (20,4,'2023-02-16 06:00:00','2023-02-16 21:59:59',5,50,1,1,1,0,0,0); insert into temp_tariff (tarId,tarDay,tarHourFrom,tarHourTo,tarNumber,tarAmount,tarPeriod,tarPeriodLength,tarPeriodCount,tarDisabled,rulAmountPeriod,rulAmountPeriodDay) VALUES (20,5,'2023-02-16 06:00:00','2023-02-16 21:59:59',5,50,1,1,1,0,0,0); insert into temp_tariff (tarId,tarDay,tarHourFrom,tarHourTo,tarNumber,tarAmount,tarPeriod,tarPeriodLength,tarPeriodCount,tarDisabled,rulAmountPeriod,rulAmountPeriodDay) VALUES (20,6,'2023-02-16 06:00:00','2023-02-16 21:59:59',5,50,1,1,1,0,0,0); insert into temp_tariff (tarId,tarDay,tarHourFrom,tarHourTo,tarNumber,tarAmount,tarPeriod,tarPeriodLength,tarPeriodCount,tarDisabled,rulAmountPeriod,rulAmountPeriodDay) VALUES (20,7,'2023-02-16 06:00:00','2023-02-16 21:59:59',5,50,1,1,1,0,0,0); insert into temp_tariff (tarId,tarDay,tarHourFrom,tarHourTo,tarNumber,tarAmount,tarPeriod,tarPeriodLength,tarPeriodCount,tarDisabled,rulAmountPeriod,rulAmountPeriodDay) VALUES (21,1,'2023-02-16 06:00:00','2023-02-16 21:59:59',6,0,119,119,1,0,0,0); insert into temp_tariff (tarId,tarDay,tarHourFrom,tarHourTo,tarNumber,tarAmount,tarPeriod,tarPeriodLength,tarPeriodCount,tarDisabled,rulAmountPeriod,rulAmountPeriodDay) VALUES (21,2,'2023-02-16 06:00:00','2023-02-16 21:59:59',6,0,119,119,1,0,0,0); insert into temp_tariff (tarId,tarDay,tarHourFrom,tarHourTo,tarNumber,tarAmount,tarPeriod,tarPeriodLength,tarPeriodCount,tarDisabled,rulAmountPeriod,rulAmountPeriodDay) VALUES (21,3,'2023-02-16 06:00:00','2023-02-16 21:59:59',6,0,119,119,1,0,0,0); insert into temp_tariff (tarId,tarDay,tarHourFrom,tarHourTo,tarNumber,tarAmount,tarPeriod,tarPeriodLength,tarPeriodCount,tarDisabled,rulAmountPeriod,rulAmountPeriodDay) VALUES (21,4,'2023-02-16 06:00:00','2023-02-16 21:59:59',6,0,119,119,1,0,0,0); insert into temp_tariff (tarId,tarDay,tarHourFrom,tarHourTo,tarNumber,tarAmount,tarPeriod,tarPeriodLength,tarPeriodCount,tarDisabled,rulAmountPeriod,rulAmountPeriodDay) VALUES (21,5,'2023-02-16 06:00:00','2023-02-16 21:59:59',6,0,119,119,1,0,0,0); insert into temp_tariff (tarId,tarDay,tarHourFrom,tarHourTo,tarNumber,tarAmount,tarPeriod,tarPeriodLength,tarPeriodCount,tarDisabled,rulAmountPeriod,rulAmountPeriodDay) VALUES (21,6,'2023-02-16 06:00:00','2023-02-16 21:59:59',6,0,119,119,1,0,0,0); insert into temp_tariff (tarId,tarDay,tarHourFrom,tarHourTo,tarNumber,tarAmount,tarPeriod,tarPeriodLength,tarPeriodCount,tarDisabled,rulAmountPeriod,rulAmountPeriodDay) VALUES (21,7,'2023-02-16 06:00:00','2023-02-16 21:59:59',6,0,119,119,1,0,0,0); insert into temp_tariff (tarId,tarDay,tarHourFrom,tarHourTo,tarNumber,tarAmount,tarPeriod,tarPeriodLength,tarPeriodCount,tarDisabled,rulAmountPeriod,rulAmountPeriodDay) VALUES (22,1,'2023-02-16 06:00:00','2023-02-16 21:59:59',7,100,1,1,1,0,0,0); insert into temp_tariff (tarId,tarDay,tarHourFrom,tarHourTo,tarNumber,tarAmount,tarPeriod,tarPeriodLength,tarPeriodCount,tarDisabled,rulAmountPeriod,rulAmountPeriodDay) VALUES (22,2,'2023-02-16 06:00:00','2023-02-16 21:59:59',7,100,1,1,1,0,0,0); insert into temp_tariff (tarId,tarDay,tarHourFrom,tarHourTo,tarNumber,tarAmount,tarPeriod,tarPeriodLength,tarPeriodCount,tarDisabled,rulAmountPeriod,rulAmountPeriodDay) VALUES (22,3,'2023-02-16 06:00:00','2023-02-16 21:59:59',7,100,1,1,1,0,0,0); insert into temp_tariff (tarId,tarDay,tarHourFrom,tarHourTo,tarNumber,tarAmount,tarPeriod,tarPeriodLength,tarPeriodCount,tarDisabled,rulAmountPeriod,rulAmountPeriodDay) VALUES (22,4,'2023-02-16 06:00:00','2023-02-16 21:59:59',7,100,1,1,1,0,0,0); insert into temp_tariff (tarId,tarDay,tarHourFrom,tarHourTo,tarNumber,tarAmount,tarPeriod,tarPeriodLength,tarPeriodCount,tarDisabled,rulAmountPeriod,rulAmountPeriodDay) VALUES (22,5,'2023-02-16 06:00:00','2023-02-16 21:59:59',7,100,1,1,1,0,0,0); insert into temp_tariff (tarId,tarDay,tarHourFrom,tarHourTo,tarNumber,tarAmount,tarPeriod,tarPeriodLength,tarPeriodCount,tarDisabled,rulAmountPeriod,rulAmountPeriodDay) VALUES (22,6,'2023-02-16 06:00:00','2023-02-16 21:59:59',7,100,1,1,1,0,0,0); insert into temp_tariff (tarId,tarDay,tarHourFrom,tarHourTo,tarNumber,tarAmount,tarPeriod,tarPeriodLength,tarPeriodCount,tarDisabled,rulAmountPeriod,rulAmountPeriodDay) VALUES (22,7,'2023-02-16 06:00:00','2023-02-16 21:59:59',7,100,1,1,1,0,0,0); insert into temp_tariff (tarId,tarDay,tarHourFrom,tarHourTo,tarNumber,tarAmount,tarPeriod,tarPeriodLength,tarPeriodCount,tarDisabled,rulAmountPeriod,rulAmountPeriodDay) VALUES (23,1,'2023-02-16 06:00:00','2023-02-16 21:59:59',8,0,59,59,1,0,0,0); insert into temp_tariff (tarId,tarDay,tarHourFrom,tarHourTo,tarNumber,tarAmount,tarPeriod,tarPeriodLength,tarPeriodCount,tarDisabled,rulAmountPeriod,rulAmountPeriodDay) VALUES (23,2,'2023-02-16 06:00:00','2023-02-16 21:59:59',8,0,59,59,1,0,0,0); insert into temp_tariff (tarId,tarDay,tarHourFrom,tarHourTo,tarNumber,tarAmount,tarPeriod,tarPeriodLength,tarPeriodCount,tarDisabled,rulAmountPeriod,rulAmountPeriodDay) VALUES (23,3,'2023-02-16 06:00:00','2023-02-16 21:59:59',8,0,59,59,1,0,0,0); insert into temp_tariff (tarId,tarDay,tarHourFrom,tarHourTo,tarNumber,tarAmount,tarPeriod,tarPeriodLength,tarPeriodCount,tarDisabled,rulAmountPeriod,rulAmountPeriodDay) VALUES (23,4,'2023-02-16 06:00:00','2023-02-16 21:59:59',8,0,59,59,1,0,0,0); insert into temp_tariff (tarId,tarDay,tarHourFrom,tarHourTo,tarNumber,tarAmount,tarPeriod,tarPeriodLength,tarPeriodCount,tarDisabled,rulAmountPeriod,rulAmountPeriodDay) VALUES (23,5,'2023-02-16 06:00:00','2023-02-16 21:59:59',8,0,59,59,1,0,0,0); insert into temp_tariff (tarId,tarDay,tarHourFrom,tarHourTo,tarNumber,tarAmount,tarPeriod,tarPeriodLength,tarPeriodCount,tarDisabled,rulAmountPeriod,rulAmountPeriodDay) VALUES (23,6,'2023-02-16 06:00:00','2023-02-16 21:59:59',8,0,59,59,1,0,0,0); insert into temp_tariff (tarId,tarDay,tarHourFrom,tarHourTo,tarNumber,tarAmount,tarPeriod,tarPeriodLength,tarPeriodCount,tarDisabled,rulAmountPeriod,rulAmountPeriodDay) VALUES (23,7,'2023-02-16 06:00:00','2023-02-16 21:59:59',8,0,59,59,1,0,0,0); insert into temp_tariff (tarId,tarDay,tarHourFrom,tarHourTo,tarNumber,tarAmount,tarPeriod,tarPeriodLength,tarPeriodCount,tarDisabled,rulAmountPeriod,rulAmountPeriodDay) VALUES (24,1,'2023-02-16 06:00:00','2023-02-16 21:59:59',9,100,60,0,0,0,0,0); insert into temp_tariff (tarId,tarDay,tarHourFrom,tarHourTo,tarNumber,tarAmount,tarPeriod,tarPeriodLength,tarPeriodCount,tarDisabled,rulAmountPeriod,rulAmountPeriodDay) VALUES (24,2,'2023-02-16 06:00:00','2023-02-16 21:59:59',9,100,60,0,0,0,0,0); insert into temp_tariff (tarId,tarDay,tarHourFrom,tarHourTo,tarNumber,tarAmount,tarPeriod,tarPeriodLength,tarPeriodCount,tarDisabled,rulAmountPeriod,rulAmountPeriodDay) VALUES (24,3,'2023-02-16 06:00:00','2023-02-16 21:59:59',9,100,60,0,0,0,0,0); insert into temp_tariff (tarId,tarDay,tarHourFrom,tarHourTo,tarNumber,tarAmount,tarPeriod,tarPeriodLength,tarPeriodCount,tarDisabled,rulAmountPeriod,rulAmountPeriodDay) VALUES (24,4,'2023-02-16 06:00:00','2023-02-16 21:59:59',9,100,60,0,0,0,0,0); insert into temp_tariff (tarId,tarDay,tarHourFrom,tarHourTo,tarNumber,tarAmount,tarPeriod,tarPeriodLength,tarPeriodCount,tarDisabled,rulAmountPeriod,rulAmountPeriodDay) VALUES (24,5,'2023-02-16 06:00:00','2023-02-16 21:59:59',9,100,60,0,0,0,0,0); insert into temp_tariff (tarId,tarDay,tarHourFrom,tarHourTo,tarNumber,tarAmount,tarPeriod,tarPeriodLength,tarPeriodCount,tarDisabled,rulAmountPeriod,rulAmountPeriodDay) VALUES (24,6,'2023-02-16 06:00:00','2023-02-16 21:59:59',9,100,60,0,0,0,0,0); insert into temp_tariff (tarId,tarDay,tarHourFrom,tarHourTo,tarNumber,tarAmount,tarPeriod,tarPeriodLength,tarPeriodCount,tarDisabled,rulAmountPeriod,rulAmountPeriodDay) VALUES (24,7,'2023-02-16 06:00:00','2023-02-16 21:59:59',9,100,60,0,0,0,0,0); insert into temp_tariff (tarId,tarDay,tarHourFrom,tarHourTo,tarNumber,tarAmount,tarPeriod,tarPeriodLength,tarPeriodCount,tarDisabled,rulAmountPeriod,rulAmountPeriodDay) VALUES (25,1,'2023-02-16 22:00:00','2023-02-16 23:57:59',10,100,57,57,1,0,0,0); insert into temp_tariff (tarId,tarDay,tarHourFrom,tarHourTo,tarNumber,tarAmount,tarPeriod,tarPeriodLength,tarPeriodCount,tarDisabled,rulAmountPeriod,rulAmountPeriodDay) VALUES (25,2,'2023-02-16 22:00:00','2023-02-16 23:57:59',10,100,57,57,1,0,0,0); insert into temp_tariff (tarId,tarDay,tarHourFrom,tarHourTo,tarNumber,tarAmount,tarPeriod,tarPeriodLength,tarPeriodCount,tarDisabled,rulAmountPeriod,rulAmountPeriodDay) VALUES (25,3,'2023-02-16 22:00:00','2023-02-16 23:57:59',10,100,57,57,1,0,0,0); insert into temp_tariff (tarId,tarDay,tarHourFrom,tarHourTo,tarNumber,tarAmount,tarPeriod,tarPeriodLength,tarPeriodCount,tarDisabled,rulAmountPeriod,rulAmountPeriodDay) VALUES (25,4,'2023-02-16 22:00:00','2023-02-16 23:57:59',10,100,57,57,1,0,0,0); insert into temp_tariff (tarId,tarDay,tarHourFrom,tarHourTo,tarNumber,tarAmount,tarPeriod,tarPeriodLength,tarPeriodCount,tarDisabled,rulAmountPeriod,rulAmountPeriodDay) VALUES (25,5,'2023-02-16 22:00:00','2023-02-16 23:57:59',10,100,57,57,1,0,0,0); insert into temp_tariff (tarId,tarDay,tarHourFrom,tarHourTo,tarNumber,tarAmount,tarPeriod,tarPeriodLength,tarPeriodCount,tarDisabled,rulAmountPeriod,rulAmountPeriodDay) VALUES (25,6,'2023-02-16 22:00:00','2023-02-16 23:57:59',10,100,57,57,1,0,0,0); insert into temp_tariff (tarId,tarDay,tarHourFrom,tarHourTo,tarNumber,tarAmount,tarPeriod,tarPeriodLength,tarPeriodCount,tarDisabled,rulAmountPeriod,rulAmountPeriodDay) VALUES (25,7,'2023-02-16 22:00:00','2023-02-16 23:57:59',10,100,57,57,1,0,0,0); insert into temp_tariff (tarId,tarDay,tarHourFrom,tarHourTo,tarNumber,tarAmount,tarPeriod,tarPeriodLength,tarPeriodCount,tarDisabled,rulAmountPeriod,rulAmountPeriodDay) VALUES (26,1,'2023-02-16 22:00:00','2023-02-16 23:57:59',11,0,1,0,0,0,0,0); insert into temp_tariff (tarId,tarDay,tarHourFrom,tarHourTo,tarNumber,tarAmount,tarPeriod,tarPeriodLength,tarPeriodCount,tarDisabled,rulAmountPeriod,rulAmountPeriodDay) VALUES (26,2,'2023-02-16 22:00:00','2023-02-16 23:57:59',11,0,1,0,0,0,0,0); insert into temp_tariff (tarId,tarDay,tarHourFrom,tarHourTo,tarNumber,tarAmount,tarPeriod,tarPeriodLength,tarPeriodCount,tarDisabled,rulAmountPeriod,rulAmountPeriodDay) VALUES (26,3,'2023-02-16 22:00:00','2023-02-16 23:57:59',11,0,1,0,0,0,0,0); insert into temp_tariff (tarId,tarDay,tarHourFrom,tarHourTo,tarNumber,tarAmount,tarPeriod,tarPeriodLength,tarPeriodCount,tarDisabled,rulAmountPeriod,rulAmountPeriodDay) VALUES (26,4,'2023-02-16 22:00:00','2023-02-16 23:57:59',11,0,1,0,0,0,0,0); insert into temp_tariff (tarId,tarDay,tarHourFrom,tarHourTo,tarNumber,tarAmount,tarPeriod,tarPeriodLength,tarPeriodCount,tarDisabled,rulAmountPeriod,rulAmountPeriodDay) VALUES (26,5,'2023-02-16 22:00:00','2023-02-16 23:57:59',11,0,1,0,0,0,0,0); insert into temp_tariff (tarId,tarDay,tarHourFrom,tarHourTo,tarNumber,tarAmount,tarPeriod,tarPeriodLength,tarPeriodCount,tarDisabled,rulAmountPeriod,rulAmountPeriodDay) VALUES (26,6,'2023-02-16 22:00:00','2023-02-16 23:57:59',11,0,1,0,0,0,0,0); insert into temp_tariff (tarId,tarDay,tarHourFrom,tarHourTo,tarNumber,tarAmount,tarPeriod,tarPeriodLength,tarPeriodCount,tarDisabled,rulAmountPeriod,rulAmountPeriodDay) VALUES (26,7,'2023-02-16 22:00:00','2023-02-16 23:57:59',11,0,1,0,0,0,0,0); insert into temp_tariff (tarId,tarDay,tarHourFrom,tarHourTo,tarNumber,tarAmount,tarPeriod,tarPeriodLength,tarPeriodCount,tarDisabled,rulAmountPeriod,rulAmountPeriodDay) VALUES (27,1,'2023-02-16 23:58:00','2023-02-16 23:59:59',12,-100,1,1,1,0,0,0); insert into temp_tariff (tarId,tarDay,tarHourFrom,tarHourTo,tarNumber,tarAmount,tarPeriod,tarPeriodLength,tarPeriodCount,tarDisabled,rulAmountPeriod,rulAmountPeriodDay) VALUES (27,2,'2023-02-16 23:58:00','2023-02-16 23:59:59',12,-100,1,1,1,0,0,0); insert into temp_tariff (tarId,tarDay,tarHourFrom,tarHourTo,tarNumber,tarAmount,tarPeriod,tarPeriodLength,tarPeriodCount,tarDisabled,rulAmountPeriod,rulAmountPeriodDay) VALUES (27,3,'2023-02-16 23:58:00','2023-02-16 23:59:59',12,-100,1,1,1,0,0,0); insert into temp_tariff (tarId,tarDay,tarHourFrom,tarHourTo,tarNumber,tarAmount,tarPeriod,tarPeriodLength,tarPeriodCount,tarDisabled,rulAmountPeriod,rulAmountPeriodDay) VALUES (27,4,'2023-02-16 23:58:00','2023-02-16 23:59:59',12,-100,1,1,1,0,0,0); insert into temp_tariff (tarId,tarDay,tarHourFrom,tarHourTo,tarNumber,tarAmount,tarPeriod,tarPeriodLength,tarPeriodCount,tarDisabled,rulAmountPeriod,rulAmountPeriodDay) VALUES (27,5,'2023-02-16 23:58:00','2023-02-16 23:59:59',12,-100,1,1,1,0,0,0); insert into temp_tariff (tarId,tarDay,tarHourFrom,tarHourTo,tarNumber,tarAmount,tarPeriod,tarPeriodLength,tarPeriodCount,tarDisabled,rulAmountPeriod,rulAmountPeriodDay) VALUES (27,6,'2023-02-16 23:58:00','2023-02-16 23:59:59',12,-100,1,1,1,0,0,0); insert into temp_tariff (tarId,tarDay,tarHourFrom,tarHourTo,tarNumber,tarAmount,tarPeriod,tarPeriodLength,tarPeriodCount,tarDisabled,rulAmountPeriod,rulAmountPeriodDay) VALUES (27,7,'2023-02-16 23:58:00','2023-02-16 23:59:59',12,-100,1,1,1,0,0,0); insert into temp_tariff (tarId,tarDay,tarHourFrom,tarHourTo,tarNumber,tarAmount,tarPeriod,tarPeriodLength,tarPeriodCount,tarDisabled,rulAmountPeriod,rulAmountPeriodDay) VALUES (28,1,'2023-02-16 23:58:00','2023-02-16 23:59:59',13,0,1,0,0,0,0,0); insert into temp_tariff (tarId,tarDay,tarHourFrom,tarHourTo,tarNumber,tarAmount,tarPeriod,tarPeriodLength,tarPeriodCount,tarDisabled,rulAmountPeriod,rulAmountPeriodDay) VALUES (28,2,'2023-02-16 23:58:00','2023-02-16 23:59:59',13,0,1,0,0,0,0,0); insert into temp_tariff (tarId,tarDay,tarHourFrom,tarHourTo,tarNumber,tarAmount,tarPeriod,tarPeriodLength,tarPeriodCount,tarDisabled,rulAmountPeriod,rulAmountPeriodDay) VALUES (28,3,'2023-02-16 23:58:00','2023-02-16 23:59:59',13,0,1,0,0,0,0,0); insert into temp_tariff (tarId,tarDay,tarHourFrom,tarHourTo,tarNumber,tarAmount,tarPeriod,tarPeriodLength,tarPeriodCount,tarDisabled,rulAmountPeriod,rulAmountPeriodDay) VALUES (28,4,'2023-02-16 23:58:00','2023-02-16 23:59:59',13,0,1,0,0,0,0,0); insert into temp_tariff (tarId,tarDay,tarHourFrom,tarHourTo,tarNumber,tarAmount,tarPeriod,tarPeriodLength,tarPeriodCount,tarDisabled,rulAmountPeriod,rulAmountPeriodDay) VALUES (28,5,'2023-02-16 23:58:00','2023-02-16 23:59:59',13,0,1,0,0,0,0,0); insert into temp_tariff (tarId,tarDay,tarHourFrom,tarHourTo,tarNumber,tarAmount,tarPeriod,tarPeriodLength,tarPeriodCount,tarDisabled,rulAmountPeriod,rulAmountPeriodDay) VALUES (28,6,'2023-02-16 23:58:00','2023-02-16 23:59:59',13,0,1,0,0,0,0,0); insert into temp_tariff (tarId,tarDay,tarHourFrom,tarHourTo,tarNumber,tarAmount,tarPeriod,tarPeriodLength,tarPeriodCount,tarDisabled,rulAmountPeriod,rulAmountPeriodDay) VALUES (28,7,'2023-02-16 23:58:00','2023-02-16 23:59:59',13,0,1,0,0,0,0,0); 15/09/2023 09:53:17.2922 4302 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 15/09/2023 09:53:17.4623 4349 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 6 15/09/2023 09:53:31.5728 4169 ms. OPEN: select * from opeShifts where sftId = 594 and sftStatus = 'V' (WAIT TIME 30 ms.) 15/09/2023 09:54:50.4931 4147 ms. OPEN: SELECT * FROM movLinks INNER JOIN movTransit on traUID = mliTraUID WHERE mliRFIDCode = '451816459900327005012999' AND mliStatus='V' ORDER BY mliId DESC LIMIT 1 15/09/2023 09:55:12.8992 4096 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 15/09/2023 09:55:27.1358 4272 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-09-15 09:55:22','V',4719626034294460,2023,'2023-09-15 09:55:07','451823570700327005031999',1,2,16,'I','',1,0,1,'','',4) 15/09/2023 09:57:24.6901 4528 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 5 (WAIT TIME 6 ms.) 15/09/2023 09:57:33.4670 4678 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 5 (WAIT TIME 8633 ms.) 15/09/2023 09:57:33.5341 8673 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-09-15 09:57:24','V',4740660171671280,2023,'2023-09-15 09:56:59','451823581900327005012999',1,2,16,'I','',1,0,1,'','',4) (WAIT TIME 91 ms.) 15/09/2023 09:57:36.6912 2554 ms. EXEC: update abbAreaGroup set argNrInside = 0 where argStatus='V' and argNrInside < 0 (WAIT TIME 118 ms.) 15/09/2023 09:57:46.0635 8813 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 15/09/2023 09:58:20.5308 2396 ms. OPEN: select parVatRate,parVatName,parVatMethod,parVatRound,parVatDiscount from tabParameters where parStatus='V' order by parId desc limit 1 15/09/2023 09:59:05.6212 9417 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-09-15 09:58:56','V',5027783083594480,2023,'2023-09-15 09:58:33','451823591300327005031999',1,2,16,'I','',1,0,1,'','',4) 15/09/2023 09:59:10.4165 4678 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-09-15 09:59:05','V',4940013884845460,2023,'2023-09-15 09:58:57','451823593700327005012999',1,2,16,'I','',1,0,1,'','',4) (WAIT TIME 45 ms.) 15/09/2023 09:59:15.1867 4497 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 1 (WAIT TIME 48 ms.) 15/09/2023 09:59:19.9659 4632 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 (WAIT TIME 78 ms.) 15/09/2023 09:59:43.7209 4448 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 5 and terStatus='V' (WAIT TIME 85 ms.) 15/09/2023 10:00:16.9033 4228 ms. OPEN: select * from tabuser where useStatus='V' order by useId 15/09/2023 10:00:35.8731 4422 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-09-15 10:00:31','V',5267012871959020,2023,'2023-09-15 10:00:29','451823602900327005012999',1,2,16,'I','',1,0,1,'','0230004101216',10,0) 15/09/2023 10:01:28.1234 4502 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 2 15/09/2023 10:01:37.6238 4160 ms. OPEN: select * from tabArea where areId = 1 and areStatus='V' and areEnabled = 1 15/09/2023 10:02:44.1236 4556 ms. EXECSCALAR: select count(*) from tabTerminalExtraMem where extStatus='V' and extTerId = 16 nr: 1 15/09/2023 10:02:48.8738 4295 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 15/09/2023 10:03:27.0106 4409 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 (WAIT TIME 93 ms.) 15/09/2023 10:03:31.6527 4144 ms. OPEN: select * from tabArea where areStatus='V' and areEnabled = 1 AND areId = 1 15/09/2023 10:04:33.4564 4362 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 15/09/2023 10:04:52.3752 4513 ms. OPEN: select * from tabArea where areStatus='V' and areEnabled = 1 AND areId = 1 15/09/2023 10:06:08.3744 4602 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 15/09/2023 10:06:22.6291 4469 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 4 OR lnsTerId=4) 15/09/2023 10:06:36.8737 4636 ms. OPEN: select * from tabDevice where devId = 2 and devStatus = 'V' 15/09/2023 10:07:19.6255 4635 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-09-15 10:07:14','V',5531675766948410,2023,'2023-09-15 10:07:12','451823643200327005012999',1,2,16,'I','',1,0,1,'','',4) 15/09/2023 10:07:29.1259 4545 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 5 and terStatus='V' 15/09/2023 10:07:38.6964 4460 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 15/09/2023 11:02:58.0041 541 ms. EXEC: update payReceipt set recCreation = '2023-09-15 11:02:57',recModify = '2023-09-15 11:02:57',recUseId=0,recStatus='V' where recId = 166514 15/09/2023 12:10:01.4856 513 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2023-09-15 12:10:00',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'; 15/09/2023 12:13:34.0872 610 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-09-15 12:13:33','V',5464218265047660,2023,'2023-09-15 12:13:33','451824401300327001012999',1,2,1,'I','',1,0,1,'','',4) 15/09/2023 12:26:08.3714 650 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-09-15 12:24:39',12,'V',5534462403498250,5427233962513310,2023,'2023-09-15 12:24:39',17,1,0,4,'2023-09-15 12:39:39','C','KES',50,50,0,'','','',1,50,0,0,'',0,0) 15/09/2023 13:40:13.2447 566 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2023-09-15 13:40:12' where traUID = 5728000250247930 and traStatus='V' and traEnabled=1 15/09/2023 14:09:45.1810 510 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 15/09/2023 15:31:34.9087 513 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-09-15 15:31:34','V',5460982985519050,2023,'2023-09-15 15:31:33','451825589300327005012999',1,2,16,'I','',1,0,1,'','',4) 15/09/2023 15:46:57.0531 564 ms. EXEC: insert into paycash (casCreation,casModify,casUseId,casStatus,casUID,casTraUID,casYear,casDateTime,casIdTerminal,casCurrency,casNumber,casSingleAmount,casTotAmount,casType,casDescription) VALUES ('2023-09-15 15:46:56',0,0,'V',5696650337199580,4628652101531720,2023,'2023-09-15 15:46:56',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-09-15 15:46:56',0,0,'V',5696650337199580,4628652101531720,2023,'2023-09-15 15:46:56',3,'KES',-1,100,-100,'N',''); 15/09/2023 19:07:04.2949 532 ms. EXEC: update abbCards set carLastDate = '2023-09-15 19:07:03',carLastDirection='O' where carStatus='V' and carId = 66 15/09/2023 20:56:19.0059 668 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-09-15 20:56:18','V',4613831749328670,2023,'2023-09-15 20:56:16','451826715200327005012999',2,2,2,'O','',0,'2023-09-15 20:56:18',1,'','0230003943530',44,0)