1
1.54 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 . pseudo = ? AND t0 . category IN ('USER' , 'VIDEOGRAPHER' ) LIMIT 1
Parameters :
[
"Kin0ko123231386 "
]
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 . pseudo = 'Kin0ko123231386' AND t0 . category IN ('USER' , 'VIDEOGRAPHER' ) LIMIT 1 ;
Copy
2
1.50 ms
SELECT t0 . id AS id_1 , t0 . reference AS reference_2 , t0 . name AS name_3 , t0 . description AS description_4 , t0 . goal AS goal_5 , t0 . points AS points_6 , t0 . secure_key AS secure_key_7 , t0 . special AS special_8 , t0 . slug AS slug_9 , t0 . slug_en AS slug_en_10 , t0 . displayed AS displayed_11 , t0 . sort_order AS sort_order_12 , t0 . unlock_before_id AS unlock_before_id_13 FROM achievement t0 WHERE t0 . displayed = ?
SELECT t0 . id AS id_1 , t0 . reference AS reference_2 , t0 . name AS name_3 , t0 . description AS description_4 , t0 . goal AS goal_5 , t0 . points AS points_6 , t0 . secure_key AS secure_key_7 , t0 . special AS special_8 , t0 . slug AS slug_9 , t0 . slug_en AS slug_en_10 , t0 . displayed AS displayed_11 , t0 . sort_order AS sort_order_12 , t0 . unlock_before_id AS unlock_before_id_13 FROM achievement t0 WHERE t0 . displayed = 1 ;
Copy
3
2.69 ms
SELECT t0 . id AS id_1 , t0 . score AS score_2 , t0 . completion AS completion_3 , t0 . finished AS finished_4 , t0 . finish_date AS finish_date_5 , t0 . notified AS notified_6 , t0 . achievement_id AS achievement_id_7 , t0 . user_id AS user_id_8 FROM achievement_user t0 WHERE t0 . user_id = ? AND t0 . finished = ? ORDER BY t0 . finish_date DESC
SELECT t0 . id AS id_1 , t0 . score AS score_2 , t0 . completion AS completion_3 , t0 . finished AS finished_4 , t0 . finish_date AS finish_date_5 , t0 . notified AS notified_6 , t0 . achievement_id AS achievement_id_7 , t0 . user_id AS user_id_8 FROM achievement_user t0 WHERE t0 . user_id = 1333 AND t0 . finished = 1 ORDER BY t0 . finish_date DESC ;
Copy
4
0.64 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 ;
Copy
5
1.80 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_ WHERE d0_ . creator_id = ? AND d0_ . private = 0 AND d0_ . invalid = 0 AND d0_ . deleted = 0 AND d0_ . website_id = ? ORDER BY d0_ . creation_date DESC LIMIT 4
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_ WHERE d0_ . creator_id = 1333 AND d0_ . private = 0 AND d0_ . invalid = 0 AND d0_ . deleted = 0 AND d0_ . website_id = 1 ORDER BY d0_ . creation_date DESC LIMIT 4 ;
Copy
6
0.93 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 :
[
6532
2905
1038
]
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 (? , ? , ? )
Copy
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 (6532 , 2905 , 1038 );
Copy
7
2.04 ms
SELECT s0_ . id AS id_0 , s0_ . elo_player1 AS elo_player1_1 , s0_ . elo_player2 AS elo_player2_2 , s0_ . new_elo_player1 AS new_elo_player1_3 , s0_ . new_elo_player2 AS new_elo_player2_4 , s0_ . player1_id AS player1_id_5 , s0_ . player2_id AS player2_id_6 , s0_ . winner_id AS winner_id_7 , s0_ . shop_tournament_id AS shop_tournament_id_8 FROM shop_match s0_ INNER JOIN shop_tournament s1_ ON s0_ . shop_tournament_id = s1_ . id WHERE s0_ . player1_id = ? OR s0_ . player2_id = ? ORDER BY s1_ . event_date DESC , s0_ . id ASC LIMIT 10
Parameters :
[
1990
1990
]
SELECT s0_ . id AS id_0 , s0_ . elo_player1 AS elo_player1_1 , s0_ . elo_player2 AS elo_player2_2 , s0_ . new_elo_player1 AS new_elo_player1_3 , s0_ . new_elo_player2 AS new_elo_player2_4 , s0_ . player1_id AS player1_id_5 , s0_ . player2_id AS player2_id_6 , s0_ . winner_id AS winner_id_7 , s0_ . shop_tournament_id AS shop_tournament_id_8 FROM shop_match s0_ INNER JOIN shop_tournament s1_ ON s0_ . shop_tournament_id = s1_ . id WHERE s0_ . player1_id = 1990 OR s0_ . player2_id = 1990 ORDER BY s1_ . event_date DESC , s0_ . id ASC LIMIT 10 ;
Copy
8
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 ;
Copy
9
60.55 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 ;
Copy
10
0.59 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 ;
Copy
11
0.65 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 . pseudo = ? AND t0 . category IN ('USER' , 'VIDEOGRAPHER' ) LIMIT 1
Parameters :
[
"Kin0ko123231386 "
]
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 . pseudo = 'Kin0ko123231386' AND t0 . category IN ('USER' , 'VIDEOGRAPHER' ) LIMIT 1 ;
Copy
12
1.39 ms
SELECT t0 . owner_id AS owner_id_1 , t0 . avatar_id AS avatar_id_2 , t0 . website_id AS website_id_3 FROM avatar_web_site t0 WHERE t0 . owner_id = ?
SELECT t0 . owner_id AS owner_id_1 , t0 . avatar_id AS avatar_id_2 , t0 . website_id AS website_id_3 FROM avatar_web_site t0 WHERE t0 . owner_id = 1333 ;
Copy
13
1.21 ms
SELECT t0 . id AS id_1 , t0 . name AS name_2 , t0 . unlocked AS unlocked_3 , t0 . slug AS slug_4 , t0 . slug_en AS slug_en_5 , t0 . displayed AS displayed_6 , t0 . rarity_id AS rarity_id_7 , t0 . groupment_id AS groupment_id_8 , t0 . website_id AS website_id_9 FROM avatar t0 WHERE t0 . id = ?
SELECT t0 . id AS id_1 , t0 . name AS name_2 , t0 . unlocked AS unlocked_3 , t0 . slug AS slug_4 , t0 . slug_en AS slug_en_5 , t0 . displayed AS displayed_6 , t0 . rarity_id AS rarity_id_7 , t0 . groupment_id AS groupment_id_8 , t0 . website_id AS website_id_9 FROM avatar t0 WHERE t0 . id = 45 ;
Copy
14
0.63 ms
SELECT t0 . id AS id_1 , t0 . code AS code_2 , t0 . name AS name_3 , t0 . path AS path_4 , t0 . latitude AS latitude_5 , t0 . longitude AS longitude_6 , t0 . country_id AS country_id_7 , t0 . region_id AS region_id_8 FROM department t0 WHERE t0 . id = ?
SELECT t0 . id AS id_1 , t0 . code AS code_2 , t0 . name AS name_3 , t0 . path AS path_4 , t0 . latitude AS latitude_5 , t0 . longitude AS longitude_6 , t0 . country_id AS country_id_7 , t0 . region_id AS region_id_8 FROM department t0 WHERE t0 . id = 76 ;
Copy
15
0.46 ms
SELECT t0 . id AS id_1 , t0 . code AS code_2 , t0 . name AS name_3 , t0 . name_vo AS name_vo_4 , t0 . french AS french_5 , t0 . view_box AS view_box_6 , t0 . department_label AS department_label_7 , t0 . displayed AS displayed_8 FROM country t0 WHERE t0 . id = ?
SELECT t0 . id AS id_1 , t0 . code AS code_2 , t0 . name AS name_3 , t0 . name_vo AS name_vo_4 , t0 . french AS french_5 , t0 . view_box AS view_box_6 , t0 . department_label AS department_label_7 , t0 . displayed AS displayed_8 FROM country t0 WHERE t0 . id = 1 ;
Copy
16
0.83 ms
SELECT t0 . id AS id_1 , t0 . matches AS matches_2 , t0 . wins AS wins_3 , t0 . loses AS loses_4 , t0 . draws AS draws_5 , t0 . tournaments AS tournaments_6 , t0 . elo AS elo_7 , t0 . pct_wins AS pct_wins_8 , t0 . user_id AS user_id_9 , t0 . website_id AS website_id_10 FROM league_stats t0 WHERE t0 . website_id = ? AND t0 . user_id = ? LIMIT 1
SELECT t0 . id AS id_1 , t0 . matches AS matches_2 , t0 . wins AS wins_3 , t0 . loses AS loses_4 , t0 . draws AS draws_5 , t0 . tournaments AS tournaments_6 , t0 . elo AS elo_7 , t0 . pct_wins AS pct_wins_8 , t0 . user_id AS user_id_9 , t0 . website_id AS website_id_10 FROM league_stats t0 WHERE t0 . website_id = 1 AND t0 . user_id = 1333 LIMIT 1 ;
Copy
17
0.35 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 = 79 ;
Copy
18
0.31 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 ;
Copy
19
0.31 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 ;
Copy
20
0.28 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 ;
Copy