Symfony Profiler

Query Metrics

22 Database Queries

10 Different statements

39.48 ms Query time

0 Invalid entities

33 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

23.36 ms
(59.18%)

SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.logo AS logo_2, s0_.cover_image AS cover_image_3, s0_.url AS url_4, s0_.cashback AS cashback_5, s0_.featured AS featured_6, s0_.offline AS offline_7, s0_.status AS status_8, s0_.channel AS channel_9, s0_.ext_mapping AS ext_mapping_10, s0_.insert_date AS insert_date_11, COUNT(c1_.id) AS sclr_12, MAX(CASE WHEN f2_.id IS NOT NULL THEN 1 ELSE 0 END) AS sclr_13 FROM stores s0_ INNER JOIN countries_lnk c3_ ON (c3_.entity_type = 1 AND c3_.entity_id = s0_.id AND c3_.country = ?) LEFT JOIN coupons c1_ ON (c1_.store_id = s0_.id AND c1_.status = 1) LEFT JOIN favorites_lnk f2_ ON (f2_.store_id = s0_.id AND (f2_.user_id = ? OR (f2_.user_id IS NULL AND f2_.client_ip = ?))) WHERE s0_.status = ? AND s0_.featured = ? GROUP BY s0_.id LIMIT 10

Parameters:

[
  "1"
  null
  ""
  1
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  s0_.id AS id_0,
  s0_.name AS name_1,
  s0_.logo AS logo_2,
  s0_.cover_image AS cover_image_3,
  s0_.url AS url_4,
  s0_.cashback AS cashback_5,
  s0_.featured AS featured_6,
  s0_.offline AS offline_7,
  s0_.status AS status_8,
  s0_.channel AS channel_9,
  s0_.ext_mapping AS ext_mapping_10,
  s0_.insert_date AS insert_date_11,
  COUNT(c1_.id) AS sclr_12,
  MAX(
    CASE WHEN f2_.id IS NOT NULL THEN
      1
    ELSE
      0
    END
  ) AS sclr_13
FROM
  stores s0_
  INNER JOIN countries_lnk c3_ ON (
    c3_.entity_type = 1
    AND c3_.entity_id = s0_.id
    AND c3_.country = ?
  )
  LEFT JOIN coupons c1_ ON (
    c1_.store_id = s0_.id
    AND c1_.status = 1
  )
  LEFT JOIN favorites_lnk f2_ ON (
    f2_.store_id = s0_.id
    AND (
      f2_.user_id = ?
      OR (
        f2_.user_id IS NULL
        AND f2_.client_ip = ?
      )
    )
  )
WHERE
  s0_.status = ?
  AND s0_.featured = ?
GROUP BY
  s0_.id
LIMIT
  10

SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.logo AS logo_2, s0_.cover_image AS cover_image_3, s0_.url AS url_4, s0_.cashback AS cashback_5, s0_.featured AS featured_6, s0_.offline AS offline_7, s0_.status AS status_8, s0_.channel AS channel_9, s0_.ext_mapping AS ext_mapping_10, s0_.insert_date AS insert_date_11, COUNT(c1_.id) AS sclr_12, MAX(CASE WHEN f2_.id IS NOT NULL THEN 1 ELSE 0 END) AS sclr_13 FROM stores s0_ INNER JOIN countries_lnk c3_ ON (c3_.entity_type = 1 AND c3_.entity_id = s0_.id AND c3_.country = '1') LEFT JOIN coupons c1_ ON (c1_.store_id = s0_.id AND c1_.status = 1) LEFT JOIN favorites_lnk f2_ ON (f2_.store_id = s0_.id AND (f2_.user_id = NULL OR (f2_.user_id IS NULL AND f2_.client_ip = ''))) WHERE s0_.status = 1 AND s0_.featured = 1 GROUP BY s0_.id LIMIT 10;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 27)
2	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 296)
3	Doctrine\ORM\Query->_doExecute (line 935)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 891)
5	Doctrine\ORM\AbstractQuery->execute (line 689)
6	Doctrine\ORM\AbstractQuery->getResult (line 292)
7	App\Service\GetDataService->getStores (line 1882)
8	Twig\Extension\CoreExtension::getAttribute (line 245)
9	__TwigTemplate_17bba3be98e94df6278ffd9e9efda1e4->doDisplay (line 388)
10	Twig\Template->yield (line 344)
11	Twig\Template->display (line 359)
12	Twig\Template->render (line 51)
13	Twig\TemplateWrapper->render (line 334)
14	Twig\Environment->render (line 431)
15	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 229)
16	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->renderView (line 75)
17	App\Controller\Common\MainController->response (line 33)
18	App\Themes\Default\Controller\Home->homePage (line 183)
19	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
20	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
21	Symfony\Component\HttpKernel\Kernel->handle (line 35)
22	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
23	require_once (line 14)

3.41 ms
(8.63%)

SELECT t0_.id AS id_0, t0_.image AS image_1, t0_.config AS config_2, t0_.visible AS visible_3, t0_.position AS position_4, t0_.insert_date AS insert_date_5 FROM theme_slider t0_ WHERE t0_.visible = 1 ORDER BY t0_.position ASC

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0_.id AS id_0,
  t0_.image AS image_1,
  t0_.config AS config_2,
  t0_.visible AS visible_3,
  t0_.position AS position_4,
  t0_.insert_date AS insert_date_5
FROM
  theme_slider t0_
WHERE
  t0_.visible = 1
ORDER BY
  t0_.position ASC

SELECT t0_.id AS id_0, t0_.image AS image_1, t0_.config AS config_2, t0_.visible AS visible_3, t0_.position AS position_4, t0_.insert_date AS insert_date_5 FROM theme_slider t0_ WHERE t0_.visible = 1 ORDER BY t0_.position ASC;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 27)
2	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 296)
3	Doctrine\ORM\Query->_doExecute (line 935)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 891)
5	Doctrine\ORM\AbstractQuery->execute (line 689)
6	Doctrine\ORM\AbstractQuery->getResult (line 28)
7	App\Themes\Default\Repository\ThemeSliderRepository->getSlides (line 17)
8	App\Themes\Default\Service\ThemeDataService->getSlider (line 37)
9	App\Themes\Default\Controller\Home->homePage (line 183)
10	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
11	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
12	Symfony\Component\HttpKernel\Kernel->handle (line 35)
13	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
14	require_once (line 14)

3.38 ms
(8.57%)

SELECT COUNT(DISTINCT s0_.id) AS sclr_0 FROM stores s0_ INNER JOIN countries_lnk c1_ ON (c1_.entity_type = 1 AND c1_.entity_id = s0_.id AND c1_.country = ?) WHERE s0_.status = ? AND s0_.featured = ?

Parameters:

[
  "1"
  1
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  COUNT(DISTINCT s0_.id) AS sclr_0
FROM
  stores s0_
  INNER JOIN countries_lnk c1_ ON (
    c1_.entity_type = 1
    AND c1_.entity_id = s0_.id
    AND c1_.country = ?
  )
WHERE
  s0_.status = ?
  AND s0_.featured = ?

SELECT COUNT(DISTINCT s0_.id) AS sclr_0 FROM stores s0_ INNER JOIN countries_lnk c1_ ON (c1_.entity_type = 1 AND c1_.entity_id = s0_.id AND c1_.country = '1') WHERE s0_.status = 1 AND s0_.featured = 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 27)
2	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 296)
3	Doctrine\ORM\Query->_doExecute (line 935)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 891)
5	Doctrine\ORM\AbstractQuery->execute (line 773)
6	Doctrine\ORM\AbstractQuery->getSingleResult (line 802)
7	Doctrine\ORM\AbstractQuery->getSingleScalarResult (line 293)
8	App\Service\GetDataService->getStores (line 1882)
9	Twig\Extension\CoreExtension::getAttribute (line 245)
10	__TwigTemplate_17bba3be98e94df6278ffd9e9efda1e4->doDisplay (line 388)
11	Twig\Template->yield (line 344)
12	Twig\Template->display (line 359)
13	Twig\Template->render (line 51)
14	Twig\TemplateWrapper->render (line 334)
15	Twig\Environment->render (line 431)
16	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 229)
17	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->renderView (line 75)
18	App\Controller\Common\MainController->response (line 33)
19	App\Themes\Default\Controller\Home->homePage (line 183)
20	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
21	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
22	Symfony\Component\HttpKernel\Kernel->handle (line 35)
23	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
24	require_once (line 14)

2.46 ms
(6.22%)

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 82)
6	App\Service\FrontEndOptions->init (line 147)
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.24 ms
(5.67%)

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 1673)
7	ContainerULRRlq6\App_KernelDevDebugContainer::getImpactServiceService (line 1642)
8	ContainerULRRlq6\App_KernelDevDebugContainer::getImpactFetchService (line 1693)
9	ContainerULRRlq6\App_KernelDevDebugContainer::getImpactStoresGridService (line 2326)
10	ContainerULRRlq6\App_KernelDevDebugContainer::getApp_EventListener_MainListenerService (line 1043)
11	ContainerULRRlq6\App_KernelDevDebugContainer::ContainerULRRlq6\{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)

1.77 ms
(4.48%)

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 1642)
6	ContainerULRRlq6\App_KernelDevDebugContainer::getImpactFetchService (line 1693)
7	ContainerULRRlq6\App_KernelDevDebugContainer::getImpactStoresGridService (line 2326)
8	ContainerULRRlq6\App_KernelDevDebugContainer::getApp_EventListener_MainListenerService (line 1043)
9	ContainerULRRlq6\App_KernelDevDebugContainer::ContainerULRRlq6\{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)

1.02 ms
(2.59%)

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	ContainerULRRlq6\getFrontEndRouterService::do (line 784)
8	ContainerULRRlq6\App_KernelDevDebugContainer->load (line 23)
9	ContainerULRRlq6\getFrontEndBundleService::do (line 784)
10	ContainerULRRlq6\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.78 ms
(1.98%)

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 97)
5	App\Service\FrontEndOptions->init (line 147)
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.70 ms
(1.77%)

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

Parameters:

[
  "1"
]

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

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.id = '1';

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 736)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 754)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 362)
4	Doctrine\ORM\EntityManager->find (line 86)
5	Doctrine\ORM\EntityRepository->find (line 61)
6	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->find (line 139)
7	App\Service\FrontEndOptions->getCountryObj (line 1882)
8	Twig\Extension\CoreExtension::getAttribute (line 369)
9	__TwigTemplate_433d034a7ae82d98678926748389140f->doDisplay (line 388)
10	Twig\Template->yield (line 344)
11	Twig\Template->display (line 359)
12	Twig\Template->render (line 51)
13	Twig\TemplateWrapper->render (line 334)
14	Twig\Environment->render (line 431)
15	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 436)
16	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 250)
17	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 96)
18	App\Controller\Common\MainController->response (line 33)
19	App\Themes\Default\Controller\Home->homePage (line 183)
20	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
21	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
22	Symfony\Component\HttpKernel\Kernel->handle (line 35)
23	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
24	require_once (line 14)

0.37 ms
(0.93%)

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:

[
  "index"
]

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 = 'index' 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\Stores	10
App\Entity\Options	8
App\Entity\Integrations	4
App\Entity\Channels	4
App\Entity\Cron	3
App\Themes\Default\Entity\ThemeSlider	3
App\Entity\Countries	1

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\Themes\Default\Entity\ThemeSlider	No errors.
App\Entity\Stores	No errors.
App\Entity\CountriesLnk	No errors.
App\Entity\Coupons	No errors.
App\Entity\FavoritesLnk	No errors.

Symfony Profiler

GET https://ccms.shady.ro/

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping