Symfony Profiler

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.contact.phone_france' 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
  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_.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 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:40:08' ORDER BY s0_.startDate ASC;

SELECT
  v0_.maker AS maker_0,
  v0_.makerSlug AS makerSlug_1,
  SUM(v0_.nbViews) AS sclr_2
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 > ?
  AND s2_.sale_id = -1
  AND v0_.maker <> ''
GROUP BY
  v0_.maker
ORDER BY
  sclr_2 DESC
LIMIT
  8

SELECT v0_.maker AS maker_0, v0_.makerSlug AS makerSlug_1, SUM(v0_.nbViews) AS sclr_2 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:40:00' AND s2_.sale_id = -1 AND v0_.maker <> '' GROUP BY v0_.maker ORDER BY sclr_2 DESC LIMIT 8;

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
  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_.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 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:40:08' ORDER BY s0_.startDate ASC;

SELECT
  v0_.maker AS maker_0,
  v0_.modelGroup AS modelGroup_1,
  v0_.makerSlug AS makerSlug_2,
  v0_.modelGroupSlug AS modelGroupSlug_3,
  SUM(v0_.nbViews) AS sclr_4
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 > ?
  AND s2_.sale_id = -1
  AND v0_.modelGroup <> ''
GROUP BY
  v0_.modelGroup
ORDER BY
  sclr_4 DESC
LIMIT
  10

SELECT v0_.maker AS maker_0, v0_.modelGroup AS modelGroup_1, v0_.makerSlug AS makerSlug_2, v0_.modelGroupSlug AS modelGroupSlug_3, SUM(v0_.nbViews) AS sclr_4 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:40:00' AND s2_.sale_id = -1 AND v0_.modelGroup <> '' GROUP BY v0_.modelGroup ORDER BY sclr_4 DESC LIMIT 10;

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.ajax.salesList.call.interval' 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 = 'tawkto_chat.enabled' LIMIT 1;