14.97 ms
(40.22%)
|
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"
]
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 = '019e4f8d-ba46-71ec-883f-2cb852c50571';
|
3.92 ms
(10.53%)
|
9 |
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-7721-70bd-9fb1-80dfa7b0949d"
]
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 = '019e4f8f-7721-70bd-9fb1-80dfa7b0949d';
|
3.15 ms
(8.46%)
|
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-c206-7137-a832-c2b6e0d06046"
]
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 = '019e4f8d-c206-7137-a832-c2b6e0d06046' ORDER BY t0.name ASC;
|
2.31 ms
(6.20%)
|
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"
]
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
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 = 'power-rangers' LIMIT 1;
|
1.79 ms
(4.81%)
|
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
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;
|
1.63 ms
(4.37%)
|
1 |
SELECT p0_.full_number AS full_number_0, p0_.season_number AS season_number_1, p0_.episode_number AS episode_number_2, p0_.part_number AS part_number_3, p0_.title AS title_4, p0_.title_slug AS title_slug_5, p0_.original_title AS original_title_6, p0_.french_first_broadcasted_at AS french_first_broadcasted_at_7, p0_.world_first_broadcasted_at AS world_first_broadcasted_at_8, p0_.story AS story_9, p0_.based_on AS based_on_10, p0_.id AS id_11, p0_.legacy_id AS legacy_id_12, p0_.legacy_table AS legacy_table_13, p0_.legacy_remaining_data AS legacy_remaining_data_14, p0_.created_at AS created_at_15, p0_.updated_at AS updated_at_16, p0_.universe_id AS universe_id_17, p0_.parent_episode_id AS parent_episode_id_18, p0_.avatar_media_id AS avatar_media_id_19 FROM "prf__universe__episode" p0_ INNER JOIN "prf__universe__universe" p1_ ON p0_.universe_id = p1_.id WHERE p1_.slug = ? AND p0_.season_number = ? AND p0_.episode_number = ? LIMIT 1
Parameters: [
"power-rangers"
1
60
]
SELECT p0_.full_number AS full_number_0, p0_.season_number AS season_number_1, p0_.episode_number AS episode_number_2, p0_.part_number AS part_number_3, p0_.title AS title_4, p0_.title_slug AS title_slug_5, p0_.original_title AS original_title_6, p0_.french_first_broadcasted_at AS french_first_broadcasted_at_7, p0_.world_first_broadcasted_at AS world_first_broadcasted_at_8, p0_.story AS story_9, p0_.based_on AS based_on_10, p0_.id AS id_11, p0_.legacy_id AS legacy_id_12, p0_.legacy_table AS legacy_table_13, p0_.legacy_remaining_data AS legacy_remaining_data_14, p0_.created_at AS created_at_15, p0_.updated_at AS updated_at_16, p0_.universe_id AS universe_id_17, p0_.parent_episode_id AS parent_episode_id_18, p0_.avatar_media_id AS avatar_media_id_19 FROM "prf__universe__episode" p0_ INNER JOIN "prf__universe__universe" p1_ ON p0_.universe_id = p1_.id WHERE p1_.slug = 'power-rangers' AND p0_.season_number = 1 AND p0_.episode_number = 60 LIMIT 1;
|
1.53 ms
(4.12%)
|
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
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;
|
1.50 ms
(4.04%)
|
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-c206-7137-a832-c2b6e0d06046"
]
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 = '019e4f8d-c206-7137-a832-c2b6e0d06046' ORDER BY t0.name ASC;
|
1.33 ms
(3.58%)
|
3 |
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 FROM "prf__universe__staff" t0 WHERE t0.id = ?
Parameters: [
"019e4fca-a095-7b6a-b30a-31ba0631fc85"
]
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 FROM "prf__universe__staff" t0 WHERE t0.id = '019e4fca-a095-7b6a-b30a-31ba0631fc85';
|
1.32 ms
(3.56%)
|
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-c206-7137-a832-c2b6e0d06046"
]
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 = '019e4f8d-c206-7137-a832-c2b6e0d06046' ORDER BY t0."order_position" ASC;
|
1.15 ms
(3.10%)
|
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-c206-7137-a832-c2b6e0d06046"
]
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 = '019e4f8d-c206-7137-a832-c2b6e0d06046' ORDER BY t0.full_number ASC;
|
0.64 ms
(1.72%)
|
1 |
SELECT t0.story AS story_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."order_position" AS order_position_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.episode_id AS episode_id_9, t0.avatar_media_id AS avatar_media_id_10 FROM "prf__universe__episode_story" t0 WHERE t0.episode_id = ? ORDER BY t0."order_position" ASC
Parameters: [
"019e4fcc-5ca9-7685-a648-f0741bd9a0f6"
]
SELECT t0.story AS story_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."order_position" AS order_position_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.episode_id AS episode_id_9, t0.avatar_media_id AS avatar_media_id_10 FROM "prf__universe__episode_story" t0 WHERE t0.episode_id = '019e4fcc-5ca9-7685-a648-f0741bd9a0f6' ORDER BY t0."order_position" ASC;
|
0.63 ms
(1.68%)
|
1 |
SELECT t0.character_name AS character_name_1, t0.type AS type_2, t0.type_name AS type_name_3, t0.id AS id_4, t0.legacy_id AS legacy_id_5, t0.legacy_table AS legacy_table_6, t0.legacy_remaining_data AS legacy_remaining_data_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.episode_id AS episode_id_10, t0.staff_id AS staff_id_11, t0.character_id AS character_id_12 FROM "prf__universe__episode_staff" t0 WHERE t0.episode_id = ?
Parameters: [
"019e4fcc-5ca9-7685-a648-f0741bd9a0f6"
]
SELECT t0.character_name AS character_name_1, t0.type AS type_2, t0.type_name AS type_name_3, t0.id AS id_4, t0.legacy_id AS legacy_id_5, t0.legacy_table AS legacy_table_6, t0.legacy_remaining_data AS legacy_remaining_data_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.episode_id AS episode_id_10, t0.staff_id AS staff_id_11, t0.character_id AS character_id_12 FROM "prf__universe__episode_staff" t0 WHERE t0.episode_id = '019e4fcc-5ca9-7685-a648-f0741bd9a0f6';
|
0.56 ms
(1.51%)
|
1 |
SELECT t0.type AS type_1, t0.note AS note_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.episode_id AS episode_id_9 FROM "prf__universe__episode_note" t0 WHERE t0.episode_id = ?
Parameters: [
"019e4fcc-5ca9-7685-a648-f0741bd9a0f6"
]
SELECT t0.type AS type_1, t0.note AS note_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.episode_id AS episode_id_9 FROM "prf__universe__episode_note" t0 WHERE t0.episode_id = '019e4fcc-5ca9-7685-a648-f0741bd9a0f6';
|
0.48 ms
(1.28%)
|
1 |
SELECT t0.type AS type_1, t0.id AS id_2, t0.previous_episode_id AS previous_episode_id_3, t0.next_episode_id AS next_episode_id_4 FROM prf__universe__episode_chronology t0 WHERE t0.next_episode_id = ?
Parameters: [
"019e4fcc-5ca9-7685-a648-f0741bd9a0f6"
]
SELECT t0.type AS type_1, t0.id AS id_2, t0.previous_episode_id AS previous_episode_id_3, t0.next_episode_id AS next_episode_id_4 FROM prf__universe__episode_chronology t0 WHERE t0.next_episode_id = '019e4fcc-5ca9-7685-a648-f0741bd9a0f6';
|
0.30 ms
(0.81%)
|
1 |
SELECT t0.type AS type_1, t0.id AS id_2, t0.previous_episode_id AS previous_episode_id_3, t0.next_episode_id AS next_episode_id_4 FROM prf__universe__episode_chronology t0 WHERE t0.previous_episode_id = ?
Parameters: [
"019e4fcc-5ca9-7685-a648-f0741bd9a0f6"
]
SELECT t0.type AS type_1, t0.id AS id_2, t0.previous_episode_id AS previous_episode_id_3, t0.next_episode_id AS next_episode_id_4 FROM prf__universe__episode_chronology t0 WHERE t0.previous_episode_id = '019e4fcc-5ca9-7685-a648-f0741bd9a0f6';
|