Symfony Profiler

Query Metrics

28 Database Queries

5 Different statements

85.12 ms Query time

0 Invalid entities

37 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

69.07 ms
(81.15%)

SELECT c0_.id AS id_0, c0_.serie AS serie_1, c0_.rang AS rang_2, c0_.nationalite AS nationalite_3, c0_.nom AS nom_4, c0_.prenom AS prenom_5, c0_.licence AS licence_6, c0_.ligue AS ligue_7, c0_.club AS club_8, c0_.nombre_tournois AS nombre_tournois_9, c0_.total_points AS total_points_10, c0_.equivalence_plus50 AS equivalence_plus50_11, c0_.equivalence_autres AS equivalence_autres_12, c0_.import_id AS import_id_13 FROM classement_fft_joueur c0_ INNER JOIN classement_fft_import c1_ ON c0_.import_id = c1_.id WHERE UPPER(TRIM(c0_.nom)) = ? AND UPPER(TRIM(c0_.prenom)) = ? ORDER BY c1_.date_import DESC, c0_.total_points DESC

Parameters:

[
  "LAGUEL"
  "JÉROME"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  c0_.id AS id_0,
  c0_.serie AS serie_1,
  c0_.rang AS rang_2,
  c0_.nationalite AS nationalite_3,
  c0_.nom AS nom_4,
  c0_.prenom AS prenom_5,
  c0_.licence AS licence_6,
  c0_.ligue AS ligue_7,
  c0_.club AS club_8,
  c0_.nombre_tournois AS nombre_tournois_9,
  c0_.total_points AS total_points_10,
  c0_.equivalence_plus50 AS equivalence_plus50_11,
  c0_.equivalence_autres AS equivalence_autres_12,
  c0_.import_id AS import_id_13
FROM
  classement_fft_joueur c0_
  INNER JOIN classement_fft_import c1_ ON c0_.import_id = c1_.id
WHERE
  UPPER(
    TRIM(c0_.nom)
  ) = ?
  AND UPPER(
    TRIM(c0_.prenom)
  ) = ?
ORDER BY
  c1_.date_import DESC,
  c0_.total_points DESC

SELECT c0_.id AS id_0, c0_.serie AS serie_1, c0_.rang AS rang_2, c0_.nationalite AS nationalite_3, c0_.nom AS nom_4, c0_.prenom AS prenom_5, c0_.licence AS licence_6, c0_.ligue AS ligue_7, c0_.club AS club_8, c0_.nombre_tournois AS nombre_tournois_9, c0_.total_points AS total_points_10, c0_.equivalence_plus50 AS equivalence_plus50_11, c0_.equivalence_autres AS equivalence_autres_12, c0_.import_id AS import_id_13 FROM classement_fft_joueur c0_ INNER JOIN classement_fft_import c1_ ON c0_.import_id = c1_.id WHERE UPPER(TRIM(c0_.nom)) = 'LAGUEL' AND UPPER(TRIM(c0_.prenom)) = 'JÉROME' ORDER BY c1_.date_import DESC, c0_.total_points DESC;

#	File/Call
1	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 27)
2	Doctrine\ORM\Query->_doExecute (line 296)
3	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 930)
4	Doctrine\ORM\AbstractQuery->execute (line 886)
5	Doctrine\ORM\AbstractQuery->getResult (line 688)
6	App\Repository\ClassementFftJoueurRepository->findAllCategoriesByNomPrenom (line 88)
7	App\Controller\PlayerController->index (line 49)
8	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
9	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
10	Symfony\Component\HttpKernel\Kernel->handle (line 193)
11	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
12	require_once (line 32)
13	require_once (line 5)

10.43 ms
(12.26%)

SELECT c0_.id AS id_0, c0_.serie AS serie_1, c0_.rang AS rang_2, c0_.nationalite AS nationalite_3, c0_.nom AS nom_4, c0_.prenom AS prenom_5, c0_.licence AS licence_6, c0_.ligue AS ligue_7, c0_.club AS club_8, c0_.nombre_tournois AS nombre_tournois_9, c0_.total_points AS total_points_10, c0_.equivalence_plus50 AS equivalence_plus50_11, c0_.equivalence_autres AS equivalence_autres_12, c0_.import_id AS import_id_13 FROM classement_fft_joueur c0_ INNER JOIN classement_fft_import c1_ ON c0_.import_id = c1_.id WHERE c0_.licence IN (?, ?, ?, ?) ORDER BY c1_.date_import DESC, c0_.total_points DESC

Parameters:

[
  "3421995J"
  "3421995 J"
  "3421995j"
  "3421995 j"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  c0_.id AS id_0,
  c0_.serie AS serie_1,
  c0_.rang AS rang_2,
  c0_.nationalite AS nationalite_3,
  c0_.nom AS nom_4,
  c0_.prenom AS prenom_5,
  c0_.licence AS licence_6,
  c0_.ligue AS ligue_7,
  c0_.club AS club_8,
  c0_.nombre_tournois AS nombre_tournois_9,
  c0_.total_points AS total_points_10,
  c0_.equivalence_plus50 AS equivalence_plus50_11,
  c0_.equivalence_autres AS equivalence_autres_12,
  c0_.import_id AS import_id_13
FROM
  classement_fft_joueur c0_
  INNER JOIN classement_fft_import c1_ ON c0_.import_id = c1_.id
WHERE
  c0_.licence IN (?, ?, ?, ?)
ORDER BY
  c1_.date_import DESC,
  c0_.total_points DESC

SELECT c0_.id AS id_0, c0_.serie AS serie_1, c0_.rang AS rang_2, c0_.nationalite AS nationalite_3, c0_.nom AS nom_4, c0_.prenom AS prenom_5, c0_.licence AS licence_6, c0_.ligue AS ligue_7, c0_.club AS club_8, c0_.nombre_tournois AS nombre_tournois_9, c0_.total_points AS total_points_10, c0_.equivalence_plus50 AS equivalence_plus50_11, c0_.equivalence_autres AS equivalence_autres_12, c0_.import_id AS import_id_13 FROM classement_fft_joueur c0_ INNER JOIN classement_fft_import c1_ ON c0_.import_id = c1_.id WHERE c0_.licence IN ('3421995J', '3421995 J', '3421995j', '3421995 j') ORDER BY c1_.date_import DESC, c0_.total_points DESC;

#	File/Call
1	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 27)
2	Doctrine\ORM\Query->_doExecute (line 296)
3	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 930)
4	Doctrine\ORM\AbstractQuery->execute (line 886)
5	Doctrine\ORM\AbstractQuery->getResult (line 688)
6	App\Repository\ClassementFftJoueurRepository->findAllCategoriesByLicence (line 67)
7	App\Controller\PlayerController->index (line 45)
8	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
9	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
10	Symfony\Component\HttpKernel\Kernel->handle (line 193)
11	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
12	require_once (line 32)
13	require_once (line 5)

3.25 ms
(3.82%)

SELECT t0.id AS id_1, t0.categorie AS categorie_2, t0.date_import AS date_import_3, t0.nom_fichier AS nom_fichier_4, t0.chemin_fichier AS chemin_fichier_5, t0.nombre_joueurs AS nombre_joueurs_6, t0.erreurs AS erreurs_7 FROM classement_fft_import t0 WHERE t0.id = ?

Parameters:

[
  5
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.categorie AS categorie_2,
  t0.date_import AS date_import_3,
  t0.nom_fichier AS nom_fichier_4,
  t0.chemin_fichier AS chemin_fichier_5,
  t0.nombre_joueurs AS nombre_joueurs_6,
  t0.erreurs AS erreurs_7
FROM
  classement_fft_import t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.categorie AS categorie_2, t0.date_import AS date_import_3, t0.nom_fichier AS nom_fichier_4, t0.chemin_fichier AS chemin_fichier_5, t0.nombre_joueurs AS nombre_joueurs_6, t0.erreurs AS erreurs_7 FROM classement_fft_import t0 WHERE t0.id = 5;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 738)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 756)
3	Doctrine\ORM\Proxy\ProxyFactory->{closure:Doctrine\ORM\Proxy\ProxyFactory::getProxy():217} (line 223)
4	App\Entity\ClassementFftImport::getCategorie (line 62)
5	App\Repository\ClassementFftJoueurRepository->groupByCategoryBest (line 102)
6	App\Repository\ClassementFftJoueurRepository->findAllCategoriesByLicence (line 59)
7	App\Controller\PlayerController->index (line 45)
8	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
9	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
10	Symfony\Component\HttpKernel\Kernel->handle (line 193)
11	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
12	require_once (line 32)
13	require_once (line 5)

1.40 ms
(1.65%)

SELECT u0_.id AS id_0, u0_.email AS email_1, u0_.pseudo AS pseudo_2, u0_.licence AS licence_3, u0_.id_dupr AS id_dupr_4, u0_.genre AS genre_5, u0_.nom AS nom_6, u0_.prenom AS prenom_7, u0_.date_de_naissance AS date_de_naissance_8, u0_.ville AS ville_9, u0_.description AS description_10, u0_.telephone AS telephone_11, u0_.instagram AS instagram_12, u0_.linkedin AS linkedin_13, u0_.tiktok AS tiktok_14, u0_.twitter AS twitter_15, u0_.facebook AS facebook_16, u0_.statut AS statut_17, u0_.roles AS roles_18, u0_.password AS password_19, u0_.indicateur AS indicateur_20, u0_.createur AS createur_21, u0_.stripe_account_id AS stripe_account_id_22, u0_.stripe_onboarding_complete AS stripe_onboarding_complete_23, u0_.stripe_account_created_at AS stripe_account_created_at_24, u0_.is_admin AS is_admin_25, u0_.commission_defaut AS commission_defaut_26, u0_.newsletter_consent AS newsletter_consent_27, u0_.newsletter_consent_date AS newsletter_consent_date_28, u0_.pays_id AS pays_id_29, u0_.niveau_simple_id AS niveau_simple_id_30, u0_.niveau_double_id AS niveau_double_id_31, u0_.niveau_mixte_id AS niveau_mixte_id_32 FROM `user` u0_ LIMIT 10

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  u0_.id AS id_0,
  u0_.email AS email_1,
  u0_.pseudo AS pseudo_2,
  u0_.licence AS licence_3,
  u0_.id_dupr AS id_dupr_4,
  u0_.genre AS genre_5,
  u0_.nom AS nom_6,
  u0_.prenom AS prenom_7,
  u0_.date_de_naissance AS date_de_naissance_8,
  u0_.ville AS ville_9,
  u0_.description AS description_10,
  u0_.telephone AS telephone_11,
  u0_.instagram AS instagram_12,
  u0_.linkedin AS linkedin_13,
  u0_.tiktok AS tiktok_14,
  u0_.twitter AS twitter_15,
  u0_.facebook AS facebook_16,
  u0_.statut AS statut_17,
  u0_.roles AS roles_18,
  u0_.password AS password_19,
  u0_.indicateur AS indicateur_20,
  u0_.createur AS createur_21,
  u0_.stripe_account_id AS stripe_account_id_22,
  u0_.stripe_onboarding_complete AS stripe_onboarding_complete_23,
  u0_.stripe_account_created_at AS stripe_account_created_at_24,
  u0_.is_admin AS is_admin_25,
  u0_.commission_defaut AS commission_defaut_26,
  u0_.newsletter_consent AS newsletter_consent_27,
  u0_.newsletter_consent_date AS newsletter_consent_date_28,
  u0_.pays_id AS pays_id_29,
  u0_.niveau_simple_id AS niveau_simple_id_30,
  u0_.niveau_double_id AS niveau_double_id_31,
  u0_.niveau_mixte_id AS niveau_mixte_id_32
FROM
  `user` u0_
LIMIT
  10

SELECT u0_.id AS id_0, u0_.email AS email_1, u0_.pseudo AS pseudo_2, u0_.licence AS licence_3, u0_.id_dupr AS id_dupr_4, u0_.genre AS genre_5, u0_.nom AS nom_6, u0_.prenom AS prenom_7, u0_.date_de_naissance AS date_de_naissance_8, u0_.ville AS ville_9, u0_.description AS description_10, u0_.telephone AS telephone_11, u0_.instagram AS instagram_12, u0_.linkedin AS linkedin_13, u0_.tiktok AS tiktok_14, u0_.twitter AS twitter_15, u0_.facebook AS facebook_16, u0_.statut AS statut_17, u0_.roles AS roles_18, u0_.password AS password_19, u0_.indicateur AS indicateur_20, u0_.createur AS createur_21, u0_.stripe_account_id AS stripe_account_id_22, u0_.stripe_onboarding_complete AS stripe_onboarding_complete_23, u0_.stripe_account_created_at AS stripe_account_created_at_24, u0_.is_admin AS is_admin_25, u0_.commission_defaut AS commission_defaut_26, u0_.newsletter_consent AS newsletter_consent_27, u0_.newsletter_consent_date AS newsletter_consent_date_28, u0_.pays_id AS pays_id_29, u0_.niveau_simple_id AS niveau_simple_id_30, u0_.niveau_double_id AS niveau_double_id_31, u0_.niveau_mixte_id AS niveau_mixte_id_32 FROM `user` u0_ LIMIT 10;

#	File/Call
1	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 27)
2	Doctrine\ORM\Query->_doExecute (line 296)
3	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 930)
4	Doctrine\ORM\AbstractQuery->execute (line 886)
5	Doctrine\ORM\AbstractQuery->getResult (line 688)
6	App\Repository\UserRepository->findFilteredUsers (line 89)
7	App\Controller\PlayerController->index (line 33)
8	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
9	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
10	Symfony\Component\HttpKernel\Kernel->handle (line 193)
11	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
12	require_once (line 32)
13	require_once (line 5)

0.96 ms
(1.13%)

SELECT COUNT(u0_.id) AS sclr_0 FROM `user` u0_

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  COUNT(u0_.id) AS sclr_0
FROM
  `user` u0_

SELECT COUNT(u0_.id) AS sclr_0 FROM `user` u0_;

#	File/Call
1	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 27)
2	Doctrine\ORM\Query->_doExecute (line 296)
3	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 930)
4	Doctrine\ORM\AbstractQuery->execute (line 886)
5	Doctrine\ORM\AbstractQuery->getSingleResult (line 772)
6	Doctrine\ORM\AbstractQuery->getSingleScalarResult (line 801)
7	App\Repository\UserRepository->countFilteredUsers (line 127)
8	App\Controller\PlayerController->index (line 34)
9	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
10	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
11	Symfony\Component\HttpKernel\Kernel->handle (line 193)
12	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
13	require_once (line 32)
14	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
App\Entity\ClassementFftJoueur	17
App\Entity\User	10
App\Entity\ClassementFftImport	6
App\Entity\Niveau	4

Entities Mapping

Class	Mapping errors
App\Entity\User	No errors.
App\Entity\Pays	No errors.
App\Entity\Niveau	No errors.
App\Entity\UserSelection	No errors.
App\Entity\Payment	No errors.
App\Entity\ClassementFftJoueur	No errors.
App\Entity\ClassementFftImport	No errors.

Symfony Profiler

GET https://preprod.tournoipickleball.fr/joueurs

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping