Symfony Profiler

[
  "route" => "game"
  "route_parameters" => [
    "_route" => "game"
    "_controller" => "App\Controller\GameController::show"
    "id" => "1694-fh-nijlen-a-thuismakers-brabo-antwerp-vt-b"
  ]
  "request_uri" => "http://beta.easyscore.be/match/1694-fh-nijlen-a-thuismakers-brabo-antwerp-vt-b"
  "method" => "GET"
]

[
  "params" => [
    "driver" => "pdo_pgsql"
    "idle_connection_ttl" => 600
    "host" => "database"
    "port" => 5432
    "user" => "easyscore"
    "password" => "<redacted>"
    "driverOptions" => []
    "defaultTableOptions" => []
    "dbname" => "easyscore"
    "serverVersion" => "16"
    "charset" => "utf8"
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.home_score AS home_score_2, t0.away_score AS away_score_3, t0.cancelled AS cancelled_4, t0.forfeit AS forfeit_5, t0.completed AS completed_6, t0.phase_clubee_id AS phase_clubee_id_7, t0.phase_name AS phase_name_8, t0.updated_at AS updated_at_9, t0.result_recorded_at AS result_recorded_at_10, t0.detail_fetched_at AS detail_fetched_at_11, t0.clubee_id AS clubee_id_12, t0.starts_at AS starts_at_13, t0.venue_name AS venue_name_14, t0.venue_street AS venue_street_15, t0.venue_city AS venue_city_16, t0.venue_zip AS venue_zip_17, t0.venue_country AS venue_country_18, t0.venue_latitude AS venue_latitude_19, t0.venue_longitude AS venue_longitude_20, t0.home_team_id AS home_team_id_21, t0.away_team_id AS away_team_id_22, t0.competition_id AS competition_id_23, t0.season_id AS season_id_24 FROM "game" t0 WHERE t0.id = ?"
  "params" => [
    1 => 1694
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#851
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.search_name AS search_name_2, t0.subname AS subname_3, t0.category AS category_4, t0.gender AS gender_5, t0.crest_url AS crest_url_6, t0.name AS name_7, t0.normalized_name AS normalized_name_8, t0.clubee_id AS clubee_id_9, t0.club_id AS club_id_10 FROM "team" t0 WHERE t0.id = ?"
  "params" => [
    1 => 189
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#851
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.search_name AS search_name_2, t0.subname AS subname_3, t0.category AS category_4, t0.gender AS gender_5, t0.crest_url AS crest_url_6, t0.name AS name_7, t0.normalized_name AS normalized_name_8, t0.clubee_id AS clubee_id_9, t0.club_id AS club_id_10 FROM "team" t0 WHERE t0.id = ?"
  "params" => [
    1 => 187
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#851
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.home_run AS home_run_2, t0.away_run AS away_run_3, t0.number AS number_4, t0.home_points AS home_points_5, t0.away_points AS away_points_6, t0.game_id AS game_id_7 FROM "game_set" t0 WHERE t0.game_id = ? ORDER BY t0.number ASC"
  "params" => [
    1 => 1694
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#851
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.search_name AS search_name_2, t0.gender AS gender_3, t0.region AS region_4, t0.category AS category_5, t0.type AS type_6, t0.active AS active_7, t0.scanned_at AS scanned_at_8, t0.name AS name_9, t0.clubee_id AS clubee_id_10, t0.season_id AS season_id_11 FROM "competition" t0 WHERE t0.id = ?"
  "params" => [
    1 => 29
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#851
      +name: "INTEGER"
    }
  ]
]