Symfony Profiler

Query Metrics

3 Database Queries

3 Different statements

2.00 ms Query time

0 Invalid entities

3 Managed entities

Queries

Group similar statements

#▲

Time

Info

0.49 ms

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.description AS description_4, t0.subdomain AS subdomain_5, t0.active AS active_6, t0.registration_enabled AS registration_enabled_7, t0.trial_expires_at AS trial_expires_at_8, t0.is_lifetime AS is_lifetime_9, t0.created_at AS created_at_10, t0.updated_at AS updated_at_11 FROM tenant t0 WHERE t0.active = ? ORDER BY t0.id ASC LIMIT 1

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.slug AS slug_3,
  t0.description AS description_4,
  t0.subdomain AS subdomain_5,
  t0.active AS active_6,
  t0.registration_enabled AS registration_enabled_7,
  t0.trial_expires_at AS trial_expires_at_8,
  t0.is_lifetime AS is_lifetime_9,
  t0.created_at AS created_at_10,
  t0.updated_at AS updated_at_11
FROM
  tenant t0
WHERE
  t0.active = ?
ORDER BY
  t0.id ASC
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.description AS description_4, t0.subdomain AS subdomain_5, t0.active AS active_6, t0.registration_enabled AS registration_enabled_7, t0.trial_expires_at AS trial_expires_at_8, t0.is_lifetime AS is_lifetime_9, t0.created_at AS created_at_10, t0.updated_at AS updated_at_11 FROM tenant t0 WHERE t0.active = 1 ORDER BY t0.id ASC LIMIT 1;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 963)
2	Doctrine\ORM\EntityRepository->findBy (line 110)
3	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findBy (line 73)
4	App\Twig\CmsExtension->resolveCurrentTenant (line 75)
5	App\Twig\CmsExtension->getAutoNavigation (line 98)
6	__TwigTemplate_71b6e2897c088b5fad257d2e4bb921dc->doDisplay (line 138)
7	Twig\Template->yield (line 402)
8	__TwigTemplate_8ecade684ffd932e7b8b845edb466b70->doDisplay (line 54)
9	Twig\Template->yield (line 402)
10	Twig\Template->display (line 358)
11	Twig\Template->render (line 373)
12	Twig\TemplateWrapper->render (line 51)
13	Twig\Environment->render (line 333)
14	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 459)
15	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 464)
16	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 278)
17	App\Controller\LoginController->index (line 25)
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	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
22	require_once (line 29)
23	require_once (line 5)

1.18 ms

SELECT c0_.id AS id_0, c0_.position AS position_1, c0_.title AS title_2, c0_.slug AS slug_3, c0_.full_path AS full_path_4, c0_.content AS content_5, c0_.css AS css_6, c0_.metadata AS metadata_7, c0_.is_published AS is_published_8, c0_.show_in_navigation AS show_in_navigation_9, c0_.nav_title AS nav_title_10, c0_.default_locale AS default_locale_11, c0_.created_at AS created_at_12, c0_.updated_at AS updated_at_13, c0_.tenant_id AS tenant_id_14, c0_.parent_id AS parent_id_15, c0_.template_id AS template_id_16 FROM cms_page c0_ WHERE c0_.tenant_id = ? AND c0_.is_published = 1 AND c0_.show_in_navigation = 1 AND c0_.parent_id IS NULL ORDER BY c0_.position ASC

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  c0_.id AS id_0,
  c0_.position AS position_1,
  c0_.title AS title_2,
  c0_.slug AS slug_3,
  c0_.full_path AS full_path_4,
  c0_.content AS content_5,
  c0_.css AS css_6,
  c0_.metadata AS metadata_7,
  c0_.is_published AS is_published_8,
  c0_.show_in_navigation AS show_in_navigation_9,
  c0_.nav_title AS nav_title_10,
  c0_.default_locale AS default_locale_11,
  c0_.created_at AS created_at_12,
  c0_.updated_at AS updated_at_13,
  c0_.tenant_id AS tenant_id_14,
  c0_.parent_id AS parent_id_15,
  c0_.template_id AS template_id_16
FROM
  cms_page c0_
WHERE
  c0_.tenant_id = ?
  AND c0_.is_published = 1
  AND c0_.show_in_navigation = 1
  AND c0_.parent_id IS NULL
ORDER BY
  c0_.position ASC

SELECT c0_.id AS id_0, c0_.position AS position_1, c0_.title AS title_2, c0_.slug AS slug_3, c0_.full_path AS full_path_4, c0_.content AS content_5, c0_.css AS css_6, c0_.metadata AS metadata_7, c0_.is_published AS is_published_8, c0_.show_in_navigation AS show_in_navigation_9, c0_.nav_title AS nav_title_10, c0_.default_locale AS default_locale_11, c0_.created_at AS created_at_12, c0_.updated_at AS updated_at_13, c0_.tenant_id AS tenant_id_14, c0_.parent_id AS parent_id_15, c0_.template_id AS template_id_16 FROM cms_page c0_ WHERE c0_.tenant_id = 1 AND c0_.is_published = 1 AND c0_.show_in_navigation = 1 AND c0_.parent_id IS NULL ORDER BY c0_.position 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\CmsPageRepository->findNavigationPages (line 96)
7	App\Twig\CmsExtension->getAutoNavigation (line 103)
8	__TwigTemplate_71b6e2897c088b5fad257d2e4bb921dc->doDisplay (line 138)
9	Twig\Template->yield (line 402)
10	__TwigTemplate_8ecade684ffd932e7b8b845edb466b70->doDisplay (line 54)
11	Twig\Template->yield (line 402)
12	Twig\Template->display (line 358)
13	Twig\Template->render (line 373)
14	Twig\TemplateWrapper->render (line 51)
15	Twig\Environment->render (line 333)
16	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 459)
17	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 464)
18	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 278)
19	App\Controller\LoginController->index (line 25)
20	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
21	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
22	Symfony\Component\HttpKernel\Kernel->handle (line 182)
23	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
24	require_once (line 29)
25	require_once (line 5)

0.33 ms

SELECT t0.id AS id_1, t0.position AS position_2, t0.title AS title_3, t0.slug AS slug_4, t0.full_path AS full_path_5, t0.content AS content_6, t0.css AS css_7, t0.metadata AS metadata_8, t0.is_published AS is_published_9, t0.show_in_navigation AS show_in_navigation_10, t0.nav_title AS nav_title_11, t0.default_locale AS default_locale_12, t0.created_at AS created_at_13, t0.updated_at AS updated_at_14, t0.tenant_id AS tenant_id_15, t0.parent_id AS parent_id_16, t0.template_id AS template_id_17 FROM cms_page t0 WHERE t0.parent_id = ? ORDER BY t0.position ASC

Parameters:

[
  4
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.position AS position_2,
  t0.title AS title_3,
  t0.slug AS slug_4,
  t0.full_path AS full_path_5,
  t0.content AS content_6,
  t0.css AS css_7,
  t0.metadata AS metadata_8,
  t0.is_published AS is_published_9,
  t0.show_in_navigation AS show_in_navigation_10,
  t0.nav_title AS nav_title_11,
  t0.default_locale AS default_locale_12,
  t0.created_at AS created_at_13,
  t0.updated_at AS updated_at_14,
  t0.tenant_id AS tenant_id_15,
  t0.parent_id AS parent_id_16,
  t0.template_id AS template_id_17
FROM
  cms_page t0
WHERE
  t0.parent_id = ?
ORDER BY
  t0.position ASC

SELECT t0.id AS id_1, t0.position AS position_2, t0.title AS title_3, t0.slug AS slug_4, t0.full_path AS full_path_5, t0.content AS content_6, t0.css AS css_7, t0.metadata AS metadata_8, t0.is_published AS is_published_9, t0.show_in_navigation AS show_in_navigation_10, t0.nav_title AS nav_title_11, t0.default_locale AS default_locale_12, t0.created_at AS created_at_13, t0.updated_at AS updated_at_14, t0.tenant_id AS tenant_id_15, t0.parent_id AS parent_id_16, t0.template_id AS template_id_17 FROM cms_page t0 WHERE t0.parent_id = 4 ORDER BY t0.position ASC;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getOneToManyStatement (line 1867)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToManyCollection (line 1812)
3	Doctrine\ORM\UnitOfWork->loadCollection (line 2722)
4	Doctrine\ORM\PersistentCollection->doInitialize (line 636)
5	Doctrine\ORM\PersistentCollection->initialize (line 186)
6	Doctrine\Common\Collections\AbstractLazyCollection->filter (line 237)
7	App\Entity\CmsPage->getNavigationChildren (line 535)
8	Twig\Extension\CoreExtension->getAttribute (line 1909)
9	__TwigTemplate_71b6e2897c088b5fad257d2e4bb921dc::doDisplay (line 146)
10	Twig\Template->yield (line 402)
11	__TwigTemplate_8ecade684ffd932e7b8b845edb466b70->doDisplay (line 54)
12	Twig\Template->yield (line 402)
13	Twig\Template->display (line 358)
14	Twig\Template->render (line 373)
15	Twig\TemplateWrapper->render (line 51)
16	Twig\Environment->render (line 333)
17	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 459)
18	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 464)
19	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 278)
20	App\Controller\LoginController->index (line 25)
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	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
25	require_once (line 29)
26	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\Tenant	1
App\Entity\CmsPage	1
App\Entity\CmsTemplate	1

Entities Mapping

Class	Mapping errors
App\Entity\Tenant	No errors.
App\Entity\User	No errors.
App\Entity\Subscription	No errors.
App\Entity\CmsPage	No errors.
App\Entity\CmsTemplate	No errors.
App\Entity\CmsPageTranslation	No errors.

Symfony Profiler

GET https://doksimple.ai/login

Configuration Settings

Theme

Page Width

Query Metrics

Queries

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping