Symfony Profiler

Query Metrics

47 Database Queries

2 Different statements

17.37 ms Query time

0 Invalid entities

111 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

14.99 ms
(86.26%)

SELECT t0.checksum AS checksum_1, t0.legacy_uri AS legacy_uri_2, t0.id AS id_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.file_metadata_name AS file_metadata_name_6, t0.file_metadata_original_name AS file_metadata_original_name_7, t0.file_metadata_mime_type AS file_metadata_mime_type_8, t0.file_metadata_size AS file_metadata_size_9, t0.file_metadata_dimensions AS file_metadata_dimensions_10 FROM "prf__file__media" t0 WHERE t0.id = ?

Parameters:

[
  "019ddb72-3256-761f-ad30-0fbb7f197604"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.checksum AS checksum_1,
  t0.legacy_uri AS legacy_uri_2,
  t0.id AS id_3,
  t0.created_at AS created_at_4,
  t0.updated_at AS updated_at_5,
  t0.file_metadata_name AS file_metadata_name_6,
  t0.file_metadata_original_name AS file_metadata_original_name_7,
  t0.file_metadata_mime_type AS file_metadata_mime_type_8,
  t0.file_metadata_size AS file_metadata_size_9,
  t0.file_metadata_dimensions AS file_metadata_dimensions_10
FROM
  "prf__file__media" t0
WHERE
  t0.id = ?

SELECT t0.checksum AS checksum_1, t0.legacy_uri AS legacy_uri_2, t0.id AS id_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.file_metadata_name AS file_metadata_name_6, t0.file_metadata_original_name AS file_metadata_original_name_7, t0.file_metadata_mime_type AS file_metadata_mime_type_8, t0.file_metadata_size AS file_metadata_size_9, t0.file_metadata_dimensions AS file_metadata_dimensions_10 FROM "prf__file__media" t0 WHERE t0.id = '019ddb72-3256-761f-ad30-0fbb7f197604';

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 738)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 756)
3	Doctrine\ORM\Proxy\ProxyFactory->{closure:Doctrine\ORM\Proxy\ProxyFactory::getProxy():217} (line 223)
4	Symfony\Component\PropertyAccess\PropertyAccessor::readProperty (line 417)
5	Symfony\Component\PropertyAccess\PropertyAccessor->readPropertiesUntil (line 323)
6	Symfony\Component\PropertyAccess\PropertyAccessor->getValue (line 107)
7	Vich\UploaderBundle\Mapping\PropertyMapping->readProperty (line 152)
8	Vich\UploaderBundle\Mapping\PropertyMapping->getFileName (line 94)
9	Vich\UploaderBundle\Storage\AbstractStorage->getFilename (line 154)
10	Vich\UploaderBundle\Storage\AbstractStorage->resolveUri (line 105)
11	Vich\UploaderBundle\Storage\FlysystemStorage->resolveUri (line 85)
12	App\Serializer\Api\File\MediaNormalizer->normalize (line 24)
13	Symfony\Component\Serializer\Debug\TraceableNormalizer->normalize (line 50)
14	Symfony\Component\Serializer\Serializer->normalize (line 152)
15	Symfony\Component\Serializer\Normalizer\AbstractObjectNormalizer->normalize (line 229)
16	Symfony\Component\Serializer\Debug\TraceableNormalizer->normalize (line 50)
17	Symfony\Component\Serializer\Serializer->normalize (line 152)
18	Symfony\Component\Serializer\Serializer->normalize (line 170)
19	Symfony\Component\Serializer\Serializer->serialize (line 131)
20	Symfony\Component\Serializer\Debug\TraceableSerializer->serialize (line 44)
21	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->json (line 153)
22	App\Controller\Api\Universe\Universe\GetAll->__invoke (line 36)
23	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
24	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
25	Symfony\Component\HttpKernel\Kernel->handle (line 193)
26	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
27	require_once (line 32)
28	require_once (line 5)

2.39 ms
(13.74%)

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

Parameters:

[]

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

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;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 963)
2	Doctrine\ORM\EntityRepository->findBy (line 110)
3	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepository->findBy (line 78)
4	Doctrine\ORM\EntityRepository->findAll (line 96)
5	App\Controller\Api\Universe\Universe\GetAll->__invoke (line 37)
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 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	88
App\Entity\Universe\Universe	23

Entities Mapping

Class	Mapping 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\Display\Slide	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/universe/universes

Configuration Settings

Theme

Page Width