Symfony Profiler

Query Metrics

43 Database Queries

13 Different statements

35.78 ms Query time

0 Invalid entities

37 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

14.95 ms
(41.79%)

SELECT t0.id AS id_1, t0.translation_key AS translation_key_2, t0.value AS value_3, t0.language_id AS language_id_4 FROM language_translation t0 WHERE t0.language_id = ? AND t0.translation_key = ? LIMIT 1

Parameters:

[
  2
  "site_auth.account"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.translation_key AS translation_key_2,
  t0.value AS value_3,
  t0.language_id AS language_id_4
FROM
  language_translation t0
WHERE
  t0.language_id = ?
  AND t0.translation_key = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.translation_key AS translation_key_2, t0.value AS value_3, t0.language_id AS language_id_4 FROM language_translation t0 WHERE t0.language_id = 2 AND t0.translation_key = 'site_auth.account' LIMIT 1;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 738)
2	Doctrine\ORM\EntityRepository->findOneBy (line 125)
3	App\Language\Application\SystemTranslator->translate (line 39)
4	App\Language\Presentation\Twig\LanguageExtension->translate (line 20)
5	__TwigTemplate_823ac9abd3b328f6880537474fb7f538->doDisplay (line 50)
6	Twig\Template->yield (line 411)
7	Twig\Template->display (line 366)
8	Twig\Template->render (line 381)
9	Twig\TemplateWrapper->render (line 51)
10	Twig\Environment->render (line 333)
11	App\Cms\Application\SystemPageRenderer->render (line 51)
12	App\Identity\Presentation\Http\SiteRegistrationController->resend (line 119)
13	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
14	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
15	Symfony\Component\HttpKernel\Kernel->handle (line 193)
16	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 34)
17	require_once (line 32)
18	require_once (line 5)

4.81 ms
(13.44%)

SELECT t0.code AS code_1, t0.version AS version_2, t0.enabled AS enabled_3, t0.installed_at AS installed_at_4, t0.updated_at AS updated_at_5 FROM installed_module t0 WHERE t0.code = ?

Parameters:

[
  "settings"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.code AS code_1,
  t0.version AS version_2,
  t0.enabled AS enabled_3,
  t0.installed_at AS installed_at_4,
  t0.updated_at AS updated_at_5
FROM
  installed_module t0
WHERE
  t0.code = ?

SELECT t0.code AS code_1, t0.version AS version_2, t0.enabled AS enabled_3, t0.installed_at AS installed_at_4, t0.updated_at AS updated_at_5 FROM installed_module t0 WHERE t0.code = 'settings';

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 738)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 756)
3	Doctrine\ORM\EntityManager->find (line 366)
4	Doctrine\ORM\EntityRepository->find (line 86)
5	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->find (line 61)
6	App\Module\Application\ModuleRuntime->isEnabledWithDependencies (line 26)
7	App\Module\Application\ModuleRuntime->isEnabled (line 16)
8	App\Settings\Presentation\Http\MaintenanceSubscriber->__invoke (line 25)
9	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
10	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
11	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
12	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 129)
13	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 159)
14	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
15	Symfony\Component\HttpKernel\Kernel->handle (line 193)
16	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 34)
17	require_once (line 32)
18	require_once (line 5)

4.32 ms
(12.07%)

SELECT TABLE_NAME
FROM information_schema.TABLES
WHERE TABLE_SCHEMA = ?
  AND TABLE_TYPE = 'BASE TABLE'
ORDER BY TABLE_NAME

Parameters:

[
  "shopro4_dev"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  TABLE_NAME
FROM
  information_schema.TABLES
WHERE
  TABLE_SCHEMA = ?
  AND TABLE_TYPE = 'BASE TABLE'
ORDER BY
  TABLE_NAME

SELECT TABLE_NAME
FROM information_schema.TABLES
WHERE TABLE_SCHEMA = 'shopro4_dev'
  AND TABLE_TYPE = 'BASE TABLE'
ORDER BY TABLE_NAME;

#	File/Call
1	Doctrine\DBAL\Schema\MySQLSchemaManager->selectTableNames (line 360)
2	Doctrine\DBAL\Schema\AbstractSchemaManager->listTableNames (line 207)
3	Doctrine\DBAL\Schema\AbstractSchemaManager->tablesExist (line 184)
4	App\Settings\Infrastructure\Persistence\Doctrine\SystemSettingsRepository->isStorageAvailable (line 26)
5	App\Settings\Infrastructure\Persistence\Doctrine\SystemSettingsRepository->get (line 17)
6	App\Settings\Application\SettingsProvider->all (line 19)
7	App\Settings\Application\SettingsProvider->get (line 24)
8	App\Settings\Presentation\Http\MaintenanceSubscriber->__invoke (line 25)
9	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
10	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
11	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
12	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 129)
13	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 159)
14	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
15	Symfony\Component\HttpKernel\Kernel->handle (line 193)
16	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 34)
17	require_once (line 32)
18	require_once (line 5)

2.21 ms
(6.19%)

SELECT c0_.id AS id_0, c0_.title AS title_1, c0_.slug AS slug_2, c0_.caption AS caption_3, c0_.seo_title AS seo_title_4, c0_.description AS description_5, c0_.content AS content_6, c0_.builder_data AS builder_data_7, c0_.builder_css AS builder_css_8, c0_.canonical AS canonical_9, c0_.published AS published_10, c0_.page_id AS page_id_11, c0_.language_id AS language_id_12 FROM cms_page_translation c0_ INNER JOIN language l1_ ON c0_.language_id = l1_.id WHERE c0_.page_id = ? AND c0_.published = 1 AND l1_.active = 1 AND l1_.default_language = 0 ORDER BY l1_.name ASC

Parameters:

[
  7
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  c0_.id AS id_0,
  c0_.title AS title_1,
  c0_.slug AS slug_2,
  c0_.caption AS caption_3,
  c0_.seo_title AS seo_title_4,
  c0_.description AS description_5,
  c0_.content AS content_6,
  c0_.builder_data AS builder_data_7,
  c0_.builder_css AS builder_css_8,
  c0_.canonical AS canonical_9,
  c0_.published AS published_10,
  c0_.page_id AS page_id_11,
  c0_.language_id AS language_id_12
FROM
  cms_page_translation c0_
  INNER JOIN language l1_ ON c0_.language_id = l1_.id
WHERE
  c0_.page_id = ?
  AND c0_.published = 1
  AND l1_.active = 1
  AND l1_.default_language = 0
ORDER BY
  l1_.name ASC

SELECT c0_.id AS id_0, c0_.title AS title_1, c0_.slug AS slug_2, c0_.caption AS caption_3, c0_.seo_title AS seo_title_4, c0_.description AS description_5, c0_.content AS content_6, c0_.builder_data AS builder_data_7, c0_.builder_css AS builder_css_8, c0_.canonical AS canonical_9, c0_.published AS published_10, c0_.page_id AS page_id_11, c0_.language_id AS language_id_12 FROM cms_page_translation c0_ INNER JOIN language l1_ ON c0_.language_id = l1_.id WHERE c0_.page_id = 7 AND c0_.published = 1 AND l1_.active = 1 AND l1_.default_language = 0 ORDER BY l1_.name 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\Cms\Infrastructure\Persistence\Doctrine\PageRepository->findPublishedActiveTranslations (line 144)
7	App\Cms\Application\SystemPageRenderer->render (line 50)
8	App\Identity\Presentation\Http\SiteRegistrationController->resend (line 119)
9	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
10	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
11	Symfony\Component\HttpKernel\Kernel->handle (line 193)
12	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 34)
13	require_once (line 32)
14	require_once (line 5)

1.69 ms
(4.71%)

SELECT t0.id AS id_1, t0.title AS title_2, t0.slug AS slug_3, t0.content AS content_4, t0.editor_mode AS editor_mode_5, t0.builder_data AS builder_data_6, t0.builder_css AS builder_css_7, t0.published AS published_8, t0.publish_at AS publish_at_9, t0.unpublish_at AS unpublish_at_10, t0.caption AS caption_11, t0.seo_title AS seo_title_12, t0.description AS description_13, t0.keywords AS keywords_14, t0.meta AS meta_15, t0.javascript AS javascript_16, t0.canonical AS canonical_17, t0.access AS access_18, t0.follow AS follow_19, t0.home_page AS home_page_20, t0.error_page AS error_page_21, t0.admin_only AS admin_only_22, t0.login_page AS login_page_23, t0.activation_page AS activation_page_24, t0.account_page AS account_page_25, t0.registration_page AS registration_page_26, t0.search_page AS search_page_27, t0.sitemap_page AS sitemap_page_28, t0.profile_page AS profile_page_29, t0.terms_page AS terms_page_30, t0.created_at AS created_at_31, t0.updated_at AS updated_at_32, t0.deleted_at AS deleted_at_33, t0.lock_version AS lock_version_34 FROM cms_page t0 WHERE t0.activation_page = ? AND t0.deleted_at IS NULL LIMIT 1

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.slug AS slug_3,
  t0.content AS content_4,
  t0.editor_mode AS editor_mode_5,
  t0.builder_data AS builder_data_6,
  t0.builder_css AS builder_css_7,
  t0.published AS published_8,
  t0.publish_at AS publish_at_9,
  t0.unpublish_at AS unpublish_at_10,
  t0.caption AS caption_11,
  t0.seo_title AS seo_title_12,
  t0.description AS description_13,
  t0.keywords AS keywords_14,
  t0.meta AS meta_15,
  t0.javascript AS javascript_16,
  t0.canonical AS canonical_17,
  t0.access AS access_18,
  t0.follow AS follow_19,
  t0.home_page AS home_page_20,
  t0.error_page AS error_page_21,
  t0.admin_only AS admin_only_22,
  t0.login_page AS login_page_23,
  t0.activation_page AS activation_page_24,
  t0.account_page AS account_page_25,
  t0.registration_page AS registration_page_26,
  t0.search_page AS search_page_27,
  t0.sitemap_page AS sitemap_page_28,
  t0.profile_page AS profile_page_29,
  t0.terms_page AS terms_page_30,
  t0.created_at AS created_at_31,
  t0.updated_at AS updated_at_32,
  t0.deleted_at AS deleted_at_33,
  t0.lock_version AS lock_version_34
FROM
  cms_page t0
WHERE
  t0.activation_page = ?
  AND t0.deleted_at IS NULL
LIMIT
  1

SELECT t0.id AS id_1, t0.title AS title_2, t0.slug AS slug_3, t0.content AS content_4, t0.editor_mode AS editor_mode_5, t0.builder_data AS builder_data_6, t0.builder_css AS builder_css_7, t0.published AS published_8, t0.publish_at AS publish_at_9, t0.unpublish_at AS unpublish_at_10, t0.caption AS caption_11, t0.seo_title AS seo_title_12, t0.description AS description_13, t0.keywords AS keywords_14, t0.meta AS meta_15, t0.javascript AS javascript_16, t0.canonical AS canonical_17, t0.access AS access_18, t0.follow AS follow_19, t0.home_page AS home_page_20, t0.error_page AS error_page_21, t0.admin_only AS admin_only_22, t0.login_page AS login_page_23, t0.activation_page AS activation_page_24, t0.account_page AS account_page_25, t0.registration_page AS registration_page_26, t0.search_page AS search_page_27, t0.sitemap_page AS sitemap_page_28, t0.profile_page AS profile_page_29, t0.terms_page AS terms_page_30, t0.created_at AS created_at_31, t0.updated_at AS updated_at_32, t0.deleted_at AS deleted_at_33, t0.lock_version AS lock_version_34 FROM cms_page t0 WHERE t0.activation_page = 1 AND t0.deleted_at IS NULL LIMIT 1;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 738)
2	Doctrine\ORM\EntityRepository->findOneBy (line 125)
3	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findOneBy (line 81)
4	App\Cms\Application\SystemPageRenderer->render (line 37)
5	App\Identity\Presentation\Http\SiteRegistrationController->resend (line 119)
6	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
7	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
8	Symfony\Component\HttpKernel\Kernel->handle (line 193)
9	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 34)
10	require_once (line 32)
11	require_once (line 5)

1.55 ms
(4.33%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.code AS code_3, t0.direction AS direction_4, t0.author AS author_5, t0.subdomain AS subdomain_6, t0.active AS active_7, t0.default_language AS default_language_8, t0.locale AS locale_9, t0.currency AS currency_10, t0.currency_symbol AS currency_symbol_11, t0.decimal_separator AS decimal_separator_12, t0.thousands_separator AS thousands_separator_13 FROM language t0 WHERE t0.code = ? AND t0.active = ? LIMIT 1

Parameters:

[
  "en"
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.code AS code_3,
  t0.direction AS direction_4,
  t0.author AS author_5,
  t0.subdomain AS subdomain_6,
  t0.active AS active_7,
  t0.default_language AS default_language_8,
  t0.locale AS locale_9,
  t0.currency AS currency_10,
  t0.currency_symbol AS currency_symbol_11,
  t0.decimal_separator AS decimal_separator_12,
  t0.thousands_separator AS thousands_separator_13
FROM
  language t0
WHERE
  t0.code = ?
  AND t0.active = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.code AS code_3, t0.direction AS direction_4, t0.author AS author_5, t0.subdomain AS subdomain_6, t0.active AS active_7, t0.default_language AS default_language_8, t0.locale AS locale_9, t0.currency AS currency_10, t0.currency_symbol AS currency_symbol_11, t0.decimal_separator AS decimal_separator_12, t0.thousands_separator AS thousands_separator_13 FROM language t0 WHERE t0.code = 'en' AND t0.active = 1 LIMIT 1;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 738)
2	Doctrine\ORM\EntityRepository->findOneBy (line 125)
3	App\Cms\Presentation\Http\SystemPageSlugSubscriber->pageFromPath (line 127)
4	App\Cms\Presentation\Http\SystemPageSlugSubscriber->routeEditableSlug (line 66)
5	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
6	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
7	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
8	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 129)
9	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 159)
10	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
11	Symfony\Component\HttpKernel\Kernel->handle (line 193)
12	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 34)
13	require_once (line 32)
14	require_once (line 5)

1.40 ms
(3.92%)

SELECT t0.id AS id_1, t0.title AS title_2, t0.slug AS slug_3, t0.caption AS caption_4, t0.seo_title AS seo_title_5, t0.description AS description_6, t0.content AS content_7, t0.builder_data AS builder_data_8, t0.builder_css AS builder_css_9, t0.canonical AS canonical_10, t0.published AS published_11, t0.page_id AS page_id_12, t0.language_id AS language_id_13 FROM cms_page_translation t0 WHERE t0.language_id = ? AND t0.slug = ? AND t0.published = ? LIMIT 1

Parameters:

[
  2
  "account-activation"
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.slug AS slug_3,
  t0.caption AS caption_4,
  t0.seo_title AS seo_title_5,
  t0.description AS description_6,
  t0.content AS content_7,
  t0.builder_data AS builder_data_8,
  t0.builder_css AS builder_css_9,
  t0.canonical AS canonical_10,
  t0.published AS published_11,
  t0.page_id AS page_id_12,
  t0.language_id AS language_id_13
FROM
  cms_page_translation t0
WHERE
  t0.language_id = ?
  AND t0.slug = ?
  AND t0.published = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.title AS title_2, t0.slug AS slug_3, t0.caption AS caption_4, t0.seo_title AS seo_title_5, t0.description AS description_6, t0.content AS content_7, t0.builder_data AS builder_data_8, t0.builder_css AS builder_css_9, t0.canonical AS canonical_10, t0.published AS published_11, t0.page_id AS page_id_12, t0.language_id AS language_id_13 FROM cms_page_translation t0 WHERE t0.language_id = 2 AND t0.slug = 'account-activation' AND t0.published = 1 LIMIT 1;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 738)
2	Doctrine\ORM\EntityRepository->findOneBy (line 125)
3	App\Cms\Presentation\Http\SystemPageSlugSubscriber->pageFromPath (line 133)
4	App\Cms\Presentation\Http\SystemPageSlugSubscriber->routeEditableSlug (line 66)
5	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
6	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
7	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
8	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 129)
9	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 159)
10	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
11	Symfony\Component\HttpKernel\Kernel->handle (line 193)
12	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 34)
13	require_once (line 32)
14	require_once (line 5)

1.34 ms
(3.73%)

SELECT t0.id AS id_1, t0.title AS title_2, t0.slug AS slug_3, t0.caption AS caption_4, t0.seo_title AS seo_title_5, t0.description AS description_6, t0.content AS content_7, t0.builder_data AS builder_data_8, t0.builder_css AS builder_css_9, t0.canonical AS canonical_10, t0.published AS published_11, t0.page_id AS page_id_12, t0.language_id AS language_id_13 FROM cms_page_translation t0 WHERE t0.page_id = ? AND t0.language_id = ? AND t0.published = ? LIMIT 1

Parameters:

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.slug AS slug_3,
  t0.caption AS caption_4,
  t0.seo_title AS seo_title_5,
  t0.description AS description_6,
  t0.content AS content_7,
  t0.builder_data AS builder_data_8,
  t0.builder_css AS builder_css_9,
  t0.canonical AS canonical_10,
  t0.published AS published_11,
  t0.page_id AS page_id_12,
  t0.language_id AS language_id_13
