Symfony Profiler

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

Query Metrics

SELECT f0_.id AS id_0, f0_.nom AS nom_1, f0_.adresse AS adresse_2, f0_.telephone AS telephone_3, f0_.president AS president_4, p1_.nom AS nom_5, u2_.email AS email_6 FROM federation f0_ LEFT JOIN province p1_ ON f0_.province_id = p1_.id LEFT JOIN `user` u2_ ON f0_.user_id = u2_.id WHERE f0_.id = ?

[
  20
]

SELECT
  f0_.id AS id_0,
  f0_.nom AS nom_1,
  f0_.adresse AS adresse_2,
  f0_.telephone AS telephone_3,
  f0_.president AS president_4,
  p1_.nom AS nom_5,
  u2_.email AS email_6
FROM
  federation f0_
  LEFT JOIN province p1_ ON f0_.province_id = p1_.id
  LEFT JOIN `user` u2_ ON f0_.user_id = u2_.id
WHERE
  f0_.id = ?

SELECT f0_.id AS id_0, f0_.nom AS nom_1, f0_.adresse AS adresse_2, f0_.telephone AS telephone_3, f0_.president AS president_4, p1_.nom AS nom_5, u2_.email AS email_6 FROM federation f0_ LEFT JOIN province p1_ ON f0_.province_id = p1_.id LEFT JOIN `user` u2_ ON f0_.user_id = u2_.id WHERE f0_.id = 20;

SELECT COUNT(*) as total FROM membre WHERE federation_id = ?

[
  20
]

SELECT
  COUNT(*) as total
FROM
  membre
WHERE
  federation_id = ?

SELECT COUNT(*) as total FROM membre WHERE federation_id = 20;

SELECT COUNT(c.id) as total_cotisations 
            FROM cotisation c
            INNER JOIN membre m ON c.membre_id = m.id
            WHERE m.federation_id = ?

[
  20
]

SELECT
  COUNT(c.id) as total_cotisations
FROM
  cotisation c
  INNER JOIN membre m ON c.membre_id = m.id
WHERE
  m.federation_id = ?

SELECT COUNT(c.id) as total_cotisations 
            FROM cotisation c
            INNER JOIN membre m ON c.membre_id = m.id
            WHERE m.federation_id = 20
        ;

SELECT 
                COUNT(*) as total,
                COUNT(CASE WHEN m.carte = 1 THEN 1 END) as avec_carte,
                COUNT(CASE WHEN m.cadre = 1 THEN 1 END) as cadres,
                AVG(TIMESTAMPDIFF(YEAR, p.date_naissance, CURDATE())) as age_moyen,
                MIN(TIMESTAMPDIFF(YEAR, p.date_naissance, CURDATE())) as age_min,
                MAX(TIMESTAMPDIFF(YEAR, p.date_naissance, CURDATE())) as age_max
            FROM membre m
            INNER JOIN user u ON m.user_id = u.id
            INNER JOIN personne p ON u.personne_id = p.id
            WHERE m.federation_id = ?

[
  20
]

SELECT
  COUNT(*) as total,
  COUNT(CASE WHEN m.carte = 1 THEN
    1
  END) as avec_carte,
  COUNT(CASE WHEN m.cadre = 1 THEN
    1
  END) as cadres,
  AVG(
    TIMESTAMPDIFF(
      YEAR,
      p.date_naissance,
      CURDATE()
    )
  ) as age_moyen,
  MIN(
    TIMESTAMPDIFF(
      YEAR,
      p.date_naissance,
      CURDATE()
    )
  ) as age_min,
  MAX(
    TIMESTAMPDIFF(
      YEAR,
      p.date_naissance,
      CURDATE()
    )
  ) as age_max
FROM
  membre m
  INNER JOIN user u ON m.user_id = u.id
  INNER JOIN personne p ON u.personne_id = p.id
WHERE
  m.federation_id = ?

SELECT 
                COUNT(*) as total,
                COUNT(CASE WHEN m.carte = 1 THEN 1 END) as avec_carte,
                COUNT(CASE WHEN m.cadre = 1 THEN 1 END) as cadres,
                AVG(TIMESTAMPDIFF(YEAR, p.date_naissance, CURDATE())) as age_moyen,
                MIN(TIMESTAMPDIFF(YEAR, p.date_naissance, CURDATE())) as age_min,
                MAX(TIMESTAMPDIFF(YEAR, p.date_naissance, CURDATE())) as age_max
            FROM membre m
            INNER JOIN user u ON m.user_id = u.id
            INNER JOIN personne p ON u.personne_id = p.id
            WHERE m.federation_id = 20
        ;

SELECT 
                p.sexe,
                COUNT(*) as count
            FROM membre m
            INNER JOIN user u ON m.user_id = u.id
            INNER JOIN personne p ON u.personne_id = p.id
            WHERE m.federation_id = ? AND p.sexe IS NOT NULL
            GROUP BY p.sexe

[
  20
]

SELECT
  p.sexe,
  COUNT(*) as count
FROM
  membre m
  INNER JOIN user u ON m.user_id = u.id
  INNER JOIN personne p ON u.personne_id = p.id
WHERE
  m.federation_id = ?
  AND p.sexe IS NOT NULL
GROUP BY
  p.sexe

SELECT 
                p.sexe,
                COUNT(*) as count
            FROM membre m
            INNER JOIN user u ON m.user_id = u.id
            INNER JOIN personne p ON u.personne_id = p.id
            WHERE m.federation_id = 20 AND p.sexe IS NOT NULL
            GROUP BY p.sexe
        ;

SELECT 
                COUNT(CASE WHEN TIMESTAMPDIFF(YEAR, p.date_naissance, CURDATE()) BETWEEN 18 AND 25 THEN 1 END) as age_18_25,
                COUNT(CASE WHEN TIMESTAMPDIFF(YEAR, p.date_naissance, CURDATE()) BETWEEN 26 AND 35 THEN 1 END) as age_26_35,
                COUNT(CASE WHEN TIMESTAMPDIFF(YEAR, p.date_naissance, CURDATE()) BETWEEN 36 AND 45 THEN 1 END) as age_36_45,
                COUNT(CASE WHEN TIMESTAMPDIFF(YEAR, p.date_naissance, CURDATE()) BETWEEN 46 AND 55 THEN 1 END) as age_46_55,
                COUNT(CASE WHEN TIMESTAMPDIFF(YEAR, p.date_naissance, CURDATE()) >= 56 THEN 1 END) as age_56_plus
            FROM membre m
            INNER JOIN user u ON m.user_id = u.id
            INNER JOIN personne p ON u.personne_id = p.id
            WHERE m.federation_id = ? AND p.date_naissance IS NOT NULL

[
  20
]

SELECT
  COUNT(
    CASE WHEN TIMESTAMPDIFF(
      YEAR,
      p.date_naissance,
      CURDATE()
    ) BETWEEN 18
    AND 25 THEN
      1
    END
  ) as age_18_25,
  COUNT(
    CASE WHEN TIMESTAMPDIFF(
      YEAR,
      p.date_naissance,
      CURDATE()
    ) BETWEEN 26
    AND 35 THEN
      1
    END
  ) as age_26_35,
  COUNT(
    CASE WHEN TIMESTAMPDIFF(
      YEAR,
      p.date_naissance,
      CURDATE()
    ) BETWEEN 36
    AND 45 THEN
      1
    END
  ) as age_36_45,
  COUNT(
    CASE WHEN TIMESTAMPDIFF(
      YEAR,
      p.date_naissance,
      CURDATE()
    ) BETWEEN 46
    AND 55 THEN
      1
    END
  ) as age_46_55,
  COUNT(
    CASE WHEN TIMESTAMPDIFF(
      YEAR,
      p.date_naissance,
      CURDATE()
    ) >= 56 THEN
      1
    END
  ) as age_56_plus
FROM
  membre m
  INNER JOIN user u ON m.user_id = u.id
  INNER JOIN personne p ON u.personne_id = p.id
WHERE
  m.federation_id = ?
  AND p.date_naissance IS NOT NULL

SELECT 
                COUNT(CASE WHEN TIMESTAMPDIFF(YEAR, p.date_naissance, CURDATE()) BETWEEN 18 AND 25 THEN 1 END) as age_18_25,
                COUNT(CASE WHEN TIMESTAMPDIFF(YEAR, p.date_naissance, CURDATE()) BETWEEN 26 AND 35 THEN 1 END) as age_26_35,
                COUNT(CASE WHEN TIMESTAMPDIFF(YEAR, p.date_naissance, CURDATE()) BETWEEN 36 AND 45 THEN 1 END) as age_36_45,
                COUNT(CASE WHEN TIMESTAMPDIFF(YEAR, p.date_naissance, CURDATE()) BETWEEN 46 AND 55 THEN 1 END) as age_46_55,
                COUNT(CASE WHEN TIMESTAMPDIFF(YEAR, p.date_naissance, CURDATE()) >= 56 THEN 1 END) as age_56_plus
            FROM membre m
            INNER JOIN user u ON m.user_id = u.id
            INNER JOIN personne p ON u.personne_id = p.id
            WHERE m.federation_id = 20 AND p.date_naissance IS NOT NULL
        ;