Symfony Profiler

Query Metrics

2 Database Queries

2 Different statements

2.32 ms Query time

2 Invalid entities

4 Managed entities

Queries

Group similar statements

#▲

Time

Info

1.20 ms

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_.pays_id AS pays_id_22, u0_.niveau_simple_id AS niveau_simple_id_23, u0_.niveau_double_id AS niveau_double_id_24, u0_.niveau_mixte_id AS niveau_mixte_id_25 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_.pays_id AS pays_id_22,
  u0_.niveau_simple_id AS niveau_simple_id_23,
  u0_.niveau_double_id AS niveau_double_id_24,
  u0_.niveau_mixte_id AS niveau_mixte_id_25
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_.pays_id AS pays_id_22, u0_.niveau_simple_id AS niveau_simple_id_23, u0_.niveau_double_id AS niveau_double_id_24, u0_.niveau_mixte_id AS niveau_mixte_id_25 FROM `user` u0_ LIMIT 10;

#	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 689)
6	Doctrine\ORM\AbstractQuery->getResult (line 89)
7	App\Repository\UserRepository->findFilteredUsers (line 32)
8	App\Controller\PlayerController->index (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.12 ms

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\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 773)
6	Doctrine\ORM\AbstractQuery->getSingleResult (line 802)
7	Doctrine\ORM\AbstractQuery->getSingleScalarResult (line 127)
8	App\Repository\UserRepository->countFilteredUsers (line 33)
9	App\Controller\PlayerController->index (line 181)
10	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
11	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
12	Symfony\Component\HttpKernel\Kernel->handle (line 35)
13	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (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	2
App\Entity\Niveau	2

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.
App\Entity\Payment	The field 'App\Entity\Payment#montantTotal' has the property type 'float' that differs from the metadata field type 'string' returned by the 'decimal' DBAL type. The field 'App\Entity\Payment#montantEpreuves' has the property type 'float' that differs from the metadata field type 'string' returned by the 'decimal' DBAL type. The field 'App\Entity\Payment#montantRepas' has the property type 'float' that differs from the metadata field type 'string' returned by the 'decimal' DBAL type. The field 'App\Entity\Payment#montantReduction' has the property type 'float' that differs from the metadata field type 'string' returned by the 'decimal' DBAL type.

Symfony Profiler

GET https://tournoipickleball.fr/joueurs?page=1

Configuration Settings

Theme

Page Width