Symfony Profiler

Query Metrics

3 Database Queries

3 Different statements

1.20 ms Query time

0 Invalid entities

1 Managed entities

Queries

Group similar statements

#▲

Time

Info

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

[
  12898
]

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

#	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->forums (line 295)
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.37 ms

SELECT count(DISTINCT a0_.auditorium_id) AS sclr_0 FROM auditorium a0_ LEFT JOIN auditorium_forum a1_ ON a0_.auditorium_forum_id = a1_.forum_id WHERE a0_.auditorium_autor_id = ?

Parameters:

[
  12898
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  count(DISTINCT a0_.auditorium_id) AS sclr_0
FROM
  auditorium a0_
  LEFT JOIN auditorium_forum a1_ ON a0_.auditorium_forum_id = a1_.forum_id
WHERE
  a0_.auditorium_autor_id = ?

SELECT count(DISTINCT a0_.auditorium_id) AS sclr_0 FROM auditorium a0_ LEFT JOIN auditorium_forum a1_ ON a0_.auditorium_forum_id = a1_.forum_id WHERE a0_.auditorium_autor_id = 12898;

#	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->forums (line 305)
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 a0_.auditorium_id AS auditorium_id_0, a0_.auditorium_datum AS auditorium_datum_1 FROM auditorium a0_ LEFT JOIN auditorium_forum a1_ ON a0_.auditorium_forum_id = a1_.forum_id WHERE a0_.auditorium_autor_id = ? ORDER BY a0_.auditorium_datum DESC LIMIT 30

Parameters:

[
  12898
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  DISTINCT a0_.auditorium_id AS auditorium_id_0,
  a0_.auditorium_datum AS auditorium_datum_1
FROM
  auditorium a0_
  LEFT JOIN auditorium_forum a1_ ON a0_.auditorium_forum_id = a1_.forum_id
WHERE
  a0_.auditorium_autor_id = ?
ORDER BY
  a0_.auditorium_datum DESC
LIMIT
  30

SELECT DISTINCT a0_.auditorium_id AS auditorium_id_0, a0_.auditorium_datum AS auditorium_datum_1 FROM auditorium a0_ LEFT JOIN auditorium_forum a1_ ON a0_.auditorium_forum_id = a1_.forum_id WHERE a0_.auditorium_autor_id = 12898 ORDER BY a0_.auditorium_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->forums (line 305)
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	1

Entities Mapping

Class	Mapping errors
App\Entity\User\User	No errors.
App\Entity\Forum\ForumPost	No errors.
App\Entity\Forum\ForumThread	No errors.

Symfony Profiler

GET https://beta22.photopost.cz/autor/12898/fora

Configuration Settings

Theme

Page Width

Query Metrics

Queries

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping