23/01/2024 17:43:37.1888 718 ms. EXECSCALAR: select count(*) from information_schema.tables where table_schema= 'wisepark_0327' and table_name= 'payInvoiceFtp' nr: 1 23/01/2024 17:43:37.2058 3501 ms. OPEN: show columns from tabParameters where Field = 'parAllowNegativePlaces' 23/01/2024 17:43:57.3891 13206 ms. OPEN: SELECT * FROM movLinks INNER JOIN movTransit on traUID = mliTraUID WHERE mliRFIDCode = '0322126284443' AND mliStatus='V' ORDER BY mliId DESC LIMIT 1 23/01/2024 17:43:57.3891 13787 ms. OPEN: SELECT * FROM movLinks INNER JOIN movTransit on traUID = mliTraUID WHERE mliRFIDCode = '0098788191889' AND mliStatus='V' ORDER BY mliId DESC LIMIT 1 23/01/2024 17:43:57.9775 583 ms. OPEN: select * from tabClass where claPosition = 1 and claStatus='V' 23/01/2024 17:43:57.9785 586 ms. OPEN: select * from tabClass where claPosition = 2 and claStatus='V' 23/01/2024 17:43:59.4224 21110 ms. EXECSCALAR: SELECT count(*) FROM payinventory WHERE invValue<>0 AND invType='' nr: 0 23/01/2024 17:44:00.1689 552 ms. OPEN: select * from movTransit where traStatus='V' and traBadge = '0532370677393' and traDirection='I' order by traId desc limit 1 23/01/2024 17:44:01.0555 1072 ms. OPEN: select * from abbCards inner join abbSubscriptions on carSubId = subId inner join tabCustomer on cusId = subCusId left join tabAbbGroups on cusAbgId = abgId where carStatus='V' and carId = 49 23/01/2024 17:44:02.5115 2328 ms. EXEC: insert into movtransit (traUseId,traCreation,traStatus,traUID,traYear,traDateTime,traCode,traType,traClass,traIdTerminal,traDirection,traPlate,traEnabled,traDisableTime,traAreId,traNotes,traBadge,traCarId,traTarId) VALUES (0,'2024-01-23 17:44:00','V',5586377379236440,2024,'2024-01-21 17:24:56','453094400500327005029999',2,1,2,'O','',1,0,1,'','0532370677393',15,0) 23/01/2024 17:44:02.5115 1452 ms. EXEC: insert into movtransit (traUseId,traCreation,traStatus,traUID,traYear,traDateTime,traCode,traType,traClass,traIdTerminal,traDirection,traPlate,traEnabled,traDisableTime,traAreId,traNotes,traBadge,traCarId,traTarId) VALUES (0,'2024-01-23 17:44:01','V',5525878407193990,2024,'2024-01-22 12:43:44','453110001900327005029999',2,2,16,'I','',1,0,1,'','1742679427739',49,0) 23/01/2024 17:44:04.5498 2026 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 23/01/2024 17:44:04.6329 843 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 23/01/2024 17:44:04.6329 1901 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 23/01/2024 17:44:04.6339 518 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 23/01/2024 17:44:05.9968 753 ms. OPEN: select * from tabUserMessage where useMesDescr = 'err_ticketnotfound' and (useLanCode = 'en-US' or mid(useLanCode,1,2) = 'en') 23/01/2024 17:44:07.0275 640 ms. OPEN: show columns from tabTariff where Field = 'tarTimeControlTimeBegin' 23/01/2024 17:44:07.7550 7859 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 23/01/2024 17:44:10.3467 778 ms. EXEC: insert into movtransit (traUseId,traCreation,traStatus,traUID,traYear,traDateTime,traCode,traType,traClass,traIdTerminal,traDirection,traPlate,traEnabled,traDisableTime,traAreId,traNotes,traBadge,traTarId) VALUES (0,'2024-01-23 17:44:09','V',4738979114832070,2024,'2024-01-22 14:28:14','0347899454317',2,1,2,'O','',1,0,1,'','',0) 23/01/2024 17:44:17.0118 9256 ms. EXEC: UPDATE payInventory SET invType='C' WHERE invType<>'C' AND invValue IN (5,10,20,40) AND invDevice IN (41003,41002,41001,41101,41102,41103); 23/01/2024 17:44:17.7313 691 ms. EXEC: UPDATE payInventory SET invType='N' WHERE invType<>'N' AND invValue IN (100,200,500) AND invDevice IN (42102,42101,42001); 23/01/2024 17:44:18.2046 573 ms. EXEC: insert into movtransit (traUseId,traCreation,traStatus,traUID,traYear,traDateTime,traCode,traType,traClass,traIdTerminal,traDirection,traPlate,traEnabled,traDisableTime,traAreId,traNotes,traBadge,traTarId) VALUES (0,'2024-01-23 17:44:17','V',4991786004083950,2024,'2024-01-22 15:09:53','0347899454317',2,1,2,'O','',1,0,1,'','',0) 23/01/2024 17:44:18.3907 620 ms. EXECSCALAR: select count(*) from tabTables where tabId = 30 and tabTxtValue='22' and tabTable = 'devAction' nr: 0 23/01/2024 17:44:21.7299 604 ms. EXEC: insert into movtransit (traUseId,traCreation,traStatus,traUID,traYear,traDateTime,traCode,traType,traClass,traIdTerminal,traDirection,traPlate,traEnabled,traDisableTime,traAreId,traNotes,traBadge,traTarId) VALUES (0,'2024-01-23 17:44:21','V',4954236555896800,2024,'2024-01-22 15:32:15','0347899454317',2,1,2,'O','',1,0,1,'','',0) 23/01/2024 17:44:32.8346 548 ms. OPEN: select * from movTransit where traStatus='V' and traBadge = '0532370675566' and traDirection='I' order by traId desc limit 1 23/01/2024 17:44:50.8931 1540 ms. OPEN: select sum(payPayed) as vTot,sum(payChange) as vChange from movTransit inner join payPayment on payPayment.payTraUID = movTransit.traUID LEFT JOIN tabTerminal on terId = payIdTerminal WHERE traCode = '453126388700327005012999' AND traStatus='V' AND payStatus='V' and (terType IS NULL OR terType<>3 OR (terType=3 and payType='P')) 23/01/2024 17:44:55.1230 540 ms. EXEC: insert into movtransit (traUseId,traCreation,traStatus,traUID,traYear,traDateTime,traCode,traType,traClass,traIdTerminal,traDirection,traPlate,traEnabled,traDisableTime,traAreId,traNotes,traBadge,traTarId) VALUES (0,'2024-01-23 17:44:54','V',4702096838817290,2024,'2024-01-23 07:45:08','0347899454317',2,1,2,'O','',1,0,1,'','',0) 23/01/2024 17:52:46.2627 17684 ms. OPEN: select traId,traDateTime,traEnabled,traDisableTime,traCode,traBadge,traCarId,traAreId,traIdTerminal from movtransit where traStatus='V' and traDirection = 'I' and traCarId = 44 order by traDateTime desc,traId desc 23/01/2024 17:52:48.6963 2279 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 = '453110003000327005029999' and traStatus='V' and casStatus='V' and terType=3 and casTotAmount>0 23/01/2024 17:52:51.2966 2595 ms. OPEN: select sum(payPayed) as vTot,sum(payChange) as vChange from movTransit inner join payPayment on payPayment.payTraUID = movTransit.traUID LEFT JOIN tabTerminal on terId = payIdTerminal WHERE traCode = '453110003000327005029999' AND traStatus='V' AND payStatus='V' and (terType IS NULL OR terType<>3 OR (terType=3 and payType='P')) 23/01/2024 17:54:23.6788 1141 ms. OPEN: select traId,traDateTime,traEnabled,traDisableTime,traCode,traBadge,traCarId,traAreId,traIdTerminal from movtransit where traStatus='V' and traDirection = 'I' and traCarId = 13 order by traDateTime desc,traId desc 23/01/2024 17:55:50.5799 5605 ms. OPEN: select count(payId) as Tot,0 as payUID,sum(payPayed) as payPayed,sum(payChange) as payChange,payAmount,traUIDGroup,traType,traClass,traIdTerminal,traDiscountValue,traDiscountType,traCarId,payIdEvent,payType,payCardType from payPayment LEFT join movtransit on trauid = payTraUID LEFT JOIN payReport ON repPayUID = payUID AND repStatus='V' where payStatus = 'V' and (payType='C' or payType='P') and payUseId = 6 and payIdEvent<90 and repPayUID IS NULL and (traCarId is null or traCarId=0 or traCarId in (select carId from abbCards inner join abbsubscriptions on subId= carSubId where carStatus='V' and subStatus='V' and subAbbType<>5)) group by traUIDGroup,payAmount,payIdEvent,payType,payCardType,traType,traIdTerminal,traDiscountValue,traDiscountType,traCarId order by traUIDGroup,payAmount, traType, traDiscountValue, traDiscountType 23/01/2024 18:10:05.2686 963 ms. EXEC: insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2024-01-23 18:08:59',5,3,42101,0,50,-7,-350,1,'O','N'); insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2024-01-23 18:08:59',5,3,42101,0,50,7,350,2,'I','N'); insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2024-01-23 18:08:59',5,3,42101,0,100,-21,-2100,1,'O','N'); insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2024-01-23 18:08:59',5,3,42101,0,100,21,2100,2,'I','N'); insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2024-01-23 18:08:59',5,3,42101,0,200,-6,-1200,1,'O','N'); insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2024-01-23 18:08:59',5,3,42101,0,200,6,1200,2,'I','N'); insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2024-01-23 18:08:59',5,3,42101,0,500,-2,-1000,1,'O','N'); insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2024-01-23 18:08:59',5,3,42101,0,500,2,1000,2,'I','N'); insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2024-01-23 18:08:59',5,3,42101,1,0,0,0,1,'O',''); update payCurInventory set curQuantity=0,curAmount=0 where curQuantity<0; 23/01/2024 18:19:28.2675 771 ms. OPEN: select traId,traDateTime,traEnabled,traDisableTime,traCode,traBadge,traCarId,traAreId,traIdTerminal from movtransit where traStatus='V' and traDirection = 'I' and traCarId = 14 order by traDateTime desc,traId desc