Symfony Profiler

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 = 148
                        AND r.isactif = 1  AND f.isactif = 1 AND g.isactif = 1
                  
            ;

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 = 148;

SELECT
  s0_.id AS id_0,
  s0_.denomination_sociale AS denomination_sociale_1,
  s0_.nom_commercial AS nom_commercial_2,
  s0_.activite_sociale AS activite_sociale_3,
  s0_.activite_complementaire AS activite_complementaire_4,
  s0_.sigle AS sigle_5,
  s0_.enseigne AS enseigne_6,
  s0_.adresse_siege AS adresse_siege_7,
  s0_.adresse_etablissement AS adresse_etablissement_8,
  s0_.boite_postale AS boite_postale_9,
  s0_.telephone AS telephone_10,
  s0_.telephone2 AS telephone2_11,
  s0_.email AS email_12,
  s0_.nombre_salarie_prevu AS nombre_salarie_prevu_13,
  s0_.valeur_nominale AS valeur_nominale_14,
  s0_.capital_social AS capital_social_15,
  s0_.apport_numeraire AS apport_numeraire_16,
  s0_.apport_nature AS apport_nature_17,
  s0_.apport_industrie AS apport_industrie_18,
  s0_.date_creation AS date_creation_19,
  s0_.date_validation AS date_validation_20,
  s0_.array_dirigent AS array_dirigent_21,
  s0_.array_present AS array_present_22,
  s0_.secretaire AS secretaire_23,
  s0_.president AS president_24,
  s0_.date_fin_reunion AS date_fin_reunion_25,
  s0_.date_ouverture_debat AS date_ouverture_debat_26,
  s0_.is_brouillon AS is_brouillon_27,
  s0_.is_soumise AS is_soumise_28,
  s0_.is_validate AS is_validate_29,
  s0_.is_quittance AS is_quittance_30,
  s0_.is_modification AS is_modification_31,
  s0_.array_associe AS array_associe_32,
  s0_.motif_modification AS motif_modification_33,
  s0_.duree_mandat AS duree_mandat_34,
  s0_.mandat AS mandat_35,
  s0_.date_ouverture AS date_ouverture_36,
  s0_.is_aguipe AS is_aguipe_37,
  s0_.coordonees_latitude AS coordonees_latitude_38,
  s0_.coordonees_longitude AS coordonees_longitude_39,
  s0_.chiffre_affaire_previsionnel AS chiffre_affaire_previsionnel_40,
  s0_.form_juridique_id AS form_juridique_id_41,
  s0_.pays_id AS pays_id_42,
  s0_.region_id AS region_id_43,
  s0_.prefecture_id AS prefecture_id_44,
  s0_.sous_prefecture_id AS sous_prefecture_id_45,
  s0_.quartier_id AS quartier_id_46,
  s0_.secteur_activite_id AS secteur_activite_id_47,
  s0_.banque_id AS banque_id_48,
  s0_.user_id AS user_id_49,
  s0_.model_pv_id AS model_pv_id_50
FROM
  statut s0_
  INNER JOIN utilisateur u1_ ON s0_.user_id = u1_.id
WHERE
  u1_.id = ?
  AND s0_.is_modification = 1
  AND s0_.is_soumise = 0
  AND s0_.is_validate = 0
  AND s0_.is_brouillon = 0
ORDER BY
  s0_.date_creation DESC

SELECT s0_.id AS id_0, s0_.denomination_sociale AS denomination_sociale_1, s0_.nom_commercial AS nom_commercial_2, s0_.activite_sociale AS activite_sociale_3, s0_.activite_complementaire AS activite_complementaire_4, s0_.sigle AS sigle_5, s0_.enseigne AS enseigne_6, s0_.adresse_siege AS adresse_siege_7, s0_.adresse_etablissement AS adresse_etablissement_8, s0_.boite_postale AS boite_postale_9, s0_.telephone AS telephone_10, s0_.telephone2 AS telephone2_11, s0_.email AS email_12, s0_.nombre_salarie_prevu AS nombre_salarie_prevu_13, s0_.valeur_nominale AS valeur_nominale_14, s0_.capital_social AS capital_social_15, s0_.apport_numeraire AS apport_numeraire_16, s0_.apport_nature AS apport_nature_17, s0_.apport_industrie AS apport_industrie_18, s0_.date_creation AS date_creation_19, s0_.date_validation AS date_validation_20, s0_.array_dirigent AS array_dirigent_21, s0_.array_present AS array_present_22, s0_.secretaire AS secretaire_23, s0_.president AS president_24, s0_.date_fin_reunion AS date_fin_reunion_25, s0_.date_ouverture_debat AS date_ouverture_debat_26, s0_.is_brouillon AS is_brouillon_27, s0_.is_soumise AS is_soumise_28, s0_.is_validate AS is_validate_29, s0_.is_quittance AS is_quittance_30, s0_.is_modification AS is_modification_31, s0_.array_associe AS array_associe_32, s0_.motif_modification AS motif_modification_33, s0_.duree_mandat AS duree_mandat_34, s0_.mandat AS mandat_35, s0_.date_ouverture AS date_ouverture_36, s0_.is_aguipe AS is_aguipe_37, s0_.coordonees_latitude AS coordonees_latitude_38, s0_.coordonees_longitude AS coordonees_longitude_39, s0_.chiffre_affaire_previsionnel AS chiffre_affaire_previsionnel_40, s0_.form_juridique_id AS form_juridique_id_41, s0_.pays_id AS pays_id_42, s0_.region_id AS region_id_43, s0_.prefecture_id AS prefecture_id_44, s0_.sous_prefecture_id AS sous_prefecture_id_45, s0_.quartier_id AS quartier_id_46, s0_.secteur_activite_id AS secteur_activite_id_47, s0_.banque_id AS banque_id_48, s0_.user_id AS user_id_49, s0_.model_pv_id AS model_pv_id_50 FROM statut s0_ INNER JOIN utilisateur u1_ ON s0_.user_id = u1_.id WHERE u1_.id = 148 AND s0_.is_modification = 1 AND s0_.is_soumise = 0 AND s0_.is_validate = 0 AND s0_.is_brouillon = 0 ORDER BY s0_.date_creation DESC;

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.code AS code_2,
  t0.libelle AS libelle_3,
  t0.description AS description_4,
  t0.isactif AS isactif_5
FROM
  role t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.code AS code_2, t0.libelle AS libelle_3, t0.description AS description_4, t0.isactif AS isactif_5 FROM role t0 WHERE t0.id = 18;

SELECT
  t0.id AS id_1,
  t0.code AS code_2,
  t0.libelle AS libelle_3,
  t0.isactif AS isactif_4,
  t0.prefecture_id AS prefecture_id_5
FROM
  sous_prefecture t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.code AS code_2, t0.libelle AS libelle_3, t0.isactif AS isactif_4, t0.prefecture_id AS prefecture_id_5 FROM sous_prefecture t0 WHERE t0.id = 919;

SELECT
  t0.id AS id_1,
  t0.code AS code_2,
  t0.libelle AS libelle_3,
  t0.isactif AS isactif_4,
  t0.region_id AS region_id_5
FROM
  prefecture t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.code AS code_2, t0.libelle AS libelle_3, t0.isactif AS isactif_4, t0.region_id AS region_id_5 FROM prefecture t0 WHERE t0.id = 48;

SELECT
  t0.id AS id_1,
  t0.code AS code_2,
  t0.libelle AS libelle_3,
  t0.actif AS actif_4,
  t0.sous_prefecture_id AS sous_prefecture_id_5
FROM
  quartier t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.code AS code_2, t0.libelle AS libelle_3, t0.actif AS actif_4, t0.sous_prefecture_id AS sous_prefecture_id_5 FROM quartier t0 WHERE t0.id = 27;

SELECT
  t0.id AS id_1,
  t0.denomination AS denomination_2,
  t0.telephone AS telephone_3,
  t0.email AS email_4,
  t0.adresse AS adresse_5,
  t0.code AS code_6,
  t0.quartier_id AS quartier_id_7,
  t0.type_structure_id AS type_structure_id_8,
  t0.banque_id AS banque_id_9
FROM
  structure t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.denomination AS denomination_2, t0.telephone AS telephone_3, t0.email AS email_4, t0.adresse AS adresse_5, t0.code AS code_6, t0.quartier_id AS quartier_id_7, t0.type_structure_id AS type_structure_id_8, t0.banque_id AS banque_id_9 FROM structure t0 WHERE t0.id = 6;

SELECT
  t0.id AS id_1,
  t0.libelle AS libelle_2,
  t0.code AS code_3,
  t0.description AS description_4,
  t0.structure_id AS structure_id_5
FROM
  services t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.libelle AS libelle_2, t0.code AS code_3, t0.description AS description_4, t0.structure_id AS structure_id_5 FROM services t0 WHERE t0.id = 71;