1 |
5.51 ms |
SELECT t0.name AS name_1, t0.slug AS slug_2, t0.customized_route AS customized_route_3, t0.customized_domain AS customized_domain_4, t0.iconify_code AS iconify_code_5, t0.id AS id_6, t0.api_id AS api_id_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.cover__sebii__file__media__id AS cover__sebii__file__media__id_10, t0.background__sebii__file__media__id AS background__sebii__file__media__id_11 FROM "sebii__category__universe" t0 WHERE t0.customized_domain = ? LIMIT 1
Parameters: [
"pokemon.sebii.dev"
]
SELECT t0.name AS name_1, t0.slug AS slug_2, t0.customized_route AS customized_route_3, t0.customized_domain AS customized_domain_4, t0.iconify_code AS iconify_code_5, t0.id AS id_6, t0.api_id AS api_id_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.cover__sebii__file__media__id AS cover__sebii__file__media__id_10, t0.background__sebii__file__media__id AS background__sebii__file__media__id_11 FROM "sebii__category__universe" t0 WHERE t0.customized_domain = 'pokemon.sebii.dev' LIMIT 1;
|
2 |
0.39 ms |
"START TRANSACTION"
"START TRANSACTION";
|
3 |
3.40 ms |
INSERT INTO sebii__messenger__message (body, headers, queue_name, created_at, available_at) VALUES(?, ?, ?, ?, ?) RETURNING id
Parameters: [
"O:36:\"Symfony\\Component\\Messenger\\Envelope\":2:{s:44:\"\0Symfony\\Component\\Messenger\\Envelope\0stamps\";a:1:{s:46:\"Symfony\\Component\\Messenger\\Stamp\\BusNameStamp\";a:1:{i:0;O:46:\"Symfony\\Component\\Messenger\\Stamp\\BusNameStamp\":1:{s:55:\"\0Symfony\\Component\\Messenger\\Stamp\\BusNameStamp\0busName\";s:21:\"messenger.bus.default\";}}}s:45:\"\0Symfony\\Component\\Messenger\\Envelope\0message\";O:46:\"App\\Messenger\\Message\\Security\\AnalyticMessage\":6:{s:50:\"\0App\\Messenger\\Message\\Security\\AnalyticMessage\0at\";O:8:\"DateTime\":3:{s:4:\"date\";s:26:\"2025-04-21 17:53:00.321848\";s:13:\"timezone_type\";i:3;s:8:\"timezone\";s:3:\"UTC\";}s:52:\"\0App\\Messenger\\Message\\Security\\AnalyticMessage\0page\";s:43:\"/video/018fe01e-c6c6-7860-b56b-40dcd0d8c45d\";s:54:\"\0App\\Messenger\\Message\\Security\\AnalyticMessage\0domain\";s:17:\"pokemon.sebii.dev\";s:57:\"\0App\\Messenger\\Message\\Security\\AnalyticMessage\0ipAddress\";s:10:\"172.19.0.1\";s:57:\"\0App\\Messenger\\Message\\Security\\AnalyticMessage\0userAgent\";s:103:\"Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)\";s:56:\"\0App\\Messenger\\Message\\Security\\AnalyticMessage\0referrer\";N;}}"
"[]"
"security_analytic"
"2025-04-21 17:53:00"
"2025-04-21 17:53:00"
]
INSERT INTO sebii__messenger__message (body, headers, queue_name, created_at, available_at) VALUES('O:36:\\\"Symfony\\\\Component\\\\Messenger\\\\Envelope\\\":2:{s:44:\\\"\\0Symfony\\\\Component\\\\Messenger\\\\Envelope\\0stamps\\\";a:1:{s:46:\\\"Symfony\\\\Component\\\\Messenger\\\\Stamp\\\\BusNameStamp\\\";a:1:{i:0;O:46:\\\"Symfony\\\\Component\\\\Messenger\\\\Stamp\\\\BusNameStamp\\\":1:{s:55:\\\"\\0Symfony\\\\Component\\\\Messenger\\\\Stamp\\\\BusNameStamp\\0busName\\\";s:21:\\\"messenger.bus.default\\\";}}}s:45:\\\"\\0Symfony\\\\Component\\\\Messenger\\\\Envelope\\0message\\\";O:46:\\\"App\\\\Messenger\\\\Message\\\\Security\\\\AnalyticMessage\\\":6:{s:50:\\\"\\0App\\\\Messenger\\\\Message\\\\Security\\\\AnalyticMessage\\0at\\\";O:8:\\\"DateTime\\\":3:{s:4:\\\"date\\\";s:26:\\\"2025-04-21 17:53:00.321848\\\";s:13:\\\"timezone_type\\\";i:3;s:8:\\\"timezone\\\";s:3:\\\"UTC\\\";}s:52:\\\"\\0App\\\\Messenger\\\\Message\\\\Security\\\\AnalyticMessage\\0page\\\";s:43:\\\"/video/018fe01e-c6c6-7860-b56b-40dcd0d8c45d\\\";s:54:\\\"\\0App\\\\Messenger\\\\Message\\\\Security\\\\AnalyticMessage\\0domain\\\";s:17:\\\"pokemon.sebii.dev\\\";s:57:\\\"\\0App\\\\Messenger\\\\Message\\\\Security\\\\AnalyticMessage\\0ipAddress\\\";s:10:\\\"172.19.0.1\\\";s:57:\\\"\\0App\\\\Messenger\\\\Message\\\\Security\\\\AnalyticMessage\\0userAgent\\\";s:103:\\\"Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)\\\";s:56:\\\"\\0App\\\\Messenger\\\\Message\\\\Security\\\\AnalyticMessage\\0referrer\\\";N;}}', '[]', 'security_analytic', '2025-04-21 17:53:00', '2025-04-21 17:53:00') RETURNING id;
|
4 |
6.79 ms |
"COMMIT"
|
5 |
2.04 ms |
SELECT t0.name AS name_1, t0.type AS type_2, t0.description AS description_3, t0.recorded_at AS recorded_at_4, t0.duration AS duration_5, t0.id AS id_6, t0.api_id AS api_id_7, t0.displayed AS displayed_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10, t0.thumbnail__sebii__file__media__id AS thumbnail__sebii__file__media__id_11 FROM "sebii__video__video" t0 WHERE t0.id = ?
Parameters: [
"018fe01e-c6c6-7860-b56b-40dcd0d8c45d"
]
SELECT t0.name AS name_1, t0.type AS type_2, t0.description AS description_3, t0.recorded_at AS recorded_at_4, t0.duration AS duration_5, t0.id AS id_6, t0.api_id AS api_id_7, t0.displayed AS displayed_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10, t0.thumbnail__sebii__file__media__id AS thumbnail__sebii__file__media__id_11 FROM "sebii__video__video" t0 WHERE t0.id = '018fe01e-c6c6-7860-b56b-40dcd0d8c45d';
|
6 |
4.78 ms |
SELECT s0_.name AS name_0, s0_.slug AS slug_1, s0_.first_recorded_at AS first_recorded_at_2, s0_.last_recorded_at AS last_recorded_at_3, s0_.video_type AS video_type_4, s0_.incomplete AS incomplete_5, s0_.status AS status_6, s0_.season AS season_7, s0_.part AS part_8, s0_.session AS session_9, s0_.dated_playlist AS dated_playlist_10, s0_.thumbnail_text_line1 AS thumbnail_text_line1_11, s0_.thumbnail_text_line1_size AS thumbnail_text_line1_size_12, s0_.thumbnail_text_line2 AS thumbnail_text_line2_13, s0_.thumbnail_text_line2_size AS thumbnail_text_line2_size_14, s0_.thumbnail_text_line3 AS thumbnail_text_line3_15, s0_.thumbnail_text_line3_size AS thumbnail_text_line3_size_16, s0_.thumbnail_text_line4 AS thumbnail_text_line4_17, s0_.thumbnail_text_line4_size AS thumbnail_text_line4_size_18, s0_.id AS id_19, s0_.api_id AS api_id_20, s0_.displayed AS displayed_21, s0_.created_at AS created_at_22, s0_.updated_at AS updated_at_23, RANDOM() AS sclr_24, s0_.parent__sebii__video__playlist__id AS parent__sebii__video__playlist__id_25, s0_.thumbnail__sebii__file__media__id AS thumbnail__sebii__file__media__id_26, s0_.thumbnail_foreground__sebii__file__media__id AS thumbnail_foreground__sebii__file__media__id_27, s0_.thumbnail_background__sebii__file__media__id AS thumbnail_background__sebii__file__media__id_28 FROM "sebii__video__playlist" s0_ WHERE s0_.displayed = true ORDER BY sclr_24 ASC LIMIT 3
SELECT s0_.name AS name_0, s0_.slug AS slug_1, s0_.first_recorded_at AS first_recorded_at_2, s0_.last_recorded_at AS last_recorded_at_3, s0_.video_type AS video_type_4, s0_.incomplete AS incomplete_5, s0_.status AS status_6, s0_.season AS season_7, s0_.part AS part_8, s0_.session AS session_9, s0_.dated_playlist AS dated_playlist_10, s0_.thumbnail_text_line1 AS thumbnail_text_line1_11, s0_.thumbnail_text_line1_size AS thumbnail_text_line1_size_12, s0_.thumbnail_text_line2 AS thumbnail_text_line2_13, s0_.thumbnail_text_line2_size AS thumbnail_text_line2_size_14, s0_.thumbnail_text_line3 AS thumbnail_text_line3_15, s0_.thumbnail_text_line3_size AS thumbnail_text_line3_size_16, s0_.thumbnail_text_line4 AS thumbnail_text_line4_17, s0_.thumbnail_text_line4_size AS thumbnail_text_line4_size_18, s0_.id AS id_19, s0_.api_id AS api_id_20, s0_.displayed AS displayed_21, s0_.created_at AS created_at_22, s0_.updated_at AS updated_at_23, RANDOM() AS sclr_24, s0_.parent__sebii__video__playlist__id AS parent__sebii__video__playlist__id_25, s0_.thumbnail__sebii__file__media__id AS thumbnail__sebii__file__media__id_26, s0_.thumbnail_foreground__sebii__file__media__id AS thumbnail_foreground__sebii__file__media__id_27, s0_.thumbnail_background__sebii__file__media__id AS thumbnail_background__sebii__file__media__id_28 FROM "sebii__video__playlist" s0_ WHERE s0_.displayed = true ORDER BY sclr_24 ASC LIMIT 3;
|
7 |
5.83 ms |
SELECT t0.name AS name_1, t0.invisible_complement_name AS invisible_complement_name_2, t0.slug AS slug_3, t0.type AS type_4, t0.is_compilation AS is_compilation_5, t0.first_released_at AS first_released_at_6, t0.id AS id_7, t0.api_id AS api_id_8, t0.displayed AS displayed_9, t0.created_at AS created_at_10, t0.updated_at AS updated_at_11, t0.cover__sebii__file__media__id AS cover__sebii__file__media__id_12, t0.background__sebii__file__media__id AS background__sebii__file__media__id_13 FROM "sebii__category__category" t0 INNER JOIN sebii__video__video_category ON t0.id = sebii__video__video_category.sebii__category__category__id WHERE sebii__video__video_category.sebii__video__video__id = ?
Parameters: [
"018fe01e-c6c6-7860-b56b-40dcd0d8c45d"
]
SELECT t0.name AS name_1, t0.invisible_complement_name AS invisible_complement_name_2, t0.slug AS slug_3, t0.type AS type_4, t0.is_compilation AS is_compilation_5, t0.first_released_at AS first_released_at_6, t0.id AS id_7, t0.api_id AS api_id_8, t0.displayed AS displayed_9, t0.created_at AS created_at_10, t0.updated_at AS updated_at_11, t0.cover__sebii__file__media__id AS cover__sebii__file__media__id_12, t0.background__sebii__file__media__id AS background__sebii__file__media__id_13 FROM "sebii__category__category" t0 INNER JOIN sebii__video__video_category ON t0.id = sebii__video__video_category.sebii__category__category__id WHERE sebii__video__video_category.sebii__video__video__id = '018fe01e-c6c6-7860-b56b-40dcd0d8c45d';
|
8 |
0.76 ms |
SELECT t0.name AS name_1, t0.slug AS slug_2, t0.customized_route AS customized_route_3, t0.customized_domain AS customized_domain_4, t0.iconify_code AS iconify_code_5, t0.id AS id_6, t0.api_id AS api_id_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.cover__sebii__file__media__id AS cover__sebii__file__media__id_10, t0.background__sebii__file__media__id AS background__sebii__file__media__id_11 FROM "sebii__category__universe" t0 WHERE t0.customized_domain = ? LIMIT 1
Parameters: [
"pokemon.sebii.dev"
]
SELECT t0.name AS name_1, t0.slug AS slug_2, t0.customized_route AS customized_route_3, t0.customized_domain AS customized_domain_4, t0.iconify_code AS iconify_code_5, t0.id AS id_6, t0.api_id AS api_id_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.cover__sebii__file__media__id AS cover__sebii__file__media__id_10, t0.background__sebii__file__media__id AS background__sebii__file__media__id_11 FROM "sebii__category__universe" t0 WHERE t0.customized_domain = 'pokemon.sebii.dev' LIMIT 1;
|
9 |
3.03 ms |
SELECT t0.service AS service_1, t0.identifier AS identifier_2, t0.part AS part_3, t0.default_source AS default_source_4, t0.duration AS duration_5, t0.view_count AS view_count_6, t0.like_count AS like_count_7, t0.dislike_count AS dislike_count_8, t0.favorite_count AS favorite_count_9, t0.comment_count AS comment_count_10, t0.id AS id_11, t0.api_id AS api_id_12, t0.displayed AS displayed_13, t0.created_at AS created_at_14, t0.updated_at AS updated_at_15, t0.sebii__video__video__id AS sebii__video__video__id_16, t0.sebii__video__source_channel__id AS sebii__video__source_channel__id_17 FROM "sebii__video__source" t0 WHERE t0.sebii__video__video__id = ? ORDER BY t0.service ASC, t0.part ASC
Parameters: [
"018fe01e-c6c6-7860-b56b-40dcd0d8c45d"
]
SELECT t0.service AS service_1, t0.identifier AS identifier_2, t0.part AS part_3, t0.default_source AS default_source_4, t0.duration AS duration_5, t0.view_count AS view_count_6, t0.like_count AS like_count_7, t0.dislike_count AS dislike_count_8, t0.favorite_count AS favorite_count_9, t0.comment_count AS comment_count_10, t0.id AS id_11, t0.api_id AS api_id_12, t0.displayed AS displayed_13, t0.created_at AS created_at_14, t0.updated_at AS updated_at_15, t0.sebii__video__video__id AS sebii__video__video__id_16, t0.sebii__video__source_channel__id AS sebii__video__source_channel__id_17 FROM "sebii__video__source" t0 WHERE t0.sebii__video__video__id = '018fe01e-c6c6-7860-b56b-40dcd0d8c45d' ORDER BY t0.service ASC, t0.part ASC;
|
10 |
1.78 ms |
SELECT t0.checksum AS checksum_1, t0.id AS id_2, t0.api_id AS api_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 "sebii__file__media" t0 WHERE t0.id = ?
Parameters: [
"018fe009-acbc-78df-a38d-a134f096ed4a"
]
SELECT t0.checksum AS checksum_1, t0.id AS id_2, t0.api_id AS api_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 "sebii__file__media" t0 WHERE t0.id = '018fe009-acbc-78df-a38d-a134f096ed4a';
|
11 |
3.46 ms |
SELECT t0.name AS name_1, t0.released_at AS released_at_2, t0.date_type AS date_type_3, t0.status AS status_4, t0.id AS id_5, t0.api_id AS api_id_6, t0.sebii__category__category__id AS sebii__category__category__id_7, t0.sebii__category__platform__id AS sebii__category__platform__id_8, t0.cover__sebii__file__media__id AS cover__sebii__file__media__id_9 FROM "sebii__category__release" t0 INNER JOIN sebii__video__video_release ON t0.id = sebii__video__video_release.sebii__category__release__id WHERE sebii__video__video_release.sebii__video__video__id = ?
Parameters: [
"018fe01e-c6c6-7860-b56b-40dcd0d8c45d"
]
SELECT t0.name AS name_1, t0.released_at AS released_at_2, t0.date_type AS date_type_3, t0.status AS status_4, t0.id AS id_5, t0.api_id AS api_id_6, t0.sebii__category__category__id AS sebii__category__category__id_7, t0.sebii__category__platform__id AS sebii__category__platform__id_8, t0.cover__sebii__file__media__id AS cover__sebii__file__media__id_9 FROM "sebii__category__release" t0 INNER JOIN sebii__video__video_release ON t0.id = sebii__video__video_release.sebii__category__release__id WHERE sebii__video__video_release.sebii__video__video__id = '018fe01e-c6c6-7860-b56b-40dcd0d8c45d';
|
12 |
2.14 ms |
SELECT t0.name AS name_1, t0.slug AS slug_2, t0.abbreviation AS abbreviation_3, t0.type AS type_4, t0.family AS family_5, t0.iconify_code AS iconify_code_6, t0.id AS id_7, t0.api_id AS api_id_8, t0.displayed AS displayed_9, t0.color AS color_10, t0.created_at AS created_at_11, t0.updated_at AS updated_at_12, t0.logo__sebii__file__media__id AS logo__sebii__file__media__id_13 FROM "sebii__category__platform" t0 WHERE t0.id = ?
Parameters: [
"019084f4-7647-792e-bb59-1de14ed6acb2"
]
SELECT t0.name AS name_1, t0.slug AS slug_2, t0.abbreviation AS abbreviation_3, t0.type AS type_4, t0.family AS family_5, t0.iconify_code AS iconify_code_6, t0.id AS id_7, t0.api_id AS api_id_8, t0.displayed AS displayed_9, t0.color AS color_10, t0.created_at AS created_at_11, t0.updated_at AS updated_at_12, t0.logo__sebii__file__media__id AS logo__sebii__file__media__id_13 FROM "sebii__category__platform" t0 WHERE t0.id = '019084f4-7647-792e-bb59-1de14ed6acb2';
|
13 |
2.21 ms |
SELECT t0.is_main AS is_main_1, t0.position AS position_2, t0.id AS id_3, t0.api_id AS api_id_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.sebii__video__playlist__id AS sebii__video__playlist__id_7, t0.sebii__video__video__id AS sebii__video__video__id_8 FROM "sebii__video__playlist_item" t0 WHERE t0.sebii__video__video__id = ?
Parameters: [
"018fe01e-c6c6-7860-b56b-40dcd0d8c45d"
]
SELECT t0.is_main AS is_main_1, t0.position AS position_2, t0.id AS id_3, t0.api_id AS api_id_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.sebii__video__playlist__id AS sebii__video__playlist__id_7, t0.sebii__video__video__id AS sebii__video__video__id_8 FROM "sebii__video__playlist_item" t0 WHERE t0.sebii__video__video__id = '018fe01e-c6c6-7860-b56b-40dcd0d8c45d';
|
14 |
0.87 ms |
SELECT t0.name AS name_1, t0.slug AS slug_2, t0.first_recorded_at AS first_recorded_at_3, t0.last_recorded_at AS last_recorded_at_4, t0.video_type AS video_type_5, t0.incomplete AS incomplete_6, t0.status AS status_7, t0.season AS season_8, t0.part AS part_9, t0.session AS session_10, t0.dated_playlist AS dated_playlist_11, t0.thumbnail_text_line1 AS thumbnail_text_line1_12, t0.thumbnail_text_line1_size AS thumbnail_text_line1_size_13, t0.thumbnail_text_line2 AS thumbnail_text_line2_14, t0.thumbnail_text_line2_size AS thumbnail_text_line2_size_15, t0.thumbnail_text_line3 AS thumbnail_text_line3_16, t0.thumbnail_text_line3_size AS thumbnail_text_line3_size_17, t0.thumbnail_text_line4 AS thumbnail_text_line4_18, t0.thumbnail_text_line4_size AS thumbnail_text_line4_size_19, t0.id AS id_20, t0.api_id AS api_id_21, t0.displayed AS displayed_22, t0.created_at AS created_at_23, t0.updated_at AS updated_at_24, t0.parent__sebii__video__playlist__id AS parent__sebii__video__playlist__id_25, t0.thumbnail__sebii__file__media__id AS thumbnail__sebii__file__media__id_26, t0.thumbnail_foreground__sebii__file__media__id AS thumbnail_foreground__sebii__file__media__id_27, t0.thumbnail_background__sebii__file__media__id AS thumbnail_background__sebii__file__media__id_28 FROM "sebii__video__playlist" t0 WHERE t0.id = ?
Parameters: [
"018fdffc-a712-7cdf-ab2f-7e1642cdda7c"
]
SELECT t0.name AS name_1, t0.slug AS slug_2, t0.first_recorded_at AS first_recorded_at_3, t0.last_recorded_at AS last_recorded_at_4, t0.video_type AS video_type_5, t0.incomplete AS incomplete_6, t0.status AS status_7, t0.season AS season_8, t0.part AS part_9, t0.session AS session_10, t0.dated_playlist AS dated_playlist_11, t0.thumbnail_text_line1 AS thumbnail_text_line1_12, t0.thumbnail_text_line1_size AS thumbnail_text_line1_size_13, t0.thumbnail_text_line2 AS thumbnail_text_line2_14, t0.thumbnail_text_line2_size AS thumbnail_text_line2_size_15, t0.thumbnail_text_line3 AS thumbnail_text_line3_16, t0.thumbnail_text_line3_size AS thumbnail_text_line3_size_17, t0.thumbnail_text_line4 AS thumbnail_text_line4_18, t0.thumbnail_text_line4_size AS thumbnail_text_line4_size_19, t0.id AS id_20, t0.api_id AS api_id_21, t0.displayed AS displayed_22, t0.created_at AS created_at_23, t0.updated_at AS updated_at_24, t0.parent__sebii__video__playlist__id AS parent__sebii__video__playlist__id_25, t0.thumbnail__sebii__file__media__id AS thumbnail__sebii__file__media__id_26, t0.thumbnail_foreground__sebii__file__media__id AS thumbnail_foreground__sebii__file__media__id_27, t0.thumbnail_background__sebii__file__media__id AS thumbnail_background__sebii__file__media__id_28 FROM "sebii__video__playlist" t0 WHERE t0.id = '018fdffc-a712-7cdf-ab2f-7e1642cdda7c';
|
15 |
1.73 ms |
SELECT t0.is_main AS is_main_1, t0.position AS position_2, t0.id AS id_3, t0.api_id AS api_id_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.sebii__video__playlist__id AS sebii__video__playlist__id_7, t0.sebii__video__video__id AS sebii__video__video__id_8 FROM "sebii__video__playlist_item" t0 WHERE t0.sebii__video__playlist__id = ? ORDER BY t0.position ASC
Parameters: [
"018fdffc-a712-7cdf-ab2f-7e1642cdda7c"
]
SELECT t0.is_main AS is_main_1, t0.position AS position_2, t0.id AS id_3, t0.api_id AS api_id_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.sebii__video__playlist__id AS sebii__video__playlist__id_7, t0.sebii__video__video__id AS sebii__video__video__id_8 FROM "sebii__video__playlist_item" t0 WHERE t0.sebii__video__playlist__id = '018fdffc-a712-7cdf-ab2f-7e1642cdda7c' ORDER BY t0.position ASC;
|
16 |
0.72 ms |
SELECT t0.checksum AS checksum_1, t0.id AS id_2, t0.api_id AS api_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 "sebii__file__media" t0 WHERE t0.id = ?
Parameters: [
"018fe01e-c6c8-7153-933e-2a51ed9ecf95"
]
SELECT t0.checksum AS checksum_1, t0.id AS id_2, t0.api_id AS api_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 "sebii__file__media" t0 WHERE t0.id = '018fe01e-c6c8-7153-933e-2a51ed9ecf95';
|
17 |
0.89 ms |
SELECT t0.name AS name_1, t0.type AS type_2, t0.description AS description_3, t0.recorded_at AS recorded_at_4, t0.duration AS duration_5, t0.id AS id_6, t0.api_id AS api_id_7, t0.displayed AS displayed_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10, t0.thumbnail__sebii__file__media__id AS thumbnail__sebii__file__media__id_11 FROM "sebii__video__video" t0 WHERE t0.id = ?
Parameters: [
"018fe01e-c6eb-7d0b-9d20-e2e15ce5c373"
]
SELECT t0.name AS name_1, t0.type AS type_2, t0.description AS description_3, t0.recorded_at AS recorded_at_4, t0.duration AS duration_5, t0.id AS id_6, t0.api_id AS api_id_7, t0.displayed AS displayed_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10, t0.thumbnail__sebii__file__media__id AS thumbnail__sebii__file__media__id_11 FROM "sebii__video__video" t0 WHERE t0.id = '018fe01e-c6eb-7d0b-9d20-e2e15ce5c373';
|
18 |
0.75 ms |
SELECT t0.checksum AS checksum_1, t0.id AS id_2, t0.api_id AS api_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 "sebii__file__media" t0 WHERE t0.id = ?
Parameters: [
"018fe01e-c6ed-7d15-87b9-6a2b6146e0e7"
]
SELECT t0.checksum AS checksum_1, t0.id AS id_2, t0.api_id AS api_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 "sebii__file__media" t0 WHERE t0.id = '018fe01e-c6ed-7d15-87b9-6a2b6146e0e7';
|
19 |
0.80 ms |
SELECT t0.name AS name_1, t0.type AS type_2, t0.description AS description_3, t0.recorded_at AS recorded_at_4, t0.duration AS duration_5, t0.id AS id_6, t0.api_id AS api_id_7, t0.displayed AS displayed_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10, t0.thumbnail__sebii__file__media__id AS thumbnail__sebii__file__media__id_11 FROM "sebii__video__video" t0 WHERE t0.id = ?
Parameters: [
"018fe01e-bd28-7303-90ef-c506e1411935"
]
SELECT t0.name AS name_1, t0.type AS type_2, t0.description AS description_3, t0.recorded_at AS recorded_at_4, t0.duration AS duration_5, t0.id AS id_6, t0.api_id AS api_id_7, t0.displayed AS displayed_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10, t0.thumbnail__sebii__file__media__id AS thumbnail__sebii__file__media__id_11 FROM "sebii__video__video" t0 WHERE t0.id = '018fe01e-bd28-7303-90ef-c506e1411935';
|
20 |
0.65 ms |
SELECT t0.checksum AS checksum_1, t0.id AS id_2, t0.api_id AS api_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 "sebii__file__media" t0 WHERE t0.id = ?
Parameters: [
"018fe01e-bd2a-7da8-a330-f65037ad290a"
]
SELECT t0.checksum AS checksum_1, t0.id AS id_2, t0.api_id AS api_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 "sebii__file__media" t0 WHERE t0.id = '018fe01e-bd2a-7da8-a330-f65037ad290a';
|
21 |
0.75 ms |
SELECT t0.name AS name_1, t0.type AS type_2, t0.description AS description_3, t0.recorded_at AS recorded_at_4, t0.duration AS duration_5, t0.id AS id_6, t0.api_id AS api_id_7, t0.displayed AS displayed_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10, t0.thumbnail__sebii__file__media__id AS thumbnail__sebii__file__media__id_11 FROM "sebii__video__video" t0 WHERE t0.id = ?
Parameters: [
"018fe01e-d22b-7476-ba06-e6edbbe5850e"
]
SELECT t0.name AS name_1, t0.type AS type_2, t0.description AS description_3, t0.recorded_at AS recorded_at_4, t0.duration AS duration_5, t0.id AS id_6, t0.api_id AS api_id_7, t0.displayed AS displayed_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10, t0.thumbnail__sebii__file__media__id AS thumbnail__sebii__file__media__id_11 FROM "sebii__video__video" t0 WHERE t0.id = '018fe01e-d22b-7476-ba06-e6edbbe5850e';
|
22 |
0.54 ms |
SELECT t0.checksum AS checksum_1, t0.id AS id_2, t0.api_id AS api_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 "sebii__file__media" t0 WHERE t0.id = ?
Parameters: [
"018fe01e-d22c-7cb9-9654-bc2d31dbd627"
]
SELECT t0.checksum AS checksum_1, t0.id AS id_2, t0.api_id AS api_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 "sebii__file__media" t0 WHERE t0.id = '018fe01e-d22c-7cb9-9654-bc2d31dbd627';
|
23 |
0.74 ms |
SELECT t0.name AS name_1, t0.type AS type_2, t0.description AS description_3, t0.recorded_at AS recorded_at_4, t0.duration AS duration_5, t0.id AS id_6, t0.api_id AS api_id_7, t0.displayed AS displayed_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10, t0.thumbnail__sebii__file__media__id AS thumbnail__sebii__file__media__id_11 FROM "sebii__video__video" t0 WHERE t0.id = ?
Parameters: [
"018fe01e-e632-79ca-8709-766a01696043"
]
SELECT t0.name AS name_1, t0.type AS type_2, t0.description AS description_3, t0.recorded_at AS recorded_at_4, t0.duration AS duration_5, t0.id AS id_6, t0.api_id AS api_id_7, t0.displayed AS displayed_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10, t0.thumbnail__sebii__file__media__id AS thumbnail__sebii__file__media__id_11 FROM "sebii__video__video" t0 WHERE t0.id = '018fe01e-e632-79ca-8709-766a01696043';
|
24 |
0.70 ms |
SELECT t0.checksum AS checksum_1, t0.id AS id_2, t0.api_id AS api_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 "sebii__file__media" t0 WHERE t0.id = ?
Parameters: [
"018fe01e-e638-7da7-a57f-b62cf8f50350"
]
SELECT t0.checksum AS checksum_1, t0.id AS id_2, t0.api_id AS api_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 "sebii__file__media" t0 WHERE t0.id = '018fe01e-e638-7da7-a57f-b62cf8f50350';
|
25 |
0.78 ms |
SELECT t0.name AS name_1, t0.type AS type_2, t0.description AS description_3, t0.recorded_at AS recorded_at_4, t0.duration AS duration_5, t0.id AS id_6, t0.api_id AS api_id_7, t0.displayed AS displayed_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10, t0.thumbnail__sebii__file__media__id AS thumbnail__sebii__file__media__id_11 FROM "sebii__video__video" t0 WHERE t0.id = ?
Parameters: [
"018fe01e-ea2d-7981-a99e-93bc317035d9"
]
SELECT t0.name AS name_1, t0.type AS type_2, t0.description AS description_3, t0.recorded_at AS recorded_at_4, t0.duration AS duration_5, t0.id AS id_6, t0.api_id AS api_id_7, t0.displayed AS displayed_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10, t0.thumbnail__sebii__file__media__id AS thumbnail__sebii__file__media__id_11 FROM "sebii__video__video" t0 WHERE t0.id = '018fe01e-ea2d-7981-a99e-93bc317035d9';
|
26 |
0.47 ms |
SELECT t0.checksum AS checksum_1, t0.id AS id_2, t0.api_id AS api_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 "sebii__file__media" t0 WHERE t0.id = ?
Parameters: [
"018fe01e-ea2f-7afc-9023-7297e5bd2611"
]
SELECT t0.checksum AS checksum_1, t0.id AS id_2, t0.api_id AS api_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 "sebii__file__media" t0 WHERE t0.id = '018fe01e-ea2f-7afc-9023-7297e5bd2611';
|
27 |
0.72 ms |
SELECT t0.name AS name_1, t0.type AS type_2, t0.description AS description_3, t0.recorded_at AS recorded_at_4, t0.duration AS duration_5, t0.id AS id_6, t0.api_id AS api_id_7, t0.displayed AS displayed_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10, t0.thumbnail__sebii__file__media__id AS thumbnail__sebii__file__media__id_11 FROM "sebii__video__video" t0 WHERE t0.id = ?
Parameters: [
"01938945-397c-79b0-baeb-d3160e75a84f"
]
SELECT t0.name AS name_1, t0.type AS type_2, t0.description AS description_3, t0.recorded_at AS recorded_at_4, t0.duration AS duration_5, t0.id AS id_6, t0.api_id AS api_id_7, t0.displayed AS displayed_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10, t0.thumbnail__sebii__file__media__id AS thumbnail__sebii__file__media__id_11 FROM "sebii__video__video" t0 WHERE t0.id = '01938945-397c-79b0-baeb-d3160e75a84f';
|
28 |
0.58 ms |
SELECT t0.checksum AS checksum_1, t0.id AS id_2, t0.api_id AS api_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 "sebii__file__media" t0 WHERE t0.id = ?
Parameters: [
"01938945-5191-79a4-805c-fbf4007b2397"
]
SELECT t0.checksum AS checksum_1, t0.id AS id_2, t0.api_id AS api_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 "sebii__file__media" t0 WHERE t0.id = '01938945-5191-79a4-805c-fbf4007b2397';
|
29 |
0.50 ms |
SELECT t0.name AS name_1, t0.type AS type_2, t0.description AS description_3, t0.recorded_at AS recorded_at_4, t0.duration AS duration_5, t0.id AS id_6, t0.api_id AS api_id_7, t0.displayed AS displayed_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10, t0.thumbnail__sebii__file__media__id AS thumbnail__sebii__file__media__id_11 FROM "sebii__video__video" t0 WHERE t0.id = ?
Parameters: [
"01938409-1d07-7226-907b-9028531f8214"
]
SELECT t0.name AS name_1, t0.type AS type_2, t0.description AS description_3, t0.recorded_at AS recorded_at_4, t0.duration AS duration_5, t0.id AS id_6, t0.api_id AS api_id_7, t0.displayed AS displayed_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10, t0.thumbnail__sebii__file__media__id AS thumbnail__sebii__file__media__id_11 FROM "sebii__video__video" t0 WHERE t0.id = '01938409-1d07-7226-907b-9028531f8214';
|
30 |
0.67 ms |
SELECT t0.checksum AS checksum_1, t0.id AS id_2, t0.api_id AS api_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 "sebii__file__media" t0 WHERE t0.id = ?
Parameters: [
"01938409-2ac1-76b9-b87c-58df33459036"
]
SELECT t0.checksum AS checksum_1, t0.id AS id_2, t0.api_id AS api_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 "sebii__file__media" t0 WHERE t0.id = '01938409-2ac1-76b9-b87c-58df33459036';
|
31 |
0.79 ms |
SELECT t0.is_main AS is_main_1, t0.position AS position_2, t0.id AS id_3, t0.api_id AS api_id_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.sebii__video__playlist__id AS sebii__video__playlist__id_7, t0.sebii__video__video__id AS sebii__video__video__id_8 FROM "sebii__video__playlist_item" t0 WHERE t0.sebii__video__playlist__id = ? ORDER BY t0.position ASC
Parameters: [
"019474e6-cab1-78e6-a031-16ccb02932cf"
]
SELECT t0.is_main AS is_main_1, t0.position AS position_2, t0.id AS id_3, t0.api_id AS api_id_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.sebii__video__playlist__id AS sebii__video__playlist__id_7, t0.sebii__video__video__id AS sebii__video__video__id_8 FROM "sebii__video__playlist_item" t0 WHERE t0.sebii__video__playlist__id = '019474e6-cab1-78e6-a031-16ccb02932cf' ORDER BY t0.position ASC;
|
32 |
0.77 ms |
SELECT t0.is_main AS is_main_1, t0.position AS position_2, t0.id AS id_3, t0.api_id AS api_id_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.sebii__video__playlist__id AS sebii__video__playlist__id_7, t0.sebii__video__video__id AS sebii__video__video__id_8 FROM "sebii__video__playlist_item" t0 WHERE t0.sebii__video__playlist__id = ? ORDER BY t0.position ASC
Parameters: [
"0193a756-160b-7106-a658-ca543758be23"
]
SELECT t0.is_main AS is_main_1, t0.position AS position_2, t0.id AS id_3, t0.api_id AS api_id_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.sebii__video__playlist__id AS sebii__video__playlist__id_7, t0.sebii__video__video__id AS sebii__video__video__id_8 FROM "sebii__video__playlist_item" t0 WHERE t0.sebii__video__playlist__id = '0193a756-160b-7106-a658-ca543758be23' ORDER BY t0.position ASC;
|
33 |
0.76 ms |
SELECT t0.is_main AS is_main_1, t0.position AS position_2, t0.id AS id_3, t0.api_id AS api_id_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.sebii__video__playlist__id AS sebii__video__playlist__id_7, t0.sebii__video__video__id AS sebii__video__video__id_8 FROM "sebii__video__playlist_item" t0 WHERE t0.sebii__video__playlist__id = ? ORDER BY t0.position ASC
Parameters: [
"018fdffc-9ebe-76e4-a33b-d1b830567a78"
]
SELECT t0.is_main AS is_main_1, t0.position AS position_2, t0.id AS id_3, t0.api_id AS api_id_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.sebii__video__playlist__id AS sebii__video__playlist__id_7, t0.sebii__video__video__id AS sebii__video__video__id_8 FROM "sebii__video__playlist_item" t0 WHERE t0.sebii__video__playlist__id = '018fdffc-9ebe-76e4-a33b-d1b830567a78' ORDER BY t0.position ASC;
|
34 |
0.70 ms |
SELECT t0.name AS name_1, t0.type AS type_2, t0.description AS description_3, t0.recorded_at AS recorded_at_4, t0.duration AS duration_5, t0.id AS id_6, t0.api_id AS api_id_7, t0.displayed AS displayed_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10, t0.thumbnail__sebii__file__media__id AS thumbnail__sebii__file__media__id_11 FROM "sebii__video__video" t0 WHERE t0.id = ?
Parameters: [
"018fe01e-ddab-7423-90f7-b2dfce95dd2d"
]
SELECT t0.name AS name_1, t0.type AS type_2, t0.description AS description_3, t0.recorded_at AS recorded_at_4, t0.duration AS duration_5, t0.id AS id_6, t0.api_id AS api_id_7, t0.displayed AS displayed_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10, t0.thumbnail__sebii__file__media__id AS thumbnail__sebii__file__media__id_11 FROM "sebii__video__video" t0 WHERE t0.id = '018fe01e-ddab-7423-90f7-b2dfce95dd2d';
|
35 |
0.50 ms |
SELECT t0.checksum AS checksum_1, t0.id AS id_2, t0.api_id AS api_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 "sebii__file__media" t0 WHERE t0.id = ?
Parameters: [
"0193a34d-39dd-7105-ac3a-a13011000c84"
]
SELECT t0.checksum AS checksum_1, t0.id AS id_2, t0.api_id AS api_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 "sebii__file__media" t0 WHERE t0.id = '0193a34d-39dd-7105-ac3a-a13011000c84';
|
36 |
1.43 ms |
SELECT s0_.type AS type_0, s0_.name AS name_1, s0_.url AS url_2, s0_.head_position AS head_position_3, s0_.id AS id_4, s0_.api_id AS api_id_5 FROM "sebii__social__item" s0_ WHERE s0_.head_position IS NOT NULL ORDER BY s0_.head_position ASC
SELECT s0_.type AS type_0, s0_.name AS name_1, s0_.url AS url_2, s0_.head_position AS head_position_3, s0_.id AS id_4, s0_.api_id AS api_id_5 FROM "sebii__social__item" s0_ WHERE s0_.head_position IS NOT NULL ORDER BY s0_.head_position ASC;
|
37 |
3.11 ms |
SELECT s0_.name AS name_0, s0_.slug AS slug_1, s0_.customized_route AS customized_route_2, s0_.customized_domain AS customized_domain_3, s0_.iconify_code AS iconify_code_4, s0_.id AS id_5, s0_.api_id AS api_id_6, s0_.created_at AS created_at_7, s0_.updated_at AS updated_at_8, s1_.name AS name_9, s1_.invisible_complement_name AS invisible_complement_name_10, s1_.slug AS slug_11, s1_.type AS type_12, s1_.is_compilation AS is_compilation_13, s1_.first_released_at AS first_released_at_14, s1_.id AS id_15, s1_.api_id AS api_id_16, s1_.displayed AS displayed_17, s1_.created_at AS created_at_18, s1_.updated_at AS updated_at_19, s0_.cover__sebii__file__media__id AS cover__sebii__file__media__id_20, s0_.background__sebii__file__media__id AS background__sebii__file__media__id_21, s1_.cover__sebii__file__media__id AS cover__sebii__file__media__id_22, s1_.background__sebii__file__media__id AS background__sebii__file__media__id_23 FROM "sebii__category__universe" s0_ LEFT JOIN sebii__category__category_universe s2_ ON s0_.id = s2_.sebii__category__universe__id LEFT JOIN "sebii__category__category" s1_ ON s1_.id = s2_.sebii__category__category__id ORDER BY s0_.name ASC, s1_.name ASC
SELECT s0_.name AS name_0, s0_.slug AS slug_1, s0_.customized_route AS customized_route_2, s0_.customized_domain AS customized_domain_3, s0_.iconify_code AS iconify_code_4, s0_.id AS id_5, s0_.api_id AS api_id_6, s0_.created_at AS created_at_7, s0_.updated_at AS updated_at_8, s1_.name AS name_9, s1_.invisible_complement_name AS invisible_complement_name_10, s1_.slug AS slug_11, s1_.type AS type_12, s1_.is_compilation AS is_compilation_13, s1_.first_released_at AS first_released_at_14, s1_.id AS id_15, s1_.api_id AS api_id_16, s1_.displayed AS displayed_17, s1_.created_at AS created_at_18, s1_.updated_at AS updated_at_19, s0_.cover__sebii__file__media__id AS cover__sebii__file__media__id_20, s0_.background__sebii__file__media__id AS background__sebii__file__media__id_21, s1_.cover__sebii__file__media__id AS cover__sebii__file__media__id_22, s1_.background__sebii__file__media__id AS background__sebii__file__media__id_23 FROM "sebii__category__universe" s0_ LEFT JOIN sebii__category__category_universe s2_ ON s0_.id = s2_.sebii__category__universe__id LEFT JOIN "sebii__category__category" s1_ ON s1_.id = s2_.sebii__category__category__id ORDER BY s0_.name ASC, s1_.name ASC;
|