Symfony Profiler

SELECT
  t0.id AS id_2,
  t0.type AS type_3,
  t0.title AS title_4,
  t0.startDate AS startDate_5,
  t0.endDate AS endDate_6,
  t0.recoveryAt AS recoveryAt_7,
  t0.description AS description_8,
  t0.status AS status_9,
  t0.bidIncrement AS bidIncrement_10,
  t0.vatRate AS vatRate_11,
  t0.dynamicClosing AS dynamicClosing_12,
  t0.extraTime AS extraTime_13,
  t0.salingType AS salingType_14,
  t0.publicationDate AS publicationDate_15,
  t0.expositionStartDate AS expositionStartDate_16,
  t0.expositionEndDate AS expositionEndDate_17,
  t0.dayExpositionTime AS dayExpositionTime_18,
  t0.createdAt AS createdAt_19,
  t0.updatedAt AS updatedAt_20,
  t0.hours AS hours_21,
  t0.bannerUrl AS bannerUrl_22,
  t0.logoUrl AS logoUrl_23,
  t0.company AS company_24,
  t0.stock AS stock_25,
  t0.public AS public_26,
  t0.displayExplodedView AS displayExplodedView_27,
  t0.displayReconditioningFees AS displayReconditioningFees_28,
  t0.isLive AS isLive_29,
  t0.noVehicles AS noVehicles_30,
  t0.liveVisitors AS liveVisitors_31,
  t0.afterSaleDuration AS afterSaleDuration_32,
  t0.exclusive AS exclusive_33,
  t0.prepared AS prepared_34,
  t0.fixedFees AS fixedFees_35,
  t0.closedAt AS closedAt_36,
  t0.country AS country_37,
  t0.iridiumId AS iridiumId_38,
  t0.room_id AS room_id_39,
  t0.vehicle_opened_id AS vehicle_opened_id_40,
  t0.last_opened_vehicle_id AS last_opened_vehicle_id_41,
  t0.discr,
  t1.provider AS provider_42,
  t1.providerId AS providerId_43,
  t1.providerType AS providerType_44,
  t1.tracked AS tracked_45,
  t1.importStatus AS importStatus_46,
  t1.endOfSaleProcessed AS endOfSaleProcessed_47,
  t1.originalTitle AS originalTitle_48
FROM
  sale t0
  LEFT JOIN external_sale t1 ON t0.id = t1.id
WHERE
  t0.id = ?
LIMIT
  1

SELECT t0.id AS id_2, t0.type AS type_3, t0.title AS title_4, t0.startDate AS startDate_5, t0.endDate AS endDate_6, t0.recoveryAt AS recoveryAt_7, t0.description AS description_8, t0.status AS status_9, t0.bidIncrement AS bidIncrement_10, t0.vatRate AS vatRate_11, t0.dynamicClosing AS dynamicClosing_12, t0.extraTime AS extraTime_13, t0.salingType AS salingType_14, t0.publicationDate AS publicationDate_15, t0.expositionStartDate AS expositionStartDate_16, t0.expositionEndDate AS expositionEndDate_17, t0.dayExpositionTime AS dayExpositionTime_18, t0.createdAt AS createdAt_19, t0.updatedAt AS updatedAt_20, t0.hours AS hours_21, t0.bannerUrl AS bannerUrl_22, t0.logoUrl AS logoUrl_23, t0.company AS company_24, t0.stock AS stock_25, t0.public AS public_26, t0.displayExplodedView AS displayExplodedView_27, t0.displayReconditioningFees AS displayReconditioningFees_28, t0.isLive AS isLive_29, t0.noVehicles AS noVehicles_30, t0.liveVisitors AS liveVisitors_31, t0.afterSaleDuration AS afterSaleDuration_32, t0.exclusive AS exclusive_33, t0.prepared AS prepared_34, t0.fixedFees AS fixedFees_35, t0.closedAt AS closedAt_36, t0.country AS country_37, t0.iridiumId AS iridiumId_38, t0.room_id AS room_id_39, t0.vehicle_opened_id AS vehicle_opened_id_40, t0.last_opened_vehicle_id AS last_opened_vehicle_id_41, t0.discr, t1.provider AS provider_42, t1.providerId AS providerId_43, t1.providerType AS providerType_44, t1.tracked AS tracked_45, t1.importStatus AS importStatus_46, t1.endOfSaleProcessed AS endOfSaleProcessed_47, t1.originalTitle AS originalTitle_48 FROM sale t0 LEFT JOIN external_sale t1 ON t0.id = t1.id WHERE t0.id = 'nantes' 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 room r2_ ON s0_.room_id = r2_.id
WHERE
  s0_.type = ?
  AND s0_.room_id IS NOT NULL
  AND s0_.endDate > ?
  AND r2_.code = ?
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 room r2_ ON s0_.room_id = r2_.id WHERE s0_.type = 'Physique' AND s0_.room_id IS NOT NULL AND s0_.endDate > '2026-02-04 11:17:38' AND r2_.code = 'nantes' ORDER BY s0_.startDate ASC LIMIT 1;