Symfony Profiler

[
  "route" => "characters_view"
  "route_parameters" => [
    "_route" => "characters_view"
    "_controller" => "App\Controller\Extra\CharacterController::view"
    "slug" => "gamma-1"
  ]
  "request_uri" => "https://dev.tcgcards.fr/characters/gamma-1"
  "method" => "GET"
]

[
  "firewall_name" => "main"
  "authenticators" => 4
]

[
  "firewall_name" => "main"
  "authenticator" => "Symfony\Component\Security\Http\Authenticator\Debug\TraceableAuthenticator"
]

[
  "firewall_name" => "main"
  "authenticator" => "Symfony\Component\Security\Http\Authenticator\Debug\TraceableAuthenticator"
]

[
  "firewall_name" => "main"
  "authenticator" => "Symfony\Component\Security\Http\Authenticator\Debug\TraceableAuthenticator"
]

[
  "firewall_name" => "main"
  "authenticator" => "Symfony\Component\Security\Http\Authenticator\Debug\TraceableAuthenticator"
]

[
  "firewall_name" => "main"
  "authenticator" => "Symfony\Component\Security\Http\Authenticator\Debug\TraceableAuthenticator"
]

[
  "firewall_name" => "main"
  "authenticator" => "Symfony\Component\Security\Http\Authenticator\Debug\TraceableAuthenticator"
]

[
  "firewall_name" => "main"
  "authenticator" => "Symfony\Component\Security\Http\Authenticator\Debug\TraceableAuthenticator"
]

[
  "firewall_name" => "main"
  "authenticator" => "Symfony\Component\Security\Http\Authenticator\Debug\TraceableAuthenticator"
]

[
  "params" => [
    "driver" => "pdo_mysql"
    "idle_connection_ttl" => 600
    "host" => "127.0.0.1"
    "port" => 3306
    "user" => "root"
    "password" => "<redacted>"
    "driverOptions" => []
    "serverVersion" => "11.8.6-MariaDB-0 deb13u1"
    "defaultTableOptions" => [
      "collation" => "utf8mb4_unicode_ci"
    ]
    "dbname" => "tcgcards"
    "charset" => "utf8mb4"
  ]
]

[
  "sql" => "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"
  "params" => [
    1 => "dbscards"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1082
      +name: "STRING"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.name AS name_2, t0.name_en AS name_en_3, t0.description AS description_4, t0.slug AS slug_5, t0.slug_en AS slug_en_6, t0.creation_date AS creation_date_7, t0.update_date AS update_date_8, t0.website_id AS website_id_9 FROM `character` t0 WHERE t0.slug = ? AND t0.website_id = ? LIMIT 1"
  "params" => [
    1 => "gamma-1"
    2 => 1
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1082
      +name: "STRING"
    }
    2 => Doctrine\DBAL\ParameterType {#1103
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "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"
  "params" => [
    1 => 1
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1103
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT COUNT(c0_.id) AS sclr_0, MAX(c0_.current_price) AS sclr_1, AVG(c0_.current_price) AS sclr_2 FROM card c0_ WHERE (EXISTS (SELECT 1 FROM card_front_characters c1_ WHERE c1_.card_id = c0_.id AND c1_.character_id IN (?)) OR EXISTS (SELECT 1 FROM card_back_characters c2_ WHERE c2_.card_id = c0_.id AND c2_.character_id IN (?))) AND c0_.slug IS NOT NULL AND c0_.displayed = 1 ORDER BY c0_.current_price DESC, c0_.release_date DESC, c0_.number DESC, c0_.id DESC"
  "params" => [
    1 => 506
    2 => 506
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1103
      +name: "INTEGER"
    }
    2 => Doctrine\DBAL\ParameterType {#1103}
  ]
]

[
  "sql" => "SELECT c0_.id AS id_0, c0_.number AS number_1, c0_.serial_number AS serial_number_2, c0_.front_name AS front_name_3, c0_.front_description AS front_description_4, c0_.front_energy_cost AS front_energy_cost_5, c0_.secondary_cost AS secondary_cost_6, c0_.front_energy_cost_alias AS front_energy_cost_alias_7, c0_.front_energy_color_cost AS front_energy_color_cost_8, c0_.back_energy_color_cost AS back_energy_color_cost_9, c0_.front_combo_cost AS front_combo_cost_10, c0_.front_combo_power AS front_combo_power_11, c0_.front_power AS front_power_12, c0_.front_defense AS front_defense_13, c0_.back_name AS back_name_14, c0_.back_description AS back_description_15, c0_.back_power AS back_power_16, c0_.back_power2 AS back_power2_17, c0_.back_defense AS back_defense_18, c0_.back_defense2 AS back_defense2_19, c0_.img_ready AS img_ready_20, c0_.image_ready AS image_ready_21, c0_.multicolor AS multicolor_22, c0_.limited AS limited_23, c0_.banned AS banned_24, c0_.unlimited_in_deck AS unlimited_in_deck_25, c0_.limitation_in_deck AS limitation_in_deck_26, c0_.reprint AS reprint_27, c0_.foil AS foil_28, c0_.reprint_category AS reprint_category_29, c0_.animated AS animated_30, c0_.version_number AS version_number_31, c0_.front_name_alias AS front_name_alias_32, c0_.front_name_en AS front_name_en_33, c0_.back_name_en AS back_name_en_34, c0_.front_description_en AS front_description_en_35, c0_.back_description_en AS back_description_en_36, c0_.english_only AS english_only_37, c0_.redirect_english_slug AS redirect_english_slug_38, c0_.position_serie_list AS position_serie_list_39, c0_.lore AS lore_40, c0_.subname AS subname_41, c0_.illustrator AS illustrator_42, c0_.energyzable AS energyzable_43, c0_.weakness AS weakness_44, c0_.resistance AS resistance_45, c0_.sub_description AS sub_description_46, c0_.exclusive AS exclusive_47, c0_.end_of_serie AS end_of_serie_48, c0_.verso AS verso_49, c0_.additional_data AS additional_data_50, c0_.ocr_keywords_count AS ocr_keywords_count_51, c0_.beta AS beta_52, c0_.level AS level_53, c0_.price_alert AS price_alert_54, c0_.creation_date AS creation_date_55, c0_.update_date AS update_date_56, c0_.displayed AS displayed_57, c0_.slug AS slug_58, c0_.slug_en AS slug_en_59, c0_.view_count AS view_count_60, c0_.cmid AS cmid_61, c0_.url AS url_62, c0_.image AS image_63, c0_.current_price AS current_price_64, c0_.yesterday_price AS yesterday_price_65, c0_.last_price_update AS last_price_update_66, c0_.cardnexus_id AS cardnexus_id_67, c0_.cardnexus_current_price AS cardnexus_current_price_68, c0_.cardnexus_yesterday_price AS cardnexus_yesterday_price_69, c0_.cardnexus_last_price_update AS cardnexus_last_price_update_70, c0_.lang AS lang_71, c0_.release_date AS release_date_72, c0_.complete AS complete_73, c0_.bandai_tcgid AS bandai_tcgid_74, c0_.checked AS checked_75, c0_.indexable AS indexable_76, c0_.front_era_id AS front_era_id_77, c0_.back_era_id AS back_era_id_78, c0_.type_id AS type_id_79, c0_.serie_id AS serie_id_80, c0_.rarity_id AS rarity_id_81, c0_.group_version_id AS group_version_id_82, c0_.avatar_id AS avatar_id_83, c0_.version_id AS version_id_84, c0_.auto_play_id AS auto_play_id_85, c0_.version_annotation_id AS version_annotation_id_86, c0_.website_id AS website_id_87 FROM card c0_ WHERE (EXISTS (SELECT 1 FROM card_front_characters c1_ WHERE c1_.card_id = c0_.id AND c1_.character_id IN (?)) OR EXISTS (SELECT 1 FROM card_back_characters c2_ WHERE c2_.card_id = c0_.id AND c2_.character_id IN (?))) AND c0_.displayed = 1 AND c0_.website_id = ? ORDER BY c0_.current_price DESC LIMIT 10"
  "params" => [
    1 => 506
    2 => 506
    3 => 1
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1103
      +name: "INTEGER"
    }
    2 => Doctrine\DBAL\ParameterType {#1103}
    3 => Doctrine\DBAL\ParameterType {#1103}
  ]
]

[
  "sql" => "SELECT c0_.id AS id_0, c0_.number AS number_1, c0_.serial_number AS serial_number_2, c0_.front_name AS front_name_3, c0_.front_description AS front_description_4, c0_.front_energy_cost AS front_energy_cost_5, c0_.secondary_cost AS secondary_cost_6, c0_.front_energy_cost_alias AS front_energy_cost_alias_7, c0_.front_energy_color_cost AS front_energy_color_cost_8, c0_.back_energy_color_cost AS back_energy_color_cost_9, c0_.front_combo_cost AS front_combo_cost_10, c0_.front_combo_power AS front_combo_power_11, c0_.front_power AS front_power_12, c0_.front_defense AS front_defense_13, c0_.back_name AS back_name_14, c0_.back_description AS back_description_15, c0_.back_power AS back_power_16, c0_.back_power2 AS back_power2_17, c0_.back_defense AS back_defense_18, c0_.back_defense2 AS back_defense2_19, c0_.img_ready AS img_ready_20, c0_.image_ready AS image_ready_21, c0_.multicolor AS multicolor_22, c0_.limited AS limited_23, c0_.banned AS banned_24, c0_.unlimited_in_deck AS unlimited_in_deck_25, c0_.limitation_in_deck AS limitation_in_deck_26, c0_.reprint AS reprint_27, c0_.foil AS foil_28, c0_.reprint_category AS reprint_category_29, c0_.animated AS animated_30, c0_.version_number AS version_number_31, c0_.front_name_alias AS front_name_alias_32, c0_.front_name_en AS front_name_en_33, c0_.back_name_en AS back_name_en_34, c0_.front_description_en AS front_description_en_35, c0_.back_description_en AS back_description_en_36, c0_.english_only AS english_only_37, c0_.redirect_english_slug AS redirect_english_slug_38, c0_.position_serie_list AS position_serie_list_39, c0_.lore AS lore_40, c0_.subname AS subname_41, c0_.illustrator AS illustrator_42, c0_.energyzable AS energyzable_43, c0_.weakness AS weakness_44, c0_.resistance AS resistance_45, c0_.sub_description AS sub_description_46, c0_.exclusive AS exclusive_47, c0_.end_of_serie AS end_of_serie_48, c0_.verso AS verso_49, c0_.additional_data AS additional_data_50, c0_.ocr_keywords_count AS ocr_keywords_count_51, c0_.beta AS beta_52, c0_.level AS level_53, c0_.price_alert AS price_alert_54, c0_.creation_date AS creation_date_55, c0_.update_date AS update_date_56, c0_.displayed AS displayed_57, c0_.slug AS slug_58, c0_.slug_en AS slug_en_59, c0_.view_count AS view_count_60, c0_.cmid AS cmid_61, c0_.url AS url_62, c0_.image AS image_63, c0_.current_price AS current_price_64, c0_.yesterday_price AS yesterday_price_65, c0_.last_price_update AS last_price_update_66, c0_.cardnexus_id AS cardnexus_id_67, c0_.cardnexus_current_price AS cardnexus_current_price_68, c0_.cardnexus_yesterday_price AS cardnexus_yesterday_price_69, c0_.cardnexus_last_price_update AS cardnexus_last_price_update_70, c0_.lang AS lang_71, c0_.release_date AS release_date_72, c0_.complete AS complete_73, c0_.bandai_tcgid AS bandai_tcgid_74, c0_.checked AS checked_75, c0_.indexable AS indexable_76, c0_.front_era_id AS front_era_id_77, c0_.back_era_id AS back_era_id_78, c0_.type_id AS type_id_79, c0_.serie_id AS serie_id_80, c0_.rarity_id AS rarity_id_81, c0_.group_version_id AS group_version_id_82, c0_.avatar_id AS avatar_id_83, c0_.version_id AS version_id_84, c0_.auto_play_id AS auto_play_id_85, c0_.version_annotation_id AS version_annotation_id_86, c0_.website_id AS website_id_87 FROM card c0_ WHERE (EXISTS (SELECT 1 FROM card_front_characters c1_ WHERE c1_.card_id = c0_.id AND c1_.character_id IN (?)) OR EXISTS (SELECT 1 FROM card_back_characters c2_ WHERE c2_.card_id = c0_.id AND c2_.character_id IN (?))) AND c0_.displayed = 1 AND c0_.website_id = ? ORDER BY c0_.release_date DESC LIMIT 10"
  "params" => [
    1 => 506
    2 => 506
    3 => 1
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1103
      +name: "INTEGER"
    }
    2 => Doctrine\DBAL\ParameterType {#1103}
    3 => Doctrine\DBAL\ParameterType {#1103}
  ]
]

[
  "sql" => "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"
  "params" => [
    1 => 1
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1103
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "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"
  "params" => [
    1 => 1
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1103
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.name AS name_2, t0.name_en AS name_en_3, t0.description AS description_4, t0.slug AS slug_5, t0.slug_en AS slug_en_6, t0.creation_date AS creation_date_7, t0.update_date AS update_date_8, t0.website_id AS website_id_9 FROM `character` t0 WHERE t0.slug = ? AND t0.website_id = ? LIMIT 1"
  "params" => [
    1 => "gamma-1"
    2 => 1
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1082
      +name: "STRING"
    }
    2 => Doctrine\DBAL\ParameterType {#1103
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT t0.quantity AS quantity_1, t0.card_id AS card_id_2, t0.user_id AS user_id_3 FROM card_owned t0 WHERE t0.card_id = ? AND t0.user_id IS NULL LIMIT 1"
  "params" => [
    1 => 47503
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1103
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "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.id = ?"
  "params" => [
    1 => 484
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1103
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "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.id = ?"
  "params" => [
    1 => 3
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1103
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT t0.quantity AS quantity_1, t0.card_id AS card_id_2, t0.user_id AS user_id_3 FROM card_owned t0 WHERE t0.card_id = ? AND t0.user_id IS NULL LIMIT 1"
  "params" => [
    1 => 19213
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1103
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "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.id = ?"
  "params" => [
    1 => 270
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1103
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "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.id = ?"
  "params" => [
    1 => 4
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1103
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT t0.quantity AS quantity_1, t0.card_id AS card_id_2, t0.user_id AS user_id_3 FROM card_owned t0 WHERE t0.card_id = ? AND t0.user_id IS NULL LIMIT 1"
  "params" => [
    1 => 19212
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1103
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT t0.quantity AS quantity_1, t0.card_id AS card_id_2, t0.user_id AS user_id_3 FROM card_owned t0 WHERE t0.card_id = ? AND t0.user_id IS NULL LIMIT 1"
  "params" => [
    1 => 7665
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1103
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "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.id = ?"
  "params" => [
    1 => 1
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1103
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT t0.quantity AS quantity_1, t0.card_id AS card_id_2, t0.user_id AS user_id_3 FROM card_owned t0 WHERE t0.card_id = ? AND t0.user_id IS NULL LIMIT 1"
  "params" => [
    1 => 20013
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1103
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "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.id = ?"
  "params" => [
    1 => 271
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1103
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT t0.quantity AS quantity_1, t0.card_id AS card_id_2, t0.user_id AS user_id_3 FROM card_owned t0 WHERE t0.card_id = ? AND t0.user_id IS NULL LIMIT 1"
  "params" => [
    1 => 7854
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1103
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "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.id = ?"
  "params" => [
    1 => 92
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1103
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT t0.quantity AS quantity_1, t0.card_id AS card_id_2, t0.user_id AS user_id_3 FROM card_owned t0 WHERE t0.card_id = ? AND t0.user_id IS NULL LIMIT 1"
  "params" => [
    1 => 8341
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1103
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "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.id = ?"
  "params" => [
    1 => 161
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1103
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT t0.quantity AS quantity_1, t0.card_id AS card_id_2, t0.user_id AS user_id_3 FROM card_owned t0 WHERE t0.card_id = ? AND t0.user_id IS NULL LIMIT 1"
  "params" => [
    1 => 20012
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1103
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT t0.quantity AS quantity_1, t0.card_id AS card_id_2, t0.user_id AS user_id_3 FROM card_owned t0 WHERE t0.card_id = ? AND t0.user_id IS NULL LIMIT 1"
  "params" => [
    1 => 19210
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1103
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT t0.quantity AS quantity_1, t0.card_id AS card_id_2, t0.user_id AS user_id_3 FROM card_owned t0 WHERE t0.card_id = ? AND t0.user_id IS NULL LIMIT 1"
  "params" => [
    1 => 19194
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1103
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "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.id = ?"
  "params" => [
    1 => 19
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1103
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT t0.quantity AS quantity_1, t0.card_id AS card_id_2, t0.user_id AS user_id_3 FROM card_owned t0 WHERE t0.card_id = ? AND t0.user_id IS NULL LIMIT 1"
  "params" => [
    1 => 47644
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1103
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT t0.quantity AS quantity_1, t0.card_id AS card_id_2, t0.user_id AS user_id_3 FROM card_owned t0 WHERE t0.card_id = ? AND t0.user_id IS NULL LIMIT 1"
  "params" => [
    1 => 47502
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1103
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT t0.quantity AS quantity_1, t0.card_id AS card_id_2, t0.user_id AS user_id_3 FROM card_owned t0 WHERE t0.card_id = ? AND t0.user_id IS NULL LIMIT 1"
  "params" => [
    1 => 47503
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1103
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT t0.quantity AS quantity_1, t0.card_id AS card_id_2, t0.user_id AS user_id_3 FROM card_owned t0 WHERE t0.card_id = ? AND t0.user_id IS NULL LIMIT 1"
  "params" => [
    1 => 40082
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1103
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "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.id = ?"
  "params" => [
    1 => 426
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1103
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT t0.quantity AS quantity_1, t0.card_id AS card_id_2, t0.user_id AS user_id_3 FROM card_owned t0 WHERE t0.card_id = ? AND t0.user_id IS NULL LIMIT 1"
  "params" => [
    1 => 19210
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1103
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT t0.quantity AS quantity_1, t0.card_id AS card_id_2, t0.user_id AS user_id_3 FROM card_owned t0 WHERE t0.card_id = ? AND t0.user_id IS NULL LIMIT 1"
  "params" => [
    1 => 19211
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1103
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT t0.quantity AS quantity_1, t0.card_id AS card_id_2, t0.user_id AS user_id_3 FROM card_owned t0 WHERE t0.card_id = ? AND t0.user_id IS NULL LIMIT 1"
  "params" => [
    1 => 19212
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1103
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT t0.quantity AS quantity_1, t0.card_id AS card_id_2, t0.user_id AS user_id_3 FROM card_owned t0 WHERE t0.card_id = ? AND t0.user_id IS NULL LIMIT 1"
  "params" => [
    1 => 19213
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1103
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT t0.quantity AS quantity_1, t0.card_id AS card_id_2, t0.user_id AS user_id_3 FROM card_owned t0 WHERE t0.card_id = ? AND t0.user_id IS NULL LIMIT 1"
  "params" => [
    1 => 19194
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1103
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT t0.quantity AS quantity_1, t0.card_id AS card_id_2, t0.user_id AS user_id_3 FROM card_owned t0 WHERE t0.card_id = ? AND t0.user_id IS NULL LIMIT 1"
  "params" => [
    1 => 8283
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1103
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "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.id = ?"
  "params" => [
    1 => 132
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1103
      +name: "INTEGER"
    }
  ]
]