GET https://www.sebii.dev/videos/1/p:android,p:nintendo-ds,p:pc,p:playstation-4,p:xbox-one,u:ace-attorney,u:assassin-s-creed,u:halo,u:picross,u:power-rangers,u:prof…

Response
200 OK
IP
172.19.0.1
Profiled on
Token
b81400

Query Metrics

27 Database Queries
13 Different statements
77.68 ms Query time
0 Invalid entities

Group similar statements

#â–˛ Time Info
1 6.26 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: 
  0 of 0   
[â–Ľ
  "www.sebii.dev"
]
View formatted query    View runnable query    Explain query    View query backtrace
2 0.46 ms 
"START TRANSACTION"
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
3 3.49 ms 
INSERT INTO sebii__messenger__message (body, headers, queue_name, created_at, available_at) VALUES(?, ?, ?, ?, ?) RETURNING id
Parameters: 
  0 of 0   
[â–Ľ
  "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-05-20 09:19:53.015689\";s:13:\"timezone_type\";i:3;s:8:\"timezone\";s:3:\"UTC\";}s:52:\"\0App\\Messenger\\Message\\Security\\AnalyticMessage\0page\";s:201:\"/videos/1/p:android,p:nintendo-ds,p:pc,p:playstation-4,p:xbox-one,u:ace-attorney,u:assassin-s-creed,u:halo,u:picross,u:power-rangers,u:professeur-layton,u:resident-evil,u:tetris-99,u:the-lapins-cretins\";s:54:\"\0App\\Messenger\\Message\\Security\\AnalyticMessage\0domain\";s:13:\"www.sebii.dev\";s:57:\"\0App\\Messenger\\Message\\Security\\AnalyticMessage\0ipAddress\";s:10:\"172.19.0.1\";s:57:\"\0App\\Messenger\\Message\\Security\\AnalyticMessage\0userAgent\";s:102:\"Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; GPTBot/1.2; +https://openai.com/gptbot)\";s:56:\"\0App\\Messenger\\Message\\Security\\AnalyticMessage\0referrer\";N;}}"
  "[]"
  "security_analytic"
  "2025-05-20 09:19:53"
  "2025-05-20 09:19:53"
]
View formatted query    View runnable query    Explain query    View query backtrace
4 2.71 ms 
"COMMIT"
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
5 1.77 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.slug = ? LIMIT 1
Parameters: 
  0 of 0   
[â–Ľ
  "android"
]
View formatted query    View runnable query    Explain query    View query backtrace
6 1.01 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.slug = ? LIMIT 1
Parameters: 
  0 of 0   
[â–Ľ
  "nintendo-ds"
]
View formatted query    View runnable query    Explain query    View query backtrace
7 0.65 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.slug = ? LIMIT 1
Parameters: 
  0 of 0   
[â–Ľ
  "pc"
]
View formatted query    View runnable query    Explain query    View query backtrace
8 0.49 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.slug = ? LIMIT 1
Parameters: 
  0 of 0   
[â–Ľ
  "playstation-4"
]
View formatted query    View runnable query    Explain query    View query backtrace
9 0.35 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.slug = ? LIMIT 1
Parameters: 
  0 of 0   
[â–Ľ
  "xbox-one"
]
View formatted query    View runnable query    Explain query    View query backtrace
10 4.45 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: 
  0 of 0   
[â–Ľ
  "ace-attorney"
]
View formatted query    View runnable query    Explain query    View query backtrace
11 0.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_.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: 
  0 of 0   
[â–Ľ
  "assassin-s-creed"
]
View formatted query    View runnable query    Explain query    View query backtrace
12 0.90 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: 
  0 of 0   
[â–Ľ
  "halo"
]
View formatted query    View runnable query    Explain query    View query backtrace
13 0.81 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: 
  0 of 0   
[â–Ľ
  "picross"
]
View formatted query    View runnable query    Explain query    View query backtrace
14 0.72 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: 
  0 of 0   
[â–Ľ
  "power-rangers"
]
View formatted query    View runnable query    Explain query    View query backtrace
15 0.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_.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: 
  0 of 0   
