Query Metrics
31
Database Queries
12
Different statements
3.83 ms
Query time
0
Invalid entities
Queries
| #▲ | Time | Info |
|---|---|---|
| 1 | 0.22 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:
[
27907
]
|
| 2 | 0.24 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:
[ 3725 "2026-10-11 02:29:46" ] |
| 3 | 0.15 ms |
SELECT MIN(c0_.base_cost_double) AS sclr_0 FROM common_price c0_ WHERE c0_.cruise_id IN (?, ?)
Parameters:
[ 28053 27907 ] |
| 4 | 0.20 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:
[ 3725 "2026-10-11 02:29:46" ] |
| 5 | 0.44 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:
[
445
]
|
| 6 | 0.21 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:
[
28053
]
|
| 7 | 0.18 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:
[
27907
]
|
| 8 | 0.12 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:
[
27907
]
|
| 9 | 0.12 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
]
|
| 10 | 0.09 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
]
|
| 11 | 0.09 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
]
|
| 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:
[
27907
]
|
| 13 | 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:
[ 28053 11 ] |
| 14 | 0.13 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:
[ 27907 11 ] |
| 15 | 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:
[ 28053 11 ] |
| 16 | 0.10 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:
[
445
]
|
| 17 | 0.08 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:
[
16
]
|
| 18 | 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:
[ 27907 11 ] |
| 19 | 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:
[ 28053 16 ] |
| 20 | 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:
[ 27907 16 ] |
| 21 | 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:
[ 28053 16 ] |
| 22 | 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:
[ 27907 16 ] |
| 23 | 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:
[ 28053 10 ] |
| 24 | 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:
[ 27907 10 ] |
| 25 | 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:
[ 28053 10 ] |
| 26 | 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:
[ 27907 10 ] |
| 27 | 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:
[ 28053 17 ] |
| 28 | 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:
[ 27907 17 ] |
| 29 | 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:
[ 28053 17 ] |
| 30 | 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:
[ 27907 17 ] |
| 31 | 0.11 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.