Symfony Profiler

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 = 'B2B' AND b0_.startDate <= '2025-01-10 18:35:31' AND b0_.endDate > '2025-01-10 18:35:31' AND b0_.localeId = 'fr' ORDER BY sclr_10 ASC, b0_.priority ASC, b0_.startDate ASC;

SELECT
  DISTINCT CASE WHEN s0_.type = ? THEN DATE(s0_.startDate) ELSE DATE(s0_.endDate) END AS sclr_0,
  s0_.id AS id_1,
  s0_.type AS type_2,
  s0_.title AS title_3,
  s0_.startDate AS startDate_4,
  s0_.endDate AS endDate_5,
  s0_.recoveryAt AS recoveryAt_6,
  s0_.description AS description_7,
  s0_.status AS status_8,
  s0_.bidIncrement AS bidIncrement_9,
  s0_.vatRate AS vatRate_10,
  s0_.dynamicClosing AS dynamicClosing_11,
  s0_.extraTime AS extraTime_12,
  s0_.salingType AS salingType_13,
  s0_.publicationDate AS publicationDate_14,
  s0_.expositionStartDate AS expositionStartDate_15,
  s0_.expositionEndDate AS expositionEndDate_16,
  s0_.dayExpositionTime AS dayExpositionTime_17,
  s0_.createdAt AS createdAt_18,
  s0_.updatedAt AS updatedAt_19,
  s0_.hours AS hours_20,
  s0_.bannerUrl AS bannerUrl_21,
  s0_.logoUrl AS logoUrl_22,
  s0_.company AS company_23,
  s0_.stock AS stock_24,
  s0_.public AS public_25,
  s0_.displayExplodedView AS displayExplodedView_26,
  s0_.displayReconditioningFees AS displayReconditioningFees_27,
  s0_.isLive AS isLive_28,
  s0_.noVehicles AS noVehicles_29,
  s0_.liveVisitors AS liveVisitors_30,
  s0_.afterSaleDuration AS afterSaleDuration_31,
  s0_.exclusive AS exclusive_32,
  s0_.prepared AS prepared_33,
  s0_.fixedFees AS fixedFees_34,
  s0_.closedAt AS closedAt_35,
  s0_.country AS country_36,
  s0_.iridiumId AS iridiumId_37,
  e1_.provider AS provider_38,
  e1_.providerId AS providerId_39,
  e1_.providerType AS providerType_40,
  e1_.tracked AS tracked_41,
  e1_.importStatus AS importStatus_42,
  e1_.endOfSaleProcessed AS endOfSaleProcessed_43,
  e1_.originalTitle AS originalTitle_44,
  s2_.id AS id_45,
  s2_.startTime AS startTime_46,
  s2_.period AS period_47,
  s2_.lotsImport AS lotsImport_48,
  s3_.id AS id_49,
  s3_.name AS name_50,
  s3_.code AS code_51,
  r4_.id AS id_52,
  r4_.name AS name_53,
  r4_.localName AS localName_54,
  r4_.code AS code_55,
  r4_.street AS street_56,
  r4_.zipCode AS zipCode_57,
  r4_.city AS city_58,
  r4_.phone AS phone_59,
  r4_.fax AS fax_60,
  r4_.api_list AS api_list_61,
  s0_.discr AS discr_62,
  s0_.room_id AS room_id_63,
  s0_.vehicle_opened_id AS vehicle_opened_id_64,
  s0_.last_opened_vehicle_id AS last_opened_vehicle_id_65,
  s2_.sale_event_title_id AS sale_event_title_id_66,
  s2_.sale_id AS sale_id_67
FROM
  sale s0_
  LEFT JOIN external_sale e1_ ON s0_.id = e1_.id
  LEFT JOIN sale_event s2_ ON s0_.id = s2_.sale_id
  LEFT JOIN sale_event_title s3_ ON s2_.sale_event_title_id = s3_.id
  LEFT JOIN room r4_ ON s0_.room_id = r4_.id
WHERE
  s0_.endDate > ?
  AND (
    (
      s0_.id IN (
        SELECT
          DISTINCT s5_.id
        FROM
          sale s5_
          LEFT JOIN external_sale e6_ ON s5_.id = e6_.id
        WHERE
          s5_.type = ?
          AND s5_.status <> ?
      )
    )
    OR (
      s0_.id IN (
        SELECT
          DISTINCT s7_.id
        FROM
          sale s7_
          LEFT JOIN external_sale e8_ ON s7_.id = e8_.id
        WHERE
          s7_.type = ?
          AND s7_.room_id IS NOT NULL
          AND s7_.endDate >= ?
      )
    )
  )
ORDER BY
  sclr_0 ASC,
  s0_.type DESC,
  s0_.endDate ASC,
  s2_.startTime ASC

SELECT DISTINCT CASE WHEN s0_.type = 'Physique' THEN DATE(s0_.startDate) ELSE DATE(s0_.endDate) END AS sclr_0, s0_.id AS id_1, s0_.type AS type_2, s0_.title AS title_3, s0_.startDate AS startDate_4, s0_.endDate AS endDate_5, s0_.recoveryAt AS recoveryAt_6, s0_.description AS description_7, s0_.status AS status_8, s0_.bidIncrement AS bidIncrement_9, s0_.vatRate AS vatRate_10, s0_.dynamicClosing AS dynamicClosing_11, s0_.extraTime AS extraTime_12, s0_.salingType AS salingType_13, s0_.publicationDate AS publicationDate_14, s0_.expositionStartDate AS expositionStartDate_15, s0_.expositionEndDate AS expositionEndDate_16, s0_.dayExpositionTime AS dayExpositionTime_17, s0_.createdAt AS createdAt_18, s0_.updatedAt AS updatedAt_19, s0_.hours AS hours_20, s0_.bannerUrl AS bannerUrl_21, s0_.logoUrl AS logoUrl_22, s0_.company AS company_23, s0_.stock AS stock_24, s0_.public AS public_25, s0_.displayExplodedView AS displayExplodedView_26, s0_.displayReconditioningFees AS displayReconditioningFees_27, s0_.isLive AS isLive_28, s0_.noVehicles AS noVehicles_29, s0_.liveVisitors AS liveVisitors_30, s0_.afterSaleDuration AS afterSaleDuration_31, s0_.exclusive AS exclusive_32, s0_.prepared AS prepared_33, s0_.fixedFees AS fixedFees_34, s0_.closedAt AS closedAt_35, s0_.country AS country_36, s0_.iridiumId AS iridiumId_37, e1_.provider AS provider_38, e1_.providerId AS providerId_39, e1_.providerType AS providerType_40, e1_.tracked AS tracked_41, e1_.importStatus AS importStatus_42, e1_.endOfSaleProcessed AS endOfSaleProcessed_43, e1_.originalTitle AS originalTitle_44, s2_.id AS id_45, s2_.startTime AS startTime_46, s2_.period AS period_47, s2_.lotsImport AS lotsImport_48, s3_.id AS id_49, s3_.name AS name_50, s3_.code AS code_51, r4_.id AS id_52, r4_.name AS name_53, r4_.localName AS localName_54, r4_.code AS code_55, r4_.street AS street_56, r4_.zipCode AS zipCode_57, r4_.city AS city_58, r4_.phone AS phone_59, r4_.fax AS fax_60, r4_.api_list AS api_list_61, s0_.discr AS discr_62, s0_.room_id AS room_id_63, s0_.vehicle_opened_id AS vehicle_opened_id_64, s0_.last_opened_vehicle_id AS last_opened_vehicle_id_65, s2_.sale_event_title_id AS sale_event_title_id_66, s2_.sale_id AS sale_id_67 FROM sale s0_ LEFT JOIN external_sale e1_ ON s0_.id = e1_.id LEFT JOIN sale_event s2_ ON s0_.id = s2_.sale_id LEFT JOIN sale_event_title s3_ ON s2_.sale_event_title_id = s3_.id LEFT JOIN room r4_ ON s0_.room_id = r4_.id WHERE s0_.endDate > '2025-01-10 18:35:31' AND ((s0_.id IN (SELECT DISTINCT s5_.id FROM sale s5_ LEFT JOIN external_sale e6_ ON s5_.id = e6_.id WHERE s5_.type = 'Electronique' AND s5_.status <> 'Fermée')) OR (s0_.id IN (SELECT DISTINCT s7_.id FROM sale s7_ LEFT JOIN external_sale e8_ ON s7_.id = e8_.id WHERE s7_.type = 'Physique' AND s7_.room_id IS NOT NULL AND s7_.endDate >= '2025-01-10 18:35:31'))) ORDER BY sclr_0 ASC, s0_.type DESC, s0_.endDate 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_.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 18:35:31' AND s0_.status <> 'Fermée' ORDER BY s0_.startDate ASC, s2_.startTime ASC LIMIT 1;

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 = 'B2B';

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,
  s2_.id AS id_44,
  s2_.startTime AS startTime_45,
  s2_.period AS period_46,
  s2_.lotsImport AS lotsImport_47,
  s3_.id AS id_48,
  s3_.name AS name_49,
  s3_.code AS code_50,
  r4_.id AS id_51,
  r4_.name AS name_52,
  r4_.localName AS localName_53,
  r4_.code AS code_54,
  r4_.street AS street_55,
  r4_.zipCode AS zipCode_56,
  r4_.city AS city_57,
  r4_.phone AS phone_58,
  r4_.fax AS fax_59,
  r4_.api_list AS api_list_60,
  s0_.discr AS discr_61,
  s0_.room_id AS room_id_62,
  s0_.vehicle_opened_id AS vehicle_opened_id_63,
  s0_.last_opened_vehicle_id AS last_opened_vehicle_id_64,
  s2_.sale_event_title_id AS sale_event_title_id_65,
  s2_.sale_id AS sale_id_66
FROM
  sale s0_
  LEFT JOIN external_sale e1_ ON s0_.id = e1_.id
  LEFT JOIN sale_event s2_ ON s0_.id = s2_.sale_id
  LEFT JOIN sale_event_title s3_ ON s2_.sale_event_title_id = s3_.id
  LEFT JOIN room r4_ ON s0_.room_id = r4_.id
WHERE
  DATE_ADD(
    s0_.endDate, INTERVAL s0_.afterSaleDuration HOUR
  ) > ?
  AND s0_.endDate <= ?
ORDER BY
  s0_.startDate 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, s2_.id AS id_44, s2_.startTime AS startTime_45, s2_.period AS period_46, s2_.lotsImport AS lotsImport_47, s3_.id AS id_48, s3_.name AS name_49, s3_.code AS code_50, r4_.id AS id_51, r4_.name AS name_52, r4_.localName AS localName_53, r4_.code AS code_54, r4_.street AS street_55, r4_.zipCode AS zipCode_56, r4_.city AS city_57, r4_.phone AS phone_58, r4_.fax AS fax_59, r4_.api_list AS api_list_60, s0_.discr AS discr_61, s0_.room_id AS room_id_62, s0_.vehicle_opened_id AS vehicle_opened_id_63, s0_.last_opened_vehicle_id AS last_opened_vehicle_id_64, s2_.sale_event_title_id AS sale_event_title_id_65, s2_.sale_id AS sale_id_66 FROM sale s0_ LEFT JOIN external_sale e1_ ON s0_.id = e1_.id LEFT JOIN sale_event s2_ ON s0_.id = s2_.sale_id LEFT JOIN sale_event_title s3_ ON s2_.sale_event_title_id = s3_.id LEFT JOIN room r4_ ON s0_.room_id = r4_.id WHERE DATE_ADD(s0_.endDate, INTERVAL s0_.afterSaleDuration HOUR) > '2025-01-10 18:35:31' AND s0_.endDate <= '2025-01-10 18:35:31' ORDER BY s0_.startDate ASC;

SELECT
  DISTINCT s0_.title AS title_0,
  s0_.id AS id_1
FROM
  sale s0_
  LEFT JOIN external_sale e1_ ON s0_.id = e1_.id
  LEFT JOIN sale_buyersgroup s3_ ON s0_.id = s3_.sale_id
  LEFT JOIN buyers_group b2_ ON b2_.id = s3_.buyersgroup_id
WHERE
  s0_.endDate > ?
ORDER BY
  s0_.startDate ASC

SELECT DISTINCT s0_.title AS title_0, s0_.id AS id_1 FROM sale s0_ LEFT JOIN external_sale e1_ ON s0_.id = e1_.id LEFT JOIN sale_buyersgroup s3_ ON s0_.id = s3_.sale_id LEFT JOIN buyers_group b2_ ON b2_.id = s3_.buyersgroup_id WHERE s0_.endDate > '2025-01-10 18:35:31' ORDER BY s0_.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 = '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;

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.help_manual.france' LIMIT 1;

SELECT
  COUNT(v0_.id) AS sclr_0
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_.salingState NOT IN (?, ?, ?)
  AND s3_.endDate > ?

SELECT COUNT(v0_.id) AS sclr_0 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_.salingState NOT IN ('Exclus', 'Supprimé', 'Absence mise à prix') AND s3_.endDate > '2025-01-10 18:35:00';