[â–Ľ
  "professeur-layton"
]
View formatted query    View runnable query    Explain query    View query backtrace
16 1.00 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: 
  0 of 0   
[â–Ľ
  "resident-evil"
]
View formatted query    View runnable query    Explain query    View query backtrace
17 0.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_.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: 
  0 of 0   
[â–Ľ
  "tetris-99"
]
View formatted query    View runnable query    Explain query    View query backtrace
18 0.80 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: 
  0 of 0   
[â–Ľ
  "the-lapins-cretins"
]
View formatted query    View runnable query    Explain query    View query backtrace
19 15.02 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, s6_.checksum AS checksum_58, s6_.id AS id_59, s6_.api_id AS api_id_60, s6_.created_at AS created_at_61, s6_.updated_at AS updated_at_62, s6_.file_metadata_name AS file_metadata_name_63, s6_.file_metadata_original_name AS file_metadata_original_name_64, s6_.file_metadata_mime_type AS file_metadata_mime_type_65, s6_.file_metadata_size AS file_metadata_size_66, s6_.file_metadata_dimensions AS file_metadata_dimensions_67 FROM "sebii__video__video" s0_ LEFT JOIN sebii__video__video_category s7_ ON s0_.id = s7_.sebii__video__video__id LEFT JOIN "sebii__category__category" s1_ ON s1_.id = s7_.sebii__category__category__id LEFT JOIN sebii__category__category_universe s8_ ON s1_.id = s8_.sebii__category__category__id LEFT JOIN "sebii__category__universe" s2_ ON s2_.id = s8_.sebii__category__universe__id LEFT JOIN sebii__video__video_release s9_ ON s0_.id = s9_.sebii__video__video__id LEFT JOIN "sebii__category__release" s3_ ON s3_.id = s9_.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 LEFT JOIN "sebii__file__media" s6_ ON s1_.cover__sebii__file__media__id = s6_.id WHERE s0_.displayed = true AND s2_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?) AND s3_.sebii__category__platform__id IN (?, ?, ?, ?, ?) ORDER BY s0_.recorded_at DESC, s2_.name ASC) dctrn_result) dctrn_table
Parameters: 
  0 of 0   
[â–Ľ
  Symfony\Component\Uid\UuidV7 {#2138 â–¶
    __toString(): "018fdadf-3718-75e2-8dad-0b55ca28f6ee"
  }
  Symfony\Component\Uid\UuidV7 {#2090 â–¶
    __toString(): "018fdade-020b-772a-b875-de502dd6d0ce"
  }
  Symfony\Component\Uid\UuidV7 {#2186 â–¶
    __toString(): "018fdadf-36f2-71d3-af4b-5138bfb34c7d"
  }
  Symfony\Component\Uid\UuidV7 {#2083 â–¶
    __toString(): "018fdadf-36e6-76a0-b6bb-ae9c4f3d76fc"
  }
  Symfony\Component\Uid\UuidV7 {#2364 â–¶
    __toString(): "018fdadf-36f5-746c-b73a-c6a0fe4cbc2e"
  }
  Symfony\Component\Uid\UuidV7 {#2371 â–¶
    __toString(): "018fdadf-3705-7bb1-99d8-84bf5ce7d4a7"
  }
  Symfony\Component\Uid\UuidV7 {#2381 â–¶
    __toString(): "018fdadf-372a-7b9a-8587-71faf340653d"
  }
  Symfony\Component\Uid\UuidV7 {#2391 â–¶
    __toString(): "018fdadf-371b-742c-a432-d7b87a705008"
  }
  Symfony\Component\Uid\UuidV7 {#2401 â–¶
    __toString(): "018fdadf-372d-7e2c-9f55-05dc4c1f31cb"
  }
  Symfony\Component\Uid\UuidV7 {#2044 â–¶
    __toString(): "0193b05c-e2bb-7380-8d85-9506f342a692"
  }
  Symfony\Component\Uid\UuidV7 {#2252 â–¶
    __toString(): "019083a6-4f5a-7d27-afbd-55b80b0a0957"
  }
  Symfony\Component\Uid\UuidV7 {#2236 â–¶
    __toString(): "019083ca-9f8d-7cbf-9a6f-b090b60c7189"
  }
  Symfony\Component\Uid\UuidV7 {#2220 â–¶
    __toString(): "01939bb4-89da-75bd-921a-84395c214876"
  }
  Symfony\Component\Uid\UuidV7 {#2209 â–¶
    __toString(): "019084e5-8ac9-77ae-a130-71bd78bbe2d7"
  }
]
View formatted query    View runnable query    View query backtrace
20 0.83 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: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
21 3.84 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: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
22 0.91 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: 
  0 of 0   
[â–Ľ
  "www.sebii.dev"
]
View formatted query    View runnable query    Explain query    View query backtrace
23 1.09 ms 
SELECT COUNT(s0_.id) AS sclr_0 FROM "sebii__video__video" s0_ WHERE s0_.type = ?
Parameters: 
  0 of 0   
[â–Ľ
  "live"
]
View formatted query    View runnable query    Explain query    View query backtrace
24 11.00 ms 
SELECT DISTINCT id_5, MIN(sclr_68) 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, s6_.checksum AS checksum_58, s6_.id AS id_59, s6_.api_id AS api_id_60, s6_.created_at AS created_at_61, s6_.updated_at AS updated_at_62, s6_.file_metadata_name AS file_metadata_name_63, s6_.file_metadata_original_name AS file_metadata_original_name_64, s6_.file_metadata_mime_type AS file_metadata_mime_type_65, s6_.file_metadata_size AS file_metadata_size_66, s6_.file_metadata_dimensions AS file_metadata_dimensions_67, ROW_NUMBER() OVER(ORDER BY s0_.recorded_at DESC, s2_.name ASC) AS sclr_68 FROM "sebii__video__video" s0_ LEFT JOIN sebii__video__video_category s7_ ON s0_.id = s7_.sebii__video__video__id LEFT JOIN "sebii__category__category" s1_ ON s1_.id = s7_.sebii__category__category__id LEFT JOIN sebii__category__category_universe s8_ ON s1_.id = s8_.sebii__category__category__id LEFT JOIN "sebii__category__universe" s2_ ON s2_.id = s8_.sebii__category__universe__id LEFT JOIN sebii__video__video_release s9_ ON s0_.id = s9_.sebii__video__video__id LEFT JOIN "sebii__category__release" s3_ ON s3_.id = s9_.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 LEFT JOIN "sebii__file__media" s6_ ON s1_.cover__sebii__file__media__id = s6_.id WHERE s0_.displayed = true AND s2_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?) AND s3_.sebii__category__platform__id IN (?, ?, ?, ?, ?)) dctrn_result GROUP BY id_5 ORDER BY dctrn_minrownum ASC LIMIT 24
Parameters: 
  0 of 0   
[â–Ľ
  Symfony\Component\Uid\UuidV7 {#2138 â–¶
    __toString(): "018fdadf-3718-75e2-8dad-0b55ca28f6ee"
  }
  Symfony\Component\Uid\UuidV7 {#2090 â–¶
    __toString(): "018fdade-020b-772a-b875-de502dd6d0ce"
  }
  Symfony\Component\Uid\UuidV7 {#2186 â–¶
    __toString(): "018fdadf-36f2-71d3-af4b-5138bfb34c7d"
  }
  Symfony\Component\Uid\UuidV7 {#2083 â–¶
    __toString(): "018fdadf-36e6-76a0-b6bb-ae9c4f3d76fc"
  }
  Symfony\Component\Uid\UuidV7 {#2364 â–¶
    __toString(): "018fdadf-36f5-746c-b73a-c6a0fe4cbc2e"
  }
  Symfony\Component\Uid\UuidV7 {#2371 â–¶
    __toString(): "018fdadf-3705-7bb1-99d8-84bf5ce7d4a7"
  }
  Symfony\Component\Uid\UuidV7 {#2381 â–¶
    __toString(): "018fdadf-372a-7b9a-8587-71faf340653d"
  }
  Symfony\Component\Uid\UuidV7 {#2391 â–¶
    __toString(): "018fdadf-371b-742c-a432-d7b87a705008"
  }
  Symfony\Component\Uid\UuidV7 {#2401 â–¶
    __toString(): "018fdadf-372d-7e2c-9f55-05dc4c1f31cb"
  }
  Symfony\Component\Uid\UuidV7 {#2044 â–¶
    __toString(): "0193b05c-e2bb-7380-8d85-9506f342a692"
  }
  Symfony\Component\Uid\UuidV7 {#2252 â–¶
    __toString(): "019083a6-4f5a-7d27-afbd-55b80b0a0957"
  }
  Symfony\Component\Uid\UuidV7 {#2236 â–¶
    __toString(): "019083ca-9f8d-7cbf-9a6f-b090b60c7189"
  }
  Symfony\Component\Uid\UuidV7 {#2220 â–¶
    __toString(): "01939bb4-89da-75bd-921a-84395c214876"
  }
  Symfony\Component\Uid\UuidV7 {#2209 â–¶
    __toString(): "019084e5-8ac9-77ae-a130-71bd78bbe2d7"
  }
]
View formatted query    View runnable query    View query backtrace
25 10.67 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, s6_.checksum AS checksum_58, s6_.id AS id_59, s6_.api_id AS api_id_60, s6_.created_at AS created_at_61, s6_.updated_at AS updated_at_62, s6_.file_metadata_name AS file_metadata_name_63, s6_.file_metadata_original_name AS file_metadata_original_name_64, s6_.file_metadata_mime_type AS file_metadata_mime_type_65, s6_.file_metadata_size AS file_metadata_size_66, s6_.file_metadata_dimensions AS file_metadata_dimensions_67, s0_.thumbnail__sebii__file__media__id AS thumbnail__sebii__file__media__id_68, s1_.cover__sebii__file__media__id AS cover__sebii__file__media__id_69, s1_.background__sebii__file__media__id AS background__sebii__file__media__id_70, s2_.cover__sebii__file__media__id AS cover__sebii__file__media__id_71, s2_.background__sebii__file__media__id AS background__sebii__file__media__id_72, s3_.sebii__category__category__id AS sebii__category__category__id_73, s3_.sebii__category__platform__id AS sebii__category__platform__id_74, s3_.cover__sebii__file__media__id AS cover__sebii__file__media__id_75, s4_.logo__sebii__file__media__id AS logo__sebii__file__media__id_76 FROM "sebii__video__video" s0_ LEFT JOIN sebii__video__video_category s7_ ON s0_.id = s7_.sebii__video__video__id LEFT JOIN "sebii__category__category" s1_ ON s1_.id = s7_.sebii__category__category__id LEFT JOIN sebii__category__category_universe s8_ ON s1_.id = s8_.sebii__category__category__id LEFT JOIN "sebii__category__universe" s2_ ON s2_.id = s8_.sebii__category__universe__id LEFT JOIN sebii__video__video_release s9_ ON s0_.id = s9_.sebii__video__video__id LEFT JOIN "sebii__category__release" s3_ ON s3_.id = s9_.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 LEFT JOIN "sebii__file__media" s6_ ON s1_.cover__sebii__file__media__id = s6_.id WHERE s0_.displayed = true AND s2_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?) AND s3_.sebii__category__platform__id IN (?, ?, ?, ?, ?) AND s0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) ORDER BY s0_.recorded_at DESC, s2_.name ASC
Parameters: 
  0 of 0   
[â–Ľ
  Symfony\Component\Uid\UuidV7 {#2138 â–¶
    __toString(): "018fdadf-3718-75e2-8dad-0b55ca28f6ee"
  }
  Symfony\Component\Uid\UuidV7 {#2090 â–¶
    __toString(): "018fdade-020b-772a-b875-de502dd6d0ce"
  }
  Symfony\Component\Uid\UuidV7 {#2186 â–¶
    __toString(): "018fdadf-36f2-71d3-af4b-5138bfb34c7d"
  }
  Symfony\Component\Uid\UuidV7 {#2083 â–¶
    __toString(): "018fdadf-36e6-76a0-b6bb-ae9c4f3d76fc"
  }
  Symfony\Component\Uid\UuidV7 {#2364 â–¶
    __toString(): "018fdadf-36f5-746c-b73a-c6a0fe4cbc2e"
  }
  Symfony\Component\Uid\UuidV7 {#2371 â–¶
    __toString(): "018fdadf-3705-7bb1-99d8-84bf5ce7d4a7"
  }
  Symfony\Component\Uid\UuidV7 {#2381 â–¶
    __toString(): "018fdadf-372a-7b9a-8587-71faf340653d"
  }
  Symfony\Component\Uid\UuidV7 {#2391 â–¶
    __toString(): "018fdadf-371b-742c-a432-d7b87a705008"
  }
  Symfony\Component\Uid\UuidV7 {#2401 â–¶
    __toString(): "018fdadf-372d-7e2c-9f55-05dc4c1f31cb"
  }
  Symfony\Component\Uid\UuidV7 {#2044 â–¶
    __toString(): "0193b05c-e2bb-7380-8d85-9506f342a692"
  }
  Symfony\Component\Uid\UuidV7 {#2252 â–¶
    __toString(): "019083a6-4f5a-7d27-afbd-55b80b0a0957"
  }
  Symfony\Component\Uid\UuidV7 {#2236 â–¶
    __toString(): "019083ca-9f8d-7cbf-9a6f-b090b60c7189"
  }
  Symfony\Component\Uid\UuidV7 {#2220 â–¶
    __toString(): "01939bb4-89da-75bd-921a-84395c214876"
  }
  Symfony\Component\Uid\UuidV7 {#2209 â–¶
    __toString(): "019084e5-8ac9-77ae-a130-71bd78bbe2d7"
  }
  "018fe01e-c463-7b5c-9a96-d5d8de3e53eb"
  "018fe01e-bba9-7aa5-873e-c9a9c05b0a6a"
  "018fe01e-d362-70fb-b5dc-6414c4c44ca5"
  "018fe01e-d5e0-7990-b2ac-a23799528e29"
  "018fe01e-d5d8-7e60-9447-3cd67f4e6e30"
  "018fe01f-3c05-7642-8051-ab69ff064021"
  "018fe01e-dead-707e-9dec-b9d10fa75943"
  "018fe01e-c0a3-78ab-a05a-db5f19fc63e5"
  "018fe01e-c336-7dab-bfa5-d7b12501508d"
  "018fe01e-e021-7b44-b661-7ee33c6bc682"
  "018fe01e-d5a1-78ec-bbd7-5a2ec4f6e1e4"
  "018fe01e-bbba-7c18-80a4-a769eab3a835"
  "018fe01e-b4b3-7056-9e43-9677668d18d1"
  "018fe01e-b4ba-7f52-97a3-d3f88dea2001"
  "018fe01e-ede3-7775-969c-d841d37f6923"
  "018fe01e-b91d-7021-964c-359519a72ab4"
  "018fe01e-b76d-73b4-a4e9-4ca8fb825b4e"
  "018fe01f-3be7-7563-94f1-2964394e8e3d"
  "018fe01e-db3a-7df4-94a2-43fb3038090d"
  "018fe01e-ae9c-7124-af9f-5a53da42452a"
  "018fe01e-ecc5-7cc8-8c5c-7e123b2b180f"
  "018fe4bf-4f3b-7bfc-8904-b985001a40a6"
  "018fe01e-e542-741d-9c4c-92950e55caba"
  "018fe01e-aed8-7563-9f1b-706b03a7a2b0"
]
View formatted query    View runnable query    View query backtrace
26 2.56 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: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
27 3.14 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: 
[]
View formatted query    View runnable query    Explain query    View query backtrace