Symfony Profiler

Last 10 Latest Search

Settings

Query Metrics

126 Database Queries

41 Different statements

106.17 ms Query time

0 Invalid entities

Grouped Statements

Show all queries

Time▼

Count

Info

11.95 ms
(11.26%)

SELECT l0_.id AS id_0, l0_.token AS token_1 FROM lang_token l0_

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  l0_.id AS id_0,
  l0_.token AS token_1
FROM
  lang_token l0_

SELECT l0_.id AS id_0, l0_.token AS token_1 FROM lang_token l0_;

#	File/Call
1	Doctrine\DBAL\Logging\LoggerChain->startQuery (line 1294)
2	Doctrine\DBAL\Connection->executeQuery (line 31)
3	Doctrine\ORM\Query\Exec\SingleSelectExecutor->execute (line 325)
4	Doctrine\ORM\Query->_doExecute (line 1212)
5	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 1166)
6	Doctrine\ORM\AbstractQuery->execute (line 901)
7	Doctrine\ORM\AbstractQuery->getResult (line 94)
8	NexCRM\BaseBundle\Service\Translator->checkToken (line 38)
9	NexCRM\BaseBundle\Service\Translator->trans (line 60)
10	App\Service\FilterEstateService->getFilterEstates (line 156)
11	App\Controller\BaseController->initialize (line 19)
12	App\Controller\CategoryController->indexAction (line 163)
13	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 75)
14	Symfony\Component\HttpKernel\HttpKernel->handle (line 202)
15	Symfony\Component\HttpKernel\Kernel->handle (line 42)

8.21 ms
(7.74%)

SELECT t0.homepage AS homepage_1, t0.documents_order AS documents_order_2, t0.doc_files_order AS doc_files_order_3, t0.id AS id_4, t0.sort AS sort_5, t0.files_order AS files_order_6, t0.media_updated AS media_updated_7, t0.img_files_order AS img_files_order_8, t0.parent AS parent_9, t0.seo_id AS seo_id_10, t0.template_id AS template_id_11, t0.page_file_id AS page_file_id_12, t0.file_id AS file_id_13, t0.img_file_id AS img_file_id_14, t0.doc_file_id AS doc_file_id_15 FROM web_page t0 WHERE t0.id = ? LIMIT 1

Parameters:

  0 of 0   
[▼
  4
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.homepage AS homepage_1,
  t0.documents_order AS documents_order_2,
  t0.doc_files_order AS doc_files_order_3,
  t0.id AS id_4,
  t0.sort AS sort_5,
  t0.files_order AS files_order_6,
  t0.media_updated AS media_updated_7,
  t0.img_files_order AS img_files_order_8,
  t0.parent AS parent_9,
  t0.seo_id AS seo_id_10,
  t0.template_id AS template_id_11,
  t0.page_file_id AS page_file_id_12,
  t0.file_id AS file_id_13,
  t0.img_file_id AS img_file_id_14,
  t0.doc_file_id AS doc_file_id_15
FROM
  web_page t0
WHERE
  t0.id = ?
LIMIT
  1

SELECT t0.homepage AS homepage_1, t0.documents_order AS documents_order_2, t0.doc_files_order AS doc_files_order_3, t0.id AS id_4, t0.sort AS sort_5, t0.files_order AS files_order_6, t0.media_updated AS media_updated_7, t0.img_files_order AS img_files_order_8, t0.parent AS parent_9, t0.seo_id AS seo_id_10, t0.template_id AS template_id_11, t0.page_file_id AS page_file_id_12, t0.file_id AS file_id_13, t0.img_file_id AS img_file_id_14, t0.doc_file_id AS doc_file_id_15 FROM web_page t0 WHERE t0.id = 4 LIMIT 1;

#	File/Call
1	Doctrine\DBAL\Logging\LoggerChain->startQuery (line 1294)
2	Doctrine\DBAL\Connection->executeQuery (line 750)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 241)
4	Doctrine\ORM\EntityRepository->findOneBy (line 38)
5	NexCRM\WebBundle\Repository\MenuRepository->findByGroupOrdered (line 132)
6	App\Controller\BaseController->initialize (line 19)
7	App\Controller\CategoryController->indexAction (line 163)
8	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 75)
9	Symfony\Component\HttpKernel\HttpKernel->handle (line 202)
10	Symfony\Component\HttpKernel\Kernel->handle (line 42)

6.23 ms
(5.87%)

SELECT t0.documents_order AS documents_order_1, t0.active AS active_2, t0.color AS color_3, t0.id AS id_4, t0.sort AS sort_5, t0.files_order AS files_order_6, t0.media_updated AS media_updated_7, t0.seo_id AS seo_id_8, t0.tag_file_id AS tag_file_id_9, t0.file_id AS file_id_10 FROM tag t0 INNER JOIN estate_tag ON t0.id = estate_tag.tag_id WHERE estate_tag.estate_id = ?

Parameters:

  0 of 0   
[▼
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.documents_order AS documents_order_1,
  t0.active AS active_2,
  t0.color AS color_3,
  t0.id AS id_4,
  t0.sort AS sort_5,
  t0.files_order AS files_order_6,
  t0.media_updated AS media_updated_7,
  t0.seo_id AS seo_id_8,
  t0.tag_file_id AS tag_file_id_9,
  t0.file_id AS file_id_10
FROM
  tag t0
  INNER JOIN estate_tag ON t0.id = estate_tag.tag_id
WHERE
  estate_tag.estate_id = ?

SELECT t0.documents_order AS documents_order_1, t0.active AS active_2, t0.color AS color_3, t0.id AS id_4, t0.sort AS sort_5, t0.files_order AS files_order_6, t0.media_updated AS media_updated_7, t0.seo_id AS seo_id_8, t0.tag_file_id AS tag_file_id_9, t0.file_id AS file_id_10 FROM tag t0 INNER JOIN estate_tag ON t0.id = estate_tag.tag_id WHERE estate_tag.estate_id = 1;

#	File/Call
1	Doctrine\DBAL\Logging\LoggerChain->startQuery (line 1294)
2	Doctrine\DBAL\Connection->executeQuery (line 1064)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getManyToManyStatement (line 986)
4	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadManyToManyCollection (line 3041)
5	Doctrine\ORM\UnitOfWork->loadCollection (line 698)
6	Doctrine\ORM\PersistentCollection->doInitialize (line 213)
7	Doctrine\ORM\PersistentCollection->initialize (line 38)
8	Doctrine\Common\Collections\AbstractLazyCollection->count (line 452)
9	Doctrine\ORM\PersistentCollection->count (line 1272)
10	twig_test_empty (line 60)
11	__TwigTemplate_174fa8555b9190bdcf222e352a0d083908ff519e9cb429f9b3efe43a06313a07->doDisplay (line 394)
12	Twig\Template->displayWithErrorHandling (line 367)
13	Twig\Template->display (line 61)
14	__TwigTemplate_148ce474357114874ae3815eb8c2ea9f7de2ac87360f883d14d0db50be1eec5f->doDisplay (line 394)
15	Twig\Template->displayWithErrorHandling (line 367)
16	Twig\Template->display (line 69)
17	__TwigTemplate_474bb8e2056b04e51b514c29a16b5e1c037f744361a26b7e1109ad8e51b2fa99->doDisplay (line 394)
18	Twig\Template->displayWithErrorHandling (line 367)
19	Twig\Template->display (line 74)
20	__TwigTemplate_f4c2710d6a0300a0d5e020bf4c9ab946165bcf56185bec2f2ac667f2a4fd8a7f->block_content (line 171)
21	Twig\Template->displayBlock (line 216)
22	__TwigTemplate_8977e40c3ea85b046ee507356db6d413d33959d7f59c852b3e046ef6f470f750->doDisplay (line 394)
23	Twig\Template->displayWithErrorHandling (line 367)
24	Twig\Template->display (line 57)
25	__TwigTemplate_0c1c9c79e3045f62ba0a13788fdba506af56c668b4917774c7305efb4dd0dcd2->doDisplay (line 394)
26	Twig\Template->displayWithErrorHandling (line 367)
27	Twig\Template->display (line 48)
28	__TwigTemplate_f4c2710d6a0300a0d5e020bf4c9ab946165bcf56185bec2f2ac667f2a4fd8a7f->doDisplay (line 394)
29	Twig\Template->displayWithErrorHandling (line 367)
30	Twig\Template->display (line 379)
31	Twig\Template->render (line 40)
32	Twig\TemplateWrapper->render (line 280)
33	Twig\Environment->render (line 258)
34	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->renderView (line 266)
35	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 107)
36	App\Controller\BaseController->render (line 40)
37	App\Controller\CategoryController->indexAction (line 163)
38	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 75)
39	Symfony\Component\HttpKernel\HttpKernel->handle (line 202)
40	Symfony\Component\HttpKernel\Kernel->handle (line 42)

6.22 ms
(5.86%)

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:

  0 of 0   
[▼
  "507e3cb064_6807b540146f39.22973208"
]

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 = '507e3cb064_6807b540146f39.22973208';

#	File/Call
1	Doctrine\DBAL\Logging\LoggerChain->startQuery (line 1294)
2	Doctrine\DBAL\Connection->executeQuery (line 916)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 225)
4	Doctrine\ORM\EntityRepository->findBy (line 30)
5	NexCRM\BaseBundle\EventListener\ResponseListener->onKernelResponse (line 117)
6	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 230)
7	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 59)
8	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 154)
9	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 196)
10	Symfony\Component\HttpKernel\HttpKernel->filterResponse (line 184)
11	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 75)
12	Symfony\Component\HttpKernel\HttpKernel->handle (line 202)
13	Symfony\Component\HttpKernel\Kernel->handle (line 42)

5.63 ms
(5.31%)

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:

  0 of 0   
[▼
  6
]

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

#	File/Call
1	Doctrine\DBAL\Logging\LoggerChain->startQuery (line 1294)
2	Doctrine\DBAL\Connection->executeQuery (line 1863)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getOneToManyStatement (line 1804)
4	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToManyCollection (line 3037)
5	Doctrine\ORM\UnitOfWork->loadCollection (line 698)
6	Doctrine\ORM\PersistentCollection->doInitialize (line 213)
7	Doctrine\ORM\PersistentCollection->initialize (line 119)
8	Doctrine\Common\Collections\AbstractLazyCollection->get (line 441)
9	Doctrine\ORM\PersistentCollection->get (line 193)
10	NexCRM\WebBundle\Entity\Menu->findTranslationByLocale (line 141)
11	NexCRM\WebBundle\Entity\Menu->doTranslate (line 75)
12	NexCRM\WebBundle\Entity\Menu->translate (line 31)
13	NexCRM\WebBundle\Repository\MenuRepository->findByGroupOrdered (line 132)
14	App\Controller\BaseController->initialize (line 19)
15	App\Controller\CategoryController->indexAction (line 163)
16	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 75)
17	Symfony\Component\HttpKernel\HttpKernel->handle (line 202)
18	Symfony\Component\HttpKernel\Kernel->handle (line 42)

5.11 ms
(4.81%)

SELECT t0.documents_order AS documents_order_1, t0.active AS active_2, t0.id AS id_3, t0.sort AS sort_4, t0.files_order AS files_order_5, t0.media_updated AS media_updated_6, t0.seo_id AS seo_id_7, t0.category_file_id AS category_file_id_8, t0.file_id AS file_id_9 FROM category t0 WHERE t0.id = ? LIMIT 1

Parameters:

  0 of 0   
[▼
  2
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.documents_order AS documents_order_1,
  t0.active AS active_2,
  t0.id AS id_3,
  t0.sort AS sort_4,
  t0.files_order AS files_order_5,
  t0.media_updated AS media_updated_6,
  t0.seo_id AS seo_id_7,
  t0.category_file_id AS category_file_id_8,
  t0.file_id AS file_id_9
FROM
  category t0
WHERE
  t0.id = ?
LIMIT
  1

SELECT t0.documents_order AS documents_order_1, t0.active AS active_2, t0.id AS id_3, t0.sort AS sort_4, t0.files_order AS files_order_5, t0.media_updated AS media_updated_6, t0.seo_id AS seo_id_7, t0.category_file_id AS category_file_id_8, t0.file_id AS file_id_9 FROM category t0 WHERE t0.id = 2 LIMIT 1;

#	File/Call
1	Doctrine\DBAL\Logging\LoggerChain->startQuery (line 1294)
2	Doctrine\DBAL\Connection->executeQuery (line 750)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 241)
4	Doctrine\ORM\EntityRepository->findOneBy (line 38)
5	NexCRM\WebBundle\Repository\MenuRepository->findByGroupOrdered (line 132)
6	App\Controller\BaseController->initialize (line 19)
7	App\Controller\CategoryController->indexAction (line 163)
8	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 75)
9	Symfony\Component\HttpKernel\HttpKernel->handle (line 202)
10	Symfony\Component\HttpKernel\Kernel->handle (line 42)

4.86 ms
(4.58%)

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:

  0 of 0   
[▼
  11
]

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

#	File/Call
1	Doctrine\DBAL\Logging\LoggerChain->startQuery (line 1294)
2	Doctrine\DBAL\Connection->executeQuery (line 1863)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getOneToManyStatement (line 1804)
4	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToManyCollection (line 3037)
5	Doctrine\ORM\UnitOfWork->loadCollection (line 698)
6	Doctrine\ORM\PersistentCollection->doInitialize (line 213)
7	Doctrine\ORM\PersistentCollection->initialize (line 119)
8	Doctrine\Common\Collections\AbstractLazyCollection->get (line 441)
9	Doctrine\ORM\PersistentCollection->get (line 193)
10	NexCRM\BaseBundle\Entity\Setting->findTranslationByLocale (line 141)
11	NexCRM\BaseBundle\Entity\Setting->doTranslate (line 75)
12	NexCRM\BaseBundle\Entity\Setting->translate (line 24)
13	NexCRM\WebBundle\Service\MetaTagsService->getMetaTags (line 34)
14	App\Controller\CategoryController->indexAction (line 163)
15	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 75)
16	Symfony\Component\HttpKernel\HttpKernel->handle (line 202)
17	Symfony\Component\HttpKernel\Kernel->handle (line 42)

4.84 ms
(4.56%)

SELECT t0.name AS name_1, t0.seo AS seo_2, t0.alt AS alt_3, t0.media AS media_4, t0.updated_at AS updated_at_5, t0.file_size AS file_size_6, t0.ext AS ext_7, t0.preview AS preview_8, t0.deleted AS deleted_9, t0.deleted_at AS deleted_at_10, t0.id AS id_11, t0.folder_id AS folder_id_12 FROM media_file t0 WHERE t0.id = ?

Parameters:

  0 of 0   
[▼
  783
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.name AS name_1,
  t0.seo AS seo_2,
  t0.alt AS alt_3,
  t0.media AS media_4,
  t0.updated_at AS updated_at_5,
  t0.file_size AS file_size_6,
  t0.ext AS ext_7,
  t0.preview AS preview_8,
  t0.deleted AS deleted_9,
  t0.deleted_at AS deleted_at_10,
  t0.id AS id_11,
  t0.folder_id AS folder_id_12
FROM
  media_file t0
WHERE
  t0.id = ?

SELECT t0.name AS name_1, t0.seo AS seo_2, t0.alt AS alt_3, t0.media AS media_4, t0.updated_at AS updated_at_5, t0.file_size AS file_size_6, t0.ext AS ext_7, t0.preview AS preview_8, t0.deleted AS deleted_9, t0.deleted_at AS deleted_at_10, t0.id AS id_11, t0.folder_id AS folder_id_12 FROM media_file t0 WHERE t0.id = 783;

#	File/Call
1	Doctrine\DBAL\Logging\LoggerChain->startQuery (line 1294)
2	Doctrine\DBAL\Connection->executeQuery (line 750)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 768)
4	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 207)
5	Doctrine\ORM\Proxy\ProxyFactory->Doctrine\ORM\Proxy\{closure} (line 186)
6	Closure->__invoke (line 186)
7	Proxies\__CG__\NexCRM\BaseBundle\Entity\MediaFile->__toString (line 1280)
8	twig_test_empty (line 91)
9	__TwigTemplate_174fa8555b9190bdcf222e352a0d083908ff519e9cb429f9b3efe43a06313a07->doDisplay (line 394)
10	Twig\Template->displayWithErrorHandling (line 367)
11	Twig\Template->display (line 61)
12	__TwigTemplate_148ce474357114874ae3815eb8c2ea9f7de2ac87360f883d14d0db50be1eec5f->doDisplay (line 394)
13	Twig\Template->displayWithErrorHandling (line 367)
14	Twig\Template->display (line 69)
15	__TwigTemplate_474bb8e2056b04e51b514c29a16b5e1c037f744361a26b7e1109ad8e51b2fa99->doDisplay (line 394)
16	Twig\Template->displayWithErrorHandling (line 367)
17	Twig\Template->display (line 74)
18	__TwigTemplate_f4c2710d6a0300a0d5e020bf4c9ab946165bcf56185bec2f2ac667f2a4fd8a7f->block_content (line 171)
19	Twig\Template->displayBlock (line 216)
20	__TwigTemplate_8977e40c3ea85b046ee507356db6d413d33959d7f59c852b3e046ef6f470f750->doDisplay (line 394)
21	Twig\Template->displayWithErrorHandling (line 367)
22	Twig\Template->display (line 57)
23	__TwigTemplate_0c1c9c79e3045f62ba0a13788fdba506af56c668b4917774c7305efb4dd0dcd2->doDisplay (line 394)
24	Twig\Template->displayWithErrorHandling (line 367)
25	Twig\Template->display (line 48)
26	__TwigTemplate_f4c2710d6a0300a0d5e020bf4c9ab946165bcf56185bec2f2ac667f2a4fd8a7f->doDisplay (line 394)
27	Twig\Template->displayWithErrorHandling (line 367)
28	Twig\Template->display (line 379)
29	Twig\Template->render (line 40)
30	Twig\TemplateWrapper->render (line 280)
31	Twig\Environment->render (line 258)
32	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->renderView (line 266)
33	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 107)
34	App\Controller\BaseController->render (line 40)
35	App\Controller\CategoryController->indexAction (line 163)
36	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 75)
37	Symfony\Component\HttpKernel\HttpKernel->handle (line 202)
38	Symfony\Component\HttpKernel\Kernel->handle (line 42)

3.92 ms
(3.69%)

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:

  0 of 0   
[▼
  4
]

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

#	File/Call
1	Doctrine\DBAL\Logging\LoggerChain->startQuery (line 1294)
2	Doctrine\DBAL\Connection->executeQuery (line 1863)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getOneToManyStatement (line 1804)
4	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToManyCollection (line 3037)
5	Doctrine\ORM\UnitOfWork->loadCollection (line 698)
6	Doctrine\ORM\PersistentCollection->doInitialize (line 213)
7	Doctrine\ORM\PersistentCollection->initialize (line 119)
8	Doctrine\Common\Collections\AbstractLazyCollection->get (line 441)
9	Doctrine\ORM\PersistentCollection->get (line 193)
10	NexCRM\WebBundle\Entity\SEO->findTranslationByLocale (line 141)
11	NexCRM\WebBundle\Entity\SEO->doTranslate (line 75)
12	NexCRM\WebBundle\Entity\SEO->translate (line 401)
13	Proxies\__CG__\NexCRM\WebBundle\Entity\SEO->translate (line 40)
14	NexCRM\WebBundle\Repository\MenuRepository->findByGroupOrdered (line 132)
15	App\Controller\BaseController->initialize (line 19)
16	App\Controller\CategoryController->indexAction (line 163)
17	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 75)
18	Symfony\Component\HttpKernel\HttpKernel->handle (line 202)
19	Symfony\Component\HttpKernel\Kernel->handle (line 42)

3.68 ms
(3.46%)

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:

  0 of 0   
[▼
  40
]

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

#	File/Call
1	Doctrine\DBAL\Logging\LoggerChain->startQuery (line 1294)
2	Doctrine\DBAL\Connection->executeQuery (line 750)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 768)
4	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 207)
5	Doctrine\ORM\Proxy\ProxyFactory->Doctrine\ORM\Proxy\{closure} (line 197)
6	Closure->__invoke (line 197)
7	Proxies\__CG__\NexCRM\WebBundle\Entity\Template->getPath (line 13)
8	App\Service\PageTemplateService->getPagetemplate (line 137)
9	App\Controller\BaseController->initialize (line 19)
10	App\Controller\CategoryController->indexAction (line 163)
11	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 75)
12	Symfony\Component\HttpKernel\HttpKernel->handle (line 202)
13	Symfony\Component\HttpKernel\Kernel->handle (line 42)

3.59 ms
(3.38%)

SELECT t0.email AS email_1, t0.phone AS phone_2, t0.documents_order AS documents_order_3, t0.active AS active_4, t0.id AS id_5, t0.sort AS sort_6, t0.files_order AS files_order_7, t0.media_updated AS media_updated_8, t0.seo_id AS seo_id_9, t0.agent_file_id AS agent_file_id_10, t0.file_id AS file_id_11 FROM agent t0 ORDER BY t0.sort ASC

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.email AS email_1,
  t0.phone AS phone_2,
  t0.documents_order AS documents_order_3,
  t0.active AS active_4,
  t0.id AS id_5,
  t0.sort AS sort_6,
  t0.files_order AS files_order_7,
  t0.media_updated AS media_updated_8,
  t0.seo_id AS seo_id_9,
  t0.agent_file_id AS agent_file_id_10,
  t0.file_id AS file_id_11
FROM
  agent t0
ORDER BY
  t0.sort ASC

SELECT t0.email AS email_1, t0.phone AS phone_2, t0.documents_order AS documents_order_3, t0.active AS active_4, t0.id AS id_5, t0.sort AS sort_6, t0.files_order AS files_order_7, t0.media_updated AS media_updated_8, t0.seo_id AS seo_id_9, t0.agent_file_id AS agent_file_id_10, t0.file_id AS file_id_11 FROM agent t0 ORDER BY t0.sort ASC;

#	File/Call
1	Doctrine\DBAL\Logging\LoggerChain->startQuery (line 1294)
2	Doctrine\DBAL\Connection->executeQuery (line 916)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 225)
4	Doctrine\ORM\EntityRepository->findBy (line 143)
5	App\Controller\BaseController->initialize (line 19)
6	App\Controller\CategoryController->indexAction (line 163)
7	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 75)
8	Symfony\Component\HttpKernel\HttpKernel->handle (line 202)
9	Symfony\Component\HttpKernel\Kernel->handle (line 42)

3.05 ms
(2.87%)

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

Parameters:

  0 of 0   
[▼
  2
]

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
  tag_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 tag_translation t0 WHERE t0.translatable_id = 2;

#	File/Call
1	Doctrine\DBAL\Logging\LoggerChain->startQuery (line 1294)
2	Doctrine\DBAL\Connection->executeQuery (line 1863)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getOneToManyStatement (line 1804)
4	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToManyCollection (line 3037)
5	Doctrine\ORM\UnitOfWork->loadCollection (line 698)
6	Doctrine\ORM\PersistentCollection->doInitialize (line 213)
7	Doctrine\ORM\PersistentCollection->initialize (line 119)
8	Doctrine\Common\Collections\AbstractLazyCollection->get (line 441)
9	Doctrine\ORM\PersistentCollection->get (line 193)
10	App\Entity\Tag->findTranslationByLocale (line 141)
11	App\Entity\Tag->doTranslate (line 75)
12	App\Entity\Tag->translate (line 1635)
13	twig_get_attribute (line 77)
14	__TwigTemplate_174fa8555b9190bdcf222e352a0d083908ff519e9cb429f9b3efe43a06313a07->doDisplay (line 394)
15	Twig\Template->displayWithErrorHandling (line 367)
16	Twig\Template->display (line 61)
17	__TwigTemplate_148ce474357114874ae3815eb8c2ea9f7de2ac87360f883d14d0db50be1eec5f->doDisplay (line 394)
18	Twig\Template->displayWithErrorHandling (line 367)
19	Twig\Template->display (line 69)
20	__TwigTemplate_474bb8e2056b04e51b514c29a16b5e1c037f744361a26b7e1109ad8e51b2fa99->doDisplay (line 394)
21	Twig\Template->displayWithErrorHandling (line 367)
22	Twig\Template->display (line 74)
23	__TwigTemplate_f4c2710d6a0300a0d5e020bf4c9ab946165bcf56185bec2f2ac667f2a4fd8a7f->block_content (line 171)
24	Twig\Template->displayBlock (line 216)
25	__TwigTemplate_8977e40c3ea85b046ee507356db6d413d33959d7f59c852b3e046ef6f470f750->doDisplay (line 394)
26	Twig\Template->displayWithErrorHandling (line 367)
27	Twig\Template->display (line 57)
28	__TwigTemplate_0c1c9c79e3045f62ba0a13788fdba506af56c668b4917774c7305efb4dd0dcd2->doDisplay (line 394)
29	Twig\Template->displayWithErrorHandling (line 367)
30	Twig\Template->display (line 48)
31	__TwigTemplate_f4c2710d6a0300a0d5e020bf4c9ab946165bcf56185bec2f2ac667f2a4fd8a7f->doDisplay (line 394)
32	Twig\Template->displayWithErrorHandling (line 367)
33	Twig\Template->display (line 379)
34	Twig\Template->render (line 40)
35	Twig\TemplateWrapper->render (line 280)
36	Twig\Environment->render (line 258)
37	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->renderView (line 266)
38	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 107)
39	App\Controller\BaseController->render (line 40)
40	App\Controller\CategoryController->indexAction (line 163)
41	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 75)
42	Symfony\Component\HttpKernel\HttpKernel->handle (line 202)
43	Symfony\Component\HttpKernel\Kernel->handle (line 42)

3.03 ms
(2.86%)

SELECT t0.name AS name_1, t0.description AS description_2, t0.longDescription AS longDescription_3, t0.price_comment AS price_comment_4, t0.agent_id AS agent_id_5, t0.external_url AS external_url_6, t0.id AS id_7, t0.locale AS locale_8, t0.translatable_id AS translatable_id_9 FROM estate_translation t0 WHERE t0.translatable_id = ?

Parameters:

  0 of 0   
[▼
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.name AS name_1,
  t0.description AS description_2,
  t0.longDescription AS longDescription_3,
  t0.price_comment AS price_comment_4,
  t0.agent_id AS agent_id_5,
  t0.external_url AS external_url_6,
  t0.id AS id_7,
  t0.locale AS locale_8,
  t0.translatable_id AS translatable_id_9
FROM
  estate_translation t0
WHERE
  t0.translatable_id = ?

SELECT t0.name AS name_1, t0.description AS description_2, t0.longDescription AS longDescription_3, t0.price_comment AS price_comment_4, t0.agent_id AS agent_id_5, t0.external_url AS external_url_6, t0.id AS id_7, t0.locale AS locale_8, t0.translatable_id AS translatable_id_9 FROM estate_translation t0 WHERE t0.translatable_id = 1;

#	File/Call
1	Doctrine\DBAL\Logging\LoggerChain->startQuery (line 1294)
2	Doctrine\DBAL\Connection->executeQuery (line 1863)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getOneToManyStatement (line 1804)
4	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToManyCollection (line 3037)
5	Doctrine\ORM\UnitOfWork->loadCollection (line 698)
6	Doctrine\ORM\PersistentCollection->doInitialize (line 213)
7	Doctrine\ORM\PersistentCollection->initialize (line 119)
8	Doctrine\Common\Collections\AbstractLazyCollection->get (line 441)
9	Doctrine\ORM\PersistentCollection->get (line 193)
10	App\Entity\Estate->findTranslationByLocale (line 141)
11	App\Entity\Estate->doTranslate (line 75)
12	App\Entity\Estate->translate (line 70)
13	App\Service\FilterEstateService->getFilterEstates (line 156)
14	App\Controller\BaseController->initialize (line 19)
15	App\Controller\CategoryController->indexAction (line 163)
16	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 75)
17	Symfony\Component\HttpKernel\HttpKernel->handle (line 202)
18	Symfony\Component\HttpKernel\Kernel->handle (line 42)

2.91 ms
(2.74%)

SELECT t0.block_key AS block_key_1, t0.id AS id_2, t0.files_order AS files_order_3, t0.media_updated AS media_updated_4, t0.img_files_order AS img_files_order_5, t0.block_file_id AS block_file_id_6, t0.file_id AS file_id_7, t0.img_file_id AS img_file_id_8, t0.doc_file_id AS doc_file_id_9 FROM web_block t0

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.block_key AS block_key_1,
  t0.id AS id_2,
  t0.files_order AS files_order_3,
  t0.media_updated AS media_updated_4,
  t0.img_files_order AS img_files_order_5,
  t0.block_file_id AS block_file_id_6,
  t0.file_id AS file_id_7,
  t0.img_file_id AS img_file_id_8,
  t0.doc_file_id AS doc_file_id_9
FROM
  web_block t0

SELECT t0.block_key AS block_key_1, t0.id AS id_2, t0.files_order AS files_order_3, t0.media_updated AS media_updated_4, t0.img_files_order AS img_files_order_5, t0.block_file_id AS block_file_id_6, t0.file_id AS file_id_7, t0.img_file_id AS img_file_id_8, t0.doc_file_id AS doc_file_id_9 FROM web_block t0;

#	File/Call
1	Doctrine\DBAL\Logging\LoggerChain->startQuery (line 1294)
2	Doctrine\DBAL\Connection->executeQuery (line 916)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 225)
4	Doctrine\ORM\EntityRepository->findBy (line 20)
5	NexCRM\WebBundle\Repository\BlockRepository->findByToArray (line 134)
6	App\Controller\BaseController->initialize (line 19)
7	App\Controller\CategoryController->indexAction (line 163)
8	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 75)
9	Symfony\Component\HttpKernel\HttpKernel->handle (line 202)
10	Symfony\Component\HttpKernel\Kernel->handle (line 42)

2.79 ms
(2.63%)

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:

  0 of 0   
[▼
  4
]

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

#	File/Call
1	Doctrine\DBAL\Logging\LoggerChain->startQuery (line 1294)
2	Doctrine\DBAL\Connection->executeQuery (line 750)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 768)
4	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 207)
5	Doctrine\ORM\Proxy\ProxyFactory->Doctrine\ORM\Proxy\{closure} (line 399)
6	Closure->__invoke (line 399)
7	Proxies\__CG__\NexCRM\WebBundle\Entity\SEO->translate (line 40)
8	NexCRM\WebBundle\Repository\MenuRepository->findByGroupOrdered (line 132)
9	App\Controller\BaseController->initialize (line 19)
10	App\Controller\CategoryController->indexAction (line 163)
11	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 75)
12	Symfony\Component\HttpKernel\HttpKernel->handle (line 202)
13	Symfony\Component\HttpKernel\Kernel->handle (line 42)

2.28 ms
(2.15%)

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 = ?

Parameters:

  0 of 0   
[▼
  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 = ?

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;

#	File/Call
1	Doctrine\DBAL\Logging\LoggerChain->startQuery (line 1294)
2	Doctrine\DBAL\Connection->executeQuery (line 916)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 225)
4	Doctrine\ORM\EntityRepository->findBy (line 119)
5	NexCRM\WebBundle\Service\MarketingService->getCodeByEnabledCookie (line 92)
6	NexCRM\WebBundle\Service\MarketingService->getCodes (line 73)
7	NexCRM\WebBundle\Twig\MarketingTwigExtension->marketing (line 200)
8	__TwigTemplate_8977e40c3ea85b046ee507356db6d413d33959d7f59c852b3e046ef6f470f750->doDisplay (line 394)
9	Twig\Template->displayWithErrorHandling (line 367)
10	Twig\Template->display (line 57)
11	__TwigTemplate_0c1c9c79e3045f62ba0a13788fdba506af56c668b4917774c7305efb4dd0dcd2->doDisplay (line 394)
12	Twig\Template->displayWithErrorHandling (line 367)
13	Twig\Template->display (line 48)
14	__TwigTemplate_f4c2710d6a0300a0d5e020bf4c9ab946165bcf56185bec2f2ac667f2a4fd8a7f->doDisplay (line 394)
15	Twig\Template->displayWithErrorHandling (line 367)
16	Twig\Template->display (line 379)
17	Twig\Template->render (line 40)
18	Twig\TemplateWrapper->render (line 280)
19	Twig\Environment->render (line 258)
20	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->renderView (line 266)
21	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 107)
22	App\Controller\BaseController->render (line 40)
23	App\Controller\CategoryController->indexAction (line 163)
24	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 75)
25	Symfony\Component\HttpKernel\HttpKernel->handle (line 202)
26	Symfony\Component\HttpKernel\Kernel->handle (line 42)

2.07 ms
(1.95%)

SELECT t0.documents_order AS documents_order_1, t0.active AS active_2, t0.api_id AS api_id_3, t0.affiliate_id AS affiliate_id_4, t0.stamp AS stamp_5, t0.lat AS lat_6, t0.lng AS lng_7, t0.price AS price_8, t0.currency AS currency_9, t0.area_floor AS area_floor_10, t0.area_use AS area_use_11, t0.area_of_lot AS area_of_lot_12, t0.area_of_balcony AS area_of_balcony_13, t0.balcony AS balcony_14, t0.area_of_loggia AS area_of_loggia_15, t0.loggia AS loggia_16, t0.area_of_terrace AS area_of_terrace_17, t0.terrace AS terrace_18, t0.elevator AS elevator_19, t0.cellar AS cellar_20, t0.area_of_cellar AS area_of_cellar_21, t0.area_of_garden AS area_of_garden_22, t0.garden AS garden_23, t0.dont_advertise_price AS dont_advertise_price_24, t0.image AS image_25, t0.images AS images_26, t0.region AS region_27, t0.district AS district_28, t0.village AS village_29, t0.part_of_village AS part_of_village_30, t0.psc AS psc_31, t0.catastral_area AS catastral_area_32, t0.type_of_estate AS type_of_estate_33, t0.subtype_of_estate AS subtype_of_estate_34, t0.floor AS floor_35, t0.type_of_ownership AS type_of_ownership_36, t0.parking AS parking_37, t0.disposition AS disposition_38, t0.youtube AS youtube_39, t0.energy_performance_rating AS energy_performance_rating_40, t0.electricity AS electricity_41, t0.electricity_on_lot AS electricity_on_lot_42, t0.internet_connection AS internet_connection_43, t0.structure_of_building AS structure_of_building_44, t0.canalization AS canalization_45, t0.water AS water_46, t0.show_external_url_button AS show_external_url_button_47, t0.show_banner AS show_banner_48, t0.price_type AS price_type_49, t0.id AS id_50, t0.sort AS sort_51, t0.files_order AS files_order_52, t0.media_updated AS media_updated_53, t0.seo_id AS seo_id_54, t0.estate_file_id AS estate_file_id_55, t0.category_id AS category_id_56, t0.file_id AS file_id_57 FROM estate t0 ORDER BY t0.sort ASC

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.documents_order AS documents_order_1,
  t0.active AS active_2,
  t0.api_id AS api_id_3,
  t0.affiliate_id AS affiliate_id_4,
  t0.stamp AS stamp_5,
  t0.lat AS lat_6,
  t0.lng AS lng_7,
  t0.price AS price_8,
  t0.currency AS currency_9,
  t0.area_floor AS area_floor_10,
  t0.area_use AS area_use_11,
  t0.area_of_lot AS area_of_lot_12,
  t0.area_of_balcony AS area_of_balcony_13,
  t0.balcony AS balcony_14,
  t0.area_of_loggia AS area_of_loggia_15,
  t0.loggia AS loggia_16,
  t0.area_of_terrace AS area_of_terrace_17,
  t0.terrace AS terrace_18,
  t0.elevator AS elevator_19,
  t0.cellar AS cellar_20,
  t0.area_of_cellar AS area_of_cellar_21,
  t0.area_of_garden AS area_of_garden_22,
  t0.garden AS garden_23,
  t0.dont_advertise_price AS dont_advertise_price_24,
  t0.image AS image_25,
  t0.images AS images_26,
  t0.region AS region_27,
  t0.district AS district_28,
  t0.village AS village_29,
  t0.part_of_village AS part_of_village_30,
  t0.psc AS psc_31,
  t0.catastral_area AS catastral_area_32,
  t0.type_of_estate AS type_of_estate_33,
  t0.subtype_of_estate AS subtype_of_estate_34,
  t0.floor AS floor_35,
  t0.type_of_ownership AS type_of_ownership_36,
  t0.parking AS parking_37,
  t0.disposition AS disposition_38,
  t0.youtube AS youtube_39,
  t0.energy_performance_rating AS energy_performance_rating_40,
  t0.electricity AS electricity_41,
  t0.electricity_on_lot AS electricity_on_lot_42,
  t0.internet_connection AS internet_connection_43,
  t0.structure_of_building AS structure_of_building_44,
  t0.canalization AS canalization_45,
  t0.water AS water_46,
  t0.show_external_url_button AS show_external_url_button_47,
  t0.show_banner AS show_banner_48,
  t0.price_type AS price_type_49,
  t0.id AS id_50,
  t0.sort AS sort_51,
  t0.files_order AS files_order_52,
  t0.media_updated AS media_updated_53,
  t0.seo_id AS seo_id_54,
  t0.estate_file_id AS estate_file_id_55,
  t0.category_id AS category_id_56,
  t0.file_id AS file_id_57
FROM
  estate t0
ORDER BY
  t0.sort ASC

SELECT t0.documents_order AS documents_order_1, t0.active AS active_2, t0.api_id AS api_id_3, t0.affiliate_id AS affiliate_id_4, t0.stamp AS stamp_5, t0.lat AS lat_6, t0.lng AS lng_7, t0.price AS price_8, t0.currency AS currency_9, t0.area_floor AS area_floor_10, t0.area_use AS area_use_11, t0.area_of_lot AS area_of_lot_12, t0.area_of_balcony AS area_of_balcony_13, t0.balcony AS balcony_14, t0.area_of_loggia AS area_of_loggia_15, t0.loggia AS loggia_16, t0.area_of_terrace AS area_of_terrace_17, t0.terrace AS terrace_18, t0.elevator AS elevator_19, t0.cellar AS cellar_20, t0.area_of_cellar AS area_of_cellar_21, t0.area_of_garden AS area_of_garden_22, t0.garden AS garden_23, t0.dont_advertise_price AS dont_advertise_price_24, t0.image AS image_25, t0.images AS images_26, t0.region AS region_27, t0.district AS district_28, t0.village AS village_29, t0.part_of_village AS part_of_village_30, t0.psc AS psc_31, t0.catastral_area AS catastral_area_32, t0.type_of_estate AS type_of_estate_33, t0.subtype_of_estate AS subtype_of_estate_34, t0.floor AS floor_35, t0.type_of_ownership AS type_of_ownership_36, t0.parking AS parking_37, t0.disposition AS disposition_38, t0.youtube AS youtube_39, t0.energy_performance_rating AS energy_performance_rating_40, t0.electricity AS electricity_41, t0.electricity_on_lot AS electricity_on_lot_42, t0.internet_connection AS internet_connection_43, t0.structure_of_building AS structure_of_building_44, t0.canalization AS canalization_45, t0.water AS water_46, t0.show_external_url_button AS show_external_url_button_47, t0.show_banner AS show_banner_48, t0.price_type AS price_type_49, t0.id AS id_50, t0.sort AS sort_51, t0.files_order AS files_order_52, t0.media_updated AS media_updated_53, t0.seo_id AS seo_id_54, t0.estate_file_id AS estate_file_id_55, t0.category_id AS category_id_56, t0.file_id AS file_id_57 FROM estate t0 ORDER BY t0.sort ASC;

#	File/Call
1	Doctrine\DBAL\Logging\LoggerChain->startQuery (line 1294)
2	Doctrine\DBAL\Connection->executeQuery (line 916)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 225)
4	Doctrine\ORM\EntityRepository->findBy (line 136)
5	App\Controller\BaseController->initialize (line 19)
6	App\Controller\CategoryController->indexAction (line 163)
7	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 75)
8	Symfony\Component\HttpKernel\HttpKernel->handle (line 202)
9	Symfony\Component\HttpKernel\Kernel->handle (line 42)

1.94 ms
(1.83%)

SELECT t0.documents_order AS documents_order_1, t0.active AS active_2, t0.id AS id_3, t0.sort AS sort_4, t0.files_order AS files_order_5, t0.media_updated AS media_updated_6, t0.project_file_id AS project_file_id_7, t0.file_id AS file_id_8 FROM project t0 ORDER BY t0.sort ASC

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.documents_order AS documents_order_1,
  t0.active AS active_2,
  t0.id AS id_3,
  t0.sort AS sort_4,
  t0.files_order AS files_order_5,
  t0.media_updated AS media_updated_6,
  t0.project_file_id AS project_file_id_7,
  t0.file_id AS file_id_8
FROM
  project t0
ORDER BY
  t0.sort ASC

SELECT t0.documents_order AS documents_order_1, t0.active AS active_2, t0.id AS id_3, t0.sort AS sort_4, t0.files_order AS files_order_5, t0.media_updated AS media_updated_6, t0.project_file_id AS project_file_id_7, t0.file_id AS file_id_8 FROM project t0 ORDER BY t0.sort ASC;

#	File/Call
1	Doctrine\DBAL\Logging\LoggerChain->startQuery (line 1294)
2	Doctrine\DBAL\Connection->executeQuery (line 916)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 225)
4	Doctrine\ORM\EntityRepository->findBy (line 144)
5	App\Controller\BaseController->initialize (line 19)
6	App\Controller\CategoryController->indexAction (line 163)
7	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 75)
8	Symfony\Component\HttpKernel\HttpKernel->handle (line 202)
9	Symfony\Component\HttpKernel\Kernel->handle (line 42)

1.76 ms
(1.66%)

SELECT t0.name AS name_1, t0.text AS text_2, t0.title AS title_3, t0.id AS id_4, t0.locale AS locale_5, t0.translatable_id AS translatable_id_6 FROM category_translation t0 WHERE t0.translatable_id = ?

Parameters:

  0 of 0   
[▼
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.name AS name_1,
  t0.text AS text_2,
  t0.title AS title_3,
  t0.id AS id_4,
  t0.locale AS locale_5,
  t0.translatable_id AS translatable_id_6
FROM
  category_translation t0
WHERE
  t0.translatable_id = ?

SELECT t0.name AS name_1, t0.text AS text_2, t0.title AS title_3, t0.id AS id_4, t0.locale AS locale_5, t0.translatable_id AS translatable_id_6 FROM category_translation t0 WHERE t0.translatable_id = 1;

#	File/Call
1	Doctrine\DBAL\Logging\LoggerChain->startQuery (line 1294)
2	Doctrine\DBAL\Connection->executeQuery (line 1863)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getOneToManyStatement (line 1804)
4	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToManyCollection (line 3037)
5	Doctrine\ORM\UnitOfWork->loadCollection (line 698)
6	Doctrine\ORM\PersistentCollection->doInitialize (line 213)
7	Doctrine\ORM\PersistentCollection->initialize (line 119)
8	Doctrine\Common\Collections\AbstractLazyCollection->get (line 441)
9	Doctrine\ORM\PersistentCollection->get (line 193)
10	App\Entity\Category->findTranslationByLocale (line 141)
11	App\Entity\Category->doTranslate (line 75)
12	App\Entity\Category->translate (line 77)
13	App\Service\FilterEstateService->getFilterEstates (line 156)
14	App\Controller\BaseController->initialize (line 19)
15	App\Controller\CategoryController->indexAction (line 163)
16	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 75)
17	Symfony\Component\HttpKernel\HttpKernel->handle (line 202)
18	Symfony\Component\HttpKernel\Kernel->handle (line 42)

1.75 ms
(1.65%)

SELECT t0.documents_order AS documents_order_1, t0.active AS active_2, t0.color AS color_3, t0.id AS id_4, t0.sort AS sort_5, t0.files_order AS files_order_6, t0.media_updated AS media_updated_7, t0.service_file_id AS service_file_id_8, t0.file_id AS file_id_9 FROM service t0 ORDER BY t0.sort ASC

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.documents_order AS documents_order_1,
  t0.active AS active_2,
  t0.color AS color_3,
  t0.id AS id_4,
  t0.sort AS sort_5,
  t0.files_order AS files_order_6,
  t0.media_updated AS media_updated_7,
  t0.service_file_id AS service_file_id_8,
  t0.file_id AS file_id_9
FROM
  service t0
ORDER BY
  t0.sort ASC

SELECT t0.documents_order AS documents_order_1, t0.active AS active_2, t0.color AS color_3, t0.id AS id_4, t0.sort AS sort_5, t0.files_order AS files_order_6, t0.media_updated AS media_updated_7, t0.service_file_id AS service_file_id_8, t0.file_id AS file_id_9 FROM service t0 ORDER BY t0.sort ASC;

#	File/Call
1	Doctrine\DBAL\Logging\LoggerChain->startQuery (line 1294)
2	Doctrine\DBAL\Connection->executeQuery (line 916)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 225)
4	Doctrine\ORM\EntityRepository->findBy (line 142)
5	App\Controller\BaseController->initialize (line 19)
6	App\Controller\CategoryController->indexAction (line 163)
7	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 75)
8	Symfony\Component\HttpKernel\HttpKernel->handle (line 202)
9	Symfony\Component\HttpKernel\Kernel->handle (line 42)

1.68 ms
(1.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\Logging\LoggerChain->startQuery (line 1294)
2	Doctrine\DBAL\Connection->executeQuery (line 916)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 225)
4	Doctrine\ORM\EntityRepository->findBy (line 21)
5	NexCRM\WebBundle\Repository\MenuRepository->findByGroupOrdered (line 132)
6	App\Controller\BaseController->initialize (line 19)
7	App\Controller\CategoryController->indexAction (line 163)
8	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 75)
9	Symfony\Component\HttpKernel\HttpKernel->handle (line 202)
10	Symfony\Component\HttpKernel\Kernel->handle (line 42)

1.66 ms
(1.57%)

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_.file_id AS file_id_7, w0_.img_file_id AS img_file_id_8 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_.file_id AS file_id_7,
  w0_.img_file_id AS img_file_id_8
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_.file_id AS file_id_7, w0_.img_file_id AS img_file_id_8 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\Logging\LoggerChain->startQuery (line 1294)
2	Doctrine\DBAL\Connection->executeQuery (line 31)
3	Doctrine\ORM\Query\Exec\SingleSelectExecutor->execute (line 325)
4	Doctrine\ORM\Query->_doExecute (line 1212)
5	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 1166)
6	Doctrine\ORM\AbstractQuery->execute (line 901)
7	Doctrine\ORM\AbstractQuery->getResult (line 29)
8	NexCRM\WebBundle\Repository\MenuRepository->findByGroupOrdered (line 132)
9	App\Controller\BaseController->initialize (line 19)
10	App\Controller\CategoryController->indexAction (line 163)
11	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 75)
12	Symfony\Component\HttpKernel\HttpKernel->handle (line 202)
13	Symfony\Component\HttpKernel\Kernel->handle (line 42)

1.49 ms
(1.40%)

SELECT t0.documents_order AS documents_order_1, t0.active AS active_2, t0.price AS price_3, t0.area_use AS area_use_4, t0.disposition AS disposition_5, t0.currency AS currency_6, t0.id AS id_7, t0.sort AS sort_8, t0.files_order AS files_order_9, t0.media_updated AS media_updated_10, t0.seo_id AS seo_id_11, t0.reference_file_id AS reference_file_id_12, t0.category_id AS category_id_13, t0.file_id AS file_id_14 FROM reference t0 ORDER BY t0.sort ASC

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.documents_order AS documents_order_1,
  t0.active AS active_2,
  t0.price AS price_3,
  t0.area_use AS area_use_4,
  t0.disposition AS disposition_5,
  t0.currency AS currency_6,
  t0.id AS id_7,
  t0.sort AS sort_8,
  t0.files_order AS files_order_9,
  t0.media_updated AS media_updated_10,
  t0.seo_id AS seo_id_11,
  t0.reference_file_id AS reference_file_id_12,
  t0.category_id AS category_id_13,
  t0.file_id AS file_id_14
FROM
  reference t0
ORDER BY
  t0.sort ASC

SELECT t0.documents_order AS documents_order_1, t0.active AS active_2, t0.price AS price_3, t0.area_use AS area_use_4, t0.disposition AS disposition_5, t0.currency AS currency_6, t0.id AS id_7, t0.sort AS sort_8, t0.files_order AS files_order_9, t0.media_updated AS media_updated_10, t0.seo_id AS seo_id_11, t0.reference_file_id AS reference_file_id_12, t0.category_id AS category_id_13, t0.file_id AS file_id_14 FROM reference t0 ORDER BY t0.sort ASC;

#	File/Call
1	Doctrine\DBAL\Logging\LoggerChain->startQuery (line 1294)
2	Doctrine\DBAL\Connection->executeQuery (line 916)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 225)
4	Doctrine\ORM\EntityRepository->findBy (line 145)
5	App\Controller\BaseController->initialize (line 19)
6	App\Controller\CategoryController->indexAction (line 163)
7	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 75)
8	Symfony\Component\HttpKernel\HttpKernel->handle (line 202)
9	Symfony\Component\HttpKernel\Kernel->handle (line 42)

1.39 ms
(1.31%)

SELECT t0.published AS published_1, t0.expired AS expired_2, t0.documents_order AS documents_order_3, t0.doc_files_order AS doc_files_order_4, t0.id AS id_5, t0.sort AS sort_6, t0.files_order AS files_order_7, t0.media_updated AS media_updated_8, t0.img_files_order AS img_files_order_9, t0.author_id AS author_id_10, t0.seo_id AS seo_id_11, t0.news_file_id AS news_file_id_12, t0.file_id AS file_id_13, t0.img_file_id AS img_file_id_14, t0.doc_file_id AS doc_file_id_15 FROM web_news t0 WHERE t0.id = ? LIMIT 1

Parameters:

  0 of 0   
[▼
  3
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.published AS published_1,
  t0.expired AS expired_2,
  t0.documents_order AS documents_order_3,
  t0.doc_files_order AS doc_files_order_4,
  t0.id AS id_5,
  t0.sort AS sort_6,
  t0.files_order AS files_order_7,
  t0.media_updated AS media_updated_8,
  t0.img_files_order AS img_files_order_9,
  t0.author_id AS author_id_10,
  t0.seo_id AS seo_id_11,
  t0.news_file_id AS news_file_id_12,
  t0.file_id AS file_id_13,
  t0.img_file_id AS img_file_id_14,
  t0.doc_file_id AS doc_file_id_15
FROM
  web_news t0
WHERE
  t0.id = ?
LIMIT
  1

SELECT t0.published AS published_1, t0.expired AS expired_2, t0.documents_order AS documents_order_3, t0.doc_files_order AS doc_files_order_4, t0.id AS id_5, t0.sort AS sort_6, t0.files_order AS files_order_7, t0.media_updated AS media_updated_8, t0.img_files_order AS img_files_order_9, t0.author_id AS author_id_10, t0.seo_id AS seo_id_11, t0.news_file_id AS news_file_id_12, t0.file_id AS file_id_13, t0.img_file_id AS img_file_id_14, t0.doc_file_id AS doc_file_id_15 FROM web_news t0 WHERE t0.id = 3 LIMIT 1;

#	File/Call
1	Doctrine\DBAL\Logging\LoggerChain->startQuery (line 1294)
2	Doctrine\DBAL\Connection->executeQuery (line 750)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 241)
4	Doctrine\ORM\EntityRepository->findOneBy (line 38)
5	NexCRM\WebBundle\Repository\MenuRepository->findByGroupOrdered (line 132)
6	App\Controller\BaseController->initialize (line 19)
7	App\Controller\CategoryController->indexAction (line 163)
8	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 75)
9	Symfony\Component\HttpKernel\HttpKernel->handle (line 202)
10	Symfony\Component\HttpKernel\Kernel->handle (line 42)

1.39 ms
(1.31%)

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:

  0 of 0   
[▼
  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\Logging\LoggerChain->startQuery (line 1294)
2	Doctrine\DBAL\Connection->executeQuery (line 916)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 225)
4	Doctrine\ORM\EntityRepository->findBy (line 36)
5	NexCRM\BaseBundle\EventListener\LocaleListener->onKernelRequest (line 117)
6	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 230)
7	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 59)
8	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 154)
9	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 139)
10	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 75)
11	Symfony\Component\HttpKernel\HttpKernel->handle (line 202)
12	Symfony\Component\HttpKernel\Kernel->handle (line 42)

1.34 ms
(1.26%)

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\Logging\LoggerChain->startQuery (line 1294)
2	Doctrine\DBAL\Connection->executeQuery (line 916)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 225)
4	Doctrine\ORM\EntityRepository->findBy (line 207)
5	Doctrine\ORM\EntityRepository->findAll (line 17)
6	NexCRM\BaseBundle\Repository\SettingRepository->findByToArray (line 130)
7	App\Controller\BaseController->initialize (line 19)
8	App\Controller\CategoryController->indexAction (line 163)
9	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 75)
10	Symfony\Component\HttpKernel\HttpKernel->handle (line 202)
11	Symfony\Component\HttpKernel\Kernel->handle (line 42)

1.27 ms
(1.19%)

SELECT t0.documents_order AS documents_order_1, t0.active AS active_2, t0.api_id AS api_id_3, t0.affiliate_id AS affiliate_id_4, t0.stamp AS stamp_5, t0.lat AS lat_6, t0.lng AS lng_7, t0.price AS price_8, t0.currency AS currency_9, t0.area_floor AS area_floor_10, t0.area_use AS area_use_11, t0.area_of_lot AS area_of_lot_12, t0.area_of_balcony AS area_of_balcony_13, t0.balcony AS balcony_14, t0.area_of_loggia AS area_of_loggia_15, t0.loggia AS loggia_16, t0.area_of_terrace AS area_of_terrace_17, t0.terrace AS terrace_18, t0.elevator AS elevator_19, t0.cellar AS cellar_20, t0.area_of_cellar AS area_of_cellar_21, t0.area_of_garden AS area_of_garden_22, t0.garden AS garden_23, t0.dont_advertise_price AS dont_advertise_price_24, t0.image AS image_25, t0.images AS images_26, t0.region AS region_27, t0.district AS district_28, t0.village AS village_29, t0.part_of_village AS part_of_village_30, t0.psc AS psc_31, t0.catastral_area AS catastral_area_32, t0.type_of_estate AS type_of_estate_33, t0.subtype_of_estate AS subtype_of_estate_34, t0.floor AS floor_35, t0.type_of_ownership AS type_of_ownership_36, t0.parking AS parking_37, t0.disposition AS disposition_38, t0.youtube AS youtube_39, t0.energy_performance_rating AS energy_performance_rating_40, t0.electricity AS electricity_41, t0.electricity_on_lot AS electricity_on_lot_42, t0.internet_connection AS internet_connection_43, t0.structure_of_building AS structure_of_building_44, t0.canalization AS canalization_45, t0.water AS water_46, t0.show_external_url_button AS show_external_url_button_47, t0.show_banner AS show_banner_48, t0.price_type AS price_type_49, t0.id AS id_50, t0.sort AS sort_51, t0.files_order AS files_order_52, t0.media_updated AS media_updated_53, t0.seo_id AS seo_id_54, t0.estate_file_id AS estate_file_id_55, t0.category_id AS category_id_56, t0.file_id AS file_id_57 FROM estate t0 WHERE t0.category_id = ? ORDER BY t0.sort ASC

Parameters:

  0 of 0   
