Symfony Profiler

Query Metrics

4 Database Queries

4 Different statements

1.41 ms Query time

0 Invalid entities

29 Managed entities

Queries

Group similar statements

#▲

Time

Info

0.48 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:

[
  7331
]

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 = 7331;

#	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->photos (line 124)
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.39 ms

SELECT count(DISTINCT f0_.foto_id) AS sclr_0 FROM foto f0_ LEFT JOIN autor a1_ ON f0_.foto_autor = a1_.autor_id WHERE f0_.foto_kos = 0 AND f0_.foto_autor = ?

Parameters:

[
  7331
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  count(DISTINCT f0_.foto_id) AS sclr_0
FROM
  foto f0_
  LEFT JOIN autor a1_ ON f0_.foto_autor = a1_.autor_id
WHERE
  f0_.foto_kos = 0
  AND f0_.foto_autor = ?

SELECT count(DISTINCT f0_.foto_id) AS sclr_0 FROM foto f0_ LEFT JOIN autor a1_ ON f0_.foto_autor = a1_.autor_id WHERE f0_.foto_kos = 0 AND f0_.foto_autor = 7331;

#	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->photos (line 154)
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.28 ms

SELECT DISTINCT f0_.foto_id AS foto_id_0, f0_.foto_datum AS foto_datum_1, f0_.foto_id AS foto_id_2 FROM foto f0_ LEFT JOIN autor a1_ ON f0_.foto_autor = a1_.autor_id WHERE f0_.foto_kos = 0 AND f0_.foto_autor = ? ORDER BY f0_.foto_datum DESC, f0_.foto_id DESC LIMIT 30

Parameters:

[
  7331
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  DISTINCT f0_.foto_id AS foto_id_0,
  f0_.foto_datum AS foto_datum_1,
  f0_.foto_id AS foto_id_2
FROM
  foto f0_
  LEFT JOIN autor a1_ ON f0_.foto_autor = a1_.autor_id
WHERE
  f0_.foto_kos = 0
  AND f0_.foto_autor = ?
ORDER BY
  f0_.foto_datum DESC,
  f0_.foto_id DESC
LIMIT
  30

SELECT DISTINCT f0_.foto_id AS foto_id_0, f0_.foto_datum AS foto_datum_1, f0_.foto_id AS foto_id_2 FROM foto f0_ LEFT JOIN autor a1_ ON f0_.foto_autor = a1_.autor_id WHERE f0_.foto_kos = 0 AND f0_.foto_autor = 7331 ORDER BY f0_.foto_datum DESC, f0_.foto_id 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->photos (line 154)
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.27 ms

SELECT t0.kategorie_id AS kategorie_id_1, t0.kategorie_nazev AS kategorie_nazev_2, t0.url AS url_3, t0.title AS title_4, t0.metadescription AS metadescription_5, t0.h1 AS h1_6, t0.description AS description_7 FROM kategorie t0 ORDER BY t0.kategorie_nazev ASC

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.kategorie_id AS kategorie_id_1,
  t0.kategorie_nazev AS kategorie_nazev_2,
  t0.url AS url_3,
  t0.title AS title_4,
  t0.metadescription AS metadescription_5,
  t0.h1 AS h1_6,
  t0.description AS description_7
FROM
  kategorie t0
ORDER BY
  t0.kategorie_nazev ASC

SELECT t0.kategorie_id AS kategorie_id_1, t0.kategorie_nazev AS kategorie_nazev_2, t0.url AS url_3, t0.title AS title_4, t0.metadescription AS metadescription_5, t0.h1 AS h1_6, t0.description AS description_7 FROM kategorie t0 ORDER BY t0.kategorie_nazev ASC;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 963)
2	Doctrine\ORM\EntityRepository->findBy (line 110)
3	App\Controller\User\ProfileController->photos (line 162)
4	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
5	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
6	Symfony\Component\HttpKernel\Kernel->handle (line 182)
7	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
8	require_once (line 29)
9	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\Category	28
App\Entity\User\User	1

Entities Mapping

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

Symfony Profiler

GET https://beta22.photopost.cz/autor/7331/fotky

Configuration Settings

Theme

Page Width

Query Metrics

Queries

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping