Symfony Profiler

[
  "route" => "app_costs"
  "route_parameters" => [
    "_route" => "app_costs"
    "_controller" => "App\Controller\CostReportController::index"
  ]
  "request_uri" => "https://travel.fna.cx/kosten?tab=final&year=2026"
  "method" => "GET"
]

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

[
  "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"
]

[
  "key" => "_security_main"
  "token_class" => "Symfony\Component\Security\Core\Authentication\Token\RememberMeToken"
]

[
  "params" => [
    "driver" => "pdo_mysql"
    "host" => "127.0.0.1"
    "port" => 3306
    "dbname" => "travel"
    "user" => "travel"
    "password" => "<redacted>"
    "charset" => "utf8mb4"
    "idle_connection_ttl" => 600
    "driverOptions" => []
    "serverVersion" => "8.4.0"
    "defaultTableOptions" => []
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.display_name AS display_name_5 FROM `user` t0 WHERE t0.id = ?"
  "params" => [
    1 => 1
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#739
      +name: "INTEGER"
    }
  ]
]

[
  "provider" => "Symfony\Bridge\Doctrine\Security\User\EntityUserProvider"
  "username" => "florian.natusch@googlemail.com"
]

[
  "authenticator" => "Symfony\Component\Security\Http\Authenticator\RememberMeAuthenticator"
]

[
  "sql" => "SELECT t0_.id AS id_0, t0_.name AS name_1, t0_.code AS code_2, t0_.start_date AS start_date_3, t0_.end_date AS end_date_4, t0_.home_base AS home_base_5, t0_.sort_order AS sort_order_6, t0_.trip_id AS trip_id_7, t0_.destination_id AS destination_id_8 FROM trip_segment t0_ INNER JOIN trip t1_ ON t0_.trip_id = t1_.id WHERE t1_.owner_id = ? AND t0_.start_date <= ? AND t0_.end_date >= ? ORDER BY t0_.start_date ASC, t0_.sort_order ASC"
  "params" => [
    1 => 1
    2 => "2026-12-31 00:00:00"
    3 => "2026-01-01 00:00:00"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#739
      +name: "INTEGER"
    }
    2 => Doctrine\DBAL\ParameterType {#923
      +name: "STRING"
    }
    3 => Doctrine\DBAL\ParameterType {#923}
  ]
]

[
  "sql" => "SELECT c0_.id AS id_0, c0_.label AS label_1, c0_.amount AS amount_2, c0_.currency AS currency_3, c0_.category AS category_4, c0_.paid AS paid_5, c0_.paid_at AS paid_at_6, c0_.segment_id AS segment_id_7 FROM cost_item c0_ WHERE c0_.segment_id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) ORDER BY c0_.category ASC, c0_.label ASC"
  "params" => [
    1 => 13
    2 => 14
    3 => 15
    4 => 16
    5 => 17
    6 => 18
    7 => 19
    8 => 20
    9 => 21
    10 => 22
    11 => 25
    12 => 23
    13 => 24
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#739
      +name: "INTEGER"
    }
    2 => Doctrine\DBAL\ParameterType {#739}
    3 => Doctrine\DBAL\ParameterType {#739}
    4 => Doctrine\DBAL\ParameterType {#739}
    5 => Doctrine\DBAL\ParameterType {#739}
    6 => Doctrine\DBAL\ParameterType {#739}
    7 => Doctrine\DBAL\ParameterType {#739}
    8 => Doctrine\DBAL\ParameterType {#739}
    9 => Doctrine\DBAL\ParameterType {#739}
    10 => Doctrine\DBAL\ParameterType {#739}
    11 => Doctrine\DBAL\ParameterType {#739}
    12 => Doctrine\DBAL\ParameterType {#739}
    13 => Doctrine\DBAL\ParameterType {#739}
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.name AS name_2, t0.country_code AS country_code_3, t0.owner_id AS owner_id_4 FROM destination t0 WHERE t0.id = ?"
  "params" => [
    1 => 7
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#739
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.category AS category_2, t0.daily_rate AS daily_rate_3, t0.destination_id AS destination_id_4 FROM allowance_rate t0 WHERE t0.destination_id = ?"
  "params" => [
    1 => 7
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#739
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.name AS name_2, t0.country_code AS country_code_3, t0.owner_id AS owner_id_4 FROM destination t0 WHERE t0.id = ?"
  "params" => [
    1 => 8
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#739
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.category AS category_2, t0.daily_rate AS daily_rate_3, t0.destination_id AS destination_id_4 FROM allowance_rate t0 WHERE t0.destination_id = ?"
  "params" => [
    1 => 8
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#739
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.name AS name_2, t0.country_code AS country_code_3, t0.owner_id AS owner_id_4 FROM destination t0 WHERE t0.id = ?"
  "params" => [
    1 => 9
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#739
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.category AS category_2, t0.daily_rate AS daily_rate_3, t0.destination_id AS destination_id_4 FROM allowance_rate t0 WHERE t0.destination_id = ?"
  "params" => [
    1 => 9
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#739
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.name AS name_2, t0.country_code AS country_code_3, t0.owner_id AS owner_id_4 FROM destination t0 WHERE t0.id = ?"
  "params" => [
    1 => 10
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#739
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.category AS category_2, t0.daily_rate AS daily_rate_3, t0.destination_id AS destination_id_4 FROM allowance_rate t0 WHERE t0.destination_id = ?"
  "params" => [
    1 => 10
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#739
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.name AS name_2, t0.country_code AS country_code_3, t0.owner_id AS owner_id_4 FROM destination t0 WHERE t0.id = ?"
  "params" => [
    1 => 11
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#739
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.category AS category_2, t0.daily_rate AS daily_rate_3, t0.destination_id AS destination_id_4 FROM allowance_rate t0 WHERE t0.destination_id = ?"
  "params" => [
    1 => 11
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#739
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.name AS name_2, t0.country_code AS country_code_3, t0.owner_id AS owner_id_4 FROM destination t0 WHERE t0.id = ?"
  "params" => [
    1 => 13
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#739
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.category AS category_2, t0.daily_rate AS daily_rate_3, t0.destination_id AS destination_id_4 FROM allowance_rate t0 WHERE t0.destination_id = ?"
  "params" => [
    1 => 13
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#739
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.name AS name_2, t0.country_code AS country_code_3, t0.owner_id AS owner_id_4 FROM destination t0 WHERE t0.id = ?"
  "params" => [
    1 => 14
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#739
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.category AS category_2, t0.daily_rate AS daily_rate_3, t0.destination_id AS destination_id_4 FROM allowance_rate t0 WHERE t0.destination_id = ?"
  "params" => [
    1 => 14
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#739
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.name AS name_2, t0.country_code AS country_code_3, t0.owner_id AS owner_id_4 FROM destination t0 WHERE t0.id = ?"
  "params" => [
    1 => 12
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#739
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.category AS category_2, t0.daily_rate AS daily_rate_3, t0.destination_id AS destination_id_4 FROM allowance_rate t0 WHERE t0.destination_id = ?"
  "params" => [
    1 => 12
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#739
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.name AS name_2, t0.country_code AS country_code_3, t0.owner_id AS owner_id_4 FROM destination t0 WHERE t0.id = ?"
  "params" => [
    1 => 15
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#739
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.category AS category_2, t0.daily_rate AS daily_rate_3, t0.destination_id AS destination_id_4 FROM allowance_rate t0 WHERE t0.destination_id = ?"
  "params" => [
    1 => 15
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#739
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.name AS name_2, t0.country_code AS country_code_3, t0.owner_id AS owner_id_4 FROM destination t0 WHERE t0.id = ?"
  "params" => [
    1 => 16
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#739
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.category AS category_2, t0.daily_rate AS daily_rate_3, t0.destination_id AS destination_id_4 FROM allowance_rate t0 WHERE t0.destination_id = ?"
  "params" => [
    1 => 16
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#739
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT t0_.start_date AS start_date_0, t0_.end_date AS end_date_1 FROM trip_segment t0_ INNER JOIN trip t1_ ON t0_.trip_id = t1_.id WHERE t1_.owner_id = ?"
  "params" => [
    1 => 1
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#739
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT t0_.id AS id_0, t0_.name AS name_1, t0_.emoji AS emoji_2, t0_.description AS description_3, t0_.sort_order AS sort_order_4, t0_.owner_id AS owner_id_5 FROM trip t0_ WHERE t0_.owner_id = ? ORDER BY t0_.sort_order ASC, t0_.name ASC"
  "params" => [
    1 => 1
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#739
      +name: "INTEGER"
    }
  ]
]

[
  "key" => "_security_main"
]