Symfony Profiler

SELECT
  count(DISTINCT c0_.id) AS sclr_0
FROM
  card c0_
  INNER JOIN serie s1_ ON c0_.serie_id = s1_.id
  INNER JOIN rarity r2_ ON c0_.rarity_id = r2_.id
WHERE
  c0_.displayed = 1
  AND s1_.displayed = 1
  AND s1_.release_date IS NOT NULL
  AND c0_.slug IS NOT NULL
  AND c0_.website_id = ?
  AND (
    c0_.serie_id = ?
    OR EXISTS (
      SELECT
        1
      FROM
        card_additional_serie c3_
      WHERE
        c3_.card_id = c0_.id
        AND c3_.serie_id IN (?)
    )
  )
  AND c0_.lang = ?
  AND c0_.reprint = 0

SELECT count(DISTINCT c0_.id) AS sclr_0 FROM card c0_ INNER JOIN serie s1_ ON c0_.serie_id = s1_.id INNER JOIN rarity r2_ ON c0_.rarity_id = r2_.id WHERE c0_.displayed = 1 AND s1_.displayed = 1 AND s1_.release_date IS NOT NULL AND c0_.slug IS NOT NULL AND c0_.website_id = 1 AND (c0_.serie_id = 133 OR EXISTS (SELECT 1 FROM card_additional_serie c3_ WHERE c3_.card_id = c0_.id AND c3_.serie_id IN (133))) AND c0_.lang = 'EN' AND c0_.reprint = 0;

SELECT
  COUNT(c0_.id) AS sclr_0
FROM
  card c0_
WHERE
  (
    c0_.serie_id = ?
    OR EXISTS (
      SELECT
        1
      FROM
        card_additional_serie c1_
      WHERE
        c1_.card_id = c0_.id
        AND c1_.serie_id IN (?)
    )
  )
  AND c0_.slug IS NOT NULL
  AND c0_.displayed = 1
  AND c0_.reprint = 0
  AND c0_.lang = ?

SELECT COUNT(c0_.id) AS sclr_0 FROM card c0_ WHERE (c0_.serie_id = 133 OR EXISTS (SELECT 1 FROM card_additional_serie c1_ WHERE c1_.card_id = c0_.id AND c1_.serie_id IN (133))) AND c0_.slug IS NOT NULL AND c0_.displayed = 1 AND c0_.reprint = 0 AND c0_.lang = 'EN';

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
  DISTINCT (c0_.front_energy_cost) AS sclr_0
FROM
  card c0_
WHERE
  c0_.front_energy_cost IS NOT NULL
  AND c0_.website_id = ?
ORDER BY
  c0_.front_energy_cost ASC

SELECT DISTINCT (c0_.front_energy_cost) AS sclr_0 FROM card c0_ WHERE c0_.front_energy_cost IS NOT NULL AND c0_.website_id = 1 ORDER BY c0_.front_energy_cost ASC;

SELECT
  DISTINCT (c0_.secondary_cost) AS sclr_0
FROM
  card c0_
WHERE
  c0_.secondary_cost IS NOT NULL
  AND c0_.website_id = ?
ORDER BY
  c0_.secondary_cost ASC

SELECT DISTINCT (c0_.secondary_cost) AS sclr_0 FROM card c0_ WHERE c0_.secondary_cost IS NOT NULL AND c0_.website_id = 1 ORDER BY c0_.secondary_cost ASC;

SELECT
  DISTINCT c0_.id AS id_0,
  c0_.end_of_serie AS end_of_serie_1,
  s1_.release_date AS release_date_2,
  s1_.reference AS reference_3,
  c0_.number AS number_4,
  r2_.sort_order AS sort_order_5,
  c0_.serial_number AS serial_number_6,
  c0_.version_number AS version_number_7,
  c0_.reprint_category AS reprint_category_8
FROM
  card c0_
  INNER JOIN serie s1_ ON c0_.serie_id = s1_.id
  INNER JOIN rarity r2_ ON c0_.rarity_id = r2_.id
WHERE
  c0_.displayed = 1
  AND s1_.displayed = 1
  AND s1_.release_date IS NOT NULL
  AND c0_.slug IS NOT NULL
  AND c0_.website_id = ?
  AND (
    c0_.serie_id = ?
    OR EXISTS (
      SELECT
        1
      FROM
        card_additional_serie c3_
      WHERE
        c3_.card_id = c0_.id
        AND c3_.serie_id IN (?)
    )
  )
  AND c0_.lang = ?
  AND c0_.reprint = 0
ORDER BY
  c0_.end_of_serie ASC,
  s1_.release_date ASC,
  s1_.reference DESC,
  c0_.number ASC,
  r2_.sort_order ASC,
  c0_.serial_number ASC,
  c0_.version_number ASC,
  c0_.reprint_category ASC
LIMIT
  30

SELECT DISTINCT c0_.id AS id_0, c0_.end_of_serie AS end_of_serie_1, s1_.release_date AS release_date_2, s1_.reference AS reference_3, c0_.number AS number_4, r2_.sort_order AS sort_order_5, c0_.serial_number AS serial_number_6, c0_.version_number AS version_number_7, c0_.reprint_category AS reprint_category_8 FROM card c0_ INNER JOIN serie s1_ ON c0_.serie_id = s1_.id INNER JOIN rarity r2_ ON c0_.rarity_id = r2_.id WHERE c0_.displayed = 1 AND s1_.displayed = 1 AND s1_.release_date IS NOT NULL AND c0_.slug IS NOT NULL AND c0_.website_id = 1 AND (c0_.serie_id = 133 OR EXISTS (SELECT 1 FROM card_additional_serie c3_ WHERE c3_.card_id = c0_.id AND c3_.serie_id IN (133))) AND c0_.lang = 'EN' AND c0_.reprint = 0 ORDER BY c0_.end_of_serie ASC, s1_.release_date ASC, s1_.reference DESC, c0_.number ASC, r2_.sort_order ASC, c0_.serial_number ASC, c0_.version_number ASC, c0_.reprint_category ASC LIMIT 30;

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.website_id = ?
  AND t0.slug = ?
LIMIT
  1

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.website_id = 1 AND t0.slug = 'en-bt19-fighters-ambition' LIMIT 1;

SELECT
  c0_.id AS id_0,
  c0_.reference AS reference_1,
  c0_.name AS name_2,
  c0_.name_en AS name_en_3,
  c0_.description AS description_4,
  c0_.type AS type_5,
  c0_.website_id AS website_id_6
FROM
  card_tag c0_
WHERE
  (c0_.website_id = ?)
  AND c0_.type IN ('UTILITY')
ORDER BY
  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_.description AS description_4, c0_.type AS type_5, c0_.website_id AS website_id_6 FROM card_tag c0_ WHERE (c0_.website_id = 1) AND c0_.type IN ('UTILITY') ORDER BY c0_.name ASC;

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
  c0_.id AS id_0,
  c0_.reference AS reference_1,
  c0_.name AS name_2,
  c0_.name_en AS name_en_3,
  c0_.description AS description_4,
  c0_.type AS type_5,
  c0_.website_id AS website_id_6
FROM
  card_tag c0_
WHERE
  (c0_.website_id = ?)
  AND c0_.type IN ('THEME')
ORDER BY
  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_.description AS description_4, c0_.type AS type_5, c0_.website_id AS website_id_6 FROM card_tag c0_ WHERE (c0_.website_id = 1) AND c0_.type IN ('THEME') ORDER BY 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_.description AS description_4,
  c0_.type AS type_5,
  c0_.website_id AS website_id_6
FROM
  card_tag c0_
WHERE
  (c0_.website_id = ?)
  AND c0_.type IN ('COMPLEMENTARITY')
ORDER BY
  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_.description AS description_4, c0_.type AS type_5, c0_.website_id AS website_id_6 FROM card_tag c0_ WHERE (c0_.website_id = 1) AND c0_.type IN ('COMPLEMENTARITY') ORDER BY c0_.name ASC;

SELECT
  s0_.id AS id_0,
  s0_.reference AS reference_1,
  s0_.name AS name_2,
  s0_.name_en AS name_en_3,
  s0_.name_jp AS name_jp_4,
  s0_.color AS color_5,
  s0_.description AS description_6,
  s0_.keyword AS keyword_7,
  s0_.bandai_tcgtext AS bandai_tcgtext_8,
  s0_.bandai_tcgtext_en AS bandai_tcgtext_en_9,
  s0_.displayed AS displayed_10,
  s0_.parent_id AS parent_id_11,
  s0_.website_id AS website_id_12
FROM
  skill s0_
WHERE
  s0_.displayed = 1
  AND s0_.website_id = ?
ORDER BY
  s0_.name ASC

SELECT s0_.id AS id_0, s0_.reference AS reference_1, s0_.name AS name_2, s0_.name_en AS name_en_3, s0_.name_jp AS name_jp_4, s0_.color AS color_5, s0_.description AS description_6, s0_.keyword AS keyword_7, s0_.bandai_tcgtext AS bandai_tcgtext_8, s0_.bandai_tcgtext_en AS bandai_tcgtext_en_9, s0_.displayed AS displayed_10, s0_.parent_id AS parent_id_11, s0_.website_id AS website_id_12 FROM skill s0_ WHERE s0_.displayed = 1 AND s0_.website_id = 1 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 = ?
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;

SELECT
  t0.number AS number_1,
  t0.sort_order AS sort_order_2,
  t0.serie_id AS serie_id_3,
  t0.rarity_id AS rarity_id_4
FROM
  serie_rarity t0
WHERE
  t0.serie_id = ?
ORDER BY
  t0.sort_order ASC

SELECT t0.number AS number_1, t0.sort_order AS sort_order_2, t0.serie_id AS serie_id_3, t0.rarity_id AS rarity_id_4 FROM serie_rarity t0 WHERE t0.serie_id = 133 ORDER BY t0.sort_order ASC;

SELECT
  e0_.id AS id_0,
  e0_.name AS name_1,
  e0_.name_en AS name_en_2,
  e0_.description AS description_3,
  e0_.slug AS slug_4,
  e0_.slug_en AS slug_en_5,
  e0_.creation_date AS creation_date_6,
  e0_.update_date AS update_date_7,
  e0_.website_id AS website_id_8
FROM
  era e0_
WHERE
  e0_.website_id = ?
ORDER BY
  e0_.name ASC

SELECT e0_.id AS id_0, e0_.name AS name_1, e0_.name_en AS name_en_2, e0_.description AS description_3, e0_.slug AS slug_4, e0_.slug_en AS slug_en_5, e0_.creation_date AS creation_date_6, e0_.update_date AS update_date_7, e0_.website_id AS website_id_8 FROM era e0_ WHERE e0_.website_id = 1 ORDER BY e0_.name ASC;

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;