Symfony Profiler

SELECT
  count(DISTINCT b0_.id) AS sclr_0
FROM
  bien b0_
WHERE
  b0_.is_enabled = 1

SELECT count(DISTINCT b0_.id) AS sclr_0 FROM bien b0_ WHERE b0_.is_enabled = 1;

SELECT
  DISTINCT b0_.id AS id_0,
  b0_.id AS id_1
FROM
  bien b0_
WHERE
  b0_.is_enabled = 1
ORDER BY
  b0_.id DESC
LIMIT
  9

SELECT DISTINCT b0_.id AS id_0, b0_.id AS id_1 FROM bien b0_ WHERE b0_.is_enabled = 1 ORDER BY b0_.id DESC LIMIT 9;

SELECT
  b0_.id AS id_0,
  b0_.annonce_type AS annonce_type_1,
  b0_.bien_type AS bien_type_2,
  b0_.code_postal AS code_postal_3,
  b0_.ville AS ville_4,
  b0_.adresse AS adresse_5,
  b0_.prix AS prix_6,
  b0_.honoraires AS honoraires_7,
  b0_.surface_bien AS surface_bien_8,
  b0_.surface_terrain AS surface_terrain_9,
  b0_.nb_pieces AS nb_pieces_10,
  b0_.nb_chambres AS nb_chambres_11,
  b0_.libelle AS libelle_12,
  b0_.descriptif AS descriptif_13,
  b0_.etage AS etage_14,
  b0_.nb_etage AS nb_etage_15,
  b0_.meuble AS meuble_16,
  b0_.ascenseur AS ascenseur_17,
  b0_.cave AS cave_18,
  b0_.nb_parkings AS nb_parkings_19,
  b0_.photo1 AS photo1_20,
  b0_.photo2 AS photo2_21,
  b0_.photo3 AS photo3_22,
  b0_.photo4 AS photo4_23,
  b0_.photo5 AS photo5_24,
  b0_.photo6 AS photo6_25,
  b0_.photo7 AS photo7_26,
  b0_.photo8 AS photo8_27,
  b0_.photo9 AS photo9_28,
  b0_.titre_photo1 AS titre_photo1_29,
  b0_.titre_photo2 AS titre_photo2_30,
  b0_.titre_photo3 AS titre_photo3_31,
  b0_.titre_photo4 AS titre_photo4_32,
  b0_.titre_photo5 AS titre_photo5_33,
  b0_.titre_photo6 AS titre_photo6_34,
  b0_.titre_photo7 AS titre_photo7_35,
  b0_.titre_photo8 AS titre_photo8_36,
  b0_.titre_photo9 AS titre_photo9_37,
  b0_.latitude AS latitude_38,
  b0_.longitude AS longitude_39,
  b0_.ref_agencebien AS ref_agencebien_40,
  b0_.is_enabled AS is_enabled_41,
  b0_.coup_coeur AS coup_coeur_42
FROM
  bien b0_
WHERE
  b0_.is_enabled = 1
  AND b0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?)
ORDER BY
  b0_.id DESC

SELECT b0_.id AS id_0, b0_.annonce_type AS annonce_type_1, b0_.bien_type AS bien_type_2, b0_.code_postal AS code_postal_3, b0_.ville AS ville_4, b0_.adresse AS adresse_5, b0_.prix AS prix_6, b0_.honoraires AS honoraires_7, b0_.surface_bien AS surface_bien_8, b0_.surface_terrain AS surface_terrain_9, b0_.nb_pieces AS nb_pieces_10, b0_.nb_chambres AS nb_chambres_11, b0_.libelle AS libelle_12, b0_.descriptif AS descriptif_13, b0_.etage AS etage_14, b0_.nb_etage AS nb_etage_15, b0_.meuble AS meuble_16, b0_.ascenseur AS ascenseur_17, b0_.cave AS cave_18, b0_.nb_parkings AS nb_parkings_19, b0_.photo1 AS photo1_20, b0_.photo2 AS photo2_21, b0_.photo3 AS photo3_22, b0_.photo4 AS photo4_23, b0_.photo5 AS photo5_24, b0_.photo6 AS photo6_25, b0_.photo7 AS photo7_26, b0_.photo8 AS photo8_27, b0_.photo9 AS photo9_28, b0_.titre_photo1 AS titre_photo1_29, b0_.titre_photo2 AS titre_photo2_30, b0_.titre_photo3 AS titre_photo3_31, b0_.titre_photo4 AS titre_photo4_32, b0_.titre_photo5 AS titre_photo5_33, b0_.titre_photo6 AS titre_photo6_34, b0_.titre_photo7 AS titre_photo7_35, b0_.titre_photo8 AS titre_photo8_36, b0_.titre_photo9 AS titre_photo9_37, b0_.latitude AS latitude_38, b0_.longitude AS longitude_39, b0_.ref_agencebien AS ref_agencebien_40, b0_.is_enabled AS is_enabled_41, b0_.coup_coeur AS coup_coeur_42 FROM bien b0_ WHERE b0_.is_enabled = 1 AND b0_.id IN (60, 59, 58, 57, 56, 55, 54, 53, 52) ORDER BY b0_.id DESC;

SELECT
  t0.id AS id_1,
  t0.annonce_type AS annonce_type_2,
  t0.bien_type AS bien_type_3,
  t0.code_postal AS code_postal_4,
  t0.ville AS ville_5,
  t0.adresse AS adresse_6,
  t0.prix AS prix_7,
  t0.honoraires AS honoraires_8,
  t0.surface_bien AS surface_bien_9,
  t0.surface_terrain AS surface_terrain_10,
  t0.nb_pieces AS nb_pieces_11,
  t0.nb_chambres AS nb_chambres_12,
  t0.libelle AS libelle_13,
  t0.descriptif AS descriptif_14,
  t0.etage AS etage_15,
  t0.nb_etage AS nb_etage_16,
  t0.meuble AS meuble_17,
  t0.ascenseur AS ascenseur_18,
  t0.cave AS cave_19,
  t0.nb_parkings AS nb_parkings_20,
  t0.photo1 AS photo1_21,
  t0.photo2 AS photo2_22,
  t0.photo3 AS photo3_23,
  t0.photo4 AS photo4_24,
  t0.photo5 AS photo5_25,
  t0.photo6 AS photo6_26,
  t0.photo7 AS photo7_27,
  t0.photo8 AS photo8_28,
  t0.photo9 AS photo9_29,
  t0.titre_photo1 AS titre_photo1_30,
  t0.titre_photo2 AS titre_photo2_31,
  t0.titre_photo3 AS titre_photo3_32,
  t0.titre_photo4 AS titre_photo4_33,
  t0.titre_photo5 AS titre_photo5_34,
  t0.titre_photo6 AS titre_photo6_35,
  t0.titre_photo7 AS titre_photo7_36,
  t0.titre_photo8 AS titre_photo8_37,
  t0.titre_photo9 AS titre_photo9_38,
  t0.latitude AS latitude_39,
  t0.longitude AS longitude_40,
  t0.ref_agencebien AS ref_agencebien_41,
  t0.is_enabled AS is_enabled_42,
  t0.coup_coeur AS coup_coeur_43
FROM
  bien t0

SELECT t0.id AS id_1, t0.annonce_type AS annonce_type_2, t0.bien_type AS bien_type_3, t0.code_postal AS code_postal_4, t0.ville AS ville_5, t0.adresse AS adresse_6, t0.prix AS prix_7, t0.honoraires AS honoraires_8, t0.surface_bien AS surface_bien_9, t0.surface_terrain AS surface_terrain_10, t0.nb_pieces AS nb_pieces_11, t0.nb_chambres AS nb_chambres_12, t0.libelle AS libelle_13, t0.descriptif AS descriptif_14, t0.etage AS etage_15, t0.nb_etage AS nb_etage_16, t0.meuble AS meuble_17, t0.ascenseur AS ascenseur_18, t0.cave AS cave_19, t0.nb_parkings AS nb_parkings_20, t0.photo1 AS photo1_21, t0.photo2 AS photo2_22, t0.photo3 AS photo3_23, t0.photo4 AS photo4_24, t0.photo5 AS photo5_25, t0.photo6 AS photo6_26, t0.photo7 AS photo7_27, t0.photo8 AS photo8_28, t0.photo9 AS photo9_29, t0.titre_photo1 AS titre_photo1_30, t0.titre_photo2 AS titre_photo2_31, t0.titre_photo3 AS titre_photo3_32, t0.titre_photo4 AS titre_photo4_33, t0.titre_photo5 AS titre_photo5_34, t0.titre_photo6 AS titre_photo6_35, t0.titre_photo7 AS titre_photo7_36, t0.titre_photo8 AS titre_photo8_37, t0.titre_photo9 AS titre_photo9_38, t0.latitude AS latitude_39, t0.longitude AS longitude_40, t0.ref_agencebien AS ref_agencebien_41, t0.is_enabled AS is_enabled_42, t0.coup_coeur AS coup_coeur_43 FROM bien t0;

SELECT
  t0.id AS id_1,
  t0.annonce_type AS annonce_type_2,
  t0.bien_type AS bien_type_3,
  t0.code_postal AS code_postal_4,
  t0.ville AS ville_5,
  t0.adresse AS adresse_6,
  t0.prix AS prix_7,
  t0.honoraires AS honoraires_8,
  t0.surface_bien AS surface_bien_9,
  t0.surface_terrain AS surface_terrain_10,
  t0.nb_pieces AS nb_pieces_11,
  t0.nb_chambres AS nb_chambres_12,
  t0.libelle AS libelle_13,
  t0.descriptif AS descriptif_14,
  t0.etage AS etage_15,
  t0.nb_etage AS nb_etage_16,
  t0.meuble AS meuble_17,
  t0.ascenseur AS ascenseur_18,
  t0.cave AS cave_19,
  t0.nb_parkings AS nb_parkings_20,
  t0.photo1 AS photo1_21,
  t0.photo2 AS photo2_22,
  t0.photo3 AS photo3_23,
  t0.photo4 AS photo4_24,
  t0.photo5 AS photo5_25,
  t0.photo6 AS photo6_26,
  t0.photo7 AS photo7_27,
  t0.photo8 AS photo8_28,
  t0.photo9 AS photo9_29,
  t0.titre_photo1 AS titre_photo1_30,
  t0.titre_photo2 AS titre_photo2_31,
  t0.titre_photo3 AS titre_photo3_32,
  t0.titre_photo4 AS titre_photo4_33,
  t0.titre_photo5 AS titre_photo5_34,
  t0.titre_photo6 AS titre_photo6_35,
  t0.titre_photo7 AS titre_photo7_36,
  t0.titre_photo8 AS titre_photo8_37,
  t0.titre_photo9 AS titre_photo9_38,
  t0.latitude AS latitude_39,
  t0.longitude AS longitude_40,
  t0.ref_agencebien AS ref_agencebien_41,
  t0.is_enabled AS is_enabled_42,
  t0.coup_coeur AS coup_coeur_43
