GET https://stream.sebii.dev/categories/p:android,p:nintendo-64-hack,u:f-zero,u:kirby,u:sonic,u:tetris-99

Response
200 OK
IP
172.19.0.1
Profiled on
Token
d00aa4

Query Metrics

17 Database Queries
12 Different statements
34.80 ms Query time
0 Invalid entities
369 Managed entities

Grouped Statements

Show all queries

Time▼ Count Info
6.38 ms
(18.32%) 		1 
"COMMIT"
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
5.58 ms
(16.03%) 		1 
SELECT s0_.name AS name_0, s0_.invisible_complement_name AS invisible_complement_name_1, s0_.slug AS slug_2, s0_.type AS type_3, s0_.is_compilation AS is_compilation_4, s0_.first_released_at AS first_released_at_5, s0_.id AS id_6, s0_.api_id AS api_id_7, s0_.displayed AS displayed_8, s0_.created_at AS created_at_9, s0_.updated_at AS updated_at_10, s1_.name AS name_11, s1_.slug AS slug_12, s1_.customized_route AS customized_route_13, s1_.customized_domain AS customized_domain_14, s1_.iconify_code AS iconify_code_15, s1_.id AS id_16, s1_.api_id AS api_id_17, s1_.created_at AS created_at_18, s1_.updated_at AS updated_at_19, s2_.name AS name_20, s2_.released_at AS released_at_21, s2_.date_type AS date_type_22, s2_.status AS status_23, s2_.id AS id_24, s2_.api_id AS api_id_25, s3_.name AS name_26, s3_.slug AS slug_27, s3_.abbreviation AS abbreviation_28, s3_.type AS type_29, s3_.family AS family_30, s3_.iconify_code AS iconify_code_31, s3_.id AS id_32, s3_.api_id AS api_id_33, s3_.displayed AS displayed_34, s3_.color AS color_35, s3_.created_at AS created_at_36, s3_.updated_at AS updated_at_37, s4_.checksum AS checksum_38, s4_.id AS id_39, s4_.api_id AS api_id_40, s4_.created_at AS created_at_41, s4_.updated_at AS updated_at_42, s4_.file_metadata_name AS file_metadata_name_43, s4_.file_metadata_original_name AS file_metadata_original_name_44, s4_.file_metadata_mime_type AS file_metadata_mime_type_45, s4_.file_metadata_size AS file_metadata_size_46, s4_.file_metadata_dimensions AS file_metadata_dimensions_47, s0_.cover__sebii__file__media__id AS cover__sebii__file__media__id_48, s0_.background__sebii__file__media__id AS background__sebii__file__media__id_49, s1_.cover__sebii__file__media__id AS cover__sebii__file__media__id_50, s1_.background__sebii__file__media__id AS background__sebii__file__media__id_51, s2_.sebii__category__category__id AS sebii__category__category__id_52, s2_.sebii__category__platform__id AS sebii__category__platform__id_53, s2_.cover__sebii__file__media__id AS cover__sebii__file__media__id_54, s3_.logo__sebii__file__media__id AS logo__sebii__file__media__id_55 FROM "sebii__category__category" s0_ LEFT JOIN sebii__category__category_universe s5_ ON s0_.id = s5_.sebii__category__category__id LEFT JOIN "sebii__category__universe" s1_ ON s1_.id = s5_.sebii__category__universe__id LEFT JOIN "sebii__category__release" s2_ ON s0_.id = s2_.sebii__category__category__id LEFT JOIN "sebii__category__platform" s3_ ON s2_.sebii__category__platform__id = s3_.id LEFT JOIN "sebii__file__media" s4_ ON s0_.cover__sebii__file__media__id = s4_.id WHERE s1_.id IN (?, ?, ?, ?) AND s3_.id IN (?, ?) ORDER BY s0_.name ASC, s1_.name ASC, s2_.name ASC
Parameters: 
[
  Symfony\Component\Uid\UuidV7 {#1388
    __toString(): "0193a6e1-4666-764b-91db-987333bafc06"
  }
  Symfony\Component\Uid\UuidV7 {#1542
    __toString(): "0193a6e1-6953-750c-ba8f-5162e1a0b6c2"
  }
  Symfony\Component\Uid\UuidV7 {#1386
    __toString(): "018fdadf-3727-7bec-bf00-fd786ab0ce7b"
  }
  Symfony\Component\Uid\UuidV7 {#1620
    __toString(): "018fdadf-371b-742c-a432-d7b87a705008"
  }
  Symfony\Component\Uid\UuidV7 {#1324
    __toString(): "0193b05c-e2bb-7380-8d85-9506f342a692"
  }
  Symfony\Component\Uid\UuidV7 {#1415
    __toString(): "01909776-46ac-7dfb-b538-aad98904c53c"
  }
]
View formatted query    View runnable query    View query backtrace
4.59 ms
(13.19%) 		1 
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, s0_.cover__sebii__file__media__id AS cover__sebii__file__media__id_9, s0_.background__sebii__file__media__id AS background__sebii__file__media__id_10 FROM "sebii__category__universe" s0_ WHERE s0_.customized_domain = ? LIMIT 1
Parameters: 
[
  "stream.sebii.dev"
]
View formatted query    View runnable query    Explain query    View query backtrace
4.55 ms
(13.07%) 		2 
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
4.48 ms
(12.89%) 		4 
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: 
[
  "f-zero"
]
View formatted query    View runnable query    Explain query    View query backtrace
2.49 ms
(7.14%) 		2 
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_ WHERE s0_.slug = ?
Parameters: 
[
  "android"
]
View formatted query    View runnable query    Explain query    View query backtrace
2.17 ms
(6.24%) 		1 
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-10-07 11:47:33.923203\";s:13:\"timezone_type\";i:3;s:8:\"timezone\";s:3:\"UTC\";}s:52:\"\0App\\Messenger\\Message\\Security\\AnalyticMessage\0page\";s:77:\"/categories/p:android,p:nintendo-64-hack,u:f-zero,u:kirby,u:sonic,u:tetris-99\";s:54:\"\0App\\Messenger\\Message\\Security\\AnalyticMessage\0domain\";s:16:\"stream.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-10-07 11:47:33"
  "2025-10-07 11:47:33"
]
View formatted query    View runnable query    Explain query    View query backtrace
1.63 ms
(4.69%) 		1 
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
1.26 ms
(3.62%) 		1 
SELECT COUNT(s0_.id) AS sclr_0 FROM "sebii__video__video" s0_ WHERE s0_.type = ?
Parameters: 
[
  "live"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.81 ms
(2.33%) 		1 
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: 
[
  "stream.sebii.dev"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.52 ms
(1.51%) 		1 
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
0.34 ms
(0.98%) 		1 
"START TRANSACTION"
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace

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.

Managed Entities

default entity manager

Class Amount of managed objects
App\Entity\File\Media 182
App\Entity\Category\Category 130
App\Entity\Category\Universe 29
App\Entity\Category\Platform 22
App\Entity\Social\Item 6

Entities Mapping

Class Mapping errors
App\Entity\Category\Universe No errors.
Vich\UploaderBundle\Entity\File No errors.
App\Entity\File\Media No errors.
App\Entity\Category\Platform No errors.
App\Entity\Category\Release No errors.
App\Entity\External\Igdb\Platform No errors.
App\Entity\Category\Category No errors.
App\Entity\Video\Video No errors.
App\Entity\Video\Playlist No errors.
App\Entity\External\Igdb\Game No errors.
App\Entity\Social\Item No errors.
App\Entity\Social\GroupItem No errors.