Symfony Profiler

Query Metrics

1 Database Queries

1 Different statements

15.24 ms Query time

0 Invalid entities

12 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

15.24 ms
(100.00%)

SELECT u0_.id AS id_0, u0_.uuid AS uuid_1, u0_.nom AS nom_2, u0_.prenom AS prenom_3, u0_.email AS email_4, u0_.email_secondaire AS email_secondaire_5, u0_.numero_ordinal AS numero_ordinal_6, u0_.telephone AS telephone_7, u0_.password_hash AS password_hash_8, u0_.status AS status_9, u0_.roles AS roles_10, u0_.departements AS departements_11, u0_.created_at AS created_at_12, f1_.id AS id_13, f1_.name AS name_14, f1_.slug AS slug_15, f1_.created_at AS created_at_16, u0_.filiere_id AS filiere_id_17 FROM users u0_ LEFT JOIN filiere f1_ ON u0_.filiere_id = f1_.id ORDER BY u0_.nom ASC, u0_.prenom ASC

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  u0_.id AS id_0,
  u0_.uuid AS uuid_1,
  u0_.nom AS nom_2,
  u0_.prenom AS prenom_3,
  u0_.email AS email_4,
  u0_.email_secondaire AS email_secondaire_5,
  u0_.numero_ordinal AS numero_ordinal_6,
  u0_.telephone AS telephone_7,
  u0_.password_hash AS password_hash_8,
  u0_.status AS status_9,
  u0_.roles AS roles_10,
  u0_.departements AS departements_11,
  u0_.created_at AS created_at_12,
  f1_.id AS id_13,
  f1_.name AS name_14,
  f1_.slug AS slug_15,
  f1_.created_at AS created_at_16,
  u0_.filiere_id AS filiere_id_17
FROM
  users u0_
  LEFT JOIN filiere f1_ ON u0_.filiere_id = f1_.id
ORDER BY
  u0_.nom ASC,
  u0_.prenom ASC

SELECT u0_.id AS id_0, u0_.uuid AS uuid_1, u0_.nom AS nom_2, u0_.prenom AS prenom_3, u0_.email AS email_4, u0_.email_secondaire AS email_secondaire_5, u0_.numero_ordinal AS numero_ordinal_6, u0_.telephone AS telephone_7, u0_.password_hash AS password_hash_8, u0_.status AS status_9, u0_.roles AS roles_10, u0_.departements AS departements_11, u0_.created_at AS created_at_12, f1_.id AS id_13, f1_.name AS name_14, f1_.slug AS slug_15, f1_.created_at AS created_at_16, u0_.filiere_id AS filiere_id_17 FROM users u0_ LEFT JOIN filiere f1_ ON u0_.filiere_id = f1_.id ORDER BY u0_.nom ASC, u0_.prenom ASC;

#	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\Admin\Infrastructure\Http\AdminUserController->list (line 43)
7	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
8	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
9	Symfony\Component\HttpKernel\Kernel->handle (line 182)
10	Runtime\FrankenPhpSymfony\Runner->{closure:Runtime\FrankenPhpSymfony\Runner::run():33} (line 38)
11	frankenphp_handle_request (line 45)
12	Runtime\FrankenPhpSymfony\Runner::run (line 45)
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\IdentityAccess\Domain\Model\User	8
App\Shared\Domain\Model\Filiere	4

Entities Mapping

Class	Mapping errors
App\IdentityAccess\Domain\Model\User	No errors.
App\Shared\Domain\Model\Filiere	No errors.
App\KnowledgeBase\Infrastructure\Persistence\FaqEntryMapping	No errors.

Symfony Profiler

GET https://mercure.terrenourriciere.org/admin/users

Configuration Settings

Theme

Page Width