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 
            FROM acteur a 
            LEFT JOIN type_acteur ta ON a.type_acteur_code = ta.code 
            WHERE a.latitude IS NOT NULL AND a.longitude IS NOT NULL

[]

SELECT
  a.*,
  ta.libelle as type_acteur_libelle
FROM
  acteur a
  LEFT JOIN type_acteur ta ON a.type_acteur_code = ta.code
WHERE
  a.latitude IS NOT NULL
  AND a.longitude IS NOT NULL

SELECT a.*, ta.libelle as type_acteur_libelle 
            FROM acteur a 
            LEFT JOIN type_acteur ta ON a.type_acteur_code = ta.code 
            WHERE a.latitude IS NOT NULL AND a.longitude IS NOT NULL
        ;

SELECT DISTINCT d.id, d.nom FROM district d JOIN acteur a ON a.district_id = d.id ORDER BY d.nom

[]

SELECT
  DISTINCT d.id,
  d.nom
FROM
  district d
  JOIN acteur a ON a.district_id = d.id
ORDER BY
  d.nom

SELECT DISTINCT d.id, d.nom FROM district d JOIN acteur a ON a.district_id = d.id ORDER BY d.nom;

SELECT DISTINCT r.id, r.nom FROM region r JOIN acteur a ON a.region_id = r.id ORDER BY r.nom

[]

SELECT
  DISTINCT r.id,
  r.nom
FROM
  region r
  JOIN acteur a ON a.region_id = r.id
ORDER BY
  r.nom

SELECT DISTINCT r.id, r.nom FROM region r JOIN acteur a ON a.region_id = r.id ORDER BY r.nom;

SELECT DISTINCT dp.id, dp.nom FROM departement dp JOIN acteur a ON a.departement_id = dp.id ORDER BY dp.nom

[]

SELECT
  DISTINCT dp.id,
  dp.nom
FROM
  departement dp
  JOIN acteur a ON a.departement_id = dp.id
ORDER BY
  dp.nom

SELECT DISTINCT dp.id, dp.nom FROM departement dp JOIN acteur a ON a.departement_id = dp.id ORDER BY dp.nom;

SELECT DISTINCT sp.id, sp.nom FROM sous_prefecture sp JOIN acteur a ON a.sous_prefecture_id = sp.id ORDER BY sp.nom

[]

SELECT
  DISTINCT sp.id,
  sp.nom
FROM
  sous_prefecture sp
  JOIN acteur a ON a.sous_prefecture_id = sp.id
ORDER BY
  sp.nom

SELECT DISTINCT sp.id, sp.nom FROM sous_prefecture sp JOIN acteur a ON a.sous_prefecture_id = sp.id ORDER BY sp.nom;

SELECT DISTINCT a.commune FROM acteur a WHERE a.commune IS NOT NULL AND a.commune != "" ORDER BY a.commune

[]

SELECT
  DISTINCT a.commune
FROM
  acteur a
WHERE
  a.commune IS NOT NULL
  AND a.commune != ""
ORDER BY
  a.commune

SELECT DISTINCT a.commune FROM acteur a WHERE a.commune IS NOT NULL AND a.commune != "" ORDER BY a.commune;