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.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;

SELECT
  r0_.id AS id_0,
  r0_.reference AS reference_1,
  r0_.name AS name_2,
  r0_.name_en AS name_en_3,
  r0_.sort_order AS sort_order_4,
  r0_.special AS special_5,
  r0_.displayed AS displayed_6,
  r0_.website_id AS website_id_7
FROM
  rarity r0_
WHERE
  r0_.displayed = 1
  AND r0_.website_id = ?
ORDER BY
  r0_.sort_order ASC,
  r0_.reference ASC

SELECT r0_.id AS id_0, r0_.reference AS reference_1, r0_.name AS name_2, r0_.name_en AS name_en_3, r0_.sort_order AS sort_order_4, r0_.special AS special_5, r0_.displayed AS displayed_6, r0_.website_id AS website_id_7 FROM rarity r0_ WHERE r0_.displayed = 1 AND r0_.website_id = 1 ORDER BY r0_.sort_order ASC, r0_.reference 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 = ?
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;

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
WHERE
  t0.id = ?

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 WHERE t0.id = 1;

SELECT
  s0_.id AS id_0,
  s0_.reference AS reference_1,
  s0_.name AS name_2,
  s0_.name_en AS name_en_3,
  s0_.description AS description_4,
  s0_.total_price AS total_price_5,
  s0_.list_ready AS list_ready_6,
  s0_.timeline_excluded AS timeline_excluded_7,
  s0_.creation_date AS creation_date_8,
  s0_.update_date AS update_date_9,
  s0_.displayed AS displayed_10,
  s0_.slug AS slug_11,
  s0_.slug_en AS slug_en_12,
  s0_.lang AS lang_13,
  s0_.release_date AS release_date_14,
  s0_.cmid AS cmid_15,
  s0_.url AS url_16,
  s0_.image AS image_17,
  s0_.current_price AS current_price_18,
  s0_.yesterday_price AS yesterday_price_19,
  s0_.last_price_update AS last_price_update_20,
  s0_.cardnexus_id AS cardnexus_id_21,
  s0_.cardnexus_current_price AS cardnexus_current_price_22,
  s0_.cardnexus_yesterday_price AS cardnexus_yesterday_price_23,
  s0_.cardnexus_last_price_update AS cardnexus_last_price_update_24,
  s0_.type_id AS type_id_25,
  s0_.website_id AS website_id_26
FROM
  serie s0_
WHERE
  s0_.displayed = 1
  AND s0_.website_id = ?
ORDER BY
  s0_.lang DESC,
  s0_.release_date DESC

SELECT s0_.id AS id_0, s0_.reference AS reference_1, s0_.name AS name_2, s0_.name_en AS name_en_3, s0_.description AS description_4, s0_.total_price AS total_price_5, s0_.list_ready AS list_ready_6, s0_.timeline_excluded AS timeline_excluded_7, s0_.creation_date AS creation_date_8, s0_.update_date AS update_date_9, s0_.displayed AS displayed_10, s0_.slug AS slug_11, s0_.slug_en AS slug_en_12, s0_.lang AS lang_13, s0_.release_date AS release_date_14, s0_.cmid AS cmid_15, s0_.url AS url_16, s0_.image AS image_17, s0_.current_price AS current_price_18, s0_.yesterday_price AS yesterday_price_19, s0_.last_price_update AS last_price_update_20, s0_.cardnexus_id AS cardnexus_id_21, s0_.cardnexus_current_price AS cardnexus_current_price_22, s0_.cardnexus_yesterday_price AS cardnexus_yesterday_price_23, s0_.cardnexus_last_price_update AS cardnexus_last_price_update_24, s0_.type_id AS type_id_25, s0_.website_id AS website_id_26 FROM serie s0_ WHERE s0_.displayed = 1 AND s0_.website_id = 1 ORDER BY s0_.lang DESC, s0_.release_date DESC;

SELECT
  l0_.id AS id_0,
  l0_.reference AS reference_1,
  l0_.name AS name_2,
  l0_.sort_order AS sort_order_3
FROM
  language l0_
WHERE
  EXISTS (
    SELECT
      1
    FROM
      web_site_language w1_
    WHERE
      w1_.language_id = l0_.id
      AND w1_.web_site_id IN (?)
  )
ORDER BY
  l0_.sort_order ASC

