Symfony Profiler

Query Metrics

3 Database Queries

2 Different statements

3.42 ms Query time

0 Invalid entities

0 Managed entities

Queries

Group similar statements

#▲

Time

Info

1.38 ms

SELECT t0.id AS id_1, t0.key_name AS key_name_2, t0.value AS value_3, t0.locked AS locked_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6 FROM config t0 WHERE t0.key_name = ? LIMIT 1

Parameters:

[
  "cache.pages"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.key_name AS key_name_2,
  t0.value AS value_3,
  t0.locked AS locked_4,
  t0.created_at AS created_at_5,
  t0.updated_at AS updated_at_6
FROM
  config t0
WHERE
  t0.key_name = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.key_name AS key_name_2, t0.value AS value_3, t0.locked AS locked_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6 FROM config t0 WHERE t0.key_name = 'cache.pages' 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\Service\BoltConfig->App\Service\{closure} (line 34)
5	Symfony\Component\Cache\Adapter\TraceableAdapter->Symfony\Component\Cache\Adapter\{closure} (line 57)
6	Symfony\Component\Cache\LockRegistry->compute (line 113)
7	Symfony\Component\Cache\Adapter\AbstractAdapter::Symfony\Component\Cache\Traits\{closure} (line 102)
8	Symfony\Component\Cache\Adapter\AbstractAdapter->contractsGet (line 64)
9	Symfony\Component\Cache\Adapter\AbstractAdapter->doGet (line 85)
10	Symfony\Component\Cache\Adapter\AbstractAdapter->get (line 30)
11	Symfony\Component\Cache\Adapter\TraceableAdapter->get (line 62)
12	App\Service\BoltConfig->get (line 32)
13	App\Service\PageCacheService->enabled (line 32)
14	App\EventListener\PageCacheListener->onRequest (line 42)
15	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
16	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
17	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
18	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 129)
19	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 159)
20	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
21	Symfony\Component\HttpKernel\Kernel->handle (line 193)
22	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
23	require_once (line 32)
24	require_once (line 6)

1.41 ms

SELECT t0.id AS id_1, t0.uri AS uri_2, t0.title AS title_3, t0.content AS content_4, t0.status AS status_5, t0.template AS template_6, t0.meta_title AS meta_title_7, t0.meta_description AS meta_description_8, t0.meta_image AS meta_image_9, t0.featured_image AS featured_image_10, t0.featured AS featured_11, t0.sort AS sort_12, t0.options AS options_13, t0.published_at AS published_at_14, t0.created_by AS created_by_15, t0.updated_by AS updated_by_16, t0.created_at AS created_at_17, t0.updated_at AS updated_at_18, t0.deleted_at AS deleted_at_19, t0.parent_id AS parent_id_20 FROM cms_page t0 WHERE t0.uri = ? LIMIT 1

Parameters:

[
  "home"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.uri AS uri_2,
  t0.title AS title_3,
  t0.content AS content_4,
  t0.status AS status_5,
  t0.template AS template_6,
  t0.meta_title AS meta_title_7,
  t0.meta_description AS meta_description_8,
  t0.meta_image AS meta_image_9,
  t0.featured_image AS featured_image_10,
  t0.featured AS featured_11,
  t0.sort AS sort_12,
  t0.options AS options_13,
  t0.published_at AS published_at_14,
  t0.created_by AS created_by_15,
  t0.updated_by AS updated_by_16,
  t0.created_at AS created_at_17,
  t0.updated_at AS updated_at_18,
  t0.deleted_at AS deleted_at_19,
  t0.parent_id AS parent_id_20
FROM
  cms_page t0
WHERE
  t0.uri = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.uri AS uri_2, t0.title AS title_3, t0.content AS content_4, t0.status AS status_5, t0.template AS template_6, t0.meta_title AS meta_title_7, t0.meta_description AS meta_description_8, t0.meta_image AS meta_image_9, t0.featured_image AS featured_image_10, t0.featured AS featured_11, t0.sort AS sort_12, t0.options AS options_13, t0.published_at AS published_at_14, t0.created_by AS created_by_15, t0.updated_by AS updated_by_16, t0.created_at AS created_at_17, t0.updated_at AS updated_at_18, t0.deleted_at AS deleted_at_19, t0.parent_id AS parent_id_20 FROM cms_page t0 WHERE t0.uri = 'home' 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\Bundle\BoltCms\Service\PageService->getByUri (line 60)
5	App\Bundle\BoltCms\Controller\Public\PublicCatchAllController->home (line 95)
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 35)
10	require_once (line 32)
11	require_once (line 6)

0.63 ms

SELECT t0.id AS id_1, t0.key_name AS key_name_2, t0.value AS value_3, t0.locked AS locked_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6 FROM config t0 WHERE t0.key_name = ? LIMIT 1

Parameters:

[
  "theme"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.key_name AS key_name_2,
  t0.value AS value_3,
  t0.locked AS locked_4,
  t0.created_at AS created_at_5,
  t0.updated_at AS updated_at_6
FROM
  config t0
WHERE
  t0.key_name = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.key_name AS key_name_2, t0.value AS value_3, t0.locked AS locked_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6 FROM config t0 WHERE t0.key_name = 'theme' 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\Service\BoltConfig->App\Service\{closure} (line 34)
5	Symfony\Component\Cache\Adapter\TraceableAdapter->Symfony\Component\Cache\Adapter\{closure} (line 57)
6	Symfony\Component\Cache\LockRegistry->compute (line 113)
7	Symfony\Component\Cache\Adapter\AbstractAdapter::Symfony\Component\Cache\Traits\{closure} (line 102)
8	Symfony\Component\Cache\Adapter\AbstractAdapter->contractsGet (line 64)
9	Symfony\Component\Cache\Adapter\AbstractAdapter->doGet (line 85)
10	Symfony\Component\Cache\Adapter\AbstractAdapter->get (line 30)
11	Symfony\Component\Cache\Adapter\TraceableAdapter->get (line 62)
12	App\Service\BoltConfig->get (line 32)
13	App\Service\ThemeService->theme (line 25)
14	App\Bundle\BoltCms\Controller\Public\PublicCatchAllController->fallbackHome (line 238)
15	App\Bundle\BoltCms\Controller\Public\PublicCatchAllController->home (line 98)
16	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
17	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
18	Symfony\Component\HttpKernel\Kernel->handle (line 193)
19	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
20	require_once (line 32)
21	require_once (line 6)

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

Entities Mapping

Class	Mapping errors
App\Entity\Config	No errors.
App\Bundle\BoltCms\Entity\Page	No errors.

Symfony Profiler

GET https://test.graystorm.xyz/

Configuration Settings

Theme

Page Width

Query Metrics

Queries

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping