Symfony Profiler

SELECT
  DISTINCT s0_.id AS id_0,
  s0_.type AS type_1,
  s0_.title AS title_2,
  s0_.startDate AS startDate_3,
  s0_.endDate AS endDate_4,
  s0_.recoveryAt AS recoveryAt_5,
  s0_.description AS description_6,
  s0_.status AS status_7,
  s0_.bidIncrement AS bidIncrement_8,
  s0_.vatRate AS vatRate_9,
  s0_.dynamicClosing AS dynamicClosing_10,
  s0_.extraTime AS extraTime_11,
  s0_.salingType AS salingType_12,
  s0_.publicationDate AS publicationDate_13,
  s0_.expositionStartDate AS expositionStartDate_14,
  s0_.expositionEndDate AS expositionEndDate_15,
  s0_.dayExpositionTime AS dayExpositionTime_16,
  s0_.createdAt AS createdAt_17,
  s0_.updatedAt AS updatedAt_18,
  s0_.hours AS hours_19,
  s0_.bannerUrl AS bannerUrl_20,
  s0_.logoUrl AS logoUrl_21,
  s0_.company AS company_22,
  s0_.stock AS stock_23,
  s0_.public AS public_24,
  s0_.displayExplodedView AS displayExplodedView_25,
  s0_.displayReconditioningFees AS displayReconditioningFees_26,
  s0_.isLive AS isLive_27,
  s0_.noVehicles AS noVehicles_28,
  s0_.liveVisitors AS liveVisitors_29,
  s0_.afterSaleDuration AS afterSaleDuration_30,
  s0_.exclusive AS exclusive_31,
  s0_.prepared AS prepared_32,
  s0_.fixedFees AS fixedFees_33,
  s0_.closedAt AS closedAt_34,
  s0_.country AS country_35,
  s0_.iridiumId AS iridiumId_36,
  e1_.provider AS provider_37,
  e1_.providerId AS providerId_38,
  e1_.providerType AS providerType_39,
  e1_.tracked AS tracked_40,
  e1_.importStatus AS importStatus_41,
  e1_.endOfSaleProcessed AS endOfSaleProcessed_42,
  e1_.originalTitle AS originalTitle_43,
  s0_.discr AS discr_44,
  s0_.room_id AS room_id_45,
  s0_.vehicle_opened_id AS vehicle_opened_id_46,
  s0_.last_opened_vehicle_id AS last_opened_vehicle_id_47
FROM
  sale s0_
  LEFT JOIN external_sale e1_ ON s0_.id = e1_.id
WHERE
  s0_.endDate > ?
ORDER BY
  s0_.startDate ASC
LIMIT
  1

SELECT DISTINCT s0_.id AS id_0, s0_.type AS type_1, s0_.title AS title_2, s0_.startDate AS startDate_3, s0_.endDate AS endDate_4, s0_.recoveryAt AS recoveryAt_5, s0_.description AS description_6, s0_.status AS status_7, s0_.bidIncrement AS bidIncrement_8, s0_.vatRate AS vatRate_9, s0_.dynamicClosing AS dynamicClosing_10, s0_.extraTime AS extraTime_11, s0_.salingType AS salingType_12, s0_.publicationDate AS publicationDate_13, s0_.expositionStartDate AS expositionStartDate_14, s0_.expositionEndDate AS expositionEndDate_15, s0_.dayExpositionTime AS dayExpositionTime_16, s0_.createdAt AS createdAt_17, s0_.updatedAt AS updatedAt_18, s0_.hours AS hours_19, s0_.bannerUrl AS bannerUrl_20, s0_.logoUrl AS logoUrl_21, s0_.company AS company_22, s0_.stock AS stock_23, s0_.public AS public_24, s0_.displayExplodedView AS displayExplodedView_25, s0_.displayReconditioningFees AS displayReconditioningFees_26, s0_.isLive AS isLive_27, s0_.noVehicles AS noVehicles_28, s0_.liveVisitors AS liveVisitors_29, s0_.afterSaleDuration AS afterSaleDuration_30, s0_.exclusive AS exclusive_31, s0_.prepared AS prepared_32, s0_.fixedFees AS fixedFees_33, s0_.closedAt AS closedAt_34, s0_.country AS country_35, s0_.iridiumId AS iridiumId_36, e1_.provider AS provider_37, e1_.providerId AS providerId_38, e1_.providerType AS providerType_39, e1_.tracked AS tracked_40, e1_.importStatus AS importStatus_41, e1_.endOfSaleProcessed AS endOfSaleProcessed_42, e1_.originalTitle AS originalTitle_43, s0_.discr AS discr_44, s0_.room_id AS room_id_45, s0_.vehicle_opened_id AS vehicle_opened_id_46, s0_.last_opened_vehicle_id AS last_opened_vehicle_id_47 FROM sale s0_ LEFT JOIN external_sale e1_ ON s0_.id = e1_.id WHERE s0_.endDate > '2025-01-10 15:09:21' ORDER BY s0_.startDate ASC LIMIT 1;

SELECT
  DISTINCT s0_.id AS id_0,
  s0_.type AS type_1,
  s0_.title AS title_2,
  s0_.startDate AS startDate_3,
  s0_.endDate AS endDate_4,
  s0_.recoveryAt AS recoveryAt_5,
  s0_.description AS description_6,
  s0_.status AS status_7,
  s0_.bidIncrement AS bidIncrement_8,
  s0_.vatRate AS vatRate_9,
  s0_.dynamicClosing AS dynamicClosing_10,
  s0_.extraTime AS extraTime_11,
  s0_.salingType AS salingType_12,
  s0_.publicationDate AS publicationDate_13,
  s0_.expositionStartDate AS expositionStartDate_14,
  s0_.expositionEndDate AS expositionEndDate_15,
  s0_.dayExpositionTime AS dayExpositionTime_16,
  s0_.createdAt AS createdAt_17,
  s0_.updatedAt AS updatedAt_18,
  s0_.hours AS hours_19,
  s0_.bannerUrl AS bannerUrl_20,
  s0_.logoUrl AS logoUrl_21,
  s0_.company AS company_22,
  s0_.stock AS stock_23,
  s0_.public AS public_24,
  s0_.displayExplodedView AS displayExplodedView_25,
  s0_.displayReconditioningFees AS displayReconditioningFees_26,
  s0_.isLive AS isLive_27,
  s0_.noVehicles AS noVehicles_28,
  s0_.liveVisitors AS liveVisitors_29,
  s0_.afterSaleDuration AS afterSaleDuration_30,
  s0_.exclusive AS exclusive_31,
  s0_.prepared AS prepared_32,
  s0_.fixedFees AS fixedFees_33,
  s0_.closedAt AS closedAt_34,
  s0_.country AS country_35,
  s0_.iridiumId AS iridiumId_36,
  e1_.provider AS provider_37,
  e1_.providerId AS providerId_38,
  e1_.providerType AS providerType_39,
  e1_.tracked AS tracked_40,
  e1_.importStatus AS importStatus_41,
  e1_.endOfSaleProcessed AS endOfSaleProcessed_42,
  e1_.originalTitle AS originalTitle_43,
  s0_.discr AS discr_44,
  s0_.room_id AS room_id_45,
  s0_.vehicle_opened_id AS vehicle_opened_id_46,
  s0_.last_opened_vehicle_id AS last_opened_vehicle_id_47
FROM
  sale s0_
  LEFT JOIN external_sale e1_ ON s0_.id = e1_.id
  INNER JOIN sale_event s2_ ON s0_.id = s2_.sale_id
WHERE
  s0_.type IN (?, ?)
  AND s0_.isLive = 1
  AND s0_.endDate > ?
  AND s0_.status <> ?
ORDER BY
  s0_.startDate ASC,
  s2_.startTime ASC
LIMIT
  1

SELECT DISTINCT s0_.id AS id_0, s0_.type AS type_1, s0_.title AS title_2, s0_.startDate AS startDate_3, s0_.endDate AS endDate_4, s0_.recoveryAt AS recoveryAt_5, s0_.description AS description_6, s0_.status AS status_7, s0_.bidIncrement AS bidIncrement_8, s0_.vatRate AS vatRate_9, s0_.dynamicClosing AS dynamicClosing_10, s0_.extraTime AS extraTime_11, s0_.salingType AS salingType_12, s0_.publicationDate AS publicationDate_13, s0_.expositionStartDate AS expositionStartDate_14, s0_.expositionEndDate AS expositionEndDate_15, s0_.dayExpositionTime AS dayExpositionTime_16, s0_.createdAt AS createdAt_17, s0_.updatedAt AS updatedAt_18, s0_.hours AS hours_19, s0_.bannerUrl AS bannerUrl_20, s0_.logoUrl AS logoUrl_21, s0_.company AS company_22, s0_.stock AS stock_23, s0_.public AS public_24, s0_.displayExplodedView AS displayExplodedView_25, s0_.displayReconditioningFees AS displayReconditioningFees_26, s0_.isLive AS isLive_27, s0_.noVehicles AS noVehicles_28, s0_.liveVisitors AS liveVisitors_29, s0_.afterSaleDuration AS afterSaleDuration_30, s0_.exclusive AS exclusive_31, s0_.prepared AS prepared_32, s0_.fixedFees AS fixedFees_33, s0_.closedAt AS closedAt_34, s0_.country AS country_35, s0_.iridiumId AS iridiumId_36, e1_.provider AS provider_37, e1_.providerId AS providerId_38, e1_.providerType AS providerType_39, e1_.tracked AS tracked_40, e1_.importStatus AS importStatus_41, e1_.endOfSaleProcessed AS endOfSaleProcessed_42, e1_.originalTitle AS originalTitle_43, s0_.discr AS discr_44, s0_.room_id AS room_id_45, s0_.vehicle_opened_id AS vehicle_opened_id_46, s0_.last_opened_vehicle_id AS last_opened_vehicle_id_47 FROM sale s0_ LEFT JOIN external_sale e1_ ON s0_.id = e1_.id INNER JOIN sale_event s2_ ON s0_.id = s2_.sale_id WHERE s0_.type IN ('Physique', 'Live') AND s0_.isLive = 1 AND s0_.endDate > '2025-01-10 15:09:21' AND s0_.status <> 'Fermée' ORDER BY s0_.startDate ASC, s2_.startTime ASC LIMIT 1;

SELECT
  DISTINCT s0_.id AS id_0,
  s0_.type AS type_1,
  s0_.title AS title_2,
  s0_.startDate AS startDate_3,
  s0_.endDate AS endDate_4,
  s0_.recoveryAt AS recoveryAt_5,
  s0_.description AS description_6,
  s0_.status AS status_7,
  s0_.bidIncrement AS bidIncrement_8,
  s0_.vatRate AS vatRate_9,
  s0_.dynamicClosing AS dynamicClosing_10,
  s0_.extraTime AS extraTime_11,
  s0_.salingType AS salingType_12,
  s0_.publicationDate AS publicationDate_13,
  s0_.expositionStartDate AS expositionStartDate_14,
  s0_.expositionEndDate AS expositionEndDate_15,
  s0_.dayExpositionTime AS dayExpositionTime_16,
  s0_.createdAt AS createdAt_17,
  s0_.updatedAt AS updatedAt_18,
  s0_.hours AS hours_19,
  s0_.bannerUrl AS bannerUrl_20,
  s0_.logoUrl AS logoUrl_21,
  s0_.company AS company_22,
  s0_.stock AS stock_23,
  s0_.public AS public_24,
  s0_.displayExplodedView AS displayExplodedView_25,
  s0_.displayReconditioningFees AS displayReconditioningFees_26,
  s0_.isLive AS isLive_27,
  s0_.noVehicles AS noVehicles_28,
  s0_.liveVisitors AS liveVisitors_29,
  s0_.afterSaleDuration AS afterSaleDuration_30,
  s0_.exclusive AS exclusive_31,
  s0_.prepared AS prepared_32,
  s0_.fixedFees AS fixedFees_33,
  s0_.closedAt AS closedAt_34,
  s0_.country AS country_35,
  s0_.iridiumId AS iridiumId_36,
  e1_.provider AS provider_37,
  e1_.providerId AS providerId_38,
  e1_.providerType AS providerType_39,
  e1_.tracked AS tracked_40,
  e1_.importStatus AS importStatus_41,
  e1_.endOfSaleProcessed AS endOfSaleProcessed_42,
  e1_.originalTitle AS originalTitle_43,
  s0_.discr AS discr_44,
  s0_.room_id AS room_id_45,
  s0_.vehicle_opened_id AS vehicle_opened_id_46,
  s0_.last_opened_vehicle_id AS last_opened_vehicle_id_47
FROM
  sale s0_
  LEFT JOIN external_sale e1_ ON s0_.id = e1_.id
  INNER JOIN sale_event s2_ ON s0_.id = s2_.sale_id
WHERE
  s0_.type IN (?, ?)
  AND s0_.isLive = 1
  AND s0_.startDate LIKE ?
ORDER BY
  s0_.endDate DESC

SELECT DISTINCT s0_.id AS id_0, s0_.type AS type_1, s0_.title AS title_2, s0_.startDate AS startDate_3, s0_.endDate AS endDate_4, s0_.recoveryAt AS recoveryAt_5, s0_.description AS description_6, s0_.status AS status_7, s0_.bidIncrement AS bidIncrement_8, s0_.vatRate AS vatRate_9, s0_.dynamicClosing AS dynamicClosing_10, s0_.extraTime AS extraTime_11, s0_.salingType AS salingType_12, s0_.publicationDate AS publicationDate_13, s0_.expositionStartDate AS expositionStartDate_14, s0_.expositionEndDate AS expositionEndDate_15, s0_.dayExpositionTime AS dayExpositionTime_16, s0_.createdAt AS createdAt_17, s0_.updatedAt AS updatedAt_18, s0_.hours AS hours_19, s0_.bannerUrl AS bannerUrl_20, s0_.logoUrl AS logoUrl_21, s0_.company AS company_22, s0_.stock AS stock_23, s0_.public AS public_24, s0_.displayExplodedView AS displayExplodedView_25, s0_.displayReconditioningFees AS displayReconditioningFees_26, s0_.isLive AS isLive_27, s0_.noVehicles AS noVehicles_28, s0_.liveVisitors AS liveVisitors_29, s0_.afterSaleDuration AS afterSaleDuration_30, s0_.exclusive AS exclusive_31, s0_.prepared AS prepared_32, s0_.fixedFees AS fixedFees_33, s0_.closedAt AS closedAt_34, s0_.country AS country_35, s0_.iridiumId AS iridiumId_36, e1_.provider AS provider_37, e1_.providerId AS providerId_38, e1_.providerType AS providerType_39, e1_.tracked AS tracked_40, e1_.importStatus AS importStatus_41, e1_.endOfSaleProcessed AS endOfSaleProcessed_42, e1_.originalTitle AS originalTitle_43, s0_.discr AS discr_44, s0_.room_id AS room_id_45, s0_.vehicle_opened_id AS vehicle_opened_id_46, s0_.last_opened_vehicle_id AS last_opened_vehicle_id_47 FROM sale s0_ LEFT JOIN external_sale e1_ ON s0_.id = e1_.id INNER JOIN sale_event s2_ ON s0_.id = s2_.sale_id WHERE s0_.type IN ('Physique', 'Live') AND s0_.isLive = 1 AND s0_.startDate LIKE '2025-01-10%' ORDER BY s0_.endDate DESC;

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.image AS image_3,
  t0.link AS link_4,
  t0.type AS type_5
