Symfony Profiler

Query Metrics

12 Database Queries

7 Different statements

28.70 ms Query time

0 Invalid entities

9 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

11.92 ms
(41.55%)

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)

9.89 ms
(34.46%)

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.74 ms
(9.56%)

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.72 ms
(5.99%)

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:

[
  8
]

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 = 8;

#	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)

1.40 ms
(4.88%)

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
  "my-account"
  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 = 'my-account' 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)

0.69 ms
(2.40%)

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.33 ms
(1.15%)

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\Module\Domain\Entity\InstalledModule	5
App\Language\Domain\Entity\Language	1
App\Cms\Domain\Entity\PageTranslation	1
App\Cms\Domain\Entity\Page	1
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.

Symfony Profiler

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

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping