Symfony Profiler

Query Metrics

279 Database Queries

46 Different statements

53.75 ms Query time

3 Invalid entities

14853 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

10.30 ms
(19.17%)

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, t5.alias AS alias_6, t5.value AS value_7, t5.id AS id_8 FROM setting_translation t0 LEFT JOIN setting t5 ON t0.translatable_id = t5.id WHERE t0.translatable_id = ?

Parameters:

[
  2
]

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,
  t5.alias AS alias_6,
  t5.value AS value_7,
  t5.id AS id_8
FROM
  setting_translation t0
  LEFT JOIN setting t5 ON t0.translatable_id = t5.id
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, t5.alias AS alias_6, t5.value AS value_7, t5.id AS id_8 FROM setting_translation t0 LEFT JOIN setting t5 ON t0.translatable_id = t5.id WHERE t0.translatable_id = 2;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getOneToManyStatement (line 1872)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToManyCollection (line 1817)
3	Doctrine\ORM\UnitOfWork->loadCollection (line 2729)
4	Doctrine\ORM\UnitOfWork->createEntity (line 2608)
5	Doctrine\ORM\Internal\Hydration\ObjectHydrator->getEntity (line 268)
6	Doctrine\ORM\Internal\Hydration\ObjectHydrator->hydrateRowData (line 495)
7	Doctrine\ORM\Internal\Hydration\ObjectHydrator->hydrateAllData (line 147)
8	Doctrine\ORM\Internal\Hydration\AbstractHydrator->hydrateAll (line 175)
9	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 943)
10	Doctrine\ORM\AbstractQuery->execute (line 886)
11	Doctrine\ORM\AbstractQuery->getResult (line 688)
12	NexCRM\BaseBundle\Repository\SettingRepository->findBaseValues (line 31)
13	App\Service\CompanyTariffPaymentHelper->__construct (line 49)
14	ContainerM1ijjA9\App_KernelDevDebugContainer->getCompanyTariffPaymentHelperService (line 3094)
15	ContainerM1ijjA9\getTariffChangeListenerService::do (line 38)
16	ContainerM1ijjA9\App_KernelDevDebugContainer::load (line 1282)
17	Symfony\Component\DependencyInjection\Container->getService (line 399)
18	Symfony\Component\DependencyInjection\Argument\ServiceLocator->get (line 36)
19	Symfony\Bridge\Doctrine\ContainerAwareEventManager->initializeListeners (line 169)
20	Symfony\Bridge\Doctrine\ContainerAwareEventManager->getAllListeners (line 80)
21	Gedmo\Sortable\Entity\Repository\SortableRepository->__construct (line 55)
22	Doctrine\Bundle\DoctrineBundle\Repository\ContainerRepositoryFactory->getOrCreateRepository (line 116)
23	Doctrine\Bundle\DoctrineBundle\Repository\ContainerRepositoryFactory->doGetRepository (line 93)
24	Doctrine\Bundle\DoctrineBundle\Repository\ContainerRepositoryFactory->getRepository (line 29)
25	Doctrine\ORM\EntityManager->getRepository (line 499)
26	App\Service\InvoiceManager->__construct (line 102)
27	ContainerM1ijjA9\App_KernelDevDebugContainer->getInvoiceManagerService (line 3359)
28	ContainerM1ijjA9\getInvoiceDoctrineListenerService::do (line 33)
29	ContainerM1ijjA9\App_KernelDevDebugContainer::load (line 1271)
30	Symfony\Component\DependencyInjection\Container->getService (line 399)
31	Symfony\Component\DependencyInjection\Argument\ServiceLocator->get (line 36)
32	Symfony\Bridge\Doctrine\ContainerAwareEventManager->initializeListeners (line 169)
33	Symfony\Bridge\Doctrine\ContainerAwareEventManager->getAllListeners (line 80)
34	Gedmo\Sortable\Entity\Repository\SortableRepository->__construct (line 55)
35	Doctrine\Bundle\DoctrineBundle\Repository\ContainerRepositoryFactory->getOrCreateRepository (line 116)
36	Doctrine\Bundle\DoctrineBundle\Repository\ContainerRepositoryFactory->doGetRepository (line 93)
37	Doctrine\Bundle\DoctrineBundle\Repository\ContainerRepositoryFactory->getRepository (line 29)
38	Doctrine\ORM\EntityManager->getRepository (line 499)
39	App\Service\InvoiceManager->__construct (line 102)
40	ContainerM1ijjA9\App_KernelDevDebugContainer->getInvoiceManagerService (line 3359)
41	ContainerM1ijjA9\getInvoiceDoctrineListenerService::do (line 33)
42	ContainerM1ijjA9\App_KernelDevDebugContainer::load (line 1271)
43	Symfony\Component\DependencyInjection\Container->getService (line 399)
44	Symfony\Component\DependencyInjection\Argument\ServiceLocator->get (line 36)
45	Symfony\Bridge\Doctrine\ContainerAwareEventManager->initializeListeners (line 169)
46	Symfony\Bridge\Doctrine\ContainerAwareEventManager->getAllListeners (line 80)
47	Gedmo\Sortable\Entity\Repository\SortableRepository->__construct (line 55)
48	Doctrine\Bundle\DoctrineBundle\Repository\ContainerRepositoryFactory->getOrCreateRepository (line 116)
49	Doctrine\Bundle\DoctrineBundle\Repository\ContainerRepositoryFactory->doGetRepository (line 93)
50	Doctrine\Bundle\DoctrineBundle\Repository\ContainerRepositoryFactory->getRepository (line 29)
51	Doctrine\ORM\EntityManager->getRepository (line 499)
52	App\Service\InvoiceManager->__construct (line 102)
53	ContainerM1ijjA9\App_KernelDevDebugContainer->getInvoiceManagerService (line 3359)
54	ContainerM1ijjA9\getInvoiceDoctrineListenerService::do (line 33)
55	ContainerM1ijjA9\App_KernelDevDebugContainer::load (line 1282)
56	Symfony\Component\DependencyInjection\Container->getService (line 399)
57	Symfony\Component\DependencyInjection\Argument\ServiceLocator->get (line 36)
58	Symfony\Bridge\Doctrine\ContainerAwareEventManager->initializeListeners (line 169)
59	Symfony\Bridge\Doctrine\ContainerAwareEventManager->getAllListeners (line 80)
60	Gedmo\Sortable\Entity\Repository\SortableRepository->__construct (line 55)
61	Doctrine\Bundle\DoctrineBundle\Repository\ContainerRepositoryFactory->getOrCreateRepository (line 116)
62	Doctrine\Bundle\DoctrineBundle\Repository\ContainerRepositoryFactory->doGetRepository (line 93)
63	Doctrine\Bundle\DoctrineBundle\Repository\ContainerRepositoryFactory->getRepository (line 29)
64	Doctrine\ORM\EntityManager->getRepository (line 499)
65	App\Service\InvoiceManager->__construct (line 102)
66	ContainerM1ijjA9\App_KernelDevDebugContainer->getInvoiceManagerService (line 3359)
67	ContainerM1ijjA9\App_KernelDevDebugContainer::getTwigService (line 5594)
68	ContainerM1ijjA9\getPdfGeneratorService::do (line 28)
69	ContainerM1ijjA9\App_KernelDevDebugContainer::load (line 1282)
70	ContainerM1ijjA9\getInvoiceHistoryHelperService->do (line 38)
71	ContainerM1ijjA9\App_KernelDevDebugContainer::load (line 1282)
72	ContainerM1ijjA9\getCRUDPostPersistListenerService->do (line 28)
73	ContainerM1ijjA9\App_KernelDevDebugContainer::load (line 1282)
74	Symfony\Component\DependencyInjection\Container->getService (line 399)
75	Symfony\Component\DependencyInjection\Argument\ServiceLocator->get (line 36)
76	Symfony\Bridge\Doctrine\ContainerAwareEventManager->initializeListeners (line 169)
77	Symfony\Bridge\Doctrine\ContainerAwareEventManager->getAllListeners (line 80)
78	Gedmo\Sortable\Entity\Repository\SortableRepository->__construct (line 55)
79	Doctrine\Bundle\DoctrineBundle\Repository\ContainerRepositoryFactory->getOrCreateRepository (line 116)
80	Doctrine\Bundle\DoctrineBundle\Repository\ContainerRepositoryFactory->doGetRepository (line 93)
81	Doctrine\Bundle\DoctrineBundle\Repository\ContainerRepositoryFactory->getRepository (line 29)
82	Doctrine\ORM\EntityManager->getRepository (line 499)
83	NexCRM\BaseBundle\EventListener\LocaleListener->onKernelRequest (line 28)
84	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
85	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
86	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
87	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 126)
88	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 159)
89	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
90	Symfony\Component\HttpKernel\Kernel->handle (line 182)
91	handle (line 46)

6.83 ms
(12.72%)

SELECT t0.token AS token_1, t0.id AS id_2 FROM lang_token t0

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.token AS token_1,
  t0.id AS id_2
FROM
  lang_token t0

SELECT t0.token AS token_1, t0.id AS id_2 FROM lang_token t0;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 963)
2	Doctrine\ORM\EntityRepository->findBy (line 110)
3	Doctrine\ORM\EntityRepository->findAll (line 96)
4	NexCRM\BaseBundle\Service\DBLoader->load (line 46)
5	Symfony\Component\Translation\Translator->doLoadCatalogue (line 378)
6	Symfony\Bundle\FrameworkBundle\Translation\Translator->doLoadCatalogue (line 135)
7	Symfony\Component\Translation\Translator->initializeCatalogue (line 272)
8	Symfony\Bundle\FrameworkBundle\Translation\Translator->initializeCatalogue (line 127)
9	Symfony\Component\Translation\Translator->loadCatalogue (line 261)
10	Symfony\Component\Translation\Translator->getCatalogue (line 237)
11	Symfony\Component\Translation\Translator->trans (line 187)
12	Symfony\Component\Translation\DataCollectorTranslator->trans (line 38)
13	NexCRM\BaseBundle\Service\Translator->trans (line 35)
14	Symfony\Bridge\Twig\Extension\TranslationExtension->trans (line 122)
15	__TwigTemplate_8cd3113afc76e811472d1bc721192c7d->doDisplay (line 252)
16	Twig\Template->yield (line 402)
17	__TwigTemplate_696542a229d5bd8419771cec448ad1bf->block_header (line 153)
18	Twig\Template->yieldBlock (line 446)
19	__TwigTemplate_696542a229d5bd8419771cec448ad1bf->doDisplay (line 51)
20	Twig\Template->yield (line 402)
21	__TwigTemplate_6297adad81ba504558373f6a3f63c93f->doDisplay (line 53)
22	Twig\Template->yield (line 402)
23	Twig\Template->display (line 358)
24	Twig\Template->render (line 373)
25	Twig\TemplateWrapper->render (line 51)
26	Twig\Environment->render (line 333)
27	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 463)
28	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 468)
29	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 282)
30	App\Controller\BaseController->render (line 57)
31	App\Controller\PageController->pageAction (line 46)
32	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
33	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
34	Symfony\Component\HttpKernel\Kernel->handle (line 182)
35	handle (line 46)

6.74 ms
(12.54%)

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

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

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

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

#	File/Call
1	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 27)
2	Doctrine\ORM\Query->_doExecute (line 296)
3	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 930)
4	Doctrine\ORM\AbstractQuery->execute (line 886)
5	Doctrine\ORM\AbstractQuery->getResult (line 688)
6	NexCRM\BaseBundle\Service\Translator->checkToken (line 76)
7	NexCRM\BaseBundle\Service\Translator->trans (line 34)
8	Symfony\Bridge\Twig\Extension\TranslationExtension->trans (line 122)
9	__TwigTemplate_8cd3113afc76e811472d1bc721192c7d->doDisplay (line 252)
10	Twig\Template->yield (line 402)
11	__TwigTemplate_696542a229d5bd8419771cec448ad1bf->block_header (line 153)
12	Twig\Template->yieldBlock (line 446)
13	__TwigTemplate_696542a229d5bd8419771cec448ad1bf->doDisplay (line 51)
14	Twig\Template->yield (line 402)
15	__TwigTemplate_6297adad81ba504558373f6a3f63c93f->doDisplay (line 53)
16	Twig\Template->yield (line 402)
17	Twig\Template->display (line 358)
18	Twig\Template->render (line 373)
19	Twig\TemplateWrapper->render (line 51)
20	Twig\Environment->render (line 333)
21	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 463)
22	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 468)
23	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 282)
24	App\Controller\BaseController->render (line 57)
25	App\Controller\PageController->pageAction (line 46)
26	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
27	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
28	Symfony\Component\HttpKernel\Kernel->handle (line 182)
29	handle (line 46)

5.35 ms
(9.96%)

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

Parameters:

[
  4
]

View formatted query View runnable query Explain query View query backtrace

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

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

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 738)
2	Doctrine\ORM\EntityRepository->findOneBy (line 125)
3	NexCRM\WebBundle\Repository\MenuRepository->findByGroupOrdered (line 33)
4	App\Controller\BaseController->initialize (line 77)
5	App\Controller\PageController->pageAction (line 18)
6	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
7	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
8	Symfony\Component\HttpKernel\Kernel->handle (line 182)
9	handle (line 46)

2.77 ms
(5.15%)

SELECT t0.name AS name_1, t0.title AS title_2, t0.short_text AS short_text_3, t0.text AS text_4, t0.id AS id_5, t0.locale AS locale_6, t0.translatable_id AS translatable_id_7, t8.homepage AS homepage_9, t8.doc_files_order AS doc_files_order_10, t8.id AS id_11, t8.sort AS sort_12, t8.img_files_order AS img_files_order_13, t8.dms_img_updated AS dms_img_updated_14, t8.parent AS parent_15, t8.seo_id AS seo_id_16, t8.template_id AS template_id_17, t8.img_file_id AS img_file_id_18, t8.doc_file_id AS doc_file_id_19 FROM web_page_translation t0 LEFT JOIN web_page t8 ON t0.translatable_id = t8.id WHERE t0.translatable_id = ?

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.name AS name_1,
  t0.title AS title_2,
  t0.short_text AS short_text_3,
  t0.text AS text_4,
  t0.id AS id_5,
  t0.locale AS locale_6,
  t0.translatable_id AS translatable_id_7,
  t8.homepage AS homepage_9,
  t8.doc_files_order AS doc_files_order_10,
  t8.id AS id_11,
  t8.sort AS sort_12,
  t8.img_files_order AS img_files_order_13,
  t8.dms_img_updated AS dms_img_updated_14,
  t8.parent AS parent_15,
  t8.seo_id AS seo_id_16,
  t8.template_id AS template_id_17,
  t8.img_file_id AS img_file_id_18,
  t8.doc_file_id AS doc_file_id_19
FROM
  web_page_translation t0
  LEFT JOIN web_page t8 ON t0.translatable_id = t8.id
WHERE
  t0.translatable_id = ?

SELECT t0.name AS name_1, t0.title AS title_2, t0.short_text AS short_text_3, t0.text AS text_4, t0.id AS id_5, t0.locale AS locale_6, t0.translatable_id AS translatable_id_7, t8.homepage AS homepage_9, t8.doc_files_order AS doc_files_order_10, t8.id AS id_11, t8.sort AS sort_12, t8.img_files_order AS img_files_order_13, t8.dms_img_updated AS dms_img_updated_14, t8.parent AS parent_15, t8.seo_id AS seo_id_16, t8.template_id AS template_id_17, t8.img_file_id AS img_file_id_18, t8.doc_file_id AS doc_file_id_19 FROM web_page_translation t0 LEFT JOIN web_page t8 ON t0.translatable_id = t8.id WHERE t0.translatable_id = 1;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getOneToManyStatement (line 1872)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToManyCollection (line 1817)
3	Doctrine\ORM\UnitOfWork->loadCollection (line 2729)
4	Doctrine\ORM\UnitOfWork->createEntity (line 2608)
5	Doctrine\ORM\Internal\Hydration\SimpleObjectHydrator->hydrateRowData (line 176)
6	Doctrine\ORM\Internal\Hydration\SimpleObjectHydrator->hydrateAllData (line 60)
7	Doctrine\ORM\Internal\Hydration\AbstractHydrator->hydrateAll (line 175)
8	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 967)
9	Doctrine\ORM\EntityRepository->findBy (line 110)
10	App\Controller\BaseController->initialize (line 72)
11	App\Controller\PageController->pageAction (line 18)
12	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
13	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
14	Symfony\Component\HttpKernel\Kernel->handle (line 182)
15	handle (line 46)

1.67 ms
(3.11%)

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, t6.link_id AS link_id_7, t6.url AS url_8, t6.active AS active_9, t6.id AS id_10, t6.sort AS sort_11, t6.parent AS parent_12, t6.module_id AS module_id_13, t6.img_file_id AS img_file_id_14 FROM web_menu_translation t0 LEFT JOIN web_menu t6 ON t0.translatable_id = t6.id WHERE t0.translatable_id = ?

Parameters:

