Symfony Profiler

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

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;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.private AS private_3,
  t0.started AS started_4,
  t0.start_date AS start_date_5,
  t0.nb_players_max AS nb_players_max_6,
  t0.description AS description_7,
  t0.history AS history_8,
  t0.nb_rounds_max AS nb_rounds_max_9,
  t0.draw_accepted AS draw_accepted_10,
  t0.topcut_phase AS topcut_phase_11,
  t0.slug AS slug_12,
  t0.slug_en AS slug_en_13,
  t0.creation_date AS creation_date_14,
  t0.update_date AS update_date_15,
  t0.finished AS finished_16,
  t0.winner_id AS winner_id_17,
  t0.creator_id AS creator_id_18,
  t0.current_round_id AS current_round_id_19,
  t0.previous_round_id AS previous_round_id_20,
  t0.category_id AS category_id_21,
  t0.rule_id AS rule_id_22,
  t0.topcut_rule_id AS topcut_rule_id_23,
  t0.website_id AS website_id_24
FROM
  tournament t0
WHERE
  t0.slug = ?
  AND t0.website_id = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.private AS private_3, t0.started AS started_4, t0.start_date AS start_date_5, t0.nb_players_max AS nb_players_max_6, t0.description AS description_7, t0.history AS history_8, t0.nb_rounds_max AS nb_rounds_max_9, t0.draw_accepted AS draw_accepted_10, t0.topcut_phase AS topcut_phase_11, t0.slug AS slug_12, t0.slug_en AS slug_en_13, t0.creation_date AS creation_date_14, t0.update_date AS update_date_15, t0.finished AS finished_16, t0.winner_id AS winner_id_17, t0.creator_id AS creator_id_18, t0.current_round_id AS current_round_id_19, t0.previous_round_id AS previous_round_id_20, t0.category_id AS category_id_21, t0.rule_id AS rule_id_22, t0.topcut_rule_id AS topcut_rule_id_23, t0.website_id AS website_id_24 FROM tournament t0 WHERE t0.slug = '7dcdc1e9ad49575230a2637c83db2826ae032c41' AND t0.website_id = 1 LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.email AS email_2,
  t0.pseudo AS pseudo_3,
  t0.play_id AS play_id_4,
  t0.roles AS roles_5,
  t0.password AS password_6,
  t0.reset_password_link AS reset_password_link_7,
  t0.last_login_date AS last_login_date_8,
  t0.facebook_id AS facebook_id_9,
  t0.facebook_access_token AS facebook_access_token_10,
  t0.google_id AS google_id_11,
  t0.discord_id AS discord_id_12,
  t0.seller_name AS seller_name_13,
  t0.achievements_points AS achievements_points_14,
  t0.nb_logins AS nb_logins_15,
  t0.nb_logins_in_arow AS nb_logins_in_arow_16,
  t0.max_logins_in_arow AS max_logins_in_arow_17,
  t0.capsule_count AS capsule_count_18,
  t0.api_id AS api_id_19,
  t0.credits AS credits_20,
  t0.cardnexus_mail AS cardnexus_mail_21,
  t0.creation_date AS creation_date_22,
  t0.update_date AS update_date_23,
  t0.avatar_id AS avatar_id_24,
  t0.data_player_id AS data_player_id_25,
  t0.country_id AS country_id_26,
  t0.department_id AS department_id_27,
  t0.website_id AS website_id_28,
  t0.category,
  t0.youtube_channel AS youtube_channel_29
FROM
  user t0
WHERE
  t0.id = ?
  AND t0.category IN ('USER', 'VIDEOGRAPHER')

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 = 3076 AND t0.category IN ('USER', 'VIDEOGRAPHER');

SELECT
  t0.id AS id_1,
  t0.uniqid AS uniqid_2,
  t0.name AS name_3,
  t0.private AS private_4,
  t0.invalid AS invalid_5,
  t0.starter AS starter_6,
  t0.dev_team AS dev_team_7,
  t0.meta AS meta_8,
  t0.total_price AS total_price_9,
  t0.untap_click_count AS untap_click_count_10,
  t0.creation_date AS creation_date_11,
  t0.update_date AS update_date_12,
  t0.view_count AS view_count_13,
  t0.like_count AS like_count_14,
  t0.deleted AS deleted_15,
  t0.leader_id AS leader_id_16,
  t17.id AS id_18,
  t17.number AS number_19,
  t17.serial_number AS serial_number_20,
  t17.front_name AS front_name_21,
  t17.front_description AS front_description_22,
  t17.front_energy_cost AS front_energy_cost_23,
  t17.secondary_cost AS secondary_cost_24,
  t17.front_energy_cost_alias AS front_energy_cost_alias_25,
  t17.front_energy_color_cost AS front_energy_color_cost_26,
  t17.back_energy_color_cost AS back_energy_color_cost_27,
  t17.front_combo_cost AS front_combo_cost_28,
  t17.front_combo_power AS front_combo_power_29,
  t17.front_power AS front_power_30,
  t17.front_defense AS front_defense_31,
  t17.back_name AS back_name_32,
  t17.back_description AS back_description_33,
  t17.back_power AS back_power_34,
  t17.back_power2 AS back_power2_35,
  t17.back_defense AS back_defense_36,
  t17.back_defense2 AS back_defense2_37,
  t17.img_ready AS img_ready_38,
  t17.image_ready AS image_ready_39,
  t17.multicolor AS multicolor_40,
  t17.limited AS limited_41,
  t17.banned AS banned_42,
  t17.unlimited_in_deck AS unlimited_in_deck_43,
  t17.limitation_in_deck AS limitation_in_deck_44,
  t17.reprint AS reprint_45,
  t17.foil AS foil_46,
  t17.reprint_category AS reprint_category_47,
  t17.animated AS animated_48,
  t17.version_number AS version_number_49,
  t17.front_name_alias AS front_name_alias_50,
  t17.front_name_en AS front_name_en_51,
  t17.back_name_en AS back_name_en_52,
  t17.front_description_en AS front_description_en_53,
  t17.back_description_en AS back_description_en_54,
  t17.english_only AS english_only_55,
  t17.redirect_english_slug AS redirect_english_slug_56,
  t17.position_serie_list AS position_serie_list_57,
  t17.lore AS lore_58,
  t17.subname AS subname_59,
  t17.illustrator AS illustrator_60,
  t17.energyzable AS energyzable_61,
  t17.weakness AS weakness_62,
  t17.resistance AS resistance_63,
  t17.sub_description AS sub_description_64,
  t17.exclusive AS exclusive_65,
  t17.end_of_serie AS end_of_serie_66,
  t17.verso AS verso_67,
  t17.additional_data AS additional_data_68,
  t17.ocr_keywords_count AS ocr_keywords_count_69,
  t17.beta AS beta_70,
  t17.level AS level_71,
  t17.price_alert AS price_alert_72,
  t17.creation_date AS creation_date_73,
  t17.update_date AS update_date_74,
  t17.displayed AS displayed_75,
  t17.slug AS slug_76,
  t17.slug_en AS slug_en_77,
  t17.view_count AS view_count_78,
  t17.cmid AS cmid_79,
  t17.url AS url_80,
  t17.image AS image_81,
  t17.current_price AS current_price_82,
  t17.yesterday_price AS yesterday_price_83,
  t17.last_price_update AS last_price_update_84,
  t17.cardnexus_id AS cardnexus_id_85,
  t17.cardnexus_current_price AS cardnexus_current_price_86,
  t17.cardnexus_yesterday_price AS cardnexus_yesterday_price_87,
  t17.cardnexus_last_price_update AS cardnexus_last_price_update_88,
  t17.lang AS lang_89,
  t17.release_date AS release_date_90,
  t17.complete AS complete_91,
  t17.bandai_tcgid AS bandai_tcgid_92,
  t17.checked AS checked_93,
  t17.indexable AS indexable_94,
  t17.front_era_id AS front_era_id_95,
  t17.back_era_id AS back_era_id_96,
  t17.type_id AS type_id_97,
  t17.serie_id AS serie_id_98,
  t17.rarity_id AS rarity_id_99,
  t17.group_version_id AS group_version_id_100,
  t17.avatar_id AS avatar_id_101,
  t17.version_id AS version_id_102,
  t17.auto_play_id AS auto_play_id_103,
  t17.version_annotation_id AS version_annotation_id_104,
  t17.website_id AS website_id_105,
  t0.creator_id AS creator_id_106,
  t0.event_id AS event_id_107,
  t0.website_id AS website_id_108
FROM
  deck t0
  INNER JOIN card t17 ON t0.leader_id = t17.id
WHERE
  t0.creator_id IS NULL
  AND t0.invalid = ?
  AND t0.website_id = ?

SELECT t0.id AS id_1, t0.uniqid AS uniqid_2, t0.name AS name_3, t0.private AS private_4, t0.invalid AS invalid_5, t0.starter AS starter_6, t0.dev_team AS dev_team_7, t0.meta AS meta_8, t0.total_price AS total_price_9, t0.untap_click_count AS untap_click_count_10, t0.creation_date AS creation_date_11, t0.update_date AS update_date_12, t0.view_count AS view_count_13, t0.like_count AS like_count_14, t0.deleted AS deleted_15, t0.leader_id AS leader_id_16, t17.id AS id_18, t17.number AS number_19, t17.serial_number AS serial_number_20, t17.front_name AS front_name_21, t17.front_description AS front_description_22, t17.front_energy_cost AS front_energy_cost_23, t17.secondary_cost AS secondary_cost_24, t17.front_energy_cost_alias AS front_energy_cost_alias_25, t17.front_energy_color_cost AS front_energy_color_cost_26, t17.back_energy_color_cost AS back_energy_color_cost_27, t17.front_combo_cost AS front_combo_cost_28, t17.front_combo_power AS front_combo_power_29, t17.front_power AS front_power_30, t17.front_defense AS front_defense_31, t17.back_name AS back_name_32, t17.back_description AS back_description_33, t17.back_power AS back_power_34, t17.back_power2 AS back_power2_35, t17.back_defense AS back_defense_36, t17.back_defense2 AS back_defense2_37, t17.img_ready AS img_ready_38, t17.image_ready AS image_ready_39, t17.multicolor AS multicolor_40, t17.limited AS limited_41, t17.banned AS banned_42, t17.unlimited_in_deck AS unlimited_in_deck_43, t17.limitation_in_deck AS limitation_in_deck_44, t17.reprint AS reprint_45, t17.foil AS foil_46, t17.reprint_category AS reprint_category_47, t17.animated AS animated_48, t17.version_number AS version_number_49, t17.front_name_alias AS front_name_alias_50, t17.front_name_en AS front_name_en_51, t17.back_name_en AS back_name_en_52, t17.front_description_en AS front_description_en_53, t17.back_description_en AS back_description_en_54, t17.english_only AS english_only_55, t17.redirect_english_slug AS redirect_english_slug_56, t17.position_serie_list AS position_serie_list_57, t17.lore AS lore_58, t17.subname AS subname_59, t17.illustrator AS illustrator_60, t17.energyzable AS energyzable_61, t17.weakness AS weakness_62, t17.resistance AS resistance_63, t17.sub_description AS sub_description_64, t17.exclusive AS exclusive_65, t17.end_of_serie AS end_of_serie_66, t17.verso AS verso_67, t17.additional_data AS additional_data_68, t17.ocr_keywords_count AS ocr_keywords_count_69, t17.beta AS beta_70, t17.level AS level_71, t17.price_alert AS price_alert_72, t17.creation_date AS creation_date_73, t17.update_date AS update_date_74, t17.displayed AS displayed_75, t17.slug AS slug_76, t17.slug_en AS slug_en_77, t17.view_count AS view_count_78, t17.cmid AS cmid_79, t17.url AS url_80, t17.image AS image_81, t17.current_price AS current_price_82, t17.yesterday_price AS yesterday_price_83, t17.last_price_update AS last_price_update_84, t17.cardnexus_id AS cardnexus_id_85, t17.cardnexus_current_price AS cardnexus_current_price_86, t17.cardnexus_yesterday_price AS cardnexus_yesterday_price_87, t17.cardnexus_last_price_update AS cardnexus_last_price_update_88, t17.lang AS lang_89, t17.release_date AS release_date_90, t17.complete AS complete_91, t17.bandai_tcgid AS bandai_tcgid_92, t17.checked AS checked_93, t17.indexable AS indexable_94, t17.front_era_id AS front_era_id_95, t17.back_era_id AS back_era_id_96, t17.type_id AS type_id_97, t17.serie_id AS serie_id_98, t17.rarity_id AS rarity_id_99, t17.group_version_id AS group_version_id_100, t17.avatar_id AS avatar_id_101, t17.version_id AS version_id_102, t17.auto_play_id AS auto_play_id_103, t17.version_annotation_id AS version_annotation_id_104, t17.website_id AS website_id_105, t0.creator_id AS creator_id_106, t0.event_id AS event_id_107, t0.website_id AS website_id_108 FROM deck t0 INNER JOIN card t17 ON t0.leader_id = t17.id WHERE t0.creator_id IS NULL AND t0.invalid = 0 AND t0.website_id = 1;

SELECT
  t0.id AS id_1,
  t0.email AS email_2,
  t0.pseudo AS pseudo_3,
  t0.play_id AS play_id_4,
  t0.roles AS roles_5,
  t0.password AS password_6,
  t0.reset_password_link AS reset_password_link_7,
  t0.last_login_date AS last_login_date_8,
  t0.facebook_id AS facebook_id_9,
  t0.facebook_access_token AS facebook_access_token_10,
  t0.google_id AS google_id_11,
  t0.discord_id AS discord_id_12,
  t0.seller_name AS seller_name_13,
  t0.achievements_points AS achievements_points_14,
  t0.nb_logins AS nb_logins_15,
  t0.nb_logins_in_arow AS nb_logins_in_arow_16,
  t0.max_logins_in_arow AS max_logins_in_arow_17,
  t0.capsule_count AS capsule_count_18,
  t0.api_id AS api_id_19,
  t0.credits AS credits_20,
  t0.cardnexus_mail AS cardnexus_mail_21,
  t0.creation_date AS creation_date_22,
  t0.update_date AS update_date_23,
  t0.avatar_id AS avatar_id_24,
  t0.data_player_id AS data_player_id_25,
  t0.country_id AS country_id_26,
  t0.department_id AS department_id_27,
  t0.website_id AS website_id_28,
  t0.category,
  t0.youtube_channel AS youtube_channel_29
FROM
  user t0
  INNER JOIN tournament_user ON t0.id = tournament_user.user_id
WHERE
  tournament_user.tournament_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 INNER JOIN tournament_user ON t0.id = tournament_user.user_id WHERE tournament_user.tournament_id = 28 AND t0.category IN ('USER', 'VIDEOGRAPHER');

SELECT
  t0.id AS id_1,
  t0.reference AS reference_2,
  t0.name AS name_3,
  t0.description AS description_4,
  t0.topcut AS topcut_5,
  t0.draw_accepted AS draw_accepted_6
FROM
  tournament_category t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.reference AS reference_2, t0.name AS name_3, t0.description AS description_4, t0.topcut AS topcut_5, t0.draw_accepted AS draw_accepted_6 FROM tournament_category t0 WHERE t0.id = 1;

SELECT
  t0.id AS id_1,
  t0.reference AS reference_2,
  t0.name AS name_3,
  t0.nb_max_games AS nb_max_games_4
FROM
  tournament_game_rule t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.reference AS reference_2, t0.name AS name_3, t0.nb_max_games AS nb_max_games_4 FROM tournament_game_rule t0 WHERE t0.id = 1;

SELECT
  t0_.rank AS rank_0,
  t0_.matches AS matches_1,
  t0_.wins AS wins_2,
  t0_.loses AS loses_3,
  t0_.draws AS draws_4,
  t0_.points AS points_5,
  t0_.real_points AS real_points_6,
  t0_.opp_sum_points AS opp_sum_points_7,
  t0_.opp_opp_sum_points AS opp_opp_sum_points_8,
  t0_.pct_wins AS pct_wins_9,
  t0_.bye_round AS bye_round_10,
  t0_.forfait AS forfait_11,
  t0_.qualified AS qualified_12,
  t0_.eliminated AS eliminated_13,
  t0_.elimination_round AS elimination_round_14,
  t0_.tournament_id AS tournament_id_15,
  t0_.player_id AS player_id_16,
  t0_.deck_id AS deck_id_17
FROM
  tournament_ranking t0_
  INNER JOIN user u1_ ON t0_.player_id = u1_.id
  AND u1_.category IN ('USER', 'VIDEOGRAPHER')
  LEFT JOIN league_stats l2_ ON u1_.id = l2_.user_id
WHERE
  l2_.website_id = ?
  AND t0_.tournament_id = ?
ORDER BY
  t0_.rank ASC,
  t0_.qualified DESC,
  t0_.eliminated ASC,
  t0_.elimination_round DESC,
  t0_.forfait ASC,
  t0_.points DESC,
  t0_.real_points DESC,
  t0_.opp_sum_points DESC,
  t0_.opp_opp_sum_points DESC,
  l2_.elo DESC

SELECT t0_.rank AS rank_0, t0_.matches AS matches_1, t0_.wins AS wins_2, t0_.loses AS loses_3, t0_.draws AS draws_4, t0_.points AS points_5, t0_.real_points AS real_points_6, t0_.opp_sum_points AS opp_sum_points_7, t0_.opp_opp_sum_points AS opp_opp_sum_points_8, t0_.pct_wins AS pct_wins_9, t0_.bye_round AS bye_round_10, t0_.forfait AS forfait_11, t0_.qualified AS qualified_12, t0_.eliminated AS eliminated_13, t0_.elimination_round AS elimination_round_14, t0_.tournament_id AS tournament_id_15, t0_.player_id AS player_id_16, t0_.deck_id AS deck_id_17 FROM tournament_ranking t0_ INNER JOIN user u1_ ON t0_.player_id = u1_.id AND u1_.category IN ('USER', 'VIDEOGRAPHER') LEFT JOIN league_stats l2_ ON u1_.id = l2_.user_id WHERE l2_.website_id = 1 AND t0_.tournament_id = 28 ORDER BY t0_.rank ASC, t0_.qualified DESC, t0_.eliminated ASC, t0_.elimination_round DESC, t0_.forfait ASC, t0_.points DESC, t0_.real_points DESC, t0_.opp_sum_points DESC, t0_.opp_opp_sum_points DESC, l2_.elo DESC;

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;

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;

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;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.private AS private_3,
  t0.started AS started_4,
  t0.start_date AS start_date_5,
  t0.nb_players_max AS nb_players_max_6,
  t0.description AS description_7,
  t0.history AS history_8,
  t0.nb_rounds_max AS nb_rounds_max_9,
  t0.draw_accepted AS draw_accepted_10,
  t0.topcut_phase AS topcut_phase_11,
  t0.slug AS slug_12,
  t0.slug_en AS slug_en_13,
  t0.creation_date AS creation_date_14,
  t0.update_date AS update_date_15,
  t0.finished AS finished_16,
  t0.winner_id AS winner_id_17,
  t0.creator_id AS creator_id_18,
  t0.current_round_id AS current_round_id_19,
  t0.previous_round_id AS previous_round_id_20,
  t0.category_id AS category_id_21,
  t0.rule_id AS rule_id_22,
  t0.topcut_rule_id AS topcut_rule_id_23,
  t0.website_id AS website_id_24
FROM
  tournament t0
WHERE
  t0.slug = ?
  AND t0.website_id = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.private AS private_3, t0.started AS started_4, t0.start_date AS start_date_5, t0.nb_players_max AS nb_players_max_6, t0.description AS description_7, t0.history AS history_8, t0.nb_rounds_max AS nb_rounds_max_9, t0.draw_accepted AS draw_accepted_10, t0.topcut_phase AS topcut_phase_11, t0.slug AS slug_12, t0.slug_en AS slug_en_13, t0.creation_date AS creation_date_14, t0.update_date AS update_date_15, t0.finished AS finished_16, t0.winner_id AS winner_id_17, t0.creator_id AS creator_id_18, t0.current_round_id AS current_round_id_19, t0.previous_round_id AS previous_round_id_20, t0.category_id AS category_id_21, t0.rule_id AS rule_id_22, t0.topcut_rule_id AS topcut_rule_id_23, t0.website_id AS website_id_24 FROM tournament t0 WHERE t0.slug = '7dcdc1e9ad49575230a2637c83db2826ae032c41' AND t0.website_id = 1 LIMIT 1;