Symfony Profiler

[
  "route" => "app_quiz_root"
  "route_parameters" => [
    "_route" => "app_quiz_root"
    "_controller" => "App\Controller\Quiz\RootController"
  ]
  "request_uri" => "https://tcgg-web-quiz.vps-f2c012e2.owl-labs.com/?font=inter&font-size=18"
  "method" => "GET"
]

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

[
  "params" => [
    "driver" => "pdo_mysql"
    "idle_connection_ttl" => 600
    "host" => "mariadb"
    "port" => 3306
    "user" => "app"
    "password" => "<redacted>"
    "driverOptions" => [
      12 => false
    ]
    "defaultTableOptions" => []
    "dbname" => "app"
    "serverVersion" => "10.11.15-MariaDB"
    "charset" => "utf8mb4"
  ]
]

[
  "sql" => "SELECT i0_.id AS id_0 FROM illustration i0_ INNER JOIN card_face c1_ ON i0_.preferred_card_face_id = c1_.id INNER JOIN card_print c2_ ON c1_.card_print_id = c2_.id INNER JOIN card_concept c3_ ON c2_.card_concept_id = c3_.id WHERE c2_.retired_at IS NULL GROUP BY i0_.id ORDER BY RAND() ASC LIMIT 1"
]

[
  "sql" => "SELECT DISTINCT i0_.id AS id_0, i0_.code AS code_1, i0_.preferred_card_face_reviewed_at AS preferred_card_face_reviewed_at_2, i0_.scryfall_illustration_id AS scryfall_illustration_id_3, i0_.is_available AS is_available_4, i0_.created_at AS created_at_5, i0_.updated_at AS updated_at_6, c1_.id AS id_7, c1_.face_index AS face_index_8, c1_.flavor_text AS flavor_text_9, c1_.type_line AS type_line_10, c1_.mana_cost AS mana_cost_11, c1_.colors_mask AS colors_mask_12, c1_.image_uris AS image_uris_13, c1_.image_source AS image_source_14, c1_.image_status AS image_status_15, c1_.val_hash AS val_hash_16, c1_.created_at AS created_at_17, c1_.updated_at AS updated_at_18, c2_.id AS id_19, c2_.code AS code_20, c2_.collector_number AS collector_number_21, c2_.rarity AS rarity_22, c2_.scryfall_card_id AS scryfall_card_id_23, c2_.content_warning AS content_warning_24, c2_.full_art AS full_art_25, c2_.textless AS textless_26, c2_.uris AS uris_27, c2_.released_at AS released_at_28, c2_.retired_at AS retired_at_29, c2_.val_hash AS val_hash_30, c2_.created_at AS created_at_31, c2_.updated_at AS updated_at_32, c3_.id AS id_33, c3_.code AS code_34, c3_.scryfall_oracle_id AS scryfall_oracle_id_35, c3_.name AS name_36, c3_.name_search AS name_search_37, c3_.layout AS layout_38, c3_.type_line AS type_line_39, c3_.color_identity_mask AS color_identity_mask_40, c3_.val_hash AS val_hash_41, c3_.created_at AS created_at_42, c3_.updated_at AS updated_at_43, i0_.preferred_card_face_id AS preferred_card_face_id_44, c1_.card_print_id AS card_print_id_45, c2_.card_concept_id AS card_concept_id_46, c2_.expansion_set_id AS expansion_set_id_47 FROM illustration i0_ INNER JOIN card_face c1_ ON i0_.preferred_card_face_id = c1_.id INNER JOIN card_print c2_ ON c1_.card_print_id = c2_.id INNER JOIN card_concept c3_ ON c2_.card_concept_id = c3_.id WHERE c2_.retired_at IS NULL AND i0_.id IN (?)"
  "params" => [
    1 => 44704
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#983
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT i0_.credited_name AS credited_name_0 FROM illustration_artist i0_ WHERE i0_.illustration_id = ? ORDER BY i0_.credit_order ASC LIMIT 1"
  "params" => [
    1 => 44704
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#983
      +name: "INTEGER"
    }
  ]
]