GET https://wwwdev2.satur.sk/poznavacie-zajazdy/katalog-zajazdov?stranka=1&zoradenie=cena-najdrahsie

Response
200 OK
IP
18.217.52.224
Profiled on
Token
dc99d6

Query Metrics

53 Database Queries
13 Different statements
28.74 ms Query time
2 Invalid entities

Queries

Group similar statements

#▲ Time Info
1 1.74 ms 
SELECT u0_.id AS id_0, u0_.old_url AS old_url_1, u0_.new_url AS new_url_2 FROM url_redirect u0_ WHERE (u0_.is_active = 1) AND (u0_.deleted_at IS NULL)
Parameters: 
[]
View formatted query    View runnable query    Explain query
2 0.94 ms 
SELECT t0.title AS title_1, t0.h1 AS h1_2, t0.url AS url_3, t0.description AS description_4, t0.image AS image_5, t0.id AS id_6, t0.deleted_at AS deleted_at_7, t0.modified_at AS modified_at_8, t0.created_at AS created_at_9 FROM seo_url t0 WHERE ((t0.deleted_at IS NULL))
Parameters: 
[]
View formatted query    View runnable query    Explain query
3 0.61 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
]
View formatted query    View runnable query    Explain query
4 0.83 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: 
[
  "1036316969"
]
View formatted query    View runnable query    Explain query
5 0.70 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: 
[
  1036316969
]
View formatted query    View runnable query    Explain query
6 0.69 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: 
[
  "1036316970"
]
View formatted query    View runnable query    Explain query
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: 
[
  1036316970
]
View formatted query    View runnable query    Explain query
8 0.66 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: 
[
  "1038089448"
]
View formatted query    View runnable query    Explain query
9 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: 
[
  1038089448
]
View formatted query    View runnable query    Explain query
10 0.65 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: 
[
  "1036383927"
]
View formatted query    View runnable query    Explain query
11 0.37 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: 
[
  1036383927
]
View formatted query    View runnable query    Explain query
12 0.66 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: 
[
  "1036316913"
]
View formatted query    View runnable query    Explain query
13 0.35 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: 
[
  1036316913
]
View formatted query    View runnable query    Explain query
14 0.57 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: 
[
  "1036316914"
]
View formatted query    View runnable query    Explain query
15 0.31 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: 
[
  1036316914
]
View formatted query    View runnable query    Explain query
16 0.51 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: 
[
  "1036383807"
]
View formatted query    View runnable query    Explain query
17 0.31 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: 
[
  1036383807
]
View formatted query    View runnable query    Explain query
18 0.51 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: 
[
  "1036377037"
]
View formatted query    View runnable query    Explain query
19 0.31 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: 
[
  1036377037
]
View formatted query    View runnable query    Explain query
20 0.60 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: 
[
  "1036337997"
]
View formatted query    View runnable query    Explain query
21 0.31 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: 
[
  1036337997
]
View formatted query    View runnable query    Explain query
22 0.61 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: 
[
  "1036337998"
]
View formatted query    View runnable query    Explain query
23 0.30 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: 
[
  1036337998
]
View formatted query    View runnable query    Explain query
24 0.50 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: 
[
  "1038289875"
]
View formatted query    View runnable query    Explain query
25 0.32 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: 
[
  1038289875
]
View formatted query    View runnable query    Explain query
26 0.53 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: 
[
  "1036383871"
]
View formatted query    View runnable query    Explain query
27 0.31 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: 
[
  1036383871
]
View formatted query    View runnable query    Explain query
28 0.62 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: 
[
  "1036383872"
]
View formatted query    View runnable query    Explain query
29 0.34 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: 
[
  1036383872
]
View formatted query    View runnable query    Explain query
30 0.55 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: 
[
  "1036383866"
]
View formatted query    View runnable query    Explain query
31 0.35 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: 
[
  1036383866
]
View formatted query    View runnable query    Explain query
32 0.64 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: 
[
  "1036384112"
]
View formatted query    View runnable query    Explain query
33 0.33 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: 
[
  1036384112
]
View formatted query    View runnable query    Explain query
34 0.58 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: 
[
  "1036383867"
]
View formatted query    View runnable query    Explain query
35 0.35 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: 
[
  1036383867
]
View formatted query    View runnable query    Explain query
36 0.59 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: 
[
  "1036376403"
]
View formatted query    View runnable query    Explain query
37 0.36 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: 
[
  1036376403
]
View formatted query    View runnable query    Explain query
38 0.64 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: 
[
  "1036383868"
]
View formatted query    View runnable query    Explain query
39 0.32 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: 
[
  1036383868
]
View formatted query    View runnable query    Explain query
40 0.52 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: 
[
  "1039585131"
]
View formatted query    View runnable query    Explain query
41 0.34 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: 
[
  1039585131
]
View formatted query    View runnable query    Explain query
42 0.57 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: 
[
  "1036383869"
]
View formatted query    View runnable query    Explain query
43 0.32 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: 
[
  1036383869
]
View formatted query    View runnable query    Explain query
44 0.44 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
]
View formatted query    View runnable query    Explain query
45 0.67 ms 
SELECT t0.title AS title_1, t0.region AS region_2, t0.phone AS phone_3, t0.email AS email_4, t0.map_zoom AS map_zoom_5, t0.description AS description_6, t0.is_active AS is_active_7, t0.opening_hours_mon AS opening_hours_mon_8, t0.opening_hours_tue AS opening_hours_tue_9, t0.opening_hours_wed AS opening_hours_wed_10, t0.opening_hours_thu AS opening_hours_thu_11, t0.opening_hours_fri AS opening_hours_fri_12, t0.opening_hours_sat AS opening_hours_sat_13, t0.opening_hours_sun AS opening_hours_sun_14, t0.no_index AS no_index_15, t0.slug AS slug_16, t0.id AS id_17, t0.deleted_at AS deleted_at_18, t0.modified_at AS modified_at_19, t0.created_at AS created_at_20, t0.seo_title AS seo_title_21, t0.meta_description AS meta_description_22, t0.meta_image AS meta_image_23, t0.street AS street_24, t0.street_number AS street_number_25, t0.zipcode AS zipcode_26, t0.city AS city_27, t0.latitude AS latitude_28, t0.longitude AS longitude_29, t0.country_id AS country_id_30 FROM branch_office t0 WHERE t0.id = ? AND ((t0.deleted_at IS NULL))
Parameters: 
[
  94
]
View formatted query    View runnable query    Explain query
46 0.68 ms 
SELECT t0.date_from AS date_from_1, t0.date_to AS date_to_2, t0.description AS description_3, t0.id AS id_4, t0.deleted_at AS deleted_at_5, t0.modified_at AS modified_at_6, t0.created_at AS created_at_7, t0.branch_office_id AS branch_office_id_8 FROM branch_office_hour t0 WHERE t0.branch_office_id = ? AND ((t0.deleted_at IS NULL))
Parameters: 
[
  94
]
View formatted query    View runnable query    Explain query
47 0.53 ms 
SELECT COUNT(*) FROM branch_office t0 WHERE t0.is_active = ? AND ((t0.deleted_at IS NULL))
Parameters: 
[
  1
]
View formatted query    View runnable query    Explain query
48 0.63 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
]
View formatted query    View runnable query    Explain query
49 0.66 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
]
View formatted query    View runnable query    Explain query
50 0.58 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
]
View formatted query    View runnable query    Explain query
51 0.58 ms 
SELECT COUNT(*) FROM branch_office t0 WHERE t0.is_active = ? AND ((t0.deleted_at IS NULL))
Parameters: 
[
  1
]
View formatted query    View runnable query    Explain query
52 1.02 ms 
SELECT p0_.title AS title_0, p0_.render_type AS render_type_1, p0_.show_type AS show_type_2, p0_.image AS image_3, p0_.image_alt AS image_alt_4, p0_.url AS url_5, p0_.show_for_url AS show_for_url_6, p0_.valid_from AS valid_from_7, p0_.valid_to AS valid_to_8, p0_.is_active AS is_active_9, p0_.show_in_cart AS show_in_cart_10, p0_.counter_views AS counter_views_11, p0_.counter_clicks AS counter_clicks_12, p0_.counter_closings AS counter_closings_13, p0_.position AS position_14, p0_.id AS id_15, p0_.deleted_at AS deleted_at_16, p0_.modified_at AS modified_at_17, p0_.created_at AS created_at_18 FROM popup p0_ WHERE (p0_.is_active = 1 AND p0_.image <> '') AND (p0_.deleted_at IS NULL) ORDER BY p0_.id DESC
Parameters: 
[]
View formatted query    View runnable query    Explain query
53 0.56 ms 
SELECT t0.title AS title_1, t0.slug AS slug_2, t0.description AS description_3, t0.value AS value_4, t0.type AS type_5, t0.id AS id_6, t0.deleted_at AS deleted_at_7, t0.modified_at AS modified_at_8, t0.created_at AS created_at_9 FROM setting t0
Parameters: 
[]
View formatted query    View runnable query    Explain query

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\UrlRedirect No errors.
Satur\DatabaseBundle\Entity\SeoUrl No 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\BranchOffice No errors.
Satur\DatabaseBundle\Entity\Country No errors.
Satur\DatabaseBundle\Entity\BranchOfficeHour No errors.
Satur\DatabaseBundle\Entity\BranchOfficeImage No errors.
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.
Satur\DatabaseBundle\Entity\Popup No errors.
Satur\DatabaseBundle\Entity\PopupEntity No errors.
Satur\DatabaseBundle\Entity\Setting No errors.