GET https://wwwdev2.satur.sk/poznavacie-zajazdy/katalog-zajazdov?stranka=27

Query Metrics

27 Database Queries
6 Different statements
18.08 ms Query time
2 Invalid entities

Queries

Group similar statements

# Time Info
1 0.66 ms
SELECT t0.title AS title_1, t0.alias AS alias_2, t0.index_final AS index_final_3, t0.index_tmp AS index_tmp_4, t0.description AS description_5, t0.generate_start AS generate_start_6, t0.generate_end AS generate_end_7, t0.id AS id_8, t0.deleted_at AS deleted_at_9, t0.modified_at AS modified_at_10, t0.created_at AS created_at_11 FROM elastic_search_index t0 WHERE t0.id = ? AND ((t0.deleted_at IS NULL))
Parameters:
[
  3
]
2 1.10 ms
SELECT t0.start_date AS start_date_1, t0.end_date AS end_date_2, t0.price_original AS price_original_3, t0.price_final AS price_final_4, t0.term_id AS term_id_5, t0.nights AS nights_6, t0.days AS days_7, t0.is_lm AS is_lm_8, t0.is_fm AS is_fm_9, t0.is_promo AS is_promo_10, t0.lowest_nigth_original_price AS lowest_nigth_original_price_11, t0.lm_price AS lm_price_12, t0.lm_discount AS lm_discount_13, t0.departure_there_date AS departure_there_date_14, t0.arrival_there_date AS arrival_there_date_15, t0.departure_back_date AS departure_back_date_16, t0.arrival_back_date AS arrival_back_date_17, t0.transfers_count AS transfers_count_18, t0.loyalty_prices AS loyalty_prices_19, t0.unique_key AS unique_key_20, t0.updated AS updated_21, t0.is_child_for_euro AS is_child_for_euro_22, t0.flight_there_tickets_count AS flight_there_tickets_count_23, t0.flight_there_number AS flight_there_number_24, t0.flight_back_tickets_count AS flight_back_tickets_count_25, t0.flight_back_number AS flight_back_number_26, t0.is_magic_lm AS is_magic_lm_27, t0.id AS id_28, t0.deleted_at AS deleted_at_29, t0.modified_at AS modified_at_30, t0.created_at AS created_at_31, t0.tour_season_id AS tour_season_id_32, t0.food_id AS food_id_33, t0.transport_id AS transport_id_34, t0.departure_there_airport_id AS departure_there_airport_id_35, t0.arrival_there_airport_id AS arrival_there_airport_id_36, t0.departure_back_airport_id AS departure_back_airport_id_37, t0.arrival_back_airport_id AS arrival_back_airport_id_38, t0.package_id AS package_id_39, t0.source_room_id AS source_room_id_40 FROM tour_term t0 WHERE t0.id = ? AND ((t0.deleted_at IS NULL))
Parameters:
[
  "1036340919"
]
3 0.47 ms
SELECT t0.id AS id_1, t0.deleted_at AS deleted_at_2, t0.modified_at AS modified_at_3, t0.created_at AS created_at_4, t0.staff_tour_id AS staff_tour_id_5, t0.term_id AS term_id_6 FROM staff_tour_term t0 WHERE t0.term_id = ? AND ((t0.deleted_at IS NULL))
Parameters:
[
  1036340919
]
4 0.98 ms
SELECT t0.start_date AS start_date_1, t0.end_date AS end_date_2, t0.price_original AS price_original_3, t0.price_final AS price_final_4, t0.term_id AS term_id_5, t0.nights AS nights_6, t0.days AS days_7, t0.is_lm AS is_lm_8, t0.is_fm AS is_fm_9, t0.is_promo AS is_promo_10, t0.lowest_nigth_original_price AS lowest_nigth_original_price_11, t0.lm_price AS lm_price_12, t0.lm_discount AS lm_discount_13, t0.departure_there_date AS departure_there_date_14, t0.arrival_there_date AS arrival_there_date_15, t0.departure_back_date AS departure_back_date_16, t0.arrival_back_date AS arrival_back_date_17, t0.transfers_count AS transfers_count_18, t0.loyalty_prices AS loyalty_prices_19, t0.unique_key AS unique_key_20, t0.updated AS updated_21, t0.is_child_for_euro AS is_child_for_euro_22, t0.flight_there_tickets_count AS flight_there_tickets_count_23, t0.flight_there_number AS flight_there_number_24, t0.flight_back_tickets_count AS flight_back_tickets_count_25, t0.flight_back_number AS flight_back_number_26, t0.is_magic_lm AS is_magic_lm_27, t0.id AS id_28, t0.deleted_at AS deleted_at_29, t0.modified_at AS modified_at_30, t0.created_at AS created_at_31, t0.tour_season_id AS tour_season_id_32, t0.food_id AS food_id_33, t0.transport_id AS transport_id_34, t0.departure_there_airport_id AS departure_there_airport_id_35, t0.arrival_there_airport_id AS arrival_there_airport_id_36, t0.departure_back_airport_id AS departure_back_airport_id_37, t0.arrival_back_airport_id AS arrival_back_airport_id_38, t0.package_id AS package_id_39, t0.source_room_id AS source_room_id_40 FROM tour_term t0 WHERE t0.id = ? AND ((t0.deleted_at IS NULL))
Parameters:
[
  "1036373075"
]
5 0.41 ms
SELECT t0.id AS id_1, t0.deleted_at AS deleted_at_2, t0.modified_at AS modified_at_3, t0.created_at AS created_at_4, t0.staff_tour_id AS staff_tour_id_5, t0.term_id AS term_id_6 FROM staff_tour_term t0 WHERE t0.term_id = ? AND ((t0.deleted_at IS NULL))
Parameters:
[
  1036373075
]
6 0.98 ms
SELECT t0.start_date AS start_date_1, t0.end_date AS end_date_2, t0.price_original AS price_original_3, t0.price_final AS price_final_4, t0.term_id AS term_id_5, t0.nights AS nights_6, t0.days AS days_7, t0.is_lm AS is_lm_8, t0.is_fm AS is_fm_9, t0.is_promo AS is_promo_10, t0.lowest_nigth_original_price AS lowest_nigth_original_price_11, t0.lm_price AS lm_price_12, t0.lm_discount AS lm_discount_13, t0.departure_there_date AS departure_there_date_14, t0.arrival_there_date AS arrival_there_date_15, t0.departure_back_date AS departure_back_date_16, t0.arrival_back_date AS arrival_back_date_17, t0.transfers_count AS transfers_count_18, t0.loyalty_prices AS loyalty_prices_19, t0.unique_key AS unique_key_20, t0.updated AS updated_21, t0.is_child_for_euro AS is_child_for_euro_22, t0.flight_there_tickets_count AS flight_there_tickets_count_23, t0.flight_there_number AS flight_there_number_24, t0.flight_back_tickets_count AS flight_back_tickets_count_25, t0.flight_back_number AS flight_back_number_26, t0.is_magic_lm AS is_magic_lm_27, t0.id AS id_28, t0.deleted_at AS deleted_at_29, t0.modified_at AS modified_at_30, t0.created_at AS created_at_31, t0.tour_season_id AS tour_season_id_32, t0.food_id AS food_id_33, t0.transport_id AS transport_id_34, t0.departure_there_airport_id AS departure_there_airport_id_35, t0.arrival_there_airport_id AS arrival_there_airport_id_36, t0.departure_back_airport_id AS departure_back_airport_id_37, t0.arrival_back_airport_id AS arrival_back_airport_id_38, t0.package_id AS package_id_39, t0.source_room_id AS source_room_id_40 FROM tour_term t0 WHERE t0.id = ? AND ((t0.deleted_at IS NULL))
Parameters:
[
  "1036333399"
]
7 0.40 ms
SELECT t0.id AS id_1, t0.deleted_at AS deleted_at_2, t0.modified_at AS modified_at_3, t0.created_at AS created_at_4, t0.staff_tour_id AS staff_tour_id_5, t0.term_id AS term_id_6 FROM staff_tour_term t0 WHERE t0.term_id = ? AND ((t0.deleted_at IS NULL))
Parameters:
[
  1036333399
]
8 0.95 ms
SELECT t0.start_date AS start_date_1, t0.end_date AS end_date_2, t0.price_original AS price_original_3, t0.price_final AS price_final_4, t0.term_id AS term_id_5, t0.nights AS nights_6, t0.days AS days_7, t0.is_lm AS is_lm_8, t0.is_fm AS is_fm_9, t0.is_promo AS is_promo_10, t0.lowest_nigth_original_price AS lowest_nigth_original_price_11, t0.lm_price AS lm_price_12, t0.lm_discount AS lm_discount_13, t0.departure_there_date AS departure_there_date_14, t0.arrival_there_date AS arrival_there_date_15, t0.departure_back_date AS departure_back_date_16, t0.arrival_back_date AS arrival_back_date_17, t0.transfers_count AS transfers_count_18, t0.loyalty_prices AS loyalty_prices_19, t0.unique_key AS unique_key_20, t0.updated AS updated_21, t0.is_child_for_euro AS is_child_for_euro_22, t0.flight_there_tickets_count AS flight_there_tickets_count_23, t0.flight_there_number AS flight_there_number_24, t0.flight_back_tickets_count AS flight_back_tickets_count_25, t0.flight_back_number AS flight_back_number_26, t0.is_magic_lm AS is_magic_lm_27, t0.id AS id_28, t0.deleted_at AS deleted_at_29, t0.modified_at AS modified_at_30, t0.created_at AS created_at_31, t0.tour_season_id AS tour_season_id_32, t0.food_id AS food_id_33, t0.transport_id AS transport_id_34, t0.departure_there_airport_id AS departure_there_airport_id_35, t0.arrival_there_airport_id AS arrival_there_airport_id_36, t0.departure_back_airport_id AS departure_back_airport_id_37, t0.arrival_back_airport_id AS arrival_back_airport_id_38, t0.package_id AS package_id_39, t0.source_room_id AS source_room_id_40 FROM tour_term t0 WHERE t0.id = ? AND ((t0.deleted_at IS NULL))
Parameters:
[
  "1037938910"
]
9 0.41 ms
SELECT t0.id AS id_1, t0.deleted_at AS deleted_at_2, t0.modified_at AS modified_at_3, t0.created_at AS created_at_4, t0.staff_tour_id AS staff_tour_id_5, t0.term_id AS term_id_6 FROM staff_tour_term t0 WHERE t0.term_id = ? AND ((t0.deleted_at IS NULL))
Parameters:
[
  1037938910
]
10 0.98 ms
SELECT t0.start_date AS start_date_1, t0.end_date AS end_date_2, t0.price_original AS price_original_3, t0.price_final AS price_final_4, t0.term_id AS term_id_5, t0.nights AS nights_6, t0.days AS days_7, t0.is_lm AS is_lm_8, t0.is_fm AS is_fm_9, t0.is_promo AS is_promo_10, t0.lowest_nigth_original_price AS lowest_nigth_original_price_11, t0.lm_price AS lm_price_12, t0.lm_discount AS lm_discount_13, t0.departure_there_date AS departure_there_date_14, t0.arrival_there_date AS arrival_there_date_15, t0.departure_back_date AS departure_back_date_16, t0.arrival_back_date AS arrival_back_date_17, t0.transfers_count AS transfers_count_18, t0.loyalty_prices AS loyalty_prices_19, t0.unique_key AS unique_key_20, t0.updated AS updated_21, t0.is_child_for_euro AS is_child_for_euro_22, t0.flight_there_tickets_count AS flight_there_tickets_count_23, t0.flight_there_number AS flight_there_number_24, t0.flight_back_tickets_count AS flight_back_tickets_count_25, t0.flight_back_number AS flight_back_number_26, t0.is_magic_lm AS is_magic_lm_27, t0.id AS id_28, t0.deleted_at AS deleted_at_29, t0.modified_at AS modified_at_30, t0.created_at AS created_at_31, t0.tour_season_id AS tour_season_id_32, t0.food_id AS food_id_33, t0.transport_id AS transport_id_34, t0.departure_there_airport_id AS departure_there_airport_id_35, t0.arrival_there_airport_id AS arrival_there_airport_id_36, t0.departure_back_airport_id AS departure_back_airport_id_37, t0.arrival_back_airport_id AS arrival_back_airport_id_38, t0.package_id AS package_id_39, t0.source_room_id AS source_room_id_40 FROM tour_term t0 WHERE t0.id = ? AND ((t0.deleted_at IS NULL))
Parameters:
[
  "1036317022"
]
11 0.41 ms
SELECT t0.id AS id_1, t0.deleted_at AS deleted_at_2, t0.modified_at AS modified_at_3, t0.created_at AS created_at_4, t0.staff_tour_id AS staff_tour_id_5, t0.term_id AS term_id_6 FROM staff_tour_term t0 WHERE t0.term_id = ? AND ((t0.deleted_at IS NULL))
Parameters:
[
  1036317022
]
12 0.96 ms
SELECT t0.start_date AS start_date_1, t0.end_date AS end_date_2, t0.price_original AS price_original_3, t0.price_final AS price_final_4, t0.term_id AS term_id_5, t0.nights AS nights_6, t0.days AS days_7, t0.is_lm AS is_lm_8, t0.is_fm AS is_fm_9, t0.is_promo AS is_promo_10, t0.lowest_nigth_original_price AS lowest_nigth_original_price_11, t0.lm_price AS lm_price_12, t0.lm_discount AS lm_discount_13, t0.departure_there_date AS departure_there_date_14, t0.arrival_there_date AS arrival_there_date_15, t0.departure_back_date AS departure_back_date_16, t0.arrival_back_date AS arrival_back_date_17, t0.transfers_count AS transfers_count_18, t0.loyalty_prices AS loyalty_prices_19, t0.unique_key AS unique_key_20, t0.updated AS updated_21, t0.is_child_for_euro AS is_child_for_euro_22, t0.flight_there_tickets_count AS flight_there_tickets_count_23, t0.flight_there_number AS flight_there_number_24, t0.flight_back_tickets_count AS flight_back_tickets_count_25, t0.flight_back_number AS flight_back_number_26, t0.is_magic_lm AS is_magic_lm_27, t0.id AS id_28, t0.deleted_at AS deleted_at_29, t0.modified_at AS modified_at_30, t0.created_at AS created_at_31, t0.tour_season_id AS tour_season_id_32, t0.food_id AS food_id_33, t0.transport_id AS transport_id_34, t0.departure_there_airport_id AS departure_there_airport_id_35, t0.arrival_there_airport_id AS arrival_there_airport_id_36, t0.departure_back_airport_id AS departure_back_airport_id_37, t0.arrival_back_airport_id AS arrival_back_airport_id_38, t0.package_id AS package_id_39, t0.source_room_id AS source_room_id_40 FROM tour_term t0 WHERE t0.id = ? AND ((t0.deleted_at IS NULL))
Parameters:
[
  "1037736519"
]
13 0.41 ms
SELECT t0.id AS id_1, t0.deleted_at AS deleted_at_2, t0.modified_at AS modified_at_3, t0.created_at AS created_at_4, t0.staff_tour_id AS staff_tour_id_5, t0.term_id AS term_id_6 FROM staff_tour_term t0 WHERE t0.term_id = ? AND ((t0.deleted_at IS NULL))
Parameters:
[
  1037736519
]
14 0.95 ms
SELECT t0.start_date AS start_date_1, t0.end_date AS end_date_2, t0.price_original AS price_original_3, t0.price_final AS price_final_4, t0.term_id AS term_id_5, t0.nights AS nights_6, t0.days AS days_7, t0.is_lm AS is_lm_8, t0.is_fm AS is_fm_9, t0.is_promo AS is_promo_10, t0.lowest_nigth_original_price AS lowest_nigth_original_price_11, t0.lm_price AS lm_price_12, t0.lm_discount AS lm_discount_13, t0.departure_there_date AS departure_there_date_14, t0.arrival_there_date AS arrival_there_date_15, t0.departure_back_date AS departure_back_date_16, t0.arrival_back_date AS arrival_back_date_17, t0.transfers_count AS transfers_count_18, t0.loyalty_prices AS loyalty_prices_19, t0.unique_key AS unique_key_20, t0.updated AS updated_21, t0.is_child_for_euro AS is_child_for_euro_22, t0.flight_there_tickets_count AS flight_there_tickets_count_23, t0.flight_there_number AS flight_there_number_24, t0.flight_back_tickets_count AS flight_back_tickets_count_25, t0.flight_back_number AS flight_back_number_26, t0.is_magic_lm AS is_magic_lm_27, t0.id AS id_28, t0.deleted_at AS deleted_at_29, t0.modified_at AS modified_at_30, t0.created_at AS created_at_31, t0.tour_season_id AS tour_season_id_32, t0.food_id AS food_id_33, t0.transport_id AS transport_id_34, t0.departure_there_airport_id AS departure_there_airport_id_35, t0.arrival_there_airport_id AS arrival_there_airport_id_36, t0.departure_back_airport_id AS departure_back_airport_id_37, t0.arrival_back_airport_id AS arrival_back_airport_id_38, t0.package_id AS package_id_39, t0.source_room_id AS source_room_id_40 FROM tour_term t0 WHERE t0.id = ? AND ((t0.deleted_at IS NULL))
Parameters:
[
  "1036333367"
]
15 0.39 ms
SELECT t0.id AS id_1, t0.deleted_at AS deleted_at_2, t0.modified_at AS modified_at_3, t0.created_at AS created_at_4, t0.staff_tour_id AS staff_tour_id_5, t0.term_id AS term_id_6 FROM staff_tour_term t0 WHERE t0.term_id = ? AND ((t0.deleted_at IS NULL))
Parameters:
[
  1036333367
]
16 0.94 ms
SELECT t0.start_date AS start_date_1, t0.end_date AS end_date_2, t0.price_original AS price_original_3, t0.price_final AS price_final_4, t0.term_id AS term_id_5, t0.nights AS nights_6, t0.days AS days_7, t0.is_lm AS is_lm_8, t0.is_fm AS is_fm_9, t0.is_promo AS is_promo_10, t0.lowest_nigth_original_price AS lowest_nigth_original_price_11, t0.lm_price AS lm_price_12, t0.lm_discount AS lm_discount_13, t0.departure_there_date AS departure_there_date_14, t0.arrival_there_date AS arrival_there_date_15, t0.departure_back_date AS departure_back_date_16, t0.arrival_back_date AS arrival_back_date_17, t0.transfers_count AS transfers_count_18, t0.loyalty_prices AS loyalty_prices_19, t0.unique_key AS unique_key_20, t0.updated AS updated_21, t0.is_child_for_euro AS is_child_for_euro_22, t0.flight_there_tickets_count AS flight_there_tickets_count_23, t0.flight_there_number AS flight_there_number_24, t0.flight_back_tickets_count AS flight_back_tickets_count_25, t0.flight_back_number AS flight_back_number_26, t0.is_magic_lm AS is_magic_lm_27, t0.id AS id_28, t0.deleted_at AS deleted_at_29, t0.modified_at AS modified_at_30, t0.created_at AS created_at_31, t0.tour_season_id AS tour_season_id_32, t0.food_id AS food_id_33, t0.transport_id AS transport_id_34, t0.departure_there_airport_id AS departure_there_airport_id_35, t0.arrival_there_airport_id AS arrival_there_airport_id_36, t0.departure_back_airport_id AS departure_back_airport_id_37, t0.arrival_back_airport_id AS arrival_back_airport_id_38, t0.package_id AS package_id_39, t0.source_room_id AS source_room_id_40 FROM tour_term t0 WHERE t0.id = ? AND ((t0.deleted_at IS NULL))
Parameters:
[
  "1036333395"
]
17 0.39 ms
SELECT t0.id AS id_1, t0.deleted_at AS deleted_at_2, t0.modified_at AS modified_at_3, t0.created_at AS created_at_4, t0.staff_tour_id AS staff_tour_id_5, t0.term_id AS term_id_6 FROM staff_tour_term t0 WHERE t0.term_id = ? AND ((t0.deleted_at IS NULL))
Parameters:
[
  1036333395
]
18 0.96 ms
SELECT t0.start_date AS start_date_1, t0.end_date AS end_date_2, t0.price_original AS price_original_3, t0.price_final AS price_final_4, t0.term_id AS term_id_5, t0.nights AS nights_6, t0.days AS days_7, t0.is_lm AS is_lm_8, t0.is_fm AS is_fm_9, t0.is_promo AS is_promo_10, t0.lowest_nigth_original_price AS lowest_nigth_original_price_11, t0.lm_price AS lm_price_12, t0.lm_discount AS lm_discount_13, t0.departure_there_date AS departure_there_date_14, t0.arrival_there_date AS arrival_there_date_15, t0.departure_back_date AS departure_back_date_16, t0.arrival_back_date AS arrival_back_date_17, t0.transfers_count AS transfers_count_18, t0.loyalty_prices AS loyalty_prices_19, t0.unique_key AS unique_key_20, t0.updated AS updated_21, t0.is_child_for_euro AS is_child_for_euro_22, t0.flight_there_tickets_count AS flight_there_tickets_count_23, t0.flight_there_number AS flight_there_number_24, t0.flight_back_tickets_count AS flight_back_tickets_count_25, t0.flight_back_number AS flight_back_number_26, t0.is_magic_lm AS is_magic_lm_27, t0.id AS id_28, t0.deleted_at AS deleted_at_29, t0.modified_at AS modified_at_30, t0.created_at AS created_at_31, t0.tour_season_id AS tour_season_id_32, t0.food_id AS food_id_33, t0.transport_id AS transport_id_34, t0.departure_there_airport_id AS departure_there_airport_id_35, t0.arrival_there_airport_id AS arrival_there_airport_id_36, t0.departure_back_airport_id AS departure_back_airport_id_37, t0.arrival_back_airport_id AS arrival_back_airport_id_38, t0.package_id AS package_id_39, t0.source_room_id AS source_room_id_40 FROM tour_term t0 WHERE t0.id = ? AND ((t0.deleted_at IS NULL))
Parameters:
[
  "1036373077"
]
19 0.39 ms
SELECT t0.id AS id_1, t0.deleted_at AS deleted_at_2, t0.modified_at AS modified_at_3, t0.created_at AS created_at_4, t0.staff_tour_id AS staff_tour_id_5, t0.term_id AS term_id_6 FROM staff_tour_term t0 WHERE t0.term_id = ? AND ((t0.deleted_at IS NULL))
Parameters:
[
  1036373077
]
20 0.94 ms
SELECT t0.start_date AS start_date_1, t0.end_date AS end_date_2, t0.price_original AS price_original_3, t0.price_final AS price_final_4, t0.term_id AS term_id_5, t0.nights AS nights_6, t0.days AS days_7, t0.is_lm AS is_lm_8, t0.is_fm AS is_fm_9, t0.is_promo AS is_promo_10, t0.lowest_nigth_original_price AS lowest_nigth_original_price_11, t0.lm_price AS lm_price_12, t0.lm_discount AS lm_discount_13, t0.departure_there_date AS departure_there_date_14, t0.arrival_there_date AS arrival_there_date_15, t0.departure_back_date AS departure_back_date_16, t0.arrival_back_date AS arrival_back_date_17, t0.transfers_count AS transfers_count_18, t0.loyalty_prices AS loyalty_prices_19, t0.unique_key AS unique_key_20, t0.updated AS updated_21, t0.is_child_for_euro AS is_child_for_euro_22, t0.flight_there_tickets_count AS flight_there_tickets_count_23, t0.flight_there_number AS flight_there_number_24, t0.flight_back_tickets_count AS flight_back_tickets_count_25, t0.flight_back_number AS flight_back_number_26, t0.is_magic_lm AS is_magic_lm_27, t0.id AS id_28, t0.deleted_at AS deleted_at_29, t0.modified_at AS modified_at_30, t0.created_at AS created_at_31, t0.tour_season_id AS tour_season_id_32, t0.food_id AS food_id_33, t0.transport_id AS transport_id_34, t0.departure_there_airport_id AS departure_there_airport_id_35, t0.arrival_there_airport_id AS arrival_there_airport_id_36, t0.departure_back_airport_id AS departure_back_airport_id_37, t0.arrival_back_airport_id AS arrival_back_airport_id_38, t0.package_id AS package_id_39, t0.source_room_id AS source_room_id_40 FROM tour_term t0 WHERE t0.id = ? AND ((t0.deleted_at IS NULL))
Parameters:
[
  "1036333397"
]
21 0.39 ms
SELECT t0.id AS id_1, t0.deleted_at AS deleted_at_2, t0.modified_at AS modified_at_3, t0.created_at AS created_at_4, t0.staff_tour_id AS staff_tour_id_5, t0.term_id AS term_id_6 FROM staff_tour_term t0 WHERE t0.term_id = ? AND ((t0.deleted_at IS NULL))
Parameters:
[
  1036333397
]
22 0.94 ms
SELECT t0.start_date AS start_date_1, t0.end_date AS end_date_2, t0.price_original AS price_original_3, t0.price_final AS price_final_4, t0.term_id AS term_id_5, t0.nights AS nights_6, t0.days AS days_7, t0.is_lm AS is_lm_8, t0.is_fm AS is_fm_9, t0.is_promo AS is_promo_10, t0.lowest_nigth_original_price AS lowest_nigth_original_price_11, t0.lm_price AS lm_price_12, t0.lm_discount AS lm_discount_13, t0.departure_there_date AS departure_there_date_14, t0.arrival_there_date AS arrival_there_date_15, t0.departure_back_date AS departure_back_date_16, t0.arrival_back_date AS arrival_back_date_17, t0.transfers_count AS transfers_count_18, t0.loyalty_prices AS loyalty_prices_19, t0.unique_key AS unique_key_20, t0.updated AS updated_21, t0.is_child_for_euro AS is_child_for_euro_22, t0.flight_there_tickets_count AS flight_there_tickets_count_23, t0.flight_there_number AS flight_there_number_24, t0.flight_back_tickets_count AS flight_back_tickets_count_25, t0.flight_back_number AS flight_back_number_26, t0.is_magic_lm AS is_magic_lm_27, t0.id AS id_28, t0.deleted_at AS deleted_at_29, t0.modified_at AS modified_at_30, t0.created_at AS created_at_31, t0.tour_season_id AS tour_season_id_32, t0.food_id AS food_id_33, t0.transport_id AS transport_id_34, t0.departure_there_airport_id AS departure_there_airport_id_35, t0.arrival_there_airport_id AS arrival_there_airport_id_36, t0.departure_back_airport_id AS departure_back_airport_id_37, t0.arrival_back_airport_id AS arrival_back_airport_id_38, t0.package_id AS package_id_39, t0.source_room_id AS source_room_id_40 FROM tour_term t0 WHERE t0.id = ? AND ((t0.deleted_at IS NULL))
Parameters:
[
  "1037604037"
]
23 0.39 ms
SELECT t0.id AS id_1, t0.deleted_at AS deleted_at_2, t0.modified_at AS modified_at_3, t0.created_at AS created_at_4, t0.staff_tour_id AS staff_tour_id_5, t0.term_id AS term_id_6 FROM staff_tour_term t0 WHERE t0.term_id = ? AND ((t0.deleted_at IS NULL))
Parameters:
[
  1037604037
]
24 0.57 ms
SELECT t0.title AS title_1, t0.start_date AS start_date_2, t0.end_date AS end_date_3, t0.slug AS slug_4, t0.show_in_calendar AS show_in_calendar_5, t0.position AS position_6, t0.id AS id_7, t0.deleted_at AS deleted_at_8, t0.modified_at AS modified_at_9, t0.created_at AS created_at_10 FROM season_event t0 WHERE t0.show_in_calendar = ? AND ((t0.deleted_at IS NULL)) ORDER BY t0.position ASC
Parameters:
[
  1
]
25 0.54 ms
SELECT t0.is_visible AS is_visible_1, t0.position AS position_2, t0.external_slug AS external_slug_3, t0.id AS id_4, t0.title AS title_5, t0.deleted_at AS deleted_at_6, t0.modified_at AS modified_at_7, t0.created_at AS created_at_8 FROM c_newsletter_category t0 WHERE t0.is_visible = ? AND ((t0.deleted_at IS NULL))
Parameters:
[
  1
]
26 0.67 ms
SELECT t0.title AS title_1, t0.slug AS slug_2, t0.is_active AS is_active_3, t0.is_popular AS is_popular_4, t0.image AS image_5, t0.image_mobile AS image_mobile_6, t0.image_alt AS image_alt_7, t0.video AS video_8, t0.redirect_url AS redirect_url_9, t0.no_index AS no_index_10, t0.canonical_url AS canonical_url_11, t0.video_url AS video_url_12, t0.video_title AS video_title_13, t0.id AS id_14, t0.deleted_at AS deleted_at_15, t0.modified_at AS modified_at_16, t0.created_at AS created_at_17, t0.seo_title AS seo_title_18, t0.meta_description AS meta_description_19, t0.meta_image AS meta_image_20, t0.type_id AS type_id_21, t0.destination_id AS destination_id_22 FROM page t0 WHERE t0.id = ? AND ((t0.deleted_at IS NULL))
Parameters:
[
  2445
]
27 0.50 ms
SELECT t0.is_visible AS is_visible_1, t0.position AS position_2, t0.external_slug AS external_slug_3, t0.id AS id_4, t0.title AS title_5, t0.deleted_at AS deleted_at_6, t0.modified_at AS modified_at_7, t0.created_at AS created_at_8 FROM c_newsletter_category t0 WHERE t0.is_visible = ? AND ((t0.deleted_at IS NULL))
Parameters:
[
  1
]

Database Connections

Name Service
default doctrine.dbal.default_connection

Entity Managers

Name Service
default doctrine.orm.default_entity_manager

Second Level Cache

Second Level Cache is not enabled.

Entities Mapping

Class Mapping errors
Satur\DatabaseBundle\Entity\SeasonEvent No errors.
Satur\DatabaseBundle\Entity\Category
  • The mappings Satur\DatabaseBundle\Entity\Category#homepageCategories and Satur\DatabaseBundle\Entity\HomepageCategory#category are inconsistent with each other.
Satur\DatabaseBundle\Entity\Food No errors.
Satur\DatabaseBundle\Entity\Transport No errors.
Satur\DatabaseBundle\Entity\ElasticSearchIndex No errors.
Satur\DatabaseBundle\Entity\TourTerm No errors.
Satur\DatabaseBundle\Entity\TourSeason No errors.
Satur\DatabaseBundle\Entity\Airport No errors.
Satur\DatabaseBundle\Entity\Package No errors.
Satur\DatabaseBundle\Entity\SourceRoom No errors.
Satur\DatabaseBundle\Entity\TourTermRoom No errors.
Satur\DatabaseBundle\Entity\StaffTourTerm No errors.
Satur\DatabaseBundle\Entity\BookmarkTerm No errors.
Satur\DatabaseBundle\Entity\MailinglistTerm No errors.
Satur\DatabaseBundle\Entity\TourTermPrice No errors.
Satur\DatabaseBundle\Entity\CategoryTopDestinationTour No errors.
Satur\DatabaseBundle\Entity\CategoryOffer No errors.
Satur\DatabaseBundle\Entity\DynamicScreen No errors.
Satur\DatabaseBundle\Entity\StaffTour No errors.
Satur\DatabaseBundle\Entity\SeasonEventDate No errors.
Satur\DatabaseBundle\Entity\Destination No errors.
Satur\DatabaseBundle\Entity\TourAttribute No errors.
Satur\DatabaseBundle\Entity\AccommodationType No errors.
Satur\DatabaseBundle\Entity\HolidayType No errors.
Satur\DatabaseBundle\Entity\TourRating No errors.
Satur\DatabaseBundle\Entity\BlogCategory No errors.
Satur\DatabaseBundle\Entity\MenuItem
  • The field 'Satur\DatabaseBundle\Entity\MenuItem#entityId' has the property type 'string' that differs from the metadata field type 'int' returned by the 'integer' DBAL type.
Satur\DatabaseBundle\Entity\NewsletterCategory No errors.
Satur\DatabaseBundle\Entity\Newsletter No errors.
Satur\DatabaseBundle\Entity\Page No errors.
Satur\DatabaseBundle\Entity\PageType No errors.
Satur\DatabaseBundle\Entity\ContentSection No errors.
Satur\DatabaseBundle\Entity\News No errors.