SELECT l0_.id AS id_0, l0_.reference AS reference_1, l0_.name AS name_2, l0_.sort_order AS sort_order_3 FROM language l0_ WHERE EXISTS (SELECT 1 FROM web_site_language w1_ WHERE w1_.language_id = l0_.id AND w1_.web_site_id IN (1)) ORDER BY l0_.sort_order ASC;

SELECT
  count(DISTINCT c0_.id) AS sclr_0
FROM
  card_graded c0_
  INNER JOIN card c1_ ON c0_.card_id = c1_.id
  INNER JOIN serie s2_ ON c1_.serie_id = s2_.id
  INNER JOIN rarity r3_ ON c1_.rarity_id = r3_.id
WHERE
  c1_.displayed = 1
  AND c0_.link IS NOT NULL
  AND s2_.displayed = 1
  AND s2_.release_date IS NOT NULL
  AND c1_.website_id = ?
  AND c1_.lang = ?

SELECT count(DISTINCT c0_.id) AS sclr_0 FROM card_graded c0_ INNER JOIN card c1_ ON c0_.card_id = c1_.id INNER JOIN serie s2_ ON c1_.serie_id = s2_.id INNER JOIN rarity r3_ ON c1_.rarity_id = r3_.id WHERE c1_.displayed = 1 AND c0_.link IS NOT NULL AND s2_.displayed = 1 AND s2_.release_date IS NOT NULL AND c1_.website_id = 1 AND c1_.lang = 'FR';

SELECT
  DISTINCT c0_.id AS id_0,
  c1_.release_date AS release_date_1,
  s2_.reference AS reference_2,
  c1_.number AS number_3,
  r3_.sort_order AS sort_order_4,
  c1_.serial_number AS serial_number_5,
  c1_.reprint_category AS reprint_category_6
FROM
  card_graded c0_
  INNER JOIN card c1_ ON c0_.card_id = c1_.id
  INNER JOIN serie s2_ ON c1_.serie_id = s2_.id
  INNER JOIN rarity r3_ ON c1_.rarity_id = r3_.id
WHERE
  c1_.displayed = 1
  AND c0_.link IS NOT NULL
  AND s2_.displayed = 1
  AND s2_.release_date IS NOT NULL
  AND c1_.website_id = ?
  AND c1_.lang = ?
ORDER BY
  c1_.release_date DESC,
  s2_.reference DESC,
  c1_.number ASC,
  r3_.sort_order ASC,
  c1_.serial_number ASC,
  c1_.reprint_category ASC
LIMIT
  30

SELECT DISTINCT c0_.id AS id_0, c1_.release_date AS release_date_1, s2_.reference AS reference_2, c1_.number AS number_3, r3_.sort_order AS sort_order_4, c1_.serial_number AS serial_number_5, c1_.reprint_category AS reprint_category_6 FROM card_graded c0_ INNER JOIN card c1_ ON c0_.card_id = c1_.id INNER JOIN serie s2_ ON c1_.serie_id = s2_.id INNER JOIN rarity r3_ ON c1_.rarity_id = r3_.id WHERE c1_.displayed = 1 AND c0_.link IS NOT NULL AND s2_.displayed = 1 AND s2_.release_date IS NOT NULL AND c1_.website_id = 1 AND c1_.lang = 'FR' ORDER BY c1_.release_date DESC, s2_.reference DESC, c1_.number ASC, r3_.sort_order ASC, c1_.serial_number ASC, c1_.reprint_category ASC LIMIT 30;

SELECT
  c0_.id AS id_0,
  c0_.price AS price_1,
  c0_.promo_price AS promo_price_2,
  c0_.available AS available_3,
  c0_.current_price AS current_price_4,
  c0_.yesterday_price AS yesterday_price_5,
  c0_.last_price_update AS last_price_update_6,
  c0_.grading_company AS grading_company_7,
  c0_.note AS note_8,
  c0_.centering AS centering_9,
  c0_.corners AS corners_10,
  c0_.edges AS edges_11,
  c0_.surface AS surface_12,
  c0_.background AS background_13,
  c0_.creation_date AS creation_date_14,
  c0_.update_date AS update_date_15,
  c0_.link AS link_16,
  c0_.displayed AS displayed_17,
  c1_.id AS id_18,
  c1_.number AS number_19,
  c1_.serial_number AS serial_number_20,
  c1_.front_name AS front_name_21,
  c1_.front_description AS front_description_22,
  c1_.front_energy_cost AS front_energy_cost_23,
  c1_.secondary_cost AS secondary_cost_24,
  c1_.front_energy_cost_alias AS front_energy_cost_alias_25,
  c1_.front_energy_color_cost AS front_energy_color_cost_26,
  c1_.back_energy_color_cost AS back_energy_color_cost_27,
  c1_.front_combo_cost AS front_combo_cost_28,
  c1_.front_combo_power AS front_combo_power_29,
  c1_.front_power AS front_power_30,
  c1_.front_defense AS front_defense_31,
  c1_.back_name AS back_name_32,
  c1_.back_description AS back_description_33,
  c1_.back_power AS back_power_34,
  c1_.back_power2 AS back_power2_35,
  c1_.back_defense AS back_defense_36,
  c1_.back_defense2 AS back_defense2_37,
  c1_.img_ready AS img_ready_38,
  c1_.image_ready AS image_ready_39,
  c1_.multicolor AS multicolor_40,
  c1_.limited AS limited_41,
  c1_.banned AS banned_42,
  c1_.unlimited_in_deck AS unlimited_in_deck_43,
  c1_.limitation_in_deck AS limitation_in_deck_44,
  c1_.reprint AS reprint_45,
  c1_.foil AS foil_46,
  c1_.reprint_category AS reprint_category_47,
  c1_.animated AS animated_48,
  c1_.version_number AS version_number_49,
  c1_.front_name_alias AS front_name_alias_50,
  c1_.front_name_en AS front_name_en_51,
  c1_.back_name_en AS back_name_en_52,
  c1_.front_description_en AS front_description_en_53,
  c1_.back_description_en AS back_description_en_54,
  c1_.english_only AS english_only_55,
  c1_.redirect_english_slug AS redirect_english_slug_56,
  c1_.position_serie_list AS position_serie_list_57,
  c1_.lore AS lore_58,
  c1_.subname AS subname_59,
  c1_.illustrator AS illustrator_60,
  c1_.energyzable AS energyzable_61,
  c1_.weakness AS weakness_62,
  c1_.resistance AS resistance_63,
  c1_.sub_description AS sub_description_64,
  c1_.exclusive AS exclusive_65,
  c1_.end_of_serie AS end_of_serie_66,
  c1_.verso AS verso_67,
  c1_.additional_data AS additional_data_68,
  c1_.ocr_keywords_count AS ocr_keywords_count_69,
  c1_.beta AS beta_70,
  c1_.level AS level_71,
  c1_.price_alert AS price_alert_72,
  c1_.creation_date AS creation_date_73,
  c1_.update_date AS update_date_74,
  c1_.displayed AS displayed_75,
  c1_.slug AS slug_76,
  c1_.slug_en AS slug_en_77,
  c1_.view_count AS view_count_78,
  c1_.cmid AS cmid_79,
  c1_.url AS url_80,
  c1_.image AS image_81,
  c1_.current_price AS current_price_82,
  c1_.yesterday_price AS yesterday_price_83,
  c1_.last_price_update AS last_price_update_84,
  c1_.cardnexus_id AS cardnexus_id_85,
  c1_.cardnexus_current_price AS cardnexus_current_price_86,
  c1_.cardnexus_yesterday_price AS cardnexus_yesterday_price_87,
  c1_.cardnexus_last_price_update AS cardnexus_last_price_update_88,
  c1_.lang AS lang_89,
  c1_.release_date AS release_date_90,
  c1_.complete AS complete_91,
  c1_.bandai_tcgid AS bandai_tcgid_92,
  c1_.checked AS checked_93,
  c1_.indexable AS indexable_94,
  s2_.id AS id_95,
  s2_.reference AS reference_96,
  s2_.name AS name_97,
  s2_.name_en AS name_en_98,
  s2_.description AS description_99,
  s2_.total_price AS total_price_100,
  s2_.list_ready AS list_ready_101,
  s2_.timeline_excluded AS timeline_excluded_102,
  s2_.creation_date AS creation_date_103,
  s2_.update_date AS update_date_104,
  s2_.displayed AS displayed_105,
  s2_.slug AS slug_106,
  s2_.slug_en AS slug_en_107,
  s2_.lang AS lang_108,
  s2_.release_date AS release_date_109,
  s2_.cmid AS cmid_110,
  s2_.url AS url_111,
  s2_.image AS image_112,
  s2_.current_price AS current_price_113,
  s2_.yesterday_price AS yesterday_price_114,
  s2_.last_price_update AS last_price_update_115,
  s2_.cardnexus_id AS cardnexus_id_116,
  s2_.cardnexus_current_price AS cardnexus_current_price_117,
  s2_.cardnexus_yesterday_price AS cardnexus_yesterday_price_118,
  s2_.cardnexus_last_price_update AS cardnexus_last_price_update_119,
  r3_.id AS id_120,
  r3_.reference AS reference_121,
  r3_.name AS name_122,
  r3_.name_en AS name_en_123,
  r3_.sort_order AS sort_order_124,
  r3_.special AS special_125,
  r3_.displayed AS displayed_126,
  c0_.card_id AS card_id_127,
  c1_.front_era_id AS front_era_id_128,
  c1_.back_era_id AS back_era_id_129,
  c1_.type_id AS type_id_130,
  c1_.serie_id AS serie_id_131,
  c1_.rarity_id AS rarity_id_132,
  c1_.group_version_id AS group_version_id_133,
  c1_.avatar_id AS avatar_id_134,
  c1_.version_id AS version_id_135,
  c1_.auto_play_id AS auto_play_id_136,
  c1_.version_annotation_id AS version_annotation_id_137,
  c1_.website_id AS website_id_138,
  s2_.type_id AS type_id_139,
  s2_.website_id AS website_id_140,
  r3_.website_id AS website_id_141
