Symfony Profiler

Query Metrics

5 Database Queries

5 Different statements

3.26 ms Query time

0 Invalid entities

53 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

1.14 ms
(35.02%)

SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.slug AS slug_2, c0_.description AS description_3, c0_.color AS color_4, c0_.created_at AS created_at_5, c0_.updated_at AS updated_at_6, l1_.id AS id_7, l1_.title AS title_8, l1_.slug AS slug_9, l1_.content AS content_10, l1_.excerpt AS excerpt_11, l1_.is_published AS is_published_12, l1_.order_number AS order_number_13, l1_.created_at AS created_at_14, l1_.updated_at AS updated_at_15, l1_.category_id AS category_id_16 FROM category c0_ LEFT JOIN lecture l1_ ON c0_.id = l1_.category_id ORDER BY c0_.name ASC

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  c0_.id AS id_0,
  c0_.name AS name_1,
  c0_.slug AS slug_2,
  c0_.description AS description_3,
  c0_.color AS color_4,
  c0_.created_at AS created_at_5,
  c0_.updated_at AS updated_at_6,
  l1_.id AS id_7,
  l1_.title AS title_8,
  l1_.slug AS slug_9,
  l1_.content AS content_10,
  l1_.excerpt AS excerpt_11,
  l1_.is_published AS is_published_12,
  l1_.order_number AS order_number_13,
  l1_.created_at AS created_at_14,
  l1_.updated_at AS updated_at_15,
  l1_.category_id AS category_id_16
FROM
  category c0_
  LEFT JOIN lecture l1_ ON c0_.id = l1_.category_id
ORDER BY
  c0_.name ASC

SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.slug AS slug_2, c0_.description AS description_3, c0_.color AS color_4, c0_.created_at AS created_at_5, c0_.updated_at AS updated_at_6, l1_.id AS id_7, l1_.title AS title_8, l1_.slug AS slug_9, l1_.content AS content_10, l1_.excerpt AS excerpt_11, l1_.is_published AS is_published_12, l1_.order_number AS order_number_13, l1_.created_at AS created_at_14, l1_.updated_at AS updated_at_15, l1_.category_id AS category_id_16 FROM category c0_ LEFT JOIN lecture l1_ ON c0_.id = l1_.category_id ORDER BY c0_.name 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\Repository\CategoryRepository->findAllOrdered (line 23)
7	App\Controller\LectureController->index (line 70)
8	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
9	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
10	Symfony\Component\HttpKernel\Kernel->handle (line 191)
11	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
12	require_once (line 32)
13	require_once (line 5)

0.66 ms
(20.09%)

SELECT count(DISTINCT l0_.id) AS sclr_0 FROM lecture l0_ WHERE l0_.is_published = ?

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  count(DISTINCT l0_.id) AS sclr_0
FROM
  lecture l0_
WHERE
  l0_.is_published = ?

SELECT count(DISTINCT l0_.id) AS sclr_0 FROM lecture l0_ WHERE l0_.is_published = 1;

#	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->getScalarResult (line 724)
6	Doctrine\ORM\Tools\Pagination\Paginator->count (line 96)
7	count (line 43)
8	Knp\Component\Pager\Event\Subscriber\Paginate\Doctrine\ORM\QuerySubscriber::items (line 43)
9	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
10	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
11	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
12	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 126)
13	Knp\Component\Pager\Paginator->paginate (line 97)
14	Container0G5pq68\PaginatorProxyBa079e5->paginate (line 20)
15	App\Controller\LectureController->index (line 60)
16	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
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)

0.63 ms
(19.31%)

SELECT l0_.id AS id_0, l0_.title AS title_1, l0_.slug AS slug_2, l0_.content AS content_3, l0_.excerpt AS excerpt_4, l0_.is_published AS is_published_5, l0_.order_number AS order_number_6, l0_.created_at AS created_at_7, l0_.updated_at AS updated_at_8, l0_.category_id AS category_id_9 FROM lecture l0_ WHERE l0_.is_published = ? AND l0_.id IN (?, ?, ?, ?, ?, ?) ORDER BY l0_.order_number ASC, l0_.created_at DESC

Parameters:

View formatted query View runnable query Explain query View query backtrace

SELECT
  l0_.id AS id_0,
  l0_.title AS title_1,
  l0_.slug AS slug_2,
  l0_.content AS content_3,
  l0_.excerpt AS excerpt_4,
  l0_.is_published AS is_published_5,
  l0_.order_number AS order_number_6,
  l0_.created_at AS created_at_7,
  l0_.updated_at AS updated_at_8,
  l0_.category_id AS category_id_9
FROM
  lecture l0_
WHERE
  l0_.is_published = ?
  AND l0_.id IN (?, ?, ?, ?, ?, ?)
ORDER BY
  l0_.order_number ASC,
  l0_.created_at DESC

SELECT l0_.id AS id_0, l0_.title AS title_1, l0_.slug AS slug_2, l0_.content AS content_3, l0_.excerpt AS excerpt_4, l0_.is_published AS is_published_5, l0_.order_number AS order_number_6, l0_.created_at AS created_at_7, l0_.updated_at AS updated_at_8, l0_.category_id AS category_id_9 FROM lecture l0_ WHERE l0_.is_published = 1 AND l0_.id IN (19, 20, 21, 22, 23, 24) ORDER BY l0_.order_number ASC, l0_.created_at DESC;

#	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	Doctrine\ORM\Tools\Pagination\Paginator->getIterator (line 145)
7	iterator_to_array (line 45)
8	Knp\Component\Pager\Event\Subscriber\Paginate\Doctrine\ORM\QuerySubscriber::items (line 45)
9	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
10	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
11	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
12	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 126)
13	Knp\Component\Pager\Paginator->paginate (line 97)
14	Container0G5pq68\PaginatorProxyBa079e5->paginate (line 20)
15	App\Controller\LectureController->index (line 60)
16	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
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)

0.50 ms
(15.25%)

SELECT l0_.id AS id_0, l0_.title AS title_1, l0_.slug AS slug_2 FROM lecture l0_ WHERE l0_.is_published = ? ORDER BY l0_.order_number ASC, l0_.title ASC

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  l0_.id AS id_0,
  l0_.title AS title_1,
  l0_.slug AS slug_2
FROM
  lecture l0_
WHERE
  l0_.is_published = ?
ORDER BY
  l0_.order_number ASC,
  l0_.title ASC

SELECT l0_.id AS id_0, l0_.title AS title_1, l0_.slug AS slug_2 FROM lecture l0_ WHERE l0_.is_published = 1 ORDER BY l0_.order_number ASC, l0_.title 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\Repository\LectureRepository->findAllForDropdown (line 25)
7	App\Controller\LectureController->index (line 67)
8	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
9	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
10	Symfony\Component\HttpKernel\Kernel->handle (line 191)
11	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
12	require_once (line 32)
13	require_once (line 5)

0.34 ms
(10.33%)

SELECT DISTINCT l0_.id AS id_0, l0_.order_number AS order_number_1, l0_.created_at AS created_at_2 FROM lecture l0_ WHERE l0_.is_published = ? ORDER BY l0_.order_number ASC, l0_.created_at DESC LIMIT 6 OFFSET 18

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  DISTINCT l0_.id AS id_0,
  l0_.order_number AS order_number_1,
  l0_.created_at AS created_at_2
FROM
  lecture l0_
WHERE
  l0_.is_published = ?
ORDER BY
  l0_.order_number ASC,
  l0_.created_at DESC
LIMIT
  6
OFFSET
  18

SELECT DISTINCT l0_.id AS id_0, l0_.order_number AS order_number_1, l0_.created_at AS created_at_2 FROM lecture l0_ WHERE l0_.is_published = 1 ORDER BY l0_.order_number ASC, l0_.created_at DESC LIMIT 6 OFFSET 18;

#	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->getScalarResult (line 724)
6	Doctrine\ORM\Tools\Pagination\Paginator->getIterator (line 127)
7	iterator_to_array (line 45)
8	Knp\Component\Pager\Event\Subscriber\Paginate\Doctrine\ORM\QuerySubscriber::items (line 45)
9	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
10	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
11	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
12	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 126)
13	Knp\Component\Pager\Paginator->paginate (line 97)
14	Container0G5pq68\PaginatorProxyBa079e5->paginate (line 20)
15	App\Controller\LectureController->index (line 60)
16	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
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
App\Entity\Lecture	51
App\Entity\Category	2

Entities Mapping

Class	Mapping errors
App\Entity\Lecture	No errors.
App\Entity\Category	No errors.

Symfony Profiler

GET https://alexzps.ru/?page=4

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping