Symfony Profiler

Query Metrics

1 Database Queries

1 Different statements

0.56 ms Query time

0 Invalid entities

0 Managed entities

Queries

Group similar statements

#▲

Time

Info

0.56 ms

SELECT t0.id AS id_1, t0.date AS date_2, t0.section AS section_3, t0.year AS year_4, t0.number AS number_5, t0.title AS title_6, t0.description AS description_7, t0.headline AS headline_8, t0.in_home AS in_home_9, t0.app_send AS app_send_10, t0.button_label AS button_label_11, t0.button_decree_label AS button_decree_label_12, t0.created_at AS created_at_13, t0.deleted_at AS deleted_at_14, t0.publishing_status AS publishing_status_15, t0.ordering AS ordering_16, t0.document_name AS document_name_17, t0.document_original_name AS document_original_name_18, t0.document_url AS document_url_19, t0.decree_name AS decree_name_20, t0.decree_original_name AS decree_original_name_21, t0.decree_url AS decree_url_22 FROM releases t0 WHERE t0.deleted_at IS NULL AND t0.publishing_status = ? AND t0.in_home = ? ORDER BY t0.created_at DESC LIMIT 20

Parameters:

[
  "published"
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.date AS date_2,
  t0.section AS section_3,
  t0.year AS year_4,
  t0.number AS number_5,
  t0.title AS title_6,
  t0.description AS description_7,
  t0.headline AS headline_8,
  t0.in_home AS in_home_9,
  t0.app_send AS app_send_10,
  t0.button_label AS button_label_11,
  t0.button_decree_label AS button_decree_label_12,
  t0.created_at AS created_at_13,
  t0.deleted_at AS deleted_at_14,
  t0.publishing_status AS publishing_status_15,
  t0.ordering AS ordering_16,
  t0.document_name AS document_name_17,
  t0.document_original_name AS document_original_name_18,
  t0.document_url AS document_url_19,
  t0.decree_name AS decree_name_20,
  t0.decree_original_name AS decree_original_name_21,
  t0.decree_url AS decree_url_22
FROM
  releases t0
WHERE
  t0.deleted_at IS NULL
  AND t0.publishing_status = ?
  AND t0.in_home = ?
ORDER BY
  t0.created_at DESC
LIMIT
  20

SELECT t0.id AS id_1, t0.date AS date_2, t0.section AS section_3, t0.year AS year_4, t0.number AS number_5, t0.title AS title_6, t0.description AS description_7, t0.headline AS headline_8, t0.in_home AS in_home_9, t0.app_send AS app_send_10, t0.button_label AS button_label_11, t0.button_decree_label AS button_decree_label_12, t0.created_at AS created_at_13, t0.deleted_at AS deleted_at_14, t0.publishing_status AS publishing_status_15, t0.ordering AS ordering_16, t0.document_name AS document_name_17, t0.document_original_name AS document_original_name_18, t0.document_url AS document_url_19, t0.decree_name AS decree_name_20, t0.decree_original_name AS decree_original_name_21, t0.decree_url AS decree_url_22 FROM releases t0 WHERE t0.deleted_at IS NULL AND t0.publishing_status = 'published' AND t0.in_home = 1 ORDER BY t0.created_at DESC LIMIT 20;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 972)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 224)
3	Doctrine\ORM\EntityRepository->findBy (line 63)
4	App\Infrastructure\Repository\DatabaseReleaseRepository->findPublishedInHome (line 31)
5	App\Infrastructure\Controller\FrontendController->releases (line 181)
6	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
7	Symfony\Component\HttpKernel\HttpKernel->handle (line 86)
8	Symfony\Component\HttpKernel\HttpCache\SubRequestHandler::handle (line 78)
9	Symfony\Component\HttpKernel\Fragment\InlineFragmentRenderer->render (line 83)
10	Symfony\Component\HttpKernel\Fragment\FragmentHandler->render (line 47)
11	Symfony\Component\HttpKernel\DependencyInjection\LazyLoadingFragmentHandler->render (line 44)
12	Symfony\Bridge\Twig\Extension\HttpKernelRuntime->renderFragment (line 519)
13	__TwigTemplate_436c06dedb71c2da5321451040e72550->block_page_content (line 432)
14	Twig\Template->yieldBlock (line 88)
15	__TwigTemplate_eb1a6acf58fa5323388f173e9cf0feb5->doDisplay (line 388)
16	Twig\Template->yield (line 58)
17	__TwigTemplate_436c06dedb71c2da5321451040e72550->doDisplay (line 388)
18	Twig\Template->yield (line 344)
19	Twig\Template->display (line 359)
20	Twig\Template->render (line 51)
21	Twig\TemplateWrapper->render (line 334)
22	Twig\Environment->render (line 448)
23	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 453)
24	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 253)
25	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 24)
26	App\Infrastructure\Controller\FrontendController->index (line 181)
27	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
28	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
29	Symfony\Component\HttpKernel\Kernel->handle (line 35)
30	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
31	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

Entities Mapping

Class	Mapping errors
App\Domain\User\Entity\User	No errors.
App\Domain\Basic\Entity\Document	No errors.
App\Domain\Release\Entity\Release	No errors.

Symfony Profiler

GET https://cc.strategiedigitali.net/index.php/_fragment?_path=_format%3Dhtml%26_locale%3Dit%26_controller%3DApp%255CInfrastructure%255CController%255CFrontendContr…

Configuration Settings

Theme

Page Width