Symfony Profiler

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

Query Metrics

SELECT a.*, 
                   ta.libelle as type_acteur_libelle,
                   dp.region_id as region_id,
                   r.district_id as district_id
            FROM acteur a 
            LEFT JOIN type_acteur ta ON a.type_acteur_id = ta.id 
            LEFT JOIN departement dp ON a.departement_id = dp.id
            LEFT JOIN region r ON dp.region_id = r.id
         WHERE a.latitude IS NOT NULL AND a.longitude IS NOT NULL

[]

SELECT
  a.*,
  ta.libelle as type_acteur_libelle,
  dp.region_id as region_id,
  r.district_id as district_id
FROM
  acteur a
  LEFT JOIN type_acteur ta ON a.type_acteur_id = ta.id
  LEFT JOIN departement dp ON a.departement_id = dp.id
  LEFT JOIN region r ON dp.region_id = r.id
WHERE
  a.latitude IS NOT NULL
  AND a.longitude IS NOT NULL

SELECT a.*, 
                   ta.libelle as type_acteur_libelle,
                   dp.region_id as region_id,
                   r.district_id as district_id
            FROM acteur a 
            LEFT JOIN type_acteur ta ON a.type_acteur_id = ta.id 
            LEFT JOIN departement dp ON a.departement_id = dp.id
            LEFT JOIN region r ON dp.region_id = r.id
         WHERE a.latitude IS NOT NULL AND a.longitude IS NOT NULL;

SELECT DISTINCT sp.id, sp.nom, sp.departement_id, dp.region_id, r.district_id FROM sous_prefecture sp JOIN departement dp ON sp.departement_id = dp.id JOIN region r ON dp.region_id = r.id ORDER BY sp.nom

[]

SELECT
  DISTINCT sp.id,
  sp.nom,
  sp.departement_id,
  dp.region_id,
  r.district_id
FROM
  sous_prefecture sp
  JOIN departement dp ON sp.departement_id = dp.id
  JOIN region r ON dp.region_id = r.id
ORDER BY
  sp.nom

SELECT DISTINCT sp.id, sp.nom, sp.departement_id, dp.region_id, r.district_id FROM sous_prefecture sp JOIN departement dp ON sp.departement_id = dp.id JOIN region r ON dp.region_id = r.id ORDER BY sp.nom;

SELECT DISTINCT dist.id, dist.nom FROM district dist ORDER BY dist.nom

[]

SELECT
  DISTINCT dist.id,
  dist.nom
FROM
  district dist
ORDER BY
  dist.nom

SELECT DISTINCT dist.id, dist.nom FROM district dist ORDER BY dist.nom;

SELECT t0.id AS id_1, t0.code AS code_2, t0.libelle AS libelle_3, t0.description AS description_4 FROM filieres t0

[]

SELECT
  t0.id AS id_1,
  t0.code AS code_2,
  t0.libelle AS libelle_3,
  t0.description AS description_4
FROM
  filieres t0

SELECT t0.id AS id_1, t0.code AS code_2, t0.libelle AS libelle_3, t0.description AS description_4 FROM filieres t0;

SELECT t0.id AS id_1, t0.code AS code_2, t0.libelle AS libelle_3, t0.description AS description_4 FROM role_principal t0

[]

SELECT
  t0.id AS id_1,
  t0.code AS code_2,
  t0.libelle AS libelle_3,
  t0.description AS description_4
FROM
  role_principal t0

SELECT t0.id AS id_1, t0.code AS code_2, t0.libelle AS libelle_3, t0.description AS description_4 FROM role_principal t0;

SELECT t0.id AS id_1, t0.libelle AS libelle_2 FROM statut_juridique t0

[]

SELECT
  t0.id AS id_1,
  t0.libelle AS libelle_2
FROM
  statut_juridique t0

SELECT t0.id AS id_1, t0.libelle AS libelle_2 FROM statut_juridique t0;

SELECT DISTINCT dp.id, dp.nom, dp.region_id, r.district_id FROM departement dp JOIN region r ON dp.region_id = r.id ORDER BY dp.nom

[]

SELECT
  DISTINCT dp.id,
  dp.nom,
  dp.region_id,
  r.district_id
FROM
  departement dp
  JOIN region r ON dp.region_id = r.id
ORDER BY
  dp.nom

SELECT DISTINCT dp.id, dp.nom, dp.region_id, r.district_id FROM departement dp JOIN region r ON dp.region_id = r.id ORDER BY dp.nom;

SELECT DISTINCT r.id, r.nom, r.district_id FROM region r ORDER BY r.nom

[]

SELECT
  DISTINCT r.id,
  r.nom,
  r.district_id
FROM
  region r
ORDER BY
  r.nom

SELECT DISTINCT r.id, r.nom, r.district_id FROM region r ORDER BY r.nom;

SELECT t0.id AS id_1, t0.code AS code_2, t0.libelle AS libelle_3 FROM type_acteur t0

[]

SELECT
  t0.id AS id_1,
  t0.code AS code_2,
  t0.libelle AS libelle_3
FROM
  type_acteur t0

SELECT t0.id AS id_1, t0.code AS code_2, t0.libelle AS libelle_3 FROM type_acteur t0;