Symfony Profiler

Query Metrics

16 Database Queries

2 Different statements

9.52 ms Query time

0 Invalid entities

0 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

8.30 ms
(87.23%)

SELECT p0_.id AS id_0, p0_.page_slug AS page_slug_1, p0_.section_key AS section_key_2, p0_.section_label AS section_label_3, p0_.content AS content_4, p0_.styles AS styles_5, p0_.position AS position_6, p0_.is_active AS is_active_7, p0_.created_at AS created_at_8, p0_.updated_at AS updated_at_9 FROM page_content p0_ WHERE p0_.page_slug = ? AND p0_.section_key = ?

Parameters:

[
  "home"
  "hero"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  p0_.id AS id_0,
  p0_.page_slug AS page_slug_1,
  p0_.section_key AS section_key_2,
  p0_.section_label AS section_label_3,
  p0_.content AS content_4,
  p0_.styles AS styles_5,
  p0_.position AS position_6,
  p0_.is_active AS is_active_7,
  p0_.created_at AS created_at_8,
  p0_.updated_at AS updated_at_9
FROM
  page_content p0_
WHERE
  p0_.page_slug = ?
  AND p0_.section_key = ?

SELECT p0_.id AS id_0, p0_.page_slug AS page_slug_1, p0_.section_key AS section_key_2, p0_.section_label AS section_label_3, p0_.content AS content_4, p0_.styles AS styles_5, p0_.position AS position_6, p0_.is_active AS is_active_7, p0_.created_at AS created_at_8, p0_.updated_at AS updated_at_9 FROM page_content p0_ WHERE p0_.page_slug = 'home' AND p0_.section_key = 'hero';

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 27)
2	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 296)
3	Doctrine\ORM\Query->_doExecute (line 935)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 891)
5	Doctrine\ORM\AbstractQuery->execute (line 738)
6	Doctrine\ORM\AbstractQuery->getOneOrNullResult (line 27)
7	App\Repository\PageContentRepository->findSection (line 44)
8	App\Twig\PageContentExtension->getPageContent (line 52)
9	App\Twig\PageContentExtension->getContent (line 95)
10	__TwigTemplate_c1cc65a58a7e3c5d87d36e8a0c89f243->doDisplay (line 402)
11	Twig\Template->yield (line 103)
12	__TwigTemplate_d3959766efe01245ce6df27b3416e7a6->block_body (line 446)
13	Twig\Template->yieldBlock (line 84)
14	__TwigTemplate_f8b6285becf2c69a4535e34ec62a8c8b->doDisplay (line 402)
15	Twig\Template->yield (line 54)
16	__TwigTemplate_d3959766efe01245ce6df27b3416e7a6->doDisplay (line 402)
17	Twig\Template->yield (line 358)
18	Twig\Template->display (line 373)
19	Twig\Template->render (line 51)
20	Twig\TemplateWrapper->render (line 333)
21	Twig\Environment->render (line 459)
22	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 464)
23	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 278)
24	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 25)
25	App\Controller\HomeController->index (line 183)
26	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
27	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
28	Symfony\Component\HttpKernel\Kernel->handle (line 35)
29	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
30	require_once (line 5)

1.21 ms
(12.77%)

SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.slug AS slug_2, s0_.tagline AS tagline_3, s0_.description AS description_4, s0_.images AS images_5, s0_.color AS color_6, s0_.height AS height_7, s0_.status AS status_8, s0_.birth_year AS birth_year_9, s0_.origin AS origin_10, s0_.shoeing AS shoeing_11, s0_.characteristics AS characteristics_12, s0_.style_characteristics AS style_characteristics_13, s0_.physique_characteristics AS physique_characteristics_14, s0_.presence_characteristics AS presence_characteristics_15, s0_.aptitudes_characteristics AS aptitudes_characteristics_16, s0_.crossing_advice AS crossing_advice_17, s0_.hereditary_transmission AS hereditary_transmission_18, s0_.haras_file AS haras_file_19, s0_.ancce_file AS ancce_file_20, s0_.breeding_price AS breeding_price_21, s0_.breeding_conditions AS breeding_conditions_22, s0_.breeding_availability AS breeding_availability_23, s0_.sort_order AS sort_order_24, s0_.is_active AS is_active_25 FROM stallion s0_ WHERE s0_.is_active = ? ORDER BY s0_.sort_order ASC

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  s0_.id AS id_0,
  s0_.name AS name_1,
  s0_.slug AS slug_2,
  s0_.tagline AS tagline_3,
  s0_.description AS description_4,
  s0_.images AS images_5,
  s0_.color AS color_6,
  s0_.height AS height_7,
  s0_.status AS status_8,
  s0_.birth_year AS birth_year_9,
  s0_.origin AS origin_10,
  s0_.shoeing AS shoeing_11,
  s0_.characteristics AS characteristics_12,
  s0_.style_characteristics AS style_characteristics_13,
  s0_.physique_characteristics AS physique_characteristics_14,
  s0_.presence_characteristics AS presence_characteristics_15,
  s0_.aptitudes_characteristics AS aptitudes_characteristics_16,
  s0_.crossing_advice AS crossing_advice_17,
  s0_.hereditary_transmission AS hereditary_transmission_18,
  s0_.haras_file AS haras_file_19,
  s0_.ancce_file AS ancce_file_20,
  s0_.breeding_price AS breeding_price_21,
  s0_.breeding_conditions AS breeding_conditions_22,
  s0_.breeding_availability AS breeding_availability_23,
  s0_.sort_order AS sort_order_24,
  s0_.is_active AS is_active_25
FROM
  stallion s0_
WHERE
  s0_.is_active = ?
ORDER BY
  s0_.sort_order ASC

SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.slug AS slug_2, s0_.tagline AS tagline_3, s0_.description AS description_4, s0_.images AS images_5, s0_.color AS color_6, s0_.height AS height_7, s0_.status AS status_8, s0_.birth_year AS birth_year_9, s0_.origin AS origin_10, s0_.shoeing AS shoeing_11, s0_.characteristics AS characteristics_12, s0_.style_characteristics AS style_characteristics_13, s0_.physique_characteristics AS physique_characteristics_14, s0_.presence_characteristics AS presence_characteristics_15, s0_.aptitudes_characteristics AS aptitudes_characteristics_16, s0_.crossing_advice AS crossing_advice_17, s0_.hereditary_transmission AS hereditary_transmission_18, s0_.haras_file AS haras_file_19, s0_.ancce_file AS ancce_file_20, s0_.breeding_price AS breeding_price_21, s0_.breeding_conditions AS breeding_conditions_22, s0_.breeding_availability AS breeding_availability_23, s0_.sort_order AS sort_order_24, s0_.is_active AS is_active_25 FROM stallion s0_ WHERE s0_.is_active = 1 ORDER BY s0_.sort_order ASC;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 27)
2	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 296)
3	Doctrine\ORM\Query->_doExecute (line 935)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 891)
5	Doctrine\ORM\AbstractQuery->execute (line 689)
6	Doctrine\ORM\AbstractQuery->getResult (line 26)
7	App\Repository\StallionRepository->findActiveByOrder (line 21)
8	App\Twig\StallionExtension->getGlobals (line 359)
9	Twig\ExtensionSet->getGlobals (line 900)
10	Twig\Environment->getGlobals (line 398)
11	Twig\Template->yield (line 358)
12	Twig\Template->display (line 373)
13	Twig\Template->render (line 51)
14	Twig\TemplateWrapper->render (line 333)
15	Twig\Environment->render (line 459)
16	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 464)
17	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 278)
18	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 25)
19	App\Controller\HomeController->index (line 183)
20	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
21	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
22	Symfony\Component\HttpKernel\Kernel->handle (line 35)
23	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
24	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\Entity\Stallion	No errors.
App\Entity\PageContent	No errors.

Symfony Profiler

GET https://elevage-darmagnac.com/

Configuration Settings

Theme

Page Width