Symfony Profiler

SELECT
  b0_.slug AS slug_0,
  b0_.id AS id_1,
  b0_.adresse AS adresse_2,
  b0_.adresse3_words AS adresse3_words_3,
  b0_.latitude AS latitude_4,
  b0_.longitude AS longitude_5,
  b0_.est_pro AS est_pro_6,
  b0_.est_bloque AS est_bloque_7,
  b0_.date_premium AS date_premium_8,
  b0_.horaire_douverture AS horaire_douverture_9,
  b0_.adresse_gpslat AS adresse_gpslat_10,
  b0_.adresse_gpslong AS adresse_gpslong_11,
  b0_.la_date AS la_date_12,
  b0_.nombre_avis AS nombre_avis_13,
  b0_.moyenne_avis AS moyenne_avis_14,
  b0_.nom AS nom_15,
  b0_.moyenne_note AS moyenne_note_16,
  b0_.nombre_de_visite AS nombre_de_visite_17,
  b0_.est_certifie AS est_certifie_18,
  b0_.est_supprime AS est_supprime_19,
  b0_.sigle AS sigle_20,
  b0_.email AS email_21,
  b0_.phone AS phone_22,
  b0_.code_postal AS code_postal_23,
  b0_.ville AS ville_24,
  b0_.site_web AS site_web_25,
  b0_.description AS description_26,
  b0_.fax AS fax_27,
  b0_.statut_juridique AS statut_juridique_28,
  b0_.capital AS capital_29,
  b0_.matricule AS matricule_30,
  b0_.siret AS siret_31,
  b0_.ape AS ape_32,
  b0_.cc AS cc_33,
  b0_.facture_tva AS facture_tva_34,
  b0_.mention_legal AS mention_legal_35,
  b0_.banque AS banque_36,
  b0_.rib AS rib_37,
  b0_.iban AS iban_38,
  b0_.bic AS bic_39,
  b0_.annee AS annee_40,
  b0_.mois AS mois_41,
  b0_.qualification AS qualification_42,
  b0_.disponibilite AS disponibilite_43,
  b0_.gamme_de_prix AS gamme_de_prix_44,
  b0_.main_d_oeuvre AS main_d_oeuvre_45,
  b0_.zone_d_intervention AS zone_d_intervention_46,
  c1_.slug AS slug_47,
  c1_.id AS id_48,
  c1_.nom AS nom_49,
  c1_.nombre_element AS nombre_element_50,
  c1_.description AS description_51,
  c1_.phrase_d_appel AS phrase_d_appel_52,
  c1_.est_supprime AS est_supprime_53,
  p2_.id AS id_54,
  p2_.url AS url_55,
  p2_.full_url AS full_url_56,
  p2_.alt AS alt_57,
  p2_.date_ajout AS date_ajout_58,
  p2_.est_valide AS est_valide_59,
  p3_.id AS id_60,
  p3_.url AS url_61,
  p3_.full_url AS full_url_62,
  p3_.alt AS alt_63,
  p3_.date_ajout AS date_ajout_64,
  p3_.est_valide AS est_valide_65,
  p4_.id AS id_66,
  p4_.url AS url_67,
  p4_.full_url AS full_url_68,
  p4_.alt AS alt_69,
  p4_.date_ajout AS date_ajout_70,
  p4_.est_valide AS est_valide_71
FROM
  boutique b0_
  LEFT JOIN categorie_entreprise c1_ ON b0_.categorie_entreprise_id = c1_.id
  LEFT JOIN photo p2_ ON b0_.logo_id = p2_.id
  LEFT JOIN photo p3_ ON b0_.video_presentation_id = p3_.id
  LEFT JOIN photo p4_ ON b0_.cover_photo_id = p4_.id
WHERE
  c1_.id = ?
  AND b0_.est_supprime = 0
ORDER BY
  b0_.nom ASC

SELECT b0_.slug AS slug_0, b0_.id AS id_1, b0_.adresse AS adresse_2, b0_.adresse3_words AS adresse3_words_3, b0_.latitude AS latitude_4, b0_.longitude AS longitude_5, b0_.est_pro AS est_pro_6, b0_.est_bloque AS est_bloque_7, b0_.date_premium AS date_premium_8, b0_.horaire_douverture AS horaire_douverture_9, b0_.adresse_gpslat AS adresse_gpslat_10, b0_.adresse_gpslong AS adresse_gpslong_11, b0_.la_date AS la_date_12, b0_.nombre_avis AS nombre_avis_13, b0_.moyenne_avis AS moyenne_avis_14, b0_.nom AS nom_15, b0_.moyenne_note AS moyenne_note_16, b0_.nombre_de_visite AS nombre_de_visite_17, b0_.est_certifie AS est_certifie_18, b0_.est_supprime AS est_supprime_19, b0_.sigle AS sigle_20, b0_.email AS email_21, b0_.phone AS phone_22, b0_.code_postal AS code_postal_23, b0_.ville AS ville_24, b0_.site_web AS site_web_25, b0_.description AS description_26, b0_.fax AS fax_27, b0_.statut_juridique AS statut_juridique_28, b0_.capital AS capital_29, b0_.matricule AS matricule_30, b0_.siret AS siret_31, b0_.ape AS ape_32, b0_.cc AS cc_33, b0_.facture_tva AS facture_tva_34, b0_.mention_legal AS mention_legal_35, b0_.banque AS banque_36, b0_.rib AS rib_37, b0_.iban AS iban_38, b0_.bic AS bic_39, b0_.annee AS annee_40, b0_.mois AS mois_41, b0_.qualification AS qualification_42, b0_.disponibilite AS disponibilite_43, b0_.gamme_de_prix AS gamme_de_prix_44, b0_.main_d_oeuvre AS main_d_oeuvre_45, b0_.zone_d_intervention AS zone_d_intervention_46, c1_.slug AS slug_47, c1_.id AS id_48, c1_.nom AS nom_49, c1_.nombre_element AS nombre_element_50, c1_.description AS description_51, c1_.phrase_d_appel AS phrase_d_appel_52, c1_.est_supprime AS est_supprime_53, p2_.id AS id_54, p2_.url AS url_55, p2_.full_url AS full_url_56, p2_.alt AS alt_57, p2_.date_ajout AS date_ajout_58, p2_.est_valide AS est_valide_59, p3_.id AS id_60, p3_.url AS url_61, p3_.full_url AS full_url_62, p3_.alt AS alt_63, p3_.date_ajout AS date_ajout_64, p3_.est_valide AS est_valide_65, p4_.id AS id_66, p4_.url AS url_67, p4_.full_url AS full_url_68, p4_.alt AS alt_69, p4_.date_ajout AS date_ajout_70, p4_.est_valide AS est_valide_71 FROM boutique b0_ LEFT JOIN categorie_entreprise c1_ ON b0_.categorie_entreprise_id = c1_.id LEFT JOIN photo p2_ ON b0_.logo_id = p2_.id LEFT JOIN photo p3_ ON b0_.video_presentation_id = p3_.id LEFT JOIN photo p4_ ON b0_.cover_photo_id = p4_.id WHERE c1_.id = '42' AND b0_.est_supprime = 0 ORDER BY b0_.nom ASC;