GET https://sebii.dev/video/0190230d-cb74-7698-9cd0-211db7d366d5

Query Metrics

52 Database Queries
17 Different statements
73.61 ms Query time
0 Invalid entities

Queries

Group similar statements

# Time Info
1 4.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"
]
2 0.42 ms
"START TRANSACTION"
Parameters:
[]
3 3.77 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-24 09:32:45.054729\";s:13:\"timezone_type\";i:3;s:8:\"timezone\";s:3:\"UTC\";}s:52:\"\0App\\Messenger\\Message\\Security\\AnalyticMessage\0page\";s:43:\"/video/0190230d-cb74-7698-9cd0-211db7d366d5\";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-24 09:32:45"
  "2025-04-24 09:32:45"
]
4 2.68 ms
"COMMIT"
Parameters:
[]
5 2.73 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:
[
  "0190230d-cb74-7698-9cd0-211db7d366d5"
]
6 4.84 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
Parameters:
[]
7 5.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:
[
  "0190230d-cb74-7698-9cd0-211db7d366d5"
]
8 0.81 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"
]
9 1.18 ms
SELECT COUNT(s0_.id) AS sclr_0 FROM "sebii__video__video" s0_ WHERE s0_.type = ?
Parameters:
[
  "live"
]
10 3.92 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:
[
  "0190230d-cb74-7698-9cd0-211db7d366d5"
]
11 2.12 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-a3bb-79fe-888c-08fe6bf0d097"
]
12 3.12 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:
[
  "0190230d-cb74-7698-9cd0-211db7d366d5"
]
13 2.75 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:
[
  "01907fce-0f43-7b76-9959-9878a254fa03"
]
14 2.74 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:
[
  "0190230d-cb74-7698-9cd0-211db7d366d5"
]
15 0.83 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-862e-7507-9968-40ca3ebdccfe"
]
16 1.78 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-862e-7507-9968-40ca3ebdccfe"
]
17 0.73 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:
[
  "019022fe-59c3-724f-a4ed-afbcc6cce008"
]
18 0.57 ms
SELECT t0.checksum AS checksum_1, t0.id AS id_2, t0.api_id AS api_id_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.file_metadata_name AS file_metadata_name_6, t0.file_metadata_original_name AS file_metadata_original_name_7, t0.file_metadata_mime_type AS file_metadata_mime_type_8, t0.file_metadata_size AS file_metadata_size_9, t0.file_metadata_dimensions AS file_metadata_dimensions_10 FROM "sebii__file__media" t0 WHERE t0.id = ?
Parameters:
[
  "019022fe-8d01-7c1f-bb37-aa9dd6a2c1b4"
]
19 0.72 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:
[
  "019022f8-6633-70d5-80e6-d9566de4e62a"
]
20 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:
[
  "019022f9-14ff-7281-8ced-448e415bb936"
]
21 0.60 ms
SELECT t0.name AS name_1, t0.type AS type_2, t0.description AS description_3, t0.recorded_at AS recorded_at_4, t0.duration AS duration_5, t0.id AS id_6, t0.api_id AS api_id_7, t0.displayed AS displayed_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10, t0.thumbnail__sebii__file__media__id AS thumbnail__sebii__file__media__id_11 FROM "sebii__video__video" t0 WHERE t0.id = ?
Parameters:
[
  "01902305-74b4-7bc4-8e25-770d1a5b6b0b"
]
22 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:
[
  "01902305-9d5f-7a51-b0df-64b0d76bc1d2"
]
23 0.99 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:
[
  "01902308-9187-70d8-8f10-6b4f5f5df1bc"
]
24 0.72 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:
[
  "01902308-b88c-7972-a59e-c18d1e4bfa97"
]
25 0.62 ms
SELECT t0.checksum AS checksum_1, t0.id AS id_2, t0.api_id AS api_id_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.file_metadata_name AS file_metadata_name_6, t0.file_metadata_original_name AS file_metadata_original_name_7, t0.file_metadata_mime_type AS file_metadata_mime_type_8, t0.file_metadata_size AS file_metadata_size_9, t0.file_metadata_dimensions AS file_metadata_dimensions_10 FROM "sebii__file__media" t0 WHERE t0.id = ?
Parameters:
[
  "0190230d-e725-72bc-83fd-7b512a18c696"
]
26 0.72 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:
[
  "01902310-7980-72a5-8bcf-84baf5449382"
]
27 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:
[
  "01902310-9b43-71ef-ae9a-3ee5d18c0cc4"
]
28 0.67 ms
SELECT t0.name AS name_1, t0.type AS type_2, t0.description AS description_3, t0.recorded_at AS recorded_at_4, t0.duration AS duration_5, t0.id AS id_6, t0.api_id AS api_id_7, t0.displayed AS displayed_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10, t0.thumbnail__sebii__file__media__id AS thumbnail__sebii__file__media__id_11 FROM "sebii__video__video" t0 WHERE t0.id = ?
Parameters:
[
  "01902312-c9ba-77da-97a1-210a05339672"
]
29 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:
[
  "01902312-ee8b-7e3f-ab77-5d40c018d6f4"
]
30 0.72 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:
[
  "01902301-aafa-7efe-8a56-a43e9684e546"
]
31 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:
[
  "01902301-c79e-70f1-9088-48e752c95c3f"
]
32 0.71 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-b754-773a-9d44-c961caacca81"
]
33 0.81 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-b75a-7722-9d76-8433d753a290"
]
34 1.23 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-aeac-7404-a385-9dc7c54d760c"
]
35 0.82 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-aeae-7dc4-bf57-fe44b50e4ac5"
]
36 0.76 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:
[
  "018fe4bf-78f9-7eff-8543-719aa44ff05c"
]
37 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:
[
  "018fe4bf-78fd-7234-9601-915353ed8888"
]
38 0.72 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-ba79-7636-9708-98d4ea29c2e2"
]
39 0.77 ms
SELECT t0.checksum AS checksum_1, t0.id AS id_2, t0.api_id AS api_id_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.file_metadata_name AS file_metadata_name_6, t0.file_metadata_original_name AS file_metadata_original_name_7, t0.file_metadata_mime_type AS file_metadata_mime_type_8, t0.file_metadata_size AS file_metadata_size_9, t0.file_metadata_dimensions AS file_metadata_dimensions_10 FROM "sebii__file__media" t0 WHERE t0.id = ?
Parameters:
[
  "018fe01e-ba7b-794f-81df-6307996fef9b"
]
40 0.76 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-d478-75cd-b694-b07e48558217"
]
41 0.60 ms
SELECT t0.checksum AS checksum_1, t0.id AS id_2, t0.api_id AS api_id_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.file_metadata_name AS file_metadata_name_6, t0.file_metadata_original_name AS file_metadata_original_name_7, t0.file_metadata_mime_type AS file_metadata_mime_type_8, t0.file_metadata_size AS file_metadata_size_9, t0.file_metadata_dimensions AS file_metadata_dimensions_10 FROM "sebii__file__media" t0 WHERE t0.id = ?
Parameters:
[
  "018fe01e-d47a-73e7-9ea8-93762e2ec350"
]
42 0.73 ms
SELECT t0.is_main AS is_main_1, t0.position AS position_2, t0.id AS id_3, t0.api_id AS api_id_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.sebii__video__playlist__id AS sebii__video__playlist__id_7, t0.sebii__video__video__id AS sebii__video__video__id_8 FROM "sebii__video__playlist_item" t0 WHERE t0.sebii__video__playlist__id = ? ORDER BY t0.position ASC
Parameters:
[
  "0190dc9f-e81b-7f80-b5ce-6329e282d1ef"
]
43 0.58 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:
[
  "0190dfc9-3ae9-7852-9445-2e85deddad3e"
]
44 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:
[
  "0190e9c3-10a2-77b5-bc71-1d355518266c"
]
45 0.82 ms
SELECT t0.is_main AS is_main_1, t0.position AS position_2, t0.id AS id_3, t0.api_id AS api_id_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.sebii__video__playlist__id AS sebii__video__playlist__id_7, t0.sebii__video__video__id AS sebii__video__video__id_8 FROM "sebii__video__playlist_item" t0 WHERE t0.sebii__video__playlist__id = ? ORDER BY t0.position ASC
Parameters:
[
  "018fdffc-9607-75c2-8b24-66c880b45069"
]
46 0.62 ms
SELECT t0.name AS name_1, t0.type AS type_2, t0.description AS description_3, t0.recorded_at AS recorded_at_4, t0.duration AS duration_5, t0.id AS id_6, t0.api_id AS api_id_7, t0.displayed AS displayed_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10, t0.thumbnail__sebii__file__media__id AS thumbnail__sebii__file__media__id_11 FROM "sebii__video__video" t0 WHERE t0.id = ?
Parameters:
[
  "018fe01e-cd25-725c-a8c9-47395e782967"
]
47 0.65 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:
[
  "0193a331-65a5-75d1-a02c-d5f046130b2d"
]
48 1.02 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-a1df-75a5-aa34-79a1e94474e7"
]
49 0.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-b908-72ed-b5bb-09f158044d17"
]
50 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:
[
  "01938cfc-cb29-72fd-b952-031a41e06519"
]
51 1.55 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
Parameters:
[]
52 3.55 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
Parameters:
[]

Database Connections

Name Service
default doctrine.dbal.default_connection

Entity Managers

Name Service
default doctrine.orm.default_entity_manager

Second Level Cache

Second Level Cache is not enabled.