Symfony Profiler

Query Metrics

3 Database Queries

2 Different statements

0.77 ms Query time

0 Invalid entities

Queries

Group similar statements

#▲

Time

Info

0.26 ms

SELECT t0.enabled AS enabled_1, t0.name AS name_2, t0.relative_path AS relative_path_3, t0.host AS host_4, t0.enabled_from AS enabled_from_5, t0.enabled_to AS enabled_to_6, t0.is_default AS is_default_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.locale AS locale_10, t0.title AS title_11, t0.meta_keywords AS meta_keywords_12, t0.meta_description AS meta_description_13, t0.id AS id_14 FROM page__site t0 WHERE t0.host IN (?, ?) AND t0.enabled = ? ORDER BY t0.is_default DESC

Parameters:

[
  "suus-backend.dev5.pl"
  "localhost"
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.enabled AS enabled_1,
  t0.name AS name_2,
  t0.relative_path AS relative_path_3,
  t0.host AS host_4,
  t0.enabled_from AS enabled_from_5,
  t0.enabled_to AS enabled_to_6,
  t0.is_default AS is_default_7,
  t0.created_at AS created_at_8,
  t0.updated_at AS updated_at_9,
  t0.locale AS locale_10,
  t0.title AS title_11,
  t0.meta_keywords AS meta_keywords_12,
  t0.meta_description AS meta_description_13,
  t0.id AS id_14
FROM
  page__site t0
WHERE
  t0.host IN (?, ?)
  AND t0.enabled = ?
ORDER BY
  t0.is_default DESC

SELECT t0.enabled AS enabled_1, t0.name AS name_2, t0.relative_path AS relative_path_3, t0.host AS host_4, t0.enabled_from AS enabled_from_5, t0.enabled_to AS enabled_to_6, t0.is_default AS is_default_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.locale AS locale_10, t0.title AS title_11, t0.meta_keywords AS meta_keywords_12, t0.meta_description AS meta_description_13, t0.id AS id_14 FROM page__site t0 WHERE t0.host IN ('suus-backend.dev5.pl', 'localhost') AND t0.enabled = 1 ORDER BY t0.is_default DESC;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 939)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 225)
3	Doctrine\ORM\EntityRepository->findBy (line 49)
4	Sonata\Doctrine\Model\BaseManager->findBy (line 89)
5	Sonata\PageBundle\Site\BaseSiteSelector->getSites (line 25)
6	Sonata\PageBundle\Site\HostSiteSelector->handleKernelRequest (line 58)
7	Sonata\PageBundle\Site\BaseSiteSelector->onKernelRequest (line 116)
8	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 220)
9	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
10	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 139)
11	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 157)
12	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
13	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
14	Symfony\Component\HttpKernel\Kernel->handle (line 35)
15	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
16	require_once (line 22)

0.41 ms

SELECT p0_.route_name AS route_name_0, p0_.page_alias AS page_alias_1, p0_.type AS type_2, p0_.position AS position_3, p0_.enabled AS enabled_4, p0_.decorate AS decorate_5, p0_.name AS name_6, p0_.url AS url_7, p0_.parent_id AS parent_id_8, p0_.content AS content_9, p0_.publication_date_start AS publication_date_start_10, p0_.publication_date_end AS publication_date_end_11, p0_.created_at AS created_at_12, p0_.updated_at AS updated_at_13, p0_.id AS id_14, p0_.site_id AS site_id_15, p0_.page_id AS page_id_16 FROM page__snapshot p0_ WHERE (p0_.publication_date_start <= ? AND (p0_.publication_date_end IS NULL OR p0_.publication_date_end >= ?)) AND p0_.enabled = 1 AND p0_.site_id = ? AND p0_.url = ? LIMIT 1

Parameters:

[
  "2025-04-19 16:13:31"
  "2025-04-19 16:13:31"
  9
  "/admin"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  p0_.route_name AS route_name_0,
  p0_.page_alias AS page_alias_1,
  p0_.type AS type_2,
  p0_.position AS position_3,
  p0_.enabled AS enabled_4,
  p0_.decorate AS decorate_5,
  p0_.name AS name_6,
  p0_.url AS url_7,
  p0_.parent_id AS parent_id_8,
  p0_.content AS content_9,
  p0_.publication_date_start AS publication_date_start_10,
  p0_.publication_date_end AS publication_date_end_11,
  p0_.created_at AS created_at_12,
  p0_.updated_at AS updated_at_13,
  p0_.id AS id_14,
  p0_.site_id AS site_id_15,
  p0_.page_id AS page_id_16
FROM
  page__snapshot p0_
WHERE
  (
    p0_.publication_date_start <= ?
    AND (
      p0_.publication_date_end IS NULL
      OR p0_.publication_date_end >= ?
    )
  )
  AND p0_.enabled = 1
  AND p0_.site_id = ?
  AND p0_.url = ?
LIMIT
  1

SELECT p0_.route_name AS route_name_0, p0_.page_alias AS page_alias_1, p0_.type AS type_2, p0_.position AS position_3, p0_.enabled AS enabled_4, p0_.decorate AS decorate_5, p0_.name AS name_6, p0_.url AS url_7, p0_.parent_id AS parent_id_8, p0_.content AS content_9, p0_.publication_date_start AS publication_date_start_10, p0_.publication_date_end AS publication_date_end_11, p0_.created_at AS created_at_12, p0_.updated_at AS updated_at_13, p0_.id AS id_14, p0_.site_id AS site_id_15, p0_.page_id AS page_id_16 FROM page__snapshot p0_ WHERE (p0_.publication_date_start <= '2025-04-19 16:13:31' AND (p0_.publication_date_end IS NULL OR p0_.publication_date_end >= '2025-04-19 16:13:31')) AND p0_.enabled = 1 AND p0_.site_id = 9 AND p0_.url = '/admin' LIMIT 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 33)
2	Doctrine\ORM\Query\Exec\SingleSelectExecutor->execute (line 327)
3	Doctrine\ORM\Query->_doExecute (line 1212)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 1166)
5	Doctrine\ORM\AbstractQuery->execute (line 953)
6	Doctrine\ORM\AbstractQuery->getOneOrNullResult (line 122)
7	Sonata\PageBundle\Entity\SnapshotManager->findEnableSnapshot (line 128)
8	Sonata\PageBundle\CmsManager\CmsSnapshotManager->getPageBy (line 49)
9	Sonata\PageBundle\CmsManager\BaseCmsPageManager->getPageByUrl (line 134)
10	Sonata\PageBundle\Route\CmsPageRouter->match (line 164)
11	Symfony\Cmf\Component\Routing\ChainRouter->doMatch (line 134)
12	Symfony\Cmf\Component\Routing\ChainRouter->matchRequest (line 105)
13	Symfony\Component\HttpKernel\EventListener\RouterListener->onKernelRequest (line 116)
14	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 220)
15	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
16	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 139)
17	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 157)
18	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
19	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
20	Symfony\Component\HttpKernel\Kernel->handle (line 35)
21	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
22	require_once (line 22)

0.10 ms

SELECT p0_.route_name AS route_name_0, p0_.page_alias AS page_alias_1, p0_.type AS type_2, p0_.position AS position_3, p0_.enabled AS enabled_4, p0_.decorate AS decorate_5, p0_.name AS name_6, p0_.url AS url_7, p0_.parent_id AS parent_id_8, p0_.content AS content_9, p0_.publication_date_start AS publication_date_start_10, p0_.publication_date_end AS publication_date_end_11, p0_.created_at AS created_at_12, p0_.updated_at AS updated_at_13, p0_.id AS id_14, p0_.site_id AS site_id_15, p0_.page_id AS page_id_16 FROM page__snapshot p0_ WHERE (p0_.publication_date_start <= ? AND (p0_.publication_date_end IS NULL OR p0_.publication_date_end >= ?)) AND p0_.enabled = 1 AND p0_.site_id = ? AND p0_.url = ? LIMIT 1

Parameters:

[
  "2025-04-19 16:13:31"
  "2025-04-19 16:13:31"
  9
  "/admin"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  p0_.route_name AS route_name_0,
  p0_.page_alias AS page_alias_1,
  p0_.type AS type_2,
  p0_.position AS position_3,
  p0_.enabled AS enabled_4,
  p0_.decorate AS decorate_5,
  p0_.name AS name_6,
  p0_.url AS url_7,
  p0_.parent_id AS parent_id_8,
  p0_.content AS content_9,
  p0_.publication_date_start AS publication_date_start_10,
  p0_.publication_date_end AS publication_date_end_11,
  p0_.created_at AS created_at_12,
  p0_.updated_at AS updated_at_13,
  p0_.id AS id_14,
  p0_.site_id AS site_id_15,
  p0_.page_id AS page_id_16
FROM
  page__snapshot p0_
WHERE
  (
    p0_.publication_date_start <= ?
    AND (
      p0_.publication_date_end IS NULL
      OR p0_.publication_date_end >= ?
    )
  )
  AND p0_.enabled = 1
  AND p0_.site_id = ?
  AND p0_.url = ?
LIMIT
  1

SELECT p0_.route_name AS route_name_0, p0_.page_alias AS page_alias_1, p0_.type AS type_2, p0_.position AS position_3, p0_.enabled AS enabled_4, p0_.decorate AS decorate_5, p0_.name AS name_6, p0_.url AS url_7, p0_.parent_id AS parent_id_8, p0_.content AS content_9, p0_.publication_date_start AS publication_date_start_10, p0_.publication_date_end AS publication_date_end_11, p0_.created_at AS created_at_12, p0_.updated_at AS updated_at_13, p0_.id AS id_14, p0_.site_id AS site_id_15, p0_.page_id AS page_id_16 FROM page__snapshot p0_ WHERE (p0_.publication_date_start <= '2025-04-19 16:13:31' AND (p0_.publication_date_end IS NULL OR p0_.publication_date_end >= '2025-04-19 16:13:31')) AND p0_.enabled = 1 AND p0_.site_id = 9 AND p0_.url = '/admin' LIMIT 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 33)
2	Doctrine\ORM\Query\Exec\SingleSelectExecutor->execute (line 327)
3	Doctrine\ORM\Query->_doExecute (line 1212)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 1166)
5	Doctrine\ORM\AbstractQuery->execute (line 953)
6	Doctrine\ORM\AbstractQuery->getOneOrNullResult (line 122)
7	Sonata\PageBundle\Entity\SnapshotManager->findEnableSnapshot (line 128)
8	Sonata\PageBundle\CmsManager\CmsSnapshotManager->getPageBy (line 49)
9	Sonata\PageBundle\CmsManager\BaseCmsPageManager->getPageByUrl (line 134)
10	Sonata\PageBundle\Route\CmsPageRouter->match (line 164)
11	Symfony\Cmf\Component\Routing\ChainRouter->doMatch (line 134)
12	Symfony\Cmf\Component\Routing\ChainRouter->matchRequest (line 105)
13	Symfony\Component\HttpKernel\EventListener\RouterListener->onKernelRequest (line 116)
14	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 220)
15	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
16	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 139)
17	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 157)
18	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
19	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
20	Symfony\Component\HttpKernel\Kernel->handle (line 35)
21	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
22	require_once (line 22)

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.

Entities Mapping

Class	Mapping errors
Sonata\PageBundle\Entity\BaseSite	No errors.
App\Entity\SonataPageSite	No errors.
Sonata\PageBundle\Entity\BaseSnapshot	No errors.
App\Entity\SonataPageSnapshot	No errors.
Sonata\PageBundle\Entity\BasePage	No errors.
App\Entity\SonataPagePage	No errors.

Symfony Profiler

GET https://suus-backend.dev5.pl/admin

Configuration Settings

Theme

Page Width

Query Metrics

Queries

Database Connections

Entity Managers

Second Level Cache

Entities Mapping