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.reference AS reference_2,
  t0.name AS name_3,
  t0.name_en AS name_en_4,
  t0.name_jp AS name_jp_5,
  t0.color AS color_6,
  t0.description AS description_7,
  t0.keyword AS keyword_8,
  t0.bandai_tcgtext AS bandai_tcgtext_9,
  t0.bandai_tcgtext_en AS bandai_tcgtext_en_10,
  t0.displayed AS displayed_11,
  t0.parent_id AS parent_id_12,
  t0.website_id AS website_id_13
FROM
  skill t0
WHERE
  t0.displayed = ?
  AND t0.website_id = ?
ORDER BY
  t0.name ASC

SELECT t0.id AS id_1, t0.reference AS reference_2, t0.name AS name_3, t0.name_en AS name_en_4, t0.name_jp AS name_jp_5, t0.color AS color_6, t0.description AS description_7, t0.keyword AS keyword_8, t0.bandai_tcgtext AS bandai_tcgtext_9, t0.bandai_tcgtext_en AS bandai_tcgtext_en_10, t0.displayed AS displayed_11, t0.parent_id AS parent_id_12, t0.website_id AS website_id_13 FROM skill t0 WHERE t0.displayed = 1 AND t0.website_id = 1 ORDER BY t0.name ASC;

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.reference AS reference_2,
  t0.name AS name_3,
  t0.name_en AS name_en_4,
  t0.name_jp AS name_jp_5,
  t0.color AS color_6,
  t0.description AS description_7,
  t0.keyword AS keyword_8,
  t0.bandai_tcgtext AS bandai_tcgtext_9,
  t0.bandai_tcgtext_en AS bandai_tcgtext_en_10,
  t0.displayed AS displayed_11,
  t0.parent_id AS parent_id_12,
  t0.website_id AS website_id_13
FROM
  skill t0
WHERE
  t0.website_id = ?
  AND t0.reference = ?
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.name_jp AS name_jp_5, t0.color AS color_6, t0.description AS description_7, t0.keyword AS keyword_8, t0.bandai_tcgtext AS bandai_tcgtext_9, t0.bandai_tcgtext_en AS bandai_tcgtext_en_10, t0.displayed AS displayed_11, t0.parent_id AS parent_id_12, t0.website_id AS website_id_13 FROM skill t0 WHERE t0.website_id = 1 AND t0.reference = 'activation:combat' 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.name_jp AS name_jp_5,
  t0.color AS color_6,
  t0.description AS description_7,
  t0.keyword AS keyword_8,
  t0.bandai_tcgtext AS bandai_tcgtext_9,
  t0.bandai_tcgtext_en AS bandai_tcgtext_en_10,
  t0.displayed AS displayed_11,
  t0.parent_id AS parent_id_12,
  t0.website_id AS website_id_13
FROM
  skill t0
WHERE
  t0.website_id = ?
  AND t0.reference = ?
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.name_jp AS name_jp_5, t0.color AS color_6, t0.description AS description_7, t0.keyword AS keyword_8, t0.bandai_tcgtext AS bandai_tcgtext_9, t0.bandai_tcgtext_en AS bandai_tcgtext_en_10, t0.displayed AS displayed_11, t0.parent_id AS parent_id_12, t0.website_id AS website_id_13 FROM skill t0 WHERE t0.website_id = 1 AND t0.reference = 'activation:combat' 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.name_jp AS name_jp_5,
  t0.color AS color_6,
  t0.description AS description_7,
  t0.keyword AS keyword_8,
  t0.bandai_tcgtext AS bandai_tcgtext_9,
  t0.bandai_tcgtext_en AS bandai_tcgtext_en_10,
  t0.displayed AS displayed_11,
  t0.parent_id AS parent_id_12,
  t0.website_id AS website_id_13
FROM
  skill t0
WHERE
  t0.website_id = ?
  AND t0.reference = ?
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.name_jp AS name_jp_5, t0.color AS color_6, t0.description AS description_7, t0.keyword AS keyword_8, t0.bandai_tcgtext AS bandai_tcgtext_9, t0.bandai_tcgtext_en AS bandai_tcgtext_en_10, t0.displayed AS displayed_11, t0.parent_id AS parent_id_12, t0.website_id AS website_id_13 FROM skill t0 WHERE t0.website_id = 1 AND t0.reference = 'activation:principale' 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.name_jp AS name_jp_5,
  t0.color AS color_6,
  t0.description AS description_7,
  t0.keyword AS keyword_8,
  t0.bandai_tcgtext AS bandai_tcgtext_9,
  t0.bandai_tcgtext_en AS bandai_tcgtext_en_10,
  t0.displayed AS displayed_11,
  t0.parent_id AS parent_id_12,
  t0.website_id AS website_id_13
FROM
  skill t0
WHERE
  t0.website_id = ?
  AND t0.reference = ?
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.name_jp AS name_jp_5, t0.color AS color_6, t0.description AS description_7, t0.keyword AS keyword_8, t0.bandai_tcgtext AS bandai_tcgtext_9, t0.bandai_tcgtext_en AS bandai_tcgtext_en_10, t0.displayed AS displayed_11, t0.parent_id AS parent_id_12, t0.website_id AS website_id_13 FROM skill t0 WHERE t0.website_id = 1 AND t0.reference = 'activation:principale' 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.name_jp AS name_jp_5,
  t0.color AS color_6,
  t0.description AS description_7,
  t0.keyword AS keyword_8,
  t0.bandai_tcgtext AS bandai_tcgtext_9,
  t0.bandai_tcgtext_en AS bandai_tcgtext_en_10,
  t0.displayed AS displayed_11,
  t0.parent_id AS parent_id_12,
  t0.website_id AS website_id_13
FROM
  skill t0
WHERE
  t0.website_id = ?
  AND t0.reference = ?
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.name_jp AS name_jp_5, t0.color AS color_6, t0.description AS description_7, t0.keyword AS keyword_8, t0.bandai_tcgtext AS bandai_tcgtext_9, t0.bandai_tcgtext_en AS bandai_tcgtext_en_10, t0.displayed AS displayed_11, t0.parent_id AS parent_id_12, t0.website_id AS website_id_13 FROM skill t0 WHERE t0.website_id = 1 AND t0.reference = 'activation:principale-combat' 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.name_jp AS name_jp_5,
  t0.color AS color_6,
  t0.description AS description_7,
  t0.keyword AS keyword_8,
  t0.bandai_tcgtext AS bandai_tcgtext_9,
  t0.bandai_tcgtext_en AS bandai_tcgtext_en_10,
  t0.displayed AS displayed_11,
  t0.parent_id AS parent_id_12,
  t0.website_id AS website_id_13
FROM
  skill t0
WHERE
  t0.website_id = ?
  AND t0.reference = ?
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.name_jp AS name_jp_5, t0.color AS color_6, t0.description AS description_7, t0.keyword AS keyword_8, t0.bandai_tcgtext AS bandai_tcgtext_9, t0.bandai_tcgtext_en AS bandai_tcgtext_en_10, t0.displayed AS displayed_11, t0.parent_id AS parent_id_12, t0.website_id AS website_id_13 FROM skill t0 WHERE t0.website_id = 1 AND t0.reference = 'activation:principale-combat' 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.name_jp AS name_jp_5,
  t0.color AS color_6,
  t0.description AS description_7,
  t0.keyword AS keyword_8,
  t0.bandai_tcgtext AS bandai_tcgtext_9,
  t0.bandai_tcgtext_en AS bandai_tcgtext_en_10,
  t0.displayed AS displayed_11,
  t0.parent_id AS parent_id_12,
  t0.website_id AS website_id_13
FROM
  skill t0
WHERE
  t0.website_id = ?
  AND t0.reference = ?
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.name_jp AS name_jp_5, t0.color AS color_6, t0.description AS description_7, t0.keyword AS keyword_8, t0.bandai_tcgtext AS bandai_tcgtext_9, t0.bandai_tcgtext_en AS bandai_tcgtext_en_10, t0.displayed AS displayed_11, t0.parent_id AS parent_id_12, t0.website_id AS website_id_13 FROM skill t0 WHERE t0.website_id = 1 AND t0.reference = 'activation:principale' 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.name_jp AS name_jp_5,
  t0.color AS color_6,
  t0.description AS description_7,
  t0.keyword AS keyword_8,
  t0.bandai_tcgtext AS bandai_tcgtext_9,
  t0.bandai_tcgtext_en AS bandai_tcgtext_en_10,
  t0.displayed AS displayed_11,
  t0.parent_id AS parent_id_12,
  t0.website_id AS website_id_13
FROM
  skill t0
WHERE
  t0.website_id = ?
  AND t0.reference = ?
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.name_jp AS name_jp_5, t0.color AS color_6, t0.description AS description_7, t0.keyword AS keyword_8, t0.bandai_tcgtext AS bandai_tcgtext_9, t0.bandai_tcgtext_en AS bandai_tcgtext_en_10, t0.displayed AS displayed_11, t0.parent_id AS parent_id_12, t0.website_id AS website_id_13 FROM skill t0 WHERE t0.website_id = 1 AND t0.reference = 'activation:combat' 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.name_jp AS name_jp_5,
  t0.color AS color_6,
  t0.description AS description_7,
  t0.keyword AS keyword_8,
  t0.bandai_tcgtext AS bandai_tcgtext_9,
  t0.bandai_tcgtext_en AS bandai_tcgtext_en_10,
  t0.displayed AS displayed_11,
  t0.parent_id AS parent_id_12,
  t0.website_id AS website_id_13
FROM
  skill t0
WHERE
  t0.website_id = ?
  AND t0.reference = ?
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.name_jp AS name_jp_5, t0.color AS color_6, t0.description AS description_7, t0.keyword AS keyword_8, t0.bandai_tcgtext AS bandai_tcgtext_9, t0.bandai_tcgtext_en AS bandai_tcgtext_en_10, t0.displayed AS displayed_11, t0.parent_id AS parent_id_12, t0.website_id AS website_id_13 FROM skill t0 WHERE t0.website_id = 1 AND t0.reference = 'alliance-rouge-vert' 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.name_jp AS name_jp_5,
  t0.color AS color_6,
  t0.description AS description_7,
  t0.keyword AS keyword_8,
  t0.bandai_tcgtext AS bandai_tcgtext_9,
  t0.bandai_tcgtext_en AS bandai_tcgtext_en_10,
  t0.displayed AS displayed_11,
  t0.parent_id AS parent_id_12,
  t0.website_id AS website_id_13
FROM
  skill t0
WHERE
  t0.website_id = ?
  AND t0.reference = ?
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.name_jp AS name_jp_5, t0.color AS color_6, t0.description AS description_7, t0.keyword AS keyword_8, t0.bandai_tcgtext AS bandai_tcgtext_9, t0.bandai_tcgtext_en AS bandai_tcgtext_en_10, t0.displayed AS displayed_11, t0.parent_id AS parent_id_12, t0.website_id AS website_id_13 FROM skill t0 WHERE t0.website_id = 1 AND t0.reference = 'auto' 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.name_jp AS name_jp_5,
  t0.color AS color_6,
  t0.description AS description_7,
  t0.keyword AS keyword_8,
  t0.bandai_tcgtext AS bandai_tcgtext_9,
  t0.bandai_tcgtext_en AS bandai_tcgtext_en_10,
  t0.displayed AS displayed_11,
  t0.parent_id AS parent_id_12,
  t0.website_id AS website_id_13
FROM
  skill t0
WHERE
  t0.website_id = ?
  AND t0.reference = ?
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.name_jp AS name_jp_5, t0.color AS color_6, t0.description AS description_7, t0.keyword AS keyword_8, t0.bandai_tcgtext AS bandai_tcgtext_9, t0.bandai_tcgtext_en AS bandai_tcgtext_en_10, t0.displayed AS displayed_11, t0.parent_id AS parent_id_12, t0.website_id AS website_id_13 FROM skill t0 WHERE t0.website_id = 1 AND t0.reference = 'alliance-rouge-vert' 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.name_jp AS name_jp_5,
  t0.color AS color_6,
  t0.description AS description_7,
  t0.keyword AS keyword_8,
  t0.bandai_tcgtext AS bandai_tcgtext_9,
  t0.bandai_tcgtext_en AS bandai_tcgtext_en_10,
  t0.displayed AS displayed_11,
  t0.parent_id AS parent_id_12,
  t0.website_id AS website_id_13
FROM
  skill t0
WHERE
  t0.website_id = ?
  AND t0.reference = ?
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.name_jp AS name_jp_5, t0.color AS color_6, t0.description AS description_7, t0.keyword AS keyword_8, t0.bandai_tcgtext AS bandai_tcgtext_9, t0.bandai_tcgtext_en AS bandai_tcgtext_en_10, t0.displayed AS displayed_11, t0.parent_id AS parent_id_12, t0.website_id AS website_id_13 FROM skill t0 WHERE t0.website_id = 1 AND t0.reference = 'apparition-bleu-jaune' LIMIT 1;