Symfony Profiler

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)
  )

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 = '1036316969' AND ((t0.deleted_at IS NULL));

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)
  )

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 = 1036316969 AND ((t0.deleted_at IS NULL));

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)

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);

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)
  )

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 = 1 AND ((t0.deleted_at IS NULL));

SELECT
  COUNT(*)
FROM
  branch_office t0
WHERE
  t0.is_active = ?
  AND (
    (t0.deleted_at IS NULL)
  )

SELECT COUNT(*) FROM branch_office t0 WHERE t0.is_active = 1 AND ((t0.deleted_at IS NULL));

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

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;

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)
  )

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));

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)
  )

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 = 94 AND ((t0.deleted_at IS NULL));

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)
  )

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 = 94 AND ((t0.deleted_at IS NULL));

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)
  )

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 = 2445 AND ((t0.deleted_at IS NULL));

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)
  )

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 = 3 AND ((t0.deleted_at IS NULL));

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

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;

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

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 = 1 AND ((t0.deleted_at IS NULL)) ORDER BY t0.position ASC;