GET https://sebii.dev/videos/2/u:assassin-s-creed,v:vod

Query Metrics

17 Database Queries
13 Different statements
59.90 ms Query time
0 Invalid entities

Queries

Group similar statements

# Time Info
1 5.59 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.40 ms
"START TRANSACTION"
Parameters:
[]
3 3.05 ms
INSERT INTO sebii__messenger__message (body, headers, queue_name, created_at, available_at) VALUES(?, ?, ?, ?, ?) RETURNING id
Parameters:
[
  "O:36:\"Symfony\\Component\\Messenger\\Envelope\":2:{s:44:\"\0Symfony\\Component\\Messenger\\Envelope\0stamps\";a:1:{s:46:\"Symfony\\Component\\Messenger\\Stamp\\BusNameStamp\";a:1:{i:0;O:46:\"Symfony\\Component\\Messenger\\Stamp\\BusNameStamp\":1:{s:55:\"\0Symfony\\Component\\Messenger\\Stamp\\BusNameStamp\0busName\";s:21:\"messenger.bus.default\";}}}s:45:\"\0Symfony\\Component\\Messenger\\Envelope\0message\";O:46:\"App\\Messenger\\Message\\Security\\AnalyticMessage\":6:{s:50:\"\0App\\Messenger\\Message\\Security\\AnalyticMessage\0at\";O:8:\"DateTime\":3:{s:4:\"date\";s:26:\"2025-04-19 20:32:22.475221\";s:13:\"timezone_type\";i:3;s:8:\"timezone\";s:3:\"UTC\";}s:52:\"\0App\\Messenger\\Message\\Security\\AnalyticMessage\0page\";s:34:\"/videos/2/u:assassin-s-creed,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-19 20:32:22"
  "2025-04-19 20:32:22"
]
4 2.30 ms
"COMMIT"
Parameters:
[]
5 4.04 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_.checksum AS checksum_9, s1_.id AS id_10, s1_.api_id AS api_id_11, s1_.created_at AS created_at_12, s1_.updated_at AS updated_at_13, s1_.file_metadata_name AS file_metadata_name_14, s1_.file_metadata_original_name AS file_metadata_original_name_15, s1_.file_metadata_mime_type AS file_metadata_mime_type_16, s1_.file_metadata_size AS file_metadata_size_17, s1_.file_metadata_dimensions AS file_metadata_dimensions_18, s0_.cover__sebii__file__media__id AS cover__sebii__file__media__id_19, s0_.background__sebii__file__media__id AS background__sebii__file__media__id_20 FROM "sebii__category__universe" s0_ LEFT JOIN "sebii__file__media" s1_ ON s0_.cover__sebii__file__media__id = s1_.id WHERE s0_.slug = ?
Parameters:
[
  "assassin-s-creed"
]
6 14.68 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 AND s2_.id IN (?) ORDER BY s0_.recorded_at DESC, s2_.name ASC) dctrn_result) dctrn_table
Parameters:
[
  Symfony\Component\Uid\UuidV7 {#2045
    __toString(): "018fdade-020b-772a-b875-de502dd6d0ce"
  }
]
7 1.06 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
Parameters:
[]
8 3.21 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:
[]
9 1.03 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"
]
10 0.83 ms
SELECT COUNT(s0_.id) AS sclr_0 FROM "sebii__video__video" s0_ WHERE s0_.type = ?
Parameters:
[
  "live"
]
11 6.27 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 AND s2_.id IN (?)) dctrn_result GROUP BY id_5 ORDER BY dctrn_minrownum ASC LIMIT 24 OFFSET 24
Parameters:
[
  Symfony\Component\Uid\UuidV7 {#2045
    __toString(): "018fdade-020b-772a-b875-de502dd6d0ce"
  }
]
12 8.78 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 s2_.id IN (?) AND s0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) ORDER BY s0_.recorded_at DESC, s2_.name ASC
Parameters:
[
  Symfony\Component\Uid\UuidV7 {#2045
    __toString(): "018fdade-020b-772a-b875-de502dd6d0ce"
  }
  "018fe01e-d5d0-75e9-8366-4cd5629b7cdc"
  "018fe01f-3d2b-7915-af1d-28366c6e7a5f"
  "018fe01e-b4de-7654-9195-eca8180fbf95"
  "018fe4bf-bfc1-77c0-add3-51b7af6e522e"
  "018fe01e-c30c-7986-81e6-56bb392ff580"
  "018fe01f-40b7-75e4-8b5f-9ec04fe39fb7"
  "018fe01e-ea41-7a17-88fb-e9fce471716a"
  "0193abdd-ad8e-7b73-8835-838054a12932"
  "0193abdb-e1d7-74f3-9da6-b850eb783476"
  "0193abda-a7dd-75c6-bfe2-8ff4e2206a4d"
  "0193abd9-5c30-7644-a4cc-4b891ada092e"
  "0193abd8-2aab-7637-b723-5492dfadf8ae"
  "0193abd5-483d-7544-a934-f37a40a28ab6"
  "018fe01f-40b1-7923-b339-52bc156a8ed0"
  "018fe01e-e7a2-76c9-a7aa-8940068f4985"
  "018fe01e-cd15-731d-94fa-9b919e65483f"
  "018fe01e-e7c7-7bf9-bacf-dde37d2cb1fb"
  "018fe01e-c802-7bc5-af85-cc4f32aad9e7"
  "018fe01e-aecd-7fc6-9de5-29b151009905"
  "018fe01e-cbd4-7298-ba8a-d7f81613c419"
  "018fe01e-c823-7fea-952c-9da06d3d127f"
  "018fe01e-b628-73c7-95b1-a04b0478f365"
  "018fe01f-3e65-7212-9ff4-74cea755f5f5"
  "018fe01e-e1b2-7200-9b91-95f90d0cef19"
]
13 1.07 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-a8f5-7d35-99db-f0dae4cfc2c1"
]
14 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-b965-7eb4-a0a5-9856e94fd8f9"
]
15 1.14 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-a403-792d-bc88-f5526c7fd9bd"
]
16 2.83 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:
[]
17 2.91 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.