Symfony Profiler

Query Metrics

2 Database Queries

2 Different statements

1.93 ms Query time

1 Invalid entities

10 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

1.42 ms
(73.62%)

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 930

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
  930

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 930;

#	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.51 ms
(26.38%)

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	10

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

Configuration Settings

Theme

Page Width