Symfony Profiler

Query Metrics

4 Database Queries

4 Different statements

2.36 ms Query time

0 Invalid entities

7 Managed entities

Queries

Group similar statements

#▲

Time

Info

0.50 ms

SELECT t0.autor_id AS autor_id_1, t0.autor_login AS autor_login_2, t0.autor_pass AS autor_pass_3, t0.autor_pass2 AS autor_pass2_4, t0.autor_mail AS autor_mail_5, t0.autor_jmeno AS autor_jmeno_6, t0.autor_prijmeni AS autor_prijmeni_7, t0.autor_blok AS autor_blok_8, t0.autor_ikonka AS autor_ikonka_9, t0.autor_body AS autor_body_10, t0.autor_fotek AS autor_fotek_11, t0.autor_komentaru AS autor_komentaru_12, t0.autor_hodnoceni AS autor_hodnoceni_13, t0.autor_predplatne AS autor_predplatne_14, t0.autor_technika AS autor_technika_15, t0.autor_poznamka AS autor_poznamka_16, t0.autor_prodejni_info AS autor_prodejni_info_17, t0.autor_ip AS autor_ip_18, t0.autor_prihlaseni AS autor_prihlaseni_19, t0.autor_last_upload AS autor_last_upload_20, t0.autor_ftp AS autor_ftp_21, t0.autor_mailpp AS autor_mailpp_22, t0.autor_posta AS autor_posta_23, t0.autor_postanew AS autor_postanew_24, t0.lat AS lat_25, t0.lon AS lon_26, t0.heslo_token AS heslo_token_27, t0.heslo_token_platnost AS heslo_token_platnost_28, t0.novinky_zasilat AS novinky_zasilat_29, t0.novinky_token AS novinky_token_30, t0.autor_flag_bazar AS autor_flag_bazar_31, t0.autor_flag_bmfoto AS autor_flag_bmfoto_32, t0.autor_flag_odeslana_posta AS autor_flag_odeslana_posta_33, t0.autor_flag_posta_back AS autor_flag_posta_back_34, t0.autor_flag_posta_pocet AS autor_flag_posta_pocet_35, t0.autor_flag_profil AS autor_flag_profil_36, t0.autor_flag_clanky AS autor_flag_clanky_37, t0.autor_flag_beztlach AS autor_flag_beztlach_38, t0.autor_flag_foto_kom AS autor_flag_foto_kom_39, t0.autor_flag_bmstart AS autor_flag_bmstart_40, t0.autor_flag_default_bodovani AS autor_flag_default_bodovani_41, t0.autor_role AS autor_role_42 FROM autor t0 WHERE t0.autor_id = ?

Parameters:

[
  1707
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.autor_id AS autor_id_1,
  t0.autor_login AS autor_login_2,
  t0.autor_pass AS autor_pass_3,
  t0.autor_pass2 AS autor_pass2_4,
  t0.autor_mail AS autor_mail_5,
  t0.autor_jmeno AS autor_jmeno_6,
  t0.autor_prijmeni AS autor_prijmeni_7,
  t0.autor_blok AS autor_blok_8,
  t0.autor_ikonka AS autor_ikonka_9,
  t0.autor_body AS autor_body_10,
  t0.autor_fotek AS autor_fotek_11,
  t0.autor_komentaru AS autor_komentaru_12,
  t0.autor_hodnoceni AS autor_hodnoceni_13,
  t0.autor_predplatne AS autor_predplatne_14,
  t0.autor_technika AS autor_technika_15,
  t0.autor_poznamka AS autor_poznamka_16,
  t0.autor_prodejni_info AS autor_prodejni_info_17,
  t0.autor_ip AS autor_ip_18,
  t0.autor_prihlaseni AS autor_prihlaseni_19,
  t0.autor_last_upload AS autor_last_upload_20,
  t0.autor_ftp AS autor_ftp_21,
  t0.autor_mailpp AS autor_mailpp_22,
  t0.autor_posta AS autor_posta_23,
  t0.autor_postanew AS autor_postanew_24,
  t0.lat AS lat_25,
  t0.lon AS lon_26,
  t0.heslo_token AS heslo_token_27,
  t0.heslo_token_platnost AS heslo_token_platnost_28,
  t0.novinky_zasilat AS novinky_zasilat_29,
  t0.novinky_token AS novinky_token_30,
  t0.autor_flag_bazar AS autor_flag_bazar_31,
  t0.autor_flag_bmfoto AS autor_flag_bmfoto_32,
  t0.autor_flag_odeslana_posta AS autor_flag_odeslana_posta_33,
  t0.autor_flag_posta_back AS autor_flag_posta_back_34,
  t0.autor_flag_posta_pocet AS autor_flag_posta_pocet_35,
  t0.autor_flag_profil AS autor_flag_profil_36,
  t0.autor_flag_clanky AS autor_flag_clanky_37,
  t0.autor_flag_beztlach AS autor_flag_beztlach_38,
  t0.autor_flag_foto_kom AS autor_flag_foto_kom_39,
  t0.autor_flag_bmstart AS autor_flag_bmstart_40,
  t0.autor_flag_default_bodovani AS autor_flag_default_bodovani_41,
  t0.autor_role AS autor_role_42
FROM
  autor t0
WHERE
  t0.autor_id = ?

SELECT t0.autor_id AS autor_id_1, t0.autor_login AS autor_login_2, t0.autor_pass AS autor_pass_3, t0.autor_pass2 AS autor_pass2_4, t0.autor_mail AS autor_mail_5, t0.autor_jmeno AS autor_jmeno_6, t0.autor_prijmeni AS autor_prijmeni_7, t0.autor_blok AS autor_blok_8, t0.autor_ikonka AS autor_ikonka_9, t0.autor_body AS autor_body_10, t0.autor_fotek AS autor_fotek_11, t0.autor_komentaru AS autor_komentaru_12, t0.autor_hodnoceni AS autor_hodnoceni_13, t0.autor_predplatne AS autor_predplatne_14, t0.autor_technika AS autor_technika_15, t0.autor_poznamka AS autor_poznamka_16, t0.autor_prodejni_info AS autor_prodejni_info_17, t0.autor_ip AS autor_ip_18, t0.autor_prihlaseni AS autor_prihlaseni_19, t0.autor_last_upload AS autor_last_upload_20, t0.autor_ftp AS autor_ftp_21, t0.autor_mailpp AS autor_mailpp_22, t0.autor_posta AS autor_posta_23, t0.autor_postanew AS autor_postanew_24, t0.lat AS lat_25, t0.lon AS lon_26, t0.heslo_token AS heslo_token_27, t0.heslo_token_platnost AS heslo_token_platnost_28, t0.novinky_zasilat AS novinky_zasilat_29, t0.novinky_token AS novinky_token_30, t0.autor_flag_bazar AS autor_flag_bazar_31, t0.autor_flag_bmfoto AS autor_flag_bmfoto_32, t0.autor_flag_odeslana_posta AS autor_flag_odeslana_posta_33, t0.autor_flag_posta_back AS autor_flag_posta_back_34, t0.autor_flag_posta_pocet AS autor_flag_posta_pocet_35, t0.autor_flag_profil AS autor_flag_profil_36, t0.autor_flag_clanky AS autor_flag_clanky_37, t0.autor_flag_beztlach AS autor_flag_beztlach_38, t0.autor_flag_foto_kom AS autor_flag_foto_kom_39, t0.autor_flag_bmstart AS autor_flag_bmstart_40, t0.autor_flag_default_bodovani AS autor_flag_default_bodovani_41, t0.autor_role AS autor_role_42 FROM autor t0 WHERE t0.autor_id = 1707;

#	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	App\Controller\User\ProfileController->findUserOrFail (line 435)
7	App\Controller\User\ProfileController->comments (line 190)
8	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
9	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
10	Symfony\Component\HttpKernel\Kernel->handle (line 182)
11	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
12	require_once (line 29)
13	require_once (line 5)

0.83 ms

SELECT count(DISTINCT h0_.hodnoceni_id) AS sclr_0 FROM hodnoceni h0_ LEFT JOIN foto f1_ ON h0_.hodnoceni_foto_id = f1_.foto_id WHERE h0_.hodnoceni_autor = ? AND f1_.foto_kos = 0

Parameters:

[
  1707
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  count(DISTINCT h0_.hodnoceni_id) AS sclr_0
FROM
  hodnoceni h0_
  LEFT JOIN foto f1_ ON h0_.hodnoceni_foto_id = f1_.foto_id
WHERE
  h0_.hodnoceni_autor = ?
  AND f1_.foto_kos = 0

SELECT count(DISTINCT h0_.hodnoceni_id) AS sclr_0 FROM hodnoceni h0_ LEFT JOIN foto f1_ ON h0_.hodnoceni_foto_id = f1_.foto_id WHERE h0_.hodnoceni_autor = 1707 AND f1_.foto_kos = 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\ProfileController->comments (line 201)
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.45 ms

SELECT DISTINCT h0_.hodnoceni_id AS hodnoceni_id_0, h0_.hodnoceni_datum AS hodnoceni_datum_1 FROM hodnoceni h0_ LEFT JOIN foto f1_ ON h0_.hodnoceni_foto_id = f1_.foto_id WHERE h0_.hodnoceni_autor = ? AND f1_.foto_kos = 0 ORDER BY h0_.hodnoceni_datum DESC LIMIT 30

Parameters:

[
  1707
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  DISTINCT h0_.hodnoceni_id AS hodnoceni_id_0,
  h0_.hodnoceni_datum AS hodnoceni_datum_1
FROM
  hodnoceni h0_
  LEFT JOIN foto f1_ ON h0_.hodnoceni_foto_id = f1_.foto_id
WHERE
  h0_.hodnoceni_autor = ?
  AND f1_.foto_kos = 0
ORDER BY
  h0_.hodnoceni_datum DESC
LIMIT
  30

SELECT DISTINCT h0_.hodnoceni_id AS hodnoceni_id_0, h0_.hodnoceni_datum AS hodnoceni_datum_1 FROM hodnoceni h0_ LEFT JOIN foto f1_ ON h0_.hodnoceni_foto_id = f1_.foto_id WHERE h0_.hodnoceni_autor = 1707 AND f1_.foto_kos = 0 ORDER BY h0_.hodnoceni_datum DESC LIMIT 30;

#	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\ProfileController->comments (line 201)
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.59 ms

SELECT h0_.hodnoceni_id AS hodnoceni_id_0, h0_.hodnoceni_autor AS hodnoceni_autor_1, h0_.hodnoceni_foto_id AS hodnoceni_foto_id_2, h0_.hodnoceni_foto_autor AS hodnoceni_foto_autor_3, h0_.hodnoceni_body AS hodnoceni_body_4, h0_.hodnoceni_text AS hodnoceni_text_5, h0_.hodnoceni_datum AS hodnoceni_datum_6, h0_.foto_soubor AS foto_soubor_7, f1_.foto_id AS foto_id_8, f1_.foto_soubor AS foto_soubor_9, f1_.foto_autor AS foto_autor_10, f1_.foto_titulek AS foto_titulek_11, f1_.foto_datum AS foto_datum_12, f1_.foto_body AS foto_body_13, f1_.foto_hodnoceni AS foto_hodnoceni_14, f1_.foto_komentaru AS foto_komentaru_15, f1_.foto_pocitadlo AS foto_pocitadlo_16, f1_.foto_kos AS foto_kos_17, f1_.foto_bd_px AS foto_bd_px_18, f1_.foto_bd_col AS foto_bd_col_19, f1_.foto_bg_col AS foto_bg_col_20, f1_.foto_width AS foto_width_21, f1_.foto_height AS foto_height_22, f1_.mazat AS mazat_23, f1_.tagy AS tagy_24, f1_.popis AS popis_25, f1_.foto_technika AS foto_technika_26, f1_.foto_poznamka AS foto_poznamka_27, f1_.foto_prodej AS foto_prodej_28, h0_.hodnoceni_autor AS hodnoceni_autor_29, h0_.hodnoceni_foto_id AS hodnoceni_foto_id_30, h0_.hodnoceni_foto_autor AS hodnoceni_foto_autor_31, f1_.foto_autor AS foto_autor_32 FROM hodnoceni h0_ LEFT JOIN foto f1_ ON h0_.hodnoceni_foto_id = f1_.foto_id WHERE h0_.hodnoceni_autor = ? AND f1_.foto_kos = 0 AND h0_.hodnoceni_id IN (?, ?, ?) ORDER BY h0_.hodnoceni_datum DESC

Parameters:

View formatted query View runnable query Explain query View query backtrace

SELECT
  h0_.hodnoceni_id AS hodnoceni_id_0,
  h0_.hodnoceni_autor AS hodnoceni_autor_1,
  h0_.hodnoceni_foto_id AS hodnoceni_foto_id_2,
  h0_.hodnoceni_foto_autor AS hodnoceni_foto_autor_3,
  h0_.hodnoceni_body AS hodnoceni_body_4,
  h0_.hodnoceni_text AS hodnoceni_text_5,
  h0_.hodnoceni_datum AS hodnoceni_datum_6,
  h0_.foto_soubor AS foto_soubor_7,
  f1_.foto_id AS foto_id_8,
  f1_.foto_soubor AS foto_soubor_9,
  f1_.foto_autor AS foto_autor_10,
  f1_.foto_titulek AS foto_titulek_11,
  f1_.foto_datum AS foto_datum_12,
  f1_.foto_body AS foto_body_13,
  f1_.foto_hodnoceni AS foto_hodnoceni_14,
  f1_.foto_komentaru AS foto_komentaru_15,
  f1_.foto_pocitadlo AS foto_pocitadlo_16,
  f1_.foto_kos AS foto_kos_17,
  f1_.foto_bd_px AS foto_bd_px_18,
  f1_.foto_bd_col AS foto_bd_col_19,
  f1_.foto_bg_col AS foto_bg_col_20,
  f1_.foto_width AS foto_width_21,
  f1_.foto_height AS foto_height_22,
  f1_.mazat AS mazat_23,
  f1_.tagy AS tagy_24,
  f1_.popis AS popis_25,
  f1_.foto_technika AS foto_technika_26,
  f1_.foto_poznamka AS foto_poznamka_27,
  f1_.foto_prodej AS foto_prodej_28,
  h0_.hodnoceni_autor AS hodnoceni_autor_29,
  h0_.hodnoceni_foto_id AS hodnoceni_foto_id_30,
  h0_.hodnoceni_foto_autor AS hodnoceni_foto_autor_31,
  f1_.foto_autor AS foto_autor_32
FROM
  hodnoceni h0_
  LEFT JOIN foto f1_ ON h0_.hodnoceni_foto_id = f1_.foto_id
WHERE
  h0_.hodnoceni_autor = ?
  AND f1_.foto_kos = 0
  AND h0_.hodnoceni_id IN (?, ?, ?)
ORDER BY
  h0_.hodnoceni_datum DESC

SELECT h0_.hodnoceni_id AS hodnoceni_id_0, h0_.hodnoceni_autor AS hodnoceni_autor_1, h0_.hodnoceni_foto_id AS hodnoceni_foto_id_2, h0_.hodnoceni_foto_autor AS hodnoceni_foto_autor_3, h0_.hodnoceni_body AS hodnoceni_body_4, h0_.hodnoceni_text AS hodnoceni_text_5, h0_.hodnoceni_datum AS hodnoceni_datum_6, h0_.foto_soubor AS foto_soubor_7, f1_.foto_id AS foto_id_8, f1_.foto_soubor AS foto_soubor_9, f1_.foto_autor AS foto_autor_10, f1_.foto_titulek AS foto_titulek_11, f1_.foto_datum AS foto_datum_12, f1_.foto_body AS foto_body_13, f1_.foto_hodnoceni AS foto_hodnoceni_14, f1_.foto_komentaru AS foto_komentaru_15, f1_.foto_pocitadlo AS foto_pocitadlo_16, f1_.foto_kos AS foto_kos_17, f1_.foto_bd_px AS foto_bd_px_18, f1_.foto_bd_col AS foto_bd_col_19, f1_.foto_bg_col AS foto_bg_col_20, f1_.foto_width AS foto_width_21, f1_.foto_height AS foto_height_22, f1_.mazat AS mazat_23, f1_.tagy AS tagy_24, f1_.popis AS popis_25, f1_.foto_technika AS foto_technika_26, f1_.foto_poznamka AS foto_poznamka_27, f1_.foto_prodej AS foto_prodej_28, h0_.hodnoceni_autor AS hodnoceni_autor_29, h0_.hodnoceni_foto_id AS hodnoceni_foto_id_30, h0_.hodnoceni_foto_autor AS hodnoceni_foto_autor_31, f1_.foto_autor AS foto_autor_32 FROM hodnoceni h0_ LEFT JOIN foto f1_ ON h0_.hodnoceni_foto_id = f1_.foto_id WHERE h0_.hodnoceni_autor = 1707 AND f1_.foto_kos = 0 AND h0_.hodnoceni_id IN (126554, 125107, 124631) ORDER BY h0_.hodnoceni_datum 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\ProfileController->comments (line 201)
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\Photo\Rating	3
App\Entity\Photo\Photo	3
App\Entity\User\User	1

Entities Mapping

Class	Mapping errors
App\Entity\User\User	No errors.
App\Entity\Photo\Rating	No errors.
App\Entity\Photo\Photo	No errors.
App\Entity\Photo\Category	No errors.

Symfony Profiler

GET https://beta22.photopost.cz/autor/1707/komentare

Configuration Settings

Theme

Page Width

Query Metrics

Queries

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping