Symfony Profiler

• Request / Response
• Performance
• Validator
• Forms
• Exception
• Logs
• Events
• Routing
• Cache
• Translation
• Security
• Twig
• HTTP Client
• Doctrine 1
• Debug
• Messages
• E-mails
• Notifications
• Serializer
• Configuration

Query Metrics

SELECT t0.id AS id_1, t0.nom_long AS nom_long_2, t0.nom_court AS nom_court_3, t0.nom_arabe AS nom_arabe_4, t0.type AS type_5, t0.etat AS etat_6, t0.adresse AS adresse_7, t0.email AS email_8, t0.site_web AS site_web_9, t0.logo AS logo_10, t0.description AS description_11, t0.code AS code_12, t0.image1 AS image1_13, t0.image2 AS image2_14, t0.image3 AS image3_15, t0.doc_pdf AS doc_pdf_16, t0.nom_doc_pdf AS nom_doc_pdf_17, t0.responsable_id AS responsable_id_18, t0.etablissement_id AS etablissement_id_19, t0.domaine_id AS domaine_id_20 FROM structure_recherche t0 WHERE t0.id = ?

[
  "5"
]

SELECT
  t0.id AS id_1,
  t0.nom_long AS nom_long_2,
  t0.nom_court AS nom_court_3,
  t0.nom_arabe AS nom_arabe_4,
  t0.type AS type_5,
  t0.etat AS etat_6,
  t0.adresse AS adresse_7,
  t0.email AS email_8,
  t0.site_web AS site_web_9,
  t0.logo AS logo_10,
  t0.description AS description_11,
  t0.code AS code_12,
  t0.image1 AS image1_13,
  t0.image2 AS image2_14,
  t0.image3 AS image3_15,
  t0.doc_pdf AS doc_pdf_16,
  t0.nom_doc_pdf AS nom_doc_pdf_17,
  t0.responsable_id AS responsable_id_18,
  t0.etablissement_id AS etablissement_id_19,
  t0.domaine_id AS domaine_id_20
FROM
  structure_recherche t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.nom_long AS nom_long_2, t0.nom_court AS nom_court_3, t0.nom_arabe AS nom_arabe_4, t0.type AS type_5, t0.etat AS etat_6, t0.adresse AS adresse_7, t0.email AS email_8, t0.site_web AS site_web_9, t0.logo AS logo_10, t0.description AS description_11, t0.code AS code_12, t0.image1 AS image1_13, t0.image2 AS image2_14, t0.image3 AS image3_15, t0.doc_pdf AS doc_pdf_16, t0.nom_doc_pdf AS nom_doc_pdf_17, t0.responsable_id AS responsable_id_18, t0.etablissement_id AS etablissement_id_19, t0.domaine_id AS domaine_id_20 FROM structure_recherche t0 WHERE t0.id = '5';

SELECT t0.id AS id_1, t0.nom AS nom_2, t0.objectif AS objectif_3, t0.date_debut AS date_debut_4, t0.date_fin AS date_fin_5, t0.description AS description_6, t0.etat AS etat_7, t0.statut AS statut_8, t0.domaine_recherche AS domaine_recherche_9, t0.image AS image_10, t0.user_id AS user_id_11, t0.directeur_id AS directeur_id_12, t0.theme_id AS theme_id_13, t0.structure_id AS structure_id_14 FROM projet t0 WHERE t0.structure_id = ?

[
  5
]

SELECT
  t0.id AS id_1,
  t0.nom AS nom_2,
  t0.objectif AS objectif_3,
  t0.date_debut AS date_debut_4,
  t0.date_fin AS date_fin_5,
  t0.description AS description_6,
  t0.etat AS etat_7,
  t0.statut AS statut_8,
  t0.domaine_recherche AS domaine_recherche_9,
  t0.image AS image_10,
  t0.user_id AS user_id_11,
  t0.directeur_id AS directeur_id_12,
  t0.theme_id AS theme_id_13,
  t0.structure_id AS structure_id_14
FROM
  projet t0
WHERE
  t0.structure_id = ?

SELECT t0.id AS id_1, t0.nom AS nom_2, t0.objectif AS objectif_3, t0.date_debut AS date_debut_4, t0.date_fin AS date_fin_5, t0.description AS description_6, t0.etat AS etat_7, t0.statut AS statut_8, t0.domaine_recherche AS domaine_recherche_9, t0.image AS image_10, t0.user_id AS user_id_11, t0.directeur_id AS directeur_id_12, t0.theme_id AS theme_id_13, t0.structure_id AS structure_id_14 FROM projet t0 WHERE t0.structure_id = 5;

SELECT  count(*) as nbr  FROM chercheur where structure_id = 5

[]

SELECT
  count(*) as nbr
FROM
  chercheur
where
  structure_id = 5

SELECT  count(*) as nbr  FROM chercheur where structure_id = 5  ;

SELECT COUNT(*) as nbr FROM projet p LEFT JOIN structure_recherche s ON s.id = p.structure_id WHERE s.id = 5

[]

SELECT
  COUNT(*) as nbr
FROM
  projet p
  LEFT JOIN structure_recherche s ON s.id = p.structure_id
WHERE
  s.id = 5

SELECT COUNT(*) as nbr FROM projet p LEFT JOIN structure_recherche s ON s.id = p.structure_id WHERE s.id = 5;

SELECT COUNT(*) as nbr FROM publication p LEFT JOIN structure_recherche s ON s.id = p.structure_id WHERE s.id = 5

[]

SELECT
  COUNT(*) as nbr
FROM
  publication p
  LEFT JOIN structure_recherche s ON s.id = p.structure_id
WHERE
  s.id = 5

SELECT COUNT(*) as nbr FROM publication p LEFT JOIN structure_recherche s ON s.id = p.structure_id WHERE s.id = 5 ;

SELECT t0.id AS id_1, t0.nom_court AS nom_court_2, t0.nom_long AS nom_long_3, t0.adresse AS adresse_4, t0.email AS email_5, t0.site_web AS site_web_6, t0.telephone AS telephone_7, t0.fax AS fax_8, t0.description AS description_9, t0.nom_arabe AS nom_arabe_10, t0.logo AS logo_11, t0.image1 AS image1_12, t0.image2 AS image2_13, t0.image3 AS image3_14 FROM etablissement t0 WHERE t0.id = ?

[
  3
]

SELECT
  t0.id AS id_1,
  t0.nom_court AS nom_court_2,
  t0.nom_long AS nom_long_3,
  t0.adresse AS adresse_4,
  t0.email AS email_5,
  t0.site_web AS site_web_6,
  t0.telephone AS telephone_7,
  t0.fax AS fax_8,
  t0.description AS description_9,
  t0.nom_arabe AS nom_arabe_10,
  t0.logo AS logo_11,
  t0.image1 AS image1_12,
  t0.image2 AS image2_13,
  t0.image3 AS image3_14
FROM
  etablissement t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.nom_court AS nom_court_2, t0.nom_long AS nom_long_3, t0.adresse AS adresse_4, t0.email AS email_5, t0.site_web AS site_web_6, t0.telephone AS telephone_7, t0.fax AS fax_8, t0.description AS description_9, t0.nom_arabe AS nom_arabe_10, t0.logo AS logo_11, t0.image1 AS image1_12, t0.image2 AS image2_13, t0.image3 AS image3_14 FROM etablissement t0 WHERE t0.id = 3;