Symfony Profiler

Query Metrics

46 Database Queries

11 Different statements

11.37 ms Query time

0 Invalid entities

68 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

3.16 ms
(27.81%)

SELECT t0.id AS id_1, t0.file AS file_2, t0.updated_at AS updated_at_3 FROM uploaded t0 WHERE t0.id = ?

Parameters:

[
  1403
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.file AS file_2,
  t0.updated_at AS updated_at_3
FROM
  uploaded t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.file AS file_2, t0.updated_at AS updated_at_3 FROM uploaded t0 WHERE t0.id = 1403;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 740)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 758)
3	Doctrine\ORM\Proxy\ProxyFactory->Doctrine\ORM\Proxy\{closure} (line 289)
4	Proxies\__CG__\App\Entity\Uploaded::Doctrine\ORM\Proxy\{closure} (line 367)
5	Symfony\Component\VarExporter\Internal\LazyObjectState::initialize (line 59)
6	Proxies\__CG__\App\Entity\Uploaded->__get (line 129)
7	App\Entity\Uploaded->getFile (line 51)
8	Twig\Extension\CoreExtension->getAttribute (line 1909)
9	__TwigTemplate_c0f0381b3af1dad70dfb65a0d69364f3::block_addstylesheets (line 188)
10	Twig\Template->yieldBlock (line 446)
11	__TwigTemplate_53369f3157bed95ec28f8e4b2db8582b->doDisplay (line 73)
12	Twig\Template->yield (line 402)
13	__TwigTemplate_c0f0381b3af1dad70dfb65a0d69364f3->doDisplay (line 55)
14	Twig\Template->yield (line 402)
15	Twig\Template->display (line 358)
16	Twig\Template->render (line 373)
17	Twig\TemplateWrapper->render (line 51)
18	Twig\Environment->render (line 333)
19	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 431)
20	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 436)
21	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 250)
22	App\Controller\EventsController->detailclanek (line 128)
23	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
24	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
25	Symfony\Component\HttpKernel\Kernel->handle (line 182)
26	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
27	require_once (line 29)
28	require_once (line 5)

2.67 ms
(23.52%)

SELECT t0.id AS id_1, t0.perex AS perex_2, t0.content AS content_3, t0.youtube_video AS youtube_video_4, t0.vimeo_video AS vimeo_video_5, t0.embed_code AS embed_code_6 FROM event_content t0 INNER JOIN events_event_content ON t0.id = events_event_content.event_content_id WHERE events_event_content.events_id = ?

Parameters:

[
  127
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.perex AS perex_2,
  t0.content AS content_3,
  t0.youtube_video AS youtube_video_4,
  t0.vimeo_video AS vimeo_video_5,
  t0.embed_code AS embed_code_6
FROM
  event_content t0
  INNER JOIN events_event_content ON t0.id = events_event_content.event_content_id
WHERE
  events_event_content.events_id = ?

SELECT t0.id AS id_1, t0.perex AS perex_2, t0.content AS content_3, t0.youtube_video AS youtube_video_4, t0.vimeo_video AS vimeo_video_5, t0.embed_code AS embed_code_6 FROM event_content t0 INNER JOIN events_event_content ON t0.id = events_event_content.event_content_id WHERE events_event_content.events_id = 127;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getManyToManyStatement (line 1085)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadManyToManyCollection (line 1014)
3	Doctrine\ORM\UnitOfWork->loadCollection (line 2726)
4	Doctrine\ORM\PersistentCollection->doInitialize (line 636)
5	Doctrine\ORM\PersistentCollection->initialize (line 186)
6	Doctrine\Common\Collections\AbstractLazyCollection->count (line 39)
7	Doctrine\ORM\PersistentCollection->count (line 391)
8	__TwigTemplate_c0f0381b3af1dad70dfb65a0d69364f3->block_addstylesheets (line 120)
9	Twig\Template->yieldBlock (line 446)
10	__TwigTemplate_53369f3157bed95ec28f8e4b2db8582b->doDisplay (line 73)
11	Twig\Template->yield (line 402)
12	__TwigTemplate_c0f0381b3af1dad70dfb65a0d69364f3->doDisplay (line 55)
13	Twig\Template->yield (line 402)
14	Twig\Template->display (line 358)
15	Twig\Template->render (line 373)
16	Twig\TemplateWrapper->render (line 51)
17	Twig\Environment->render (line 333)
18	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 431)
19	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 436)
20	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 250)
21	App\Controller\EventsController->detailclanek (line 128)
22	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
23	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
24	Symfony\Component\HttpKernel\Kernel->handle (line 182)
25	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
26	require_once (line 29)
27	require_once (line 5)

2.44 ms
(21.50%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.approved AS approved_3, t0.fonticon AS fonticon_4, t0.approved_by_id AS approved_by_id_5, t0.hero_article_id AS hero_article_id_6 FROM event_tags t0 INNER JOIN events_event_tags ON t0.id = events_event_tags.event_tags_id WHERE events_event_tags.events_id = ?

Parameters:

[
  127
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.approved AS approved_3,
  t0.fonticon AS fonticon_4,
  t0.approved_by_id AS approved_by_id_5,
  t0.hero_article_id AS hero_article_id_6
FROM
  event_tags t0
  INNER JOIN events_event_tags ON t0.id = events_event_tags.event_tags_id
WHERE
  events_event_tags.events_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.approved AS approved_3, t0.fonticon AS fonticon_4, t0.approved_by_id AS approved_by_id_5, t0.hero_article_id AS hero_article_id_6 FROM event_tags t0 INNER JOIN events_event_tags ON t0.id = events_event_tags.event_tags_id WHERE events_event_tags.events_id = 127;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getManyToManyStatement (line 1085)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadManyToManyCollection (line 1014)
3	Doctrine\ORM\UnitOfWork->loadCollection (line 2726)
4	Doctrine\ORM\PersistentCollection->doInitialize (line 636)
5	Doctrine\ORM\PersistentCollection->initialize (line 186)
6	Doctrine\Common\Collections\AbstractLazyCollection->getIterator (line 313)
7	__TwigTemplate_c0f0381b3af1dad70dfb65a0d69364f3->block_body (line 766)
8	Twig\Template->yieldBlock (line 446)
9	__TwigTemplate_53369f3157bed95ec28f8e4b2db8582b->doDisplay (line 106)
10	Twig\Template->yield (line 402)
11	__TwigTemplate_c0f0381b3af1dad70dfb65a0d69364f3->doDisplay (line 55)
12	Twig\Template->yield (line 402)
13	Twig\Template->display (line 358)
14	Twig\Template->render (line 373)
15	Twig\TemplateWrapper->render (line 51)
16	Twig\Environment->render (line 333)
17	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 431)
18	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 436)
19	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 250)
20	App\Controller\EventsController->detailclanek (line 128)
21	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
22	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
23	Symfony\Component\HttpKernel\Kernel->handle (line 182)
24	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
25	require_once (line 29)
26	require_once (line 5)

0.62 ms
(5.46%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.date_from AS date_from_3, t0.date_to AS date_to_4, t0.email AS email_5, t0.created_at AS created_at_6, t0.udated_at AS udated_at_7, t0.supervised AS supervised_8, t0.approved AS approved_9, t0.slug AS slug_10, t0.supervisor_md_sum AS supervisor_md_sum_11, t0.changes_md_sum AS changes_md_sum_12, t0.owner_id AS owner_id_13, t0.approver_id AS approver_id_14, t0.company_id AS company_id_15, t0.updated_by_id AS updated_by_id_16, t0.type_id AS type_id_17, t0.main_image_id AS main_image_id_18 FROM events t0 WHERE t0.slug = ? LIMIT 1

Parameters:

[
  "Vernisaz-Pod-vasimi-kridly-v-Ceskych-Budejovicich-127"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.date_from AS date_from_3,
  t0.date_to AS date_to_4,
  t0.email AS email_5,
  t0.created_at AS created_at_6,
  t0.udated_at AS udated_at_7,
  t0.supervised AS supervised_8,
  t0.approved AS approved_9,
  t0.slug AS slug_10,
  t0.supervisor_md_sum AS supervisor_md_sum_11,
  t0.changes_md_sum AS changes_md_sum_12,
  t0.owner_id AS owner_id_13,
  t0.approver_id AS approver_id_14,
  t0.company_id AS company_id_15,
  t0.updated_by_id AS updated_by_id_16,
  t0.type_id AS type_id_17,
  t0.main_image_id AS main_image_id_18
FROM
  events t0
WHERE
  t0.slug = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.date_from AS date_from_3, t0.date_to AS date_to_4, t0.email AS email_5, t0.created_at AS created_at_6, t0.udated_at AS udated_at_7, t0.supervised AS supervised_8, t0.approved AS approved_9, t0.slug AS slug_10, t0.supervisor_md_sum AS supervisor_md_sum_11, t0.changes_md_sum AS changes_md_sum_12, t0.owner_id AS owner_id_13, t0.approver_id AS approver_id_14, t0.company_id AS company_id_15, t0.updated_by_id AS updated_by_id_16, t0.type_id AS type_id_17, t0.main_image_id AS main_image_id_18 FROM events t0 WHERE t0.slug = 'Vernisaz-Pod-vasimi-kridly-v-Ceskych-Budejovicich-127' LIMIT 1;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 740)
2	Doctrine\ORM\EntityRepository->findOneBy (line 125)
3	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findOneBy (line 81)
4	App\Controller\EventsController->detailclanek (line 125)
5	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
6	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
7	Symfony\Component\HttpKernel\Kernel->handle (line 182)
8	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
9	require_once (line 29)
10	require_once (line 5)

0.62 ms
(5.45%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.date_from AS date_from_3, t0.date_to AS date_to_4, t0.email AS email_5, t0.created_at AS created_at_6, t0.udated_at AS udated_at_7, t0.supervised AS supervised_8, t0.approved AS approved_9, t0.slug AS slug_10, t0.supervisor_md_sum AS supervisor_md_sum_11, t0.changes_md_sum AS changes_md_sum_12, t0.owner_id AS owner_id_13, t0.approver_id AS approver_id_14, t0.company_id AS company_id_15, t0.updated_by_id AS updated_by_id_16, t0.type_id AS type_id_17, t0.main_image_id AS main_image_id_18 FROM events t0 WHERE t0.approved = ? AND t0.type_id = ? ORDER BY t0.date_from DESC LIMIT 10

Parameters:

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.date_from AS date_from_3,
  t0.date_to AS date_to_4,
  t0.email AS email_5,
  t0.created_at AS created_at_6,
  t0.udated_at AS udated_at_7,
  t0.supervised AS supervised_8,
  t0.approved AS approved_9,
  t0.slug AS slug_10,
  t0.supervisor_md_sum AS supervisor_md_sum_11,
  t0.changes_md_sum AS changes_md_sum_12,
  t0.owner_id AS owner_id_13,
  t0.approver_id AS approver_id_14,
  t0.company_id AS company_id_15,
  t0.updated_by_id AS updated_by_id_16,
  t0.type_id AS type_id_17,
  t0.main_image_id AS main_image_id_18
FROM
  events t0
WHERE
  t0.approved = ?
  AND t0.type_id = ?
ORDER BY
  t0.date_from DESC
LIMIT
  10

SELECT t0.id AS id_1, t0.name AS name_2, t0.date_from AS date_from_3, t0.date_to AS date_to_4, t0.email AS email_5, t0.created_at AS created_at_6, t0.udated_at AS udated_at_7, t0.supervised AS supervised_8, t0.approved AS approved_9, t0.slug AS slug_10, t0.supervisor_md_sum AS supervisor_md_sum_11, t0.changes_md_sum AS changes_md_sum_12, t0.owner_id AS owner_id_13, t0.approver_id AS approver_id_14, t0.company_id AS company_id_15, t0.updated_by_id AS updated_by_id_16, t0.type_id AS type_id_17, t0.main_image_id AS main_image_id_18 FROM events t0 WHERE t0.approved = 1 AND t0.type_id = 2 ORDER BY t0.date_from DESC LIMIT 10;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 942)
2	Doctrine\ORM\EntityRepository->findBy (line 110)
3	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findBy (line 73)
4	App\Controller\EventsController->detailclanek (line 126)
5	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
6	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
7	Symfony\Component\HttpKernel\Kernel->handle (line 182)
8	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
9	require_once (line 29)
10	require_once (line 5)

0.42 ms
(3.73%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.approved AS approved_3, t0.fonticon AS fonticon_4, t0.poradi AS poradi_5, t0.approved_by_id AS approved_by_id_6, t0.hero_article_id AS hero_article_id_7, t0.type_id AS type_id_8 FROM event_catagories t0 INNER JOIN events_event_catagories ON t0.id = events_event_catagories.event_catagories_id WHERE events_event_catagories.events_id = ?

Parameters:

[
  127
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.approved AS approved_3,
  t0.fonticon AS fonticon_4,
  t0.poradi AS poradi_5,
  t0.approved_by_id AS approved_by_id_6,
  t0.hero_article_id AS hero_article_id_7,
  t0.type_id AS type_id_8
FROM
  event_catagories t0
  INNER JOIN events_event_catagories ON t0.id = events_event_catagories.event_catagories_id
WHERE
  events_event_catagories.events_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.approved AS approved_3, t0.fonticon AS fonticon_4, t0.poradi AS poradi_5, t0.approved_by_id AS approved_by_id_6, t0.hero_article_id AS hero_article_id_7, t0.type_id AS type_id_8 FROM event_catagories t0 INNER JOIN events_event_catagories ON t0.id = events_event_catagories.event_catagories_id WHERE events_event_catagories.events_id = 127;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getManyToManyStatement (line 1085)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadManyToManyCollection (line 1014)
3	Doctrine\ORM\UnitOfWork->loadCollection (line 2726)
4	Doctrine\ORM\PersistentCollection->doInitialize (line 636)
5	Doctrine\ORM\PersistentCollection->initialize (line 186)
6	Doctrine\Common\Collections\AbstractLazyCollection->count (line 39)
7	Doctrine\ORM\PersistentCollection->count (line 391)
8	__TwigTemplate_c0f0381b3af1dad70dfb65a0d69364f3->block_body (line 277)
9	Twig\Template->yieldBlock (line 446)
10	__TwigTemplate_53369f3157bed95ec28f8e4b2db8582b->doDisplay (line 106)
11	Twig\Template->yield (line 402)
12	__TwigTemplate_c0f0381b3af1dad70dfb65a0d69364f3->doDisplay (line 55)
13	Twig\Template->yield (line 402)
14	Twig\Template->display (line 358)
15	Twig\Template->render (line 373)
16	Twig\TemplateWrapper->render (line 51)
17	Twig\Environment->render (line 333)
18	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 431)
19	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 436)
20	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 250)
21	App\Controller\EventsController->detailclanek (line 128)
22	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
23	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
24	Symfony\Component\HttpKernel\Kernel->handle (line 182)
25	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
26	require_once (line 29)
27	require_once (line 5)

