1 |
4.05 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.32 ms |
"START TRANSACTION"
"START TRANSACTION";
|
3 |
2.71 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:48:16.058845\";s:13:\"timezone_type\";i:3;s:8:\"timezone\";s:3:\"UTC\";}s:52:\"\0App\\Messenger\\Message\\Security\\AnalyticMessage\0page\";s:43:\"/video/018fe01e-bcfc-7929-8be2-f0f72ce262ae\";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:48:16"
"2025-04-19 17:48:16"
]
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:48:16.058845\\\";s:13:\\\"timezone_type\\\";i:3;s:8:\\\"timezone\\\";s:3:\\\"UTC\\\";}s:52:\\\"\\0App\\\\Messenger\\\\Message\\\\Security\\\\AnalyticMessage\\0page\\\";s:43:\\\"/video/018fe01e-bcfc-7929-8be2-f0f72ce262ae\\\";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:48:16', '2025-04-19 17:48:16') RETURNING id;
|
4 |
1.35 ms |
"COMMIT"
|
5 |
1.77 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-bcfc-7929-8be2-f0f72ce262ae"
]
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-bcfc-7929-8be2-f0f72ce262ae';
|
6 |
3.14 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 |
3.43 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-bcfc-7929-8be2-f0f72ce262ae"
]
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-bcfc-7929-8be2-f0f72ce262ae';
|
8 |
0.75 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.97 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.32 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-bcfc-7929-8be2-f0f72ce262ae"
]
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-bcfc-7929-8be2-f0f72ce262ae' ORDER BY t0.service ASC, t0.part ASC;
|
11 |
1.40 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-aca8-70ff-97c7-0086c6effab6"
]
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-aca8-70ff-97c7-0086c6effab6';
|
12 |
2.33 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-bcfc-7929-8be2-f0f72ce262ae"
]
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-bcfc-7929-8be2-f0f72ce262ae';
|
13 |
1.23 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: [
"019083ca-9f8d-7cbf-9a6f-b090b60c7189"
]
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 = '019083ca-9f8d-7cbf-9a6f-b090b60c7189';
|
14 |
1.48 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-bcfc-7929-8be2-f0f72ce262ae"
]
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-bcfc-7929-8be2-f0f72ce262ae';
|
15 |
0.70 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-a5a5-7d25-88b3-a21191ea24a0"
]
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-a5a5-7d25-88b3-a21191ea24a0';
|
16 |
1.12 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-a5a5-7d25-88b3-a21191ea24a0"
]
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-a5a5-7d25-88b3-a21191ea24a0' ORDER BY t0.position ASC;
|
17 |
0.51 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-bcfd-7707-a8da-4179a026b76e"
]
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-bcfd-7707-a8da-4179a026b76e';
|
18 |
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: [
"0193b03f-aec9-79a1-b5bc-3a23113bbf43"
]
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 = '0193b03f-aec9-79a1-b5bc-3a23113bbf43';
|
19 |
0.37 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: [
"0193b03f-c02d-7f90-bd6c-94a046b45009"
]
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 = '0193b03f-c02d-7f90-bd6c-94a046b45009';
|
20 |
0.66 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: [
"0193d13a-d410-72be-afcc-093696250788"
]
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 = '0193d13a-d410-72be-afcc-093696250788' ORDER BY t0.position ASC;
|
21 |
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: [
"0193d13d-0947-7ae4-948d-29fa4a936468"
]
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 = '0193d13d-0947-7ae4-948d-29fa4a936468';
|
22 |
0.80 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: [
"0193d13d-6f4a-78db-8ce2-2431806d7f37"
]
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 = '0193d13d-6f4a-78db-8ce2-2431806d7f37';
|
23 |
0.72 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: [
"019383bf-be6a-772f-bb4c-26f1db84921e"
]
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 = '019383bf-be6a-772f-bb4c-26f1db84921e' ORDER BY t0.position ASC;
|
24 |
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: [
"019383c3-e09b-787f-acbd-5de650c2558b"
]
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 = '019383c3-e09b-787f-acbd-5de650c2558b';
|
25 |
0.37 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: [
"019383c0-1790-7f99-b039-5b56b64674aa"
]
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 = '019383c0-1790-7f99-b039-5b56b64674aa';
|
26 |
0.38 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-afcf-7a8c-903a-1c922fa41f0d"
]
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-afcf-7a8c-903a-1c922fa41f0d' ORDER BY t0.position ASC;
|
27 |
0.37 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-c838-760b-84f6-94094dd3053e"
]
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-c838-760b-84f6-94094dd3053e';
|
28 |
0.31 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: [
"0193a79a-2dbb-7581-99cc-17c8959d955f"
]
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 = '0193a79a-2dbb-7581-99cc-17c8959d955f';
|
29 |
1.66 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;
|
30 |
2.39 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;
|