FROM
  news t0
WHERE
  t0.type = ?

SELECT t0.id AS id_1, t0.title AS title_2, t0.image AS image_3, t0.link AS link_4, t0.type AS type_5 FROM news t0 WHERE t0.type = 'B2C';

SELECT
  b0_.id AS id_0,
  b0_.alt AS alt_1,
  b0_.image AS image_2,
  b0_.imageMobile AS imageMobile_3,
  b0_.link AS link_4,
  b0_.type AS type_5,
  b0_.localeId AS localeId_6,
  b0_.priority AS priority_7,
  b0_.startDate AS startDate_8,
  b0_.endDate AS endDate_9,
  CASE WHEN b0_.priority IS NULL THEN 1 ELSE 0 END AS sclr_10
FROM
  banner b0_
WHERE
  b0_.type = ?
  AND b0_.startDate <= ?
  AND b0_.endDate > ?
  AND b0_.localeId = ?
ORDER BY
  sclr_10 ASC,
  b0_.priority ASC,
  b0_.startDate ASC

SELECT b0_.id AS id_0, b0_.alt AS alt_1, b0_.image AS image_2, b0_.imageMobile AS imageMobile_3, b0_.link AS link_4, b0_.type AS type_5, b0_.localeId AS localeId_6, b0_.priority AS priority_7, b0_.startDate AS startDate_8, b0_.endDate AS endDate_9, CASE WHEN b0_.priority IS NULL THEN 1 ELSE 0 END AS sclr_10 FROM banner b0_ WHERE b0_.type = 'B2C' AND b0_.startDate <= '2025-01-10 15:09:21' AND b0_.endDate > '2025-01-10 15:09:21' AND b0_.localeId = 'fr' ORDER BY sclr_10 ASC, b0_.priority ASC, b0_.startDate ASC;

SELECT
  t0.id AS id_1,
  t0.value AS value_2,
  t0.array_value AS array_value_3,
  t0.type AS type_4,
  t0.category AS category_5,
  t0.tooltip AS tooltip_6,
  t0.name AS name_7
FROM
  parameter t0
WHERE
  t0.name = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.value AS value_2, t0.array_value AS array_value_3, t0.type AS type_4, t0.category AS category_5, t0.tooltip AS tooltip_6, t0.name AS name_7 FROM parameter t0 WHERE t0.name = 'home.auctioneer.number_selection' LIMIT 1;

