Symfony Profiler

Query Metrics

3 Database Queries

3 Different statements

20.53 ms Query time

0 Invalid entities

30 Managed entities

Queries

Group similar statements

#▲

Time

Info

8.87 ms

SELECT count(DISTINCT a0_.autor_id) AS sclr_0 FROM autor a0_ WHERE a0_.autor_blok = 0

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  count(DISTINCT a0_.autor_id) AS sclr_0
FROM
  autor a0_
WHERE
  a0_.autor_blok = 0

SELECT count(DISTINCT a0_.autor_id) AS sclr_0 FROM autor a0_ WHERE a0_.autor_blok = 0;

#	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 122)
13	Knp\Component\Pager\Paginator->paginate (line 97)
14	ContainerYrspsD3\PaginatorProxyBa079e5->paginate (line 25)
15	App\Controller\User\UserListController->list (line 52)
16	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
17	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
18	Symfony\Component\HttpKernel\Kernel->handle (line 182)
19	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
20	require_once (line 29)
21	require_once (line 5)

10.96 ms

SELECT DISTINCT a0_.autor_id AS autor_id_0, a0_.autor_komentaru AS autor_komentaru_1 FROM autor a0_ WHERE a0_.autor_blok = 0 ORDER BY a0_.autor_komentaru DESC LIMIT 30 OFFSET 15870

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  DISTINCT a0_.autor_id AS autor_id_0,
  a0_.autor_komentaru AS autor_komentaru_1
FROM
  autor a0_
WHERE
  a0_.autor_blok = 0
ORDER BY
  a0_.autor_komentaru DESC
LIMIT
  30
OFFSET
  15870

SELECT DISTINCT a0_.autor_id AS autor_id_0, a0_.autor_komentaru AS autor_komentaru_1 FROM autor a0_ WHERE a0_.autor_blok = 0 ORDER BY a0_.autor_komentaru DESC LIMIT 30 OFFSET 15870;

#	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 122)
13	Knp\Component\Pager\Paginator->paginate (line 97)
14	ContainerYrspsD3\PaginatorProxyBa079e5->paginate (line 25)
15	App\Controller\User\UserListController->list (line 52)
16	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
17	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
18	Symfony\Component\HttpKernel\Kernel->handle (line 182)
19	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
20	require_once (line 29)
21	require_once (line 5)

0.71 ms

SELECT a0_.autor_id AS autor_id_0, a0_.autor_login AS autor_login_1, a0_.autor_pass AS autor_pass_2, a0_.autor_pass2 AS autor_pass2_3, a0_.autor_mail AS autor_mail_4, a0_.autor_jmeno AS autor_jmeno_5, a0_.autor_prijmeni AS autor_prijmeni_6, a0_.autor_blok AS autor_blok_7, a0_.autor_ikonka AS autor_ikonka_8, a0_.autor_body AS autor_body_9, a0_.autor_fotek AS autor_fotek_10, a0_.autor_komentaru AS autor_komentaru_11, a0_.autor_hodnoceni AS autor_hodnoceni_12, a0_.autor_predplatne AS autor_predplatne_13, a0_.autor_technika AS autor_technika_14, a0_.autor_poznamka AS autor_poznamka_15, a0_.autor_prodejni_info AS autor_prodejni_info_16, a0_.autor_ip AS autor_ip_17, a0_.autor_prihlaseni AS autor_prihlaseni_18, a0_.autor_last_upload AS autor_last_upload_19, a0_.autor_ftp AS autor_ftp_20, a0_.autor_mailpp AS autor_mailpp_21, a0_.autor_posta AS autor_posta_22, a0_.autor_postanew AS autor_postanew_23, a0_.lat AS lat_24, a0_.lon AS lon_25, a0_.heslo_token AS heslo_token_26, a0_.heslo_token_platnost AS heslo_token_platnost_27, a0_.novinky_zasilat AS novinky_zasilat_28, a0_.novinky_token AS novinky_token_29, a0_.autor_flag_bazar AS autor_flag_bazar_30, a0_.autor_flag_bmfoto AS autor_flag_bmfoto_31, a0_.autor_flag_odeslana_posta AS autor_flag_odeslana_posta_32, a0_.autor_flag_posta_back AS autor_flag_posta_back_33, a0_.autor_flag_posta_pocet AS autor_flag_posta_pocet_34, a0_.autor_flag_profil AS autor_flag_profil_35, a0_.autor_flag_clanky AS autor_flag_clanky_36, a0_.autor_flag_beztlach AS autor_flag_beztlach_37, a0_.autor_flag_foto_kom AS autor_flag_foto_kom_38, a0_.autor_flag_bmstart AS autor_flag_bmstart_39, a0_.autor_flag_default_bodovani AS autor_flag_default_bodovani_40, a0_.autor_role AS autor_role_41 FROM autor a0_ WHERE a0_.autor_blok = 0 AND a0_.autor_id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) ORDER BY a0_.autor_komentaru DESC

Parameters:

View formatted query View runnable query Explain query View query backtrace

SELECT
  a0_.autor_id AS autor_id_0,
  a0_.autor_login AS autor_login_1,
  a0_.autor_pass AS autor_pass_2,
  a0_.autor_pass2 AS autor_pass2_3,
  a0_.autor_mail AS autor_mail_4,
  a0_.autor_jmeno AS autor_jmeno_5,
  a0_.autor_prijmeni AS autor_prijmeni_6,
  a0_.autor_blok AS autor_blok_7,
  a0_.autor_ikonka AS autor_ikonka_8,
  a0_.autor_body AS autor_body_9,
  a0_.autor_fotek AS autor_fotek_10,
  a0_.autor_komentaru AS autor_komentaru_11,
  a0_.autor_hodnoceni AS autor_hodnoceni_12,
  a0_.autor_predplatne AS autor_predplatne_13,
  a0_.autor_technika AS autor_technika_14,
  a0_.autor_poznamka AS autor_poznamka_15,
  a0_.autor_prodejni_info AS autor_prodejni_info_16,
  a0_.autor_ip AS autor_ip_17,
  a0_.autor_prihlaseni AS autor_prihlaseni_18,
  a0_.autor_last_upload AS autor_last_upload_19,
  a0_.autor_ftp AS autor_ftp_20,
  a0_.autor_mailpp AS autor_mailpp_21,
  a0_.autor_posta AS autor_posta_22,
  a0_.autor_postanew AS autor_postanew_23,
  a0_.lat AS lat_24,
  a0_.lon AS lon_25,
  a0_.heslo_token AS heslo_token_26,
  a0_.heslo_token_platnost AS heslo_token_platnost_27,
  a0_.novinky_zasilat AS novinky_zasilat_28,
  a0_.novinky_token AS novinky_token_29,
  a0_.autor_flag_bazar AS autor_flag_bazar_30,
  a0_.autor_flag_bmfoto AS autor_flag_bmfoto_31,
  a0_.autor_flag_odeslana_posta AS autor_flag_odeslana_posta_32,
  a0_.autor_flag_posta_back AS autor_flag_posta_back_33,
  a0_.autor_flag_posta_pocet AS autor_flag_posta_pocet_34,
  a0_.autor_flag_profil AS autor_flag_profil_35,
  a0_.autor_flag_clanky AS autor_flag_clanky_36,
  a0_.autor_flag_beztlach AS autor_flag_beztlach_37,
  a0_.autor_flag_foto_kom AS autor_flag_foto_kom_38,
  a0_.autor_flag_bmstart AS autor_flag_bmstart_39,
  a0_.autor_flag_default_bodovani AS autor_flag_default_bodovani_40,
  a0_.autor_role AS autor_role_41
FROM
  autor a0_
WHERE
  a0_.autor_blok = 0
  AND a0_.autor_id IN (
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?
  )
ORDER BY
  a0_.autor_komentaru DESC

SELECT a0_.autor_id AS autor_id_0, a0_.autor_login AS autor_login_1, a0_.autor_pass AS autor_pass_2, a0_.autor_pass2 AS autor_pass2_3, a0_.autor_mail AS autor_mail_4, a0_.autor_jmeno AS autor_jmeno_5, a0_.autor_prijmeni AS autor_prijmeni_6, a0_.autor_blok AS autor_blok_7, a0_.autor_ikonka AS autor_ikonka_8, a0_.autor_body AS autor_body_9, a0_.autor_fotek AS autor_fotek_10, a0_.autor_komentaru AS autor_komentaru_11, a0_.autor_hodnoceni AS autor_hodnoceni_12, a0_.autor_predplatne AS autor_predplatne_13, a0_.autor_technika AS autor_technika_14, a0_.autor_poznamka AS autor_poznamka_15, a0_.autor_prodejni_info AS autor_prodejni_info_16, a0_.autor_ip AS autor_ip_17, a0_.autor_prihlaseni AS autor_prihlaseni_18, a0_.autor_last_upload AS autor_last_upload_19, a0_.autor_ftp AS autor_ftp_20, a0_.autor_mailpp AS autor_mailpp_21, a0_.autor_posta AS autor_posta_22, a0_.autor_postanew AS autor_postanew_23, a0_.lat AS lat_24, a0_.lon AS lon_25, a0_.heslo_token AS heslo_token_26, a0_.heslo_token_platnost AS heslo_token_platnost_27, a0_.novinky_zasilat AS novinky_zasilat_28, a0_.novinky_token AS novinky_token_29, a0_.autor_flag_bazar AS autor_flag_bazar_30, a0_.autor_flag_bmfoto AS autor_flag_bmfoto_31, a0_.autor_flag_odeslana_posta AS autor_flag_odeslana_posta_32, a0_.autor_flag_posta_back AS autor_flag_posta_back_33, a0_.autor_flag_posta_pocet AS autor_flag_posta_pocet_34, a0_.autor_flag_profil AS autor_flag_profil_35, a0_.autor_flag_clanky AS autor_flag_clanky_36, a0_.autor_flag_beztlach AS autor_flag_beztlach_37, a0_.autor_flag_foto_kom AS autor_flag_foto_kom_38, a0_.autor_flag_bmstart AS autor_flag_bmstart_39, a0_.autor_flag_default_bodovani AS autor_flag_default_bodovani_40, a0_.autor_role AS autor_role_41 FROM autor a0_ WHERE a0_.autor_blok = 0 AND a0_.autor_id IN (16679, 16680, 16682, 16683, 16691, 16692, 16694, 16695, 16697, 16699, 16703, 16704, 16705, 16708, 16709, 16710, 16714, 16715, 16716, 16717, 16719, 16722, 16723, 16725, 16727, 16731, 16733, 16735, 16736, 16737) ORDER BY a0_.autor_komentaru 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 122)
13	Knp\Component\Pager\Paginator->paginate (line 97)
14	ContainerYrspsD3\PaginatorProxyBa079e5->paginate (line 25)
15	App\Controller\User\UserListController->list (line 52)
16	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
17	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
18	Symfony\Component\HttpKernel\Kernel->handle (line 182)
19	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
20	require_once (line 29)
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\User\User	30

Entities Mapping

Class	Mapping errors
App\Entity\User\User	No errors.

Symfony Profiler

GET https://beta22.photopost.cz/autori?ord=3&strana=530

Configuration Settings

Theme

Page Width

Query Metrics

Queries

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping