09/04/2024 08:56:57.9787   546 ms.           EXEC: insert into payReport (repCreation,repNumber,repPayUID) VALUES
('2024-04-09 08:56:56',2024200108,5325177397042620),
('2024-04-09 08:56:56',2024200108,4651215843807820),
('2024-04-09 08:56:56',2024200108,4840397864377550),
('2024-04-09 08:56:56',2024200108,4948857809003050),
('2024-04-09 08:56:56',2024200108,5497507597684450),
('2024-04-09 08:56:56',2024200108,4720707550447630),
('2024-04-09 08:56:56',2024200108,5366548677461390),
('2024-04-09 08:56:56',2024200108,5512861574763520),
('2024-04-09 08:56:56',2024200108,5483558370782070),
('2024-04-09 08:56:56',2024200108,5684065482865920),
('2024-04-09 08:56:56',2024200108,5550750312018770),
('2024-04-09 08:56:56',2024200108,4985016096122530),
('2024-04-09 08:56:56',2024200108,5342217382708450),
('2024-04-09 08:56:56',2024200108,5352168313007340),
('2024-04-09 08:56:56',2024200108,5568248723739150),
('2024-04-09 08:56:56',2024200108,5028217584497250),
('2024-04-09 08:56:56',2024200108,5280498967967400),
('2024-04-09 08:56:56',2024200108,4666603957269940),
('2024-04-09 08:56:56',2024200108,5528821740239590),
('2024-04-09 08:56:56',2024200108,5154442016670450),
('2024-04-09 08:56:56',2024200108,5069292954780950),
('2024-04-09 08:56:56',2024200108,5235274594771920),
('2024-04-09 08:56:56',2024200108,4649448055512260),
('2024-04-09 08:56:56',2024200108,5749463908478340),
('2024-04-09 08:56:56',2024200108,4734178793134350),
('2024-04-09 08:56:56',2024200108,5050281696315230),
('2024-04-09 08:56:56',2024200108,5718534056563850),
('2024-04-09 08:56:56',2024200108,5670819801302260),
('2024-04-09 08:56:56',2024200108,5284186496668530),
('2024-04-09 08:56:56',2024200108,4861927527849410),
('2024-04-09 08:56:56',2024200108,4881446019503800),
('2024-04-09 08:56:56',2024200108,4951617962079860),
('2024-04-09 08:56:56',2024200108,4850856286597520),
('2024-04-09 08:56:56',2024200108,5029646368316260),
('2024-04-09 08:56:56',2024200108,5475738111192810),
('2024-04-09 08:56:56',2024200108,4759931927784160),
('2024-04-09 08:56:56',2024200108,5375820690802360),
('2024-04-09 08:56:56',2024200108,4676256951431230),
('2024-04-09 08:56:56',2024200108,5677311469362240),
('2024-04-09 08:56:56',2024200108,4681238819713780),
('2024-04-09 08:56:56',2024200108,5134360945623870),
('2024-04-09 08:56:56',2024200108,4962316442820210),
('2024-04-09 08:56:56',2024200108,5036327319457150),
('2024-04-09 08:56:56',2024200108,5435791389362650),
('2024-04-09 08:56:56',2024200108,5302999025537740),
('2024-04-09 08:56:56',2024200108,5118997605362540),
('2024-04-09 08:56:56',2024200108,5279497376499420),
('2024-04-09 08:56:56',2024200108,4863869406084450),
('2024-04-09 08:56:56',2024200108,4927459733985940),
('2024-04-09 08:56:56',2024200108,5268198711992880),
('2024-04-09 08:56:56',2024200108,5301314705165550),
('2024-04-09 08:56:56',2024200108,5383722239543130),
('2024-04-09 08:56:56',2024200108,4886444499630870),
('2024-04-09 08:56:56',2024200108,5149031290813190),
('2024-04-09 08:56:56',2024200108,4835600673870960),
('2024-04-09 08:56:56',2024200108,4964397384298430),
('2024-04-09 08:56:56',2024200108,5151906884152280),
('2024-04-09 08:56:56',2024200108,5062585481092710),
('2024-04-09 08:56:56',2024200108,4661573334410380),
('2024-04-09 08:56:56',2024200108,5385364575617190),
('2024-04-09 08:56:56',2024200108,5441507427210460),
('2024-04-09 08:56:56',2024200108,5517263996843230),
('2024-04-09 08:56:56',2024200108,5424171253827560),
('2024-04-09 08:56:56',2024200108,5549828030361830),
('2024-04-09 08:56:56',2024200108,5642342296447910),
('2024-04-09 08:56:56',2024200108,5264611903857290),
('2024-04-09 08:56:56',2024200108,5029777184465340),
('2024-04-09 08:56:56',2024200108,4917709689890780),
('2024-04-09 08:56:56',2024200108,5028245307684760),
('2024-04-09 08:56:56',2024200108,5312253699418640),
('2024-04-09 08:56:56',2024200108,5591626871559380),
('2024-04-09 08:56:56',2024200108,5513796660503120),
('2024-04-09 08:56:56',2024200108,5174097782332980),
('2024-04-09 08:56:56',2024200108,5308727454447700),
('2024-04-09 08:56:56',2024200108,5386713347559260),
('2024-04-09 08:56:56',2024200108,5717287090351610),
('2024-04-09 08:56:56',2024200108,5250940301799130),
('2024-04-09 08:56:56',2024200108,5455979081557710),
('2024-04-09 08:56:56',2024200108,5640818885939890),
('2024-04-09 08:56:56',2024200108,5375420080449920),
('2024-04-09 08:56:56',2024200108,5551851061459000),
('2024-04-09 08:56:56',2024200108,4614281814941650),
('2024-04-09 08:56:56',2024200108,5529831009740360),
('2024-04-09 08:56:56',2024200108,5339874212942920),
('2024-04-09 08:56:56',2024200108,5029833347218180),
('2024-04-09 08:56:56',2024200108,4833456377795560),
('2024-04-09 08:56:56',2024200108,5684181667343140),
('2024-04-09 08:56:56',2024200108,5617089347718480),
('2024-04-09 08:56:56',2024200108,4650744624004200),
('2024-04-09 08:56:56',2024200108,5147943721188100),
('2024-04-09 08:56:56',2024200108,5071695959475810),
('2024-04-09 08:56:56',2024200108,5092708961140410),
('2024-04-09 08:56:56',2024200108,4792890848435750),
('2024-04-09 08:56:56',2024200108,4787315305525650),
('2024-04-09 08:56:56',2024200108,4863260213930070),
('2024-04-09 08:56:56',2024200108,5042303550494950),
('2024-04-09 08:56:56',2024200108,4873529994856800),
('2024-04-09 08:56:56',2024200108,5522433021272260),
('2024-04-09 08:56:56',2024200108,4883138570518200);

09/04/2024 13:50:14.6090   921 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