Symfony Profiler

Query Metrics

17 Database Queries

7 Different statements

13.67 ms Query time

0 Invalid entities

19 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

4.12 ms
(30.12%)

SELECT t0.id AS id_1, t0.title AS title_2, t0.status AS status_3, t0.language AS language_4, t0.user AS user_5, t0.slug AS slug_6, t0.last_update_by AS last_update_by_7, t0.last_update AS last_update_8, t0.insert_date AS insert_date_9 FROM pages t0 WHERE t0.slug = ? LIMIT 1

Parameters:

[
  "sitemap.xml"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.status AS status_3,
  t0.language AS language_4,
  t0.user AS user_5,
  t0.slug AS slug_6,
  t0.last_update_by AS last_update_by_7,
  t0.last_update AS last_update_8,
  t0.insert_date AS insert_date_9
FROM
  pages t0
WHERE
  t0.slug = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.title AS title_2, t0.status AS status_3, t0.language AS language_4, t0.user AS user_5, t0.slug AS slug_6, t0.last_update_by AS last_update_by_7, t0.last_update AS last_update_8, t0.insert_date AS insert_date_9 FROM pages t0 WHERE t0.slug = 'sitemap.xml' LIMIT 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 736)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 125)
3	Doctrine\ORM\EntityRepository->findOneBy (line 81)
4	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findOneBy (line 1114)
5	App\Themes\Default\Controller\Main->page (line 125)
6	App\Themes\Default\Controller\Main->main (line 183)
7	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
8	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
9	Symfony\Component\HttpKernel\Kernel->handle (line 35)
10	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
11	require_once (line 14)

2.99 ms
(21.88%)

SELECT t0.id AS id_1, t0.name_id AS name_id_2, t0.category_id AS category_id_3, t0.name AS name_4, t0.value AS value_5 FROM options t0 WHERE t0.name_id = ? AND t0.category_id = ? LIMIT 1

Parameters:

[
  "pref"
  "settings"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name_id AS name_id_2,
  t0.category_id AS category_id_3,
  t0.name AS name_4,
  t0.value AS value_5
FROM
  options t0
WHERE
  t0.name_id = ?
  AND t0.category_id = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name_id AS name_id_2, t0.category_id AS category_id_3, t0.name AS name_4, t0.value AS value_5 FROM options t0 WHERE t0.name_id = 'pref' AND t0.category_id = 'settings' LIMIT 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 736)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 125)
3	Doctrine\ORM\EntityRepository->findOneBy (line 81)
4	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findOneBy (line 66)
5	App\Service\Utils\Options->get (line 83)
6	App\Service\FrontEndOptions->init (line 148)
7	App\Service\FrontEndOptions->getLanguage (line 29)
8	App\EventListener\FirstRequestListener->onKernelRequest (line 115)
9	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 206)
10	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
11	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 122)
12	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 159)
13	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
14	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
15	Symfony\Component\HttpKernel\Kernel->handle (line 35)
16	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
17	require_once (line 14)

2.49 ms
(18.23%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.image AS image_3, t0.controller AS controller_4, t0.config AS config_5, t0.active AS active_6, t0.insert_date AS insert_date_7, t0.channel_id AS channel_id_8 FROM integrations t0 WHERE t0.controller = ? LIMIT 1

Parameters:

[
  "App\Controller\Plugins\Integrations\Impact"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.image AS image_3,
  t0.controller AS controller_4,
  t0.config AS config_5,
  t0.active AS active_6,
  t0.insert_date AS insert_date_7,
  t0.channel_id AS channel_id_8
FROM
  integrations t0
WHERE
  t0.controller = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.image AS image_3, t0.controller AS controller_4, t0.config AS config_5, t0.active AS active_6, t0.insert_date AS insert_date_7, t0.channel_id AS channel_id_8 FROM integrations t0 WHERE t0.controller = 'App\\Controller\\Plugins\\Integrations\\Impact' LIMIT 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 736)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 125)
3	Doctrine\ORM\EntityRepository->findOneBy (line 81)
4	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findOneBy (line 27)
5	App\Repository\IntegrationsRepository->getByControllerName (line 58)
6	App\Service\Plugins\Integrations\Impact\ImpactService->__construct (line 1668)
7	ContainerKrZqq0I\App_KernelDevDebugContainer::getImpactServiceService (line 1637)
8	ContainerKrZqq0I\App_KernelDevDebugContainer::getImpactFetchService (line 1688)
9	ContainerKrZqq0I\App_KernelDevDebugContainer::getImpactStoresGridService (line 2330)
10	ContainerKrZqq0I\App_KernelDevDebugContainer::getApp_EventListener_MainListenerService (line 1037)
11	ContainerKrZqq0I\App_KernelDevDebugContainer::ContainerKrZqq0I\{closure} (line 221)
12	Symfony\Component\EventDispatcher\EventDispatcher->sortListeners (line 70)
13	Symfony\Component\EventDispatcher\EventDispatcher->getListeners (line 252)
14	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->preProcess (line 116)
15	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 171)
16	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
17	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
18	Symfony\Component\HttpKernel\Kernel->handle (line 35)
19	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
20	require_once (line 14)

2.02 ms
(14.79%)

SELECT t0.id AS id_1, t0.label_id AS label_id_2, t0.integration AS integration_3, t0.config AS config_4, t0.last_execution AS last_execution_5, t0.every_minutes AS every_minutes_6, t0.next_execution AS next_execution_7 FROM cron t0 WHERE t0.label_id = ? LIMIT 1

Parameters:

[
  "impact_fetch_data"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.label_id AS label_id_2,
  t0.integration AS integration_3,
  t0.config AS config_4,
  t0.last_execution AS last_execution_5,
  t0.every_minutes AS every_minutes_6,
  t0.next_execution AS next_execution_7
FROM
  cron t0
WHERE
  t0.label_id = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.label_id AS label_id_2, t0.integration AS integration_3, t0.config AS config_4, t0.last_execution AS last_execution_5, t0.every_minutes AS every_minutes_6, t0.next_execution AS next_execution_7 FROM cron t0 WHERE t0.label_id = 'impact_fetch_data' LIMIT 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 736)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 125)
3	Doctrine\ORM\EntityRepository->findOneBy (line 81)
4	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findOneBy (line 57)
5	App\Service\Plugins\Integrations\Impact\ImpactFetch->__construct (line 1637)
6	ContainerKrZqq0I\App_KernelDevDebugContainer::getImpactFetchService (line 1688)
7	ContainerKrZqq0I\App_KernelDevDebugContainer::getImpactStoresGridService (line 2330)
8	ContainerKrZqq0I\App_KernelDevDebugContainer::getApp_EventListener_MainListenerService (line 1037)
9	ContainerKrZqq0I\App_KernelDevDebugContainer::ContainerKrZqq0I\{closure} (line 221)
10	Symfony\Component\EventDispatcher\EventDispatcher->sortListeners (line 70)
11	Symfony\Component\EventDispatcher\EventDispatcher->getListeners (line 252)
12	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->preProcess (line 116)
13	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 171)
14	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
15	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
16	Symfony\Component\HttpKernel\Kernel->handle (line 35)
17	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
18	require_once (line 14)

0.91 ms
(6.67%)

SELECT t0.id AS id_1, t0.name_id AS name_id_2, t0.category_id AS category_id_3, t0.name AS name_4, t0.value AS value_5 FROM options t0 WHERE t0.category_id = ?

Parameters:

[
  "paths"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name_id AS name_id_2,
  t0.category_id AS category_id_3,
  t0.name AS name_4,
  t0.value AS value_5
FROM
  options t0
WHERE
  t0.category_id = ?

SELECT t0.id AS id_1, t0.name_id AS name_id_2, t0.category_id AS category_id_3, t0.name AS name_4, t0.value AS value_5 FROM options t0 WHERE t0.category_id = 'paths';

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 938)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 110)
3	Doctrine\ORM\EntityRepository->findBy (line 73)
4	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findBy (line 154)
5	App\Service\Utils\Options->getAllCategory (line 25)
6	App\Service\FrontEndRouter->__construct (line 23)
7	ContainerKrZqq0I\getFrontEndRouterService::do (line 779)
8	ContainerKrZqq0I\App_KernelDevDebugContainer->load (line 23)
9	ContainerKrZqq0I\getFrontEndBundleService::do (line 779)
10	ContainerKrZqq0I\App_KernelDevDebugContainer->load (line 399)
11	Symfony\Component\DependencyInjection\Container->getService (line 36)
12	Symfony\Component\DependencyInjection\Argument\ServiceLocator->get (line 56)
13	Symfony\Component\HttpKernel\Controller\ArgumentResolver\ServiceValueResolver->resolve (line 37)
14	Symfony\Component\HttpKernel\Controller\ArgumentResolver\TraceableValueResolver->resolve (line 91)
15	Symfony\Component\HttpKernel\Controller\ArgumentResolver->getArguments (line 33)
16	Symfony\Component\HttpKernel\Controller\TraceableArgumentResolver->getArguments (line 175)
17	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
18	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
19	Symfony\Component\HttpKernel\Kernel->handle (line 35)
20	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
21	require_once (line 14)

0.63 ms
(4.62%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.iso_code AS iso_code_3, t0.icon AS icon_4, t0.def_language AS def_language_5, t0.visible AS visible_6, t0.insert_date AS insert_date_7 FROM countries t0 WHERE t0.iso_code = ? LIMIT 1

Parameters:

[
  "US"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.iso_code AS iso_code_3,
  t0.icon AS icon_4,
  t0.def_language AS def_language_5,
  t0.visible AS visible_6,
  t0.insert_date AS insert_date_7
FROM
  countries t0
WHERE
  t0.iso_code = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.iso_code AS iso_code_3, t0.icon AS icon_4, t0.def_language AS def_language_5, t0.visible AS visible_6, t0.insert_date AS insert_date_7 FROM countries t0 WHERE t0.iso_code = 'US' LIMIT 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 736)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 125)
3	Doctrine\ORM\EntityRepository->findOneBy (line 81)
4	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findOneBy (line 98)
5	App\Service\FrontEndOptions->init (line 148)
6	App\Service\FrontEndOptions->getLanguage (line 29)
7	App\EventListener\FirstRequestListener->onKernelRequest (line 115)
8	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 206)
9	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
10	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 122)
11	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 159)
12	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
13	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
14	Symfony\Component\HttpKernel\Kernel->handle (line 35)
15	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
16	require_once (line 14)

0.51 ms
(3.70%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.route AS route_3, t0.icon AS icon_4, t0.parent AS parent_5, t0.menu_position AS menu_position_6, t0.popup_open AS popup_open_7, t0.mandatory AS mandatory_8, t0.menu_default AS menu_default_9 FROM modules t0 WHERE t0.route = ? LIMIT 1

Parameters:

[
  "main_path"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.route AS route_3,
  t0.icon AS icon_4,
  t0.parent AS parent_5,
  t0.menu_position AS menu_position_6,
  t0.popup_open AS popup_open_7,
  t0.mandatory AS mandatory_8,
  t0.menu_default AS menu_default_9
FROM
  modules t0
WHERE
  t0.route = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.route AS route_3, t0.icon AS icon_4, t0.parent AS parent_5, t0.menu_position AS menu_position_6, t0.popup_open AS popup_open_7, t0.mandatory AS mandatory_8, t0.menu_default AS menu_default_9 FROM modules t0 WHERE t0.route = 'main_path' LIMIT 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 736)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 125)
3	Doctrine\ORM\EntityRepository->findOneBy (line 81)
4	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findOneBy (line 30)
5	App\Service\ModulesManager->checkRoute (line 75)
6	App\EventListener\MainListener->onKernelController (line 115)
7	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 206)
8	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
9	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 122)
10	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 171)
11	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
12	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
13	Symfony\Component\HttpKernel\Kernel->handle (line 35)
14	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
15	require_once (line 14)

Database Connections

Name	Service
default	doctrine.dbal.default_connection

Entity Managers

Name	Service
default	doctrine.orm.default_entity_manager

Second Level Cache

Second Level Cache is not enabled.

Managed Entities

default entity manager

Class	Amount of managed objects
App\Entity\Options	8
App\Entity\Integrations	4
App\Entity\Channels	4
App\Entity\Cron	3

Entities Mapping

Class	Mapping errors
App\Entity\Options	No errors.
App\Entity\Countries	No errors.
App\Entity\Integrations	No errors.
App\Entity\Channels	No errors.
App\Entity\Cron	No errors.
App\Entity\Modules	No errors.
App\Entity\Pages	No errors.

Symfony Profiler

GET https://ccms.shady.ro/sitemap.xml

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping