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.title AS title_2,
  t0.summary AS summary_3,
  t0.content AS content_4,
  t0.creation_date AS creation_date_5,
  t0.update_date AS update_date_6,
  t0.displayed AS displayed_7,
  t0.slug AS slug_8,
  t0.slug_en AS slug_en_9,
  t0.view_count AS view_count_10,
  t0.like_count AS like_count_11,
  t0.website_id AS website_id_12
FROM
  article t0
WHERE
  t0.slug = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.title AS title_2, t0.summary AS summary_3, t0.content AS content_4, t0.creation_date AS creation_date_5, t0.update_date AS update_date_6, t0.displayed AS displayed_7, t0.slug AS slug_8, t0.slug_en AS slug_en_9, t0.view_count AS view_count_10, t0.like_count AS like_count_11, t0.website_id AS website_id_12 FROM article t0 WHERE t0.slug = 'nouvelle-serie-bt17-ultimate-squad' LIMIT 1;

SELECT
  COUNT(a0_.ip) AS sclr_0
FROM
  article_view a0_
WHERE
  a0_.article_id = ?
  AND DATE(a0_.view_date) = ?
  AND a0_.ip = ?

SELECT COUNT(a0_.ip) AS sclr_0 FROM article_view a0_ WHERE a0_.article_id = 21 AND DATE(a0_.view_date) = '2026-11-10' AND a0_.ip = '216.73.216.191';

"START TRANSACTION"

"START TRANSACTION";

INSERT INTO article_view (
  view_date, ip, article_id, user_id
)
VALUES
  (?, ?, ?, ?)

INSERT INTO article_view (view_date, ip, article_id, user_id) VALUES ('2026-11-10 15:14:14', '216.73.216.191', 21, NULL);

UPDATE
  article
SET
  view_count = ?,
  update_date = ?
WHERE
  id = ?

UPDATE article SET view_count = 6130, update_date = '2026-11-10 15:14:14' WHERE id = 21;

"COMMIT"

"COMMIT";

SELECT
  a0_.id AS id_0,
  a0_.reference AS reference_1,
  a0_.name AS name_2,
  a0_.summary AS summary_3,
  a0_.creation_date AS creation_date_4,
  a0_.update_date AS update_date_5,
  a0_.displayed AS displayed_6,
  a0_.slug AS slug_7,
  a0_.slug_en AS slug_en_8,
  COUNT(a1_.id) AS sclr_9,
  a0_.website_id AS website_id_10
FROM
  article_category a0_
  INNER JOIN article_article_category a2_ ON a0_.id = a2_.article_category_id
  INNER JOIN article a1_ ON a1_.id = a2_.article_id
WHERE
  a1_.displayed = 1
GROUP BY
  a0_.id
ORDER BY
  a0_.name ASC

SELECT a0_.id AS id_0, a0_.reference AS reference_1, a0_.name AS name_2, a0_.summary AS summary_3, a0_.creation_date AS creation_date_4, a0_.update_date AS update_date_5, a0_.displayed AS displayed_6, a0_.slug AS slug_7, a0_.slug_en AS slug_en_8, COUNT(a1_.id) AS sclr_9, a0_.website_id AS website_id_10 FROM article_category a0_ INNER JOIN article_article_category a2_ ON a0_.id = a2_.article_category_id INNER JOIN article a1_ ON a1_.id = a2_.article_id WHERE a1_.displayed = 1 GROUP BY a0_.id ORDER BY a0_.name ASC;

SELECT
  a0_.id AS id_0,
  a0_.title AS title_1,
  a0_.summary AS summary_2,
  a0_.content AS content_3,
  a0_.creation_date AS creation_date_4,
  a0_.update_date AS update_date_5,
  a0_.displayed AS displayed_6,
  a0_.slug AS slug_7,
  a0_.slug_en AS slug_en_8,
  a0_.view_count AS view_count_9,
  a0_.like_count AS like_count_10,
  a0_.website_id AS website_id_11
FROM
  article a0_
WHERE
  a0_.displayed = 1
ORDER BY
  a0_.creation_date DESC
LIMIT
  10

SELECT a0_.id AS id_0, a0_.title AS title_1, a0_.summary AS summary_2, a0_.content AS content_3, a0_.creation_date AS creation_date_4, a0_.update_date AS update_date_5, a0_.displayed AS displayed_6, a0_.slug AS slug_7, a0_.slug_en AS slug_en_8, a0_.view_count AS view_count_9, a0_.like_count AS like_count_10, a0_.website_id AS website_id_11 FROM article a0_ WHERE a0_.displayed = 1 ORDER BY a0_.creation_date DESC LIMIT 10;

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.title AS title_2,
  t0.summary AS summary_3,
  t0.content AS content_4,
  t0.creation_date AS creation_date_5,
  t0.update_date AS update_date_6,
  t0.displayed AS displayed_7,
  t0.slug AS slug_8,
  t0.slug_en AS slug_en_9,
  t0.view_count AS view_count_10,
  t0.like_count AS like_count_11,
  t0.website_id AS website_id_12
FROM
  article t0
WHERE
  t0.slug = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.title AS title_2, t0.summary AS summary_3, t0.content AS content_4, t0.creation_date AS creation_date_5, t0.update_date AS update_date_6, t0.displayed AS displayed_7, t0.slug AS slug_8, t0.slug_en AS slug_en_9, t0.view_count AS view_count_10, t0.like_count AS like_count_11, t0.website_id AS website_id_12 FROM article t0 WHERE t0.slug = 'nouvelle-serie-bt17-ultimate-squad' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.name_en AS name_en_3,
  t0.sort_order AS sort_order_4,
  t0.deck_sort_order AS deck_sort_order_5,
  t0.leader AS leader_6,
  t0.displayed AS displayed_7,
  t0.website_id AS website_id_8
FROM
  card_type t0
WHERE
  t0.name = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.name_en AS name_en_3, t0.sort_order AS sort_order_4, t0.deck_sort_order AS deck_sort_order_5, t0.leader AS leader_6, t0.displayed AS displayed_7, t0.website_id AS website_id_8 FROM card_type t0 WHERE t0.name = 'COMBAT' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.name_en AS name_en_3,
  t0.sort_order AS sort_order_4,
  t0.deck_sort_order AS deck_sort_order_5,
  t0.leader AS leader_6,
  t0.displayed AS displayed_7,
  t0.website_id AS website_id_8
FROM
  card_type t0
WHERE
  t0.name = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.name_en AS name_en_3, t0.sort_order AS sort_order_4, t0.deck_sort_order AS deck_sort_order_5, t0.leader AS leader_6, t0.displayed AS displayed_7, t0.website_id AS website_id_8 FROM card_type t0 WHERE t0.name = 'COMBAT' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.name_en AS name_en_3,
  t0.sort_order AS sort_order_4,
  t0.deck_sort_order AS deck_sort_order_5,
  t0.leader AS leader_6,
  t0.displayed AS displayed_7,
  t0.website_id AS website_id_8
FROM
  card_type t0
WHERE
  t0.name = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.name_en AS name_en_3, t0.sort_order AS sort_order_4, t0.deck_sort_order AS deck_sort_order_5, t0.leader AS leader_6, t0.displayed AS displayed_7, t0.website_id AS website_id_8 FROM card_type t0 WHERE t0.name = 'COMBAT' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.name_en AS name_en_3,
  t0.sort_order AS sort_order_4,
  t0.deck_sort_order AS deck_sort_order_5,
  t0.leader AS leader_6,
  t0.displayed AS displayed_7,
  t0.website_id AS website_id_8
FROM
  card_type t0
WHERE
  t0.name = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.name_en AS name_en_3, t0.sort_order AS sort_order_4, t0.deck_sort_order AS deck_sort_order_5, t0.leader AS leader_6, t0.displayed AS displayed_7, t0.website_id AS website_id_8 FROM card_type t0 WHERE t0.name = '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.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.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.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.reference = 'BT17' LIMIT 1;

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 = ?
LIMIT
  1

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 = '6633' LIMIT 1;