Symfony Profiler

Query Metrics

290 Database Queries

42 Different statements

95.09 ms Query time

2 Invalid entities

Grouped Statements

Show all queries

Time▼

Count

Info

16.25 ms
(17.09%)

SELECT t0.homepage AS homepage_1, t0.doc_files_order AS doc_files_order_2, t0.id AS id_3, t0.sort AS sort_4, t0.img_files_order AS img_files_order_5, t0.dms_img_updated AS dms_img_updated_6, t0.parent AS parent_7, t0.seo_id AS seo_id_8, t0.template_id AS template_id_9, t0.img_file_id AS img_file_id_10, t0.doc_file_id AS doc_file_id_11 FROM web_page t0 WHERE t0.id = ? LIMIT 1

Parameters:

[
  23
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.homepage AS homepage_1,
  t0.doc_files_order AS doc_files_order_2,
  t0.id AS id_3,
  t0.sort AS sort_4,
  t0.img_files_order AS img_files_order_5,
  t0.dms_img_updated AS dms_img_updated_6,
  t0.parent AS parent_7,
  t0.seo_id AS seo_id_8,
  t0.template_id AS template_id_9,
  t0.img_file_id AS img_file_id_10,
  t0.doc_file_id AS doc_file_id_11
FROM
  web_page t0
WHERE
  t0.id = ?
LIMIT
  1

SELECT t0.homepage AS homepage_1, t0.doc_files_order AS doc_files_order_2, t0.id AS id_3, t0.sort AS sort_4, t0.img_files_order AS img_files_order_5, t0.dms_img_updated AS dms_img_updated_6, t0.parent AS parent_7, t0.seo_id AS seo_id_8, t0.template_id AS template_id_9, t0.img_file_id AS img_file_id_10, t0.doc_file_id AS doc_file_id_11 FROM web_page t0 WHERE t0.id = 23 LIMIT 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 779)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 240)
3	Doctrine\ORM\EntityRepository->findOneBy (line 33)
4	NexCRM\WebBundle\Repository\MenuRepository->findByGroupOrdered (line 85)
5	App\Controller\BaseController->initialize (line 39)
6	App\Controller\PageController->pageAction (line 181)
7	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
8	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
9	Symfony\Component\HttpKernel\Kernel->handle (line 42)

12.68 ms
(13.33%)

SELECT t0.name AS name_1, t0.allergen AS allergen_2, t0.text AS text_3, t0.price AS price_4, t0.id AS id_5, t0.locale AS locale_6, t0.translatable_id AS translatable_id_7 FROM food_translation t0 WHERE t0.translatable_id = ?

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.name AS name_1,
  t0.allergen AS allergen_2,
  t0.text AS text_3,
  t0.price AS price_4,
  t0.id AS id_5,
  t0.locale AS locale_6,
  t0.translatable_id AS translatable_id_7
FROM
  food_translation t0
WHERE
  t0.translatable_id = ?

SELECT t0.name AS name_1, t0.allergen AS allergen_2, t0.text AS text_3, t0.price AS price_4, t0.id AS id_5, t0.locale AS locale_6, t0.translatable_id AS translatable_id_7 FROM food_translation t0 WHERE t0.translatable_id = 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 1920)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getOneToManyStatement (line 1861)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToManyCollection (line 3301)
4	Doctrine\ORM\UnitOfWork->loadCollection (line 706)
5	Doctrine\ORM\PersistentCollection->doInitialize (line 218)
6	Doctrine\ORM\PersistentCollection->initialize (line 118)
7	Doctrine\Common\Collections\AbstractLazyCollection->get (line 445)
8	Doctrine\ORM\PersistentCollection->get (line 190)
9	App\Entity\Food->findTranslationByLocale (line 138)
10	App\Entity\Food->doTranslate (line 75)
11	App\Entity\Food->translate (line 1882)
12	Twig\Extension\CoreExtension::getAttribute (line 99)
13	__TwigTemplate_129dd9729ae612099ca59c2a1273dc17->doDisplay (line 388)
14	Twig\Template->yield (line 109)
15	__TwigTemplate_d6f5a974ffe022dc7665f15ebee20594->block_content (line 432)
16	Twig\Template->yieldBlock (line 197)
17	__TwigTemplate_a7a9180b403871f90ae957b92a2e9794->doDisplay (line 388)
18	Twig\Template->yield (line 54)
19	__TwigTemplate_e725e9007ecc96bfefee296aad70013f->doDisplay (line 388)
20	Twig\Template->yield (line 54)
21	__TwigTemplate_d6f5a974ffe022dc7665f15ebee20594->doDisplay (line 388)
22	Twig\Template->yield (line 344)
23	Twig\Template->display (line 359)
24	Twig\Template->render (line 51)
25	Twig\TemplateWrapper->render (line 334)
26	Twig\Environment->render (line 448)
27	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 453)
28	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 253)
29	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 66)
30	App\Controller\BaseController->render (line 63)
31	App\Controller\PageController->pageAction (line 181)
32	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
33	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
34	Symfony\Component\HttpKernel\Kernel->handle (line 42)

7.89 ms
(8.30%)

SELECT t0.link_id AS link_id_1, t0.url AS url_2, t0.active AS active_3, t0.id AS id_4, t0.sort AS sort_5, t0.parent AS parent_6, t0.module_id AS module_id_7, t0.img_file_id AS img_file_id_8 FROM web_menu t0 WHERE (t0.active = ? AND t0.parent = ?) ORDER BY t0.sort ASC

Parameters:

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.link_id AS link_id_1,
  t0.url AS url_2,
  t0.active AS active_3,
  t0.id AS id_4,
  t0.sort AS sort_5,
  t0.parent AS parent_6,
  t0.module_id AS module_id_7,
  t0.img_file_id AS img_file_id_8
FROM
  web_menu t0
WHERE
  (
    t0.active = ?
    AND t0.parent = ?
  )
ORDER BY
  t0.sort ASC

SELECT t0.link_id AS link_id_1, t0.url AS url_2, t0.active AS active_3, t0.id AS id_4, t0.sort AS sort_5, t0.parent AS parent_6, t0.module_id AS module_id_7, t0.img_file_id AS img_file_id_8 FROM web_menu t0 WHERE (t0.active = 1 AND t0.parent = 16) ORDER BY t0.sort ASC;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 924)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadCriteria (line 680)
3	Doctrine\ORM\PersistentCollection->matching (line 158)
4	NexCRM\WebBundle\Entity\Menu->getActiveChildren (line 1882)
5	Twig\Extension\CoreExtension::getAttribute (line 106)
6	__TwigTemplate_e725e9007ecc96bfefee296aad70013f->block_header (line 432)
7	Twig\Template->yieldBlock (line 192)
8	__TwigTemplate_a7a9180b403871f90ae957b92a2e9794->doDisplay (line 388)
9	Twig\Template->yield (line 54)
10	__TwigTemplate_e725e9007ecc96bfefee296aad70013f->doDisplay (line 388)
11	Twig\Template->yield (line 54)
12	__TwigTemplate_d6f5a974ffe022dc7665f15ebee20594->doDisplay (line 388)
13	Twig\Template->yield (line 344)
14	Twig\Template->display (line 359)
15	Twig\Template->render (line 51)
16	Twig\TemplateWrapper->render (line 334)
17	Twig\Environment->render (line 448)
18	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 453)
19	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 253)
20	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 66)
21	App\Controller\BaseController->render (line 63)
22	App\Controller\PageController->pageAction (line 181)
23	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
24	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
25	Symfony\Component\HttpKernel\Kernel->handle (line 42)

5.44 ms
(5.72%)

SELECT t0.name AS name_1, t0.id AS id_2, t0.locale AS locale_3, t0.translatable_id AS translatable_id_4 FROM food_category_translation t0 WHERE t0.translatable_id = ?

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.name AS name_1,
  t0.id AS id_2,
  t0.locale AS locale_3,
  t0.translatable_id AS translatable_id_4
FROM
  food_category_translation t0
WHERE
  t0.translatable_id = ?

SELECT t0.name AS name_1, t0.id AS id_2, t0.locale AS locale_3, t0.translatable_id AS translatable_id_4 FROM food_category_translation t0 WHERE t0.translatable_id = 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 1920)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getOneToManyStatement (line 1861)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToManyCollection (line 3301)
4	Doctrine\ORM\UnitOfWork->loadCollection (line 706)
5	Doctrine\ORM\PersistentCollection->doInitialize (line 218)
6	Doctrine\ORM\PersistentCollection->initialize (line 118)
7	Doctrine\Common\Collections\AbstractLazyCollection->get (line 445)
8	Doctrine\ORM\PersistentCollection->get (line 190)
9	App\Entity\FoodCategory->findTranslationByLocale (line 138)
10	App\Entity\FoodCategory->doTranslate (line 75)
11	App\Entity\FoodCategory->translate (line 335)
12	Proxies\__CG__\App\Entity\FoodCategory->translate (line 1882)
13	Twig\Extension\CoreExtension::getAttribute (line 77)
14	__TwigTemplate_129dd9729ae612099ca59c2a1273dc17->doDisplay (line 388)
15	Twig\Template->yield (line 109)
16	__TwigTemplate_d6f5a974ffe022dc7665f15ebee20594->block_content (line 432)
17	Twig\Template->yieldBlock (line 197)
18	__TwigTemplate_a7a9180b403871f90ae957b92a2e9794->doDisplay (line 388)
19	Twig\Template->yield (line 54)
20	__TwigTemplate_e725e9007ecc96bfefee296aad70013f->doDisplay (line 388)
21	Twig\Template->yield (line 54)
22	__TwigTemplate_d6f5a974ffe022dc7665f15ebee20594->doDisplay (line 388)
23	Twig\Template->yield (line 344)
24	Twig\Template->display (line 359)
25	Twig\Template->render (line 51)
26	Twig\TemplateWrapper->render (line 334)
27	Twig\Environment->render (line 448)
28	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 453)
29	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 253)
30	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 66)
31	App\Controller\BaseController->render (line 63)
32	App\Controller\PageController->pageAction (line 181)
33	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
34	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
35	Symfony\Component\HttpKernel\Kernel->handle (line 42)

4.17 ms
(4.39%)

SELECT t0.title AS title_1, t0.description AS description_2, t0.keywords AS keywords_3, t0.name AS name_4, t0.url AS url_5, t0.`generated` AS generated_6, t0.id AS id_7, t0.locale AS locale_8, t0.translatable_id AS translatable_id_9 FROM web_seo_translation t0 WHERE t0.translatable_id = ?

Parameters:

[
  23
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.title AS title_1,
  t0.description AS description_2,
  t0.keywords AS keywords_3,
  t0.name AS name_4,
  t0.url AS url_5,
  t0.`generated` AS generated_6,
  t0.id AS id_7,
  t0.locale AS locale_8,
  t0.translatable_id AS translatable_id_9
FROM
  web_seo_translation t0
WHERE
  t0.translatable_id = ?

SELECT t0.title AS title_1, t0.description AS description_2, t0.keywords AS keywords_3, t0.name AS name_4, t0.url AS url_5, t0.`generated` AS generated_6, t0.id AS id_7, t0.locale AS locale_8, t0.translatable_id AS translatable_id_9 FROM web_seo_translation t0 WHERE t0.translatable_id = 23;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 1920)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getOneToManyStatement (line 1861)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToManyCollection (line 3301)
4	Doctrine\ORM\UnitOfWork->loadCollection (line 706)
5	Doctrine\ORM\PersistentCollection->doInitialize (line 218)
6	Doctrine\ORM\PersistentCollection->initialize (line 118)
7	Doctrine\Common\Collections\AbstractLazyCollection->get (line 445)
8	Doctrine\ORM\PersistentCollection->get (line 190)
9	NexCRM\WebBundle\Entity\SEO->findTranslationByLocale (line 138)
10	NexCRM\WebBundle\Entity\SEO->doTranslate (line 75)
11	NexCRM\WebBundle\Entity\SEO->translate (line 401)
12	Proxies\__CG__\NexCRM\WebBundle\Entity\SEO->translate (line 35)
13	NexCRM\WebBundle\Repository\MenuRepository->findByGroupOrdered (line 85)
14	App\Controller\BaseController->initialize (line 39)
15	App\Controller\PageController->pageAction (line 181)
16	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
17	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
18	Symfony\Component\HttpKernel\Kernel->handle (line 42)

4.14 ms
(4.35%)

SELECT t0.name AS name_1, t0.disabled AS disabled_2, t0.id AS id_3, t0.locale AS locale_4, t0.translatable_id AS translatable_id_5 FROM web_menu_translation t0 WHERE t0.translatable_id = ?

Parameters:

[
  16
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.name AS name_1,
  t0.disabled AS disabled_2,
  t0.id AS id_3,
  t0.locale AS locale_4,
  t0.translatable_id AS translatable_id_5
FROM
  web_menu_translation t0
WHERE
  t0.translatable_id = ?

SELECT t0.name AS name_1, t0.disabled AS disabled_2, t0.id AS id_3, t0.locale AS locale_4, t0.translatable_id AS translatable_id_5 FROM web_menu_translation t0 WHERE t0.translatable_id = 16;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 1920)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getOneToManyStatement (line 1861)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToManyCollection (line 3301)
4	Doctrine\ORM\UnitOfWork->loadCollection (line 706)
5	Doctrine\ORM\PersistentCollection->doInitialize (line 218)
6	Doctrine\ORM\PersistentCollection->initialize (line 118)
7	Doctrine\Common\Collections\AbstractLazyCollection->get (line 445)
8	Doctrine\ORM\PersistentCollection->get (line 190)
9	NexCRM\WebBundle\Entity\Menu->findTranslationByLocale (line 138)
10	NexCRM\WebBundle\Entity\Menu->doTranslate (line 75)
11	NexCRM\WebBundle\Entity\Menu->translate (line 26)
12	NexCRM\WebBundle\Repository\MenuRepository->findByGroupOrdered (line 85)
13	App\Controller\BaseController->initialize (line 39)
14	App\Controller\PageController->pageAction (line 181)
15	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
16	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
17	Symfony\Component\HttpKernel\Kernel->handle (line 42)

3.88 ms
(4.08%)

SELECT t0.name AS name_1, t0.text AS text_2, t0.id AS id_3, t0.locale AS locale_4, t0.translatable_id AS translatable_id_5 FROM room_translation t0 WHERE t0.translatable_id = ?

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.name AS name_1,
  t0.text AS text_2,
  t0.id AS id_3,
  t0.locale AS locale_4,
  t0.translatable_id AS translatable_id_5
FROM
  room_translation t0
WHERE
  t0.translatable_id = ?

SELECT t0.name AS name_1, t0.text AS text_2, t0.id AS id_3, t0.locale AS locale_4, t0.translatable_id AS translatable_id_5 FROM room_translation t0 WHERE t0.translatable_id = 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 1920)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getOneToManyStatement (line 1861)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToManyCollection (line 3301)
4	Doctrine\ORM\UnitOfWork->loadCollection (line 706)
5	Doctrine\ORM\PersistentCollection->doInitialize (line 218)
6	Doctrine\ORM\PersistentCollection->initialize (line 118)
7	Doctrine\Common\Collections\AbstractLazyCollection->get (line 445)
8	Doctrine\ORM\PersistentCollection->get (line 190)
9	App\Entity\Room->findTranslationByLocale (line 53)
10	App\Entity\Room->__toString (line 59)
11	Symfony\Bridge\Doctrine\Form\Type\DoctrineType::createChoiceLabel (line 162)
12	Symfony\Component\Form\ChoiceList\Factory\DefaultChoiceListFactory::addChoiceView (line 237)
13	Symfony\Component\Form\ChoiceList\Factory\DefaultChoiceListFactory::addChoiceViewsFromStructuredValues (line 127)
14	Symfony\Component\Form\ChoiceList\Factory\DefaultChoiceListFactory->createView (line 182)
15	Symfony\Component\Form\ChoiceList\Factory\PropertyAccessDecorator->createView (line 208)
16	Symfony\Component\Form\ChoiceList\Factory\CachingFactoryDecorator->createView (line 465)
17	Symfony\Component\Form\Extension\Core\Type\ChoiceType->createChoiceListView (line 238)
18	Symfony\Component\Form\Extension\Core\Type\ChoiceType->buildView (line 116)
19	Symfony\Component\Form\ResolvedFormType->buildView (line 87)
20	Symfony\Component\Form\Extension\DataCollector\Proxy\ResolvedTypeDataCollectorProxy->buildView (line 114)
21	Symfony\Component\Form\ResolvedFormType->buildView (line 87)
22	Symfony\Component\Form\Extension\DataCollector\Proxy\ResolvedTypeDataCollectorProxy->buildView (line 900)
23	Symfony\Component\Form\Form->createView (line 903)
24	Symfony\Component\Form\Form->createView (line 160)
25	App\Controller\BaseController->initialize (line 39)
26	App\Controller\PageController->pageAction (line 181)
27	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
28	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
29	Symfony\Component\HttpKernel\Kernel->handle (line 42)

3.26 ms
(3.43%)

SELECT t0.noindex AS noindex_1, t0.module AS module_2, t0.anchor AS anchor_3, t0.suffix AS suffix_4, t0.entity AS entity_5, t0.id AS id_6 FROM web_seo t0 WHERE t0.id = ?

Parameters:

[
  23
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.noindex AS noindex_1,
  t0.module AS module_2,
  t0.anchor AS anchor_3,
  t0.suffix AS suffix_4,
  t0.entity AS entity_5,
  t0.id AS id_6
FROM
  web_seo t0
WHERE
  t0.id = ?

SELECT t0.noindex AS noindex_1, t0.module AS module_2, t0.anchor AS anchor_3, t0.suffix AS suffix_4, t0.entity AS entity_5, t0.id AS id_6 FROM web_seo t0 WHERE t0.id = 23;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 779)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 797)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 333)
4	Doctrine\ORM\Proxy\ProxyFactory->{closure:Doctrine\ORM\Proxy\ProxyFactory::createInitializer():305} (line 399)
5	Closure->__invoke (line 399)
6	Proxies\__CG__\NexCRM\WebBundle\Entity\SEO->translate (line 35)
7	NexCRM\WebBundle\Repository\MenuRepository->findByGroupOrdered (line 85)
8	App\Controller\BaseController->initialize (line 39)
9	App\Controller\PageController->pageAction (line 181)
10	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
11	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
12	Symfony\Component\HttpKernel\Kernel->handle (line 42)

3.22 ms
(3.39%)

SELECT t0.trans_value AS trans_value_1, t0.id AS id_2, t0.locale AS locale_3, t0.translatable_id AS translatable_id_4 FROM setting_translation t0 WHERE t0.translatable_id = ?

Parameters:

[
  3
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.trans_value AS trans_value_1,
  t0.id AS id_2,
  t0.locale AS locale_3,
  t0.translatable_id AS translatable_id_4
FROM
  setting_translation t0
WHERE
  t0.translatable_id = ?

SELECT t0.trans_value AS trans_value_1, t0.id AS id_2, t0.locale AS locale_3, t0.translatable_id AS translatable_id_4 FROM setting_translation t0 WHERE t0.translatable_id = 3;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 1920)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getOneToManyStatement (line 1861)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToManyCollection (line 3301)
4	Doctrine\ORM\UnitOfWork->loadCollection (line 706)
5	Doctrine\ORM\PersistentCollection->doInitialize (line 218)
6	Doctrine\ORM\PersistentCollection->initialize (line 118)
7	Doctrine\Common\Collections\AbstractLazyCollection->get (line 445)
8	Doctrine\ORM\PersistentCollection->get (line 190)
9	NexCRM\BaseBundle\Entity\Setting->findTranslationByLocale (line 138)
10	NexCRM\BaseBundle\Entity\Setting->doTranslate (line 75)
11	NexCRM\BaseBundle\Entity\Setting->translate (line 22)
12	NexCRM\WebBundle\Service\MetaTagsService->getMetaTags (line 66)
13	App\Controller\PageController->pageAction (line 181)
14	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
15	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
16	Symfony\Component\HttpKernel\Kernel->handle (line 42)

2.85 ms
(3.00%)

SELECT t0.path AS path_1, t0.type AS type_2, t0.template AS template_3, t0.upload_form AS upload_form_4, t0.data_sources AS data_sources_5, t0.only_once AS only_once_6, t0.id AS id_7, t0.updated_at AS updated_at_8, t0.upload AS upload_9 FROM web_template t0 WHERE t0.id = ?

Parameters:

[
  2
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.path AS path_1,
  t0.type AS type_2,
  t0.template AS template_3,
  t0.upload_form AS upload_form_4,
  t0.data_sources AS data_sources_5,
  t0.only_once AS only_once_6,
  t0.id AS id_7,
  t0.updated_at AS updated_at_8,
  t0.upload AS upload_9
FROM
  web_template t0
WHERE
  t0.id = ?

SELECT t0.path AS path_1, t0.type AS type_2, t0.template AS template_3, t0.upload_form AS upload_form_4, t0.data_sources AS data_sources_5, t0.only_once AS only_once_6, t0.id AS id_7, t0.updated_at AS updated_at_8, t0.upload AS upload_9 FROM web_template t0 WHERE t0.id = 2;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 779)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 797)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 333)
4	Doctrine\ORM\Proxy\ProxyFactory->{closure:Doctrine\ORM\Proxy\ProxyFactory::createInitializer():305} (line 197)
5	Closure->__invoke (line 197)
6	Proxies\__CG__\NexCRM\WebBundle\Entity\Template->getPath (line 21)
7	NexCRM\WebBundle\Service\PageTemplateService->getPagetemplate (line 87)
8	App\Controller\BaseController->initialize (line 39)
9	App\Controller\PageController->pageAction (line 181)
10	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
11	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
12	Symfony\Component\HttpKernel\Kernel->handle (line 42)

2.59 ms
(2.72%)

SELECT l0_.token AS token_0, l0_.id AS id_1 FROM lang_token l0_

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  l0_.token AS token_0,
  l0_.id AS id_1
FROM
  lang_token l0_

SELECT l0_.token AS token_0, l0_.id AS id_1 FROM lang_token l0_;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 31)
2	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 330)
3	Doctrine\ORM\Query->_doExecute (line 1218)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 1172)
5	Doctrine\ORM\AbstractQuery->execute (line 907)
6	Doctrine\ORM\AbstractQuery->getResult (line 76)
7	NexCRM\BaseBundle\Service\Translator->checkToken (line 31)
8	NexCRM\BaseBundle\Service\Translator->trans (line 125)
9	Symfony\Bridge\Twig\Extension\TranslationExtension->trans (line 278)
10	__TwigTemplate_e725e9007ecc96bfefee296aad70013f->block_header (line 432)
11	Twig\Template->yieldBlock (line 192)
12	__TwigTemplate_a7a9180b403871f90ae957b92a2e9794->doDisplay (line 388)
13	Twig\Template->yield (line 54)
14	__TwigTemplate_e725e9007ecc96bfefee296aad70013f->doDisplay (line 388)
15	Twig\Template->yield (line 54)
16	__TwigTemplate_d6f5a974ffe022dc7665f15ebee20594->doDisplay (line 388)
17	Twig\Template->yield (line 344)
18	Twig\Template->display (line 359)
19	Twig\Template->render (line 51)
20	Twig\TemplateWrapper->render (line 334)
21	Twig\Environment->render (line 448)
22	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 453)
23	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 253)
24	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 66)
25	App\Controller\BaseController->render (line 63)
26	App\Controller\PageController->pageAction (line 181)
27	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
28	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
29	Symfony\Component\HttpKernel\Kernel->handle (line 42)

2.44 ms
(2.57%)

SELECT t0.name AS name_1, t0.media AS media_2, t0.updated_at AS updated_at_3, t0.file_size AS file_size_4, t0.ext AS ext_5, t0.preview AS preview_6, t0.pdf_preview AS pdf_preview_7, t0.deleted AS deleted_8, t0.deleted_at AS deleted_at_9, t0.seo AS seo_10, t0.height AS height_11, t0.width AS width_12, t0.disable_dynamic_fields AS disable_dynamic_fields_13, t0.disable_preview AS disable_preview_14, t0.id AS id_15, t0.folder_id AS folder_id_16, t17.name AS name_18, t17.description AS description_19, t17.deleted AS deleted_20, t17.deleted_at AS deleted_at_21, t17.date_representation AS date_representation_22, t17.active AS active_23, t17.undeletable AS undeletable_24, t17.id AS id_25, t17.parent_id AS parent_id_26, t17.company AS company_27, t17.filter_id AS filter_id_28, t17.file_type_id AS file_type_id_29, t17.numerical_root_id AS numerical_root_id_30, t31.id AS id_32, t31.file_id AS file_id_33, t31.file_type_id AS file_type_id_34 FROM dms_file t0 LEFT JOIN dms_folder t17 ON t0.folder_id = t17.id LEFT JOIN dms_file_parameters t31 ON t31.file_id = t0.id WHERE t0.id = ?

Parameters:

[
  275
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.name AS name_1,
  t0.media AS media_2,
  t0.updated_at AS updated_at_3,
  t0.file_size AS file_size_4,
  t0.ext AS ext_5,
  t0.preview AS preview_6,
  t0.pdf_preview AS pdf_preview_7,
  t0.deleted AS deleted_8,
  t0.deleted_at AS deleted_at_9,
  t0.seo AS seo_10,
  t0.height AS height_11,
  t0.width AS width_12,
  t0.disable_dynamic_fields AS disable_dynamic_fields_13,
  t0.disable_preview AS disable_preview_14,
  t0.id AS id_15,
  t0.folder_id AS folder_id_16,
  t17.name AS name_18,
  t17.description AS description_19,
  t17.deleted AS deleted_20,
  t17.deleted_at AS deleted_at_21,
  t17.date_representation AS date_representation_22,
  t17.active AS active_23,
  t17.undeletable AS undeletable_24,
  t17.id AS id_25,
  t17.parent_id AS parent_id_26,
  t17.company AS company_27,
  t17.filter_id AS filter_id_28,
  t17.file_type_id AS file_type_id_29,
  t17.numerical_root_id AS numerical_root_id_30,
  t31.id AS id_32,
  t31.file_id AS file_id_33,
  t31.file_type_id AS file_type_id_34
FROM
  dms_file t0
  LEFT JOIN dms_folder t17 ON t0.folder_id = t17.id
  LEFT JOIN dms_file_parameters t31 ON t31.file_id = t0.id
WHERE
  t0.id = ?

SELECT t0.name AS name_1, t0.media AS media_2, t0.updated_at AS updated_at_3, t0.file_size AS file_size_4, t0.ext AS ext_5, t0.preview AS preview_6, t0.pdf_preview AS pdf_preview_7, t0.deleted AS deleted_8, t0.deleted_at AS deleted_at_9, t0.seo AS seo_10, t0.height AS height_11, t0.width AS width_12, t0.disable_dynamic_fields AS disable_dynamic_fields_13, t0.disable_preview AS disable_preview_14, t0.id AS id_15, t0.folder_id AS folder_id_16, t17.name AS name_18, t17.description AS description_19, t17.deleted AS deleted_20, t17.deleted_at AS deleted_at_21, t17.date_representation AS date_representation_22, t17.active AS active_23, t17.undeletable AS undeletable_24, t17.id AS id_25, t17.parent_id AS parent_id_26, t17.company AS company_27, t17.filter_id AS filter_id_28, t17.file_type_id AS file_type_id_29, t17.numerical_root_id AS numerical_root_id_30, t31.id AS id_32, t31.file_id AS file_id_33, t31.file_type_id AS file_type_id_34 FROM dms_file t0 LEFT JOIN dms_folder t17 ON t0.folder_id = t17.id LEFT JOIN dms_file_parameters t31 ON t31.file_id = t0.id WHERE t0.id = 275;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 779)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 797)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 333)
4	Doctrine\ORM\Proxy\ProxyFactory->{closure:Doctrine\ORM\Proxy\ProxyFactory::createInitializer():305} (line 186)
5	Closure->__invoke (line 186)
6	Proxies\__CG__\NexCRM\DMSBundle\Entity\File->__toString (line 1394)
7	Twig\Extension\CoreExtension::testEmpty (line 49)
8	__TwigTemplate_44e76a9314ae9b8003a3a386a80d4f3e->doDisplay (line 388)
9	Twig\Template->yield (line 78)
10	__TwigTemplate_d6f5a974ffe022dc7665f15ebee20594->block_content (line 432)
11	Twig\Template->yieldBlock (line 197)
12	__TwigTemplate_a7a9180b403871f90ae957b92a2e9794->doDisplay (line 388)
13	Twig\Template->yield (line 54)
14	__TwigTemplate_e725e9007ecc96bfefee296aad70013f->doDisplay (line 388)
15	Twig\Template->yield (line 54)
16	__TwigTemplate_d6f5a974ffe022dc7665f15ebee20594->doDisplay (line 388)
17	Twig\Template->yield (line 344)
18	Twig\Template->display (line 359)
19	Twig\Template->render (line 51)
20	Twig\TemplateWrapper->render (line 334)
21	Twig\Environment->render (line 448)
22	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 453)
23	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 253)
24	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 66)
25	App\Controller\BaseController->render (line 63)
26	App\Controller\PageController->pageAction (line 181)
27	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
28	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
29	Symfony\Component\HttpKernel\Kernel->handle (line 42)

2.34 ms
(2.46%)

SELECT t0.active AS active_1, t0.id AS id_2, t0.sort AS sort_3, t0.food_category_id AS food_category_id_4 FROM food t0 WHERE t0.food_category_id = ?

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.active AS active_1,
  t0.id AS id_2,
  t0.sort AS sort_3,
  t0.food_category_id AS food_category_id_4
FROM
  food t0
WHERE
  t0.food_category_id = ?

SELECT t0.active AS active_1, t0.id AS id_2, t0.sort AS sort_3, t0.food_category_id AS food_category_id_4 FROM food t0 WHERE t0.food_category_id = 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 1920)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getOneToManyStatement (line 1861)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToManyCollection (line 3301)
4	Doctrine\ORM\UnitOfWork->loadCollection (line 706)
5	Doctrine\ORM\PersistentCollection->doInitialize (line 218)
6	Doctrine\ORM\PersistentCollection->initialize (line 39)
7	Doctrine\Common\Collections\AbstractLazyCollection->count (line 456)
8	Doctrine\ORM\PersistentCollection->count (line 1386)
9	Twig\Extension\CoreExtension::testEmpty (line 58)
10	__TwigTemplate_129dd9729ae612099ca59c2a1273dc17->doDisplay (line 388)
11	Twig\Template->yield (line 109)
12	__TwigTemplate_d6f5a974ffe022dc7665f15ebee20594->block_content (line 432)
13	Twig\Template->yieldBlock (line 197)
14	__TwigTemplate_a7a9180b403871f90ae957b92a2e9794->doDisplay (line 388)
15	Twig\Template->yield (line 54)
16	__TwigTemplate_e725e9007ecc96bfefee296aad70013f->doDisplay (line 388)
17	Twig\Template->yield (line 54)
18	__TwigTemplate_d6f5a974ffe022dc7665f15ebee20594->doDisplay (line 388)
19	Twig\Template->yield (line 344)
20	Twig\Template->display (line 359)
21	Twig\Template->render (line 51)
22	Twig\TemplateWrapper->render (line 334)
23	Twig\Environment->render (line 448)
24	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 453)
25	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 253)
26	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 66)
27	App\Controller\BaseController->render (line 63)
28	App\Controller\PageController->pageAction (line 181)
29	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
30	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
31	Symfony\Component\HttpKernel\Kernel->handle (line 42)

2.25 ms
(2.37%)

SELECT t0.alias AS alias_1, t0.value AS value_2, t0.id AS id_3 FROM setting t0 WHERE t0.alias = ? LIMIT 1

Parameters:

[
  "marketing_code_hard_write"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.alias AS alias_1,
  t0.value AS value_2,
  t0.id AS id_3
FROM
  setting t0
WHERE
  t0.alias = ?
LIMIT
  1

SELECT t0.alias AS alias_1, t0.value AS value_2, t0.id AS id_3 FROM setting t0 WHERE t0.alias = 'marketing_code_hard_write' LIMIT 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 779)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 240)
3	Doctrine\ORM\EntityRepository->findOneBy (line 140)
4	NexCRM\WebBundle\Service\MarketingService->getCodeByEnabledCookie (line 122)
5	NexCRM\WebBundle\Service\MarketingService->getCodes (line 66)
6	NexCRM\WebBundle\Twig\MarketingTwigExtension->marketing (line 157)
7	__TwigTemplate_a7a9180b403871f90ae957b92a2e9794->doDisplay (line 388)
8	Twig\Template->yield (line 54)
9	__TwigTemplate_e725e9007ecc96bfefee296aad70013f->doDisplay (line 388)
10	Twig\Template->yield (line 54)
11	__TwigTemplate_d6f5a974ffe022dc7665f15ebee20594->doDisplay (line 388)
12	Twig\Template->yield (line 344)
13	Twig\Template->display (line 359)
14	Twig\Template->render (line 51)
15	Twig\TemplateWrapper->render (line 334)
16	Twig\Environment->render (line 448)
17	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 453)
18	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 253)
19	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 66)
20	App\Controller\BaseController->render (line 63)
21	App\Controller\PageController->pageAction (line 181)
22	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
23	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
24	Symfony\Component\HttpKernel\Kernel->handle (line 42)

1.74 ms
(1.83%)

SELECT t0.name AS name_1, t0.iso_2 AS iso_2_2, t0.iso_3 AS iso_3_3, t0.default_lang AS default_lang_4, t0.active AS active_5, t0.id AS id_6, t0.country AS country_7 FROM lang t0 WHERE t0.active = ?

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.name AS name_1,
  t0.iso_2 AS iso_2_2,
  t0.iso_3 AS iso_3_3,
  t0.default_lang AS default_lang_4,
  t0.active AS active_5,
  t0.id AS id_6,
  t0.country AS country_7
FROM
  lang t0
WHERE
  t0.active = ?

SELECT t0.name AS name_1, t0.iso_2 AS iso_2_2, t0.iso_3 AS iso_3_3, t0.default_lang AS default_lang_4, t0.active AS active_5, t0.id AS id_6, t0.country AS country_7 FROM lang t0 WHERE t0.active = 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 972)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 224)
3	Doctrine\ORM\EntityRepository->findBy (line 29)
4	NexCRM\BaseBundle\EventListener\LocaleListener->onKernelRequest (line 116)
5	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 220)
6	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
7	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 139)
8	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 157)
9	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
10	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
11	Symfony\Component\HttpKernel\Kernel->handle (line 42)

1.72 ms
(1.81%)

SELECT t0.entity_class AS entity_class_1, t0.request_id AS request_id_2, t0.property AS property_3, t0.media_order AS media_order_4, t0.created AS created_5, t0.entity_id AS entity_id_6, t0.id AS id_7 FROM media_order_record t0 WHERE t0.request_id = ?

Parameters:

[
  "b8763e3cee_68085dec9c21c1.21769632"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.entity_class AS entity_class_1,
  t0.request_id AS request_id_2,
  t0.property AS property_3,
  t0.media_order AS media_order_4,
  t0.created AS created_5,
  t0.entity_id AS entity_id_6,
  t0.id AS id_7
FROM
  media_order_record t0
WHERE
  t0.request_id = ?

SELECT t0.entity_class AS entity_class_1, t0.request_id AS request_id_2, t0.property AS property_3, t0.media_order AS media_order_4, t0.created AS created_5, t0.entity_id AS entity_id_6, t0.id AS id_7 FROM media_order_record t0 WHERE t0.request_id = 'b8763e3cee_68085dec9c21c1.21769632';

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 972)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 224)
3	Doctrine\ORM\EntityRepository->findBy (line 27)
4	NexCRM\BaseBundle\EventListener\ResponseListener->onKernelResponse (line 116)
5	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 220)
6	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
7	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 139)
8	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 214)
9	Symfony\Component\HttpKernel\HttpKernel->filterResponse (line 202)
10	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
11	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
12	Symfony\Component\HttpKernel\Kernel->handle (line 42)

1.32 ms
(1.39%)

SELECT t0.alias AS alias_1, t0.active AS active_2, t0.api AS api_3, t0.display AS display_4, t0.script AS script_5, t0.category AS category_6, t0.position AS position_7, t0.code1 AS code1_8, t0.code2 AS code2_9, t0.id AS id_10, t0.sort AS sort_11 FROM web_code t0 WHERE t0.active = ? ORDER BY t0.sort ASC

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.alias AS alias_1,
  t0.active AS active_2,
  t0.api AS api_3,
  t0.display AS display_4,
  t0.script AS script_5,
  t0.category AS category_6,
  t0.position AS position_7,
  t0.code1 AS code1_8,
  t0.code2 AS code2_9,
  t0.id AS id_10,
  t0.sort AS sort_11
FROM
  web_code t0
WHERE
  t0.active = ?
ORDER BY
  t0.sort ASC

SELECT t0.alias AS alias_1, t0.active AS active_2, t0.api AS api_3, t0.display AS display_4, t0.script AS script_5, t0.category AS category_6, t0.position AS position_7, t0.code1 AS code1_8, t0.code2 AS code2_9, t0.id AS id_10, t0.sort AS sort_11 FROM web_code t0 WHERE t0.active = 1 ORDER BY t0.sort ASC;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 972)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 224)
3	Doctrine\ORM\EntityRepository->findBy (line 157)
4	NexCRM\WebBundle\Service\MarketingService->getCodeByEnabledCookie (line 122)
5	NexCRM\WebBundle\Service\MarketingService->getCodes (line 66)
6	NexCRM\WebBundle\Twig\MarketingTwigExtension->marketing (line 157)
7	__TwigTemplate_a7a9180b403871f90ae957b92a2e9794->doDisplay (line 388)
8	Twig\Template->yield (line 54)
9	__TwigTemplate_e725e9007ecc96bfefee296aad70013f->doDisplay (line 388)
10	Twig\Template->yield (line 54)
11	__TwigTemplate_d6f5a974ffe022dc7665f15ebee20594->doDisplay (line 388)
12	Twig\Template->yield (line 344)
13	Twig\Template->display (line 359)
14	Twig\Template->render (line 51)
15	Twig\TemplateWrapper->render (line 334)
16	Twig\Environment->render (line 448)
17	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 453)
18	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 253)
19	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 66)
20	App\Controller\BaseController->render (line 63)
21	App\Controller\PageController->pageAction (line 181)
22	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
23	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
24	Symfony\Component\HttpKernel\Kernel->handle (line 42)

1.29 ms
(1.36%)

SELECT t0.alias AS alias_1, t0.value AS value_2, t0.id AS id_3 FROM setting t0

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.alias AS alias_1,
  t0.value AS value_2,
  t0.id AS id_3
FROM
  setting t0

SELECT t0.alias AS alias_1, t0.value AS value_2, t0.id AS id_3 FROM setting t0;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 972)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 224)
3	Doctrine\ORM\EntityRepository->findBy (line 206)
4	Doctrine\ORM\EntityRepository->findAll (line 17)
5	NexCRM\BaseBundle\Repository\SettingRepository->findByToArray (line 84)
6	App\Controller\BaseController->initialize (line 39)
7	App\Controller\PageController->pageAction (line 181)
8	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
9	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
10	Symfony\Component\HttpKernel\Kernel->handle (line 42)

1.26 ms
(1.32%)

SELECT w0_.link_id AS link_id_0, w0_.url AS url_1, w0_.active AS active_2, w0_.id AS id_3, w0_.sort AS sort_4, w0_.parent AS parent_5, w0_.module_id AS module_id_6, w0_.img_file_id AS img_file_id_7 FROM web_menu w0_ INNER JOIN web_menu_to_group w2_ ON w0_.id = w2_.menu_item_id INNER JOIN web_menu_group w1_ ON w1_.id = w2_.menu_group_id WHERE w1_.id = 1 AND w0_.active = 1 ORDER BY w0_.sort ASC

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  w0_.link_id AS link_id_0,
  w0_.url AS url_1,
  w0_.active AS active_2,
  w0_.id AS id_3,
  w0_.sort AS sort_4,
  w0_.parent AS parent_5,
  w0_.module_id AS module_id_6,
  w0_.img_file_id AS img_file_id_7
FROM
  web_menu w0_
  INNER JOIN web_menu_to_group w2_ ON w0_.id = w2_.menu_item_id
  INNER JOIN web_menu_group w1_ ON w1_.id = w2_.menu_group_id
WHERE
  w1_.id = 1
  AND w0_.active = 1
ORDER BY
  w0_.sort ASC

SELECT w0_.link_id AS link_id_0, w0_.url AS url_1, w0_.active AS active_2, w0_.id AS id_3, w0_.sort AS sort_4, w0_.parent AS parent_5, w0_.module_id AS module_id_6, w0_.img_file_id AS img_file_id_7 FROM web_menu w0_ INNER JOIN web_menu_to_group w2_ ON w0_.id = w2_.menu_item_id INNER JOIN web_menu_group w1_ ON w1_.id = w2_.menu_group_id WHERE w1_.id = 1 AND w0_.active = 1 ORDER BY w0_.sort ASC;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 31)
2	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 330)
3	Doctrine\ORM\Query->_doExecute (line 1218)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 1172)
5	Doctrine\ORM\AbstractQuery->execute (line 907)
6	Doctrine\ORM\AbstractQuery->getResult (line 24)
7	NexCRM\WebBundle\Repository\MenuRepository->findByGroupOrdered (line 85)
8	App\Controller\BaseController->initialize (line 39)
9	App\Controller\PageController->pageAction (line 181)
10	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
11	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
12	Symfony\Component\HttpKernel\Kernel->handle (line 42)

1.14 ms
(1.20%)

SELECT t0.name AS name_1, t0.text AS text_2, t0.price AS price_3, t0.id AS id_4, t0.locale AS locale_5, t0.translatable_id AS translatable_id_6 FROM voucher_types_translation t0 WHERE t0.translatable_id = ?

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.name AS name_1,
  t0.text AS text_2,
  t0.price AS price_3,
  t0.id AS id_4,
  t0.locale AS locale_5,
  t0.translatable_id AS translatable_id_6
FROM
  voucher_types_translation t0
WHERE
  t0.translatable_id = ?

SELECT t0.name AS name_1, t0.text AS text_2, t0.price AS price_3, t0.id AS id_4, t0.locale AS locale_5, t0.translatable_id AS translatable_id_6 FROM voucher_types_translation t0 WHERE t0.translatable_id = 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 1920)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getOneToManyStatement (line 1861)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToManyCollection (line 3301)
4	Doctrine\ORM\UnitOfWork->loadCollection (line 706)
5	Doctrine\ORM\PersistentCollection->doInitialize (line 218)
6	Doctrine\ORM\PersistentCollection->initialize (line 118)
7	Doctrine\Common\Collections\AbstractLazyCollection->get (line 445)
8	Doctrine\ORM\PersistentCollection->get (line 190)
9	App\Entity\VoucherTypes->findTranslationByLocale (line 49)
10	App\Entity\VoucherTypes->__toString (line 59)
11	Symfony\Bridge\Doctrine\Form\Type\DoctrineType::createChoiceLabel (line 162)
12	Symfony\Component\Form\ChoiceList\Factory\DefaultChoiceListFactory::addChoiceView (line 237)
13	Symfony\Component\Form\ChoiceList\Factory\DefaultChoiceListFactory::addChoiceViewsFromStructuredValues (line 127)
14	Symfony\Component\Form\ChoiceList\Factory\DefaultChoiceListFactory->createView (line 182)
15	Symfony\Component\Form\ChoiceList\Factory\PropertyAccessDecorator->createView (line 208)
16	Symfony\Component\Form\ChoiceList\Factory\CachingFactoryDecorator->createView (line 465)
17	Symfony\Component\Form\Extension\Core\Type\ChoiceType->createChoiceListView (line 238)
18	Symfony\Component\Form\Extension\Core\Type\ChoiceType->buildView (line 116)
19	Symfony\Component\Form\ResolvedFormType->buildView (line 87)
20	Symfony\Component\Form\Extension\DataCollector\Proxy\ResolvedTypeDataCollectorProxy->buildView (line 114)
21	Symfony\Component\Form\ResolvedFormType->buildView (line 87)
22	Symfony\Component\Form\Extension\DataCollector\Proxy\ResolvedTypeDataCollectorProxy->buildView (line 900)
23	Symfony\Component\Form\Form->createView (line 903)
24	Symfony\Component\Form\Form->createView (line 106)
25	App\Controller\BaseController->initialize (line 39)
26	App\Controller\PageController->pageAction (line 181)
27	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
28	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
29	Symfony\Component\HttpKernel\Kernel->handle (line 42)

0.89 ms
(0.94%)

SELECT t0.sort AS sort_1, t0.id AS id_2, t0.template_id AS template_id_3 FROM web_content t0 INNER JOIN page_content ON t0.id = page_content.content_id WHERE page_content.entity_id = ?

Parameters:

[
  34
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.sort AS sort_1,
  t0.id AS id_2,
  t0.template_id AS template_id_3
FROM
  web_content t0
  INNER JOIN page_content ON t0.id = page_content.content_id
WHERE
  page_content.entity_id = ?

SELECT t0.sort AS sort_1, t0.id AS id_2, t0.template_id AS template_id_3 FROM web_content t0 INNER JOIN page_content ON t0.id = page_content.content_id WHERE page_content.entity_id = 34;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 1120)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getManyToManyStatement (line 1042)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadManyToManyCollection (line 3305)
4	Doctrine\ORM\UnitOfWork->loadCollection (line 706)
5	Doctrine\ORM\PersistentCollection->doInitialize (line 218)
6	Doctrine\ORM\PersistentCollection->initialize (line 313)
7	Doctrine\Common\Collections\AbstractLazyCollection->getIterator (line 157)
8	NexCRM\WebBundle\Entity\Page->getContents (line 1882)
9	Twig\Extension\CoreExtension::getAttribute (line 88)
10	__TwigTemplate_d6f5a974ffe022dc7665f15ebee20594->block_content (line 432)
11	Twig\Template->yieldBlock (line 197)
12	__TwigTemplate_a7a9180b403871f90ae957b92a2e9794->doDisplay (line 388)
13	Twig\Template->yield (line 54)
14	__TwigTemplate_e725e9007ecc96bfefee296aad70013f->doDisplay (line 388)
15	Twig\Template->yield (line 54)
16	__TwigTemplate_d6f5a974ffe022dc7665f15ebee20594->doDisplay (line 388)
17	Twig\Template->yield (line 344)
18	Twig\Template->display (line 359)
19	Twig\Template->render (line 51)
20	Twig\TemplateWrapper->render (line 334)
21	Twig\Environment->render (line 448)
22	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 453)
23	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 253)
24	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 66)
25	App\Controller\BaseController->render (line 63)
26	App\Controller\PageController->pageAction (line 181)
27	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
28	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
29	Symfony\Component\HttpKernel\Kernel->handle (line 42)

0.77 ms
(0.81%)

SELECT t0.homepage AS homepage_1, t0.doc_files_order AS doc_files_order_2, t0.id AS id_3, t0.sort AS sort_4, t0.img_files_order AS img_files_order_5, t0.dms_img_updated AS dms_img_updated_6, t0.parent AS parent_7, t0.seo_id AS seo_id_8, t0.template_id AS template_id_9, t0.img_file_id AS img_file_id_10, t0.doc_file_id AS doc_file_id_11 FROM web_page t0

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.homepage AS homepage_1,
  t0.doc_files_order AS doc_files_order_2,
  t0.id AS id_3,
  t0.sort AS sort_4,
  t0.img_files_order AS img_files_order_5,
  t0.dms_img_updated AS dms_img_updated_6,
  t0.parent AS parent_7,
  t0.seo_id AS seo_id_8,
  t0.template_id AS template_id_9,
  t0.img_file_id AS img_file_id_10,
  t0.doc_file_id AS doc_file_id_11
FROM
  web_page t0

SELECT t0.homepage AS homepage_1, t0.doc_files_order AS doc_files_order_2, t0.id AS id_3, t0.sort AS sort_4, t0.img_files_order AS img_files_order_5, t0.dms_img_updated AS dms_img_updated_6, t0.parent AS parent_7, t0.seo_id AS seo_id_8, t0.template_id AS template_id_9, t0.img_file_id AS img_file_id_10, t0.doc_file_id AS doc_file_id_11 FROM web_page t0;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 972)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 224)
3	Doctrine\ORM\EntityRepository->findBy (line 206)
4	Doctrine\ORM\EntityRepository->findAll (line 86)
5	App\Controller\BaseController->initialize (line 39)
6	App\Controller\PageController->pageAction (line 181)
7	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
8	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
9	Symfony\Component\HttpKernel\Kernel->handle (line 42)

0.72 ms
(0.76%)

SELECT t0.active AS active_1, t0.id AS id_2, t0.sort AS sort_3, t0.img_file_id AS img_file_id_4 FROM activity t0 WHERE t0.active = ? ORDER BY t0.sort ASC

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.active AS active_1,
  t0.id AS id_2,
  t0.sort AS sort_3,
  t0.img_file_id AS img_file_id_4
FROM
  activity t0
WHERE
  t0.active = ?
ORDER BY
  t0.sort ASC

SELECT t0.active AS active_1, t0.id AS id_2, t0.sort AS sort_3, t0.img_file_id AS img_file_id_4 FROM activity t0 WHERE t0.active = 1 ORDER BY t0.sort ASC;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 972)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 224)
3	Doctrine\ORM\EntityRepository->findBy (line 94)
4	App\Controller\BaseController->initialize (line 39)
5	App\Controller\PageController->pageAction (line 181)
6	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
7	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
8	Symfony\Component\HttpKernel\Kernel->handle (line 42)

0.72 ms
(0.76%)

SELECT t0.published AS published_1, t0.expired AS expired_2, t0.doc_files_order AS doc_files_order_3, t0.id AS id_4, t0.sort AS sort_5, t0.img_files_order AS img_files_order_6, t0.dms_img_updated AS dms_img_updated_7, t0.author_id AS author_id_8, t0.seo_id AS seo_id_9, t0.img_file_id AS img_file_id_10, t0.doc_file_id AS doc_file_id_11 FROM web_news t0 ORDER BY t0.sort ASC

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.published AS published_1,
  t0.expired AS expired_2,
  t0.doc_files_order AS doc_files_order_3,
  t0.id AS id_4,
  t0.sort AS sort_5,
  t0.img_files_order AS img_files_order_6,
  t0.dms_img_updated AS dms_img_updated_7,
  t0.author_id AS author_id_8,
  t0.seo_id AS seo_id_9,
  t0.img_file_id AS img_file_id_10,
  t0.doc_file_id AS doc_file_id_11
FROM
  web_news t0
ORDER BY
  t0.sort ASC

SELECT t0.published AS published_1, t0.expired AS expired_2, t0.doc_files_order AS doc_files_order_3, t0.id AS id_4, t0.sort AS sort_5, t0.img_files_order AS img_files_order_6, t0.dms_img_updated AS dms_img_updated_7, t0.author_id AS author_id_8, t0.seo_id AS seo_id_9, t0.img_file_id AS img_file_id_10, t0.doc_file_id AS doc_file_id_11 FROM web_news t0 ORDER BY t0.sort ASC;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 972)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 224)
3	Doctrine\ORM\EntityRepository->findBy (line 92)
4	App\Controller\BaseController->initialize (line 39)
5	App\Controller\PageController->pageAction (line 181)
6	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
7	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
8	Symfony\Component\HttpKernel\Kernel->handle (line 42)

0.71 ms
(0.75%)

SELECT t0.active AS active_1, t0.id AS id_2, t0.sort AS sort_3, t0.food_category_id AS food_category_id_4 FROM food t0 WHERE t0.active = ? ORDER BY t0.sort ASC

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.active AS active_1,
  t0.id AS id_2,
  t0.sort AS sort_3,
  t0.food_category_id AS food_category_id_4
FROM
  food t0
WHERE
  t0.active = ?
ORDER BY
  t0.sort ASC

SELECT t0.active AS active_1, t0.id AS id_2, t0.sort AS sort_3, t0.food_category_id AS food_category_id_4 FROM food t0 WHERE t0.active = 1 ORDER BY t0.sort ASC;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 972)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 224)
3	Doctrine\ORM\EntityRepository->findBy (line 96)
4	App\Controller\BaseController->initialize (line 39)
5	App\Controller\PageController->pageAction (line 181)
6	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
7	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
8	Symfony\Component\HttpKernel\Kernel->handle (line 42)

0.71 ms
(0.74%)

SELECT t0.count AS count_1, t0.active AS active_2, t0.room_id AS room_id_3, t0.id AS id_4, t0.sort AS sort_5, t0.img_files_order AS img_files_order_6, t0.dms_img_updated AS dms_img_updated_7, t0.img_file_id AS img_file_id_8 FROM room t0 WHERE t0.active = ? ORDER BY t0.sort ASC

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.count AS count_1,
  t0.active AS active_2,
  t0.room_id AS room_id_3,
  t0.id AS id_4,
  t0.sort AS sort_5,
  t0.img_files_order AS img_files_order_6,
  t0.dms_img_updated AS dms_img_updated_7,
  t0.img_file_id AS img_file_id_8
FROM
  room t0
WHERE
  t0.active = ?
ORDER BY
  t0.sort ASC

SELECT t0.count AS count_1, t0.active AS active_2, t0.room_id AS room_id_3, t0.id AS id_4, t0.sort AS sort_5, t0.img_files_order AS img_files_order_6, t0.dms_img_updated AS dms_img_updated_7, t0.img_file_id AS img_file_id_8 FROM room t0 WHERE t0.active = 1 ORDER BY t0.sort ASC;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 972)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 224)
3	Doctrine\ORM\EntityRepository->findBy (line 95)
4	App\Controller\BaseController->initialize (line 39)
5	App\Controller\PageController->pageAction (line 181)
6	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
7	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
8	Symfony\Component\HttpKernel\Kernel->handle (line 42)

0.66 ms
(0.69%)

SELECT t0.active AS active_1, t0.nights AS nights_2, t0.id AS id_3, t0.sort AS sort_4, t0.room_id AS room_id_5, t0.img_file_id AS img_file_id_6 FROM voucher_types t0 WHERE t0.active = ? ORDER BY t0.sort ASC

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.active AS active_1,
  t0.nights AS nights_2,
  t0.id AS id_3,
  t0.sort AS sort_4,
  t0.room_id AS room_id_5,
  t0.img_file_id AS img_file_id_6
FROM
  voucher_types t0
WHERE
  t0.active = ?
ORDER BY
  t0.sort ASC

SELECT t0.active AS active_1, t0.nights AS nights_2, t0.id AS id_3, t0.sort AS sort_4, t0.room_id AS room_id_5, t0.img_file_id AS img_file_id_6 FROM voucher_types t0 WHERE t0.active = 1 ORDER BY t0.sort ASC;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 972)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 224)
3	Doctrine\ORM\EntityRepository->findBy (line 53)
4	App\Form\VoucherFormType->buildForm (line 102)
5	Symfony\Component\Form\ResolvedFormType->buildForm (line 79)
6	Symfony\Component\Form\Extension\DataCollector\Proxy\ResolvedTypeDataCollectorProxy->buildForm (line 58)
7	Symfony\Component\Form\FormFactory->createNamedBuilder (line 43)
8	Symfony\Component\Form\FormFactory->createBuilder (line 28)
9	Symfony\Component\Form\FormFactory->create (line 340)
10	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->createForm (line 100)
11	App\Controller\BaseController->initialize (line 39)
12	App\Controller\PageController->pageAction (line 181)
13	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
14	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
15	Symfony\Component\HttpKernel\Kernel->handle (line 42)

0.63 ms
(0.66%)

SELECT t0.active AS active_1, t0.id AS id_2, t0.sort AS sort_3, t0.img_file_id AS img_file_id_4 FROM icon t0

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.active AS active_1,
  t0.id AS id_2,
  t0.sort AS sort_3,
  t0.img_file_id AS img_file_id_4
FROM
  icon t0

SELECT t0.active AS active_1, t0.id AS id_2, t0.sort AS sort_3, t0.img_file_id AS img_file_id_4 FROM icon t0;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 972)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 224)
3	Doctrine\ORM\EntityRepository->findBy (line 206)
4	Doctrine\ORM\EntityRepository->findAll (line 90)
5	App\Controller\BaseController->initialize (line 39)
6	App\Controller\PageController->pageAction (line 181)
7	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
8	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
9	Symfony\Component\HttpKernel\Kernel->handle (line 42)

0.62 ms
(0.65%)

SELECT t0.name AS name_1, t0.iso_2 AS iso_2_2, t0.iso_3 AS iso_3_3, t0.default_lang AS default_lang_4, t0.active AS active_5, t0.id AS id_6, t0.country AS country_7 FROM lang t0 WHERE t0.default_lang = ? LIMIT 1

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.name AS name_1,
  t0.iso_2 AS iso_2_2,
  t0.iso_3 AS iso_3_3,
  t0.default_lang AS default_lang_4,
  t0.active AS active_5,
  t0.id AS id_6,
  t0.country AS country_7
FROM
  lang t0
WHERE
  t0.default_lang = ?
LIMIT
  1

SELECT t0.name AS name_1, t0.iso_2 AS iso_2_2, t0.iso_3 AS iso_3_3, t0.default_lang AS default_lang_4, t0.active AS active_5, t0.id AS id_6, t0.country AS country_7 FROM lang t0 WHERE t0.default_lang = 1 LIMIT 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 779)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 240)
3	Doctrine\ORM\EntityRepository->findOneBy (line 31)
4	NexCRM\BaseBundle\EventListener\LocaleListener->onKernelRequest (line 116)
5	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 220)
6	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
7	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 139)
8	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 157)
9	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
10	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
11	Symfony\Component\HttpKernel\Kernel->handle (line 42)

0.61 ms
(0.64%)

SELECT t0.active AS active_1, t0.id AS id_2, t0.sort AS sort_3 FROM food_category t0 WHERE t0.active = ? ORDER BY t0.sort ASC

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.active AS active_1,
  t0.id AS id_2,
  t0.sort AS sort_3
FROM
  food_category t0
WHERE
  t0.active = ?
ORDER BY
  t0.sort ASC

SELECT t0.active AS active_1, t0.id AS id_2, t0.sort AS sort_3 FROM food_category t0 WHERE t0.active = 1 ORDER BY t0.sort ASC;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 972)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 224)
3	Doctrine\ORM\EntityRepository->findBy (line 97)
4	App\Controller\BaseController->initialize (line 39)
5	App\Controller\PageController->pageAction (line 181)
6	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
7	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
8	Symfony\Component\HttpKernel\Kernel->handle (line 42)

0.60 ms
(0.64%)

SELECT t0.code AS code_1, t0.active AS active_2, t0.id AS id_3, t0.sort AS sort_4 FROM video t0

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.code AS code_1,
  t0.active AS active_2,
  t0.id AS id_3,
  t0.sort AS sort_4
FROM
  video t0

SELECT t0.code AS code_1, t0.active AS active_2, t0.id AS id_3, t0.sort AS sort_4 FROM video t0;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 972)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 224)
3	Doctrine\ORM\EntityRepository->findBy (line 206)
4	Doctrine\ORM\EntityRepository->findAll (line 91)
5	App\Controller\BaseController->initialize (line 39)
6	App\Controller\PageController->pageAction (line 181)
7	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
8	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
9	Symfony\Component\HttpKernel\Kernel->handle (line 42)

0.59 ms
(0.62%)

SELECT t0.email AS email_1, t0.phone AS phone_2, t0.active AS active_3, t0.id AS id_4, t0.sort AS sort_5, t0.img_file_id AS img_file_id_6 FROM contact_person t0 WHERE t0.active = ? ORDER BY t0.sort ASC

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.email AS email_1,
  t0.phone AS phone_2,
  t0.active AS active_3,
  t0.id AS id_4,
  t0.sort AS sort_5,
  t0.img_file_id AS img_file_id_6
FROM
  contact_person t0
WHERE
  t0.active = ?
ORDER BY
  t0.sort ASC

SELECT t0.email AS email_1, t0.phone AS phone_2, t0.active AS active_3, t0.id AS id_4, t0.sort AS sort_5, t0.img_file_id AS img_file_id_6 FROM contact_person t0 WHERE t0.active = 1 ORDER BY t0.sort ASC;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 972)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 224)
3	Doctrine\ORM\EntityRepository->findBy (line 89)
4	App\Controller\BaseController->initialize (line 39)
5	App\Controller\PageController->pageAction (line 181)
6	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
7	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
8	Symfony\Component\HttpKernel\Kernel->handle (line 42)

0.58 ms
(0.61%)

SELECT t0.id AS id_1, t0.sort AS sort_2, t0.seo_id AS seo_id_3 FROM web_tag t0

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.sort AS sort_2,
  t0.seo_id AS seo_id_3
FROM
  web_tag t0

SELECT t0.id AS id_1, t0.sort AS sort_2, t0.seo_id AS seo_id_3 FROM web_tag t0;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 972)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 224)
3	Doctrine\ORM\EntityRepository->findBy (line 206)
4	Doctrine\ORM\EntityRepository->findAll (line 93)
5	App\Controller\BaseController->initialize (line 39)
6	App\Controller\PageController->pageAction (line 181)
7	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
8	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
9	Symfony\Component\HttpKernel\Kernel->handle (line 42)

