05/05/2025 02:54:55.6561 4735 ms. EXECSCALAR: select count(0) as vTot from tabParameters where parPlateReading<>0 nr: 0 05/05/2025 04:31:15.5219 2246 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 5 05/05/2025 04:31:20.2711 1092 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 2 OR lnsTerId=2) 05/05/2025 05:56:13.4272 1139 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 3 05/05/2025 06:01:54.9121 4746 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 1 05/05/2025 06:25:26.1586 2186 ms. OPEN: select traId,traDateTime,traEnabled,traDisableTime,traCode,traBadge,traCarId,traAreId,traIdTerminal from movtransit where traStatus='V' and traDirection = 'I' and traCarId = 26 order by traDateTime desc,traId desc 05/05/2025 06:33:13.9987 583 ms. OPEN: select traId,traDateTime,traEnabled,traDisableTime,traCode,traBadge,traCarId,traAreId,traIdTerminal from movtransit where traStatus='V' and traDirection = 'I' and traCarId = 163 order by traDateTime desc,traId desc 05/05/2025 06:59:53.3003 4743 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 05/05/2025 06:59:55.8130 2482 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,'2025-05-05 06:59:53','V',5668493613493740,2025,'2025-05-05 06:59:48','457802518800327005012999',1,2,16,'I','',1,0,1,'','',4) 05/05/2025 07:09:08.2027 2782 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 05/05/2025 07:22:39.8054 4768 ms. OPEN: select * from tabArea where areStatus='V' and areEnabled = 1 AND areId = 1 05/05/2025 07:26:21.2173 2840 ms. OPEN: select * from tabArea where areStatus='V' and areEnabled = 1 AND areId = 1 05/05/2025 07:28:09.3727 630 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 1 OR lnsTerId=1) 05/05/2025 07:38:19.3037 6467 ms. OPEN: select 1 as Tot,payUID,payPayed,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 = 9 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)) order by traUIDGroup,payAmount, traType, traDiscountValue, traDiscountType 05/05/2025 07:42:30.3948 4743 ms. OPEN: select * from tabUserMessage where useMesDescr = 'msg_payed' and (useLanCode = 'en-US' or mid(useLanCode,1,2) = 'en') 05/05/2025 07:45:19.5205 4736 ms. OPEN: select * from tabArea where areStatus='V' and areEnabled = 1 AND areId = 1 05/05/2025 07:46:25.8169 4699 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,'2025-05-05 07:46:21','V',4695478070612470,2025,'2025-05-05 07:45:57','457802549400327005012999',2,2,2,'O','',0,'2025-05-05 07:46:21',1,'','',0) 05/05/2025 07:46:25.8229 4674 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 1 and terStatus='V' 05/05/2025 07:46:55.2016 3271 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 4 05/05/2025 07:51:36.7564 868 ms. OPEN: select traId,traDateTime,traEnabled,traDisableTime,traCode,traBadge,traCarId,traAreId,traIdTerminal from movtransit where traStatus='V' and traDirection = 'I' and traCarId = 31 order by traDateTime desc,traId desc 05/05/2025 07:55:41.2077 4698 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 1 OR lnsTerId=1) 05/05/2025 07:55:41.2608 4761 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 2 OR lnsTerId=2) 05/05/2025 07:56:28.7075 4580 ms. EXEC: INSERT INTO movOperator (opeCreation,opeUseId,opeTerId,opeDateTime,opeCode,opeDescription) VALUES ('2025-05-05 07:56:24',0,3,'2025-05-05 07:56:24','0230003944086','POF - User Transit Supervisor Supervisor') 05/05/2025 07:57:28.7287 1408 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 05/05/2025 07:59:29.2114 4725 ms. OPEN: select traId,traDateTime,traEnabled,traDisableTime,traCode,traBadge,traCarId,traAreId,traIdTerminal from movtransit where traStatus='V' and traDirection = 'I' and traCarId = 156 order by traDateTime desc,traId desc 05/05/2025 07:59:33.9575 4662 ms. OPEN: select * from payreceipt where recPayUID = 4723154129144520 and recStatus='V' 05/05/2025 07:59:38.7097 4651 ms. OPEN: select * from movTransit where traStatus = 'V' and traBadge = '0230003939767' order by traId desc limit 1 05/05/2025 07:59:38.8328 9534 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 05/05/2025 07:59:43.4669 4690 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 05/05/2025 07:59:48.2161 4671 ms. OPEN: select * from tabTerminal where terId = 16 05/05/2025 07:59:57.7074 4677 ms. EXEC: INSERT INTO movOperator (opeCreation,opeUseId,opeTerId,opeDateTime,opeCode,opeDescription) VALUES ('2025-05-05 07:59:53',0,16,'2025-05-05 07:59:53','','Unauthorized Transit Entry 2') 05/05/2025 08:00:01.3349 13075 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 05/05/2025 08:00:02.4586 834 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 4 05/05/2025 08:00:02.5207 1133 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 05/05/2025 08:00:11.9770 3108 ms. EXECSCALAR: select count(resId) as Tot from movReservation where resStatus = 'V' and resTypeRes = 'B' AND ((resConfirmed IN (0,2,3) AND resCreation>'2025-05-05 07:00:08') OR resConfirmed IN (4,5)) and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) <= '2025-05-05 08:00:08' and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) >= '2025-05-05 08:00:08' and (resAreId = 1 or resAreId <= 0) nr: 0 05/05/2025 08:00:40.4731 1511 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 5 and terStatus='V' 05/05/2025 08:01:26.4108 2807 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 05/05/2025 08:02:51.3316 4692 ms. OPEN: SELECT * FROM tabCardConversionRules WHERE ccrStatus=@ccrStatus AND (ccrTerId = @ccrTerId OR ccrTerId=0) AND (ccrDevId = @ccrDevId OR ccrDevId=0) AND (ccrSubId = @ccrSubId OR ccrSubId=0) ORDER BY ccrTerId DESC, ccrDevId DESC, ccrSubId DESC, ccrId DESC LIMIT 1 05/05/2025 08:03:24.3628 3160 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 05/05/2025 08:05:05.6776 4432 ms. EXEC: insert into payCurInventory (curTerId,curDevCode,curDevDescription,curChannelId,curChannelDescr,curValue,curType) SELECT * FROM (SELECT 3,41101,'Coin Hopper 1',2 as c1,'Cashbox',20 as v2,'C') as tmp WHERE NOT EXISTS ( SELECT curDevCode,curTerId,curChannelId,curValue FROM payCurInventory WHERE curDevCode = 41101 and curChannelId = 2 and curTerId = 3 and curValue = 20 and curType = 'C' LIMIT 1) 05/05/2025 08:05:10.4328 4655 ms. OPEN: select traId,traDateTime,traEnabled,traDisableTime,traCode,traBadge,traCarId,traAreId,traIdTerminal from movtransit where traStatus='V' and traDirection = 'I' and traCarId = 186 order by traDateTime desc,traId desc 05/05/2025 08:05:48.4912 4672 ms. OPEN: select * from payreceipt where recPayUID = 4634150632505890 and recStatus='V' (WAIT TIME 64 ms.) 05/05/2025 08:06:02.6767 4720 ms. OPEN: select * from movTransit where traStatus = 'V' and traBadge = '0230003950863' order by traId desc limit 1 05/05/2025 08:06:07.4269 4744 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,'2025-05-05 08:06:02','V',4879286081904110,2025,'2025-05-05 08:05:38','457802913800327005012999',1,2,16,'I','',1,0,1,'','0230003950863',158,0) 05/05/2025 08:06:12.1771 4726 ms. EXEC: update abbCards set carLastDate = '2025-05-05 08:06:07',carLastDirection='I' where carStatus='V' and carId = 158 05/05/2025 08:06:16.9903 4742 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 5 and terStatus='V' 05/05/2025 08:06:17.0013 9517 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 1 and terStatus='V' 05/05/2025 08:06:21.6774 4696 ms. EXEC: INSERT INTO movOperator (opeCreation,opeUseId,opeTerId,opeDateTime,opeCode,opeDescription) VALUES ('2025-05-05 08:06:16',0,16,'2025-05-05 08:06:16','','Unauthorized Transit Entry 2') 05/05/2025 08:16:38.5375 3849 ms. EXECSCALAR: SELECT traId FROM movTransit WHERE traCode = '457802979400327005012999' and traDirection='I' order by traId DESC LIMIT 1 nr: 920751 05/05/2025 08:17:02.2864 4676 ms. OPEN: select * from movtransit where trastatus='V' and (traCode = '457802608400327005012999') and traDirection='I' order by traId desc limit 1 05/05/2025 08:17:07.0376 4703 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 16 OR lnsTerId=16) 05/05/2025 08:18:25.9104 2943 ms. OPEN: select * from tabArea where areStatus='V' and areEnabled = 1 AND areId = 1 05/05/2025 08:18:27.6396 859 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 05/05/2025 08:18:35.4448 4714 ms. OPEN: select traCode from movTransit where traCode ='457802990600327005012999' 05/05/2025 08:18:40.1659 4716 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,'2025-05-05 08:18:35','V',4801697585550220,2025,'2025-05-05 08:18:26','457802990600327005012999',1,2,16,'I','',1,0,1,'','0230003957466',21,0) 05/05/2025 08:18:54.3975 4590 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 16 OR lnsTerId=16) 05/05/2025 08:47:23.4527 4738 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 05/05/2025 08:49:48.4577 1591 ms. OPEN: select * from tabTerminal where terId = 16 05/05/2025 09:31:53.8219 2587 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 = 12 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 05/05/2025 09:54:19.3616 570 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 05/05/2025 10:12:48.1598 1043 ms. EXECSCALAR: SELECT count(*) FROM payinventory WHERE invValue<>0 AND invType='' nr: 0 05/05/2025 10:12:49.1026 940 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 05/05/2025 10:18:31.9744 5541 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/05/2025 10:18:41.4748 2418 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/05/2025 10:19:14.7240 3787 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 3 OR lnsTerId=3) 05/05/2025 10:21:25.8240 4786 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/05/2025 10:21:59.9579 3395 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 1 05/05/2025 10:22:24.0210 4684 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,'2025-05-05 10:22:19','V',4795280347285740,2025,'2025-05-05 10:22:13','457803648200327005012999',2,2,2,'O','',0,'2025-05-05 10:22:19',1,'','',0) 05/05/2025 10:24:00.5342 4820 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/05/2025 10:24:05.2204 4680 ms. OPEN: select * from tabArea where areStatus='V' and areEnabled = 1 AND areId = 1 05/05/2025 10:24:24.2651 4520 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 05/05/2025 10:24:28.9603 2430 ms. EXECSCALAR: select count(0) as vTot from tabParameters where parPlateReading<>0 nr: 0 05/05/2025 10:24:47.9780 3608 ms. EXECSCALAR: select count(0) as vTot from tabParameters where parPlateReading<>0 nr: 0 05/05/2025 10:25:55.1553 4068 ms. OPEN: select * from payreceipt where recPayUID = 5762882476109840 and recStatus='V' 05/05/2025 10:31:24.9367 4196 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 05/05/2025 10:31:29.6298 4680 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 05/05/2025 10:31:39.2182 9435 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,'2025-05-05 10:31:29','V',4963899095771870,2025,'2025-05-05 10:31:19','457803787900327005012999',1,2,16,'I','',1,0,1,'','',4) 05/05/2025 10:31:43.8824 4488 ms. EXECSCALAR: SELECT traId FROM movTransit WHERE traStatus='V' AND traCode = @traCode nr: 920840 05/05/2025 10:31:43.9224 4545 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 05/05/2025 10:35:47.6560 4743 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,'2025-05-05 10:35:42','V',5628193070775890,2025,'2025-05-05 10:35:37','457803813700327005012999',1,2,16,'I','',1,0,1,'','',4) 05/05/2025 10:36:11.3498 4667 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,'2025-05-05 10:36:06','V',5350057960371360,2025,'2025-05-05 10:35:49','457803814900327005031999',1,2,16,'I','',1,0,1,'','',4) 05/05/2025 10:40:07.5578 1133 ms. OPEN: select * from tabArea where areStatus='V' and areEnabled = 1 AND areId = 1 05/05/2025 10:43:06.4754 20184 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2025-05-05 10:42:46' where traUID = 4925604762943770 and traStatus='V' and traEnabled=1 05/05/2025 10:44:52.9665 617 ms. OPEN: select traId,traDateTime,traEnabled,traDisableTime,traCode,traBadge,traCarId,traAreId,traIdTerminal from movtransit where traStatus='V' and traDirection = 'I' and traCarId = 99 order by traDateTime desc,traId desc 05/05/2025 12:03:29.6464 502 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,'2025-05-05 12:03:29','V',4850789513078160,2025,'2025-05-05 12:03:28','457804271400327005012999',2,2,2,'O','',0,'2025-05-05 12:03:29',1,'','',0) 05/05/2025 12:24:29.5322 4742 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/05/2025 12:24:58.0983 4752 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 05/05/2025 12:26:50.1283 5626 ms. OPEN: select * from movTransit where traStatus='V' and traEnabled = 1 and traCode = '457804324500327005012999' 05/05/2025 12:26:56.9299 6799 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2025-05-05 12:26:44' where payTraUID = 4988883563100680 and payStatus='V' and payEnabled=1 05/05/2025 13:50:57.5893 543 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 05/05/2025 14:43:15.0866 533 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2025-05-05 14:43:14' where traUID = 4959042533171910 and traStatus='V' and traEnabled=1 05/05/2025 15:12:14.1254 653 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,'2025-05-05 15:12:13','V',5760760308512830,2025,'2025-05-05 15:12:13','457805473300327005012999',1,2,16,'I','',1,0,1,'','',4) 05/05/2025 21:04:51.4798 1567 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