Symfony Profiler

[
  "route" => "app_homepage"
  "route_parameters" => [
    "_route" => "app_homepage"
    "_locale" => "sv"
    "_controller" => "App\Controller\HomepageController::index"
  ]
  "request_uri" => "https://devcodin.com/"
  "method" => "GET"
]

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

[
  "event" => "kernel.request"
  "listener" => "Symfony\Component\HttpKernel\EventListener\DebugHandlersListener::configure"
]

[
  "event" => "kernel.request"
  "listener" => "Symfony\Component\HttpKernel\EventListener\ValidateRequestListener::onKernelRequest"
]

[
  "event" => "kernel.request"
  "listener" => "Nelmio\CorsBundle\EventListener\CorsListener::onKernelRequest"
]

[
  "event" => "kernel.request"
  "listener" => "Symfony\Component\HttpKernel\EventListener\SessionListener::onKernelRequest"
]

[
  "event" => "kernel.request"
  "listener" => "Symfony\Component\HttpKernel\EventListener\LocaleListener::setDefaultLocale"
]

[
  "event" => "kernel.request"
  "listener" => "Symfony\Component\HttpKernel\EventListener\RouterListener::onKernelRequest"
]

[
  "event" => "kernel.request"
  "listener" => "ApiPlatform\Symfony\EventListener\AddFormatListener::onKernelRequest"
]

[
  "event" => "kernel.request"
  "listener" => "ApiPlatform\Symfony\EventListener\QueryParameterValidateListener::onKernelRequest"
]

[
  "event" => "kernel.request"
  "listener" => "Symfony\Component\HttpKernel\EventListener\LocaleListener::onKernelRequest"
]

[
  "event" => "kernel.request"
  "listener" => "Symfony\Component\HttpKernel\EventListener\LocaleAwareListener::onKernelRequest"
]

[
  "event" => "kernel.request"
  "listener" => "Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener::configureLogoutUrlGenerator"
]

[
  "event" => "kernel.request"
  "listener" => "Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener::onKernelRequest"
]

[
  "event" => "kernel.request"
  "listener" => "ApiPlatform\Symfony\EventListener\ReadListener::onKernelRequest"
]

[
  "event" => "kernel.request"
  "listener" => "ApiPlatform\Symfony\EventListener\DenyAccessListener::onSecurity"
]

[
  "event" => "kernel.request"
  "listener" => "ApiPlatform\Symfony\EventListener\DeserializeListener::onKernelRequest"
]

[
  "event" => "kernel.request"
  "listener" => "ApiPlatform\Symfony\EventListener\DenyAccessListener::onSecurityPostDenormalize"
]

[
  "event" => "kernel.request"
  "listener" => "ApiPlatform\Symfony\Bundle\EventListener\SwaggerUiListener::onKernelRequest"
]

[
  "event" => "kernel.controller"
  "listener" => "Symfony\Bundle\FrameworkBundle\DataCollector\RouterDataCollector::onKernelController"
]

[
  "event" => "kernel.controller"
  "listener" => "Symfony\Component\HttpKernel\DataCollector\RequestDataCollector::onKernelController"
]

[
  "event" => "kernel.controller_arguments"
  "listener" => "Symfony\Component\Security\Http\EventListener\IsGrantedAttributeListener::onKernelControllerArguments"
]

[
  "event" => "kernel.controller_arguments"
  "listener" => "Symfony\Component\HttpKernel\EventListener\CacheAttributeListener::onKernelControllerArguments"
]

[
  "event" => "kernel.controller_arguments"
  "listener" => "ContainerZ5Wx2x7\RequestPayloadValueResolverGhost3590451::onKernelControllerArguments"
]

[
  "event" => "kernel.controller_arguments"
  "listener" => "Symfony\Component\HttpKernel\EventListener\ErrorListener::onControllerArguments"
]

[
  "params" => [
    "driver" => "pdo_mysql"
    "host" => "localhost"
    "port" => 3306
    "user" => "allsvenskan_user"
    "password" => "<redacted>"
    "driverOptions" => []
    "defaultTableOptions" => []
    "dbname" => "allsvenskan"
    "serverVersion" => "5.5.68-MariaDB"
    "charset" => "utf8mb4"
  ]
]

[
  "sql" => "SELECT t0_.id AS id_0, t0_.uuid AS uuid_1, t0_.name AS name_2, t0_.start_date AS start_date_3, t0_.end_date AS end_date_4, t0_.competition_id AS competition_id_5 FROM tournament t0_ INNER JOIN competition c1_ ON t0_.competition_id = c1_.id AND (c1_.name = ? AND c1_.area = ?) INNER JOIN team t2_ ON t0_.id = t2_.tournament_id WHERE t0_.name NOT IN (?, ?, ?) ORDER BY t0_.start_date DESC"
  "params" => [
    1 => "Allsvenskan"
    2 => "SWE"
    3 => "2015"
    4 => "2016"
    5 => "2017"
  ]
  "types" => [
    1 => 2
    2 => 2
    3 => 2
    4 => 2
    5 => 2
  ]
]

[
  "sql" => "SELECT t0_.id AS id_0, t0_.uuid AS uuid_1, t0_.name AS name_2, t0_.start_date AS start_date_3, t0_.end_date AS end_date_4, t0_.competition_id AS competition_id_5 FROM tournament t0_ INNER JOIN competition c1_ ON t0_.competition_id = c1_.id AND (c1_.name = ? AND c1_.area = ?) WHERE t0_.name NOT IN (?, ?, ?) ORDER BY t0_.start_date DESC LIMIT 1"
  "params" => [
    1 => "Allsvenskan"
    2 => "SWE"
    3 => "2015"
    4 => "2016"
    5 => "2017"
  ]
  "types" => [
    1 => 2
    2 => 2
    3 => 2
    4 => 2
    5 => 2
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.uuid AS uuid_2, t0.name AS name_3, t0.area AS area_4 FROM competition t0 WHERE t0.id = ?"
  "params" => [
    1 => 1
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0_.id AS id_0, t0_.uuid AS uuid_1, t0_.name AS name_2, t0_.start_date AS start_date_3, t0_.end_date AS end_date_4, t0_.competition_id AS competition_id_5 FROM tournament t0_ INNER JOIN competition c1_ ON t0_.competition_id = c1_.id AND (c1_.name = ? AND c1_.area = ?) INNER JOIN team t2_ ON t0_.id = t2_.tournament_id WHERE t0_.name NOT IN (?, ?, ?) ORDER BY t0_.start_date DESC"
  "params" => [
    1 => "Allsvenskan"
    2 => "SWE"
    3 => "2015"
    4 => "2016"
    5 => "2017"
  ]
  "types" => [
    1 => 2
    2 => 2
    3 => 2
    4 => 2
    5 => 2
  ]
]

[
  "sql" => "SELECT t0_.id AS id_0, t0_.uuid AS uuid_1, t0_.name AS name_2, t0_.start_date AS start_date_3, t0_.end_date AS end_date_4, t0_.competition_id AS competition_id_5 FROM tournament t0_ INNER JOIN competition c1_ ON t0_.competition_id = c1_.id AND (c1_.name = ? AND c1_.area = ?) WHERE t0_.name NOT IN (?, ?, ?) ORDER BY t0_.start_date DESC LIMIT 1"
  "params" => [
    1 => "Allsvenskan"
    2 => "SWE"
    3 => "2015"
    4 => "2016"
    5 => "2017"
  ]
  "types" => [
    1 => 2
    2 => 2
    3 => 2
    4 => 2
    5 => 2
  ]
]

[
  "sql" => "SELECT t0_.id AS id_0, t0_.uuid AS uuid_1, t0_.name AS name_2, t0_.start_date AS start_date_3, t0_.end_date AS end_date_4, t0_.competition_id AS competition_id_5 FROM tournament t0_ INNER JOIN competition c1_ ON t0_.competition_id = c1_.id AND (c1_.name = ? AND c1_.area = ?) WHERE t0_.name NOT IN (?, ?, ?) ORDER BY t0_.start_date DESC LIMIT 1"
  "params" => [
    1 => "Allsvenskan"
    2 => "SWE"
    3 => "2015"
    4 => "2016"
    5 => "2017"
  ]
  "types" => [
    1 => 2
    2 => 2
    3 => 2
    4 => 2
    5 => 2
  ]
]

[
  "sql" => "SELECT v0_.id AS id_0, v0_.position AS position_1, v0_.team AS team_2, v0_.team_logo AS team_logo_3, v0_.games_matches AS games_matches_4, v0_.won AS won_5, v0_.tied_draw AS tied_draw_6, v0_.lost AS lost_7, v0_.goals_scored AS goals_scored_8, v0_.goals_conceded AS goals_conceded_9, v0_.points AS points_10, v0_.tournament_id AS tournament_id_11 FROM view_ttat01 v0_ WHERE v0_.tournament_id = ? ORDER BY v0_.position ASC"
  "params" => [
    1 => 6
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0_.id AS id_0, t0_.uuid AS uuid_1, t0_.name AS name_2, t0_.start_date AS start_date_3, t0_.end_date AS end_date_4, t0_.competition_id AS competition_id_5 FROM tournament t0_ INNER JOIN competition c1_ ON t0_.competition_id = c1_.id AND (c1_.name = ? AND c1_.area = ?) INNER JOIN team t2_ ON t0_.id = t2_.tournament_id WHERE t0_.name NOT IN (?, ?, ?) ORDER BY t0_.start_date DESC"
  "params" => [
    1 => "Allsvenskan"
    2 => "SWE"
    3 => "2015"
    4 => "2016"
    5 => "2017"
  ]
  "types" => [
    1 => 2
    2 => 2
    3 => 2
    4 => 2
    5 => 2
  ]
]

[
  "sql" => "SELECT t0_.id AS id_0, t0_.uuid AS uuid_1, t0_.name AS name_2, t0_.start_date AS start_date_3, t0_.end_date AS end_date_4, t0_.competition_id AS competition_id_5 FROM tournament t0_ INNER JOIN competition c1_ ON t0_.competition_id = c1_.id AND (c1_.name = ? AND c1_.area = ?) WHERE t0_.name NOT IN (?, ?, ?) ORDER BY t0_.start_date DESC LIMIT 1"
  "params" => [
    1 => "Allsvenskan"
    2 => "SWE"
    3 => "2015"
    4 => "2016"
    5 => "2017"
  ]
  "types" => [
    1 => 2
    2 => 2
    3 => 2
    4 => 2
    5 => 2
  ]
]

[
  "sql" => "SELECT t0_.id AS id_0, t0_.uuid AS uuid_1, t0_.name AS name_2, t0_.start_date AS start_date_3, t0_.end_date AS end_date_4, t0_.competition_id AS competition_id_5 FROM tournament t0_ INNER JOIN competition c1_ ON t0_.competition_id = c1_.id AND (c1_.name = ? AND c1_.area = ?) WHERE t0_.name NOT IN (?, ?, ?) ORDER BY t0_.start_date DESC LIMIT 1"
  "params" => [
    1 => "Allsvenskan"
    2 => "SWE"
    3 => "2015"
    4 => "2016"
    5 => "2017"
  ]
  "types" => [
    1 => 2
    2 => 2
    3 => 2
    4 => 2
    5 => 2
  ]
]

[
  "sql" => "SELECT v0_.id AS id_0, v0_.position AS position_1, v0_.team AS team_2, v0_.team_logo AS team_logo_3, v0_.games_matches AS games_matches_4, v0_.won AS won_5, v0_.tied_draw AS tied_draw_6, v0_.lost AS lost_7, v0_.goals_scored AS goals_scored_8, v0_.goals_conceded AS goals_conceded_9, v0_.points AS points_10, v0_.tournament_id AS tournament_id_11 FROM view_ttaht01 v0_ WHERE v0_.tournament_id = ? ORDER BY v0_.points DESC, v0_.goals_scored - v0_.goals_conceded DESC, v0_.games_matches DESC, v0_.won DESC, v0_.tied_draw DESC, v0_.lost DESC, v0_.goals_conceded DESC, v0_.team ASC"
  "params" => [
    1 => 6
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0_.id AS id_0, t0_.uuid AS uuid_1, t0_.name AS name_2, t0_.start_date AS start_date_3, t0_.end_date AS end_date_4, t0_.competition_id AS competition_id_5 FROM tournament t0_ INNER JOIN competition c1_ ON t0_.competition_id = c1_.id AND (c1_.name = ? AND c1_.area = ?) INNER JOIN team t2_ ON t0_.id = t2_.tournament_id WHERE t0_.name NOT IN (?, ?, ?) ORDER BY t0_.start_date DESC"
  "params" => [
    1 => "Allsvenskan"
    2 => "SWE"
    3 => "2015"
    4 => "2016"
    5 => "2017"
  ]
  "types" => [
    1 => 2
    2 => 2
    3 => 2
    4 => 2
    5 => 2
  ]
]

[
  "sql" => "SELECT t0_.id AS id_0, t0_.uuid AS uuid_1, t0_.name AS name_2, t0_.start_date AS start_date_3, t0_.end_date AS end_date_4, t0_.competition_id AS competition_id_5 FROM tournament t0_ INNER JOIN competition c1_ ON t0_.competition_id = c1_.id AND (c1_.name = ? AND c1_.area = ?) WHERE t0_.name NOT IN (?, ?, ?) ORDER BY t0_.start_date DESC LIMIT 1"
  "params" => [
    1 => "Allsvenskan"
    2 => "SWE"
    3 => "2015"
    4 => "2016"
    5 => "2017"
  ]
  "types" => [
    1 => 2
    2 => 2
    3 => 2
    4 => 2
    5 => 2
  ]
]

[
  "sql" => "SELECT t0_.id AS id_0, t0_.uuid AS uuid_1, t0_.name AS name_2, t0_.start_date AS start_date_3, t0_.end_date AS end_date_4, t0_.competition_id AS competition_id_5 FROM tournament t0_ INNER JOIN competition c1_ ON t0_.competition_id = c1_.id AND (c1_.name = ? AND c1_.area = ?) WHERE t0_.name NOT IN (?, ?, ?) ORDER BY t0_.start_date DESC LIMIT 1"
  "params" => [
    1 => "Allsvenskan"
    2 => "SWE"
    3 => "2015"
    4 => "2016"
    5 => "2017"
  ]
  "types" => [
    1 => 2
    2 => 2
    3 => 2
    4 => 2
    5 => 2
  ]
]

[
  "sql" => "SELECT v0_.id AS id_0, v0_.position AS position_1, v0_.team AS team_2, v0_.team_logo AS team_logo_3, v0_.games_matches AS games_matches_4, v0_.won AS won_5, v0_.tied_draw AS tied_draw_6, v0_.lost AS lost_7, v0_.goals_scored AS goals_scored_8, v0_.goals_conceded AS goals_conceded_9, v0_.points AS points_10, v0_.tournament_id AS tournament_id_11 FROM view_ttabt01 v0_ WHERE v0_.tournament_id = ? ORDER BY v0_.points DESC, v0_.goals_scored - v0_.goals_conceded DESC, v0_.games_matches DESC, v0_.won DESC, v0_.tied_draw DESC, v0_.lost DESC, v0_.goals_conceded DESC, v0_.team ASC"
  "params" => [
    1 => 6
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0_.id AS id_0, t0_.uuid AS uuid_1, t0_.name AS name_2, t0_.start_date AS start_date_3, t0_.end_date AS end_date_4, t0_.competition_id AS competition_id_5 FROM tournament t0_ INNER JOIN competition c1_ ON t0_.competition_id = c1_.id AND (c1_.name = ? AND c1_.area = ?) INNER JOIN team t2_ ON t0_.id = t2_.tournament_id WHERE t0_.name NOT IN (?, ?, ?) ORDER BY t0_.start_date DESC"
  "params" => [
    1 => "Allsvenskan"
    2 => "SWE"
    3 => "2015"
    4 => "2016"
    5 => "2017"
  ]
  "types" => [
    1 => 2
    2 => 2
    3 => 2
    4 => 2
    5 => 2
  ]
]

[
  "sql" => "SELECT t0_.id AS id_0, t0_.uuid AS uuid_1, t0_.name AS name_2, t0_.start_date AS start_date_3, t0_.end_date AS end_date_4, t0_.competition_id AS competition_id_5 FROM tournament t0_ INNER JOIN competition c1_ ON t0_.competition_id = c1_.id AND (c1_.name = ? AND c1_.area = ?) WHERE t0_.name NOT IN (?, ?, ?) ORDER BY t0_.start_date DESC LIMIT 1"
  "params" => [
    1 => "Allsvenskan"
    2 => "SWE"
    3 => "2015"
    4 => "2016"
    5 => "2017"
  ]
  "types" => [
    1 => 2
    2 => 2
    3 => 2
    4 => 2
    5 => 2
  ]
]

[
  "sql" => "SELECT t0_.id AS id_0, t0_.uuid AS uuid_1, t0_.name AS name_2, t0_.start_date AS start_date_3, t0_.end_date AS end_date_4, t0_.competition_id AS competition_id_5 FROM tournament t0_ INNER JOIN competition c1_ ON t0_.competition_id = c1_.id AND (c1_.name = ? AND c1_.area = ?) WHERE t0_.name NOT IN (?, ?, ?) ORDER BY t0_.start_date DESC LIMIT 1"
  "params" => [
    1 => "Allsvenskan"
    2 => "SWE"
    3 => "2015"
    4 => "2016"
    5 => "2017"
  ]
  "types" => [
    1 => 2
    2 => 2
    3 => 2
    4 => 2
    5 => 2
  ]
]

[
  "sql" => "SELECT v0_.id AS id_0, v0_.team AS team_1, v0_.team_logo AS team_logo_2, v0_.games_matches AS games_matches_3, v0_.won AS won_4, v0_.tied_draw AS tied_draw_5, v0_.lost AS lost_6, v0_.goals_scored AS goals_scored_7, v0_.goals_conceded AS goals_conceded_8, v0_.points AS points_9, v0_.ordinary_position AS ordinary_position_10, v0_.tournament_id AS tournament_id_11 FROM view_ttatxg01 v0_ WHERE v0_.tournament_id = ? ORDER BY v0_.points DESC, v0_.goals_scored - v0_.goals_conceded DESC, v0_.won DESC, v0_.goals_scored ASC, v0_.team ASC"
  "params" => [
    1 => 6
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0_.id AS id_0, t0_.uuid AS uuid_1, t0_.name AS name_2, t0_.start_date AS start_date_3, t0_.end_date AS end_date_4, t0_.competition_id AS competition_id_5 FROM tournament t0_ INNER JOIN competition c1_ ON t0_.competition_id = c1_.id AND (c1_.name = ? AND c1_.area = ?) INNER JOIN team t2_ ON t0_.id = t2_.tournament_id WHERE t0_.name NOT IN (?, ?, ?) ORDER BY t0_.start_date DESC"
  "params" => [
    1 => "Allsvenskan"
    2 => "SWE"
    3 => "2015"
    4 => "2016"
    5 => "2017"
  ]
  "types" => [
    1 => 2
    2 => 2
    3 => 2
    4 => 2
    5 => 2
  ]
]

[
  "sql" => "SELECT t0_.id AS id_0, t0_.uuid AS uuid_1, t0_.name AS name_2, t0_.start_date AS start_date_3, t0_.end_date AS end_date_4, t0_.competition_id AS competition_id_5 FROM tournament t0_ INNER JOIN competition c1_ ON t0_.competition_id = c1_.id AND (c1_.name = ? AND c1_.area = ?) WHERE t0_.name NOT IN (?, ?, ?) ORDER BY t0_.start_date DESC LIMIT 1"
  "params" => [
    1 => "Allsvenskan"
    2 => "SWE"
    3 => "2015"
    4 => "2016"
    5 => "2017"
  ]
  "types" => [
    1 => 2
    2 => 2
    3 => 2
    4 => 2
    5 => 2
  ]
]

[
  "sql" => "SELECT t0_.id AS id_0, t0_.uuid AS uuid_1, t0_.name AS name_2, t0_.start_date AS start_date_3, t0_.end_date AS end_date_4, t0_.competition_id AS competition_id_5 FROM tournament t0_ INNER JOIN competition c1_ ON t0_.competition_id = c1_.id AND (c1_.name = ? AND c1_.area = ?) WHERE t0_.name NOT IN (?, ?, ?) ORDER BY t0_.start_date DESC LIMIT 1"
  "params" => [
    1 => "Allsvenskan"
    2 => "SWE"
    3 => "2015"
    4 => "2016"
    5 => "2017"
  ]
  "types" => [
    1 => 2
    2 => 2
    3 => 2
    4 => 2
    5 => 2
  ]
]

[
  "sql" => "SELECT v0_.id AS id_0, v0_.team AS team_1, v0_.team_logo AS team_logo_2, v0_.chances_created AS chances_created_3, v0_.matches_played AS matches_played_4, v0_.goals_scored AS goals_scored_5, v0_.goals_concieved AS goals_concieved_6, v0_.chances_created_against AS chances_created_against_7, v0_.chanses90 AS chanses90_8, v0_.tournament_id AS tournament_id_9 FROM view_ttsm01 v0_ WHERE v0_.tournament_id = ? ORDER BY v0_.chanses90 DESC, v0_.matches_played DESC, v0_.goals_scored DESC, v0_.chances_created DESC, v0_.goals_concieved DESC, v0_.chances_created_against DESC, v0_.team ASC"
  "params" => [
    1 => 6
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0_.id AS id_0, t0_.uuid AS uuid_1, t0_.name AS name_2, t0_.start_date AS start_date_3, t0_.end_date AS end_date_4, t0_.competition_id AS competition_id_5 FROM tournament t0_ INNER JOIN competition c1_ ON t0_.competition_id = c1_.id AND (c1_.name = ? AND c1_.area = ?) INNER JOIN team t2_ ON t0_.id = t2_.tournament_id WHERE t0_.name NOT IN (?, ?, ?) ORDER BY t0_.start_date DESC"
  "params" => [
    1 => "Allsvenskan"
    2 => "SWE"
    3 => "2015"
    4 => "2016"
    5 => "2017"
  ]
  "types" => [
    1 => 2
    2 => 2
    3 => 2
    4 => 2
    5 => 2
  ]
]

[
  "sql" => "SELECT t0_.id AS id_0, t0_.uuid AS uuid_1, t0_.name AS name_2, t0_.start_date AS start_date_3, t0_.end_date AS end_date_4, t0_.competition_id AS competition_id_5 FROM tournament t0_ INNER JOIN competition c1_ ON t0_.competition_id = c1_.id AND (c1_.name = ? AND c1_.area = ?) WHERE t0_.name NOT IN (?, ?, ?) ORDER BY t0_.start_date DESC LIMIT 1"
  "params" => [
    1 => "Allsvenskan"
    2 => "SWE"
    3 => "2015"
    4 => "2016"
    5 => "2017"
  ]
  "types" => [
    1 => 2
    2 => 2
    3 => 2
    4 => 2
    5 => 2
  ]
]

[
  "sql" => "SELECT t0_.id AS id_0, t0_.uuid AS uuid_1, t0_.name AS name_2, t0_.start_date AS start_date_3, t0_.end_date AS end_date_4, t0_.competition_id AS competition_id_5 FROM tournament t0_ INNER JOIN competition c1_ ON t0_.competition_id = c1_.id AND (c1_.name = ? AND c1_.area = ?) WHERE t0_.name NOT IN (?, ?, ?) ORDER BY t0_.start_date DESC LIMIT 1"
  "params" => [
    1 => "Allsvenskan"
    2 => "SWE"
    3 => "2015"
    4 => "2016"
    5 => "2017"
  ]
  "types" => [
    1 => 2
    2 => 2
    3 => 2
    4 => 2
    5 => 2
  ]
]

[
  "sql" => "SELECT v0_.id AS id_0, v0_.team AS team_1, v0_.team_logo AS team_logo_2, v0_.matches_played AS matches_played_3, v0_.goals_scored AS goals_scored_4, v0_.shots AS shots_5, v0_.shots_on_goal AS shots_on_goal_6, v0_.shots_on_goal90 AS shots_on_goal90_7, v0_.tournament_id AS tournament_id_8 FROM view_ttspm01 v0_ WHERE v0_.tournament_id = ? ORDER BY v0_.shots_on_goal90 DESC, v0_.matches_played DESC, v0_.goals_scored DESC, v0_.shots DESC, v0_.shots_on_goal DESC, v0_.team ASC"
  "params" => [
    1 => 6
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0_.id AS id_0, t0_.uuid AS uuid_1, t0_.name AS name_2, t0_.start_date AS start_date_3, t0_.end_date AS end_date_4, t0_.competition_id AS competition_id_5 FROM tournament t0_ INNER JOIN competition c1_ ON t0_.competition_id = c1_.id AND (c1_.name = ? AND c1_.area = ?) INNER JOIN team t2_ ON t0_.id = t2_.tournament_id WHERE t0_.name NOT IN (?, ?, ?) ORDER BY t0_.start_date DESC"
  "params" => [
    1 => "Allsvenskan"
    2 => "SWE"
    3 => "2015"
    4 => "2016"
    5 => "2017"
  ]
  "types" => [
    1 => 2
    2 => 2
    3 => 2
    4 => 2
    5 => 2
  ]
]

[
  "sql" => "SELECT t0_.id AS id_0, t0_.uuid AS uuid_1, t0_.name AS name_2, t0_.start_date AS start_date_3, t0_.end_date AS end_date_4, t0_.competition_id AS competition_id_5 FROM tournament t0_ INNER JOIN competition c1_ ON t0_.competition_id = c1_.id AND (c1_.name = ? AND c1_.area = ?) WHERE t0_.name NOT IN (?, ?, ?) ORDER BY t0_.start_date DESC LIMIT 1"
  "params" => [
    1 => "Allsvenskan"
    2 => "SWE"
    3 => "2015"
    4 => "2016"
    5 => "2017"
  ]
  "types" => [
    1 => 2
    2 => 2
    3 => 2
    4 => 2
    5 => 2
  ]
]

[
  "sql" => "SELECT t0_.id AS id_0, t0_.uuid AS uuid_1, t0_.name AS name_2, t0_.start_date AS start_date_3, t0_.end_date AS end_date_4, t0_.competition_id AS competition_id_5 FROM tournament t0_ INNER JOIN competition c1_ ON t0_.competition_id = c1_.id AND (c1_.name = ? AND c1_.area = ?) WHERE t0_.name NOT IN (?, ?, ?) ORDER BY t0_.start_date DESC LIMIT 1"
  "params" => [
    1 => "Allsvenskan"
    2 => "SWE"
    3 => "2015"
    4 => "2016"
    5 => "2017"
  ]
  "types" => [
    1 => 2
    2 => 2
    3 => 2
    4 => 2
    5 => 2
  ]
]

[
  "sql" => "SELECT v0_.id AS id_0, v0_.team AS team_1, v0_.team_logo AS team_logo_2, v0_.goals AS goals_3, v0_.shots AS shots_4, v0_.goals_per_shot AS goals_per_shot_5, v0_.matches_played AS matches_played_6, v0_.shots_on_goal AS shots_on_goal_7, v0_.tournament_id AS tournament_id_8 FROM view_ttkg01 v0_ WHERE v0_.tournament_id = ? ORDER BY v0_.goals_per_shot DESC, v0_.matches_played DESC, v0_.goals DESC, v0_.shots DESC, v0_.shots_on_goal DESC, v0_.team ASC"
  "params" => [
    1 => 6
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0_.id AS id_0, t0_.uuid AS uuid_1, t0_.name AS name_2, t0_.start_date AS start_date_3, t0_.end_date AS end_date_4, t0_.competition_id AS competition_id_5 FROM tournament t0_ INNER JOIN competition c1_ ON t0_.competition_id = c1_.id AND (c1_.name = ? AND c1_.area = ?) INNER JOIN team t2_ ON t0_.id = t2_.tournament_id WHERE t0_.name NOT IN (?, ?, ?) ORDER BY t0_.start_date DESC"
  "params" => [
    1 => "Allsvenskan"
    2 => "SWE"
    3 => "2015"
    4 => "2016"
    5 => "2017"
  ]
  "types" => [
    1 => 2
    2 => 2
    3 => 2
    4 => 2
    5 => 2
  ]
]

[
  "sql" => "SELECT t0_.id AS id_0, t0_.uuid AS uuid_1, t0_.name AS name_2, t0_.start_date AS start_date_3, t0_.end_date AS end_date_4, t0_.competition_id AS competition_id_5 FROM tournament t0_ INNER JOIN competition c1_ ON t0_.competition_id = c1_.id AND (c1_.name = ? AND c1_.area = ?) WHERE t0_.name NOT IN (?, ?, ?) ORDER BY t0_.start_date DESC LIMIT 1"
  "params" => [
    1 => "Allsvenskan"
    2 => "SWE"
    3 => "2015"
    4 => "2016"
    5 => "2017"
  ]
  "types" => [
    1 => 2
    2 => 2
    3 => 2
    4 => 2
    5 => 2
  ]
]

[
  "sql" => "SELECT t0_.id AS id_0, t0_.uuid AS uuid_1, t0_.name AS name_2, t0_.start_date AS start_date_3, t0_.end_date AS end_date_4, t0_.competition_id AS competition_id_5 FROM tournament t0_ INNER JOIN competition c1_ ON t0_.competition_id = c1_.id AND (c1_.name = ? AND c1_.area = ?) WHERE t0_.name NOT IN (?, ?, ?) ORDER BY t0_.start_date DESC LIMIT 1"
  "params" => [
    1 => "Allsvenskan"
    2 => "SWE"
    3 => "2015"
    4 => "2016"
    5 => "2017"
  ]
  "types" => [
    1 => 2
    2 => 2
    3 => 2
    4 => 2
    5 => 2
  ]
]

[
  "sql" => "SELECT v0_.id AS id_0, v0_.team AS team_1, v0_.team_logo AS team_logo_2, v0_.passes AS passes_3, v0_.successfull_passes AS successfull_passes_4, v0_.pass_percentage AS pass_percentage_5, v0_.matches_played AS matches_played_6, v0_.tournament_id AS tournament_id_7 FROM view_ttppp01 v0_ WHERE v0_.tournament_id = ? ORDER BY v0_.pass_percentage DESC, v0_.matches_played DESC, v0_.passes DESC, v0_.successfull_passes DESC, v0_.team ASC"
  "params" => [
    1 => 6
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0_.id AS id_0, t0_.uuid AS uuid_1, t0_.name AS name_2, t0_.start_date AS start_date_3, t0_.end_date AS end_date_4, t0_.competition_id AS competition_id_5 FROM tournament t0_ INNER JOIN competition c1_ ON t0_.competition_id = c1_.id AND (c1_.name = ? AND c1_.area = ?) INNER JOIN team t2_ ON t0_.id = t2_.tournament_id WHERE t0_.name NOT IN (?, ?, ?) ORDER BY t0_.start_date DESC"
  "params" => [
    1 => "Allsvenskan"
    2 => "SWE"
    3 => "2015"
    4 => "2016"
    5 => "2017"
  ]
  "types" => [
    1 => 2
    2 => 2
    3 => 2
    4 => 2
    5 => 2
  ]
]

[
  "sql" => "SELECT t0_.id AS id_0, t0_.uuid AS uuid_1, t0_.name AS name_2, t0_.start_date AS start_date_3, t0_.end_date AS end_date_4, t0_.competition_id AS competition_id_5 FROM tournament t0_ INNER JOIN competition c1_ ON t0_.competition_id = c1_.id AND (c1_.name = ? AND c1_.area = ?) WHERE t0_.name NOT IN (?, ?, ?) ORDER BY t0_.start_date DESC LIMIT 1"
  "params" => [
    1 => "Allsvenskan"
    2 => "SWE"
    3 => "2015"
    4 => "2016"
    5 => "2017"
  ]
  "types" => [
    1 => 2
    2 => 2
    3 => 2
    4 => 2
    5 => 2
  ]
]

[
  "sql" => "SELECT t0_.id AS id_0, t0_.uuid AS uuid_1, t0_.name AS name_2, t0_.start_date AS start_date_3, t0_.end_date AS end_date_4, t0_.competition_id AS competition_id_5 FROM tournament t0_ INNER JOIN competition c1_ ON t0_.competition_id = c1_.id AND (c1_.name = ? AND c1_.area = ?) WHERE t0_.name NOT IN (?, ?, ?) ORDER BY t0_.start_date DESC LIMIT 1"
  "params" => [
    1 => "Allsvenskan"
    2 => "SWE"
    3 => "2015"
    4 => "2016"
    5 => "2017"
  ]
  "types" => [
    1 => 2
    2 => 2
    3 => 2
    4 => 2
    5 => 2
  ]
]

[
  "sql" => "SELECT v0_.id AS id_0, v0_.team AS team_1, v0_.team_logo AS team_logo_2, v0_.matches_played AS matches_played_3, v0_.passes AS passes_4, v0_.key_passes AS key_passes_5, v0_.key_passes90 AS key_passes90_6, v0_.tournament_id AS tournament_id_7 FROM view_ttnp01 v0_ WHERE v0_.tournament_id = ? ORDER BY v0_.key_passes90 DESC, v0_.matches_played DESC, v0_.passes DESC, v0_.key_passes DESC, v0_.team ASC"
  "params" => [
    1 => 6
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0_.id AS id_0, t0_.uuid AS uuid_1, t0_.name AS name_2, t0_.start_date AS start_date_3, t0_.end_date AS end_date_4, t0_.competition_id AS competition_id_5 FROM tournament t0_ INNER JOIN competition c1_ ON t0_.competition_id = c1_.id AND (c1_.name = ? AND c1_.area = ?) INNER JOIN team t2_ ON t0_.id = t2_.tournament_id WHERE t0_.name NOT IN (?, ?, ?) ORDER BY t0_.start_date DESC"
  "params" => [
    1 => "Allsvenskan"
    2 => "SWE"
    3 => "2015"
    4 => "2016"
    5 => "2017"
  ]
  "types" => [
    1 => 2
    2 => 2
    3 => 2
    4 => 2
    5 => 2
  ]
]

[
  "sql" => "SELECT t0_.id AS id_0, t0_.uuid AS uuid_1, t0_.name AS name_2, t0_.start_date AS start_date_3, t0_.end_date AS end_date_4, t0_.competition_id AS competition_id_5 FROM tournament t0_ INNER JOIN competition c1_ ON t0_.competition_id = c1_.id AND (c1_.name = ? AND c1_.area = ?) WHERE t0_.name NOT IN (?, ?, ?) ORDER BY t0_.start_date DESC LIMIT 1"
  "params" => [
    1 => "Allsvenskan"
    2 => "SWE"
    3 => "2015"
    4 => "2016"
    5 => "2017"
  ]
  "types" => [
    1 => 2
    2 => 2
    3 => 2
    4 => 2
    5 => 2
  ]
]

[
  "sql" => "SELECT t0_.id AS id_0, t0_.uuid AS uuid_1, t0_.name AS name_2, t0_.start_date AS start_date_3, t0_.end_date AS end_date_4, t0_.competition_id AS competition_id_5 FROM tournament t0_ INNER JOIN competition c1_ ON t0_.competition_id = c1_.id AND (c1_.name = ? AND c1_.area = ?) WHERE t0_.name NOT IN (?, ?, ?) ORDER BY t0_.start_date DESC LIMIT 1"
  "params" => [
    1 => "Allsvenskan"
    2 => "SWE"
    3 => "2015"
    4 => "2016"
    5 => "2017"
  ]
  "types" => [
    1 => 2
    2 => 2
    3 => 2
    4 => 2
    5 => 2
  ]
]

[
  "sql" => "SELECT v0_.id AS id_0, v0_.team AS team_1, v0_.team_logo AS team_logo_2, v0_.matches_played AS matches_played_3, v0_.passes AS passes_4, v0_.smart_passes AS smart_passes_5, v0_.progressive_passes AS progressive_passes_6, v0_.smart_progressive_passes AS smart_progressive_passes_7, v0_.smart_progressive_passes90 AS smart_progressive_passes90_8, v0_.tournament_id AS tournament_id_9 FROM view_ttspp01 v0_ WHERE v0_.tournament_id = ? ORDER BY v0_.smart_progressive_passes90 DESC, v0_.matches_played DESC, v0_.passes DESC, v0_.smart_passes DESC, v0_.progressive_passes DESC, v0_.smart_progressive_passes DESC, v0_.team ASC"
  "params" => [
    1 => 6
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0_.id AS id_0, t0_.uuid AS uuid_1, t0_.name AS name_2, t0_.start_date AS start_date_3, t0_.end_date AS end_date_4, t0_.competition_id AS competition_id_5 FROM tournament t0_ INNER JOIN competition c1_ ON t0_.competition_id = c1_.id AND (c1_.name = ? AND c1_.area = ?) INNER JOIN team t2_ ON t0_.id = t2_.tournament_id WHERE t0_.name NOT IN (?, ?, ?) ORDER BY t0_.start_date DESC"
  "params" => [
    1 => "Allsvenskan"
    2 => "SWE"
    3 => "2015"
    4 => "2016"
    5 => "2017"
  ]
  "types" => [
    1 => 2
    2 => 2
    3 => 2
    4 => 2
    5 => 2
  ]
]

[
  "sql" => "SELECT t0_.id AS id_0, t0_.uuid AS uuid_1, t0_.name AS name_2, t0_.start_date AS start_date_3, t0_.end_date AS end_date_4, t0_.competition_id AS competition_id_5 FROM tournament t0_ INNER JOIN competition c1_ ON t0_.competition_id = c1_.id AND (c1_.name = ? AND c1_.area = ?) WHERE t0_.name NOT IN (?, ?, ?) ORDER BY t0_.start_date DESC LIMIT 1"
  "params" => [
    1 => "Allsvenskan"
    2 => "SWE"
    3 => "2015"
    4 => "2016"
    5 => "2017"
  ]
  "types" => [
    1 => 2
    2 => 2
    3 => 2
    4 => 2
    5 => 2
  ]
]

[
  "sql" => "SELECT t0_.id AS id_0, t0_.uuid AS uuid_1, t0_.name AS name_2, t0_.start_date AS start_date_3, t0_.end_date AS end_date_4, t0_.competition_id AS competition_id_5 FROM tournament t0_ INNER JOIN competition c1_ ON t0_.competition_id = c1_.id AND (c1_.name = ? AND c1_.area = ?) WHERE t0_.name NOT IN (?, ?, ?) ORDER BY t0_.start_date DESC LIMIT 1"
  "params" => [
    1 => "Allsvenskan"
    2 => "SWE"
    3 => "2015"
    4 => "2016"
    5 => "2017"
  ]
  "types" => [
    1 => 2
    2 => 2
    3 => 2
    4 => 2
    5 => 2
  ]
]

[
  "sql" => "SELECT v0_.id AS id_0, v0_.team AS team_1, v0_.team_logo AS team_logo_2, v0_.matches_played AS matches_played_3, v0_.passes AS passes_4, v0_.long_passes AS long_passes_5, v0_.through_balls AS through_balls_6, v0_.long_passes_through_balls AS long_passes_through_balls_7, v0_.long_passes_through_balls90 AS long_passes_through_balls90_8, v0_.tournament_id AS tournament_id_9 FROM view_ttlpgs01 v0_ WHERE v0_.tournament_id = ? ORDER BY v0_.long_passes_through_balls90 DESC, v0_.matches_played DESC, v0_.passes DESC, v0_.long_passes DESC, v0_.through_balls DESC, v0_.long_passes_through_balls DESC, v0_.team ASC"
  "params" => [
    1 => 6
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0_.id AS id_0, t0_.uuid AS uuid_1, t0_.name AS name_2, t0_.start_date AS start_date_3, t0_.end_date AS end_date_4, t0_.competition_id AS competition_id_5 FROM tournament t0_ INNER JOIN competition c1_ ON t0_.competition_id = c1_.id AND (c1_.name = ? AND c1_.area = ?) INNER JOIN team t2_ ON t0_.id = t2_.tournament_id WHERE t0_.name NOT IN (?, ?, ?) ORDER BY t0_.start_date DESC"
  "params" => [
    1 => "Allsvenskan"
    2 => "SWE"
    3 => "2015"
    4 => "2016"
    5 => "2017"
  ]
  "types" => [
    1 => 2
    2 => 2
    3 => 2
    4 => 2
    5 => 2
  ]
]

[
  "sql" => "SELECT t0_.id AS id_0, t0_.uuid AS uuid_1, t0_.name AS name_2, t0_.start_date AS start_date_3, t0_.end_date AS end_date_4, t0_.competition_id AS competition_id_5 FROM tournament t0_ INNER JOIN competition c1_ ON t0_.competition_id = c1_.id AND (c1_.name = ? AND c1_.area = ?) WHERE t0_.name NOT IN (?, ?, ?) ORDER BY t0_.start_date DESC LIMIT 1"
  "params" => [
    1 => "Allsvenskan"
    2 => "SWE"
    3 => "2015"
    4 => "2016"
    5 => "2017"
  ]
  "types" => [
    1 => 2
    2 => 2
    3 => 2
    4 => 2
    5 => 2
  ]
]

[
  "sql" => "SELECT t0_.id AS id_0, t0_.uuid AS uuid_1, t0_.name AS name_2, t0_.start_date AS start_date_3, t0_.end_date AS end_date_4, t0_.competition_id AS competition_id_5 FROM tournament t0_ INNER JOIN competition c1_ ON t0_.competition_id = c1_.id AND (c1_.name = ? AND c1_.area = ?) WHERE t0_.name NOT IN (?, ?, ?) ORDER BY t0_.start_date DESC LIMIT 1"
  "params" => [
    1 => "Allsvenskan"
    2 => "SWE"
    3 => "2015"
    4 => "2016"
    5 => "2017"
  ]
  "types" => [
    1 => 2
    2 => 2
    3 => 2
    4 => 2
    5 => 2
  ]
]

[
  "sql" => "SELECT v0_.id AS id_0, v0_.team AS team_1, v0_.team_logo AS team_logo_2, v0_.goals AS goals_3, v0_.x_g AS x_g_4, v0_.matches_played AS matches_played_5, v0_.goals_scored AS goals_scored_6, v0_.set_pieces AS set_pieces_7, v0_.tournament_id AS tournament_id_8 FROM view_ttfs01 v0_ WHERE v0_.tournament_id = ? ORDER BY v0_.goals DESC, v0_.matches_played DESC, v0_.goals_scored DESC, v0_.set_pieces DESC, v0_.x_g DESC, v0_.team ASC"
  "params" => [
    1 => 6
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0_.id AS id_0, t0_.uuid AS uuid_1, t0_.name AS name_2, t0_.start_date AS start_date_3, t0_.end_date AS end_date_4, t0_.competition_id AS competition_id_5 FROM tournament t0_ INNER JOIN competition c1_ ON t0_.competition_id = c1_.id AND (c1_.name = ? AND c1_.area = ?) INNER JOIN team t2_ ON t0_.id = t2_.tournament_id WHERE t0_.name NOT IN (?, ?, ?) ORDER BY t0_.start_date DESC"
  "params" => [
    1 => "Allsvenskan"
    2 => "SWE"
    3 => "2015"
    4 => "2016"
    5 => "2017"
  ]
  "types" => [
    1 => 2
    2 => 2
    3 => 2
    4 => 2
    5 => 2
  ]
]

[
  "sql" => "SELECT t0_.id AS id_0, t0_.uuid AS uuid_1, t0_.name AS name_2, t0_.start_date AS start_date_3, t0_.end_date AS end_date_4, t0_.competition_id AS competition_id_5 FROM tournament t0_ INNER JOIN competition c1_ ON t0_.competition_id = c1_.id AND (c1_.name = ? AND c1_.area = ?) WHERE t0_.name NOT IN (?, ?, ?) ORDER BY t0_.start_date DESC LIMIT 1"
  "params" => [
    1 => "Allsvenskan"
    2 => "SWE"
    3 => "2015"
    4 => "2016"
    5 => "2017"
  ]
  "types" => [
    1 => 2
    2 => 2
    3 => 2
    4 => 2
    5 => 2
  ]
]

[
  "sql" => "SELECT t0_.id AS id_0, t0_.uuid AS uuid_1, t0_.name AS name_2, t0_.start_date AS start_date_3, t0_.end_date AS end_date_4, t0_.competition_id AS competition_id_5 FROM tournament t0_ INNER JOIN competition c1_ ON t0_.competition_id = c1_.id AND (c1_.name = ? AND c1_.area = ?) WHERE t0_.name NOT IN (?, ?, ?) ORDER BY t0_.start_date DESC LIMIT 1"
  "params" => [
    1 => "Allsvenskan"
    2 => "SWE"
    3 => "2015"
    4 => "2016"
    5 => "2017"
  ]
  "types" => [
    1 => 2
    2 => 2
    3 => 2
    4 => 2
    5 => 2
  ]
]

[
  "sql" => "SELECT v0_.id AS id_0, v0_.team AS team_1, v0_.team_logo AS team_logo_2, v0_.clean_sheets AS clean_sheets_3, v0_.goals_conceded AS goals_conceded_4, v0_.chances_created_against AS chances_created_against_5, v0_.matches_played AS matches_played_6, v0_.shots_against AS shots_against_7, v0_.chanses90 AS chanses90_8, v0_.tournament_id AS tournament_id_9 FROM view_ttds01 v0_ WHERE v0_.tournament_id = ? ORDER BY v0_.chanses90 ASC, v0_.matches_played DESC, v0_.goals_conceded DESC, v0_.clean_sheets DESC, v0_.shots_against DESC, v0_.chances_created_against DESC, v0_.team ASC"
  "params" => [
    1 => 6
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0_.id AS id_0, t0_.uuid AS uuid_1, t0_.name AS name_2, t0_.start_date AS start_date_3, t0_.end_date AS end_date_4, t0_.competition_id AS competition_id_5 FROM tournament t0_ INNER JOIN competition c1_ ON t0_.competition_id = c1_.id AND (c1_.name = ? AND c1_.area = ?) INNER JOIN team t2_ ON t0_.id = t2_.tournament_id WHERE t0_.name NOT IN (?, ?, ?) ORDER BY t0_.start_date DESC"
  "params" => [
    1 => "Allsvenskan"
    2 => "SWE"
    3 => "2015"
    4 => "2016"
    5 => "2017"
  ]
  "types" => [
    1 => 2
    2 => 2
    3 => 2
    4 => 2
    5 => 2
  ]
]

[
  "sql" => "SELECT t0_.id AS id_0, t0_.uuid AS uuid_1, t0_.name AS name_2, t0_.start_date AS start_date_3, t0_.end_date AS end_date_4, t0_.competition_id AS competition_id_5 FROM tournament t0_ INNER JOIN competition c1_ ON t0_.competition_id = c1_.id AND (c1_.name = ? AND c1_.area = ?) WHERE t0_.name NOT IN (?, ?, ?) ORDER BY t0_.start_date DESC LIMIT 1"
  "params" => [
    1 => "Allsvenskan"
    2 => "SWE"
    3 => "2015"
    4 => "2016"
    5 => "2017"
  ]
  "types" => [
    1 => 2
    2 => 2
    3 => 2
    4 => 2
    5 => 2
  ]
]

[
  "sql" => "SELECT t0_.id AS id_0, t0_.uuid AS uuid_1, t0_.name AS name_2, t0_.start_date AS start_date_3, t0_.end_date AS end_date_4, t0_.competition_id AS competition_id_5 FROM tournament t0_ INNER JOIN competition c1_ ON t0_.competition_id = c1_.id AND (c1_.name = ? AND c1_.area = ?) WHERE t0_.name NOT IN (?, ?, ?) ORDER BY t0_.start_date DESC LIMIT 1"
  "params" => [
    1 => "Allsvenskan"
    2 => "SWE"
    3 => "2015"
    4 => "2016"
    5 => "2017"
  ]
  "types" => [
    1 => 2
    2 => 2
    3 => 2
    4 => 2
    5 => 2
  ]
]

[
  "sql" => "SELECT v0_.id AS id_0, v0_.team AS team_1, v0_.team_logo AS team_logo_2, v0_.matches_played AS matches_played_3, v0_.accelerations AS accelerations_4, v0_.progressive_run AS progressive_run_5, v0_.accelerations90 AS accelerations90_6, v0_.progressive_run90 AS progressive_run90_7, v0_.tournament_id AS tournament_id_8 FROM view_ttamub01 v0_ WHERE v0_.tournament_id = ? ORDER BY v0_.progressive_run90 DESC, v0_.accelerations90 DESC, v0_.matches_played DESC, v0_.accelerations DESC, v0_.progressive_run DESC, v0_.team ASC"
  "params" => [
    1 => 6
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0_.id AS id_0, t0_.uuid AS uuid_1, t0_.name AS name_2, t0_.start_date AS start_date_3, t0_.end_date AS end_date_4, t0_.competition_id AS competition_id_5 FROM tournament t0_ INNER JOIN competition c1_ ON t0_.competition_id = c1_.id AND (c1_.name = ? AND c1_.area = ?) INNER JOIN team t2_ ON t0_.id = t2_.tournament_id WHERE t0_.name NOT IN (?, ?, ?) ORDER BY t0_.start_date DESC"
  "params" => [
    1 => "Allsvenskan"
    2 => "SWE"
    3 => "2015"
    4 => "2016"
    5 => "2017"
  ]
  "types" => [
    1 => 2
    2 => 2
    3 => 2
    4 => 2
    5 => 2
  ]
]

[
  "sql" => "SELECT t0_.id AS id_0, t0_.uuid AS uuid_1, t0_.name AS name_2, t0_.start_date AS start_date_3, t0_.end_date AS end_date_4, t0_.competition_id AS competition_id_5 FROM tournament t0_ INNER JOIN competition c1_ ON t0_.competition_id = c1_.id AND (c1_.name = ? AND c1_.area = ?) WHERE t0_.name NOT IN (?, ?, ?) ORDER BY t0_.start_date DESC LIMIT 1"
  "params" => [
    1 => "Allsvenskan"
    2 => "SWE"
    3 => "2015"
    4 => "2016"
    5 => "2017"
  ]
  "types" => [
    1 => 2
    2 => 2
    3 => 2
    4 => 2
    5 => 2
  ]
]

[
  "sql" => "SELECT t0_.id AS id_0, t0_.uuid AS uuid_1, t0_.name AS name_2, t0_.start_date AS start_date_3, t0_.end_date AS end_date_4, t0_.competition_id AS competition_id_5 FROM tournament t0_ INNER JOIN competition c1_ ON t0_.competition_id = c1_.id AND (c1_.name = ? AND c1_.area = ?) WHERE t0_.name NOT IN (?, ?, ?) ORDER BY t0_.start_date DESC LIMIT 1"
  "params" => [
    1 => "Allsvenskan"
    2 => "SWE"
    3 => "2015"
    4 => "2016"
    5 => "2017"
  ]
  "types" => [
    1 => 2
    2 => 2
    3 => 2
    4 => 2
    5 => 2
  ]
]

[
  "sql" => "SELECT v0_.id AS id_0, v0_.team AS team_1, v0_.team_logo AS team_logo_2, v0_.matches_played AS matches_played_3, v0_.yellow_cards AS yellow_cards_4, v0_.red_cards AS red_cards_5, v0_.yellow_cards90 AS yellow_cards90_6, v0_.tournament_id AS tournament_id_7 FROM view_ttgrk01 v0_ WHERE v0_.tournament_id = ? ORDER BY v0_.yellow_cards90 DESC, v0_.matches_played DESC, v0_.yellow_cards DESC, v0_.red_cards DESC, v0_.team ASC"
  "params" => [
    1 => 6
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0_.id AS id_0, t0_.uuid AS uuid_1, t0_.name AS name_2, t0_.start_date AS start_date_3, t0_.end_date AS end_date_4, t0_.competition_id AS competition_id_5 FROM tournament t0_ INNER JOIN competition c1_ ON t0_.competition_id = c1_.id AND (c1_.name = ? AND c1_.area = ?) INNER JOIN team t2_ ON t0_.id = t2_.tournament_id WHERE t0_.name NOT IN (?, ?, ?) ORDER BY t0_.start_date DESC"
  "params" => [
    1 => "Allsvenskan"
    2 => "SWE"
    3 => "2015"
    4 => "2016"
    5 => "2017"
  ]
  "types" => [
    1 => 2
    2 => 2
    3 => 2
    4 => 2
    5 => 2
  ]
]

[
  "sql" => "SELECT t0_.id AS id_0, t0_.uuid AS uuid_1, t0_.name AS name_2, t0_.start_date AS start_date_3, t0_.end_date AS end_date_4, t0_.competition_id AS competition_id_5 FROM tournament t0_ INNER JOIN competition c1_ ON t0_.competition_id = c1_.id AND (c1_.name = ? AND c1_.area = ?) WHERE t0_.name NOT IN (?, ?, ?) ORDER BY t0_.start_date DESC LIMIT 1"
  "params" => [
    1 => "Allsvenskan"
    2 => "SWE"
    3 => "2015"
    4 => "2016"
    5 => "2017"
  ]
  "types" => [
    1 => 2
    2 => 2
    3 => 2
    4 => 2
    5 => 2
  ]
]

[
  "sql" => "SELECT t0_.id AS id_0, t0_.uuid AS uuid_1, t0_.name AS name_2, t0_.start_date AS start_date_3, t0_.end_date AS end_date_4, t0_.competition_id AS competition_id_5 FROM tournament t0_ INNER JOIN competition c1_ ON t0_.competition_id = c1_.id AND (c1_.name = ? AND c1_.area = ?) WHERE t0_.name NOT IN (?, ?, ?) ORDER BY t0_.start_date DESC LIMIT 1"
  "params" => [
    1 => "Allsvenskan"
    2 => "SWE"
    3 => "2015"
    4 => "2016"
    5 => "2017"
  ]
  "types" => [
    1 => 2
    2 => 2
    3 => 2
    4 => 2
    5 => 2
  ]
]

[
  "sql" => "SELECT v0_.id AS id_0, v0_.team AS team_1, v0_.team_logo AS team_logo_2, v0_.matches_played AS matches_played_3, v0_.penalties AS penalties_4, v0_.penalties_goals AS penalties_goals_5, v0_.penalties_against AS penalties_against_6, v0_.penalties_goals_against AS penalties_goals_against_7, v0_.tournament_id AS tournament_id_8 FROM view_tts01 v0_ WHERE v0_.tournament_id = ? ORDER BY v0_.penalties DESC, v0_.matches_played DESC, v0_.penalties_goals DESC, v0_.penalties_against DESC, v0_.penalties_goals_against DESC, v0_.team ASC"
  "params" => [
    1 => 6
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0_.id AS id_0, t0_.uuid AS uuid_1, t0_.name AS name_2, t0_.start_date AS start_date_3, t0_.end_date AS end_date_4, t0_.competition_id AS competition_id_5 FROM tournament t0_ INNER JOIN competition c1_ ON t0_.competition_id = c1_.id AND (c1_.name = ? AND c1_.area = ?) INNER JOIN team t2_ ON t0_.id = t2_.tournament_id WHERE t0_.name NOT IN (?, ?, ?) ORDER BY t0_.start_date DESC"
  "params" => [
    1 => "Allsvenskan"
    2 => "SWE"
    3 => "2015"
    4 => "2016"
    5 => "2017"
  ]
  "types" => [
    1 => 2
    2 => 2
    3 => 2
    4 => 2
    5 => 2
  ]
]

[
  "sql" => "SELECT t0_.id AS id_0, t0_.uuid AS uuid_1, t0_.name AS name_2, t0_.start_date AS start_date_3, t0_.end_date AS end_date_4, t0_.competition_id AS competition_id_5 FROM tournament t0_ INNER JOIN competition c1_ ON t0_.competition_id = c1_.id AND (c1_.name = ? AND c1_.area = ?) WHERE t0_.name NOT IN (?, ?, ?) ORDER BY t0_.start_date DESC LIMIT 1"
  "params" => [
    1 => "Allsvenskan"
    2 => "SWE"
    3 => "2015"
    4 => "2016"
    5 => "2017"
  ]
  "types" => [
    1 => 2
    2 => 2
    3 => 2
    4 => 2
    5 => 2
  ]
]

[
  "sql" => "SELECT t0_.id AS id_0, t0_.uuid AS uuid_1, t0_.name AS name_2, t0_.start_date AS start_date_3, t0_.end_date AS end_date_4, t0_.competition_id AS competition_id_5 FROM tournament t0_ INNER JOIN competition c1_ ON t0_.competition_id = c1_.id AND (c1_.name = ? AND c1_.area = ?) WHERE t0_.name NOT IN (?, ?, ?) ORDER BY t0_.start_date DESC LIMIT 1"
  "params" => [
    1 => "Allsvenskan"
    2 => "SWE"
    3 => "2015"
    4 => "2016"
    5 => "2017"
  ]
  "types" => [
    1 => 2
    2 => 2
    3 => 2
    4 => 2
    5 => 2
  ]
]

[
  "sql" => "SELECT v0_.id AS id_0, v0_.player_id AS player_id_1, v0_.player AS player_2, v0_.team AS team_3, v0_.team_logo AS team_logo_4, v0_.player_goals AS player_goals_5, v0_.assists AS assists_6, v0_.points AS points_7, v0_.matches_played AS matches_played_8, v0_.minutes_played AS minutes_played_9, v0_.min_minutes_played AS min_minutes_played_10, v0_.points90 AS points90_11, v0_.tournament_id AS tournament_id_12 FROM view_tpmap01 v0_ WHERE v0_.minutes_played >= v0_.min_minutes_played AND v0_.tournament_id = ? ORDER BY v0_.points DESC, v0_.points90 DESC, v0_.matches_played DESC, v0_.minutes_played DESC, v0_.player_goals DESC, v0_.assists DESC, v0_.player ASC LIMIT 20"
  "params" => [
    1 => 6
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0_.id AS id_0, t0_.uuid AS uuid_1, t0_.name AS name_2, t0_.start_date AS start_date_3, t0_.end_date AS end_date_4, t0_.competition_id AS competition_id_5 FROM tournament t0_ INNER JOIN competition c1_ ON t0_.competition_id = c1_.id AND (c1_.name = ? AND c1_.area = ?) INNER JOIN team t2_ ON t0_.id = t2_.tournament_id WHERE t0_.name NOT IN (?, ?, ?) ORDER BY t0_.start_date DESC"
  "params" => [
    1 => "Allsvenskan"
    2 => "SWE"
    3 => "2015"
    4 => "2016"
    5 => "2017"
  ]
  "types" => [
    1 => 2
    2 => 2
    3 => 2
    4 => 2
    5 => 2
  ]
]

[
  "sql" => "SELECT t0_.id AS id_0, t0_.uuid AS uuid_1, t0_.name AS name_2, t0_.start_date AS start_date_3, t0_.end_date AS end_date_4, t0_.competition_id AS competition_id_5 FROM tournament t0_ INNER JOIN competition c1_ ON t0_.competition_id = c1_.id AND (c1_.name = ? AND c1_.area = ?) WHERE t0_.name NOT IN (?, ?, ?) ORDER BY t0_.start_date DESC LIMIT 1"
  "params" => [
    1 => "Allsvenskan"
    2 => "SWE"
    3 => "2015"
    4 => "2016"
    5 => "2017"
  ]
  "types" => [
    1 => 2
    2 => 2
    3 => 2
    4 => 2
    5 => 2
  ]
]

[
  "sql" => "SELECT t0_.id AS id_0, t0_.uuid AS uuid_1, t0_.name AS name_2, t0_.start_date AS start_date_3, t0_.end_date AS end_date_4, t0_.competition_id AS competition_id_5 FROM tournament t0_ INNER JOIN competition c1_ ON t0_.competition_id = c1_.id AND (c1_.name = ? AND c1_.area = ?) WHERE t0_.name NOT IN (?, ?, ?) ORDER BY t0_.start_date DESC LIMIT 1"
  "params" => [
    1 => "Allsvenskan"
    2 => "SWE"
    3 => "2015"
    4 => "2016"
    5 => "2017"
  ]
  "types" => [
    1 => 2
    2 => 2
    3 => 2
    4 => 2
    5 => 2
  ]
]

[
  "sql" => "SELECT v0_.id AS id_0, v0_.player_id AS player_id_1, v0_.player AS player_2, v0_.team AS team_3, v0_.team_logo AS team_logo_4, v0_.born AS born_5, v0_.matches_played AS matches_played_6, v0_.minutes_played AS minutes_played_7, v0_.min_minutes_played AS min_minutes_played_8, v0_.expected_goals AS expected_goals_9, v0_.expected_assists AS expected_assists_10, v0_.expected_points AS expected_points_11, v0_.expected_points90 AS expected_points90_12, v0_.tournament_id AS tournament_id_13 FROM view_tpxgxaxp01 v0_ WHERE v0_.minutes_played >= v0_.min_minutes_played AND v0_.tournament_id = ? ORDER BY v0_.expected_points90 DESC, v0_.born DESC, v0_.matches_played DESC, v0_.minutes_played DESC, v0_.expected_goals DESC, v0_.expected_assists DESC, v0_.expected_points DESC, v0_.player ASC LIMIT 20"
  "params" => [
    1 => 6
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0_.id AS id_0, t0_.uuid AS uuid_1, t0_.name AS name_2, t0_.start_date AS start_date_3, t0_.end_date AS end_date_4, t0_.competition_id AS competition_id_5 FROM tournament t0_ INNER JOIN competition c1_ ON t0_.competition_id = c1_.id AND (c1_.name = ? AND c1_.area = ?) INNER JOIN team t2_ ON t0_.id = t2_.tournament_id WHERE t0_.name NOT IN (?, ?, ?) ORDER BY t0_.start_date DESC"
  "params" => [
    1 => "Allsvenskan"
    2 => "SWE"
    3 => "2015"
    4 => "2016"
    5 => "2017"
  ]
  "types" => [
    1 => 2
    2 => 2
    3 => 2
    4 => 2
    5 => 2
  ]
]

[
  "sql" => "SELECT t0_.id AS id_0, t0_.uuid AS uuid_1, t0_.name AS name_2, t0_.start_date AS start_date_3, t0_.end_date AS end_date_4, t0_.competition_id AS competition_id_5 FROM tournament t0_ INNER JOIN competition c1_ ON t0_.competition_id = c1_.id AND (c1_.name = ? AND c1_.area = ?) WHERE t0_.name NOT IN (?, ?, ?) ORDER BY t0_.start_date DESC LIMIT 1"
  "params" => [
    1 => "Allsvenskan"
    2 => "SWE"
    3 => "2015"
    4 => "2016"
    5 => "2017"
  ]
  "types" => [
    1 => 2
    2 => 2
    3 => 2
    4 => 2
    5 => 2
  ]
]

[
  "sql" => "SELECT t0_.id AS id_0, t0_.uuid AS uuid_1, t0_.name AS name_2, t0_.start_date AS start_date_3, t0_.end_date AS end_date_4, t0_.competition_id AS competition_id_5 FROM tournament t0_ INNER JOIN competition c1_ ON t0_.competition_id = c1_.id AND (c1_.name = ? AND c1_.area = ?) WHERE t0_.name NOT IN (?, ?, ?) ORDER BY t0_.start_date DESC LIMIT 1"
  "params" => [
    1 => "Allsvenskan"
    2 => "SWE"
    3 => "2015"
    4 => "2016"
    5 => "2017"
  ]
  "types" => [
    1 => 2
    2 => 2
    3 => 2
    4 => 2
    5 => 2
  ]
]

[
  "sql" => "SELECT v0_.id AS id_0, v0_.player_id AS player_id_1, v0_.player AS player_2, v0_.team AS team_3, v0_.team_logo AS team_logo_4, v0_.matches_played AS matches_played_5, v0_.minutes_played AS minutes_played_6, v0_.min_minutes_played AS min_minutes_played_7, v0_.goals_scored AS goals_scored_8, v0_.expected_goals AS expected_goals_9, v0_.ordinary_position AS ordinary_position_10, v0_.expected_goals90 AS expected_goals90_11, v0_.tournament_id AS tournament_id_12 FROM view_tpmxg01 v0_ WHERE v0_.minutes_played >= v0_.min_minutes_played AND v0_.tournament_id = ? ORDER BY v0_.goals_scored DESC, v0_.expected_goals90 DESC, v0_.matches_played DESC, v0_.minutes_played DESC, v0_.expected_goals DESC, v0_.player ASC LIMIT 20"
  "params" => [
    1 => 6
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0_.id AS id_0, t0_.uuid AS uuid_1, t0_.name AS name_2, t0_.start_date AS start_date_3, t0_.end_date AS end_date_4, t0_.competition_id AS competition_id_5 FROM tournament t0_ INNER JOIN competition c1_ ON t0_.competition_id = c1_.id AND (c1_.name = ? AND c1_.area = ?) INNER JOIN team t2_ ON t0_.id = t2_.tournament_id WHERE t0_.name NOT IN (?, ?, ?) ORDER BY t0_.start_date DESC"
  "params" => [
    1 => "Allsvenskan"
    2 => "SWE"
    3 => "2015"
    4 => "2016"
    5 => "2017"
  ]
  "types" => [
    1 => 2
    2 => 2
    3 => 2
    4 => 2
    5 => 2
  ]
]

[
  "sql" => "SELECT t0_.id AS id_0, t0_.uuid AS uuid_1, t0_.name AS name_2, t0_.start_date AS start_date_3, t0_.end_date AS end_date_4, t0_.competition_id AS competition_id_5 FROM tournament t0_ INNER JOIN competition c1_ ON t0_.competition_id = c1_.id AND (c1_.name = ? AND c1_.area = ?) WHERE t0_.name NOT IN (?, ?, ?) ORDER BY t0_.start_date DESC LIMIT 1"
  "params" => [
    1 => "Allsvenskan"
    2 => "SWE"
    3 => "2015"
    4 => "2016"
    5 => "2017"
  ]
  "types" => [
    1 => 2
    2 => 2
    3 => 2
    4 => 2
    5 => 2
  ]
]

[
  "sql" => "SELECT t0_.id AS id_0, t0_.uuid AS uuid_1, t0_.name AS name_2, t0_.start_date AS start_date_3, t0_.end_date AS end_date_4, t0_.competition_id AS competition_id_5 FROM tournament t0_ INNER JOIN competition c1_ ON t0_.competition_id = c1_.id AND (c1_.name = ? AND c1_.area = ?) WHERE t0_.name NOT IN (?, ?, ?) ORDER BY t0_.start_date DESC LIMIT 1"
  "params" => [
    1 => "Allsvenskan"
    2 => "SWE"
    3 => "2015"
    4 => "2016"
    5 => "2017"
  ]
  "types" => [
    1 => 2
    2 => 2
    3 => 2
    4 => 2
    5 => 2
  ]
]

[
  "sql" => "SELECT v0_.id AS id_0, v0_.player_id AS player_id_1, v0_.player AS player_2, v0_.team AS team_3, v0_.team_logo AS team_logo_4, v0_.matches_played AS matches_played_5, v0_.minutes_played AS minutes_played_6, v0_.min_minutes_played AS min_minutes_played_7, v0_.assists AS assists_8, v0_.expected_assists AS expected_assists_9, v0_.ordinary_position AS ordinary_position_10, v0_.expected_assists90 AS expected_assists90_11, v0_.tournament_id AS tournament_id_12 FROM view_tpaxa01 v0_ WHERE v0_.minutes_played >= v0_.min_minutes_played AND v0_.tournament_id = ? ORDER BY v0_.assists DESC, v0_.expected_assists90 DESC, v0_.matches_played DESC, v0_.minutes_played DESC, v0_.expected_assists DESC, v0_.player ASC LIMIT 20"
  "params" => [
    1 => 6
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0_.id AS id_0, t0_.uuid AS uuid_1, t0_.name AS name_2, t0_.start_date AS start_date_3, t0_.end_date AS end_date_4, t0_.competition_id AS competition_id_5 FROM tournament t0_ INNER JOIN competition c1_ ON t0_.competition_id = c1_.id AND (c1_.name = ? AND c1_.area = ?) INNER JOIN team t2_ ON t0_.id = t2_.tournament_id WHERE t0_.name NOT IN (?, ?, ?) ORDER BY t0_.start_date DESC"
  "params" => [
    1 => "Allsvenskan"
    2 => "SWE"
    3 => "2015"
    4 => "2016"
    5 => "2017"
  ]
  "types" => [
    1 => 2
    2 => 2
    3 => 2
    4 => 2
    5 => 2
  ]
]

[
  "sql" => "SELECT t0_.id AS id_0, t0_.uuid AS uuid_1, t0_.name AS name_2, t0_.start_date AS start_date_3, t0_.end_date AS end_date_4, t0_.competition_id AS competition_id_5 FROM tournament t0_ INNER JOIN competition c1_ ON t0_.competition_id = c1_.id AND (c1_.name = ? AND c1_.area = ?) WHERE t0_.name NOT IN (?, ?, ?) ORDER BY t0_.start_date DESC LIMIT 1"
  "params" => [
    1 => "Allsvenskan"
    2 => "SWE"
    3 => "2015"
    4 => "2016"
    5 => "2017"
  ]
  "types" => [
    1 => 2
    2 => 2
    3 => 2
    4 => 2
    5 => 2
  ]
]

[
  "sql" => "SELECT t0_.id AS id_0, t0_.uuid AS uuid_1, t0_.name AS name_2, t0_.start_date AS start_date_3, t0_.end_date AS end_date_4, t0_.competition_id AS competition_id_5 FROM tournament t0_ INNER JOIN competition c1_ ON t0_.competition_id = c1_.id AND (c1_.name = ? AND c1_.area = ?) WHERE t0_.name NOT IN (?, ?, ?) ORDER BY t0_.start_date DESC LIMIT 1"
  "params" => [
    1 => "Allsvenskan"
    2 => "SWE"
    3 => "2015"
    4 => "2016"
    5 => "2017"
  ]
  "types" => [
    1 => 2
    2 => 2
    3 => 2
    4 => 2
    5 => 2
  ]
]

[
  "sql" => "SELECT v0_.id AS id_0, v0_.player_id AS player_id_1, v0_.player AS player_2, v0_.team AS team_3, v0_.team_logo AS team_logo_4, v0_.expected_points AS expected_points_5, v0_.ordinary_position AS ordinary_position_6, v0_.matches_played AS matches_played_7, v0_.minutes_played AS minutes_played_8, v0_.min_minutes_played AS min_minutes_played_9, v0_.points AS points_10, v0_.expected_points90 AS expected_points90_11, v0_.tournament_id AS tournament_id_12 FROM view_tppxp01 v0_ WHERE v0_.minutes_played >= v0_.min_minutes_played AND v0_.tournament_id = ? ORDER BY v0_.expected_points DESC, v0_.expected_points90 DESC, v0_.matches_played DESC, v0_.minutes_played DESC, v0_.points DESC, v0_.player ASC LIMIT 20"
  "params" => [
    1 => 6
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0_.id AS id_0, t0_.uuid AS uuid_1, t0_.name AS name_2, t0_.start_date AS start_date_3, t0_.end_date AS end_date_4, t0_.competition_id AS competition_id_5 FROM tournament t0_ INNER JOIN competition c1_ ON t0_.competition_id = c1_.id AND (c1_.name = ? AND c1_.area = ?) INNER JOIN team t2_ ON t0_.id = t2_.tournament_id WHERE t0_.name NOT IN (?, ?, ?) ORDER BY t0_.start_date DESC"
  "params" => [
    1 => "Allsvenskan"
    2 => "SWE"
    3 => "2015"
    4 => "2016"
    5 => "2017"
  ]
  "types" => [
    1 => 2
    2 => 2
    3 => 2
    4 => 2
    5 => 2
  ]
]

[
  "sql" => "SELECT t0_.id AS id_0, t0_.uuid AS uuid_1, t0_.name AS name_2, t0_.start_date AS start_date_3, t0_.end_date AS end_date_4, t0_.competition_id AS competition_id_5 FROM tournament t0_ INNER JOIN competition c1_ ON t0_.competition_id = c1_.id AND (c1_.name = ? AND c1_.area = ?) WHERE t0_.name NOT IN (?, ?, ?) ORDER BY t0_.start_date DESC LIMIT 1"
  "params" => [
    1 => "Allsvenskan"
    2 => "SWE"
    3 => "2015"
    4 => "2016"
    5 => "2017"
  ]
  "types" => [
    1 => 2
    2 => 2
    3 => 2
    4 => 2
    5 => 2
  ]
]

[
  "sql" => "SELECT t0_.id AS id_0, t0_.uuid AS uuid_1, t0_.name AS name_2, t0_.start_date AS start_date_3, t0_.end_date AS end_date_4, t0_.competition_id AS competition_id_5 FROM tournament t0_ INNER JOIN competition c1_ ON t0_.competition_id = c1_.id AND (c1_.name = ? AND c1_.area = ?) WHERE t0_.name NOT IN (?, ?, ?) ORDER BY t0_.start_date DESC LIMIT 1"
  "params" => [
    1 => "Allsvenskan"
    2 => "SWE"
    3 => "2015"
    4 => "2016"
    5 => "2017"
  ]
  "types" => [
    1 => 2
    2 => 2
    3 => 2
    4 => 2
    5 => 2
  ]
]

[
  "sql" => "SELECT v0_.id AS id_0, v0_.player_id AS player_id_1, v0_.player AS player_2, v0_.team AS team_3, v0_.team_logo AS team_logo_4, v0_.chances_created AS chances_created_5, v0_.minutes_played AS minutes_played_6, v0_.min_minutes_played AS min_minutes_played_7, v0_.matches_played AS matches_played_8, v0_.chanses90 AS chanses90_9, v0_.tournament_id AS tournament_id_10 FROM view_tpsc01 v0_ WHERE v0_.minutes_played >= v0_.min_minutes_played AND v0_.tournament_id = ? ORDER BY v0_.chanses90 DESC, v0_.matches_played DESC, v0_.minutes_played DESC, v0_.chances_created DESC, v0_.player ASC LIMIT 20"
  "params" => [
    1 => 6
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0_.id AS id_0, t0_.uuid AS uuid_1, t0_.name AS name_2, t0_.start_date AS start_date_3, t0_.end_date AS end_date_4, t0_.competition_id AS competition_id_5 FROM tournament t0_ INNER JOIN competition c1_ ON t0_.competition_id = c1_.id AND (c1_.name = ? AND c1_.area = ?) INNER JOIN team t2_ ON t0_.id = t2_.tournament_id WHERE t0_.name NOT IN (?, ?, ?) ORDER BY t0_.start_date DESC"
  "params" => [
    1 => "Allsvenskan"
    2 => "SWE"
    3 => "2015"
    4 => "2016"
    5 => "2017"
  ]
  "types" => [
    1 => 2
    2 => 2
    3 => 2
    4 => 2
    5 => 2
  ]
]

[
  "sql" => "SELECT t0_.id AS id_0, t0_.uuid AS uuid_1, t0_.name AS name_2, t0_.start_date AS start_date_3, t0_.end_date AS end_date_4, t0_.competition_id AS competition_id_5 FROM tournament t0_ INNER JOIN competition c1_ ON t0_.competition_id = c1_.id AND (c1_.name = ? AND c1_.area = ?) WHERE t0_.name NOT IN (?, ?, ?) ORDER BY t0_.start_date DESC LIMIT 1"
  "params" => [
    1 => "Allsvenskan"
    2 => "SWE"
    3 => "2015"
    4 => "2016"
    5 => "2017"
  ]
  "types" => [
    1 => 2
    2 => 2
    3 => 2
    4 => 2
    5 => 2
  ]
]

[
  "sql" => "SELECT t0_.id AS id_0, t0_.uuid AS uuid_1, t0_.name AS name_2, t0_.start_date AS start_date_3, t0_.end_date AS end_date_4, t0_.competition_id AS competition_id_5 FROM tournament t0_ INNER JOIN competition c1_ ON t0_.competition_id = c1_.id AND (c1_.name = ? AND c1_.area = ?) WHERE t0_.name NOT IN (?, ?, ?) ORDER BY t0_.start_date DESC LIMIT 1"
  "params" => [
    1 => "Allsvenskan"
    2 => "SWE"
    3 => "2015"
    4 => "2016"
    5 => "2017"
  ]
  "types" => [
    1 => 2
    2 => 2
    3 => 2
    4 => 2
    5 => 2
  ]
]

[
  "sql" => "SELECT v0_.id AS id_0, v0_.player_id AS player_id_1, v0_.player AS player_2, v0_.team AS team_3, v0_.team_logo AS team_logo_4, v0_.goals_scored AS goals_scored_5, v0_.matches_played AS matches_played_6, v0_.minutes_played AS minutes_played_7, v0_.min_minutes_played AS min_minutes_played_8, v0_.chances_created AS chances_created_9, v0_.goals_chances_created AS goals_chances_created_10, v0_.tournament_id AS tournament_id_11 FROM view_tpkg01 v0_ WHERE v0_.minutes_played >= v0_.min_minutes_played AND (NOT (v0_.chances_created <= 2 OR v0_.goals_scored <= 1)) AND v0_.tournament_id = ? ORDER BY v0_.goals_chances_created DESC, v0_.matches_played DESC, v0_.minutes_played DESC, v0_.goals_scored DESC, v0_.chances_created DESC, v0_.player ASC LIMIT 20"
  "params" => [
    1 => 6
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0_.id AS id_0, t0_.uuid AS uuid_1, t0_.name AS name_2, t0_.start_date AS start_date_3, t0_.end_date AS end_date_4, t0_.competition_id AS competition_id_5 FROM tournament t0_ INNER JOIN competition c1_ ON t0_.competition_id = c1_.id AND (c1_.name = ? AND c1_.area = ?) INNER JOIN team t2_ ON t0_.id = t2_.tournament_id WHERE t0_.name NOT IN (?, ?, ?) ORDER BY t0_.start_date DESC"
  "params" => [
    1 => "Allsvenskan"
    2 => "SWE"
    3 => "2015"
    4 => "2016"
    5 => "2017"
  ]
  "types" => [
    1 => 2
    2 => 2
    3 => 2
    4 => 2
    5 => 2
  ]
]

[
  "sql" => "SELECT t0_.id AS id_0, t0_.uuid AS uuid_1, t0_.name AS name_2, t0_.start_date AS start_date_3, t0_.end_date AS end_date_4, t0_.competition_id AS competition_id_5 FROM tournament t0_ INNER JOIN competition c1_ ON t0_.competition_id = c1_.id AND (c1_.name = ? AND c1_.area = ?) WHERE t0_.name NOT IN (?, ?, ?) ORDER BY t0_.start_date DESC LIMIT 1"
  "params" => [
    1 => "Allsvenskan"
    2 => "SWE"
    3 => "2015"
    4 => "2016"
    5 => "2017"
  ]
  "types" => [
    1 => 2
    2 => 2
    3 => 2
    4 => 2
    5 => 2
  ]
]

[
  "sql" => "SELECT t0_.id AS id_0, t0_.uuid AS uuid_1, t0_.name AS name_2, t0_.start_date AS start_date_3, t0_.end_date AS end_date_4, t0_.competition_id AS competition_id_5 FROM tournament t0_ INNER JOIN competition c1_ ON t0_.competition_id = c1_.id AND (c1_.name = ? AND c1_.area = ?) WHERE t0_.name NOT IN (?, ?, ?) ORDER BY t0_.start_date DESC LIMIT 1"
  "params" => [
    1 => "Allsvenskan"
    2 => "SWE"
    3 => "2015"
    4 => "2016"
    5 => "2017"
  ]
  "types" => [
    1 => 2
    2 => 2
    3 => 2
    4 => 2
    5 => 2
  ]
]

[
  "sql" => "SELECT v0_.id AS id_0, v0_.player_id AS player_id_1, v0_.player AS player_2, v0_.team AS team_3, v0_.team_logo AS team_logo_4, v0_.passes AS passes_5, v0_.successfull_passes AS successfull_passes_6, v0_.pass_percentage AS pass_percentage_7, v0_.matches_played AS matches_played_8, v0_.minutes_played AS minutes_played_9, v0_.min_minutes_played AS min_minutes_played_10, v0_.role_code2 AS role_code2_11, v0_.tournament_id AS tournament_id_12 FROM view_tpppp01 v0_ WHERE v0_.minutes_played >= v0_.min_minutes_played AND v0_.role_code2 NOT IN ('GK') AND v0_.tournament_id = ? ORDER BY v0_.pass_percentage DESC, v0_.matches_played DESC, v0_.minutes_played DESC, v0_.passes DESC, v0_.successfull_passes DESC, v0_.player ASC LIMIT 20"
  "params" => [
    1 => 6
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0_.id AS id_0, t0_.uuid AS uuid_1, t0_.name AS name_2, t0_.start_date AS start_date_3, t0_.end_date AS end_date_4, t0_.competition_id AS competition_id_5 FROM tournament t0_ INNER JOIN competition c1_ ON t0_.competition_id = c1_.id AND (c1_.name = ? AND c1_.area = ?) INNER JOIN team t2_ ON t0_.id = t2_.tournament_id WHERE t0_.name NOT IN (?, ?, ?) ORDER BY t0_.start_date DESC"
  "params" => [
    1 => "Allsvenskan"
    2 => "SWE"
    3 => "2015"
    4 => "2016"
    5 => "2017"
  ]
  "types" => [
    1 => 2
    2 => 2
    3 => 2
    4 => 2
    5 => 2
  ]
]

[
  "sql" => "SELECT t0_.id AS id_0, t0_.uuid AS uuid_1, t0_.name AS name_2, t0_.start_date AS start_date_3, t0_.end_date AS end_date_4, t0_.competition_id AS competition_id_5 FROM tournament t0_ INNER JOIN competition c1_ ON t0_.competition_id = c1_.id AND (c1_.name = ? AND c1_.area = ?) WHERE t0_.name NOT IN (?, ?, ?) ORDER BY t0_.start_date DESC LIMIT 1"
  "params" => [
    1 => "Allsvenskan"
    2 => "SWE"
    3 => "2015"
    4 => "2016"
    5 => "2017"
  ]
  "types" => [
    1 => 2
    2 => 2
    3 => 2
    4 => 2
    5 => 2
  ]
]

[
  "sql" => "SELECT t0_.id AS id_0, t0_.uuid AS uuid_1, t0_.name AS name_2, t0_.start_date AS start_date_3, t0_.end_date AS end_date_4, t0_.competition_id AS competition_id_5 FROM tournament t0_ INNER JOIN competition c1_ ON t0_.competition_id = c1_.id AND (c1_.name = ? AND c1_.area = ?) WHERE t0_.name NOT IN (?, ?, ?) ORDER BY t0_.start_date DESC LIMIT 1"
  "params" => [
    1 => "Allsvenskan"
    2 => "SWE"
    3 => "2015"
    4 => "2016"
    5 => "2017"
  ]
  "types" => [
    1 => 2
    2 => 2
    3 => 2
    4 => 2
    5 => 2
  ]
]

[
  "sql" => "SELECT v0_.id AS id_0, v0_.player_id AS player_id_1, v0_.player AS player_2, v0_.team AS team_3, v0_.team_logo AS team_logo_4, v0_.passes AS passes_5, v0_.key_passes AS key_passes_6, v0_.key_passes90 AS key_passes90_7, v0_.matches_played AS matches_played_8, v0_.minutes_played AS minutes_played_9, v0_.min_minutes_played AS min_minutes_played_10, v0_.tournament_id AS tournament_id_11 FROM view_tpnp01 v0_ WHERE v0_.minutes_played >= v0_.min_minutes_played AND v0_.tournament_id = ? ORDER BY v0_.key_passes90 DESC, v0_.matches_played DESC, v0_.minutes_played DESC, v0_.passes DESC, v0_.key_passes DESC, v0_.player ASC LIMIT 20"
  "params" => [
    1 => 6
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0_.id AS id_0, t0_.uuid AS uuid_1, t0_.name AS name_2, t0_.start_date AS start_date_3, t0_.end_date AS end_date_4, t0_.competition_id AS competition_id_5 FROM tournament t0_ INNER JOIN competition c1_ ON t0_.competition_id = c1_.id AND (c1_.name = ? AND c1_.area = ?) INNER JOIN team t2_ ON t0_.id = t2_.tournament_id WHERE t0_.name NOT IN (?, ?, ?) ORDER BY t0_.start_date DESC"
  "params" => [
    1 => "Allsvenskan"
    2 => "SWE"
    3 => "2015"
    4 => "2016"
    5 => "2017"
  ]
  "types" => [
    1 => 2
    2 => 2
    3 => 2
    4 => 2
    5 => 2
  ]
]