Symfony Profiler

Query Metrics

4 Database Queries

4 Different statements

1.36 ms Query time

0 Invalid entities

Queries

Group similar statements

#▲

Time

Info

0.37 ms

SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.is_verified AS is_verified_5, t0.enabled AS enabled_6, t0.firstname AS firstname_7, t0.lastname AS lastname_8, t0.phone AS phone_9, t0.marketing AS marketing_10, t0.company AS company_11, t0.street AS street_12, t0.house_number AS house_number_13, t0.city AS city_14, t0.zipcode AS zipcode_15, t0.nip AS nip_16, t0.delete_request AS delete_request_17, t0.created AS created_18, t0.updated AS updated_19, t0.sep_member AS sep_member_20, t0.sep_fee AS sep_fee_21, t0.sep_number AS sep_number_22 FROM user t0 WHERE t0.id = ?

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.email AS email_2,
  t0.roles AS roles_3,
  t0.password AS password_4,
  t0.is_verified AS is_verified_5,
  t0.enabled AS enabled_6,
  t0.firstname AS firstname_7,
  t0.lastname AS lastname_8,
  t0.phone AS phone_9,
  t0.marketing AS marketing_10,
  t0.company AS company_11,
  t0.street AS street_12,
  t0.house_number AS house_number_13,
  t0.city AS city_14,
  t0.zipcode AS zipcode_15,
  t0.nip AS nip_16,
  t0.delete_request AS delete_request_17,
  t0.created AS created_18,
  t0.updated AS updated_19,
  t0.sep_member AS sep_member_20,
  t0.sep_fee AS sep_fee_21,
  t0.sep_number AS sep_number_22
FROM
  user t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.is_verified AS is_verified_5, t0.enabled AS enabled_6, t0.firstname AS firstname_7, t0.lastname AS lastname_8, t0.phone AS phone_9, t0.marketing AS marketing_10, t0.company AS company_11, t0.street AS street_12, t0.house_number AS house_number_13, t0.city AS city_14, t0.zipcode AS zipcode_15, t0.nip AS nip_16, t0.delete_request AS delete_request_17, t0.created AS created_18, t0.updated AS updated_19, t0.sep_member AS sep_member_20, t0.sep_fee AS sep_fee_21, t0.sep_number AS sep_number_22 FROM user t0 WHERE t0.id = 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 779)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 797)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 530)
4	Doctrine\ORM\EntityManager->find (line 196)
5	Doctrine\ORM\EntityRepository->find (line 92)
6	Symfony\Bridge\Doctrine\Security\User\EntityUserProvider->refreshUser (line 214)
7	Symfony\Component\Security\Http\Firewall\ContextListener->refreshUser (line 131)
8	Symfony\Component\Security\Http\Firewall\ContextListener->authenticate (line 46)
9	Symfony\Bundle\SecurityBundle\Debug\WrappedLazyListener->authenticate (line 60)
10	Symfony\Bundle\SecurityBundle\Security\LazyFirewallContext->__invoke (line 80)
11	Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener->callListeners (line 95)
12	Symfony\Component\Security\Http\Firewall->onKernelRequest (line 116)
13	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 220)
14	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
15	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 139)
16	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 157)
17	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
18	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
19	Symfony\Component\HttpKernel\Kernel->handle (line 86)
20	Symfony\Component\HttpKernel\HttpCache\SubRequestHandler::handle (line 476)
21	Symfony\Component\HttpKernel\HttpCache\HttpCache->forward (line 68)
22	Symfony\Bundle\FrameworkBundle\HttpCache\HttpCache->forward (line 451)
23	Symfony\Component\HttpKernel\HttpCache\HttpCache->fetch (line 349)
24	Symfony\Component\HttpKernel\HttpCache\HttpCache->lookup (line 222)
25	Symfony\Component\HttpKernel\HttpCache\HttpCache->handle (line 188)
26	Symfony\Component\HttpKernel\Kernel->handle (line 35)
27	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
28	require_once (line 5)

0.33 ms

SELECT DISTINCT e0_.id AS id_0 FROM event e0_ LIMIT 20

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  DISTINCT e0_.id AS id_0
FROM
  event e0_
LIMIT
  20

SELECT DISTINCT e0_.id AS id_0 FROM event e0_ LIMIT 20;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 31)
2	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 330)
3	Doctrine\ORM\Query->_doExecute (line 1218)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 1172)
5	Doctrine\ORM\AbstractQuery->execute (line 943)
6	Doctrine\ORM\AbstractQuery->getScalarResult (line 153)
7	Doctrine\ORM\Tools\Pagination\Paginator->getIterator (line 70)
8	EasyCorp\Bundle\EasyAdminBundle\Orm\EntityPaginator->paginate (line 26)
9	EasyCorp\Bundle\EasyAdminBundle\Factory\PaginatorFactory->create (line 132)
10	EasyCorp\Bundle\EasyAdminBundle\Controller\AbstractCrudController->index (line 181)
11	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
12	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
13	Symfony\Component\HttpKernel\Kernel->handle (line 86)
14	Symfony\Component\HttpKernel\HttpCache\SubRequestHandler::handle (line 476)
15	Symfony\Component\HttpKernel\HttpCache\HttpCache->forward (line 68)
16	Symfony\Bundle\FrameworkBundle\HttpCache\HttpCache->forward (line 451)
17	Symfony\Component\HttpKernel\HttpCache\HttpCache->fetch (line 349)
18	Symfony\Component\HttpKernel\HttpCache\HttpCache->lookup (line 222)
19	Symfony\Component\HttpKernel\HttpCache\HttpCache->handle (line 188)
20	Symfony\Component\HttpKernel\Kernel->handle (line 35)
21	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
22	require_once (line 5)

0.41 ms

SELECT e0_.id AS id_0, e0_.time_from AS time_from_1, e0_.time_to AS time_to_2, e0_.name AS name_3, e0_.slug AS slug_4, e0_.enabled AS enabled_5, e0_.repeat_for AS repeat_for_6, e0_.startdate AS startdate_7, e0_.members_limit AS members_limit_8, e0_.created AS created_9, e0_.updated AS updated_10, e0_.booking_start_date AS booking_start_date_11, e0_.nobooking AS nobooking_12, e0_.image AS image_13, e0_.content AS content_14, e0_.color AS color_15, e0_.inactive_to AS inactive_to_16, e0_.inactive_from AS inactive_from_17, e0_.type AS type_18 FROM event e0_ WHERE e0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)

Parameters:

View formatted query View runnable query Explain query View query backtrace

SELECT
  e0_.id AS id_0,
  e0_.time_from AS time_from_1,
  e0_.time_to AS time_to_2,
  e0_.name AS name_3,
  e0_.slug AS slug_4,
  e0_.enabled AS enabled_5,
  e0_.repeat_for AS repeat_for_6,
  e0_.startdate AS startdate_7,
  e0_.members_limit AS members_limit_8,
  e0_.created AS created_9,
  e0_.updated AS updated_10,
  e0_.booking_start_date AS booking_start_date_11,
  e0_.nobooking AS nobooking_12,
  e0_.image AS image_13,
  e0_.content AS content_14,
  e0_.color AS color_15,
  e0_.inactive_to AS inactive_to_16,
  e0_.inactive_from AS inactive_from_17,
  e0_.type AS type_18
FROM
  event e0_
WHERE
  e0_.id IN (
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?
  )

SELECT e0_.id AS id_0, e0_.time_from AS time_from_1, e0_.time_to AS time_to_2, e0_.name AS name_3, e0_.slug AS slug_4, e0_.enabled AS enabled_5, e0_.repeat_for AS repeat_for_6, e0_.startdate AS startdate_7, e0_.members_limit AS members_limit_8, e0_.created AS created_9, e0_.updated AS updated_10, e0_.booking_start_date AS booking_start_date_11, e0_.nobooking AS nobooking_12, e0_.image AS image_13, e0_.content AS content_14, e0_.color AS color_15, e0_.inactive_to AS inactive_to_16, e0_.inactive_from AS inactive_from_17, e0_.type AS type_18 FROM event e0_ WHERE e0_.id IN (35, 20, 38, 47, 88, 67, 32, 59, 43, 44, 63, 68, 80, 85, 24, 14, 52, 3, 18, 60);

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 31)
2	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 330)
3	Doctrine\ORM\Query->_doExecute (line 1218)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 1172)
5	Doctrine\ORM\AbstractQuery->execute (line 907)
6	Doctrine\ORM\AbstractQuery->getResult (line 171)
7	Doctrine\ORM\Tools\Pagination\Paginator->getIterator (line 70)
8	EasyCorp\Bundle\EasyAdminBundle\Orm\EntityPaginator->paginate (line 26)
9	EasyCorp\Bundle\EasyAdminBundle\Factory\PaginatorFactory->create (line 132)
10	EasyCorp\Bundle\EasyAdminBundle\Controller\AbstractCrudController->index (line 181)
11	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
12	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
13	Symfony\Component\HttpKernel\Kernel->handle (line 86)
14	Symfony\Component\HttpKernel\HttpCache\SubRequestHandler::handle (line 476)
15	Symfony\Component\HttpKernel\HttpCache\HttpCache->forward (line 68)
16	Symfony\Bundle\FrameworkBundle\HttpCache\HttpCache->forward (line 451)
17	Symfony\Component\HttpKernel\HttpCache\HttpCache->fetch (line 349)
18	Symfony\Component\HttpKernel\HttpCache\HttpCache->lookup (line 222)
19	Symfony\Component\HttpKernel\HttpCache\HttpCache->handle (line 188)
20	Symfony\Component\HttpKernel\Kernel->handle (line 35)
21	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
22	require_once (line 5)

0.24 ms

SELECT count(e0_.id) AS sclr_0 FROM event e0_

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  count(e0_.id) AS sclr_0
FROM
  event e0_

SELECT count(e0_.id) AS sclr_0 FROM event e0_;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 31)
2	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 330)
3	Doctrine\ORM\Query->_doExecute (line 1218)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 1172)
5	Doctrine\ORM\AbstractQuery->execute (line 943)
6	Doctrine\ORM\AbstractQuery->getScalarResult (line 120)
7	Doctrine\ORM\Tools\Pagination\Paginator->count (line 71)
8	EasyCorp\Bundle\EasyAdminBundle\Orm\EntityPaginator->paginate (line 26)
9	EasyCorp\Bundle\EasyAdminBundle\Factory\PaginatorFactory->create (line 132)
10	EasyCorp\Bundle\EasyAdminBundle\Controller\AbstractCrudController->index (line 181)
11	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
12	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
13	Symfony\Component\HttpKernel\Kernel->handle (line 86)
14	Symfony\Component\HttpKernel\HttpCache\SubRequestHandler::handle (line 476)
15	Symfony\Component\HttpKernel\HttpCache\HttpCache->forward (line 68)
16	Symfony\Bundle\FrameworkBundle\HttpCache\HttpCache->forward (line 451)
17	Symfony\Component\HttpKernel\HttpCache\HttpCache->fetch (line 349)
18	Symfony\Component\HttpKernel\HttpCache\HttpCache->lookup (line 222)
19	Symfony\Component\HttpKernel\HttpCache\HttpCache->handle (line 188)
20	Symfony\Component\HttpKernel\Kernel->handle (line 35)
21	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
22	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.

Entities Mapping

Class	Mapping errors
App\Entity\User	No errors.
App\Entity\Application	No errors.
App\Entity\Event	No errors.
App\Entity\EventMember	No errors.

Symfony Profiler

GET https://sep.dev.biolabs.pl/admin?crudAction=index&crudControllerFqcn=App%5CController%5CAdmin%5CEventCrudController

Configuration Settings

Theme

Page Width

Query Metrics

Queries

Database Connections

Entity Managers

Second Level Cache

Entities Mapping