GET https://pokemon.sebii.dev/categories/p:gameboy-color,p:gamecube,p:lego,p:megadrive,p:navigateur-web,p:nintendo-64-hack,p:playstation-4,p:playstation-5,p:switch,…

Response
200 OK
IP
172.19.0.1
Profiled on
Token
420e22

Query Metrics

20 Database Queries
9 Different statements
47.72 ms Query time
0 Invalid entities

Group similar statements

#▲ Time Info
1 6.73 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   
[▼
  "pokemon.sebii.dev"
]
View formatted query    View runnable query    Explain query    View query backtrace
2 0.44 ms 
"START TRANSACTION"
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
3 4.18 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-18 01:48:34.242027\";s:13:\"timezone_type\";i:3;s:8:\"timezone\";s:3:\"UTC\";}s:52:\"\0App\\Messenger\\Message\\Security\\AnalyticMessage\0page\";s:169:\"/categories/p:gameboy-color,p:gamecube,p:lego,p:megadrive,p:navigateur-web,p:nintendo-64-hack,p:playstation-4,p:playstation-5,p:switch,p:xbox-360,p:xbox-one,t:video_game\";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-05-18 01:48:34"
  "2025-05-18 01:48:34"
]
View formatted query    View runnable query    Explain query    View query backtrace
4 6.65 ms 
"COMMIT"
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
5 2.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   
[▼
  "gameboy-color"
]
View formatted query    View runnable query    Explain query    View query backtrace
6 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: 
  0 of 0   
[▼
  "gamecube"
]
View formatted query    View runnable query    Explain query    View query backtrace
7 0.69 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   
[▼
  "lego"
]
View formatted query    View runnable query    Explain query    View query backtrace
8 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: 
  0 of 0   
[▼
  "megadrive"
]
View formatted query    View runnable query    Explain query    View query backtrace
9 0.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.slug = ? LIMIT 1
Parameters: 
  0 of 0   
[▼
  "navigateur-web"
]
View formatted query    View runnable query    Explain query    View query backtrace
10 0.79 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-64-hack"
]
View formatted query    View runnable query    Explain query    View query backtrace
11 0.78 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
12 0.63 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-5"
]
View formatted query    View runnable query    Explain query    View query backtrace
13 0.66 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   
[▼
  "switch"
]
View formatted query    View runnable query    Explain query    View query backtrace
14 0.63 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-360"
]
View formatted query    View runnable query    Explain query    View query backtrace
15 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: 
  0 of 0   
[▼
  "xbox-one"
]
View formatted query    View runnable query    Explain query    View query backtrace
16 13.11 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: 
  0 of 0   
[▼
  "video_game"
  Symfony\Component\Uid\UuidV7 {#1928 ▶
    __toString(): "018fdadf-3702-7222-a0df-ab5d0bd85b17"
  }
  Symfony\Component\Uid\UuidV7 {#2103 ▶
    __toString(): "01909eb8-5061-77ae-bae2-9fa29ba96a7b"
  }
  Symfony\Component\Uid\UuidV7 {#2138 ▶
    __toString(): "019084ca-e152-7d57-a494-cc8f7e20d72d"
  }
  Symfony\Component\Uid\UuidV7 {#2217 ▶
    __toString(): "0191b307-d4f5-739c-92a2-837736d85dde"
  }
  Symfony\Component\Uid\UuidV7 {#2228 ▶
    __toString(): "019084b1-8d10-72d0-991d-2a49650fb265"
  }
  Symfony\Component\Uid\UuidV7 {#2239 ▶
    __toString(): "0190979f-c90b-7cb4-85cd-1fe911dd8680"
  }
  Symfony\Component\Uid\UuidV7 {#2250 ▶
    __toString(): "01909776-46ac-7dfb-b538-aad98904c53c"
  }
  Symfony\Component\Uid\UuidV7 {#2261 ▶
    __toString(): "01939bb4-89da-75bd-921a-84395c214876"
  }
  Symfony\Component\Uid\UuidV7 {#2272 ▶
    __toString(): "01909e6a-2f37-78b5-9501-a9b348b32785"
  }
  Symfony\Component\Uid\UuidV7 {#2283 ▶
    __toString(): "019084f4-7647-792e-bb59-1de14ed6acb2"
  }
  Symfony\Component\Uid\UuidV7 {#2294 ▶
    __toString(): "019084d0-2c0b-7f6b-916b-3fe34eec9973"
  }
  Symfony\Component\Uid\UuidV7 {#2305 ▶
    __toString(): "019084e5-8ac9-77ae-a130-71bd78bbe2d7"
  }
]
View formatted query    View runnable query    View query backtrace
17 0.92 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
18 1.01 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   
[▼
  "pokemon.sebii.dev"
]
View formatted query    View runnable query    Explain query    View query backtrace
19 2.48 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
20 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: 
[]
View formatted query    View runnable query    Explain query    View query backtrace