| 1 |
6.05 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, s0_.cover__sebii__file__media__id AS cover__sebii__file__media__id_9, s0_.background__sebii__file__media__id AS background__sebii__file__media__id_10 FROM "sebii__category__universe" s0_ WHERE s0_.customized_domain = ? LIMIT 1
Parameters: [
"stream.sebii.dev"
]
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, s0_.cover__sebii__file__media__id AS cover__sebii__file__media__id_9, s0_.background__sebii__file__media__id AS background__sebii__file__media__id_10 FROM "sebii__category__universe" s0_ WHERE s0_.customized_domain = 'stream.sebii.dev' LIMIT 1;
|
| 2 |
0.39 ms |
"START TRANSACTION"
"START TRANSACTION";
|
| 3 |
3.47 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-12-15 18:10:36.074777\";s:13:\"timezone_type\";i:3;s:8:\"timezone\";s:3:\"UTC\";}s:52:\"\0App\\Messenger\\Message\\Security\\AnalyticMessage\0page\";s:43:\"/video/018fe01e-edb2-71ff-9f53-58faef52be43\";s:54:\"\0App\\Messenger\\Message\\Security\\AnalyticMessage\0domain\";s:16:\"stream.sebii.dev\";s:57:\"\0App\\Messenger\\Message\\Security\\AnalyticMessage\0ipAddress\";s:14:\"216.73.216.127\";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-12-15 18:10:36"
"2025-12-15 18:10:36"
]
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-12-15 18:10:36.074777\\\";s:13:\\\"timezone_type\\\";i:3;s:8:\\\"timezone\\\";s:3:\\\"UTC\\\";}s:52:\\\"\\0App\\\\Messenger\\\\Message\\\\Security\\\\AnalyticMessage\\0page\\\";s:43:\\\"/video/018fe01e-edb2-71ff-9f53-58faef52be43\\\";s:54:\\\"\\0App\\\\Messenger\\\\Message\\\\Security\\\\AnalyticMessage\\0domain\\\";s:16:\\\"stream.sebii.dev\\\";s:57:\\\"\\0App\\\\Messenger\\\\Message\\\\Security\\\\AnalyticMessage\\0ipAddress\\\";s:14:\\\"216.73.216.127\\\";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-12-15 18:10:36', '2025-12-15 18:10:36') RETURNING id;
|
| 4 |
7.16 ms |
"COMMIT"
|
| 5 |
2.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: [
"018fe01e-edb2-71ff-9f53-58faef52be43"
]
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-edb2-71ff-9f53-58faef52be43';
|
| 6 |
4.10 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.82 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-edb2-71ff-9f53-58faef52be43"
]
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-edb2-71ff-9f53-58faef52be43';
|
| 8 |
0.87 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: [
"stream.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 = 'stream.sebii.dev' LIMIT 1;
|
| 9 |
1.01 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 |
3.69 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-edb2-71ff-9f53-58faef52be43"
]
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-edb2-71ff-9f53-58faef52be43' ORDER BY t0.service ASC, t0.part ASC;
|
| 11 |
2.00 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-b62f-79b6-8642-ea1f618c84d2"
]
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-b62f-79b6-8642-ea1f618c84d2';
|
| 12 |
3.05 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-edb2-71ff-9f53-58faef52be43"
]
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-edb2-71ff-9f53-58faef52be43';
|
| 13 |
1.63 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, t0.steam_grid_template__sebii__file__media__id AS steam_grid_template__sebii__file__media__id_14 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, t0.steam_grid_template__sebii__file__media__id AS steam_grid_template__sebii__file__media__id_14 FROM "sebii__category__platform" t0 WHERE t0.id = '019084f4-7647-792e-bb59-1de14ed6acb2';
|
| 14 |
1.62 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-edb2-71ff-9f53-58faef52be43"
]
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-edb2-71ff-9f53-58faef52be43';
|
| 15 |
0.95 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-bfe5-738d-9a60-e0ba313acdca"
]
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-bfe5-738d-9a60-e0ba313acdca';
|
| 16 |
1.54 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-bfe5-738d-9a60-e0ba313acdca"
]
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-bfe5-738d-9a60-e0ba313acdca' ORDER BY t0.position ASC;
|
| 17 |
0.86 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-edb3-7ad5-9a4d-29f94b78c867"
]
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-edb3-7ad5-9a4d-29f94b78c867';
|
| 18 |
0.69 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-e8fa-7a05-8aac-417d91a6c386"
]
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-e8fa-7a05-8aac-417d91a6c386';
|
| 19 |
0.60 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-e8fb-7e0f-8c59-0ebf8ac95e67"
]
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-e8fb-7e0f-8c59-0ebf8ac95e67';
|
| 20 |
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: [
"018fe01e-dd82-7c98-af68-e685929ce111"
]
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-dd82-7c98-af68-e685929ce111';
|
| 21 |
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-dd88-703e-8df5-a885ea7599dd"
]
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-dd88-703e-8df5-a885ea7599dd';
|
| 22 |
1.18 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-9024-7011-a1f4-55ea0867ab09"
]
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-9024-7011-a1f4-55ea0867ab09' ORDER BY t0.position ASC;
|
| 23 |
0.66 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-3923-7067-9a18-75afa149ace5"
]
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-3923-7067-9a18-75afa149ace5';
|
| 24 |
0.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: [
"018fe01f-3924-7610-a0d7-1be2a9285dca"
]
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-3924-7610-a0d7-1be2a9285dca';
|
| 25 |
0.82 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-850c-7f43-90cd-99c6f7db9594"
]
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-850c-7f43-90cd-99c6f7db9594' ORDER BY t0.position ASC;
|
| 26 |
0.67 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-e542-741d-9c4c-92950e55caba"
]
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-e542-741d-9c4c-92950e55caba';
|
| 27 |
0.57 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: [
"0193a339-74d7-7003-adab-dafbc9bf17f2"
]
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 = '0193a339-74d7-7003-adab-dafbc9bf17f2';
|
| 28 |
0.80 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: [
"01938d06-268a-7944-b0b7-f4b759598d73"
]
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 = '01938d06-268a-7944-b0b7-f4b759598d73' ORDER BY t0.position ASC;
|
| 29 |
0.65 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: [
"01938d0a-567d-7180-8509-48e8a96cc685"
]
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 = '01938d0a-567d-7180-8509-48e8a96cc685';
|
| 30 |
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: [
"019392b6-3a71-7771-b2fd-5072d02e4c73"
]
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 = '019392b6-3a71-7771-b2fd-5072d02e4c73';
|
| 31 |
1.38 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;
|
| 32 |
3.63 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;
|