0.32 ms
(2.82%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.updated_at AS updated_at_3, t0.headquarter AS headquarter_4, t0.ico AS ico_5, t0.dic AS dic_6, t0.bank_no AS bank_no_7, t0.correspondece AS correspondece_8, t0.approved AS approved_9, t0.latitude AS latitude_10, t0.longitude AS longitude_11, t0.nationwide AS nationwide_12, t0.slug AS slug_13, t0.changes_md_sum AS changes_md_sum_14, t0.approved_by_id AS approved_by_id_15, t0.owner_id AS owner_id_16, t0.logo_id AS logo_id_17 FROM company t0 WHERE t0.id = ?

Parameters:

[
  90
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.updated_at AS updated_at_3,
  t0.headquarter AS headquarter_4,
  t0.ico AS ico_5,
  t0.dic AS dic_6,
  t0.bank_no AS bank_no_7,
  t0.correspondece AS correspondece_8,
  t0.approved AS approved_9,
  t0.latitude AS latitude_10,
  t0.longitude AS longitude_11,
  t0.nationwide AS nationwide_12,
  t0.slug AS slug_13,
  t0.changes_md_sum AS changes_md_sum_14,
  t0.approved_by_id AS approved_by_id_15,
  t0.owner_id AS owner_id_16,
  t0.logo_id AS logo_id_17
FROM
  company t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.updated_at AS updated_at_3, t0.headquarter AS headquarter_4, t0.ico AS ico_5, t0.dic AS dic_6, t0.bank_no AS bank_no_7, t0.correspondece AS correspondece_8, t0.approved AS approved_9, t0.latitude AS latitude_10, t0.longitude AS longitude_11, t0.nationwide AS nationwide_12, t0.slug AS slug_13, t0.changes_md_sum AS changes_md_sum_14, t0.approved_by_id AS approved_by_id_15, t0.owner_id AS owner_id_16, t0.logo_id AS logo_id_17 FROM company t0 WHERE t0.id = 90;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 740)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 758)
3	Doctrine\ORM\Proxy\ProxyFactory->Doctrine\ORM\Proxy\{closure} (line 289)
4	Proxies\__CG__\App\Entity\Company::Doctrine\ORM\Proxy\{closure} (line 367)
5	Symfony\Component\VarExporter\Internal\LazyObjectState::initialize (line 59)
6	Proxies\__CG__\App\Entity\Company->__get (line 129)
7	App\Entity\Company->getLogo (line 376)
8	Twig\Extension\CoreExtension->getAttribute (line 1909)
9	__TwigTemplate_c0f0381b3af1dad70dfb65a0d69364f3::block_body (line 435)
10	Twig\Template->yieldBlock (line 446)
11	__TwigTemplate_53369f3157bed95ec28f8e4b2db8582b->doDisplay (line 106)
12	Twig\Template->yield (line 402)
13	__TwigTemplate_c0f0381b3af1dad70dfb65a0d69364f3->doDisplay (line 55)
14	Twig\Template->yield (line 402)
15	Twig\Template->display (line 358)
16	Twig\Template->render (line 373)
17	Twig\TemplateWrapper->render (line 51)
18	Twig\Environment->render (line 333)
19	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 431)
20	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 436)
21	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 250)
22	App\Controller\EventsController->detailclanek (line 128)
23	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
24	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
25	Symfony\Component\HttpKernel\Kernel->handle (line 182)
26	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
27	require_once (line 29)
28	require_once (line 5)

0.32 ms
(2.81%)

SELECT t0.id AS id_1, t0.email AS email_2, t0.phone AS phone_3, t0.street AS street_4, t0.city AS city_5, t0.zip AS zip_6, t0.latitude AS latitude_7, t0.longitude AS longitude_8, t0.website AS website_9, t0.facebook AS facebook_10, t0.instagram AS instagram_11, t0.twitter AS twitter_12, t0.linkedin AS linkedin_13, t0.youtube AS youtube_14, t0.vimeo AS vimeo_15, t0.branch_name AS branch_name_16, t0.company_id AS company_id_17 FROM contacts t0 INNER JOIN events_contacts ON t0.id = events_contacts.contacts_id WHERE events_contacts.events_id = ?

Parameters:

