Symfony Profiler

Query Metrics

2 Database Queries

2 Different statements

0.17 ms Query time

0 Invalid entities

0 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

0.10 ms
(57.64%)

SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.slug AS slug_2, s0_.description AS description_3, s0_.image_name AS image_name_4, s0_.image_size AS image_size_5, s0_.image_dark_name AS image_dark_name_6, s0_.image_dark_size AS image_dark_size_7, s0_.active AS active_8, s0_.position AS position_9, s0_.roles_hide AS roles_hide_10, s0_.created_at AS created_at_11, s0_.updated_at AS updated_at_12 FROM site s0_ WHERE s0_.active = ? ORDER BY s0_.position ASC

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  s0_.id AS id_0,
  s0_.name AS name_1,
  s0_.slug AS slug_2,
  s0_.description AS description_3,
  s0_.image_name AS image_name_4,
  s0_.image_size AS image_size_5,
  s0_.image_dark_name AS image_dark_name_6,
  s0_.image_dark_size AS image_dark_size_7,
  s0_.active AS active_8,
  s0_.position AS position_9,
  s0_.roles_hide AS roles_hide_10,
  s0_.created_at AS created_at_11,
  s0_.updated_at AS updated_at_12
FROM
  site s0_
WHERE
  s0_.active = ?
ORDER BY
  s0_.position ASC

SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.slug AS slug_2, s0_.description AS description_3, s0_.image_name AS image_name_4, s0_.image_size AS image_size_5, s0_.image_dark_name AS image_dark_name_6, s0_.image_dark_size AS image_dark_size_7, s0_.active AS active_8, s0_.position AS position_9, s0_.roles_hide AS roles_hide_10, s0_.created_at AS created_at_11, s0_.updated_at AS updated_at_12 FROM site s0_ WHERE s0_.active = 1 ORDER BY s0_.position ASC;

#	File/Call
1	Doctrine\DBAL\Connection->executeCacheQuery (line 851)
2	Doctrine\DBAL\Connection->executeQuery (line 789)
3	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 27)
4	Doctrine\ORM\Query->_doExecute (line 296)
5	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 930)
6	Doctrine\ORM\AbstractQuery->execute (line 886)
7	Doctrine\ORM\AbstractQuery->getResult (line 688)
8	App\Repository\SiteRepository->findAllWithOrder (line 31)
9	App\Service\SelectedSiteContext->getAllActiveSites (line 37)
10	App\EventListener\SiteSlugListener->onKernelRequest (line 38)
11	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
12	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
13	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
14	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 126)
15	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 159)
16	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
17	Symfony\Component\HttpKernel\Kernel->handle (line 191)
18	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
19	require_once (line 32)
20	require_once (line 5)

0.07 ms
(42.36%)

SELECT t0.id AS id_1, t0.start_value AS start_value_2, t0.used AS used_3, t0.user_id AS user_id_4, t0.periode_id AS periode_id_5 FROM cagnotte t0 WHERE t0.id = ?

Parameters:

[
  "batch-delete"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.start_value AS start_value_2,
  t0.used AS used_3,
  t0.user_id AS user_id_4,
  t0.periode_id AS periode_id_5
FROM
  cagnotte t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.start_value AS start_value_2, t0.used AS used_3, t0.user_id AS user_id_4, t0.periode_id AS periode_id_5 FROM cagnotte t0 WHERE t0.id = 'batch-delete';

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 738)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 756)
3	Doctrine\ORM\EntityManager->find (line 366)
4	Doctrine\ORM\EntityRepository->find (line 86)
5	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepository->find (line 66)
6	EasyCorp\Bundle\EasyAdminBundle\Factory\EntityFactory->getEntityInstance (line 130)
7	EasyCorp\Bundle\EasyAdminBundle\Factory\EntityFactory->doCreate (line 89)
8	EasyCorp\Bundle\EasyAdminBundle\Factory\EntityFactory->create (line 35)
9	EasyCorp\Bundle\EasyAdminBundle\Factory\AdminContextFactory->getEntityDto (line 266)
10	EasyCorp\Bundle\EasyAdminBundle\Factory\AdminContextFactory->create (line 68)
11	EasyCorp\Bundle\EasyAdminBundle\EventListener\AdminRouterSubscriber->onKernelRequest (line 89)
12	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
13	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
14	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
15	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 126)
16	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 159)
17	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
18	Symfony\Component\HttpKernel\Kernel->handle (line 191)
19	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
20	require_once (line 32)
21	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

Entities Mapping

Class	Mapping errors
App\Entity\Site	No errors.
App\Entity\Cagnotte	No errors.
App\Entity\User	No errors.
App\Entity\Periode	No errors.
App\Entity\ProductCategory	No errors.

Symfony Profiler

GET https://adidas.toofoot.com/admin/cagnotte/batch-delete?sort%5Bid%5D=DESC

Configuration Settings

Theme

Page Width