Query Metrics
51
Database Queries
11
Different statements
33.19 ms
Query time
2
Invalid entities
601
Managed entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
12.45 ms (37.51%) |
23 |
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:
[
"019e4f8d-e4bd-7226-844a-e5676f4af17a"
]
|
||||||||||||||||||||||||||||
|
8.10 ms (24.42%) |
19 |
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:
[
"019e4f8f-8c30-749f-aec7-3c0fefc0ee34"
]
|
||||||||||||||||||||||||||||
|
2.19 ms (6.61%) |
1 |
SELECT p0_.type AS type_0, p0_.sub_type AS sub_type_1, p0_.support AS support_2, p0_.release_zone AS release_zone_3, p0_.released_at AS released_at_4, p0_.usa_released_at AS usa_released_at_5, p0_.audio_language AS audio_language_6, p0_.subtitle_language AS subtitle_language_7, p0_.pages AS pages_8, p0_.collectibles AS collectibles_9, p0_.content AS content_10, p0_.bonus AS bonus_11, p0_.id AS id_12, p0_.legacy_id AS legacy_id_13, p0_.legacy_table AS legacy_table_14, p0_.legacy_remaining_data AS legacy_remaining_data_15, p0_.created_at AS created_at_16, p0_.updated_at AS updated_at_17, p0_.name AS name_18, p0_.slug AS slug_19, p0_."order_position" AS order_position_20, p0_.universe_id AS universe_id_21, p0_.editor_staff_id AS editor_staff_id_22, p0_.front_cover_id AS front_cover_id_23, p0_.usa_front_cover_id AS usa_front_cover_id_24, p0_.back_cover_id AS back_cover_id_25, p0_.usa_back_cover_id AS usa_back_cover_id_26, p0_.full_cover_id AS full_cover_id_27, p0_.release_support_id AS release_support_id_28, p0_.usa_release_support_id AS usa_release_support_id_29, p0_.booklet_id AS booklet_id_30, p0_.usa_booklet_id AS usa_booklet_id_31 FROM "prf__universe__extra" p0_ INNER JOIN "prf__universe__universe" p1_ ON p0_.universe_id = p1_.id WHERE p0_.type = ? AND p0_.slug = ? AND p1_.slug = ? LIMIT 1
Parameters:
[ "manufacturer" "power-rangers-lightning-collection" "power-rangers-dans-l-espace" ] |
||||||||||||||||||||||||||||
|
1.63 ms (4.92%) |
1 |
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:
[] |
||||||||||||||||||||||||||||
|
1.61 ms (4.85%) |
1 |
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:
[] |
||||||||||||||||||||||||||||
|
1.55 ms (4.66%) |
1 |
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_ WHERE p0_.slug = ? LIMIT 1
Parameters:
[
"power-rangers-dans-l-espace"
]
|
||||||||||||||||||||||||||||
|
1.46 ms (4.41%) |
1 |
SELECT t0.distinct_order AS distinct_order_1, t0.type AS type_2, t0.first_name AS first_name_3, t0.last_name AS last_name_4, t0.ranger_name AS ranger_name_5, t0.story AS story_6, t0.color AS color_7, t0.extra AS extra_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.name AS name_15, t0.slug AS slug_16, t0.universe_id AS universe_id_17, t0.character_life_id AS character_life_id_18, t0.character_group_id AS character_group_id_19, t0.character_sub_group_id AS character_sub_group_id_20, t0.avatar_media_id AS avatar_media_id_21 FROM "prf__universe__character" t0 WHERE t0.universe_id = ? ORDER BY t0.name ASC
Parameters:
[
"019e4f8d-e4bd-7226-844a-e5676f4af17a"
]
|
||||||||||||||||||||||||||||
|
1.31 ms (3.96%) |
1 |
SELECT t0.description AS description_1, t0.id AS id_2, t0.legacy_id AS legacy_id_3, t0.legacy_table AS legacy_table_4, t0.legacy_remaining_data AS legacy_remaining_data_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.name AS name_8, t0.slug AS slug_9, t0.universe_id AS universe_id_10, t0.weapon_group_id AS weapon_group_id_11, t0.groupment_weapon_id AS groupment_weapon_id_12, t0.avatar_media_id AS avatar_media_id_13 FROM "prf__universe__weapon" t0 WHERE t0.universe_id = ? ORDER BY t0.name ASC
Parameters:
[
"019e4f8d-e4bd-7226-844a-e5676f4af17a"
]
|
||||||||||||||||||||||||||||
|
1.12 ms (3.36%) |
1 |
SELECT t0.number AS number_1, t0.face AS face_2, t0.reference AS reference_3, t0.type AS type_4, t0.title AS title_5, t0.year AS year_6, t0.is_fra_eur_released AS is_fra_eur_released_7, t0.is_usa_released AS is_usa_released_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.extra_id AS extra_id_15, t0.universe_id AS universe_id_16, t0.parent_id AS parent_id_17, t0.episode_id AS episode_id_18, t0.cover_media_id AS cover_media_id_19, t0.media_id AS media_id_20, t0.content_id AS content_id_21 FROM "prf__universe__extra_content" t0 WHERE t0.extra_id = ? ORDER BY t0.face ASC, t0.number ASC
Parameters:
[
"019f6b83-20aa-7e2e-b44d-9c0e3027e98a"
]
|
||||||||||||||||||||||||||||
|
1.09 ms (3.27%) |
1 |
SELECT t0.full_number AS full_number_1, t0.season_number AS season_number_2, t0.episode_number AS episode_number_3, t0.part_number AS part_number_4, t0.title AS title_5, t0.title_slug AS title_slug_6, t0.original_title AS original_title_7, t0.french_first_broadcasted_at AS french_first_broadcasted_at_8, t0.world_first_broadcasted_at AS world_first_broadcasted_at_9, t0.story AS story_10, t0.based_on AS based_on_11, t0.id AS id_12, t0.legacy_id AS legacy_id_13, t0.legacy_table AS legacy_table_14, t0.legacy_remaining_data AS legacy_remaining_data_15, t0.created_at AS created_at_16, t0.updated_at AS updated_at_17, t0.universe_id AS universe_id_18, t0.parent_episode_id AS parent_episode_id_19, t0.avatar_media_id AS avatar_media_id_20 FROM "prf__universe__episode" t0 WHERE t0.universe_id = ? ORDER BY t0.full_number ASC
Parameters:
[
"019e4f8d-e4bd-7226-844a-e5676f4af17a"
]
|
||||||||||||||||||||||||||||
|
0.68 ms (2.04%) |
1 |
SELECT t0.id AS id_1, t0.legacy_id AS legacy_id_2, t0.legacy_table AS legacy_table_3, t0.legacy_remaining_data AS legacy_remaining_data_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.name AS name_7, t0.slug AS slug_8, t0."order_position" AS order_position_9, t0.universe_id AS universe_id_10, t0.avatar_media_id AS avatar_media_id_11 FROM "prf__universe__zord_group" t0 WHERE t0.universe_id = ? ORDER BY t0."order_position" ASC
Parameters:
[
"019e4f8d-e4bd-7226-844a-e5676f4af17a"
]
|
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 | 313 |
| App\Entity\Universe\Character | 109 |
| App\Entity\Universe\Weapon | 52 |
| App\Entity\Universe\Episode | 43 |
| App\Entity\Universe\Universe | 23 |
| App\Entity\Universe\ExtraContent | 16 |
| App\Entity\Universe\CharacterSubGroup | 16 |
| App\Entity\Universe\CharacterGroup | 15 |
| App\Entity\Universe\WeaponGroup | 9 |
| App\Entity\Universe\ZordGroup | 4 |
| App\Entity\Universe\Extra | 1 |