1
0.43 ms
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 = ?
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 = 1 ;
Copy
2
0.71 ms
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 "
]
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 = 1 AND t0_ . start_date < = '2026-12-31 00:00:00' AND t0_ . end_date > = '2026-01-01 00:00:00' ORDER BY t0_ . start_date ASC , t0_ . sort_order ASC ;
Copy
3
0.84 ms
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
]
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 (13 , 14 , 15 , 16 , 17 , 18 , 19 , 20 , 21 , 22 , 25 , 23 , 24 ) ORDER BY c0_ . category ASC , c0_ . label ASC ;
Copy
4
0.56 ms
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 = ?
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 = 7 ;
Copy
5
0.49 ms
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 = ?
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 = 7 ;
Copy
6
0.44 ms
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 = ?
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 = 8 ;
Copy
7
0.38 ms
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 = ?
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 = 8 ;
Copy
8
0.32 ms
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 = ?
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 = 9 ;
Copy
9
0.29 ms
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 = ?
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 = 9 ;
Copy
10
0.29 ms
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 = ?
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 = 10 ;
Copy
11
0.33 ms
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 = ?
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 = 10 ;
Copy
12
0.35 ms
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 = ?
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 = 11 ;
Copy
13
0.33 ms
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 = ?
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 = 11 ;
Copy
14
0.31 ms
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 = ?
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 = 13 ;
Copy
15
0.28 ms
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 = ?
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 = 13 ;
Copy
16
0.28 ms
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 = ?
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 = 14 ;
Copy
17
0.31 ms
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 = ?
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 = 14 ;
Copy
18
0.29 ms
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 = ?
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 = 12 ;
Copy
19
0.29 ms
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 = ?
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 = 12 ;
Copy
20
0.36 ms
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 = ?
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 = 15 ;
Copy
21
0.29 ms
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 = ?
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 = 15 ;
Copy
22
0.30 ms
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 = ?
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 = 16 ;
Copy
23
0.36 ms
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 = ?
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 = 16 ;
Copy
24
0.54 ms
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 = ?
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 = 1 ;
Copy
25
0.54 ms
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
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 = 1 ORDER BY t0_ . sort_order ASC , t0_ . name ASC ;
Copy