Query Metrics
37
Database Queries
12
Different statements
27.89 ms
Query time
2
Invalid entities
602
Managed entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
12.13 ms (43.50%) |
22 |
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-ba46-71ec-883f-2cb852c50571"
]
|
||||||||||||||||||||||||||||
|
2.88 ms (10.32%) |
5 |
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-8e2c-7a77-a458-ea8875be74b2"
]
|
||||||||||||||||||||||||||||
|
2.11 ms (7.55%) |
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.87 ms (6.70%) |
1 |
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.slug = ? LIMIT 1
Parameters:
[
"power-rangers-l-autre-galaxie"
]
|
||||||||||||||||||||||||||||
|
1.44 ms (5.16%) |
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-e632-7b54-ba93-e3a32229e862"
]
|
||||||||||||||||||||||||||||
|
1.37 ms (4.91%) |
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.29 ms (4.63%) |
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.slug = ? LIMIT 1
Parameters:
[
"colby-prlag"
]
|
||||||||||||||||||||||||||||
|
1.08 ms (3.88%) |
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-e632-7b54-ba93-e3a32229e862"
]
|
||||||||||||||||||||||||||||
|
1.00 ms (3.57%) |
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__character_group" t0 WHERE t0.id = ?
Parameters:
[
"019e4f97-8455-76fd-a0b9-94d570f424c9"
]
|
||||||||||||||||||||||||||||
|
0.97 ms (3.47%) |
1 |
SELECT t0.caption AS caption_1, t0.type AS type_2, t0.id AS id_3, t0.legacy_id AS legacy_id_4, t0.legacy_table AS legacy_table_5, t0.legacy_remaining_data AS legacy_remaining_data_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.media_id AS media_id_9, t0.attack_id AS attack_id_10, t0.character_id AS character_id_11, t0.character_group_id AS character_group_id_12, t0.extra_id AS extra_id_13, t0.megazord_id AS megazord_id_14, t0.megazord_attack_id AS megazord_attack_id_15, t0.megazord_weapon_id AS megazord_weapon_id_16, t0.weapon_id AS weapon_id_17, t0.zord_id AS zord_id_18 FROM "prf__universe__picture" t0 WHERE t0.character_id = ?
Parameters:
[
"019e4f9e-2774-78d0-990f-510271756a5e"
]
|
||||||||||||||||||||||||||||
|
0.91 ms (3.27%) |
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-e632-7b54-ba93-e3a32229e862"
]
|
||||||||||||||||||||||||||||
|
0.85 ms (3.03%) |
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-e632-7b54-ba93-e3a32229e862"
]
|
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 | 312 |
| App\Entity\Universe\Character | 128 |
| App\Entity\Universe\Episode | 45 |
| App\Entity\Universe\Weapon | 43 |
| App\Entity\Universe\Universe | 23 |
| App\Entity\Universe\CharacterSubGroup | 20 |
| App\Entity\Universe\CharacterGroup | 16 |
| App\Entity\Universe\WeaponGroup | 8 |
| App\Entity\Universe\ZordGroup | 5 |
| App\Entity\Universe\Picture | 2 |