[
  16
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.name AS name_1,
  t0.disabled AS disabled_2,
  t0.id AS id_3,
  t0.locale AS locale_4,
  t0.translatable_id AS translatable_id_5,
  t6.link_id AS link_id_7,
  t6.url AS url_8,
  t6.active AS active_9,
  t6.id AS id_10,
  t6.sort AS sort_11,
  t6.parent AS parent_12,
  t6.module_id AS module_id_13,
  t6.img_file_id AS img_file_id_14
FROM
  web_menu_translation t0
  LEFT JOIN web_menu t6 ON t0.translatable_id = t6.id
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, t6.link_id AS link_id_7, t6.url AS url_8, t6.active AS active_9, t6.id AS id_10, t6.sort AS sort_11, t6.parent AS parent_12, t6.module_id AS module_id_13, t6.img_file_id AS img_file_id_14 FROM web_menu_translation t0 LEFT JOIN web_menu t6 ON t0.translatable_id = t6.id WHERE t0.translatable_id = 16;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getOneToManyStatement (line 1872)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToManyCollection (line 1817)
3	Doctrine\ORM\UnitOfWork->loadCollection (line 2729)
4	Doctrine\ORM\UnitOfWork->createEntity (line 2608)
5	Doctrine\ORM\Internal\Hydration\ObjectHydrator->getEntity (line 268)
6	Doctrine\ORM\Internal\Hydration\ObjectHydrator->hydrateRowData (line 495)
7	Doctrine\ORM\Internal\Hydration\ObjectHydrator->hydrateAllData (line 147)
8	Doctrine\ORM\Internal\Hydration\AbstractHydrator->hydrateAll (line 175)
9	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 943)
10	Doctrine\ORM\AbstractQuery->execute (line 886)
11	Doctrine\ORM\AbstractQuery->getResult (line 688)
12	NexCRM\WebBundle\Repository\MenuRepository->findByGroupOrdered (line 24)
13	App\Controller\BaseController->initialize (line 77)
14	App\Controller\PageController->pageAction (line 18)
15	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
16	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
17	Symfony\Component\HttpKernel\Kernel->handle (line 182)
18	handle (line 46)

1.57 ms
(2.92%)

SELECT v0_.name AS name_0, v0_.rate AS rate_1, v0_.valid_from AS valid_from_2, v0_.valid_to AS valid_to_3, v0_.type AS type_4, v0_.kind AS kind_5, v0_.calc_without_vat AS calc_without_vat_6, v0_.calc_with_vat AS calc_with_vat_7, v0_.rounding AS rounding_8, v0_.rounding_direction AS rounding_direction_9, v0_.program AS program_10, v0_.hide_in_list AS hide_in_list_11, v0_.is_default AS is_default_12, v0_.company_invoice AS company_invoice_13, v0_.company_package AS company_package_14, v0_.id AS id_15, v0_.previous_id AS previous_id_16, v0_.account_company_id AS account_company_id_17, v0_.account_organization_id AS account_organization_id_18 FROM vat v0_ WHERE v0_.valid_from <= ? AND (v0_.valid_to >= ? OR v0_.valid_to IS NULL) AND (v0_.company_invoice = 1 OR v0_.type = ?) ORDER BY v0_.company_invoice DESC, v0_.type DESC LIMIT 1

Parameters:

[
  "2025-12-08"
  "2025-12-08"
  "other"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  v0_.name AS name_0,
  v0_.rate AS rate_1,
  v0_.valid_from AS valid_from_2,
  v0_.valid_to AS valid_to_3,
  v0_.type AS type_4,
  v0_.kind AS kind_5,
  v0_.calc_without_vat AS calc_without_vat_6,
  v0_.calc_with_vat AS calc_with_vat_7,
  v0_.rounding AS rounding_8,
  v0_.rounding_direction AS rounding_direction_9,
  v0_.program AS program_10,
  v0_.hide_in_list AS hide_in_list_11,
  v0_.is_default AS is_default_12,
  v0_.company_invoice AS company_invoice_13,
  v0_.company_package AS company_package_14,
  v0_.id AS id_15,
  v0_.previous_id AS previous_id_16,
  v0_.account_company_id AS account_company_id_17,
  v0_.account_organization_id AS account_organization_id_18
FROM
  vat v0_
WHERE
  v0_.valid_from <= ?
  AND (
    v0_.valid_to >= ?
    OR v0_.valid_to IS NULL
  )
  AND (
    v0_.company_invoice = 1
    OR v0_.type = ?
  )
ORDER BY
  v0_.company_invoice DESC,
  v0_.type DESC
LIMIT
  1

SELECT v0_.name AS name_0, v0_.rate AS rate_1, v0_.valid_from AS valid_from_2, v0_.valid_to AS valid_to_3, v0_.type AS type_4, v0_.kind AS kind_5, v0_.calc_without_vat AS calc_without_vat_6, v0_.calc_with_vat AS calc_with_vat_7, v0_.rounding AS rounding_8, v0_.rounding_direction AS rounding_direction_9, v0_.program AS program_10, v0_.hide_in_list AS hide_in_list_11, v0_.is_default AS is_default_12, v0_.company_invoice AS company_invoice_13, v0_.company_package AS company_package_14, v0_.id AS id_15, v0_.previous_id AS previous_id_16, v0_.account_company_id AS account_company_id_17, v0_.account_organization_id AS account_organization_id_18 FROM vat v0_ WHERE v0_.valid_from <= '2025-12-08' AND (v0_.valid_to >= '2025-12-08' OR v0_.valid_to IS NULL) AND (v0_.company_invoice = 1 OR v0_.type = 'other') ORDER BY v0_.company_invoice DESC, v0_.type DESC LIMIT 1;

#	File/Call
1	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 27)
2	Doctrine\ORM\Query->_doExecute (line 296)
3	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 930)
4	Doctrine\ORM\AbstractQuery->execute (line 886)
5	Doctrine\ORM\AbstractQuery->getOneOrNullResult (line 737)
6	App\Repository\VatRepository->getCompanyInvoice (line 168)
7	App\Service\InvoiceManager->__construct (line 102)
8	ContainerM1ijjA9\App_KernelDevDebugContainer->getInvoiceManagerService (line 3359)
9	ContainerM1ijjA9\getInvoiceDoctrineListenerService::do (line 33)
10	ContainerM1ijjA9\App_KernelDevDebugContainer::load (line 1271)
11	Symfony\Component\DependencyInjection\Container->getService (line 399)
12	Symfony\Component\DependencyInjection\Argument\ServiceLocator->get (line 36)
13	Symfony\Bridge\Doctrine\ContainerAwareEventManager->initializeListeners (line 169)
14	Symfony\Bridge\Doctrine\ContainerAwareEventManager->getAllListeners (line 80)
15	Gedmo\Sortable\Entity\Repository\SortableRepository->__construct (line 55)
16	Doctrine\Bundle\DoctrineBundle\Repository\ContainerRepositoryFactory->getOrCreateRepository (line 116)
17	Doctrine\Bundle\DoctrineBundle\Repository\ContainerRepositoryFactory->doGetRepository (line 93)
18	Doctrine\Bundle\DoctrineBundle\Repository\ContainerRepositoryFactory->getRepository (line 29)
19	Doctrine\ORM\EntityManager->getRepository (line 499)
20	App\Service\InvoiceManager->__construct (line 102)
21	ContainerM1ijjA9\App_KernelDevDebugContainer->getInvoiceManagerService (line 3359)
22	ContainerM1ijjA9\getFileDeletedDoctrineListenerService::do (line 28)
23	ContainerM1ijjA9\App_KernelDevDebugContainer::load (line 1282)
24	Symfony\Component\DependencyInjection\Container->getService (line 399)
25	Symfony\Component\DependencyInjection\Argument\ServiceLocator->get (line 36)
26	Symfony\Bridge\Doctrine\ContainerAwareEventManager->initializeListeners (line 169)
27	Symfony\Bridge\Doctrine\ContainerAwareEventManager->getAllListeners (line 80)
28	Gedmo\Sortable\Entity\Repository\SortableRepository->__construct (line 55)
29	Doctrine\Bundle\DoctrineBundle\Repository\ContainerRepositoryFactory->getOrCreateRepository (line 116)
30	Doctrine\Bundle\DoctrineBundle\Repository\ContainerRepositoryFactory->doGetRepository (line 93)
31	Doctrine\Bundle\DoctrineBundle\Repository\ContainerRepositoryFactory->getRepository (line 29)
32	Doctrine\ORM\EntityManager->getRepository (line 499)
33	App\Service\InvoiceManager->__construct (line 102)
34	ContainerM1ijjA9\App_KernelDevDebugContainer->getInvoiceManagerService (line 3359)
35	ContainerM1ijjA9\App_KernelDevDebugContainer::getCompanyTariffPaymentHelperService (line 3068)
36	ContainerM1ijjA9\getTariffChangeListenerService::do (line 38)
37	ContainerM1ijjA9\App_KernelDevDebugContainer::load (line 1282)
38	Symfony\Component\DependencyInjection\Container->getService (line 399)
39	Symfony\Component\DependencyInjection\Argument\ServiceLocator->get (line 36)
40	Symfony\Bridge\Doctrine\ContainerAwareEventManager->initializeListeners (line 169)
41	Symfony\Bridge\Doctrine\ContainerAwareEventManager->getAllListeners (line 80)
42	Gedmo\Sortable\Entity\Repository\SortableRepository->__construct (line 55)
43	Doctrine\Bundle\DoctrineBundle\Repository\ContainerRepositoryFactory->getOrCreateRepository (line 116)
44	Doctrine\Bundle\DoctrineBundle\Repository\ContainerRepositoryFactory->doGetRepository (line 93)
45	Doctrine\Bundle\DoctrineBundle\Repository\ContainerRepositoryFactory->getRepository (line 29)
46	Doctrine\ORM\EntityManager->getRepository (line 499)
47	App\Service\InvoiceManager->__construct (line 102)
48	ContainerM1ijjA9\App_KernelDevDebugContainer->getInvoiceManagerService (line 3359)
49	ContainerM1ijjA9\getInvoiceDoctrineListenerService::do (line 33)
50	ContainerM1ijjA9\App_KernelDevDebugContainer::load (line 1271)
51	Symfony\Component\DependencyInjection\Container->getService (line 399)
52	Symfony\Component\DependencyInjection\Argument\ServiceLocator->get (line 36)
53	Symfony\Bridge\Doctrine\ContainerAwareEventManager->initializeListeners (line 169)
54	Symfony\Bridge\Doctrine\ContainerAwareEventManager->getAllListeners (line 80)
55	Gedmo\Sortable\Entity\Repository\SortableRepository->__construct (line 55)
56	Doctrine\Bundle\DoctrineBundle\Repository\ContainerRepositoryFactory->getOrCreateRepository (line 116)
57	Doctrine\Bundle\DoctrineBundle\Repository\ContainerRepositoryFactory->doGetRepository (line 93)
58	Doctrine\Bundle\DoctrineBundle\Repository\ContainerRepositoryFactory->getRepository (line 29)
59	Doctrine\ORM\EntityManager->getRepository (line 499)
60	App\Service\InvoiceManager->__construct (line 102)
61	ContainerM1ijjA9\App_KernelDevDebugContainer->getInvoiceManagerService (line 3359)
62	ContainerM1ijjA9\getInvoiceDoctrineListenerService::do (line 33)
63	ContainerM1ijjA9\App_KernelDevDebugContainer::load (line 1271)
64	Symfony\Component\DependencyInjection\Container->getService (line 399)
65	Symfony\Component\DependencyInjection\Argument\ServiceLocator->get (line 36)
66	Symfony\Bridge\Doctrine\ContainerAwareEventManager->initializeListeners (line 169)
67	Symfony\Bridge\Doctrine\ContainerAwareEventManager->getAllListeners (line 80)
68	Gedmo\Sortable\Entity\Repository\SortableRepository->__construct (line 55)
69	Doctrine\Bundle\DoctrineBundle\Repository\ContainerRepositoryFactory->getOrCreateRepository (line 116)
70	Doctrine\Bundle\DoctrineBundle\Repository\ContainerRepositoryFactory->doGetRepository (line 93)
71	Doctrine\Bundle\DoctrineBundle\Repository\ContainerRepositoryFactory->getRepository (line 29)
72	Doctrine\ORM\EntityManager->getRepository (line 499)
73	App\Service\InvoiceManager->__construct (line 102)
74	ContainerM1ijjA9\App_KernelDevDebugContainer->getInvoiceManagerService (line 3359)
75	ContainerM1ijjA9\getInvoiceDoctrineListenerService::do (line 33)
76	ContainerM1ijjA9\App_KernelDevDebugContainer::load (line 1282)
77	Symfony\Component\DependencyInjection\Container->getService (line 399)
78	Symfony\Component\DependencyInjection\Argument\ServiceLocator->get (line 36)
79	Symfony\Bridge\Doctrine\ContainerAwareEventManager->initializeListeners (line 169)
80	Symfony\Bridge\Doctrine\ContainerAwareEventManager->getAllListeners (line 80)
81	Gedmo\Sortable\Entity\Repository\SortableRepository->__construct (line 55)
82	Doctrine\Bundle\DoctrineBundle\Repository\ContainerRepositoryFactory->getOrCreateRepository (line 116)
83	Doctrine\Bundle\DoctrineBundle\Repository\ContainerRepositoryFactory->doGetRepository (line 93)
84	Doctrine\Bundle\DoctrineBundle\Repository\ContainerRepositoryFactory->getRepository (line 29)
85	Doctrine\ORM\EntityManager->getRepository (line 499)
86	App\Service\InvoiceManager->__construct (line 102)
87	ContainerM1ijjA9\App_KernelDevDebugContainer->getInvoiceManagerService (line 3359)
88	ContainerM1ijjA9\App_KernelDevDebugContainer::getTwigService (line 5594)
89	ContainerM1ijjA9\getPdfGeneratorService::do (line 28)
90	ContainerM1ijjA9\App_KernelDevDebugContainer::load (line 1282)
91	ContainerM1ijjA9\getInvoiceHistoryHelperService->do (line 38)
92	ContainerM1ijjA9\App_KernelDevDebugContainer::load (line 1282)
93	ContainerM1ijjA9\getCRUDPostPersistListenerService->do (line 28)
94	ContainerM1ijjA9\App_KernelDevDebugContainer::load (line 1282)
95	Symfony\Component\DependencyInjection\Container->getService (line 399)
96	Symfony\Component\DependencyInjection\Argument\ServiceLocator->get (line 36)
97	Symfony\Bridge\Doctrine\ContainerAwareEventManager->initializeListeners (line 169)
98	Symfony\Bridge\Doctrine\ContainerAwareEventManager->getAllListeners (line 80)
99	Gedmo\Sortable\Entity\Repository\SortableRepository->__construct (line 55)
100	Doctrine\Bundle\DoctrineBundle\Repository\ContainerRepositoryFactory->getOrCreateRepository (line 116)
101	Doctrine\Bundle\DoctrineBundle\Repository\ContainerRepositoryFactory->doGetRepository (line 93)
102	Doctrine\Bundle\DoctrineBundle\Repository\ContainerRepositoryFactory->getRepository (line 29)
103	Doctrine\ORM\EntityManager->getRepository (line 499)
104	NexCRM\BaseBundle\EventListener\LocaleListener->onKernelRequest (line 28)
105	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
106	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
107	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
108	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 126)
109	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 159)
110	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
111	Symfony\Component\HttpKernel\Kernel->handle (line 182)
112	handle (line 46)