0.57 ms
(0.60%)

SELECT t0.name AS name_1, t0.title AS title_2, t0.short_text AS short_text_3, t0.text AS text_4, t0.id AS id_5, t0.locale AS locale_6, t0.translatable_id AS translatable_id_7 FROM web_page_translation t0 WHERE t0.translatable_id = ?

Parameters:

[
  34
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.name AS name_1,
  t0.title AS title_2,
  t0.short_text AS short_text_3,
  t0.text AS text_4,
  t0.id AS id_5,
  t0.locale AS locale_6,
  t0.translatable_id AS translatable_id_7
FROM
  web_page_translation t0
WHERE
  t0.translatable_id = ?

SELECT t0.name AS name_1, t0.title AS title_2, t0.short_text AS short_text_3, t0.text AS text_4, t0.id AS id_5, t0.locale AS locale_6, t0.translatable_id AS translatable_id_7 FROM web_page_translation t0 WHERE t0.translatable_id = 34;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 1920)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getOneToManyStatement (line 1861)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToManyCollection (line 3301)
4	Doctrine\ORM\UnitOfWork->loadCollection (line 706)
5	Doctrine\ORM\PersistentCollection->doInitialize (line 218)
6	Doctrine\ORM\PersistentCollection->initialize (line 118)
7	Doctrine\Common\Collections\AbstractLazyCollection->get (line 445)
8	Doctrine\ORM\PersistentCollection->get (line 190)
9	NexCRM\WebBundle\Entity\Page->findTranslationByLocale (line 93)
10	NexCRM\WebBundle\Entity\Page->__toString (line 36)
11	NexCRM\WebBundle\Service\MetaTagsService->getMetaTags (line 66)
12	App\Controller\PageController->pageAction (line 181)
13	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
14	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
15	Symfony\Component\HttpKernel\Kernel->handle (line 42)

0.56 ms
(0.59%)

SELECT t0.entity AS entity_1, t0.controller AS controller_2, t0.bundle AS bundle_3, t0.action AS action_4, t0.id AS id_5 FROM web_module t0 WHERE t0.id = ?

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.entity AS entity_1,
  t0.controller AS controller_2,
  t0.bundle AS bundle_3,
  t0.action AS action_4,
  t0.id AS id_5
FROM
  web_module t0
WHERE
  t0.id = ?

SELECT t0.entity AS entity_1, t0.controller AS controller_2, t0.bundle AS bundle_3, t0.action AS action_4, t0.id AS id_5 FROM web_module t0 WHERE t0.id = 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 779)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 797)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 333)
4	Doctrine\ORM\Proxy\ProxyFactory->{closure:Doctrine\ORM\Proxy\ProxyFactory::createInitializer():305} (line 197)
5	Closure->__invoke (line 197)
6	Proxies\__CG__\NexCRM\WebBundle\Entity\Module->getEntity (line 30)
7	NexCRM\WebBundle\Repository\MenuRepository->findByGroupOrdered (line 85)
8	App\Controller\BaseController->initialize (line 39)
9	App\Controller\PageController->pageAction (line 181)
10	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
11	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
12	Symfony\Component\HttpKernel\Kernel->handle (line 42)

0.56 ms
(0.59%)

SELECT t0.name AS name_1, t0.id AS id_2 FROM web_menu_group t0

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.name AS name_1,
  t0.id AS id_2
FROM
  web_menu_group t0

SELECT t0.name AS name_1, t0.id AS id_2 FROM web_menu_group t0;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 972)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 224)
3	Doctrine\ORM\EntityRepository->findBy (line 16)
4	NexCRM\WebBundle\Repository\MenuRepository->findByGroupOrdered (line 85)
5	App\Controller\BaseController->initialize (line 39)
6	App\Controller\PageController->pageAction (line 181)
7	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
8	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
9	Symfony\Component\HttpKernel\Kernel->handle (line 42)

0.54 ms
(0.56%)

SELECT t0.name AS name_1, t0.iso_2 AS iso_2_2, t0.iso_3 AS iso_3_3, t0.default_lang AS default_lang_4, t0.active AS active_5, t0.id AS id_6, t0.country AS country_7 FROM lang t0 WHERE t0.iso_2 = ? LIMIT 1

Parameters:

[
  "cs"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.name AS name_1,
  t0.iso_2 AS iso_2_2,
  t0.iso_3 AS iso_3_3,
  t0.default_lang AS default_lang_4,
  t0.active AS active_5,
  t0.id AS id_6,
  t0.country AS country_7
FROM
  lang t0
WHERE
  t0.iso_2 = ?
LIMIT
  1

SELECT t0.name AS name_1, t0.iso_2 AS iso_2_2, t0.iso_3 AS iso_3_3, t0.default_lang AS default_lang_4, t0.active AS active_5, t0.id AS id_6, t0.country AS country_7 FROM lang t0 WHERE t0.iso_2 = 'cs' LIMIT 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 779)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 240)
3	Doctrine\ORM\EntityRepository->findOneBy (line 45)
4	NexCRM\BaseBundle\EventListener\LocaleListener->onKernelRequest (line 116)
5	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 220)
6	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
7	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 139)
8	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 157)
9	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
10	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
11	Symfony\Component\HttpKernel\Kernel->handle (line 42)

0.49 ms
(0.51%)

SELECT t0.name AS name_1, t0.field0 AS field0_2, t0.field1 AS field1_3, t0.field2 AS field2_4, t0.field3 AS field3_5, t0.field4 AS field4_6, t0.field5 AS field5_7, t0.field6 AS field6_8, t0.field7 AS field7_9, t0.field8 AS field8_10, t0.field9 AS field9_11, t0.id AS id_12, t0.locale AS locale_13, t0.translatable_id AS translatable_id_14 FROM web_content_translation t0 WHERE t0.translatable_id = ?

Parameters:

[
  119
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.name AS name_1,
  t0.field0 AS field0_2,
  t0.field1 AS field1_3,
  t0.field2 AS field2_4,
  t0.field3 AS field3_5,
  t0.field4 AS field4_6,
  t0.field5 AS field5_7,
  t0.field6 AS field6_8,
  t0.field7 AS field7_9,
  t0.field8 AS field8_10,
  t0.field9 AS field9_11,
  t0.id AS id_12,
  t0.locale AS locale_13,
  t0.translatable_id AS translatable_id_14
FROM
  web_content_translation t0
WHERE
  t0.translatable_id = ?

SELECT t0.name AS name_1, t0.field0 AS field0_2, t0.field1 AS field1_3, t0.field2 AS field2_4, t0.field3 AS field3_5, t0.field4 AS field4_6, t0.field5 AS field5_7, t0.field6 AS field6_8, t0.field7 AS field7_9, t0.field8 AS field8_10, t0.field9 AS field9_11, t0.id AS id_12, t0.locale AS locale_13, t0.translatable_id AS translatable_id_14 FROM web_content_translation t0 WHERE t0.translatable_id = 119;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 1920)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getOneToManyStatement (line 1861)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToManyCollection (line 3301)
4	Doctrine\ORM\UnitOfWork->loadCollection (line 706)
5	Doctrine\ORM\PersistentCollection->doInitialize (line 218)
6	Doctrine\ORM\PersistentCollection->initialize (line 118)
7	Doctrine\Common\Collections\AbstractLazyCollection->get (line 445)
8	Doctrine\ORM\PersistentCollection->get (line 190)
9	NexCRM\WebBundle\Entity\Content->findTranslationByLocale (line 138)
10	NexCRM\WebBundle\Entity\Content->doTranslate (line 75)
11	NexCRM\WebBundle\Entity\Content->translate (line 1882)
12	Twig\Extension\CoreExtension::getAttribute (line 52)
13	__TwigTemplate_de3f54ced177f6b0308dfdd20a588bf0->doDisplay (line 388)
14	Twig\Template->yield (line 109)
15	__TwigTemplate_d6f5a974ffe022dc7665f15ebee20594->block_content (line 432)
16	Twig\Template->yieldBlock (line 197)
17	__TwigTemplate_a7a9180b403871f90ae957b92a2e9794->doDisplay (line 388)
18	Twig\Template->yield (line 54)
19	__TwigTemplate_e725e9007ecc96bfefee296aad70013f->doDisplay (line 388)
20	Twig\Template->yield (line 54)
21	__TwigTemplate_d6f5a974ffe022dc7665f15ebee20594->doDisplay (line 388)
22	Twig\Template->yield (line 344)
23	Twig\Template->display (line 359)
24	Twig\Template->render (line 51)
25	Twig\TemplateWrapper->render (line 334)
26	Twig\Environment->render (line 448)
27	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 453)
28	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 253)
29	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 66)
30	App\Controller\BaseController->render (line 63)
31	App\Controller\PageController->pageAction (line 181)
32	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
33	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
34	Symfony\Component\HttpKernel\Kernel->handle (line 42)

0.47 ms
(0.49%)

SELECT w0_.link_id AS link_id_0, w0_.url AS url_1, w0_.active AS active_2, w0_.id AS id_3, w0_.sort AS sort_4, w0_.parent AS parent_5, w0_.module_id AS module_id_6, w0_.img_file_id AS img_file_id_7 FROM web_menu w0_ INNER JOIN web_menu_to_group w2_ ON w0_.id = w2_.menu_item_id INNER JOIN web_menu_group w1_ ON w1_.id = w2_.menu_group_id WHERE w1_.id = 2 AND w0_.active = 1 ORDER BY w0_.sort ASC

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  w0_.link_id AS link_id_0,
  w0_.url AS url_1,
  w0_.active AS active_2,
  w0_.id AS id_3,
  w0_.sort AS sort_4,
  w0_.parent AS parent_5,
  w0_.module_id AS module_id_6,
  w0_.img_file_id AS img_file_id_7
FROM
  web_menu w0_
  INNER JOIN web_menu_to_group w2_ ON w0_.id = w2_.menu_item_id
  INNER JOIN web_menu_group w1_ ON w1_.id = w2_.menu_group_id
WHERE
  w1_.id = 2
  AND w0_.active = 1
ORDER BY
  w0_.sort ASC

SELECT w0_.link_id AS link_id_0, w0_.url AS url_1, w0_.active AS active_2, w0_.id AS id_3, w0_.sort AS sort_4, w0_.parent AS parent_5, w0_.module_id AS module_id_6, w0_.img_file_id AS img_file_id_7 FROM web_menu w0_ INNER JOIN web_menu_to_group w2_ ON w0_.id = w2_.menu_item_id INNER JOIN web_menu_group w1_ ON w1_.id = w2_.menu_group_id WHERE w1_.id = 2 AND w0_.active = 1 ORDER BY w0_.sort ASC;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 31)
2	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 330)
3	Doctrine\ORM\Query->_doExecute (line 1218)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 1172)
5	Doctrine\ORM\AbstractQuery->execute (line 907)
6	Doctrine\ORM\AbstractQuery->getResult (line 24)
7	NexCRM\WebBundle\Repository\MenuRepository->findByGroupOrdered (line 85)
8	App\Controller\BaseController->initialize (line 39)
9	App\Controller\PageController->pageAction (line 181)
10	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
11	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
12	Symfony\Component\HttpKernel\Kernel->handle (line 42)

0.43 ms
(0.45%)

SELECT t0.date AS date_1, t0.active AS active_2, t0.id AS id_3, t0.sort AS sort_4, t0.img_file_id AS img_file_id_5 FROM reference t0

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.date AS date_1,
  t0.active AS active_2,
  t0.id AS id_3,
  t0.sort AS sort_4,
  t0.img_file_id AS img_file_id_5
FROM
  reference t0

SELECT t0.date AS date_1, t0.active AS active_2, t0.id AS id_3, t0.sort AS sort_4, t0.img_file_id AS img_file_id_5 FROM reference t0;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 972)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 224)
3	Doctrine\ORM\EntityRepository->findBy (line 206)
4	Doctrine\ORM\EntityRepository->findAll (line 88)
5	App\Controller\BaseController->initialize (line 39)
6	App\Controller\PageController->pageAction (line 181)
7	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
8	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
9	Symfony\Component\HttpKernel\Kernel->handle (line 42)

0.41 ms
(0.43%)

SELECT t0.homepage AS homepage_1, t0.doc_files_order AS doc_files_order_2, t0.id AS id_3, t0.sort AS sort_4, t0.img_files_order AS img_files_order_5, t0.dms_img_updated AS dms_img_updated_6, t0.parent AS parent_7, t0.seo_id AS seo_id_8, t0.template_id AS template_id_9, t0.img_file_id AS img_file_id_10, t0.doc_file_id AS doc_file_id_11 FROM web_page t0 WHERE t0.seo_id = ? LIMIT 1

Parameters:

[
  "34"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.homepage AS homepage_1,
  t0.doc_files_order AS doc_files_order_2,
  t0.id AS id_3,
  t0.sort AS sort_4,
  t0.img_files_order AS img_files_order_5,
  t0.dms_img_updated AS dms_img_updated_6,
  t0.parent AS parent_7,
  t0.seo_id AS seo_id_8,
  t0.template_id AS template_id_9,
  t0.img_file_id AS img_file_id_10,
  t0.doc_file_id AS doc_file_id_11
FROM
  web_page t0
WHERE
  t0.seo_id = ?
LIMIT
  1

SELECT t0.homepage AS homepage_1, t0.doc_files_order AS doc_files_order_2, t0.id AS id_3, t0.sort AS sort_4, t0.img_files_order AS img_files_order_5, t0.dms_img_updated AS dms_img_updated_6, t0.parent AS parent_7, t0.seo_id AS seo_id_8, t0.template_id AS template_id_9, t0.img_file_id AS img_file_id_10, t0.doc_file_id AS doc_file_id_11 FROM web_page t0 WHERE t0.seo_id = '34' LIMIT 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 779)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 240)
3	Doctrine\ORM\EntityRepository->findOneBy (line 40)
4	App\Controller\PageController->pageAction (line 181)
5	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
6	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
7	Symfony\Component\HttpKernel\Kernel->handle (line 42)

0.40 ms
(0.42%)

SELECT r0_.count AS count_0, r0_.active AS active_1, r0_.room_id AS room_id_2, r0_.id AS id_3, r0_.sort AS sort_4, r0_.img_files_order AS img_files_order_5, r0_.dms_img_updated AS dms_img_updated_6, r0_.img_file_id AS img_file_id_7 FROM room r0_

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  r0_.count AS count_0,
  r0_.active AS active_1,
  r0_.room_id AS room_id_2,
  r0_.id AS id_3,
  r0_.sort AS sort_4,
  r0_.img_files_order AS img_files_order_5,
  r0_.dms_img_updated AS dms_img_updated_6,
  r0_.img_file_id AS img_file_id_7
FROM
  room r0_

SELECT r0_.count AS count_0, r0_.active AS active_1, r0_.room_id AS room_id_2, r0_.id AS id_3, r0_.sort AS sort_4, r0_.img_files_order AS img_files_order_5, r0_.dms_img_updated AS dms_img_updated_6, r0_.img_file_id AS img_file_id_7 FROM room r0_;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 31)
2	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 330)
3	Doctrine\ORM\Query->_doExecute (line 1218)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 1172)
5	Doctrine\ORM\AbstractQuery->execute (line 36)
6	Symfony\Bridge\Doctrine\Form\ChoiceList\ORMQueryBuilderLoader->getEntities (line 53)
7	Symfony\Bridge\Doctrine\Form\ChoiceList\DoctrineChoiceLoader->loadChoices (line 29)
8	Symfony\Component\Form\ChoiceList\Loader\AbstractChoiceLoader->loadChoiceList (line 56)
9	Symfony\Component\Form\ChoiceList\LazyChoiceList->getChoices (line 64)
10	Symfony\Component\Form\ChoiceList\Factory\DefaultChoiceListFactory->createView (line 182)
11	Symfony\Component\Form\ChoiceList\Factory\PropertyAccessDecorator->createView (line 208)
12	Symfony\Component\Form\ChoiceList\Factory\CachingFactoryDecorator->createView (line 465)
13	Symfony\Component\Form\Extension\Core\Type\ChoiceType->createChoiceListView (line 238)
14	Symfony\Component\Form\Extension\Core\Type\ChoiceType->buildView (line 116)
15	Symfony\Component\Form\ResolvedFormType->buildView (line 87)
16	Symfony\Component\Form\Extension\DataCollector\Proxy\ResolvedTypeDataCollectorProxy->buildView (line 114)
17	Symfony\Component\Form\ResolvedFormType->buildView (line 87)
18	Symfony\Component\Form\Extension\DataCollector\Proxy\ResolvedTypeDataCollectorProxy->buildView (line 900)
19	Symfony\Component\Form\Form->createView (line 903)
20	Symfony\Component\Form\Form->createView (line 160)
21	App\Controller\BaseController->initialize (line 39)
22	App\Controller\PageController->pageAction (line 181)
23	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
24	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
25	Symfony\Component\HttpKernel\Kernel->handle (line 42)

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.

Entities Mapping

Class	Mapping errors
NexCRM\BaseBundle\Entity\Lang	No errors.
NexCRM\BaseBundle\Entity\Country	No errors.
NexCRM\BaseBundle\Entity\Setting	No errors.
NexCRM\BaseBundle\Entity\SettingTranslation	No errors.
NexCRM\WebBundle\Entity\Menu	No errors.
NexCRM\WebBundle\Entity\MenuGroup	No errors.
NexCRM\WebBundle\Entity\MenuGroupTranslation	No errors.
NexCRM\WebBundle\Entity\Module	No errors.
NexCRM\DMSBundle\Entity\File	No errors.
NexCRM\WebBundle\Entity\MenuTranslation	No errors.
NexCRM\WebBundle\Entity\ModuleTranslation	No errors.
NexCRM\WebBundle\Entity\Page	No errors.
NexCRM\WebBundle\Entity\SEO	No errors.
NexCRM\WebBundle\Entity\Template	No errors.
NexCRM\WebBundle\Entity\Content	No errors.
NexCRM\WebBundle\Entity\PageTranslation	No errors.
NexCRM\WebBundle\Entity\SEOTranslation	No errors.
NexCRM\WebBundle\Entity\TemplateTranslation	No errors.
App\Entity\Reference	No errors.
App\Entity\ReferenceTranslation	No errors.
App\Entity\ContactPerson	No errors.
App\Entity\ContactPersonTranslation	No errors.
App\Entity\Icon	No errors.
App\Entity\IconTranslation	No errors.
App\Entity\Video	No errors.
App\Entity\VideoTranslation	No errors.
NexCRM\WebBundle\Entity\News	No errors.
NexCRM\BaseBundle\Entity\User	No errors.
NexCRM\WebBundle\Entity\Tag	No errors.
NexCRM\WebBundle\Entity\NewsTranslation	No errors.
NexCRM\WebBundle\Entity\TagTranslation	No errors.
App\Entity\Activity	No errors.
App\Entity\ActivityTranslation	No errors.
App\Entity\Room	No errors.
App\Entity\Reservation	No errors.
App\Entity\RoomTranslation	No errors.
App\Entity\Food	No errors.
App\Entity\FoodCategory	No errors.
App\Entity\FoodTranslation	No errors.
App\Entity\FoodCategoryTranslation	No errors.
App\Entity\VoucherTypes	The mappings App\Entity\VoucherTypes#vouchers and App\Entity\VoucherOrders#type are inconsistent with each other.
App\Entity\VoucherOrders	The association App\Entity\VoucherOrders#type refers to the inverse side field App\Entity\VoucherTypes#voucher_orders which does not exist.
App\Entity\VoucherTypesTranslation	No errors.
NexCRM\WebBundle\Entity\Code	No errors.
NexCRM\WebBundle\Entity\CodeTranslation	No errors.
NexCRM\BaseBundle\Entity\LangToken	No errors.
NexCRM\DMSBundle\Entity\Folder	No errors.
NexCRM\CompanyBundle\Entity\Company	No errors.
NexCRM\DMSBundle\Entity\Filter	No errors.
NexCRM\DMSBundle\Entity\FileType	No errors.
NexCRM\DMSBundle\Entity\NumericalRoot	No errors.
NexCRM\DMSBundle\Entity\FileParameters	No errors.
NexCRM\DMSBundle\Entity\FileLog	No errors.
NexCRM\DMSBundle\Entity\FileTranslation	No errors.
NexCRM\DMSBundle\Entity\FolderRule	No errors.
NexCRM\WebBundle\Entity\ContentTranslation	No errors.
NexCRM\BaseBundle\Entity\MediaOrderRecord	No errors.

Symfony Profiler

GET https://dev69.nexgen.cz/jidelni-listek

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Entities Mapping