Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.email AS email_2,
  t0.roles AS roles_3,
  t0.date_naissance AS date_naissance_4,
  t0.lieu_naissance AS lieu_naissance_5,
  t0.adresse AS adresse_6,
  t0.telephone AS telephone_7,
  t0.account_must_be_verified_before AS account_must_be_verified_before_8,
  t0.registration_token AS registration_token_9,
  t0.is_verified AS is_verified_10,
  t0.account_verified_at AS account_verified_at_11,
  t0.forgot_password_token AS forgot_password_token_12,
  t0.forgot_password_token_requested_at AS forgot_password_token_requested_at_13,
  t0.forgot_password_token_must_be_verified_before AS forgot_password_token_must_be_verified_before_14,
  t0.forgot_password_token_verified_at AS forgot_password_token_verified_at_15,
  t0.password AS password_16,
  t0.nom AS nom_17,
  t0.prenom AS prenom_18,
  t0.numero_piece_identite AS numero_piece_identite_19,
  t0.ville AS ville_20,
  t0.last_login AS last_login_21,
  t0.last_logout AS last_logout_22,
  t0.is_first_login AS is_first_login_23,
  t0.username AS username_24,
  t0.signature_file_name AS signature_file_name_25,
  t0.code_pin AS code_pin_26,
  t0.signataire_id AS signataire_id_27,
  t0.appelant_id AS appelant_id_28,
  t0.kyc_piece1 AS kyc_piece1_29,
  t0.kyc_piece2 AS kyc_piece2_30,
  t0.kyc_photo AS kyc_photo_31,
  t0.photo_profil AS photo_profil_32,
  t0.created_at AS created_at_33,
  t0.updated_at AS updated_at_34,
  t0.civilite_id AS civilite_id_35,
  t0.piece_itendite_id AS piece_itendite_id_36,
  t0.pays_id AS pays_id_37,
  t0.service_id AS service_id_38,
  t0.role_id AS role_id_39,
  t0.banque_id AS banque_id_40
FROM
  utilisateur t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.date_naissance AS date_naissance_4, t0.lieu_naissance AS lieu_naissance_5, t0.adresse AS adresse_6, t0.telephone AS telephone_7, t0.account_must_be_verified_before AS account_must_be_verified_before_8, t0.registration_token AS registration_token_9, t0.is_verified AS is_verified_10, t0.account_verified_at AS account_verified_at_11, t0.forgot_password_token AS forgot_password_token_12, t0.forgot_password_token_requested_at AS forgot_password_token_requested_at_13, t0.forgot_password_token_must_be_verified_before AS forgot_password_token_must_be_verified_before_14, t0.forgot_password_token_verified_at AS forgot_password_token_verified_at_15, t0.password AS password_16, t0.nom AS nom_17, t0.prenom AS prenom_18, t0.numero_piece_identite AS numero_piece_identite_19, t0.ville AS ville_20, t0.last_login AS last_login_21, t0.last_logout AS last_logout_22, t0.is_first_login AS is_first_login_23, t0.username AS username_24, t0.signature_file_name AS signature_file_name_25, t0.code_pin AS code_pin_26, t0.signataire_id AS signataire_id_27, t0.appelant_id AS appelant_id_28, t0.kyc_piece1 AS kyc_piece1_29, t0.kyc_piece2 AS kyc_piece2_30, t0.kyc_photo AS kyc_photo_31, t0.photo_profil AS photo_profil_32, t0.created_at AS created_at_33, t0.updated_at AS updated_at_34, t0.civilite_id AS civilite_id_35, t0.piece_itendite_id AS piece_itendite_id_36, t0.pays_id AS pays_id_37, t0.service_id AS service_id_38, t0.role_id AS role_id_39, t0.banque_id AS banque_id_40 FROM utilisateur t0 WHERE t0.id = 47;

SELECT
  d.id dossierDemand,
  d.numero_dossier numeroDossier,
  d.denomination_sociale denominationSociale,
  f.libelle formeJuridique,
  td.libelle typeDossier,
  st.denomination structure,
  d.date_retrait dateReception,
  (
    SELECT
      CONCAT(g.nom, ' ', g.prenom) AS premierGerant
    FROM
      gerant g
      INNER JOIN fonction ft ON g.fonction_id = ft.id
    WHERE
      ft.code = 'GR'
      AND g.demande_dossier_id = d.id
    ORDER BY
      g.id ASC
    LIMIT
      1
  ) AS premierGerant,
  (
    SELECT
      g.telephone1
    FROM
      gerant g
      INNER JOIN fonction ft ON g.fonction_id = ft.id
    WHERE
      ft.code = 'GR'
      AND g.demande_dossier_id = d.id
    ORDER BY
      g.id ASC
    LIMIT
      1
  ) AS telephoneGerant
FROM
  dossier_demande d
  INNER JOIN rccm r ON r.dossier_demande_id = d.id
  INNER JOIN form_juridique f ON d.forme_juridique_id = f.id
  INNER JOIN type_dossier td ON d.type_dossier_id = td.id
  INNER JOIN utilisateur u ON d.user_retrait_id = u.id
  INNER JOIN services s ON u.service_id = s.id
  INNER JOIN structure st ON s.structure_id = st.id
WHERE
  d.status_retrait = TRUE
  AND u.id = :agent
ORDER BY
  d.date_retrait DESC

SELECT  d.id dossierDemand, d.numero_dossier numeroDossier, d.denomination_sociale denominationSociale,
               f.libelle formeJuridique, td.libelle typeDossier,
               st.denomination structure, d.date_retrait dateReception,
               (
                   SELECT CONCAT(g.nom, ' ', g.prenom) AS premierGerant
                   FROM gerant g
                   INNER JOIN fonction ft ON g.fonction_id = ft.id
                   WHERE ft.code='GR' AND g.demande_dossier_id = d.id
                   ORDER BY g.id ASC
                   LIMIT 1
               ) AS premierGerant, (
                   SELECT g.telephone1
                   FROM gerant g
                   INNER JOIN fonction ft ON g.fonction_id = ft.id
                   WHERE ft.code='GR' AND g.demande_dossier_id = d.id
                   ORDER BY g.id ASC
                   LIMIT 1
               ) AS telephoneGerant
        FROM dossier_demande d
        INNER JOIN rccm r ON r.dossier_demande_id = d.id
        INNER JOIN form_juridique f ON d.forme_juridique_id = f.id
        INNER JOIN type_dossier td ON d.type_dossier_id = td.id
        INNER JOIN utilisateur u ON d.user_retrait_id = u.id
        INNER JOIN services s ON u.service_id = s.id
        INNER JOIN structure st ON s.structure_id = st.id
        WHERE d.status_retrait = TRUE
     AND u.id = 47 ORDER BY d.date_retrait DESC;

SELECT
  t0_.id AS id_0,
  t0_.code AS code_1,
  t0_.libelle AS libelle_2,
  t0_.isactif AS isactif_3
FROM
  type_dossier t0_

SELECT t0_.id AS id_0, t0_.code AS code_1, t0_.libelle AS libelle_2, t0_.isactif AS isactif_3 FROM type_dossier t0_;

SELECT
  s0_.id AS id_0,
  s0_.denomination AS denomination_1,
  s0_.telephone AS telephone_2,
  s0_.email AS email_3,
  s0_.adresse AS adresse_4,
  s0_.code AS code_5,
  s0_.quartier_id AS quartier_id_6,
  s0_.type_structure_id AS type_structure_id_7,
  s0_.banque_id AS banque_id_8
FROM
  structure s0_

SELECT s0_.id AS id_0, s0_.denomination AS denomination_1, s0_.telephone AS telephone_2, s0_.email AS email_3, s0_.adresse AS adresse_4, s0_.code AS code_5, s0_.quartier_id AS quartier_id_6, s0_.type_structure_id AS type_structure_id_7, s0_.banque_id AS banque_id_8 FROM structure s0_;

SELECT
  f0_.id AS id_0,
  f0_.libelle AS libelle_1,
  f0_.isactif AS isactif_2,
  f0_.sigle AS sigle_3
FROM
  form_juridique f0_
WHERE
  f0_.isactif = 1
ORDER BY
  f0_.libelle ASC

SELECT f0_.id AS id_0, f0_.libelle AS libelle_1, f0_.isactif AS isactif_2, f0_.sigle AS sigle_3 FROM form_juridique f0_ WHERE f0_.isactif = 1 ORDER BY f0_.libelle ASC;

SELECT
  f.libelle,
  f.id,
  f.route,
  f.icon
FROM
  reference r
  INNER JOIN fonctionnalite f ON f.reference_id = r.id
  INNER JOIN groupe_fonctionnalite gf ON gf.fonctionnalite_id = f.id
  INNER JOIN groupe g ON gf.groupe_id = g.id
  INNER JOIN user_groupe ug ON ug.groupe_id = g.id
  INNER JOIN utilisateur u ON ug.utilisateur_id = u.id
WHERE
  r.code = :typeMenu
  AND u.id = :user
  AND r.isactif = 1
  AND f.isactif = 1
  AND g.isactif = 1

SELECT f.libelle, f.id,f.route, f.icon
                    FROM reference r
                    INNER JOIN fonctionnalite f ON f.reference_id = r.id
                    INNER JOIN groupe_fonctionnalite gf ON gf.fonctionnalite_id = f.id
                    INNER JOIN groupe g ON gf.groupe_id = g.id 
                    INNER JOIN user_groupe ug ON ug.groupe_id = g.id
                    INNER JOIN utilisateur u ON ug.utilisateur_id = u.id
                    WHERE r.code = 'sidebarmenu' AND u.id = 47
                        AND r.isactif = 1  AND f.isactif = 1 AND g.isactif = 1
                  
            ;

SELECT
  t0.id AS id_1,
  t0.telephone AS telephone_2,
  t0.email AS email_3,
  t0.adresse AS adresse_4
FROM
  contact t0
ORDER BY
  t0.id ASC
LIMIT
  1

SELECT t0.id AS id_1, t0.telephone AS telephone_2, t0.email AS email_3, t0.adresse AS adresse_4 FROM contact t0 ORDER BY t0.id ASC LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.telephone AS telephone_2,
  t0.email AS email_3,
  t0.adresse AS adresse_4
FROM
  contact t0
ORDER BY
  t0.id ASC
LIMIT
  1

SELECT t0.id AS id_1, t0.telephone AS telephone_2, t0.email AS email_3, t0.adresse AS adresse_4 FROM contact t0 ORDER BY t0.id ASC LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.telephone AS telephone_2,
  t0.email AS email_3,
  t0.adresse AS adresse_4
FROM
  contact t0
ORDER BY
  t0.id ASC
LIMIT
  1

SELECT t0.id AS id_1, t0.telephone AS telephone_2, t0.email AS email_3, t0.adresse AS adresse_4 FROM contact t0 ORDER BY t0.id ASC LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.telephone AS telephone_2,
  t0.email AS email_3,
  t0.adresse AS adresse_4
FROM
  contact t0
ORDER BY
  t0.id ASC
LIMIT
  1

SELECT t0.id AS id_1, t0.telephone AS telephone_2, t0.email AS email_3, t0.adresse AS adresse_4 FROM contact t0 ORDER BY t0.id ASC LIMIT 1;