Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.username_user AS username_user_2,
  t0.nom_user AS nom_user_3,
  t0.prenoms_user AS prenoms_user_4,
  t0.email_user AS email_user_5,
  t0.tel1_user AS tel1_user_6,
  t0.tel2_user AS tel2_user_7,
  t0.bp AS bp_8,
  t0.adresse_user AS adresse_user_9,
  t0.etat_user AS etat_user_10,
  t0.attempt_user AS attempt_user_11,
  t0.password_user AS password_user_12,
  t0.c_password_user AS c_password_user_13,
  t0.salt_user AS salt_user_14,
  t0.etat_connecte AS etat_connecte_15,
  t0.adresse_ip_user AS adresse_ip_user_16,
  t0.sexe_user AS sexe_user_17,
  t0.date_ajout_user AS date_ajout_user_18,
  t0.date_edit_user AS date_edit_user_19,
  t0.loss_password_url_user AS loss_password_url_user_20,
  t0.date_loss_password_user AS date_loss_password_user_21,
  t0.date_naissance AS date_naissance_22,
  t0.date_synchronisation AS date_synchronisation_23,
  t0.type_prod_user AS type_prod_user_24,
  t0.si_chef AS si_chef_25,
  t0.code_genere AS code_genere_26,
  t0.site_web AS site_web_27,
  t0.cni AS cni_28,
  t0.cout AS cout_29,
  t0.commission AS commission_30,
  t0.type_utilisateur AS type_utilisateur_31,
  t0.roles AS roles_32,
  t0.profil_id AS profil_id_33,
  t0.ville_id AS ville_id_34,
  t0.entrepot_id AS entrepot_id_35,
  t0.caisse_id AS caisse_id_36,
  t0.abonne_id AS abonne_id_37
FROM
  utilisateur t0
WHERE
  t0.username_user = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.username_user AS username_user_2, t0.nom_user AS nom_user_3, t0.prenoms_user AS prenoms_user_4, t0.email_user AS email_user_5, t0.tel1_user AS tel1_user_6, t0.tel2_user AS tel2_user_7, t0.bp AS bp_8, t0.adresse_user AS adresse_user_9, t0.etat_user AS etat_user_10, t0.attempt_user AS attempt_user_11, t0.password_user AS password_user_12, t0.c_password_user AS c_password_user_13, t0.salt_user AS salt_user_14, t0.etat_connecte AS etat_connecte_15, t0.adresse_ip_user AS adresse_ip_user_16, t0.sexe_user AS sexe_user_17, t0.date_ajout_user AS date_ajout_user_18, t0.date_edit_user AS date_edit_user_19, t0.loss_password_url_user AS loss_password_url_user_20, t0.date_loss_password_user AS date_loss_password_user_21, t0.date_naissance AS date_naissance_22, t0.date_synchronisation AS date_synchronisation_23, t0.type_prod_user AS type_prod_user_24, t0.si_chef AS si_chef_25, t0.code_genere AS code_genere_26, t0.site_web AS site_web_27, t0.cni AS cni_28, t0.cout AS cout_29, t0.commission AS commission_30, t0.type_utilisateur AS type_utilisateur_31, t0.roles AS roles_32, t0.profil_id AS profil_id_33, t0.ville_id AS ville_id_34, t0.entrepot_id AS entrepot_id_35, t0.caisse_id AS caisse_id_36, t0.abonne_id AS abonne_id_37 FROM utilisateur t0 WHERE t0.username_user = 'alagunes' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.nom AS nom_2,
  t0.code_base_abonne AS code_base_abonne_3,
  t0.email_abonne AS email_abonne_4,
  t0.tel1_abonne AS tel1_abonne_5,
  t0.tel2_abonne AS tel2_abonne_6,
  t0.adresse_abonne AS adresse_abonne_7,
  t0.description_abonne AS description_abonne_8,
  t0.etat_abonne AS etat_abonne_9,
  t0.siExploitation AS siExploitation_10,
  t0.si_principale AS si_principale_11,
  t0.type_action_abonne AS type_action_abonne_12,
  t0.adresse_web AS adresse_web_13,
  t0.date_ajout_abonne AS date_ajout_abonne_14,
  t0.date_edit_abonne AS date_edit_abonne_15,
  t0.titre_image AS titre_image_16,
  t0.url_image AS url_image_17,
  t0.type_presentation AS type_presentation_18,
  t0.langue AS langue_19,
  t0.configuration AS configuration_20,
  t0.type_abonne_id AS type_abonne_id_21,
  t0.template_id AS template_id_22,
  t0.partenaire_id AS partenaire_id_23,
  t0.devise_id AS devise_id_24,
  t0.pays_id AS pays_id_25
FROM
  abonne t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.nom AS nom_2, t0.code_base_abonne AS code_base_abonne_3, t0.email_abonne AS email_abonne_4, t0.tel1_abonne AS tel1_abonne_5, t0.tel2_abonne AS tel2_abonne_6, t0.adresse_abonne AS adresse_abonne_7, t0.description_abonne AS description_abonne_8, t0.etat_abonne AS etat_abonne_9, t0.siExploitation AS siExploitation_10, t0.si_principale AS si_principale_11, t0.type_action_abonne AS type_action_abonne_12, t0.adresse_web AS adresse_web_13, t0.date_ajout_abonne AS date_ajout_abonne_14, t0.date_edit_abonne AS date_edit_abonne_15, t0.titre_image AS titre_image_16, t0.url_image AS url_image_17, t0.type_presentation AS type_presentation_18, t0.langue AS langue_19, t0.configuration AS configuration_20, t0.type_abonne_id AS type_abonne_id_21, t0.template_id AS template_id_22, t0.partenaire_id AS partenaire_id_23, t0.devise_id AS devise_id_24, t0.pays_id AS pays_id_25 FROM abonne t0 WHERE t0.id = 94;

SELECT
  l0_.id AS id_0,
  l0_.latitude AS latitude_1,
  l0_.longitude AS longitude_2,
  l0_.type_localisation AS type_localisation_3,
  l0_.code_genere AS code_genere_4,
  s1_.code_genere AS code_genere_5,
  0 AS sclr_6,
  3 AS sclr_7,
  u2_.nom_user AS nom_user_8,
  u2_.prenoms_user AS prenoms_user_9,
  l0_.tab_polygone AS tab_polygone_10
FROM
  localisation l0_
  INNER JOIN surface_annee s1_ ON l0_.surfaceannee_id = s1_.id
  INNER JOIN producteur p3_ ON s1_.producteur_id = p3_.id
  INNER JOIN utilisateur u2_ ON p3_.utilisateur_id = u2_.id
  INNER JOIN producteur_abonne p4_ ON p3_.id = p4_.producteur_id
  INNER JOIN abonne a5_ ON p4_.abonne_id = a5_.id
  INNER JOIN zone_producteur z6_ ON p3_.id = z6_.producteur_id
  LEFT JOIN ville v7_ ON z6_.ville_id = v7_.id
WHERE
  1 = 1
  AND p3_.etat_prod <> ?
  AND s1_.etat_surface_annee <> ?
  AND a5_.id = ?
ORDER BY
  p3_.id DESC

SELECT l0_.id AS id_0, l0_.latitude AS latitude_1, l0_.longitude AS longitude_2, l0_.type_localisation AS type_localisation_3, l0_.code_genere AS code_genere_4, s1_.code_genere AS code_genere_5, 0 AS sclr_6, 3 AS sclr_7, u2_.nom_user AS nom_user_8, u2_.prenoms_user AS prenoms_user_9, l0_.tab_polygone AS tab_polygone_10 FROM localisation l0_ INNER JOIN surface_annee s1_ ON l0_.surfaceannee_id = s1_.id INNER JOIN producteur p3_ ON s1_.producteur_id = p3_.id INNER JOIN utilisateur u2_ ON p3_.utilisateur_id = u2_.id INNER JOIN producteur_abonne p4_ ON p3_.id = p4_.producteur_id INNER JOIN abonne a5_ ON p4_.abonne_id = a5_.id INNER JOIN zone_producteur z6_ ON p3_.id = z6_.producteur_id LEFT JOIN ville v7_ ON z6_.ville_id = v7_.id WHERE 1 = 1 AND p3_.etat_prod <> 2 AND s1_.etat_surface_annee <> 2 AND a5_.id = '94' ORDER BY p3_.id DESC;