Symfony Profiler

Query Metrics

59 Database Queries

6 Different statements

7.13 ms Query time

0 Invalid entities

46 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

4.73 ms
(66.43%)

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)

1.50 ms
(21.04%)

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)

0.24 ms
(3.40%)

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.24 ms
(3.34%)

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.24 ms
(3.34%)

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.17 ms
(2.46%)

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)

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\Setting	43
App\Entity\Vat	1
NexCRM\BaseBundle\Entity\Lang	1
NexCRM\BaseBundle\Entity\Country	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.

Symfony Profiler

GET https://nexgen.yopaz.dev/

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping