Symfony Profiler

Query Metrics

10 Database Queries

6 Different statements

15.04 ms Query time

0 Invalid entities

7 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

7.69 ms
(51.15%)

SELECT c0_.id AS id_0, c0_.title AS title_1, c0_.slug AS slug_2, c0_.content AS content_3, c0_.editor_mode AS editor_mode_4, c0_.builder_data AS builder_data_5, c0_.builder_css AS builder_css_6, c0_.published AS published_7, c0_.publish_at AS publish_at_8, c0_.unpublish_at AS unpublish_at_9, c0_.caption AS caption_10, c0_.seo_title AS seo_title_11, c0_.description AS description_12, c0_.keywords AS keywords_13, c0_.meta AS meta_14, c0_.javascript AS javascript_15, c0_.canonical AS canonical_16, c0_.access AS access_17, c0_.follow AS follow_18, c0_.home_page AS home_page_19, c0_.error_page AS error_page_20, c0_.admin_only AS admin_only_21, c0_.login_page AS login_page_22, c0_.activation_page AS activation_page_23, c0_.account_page AS account_page_24, c0_.registration_page AS registration_page_25, c0_.search_page AS search_page_26, c0_.sitemap_page AS sitemap_page_27, c0_.profile_page AS profile_page_28, c0_.terms_page AS terms_page_29, c0_.created_at AS created_at_30, c0_.updated_at AS updated_at_31, c0_.deleted_at AS deleted_at_32, c0_.lock_version AS lock_version_33 FROM cms_page c0_ WHERE c0_.slug = ? AND c0_.deleted_at IS NULL AND c0_.published = 1 AND ((c0_.publish_at IS NULL OR c0_.publish_at <= ?)) AND ((c0_.unpublish_at IS NULL OR c0_.unpublish_at > ?))

Parameters:

[
  "robots.txt"
  "2026-09-11 07:23:40"
  "2026-09-11 07:23:40"
]

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_.content AS content_3,
  c0_.editor_mode AS editor_mode_4,
  c0_.builder_data AS builder_data_5,
  c0_.builder_css AS builder_css_6,
  c0_.published AS published_7,
  c0_.publish_at AS publish_at_8,
  c0_.unpublish_at AS unpublish_at_9,
  c0_.caption AS caption_10,
  c0_.seo_title AS seo_title_11,
  c0_.description AS description_12,
  c0_.keywords AS keywords_13,
  c0_.meta AS meta_14,
  c0_.javascript AS javascript_15,
  c0_.canonical AS canonical_16,
  c0_.access AS access_17,
  c0_.follow AS follow_18,
  c0_.home_page AS home_page_19,
  c0_.error_page AS error_page_20,
  c0_.admin_only AS admin_only_21,
  c0_.login_page AS login_page_22,
  c0_.activation_page AS activation_page_23,
  c0_.account_page AS account_page_24,
  c0_.registration_page AS registration_page_25,
  c0_.search_page AS search_page_26,
  c0_.sitemap_page AS sitemap_page_27,
  c0_.profile_page AS profile_page_28,
  c0_.terms_page AS terms_page_29,
  c0_.created_at AS created_at_30,
  c0_.updated_at AS updated_at_31,
  c0_.deleted_at AS deleted_at_32,
  c0_.lock_version AS lock_version_33
FROM
  cms_page c0_
WHERE
  c0_.slug = ?
  AND c0_.deleted_at IS NULL
  AND c0_.published = 1
  AND (
    (
      c0_.publish_at IS NULL
      OR c0_.publish_at <= ?
    )
  )
  AND (
    (
      c0_.unpublish_at IS NULL
      OR c0_.unpublish_at > ?
    )
  )

SELECT c0_.id AS id_0, c0_.title AS title_1, c0_.slug AS slug_2, c0_.content AS content_3, c0_.editor_mode AS editor_mode_4, c0_.builder_data AS builder_data_5, c0_.builder_css AS builder_css_6, c0_.published AS published_7, c0_.publish_at AS publish_at_8, c0_.unpublish_at AS unpublish_at_9, c0_.caption AS caption_10, c0_.seo_title AS seo_title_11, c0_.description AS description_12, c0_.keywords AS keywords_13, c0_.meta AS meta_14, c0_.javascript AS javascript_15, c0_.canonical AS canonical_16, c0_.access AS access_17, c0_.follow AS follow_18, c0_.home_page AS home_page_19, c0_.error_page AS error_page_20, c0_.admin_only AS admin_only_21, c0_.login_page AS login_page_22, c0_.activation_page AS activation_page_23, c0_.account_page AS account_page_24, c0_.registration_page AS registration_page_25, c0_.search_page AS search_page_26, c0_.sitemap_page AS sitemap_page_27, c0_.profile_page AS profile_page_28, c0_.terms_page AS terms_page_29, c0_.created_at AS created_at_30, c0_.updated_at AS updated_at_31, c0_.deleted_at AS deleted_at_32, c0_.lock_version AS lock_version_33 FROM cms_page c0_ WHERE c0_.slug = 'robots.txt' AND c0_.deleted_at IS NULL AND c0_.published = 1 AND ((c0_.publish_at IS NULL OR c0_.publish_at <= '2026-09-11 07:23:40')) AND ((c0_.unpublish_at IS NULL OR c0_.unpublish_at > '2026-09-11 07:23:40'));

#	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->getOneOrNullResult (line 737)
6	App\Cms\Infrastructure\Persistence\Doctrine\PageRepository->findPublishedBySlug (line 35)
7	App\Cms\Presentation\Http\SystemPageSlugSubscriber->pageFromPath (line 123)
8	App\Cms\Presentation\Http\SystemPageSlugSubscriber->routeEditableSlug (line 66)
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)

3.94 ms
(26.21%)

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.05 ms
(13.61%)

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)

0.61 ms
(4.05%)

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:

[
  "pl"
  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 = 'pl' 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 21)
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.45 ms
(3.01%)

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.29 ms
(1.96%)

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

Entities Mapping

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

Symfony Profiler

GET https://shopro4.orangestudio.pl/robots.txt

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping