Symfony Profiler

Query Metrics

4 Database Queries

4 Different statements

4.54 ms Query time

0 Invalid entities

6 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

3.63 ms
(80.03%)

SELECT t0.id AS id_1, t0.title AS title_2, t0.content AS content_3, t0.meta_title AS meta_title_4, t0.meta_description AS meta_description_5, t0.title_uk AS title_uk_6, t0.content_uk AS content_uk_7, t0.meta_title_uk AS meta_title_uk_8, t0.meta_description_uk AS meta_description_uk_9, t0.title_ru AS title_ru_10, t0.content_ru AS content_ru_11, t0.meta_title_ru AS meta_title_ru_12, t0.meta_description_ru AS meta_description_ru_13, t0.slug AS slug_14, t0.enabled AS enabled_15 FROM page t0 WHERE t0.slug = ? AND t0.enabled = ? LIMIT 1

Parameters:

[
  "how-it-works"
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.content AS content_3,
  t0.meta_title AS meta_title_4,
  t0.meta_description AS meta_description_5,
  t0.title_uk AS title_uk_6,
  t0.content_uk AS content_uk_7,
  t0.meta_title_uk AS meta_title_uk_8,
  t0.meta_description_uk AS meta_description_uk_9,
  t0.title_ru AS title_ru_10,
  t0.content_ru AS content_ru_11,
  t0.meta_title_ru AS meta_title_ru_12,
  t0.meta_description_ru AS meta_description_ru_13,
  t0.slug AS slug_14,
  t0.enabled AS enabled_15
FROM
  page t0
WHERE
  t0.slug = ?
  AND t0.enabled = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.title AS title_2, t0.content AS content_3, t0.meta_title AS meta_title_4, t0.meta_description AS meta_description_5, t0.title_uk AS title_uk_6, t0.content_uk AS content_uk_7, t0.meta_title_uk AS meta_title_uk_8, t0.meta_description_uk AS meta_description_uk_9, t0.title_ru AS title_ru_10, t0.content_ru AS content_ru_11, t0.meta_title_ru AS meta_title_ru_12, t0.meta_description_ru AS meta_description_ru_13, t0.slug AS slug_14, t0.enabled AS enabled_15 FROM page t0 WHERE t0.slug = 'how-it-works' AND t0.enabled = 1 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 17)
4	App\Controller\PageController->show (line 183)
5	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
6	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
7	Symfony\Component\HttpKernel\Kernel->handle (line 35)
8	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
9	require_once (line 5)

0.33 ms
(7.29%)

SELECT t0.id AS id_1, t0.platform AS platform_2, t0.url AS url_3, t0.icon_class AS icon_class_4 FROM social_link t0

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.platform AS platform_2,
  t0.url AS url_3,
  t0.icon_class AS icon_class_4
FROM
  social_link t0

SELECT t0.id AS id_1, t0.platform AS platform_2, t0.url AS url_3, t0.icon_class AS icon_class_4 FROM social_link t0;

#	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 96)
5	Doctrine\ORM\EntityRepository->findAll (line 23)
6	App\Twig\Extension\AppExtension->getGlobals (line 352)
7	Twig\ExtensionSet->getGlobals (line 901)
8	Twig\Environment->getGlobals (line 384)
9	Twig\Template->yield (line 344)
10	Twig\Template->display (line 359)
11	Twig\Template->render (line 51)
12	Twig\TemplateWrapper->render (line 334)
13	Twig\Environment->render (line 431)
14	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 436)
15	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 250)
16	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 48)
17	App\Controller\PageController->show (line 183)
18	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
19	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
20	Symfony\Component\HttpKernel\Kernel->handle (line 35)
21	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
22	require_once (line 5)

0.30 ms
(6.65%)

SELECT COUNT(*) FROM model3_d t0

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  COUNT(*)
FROM
  model3_d t0

SELECT COUNT(*) FROM model3_d t0;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 865)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->count (line 140)
3	Doctrine\ORM\EntityRepository->count (line 87)
4	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->count (line 21)
5	App\Twig\Extension\GlobalVariablesExtension->getGlobals (line 352)
6	Twig\ExtensionSet->getGlobals (line 901)
7	Twig\Environment->getGlobals (line 384)
8	Twig\Template->yield (line 344)
9	Twig\Template->display (line 359)
10	Twig\Template->render (line 51)
11	Twig\TemplateWrapper->render (line 334)
12	Twig\Environment->render (line 431)
13	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 436)
14	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 250)
15	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 48)
16	App\Controller\PageController->show (line 183)
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 5)

0.27 ms
(6.03%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.logo AS logo_4, t0.footer AS footer_5, t0.seo_title AS seo_title_6, t0.seo_description AS seo_description_7, t0.seo_keywords AS seo_keywords_8, t0.seo_canonical AS seo_canonical_9, t0.updated_at AS updated_at_10, t0.stripe_secret_key AS stripe_secret_key_11, t0.stripe_publishable_key AS stripe_publishable_key_12, t0.fondy_merchant_id AS fondy_merchant_id_13, t0.fondy_secret_key AS fondy_secret_key_14 FROM site_configuration t0 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.description AS description_3,
  t0.logo AS logo_4,
  t0.footer AS footer_5,
  t0.seo_title AS seo_title_6,
  t0.seo_description AS seo_description_7,
  t0.seo_keywords AS seo_keywords_8,
  t0.seo_canonical AS seo_canonical_9,
  t0.updated_at AS updated_at_10,
  t0.stripe_secret_key AS stripe_secret_key_11,
  t0.stripe_publishable_key AS stripe_publishable_key_12,
  t0.fondy_merchant_id AS fondy_merchant_id_13,
  t0.fondy_secret_key AS fondy_secret_key_14
FROM
  site_configuration t0
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.logo AS logo_4, t0.footer AS footer_5, t0.seo_title AS seo_title_6, t0.seo_description AS seo_description_7, t0.seo_keywords AS seo_keywords_8, t0.seo_canonical AS seo_canonical_9, t0.updated_at AS updated_at_10, t0.stripe_secret_key AS stripe_secret_key_11, t0.stripe_publishable_key AS stripe_publishable_key_12, t0.fondy_merchant_id AS fondy_merchant_id_13, t0.fondy_secret_key AS fondy_secret_key_14 FROM site_configuration t0 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 18)
5	App\Service\SiteConfigurationService->getConfiguration (line 1882)
6	Twig\Extension\CoreExtension::getAttribute (line 55)
7	__TwigTemplate_7497b7d36d1f149a7fbd41acd51faa49->doDisplay (line 388)
8	Twig\Template->yield (line 55)
9	__TwigTemplate_bfccefe16e11dd0a658d85687773431b->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 48)
18	App\Controller\PageController->show (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 5)

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\SocialLink	4
App\Entity\Page	1
App\Entity\SiteConfiguration	1

Entities Mapping

Class	Mapping errors
App\Entity\Page	No errors.
App\Entity\SocialLink	No errors.
App\Entity\Model3D	No errors.
App\Entity\SiteConfiguration	No errors.

Symfony Profiler

GET https://3d-edem.com/page/how-it-works?q=page%2Fhow-it-works

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping