1 |
4.60 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: [
"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 = 'sebii.dev' LIMIT 1;
|
2 |
0.46 ms |
"START TRANSACTION"
"START TRANSACTION";
|
3 |
3.25 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-19 17:46:42.762974\";s:13:\"timezone_type\";i:3;s:8:\"timezone\";s:3:\"UTC\";}s:52:\"\0App\\Messenger\\Message\\Security\\AnalyticMessage\0page\";s:43:\"/video/0193abdb-e1d7-74f3-9da6-b850eb783476\";s:54:\"\0App\\Messenger\\Message\\Security\\AnalyticMessage\0domain\";s:9:\"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-19 17:46:42"
"2025-04-19 17:46:42"
]
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-19 17:46:42.762974\\\";s:13:\\\"timezone_type\\\";i:3;s:8:\\\"timezone\\\";s:3:\\\"UTC\\\";}s:52:\\\"\\0App\\\\Messenger\\\\Message\\\\Security\\\\AnalyticMessage\\0page\\\";s:43:\\\"/video/0193abdb-e1d7-74f3-9da6-b850eb783476\\\";s:54:\\\"\\0App\\\\Messenger\\\\Message\\\\Security\\\\AnalyticMessage\\0domain\\\";s:9:\\\"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-19 17:46:42', '2025-04-19 17:46:42') RETURNING id;
|
4 |
1.49 ms |
"COMMIT"
|
5 |
2.03 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: [
"0193abdb-e1d7-74f3-9da6-b850eb783476"
]
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 = '0193abdb-e1d7-74f3-9da6-b850eb783476';
|
6 |
4.04 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 |
4.53 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: [
"0193abdb-e1d7-74f3-9da6-b850eb783476"
]
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 = '0193abdb-e1d7-74f3-9da6-b850eb783476';
|
8 |
0.59 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: [
"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 = 'sebii.dev' LIMIT 1;
|
9 |
0.95 ms |
SELECT COUNT(s0_.id) AS sclr_0 FROM "sebii__video__video" s0_ WHERE s0_.type = ?
SELECT COUNT(s0_.id) AS sclr_0 FROM "sebii__video__video" s0_ WHERE s0_.type = 'live';
|
10 |
2.84 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: [
"0193abdb-e1d7-74f3-9da6-b850eb783476"
]
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 = '0193abdb-e1d7-74f3-9da6-b850eb783476' ORDER BY t0.service ASC, t0.part ASC;
|
11 |
1.55 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-b965-7eb4-a0a5-9856e94fd8f9"
]
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-b965-7eb4-a0a5-9856e94fd8f9';
|
12 |
2.86 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: [
"0193abdb-e1d7-74f3-9da6-b850eb783476"
]
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 = '0193abdb-e1d7-74f3-9da6-b850eb783476';
|
13 |
1.50 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: [
"019084e5-8ac9-77ae-a130-71bd78bbe2d7"
]
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 = '019084e5-8ac9-77ae-a130-71bd78bbe2d7';
|
14 |
1.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__video__id = ?
Parameters: [
"0193abdb-e1d7-74f3-9da6-b850eb783476"
]
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 = '0193abdb-e1d7-74f3-9da6-b850eb783476';
|
15 |
0.63 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-c9fa-7d32-8e72-3a3533af7086"
]
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-c9fa-7d32-8e72-3a3533af7086';
|
16 |
1.32 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-c9fa-7d32-8e72-3a3533af7086"
]
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-c9fa-7d32-8e72-3a3533af7086' ORDER BY t0.position ASC;
|
17 |
0.60 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: [
"018fe01f-40b1-7923-b339-52bc156a8ed0"
]
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 = '018fe01f-40b1-7923-b339-52bc156a8ed0';
|
18 |
0.48 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: [
"018fe01f-40b2-716d-b276-d32f023fbf9c"
]
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 = '018fe01f-40b2-716d-b276-d32f023fbf9c';
|
19 |
0.47 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: [
"0193abd5-483d-7544-a934-f37a40a28ab6"
]
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 = '0193abd5-483d-7544-a934-f37a40a28ab6';
|
20 |
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: [
"0193abe2-486f-79e8-a1a7-fe325bd879b3"
]
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 = '0193abe2-486f-79e8-a1a7-fe325bd879b3';
|
21 |
0.63 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: [
"0193abd8-2aab-7637-b723-5492dfadf8ae"
]
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 = '0193abd8-2aab-7637-b723-5492dfadf8ae';
|
22 |
0.77 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: [
"0193abe1-a8f2-7adc-bc52-ae0b1118e1d2"
]
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 = '0193abe1-a8f2-7adc-bc52-ae0b1118e1d2';
|
23 |
0.49 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: [
"0193abd9-5c30-7644-a4cc-4b891ada092e"
]
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 = '0193abd9-5c30-7644-a4cc-4b891ada092e';
|
24 |
0.64 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: [
"0193abe0-b3b4-7a5a-ba4d-e7b28c9880be"
]
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 = '0193abe0-b3b4-7a5a-ba4d-e7b28c9880be';
|
25 |
0.55 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: [
"0193abda-a7dd-75c6-bfe2-8ff4e2206a4d"
]
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 = '0193abda-a7dd-75c6-bfe2-8ff4e2206a4d';
|
26 |
0.68 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: [
"0193abe0-0fb9-7b4e-9583-485f60aecc7e"
]
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 = '0193abe0-0fb9-7b4e-9583-485f60aecc7e';
|
27 |
0.59 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: [
"0193abdf-589d-7dfd-9e0a-32c4ed3d2a90"
]
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 = '0193abdf-589d-7dfd-9e0a-32c4ed3d2a90';
|
28 |
0.64 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: [
"0193abdd-ad8e-7b73-8835-838054a12932"
]
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 = '0193abdd-ad8e-7b73-8835-838054a12932';
|
29 |
0.63 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: [
"0193abde-bc08-7d55-b1cf-96ebd175773f"
]
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 = '0193abde-bc08-7d55-b1cf-96ebd175773f';
|
30 |
0.86 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-a4b1-7d64-a951-3fccb7c9028d"
]
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-a4b1-7d64-a951-3fccb7c9028d' ORDER BY t0.position ASC;
|
31 |
0.62 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-bbde-7607-849a-d9ab1c5d902b"
]
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-bbde-7607-849a-d9ab1c5d902b';
|
32 |
0.63 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: [
"0193a34b-1461-753c-9419-d518aa893106"
]
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 = '0193a34b-1461-753c-9419-d518aa893106';
|
33 |
0.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: [
"019387a0-11ba-793c-bfa9-a4e8a81ae496"
]
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 = '019387a0-11ba-793c-bfa9-a4e8a81ae496' ORDER BY t0.position ASC;
|
34 |
0.61 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: [
"019387a4-de28-7933-8305-b60918e2c978"
]
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 = '019387a4-de28-7933-8305-b60918e2c978';
|
35 |
0.62 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: [
"019387a1-1d54-706c-99ea-b67b02aaf480"
]
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 = '019387a1-1d54-706c-99ea-b67b02aaf480';
|
36 |
0.69 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: [
"0193a781-a35a-7f66-aa81-f13560033fe7"
]
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 = '0193a781-a35a-7f66-aa81-f13560033fe7' ORDER BY t0.position ASC;
|
37 |
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;
|
38 |
2.49 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;
|