Symfony Profiler

Query Metrics

3 Database Queries

3 Different statements

3.39 ms Query time

0 Invalid entities

0 Managed entities

Queries

Group similar statements

#▲

Time

Info

2.06 ms

SELECT p0_.title AS title_0, p0_.content AS content_1, p0_.id AS id_2, p0_.legacy_id AS legacy_id_3, p0_.legacy_table AS legacy_table_4, p0_.legacy_remaining_data AS legacy_remaining_data_5, p0_."order_position" AS order_position_6, p0_.enabled AS enabled_7, p0_.created_at AS created_at_8, p0_.updated_at AS updated_at_9, p1_.original_name AS original_name_10, p1_.acronym AS acronym_11, p1_.type AS type_12, p1_.morph_call AS morph_call_13, p1_.story AS story_14, p1_.slide_title AS slide_title_15, p1_.slide_content AS slide_content_16, p1_.copyright AS copyright_17, p1_.id AS id_18, p1_.legacy_id AS legacy_id_19, p1_.legacy_table AS legacy_table_20, p1_.legacy_remaining_data AS legacy_remaining_data_21, p1_.created_at AS created_at_22, p1_.updated_at AS updated_at_23, p1_.enabled AS enabled_24, p1_.name AS name_25, p1_.slug AS slug_26, p1_."order_position" AS order_position_27, p2_.checksum AS checksum_28, p2_.legacy_uri AS legacy_uri_29, p2_.id AS id_30, p2_.created_at AS created_at_31, p2_.updated_at AS updated_at_32, p2_.file_metadata_name AS file_metadata_name_33, p2_.file_metadata_original_name AS file_metadata_original_name_34, p2_.file_metadata_mime_type AS file_metadata_mime_type_35, p2_.file_metadata_size AS file_metadata_size_36, p2_.file_metadata_dimensions AS file_metadata_dimensions_37, p0_.background_id AS background_id_38, p0_.universe_id AS universe_id_39, p1_.logo_sd_media_id AS logo_sd_media_id_40, p1_.logo_sd_bw_media_id AS logo_sd_bw_media_id_41, p1_.logo_media_id AS logo_media_id_42, p1_.prequel_universe_id AS prequel_universe_id_43, p1_.slide_background_id AS slide_background_id_44 FROM "prf__display__slide" p0_ LEFT JOIN "prf__universe__universe" p1_ ON p0_.universe_id = p1_.id INNER JOIN "prf__file__media" p2_ ON p0_.background_id = p2_.id WHERE p0_.enabled = true ORDER BY p0_."order_position" ASC

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  p0_.title AS title_0,
  p0_.content AS content_1,
  p0_.id AS id_2,
  p0_.legacy_id AS legacy_id_3,
  p0_.legacy_table AS legacy_table_4,
  p0_.legacy_remaining_data AS legacy_remaining_data_5,
  p0_."order_position" AS order_position_6,
  p0_.enabled AS enabled_7,
  p0_.created_at AS created_at_8,
  p0_.updated_at AS updated_at_9,
  p1_.original_name AS original_name_10,
  p1_.acronym AS acronym_11,
  p1_.type AS type_12,
  p1_.morph_call AS morph_call_13,
  p1_.story AS story_14,
  p1_.slide_title AS slide_title_15,
  p1_.slide_content AS slide_content_16,
  p1_.copyright AS copyright_17,
  p1_.id AS id_18,
  p1_.legacy_id AS legacy_id_19,
  p1_.legacy_table AS legacy_table_20,
  p1_.legacy_remaining_data AS legacy_remaining_data_21,
  p1_.created_at AS created_at_22,
  p1_.updated_at AS updated_at_23,
  p1_.enabled AS enabled_24,
  p1_.name AS name_25,
  p1_.slug AS slug_26,
  p1_."order_position" AS order_position_27,
  p2_.checksum AS checksum_28,
  p2_.legacy_uri AS legacy_uri_29,
  p2_.id AS id_30,
  p2_.created_at AS created_at_31,
  p2_.updated_at AS updated_at_32,
  p2_.file_metadata_name AS file_metadata_name_33,
  p2_.file_metadata_original_name AS file_metadata_original_name_34,
  p2_.file_metadata_mime_type AS file_metadata_mime_type_35,
  p2_.file_metadata_size AS file_metadata_size_36,
  p2_.file_metadata_dimensions AS file_metadata_dimensions_37,
  p0_.background_id AS background_id_38,
  p0_.universe_id AS universe_id_39,
  p1_.logo_sd_media_id AS logo_sd_media_id_40,
  p1_.logo_sd_bw_media_id AS logo_sd_bw_media_id_41,
  p1_.logo_media_id AS logo_media_id_42,
  p1_.prequel_universe_id AS prequel_universe_id_43,
  p1_.slide_background_id AS slide_background_id_44
FROM
  "prf__display__slide" p0_
  LEFT JOIN "prf__universe__universe" p1_ ON p0_.universe_id = p1_.id
  INNER JOIN "prf__file__media" p2_ ON p0_.background_id = p2_.id
WHERE
  p0_.enabled = true
ORDER BY
  p0_."order_position" ASC

SELECT p0_.title AS title_0, p0_.content AS content_1, p0_.id AS id_2, p0_.legacy_id AS legacy_id_3, p0_.legacy_table AS legacy_table_4, p0_.legacy_remaining_data AS legacy_remaining_data_5, p0_."order_position" AS order_position_6, p0_.enabled AS enabled_7, p0_.created_at AS created_at_8, p0_.updated_at AS updated_at_9, p1_.original_name AS original_name_10, p1_.acronym AS acronym_11, p1_.type AS type_12, p1_.morph_call AS morph_call_13, p1_.story AS story_14, p1_.slide_title AS slide_title_15, p1_.slide_content AS slide_content_16, p1_.copyright AS copyright_17, p1_.id AS id_18, p1_.legacy_id AS legacy_id_19, p1_.legacy_table AS legacy_table_20, p1_.legacy_remaining_data AS legacy_remaining_data_21, p1_.created_at AS created_at_22, p1_.updated_at AS updated_at_23, p1_.enabled AS enabled_24, p1_.name AS name_25, p1_.slug AS slug_26, p1_."order_position" AS order_position_27, p2_.checksum AS checksum_28, p2_.legacy_uri AS legacy_uri_29, p2_.id AS id_30, p2_.created_at AS created_at_31, p2_.updated_at AS updated_at_32, p2_.file_metadata_name AS file_metadata_name_33, p2_.file_metadata_original_name AS file_metadata_original_name_34, p2_.file_metadata_mime_type AS file_metadata_mime_type_35, p2_.file_metadata_size AS file_metadata_size_36, p2_.file_metadata_dimensions AS file_metadata_dimensions_37, p0_.background_id AS background_id_38, p0_.universe_id AS universe_id_39, p1_.logo_sd_media_id AS logo_sd_media_id_40, p1_.logo_sd_bw_media_id AS logo_sd_bw_media_id_41, p1_.logo_media_id AS logo_media_id_42, p1_.prequel_universe_id AS prequel_universe_id_43, p1_.slide_background_id AS slide_background_id_44 FROM "prf__display__slide" p0_ LEFT JOIN "prf__universe__universe" p1_ ON p0_.universe_id = p1_.id INNER JOIN "prf__file__media" p2_ ON p0_.background_id = p2_.id WHERE p0_.enabled = true ORDER BY p0_."order_position" ASC;

#	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->getResult (line 688)
6	App\Repository\Display\SlideRepository->findAllEnabledAndOrdered (line 40)
7	App\Controller\Front\Home->__invoke (line 23)
8	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
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 35)
12	require_once (line 32)
13	require_once (line 5)

0.78 ms

SELECT p0_.original_name AS original_name_0, p0_.acronym AS acronym_1, p0_.type AS type_2, p0_.morph_call AS morph_call_3, p0_.story AS story_4, p0_.slide_title AS slide_title_5, p0_.slide_content AS slide_content_6, p0_.copyright AS copyright_7, p0_.id AS id_8, p0_.legacy_id AS legacy_id_9, p0_.legacy_table AS legacy_table_10, p0_.legacy_remaining_data AS legacy_remaining_data_11, p0_.created_at AS created_at_12, p0_.updated_at AS updated_at_13, p0_.enabled AS enabled_14, p0_.name AS name_15, p0_.slug AS slug_16, p0_."order_position" AS order_position_17, p1_.checksum AS checksum_18, p1_.legacy_uri AS legacy_uri_19, p1_.id AS id_20, p1_.created_at AS created_at_21, p1_.updated_at AS updated_at_22, p1_.file_metadata_name AS file_metadata_name_23, p1_.file_metadata_original_name AS file_metadata_original_name_24, p1_.file_metadata_mime_type AS file_metadata_mime_type_25, p1_.file_metadata_size AS file_metadata_size_26, p1_.file_metadata_dimensions AS file_metadata_dimensions_27, p2_.checksum AS checksum_28, p2_.legacy_uri AS legacy_uri_29, p2_.id AS id_30, p2_.created_at AS created_at_31, p2_.updated_at AS updated_at_32, p2_.file_metadata_name AS file_metadata_name_33, p2_.file_metadata_original_name AS file_metadata_original_name_34, p2_.file_metadata_mime_type AS file_metadata_mime_type_35, p2_.file_metadata_size AS file_metadata_size_36, p2_.file_metadata_dimensions AS file_metadata_dimensions_37, p0_.logo_sd_media_id AS logo_sd_media_id_38, p0_.logo_sd_bw_media_id AS logo_sd_bw_media_id_39, p0_.logo_media_id AS logo_media_id_40, p0_.prequel_universe_id AS prequel_universe_id_41, p0_.slide_background_id AS slide_background_id_42 FROM "prf__universe__universe" p0_ INNER JOIN "prf__file__media" p1_ ON p0_.logo_sd_media_id = p1_.id INNER JOIN "prf__file__media" p2_ ON p0_.logo_sd_bw_media_id = p2_.id WHERE p0_.enabled = true ORDER BY p0_."order_position" ASC

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  p0_.original_name AS original_name_0,
  p0_.acronym AS acronym_1,
  p0_.type AS type_2,
  p0_.morph_call AS morph_call_3,
  p0_.story AS story_4,
  p0_.slide_title AS slide_title_5,
  p0_.slide_content AS slide_content_6,
  p0_.copyright AS copyright_7,
  p0_.id AS id_8,
  p0_.legacy_id AS legacy_id_9,
  p0_.legacy_table AS legacy_table_10,
  p0_.legacy_remaining_data AS legacy_remaining_data_11,
  p0_.created_at AS created_at_12,
  p0_.updated_at AS updated_at_13,
  p0_.enabled AS enabled_14,
  p0_.name AS name_15,
  p0_.slug AS slug_16,
  p0_."order_position" AS order_position_17,
  p1_.checksum AS checksum_18,
  p1_.legacy_uri AS legacy_uri_19,
  p1_.id AS id_20,
  p1_.created_at AS created_at_21,
  p1_.updated_at AS updated_at_22,
  p1_.file_metadata_name AS file_metadata_name_23,
  p1_.file_metadata_original_name AS file_metadata_original_name_24,
  p1_.file_metadata_mime_type AS file_metadata_mime_type_25,
  p1_.file_metadata_size AS file_metadata_size_26,
  p1_.file_metadata_dimensions AS file_metadata_dimensions_27,
  p2_.checksum AS checksum_28,
  p2_.legacy_uri AS legacy_uri_29,
  p2_.id AS id_30,
  p2_.created_at AS created_at_31,
  p2_.updated_at AS updated_at_32,
  p2_.file_metadata_name AS file_metadata_name_33,
  p2_.file_metadata_original_name AS file_metadata_original_name_34,
  p2_.file_metadata_mime_type AS file_metadata_mime_type_35,
  p2_.file_metadata_size AS file_metadata_size_36,
  p2_.file_metadata_dimensions AS file_metadata_dimensions_37,
  p0_.logo_sd_media_id AS logo_sd_media_id_38,
  p0_.logo_sd_bw_media_id AS logo_sd_bw_media_id_39,
  p0_.logo_media_id AS logo_media_id_40,
  p0_.prequel_universe_id AS prequel_universe_id_41,
  p0_.slide_background_id AS slide_background_id_42
FROM
  "prf__universe__universe" p0_
  INNER JOIN "prf__file__media" p1_ ON p0_.logo_sd_media_id = p1_.id
  INNER JOIN "prf__file__media" p2_ ON p0_.logo_sd_bw_media_id = p2_.id
WHERE
  p0_.enabled = true
ORDER BY
  p0_."order_position" ASC

SELECT p0_.original_name AS original_name_0, p0_.acronym AS acronym_1, p0_.type AS type_2, p0_.morph_call AS morph_call_3, p0_.story AS story_4, p0_.slide_title AS slide_title_5, p0_.slide_content AS slide_content_6, p0_.copyright AS copyright_7, p0_.id AS id_8, p0_.legacy_id AS legacy_id_9, p0_.legacy_table AS legacy_table_10, p0_.legacy_remaining_data AS legacy_remaining_data_11, p0_.created_at AS created_at_12, p0_.updated_at AS updated_at_13, p0_.enabled AS enabled_14, p0_.name AS name_15, p0_.slug AS slug_16, p0_."order_position" AS order_position_17, p1_.checksum AS checksum_18, p1_.legacy_uri AS legacy_uri_19, p1_.id AS id_20, p1_.created_at AS created_at_21, p1_.updated_at AS updated_at_22, p1_.file_metadata_name AS file_metadata_name_23, p1_.file_metadata_original_name AS file_metadata_original_name_24, p1_.file_metadata_mime_type AS file_metadata_mime_type_25, p1_.file_metadata_size AS file_metadata_size_26, p1_.file_metadata_dimensions AS file_metadata_dimensions_27, p2_.checksum AS checksum_28, p2_.legacy_uri AS legacy_uri_29, p2_.id AS id_30, p2_.created_at AS created_at_31, p2_.updated_at AS updated_at_32, p2_.file_metadata_name AS file_metadata_name_33, p2_.file_metadata_original_name AS file_metadata_original_name_34, p2_.file_metadata_mime_type AS file_metadata_mime_type_35, p2_.file_metadata_size AS file_metadata_size_36, p2_.file_metadata_dimensions AS file_metadata_dimensions_37, p0_.logo_sd_media_id AS logo_sd_media_id_38, p0_.logo_sd_bw_media_id AS logo_sd_bw_media_id_39, p0_.logo_media_id AS logo_media_id_40, p0_.prequel_universe_id AS prequel_universe_id_41, p0_.slide_background_id AS slide_background_id_42 FROM "prf__universe__universe" p0_ INNER JOIN "prf__file__media" p1_ ON p0_.logo_sd_media_id = p1_.id INNER JOIN "prf__file__media" p2_ ON p0_.logo_sd_bw_media_id = p2_.id WHERE p0_.enabled = true ORDER BY p0_."order_position" ASC;

#	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->getResult (line 688)
6	App\Repository\Universe\UniverseRepository->findAllEnabledAndOrdered (line 37)
7	App\Twig\Extension\TwigGlobalDataExtension->getEnabledUniverses (line 26)
8	__TwigTemplate_274867467a674bbcccf9be919d295cbf->doDisplay (line 211)
9	Twig\Template->yield (line 402)
10	__TwigTemplate_6bb6db981e4e8a8a506b9bb3ee077804->doDisplay (line 53)
11	Twig\Template->yield (line 402)
12	Twig\Template->display (line 358)
13	Twig\Template->render (line 373)
14	Twig\TemplateWrapper->render (line 51)
15	Twig\Environment->render (line 333)
16	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 467)
17	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 472)
18	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 284)
19	App\Controller\Front\Home->__invoke (line 20)
20	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
21	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
22	Symfony\Component\HttpKernel\Kernel->handle (line 193)
23	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
24	require_once (line 32)
25	require_once (line 5)

0.55 ms

SELECT p0_.original_name AS original_name_0, p0_.acronym AS acronym_1, p0_.type AS type_2, p0_.morph_call AS morph_call_3, p0_.story AS story_4, p0_.slide_title AS slide_title_5, p0_.slide_content AS slide_content_6, p0_.copyright AS copyright_7, p0_.id AS id_8, p0_.legacy_id AS legacy_id_9, p0_.legacy_table AS legacy_table_10, p0_.legacy_remaining_data AS legacy_remaining_data_11, p0_.created_at AS created_at_12, p0_.updated_at AS updated_at_13, p0_.enabled AS enabled_14, p0_.name AS name_15, p0_.slug AS slug_16, p0_."order_position" AS order_position_17, p0_.logo_sd_media_id AS logo_sd_media_id_18, p0_.logo_sd_bw_media_id AS logo_sd_bw_media_id_19, p0_.logo_media_id AS logo_media_id_20, p0_.prequel_universe_id AS prequel_universe_id_21, p0_.slide_background_id AS slide_background_id_22 FROM "prf__universe__universe" p0_ ORDER BY p0_."order_position" ASC

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  p0_.original_name AS original_name_0,
  p0_.acronym AS acronym_1,
  p0_.type AS type_2,
  p0_.morph_call AS morph_call_3,
  p0_.story AS story_4,
  p0_.slide_title AS slide_title_5,
  p0_.slide_content AS slide_content_6,
  p0_.copyright AS copyright_7,
  p0_.id AS id_8,
  p0_.legacy_id AS legacy_id_9,
  p0_.legacy_table AS legacy_table_10,
  p0_.legacy_remaining_data AS legacy_remaining_data_11,
  p0_.created_at AS created_at_12,
  p0_.updated_at AS updated_at_13,
  p0_.enabled AS enabled_14,
  p0_.name AS name_15,
  p0_.slug AS slug_16,
  p0_."order_position" AS order_position_17,
  p0_.logo_sd_media_id AS logo_sd_media_id_18,
  p0_.logo_sd_bw_media_id AS logo_sd_bw_media_id_19,
  p0_.logo_media_id AS logo_media_id_20,
  p0_.prequel_universe_id AS prequel_universe_id_21,
  p0_.slide_background_id AS slide_background_id_22
FROM
  "prf__universe__universe" p0_
ORDER BY
  p0_."order_position" ASC

SELECT p0_.original_name AS original_name_0, p0_.acronym AS acronym_1, p0_.type AS type_2, p0_.morph_call AS morph_call_3, p0_.story AS story_4, p0_.slide_title AS slide_title_5, p0_.slide_content AS slide_content_6, p0_.copyright AS copyright_7, p0_.id AS id_8, p0_.legacy_id AS legacy_id_9, p0_.legacy_table AS legacy_table_10, p0_.legacy_remaining_data AS legacy_remaining_data_11, p0_.created_at AS created_at_12, p0_.updated_at AS updated_at_13, p0_.enabled AS enabled_14, p0_.name AS name_15, p0_.slug AS slug_16, p0_."order_position" AS order_position_17, p0_.logo_sd_media_id AS logo_sd_media_id_18, p0_.logo_sd_bw_media_id AS logo_sd_bw_media_id_19, p0_.logo_media_id AS logo_media_id_20, p0_.prequel_universe_id AS prequel_universe_id_21, p0_.slide_background_id AS slide_background_id_22 FROM "prf__universe__universe" p0_ ORDER BY p0_."order_position" ASC;

#	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->getResult (line 688)
6	App\Repository\Universe\UniverseRepository->findAllOrdered (line 25)
7	__TwigTemplate_274867467a674bbcccf9be919d295cbf->doDisplay (line 277)
8	Twig\Template->yield (line 402)
9	__TwigTemplate_6bb6db981e4e8a8a506b9bb3ee077804->doDisplay (line 53)
10	Twig\Template->yield (line 402)
11	Twig\Template->display (line 358)
12	Twig\Template->render (line 373)
13	Twig\TemplateWrapper->render (line 51)
14	Twig\Environment->render (line 333)
15	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 467)
16	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 472)
17	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 284)
18	App\Controller\Front\Home->__invoke (line 20)
19	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
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 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\Display\Slide	No errors.
App\Entity\Universe\Universe	No errors.
Vich\UploaderBundle\Entity\File	No errors.
App\Entity\File\Media	No errors.

Symfony Profiler

GET https://thunder.prf.la-ranger-house.ovh/

Configuration Settings

Theme

Page Width

Query Metrics

Queries

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping