GET https://travel.fna.cx/kosten?tab=final&year=2026

Query Metrics

25 Database Queries
7 Different statements
9.48 ms Query time
0 Invalid entities
125 Managed entities

Grouped Statements

Show all queries

Time Count Info
3.24 ms
(34.17%)
10
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 = ?
Parameters:
[
  7
]
3.21 ms
(33.81%)
10
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 = ?
Parameters:
[
  7
]
0.77 ms
(8.11%)
1
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
Parameters:
[
  13
  14
  15
  16
  17
  18
  19
  20
  21
  22
  25
  23
  24
]
0.75 ms
(7.92%)
1
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
Parameters:
[
  1
  "2026-12-31 00:00:00"
  "2026-01-01 00:00:00"
]
0.59 ms
(6.22%)
1
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 = ?
Parameters:
[
  1
]
0.53 ms
(5.59%)
1
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
Parameters:
[
  1
]
0.40 ms
(4.18%)
1
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 = ?
Parameters:
[
  1
]

Database Connections

Name Service
default doctrine.dbal.default_connection

Entity Managers

Name Service
default doctrine.orm.default_entity_manager

Second Level Cache

Second Level Cache is not enabled.

Managed Entities

default entity manager

Class Amount of managed objects
App\Entity\CostItem 78
App\Entity\AllowanceRate 19
App\Entity\TripSegment 13
App\Entity\Destination 10
App\Entity\Trip 4
App\Entity\User 1

Entities Mapping

Class Mapping errors
App\Entity\User No errors.
App\Entity\TripSegment No errors.
App\Entity\Trip No errors.
App\Entity\Destination No errors.
App\Entity\ItineraryItem No errors.
App\Entity\CostItem No errors.
App\Entity\AllowanceRate No errors.