GET https://pokemon.sebii.dev/

Query Metrics

101 Database Queries
17 Different statements
104.20 ms Query time
0 Invalid entities

Grouped Statements

Show all queries

Time Count Info
22.21 ms
(21.31%)
2
SELECT RANDOM() AS sclr_0, s0_.french_name AS french_name_1, s0_.english_name AS english_name_2, s0_.japanese_name AS japanese_name_3, s0_.number AS number_4, s0_.prefix AS prefix_5, s0_.order_number AS order_number_6, s0_.category AS category_7, s0_.type AS type_8, s0_.form AS form_9, s0_.rarity AS rarity_10, s0_.dark AS dark_11, s0_.extra AS extra_12, s0_.v AS v_13, s0_.v_max AS v_max_14, s0_.v_star AS v_star_15, s0_.battle_style AS battle_style_16, s0_.id AS id_17, s0_.api_id AS api_id_18, s0_.created_at AS created_at_19, s0_.updated_at AS updated_at_20, s1_.code AS code_21, s1_.slug AS slug_22, s1_.french_name AS french_name_23, s1_.french_slug AS french_slug_24, s1_.english_name AS english_name_25, s1_.english_slug AS english_slug_26, s1_.japanese_name AS japanese_name_27, s1_.japanese_slug AS japanese_slug_28, s1_.card_count AS card_count_29, s1_.total_card_count AS total_card_count_30, s1_.released_at AS released_at_31, s1_.promo AS promo_32, s1_.pokemon_tcg_io_sub_set_prefix AS pokemon_tcg_io_sub_set_prefix_33, s1_.pokemon_tcg_io_sub_set_order_start AS pokemon_tcg_io_sub_set_order_start_34, s1_.id AS id_35, s1_.api_id AS api_id_36, s1_.created_at AS created_at_37, s1_.updated_at AS updated_at_38, s2_.french_name AS french_name_39, s2_.english_name AS english_name_40, s2_.japanese_name AS japanese_name_41, s2_.tcg_pocket AS tcg_pocket_42, s2_.id AS id_43, s2_.api_id AS api_id_44, s2_.created_at AS created_at_45, s2_.updated_at AS updated_at_46, s3_.checksum AS checksum_47, s3_.id AS id_48, s3_.api_id AS api_id_49, s3_.created_at AS created_at_50, s3_.updated_at AS updated_at_51, s3_.file_metadata_name AS file_metadata_name_52, s3_.file_metadata_original_name AS file_metadata_original_name_53, s3_.file_metadata_mime_type AS file_metadata_mime_type_54, s3_.file_metadata_size AS file_metadata_size_55, s3_.file_metadata_dimensions AS file_metadata_dimensions_56, s0_.card_set_id AS card_set_id_57, s0_.pokemon_id AS pokemon_id_58, s0_.alternative_card_to_id AS alternative_card_to_id_59, s0_.french_display_media_id AS french_display_media_id_60, s0_.english_display_media_id AS english_display_media_id_61, s0_.japanese_display_media_id AS japanese_display_media_id_62, s0_.pokemon_tcg_io_card_id AS pokemon_tcg_io_card_id_63, s0_.card_event_id AS card_event_id_64, s1_.card_series_id AS card_series_id_65, s1_.symbol_media_id AS symbol_media_id_66, s1_.french_logo_media_id AS french_logo_media_id_67, s1_.english_logo_media_id AS english_logo_media_id_68, s1_.japanese_logo_media_id AS japanese_logo_media_id_69, s1_.pokemon_tcg_io_set_id AS pokemon_tcg_io_set_id_70, s1_.pokemon_tcg_io_set_sub_id AS pokemon_tcg_io_set_sub_id_71 FROM "sebii__pokemon__card" s0_ INNER JOIN "sebii__pokemon__card_set" s1_ ON s0_.card_set_id = s1_.id INNER JOIN "sebii__pokemon__card_series" s2_ ON s1_.card_series_id = s2_.id INNER JOIN "sebii__file__media" s3_ ON s0_.french_display_media_id = s3_.id WHERE s2_.tcg_pocket = ? ORDER BY sclr_0 ASC LIMIT 12
Parameters:
[
  1
]
18.60 ms
(17.85%)
44
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:
[
  "0193a416-572f-7fc7-8492-2ce79635cc60"
]
18.51 ms
(17.77%)
24
SELECT t0.released_at AS released_at_1, t0.common_booster_chance AS common_booster_chance_2, t0.rare_booster_chance AS rare_booster_chance_3, t0.id AS id_4, t0.api_id AS api_id_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.card_set_id AS card_set_id_8, t0.pokemon_id AS pokemon_id_9, t0.french_display_media_id AS french_display_media_id_10, t0.french_logo_media_id AS french_logo_media_id_11, t0.english_display_media_id AS english_display_media_id_12, t0.english_logo_media_id AS english_logo_media_id_13, t0.japanese_display_media_id AS japanese_display_media_id_14, t0.japanese_logo_media_id AS japanese_logo_media_id_15 FROM "sebii__pokemon__card_booster" t0 INNER JOIN sebii__pokemon__card_card_booster ON t0.id = sebii__pokemon__card_card_booster.card_booster_id WHERE sebii__pokemon__card_card_booster.card_id = ?
Parameters:
[
  "0193df5d-45f0-7eda-8b25-74710244c99a"
]
6.48 ms
(6.22%)
1
"COMMIT"
Parameters:
[]
5.58 ms
(5.35%)
1
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, s0_.thumbnail__sebii__file__media__id AS thumbnail__sebii__file__media__id_30, s1_.cover__sebii__file__media__id AS cover__sebii__file__media__id_31, s1_.background__sebii__file__media__id AS background__sebii__file__media__id_32, s2_.cover__sebii__file__media__id AS cover__sebii__file__media__id_33, s2_.background__sebii__file__media__id AS background__sebii__file__media__id_34 FROM "sebii__video__video" s0_ INNER JOIN sebii__video__video_category s3_ ON s0_.id = s3_.sebii__video__video__id INNER JOIN "sebii__category__category" s1_ ON s1_.id = s3_.sebii__category__category__id INNER JOIN sebii__category__category_universe s4_ ON s1_.id = s4_.sebii__category__category__id INNER JOIN "sebii__category__universe" s2_ ON s2_.id = s4_.sebii__category__universe__id WHERE s2_.id = ? ORDER BY s0_.recorded_at DESC, s2_.name ASC LIMIT 4
Parameters:
[
  Symfony\Component\Uid\UuidV7 {#1928
    __toString(): "018fdadf-3702-7222-a0df-ab5d0bd85b17"
  }
]
5.35 ms
(5.14%)
2
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"
]
4.15 ms
(3.98%)
7
SELECT t0.name AS name_1, t0.released_at AS released_at_2, t0.date_type AS date_type_3, t0.status AS status_4, t0.id AS id_5, t0.api_id AS api_id_6, t0.sebii__category__category__id AS sebii__category__category__id_7, t0.sebii__category__platform__id AS sebii__category__platform__id_8, t0.cover__sebii__file__media__id AS cover__sebii__file__media__id_9 FROM "sebii__category__release" t0 WHERE t0.sebii__category__category__id = ? ORDER BY t0.name ASC
Parameters:
[
  "018fde62-4e25-7afe-a173-fb16e0ece144"
]
4.08 ms
(3.91%)
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, 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:
[
  "pokemon"
]
3.13 ms
(3.01%)
4
SELECT t0.name AS name_1, t0.released_at AS released_at_2, t0.date_type AS date_type_3, t0.status AS status_4, t0.id AS id_5, t0.api_id AS api_id_6, t0.sebii__category__category__id AS sebii__category__category__id_7, t0.sebii__category__platform__id AS sebii__category__platform__id_8, t0.cover__sebii__file__media__id AS cover__sebii__file__media__id_9 FROM "sebii__category__release" t0 INNER JOIN sebii__video__video_release ON t0.id = sebii__video__video_release.sebii__category__release__id WHERE sebii__video__video_release.sebii__video__video__id = ?
Parameters:
[
  "0193b062-eaf7-740f-b0a8-4c2cfcbf7dc6"
]
2.78 ms
(2.67%)
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, s0_.cover__sebii__file__media__id AS cover__sebii__file__media__id_11, s0_.background__sebii__file__media__id AS background__sebii__file__media__id_12 FROM "sebii__category__category" s0_ INNER JOIN sebii__category__category_universe s2_ ON s0_.id = s2_.sebii__category__category__id INNER JOIN "sebii__category__universe" s1_ ON s1_.id = s2_.sebii__category__universe__id WHERE s1_.id = ?
Parameters:
[
  "018fdadf-3702-7222-a0df-ab5d0bd85b17"
]
2.66 ms
(2.56%)
1
SELECT s0_.french_name AS french_name_0, s0_.english_name AS english_name_1, s0_.japanese_name AS japanese_name_2, s0_.generation AS generation_3, s0_.national_pokedex_number AS national_pokedex_number_4, s0_.baby AS baby_5, s0_.legendary AS legendary_6, s0_.mythical AS mythical_7, s0_.id AS id_8, s0_.api_id AS api_id_9, s0_.created_at AS created_at_10, s0_.updated_at AS updated_at_11, RANDOM() AS sclr_12, s0_.evolve_from_id AS evolve_from_id_13, s0_.front_sprite_media_id AS front_sprite_media_id_14 FROM "sebii__pokemon__pokemon" s0_ ORDER BY sclr_12 ASC LIMIT 12
Parameters:
[]
2.43 ms
(2.33%)
4
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.id = ?
Parameters:
[
  "019083a6-4f5a-7d27-afbd-55b80b0a0957"
]
2.26 ms
(2.17%)
5
SELECT t0.french_name AS french_name_1, t0.english_name AS english_name_2, t0.japanese_name AS japanese_name_3, t0.generation AS generation_4, t0.national_pokedex_number AS national_pokedex_number_5, t0.baby AS baby_6, t0.legendary AS legendary_7, t0.mythical AS mythical_8, t0.id AS id_9, t0.api_id AS api_id_10, t0.created_at AS created_at_11, t0.updated_at AS updated_at_12, t0.evolve_from_id AS evolve_from_id_13, t0.front_sprite_media_id AS front_sprite_media_id_14 FROM "sebii__pokemon__pokemon" t0 WHERE t0.id = ?
Parameters:
[
  "0193ceeb-5edb-7598-98f5-de2b981b0ff4"
]
2.20 ms
(2.11%)
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-04-19 04:49:28.387692\";s:13:\"timezone_type\";i:3;s:8:\"timezone\";s:3:\"UTC\";}s:52:\"\0App\\Messenger\\Message\\Security\\AnalyticMessage\0page\";s:1:\"/\";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: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 04:49:28"
  "2025-04-19 04:49:28"
]
1.87 ms
(1.79%)
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, 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:
[]
1.57 ms
(1.51%)
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:
[]
0.33 ms
(0.32%)
1
"START TRANSACTION"
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.