[
  127
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.email AS email_2,
  t0.phone AS phone_3,
  t0.street AS street_4,
  t0.city AS city_5,
  t0.zip AS zip_6,
  t0.latitude AS latitude_7,
  t0.longitude AS longitude_8,
  t0.website AS website_9,
  t0.facebook AS facebook_10,
  t0.instagram AS instagram_11,
  t0.twitter AS twitter_12,
  t0.linkedin AS linkedin_13,
  t0.youtube AS youtube_14,
  t0.vimeo AS vimeo_15,
  t0.branch_name AS branch_name_16,
  t0.company_id AS company_id_17
FROM
  contacts t0
  INNER JOIN events_contacts ON t0.id = events_contacts.contacts_id
WHERE
  events_contacts.events_id = ?

SELECT t0.id AS id_1, t0.email AS email_2, t0.phone AS phone_3, t0.street AS street_4, t0.city AS city_5, t0.zip AS zip_6, t0.latitude AS latitude_7, t0.longitude AS longitude_8, t0.website AS website_9, t0.facebook AS facebook_10, t0.instagram AS instagram_11, t0.twitter AS twitter_12, t0.linkedin AS linkedin_13, t0.youtube AS youtube_14, t0.vimeo AS vimeo_15, t0.branch_name AS branch_name_16, t0.company_id AS company_id_17 FROM contacts t0 INNER JOIN events_contacts ON t0.id = events_contacts.contacts_id WHERE events_contacts.events_id = 127;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getManyToManyStatement (line 1085)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadManyToManyCollection (line 1014)
3	Doctrine\ORM\UnitOfWork->loadCollection (line 2726)
4	Doctrine\ORM\PersistentCollection->doInitialize (line 636)
5	Doctrine\ORM\PersistentCollection->initialize (line 186)
6	Doctrine\Common\Collections\AbstractLazyCollection->count (line 39)
7	Doctrine\ORM\PersistentCollection->count (line 391)
8	__TwigTemplate_c0f0381b3af1dad70dfb65a0d69364f3->block_body (line 556)
9	Twig\Template->yieldBlock (line 446)
10	__TwigTemplate_53369f3157bed95ec28f8e4b2db8582b->doDisplay (line 106)
11	Twig\Template->yield (line 402)
12	__TwigTemplate_c0f0381b3af1dad70dfb65a0d69364f3->doDisplay (line 55)
13	Twig\Template->yield (line 402)
14	Twig\Template->display (line 358)
15	Twig\Template->render (line 373)
16	Twig\TemplateWrapper->render (line 51)
17	Twig\Environment->render (line 333)
18	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 431)
19	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 436)
20	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 250)
21	App\Controller\EventsController->detailclanek (line 128)
22	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
23	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
24	Symfony\Component\HttpKernel\Kernel->handle (line 182)
25	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
26	require_once (line 29)
27	require_once (line 5)

0.31 ms
(2.73%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.general_partner AS general_partner_3, t0.web_url AS web_url_4, t0.poradi AS poradi_5, t0.logo_id AS logo_id_6 FROM partners t0 ORDER BY t0.poradi ASC

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.general_partner AS general_partner_3,
  t0.web_url AS web_url_4,
  t0.poradi AS poradi_5,
  t0.logo_id AS logo_id_6
FROM
  partners t0
ORDER BY
  t0.poradi ASC

SELECT t0.id AS id_1, t0.name AS name_2, t0.general_partner AS general_partner_3, t0.web_url AS web_url_4, t0.poradi AS poradi_5, t0.logo_id AS logo_id_6 FROM partners t0 ORDER BY t0.poradi ASC;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 942)
2	Doctrine\ORM\EntityRepository->findBy (line 110)
3	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findBy (line 73)
4	App\Twig\Extension\PartnerGlobalExtension->getGlobals (line 25)
5	Twig\ExtensionSet->getGlobals (line 359)
6	Twig\Environment->getGlobals (line 900)
7	Twig\Template->yield (line 398)
8	Twig\Template->display (line 358)
9	Twig\Template->render (line 373)
10	Twig\TemplateWrapper->render (line 51)
11	Twig\Environment->render (line 333)
12	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 431)
13	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 436)
14	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 250)
15	App\Controller\EventsController->detailclanek (line 128)
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.24 ms
(2.08%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.url AS url_3, t0.active AS active_4, t0.poradi AS poradi_5 FROM main_menu_items t0 WHERE t0.active = ? ORDER BY t0.poradi ASC

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.url AS url_3,
  t0.active AS active_4,
  t0.poradi AS poradi_5
FROM
  main_menu_items t0
WHERE
  t0.active = ?
ORDER BY
  t0.poradi ASC

SELECT t0.id AS id_1, t0.name AS name_2, t0.url AS url_3, t0.active AS active_4, t0.poradi AS poradi_5 FROM main_menu_items t0 WHERE t0.active = 1 ORDER BY t0.poradi ASC;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 942)
2	Doctrine\ORM\EntityRepository->findBy (line 110)
3	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findBy (line 73)
4	App\Twig\Extension\PartnerGlobalExtension->getGlobals (line 26)
5	Twig\ExtensionSet->getGlobals (line 359)
6	Twig\Environment->getGlobals (line 900)
7	Twig\Template->yield (line 398)
8	Twig\Template->display (line 358)
9	Twig\Template->render (line 373)
10	Twig\TemplateWrapper->render (line 51)
11	Twig\Environment->render (line 333)
12	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 431)
13	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 436)
14	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 250)
15	App\Controller\EventsController->detailclanek (line 128)
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.24 ms
(2.08%)

