Symfony Profiler

• Request / Response
• Performance
• Validator
• Forms
• Exception
• Logs 40
• Events
• Routing
• Cache
• Translation 2
• Security
• Twig
• HTTP Client
• Doctrine
• Debug
• Messages
• Emails
• Notifications
• VichUploader
• Configuration

Query Metrics

SELECT s0_.id AS id_0, s0_.insee AS insee_1, s0_.mtn_total_travaux AS mtn_total_travaux_2, s0_.mtn_for_sieds AS mtn_for_sieds_3, s0_.detail_projet_id AS detail_projet_id_4 FROM suivi_et_histo s0_ LEFT JOIN projet p1_ ON (s0_.detail_projet_id = p1_.id) WHERE s0_.insee = ? AND (p1_.id IS NOT NULL AND p1_.dcode IS NOT NULL)

[
  "79002"
]

SELECT
  s0_.id AS id_0,
  s0_.insee AS insee_1,
  s0_.mtn_total_travaux AS mtn_total_travaux_2,
  s0_.mtn_for_sieds AS mtn_for_sieds_3,
  s0_.detail_projet_id AS detail_projet_id_4
FROM
  suivi_et_histo s0_
  LEFT JOIN projet p1_ ON (s0_.detail_projet_id = p1_.id)
WHERE
  s0_.insee = ?
  AND (
    p1_.id IS NOT NULL
    AND p1_.dcode IS NOT NULL
  )

SELECT s0_.id AS id_0, s0_.insee AS insee_1, s0_.mtn_total_travaux AS mtn_total_travaux_2, s0_.mtn_for_sieds AS mtn_for_sieds_3, s0_.detail_projet_id AS detail_projet_id_4 FROM suivi_et_histo s0_ LEFT JOIN projet p1_ ON (s0_.detail_projet_id = p1_.id) WHERE s0_.insee = '79002' AND (p1_.id IS NOT NULL AND p1_.dcode IS NOT NULL);

SELECT t0.id AS id_1, t0.status AS status_2, t0.decision AS decision_3, t0.lieu AS lieu_4, t0.date_prev AS date_prev_5, t0.step AS step_6, t0.attestation AS attestation_7, t0.fields AS fields_8, t0.commune AS commune_9, t0.detail_techs AS detail_techs_10, t0.signature AS signature_11, t0.created_at AS created_at_12, t0.dcode AS dcode_13, t0.annee_programme AS annee_programme_14, t0.nom_programme AS nom_programme_15, t0.updated_at AS updated_at_16, t0.date_demande AS date_demande_17, t0.type_id AS type_id_18, t0.type_work_id AS type_work_id_19, t0.user_id AS user_id_20 FROM projet t0 WHERE t0.id = ?

[
  17077
]

SELECT
  t0.id AS id_1,
  t0.status AS status_2,
  t0.decision AS decision_3,
  t0.lieu AS lieu_4,
  t0.date_prev AS date_prev_5,
  t0.step AS step_6,
  t0.attestation AS attestation_7,
  t0.fields AS fields_8,
  t0.commune AS commune_9,
  t0.detail_techs AS detail_techs_10,
  t0.signature AS signature_11,
  t0.created_at AS created_at_12,
  t0.dcode AS dcode_13,
  t0.annee_programme AS annee_programme_14,
  t0.nom_programme AS nom_programme_15,
  t0.updated_at AS updated_at_16,
  t0.date_demande AS date_demande_17,
  t0.type_id AS type_id_18,
  t0.type_work_id AS type_work_id_19,
  t0.user_id AS user_id_20
FROM
  projet t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.status AS status_2, t0.decision AS decision_3, t0.lieu AS lieu_4, t0.date_prev AS date_prev_5, t0.step AS step_6, t0.attestation AS attestation_7, t0.fields AS fields_8, t0.commune AS commune_9, t0.detail_techs AS detail_techs_10, t0.signature AS signature_11, t0.created_at AS created_at_12, t0.dcode AS dcode_13, t0.annee_programme AS annee_programme_14, t0.nom_programme AS nom_programme_15, t0.updated_at AS updated_at_16, t0.date_demande AS date_demande_17, t0.type_id AS type_id_18, t0.type_work_id AS type_work_id_19, t0.user_id AS user_id_20 FROM projet t0 WHERE t0.id = 17077;

SELECT t0.id AS id_1, t0.username AS username_2, t0.roles AS roles_3, t0.password AS password_4, t0.email AS email_5, t0.nom AS nom_6, t0.prenom AS prenom_7, t0.poste_name AS poste_name_8, t0.poste_key AS poste_key_9, t0.fonction_name AS fonction_name_10, t0.fonction_key AS fonction_key_11, t0.address AS address_12, t0.cp AS cp_13, t0.ville AS ville_14, t0.tel AS tel_15, t0.updated_at AS updated_at_16, t0.created_at AS created_at_17, t0.alert_rules AS alert_rules_18, t0.first_connection AS first_connection_19, t0.reset_token AS reset_token_20, t0.img_user_file_id AS img_user_file_id_21 FROM user t0 WHERE t0.id = ?

[
  4908
]

SELECT
  t0.id AS id_1,
  t0.username AS username_2,
  t0.roles AS roles_3,
  t0.password AS password_4,
  t0.email AS email_5,
  t0.nom AS nom_6,
  t0.prenom AS prenom_7,
  t0.poste_name AS poste_name_8,
  t0.poste_key AS poste_key_9,
  t0.fonction_name AS fonction_name_10,
  t0.fonction_key AS fonction_key_11,
  t0.address AS address_12,
  t0.cp AS cp_13,
  t0.ville AS ville_14,
  t0.tel AS tel_15,
  t0.updated_at AS updated_at_16,
  t0.created_at AS created_at_17,
  t0.alert_rules AS alert_rules_18,
  t0.first_connection AS first_connection_19,
  t0.reset_token AS reset_token_20,
  t0.img_user_file_id AS img_user_file_id_21
FROM
  user t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.username AS username_2, t0.roles AS roles_3, t0.password AS password_4, t0.email AS email_5, t0.nom AS nom_6, t0.prenom AS prenom_7, t0.poste_name AS poste_name_8, t0.poste_key AS poste_key_9, t0.fonction_name AS fonction_name_10, t0.fonction_key AS fonction_key_11, t0.address AS address_12, t0.cp AS cp_13, t0.ville AS ville_14, t0.tel AS tel_15, t0.updated_at AS updated_at_16, t0.created_at AS created_at_17, t0.alert_rules AS alert_rules_18, t0.first_connection AS first_connection_19, t0.reset_token AS reset_token_20, t0.img_user_file_id AS img_user_file_id_21 FROM user t0 WHERE t0.id = 4908;

SELECT t0.id AS id_1, t0.url AS url_2, t0.actif AS actif_3, t0.name AS name_4, t0.type AS type_5 FROM link t0 WHERE t0.actif = ? AND t0.type = ?

[
  1
  "enquete"
]

SELECT
  t0.id AS id_1,
  t0.url AS url_2,
  t0.actif AS actif_3,
  t0.name AS name_4,
  t0.type AS type_5
FROM
  link t0
WHERE
  t0.actif = ?
  AND t0.type = ?

SELECT t0.id AS id_1, t0.url AS url_2, t0.actif AS actif_3, t0.name AS name_4, t0.type AS type_5 FROM link t0 WHERE t0.actif = 1 AND t0.type = 'enquete';

SELECT COUNT(*) FROM projet t0 WHERE t0.status = ? AND t0.user_id = ? AND (t0.dcode IN (?) OR t0.dcode IS NULL)

[
  "En cours de saisie"
  4908
  null
]

SELECT
  COUNT(*)
FROM
  projet t0
WHERE
  t0.status = ?
  AND t0.user_id = ?
  AND (
    t0.dcode IN (?)
    OR t0.dcode IS NULL
  )

SELECT COUNT(*) FROM projet t0 WHERE t0.status = 'En cours de saisie' AND t0.user_id = 4908 AND (t0.dcode IN (NULL) OR t0.dcode IS NULL);

SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.phone AS phone_2, c0_.code_insee AS code_insee_3, c0_.territoire_id AS territoire_id_4 FROM commune c0_ LEFT JOIN user_commune u2_ ON c0_.id = u2_.commune_id LEFT JOIN user u1_ ON u1_.id = u2_.user_id WHERE u1_.id = ?

[
  4908
]

SELECT
  c0_.id AS id_0,
  c0_.name AS name_1,
  c0_.phone AS phone_2,
  c0_.code_insee AS code_insee_3,
  c0_.territoire_id AS territoire_id_4
FROM
  commune c0_
  LEFT JOIN user_commune u2_ ON c0_.id = u2_.commune_id
  LEFT JOIN user u1_ ON u1_.id = u2_.user_id
WHERE
  u1_.id = ?

SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.phone AS phone_2, c0_.code_insee AS code_insee_3, c0_.territoire_id AS territoire_id_4 FROM commune c0_ LEFT JOIN user_commune u2_ ON c0_.id = u2_.commune_id LEFT JOIN user u1_ ON u1_.id = u2_.user_id WHERE u1_.id = 4908;

SELECT t0.id AS id_1, t0.nom AS nom_2, t0.key AS key_3 FROM territoire_energie t0 INNER JOIN user_territoire_energie ON t0.id = user_territoire_energie.territoire_energie_id WHERE user_territoire_energie.user_id = ?

[
  4908
]

SELECT
  t0.id AS id_1,
  t0.nom AS nom_2,
  t0.key AS key_3
FROM
  territoire_energie t0
  INNER JOIN user_territoire_energie ON t0.id = user_territoire_energie.territoire_energie_id
WHERE
  user_territoire_energie.user_id = ?

SELECT t0.id AS id_1, t0.nom AS nom_2, t0.key AS key_3 FROM territoire_energie t0 INNER JOIN user_territoire_energie ON t0.id = user_territoire_energie.territoire_energie_id WHERE user_territoire_energie.user_id = 4908;

SELECT t0.id AS id_1, t0.name AS name_2, t0.phone AS phone_3, t0.code_insee AS code_insee_4, t0.territoire_id AS territoire_id_5 FROM commune t0 INNER JOIN user_commune ON t0.id = user_commune.commune_id WHERE user_commune.user_id = ?

[
  4908
]

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.phone AS phone_3,
  t0.code_insee AS code_insee_4,
  t0.territoire_id AS territoire_id_5
FROM
  commune t0
  INNER JOIN user_commune ON t0.id = user_commune.commune_id
WHERE
  user_commune.user_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.phone AS phone_3, t0.code_insee AS code_insee_4, t0.territoire_id AS territoire_id_5 FROM commune t0 INNER JOIN user_commune ON t0.id = user_commune.commune_id WHERE user_commune.user_id = 4908;

SELECT t0.id AS id_1, t0.titre AS titre_2, t0.intro AS intro_3, t0.contenu AS contenu_4, t0.button AS button_5, t0.text_btn AS text_btn_6, t0.url_btn AS url_btn_7, t0.type AS type_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10, t0.img_useful_file_id AS img_useful_file_id_11, t0.img_contenu_file_id AS img_contenu_file_id_12, t0.img_intro_file_id AS img_intro_file_id_13 FROM contenu t0 WHERE t0.type = ?

[
  "Information"
]

SELECT
  t0.id AS id_1,
  t0.titre AS titre_2,
  t0.intro AS intro_3,
  t0.contenu AS contenu_4,
  t0.button AS button_5,
  t0.text_btn AS text_btn_6,
  t0.url_btn AS url_btn_7,
  t0.type AS type_8,
  t0.created_at AS created_at_9,
  t0.updated_at AS updated_at_10,
  t0.img_useful_file_id AS img_useful_file_id_11,
  t0.img_contenu_file_id AS img_contenu_file_id_12,
  t0.img_intro_file_id AS img_intro_file_id_13
FROM
  contenu t0
WHERE
  t0.type = ?

SELECT t0.id AS id_1, t0.titre AS titre_2, t0.intro AS intro_3, t0.contenu AS contenu_4, t0.button AS button_5, t0.text_btn AS text_btn_6, t0.url_btn AS url_btn_7, t0.type AS type_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10, t0.img_useful_file_id AS img_useful_file_id_11, t0.img_contenu_file_id AS img_contenu_file_id_12, t0.img_intro_file_id AS img_intro_file_id_13 FROM contenu t0 WHERE t0.type = 'Information';