Symfony Profiler

Query Metrics

35 Database Queries

7 Different statements

32.43 ms Query time

0 Invalid entities

33 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

14.71 ms
(45.35%)

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:

[
  1
  "front.home"
]

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 = 1 AND t0.translation_key = 'front.home' 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_8feb1d99349b588a2a10b58e78733119->doDisplay (line 137)
6	Twig\Template->yield (line 411)
7	__TwigTemplate_f67a99fcfdb6a3c06f7b97aa3f8b96b6->block_structured_data (line 242)
8	Twig\Template->yieldBlock (line 458)
9	__TwigTemplate_f67a99fcfdb6a3c06f7b97aa3f8b96b6->doDisplay (line 73)
10	Twig\Template->yield (line 411)
11	__TwigTemplate_69cef74e4ffe200fcc75e8fd4ed27a8d->doDisplay (line 60)
12	Twig\Template->yield (line 411)
13	__TwigTemplate_50a8cf494acfca27134f95d826d4ef8b->doDisplay (line 56)
14	Twig\Template->yield (line 411)
15	__TwigTemplate_783bac79ace73c42027a5c5c0db06b34->doDisplay (line 53)
16	Twig\Template->yield (line 411)
17	__TwigTemplate_ddb3ca65fa5f85f3141ee538ab8beb0f->doDisplay (line 55)
18	Twig\Template->yield (line 411)
19	Twig\Template->display (line 366)
20	Twig\Template->render (line 381)
21	Twig\TemplateWrapper->render (line 51)
22	Twig\Environment->render (line 333)
23	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 467)
24	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 472)
25	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 284)
26	App\Identity\Presentation\Http\SitePasswordResetController->forgot (line 41)
27	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
28	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
29	Symfony\Component\HttpKernel\Kernel->handle (line 193)
30	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 34)
31	require_once (line 32)
32	require_once (line 5)

7.65 ms
(23.59%)

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)

5.52 ms
(17.02%)

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.80 ms
(8.62%)

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.81 ms
(2.51%)

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_ddb3ca65fa5f85f3141ee538ab8beb0f->block_page_content (line 122)
6	Twig\Template->yieldBlock (line 458)
7	__TwigTemplate_69cef74e4ffe200fcc75e8fd4ed27a8d->block_site_shell (line 137)
8	Twig\Template->yieldBlock (line 458)
9	__TwigTemplate_69cef74e4ffe200fcc75e8fd4ed27a8d->block_body (line 106)
10	Twig\Template->yieldBlock (line 458)
11	__TwigTemplate_f67a99fcfdb6a3c06f7b97aa3f8b96b6->doDisplay (line 107)
12	Twig\Template->yield (line 411)
13	__TwigTemplate_69cef74e4ffe200fcc75e8fd4ed27a8d->doDisplay (line 60)
14	Twig\Template->yield (line 411)
15	__TwigTemplate_50a8cf494acfca27134f95d826d4ef8b->doDisplay (line 56)
16	Twig\Template->yield (line 411)
17	__TwigTemplate_783bac79ace73c42027a5c5c0db06b34->doDisplay (line 53)
18	Twig\Template->yield (line 411)
19	__TwigTemplate_ddb3ca65fa5f85f3141ee538ab8beb0f->doDisplay (line 55)
20	Twig\Template->yield (line 411)
21	Twig\Template->display (line 366)
22	Twig\Template->render (line 381)
23	Twig\TemplateWrapper->render (line 51)
24	Twig\Environment->render (line 333)
25	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 467)
26	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 472)
27	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 284)
28	App\Identity\Presentation\Http\SitePasswordResetController->forgot (line 41)
29	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
30	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
31	Symfony\Component\HttpKernel\Kernel->handle (line 193)
32	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 34)
33	require_once (line 32)
34	require_once (line 5)

0.51 ms
(1.58%)

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 = ? AND t0.active = ? 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.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 = ?
  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.default_language = 1 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\Language\Presentation\Http\LanguageContextSubscriber->__invoke (line 22)
4	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
5	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
6	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
7	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 129)
8	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 159)
9	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
10	Symfony\Component\HttpKernel\Kernel->handle (line 193)
11	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 34)
12	require_once (line 32)
13	require_once (line 5)

0.43 ms
(1.34%)

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\Settings\Domain\Entity\SystemSettings	1
App\Language\Domain\Entity\Language	1
App\Cms\Domain\Entity\Page	1

Entities Mapping

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

Symfony Profiler

GET https://shopro4.orangestudio.pl/password/forgot

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping