09/06/2024 11:47:12.6581 525 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-06-09 11:47:12','V',4843139751728470,2024,'2024-06-09 11:47:11','454504243100327005012999',1,2,16,'I','',1,0,1,'','',4) 09/06/2024 12:27:48.2798 1780 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 09/06/2024 14:03:14.2642 582 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2024-06-09 14:03:13' where traUID = 5007677563118820 and traStatus='V' and traEnabled=1 09/06/2024 15:04:47.1118 540 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2024-06-09 15:04:46' where traUID = 5019758967274670 and traStatus='V' and traEnabled=1 09/06/2024 15:46:35.6356 507 ms. EXEC: update abbCards set carLastDate = '2024-06-09 15:46:35',carLastDirection='O' where carStatus='V' and carId = 13 09/06/2024 16:01:14.9115 821 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 = '454505404500327005012999' and traStatus='V' and casStatus='V' and terType=3 and casTotAmount>0 09/06/2024 16:01:54.9771 703 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 09/06/2024 16:02:15.2173 4743 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 09/06/2024 16:03:53.9375 37558 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 09/06/2024 16:04:28.3750 34350 ms. OPEN: select * from tabArea where areStatus='V' and areEnabled = 1 AND areId = 1 09/06/2024 16:04:42.6257 4670 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 2 09/06/2024 16:05:25.4218 4324 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 2 (WAIT TIME 28 ms.) 09/06/2024 16:05:30.1610 4399 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 5 (WAIT TIME 31 ms.) 09/06/2024 16:05:34.9633 4351 ms. EXEC: update payReceipt set recCreation = '2024-06-09 16:05:30',recModify = '2024-06-09 16:05:30',recUseId=0,recStatus='V' where recId = 270551 (WAIT TIME 64 ms.) 09/06/2024 16:05:44.4908 4433 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 1 OR lnsTerId=1) (WAIT TIME 92 ms.) 09/06/2024 16:05:53.9472 4362 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 61 ms.) 09/06/2024 16:06:27.2079 4433 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 1 (WAIT TIME 45 ms.) 09/06/2024 16:06:41.4166 4464 ms. OPEN: select * from tabArea where areStatus='V' and areEnabled = 1 AND areId = 1 09/06/2024 16:06:46.1648 4415 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 1 OR lnsTerId=1) 09/06/2024 16:07:28.9960 4385 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 09/06/2024 16:07:33.6291 4454 ms. EXEC: update tabTerminalReceipt set trcProgressive = 8358, trcLastPrinted = '2400408358', trcLastDate = '2024-06-09 16:07:29' where trcStatus='V' and trcTerId = 4 09/06/2024 16:08:23.5141 1193 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 2 09/06/2024 16:08:23.5151 1027 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 09/06/2024 16:09:00.2851 3054 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 09/06/2024 16:10:00.7463 1113 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 3 09/06/2024 16:10:31.3491 2307 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 09/06/2024 16:11:11.0241 3991 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 09/06/2024 16:11:11.0602 3984 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 1 09/06/2024 16:11:25.2738 2484 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 09/06/2024 16:11:30.0271 2714 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 09/06/2024 16:12:11.7815 4692 ms. EXECSCALAR: select count(*) from tabTerminalExtraMem where extStatus='V' and extTerId = @extTerId nr: 1 09/06/2024 16:12:40.5821 9411 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 3 (WAIT TIME 9410 ms.) 09/06/2024 16:13:34.0776 4496 ms. EXEC: UPDATE payInventory SET invType='N' WHERE invType<>'N' AND invValue IN (100,200,500) AND invDevice IN (42102,42101,42001); 09/06/2024 16:14:28.9809 22407 ms. OPEN: show columns from tabParameters where Field = 'parUseCulture' 09/06/2024 16:14:34.6498 4844 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 1 and terStatus='V' 09/06/2024 16:14:36.1768 1159 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 09/06/2024 16:14:41.7676 5454 ms. OPEN: show columns from tabParameters where Field = 'parUseCulture' 09/06/2024 16:16:50.3392 936 ms. OPEN: select * from movtransit where tracode=@TRACODE and trastatus='V' and traenabled=1 order by traDateTime desc limit 1 09/06/2024 16:17:16.1328 904 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 09/06/2024 16:17:35.4339 4575 ms. OPEN: select * from movtransit where trastatus='V' and traCode = '454505804900327005012999' order by traId desc limit 1 09/06/2024 16:17:39.0384 3603 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 = '454505804900327005012999' and traStatus='V' and casStatus='V' and terType=3 and casTotAmount>0 09/06/2024 16:18:16.9942 4560 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 4 OR lnsTerId=4) 09/06/2024 16:18:55.1032 4414 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 09/06/2024 16:19:04.5266 4741 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 5 and terStatus='V' 09/06/2024 16:19:30.6223 4401 ms. EXECSCALAR: select count(0) as vTot from tabParameters where parPlateReading<>0 nr: 0 09/06/2024 16:19:30.6694 4450 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 5 09/06/2024 16:20:03.8750 9430 ms. EXECSCALAR: select claId from tabClass where claPosition = 2 and claStatus='V' nr: 2 09/06/2024 16:20:03.9380 4750 ms. OPEN: select * from tabArea where areStatus='V' and areEnabled = 1 AND areId = 1 09/06/2024 16:20:08.6222 4689 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 09/06/2024 16:20:08.6512 4705 ms. EXECSCALAR: select count(resId) as Tot from movReservation where resStatus = 'V' and resTypeRes = 'B' AND ((resConfirmed IN (0,2,3) AND resCreation>'2024-06-09 15:20:03') OR resConfirmed IN (4,5)) and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) <= '2024-06-09 16:19:59' and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) >= '2024-06-09 16:19:59' and (resAreId = 1 or resAreId <= 0) nr: 0 09/06/2024 16:20:08.8193 4738 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 (WAIT TIME 137 ms.) 09/06/2024 16:20:26.3183 624 ms. OPEN: SELECT * FROM movLinks INNER JOIN movTransit on traUID = mliTraUID WHERE mliRFIDCode = '454505880500327005031999' AND mliStatus='V' ORDER BY mliId DESC LIMIT 1 09/06/2024 16:23:13.6352 60091 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 (WAIT TIME 555 ms.) 09/06/2024 16:26:22.9471 3886 ms. OPEN: show columns from tabParameters where Field = 'parAllowNegativePlaces' 09/06/2024 16:26:30.6974 4770 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 51 ms.) 09/06/2024 16:26:35.0654 2961 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 5 (WAIT TIME 325 ms.) 09/06/2024 16:26:44.4027 3997 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 (WAIT TIME 20 ms.)