Symfony Profiler

Query Metrics

2 Database Queries

2 Different statements

2.72 ms Query time

1 Invalid entities

1 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

2.16 ms
(79.38%)

SELECT u0_.id AS id_0, u0_.email AS email_1, u0_.pseudo AS pseudo_2, u0_.licence AS licence_3, u0_.genre AS genre_4, u0_.nom AS nom_5, u0_.prenom AS prenom_6, u0_.date_de_naissance AS date_de_naissance_7, u0_.ville AS ville_8, u0_.description AS description_9, u0_.telephone AS telephone_10, u0_.instagram AS instagram_11, u0_.linkedin AS linkedin_12, u0_.tiktok AS tiktok_13, u0_.twitter AS twitter_14, u0_.facebook AS facebook_15, u0_.statut AS statut_16, u0_.roles AS roles_17, u0_.password AS password_18, u0_.indicateur AS indicateur_19, u0_.createur AS createur_20, u0_.pays_id AS pays_id_21, u0_.niveau_simple_id AS niveau_simple_id_22, u0_.niveau_double_id AS niveau_double_id_23, u0_.niveau_mixte_id AS niveau_mixte_id_24 FROM `user` u0_ LIMIT 10 OFFSET 940

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_.genre AS genre_4,
  u0_.nom AS nom_5,
  u0_.prenom AS prenom_6,
  u0_.date_de_naissance AS date_de_naissance_7,
  u0_.ville AS ville_8,
  u0_.description AS description_9,
  u0_.telephone AS telephone_10,
  u0_.instagram AS instagram_11,
  u0_.linkedin AS linkedin_12,
  u0_.tiktok AS tiktok_13,
  u0_.twitter AS twitter_14,
  u0_.facebook AS facebook_15,
  u0_.statut AS statut_16,
  u0_.roles AS roles_17,
  u0_.password AS password_18,
  u0_.indicateur AS indicateur_19,
  u0_.createur AS createur_20,
  u0_.pays_id AS pays_id_21,
  u0_.niveau_simple_id AS niveau_simple_id_22,
  u0_.niveau_double_id AS niveau_double_id_23,
  u0_.niveau_mixte_id AS niveau_mixte_id_24
FROM
  `user` u0_
LIMIT
  10
OFFSET
  940

SELECT u0_.id AS id_0, u0_.email AS email_1, u0_.pseudo AS pseudo_2, u0_.licence AS licence_3, u0_.genre AS genre_4, u0_.nom AS nom_5, u0_.prenom AS prenom_6, u0_.date_de_naissance AS date_de_naissance_7, u0_.ville AS ville_8, u0_.description AS description_9, u0_.telephone AS telephone_10, u0_.instagram AS instagram_11, u0_.linkedin AS linkedin_12, u0_.tiktok AS tiktok_13, u0_.twitter AS twitter_14, u0_.facebook AS facebook_15, u0_.statut AS statut_16, u0_.roles AS roles_17, u0_.password AS password_18, u0_.indicateur AS indicateur_19, u0_.createur AS createur_20, u0_.pays_id AS pays_id_21, u0_.niveau_simple_id AS niveau_simple_id_22, u0_.niveau_double_id AS niveau_double_id_23, u0_.niveau_mixte_id AS niveau_mixte_id_24 FROM `user` u0_ LIMIT 10 OFFSET 940;

#	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 32)
8	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 181)
9	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
10	Symfony\Component\HttpKernel\Kernel->handle (line 197)
11	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
12	require_once (line 29)
13	require_once (line 5)

0.56 ms
(20.62%)

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 33)
9	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 181)
10	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
11	Symfony\Component\HttpKernel\Kernel->handle (line 197)
12	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
13	require_once (line 29)
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\User	1

Entities Mapping

Class	Mapping errors
App\Entity\User	No errors.
App\Entity\Pays	No errors.
App\Entity\Niveau	No errors.
App\Entity\UserSelection	The field 'App\Entity\UserSelection#montantPaye' has the property type 'float' that differs from the metadata field type 'string' returned by the 'decimal' DBAL type.

Symfony Profiler

GET https://preprod.tournoispickleball.fr/joueurs?page=95

Configuration Settings

Theme

Page Width