Symfony Profiler

SELECT
  v0_.id AS id_0,
  v0_.id AS id_1,
  v0_.identifiant_vn AS identifiant_vn_2,
  v0_.numero_chassis AS numero_chassis_3,
  v0_.modele AS modele_4,
  v0_.titre AS titre_5,
  v0_.prix_neuf AS prix_neuf_6,
  v0_.prix_remise AS prix_remise_7,
  v0_.kilometrage AS kilometrage_8,
  v0_.motorisation AS motorisation_9,
  v0_.cylindree AS cylindree_10,
  v0_.date_immat AS date_immat_11,
  v0_.immatriculation AS immatriculation_12,
  v0_.boite_vitesse AS boite_vitesse_13,
  v0_.garantie AS garantie_14,
  v0_.carrosserie AS carrosserie_15,
  v0_.poids_avide AS poids_avide_16,
  v0_.transmission AS transmission_17,
  v0_.emissions_co2 AS emissions_co2_18,
  v0_.crit_air AS crit_air_19,
  v0_.puissance_din AS puissance_din_20,
  v0_.puissance_fiscale AS puissance_fiscale_21,
  v0_.nb_places AS nb_places_22,
  v0_.nb_portes AS nb_portes_23,
  v0_.couleur_exterieure AS couleur_exterieure_24,
  v0_.sellerie AS sellerie_25,
  v0_.nb_jours_en_stock AS nb_jours_en_stock_26,
  v0_.options_et_equipements AS options_et_equipements_27,
  v0_.visuels AS visuels_28,
  v0_.commentaire AS commentaire_29,
  v0_.is_published AS is_published_30,
  v0_.modifier_backend AS modifier_backend_31,
  v0_.flux AS flux_32,
  v0_.is_supprimed AS is_supprimed_33,
  v0_.create_at AS create_at_34,
  v0_.update_at AS update_at_35,
  m1_.id AS id_36,
  m1_.nom AS nom_37,
  m1_.type AS type_38,
  c2_.id AS id_39,
  c2_.nom AS nom_40,
  c2_.adresse AS adresse_41,
  c2_.telephone AS telephone_42
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
  CASE WHEN v0_.prix_neuf IS NOT NULL
  AND v0_.prix_neuf > 0
  AND v0_.prix_remise IS NOT NULL
  AND v0_.prix_remise > 0
  AND v0_.prix_remise < v0_.prix_neuf THEN
    (
      100 * (v0_.prix_neuf - v0_.prix_remise) / v0_.prix_neuf
    )
  ELSE
    0
  END DESC,
  v0_.id DESC

SELECT v0_.id AS id_0, v0_.id AS id_1, v0_.identifiant_vn AS identifiant_vn_2, v0_.numero_chassis AS numero_chassis_3, v0_.modele AS modele_4, v0_.titre AS titre_5, v0_.prix_neuf AS prix_neuf_6, v0_.prix_remise AS prix_remise_7, v0_.kilometrage AS kilometrage_8, v0_.motorisation AS motorisation_9, v0_.cylindree AS cylindree_10, v0_.date_immat AS date_immat_11, v0_.immatriculation AS immatriculation_12, v0_.boite_vitesse AS boite_vitesse_13, v0_.garantie AS garantie_14, v0_.carrosserie AS carrosserie_15, v0_.poids_avide AS poids_avide_16, v0_.transmission AS transmission_17, v0_.emissions_co2 AS emissions_co2_18, v0_.crit_air AS crit_air_19, v0_.puissance_din AS puissance_din_20, v0_.puissance_fiscale AS puissance_fiscale_21, v0_.nb_places AS nb_places_22, v0_.nb_portes AS nb_portes_23, v0_.couleur_exterieure AS couleur_exterieure_24, v0_.sellerie AS sellerie_25, v0_.nb_jours_en_stock AS nb_jours_en_stock_26, v0_.options_et_equipements AS options_et_equipements_27, v0_.visuels AS visuels_28, v0_.commentaire AS commentaire_29, v0_.is_published AS is_published_30, v0_.modifier_backend AS modifier_backend_31, v0_.flux AS flux_32, v0_.is_supprimed AS is_supprimed_33, v0_.create_at AS create_at_34, v0_.update_at AS update_at_35, m1_.id AS id_36, m1_.nom AS nom_37, m1_.type AS type_38, c2_.id AS id_39, c2_.nom AS nom_40, c2_.adresse AS adresse_41, c2_.telephone AS telephone_42 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 CASE WHEN v0_.prix_neuf IS NOT NULL AND v0_.prix_neuf > 0 AND v0_.prix_remise IS NOT NULL AND v0_.prix_remise > 0 AND v0_.prix_remise < v0_.prix_neuf THEN (100 * (v0_.prix_neuf - v0_.prix_remise) / v0_.prix_neuf) ELSE 0 END DESC, v0_.id DESC;

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
  DISTINCT v0_.id AS id_0,
  v0_.id AS id_1
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
  CASE WHEN v0_.prix_neuf IS NOT NULL
  AND v0_.prix_neuf > 0
  AND v0_.prix_remise IS NOT NULL
  AND v0_.prix_remise > 0
  AND v0_.prix_remise < v0_.prix_neuf THEN
    (
      100 * (v0_.prix_neuf - v0_.prix_remise) / v0_.prix_neuf
    )
  ELSE
    0
  END DESC,
  v0_.id DESC
LIMIT
  20