FROM
  cms_page_translation t0
WHERE
  t0.page_id = ?
  AND t0.language_id = ?
  AND t0.published = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.title AS title_2, t0.slug AS slug_3, t0.caption AS caption_4, t0.seo_title AS seo_title_5, t0.description AS description_6, t0.content AS content_7, t0.builder_data AS builder_data_8, t0.builder_css AS builder_css_9, t0.canonical AS canonical_10, t0.published AS published_11, t0.page_id AS page_id_12, t0.language_id AS language_id_13 FROM cms_page_translation t0 WHERE t0.page_id = 7 AND t0.language_id = 2 AND t0.published = 1 LIMIT 1;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 738)
2	Doctrine\ORM\EntityRepository->findOneBy (line 125)
3	App\Cms\Application\SystemPageRenderer->translatedPage (line 64)
4	App\Cms\Application\SystemPageRenderer->render (line 42)
5	App\Identity\Presentation\Http\SiteRegistrationController->resend (line 119)
6	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
7	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
8	Symfony\Component\HttpKernel\Kernel->handle (line 193)
9	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 34)
10	require_once (line 32)
11	require_once (line 5)

1.17 ms
(3.27%)

SELECT t0.id AS id_1, t0.title AS title_2, t0.slug AS slug_3, t0.content AS content_4, t0.editor_mode AS editor_mode_5, t0.builder_data AS builder_data_6, t0.builder_css AS builder_css_7, t0.published AS published_8, t0.publish_at AS publish_at_9, t0.unpublish_at AS unpublish_at_10, t0.caption AS caption_11, t0.seo_title AS seo_title_12, t0.description AS description_13, t0.keywords AS keywords_14, t0.meta AS meta_15, t0.javascript AS javascript_16, t0.canonical AS canonical_17, t0.access AS access_18, t0.follow AS follow_19, t0.home_page AS home_page_20, t0.error_page AS error_page_21, t0.admin_only AS admin_only_22, t0.login_page AS login_page_23, t0.activation_page AS activation_page_24, t0.account_page AS account_page_25, t0.registration_page AS registration_page_26, t0.search_page AS search_page_27, t0.sitemap_page AS sitemap_page_28, t0.profile_page AS profile_page_29, t0.terms_page AS terms_page_30, t0.created_at AS created_at_31, t0.updated_at AS updated_at_32, t0.deleted_at AS deleted_at_33, t0.lock_version AS lock_version_34 FROM cms_page t0 WHERE t0.id = ?

Parameters:

[
  7
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.slug AS slug_3,
  t0.content AS content_4,
  t0.editor_mode AS editor_mode_5,
  t0.builder_data AS builder_data_6,
  t0.builder_css AS builder_css_7,
  t0.published AS published_8,
  t0.publish_at AS publish_at_9,
  t0.unpublish_at AS unpublish_at_10,
  t0.caption AS caption_11,
  t0.seo_title AS seo_title_12,
  t0.description AS description_13,
  t0.keywords AS keywords_14,
  t0.meta AS meta_15,
  t0.javascript AS javascript_16,
  t0.canonical AS canonical_17,
  t0.access AS access_18,
  t0.follow AS follow_19,
  t0.home_page AS home_page_20,
  t0.error_page AS error_page_21,
  t0.admin_only AS admin_only_22,
  t0.login_page AS login_page_23,
  t0.activation_page AS activation_page_24,
  t0.account_page AS account_page_25,
  t0.registration_page AS registration_page_26,
  t0.search_page AS search_page_27,
  t0.sitemap_page AS sitemap_page_28,
  t0.profile_page AS profile_page_29,
  t0.terms_page AS terms_page_30,
  t0.created_at AS created_at_31,
  t0.updated_at AS updated_at_32,
  t0.deleted_at AS deleted_at_33,
  t0.lock_version AS lock_version_34
FROM
  cms_page t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.title AS title_2, t0.slug AS slug_3, t0.content AS content_4, t0.editor_mode AS editor_mode_5, t0.builder_data AS builder_data_6, t0.builder_css AS builder_css_7, t0.published AS published_8, t0.publish_at AS publish_at_9, t0.unpublish_at AS unpublish_at_10, t0.caption AS caption_11, t0.seo_title AS seo_title_12, t0.description AS description_13, t0.keywords AS keywords_14, t0.meta AS meta_15, t0.javascript AS javascript_16, t0.canonical AS canonical_17, t0.access AS access_18, t0.follow AS follow_19, t0.home_page AS home_page_20, t0.error_page AS error_page_21, t0.admin_only AS admin_only_22, t0.login_page AS login_page_23, t0.activation_page AS activation_page_24, t0.account_page AS account_page_25, t0.registration_page AS registration_page_26, t0.search_page AS search_page_27, t0.sitemap_page AS sitemap_page_28, t0.profile_page AS profile_page_29, t0.terms_page AS terms_page_30, t0.created_at AS created_at_31, t0.updated_at AS updated_at_32, t0.deleted_at AS deleted_at_33, t0.lock_version AS lock_version_34 FROM cms_page t0 WHERE t0.id = 7;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 738)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 756)
3	Doctrine\ORM\Proxy\ProxyFactory->Doctrine\ORM\Proxy\{closure} (line 295)
4	Proxies\__CG__\App\Cms\Domain\Entity\Page::Doctrine\ORM\Proxy\{closure} (line 373)
5	Symfony\Component\VarExporter\Internal\LazyObjectState::initialize (line 60)
6	Proxies\__CG__\App\Cms\Domain\Entity\Page->__get (line 153)
7	App\Cms\Domain\Entity\Page->isPubliclyAvailable (line 198)
8	App\Cms\Presentation\Http\SystemPageSlugSubscriber->pageFromPath (line 138)
9	App\Cms\Presentation\Http\SystemPageSlugSubscriber->routeEditableSlug (line 66)
10	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
11	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
12	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
13	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 129)
14	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 159)
15	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
16	Symfony\Component\HttpKernel\Kernel->handle (line 193)
17	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 34)
18	require_once (line 32)
19	require_once (line 5)

0.75 ms
(2.10%)

SELECT t0.id AS id_1, t0.title AS title_2, t0.slug AS slug_3, t0.content AS content_4, t0.editor_mode AS editor_mode_5, t0.builder_data AS builder_data_6, t0.builder_css AS builder_css_7, t0.published AS published_8, t0.publish_at AS publish_at_9, t0.unpublish_at AS unpublish_at_10, t0.caption AS caption_11, t0.seo_title AS seo_title_12, t0.description AS description_13, t0.keywords AS keywords_14, t0.meta AS meta_15, t0.javascript AS javascript_16, t0.canonical AS canonical_17, t0.access AS access_18, t0.follow AS follow_19, t0.home_page AS home_page_20, t0.error_page AS error_page_21, t0.admin_only AS admin_only_22, t0.login_page AS login_page_23, t0.activation_page AS activation_page_24, t0.account_page AS account_page_25, t0.registration_page AS registration_page_26, t0.search_page AS search_page_27, t0.sitemap_page AS sitemap_page_28, t0.profile_page AS profile_page_29, t0.terms_page AS terms_page_30, t0.created_at AS created_at_31, t0.updated_at AS updated_at_32, t0.deleted_at AS deleted_at_33, t0.lock_version AS lock_version_34 FROM cms_page t0 WHERE t0.login_page = ? AND t0.deleted_at IS NULL LIMIT 1

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.slug AS slug_3,
  t0.content AS content_4,
  t0.editor_mode AS editor_mode_5,
  t0.builder_data AS builder_data_6,
  t0.builder_css AS builder_css_7,
  t0.published AS published_8,
  t0.publish_at AS publish_at_9,
  t0.unpublish_at AS unpublish_at_10,
  t0.caption AS caption_11,
  t0.seo_title AS seo_title_12,
  t0.description AS description_13,
  t0.keywords AS keywords_14,
  t0.meta AS meta_15,
  t0.javascript AS javascript_16,
  t0.canonical AS canonical_17,
  t0.access AS access_18,
  t0.follow AS follow_19,
  t0.home_page AS home_page_20,
  t0.error_page AS error_page_21,
  t0.admin_only AS admin_only_22,
  t0.login_page AS login_page_23,
  t0.activation_page AS activation_page_24,
  t0.account_page AS account_page_25,
  t0.registration_page AS registration_page_26,
  t0.search_page AS search_page_27,
  t0.sitemap_page AS sitemap_page_28,
  t0.profile_page AS profile_page_29,
  t0.terms_page AS terms_page_30,
  t0.created_at AS created_at_31,
  t0.updated_at AS updated_at_32,
  t0.deleted_at AS deleted_at_33,
  t0.lock_version AS lock_version_34
FROM
  cms_page t0
WHERE
  t0.login_page = ?
  AND t0.deleted_at IS NULL
LIMIT
  1

SELECT t0.id AS id_1, t0.title AS title_2, t0.slug AS slug_3, t0.content AS content_4, t0.editor_mode AS editor_mode_5, t0.builder_data AS builder_data_6, t0.builder_css AS builder_css_7, t0.published AS published_8, t0.publish_at AS publish_at_9, t0.unpublish_at AS unpublish_at_10, t0.caption AS caption_11, t0.seo_title AS seo_title_12, t0.description AS description_13, t0.keywords AS keywords_14, t0.meta AS meta_15, t0.javascript AS javascript_16, t0.canonical AS canonical_17, t0.access AS access_18, t0.follow AS follow_19, t0.home_page AS home_page_20, t0.error_page AS error_page_21, t0.admin_only AS admin_only_22, t0.login_page AS login_page_23, t0.activation_page AS activation_page_24, t0.account_page AS account_page_25, t0.registration_page AS registration_page_26, t0.search_page AS search_page_27, t0.sitemap_page AS sitemap_page_28, t0.profile_page AS profile_page_29, t0.terms_page AS terms_page_30, t0.created_at AS created_at_31, t0.updated_at AS updated_at_32, t0.deleted_at AS deleted_at_33, t0.lock_version AS lock_version_34 FROM cms_page t0 WHERE t0.login_page = 1 AND t0.deleted_at IS NULL LIMIT 1;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 738)
2	Doctrine\ORM\EntityRepository->findOneBy (line 125)
3	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findOneBy (line 81)
4	App\Cms\Presentation\Twig\SystemPageExtension->url (line 48)
5	__TwigTemplate_823ac9abd3b328f6880537474fb7f538->doDisplay (line 70)
6	Twig\Template->yield (line 411)
7	Twig\Template->display (line 366)
8	Twig\Template->render (line 381)
9	Twig\TemplateWrapper->render (line 51)
10	Twig\Environment->render (line 333)
11	App\Cms\Application\SystemPageRenderer->render (line 51)
12	App\Identity\Presentation\Http\SiteRegistrationController->resend (line 119)
13	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
14	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
15	Symfony\Component\HttpKernel\Kernel->handle (line 193)
16	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 34)
17	require_once (line 32)
18	require_once (line 5)

0.72 ms
(2.01%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.code AS code_3, t0.direction AS direction_4, t0.author AS author_5, t0.subdomain AS subdomain_6, t0.active AS active_7, t0.default_language AS default_language_8, t0.locale AS locale_9, t0.currency AS currency_10, t0.currency_symbol AS currency_symbol_11, t0.decimal_separator AS decimal_separator_12, t0.thousands_separator AS thousands_separator_13 FROM language t0 WHERE t0.default_language = ? 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.code AS code_3,
  t0.direction AS direction_4,
  t0.author AS author_5,
  t0.subdomain AS subdomain_6,
  t0.active AS active_7,
  t0.default_language AS default_language_8,
  t0.locale AS locale_9,
  t0.currency AS currency_10,
  t0.currency_symbol AS currency_symbol_11,
  t0.decimal_separator AS decimal_separator_12,
  t0.thousands_separator AS thousands_separator_13
FROM
  language t0
WHERE
  t0.default_language = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.code AS code_3, t0.direction AS direction_4, t0.author AS author_5, t0.subdomain AS subdomain_6, t0.active AS active_7, t0.default_language AS default_language_8, t0.locale AS locale_9, t0.currency AS currency_10, t0.currency_symbol AS currency_symbol_11, t0.decimal_separator AS decimal_separator_12, t0.thousands_separator AS thousands_separator_13 FROM language t0 WHERE t0.default_language = 1 LIMIT 1;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 738)
