Symfony Profiler

Query Metrics

6 Database Queries

6 Different statements

317.02 ms Query time

0 Invalid entities

0 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

203.86 ms
(64.31%)

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 = ?

Parameters:

[
  48
]

View formatted query View runnable query Explain query View query backtrace

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 = 48
        ;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 92)
2	App\Repository\FederationRepository->getFederationStats (line 55)
3	App\Controller\FederationController->show (line 181)
4	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
5	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
6	Symfony\Component\HttpKernel\Kernel->handle (line 35)
7	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
8	require_once (line 5)

106.10 ms
(33.47%)

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

Parameters:

[
  48
]

View formatted query View runnable query Explain query View query backtrace

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 = 48
        ;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 76)
2	App\Repository\FederationRepository->getFederationStats (line 55)
3	App\Controller\FederationController->show (line 181)
4	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
5	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
6	Symfony\Component\HttpKernel\Kernel->handle (line 35)
7	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
8	require_once (line 5)

2.72 ms
(0.86%)

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 = ?

Parameters:

[
  48
]

View formatted query View runnable query Explain query View query backtrace

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 = 48;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 27)
2	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 296)
3	Doctrine\ORM\Query->_doExecute (line 935)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 891)
5	Doctrine\ORM\AbstractQuery->execute (line 738)
6	Doctrine\ORM\AbstractQuery->getOneOrNullResult (line 54)
7	App\Repository\FederationRepository->findOneWithProvince (line 48)
8	App\Controller\FederationController->show (line 181)
9	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
10	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
11	Symfony\Component\HttpKernel\Kernel->handle (line 35)
12	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
13	require_once (line 5)

1.85 ms
(0.58%)

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

Parameters:

[
  48
]

View formatted query View runnable query Explain query View query backtrace

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 = 48 AND p.sexe IS NOT NULL
            GROUP BY p.sexe
        ;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 105)
2	App\Repository\FederationRepository->getFederationStats (line 55)
3	App\Controller\FederationController->show (line 181)
4	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
5	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
6	Symfony\Component\HttpKernel\Kernel->handle (line 35)
7	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
8	require_once (line 5)

1.72 ms
(0.54%)

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

Parameters:

[
  48
]

View formatted query View runnable query Explain query View query backtrace

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

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

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 63)
2	App\Repository\FederationRepository->getFederationStats (line 55)
3	App\Controller\FederationController->show (line 181)
4	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
5	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
6	Symfony\Component\HttpKernel\Kernel->handle (line 35)
7	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
8	require_once (line 5)

0.76 ms
(0.24%)

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

Parameters:

[
  48
]

View formatted query View runnable query Explain query View query backtrace

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 = 48 AND p.date_naissance IS NOT NULL
        ;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 120)
2	App\Repository\FederationRepository->getFederationStats (line 55)
3	App\Controller\FederationController->show (line 181)
4	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
5	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
6	Symfony\Component\HttpKernel\Kernel->handle (line 35)
7	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
8	require_once (line 5)

Database Connections

Name	Service
default	doctrine.dbal.default_connection

Entity Managers

Name	Service
default	doctrine.orm.default_entity_manager

Second Level Cache

Second Level Cache is not enabled.

Managed Entities

default entity manager

Class	Amount of managed objects

Entities Mapping

Class	Mapping errors
App\Entity\Federation	No errors.
App\Entity\Province	No errors.
App\Entity\User	No errors.

Symfony Profiler

GET https://www.mlcapp.org/federation/48

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping