Symfony Profiler

Query Metrics

43 Database Queries

21 Different statements

41.20 ms Query time

4 Invalid entities

Queries


SELECT c.Id FROM category c 
WHERE CONCAT(COALESCE(c.segment,''),'/',COALESCE(c.slug,'')) = :concated AND c.deleted_at IS NULL ORDER BY c.is_active=1 DESC
SELECT t0.title AS title_1, t0.title_short AS title_short_2, t0.lft AS lft_3, t0.rgt AS rgt_4, t0.lvl AS lvl_5, t0.slug AS slug_6, t0.segment AS segment_7, t0.is_active AS is_active_8, t0.redirect_url AS redirect_url_9, t0.description AS description_10, t0.filter_range AS filter_range_11, t0.no_index AS no_index_12, t0.icon_image AS icon_image_13, t0.image AS image_14, t0.qb_rules AS qb_rules_15, t0.qb_rules_elastic AS qb_rules_elastic_16, t0.url_old AS url_old_17, t0.seo_year AS seo_year_18, t0.show_calendar_button AS show_calendar_button_19, t0.category_offer_order_by AS category_offer_order_by_20, t0.category_offer_after_sold_out AS category_offer_after_sold_out_21, t0.id AS id_22, t0.deleted_at AS deleted_at_23, t0.modified_at AS modified_at_24, t0.created_at AS created_at_25, t0.seo_title AS seo_title_26, t0.meta_description AS meta_description_27, t0.meta_image AS meta_image_28, t0.tree_root AS tree_root_29, t0.parent_id AS parent_id_30, t0.filter_category_id AS filter_category_id_31, t0.canonical_category_id AS canonical_category_id_32 FROM category t0 WHERE t0.id = ? AND ((t0.deleted_at IS NULL))
SELECT t0.position AS position_1, t0.id AS id_2, t0.deleted_at AS deleted_at_3, t0.modified_at AS modified_at_4, t0.created_at AS created_at_5, t0.tour_id AS tour_id_6, t0.tour_term_id AS tour_term_id_7, t0.category_id AS category_id_8 FROM category_offer t0 WHERE t0.category_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 = ? AND ((t0.deleted_at IS NULL))
SELECT c0_.is_active AS is_active_0, c0_.position AS position_1, c0_.id AS id_2, c0_.deleted_at AS deleted_at_3, c0_.modified_at AS modified_at_4, c0_.created_at AS created_at_5, t1_.alternative_title AS alternative_title_6, t1_.slug AS slug_7, t1_.description AS description_8, t1_.icon AS icon_9, t1_.has_pill AS has_pill_10, t1_.pill_title AS pill_title_11, t1_.pill_tooltip AS pill_tooltip_12, t1_.pill_color AS pill_color_13, t1_.position AS position_14, t1_.is_active AS is_active_15, t1_.id AS id_16, t1_.title AS title_17, t1_.deleted_at AS deleted_at_18, t1_.modified_at AS modified_at_19, t1_.created_at AS created_at_20, c0_.category_id AS category_id_21, c0_.tour_attribute_id AS tour_attribute_id_22, t1_.tour_attribute_category_id AS tour_attribute_category_id_23 FROM category_tour_attribute_filter c0_ LEFT JOIN tour_attribute t1_ ON c0_.tour_attribute_id = t1_.id AND (t1_.deleted_at IS NULL) WHERE (c0_.category_id = ?) AND (c0_.deleted_at IS NULL) ORDER BY c0_.position ASC
SELECT c0_.is_active AS is_active_0, c0_.position AS position_1, c0_.id AS id_2, c0_.deleted_at AS deleted_at_3, c0_.modified_at AS modified_at_4, c0_.created_at AS created_at_5, t1_.alternative_title AS alternative_title_6, t1_.slug AS slug_7, t1_.description AS description_8, t1_.icon AS icon_9, t1_.has_pill AS has_pill_10, t1_.pill_title AS pill_title_11, t1_.pill_tooltip AS pill_tooltip_12, t1_.pill_color AS pill_color_13, t1_.position AS position_14, t1_.is_active AS is_active_15, t1_.id AS id_16, t1_.title AS title_17, t1_.deleted_at AS deleted_at_18, t1_.modified_at AS modified_at_19, t1_.created_at AS created_at_20, c0_.category_id AS category_id_21, c0_.tour_attribute_id AS tour_attribute_id_22, t1_.tour_attribute_category_id AS tour_attribute_category_id_23 FROM category_tour_attribute_filter c0_ LEFT JOIN tour_attribute t1_ ON c0_.tour_attribute_id = t1_.id AND (t1_.deleted_at IS NULL) WHERE (c0_.category_id = ?) AND (c0_.deleted_at IS NULL) ORDER BY c0_.position ASC
SELECT t0.alternative_title AS alternative_title_1, t0.slug AS slug_2, t0.description AS description_3, t0.icon AS icon_4, t0.has_pill AS has_pill_5, t0.pill_title AS pill_title_6, t0.pill_tooltip AS pill_tooltip_7, t0.pill_color AS pill_color_8, t0.position AS position_9, t0.is_active AS is_active_10, t0.id AS id_11, t0.title AS title_12, t0.deleted_at AS deleted_at_13, t0.modified_at AS modified_at_14, t0.created_at AS created_at_15, t0.tour_attribute_category_id AS tour_attribute_category_id_16 FROM tour_attribute t0 WHERE t0.tour_attribute_category_id = ? AND ((t0.deleted_at IS NULL))
SELECT t0.alternative_title AS alternative_title_1, t0.slug AS slug_2, t0.description AS description_3, t0.icon AS icon_4, t0.has_pill AS has_pill_5, t0.pill_title AS pill_title_6, t0.pill_tooltip AS pill_tooltip_7, t0.pill_color AS pill_color_8, t0.position AS position_9, t0.is_active AS is_active_10, t0.id AS id_11, t0.title AS title_12, t0.deleted_at AS deleted_at_13, t0.modified_at AS modified_at_14, t0.created_at AS created_at_15, t0.tour_attribute_category_id AS tour_attribute_category_id_16 FROM tour_attribute t0 WHERE t0.tour_attribute_category_id = ? AND ((t0.deleted_at IS NULL))
SELECT r0_.slug AS slug_0, r0_.is_active AS is_active_1, r0_.id AS id_2, r0_.title AS title_3, r0_.deleted_at AS deleted_at_4, r0_.modified_at AS modified_at_5, r0_.created_at AS created_at_6 FROM region r0_ WHERE (r0_.deleted_at IS NULL)
SELECT c0_.slug AS slug_0, c0_.title_instrumental AS title_instrumental_1, c0_.position AS position_2, c0_.id AS id_3, c0_.title AS title_4, c0_.deleted_at AS deleted_at_5, c0_.modified_at AS modified_at_6, c0_.created_at AS created_at_7, c0_.tour_attribute_id AS tour_attribute_id_8 FROM c_food c0_ WHERE (c0_.deleted_at IS NULL)
SELECT c0_.slug AS slug_0, c0_.position AS position_1, c0_.id AS id_2, c0_.title AS title_3, c0_.deleted_at AS deleted_at_4, c0_.modified_at AS modified_at_5, c0_.created_at AS created_at_6 FROM c_transport c0_ WHERE (c0_.deleted_at IS NULL)
SELECT d0_.title AS title_0, d0_.code AS code_1, d0_.lft AS lft_2, d0_.rgt AS rgt_3, d0_.lvl AS lvl_4, d0_.slug AS slug_5, d0_.alternative_title AS alternative_title_6, d0_.is_active AS is_active_7, d0_.description AS description_8, d0_.capital_city AS capital_city_9, d0_.time_shift AS time_shift_10, d0_.must_visit_radius AS must_visit_radius_11, d0_.title_lokal AS title_lokal_12, d0_.title_genitiv AS title_genitiv_13, d0_.title_in_search AS title_in_search_14, d0_.district_id AS district_id_15, d0_.location_id AS location_id_16, d0_.images_season AS images_season_17, d0_.image AS image_18, d0_.popular_image AS popular_image_19, d0_.image_alt AS image_alt_20, d0_.id AS id_21, d0_.deleted_at AS deleted_at_22, d0_.modified_at AS modified_at_23, d0_.created_at AS created_at_24, d0_.latitude AS latitude_25, d0_.longitude AS longitude_26, d0_.tree_root AS tree_root_27, d0_.parent_id AS parent_id_28, d0_.currency_id AS currency_id_29, d0_.continent_id AS continent_id_30 FROM destination d0_ WHERE (d0_.deleted_at IS NULL)
SELECT c0_.is_active AS is_active_0, c0_.position AS position_1, c0_.id AS id_2, c0_.deleted_at AS deleted_at_3, c0_.modified_at AS modified_at_4, c0_.created_at AS created_at_5, t1_.alternative_title AS alternative_title_6, t1_.slug AS slug_7, t1_.description AS description_8, t1_.icon AS icon_9, t1_.has_pill AS has_pill_10, t1_.pill_title AS pill_title_11, t1_.pill_tooltip AS pill_tooltip_12, t1_.pill_color AS pill_color_13, t1_.position AS position_14, t1_.is_active AS is_active_15, t1_.id AS id_16, t1_.title AS title_17, t1_.deleted_at AS deleted_at_18, t1_.modified_at AS modified_at_19, t1_.created_at AS created_at_20, c0_.category_id AS category_id_21, c0_.tour_attribute_id AS tour_attribute_id_22, t1_.tour_attribute_category_id AS tour_attribute_category_id_23 FROM category_tour_attribute_filter c0_ LEFT JOIN tour_attribute t1_ ON c0_.tour_attribute_id = t1_.id AND (t1_.deleted_at IS NULL) WHERE (c0_.category_id = ?) AND (c0_.deleted_at IS NULL) ORDER BY c0_.position ASC
SELECT c0_.is_active AS is_active_0, c0_.position AS position_1, c0_.id AS id_2, c0_.deleted_at AS deleted_at_3, c0_.modified_at AS modified_at_4, c0_.created_at AS created_at_5, t1_.alternative_title AS alternative_title_6, t1_.slug AS slug_7, t1_.description AS description_8, t1_.icon AS icon_9, t1_.has_pill AS has_pill_10, t1_.pill_title AS pill_title_11, t1_.pill_tooltip AS pill_tooltip_12, t1_.pill_color AS pill_color_13, t1_.position AS position_14, t1_.is_active AS is_active_15, t1_.id AS id_16, t1_.title AS title_17, t1_.deleted_at AS deleted_at_18, t1_.modified_at AS modified_at_19, t1_.created_at AS created_at_20, c0_.category_id AS category_id_21, c0_.tour_attribute_id AS tour_attribute_id_22, t1_.tour_attribute_category_id AS tour_attribute_category_id_23 FROM category_tour_attribute_filter c0_ LEFT JOIN tour_attribute t1_ ON c0_.tour_attribute_id = t1_.id AND (t1_.deleted_at IS NULL) WHERE (c0_.category_id = ?) AND (c0_.deleted_at IS NULL) ORDER BY c0_.position ASC
SELECT t0.position AS position_1, t0.id AS id_2, t0.deleted_at AS deleted_at_3, t0.modified_at AS modified_at_4, t0.created_at AS created_at_5, t0.category_id AS category_id_6, t0.destination_id AS destination_id_7, t0.parent_best_destination_id AS parent_best_destination_id_8 FROM category_best_destination t0 WHERE t0.category_id = ? AND ((t0.deleted_at IS NULL)) ORDER BY t0.position ASC
SELECT t0.title AS title_1, t0.title_short AS title_short_2, t0.lft AS lft_3, t0.rgt AS rgt_4, t0.lvl AS lvl_5, t0.slug AS slug_6, t0.segment AS segment_7, t0.is_active AS is_active_8, t0.redirect_url AS redirect_url_9, t0.description AS description_10, t0.filter_range AS filter_range_11, t0.no_index AS no_index_12, t0.icon_image AS icon_image_13, t0.image AS image_14, t0.qb_rules AS qb_rules_15, t0.qb_rules_elastic AS qb_rules_elastic_16, t0.url_old AS url_old_17, t0.seo_year AS seo_year_18, t0.show_calendar_button AS show_calendar_button_19, t0.category_offer_order_by AS category_offer_order_by_20, t0.category_offer_after_sold_out AS category_offer_after_sold_out_21, t0.id AS id_22, t0.deleted_at AS deleted_at_23, t0.modified_at AS modified_at_24, t0.created_at AS created_at_25, t0.seo_title AS seo_title_26, t0.meta_description AS meta_description_27, t0.meta_image AS meta_image_28, t0.tree_root AS tree_root_29, t0.parent_id AS parent_id_30, t0.filter_category_id AS filter_category_id_31, t0.canonical_category_id AS canonical_category_id_32 FROM category t0 WHERE t0.parent_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.alias = ? AND ((t0.deleted_at IS NULL)) LIMIT 1
SELECT c.Id FROM category c 
WHERE CONCAT(COALESCE(c.segment,''),'/',COALESCE(c.slug,'')) = :concated AND c.deleted_at IS NULL ORDER BY c.is_active=1 DESC
SELECT c0_.is_active AS is_active_0, c0_.position AS position_1, c0_.id AS id_2, c0_.deleted_at AS deleted_at_3, c0_.modified_at AS modified_at_4, c0_.created_at AS created_at_5, t1_.alternative_title AS alternative_title_6, t1_.slug AS slug_7, t1_.description AS description_8, t1_.icon AS icon_9, t1_.has_pill AS has_pill_10, t1_.pill_title AS pill_title_11, t1_.pill_tooltip AS pill_tooltip_12, t1_.pill_color AS pill_color_13, t1_.position AS position_14, t1_.is_active AS is_active_15, t1_.id AS id_16, t1_.title AS title_17, t1_.deleted_at AS deleted_at_18, t1_.modified_at AS modified_at_19, t1_.created_at AS created_at_20, c0_.category_id AS category_id_21, c0_.tour_attribute_id AS tour_attribute_id_22, t1_.tour_attribute_category_id AS tour_attribute_category_id_23 FROM category_tour_attribute_filter c0_ LEFT JOIN tour_attribute t1_ ON c0_.tour_attribute_id = t1_.id AND (t1_.deleted_at IS NULL) WHERE (c0_.category_id = ?) AND (c0_.deleted_at IS NULL) ORDER BY c0_.position ASC
SELECT c0_.is_active AS is_active_0, c0_.position AS position_1, c0_.id AS id_2, c0_.deleted_at AS deleted_at_3, c0_.modified_at AS modified_at_4, c0_.created_at AS created_at_5, t1_.alternative_title AS alternative_title_6, t1_.slug AS slug_7, t1_.description AS description_8, t1_.icon AS icon_9, t1_.has_pill AS has_pill_10, t1_.pill_title AS pill_title_11, t1_.pill_tooltip AS pill_tooltip_12, t1_.pill_color AS pill_color_13, t1_.position AS position_14, t1_.is_active AS is_active_15, t1_.id AS id_16, t1_.title AS title_17, t1_.deleted_at AS deleted_at_18, t1_.modified_at AS modified_at_19, t1_.created_at AS created_at_20, c0_.category_id AS category_id_21, c0_.tour_attribute_id AS tour_attribute_id_22, t1_.tour_attribute_category_id AS tour_attribute_category_id_23 FROM category_tour_attribute_filter c0_ LEFT JOIN tour_attribute t1_ ON c0_.tour_attribute_id = t1_.id AND (t1_.deleted_at IS NULL) WHERE (c0_.category_id = ?) AND (c0_.deleted_at IS NULL) ORDER BY c0_.position ASC
SELECT t0.position AS position_1, t0.id AS id_2, t0.deleted_at AS deleted_at_3, t0.modified_at AS modified_at_4, t0.created_at AS created_at_5, t0.tour_id AS tour_id_6, t0.tour_term_id AS tour_term_id_7, t0.category_id AS category_id_8 FROM category_offer t0 WHERE t0.category_id = ? AND ((t0.deleted_at IS NULL))
SELECT c.Id FROM category c 
WHERE CONCAT(COALESCE(c.segment,''),'/',COALESCE(c.slug,'')) = :concated AND c.deleted_at IS NULL ORDER BY c.is_active=1 DESC
SELECT c0_.is_active AS is_active_0, c0_.position AS position_1, c0_.id AS id_2, c0_.deleted_at AS deleted_at_3, c0_.modified_at AS modified_at_4, c0_.created_at AS created_at_5, t1_.alternative_title AS alternative_title_6, t1_.slug AS slug_7, t1_.description AS description_8, t1_.icon AS icon_9, t1_.has_pill AS has_pill_10, t1_.pill_title AS pill_title_11, t1_.pill_tooltip AS pill_tooltip_12, t1_.pill_color AS pill_color_13, t1_.position AS position_14, t1_.is_active AS is_active_15, t1_.id AS id_16, t1_.title AS title_17, t1_.deleted_at AS deleted_at_18, t1_.modified_at AS modified_at_19, t1_.created_at AS created_at_20, c0_.category_id AS category_id_21, c0_.tour_attribute_id AS tour_attribute_id_22, t1_.tour_attribute_category_id AS tour_attribute_category_id_23 FROM category_tour_attribute_filter c0_ LEFT JOIN tour_attribute t1_ ON c0_.tour_attribute_id = t1_.id AND (t1_.deleted_at IS NULL) WHERE (c0_.category_id = ?) AND (c0_.deleted_at IS NULL) ORDER BY c0_.position ASC
SELECT c0_.is_active AS is_active_0, c0_.position AS position_1, c0_.id AS id_2, c0_.deleted_at AS deleted_at_3, c0_.modified_at AS modified_at_4, c0_.created_at AS created_at_5, t1_.alternative_title AS alternative_title_6, t1_.slug AS slug_7, t1_.description AS description_8, t1_.icon AS icon_9, t1_.has_pill AS has_pill_10, t1_.pill_title AS pill_title_11, t1_.pill_tooltip AS pill_tooltip_12, t1_.pill_color AS pill_color_13, t1_.position AS position_14, t1_.is_active AS is_active_15, t1_.id AS id_16, t1_.title AS title_17, t1_.deleted_at AS deleted_at_18, t1_.modified_at AS modified_at_19, t1_.created_at AS created_at_20, c0_.category_id AS category_id_21, c0_.tour_attribute_id AS tour_attribute_id_22, t1_.tour_attribute_category_id AS tour_attribute_category_id_23 FROM category_tour_attribute_filter c0_ LEFT JOIN tour_attribute t1_ ON c0_.tour_attribute_id = t1_.id AND (t1_.deleted_at IS NULL) WHERE (c0_.category_id = ?) AND (c0_.deleted_at IS NULL) ORDER BY c0_.position ASC
SELECT t0.position AS position_1, t0.id AS id_2, t0.deleted_at AS deleted_at_3, t0.modified_at AS modified_at_4, t0.created_at AS created_at_5, t0.tour_id AS tour_id_6, t0.tour_term_id AS tour_term_id_7, t0.category_id AS category_id_8 FROM category_offer t0 WHERE t0.category_id = ? AND ((t0.deleted_at IS NULL))
SELECT c.Id FROM category c 
WHERE CONCAT(COALESCE(c.segment,''),'/',COALESCE(c.slug,'')) = :concated AND c.deleted_at IS NULL ORDER BY c.is_active=1 DESC
SELECT c0_.is_active AS is_active_0, c0_.position AS position_1, c0_.id AS id_2, c0_.deleted_at AS deleted_at_3, c0_.modified_at AS modified_at_4, c0_.created_at AS created_at_5, t1_.alternative_title AS alternative_title_6, t1_.slug AS slug_7, t1_.description AS description_8, t1_.icon AS icon_9, t1_.has_pill AS has_pill_10, t1_.pill_title AS pill_title_11, t1_.pill_tooltip AS pill_tooltip_12, t1_.pill_color AS pill_color_13, t1_.position AS position_14, t1_.is_active AS is_active_15, t1_.id AS id_16, t1_.title AS title_17, t1_.deleted_at AS deleted_at_18, t1_.modified_at AS modified_at_19, t1_.created_at AS created_at_20, c0_.category_id AS category_id_21, c0_.tour_attribute_id AS tour_attribute_id_22, t1_.tour_attribute_category_id AS tour_attribute_category_id_23 FROM category_tour_attribute_filter c0_ LEFT JOIN tour_attribute t1_ ON c0_.tour_attribute_id = t1_.id AND (t1_.deleted_at IS NULL) WHERE (c0_.category_id = ?) AND (c0_.deleted_at IS NULL) ORDER BY c0_.position ASC
SELECT t0.position AS position_1, t0.id AS id_2, t0.deleted_at AS deleted_at_3, t0.modified_at AS modified_at_4, t0.created_at AS created_at_5, t0.tour_id AS tour_id_6, t0.tour_term_id AS tour_term_id_7, t0.category_id AS category_id_8 FROM category_offer t0 WHERE t0.category_id = ? AND ((t0.deleted_at IS NULL))
SELECT t0.description AS description_1, t0.title AS title_2, t0.id AS id_3, t0.deleted_at AS deleted_at_4, t0.modified_at AS modified_at_5, t0.created_at AS created_at_6, t0.seo_title AS seo_title_7, t0.meta_description AS meta_description_8, t0.meta_image AS meta_image_9, t0.category_id AS category_id_10, t0.destination_id AS destination_id_11 FROM category_seo_destination t0 WHERE t0.category_id = ? AND t0.destination_id = ? AND ((t0.deleted_at IS NULL)) LIMIT 1
SELECT b0_.title AS title_0, b0_.slug AS slug_1, b0_.is_active AS is_active_2, b0_.image AS image_3, b0_.publish_from AS publish_from_4, b0_.views AS views_5, b0_.read_time_min AS read_time_min_6, b0_.no_index AS no_index_7, b0_.updated_at AS updated_at_8, b0_.id AS id_9, b0_.deleted_at AS deleted_at_10, b0_.modified_at AS modified_at_11, b0_.created_at AS created_at_12, b0_.seo_title AS seo_title_13, b0_.meta_description AS meta_description_14, b0_.meta_image AS meta_image_15, b0_.blog_category_id AS blog_category_id_16, b0_.destination_id AS destination_id_17 FROM blog b0_ WHERE (b0_.publish_from <= '2025-04-05 09:41:34' AND b0_.publish_from IS NOT NULL AND b0_.is_active = 1) AND (b0_.deleted_at IS NULL) ORDER BY b0_.publish_from DESC LIMIT 5
SELECT t0.name AS name_1, t0.image AS image_2, t0.is_active AS is_active_3, t0.slug AS slug_4, t0.about_me AS about_me_5, t0.motto AS motto_6, t0.email AS email_7, t0.is_in_filter AS is_in_filter_8, t0.no_index AS no_index_9, t0.phone AS phone_10, t0.subtitle AS subtitle_11, t0.background_image AS background_image_12, t0.background_image_alt AS background_image_alt_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.staff_type_id AS staff_type_id_21 FROM staff t0 INNER JOIN staff_category ON t0.id = staff_category.staff_id WHERE staff_category.category_id = ? AND ((t0.deleted_at IS NULL))
SELECT c0_.start_date AS start_date_0, c0_.end_date AS end_date_1, c0_.is_active AS is_active_2, c0_.position AS position_3, c0_.listing_position AS listing_position_4, c0_.message_type AS message_type_5, c0_.title AS title_6, c0_.text_above_title AS text_above_title_7, c0_.icon AS icon_8, c0_.button_url AS button_url_9, c0_.text AS text_10, c0_.show_form AS show_form_11, c0_.id AS id_12, c0_.deleted_at AS deleted_at_13, c0_.modified_at AS modified_at_14, c0_.created_at AS created_at_15 FROM category_info_message c0_ LEFT JOIN category_info_message_category c2_ ON c0_.id = c2_.category_info_message_id LEFT JOIN category c1_ ON c1_.id = c2_.category_id AND (c1_.deleted_at IS NULL) LEFT JOIN category_info_message_destination c4_ ON c0_.id = c4_.category_info_message_id LEFT JOIN destination d3_ ON d3_.id = c4_.destination_id AND (d3_.deleted_at IS NULL) WHERE ((c1_.id = 5 OR c1_.id IS NULL) AND (d3_.id IN (138) OR d3_.id IS NULL) AND (c0_.start_date <= '2025-04-05 09:41:34' OR c0_.start_date IS NULL) AND (c0_.end_date >= '2025-04-05 09:41:34' OR c0_.end_date IS NULL) AND c0_.is_active = 1) AND (c0_.deleted_at IS NULL) ORDER BY c0_.position DESC LIMIT 1
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 = ? AND ((t0.deleted_at IS NULL))
SELECT c0_.position AS position_0, c0_.highlight AS highlight_1, c0_.id AS id_2, c0_.deleted_at AS deleted_at_3, c0_.modified_at AS modified_at_4, c0_.created_at AS created_at_5, c0_.tour_id AS tour_id_6, c0_.category_top_destination_id AS category_top_destination_id_7, c0_.user_id AS user_id_8 FROM category_top_destination_tour c0_ LEFT JOIN category_top_destination c1_ ON c0_.category_top_destination_id = c1_.id AND (c1_.deleted_at IS NULL) WHERE (c1_.category_id = ? AND c1_.destination_id IS NULL) AND (c0_.deleted_at IS NULL) ORDER BY c0_.position ASC
SELECT c0_.start_date AS start_date_0, c0_.end_date AS end_date_1, c0_.is_active AS is_active_2, c0_.position AS position_3, c0_.listing_position AS listing_position_4, c0_.message_type AS message_type_5, c0_.title AS title_6, c0_.text_above_title AS text_above_title_7, c0_.icon AS icon_8, c0_.button_url AS button_url_9, c0_.text AS text_10, c0_.show_form AS show_form_11, c0_.id AS id_12, c0_.deleted_at AS deleted_at_13, c0_.modified_at AS modified_at_14, c0_.created_at AS created_at_15 FROM category_info_message c0_ LEFT JOIN category_info_message_category c2_ ON c0_.id = c2_.category_info_message_id LEFT JOIN category c1_ ON c1_.id = c2_.category_id AND (c1_.deleted_at IS NULL) LEFT JOIN category_info_message_destination c4_ ON c0_.id = c4_.category_info_message_id LEFT JOIN destination d3_ ON d3_.id = c4_.destination_id AND (d3_.deleted_at IS NULL) WHERE ((c1_.id = 5 OR c1_.id IS NULL) AND (d3_.id IN (138) OR d3_.id IS NULL) AND (c0_.start_date <= '2025-04-05 09:41:34' OR c0_.start_date IS NULL) AND (c0_.end_date >= '2025-04-05 09:41:34' OR c0_.end_date IS NULL) AND c0_.is_active = 1) AND (c0_.deleted_at IS NULL) ORDER BY c0_.position DESC LIMIT 1
SELECT t0.slug AS slug_1, t0.is_active AS is_active_2, t0.position AS position_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 blog_category t0 WHERE t0.id = ? AND ((t0.deleted_at IS NULL))
SELECT t0.slug AS slug_1, t0.is_active AS is_active_2, t0.position AS position_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 blog_category t0 WHERE t0.id = ? AND ((t0.deleted_at IS NULL))
SELECT t0.slug AS slug_1, t0.is_active AS is_active_2, t0.position AS position_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 blog_category t0 WHERE t0.id = ? AND ((t0.deleted_at IS NULL))
SELECT t0.slug AS slug_1, t0.is_active AS is_active_2, t0.position AS position_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 blog_category t0 WHERE t0.id = ? 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 = ? 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.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))

#▲	Time	Info
1	0.57 ms	SELECT c.Id FROM category c WHERE CONCAT(COALESCE(c.segment,''),'/',COALESCE(c.slug,'')) = :concated AND c.deleted_at IS NULL ORDER BY c.is_active=1 DESC Parameters: [`"concated" => "dovolenka/silvester"`] View formatted query View runnable query Explain query SELECT c.Id FROM category c WHERE CONCAT( COALESCE(c.segment, ''), '/', COALESCE(c.slug, '') ) = :concated AND c.deleted_at IS NULL ORDER BY c.is_active = 1 DESC SELECT c.Id FROM category c WHERE CONCAT(COALESCE(c.segment,''),'/',COALESCE(c.slug,'')) = 'dovolenka/silvester' AND c.deleted_at IS NULL ORDER BY c.is_active=1 DESC;
2	0.51 ms	SELECT t0.title AS title_1, t0.title_short AS title_short_2, t0.lft AS lft_3, t0.rgt AS rgt_4, t0.lvl AS lvl_5, t0.slug AS slug_6, t0.segment AS segment_7, t0.is_active AS is_active_8, t0.redirect_url AS redirect_url_9, t0.description AS description_10, t0.filter_range AS filter_range_11, t0.no_index AS no_index_12, t0.icon_image AS icon_image_13, t0.image AS image_14, t0.qb_rules AS qb_rules_15, t0.qb_rules_elastic AS qb_rules_elastic_16, t0.url_old AS url_old_17, t0.seo_year AS seo_year_18, t0.show_calendar_button AS show_calendar_button_19, t0.category_offer_order_by AS category_offer_order_by_20, t0.category_offer_after_sold_out AS category_offer_after_sold_out_21, t0.id AS id_22, t0.deleted_at AS deleted_at_23, t0.modified_at AS modified_at_24, t0.created_at AS created_at_25, t0.seo_title AS seo_title_26, t0.meta_description AS meta_description_27, t0.meta_image AS meta_image_28, t0.tree_root AS tree_root_29, t0.parent_id AS parent_id_30, t0.filter_category_id AS filter_category_id_31, t0.canonical_category_id AS canonical_category_id_32 FROM category t0 WHERE t0.id = ? AND ((t0.deleted_at IS NULL)) Parameters: [`5`] View formatted query View runnable query Explain query SELECT t0.title AS title_1, t0.title_short AS title_short_2, t0.lft AS lft_3, t0.rgt AS rgt_4, t0.lvl AS lvl_5, t0.slug AS slug_6, t0.segment AS segment_7, t0.is_active AS is_active_8, t0.redirect_url AS redirect_url_9, t0.description AS description_10, t0.filter_range AS filter_range_11, t0.no_index AS no_index_12, t0.icon_image AS icon_image_13, t0.image AS image_14, t0.qb_rules AS qb_rules_15, t0.qb_rules_elastic AS qb_rules_elastic_16, t0.url_old AS url_old_17, t0.seo_year AS seo_year_18, t0.show_calendar_button AS show_calendar_button_19, t0.category_offer_order_by AS category_offer_order_by_20, t0.category_offer_after_sold_out AS category_offer_after_sold_out_21, t0.id AS id_22, t0.deleted_at AS deleted_at_23, t0.modified_at AS modified_at_24, t0.created_at AS created_at_25, t0.seo_title AS seo_title_26, t0.meta_description AS meta_description_27, t0.meta_image AS meta_image_28, t0.tree_root AS tree_root_29, t0.parent_id AS parent_id_30, t0.filter_category_id AS filter_category_id_31, t0.canonical_category_id AS canonical_category_id_32 FROM category t0 WHERE t0.id = ? AND ( (t0.deleted_at IS NULL) ) SELECT t0.title AS title_1, t0.title_short AS title_short_2, t0.lft AS lft_3, t0.rgt AS rgt_4, t0.lvl AS lvl_5, t0.slug AS slug_6, t0.segment AS segment_7, t0.is_active AS is_active_8, t0.redirect_url AS redirect_url_9, t0.description AS description_10, t0.filter_range AS filter_range_11, t0.no_index AS no_index_12, t0.icon_image AS icon_image_13, t0.image AS image_14, t0.qb_rules AS qb_rules_15, t0.qb_rules_elastic AS qb_rules_elastic_16, t0.url_old AS url_old_17, t0.seo_year AS seo_year_18, t0.show_calendar_button AS show_calendar_button_19, t0.category_offer_order_by AS category_offer_order_by_20, t0.category_offer_after_sold_out AS category_offer_after_sold_out_21, t0.id AS id_22, t0.deleted_at AS deleted_at_23, t0.modified_at AS modified_at_24, t0.created_at AS created_at_25, t0.seo_title AS seo_title_26, t0.meta_description AS meta_description_27, t0.meta_image AS meta_image_28, t0.tree_root AS tree_root_29, t0.parent_id AS parent_id_30, t0.filter_category_id AS filter_category_id_31, t0.canonical_category_id AS canonical_category_id_32 FROM category t0 WHERE t0.id = 5 AND ((t0.deleted_at IS NULL));
3	0.45 ms	SELECT t0.position AS position_1, t0.id AS id_2, t0.deleted_at AS deleted_at_3, t0.modified_at AS modified_at_4, t0.created_at AS created_at_5, t0.tour_id AS tour_id_6, t0.tour_term_id AS tour_term_id_7, t0.category_id AS category_id_8 FROM category_offer t0 WHERE t0.category_id = ? AND ((t0.deleted_at IS NULL)) Parameters: [`5`] View formatted query View runnable query Explain query SELECT t0.position AS position_1, t0.id AS id_2, t0.deleted_at AS deleted_at_3, t0.modified_at AS modified_at_4, t0.created_at AS created_at_5, t0.tour_id AS tour_id_6, t0.tour_term_id AS tour_term_id_7, t0.category_id AS category_id_8 FROM category_offer t0 WHERE t0.category_id = ? AND ( (t0.deleted_at IS NULL) ) SELECT t0.position AS position_1, t0.id AS id_2, t0.deleted_at AS deleted_at_3, t0.modified_at AS modified_at_4, t0.created_at AS created_at_5, t0.tour_id AS tour_id_6, t0.tour_term_id AS tour_term_id_7, t0.category_id AS category_id_8 FROM category_offer t0 WHERE t0.category_id = 5 AND ((t0.deleted_at IS NULL));
4	0.43 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: [`4`] View formatted query View runnable query Explain query 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 = 4 AND ((t0.deleted_at IS NULL));
5	0.71 ms	SELECT c0_.is_active AS is_active_0, c0_.position AS position_1, c0_.id AS id_2, c0_.deleted_at AS deleted_at_3, c0_.modified_at AS modified_at_4, c0_.created_at AS created_at_5, t1_.alternative_title AS alternative_title_6, t1_.slug AS slug_7, t1_.description AS description_8, t1_.icon AS icon_9, t1_.has_pill AS has_pill_10, t1_.pill_title AS pill_title_11, t1_.pill_tooltip AS pill_tooltip_12, t1_.pill_color AS pill_color_13, t1_.position AS position_14, t1_.is_active AS is_active_15, t1_.id AS id_16, t1_.title AS title_17, t1_.deleted_at AS deleted_at_18, t1_.modified_at AS modified_at_19, t1_.created_at AS created_at_20, c0_.category_id AS category_id_21, c0_.tour_attribute_id AS tour_attribute_id_22, t1_.tour_attribute_category_id AS tour_attribute_category_id_23 FROM category_tour_attribute_filter c0_ LEFT JOIN tour_attribute t1_ ON c0_.tour_attribute_id = t1_.id AND (t1_.deleted_at IS NULL) WHERE (c0_.category_id = ?) AND (c0_.deleted_at IS NULL) ORDER BY c0_.position ASC Parameters: [`5`] View formatted query View runnable query Explain query SELECT c0_.is_active AS is_active_0, c0_.position AS position_1, c0_.id AS id_2, c0_.deleted_at AS deleted_at_3, c0_.modified_at AS modified_at_4, c0_.created_at AS created_at_5, t1_.alternative_title AS alternative_title_6, t1_.slug AS slug_7, t1_.description AS description_8, t1_.icon AS icon_9, t1_.has_pill AS has_pill_10, t1_.pill_title AS pill_title_11, t1_.pill_tooltip AS pill_tooltip_12, t1_.pill_color AS pill_color_13, t1_.position AS position_14, t1_.is_active AS is_active_15, t1_.id AS id_16, t1_.title AS title_17, t1_.deleted_at AS deleted_at_18, t1_.modified_at AS modified_at_19, t1_.created_at AS created_at_20, c0_.category_id AS category_id_21, c0_.tour_attribute_id AS tour_attribute_id_22, t1_.tour_attribute_category_id AS tour_attribute_category_id_23 FROM category_tour_attribute_filter c0_ LEFT JOIN tour_attribute t1_ ON c0_.tour_attribute_id = t1_.id AND (t1_.deleted_at IS NULL) WHERE (c0_.category_id = ?) AND (c0_.deleted_at IS NULL) ORDER BY c0_.position ASC SELECT c0_.is_active AS is_active_0, c0_.position AS position_1, c0_.id AS id_2, c0_.deleted_at AS deleted_at_3, c0_.modified_at AS modified_at_4, c0_.created_at AS created_at_5, t1_.alternative_title AS alternative_title_6, t1_.slug AS slug_7, t1_.description AS description_8, t1_.icon AS icon_9, t1_.has_pill AS has_pill_10, t1_.pill_title AS pill_title_11, t1_.pill_tooltip AS pill_tooltip_12, t1_.pill_color AS pill_color_13, t1_.position AS position_14, t1_.is_active AS is_active_15, t1_.id AS id_16, t1_.title AS title_17, t1_.deleted_at AS deleted_at_18, t1_.modified_at AS modified_at_19, t1_.created_at AS created_at_20, c0_.category_id AS category_id_21, c0_.tour_attribute_id AS tour_attribute_id_22, t1_.tour_attribute_category_id AS tour_attribute_category_id_23 FROM category_tour_attribute_filter c0_ LEFT JOIN tour_attribute t1_ ON c0_.tour_attribute_id = t1_.id AND (t1_.deleted_at IS NULL) WHERE (c0_.category_id = 5) AND (c0_.deleted_at IS NULL) ORDER BY c0_.position ASC;
6	0.97 ms	SELECT c0_.is_active AS is_active_0, c0_.position AS position_1, c0_.id AS id_2, c0_.deleted_at AS deleted_at_3, c0_.modified_at AS modified_at_4, c0_.created_at AS created_at_5, t1_.alternative_title AS alternative_title_6, t1_.slug AS slug_7, t1_.description AS description_8, t1_.icon AS icon_9, t1_.has_pill AS has_pill_10, t1_.pill_title AS pill_title_11, t1_.pill_tooltip AS pill_tooltip_12, t1_.pill_color AS pill_color_13, t1_.position AS position_14, t1_.is_active AS is_active_15, t1_.id AS id_16, t1_.title AS title_17, t1_.deleted_at AS deleted_at_18, t1_.modified_at AS modified_at_19, t1_.created_at AS created_at_20, c0_.category_id AS category_id_21, c0_.tour_attribute_id AS tour_attribute_id_22, t1_.tour_attribute_category_id AS tour_attribute_category_id_23 FROM category_tour_attribute_filter c0_ LEFT JOIN tour_attribute t1_ ON c0_.tour_attribute_id = t1_.id AND (t1_.deleted_at IS NULL) WHERE (c0_.category_id = ?) AND (c0_.deleted_at IS NULL) ORDER BY c0_.position ASC Parameters: [`408`] View formatted query View runnable query Explain query SELECT c0_.is_active AS is_active_0, c0_.position AS position_1, c0_.id AS id_2, c0_.deleted_at AS deleted_at_3, c0_.modified_at AS modified_at_4, c0_.created_at AS created_at_5, t1_.alternative_title AS alternative_title_6, t1_.slug AS slug_7, t1_.description AS description_8, t1_.icon AS icon_9, t1_.has_pill AS has_pill_10, t1_.pill_title AS pill_title_11, t1_.pill_tooltip AS pill_tooltip_12, t1_.pill_color AS pill_color_13, t1_.position AS position_14, t1_.is_active AS is_active_15, t1_.id AS id_16, t1_.title AS title_17, t1_.deleted_at AS deleted_at_18, t1_.modified_at AS modified_at_19, t1_.created_at AS created_at_20, c0_.category_id AS category_id_21, c0_.tour_attribute_id AS tour_attribute_id_22, t1_.tour_attribute_category_id AS tour_attribute_category_id_23 FROM category_tour_attribute_filter c0_ LEFT JOIN tour_attribute t1_ ON c0_.tour_attribute_id = t1_.id AND (t1_.deleted_at IS NULL) WHERE (c0_.category_id = ?) AND (c0_.deleted_at IS NULL) ORDER BY c0_.position ASC SELECT c0_.is_active AS is_active_0, c0_.position AS position_1, c0_.id AS id_2, c0_.deleted_at AS deleted_at_3, c0_.modified_at AS modified_at_4, c0_.created_at AS created_at_5, t1_.alternative_title AS alternative_title_6, t1_.slug AS slug_7, t1_.description AS description_8, t1_.icon AS icon_9, t1_.has_pill AS has_pill_10, t1_.pill_title AS pill_title_11, t1_.pill_tooltip AS pill_tooltip_12, t1_.pill_color AS pill_color_13, t1_.position AS position_14, t1_.is_active AS is_active_15, t1_.id AS id_16, t1_.title AS title_17, t1_.deleted_at AS deleted_at_18, t1_.modified_at AS modified_at_19, t1_.created_at AS created_at_20, c0_.category_id AS category_id_21, c0_.tour_attribute_id AS tour_attribute_id_22, t1_.tour_attribute_category_id AS tour_attribute_category_id_23 FROM category_tour_attribute_filter c0_ LEFT JOIN tour_attribute t1_ ON c0_.tour_attribute_id = t1_.id AND (t1_.deleted_at IS NULL) WHERE (c0_.category_id = 408) AND (c0_.deleted_at IS NULL) ORDER BY c0_.position ASC;
7	1.18 ms	SELECT t0.alternative_title AS alternative_title_1, t0.slug AS slug_2, t0.description AS description_3, t0.icon AS icon_4, t0.has_pill AS has_pill_5, t0.pill_title AS pill_title_6, t0.pill_tooltip AS pill_tooltip_7, t0.pill_color AS pill_color_8, t0.position AS position_9, t0.is_active AS is_active_10, t0.id AS id_11, t0.title AS title_12, t0.deleted_at AS deleted_at_13, t0.modified_at AS modified_at_14, t0.created_at AS created_at_15, t0.tour_attribute_category_id AS tour_attribute_category_id_16 FROM tour_attribute t0 WHERE t0.tour_attribute_category_id = ? AND ((t0.deleted_at IS NULL)) Parameters: [`11`] View formatted query View runnable query Explain query SELECT t0.alternative_title AS alternative_title_1, t0.slug AS slug_2, t0.description AS description_3, t0.icon AS icon_4, t0.has_pill AS has_pill_5, t0.pill_title AS pill_title_6, t0.pill_tooltip AS pill_tooltip_7, t0.pill_color AS pill_color_8, t0.position AS position_9, t0.is_active AS is_active_10, t0.id AS id_11, t0.title AS title_12, t0.deleted_at AS deleted_at_13, t0.modified_at AS modified_at_14, t0.created_at AS created_at_15, t0.tour_attribute_category_id AS tour_attribute_category_id_16 FROM tour_attribute t0 WHERE t0.tour_attribute_category_id = ? AND ( (t0.deleted_at IS NULL) ) SELECT t0.alternative_title AS alternative_title_1, t0.slug AS slug_2, t0.description AS description_3, t0.icon AS icon_4, t0.has_pill AS has_pill_5, t0.pill_title AS pill_title_6, t0.pill_tooltip AS pill_tooltip_7, t0.pill_color AS pill_color_8, t0.position AS position_9, t0.is_active AS is_active_10, t0.id AS id_11, t0.title AS title_12, t0.deleted_at AS deleted_at_13, t0.modified_at AS modified_at_14, t0.created_at AS created_at_15, t0.tour_attribute_category_id AS tour_attribute_category_id_16 FROM tour_attribute t0 WHERE t0.tour_attribute_category_id = 11 AND ((t0.deleted_at IS NULL));
8	0.66 ms	SELECT t0.alternative_title AS alternative_title_1, t0.slug AS slug_2, t0.description AS description_3, t0.icon AS icon_4, t0.has_pill AS has_pill_5, t0.pill_title AS pill_title_6, t0.pill_tooltip AS pill_tooltip_7, t0.pill_color AS pill_color_8, t0.position AS position_9, t0.is_active AS is_active_10, t0.id AS id_11, t0.title AS title_12, t0.deleted_at AS deleted_at_13, t0.modified_at AS modified_at_14, t0.created_at AS created_at_15, t0.tour_attribute_category_id AS tour_attribute_category_id_16 FROM tour_attribute t0 WHERE t0.tour_attribute_category_id = ? AND ((t0.deleted_at IS NULL)) Parameters: [`16`] View formatted query View runnable query Explain query SELECT t0.alternative_title AS alternative_title_1, t0.slug AS slug_2, t0.description AS description_3, t0.icon AS icon_4, t0.has_pill AS has_pill_5, t0.pill_title AS pill_title_6, t0.pill_tooltip AS pill_tooltip_7, t0.pill_color AS pill_color_8, t0.position AS position_9, t0.is_active AS is_active_10, t0.id AS id_11, t0.title AS title_12, t0.deleted_at AS deleted_at_13, t0.modified_at AS modified_at_14, t0.created_at AS created_at_15, t0.tour_attribute_category_id AS tour_attribute_category_id_16 FROM tour_attribute t0 WHERE t0.tour_attribute_category_id = ? AND ( (t0.deleted_at IS NULL) ) SELECT t0.alternative_title AS alternative_title_1, t0.slug AS slug_2, t0.description AS description_3, t0.icon AS icon_4, t0.has_pill AS has_pill_5, t0.pill_title AS pill_title_6, t0.pill_tooltip AS pill_tooltip_7, t0.pill_color AS pill_color_8, t0.position AS position_9, t0.is_active AS is_active_10, t0.id AS id_11, t0.title AS title_12, t0.deleted_at AS deleted_at_13, t0.modified_at AS modified_at_14, t0.created_at AS created_at_15, t0.tour_attribute_category_id AS tour_attribute_category_id_16 FROM tour_attribute t0 WHERE t0.tour_attribute_category_id = 16 AND ((t0.deleted_at IS NULL));
9	0.52 ms	SELECT r0_.slug AS slug_0, r0_.is_active AS is_active_1, r0_.id AS id_2, r0_.title AS title_3, r0_.deleted_at AS deleted_at_4, r0_.modified_at AS modified_at_5, r0_.created_at AS created_at_6 FROM region r0_ WHERE (r0_.deleted_at IS NULL) Parameters: [] View formatted query View runnable query Explain query SELECT r0_.slug AS slug_0, r0_.is_active AS is_active_1, r0_.id AS id_2, r0_.title AS title_3, r0_.deleted_at AS deleted_at_4, r0_.modified_at AS modified_at_5, r0_.created_at AS created_at_6 FROM region r0_ WHERE (r0_.deleted_at IS NULL) SELECT r0_.slug AS slug_0, r0_.is_active AS is_active_1, r0_.id AS id_2, r0_.title AS title_3, r0_.deleted_at AS deleted_at_4, r0_.modified_at AS modified_at_5, r0_.created_at AS created_at_6 FROM region r0_ WHERE (r0_.deleted_at IS NULL);
10	0.54 ms	SELECT c0_.slug AS slug_0, c0_.title_instrumental AS title_instrumental_1, c0_.position AS position_2, c0_.id AS id_3, c0_.title AS title_4, c0_.deleted_at AS deleted_at_5, c0_.modified_at AS modified_at_6, c0_.created_at AS created_at_7, c0_.tour_attribute_id AS tour_attribute_id_8 FROM c_food c0_ WHERE (c0_.deleted_at IS NULL) Parameters: [] View formatted query View runnable query Explain query SELECT c0_.slug AS slug_0, c0_.title_instrumental AS title_instrumental_1, c0_.position AS position_2, c0_.id AS id_3, c0_.title AS title_4, c0_.deleted_at AS deleted_at_5, c0_.modified_at AS modified_at_6, c0_.created_at AS created_at_7, c0_.tour_attribute_id AS tour_attribute_id_8 FROM c_food c0_ WHERE (c0_.deleted_at IS NULL) SELECT c0_.slug AS slug_0, c0_.title_instrumental AS title_instrumental_1, c0_.position AS position_2, c0_.id AS id_3, c0_.title AS title_4, c0_.deleted_at AS deleted_at_5, c0_.modified_at AS modified_at_6, c0_.created_at AS created_at_7, c0_.tour_attribute_id AS tour_attribute_id_8 FROM c_food c0_ WHERE (c0_.deleted_at IS NULL);
11	0.54 ms	SELECT c0_.slug AS slug_0, c0_.position AS position_1, c0_.id AS id_2, c0_.title AS title_3, c0_.deleted_at AS deleted_at_4, c0_.modified_at AS modified_at_5, c0_.created_at AS created_at_6 FROM c_transport c0_ WHERE (c0_.deleted_at IS NULL) Parameters: [] View formatted query View runnable query Explain query SELECT c0_.slug AS slug_0, c0_.position AS position_1, c0_.id AS id_2, c0_.title AS title_3, c0_.deleted_at AS deleted_at_4, c0_.modified_at AS modified_at_5, c0_.created_at AS created_at_6 FROM c_transport c0_ WHERE (c0_.deleted_at IS NULL) SELECT c0_.slug AS slug_0, c0_.position AS position_1, c0_.id AS id_2, c0_.title AS title_3, c0_.deleted_at AS deleted_at_4, c0_.modified_at AS modified_at_5, c0_.created_at AS created_at_6 FROM c_transport c0_ WHERE (c0_.deleted_at IS NULL);
12	9.63 ms	SELECT d0_.title AS title_0, d0_.code AS code_1, d0_.lft AS lft_2, d0_.rgt AS rgt_3, d0_.lvl AS lvl_4, d0_.slug AS slug_5, d0_.alternative_title AS alternative_title_6, d0_.is_active AS is_active_7, d0_.description AS description_8, d0_.capital_city AS capital_city_9, d0_.time_shift AS time_shift_10, d0_.must_visit_radius AS must_visit_radius_11, d0_.title_lokal AS title_lokal_12, d0_.title_genitiv AS title_genitiv_13, d0_.title_in_search AS title_in_search_14, d0_.district_id AS district_id_15, d0_.location_id AS location_id_16, d0_.images_season AS images_season_17, d0_.image AS image_18, d0_.popular_image AS popular_image_19, d0_.image_alt AS image_alt_20, d0_.id AS id_21, d0_.deleted_at AS deleted_at_22, d0_.modified_at AS modified_at_23, d0_.created_at AS created_at_24, d0_.latitude AS latitude_25, d0_.longitude AS longitude_26, d0_.tree_root AS tree_root_27, d0_.parent_id AS parent_id_28, d0_.currency_id AS currency_id_29, d0_.continent_id AS continent_id_30 FROM destination d0_ WHERE (d0_.deleted_at IS NULL) Parameters: [] View formatted query View runnable query Explain query SELECT d0_.title AS title_0, d0_.code AS code_1, d0_.lft AS lft_2, d0_.rgt AS rgt_3, d0_.lvl AS lvl_4, d0_.slug AS slug_5, d0_.alternative_title AS alternative_title_6, d0_.is_active AS is_active_7, d0_.description AS description_8, d0_.capital_city AS capital_city_9, d0_.time_shift AS time_shift_10, d0_.must_visit_radius AS must_visit_radius_11, d0_.title_lokal AS title_lokal_12, d0_.title_genitiv AS title_genitiv_13, d0_.title_in_search AS title_in_search_14, d0_.district_id AS district_id_15, d0_.location_id AS location_id_16, d0_.images_season AS images_season_17, d0_.image AS image_18, d0_.popular_image AS popular_image_19, d0_.image_alt AS image_alt_20, d0_.id AS id_21, d0_.deleted_at AS deleted_at_22, d0_.modified_at AS modified_at_23, d0_.created_at AS created_at_24, d0_.latitude AS latitude_25, d0_.longitude AS longitude_26, d0_.tree_root AS tree_root_27, d0_.parent_id AS parent_id_28, d0_.currency_id AS currency_id_29, d0_.continent_id AS continent_id_30 FROM destination d0_ WHERE (d0_.deleted_at IS NULL) SELECT d0_.title AS title_0, d0_.code AS code_1, d0_.lft AS lft_2, d0_.rgt AS rgt_3, d0_.lvl AS lvl_4, d0_.slug AS slug_5, d0_.alternative_title AS alternative_title_6, d0_.is_active AS is_active_7, d0_.description AS description_8, d0_.capital_city AS capital_city_9, d0_.time_shift AS time_shift_10, d0_.must_visit_radius AS must_visit_radius_11, d0_.title_lokal AS title_lokal_12, d0_.title_genitiv AS title_genitiv_13, d0_.title_in_search AS title_in_search_14, d0_.district_id AS district_id_15, d0_.location_id AS location_id_16, d0_.images_season AS images_season_17, d0_.image AS image_18, d0_.popular_image AS popular_image_19, d0_.image_alt AS image_alt_20, d0_.id AS id_21, d0_.deleted_at AS deleted_at_22, d0_.modified_at AS modified_at_23, d0_.created_at AS created_at_24, d0_.latitude AS latitude_25, d0_.longitude AS longitude_26, d0_.tree_root AS tree_root_27, d0_.parent_id AS parent_id_28, d0_.currency_id AS currency_id_29, d0_.continent_id AS continent_id_30 FROM destination d0_ WHERE (d0_.deleted_at IS NULL);
13	0.85 ms	SELECT c0_.is_active AS is_active_0, c0_.position AS position_1, c0_.id AS id_2, c0_.deleted_at AS deleted_at_3, c0_.modified_at AS modified_at_4, c0_.created_at AS created_at_5, t1_.alternative_title AS alternative_title_6, t1_.slug AS slug_7, t1_.description AS description_8, t1_.icon AS icon_9, t1_.has_pill AS has_pill_10, t1_.pill_title AS pill_title_11, t1_.pill_tooltip AS pill_tooltip_12, t1_.pill_color AS pill_color_13, t1_.position AS position_14, t1_.is_active AS is_active_15, t1_.id AS id_16, t1_.title AS title_17, t1_.deleted_at AS deleted_at_18, t1_.modified_at AS modified_at_19, t1_.created_at AS created_at_20, c0_.category_id AS category_id_21, c0_.tour_attribute_id AS tour_attribute_id_22, t1_.tour_attribute_category_id AS tour_attribute_category_id_23 FROM category_tour_attribute_filter c0_ LEFT JOIN tour_attribute t1_ ON c0_.tour_attribute_id = t1_.id AND (t1_.deleted_at IS NULL) WHERE (c0_.category_id = ?) AND (c0_.deleted_at IS NULL) ORDER BY c0_.position ASC Parameters: [`5`] View formatted query View runnable query Explain query SELECT c0_.is_active AS is_active_0, c0_.position AS position_1, c0_.id AS id_2, c0_.deleted_at AS deleted_at_3, c0_.modified_at AS modified_at_4, c0_.created_at AS created_at_5, t1_.alternative_title AS alternative_title_6, t1_.slug AS slug_7, t1_.description AS description_8, t1_.icon AS icon_9, t1_.has_pill AS has_pill_10, t1_.pill_title AS pill_title_11, t1_.pill_tooltip AS pill_tooltip_12, t1_.pill_color AS pill_color_13, t1_.position AS position_14, t1_.is_active AS is_active_15, t1_.id AS id_16, t1_.title AS title_17, t1_.deleted_at AS deleted_at_18, t1_.modified_at AS modified_at_19, t1_.created_at AS created_at_20, c0_.category_id AS category_id_21, c0_.tour_attribute_id AS tour_attribute_id_22, t1_.tour_attribute_category_id AS tour_attribute_category_id_23 FROM category_tour_attribute_filter c0_ LEFT JOIN tour_attribute t1_ ON c0_.tour_attribute_id = t1_.id AND (t1_.deleted_at IS NULL) WHERE (c0_.category_id = ?) AND (c0_.deleted_at IS NULL) ORDER BY c0_.position ASC SELECT c0_.is_active AS is_active_0, c0_.position AS position_1, c0_.id AS id_2, c0_.deleted_at AS deleted_at_3, c0_.modified_at AS modified_at_4, c0_.created_at AS created_at_5, t1_.alternative_title AS alternative_title_6, t1_.slug AS slug_7, t1_.description AS description_8, t1_.icon AS icon_9, t1_.has_pill AS has_pill_10, t1_.pill_title AS pill_title_11, t1_.pill_tooltip AS pill_tooltip_12, t1_.pill_color AS pill_color_13, t1_.position AS position_14, t1_.is_active AS is_active_15, t1_.id AS id_16, t1_.title AS title_17, t1_.deleted_at AS deleted_at_18, t1_.modified_at AS modified_at_19, t1_.created_at AS created_at_20, c0_.category_id AS category_id_21, c0_.tour_attribute_id AS tour_attribute_id_22, t1_.tour_attribute_category_id AS tour_attribute_category_id_23 FROM category_tour_attribute_filter c0_ LEFT JOIN tour_attribute t1_ ON c0_.tour_attribute_id = t1_.id AND (t1_.deleted_at IS NULL) WHERE (c0_.category_id = 5) AND (c0_.deleted_at IS NULL) ORDER BY c0_.position ASC;
14	1.03 ms	SELECT c0_.is_active AS is_active_0, c0_.position AS position_1, c0_.id AS id_2, c0_.deleted_at AS deleted_at_3, c0_.modified_at AS modified_at_4, c0_.created_at AS created_at_5, t1_.alternative_title AS alternative_title_6, t1_.slug AS slug_7, t1_.description AS description_8, t1_.icon AS icon_9, t1_.has_pill AS has_pill_10, t1_.pill_title AS pill_title_11, t1_.pill_tooltip AS pill_tooltip_12, t1_.pill_color AS pill_color_13, t1_.position AS position_14, t1_.is_active AS is_active_15, t1_.id AS id_16, t1_.title AS title_17, t1_.deleted_at AS deleted_at_18, t1_.modified_at AS modified_at_19, t1_.created_at AS created_at_20, c0_.category_id AS category_id_21, c0_.tour_attribute_id AS tour_attribute_id_22, t1_.tour_attribute_category_id AS tour_attribute_category_id_23 FROM category_tour_attribute_filter c0_ LEFT JOIN tour_attribute t1_ ON c0_.tour_attribute_id = t1_.id AND (t1_.deleted_at IS NULL) WHERE (c0_.category_id = ?) AND (c0_.deleted_at IS NULL) ORDER BY c0_.position ASC Parameters: [`408`] View formatted query View runnable query Explain query SELECT c0_.is_active AS is_active_0, c0_.position AS position_1, c0_.id AS id_2, c0_.deleted_at AS deleted_at_3, c0_.modified_at AS modified_at_4, c0_.created_at AS created_at_5, t1_.alternative_title AS alternative_title_6, t1_.slug AS slug_7, t1_.description AS description_8, t1_.icon AS icon_9, t1_.has_pill AS has_pill_10, t1_.pill_title AS pill_title_11, t1_.pill_tooltip AS pill_tooltip_12, t1_.pill_color AS pill_color_13, t1_.position AS position_14, t1_.is_active AS is_active_15, t1_.id AS id_16, t1_.title AS title_17, t1_.deleted_at AS deleted_at_18, t1_.modified_at AS modified_at_19, t1_.created_at AS created_at_20, c0_.category_id AS category_id_21, c0_.tour_attribute_id AS tour_attribute_id_22, t1_.tour_attribute_category_id AS tour_attribute_category_id_23 FROM category_tour_attribute_filter c0_ LEFT JOIN tour_attribute t1_ ON c0_.tour_attribute_id = t1_.id AND (t1_.deleted_at IS NULL) WHERE (c0_.category_id = ?) AND (c0_.deleted_at IS NULL) ORDER BY c0_.position ASC SELECT c0_.is_active AS is_active_0, c0_.position AS position_1, c0_.id AS id_2, c0_.deleted_at AS deleted_at_3, c0_.modified_at AS modified_at_4, c0_.created_at AS created_at_5, t1_.alternative_title AS alternative_title_6, t1_.slug AS slug_7, t1_.description AS description_8, t1_.icon AS icon_9, t1_.has_pill AS has_pill_10, t1_.pill_title AS pill_title_11, t1_.pill_tooltip AS pill_tooltip_12, t1_.pill_color AS pill_color_13, t1_.position AS position_14, t1_.is_active AS is_active_15, t1_.id AS id_16, t1_.title AS title_17, t1_.deleted_at AS deleted_at_18, t1_.modified_at AS modified_at_19, t1_.created_at AS created_at_20, c0_.category_id AS category_id_21, c0_.tour_attribute_id AS tour_attribute_id_22, t1_.tour_attribute_category_id AS tour_attribute_category_id_23 FROM category_tour_attribute_filter c0_ LEFT JOIN tour_attribute t1_ ON c0_.tour_attribute_id = t1_.id AND (t1_.deleted_at IS NULL) WHERE (c0_.category_id = 408) AND (c0_.deleted_at IS NULL) ORDER BY c0_.position ASC;
15	0.58 ms	SELECT t0.position AS position_1, t0.id AS id_2, t0.deleted_at AS deleted_at_3, t0.modified_at AS modified_at_4, t0.created_at AS created_at_5, t0.category_id AS category_id_6, t0.destination_id AS destination_id_7, t0.parent_best_destination_id AS parent_best_destination_id_8 FROM category_best_destination t0 WHERE t0.category_id = ? AND ((t0.deleted_at IS NULL)) ORDER BY t0.position ASC Parameters: [`5`] View formatted query View runnable query Explain query SELECT t0.position AS position_1, t0.id AS id_2, t0.deleted_at AS deleted_at_3, t0.modified_at AS modified_at_4, t0.created_at AS created_at_5, t0.category_id AS category_id_6, t0.destination_id AS destination_id_7, t0.parent_best_destination_id AS parent_best_destination_id_8 FROM category_best_destination t0 WHERE t0.category_id = ? AND ( (t0.deleted_at IS NULL) ) ORDER BY t0.position ASC SELECT t0.position AS position_1, t0.id AS id_2, t0.deleted_at AS deleted_at_3, t0.modified_at AS modified_at_4, t0.created_at AS created_at_5, t0.category_id AS category_id_6, t0.destination_id AS destination_id_7, t0.parent_best_destination_id AS parent_best_destination_id_8 FROM category_best_destination t0 WHERE t0.category_id = 5 AND ((t0.deleted_at IS NULL)) ORDER BY t0.position ASC;
16	0.77 ms	SELECT t0.title AS title_1, t0.title_short AS title_short_2, t0.lft AS lft_3, t0.rgt AS rgt_4, t0.lvl AS lvl_5, t0.slug AS slug_6, t0.segment AS segment_7, t0.is_active AS is_active_8, t0.redirect_url AS redirect_url_9, t0.description AS description_10, t0.filter_range AS filter_range_11, t0.no_index AS no_index_12, t0.icon_image AS icon_image_13, t0.image AS image_14, t0.qb_rules AS qb_rules_15, t0.qb_rules_elastic AS qb_rules_elastic_16, t0.url_old AS url_old_17, t0.seo_year AS seo_year_18, t0.show_calendar_button AS show_calendar_button_19, t0.category_offer_order_by AS category_offer_order_by_20, t0.category_offer_after_sold_out AS category_offer_after_sold_out_21, t0.id AS id_22, t0.deleted_at AS deleted_at_23, t0.modified_at AS modified_at_24, t0.created_at AS created_at_25, t0.seo_title AS seo_title_26, t0.meta_description AS meta_description_27, t0.meta_image AS meta_image_28, t0.tree_root AS tree_root_29, t0.parent_id AS parent_id_30, t0.filter_category_id AS filter_category_id_31, t0.canonical_category_id AS canonical_category_id_32 FROM category t0 WHERE t0.parent_id = ? AND ((t0.deleted_at IS NULL)) Parameters: [`5`] View formatted query View runnable query Explain query SELECT t0.title AS title_1, t0.title_short AS title_short_2, t0.lft AS lft_3, t0.rgt AS rgt_4, t0.lvl AS lvl_5, t0.slug AS slug_6, t0.segment AS segment_7, t0.is_active AS is_active_8, t0.redirect_url AS redirect_url_9, t0.description AS description_10, t0.filter_range AS filter_range_11, t0.no_index AS no_index_12, t0.icon_image AS icon_image_13, t0.image AS image_14, t0.qb_rules AS qb_rules_15, t0.qb_rules_elastic AS qb_rules_elastic_16, t0.url_old AS url_old_17, t0.seo_year AS seo_year_18, t0.show_calendar_button AS show_calendar_button_19, t0.category_offer_order_by AS category_offer_order_by_20, t0.category_offer_after_sold_out AS category_offer_after_sold_out_21, t0.id AS id_22, t0.deleted_at AS deleted_at_23, t0.modified_at AS modified_at_24, t0.created_at AS created_at_25, t0.seo_title AS seo_title_26, t0.meta_description AS meta_description_27, t0.meta_image AS meta_image_28, t0.tree_root AS tree_root_29, t0.parent_id AS parent_id_30, t0.filter_category_id AS filter_category_id_31, t0.canonical_category_id AS canonical_category_id_32 FROM category t0 WHERE t0.parent_id = ? AND ( (t0.deleted_at IS NULL) ) SELECT t0.title AS title_1, t0.title_short AS title_short_2, t0.lft AS lft_3, t0.rgt AS rgt_4, t0.lvl AS lvl_5, t0.slug AS slug_6, t0.segment AS segment_7, t0.is_active AS is_active_8, t0.redirect_url AS redirect_url_9, t0.description AS description_10, t0.filter_range AS filter_range_11, t0.no_index AS no_index_12, t0.icon_image AS icon_image_13, t0.image AS image_14, t0.qb_rules AS qb_rules_15, t0.qb_rules_elastic AS qb_rules_elastic_16, t0.url_old AS url_old_17, t0.seo_year AS seo_year_18, t0.show_calendar_button AS show_calendar_button_19, t0.category_offer_order_by AS category_offer_order_by_20, t0.category_offer_after_sold_out AS category_offer_after_sold_out_21, t0.id AS id_22, t0.deleted_at AS deleted_at_23, t0.modified_at AS modified_at_24, t0.created_at AS created_at_25, t0.seo_title AS seo_title_26, t0.meta_description AS meta_description_27, t0.meta_image AS meta_image_28, t0.tree_root AS tree_root_29, t0.parent_id AS parent_id_30, t0.filter_category_id AS filter_category_id_31, t0.canonical_category_id AS canonical_category_id_32 FROM category t0 WHERE t0.parent_id = 5 AND ((t0.deleted_at IS NULL));
17	0.43 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.alias = ? AND ((t0.deleted_at IS NULL)) LIMIT 1 Parameters: [`"tours_count"`] View formatted query View runnable query Explain query 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.alias = ? AND ( (t0.deleted_at IS NULL) ) LIMIT 1 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.alias = 'tours_count' AND ((t0.deleted_at IS NULL)) LIMIT 1;
18	0.73 ms	SELECT c.Id FROM category c WHERE CONCAT(COALESCE(c.segment,''),'/',COALESCE(c.slug,'')) = :concated AND c.deleted_at IS NULL ORDER BY c.is_active=1 DESC Parameters: [`"concated" => "dovolenka/silvester-exotika"`] View formatted query View runnable query Explain query SELECT c.Id FROM category c WHERE CONCAT( COALESCE(c.segment, ''), '/', COALESCE(c.slug, '') ) = :concated AND c.deleted_at IS NULL ORDER BY c.is_active = 1 DESC SELECT c.Id FROM category c WHERE CONCAT(COALESCE(c.segment,''),'/',COALESCE(c.slug,'')) = 'dovolenka/silvester-exotika' AND c.deleted_at IS NULL ORDER BY c.is_active=1 DESC;
19	0.65 ms	SELECT c0_.is_active AS is_active_0, c0_.position AS position_1, c0_.id AS id_2, c0_.deleted_at AS deleted_at_3, c0_.modified_at AS modified_at_4, c0_.created_at AS created_at_5, t1_.alternative_title AS alternative_title_6, t1_.slug AS slug_7, t1_.description AS description_8, t1_.icon AS icon_9, t1_.has_pill AS has_pill_10, t1_.pill_title AS pill_title_11, t1_.pill_tooltip AS pill_tooltip_12, t1_.pill_color AS pill_color_13, t1_.position AS position_14, t1_.is_active AS is_active_15, t1_.id AS id_16, t1_.title AS title_17, t1_.deleted_at AS deleted_at_18, t1_.modified_at AS modified_at_19, t1_.created_at AS created_at_20, c0_.category_id AS category_id_21, c0_.tour_attribute_id AS tour_attribute_id_22, t1_.tour_attribute_category_id AS tour_attribute_category_id_23 FROM category_tour_attribute_filter c0_ LEFT JOIN tour_attribute t1_ ON c0_.tour_attribute_id = t1_.id AND (t1_.deleted_at IS NULL) WHERE (c0_.category_id = ?) AND (c0_.deleted_at IS NULL) ORDER BY c0_.position ASC Parameters: [`7`] View formatted query View runnable query Explain query SELECT c0_.is_active AS is_active_0, c0_.position AS position_1, c0_.id AS id_2, c0_.deleted_at AS deleted_at_3, c0_.modified_at AS modified_at_4, c0_.created_at AS created_at_5, t1_.alternative_title AS alternative_title_6, t1_.slug AS slug_7, t1_.description AS description_8, t1_.icon AS icon_9, t1_.has_pill AS has_pill_10, t1_.pill_title AS pill_title_11, t1_.pill_tooltip AS pill_tooltip_12, t1_.pill_color AS pill_color_13, t1_.position AS position_14, t1_.is_active AS is_active_15, t1_.id AS id_16, t1_.title AS title_17, t1_.deleted_at AS deleted_at_18, t1_.modified_at AS modified_at_19, t1_.created_at AS created_at_20, c0_.category_id AS category_id_21, c0_.tour_attribute_id AS tour_attribute_id_22, t1_.tour_attribute_category_id AS tour_attribute_category_id_23 FROM category_tour_attribute_filter c0_ LEFT JOIN tour_attribute t1_ ON c0_.tour_attribute_id = t1_.id AND (t1_.deleted_at IS NULL) WHERE (c0_.category_id = ?) AND (c0_.deleted_at IS NULL) ORDER BY c0_.position ASC SELECT c0_.is_active AS is_active_0, c0_.position AS position_1, c0_.id AS id_2, c0_.deleted_at AS deleted_at_3, c0_.modified_at AS modified_at_4, c0_.created_at AS created_at_5, t1_.alternative_title AS alternative_title_6, t1_.slug AS slug_7, t1_.description AS description_8, t1_.icon AS icon_9, t1_.has_pill AS has_pill_10, t1_.pill_title AS pill_title_11, t1_.pill_tooltip AS pill_tooltip_12, t1_.pill_color AS pill_color_13, t1_.position AS position_14, t1_.is_active AS is_active_15, t1_.id AS id_16, t1_.title AS title_17, t1_.deleted_at AS deleted_at_18, t1_.modified_at AS modified_at_19, t1_.created_at AS created_at_20, c0_.category_id AS category_id_21, c0_.tour_attribute_id AS tour_attribute_id_22, t1_.tour_attribute_category_id AS tour_attribute_category_id_23 FROM category_tour_attribute_filter c0_ LEFT JOIN tour_attribute t1_ ON c0_.tour_attribute_id = t1_.id AND (t1_.deleted_at IS NULL) WHERE (c0_.category_id = 7) AND (c0_.deleted_at IS NULL) ORDER BY c0_.position ASC;
20	0.92 ms	SELECT c0_.is_active AS is_active_0, c0_.position AS position_1, c0_.id AS id_2, c0_.deleted_at AS deleted_at_3, c0_.modified_at AS modified_at_4, c0_.created_at AS created_at_5, t1_.alternative_title AS alternative_title_6, t1_.slug AS slug_7, t1_.description AS description_8, t1_.icon AS icon_9, t1_.has_pill AS has_pill_10, t1_.pill_title AS pill_title_11, t1_.pill_tooltip AS pill_tooltip_12, t1_.pill_color AS pill_color_13, t1_.position AS position_14, t1_.is_active AS is_active_15, t1_.id AS id_16, t1_.title AS title_17, t1_.deleted_at AS deleted_at_18, t1_.modified_at AS modified_at_19, t1_.created_at AS created_at_20, c0_.category_id AS category_id_21, c0_.tour_attribute_id AS tour_attribute_id_22, t1_.tour_attribute_category_id AS tour_attribute_category_id_23 FROM category_tour_attribute_filter c0_ LEFT JOIN tour_attribute t1_ ON c0_.tour_attribute_id = t1_.id AND (t1_.deleted_at IS NULL) WHERE (c0_.category_id = ?) AND (c0_.deleted_at IS NULL) ORDER BY c0_.position ASC Parameters: [`408`] View formatted query View runnable query Explain query SELECT c0_.is_active AS is_active_0, c0_.position AS position_1, c0_.id AS id_2, c0_.deleted_at AS deleted_at_3, c0_.modified_at AS modified_at_4, c0_.created_at AS created_at_5, t1_.alternative_title AS alternative_title_6, t1_.slug AS slug_7, t1_.description AS description_8, t1_.icon AS icon_9, t1_.has_pill AS has_pill_10, t1_.pill_title AS pill_title_11, t1_.pill_tooltip AS pill_tooltip_12, t1_.pill_color AS pill_color_13, t1_.position AS position_14, t1_.is_active AS is_active_15, t1_.id AS id_16, t1_.title AS title_17, t1_.deleted_at AS deleted_at_18, t1_.modified_at AS modified_at_19, t1_.created_at AS created_at_20, c0_.category_id AS category_id_21, c0_.tour_attribute_id AS tour_attribute_id_22, t1_.tour_attribute_category_id AS tour_attribute_category_id_23 FROM category_tour_attribute_filter c0_ LEFT JOIN tour_attribute t1_ ON c0_.tour_attribute_id = t1_.id AND (t1_.deleted_at IS NULL) WHERE (c0_.category_id = ?) AND (c0_.deleted_at IS NULL) ORDER BY c0_.position ASC SELECT c0_.is_active AS is_active_0, c0_.position AS position_1, c0_.id AS id_2, c0_.deleted_at AS deleted_at_3, c0_.modified_at AS modified_at_4, c0_.created_at AS created_at_5, t1_.alternative_title AS alternative_title_6, t1_.slug AS slug_7, t1_.description AS description_8, t1_.icon AS icon_9, t1_.has_pill AS has_pill_10, t1_.pill_title AS pill_title_11, t1_.pill_tooltip AS pill_tooltip_12, t1_.pill_color AS pill_color_13, t1_.position AS position_14, t1_.is_active AS is_active_15, t1_.id AS id_16, t1_.title AS title_17, t1_.deleted_at AS deleted_at_18, t1_.modified_at AS modified_at_19, t1_.created_at AS created_at_20, c0_.category_id AS category_id_21, c0_.tour_attribute_id AS tour_attribute_id_22, t1_.tour_attribute_category_id AS tour_attribute_category_id_23 FROM category_tour_attribute_filter c0_ LEFT JOIN tour_attribute t1_ ON c0_.tour_attribute_id = t1_.id AND (t1_.deleted_at IS NULL) WHERE (c0_.category_id = 408) AND (c0_.deleted_at IS NULL) ORDER BY c0_.position ASC;
21	0.56 ms	SELECT t0.position AS position_1, t0.id AS id_2, t0.deleted_at AS deleted_at_3, t0.modified_at AS modified_at_4, t0.created_at AS created_at_5, t0.tour_id AS tour_id_6, t0.tour_term_id AS tour_term_id_7, t0.category_id AS category_id_8 FROM category_offer t0 WHERE t0.category_id = ? AND ((t0.deleted_at IS NULL)) Parameters: [`7`] View formatted query View runnable query Explain query SELECT t0.position AS position_1, t0.id AS id_2, t0.deleted_at AS deleted_at_3, t0.modified_at AS modified_at_4, t0.created_at AS created_at_5, t0.tour_id AS tour_id_6, t0.tour_term_id AS tour_term_id_7, t0.category_id AS category_id_8 FROM category_offer t0 WHERE t0.category_id = ? AND ( (t0.deleted_at IS NULL) ) SELECT t0.position AS position_1, t0.id AS id_2, t0.deleted_at AS deleted_at_3, t0.modified_at AS modified_at_4, t0.created_at AS created_at_5, t0.tour_id AS tour_id_6, t0.tour_term_id AS tour_term_id_7, t0.category_id AS category_id_8 FROM category_offer t0 WHERE t0.category_id = 7 AND ((t0.deleted_at IS NULL));
22	0.75 ms	SELECT c.Id FROM category c WHERE CONCAT(COALESCE(c.segment,''),'/',COALESCE(c.slug,'')) = :concated AND c.deleted_at IS NULL ORDER BY c.is_active=1 DESC Parameters: [`"concated" => "dovolenka/silvester-poznavacie-zajazdy"`] View formatted query View runnable query Explain query SELECT c.Id FROM category c WHERE CONCAT( COALESCE(c.segment, ''), '/', COALESCE(c.slug, '') ) = :concated AND c.deleted_at IS NULL ORDER BY c.is_active = 1 DESC SELECT c.Id FROM category c WHERE CONCAT(COALESCE(c.segment,''),'/',COALESCE(c.slug,'')) = 'dovolenka/silvester-poznavacie-zajazdy' AND c.deleted_at IS NULL ORDER BY c.is_active=1 DESC;
23	0.77 ms	SELECT c0_.is_active AS is_active_0, c0_.position AS position_1, c0_.id AS id_2, c0_.deleted_at AS deleted_at_3, c0_.modified_at AS modified_at_4, c0_.created_at AS created_at_5, t1_.alternative_title AS alternative_title_6, t1_.slug AS slug_7, t1_.description AS description_8, t1_.icon AS icon_9, t1_.has_pill AS has_pill_10, t1_.pill_title AS pill_title_11, t1_.pill_tooltip AS pill_tooltip_12, t1_.pill_color AS pill_color_13, t1_.position AS position_14, t1_.is_active AS is_active_15, t1_.id AS id_16, t1_.title AS title_17, t1_.deleted_at AS deleted_at_18, t1_.modified_at AS modified_at_19, t1_.created_at AS created_at_20, c0_.category_id AS category_id_21, c0_.tour_attribute_id AS tour_attribute_id_22, t1_.tour_attribute_category_id AS tour_attribute_category_id_23 FROM category_tour_attribute_filter c0_ LEFT JOIN tour_attribute t1_ ON c0_.tour_attribute_id = t1_.id AND (t1_.deleted_at IS NULL) WHERE (c0_.category_id = ?) AND (c0_.deleted_at IS NULL) ORDER BY c0_.position ASC Parameters: [`6`] View formatted query View runnable query Explain query SELECT c0_.is_active AS is_active_0, c0_.position AS position_1, c0_.id AS id_2, c0_.deleted_at AS deleted_at_3, c0_.modified_at AS modified_at_4, c0_.created_at AS created_at_5, t1_.alternative_title AS alternative_title_6, t1_.slug AS slug_7, t1_.description AS description_8, t1_.icon AS icon_9, t1_.has_pill AS has_pill_10, t1_.pill_title AS pill_title_11, t1_.pill_tooltip AS pill_tooltip_12, t1_.pill_color AS pill_color_13, t1_.position AS position_14, t1_.is_active AS is_active_15, t1_.id AS id_16, t1_.title AS title_17, t1_.deleted_at AS deleted_at_18, t1_.modified_at AS modified_at_19, t1_.created_at AS created_at_20, c0_.category_id AS category_id_21, c0_.tour_attribute_id AS tour_attribute_id_22, t1_.tour_attribute_category_id AS tour_attribute_category_id_23 FROM category_tour_attribute_filter c0_ LEFT JOIN tour_attribute t1_ ON c0_.tour_attribute_id = t1_.id AND (t1_.deleted_at IS NULL) WHERE (c0_.category_id = ?) AND (c0_.deleted_at IS NULL) ORDER BY c0_.position ASC SELECT c0_.is_active AS is_active_0, c0_.position AS position_1, c0_.id AS id_2, c0_.deleted_at AS deleted_at_3, c0_.modified_at AS modified_at_4, c0_.created_at AS created_at_5, t1_.alternative_title AS alternative_title_6, t1_.slug AS slug_7, t1_.description AS description_8, t1_.icon AS icon_9, t1_.has_pill AS has_pill_10, t1_.pill_title AS pill_title_11, t1_.pill_tooltip AS pill_tooltip_12, t1_.pill_color AS pill_color_13, t1_.position AS position_14, t1_.is_active AS is_active_15, t1_.id AS id_16, t1_.title AS title_17, t1_.deleted_at AS deleted_at_18, t1_.modified_at AS modified_at_19, t1_.created_at AS created_at_20, c0_.category_id AS category_id_21, c0_.tour_attribute_id AS tour_attribute_id_22, t1_.tour_attribute_category_id AS tour_attribute_category_id_23 FROM category_tour_attribute_filter c0_ LEFT JOIN tour_attribute t1_ ON c0_.tour_attribute_id = t1_.id AND (t1_.deleted_at IS NULL) WHERE (c0_.category_id = 6) AND (c0_.deleted_at IS NULL) ORDER BY c0_.position ASC;
24	0.95 ms	SELECT c0_.is_active AS is_active_0, c0_.position AS position_1, c0_.id AS id_2, c0_.deleted_at AS deleted_at_3, c0_.modified_at AS modified_at_4, c0_.created_at AS created_at_5, t1_.alternative_title AS alternative_title_6, t1_.slug AS slug_7, t1_.description AS description_8, t1_.icon AS icon_9, t1_.has_pill AS has_pill_10, t1_.pill_title AS pill_title_11, t1_.pill_tooltip AS pill_tooltip_12, t1_.pill_color AS pill_color_13, t1_.position AS position_14, t1_.is_active AS is_active_15, t1_.id AS id_16, t1_.title AS title_17, t1_.deleted_at AS deleted_at_18, t1_.modified_at AS modified_at_19, t1_.created_at AS created_at_20, c0_.category_id AS category_id_21, c0_.tour_attribute_id AS tour_attribute_id_22, t1_.tour_attribute_category_id AS tour_attribute_category_id_23 FROM category_tour_attribute_filter c0_ LEFT JOIN tour_attribute t1_ ON c0_.tour_attribute_id = t1_.id AND (t1_.deleted_at IS NULL) WHERE (c0_.category_id = ?) AND (c0_.deleted_at IS NULL) ORDER BY c0_.position ASC Parameters: [`408`] View formatted query View runnable query Explain query SELECT c0_.is_active AS is_active_0, c0_.position AS position_1, c0_.id AS id_2, c0_.deleted_at AS deleted_at_3, c0_.modified_at AS modified_at_4, c0_.created_at AS created_at_5, t1_.alternative_title AS alternative_title_6, t1_.slug AS slug_7, t1_.description AS description_8, t1_.icon AS icon_9, t1_.has_pill AS has_pill_10, t1_.pill_title AS pill_title_11, t1_.pill_tooltip AS pill_tooltip_12, t1_.pill_color AS pill_color_13, t1_.position AS position_14, t1_.is_active AS is_active_15, t1_.id AS id_16, t1_.title AS title_17, t1_.deleted_at AS deleted_at_18, t1_.modified_at AS modified_at_19, t1_.created_at AS created_at_20, c0_.category_id AS category_id_21, c0_.tour_attribute_id AS tour_attribute_id_22, t1_.tour_attribute_category_id AS tour_attribute_category_id_23 FROM category_tour_attribute_filter c0_ LEFT JOIN tour_attribute t1_ ON c0_.tour_attribute_id = t1_.id AND (t1_.deleted_at IS NULL) WHERE (c0_.category_id = ?) AND (c0_.deleted_at IS NULL) ORDER BY c0_.position ASC SELECT c0_.is_active AS is_active_0, c0_.position AS position_1, c0_.id AS id_2, c0_.deleted_at AS deleted_at_3, c0_.modified_at AS modified_at_4, c0_.created_at AS created_at_5, t1_.alternative_title AS alternative_title_6, t1_.slug AS slug_7, t1_.description AS description_8, t1_.icon AS icon_9, t1_.has_pill AS has_pill_10, t1_.pill_title AS pill_title_11, t1_.pill_tooltip AS pill_tooltip_12, t1_.pill_color AS pill_color_13, t1_.position AS position_14, t1_.is_active AS is_active_15, t1_.id AS id_16, t1_.title AS title_17, t1_.deleted_at AS deleted_at_18, t1_.modified_at AS modified_at_19, t1_.created_at AS created_at_20, c0_.category_id AS category_id_21, c0_.tour_attribute_id AS tour_attribute_id_22, t1_.tour_attribute_category_id AS tour_attribute_category_id_23 FROM category_tour_attribute_filter c0_ LEFT JOIN tour_attribute t1_ ON c0_.tour_attribute_id = t1_.id AND (t1_.deleted_at IS NULL) WHERE (c0_.category_id = 408) AND (c0_.deleted_at IS NULL) ORDER BY c0_.position ASC;
25	2.73 ms	SELECT t0.position AS position_1, t0.id AS id_2, t0.deleted_at AS deleted_at_3, t0.modified_at AS modified_at_4, t0.created_at AS created_at_5, t0.tour_id AS tour_id_6, t0.tour_term_id AS tour_term_id_7, t0.category_id AS category_id_8 FROM category_offer t0 WHERE t0.category_id = ? AND ((t0.deleted_at IS NULL)) Parameters: [`6`] View formatted query View runnable query Explain query SELECT t0.position AS position_1, t0.id AS id_2, t0.deleted_at AS deleted_at_3, t0.modified_at AS modified_at_4, t0.created_at AS created_at_5, t0.tour_id AS tour_id_6, t0.tour_term_id AS tour_term_id_7, t0.category_id AS category_id_8 FROM category_offer t0 WHERE t0.category_id = ? AND ( (t0.deleted_at IS NULL) ) SELECT t0.position AS position_1, t0.id AS id_2, t0.deleted_at AS deleted_at_3, t0.modified_at AS modified_at_4, t0.created_at AS created_at_5, t0.tour_id AS tour_id_6, t0.tour_term_id AS tour_term_id_7, t0.category_id AS category_id_8 FROM category_offer t0 WHERE t0.category_id = 6 AND ((t0.deleted_at IS NULL));
26	0.87 ms	SELECT c.Id FROM category c WHERE CONCAT(COALESCE(c.segment,''),'/',COALESCE(c.slug,'')) = :concated AND c.deleted_at IS NULL ORDER BY c.is_active=1 DESC Parameters: [`"concated" => "dovolenka/silvester-lyzovacky"`] View formatted query View runnable query Explain query SELECT c.Id FROM category c WHERE CONCAT( COALESCE(c.segment, ''), '/', COALESCE(c.slug, '') ) = :concated AND c.deleted_at IS NULL ORDER BY c.is_active = 1 DESC SELECT c.Id FROM category c WHERE CONCAT(COALESCE(c.segment,''),'/',COALESCE(c.slug,'')) = 'dovolenka/silvester-lyzovacky' AND c.deleted_at IS NULL ORDER BY c.is_active=1 DESC;
27	0.95 ms	SELECT c0_.is_active AS is_active_0, c0_.position AS position_1, c0_.id AS id_2, c0_.deleted_at AS deleted_at_3, c0_.modified_at AS modified_at_4, c0_.created_at AS created_at_5, t1_.alternative_title AS alternative_title_6, t1_.slug AS slug_7, t1_.description AS description_8, t1_.icon AS icon_9, t1_.has_pill AS has_pill_10, t1_.pill_title AS pill_title_11, t1_.pill_tooltip AS pill_tooltip_12, t1_.pill_color AS pill_color_13, t1_.position AS position_14, t1_.is_active AS is_active_15, t1_.id AS id_16, t1_.title AS title_17, t1_.deleted_at AS deleted_at_18, t1_.modified_at AS modified_at_19, t1_.created_at AS created_at_20, c0_.category_id AS category_id_21, c0_.tour_attribute_id AS tour_attribute_id_22, t1_.tour_attribute_category_id AS tour_attribute_category_id_23 FROM category_tour_attribute_filter c0_ LEFT JOIN tour_attribute t1_ ON c0_.tour_attribute_id = t1_.id AND (t1_.deleted_at IS NULL) WHERE (c0_.category_id = ?) AND (c0_.deleted_at IS NULL) ORDER BY c0_.position ASC Parameters: [`426`] View formatted query View runnable query Explain query SELECT c0_.is_active AS is_active_0, c0_.position AS position_1, c0_.id AS id_2, c0_.deleted_at AS deleted_at_3, c0_.modified_at AS modified_at_4, c0_.created_at AS created_at_5, t1_.alternative_title AS alternative_title_6, t1_.slug AS slug_7, t1_.description AS description_8, t1_.icon AS icon_9, t1_.has_pill AS has_pill_10, t1_.pill_title AS pill_title_11, t1_.pill_tooltip AS pill_tooltip_12, t1_.pill_color AS pill_color_13, t1_.position AS position_14, t1_.is_active AS is_active_15, t1_.id AS id_16, t1_.title AS title_17, t1_.deleted_at AS deleted_at_18, t1_.modified_at AS modified_at_19, t1_.created_at AS created_at_20, c0_.category_id AS category_id_21, c0_.tour_attribute_id AS tour_attribute_id_22, t1_.tour_attribute_category_id AS tour_attribute_category_id_23 FROM category_tour_attribute_filter c0_ LEFT JOIN tour_attribute t1_ ON c0_.tour_attribute_id = t1_.id AND (t1_.deleted_at IS NULL) WHERE (c0_.category_id = ?) AND (c0_.deleted_at IS NULL) ORDER BY c0_.position ASC SELECT c0_.is_active AS is_active_0, c0_.position AS position_1, c0_.id AS id_2, c0_.deleted_at AS deleted_at_3, c0_.modified_at AS modified_at_4, c0_.created_at AS created_at_5, t1_.alternative_title AS alternative_title_6, t1_.slug AS slug_7, t1_.description AS description_8, t1_.icon AS icon_9, t1_.has_pill AS has_pill_10, t1_.pill_title AS pill_title_11, t1_.pill_tooltip AS pill_tooltip_12, t1_.pill_color AS pill_color_13, t1_.position AS position_14, t1_.is_active AS is_active_15, t1_.id AS id_16, t1_.title AS title_17, t1_.deleted_at AS deleted_at_18, t1_.modified_at AS modified_at_19, t1_.created_at AS created_at_20, c0_.category_id AS category_id_21, c0_.tour_attribute_id AS tour_attribute_id_22, t1_.tour_attribute_category_id AS tour_attribute_category_id_23 FROM category_tour_attribute_filter c0_ LEFT JOIN tour_attribute t1_ ON c0_.tour_attribute_id = t1_.id AND (t1_.deleted_at IS NULL) WHERE (c0_.category_id = 426) AND (c0_.deleted_at IS NULL) ORDER BY c0_.position ASC;
28	0.58 ms	SELECT t0.position AS position_1, t0.id AS id_2, t0.deleted_at AS deleted_at_3, t0.modified_at AS modified_at_4, t0.created_at AS created_at_5, t0.tour_id AS tour_id_6, t0.tour_term_id AS tour_term_id_7, t0.category_id AS category_id_8 FROM category_offer t0 WHERE t0.category_id = ? AND ((t0.deleted_at IS NULL)) Parameters: [`8`] View formatted query View runnable query Explain query SELECT t0.position AS position_1, t0.id AS id_2, t0.deleted_at AS deleted_at_3, t0.modified_at AS modified_at_4, t0.created_at AS created_at_5, t0.tour_id AS tour_id_6, t0.tour_term_id AS tour_term_id_7, t0.category_id AS category_id_8 FROM category_offer t0 WHERE t0.category_id = ? AND ( (t0.deleted_at IS NULL) ) SELECT t0.position AS position_1, t0.id AS id_2, t0.deleted_at AS deleted_at_3, t0.modified_at AS modified_at_4, t0.created_at AS created_at_5, t0.tour_id AS tour_id_6, t0.tour_term_id AS tour_term_id_7, t0.category_id AS category_id_8 FROM category_offer t0 WHERE t0.category_id = 8 AND ((t0.deleted_at IS NULL));
29	0.69 ms	SELECT t0.description AS description_1, t0.title AS title_2, t0.id AS id_3, t0.deleted_at AS deleted_at_4, t0.modified_at AS modified_at_5, t0.created_at AS created_at_6, t0.seo_title AS seo_title_7, t0.meta_description AS meta_description_8, t0.meta_image AS meta_image_9, t0.category_id AS category_id_10, t0.destination_id AS destination_id_11 FROM category_seo_destination t0 WHERE t0.category_id = ? AND t0.destination_id = ? AND ((t0.deleted_at IS NULL)) LIMIT 1 Parameters: [`5 138`] View formatted query View runnable query Explain query SELECT t0.description AS description_1, t0.title AS title_2, t0.id AS id_3, t0.deleted_at AS deleted_at_4, t0.modified_at AS modified_at_5, t0.created_at AS created_at_6, t0.seo_title AS seo_title_7, t0.meta_description AS meta_description_8, t0.meta_image AS meta_image_9, t0.category_id AS category_id_10, t0.destination_id AS destination_id_11 FROM category_seo_destination t0 WHERE t0.category_id = ? AND t0.destination_id = ? AND ( (t0.deleted_at IS NULL) ) LIMIT 1 SELECT t0.description AS description_1, t0.title AS title_2, t0.id AS id_3, t0.deleted_at AS deleted_at_4, t0.modified_at AS modified_at_5, t0.created_at AS created_at_6, t0.seo_title AS seo_title_7, t0.meta_description AS meta_description_8, t0.meta_image AS meta_image_9, t0.category_id AS category_id_10, t0.destination_id AS destination_id_11 FROM category_seo_destination t0 WHERE t0.category_id = 5 AND t0.destination_id = 138 AND ((t0.deleted_at IS NULL)) LIMIT 1;
30	1.23 ms	SELECT b0_.title AS title_0, b0_.slug AS slug_1, b0_.is_active AS is_active_2, b0_.image AS image_3, b0_.publish_from AS publish_from_4, b0_.views AS views_5, b0_.read_time_min AS read_time_min_6, b0_.no_index AS no_index_7, b0_.updated_at AS updated_at_8, b0_.id AS id_9, b0_.deleted_at AS deleted_at_10, b0_.modified_at AS modified_at_11, b0_.created_at AS created_at_12, b0_.seo_title AS seo_title_13, b0_.meta_description AS meta_description_14, b0_.meta_image AS meta_image_15, b0_.blog_category_id AS blog_category_id_16, b0_.destination_id AS destination_id_17 FROM blog b0_ WHERE (b0_.publish_from <= '2025-04-05 09:41:34' AND b0_.publish_from IS NOT NULL AND b0_.is_active = 1) AND (b0_.deleted_at IS NULL) ORDER BY b0_.publish_from DESC LIMIT 5 Parameters: [] View formatted query View runnable query Explain query SELECT b0_.title AS title_0, b0_.slug AS slug_1, b0_.is_active AS is_active_2, b0_.image AS image_3, b0_.publish_from AS publish_from_4, b0_.views AS views_5, b0_.read_time_min AS read_time_min_6, b0_.no_index AS no_index_7, b0_.updated_at AS updated_at_8, b0_.id AS id_9, b0_.deleted_at AS deleted_at_10, b0_.modified_at AS modified_at_11, b0_.created_at AS created_at_12, b0_.seo_title AS seo_title_13, b0_.meta_description AS meta_description_14, b0_.meta_image AS meta_image_15, b0_.blog_category_id AS blog_category_id_16, b0_.destination_id AS destination_id_17 FROM blog b0_ WHERE ( b0_.publish_from <= '2025-04-05 09:41:34' AND b0_.publish_from IS NOT NULL AND b0_.is_active = 1 ) AND (b0_.deleted_at IS NULL) ORDER BY b0_.publish_from DESC LIMIT 5 SELECT b0_.title AS title_0, b0_.slug AS slug_1, b0_.is_active AS is_active_2, b0_.image AS image_3, b0_.publish_from AS publish_from_4, b0_.views AS views_5, b0_.read_time_min AS read_time_min_6, b0_.no_index AS no_index_7, b0_.updated_at AS updated_at_8, b0_.id AS id_9, b0_.deleted_at AS deleted_at_10, b0_.modified_at AS modified_at_11, b0_.created_at AS created_at_12, b0_.seo_title AS seo_title_13, b0_.meta_description AS meta_description_14, b0_.meta_image AS meta_image_15, b0_.blog_category_id AS blog_category_id_16, b0_.destination_id AS destination_id_17 FROM blog b0_ WHERE (b0_.publish_from <= '2025-04-05 09:41:34' AND b0_.publish_from IS NOT NULL AND b0_.is_active = 1) AND (b0_.deleted_at IS NULL) ORDER BY b0_.publish_from DESC LIMIT 5;
31	0.75 ms	SELECT t0.name AS name_1, t0.image AS image_2, t0.is_active AS is_active_3, t0.slug AS slug_4, t0.about_me AS about_me_5, t0.motto AS motto_6, t0.email AS email_7, t0.is_in_filter AS is_in_filter_8, t0.no_index AS no_index_9, t0.phone AS phone_10, t0.subtitle AS subtitle_11, t0.background_image AS background_image_12, t0.background_image_alt AS background_image_alt_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.staff_type_id AS staff_type_id_21 FROM staff t0 INNER JOIN staff_category ON t0.id = staff_category.staff_id WHERE staff_category.category_id = ? AND ((t0.deleted_at IS NULL)) Parameters: [`5`] View formatted query View runnable query Explain query SELECT t0.name AS name_1, t0.image AS image_2, t0.is_active AS is_active_3, t0.slug AS slug_4, t0.about_me AS about_me_5, t0.motto AS motto_6, t0.email AS email_7, t0.is_in_filter AS is_in_filter_8, t0.no_index AS no_index_9, t0.phone AS phone_10, t0.subtitle AS subtitle_11, t0.background_image AS background_image_12, t0.background_image_alt AS background_image_alt_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.staff_type_id AS staff_type_id_21 FROM staff t0 INNER JOIN staff_category ON t0.id = staff_category.staff_id WHERE staff_category.category_id = ? AND ( (t0.deleted_at IS NULL) ) SELECT t0.name AS name_1, t0.image AS image_2, t0.is_active AS is_active_3, t0.slug AS slug_4, t0.about_me AS about_me_5, t0.motto AS motto_6, t0.email AS email_7, t0.is_in_filter AS is_in_filter_8, t0.no_index AS no_index_9, t0.phone AS phone_10, t0.subtitle AS subtitle_11, t0.background_image AS background_image_12, t0.background_image_alt AS background_image_alt_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.staff_type_id AS staff_type_id_21 FROM staff t0 INNER JOIN staff_category ON t0.id = staff_category.staff_id WHERE staff_category.category_id = 5 AND ((t0.deleted_at IS NULL));
32	0.95 ms	SELECT c0_.start_date AS start_date_0, c0_.end_date AS end_date_1, c0_.is_active AS is_active_2, c0_.position AS position_3, c0_.listing_position AS listing_position_4, c0_.message_type AS message_type_5, c0_.title AS title_6, c0_.text_above_title AS text_above_title_7, c0_.icon AS icon_8, c0_.button_url AS button_url_9, c0_.text AS text_10, c0_.show_form AS show_form_11, c0_.id AS id_12, c0_.deleted_at AS deleted_at_13, c0_.modified_at AS modified_at_14, c0_.created_at AS created_at_15 FROM category_info_message c0_ LEFT JOIN category_info_message_category c2_ ON c0_.id = c2_.category_info_message_id LEFT JOIN category c1_ ON c1_.id = c2_.category_id AND (c1_.deleted_at IS NULL) LEFT JOIN category_info_message_destination c4_ ON c0_.id = c4_.category_info_message_id LEFT JOIN destination d3_ ON d3_.id = c4_.destination_id AND (d3_.deleted_at IS NULL) WHERE ((c1_.id = 5 OR c1_.id IS NULL) AND (d3_.id IN (138) OR d3_.id IS NULL) AND (c0_.start_date <= '2025-04-05 09:41:34' OR c0_.start_date IS NULL) AND (c0_.end_date >= '2025-04-05 09:41:34' OR c0_.end_date IS NULL) AND c0_.is_active = 1) AND (c0_.deleted_at IS NULL) ORDER BY c0_.position DESC LIMIT 1 Parameters: [] View formatted query View runnable query Explain query SELECT c0_.start_date AS start_date_0, c0_.end_date AS end_date_1, c0_.is_active AS is_active_2, c0_.position AS position_3, c0_.listing_position AS listing_position_4, c0_.message_type AS message_type_5, c0_.title AS title_6, c0_.text_above_title AS text_above_title_7, c0_.icon AS icon_8, c0_.button_url AS button_url_9, c0_.text AS text_10, c0_.show_form AS show_form_11, c0_.id AS id_12, c0_.deleted_at AS deleted_at_13, c0_.modified_at AS modified_at_14, c0_.created_at AS created_at_15 FROM category_info_message c0_ LEFT JOIN category_info_message_category c2_ ON c0_.id = c2_.category_info_message_id LEFT JOIN category c1_ ON c1_.id = c2_.category_id AND (c1_.deleted_at IS NULL) LEFT JOIN category_info_message_destination c4_ ON c0_.id = c4_.category_info_message_id LEFT JOIN destination d3_ ON d3_.id = c4_.destination_id AND (d3_.deleted_at IS NULL) WHERE ( ( c1_.id = 5 OR c1_.id IS NULL ) AND ( d3_.id IN (138) OR d3_.id IS NULL ) AND ( c0_.start_date <= '2025-04-05 09:41:34' OR c0_.start_date IS NULL ) AND ( c0_.end_date >= '2025-04-05 09:41:34' OR c0_.end_date IS NULL ) AND c0_.is_active = 1 ) AND (c0_.deleted_at IS NULL) ORDER BY c0_.position DESC LIMIT 1 SELECT c0_.start_date AS start_date_0, c0_.end_date AS end_date_1, c0_.is_active AS is_active_2, c0_.position AS position_3, c0_.listing_position AS listing_position_4, c0_.message_type AS message_type_5, c0_.title AS title_6, c0_.text_above_title AS text_above_title_7, c0_.icon AS icon_8, c0_.button_url AS button_url_9, c0_.text AS text_10, c0_.show_form AS show_form_11, c0_.id AS id_12, c0_.deleted_at AS deleted_at_13, c0_.modified_at AS modified_at_14, c0_.created_at AS created_at_15 FROM category_info_message c0_ LEFT JOIN category_info_message_category c2_ ON c0_.id = c2_.category_info_message_id LEFT JOIN category c1_ ON c1_.id = c2_.category_id AND (c1_.deleted_at IS NULL) LEFT JOIN category_info_message_destination c4_ ON c0_.id = c4_.category_info_message_id LEFT JOIN destination d3_ ON d3_.id = c4_.destination_id AND (d3_.deleted_at IS NULL) WHERE ((c1_.id = 5 OR c1_.id IS NULL) AND (d3_.id IN (138) OR d3_.id IS NULL) AND (c0_.start_date <= '2025-04-05 09:41:34' OR c0_.start_date IS NULL) AND (c0_.end_date >= '2025-04-05 09:41:34' OR c0_.end_date IS NULL) AND c0_.is_active = 1) AND (c0_.deleted_at IS NULL) ORDER BY c0_.position DESC LIMIT 1;
33	0.70 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: [`2447`] View formatted query View runnable query Explain query 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 = 2447 AND ((t0.deleted_at IS NULL));
34	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: [`2448`] View formatted query View runnable query Explain query 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 = 2448 AND ((t0.deleted_at IS NULL));
35	0.98 ms	SELECT c0_.position AS position_0, c0_.highlight AS highlight_1, c0_.id AS id_2, c0_.deleted_at AS deleted_at_3, c0_.modified_at AS modified_at_4, c0_.created_at AS created_at_5, c0_.tour_id AS tour_id_6, c0_.category_top_destination_id AS category_top_destination_id_7, c0_.user_id AS user_id_8 FROM category_top_destination_tour c0_ LEFT JOIN category_top_destination c1_ ON c0_.category_top_destination_id = c1_.id AND (c1_.deleted_at IS NULL) WHERE (c1_.category_id = ? AND c1_.destination_id IS NULL) AND (c0_.deleted_at IS NULL) ORDER BY c0_.position ASC Parameters: [`5`] View formatted query View runnable query Explain query SELECT c0_.position AS position_0, c0_.highlight AS highlight_1, c0_.id AS id_2, c0_.deleted_at AS deleted_at_3, c0_.modified_at AS modified_at_4, c0_.created_at AS created_at_5, c0_.tour_id AS tour_id_6, c0_.category_top_destination_id AS category_top_destination_id_7, c0_.user_id AS user_id_8 FROM category_top_destination_tour c0_ LEFT JOIN category_top_destination c1_ ON c0_.category_top_destination_id = c1_.id AND (c1_.deleted_at IS NULL) WHERE ( c1_.category_id = ? AND c1_.destination_id IS NULL ) AND (c0_.deleted_at IS NULL) ORDER BY c0_.position ASC SELECT c0_.position AS position_0, c0_.highlight AS highlight_1, c0_.id AS id_2, c0_.deleted_at AS deleted_at_3, c0_.modified_at AS modified_at_4, c0_.created_at AS created_at_5, c0_.tour_id AS tour_id_6, c0_.category_top_destination_id AS category_top_destination_id_7, c0_.user_id AS user_id_8 FROM category_top_destination_tour c0_ LEFT JOIN category_top_destination c1_ ON c0_.category_top_destination_id = c1_.id AND (c1_.deleted_at IS NULL) WHERE (c1_.category_id = 5 AND c1_.destination_id IS NULL) AND (c0_.deleted_at IS NULL) ORDER BY c0_.position ASC;
36	0.91 ms	SELECT c0_.start_date AS start_date_0, c0_.end_date AS end_date_1, c0_.is_active AS is_active_2, c0_.position AS position_3, c0_.listing_position AS listing_position_4, c0_.message_type AS message_type_5, c0_.title AS title_6, c0_.text_above_title AS text_above_title_7, c0_.icon AS icon_8, c0_.button_url AS button_url_9, c0_.text AS text_10, c0_.show_form AS show_form_11, c0_.id AS id_12, c0_.deleted_at AS deleted_at_13, c0_.modified_at AS modified_at_14, c0_.created_at AS created_at_15 FROM category_info_message c0_ LEFT JOIN category_info_message_category c2_ ON c0_.id = c2_.category_info_message_id LEFT JOIN category c1_ ON c1_.id = c2_.category_id AND (c1_.deleted_at IS NULL) LEFT JOIN category_info_message_destination c4_ ON c0_.id = c4_.category_info_message_id LEFT JOIN destination d3_ ON d3_.id = c4_.destination_id AND (d3_.deleted_at IS NULL) WHERE ((c1_.id = 5 OR c1_.id IS NULL) AND (d3_.id IN (138) OR d3_.id IS NULL) AND (c0_.start_date <= '2025-04-05 09:41:34' OR c0_.start_date IS NULL) AND (c0_.end_date >= '2025-04-05 09:41:34' OR c0_.end_date IS NULL) AND c0_.is_active = 1) AND (c0_.deleted_at IS NULL) ORDER BY c0_.position DESC LIMIT 1 Parameters: [] View formatted query View runnable query Explain query SELECT c0_.start_date AS start_date_0, c0_.end_date AS end_date_1, c0_.is_active AS is_active_2, c0_.position AS position_3, c0_.listing_position AS listing_position_4, c0_.message_type AS message_type_5, c0_.title AS title_6, c0_.text_above_title AS text_above_title_7, c0_.icon AS icon_8, c0_.button_url AS button_url_9, c0_.text AS text_10, c0_.show_form AS show_form_11, c0_.id AS id_12, c0_.deleted_at AS deleted_at_13, c0_.modified_at AS modified_at_14, c0_.created_at AS created_at_15 FROM category_info_message c0_ LEFT JOIN category_info_message_category c2_ ON c0_.id = c2_.category_info_message_id LEFT JOIN category c1_ ON c1_.id = c2_.category_id AND (c1_.deleted_at IS NULL) LEFT JOIN category_info_message_destination c4_ ON c0_.id = c4_.category_info_message_id LEFT JOIN destination d3_ ON d3_.id = c4_.destination_id AND (d3_.deleted_at IS NULL) WHERE ( ( c1_.id = 5 OR c1_.id IS NULL ) AND ( d3_.id IN (138) OR d3_.id IS NULL ) AND ( c0_.start_date <= '2025-04-05 09:41:34' OR c0_.start_date IS NULL ) AND ( c0_.end_date >= '2025-04-05 09:41:34' OR c0_.end_date IS NULL ) AND c0_.is_active = 1 ) AND (c0_.deleted_at IS NULL) ORDER BY c0_.position DESC LIMIT 1 SELECT c0_.start_date AS start_date_0, c0_.end_date AS end_date_1, c0_.is_active AS is_active_2, c0_.position AS position_3, c0_.listing_position AS listing_position_4, c0_.message_type AS message_type_5, c0_.title AS title_6, c0_.text_above_title AS text_above_title_7, c0_.icon AS icon_8, c0_.button_url AS button_url_9, c0_.text AS text_10, c0_.show_form AS show_form_11, c0_.id AS id_12, c0_.deleted_at AS deleted_at_13, c0_.modified_at AS modified_at_14, c0_.created_at AS created_at_15 FROM category_info_message c0_ LEFT JOIN category_info_message_category c2_ ON c0_.id = c2_.category_info_message_id LEFT JOIN category c1_ ON c1_.id = c2_.category_id AND (c1_.deleted_at IS NULL) LEFT JOIN category_info_message_destination c4_ ON c0_.id = c4_.category_info_message_id LEFT JOIN destination d3_ ON d3_.id = c4_.destination_id AND (d3_.deleted_at IS NULL) WHERE ((c1_.id = 5 OR c1_.id IS NULL) AND (d3_.id IN (138) OR d3_.id IS NULL) AND (c0_.start_date <= '2025-04-05 09:41:34' OR c0_.start_date IS NULL) AND (c0_.end_date >= '2025-04-05 09:41:34' OR c0_.end_date IS NULL) AND c0_.is_active = 1) AND (c0_.deleted_at IS NULL) ORDER BY c0_.position DESC LIMIT 1;
37	0.59 ms	SELECT t0.slug AS slug_1, t0.is_active AS is_active_2, t0.position AS position_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 blog_category t0 WHERE t0.id = ? AND ((t0.deleted_at IS NULL)) Parameters: [`3`] View formatted query View runnable query Explain query SELECT t0.slug AS slug_1, t0.is_active AS is_active_2, t0.position AS position_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 blog_category t0 WHERE t0.id = ? AND ( (t0.deleted_at IS NULL) ) SELECT t0.slug AS slug_1, t0.is_active AS is_active_2, t0.position AS position_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 blog_category t0 WHERE t0.id = 3 AND ((t0.deleted_at IS NULL));
38	0.46 ms	SELECT t0.slug AS slug_1, t0.is_active AS is_active_2, t0.position AS position_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 blog_category t0 WHERE t0.id = ? AND ((t0.deleted_at IS NULL)) Parameters: [`4`] View formatted query View runnable query Explain query SELECT t0.slug AS slug_1, t0.is_active AS is_active_2, t0.position AS position_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 blog_category t0 WHERE t0.id = ? AND ( (t0.deleted_at IS NULL) ) SELECT t0.slug AS slug_1, t0.is_active AS is_active_2, t0.position AS position_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 blog_category t0 WHERE t0.id = 4 AND ((t0.deleted_at IS NULL));
39	0.38 ms	SELECT t0.slug AS slug_1, t0.is_active AS is_active_2, t0.position AS position_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 blog_category t0 WHERE t0.id = ? AND ((t0.deleted_at IS NULL)) Parameters: [`1`] View formatted query View runnable query Explain query SELECT t0.slug AS slug_1, t0.is_active AS is_active_2, t0.position AS position_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 blog_category t0 WHERE t0.id = ? AND ( (t0.deleted_at IS NULL) ) SELECT t0.slug AS slug_1, t0.is_active AS is_active_2, t0.position AS position_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 blog_category t0 WHERE t0.id = 1 AND ((t0.deleted_at IS NULL));
40	0.37 ms	SELECT t0.slug AS slug_1, t0.is_active AS is_active_2, t0.position AS position_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 blog_category t0 WHERE t0.id = ? AND ((t0.deleted_at IS NULL)) Parameters: [`5`] View formatted query View runnable query Explain query SELECT t0.slug AS slug_1, t0.is_active AS is_active_2, t0.position AS position_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 blog_category t0 WHERE t0.id = ? AND ( (t0.deleted_at IS NULL) ) SELECT t0.slug AS slug_1, t0.is_active AS is_active_2, t0.position AS position_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 blog_category t0 WHERE t0.id = 5 AND ((t0.deleted_at IS NULL));
41	0.56 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 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));
42	0.63 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 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));
43	0.52 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 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));

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\Food	No errors.
Satur\DatabaseBundle\Entity\TourRating	No errors.
Satur\DatabaseBundle\Entity\Destination	No errors.
Satur\DatabaseBundle\Entity\Transport	No errors.
Satur\DatabaseBundle\Entity\TourAttribute	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\AccommodationType	No errors.
Satur\DatabaseBundle\Entity\HolidayType	No errors.
Satur\DatabaseBundle\Entity\BlogCategory	No errors.
Satur\DatabaseBundle\Entity\CategoryTopDestination	No errors.
Satur\DatabaseBundle\Entity\CategoryBestDestination	No errors.
Satur\DatabaseBundle\Entity\CategorySeoDestination	No errors.
Satur\DatabaseBundle\Entity\CategorySeoRegion	No errors.
Satur\DatabaseBundle\Entity\Staff	No errors.
Satur\DatabaseBundle\Entity\CategoryInfoMessage	No errors.
Satur\DatabaseBundle\Entity\CategoryOffer	No errors.
Satur\DatabaseBundle\Entity\HomepageCategory	The association Satur\DatabaseBundle\Entity\HomepageCategory#category refers to the inverse side field Satur\DatabaseBundle\Entity\Category#HomepageCategory which does not exist.
Satur\DatabaseBundle\Entity\Tour	No errors.
Satur\DatabaseBundle\Entity\TourTerm	No errors.
Satur\DatabaseBundle\Entity\ElasticSearchIndex	No errors.
Satur\DatabaseBundle\Entity\CategoryTourAttributeFilter	No errors.
Satur\DatabaseBundle\Entity\TourAttributeCategory	No errors.
Satur\DatabaseBundle\Entity\TourSeasonAttribute	No errors.
Satur\DatabaseBundle\Entity\SourceTourAttribute	No errors.
Satur\DatabaseBundle\Entity\Region	No errors.
Satur\DatabaseBundle\Entity\SourceFood	No errors.
Satur\DatabaseBundle\Entity\SourcePackage	No errors.
Satur\DatabaseBundle\Entity\SourceTransport	No errors.
Satur\DatabaseBundle\Entity\Currency	No errors.
Satur\DatabaseBundle\Entity\Continent	No errors.
Satur\DatabaseBundle\Entity\MustVisit	No errors.
Satur\DatabaseBundle\Entity\Climate	No errors.
Satur\DatabaseBundle\Entity\SourceDestination	No errors.
Satur\DatabaseBundle\Entity\Page	No errors.
Satur\DatabaseBundle\Entity\ForbiddenSource	No errors.
Satur\DatabaseBundle\Entity\PaymentType	No errors.
Satur\DatabaseBundle\Entity\ExtraService	No errors.
Satur\DatabaseBundle\Entity\CheckTerm	No errors.
Satur\DatabaseBundle\Entity\FlightDuration	No errors.
Satur\DatabaseBundle\Entity\MapItem	No errors.
Satur\DatabaseBundle\Entity\Blog	No errors.
Satur\DatabaseBundle\Entity\TourInfoMessage	No errors.
Satur\DatabaseBundle\Entity\Bookmark	No errors.
Satur\DatabaseBundle\Entity\ContentSection	No errors.
Satur\DatabaseBundle\Entity\BlogTag	No errors.
Satur\DatabaseBundle\Entity\StaffType	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\PageType	No errors.
Satur\DatabaseBundle\Entity\News	No errors.
Satur\DatabaseBundle\Entity\CategoryTopDestinationTour	No errors.
Satur\DatabaseBundle\Entity\User	The field Satur\DatabaseBundle\Entity\User#favoriteCategories is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity Satur\DatabaseBundle\Entity\UserFavoriteCategory#user does not contain the required 'inversedBy="favoriteCategories"' attribute.
Satur\DatabaseBundle\Entity\NewsletterCategory	No errors.
Satur\DatabaseBundle\Entity\Newsletter	No errors.

Symfony Profiler

GET https://wwwdev2.satur.sk/dovolenka/silvester/maldivy

Configuration Settings

Theme

Page Width

Query Metrics

Queries

Database Connections

Entity Managers

Second Level Cache

Entities Mapping