Symfony Profiler

Query Metrics

3 Database Queries

3 Different statements

6.75 ms Query time

0 Invalid entities

21 Managed entities

Queries

Group similar statements

#▲

Time

Info

2.31 ms

SELECT DISTINCT u0_.id AS id_0, u0_.username AS username_1 FROM [user] u0_ ORDER BY u0_.username ASC OFFSET 20 ROWS FETCH NEXT 20 ROWS ONLY

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  DISTINCT u0_.id AS id_0,
  u0_.username AS username_1
FROM
  [user] u0_
ORDER BY
  u0_.username ASC
OFFSET
  20
ROWS
FETCH
  NEXT 20
ROWS
  ONLY

SELECT DISTINCT u0_.id AS id_0, u0_.username AS username_1 FROM [user] u0_ ORDER BY u0_.username ASC OFFSET 20 ROWS FETCH NEXT 20 ROWS ONLY;

#	File/Call
1	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 27)
2	Doctrine\ORM\Query->_doExecute (line 296)
3	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 935)
4	Doctrine\ORM\AbstractQuery->execute (line 891)
5	Doctrine\ORM\AbstractQuery->getScalarResult (line 725)
6	Doctrine\ORM\Tools\Pagination\Paginator->getIterator (line 127)
7	EasyCorp\Bundle\EasyAdminBundle\Orm\EntityPaginator->paginate (line 71)
8	EasyCorp\Bundle\EasyAdminBundle\Factory\PaginatorFactory->create (line 26)
9	EasyCorp\Bundle\EasyAdminBundle\Controller\AbstractCrudController->index (line 136)
10	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 181)
11	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
12	Symfony\Component\HttpKernel\Kernel->handle (line 197)
13	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
14	require_once (line 29)
15	require_once (line 5)

4.00 ms

SELECT u0_.id AS id_0, u0_.username AS username_1, u0_.roles AS roles_2, u0_.password AS password_3, u0_.full_name AS full_name_4, u0_.email AS email_5, u0_.phone AS phone_6, u0_.is_template AS is_template_7, u0_.status_id AS status_id_8, u0_.fonction_id AS fonction_id_9, u0_.service_id AS service_id_10 FROM [user] u0_ WHERE u0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) ORDER BY u0_.username ASC

Parameters:

View formatted query View runnable query Explain query View query backtrace

SELECT
  u0_.id AS id_0,
  u0_.username AS username_1,
  u0_.roles AS roles_2,
  u0_.password AS password_3,
  u0_.full_name AS full_name_4,
  u0_.email AS email_5,
  u0_.phone AS phone_6,
  u0_.is_template AS is_template_7,
  u0_.status_id AS status_id_8,
  u0_.fonction_id AS fonction_id_9,
  u0_.service_id AS service_id_10
FROM
  [user] u0_
WHERE
  u0_.id IN (
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?
  )
ORDER BY
  u0_.username ASC

SELECT u0_.id AS id_0, u0_.username AS username_1, u0_.roles AS roles_2, u0_.password AS password_3, u0_.full_name AS full_name_4, u0_.email AS email_5, u0_.phone AS phone_6, u0_.is_template AS is_template_7, u0_.status_id AS status_id_8, u0_.fonction_id AS fonction_id_9, u0_.service_id AS service_id_10 FROM [user] u0_ WHERE u0_.id IN (22, 5, 3, 6, 1, 4, 2, 50, 58, 41, 19, 17, 20, 15, 18, 16, 48, 49, 44, 56) ORDER BY u0_.username 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 935)
4	Doctrine\ORM\AbstractQuery->execute (line 891)
5	Doctrine\ORM\AbstractQuery->getResult (line 689)
6	Doctrine\ORM\Tools\Pagination\Paginator->getIterator (line 145)
7	EasyCorp\Bundle\EasyAdminBundle\Orm\EntityPaginator->paginate (line 71)
8	EasyCorp\Bundle\EasyAdminBundle\Factory\PaginatorFactory->create (line 26)
9	EasyCorp\Bundle\EasyAdminBundle\Controller\AbstractCrudController->index (line 136)
10	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 181)
11	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
12	Symfony\Component\HttpKernel\Kernel->handle (line 197)
13	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
14	require_once (line 29)
15	require_once (line 5)

0.44 ms

SELECT count(*) AS sclr_0 FROM [user] u0_

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  count(*) AS sclr_0
FROM
  [user] u0_

SELECT count(*) 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 935)
4	Doctrine\ORM\AbstractQuery->execute (line 891)
5	Doctrine\ORM\AbstractQuery->getScalarResult (line 725)
6	Doctrine\ORM\Tools\Pagination\Paginator->count (line 96)
7	EasyCorp\Bundle\EasyAdminBundle\Orm\EntityPaginator->paginate (line 72)
8	EasyCorp\Bundle\EasyAdminBundle\Factory\PaginatorFactory->create (line 26)
9	EasyCorp\Bundle\EasyAdminBundle\Controller\AbstractCrudController->index (line 136)
10	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 181)
11	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
12	Symfony\Component\HttpKernel\Kernel->handle (line 197)
13	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
14	require_once (line 29)
15	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	20
App\Entity\ListStatus	1

Entities Mapping

Class	Mapping errors
App\Entity\User	No errors.
App\Entity\ListStatus	No errors.
App\Entity\ListFunction	No errors.
App\Entity\ListService	No errors.
App\Entity\CopperBundleChangeRequest	No errors.
App\Entity\CopperBundles	No errors.
App\Entity\ConfigUserAccessRole	No errors.

Symfony Profiler

GET https://boyekoli.com/admin/user?page=2&sort%5Busername%5D=ASC

Configuration Settings

Theme

Page Width

Query Metrics

Queries

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping