Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.email AS email_2,
  t0.roles AS roles_3,
  t0.password AS password_4,
  t0.notification AS notification_5,
  t0.hide_account AS hide_account_6,
  t0.hide_entreprise AS hide_entreprise_7,
  t0.all_programmes AS all_programmes_8,
  t0.couleur AS couleur_9,
  t0.telephone AS telephone_10,
  t0.nom AS nom_11,
  t0.prenom AS prenom_12,
  t0.prescripteur_coordonnees_responsable AS prescripteur_coordonnees_responsable_13,
  t0.peut_modifier AS peut_modifier_14,
  t0.entreprise_id AS entreprise_id_15
FROM
  utilisateur t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.notification AS notification_5, t0.hide_account AS hide_account_6, t0.hide_entreprise AS hide_entreprise_7, t0.all_programmes AS all_programmes_8, t0.couleur AS couleur_9, t0.telephone AS telephone_10, t0.nom AS nom_11, t0.prenom AS prenom_12, t0.prescripteur_coordonnees_responsable AS prescripteur_coordonnees_responsable_13, t0.peut_modifier AS peut_modifier_14, t0.entreprise_id AS entreprise_id_15 FROM utilisateur t0 WHERE t0.id = 12;

SELECT
  COUNT(*) AS dctrn_count
FROM
  (
    SELECT
      DISTINCT id_0
    FROM
      (
        SELECT
          u0_.id AS id_0,
          u0_.email AS email_1,
          u0_.roles AS roles_2,
          u0_.password AS password_3,
          u0_.notification AS notification_4,
          u0_.hide_account AS hide_account_5,
          u0_.hide_entreprise AS hide_entreprise_6,
          u0_.all_programmes AS all_programmes_7,
          u0_.couleur AS couleur_8,
          u0_.telephone AS telephone_9,
          u0_.nom AS nom_10,
          u0_.prenom AS prenom_11,
          u0_.prescripteur_coordonnees_responsable AS prescripteur_coordonnees_responsable_12,
          u0_.peut_modifier AS peut_modifier_13
        FROM
          utilisateur u0_
          INNER JOIN entreprise e1_ ON u0_.entreprise_id = e1_.id
        WHERE
          e1_.id = ?
          AND u0_.hide_entreprise = 0
          AND u0_.roles NOT LIKE ?
          AND (
            u0_.roles NOT LIKE ?
            AND u0_.roles NOT LIKE ?
          )
        ORDER BY
          e1_.nom ASC,
          u0_.id ASC
      ) dctrn_result
  ) dctrn_table

SELECT COUNT(*) AS dctrn_count FROM (SELECT DISTINCT id_0 FROM (SELECT u0_.id AS id_0, u0_.email AS email_1, u0_.roles AS roles_2, u0_.password AS password_3, u0_.notification AS notification_4, u0_.hide_account AS hide_account_5, u0_.hide_entreprise AS hide_entreprise_6, u0_.all_programmes AS all_programmes_7, u0_.couleur AS couleur_8, u0_.telephone AS telephone_9, u0_.nom AS nom_10, u0_.prenom AS prenom_11, u0_.prescripteur_coordonnees_responsable AS prescripteur_coordonnees_responsable_12, u0_.peut_modifier AS peut_modifier_13 FROM utilisateur u0_ INNER JOIN entreprise e1_ ON u0_.entreprise_id = e1_.id WHERE e1_.id = 4 AND u0_.hide_entreprise = 0 AND u0_.roles NOT LIKE '%\"ROLE_MASTER\"%' AND (u0_.roles NOT LIKE '%\"ROLE_PARTENAIRE\"%' AND u0_.roles NOT LIKE '%\"ROLE_RESPONSABLE\"%') ORDER BY e1_.nom ASC, u0_.id ASC) dctrn_result) dctrn_table;

SELECT
  DISTINCT id_0
FROM
  (
    SELECT
      DISTINCT id_0,
      nom_15
    FROM
      (
        SELECT
          u0_.id AS id_0,
          u0_.email AS email_1,
          u0_.roles AS roles_2,
          u0_.password AS password_3,
          u0_.notification AS notification_4,
          u0_.hide_account AS hide_account_5,
          u0_.hide_entreprise AS hide_entreprise_6,
          u0_.all_programmes AS all_programmes_7,
          u0_.couleur AS couleur_8,
          u0_.telephone AS telephone_9,
          u0_.nom AS nom_10,
          u0_.prenom AS prenom_11,
          u0_.prescripteur_coordonnees_responsable AS prescripteur_coordonnees_responsable_12,
          u0_.peut_modifier AS peut_modifier_13,
          e1_.id AS id_14,
          e1_.nom AS nom_15
        FROM
          utilisateur u0_
          INNER JOIN entreprise e1_ ON u0_.entreprise_id = e1_.id
        WHERE
          e1_.id = ?
          AND u0_.hide_entreprise = 0
          AND u0_.roles NOT LIKE ?
          AND (
            u0_.roles NOT LIKE ?
            AND u0_.roles NOT LIKE ?
          )
      ) dctrn_result_inner
    ORDER BY
      nom_15 ASC,
      id_0 ASC
  ) dctrn_result
LIMIT
  250