FROM
  card_graded c0_
  INNER JOIN card c1_ ON c0_.card_id = c1_.id
  INNER JOIN serie s2_ ON c1_.serie_id = s2_.id
  INNER JOIN rarity r3_ ON c1_.rarity_id = r3_.id
WHERE
  c1_.displayed = 1
  AND c0_.link IS NOT NULL
  AND s2_.displayed = 1
  AND s2_.release_date IS NOT NULL
  AND c1_.website_id = ?
  AND c1_.lang = ?
  AND c0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?)
ORDER BY
  c1_.release_date DESC,
  s2_.reference DESC,
  c1_.number ASC,
  r3_.sort_order ASC,
  c1_.serial_number ASC,
  c1_.reprint_category ASC

SELECT c0_.id AS id_0, c0_.price AS price_1, c0_.promo_price AS promo_price_2, c0_.available AS available_3, c0_.current_price AS current_price_4, c0_.yesterday_price AS yesterday_price_5, c0_.last_price_update AS last_price_update_6, c0_.grading_company AS grading_company_7, c0_.note AS note_8, c0_.centering AS centering_9, c0_.corners AS corners_10, c0_.edges AS edges_11, c0_.surface AS surface_12, c0_.background AS background_13, c0_.creation_date AS creation_date_14, c0_.update_date AS update_date_15, c0_.link AS link_16, c0_.displayed AS displayed_17, c1_.id AS id_18, c1_.number AS number_19, c1_.serial_number AS serial_number_20, c1_.front_name AS front_name_21, c1_.front_description AS front_description_22, c1_.front_energy_cost AS front_energy_cost_23, c1_.secondary_cost AS secondary_cost_24, c1_.front_energy_cost_alias AS front_energy_cost_alias_25, c1_.front_energy_color_cost AS front_energy_color_cost_26, c1_.back_energy_color_cost AS back_energy_color_cost_27, c1_.front_combo_cost AS front_combo_cost_28, c1_.front_combo_power AS front_combo_power_29, c1_.front_power AS front_power_30, c1_.front_defense AS front_defense_31, c1_.back_name AS back_name_32, c1_.back_description AS back_description_33, c1_.back_power AS back_power_34, c1_.back_power2 AS back_power2_35, c1_.back_defense AS back_defense_36, c1_.back_defense2 AS back_defense2_37, c1_.img_ready AS img_ready_38, c1_.image_ready AS image_ready_39, c1_.multicolor AS multicolor_40, c1_.limited AS limited_41, c1_.banned AS banned_42, c1_.unlimited_in_deck AS unlimited_in_deck_43, c1_.limitation_in_deck AS limitation_in_deck_44, c1_.reprint AS reprint_45, c1_.foil AS foil_46, c1_.reprint_category AS reprint_category_47, c1_.animated AS animated_48, c1_.version_number AS version_number_49, c1_.front_name_alias AS front_name_alias_50, c1_.front_name_en AS front_name_en_51, c1_.back_name_en AS back_name_en_52, c1_.front_description_en AS front_description_en_53, c1_.back_description_en AS back_description_en_54, c1_.english_only AS english_only_55, c1_.redirect_english_slug AS redirect_english_slug_56, c1_.position_serie_list AS position_serie_list_57, c1_.lore AS lore_58, c1_.subname AS subname_59, c1_.illustrator AS illustrator_60, c1_.energyzable AS energyzable_61, c1_.weakness AS weakness_62, c1_.resistance AS resistance_63, c1_.sub_description AS sub_description_64, c1_.exclusive AS exclusive_65, c1_.end_of_serie AS end_of_serie_66, c1_.verso AS verso_67, c1_.additional_data AS additional_data_68, c1_.ocr_keywords_count AS ocr_keywords_count_69, c1_.beta AS beta_70, c1_.level AS level_71, c1_.price_alert AS price_alert_72, c1_.creation_date AS creation_date_73, c1_.update_date AS update_date_74, c1_.displayed AS displayed_75, c1_.slug AS slug_76, c1_.slug_en AS slug_en_77, c1_.view_count AS view_count_78, c1_.cmid AS cmid_79, c1_.url AS url_80, c1_.image AS image_81, c1_.current_price AS current_price_82, c1_.yesterday_price AS yesterday_price_83, c1_.last_price_update AS last_price_update_84, c1_.cardnexus_id AS cardnexus_id_85, c1_.cardnexus_current_price AS cardnexus_current_price_86, c1_.cardnexus_yesterday_price AS cardnexus_yesterday_price_87, c1_.cardnexus_last_price_update AS cardnexus_last_price_update_88, c1_.lang AS lang_89, c1_.release_date AS release_date_90, c1_.complete AS complete_91, c1_.bandai_tcgid AS bandai_tcgid_92, c1_.checked AS checked_93, c1_.indexable AS indexable_94, s2_.id AS id_95, s2_.reference AS reference_96, s2_.name AS name_97, s2_.name_en AS name_en_98, s2_.description AS description_99, s2_.total_price AS total_price_100, s2_.list_ready AS list_ready_101, s2_.timeline_excluded AS timeline_excluded_102, s2_.creation_date AS creation_date_103, s2_.update_date AS update_date_104, s2_.displayed AS displayed_105, s2_.slug AS slug_106, s2_.slug_en AS slug_en_107, s2_.lang AS lang_108, s2_.release_date AS release_date_109, s2_.cmid AS cmid_110, s2_.url AS url_111, s2_.image AS image_112, s2_.current_price AS current_price_113, s2_.yesterday_price AS yesterday_price_114, s2_.last_price_update AS last_price_update_115, s2_.cardnexus_id AS cardnexus_id_116, s2_.cardnexus_current_price AS cardnexus_current_price_117, s2_.cardnexus_yesterday_price AS cardnexus_yesterday_price_118, s2_.cardnexus_last_price_update AS cardnexus_last_price_update_119, r3_.id AS id_120, r3_.reference AS reference_121, r3_.name AS name_122, r3_.name_en AS name_en_123, r3_.sort_order AS sort_order_124, r3_.special AS special_125, r3_.displayed AS displayed_126, c0_.card_id AS card_id_127, c1_.front_era_id AS front_era_id_128, c1_.back_era_id AS back_era_id_129, c1_.type_id AS type_id_130, c1_.serie_id AS serie_id_131, c1_.rarity_id AS rarity_id_132, c1_.group_version_id AS group_version_id_133, c1_.avatar_id AS avatar_id_134, c1_.version_id AS version_id_135, c1_.auto_play_id AS auto_play_id_136, c1_.version_annotation_id AS version_annotation_id_137, c1_.website_id AS website_id_138, s2_.type_id AS type_id_139, s2_.website_id AS website_id_140, r3_.website_id AS website_id_141 FROM card_graded c0_ INNER JOIN card c1_ ON c0_.card_id = c1_.id INNER JOIN serie s2_ ON c1_.serie_id = s2_.id INNER JOIN rarity r3_ ON c1_.rarity_id = r3_.id WHERE c1_.displayed = 1 AND c0_.link IS NOT NULL AND s2_.displayed = 1 AND s2_.release_date IS NOT NULL AND c1_.website_id = 1 AND c1_.lang = 'FR' AND c0_.id IN (25, 28, 30, 58, 55, 54, 26, 61, 60) ORDER BY c1_.release_date DESC, s2_.reference DESC, c1_.number ASC, r3_.sort_order ASC, c1_.serial_number ASC, c1_.reprint_category ASC;