Query Metrics
75
Database Queries
22
Different statements
198.07 ms
Query time
0
Invalid entities
105
Managed entities
0
Cache hits
0
Cache misses
0
Cache puts
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
81.37 ms (41.08%) |
1 |
SELECT COUNT(c0_.id) AS sclr_0 FROM card c0_ INNER JOIN serie s1_ ON c0_.serie_id = s1_.id WHERE c0_.displayed = 1 AND c0_.slug IS NOT NULL AND c0_.current_price IS NOT NULL AND c0_.cardnexus_current_price IS NOT NULL AND c0_.website_id = ? AND c0_.cardnexus_current_price < c0_.current_price
Parameters:
[
1
]
|
||||||||||||||||||||||||||||||||
|
69.23 ms (34.95%) |
1 |
SELECT COUNT(a0_.ip) AS sclr_0 FROM article_view a0_ WHERE a0_.article_id = ? AND DATE(a0_.view_date) = ? AND a0_.ip = ?
Parameters:
[ 17 "2026-11-12" "216.73.217.31" ]
|
||||||||||||||||||||||||||||||||
|
13.24 ms (6.69%) |
16 |
SELECT t0.id AS id_1, t0.uniqid AS uniqid_2, t0.name AS name_3, t0.private AS private_4, t0.invalid AS invalid_5, t0.starter AS starter_6, t0.dev_team AS dev_team_7, t0.meta AS meta_8, t0.total_price AS total_price_9, t0.untap_click_count AS untap_click_count_10, t0.creation_date AS creation_date_11, t0.update_date AS update_date_12, t0.view_count AS view_count_13, t0.like_count AS like_count_14, t0.deleted AS deleted_15, t0.leader_id AS leader_id_16, t17.id AS id_18, t17.number AS number_19, t17.serial_number AS serial_number_20, t17.front_name AS front_name_21, t17.front_description AS front_description_22, t17.front_energy_cost AS front_energy_cost_23, t17.secondary_cost AS secondary_cost_24, t17.front_energy_cost_alias AS front_energy_cost_alias_25, t17.front_energy_color_cost AS front_energy_color_cost_26, t17.back_energy_color_cost AS back_energy_color_cost_27, t17.front_combo_cost AS front_combo_cost_28, t17.front_combo_power AS front_combo_power_29, t17.front_power AS front_power_30, t17.front_defense AS front_defense_31, t17.back_name AS back_name_32, t17.back_description AS back_description_33, t17.back_power AS back_power_34, t17.back_power2 AS back_power2_35, t17.back_defense AS back_defense_36, t17.back_defense2 AS back_defense2_37, t17.img_ready AS img_ready_38, t17.image_ready AS image_ready_39, t17.multicolor AS multicolor_40, t17.limited AS limited_41, t17.banned AS banned_42, t17.unlimited_in_deck AS unlimited_in_deck_43, t17.limitation_in_deck AS limitation_in_deck_44, t17.reprint AS reprint_45, t17.foil AS foil_46, t17.reprint_category AS reprint_category_47, t17.animated AS animated_48, t17.version_number AS version_number_49, t17.front_name_alias AS front_name_alias_50, t17.front_name_en AS front_name_en_51, t17.back_name_en AS back_name_en_52, t17.front_description_en AS front_description_en_53, t17.back_description_en AS back_description_en_54, t17.english_only AS english_only_55, t17.redirect_english_slug AS redirect_english_slug_56, t17.position_serie_list AS position_serie_list_57, t17.lore AS lore_58, t17.subname AS subname_59, t17.illustrator AS illustrator_60, t17.energyzable AS energyzable_61, t17.weakness AS weakness_62, t17.resistance AS resistance_63, t17.sub_description AS sub_description_64, t17.exclusive AS exclusive_65, t17.end_of_serie AS end_of_serie_66, t17.verso AS verso_67, t17.additional_data AS additional_data_68, t17.ocr_keywords_count AS ocr_keywords_count_69, t17.beta AS beta_70, t17.level AS level_71, t17.price_alert AS price_alert_72, t17.creation_date AS creation_date_73, t17.update_date AS update_date_74, t17.displayed AS displayed_75, t17.slug AS slug_76, t17.slug_en AS slug_en_77, t17.view_count AS view_count_78, t17.cmid AS cmid_79, t17.url AS url_80, t17.image AS image_81, t17.current_price AS current_price_82, t17.yesterday_price AS yesterday_price_83, t17.last_price_update AS last_price_update_84, t17.cardnexus_id AS cardnexus_id_85, t17.cardnexus_current_price AS cardnexus_current_price_86, t17.cardnexus_yesterday_price AS cardnexus_yesterday_price_87, t17.cardnexus_last_price_update AS cardnexus_last_price_update_88, t17.lang AS lang_89, t17.release_date AS release_date_90, t17.complete AS complete_91, t17.bandai_tcgid AS bandai_tcgid_92, t17.checked AS checked_93, t17.indexable AS indexable_94, t17.front_era_id AS front_era_id_95, t17.back_era_id AS back_era_id_96, t17.type_id AS type_id_97, t17.serie_id AS serie_id_98, t17.rarity_id AS rarity_id_99, t17.group_version_id AS group_version_id_100, t17.avatar_id AS avatar_id_101, t17.version_id AS version_id_102, t17.auto_play_id AS auto_play_id_103, t17.version_annotation_id AS version_annotation_id_104, t17.website_id AS website_id_105, t0.creator_id AS creator_id_106, t0.event_id AS event_id_107, t0.website_id AS website_id_108 FROM deck t0 INNER JOIN card t17 ON t0.leader_id = t17.id WHERE t0.id = ? LIMIT 1
Parameters:
[
"3259"
]
|
||||||||||||||||||||||||||||||||
|
8.76 ms (4.43%) |
16 |
SELECT t0.id AS id_1, t0.email AS email_2, t0.pseudo AS pseudo_3, t0.play_id AS play_id_4, t0.roles AS roles_5, t0.password AS password_6, t0.reset_password_link AS reset_password_link_7, t0.last_login_date AS last_login_date_8, t0.facebook_id AS facebook_id_9, t0.facebook_access_token AS facebook_access_token_10, t0.google_id AS google_id_11, t0.discord_id AS discord_id_12, t0.seller_name AS seller_name_13, t0.achievements_points AS achievements_points_14, t0.nb_logins AS nb_logins_15, t0.nb_logins_in_arow AS nb_logins_in_arow_16, t0.max_logins_in_arow AS max_logins_in_arow_17, t0.capsule_count AS capsule_count_18, t0.api_id AS api_id_19, t0.credits AS credits_20, t0.cardnexus_mail AS cardnexus_mail_21, t0.creation_date AS creation_date_22, t0.update_date AS update_date_23, t0.avatar_id AS avatar_id_24, t0.data_player_id AS data_player_id_25, t0.country_id AS country_id_26, t0.department_id AS department_id_27, t0.website_id AS website_id_28, t0.category, t0.youtube_channel AS youtube_channel_29 FROM user t0 WHERE t0.play_id = ? AND t0.category IN ('USER', 'VIDEOGRAPHER') LIMIT 1
Parameters:
[
"7501001529"
]
|
||||||||||||||||||||||||||||||||
|
3.87 ms (1.95%) |
9 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.unlocked AS unlocked_3, t0.slug AS slug_4, t0.slug_en AS slug_en_5, t0.displayed AS displayed_6, t0.rarity_id AS rarity_id_7, t0.groupment_id AS groupment_id_8, t0.website_id AS website_id_9 FROM avatar t0 WHERE t0.id = ?
Parameters:
[
60
]
|
||||||||||||||||||||||||||||||||
|
3.32 ms (1.68%) |
4 |
SELECT t0.id AS id_1, t0.number AS number_2, t0.serial_number AS serial_number_3, t0.front_name AS front_name_4, t0.front_description AS front_description_5, t0.front_energy_cost AS front_energy_cost_6, t0.secondary_cost AS secondary_cost_7, t0.front_energy_cost_alias AS front_energy_cost_alias_8, t0.front_energy_color_cost AS front_energy_color_cost_9, t0.back_energy_color_cost AS back_energy_color_cost_10, t0.front_combo_cost AS front_combo_cost_11, t0.front_combo_power AS front_combo_power_12, t0.front_power AS front_power_13, t0.front_defense AS front_defense_14, t0.back_name AS back_name_15, t0.back_description AS back_description_16, t0.back_power AS back_power_17, t0.back_power2 AS back_power2_18, t0.back_defense AS back_defense_19, t0.back_defense2 AS back_defense2_20, t0.img_ready AS img_ready_21, t0.image_ready AS image_ready_22, t0.multicolor AS multicolor_23, t0.limited AS limited_24, t0.banned AS banned_25, t0.unlimited_in_deck AS unlimited_in_deck_26, t0.limitation_in_deck AS limitation_in_deck_27, t0.reprint AS reprint_28, t0.foil AS foil_29, t0.reprint_category AS reprint_category_30, t0.animated AS animated_31, t0.version_number AS version_number_32, t0.front_name_alias AS front_name_alias_33, t0.front_name_en AS front_name_en_34, t0.back_name_en AS back_name_en_35, t0.front_description_en AS front_description_en_36, t0.back_description_en AS back_description_en_37, t0.english_only AS english_only_38, t0.redirect_english_slug AS redirect_english_slug_39, t0.position_serie_list AS position_serie_list_40, t0.lore AS lore_41, t0.subname AS subname_42, t0.illustrator AS illustrator_43, t0.energyzable AS energyzable_44, t0.weakness AS weakness_45, t0.resistance AS resistance_46, t0.sub_description AS sub_description_47, t0.exclusive AS exclusive_48, t0.end_of_serie AS end_of_serie_49, t0.verso AS verso_50, t0.additional_data AS additional_data_51, t0.ocr_keywords_count AS ocr_keywords_count_52, t0.beta AS beta_53, t0.level AS level_54, t0.price_alert AS price_alert_55, t0.creation_date AS creation_date_56, t0.update_date AS update_date_57, t0.displayed AS displayed_58, t0.slug AS slug_59, t0.slug_en AS slug_en_60, t0.view_count AS view_count_61, t0.cmid AS cmid_62, t0.url AS url_63, t0.image AS image_64, t0.current_price AS current_price_65, t0.yesterday_price AS yesterday_price_66, t0.last_price_update AS last_price_update_67, t0.cardnexus_id AS cardnexus_id_68, t0.cardnexus_current_price AS cardnexus_current_price_69, t0.cardnexus_yesterday_price AS cardnexus_yesterday_price_70, t0.cardnexus_last_price_update AS cardnexus_last_price_update_71, t0.lang AS lang_72, t0.release_date AS release_date_73, t0.complete AS complete_74, t0.bandai_tcgid AS bandai_tcgid_75, t0.checked AS checked_76, t0.indexable AS indexable_77, t0.front_era_id AS front_era_id_78, t0.back_era_id AS back_era_id_79, t0.type_id AS type_id_80, t0.serie_id AS serie_id_81, t0.rarity_id AS rarity_id_82, t0.group_version_id AS group_version_id_83, t0.avatar_id AS avatar_id_84, t0.version_id AS version_id_85, t0.auto_play_id AS auto_play_id_86, t0.version_annotation_id AS version_annotation_id_87, t0.website_id AS website_id_88 FROM card t0 WHERE t0.id = ? LIMIT 1
Parameters:
[
"3966"
]
|
||||||||||||||||||||||||||||||||
|
2.40 ms (1.21%) |
1 |
SELECT a0_.id AS id_0, a0_.title AS title_1, a0_.summary AS summary_2, a0_.content AS content_3, a0_.creation_date AS creation_date_4, a0_.update_date AS update_date_5, a0_.displayed AS displayed_6, a0_.slug AS slug_7, a0_.slug_en AS slug_en_8, a0_.view_count AS view_count_9, a0_.like_count AS like_count_10, a0_.website_id AS website_id_11 FROM article a0_ WHERE a0_.displayed = 1 ORDER BY a0_.creation_date DESC LIMIT 10
Parameters:
[]
|
||||||||||||||||||||||||||||||||
|
2.33 ms (1.17%) |
1 |
SELECT a0_.id AS id_0, a0_.reference AS reference_1, a0_.name AS name_2, a0_.summary AS summary_3, a0_.creation_date AS creation_date_4, a0_.update_date AS update_date_5, a0_.displayed AS displayed_6, a0_.slug AS slug_7, a0_.slug_en AS slug_en_8, COUNT(a1_.id) AS sclr_9, a0_.website_id AS website_id_10 FROM article_category a0_ INNER JOIN article_article_category a2_ ON a0_.id = a2_.article_category_id INNER JOIN article a1_ ON a1_.id = a2_.article_id WHERE a1_.displayed = 1 GROUP BY a0_.id ORDER BY a0_.name ASC
Parameters:
[]
|
||||||||||||||||||||||||||||||||
|
2.26 ms (1.14%) |
2 |
SELECT t0.id AS id_1, t0.title AS title_2, t0.summary AS summary_3, t0.content AS content_4, t0.creation_date AS creation_date_5, t0.update_date AS update_date_6, t0.displayed AS displayed_7, t0.slug AS slug_8, t0.slug_en AS slug_en_9, t0.view_count AS view_count_10, t0.like_count AS like_count_11, t0.website_id AS website_id_12 FROM article t0 WHERE t0.slug = ? LIMIT 1
Parameters:
[
"championnat-de-france-dragon-ball-super-card-game-2021"
]
|
||||||||||||||||||||||||||||||||
|
1.98 ms (1.00%) |
9 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.unlocked AS unlocked_3, t0.slug AS slug_4, t0.slug_en AS slug_en_5, t0.displayed AS displayed_6, t0.rarity_id AS rarity_id_7, t0.groupment_id AS groupment_id_8, t0.website_id AS website_id_9 FROM avatar t0 WHERE t0.id = ? LIMIT 1
Parameters:
[
"60"
]
|
||||||||||||||||||||||||||||||||
|
1.87 ms (0.94%) |
1 |
SELECT t0.id AS id_1, t0.reference AS reference_2, t0.name AS name_3, t0.sort_order AS sort_order_4 FROM language t0 INNER JOIN web_site_language ON t0.id = web_site_language.language_id WHERE web_site_language.web_site_id = ? ORDER BY t0.sort_order ASC
Parameters:
[
1
]
|
||||||||||||||||||||||||||||||||
|
1.59 ms (0.80%) |
1 |
INSERT INTO article_view (view_date, ip, article_id, user_id) VALUES (?, ?, ?, ?)
Parameters:
[ "2026-11-12 03:21:17" "216.73.217.31" 17 null ]
|
||||||||||||||||||||||||||||||||
|
1.24 ms (0.63%) |
2 |
SELECT t0.id AS id_1, t0.reference AS reference_2, t0.name AS name_3, t0.name_en AS name_en_4, t0.name_jp AS name_jp_5, t0.color AS color_6, t0.description AS description_7, t0.keyword AS keyword_8, t0.bandai_tcgtext AS bandai_tcgtext_9, t0.bandai_tcgtext_en AS bandai_tcgtext_en_10, t0.displayed AS displayed_11, t0.parent_id AS parent_id_12, t0.website_id AS website_id_13 FROM skill t0 WHERE t0.website_id = ? AND t0.reference = ? LIMIT 1
Parameters:
[ 1 "card:3966" ] |
||||||||||||||||||||||||||||||||
|
0.74 ms (0.37%) |
2 |
SELECT t0.id AS id_1, t0.reference AS reference_2, t0.name AS name_3, t0.name_en AS name_en_4, t0.description AS description_5, t0.total_price AS total_price_6, t0.list_ready AS list_ready_7, t0.timeline_excluded AS timeline_excluded_8, t0.creation_date AS creation_date_9, t0.update_date AS update_date_10, t0.displayed AS displayed_11, t0.slug AS slug_12, t0.slug_en AS slug_en_13, t0.lang AS lang_14, t0.release_date AS release_date_15, t0.cmid AS cmid_16, t0.url AS url_17, t0.image AS image_18, t0.current_price AS current_price_19, t0.yesterday_price AS yesterday_price_20, t0.last_price_update AS last_price_update_21, t0.cardnexus_id AS cardnexus_id_22, t0.cardnexus_current_price AS cardnexus_current_price_23, t0.cardnexus_yesterday_price AS cardnexus_yesterday_price_24, t0.cardnexus_last_price_update AS cardnexus_last_price_update_25, t0.type_id AS type_id_26, t0.website_id AS website_id_27 FROM serie t0 WHERE t0.id = ?
Parameters:
[
67
]
|
||||||||||||||||||||||||||||||||
|
0.70 ms (0.35%) |
1 |
SELECT t0.id AS id_1, t0.reference AS reference_2, t0.name AS name_3, t0.extended_name AS extended_name_4, t0.domain AS domain_5, t0.item_image_prefix AS item_image_prefix_6, t0.image_prefix AS image_prefix_7, t0.image_enprefix AS image_enprefix_8, t0.facebook AS facebook_9, t0.discord AS discord_10, t0.instagram AS instagram_11, t0.decks AS decks_12, t0.wishlists AS wishlists_13, t0.achievements AS achievements_14, t0.blog AS blog_15, t0.shops AS shops_16, t0.ranking AS ranking_17, t0.rules AS rules_18, t0.videos AS videos_19, t0.eras AS eras_20, t0.characters AS characters_21, t0.grading AS grading_22, t0.year AS year_23, t0.game AS game_24, t0.game_condensed AS game_condensed_25, t0.static_folder AS static_folder_26, t0.untap_ccg_type AS untap_ccg_type_27, t0.rarity_iconable AS rarity_iconable_28, t0.description AS description_29, t0.cardmarket_game_id AS cardmarket_game_id_30, t0.cardnexus_game_key AS cardnexus_game_key_31, t0.displayed AS displayed_32, t0.sort_order AS sort_order_33, t0.default_language_id AS default_language_id_34, t0.form_filters_id AS form_filters_id_35 FROM web_site t0 WHERE t0.reference = ? LIMIT 1
Parameters:
[
"dbscards"
]
|
||||||||||||||||||||||||||||||||
|
0.61 ms (0.31%) |
1 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.name_en AS name_en_3, t0.sort_order AS sort_order_4, t0.deck_sort_order AS deck_sort_order_5, t0.leader AS leader_6, t0.displayed AS displayed_7, t0.website_id AS website_id_8 FROM card_type t0 WHERE t0.id = ?
Parameters:
[
4
]
|
||||||||||||||||||||||||||||||||
|
0.58 ms (0.29%) |
1 |
SELECT t0.id AS id_1, t0.max_same_cards AS max_same_cards_2, t0.leader AS leader_3, t0.start_hand_length AS start_hand_length_4, t0.leader_first AS leader_first_5, t0.mulligan AS mulligan_6, t0.nb_max_cards AS nb_max_cards_7, t0.default_deck_area_id AS default_deck_area_id_8, t0.website_id AS website_id_9 FROM deckbuilder t0 WHERE t0.website_id = ? LIMIT 1
Parameters:
[
1
]
|
||||||||||||||||||||||||||||||||
|
0.52 ms (0.26%) |
1 |
SELECT t0.id AS id_1, t0.email AS email_2, t0.pseudo AS pseudo_3, t0.play_id AS play_id_4, t0.roles AS roles_5, t0.password AS password_6, t0.reset_password_link AS reset_password_link_7, t0.last_login_date AS last_login_date_8, t0.facebook_id AS facebook_id_9, t0.facebook_access_token AS facebook_access_token_10, t0.google_id AS google_id_11, t0.discord_id AS discord_id_12, t0.seller_name AS seller_name_13, t0.achievements_points AS achievements_points_14, t0.nb_logins AS nb_logins_15, t0.nb_logins_in_arow AS nb_logins_in_arow_16, t0.max_logins_in_arow AS max_logins_in_arow_17, t0.capsule_count AS capsule_count_18, t0.api_id AS api_id_19, t0.credits AS credits_20, t0.cardnexus_mail AS cardnexus_mail_21, t0.creation_date AS creation_date_22, t0.update_date AS update_date_23, t0.avatar_id AS avatar_id_24, t0.data_player_id AS data_player_id_25, t0.country_id AS country_id_26, t0.department_id AS department_id_27, t0.website_id AS website_id_28, t0.category, t0.youtube_channel AS youtube_channel_29 FROM user t0 WHERE t0.id = ? AND t0.category IN ('USER', 'VIDEOGRAPHER')
Parameters:
[
1
]
|
||||||||||||||||||||||||||||||||
|
0.50 ms (0.25%) |
2 |
SELECT t0.quantity AS quantity_1, t0.card_id AS card_id_2, t0.user_id AS user_id_3 FROM card_owned t0 WHERE t0.card_id = ? AND t0.user_id IS NULL LIMIT 1
Parameters:
[
3966
]
|
||||||||||||||||||||||||||||||||
|
0.41 ms (0.21%) |
1 |
"COMMIT"
Parameters:
[]
|
||||||||||||||||||||||||||||||||
|
0.31 ms (0.16%) |
1 |
UPDATE article SET view_count = ?, update_date = ? WHERE id = ?
Parameters:
[ 5078 "2026-11-12 03:21:17" 17 ]
|
||||||||||||||||||||||||||||||||
|
0.22 ms (0.11%) |
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
0
Hits
0
Misses
0
Puts
Managed Entities
default entity manager
| Class | Amount of managed objects |
|---|---|
| App\Entity\Deck | 16 |
| App\Entity\Card | 11 |
| App\Entity\Avatar\Avatar | 11 |
| App\Entity\Blog\Article | 10 |
| App\Entity\Era | 9 |
| App\Entity\Serie | 9 |
| App\Entity\GroupVersion | 6 |
| App\Entity\Blog\ArticleCategory | 4 |
| App\Entity\Rarity | 4 |
| App\Entity\User | 4 |
| App\Entity\Shop\ShopTournamentPlayer | 4 |
| App\Entity\Avatar\AvatarRarity | 3 |
| App\Entity\WebSite | 2 |
| App\Entity\Language | 2 |
| App\Entity\CardType | 2 |
| App\Entity\Serie\SerieType | 2 |
| App\Entity\Settings\FormFilter | 1 |
| App\Entity\View\ArticleView | 1 |
| App\Entity\Deckbuilder\Deckbuilder | 1 |
| App\Entity\Deckbuilder\DeckArea | 1 |
| App\Entity\Map\Country | 1 |
| App\Entity\Map\Department | 1 |