GET https://pokemon.sebii.dev/categories/p:android,p:gameboy,p:gameboy-color,p:gamecube,p:nintendo-64-hack,p:super-n-e-s,p:switch,p:wii,p:wiiu,p:xbox-one,t:game_boo…

Response
200 OK
IP
172.19.0.1
Profiled on
Token
859dfc

Query Metrics

19 Database Queries
9 Different statements
35.71 ms Query time
0 Invalid entities

Queries

Group similar statements

#▲ Time Info
1 5.38 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: 
[
  "pokemon.sebii.dev"
]
View formatted query    View runnable query    Explain query    View query backtrace
2 0.33 ms 
"START TRANSACTION"
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
3 3.12 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-28 17:17:35.153227\";s:13:\"timezone_type\";i:3;s:8:\"timezone\";s:3:\"UTC\";}s:52:\"\0App\\Messenger\\Message\\Security\\AnalyticMessage\0page\";s:159:\"/categories/p:android,p:gameboy,p:gameboy-color,p:gamecube,p:nintendo-64-hack,p:super-n-e-s,p:switch,p:wii,p:wiiu,p:xbox-one,t:game_book,t:tv_series,t:unboxing\";s:54:\"\0App\\Messenger\\Message\\Security\\AnalyticMessage\0domain\";s:17:\"pokemon.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-04-28 17:17:35"
  "2025-04-28 17:17:35"
]
View formatted query    View runnable query    Explain query    View query backtrace
4 2.63 ms 
"COMMIT"
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
5 2.53 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: 
[
  "android"
]
View formatted query    View runnable query    Explain query    View query backtrace
6 0.91 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: 
[
  "gameboy"
]
View formatted query    View runnable query    Explain query    View query backtrace
7 0.61 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: 
[
  "gameboy-color"
]
View formatted query    View runnable query    Explain query    View query backtrace
8 0.53 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: 
[
  "gamecube"
]
View formatted query    View runnable query    Explain query    View query backtrace
9 0.52 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: 
[
  "nintendo-64-hack"
]
View formatted query    View runnable query    Explain query    View query backtrace
10 0.60 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: 
[
  "super-n-e-s"
]
View formatted query    View runnable query    Explain query    View query backtrace
11 0.59 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: 
[
  "switch"
]
View formatted query    View runnable query    Explain query    View query backtrace
12 0.86 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: 
[
  "wii"
]
View formatted query    View runnable query    Explain query    View query backtrace
13 0.72 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: 
[
  "wiiu"
]
View formatted query    View runnable query    Explain query    View query backtrace
14 0.64 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: 
[
  "xbox-one"
]
View formatted query    View runnable query    Explain query    View query backtrace
15 10.37 ms 
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 s0_.type IN (?, ?, ?) AND s1_.id IN (?) AND s3_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?) ORDER BY s0_.name ASC, s1_.name ASC, s2_.name ASC
Parameters: 
[
  "game_book"
  "tv_series"
  "unboxing"
  Symfony\Component\Uid\UuidV7 {#1928
    __toString(): "018fdadf-3702-7222-a0df-ab5d0bd85b17"
  }
  Symfony\Component\Uid\UuidV7 {#2103
    __toString(): "0193b05c-e2bb-7380-8d85-9506f342a692"
  }
  Symfony\Component\Uid\UuidV7 {#2138
    __toString(): "01908e25-9ef5-7888-9ae6-3489b3d3a3c2"
  }
  Symfony\Component\Uid\UuidV7 {#2217
    __toString(): "01909eb8-5061-77ae-bae2-9fa29ba96a7b"
  }
  Symfony\Component\Uid\UuidV7 {#2228
    __toString(): "019084ca-e152-7d57-a494-cc8f7e20d72d"
  }
  Symfony\Component\Uid\UuidV7 {#2239
    __toString(): "01909776-46ac-7dfb-b538-aad98904c53c"
  }
  Symfony\Component\Uid\UuidV7 {#2250
    __toString(): "01909e92-9a71-7531-ad9d-2e87febca18a"
  }
  Symfony\Component\Uid\UuidV7 {#2261
    __toString(): "019084f4-7647-792e-bb59-1de14ed6acb2"
  }
  Symfony\Component\Uid\UuidV7 {#2272
    __toString(): "01907fce-0f43-7b76-9959-9878a254fa03"
  }
  Symfony\Component\Uid\UuidV7 {#2283
    __toString(): "01908338-f201-7079-bd65-5a1642619760"
  }
  Symfony\Component\Uid\UuidV7 {#2294
    __toString(): "019084e5-8ac9-77ae-a130-71bd78bbe2d7"
  }
]
View formatted query    View runnable query    View query backtrace
16 0.81 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
17 0.68 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: 
[
  "pokemon.sebii.dev"
]
View formatted query    View runnable query    Explain query    View query backtrace
18 1.73 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
19 2.16 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

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.

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\Category No errors.
App\Entity\Category\Platform No errors.
App\Entity\Category\Release No errors.
App\Entity\External\Igdb\Platform No errors.
App\Entity\Social\Item No errors.
App\Entity\Social\GroupItem No errors.
App\Entity\Video\Video No errors.
App\Entity\Video\Playlist No errors.
App\Entity\External\Igdb\Game No errors.