[▼
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.documents_order AS documents_order_1,
  t0.active AS active_2,
  t0.api_id AS api_id_3,
  t0.affiliate_id AS affiliate_id_4,
  t0.stamp AS stamp_5,
  t0.lat AS lat_6,
  t0.lng AS lng_7,
  t0.price AS price_8,
  t0.currency AS currency_9,
  t0.area_floor AS area_floor_10,
  t0.area_use AS area_use_11,
  t0.area_of_lot AS area_of_lot_12,
  t0.area_of_balcony AS area_of_balcony_13,
  t0.balcony AS balcony_14,
  t0.area_of_loggia AS area_of_loggia_15,
  t0.loggia AS loggia_16,
  t0.area_of_terrace AS area_of_terrace_17,
  t0.terrace AS terrace_18,
  t0.elevator AS elevator_19,
  t0.cellar AS cellar_20,
  t0.area_of_cellar AS area_of_cellar_21,
  t0.area_of_garden AS area_of_garden_22,
  t0.garden AS garden_23,
  t0.dont_advertise_price AS dont_advertise_price_24,
  t0.image AS image_25,
  t0.images AS images_26,
  t0.region AS region_27,
  t0.district AS district_28,
  t0.village AS village_29,
  t0.part_of_village AS part_of_village_30,
  t0.psc AS psc_31,
  t0.catastral_area AS catastral_area_32,
  t0.type_of_estate AS type_of_estate_33,
  t0.subtype_of_estate AS subtype_of_estate_34,
  t0.floor AS floor_35,
  t0.type_of_ownership AS type_of_ownership_36,
  t0.parking AS parking_37,
  t0.disposition AS disposition_38,
  t0.youtube AS youtube_39,
  t0.energy_performance_rating AS energy_performance_rating_40,
  t0.electricity AS electricity_41,
  t0.electricity_on_lot AS electricity_on_lot_42,
  t0.internet_connection AS internet_connection_43,
  t0.structure_of_building AS structure_of_building_44,
  t0.canalization AS canalization_45,
  t0.water AS water_46,
  t0.show_external_url_button AS show_external_url_button_47,
  t0.show_banner AS show_banner_48,
  t0.price_type AS price_type_49,
  t0.id AS id_50,
  t0.sort AS sort_51,
  t0.files_order AS files_order_52,
  t0.media_updated AS media_updated_53,
  t0.seo_id AS seo_id_54,
  t0.estate_file_id AS estate_file_id_55,
  t0.category_id AS category_id_56,
  t0.file_id AS file_id_57
FROM
  estate t0
WHERE
  t0.category_id = ?
ORDER BY
  t0.sort ASC

SELECT t0.documents_order AS documents_order_1, t0.active AS active_2, t0.api_id AS api_id_3, t0.affiliate_id AS affiliate_id_4, t0.stamp AS stamp_5, t0.lat AS lat_6, t0.lng AS lng_7, t0.price AS price_8, t0.currency AS currency_9, t0.area_floor AS area_floor_10, t0.area_use AS area_use_11, t0.area_of_lot AS area_of_lot_12, t0.area_of_balcony AS area_of_balcony_13, t0.balcony AS balcony_14, t0.area_of_loggia AS area_of_loggia_15, t0.loggia AS loggia_16, t0.area_of_terrace AS area_of_terrace_17, t0.terrace AS terrace_18, t0.elevator AS elevator_19, t0.cellar AS cellar_20, t0.area_of_cellar AS area_of_cellar_21, t0.area_of_garden AS area_of_garden_22, t0.garden AS garden_23, t0.dont_advertise_price AS dont_advertise_price_24, t0.image AS image_25, t0.images AS images_26, t0.region AS region_27, t0.district AS district_28, t0.village AS village_29, t0.part_of_village AS part_of_village_30, t0.psc AS psc_31, t0.catastral_area AS catastral_area_32, t0.type_of_estate AS type_of_estate_33, t0.subtype_of_estate AS subtype_of_estate_34, t0.floor AS floor_35, t0.type_of_ownership AS type_of_ownership_36, t0.parking AS parking_37, t0.disposition AS disposition_38, t0.youtube AS youtube_39, t0.energy_performance_rating AS energy_performance_rating_40, t0.electricity AS electricity_41, t0.electricity_on_lot AS electricity_on_lot_42, t0.internet_connection AS internet_connection_43, t0.structure_of_building AS structure_of_building_44, t0.canalization AS canalization_45, t0.water AS water_46, t0.show_external_url_button AS show_external_url_button_47, t0.show_banner AS show_banner_48, t0.price_type AS price_type_49, t0.id AS id_50, t0.sort AS sort_51, t0.files_order AS files_order_52, t0.media_updated AS media_updated_53, t0.seo_id AS seo_id_54, t0.estate_file_id AS estate_file_id_55, t0.category_id AS category_id_56, t0.file_id AS file_id_57 FROM estate t0 WHERE t0.category_id = 1 ORDER BY t0.sort ASC;

#	File/Call
1	Doctrine\DBAL\Logging\LoggerChain->startQuery (line 1294)
2	Doctrine\DBAL\Connection->executeQuery (line 916)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 225)
4	Doctrine\ORM\EntityRepository->findBy (line 368)
5	Doctrine\ORM\EntityRepository->resolveMagicCall (line 272)
6	Doctrine\ORM\EntityRepository->__call (line 26)
7	App\Controller\CategoryController->indexAction (line 163)
8	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 75)
9	Symfony\Component\HttpKernel\HttpKernel->handle (line 202)
10	Symfony\Component\HttpKernel\Kernel->handle (line 42)

1.19 ms
(1.12%)

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_.file_id AS file_id_7, w0_.img_file_id AS img_file_id_8 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_.file_id AS file_id_7,
  w0_.img_file_id AS img_file_id_8
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_.file_id AS file_id_7, w0_.img_file_id AS img_file_id_8 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\Logging\LoggerChain->startQuery (line 1294)
2	Doctrine\DBAL\Connection->executeQuery (line 31)
3	Doctrine\ORM\Query\Exec\SingleSelectExecutor->execute (line 325)
4	Doctrine\ORM\Query->_doExecute (line 1212)
5	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 1166)
6	Doctrine\ORM\AbstractQuery->execute (line 901)
7	Doctrine\ORM\AbstractQuery->getResult (line 29)
8	NexCRM\WebBundle\Repository\MenuRepository->findByGroupOrdered (line 132)
9	App\Controller\BaseController->initialize (line 19)
10	App\Controller\CategoryController->indexAction (line 163)
11	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 75)
12	Symfony\Component\HttpKernel\HttpKernel->handle (line 202)
13	Symfony\Component\HttpKernel\Kernel->handle (line 42)

1.06 ms
(1.00%)

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:

  0 of 0   
[▼
  2
]

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

#	File/Call
1	Doctrine\DBAL\Logging\LoggerChain->startQuery (line 1294)
2	Doctrine\DBAL\Connection->executeQuery (line 750)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 768)
4	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 207)
5	Doctrine\ORM\Proxy\ProxyFactory->Doctrine\ORM\Proxy\{closure} (line 197)
6	Closure->__invoke (line 197)
7	Proxies\__CG__\NexCRM\WebBundle\Entity\Module->getEntity (line 35)
8	NexCRM\WebBundle\Repository\MenuRepository->findByGroupOrdered (line 132)
9	App\Controller\BaseController->initialize (line 19)
10	App\Controller\CategoryController->indexAction (line 163)
11	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 75)
12	Symfony\Component\HttpKernel\HttpKernel->handle (line 202)
13	Symfony\Component\HttpKernel\Kernel->handle (line 42)

1.05 ms
(0.99%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.lft AS lft_3, t0.rgt AS rgt_4, t0.lvl AS lvl_5, t0.root AS root_6, t0.deleted AS deleted_7, t0.deleted_at AS deleted_at_8, t0.parent_id AS parent_id_9 FROM folder t0 WHERE t0.id = ?

Parameters:

  0 of 0   
[▼
  67
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.lft AS lft_3,
  t0.rgt AS rgt_4,
  t0.lvl AS lvl_5,
  t0.root AS root_6,
  t0.deleted AS deleted_7,
  t0.deleted_at AS deleted_at_8,
  t0.parent_id AS parent_id_9
FROM
  folder t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.lft AS lft_3, t0.rgt AS rgt_4, t0.lvl AS lvl_5, t0.root AS root_6, t0.deleted AS deleted_7, t0.deleted_at AS deleted_at_8, t0.parent_id AS parent_id_9 FROM folder t0 WHERE t0.id = 67;

#	File/Call
1	Doctrine\DBAL\Logging\LoggerChain->startQuery (line 1294)
2	Doctrine\DBAL\Connection->executeQuery (line 750)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 768)
4	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 207)
5	Doctrine\ORM\Proxy\ProxyFactory->Doctrine\ORM\Proxy\{closure} (line 256)
6	Closure->__invoke (line 256)
7	Proxies\__CG__\NexCRM\BaseBundle\Entity\Folder->getName (line 276)
8	NexCRM\BaseBundle\Entity\MediaFile->directoryName (line 375)
9	Proxies\__CG__\NexCRM\BaseBundle\Entity\MediaFile->directoryName (line 1635)
10	twig_get_attribute (line 94)
11	__TwigTemplate_174fa8555b9190bdcf222e352a0d083908ff519e9cb429f9b3efe43a06313a07->doDisplay (line 394)
12	Twig\Template->displayWithErrorHandling (line 367)
13	Twig\Template->display (line 61)
14	__TwigTemplate_148ce474357114874ae3815eb8c2ea9f7de2ac87360f883d14d0db50be1eec5f->doDisplay (line 394)
15	Twig\Template->displayWithErrorHandling (line 367)
16	Twig\Template->display (line 69)
17	__TwigTemplate_474bb8e2056b04e51b514c29a16b5e1c037f744361a26b7e1109ad8e51b2fa99->doDisplay (line 394)
18	Twig\Template->displayWithErrorHandling (line 367)
19	Twig\Template->display (line 74)
20	__TwigTemplate_f4c2710d6a0300a0d5e020bf4c9ab946165bcf56185bec2f2ac667f2a4fd8a7f->block_content (line 171)
21	Twig\Template->displayBlock (line 216)
22	__TwigTemplate_8977e40c3ea85b046ee507356db6d413d33959d7f59c852b3e046ef6f470f750->doDisplay (line 394)
23	Twig\Template->displayWithErrorHandling (line 367)
24	Twig\Template->display (line 57)
25	__TwigTemplate_0c1c9c79e3045f62ba0a13788fdba506af56c668b4917774c7305efb4dd0dcd2->doDisplay (line 394)
26	Twig\Template->displayWithErrorHandling (line 367)
27	Twig\Template->display (line 48)
28	__TwigTemplate_f4c2710d6a0300a0d5e020bf4c9ab946165bcf56185bec2f2ac667f2a4fd8a7f->doDisplay (line 394)
29	Twig\Template->displayWithErrorHandling (line 367)
30	Twig\Template->display (line 379)
31	Twig\Template->render (line 40)
32	Twig\TemplateWrapper->render (line 280)
33	Twig\Environment->render (line 258)
34	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->renderView (line 266)
35	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 107)
36	App\Controller\BaseController->render (line 40)
37	App\Controller\CategoryController->indexAction (line 163)
38	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 75)
39	Symfony\Component\HttpKernel\HttpKernel->handle (line 202)
40	Symfony\Component\HttpKernel\Kernel->handle (line 42)

0.90 ms
(0.85%)

SELECT w0_.active AS active_0, w0_.only_image AS only_image_1, w0_.created AS created_2, w0_.entity_id AS entity_id_3, w0_.id AS id_4, w0_.sort AS sort_5, w0_.link_id AS link_id_6, w0_.page_id AS page_id_7, w0_.author_id AS author_id_8, w0_.file_tablet_id AS file_tablet_id_9, w0_.file_phone_id AS file_phone_id_10, w0_.video_id AS video_id_11, w0_.dms_file_tablet_id AS dms_file_tablet_id_12, w0_.dms_file_phone_id AS dms_file_phone_id_13, w0_.dms_video_id AS dms_video_id_14, w0_.file_id AS file_id_15, w0_.img_file_id AS img_file_id_16 FROM web_slider w0_ INNER JOIN web_slider_to_group w2_ ON w0_.id = w2_.slider_item_id INNER JOIN web_slider_group w1_ ON w1_.id = w2_.slider_group_id WHERE w1_.id = 1 AND w0_.active = 1 ORDER BY w0_.page_id ASC, w0_.sort ASC

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  w0_.active AS active_0,
  w0_.only_image AS only_image_1,
  w0_.created AS created_2,
  w0_.entity_id AS entity_id_3,
  w0_.id AS id_4,
  w0_.sort AS sort_5,
  w0_.link_id AS link_id_6,
  w0_.page_id AS page_id_7,
  w0_.author_id AS author_id_8,
  w0_.file_tablet_id AS file_tablet_id_9,
  w0_.file_phone_id AS file_phone_id_10,
  w0_.video_id AS video_id_11,
  w0_.dms_file_tablet_id AS dms_file_tablet_id_12,
  w0_.dms_file_phone_id AS dms_file_phone_id_13,
  w0_.dms_video_id AS dms_video_id_14,
  w0_.file_id AS file_id_15,
  w0_.img_file_id AS img_file_id_16
FROM
  web_slider w0_
  INNER JOIN web_slider_to_group w2_ ON w0_.id = w2_.slider_item_id
  INNER JOIN web_slider_group w1_ ON w1_.id = w2_.slider_group_id
WHERE
  w1_.id = 1
  AND w0_.active = 1
ORDER BY
  w0_.page_id ASC,
  w0_.sort ASC

SELECT w0_.active AS active_0, w0_.only_image AS only_image_1, w0_.created AS created_2, w0_.entity_id AS entity_id_3, w0_.id AS id_4, w0_.sort AS sort_5, w0_.link_id AS link_id_6, w0_.page_id AS page_id_7, w0_.author_id AS author_id_8, w0_.file_tablet_id AS file_tablet_id_9, w0_.file_phone_id AS file_phone_id_10, w0_.video_id AS video_id_11, w0_.dms_file_tablet_id AS dms_file_tablet_id_12, w0_.dms_file_phone_id AS dms_file_phone_id_13, w0_.dms_video_id AS dms_video_id_14, w0_.file_id AS file_id_15, w0_.img_file_id AS img_file_id_16 FROM web_slider w0_ INNER JOIN web_slider_to_group w2_ ON w0_.id = w2_.slider_item_id INNER JOIN web_slider_group w1_ ON w1_.id = w2_.slider_group_id WHERE w1_.id = 1 AND w0_.active = 1 ORDER BY w0_.page_id ASC, w0_.sort ASC;

#	File/Call
1	Doctrine\DBAL\Logging\LoggerChain->startQuery (line 1294)
2	Doctrine\DBAL\Connection->executeQuery (line 31)
3	Doctrine\ORM\Query\Exec\SingleSelectExecutor->execute (line 325)
4	Doctrine\ORM\Query->_doExecute (line 1212)
5	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 1166)
6	Doctrine\ORM\AbstractQuery->execute (line 901)
7	Doctrine\ORM\AbstractQuery->getResult (line 29)
8	NexCRM\WebBundle\Repository\SliderRepository->findByGroupOrdered (line 133)
9	App\Controller\BaseController->initialize (line 19)
10	App\Controller\CategoryController->indexAction (line 163)
11	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 75)
12	Symfony\Component\HttpKernel\HttpKernel->handle (line 202)
13	Symfony\Component\HttpKernel\Kernel->handle (line 42)

0.89 ms
(0.84%)

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_.file_id AS file_id_7, w0_.img_file_id AS img_file_id_8 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 = 4 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_.file_id AS file_id_7,
  w0_.img_file_id AS img_file_id_8
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 = 4
  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_.file_id AS file_id_7, w0_.img_file_id AS img_file_id_8 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 = 4 AND w0_.active = 1 ORDER BY w0_.sort ASC;

#	File/Call
1	Doctrine\DBAL\Logging\LoggerChain->startQuery (line 1294)
2	Doctrine\DBAL\Connection->executeQuery (line 31)
3	Doctrine\ORM\Query\Exec\SingleSelectExecutor->execute (line 325)
4	Doctrine\ORM\Query->_doExecute (line 1212)
5	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 1166)
6	Doctrine\ORM\AbstractQuery->execute (line 901)
7	Doctrine\ORM\AbstractQuery->getResult (line 29)
8	NexCRM\WebBundle\Repository\MenuRepository->findByGroupOrdered (line 132)
9	App\Controller\BaseController->initialize (line 19)
10	App\Controller\CategoryController->indexAction (line 163)
11	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 75)
12	Symfony\Component\HttpKernel\HttpKernel->handle (line 202)
13	Symfony\Component\HttpKernel\Kernel->handle (line 42)

0.69 ms
(0.65%)

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_.file_id AS file_id_7, w0_.img_file_id AS img_file_id_8 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 = 3 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_.file_id AS file_id_7,
  w0_.img_file_id AS img_file_id_8
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 = 3
  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_.file_id AS file_id_7, w0_.img_file_id AS img_file_id_8 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 = 3 AND w0_.active = 1 ORDER BY w0_.sort ASC;

#	File/Call
1	Doctrine\DBAL\Logging\LoggerChain->startQuery (line 1294)
2	Doctrine\DBAL\Connection->executeQuery (line 31)
3	Doctrine\ORM\Query\Exec\SingleSelectExecutor->execute (line 325)
4	Doctrine\ORM\Query->_doExecute (line 1212)
5	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 1166)
6	Doctrine\ORM\AbstractQuery->execute (line 901)
7	Doctrine\ORM\AbstractQuery->getResult (line 29)
8	NexCRM\WebBundle\Repository\MenuRepository->findByGroupOrdered (line 132)
9	App\Controller\BaseController->initialize (line 19)
10	App\Controller\CategoryController->indexAction (line 163)
11	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 75)
12	Symfony\Component\HttpKernel\HttpKernel->handle (line 202)
13	Symfony\Component\HttpKernel\Kernel->handle (line 42)

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

  0 of 0   
[▼
  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\Logging\LoggerChain->startQuery (line 1294)
2	Doctrine\DBAL\Connection->executeQuery (line 750)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 241)
4	Doctrine\ORM\EntityRepository->findOneBy (line 38)
5	NexCRM\BaseBundle\EventListener\LocaleListener->onKernelRequest (line 117)
6	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 230)
7	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 59)
8	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 154)
9	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 139)
10	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 75)
11	Symfony\Component\HttpKernel\HttpKernel->handle (line 202)
12	Symfony\Component\HttpKernel\Kernel->handle (line 42)

0.67 ms
(0.63%)

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:

  0 of 0   
[▼
  "en"
]

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 = 'en' LIMIT 1;

#	File/Call
1	Doctrine\DBAL\Logging\LoggerChain->startQuery (line 1294)
2	Doctrine\DBAL\Connection->executeQuery (line 750)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 241)
4	Doctrine\ORM\EntityRepository->findOneBy (line 52)
5	NexCRM\BaseBundle\EventListener\LocaleListener->onKernelRequest (line 117)
6	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 230)
7	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 59)
8	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 154)
9	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 139)
10	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 75)
11	Symfony\Component\HttpKernel\HttpKernel->handle (line 202)
12	Symfony\Component\HttpKernel\Kernel->handle (line 42)

0.59 ms
(0.56%)

SELECT t0.homepage AS homepage_1, t0.documents_order AS documents_order_2, t0.doc_files_order AS doc_files_order_3, t0.id AS id_4, t0.sort AS sort_5, t0.files_order AS files_order_6, t0.media_updated AS media_updated_7, t0.img_files_order AS img_files_order_8, t0.parent AS parent_9, t0.seo_id AS seo_id_10, t0.template_id AS template_id_11, t0.page_file_id AS page_file_id_12, t0.file_id AS file_id_13, t0.img_file_id AS img_file_id_14, t0.doc_file_id AS doc_file_id_15 FROM web_page t0

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.homepage AS homepage_1,
  t0.documents_order AS documents_order_2,
  t0.doc_files_order AS doc_files_order_3,
  t0.id AS id_4,
  t0.sort AS sort_5,
  t0.files_order AS files_order_6,
  t0.media_updated AS media_updated_7,
  t0.img_files_order AS img_files_order_8,
  t0.parent AS parent_9,
  t0.seo_id AS seo_id_10,
  t0.template_id AS template_id_11,
  t0.page_file_id AS page_file_id_12,
  t0.file_id AS file_id_13,
  t0.img_file_id AS img_file_id_14,
  t0.doc_file_id AS doc_file_id_15
FROM
  web_page t0

SELECT t0.homepage AS homepage_1, t0.documents_order AS documents_order_2, t0.doc_files_order AS doc_files_order_3, t0.id AS id_4, t0.sort AS sort_5, t0.files_order AS files_order_6, t0.media_updated AS media_updated_7, t0.img_files_order AS img_files_order_8, t0.parent AS parent_9, t0.seo_id AS seo_id_10, t0.template_id AS template_id_11, t0.page_file_id AS page_file_id_12, t0.file_id AS file_id_13, t0.img_file_id AS img_file_id_14, t0.doc_file_id AS doc_file_id_15 FROM web_page t0;

#	File/Call
1	Doctrine\DBAL\Logging\LoggerChain->startQuery (line 1294)
2	Doctrine\DBAL\Connection->executeQuery (line 916)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 225)
4	Doctrine\ORM\EntityRepository->findBy (line 131)
5	App\Controller\BaseController->initialize (line 19)
6	App\Controller\CategoryController->indexAction (line 163)
7	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 75)
8	Symfony\Component\HttpKernel\HttpKernel->handle (line 202)
9	Symfony\Component\HttpKernel\Kernel->handle (line 42)

0.58 ms
(0.54%)

SELECT w0_.published AS published_0, w0_.expired AS expired_1, w0_.documents_order AS documents_order_2, w0_.doc_files_order AS doc_files_order_3, w0_.id AS id_4, w0_.sort AS sort_5, w0_.files_order AS files_order_6, w0_.media_updated AS media_updated_7, w0_.img_files_order AS img_files_order_8, w0_.author_id AS author_id_9, w0_.seo_id AS seo_id_10, w0_.news_file_id AS news_file_id_11, w0_.file_id AS file_id_12, w0_.img_file_id AS img_file_id_13, w0_.doc_file_id AS doc_file_id_14 FROM web_news w0_ WHERE (w0_.expired > '2025-04-22 17:26:56' OR w0_.expired IS NULL) AND w0_.published <= '2025-04-22 17:26:56' ORDER BY w0_.published DESC, w0_.id DESC LIMIT 6

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  w0_.published AS published_0,
  w0_.expired AS expired_1,
  w0_.documents_order AS documents_order_2,
  w0_.doc_files_order AS doc_files_order_3,
  w0_.id AS id_4,
  w0_.sort AS sort_5,
  w0_.files_order AS files_order_6,
  w0_.media_updated AS media_updated_7,
  w0_.img_files_order AS img_files_order_8,
  w0_.author_id AS author_id_9,
  w0_.seo_id AS seo_id_10,
  w0_.news_file_id AS news_file_id_11,
  w0_.file_id AS file_id_12,
  w0_.img_file_id AS img_file_id_13,
  w0_.doc_file_id AS doc_file_id_14
FROM
  web_news w0_
WHERE
  (
    w0_.expired > '2025-04-22 17:26:56'
    OR w0_.expired IS NULL
  )
  AND w0_.published <= '2025-04-22 17:26:56'
ORDER BY
  w0_.published DESC,
  w0_.id DESC
LIMIT
  6

SELECT w0_.published AS published_0, w0_.expired AS expired_1, w0_.documents_order AS documents_order_2, w0_.doc_files_order AS doc_files_order_3, w0_.id AS id_4, w0_.sort AS sort_5, w0_.files_order AS files_order_6, w0_.media_updated AS media_updated_7, w0_.img_files_order AS img_files_order_8, w0_.author_id AS author_id_9, w0_.seo_id AS seo_id_10, w0_.news_file_id AS news_file_id_11, w0_.file_id AS file_id_12, w0_.img_file_id AS img_file_id_13, w0_.doc_file_id AS doc_file_id_14 FROM web_news w0_ WHERE (w0_.expired > '2025-04-22 17:26:56' OR w0_.expired IS NULL) AND w0_.published <= '2025-04-22 17:26:56' ORDER BY w0_.published DESC, w0_.id DESC LIMIT 6;

#	File/Call
1	Doctrine\DBAL\Logging\LoggerChain->startQuery (line 1294)
2	Doctrine\DBAL\Connection->executeQuery (line 31)
3	Doctrine\ORM\Query\Exec\SingleSelectExecutor->execute (line 325)
4	Doctrine\ORM\Query->_doExecute (line 1212)
5	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 1166)
6	Doctrine\ORM\AbstractQuery->execute (line 901)
7	Doctrine\ORM\AbstractQuery->getResult (line 33)
8	NexCRM\WebBundle\Repository\NewsRepository->findVisible (line 140)
9	App\Controller\BaseController->initialize (line 19)
10	App\Controller\CategoryController->indexAction (line 163)
11	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 75)
12	Symfony\Component\HttpKernel\HttpKernel->handle (line 202)
13	Symfony\Component\HttpKernel\Kernel->handle (line 42)

0.53 ms
(0.50%)

SELECT t0.documents_order AS documents_order_1, t0.active AS active_2, t0.id AS id_3, t0.sort AS sort_4, t0.files_order AS files_order_5, t0.media_updated AS media_updated_6, t0.seo_id AS seo_id_7, t0.category_file_id AS category_file_id_8, t0.file_id AS file_id_9 FROM category t0 WHERE t0.seo_id = ? LIMIT 1

Parameters:

  0 of 0   
[▼
  "6"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.documents_order AS documents_order_1,
  t0.active AS active_2,
  t0.id AS id_3,
  t0.sort AS sort_4,
  t0.files_order AS files_order_5,
  t0.media_updated AS media_updated_6,
  t0.seo_id AS seo_id_7,
  t0.category_file_id AS category_file_id_8,
  t0.file_id AS file_id_9
FROM
  category t0
WHERE
  t0.seo_id = ?
LIMIT
  1

SELECT t0.documents_order AS documents_order_1, t0.active AS active_2, t0.id AS id_3, t0.sort AS sort_4, t0.files_order AS files_order_5, t0.media_updated AS media_updated_6, t0.seo_id AS seo_id_7, t0.category_file_id AS category_file_id_8, t0.file_id AS file_id_9 FROM category t0 WHERE t0.seo_id = '6' LIMIT 1;

#	File/Call
1	Doctrine\DBAL\Logging\LoggerChain->startQuery (line 1294)
2	Doctrine\DBAL\Connection->executeQuery (line 750)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 241)
4	Doctrine\ORM\EntityRepository->findOneBy (line 21)
5	App\Controller\CategoryController->indexAction (line 163)
6	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 75)
7	Symfony\Component\HttpKernel\HttpKernel->handle (line 202)
8	Symfony\Component\HttpKernel\Kernel->handle (line 42)

0.50 ms
(0.47%)

SELECT t0.name AS name_1, t0.id AS id_2 FROM web_slider_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_slider_group t0

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

#	File/Call
1	Doctrine\DBAL\Logging\LoggerChain->startQuery (line 1294)
2	Doctrine\DBAL\Connection->executeQuery (line 916)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 225)
4	Doctrine\ORM\EntityRepository->findBy (line 20)
5	NexCRM\WebBundle\Repository\SliderRepository->findByGroupOrdered (line 133)
6	App\Controller\BaseController->initialize (line 19)
7	App\Controller\CategoryController->indexAction (line 163)
8	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 75)
9	Symfony\Component\HttpKernel\HttpKernel->handle (line 202)
10	Symfony\Component\HttpKernel\Kernel->handle (line 42)

0.43 ms
(0.41%)

SELECT t0.documents_order AS documents_order_1, t0.active AS active_2, t0.id AS id_3, t0.sort AS sort_4, t0.files_order AS files_order_5, t0.media_updated AS media_updated_6, t0.seo_id AS seo_id_7, t0.category_file_id AS category_file_id_8, t0.file_id AS file_id_9 FROM category t0 ORDER BY t0.sort ASC

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.documents_order AS documents_order_1,
  t0.active AS active_2,
  t0.id AS id_3,
  t0.sort AS sort_4,
  t0.files_order AS files_order_5,
  t0.media_updated AS media_updated_6,
  t0.seo_id AS seo_id_7,
  t0.category_file_id AS category_file_id_8,
  t0.file_id AS file_id_9
FROM
  category t0
ORDER BY
  t0.sort ASC

SELECT t0.documents_order AS documents_order_1, t0.active AS active_2, t0.id AS id_3, t0.sort AS sort_4, t0.files_order AS files_order_5, t0.media_updated AS media_updated_6, t0.seo_id AS seo_id_7, t0.category_file_id AS category_file_id_8, t0.file_id AS file_id_9 FROM category t0 ORDER BY t0.sort ASC;

#	File/Call
1	Doctrine\DBAL\Logging\LoggerChain->startQuery (line 1294)
2	Doctrine\DBAL\Connection->executeQuery (line 916)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 225)
4	Doctrine\ORM\EntityRepository->findBy (line 135)
5	App\Controller\BaseController->initialize (line 19)
6	App\Controller\CategoryController->indexAction (line 163)
7	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 75)
8	Symfony\Component\HttpKernel\HttpKernel->handle (line 202)
9	Symfony\Component\HttpKernel\Kernel->handle (line 42)

0.35 ms
(0.33%)

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:

  0 of 0   
[▼
  "default_thumbnail_size"
]

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 = 'default_thumbnail_size' LIMIT 1;

#	File/Call
1	Doctrine\DBAL\Logging\LoggerChain->startQuery (line 1294)
2	Doctrine\DBAL\Connection->executeQuery (line 750)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 241)
4	Doctrine\ORM\EntityRepository->findOneBy (line 76)
5	NexCRM\BaseBundle\Service\ImagineExtension->initMaxSize (line 50)
6	NexCRM\BaseBundle\Service\ImagineExtension->filter (line 94)
7	__TwigTemplate_174fa8555b9190bdcf222e352a0d083908ff519e9cb429f9b3efe43a06313a07->doDisplay (line 394)
8	Twig\Template->displayWithErrorHandling (line 367)
9	Twig\Template->display (line 61)
10	__TwigTemplate_148ce474357114874ae3815eb8c2ea9f7de2ac87360f883d14d0db50be1eec5f->doDisplay (line 394)
11	Twig\Template->displayWithErrorHandling (line 367)
12	Twig\Template->display (line 69)
13	__TwigTemplate_474bb8e2056b04e51b514c29a16b5e1c037f744361a26b7e1109ad8e51b2fa99->doDisplay (line 394)
14	Twig\Template->displayWithErrorHandling (line 367)
15	Twig\Template->display (line 74)
16	__TwigTemplate_f4c2710d6a0300a0d5e020bf4c9ab946165bcf56185bec2f2ac667f2a4fd8a7f->block_content (line 171)
17	Twig\Template->displayBlock (line 216)
18	__TwigTemplate_8977e40c3ea85b046ee507356db6d413d33959d7f59c852b3e046ef6f470f750->doDisplay (line 394)
19	Twig\Template->displayWithErrorHandling (line 367)
20	Twig\Template->display (line 57)
21	__TwigTemplate_0c1c9c79e3045f62ba0a13788fdba506af56c668b4917774c7305efb4dd0dcd2->doDisplay (line 394)
22	Twig\Template->displayWithErrorHandling (line 367)
23	Twig\Template->display (line 48)
24	__TwigTemplate_f4c2710d6a0300a0d5e020bf4c9ab946165bcf56185bec2f2ac667f2a4fd8a7f->doDisplay (line 394)
25	Twig\Template->displayWithErrorHandling (line 367)
26	Twig\Template->display (line 379)
27	Twig\Template->render (line 40)
28	Twig\TemplateWrapper->render (line 280)
29	Twig\Environment->render (line 258)
30	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->renderView (line 266)
31	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 107)
32	App\Controller\BaseController->render (line 40)
33	App\Controller\CategoryController->indexAction (line 163)
34	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 75)
35	Symfony\Component\HttpKernel\HttpKernel->handle (line 202)
36	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\Setting	No errors.
NexCRM\BaseBundle\Entity\Country	No errors.
NexCRM\BaseBundle\Entity\SettingTranslation	No errors.
NexCRM\WebBundle\Entity\Page	No errors.
NexCRM\WebBundle\Entity\SEO	No errors.
NexCRM\WebBundle\Entity\Template	No errors.
NexCRM\BaseBundle\Entity\MediaFile	No errors.
NexCRM\DMSBundle\Entity\File	No errors.
NexCRM\WebBundle\Entity\Content	No errors.
NexCRM\WebBundle\Entity\PageTranslation	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\WebBundle\Entity\MenuTranslation	No errors.
NexCRM\WebBundle\Entity\SEOTranslation	No errors.
NexCRM\WebBundle\Entity\ModuleTranslation	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.
App\Entity\Category	No errors.
App\Entity\CategoryTranslation	No errors.
NexCRM\WebBundle\Entity\Slider	No errors.
NexCRM\WebBundle\Entity\SliderGroup	No errors.
NexCRM\WebBundle\Entity\Block	No errors.
App\Entity\Estate	No errors.
App\Entity\Tag	No errors.
App\Entity\EstateTranslation	No errors.
NexCRM\WebBundle\Entity\TemplateTranslation	No errors.
App\Entity\Service	No errors.
App\Entity\ServiceTranslation	No errors.
App\Entity\Agent	No errors.
App\Entity\AgentTranslation	No errors.
App\Entity\Project	No errors.
App\Entity\ProjectTranslation	No errors.
App\Entity\Reference	No errors.
App\Entity\ReferenceTranslation	No errors.
NexCRM\BaseBundle\Entity\LangToken	No errors.
NexCRM\WebBundle\Entity\Code	No errors.
NexCRM\WebBundle\Entity\CodeTranslation	No errors.
App\Entity\TagTranslation	No errors.
NexCRM\BaseBundle\Entity\Folder	No errors.
NexCRM\BaseBundle\Entity\MediaFileTranslation	No errors.
NexCRM\BaseBundle\Entity\MediaOrderRecord	No errors.

Symfony Profiler

http://dev80.nexgen.cz/en/houses

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Entities Mapping