| 1 |
4.79 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.43 ms |
"START TRANSACTION"
"START TRANSACTION";
|
| 3 |
3.59 ms |
INSERT INTO sebii__messenger__message (body, headers, queue_name, created_at, available_at) VALUES(?, ?, ?, ?, ?) RETURNING id
Parameters: [
"O:36:\"Symfony\\Component\\Messenger\\Envelope\":2:{s:44:\"\0Symfony\\Component\\Messenger\\Envelope\0stamps\";a:1:{s:46:\"Symfony\\Component\\Messenger\\Stamp\\BusNameStamp\";a:1:{i:0;O:46:\"Symfony\\Component\\Messenger\\Stamp\\BusNameStamp\":1:{s:55:\"\0Symfony\\Component\\Messenger\\Stamp\\BusNameStamp\0busName\";s:21:\"messenger.bus.default\";}}}s:45:\"\0Symfony\\Component\\Messenger\\Envelope\0message\";O:46:\"App\\Messenger\\Message\\Security\\AnalyticMessage\":6:{s:50:\"\0App\\Messenger\\Message\\Security\\AnalyticMessage\0at\";O:8:\"DateTime\":3:{s:4:\"date\";s:26:\"2025-04-21 04:37:50.938571\";s:13:\"timezone_type\";i:3;s:8:\"timezone\";s:3:\"UTC\";}s:52:\"\0App\\Messenger\\Message\\Security\\AnalyticMessage\0page\";s:40:\"/videos/23/v:live,v:replay,v:short,v:vod\";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-21 04:37:50"
"2025-04-21 04:37:50"
]
INSERT INTO sebii__messenger__message (body, headers, queue_name, created_at, available_at) VALUES('O:36:\\\"Symfony\\\\Component\\\\Messenger\\\\Envelope\\\":2:{s:44:\\\"\\0Symfony\\\\Component\\\\Messenger\\\\Envelope\\0stamps\\\";a:1:{s:46:\\\"Symfony\\\\Component\\\\Messenger\\\\Stamp\\\\BusNameStamp\\\";a:1:{i:0;O:46:\\\"Symfony\\\\Component\\\\Messenger\\\\Stamp\\\\BusNameStamp\\\":1:{s:55:\\\"\\0Symfony\\\\Component\\\\Messenger\\\\Stamp\\\\BusNameStamp\\0busName\\\";s:21:\\\"messenger.bus.default\\\";}}}s:45:\\\"\\0Symfony\\\\Component\\\\Messenger\\\\Envelope\\0message\\\";O:46:\\\"App\\\\Messenger\\\\Message\\\\Security\\\\AnalyticMessage\\\":6:{s:50:\\\"\\0App\\\\Messenger\\\\Message\\\\Security\\\\AnalyticMessage\\0at\\\";O:8:\\\"DateTime\\\":3:{s:4:\\\"date\\\";s:26:\\\"2025-04-21 04:37:50.938571\\\";s:13:\\\"timezone_type\\\";i:3;s:8:\\\"timezone\\\";s:3:\\\"UTC\\\";}s:52:\\\"\\0App\\\\Messenger\\\\Message\\\\Security\\\\AnalyticMessage\\0page\\\";s:40:\\\"/videos/23/v:live,v:replay,v:short,v:vod\\\";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-21 04:37:50', '2025-04-21 04:37:50') RETURNING id;
|
| 4 |
2.59 ms |
"COMMIT"
|
| 5 |
17.95 ms |
SELECT COUNT(*) AS dctrn_count FROM (SELECT DISTINCT id_5 FROM (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, s3_.name AS name_30, s3_.released_at AS released_at_31, s3_.date_type AS date_type_32, s3_.status AS status_33, s3_.id AS id_34, s3_.api_id AS api_id_35, s4_.name AS name_36, s4_.slug AS slug_37, s4_.abbreviation AS abbreviation_38, s4_.type AS type_39, s4_.family AS family_40, s4_.iconify_code AS iconify_code_41, s4_.id AS id_42, s4_.api_id AS api_id_43, s4_.displayed AS displayed_44, s4_.color AS color_45, s4_.created_at AS created_at_46, s4_.updated_at AS updated_at_47, s5_.checksum AS checksum_48, s5_.id AS id_49, s5_.api_id AS api_id_50, s5_.created_at AS created_at_51, s5_.updated_at AS updated_at_52, s5_.file_metadata_name AS file_metadata_name_53, s5_.file_metadata_original_name AS file_metadata_original_name_54, s5_.file_metadata_mime_type AS file_metadata_mime_type_55, s5_.file_metadata_size AS file_metadata_size_56, s5_.file_metadata_dimensions AS file_metadata_dimensions_57 FROM "sebii__video__video" s0_ LEFT JOIN sebii__video__video_category s6_ ON s0_.id = s6_.sebii__video__video__id LEFT JOIN "sebii__category__category" s1_ ON s1_.id = s6_.sebii__category__category__id LEFT JOIN sebii__category__category_universe s7_ ON s1_.id = s7_.sebii__category__category__id LEFT JOIN "sebii__category__universe" s2_ ON s2_.id = s7_.sebii__category__universe__id LEFT JOIN sebii__video__video_release s8_ ON s0_.id = s8_.sebii__video__video__id LEFT JOIN "sebii__category__release" s3_ ON s3_.id = s8_.sebii__category__release__id LEFT JOIN "sebii__category__platform" s4_ ON s3_.sebii__category__platform__id = s4_.id LEFT JOIN "sebii__file__media" s5_ ON s0_.thumbnail__sebii__file__media__id = s5_.id WHERE s0_.displayed = true ORDER BY s0_.recorded_at DESC, s2_.name ASC) dctrn_result) dctrn_table
SELECT
COUNT(*) AS dctrn_count
FROM
(
SELECT
DISTINCT id_5
FROM
(
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,
s3_.name AS name_30,
s3_.released_at AS released_at_31,
s3_.date_type AS date_type_32,
s3_.status AS status_33,
s3_.id AS id_34,
s3_.api_id AS api_id_35,
s4_.name AS name_36,
s4_.slug AS slug_37,
s4_.abbreviation AS abbreviation_38,
s4_.type AS type_39,
s4_.family AS family_40,
s4_.iconify_code AS iconify_code_41,
s4_.id AS id_42,
s4_.api_id AS api_id_43,
s4_.displayed AS displayed_44,
s4_.color AS color_45,
s4_.created_at AS created_at_46,
s4_.updated_at AS updated_at_47,
s5_.checksum AS checksum_48,
s5_.id AS id_49,
s5_.api_id AS api_id_50,
s5_.created_at AS created_at_51,
s5_.updated_at AS updated_at_52,
s5_.file_metadata_name AS file_metadata_name_53,
s5_.file_metadata_original_name AS file_metadata_original_name_54,
s5_.file_metadata_mime_type AS file_metadata_mime_type_55,
s5_.file_metadata_size AS file_metadata_size_56,
s5_.file_metadata_dimensions AS file_metadata_dimensions_57
FROM
"sebii__video__video" s0_
LEFT JOIN sebii__video__video_category s6_ ON s0_.id = s6_.sebii__video__video__id
LEFT JOIN "sebii__category__category" s1_ ON s1_.id = s6_.sebii__category__category__id
LEFT JOIN sebii__category__category_universe s7_ ON s1_.id = s7_.sebii__category__category__id
LEFT JOIN "sebii__category__universe" s2_ ON s2_.id = s7_.sebii__category__universe__id
LEFT JOIN sebii__video__video_release s8_ ON s0_.id = s8_.sebii__video__video__id
LEFT JOIN "sebii__category__release" s3_ ON s3_.id = s8_.sebii__category__release__id
LEFT JOIN "sebii__category__platform" s4_ ON s3_.sebii__category__platform__id = s4_.id
LEFT JOIN "sebii__file__media" s5_ ON s0_.thumbnail__sebii__file__media__id = s5_.id
WHERE
s0_.displayed = true
ORDER BY
s0_.recorded_at DESC,
s2_.name ASC
) dctrn_result
) dctrn_table
SELECT COUNT(*) AS dctrn_count FROM (SELECT DISTINCT id_5 FROM (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, s3_.name AS name_30, s3_.released_at AS released_at_31, s3_.date_type AS date_type_32, s3_.status AS status_33, s3_.id AS id_34, s3_.api_id AS api_id_35, s4_.name AS name_36, s4_.slug AS slug_37, s4_.abbreviation AS abbreviation_38, s4_.type AS type_39, s4_.family AS family_40, s4_.iconify_code AS iconify_code_41, s4_.id AS id_42, s4_.api_id AS api_id_43, s4_.displayed AS displayed_44, s4_.color AS color_45, s4_.created_at AS created_at_46, s4_.updated_at AS updated_at_47, s5_.checksum AS checksum_48, s5_.id AS id_49, s5_.api_id AS api_id_50, s5_.created_at AS created_at_51, s5_.updated_at AS updated_at_52, s5_.file_metadata_name AS file_metadata_name_53, s5_.file_metadata_original_name AS file_metadata_original_name_54, s5_.file_metadata_mime_type AS file_metadata_mime_type_55, s5_.file_metadata_size AS file_metadata_size_56, s5_.file_metadata_dimensions AS file_metadata_dimensions_57 FROM "sebii__video__video" s0_ LEFT JOIN sebii__video__video_category s6_ ON s0_.id = s6_.sebii__video__video__id LEFT JOIN "sebii__category__category" s1_ ON s1_.id = s6_.sebii__category__category__id LEFT JOIN sebii__category__category_universe s7_ ON s1_.id = s7_.sebii__category__category__id LEFT JOIN "sebii__category__universe" s2_ ON s2_.id = s7_.sebii__category__universe__id LEFT JOIN sebii__video__video_release s8_ ON s0_.id = s8_.sebii__video__video__id LEFT JOIN "sebii__category__release" s3_ ON s3_.id = s8_.sebii__category__release__id LEFT JOIN "sebii__category__platform" s4_ ON s3_.sebii__category__platform__id = s4_.id LEFT JOIN "sebii__file__media" s5_ ON s0_.thumbnail__sebii__file__media__id = s5_.id WHERE s0_.displayed = true ORDER BY s0_.recorded_at DESC, s2_.name ASC) dctrn_result) dctrn_table;
|
| 6 |
1.32 ms |
SELECT s0_.name AS name_0, s0_.slug AS slug_1, s0_.abbreviation AS abbreviation_2, s0_.type AS type_3, s0_.family AS family_4, s0_.iconify_code AS iconify_code_5, s0_.id AS id_6, s0_.api_id AS api_id_7, s0_.displayed AS displayed_8, s0_.color AS color_9, s0_.created_at AS created_at_10, s0_.updated_at AS updated_at_11, s0_.logo__sebii__file__media__id AS logo__sebii__file__media__id_12 FROM "sebii__category__platform" s0_ ORDER BY s0_.name ASC
SELECT s0_.name AS name_0, s0_.slug AS slug_1, s0_.abbreviation AS abbreviation_2, s0_.type AS type_3, s0_.family AS family_4, s0_.iconify_code AS iconify_code_5, s0_.id AS id_6, s0_.api_id AS api_id_7, s0_.displayed AS displayed_8, s0_.color AS color_9, s0_.created_at AS created_at_10, s0_.updated_at AS updated_at_11, s0_.logo__sebii__file__media__id AS logo__sebii__file__media__id_12 FROM "sebii__category__platform" s0_ ORDER BY s0_.name ASC;
|
| 7 |
3.49 ms |
SELECT s0_.name AS name_0, s0_.slug AS slug_1, s0_.customized_route AS customized_route_2, s0_.customized_domain AS customized_domain_3, s0_.iconify_code AS iconify_code_4, s0_.id AS id_5, s0_.api_id AS api_id_6, s0_.created_at AS created_at_7, s0_.updated_at AS updated_at_8, s1_.name AS name_9, s1_.invisible_complement_name AS invisible_complement_name_10, s1_.slug AS slug_11, s1_.type AS type_12, s1_.is_compilation AS is_compilation_13, s1_.first_released_at AS first_released_at_14, s1_.id AS id_15, s1_.api_id AS api_id_16, s1_.displayed AS displayed_17, s1_.created_at AS created_at_18, s1_.updated_at AS updated_at_19, s0_.cover__sebii__file__media__id AS cover__sebii__file__media__id_20, s0_.background__sebii__file__media__id AS background__sebii__file__media__id_21, s1_.cover__sebii__file__media__id AS cover__sebii__file__media__id_22, s1_.background__sebii__file__media__id AS background__sebii__file__media__id_23 FROM "sebii__category__universe" s0_ LEFT JOIN sebii__category__category_universe s2_ ON s0_.id = s2_.sebii__category__universe__id LEFT JOIN "sebii__category__category" s1_ ON s1_.id = s2_.sebii__category__category__id ORDER BY s0_.name ASC, s1_.name ASC
SELECT s0_.name AS name_0, s0_.slug AS slug_1, s0_.customized_route AS customized_route_2, s0_.customized_domain AS customized_domain_3, s0_.iconify_code AS iconify_code_4, s0_.id AS id_5, s0_.api_id AS api_id_6, s0_.created_at AS created_at_7, s0_.updated_at AS updated_at_8, s1_.name AS name_9, s1_.invisible_complement_name AS invisible_complement_name_10, s1_.slug AS slug_11, s1_.type AS type_12, s1_.is_compilation AS is_compilation_13, s1_.first_released_at AS first_released_at_14, s1_.id AS id_15, s1_.api_id AS api_id_16, s1_.displayed AS displayed_17, s1_.created_at AS created_at_18, s1_.updated_at AS updated_at_19, s0_.cover__sebii__file__media__id AS cover__sebii__file__media__id_20, s0_.background__sebii__file__media__id AS background__sebii__file__media__id_21, s1_.cover__sebii__file__media__id AS cover__sebii__file__media__id_22, s1_.background__sebii__file__media__id AS background__sebii__file__media__id_23 FROM "sebii__category__universe" s0_ LEFT JOIN sebii__category__category_universe s2_ ON s0_.id = s2_.sebii__category__universe__id LEFT JOIN "sebii__category__category" s1_ ON s1_.id = s2_.sebii__category__category__id ORDER BY s0_.name ASC, s1_.name ASC;
|
| 8 |
0.90 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.79 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 |
8.99 ms |
SELECT DISTINCT id_5, MIN(sclr_58) AS dctrn_minrownum FROM (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, s3_.name AS name_30, s3_.released_at AS released_at_31, s3_.date_type AS date_type_32, s3_.status AS status_33, s3_.id AS id_34, s3_.api_id AS api_id_35, s4_.name AS name_36, s4_.slug AS slug_37, s4_.abbreviation AS abbreviation_38, s4_.type AS type_39, s4_.family AS family_40, s4_.iconify_code AS iconify_code_41, s4_.id AS id_42, s4_.api_id AS api_id_43, s4_.displayed AS displayed_44, s4_.color AS color_45, s4_.created_at AS created_at_46, s4_.updated_at AS updated_at_47, s5_.checksum AS checksum_48, s5_.id AS id_49, s5_.api_id AS api_id_50, s5_.created_at AS created_at_51, s5_.updated_at AS updated_at_52, s5_.file_metadata_name AS file_metadata_name_53, s5_.file_metadata_original_name AS file_metadata_original_name_54, s5_.file_metadata_mime_type AS file_metadata_mime_type_55, s5_.file_metadata_size AS file_metadata_size_56, s5_.file_metadata_dimensions AS file_metadata_dimensions_57, ROW_NUMBER() OVER(ORDER BY s0_.recorded_at DESC, s2_.name ASC) AS sclr_58 FROM "sebii__video__video" s0_ LEFT JOIN sebii__video__video_category s6_ ON s0_.id = s6_.sebii__video__video__id LEFT JOIN "sebii__category__category" s1_ ON s1_.id = s6_.sebii__category__category__id LEFT JOIN sebii__category__category_universe s7_ ON s1_.id = s7_.sebii__category__category__id LEFT JOIN "sebii__category__universe" s2_ ON s2_.id = s7_.sebii__category__universe__id LEFT JOIN sebii__video__video_release s8_ ON s0_.id = s8_.sebii__video__video__id LEFT JOIN "sebii__category__release" s3_ ON s3_.id = s8_.sebii__category__release__id LEFT JOIN "sebii__category__platform" s4_ ON s3_.sebii__category__platform__id = s4_.id LEFT JOIN "sebii__file__media" s5_ ON s0_.thumbnail__sebii__file__media__id = s5_.id WHERE s0_.displayed = true) dctrn_result GROUP BY id_5 ORDER BY dctrn_minrownum ASC LIMIT 24 OFFSET 528
SELECT
DISTINCT id_5,
MIN(sclr_58) AS dctrn_minrownum
FROM
(
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,
s3_.name AS name_30,
s3_.released_at AS released_at_31,
s3_.date_type AS date_type_32,
s3_.status AS status_33,
s3_.id AS id_34,
s3_.api_id AS api_id_35,
s4_.name AS name_36,
s4_.slug AS slug_37,
s4_.abbreviation AS abbreviation_38,
s4_.type AS type_39,
s4_.family AS family_40,
s4_.iconify_code AS iconify_code_41,
s4_.id AS id_42,
s4_.api_id AS api_id_43,
s4_.displayed AS displayed_44,
s4_.color AS color_45,
s4_.created_at AS created_at_46,
s4_.updated_at AS updated_at_47,
s5_.checksum AS checksum_48,
s5_.id AS id_49,
s5_.api_id AS api_id_50,
s5_.created_at AS created_at_51,
s5_.updated_at AS updated_at_52,
s5_.file_metadata_name AS file_metadata_name_53,
s5_.file_metadata_original_name AS file_metadata_original_name_54,
s5_.file_metadata_mime_type AS file_metadata_mime_type_55,
s5_.file_metadata_size AS file_metadata_size_56,
s5_.file_metadata_dimensions AS file_metadata_dimensions_57,
ROW_NUMBER() OVER(
ORDER BY
s0_.recorded_at DESC,
s2_.name ASC
) AS sclr_58
FROM
"sebii__video__video" s0_
LEFT JOIN sebii__video__video_category s6_ ON s0_.id = s6_.sebii__video__video__id
LEFT JOIN "sebii__category__category" s1_ ON s1_.id = s6_.sebii__category__category__id
LEFT JOIN sebii__category__category_universe s7_ ON s1_.id = s7_.sebii__category__category__id
LEFT JOIN "sebii__category__universe" s2_ ON s2_.id = s7_.sebii__category__universe__id
LEFT JOIN sebii__video__video_release s8_ ON s0_.id = s8_.sebii__video__video__id
LEFT JOIN "sebii__category__release" s3_ ON s3_.id = s8_.sebii__category__release__id
LEFT JOIN "sebii__category__platform" s4_ ON s3_.sebii__category__platform__id = s4_.id
LEFT JOIN "sebii__file__media" s5_ ON s0_.thumbnail__sebii__file__media__id = s5_.id
WHERE
s0_.displayed = true
) dctrn_result
GROUP BY
id_5
ORDER BY
dctrn_minrownum ASC
LIMIT
24
OFFSET
528
SELECT DISTINCT id_5, MIN(sclr_58) AS dctrn_minrownum FROM (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, s3_.name AS name_30, s3_.released_at AS released_at_31, s3_.date_type AS date_type_32, s3_.status AS status_33, s3_.id AS id_34, s3_.api_id AS api_id_35, s4_.name AS name_36, s4_.slug AS slug_37, s4_.abbreviation AS abbreviation_38, s4_.type AS type_39, s4_.family AS family_40, s4_.iconify_code AS iconify_code_41, s4_.id AS id_42, s4_.api_id AS api_id_43, s4_.displayed AS displayed_44, s4_.color AS color_45, s4_.created_at AS created_at_46, s4_.updated_at AS updated_at_47, s5_.checksum AS checksum_48, s5_.id AS id_49, s5_.api_id AS api_id_50, s5_.created_at AS created_at_51, s5_.updated_at AS updated_at_52, s5_.file_metadata_name AS file_metadata_name_53, s5_.file_metadata_original_name AS file_metadata_original_name_54, s5_.file_metadata_mime_type AS file_metadata_mime_type_55, s5_.file_metadata_size AS file_metadata_size_56, s5_.file_metadata_dimensions AS file_metadata_dimensions_57, ROW_NUMBER() OVER(ORDER BY s0_.recorded_at DESC, s2_.name ASC) AS sclr_58 FROM "sebii__video__video" s0_ LEFT JOIN sebii__video__video_category s6_ ON s0_.id = s6_.sebii__video__video__id LEFT JOIN "sebii__category__category" s1_ ON s1_.id = s6_.sebii__category__category__id LEFT JOIN sebii__category__category_universe s7_ ON s1_.id = s7_.sebii__category__category__id LEFT JOIN "sebii__category__universe" s2_ ON s2_.id = s7_.sebii__category__universe__id LEFT JOIN sebii__video__video_release s8_ ON s0_.id = s8_.sebii__video__video__id LEFT JOIN "sebii__category__release" s3_ ON s3_.id = s8_.sebii__category__release__id LEFT JOIN "sebii__category__platform" s4_ ON s3_.sebii__category__platform__id = s4_.id LEFT JOIN "sebii__file__media" s5_ ON s0_.thumbnail__sebii__file__media__id = s5_.id WHERE s0_.displayed = true) dctrn_result GROUP BY id_5 ORDER BY dctrn_minrownum ASC LIMIT 24 OFFSET 528;
|
| 11 |
8.96 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, s3_.name AS name_30, s3_.released_at AS released_at_31, s3_.date_type AS date_type_32, s3_.status AS status_33, s3_.id AS id_34, s3_.api_id AS api_id_35, s4_.name AS name_36, s4_.slug AS slug_37, s4_.abbreviation AS abbreviation_38, s4_.type AS type_39, s4_.family AS family_40, s4_.iconify_code AS iconify_code_41, s4_.id AS id_42, s4_.api_id AS api_id_43, s4_.displayed AS displayed_44, s4_.color AS color_45, s4_.created_at AS created_at_46, s4_.updated_at AS updated_at_47, s5_.checksum AS checksum_48, s5_.id AS id_49, s5_.api_id AS api_id_50, s5_.created_at AS created_at_51, s5_.updated_at AS updated_at_52, s5_.file_metadata_name AS file_metadata_name_53, s5_.file_metadata_original_name AS file_metadata_original_name_54, s5_.file_metadata_mime_type AS file_metadata_mime_type_55, s5_.file_metadata_size AS file_metadata_size_56, s5_.file_metadata_dimensions AS file_metadata_dimensions_57, s0_.thumbnail__sebii__file__media__id AS thumbnail__sebii__file__media__id_58, s1_.cover__sebii__file__media__id AS cover__sebii__file__media__id_59, s1_.background__sebii__file__media__id AS background__sebii__file__media__id_60, s2_.cover__sebii__file__media__id AS cover__sebii__file__media__id_61, s2_.background__sebii__file__media__id AS background__sebii__file__media__id_62, s3_.sebii__category__category__id AS sebii__category__category__id_63, s3_.sebii__category__platform__id AS sebii__category__platform__id_64, s3_.cover__sebii__file__media__id AS cover__sebii__file__media__id_65, s4_.logo__sebii__file__media__id AS logo__sebii__file__media__id_66 FROM "sebii__video__video" s0_ LEFT JOIN sebii__video__video_category s6_ ON s0_.id = s6_.sebii__video__video__id LEFT JOIN "sebii__category__category" s1_ ON s1_.id = s6_.sebii__category__category__id LEFT JOIN sebii__category__category_universe s7_ ON s1_.id = s7_.sebii__category__category__id LEFT JOIN "sebii__category__universe" s2_ ON s2_.id = s7_.sebii__category__universe__id LEFT JOIN sebii__video__video_release s8_ ON s0_.id = s8_.sebii__video__video__id LEFT JOIN "sebii__category__release" s3_ ON s3_.id = s8_.sebii__category__release__id LEFT JOIN "sebii__category__platform" s4_ ON s3_.sebii__category__platform__id = s4_.id LEFT JOIN "sebii__file__media" s5_ ON s0_.thumbnail__sebii__file__media__id = s5_.id WHERE s0_.displayed = true AND s0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) ORDER BY s0_.recorded_at DESC, s2_.name ASC
Parameters: [
"018fe01e-c454-78ec-99d0-87f5551e28d3"
"018fe01e-aed8-7563-9f1b-706b03a7a2b0"
"018fe01e-ba72-76a7-8e64-70a544602492"
"018fe01e-bf98-7f54-82cd-1872f63aba9c"
"018fe01e-e8d5-72db-ab44-4ec7933df848"
"018fe01e-bf84-76ad-8f7c-6a6a6baec437"
"018fe01e-b61a-7aab-b35a-3e6c8d6b1e6a"
"018fe01e-edb2-71ff-9f53-58faef52be43"
"018fe01e-ce4a-79c7-9cc0-b679feb3418c"
"018fe01e-db5d-754a-9c18-87125fc4431b"
"018fe01e-e8e4-7312-aa72-2e9603a791d2"
"018fe01f-409c-737b-af02-2b7f62fbf8eb"
"018fe01e-edf1-7401-a1ed-bccb33012d91"
"018fe01e-cbdb-7992-90af-0ed44d804088"
"018fe01e-ef36-7d0a-a0ec-e92bd7454899"
"018fe01e-d239-73bd-89c8-7a97d1457736"
"018fe01e-cbb2-78f6-9394-06455f215d7f"
"018fe01e-bbe4-76e4-8783-c2dbfe3da661"
"018fe01e-bcfc-7929-8be2-f0f72ce262ae"
"018fe01e-e67f-7fea-8e4b-e525b952b258"
"018fe01e-b8e9-73b2-8901-570023f71746"
"01902d89-dd22-7d89-b09f-62d80b069fe5"
"01902d8f-1f95-72d7-b7db-26ab8e21ee49"
"019396e2-90ed-704e-9aff-fbf57a370a63"
]
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,
s3_.name AS name_30,
s3_.released_at AS released_at_31,
s3_.date_type AS date_type_32,
s3_.status AS status_33,
s3_.id AS id_34,
s3_.api_id AS api_id_35,
s4_.name AS name_36,
s4_.slug AS slug_37,
s4_.abbreviation AS abbreviation_38,
s4_.type AS type_39,
s4_.family AS family_40,
s4_.iconify_code AS iconify_code_41,
s4_.id AS id_42,
s4_.api_id AS api_id_43,
s4_.displayed AS displayed_44,
s4_.color AS color_45,
s4_.created_at AS created_at_46,
s4_.updated_at AS updated_at_47,
s5_.checksum AS checksum_48,
s5_.id AS id_49,
s5_.api_id AS api_id_50,
s5_.created_at AS created_at_51,
s5_.updated_at AS updated_at_52,
s5_.file_metadata_name AS file_metadata_name_53,
s5_.file_metadata_original_name AS file_metadata_original_name_54,
s5_.file_metadata_mime_type AS file_metadata_mime_type_55,
s5_.file_metadata_size AS file_metadata_size_56,
s5_.file_metadata_dimensions AS file_metadata_dimensions_57,
s0_.thumbnail__sebii__file__media__id AS thumbnail__sebii__file__media__id_58,
s1_.cover__sebii__file__media__id AS cover__sebii__file__media__id_59,
s1_.background__sebii__file__media__id AS background__sebii__file__media__id_60,
s2_.cover__sebii__file__media__id AS cover__sebii__file__media__id_61,
s2_.background__sebii__file__media__id AS background__sebii__file__media__id_62,
s3_.sebii__category__category__id AS sebii__category__category__id_63,
s3_.sebii__category__platform__id AS sebii__category__platform__id_64,
s3_.cover__sebii__file__media__id AS cover__sebii__file__media__id_65,
s4_.logo__sebii__file__media__id AS logo__sebii__file__media__id_66
FROM
"sebii__video__video" s0_
LEFT JOIN sebii__video__video_category s6_ ON s0_.id = s6_.sebii__video__video__id
LEFT JOIN "sebii__category__category" s1_ ON s1_.id = s6_.sebii__category__category__id
LEFT JOIN sebii__category__category_universe s7_ ON s1_.id = s7_.sebii__category__category__id
LEFT JOIN "sebii__category__universe" s2_ ON s2_.id = s7_.sebii__category__universe__id
LEFT JOIN sebii__video__video_release s8_ ON s0_.id = s8_.sebii__video__video__id
LEFT JOIN "sebii__category__release" s3_ ON s3_.id = s8_.sebii__category__release__id
LEFT JOIN "sebii__category__platform" s4_ ON s3_.sebii__category__platform__id = s4_.id
LEFT JOIN "sebii__file__media" s5_ ON s0_.thumbnail__sebii__file__media__id = s5_.id
WHERE
s0_.displayed = true
AND s0_.id IN (
?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
?, ?, ?, ?, ?, ?, ?, ?
)
ORDER BY
s0_.recorded_at DESC,
s2_.name ASC
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, s3_.name AS name_30, s3_.released_at AS released_at_31, s3_.date_type AS date_type_32, s3_.status AS status_33, s3_.id AS id_34, s3_.api_id AS api_id_35, s4_.name AS name_36, s4_.slug AS slug_37, s4_.abbreviation AS abbreviation_38, s4_.type AS type_39, s4_.family AS family_40, s4_.iconify_code AS iconify_code_41, s4_.id AS id_42, s4_.api_id AS api_id_43, s4_.displayed AS displayed_44, s4_.color AS color_45, s4_.created_at AS created_at_46, s4_.updated_at AS updated_at_47, s5_.checksum AS checksum_48, s5_.id AS id_49, s5_.api_id AS api_id_50, s5_.created_at AS created_at_51, s5_.updated_at AS updated_at_52, s5_.file_metadata_name AS file_metadata_name_53, s5_.file_metadata_original_name AS file_metadata_original_name_54, s5_.file_metadata_mime_type AS file_metadata_mime_type_55, s5_.file_metadata_size AS file_metadata_size_56, s5_.file_metadata_dimensions AS file_metadata_dimensions_57, s0_.thumbnail__sebii__file__media__id AS thumbnail__sebii__file__media__id_58, s1_.cover__sebii__file__media__id AS cover__sebii__file__media__id_59, s1_.background__sebii__file__media__id AS background__sebii__file__media__id_60, s2_.cover__sebii__file__media__id AS cover__sebii__file__media__id_61, s2_.background__sebii__file__media__id AS background__sebii__file__media__id_62, s3_.sebii__category__category__id AS sebii__category__category__id_63, s3_.sebii__category__platform__id AS sebii__category__platform__id_64, s3_.cover__sebii__file__media__id AS cover__sebii__file__media__id_65, s4_.logo__sebii__file__media__id AS logo__sebii__file__media__id_66 FROM "sebii__video__video" s0_ LEFT JOIN sebii__video__video_category s6_ ON s0_.id = s6_.sebii__video__video__id LEFT JOIN "sebii__category__category" s1_ ON s1_.id = s6_.sebii__category__category__id LEFT JOIN sebii__category__category_universe s7_ ON s1_.id = s7_.sebii__category__category__id LEFT JOIN "sebii__category__universe" s2_ ON s2_.id = s7_.sebii__category__universe__id LEFT JOIN sebii__video__video_release s8_ ON s0_.id = s8_.sebii__video__video__id LEFT JOIN "sebii__category__release" s3_ ON s3_.id = s8_.sebii__category__release__id LEFT JOIN "sebii__category__platform" s4_ ON s3_.sebii__category__platform__id = s4_.id LEFT JOIN "sebii__file__media" s5_ ON s0_.thumbnail__sebii__file__media__id = s5_.id WHERE s0_.displayed = true AND s0_.id IN ('018fe01e-c454-78ec-99d0-87f5551e28d3', '018fe01e-aed8-7563-9f1b-706b03a7a2b0', '018fe01e-ba72-76a7-8e64-70a544602492', '018fe01e-bf98-7f54-82cd-1872f63aba9c', '018fe01e-e8d5-72db-ab44-4ec7933df848', '018fe01e-bf84-76ad-8f7c-6a6a6baec437', '018fe01e-b61a-7aab-b35a-3e6c8d6b1e6a', '018fe01e-edb2-71ff-9f53-58faef52be43', '018fe01e-ce4a-79c7-9cc0-b679feb3418c', '018fe01e-db5d-754a-9c18-87125fc4431b', '018fe01e-e8e4-7312-aa72-2e9603a791d2', '018fe01f-409c-737b-af02-2b7f62fbf8eb', '018fe01e-edf1-7401-a1ed-bccb33012d91', '018fe01e-cbdb-7992-90af-0ed44d804088', '018fe01e-ef36-7d0a-a0ec-e92bd7454899', '018fe01e-d239-73bd-89c8-7a97d1457736', '018fe01e-cbb2-78f6-9394-06455f215d7f', '018fe01e-bbe4-76e4-8783-c2dbfe3da661', '018fe01e-bcfc-7929-8be2-f0f72ce262ae', '018fe01e-e67f-7fea-8e4b-e525b952b258', '018fe01e-b8e9-73b2-8901-570023f71746', '01902d89-dd22-7d89-b09f-62d80b069fe5', '01902d8f-1f95-72d7-b7db-26ab8e21ee49', '019396e2-90ed-704e-9aff-fbf57a370a63') ORDER BY s0_.recorded_at DESC, s2_.name ASC;
|
| 12 |
0.70 ms |
SELECT t0.checksum AS checksum_1, t0.id AS id_2, t0.api_id AS api_id_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.file_metadata_name AS file_metadata_name_6, t0.file_metadata_original_name AS file_metadata_original_name_7, t0.file_metadata_mime_type AS file_metadata_mime_type_8, t0.file_metadata_size AS file_metadata_size_9, t0.file_metadata_dimensions AS file_metadata_dimensions_10 FROM "sebii__file__media" t0 WHERE t0.id = ?
Parameters: [
"018fe009-a3ed-7e2d-aab2-9cecb556edd8"
]
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-a3ed-7e2d-aab2-9cecb556edd8';
|
| 13 |
0.63 ms |
SELECT t0.checksum AS checksum_1, t0.id AS id_2, t0.api_id AS api_id_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.file_metadata_name AS file_metadata_name_6, t0.file_metadata_original_name AS file_metadata_original_name_7, t0.file_metadata_mime_type AS file_metadata_mime_type_8, t0.file_metadata_size AS file_metadata_size_9, t0.file_metadata_dimensions AS file_metadata_dimensions_10 FROM "sebii__file__media" t0 WHERE t0.id = ?
Parameters: [
"018fe009-a42b-78d1-9f82-be088a6d4e3f"
]
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-a42b-78d1-9f82-be088a6d4e3f';
|
| 14 |
0.59 ms |
SELECT t0.checksum AS checksum_1, t0.id AS id_2, t0.api_id AS api_id_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.file_metadata_name AS file_metadata_name_6, t0.file_metadata_original_name AS file_metadata_original_name_7, t0.file_metadata_mime_type AS file_metadata_mime_type_8, t0.file_metadata_size AS file_metadata_size_9, t0.file_metadata_dimensions AS file_metadata_dimensions_10 FROM "sebii__file__media" t0 WHERE t0.id = ?
Parameters: [
"018fe009-ab3c-79a7-bb77-7f5ba9255340"
]
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-ab3c-79a7-bb77-7f5ba9255340';
|
| 15 |
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: [
"018fe009-a446-7a00-8e69-7b406ffa2066"
]
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-a446-7a00-8e69-7b406ffa2066';
|
| 16 |
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: [
"018fe009-a8a2-7e4d-bd16-09491d56e26b"
]
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-a8a2-7e4d-bd16-09491d56e26b';
|
| 17 |
0.53 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';
|
| 18 |
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: [
"018fe009-b675-7095-8a6c-bb19edcbc191"
]
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-b675-7095-8a6c-bb19edcbc191';
|
| 19 |
0.66 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-b1a0-7caf-a134-8f1c53f778dc"
]
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-b1a0-7caf-a134-8f1c53f778dc';
|
| 20 |
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: [
"018fe009-a3c5-7217-b71d-8b464da315b0"
]
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-a3c5-7217-b71d-8b464da315b0';
|
| 21 |
0.54 ms |
SELECT t0.checksum AS checksum_1, t0.id AS id_2, t0.api_id AS api_id_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.file_metadata_name AS file_metadata_name_6, t0.file_metadata_original_name AS file_metadata_original_name_7, t0.file_metadata_mime_type AS file_metadata_mime_type_8, t0.file_metadata_size AS file_metadata_size_9, t0.file_metadata_dimensions AS file_metadata_dimensions_10 FROM "sebii__file__media" t0 WHERE t0.id = ?
Parameters: [
"018fe009-b178-72dd-aca7-0fc8f6bb1c53"
]
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-b178-72dd-aca7-0fc8f6bb1c53';
|
| 22 |
0.67 ms |
SELECT t0.checksum AS checksum_1, t0.id AS id_2, t0.api_id AS api_id_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.file_metadata_name AS file_metadata_name_6, t0.file_metadata_original_name AS file_metadata_original_name_7, t0.file_metadata_mime_type AS file_metadata_mime_type_8, t0.file_metadata_size AS file_metadata_size_9, t0.file_metadata_dimensions AS file_metadata_dimensions_10 FROM "sebii__file__media" t0 WHERE t0.id = ?
Parameters: [
"018fe009-aca2-70f7-9041-2757eba272e5"
]
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-aca2-70f7-9041-2757eba272e5';
|
| 23 |
0.53 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';
|
| 24 |
0.64 ms |
SELECT t0.checksum AS checksum_1, t0.id AS id_2, t0.api_id AS api_id_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.file_metadata_name AS file_metadata_name_6, t0.file_metadata_original_name AS file_metadata_original_name_7, t0.file_metadata_mime_type AS file_metadata_mime_type_8, t0.file_metadata_size AS file_metadata_size_9, t0.file_metadata_dimensions AS file_metadata_dimensions_10 FROM "sebii__file__media" t0 WHERE t0.id = ?
Parameters: [
"01902d55-7a02-7113-8195-6214200509d6"
]
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 = '01902d55-7a02-7113-8195-6214200509d6';
|
| 25 |
2.70 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;
|
| 26 |
2.93 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;
|