SELECT DISTINCT id_0 FROM (SELECT DISTINCT id_0, nom_15 FROM (SELECT u0_.id AS id_0, u0_.email AS email_1, u0_.roles AS roles_2, u0_.password AS password_3, u0_.notification AS notification_4, u0_.hide_account AS hide_account_5, u0_.hide_entreprise AS hide_entreprise_6, u0_.all_programmes AS all_programmes_7, u0_.couleur AS couleur_8, u0_.telephone AS telephone_9, u0_.nom AS nom_10, u0_.prenom AS prenom_11, u0_.prescripteur_coordonnees_responsable AS prescripteur_coordonnees_responsable_12, u0_.peut_modifier AS peut_modifier_13, e1_.id AS id_14, e1_.nom AS nom_15 FROM utilisateur u0_ INNER JOIN entreprise e1_ ON u0_.entreprise_id = e1_.id WHERE e1_.id = 4 AND u0_.hide_entreprise = 0 AND u0_.roles NOT LIKE '%\"ROLE_MASTER\"%' AND (u0_.roles NOT LIKE '%\"ROLE_PARTENAIRE\"%' AND u0_.roles NOT LIKE '%\"ROLE_RESPONSABLE\"%')) dctrn_result_inner ORDER BY nom_15 ASC, id_0 ASC) dctrn_result LIMIT 250;

SELECT
  u0_.id AS id_0,
  u0_.email AS email_1,
  u0_.roles AS roles_2,
  u0_.password AS password_3,
  u0_.notification AS notification_4,
  u0_.hide_account AS hide_account_5,
  u0_.hide_entreprise AS hide_entreprise_6,
  u0_.all_programmes AS all_programmes_7,
  u0_.couleur AS couleur_8,
  u0_.telephone AS telephone_9,
  u0_.nom AS nom_10,
  u0_.prenom AS prenom_11,
  u0_.prescripteur_coordonnees_responsable AS prescripteur_coordonnees_responsable_12,
  u0_.peut_modifier AS peut_modifier_13,
  u0_.entreprise_id AS entreprise_id_14
FROM
  utilisateur u0_
  INNER JOIN entreprise e1_ ON u0_.entreprise_id = e1_.id
WHERE
  e1_.id = ?
  AND u0_.hide_entreprise = 0
  AND u0_.roles NOT LIKE ?
  AND (
    u0_.roles NOT LIKE ?
    AND u0_.roles NOT LIKE ?
  )
  AND u0_.id IN (?, ?, ?, ?, ?, ?, ?)
ORDER BY
  e1_.nom ASC,
  u0_.id ASC

SELECT u0_.id AS id_0, u0_.email AS email_1, u0_.roles AS roles_2, u0_.password AS password_3, u0_.notification AS notification_4, u0_.hide_account AS hide_account_5, u0_.hide_entreprise AS hide_entreprise_6, u0_.all_programmes AS all_programmes_7, u0_.couleur AS couleur_8, u0_.telephone AS telephone_9, u0_.nom AS nom_10, u0_.prenom AS prenom_11, u0_.prescripteur_coordonnees_responsable AS prescripteur_coordonnees_responsable_12, u0_.peut_modifier AS peut_modifier_13, u0_.entreprise_id AS entreprise_id_14 FROM utilisateur u0_ INNER JOIN entreprise e1_ ON u0_.entreprise_id = e1_.id WHERE e1_.id = 4 AND u0_.hide_entreprise = 0 AND u0_.roles NOT LIKE '%\"ROLE_MASTER\"%' AND (u0_.roles NOT LIKE '%\"ROLE_PARTENAIRE\"%' AND u0_.roles NOT LIKE '%\"ROLE_RESPONSABLE\"%') AND u0_.id IN (12, 24, 25, 26, 27, 31, 35) ORDER BY e1_.nom ASC, u0_.id ASC;

SELECT
  t0.id AS id_1,
  t0.nom AS nom_2,
  t0.email AS email_3,
  t0.telephone AS telephone_4,
  t0.adresse AS adresse_5,
  t0.website AS website_6,
  t0.logo AS logo_7,
  t0.logo_admin AS logo_admin_8,
  t0.updated_at AS updated_at_9,
  t0.available_roles AS available_roles_10
FROM
  entreprise t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.nom AS nom_2, t0.email AS email_3, t0.telephone AS telephone_4, t0.adresse AS adresse_5, t0.website AS website_6, t0.logo AS logo_7, t0.logo_admin AS logo_admin_8, t0.updated_at AS updated_at_9, t0.available_roles AS available_roles_10 FROM entreprise t0 WHERE t0.id = 4;

SELECT
  t0.id AS id_1,
  t0.type AS type_2,
  t0.description AS description_3,
  t0.date AS date_4,
  t0.lu AS lu_5,
  t0.utilisateur_id AS utilisateur_id_6,
  t0.auteur_id AS auteur_id_7,
  t0.connected_user_id AS connected_user_id_8,
  t0.historique_id AS historique_id_9,
  t0.programme_id AS programme_id_10
FROM
  infos_suivi t0
WHERE
  t0.utilisateur_id = ?

SELECT t0.id AS id_1, t0.type AS type_2, t0.description AS description_3, t0.date AS date_4, t0.lu AS lu_5, t0.utilisateur_id AS utilisateur_id_6, t0.auteur_id AS auteur_id_7, t0.connected_user_id AS connected_user_id_8, t0.historique_id AS historique_id_9, t0.programme_id AS programme_id_10 FROM infos_suivi t0 WHERE t0.utilisateur_id = 12;