Query Metrics
190
Database Queries
12
Different statements
18.29 ms
Query time
0
Invalid entities
Queries
| #▲ | Time | Info |
|---|---|---|
| 1 | 0.26 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.code AS code_3, t0.crush AS crush_4, t0.slug AS slug_5, t0.flat_file_description AS flat_file_description_6, t0.flat_file_immediate_confirm AS flat_file_immediate_confirm_7, t0.manually_created AS manually_created_8, t0.departure_date AS departure_date_9, t0.arrival_date AS arrival_date_10, t0.is_erp_itinerary_history_up_to_date AS is_erp_itinerary_history_up_to_date_11, t0.active AS active_12, t0.visible AS visible_13, t0.created_at AS created_at_14, t0.created_by AS created_by_15, t0.updated_at AS updated_at_16, t0.updated_by AS updated_by_17, t0.module_order AS module_order_18, t0.included AS included_19, t0.excluded AS excluded_20, t0.ship_id AS ship_id_21, t0.best_price_id AS best_price_id_22, t0.best_price_with_flight_id AS best_price_with_flight_id_23, t0.best_group_price_id AS best_group_price_id_24, t0.best_group_price_with_flight_id AS best_group_price_with_flight_id_25, t0.itinerary_id AS itinerary_id_26, t0.origin_id AS origin_id_27 FROM common_cruise t0 WHERE t0.id = ?
Parameters:
[
4806
]
|
| 2 | 0.22 ms |
SELECT c0_.id AS id_0 FROM common_cruise c0_ WHERE c0_.itinerary_id = ? AND c0_.departure_date > ? AND c0_.active = 1 AND c0_.visible = 1 ORDER BY c0_.departure_date ASC
Parameters:
[ 649 "2026-10-12 21:07:30" ] |
| 3 | 0.28 ms |
SELECT MIN(c0_.base_cost_double) AS sclr_0 FROM common_price c0_ WHERE c0_.cruise_id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[ 4684 4692 4719 4728 4732 4753 4761 4770 4792 4806 4819 4827 4832 4847 4855 4863 ] |
| 4 | 0.14 ms |
SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.code AS code_2, c0_.crush AS crush_3, c0_.slug AS slug_4, c0_.flat_file_description AS flat_file_description_5, c0_.flat_file_immediate_confirm AS flat_file_immediate_confirm_6, c0_.manually_created AS manually_created_7, c0_.departure_date AS departure_date_8, c0_.arrival_date AS arrival_date_9, c0_.is_erp_itinerary_history_up_to_date AS is_erp_itinerary_history_up_to_date_10, c0_.active AS active_11, c0_.visible AS visible_12, c0_.created_at AS created_at_13, c0_.created_by AS created_by_14, c0_.updated_at AS updated_at_15, c0_.updated_by AS updated_by_16, c0_.module_order AS module_order_17, c0_.included AS included_18, c0_.excluded AS excluded_19, c0_.ship_id AS ship_id_20, c0_.best_price_id AS best_price_id_21, c0_.best_price_with_flight_id AS best_price_with_flight_id_22, c0_.best_group_price_id AS best_group_price_id_23, c0_.best_group_price_with_flight_id AS best_group_price_with_flight_id_24, c0_.itinerary_id AS itinerary_id_25, c0_.origin_id AS origin_id_26 FROM common_cruise c0_ WHERE c0_.itinerary_id = ? AND c0_.departure_date > ? AND c0_.active = 1 AND c0_.visible = 1 ORDER BY c0_.departure_date ASC
Parameters:
[ 649 "2026-10-12 21:07:30" ] |
| 5 | 0.42 ms |
SELECT DISTINCT c0_.id AS id_0, c0_.name AS name_1, c0_.short_name AS short_name_2, c0_.slug AS slug_3, c0_.description AS description_4, c0_.cabin_area_min AS cabin_area_min_5, c0_.cabin_area_max AS cabin_area_max_6, c0_.balcony_area_min AS balcony_area_min_7, c0_.balcony_area_max AS balcony_area_max_8, c0_.active AS active_9, c0_.list_order AS list_order_10, c0_.created_at AS created_at_11, c0_.created_by AS created_by_12, c0_.updated_at AS updated_at_13, c0_.updated_by AS updated_by_14, c0_.key_value_pairs AS key_value_pairs_15, c0_.cabin_type_id AS cabin_type_id_16, c0_.company_id AS company_id_17 FROM common_cabin_sub_type c0_ INNER JOIN common_cabin_category c1_ ON c0_.id = c1_.cabin_sub_type_id WHERE c1_.ship_id = ? ORDER BY c0_.list_order ASC, c0_.name ASC
Parameters:
[
135
]
|
| 6 | 0.17 ms |
SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.short_name AS short_name_2, c0_.slug AS slug_3, c0_.description AS description_4, c0_.cabin_area_min AS cabin_area_min_5, c0_.cabin_area_max AS cabin_area_max_6, c0_.balcony_area_min AS balcony_area_min_7, c0_.balcony_area_max AS balcony_area_max_8, c0_.active AS active_9, c0_.list_order AS list_order_10, c0_.created_at AS created_at_11, c0_.created_by AS created_by_12, c0_.updated_at AS updated_at_13, c0_.updated_by AS updated_by_14, c0_.key_value_pairs AS key_value_pairs_15, c0_.cabin_type_id AS cabin_type_id_16, c0_.company_id AS company_id_17 FROM common_cabin_sub_type c0_ INNER JOIN common_cabin_type c1_ ON c0_.cabin_type_id = c1_.id INNER JOIN common_cabin_category c2_ ON c0_.id = c2_.cabin_sub_type_id INNER JOIN common_price c3_ ON c2_.id = c3_.cabin_category_id WHERE c3_.cruise_id = ? ORDER BY c0_.list_order ASC, c0_.name ASC
Parameters:
[
4684
]
|
| 7 | 0.15 ms |
SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.short_name AS short_name_2, c0_.slug AS slug_3, c0_.description AS description_4, c0_.cabin_area_min AS cabin_area_min_5, c0_.cabin_area_max AS cabin_area_max_6, c0_.balcony_area_min AS balcony_area_min_7, c0_.balcony_area_max AS balcony_area_max_8, c0_.active AS active_9, c0_.list_order AS list_order_10, c0_.created_at AS created_at_11, c0_.created_by AS created_by_12, c0_.updated_at AS updated_at_13, c0_.updated_by AS updated_by_14, c0_.key_value_pairs AS key_value_pairs_15, c0_.cabin_type_id AS cabin_type_id_16, c0_.company_id AS company_id_17 FROM common_cabin_sub_type c0_ INNER JOIN common_cabin_type c1_ ON c0_.cabin_type_id = c1_.id INNER JOIN common_cabin_category c2_ ON c0_.id = c2_.cabin_sub_type_id INNER JOIN common_price c3_ ON c2_.id = c3_.cabin_category_id WHERE c3_.cruise_id = ? ORDER BY c0_.list_order ASC, c0_.name ASC
Parameters:
[
4692
]
|
| 8 | 0.25 ms |
SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.short_name AS short_name_2, c0_.slug AS slug_3, c0_.description AS description_4, c0_.cabin_area_min AS cabin_area_min_5, c0_.cabin_area_max AS cabin_area_max_6, c0_.balcony_area_min AS balcony_area_min_7, c0_.balcony_area_max AS balcony_area_max_8, c0_.active AS active_9, c0_.list_order AS list_order_10, c0_.created_at AS created_at_11, c0_.created_by AS created_by_12, c0_.updated_at AS updated_at_13, c0_.updated_by AS updated_by_14, c0_.key_value_pairs AS key_value_pairs_15, c0_.cabin_type_id AS cabin_type_id_16, c0_.company_id AS company_id_17 FROM common_cabin_sub_type c0_ INNER JOIN common_cabin_type c1_ ON c0_.cabin_type_id = c1_.id INNER JOIN common_cabin_category c2_ ON c0_.id = c2_.cabin_sub_type_id INNER JOIN common_price c3_ ON c2_.id = c3_.cabin_category_id WHERE c3_.cruise_id = ? ORDER BY c0_.list_order ASC, c0_.name ASC
Parameters:
[
4719
]
|
| 9 | 0.23 ms |
SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.short_name AS short_name_2, c0_.slug AS slug_3, c0_.description AS description_4, c0_.cabin_area_min AS cabin_area_min_5, c0_.cabin_area_max AS cabin_area_max_6, c0_.balcony_area_min AS balcony_area_min_7, c0_.balcony_area_max AS balcony_area_max_8, c0_.active AS active_9, c0_.list_order AS list_order_10, c0_.created_at AS created_at_11, c0_.created_by AS created_by_12, c0_.updated_at AS updated_at_13, c0_.updated_by AS updated_by_14, c0_.key_value_pairs AS key_value_pairs_15, c0_.cabin_type_id AS cabin_type_id_16, c0_.company_id AS company_id_17 FROM common_cabin_sub_type c0_ INNER JOIN common_cabin_type c1_ ON c0_.cabin_type_id = c1_.id INNER JOIN common_cabin_category c2_ ON c0_.id = c2_.cabin_sub_type_id INNER JOIN common_price c3_ ON c2_.id = c3_.cabin_category_id WHERE c3_.cruise_id = ? ORDER BY c0_.list_order ASC, c0_.name ASC
Parameters:
[
4728
]
|
| 10 | 0.13 ms |
SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.short_name AS short_name_2, c0_.slug AS slug_3, c0_.description AS description_4, c0_.cabin_area_min AS cabin_area_min_5, c0_.cabin_area_max AS cabin_area_max_6, c0_.balcony_area_min AS balcony_area_min_7, c0_.balcony_area_max AS balcony_area_max_8, c0_.active AS active_9, c0_.list_order AS list_order_10, c0_.created_at AS created_at_11, c0_.created_by AS created_by_12, c0_.updated_at AS updated_at_13, c0_.updated_by AS updated_by_14, c0_.key_value_pairs AS key_value_pairs_15, c0_.cabin_type_id AS cabin_type_id_16, c0_.company_id AS company_id_17 FROM common_cabin_sub_type c0_ INNER JOIN common_cabin_type c1_ ON c0_.cabin_type_id = c1_.id INNER JOIN common_cabin_category c2_ ON c0_.id = c2_.cabin_sub_type_id INNER JOIN common_price c3_ ON c2_.id = c3_.cabin_category_id WHERE c3_.cruise_id = ? ORDER BY c0_.list_order ASC, c0_.name ASC
Parameters:
[
4732
]
|
| 11 | 0.09 ms |
SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.short_name AS short_name_2, c0_.slug AS slug_3, c0_.description AS description_4, c0_.cabin_area_min AS cabin_area_min_5, c0_.cabin_area_max AS cabin_area_max_6, c0_.balcony_area_min AS balcony_area_min_7, c0_.balcony_area_max AS balcony_area_max_8, c0_.active AS active_9, c0_.list_order AS list_order_10, c0_.created_at AS created_at_11, c0_.created_by AS created_by_12, c0_.updated_at AS updated_at_13, c0_.updated_by AS updated_by_14, c0_.key_value_pairs AS key_value_pairs_15, c0_.cabin_type_id AS cabin_type_id_16, c0_.company_id AS company_id_17 FROM common_cabin_sub_type c0_ INNER JOIN common_cabin_type c1_ ON c0_.cabin_type_id = c1_.id INNER JOIN common_cabin_category c2_ ON c0_.id = c2_.cabin_sub_type_id INNER JOIN common_price c3_ ON c2_.id = c3_.cabin_category_id WHERE c3_.cruise_id = ? ORDER BY c0_.list_order ASC, c0_.name ASC
Parameters:
[
4753
]
|
| 12 | 0.14 ms |
SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.short_name AS short_name_2, c0_.slug AS slug_3, c0_.description AS description_4, c0_.cabin_area_min AS cabin_area_min_5, c0_.cabin_area_max AS cabin_area_max_6, c0_.balcony_area_min AS balcony_area_min_7, c0_.balcony_area_max AS balcony_area_max_8, c0_.active AS active_9, c0_.list_order AS list_order_10, c0_.created_at AS created_at_11, c0_.created_by AS created_by_12, c0_.updated_at AS updated_at_13, c0_.updated_by AS updated_by_14, c0_.key_value_pairs AS key_value_pairs_15, c0_.cabin_type_id AS cabin_type_id_16, c0_.company_id AS company_id_17 FROM common_cabin_sub_type c0_ INNER JOIN common_cabin_type c1_ ON c0_.cabin_type_id = c1_.id INNER JOIN common_cabin_category c2_ ON c0_.id = c2_.cabin_sub_type_id INNER JOIN common_price c3_ ON c2_.id = c3_.cabin_category_id WHERE c3_.cruise_id = ? ORDER BY c0_.list_order ASC, c0_.name ASC
Parameters:
[
4761
]
|
| 13 | 0.13 ms |
SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.short_name AS short_name_2, c0_.slug AS slug_3, c0_.description AS description_4, c0_.cabin_area_min AS cabin_area_min_5, c0_.cabin_area_max AS cabin_area_max_6, c0_.balcony_area_min AS balcony_area_min_7, c0_.balcony_area_max AS balcony_area_max_8, c0_.active AS active_9, c0_.list_order AS list_order_10, c0_.created_at AS created_at_11, c0_.created_by AS created_by_12, c0_.updated_at AS updated_at_13, c0_.updated_by AS updated_by_14, c0_.key_value_pairs AS key_value_pairs_15, c0_.cabin_type_id AS cabin_type_id_16, c0_.company_id AS company_id_17 FROM common_cabin_sub_type c0_ INNER JOIN common_cabin_type c1_ ON c0_.cabin_type_id = c1_.id INNER JOIN common_cabin_category c2_ ON c0_.id = c2_.cabin_sub_type_id INNER JOIN common_price c3_ ON c2_.id = c3_.cabin_category_id WHERE c3_.cruise_id = ? ORDER BY c0_.list_order ASC, c0_.name ASC
Parameters:
[
4770
]
|
| 14 | 0.14 ms |
SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.short_name AS short_name_2, c0_.slug AS slug_3, c0_.description AS description_4, c0_.cabin_area_min AS cabin_area_min_5, c0_.cabin_area_max AS cabin_area_max_6, c0_.balcony_area_min AS balcony_area_min_7, c0_.balcony_area_max AS balcony_area_max_8, c0_.active AS active_9, c0_.list_order AS list_order_10, c0_.created_at AS created_at_11, c0_.created_by AS created_by_12, c0_.updated_at AS updated_at_13, c0_.updated_by AS updated_by_14, c0_.key_value_pairs AS key_value_pairs_15, c0_.cabin_type_id AS cabin_type_id_16, c0_.company_id AS company_id_17 FROM common_cabin_sub_type c0_ INNER JOIN common_cabin_type c1_ ON c0_.cabin_type_id = c1_.id INNER JOIN common_cabin_category c2_ ON c0_.id = c2_.cabin_sub_type_id INNER JOIN common_price c3_ ON c2_.id = c3_.cabin_category_id WHERE c3_.cruise_id = ? ORDER BY c0_.list_order ASC, c0_.name ASC
Parameters:
[
4792
]
|
| 15 | 0.13 ms |
SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.short_name AS short_name_2, c0_.slug AS slug_3, c0_.description AS description_4, c0_.cabin_area_min AS cabin_area_min_5, c0_.cabin_area_max AS cabin_area_max_6, c0_.balcony_area_min AS balcony_area_min_7, c0_.balcony_area_max AS balcony_area_max_8, c0_.active AS active_9, c0_.list_order AS list_order_10, c0_.created_at AS created_at_11, c0_.created_by AS created_by_12, c0_.updated_at AS updated_at_13, c0_.updated_by AS updated_by_14, c0_.key_value_pairs AS key_value_pairs_15, c0_.cabin_type_id AS cabin_type_id_16, c0_.company_id AS company_id_17 FROM common_cabin_sub_type c0_ INNER JOIN common_cabin_type c1_ ON c0_.cabin_type_id = c1_.id INNER JOIN common_cabin_category c2_ ON c0_.id = c2_.cabin_sub_type_id INNER JOIN common_price c3_ ON c2_.id = c3_.cabin_category_id WHERE c3_.cruise_id = ? ORDER BY c0_.list_order ASC, c0_.name ASC
Parameters:
[
4806
]
|
| 16 | 0.14 ms |
SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.short_name AS short_name_2, c0_.slug AS slug_3, c0_.description AS description_4, c0_.cabin_area_min AS cabin_area_min_5, c0_.cabin_area_max AS cabin_area_max_6, c0_.balcony_area_min AS balcony_area_min_7, c0_.balcony_area_max AS balcony_area_max_8, c0_.active AS active_9, c0_.list_order AS list_order_10, c0_.created_at AS created_at_11, c0_.created_by AS created_by_12, c0_.updated_at AS updated_at_13, c0_.updated_by AS updated_by_14, c0_.key_value_pairs AS key_value_pairs_15, c0_.cabin_type_id AS cabin_type_id_16, c0_.company_id AS company_id_17 FROM common_cabin_sub_type c0_ INNER JOIN common_cabin_type c1_ ON c0_.cabin_type_id = c1_.id INNER JOIN common_cabin_category c2_ ON c0_.id = c2_.cabin_sub_type_id INNER JOIN common_price c3_ ON c2_.id = c3_.cabin_category_id WHERE c3_.cruise_id = ? ORDER BY c0_.list_order ASC, c0_.name ASC
Parameters:
[
4819
]
|
| 17 | 0.14 ms |
SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.short_name AS short_name_2, c0_.slug AS slug_3, c0_.description AS description_4, c0_.cabin_area_min AS cabin_area_min_5, c0_.cabin_area_max AS cabin_area_max_6, c0_.balcony_area_min AS balcony_area_min_7, c0_.balcony_area_max AS balcony_area_max_8, c0_.active AS active_9, c0_.list_order AS list_order_10, c0_.created_at AS created_at_11, c0_.created_by AS created_by_12, c0_.updated_at AS updated_at_13, c0_.updated_by AS updated_by_14, c0_.key_value_pairs AS key_value_pairs_15, c0_.cabin_type_id AS cabin_type_id_16, c0_.company_id AS company_id_17 FROM common_cabin_sub_type c0_ INNER JOIN common_cabin_type c1_ ON c0_.cabin_type_id = c1_.id INNER JOIN common_cabin_category c2_ ON c0_.id = c2_.cabin_sub_type_id INNER JOIN common_price c3_ ON c2_.id = c3_.cabin_category_id WHERE c3_.cruise_id = ? ORDER BY c0_.list_order ASC, c0_.name ASC
Parameters:
[
4827
]
|
| 18 | 0.14 ms |
SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.short_name AS short_name_2, c0_.slug AS slug_3, c0_.description AS description_4, c0_.cabin_area_min AS cabin_area_min_5, c0_.cabin_area_max AS cabin_area_max_6, c0_.balcony_area_min AS balcony_area_min_7, c0_.balcony_area_max AS balcony_area_max_8, c0_.active AS active_9, c0_.list_order AS list_order_10, c0_.created_at AS created_at_11, c0_.created_by AS created_by_12, c0_.updated_at AS updated_at_13, c0_.updated_by AS updated_by_14, c0_.key_value_pairs AS key_value_pairs_15, c0_.cabin_type_id AS cabin_type_id_16, c0_.company_id AS company_id_17 FROM common_cabin_sub_type c0_ INNER JOIN common_cabin_type c1_ ON c0_.cabin_type_id = c1_.id INNER JOIN common_cabin_category c2_ ON c0_.id = c2_.cabin_sub_type_id INNER JOIN common_price c3_ ON c2_.id = c3_.cabin_category_id WHERE c3_.cruise_id = ? ORDER BY c0_.list_order ASC, c0_.name ASC
Parameters:
[
4832
]
|
| 19 | 0.14 ms |
SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.short_name AS short_name_2, c0_.slug AS slug_3, c0_.description AS description_4, c0_.cabin_area_min AS cabin_area_min_5, c0_.cabin_area_max AS cabin_area_max_6, c0_.balcony_area_min AS balcony_area_min_7, c0_.balcony_area_max AS balcony_area_max_8, c0_.active AS active_9, c0_.list_order AS list_order_10, c0_.created_at AS created_at_11, c0_.created_by AS created_by_12, c0_.updated_at AS updated_at_13, c0_.updated_by AS updated_by_14, c0_.key_value_pairs AS key_value_pairs_15, c0_.cabin_type_id AS cabin_type_id_16, c0_.company_id AS company_id_17 FROM common_cabin_sub_type c0_ INNER JOIN common_cabin_type c1_ ON c0_.cabin_type_id = c1_.id INNER JOIN common_cabin_category c2_ ON c0_.id = c2_.cabin_sub_type_id INNER JOIN common_price c3_ ON c2_.id = c3_.cabin_category_id WHERE c3_.cruise_id = ? ORDER BY c0_.list_order ASC, c0_.name ASC
Parameters:
[
4847
]
|
| 20 | 0.14 ms |
SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.short_name AS short_name_2, c0_.slug AS slug_3, c0_.description AS description_4, c0_.cabin_area_min AS cabin_area_min_5, c0_.cabin_area_max AS cabin_area_max_6, c0_.balcony_area_min AS balcony_area_min_7, c0_.balcony_area_max AS balcony_area_max_8, c0_.active AS active_9, c0_.list_order AS list_order_10, c0_.created_at AS created_at_11, c0_.created_by AS created_by_12, c0_.updated_at AS updated_at_13, c0_.updated_by AS updated_by_14, c0_.key_value_pairs AS key_value_pairs_15, c0_.cabin_type_id AS cabin_type_id_16, c0_.company_id AS company_id_17 FROM common_cabin_sub_type c0_ INNER JOIN common_cabin_type c1_ ON c0_.cabin_type_id = c1_.id INNER JOIN common_cabin_category c2_ ON c0_.id = c2_.cabin_sub_type_id INNER JOIN common_price c3_ ON c2_.id = c3_.cabin_category_id WHERE c3_.cruise_id = ? ORDER BY c0_.list_order ASC, c0_.name ASC
Parameters:
[
4855
]
|
| 21 | 0.14 ms |
SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.short_name AS short_name_2, c0_.slug AS slug_3, c0_.description AS description_4, c0_.cabin_area_min AS cabin_area_min_5, c0_.cabin_area_max AS cabin_area_max_6, c0_.balcony_area_min AS balcony_area_min_7, c0_.balcony_area_max AS balcony_area_max_8, c0_.active AS active_9, c0_.list_order AS list_order_10, c0_.created_at AS created_at_11, c0_.created_by AS created_by_12, c0_.updated_at AS updated_at_13, c0_.updated_by AS updated_by_14, c0_.key_value_pairs AS key_value_pairs_15, c0_.cabin_type_id AS cabin_type_id_16, c0_.company_id AS company_id_17 FROM common_cabin_sub_type c0_ INNER JOIN common_cabin_type c1_ ON c0_.cabin_type_id = c1_.id INNER JOIN common_cabin_category c2_ ON c0_.id = c2_.cabin_sub_type_id INNER JOIN common_price c3_ ON c2_.id = c3_.cabin_category_id WHERE c3_.cruise_id = ? ORDER BY c0_.list_order ASC, c0_.name ASC
Parameters:
[
4863
]
|
| 22 | 0.10 ms |
SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.short_name AS short_name_2, c0_.slug AS slug_3, c0_.active AS active_4, c0_.list_order AS list_order_5, c0_.created_at AS created_at_6, c0_.created_by AS created_by_7, c0_.updated_at AS updated_at_8, c0_.updated_by AS updated_by_9, c0_.key_value_pairs AS key_value_pairs_10 FROM common_cabin_type c0_ INNER JOIN common_cabin_sub_type c1_ ON c0_.id = c1_.cabin_type_id INNER JOIN common_cabin_category c2_ ON c1_.id = c2_.cabin_sub_type_id INNER JOIN common_price c3_ ON c2_.id = c3_.cabin_category_id WHERE c3_.cruise_id = ?
Parameters:
[
4806
]
|
| 23 | 0.08 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.short_name AS short_name_3, t0.slug AS slug_4, t0.description AS description_5, t0.cabin_area_min AS cabin_area_min_6, t0.cabin_area_max AS cabin_area_max_7, t0.balcony_area_min AS balcony_area_min_8, t0.balcony_area_max AS balcony_area_max_9, t0.active AS active_10, t0.list_order AS list_order_11, t0.created_at AS created_at_12, t0.created_by AS created_by_13, t0.updated_at AS updated_at_14, t0.updated_by AS updated_by_15, t0.key_value_pairs AS key_value_pairs_16, t0.cabin_type_id AS cabin_type_id_17, t0.company_id AS company_id_18 FROM common_cabin_sub_type t0 WHERE t0.cabin_type_id = ?
Parameters:
[
1
]
|
| 24 | 0.07 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.short_name AS short_name_3, t0.slug AS slug_4, t0.description AS description_5, t0.cabin_area_min AS cabin_area_min_6, t0.cabin_area_max AS cabin_area_max_7, t0.balcony_area_min AS balcony_area_min_8, t0.balcony_area_max AS balcony_area_max_9, t0.active AS active_10, t0.list_order AS list_order_11, t0.created_at AS created_at_12, t0.created_by AS created_by_13, t0.updated_at AS updated_at_14, t0.updated_by AS updated_by_15, t0.key_value_pairs AS key_value_pairs_16, t0.cabin_type_id AS cabin_type_id_17, t0.company_id AS company_id_18 FROM common_cabin_sub_type t0 WHERE t0.cabin_type_id = ?
Parameters:
[
3
]
|
| 25 | 0.07 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.short_name AS short_name_3, t0.slug AS slug_4, t0.description AS description_5, t0.cabin_area_min AS cabin_area_min_6, t0.cabin_area_max AS cabin_area_max_7, t0.balcony_area_min AS balcony_area_min_8, t0.balcony_area_max AS balcony_area_max_9, t0.active AS active_10, t0.list_order AS list_order_11, t0.created_at AS created_at_12, t0.created_by AS created_by_13, t0.updated_at AS updated_at_14, t0.updated_by AS updated_by_15, t0.key_value_pairs AS key_value_pairs_16, t0.cabin_type_id AS cabin_type_id_17, t0.company_id AS company_id_18 FROM common_cabin_sub_type t0 WHERE t0.cabin_type_id = ?
Parameters:
[
4
]
|
| 26 | 0.06 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.short_name AS short_name_3, t0.slug AS slug_4, t0.description AS description_5, t0.cabin_area_min AS cabin_area_min_6, t0.cabin_area_max AS cabin_area_max_7, t0.balcony_area_min AS balcony_area_min_8, t0.balcony_area_max AS balcony_area_max_9, t0.active AS active_10, t0.list_order AS list_order_11, t0.created_at AS created_at_12, t0.created_by AS created_by_13, t0.updated_at AS updated_at_14, t0.updated_by AS updated_by_15, t0.key_value_pairs AS key_value_pairs_16, t0.cabin_type_id AS cabin_type_id_17, t0.company_id AS company_id_18 FROM common_cabin_sub_type t0 WHERE t0.cabin_type_id = ?
Parameters:
[
2
]
|
| 27 | 0.13 ms |
SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.short_name AS short_name_2, c0_.slug AS slug_3, c0_.description AS description_4, c0_.cabin_area_min AS cabin_area_min_5, c0_.cabin_area_max AS cabin_area_max_6, c0_.balcony_area_min AS balcony_area_min_7, c0_.balcony_area_max AS balcony_area_max_8, c0_.active AS active_9, c0_.list_order AS list_order_10, c0_.created_at AS created_at_11, c0_.created_by AS created_by_12, c0_.updated_at AS updated_at_13, c0_.updated_by AS updated_by_14, c0_.key_value_pairs AS key_value_pairs_15, c0_.cabin_type_id AS cabin_type_id_16, c0_.company_id AS company_id_17 FROM common_cabin_sub_type c0_ INNER JOIN common_cabin_type c1_ ON c0_.cabin_type_id = c1_.id INNER JOIN common_cabin_category c2_ ON c0_.id = c2_.cabin_sub_type_id INNER JOIN common_price c3_ ON c2_.id = c3_.cabin_category_id WHERE c3_.cruise_id = ? ORDER BY c0_.list_order ASC, c0_.name ASC
Parameters:
[
4806
]
|
| 28 | 0.17 ms |
SELECT c0_.id AS id_0, c0_.fare_code AS fare_code_1, c0_.description AS description_2, c0_.price_family AS price_family_3, c0_.price_family_normalized AS price_family_normalized_4, c0_.flight_possible AS flight_possible_5, c0_.flight_included AS flight_included_6, c0_.base_cost_double AS base_cost_double_7, c0_.code AS code_8, c0_.created_at AS created_at_9, c0_.created_by AS created_by_10, c0_.updated_at AS updated_at_11, c0_.updated_by AS updated_by_12, c0_.currency AS currency_13, c0_.cruise_id AS cruise_id_14, c0_.cabin_category_id AS cabin_category_id_15, c0_.offer_id AS offer_id_16 FROM common_price c0_ INNER JOIN common_cabin_category c1_ ON c0_.cabin_category_id = c1_.id WHERE c0_.cruise_id = ? AND c1_.cabin_sub_type_id = ? AND c0_.base_cost_double > 0 ORDER BY c0_.base_cost_double ASC LIMIT 1
Parameters:
[ 4684 46 ] |
| 29 | 0.10 ms |
SELECT c0_.id AS id_0, c0_.fare_code AS fare_code_1, c0_.description AS description_2, c0_.price_family AS price_family_3, c0_.price_family_normalized AS price_family_normalized_4, c0_.flight_possible AS flight_possible_5, c0_.flight_included AS flight_included_6, c0_.base_cost_double AS base_cost_double_7, c0_.code AS code_8, c0_.created_at AS created_at_9, c0_.created_by AS created_by_10, c0_.updated_at AS updated_at_11, c0_.updated_by AS updated_by_12, c0_.currency AS currency_13, c0_.cruise_id AS cruise_id_14, c0_.cabin_category_id AS cabin_category_id_15, c0_.offer_id AS offer_id_16 FROM common_price c0_ INNER JOIN common_cabin_category c1_ ON c0_.cabin_category_id = c1_.id WHERE c0_.cruise_id = ? AND c1_.cabin_sub_type_id = ? AND c0_.base_cost_double > 0 ORDER BY c0_.base_cost_double ASC LIMIT 1
Parameters:
[ 4692 46 ] |
| 30 | 0.11 ms |
SELECT c0_.id AS id_0, c0_.fare_code AS fare_code_1, c0_.description AS description_2, c0_.price_family AS price_family_3, c0_.price_family_normalized AS price_family_normalized_4, c0_.flight_possible AS flight_possible_5, c0_.flight_included AS flight_included_6, c0_.base_cost_double AS base_cost_double_7, c0_.code AS code_8, c0_.created_at AS created_at_9, c0_.created_by AS created_by_10, c0_.updated_at AS updated_at_11, c0_.updated_by AS updated_by_12, c0_.currency AS currency_13, c0_.cruise_id AS cruise_id_14, c0_.cabin_category_id AS cabin_category_id_15, c0_.offer_id AS offer_id_16 FROM common_price c0_ INNER JOIN common_cabin_category c1_ ON c0_.cabin_category_id = c1_.id WHERE c0_.cruise_id = ? AND c1_.cabin_sub_type_id = ? AND c0_.base_cost_double > 0 ORDER BY c0_.base_cost_double ASC LIMIT 1
Parameters:
[ 4719 46 ] |
| 31 | 0.10 ms |
SELECT c0_.id AS id_0, c0_.fare_code AS fare_code_1, c0_.description AS description_2, c0_.price_family AS price_family_3, c0_.price_family_normalized AS price_family_normalized_4, c0_.flight_possible AS flight_possible_5, c0_.flight_included AS flight_included_6, c0_.base_cost_double AS base_cost_double_7, c0_.code AS code_8, c0_.created_at AS created_at_9, c0_.created_by AS created_by_10, c0_.updated_at AS updated_at_11, c0_.updated_by AS updated_by_12, c0_.currency AS currency_13, c0_.cruise_id AS cruise_id_14, c0_.cabin_category_id AS cabin_category_id_15, c0_.offer_id AS offer_id_16 FROM common_price c0_ INNER JOIN common_cabin_category c1_ ON c0_.cabin_category_id = c1_.id WHERE c0_.cruise_id = ? AND c1_.cabin_sub_type_id = ? AND c0_.base_cost_double > 0 ORDER BY c0_.base_cost_double ASC LIMIT 1
Parameters:
[ 4728 46 ] |
| 32 | 0.10 ms |
SELECT c0_.id AS id_0, c0_.fare_code AS fare_code_1, c0_.description AS description_2, c0_.price_family AS price_family_3, c0_.price_family_normalized AS price_family_normalized_4, c0_.flight_possible AS flight_possible_5, c0_.flight_included AS flight_included_6, c0_.base_cost_double AS base_cost_double_7, c0_.code AS code_8, c0_.created_at AS created_at_9, c0_.created_by AS created_by_10, c0_.updated_at AS updated_at_11, c0_.updated_by AS updated_by_12, c0_.currency AS currency_13, c0_.cruise_id AS cruise_id_14, c0_.cabin_category_id AS cabin_category_id_15, c0_.offer_id AS offer_id_16 FROM common_price c0_ INNER JOIN common_cabin_category c1_ ON c0_.cabin_category_id = c1_.id WHERE c0_.cruise_id = ? AND c1_.cabin_sub_type_id = ? AND c0_.base_cost_double > 0 ORDER BY c0_.base_cost_double ASC LIMIT 1
Parameters:
[ 4732 46 ] |
| 33 | 0.09 ms |
SELECT c0_.id AS id_0, c0_.fare_code AS fare_code_1, c0_.description AS description_2, c0_.price_family AS price_family_3, c0_.price_family_normalized AS price_family_normalized_4, c0_.flight_possible AS flight_possible_5, c0_.flight_included AS flight_included_6, c0_.base_cost_double AS base_cost_double_7, c0_.code AS code_8, c0_.created_at AS created_at_9, c0_.created_by AS created_by_10, c0_.updated_at AS updated_at_11, c0_.updated_by AS updated_by_12, c0_.currency AS currency_13, c0_.cruise_id AS cruise_id_14, c0_.cabin_category_id AS cabin_category_id_15, c0_.offer_id AS offer_id_16 FROM common_price c0_ INNER JOIN common_cabin_category c1_ ON c0_.cabin_category_id = c1_.id WHERE c0_.cruise_id = ? AND c1_.cabin_sub_type_id = ? AND c0_.base_cost_double > 0 ORDER BY c0_.base_cost_double ASC LIMIT 1
Parameters:
[ 4753 46 ] |
| 34 | 0.11 ms |
SELECT c0_.id AS id_0, c0_.fare_code AS fare_code_1, c0_.description AS description_2, c0_.price_family AS price_family_3, c0_.price_family_normalized AS price_family_normalized_4, c0_.flight_possible AS flight_possible_5, c0_.flight_included AS flight_included_6, c0_.base_cost_double AS base_cost_double_7, c0_.code AS code_8, c0_.created_at AS created_at_9, c0_.created_by AS created_by_10, c0_.updated_at AS updated_at_11, c0_.updated_by AS updated_by_12, c0_.currency AS currency_13, c0_.cruise_id AS cruise_id_14, c0_.cabin_category_id AS cabin_category_id_15, c0_.offer_id AS offer_id_16 FROM common_price c0_ INNER JOIN common_cabin_category c1_ ON c0_.cabin_category_id = c1_.id WHERE c0_.cruise_id = ? AND c1_.cabin_sub_type_id = ? AND c0_.base_cost_double > 0 ORDER BY c0_.base_cost_double ASC LIMIT 1
Parameters:
[ 4761 46 ] |
| 35 | 0.11 ms |
SELECT c0_.id AS id_0, c0_.fare_code AS fare_code_1, c0_.description AS description_2, c0_.price_family AS price_family_3, c0_.price_family_normalized AS price_family_normalized_4, c0_.flight_possible AS flight_possible_5, c0_.flight_included AS flight_included_6, c0_.base_cost_double AS base_cost_double_7, c0_.code AS code_8, c0_.created_at AS created_at_9, c0_.created_by AS created_by_10, c0_.updated_at AS updated_at_11, c0_.updated_by AS updated_by_12, c0_.currency AS currency_13, c0_.cruise_id AS cruise_id_14, c0_.cabin_category_id AS cabin_category_id_15, c0_.offer_id AS offer_id_16 FROM common_price c0_ INNER JOIN common_cabin_category c1_ ON c0_.cabin_category_id = c1_.id WHERE c0_.cruise_id = ? AND c1_.cabin_sub_type_id = ? AND c0_.base_cost_double > 0 ORDER BY c0_.base_cost_double ASC LIMIT 1
Parameters:
[ 4770 46 ] |
| 36 | 0.11 ms |
SELECT c0_.id AS id_0, c0_.fare_code AS fare_code_1, c0_.description AS description_2, c0_.price_family AS price_family_3, c0_.price_family_normalized AS price_family_normalized_4, c0_.flight_possible AS flight_possible_5, c0_.flight_included AS flight_included_6, c0_.base_cost_double AS base_cost_double_7, c0_.code AS code_8, c0_.created_at AS created_at_9, c0_.created_by AS created_by_10, c0_.updated_at AS updated_at_11, c0_.updated_by AS updated_by_12, c0_.currency AS currency_13, c0_.cruise_id AS cruise_id_14, c0_.cabin_category_id AS cabin_category_id_15, c0_.offer_id AS offer_id_16 FROM common_price c0_ INNER JOIN common_cabin_category c1_ ON c0_.cabin_category_id = c1_.id WHERE c0_.cruise_id = ? AND c1_.cabin_sub_type_id = ? AND c0_.base_cost_double > 0 ORDER BY c0_.base_cost_double ASC LIMIT 1
Parameters:
[ 4792 46 ] |
| 37 | 0.11 ms |
SELECT c0_.id AS id_0, c0_.fare_code AS fare_code_1, c0_.description AS description_2, c0_.price_family AS price_family_3, c0_.price_family_normalized AS price_family_normalized_4, c0_.flight_possible AS flight_possible_5, c0_.flight_included AS flight_included_6, c0_.base_cost_double AS base_cost_double_7, c0_.code AS code_8, c0_.created_at AS created_at_9, c0_.created_by AS created_by_10, c0_.updated_at AS updated_at_11, c0_.updated_by AS updated_by_12, c0_.currency AS currency_13, c0_.cruise_id AS cruise_id_14, c0_.cabin_category_id AS cabin_category_id_15, c0_.offer_id AS offer_id_16 FROM common_price c0_ INNER JOIN common_cabin_category c1_ ON c0_.cabin_category_id = c1_.id WHERE c0_.cruise_id = ? AND c1_.cabin_sub_type_id = ? AND c0_.base_cost_double > 0 ORDER BY c0_.base_cost_double ASC LIMIT 1
Parameters:
[ 4806 46 ] |
| 38 | 0.11 ms |
SELECT c0_.id AS id_0, c0_.fare_code AS fare_code_1, c0_.description AS description_2, c0_.price_family AS price_family_3, c0_.price_family_normalized AS price_family_normalized_4, c0_.flight_possible AS flight_possible_5, c0_.flight_included AS flight_included_6, c0_.base_cost_double AS base_cost_double_7, c0_.code AS code_8, c0_.created_at AS created_at_9, c0_.created_by AS created_by_10, c0_.updated_at AS updated_at_11, c0_.updated_by AS updated_by_12, c0_.currency AS currency_13, c0_.cruise_id AS cruise_id_14, c0_.cabin_category_id AS cabin_category_id_15, c0_.offer_id AS offer_id_16 FROM common_price c0_ INNER JOIN common_cabin_category c1_ ON c0_.cabin_category_id = c1_.id WHERE c0_.cruise_id = ? AND c1_.cabin_sub_type_id = ? AND c0_.base_cost_double > 0 ORDER BY c0_.base_cost_double ASC LIMIT 1
Parameters:
[ 4819 46 ] |
| 39 | 0.11 ms |
SELECT c0_.id AS id_0, c0_.fare_code AS fare_code_1, c0_.description AS description_2, c0_.price_family AS price_family_3, c0_.price_family_normalized AS price_family_normalized_4, c0_.flight_possible AS flight_possible_5, c0_.flight_included AS flight_included_6, c0_.base_cost_double AS base_cost_double_7, c0_.code AS code_8, c0_.created_at AS created_at_9, c0_.created_by AS created_by_10, c0_.updated_at AS updated_at_11, c0_.updated_by AS updated_by_12, c0_.currency AS currency_13, c0_.cruise_id AS cruise_id_14, c0_.cabin_category_id AS cabin_category_id_15, c0_.offer_id AS offer_id_16 FROM common_price c0_ INNER JOIN common_cabin_category c1_ ON c0_.cabin_category_id = c1_.id WHERE c0_.cruise_id = ? AND c1_.cabin_sub_type_id = ? AND c0_.base_cost_double > 0 ORDER BY c0_.base_cost_double ASC LIMIT 1
Parameters:
[ 4827 46 ] |
| 40 | 0.11 ms |
SELECT c0_.id AS id_0, c0_.fare_code AS fare_code_1, c0_.description AS description_2, c0_.price_family AS price_family_3, c0_.price_family_normalized AS price_family_normalized_4, c0_.flight_possible AS flight_possible_5, c0_.flight_included AS flight_included_6, c0_.base_cost_double AS base_cost_double_7, c0_.code AS code_8, c0_.created_at AS created_at_9, c0_.created_by AS created_by_10, c0_.updated_at AS updated_at_11, c0_.updated_by AS updated_by_12, c0_.currency AS currency_13, c0_.cruise_id AS cruise_id_14, c0_.cabin_category_id AS cabin_category_id_15, c0_.offer_id AS offer_id_16 FROM common_price c0_ INNER JOIN common_cabin_category c1_ ON c0_.cabin_category_id = c1_.id WHERE c0_.cruise_id = ? AND c1_.cabin_sub_type_id = ? AND c0_.base_cost_double > 0 ORDER BY c0_.base_cost_double ASC LIMIT 1
Parameters:
[ 4832 46 ] |
| 41 | 0.10 ms |
SELECT c0_.id AS id_0, c0_.fare_code AS fare_code_1, c0_.description AS description_2, c0_.price_family AS price_family_3, c0_.price_family_normalized AS price_family_normalized_4, c0_.flight_possible AS flight_possible_5, c0_.flight_included AS flight_included_6, c0_.base_cost_double AS base_cost_double_7, c0_.code AS code_8, c0_.created_at AS created_at_9, c0_.created_by AS created_by_10, c0_.updated_at AS updated_at_11, c0_.updated_by AS updated_by_12, c0_.currency AS currency_13, c0_.cruise_id AS cruise_id_14, c0_.cabin_category_id AS cabin_category_id_15, c0_.offer_id AS offer_id_16 FROM common_price c0_ INNER JOIN common_cabin_category c1_ ON c0_.cabin_category_id = c1_.id WHERE c0_.cruise_id = ? AND c1_.cabin_sub_type_id = ? AND c0_.base_cost_double > 0 ORDER BY c0_.base_cost_double ASC LIMIT 1
Parameters:
[ 4847 46 ] |
| 42 | 0.11 ms |
SELECT c0_.id AS id_0, c0_.fare_code AS fare_code_1, c0_.description AS description_2, c0_.price_family AS price_family_3, c0_.price_family_normalized AS price_family_normalized_4, c0_.flight_possible AS flight_possible_5, c0_.flight_included AS flight_included_6, c0_.base_cost_double AS base_cost_double_7, c0_.code AS code_8, c0_.created_at AS created_at_9, c0_.created_by AS created_by_10, c0_.updated_at AS updated_at_11, c0_.updated_by AS updated_by_12, c0_.currency AS currency_13, c0_.cruise_id AS cruise_id_14, c0_.cabin_category_id AS cabin_category_id_15, c0_.offer_id AS offer_id_16 FROM common_price c0_ INNER JOIN common_cabin_category c1_ ON c0_.cabin_category_id = c1_.id WHERE c0_.cruise_id = ? AND c1_.cabin_sub_type_id = ? AND c0_.base_cost_double > 0 ORDER BY c0_.base_cost_double ASC LIMIT 1
Parameters:
[ 4855 46 ] |
| 43 | 0.11 ms |
SELECT c0_.id AS id_0, c0_.fare_code AS fare_code_1, c0_.description AS description_2, c0_.price_family AS price_family_3, c0_.price_family_normalized AS price_family_normalized_4, c0_.flight_possible AS flight_possible_5, c0_.flight_included AS flight_included_6, c0_.base_cost_double AS base_cost_double_7, c0_.code AS code_8, c0_.created_at AS created_at_9, c0_.created_by AS created_by_10, c0_.updated_at AS updated_at_11, c0_.updated_by AS updated_by_12, c0_.currency AS currency_13, c0_.cruise_id AS cruise_id_14, c0_.cabin_category_id AS cabin_category_id_15, c0_.offer_id AS offer_id_16 FROM common_price c0_ INNER JOIN common_cabin_category c1_ ON c0_.cabin_category_id = c1_.id WHERE c0_.cruise_id = ? AND c1_.cabin_sub_type_id = ? AND c0_.base_cost_double > 0 ORDER BY c0_.base_cost_double ASC LIMIT 1
Parameters:
[ 4863 46 ] |
| 44 | 0.07 ms |
SELECT c0_.id AS id_0, c0_.fare_code AS fare_code_1, c0_.description AS description_2, c0_.price_family AS price_family_3, c0_.price_family_normalized AS price_family_normalized_4, c0_.flight_possible AS flight_possible_5, c0_.flight_included AS flight_included_6, c0_.base_cost_double AS base_cost_double_7, c0_.code AS code_8, c0_.created_at AS created_at_9, c0_.created_by AS created_by_10, c0_.updated_at AS updated_at_11, c0_.updated_by AS updated_by_12, c0_.currency AS currency_13, c0_.cruise_id AS cruise_id_14, c0_.cabin_category_id AS cabin_category_id_15, c0_.offer_id AS offer_id_16 FROM common_price c0_ INNER JOIN common_cabin_category c1_ ON c0_.cabin_category_id = c1_.id WHERE c0_.cruise_id = ? AND c1_.cabin_sub_type_id = ? AND c0_.base_cost_double > 0 ORDER BY c0_.base_cost_double ASC LIMIT 1
Parameters:
[ 4684 46 ] |
| 45 | 0.08 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.code AS code_3, t0.slug AS slug_4, t0.description AS description_5, t0.short_description AS short_description_6, t0.long_description AS long_description_7, t0.number_of_members AS number_of_members_8, t0.number_of_decks AS number_of_decks_9, t0.number_of_cabins AS number_of_cabins_10, t0.number_of_passengers AS number_of_passengers_11, t0.speed AS speed_12, t0.width AS width_13, t0.length AS length_14, t0.tonnage AS tonnage_15, t0.renovation_year AS renovation_year_16, t0.construction_year AS construction_year_17, t0.additional_informations AS additional_informations_18, t0.active AS active_19, t0.created_at AS created_at_20, t0.created_by AS created_by_21, t0.updated_at AS updated_at_22, t0.updated_by AS updated_by_23, t0.list_order AS list_order_24, t0.company_id AS company_id_25, t0.fuel_id AS fuel_id_26 FROM common_ship t0 WHERE t0.id = ?
Parameters:
[
135
]
|
| 46 | 0.06 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.`lead` AS lead_3, t0.description AS description_4, t0.list_description AS list_description_5, t0.mid_description AS mid_description_6, t0.useful_informations AS useful_informations_7, t0.additional_informations AS additional_informations_8, t0.code AS code_9, t0.slug AS slug_10, t0.list_order AS list_order_11, t0.active AS active_12, t0.created_at AS created_at_13, t0.created_by AS created_by_14, t0.updated_at AS updated_at_15, t0.updated_by AS updated_by_16, t0.included AS included_17, t0.excluded AS excluded_18 FROM common_company t0 WHERE t0.id = ?
Parameters:
[
6
]
|
| 47 | 0.08 ms |
SELECT c0_.id AS id_0, c0_.fare_code AS fare_code_1, c0_.description AS description_2, c0_.price_family AS price_family_3, c0_.price_family_normalized AS price_family_normalized_4, c0_.flight_possible AS flight_possible_5, c0_.flight_included AS flight_included_6, c0_.base_cost_double AS base_cost_double_7, c0_.code AS code_8, c0_.created_at AS created_at_9, c0_.created_by AS created_by_10, c0_.updated_at AS updated_at_11, c0_.updated_by AS updated_by_12, c0_.currency AS currency_13, c0_.cruise_id AS cruise_id_14, c0_.cabin_category_id AS cabin_category_id_15, c0_.offer_id AS offer_id_16 FROM common_price c0_ INNER JOIN common_cabin_category c1_ ON c0_.cabin_category_id = c1_.id WHERE c0_.cruise_id = ? AND c1_.cabin_sub_type_id = ? AND c0_.base_cost_double > 0 ORDER BY c0_.base_cost_double ASC LIMIT 1
Parameters:
[ 4692 46 ] |
| 48 | 0.10 ms |
SELECT c0_.id AS id_0, c0_.fare_code AS fare_code_1, c0_.description AS description_2, c0_.price_family AS price_family_3, c0_.price_family_normalized AS price_family_normalized_4, c0_.flight_possible AS flight_possible_5, c0_.flight_included AS flight_included_6, c0_.base_cost_double AS base_cost_double_7, c0_.code AS code_8, c0_.created_at AS created_at_9, c0_.created_by AS created_by_10, c0_.updated_at AS updated_at_11, c0_.updated_by AS updated_by_12, c0_.currency AS currency_13, c0_.cruise_id AS cruise_id_14, c0_.cabin_category_id AS cabin_category_id_15, c0_.offer_id AS offer_id_16 FROM common_price c0_ INNER JOIN common_cabin_category c1_ ON c0_.cabin_category_id = c1_.id WHERE c0_.cruise_id = ? AND c1_.cabin_sub_type_id = ? AND c0_.base_cost_double > 0 ORDER BY c0_.base_cost_double ASC LIMIT 1
Parameters:
[ 4719 46 ] |
| 49 | 0.09 ms |
SELECT c0_.id AS id_0, c0_.fare_code AS fare_code_1, c0_.description AS description_2, c0_.price_family AS price_family_3, c0_.price_family_normalized AS price_family_normalized_4, c0_.flight_possible AS flight_possible_5, c0_.flight_included AS flight_included_6, c0_.base_cost_double AS base_cost_double_7, c0_.code AS code_8, c0_.created_at AS created_at_9, c0_.created_by AS created_by_10, c0_.updated_at AS updated_at_11, c0_.updated_by AS updated_by_12, c0_.currency AS currency_13, c0_.cruise_id AS cruise_id_14, c0_.cabin_category_id AS cabin_category_id_15, c0_.offer_id AS offer_id_16 FROM common_price c0_ INNER JOIN common_cabin_category c1_ ON c0_.cabin_category_id = c1_.id WHERE c0_.cruise_id = ? AND c1_.cabin_sub_type_id = ? AND c0_.base_cost_double > 0 ORDER BY c0_.base_cost_double ASC LIMIT 1
Parameters:
[ 4728 46 ] |
| 50 | 0.09 ms |
SELECT c0_.id AS id_0, c0_.fare_code AS fare_code_1, c0_.description AS description_2, c0_.price_family AS price_family_3, c0_.price_family_normalized AS price_family_normalized_4, c0_.flight_possible AS flight_possible_5, c0_.flight_included AS flight_included_6, c0_.base_cost_double AS base_cost_double_7, c0_.code AS code_8, c0_.created_at AS created_at_9, c0_.created_by AS created_by_10, c0_.updated_at AS updated_at_11, c0_.updated_by AS updated_by_12, c0_.currency AS currency_13, c0_.cruise_id AS cruise_id_14, c0_.cabin_category_id AS cabin_category_id_15, c0_.offer_id AS offer_id_16 FROM common_price c0_ INNER JOIN common_cabin_category c1_ ON c0_.cabin_category_id = c1_.id WHERE c0_.cruise_id = ? AND c1_.cabin_sub_type_id = ? AND c0_.base_cost_double > 0 ORDER BY c0_.base_cost_double ASC LIMIT 1
Parameters:
[ 4732 46 ] |
| 51 | 0.08 ms |
SELECT c0_.id AS id_0, c0_.fare_code AS fare_code_1, c0_.description AS description_2, c0_.price_family AS price_family_3, c0_.price_family_normalized AS price_family_normalized_4, c0_.flight_possible AS flight_possible_5, c0_.flight_included AS flight_included_6, c0_.base_cost_double AS base_cost_double_7, c0_.code AS code_8, c0_.created_at AS created_at_9, c0_.created_by AS created_by_10, c0_.updated_at AS updated_at_11, c0_.updated_by AS updated_by_12, c0_.currency AS currency_13, c0_.cruise_id AS cruise_id_14, c0_.cabin_category_id AS cabin_category_id_15, c0_.offer_id AS offer_id_16 FROM common_price c0_ INNER JOIN common_cabin_category c1_ ON c0_.cabin_category_id = c1_.id WHERE c0_.cruise_id = ? AND c1_.cabin_sub_type_id = ? AND c0_.base_cost_double > 0 ORDER BY c0_.base_cost_double ASC LIMIT 1
Parameters:
[ 4753 46 ] |
| 52 | 0.10 ms |
SELECT c0_.id AS id_0, c0_.fare_code AS fare_code_1, c0_.description AS description_2, c0_.price_family AS price_family_3, c0_.price_family_normalized AS price_family_normalized_4, c0_.flight_possible AS flight_possible_5, c0_.flight_included AS flight_included_6, c0_.base_cost_double AS base_cost_double_7, c0_.code AS code_8, c0_.created_at AS created_at_9, c0_.created_by AS created_by_10, c0_.updated_at AS updated_at_11, c0_.updated_by AS updated_by_12, c0_.currency AS currency_13, c0_.cruise_id AS cruise_id_14, c0_.cabin_category_id AS cabin_category_id_15, c0_.offer_id AS offer_id_16 FROM common_price c0_ INNER JOIN common_cabin_category c1_ ON c0_.cabin_category_id = c1_.id WHERE c0_.cruise_id = ? AND c1_.cabin_sub_type_id = ? AND c0_.base_cost_double > 0 ORDER BY c0_.base_cost_double ASC LIMIT 1
Parameters:
[ 4761 46 ] |
| 53 | 0.10 ms |
SELECT c0_.id AS id_0, c0_.fare_code AS fare_code_1, c0_.description AS description_2, c0_.price_family AS price_family_3, c0_.price_family_normalized AS price_family_normalized_4, c0_.flight_possible AS flight_possible_5, c0_.flight_included AS flight_included_6, c0_.base_cost_double AS base_cost_double_7, c0_.code AS code_8, c0_.created_at AS created_at_9, c0_.created_by AS created_by_10, c0_.updated_at AS updated_at_11, c0_.updated_by AS updated_by_12, c0_.currency AS currency_13, c0_.cruise_id AS cruise_id_14, c0_.cabin_category_id AS cabin_category_id_15, c0_.offer_id AS offer_id_16 FROM common_price c0_ INNER JOIN common_cabin_category c1_ ON c0_.cabin_category_id = c1_.id WHERE c0_.cruise_id = ? AND c1_.cabin_sub_type_id = ? AND c0_.base_cost_double > 0 ORDER BY c0_.base_cost_double ASC LIMIT 1
Parameters:
[ 4770 46 ] |
| 54 | 0.10 ms |
SELECT c0_.id AS id_0, c0_.fare_code AS fare_code_1, c0_.description AS description_2, c0_.price_family AS price_family_3, c0_.price_family_normalized AS price_family_normalized_4, c0_.flight_possible AS flight_possible_5, c0_.flight_included AS flight_included_6, c0_.base_cost_double AS base_cost_double_7, c0_.code AS code_8, c0_.created_at AS created_at_9, c0_.created_by AS created_by_10, c0_.updated_at AS updated_at_11, c0_.updated_by AS updated_by_12, c0_.currency AS currency_13, c0_.cruise_id AS cruise_id_14, c0_.cabin_category_id AS cabin_category_id_15, c0_.offer_id AS offer_id_16 FROM common_price c0_ INNER JOIN common_cabin_category c1_ ON c0_.cabin_category_id = c1_.id WHERE c0_.cruise_id = ? AND c1_.cabin_sub_type_id = ? AND c0_.base_cost_double > 0 ORDER BY c0_.base_cost_double ASC LIMIT 1
Parameters:
[ 4792 46 ] |
| 55 | 0.10 ms |
SELECT c0_.id AS id_0, c0_.fare_code AS fare_code_1, c0_.description AS description_2, c0_.price_family AS price_family_3, c0_.price_family_normalized AS price_family_normalized_4, c0_.flight_possible AS flight_possible_5, c0_.flight_included AS flight_included_6, c0_.base_cost_double AS base_cost_double_7, c0_.code AS code_8, c0_.created_at AS created_at_9, c0_.created_by AS created_by_10, c0_.updated_at AS updated_at_11, c0_.updated_by AS updated_by_12, c0_.currency AS currency_13, c0_.cruise_id AS cruise_id_14, c0_.cabin_category_id AS cabin_category_id_15, c0_.offer_id AS offer_id_16 FROM common_price c0_ INNER JOIN common_cabin_category c1_ ON c0_.cabin_category_id = c1_.id WHERE c0_.cruise_id = ? AND c1_.cabin_sub_type_id = ? AND c0_.base_cost_double > 0 ORDER BY c0_.base_cost_double ASC LIMIT 1
Parameters:
[ 4806 46 ] |
| 56 | 0.10 ms |
SELECT c0_.id AS id_0, c0_.fare_code AS fare_code_1, c0_.description AS description_2, c0_.price_family AS price_family_3, c0_.price_family_normalized AS price_family_normalized_4, c0_.flight_possible AS flight_possible_5, c0_.flight_included AS flight_included_6, c0_.base_cost_double AS base_cost_double_7, c0_.code AS code_8, c0_.created_at AS created_at_9, c0_.created_by AS created_by_10, c0_.updated_at AS updated_at_11, c0_.updated_by AS updated_by_12, c0_.currency AS currency_13, c0_.cruise_id AS cruise_id_14, c0_.cabin_category_id AS cabin_category_id_15, c0_.offer_id AS offer_id_16 FROM common_price c0_ INNER JOIN common_cabin_category c1_ ON c0_.cabin_category_id = c1_.id WHERE c0_.cruise_id = ? AND c1_.cabin_sub_type_id = ? AND c0_.base_cost_double > 0 ORDER BY c0_.base_cost_double ASC LIMIT 1
Parameters:
[ 4819 46 ] |
| 57 | 0.10 ms |
SELECT c0_.id AS id_0, c0_.fare_code AS fare_code_1, c0_.description AS description_2, c0_.price_family AS price_family_3, c0_.price_family_normalized AS price_family_normalized_4, c0_.flight_possible AS flight_possible_5, c0_.flight_included AS flight_included_6, c0_.base_cost_double AS base_cost_double_7, c0_.code AS code_8, c0_.created_at AS created_at_9, c0_.created_by AS created_by_10, c0_.updated_at AS updated_at_11, c0_.updated_by AS updated_by_12, c0_.currency AS currency_13, c0_.cruise_id AS cruise_id_14, c0_.cabin_category_id AS cabin_category_id_15, c0_.offer_id AS offer_id_16 FROM common_price c0_ INNER JOIN common_cabin_category c1_ ON c0_.cabin_category_id = c1_.id WHERE c0_.cruise_id = ? AND c1_.cabin_sub_type_id = ? AND c0_.base_cost_double > 0 ORDER BY c0_.base_cost_double ASC LIMIT 1
Parameters:
[ 4827 46 ] |
| 58 | 0.10 ms |
SELECT c0_.id AS id_0, c0_.fare_code AS fare_code_1, c0_.description AS description_2, c0_.price_family AS price_family_3, c0_.price_family_normalized AS price_family_normalized_4, c0_.flight_possible AS flight_possible_5, c0_.flight_included AS flight_included_6, c0_.base_cost_double AS base_cost_double_7, c0_.code AS code_8, c0_.created_at AS created_at_9, c0_.created_by AS created_by_10, c0_.updated_at AS updated_at_11, c0_.updated_by AS updated_by_12, c0_.currency AS currency_13, c0_.cruise_id AS cruise_id_14, c0_.cabin_category_id AS cabin_category_id_15, c0_.offer_id AS offer_id_16 FROM common_price c0_ INNER JOIN common_cabin_category c1_ ON c0_.cabin_category_id = c1_.id WHERE c0_.cruise_id = ? AND c1_.cabin_sub_type_id = ? AND c0_.base_cost_double > 0 ORDER BY c0_.base_cost_double ASC LIMIT 1
Parameters:
[ 4832 46 ] |
| 59 | 0.10 ms |
SELECT c0_.id AS id_0, c0_.fare_code AS fare_code_1, c0_.description AS description_2, c0_.price_family AS price_family_3, c0_.price_family_normalized AS price_family_normalized_4, c0_.flight_possible AS flight_possible_5, c0_.flight_included AS flight_included_6, c0_.base_cost_double AS base_cost_double_7, c0_.code AS code_8, c0_.created_at AS created_at_9, c0_.created_by AS created_by_10, c0_.updated_at AS updated_at_11, c0_.updated_by AS updated_by_12, c0_.currency AS currency_13, c0_.cruise_id AS cruise_id_14, c0_.cabin_category_id AS cabin_category_id_15, c0_.offer_id AS offer_id_16 FROM common_price c0_ INNER JOIN common_cabin_category c1_ ON c0_.cabin_category_id = c1_.id WHERE c0_.cruise_id = ? AND c1_.cabin_sub_type_id = ? AND c0_.base_cost_double > 0 ORDER BY c0_.base_cost_double ASC LIMIT 1
Parameters:
[ 4847 46 ] |
| 60 | 0.10 ms |
SELECT c0_.id AS id_0, c0_.fare_code AS fare_code_1, c0_.description AS description_2, c0_.price_family AS price_family_3, c0_.price_family_normalized AS price_family_normalized_4, c0_.flight_possible AS flight_possible_5, c0_.flight_included AS flight_included_6, c0_.base_cost_double AS base_cost_double_7, c0_.code AS code_8, c0_.created_at AS created_at_9, c0_.created_by AS created_by_10, c0_.updated_at AS updated_at_11, c0_.updated_by AS updated_by_12, c0_.currency AS currency_13, c0_.cruise_id AS cruise_id_14, c0_.cabin_category_id AS cabin_category_id_15, c0_.offer_id AS offer_id_16 FROM common_price c0_ INNER JOIN common_cabin_category c1_ ON c0_.cabin_category_id = c1_.id WHERE c0_.cruise_id = ? AND c1_.cabin_sub_type_id = ? AND c0_.base_cost_double > 0 ORDER BY c0_.base_cost_double ASC LIMIT 1
Parameters:
[ 4855 46 ] |
| 61 | 0.10 ms |
SELECT c0_.id AS id_0, c0_.fare_code AS fare_code_1, c0_.description AS description_2, c0_.price_family AS price_family_3, c0_.price_family_normalized AS price_family_normalized_4, c0_.flight_possible AS flight_possible_5, c0_.flight_included AS flight_included_6, c0_.base_cost_double AS base_cost_double_7, c0_.code AS code_8, c0_.created_at AS created_at_9, c0_.created_by AS created_by_10, c0_.updated_at AS updated_at_11, c0_.updated_by AS updated_by_12, c0_.currency AS currency_13, c0_.cruise_id AS cruise_id_14, c0_.cabin_category_id AS cabin_category_id_15, c0_.offer_id AS offer_id_16 FROM common_price c0_ INNER JOIN common_cabin_category c1_ ON c0_.cabin_category_id = c1_.id WHERE c0_.cruise_id = ? AND c1_.cabin_sub_type_id = ? AND c0_.base_cost_double > 0 ORDER BY c0_.base_cost_double ASC LIMIT 1
Parameters:
[ 4863 46 ] |
| 62 | 0.06 ms |
SELECT c0_.id AS id_0, c0_.fare_code AS fare_code_1, c0_.description AS description_2, c0_.price_family AS price_family_3, c0_.price_family_normalized AS price_family_normalized_4, c0_.flight_possible AS flight_possible_5, c0_.flight_included AS flight_included_6, c0_.base_cost_double AS base_cost_double_7, c0_.code AS code_8, c0_.created_at AS created_at_9, c0_.created_by AS created_by_10, c0_.updated_at AS updated_at_11, c0_.updated_by AS updated_by_12, c0_.currency AS currency_13, c0_.cruise_id AS cruise_id_14, c0_.cabin_category_id AS cabin_category_id_15, c0_.offer_id AS offer_id_16 FROM common_price c0_ INNER JOIN common_cabin_category c1_ ON c0_.cabin_category_id = c1_.id WHERE c0_.cruise_id = ? AND c1_.cabin_sub_type_id = ? AND c0_.base_cost_double > 0 ORDER BY c0_.base_cost_double ASC LIMIT 1
Parameters:
[ 4684 47 ] |
| 63 | 0.06 ms |
SELECT c0_.id AS id_0, c0_.fare_code AS fare_code_1, c0_.description AS description_2, c0_.price_family AS price_family_3, c0_.price_family_normalized AS price_family_normalized_4, c0_.flight_possible AS flight_possible_5, c0_.flight_included AS flight_included_6, c0_.base_cost_double AS base_cost_double_7, c0_.code AS code_8, c0_.created_at AS created_at_9, c0_.created_by AS created_by_10, c0_.updated_at AS updated_at_11, c0_.updated_by AS updated_by_12, c0_.currency AS currency_13, c0_.cruise_id AS cruise_id_14, c0_.cabin_category_id AS cabin_category_id_15, c0_.offer_id AS offer_id_16 FROM common_price c0_ INNER JOIN common_cabin_category c1_ ON c0_.cabin_category_id = c1_.id WHERE c0_.cruise_id = ? AND c1_.cabin_sub_type_id = ? AND c0_.base_cost_double > 0 ORDER BY c0_.base_cost_double ASC LIMIT 1
Parameters:
[ 4692 47 ] |
| 64 | 0.09 ms |
SELECT c0_.id AS id_0, c0_.fare_code AS fare_code_1, c0_.description AS description_2, c0_.price_family AS price_family_3, c0_.price_family_normalized AS price_family_normalized_4, c0_.flight_possible AS flight_possible_5, c0_.flight_included AS flight_included_6, c0_.base_cost_double AS base_cost_double_7, c0_.code AS code_8, c0_.created_at AS created_at_9, c0_.created_by AS created_by_10, c0_.updated_at AS updated_at_11, c0_.updated_by AS updated_by_12, c0_.currency AS currency_13, c0_.cruise_id AS cruise_id_14, c0_.cabin_category_id AS cabin_category_id_15, c0_.offer_id AS offer_id_16 FROM common_price c0_ INNER JOIN common_cabin_category c1_ ON c0_.cabin_category_id = c1_.id WHERE c0_.cruise_id = ? AND c1_.cabin_sub_type_id = ? AND c0_.base_cost_double > 0 ORDER BY c0_.base_cost_double ASC LIMIT 1
Parameters:
[ 4719 47 ] |
| 65 | 0.09 ms |
SELECT c0_.id AS id_0, c0_.fare_code AS fare_code_1, c0_.description AS description_2, c0_.price_family AS price_family_3, c0_.price_family_normalized AS price_family_normalized_4, c0_.flight_possible AS flight_possible_5, c0_.flight_included AS flight_included_6, c0_.base_cost_double AS base_cost_double_7, c0_.code AS code_8, c0_.created_at AS created_at_9, c0_.created_by AS created_by_10, c0_.updated_at AS updated_at_11, c0_.updated_by AS updated_by_12, c0_.currency AS currency_13, c0_.cruise_id AS cruise_id_14, c0_.cabin_category_id AS cabin_category_id_15, c0_.offer_id AS offer_id_16 FROM common_price c0_ INNER JOIN common_cabin_category c1_ ON c0_.cabin_category_id = c1_.id WHERE c0_.cruise_id = ? AND c1_.cabin_sub_type_id = ? AND c0_.base_cost_double > 0 ORDER BY c0_.base_cost_double ASC LIMIT 1
Parameters:
[ 4728 47 ] |
| 66 | 0.09 ms |
SELECT c0_.id AS id_0, c0_.fare_code AS fare_code_1, c0_.description AS description_2, c0_.price_family AS price_family_3, c0_.price_family_normalized AS price_family_normalized_4, c0_.flight_possible AS flight_possible_5, c0_.flight_included AS flight_included_6, c0_.base_cost_double AS base_cost_double_7, c0_.code AS code_8, c0_.created_at AS created_at_9, c0_.created_by AS created_by_10, c0_.updated_at AS updated_at_11, c0_.updated_by AS updated_by_12, c0_.currency AS currency_13, c0_.cruise_id AS cruise_id_14, c0_.cabin_category_id AS cabin_category_id_15, c0_.offer_id AS offer_id_16 FROM common_price c0_ INNER JOIN common_cabin_category c1_ ON c0_.cabin_category_id = c1_.id WHERE c0_.cruise_id = ? AND c1_.cabin_sub_type_id = ? AND c0_.base_cost_double > 0 ORDER BY c0_.base_cost_double ASC LIMIT 1
Parameters:
[ 4732 47 ] |
| 67 | 0.07 ms |
SELECT c0_.id AS id_0, c0_.fare_code AS fare_code_1, c0_.description AS description_2, c0_.price_family AS price_family_3, c0_.price_family_normalized AS price_family_normalized_4, c0_.flight_possible AS flight_possible_5, c0_.flight_included AS flight_included_6, c0_.base_cost_double AS base_cost_double_7, c0_.code AS code_8, c0_.created_at AS created_at_9, c0_.created_by AS created_by_10, c0_.updated_at AS updated_at_11, c0_.updated_by AS updated_by_12, c0_.currency AS currency_13, c0_.cruise_id AS cruise_id_14, c0_.cabin_category_id AS cabin_category_id_15, c0_.offer_id AS offer_id_16 FROM common_price c0_ INNER JOIN common_cabin_category c1_ ON c0_.cabin_category_id = c1_.id WHERE c0_.cruise_id = ? AND c1_.cabin_sub_type_id = ? AND c0_.base_cost_double > 0 ORDER BY c0_.base_cost_double ASC LIMIT 1
Parameters:
[ 4753 47 ] |
| 68 | 0.10 ms |
SELECT c0_.id AS id_0, c0_.fare_code AS fare_code_1, c0_.description AS description_2, c0_.price_family AS price_family_3, c0_.price_family_normalized AS price_family_normalized_4, c0_.flight_possible AS flight_possible_5, c0_.flight_included AS flight_included_6, c0_.base_cost_double AS base_cost_double_7, c0_.code AS code_8, c0_.created_at AS created_at_9, c0_.created_by AS created_by_10, c0_.updated_at AS updated_at_11, c0_.updated_by AS updated_by_12, c0_.currency AS currency_13, c0_.cruise_id AS cruise_id_14, c0_.cabin_category_id AS cabin_category_id_15, c0_.offer_id AS offer_id_16 FROM common_price c0_ INNER JOIN common_cabin_category c1_ ON c0_.cabin_category_id = c1_.id WHERE c0_.cruise_id = ? AND c1_.cabin_sub_type_id = ? AND c0_.base_cost_double > 0 ORDER BY c0_.base_cost_double ASC LIMIT 1
Parameters:
[ 4761 47 ] |
| 69 | 0.10 ms |
SELECT c0_.id AS id_0, c0_.fare_code AS fare_code_1, c0_.description AS description_2, c0_.price_family AS price_family_3, c0_.price_family_normalized AS price_family_normalized_4, c0_.flight_possible AS flight_possible_5, c0_.flight_included AS flight_included_6, c0_.base_cost_double AS base_cost_double_7, c0_.code AS code_8, c0_.created_at AS created_at_9, c0_.created_by AS created_by_10, c0_.updated_at AS updated_at_11, c0_.updated_by AS updated_by_12, c0_.currency AS currency_13, c0_.cruise_id AS cruise_id_14, c0_.cabin_category_id AS cabin_category_id_15, c0_.offer_id AS offer_id_16 FROM common_price c0_ INNER JOIN common_cabin_category c1_ ON c0_.cabin_category_id = c1_.id WHERE c0_.cruise_id = ? AND c1_.cabin_sub_type_id = ? AND c0_.base_cost_double > 0 ORDER BY c0_.base_cost_double ASC LIMIT 1
Parameters:
[ 4770 47 ] |
| 70 | 0.10 ms |
SELECT c0_.id AS id_0, c0_.fare_code AS fare_code_1, c0_.description AS description_2, c0_.price_family AS price_family_3, c0_.price_family_normalized AS price_family_normalized_4, c0_.flight_possible AS flight_possible_5, c0_.flight_included AS flight_included_6, c0_.base_cost_double AS base_cost_double_7, c0_.code AS code_8, c0_.created_at AS created_at_9, c0_.created_by AS created_by_10, c0_.updated_at AS updated_at_11, c0_.updated_by AS updated_by_12, c0_.currency AS currency_13, c0_.cruise_id AS cruise_id_14, c0_.cabin_category_id AS cabin_category_id_15, c0_.offer_id AS offer_id_16 FROM common_price c0_ INNER JOIN common_cabin_category c1_ ON c0_.cabin_category_id = c1_.id WHERE c0_.cruise_id = ? AND c1_.cabin_sub_type_id = ? AND c0_.base_cost_double > 0 ORDER BY c0_.base_cost_double ASC LIMIT 1
Parameters:
[ 4792 47 ] |
| 71 | 0.09 ms |
SELECT c0_.id AS id_0, c0_.fare_code AS fare_code_1, c0_.description AS description_2, c0_.price_family AS price_family_3, c0_.price_family_normalized AS price_family_normalized_4, c0_.flight_possible AS flight_possible_5, c0_.flight_included AS flight_included_6, c0_.base_cost_double AS base_cost_double_7, c0_.code AS code_8, c0_.created_at AS created_at_9, c0_.created_by AS created_by_10, c0_.updated_at AS updated_at_11, c0_.updated_by AS updated_by_12, c0_.currency AS currency_13, c0_.cruise_id AS cruise_id_14, c0_.cabin_category_id AS cabin_category_id_15, c0_.offer_id AS offer_id_16 FROM common_price c0_ INNER JOIN common_cabin_category c1_ ON c0_.cabin_category_id = c1_.id WHERE c0_.cruise_id = ? AND c1_.cabin_sub_type_id = ? AND c0_.base_cost_double > 0 ORDER BY c0_.base_cost_double ASC LIMIT 1
Parameters:
[ 4806 47 ] |
| 72 | 0.10 ms |
SELECT c0_.id AS id_0, c0_.fare_code AS fare_code_1, c0_.description AS description_2, c0_.price_family AS price_family_3, c0_.price_family_normalized AS price_family_normalized_4, c0_.flight_possible AS flight_possible_5, c0_.flight_included AS flight_included_6, c0_.base_cost_double AS base_cost_double_7, c0_.code AS code_8, c0_.created_at AS created_at_9, c0_.created_by AS created_by_10, c0_.updated_at AS updated_at_11, c0_.updated_by AS updated_by_12, c0_.currency AS currency_13, c0_.cruise_id AS cruise_id_14, c0_.cabin_category_id AS cabin_category_id_15, c0_.offer_id AS offer_id_16 FROM common_price c0_ INNER JOIN common_cabin_category c1_ ON c0_.cabin_category_id = c1_.id WHERE c0_.cruise_id = ? AND c1_.cabin_sub_type_id = ? AND c0_.base_cost_double > 0 ORDER BY c0_.base_cost_double ASC LIMIT 1
Parameters:
[ 4819 47 ] |
| 73 | 0.10 ms |
SELECT c0_.id AS id_0, c0_.fare_code AS fare_code_1, c0_.description AS description_2, c0_.price_family AS price_family_3, c0_.price_family_normalized AS price_family_normalized_4, c0_.flight_possible AS flight_possible_5, c0_.flight_included AS flight_included_6, c0_.base_cost_double AS base_cost_double_7, c0_.code AS code_8, c0_.created_at AS created_at_9, c0_.created_by AS created_by_10, c0_.updated_at AS updated_at_11, c0_.updated_by AS updated_by_12, c0_.currency AS currency_13, c0_.cruise_id AS cruise_id_14, c0_.cabin_category_id AS cabin_category_id_15, c0_.offer_id AS offer_id_16 FROM common_price c0_ INNER JOIN common_cabin_category c1_ ON c0_.cabin_category_id = c1_.id WHERE c0_.cruise_id = ? AND c1_.cabin_sub_type_id = ? AND c0_.base_cost_double > 0 ORDER BY c0_.base_cost_double ASC LIMIT 1
Parameters:
[ 4827 47 ] |
| 74 | 0.10 ms |
SELECT c0_.id AS id_0, c0_.fare_code AS fare_code_1, c0_.description AS description_2, c0_.price_family AS price_family_3, c0_.price_family_normalized AS price_family_normalized_4, c0_.flight_possible AS flight_possible_5, c0_.flight_included AS flight_included_6, c0_.base_cost_double AS base_cost_double_7, c0_.code AS code_8, c0_.created_at AS created_at_9, c0_.created_by AS created_by_10, c0_.updated_at AS updated_at_11, c0_.updated_by AS updated_by_12, c0_.currency AS currency_13, c0_.cruise_id AS cruise_id_14, c0_.cabin_category_id AS cabin_category_id_15, c0_.offer_id AS offer_id_16 FROM common_price c0_ INNER JOIN common_cabin_category c1_ ON c0_.cabin_category_id = c1_.id WHERE c0_.cruise_id = ? AND c1_.cabin_sub_type_id = ? AND c0_.base_cost_double > 0 ORDER BY c0_.base_cost_double ASC LIMIT 1
Parameters:
[ 4832 47 ] |
| 75 | 0.10 ms |
SELECT c0_.id AS id_0, c0_.fare_code AS fare_code_1, c0_.description AS description_2, c0_.price_family AS price_family_3, c0_.price_family_normalized AS price_family_normalized_4, c0_.flight_possible AS flight_possible_5, c0_.flight_included AS flight_included_6, c0_.base_cost_double AS base_cost_double_7, c0_.code AS code_8, c0_.created_at AS created_at_9, c0_.created_by AS created_by_10, c0_.updated_at AS updated_at_11, c0_.updated_by AS updated_by_12, c0_.currency AS currency_13, c0_.cruise_id AS cruise_id_14, c0_.cabin_category_id AS cabin_category_id_15, c0_.offer_id AS offer_id_16 FROM common_price c0_ INNER JOIN common_cabin_category c1_ ON c0_.cabin_category_id = c1_.id WHERE c0_.cruise_id = ? AND c1_.cabin_sub_type_id = ? AND c0_.base_cost_double > 0 ORDER BY c0_.base_cost_double ASC LIMIT 1
Parameters:
[ 4847 47 ] |
| 76 | 0.10 ms |
SELECT c0_.id AS id_0, c0_.fare_code AS fare_code_1, c0_.description AS description_2, c0_.price_family AS price_family_3, c0_.price_family_normalized AS price_family_normalized_4, c0_.flight_possible AS flight_possible_5, c0_.flight_included AS flight_included_6, c0_.base_cost_double AS base_cost_double_7, c0_.code AS code_8, c0_.created_at AS created_at_9, c0_.created_by AS created_by_10, c0_.updated_at AS updated_at_11, c0_.updated_by AS updated_by_12, c0_.currency AS currency_13, c0_.cruise_id AS cruise_id_14, c0_.cabin_category_id AS cabin_category_id_15, c0_.offer_id AS offer_id_16 FROM common_price c0_ INNER JOIN common_cabin_category c1_ ON c0_.cabin_category_id = c1_.id WHERE c0_.cruise_id = ? AND c1_.cabin_sub_type_id = ? AND c0_.base_cost_double > 0 ORDER BY c0_.base_cost_double ASC LIMIT 1
Parameters:
[ 4855 47 ] |
| 77 | 0.10 ms |
SELECT c0_.id AS id_0, c0_.fare_code AS fare_code_1, c0_.description AS description_2, c0_.price_family AS price_family_3, c0_.price_family_normalized AS price_family_normalized_4, c0_.flight_possible AS flight_possible_5, c0_.flight_included AS flight_included_6, c0_.base_cost_double AS base_cost_double_7, c0_.code AS code_8, c0_.created_at AS created_at_9, c0_.created_by AS created_by_10, c0_.updated_at AS updated_at_11, c0_.updated_by AS updated_by_12, c0_.currency AS currency_13, c0_.cruise_id AS cruise_id_14, c0_.cabin_category_id AS cabin_category_id_15, c0_.offer_id AS offer_id_16 FROM common_price c0_ INNER JOIN common_cabin_category c1_ ON c0_.cabin_category_id = c1_.id WHERE c0_.cruise_id = ? AND c1_.cabin_sub_type_id = ? AND c0_.base_cost_double > 0 ORDER BY c0_.base_cost_double ASC LIMIT 1
Parameters:
[ 4863 47 ] |
| 78 | 0.07 ms |
SELECT c0_.id AS id_0, c0_.fare_code AS fare_code_1, c0_.description AS description_2, c0_.price_family AS price_family_3, c0_.price_family_normalized AS price_family_normalized_4, c0_.flight_possible AS flight_possible_5, c0_.flight_included AS flight_included_6, c0_.base_cost_double AS base_cost_double_7, c0_.code AS code_8, c0_.created_at AS created_at_9, c0_.created_by AS created_by_10, c0_.updated_at AS updated_at_11, c0_.updated_by AS updated_by_12, c0_.currency AS currency_13, c0_.cruise_id AS cruise_id_14, c0_.cabin_category_id AS cabin_category_id_15, c0_.offer_id AS offer_id_16 FROM common_price c0_ INNER JOIN common_cabin_category c1_ ON c0_.cabin_category_id = c1_.id WHERE c0_.cruise_id = ? AND c1_.cabin_sub_type_id = ? AND c0_.base_cost_double > 0 ORDER BY c0_.base_cost_double ASC LIMIT 1
Parameters:
[ 4684 47 ] |
| 79 | 0.06 ms |
SELECT c0_.id AS id_0, c0_.fare_code AS fare_code_1, c0_.description AS description_2, c0_.price_family AS price_family_3, c0_.price_family_normalized AS price_family_normalized_4, c0_.flight_possible AS flight_possible_5, c0_.flight_included AS flight_included_6, c0_.base_cost_double AS base_cost_double_7, c0_.code AS code_8, c0_.created_at AS created_at_9, c0_.created_by AS created_by_10, c0_.updated_at AS updated_at_11, c0_.updated_by AS updated_by_12, c0_.currency AS currency_13, c0_.cruise_id AS cruise_id_14, c0_.cabin_category_id AS cabin_category_id_15, c0_.offer_id AS offer_id_16 FROM common_price c0_ INNER JOIN common_cabin_category c1_ ON c0_.cabin_category_id = c1_.id WHERE c0_.cruise_id = ? AND c1_.cabin_sub_type_id = ? AND c0_.base_cost_double > 0 ORDER BY c0_.base_cost_double ASC LIMIT 1
Parameters:
[ 4692 47 ] |
| 80 | 0.09 ms |
SELECT c0_.id AS id_0, c0_.fare_code AS fare_code_1, c0_.description AS description_2, c0_.price_family AS price_family_3, c0_.price_family_normalized AS price_family_normalized_4, c0_.flight_possible AS flight_possible_5, c0_.flight_included AS flight_included_6, c0_.base_cost_double AS base_cost_double_7, c0_.code AS code_8, c0_.created_at AS created_at_9, c0_.created_by AS created_by_10, c0_.updated_at AS updated_at_11, c0_.updated_by AS updated_by_12, c0_.currency AS currency_13, c0_.cruise_id AS cruise_id_14, c0_.cabin_category_id AS cabin_category_id_15, c0_.offer_id AS offer_id_16 FROM common_price c0_ INNER JOIN common_cabin_category c1_ ON c0_.cabin_category_id = c1_.id WHERE c0_.cruise_id = ? AND c1_.cabin_sub_type_id = ? AND c0_.base_cost_double > 0 ORDER BY c0_.base_cost_double ASC LIMIT 1
Parameters:
[ 4719 47 ] |
| 81 | 0.09 ms |
SELECT c0_.id AS id_0, c0_.fare_code AS fare_code_1, c0_.description AS description_2, c0_.price_family AS price_family_3, c0_.price_family_normalized AS price_family_normalized_4, c0_.flight_possible AS flight_possible_5, c0_.flight_included AS flight_included_6, c0_.base_cost_double AS base_cost_double_7, c0_.code AS code_8, c0_.created_at AS created_at_9, c0_.created_by AS created_by_10, c0_.updated_at AS updated_at_11, c0_.updated_by AS updated_by_12, c0_.currency AS currency_13, c0_.cruise_id AS cruise_id_14, c0_.cabin_category_id AS cabin_category_id_15, c0_.offer_id AS offer_id_16 FROM common_price c0_ INNER JOIN common_cabin_category c1_ ON c0_.cabin_category_id = c1_.id WHERE c0_.cruise_id = ? AND c1_.cabin_sub_type_id = ? AND c0_.base_cost_double > 0 ORDER BY c0_.base_cost_double ASC LIMIT 1
Parameters:
[ 4728 47 ] |
| 82 | 0.09 ms |
SELECT c0_.id AS id_0, c0_.fare_code AS fare_code_1, c0_.description AS description_2, c0_.price_family AS price_family_3, c0_.price_family_normalized AS price_family_normalized_4, c0_.flight_possible AS flight_possible_5, c0_.flight_included AS flight_included_6, c0_.base_cost_double AS base_cost_double_7, c0_.code AS code_8, c0_.created_at AS created_at_9, c0_.created_by AS created_by_10, c0_.updated_at AS updated_at_11, c0_.updated_by AS updated_by_12, c0_.currency AS currency_13, c0_.cruise_id AS cruise_id_14, c0_.cabin_category_id AS cabin_category_id_15, c0_.offer_id AS offer_id_16 FROM common_price c0_ INNER JOIN common_cabin_category c1_ ON c0_.cabin_category_id = c1_.id WHERE c0_.cruise_id = ? AND c1_.cabin_sub_type_id = ? AND c0_.base_cost_double > 0 ORDER BY c0_.base_cost_double ASC LIMIT 1
Parameters:
[ 4732 47 ] |
| 83 | 0.07 ms |
SELECT c0_.id AS id_0, c0_.fare_code AS fare_code_1, c0_.description AS description_2, c0_.price_family AS price_family_3, c0_.price_family_normalized AS price_family_normalized_4, c0_.flight_possible AS flight_possible_5, c0_.flight_included AS flight_included_6, c0_.base_cost_double AS base_cost_double_7, c0_.code AS code_8, c0_.created_at AS created_at_9, c0_.created_by AS created_by_10, c0_.updated_at AS updated_at_11, c0_.updated_by AS updated_by_12, c0_.currency AS currency_13, c0_.cruise_id AS cruise_id_14, c0_.cabin_category_id AS cabin_category_id_15, c0_.offer_id AS offer_id_16 FROM common_price c0_ INNER JOIN common_cabin_category c1_ ON c0_.cabin_category_id = c1_.id WHERE c0_.cruise_id = ? AND c1_.cabin_sub_type_id = ? AND c0_.base_cost_double > 0 ORDER BY c0_.base_cost_double ASC LIMIT 1
Parameters:
[ 4753 47 ] |
| 84 | 0.09 ms |
SELECT c0_.id AS id_0, c0_.fare_code AS fare_code_1, c0_.description AS description_2, c0_.price_family AS price_family_3, c0_.price_family_normalized AS price_family_normalized_4, c0_.flight_possible AS flight_possible_5, c0_.flight_included AS flight_included_6, c0_.base_cost_double AS base_cost_double_7, c0_.code AS code_8, c0_.created_at AS created_at_9, c0_.created_by AS created_by_10, c0_.updated_at AS updated_at_11, c0_.updated_by AS updated_by_12, c0_.currency AS currency_13, c0_.cruise_id AS cruise_id_14, c0_.cabin_category_id AS cabin_category_id_15, c0_.offer_id AS offer_id_16 FROM common_price c0_ INNER JOIN common_cabin_category c1_ ON c0_.cabin_category_id = c1_.id WHERE c0_.cruise_id = ? AND c1_.cabin_sub_type_id = ? AND c0_.base_cost_double > 0 ORDER BY c0_.base_cost_double ASC LIMIT 1
Parameters:
[ 4761 47 ] |
| 85 | 0.09 ms |
SELECT c0_.id AS id_0, c0_.fare_code AS fare_code_1, c0_.description AS description_2, c0_.price_family AS price_family_3, c0_.price_family_normalized AS price_family_normalized_4, c0_.flight_possible AS flight_possible_5, c0_.flight_included AS flight_included_6, c0_.base_cost_double AS base_cost_double_7, c0_.code AS code_8, c0_.created_at AS created_at_9, c0_.created_by AS created_by_10, c0_.updated_at AS updated_at_11, c0_.updated_by AS updated_by_12, c0_.currency AS currency_13, c0_.cruise_id AS cruise_id_14, c0_.cabin_category_id AS cabin_category_id_15, c0_.offer_id AS offer_id_16 FROM common_price c0_ INNER JOIN common_cabin_category c1_ ON c0_.cabin_category_id = c1_.id WHERE c0_.cruise_id = ? AND c1_.cabin_sub_type_id = ? AND c0_.base_cost_double > 0 ORDER BY c0_.base_cost_double ASC LIMIT 1
Parameters:
[ 4770 47 ] |
| 86 | 0.10 ms |
SELECT c0_.id AS id_0, c0_.fare_code AS fare_code_1, c0_.description AS description_2, c0_.price_family AS price_family_3, c0_.price_family_normalized AS price_family_normalized_4, c0_.flight_possible AS flight_possible_5, c0_.flight_included AS flight_included_6, c0_.base_cost_double AS base_cost_double_7, c0_.code AS code_8, c0_.created_at AS created_at_9, c0_.created_by AS created_by_10, c0_.updated_at AS updated_at_11, c0_.updated_by AS updated_by_12, c0_.currency AS currency_13, c0_.cruise_id AS cruise_id_14, c0_.cabin_category_id AS cabin_category_id_15, c0_.offer_id AS offer_id_16 FROM common_price c0_ INNER JOIN common_cabin_category c1_ ON c0_.cabin_category_id = c1_.id WHERE c0_.cruise_id = ? AND c1_.cabin_sub_type_id = ? AND c0_.base_cost_double > 0 ORDER BY c0_.base_cost_double ASC LIMIT 1
Parameters:
[ 4792 47 ] |
| 87 | 0.09 ms |
SELECT c0_.id AS id_0, c0_.fare_code AS fare_code_1, c0_.description AS description_2, c0_.price_family AS price_family_3, c0_.price_family_normalized AS price_family_normalized_4, c0_.flight_possible AS flight_possible_5, c0_.flight_included AS flight_included_6, c0_.base_cost_double AS base_cost_double_7, c0_.code AS code_8, c0_.created_at AS created_at_9, c0_.created_by AS created_by_10, c0_.updated_at AS updated_at_11, c0_.updated_by AS updated_by_12, c0_.currency AS currency_13, c0_.cruise_id AS cruise_id_14, c0_.cabin_category_id AS cabin_category_id_15, c0_.offer_id AS offer_id_16 FROM common_price c0_ INNER JOIN common_cabin_category c1_ ON c0_.cabin_category_id = c1_.id WHERE c0_.cruise_id = ? AND c1_.cabin_sub_type_id = ? AND c0_.base_cost_double > 0 ORDER BY c0_.base_cost_double ASC LIMIT 1
Parameters:
[ 4806 47 ] |
| 88 | 0.10 ms |
SELECT c0_.id AS id_0, c0_.fare_code AS fare_code_1, c0_.description AS description_2, c0_.price_family AS price_family_3, c0_.price_family_normalized AS price_family_normalized_4, c0_.flight_possible AS flight_possible_5, c0_.flight_included AS flight_included_6, c0_.base_cost_double AS base_cost_double_7, c0_.code AS code_8, c0_.created_at AS created_at_9, c0_.created_by AS created_by_10, c0_.updated_at AS updated_at_11, c0_.updated_by AS updated_by_12, c0_.currency AS currency_13, c0_.cruise_id AS cruise_id_14, c0_.cabin_category_id AS cabin_category_id_15, c0_.offer_id AS offer_id_16 FROM common_price c0_ INNER JOIN common_cabin_category c1_ ON c0_.cabin_category_id = c1_.id WHERE c0_.cruise_id = ? AND c1_.cabin_sub_type_id = ? AND c0_.base_cost_double > 0 ORDER BY c0_.base_cost_double ASC LIMIT 1
Parameters:
[ 4819 47 ] |
| 89 | 0.10 ms |
SELECT c0_.id AS id_0, c0_.fare_code AS fare_code_1, c0_.description AS description_2, c0_.price_family AS price_family_3, c0_.price_family_normalized AS price_family_normalized_4, c0_.flight_possible AS flight_possible_5, c0_.flight_included AS flight_included_6, c0_.base_cost_double AS base_cost_double_7, c0_.code AS code_8, c0_.created_at AS created_at_9, c0_.created_by AS created_by_10, c0_.updated_at AS updated_at_11, c0_.updated_by AS updated_by_12, c0_.currency AS currency_13, c0_.cruise_id AS cruise_id_14, c0_.cabin_category_id AS cabin_category_id_15, c0_.offer_id AS offer_id_16 FROM common_price c0_ INNER JOIN common_cabin_category c1_ ON c0_.cabin_category_id = c1_.id WHERE c0_.cruise_id = ? AND c1_.cabin_sub_type_id = ? AND c0_.base_cost_double > 0 ORDER BY c0_.base_cost_double ASC LIMIT 1
Parameters:
[ 4827 47 ] |
| 90 | 0.10 ms |
SELECT c0_.id AS id_0, c0_.fare_code AS fare_code_1, c0_.description AS description_2, c0_.price_family AS price_family_3, c0_.price_family_normalized AS price_family_normalized_4, c0_.flight_possible AS flight_possible_5, c0_.flight_included AS flight_included_6, c0_.base_cost_double AS base_cost_double_7, c0_.code AS code_8, c0_.created_at AS created_at_9, c0_.created_by AS created_by_10, c0_.updated_at AS updated_at_11, c0_.updated_by AS updated_by_12, c0_.currency AS currency_13, c0_.cruise_id AS cruise_id_14, c0_.cabin_category_id AS cabin_category_id_15, c0_.offer_id AS offer_id_16 FROM common_price c0_ INNER JOIN common_cabin_category c1_ ON c0_.cabin_category_id = c1_.id WHERE c0_.cruise_id = ? AND c1_.cabin_sub_type_id = ? AND c0_.base_cost_double > 0 ORDER BY c0_.base_cost_double ASC LIMIT 1
Parameters:
[ 4832 47 ] |
| 91 | 0.10 ms |
SELECT c0_.id AS id_0, c0_.fare_code AS fare_code_1, c0_.description AS description_2, c0_.price_family AS price_family_3, c0_.price_family_normalized AS price_family_normalized_4, c0_.flight_possible AS flight_possible_5, c0_.flight_included AS flight_included_6, c0_.base_cost_double AS base_cost_double_7, c0_.code AS code_8, c0_.created_at AS created_at_9, c0_.created_by AS created_by_10, c0_.updated_at AS updated_at_11, c0_.updated_by AS updated_by_12, c0_.currency AS currency_13, c0_.cruise_id AS cruise_id_14, c0_.cabin_category_id AS cabin_category_id_15, c0_.offer_id AS offer_id_16 FROM common_price c0_ INNER JOIN common_cabin_category c1_ ON c0_.cabin_category_id = c1_.id WHERE c0_.cruise_id = ? AND c1_.cabin_sub_type_id = ? AND c0_.base_cost_double > 0 ORDER BY c0_.base_cost_double ASC LIMIT 1
Parameters:
[ 4847 47 ] |
| 92 | 0.10 ms |
SELECT c0_.id AS id_0, c0_.fare_code AS fare_code_1, c0_.description AS description_2, c0_.price_family AS price_family_3, c0_.price_family_normalized AS price_family_normalized_4, c0_.flight_possible AS flight_possible_5, c0_.flight_included AS flight_included_6, c0_.base_cost_double AS base_cost_double_7, c0_.code AS code_8, c0_.created_at AS created_at_9, c0_.created_by AS created_by_10, c0_.updated_at AS updated_at_11, c0_.updated_by AS updated_by_12, c0_.currency AS currency_13, c0_.cruise_id AS cruise_id_14, c0_.cabin_category_id AS cabin_category_id_15, c0_.offer_id AS offer_id_16 FROM common_price c0_ INNER JOIN common_cabin_category c1_ ON c0_.cabin_category_id = c1_.id WHERE c0_.cruise_id = ? AND c1_.cabin_sub_type_id = ? AND c0_.base_cost_double > 0 ORDER BY c0_.base_cost_double ASC LIMIT 1
Parameters:
[ 4855 47 ] |
| 93 | 0.10 ms |
SELECT c0_.id AS id_0, c0_.fare_code AS fare_code_1, c0_.description AS description_2, c0_.price_family AS price_family_3, c0_.price_family_normalized AS price_family_normalized_4, c0_.flight_possible AS flight_possible_5, c0_.flight_included AS flight_included_6, c0_.base_cost_double AS base_cost_double_7, c0_.code AS code_8, c0_.created_at AS created_at_9, c0_.created_by AS created_by_10, c0_.updated_at AS updated_at_11, c0_.updated_by AS updated_by_12, c0_.currency AS currency_13, c0_.cruise_id AS cruise_id_14, c0_.cabin_category_id AS cabin_category_id_15, c0_.offer_id AS offer_id_16 FROM common_price c0_ INNER JOIN common_cabin_category c1_ ON c0_.cabin_category_id = c1_.id WHERE c0_.cruise_id = ? AND c1_.cabin_sub_type_id = ? AND c0_.base_cost_double > 0 ORDER BY c0_.base_cost_double ASC LIMIT 1
Parameters:
[ 4863 47 ] |
| 94 | 0.06 ms |
SELECT c0_.id AS id_0, c0_.fare_code AS fare_code_1, c0_.description AS description_2, c0_.price_family AS price_family_3, c0_.price_family_normalized AS price_family_normalized_4, c0_.flight_possible AS flight_possible_5, c0_.flight_included AS flight_included_6, c0_.base_cost_double AS base_cost_double_7, c0_.code AS code_8, c0_.created_at AS created_at_9, c0_.created_by AS created_by_10, c0_.updated_at AS updated_at_11, c0_.updated_by AS updated_by_12, c0_.currency AS currency_13, c0_.cruise_id AS cruise_id_14, c0_.cabin_category_id AS cabin_category_id_15, c0_.offer_id AS offer_id_16 FROM common_price c0_ INNER JOIN common_cabin_category c1_ ON c0_.cabin_category_id = c1_.id WHERE c0_.cruise_id = ? AND c1_.cabin_sub_type_id = ? AND c0_.base_cost_double > 0 ORDER BY c0_.base_cost_double ASC LIMIT 1
Parameters:
[ 4684 66 ] |
| 95 | 0.06 ms |
SELECT c0_.id AS id_0, c0_.fare_code AS fare_code_1, c0_.description AS description_2, c0_.price_family AS price_family_3, c0_.price_family_normalized AS price_family_normalized_4, c0_.flight_possible AS flight_possible_5, c0_.flight_included AS flight_included_6, c0_.base_cost_double AS base_cost_double_7, c0_.code AS code_8, c0_.created_at AS created_at_9, c0_.created_by AS created_by_10, c0_.updated_at AS updated_at_11, c0_.updated_by AS updated_by_12, c0_.currency AS currency_13, c0_.cruise_id AS cruise_id_14, c0_.cabin_category_id AS cabin_category_id_15, c0_.offer_id AS offer_id_16 FROM common_price c0_ INNER JOIN common_cabin_category c1_ ON c0_.cabin_category_id = c1_.id WHERE c0_.cruise_id = ? AND c1_.cabin_sub_type_id = ? AND c0_.base_cost_double > 0 ORDER BY c0_.base_cost_double ASC LIMIT 1
Parameters:
[ 4692 66 ] |
| 96 | 0.08 ms |
SELECT c0_.id AS id_0, c0_.fare_code AS fare_code_1, c0_.description AS description_2, c0_.price_family AS price_family_3, c0_.price_family_normalized AS price_family_normalized_4, c0_.flight_possible AS flight_possible_5, c0_.flight_included AS flight_included_6, c0_.base_cost_double AS base_cost_double_7, c0_.code AS code_8, c0_.created_at AS created_at_9, c0_.created_by AS created_by_10, c0_.updated_at AS updated_at_11, c0_.updated_by AS updated_by_12, c0_.currency AS currency_13, c0_.cruise_id AS cruise_id_14, c0_.cabin_category_id AS cabin_category_id_15, c0_.offer_id AS offer_id_16 FROM common_price c0_ INNER JOIN common_cabin_category c1_ ON c0_.cabin_category_id = c1_.id WHERE c0_.cruise_id = ? AND c1_.cabin_sub_type_id = ? AND c0_.base_cost_double > 0 ORDER BY c0_.base_cost_double ASC LIMIT 1
Parameters:
[ 4719 66 ] |
| 97 | 0.08 ms |
SELECT c0_.id AS id_0, c0_.fare_code AS fare_code_1, c0_.description AS description_2, c0_.price_family AS price_family_3, c0_.price_family_normalized AS price_family_normalized_4, c0_.flight_possible AS flight_possible_5, c0_.flight_included AS flight_included_6, c0_.base_cost_double AS base_cost_double_7, c0_.code AS code_8, c0_.created_at AS created_at_9, c0_.created_by AS created_by_10, c0_.updated_at AS updated_at_11, c0_.updated_by AS updated_by_12, c0_.currency AS currency_13, c0_.cruise_id AS cruise_id_14, c0_.cabin_category_id AS cabin_category_id_15, c0_.offer_id AS offer_id_16 FROM common_price c0_ INNER JOIN common_cabin_category c1_ ON c0_.cabin_category_id = c1_.id WHERE c0_.cruise_id = ? AND c1_.cabin_sub_type_id = ? AND c0_.base_cost_double > 0 ORDER BY c0_.base_cost_double ASC LIMIT 1
Parameters:
[ 4728 66 ] |
| 98 | 0.08 ms |
SELECT c0_.id AS id_0, c0_.fare_code AS fare_code_1, c0_.description AS description_2, c0_.price_family AS price_family_3, c0_.price_family_normalized AS price_family_normalized_4, c0_.flight_possible AS flight_possible_5, c0_.flight_included AS flight_included_6, c0_.base_cost_double AS base_cost_double_7, c0_.code AS code_8, c0_.created_at AS created_at_9, c0_.created_by AS created_by_10, c0_.updated_at AS updated_at_11, c0_.updated_by AS updated_by_12, c0_.currency AS currency_13, c0_.cruise_id AS cruise_id_14, c0_.cabin_category_id AS cabin_category_id_15, c0_.offer_id AS offer_id_16 FROM common_price c0_ INNER JOIN common_cabin_category c1_ ON c0_.cabin_category_id = c1_.id WHERE c0_.cruise_id = ? AND c1_.cabin_sub_type_id = ? AND c0_.base_cost_double > 0 ORDER BY c0_.base_cost_double ASC LIMIT 1
Parameters:
[ 4732 66 ] |
| 99 | 0.07 ms |
SELECT c0_.id AS id_0, c0_.fare_code AS fare_code_1, c0_.description AS description_2, c0_.price_family AS price_family_3, c0_.price_family_normalized AS price_family_normalized_4, c0_.flight_possible AS flight_possible_5, c0_.flight_included AS flight_included_6, c0_.base_cost_double AS base_cost_double_7, c0_.code AS code_8, c0_.created_at AS created_at_9, c0_.created_by AS created_by_10, c0_.updated_at AS updated_at_11, c0_.updated_by AS updated_by_12, c0_.currency AS currency_13, c0_.cruise_id AS cruise_id_14, c0_.cabin_category_id AS cabin_category_id_15, c0_.offer_id AS offer_id_16 FROM common_price c0_ INNER JOIN common_cabin_category c1_ ON c0_.cabin_category_id = c1_.id WHERE c0_.cruise_id = ? AND c1_.cabin_sub_type_id = ? AND c0_.base_cost_double > 0 ORDER BY c0_.base_cost_double ASC LIMIT 1
Parameters:
[ 4753 66 ] |
| 100 | 0.09 ms |
SELECT c0_.id AS id_0, c0_.fare_code AS fare_code_1, c0_.description AS description_2, c0_.price_family AS price_family_3, c0_.price_family_normalized AS price_family_normalized_4, c0_.flight_possible AS flight_possible_5, c0_.flight_included AS flight_included_6, c0_.base_cost_double AS base_cost_double_7, c0_.code AS code_8, c0_.created_at AS created_at_9, c0_.created_by AS created_by_10, c0_.updated_at AS updated_at_11, c0_.updated_by AS updated_by_12, c0_.currency AS currency_13, c0_.cruise_id AS cruise_id_14, c0_.cabin_category_id AS cabin_category_id_15, c0_.offer_id AS offer_id_16 FROM common_price c0_ INNER JOIN common_cabin_category c1_ ON c0_.cabin_category_id = c1_.id WHERE c0_.cruise_id = ? AND c1_.cabin_sub_type_id = ? AND c0_.base_cost_double > 0 ORDER BY c0_.base_cost_double ASC LIMIT 1
Parameters:
[ 4761 66 ] |
| 101 | 0.09 ms |
SELECT c0_.id AS id_0, c0_.fare_code AS fare_code_1, c0_.description AS description_2, c0_.price_family AS price_family_3, c0_.price_family_normalized AS price_family_normalized_4, c0_.flight_possible AS flight_possible_5, c0_.flight_included AS flight_included_6, c0_.base_cost_double AS base_cost_double_7, c0_.code AS code_8, c0_.created_at AS created_at_9, c0_.created_by AS created_by_10, c0_.updated_at AS updated_at_11, c0_.updated_by AS updated_by_12, c0_.currency AS currency_13, c0_.cruise_id AS cruise_id_14, c0_.cabin_category_id AS cabin_category_id_15, c0_.offer_id AS offer_id_16 FROM common_price c0_ INNER JOIN common_cabin_category c1_ ON c0_.cabin_category_id = c1_.id WHERE c0_.cruise_id = ? AND c1_.cabin_sub_type_id = ? AND c0_.base_cost_double > 0 ORDER BY c0_.base_cost_double ASC LIMIT 1
Parameters:
[ 4770 66 ] |
| 102 | 0.09 ms |
SELECT c0_.id AS id_0, c0_.fare_code AS fare_code_1, c0_.description AS description_2, c0_.price_family AS price_family_3, c0_.price_family_normalized AS price_family_normalized_4, c0_.flight_possible AS flight_possible_5, c0_.flight_included AS flight_included_6, c0_.base_cost_double AS base_cost_double_7, c0_.code AS code_8, c0_.created_at AS created_at_9, c0_.created_by AS created_by_10, c0_.updated_at AS updated_at_11, c0_.updated_by AS updated_by_12, c0_.currency AS currency_13, c0_.cruise_id AS cruise_id_14, c0_.cabin_category_id AS cabin_category_id_15, c0_.offer_id AS offer_id_16 FROM common_price c0_ INNER JOIN common_cabin_category c1_ ON c0_.cabin_category_id = c1_.id WHERE c0_.cruise_id = ? AND c1_.cabin_sub_type_id = ? AND c0_.base_cost_double > 0 ORDER BY c0_.base_cost_double ASC LIMIT 1
Parameters:
[ 4792 66 ] |
| 103 | 0.08 ms |
SELECT c0_.id AS id_0, c0_.fare_code AS fare_code_1, c0_.description AS description_2, c0_.price_family AS price_family_3, c0_.price_family_normalized AS price_family_normalized_4, c0_.flight_possible AS flight_possible_5, c0_.flight_included AS flight_included_6, c0_.base_cost_double AS base_cost_double_7, c0_.code AS code_8, c0_.created_at AS created_at_9, c0_.created_by AS created_by_10, c0_.updated_at AS updated_at_11, c0_.updated_by AS updated_by_12, c0_.currency AS currency_13, c0_.cruise_id AS cruise_id_14, c0_.cabin_category_id AS cabin_category_id_15, c0_.offer_id AS offer_id_16 FROM common_price c0_ INNER JOIN common_cabin_category c1_ ON c0_.cabin_category_id = c1_.id WHERE c0_.cruise_id = ? AND c1_.cabin_sub_type_id = ? AND c0_.base_cost_double > 0 ORDER BY c0_.base_cost_double ASC LIMIT 1
Parameters:
[ 4806 66 ] |
| 104 | 0.09 ms |
SELECT c0_.id AS id_0, c0_.fare_code AS fare_code_1, c0_.description AS description_2, c0_.price_family AS price_family_3, c0_.price_family_normalized AS price_family_normalized_4, c0_.flight_possible AS flight_possible_5, c0_.flight_included AS flight_included_6, c0_.base_cost_double AS base_cost_double_7, c0_.code AS code_8, c0_.created_at AS created_at_9, c0_.created_by AS created_by_10, c0_.updated_at AS updated_at_11, c0_.updated_by AS updated_by_12, c0_.currency AS currency_13, c0_.cruise_id AS cruise_id_14, c0_.cabin_category_id AS cabin_category_id_15, c0_.offer_id AS offer_id_16 FROM common_price c0_ INNER JOIN common_cabin_category c1_ ON c0_.cabin_category_id = c1_.id WHERE c0_.cruise_id = ? AND c1_.cabin_sub_type_id = ? AND c0_.base_cost_double > 0 ORDER BY c0_.base_cost_double ASC LIMIT 1
Parameters:
[ 4819 66 ] |
| 105 | 0.09 ms |
SELECT c0_.id AS id_0, c0_.fare_code AS fare_code_1, c0_.description AS description_2, c0_.price_family AS price_family_3, c0_.price_family_normalized AS price_family_normalized_4, c0_.flight_possible AS flight_possible_5, c0_.flight_included AS flight_included_6, c0_.base_cost_double AS base_cost_double_7, c0_.code AS code_8, c0_.created_at AS created_at_9, c0_.created_by AS created_by_10, c0_.updated_at AS updated_at_11, c0_.updated_by AS updated_by_12, c0_.currency AS currency_13, c0_.cruise_id AS cruise_id_14, c0_.cabin_category_id AS cabin_category_id_15, c0_.offer_id AS offer_id_16 FROM common_price c0_ INNER JOIN common_cabin_category c1_ ON c0_.cabin_category_id = c1_.id WHERE c0_.cruise_id = ? AND c1_.cabin_sub_type_id = ? AND c0_.base_cost_double > 0 ORDER BY c0_.base_cost_double ASC LIMIT 1
Parameters:
[ 4827 66 ] |
| 106 | 0.09 ms |
SELECT c0_.id AS id_0, c0_.fare_code AS fare_code_1, c0_.description AS description_2, c0_.price_family AS price_family_3, c0_.price_family_normalized AS price_family_normalized_4, c0_.flight_possible AS flight_possible_5, c0_.flight_included AS flight_included_6, c0_.base_cost_double AS base_cost_double_7, c0_.code AS code_8, c0_.created_at AS created_at_9, c0_.created_by AS created_by_10, c0_.updated_at AS updated_at_11, c0_.updated_by AS updated_by_12, c0_.currency AS currency_13, c0_.cruise_id AS cruise_id_14, c0_.cabin_category_id AS cabin_category_id_15, c0_.offer_id AS offer_id_16 FROM common_price c0_ INNER JOIN common_cabin_category c1_ ON c0_.cabin_category_id = c1_.id WHERE c0_.cruise_id = ? AND c1_.cabin_sub_type_id = ? AND c0_.base_cost_double > 0 ORDER BY c0_.base_cost_double ASC LIMIT 1
Parameters:
[ 4832 66 ] |
| 107 | 0.09 ms |
SELECT c0_.id AS id_0, c0_.fare_code AS fare_code_1, c0_.description AS description_2, c0_.price_family AS price_family_3, c0_.price_family_normalized AS price_family_normalized_4, c0_.flight_possible AS flight_possible_5, c0_.flight_included AS flight_included_6, c0_.base_cost_double AS base_cost_double_7, c0_.code AS code_8, c0_.created_at AS created_at_9, c0_.created_by AS created_by_10, c0_.updated_at AS updated_at_11, c0_.updated_by AS updated_by_12, c0_.currency AS currency_13, c0_.cruise_id AS cruise_id_14, c0_.cabin_category_id AS cabin_category_id_15, c0_.offer_id AS offer_id_16 FROM common_price c0_ INNER JOIN common_cabin_category c1_ ON c0_.cabin_category_id = c1_.id WHERE c0_.cruise_id = ? AND c1_.cabin_sub_type_id = ? AND c0_.base_cost_double > 0 ORDER BY c0_.base_cost_double ASC LIMIT 1
Parameters:
[ 4847 66 ] |
| 108 | 0.09 ms |
SELECT c0_.id AS id_0, c0_.fare_code AS fare_code_1, c0_.description AS description_2, c0_.price_family AS price_family_3, c0_.price_family_normalized AS price_family_normalized_4, c0_.flight_possible AS flight_possible_5, c0_.flight_included AS flight_included_6, c0_.base_cost_double AS base_cost_double_7, c0_.code AS code_8, c0_.created_at AS created_at_9, c0_.created_by AS created_by_10, c0_.updated_at AS updated_at_11, c0_.updated_by AS updated_by_12, c0_.currency AS currency_13, c0_.cruise_id AS cruise_id_14, c0_.cabin_category_id AS cabin_category_id_15, c0_.offer_id AS offer_id_16 FROM common_price c0_ INNER JOIN common_cabin_category c1_ ON c0_.cabin_category_id = c1_.id WHERE c0_.cruise_id = ? AND c1_.cabin_sub_type_id = ? AND c0_.base_cost_double > 0 ORDER BY c0_.base_cost_double ASC LIMIT 1
Parameters:
[ 4855 66 ] |
| 109 | 0.09 ms |
SELECT c0_.id AS id_0, c0_.fare_code AS fare_code_1, c0_.description AS description_2, c0_.price_family AS price_family_3, c0_.price_family_normalized AS price_family_normalized_4, c0_.flight_possible AS flight_possible_5, c0_.flight_included AS flight_included_6, c0_.base_cost_double AS base_cost_double_7, c0_.code AS code_8, c0_.created_at AS created_at_9, c0_.created_by AS created_by_10, c0_.updated_at AS updated_at_11, c0_.updated_by AS updated_by_12, c0_.currency AS currency_13, c0_.cruise_id AS cruise_id_14, c0_.cabin_category_id AS cabin_category_id_15, c0_.offer_id AS offer_id_16 FROM common_price c0_ INNER JOIN common_cabin_category c1_ ON c0_.cabin_category_id = c1_.id WHERE c0_.cruise_id = ? AND c1_.cabin_sub_type_id = ? AND c0_.base_cost_double > 0 ORDER BY c0_.base_cost_double ASC LIMIT 1
Parameters:
[ 4863 66 ] |
| 110 | 0.06 ms |
SELECT c0_.id AS id_0, c0_.fare_code AS fare_code_1, c0_.description AS description_2, c0_.price_family AS price_family_3, c0_.price_family_normalized AS price_family_normalized_4, c0_.flight_possible AS flight_possible_5, c0_.flight_included AS flight_included_6, c0_.base_cost_double AS base_cost_double_7, c0_.code AS code_8, c0_.created_at AS created_at_9, c0_.created_by AS created_by_10, c0_.updated_at AS updated_at_11, c0_.updated_by AS updated_by_12, c0_.currency AS currency_13, c0_.cruise_id AS cruise_id_14, c0_.cabin_category_id AS cabin_category_id_15, c0_.offer_id AS offer_id_16 FROM common_price c0_ INNER JOIN common_cabin_category c1_ ON c0_.cabin_category_id = c1_.id WHERE c0_.cruise_id = ? AND c1_.cabin_sub_type_id = ? AND c0_.base_cost_double > 0 ORDER BY c0_.base_cost_double ASC LIMIT 1
Parameters:
[ 4684 66 ] |
| 111 | 0.06 ms |
SELECT c0_.id AS id_0, c0_.fare_code AS fare_code_1, c0_.description AS description_2, c0_.price_family AS price_family_3, c0_.price_family_normalized AS price_family_normalized_4, c0_.flight_possible AS flight_possible_5, c0_.flight_included AS flight_included_6, c0_.base_cost_double AS base_cost_double_7, c0_.code AS code_8, c0_.created_at AS created_at_9, c0_.created_by AS created_by_10, c0_.updated_at AS updated_at_11, c0_.updated_by AS updated_by_12, c0_.currency AS currency_13, c0_.cruise_id AS cruise_id_14, c0_.cabin_category_id AS cabin_category_id_15, c0_.offer_id AS offer_id_16 FROM common_price c0_ INNER JOIN common_cabin_category c1_ ON c0_.cabin_category_id = c1_.id WHERE c0_.cruise_id = ? AND c1_.cabin_sub_type_id = ? AND c0_.base_cost_double > 0 ORDER BY c0_.base_cost_double ASC LIMIT 1
Parameters:
[ 4692 66 ] |
| 112 | 0.08 ms |
SELECT c0_.id AS id_0, c0_.fare_code AS fare_code_1, c0_.description AS description_2, c0_.price_family AS price_family_3, c0_.price_family_normalized AS price_family_normalized_4, c0_.flight_possible AS flight_possible_5, c0_.flight_included AS flight_included_6, c0_.base_cost_double AS base_cost_double_7, c0_.code AS code_8, c0_.created_at AS created_at_9, c0_.created_by AS created_by_10, c0_.updated_at AS updated_at_11, c0_.updated_by AS updated_by_12, c0_.currency AS currency_13, c0_.cruise_id AS cruise_id_14, c0_.cabin_category_id AS cabin_category_id_15, c0_.offer_id AS offer_id_16 FROM common_price c0_ INNER JOIN common_cabin_category c1_ ON c0_.cabin_category_id = c1_.id WHERE c0_.cruise_id = ? AND c1_.cabin_sub_type_id = ? AND c0_.base_cost_double > 0 ORDER BY c0_.base_cost_double ASC LIMIT 1
Parameters:
[ 4719 66 ] |
| 113 | 0.08 ms |
SELECT c0_.id AS id_0, c0_.fare_code AS fare_code_1, c0_.description AS description_2, c0_.price_family AS price_family_3, c0_.price_family_normalized AS price_family_normalized_4, c0_.flight_possible AS flight_possible_5, c0_.flight_included AS flight_included_6, c0_.base_cost_double AS base_cost_double_7, c0_.code AS code_8, c0_.created_at AS created_at_9, c0_.created_by AS created_by_10, c0_.updated_at AS updated_at_11, c0_.updated_by AS updated_by_12, c0_.currency AS currency_13, c0_.cruise_id AS cruise_id_14, c0_.cabin_category_id AS cabin_category_id_15, c0_.offer_id AS offer_id_16 FROM common_price c0_ INNER JOIN common_cabin_category c1_ ON c0_.cabin_category_id = c1_.id WHERE c0_.cruise_id = ? AND c1_.cabin_sub_type_id = ? AND c0_.base_cost_double > 0 ORDER BY c0_.base_cost_double ASC LIMIT 1
Parameters:
[ 4728 66 ] |
| 114 | 0.08 ms |
SELECT c0_.id AS id_0, c0_.fare_code AS fare_code_1, c0_.description AS description_2, c0_.price_family AS price_family_3, c0_.price_family_normalized AS price_family_normalized_4, c0_.flight_possible AS flight_possible_5, c0_.flight_included AS flight_included_6, c0_.base_cost_double AS base_cost_double_7, c0_.code AS code_8, c0_.created_at AS created_at_9, c0_.created_by AS created_by_10, c0_.updated_at AS updated_at_11, c0_.updated_by AS updated_by_12, c0_.currency AS currency_13, c0_.cruise_id AS cruise_id_14, c0_.cabin_category_id AS cabin_category_id_15, c0_.offer_id AS offer_id_16 FROM common_price c0_ INNER JOIN common_cabin_category c1_ ON c0_.cabin_category_id = c1_.id WHERE c0_.cruise_id = ? AND c1_.cabin_sub_type_id = ? AND c0_.base_cost_double > 0 ORDER BY c0_.base_cost_double ASC LIMIT 1
Parameters:
[ 4732 66 ] |
| 115 | 0.07 ms |
SELECT c0_.id AS id_0, c0_.fare_code AS fare_code_1, c0_.description AS description_2, c0_.price_family AS price_family_3, c0_.price_family_normalized AS price_family_normalized_4, c0_.flight_possible AS flight_possible_5, c0_.flight_included AS flight_included_6, c0_.base_cost_double AS base_cost_double_7, c0_.code AS code_8, c0_.created_at AS created_at_9, c0_.created_by AS created_by_10, c0_.updated_at AS updated_at_11, c0_.updated_by AS updated_by_12, c0_.currency AS currency_13, c0_.cruise_id AS cruise_id_14, c0_.cabin_category_id AS cabin_category_id_15, c0_.offer_id AS offer_id_16 FROM common_price c0_ INNER JOIN common_cabin_category c1_ ON c0_.cabin_category_id = c1_.id WHERE c0_.cruise_id = ? AND c1_.cabin_sub_type_id = ? AND c0_.base_cost_double > 0 ORDER BY c0_.base_cost_double ASC LIMIT 1
Parameters:
[ 4753 66 ] |
| 116 | 0.08 ms |
SELECT c0_.id AS id_0, c0_.fare_code AS fare_code_1, c0_.description AS description_2, c0_.price_family AS price_family_3, c0_.price_family_normalized AS price_family_normalized_4, c0_.flight_possible AS flight_possible_5, c0_.flight_included AS flight_included_6, c0_.base_cost_double AS base_cost_double_7, c0_.code AS code_8, c0_.created_at AS created_at_9, c0_.created_by AS created_by_10, c0_.updated_at AS updated_at_11, c0_.updated_by AS updated_by_12, c0_.currency AS currency_13, c0_.cruise_id AS cruise_id_14, c0_.cabin_category_id AS cabin_category_id_15, c0_.offer_id AS offer_id_16 FROM common_price c0_ INNER JOIN common_cabin_category c1_ ON c0_.cabin_category_id = c1_.id WHERE c0_.cruise_id = ? AND c1_.cabin_sub_type_id = ? AND c0_.base_cost_double > 0 ORDER BY c0_.base_cost_double ASC LIMIT 1
Parameters:
[ 4761 66 ] |
| 117 | 0.09 ms |
SELECT c0_.id AS id_0, c0_.fare_code AS fare_code_1, c0_.description AS description_2, c0_.price_family AS price_family_3, c0_.price_family_normalized AS price_family_normalized_4, c0_.flight_possible AS flight_possible_5, c0_.flight_included AS flight_included_6, c0_.base_cost_double AS base_cost_double_7, c0_.code AS code_8, c0_.created_at AS created_at_9, c0_.created_by AS created_by_10, c0_.updated_at AS updated_at_11, c0_.updated_by AS updated_by_12, c0_.currency AS currency_13, c0_.cruise_id AS cruise_id_14, c0_.cabin_category_id AS cabin_category_id_15, c0_.offer_id AS offer_id_16 FROM common_price c0_ INNER JOIN common_cabin_category c1_ ON c0_.cabin_category_id = c1_.id WHERE c0_.cruise_id = ? AND c1_.cabin_sub_type_id = ? AND c0_.base_cost_double > 0 ORDER BY c0_.base_cost_double ASC LIMIT 1
Parameters:
[ 4770 66 ] |
| 118 | 0.09 ms |
SELECT c0_.id AS id_0, c0_.fare_code AS fare_code_1, c0_.description AS description_2, c0_.price_family AS price_family_3, c0_.price_family_normalized AS price_family_normalized_4, c0_.flight_possible AS flight_possible_5, c0_.flight_included AS flight_included_6, c0_.base_cost_double AS base_cost_double_7, c0_.code AS code_8, c0_.created_at AS created_at_9, c0_.created_by AS created_by_10, c0_.updated_at AS updated_at_11, c0_.updated_by AS updated_by_12, c0_.currency AS currency_13, c0_.cruise_id AS cruise_id_14, c0_.cabin_category_id AS cabin_category_id_15, c0_.offer_id AS offer_id_16 FROM common_price c0_ INNER JOIN common_cabin_category c1_ ON c0_.cabin_category_id = c1_.id WHERE c0_.cruise_id = ? AND c1_.cabin_sub_type_id = ? AND c0_.base_cost_double > 0 ORDER BY c0_.base_cost_double ASC LIMIT 1
Parameters:
[ 4792 66 ] |
| 119 | 0.09 ms |
SELECT c0_.id AS id_0, c0_.fare_code AS fare_code_1, c0_.description AS description_2, c0_.price_family AS price_family_3, c0_.price_family_normalized AS price_family_normalized_4, c0_.flight_possible AS flight_possible_5, c0_.flight_included AS flight_included_6, c0_.base_cost_double AS base_cost_double_7, c0_.code AS code_8, c0_.created_at AS created_at_9, c0_.created_by AS created_by_10, c0_.updated_at AS updated_at_11, c0_.updated_by AS updated_by_12, c0_.currency AS currency_13, c0_.cruise_id AS cruise_id_14, c0_.cabin_category_id AS cabin_category_id_15, c0_.offer_id AS offer_id_16 FROM common_price c0_ INNER JOIN common_cabin_category c1_ ON c0_.cabin_category_id = c1_.id WHERE c0_.cruise_id = ? AND c1_.cabin_sub_type_id = ? AND c0_.base_cost_double > 0 ORDER BY c0_.base_cost_double ASC LIMIT 1
Parameters:
[ 4806 66 ] |
| 120 | 0.09 ms |
SELECT c0_.id AS id_0, c0_.fare_code AS fare_code_1, c0_.description AS description_2, c0_.price_family AS price_family_3, c0_.price_family_normalized AS price_family_normalized_4, c0_.flight_possible AS flight_possible_5, c0_.flight_included AS flight_included_6, c0_.base_cost_double AS base_cost_double_7, c0_.code AS code_8, c0_.created_at AS created_at_9, c0_.created_by AS created_by_10, c0_.updated_at AS updated_at_11, c0_.updated_by AS updated_by_12, c0_.currency AS currency_13, c0_.cruise_id AS cruise_id_14, c0_.cabin_category_id AS cabin_category_id_15, c0_.offer_id AS offer_id_16 FROM common_price c0_ INNER JOIN common_cabin_category c1_ ON c0_.cabin_category_id = c1_.id WHERE c0_.cruise_id = ? AND c1_.cabin_sub_type_id = ? AND c0_.base_cost_double > 0 ORDER BY c0_.base_cost_double ASC LIMIT 1
Parameters:
[ 4819 66 ] |
| 121 | 0.09 ms |
SELECT c0_.id AS id_0, c0_.fare_code AS fare_code_1, c0_.description AS description_2, c0_.price_family AS price_family_3, c0_.price_family_normalized AS price_family_normalized_4, c0_.flight_possible AS flight_possible_5, c0_.flight_included AS flight_included_6, c0_.base_cost_double AS base_cost_double_7, c0_.code AS code_8, c0_.created_at AS created_at_9, c0_.created_by AS created_by_10, c0_.updated_at AS updated_at_11, c0_.updated_by AS updated_by_12, c0_.currency AS currency_13, c0_.cruise_id AS cruise_id_14, c0_.cabin_category_id AS cabin_category_id_15, c0_.offer_id AS offer_id_16 FROM common_price c0_ INNER JOIN common_cabin_category c1_ ON c0_.cabin_category_id = c1_.id WHERE c0_.cruise_id = ? AND c1_.cabin_sub_type_id = ? AND c0_.base_cost_double > 0 ORDER BY c0_.base_cost_double ASC LIMIT 1
Parameters:
[ 4827 66 ] |
| 122 | 0.09 ms |
SELECT c0_.id AS id_0, c0_.fare_code AS fare_code_1, c0_.description AS description_2, c0_.price_family AS price_family_3, c0_.price_family_normalized AS price_family_normalized_4, c0_.flight_possible AS flight_possible_5, c0_.flight_included AS flight_included_6, c0_.base_cost_double AS base_cost_double_7, c0_.code AS code_8, c0_.created_at AS created_at_9, c0_.created_by AS created_by_10, c0_.updated_at AS updated_at_11, c0_.updated_by AS updated_by_12, c0_.currency AS currency_13, c0_.cruise_id AS cruise_id_14, c0_.cabin_category_id AS cabin_category_id_15, c0_.offer_id AS offer_id_16 FROM common_price c0_ INNER JOIN common_cabin_category c1_ ON c0_.cabin_category_id = c1_.id WHERE c0_.cruise_id = ? AND c1_.cabin_sub_type_id = ? AND c0_.base_cost_double > 0 ORDER BY c0_.base_cost_double ASC LIMIT 1
Parameters:
[ 4832 66 ] |
| 123 | 0.09 ms |
SELECT c0_.id AS id_0, c0_.fare_code AS fare_code_1, c0_.description AS description_2, c0_.price_family AS price_family_3, c0_.price_family_normalized AS price_family_normalized_4, c0_.flight_possible AS flight_possible_5, c0_.flight_included AS flight_included_6, c0_.base_cost_double AS base_cost_double_7, c0_.code AS code_8, c0_.created_at AS created_at_9, c0_.created_by AS created_by_10, c0_.updated_at AS updated_at_11, c0_.updated_by AS updated_by_12, c0_.currency AS currency_13, c0_.cruise_id AS cruise_id_14, c0_.cabin_category_id AS cabin_category_id_15, c0_.offer_id AS offer_id_16 FROM common_price c0_ INNER JOIN common_cabin_category c1_ ON c0_.cabin_category_id = c1_.id WHERE c0_.cruise_id = ? AND c1_.cabin_sub_type_id = ? AND c0_.base_cost_double > 0 ORDER BY c0_.base_cost_double ASC LIMIT 1
Parameters:
[ 4847 66 ] |
| 124 | 0.09 ms |
SELECT c0_.id AS id_0, c0_.fare_code AS fare_code_1, c0_.description AS description_2, c0_.price_family AS price_family_3, c0_.price_family_normalized AS price_family_normalized_4, c0_.flight_possible AS flight_possible_5, c0_.flight_included AS flight_included_6, c0_.base_cost_double AS base_cost_double_7, c0_.code AS code_8, c0_.created_at AS created_at_9, c0_.created_by AS created_by_10, c0_.updated_at AS updated_at_11, c0_.updated_by AS updated_by_12, c0_.currency AS currency_13, c0_.cruise_id AS cruise_id_14, c0_.cabin_category_id AS cabin_category_id_15, c0_.offer_id AS offer_id_16 FROM common_price c0_ INNER JOIN common_cabin_category c1_ ON c0_.cabin_category_id = c1_.id WHERE c0_.cruise_id = ? AND c1_.cabin_sub_type_id = ? AND c0_.base_cost_double > 0 ORDER BY c0_.base_cost_double ASC LIMIT 1
Parameters:
[ 4855 66 ] |
| 125 | 0.09 ms |
SELECT c0_.id AS id_0, c0_.fare_code AS fare_code_1, c0_.description AS description_2, c0_.price_family AS price_family_3, c0_.price_family_normalized AS price_family_normalized_4, c0_.flight_possible AS flight_possible_5, c0_.flight_included AS flight_included_6, c0_.base_cost_double AS base_cost_double_7, c0_.code AS code_8, c0_.created_at AS created_at_9, c0_.created_by AS created_by_10, c0_.updated_at AS updated_at_11, c0_.updated_by AS updated_by_12, c0_.currency AS currency_13, c0_.cruise_id AS cruise_id_14, c0_.cabin_category_id AS cabin_category_id_15, c0_.offer_id AS offer_id_16 FROM common_price c0_ INNER JOIN common_cabin_category c1_ ON c0_.cabin_category_id = c1_.id WHERE c0_.cruise_id = ? AND c1_.cabin_sub_type_id = ? AND c0_.base_cost_double > 0 ORDER BY c0_.base_cost_double ASC LIMIT 1
Parameters:
[ 4863 66 ] |
| 126 | 0.07 ms |
SELECT c0_.id AS id_0, c0_.fare_code AS fare_code_1, c0_.description AS description_2, c0_.price_family AS price_family_3, c0_.price_family_normalized AS price_family_normalized_4, c0_.flight_possible AS flight_possible_5, c0_.flight_included AS flight_included_6, c0_.base_cost_double AS base_cost_double_7, c0_.code AS code_8, c0_.created_at AS created_at_9, c0_.created_by AS created_by_10, c0_.updated_at AS updated_at_11, c0_.updated_by AS updated_by_12, c0_.currency AS currency_13, c0_.cruise_id AS cruise_id_14, c0_.cabin_category_id AS cabin_category_id_15, c0_.offer_id AS offer_id_16 FROM common_price c0_ INNER JOIN common_cabin_category c1_ ON c0_.cabin_category_id = c1_.id WHERE c0_.cruise_id = ? AND c1_.cabin_sub_type_id = ? AND c0_.base_cost_double > 0 ORDER BY c0_.base_cost_double ASC LIMIT 1
Parameters:
[ 4684 49 ] |
| 127 | 0.05 ms |
SELECT c0_.id AS id_0, c0_.fare_code AS fare_code_1, c0_.description AS description_2, c0_.price_family AS price_family_3, c0_.price_family_normalized AS price_family_normalized_4, c0_.flight_possible AS flight_possible_5, c0_.flight_included AS flight_included_6, c0_.base_cost_double AS base_cost_double_7, c0_.code AS code_8, c0_.created_at AS created_at_9, c0_.created_by AS created_by_10, c0_.updated_at AS updated_at_11, c0_.updated_by AS updated_by_12, c0_.currency AS currency_13, c0_.cruise_id AS cruise_id_14, c0_.cabin_category_id AS cabin_category_id_15, c0_.offer_id AS offer_id_16 FROM common_price c0_ INNER JOIN common_cabin_category c1_ ON c0_.cabin_category_id = c1_.id WHERE c0_.cruise_id = ? AND c1_.cabin_sub_type_id = ? AND c0_.base_cost_double > 0 ORDER BY c0_.base_cost_double ASC LIMIT 1
Parameters:
[ 4692 49 ] |
| 128 | 0.07 ms |
SELECT c0_.id AS id_0, c0_.fare_code AS fare_code_1, c0_.description AS description_2, c0_.price_family AS price_family_3, c0_.price_family_normalized AS price_family_normalized_4, c0_.flight_possible AS flight_possible_5, c0_.flight_included AS flight_included_6, c0_.base_cost_double AS base_cost_double_7, c0_.code AS code_8, c0_.created_at AS created_at_9, c0_.created_by AS created_by_10, c0_.updated_at AS updated_at_11, c0_.updated_by AS updated_by_12, c0_.currency AS currency_13, c0_.cruise_id AS cruise_id_14, c0_.cabin_category_id AS cabin_category_id_15, c0_.offer_id AS offer_id_16 FROM common_price c0_ INNER JOIN common_cabin_category c1_ ON c0_.cabin_category_id = c1_.id WHERE c0_.cruise_id = ? AND c1_.cabin_sub_type_id = ? AND c0_.base_cost_double > 0 ORDER BY c0_.base_cost_double ASC LIMIT 1
Parameters:
[ 4719 49 ] |
| 129 | 0.06 ms |
SELECT c0_.id AS id_0, c0_.fare_code AS fare_code_1, c0_.description AS description_2, c0_.price_family AS price_family_3, c0_.price_family_normalized AS price_family_normalized_4, c0_.flight_possible AS flight_possible_5, c0_.flight_included AS flight_included_6, c0_.base_cost_double AS base_cost_double_7, c0_.code AS code_8, c0_.created_at AS created_at_9, c0_.created_by AS created_by_10, c0_.updated_at AS updated_at_11, c0_.updated_by AS updated_by_12, c0_.currency AS currency_13, c0_.cruise_id AS cruise_id_14, c0_.cabin_category_id AS cabin_category_id_15, c0_.offer_id AS offer_id_16 FROM common_price c0_ INNER JOIN common_cabin_category c1_ ON c0_.cabin_category_id = c1_.id WHERE c0_.cruise_id = ? AND c1_.cabin_sub_type_id = ? AND c0_.base_cost_double > 0 ORDER BY c0_.base_cost_double ASC LIMIT 1
Parameters:
[ 4728 49 ] |
| 130 | 0.06 ms |
SELECT c0_.id AS id_0, c0_.fare_code AS fare_code_1, c0_.description AS description_2, c0_.price_family AS price_family_3, c0_.price_family_normalized AS price_family_normalized_4, c0_.flight_possible AS flight_possible_5, c0_.flight_included AS flight_included_6, c0_.base_cost_double AS base_cost_double_7, c0_.code AS code_8, c0_.created_at AS created_at_9, c0_.created_by AS created_by_10, c0_.updated_at AS updated_at_11, c0_.updated_by AS updated_by_12, c0_.currency AS currency_13, c0_.cruise_id AS cruise_id_14, c0_.cabin_category_id AS cabin_category_id_15, c0_.offer_id AS offer_id_16 FROM common_price c0_ INNER JOIN common_cabin_category c1_ ON c0_.cabin_category_id = c1_.id WHERE c0_.cruise_id = ? AND c1_.cabin_sub_type_id = ? AND c0_.base_cost_double > 0 ORDER BY c0_.base_cost_double ASC LIMIT 1
Parameters:
[ 4732 49 ] |
| 131 | 0.06 ms |
SELECT c0_.id AS id_0, c0_.fare_code AS fare_code_1, c0_.description AS description_2, c0_.price_family AS price_family_3, c0_.price_family_normalized AS price_family_normalized_4, c0_.flight_possible AS flight_possible_5, c0_.flight_included AS flight_included_6, c0_.base_cost_double AS base_cost_double_7, c0_.code AS code_8, c0_.created_at AS created_at_9, c0_.created_by AS created_by_10, c0_.updated_at AS updated_at_11, c0_.updated_by AS updated_by_12, c0_.currency AS currency_13, c0_.cruise_id AS cruise_id_14, c0_.cabin_category_id AS cabin_category_id_15, c0_.offer_id AS offer_id_16 FROM common_price c0_ INNER JOIN common_cabin_category c1_ ON c0_.cabin_category_id = c1_.id WHERE c0_.cruise_id = ? AND c1_.cabin_sub_type_id = ? AND c0_.base_cost_double > 0 ORDER BY c0_.base_cost_double ASC LIMIT 1
Parameters:
[ 4753 49 ] |
| 132 | 0.05 ms |
SELECT c0_.id AS id_0, c0_.fare_code AS fare_code_1, c0_.description AS description_2, c0_.price_family AS price_family_3, c0_.price_family_normalized AS price_family_normalized_4, c0_.flight_possible AS flight_possible_5, c0_.flight_included AS flight_included_6, c0_.base_cost_double AS base_cost_double_7, c0_.code AS code_8, c0_.created_at AS created_at_9, c0_.created_by AS created_by_10, c0_.updated_at AS updated_at_11, c0_.updated_by AS updated_by_12, c0_.currency AS currency_13, c0_.cruise_id AS cruise_id_14, c0_.cabin_category_id AS cabin_category_id_15, c0_.offer_id AS offer_id_16 FROM common_price c0_ INNER JOIN common_cabin_category c1_ ON c0_.cabin_category_id = c1_.id WHERE c0_.cruise_id = ? AND c1_.cabin_sub_type_id = ? AND c0_.base_cost_double > 0 ORDER BY c0_.base_cost_double ASC LIMIT 1
Parameters:
[ 4761 49 ] |
| 133 | 0.06 ms |
SELECT c0_.id AS id_0, c0_.fare_code AS fare_code_1, c0_.description AS description_2, c0_.price_family AS price_family_3, c0_.price_family_normalized AS price_family_normalized_4, c0_.flight_possible AS flight_possible_5, c0_.flight_included AS flight_included_6, c0_.base_cost_double AS base_cost_double_7, c0_.code AS code_8, c0_.created_at AS created_at_9, c0_.created_by AS created_by_10, c0_.updated_at AS updated_at_11, c0_.updated_by AS updated_by_12, c0_.currency AS currency_13, c0_.cruise_id AS cruise_id_14, c0_.cabin_category_id AS cabin_category_id_15, c0_.offer_id AS offer_id_16 FROM common_price c0_ INNER JOIN common_cabin_category c1_ ON c0_.cabin_category_id = c1_.id WHERE c0_.cruise_id = ? AND c1_.cabin_sub_type_id = ? AND c0_.base_cost_double > 0 ORDER BY c0_.base_cost_double ASC LIMIT 1
Parameters:
[ 4770 49 ] |
| 134 | 0.05 ms |
SELECT c0_.id AS id_0, c0_.fare_code AS fare_code_1, c0_.description AS description_2, c0_.price_family AS price_family_3, c0_.price_family_normalized AS price_family_normalized_4, c0_.flight_possible AS flight_possible_5, c0_.flight_included AS flight_included_6, c0_.base_cost_double AS base_cost_double_7, c0_.code AS code_8, c0_.created_at AS created_at_9, c0_.created_by AS created_by_10, c0_.updated_at AS updated_at_11, c0_.updated_by AS updated_by_12, c0_.currency AS currency_13, c0_.cruise_id AS cruise_id_14, c0_.cabin_category_id AS cabin_category_id_15, c0_.offer_id AS offer_id_16 FROM common_price c0_ INNER JOIN common_cabin_category c1_ ON c0_.cabin_category_id = c1_.id WHERE c0_.cruise_id = ? AND c1_.cabin_sub_type_id = ? AND c0_.base_cost_double > 0 ORDER BY c0_.base_cost_double ASC LIMIT 1
Parameters:
[ 4792 49 ] |
| 135 | 0.05 ms |
SELECT c0_.id AS id_0, c0_.fare_code AS fare_code_1, c0_.description AS description_2, c0_.price_family AS price_family_3, c0_.price_family_normalized AS price_family_normalized_4, c0_.flight_possible AS flight_possible_5, c0_.flight_included AS flight_included_6, c0_.base_cost_double AS base_cost_double_7, c0_.code AS code_8, c0_.created_at AS created_at_9, c0_.created_by AS created_by_10, c0_.updated_at AS updated_at_11, c0_.updated_by AS updated_by_12, c0_.currency AS currency_13, c0_.cruise_id AS cruise_id_14, c0_.cabin_category_id AS cabin_category_id_15, c0_.offer_id AS offer_id_16 FROM common_price c0_ INNER JOIN common_cabin_category c1_ ON c0_.cabin_category_id = c1_.id WHERE c0_.cruise_id = ? AND c1_.cabin_sub_type_id = ? AND c0_.base_cost_double > 0 ORDER BY c0_.base_cost_double ASC LIMIT 1
Parameters:
[ 4806 49 ] |
| 136 | 0.05 ms |
SELECT c0_.id AS id_0, c0_.fare_code AS fare_code_1, c0_.description AS description_2, c0_.price_family AS price_family_3, c0_.price_family_normalized AS price_family_normalized_4, c0_.flight_possible AS flight_possible_5, c0_.flight_included AS flight_included_6, c0_.base_cost_double AS base_cost_double_7, c0_.code AS code_8, c0_.created_at AS created_at_9, c0_.created_by AS created_by_10, c0_.updated_at AS updated_at_11, c0_.updated_by AS updated_by_12, c0_.currency AS currency_13, c0_.cruise_id AS cruise_id_14, c0_.cabin_category_id AS cabin_category_id_15, c0_.offer_id AS offer_id_16 FROM common_price c0_ INNER JOIN common_cabin_category c1_ ON c0_.cabin_category_id = c1_.id WHERE c0_.cruise_id = ? AND c1_.cabin_sub_type_id = ? AND c0_.base_cost_double > 0 ORDER BY c0_.base_cost_double ASC LIMIT 1
Parameters:
[ 4819 49 ] |
| 137 | 0.06 ms |
SELECT c0_.id AS id_0, c0_.fare_code AS fare_code_1, c0_.description AS description_2, c0_.price_family AS price_family_3, c0_.price_family_normalized AS price_family_normalized_4, c0_.flight_possible AS flight_possible_5, c0_.flight_included AS flight_included_6, c0_.base_cost_double AS base_cost_double_7, c0_.code AS code_8, c0_.created_at AS created_at_9, c0_.created_by AS created_by_10, c0_.updated_at AS updated_at_11, c0_.updated_by AS updated_by_12, c0_.currency AS currency_13, c0_.cruise_id AS cruise_id_14, c0_.cabin_category_id AS cabin_category_id_15, c0_.offer_id AS offer_id_16 FROM common_price c0_ INNER JOIN common_cabin_category c1_ ON c0_.cabin_category_id = c1_.id WHERE c0_.cruise_id = ? AND c1_.cabin_sub_type_id = ? AND c0_.base_cost_double > 0 ORDER BY c0_.base_cost_double ASC LIMIT 1
Parameters:
[ 4827 49 ] |
| 138 | 0.05 ms |
SELECT c0_.id AS id_0, c0_.fare_code AS fare_code_1, c0_.description AS description_2, c0_.price_family AS price_family_3, c0_.price_family_normalized AS price_family_normalized_4, c0_.flight_possible AS flight_possible_5, c0_.flight_included AS flight_included_6, c0_.base_cost_double AS base_cost_double_7, c0_.code AS code_8, c0_.created_at AS created_at_9, c0_.created_by AS created_by_10, c0_.updated_at AS updated_at_11, c0_.updated_by AS updated_by_12, c0_.currency AS currency_13, c0_.cruise_id AS cruise_id_14, c0_.cabin_category_id AS cabin_category_id_15, c0_.offer_id AS offer_id_16 FROM common_price c0_ INNER JOIN common_cabin_category c1_ ON c0_.cabin_category_id = c1_.id WHERE c0_.cruise_id = ? AND c1_.cabin_sub_type_id = ? AND c0_.base_cost_double > 0 ORDER BY c0_.base_cost_double ASC LIMIT 1
Parameters:
[ 4832 49 ] |
| 139 | 0.05 ms |
SELECT c0_.id AS id_0, c0_.fare_code AS fare_code_1, c0_.description AS description_2, c0_.price_family AS price_family_3, c0_.price_family_normalized AS price_family_normalized_4, c0_.flight_possible AS flight_possible_5, c0_.flight_included AS flight_included_6, c0_.base_cost_double AS base_cost_double_7, c0_.code AS code_8, c0_.created_at AS created_at_9, c0_.created_by AS created_by_10, c0_.updated_at AS updated_at_11, c0_.updated_by AS updated_by_12, c0_.currency AS currency_13, c0_.cruise_id AS cruise_id_14, c0_.cabin_category_id AS cabin_category_id_15, c0_.offer_id AS offer_id_16 FROM common_price c0_ INNER JOIN common_cabin_category c1_ ON c0_.cabin_category_id = c1_.id WHERE c0_.cruise_id = ? AND c1_.cabin_sub_type_id = ? AND c0_.base_cost_double > 0 ORDER BY c0_.base_cost_double ASC LIMIT 1
Parameters:
[ 4847 49 ] |
| 140 | 0.06 ms |
SELECT c0_.id AS id_0, c0_.fare_code AS fare_code_1, c0_.description AS description_2, c0_.price_family AS price_family_3, c0_.price_family_normalized AS price_family_normalized_4, c0_.flight_possible AS flight_possible_5, c0_.flight_included AS flight_included_6, c0_.base_cost_double AS base_cost_double_7, c0_.code AS code_8, c0_.created_at AS created_at_9, c0_.created_by AS created_by_10, c0_.updated_at AS updated_at_11, c0_.updated_by AS updated_by_12, c0_.currency AS currency_13, c0_.cruise_id AS cruise_id_14, c0_.cabin_category_id AS cabin_category_id_15, c0_.offer_id AS offer_id_16 FROM common_price c0_ INNER JOIN common_cabin_category c1_ ON c0_.cabin_category_id = c1_.id WHERE c0_.cruise_id = ? AND c1_.cabin_sub_type_id = ? AND c0_.base_cost_double > 0 ORDER BY c0_.base_cost_double ASC LIMIT 1
Parameters:
[ 4855 49 ] |
| 141 | 0.05 ms |
SELECT c0_.id AS id_0, c0_.fare_code AS fare_code_1, c0_.description AS description_2, c0_.price_family AS price_family_3, c0_.price_family_normalized AS price_family_normalized_4, c0_.flight_possible AS flight_possible_5, c0_.flight_included AS flight_included_6, c0_.base_cost_double AS base_cost_double_7, c0_.code AS code_8, c0_.created_at AS created_at_9, c0_.created_by AS created_by_10, c0_.updated_at AS updated_at_11, c0_.updated_by AS updated_by_12, c0_.currency AS currency_13, c0_.cruise_id AS cruise_id_14, c0_.cabin_category_id AS cabin_category_id_15, c0_.offer_id AS offer_id_16 FROM common_price c0_ INNER JOIN common_cabin_category c1_ ON c0_.cabin_category_id = c1_.id WHERE c0_.cruise_id = ? AND c1_.cabin_sub_type_id = ? AND c0_.base_cost_double > 0 ORDER BY c0_.base_cost_double ASC LIMIT 1
Parameters:
[ 4863 49 ] |
| 142 | 0.07 ms |
SELECT c0_.id AS id_0, c0_.fare_code AS fare_code_1, c0_.description AS description_2, c0_.price_family AS price_family_3, c0_.price_family_normalized AS price_family_normalized_4, c0_.flight_possible AS flight_possible_5, c0_.flight_included AS flight_included_6, c0_.base_cost_double AS base_cost_double_7, c0_.code AS code_8, c0_.created_at AS created_at_9, c0_.created_by AS created_by_10, c0_.updated_at AS updated_at_11, c0_.updated_by AS updated_by_12, c0_.currency AS currency_13, c0_.cruise_id AS cruise_id_14, c0_.cabin_category_id AS cabin_category_id_15, c0_.offer_id AS offer_id_16 FROM common_price c0_ INNER JOIN common_cabin_category c1_ ON c0_.cabin_category_id = c1_.id WHERE c0_.cruise_id = ? AND c1_.cabin_sub_type_id = ? AND c0_.base_cost_double > 0 ORDER BY c0_.base_cost_double ASC LIMIT 1
Parameters:
[ 4684 49 ] |
| 143 | 0.06 ms |
SELECT c0_.id AS id_0, c0_.fare_code AS fare_code_1, c0_.description AS description_2, c0_.price_family AS price_family_3, c0_.price_family_normalized AS price_family_normalized_4, c0_.flight_possible AS flight_possible_5, c0_.flight_included AS flight_included_6, c0_.base_cost_double AS base_cost_double_7, c0_.code AS code_8, c0_.created_at AS created_at_9, c0_.created_by AS created_by_10, c0_.updated_at AS updated_at_11, c0_.updated_by AS updated_by_12, c0_.currency AS currency_13, c0_.cruise_id AS cruise_id_14, c0_.cabin_category_id AS cabin_category_id_15, c0_.offer_id AS offer_id_16 FROM common_price c0_ INNER JOIN common_cabin_category c1_ ON c0_.cabin_category_id = c1_.id WHERE c0_.cruise_id = ? AND c1_.cabin_sub_type_id = ? AND c0_.base_cost_double > 0 ORDER BY c0_.base_cost_double ASC LIMIT 1
Parameters:
[ 4692 49 ] |
| 144 | 0.06 ms |
SELECT c0_.id AS id_0, c0_.fare_code AS fare_code_1, c0_.description AS description_2, c0_.price_family AS price_family_3, c0_.price_family_normalized AS price_family_normalized_4, c0_.flight_possible AS flight_possible_5, c0_.flight_included AS flight_included_6, c0_.base_cost_double AS base_cost_double_7, c0_.code AS code_8, c0_.created_at AS created_at_9, c0_.created_by AS created_by_10, c0_.updated_at AS updated_at_11, c0_.updated_by AS updated_by_12, c0_.currency AS currency_13, c0_.cruise_id AS cruise_id_14, c0_.cabin_category_id AS cabin_category_id_15, c0_.offer_id AS offer_id_16 FROM common_price c0_ INNER JOIN common_cabin_category c1_ ON c0_.cabin_category_id = c1_.id WHERE c0_.cruise_id = ? AND c1_.cabin_sub_type_id = ? AND c0_.base_cost_double > 0 ORDER BY c0_.base_cost_double ASC LIMIT 1
Parameters:
[ 4719 49 ] |
| 145 | 0.05 ms |
SELECT c0_.id AS id_0, c0_.fare_code AS fare_code_1, c0_.description AS description_2, c0_.price_family AS price_family_3, c0_.price_family_normalized AS price_family_normalized_4, c0_.flight_possible AS flight_possible_5, c0_.flight_included AS flight_included_6, c0_.base_cost_double AS base_cost_double_7, c0_.code AS code_8, c0_.created_at AS created_at_9, c0_.created_by AS created_by_10, c0_.updated_at AS updated_at_11, c0_.updated_by AS updated_by_12, c0_.currency AS currency_13, c0_.cruise_id AS cruise_id_14, c0_.cabin_category_id AS cabin_category_id_15, c0_.offer_id AS offer_id_16 FROM common_price c0_ INNER JOIN common_cabin_category c1_ ON c0_.cabin_category_id = c1_.id WHERE c0_.cruise_id = ? AND c1_.cabin_sub_type_id = ? AND c0_.base_cost_double > 0 ORDER BY c0_.base_cost_double ASC LIMIT 1
Parameters:
[ 4728 49 ] |
| 146 | 0.06 ms |
SELECT c0_.id AS id_0, c0_.fare_code AS fare_code_1, c0_.description AS description_2, c0_.price_family AS price_family_3, c0_.price_family_normalized AS price_family_normalized_4, c0_.flight_possible AS flight_possible_5, c0_.flight_included AS flight_included_6, c0_.base_cost_double AS base_cost_double_7, c0_.code AS code_8, c0_.created_at AS created_at_9, c0_.created_by AS created_by_10, c0_.updated_at AS updated_at_11, c0_.updated_by AS updated_by_12, c0_.currency AS currency_13, c0_.cruise_id AS cruise_id_14, c0_.cabin_category_id AS cabin_category_id_15, c0_.offer_id AS offer_id_16 FROM common_price c0_ INNER JOIN common_cabin_category c1_ ON c0_.cabin_category_id = c1_.id WHERE c0_.cruise_id = ? AND c1_.cabin_sub_type_id = ? AND c0_.base_cost_double > 0 ORDER BY c0_.base_cost_double ASC LIMIT 1
Parameters:
[ 4732 49 ] |
| 147 | 0.05 ms |
SELECT c0_.id AS id_0, c0_.fare_code AS fare_code_1, c0_.description AS description_2, c0_.price_family AS price_family_3, c0_.price_family_normalized AS price_family_normalized_4, c0_.flight_possible AS flight_possible_5, c0_.flight_included AS flight_included_6, c0_.base_cost_double AS base_cost_double_7, c0_.code AS code_8, c0_.created_at AS created_at_9, c0_.created_by AS created_by_10, c0_.updated_at AS updated_at_11, c0_.updated_by AS updated_by_12, c0_.currency AS currency_13, c0_.cruise_id AS cruise_id_14, c0_.cabin_category_id AS cabin_category_id_15, c0_.offer_id AS offer_id_16 FROM common_price c0_ INNER JOIN common_cabin_category c1_ ON c0_.cabin_category_id = c1_.id WHERE c0_.cruise_id = ? AND c1_.cabin_sub_type_id = ? AND c0_.base_cost_double > 0 ORDER BY c0_.base_cost_double ASC LIMIT 1
Parameters:
[ 4753 49 ] |
| 148 | 0.05 ms |
SELECT c0_.id AS id_0, c0_.fare_code AS fare_code_1, c0_.description AS description_2, c0_.price_family AS price_family_3, c0_.price_family_normalized AS price_family_normalized_4, c0_.flight_possible AS flight_possible_5, c0_.flight_included AS flight_included_6, c0_.base_cost_double AS base_cost_double_7, c0_.code AS code_8, c0_.created_at AS created_at_9, c0_.created_by AS created_by_10, c0_.updated_at AS updated_at_11, c0_.updated_by AS updated_by_12, c0_.currency AS currency_13, c0_.cruise_id AS cruise_id_14, c0_.cabin_category_id AS cabin_category_id_15, c0_.offer_id AS offer_id_16 FROM common_price c0_ INNER JOIN common_cabin_category c1_ ON c0_.cabin_category_id = c1_.id WHERE c0_.cruise_id = ? AND c1_.cabin_sub_type_id = ? AND c0_.base_cost_double > 0 ORDER BY c0_.base_cost_double ASC LIMIT 1
Parameters:
[ 4761 49 ] |
| 149 | 0.05 ms |
SELECT c0_.id AS id_0, c0_.fare_code AS fare_code_1, c0_.description AS description_2, c0_.price_family AS price_family_3, c0_.price_family_normalized AS price_family_normalized_4, c0_.flight_possible AS flight_possible_5, c0_.flight_included AS flight_included_6, c0_.base_cost_double AS base_cost_double_7, c0_.code AS code_8, c0_.created_at AS created_at_9, c0_.created_by AS created_by_10, c0_.updated_at AS updated_at_11, c0_.updated_by AS updated_by_12, c0_.currency AS currency_13, c0_.cruise_id AS cruise_id_14, c0_.cabin_category_id AS cabin_category_id_15, c0_.offer_id AS offer_id_16 FROM common_price c0_ INNER JOIN common_cabin_category c1_ ON c0_.cabin_category_id = c1_.id WHERE c0_.cruise_id = ? AND c1_.cabin_sub_type_id = ? AND c0_.base_cost_double > 0 ORDER BY c0_.base_cost_double ASC LIMIT 1
Parameters:
[ 4770 49 ] |
| 150 | 0.05 ms |
SELECT c0_.id AS id_0, c0_.fare_code AS fare_code_1, c0_.description AS description_2, c0_.price_family AS price_family_3, c0_.price_family_normalized AS price_family_normalized_4, c0_.flight_possible AS flight_possible_5, c0_.flight_included AS flight_included_6, c0_.base_cost_double AS base_cost_double_7, c0_.code AS code_8, c0_.created_at AS created_at_9, c0_.created_by AS created_by_10, c0_.updated_at AS updated_at_11, c0_.updated_by AS updated_by_12, c0_.currency AS currency_13, c0_.cruise_id AS cruise_id_14, c0_.cabin_category_id AS cabin_category_id_15, c0_.offer_id AS offer_id_16 FROM common_price c0_ INNER JOIN common_cabin_category c1_ ON c0_.cabin_category_id = c1_.id WHERE c0_.cruise_id = ? AND c1_.cabin_sub_type_id = ? AND c0_.base_cost_double > 0 ORDER BY c0_.base_cost_double ASC LIMIT 1
Parameters:
[ 4792 49 ] |
| 151 | 0.05 ms |
SELECT c0_.id AS id_0, c0_.fare_code AS fare_code_1, c0_.description AS description_2, c0_.price_family AS price_family_3, c0_.price_family_normalized AS price_family_normalized_4, c0_.flight_possible AS flight_possible_5, c0_.flight_included AS flight_included_6, c0_.base_cost_double AS base_cost_double_7, c0_.code AS code_8, c0_.created_at AS created_at_9, c0_.created_by AS created_by_10, c0_.updated_at AS updated_at_11, c0_.updated_by AS updated_by_12, c0_.currency AS currency_13, c0_.cruise_id AS cruise_id_14, c0_.cabin_category_id AS cabin_category_id_15, c0_.offer_id AS offer_id_16 FROM common_price c0_ INNER JOIN common_cabin_category c1_ ON c0_.cabin_category_id = c1_.id WHERE c0_.cruise_id = ? AND c1_.cabin_sub_type_id = ? AND c0_.base_cost_double > 0 ORDER BY c0_.base_cost_double ASC LIMIT 1
Parameters:
[ 4806 49 ] |
| 152 | 0.05 ms |
SELECT c0_.id AS id_0, c0_.fare_code AS fare_code_1, c0_.description AS description_2, c0_.price_family AS price_family_3, c0_.price_family_normalized AS price_family_normalized_4, c0_.flight_possible AS flight_possible_5, c0_.flight_included AS flight_included_6, c0_.base_cost_double AS base_cost_double_7, c0_.code AS code_8, c0_.created_at AS created_at_9, c0_.created_by AS created_by_10, c0_.updated_at AS updated_at_11, c0_.updated_by AS updated_by_12, c0_.currency AS currency_13, c0_.cruise_id AS cruise_id_14, c0_.cabin_category_id AS cabin_category_id_15, c0_.offer_id AS offer_id_16 FROM common_price c0_ INNER JOIN common_cabin_category c1_ ON c0_.cabin_category_id = c1_.id WHERE c0_.cruise_id = ? AND c1_.cabin_sub_type_id = ? AND c0_.base_cost_double > 0 ORDER BY c0_.base_cost_double ASC LIMIT 1
Parameters:
[ 4819 49 ] |
| 153 | 0.06 ms |
SELECT c0_.id AS id_0, c0_.fare_code AS fare_code_1, c0_.description AS description_2, c0_.price_family AS price_family_3, c0_.price_family_normalized AS price_family_normalized_4, c0_.flight_possible AS flight_possible_5, c0_.flight_included AS flight_included_6, c0_.base_cost_double AS base_cost_double_7, c0_.code AS code_8, c0_.created_at AS created_at_9, c0_.created_by AS created_by_10, c0_.updated_at AS updated_at_11, c0_.updated_by AS updated_by_12, c0_.currency AS currency_13, c0_.cruise_id AS cruise_id_14, c0_.cabin_category_id AS cabin_category_id_15, c0_.offer_id AS offer_id_16 FROM common_price c0_ INNER JOIN common_cabin_category c1_ ON c0_.cabin_category_id = c1_.id WHERE c0_.cruise_id = ? AND c1_.cabin_sub_type_id = ? AND c0_.base_cost_double > 0 ORDER BY c0_.base_cost_double ASC LIMIT 1
Parameters:
[ 4827 49 ] |
| 154 | 0.05 ms |
SELECT c0_.id AS id_0, c0_.fare_code AS fare_code_1, c0_.description AS description_2, c0_.price_family AS price_family_3, c0_.price_family_normalized AS price_family_normalized_4, c0_.flight_possible AS flight_possible_5, c0_.flight_included AS flight_included_6, c0_.base_cost_double AS base_cost_double_7, c0_.code AS code_8, c0_.created_at AS created_at_9, c0_.created_by AS created_by_10, c0_.updated_at AS updated_at_11, c0_.updated_by AS updated_by_12, c0_.currency AS currency_13, c0_.cruise_id AS cruise_id_14, c0_.cabin_category_id AS cabin_category_id_15, c0_.offer_id AS offer_id_16 FROM common_price c0_ INNER JOIN common_cabin_category c1_ ON c0_.cabin_category_id = c1_.id WHERE c0_.cruise_id = ? AND c1_.cabin_sub_type_id = ? AND c0_.base_cost_double > 0 ORDER BY c0_.base_cost_double ASC LIMIT 1
Parameters:
[ 4832 49 ] |
| 155 | 0.05 ms |
SELECT c0_.id AS id_0, c0_.fare_code AS fare_code_1, c0_.description AS description_2, c0_.price_family AS price_family_3, c0_.price_family_normalized AS price_family_normalized_4, c0_.flight_possible AS flight_possible_5, c0_.flight_included AS flight_included_6, c0_.base_cost_double AS base_cost_double_7, c0_.code AS code_8, c0_.created_at AS created_at_9, c0_.created_by AS created_by_10, c0_.updated_at AS updated_at_11, c0_.updated_by AS updated_by_12, c0_.currency AS currency_13, c0_.cruise_id AS cruise_id_14, c0_.cabin_category_id AS cabin_category_id_15, c0_.offer_id AS offer_id_16 FROM common_price c0_ INNER JOIN common_cabin_category c1_ ON c0_.cabin_category_id = c1_.id WHERE c0_.cruise_id = ? AND c1_.cabin_sub_type_id = ? AND c0_.base_cost_double > 0 ORDER BY c0_.base_cost_double ASC LIMIT 1
Parameters:
[ 4847 49 ] |
| 156 | 0.05 ms |
SELECT c0_.id AS id_0, c0_.fare_code AS fare_code_1, c0_.description AS description_2, c0_.price_family AS price_family_3, c0_.price_family_normalized AS price_family_normalized_4, c0_.flight_possible AS flight_possible_5, c0_.flight_included AS flight_included_6, c0_.base_cost_double AS base_cost_double_7, c0_.code AS code_8, c0_.created_at AS created_at_9, c0_.created_by AS created_by_10, c0_.updated_at AS updated_at_11, c0_.updated_by AS updated_by_12, c0_.currency AS currency_13, c0_.cruise_id AS cruise_id_14, c0_.cabin_category_id AS cabin_category_id_15, c0_.offer_id AS offer_id_16 FROM common_price c0_ INNER JOIN common_cabin_category c1_ ON c0_.cabin_category_id = c1_.id WHERE c0_.cruise_id = ? AND c1_.cabin_sub_type_id = ? AND c0_.base_cost_double > 0 ORDER BY c0_.base_cost_double ASC LIMIT 1
Parameters:
[ 4855 49 ] |
| 157 | 0.05 ms |
SELECT c0_.id AS id_0, c0_.fare_code AS fare_code_1, c0_.description AS description_2, c0_.price_family AS price_family_3, c0_.price_family_normalized AS price_family_normalized_4, c0_.flight_possible AS flight_possible_5, c0_.flight_included AS flight_included_6, c0_.base_cost_double AS base_cost_double_7, c0_.code AS code_8, c0_.created_at AS created_at_9, c0_.created_by AS created_by_10, c0_.updated_at AS updated_at_11, c0_.updated_by AS updated_by_12, c0_.currency AS currency_13, c0_.cruise_id AS cruise_id_14, c0_.cabin_category_id AS cabin_category_id_15, c0_.offer_id AS offer_id_16 FROM common_price c0_ INNER JOIN common_cabin_category c1_ ON c0_.cabin_category_id = c1_.id WHERE c0_.cruise_id = ? AND c1_.cabin_sub_type_id = ? AND c0_.base_cost_double > 0 ORDER BY c0_.base_cost_double ASC LIMIT 1
Parameters:
[ 4863 49 ] |
| 158 | 0.06 ms |
SELECT c0_.id AS id_0, c0_.fare_code AS fare_code_1, c0_.description AS description_2, c0_.price_family AS price_family_3, c0_.price_family_normalized AS price_family_normalized_4, c0_.flight_possible AS flight_possible_5, c0_.flight_included AS flight_included_6, c0_.base_cost_double AS base_cost_double_7, c0_.code AS code_8, c0_.created_at AS created_at_9, c0_.created_by AS created_by_10, c0_.updated_at AS updated_at_11, c0_.updated_by AS updated_by_12, c0_.currency AS currency_13, c0_.cruise_id AS cruise_id_14, c0_.cabin_category_id AS cabin_category_id_15, c0_.offer_id AS offer_id_16 FROM common_price c0_ INNER JOIN common_cabin_category c1_ ON c0_.cabin_category_id = c1_.id WHERE c0_.cruise_id = ? AND c1_.cabin_sub_type_id = ? AND c0_.base_cost_double > 0 ORDER BY c0_.base_cost_double ASC LIMIT 1
Parameters:
[ 4684 48 ] |
| 159 | 0.05 ms |
SELECT c0_.id AS id_0, c0_.fare_code AS fare_code_1, c0_.description AS description_2, c0_.price_family AS price_family_3, c0_.price_family_normalized AS price_family_normalized_4, c0_.flight_possible AS flight_possible_5, c0_.flight_included AS flight_included_6, c0_.base_cost_double AS base_cost_double_7, c0_.code AS code_8, c0_.created_at AS created_at_9, c0_.created_by AS created_by_10, c0_.updated_at AS updated_at_11, c0_.updated_by AS updated_by_12, c0_.currency AS currency_13, c0_.cruise_id AS cruise_id_14, c0_.cabin_category_id AS cabin_category_id_15, c0_.offer_id AS offer_id_16 FROM common_price c0_ INNER JOIN common_cabin_category c1_ ON c0_.cabin_category_id = c1_.id WHERE c0_.cruise_id = ? AND c1_.cabin_sub_type_id = ? AND c0_.base_cost_double > 0 ORDER BY c0_.base_cost_double ASC LIMIT 1
Parameters:
[ 4692 48 ] |
| 160 | 0.10 ms |
SELECT c0_.id AS id_0, c0_.fare_code AS fare_code_1, c0_.description AS description_2, c0_.price_family AS price_family_3, c0_.price_family_normalized AS price_family_normalized_4, c0_.flight_possible AS flight_possible_5, c0_.flight_included AS flight_included_6, c0_.base_cost_double AS base_cost_double_7, c0_.code AS code_8, c0_.created_at AS created_at_9, c0_.created_by AS created_by_10, c0_.updated_at AS updated_at_11, c0_.updated_by AS updated_by_12, c0_.currency AS currency_13, c0_.cruise_id AS cruise_id_14, c0_.cabin_category_id AS cabin_category_id_15, c0_.offer_id AS offer_id_16 FROM common_price c0_ INNER JOIN common_cabin_category c1_ ON c0_.cabin_category_id = c1_.id WHERE c0_.cruise_id = ? AND c1_.cabin_sub_type_id = ? AND c0_.base_cost_double > 0 ORDER BY c0_.base_cost_double ASC LIMIT 1
Parameters:
[ 4719 48 ] |
| 161 | 0.10 ms |
SELECT c0_.id AS id_0, c0_.fare_code AS fare_code_1, c0_.description AS description_2, c0_.price_family AS price_family_3, c0_.price_family_normalized AS price_family_normalized_4, c0_.flight_possible AS flight_possible_5, c0_.flight_included AS flight_included_6, c0_.base_cost_double AS base_cost_double_7, c0_.code AS code_8, c0_.created_at AS created_at_9, c0_.created_by AS created_by_10, c0_.updated_at AS updated_at_11, c0_.updated_by AS updated_by_12, c0_.currency AS currency_13, c0_.cruise_id AS cruise_id_14, c0_.cabin_category_id AS cabin_category_id_15, c0_.offer_id AS offer_id_16 FROM common_price c0_ INNER JOIN common_cabin_category c1_ ON c0_.cabin_category_id = c1_.id WHERE c0_.cruise_id = ? AND c1_.cabin_sub_type_id = ? AND c0_.base_cost_double > 0 ORDER BY c0_.base_cost_double ASC LIMIT 1
Parameters:
[ 4728 48 ] |
| 162 | 0.11 ms |
SELECT c0_.id AS id_0, c0_.fare_code AS fare_code_1, c0_.description AS description_2, c0_.price_family AS price_family_3, c0_.price_family_normalized AS price_family_normalized_4, c0_.flight_possible AS flight_possible_5, c0_.flight_included AS flight_included_6, c0_.base_cost_double AS base_cost_double_7, c0_.code AS code_8, c0_.created_at AS created_at_9, c0_.created_by AS created_by_10, c0_.updated_at AS updated_at_11, c0_.updated_by AS updated_by_12, c0_.currency AS currency_13, c0_.cruise_id AS cruise_id_14, c0_.cabin_category_id AS cabin_category_id_15, c0_.offer_id AS offer_id_16 FROM common_price c0_ INNER JOIN common_cabin_category c1_ ON c0_.cabin_category_id = c1_.id WHERE c0_.cruise_id = ? AND c1_.cabin_sub_type_id = ? AND c0_.base_cost_double > 0 ORDER BY c0_.base_cost_double ASC LIMIT 1
Parameters:
[ 4732 48 ] |
| 163 | 0.07 ms |
SELECT c0_.id AS id_0, c0_.fare_code AS fare_code_1, c0_.description AS description_2, c0_.price_family AS price_family_3, c0_.price_family_normalized AS price_family_normalized_4, c0_.flight_possible AS flight_possible_5, c0_.flight_included AS flight_included_6, c0_.base_cost_double AS base_cost_double_7, c0_.code AS code_8, c0_.created_at AS created_at_9, c0_.created_by AS created_by_10, c0_.updated_at AS updated_at_11, c0_.updated_by AS updated_by_12, c0_.currency AS currency_13, c0_.cruise_id AS cruise_id_14, c0_.cabin_category_id AS cabin_category_id_15, c0_.offer_id AS offer_id_16 FROM common_price c0_ INNER JOIN common_cabin_category c1_ ON c0_.cabin_category_id = c1_.id WHERE c0_.cruise_id = ? AND c1_.cabin_sub_type_id = ? AND c0_.base_cost_double > 0 ORDER BY c0_.base_cost_double ASC LIMIT 1
Parameters:
[ 4753 48 ] |
| 164 | 0.12 ms |
SELECT c0_.id AS id_0, c0_.fare_code AS fare_code_1, c0_.description AS description_2, c0_.price_family AS price_family_3, c0_.price_family_normalized AS price_family_normalized_4, c0_.flight_possible AS flight_possible_5, c0_.flight_included AS flight_included_6, c0_.base_cost_double AS base_cost_double_7, c0_.code AS code_8, c0_.created_at AS created_at_9, c0_.created_by AS created_by_10, c0_.updated_at AS updated_at_11, c0_.updated_by AS updated_by_12, c0_.currency AS currency_13, c0_.cruise_id AS cruise_id_14, c0_.cabin_category_id AS cabin_category_id_15, c0_.offer_id AS offer_id_16 FROM common_price c0_ INNER JOIN common_cabin_category c1_ ON c0_.cabin_category_id = c1_.id WHERE c0_.cruise_id = ? AND c1_.cabin_sub_type_id = ? AND c0_.base_cost_double > 0 ORDER BY c0_.base_cost_double ASC LIMIT 1
Parameters:
[ 4761 48 ] |
| 165 | 0.11 ms |
SELECT c0_.id AS id_0, c0_.fare_code AS fare_code_1, c0_.description AS description_2, c0_.price_family AS price_family_3, c0_.price_family_normalized AS price_family_normalized_4, c0_.flight_possible AS flight_possible_5, c0_.flight_included AS flight_included_6, c0_.base_cost_double AS base_cost_double_7, c0_.code AS code_8, c0_.created_at AS created_at_9, c0_.created_by AS created_by_10, c0_.updated_at AS updated_at_11, c0_.updated_by AS updated_by_12, c0_.currency AS currency_13, c0_.cruise_id AS cruise_id_14, c0_.cabin_category_id AS cabin_category_id_15, c0_.offer_id AS offer_id_16 FROM common_price c0_ INNER JOIN common_cabin_category c1_ ON c0_.cabin_category_id = c1_.id WHERE c0_.cruise_id = ? AND c1_.cabin_sub_type_id = ? AND c0_.base_cost_double > 0 ORDER BY c0_.base_cost_double ASC LIMIT 1
Parameters:
[ 4770 48 ] |
| 166 | 0.11 ms |
SELECT c0_.id AS id_0, c0_.fare_code AS fare_code_1, c0_.description AS description_2, c0_.price_family AS price_family_3, c0_.price_family_normalized AS price_family_normalized_4, c0_.flight_possible AS flight_possible_5, c0_.flight_included AS flight_included_6, c0_.base_cost_double AS base_cost_double_7, c0_.code AS code_8, c0_.created_at AS created_at_9, c0_.created_by AS created_by_10, c0_.updated_at AS updated_at_11, c0_.updated_by AS updated_by_12, c0_.currency AS currency_13, c0_.cruise_id AS cruise_id_14, c0_.cabin_category_id AS cabin_category_id_15, c0_.offer_id AS offer_id_16 FROM common_price c0_ INNER JOIN common_cabin_category c1_ ON c0_.cabin_category_id = c1_.id WHERE c0_.cruise_id = ? AND c1_.cabin_sub_type_id = ? AND c0_.base_cost_double > 0 ORDER BY c0_.base_cost_double ASC LIMIT 1
Parameters:
[ 4792 48 ] |
| 167 | 0.11 ms |
SELECT c0_.id AS id_0, c0_.fare_code AS fare_code_1, c0_.description AS description_2, c0_.price_family AS price_family_3, c0_.price_family_normalized AS price_family_normalized_4, c0_.flight_possible AS flight_possible_5, c0_.flight_included AS flight_included_6, c0_.base_cost_double AS base_cost_double_7, c0_.code AS code_8, c0_.created_at AS created_at_9, c0_.created_by AS created_by_10, c0_.updated_at AS updated_at_11, c0_.updated_by AS updated_by_12, c0_.currency AS currency_13, c0_.cruise_id AS cruise_id_14, c0_.cabin_category_id AS cabin_category_id_15, c0_.offer_id AS offer_id_16 FROM common_price c0_ INNER JOIN common_cabin_category c1_ ON c0_.cabin_category_id = c1_.id WHERE c0_.cruise_id = ? AND c1_.cabin_sub_type_id = ? AND c0_.base_cost_double > 0 ORDER BY c0_.base_cost_double ASC LIMIT 1
Parameters:
[ 4806 48 ] |
| 168 | 0.12 ms |
SELECT c0_.id AS id_0, c0_.fare_code AS fare_code_1, c0_.description AS description_2, c0_.price_family AS price_family_3, c0_.price_family_normalized AS price_family_normalized_4, c0_.flight_possible AS flight_possible_5, c0_.flight_included AS flight_included_6, c0_.base_cost_double AS base_cost_double_7, c0_.code AS code_8, c0_.created_at AS created_at_9, c0_.created_by AS created_by_10, c0_.updated_at AS updated_at_11, c0_.updated_by AS updated_by_12, c0_.currency AS currency_13, c0_.cruise_id AS cruise_id_14, c0_.cabin_category_id AS cabin_category_id_15, c0_.offer_id AS offer_id_16 FROM common_price c0_ INNER JOIN common_cabin_category c1_ ON c0_.cabin_category_id = c1_.id WHERE c0_.cruise_id = ? AND c1_.cabin_sub_type_id = ? AND c0_.base_cost_double > 0 ORDER BY c0_.base_cost_double ASC LIMIT 1
Parameters:
[ 4819 48 ] |
| 169 | 0.12 ms |
SELECT c0_.id AS id_0, c0_.fare_code AS fare_code_1, c0_.description AS description_2, c0_.price_family AS price_family_3, c0_.price_family_normalized AS price_family_normalized_4, c0_.flight_possible AS flight_possible_5, c0_.flight_included AS flight_included_6, c0_.base_cost_double AS base_cost_double_7, c0_.code AS code_8, c0_.created_at AS created_at_9, c0_.created_by AS created_by_10, c0_.updated_at AS updated_at_11, c0_.updated_by AS updated_by_12, c0_.currency AS currency_13, c0_.cruise_id AS cruise_id_14, c0_.cabin_category_id AS cabin_category_id_15, c0_.offer_id AS offer_id_16 FROM common_price c0_ INNER JOIN common_cabin_category c1_ ON c0_.cabin_category_id = c1_.id WHERE c0_.cruise_id = ? AND c1_.cabin_sub_type_id = ? AND c0_.base_cost_double > 0 ORDER BY c0_.base_cost_double ASC LIMIT 1
Parameters:
[ 4827 48 ] |
| 170 | 0.12 ms |
SELECT c0_.id AS id_0, c0_.fare_code AS fare_code_1, c0_.description AS description_2, c0_.price_family AS price_family_3, c0_.price_family_normalized AS price_family_normalized_4, c0_.flight_possible AS flight_possible_5, c0_.flight_included AS flight_included_6, c0_.base_cost_double AS base_cost_double_7, c0_.code AS code_8, c0_.created_at AS created_at_9, c0_.created_by AS created_by_10, c0_.updated_at AS updated_at_11, c0_.updated_by AS updated_by_12, c0_.currency AS currency_13, c0_.cruise_id AS cruise_id_14, c0_.cabin_category_id AS cabin_category_id_15, c0_.offer_id AS offer_id_16 FROM common_price c0_ INNER JOIN common_cabin_category c1_ ON c0_.cabin_category_id = c1_.id WHERE c0_.cruise_id = ? AND c1_.cabin_sub_type_id = ? AND c0_.base_cost_double > 0 ORDER BY c0_.base_cost_double ASC LIMIT 1
Parameters:
[ 4832 48 ] |
| 171 | 0.12 ms |
SELECT c0_.id AS id_0, c0_.fare_code AS fare_code_1, c0_.description AS description_2, c0_.price_family AS price_family_3, c0_.price_family_normalized AS price_family_normalized_4, c0_.flight_possible AS flight_possible_5, c0_.flight_included AS flight_included_6, c0_.base_cost_double AS base_cost_double_7, c0_.code AS code_8, c0_.created_at AS created_at_9, c0_.created_by AS created_by_10, c0_.updated_at AS updated_at_11, c0_.updated_by AS updated_by_12, c0_.currency AS currency_13, c0_.cruise_id AS cruise_id_14, c0_.cabin_category_id AS cabin_category_id_15, c0_.offer_id AS offer_id_16 FROM common_price c0_ INNER JOIN common_cabin_category c1_ ON c0_.cabin_category_id = c1_.id WHERE c0_.cruise_id = ? AND c1_.cabin_sub_type_id = ? AND c0_.base_cost_double > 0 ORDER BY c0_.base_cost_double ASC LIMIT 1
Parameters:
[ 4847 48 ] |
| 172 | 0.11 ms |
SELECT c0_.id AS id_0, c0_.fare_code AS fare_code_1, c0_.description AS description_2, c0_.price_family AS price_family_3, c0_.price_family_normalized AS price_family_normalized_4, c0_.flight_possible AS flight_possible_5, c0_.flight_included AS flight_included_6, c0_.base_cost_double AS base_cost_double_7, c0_.code AS code_8, c0_.created_at AS created_at_9, c0_.created_by AS created_by_10, c0_.updated_at AS updated_at_11, c0_.updated_by AS updated_by_12, c0_.currency AS currency_13, c0_.cruise_id AS cruise_id_14, c0_.cabin_category_id AS cabin_category_id_15, c0_.offer_id AS offer_id_16 FROM common_price c0_ INNER JOIN common_cabin_category c1_ ON c0_.cabin_category_id = c1_.id WHERE c0_.cruise_id = ? AND c1_.cabin_sub_type_id = ? AND c0_.base_cost_double > 0 ORDER BY c0_.base_cost_double ASC LIMIT 1
Parameters:
[ 4855 48 ] |
| 173 | 0.11 ms |
SELECT c0_.id AS id_0, c0_.fare_code AS fare_code_1, c0_.description AS description_2, c0_.price_family AS price_family_3, c0_.price_family_normalized AS price_family_normalized_4, c0_.flight_possible AS flight_possible_5, c0_.flight_included AS flight_included_6, c0_.base_cost_double AS base_cost_double_7, c0_.code AS code_8, c0_.created_at AS created_at_9, c0_.created_by AS created_by_10, c0_.updated_at AS updated_at_11, c0_.updated_by AS updated_by_12, c0_.currency AS currency_13, c0_.cruise_id AS cruise_id_14, c0_.cabin_category_id AS cabin_category_id_15, c0_.offer_id AS offer_id_16 FROM common_price c0_ INNER JOIN common_cabin_category c1_ ON c0_.cabin_category_id = c1_.id WHERE c0_.cruise_id = ? AND c1_.cabin_sub_type_id = ? AND c0_.base_cost_double > 0 ORDER BY c0_.base_cost_double ASC LIMIT 1
Parameters:
[ 4863 48 ] |
| 174 | 0.07 ms |
SELECT c0_.id AS id_0, c0_.fare_code AS fare_code_1, c0_.description AS description_2, c0_.price_family AS price_family_3, c0_.price_family_normalized AS price_family_normalized_4, c0_.flight_possible AS flight_possible_5, c0_.flight_included AS flight_included_6, c0_.base_cost_double AS base_cost_double_7, c0_.code AS code_8, c0_.created_at AS created_at_9, c0_.created_by AS created_by_10, c0_.updated_at AS updated_at_11, c0_.updated_by AS updated_by_12, c0_.currency AS currency_13, c0_.cruise_id AS cruise_id_14, c0_.cabin_category_id AS cabin_category_id_15, c0_.offer_id AS offer_id_16 FROM common_price c0_ INNER JOIN common_cabin_category c1_ ON c0_.cabin_category_id = c1_.id WHERE c0_.cruise_id = ? AND c1_.cabin_sub_type_id = ? AND c0_.base_cost_double > 0 ORDER BY c0_.base_cost_double ASC LIMIT 1
Parameters:
[ 4684 48 ] |
| 175 | 0.06 ms |
SELECT c0_.id AS id_0, c0_.fare_code AS fare_code_1, c0_.description AS description_2, c0_.price_family AS price_family_3, c0_.price_family_normalized AS price_family_normalized_4, c0_.flight_possible AS flight_possible_5, c0_.flight_included AS flight_included_6, c0_.base_cost_double AS base_cost_double_7, c0_.code AS code_8, c0_.created_at AS created_at_9, c0_.created_by AS created_by_10, c0_.updated_at AS updated_at_11, c0_.updated_by AS updated_by_12, c0_.currency AS currency_13, c0_.cruise_id AS cruise_id_14, c0_.cabin_category_id AS cabin_category_id_15, c0_.offer_id AS offer_id_16 FROM common_price c0_ INNER JOIN common_cabin_category c1_ ON c0_.cabin_category_id = c1_.id WHERE c0_.cruise_id = ? AND c1_.cabin_sub_type_id = ? AND c0_.base_cost_double > 0 ORDER BY c0_.base_cost_double ASC LIMIT 1
Parameters:
[ 4692 48 ] |
| 176 | 0.10 ms |
SELECT c0_.id AS id_0, c0_.fare_code AS fare_code_1, c0_.description AS description_2, c0_.price_family AS price_family_3, c0_.price_family_normalized AS price_family_normalized_4, c0_.flight_possible AS flight_possible_5, c0_.flight_included AS flight_included_6, c0_.base_cost_double AS base_cost_double_7, c0_.code AS code_8, c0_.created_at AS created_at_9, c0_.created_by AS created_by_10, c0_.updated_at AS updated_at_11, c0_.updated_by AS updated_by_12, c0_.currency AS currency_13, c0_.cruise_id AS cruise_id_14, c0_.cabin_category_id AS cabin_category_id_15, c0_.offer_id AS offer_id_16 FROM common_price c0_ INNER JOIN common_cabin_category c1_ ON c0_.cabin_category_id = c1_.id WHERE c0_.cruise_id = ? AND c1_.cabin_sub_type_id = ? AND c0_.base_cost_double > 0 ORDER BY c0_.base_cost_double ASC LIMIT 1
Parameters:
[ 4719 48 ] |
| 177 | 0.10 ms |
SELECT c0_.id AS id_0, c0_.fare_code AS fare_code_1, c0_.description AS description_2, c0_.price_family AS price_family_3, c0_.price_family_normalized AS price_family_normalized_4, c0_.flight_possible AS flight_possible_5, c0_.flight_included AS flight_included_6, c0_.base_cost_double AS base_cost_double_7, c0_.code AS code_8, c0_.created_at AS created_at_9, c0_.created_by AS created_by_10, c0_.updated_at AS updated_at_11, c0_.updated_by AS updated_by_12, c0_.currency AS currency_13, c0_.cruise_id AS cruise_id_14, c0_.cabin_category_id AS cabin_category_id_15, c0_.offer_id AS offer_id_16 FROM common_price c0_ INNER JOIN common_cabin_category c1_ ON c0_.cabin_category_id = c1_.id WHERE c0_.cruise_id = ? AND c1_.cabin_sub_type_id = ? AND c0_.base_cost_double > 0 ORDER BY c0_.base_cost_double ASC LIMIT 1
Parameters:
[ 4728 48 ] |
| 178 | 0.11 ms |
SELECT c0_.id AS id_0, c0_.fare_code AS fare_code_1, c0_.description AS description_2, c0_.price_family AS price_family_3, c0_.price_family_normalized AS price_family_normalized_4, c0_.flight_possible AS flight_possible_5, c0_.flight_included AS flight_included_6, c0_.base_cost_double AS base_cost_double_7, c0_.code AS code_8, c0_.created_at AS created_at_9, c0_.created_by AS created_by_10, c0_.updated_at AS updated_at_11, c0_.updated_by AS updated_by_12, c0_.currency AS currency_13, c0_.cruise_id AS cruise_id_14, c0_.cabin_category_id AS cabin_category_id_15, c0_.offer_id AS offer_id_16 FROM common_price c0_ INNER JOIN common_cabin_category c1_ ON c0_.cabin_category_id = c1_.id WHERE c0_.cruise_id = ? AND c1_.cabin_sub_type_id = ? AND c0_.base_cost_double > 0 ORDER BY c0_.base_cost_double ASC LIMIT 1
Parameters:
[ 4732 48 ] |
| 179 | 0.08 ms |
SELECT c0_.id AS id_0, c0_.fare_code AS fare_code_1, c0_.description AS description_2, c0_.price_family AS price_family_3, c0_.price_family_normalized AS price_family_normalized_4, c0_.flight_possible AS flight_possible_5, c0_.flight_included AS flight_included_6, c0_.base_cost_double AS base_cost_double_7, c0_.code AS code_8, c0_.created_at AS created_at_9, c0_.created_by AS created_by_10, c0_.updated_at AS updated_at_11, c0_.updated_by AS updated_by_12, c0_.currency AS currency_13, c0_.cruise_id AS cruise_id_14, c0_.cabin_category_id AS cabin_category_id_15, c0_.offer_id AS offer_id_16 FROM common_price c0_ INNER JOIN common_cabin_category c1_ ON c0_.cabin_category_id = c1_.id WHERE c0_.cruise_id = ? AND c1_.cabin_sub_type_id = ? AND c0_.base_cost_double > 0 ORDER BY c0_.base_cost_double ASC LIMIT 1
Parameters:
[ 4753 48 ] |
| 180 | 0.11 ms |
SELECT c0_.id AS id_0, c0_.fare_code AS fare_code_1, c0_.description AS description_2, c0_.price_family AS price_family_3, c0_.price_family_normalized AS price_family_normalized_4, c0_.flight_possible AS flight_possible_5, c0_.flight_included AS flight_included_6, c0_.base_cost_double AS base_cost_double_7, c0_.code AS code_8, c0_.created_at AS created_at_9, c0_.created_by AS created_by_10, c0_.updated_at AS updated_at_11, c0_.updated_by AS updated_by_12, c0_.currency AS currency_13, c0_.cruise_id AS cruise_id_14, c0_.cabin_category_id AS cabin_category_id_15, c0_.offer_id AS offer_id_16 FROM common_price c0_ INNER JOIN common_cabin_category c1_ ON c0_.cabin_category_id = c1_.id WHERE c0_.cruise_id = ? AND c1_.cabin_sub_type_id = ? AND c0_.base_cost_double > 0 ORDER BY c0_.base_cost_double ASC LIMIT 1
Parameters:
[ 4761 48 ] |
| 181 | 0.11 ms |
SELECT c0_.id AS id_0, c0_.fare_code AS fare_code_1, c0_.description AS description_2, c0_.price_family AS price_family_3, c0_.price_family_normalized AS price_family_normalized_4, c0_.flight_possible AS flight_possible_5, c0_.flight_included AS flight_included_6, c0_.base_cost_double AS base_cost_double_7, c0_.code AS code_8, c0_.created_at AS created_at_9, c0_.created_by AS created_by_10, c0_.updated_at AS updated_at_11, c0_.updated_by AS updated_by_12, c0_.currency AS currency_13, c0_.cruise_id AS cruise_id_14, c0_.cabin_category_id AS cabin_category_id_15, c0_.offer_id AS offer_id_16 FROM common_price c0_ INNER JOIN common_cabin_category c1_ ON c0_.cabin_category_id = c1_.id WHERE c0_.cruise_id = ? AND c1_.cabin_sub_type_id = ? AND c0_.base_cost_double > 0 ORDER BY c0_.base_cost_double ASC LIMIT 1
Parameters:
[ 4770 48 ] |
| 182 | 0.11 ms |
SELECT c0_.id AS id_0, c0_.fare_code AS fare_code_1, c0_.description AS description_2, c0_.price_family AS price_family_3, c0_.price_family_normalized AS price_family_normalized_4, c0_.flight_possible AS flight_possible_5, c0_.flight_included AS flight_included_6, c0_.base_cost_double AS base_cost_double_7, c0_.code AS code_8, c0_.created_at AS created_at_9, c0_.created_by AS created_by_10, c0_.updated_at AS updated_at_11, c0_.updated_by AS updated_by_12, c0_.currency AS currency_13, c0_.cruise_id AS cruise_id_14, c0_.cabin_category_id AS cabin_category_id_15, c0_.offer_id AS offer_id_16 FROM common_price c0_ INNER JOIN common_cabin_category c1_ ON c0_.cabin_category_id = c1_.id WHERE c0_.cruise_id = ? AND c1_.cabin_sub_type_id = ? AND c0_.base_cost_double > 0 ORDER BY c0_.base_cost_double ASC LIMIT 1
Parameters:
[ 4792 48 ] |
| 183 | 0.11 ms |
SELECT c0_.id AS id_0, c0_.fare_code AS fare_code_1, c0_.description AS description_2, c0_.price_family AS price_family_3, c0_.price_family_normalized AS price_family_normalized_4, c0_.flight_possible AS flight_possible_5, c0_.flight_included AS flight_included_6, c0_.base_cost_double AS base_cost_double_7, c0_.code AS code_8, c0_.created_at AS created_at_9, c0_.created_by AS created_by_10, c0_.updated_at AS updated_at_11, c0_.updated_by AS updated_by_12, c0_.currency AS currency_13, c0_.cruise_id AS cruise_id_14, c0_.cabin_category_id AS cabin_category_id_15, c0_.offer_id AS offer_id_16 FROM common_price c0_ INNER JOIN common_cabin_category c1_ ON c0_.cabin_category_id = c1_.id WHERE c0_.cruise_id = ? AND c1_.cabin_sub_type_id = ? AND c0_.base_cost_double > 0 ORDER BY c0_.base_cost_double ASC LIMIT 1
Parameters:
[ 4806 48 ] |
| 184 | 0.12 ms |
SELECT c0_.id AS id_0, c0_.fare_code AS fare_code_1, c0_.description AS description_2, c0_.price_family AS price_family_3, c0_.price_family_normalized AS price_family_normalized_4, c0_.flight_possible AS flight_possible_5, c0_.flight_included AS flight_included_6, c0_.base_cost_double AS base_cost_double_7, c0_.code AS code_8, c0_.created_at AS created_at_9, c0_.created_by AS created_by_10, c0_.updated_at AS updated_at_11, c0_.updated_by AS updated_by_12, c0_.currency AS currency_13, c0_.cruise_id AS cruise_id_14, c0_.cabin_category_id AS cabin_category_id_15, c0_.offer_id AS offer_id_16 FROM common_price c0_ INNER JOIN common_cabin_category c1_ ON c0_.cabin_category_id = c1_.id WHERE c0_.cruise_id = ? AND c1_.cabin_sub_type_id = ? AND c0_.base_cost_double > 0 ORDER BY c0_.base_cost_double ASC LIMIT 1
Parameters:
[ 4819 48 ] |
| 185 | 0.11 ms |
SELECT c0_.id AS id_0, c0_.fare_code AS fare_code_1, c0_.description AS description_2, c0_.price_family AS price_family_3, c0_.price_family_normalized AS price_family_normalized_4, c0_.flight_possible AS flight_possible_5, c0_.flight_included AS flight_included_6, c0_.base_cost_double AS base_cost_double_7, c0_.code AS code_8, c0_.created_at AS created_at_9, c0_.created_by AS created_by_10, c0_.updated_at AS updated_at_11, c0_.updated_by AS updated_by_12, c0_.currency AS currency_13, c0_.cruise_id AS cruise_id_14, c0_.cabin_category_id AS cabin_category_id_15, c0_.offer_id AS offer_id_16 FROM common_price c0_ INNER JOIN common_cabin_category c1_ ON c0_.cabin_category_id = c1_.id WHERE c0_.cruise_id = ? AND c1_.cabin_sub_type_id = ? AND c0_.base_cost_double > 0 ORDER BY c0_.base_cost_double ASC LIMIT 1
Parameters:
[ 4827 48 ] |
| 186 | 0.11 ms |
SELECT c0_.id AS id_0, c0_.fare_code AS fare_code_1, c0_.description AS description_2, c0_.price_family AS price_family_3, c0_.price_family_normalized AS price_family_normalized_4, c0_.flight_possible AS flight_possible_5, c0_.flight_included AS flight_included_6, c0_.base_cost_double AS base_cost_double_7, c0_.code AS code_8, c0_.created_at AS created_at_9, c0_.created_by AS created_by_10, c0_.updated_at AS updated_at_11, c0_.updated_by AS updated_by_12, c0_.currency AS currency_13, c0_.cruise_id AS cruise_id_14, c0_.cabin_category_id AS cabin_category_id_15, c0_.offer_id AS offer_id_16 FROM common_price c0_ INNER JOIN common_cabin_category c1_ ON c0_.cabin_category_id = c1_.id WHERE c0_.cruise_id = ? AND c1_.cabin_sub_type_id = ? AND c0_.base_cost_double > 0 ORDER BY c0_.base_cost_double ASC LIMIT 1
Parameters:
[ 4832 48 ] |
| 187 | 0.11 ms |
SELECT c0_.id AS id_0, c0_.fare_code AS fare_code_1, c0_.description AS description_2, c0_.price_family AS price_family_3, c0_.price_family_normalized AS price_family_normalized_4, c0_.flight_possible AS flight_possible_5, c0_.flight_included AS flight_included_6, c0_.base_cost_double AS base_cost_double_7, c0_.code AS code_8, c0_.created_at AS created_at_9, c0_.created_by AS created_by_10, c0_.updated_at AS updated_at_11, c0_.updated_by AS updated_by_12, c0_.currency AS currency_13, c0_.cruise_id AS cruise_id_14, c0_.cabin_category_id AS cabin_category_id_15, c0_.offer_id AS offer_id_16 FROM common_price c0_ INNER JOIN common_cabin_category c1_ ON c0_.cabin_category_id = c1_.id WHERE c0_.cruise_id = ? AND c1_.cabin_sub_type_id = ? AND c0_.base_cost_double > 0 ORDER BY c0_.base_cost_double ASC LIMIT 1
Parameters:
[ 4847 48 ] |
| 188 | 0.12 ms |
SELECT c0_.id AS id_0, c0_.fare_code AS fare_code_1, c0_.description AS description_2, c0_.price_family AS price_family_3, c0_.price_family_normalized AS price_family_normalized_4, c0_.flight_possible AS flight_possible_5, c0_.flight_included AS flight_included_6, c0_.base_cost_double AS base_cost_double_7, c0_.code AS code_8, c0_.created_at AS created_at_9, c0_.created_by AS created_by_10, c0_.updated_at AS updated_at_11, c0_.updated_by AS updated_by_12, c0_.currency AS currency_13, c0_.cruise_id AS cruise_id_14, c0_.cabin_category_id AS cabin_category_id_15, c0_.offer_id AS offer_id_16 FROM common_price c0_ INNER JOIN common_cabin_category c1_ ON c0_.cabin_category_id = c1_.id WHERE c0_.cruise_id = ? AND c1_.cabin_sub_type_id = ? AND c0_.base_cost_double > 0 ORDER BY c0_.base_cost_double ASC LIMIT 1
Parameters:
[ 4855 48 ] |
| 189 | 0.12 ms |
SELECT c0_.id AS id_0, c0_.fare_code AS fare_code_1, c0_.description AS description_2, c0_.price_family AS price_family_3, c0_.price_family_normalized AS price_family_normalized_4, c0_.flight_possible AS flight_possible_5, c0_.flight_included AS flight_included_6, c0_.base_cost_double AS base_cost_double_7, c0_.code AS code_8, c0_.created_at AS created_at_9, c0_.created_by AS created_by_10, c0_.updated_at AS updated_at_11, c0_.updated_by AS updated_by_12, c0_.currency AS currency_13, c0_.cruise_id AS cruise_id_14, c0_.cabin_category_id AS cabin_category_id_15, c0_.offer_id AS offer_id_16 FROM common_price c0_ INNER JOIN common_cabin_category c1_ ON c0_.cabin_category_id = c1_.id WHERE c0_.cruise_id = ? AND c1_.cabin_sub_type_id = ? AND c0_.base_cost_double > 0 ORDER BY c0_.base_cost_double ASC LIMIT 1
Parameters:
[ 4863 48 ] |
| 190 | 0.10 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.