SELECT t0.id AS id_1, t0.file AS file_2, t0.updated_at AS updated_at_3 FROM uploaded t0 INNER JOIN event_content_uploaded ON t0.id = event_content_uploaded.uploaded_id WHERE event_content_uploaded.event_content_id = ?

Parameters:

[
  499
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.file AS file_2,
  t0.updated_at AS updated_at_3
FROM
  uploaded t0
  INNER JOIN event_content_uploaded ON t0.id = event_content_uploaded.uploaded_id
WHERE
  event_content_uploaded.event_content_id = ?

SELECT t0.id AS id_1, t0.file AS file_2, t0.updated_at AS updated_at_3 FROM uploaded t0 INNER JOIN event_content_uploaded ON t0.id = event_content_uploaded.uploaded_id WHERE event_content_uploaded.event_content_id = 499;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getManyToManyStatement (line 1085)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadManyToManyCollection (line 1014)
3	Doctrine\ORM\UnitOfWork->loadCollection (line 2726)
4	Doctrine\ORM\PersistentCollection->doInitialize (line 636)
5	Doctrine\ORM\PersistentCollection->initialize (line 186)
6	Doctrine\Common\Collections\AbstractLazyCollection->count (line 39)
7	Doctrine\ORM\PersistentCollection->count (line 391)
8	Twig\Extension\CoreExtension->length (line 1272)
9	__TwigTemplate_c0f0381b3af1dad70dfb65a0d69364f3::block_body (line 857)
10	Twig\Template->yieldBlock (line 446)
11	__TwigTemplate_53369f3157bed95ec28f8e4b2db8582b->doDisplay (line 106)
12	Twig\Template->yield (line 402)
13	__TwigTemplate_c0f0381b3af1dad70dfb65a0d69364f3->doDisplay (line 55)
14	Twig\Template->yield (line 402)
15	Twig\Template->display (line 358)
16	Twig\Template->render (line 373)
17	Twig\TemplateWrapper->render (line 51)
18	Twig\Environment->render (line 333)
19	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 431)
20	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 436)
21	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 250)
22	App\Controller\EventsController->detailclanek (line 128)
23	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
24	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
25	Symfony\Component\HttpKernel\Kernel->handle (line 182)
26	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
27	require_once (line 29)
28	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\Uploaded	18
App\Entity\EventContent	11
App\Entity\Events	10
App\Entity\User	7
App\Entity\Partners	7
App\Entity\MainMenuItems	6
App\Entity\Company	5
App\Entity\EventCatagories	2
App\Entity\EventType	1
App\Entity\Contacts	1

Entities Mapping

Class	Mapping errors
App\Entity\Events	No errors.
App\Entity\User	No errors.
App\Entity\Company	No errors.
App\Entity\EventType	No errors.
App\Entity\Uploaded	No errors.
App\Entity\EventCatagories	No errors.
App\Entity\EventTags	No errors.
App\Entity\EventContent	No errors.
App\Entity\Contacts	No errors.
App\Entity\Partners	No errors.
App\Entity\MainMenuItems	No errors.
App\Entity\Banners	No errors.
App\Entity\CategoryCompany	No errors.
App\Entity\TagsCompany	No errors.

Symfony Profiler

GET https://xkodev.dot11.cz/clanek/Vernisaz-Pod-vasimi-kridly-v-Ceskych-Budejovicich-127

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping