Symfony Profiler

SELECT
  d.numero_dossier AS numeroDossier,
  d.denomination_sociale AS denominationSociale,
  f.libelle AS formeJuridique,
  td.libelle AS typeDossier,
  st.denomination AS structure,
  (
    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
      CONCAT(agent.nom, ' ', agent.prenom) AS agentSaisie
    FROM
      utilisateur agent
    WHERE
      agent.id = d.utilisateur_id
    ORDER BY
      agent.id ASC
    LIMIT
      1
  ) AS agentSaisie,
  doc.date_soumission AS dateReception,
  d.date_creation,
  f.sigle,
  d.id AS dossier_id,
  pol.libelle,
  sj.id AS serviceJuridique,
  sj.date_depot AS dateDepotSJ,
  r.date AS dateDelivrance
FROM
  document_collected doc
  INNER JOIN dossier_demande d ON d.id = doc.dossier_demande_id
  LEFT JOIN service_juridique sj ON sj.id = d.service_juridique_id
  LEFT JOIN rccm r ON r.dossier_demande_id = d.id
  INNER JOIN type_structure pol ON pol.id = doc.pole_id
  LEFT JOIN statut_traitement stat ON doc.statut_traitement_id = stat.id
  INNER JOIN type_dossier td ON d.type_dossier_id = td.id
  INNER JOIN form_juridique f ON d.forme_juridique_id = f.id
  INNER JOIN utilisateur u ON d.utilisateur_id = u.id
  LEFT JOIN services s ON u.service_id = s.id
  LEFT JOIN structure st ON s.structure_id = st.id
WHERE
  pol.code = 'GF'
  AND stat.code = 'EC'
  AND (
    d.statut_validation_chef_greffe is null
  )
ORDER BY
  d.date_creation ASC

SELECT d.numero_dossier AS numeroDossier, d.denomination_sociale AS denominationSociale, f.libelle AS  formeJuridique, td.libelle AS typeDossier, st.denomination AS structure,
		(
			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 CONCAT(agent.nom, ' ', agent.prenom) AS agentSaisie
			FROM utilisateur agent
			WHERE agent.id = d.utilisateur_id 
			ORDER BY agent.id ASC
			LIMIT 1
		) AS agentSaisie, doc.date_soumission AS dateReception, d.date_creation , f.sigle, d.id AS dossier_id, pol.libelle, sj.id AS serviceJuridique,sj.date_depot AS dateDepotSJ, r.date AS dateDelivrance
		FROM document_collected doc 
		INNER JOIN dossier_demande d ON d.id = doc.dossier_demande_id
		LEFT JOIN service_juridique sj ON sj.id = d.service_juridique_id
		LEFT JOIN rccm r ON r.dossier_demande_id = d.id
		INNER JOIN type_structure pol ON pol.id= doc.pole_id
		LEFT  JOIN statut_traitement stat ON  doc.statut_traitement_id = stat.id
		INNER  JOIN type_dossier td ON d.type_dossier_id = td.id
		INNER JOIN form_juridique f ON d.forme_juridique_id = f.id
		INNER JOIN utilisateur u ON d.utilisateur_id = u.id
		LEFT  JOIN services s ON u.service_id = s.id
		LEFT  JOIN structure st ON s.structure_id = st.id
		WHERE pol.code ='GF'  AND stat.code = 'EC' AND (d.statut_validation_chef_greffe is null)  ORDER BY d.date_creation ASC;

SELECT
  d.numero_dossier AS numeroDossier,
  d.denomination_sociale AS denominationSociale,
  f.libelle AS formeJuridique,
  td.libelle AS typeDossier,
  st.denomination AS structure,
  (
    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
      CONCAT(agent.nom, ' ', agent.prenom) AS agentSaisie
    FROM
      utilisateur agent
    WHERE
      agent.id = d.utilisateur_id
    ORDER BY
      agent.id ASC
    LIMIT
      1
  ) AS agentSaisie,
  doc.date_soumission AS dateReception,
  d.date_creation,
  f.sigle,
  d.id AS dossier_id,
  pol.libelle,
  sj.id AS serviceJuridique,
  sj.date_depot AS dateDepotSJ,
  r.date AS dateDelivrance
FROM
  document_collected doc
  INNER JOIN dossier_demande d ON d.id = doc.dossier_demande_id
  LEFT JOIN service_juridique sj ON sj.id = d.service_juridique_id
  LEFT JOIN rccm r ON r.dossier_demande_id = d.id
  INNER JOIN type_structure pol ON pol.id = doc.pole_id
  LEFT JOIN statut_traitement stat ON doc.statut_traitement_id = stat.id
  INNER JOIN type_dossier td ON d.type_dossier_id = td.id
  INNER JOIN form_juridique f ON d.forme_juridique_id = f.id
  INNER JOIN utilisateur u ON d.utilisateur_id = u.id
  LEFT JOIN services s ON u.service_id = s.id
  LEFT JOIN structure st ON s.structure_id = st.id
WHERE
  pol.code = 'GF'
  AND (
    stat.code = 'EC'
    or stat.code = 'DD'
  )
  AND d.statut_validation_chef_greffe is not null
  and d.statut_validation_chef_greffe != :idStatutTraitement
ORDER BY
  d.date_creation DESC

SELECT d.numero_dossier AS numeroDossier, d.denomination_sociale AS denominationSociale, f.libelle AS  formeJuridique, td.libelle AS typeDossier, st.denomination AS structure,
		(
			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 CONCAT(agent.nom, ' ', agent.prenom) AS agentSaisie
			FROM utilisateur agent
			WHERE agent.id = d.utilisateur_id 
			ORDER BY agent.id ASC
			LIMIT 1
		) AS agentSaisie, doc.date_soumission AS dateReception, d.date_creation , f.sigle, d.id AS dossier_id, pol.libelle, sj.id AS serviceJuridique,sj.date_depot AS dateDepotSJ, r.date AS dateDelivrance
		FROM document_collected doc 
		INNER JOIN dossier_demande d ON d.id = doc.dossier_demande_id
		LEFT JOIN service_juridique sj ON sj.id = d.service_juridique_id
		LEFT JOIN rccm r ON r.dossier_demande_id = d.id
		INNER JOIN type_structure pol ON pol.id= doc.pole_id
		LEFT  JOIN statut_traitement stat ON  doc.statut_traitement_id = stat.id
		INNER  JOIN type_dossier td ON d.type_dossier_id = td.id
		INNER JOIN form_juridique f ON d.forme_juridique_id = f.id
		INNER JOIN utilisateur u ON d.utilisateur_id = u.id
		LEFT  JOIN services s ON u.service_id = s.id
		LEFT  JOIN structure st ON s.structure_id = st.id
		WHERE pol.code ='GF'  AND (stat.code = 'EC' or stat.code = 'DD') AND d.statut_validation_chef_greffe is not null and d.statut_validation_chef_greffe  != 3  ORDER BY d.date_creation DESC;

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

SELECT
  d.numero_dossier AS numeroDossier,
  d.denomination_sociale AS denominationSociale,
  f.libelle AS formeJuridique,
  td.libelle AS typeDossier,
  st.denomination AS structure,
  (
    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
      CONCAT(agent.nom, ' ', agent.prenom) AS agentSaisie
    FROM
      utilisateur agent
    WHERE
      agent.id = d.utilisateur_id
    ORDER BY
      agent.id ASC
    LIMIT
      1
  ) AS agentSaisie,
  doc.date_soumission AS dateReception,
  d.date_creation,
  f.sigle,
  d.id AS dossier_id,
  pol.libelle,
  sj.id AS serviceJuridique,
  sj.date_depot AS dateDepotSJ,
  r.date AS dateDelivrance
FROM
  document_collected doc
  INNER JOIN dossier_demande d ON d.id = doc.dossier_demande_id
  LEFT JOIN service_juridique sj ON sj.id = d.service_juridique_id
  LEFT JOIN rccm r ON r.dossier_demande_id = d.id
  INNER JOIN type_structure pol ON pol.id = doc.pole_id
  LEFT JOIN statut_traitement stat ON doc.statut_traitement_id = stat.id
  INNER JOIN type_dossier td ON d.type_dossier_id = td.id
  INNER JOIN form_juridique f ON d.forme_juridique_id = f.id
  INNER JOIN utilisateur u ON d.utilisateur_id = u.id
  LEFT JOIN services s ON u.service_id = s.id
  LEFT JOIN structure st ON s.structure_id = st.id
WHERE
  pol.code = 'GF'
  AND stat.code = :statut
ORDER BY
  d.date_creation DESC

SELECT d.numero_dossier AS numeroDossier, d.denomination_sociale AS denominationSociale, f.libelle AS  formeJuridique, td.libelle AS typeDossier, st.denomination AS structure,
		(
			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 CONCAT(agent.nom, ' ', agent.prenom) AS agentSaisie
			FROM utilisateur agent
			WHERE agent.id = d.utilisateur_id 
			ORDER BY agent.id ASC
			LIMIT 1
		) AS agentSaisie, doc.date_soumission AS dateReception, d.date_creation , f.sigle, d.id AS dossier_id, pol.libelle, sj.id AS serviceJuridique,sj.date_depot AS dateDepotSJ, r.date AS dateDelivrance
		FROM document_collected doc 
		INNER JOIN dossier_demande d ON d.id = doc.dossier_demande_id
		LEFT JOIN service_juridique sj ON sj.id = d.service_juridique_id
		LEFT JOIN rccm r ON r.dossier_demande_id = d.id
		INNER JOIN type_structure pol ON pol.id= doc.pole_id
		LEFT  JOIN statut_traitement stat ON  doc.statut_traitement_id = stat.id
		INNER  JOIN type_dossier td ON d.type_dossier_id = td.id
		INNER JOIN form_juridique f ON d.forme_juridique_id = f.id
		INNER JOIN utilisateur u ON d.utilisateur_id = u.id
		LEFT  JOIN services s ON u.service_id = s.id
		LEFT  JOIN structure st ON s.structure_id = st.id
		WHERE pol.code ='GF'   AND stat.code = 'DM' ORDER BY d.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.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.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 = 117;

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

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.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 = 85;

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;