Query Metrics
102
Database Queries
12
Different statements
7.21 ms
Query time
0
Invalid entities
Queries
| #▲ | Time | Info |
|---|---|---|
| 1 | 0.36 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.short_description AS short_description_4, t0.description AS description_5, t0.riverside AS riverside_6, t0.list_order AS list_order_7, t0.module_order AS module_order_8, t0.active AS active_9, t0.created_at AS created_at_10, t0.created_by AS created_by_11, t0.updated_at AS updated_at_12, t0.updated_by AS updated_by_13, t0.main_destination_id AS main_destination_id_14, t15.itineraries_count AS itineraries_count_16, t15.active_cruises_count AS active_cruises_count_17, t15.medias_count AS medias_count_18, t15.destination_secondary_id AS destination_secondary_id_19 FROM common_destination_secondary t0 LEFT JOIN common_destination_secondary_computed t15 ON t15.destination_secondary_id = t0.id WHERE t0.id IN (?)
Parameters:
[
"50"
]
|
| 2 | 0.32 ms |
SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.list_order AS list_order_2 FROM common_destination_main c0_ WHERE c0_.active = ? GROUP BY c0_.id ORDER BY c0_.list_order ASC, c0_.name ASC
Parameters:
[
1
]
|
| 3 | 0.11 ms |
SELECT t0.destination_secondaries_count AS destination_secondaries_count_1, t0.itineraries_count AS itineraries_count_2, t0.active_cruises_count AS active_cruises_count_3, t0.medias_count AS medias_count_4, t0.destination_main_id AS destination_main_id_5 FROM common_destination_main_computed t0 WHERE t0.destination_main_id = ?
Parameters:
[
13
]
|
| 4 | 0.05 ms |
SELECT t0.destination_secondaries_count AS destination_secondaries_count_1, t0.itineraries_count AS itineraries_count_2, t0.active_cruises_count AS active_cruises_count_3, t0.medias_count AS medias_count_4, t0.destination_main_id AS destination_main_id_5 FROM common_destination_main_computed t0 WHERE t0.destination_main_id = ?
Parameters:
[
22
]
|
| 5 | 0.04 ms |
SELECT t0.destination_secondaries_count AS destination_secondaries_count_1, t0.itineraries_count AS itineraries_count_2, t0.active_cruises_count AS active_cruises_count_3, t0.medias_count AS medias_count_4, t0.destination_main_id AS destination_main_id_5 FROM common_destination_main_computed t0 WHERE t0.destination_main_id = ?
Parameters:
[
21
]
|
| 6 | 0.03 ms |
SELECT t0.destination_secondaries_count AS destination_secondaries_count_1, t0.itineraries_count AS itineraries_count_2, t0.active_cruises_count AS active_cruises_count_3, t0.medias_count AS medias_count_4, t0.destination_main_id AS destination_main_id_5 FROM common_destination_main_computed t0 WHERE t0.destination_main_id = ?
Parameters:
[
9
]
|
| 7 | 0.03 ms |
SELECT t0.destination_secondaries_count AS destination_secondaries_count_1, t0.itineraries_count AS itineraries_count_2, t0.active_cruises_count AS active_cruises_count_3, t0.medias_count AS medias_count_4, t0.destination_main_id AS destination_main_id_5 FROM common_destination_main_computed t0 WHERE t0.destination_main_id = ?
Parameters:
[
16
]
|
| 8 | 0.03 ms |
SELECT t0.destination_secondaries_count AS destination_secondaries_count_1, t0.itineraries_count AS itineraries_count_2, t0.active_cruises_count AS active_cruises_count_3, t0.medias_count AS medias_count_4, t0.destination_main_id AS destination_main_id_5 FROM common_destination_main_computed t0 WHERE t0.destination_main_id = ?
Parameters:
[
5
]
|
| 9 | 0.03 ms |
SELECT t0.destination_secondaries_count AS destination_secondaries_count_1, t0.itineraries_count AS itineraries_count_2, t0.active_cruises_count AS active_cruises_count_3, t0.medias_count AS medias_count_4, t0.destination_main_id AS destination_main_id_5 FROM common_destination_main_computed t0 WHERE t0.destination_main_id = ?
Parameters:
[
6
]
|
| 10 | 0.04 ms |
SELECT t0.destination_secondaries_count AS destination_secondaries_count_1, t0.itineraries_count AS itineraries_count_2, t0.active_cruises_count AS active_cruises_count_3, t0.medias_count AS medias_count_4, t0.destination_main_id AS destination_main_id_5 FROM common_destination_main_computed t0 WHERE t0.destination_main_id = ?
Parameters:
[
14
]
|
| 11 | 0.04 ms |
SELECT t0.destination_secondaries_count AS destination_secondaries_count_1, t0.itineraries_count AS itineraries_count_2, t0.active_cruises_count AS active_cruises_count_3, t0.medias_count AS medias_count_4, t0.destination_main_id AS destination_main_id_5 FROM common_destination_main_computed t0 WHERE t0.destination_main_id = ?
Parameters:
[
18
]
|
| 12 | 0.03 ms |
SELECT t0.destination_secondaries_count AS destination_secondaries_count_1, t0.itineraries_count AS itineraries_count_2, t0.active_cruises_count AS active_cruises_count_3, t0.medias_count AS medias_count_4, t0.destination_main_id AS destination_main_id_5 FROM common_destination_main_computed t0 WHERE t0.destination_main_id = ?
Parameters:
[
2
]
|
| 13 | 0.03 ms |
SELECT t0.destination_secondaries_count AS destination_secondaries_count_1, t0.itineraries_count AS itineraries_count_2, t0.active_cruises_count AS active_cruises_count_3, t0.medias_count AS medias_count_4, t0.destination_main_id AS destination_main_id_5 FROM common_destination_main_computed t0 WHERE t0.destination_main_id = ?
Parameters:
[
19
]
|
| 14 | 0.03 ms |
SELECT t0.destination_secondaries_count AS destination_secondaries_count_1, t0.itineraries_count AS itineraries_count_2, t0.active_cruises_count AS active_cruises_count_3, t0.medias_count AS medias_count_4, t0.destination_main_id AS destination_main_id_5 FROM common_destination_main_computed t0 WHERE t0.destination_main_id = ?
Parameters:
[
10
]
|
| 15 | 0.03 ms |
SELECT t0.destination_secondaries_count AS destination_secondaries_count_1, t0.itineraries_count AS itineraries_count_2, t0.active_cruises_count AS active_cruises_count_3, t0.medias_count AS medias_count_4, t0.destination_main_id AS destination_main_id_5 FROM common_destination_main_computed t0 WHERE t0.destination_main_id = ?
Parameters:
[
23
]
|
| 16 | 0.03 ms |
SELECT t0.destination_secondaries_count AS destination_secondaries_count_1, t0.itineraries_count AS itineraries_count_2, t0.active_cruises_count AS active_cruises_count_3, t0.medias_count AS medias_count_4, t0.destination_main_id AS destination_main_id_5 FROM common_destination_main_computed t0 WHERE t0.destination_main_id = ?
Parameters:
[
1
]
|
| 17 | 0.03 ms |
SELECT t0.destination_secondaries_count AS destination_secondaries_count_1, t0.itineraries_count AS itineraries_count_2, t0.active_cruises_count AS active_cruises_count_3, t0.medias_count AS medias_count_4, t0.destination_main_id AS destination_main_id_5 FROM common_destination_main_computed t0 WHERE t0.destination_main_id = ?
Parameters:
[
20
]
|
| 18 | 0.03 ms |
SELECT t0.destination_secondaries_count AS destination_secondaries_count_1, t0.itineraries_count AS itineraries_count_2, t0.active_cruises_count AS active_cruises_count_3, t0.medias_count AS medias_count_4, t0.destination_main_id AS destination_main_id_5 FROM common_destination_main_computed t0 WHERE t0.destination_main_id = ?
Parameters:
[
4
]
|
| 19 | 0.03 ms |
SELECT t0.destination_secondaries_count AS destination_secondaries_count_1, t0.itineraries_count AS itineraries_count_2, t0.active_cruises_count AS active_cruises_count_3, t0.medias_count AS medias_count_4, t0.destination_main_id AS destination_main_id_5 FROM common_destination_main_computed t0 WHERE t0.destination_main_id = ?
Parameters:
[
3
]
|
| 20 | 0.03 ms |
SELECT t0.destination_secondaries_count AS destination_secondaries_count_1, t0.itineraries_count AS itineraries_count_2, t0.active_cruises_count AS active_cruises_count_3, t0.medias_count AS medias_count_4, t0.destination_main_id AS destination_main_id_5 FROM common_destination_main_computed t0 WHERE t0.destination_main_id = ?
Parameters:
[
11
]
|
| 21 | 0.03 ms |
SELECT t0.destination_secondaries_count AS destination_secondaries_count_1, t0.itineraries_count AS itineraries_count_2, t0.active_cruises_count AS active_cruises_count_3, t0.medias_count AS medias_count_4, t0.destination_main_id AS destination_main_id_5 FROM common_destination_main_computed t0 WHERE t0.destination_main_id = ?
Parameters:
[
12
]
|
| 22 | 0.03 ms |
SELECT t0.destination_secondaries_count AS destination_secondaries_count_1, t0.itineraries_count AS itineraries_count_2, t0.active_cruises_count AS active_cruises_count_3, t0.medias_count AS medias_count_4, t0.destination_main_id AS destination_main_id_5 FROM common_destination_main_computed t0 WHERE t0.destination_main_id = ?
Parameters:
[
17
]
|
| 23 | 0.03 ms |
SELECT t0.destination_secondaries_count AS destination_secondaries_count_1, t0.itineraries_count AS itineraries_count_2, t0.active_cruises_count AS active_cruises_count_3, t0.medias_count AS medias_count_4, t0.destination_main_id AS destination_main_id_5 FROM common_destination_main_computed t0 WHERE t0.destination_main_id = ?
Parameters:
[
15
]
|
| 24 | 0.03 ms |
SELECT t0.destination_secondaries_count AS destination_secondaries_count_1, t0.itineraries_count AS itineraries_count_2, t0.active_cruises_count AS active_cruises_count_3, t0.medias_count AS medias_count_4, t0.destination_main_id AS destination_main_id_5 FROM common_destination_main_computed t0 WHERE t0.destination_main_id = ?
Parameters:
[
7
]
|
| 25 | 0.03 ms |
SELECT t0.destination_secondaries_count AS destination_secondaries_count_1, t0.itineraries_count AS itineraries_count_2, t0.active_cruises_count AS active_cruises_count_3, t0.medias_count AS medias_count_4, t0.destination_main_id AS destination_main_id_5 FROM common_destination_main_computed t0 WHERE t0.destination_main_id = ?
Parameters:
[
8
]
|
| 26 | 0.29 ms |
SELECT c0_.id AS id_0, c0_.name AS name_1, c1_.id AS id_2, c1_.name AS name_3, c0_.main_destination_id AS main_destination_id_4 FROM common_destination_secondary c0_ INNER JOIN common_destination_main c1_ ON c0_.main_destination_id = c1_.id WHERE c0_.active = ? AND c1_.active = ? GROUP BY c0_.id ORDER BY c0_.list_order ASC, c0_.name ASC
Parameters:
[ 1 1 ] |
| 27 | 0.05 ms |
SELECT t0.itineraries_count AS itineraries_count_1, t0.active_cruises_count AS active_cruises_count_2, t0.medias_count AS medias_count_3, t0.destination_secondary_id AS destination_secondary_id_4 FROM common_destination_secondary_computed t0 WHERE t0.destination_secondary_id = ?
Parameters:
[
5
]
|
| 28 | 0.04 ms |
SELECT t0.itineraries_count AS itineraries_count_1, t0.active_cruises_count AS active_cruises_count_2, t0.medias_count AS medias_count_3, t0.destination_secondary_id AS destination_secondary_id_4 FROM common_destination_secondary_computed t0 WHERE t0.destination_secondary_id = ?
Parameters:
[
55
]
|
| 29 | 0.03 ms |
SELECT t0.itineraries_count AS itineraries_count_1, t0.active_cruises_count AS active_cruises_count_2, t0.medias_count AS medias_count_3, t0.destination_secondary_id AS destination_secondary_id_4 FROM common_destination_secondary_computed t0 WHERE t0.destination_secondary_id = ?
Parameters:
[
23
]
|
| 30 | 0.03 ms |
SELECT t0.itineraries_count AS itineraries_count_1, t0.active_cruises_count AS active_cruises_count_2, t0.medias_count AS medias_count_3, t0.destination_secondary_id AS destination_secondary_id_4 FROM common_destination_secondary_computed t0 WHERE t0.destination_secondary_id = ?
Parameters:
[
54
]
|
| 31 | 0.03 ms |
SELECT t0.itineraries_count AS itineraries_count_1, t0.active_cruises_count AS active_cruises_count_2, t0.medias_count AS medias_count_3, t0.destination_secondary_id AS destination_secondary_id_4 FROM common_destination_secondary_computed t0 WHERE t0.destination_secondary_id = ?
Parameters:
[
49
]
|
| 32 | 0.03 ms |
SELECT t0.itineraries_count AS itineraries_count_1, t0.active_cruises_count AS active_cruises_count_2, t0.medias_count AS medias_count_3, t0.destination_secondary_id AS destination_secondary_id_4 FROM common_destination_secondary_computed t0 WHERE t0.destination_secondary_id = ?
Parameters:
[
47
]
|
| 33 | 0.03 ms |
SELECT t0.itineraries_count AS itineraries_count_1, t0.active_cruises_count AS active_cruises_count_2, t0.medias_count AS medias_count_3, t0.destination_secondary_id AS destination_secondary_id_4 FROM common_destination_secondary_computed t0 WHERE t0.destination_secondary_id = ?
Parameters:
[
21
]
|
| 34 | 0.03 ms |
SELECT t0.itineraries_count AS itineraries_count_1, t0.active_cruises_count AS active_cruises_count_2, t0.medias_count AS medias_count_3, t0.destination_secondary_id AS destination_secondary_id_4 FROM common_destination_secondary_computed t0 WHERE t0.destination_secondary_id = ?
Parameters:
[
16
]
|
| 35 | 0.03 ms |
SELECT t0.itineraries_count AS itineraries_count_1, t0.active_cruises_count AS active_cruises_count_2, t0.medias_count AS medias_count_3, t0.destination_secondary_id AS destination_secondary_id_4 FROM common_destination_secondary_computed t0 WHERE t0.destination_secondary_id = ?
Parameters:
[
42
]
|
| 36 | 0.03 ms |
SELECT t0.itineraries_count AS itineraries_count_1, t0.active_cruises_count AS active_cruises_count_2, t0.medias_count AS medias_count_3, t0.destination_secondary_id AS destination_secondary_id_4 FROM common_destination_secondary_computed t0 WHERE t0.destination_secondary_id = ?
Parameters:
[
10
]
|
| 37 | 0.03 ms |
SELECT t0.itineraries_count AS itineraries_count_1, t0.active_cruises_count AS active_cruises_count_2, t0.medias_count AS medias_count_3, t0.destination_secondary_id AS destination_secondary_id_4 FROM common_destination_secondary_computed t0 WHERE t0.destination_secondary_id = ?
Parameters:
[
26
]
|
| 38 | 0.03 ms |
SELECT t0.itineraries_count AS itineraries_count_1, t0.active_cruises_count AS active_cruises_count_2, t0.medias_count AS medias_count_3, t0.destination_secondary_id AS destination_secondary_id_4 FROM common_destination_secondary_computed t0 WHERE t0.destination_secondary_id = ?
Parameters:
[
22
]
|
| 39 | 0.03 ms |
SELECT t0.itineraries_count AS itineraries_count_1, t0.active_cruises_count AS active_cruises_count_2, t0.medias_count AS medias_count_3, t0.destination_secondary_id AS destination_secondary_id_4 FROM common_destination_secondary_computed t0 WHERE t0.destination_secondary_id = ?
Parameters:
[
25
]
|
| 40 | 0.03 ms |
SELECT t0.itineraries_count AS itineraries_count_1, t0.active_cruises_count AS active_cruises_count_2, t0.medias_count AS medias_count_3, t0.destination_secondary_id AS destination_secondary_id_4 FROM common_destination_secondary_computed t0 WHERE t0.destination_secondary_id = ?
Parameters:
[
7
]
|
| 41 | 0.03 ms |
SELECT t0.itineraries_count AS itineraries_count_1, t0.active_cruises_count AS active_cruises_count_2, t0.medias_count AS medias_count_3, t0.destination_secondary_id AS destination_secondary_id_4 FROM common_destination_secondary_computed t0 WHERE t0.destination_secondary_id = ?
Parameters:
[
15
]
|
| 42 | 0.03 ms |
SELECT t0.itineraries_count AS itineraries_count_1, t0.active_cruises_count AS active_cruises_count_2, t0.medias_count AS medias_count_3, t0.destination_secondary_id AS destination_secondary_id_4 FROM common_destination_secondary_computed t0 WHERE t0.destination_secondary_id = ?
Parameters:
[
24
]
|
| 43 | 0.03 ms |
SELECT t0.itineraries_count AS itineraries_count_1, t0.active_cruises_count AS active_cruises_count_2, t0.medias_count AS medias_count_3, t0.destination_secondary_id AS destination_secondary_id_4 FROM common_destination_secondary_computed t0 WHERE t0.destination_secondary_id = ?
Parameters:
[
31
]
|
| 44 | 0.03 ms |
SELECT t0.itineraries_count AS itineraries_count_1, t0.active_cruises_count AS active_cruises_count_2, t0.medias_count AS medias_count_3, t0.destination_secondary_id AS destination_secondary_id_4 FROM common_destination_secondary_computed t0 WHERE t0.destination_secondary_id = ?
Parameters:
[
35
]
|
| 45 | 0.03 ms |
SELECT t0.itineraries_count AS itineraries_count_1, t0.active_cruises_count AS active_cruises_count_2, t0.medias_count AS medias_count_3, t0.destination_secondary_id AS destination_secondary_id_4 FROM common_destination_secondary_computed t0 WHERE t0.destination_secondary_id = ?
Parameters:
[
38
]
|
| 46 | 0.02 ms |
SELECT t0.itineraries_count AS itineraries_count_1, t0.active_cruises_count AS active_cruises_count_2, t0.medias_count AS medias_count_3, t0.destination_secondary_id AS destination_secondary_id_4 FROM common_destination_secondary_computed t0 WHERE t0.destination_secondary_id = ?
Parameters:
[
41
]
|
| 47 | 0.03 ms |
SELECT t0.itineraries_count AS itineraries_count_1, t0.active_cruises_count AS active_cruises_count_2, t0.medias_count AS medias_count_3, t0.destination_secondary_id AS destination_secondary_id_4 FROM common_destination_secondary_computed t0 WHERE t0.destination_secondary_id = ?
Parameters:
[
40
]
|
| 48 | 0.03 ms |
SELECT t0.itineraries_count AS itineraries_count_1, t0.active_cruises_count AS active_cruises_count_2, t0.medias_count AS medias_count_3, t0.destination_secondary_id AS destination_secondary_id_4 FROM common_destination_secondary_computed t0 WHERE t0.destination_secondary_id = ?
Parameters:
[
19
]
|
| 49 | 0.03 ms |
SELECT t0.itineraries_count AS itineraries_count_1, t0.active_cruises_count AS active_cruises_count_2, t0.medias_count AS medias_count_3, t0.destination_secondary_id AS destination_secondary_id_4 FROM common_destination_secondary_computed t0 WHERE t0.destination_secondary_id = ?
Parameters:
[
8
]
|
| 50 | 0.02 ms |
SELECT t0.itineraries_count AS itineraries_count_1, t0.active_cruises_count AS active_cruises_count_2, t0.medias_count AS medias_count_3, t0.destination_secondary_id AS destination_secondary_id_4 FROM common_destination_secondary_computed t0 WHERE t0.destination_secondary_id = ?
Parameters:
[
13
]
|
| 51 | 0.03 ms |
SELECT t0.itineraries_count AS itineraries_count_1, t0.active_cruises_count AS active_cruises_count_2, t0.medias_count AS medias_count_3, t0.destination_secondary_id AS destination_secondary_id_4 FROM common_destination_secondary_computed t0 WHERE t0.destination_secondary_id = ?
Parameters:
[
39
]
|
| 52 | 0.03 ms |
SELECT t0.itineraries_count AS itineraries_count_1, t0.active_cruises_count AS active_cruises_count_2, t0.medias_count AS medias_count_3, t0.destination_secondary_id AS destination_secondary_id_4 FROM common_destination_secondary_computed t0 WHERE t0.destination_secondary_id = ?
Parameters:
[
6
]
|
| 53 | 0.03 ms |
SELECT t0.itineraries_count AS itineraries_count_1, t0.active_cruises_count AS active_cruises_count_2, t0.medias_count AS medias_count_3, t0.destination_secondary_id AS destination_secondary_id_4 FROM common_destination_secondary_computed t0 WHERE t0.destination_secondary_id = ?
Parameters:
[
43
]
|
| 54 | 0.03 ms |
SELECT t0.itineraries_count AS itineraries_count_1, t0.active_cruises_count AS active_cruises_count_2, t0.medias_count AS medias_count_3, t0.destination_secondary_id AS destination_secondary_id_4 FROM common_destination_secondary_computed t0 WHERE t0.destination_secondary_id = ?
Parameters:
[
28
]
|
| 55 | 0.03 ms |
SELECT t0.itineraries_count AS itineraries_count_1, t0.active_cruises_count AS active_cruises_count_2, t0.medias_count AS medias_count_3, t0.destination_secondary_id AS destination_secondary_id_4 FROM common_destination_secondary_computed t0 WHERE t0.destination_secondary_id = ?
Parameters:
[
12
]
|
| 56 | 0.03 ms |
SELECT t0.itineraries_count AS itineraries_count_1, t0.active_cruises_count AS active_cruises_count_2, t0.medias_count AS medias_count_3, t0.destination_secondary_id AS destination_secondary_id_4 FROM common_destination_secondary_computed t0 WHERE t0.destination_secondary_id = ?
Parameters:
[
33
]
|
| 57 | 0.03 ms |
SELECT t0.itineraries_count AS itineraries_count_1, t0.active_cruises_count AS active_cruises_count_2, t0.medias_count AS medias_count_3, t0.destination_secondary_id AS destination_secondary_id_4 FROM common_destination_secondary_computed t0 WHERE t0.destination_secondary_id = ?
Parameters:
[
32
]
|
| 58 | 0.03 ms |
SELECT t0.itineraries_count AS itineraries_count_1, t0.active_cruises_count AS active_cruises_count_2, t0.medias_count AS medias_count_3, t0.destination_secondary_id AS destination_secondary_id_4 FROM common_destination_secondary_computed t0 WHERE t0.destination_secondary_id = ?
Parameters:
[
53
]
|
| 59 | 0.03 ms |
SELECT t0.itineraries_count AS itineraries_count_1, t0.active_cruises_count AS active_cruises_count_2, t0.medias_count AS medias_count_3, t0.destination_secondary_id AS destination_secondary_id_4 FROM common_destination_secondary_computed t0 WHERE t0.destination_secondary_id = ?
Parameters:
[
11
]
|
| 60 | 0.03 ms |
SELECT t0.itineraries_count AS itineraries_count_1, t0.active_cruises_count AS active_cruises_count_2, t0.medias_count AS medias_count_3, t0.destination_secondary_id AS destination_secondary_id_4 FROM common_destination_secondary_computed t0 WHERE t0.destination_secondary_id = ?
Parameters:
[
20
]
|
| 61 | 0.03 ms |
SELECT t0.itineraries_count AS itineraries_count_1, t0.active_cruises_count AS active_cruises_count_2, t0.medias_count AS medias_count_3, t0.destination_secondary_id AS destination_secondary_id_4 FROM common_destination_secondary_computed t0 WHERE t0.destination_secondary_id = ?
Parameters:
[
34
]
|
| 62 | 0.03 ms |
SELECT t0.itineraries_count AS itineraries_count_1, t0.active_cruises_count AS active_cruises_count_2, t0.medias_count AS medias_count_3, t0.destination_secondary_id AS destination_secondary_id_4 FROM common_destination_secondary_computed t0 WHERE t0.destination_secondary_id = ?
Parameters:
[
1
]
|
| 63 | 0.03 ms |
SELECT t0.itineraries_count AS itineraries_count_1, t0.active_cruises_count AS active_cruises_count_2, t0.medias_count AS medias_count_3, t0.destination_secondary_id AS destination_secondary_id_4 FROM common_destination_secondary_computed t0 WHERE t0.destination_secondary_id = ?
Parameters:
[
52
]
|
| 64 | 0.03 ms |
SELECT t0.itineraries_count AS itineraries_count_1, t0.active_cruises_count AS active_cruises_count_2, t0.medias_count AS medias_count_3, t0.destination_secondary_id AS destination_secondary_id_4 FROM common_destination_secondary_computed t0 WHERE t0.destination_secondary_id = ?
Parameters:
[
27
]
|
| 65 | 0.03 ms |
SELECT t0.itineraries_count AS itineraries_count_1, t0.active_cruises_count AS active_cruises_count_2, t0.medias_count AS medias_count_3, t0.destination_secondary_id AS destination_secondary_id_4 FROM common_destination_secondary_computed t0 WHERE t0.destination_secondary_id = ?
Parameters:
[
56
]
|
| 66 | 0.03 ms |
SELECT t0.itineraries_count AS itineraries_count_1, t0.active_cruises_count AS active_cruises_count_2, t0.medias_count AS medias_count_3, t0.destination_secondary_id AS destination_secondary_id_4 FROM common_destination_secondary_computed t0 WHERE t0.destination_secondary_id = ?
Parameters:
[
45
]
|
| 67 | 0.03 ms |
SELECT t0.itineraries_count AS itineraries_count_1, t0.active_cruises_count AS active_cruises_count_2, t0.medias_count AS medias_count_3, t0.destination_secondary_id AS destination_secondary_id_4 FROM common_destination_secondary_computed t0 WHERE t0.destination_secondary_id = ?
Parameters:
[
36
]
|
| 68 | 0.03 ms |
SELECT t0.itineraries_count AS itineraries_count_1, t0.active_cruises_count AS active_cruises_count_2, t0.medias_count AS medias_count_3, t0.destination_secondary_id AS destination_secondary_id_4 FROM common_destination_secondary_computed t0 WHERE t0.destination_secondary_id = ?
Parameters:
[
37
]
|
| 69 | 0.03 ms |
SELECT t0.itineraries_count AS itineraries_count_1, t0.active_cruises_count AS active_cruises_count_2, t0.medias_count AS medias_count_3, t0.destination_secondary_id AS destination_secondary_id_4 FROM common_destination_secondary_computed t0 WHERE t0.destination_secondary_id = ?
Parameters:
[
46
]
|
| 70 | 0.03 ms |
SELECT t0.itineraries_count AS itineraries_count_1, t0.active_cruises_count AS active_cruises_count_2, t0.medias_count AS medias_count_3, t0.destination_secondary_id AS destination_secondary_id_4 FROM common_destination_secondary_computed t0 WHERE t0.destination_secondary_id = ?
Parameters:
[
57
]
|
| 71 | 0.03 ms |
SELECT t0.itineraries_count AS itineraries_count_1, t0.active_cruises_count AS active_cruises_count_2, t0.medias_count AS medias_count_3, t0.destination_secondary_id AS destination_secondary_id_4 FROM common_destination_secondary_computed t0 WHERE t0.destination_secondary_id = ?
Parameters:
[
48
]
|
| 72 | 0.03 ms |
SELECT t0.itineraries_count AS itineraries_count_1, t0.active_cruises_count AS active_cruises_count_2, t0.medias_count AS medias_count_3, t0.destination_secondary_id AS destination_secondary_id_4 FROM common_destination_secondary_computed t0 WHERE t0.destination_secondary_id = ?
Parameters:
[
29
]
|
| 73 | 0.03 ms |
SELECT t0.itineraries_count AS itineraries_count_1, t0.active_cruises_count AS active_cruises_count_2, t0.medias_count AS medias_count_3, t0.destination_secondary_id AS destination_secondary_id_4 FROM common_destination_secondary_computed t0 WHERE t0.destination_secondary_id = ?
Parameters:
[
30
]
|
| 74 | 0.03 ms |
SELECT t0.itineraries_count AS itineraries_count_1, t0.active_cruises_count AS active_cruises_count_2, t0.medias_count AS medias_count_3, t0.destination_secondary_id AS destination_secondary_id_4 FROM common_destination_secondary_computed t0 WHERE t0.destination_secondary_id = ?
Parameters:
[
44
]
|
| 75 | 0.03 ms |
SELECT t0.itineraries_count AS itineraries_count_1, t0.active_cruises_count AS active_cruises_count_2, t0.medias_count AS medias_count_3, t0.destination_secondary_id AS destination_secondary_id_4 FROM common_destination_secondary_computed t0 WHERE t0.destination_secondary_id = ?
Parameters:
[
51
]
|
| 76 | 1.14 ms |
SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.list_order AS list_order_2, c0_.offer_category_id AS offer_category_id_3, c0_.offer_type_id AS offer_type_id_4 FROM common_offer c0_ WHERE c0_.active = ? GROUP BY c0_.id ORDER BY c0_.list_order ASC, c0_.name ASC
Parameters:
[
1
]
|
| 77 | 0.18 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.description AS description_4, t0.icon AS icon_5, t0.icon_color_fill AS icon_color_fill_6, t0.icon_color_stroke AS icon_color_stroke_7, t0.icon_stroke_width AS icon_stroke_width_8, t0.icon_stroke_linecap AS icon_stroke_linecap_9, t0.icon_stroke_linejoin AS icon_stroke_linejoin_10, t0.color_fill AS color_fill_11, t0.color_stroke AS color_stroke_12, t0.color_font AS color_font_13, t0.list_order AS list_order_14, t0.active AS active_15, t0.created_at AS created_at_16, t0.created_by AS created_by_17, t0.updated_at AS updated_at_18, t0.updated_by AS updated_by_19 FROM common_offer_category t0 WHERE t0.id = ?
Parameters:
[
17
]
|
| 78 | 0.07 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.description AS description_4, t0.icon AS icon_5, t0.icon_color_fill AS icon_color_fill_6, t0.icon_color_stroke AS icon_color_stroke_7, t0.icon_stroke_width AS icon_stroke_width_8, t0.icon_stroke_linecap AS icon_stroke_linecap_9, t0.icon_stroke_linejoin AS icon_stroke_linejoin_10, t0.color_fill AS color_fill_11, t0.color_stroke AS color_stroke_12, t0.color_font AS color_font_13, t0.list_order AS list_order_14, t0.active AS active_15, t0.created_at AS created_at_16, t0.created_by AS created_by_17, t0.updated_at AS updated_at_18, t0.updated_by AS updated_by_19 FROM common_offer_category t0 WHERE t0.id = ?
Parameters:
[
5
]
|
| 79 | 0.05 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.description AS description_4, t0.icon AS icon_5, t0.icon_color_fill AS icon_color_fill_6, t0.icon_color_stroke AS icon_color_stroke_7, t0.icon_stroke_width AS icon_stroke_width_8, t0.icon_stroke_linecap AS icon_stroke_linecap_9, t0.icon_stroke_linejoin AS icon_stroke_linejoin_10, t0.color_fill AS color_fill_11, t0.color_stroke AS color_stroke_12, t0.color_font AS color_font_13, t0.list_order AS list_order_14, t0.active AS active_15, t0.created_at AS created_at_16, t0.created_by AS created_by_17, t0.updated_at AS updated_at_18, t0.updated_by AS updated_by_19 FROM common_offer_category t0 WHERE t0.id = ?
Parameters:
[
27
]
|
| 80 | 0.05 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.description AS description_4, t0.icon AS icon_5, t0.icon_color_fill AS icon_color_fill_6, t0.icon_color_stroke AS icon_color_stroke_7, t0.icon_stroke_width AS icon_stroke_width_8, t0.icon_stroke_linecap AS icon_stroke_linecap_9, t0.icon_stroke_linejoin AS icon_stroke_linejoin_10, t0.color_fill AS color_fill_11, t0.color_stroke AS color_stroke_12, t0.color_font AS color_font_13, t0.list_order AS list_order_14, t0.active AS active_15, t0.created_at AS created_at_16, t0.created_by AS created_by_17, t0.updated_at AS updated_at_18, t0.updated_by AS updated_by_19 FROM common_offer_category t0 WHERE t0.id = ?
Parameters:
[
6
]
|
| 81 | 0.05 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.description AS description_4, t0.icon AS icon_5, t0.icon_color_fill AS icon_color_fill_6, t0.icon_color_stroke AS icon_color_stroke_7, t0.icon_stroke_width AS icon_stroke_width_8, t0.icon_stroke_linecap AS icon_stroke_linecap_9, t0.icon_stroke_linejoin AS icon_stroke_linejoin_10, t0.color_fill AS color_fill_11, t0.color_stroke AS color_stroke_12, t0.color_font AS color_font_13, t0.list_order AS list_order_14, t0.active AS active_15, t0.created_at AS created_at_16, t0.created_by AS created_by_17, t0.updated_at AS updated_at_18, t0.updated_by AS updated_by_19 FROM common_offer_category t0 WHERE t0.id = ?
Parameters:
[
10
]
|
| 82 | 0.05 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.description AS description_4, t0.icon AS icon_5, t0.icon_color_fill AS icon_color_fill_6, t0.icon_color_stroke AS icon_color_stroke_7, t0.icon_stroke_width AS icon_stroke_width_8, t0.icon_stroke_linecap AS icon_stroke_linecap_9, t0.icon_stroke_linejoin AS icon_stroke_linejoin_10, t0.color_fill AS color_fill_11, t0.color_stroke AS color_stroke_12, t0.color_font AS color_font_13, t0.list_order AS list_order_14, t0.active AS active_15, t0.created_at AS created_at_16, t0.created_by AS created_by_17, t0.updated_at AS updated_at_18, t0.updated_by AS updated_by_19 FROM common_offer_category t0 WHERE t0.id = ?
Parameters:
[
19
]
|
| 83 | 0.05 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.description AS description_4, t0.icon AS icon_5, t0.icon_color_fill AS icon_color_fill_6, t0.icon_color_stroke AS icon_color_stroke_7, t0.icon_stroke_width AS icon_stroke_width_8, t0.icon_stroke_linecap AS icon_stroke_linecap_9, t0.icon_stroke_linejoin AS icon_stroke_linejoin_10, t0.color_fill AS color_fill_11, t0.color_stroke AS color_stroke_12, t0.color_font AS color_font_13, t0.list_order AS list_order_14, t0.active AS active_15, t0.created_at AS created_at_16, t0.created_by AS created_by_17, t0.updated_at AS updated_at_18, t0.updated_by AS updated_by_19 FROM common_offer_category t0 WHERE t0.id = ?
Parameters:
[
28
]
|
| 84 | 0.05 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.description AS description_4, t0.icon AS icon_5, t0.icon_color_fill AS icon_color_fill_6, t0.icon_color_stroke AS icon_color_stroke_7, t0.icon_stroke_width AS icon_stroke_width_8, t0.icon_stroke_linecap AS icon_stroke_linecap_9, t0.icon_stroke_linejoin AS icon_stroke_linejoin_10, t0.color_fill AS color_fill_11, t0.color_stroke AS color_stroke_12, t0.color_font AS color_font_13, t0.list_order AS list_order_14, t0.active AS active_15, t0.created_at AS created_at_16, t0.created_by AS created_by_17, t0.updated_at AS updated_at_18, t0.updated_by AS updated_by_19 FROM common_offer_category t0 WHERE t0.id = ?
Parameters:
[
22
]
|
| 85 | 0.04 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.description AS description_4, t0.icon AS icon_5, t0.icon_color_fill AS icon_color_fill_6, t0.icon_color_stroke AS icon_color_stroke_7, t0.icon_stroke_width AS icon_stroke_width_8, t0.icon_stroke_linecap AS icon_stroke_linecap_9, t0.icon_stroke_linejoin AS icon_stroke_linejoin_10, t0.color_fill AS color_fill_11, t0.color_stroke AS color_stroke_12, t0.color_font AS color_font_13, t0.list_order AS list_order_14, t0.active AS active_15, t0.created_at AS created_at_16, t0.created_by AS created_by_17, t0.updated_at AS updated_at_18, t0.updated_by AS updated_by_19 FROM common_offer_category t0 WHERE t0.id = ?
Parameters:
[
18
]
|
| 86 | 0.04 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.description AS description_4, t0.icon AS icon_5, t0.icon_color_fill AS icon_color_fill_6, t0.icon_color_stroke AS icon_color_stroke_7, t0.icon_stroke_width AS icon_stroke_width_8, t0.icon_stroke_linecap AS icon_stroke_linecap_9, t0.icon_stroke_linejoin AS icon_stroke_linejoin_10, t0.color_fill AS color_fill_11, t0.color_stroke AS color_stroke_12, t0.color_font AS color_font_13, t0.list_order AS list_order_14, t0.active AS active_15, t0.created_at AS created_at_16, t0.created_by AS created_by_17, t0.updated_at AS updated_at_18, t0.updated_by AS updated_by_19 FROM common_offer_category t0 WHERE t0.id = ?
Parameters:
[
9
]
|
| 87 | 0.05 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.description AS description_4, t0.icon AS icon_5, t0.icon_color_fill AS icon_color_fill_6, t0.icon_color_stroke AS icon_color_stroke_7, t0.icon_stroke_width AS icon_stroke_width_8, t0.icon_stroke_linecap AS icon_stroke_linecap_9, t0.icon_stroke_linejoin AS icon_stroke_linejoin_10, t0.color_fill AS color_fill_11, t0.color_stroke AS color_stroke_12, t0.color_font AS color_font_13, t0.list_order AS list_order_14, t0.active AS active_15, t0.created_at AS created_at_16, t0.created_by AS created_by_17, t0.updated_at AS updated_at_18, t0.updated_by AS updated_by_19 FROM common_offer_category t0 WHERE t0.id = ?
Parameters:
[
26
]
|
| 88 | 0.04 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.description AS description_4, t0.icon AS icon_5, t0.icon_color_fill AS icon_color_fill_6, t0.icon_color_stroke AS icon_color_stroke_7, t0.icon_stroke_width AS icon_stroke_width_8, t0.icon_stroke_linecap AS icon_stroke_linecap_9, t0.icon_stroke_linejoin AS icon_stroke_linejoin_10, t0.color_fill AS color_fill_11, t0.color_stroke AS color_stroke_12, t0.color_font AS color_font_13, t0.list_order AS list_order_14, t0.active AS active_15, t0.created_at AS created_at_16, t0.created_by AS created_by_17, t0.updated_at AS updated_at_18, t0.updated_by AS updated_by_19 FROM common_offer_category t0 WHERE t0.id = ?
Parameters:
[
7
]
|
| 89 | 0.05 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.description AS description_4, t0.icon AS icon_5, t0.icon_color_fill AS icon_color_fill_6, t0.icon_color_stroke AS icon_color_stroke_7, t0.icon_stroke_width AS icon_stroke_width_8, t0.icon_stroke_linecap AS icon_stroke_linecap_9, t0.icon_stroke_linejoin AS icon_stroke_linejoin_10, t0.color_fill AS color_fill_11, t0.color_stroke AS color_stroke_12, t0.color_font AS color_font_13, t0.list_order AS list_order_14, t0.active AS active_15, t0.created_at AS created_at_16, t0.created_by AS created_by_17, t0.updated_at AS updated_at_18, t0.updated_by AS updated_by_19 FROM common_offer_category t0 WHERE t0.id = ?
Parameters:
[
1
]
|
| 90 | 0.05 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.description AS description_4, t0.icon AS icon_5, t0.icon_color_fill AS icon_color_fill_6, t0.icon_color_stroke AS icon_color_stroke_7, t0.icon_stroke_width AS icon_stroke_width_8, t0.icon_stroke_linecap AS icon_stroke_linecap_9, t0.icon_stroke_linejoin AS icon_stroke_linejoin_10, t0.color_fill AS color_fill_11, t0.color_stroke AS color_stroke_12, t0.color_font AS color_font_13, t0.list_order AS list_order_14, t0.active AS active_15, t0.created_at AS created_at_16, t0.created_by AS created_by_17, t0.updated_at AS updated_at_18, t0.updated_by AS updated_by_19 FROM common_offer_category t0 WHERE t0.id = ?
Parameters:
[
4
]
|
| 91 | 0.05 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.description AS description_4, t0.icon AS icon_5, t0.icon_color_fill AS icon_color_fill_6, t0.icon_color_stroke AS icon_color_stroke_7, t0.icon_stroke_width AS icon_stroke_width_8, t0.icon_stroke_linecap AS icon_stroke_linecap_9, t0.icon_stroke_linejoin AS icon_stroke_linejoin_10, t0.color_fill AS color_fill_11, t0.color_stroke AS color_stroke_12, t0.color_font AS color_font_13, t0.list_order AS list_order_14, t0.active AS active_15, t0.created_at AS created_at_16, t0.created_by AS created_by_17, t0.updated_at AS updated_at_18, t0.updated_by AS updated_by_19 FROM common_offer_category t0 WHERE t0.id = ?
Parameters:
[
23
]
|
| 92 | 0.05 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.description AS description_4, t0.icon AS icon_5, t0.icon_color_fill AS icon_color_fill_6, t0.icon_color_stroke AS icon_color_stroke_7, t0.icon_stroke_width AS icon_stroke_width_8, t0.icon_stroke_linecap AS icon_stroke_linecap_9, t0.icon_stroke_linejoin AS icon_stroke_linejoin_10, t0.color_fill AS color_fill_11, t0.color_stroke AS color_stroke_12, t0.color_font AS color_font_13, t0.list_order AS list_order_14, t0.active AS active_15, t0.created_at AS created_at_16, t0.created_by AS created_by_17, t0.updated_at AS updated_at_18, t0.updated_by AS updated_by_19 FROM common_offer_category t0 WHERE t0.id = ?
Parameters:
[
24
]
|
| 93 | 0.05 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.description AS description_4, t0.icon AS icon_5, t0.icon_color_fill AS icon_color_fill_6, t0.icon_color_stroke AS icon_color_stroke_7, t0.icon_stroke_width AS icon_stroke_width_8, t0.icon_stroke_linecap AS icon_stroke_linecap_9, t0.icon_stroke_linejoin AS icon_stroke_linejoin_10, t0.color_fill AS color_fill_11, t0.color_stroke AS color_stroke_12, t0.color_font AS color_font_13, t0.list_order AS list_order_14, t0.active AS active_15, t0.created_at AS created_at_16, t0.created_by AS created_by_17, t0.updated_at AS updated_at_18, t0.updated_by AS updated_by_19 FROM common_offer_category t0 WHERE t0.id = ?
Parameters:
[
20
]
|
| 94 | 0.07 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.description AS description_4, t0.icon AS icon_5, t0.icon_color_fill AS icon_color_fill_6, t0.icon_color_stroke AS icon_color_stroke_7, t0.icon_stroke_width AS icon_stroke_width_8, t0.icon_stroke_linecap AS icon_stroke_linecap_9, t0.icon_stroke_linejoin AS icon_stroke_linejoin_10, t0.color_fill AS color_fill_11, t0.color_stroke AS color_stroke_12, t0.color_font AS color_font_13, t0.list_order AS list_order_14, t0.active AS active_15, t0.created_at AS created_at_16, t0.created_by AS created_by_17, t0.updated_at AS updated_at_18, t0.updated_by AS updated_by_19 FROM common_offer_category t0 WHERE t0.id = ?
Parameters:
[
21
]
|
| 95 | 0.05 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.description AS description_4, t0.icon AS icon_5, t0.icon_color_fill AS icon_color_fill_6, t0.icon_color_stroke AS icon_color_stroke_7, t0.icon_stroke_width AS icon_stroke_width_8, t0.icon_stroke_linecap AS icon_stroke_linecap_9, t0.icon_stroke_linejoin AS icon_stroke_linejoin_10, t0.color_fill AS color_fill_11, t0.color_stroke AS color_stroke_12, t0.color_font AS color_font_13, t0.list_order AS list_order_14, t0.active AS active_15, t0.created_at AS created_at_16, t0.created_by AS created_by_17, t0.updated_at AS updated_at_18, t0.updated_by AS updated_by_19 FROM common_offer_category t0 WHERE t0.id = ?
Parameters:
[
25
]
|
| 96 | 0.05 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.description AS description_4, t0.icon AS icon_5, t0.icon_color_fill AS icon_color_fill_6, t0.icon_color_stroke AS icon_color_stroke_7, t0.icon_stroke_width AS icon_stroke_width_8, t0.icon_stroke_linecap AS icon_stroke_linecap_9, t0.icon_stroke_linejoin AS icon_stroke_linejoin_10, t0.color_fill AS color_fill_11, t0.color_stroke AS color_stroke_12, t0.color_font AS color_font_13, t0.list_order AS list_order_14, t0.active AS active_15, t0.created_at AS created_at_16, t0.created_by AS created_by_17, t0.updated_at AS updated_at_18, t0.updated_by AS updated_by_19 FROM common_offer_category t0 WHERE t0.id = ?
Parameters:
[
11
]
|
| 97 | 0.05 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.description AS description_4, t0.icon AS icon_5, t0.icon_color_fill AS icon_color_fill_6, t0.icon_color_stroke AS icon_color_stroke_7, t0.icon_stroke_width AS icon_stroke_width_8, t0.icon_stroke_linecap AS icon_stroke_linecap_9, t0.icon_stroke_linejoin AS icon_stroke_linejoin_10, t0.color_fill AS color_fill_11, t0.color_stroke AS color_stroke_12, t0.color_font AS color_font_13, t0.list_order AS list_order_14, t0.active AS active_15, t0.created_at AS created_at_16, t0.created_by AS created_by_17, t0.updated_at AS updated_at_18, t0.updated_by AS updated_by_19 FROM common_offer_category t0 WHERE t0.id = ?
Parameters:
[
8
]
|
| 98 | 0.38 ms |
SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.`lead` AS lead_2, c0_.description AS description_3, c0_.list_description AS list_description_4, c0_.mid_description AS mid_description_5, c0_.useful_informations AS useful_informations_6, c0_.additional_informations AS additional_informations_7, c0_.code AS code_8, c0_.slug AS slug_9, c0_.list_order AS list_order_10, c0_.active AS active_11, c0_.created_at AS created_at_12, c0_.created_by AS created_by_13, c0_.updated_at AS updated_at_14, c0_.updated_by AS updated_by_15, c0_.included AS included_16, c0_.excluded AS excluded_17 FROM common_company c0_ WHERE c0_.active = ? AND (EXISTS (SELECT 1 AS sclr_18 FROM common_itinerary_secondary_destination c1_ INNER JOIN common_itinerary c2_ ON c1_.itinerary_id = c2_.id INNER JOIN common_company c3_ ON c2_.origin_company_id = c3_.id INNER JOIN common_destination_secondary c4_ ON c1_.secondary_destination_id = c4_.id WHERE c3_.id = c0_.id AND c4_.id IN (?))) GROUP BY c0_.id ORDER BY c0_.list_order ASC, c0_.name ASC
Parameters:
[ 1 50 ] |
| 99 | 0.65 ms |
SELECT c0_.id AS id_0, c0_.name AS name_1, g1_.id AS id_2, g1_.iso_name AS iso_name_3, c0_.country_id AS country_id_4, c0_.creation_origin_id AS creation_origin_id_5 FROM common_stopover c0_ INNER JOIN geographic_country g1_ ON c0_.country_id = g1_.id INNER JOIN common_itinerary_segment c2_ ON c0_.id = c2_.stopover_id AND (c2_.segment_order = ?) INNER JOIN common_itinerary c3_ ON c2_.itinerary_id = c3_.id INNER JOIN common_cruise c4_ ON c3_.id = c4_.itinerary_id INNER JOIN common_ship c5_ ON c4_.ship_id = c5_.id INNER JOIN common_company c6_ ON c5_.company_id = c6_.id INNER JOIN common_itinerary_secondary_destination c7_ ON c3_.id = c7_.itinerary_id WHERE c7_.secondary_destination_id IN (?) GROUP BY c0_.id ORDER BY g1_.iso_name ASC, c0_.name ASC
Parameters:
[ 1 50 ] |
| 100 | 0.08 ms |
SELECT t0.itineraries_count AS itineraries_count_1, t0.active_cruises_count AS active_cruises_count_2, t0.description AS description_3, t0.what_to_do AS what_to_do_4, t0.access_guide AS access_guide_5, t0.correspondence AS correspondence_6, t0.geolocation AS geolocation_7, t0.medias_count AS medias_count_8, t0.stopover_id AS stopover_id_9 FROM common_stopover_computed t0 WHERE t0.stopover_id = ?
Parameters:
[
2837
]
|
| 101 | 0.49 ms |
SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.code AS code_2, c0_.slug AS slug_3, c0_.description AS description_4, c0_.short_description AS short_description_5, c0_.long_description AS long_description_6, c0_.number_of_members AS number_of_members_7, c0_.number_of_decks AS number_of_decks_8, c0_.number_of_cabins AS number_of_cabins_9, c0_.number_of_passengers AS number_of_passengers_10, c0_.speed AS speed_11, c0_.width AS width_12, c0_.length AS length_13, c0_.tonnage AS tonnage_14, c0_.renovation_year AS renovation_year_15, c0_.construction_year AS construction_year_16, c0_.additional_informations AS additional_informations_17, c0_.active AS active_18, c0_.created_at AS created_at_19, c0_.created_by AS created_by_20, c0_.updated_at AS updated_at_21, c0_.updated_by AS updated_by_22, c0_.list_order AS list_order_23, c0_.company_id AS company_id_24, c0_.fuel_id AS fuel_id_25 FROM common_ship c0_ INNER JOIN common_company c1_ ON c0_.company_id = c1_.id INNER JOIN common_cruise c2_ ON c0_.id = c2_.ship_id INNER JOIN common_itinerary c3_ ON c2_.itinerary_id = c3_.id INNER JOIN common_itinerary_secondary_destination c4_ ON c3_.id = c4_.itinerary_id INNER JOIN common_destination_secondary c5_ ON c4_.secondary_destination_id = c5_.id WHERE c0_.active = ? AND c1_.active = ? AND c5_.id IN (?) GROUP BY c0_.id ORDER BY c1_.list_order ASC, c1_.name ASC, c0_.list_order ASC, c0_.name ASC
Parameters:
[ 1 1 50 ] |
| 102 | 0.19 ms |
SELECT s0_.title AS title_0, s0_.webspace_key AS webspace_key_1, s0_.all_domains AS all_domains_2, s0_.content AS content_3, s0_.type AS type_4, s0_.id AS id_5, s1_.url AS url_6, s1_.environment AS environment_7, s1_.id AS id_8 FROM sulu_we_analytics s0_ LEFT JOIN sulu_we_analytics_domains s2_ ON s0_.id = s2_.analytics LEFT JOIN sulu_we_domains s1_ ON s1_.id = s2_.domain WHERE (s0_.all_domains = 1 OR (s1_.url = ? AND s1_.environment = ?)) AND s0_.webspace_key = ? ORDER BY s0_.id ASC
Parameters:
[ "preprod-croisiland.dev" "dev" "main-website" ] |
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.