| 1 |
0.83 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"
]
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 = 'dbscards' LIMIT 1;
|
| 2 |
0.98 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
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 = 1 LIMIT 1;
|
| 3 |
1.20 ms
|
SELECT t0.id AS id_1, t0.color AS color_2, t0.multicolor AS multicolor_3, t0.ink AS ink_4, t0.attribute AS attribute_5, t0.special_trait AS special_trait_6, t0.era AS era_7, t0.sub_type AS sub_type_8, t0.energy_cost AS energy_cost_9, t0.power AS power_10, t0.version AS version_11, t0.theme AS theme_12, t0.serie_type AS serie_type_13, t0.`character` AS character_14, t0.character_label AS character_label_15, t0.character_icon AS character_icon_16, t0.special_trait_label AS special_trait_label_17, t0.special_trait_icon AS special_trait_icon_18, t0.special_trait_priority AS special_trait_priority_19, t0.era_label AS era_label_20, t0.era_icon AS era_icon_21, t0.energy_cost_label AS energy_cost_label_22, t0.energy_cost_icon AS energy_cost_icon_23, t0.timing AS timing_24, t0.attribute_label AS attribute_label_25, t0.attribute_icon AS attribute_icon_26, t0.attribute_img_size AS attribute_img_size_27, t0.sub_type_label AS sub_type_label_28, t0.sub_type_icon AS sub_type_icon_29, t0.defense AS defense_30, t0.defense_label AS defense_label_31, t0.defense_icon AS defense_icon_32, t0.power_label AS power_label_33, t0.power_icon AS power_icon_34, t0.secondary_cost AS secondary_cost_35, t0.secondary_cost_label AS secondary_cost_label_36, t0.secondary_cost_icon AS secondary_cost_icon_37, t0.leader_label AS leader_label_38, t0.skill_label AS skill_label_39, t0.additional_data_label AS additional_data_label_40, t0.additional_data_icon AS additional_data_icon_41, t42.id AS id_43, t42.reference AS reference_44, t42.name AS name_45, t42.extended_name AS extended_name_46, t42.domain AS domain_47, t42.item_image_prefix AS item_image_prefix_48, t42.image_prefix AS image_prefix_49, t42.image_enprefix AS image_enprefix_50, t42.facebook AS facebook_51, t42.discord AS discord_52, t42.instagram AS instagram_53, t42.decks AS decks_54, t42.wishlists AS wishlists_55, t42.achievements AS achievements_56, t42.blog AS blog_57, t42.shops AS shops_58, t42.ranking AS ranking_59, t42.rules AS rules_60, t42.videos AS videos_61, t42.eras AS eras_62, t42.characters AS characters_63, t42.grading AS grading_64, t42.year AS year_65, t42.game AS game_66, t42.game_condensed AS game_condensed_67, t42.static_folder AS static_folder_68, t42.untap_ccg_type AS untap_ccg_type_69, t42.rarity_iconable AS rarity_iconable_70, t42.description AS description_71, t42.cardmarket_game_id AS cardmarket_game_id_72, t42.cardnexus_game_key AS cardnexus_game_key_73, t42.displayed AS displayed_74, t42.sort_order AS sort_order_75, t42.default_language_id AS default_language_id_76, t42.form_filters_id AS form_filters_id_77 FROM form_filter t0 LEFT JOIN web_site t42 ON t42.form_filters_id = t0.id WHERE t0.id = ?
SELECT
t0.id AS id_1,
t0.color AS color_2,
t0.multicolor AS multicolor_3,
t0.ink AS ink_4,
t0.attribute AS attribute_5,
t0.special_trait AS special_trait_6,
t0.era AS era_7,
t0.sub_type AS sub_type_8,
t0.energy_cost AS energy_cost_9,
t0.power AS power_10,
t0.version AS version_11,
t0.theme AS theme_12,
t0.serie_type AS serie_type_13,
t0.`character` AS character_14,
t0.character_label AS character_label_15,
t0.character_icon AS character_icon_16,
t0.special_trait_label AS special_trait_label_17,
t0.special_trait_icon AS special_trait_icon_18,
t0.special_trait_priority AS special_trait_priority_19,
t0.era_label AS era_label_20,
t0.era_icon AS era_icon_21,
t0.energy_cost_label AS energy_cost_label_22,
t0.energy_cost_icon AS energy_cost_icon_23,
t0.timing AS timing_24,
t0.attribute_label AS attribute_label_25,
t0.attribute_icon AS attribute_icon_26,
t0.attribute_img_size AS attribute_img_size_27,
t0.sub_type_label AS sub_type_label_28,
t0.sub_type_icon AS sub_type_icon_29,
t0.defense AS defense_30,
t0.defense_label AS defense_label_31,
t0.defense_icon AS defense_icon_32,
t0.power_label AS power_label_33,
t0.power_icon AS power_icon_34,
t0.secondary_cost AS secondary_cost_35,
t0.secondary_cost_label AS secondary_cost_label_36,
t0.secondary_cost_icon AS secondary_cost_icon_37,
t0.leader_label AS leader_label_38,
t0.skill_label AS skill_label_39,
t0.additional_data_label AS additional_data_label_40,
t0.additional_data_icon AS additional_data_icon_41,
t42.id AS id_43,
t42.reference AS reference_44,
t42.name AS name_45,
t42.extended_name AS extended_name_46,
t42.domain AS domain_47,
t42.item_image_prefix AS item_image_prefix_48,
t42.image_prefix AS image_prefix_49,
t42.image_enprefix AS image_enprefix_50,
t42.facebook AS facebook_51,
t42.discord AS discord_52,
t42.instagram AS instagram_53,
t42.decks AS decks_54,
t42.wishlists AS wishlists_55,
t42.achievements AS achievements_56,
t42.blog AS blog_57,
t42.shops AS shops_58,
t42.ranking AS ranking_59,
t42.rules AS rules_60,
t42.videos AS videos_61,
t42.eras AS eras_62,
t42.characters AS characters_63,
t42.grading AS grading_64,
t42.year AS year_65,
t42.game AS game_66,
t42.game_condensed AS game_condensed_67,
t42.static_folder AS static_folder_68,
t42.untap_ccg_type AS untap_ccg_type_69,
t42.rarity_iconable AS rarity_iconable_70,
t42.description AS description_71,
t42.cardmarket_game_id AS cardmarket_game_id_72,
t42.cardnexus_game_key AS cardnexus_game_key_73,
t42.displayed AS displayed_74,
t42.sort_order AS sort_order_75,
t42.default_language_id AS default_language_id_76,
t42.form_filters_id AS form_filters_id_77
FROM
form_filter t0
LEFT JOIN web_site t42 ON t42.form_filters_id = t0.id
WHERE
t0.id = ?
SELECT t0.id AS id_1, t0.color AS color_2, t0.multicolor AS multicolor_3, t0.ink AS ink_4, t0.attribute AS attribute_5, t0.special_trait AS special_trait_6, t0.era AS era_7, t0.sub_type AS sub_type_8, t0.energy_cost AS energy_cost_9, t0.power AS power_10, t0.version AS version_11, t0.theme AS theme_12, t0.serie_type AS serie_type_13, t0.`character` AS character_14, t0.character_label AS character_label_15, t0.character_icon AS character_icon_16, t0.special_trait_label AS special_trait_label_17, t0.special_trait_icon AS special_trait_icon_18, t0.special_trait_priority AS special_trait_priority_19, t0.era_label AS era_label_20, t0.era_icon AS era_icon_21, t0.energy_cost_label AS energy_cost_label_22, t0.energy_cost_icon AS energy_cost_icon_23, t0.timing AS timing_24, t0.attribute_label AS attribute_label_25, t0.attribute_icon AS attribute_icon_26, t0.attribute_img_size AS attribute_img_size_27, t0.sub_type_label AS sub_type_label_28, t0.sub_type_icon AS sub_type_icon_29, t0.defense AS defense_30, t0.defense_label AS defense_label_31, t0.defense_icon AS defense_icon_32, t0.power_label AS power_label_33, t0.power_icon AS power_icon_34, t0.secondary_cost AS secondary_cost_35, t0.secondary_cost_label AS secondary_cost_label_36, t0.secondary_cost_icon AS secondary_cost_icon_37, t0.leader_label AS leader_label_38, t0.skill_label AS skill_label_39, t0.additional_data_label AS additional_data_label_40, t0.additional_data_icon AS additional_data_icon_41, t42.id AS id_43, t42.reference AS reference_44, t42.name AS name_45, t42.extended_name AS extended_name_46, t42.domain AS domain_47, t42.item_image_prefix AS item_image_prefix_48, t42.image_prefix AS image_prefix_49, t42.image_enprefix AS image_enprefix_50, t42.facebook AS facebook_51, t42.discord AS discord_52, t42.instagram AS instagram_53, t42.decks AS decks_54, t42.wishlists AS wishlists_55, t42.achievements AS achievements_56, t42.blog AS blog_57, t42.shops AS shops_58, t42.ranking AS ranking_59, t42.rules AS rules_60, t42.videos AS videos_61, t42.eras AS eras_62, t42.characters AS characters_63, t42.grading AS grading_64, t42.year AS year_65, t42.game AS game_66, t42.game_condensed AS game_condensed_67, t42.static_folder AS static_folder_68, t42.untap_ccg_type AS untap_ccg_type_69, t42.rarity_iconable AS rarity_iconable_70, t42.description AS description_71, t42.cardmarket_game_id AS cardmarket_game_id_72, t42.cardnexus_game_key AS cardnexus_game_key_73, t42.displayed AS displayed_74, t42.sort_order AS sort_order_75, t42.default_language_id AS default_language_id_76, t42.form_filters_id AS form_filters_id_77 FROM form_filter t0 LEFT JOIN web_site t42 ON t42.form_filters_id = t0.id WHERE t0.id = 1;
|
| 4 |
0.87 ms
|
SELECT c0_.id AS id_0, c0_.reference AS reference_1, c0_.name AS name_2, c0_.name_en AS name_en_3, c0_.sort_order AS sort_order_4, c0_.hexadecimal AS hexadecimal_5, c0_.website_id AS website_id_6 FROM color c0_ WHERE c0_.website_id = ? ORDER BY c0_.sort_order ASC, c0_.name ASC
SELECT c0_.id AS id_0, c0_.reference AS reference_1, c0_.name AS name_2, c0_.name_en AS name_en_3, c0_.sort_order AS sort_order_4, c0_.hexadecimal AS hexadecimal_5, c0_.website_id AS website_id_6 FROM color c0_ WHERE c0_.website_id = 1 ORDER BY c0_.sort_order ASC, c0_.name ASC;
|
| 5 |
6.67 ms
|
SELECT count(DISTINCT d0_.id) AS sclr_0 FROM deck d0_ INNER JOIN card c1_ ON d0_.leader_id = c1_.id INNER JOIN deck_area_card d2_ ON d0_.id = d2_.deck_id INNER JOIN card c3_ ON d2_.card_id = c3_.id INNER JOIN user u4_ ON d0_.creator_id = u4_.id AND u4_.category IN ('USER', 'VIDEOGRAPHER') WHERE d0_.deleted = 0 AND d0_.website_id = ? AND (d0_.private = 0 AND d0_.invalid = 0) AND u4_.pseudo LIKE ?
Parameters: [
1
"Geodbs%"
]
SELECT count(DISTINCT d0_.id) AS sclr_0 FROM deck d0_ INNER JOIN card c1_ ON d0_.leader_id = c1_.id INNER JOIN deck_area_card d2_ ON d0_.id = d2_.deck_id INNER JOIN card c3_ ON d2_.card_id = c3_.id INNER JOIN user u4_ ON d0_.creator_id = u4_.id AND u4_.category IN ('USER', 'VIDEOGRAPHER') WHERE d0_.deleted = 0 AND d0_.website_id = 1 AND (d0_.private = 0 AND d0_.invalid = 0) AND u4_.pseudo LIKE 'Geodbs%';
|
| 6 |
1.37 ms
|
SELECT DISTINCT d0_.id AS id_0, d0_.creation_date AS creation_date_1 FROM deck d0_ INNER JOIN card c1_ ON d0_.leader_id = c1_.id INNER JOIN deck_area_card d2_ ON d0_.id = d2_.deck_id INNER JOIN card c3_ ON d2_.card_id = c3_.id INNER JOIN user u4_ ON d0_.creator_id = u4_.id AND u4_.category IN ('USER', 'VIDEOGRAPHER') WHERE d0_.deleted = 0 AND d0_.website_id = ? AND (d0_.private = 0 AND d0_.invalid = 0) AND u4_.pseudo LIKE ? ORDER BY d0_.creation_date DESC LIMIT 30
Parameters: [
1
"Geodbs%"
]
SELECT DISTINCT d0_.id AS id_0, d0_.creation_date AS creation_date_1 FROM deck d0_ INNER JOIN card c1_ ON d0_.leader_id = c1_.id INNER JOIN deck_area_card d2_ ON d0_.id = d2_.deck_id INNER JOIN card c3_ ON d2_.card_id = c3_.id INNER JOIN user u4_ ON d0_.creator_id = u4_.id AND u4_.category IN ('USER', 'VIDEOGRAPHER') WHERE d0_.deleted = 0 AND d0_.website_id = 1 AND (d0_.private = 0 AND d0_.invalid = 0) AND u4_.pseudo LIKE 'Geodbs%' ORDER BY d0_.creation_date DESC LIMIT 30;
|
| 7 |
6.25 ms
|
SELECT d0_.id AS id_0, d0_.uniqid AS uniqid_1, d0_.name AS name_2, d0_.private AS private_3, d0_.invalid AS invalid_4, d0_.starter AS starter_5, d0_.dev_team AS dev_team_6, d0_.meta AS meta_7, d0_.total_price AS total_price_8, d0_.untap_click_count AS untap_click_count_9, d0_.creation_date AS creation_date_10, d0_.update_date AS update_date_11, d0_.view_count AS view_count_12, d0_.like_count AS like_count_13, d0_.deleted AS deleted_14, d0_.leader_id AS leader_id_15, d0_.creator_id AS creator_id_16, d0_.event_id AS event_id_17, d0_.website_id AS website_id_18 FROM deck d0_ INNER JOIN card c1_ ON d0_.leader_id = c1_.id INNER JOIN deck_area_card d2_ ON d0_.id = d2_.deck_id INNER JOIN card c3_ ON d2_.card_id = c3_.id INNER JOIN user u4_ ON d0_.creator_id = u4_.id AND u4_.category IN ('USER', 'VIDEOGRAPHER') WHERE d0_.deleted = 0 AND d0_.website_id = ? AND (d0_.private = 0 AND d0_.invalid = 0) AND u4_.pseudo LIKE ? AND d0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) ORDER BY d0_.creation_date DESC
Parameters: [
1
"Geodbs%"
4926
4700
4680
4679
4567
4558
4491
4490
4476
4475
4471
4469
4468
4467
4075
]
SELECT d0_.id AS id_0, d0_.uniqid AS uniqid_1, d0_.name AS name_2, d0_.private AS private_3, d0_.invalid AS invalid_4, d0_.starter AS starter_5, d0_.dev_team AS dev_team_6, d0_.meta AS meta_7, d0_.total_price AS total_price_8, d0_.untap_click_count AS untap_click_count_9, d0_.creation_date AS creation_date_10, d0_.update_date AS update_date_11, d0_.view_count AS view_count_12, d0_.like_count AS like_count_13, d0_.deleted AS deleted_14, d0_.leader_id AS leader_id_15, d0_.creator_id AS creator_id_16, d0_.event_id AS event_id_17, d0_.website_id AS website_id_18 FROM deck d0_ INNER JOIN card c1_ ON d0_.leader_id = c1_.id INNER JOIN deck_area_card d2_ ON d0_.id = d2_.deck_id INNER JOIN card c3_ ON d2_.card_id = c3_.id INNER JOIN user u4_ ON d0_.creator_id = u4_.id AND u4_.category IN ('USER', 'VIDEOGRAPHER') WHERE d0_.deleted = 0 AND d0_.website_id = 1 AND (d0_.private = 0 AND d0_.invalid = 0) AND u4_.pseudo LIKE 'Geodbs%' AND d0_.id IN (4926, 4700, 4680, 4679, 4567, 4558, 4491, 4490, 4476, 4475, 4471, 4469, 4468, 4467, 4075) ORDER BY d0_.creation_date DESC;
|
| 8 |
0.93 ms
|
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')
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 = 995 AND t0.category IN ('USER', 'VIDEOGRAPHER');
|
| 9 |
1.45 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 IN (?)
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 IN (?)
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 IN (4994);
|
| 10 |
1.73 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 IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters: [
5081
5052
3848
3882
4749
1912
1033
553
1287
2220
929
1907
794
5082
]
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 IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
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 IN (5081, 5052, 3848, 3882, 4749, 1912, 1033, 553, 1287, 2220, 929, 1907, 794, 5082);
|
| 11 |
4.44 ms
|
SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.name_en AS name_en_2, c0_.description AS description_3, c0_.slug AS slug_4, c0_.slug_en AS slug_en_5, c0_.creation_date AS creation_date_6, c0_.update_date AS update_date_7, c0_.website_id AS website_id_8 FROM `character` c0_ WHERE c0_.website_id = ? ORDER BY c0_.name ASC
SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.name_en AS name_en_2, c0_.description AS description_3, c0_.slug AS slug_4, c0_.slug_en AS slug_en_5, c0_.creation_date AS creation_date_6, c0_.update_date AS update_date_7, c0_.website_id AS website_id_8 FROM `character` c0_ WHERE c0_.website_id = 1 ORDER BY c0_.name ASC;
|
| 12 |
1.47 ms
|
SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.name_en AS name_en_2, s0_.website_id AS website_id_3 FROM special_trait s0_ WHERE s0_.website_id = ? ORDER BY s0_.name ASC
SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.name_en AS name_en_2, s0_.website_id AS website_id_3 FROM special_trait s0_ WHERE s0_.website_id = 1 ORDER BY s0_.name ASC;
|
| 13 |
0.78 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
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 = 1 LIMIT 1;
|
| 14 |
122.17 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
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 = 1 AND c0_.cardnexus_current_price < c0_.current_price;
|
| 15 |
0.79 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
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 = 1 ORDER BY t0.sort_order ASC;
|
| 16 |
0.97 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
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 = 1 LIMIT 1;
|
| 17 |
0.66 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
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 = 1 LIMIT 1;
|
| 18 |
0.52 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
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 = 1 LIMIT 1;
|
| 19 |
0.70 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
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 = 1 LIMIT 1;
|
| 20 |
0.60 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
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 = 1 LIMIT 1;
|
| 21 |
0.54 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
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 = 1 LIMIT 1;
|
| 22 |
0.70 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
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 = 1 LIMIT 1;
|
| 23 |
0.59 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
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 = 1 LIMIT 1;
|
| 24 |
0.62 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
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 = 1 LIMIT 1;
|
| 25 |
0.70 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
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 = 1 LIMIT 1;
|
| 26 |
0.52 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
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 = 1 LIMIT 1;
|
| 27 |
0.65 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
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 = 1 LIMIT 1;
|
| 28 |
0.85 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 = ?
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 = 33;
|
| 29 |
0.62 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
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 = 1 LIMIT 1;
|
| 30 |
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 = ?
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 = 12;
|
| 31 |
0.52 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
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 = 1 LIMIT 1;
|
| 32 |
0.52 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
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 = 1 LIMIT 1;
|