GET https://dev.tcgcards.fr/

Response
200 OK
IP
91.196.152.114
Profiled on
Token
64a741

Query Metrics

80 Database Queries
15 Different statements
403.23 ms Query time
1 Invalid entities
108 Managed entities
0 Cache hits
0 Cache misses
0 Cache puts

Queries

Group similar statements

#▲ Time Info
1 0.84 ms 
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"
]
View formatted query    View runnable query    Explain query    View query backtrace
2 0.67 ms 
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
]
View formatted query    View runnable query    Explain query    View query backtrace
3 92.96 ms 
SELECT c0_.id AS id_0, c0_.number AS number_1, c0_.serial_number AS serial_number_2, c0_.front_name AS front_name_3, c0_.front_description AS front_description_4, c0_.front_energy_cost AS front_energy_cost_5, c0_.secondary_cost AS secondary_cost_6, c0_.front_energy_cost_alias AS front_energy_cost_alias_7, c0_.front_energy_color_cost AS front_energy_color_cost_8, c0_.back_energy_color_cost AS back_energy_color_cost_9, c0_.front_combo_cost AS front_combo_cost_10, c0_.front_combo_power AS front_combo_power_11, c0_.front_power AS front_power_12, c0_.front_defense AS front_defense_13, c0_.back_name AS back_name_14, c0_.back_description AS back_description_15, c0_.back_power AS back_power_16, c0_.back_power2 AS back_power2_17, c0_.back_defense AS back_defense_18, c0_.back_defense2 AS back_defense2_19, c0_.img_ready AS img_ready_20, c0_.image_ready AS image_ready_21, c0_.multicolor AS multicolor_22, c0_.limited AS limited_23, c0_.banned AS banned_24, c0_.unlimited_in_deck AS unlimited_in_deck_25, c0_.limitation_in_deck AS limitation_in_deck_26, c0_.reprint AS reprint_27, c0_.foil AS foil_28, c0_.reprint_category AS reprint_category_29, c0_.animated AS animated_30, c0_.version_number AS version_number_31, c0_.front_name_alias AS front_name_alias_32, c0_.front_name_en AS front_name_en_33, c0_.back_name_en AS back_name_en_34, c0_.front_description_en AS front_description_en_35, c0_.back_description_en AS back_description_en_36, c0_.english_only AS english_only_37, c0_.redirect_english_slug AS redirect_english_slug_38, c0_.position_serie_list AS position_serie_list_39, c0_.lore AS lore_40, c0_.subname AS subname_41, c0_.illustrator AS illustrator_42, c0_.energyzable AS energyzable_43, c0_.weakness AS weakness_44, c0_.resistance AS resistance_45, c0_.sub_description AS sub_description_46, c0_.exclusive AS exclusive_47, c0_.end_of_serie AS end_of_serie_48, c0_.verso AS verso_49, c0_.additional_data AS additional_data_50, c0_.ocr_keywords_count AS ocr_keywords_count_51, c0_.beta AS beta_52, c0_.level AS level_53, c0_.price_alert AS price_alert_54, c0_.creation_date AS creation_date_55, c0_.update_date AS update_date_56, c0_.displayed AS displayed_57, c0_.slug AS slug_58, c0_.slug_en AS slug_en_59, c0_.view_count AS view_count_60, c0_.cmid AS cmid_61, c0_.url AS url_62, c0_.image AS image_63, c0_.current_price AS current_price_64, c0_.yesterday_price AS yesterday_price_65, c0_.last_price_update AS last_price_update_66, c0_.cardnexus_id AS cardnexus_id_67, c0_.cardnexus_current_price AS cardnexus_current_price_68, c0_.cardnexus_yesterday_price AS cardnexus_yesterday_price_69, c0_.cardnexus_last_price_update AS cardnexus_last_price_update_70, c0_.lang AS lang_71, c0_.release_date AS release_date_72, c0_.complete AS complete_73, c0_.bandai_tcgid AS bandai_tcgid_74, c0_.checked AS checked_75, c0_.indexable AS indexable_76, s1_.id AS id_77, s1_.reference AS reference_78, s1_.name AS name_79, s1_.name_en AS name_en_80, s1_.description AS description_81, s1_.total_price AS total_price_82, s1_.list_ready AS list_ready_83, s1_.timeline_excluded AS timeline_excluded_84, s1_.creation_date AS creation_date_85, s1_.update_date AS update_date_86, s1_.displayed AS displayed_87, s1_.slug AS slug_88, s1_.slug_en AS slug_en_89, s1_.lang AS lang_90, s1_.release_date AS release_date_91, s1_.cmid AS cmid_92, s1_.url AS url_93, s1_.image AS image_94, s1_.current_price AS current_price_95, s1_.yesterday_price AS yesterday_price_96, s1_.last_price_update AS last_price_update_97, s1_.cardnexus_id AS cardnexus_id_98, s1_.cardnexus_current_price AS cardnexus_current_price_99, s1_.cardnexus_yesterday_price AS cardnexus_yesterday_price_100, s1_.cardnexus_last_price_update AS cardnexus_last_price_update_101, c0_.front_era_id AS front_era_id_102, c0_.back_era_id AS back_era_id_103, c0_.type_id AS type_id_104, c0_.serie_id AS serie_id_105, c0_.rarity_id AS rarity_id_106, c0_.group_version_id AS group_version_id_107, c0_.avatar_id AS avatar_id_108, c0_.version_id AS version_id_109, c0_.auto_play_id AS auto_play_id_110, c0_.version_annotation_id AS version_annotation_id_111, c0_.website_id AS website_id_112, s1_.type_id AS type_id_113, s1_.website_id AS website_id_114 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 GROUP BY c0_.id ORDER BY c0_.current_price - c0_.cardnexus_current_price DESC LIMIT 12
Parameters: 
[
  1
]
View formatted query    View runnable query    Explain query    View query backtrace
4 6.97 ms 
SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.description AS description_2, p0_.price AS price_3, p0_.promo_price AS promo_price_4, p0_.available AS available_5, p0_.preorder AS preorder_6, p0_.preorder_date AS preorder_date_7, p0_.nb_items AS nb_items_8, p0_.redirection AS redirection_9, p0_.group_ref AS group_ref_10, p0_.brand AS brand_11, p0_.displayed AS displayed_12, p0_.creation_date AS creation_date_13, p0_.update_date AS update_date_14, p0_.slug AS slug_15, p0_.slug_en AS slug_en_16, p0_.link AS link_17, p0_.cmid AS cmid_18, p0_.url AS url_19, p0_.image AS image_20, p0_.current_price AS current_price_21, p0_.yesterday_price AS yesterday_price_22, p0_.last_price_update AS last_price_update_23, p0_.cardnexus_id AS cardnexus_id_24, p0_.cardnexus_current_price AS cardnexus_current_price_25, p0_.cardnexus_yesterday_price AS cardnexus_yesterday_price_26, p0_.cardnexus_last_price_update AS cardnexus_last_price_update_27, p0_.lang AS lang_28, p0_.release_date AS release_date_29, p0_.category_id AS category_id_30, p0_.serie_id AS serie_id_31, p0_.website_id AS website_id_32 FROM product p0_ WHERE p0_.displayed = 1 AND p0_.website_id = ? AND p0_.current_price IS NOT NULL AND (p0_.cmid IS NOT NULL OR (p0_.available = 1 AND p0_.link IS NOT NULL AND p0_.link <> '')) ORDER BY p0_.release_date DESC LIMIT 12
Parameters: 
[
  1
]
View formatted query    View runnable query    Explain query    View query backtrace
5 1.15 ms 
SELECT t0.id AS id_1, t0.card_id AS card_id_2, t0.website_id AS website_id_3 FROM card_most_popular t0 WHERE t0.website_id = ? LIMIT 12
Parameters: 
[
  1
]
View formatted query    View runnable query    Explain query    View query backtrace
6 192.89 ms 
SELECT v0_.id AS id_0, v0_.identifier AS identifier_1, v0_.name AS name_2, v0_.description AS description_3, v0_.short_description AS short_description_4, v0_.publish_date AS publish_date_5, v0_.creation_date AS creation_date_6, v0_.update_date AS update_date_7, v0_.slug AS slug_8, v0_.slug_en AS slug_en_9, v0_.displayed AS displayed_10, v0_.view_count AS view_count_11, v0_.like_count AS like_count_12, v0_.lang AS lang_13, v0_.mark AS mark_14, v0_.media AS media_15, v0_.videographer_id AS videographer_id_16, v0_.source_id AS source_id_17, v0_.website_id AS website_id_18 FROM video v0_ WHERE (v0_.displayed = 1 AND v0_.website_id = ?) AND v0_.media IN ('YOUTUBE') ORDER BY RAND() ASC LIMIT 5
Parameters: 
[
  1
]
View formatted query    View runnable query    Explain query    View query backtrace
7 0.56 ms 
SELECT t0.id AS id_1, t0.identifier AS identifier_2, t0.name AS name_3, t0.lang AS lang_4, t0.displayed AS displayed_5, t0.website_id AS website_id_6, t0.source FROM video_source t0 WHERE t0.id = ? AND t0.source IN ('YTB_PLAYLIST')
Parameters: 
[
  3
]
View formatted query    View runnable query    Explain query    View query backtrace
8 0.52 ms 
SELECT t0.id AS id_1, t0.identifier AS identifier_2, t0.name AS name_3, t0.lang AS lang_4, t0.displayed AS displayed_5, t0.website_id AS website_id_6, t0.source FROM video_source t0 WHERE t0.id = ? AND t0.source IN ('YTB_PLAYLIST')
Parameters: 
[
  4
]
View formatted query    View runnable query    Explain query    View query backtrace
9 0.47 ms 
SELECT t0.id AS id_1, t0.identifier AS identifier_2, t0.name AS name_3, t0.lang AS lang_4, t0.displayed AS displayed_5, t0.website_id AS website_id_6, t0.source FROM video_source t0 WHERE t0.id = ? AND t0.source IN ('YTB_PLAYLIST')
Parameters: 
[
  14
]
View formatted query    View runnable query    Explain query    View query backtrace
10 0.43 ms 
SELECT t0.id AS id_1, t0.identifier AS identifier_2, t0.name AS name_3, t0.lang AS lang_4, t0.displayed AS displayed_5, t0.website_id AS website_id_6, t0.source FROM video_source t0 WHERE t0.id = ? AND t0.source IN ('YTB_PLAYLIST')
Parameters: 
[
  26
]
View formatted query    View runnable query    Explain query    View query backtrace
11 64.46 ms 
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
]
View formatted query    View runnable query    Explain query    View query backtrace
12 0.75 ms 
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
]
View formatted query    View runnable query    Explain query    View query backtrace
13 0.43 ms 
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: 
[
  8092
]
View formatted query    View runnable query    Explain query    View query backtrace
14 0.47 ms 
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
]
View formatted query    View runnable query    Explain query    View query backtrace
15 0.43 ms 
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: 
[
  3890
]
View formatted query    View runnable query    Explain query    View query backtrace
16 0.43 ms 
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: 
[
  2656
]
View formatted query    View runnable query    Explain query    View query backtrace
17 0.42 ms 
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: 
[
  3817
]
View formatted query    View runnable query    Explain query    View query backtrace
18 0.45 ms 
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: 
[
  5
]
View formatted query    View runnable query    Explain query    View query backtrace
19 0.42 ms 
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: 
[
  3565
]
View formatted query    View runnable query    Explain query    View query backtrace
20 0.44 ms 
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: 
[
  6
]
View formatted query    View runnable query    Explain query    View query backtrace
21 0.43 ms 
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: 
[
  88122
]
View formatted query    View runnable query    Explain query    View query backtrace
22 0.41 ms 
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: 
[
  1942
]
View formatted query    View runnable query    Explain query    View query backtrace
23 0.41 ms 
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: 
[
  6050
]
View formatted query    View runnable query    Explain query    View query backtrace
24 0.46 ms 
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: 
[
  3551
]
View formatted query    View runnable query    Explain query    View query backtrace
25 0.37 ms 
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: 
[
  8269
]
View formatted query    View runnable query    Explain query    View query backtrace
26 0.43 ms 
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: 
[
  6129
]
View formatted query    View runnable query    Explain query    View query backtrace
27 0.41 ms 
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: 
[
  4250
]
View formatted query    View runnable query    Explain query    View query backtrace
28 0.59 ms 
SELECT t0.id AS id_1, t0.name AS name_2, t0.no_language AS no_language_3, t0.displayed AS displayed_4, t0.creation_date AS creation_date_5, t0.update_date AS update_date_6, t0.slug AS slug_7, t0.slug_en AS slug_en_8, t0.link AS link_9, t0.parent_id AS parent_id_10 FROM product_category t0 WHERE t0.id = ?
Parameters: 
[
  3
]
View formatted query    View runnable query    Explain query    View query backtrace
29 0.46 ms 
SELECT t0.quantity AS quantity_1, t0.product_id AS product_id_2, t0.user_id AS user_id_3 FROM product_owned t0 WHERE t0.product_id = ? AND t0.user_id IS NULL LIMIT 1
Parameters: 
[
  1882
]
View formatted query    View runnable query    Explain query    View query backtrace
30 0.60 ms 
SELECT t0.id AS id_1, t0.name AS name_2, t0.no_language AS no_language_3, t0.displayed AS displayed_4, t0.creation_date AS creation_date_5, t0.update_date AS update_date_6, t0.slug AS slug_7, t0.slug_en AS slug_en_8, t0.link AS link_9, t0.parent_id AS parent_id_10 FROM product_category t0 WHERE t0.id = ?
Parameters: 
[
  2
]
View formatted query    View runnable query    Explain query    View query backtrace
31 0.38 ms 
SELECT t0.quantity AS quantity_1, t0.product_id AS product_id_2, t0.user_id AS user_id_3 FROM product_owned t0 WHERE t0.product_id = ? AND t0.user_id IS NULL LIMIT 1
Parameters: 
[
  1932
]
View formatted query    View runnable query    Explain query    View query backtrace
32 0.47 ms 
SELECT t0.quantity AS quantity_1, t0.product_id AS product_id_2, t0.user_id AS user_id_3 FROM product_owned t0 WHERE t0.product_id = ? AND t0.user_id IS NULL LIMIT 1
Parameters: 
[
  1310
]
View formatted query    View runnable query    Explain query    View query backtrace
33 0.47 ms 
SELECT t0.quantity AS quantity_1, t0.product_id AS product_id_2, t0.user_id AS user_id_3 FROM product_owned t0 WHERE t0.product_id = ? AND t0.user_id IS NULL LIMIT 1
Parameters: 
[
  1301
]
View formatted query    View runnable query    Explain query    View query backtrace
34 0.52 ms 
SELECT t0.quantity AS quantity_1, t0.product_id AS product_id_2, t0.user_id AS user_id_3 FROM product_owned t0 WHERE t0.product_id = ? AND t0.user_id IS NULL LIMIT 1
Parameters: 
[
  1309
]
View formatted query    View runnable query    Explain query    View query backtrace
35 0.49 ms 
SELECT t0.quantity AS quantity_1, t0.product_id AS product_id_2, t0.user_id AS user_id_3 FROM product_owned t0 WHERE t0.product_id = ? AND t0.user_id IS NULL LIMIT 1
Parameters: 
[
  1202
]
View formatted query    View runnable query    Explain query    View query backtrace
36 0.48 ms 
SELECT t0.quantity AS quantity_1, t0.product_id AS product_id_2, t0.user_id AS user_id_3 FROM product_owned t0 WHERE t0.product_id = ? AND t0.user_id IS NULL LIMIT 1
Parameters: 
[
  1308
]
View formatted query    View runnable query    Explain query    View query backtrace
37 0.49 ms 
SELECT t0.quantity AS quantity_1, t0.product_id AS product_id_2, t0.user_id AS user_id_3 FROM product_owned t0 WHERE t0.product_id = ? AND t0.user_id IS NULL LIMIT 1
Parameters: 
[
  1100
]
View formatted query    View runnable query    Explain query    View query backtrace
38 0.60 ms 
SELECT t0.quantity AS quantity_1, t0.product_id AS product_id_2, t0.user_id AS user_id_3 FROM product_owned t0 WHERE t0.product_id = ? AND t0.user_id IS NULL LIMIT 1
Parameters: 
[
  1208
]
View formatted query    View runnable query    Explain query    View query backtrace
39 0.49 ms 
SELECT t0.quantity AS quantity_1, t0.product_id AS product_id_2, t0.user_id AS user_id_3 FROM product_owned t0 WHERE t0.product_id = ? AND t0.user_id IS NULL LIMIT 1
Parameters: 
[
  1306
]
View formatted query    View runnable query    Explain query    View query backtrace
40 0.53 ms 
SELECT t0.quantity AS quantity_1, t0.product_id AS product_id_2, t0.user_id AS user_id_3 FROM product_owned t0 WHERE t0.product_id = ? AND t0.user_id IS NULL LIMIT 1
Parameters: 
[
  1307
]
View formatted query    View runnable query    Explain query    View query backtrace
41 0.51 ms 
SELECT t0.quantity AS quantity_1, t0.product_id AS product_id_2, t0.user_id AS user_id_3 FROM product_owned t0 WHERE t0.product_id = ? AND t0.user_id IS NULL LIMIT 1
Parameters: 
[
  917
]
View formatted query    View runnable query    Explain query    View query backtrace
42 1.25 ms 
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 = ?
Parameters: 
[
  1461
]
View formatted query    View runnable query    Explain query    View query backtrace
43 0.53 ms 
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: 
[
  1461
]
View formatted query    View runnable query    Explain query    View query backtrace
44 0.75 ms 
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: 
[
  26
]
View formatted query    View runnable query    Explain query    View query backtrace
45 0.53 ms 
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: 
[
  3890
]
View formatted query    View runnable query    Explain query    View query backtrace
46 1.25 ms 
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 = ?
Parameters: 
[
  19200
]
View formatted query    View runnable query    Explain query    View query backtrace
47 0.56 ms 
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: 
[
  19200
]
View formatted query    View runnable query    Explain query    View query backtrace
48 0.86 ms 
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: 
[
  270
]
View formatted query    View runnable query    Explain query    View query backtrace
49 1.27 ms 
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 = ?
Parameters: 
[
  88128
]
View formatted query    View runnable query    Explain query    View query backtrace
50 0.50 ms 
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: 
[
  88128
]
View formatted query    View runnable query    Explain query    View query backtrace
51 1.25 ms 
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 = ?
Parameters: 
[
  1919
]
View formatted query    View runnable query    Explain query    View query backtrace
52 0.61 ms 
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: 
[
  1919
]
View formatted query    View runnable query    Explain query    View query backtrace
53 0.72 ms 
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: 
[
  34
]
View formatted query    View runnable query    Explain query    View query backtrace
54 1.28 ms 
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 = ?
Parameters: 
[
  529
]
View formatted query    View runnable query    Explain query    View query backtrace
55 0.57 ms 
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: 
[
  529
]
View formatted query    View runnable query    Explain query    View query backtrace
56 0.76 ms 
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: 
[
  8
]
View formatted query    View runnable query    Explain query    View query backtrace
57 0.63 ms 
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: 
[
  7537
]
View formatted query    View runnable query    Explain query    View query backtrace
58 0.66 ms 
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: 
[
  77073
]
View formatted query    View runnable query    Explain query    View query backtrace
59 0.62 ms 
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: 
[
  77024
]
View formatted query    View runnable query    Explain query    View query backtrace
60 0.68 ms 
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: 
[
  88126
]
View formatted query    View runnable query    Explain query    View query backtrace
61 0.63 ms 
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: 
[
  6721
]
View formatted query    View runnable query    Explain query    View query backtrace
62 0.54 ms 
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: 
[
  9290
]
View formatted query    View runnable query    Explain query    View query backtrace
63 0.57 ms 
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: 
[
  14875
]
View formatted query    View runnable query    Explain query    View query backtrace
64 0.57 ms 
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: 
[
  14948
]
View formatted query    View runnable query    Explain query    View query backtrace
65 0.62 ms 
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: 
[
  81192
]
View formatted query    View runnable query    Explain query    View query backtrace
66 0.52 ms 
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: 
[
  81193
]
View formatted query    View runnable query    Explain query    View query backtrace
67 0.53 ms 
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: 
[
  8808
]
View formatted query    View runnable query    Explain query    View query backtrace
68 0.53 ms 
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: 
[
  8548
]
View formatted query    View runnable query    Explain query    View query backtrace
69 0.54 ms 
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: 
[
  29747
]
View formatted query    View runnable query    Explain query    View query backtrace
70 0.51 ms 
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: 
[
  29587
]
View formatted query    View runnable query    Explain query    View query backtrace
71 0.51 ms 
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: 
[
  5665
]
View formatted query    View runnable query    Explain query    View query backtrace
72 0.53 ms 
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: 
[
  88120
]
View formatted query    View runnable query    Explain query    View query backtrace
73 0.65 ms 
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: 
[
  5746
]
View formatted query    View runnable query    Explain query    View query backtrace
74 0.51 ms 
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: 
[
  9555
]
View formatted query    View runnable query    Explain query    View query backtrace
75 0.60 ms 
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: 
[
  7765
]
View formatted query    View runnable query    Explain query    View query backtrace
76 0.45 ms 
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: 
[
  37311
]
View formatted query    View runnable query    Explain query    View query backtrace
77 0.67 ms 
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: 
[
  7673
]
View formatted query    View runnable query    Explain query    View query backtrace
78 0.99 ms 
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: 
[
  24360
]
View formatted query    View runnable query    Explain query    View query backtrace
79 0.59 ms 
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: 
[
  7232
]
View formatted query    View runnable query    Explain query    View query backtrace
80 0.73 ms 
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: 
[
  8559
]
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

0 Hits
0 Misses
0 Puts

Managed Entities

default entity manager

Class Amount of managed objects
App\Entity\Serie 20
App\Entity\Card 17
App\Entity\Product\Product 12
App\Entity\Era 9
App\Entity\Rarity 9
App\Entity\GroupVersion 9
App\Entity\CardMostPopular 6
App\Entity\Video\Video 5
App\Entity\Serie\SerieType 4
App\Entity\Video\VideoSource 4
App\Entity\CardType 3
App\Entity\Language 2
App\Entity\Product\ProductCategory 2
App\Entity\WebSite 1
App\Entity\Settings\FormFilter 1
App\Entity\Deckbuilder\Deckbuilder 1
App\Entity\Deckbuilder\DeckArea 1
App\Entity\CardVersion 1
App\Entity\Card\CardVersionAnnotation 1

Entities Mapping

Class Mapping errors
App\Entity\WebSite No errors.
App\Entity\Language No errors.
App\Entity\Settings\FormFilter No errors.
App\Entity\User No errors.
App\Entity\Support\Ticket No errors.
App\Entity\Card No errors.
App\Entity\Deckbuilder\Deckbuilder No errors.
App\Entity\Deckbuilder\DeckArea No errors.
App\Entity\Deckbuilder\DeckBuilderSkill No errors.
App\Entity\Serie No errors.
App\Entity\Era No errors.
App\Entity\CardType No errors.
App\Entity\Rarity No errors.
App\Entity\GroupVersion No errors.
App\Entity\Avatar\Avatar No errors.
App\Entity\CardVersion No errors.
App\Entity\Card\CardVersionAnnotation No errors.
App\Entity\Serie\SerieType No errors.
App\Entity\Character No errors.
App\Entity\SpecialTrait No errors.
App\Entity\Color No errors.
App\Entity\Snapshot No errors.
App\Entity\Skill No errors.
App\Entity\Card\Timing No errors.
App\Entity\CardTag No errors.
App\Entity\Deck No errors.
App\Entity\Deckbuilder\DeckAreaCard No errors.
App\Entity\CardOwned No errors.
App\Entity\WishlistCard No errors.
App\Entity\Partnership\CardmarketClick No errors.
App\Entity\FAQ No errors.
App\Entity\Errata No errors.
App\Entity\CardAssociation No errors.
App\Entity\Product\Product No errors.
App\Entity\View\CardView No errors.
App\Entity\User\CardSale No errors.
App\Entity\Card\Ink No errors.
App\Entity\Card\Attribute No errors.
App\Entity\SubCardType No errors.
App\Entity\Stream\DisplayerHistory No errors.
App\Entity\Card\Digivolution No errors.
App\Entity\SerieRarity No errors.
App\Entity\Product\ProductCategory No errors.
App\Entity\Partnership\GoupiyaClick No errors.
App\Entity\Video\Video No errors.
App\Entity\Product\ProductSale
  • The association App\Entity\Product\ProductSale#user refers to the inverse side App\Entity\User#sales which targets a different entity (App\Entity\User\CardSale).
App\Entity\Product\ProductSnapshot No errors.
App\Entity\Product\ProductOwned No errors.
App\Entity\Product\ProductContent No errors.
App\Entity\CardMostPopular No errors.
App\Entity\Video\YoutubeVideo No errors.
App\Entity\Video\Videographer No errors.
App\Entity\Video\VideoSource No errors.
App\Entity\Video\YoutubePlaylist No errors.
App\Entity\Video\VideoTag No errors.
App\Entity\Video\VideoReview No errors.