Symfony Profiler

SELECT
  (
    CASE WHEN v0_.prix_remise IS NULL
    OR v0_.prix_remise = 0 THEN
      v0_.prix_neuf
    ELSE
      v0_.prix_remise
    END
  ) AS sclr_0,
  (
    CASE WHEN (
      v0_.prix_remise IS NULL
      AND v0_.prix_neuf IS NULL
    ) THEN
      1
    ELSE
      0
    END
  ) AS sclr_1,
  v0_.id AS id_2,
  v0_.id AS id_3,
  v0_.identifiant_vn AS identifiant_vn_4,
  v0_.numero_chassis AS numero_chassis_5,
  v0_.modele AS modele_6,
  v0_.titre AS titre_7,
  v0_.prix_neuf AS prix_neuf_8,
  v0_.prix_remise AS prix_remise_9,
  v0_.kilometrage AS kilometrage_10,
  v0_.motorisation AS motorisation_11,
  v0_.cylindree AS cylindree_12,
  v0_.date_immat AS date_immat_13,
  v0_.immatriculation AS immatriculation_14,
  v0_.boite_vitesse AS boite_vitesse_15,
  v0_.garantie AS garantie_16,
  v0_.carrosserie AS carrosserie_17,
  v0_.poids_avide AS poids_avide_18,
  v0_.transmission AS transmission_19,
  v0_.emissions_co2 AS emissions_co2_20,
  v0_.crit_air AS crit_air_21,
  v0_.puissance_din AS puissance_din_22,
  v0_.puissance_fiscale AS puissance_fiscale_23,
  v0_.nb_places AS nb_places_24,
  v0_.nb_portes AS nb_portes_25,
  v0_.couleur_exterieure AS couleur_exterieure_26,
  v0_.sellerie AS sellerie_27,
  v0_.nb_jours_en_stock AS nb_jours_en_stock_28,
  v0_.options_et_equipements AS options_et_equipements_29,
  v0_.visuels AS visuels_30,
  v0_.commentaire AS commentaire_31,
  v0_.is_published AS is_published_32,
  v0_.modifier_backend AS modifier_backend_33,
  v0_.flux AS flux_34,
  v0_.is_supprimed AS is_supprimed_35,
  v0_.create_at AS create_at_36,
  v0_.update_at AS update_at_37,
  m1_.id AS id_38,
  m1_.nom AS nom_39,
  m1_.type AS type_40,
  c2_.id AS id_41,
  c2_.nom AS nom_42,
  c2_.adresse AS adresse_43,
  c2_.telephone AS telephone_44
FROM
  vehicule_neuf v0_
  LEFT JOIN marque m1_ ON v0_.marque_id = m1_.id
  LEFT JOIN concession c2_ ON v0_.concession_id = c2_.id
WHERE
  v0_.is_supprimed = 0
  AND v0_.is_published = ?
  AND m1_.type = ?
ORDER BY
  sclr_1 ASC,
  sclr_0 ASC,
  v0_.id DESC

SELECT (CASE WHEN v0_.prix_remise IS NULL OR v0_.prix_remise = 0 THEN v0_.prix_neuf ELSE v0_.prix_remise END) AS sclr_0, (CASE WHEN (v0_.prix_remise IS NULL AND v0_.prix_neuf IS NULL) THEN 1 ELSE 0 END) AS sclr_1, v0_.id AS id_2, v0_.id AS id_3, v0_.identifiant_vn AS identifiant_vn_4, v0_.numero_chassis AS numero_chassis_5, v0_.modele AS modele_6, v0_.titre AS titre_7, v0_.prix_neuf AS prix_neuf_8, v0_.prix_remise AS prix_remise_9, v0_.kilometrage AS kilometrage_10, v0_.motorisation AS motorisation_11, v0_.cylindree AS cylindree_12, v0_.date_immat AS date_immat_13, v0_.immatriculation AS immatriculation_14, v0_.boite_vitesse AS boite_vitesse_15, v0_.garantie AS garantie_16, v0_.carrosserie AS carrosserie_17, v0_.poids_avide AS poids_avide_18, v0_.transmission AS transmission_19, v0_.emissions_co2 AS emissions_co2_20, v0_.crit_air AS crit_air_21, v0_.puissance_din AS puissance_din_22, v0_.puissance_fiscale AS puissance_fiscale_23, v0_.nb_places AS nb_places_24, v0_.nb_portes AS nb_portes_25, v0_.couleur_exterieure AS couleur_exterieure_26, v0_.sellerie AS sellerie_27, v0_.nb_jours_en_stock AS nb_jours_en_stock_28, v0_.options_et_equipements AS options_et_equipements_29, v0_.visuels AS visuels_30, v0_.commentaire AS commentaire_31, v0_.is_published AS is_published_32, v0_.modifier_backend AS modifier_backend_33, v0_.flux AS flux_34, v0_.is_supprimed AS is_supprimed_35, v0_.create_at AS create_at_36, v0_.update_at AS update_at_37, m1_.id AS id_38, m1_.nom AS nom_39, m1_.type AS type_40, c2_.id AS id_41, c2_.nom AS nom_42, c2_.adresse AS adresse_43, c2_.telephone AS telephone_44 FROM vehicule_neuf v0_ LEFT JOIN marque m1_ ON v0_.marque_id = m1_.id LEFT JOIN concession c2_ ON v0_.concession_id = c2_.id WHERE v0_.is_supprimed = 0 AND v0_.is_published = 1 AND m1_.type = 'auto' ORDER BY sclr_1 ASC, sclr_0 ASC, v0_.id DESC;