FROM
  bien t0
WHERE
  t0.ville = ?

SELECT t0.id AS id_1, t0.annonce_type AS annonce_type_2, t0.bien_type AS bien_type_3, t0.code_postal AS code_postal_4, t0.ville AS ville_5, t0.adresse AS adresse_6, t0.prix AS prix_7, t0.honoraires AS honoraires_8, t0.surface_bien AS surface_bien_9, t0.surface_terrain AS surface_terrain_10, t0.nb_pieces AS nb_pieces_11, t0.nb_chambres AS nb_chambres_12, t0.libelle AS libelle_13, t0.descriptif AS descriptif_14, t0.etage AS etage_15, t0.nb_etage AS nb_etage_16, t0.meuble AS meuble_17, t0.ascenseur AS ascenseur_18, t0.cave AS cave_19, t0.nb_parkings AS nb_parkings_20, t0.photo1 AS photo1_21, t0.photo2 AS photo2_22, t0.photo3 AS photo3_23, t0.photo4 AS photo4_24, t0.photo5 AS photo5_25, t0.photo6 AS photo6_26, t0.photo7 AS photo7_27, t0.photo8 AS photo8_28, t0.photo9 AS photo9_29, t0.titre_photo1 AS titre_photo1_30, t0.titre_photo2 AS titre_photo2_31, t0.titre_photo3 AS titre_photo3_32, t0.titre_photo4 AS titre_photo4_33, t0.titre_photo5 AS titre_photo5_34, t0.titre_photo6 AS titre_photo6_35, t0.titre_photo7 AS titre_photo7_36, t0.titre_photo8 AS titre_photo8_37, t0.titre_photo9 AS titre_photo9_38, t0.latitude AS latitude_39, t0.longitude AS longitude_40, t0.ref_agencebien AS ref_agencebien_41, t0.is_enabled AS is_enabled_42, t0.coup_coeur AS coup_coeur_43 FROM bien t0 WHERE t0.ville = 'ASC';

SELECT
  t0.id AS id_1,
  t0.site_name AS site_name_2,
  t0.site_description AS site_description_3,
  t0.site_keywords AS site_keywords_4,
  t0.site_url AS site_url_5,
  t0.site_urlfull AS site_urlfull_6,
  t0.site_logo AS site_logo_7,
  t0.site_email AS site_email_8,
  t0.site_adresse AS site_adresse_9,
  t0.site_cp AS site_cp_10,
  t0.site_ville AS site_ville_11,
  t0.site_telephone AS site_telephone_12,
  t0.site_cpi AS site_cpi_13,
  t0.site_instagram AS site_instagram_14,
  t0.site_facebook AS site_facebook_15,
  t0.site_mentionslegales AS site_mentionslegales_16,
  t0.site_googlemap AS site_googlemap_17,
  t0.site_twitter AS site_twitter_18,
  t0.page_equipetitle AS page_equipetitle_19,
  t0.page_equipesubtitle AS page_equipesubtitle_20,
  t0.page_coupcoeurtitle AS page_coupcoeurtitle_21
FROM
  setting t0

SELECT t0.id AS id_1, t0.site_name AS site_name_2, t0.site_description AS site_description_3, t0.site_keywords AS site_keywords_4, t0.site_url AS site_url_5, t0.site_urlfull AS site_urlfull_6, t0.site_logo AS site_logo_7, t0.site_email AS site_email_8, t0.site_adresse AS site_adresse_9, t0.site_cp AS site_cp_10, t0.site_ville AS site_ville_11, t0.site_telephone AS site_telephone_12, t0.site_cpi AS site_cpi_13, t0.site_instagram AS site_instagram_14, t0.site_facebook AS site_facebook_15, t0.site_mentionslegales AS site_mentionslegales_16, t0.site_googlemap AS site_googlemap_17, t0.site_twitter AS site_twitter_18, t0.page_equipetitle AS page_equipetitle_19, t0.page_equipesubtitle AS page_equipesubtitle_20, t0.page_coupcoeurtitle AS page_coupcoeurtitle_21 FROM setting t0;