SELECT
  v0_.id AS id_0,
  v0_.vehicleId AS vehicleId_1,
  v0_.photos AS photos_2,
  v0_.lot AS lot_3,
  v0_.lotComplement AS lotComplement_4,
  v0_.isranked AS isranked_5,
  v0_.salingState AS salingState_6,
  v0_.class AS class_7,
  v0_.maker AS maker_8,
  v0_.makerSlug AS makerSlug_9,
  v0_.modelGroup AS modelGroup_10,
  v0_.modelGroupSlug AS modelGroupSlug_11,
  v0_.segment AS segment_12,
  v0_.segmentSlug AS segmentSlug_13,
  v0_.segmentSize AS segmentSize_14,
  v0_.segmentSizeSlug AS segmentSizeSlug_15,
  v0_.segmentBody AS segmentBody_16,
  v0_.model AS model_17,
  v0_.typeCode AS typeCode_18,
  v0_.millesime AS millesime_19,
  v0_.registrationDate AS registrationDate_20,
  v0_.kilometers AS kilometers_21,
  v0_.taxHorsepower AS taxHorsepower_22,
  v0_.bodyType AS bodyType_23,
  v0_.stateDetails AS stateDetails_24,
  v0_.guarantee AS guarantee_25,
  v0_.guaranteed AS guaranteed_26,
  v0_.stateRating AS stateRating_27,
  v0_.afnor AS afnor_28,
  v0_.etincelleId AS etincelleId_29,
  v0_.iridiumId AS iridiumId_30,
  v0_.vat AS vat_31,
  v0_.seatCount AS seatCount_32,
  v0_.observation AS observation_33,
  v0_.motFileUrl AS motFileUrl_34,
  v0_.maintenanceFileUrl AS maintenanceFileUrl_35,
  v0_.roadTestFileUrl AS roadTestFileUrl_36,
  v0_.bilanExpertFileUrl AS bilanExpertFileUrl_37,
  v0_.photo3dExteriorUrl AS photo3dExteriorUrl_38,
  v0_.photo3dExteriorExtraUrl AS photo3dExteriorExtraUrl_39,
  v0_.explodedViewFileUrl AS explodedViewFileUrl_40,
  v0_.dekraUrl AS dekraUrl_41,
  v0_.inspectionReportUrl AS inspectionReportUrl_42,
  v0_.argusPrice AS argusPrice_43,
  v0_.argusTransactionPrice AS argusTransactionPrice_44,
  v0_.argusAnnoncePrice AS argusAnnoncePrice_45,
  v0_.argusDatedPrice AS argusDatedPrice_46,
  v0_.argusKmPrice AS argusKmPrice_47,
  v0_.spotPrice AS spotPrice_48,
  v0_.reconditioningPrice AS reconditioningPrice_49,
  v0_.estimationPrice AS estimationPrice_50,
  v0_.estimationPriceMin AS estimationPriceMin_51,
  v0_.initialReservePrice AS initialReservePrice_52,
  v0_.initialReservePriceHF AS initialReservePriceHF_53,
  v0_.reservePrice AS reservePrice_54,
  v0_.reservePriceHF AS reservePriceHF_55,
  v0_.oldReservePrice AS oldReservePrice_56,
  v0_.oldReservePriceHF AS oldReservePriceHF_57,
  v0_.deltaReservePrice AS deltaReservePrice_58,
  v0_.deltaFees AS deltaFees_59,
  v0_.unusedPrice AS unusedPrice_60,
  v0_.startingPrice AS startingPrice_61,
  v0_.buyoutPrice AS buyoutPrice_62,
  v0_.unsoldPrice AS unsoldPrice_63,
  v0_.unsoldOnlinePrice AS unsoldOnlinePrice_64,
  v0_.lastHammerPrice AS lastHammerPrice_65,
  v0_.finalAmount AS finalAmount_66,
  v0_.unsoldCount AS unsoldCount_67,
  v0_.unsoldOnlineCount AS unsoldOnlineCount_68,
  v0_.broken AS broken_69,
  v0_.duplicateKeys AS duplicateKeys_70,
  v0_.co2 AS co2_71,
  v0_.euroEmissionStandard AS euroEmissionStandard_72,
  v0_.shortModel AS shortModel_73,
  v0_.version AS version_74,
  v0_.length AS length_75,
  v0_.width AS width_76,
  v0_.height AS height_77,
  v0_.tarification AS tarification_78,
  v0_.tarificationType AS tarificationType_79,
  v0_.zipCodeLocation AS zipCodeLocation_80,
  v0_.cityLocation AS cityLocation_81,
  v0_.lotOpen AS lotOpen_82,
  v0_.justOpened AS justOpened_83,
  v0_.nbViews AS nbViews_84,
  v0_.noShipping AS noShipping_85,
  v0_.salesperson AS salesperson_86,
  v0_.etincelleCreatedAt AS etincelleCreatedAt_87,
  v0_.etincelleSalingState AS etincelleSalingState_88,
  v0_.etincelleSalingStateComplement AS etincelleSalingStateComplement_89,
  v0_.urgent AS urgent_90,
  v0_.mandateDate AS mandateDate_91,
  v0_.soldDate AS soldDate_92,
  v0_.registrationPlate AS registrationPlate_93,
  v0_.adjustable AS adjustable_94,
  v0_.emptyWeight AS emptyWeight_95,
  v0_.liftingCapacity AS liftingCapacity_96,
  v0_.liftingHeight AS liftingHeight_97,
  v0_.engineActualHourCount AS engineActualHourCount_98,
  v0_.wheelBase AS wheelBase_99,
  v0_.cylinderCount AS cylinderCount_100,
  v0_.doorCount AS doorCount_101,
  v0_.gearCount AS gearCount_102,
  v0_.driveWheel AS driveWheel_103,
  v0_.loadWeight AS loadWeight_104,
  v0_.horsePower AS horsePower_105,
  v0_.gearbox AS gearbox_106,
  v0_.maintenanceBookState AS maintenanceBookState_107,
  v0_.maintenanceFileState AS maintenanceFileState_108,
  v0_.makerGuarantee AS makerGuarantee_109,
  v0_.makerGuaranteeExpiredAt AS makerGuaranteeExpiredAt_110,
  v0_.makerGuaranteeKilometers AS makerGuaranteeKilometers_111,
  v0_.premiumGuarantee AS premiumGuarantee_112,
  v0_.premiumGuaranteeDescription AS premiumGuaranteeDescription_113,
  v0_.segmentFirst AS segmentFirst_114,
  v0_.firstHand AS firstHand_115,
  v0_.argusOID AS argusOID_116,
  v0_.natCode AS natCode_117,
  v0_.damaged AS damaged_118,
  v0_.sellerObservation AS sellerObservation_119,
  v0_.trainingVehicle AS trainingVehicle_120,
  v0_.taxi AS taxi_121,
  v0_.mechanicallyDamaged AS mechanicallyDamaged_122,
  v0_.innerStateRating AS innerStateRating_123,
  v0_.expertiseRating AS expertiseRating_124,
  v0_.highlight AS highlight_125,
  v0_.catalog AS catalog_126,
  v0_.catalogHighlight AS catalogHighlight_127,
  v0_.star AS star_128,
  v0_.starElectro AS starElectro_129,
  v0_.sellerCallback AS sellerCallback_130,
  v0_.sentToSap AS sentToSap_131,
  v0_.critair AS critair_132,
  v0_.deliveryRequest AS deliveryRequest_133,
  v0_.identificationType AS identificationType_134,
  v0_.etincelleReservePrice AS etincelleReservePrice_135,
  v0_.sellerEstimationPrice AS sellerEstimationPrice_136,
  v0_.etincelleReservePriceHF AS etincelleReservePriceHF_137,
  v0_.sellerEstimationPriceHF AS sellerEstimationPriceHF_138,
  v0_.estimationPriceHF AS estimationPriceHF_139,
  v0_.cocFileUrl AS cocFileUrl_140,
  v0_.carpassFileUrl AS carpassFileUrl_141,
  v0_.firstCountryRegistration AS firstCountryRegistration_142,
  v0_.co2Standard AS co2Standard_143,
  v0_.vin AS vin_144,
  v0_.dataHubUUID AS dataHubUUID_145,
  v0_.sapFile AS sapFile_146,
  e1_.sourceStartingPrice AS sourceStartingPrice_147,
  e1_.datahubStartingPrice AS datahubStartingPrice_148,
  e1_.datahubSpotPrice AS datahubSpotPrice_149,
  e1_.datahubEstimationPrice AS datahubEstimationPrice_150,
  e1_.datahubCoefficient AS datahubCoefficient_151,
  e1_.priceVariationFromBidIncrement AS priceVariationFromBidIncrement_152,
  e1_.firstRegistrationYear AS firstRegistrationYear_153,
  e1_.cylinderCapacity AS cylinderCapacity_154,
  e1_.accessories AS accessories_155,
  e1_.DMRReports AS DMRReports_156,
  e1_.vatValue AS vatValue_157,
  e1_.formattedAddress AS formattedAddress_158,
  e1_.supplierCountry AS supplierCountry_159,
  e1_.fuelType AS fuelType_160,
  e1_.dataHubExportState AS dataHubExportState_161,
  e1_.gearType AS gearType_162,
  e1_.locationName AS locationName_163,
  CASE WHEN v0_.lot IS NULL THEN 1 ELSE 0 END AS sclr_164,
  v0_.discr AS discr_165,
  v0_.event_id AS event_id_166,
  v0_.winner_id AS winner_id_167,
  v0_.transmission_id AS transmission_id_168,
  v0_.category_id AS category_id_169,
  v0_.energy_id AS energy_id_170,
  v0_.seller_id AS seller_id_171,
  v0_.color_id AS color_id_172
FROM
  vehicle v0_
  LEFT JOIN external_vehicle e1_ ON v0_.id = e1_.id
  INNER JOIN sale_event s2_ ON v0_.event_id = s2_.id
  INNER JOIN sale s3_ ON s2_.sale_id = s3_.id
  LEFT JOIN external_sale e4_ ON s3_.id = e4_.id
WHERE
  v0_.star = (?)
  AND (
    (
      s3_.type = ?
      OR (
        s3_.type = ?
        AND s3_.public = ?
      )
    )
  )
  AND s3_.room_id IS NOT NULL
  AND s3_.endDate > ?
  AND v0_.salingState NOT IN (?, ?, ?)
  AND v0_.photos <> (?)
ORDER BY
  sclr_164 ASC
LIMIT
  0

SELECT v0_.id AS id_0, v0_.vehicleId AS vehicleId_1, v0_.photos AS photos_2, v0_.lot AS lot_3, v0_.lotComplement AS lotComplement_4, v0_.isranked AS isranked_5, v0_.salingState AS salingState_6, v0_.class AS class_7, v0_.maker AS maker_8, v0_.makerSlug AS makerSlug_9, v0_.modelGroup AS modelGroup_10, v0_.modelGroupSlug AS modelGroupSlug_11, v0_.segment AS segment_12, v0_.segmentSlug AS segmentSlug_13, v0_.segmentSize AS segmentSize_14, v0_.segmentSizeSlug AS segmentSizeSlug_15, v0_.segmentBody AS segmentBody_16, v0_.model AS model_17, v0_.typeCode AS typeCode_18, v0_.millesime AS millesime_19, v0_.registrationDate AS registrationDate_20, v0_.kilometers AS kilometers_21, v0_.taxHorsepower AS taxHorsepower_22, v0_.bodyType AS bodyType_23, v0_.stateDetails AS stateDetails_24, v0_.guarantee AS guarantee_25, v0_.guaranteed AS guaranteed_26, v0_.stateRating AS stateRating_27, v0_.afnor AS afnor_28, v0_.etincelleId AS etincelleId_29, v0_.iridiumId AS iridiumId_30, v0_.vat AS vat_31, v0_.seatCount AS seatCount_32, v0_.observation AS observation_33, v0_.motFileUrl AS motFileUrl_34, v0_.maintenanceFileUrl AS maintenanceFileUrl_35, v0_.roadTestFileUrl AS roadTestFileUrl_36, v0_.bilanExpertFileUrl AS bilanExpertFileUrl_37, v0_.photo3dExteriorUrl AS photo3dExteriorUrl_38, v0_.photo3dExteriorExtraUrl AS photo3dExteriorExtraUrl_39, v0_.explodedViewFileUrl AS explodedViewFileUrl_40, v0_.dekraUrl AS dekraUrl_41, v0_.inspectionReportUrl AS inspectionReportUrl_42, v0_.argusPrice AS argusPrice_43, v0_.argusTransactionPrice AS argusTransactionPrice_44, v0_.argusAnnoncePrice AS argusAnnoncePrice_45, v0_.argusDatedPrice AS argusDatedPrice_46, v0_.argusKmPrice AS argusKmPrice_47, v0_.spotPrice AS spotPrice_48, v0_.reconditioningPrice AS reconditioningPrice_49, v0_.estimationPrice AS estimationPrice_50, v0_.estimationPriceMin AS estimationPriceMin_51, v0_.initialReservePrice AS initialReservePrice_52, v0_.initialReservePriceHF AS initialReservePriceHF_53, v0_.reservePrice AS reservePrice_54, v0_.reservePriceHF AS reservePriceHF_55, v0_.oldReservePrice AS oldReservePrice_56, v0_.oldReservePriceHF AS oldReservePriceHF_57, v0_.deltaReservePrice AS deltaReservePrice_58, v0_.deltaFees AS deltaFees_59, v0_.unusedPrice AS unusedPrice_60, v0_.startingPrice AS startingPrice_61, v0_.buyoutPrice AS buyoutPrice_62, v0_.unsoldPrice AS unsoldPrice_63, v0_.unsoldOnlinePrice AS unsoldOnlinePrice_64, v0_.lastHammerPrice AS lastHammerPrice_65, v0_.finalAmount AS finalAmount_66, v0_.unsoldCount AS unsoldCount_67, v0_.unsoldOnlineCount AS unsoldOnlineCount_68, v0_.broken AS broken_69, v0_.duplicateKeys AS duplicateKeys_70, v0_.co2 AS co2_71, v0_.euroEmissionStandard AS euroEmissionStandard_72, v0_.shortModel AS shortModel_73, v0_.version AS version_74, v0_.length AS length_75, v0_.width AS width_76, v0_.height AS height_77, v0_.tarification AS tarification_78, v0_.tarificationType AS tarificationType_79, v0_.zipCodeLocation AS zipCodeLocation_80, v0_.cityLocation AS cityLocation_81, v0_.lotOpen AS lotOpen_82, v0_.justOpened AS justOpened_83, v0_.nbViews AS nbViews_84, v0_.noShipping AS noShipping_85, v0_.salesperson AS salesperson_86, v0_.etincelleCreatedAt AS etincelleCreatedAt_87, v0_.etincelleSalingState AS etincelleSalingState_88, v0_.etincelleSalingStateComplement AS etincelleSalingStateComplement_89, v0_.urgent AS urgent_90, v0_.mandateDate AS mandateDate_91, v0_.soldDate AS soldDate_92, v0_.registrationPlate AS registrationPlate_93, v0_.adjustable AS adjustable_94, v0_.emptyWeight AS emptyWeight_95, v0_.liftingCapacity AS liftingCapacity_96, v0_.liftingHeight AS liftingHeight_97, v0_.engineActualHourCount AS engineActualHourCount_98, v0_.wheelBase AS wheelBase_99, v0_.cylinderCount AS cylinderCount_100, v0_.doorCount AS doorCount_101, v0_.gearCount AS gearCount_102, v0_.driveWheel AS driveWheel_103, v0_.loadWeight AS loadWeight_104, v0_.horsePower AS horsePower_105, v0_.gearbox AS gearbox_106, v0_.maintenanceBookState AS maintenanceBookState_107, v0_.maintenanceFileState AS maintenanceFileState_108, v0_.makerGuarantee AS makerGuarantee_109, v0_.makerGuaranteeExpiredAt AS makerGuaranteeExpiredAt_110, v0_.makerGuaranteeKilometers AS makerGuaranteeKilometers_111, v0_.premiumGuarantee AS premiumGuarantee_112, v0_.premiumGuaranteeDescription AS premiumGuaranteeDescription_113, v0_.segmentFirst AS segmentFirst_114, v0_.firstHand AS firstHand_115, v0_.argusOID AS argusOID_116, v0_.natCode AS natCode_117, v0_.damaged AS damaged_118, v0_.sellerObservation AS sellerObservation_119, v0_.trainingVehicle AS trainingVehicle_120, v0_.taxi AS taxi_121, v0_.mechanicallyDamaged AS mechanicallyDamaged_122, v0_.innerStateRating AS innerStateRating_123, v0_.expertiseRating AS expertiseRating_124, v0_.highlight AS highlight_125, v0_.catalog AS catalog_126, v0_.catalogHighlight AS catalogHighlight_127, v0_.star AS star_128, v0_.starElectro AS starElectro_129, v0_.sellerCallback AS sellerCallback_130, v0_.sentToSap AS sentToSap_131, v0_.critair AS critair_132, v0_.deliveryRequest AS deliveryRequest_133, v0_.identificationType AS identificationType_134, v0_.etincelleReservePrice AS etincelleReservePrice_135, v0_.sellerEstimationPrice AS sellerEstimationPrice_136, v0_.etincelleReservePriceHF AS etincelleReservePriceHF_137, v0_.sellerEstimationPriceHF AS sellerEstimationPriceHF_138, v0_.estimationPriceHF AS estimationPriceHF_139, v0_.cocFileUrl AS cocFileUrl_140, v0_.carpassFileUrl AS carpassFileUrl_141, v0_.firstCountryRegistration AS firstCountryRegistration_142, v0_.co2Standard AS co2Standard_143, v0_.vin AS vin_144, v0_.dataHubUUID AS dataHubUUID_145, v0_.sapFile AS sapFile_146, e1_.sourceStartingPrice AS sourceStartingPrice_147, e1_.datahubStartingPrice AS datahubStartingPrice_148, e1_.datahubSpotPrice AS datahubSpotPrice_149, e1_.datahubEstimationPrice AS datahubEstimationPrice_150, e1_.datahubCoefficient AS datahubCoefficient_151, e1_.priceVariationFromBidIncrement AS priceVariationFromBidIncrement_152, e1_.firstRegistrationYear AS firstRegistrationYear_153, e1_.cylinderCapacity AS cylinderCapacity_154, e1_.accessories AS accessories_155, e1_.DMRReports AS DMRReports_156, e1_.vatValue AS vatValue_157, e1_.formattedAddress AS formattedAddress_158, e1_.supplierCountry AS supplierCountry_159, e1_.fuelType AS fuelType_160, e1_.dataHubExportState AS dataHubExportState_161, e1_.gearType AS gearType_162, e1_.locationName AS locationName_163, CASE WHEN v0_.lot IS NULL THEN 1 ELSE 0 END AS sclr_164, v0_.discr AS discr_165, v0_.event_id AS event_id_166, v0_.winner_id AS winner_id_167, v0_.transmission_id AS transmission_id_168, v0_.category_id AS category_id_169, v0_.energy_id AS energy_id_170, v0_.seller_id AS seller_id_171, v0_.color_id AS color_id_172 FROM vehicle v0_ LEFT JOIN external_vehicle e1_ ON v0_.id = e1_.id INNER JOIN sale_event s2_ ON v0_.event_id = s2_.id INNER JOIN sale s3_ ON s2_.sale_id = s3_.id LEFT JOIN external_sale e4_ ON s3_.id = e4_.id WHERE v0_.star = (1) AND ((s3_.type = 'Physique' OR (s3_.type = 'Electronique' AND s3_.public = 'al'))) AND s3_.room_id IS NOT NULL AND s3_.endDate > '2025-01-10 15:09:21' AND v0_.salingState NOT IN ('Exclus', 'Supprimé', 'Absence mise à prix') AND v0_.photos <> ('N;') ORDER BY sclr_164 ASC LIMIT 0;

SELECT
  t0.id AS id_1,
  t0.value AS value_2,
  t0.array_value AS array_value_3,
  t0.type AS type_4,
  t0.category AS category_5,
  t0.tooltip AS tooltip_6,
  t0.name AS name_7
FROM
  parameter t0
WHERE
  t0.name = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.value AS value_2, t0.array_value AS array_value_3, t0.type AS type_4, t0.category AS category_5, t0.tooltip AS tooltip_6, t0.name AS name_7 FROM parameter t0 WHERE t0.name = 'google.verif_tag.enabled' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.value AS value_2,
  t0.array_value AS array_value_3,
  t0.type AS type_4,
  t0.category AS category_5,
  t0.tooltip AS tooltip_6,
  t0.name AS name_7
FROM
  parameter t0
WHERE
  t0.name = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.value AS value_2, t0.array_value AS array_value_3, t0.type AS type_4, t0.category AS category_5, t0.tooltip AS tooltip_6, t0.name AS name_7 FROM parameter t0 WHERE t0.name = 'bing.verif_tag.enabled' LIMIT 1;