26/11/2024 13:02:26.8216 3049 ms. OPEN: show columns from tabParameters where Field = 'parAllowNegativePlaces' 26/11/2024 14:17:55.8775 3116 ms. OPEN: show columns from tabParameters where Field = 'parAllowNegativePlaces' 26/11/2024 14:20:53.7116 831 ms. EXEC: insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2024-11-26 14:20:52',3,42101,0,50,-1,-50,1,'O','N'); update payCurInventory set curQuantity=round(curQuantity-1,5),curAmount=round(curAmount-50,5) where curTerId = 3 and curDevCode = 42101 and curChannelId = 1 and curValue = 50 and curType = 'N'; insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2024-11-26 14:20:52',3,42101,0,50,1,50,2,'I','N'); update payCurInventory set curQuantity=round(curQuantity+1,5),curAmount=round(curAmount+50,5) where curTerId = 3 and curDevCode = 42101 and curChannelId = 2 and curValue = 50 and curType = 'N'; 26/11/2024 17:16:16.1941 27774 ms. OPEN: show columns from tabParameters where Field = 'parAllowNegativePlaces' 26/11/2024 17:16:17.3739 658 ms. OPEN: show columns from movLinks where Field = 'mliReceiptMessage' 26/11/2024 17:16:18.6918 535 ms. EXECSCALAR: select count(*) from information_schema.tables where table_schema= 'wisepark_0327' and table_name= 'movTransitPlates' nr: 1 (WAIT TIME 5 ms.) 26/11/2024 17:16:18.7008 549 ms. EXECSCALAR: select count(*) from tabTerminalExtraMem where extStatus='V' and extTerId = 1 nr: 0 26/11/2024 17:16:18.7018 537 ms. EXECSCALAR: select count(*) from tabTerminalExtraMem where extStatus='V' and extTerId = 1 nr: 0 (WAIT TIME 15 ms.) 26/11/2024 17:16:18.7768 627 ms. EXECSCALAR: select count(*) from tabTerminalExtraMem where extStatus='V' and extTerId = 16 nr: 0 26/11/2024 17:16:20.3989 580 ms. EXECSCALAR: select count(resId) as Tot from movReservation where resStatus = 'V' and resTypeRes = 'B' AND ((resConfirmed IN (0,2,3) AND resCreation>'2024-11-26 16:16:19') OR resConfirmed IN (4,5)) and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) <= '2024-11-26 17:16:18' and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) >= '2024-11-26 17:16:18' and (resAreId = 1 or resAreId <= 0) nr: 0 26/11/2024 17:16:20.3989 570 ms. EXECSCALAR: select count(resId) as Tot from movReservation where resStatus = 'V' and resTypeRes = 'B' AND ((resConfirmed IN (0,2,3) AND resCreation>'2024-11-26 16:16:19') OR resConfirmed IN (4,5)) and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) <= '2024-11-26 17:16:18' and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) >= '2024-11-26 17:16:18' and (resAreId = 1 or resAreId <= 0) nr: 0 26/11/2024 17:16:20.3999 580 ms. EXECSCALAR: select count(resId) as Tot from movReservation where resStatus = 'V' and resTypeRes = 'B' AND ((resConfirmed IN (0,2,3) AND resCreation>'2024-11-26 16:16:19') OR resConfirmed IN (4,5)) and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) <= '2024-11-26 17:16:18' and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) >= '2024-11-26 17:16:18' and (resAreId = 1 or resAreId <= 0) nr: 0 26/11/2024 17:16:20.4059 576 ms. EXECSCALAR: select count(resId) as Tot from movReservation where resStatus = 'V' and resTypeRes = 'B' AND ((resConfirmed IN (0,2,3) AND resCreation>'2024-11-26 16:16:19') OR resConfirmed IN (4,5)) and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) <= '2024-11-26 17:16:18' and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) >= '2024-11-26 17:16:18' and (resAreId = 1 or resAreId <= 0) nr: 0 (WAIT TIME 3 ms.) 26/11/2024 17:16:20.4099 573 ms. EXECSCALAR: select count(resId) as Tot from movReservation where resStatus = 'V' and resTypeRes = 'B' AND ((resConfirmed IN (0,2,3) AND resCreation>'2024-11-26 16:16:19') OR resConfirmed IN (4,5)) and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) <= '2024-11-26 17:16:18' and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) >= '2024-11-26 17:16:18' and (resAreId = 1 or resAreId <= 0) nr: 0 (WAIT TIME 6 ms.) 26/11/2024 17:16:20.4129 563 ms. EXECSCALAR: select count(resId) as Tot from movReservation where resStatus = 'V' and resTypeRes = 'B' AND ((resConfirmed IN (0,2,3) AND resCreation>'2024-11-26 16:16:19') OR resConfirmed IN (4,5)) and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) <= '2024-11-26 17:16:18' and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) >= '2024-11-26 17:16:18' and (resAreId = 1 or resAreId <= 0) nr: 0 (WAIT TIME 11 ms.) 26/11/2024 17:16:20.4169 567 ms. EXECSCALAR: select count(resId) as Tot from movReservation where resStatus = 'V' and resTypeRes = 'B' AND ((resConfirmed IN (0,2,3) AND resCreation>'2024-11-26 16:16:19') OR resConfirmed IN (4,5)) and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) <= '2024-11-26 17:16:18' and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) >= '2024-11-26 17:16:18' and (resAreId = 1 or resAreId <= 0) nr: 0 (WAIT TIME 16 ms.) 26/11/2024 17:16:20.4189 566 ms. EXECSCALAR: select count(resId) as Tot from movReservation where resStatus = 'V' and resTypeRes = 'B' AND ((resConfirmed IN (0,2,3) AND resCreation>'2024-11-26 16:16:19') OR resConfirmed IN (4,5)) and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) <= '2024-11-26 17:16:18' and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) >= '2024-11-26 17:16:18' and (resAreId = 1 or resAreId <= 0) nr: 0 (WAIT TIME 17 ms.) 26/11/2024 17:16:20.4229 558 ms. EXECSCALAR: select count(resId) as Tot from movReservation where resStatus = 'V' and resTypeRes = 'B' AND ((resConfirmed IN (0,2,3) AND resCreation>'2024-11-26 16:16:19') OR resConfirmed IN (4,5)) and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) <= '2024-11-26 17:16:18' and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) >= '2024-11-26 17:16:18' and (resAreId = 1 or resAreId <= 0) nr: 0 (WAIT TIME 23 ms.) 26/11/2024 17:16:20.4269 564 ms. EXECSCALAR: select count(resId) as Tot from movReservation where resStatus = 'V' and resTypeRes = 'B' AND ((resConfirmed IN (0,2,3) AND resCreation>'2024-11-26 16:16:19') OR resConfirmed IN (4,5)) and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) <= '2024-11-26 17:16:18' and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) >= '2024-11-26 17:16:18' and (resAreId = 1 or resAreId <= 0) nr: 0 (WAIT TIME 24 ms.) 26/11/2024 17:16:20.4289 566 ms. EXECSCALAR: select count(resId) as Tot from movReservation where resStatus = 'V' and resTypeRes = 'B' AND ((resConfirmed IN (0,2,3) AND resCreation>'2024-11-26 16:16:19') OR resConfirmed IN (4,5)) and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) <= '2024-11-26 17:16:18' and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) >= '2024-11-26 17:16:18' and (resAreId = 1 or resAreId <= 0) nr: 0 (WAIT TIME 28 ms.) 26/11/2024 17:16:20.4319 583 ms. EXECSCALAR: select count(resId) as Tot from movReservation where resStatus = 'V' and resTypeRes = 'B' AND ((resConfirmed IN (0,2,3) AND resCreation>'2024-11-26 16:16:19') OR resConfirmed IN (4,5)) and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) <= '2024-11-26 17:16:18' and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) >= '2024-11-26 17:16:18' and (resAreId = 1 or resAreId <= 0) nr: 0 (WAIT TIME 27 ms.) 26/11/2024 17:16:20.4369 572 ms. OPEN: select parcurrency,parcurrencySymbol from tabParameters where parStatus='V' order by parId desc limit 1 (WAIT TIME 31 ms.) 26/11/2024 17:16:20.6110 634 ms. OPEN: select sum(crc32(terDescription)) as vCheck from tabTerminal (WAIT TIME 77 ms.) 26/11/2024 17:16:35.0329 15088 ms. OPEN: SELECT * FROM movLinks INNER JOIN movTransit on traUID = mliTraUID WHERE mliRFIDCode = '0098788348987' AND mliStatus='V' ORDER BY mliId DESC LIMIT 1 26/11/2024 17:16:35.0349 13800 ms. OPEN: SELECT * FROM movLinks INNER JOIN movTransit on traUID = mliTraUID WHERE mliRFIDCode = '456206162200327005031999' AND mliStatus='V' ORDER BY mliId DESC LIMIT 1 26/11/2024 17:16:37.7317 17098 ms. EXECSCALAR: SELECT count(*) FROM payinventory WHERE invValue<>0 AND invType='' nr: 0 26/11/2024 17:16:40.0502 2194 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-11-26 17:16:37','V',4731728609707240,2024,'2024-11-26 17:07:02','456206162200327005031999',1,2,16,'I','',1,0,1,'','',4) 26/11/2024 17:16:40.0512 2573 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-11-26 17:16:37','V',5269618568664670,2024,'2024-11-26 15:10:57','456205895700327002029999',2,1,2,'O','',1,0,1,'','0532370834491',8,0) 26/11/2024 17:16:42.1286 2029 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 = 10 26/11/2024 17:16:42.3758 2313 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 26/11/2024 17:16:42.4268 1460 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 26/11/2024 17:16:44.1470 5959 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 26/11/2024 17:16:46.7537 2606 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); 26/11/2024 17:17:52.2675 16156 ms. OPEN: select count(payId) as Tot,0 as payUID,sum(payPayed) as payPayed,sum(payChange) as payChange,payAmount,traUIDGroup,traType,traClass,traIdTerminal,traDiscountValue,traDiscountType,traCarId,payIdEvent,payType,payCardType from payPayment LEFT join movtransit on trauid = payTraUID LEFT JOIN payReport ON repPayUID = payUID AND repStatus='V' where payStatus = 'V' and (payType='C' or payType='P') and payUseId = 1 and payIdEvent<90 and repPayUID IS NULL and (traCarId is null or traCarId=0 or traCarId in (select carId from abbCards inner join abbsubscriptions on subId= carSubId where carStatus='V' and subStatus='V' and subAbbType<>5)) group by traUIDGroup,payAmount,payIdEvent,payType,payCardType,traType,traIdTerminal,traDiscountValue,traDiscountType,traCarId order by traUIDGroup,payAmount, traType, traDiscountValue, traDiscountType 26/11/2024 17:26:28.5305 1888 ms. OPEN: select traId,traDateTime,traEnabled,traDisableTime,traCode,traBadge,traCarId,traAreId,traIdTerminal from movtransit where traStatus='V' and traDirection = 'I' and traCarId = 103 order by traDateTime desc,traId desc 26/11/2024 17:30:42.3063 3259 ms. OPEN: select traId,traDateTime,traEnabled,traDisableTime,traCode,traBadge,traCarId,traAreId,traIdTerminal from movtransit where traStatus='V' and traDirection = 'I' and traCarId = 15 order by traDateTime desc,traId desc 26/11/2024 17:31:00.9287 597 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 26/11/2024 17:32:18.3448 834 ms. OPEN: select traId,traDateTime,traEnabled,traDisableTime,traCode,traBadge,traCarId,traAreId,traIdTerminal from movtransit where traStatus='V' and traDirection = 'I' and traCarId = 30 order by traDateTime desc,traId desc 26/11/2024 17:46:08.3367 784 ms. OPEN: select traId,traDateTime,traEnabled,traDisableTime,traCode,traBadge,traCarId,traAreId,traIdTerminal from movtransit where traStatus='V' and traDirection = 'I' and traCarId = 21 order by traDateTime desc,traId desc 26/11/2024 18:06:52.0374 541 ms. OPEN: select traId,traDateTime,traEnabled,traDisableTime,traCode,traBadge,traCarId,traAreId,traIdTerminal from movtransit where traStatus='V' and traDirection = 'I' and traCarId = 9 order by traDateTime desc,traId desc