Query Metrics
189
Database Queries
13
Different statements
162.79 ms
Query time
0
Invalid entities
Grouped Statements
Time▼ | Count | Info | ||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
80.75 ms (49.61%) |
86 |
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:
[
"0193df6a-ffa9-7670-b93c-70374196df8a"
]
|
||||||||||||||||||||||
50.42 ms (30.97%) |
91 |
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:
[
"0194cb6a-b59b-7081-9052-d6152e76718f"
]
|
||||||||||||||||||||||
8.07 ms (4.96%) |
1 |
SELECT s0_.code AS code_0, s0_.slug AS slug_1, s0_.french_name AS french_name_2, s0_.french_slug AS french_slug_3, s0_.english_name AS english_name_4, s0_.english_slug AS english_slug_5, s0_.japanese_name AS japanese_name_6, s0_.japanese_slug AS japanese_slug_7, s0_.card_count AS card_count_8, s0_.total_card_count AS total_card_count_9, s0_.released_at AS released_at_10, s0_.promo AS promo_11, s0_.pokemon_tcg_io_sub_set_prefix AS pokemon_tcg_io_sub_set_prefix_12, s0_.pokemon_tcg_io_sub_set_order_start AS pokemon_tcg_io_sub_set_order_start_13, s0_.id AS id_14, s0_.api_id AS api_id_15, s0_.created_at AS created_at_16, s0_.updated_at AS updated_at_17, s1_.french_name AS french_name_18, s1_.english_name AS english_name_19, s1_.japanese_name AS japanese_name_20, s1_.tcg_pocket AS tcg_pocket_21, s1_.id AS id_22, s1_.api_id AS api_id_23, s1_.created_at AS created_at_24, s1_.updated_at AS updated_at_25, s2_.released_at AS released_at_26, s2_.common_booster_chance AS common_booster_chance_27, s2_.rare_booster_chance AS rare_booster_chance_28, s2_.id AS id_29, s2_.api_id AS api_id_30, s2_.created_at AS created_at_31, s2_.updated_at AS updated_at_32, s3_.checksum AS checksum_33, s3_.id AS id_34, s3_.api_id AS api_id_35, s3_.created_at AS created_at_36, s3_.updated_at AS updated_at_37, s3_.file_metadata_name AS file_metadata_name_38, s3_.file_metadata_original_name AS file_metadata_original_name_39, s3_.file_metadata_mime_type AS file_metadata_mime_type_40, s3_.file_metadata_size AS file_metadata_size_41, s3_.file_metadata_dimensions AS file_metadata_dimensions_42, s0_.card_series_id AS card_series_id_43, s0_.symbol_media_id AS symbol_media_id_44, s0_.french_logo_media_id AS french_logo_media_id_45, s0_.english_logo_media_id AS english_logo_media_id_46, s0_.japanese_logo_media_id AS japanese_logo_media_id_47, s0_.pokemon_tcg_io_set_id AS pokemon_tcg_io_set_id_48, s0_.pokemon_tcg_io_set_sub_id AS pokemon_tcg_io_set_sub_id_49, s2_.card_set_id AS card_set_id_50, s2_.pokemon_id AS pokemon_id_51, s2_.french_display_media_id AS french_display_media_id_52, s2_.french_logo_media_id AS french_logo_media_id_53, s2_.english_display_media_id AS english_display_media_id_54, s2_.english_logo_media_id AS english_logo_media_id_55, s2_.japanese_display_media_id AS japanese_display_media_id_56, s2_.japanese_logo_media_id AS japanese_logo_media_id_57 FROM "sebii__pokemon__card_set" s0_ LEFT JOIN "sebii__pokemon__card_series" s1_ ON s0_.card_series_id = s1_.id LEFT JOIN "sebii__pokemon__card_booster" s2_ ON s0_.id = s2_.card_set_id LEFT JOIN "sebii__file__media" s3_ ON s0_.french_logo_media_id = s3_.id WHERE s1_.tcg_pocket = ? ORDER BY s0_.promo ASC, s0_.released_at DESC, s2_.released_at DESC
Parameters:
[
1
]
|
||||||||||||||||||||||
4.82 ms (2.96%) |
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.60 ms (2.83%) |
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:
[] |
||||||||||||||||||||||
4.01 ms (2.46%) |
1 |
SELECT t0.french_name AS french_name_1, t0.english_name AS english_name_2, t0.japanese_name AS japanese_name_3, t0.number AS number_4, t0.prefix AS prefix_5, t0.order_number AS order_number_6, t0.category AS category_7, t0.type AS type_8, t0.form AS form_9, t0.rarity AS rarity_10, t0.dark AS dark_11, t0.extra AS extra_12, t0.v AS v_13, t0.v_max AS v_max_14, t0.v_star AS v_star_15, t0.battle_style AS battle_style_16, t0.id AS id_17, t0.api_id AS api_id_18, t0.created_at AS created_at_19, t0.updated_at AS updated_at_20, t0.card_set_id AS card_set_id_21, t0.pokemon_id AS pokemon_id_22, t0.alternative_card_to_id AS alternative_card_to_id_23, t0.french_display_media_id AS french_display_media_id_24, t0.english_display_media_id AS english_display_media_id_25, t0.japanese_display_media_id AS japanese_display_media_id_26, t0.pokemon_tcg_io_card_id AS pokemon_tcg_io_card_id_27, t0.card_event_id AS card_event_id_28 FROM "sebii__pokemon__card" t0 INNER JOIN sebii__pokemon__card_card_booster ON t0.id = sebii__pokemon__card_card_booster.card_id WHERE sebii__pokemon__card_card_booster.card_booster_id = ?
Parameters:
[
"0193df6a-263a-70e6-84c4-968fc386fbe0"
]
|
||||||||||||||||||||||
2.46 ms (1.51%) |
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 15:44:53.370097\";s:13:\"timezone_type\";i:3;s:8:\"timezone\";s:3:\"UTC\";}s:52:\"\0App\\Messenger\\Message\\Security\\AnalyticMessage\0page\";s:40:\"/tcg-pocket/cartodex/a1a-l-ile-fabuleuse\";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 15:44:53" "2025-04-19 15:44:53" ] |
||||||||||||||||||||||
2.24 ms (1.38%) |
1 |
"COMMIT"
Parameters:
[] |
||||||||||||||||||||||
1.62 ms (0.99%) |
1 |
SELECT t0.french_name AS french_name_1, t0.english_name AS english_name_2, t0.japanese_name AS japanese_name_3, t0.number AS number_4, t0.prefix AS prefix_5, t0.order_number AS order_number_6, t0.category AS category_7, t0.type AS type_8, t0.form AS form_9, t0.rarity AS rarity_10, t0.dark AS dark_11, t0.extra AS extra_12, t0.v AS v_13, t0.v_max AS v_max_14, t0.v_star AS v_star_15, t0.battle_style AS battle_style_16, t0.id AS id_17, t0.api_id AS api_id_18, t0.created_at AS created_at_19, t0.updated_at AS updated_at_20, t0.card_set_id AS card_set_id_21, t0.pokemon_id AS pokemon_id_22, t0.alternative_card_to_id AS alternative_card_to_id_23, t0.french_display_media_id AS french_display_media_id_24, t0.english_display_media_id AS english_display_media_id_25, t0.japanese_display_media_id AS japanese_display_media_id_26, t0.pokemon_tcg_io_card_id AS pokemon_tcg_io_card_id_27, t0.card_event_id AS card_event_id_28 FROM "sebii__pokemon__card" t0 WHERE t0.card_set_id = ? ORDER BY t0.order_number ASC
Parameters:
[
"0193df64-1b54-764c-bd8f-cff6535a4ceb"
]
|
||||||||||||||||||||||
1.40 ms (0.86%) |
1 |
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-ab59-707f-a1f7-1cf6ac8cf734"
]
|
||||||||||||||||||||||
1.30 ms (0.80%) |
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.71 ms (0.44%) |
1 |
SELECT t0.code AS code_1, t0.slug AS slug_2, t0.french_name AS french_name_3, t0.french_slug AS french_slug_4, t0.english_name AS english_name_5, t0.english_slug AS english_slug_6, t0.japanese_name AS japanese_name_7, t0.japanese_slug AS japanese_slug_8, t0.card_count AS card_count_9, t0.total_card_count AS total_card_count_10, t0.released_at AS released_at_11, t0.promo AS promo_12, t0.pokemon_tcg_io_sub_set_prefix AS pokemon_tcg_io_sub_set_prefix_13, t0.pokemon_tcg_io_sub_set_order_start AS pokemon_tcg_io_sub_set_order_start_14, t0.id AS id_15, t0.api_id AS api_id_16, t0.created_at AS created_at_17, t0.updated_at AS updated_at_18, t0.card_series_id AS card_series_id_19, t0.symbol_media_id AS symbol_media_id_20, t0.french_logo_media_id AS french_logo_media_id_21, t0.english_logo_media_id AS english_logo_media_id_22, t0.japanese_logo_media_id AS japanese_logo_media_id_23, t0.pokemon_tcg_io_set_id AS pokemon_tcg_io_set_id_24, t0.pokemon_tcg_io_set_sub_id AS pokemon_tcg_io_set_sub_id_25 FROM "sebii__pokemon__card_set" t0 WHERE t0.slug = ? LIMIT 1
Parameters:
[
"a1a"
]
|
||||||||||||||||||||||
0.38 ms (0.24%) |
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.
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\Pokemon\CardSet | No errors. |
App\Entity\Pokemon\CardSeries | No errors. |
App\Entity\Pokemon\CardBooster | No errors. |
App\Entity\External\PokemonTcgIo\Set | No errors. |
App\Entity\Pokemon\Pokemon | No errors. |
App\Entity\Pokemon\Card | No errors. |
App\Entity\External\PokemonTcgIo\Card | No errors. |
App\Entity\Pokemon\CardEvent | No errors. |
App\Entity\Pokemon\CardOwner | No errors. |
App\Entity\External\PokeApiCo\Species | No errors. |
App\Entity\Social\Item | No errors. |
App\Entity\Social\GroupItem | No errors. |
App\Entity\Category\Release | No errors. |
App\Entity\Video\Video | No errors. |
App\Entity\Video\Playlist | No errors. |
App\Entity\External\Igdb\Game | No errors. |