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
  INNER JOIN sale_event s2_ ON s0_.id = s2_.sale_id
WHERE
  s0_.type IN (?, ?)
  AND s0_.isLive = 1
  AND s0_.startDate <= ?
  AND s0_.status = ?
  AND s0_.endDate > ?
ORDER BY
  s0_.startDate ASC,
  s2_.startTime ASC

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 <= '2025-01-10 21:57:59' AND s0_.status = 'Fermée' AND s0_.endDate > '2025-01-10 21:57:59' ORDER BY s0_.startDate ASC, s2_.startTime ASC;

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_.status <> ?
  AND s0_.endDate > ?
  AND s0_.status <> ?
ORDER BY
  s0_.startDate ASC,
  s2_.startTime ASC
LIMIT
  3

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_.status <> 'Fermée' AND s0_.endDate > '2025-01-10 21:57:59' AND s0_.status <> 'Fermée' ORDER BY s0_.startDate ASC, s2_.startTime ASC LIMIT 3;

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;

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 = 'cookiebot.id' 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 = 'matomo.url' 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 = 'kameleoon_ab_testing.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 = 'tracking.tag_manager' 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 = 'yandex_metrica.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 = 'vpautopro.help_manual.france' 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 = 'vpautopro.contact.phone' 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 = 'vpautopro.contact.phone' LIMIT 1;