SELECT DISTINCT v0_.id AS id_0, v0_.id AS id_1 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 CASE WHEN v0_.prix_neuf IS NOT NULL AND v0_.prix_neuf > 0 AND v0_.prix_remise IS NOT NULL AND v0_.prix_remise > 0 AND v0_.prix_remise < v0_.prix_neuf THEN (100 * (v0_.prix_neuf - v0_.prix_remise) / v0_.prix_neuf) ELSE 0 END DESC, v0_.id DESC LIMIT 20;

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
  v0_.id AS id_0,
  v0_.identifiant_vn AS identifiant_vn_1,
  v0_.numero_chassis AS numero_chassis_2,
  v0_.modele AS modele_3,
  v0_.titre AS titre_4,
  v0_.prix_neuf AS prix_neuf_5,
  v0_.prix_remise AS prix_remise_6,
  v0_.kilometrage AS kilometrage_7,
  v0_.motorisation AS motorisation_8,
  v0_.cylindree AS cylindree_9,
  v0_.date_immat AS date_immat_10,
  v0_.immatriculation AS immatriculation_11,
  v0_.boite_vitesse AS boite_vitesse_12,
  v0_.garantie AS garantie_13,
  v0_.carrosserie AS carrosserie_14,
  v0_.poids_avide AS poids_avide_15,
  v0_.transmission AS transmission_16,
  v0_.emissions_co2 AS emissions_co2_17,
  v0_.crit_air AS crit_air_18,
  v0_.puissance_din AS puissance_din_19,
  v0_.puissance_fiscale AS puissance_fiscale_20,
  v0_.nb_places AS nb_places_21,
  v0_.nb_portes AS nb_portes_22,
  v0_.couleur_exterieure AS couleur_exterieure_23,
  v0_.sellerie AS sellerie_24,
  v0_.nb_jours_en_stock AS nb_jours_en_stock_25,
  v0_.options_et_equipements AS options_et_equipements_26,
  v0_.visuels AS visuels_27,
  v0_.commentaire AS commentaire_28,
  v0_.is_published AS is_published_29,
  v0_.modifier_backend AS modifier_backend_30,
  v0_.flux AS flux_31,
  v0_.is_supprimed AS is_supprimed_32,
  v0_.create_at AS create_at_33,
  v0_.update_at AS update_at_34,
  m1_.id AS id_35,
  m1_.nom AS nom_36,
  m1_.type AS type_37,
  c2_.id AS id_38,
  c2_.nom AS nom_39,
  c2_.adresse AS adresse_40,
  c2_.telephone AS telephone_41,
  v0_.marque_id AS marque_id_42,
  v0_.concession_id AS concession_id_43
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
  CASE WHEN v0_.prix_neuf IS NOT NULL
  AND v0_.prix_neuf > 0
  AND v0_.prix_remise IS NOT NULL
  AND v0_.prix_remise > 0
  AND v0_.prix_remise < v0_.prix_neuf THEN
    (
      100 * (v0_.prix_neuf - v0_.prix_remise) / v0_.prix_neuf
    )
  ELSE
    0
  END DESC,
  v0_.id DESC

SELECT v0_.id AS id_0, v0_.identifiant_vn AS identifiant_vn_1, v0_.numero_chassis AS numero_chassis_2, v0_.modele AS modele_3, v0_.titre AS titre_4, v0_.prix_neuf AS prix_neuf_5, v0_.prix_remise AS prix_remise_6, v0_.kilometrage AS kilometrage_7, v0_.motorisation AS motorisation_8, v0_.cylindree AS cylindree_9, v0_.date_immat AS date_immat_10, v0_.immatriculation AS immatriculation_11, v0_.boite_vitesse AS boite_vitesse_12, v0_.garantie AS garantie_13, v0_.carrosserie AS carrosserie_14, v0_.poids_avide AS poids_avide_15, v0_.transmission AS transmission_16, v0_.emissions_co2 AS emissions_co2_17, v0_.crit_air AS crit_air_18, v0_.puissance_din AS puissance_din_19, v0_.puissance_fiscale AS puissance_fiscale_20, v0_.nb_places AS nb_places_21, v0_.nb_portes AS nb_portes_22, v0_.couleur_exterieure AS couleur_exterieure_23, v0_.sellerie AS sellerie_24, v0_.nb_jours_en_stock AS nb_jours_en_stock_25, v0_.options_et_equipements AS options_et_equipements_26, v0_.visuels AS visuels_27, v0_.commentaire AS commentaire_28, v0_.is_published AS is_published_29, v0_.modifier_backend AS modifier_backend_30, v0_.flux AS flux_31, v0_.is_supprimed AS is_supprimed_32, v0_.create_at AS create_at_33, v0_.update_at AS update_at_34, m1_.id AS id_35, m1_.nom AS nom_36, m1_.type AS type_37, c2_.id AS id_38, c2_.nom AS nom_39, c2_.adresse AS adresse_40, c2_.telephone AS telephone_41, v0_.marque_id AS marque_id_42, v0_.concession_id AS concession_id_43 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 (10668, 10521, 10528, 10522, 10529, 10532, 10527, 11437, 10531, 10524, 11105, 10533, 10534, 10526, 10525, 10535, 10530, 10770, 9278, 9862) ORDER BY CASE WHEN v0_.prix_neuf IS NOT NULL AND v0_.prix_neuf > 0 AND v0_.prix_remise IS NOT NULL AND v0_.prix_remise > 0 AND v0_.prix_remise < v0_.prix_neuf THEN (100 * (v0_.prix_neuf - v0_.prix_remise) / v0_.prix_neuf) ELSE 0 END DESC, 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;