SELECT
  m0_.id AS id_0,
  m0_.nom AS nom_1,
  m0_.type AS type_2
FROM
  marque m0_
WHERE
  m0_.type = ?
ORDER BY
  m0_.nom ASC

SELECT m0_.id AS id_0, m0_.nom AS nom_1, m0_.type AS type_2 FROM marque m0_ WHERE m0_.type = 'auto' ORDER BY m0_.nom ASC;

SELECT
  DISTINCT v0_.id AS id_0,
  (
    CASE WHEN (
      v0_.prix_remise IS NULL
      AND v0_.prix_neuf IS NULL
    ) THEN
      1
    ELSE
      0
    END
  ) AS sclr_1,
  (
    CASE WHEN v0_.prix_remise IS NULL
    OR v0_.prix_remise = 0 THEN
      v0_.prix_neuf
    ELSE
      v0_.prix_remise
    END
  ) AS sclr_2,
  v0_.id AS id_3
FROM
  vehicule_neuf v0_
  LEFT JOIN marque m1_ ON v0_.marque_id = m1_.id
  LEFT JOIN concession c2_ ON v0_.concession_id = c2_.id
WHERE
  v0_.is_supprimed = 0
  AND v0_.is_published = ?
  AND m1_.type = ?
ORDER BY
  sclr_1 ASC,
  sclr_2 ASC,
  v0_.id DESC
LIMIT
  20

SELECT DISTINCT v0_.id AS id_0, (CASE WHEN (v0_.prix_remise IS NULL AND v0_.prix_neuf IS NULL) THEN 1 ELSE 0 END) AS sclr_1, (CASE WHEN v0_.prix_remise IS NULL OR v0_.prix_remise = 0 THEN v0_.prix_neuf ELSE v0_.prix_remise END) AS sclr_2, v0_.id AS id_3 FROM vehicule_neuf v0_ LEFT JOIN marque m1_ ON v0_.marque_id = m1_.id LEFT JOIN concession c2_ ON v0_.concession_id = c2_.id WHERE v0_.is_supprimed = 0 AND v0_.is_published = 1 AND m1_.type = 'auto' ORDER BY sclr_1 ASC, sclr_2 ASC, v0_.id DESC LIMIT 20;

SELECT
  count(DISTINCT v0_.id) AS sclr_0
FROM
  vehicule_neuf v0_
  LEFT JOIN marque m1_ ON v0_.marque_id = m1_.id
  LEFT JOIN concession c2_ ON v0_.concession_id = c2_.id
WHERE
  v0_.is_supprimed = 0
  AND v0_.is_published = ?
  AND m1_.type = ?

SELECT count(DISTINCT v0_.id) AS sclr_0 FROM vehicule_neuf v0_ LEFT JOIN marque m1_ ON v0_.marque_id = m1_.id LEFT JOIN concession c2_ ON v0_.concession_id = c2_.id WHERE v0_.is_supprimed = 0 AND v0_.is_published = 1 AND m1_.type = 'auto';

SELECT
  m0_.id AS id_0,
  COUNT(v1_.id) AS sclr_1
FROM
  vehicule_neuf v1_
  LEFT JOIN marque m0_ ON v1_.marque_id = m0_.id
  LEFT JOIN concession c2_ ON v1_.concession_id = c2_.id
WHERE
  v1_.is_supprimed = 0
  AND v1_.is_published = ?
GROUP BY
  m0_.id

SELECT m0_.id AS id_0, COUNT(v1_.id) AS sclr_1 FROM vehicule_neuf v1_ LEFT JOIN marque m0_ ON v1_.marque_id = m0_.id LEFT JOIN concession c2_ ON v1_.concession_id = c2_.id WHERE v1_.is_supprimed = 0 AND v1_.is_published = 1 GROUP BY m0_.id;

SELECT
  (
    CASE WHEN v0_.prix_remise IS NULL
    OR v0_.prix_remise = 0 THEN
      v0_.prix_neuf
    ELSE
      v0_.prix_remise
    END
  ) AS sclr_0,
  (
    CASE WHEN (
      v0_.prix_remise IS NULL
      AND v0_.prix_neuf IS NULL
    ) THEN
      1
    ELSE
      0
    END
  ) AS sclr_1,
  v0_.id AS id_2,
  v0_.identifiant_vn AS identifiant_vn_3,
  v0_.numero_chassis AS numero_chassis_4,
  v0_.modele AS modele_5,
  v0_.titre AS titre_6,
  v0_.prix_neuf AS prix_neuf_7,
  v0_.prix_remise AS prix_remise_8,
  v0_.kilometrage AS kilometrage_9,
  v0_.motorisation AS motorisation_10,
  v0_.cylindree AS cylindree_11,
  v0_.date_immat AS date_immat_12,
  v0_.immatriculation AS immatriculation_13,
  v0_.boite_vitesse AS boite_vitesse_14,
  v0_.garantie AS garantie_15,
  v0_.carrosserie AS carrosserie_16,
  v0_.poids_avide AS poids_avide_17,
  v0_.transmission AS transmission_18,
  v0_.emissions_co2 AS emissions_co2_19,
  v0_.crit_air AS crit_air_20,
  v0_.puissance_din AS puissance_din_21,
  v0_.puissance_fiscale AS puissance_fiscale_22,
  v0_.nb_places AS nb_places_23,
  v0_.nb_portes AS nb_portes_24,
  v0_.couleur_exterieure AS couleur_exterieure_25,
  v0_.sellerie AS sellerie_26,
  v0_.nb_jours_en_stock AS nb_jours_en_stock_27,
  v0_.options_et_equipements AS options_et_equipements_28,
  v0_.visuels AS visuels_29,
  v0_.commentaire AS commentaire_30,
  v0_.is_published AS is_published_31,
  v0_.modifier_backend AS modifier_backend_32,
  v0_.flux AS flux_33,
  v0_.is_supprimed AS is_supprimed_34,
  v0_.create_at AS create_at_35,
  v0_.update_at AS update_at_36,
  m1_.id AS id_37,
  m1_.nom AS nom_38,
  m1_.type AS type_39,
  c2_.id AS id_40,
  c2_.nom AS nom_41,
  c2_.adresse AS adresse_42,
  c2_.telephone AS telephone_43,
  v0_.marque_id AS marque_id_44,
  v0_.concession_id AS concession_id_45
FROM
  vehicule_neuf v0_
  LEFT JOIN marque m1_ ON v0_.marque_id = m1_.id
  LEFT JOIN concession c2_ ON v0_.concession_id = c2_.id
WHERE
  v0_.is_supprimed = 0
  AND v0_.is_published = ?
  AND m1_.type = ?
  AND v0_.id IN (
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?
  )
ORDER BY
  sclr_1 ASC,
  sclr_0 ASC,
  v0_.id DESC

SELECT (CASE WHEN v0_.prix_remise IS NULL OR v0_.prix_remise = 0 THEN v0_.prix_neuf ELSE v0_.prix_remise END) AS sclr_0, (CASE WHEN (v0_.prix_remise IS NULL AND v0_.prix_neuf IS NULL) THEN 1 ELSE 0 END) AS sclr_1, v0_.id AS id_2, v0_.identifiant_vn AS identifiant_vn_3, v0_.numero_chassis AS numero_chassis_4, v0_.modele AS modele_5, v0_.titre AS titre_6, v0_.prix_neuf AS prix_neuf_7, v0_.prix_remise AS prix_remise_8, v0_.kilometrage AS kilometrage_9, v0_.motorisation AS motorisation_10, v0_.cylindree AS cylindree_11, v0_.date_immat AS date_immat_12, v0_.immatriculation AS immatriculation_13, v0_.boite_vitesse AS boite_vitesse_14, v0_.garantie AS garantie_15, v0_.carrosserie AS carrosserie_16, v0_.poids_avide AS poids_avide_17, v0_.transmission AS transmission_18, v0_.emissions_co2 AS emissions_co2_19, v0_.crit_air AS crit_air_20, v0_.puissance_din AS puissance_din_21, v0_.puissance_fiscale AS puissance_fiscale_22, v0_.nb_places AS nb_places_23, v0_.nb_portes AS nb_portes_24, v0_.couleur_exterieure AS couleur_exterieure_25, v0_.sellerie AS sellerie_26, v0_.nb_jours_en_stock AS nb_jours_en_stock_27, v0_.options_et_equipements AS options_et_equipements_28, v0_.visuels AS visuels_29, v0_.commentaire AS commentaire_30, v0_.is_published AS is_published_31, v0_.modifier_backend AS modifier_backend_32, v0_.flux AS flux_33, v0_.is_supprimed AS is_supprimed_34, v0_.create_at AS create_at_35, v0_.update_at AS update_at_36, m1_.id AS id_37, m1_.nom AS nom_38, m1_.type AS type_39, c2_.id AS id_40, c2_.nom AS nom_41, c2_.adresse AS adresse_42, c2_.telephone AS telephone_43, v0_.marque_id AS marque_id_44, v0_.concession_id AS concession_id_45 FROM vehicule_neuf v0_ LEFT JOIN marque m1_ ON v0_.marque_id = m1_.id LEFT JOIN concession c2_ ON v0_.concession_id = c2_.id WHERE v0_.is_supprimed = 0 AND v0_.is_published = 1 AND m1_.type = 'auto' AND v0_.id IN (10526, 11437, 10525, 10524, 11105, 10529, 10531, 10527, 11177, 10528, 10521, 10668, 10530, 10523, 10532, 10522, 9820, 9711, 10534, 10770) ORDER BY sclr_1 ASC, sclr_0 ASC, v0_.id DESC;