Symfony Profiler

[
  "route" => "competition"
  "route_parameters" => [
    "_route" => "competition"
    "_controller" => "App\Controller\CompetitionController::show"
    "id" => "572-bwbc-loisirs-mixtes-l4"
  ]
  "request_uri" => "http://beta.easyscore.be/competition/572-bwbc-loisirs-mixtes-l4"
  "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.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 => 572
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#675
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT g0_.id AS id_0, g0_.home_score AS home_score_1, g0_.away_score AS away_score_2, g0_.cancelled AS cancelled_3, g0_.forfeit AS forfeit_4, g0_.completed AS completed_5, g0_.phase_clubee_id AS phase_clubee_id_6, g0_.phase_name AS phase_name_7, g0_.updated_at AS updated_at_8, g0_.result_recorded_at AS result_recorded_at_9, g0_.detail_fetched_at AS detail_fetched_at_10, g0_.clubee_id AS clubee_id_11, g0_.starts_at AS starts_at_12, g0_.venue_name AS venue_name_13, g0_.venue_street AS venue_street_14, g0_.venue_city AS venue_city_15, g0_.venue_zip AS venue_zip_16, g0_.venue_country AS venue_country_17, g0_.venue_latitude AS venue_latitude_18, g0_.venue_longitude AS venue_longitude_19, t1_.id AS id_20, t1_.search_name AS search_name_21, t1_.subname AS subname_22, t1_.category AS category_23, t1_.gender AS gender_24, t1_.crest_url AS crest_url_25, t1_.name AS name_26, t1_.normalized_name AS normalized_name_27, t1_.clubee_id AS clubee_id_28, t2_.id AS id_29, t2_.search_name AS search_name_30, t2_.subname AS subname_31, t2_.category AS category_32, t2_.gender AS gender_33, t2_.crest_url AS crest_url_34, t2_.name AS name_35, t2_.normalized_name AS normalized_name_36, t2_.clubee_id AS clubee_id_37, c3_.id AS id_38, c3_.search_name AS search_name_39, c3_.gender AS gender_40, c3_.region AS region_41, c3_.category AS category_42, c3_.type AS type_43, c3_.active AS active_44, c3_.scanned_at AS scanned_at_45, c3_.name AS name_46, c3_.clubee_id AS clubee_id_47, g0_.home_team_id AS home_team_id_48, g0_.away_team_id AS away_team_id_49, g0_.competition_id AS competition_id_50, g0_.season_id AS season_id_51, t1_.club_id AS club_id_52, t2_.club_id AS club_id_53, c3_.season_id AS season_id_54 FROM "game" g0_ INNER JOIN "team" t1_ ON g0_.home_team_id = t1_.id INNER JOIN "team" t2_ ON g0_.away_team_id = t2_.id INNER JOIN "competition" c3_ ON g0_.competition_id = c3_.id WHERE g0_.competition_id = ? ORDER BY g0_.starts_at ASC"
  "params" => [
    1 => 572
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#675
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT r0_.id AS id_0, r0_.captured_at AS captured_at_1, r0_.hash AS hash_2, r0_.competition_id AS competition_id_3 FROM "ranking_snapshot" r0_ WHERE r0_.competition_id = ? ORDER BY r0_.captured_at DESC LIMIT 1"
  "params" => [
    1 => 572
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#675
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.clubee_id AS clubee_id_2, t0.name AS name_3 FROM "season" t0 WHERE t0.id = ?"
  "params" => [
    1 => 1
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#675
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.won AS won_2, t0.lost AS lost_3, t0.sets_won AS sets_won_4, t0.sets_lost AS sets_lost_5, t0.points_for AS points_for_6, t0.points_against AS points_against_7, t0.position AS position_8, t0.played AS played_9, t0.points AS points_10, t0.snapshot_id AS snapshot_id_11, t0.team_id AS team_id_12 FROM "ranking_entry" t0 WHERE t0.snapshot_id = ? ORDER BY t0.position ASC"
  "params" => [
    1 => 17
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#675
      +name: "INTEGER"
    }
  ]
]