1.40 ms
(2.61%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.media AS media_3, t0.updated_at AS updated_at_4, t0.file_size AS file_size_5, t0.ext AS ext_6, t0.preview AS preview_7, t0.pdf_preview AS pdf_preview_8, t0.deleted AS deleted_9, t0.deleted_at AS deleted_at_10, t0.seo AS seo_11, t0.height AS height_12, t0.width AS width_13, t0.disable_dynamic_fields AS disable_dynamic_fields_14, t0.disable_preview AS disable_preview_15, t0.duplicity_check AS duplicity_check_16, t0.change_check AS change_check_17, t0.recalculate AS recalculate_18, t0.diary AS diary_19, t0.state_close AS state_close_20, t0.date_control AS date_control_21, t0.warning_price AS warning_price_22, t0.warning_contact AS warning_contact_23, t0.from_api AS from_api_24, t0.created_at AS created_at_25, t0.isdoc AS isdoc_26, t0.folder_id AS folder_id_27, t28.id AS id_29, t28.name AS name_30, t28.description AS description_31, t28.deleted AS deleted_32, t28.deleted_at AS deleted_at_33, t28.date_representation AS date_representation_34, t28.active AS active_35, t28.undeletable AS undeletable_36, t28.editable AS editable_37, t28.auto_generate_rules AS auto_generate_rules_38, t28.auto_generate_co_workers AS auto_generate_co_workers_39, t28.persons_authorization AS persons_authorization_40, t28.duplicate_on_period AS duplicate_on_period_41, t28.title AS title_42, t28.start_balance AS start_balance_43, t28.start_balance_rate AS start_balance_rate_44, t28.recalculate_start_balance AS recalculate_start_balance_45, t28.state_close AS state_close_46, t28.in_ck AS in_ck_47, t28.parent_id AS parent_id_48, t28.company AS company_49, t28.filter_id AS filter_id_50, t28.file_type_id AS file_type_id_51, t28.numerical_root_id AS numerical_root_id_52, t28.agenda_sub_forlder_id AS agenda_sub_forlder_id_53, t28.agenda_period_id AS agenda_period_id_54, t28.period_before AS period_before_55, t28.period_after AS period_after_56, t28.should_give_id AS should_give_id_57, t28.given_id AS given_id_58, t28.department_id AS department_id_59, t28.project_id AS project_id_60, t28.activity_id AS activity_id_61, t28.payment_method_id AS payment_method_id_62, t28.currency_id AS currency_id_63, t28.account_assigment_id AS account_assigment_id_64, t28.vat_breakdown_id AS vat_breakdown_id_65, t28.numerical_root_definition_id AS numerical_root_definition_id_66, t28.bank_account_id AS bank_account_id_67, t68.file_type AS file_type_69, t68.invoice_number AS invoice_number_70, t68.variable_number AS variable_number_71, t68.contact AS contact_72, t68.price AS price_73, t68.currency AS currency_74, t68.rate AS rate_75, t68.defray AS defray_76, t68.defray_czk AS defray_czk_77, t68.is_bank_linked AS is_bank_linked_78, t68.id AS id_79, t68.file_id AS file_id_80, t68.company_id AS company_id_81, t68.should_give_id AS should_give_id_82, t83.id AS id_84, t83.file_id AS file_id_85, t83.file_type_id AS file_type_id_86, t0.last_editor_id AS last_editor_id_87, t0.previous_id AS previous_id_88, t0.next_id AS next_id_89, t0.user_id AS user_id_90 FROM dms_file t0 LEFT JOIN dms_folder t28 ON t0.folder_id = t28.id LEFT JOIN dms_file_field_data t68 ON t68.file_id = t0.id LEFT JOIN dms_file_parameters t83 ON t83.file_id = t0.id INNER JOIN page_file ON t0.id = page_file.img_file_id WHERE page_file.img_item_id = ?

Parameters:

[
  5
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.media AS media_3,
  t0.updated_at AS updated_at_4,
  t0.file_size AS file_size_5,
  t0.ext AS ext_6,
  t0.preview AS preview_7,
  t0.pdf_preview AS pdf_preview_8,
  t0.deleted AS deleted_9,
  t0.deleted_at AS deleted_at_10,
  t0.seo AS seo_11,
  t0.height AS height_12,
  t0.width AS width_13,
  t0.disable_dynamic_fields AS disable_dynamic_fields_14,
  t0.disable_preview AS disable_preview_15,
  t0.duplicity_check AS duplicity_check_16,
  t0.change_check AS change_check_17,
  t0.recalculate AS recalculate_18,
  t0.diary AS diary_19,
  t0.state_close AS state_close_20,
  t0.date_control AS date_control_21,
  t0.warning_price AS warning_price_22,
  t0.warning_contact AS warning_contact_23,
  t0.from_api AS from_api_24,
  t0.created_at AS created_at_25,
  t0.isdoc AS isdoc_26,
  t0.folder_id AS folder_id_27,
  t28.id AS id_29,
  t28.name AS name_30,
  t28.description AS description_31,
  t28.deleted AS deleted_32,
  t28.deleted_at AS deleted_at_33,
  t28.date_representation AS date_representation_34,
  t28.active AS active_35,
  t28.undeletable AS undeletable_36,
  t28.editable AS editable_37,
  t28.auto_generate_rules AS auto_generate_rules_38,
  t28.auto_generate_co_workers AS auto_generate_co_workers_39,
  t28.persons_authorization AS persons_authorization_40,
  t28.duplicate_on_period AS duplicate_on_period_41,
  t28.title AS title_42,
  t28.start_balance AS start_balance_43,
  t28.start_balance_rate AS start_balance_rate_44,
  t28.recalculate_start_balance AS recalculate_start_balance_45,
  t28.state_close AS state_close_46,
  t28.in_ck AS in_ck_47,
  t28.parent_id AS parent_id_48,
  t28.company AS company_49,
  t28.filter_id AS filter_id_50,
  t28.file_type_id AS file_type_id_51,
  t28.numerical_root_id AS numerical_root_id_52,
  t28.agenda_sub_forlder_id AS agenda_sub_forlder_id_53,
  t28.agenda_period_id AS agenda_period_id_54,
  t28.period_before AS period_before_55,
  t28.period_after AS period_after_56,
  t28.should_give_id AS should_give_id_57,
  t28.given_id AS given_id_58,
  t28.department_id AS department_id_59,
  t28.project_id AS project_id_60,
  t28.activity_id AS activity_id_61,
  t28.payment_method_id AS payment_method_id_62,
  t28.currency_id AS currency_id_63,
  t28.account_assigment_id AS account_assigment_id_64,
  t28.vat_breakdown_id AS vat_breakdown_id_65,
  t28.numerical_root_definition_id AS numerical_root_definition_id_66,
  t28.bank_account_id AS bank_account_id_67,
  t68.file_type AS file_type_69,
  t68.invoice_number AS invoice_number_70,
  t68.variable_number AS variable_number_71,
  t68.contact AS contact_72,
  t68.price AS price_73,
  t68.currency AS currency_74,
  t68.rate AS rate_75,
  t68.defray AS defray_76,
  t68.defray_czk AS defray_czk_77,
  t68.is_bank_linked AS is_bank_linked_78,
  t68.id AS id_79,
  t68.file_id AS file_id_80,
  t68.company_id AS company_id_81,
  t68.should_give_id AS should_give_id_82,
  t83.id AS id_84,
  t83.file_id AS file_id_85,
  t83.file_type_id AS file_type_id_86,
  t0.last_editor_id AS last_editor_id_87,
  t0.previous_id AS previous_id_88,
  t0.next_id AS next_id_89,
  t0.user_id AS user_id_90
FROM
  dms_file t0
  LEFT JOIN dms_folder t28 ON t0.folder_id = t28.id
  LEFT JOIN dms_file_field_data t68 ON t68.file_id = t0.id
  LEFT JOIN dms_file_parameters t83 ON t83.file_id = t0.id
  INNER JOIN page_file ON t0.id = page_file.img_file_id
WHERE
  page_file.img_item_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.media AS media_3, t0.updated_at AS updated_at_4, t0.file_size AS file_size_5, t0.ext AS ext_6, t0.preview AS preview_7, t0.pdf_preview AS pdf_preview_8, t0.deleted AS deleted_9, t0.deleted_at AS deleted_at_10, t0.seo AS seo_11, t0.height AS height_12, t0.width AS width_13, t0.disable_dynamic_fields AS disable_dynamic_fields_14, t0.disable_preview AS disable_preview_15, t0.duplicity_check AS duplicity_check_16, t0.change_check AS change_check_17, t0.recalculate AS recalculate_18, t0.diary AS diary_19, t0.state_close AS state_close_20, t0.date_control AS date_control_21, t0.warning_price AS warning_price_22, t0.warning_contact AS warning_contact_23, t0.from_api AS from_api_24, t0.created_at AS created_at_25, t0.isdoc AS isdoc_26, t0.folder_id AS folder_id_27, t28.id AS id_29, t28.name AS name_30, t28.description AS description_31, t28.deleted AS deleted_32, t28.deleted_at AS deleted_at_33, t28.date_representation AS date_representation_34, t28.active AS active_35, t28.undeletable AS undeletable_36, t28.editable AS editable_37, t28.auto_generate_rules AS auto_generate_rules_38, t28.auto_generate_co_workers AS auto_generate_co_workers_39, t28.persons_authorization AS persons_authorization_40, t28.duplicate_on_period AS duplicate_on_period_41, t28.title AS title_42, t28.start_balance AS start_balance_43, t28.start_balance_rate AS start_balance_rate_44, t28.recalculate_start_balance AS recalculate_start_balance_45, t28.state_close AS state_close_46, t28.in_ck AS in_ck_47, t28.parent_id AS parent_id_48, t28.company AS company_49, t28.filter_id AS filter_id_50, t28.file_type_id AS file_type_id_51, t28.numerical_root_id AS numerical_root_id_52, t28.agenda_sub_forlder_id AS agenda_sub_forlder_id_53, t28.agenda_period_id AS agenda_period_id_54, t28.period_before AS period_before_55, t28.period_after AS period_after_56, t28.should_give_id AS should_give_id_57, t28.given_id AS given_id_58, t28.department_id AS department_id_59, t28.project_id AS project_id_60, t28.activity_id AS activity_id_61, t28.payment_method_id AS payment_method_id_62, t28.currency_id AS currency_id_63, t28.account_assigment_id AS account_assigment_id_64, t28.vat_breakdown_id AS vat_breakdown_id_65, t28.numerical_root_definition_id AS numerical_root_definition_id_66, t28.bank_account_id AS bank_account_id_67, t68.file_type AS file_type_69, t68.invoice_number AS invoice_number_70, t68.variable_number AS variable_number_71, t68.contact AS contact_72, t68.price AS price_73, t68.currency AS currency_74, t68.rate AS rate_75, t68.defray AS defray_76, t68.defray_czk AS defray_czk_77, t68.is_bank_linked AS is_bank_linked_78, t68.id AS id_79, t68.file_id AS file_id_80, t68.company_id AS company_id_81, t68.should_give_id AS should_give_id_82, t83.id AS id_84, t83.file_id AS file_id_85, t83.file_type_id AS file_type_id_86, t0.last_editor_id AS last_editor_id_87, t0.previous_id AS previous_id_88, t0.next_id AS next_id_89, t0.user_id AS user_id_90 FROM dms_file t0 LEFT JOIN dms_folder t28 ON t0.folder_id = t28.id LEFT JOIN dms_file_field_data t68 ON t68.file_id = t0.id LEFT JOIN dms_file_parameters t83 ON t83.file_id = t0.id INNER JOIN page_file ON t0.id = page_file.img_file_id WHERE page_file.img_item_id = 5;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getManyToManyStatement (line 1106)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadManyToManyCollection (line 1035)
3	Doctrine\ORM\UnitOfWork->loadCollection (line 2733)
4	Doctrine\ORM\PersistentCollection->doInitialize (line 636)
5	Doctrine\ORM\PersistentCollection->initialize (line 186)
6	Doctrine\Common\Collections\AbstractLazyCollection->count (line 39)
7	Doctrine\ORM\PersistentCollection->count (line 391)
8	Twig\Extension\CoreExtension->length (line 1272)
9	__TwigTemplate_496d11d7262e5acab492cc857529bcdf::doDisplay (line 54)
10	Twig\Template->yield (line 402)
11	__TwigTemplate_6297adad81ba504558373f6a3f63c93f->block_content (line 148)
12	Twig\Template->yieldBlock (line 446)
13	__TwigTemplate_696542a229d5bd8419771cec448ad1bf->doDisplay (line 57)
14	Twig\Template->yield (line 402)
15	__TwigTemplate_6297adad81ba504558373f6a3f63c93f->doDisplay (line 53)
16	Twig\Template->yield (line 402)
17	Twig\Template->display (line 358)
18	Twig\Template->render (line 373)
19	Twig\TemplateWrapper->render (line 51)
20	Twig\Environment->render (line 333)
21	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 463)
22	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 468)
23	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 282)
24	App\Controller\BaseController->render (line 57)
25	App\Controller\PageController->pageAction (line 46)
26	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
27	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
28	Symfony\Component\HttpKernel\Kernel->handle (line 182)
29	handle (line 46)

1.38 ms
(2.56%)

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_.dms_file_tablet_id AS dms_file_tablet_id_9, w0_.dms_file_phone_id AS dms_file_phone_id_10, w0_.dms_video_id AS dms_video_id_11, w0_.img_file_id AS img_file_id_12 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_.dms_file_tablet_id AS dms_file_tablet_id_9,
  w0_.dms_file_phone_id AS dms_file_phone_id_10,
  w0_.dms_video_id AS dms_video_id_11,
  w0_.img_file_id AS img_file_id_12
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_.dms_file_tablet_id AS dms_file_tablet_id_9, w0_.dms_file_phone_id AS dms_file_phone_id_10, w0_.dms_video_id AS dms_video_id_11, w0_.img_file_id AS img_file_id_12 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\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 27)
2	Doctrine\ORM\Query->_doExecute (line 296)
3	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 930)
4	Doctrine\ORM\AbstractQuery->execute (line 886)
5	Doctrine\ORM\AbstractQuery->getResult (line 688)
6	NexCRM\WebBundle\Repository\SliderRepository->findByGroupOrdered (line 24)
7	App\Controller\BaseController->initialize (line 78)
8	App\Controller\PageController->pageAction (line 18)
9	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
10	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
11	Symfony\Component\HttpKernel\Kernel->handle (line 182)
12	handle (line 46)

1.25 ms
(2.32%)

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, t10.noindex AS noindex_11, t10.module AS module_12, t10.anchor AS anchor_13, t10.suffix AS suffix_14, t10.entity AS entity_15, t10.id AS id_16 FROM web_seo_translation t0 LEFT JOIN web_seo t10 ON t0.translatable_id = t10.id WHERE t0.translatable_id = ?

Parameters:

[
  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,
  t10.noindex AS noindex_11,
  t10.module AS module_12,
  t10.anchor AS anchor_13,
  t10.suffix AS suffix_14,
  t10.entity AS entity_15,
  t10.id AS id_16
FROM
  web_seo_translation t0
  LEFT JOIN web_seo t10 ON t0.translatable_id = t10.id
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, t10.noindex AS noindex_11, t10.module AS module_12, t10.anchor AS anchor_13, t10.suffix AS suffix_14, t10.entity AS entity_15, t10.id AS id_16 FROM web_seo_translation t0 LEFT JOIN web_seo t10 ON t0.translatable_id = t10.id WHERE t0.translatable_id = 4;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getOneToManyStatement (line 1872)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToManyCollection (line 1817)
3	Doctrine\ORM\UnitOfWork->loadCollection (line 2729)
4	Doctrine\ORM\UnitOfWork->createEntity (line 2608)
5	Doctrine\ORM\Internal\Hydration\SimpleObjectHydrator->hydrateRowData (line 176)
6	Doctrine\ORM\Internal\Hydration\SimpleObjectHydrator->hydrateAllData (line 60)
7	Doctrine\ORM\Internal\Hydration\AbstractHydrator->hydrateAll (line 175)
8	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 746)
9	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 756)
10	Doctrine\ORM\Proxy\ProxyFactory->{closure:Doctrine\ORM\Proxy\ProxyFactory::createLazyInitializer():294} (line 295)
11	Proxies\__CG__\NexCRM\WebBundle\Entity\SEO::{closure:{closure:Doctrine\ORM\Proxy\ProxyFactory::getProxyFactory():371}:372} (line 373)
12	Symfony\Component\VarExporter\Internal\LazyObjectState::initialize (line 60)
13	Proxies\__CG__\NexCRM\WebBundle\Entity\SEO->__get (line 153)
14	NexCRM\WebBundle\Entity\SEO->getTranslations (line 20)
15	NexCRM\WebBundle\Entity\SEO->findTranslationByLocale (line 189)
16	NexCRM\WebBundle\Entity\SEO->doTranslate (line 138)
17	NexCRM\WebBundle\Entity\SEO->translate (line 75)
18	NexCRM\WebBundle\Repository\MenuRepository->findByGroupOrdered (line 35)
19	App\Controller\BaseController->initialize (line 77)
20	App\Controller\PageController->pageAction (line 18)
21	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
22	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
23	Symfony\Component\HttpKernel\Kernel->handle (line 182)
24	handle (line 46)

1.18 ms
(2.20%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.media AS media_3, t0.updated_at AS updated_at_4, t0.file_size AS file_size_5, t0.ext AS ext_6, t0.preview AS preview_7, t0.pdf_preview AS pdf_preview_8, t0.deleted AS deleted_9, t0.deleted_at AS deleted_at_10, t0.seo AS seo_11, t0.height AS height_12, t0.width AS width_13, t0.disable_dynamic_fields AS disable_dynamic_fields_14, t0.disable_preview AS disable_preview_15, t0.duplicity_check AS duplicity_check_16, t0.change_check AS change_check_17, t0.recalculate AS recalculate_18, t0.diary AS diary_19, t0.state_close AS state_close_20, t0.date_control AS date_control_21, t0.warning_price AS warning_price_22, t0.warning_contact AS warning_contact_23, t0.from_api AS from_api_24, t0.created_at AS created_at_25, t0.isdoc AS isdoc_26, t0.folder_id AS folder_id_27, t28.id AS id_29, t28.name AS name_30, t28.description AS description_31, t28.deleted AS deleted_32, t28.deleted_at AS deleted_at_33, t28.date_representation AS date_representation_34, t28.active AS active_35, t28.undeletable AS undeletable_36, t28.editable AS editable_37, t28.auto_generate_rules AS auto_generate_rules_38, t28.auto_generate_co_workers AS auto_generate_co_workers_39, t28.persons_authorization AS persons_authorization_40, t28.duplicate_on_period AS duplicate_on_period_41, t28.title AS title_42, t28.start_balance AS start_balance_43, t28.start_balance_rate AS start_balance_rate_44, t28.recalculate_start_balance AS recalculate_start_balance_45, t28.state_close AS state_close_46, t28.in_ck AS in_ck_47, t28.parent_id AS parent_id_48, t28.company AS company_49, t28.filter_id AS filter_id_50, t28.file_type_id AS file_type_id_51, t28.numerical_root_id AS numerical_root_id_52, t28.agenda_sub_forlder_id AS agenda_sub_forlder_id_53, t28.agenda_period_id AS agenda_period_id_54, t28.period_before AS period_before_55, t28.period_after AS period_after_56, t28.should_give_id AS should_give_id_57, t28.given_id AS given_id_58, t28.department_id AS department_id_59, t28.project_id AS project_id_60, t28.activity_id AS activity_id_61, t28.payment_method_id AS payment_method_id_62, t28.currency_id AS currency_id_63, t28.account_assigment_id AS account_assigment_id_64, t28.vat_breakdown_id AS vat_breakdown_id_65, t28.numerical_root_definition_id AS numerical_root_definition_id_66, t28.bank_account_id AS bank_account_id_67, t68.file_type AS file_type_69, t68.invoice_number AS invoice_number_70, t68.variable_number AS variable_number_71, t68.contact AS contact_72, t68.price AS price_73, t68.currency AS currency_74, t68.rate AS rate_75, t68.defray AS defray_76, t68.defray_czk AS defray_czk_77, t68.is_bank_linked AS is_bank_linked_78, t68.id AS id_79, t68.file_id AS file_id_80, t68.company_id AS company_id_81, t68.should_give_id AS should_give_id_82, t83.id AS id_84, t83.file_id AS file_id_85, t83.file_type_id AS file_type_id_86, t0.last_editor_id AS last_editor_id_87, t0.previous_id AS previous_id_88, t0.next_id AS next_id_89, t0.user_id AS user_id_90 FROM dms_file t0 LEFT JOIN dms_folder t28 ON t0.folder_id = t28.id LEFT JOIN dms_file_field_data t68 ON t68.file_id = t0.id LEFT JOIN dms_file_parameters t83 ON t83.file_id = t0.id INNER JOIN page_doc_file ON t0.id = page_doc_file.file_id WHERE page_doc_file.item_id = ?

Parameters:

[
  5
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.media AS media_3,
  t0.updated_at AS updated_at_4,
  t0.file_size AS file_size_5,
  t0.ext AS ext_6,
  t0.preview AS preview_7,
  t0.pdf_preview AS pdf_preview_8,
  t0.deleted AS deleted_9,
  t0.deleted_at AS deleted_at_10,
  t0.seo AS seo_11,
  t0.height AS height_12,
  t0.width AS width_13,
  t0.disable_dynamic_fields AS disable_dynamic_fields_14,
  t0.disable_preview AS disable_preview_15,
  t0.duplicity_check AS duplicity_check_16,
  t0.change_check AS change_check_17,
  t0.recalculate AS recalculate_18,
  t0.diary AS diary_19,
  t0.state_close AS state_close_20,
  t0.date_control AS date_control_21,
  t0.warning_price AS warning_price_22,
  t0.warning_contact AS warning_contact_23,
  t0.from_api AS from_api_24,
  t0.created_at AS created_at_25,
  t0.isdoc AS isdoc_26,
  t0.folder_id AS folder_id_27,
  t28.id AS id_29,
  t28.name AS name_30,
  t28.description AS description_31,
  t28.deleted AS deleted_32,
  t28.deleted_at AS deleted_at_33,
  t28.date_representation AS date_representation_34,
  t28.active AS active_35,
  t28.undeletable AS undeletable_36,
  t28.editable AS editable_37,
  t28.auto_generate_rules AS auto_generate_rules_38,
  t28.auto_generate_co_workers AS auto_generate_co_workers_39,
  t28.persons_authorization AS persons_authorization_40,
  t28.duplicate_on_period AS duplicate_on_period_41,
  t28.title AS title_42,
  t28.start_balance AS start_balance_43,
  t28.start_balance_rate AS start_balance_rate_44,
  t28.recalculate_start_balance AS recalculate_start_balance_45,
  t28.state_close AS state_close_46,
  t28.in_ck AS in_ck_47,
  t28.parent_id AS parent_id_48,
  t28.company AS company_49,
  t28.filter_id AS filter_id_50,
  t28.file_type_id AS file_type_id_51,
  t28.numerical_root_id AS numerical_root_id_52,
  t28.agenda_sub_forlder_id AS agenda_sub_forlder_id_53,
  t28.agenda_period_id AS agenda_period_id_54,
  t28.period_before AS period_before_55,
  t28.period_after AS period_after_56,
  t28.should_give_id AS should_give_id_57,
  t28.given_id AS given_id_58,
  t28.department_id AS department_id_59,
  t28.project_id AS project_id_60,
  t28.activity_id AS activity_id_61,
  t28.payment_method_id AS payment_method_id_62,
  t28.currency_id AS currency_id_63,
  t28.account_assigment_id AS account_assigment_id_64,
  t28.vat_breakdown_id AS vat_breakdown_id_65,
  t28.numerical_root_definition_id AS numerical_root_definition_id_66,
  t28.bank_account_id AS bank_account_id_67,
  t68.file_type AS file_type_69,
  t68.invoice_number AS invoice_number_70,
  t68.variable_number AS variable_number_71,
  t68.contact AS contact_72,
  t68.price AS price_73,
  t68.currency AS currency_74,
  t68.rate AS rate_75,
  t68.defray AS defray_76,
  t68.defray_czk AS defray_czk_77,
  t68.is_bank_linked AS is_bank_linked_78,
  t68.id AS id_79,
  t68.file_id AS file_id_80,
  t68.company_id AS company_id_81,
  t68.should_give_id AS should_give_id_82,
  t83.id AS id_84,
  t83.file_id AS file_id_85,
  t83.file_type_id AS file_type_id_86,
  t0.last_editor_id AS last_editor_id_87,
  t0.previous_id AS previous_id_88,
  t0.next_id AS next_id_89,
  t0.user_id AS user_id_90
FROM
  dms_file t0
  LEFT JOIN dms_folder t28 ON t0.folder_id = t28.id
  LEFT JOIN dms_file_field_data t68 ON t68.file_id = t0.id
  LEFT JOIN dms_file_parameters t83 ON t83.file_id = t0.id
  INNER JOIN page_doc_file ON t0.id = page_doc_file.file_id
WHERE
  page_doc_file.item_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.media AS media_3, t0.updated_at AS updated_at_4, t0.file_size AS file_size_5, t0.ext AS ext_6, t0.preview AS preview_7, t0.pdf_preview AS pdf_preview_8, t0.deleted AS deleted_9, t0.deleted_at AS deleted_at_10, t0.seo AS seo_11, t0.height AS height_12, t0.width AS width_13, t0.disable_dynamic_fields AS disable_dynamic_fields_14, t0.disable_preview AS disable_preview_15, t0.duplicity_check AS duplicity_check_16, t0.change_check AS change_check_17, t0.recalculate AS recalculate_18, t0.diary AS diary_19, t0.state_close AS state_close_20, t0.date_control AS date_control_21, t0.warning_price AS warning_price_22, t0.warning_contact AS warning_contact_23, t0.from_api AS from_api_24, t0.created_at AS created_at_25, t0.isdoc AS isdoc_26, t0.folder_id AS folder_id_27, t28.id AS id_29, t28.name AS name_30, t28.description AS description_31, t28.deleted AS deleted_32, t28.deleted_at AS deleted_at_33, t28.date_representation AS date_representation_34, t28.active AS active_35, t28.undeletable AS undeletable_36, t28.editable AS editable_37, t28.auto_generate_rules AS auto_generate_rules_38, t28.auto_generate_co_workers AS auto_generate_co_workers_39, t28.persons_authorization AS persons_authorization_40, t28.duplicate_on_period AS duplicate_on_period_41, t28.title AS title_42, t28.start_balance AS start_balance_43, t28.start_balance_rate AS start_balance_rate_44, t28.recalculate_start_balance AS recalculate_start_balance_45, t28.state_close AS state_close_46, t28.in_ck AS in_ck_47, t28.parent_id AS parent_id_48, t28.company AS company_49, t28.filter_id AS filter_id_50, t28.file_type_id AS file_type_id_51, t28.numerical_root_id AS numerical_root_id_52, t28.agenda_sub_forlder_id AS agenda_sub_forlder_id_53, t28.agenda_period_id AS agenda_period_id_54, t28.period_before AS period_before_55, t28.period_after AS period_after_56, t28.should_give_id AS should_give_id_57, t28.given_id AS given_id_58, t28.department_id AS department_id_59, t28.project_id AS project_id_60, t28.activity_id AS activity_id_61, t28.payment_method_id AS payment_method_id_62, t28.currency_id AS currency_id_63, t28.account_assigment_id AS account_assigment_id_64, t28.vat_breakdown_id AS vat_breakdown_id_65, t28.numerical_root_definition_id AS numerical_root_definition_id_66, t28.bank_account_id AS bank_account_id_67, t68.file_type AS file_type_69, t68.invoice_number AS invoice_number_70, t68.variable_number AS variable_number_71, t68.contact AS contact_72, t68.price AS price_73, t68.currency AS currency_74, t68.rate AS rate_75, t68.defray AS defray_76, t68.defray_czk AS defray_czk_77, t68.is_bank_linked AS is_bank_linked_78, t68.id AS id_79, t68.file_id AS file_id_80, t68.company_id AS company_id_81, t68.should_give_id AS should_give_id_82, t83.id AS id_84, t83.file_id AS file_id_85, t83.file_type_id AS file_type_id_86, t0.last_editor_id AS last_editor_id_87, t0.previous_id AS previous_id_88, t0.next_id AS next_id_89, t0.user_id AS user_id_90 FROM dms_file t0 LEFT JOIN dms_folder t28 ON t0.folder_id = t28.id LEFT JOIN dms_file_field_data t68 ON t68.file_id = t0.id LEFT JOIN dms_file_parameters t83 ON t83.file_id = t0.id INNER JOIN page_doc_file ON t0.id = page_doc_file.file_id WHERE page_doc_file.item_id = 5;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getManyToManyStatement (line 1106)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadManyToManyCollection (line 1035)
3	Doctrine\ORM\UnitOfWork->loadCollection (line 2733)
4	Doctrine\ORM\PersistentCollection->doInitialize (line 636)
5	Doctrine\ORM\PersistentCollection->initialize (line 186)
6	Doctrine\Common\Collections\AbstractLazyCollection->count (line 39)
7	Doctrine\ORM\PersistentCollection->count (line 391)
8	Twig\Extension\CoreExtension->length (line 1272)
9	__TwigTemplate_9b7a298150db0016686756673f23793b::doDisplay (line 54)
10	Twig\Template->yield (line 402)
11	__TwigTemplate_6297adad81ba504558373f6a3f63c93f->block_content (line 151)
12	Twig\Template->yieldBlock (line 446)
13	__TwigTemplate_696542a229d5bd8419771cec448ad1bf->doDisplay (line 57)
14	Twig\Template->yield (line 402)
15	__TwigTemplate_6297adad81ba504558373f6a3f63c93f->doDisplay (line 53)
16	Twig\Template->yield (line 402)
17	Twig\Template->display (line 358)
18	Twig\Template->render (line 373)
19	Twig\TemplateWrapper->render (line 51)
20	Twig\Environment->render (line 333)
21	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 463)
22	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 468)
23	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 282)
24	App\Controller\BaseController->render (line 57)
25	App\Controller\PageController->pageAction (line 46)
26	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
27	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
28	Symfony\Component\HttpKernel\Kernel->handle (line 182)
29	handle (line 46)

1.16 ms
(2.16%)

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:

[
  "pagination"
]

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

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 738)
2	Doctrine\ORM\EntityRepository->findOneBy (line 125)
3	App\Controller\BaseController->initialize (line 69)
4	App\Controller\PageController->pageAction (line 18)
5	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
6	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
7	Symfony\Component\HttpKernel\Kernel->handle (line 182)
8	handle (line 46)

0.92 ms
(1.70%)

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:

[
  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\ORM\Persisters\Entity\BasicEntityPersister->load (line 738)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 756)
3	Doctrine\ORM\Proxy\ProxyFactory->{closure:Doctrine\ORM\Proxy\ProxyFactory::createLazyInitializer():294} (line 295)
4	Proxies\__CG__\NexCRM\WebBundle\Entity\SEO::{closure:{closure:Doctrine\ORM\Proxy\ProxyFactory::getProxyFactory():371}:372} (line 373)
5	Symfony\Component\VarExporter\Internal\LazyObjectState::initialize (line 60)
6	Proxies\__CG__\NexCRM\WebBundle\Entity\SEO->__get (line 153)
7	NexCRM\WebBundle\Entity\SEO->getTranslations (line 20)
8	NexCRM\WebBundle\Entity\SEO->findTranslationByLocale (line 189)
9	NexCRM\WebBundle\Entity\SEO->doTranslate (line 138)
10	NexCRM\WebBundle\Entity\SEO->translate (line 75)
11	NexCRM\WebBundle\Repository\MenuRepository->findByGroupOrdered (line 35)
12	App\Controller\BaseController->initialize (line 77)
13	App\Controller\PageController->pageAction (line 18)
14	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
15	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
16	Symfony\Component\HttpKernel\Kernel->handle (line 182)
17	handle (line 46)

0.79 ms
(1.48%)

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

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

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

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

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 963)
2	Doctrine\ORM\EntityRepository->findBy (line 110)
3	NexCRM\WebBundle\Service\MarketingService->getCodeByEnabledCookie (line 157)
4	NexCRM\WebBundle\Service\MarketingService->getCodes (line 122)
5	NexCRM\WebBundle\Twig\MarketingTwigExtension->marketing (line 66)
6	__TwigTemplate_8cd3113afc76e811472d1bc721192c7d->doDisplay (line 148)
7	Twig\Template->yield (line 402)
8	__TwigTemplate_696542a229d5bd8419771cec448ad1bf->block_header (line 153)
9	Twig\Template->yieldBlock (line 446)
10	__TwigTemplate_696542a229d5bd8419771cec448ad1bf->doDisplay (line 51)
11	Twig\Template->yield (line 402)
12	__TwigTemplate_6297adad81ba504558373f6a3f63c93f->doDisplay (line 53)
13	Twig\Template->yield (line 402)
14	Twig\Template->display (line 358)
15	Twig\Template->render (line 373)
16	Twig\TemplateWrapper->render (line 51)
17	Twig\Environment->render (line 333)
18	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 463)
19	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 468)
20	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 282)
21	App\Controller\BaseController->render (line 57)
22	App\Controller\PageController->pageAction (line 46)
23	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
24	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
25	Symfony\Component\HttpKernel\Kernel->handle (line 182)
26	handle (line 46)

0.72 ms
(1.34%)

SELECT t0.name AS name_1, t0.id AS id_2, t0.locale AS locale_3, t0.translatable_id AS translatable_id_4, t5.path AS path_6, t5.type AS type_7, t5.template AS template_8, t5.upload_form AS upload_form_9, t5.data_sources AS data_sources_10, t5.only_once AS only_once_11, t5.id AS id_12, t5.updated_at AS updated_at_13, t5.upload AS upload_14 FROM web_template_translation t0 LEFT JOIN web_template t5 ON t0.translatable_id = t5.id WHERE t0.translatable_id = ?

Parameters:

[
  3
]

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,
  t5.path AS path_6,
  t5.type AS type_7,
  t5.template AS template_8,
  t5.upload_form AS upload_form_9,
  t5.data_sources AS data_sources_10,
  t5.only_once AS only_once_11,
  t5.id AS id_12,
  t5.updated_at AS updated_at_13,
  t5.upload AS upload_14
FROM
  web_template_translation t0
  LEFT JOIN web_template t5 ON t0.translatable_id = t5.id
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, t5.path AS path_6, t5.type AS type_7, t5.template AS template_8, t5.upload_form AS upload_form_9, t5.data_sources AS data_sources_10, t5.only_once AS only_once_11, t5.id AS id_12, t5.updated_at AS updated_at_13, t5.upload AS upload_14 FROM web_template_translation t0 LEFT JOIN web_template t5 ON t0.translatable_id = t5.id WHERE t0.translatable_id = 3;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getOneToManyStatement (line 1872)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToManyCollection (line 1817)
3	Doctrine\ORM\UnitOfWork->loadCollection (line 2729)
4	Doctrine\ORM\UnitOfWork->createEntity (line 2608)
5	Doctrine\ORM\Internal\Hydration\SimpleObjectHydrator->hydrateRowData (line 176)
6	Doctrine\ORM\Internal\Hydration\SimpleObjectHydrator->hydrateAllData (line 60)
7	Doctrine\ORM\Internal\Hydration\AbstractHydrator->hydrateAll (line 175)
8	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 746)
9	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 756)
10	Doctrine\ORM\Proxy\ProxyFactory->{closure:Doctrine\ORM\Proxy\ProxyFactory::createLazyInitializer():294} (line 295)
11	Proxies\__CG__\NexCRM\WebBundle\Entity\Template::{closure:{closure:Doctrine\ORM\Proxy\ProxyFactory::getProxyFactory():371}:372} (line 373)
12	Symfony\Component\VarExporter\Internal\LazyObjectState::initialize (line 60)
13	Proxies\__CG__\NexCRM\WebBundle\Entity\Template->__get (line 153)
14	NexCRM\WebBundle\Entity\Template->getPath (line 68)
15	NexCRM\WebBundle\Service\PageTemplateService->getPagetemplate (line 21)
16	App\Controller\BaseController->initialize (line 80)
17	App\Controller\PageController->pageAction (line 18)
18	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
19	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
20	Symfony\Component\HttpKernel\Kernel->handle (line 182)
21	handle (line 46)

0.68 ms
(1.26%)

SELECT t0.catalogue AS catalogue_1, t0.translation AS translation_2, t0.id AS id_3, t0.lang_id AS lang_id_4, t5.name AS name_6, t5.menu AS menu_7, t5.iso_2 AS iso_2_8, t5.iso_3 AS iso_3_9, t5.default_lang AS default_lang_10, t5.active AS active_11, t5.id AS id_12, t5.country AS country_13, t0.lang_token_id AS lang_token_id_14, t15.token AS token_16, t15.id AS id_17 FROM lang_translation t0 LEFT JOIN lang t5 ON t0.lang_id = t5.id LEFT JOIN lang_token t15 ON t0.lang_token_id = t15.id WHERE t0.lang_id = ?

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.catalogue AS catalogue_1,
  t0.translation AS translation_2,
  t0.id AS id_3,
  t0.lang_id AS lang_id_4,
  t5.name AS name_6,
  t5.menu AS menu_7,
  t5.iso_2 AS iso_2_8,
  t5.iso_3 AS iso_3_9,
  t5.default_lang AS default_lang_10,
  t5.active AS active_11,
  t5.id AS id_12,
  t5.country AS country_13,
  t0.lang_token_id AS lang_token_id_14,
  t15.token AS token_16,
  t15.id AS id_17
FROM
  lang_translation t0
  LEFT JOIN lang t5 ON t0.lang_id = t5.id
  LEFT JOIN lang_token t15 ON t0.lang_token_id = t15.id
WHERE
  t0.lang_id = ?

SELECT t0.catalogue AS catalogue_1, t0.translation AS translation_2, t0.id AS id_3, t0.lang_id AS lang_id_4, t5.name AS name_6, t5.menu AS menu_7, t5.iso_2 AS iso_2_8, t5.iso_3 AS iso_3_9, t5.default_lang AS default_lang_10, t5.active AS active_11, t5.id AS id_12, t5.country AS country_13, t0.lang_token_id AS lang_token_id_14, t15.token AS token_16, t15.id AS id_17 FROM lang_translation t0 LEFT JOIN lang t5 ON t0.lang_id = t5.id LEFT JOIN lang_token t15 ON t0.lang_token_id = t15.id WHERE t0.lang_id = 1;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 963)
2	Doctrine\ORM\EntityRepository->findBy (line 110)
3	NexCRM\BaseBundle\Service\DBLoader->load (line 34)
4	Symfony\Component\Translation\Translator->doLoadCatalogue (line 378)
5	Symfony\Bundle\FrameworkBundle\Translation\Translator->doLoadCatalogue (line 135)
6	Symfony\Component\Translation\Translator->initializeCatalogue (line 272)
7	Symfony\Bundle\FrameworkBundle\Translation\Translator->initializeCatalogue (line 127)
8	Symfony\Component\Translation\Translator->loadCatalogue (line 261)
9	Symfony\Component\Translation\Translator->getCatalogue (line 237)
10	Symfony\Component\Translation\Translator->trans (line 187)
11	Symfony\Component\Translation\DataCollectorTranslator->trans (line 38)
12	NexCRM\BaseBundle\Service\Translator->trans (line 35)
13	Symfony\Bridge\Twig\Extension\TranslationExtension->trans (line 122)
14	__TwigTemplate_8cd3113afc76e811472d1bc721192c7d->doDisplay (line 252)
15	Twig\Template->yield (line 402)
16	__TwigTemplate_696542a229d5bd8419771cec448ad1bf->block_header (line 153)
17	Twig\Template->yieldBlock (line 446)
18	__TwigTemplate_696542a229d5bd8419771cec448ad1bf->doDisplay (line 51)
19	Twig\Template->yield (line 402)
20	__TwigTemplate_6297adad81ba504558373f6a3f63c93f->doDisplay (line 53)
21	Twig\Template->yield (line 402)
22	Twig\Template->display (line 358)
23	Twig\Template->render (line 373)
24	Twig\TemplateWrapper->render (line 51)
25	Twig\Environment->render (line 333)
26	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 463)
27	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 468)
28	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 282)
29	App\Controller\BaseController->render (line 57)
30	App\Controller\PageController->pageAction (line 46)
31	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
32	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
33	Symfony\Component\HttpKernel\Kernel->handle (line 182)
34	handle (line 46)

0.68 ms
(1.26%)

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:

[
  3
]

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

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 738)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 756)
3	Doctrine\ORM\Proxy\ProxyFactory->{closure:Doctrine\ORM\Proxy\ProxyFactory::createLazyInitializer():294} (line 295)
4	Proxies\__CG__\NexCRM\WebBundle\Entity\Template::{closure:{closure:Doctrine\ORM\Proxy\ProxyFactory::getProxyFactory():371}:372} (line 373)
5	Symfony\Component\VarExporter\Internal\LazyObjectState::initialize (line 60)
6	Proxies\__CG__\NexCRM\WebBundle\Entity\Template->__get (line 153)
7	NexCRM\WebBundle\Entity\Template->getPath (line 68)
8	NexCRM\WebBundle\Service\PageTemplateService->getPagetemplate (line 21)
9	App\Controller\BaseController->initialize (line 80)
10	App\Controller\PageController->pageAction (line 18)
11	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
12	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
13	Symfony\Component\HttpKernel\Kernel->handle (line 182)
14	handle (line 46)

0.65 ms
(1.21%)

SELECT t0.name AS name_1, t0.code1 AS code1_2, t0.code2 AS code2_3, t0.id AS id_4, t0.locale AS locale_5, t0.translatable_id AS translatable_id_6, t7.alias AS alias_8, t7.active AS active_9, t7.api AS api_10, t7.display AS display_11, t7.script AS script_12, t7.category AS category_13, t7.position AS position_14, t7.code1 AS code1_15, t7.code2 AS code2_16, t7.id AS id_17, t7.sort AS sort_18 FROM web_code_translation t0 LEFT JOIN web_code t7 ON t0.translatable_id = t7.id WHERE t0.translatable_id = ?

Parameters:

[
  9
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.name AS name_1,
  t0.code1 AS code1_2,
  t0.code2 AS code2_3,
  t0.id AS id_4,
  t0.locale AS locale_5,
  t0.translatable_id AS translatable_id_6,
  t7.alias AS alias_8,
  t7.active AS active_9,
  t7.api AS api_10,
  t7.display AS display_11,
  t7.script AS script_12,
  t7.category AS category_13,
  t7.position AS position_14,
  t7.code1 AS code1_15,
  t7.code2 AS code2_16,
  t7.id AS id_17,
  t7.sort AS sort_18
FROM
  web_code_translation t0
  LEFT JOIN web_code t7 ON t0.translatable_id = t7.id
WHERE
  t0.translatable_id = ?

SELECT t0.name AS name_1, t0.code1 AS code1_2, t0.code2 AS code2_3, t0.id AS id_4, t0.locale AS locale_5, t0.translatable_id AS translatable_id_6, t7.alias AS alias_8, t7.active AS active_9, t7.api AS api_10, t7.display AS display_11, t7.script AS script_12, t7.category AS category_13, t7.position AS position_14, t7.code1 AS code1_15, t7.code2 AS code2_16, t7.id AS id_17, t7.sort AS sort_18 FROM web_code_translation t0 LEFT JOIN web_code t7 ON t0.translatable_id = t7.id WHERE t0.translatable_id = 9;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getOneToManyStatement (line 1872)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToManyCollection (line 1817)
3	Doctrine\ORM\UnitOfWork->loadCollection (line 2729)
4	Doctrine\ORM\UnitOfWork->createEntity (line 2608)
5	Doctrine\ORM\Internal\Hydration\SimpleObjectHydrator->hydrateRowData (line 176)
6	Doctrine\ORM\Internal\Hydration\SimpleObjectHydrator->hydrateAllData (line 60)
7	Doctrine\ORM\Internal\Hydration\AbstractHydrator->hydrateAll (line 175)
8	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 967)
9	Doctrine\ORM\EntityRepository->findBy (line 110)
10	NexCRM\WebBundle\Service\MarketingService->getCodeByEnabledCookie (line 157)
11	NexCRM\WebBundle\Service\MarketingService->getCodes (line 122)
12	NexCRM\WebBundle\Twig\MarketingTwigExtension->marketing (line 66)
13	__TwigTemplate_8cd3113afc76e811472d1bc721192c7d->doDisplay (line 148)
14	Twig\Template->yield (line 402)
15	__TwigTemplate_696542a229d5bd8419771cec448ad1bf->block_header (line 153)
16	Twig\Template->yieldBlock (line 446)
17	__TwigTemplate_696542a229d5bd8419771cec448ad1bf->doDisplay (line 51)
18	Twig\Template->yield (line 402)
19	__TwigTemplate_6297adad81ba504558373f6a3f63c93f->doDisplay (line 53)
20	Twig\Template->yield (line 402)
21	Twig\Template->display (line 358)
22	Twig\Template->render (line 373)
23	Twig\TemplateWrapper->render (line 51)
24	Twig\Environment->render (line 333)
25	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 463)
26	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 468)
27	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 282)
28	App\Controller\BaseController->render (line 57)
29	App\Controller\PageController->pageAction (line 46)
30	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
31	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
32	Symfony\Component\HttpKernel\Kernel->handle (line 182)
33	handle (line 46)

0.59 ms
(1.09%)

SELECT t0.question AS question_1, t0.answer AS answer_2, t0.active AS active_3, t0.id AS id_4, t0.sort AS sort_5 FROM web_faq t0 WHERE t0.active = ? ORDER BY t0.sort ASC

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.question AS question_1,
  t0.answer AS answer_2,
  t0.active AS active_3,
  t0.id AS id_4,
  t0.sort AS sort_5
FROM
  web_faq t0
WHERE
  t0.active = ?
ORDER BY
  t0.sort ASC

SELECT t0.question AS question_1, t0.answer AS answer_2, t0.active AS active_3, t0.id AS id_4, t0.sort AS sort_5 FROM web_faq t0 WHERE t0.active = 1 ORDER BY t0.sort ASC;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 963)
2	Doctrine\ORM\EntityRepository->findBy (line 110)
3	App\Controller\BaseController->initialize (line 73)
4	App\Controller\PageController->pageAction (line 18)
5	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
6	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
7	Symfony\Component\HttpKernel\Kernel->handle (line 182)
8	handle (line 46)

0.52 ms
(0.97%)

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

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

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

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

#	File/Call
1	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 27)
2	Doctrine\ORM\Query->_doExecute (line 296)
3	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 930)
4	Doctrine\ORM\AbstractQuery->execute (line 886)
5	Doctrine\ORM\AbstractQuery->getResult (line 688)
6	NexCRM\WebBundle\Repository\MenuRepository->findByGroupOrdered (line 24)
7	App\Controller\BaseController->initialize (line 77)
8	App\Controller\PageController->pageAction (line 18)
9	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
10	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
11	Symfony\Component\HttpKernel\Kernel->handle (line 182)
12	handle (line 46)

0.46 ms
(0.85%)

SELECT d0_.name AS name_0, d0_.hint AS hint_1, d0_.active_for_tariffs AS active_for_tariffs_2, d0_.id AS id_3, d0_.sort AS sort_4, d0_.parent_id AS parent_id_5 FROM dms_web_tariff_item d0_ WHERE d0_.parent_id IS NULL ORDER BY d0_.sort ASC

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  d0_.name AS name_0,
  d0_.hint AS hint_1,
  d0_.active_for_tariffs AS active_for_tariffs_2,
  d0_.id AS id_3,
  d0_.sort AS sort_4,
  d0_.parent_id AS parent_id_5
FROM
  dms_web_tariff_item d0_
WHERE
  d0_.parent_id IS NULL
ORDER BY
  d0_.sort ASC

SELECT d0_.name AS name_0, d0_.hint AS hint_1, d0_.active_for_tariffs AS active_for_tariffs_2, d0_.id AS id_3, d0_.sort AS sort_4, d0_.parent_id AS parent_id_5 FROM dms_web_tariff_item d0_ WHERE d0_.parent_id IS NULL ORDER BY d0_.sort ASC;

#	File/Call
1	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 27)
2	Doctrine\ORM\Query->_doExecute (line 296)
3	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 930)
4	Doctrine\ORM\AbstractQuery->execute (line 886)
5	Doctrine\ORM\AbstractQuery->getResult (line 688)
6	App\Repository\WebTariffItemRepository->getRootItems (line 17)
7	App\Controller\BaseController->initialize (line 82)
8	App\Controller\PageController->pageAction (line 18)
9	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
10	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
11	Symfony\Component\HttpKernel\Kernel->handle (line 182)
12	handle (line 46)

0.44 ms
(0.82%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.viesName AS viesName_3, t0.bin AS bin_4, t0.tid AS tid_5, t0.file_number AS file_number_6, t0.synthetic_month AS synthetic_month_7, t0.agenda_last_run AS agenda_last_run_8, t0.vat AS vat_9, t0.vatUnreliableDate AS vatUnreliableDate_10, t0.dateCheck AS dateCheck_11, t0.automatic_bin AS automatic_bin_12, t0.street AS street_13, t0.street_number AS street_number_14, t0.street_number2 AS street_number2_15, t0.city AS city_16, t0.zip AS zip_17, t0.bank_account AS bank_account_18, t0.bank_number AS bank_number_19, t0.iban AS iban_20, t0.swift AS swift_21, t0.tariff_update_at AS tariff_update_at_22, t0.deregister_at AS deregister_at_23, t0.block AS block_24, t0.issues_invoice AS issues_invoice_25, t0.active AS active_26, t0.last_registration_at AS last_registration_at_27, t0.email_send_invoice AS email_send_invoice_28, t0.short_description AS short_description_29, t0.description AS description_30, t0.facebook_link AS facebook_link_31, t0.twitter_link AS twitter_link_32, t0.instagram_link AS instagram_link_33, t0.linked_in_link AS linked_in_link_34, t0.dateClose AS dateClose_35, t0.discount_active AS discount_active_36, t0.init_number_of_mining AS init_number_of_mining_37, t0.updated_at AS updated_at_38, t0.upload AS upload_39, t0.subject_id AS subject_id_40, t0.vat_payer_type_id AS vat_payer_type_id_41, t0.evidence_type_id AS evidence_type_id_42, t0.synthetic_group_id AS synthetic_group_id_43, t0.synthetic_period_id AS synthetic_period_id_44, t0.tariff_id AS tariff_id_45, t0.country_id AS country_id_46, t0.accounting_office_id AS accounting_office_id_47, t0.tariff_info_id AS tariff_info_id_48, t0.billing_contact_id AS billing_contact_id_49 FROM company t0 WHERE t0.id IS NULL LIMIT 1

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.viesName AS viesName_3,
  t0.bin AS bin_4,
  t0.tid AS tid_5,
  t0.file_number AS file_number_6,
  t0.synthetic_month AS synthetic_month_7,
  t0.agenda_last_run AS agenda_last_run_8,
  t0.vat AS vat_9,
  t0.vatUnreliableDate AS vatUnreliableDate_10,
  t0.dateCheck AS dateCheck_11,
  t0.automatic_bin AS automatic_bin_12,
  t0.street AS street_13,
  t0.street_number AS street_number_14,
  t0.street_number2 AS street_number2_15,
  t0.city AS city_16,
  t0.zip AS zip_17,
  t0.bank_account AS bank_account_18,
  t0.bank_number AS bank_number_19,
  t0.iban AS iban_20,
  t0.swift AS swift_21,
  t0.tariff_update_at AS tariff_update_at_22,
  t0.deregister_at AS deregister_at_23,
  t0.block AS block_24,
  t0.issues_invoice AS issues_invoice_25,
  t0.active AS active_26,
  t0.last_registration_at AS last_registration_at_27,
  t0.email_send_invoice AS email_send_invoice_28,
  t0.short_description AS short_description_29,
  t0.description AS description_30,
  t0.facebook_link AS facebook_link_31,
  t0.twitter_link AS twitter_link_32,
  t0.instagram_link AS instagram_link_33,
  t0.linked_in_link AS linked_in_link_34,
  t0.dateClose AS dateClose_35,
  t0.discount_active AS discount_active_36,
  t0.init_number_of_mining AS init_number_of_mining_37,
  t0.updated_at AS updated_at_38,
  t0.upload AS upload_39,
  t0.subject_id AS subject_id_40,
  t0.vat_payer_type_id AS vat_payer_type_id_41,
  t0.evidence_type_id AS evidence_type_id_42,
  t0.synthetic_group_id AS synthetic_group_id_43,
  t0.synthetic_period_id AS synthetic_period_id_44,
  t0.tariff_id AS tariff_id_45,
  t0.country_id AS country_id_46,
  t0.accounting_office_id AS accounting_office_id_47,
  t0.tariff_info_id AS tariff_info_id_48,
  t0.billing_contact_id AS billing_contact_id_49
FROM
  company t0
WHERE
  t0.id IS NULL
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.viesName AS viesName_3, t0.bin AS bin_4, t0.tid AS tid_5, t0.file_number AS file_number_6, t0.synthetic_month AS synthetic_month_7, t0.agenda_last_run AS agenda_last_run_8, t0.vat AS vat_9, t0.vatUnreliableDate AS vatUnreliableDate_10, t0.dateCheck AS dateCheck_11, t0.automatic_bin AS automatic_bin_12, t0.street AS street_13, t0.street_number AS street_number_14, t0.street_number2 AS street_number2_15, t0.city AS city_16, t0.zip AS zip_17, t0.bank_account AS bank_account_18, t0.bank_number AS bank_number_19, t0.iban AS iban_20, t0.swift AS swift_21, t0.tariff_update_at AS tariff_update_at_22, t0.deregister_at AS deregister_at_23, t0.block AS block_24, t0.issues_invoice AS issues_invoice_25, t0.active AS active_26, t0.last_registration_at AS last_registration_at_27, t0.email_send_invoice AS email_send_invoice_28, t0.short_description AS short_description_29, t0.description AS description_30, t0.facebook_link AS facebook_link_31, t0.twitter_link AS twitter_link_32, t0.instagram_link AS instagram_link_33, t0.linked_in_link AS linked_in_link_34, t0.dateClose AS dateClose_35, t0.discount_active AS discount_active_36, t0.init_number_of_mining AS init_number_of_mining_37, t0.updated_at AS updated_at_38, t0.upload AS upload_39, t0.subject_id AS subject_id_40, t0.vat_payer_type_id AS vat_payer_type_id_41, t0.evidence_type_id AS evidence_type_id_42, t0.synthetic_group_id AS synthetic_group_id_43, t0.synthetic_period_id AS synthetic_period_id_44, t0.tariff_id AS tariff_id_45, t0.country_id AS country_id_46, t0.accounting_office_id AS accounting_office_id_47, t0.tariff_info_id AS tariff_info_id_48, t0.billing_contact_id AS billing_contact_id_49 FROM company t0 WHERE t0.id IS NULL LIMIT 1;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 738)
2	Doctrine\ORM\EntityRepository->findOneBy (line 125)
3	App\Service\CompanyHelper->getSelectedCompany (line 122)
4	App\Service\WidgetContextResolver->ctxMarketplace (line 61)
5	App\Service\WidgetContextResolver->resolve (line 37)
6	NexCRM\BaseBundle\Service\WidgetService->getWidgets (line 55)
7	NexCRM\BaseBundle\EventListener\WidgetBaseControllerConstructListener->onBaseControllerConstruct (line 35)
8	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
9	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
10	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
11	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 126)
12	NexCRM\BaseBundle\Controller\AbstractBaseController->dispatchBaseControllerConstructEvent (line 24)
13	ContainerM1ijjA9\getPageControllerService->do (line 29)
14	ContainerM1ijjA9\App_KernelDevDebugContainer::load (line 1282)
15	Symfony\Component\DependencyInjection\Container->make (line 221)
16	Symfony\Component\DependencyInjection\Container::get (line 203)
17	Symfony\Component\HttpKernel\Controller\ContainerControllerResolver->instantiateController (line 38)
18	Symfony\Bundle\FrameworkBundle\Controller\ControllerResolver->instantiateController (line 25)
19	Symfony\Component\HttpKernel\Controller\ControllerResolver->createController (line 127)
20	Symfony\Component\HttpKernel\Controller\ControllerResolver->getController (line 95)
21	Symfony\Component\HttpKernel\Controller\TraceableControllerResolver->getController (line 33)
22	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 166)
23	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
24	Symfony\Component\HttpKernel\Kernel->handle (line 182)
25	handle (line 46)

0.44 ms
(0.81%)

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

Parameters:

[
  5
]

View formatted query View runnable query Explain query View query backtrace

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

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

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getManyToManyStatement (line 1106)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadManyToManyCollection (line 1035)
3	Doctrine\ORM\UnitOfWork->loadCollection (line 2733)
4	Doctrine\ORM\PersistentCollection->doInitialize (line 636)
5	Doctrine\ORM\PersistentCollection->initialize (line 186)
6	Doctrine\Common\Collections\AbstractLazyCollection->getIterator (line 313)
7	NexCRM\WebBundle\Entity\Page->getContents (line 157)
8	Twig\Extension\CoreExtension->getAttribute (line 1913)
9	__TwigTemplate_6297adad81ba504558373f6a3f63c93f::block_content (line 158)
10	Twig\Template->yieldBlock (line 446)
11	__TwigTemplate_696542a229d5bd8419771cec448ad1bf->doDisplay (line 57)
12	Twig\Template->yield (line 402)
13	__TwigTemplate_6297adad81ba504558373f6a3f63c93f->doDisplay (line 53)
14	Twig\Template->yield (line 402)
15	Twig\Template->display (line 358)
16	Twig\Template->render (line 373)
17	Twig\TemplateWrapper->render (line 51)
18	Twig\Environment->render (line 333)
19	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 463)
20	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 468)
21	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 282)
22	App\Controller\BaseController->render (line 57)
23	App\Controller\PageController->pageAction (line 46)
24	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
25	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
26	Symfony\Component\HttpKernel\Kernel->handle (line 182)
27	handle (line 46)

0.42 ms
(0.78%)

SELECT t0.name AS name_1, t0.postion AS postion_2, t0.text AS text_3, t0.active AS active_4, t0.id AS id_5, t0.sort AS sort_6, t0.img_file_id AS img_file_id_7 FROM web_reference t0 WHERE t0.active = ? ORDER BY t0.sort ASC

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.name AS name_1,
  t0.postion AS postion_2,
  t0.text AS text_3,
  t0.active AS active_4,
  t0.id AS id_5,
  t0.sort AS sort_6,
  t0.img_file_id AS img_file_id_7
FROM
  web_reference t0
WHERE
  t0.active = ?
ORDER BY
  t0.sort ASC

SELECT t0.name AS name_1, t0.postion AS postion_2, t0.text AS text_3, t0.active AS active_4, t0.id AS id_5, t0.sort AS sort_6, t0.img_file_id AS img_file_id_7 FROM web_reference t0 WHERE t0.active = 1 ORDER BY t0.sort ASC;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 963)
2	Doctrine\ORM\EntityRepository->findBy (line 110)
3	App\Controller\BaseController->initialize (line 74)
4	App\Controller\PageController->pageAction (line 18)
5	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
6	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
7	Symfony\Component\HttpKernel\Kernel->handle (line 182)
8	handle (line 46)

0.41 ms
(0.76%)

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\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 963)
2	Doctrine\ORM\EntityRepository->findBy (line 110)
3	Doctrine\ORM\EntityRepository->findAll (line 96)
4	NexCRM\BaseBundle\Repository\SettingRepository->findByToArray (line 17)
5	App\Controller\BaseController->initialize (line 71)
6	App\Controller\PageController->pageAction (line 18)
7	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
8	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
9	Symfony\Component\HttpKernel\Kernel->handle (line 182)
10	handle (line 46)

0.38 ms
(0.71%)

SELECT d0_.name AS name_0, d0_.position AS position_1, d0_.id AS id_2, d0_.sort AS sort_3, d0_.img_file_id AS img_file_id_4 FROM dms_web_employee d0_ ORDER BY d0_.sort ASC

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  d0_.name AS name_0,
  d0_.position AS position_1,
  d0_.id AS id_2,
  d0_.sort AS sort_3,
  d0_.img_file_id AS img_file_id_4
FROM
  dms_web_employee d0_
ORDER BY
  d0_.sort ASC

SELECT d0_.name AS name_0, d0_.position AS position_1, d0_.id AS id_2, d0_.sort AS sort_3, d0_.img_file_id AS img_file_id_4 FROM dms_web_employee d0_ ORDER BY d0_.sort ASC;

#	File/Call
1	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 27)
2	Doctrine\ORM\Query->_doExecute (line 296)
3	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 930)
4	Doctrine\ORM\AbstractQuery->execute (line 886)
5	Doctrine\ORM\AbstractQuery->getResult (line 688)
6	App\Repository\WebEmployeeRepository->getOrdered (line 15)
7	App\Controller\BaseController->initialize (line 81)
8	App\Controller\PageController->pageAction (line 18)
9	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
10	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
11	Symfony\Component\HttpKernel\Kernel->handle (line 182)
12	handle (line 46)

0.37 ms
(0.69%)

SELECT t0.name AS name_1, t0.id AS id_2, t0.locale AS locale_3, t0.translatable_id AS translatable_id_4, t5.name AS name_6, t5.id AS id_7 FROM web_menu_group_translation t0 LEFT JOIN web_menu_group t5 ON t0.translatable_id = t5.id WHERE t0.translatable_id = ?

Parameters:

[
  3
]

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,
  t5.name AS name_6,
  t5.id AS id_7
FROM
  web_menu_group_translation t0
  LEFT JOIN web_menu_group t5 ON t0.translatable_id = t5.id
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, t5.name AS name_6, t5.id AS id_7 FROM web_menu_group_translation t0 LEFT JOIN web_menu_group t5 ON t0.translatable_id = t5.id WHERE t0.translatable_id = 3;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getOneToManyStatement (line 1872)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToManyCollection (line 1817)
3	Doctrine\ORM\UnitOfWork->loadCollection (line 2729)
4	Doctrine\ORM\UnitOfWork->createEntity (line 2608)
5	Doctrine\ORM\Internal\Hydration\SimpleObjectHydrator->hydrateRowData (line 176)
6	Doctrine\ORM\Internal\Hydration\SimpleObjectHydrator->hydrateAllData (line 60)
7	Doctrine\ORM\Internal\Hydration\AbstractHydrator->hydrateAll (line 175)
8	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 967)
9	Doctrine\ORM\EntityRepository->findBy (line 110)
10	NexCRM\WebBundle\Repository\MenuRepository->findByGroupOrdered (line 16)
11	App\Controller\BaseController->initialize (line 77)
12	App\Controller\PageController->pageAction (line 18)
13	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
14	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
15	Symfony\Component\HttpKernel\Kernel->handle (line 182)
16	handle (line 46)

0.34 ms
(0.64%)

SELECT t0.name AS name_1, t0.menu AS menu_2, t0.iso_2 AS iso_2_3, t0.iso_3 AS iso_3_4, t0.default_lang AS default_lang_5, t0.active AS active_6, t0.id AS id_7, t0.country AS country_8 FROM lang t0 WHERE t0.iso_2 = ? LIMIT 1

Parameters:

[
  "cs"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.name AS name_1,
  t0.menu AS menu_2,
  t0.iso_2 AS iso_2_3,
  t0.iso_3 AS iso_3_4,
  t0.default_lang AS default_lang_5,
  t0.active AS active_6,
  t0.id AS id_7,
  t0.country AS country_8
FROM
  lang t0
WHERE
  t0.iso_2 = ?
LIMIT
  1

SELECT t0.name AS name_1, t0.menu AS menu_2, t0.iso_2 AS iso_2_3, t0.iso_3 AS iso_3_4, t0.default_lang AS default_lang_5, t0.active AS active_6, t0.id AS id_7, t0.country AS country_8 FROM lang t0 WHERE t0.iso_2 = 'cs' LIMIT 1;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 738)
2	Doctrine\ORM\EntityRepository->findOneBy (line 125)
3	NexCRM\BaseBundle\EventListener\LocaleListener->onKernelRequest (line 45)
4	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
5	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
6	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
7	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 126)
8	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 159)
9	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
10	Symfony\Component\HttpKernel\Kernel->handle (line 182)
11	handle (line 46)

0.29 ms
(0.54%)

SELECT t0.name AS name_1, t0.text AS text_2, t0.front_tariff AS front_tariff_3, t0.price_monthly AS price_monthly_4, t0.price_quarterly AS price_quarterly_5, t0.price_yearly AS price_yearly_6, t0.discount_quarterly AS discount_quarterly_7, t0.discount_yearly AS discount_yearly_8, t0.hash AS hash_9, t0.price_interval AS price_interval_10, t0.price_text AS price_text_11, t0.advantage_text AS advantage_text_12, t0.description AS description_13, t0.favorite AS favorite_14, t0.number_of_users AS number_of_users_15, t0.max_disk_space AS max_disk_space_16, t0.data_mining_per_month AS data_mining_per_month_17, t0.number_of_mining AS number_of_mining_18, t0.unlimited_mining AS unlimited_mining_19, t0.active AS active_20, t0.additional_seat AS additional_seat_21, t0.price_per_1_gb AS price_per_1_gb_22, t0.public AS public_23, t0.number_of_contacts AS number_of_contacts_24, t0.id AS id_25, t0.sort AS sort_26, t0.img_file_id AS img_file_id_27 FROM dms_tariff t0 WHERE t0.active = ? AND t0.public = ? ORDER BY t0.sort ASC

Parameters:

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.name AS name_1,
  t0.text AS text_2,
  t0.front_tariff AS front_tariff_3,
  t0.price_monthly AS price_monthly_4,
  t0.price_quarterly AS price_quarterly_5,
  t0.price_yearly AS price_yearly_6,
  t0.discount_quarterly AS discount_quarterly_7,
  t0.discount_yearly AS discount_yearly_8,
  t0.hash AS hash_9,
  t0.price_interval AS price_interval_10,
  t0.price_text AS price_text_11,
  t0.advantage_text AS advantage_text_12,
  t0.description AS description_13,
  t0.favorite AS favorite_14,
  t0.number_of_users AS number_of_users_15,
  t0.max_disk_space AS max_disk_space_16,
  t0.data_mining_per_month AS data_mining_per_month_17,
  t0.number_of_mining AS number_of_mining_18,
  t0.unlimited_mining AS unlimited_mining_19,
  t0.active AS active_20,
  t0.additional_seat AS additional_seat_21,
  t0.price_per_1_gb AS price_per_1_gb_22,
  t0.public AS public_23,
  t0.number_of_contacts AS number_of_contacts_24,
  t0.id AS id_25,
  t0.sort AS sort_26,
  t0.img_file_id AS img_file_id_27
FROM
  dms_tariff t0
WHERE
  t0.active = ?
  AND t0.public = ?
ORDER BY
  t0.sort ASC

SELECT t0.name AS name_1, t0.text AS text_2, t0.front_tariff AS front_tariff_3, t0.price_monthly AS price_monthly_4, t0.price_quarterly AS price_quarterly_5, t0.price_yearly AS price_yearly_6, t0.discount_quarterly AS discount_quarterly_7, t0.discount_yearly AS discount_yearly_8, t0.hash AS hash_9, t0.price_interval AS price_interval_10, t0.price_text AS price_text_11, t0.advantage_text AS advantage_text_12, t0.description AS description_13, t0.favorite AS favorite_14, t0.number_of_users AS number_of_users_15, t0.max_disk_space AS max_disk_space_16, t0.data_mining_per_month AS data_mining_per_month_17, t0.number_of_mining AS number_of_mining_18, t0.unlimited_mining AS unlimited_mining_19, t0.active AS active_20, t0.additional_seat AS additional_seat_21, t0.price_per_1_gb AS price_per_1_gb_22, t0.public AS public_23, t0.number_of_contacts AS number_of_contacts_24, t0.id AS id_25, t0.sort AS sort_26, t0.img_file_id AS img_file_id_27 FROM dms_tariff t0 WHERE t0.active = 1 AND t0.public = 1 ORDER BY t0.sort ASC;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 963)
2	Doctrine\ORM\EntityRepository->findBy (line 110)
3	App\Controller\BaseController->initialize (line 76)
4	App\Controller\PageController->pageAction (line 18)
5	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
6	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
7	Symfony\Component\HttpKernel\Kernel->handle (line 182)
8	handle (line 46)

0.28 ms
(0.52%)

SELECT t0.block_key AS block_key_1, t0.id AS id_2, t0.img_files_order AS img_files_order_3, t0.dms_img_updated AS dms_img_updated_4, t0.img_file_id AS img_file_id_5, t0.doc_file_id AS doc_file_id_6 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.img_files_order AS img_files_order_3,
  t0.dms_img_updated AS dms_img_updated_4,
  t0.img_file_id AS img_file_id_5,
  t0.doc_file_id AS doc_file_id_6
FROM
  web_block t0

SELECT t0.block_key AS block_key_1, t0.id AS id_2, t0.img_files_order AS img_files_order_3, t0.dms_img_updated AS dms_img_updated_4, t0.img_file_id AS img_file_id_5, t0.doc_file_id AS doc_file_id_6 FROM web_block t0;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 963)
2	Doctrine\ORM\EntityRepository->findBy (line 110)
3	NexCRM\WebBundle\Repository\BlockRepository->findByToArray (line 15)
4	App\Controller\BaseController->initialize (line 79)
5	App\Controller\PageController->pageAction (line 18)
6	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
7	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
8	Symfony\Component\HttpKernel\Kernel->handle (line 182)
9	handle (line 46)

0.23 ms
(0.42%)

SELECT t0.active AS active_1, t0.name AS name_2, t0.text AS text_3, t0.id AS id_4, t0.sort AS sort_5, t0.img_file_id AS img_file_id_6 FROM app_function t0 WHERE t0.active = ? ORDER BY t0.sort ASC

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.active AS active_1,
  t0.name AS name_2,
  t0.text AS text_3,
  t0.id AS id_4,
  t0.sort AS sort_5,
  t0.img_file_id AS img_file_id_6
FROM
  app_function t0
WHERE
  t0.active = ?
ORDER BY
  t0.sort ASC

SELECT t0.active AS active_1, t0.name AS name_2, t0.text AS text_3, t0.id AS id_4, t0.sort AS sort_5, t0.img_file_id AS img_file_id_6 FROM app_function t0 WHERE t0.active = 1 ORDER BY t0.sort ASC;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 963)
2	Doctrine\ORM\EntityRepository->findBy (line 110)
3	App\Controller\BaseController->initialize (line 84)
4	App\Controller\PageController->pageAction (line 18)
5	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
6	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
7	Symfony\Component\HttpKernel\Kernel->handle (line 182)
8	handle (line 46)

0.22 ms
(0.41%)

SELECT w0_.widget AS widget_0, w0_.width AS width_1, w0_.height AS height_2, w0_.locked AS locked_3, w0_.preferred AS preferred_4, w0_.active AS active_5, w0_.id AS id_6, w0_.sort AS sort_7, w0_.updated_at AS updated_at_8, w0_.upload AS upload_9 FROM widget w0_ WHERE w0_.active = ?

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  w0_.widget AS widget_0,
  w0_.width AS width_1,
  w0_.height AS height_2,
  w0_.locked AS locked_3,
  w0_.preferred AS preferred_4,
  w0_.active AS active_5,
  w0_.id AS id_6,
  w0_.sort AS sort_7,
  w0_.updated_at AS updated_at_8,
  w0_.upload AS upload_9
FROM
  widget w0_
WHERE
  w0_.active = ?

SELECT w0_.widget AS widget_0, w0_.width AS width_1, w0_.height AS height_2, w0_.locked AS locked_3, w0_.preferred AS preferred_4, w0_.active AS active_5, w0_.id AS id_6, w0_.sort AS sort_7, w0_.updated_at AS updated_at_8, w0_.upload AS upload_9 FROM widget w0_ WHERE w0_.active = 1;

#	File/Call
1	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 27)
2	Doctrine\ORM\Query->_doExecute (line 296)
3	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 930)
4	Doctrine\ORM\AbstractQuery->execute (line 886)
5	Doctrine\ORM\AbstractQuery->getResult (line 688)
6	NexCRM\BaseBundle\Service\WidgetService->getWidgets (line 31)
7	NexCRM\BaseBundle\EventListener\WidgetBaseControllerConstructListener->onBaseControllerConstruct (line 35)
8	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
9	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
10	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
11	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 126)
12	NexCRM\BaseBundle\Controller\AbstractBaseController->dispatchBaseControllerConstructEvent (line 24)
13	ContainerM1ijjA9\getPageControllerService->do (line 29)
14	ContainerM1ijjA9\App_KernelDevDebugContainer::load (line 1282)
15	Symfony\Component\DependencyInjection\Container->make (line 221)
16	Symfony\Component\DependencyInjection\Container::get (line 203)
17	Symfony\Component\HttpKernel\Controller\ContainerControllerResolver->instantiateController (line 38)
18	Symfony\Bundle\FrameworkBundle\Controller\ControllerResolver->instantiateController (line 25)
19	Symfony\Component\HttpKernel\Controller\ControllerResolver->createController (line 127)
20	Symfony\Component\HttpKernel\Controller\ControllerResolver->getController (line 95)
21	Symfony\Component\HttpKernel\Controller\TraceableControllerResolver->getController (line 33)
22	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 166)
23	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
24	Symfony\Component\HttpKernel\Kernel->handle (line 182)
25	handle (line 46)

0.22 ms
(0.41%)

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

#	File/Call
1	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 27)
2	Doctrine\ORM\Query->_doExecute (line 296)
3	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 930)
4	Doctrine\ORM\AbstractQuery->execute (line 886)
5	Doctrine\ORM\AbstractQuery->getResult (line 688)
6	NexCRM\WebBundle\Repository\MenuRepository->findByGroupOrdered (line 24)
7	App\Controller\BaseController->initialize (line 77)
8	App\Controller\PageController->pageAction (line 18)
9	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
10	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
11	Symfony\Component\HttpKernel\Kernel->handle (line 182)
12	handle (line 46)

0.22 ms
(0.40%)

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\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 963)
2	Doctrine\ORM\EntityRepository->findBy (line 110)
3	NexCRM\WebBundle\Repository\SliderRepository->findByGroupOrdered (line 15)
4	App\Controller\BaseController->initialize (line 78)
5	App\Controller\PageController->pageAction (line 18)
6	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
7	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
8	Symfony\Component\HttpKernel\Kernel->handle (line 182)
9	handle (line 46)

0.21 ms
(0.40%)

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

#	File/Call
1	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 27)
2	Doctrine\ORM\Query->_doExecute (line 296)
3	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 930)
4	Doctrine\ORM\AbstractQuery->execute (line 886)
5	Doctrine\ORM\AbstractQuery->getResult (line 688)
6	NexCRM\WebBundle\Repository\MenuRepository->findByGroupOrdered (line 24)
7	App\Controller\BaseController->initialize (line 77)
8	App\Controller\PageController->pageAction (line 18)
9	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
10	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
11	Symfony\Component\HttpKernel\Kernel->handle (line 182)
12	handle (line 46)

0.19 ms
(0.35%)

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

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

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

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

#	File/Call
1	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 27)
2	Doctrine\ORM\Query->_doExecute (line 296)
3	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 930)
4	Doctrine\ORM\AbstractQuery->execute (line 886)
5	Doctrine\ORM\AbstractQuery->getResult (line 688)
6	NexCRM\WebBundle\Repository\MenuRepository->findByGroupOrdered (line 24)
7	App\Controller\BaseController->initialize (line 77)
8	App\Controller\PageController->pageAction (line 18)
9	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
10	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
11	Symfony\Component\HttpKernel\Kernel->handle (line 182)
12	handle (line 46)

0.19 ms
(0.35%)

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

Parameters:

[
  "5"
]

View formatted query View runnable query Explain query View query backtrace

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

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

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 738)
2	Doctrine\ORM\EntityRepository->findOneBy (line 125)
3	App\Controller\PageController->pageAction (line 19)
4	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
5	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
6	Symfony\Component\HttpKernel\Kernel->handle (line 182)
7	handle (line 46)

0.17 ms
(0.32%)

SELECT s0_.alias AS alias_0, s0_.value AS value_1, s0_.id AS id_2 FROM setting s0_ WHERE s0_.value <> ?

Parameters:

[
  ""
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  s0_.alias AS alias_0,
  s0_.value AS value_1,
  s0_.id AS id_2
FROM
  setting s0_
WHERE
  s0_.value <> ?

SELECT s0_.alias AS alias_0, s0_.value AS value_1, s0_.id AS id_2 FROM setting s0_ WHERE s0_.value <> '';

#	File/Call
1	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 27)
2	Doctrine\ORM\Query->_doExecute (line 296)
3	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 930)
4	Doctrine\ORM\AbstractQuery->execute (line 886)
5	Doctrine\ORM\AbstractQuery->getResult (line 688)
6	NexCRM\BaseBundle\Repository\SettingRepository->findBaseValues (line 31)
7	App\Service\CompanyTariffPaymentHelper->__construct (line 49)
8	ContainerM1ijjA9\App_KernelDevDebugContainer->getCompanyTariffPaymentHelperService (line 3094)
9	ContainerM1ijjA9\getTariffChangeListenerService::do (line 38)
10	ContainerM1ijjA9\App_KernelDevDebugContainer::load (line 1282)
11	Symfony\Component\DependencyInjection\Container->getService (line 399)
12	Symfony\Component\DependencyInjection\Argument\ServiceLocator->get (line 36)
13	Symfony\Bridge\Doctrine\ContainerAwareEventManager->initializeListeners (line 169)
14	Symfony\Bridge\Doctrine\ContainerAwareEventManager->getAllListeners (line 80)
15	Gedmo\Sortable\Entity\Repository\SortableRepository->__construct (line 55)
16	Doctrine\Bundle\DoctrineBundle\Repository\ContainerRepositoryFactory->getOrCreateRepository (line 116)
17	Doctrine\Bundle\DoctrineBundle\Repository\ContainerRepositoryFactory->doGetRepository (line 93)
18	Doctrine\Bundle\DoctrineBundle\Repository\ContainerRepositoryFactory->getRepository (line 29)
19	Doctrine\ORM\EntityManager->getRepository (line 499)
20	App\Service\InvoiceManager->__construct (line 102)
21	ContainerM1ijjA9\App_KernelDevDebugContainer->getInvoiceManagerService (line 3359)
22	ContainerM1ijjA9\getInvoiceDoctrineListenerService::do (line 33)
23	ContainerM1ijjA9\App_KernelDevDebugContainer::load (line 1271)
24	Symfony\Component\DependencyInjection\Container->getService (line 399)
25	Symfony\Component\DependencyInjection\Argument\ServiceLocator->get (line 36)
26	Symfony\Bridge\Doctrine\ContainerAwareEventManager->initializeListeners (line 169)
27	Symfony\Bridge\Doctrine\ContainerAwareEventManager->getAllListeners (line 80)
28	Gedmo\Sortable\Entity\Repository\SortableRepository->__construct (line 55)
29	Doctrine\Bundle\DoctrineBundle\Repository\ContainerRepositoryFactory->getOrCreateRepository (line 116)
30	Doctrine\Bundle\DoctrineBundle\Repository\ContainerRepositoryFactory->doGetRepository (line 93)
31	Doctrine\Bundle\DoctrineBundle\Repository\ContainerRepositoryFactory->getRepository (line 29)
32	Doctrine\ORM\EntityManager->getRepository (line 499)
33	App\Service\InvoiceManager->__construct (line 102)
34	ContainerM1ijjA9\App_KernelDevDebugContainer->getInvoiceManagerService (line 3359)
35	ContainerM1ijjA9\getInvoiceDoctrineListenerService::do (line 33)
36	ContainerM1ijjA9\App_KernelDevDebugContainer::load (line 1271)
37	Symfony\Component\DependencyInjection\Container->getService (line 399)
38	Symfony\Component\DependencyInjection\Argument\ServiceLocator->get (line 36)
39	Symfony\Bridge\Doctrine\ContainerAwareEventManager->initializeListeners (line 169)
40	Symfony\Bridge\Doctrine\ContainerAwareEventManager->getAllListeners (line 80)
41	Gedmo\Sortable\Entity\Repository\SortableRepository->__construct (line 55)
42	Doctrine\Bundle\DoctrineBundle\Repository\ContainerRepositoryFactory->getOrCreateRepository (line 116)
43	Doctrine\Bundle\DoctrineBundle\Repository\ContainerRepositoryFactory->doGetRepository (line 93)
44	Doctrine\Bundle\DoctrineBundle\Repository\ContainerRepositoryFactory->getRepository (line 29)
45	Doctrine\ORM\EntityManager->getRepository (line 499)
46	App\Service\InvoiceManager->__construct (line 102)
47	ContainerM1ijjA9\App_KernelDevDebugContainer->getInvoiceManagerService (line 3359)
48	ContainerM1ijjA9\getInvoiceDoctrineListenerService::do (line 33)
49	ContainerM1ijjA9\App_KernelDevDebugContainer::load (line 1282)
50	Symfony\Component\DependencyInjection\Container->getService (line 399)
51	Symfony\Component\DependencyInjection\Argument\ServiceLocator->get (line 36)
52	Symfony\Bridge\Doctrine\ContainerAwareEventManager->initializeListeners (line 169)
53	Symfony\Bridge\Doctrine\ContainerAwareEventManager->getAllListeners (line 80)
54	Gedmo\Sortable\Entity\Repository\SortableRepository->__construct (line 55)
55	Doctrine\Bundle\DoctrineBundle\Repository\ContainerRepositoryFactory->getOrCreateRepository (line 116)
56	Doctrine\Bundle\DoctrineBundle\Repository\ContainerRepositoryFactory->doGetRepository (line 93)
57	Doctrine\Bundle\DoctrineBundle\Repository\ContainerRepositoryFactory->getRepository (line 29)
58	Doctrine\ORM\EntityManager->getRepository (line 499)
59	App\Service\InvoiceManager->__construct (line 102)
60	ContainerM1ijjA9\App_KernelDevDebugContainer->getInvoiceManagerService (line 3359)
61	ContainerM1ijjA9\App_KernelDevDebugContainer::getTwigService (line 5594)
62	ContainerM1ijjA9\getPdfGeneratorService::do (line 28)
63	ContainerM1ijjA9\App_KernelDevDebugContainer::load (line 1282)
64	ContainerM1ijjA9\getInvoiceHistoryHelperService->do (line 38)
65	ContainerM1ijjA9\App_KernelDevDebugContainer::load (line 1282)
66	ContainerM1ijjA9\getCRUDPostPersistListenerService->do (line 28)
67	ContainerM1ijjA9\App_KernelDevDebugContainer::load (line 1282)
68	Symfony\Component\DependencyInjection\Container->getService (line 399)
69	Symfony\Component\DependencyInjection\Argument\ServiceLocator->get (line 36)
70	Symfony\Bridge\Doctrine\ContainerAwareEventManager->initializeListeners (line 169)
71	Symfony\Bridge\Doctrine\ContainerAwareEventManager->getAllListeners (line 80)
72	Gedmo\Sortable\Entity\Repository\SortableRepository->__construct (line 55)
73	Doctrine\Bundle\DoctrineBundle\Repository\ContainerRepositoryFactory->getOrCreateRepository (line 116)
74	Doctrine\Bundle\DoctrineBundle\Repository\ContainerRepositoryFactory->doGetRepository (line 93)
75	Doctrine\Bundle\DoctrineBundle\Repository\ContainerRepositoryFactory->getRepository (line 29)
76	Doctrine\ORM\EntityManager->getRepository (line 499)
77	NexCRM\BaseBundle\EventListener\LocaleListener->onKernelRequest (line 28)
78	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
79	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
80	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
81	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 126)
82	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 159)
83	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
84	Symfony\Component\HttpKernel\Kernel->handle (line 182)
85	handle (line 46)

0.16 ms
(0.31%)

SELECT t0.name AS name_1, t0.menu AS menu_2, t0.iso_2 AS iso_2_3, t0.iso_3 AS iso_3_4, t0.default_lang AS default_lang_5, t0.active AS active_6, t0.id AS id_7, t0.country AS country_8 FROM lang t0 WHERE t0.active = ?

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.name AS name_1,
  t0.menu AS menu_2,
  t0.iso_2 AS iso_2_3,
  t0.iso_3 AS iso_3_4,
  t0.default_lang AS default_lang_5,
  t0.active AS active_6,
  t0.id AS id_7,
  t0.country AS country_8
FROM
  lang t0
WHERE
  t0.active = ?

SELECT t0.name AS name_1, t0.menu AS menu_2, t0.iso_2 AS iso_2_3, t0.iso_3 AS iso_3_4, t0.default_lang AS default_lang_5, t0.active AS active_6, t0.id AS id_7, t0.country AS country_8 FROM lang t0 WHERE t0.active = 1;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 963)
2	Doctrine\ORM\EntityRepository->findBy (line 110)
3	NexCRM\BaseBundle\EventListener\LocaleListener->onKernelRequest (line 29)
4	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
5	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
6	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
7	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 126)
8	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 159)
9	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
10	Symfony\Component\HttpKernel\Kernel->handle (line 182)
11	handle (line 46)

0.16 ms
(0.29%)

SELECT t0.name AS name_1, t0.menu AS menu_2, t0.iso_2 AS iso_2_3, t0.iso_3 AS iso_3_4, t0.default_lang AS default_lang_5, t0.active AS active_6, t0.id AS id_7, t0.country AS country_8 FROM lang t0 WHERE t0.default_lang = ? LIMIT 1

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.name AS name_1,
  t0.menu AS menu_2,
  t0.iso_2 AS iso_2_3,
  t0.iso_3 AS iso_3_4,
  t0.default_lang AS default_lang_5,
  t0.active AS active_6,
  t0.id AS id_7,
  t0.country AS country_8
FROM
  lang t0
WHERE
  t0.default_lang = ?
LIMIT
  1

SELECT t0.name AS name_1, t0.menu AS menu_2, t0.iso_2 AS iso_2_3, t0.iso_3 AS iso_3_4, t0.default_lang AS default_lang_5, t0.active AS active_6, t0.id AS id_7, t0.country AS country_8 FROM lang t0 WHERE t0.default_lang = 1 LIMIT 1;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 738)
2	Doctrine\ORM\EntityRepository->findOneBy (line 125)
3	NexCRM\BaseBundle\EventListener\LocaleListener->onKernelRequest (line 31)
4	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
5	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
6	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
7	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 126)
8	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 159)
9	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
10	Symfony\Component\HttpKernel\Kernel->handle (line 182)
11	handle (line 46)

0.16 ms
(0.29%)

SELECT t0.url AS url_1, t0.name AS name_2, t0.id AS id_3, t0.locale AS locale_4, t0.translatable_id AS translatable_id_5, t6.entity AS entity_7, t6.controller AS controller_8, t6.bundle AS bundle_9, t6.action AS action_10, t6.id AS id_11 FROM web_module_translation t0 LEFT JOIN web_module t6 ON t0.translatable_id = t6.id WHERE t0.translatable_id = ?

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.url AS url_1,
  t0.name AS name_2,
  t0.id AS id_3,
  t0.locale AS locale_4,
  t0.translatable_id AS translatable_id_5,
  t6.entity AS entity_7,
  t6.controller AS controller_8,
  t6.bundle AS bundle_9,
  t6.action AS action_10,
  t6.id AS id_11
FROM
  web_module_translation t0
  LEFT JOIN web_module t6 ON t0.translatable_id = t6.id
WHERE
  t0.translatable_id = ?

SELECT t0.url AS url_1, t0.name AS name_2, t0.id AS id_3, t0.locale AS locale_4, t0.translatable_id AS translatable_id_5, t6.entity AS entity_7, t6.controller AS controller_8, t6.bundle AS bundle_9, t6.action AS action_10, t6.id AS id_11 FROM web_module_translation t0 LEFT JOIN web_module t6 ON t0.translatable_id = t6.id WHERE t0.translatable_id = 1;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getOneToManyStatement (line 1872)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToManyCollection (line 1817)
3	Doctrine\ORM\UnitOfWork->loadCollection (line 2729)
4	Doctrine\ORM\UnitOfWork->createEntity (line 2608)
5	Doctrine\ORM\Internal\Hydration\SimpleObjectHydrator->hydrateRowData (line 176)
6	Doctrine\ORM\Internal\Hydration\SimpleObjectHydrator->hydrateAllData (line 60)
7	Doctrine\ORM\Internal\Hydration\AbstractHydrator->hydrateAll (line 175)
8	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 746)
9	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 756)
10	Doctrine\ORM\Proxy\ProxyFactory->{closure:Doctrine\ORM\Proxy\ProxyFactory::createLazyInitializer():294} (line 295)
11	Proxies\__CG__\NexCRM\WebBundle\Entity\Module::{closure:{closure:Doctrine\ORM\Proxy\ProxyFactory::getProxyFactory():371}:372} (line 373)
12	Symfony\Component\VarExporter\Internal\LazyObjectState::initialize (line 60)
13	Proxies\__CG__\NexCRM\WebBundle\Entity\Module->__get (line 153)
14	NexCRM\WebBundle\Entity\Module->getEntity (line 48)
15	NexCRM\WebBundle\Repository\MenuRepository->findByGroupOrdered (line 30)
16	App\Controller\BaseController->initialize (line 77)
17	App\Controller\PageController->pageAction (line 18)
18	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
19	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
20	Symfony\Component\HttpKernel\Kernel->handle (line 182)
21	handle (line 46)

0.15 ms
(0.28%)

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

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

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

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

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 963)
2	Doctrine\ORM\EntityRepository->findBy (line 110)
3	App\Controller\BaseController->initialize (line 72)
4	App\Controller\PageController->pageAction (line 18)
5	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
6	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
7	Symfony\Component\HttpKernel\Kernel->handle (line 182)
8	handle (line 46)

0.13 ms
(0.25%)

SELECT t0.name AS name_1, t0.id AS id_2, t0.locale AS locale_3, t0.translatable_id AS translatable_id_4, t5.widget AS widget_6, t5.width AS width_7, t5.height AS height_8, t5.locked AS locked_9, t5.preferred AS preferred_10, t5.active AS active_11, t5.id AS id_12, t5.sort AS sort_13, t5.updated_at AS updated_at_14, t5.upload AS upload_15 FROM widget_translation t0 LEFT JOIN widget t5 ON t0.translatable_id = t5.id WHERE t0.translatable_id = ?

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.name AS name_1,
  t0.id AS id_2,
  t0.locale AS locale_3,
  t0.translatable_id AS translatable_id_4,
  t5.widget AS widget_6,
  t5.width AS width_7,
  t5.height AS height_8,
  t5.locked AS locked_9,
  t5.preferred AS preferred_10,
  t5.active AS active_11,
  t5.id AS id_12,
  t5.sort AS sort_13,
  t5.updated_at AS updated_at_14,
  t5.upload AS upload_15
FROM
  widget_translation t0
  LEFT JOIN widget t5 ON t0.translatable_id = t5.id
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, t5.widget AS widget_6, t5.width AS width_7, t5.height AS height_8, t5.locked AS locked_9, t5.preferred AS preferred_10, t5.active AS active_11, t5.id AS id_12, t5.sort AS sort_13, t5.updated_at AS updated_at_14, t5.upload AS upload_15 FROM widget_translation t0 LEFT JOIN widget t5 ON t0.translatable_id = t5.id WHERE t0.translatable_id = 1;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getOneToManyStatement (line 1872)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToManyCollection (line 1817)
3	Doctrine\ORM\UnitOfWork->loadCollection (line 2729)
4	Doctrine\ORM\UnitOfWork->createEntity (line 2608)
5	Doctrine\ORM\Internal\Hydration\ObjectHydrator->getEntity (line 268)
6	Doctrine\ORM\Internal\Hydration\ObjectHydrator->hydrateRowData (line 495)
7	Doctrine\ORM\Internal\Hydration\ObjectHydrator->hydrateAllData (line 147)
8	Doctrine\ORM\Internal\Hydration\AbstractHydrator->hydrateAll (line 175)
9	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 943)
10	Doctrine\ORM\AbstractQuery->execute (line 886)
11	Doctrine\ORM\AbstractQuery->getResult (line 688)
12	NexCRM\BaseBundle\Service\WidgetService->getWidgets (line 31)
13	NexCRM\BaseBundle\EventListener\WidgetBaseControllerConstructListener->onBaseControllerConstruct (line 35)
14	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
15	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
16	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
17	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 126)
18	NexCRM\BaseBundle\Controller\AbstractBaseController->dispatchBaseControllerConstructEvent (line 24)
19	ContainerM1ijjA9\getPageControllerService->do (line 29)
20	ContainerM1ijjA9\App_KernelDevDebugContainer::load (line 1282)
21	Symfony\Component\DependencyInjection\Container->make (line 221)
22	Symfony\Component\DependencyInjection\Container::get (line 203)
23	Symfony\Component\HttpKernel\Controller\ContainerControllerResolver->instantiateController (line 38)
24	Symfony\Bundle\FrameworkBundle\Controller\ControllerResolver->instantiateController (line 25)
25	Symfony\Component\HttpKernel\Controller\ControllerResolver->createController (line 127)
26	Symfony\Component\HttpKernel\Controller\ControllerResolver->getController (line 95)
27	Symfony\Component\HttpKernel\Controller\TraceableControllerResolver->getController (line 33)
28	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 166)
29	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
30	Symfony\Component\HttpKernel\Kernel->handle (line 182)
31	handle (line 46)

0.12 ms
(0.22%)

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

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

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

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

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 738)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 756)
3	Doctrine\ORM\Proxy\ProxyFactory->{closure:Doctrine\ORM\Proxy\ProxyFactory::createLazyInitializer():294} (line 295)
4	Proxies\__CG__\NexCRM\WebBundle\Entity\Module::{closure:{closure:Doctrine\ORM\Proxy\ProxyFactory::getProxyFactory():371}:372} (line 373)
5	Symfony\Component\VarExporter\Internal\LazyObjectState::initialize (line 60)
6	Proxies\__CG__\NexCRM\WebBundle\Entity\Module->__get (line 153)
7	NexCRM\WebBundle\Entity\Module->getEntity (line 48)
8	NexCRM\WebBundle\Repository\MenuRepository->findByGroupOrdered (line 30)
9	App\Controller\BaseController->initialize (line 77)
10	App\Controller\PageController->pageAction (line 18)
11	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
12	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
13	Symfony\Component\HttpKernel\Kernel->handle (line 182)
14	handle (line 46)

0.12 ms
(0.22%)

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\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 963)
2	Doctrine\ORM\EntityRepository->findBy (line 110)
3	NexCRM\WebBundle\Repository\MenuRepository->findByGroupOrdered (line 16)
4	App\Controller\BaseController->initialize (line 77)
5	App\Controller\PageController->pageAction (line 18)
6	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
7	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
8	Symfony\Component\HttpKernel\Kernel->handle (line 182)
9	handle (line 46)

0.11 ms
(0.21%)

SELECT t0.name AS name_1, t0.text AS text_2, t0.active AS active_3, t0.id AS id_4, t0.sort AS sort_5, t0.file_id AS file_id_6, t0.img_file_id AS img_file_id_7 FROM web_advantage t0 WHERE t0.active = ? ORDER BY t0.sort ASC

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.name AS name_1,
  t0.text AS text_2,
  t0.active AS active_3,
  t0.id AS id_4,
  t0.sort AS sort_5,
  t0.file_id AS file_id_6,
  t0.img_file_id AS img_file_id_7
FROM
  web_advantage t0
WHERE
  t0.active = ?
ORDER BY
  t0.sort ASC

SELECT t0.name AS name_1, t0.text AS text_2, t0.active AS active_3, t0.id AS id_4, t0.sort AS sort_5, t0.file_id AS file_id_6, t0.img_file_id AS img_file_id_7 FROM web_advantage t0 WHERE t0.active = 1 ORDER BY t0.sort ASC;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 963)
2	Doctrine\ORM\EntityRepository->findBy (line 110)
3	App\Controller\BaseController->initialize (line 75)
4	App\Controller\PageController->pageAction (line 18)
5	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
6	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
7	Symfony\Component\HttpKernel\Kernel->handle (line 182)
8	handle (line 46)

Database Connections

Name	Service
default	doctrine.dbal.default_connection

Entity Managers

Name	Service
default	doctrine.orm.default_entity_manager

Second Level Cache

Second Level Cache is not enabled.

Managed Entities

default entity manager

Class	Amount of managed objects
NexCRM\BaseBundle\Entity\LangToken	14550
NexCRM\BaseBundle\Entity\Setting	92
NexCRM\BaseBundle\Entity\LangTranslation	43
NexCRM\WebBundle\Entity\PageTranslation	22
NexCRM\WebBundle\Entity\Page	21
NexCRM\WebBundle\Entity\SEO	21
NexCRM\WebBundle\Entity\Menu	11
NexCRM\WebBundle\Entity\MenuTranslation	11
NexCRM\WebBundle\Entity\CodeTranslation	10
NexCRM\WebBundle\Entity\SEOTranslation	9
NexCRM\WebBundle\Entity\TemplateTranslation	9
NexCRM\WebBundle\Entity\Template	7
App\Entity\Tariff	7
NexCRM\WebBundle\Entity\MenuGroupTranslation	6
NexCRM\BaseBundle\Entity\SettingTranslation	5
App\Entity\Advantage	4
NexCRM\WebBundle\Entity\MenuGroup	4
App\Entity\Reference	3
App\Entity\WebTariffItem	3
App\Entity\Faq	2
NexCRM\WebBundle\Entity\ModuleTranslation	2
NexCRM\WebBundle\Entity\Code	2
App\Entity\Vat	1
NexCRM\BaseBundle\Entity\Lang	1
NexCRM\BaseBundle\Entity\Country	1
NexCRM\BaseBundle\Entity\Widget	1
NexCRM\BaseBundle\Entity\WidgetTranslation	1
NexCRM\WebBundle\Entity\Module	1
NexCRM\WebBundle\Entity\SliderGroup	1
App\Entity\WebEmployee	1
NexCRM\DMSBundle\Entity\File	1

Entities Mapping

Class	Mapping errors
NexCRM\BaseBundle\Entity\Lang	No errors.
App\Entity\Vat	No errors.
App\Entity\FinancialDiary	No errors.
App\Entity\SyntheticAccount	No errors.
App\Entity\VatExport	No errors.
NexCRM\BaseBundle\Entity\Setting	No errors.
NexCRM\BaseBundle\Entity\SettingTranslation	No errors.
NexCRM\BaseBundle\Entity\Country	No errors.
NexCRM\BaseBundle\Entity\Widget	No errors.
NexCRM\BaseBundle\Entity\WidgetUser	No errors.
NexCRM\BaseBundle\Entity\WidgetTranslation	No errors.
NexCRM\CompanyBundle\Entity\Company	The mappings NexCRM\CompanyBundle\Entity\Company#tariffPayments and App\Entity\CompanyTariffPayment#company are inconsistent with each other.
NexCRM\CompanyBundle\Entity\Subject	No errors.
NexCRM\CompanyBundle\Entity\VatPayer	No errors.
NexCRM\CompanyBundle\Entity\EvidenceType	No errors.
App\Entity\SyntheticAccountGroup	No errors.
App\Entity\SyntheticAccountPeriod	No errors.
App\Entity\Tariff	No errors.
App\Entity\AccountingOffice	No errors.
App\Entity\CompanyTariffInfo	The field App\Entity\CompanyTariffInfo#company is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity NexCRM\CompanyBundle\Entity\Company#tariffInfo does not contain the required 'inversedBy: "company"' attribute.
App\Entity\Contact	No errors.
NexCRM\WebBundle\Entity\Page	No errors.
NexCRM\WebBundle\Entity\SEO	No errors.
NexCRM\WebBundle\Entity\Template	No errors.
NexCRM\DMSBundle\Entity\File	No errors.
NexCRM\WebBundle\Entity\Content	No errors.
NexCRM\WebBundle\Entity\PageTranslation	No errors.
App\Entity\Faq	No errors.
App\Entity\Reference	No errors.
App\Entity\Advantage	No errors.
NexCRM\BaseBundle\Entity\Role	No errors.
App\Entity\HelpScript	The association App\Entity\HelpScript#helpScriptTariffPackages refers to the inverse side field App\Entity\TariffPackage#helpScriptTariffs which does not exist.
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\Slider	No errors.
NexCRM\WebBundle\Entity\SliderGroup	No errors.
NexCRM\BaseBundle\Entity\User	No errors.
NexCRM\WebBundle\Entity\Block	No errors.
NexCRM\WebBundle\Entity\TemplateTranslation	No errors.
App\Entity\WebEmployee	No errors.
App\Entity\WebTariffItem	No errors.
App\Entity\AppFunction	No errors.
NexCRM\WebBundle\Entity\Code	No errors.
NexCRM\WebBundle\Entity\CodeTranslation	No errors.
NexCRM\BaseBundle\Entity\LangToken	No errors.
NexCRM\BaseBundle\Entity\LangTranslation	No errors.
NexCRM\DMSBundle\Entity\Folder	No errors.
NexCRM\DMSBundle\Entity\Filter	No errors.
NexCRM\DMSBundle\Entity\FileType	No errors.
NexCRM\DMSBundle\Entity\NumericalRoot	No errors.
App\Entity\AgendaSubFolder	No errors.
App\Entity\AgendaPeriod	No errors.
App\Entity\Center	No errors.
App\Entity\Project	No errors.
App\Entity\Activity	No errors.
App\Entity\PaymentType	No errors.
App\Entity\Currency	No errors.
App\Entity\AccountAssigment	No errors.
App\Entity\VatBreakdown	No errors.
NexCRM\DMSBundle\Entity\NumericalRootDefinition	No errors.
NexCRM\PersonBundle\Entity\BankDetail	No errors.
App\Entity\FileFieldData	No errors.
NexCRM\DMSBundle\Entity\FileParameters	No errors.

Symfony Profiler

GET https://nexgen.yopaz.dev/kontakt

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping