Symfony Profiler

Query Metrics

19 Database Queries

2 Different statements

13.59 ms Query time

0 Invalid entities

128 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

10.46 ms
(77.01%)

SELECT t0.original_name AS original_name_1, t0.acronym AS acronym_2, t0.type AS type_3, t0.morph_call AS morph_call_4, t0.story AS story_5, t0.slide_title AS slide_title_6, t0.slide_content AS slide_content_7, t0.copyright AS copyright_8, t0.id AS id_9, t0.legacy_id AS legacy_id_10, t0.legacy_table AS legacy_table_11, t0.legacy_remaining_data AS legacy_remaining_data_12, t0.created_at AS created_at_13, t0.updated_at AS updated_at_14, t0.enabled AS enabled_15, t0.name AS name_16, t0.slug AS slug_17, t0."order_position" AS order_position_18, t0.logo_sd_media_id AS logo_sd_media_id_19, t0.logo_sd_bw_media_id AS logo_sd_bw_media_id_20, t0.logo_media_id AS logo_media_id_21, t0.prequel_universe_id AS prequel_universe_id_22, t23.original_name AS original_name_24, t23.acronym AS acronym_25, t23.type AS type_26, t23.morph_call AS morph_call_27, t23.story AS story_28, t23.slide_title AS slide_title_29, t23.slide_content AS slide_content_30, t23.copyright AS copyright_31, t23.id AS id_32, t23.legacy_id AS legacy_id_33, t23.legacy_table AS legacy_table_34, t23.legacy_remaining_data AS legacy_remaining_data_35, t23.created_at AS created_at_36, t23.updated_at AS updated_at_37, t23.enabled AS enabled_38, t23.name AS name_39, t23.slug AS slug_40, t23."order_position" AS order_position_41, t23.logo_sd_media_id AS logo_sd_media_id_42, t23.logo_sd_bw_media_id AS logo_sd_bw_media_id_43, t23.logo_media_id AS logo_media_id_44, t23.prequel_universe_id AS prequel_universe_id_45, t23.slide_background_id AS slide_background_id_46, t0.slide_background_id AS slide_background_id_47 FROM "prf__universe__universe" t0 LEFT JOIN "prf__universe__universe" t23 ON t23.prequel_universe_id = t0.id WHERE t0.prequel_universe_id = ?

Parameters:

[
  "019ddb72-676c-788a-86bd-d2bc03c0bb60"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.original_name AS original_name_1,
  t0.acronym AS acronym_2,
  t0.type AS type_3,
  t0.morph_call AS morph_call_4,
  t0.story AS story_5,
  t0.slide_title AS slide_title_6,
  t0.slide_content AS slide_content_7,
  t0.copyright AS copyright_8,
  t0.id AS id_9,
  t0.legacy_id AS legacy_id_10,
  t0.legacy_table AS legacy_table_11,
  t0.legacy_remaining_data AS legacy_remaining_data_12,
  t0.created_at AS created_at_13,
  t0.updated_at AS updated_at_14,
  t0.enabled AS enabled_15,
  t0.name AS name_16,
  t0.slug AS slug_17,
  t0."order_position" AS order_position_18,
  t0.logo_sd_media_id AS logo_sd_media_id_19,
  t0.logo_sd_bw_media_id AS logo_sd_bw_media_id_20,
  t0.logo_media_id AS logo_media_id_21,
  t0.prequel_universe_id AS prequel_universe_id_22,
  t23.original_name AS original_name_24,
  t23.acronym AS acronym_25,
  t23.type AS type_26,
  t23.morph_call AS morph_call_27,
  t23.story AS story_28,
  t23.slide_title AS slide_title_29,
  t23.slide_content AS slide_content_30,
  t23.copyright AS copyright_31,
  t23.id AS id_32,
  t23.legacy_id AS legacy_id_33,
  t23.legacy_table AS legacy_table_34,
  t23.legacy_remaining_data AS legacy_remaining_data_35,
  t23.created_at AS created_at_36,
  t23.updated_at AS updated_at_37,
  t23.enabled AS enabled_38,
  t23.name AS name_39,
  t23.slug AS slug_40,
  t23."order_position" AS order_position_41,
  t23.logo_sd_media_id AS logo_sd_media_id_42,
  t23.logo_sd_bw_media_id AS logo_sd_bw_media_id_43,
  t23.logo_media_id AS logo_media_id_44,
  t23.prequel_universe_id AS prequel_universe_id_45,
  t23.slide_background_id AS slide_background_id_46,
  t0.slide_background_id AS slide_background_id_47
FROM
  "prf__universe__universe" t0
  LEFT JOIN "prf__universe__universe" t23 ON t23.prequel_universe_id = t0.id
WHERE
  t0.prequel_universe_id = ?

SELECT t0.original_name AS original_name_1, t0.acronym AS acronym_2, t0.type AS type_3, t0.morph_call AS morph_call_4, t0.story AS story_5, t0.slide_title AS slide_title_6, t0.slide_content AS slide_content_7, t0.copyright AS copyright_8, t0.id AS id_9, t0.legacy_id AS legacy_id_10, t0.legacy_table AS legacy_table_11, t0.legacy_remaining_data AS legacy_remaining_data_12, t0.created_at AS created_at_13, t0.updated_at AS updated_at_14, t0.enabled AS enabled_15, t0.name AS name_16, t0.slug AS slug_17, t0."order_position" AS order_position_18, t0.logo_sd_media_id AS logo_sd_media_id_19, t0.logo_sd_bw_media_id AS logo_sd_bw_media_id_20, t0.logo_media_id AS logo_media_id_21, t0.prequel_universe_id AS prequel_universe_id_22, t23.original_name AS original_name_24, t23.acronym AS acronym_25, t23.type AS type_26, t23.morph_call AS morph_call_27, t23.story AS story_28, t23.slide_title AS slide_title_29, t23.slide_content AS slide_content_30, t23.copyright AS copyright_31, t23.id AS id_32, t23.legacy_id AS legacy_id_33, t23.legacy_table AS legacy_table_34, t23.legacy_remaining_data AS legacy_remaining_data_35, t23.created_at AS created_at_36, t23.updated_at AS updated_at_37, t23.enabled AS enabled_38, t23.name AS name_39, t23.slug AS slug_40, t23."order_position" AS order_position_41, t23.logo_sd_media_id AS logo_sd_media_id_42, t23.logo_sd_bw_media_id AS logo_sd_bw_media_id_43, t23.logo_media_id AS logo_media_id_44, t23.prequel_universe_id AS prequel_universe_id_45, t23.slide_background_id AS slide_background_id_46, t0.slide_background_id AS slide_background_id_47 FROM "prf__universe__universe" t0 LEFT JOIN "prf__universe__universe" t23 ON t23.prequel_universe_id = t0.id WHERE t0.prequel_universe_id = '019ddb72-676c-788a-86bd-d2bc03c0bb60';

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 738)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToOneEntity (line 837)
3	Doctrine\ORM\UnitOfWork->createEntity (line 2458)
4	Doctrine\ORM\Internal\Hydration\ObjectHydrator->getEntity (line 268)
5	Doctrine\ORM\Internal\Hydration\ObjectHydrator->hydrateRowData (line 442)
6	Doctrine\ORM\Internal\Hydration\ObjectHydrator->hydrateAllData (line 147)
7	Doctrine\ORM\Internal\Hydration\AbstractHydrator->hydrateAll (line 176)
8	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 943)
9	Doctrine\ORM\AbstractQuery->execute (line 886)
10	Doctrine\ORM\AbstractQuery->getResult (line 688)
11	App\Repository\Display\SlideRepository->findAllOrdered (line 28)
12	App\Controller\Api\Display\Slide\GetAll->__invoke (line 37)
13	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
14	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
15	Symfony\Component\HttpKernel\Kernel->handle (line 193)
16	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
17	require_once (line 32)
18	require_once (line 5)

3.12 ms
(22.99%)

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 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
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 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->findAllOrdered (line 28)
7	App\Controller\Api\Display\Slide\GetAll->__invoke (line 37)
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)

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
App\Entity\File\Media	91
App\Entity\Display\Slide	19
App\Entity\Universe\Universe	18

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.
App\Entity\Universe\Character	No errors.
App\Entity\Universe\CharacterGroup	No errors.
App\Entity\Universe\CharacterSubGroup	No errors.
App\Entity\Universe\Weapon	No errors.
App\Entity\Universe\WeaponGroup	No errors.
App\Entity\Universe\Zord	No errors.
App\Entity\Universe\ZordGroup	No errors.
App\Entity\Universe\Megazord	No errors.
App\Entity\Universe\Episode	No errors.
App\Entity\Universe\UniverseStaff	No errors.
App\Entity\Universe\Extra	No errors.

Symfony Profiler

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

Configuration Settings

Theme

Page Width