Symfony Profiler

[
  "route" => "players_list"
  "route_parameters" => [
    "_route" => "players_list"
    "_controller" => "App\Controller\PlayerController::list"
  ]
  "request_uri" => "https://dev.tcgcards.fr/players"
  "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 {#1104
      +name: "STRING"
    }
  ]
]

[
  "sql" => "SELECT c0_.id AS id_0, c0_.code AS code_1, c0_.name AS name_2, c0_.name_vo AS name_vo_3, c0_.french AS french_4, c0_.view_box AS view_box_5, c0_.department_label AS department_label_6, c0_.displayed AS displayed_7 FROM country c0_ WHERE c0_.displayed = 1 ORDER BY c0_.name ASC"
]

[
  "sql" => "SELECT count(DISTINCT u0_.id) AS sclr_0 FROM user u0_ WHERE (EXISTS (SELECT 1 FROM user_game u1_ WHERE u1_.user_id = u0_.id AND u1_.web_site_id IN (?))) AND u0_.category IN ('USER', 'VIDEOGRAPHER')"
  "params" => [
    1 => 1
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1107
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT DISTINCT u0_.id AS id_0, u0_.pseudo AS pseudo_1 FROM user u0_ WHERE (EXISTS (SELECT 1 FROM user_game u1_ WHERE u1_.user_id = u0_.id AND u1_.web_site_id IN (?))) AND u0_.category IN ('USER', 'VIDEOGRAPHER') ORDER BY u0_.pseudo ASC LIMIT 30"
  "params" => [
    1 => 1
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1107
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT u0_.id AS id_0, u0_.email AS email_1, u0_.pseudo AS pseudo_2, u0_.play_id AS play_id_3, u0_.roles AS roles_4, u0_.password AS password_5, u0_.reset_password_link AS reset_password_link_6, u0_.last_login_date AS last_login_date_7, u0_.facebook_id AS facebook_id_8, u0_.facebook_access_token AS facebook_access_token_9, u0_.google_id AS google_id_10, u0_.discord_id AS discord_id_11, u0_.seller_name AS seller_name_12, u0_.achievements_points AS achievements_points_13, u0_.nb_logins AS nb_logins_14, u0_.nb_logins_in_arow AS nb_logins_in_arow_15, u0_.max_logins_in_arow AS max_logins_in_arow_16, u0_.capsule_count AS capsule_count_17, u0_.api_id AS api_id_18, u0_.credits AS credits_19, u0_.cardnexus_mail AS cardnexus_mail_20, u0_.creation_date AS creation_date_21, u0_.update_date AS update_date_22, u0_.youtube_channel AS youtube_channel_23, u0_.category AS category_24, u0_.avatar_id AS avatar_id_25, u0_.data_player_id AS data_player_id_26, u0_.country_id AS country_id_27, u0_.department_id AS department_id_28, u0_.website_id AS website_id_29 FROM user u0_ WHERE (EXISTS (SELECT 1 FROM user_game u1_ WHERE u1_.user_id = u0_.id AND u1_.web_site_id IN (?)) AND u0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)) AND u0_.category IN ('USER', 'VIDEOGRAPHER') ORDER BY u0_.pseudo ASC"
  "params" => [
    1 => 1
    2 => 9932
    3 => 3491
    4 => 8738
    5 => 12760
    6 => 4125
    7 => 8599
    8 => 12102
    9 => 5971
    10 => 4006
    11 => 17567
    12 => 14026
    13 => 12065
    14 => 19991
    15 => 16811
    16 => 3262
    17 => 13611
    18 => 11628
    19 => 6377
    20 => 2428
    21 => 1
    22 => 8651
    23 => 4352
    24 => 4067
    25 => 11663
    26 => 6444
    27 => 12981
    28 => 6202
    29 => 15350
    30 => 6295
    31 => 9766
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1107
      +name: "INTEGER"
    }
    2 => Doctrine\DBAL\ParameterType {#1107}
    3 => Doctrine\DBAL\ParameterType {#1107}
    4 => Doctrine\DBAL\ParameterType {#1107}
    5 => Doctrine\DBAL\ParameterType {#1107}
    6 => Doctrine\DBAL\ParameterType {#1107}
    7 => Doctrine\DBAL\ParameterType {#1107}
    8 => Doctrine\DBAL\ParameterType {#1107}
    9 => Doctrine\DBAL\ParameterType {#1107}
    10 => Doctrine\DBAL\ParameterType {#1107}
    11 => Doctrine\DBAL\ParameterType {#1107}
    12 => Doctrine\DBAL\ParameterType {#1107}
    13 => Doctrine\DBAL\ParameterType {#1107}
    14 => Doctrine\DBAL\ParameterType {#1107}
    15 => Doctrine\DBAL\ParameterType {#1107}
    16 => Doctrine\DBAL\ParameterType {#1107}
    17 => Doctrine\DBAL\ParameterType {#1107}
    18 => Doctrine\DBAL\ParameterType {#1107}
    19 => Doctrine\DBAL\ParameterType {#1107}
    20 => Doctrine\DBAL\ParameterType {#1107}
    21 => Doctrine\DBAL\ParameterType {#1107}
    22 => Doctrine\DBAL\ParameterType {#1107}
    23 => Doctrine\DBAL\ParameterType {#1107}
    24 => Doctrine\DBAL\ParameterType {#1107}
    25 => Doctrine\DBAL\ParameterType {#1107}
    26 => Doctrine\DBAL\ParameterType {#1107}
    27 => Doctrine\DBAL\ParameterType {#1107}
    28 => Doctrine\DBAL\ParameterType {#1107}
    29 => Doctrine\DBAL\ParameterType {#1107}
    30 => Doctrine\DBAL\ParameterType {#1107}
    31 => Doctrine\DBAL\ParameterType {#1107}
  ]
]

[
  "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 {#1107
      +name: "INTEGER"
    }
  ]
]

[
  "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 {#1107
      +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 {#1107
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT t0.owner_id AS owner_id_1, t0.avatar_id AS avatar_id_2, t0.website_id AS website_id_3 FROM avatar_web_site t0 WHERE t0.owner_id = ? AND t0.website_id = ? LIMIT 1"
  "params" => [
    1 => 9932
    2 => 1
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1107
      +name: "INTEGER"
    }
    2 => Doctrine\DBAL\ParameterType {#1107}
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.name AS name_2, t0.unlocked AS unlocked_3, t0.slug AS slug_4, t0.slug_en AS slug_en_5, t0.displayed AS displayed_6, t0.rarity_id AS rarity_id_7, t0.groupment_id AS groupment_id_8, t0.website_id AS website_id_9 FROM avatar t0 WHERE t0.id = ?"
  "params" => [
    1 => 30
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1107
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.code AS code_2, t0.name AS name_3, t0.path AS path_4, t0.latitude AS latitude_5, t0.longitude AS longitude_6, t0.country_id AS country_id_7, t0.region_id AS region_id_8 FROM department t0 WHERE t0.id = ?"
  "params" => [
    1 => 59
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1107
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT COUNT(d0_.id) AS sclr_0 FROM deck d0_ WHERE d0_.creator_id = ? AND d0_.private = 0 AND d0_.invalid = 0 AND d0_.deleted = 0 AND d0_.website_id = ?"
  "params" => [
    1 => 9932
    2 => 1
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1107
      +name: "INTEGER"
    }
    2 => Doctrine\DBAL\ParameterType {#1107}
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.score AS score_2, t0.completion AS completion_3, t0.finished AS finished_4, t0.finish_date AS finish_date_5, t0.notified AS notified_6, t0.achievement_id AS achievement_id_7, t0.user_id AS user_id_8 FROM achievement_user t0 WHERE t0.user_id = ? ORDER BY t0.finish_date DESC"
  "params" => [
    1 => 9932
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1107
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT t0.owner_id AS owner_id_1, t0.avatar_id AS avatar_id_2, t0.website_id AS website_id_3 FROM avatar_web_site t0 WHERE t0.owner_id = ? AND t0.website_id = ? LIMIT 1"
  "params" => [
    1 => 3491
    2 => 1
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1107
      +name: "INTEGER"
    }
    2 => Doctrine\DBAL\ParameterType {#1107}
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.name AS name_2, t0.unlocked AS unlocked_3, t0.slug AS slug_4, t0.slug_en AS slug_en_5, t0.displayed AS displayed_6, t0.rarity_id AS rarity_id_7, t0.groupment_id AS groupment_id_8, t0.website_id AS website_id_9 FROM avatar t0 WHERE t0.id = ?"
  "params" => [
    1 => 124
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1107
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.code AS code_2, t0.name AS name_3, t0.path AS path_4, t0.latitude AS latitude_5, t0.longitude AS longitude_6, t0.country_id AS country_id_7, t0.region_id AS region_id_8 FROM department t0 WHERE t0.id = ?"
  "params" => [
    1 => 60
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1107
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT COUNT(d0_.id) AS sclr_0 FROM deck d0_ WHERE d0_.creator_id = ? AND d0_.private = 0 AND d0_.invalid = 0 AND d0_.deleted = 0 AND d0_.website_id = ?"
  "params" => [
    1 => 3491
    2 => 1
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1107
      +name: "INTEGER"
    }
    2 => Doctrine\DBAL\ParameterType {#1107}
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.score AS score_2, t0.completion AS completion_3, t0.finished AS finished_4, t0.finish_date AS finish_date_5, t0.notified AS notified_6, t0.achievement_id AS achievement_id_7, t0.user_id AS user_id_8 FROM achievement_user t0 WHERE t0.user_id = ? ORDER BY t0.finish_date DESC"
  "params" => [
    1 => 3491
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1107
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT t0.owner_id AS owner_id_1, t0.avatar_id AS avatar_id_2, t0.website_id AS website_id_3 FROM avatar_web_site t0 WHERE t0.owner_id = ? AND t0.website_id = ? LIMIT 1"
  "params" => [
    1 => 8738
    2 => 1
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1107
      +name: "INTEGER"
    }
    2 => Doctrine\DBAL\ParameterType {#1107}
  ]
]

[
  "sql" => "SELECT COUNT(d0_.id) AS sclr_0 FROM deck d0_ WHERE d0_.creator_id = ? AND d0_.private = 0 AND d0_.invalid = 0 AND d0_.deleted = 0 AND d0_.website_id = ?"
  "params" => [
    1 => 8738
    2 => 1
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1107
      +name: "INTEGER"
    }
    2 => Doctrine\DBAL\ParameterType {#1107}
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.score AS score_2, t0.completion AS completion_3, t0.finished AS finished_4, t0.finish_date AS finish_date_5, t0.notified AS notified_6, t0.achievement_id AS achievement_id_7, t0.user_id AS user_id_8 FROM achievement_user t0 WHERE t0.user_id = ? ORDER BY t0.finish_date DESC"
  "params" => [
    1 => 8738
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1107
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT t0.owner_id AS owner_id_1, t0.avatar_id AS avatar_id_2, t0.website_id AS website_id_3 FROM avatar_web_site t0 WHERE t0.owner_id = ? AND t0.website_id = ? LIMIT 1"
  "params" => [
    1 => 12760
    2 => 1
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1107
      +name: "INTEGER"
    }
    2 => Doctrine\DBAL\ParameterType {#1107}
  ]
]

[
  "sql" => "SELECT COUNT(d0_.id) AS sclr_0 FROM deck d0_ WHERE d0_.creator_id = ? AND d0_.private = 0 AND d0_.invalid = 0 AND d0_.deleted = 0 AND d0_.website_id = ?"
  "params" => [
    1 => 12760
    2 => 1
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1107
      +name: "INTEGER"
    }
    2 => Doctrine\DBAL\ParameterType {#1107}
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.score AS score_2, t0.completion AS completion_3, t0.finished AS finished_4, t0.finish_date AS finish_date_5, t0.notified AS notified_6, t0.achievement_id AS achievement_id_7, t0.user_id AS user_id_8 FROM achievement_user t0 WHERE t0.user_id = ? ORDER BY t0.finish_date DESC"
  "params" => [
    1 => 12760
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1107
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT t0.owner_id AS owner_id_1, t0.avatar_id AS avatar_id_2, t0.website_id AS website_id_3 FROM avatar_web_site t0 WHERE t0.owner_id = ? AND t0.website_id = ? LIMIT 1"
  "params" => [
    1 => 4125
    2 => 1
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1107
      +name: "INTEGER"
    }
    2 => Doctrine\DBAL\ParameterType {#1107}
  ]
]

[
  "sql" => "SELECT COUNT(d0_.id) AS sclr_0 FROM deck d0_ WHERE d0_.creator_id = ? AND d0_.private = 0 AND d0_.invalid = 0 AND d0_.deleted = 0 AND d0_.website_id = ?"
  "params" => [
    1 => 4125
    2 => 1
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1107
      +name: "INTEGER"
    }
    2 => Doctrine\DBAL\ParameterType {#1107}
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.score AS score_2, t0.completion AS completion_3, t0.finished AS finished_4, t0.finish_date AS finish_date_5, t0.notified AS notified_6, t0.achievement_id AS achievement_id_7, t0.user_id AS user_id_8 FROM achievement_user t0 WHERE t0.user_id = ? ORDER BY t0.finish_date DESC"
  "params" => [
    1 => 4125
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1107
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT t0.owner_id AS owner_id_1, t0.avatar_id AS avatar_id_2, t0.website_id AS website_id_3 FROM avatar_web_site t0 WHERE t0.owner_id = ? AND t0.website_id = ? LIMIT 1"
  "params" => [
    1 => 8599
    2 => 1
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1107
      +name: "INTEGER"
    }
    2 => Doctrine\DBAL\ParameterType {#1107}
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.code AS code_2, t0.name AS name_3, t0.path AS path_4, t0.latitude AS latitude_5, t0.longitude AS longitude_6, t0.country_id AS country_id_7, t0.region_id AS region_id_8 FROM department t0 WHERE t0.id = ?"
  "params" => [
    1 => 3
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1107
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT COUNT(d0_.id) AS sclr_0 FROM deck d0_ WHERE d0_.creator_id = ? AND d0_.private = 0 AND d0_.invalid = 0 AND d0_.deleted = 0 AND d0_.website_id = ?"
  "params" => [
    1 => 8599
    2 => 1
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1107
      +name: "INTEGER"
    }
    2 => Doctrine\DBAL\ParameterType {#1107}
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.score AS score_2, t0.completion AS completion_3, t0.finished AS finished_4, t0.finish_date AS finish_date_5, t0.notified AS notified_6, t0.achievement_id AS achievement_id_7, t0.user_id AS user_id_8 FROM achievement_user t0 WHERE t0.user_id = ? ORDER BY t0.finish_date DESC"
  "params" => [
    1 => 8599
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1107
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT t0.owner_id AS owner_id_1, t0.avatar_id AS avatar_id_2, t0.website_id AS website_id_3 FROM avatar_web_site t0 WHERE t0.owner_id = ? AND t0.website_id = ? LIMIT 1"
  "params" => [
    1 => 12102
    2 => 1
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1107
      +name: "INTEGER"
    }
    2 => Doctrine\DBAL\ParameterType {#1107}
  ]
]

[
  "sql" => "SELECT COUNT(d0_.id) AS sclr_0 FROM deck d0_ WHERE d0_.creator_id = ? AND d0_.private = 0 AND d0_.invalid = 0 AND d0_.deleted = 0 AND d0_.website_id = ?"
  "params" => [
    1 => 12102
    2 => 1
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1107
      +name: "INTEGER"
    }
    2 => Doctrine\DBAL\ParameterType {#1107}
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.score AS score_2, t0.completion AS completion_3, t0.finished AS finished_4, t0.finish_date AS finish_date_5, t0.notified AS notified_6, t0.achievement_id AS achievement_id_7, t0.user_id AS user_id_8 FROM achievement_user t0 WHERE t0.user_id = ? ORDER BY t0.finish_date DESC"
  "params" => [
    1 => 12102
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1107
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT t0.owner_id AS owner_id_1, t0.avatar_id AS avatar_id_2, t0.website_id AS website_id_3 FROM avatar_web_site t0 WHERE t0.owner_id = ? AND t0.website_id = ? LIMIT 1"
  "params" => [
    1 => 5971
    2 => 1
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1107
      +name: "INTEGER"
    }
    2 => Doctrine\DBAL\ParameterType {#1107}
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.name AS name_2, t0.unlocked AS unlocked_3, t0.slug AS slug_4, t0.slug_en AS slug_en_5, t0.displayed AS displayed_6, t0.rarity_id AS rarity_id_7, t0.groupment_id AS groupment_id_8, t0.website_id AS website_id_9 FROM avatar t0 WHERE t0.id = ?"
  "params" => [
    1 => 24
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1107
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.code AS code_2, t0.name AS name_3, t0.path AS path_4, t0.latitude AS latitude_5, t0.longitude AS longitude_6, t0.country_id AS country_id_7, t0.region_id AS region_id_8 FROM department t0 WHERE t0.id = ?"
  "params" => [
    1 => 54
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1107
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT COUNT(d0_.id) AS sclr_0 FROM deck d0_ WHERE d0_.creator_id = ? AND d0_.private = 0 AND d0_.invalid = 0 AND d0_.deleted = 0 AND d0_.website_id = ?"
  "params" => [
    1 => 5971
    2 => 1
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1107
      +name: "INTEGER"
    }
    2 => Doctrine\DBAL\ParameterType {#1107}
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.score AS score_2, t0.completion AS completion_3, t0.finished AS finished_4, t0.finish_date AS finish_date_5, t0.notified AS notified_6, t0.achievement_id AS achievement_id_7, t0.user_id AS user_id_8 FROM achievement_user t0 WHERE t0.user_id = ? ORDER BY t0.finish_date DESC"
  "params" => [
    1 => 5971
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1107
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT t0.owner_id AS owner_id_1, t0.avatar_id AS avatar_id_2, t0.website_id AS website_id_3 FROM avatar_web_site t0 WHERE t0.owner_id = ? AND t0.website_id = ? LIMIT 1"
  "params" => [
    1 => 4006
    2 => 1
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1107
      +name: "INTEGER"
    }
    2 => Doctrine\DBAL\ParameterType {#1107}
  ]
]

[
  "sql" => "SELECT COUNT(d0_.id) AS sclr_0 FROM deck d0_ WHERE d0_.creator_id = ? AND d0_.private = 0 AND d0_.invalid = 0 AND d0_.deleted = 0 AND d0_.website_id = ?"
  "params" => [
    1 => 4006
    2 => 1
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1107
      +name: "INTEGER"
    }
    2 => Doctrine\DBAL\ParameterType {#1107}
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.score AS score_2, t0.completion AS completion_3, t0.finished AS finished_4, t0.finish_date AS finish_date_5, t0.notified AS notified_6, t0.achievement_id AS achievement_id_7, t0.user_id AS user_id_8 FROM achievement_user t0 WHERE t0.user_id = ? ORDER BY t0.finish_date DESC"
  "params" => [
    1 => 4006
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1107
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT t0.owner_id AS owner_id_1, t0.avatar_id AS avatar_id_2, t0.website_id AS website_id_3 FROM avatar_web_site t0 WHERE t0.owner_id = ? AND t0.website_id = ? LIMIT 1"
  "params" => [
    1 => 17567
    2 => 1
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1107
      +name: "INTEGER"
    }
    2 => Doctrine\DBAL\ParameterType {#1107}
  ]
]

[
  "sql" => "SELECT COUNT(d0_.id) AS sclr_0 FROM deck d0_ WHERE d0_.creator_id = ? AND d0_.private = 0 AND d0_.invalid = 0 AND d0_.deleted = 0 AND d0_.website_id = ?"
  "params" => [
    1 => 17567
    2 => 1
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1107
      +name: "INTEGER"
    }
    2 => Doctrine\DBAL\ParameterType {#1107}
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.score AS score_2, t0.completion AS completion_3, t0.finished AS finished_4, t0.finish_date AS finish_date_5, t0.notified AS notified_6, t0.achievement_id AS achievement_id_7, t0.user_id AS user_id_8 FROM achievement_user t0 WHERE t0.user_id = ? ORDER BY t0.finish_date DESC"
  "params" => [
    1 => 17567
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1107
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT t0.owner_id AS owner_id_1, t0.avatar_id AS avatar_id_2, t0.website_id AS website_id_3 FROM avatar_web_site t0 WHERE t0.owner_id = ? AND t0.website_id = ? LIMIT 1"
  "params" => [
    1 => 14026
    2 => 1
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1107
      +name: "INTEGER"
    }
    2 => Doctrine\DBAL\ParameterType {#1107}
  ]
]

[
  "sql" => "SELECT COUNT(d0_.id) AS sclr_0 FROM deck d0_ WHERE d0_.creator_id = ? AND d0_.private = 0 AND d0_.invalid = 0 AND d0_.deleted = 0 AND d0_.website_id = ?"
  "params" => [
    1 => 14026
    2 => 1
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1107
      +name: "INTEGER"
    }
    2 => Doctrine\DBAL\ParameterType {#1107}
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.score AS score_2, t0.completion AS completion_3, t0.finished AS finished_4, t0.finish_date AS finish_date_5, t0.notified AS notified_6, t0.achievement_id AS achievement_id_7, t0.user_id AS user_id_8 FROM achievement_user t0 WHERE t0.user_id = ? ORDER BY t0.finish_date DESC"
  "params" => [
    1 => 14026
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1107
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT t0.owner_id AS owner_id_1, t0.avatar_id AS avatar_id_2, t0.website_id AS website_id_3 FROM avatar_web_site t0 WHERE t0.owner_id = ? AND t0.website_id = ? LIMIT 1"
  "params" => [
    1 => 12065
    2 => 1
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1107
      +name: "INTEGER"
    }
    2 => Doctrine\DBAL\ParameterType {#1107}
  ]
]

[
  "sql" => "SELECT COUNT(d0_.id) AS sclr_0 FROM deck d0_ WHERE d0_.creator_id = ? AND d0_.private = 0 AND d0_.invalid = 0 AND d0_.deleted = 0 AND d0_.website_id = ?"
  "params" => [
    1 => 12065
    2 => 1
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1107
      +name: "INTEGER"
    }
    2 => Doctrine\DBAL\ParameterType {#1107}
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.score AS score_2, t0.completion AS completion_3, t0.finished AS finished_4, t0.finish_date AS finish_date_5, t0.notified AS notified_6, t0.achievement_id AS achievement_id_7, t0.user_id AS user_id_8 FROM achievement_user t0 WHERE t0.user_id = ? ORDER BY t0.finish_date DESC"
  "params" => [
    1 => 12065
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1107
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT t0.owner_id AS owner_id_1, t0.avatar_id AS avatar_id_2, t0.website_id AS website_id_3 FROM avatar_web_site t0 WHERE t0.owner_id = ? AND t0.website_id = ? LIMIT 1"
  "params" => [
    1 => 19991
    2 => 1
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1107
      +name: "INTEGER"
    }
    2 => Doctrine\DBAL\ParameterType {#1107}
  ]
]

[
  "sql" => "SELECT COUNT(d0_.id) AS sclr_0 FROM deck d0_ WHERE d0_.creator_id = ? AND d0_.private = 0 AND d0_.invalid = 0 AND d0_.deleted = 0 AND d0_.website_id = ?"
  "params" => [
    1 => 19991
    2 => 1
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1107
      +name: "INTEGER"
    }
    2 => Doctrine\DBAL\ParameterType {#1107}
  ]
]