2	Doctrine\ORM\EntityRepository->findOneBy (line 125)
3	App\Language\Presentation\Twig\LanguageExtension->defaultLanguage (line 19)
4	__TwigTemplate_a128d7387e2716c144a0481d49273f3b->block_meta (line 213)
5	Twig\Template->yieldBlock (line 458)
6	__TwigTemplate_f67a99fcfdb6a3c06f7b97aa3f8b96b6->doDisplay (line 70)
7	Twig\Template->yield (line 411)
8	__TwigTemplate_69cef74e4ffe200fcc75e8fd4ed27a8d->doDisplay (line 60)
9	Twig\Template->yield (line 411)
10	__TwigTemplate_50a8cf494acfca27134f95d826d4ef8b->doDisplay (line 56)
11	Twig\Template->yield (line 411)
12	__TwigTemplate_783bac79ace73c42027a5c5c0db06b34->doDisplay (line 53)
13	Twig\Template->yield (line 411)
14	__TwigTemplate_a128d7387e2716c144a0481d49273f3b->doDisplay (line 59)
15	Twig\Template->yield (line 411)
16	Twig\Template->display (line 366)
17	Twig\Template->render (line 381)
18	Twig\TemplateWrapper->render (line 51)
19	Twig\Environment->render (line 333)
20	App\Cms\Application\SystemPageRenderer->render (line 47)
21	App\Identity\Presentation\Http\SiteRegistrationController->resend (line 119)
22	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
23	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
24	Symfony\Component\HttpKernel\Kernel->handle (line 193)
25	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 34)
26	require_once (line 32)
27	require_once (line 5)

0.49 ms
(1.38%)

SELECT t0.id AS id_1, t0.configuration AS configuration_2, t0.smtp_password AS smtp_password_3, t0.updated_at AS updated_at_4 FROM system_settings t0 WHERE t0.id = ?

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.configuration AS configuration_2,
  t0.smtp_password AS smtp_password_3,
  t0.updated_at AS updated_at_4
FROM
  system_settings t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.configuration AS configuration_2, t0.smtp_password AS smtp_password_3, t0.updated_at AS updated_at_4 FROM system_settings t0 WHERE t0.id = 1;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 738)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 756)
3	Doctrine\ORM\EntityManager->find (line 366)
4	Doctrine\ORM\EntityRepository->find (line 86)
5	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->find (line 61)
6	App\Settings\Infrastructure\Persistence\Doctrine\SystemSettingsRepository->get (line 21)
7	App\Settings\Application\SettingsProvider->all (line 19)
8	App\Settings\Application\SettingsProvider->get (line 24)
9	App\Settings\Presentation\Http\MaintenanceSubscriber->__invoke (line 25)
10	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
11	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
12	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
13	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 129)
14	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 159)
15	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
16	Symfony\Component\HttpKernel\Kernel->handle (line 193)
17	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 34)
18	require_once (line 32)
19	require_once (line 5)

0.38 ms
(1.07%)

SELECT DATABASE()

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  DATABASE()

SELECT DATABASE();

#	File/Call
1	Doctrine\DBAL\Connection->fetchOne (line 332)
2	Doctrine\DBAL\Connection->getDatabase (line 161)
3	Doctrine\DBAL\Schema\AbstractSchemaManager->getDatabase (line 1458)
4	Doctrine\DBAL\Schema\AbstractSchemaManager->listTableNames (line 208)
5	Doctrine\DBAL\Schema\AbstractSchemaManager->tablesExist (line 184)
6	App\Settings\Infrastructure\Persistence\Doctrine\SystemSettingsRepository->isStorageAvailable (line 26)
7	App\Settings\Infrastructure\Persistence\Doctrine\SystemSettingsRepository->get (line 17)
8	App\Settings\Application\SettingsProvider->all (line 19)
9	App\Settings\Application\SettingsProvider->get (line 24)
10	App\Settings\Presentation\Http\MaintenanceSubscriber->__invoke (line 25)
11	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
12	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
13	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
14	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 129)
15	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 159)
16	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
17	Symfony\Component\HttpKernel\Kernel->handle (line 193)
18	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 34)
19	require_once (line 32)
20	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\Language\Domain\Entity\Translation	23
App\Module\Domain\Entity\InstalledModule	7
App\Language\Domain\Entity\Language	2
App\Cms\Domain\Entity\PageTranslation	2
App\Cms\Domain\Entity\Page	2
App\Settings\Domain\Entity\SystemSettings	1

Entities Mapping

Class	Mapping errors
App\Language\Domain\Entity\Language	No errors.
App\Cms\Domain\Entity\PageTranslation	No errors.
App\Cms\Domain\Entity\Page	No errors.
App\Identity\Domain\Entity\Membership	No errors.
App\Module\Domain\Entity\InstalledModule	No errors.
App\Settings\Domain\Entity\SystemSettings	No errors.
App\Language\Domain\Entity\Translation	No errors.

Symfony Profiler

GET https://shopro4.orangestudio.pl/en/account-activation

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping