| 1 |
5.80 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: [
"www.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 = 'www.sebii.dev' LIMIT 1;
|
| 2 |
0.53 ms |
"START TRANSACTION"
"START TRANSACTION";
|
| 3 |
3.40 ms |
INSERT INTO sebii__messenger__message (body, headers, queue_name, created_at, available_at) VALUES(?, ?, ?, ?, ?) RETURNING id
Parameters: [
"O:36:\"Symfony\\Component\\Messenger\\Envelope\":2:{s:44:\"\0Symfony\\Component\\Messenger\\Envelope\0stamps\";a:1:{s:46:\"Symfony\\Component\\Messenger\\Stamp\\BusNameStamp\";a:1:{i:0;O:46:\"Symfony\\Component\\Messenger\\Stamp\\BusNameStamp\":1:{s:55:\"\0Symfony\\Component\\Messenger\\Stamp\\BusNameStamp\0busName\";s:21:\"messenger.bus.default\";}}}s:45:\"\0Symfony\\Component\\Messenger\\Envelope\0message\";O:46:\"App\\Messenger\\Message\\Security\\AnalyticMessage\":6:{s:50:\"\0App\\Messenger\\Message\\Security\\AnalyticMessage\0at\";O:8:\"DateTime\":3:{s:4:\"date\";s:26:\"2025-04-25 04:19:28.616644\";s:13:\"timezone_type\";i:3;s:8:\"timezone\";s:3:\"UTC\";}s:52:\"\0App\\Messenger\\Message\\Security\\AnalyticMessage\0page\";s:22:\"/u/marvel-s-spider-man\";s:54:\"\0App\\Messenger\\Message\\Security\\AnalyticMessage\0domain\";s:13:\"www.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-25 04:19:28"
"2025-04-25 04:19:28"
]
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-25 04:19:28.616644\\\";s:13:\\\"timezone_type\\\";i:3;s:8:\\\"timezone\\\";s:3:\\\"UTC\\\";}s:52:\\\"\\0App\\\\Messenger\\\\Message\\\\Security\\\\AnalyticMessage\\0page\\\";s:22:\\\"/u/marvel-s-spider-man\\\";s:54:\\\"\\0App\\\\Messenger\\\\Message\\\\Security\\\\AnalyticMessage\\0domain\\\";s:13:\\\"www.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-25 04:19:28', '2025-04-25 04:19:28') RETURNING id;
|
| 4 |
3.04 ms |
"COMMIT"
|
| 5 |
0.78 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.slug = ? LIMIT 1
Parameters: [
"marvel-s-spider-man"
]
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.slug = 'marvel-s-spider-man' LIMIT 1;
|
| 6 |
5.65 ms |
SELECT s0_.name AS name_0, s0_.invisible_complement_name AS invisible_complement_name_1, s0_.slug AS slug_2, s0_.type AS type_3, s0_.is_compilation AS is_compilation_4, s0_.first_released_at AS first_released_at_5, s0_.id AS id_6, s0_.api_id AS api_id_7, s0_.displayed AS displayed_8, s0_.created_at AS created_at_9, s0_.updated_at AS updated_at_10, s0_.cover__sebii__file__media__id AS cover__sebii__file__media__id_11, s0_.background__sebii__file__media__id AS background__sebii__file__media__id_12 FROM "sebii__category__category" s0_ INNER JOIN sebii__category__category_universe s2_ ON s0_.id = s2_.sebii__category__category__id INNER JOIN "sebii__category__universe" s1_ ON s1_.id = s2_.sebii__category__universe__id WHERE s1_.id = ?
Parameters: [
"018fdadf-36ff-7d1b-aeef-37295bb57b60"
]
SELECT s0_.name AS name_0, s0_.invisible_complement_name AS invisible_complement_name_1, s0_.slug AS slug_2, s0_.type AS type_3, s0_.is_compilation AS is_compilation_4, s0_.first_released_at AS first_released_at_5, s0_.id AS id_6, s0_.api_id AS api_id_7, s0_.displayed AS displayed_8, s0_.created_at AS created_at_9, s0_.updated_at AS updated_at_10, s0_.cover__sebii__file__media__id AS cover__sebii__file__media__id_11, s0_.background__sebii__file__media__id AS background__sebii__file__media__id_12 FROM "sebii__category__category" s0_ INNER JOIN sebii__category__category_universe s2_ ON s0_.id = s2_.sebii__category__category__id INNER JOIN "sebii__category__universe" s1_ ON s1_.id = s2_.sebii__category__universe__id WHERE s1_.id = '018fdadf-36ff-7d1b-aeef-37295bb57b60';
|
| 7 |
7.80 ms |
SELECT s0_.name AS name_0, s0_.type AS type_1, s0_.description AS description_2, s0_.recorded_at AS recorded_at_3, s0_.duration AS duration_4, s0_.id AS id_5, s0_.api_id AS api_id_6, s0_.displayed AS displayed_7, s0_.created_at AS created_at_8, s0_.updated_at AS updated_at_9, s1_.name AS name_10, s1_.invisible_complement_name AS invisible_complement_name_11, s1_.slug AS slug_12, s1_.type AS type_13, s1_.is_compilation AS is_compilation_14, s1_.first_released_at AS first_released_at_15, s1_.id AS id_16, s1_.api_id AS api_id_17, s1_.displayed AS displayed_18, s1_.created_at AS created_at_19, s1_.updated_at AS updated_at_20, s2_.name AS name_21, s2_.slug AS slug_22, s2_.customized_route AS customized_route_23, s2_.customized_domain AS customized_domain_24, s2_.iconify_code AS iconify_code_25, s2_.id AS id_26, s2_.api_id AS api_id_27, s2_.created_at AS created_at_28, s2_.updated_at AS updated_at_29, s0_.thumbnail__sebii__file__media__id AS thumbnail__sebii__file__media__id_30, s1_.cover__sebii__file__media__id AS cover__sebii__file__media__id_31, s1_.background__sebii__file__media__id AS background__sebii__file__media__id_32, s2_.cover__sebii__file__media__id AS cover__sebii__file__media__id_33, s2_.background__sebii__file__media__id AS background__sebii__file__media__id_34 FROM "sebii__video__video" s0_ INNER JOIN sebii__video__video_category s3_ ON s0_.id = s3_.sebii__video__video__id INNER JOIN "sebii__category__category" s1_ ON s1_.id = s3_.sebii__category__category__id INNER JOIN sebii__category__category_universe s4_ ON s1_.id = s4_.sebii__category__category__id INNER JOIN "sebii__category__universe" s2_ ON s2_.id = s4_.sebii__category__universe__id WHERE s2_.id = ? ORDER BY s0_.recorded_at DESC, s2_.name ASC LIMIT 4
SELECT s0_.name AS name_0, s0_.type AS type_1, s0_.description AS description_2, s0_.recorded_at AS recorded_at_3, s0_.duration AS duration_4, s0_.id AS id_5, s0_.api_id AS api_id_6, s0_.displayed AS displayed_7, s0_.created_at AS created_at_8, s0_.updated_at AS updated_at_9, s1_.name AS name_10, s1_.invisible_complement_name AS invisible_complement_name_11, s1_.slug AS slug_12, s1_.type AS type_13, s1_.is_compilation AS is_compilation_14, s1_.first_released_at AS first_released_at_15, s1_.id AS id_16, s1_.api_id AS api_id_17, s1_.displayed AS displayed_18, s1_.created_at AS created_at_19, s1_.updated_at AS updated_at_20, s2_.name AS name_21, s2_.slug AS slug_22, s2_.customized_route AS customized_route_23, s2_.customized_domain AS customized_domain_24, s2_.iconify_code AS iconify_code_25, s2_.id AS id_26, s2_.api_id AS api_id_27, s2_.created_at AS created_at_28, s2_.updated_at AS updated_at_29, s0_.thumbnail__sebii__file__media__id AS thumbnail__sebii__file__media__id_30, s1_.cover__sebii__file__media__id AS cover__sebii__file__media__id_31, s1_.background__sebii__file__media__id AS background__sebii__file__media__id_32, s2_.cover__sebii__file__media__id AS cover__sebii__file__media__id_33, s2_.background__sebii__file__media__id AS background__sebii__file__media__id_34 FROM "sebii__video__video" s0_ INNER JOIN sebii__video__video_category s3_ ON s0_.id = s3_.sebii__video__video__id INNER JOIN "sebii__category__category" s1_ ON s1_.id = s3_.sebii__category__category__id INNER JOIN sebii__category__category_universe s4_ ON s1_.id = s4_.sebii__category__category__id INNER JOIN "sebii__category__universe" s2_ ON s2_.id = s4_.sebii__category__universe__id WHERE s2_.id = '018fdadf-36ff-7d1b-aeef-37295bb57b60' ORDER BY s0_.recorded_at DESC, s2_.name ASC LIMIT 4;
|
| 8 |
1.22 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: [
"www.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 = 'www.sebii.dev' LIMIT 1;
|
| 9 |
1.44 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.21 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-aada-712f-a35c-306674446a36"
]
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-aada-712f-a35c-306674446a36';
|
| 11 |
2.22 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 WHERE t0.sebii__category__category__id = ? ORDER BY t0.name ASC
Parameters: [
"018fde62-4e0b-7042-b19c-e6e75b811f9e"
]
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 WHERE t0.sebii__category__category__id = '018fde62-4e0b-7042-b19c-e6e75b811f9e' ORDER BY t0.name ASC;
|
| 12 |
1.97 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: [
"01909e6a-2f37-78b5-9501-a9b348b32785"
]
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 = '01909e6a-2f37-78b5-9501-a9b348b32785';
|
| 13 |
0.78 ms |
SELECT t0.checksum AS checksum_1, t0.id AS id_2, t0.api_id AS api_id_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.file_metadata_name AS file_metadata_name_6, t0.file_metadata_original_name AS file_metadata_original_name_7, t0.file_metadata_mime_type AS file_metadata_mime_type_8, t0.file_metadata_size AS file_metadata_size_9, t0.file_metadata_dimensions AS file_metadata_dimensions_10 FROM "sebii__file__media" t0 WHERE t0.id = ?
Parameters: [
"01939ba0-f8d2-7538-a522-6d9c0dfbadd7"
]
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 = '01939ba0-f8d2-7538-a522-6d9c0dfbadd7';
|
| 14 |
0.80 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 WHERE t0.sebii__category__category__id = ? ORDER BY t0.name ASC
Parameters: [
"01939b97-9c8e-7dae-8816-74f7ab79c819"
]
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 WHERE t0.sebii__category__category__id = '01939b97-9c8e-7dae-8816-74f7ab79c819' ORDER BY t0.name ASC;
|
| 15 |
0.71 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: [
"01939bb3-3b5d-7625-9eee-d74c63fead28"
]
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 = '01939bb3-3b5d-7625-9eee-d74c63fead28';
|
| 16 |
0.77 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 WHERE t0.sebii__category__category__id = ? ORDER BY t0.name ASC
Parameters: [
"01939bb3-27e8-7f55-bada-dbfe6c93bd7b"
]
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 WHERE t0.sebii__category__category__id = '01939bb3-27e8-7f55-bada-dbfe6c93bd7b' ORDER BY t0.name ASC;
|
| 17 |
0.62 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: [
"01939bb4-89da-75bd-921a-84395c214876"
]
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 = '01939bb4-89da-75bd-921a-84395c214876';
|
| 18 |
0.94 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: [
"01900241-8c14-7ce9-8ebe-cfa5d4a023ef"
]
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 = '01900241-8c14-7ce9-8ebe-cfa5d4a023ef';
|
| 19 |
2.53 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: [
"01900241-6a37-7ebf-8e8e-86e9a624e5b9"
]
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 = '01900241-6a37-7ebf-8e8e-86e9a624e5b9';
|
| 20 |
0.85 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: [
"0190023d-60b7-7c35-a051-20cda95fa89e"
]
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 = '0190023d-60b7-7c35-a051-20cda95fa89e';
|
| 21 |
1.29 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: [
"0190023d-4424-77f9-acbc-10e491e41b4b"
]
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 = '0190023d-4424-77f9-acbc-10e491e41b4b';
|
| 22 |
0.69 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: [
"0190023b-5166-777a-bc00-5b5b38292582"
]
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 = '0190023b-5166-777a-bc00-5b5b38292582';
|
| 23 |
1.11 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: [
"0190023b-356c-780f-8af1-e0c186eb4608"
]
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 = '0190023b-356c-780f-8af1-e0c186eb4608';
|
| 24 |
0.69 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: [
"01900238-a195-75ef-bcc9-b1bbf97e37b5"
]
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 = '01900238-a195-75ef-bcc9-b1bbf97e37b5';
|
| 25 |
1.00 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: [
"01900238-839e-72d7-962a-a41c3e7a6dbb"
]
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 = '01900238-839e-72d7-962a-a41c3e7a6dbb';
|
| 26 |
2.49 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;
|
| 27 |
2.68 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;
|