Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.project_name AS project_name_2,
  t0.domains AS domains_3,
  t0.user_id AS user_id_4,
  t0.eshop_id AS eshop_id_5,
  t0.has_camps AS has_camps_6,
  t0.has_facilities AS has_facilities_7,
  t0.canonical_domain AS canonical_domain_8,
  t0.robots_txt AS robots_txt_9,
  t0.is_active AS is_active_10,
  t0.sitemap_cached_at AS sitemap_cached_at_11,
  t0.user_id AS user_id_12,
  t0.eshop_id AS eshop_id_13
FROM
  kw_web t0
WHERE
  t0.is_active = ?

SELECT t0.id AS id_1, t0.project_name AS project_name_2, t0.domains AS domains_3, t0.user_id AS user_id_4, t0.eshop_id AS eshop_id_5, t0.has_camps AS has_camps_6, t0.has_facilities AS has_facilities_7, t0.canonical_domain AS canonical_domain_8, t0.robots_txt AS robots_txt_9, t0.is_active AS is_active_10, t0.sitemap_cached_at AS sitemap_cached_at_11, t0.user_id AS user_id_12, t0.eshop_id AS eshop_id_13 FROM kw_web t0 WHERE t0.is_active = 1;

SELECT
  k0_.id AS id_0,
  k0_.name AS name_1,
  k0_.code AS code_2,
  k0_.is_for_all_projects AS is_for_all_projects_3
FROM
  kw_languages k0_
  LEFT JOIN kw_language_webs k2_ ON k0_.id = k2_.language_id
  LEFT JOIN kw_web k1_ ON k1_.id = k2_.web_id
WHERE
  k0_.code = ?
  AND (
    k0_.is_for_all_projects = 1
    OR k1_.id = ?
  )
LIMIT
  1

SELECT k0_.id AS id_0, k0_.name AS name_1, k0_.code AS code_2, k0_.is_for_all_projects AS is_for_all_projects_3 FROM kw_languages k0_ LEFT JOIN kw_language_webs k2_ ON k0_.id = k2_.language_id LEFT JOIN kw_web k1_ ON k1_.id = k2_.web_id WHERE k0_.code = 'cz' AND (k0_.is_for_all_projects = 1 OR k1_.id = 2) LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.phrase AS phrase_3,
  t0.language_id AS language_id_4,
  t0.language_id AS language_id_5
FROM
  kw_phrases t0
WHERE
  t0.name = ?
  AND t0.language_id = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.phrase AS phrase_3, t0.language_id AS language_id_4, t0.language_id AS language_id_5 FROM kw_phrases t0 WHERE t0.name = 'cookie-agree' AND t0.language_id = 1 LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.phrase AS phrase_3,
  t0.language_id AS language_id_4,
  t0.language_id AS language_id_5
FROM
  kw_phrases t0
WHERE
  t0.name = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.phrase AS phrase_3, t0.language_id AS language_id_4, t0.language_id AS language_id_5 FROM kw_phrases t0 WHERE t0.name = 'cookie-agree';

"COMMIT"

"COMMIT";

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.content AS content_3,
  t0.content_prefix AS content_prefix_4,
  t0.content_suffix AS content_suffix_5,
  t0.groupper AS groupper_6,
  t0.type AS type_7,
  t0.language_id AS language_id_8,
  t0.web_id AS web_id_9,
  t0.language_id AS language_id_10,
  t0.web_id AS web_id_11
FROM
  kw_global_configs t0
WHERE
  t0.name = ?
  AND t0.language_id = ?
  AND t0.web_id = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.content AS content_3, t0.content_prefix AS content_prefix_4, t0.content_suffix AS content_suffix_5, t0.groupper AS groupper_6, t0.type AS type_7, t0.language_id AS language_id_8, t0.web_id AS web_id_9, t0.language_id AS language_id_10, t0.web_id AS web_id_11 FROM kw_global_configs t0 WHERE t0.name = 'title' AND t0.language_id = 1 AND t0.web_id = 2 LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.web_id AS web_id_2,
  t0.name AS name_3,
  t0.code AS code_4,
  t0.description AS description_5,
  t0.address_street AS address_street_6,
  t0.address_city AS address_city_7,
  t0.address_zip AS address_zip_8,
  t0.address_region AS address_region_9,
  t0.address_country AS address_country_10,
  t0.map_point_id AS map_point_id_11,
  t0.gallery_id AS gallery_id_12,
  t0.accommodation_type AS accommodation_type_13,
  t0.meals_info AS meals_info_14,
  t0.is_hidden AS is_hidden_15,
  t0.sort_num AS sort_num_16,
  t0.facility_room_count AS facility_room_count_17,
  t0.facility_capacity_total AS facility_capacity_total_18,
  t0.facility_capacity_min AS facility_capacity_min_19,
  t0.facility_seasonal_from AS facility_seasonal_from_20,
  t0.facility_seasonal_to AS facility_seasonal_to_21,
  t0.facility_short_pitch AS facility_short_pitch_22,
  t0.facility_long_description AS facility_long_description_23,
  t0.facility_features_xml AS facility_features_xml_24,
  t0.facility_surroundings_xml AS facility_surroundings_xml_25,
  t0.facility_transport_xml AS facility_transport_xml_26,
  t0.facility_is_top AS facility_is_top_27,
  t0.facility_whole_only AS facility_whole_only_28,
  t0.facility_sort_num AS facility_sort_num_29,
  t0.facility_image_id AS facility_image_id_30,
  t0.facility_page_id AS facility_page_id_31,
  t0.facility_file_id AS facility_file_id_32,
  t0.facility_map_id AS facility_map_id_33,
  t0.web_id AS web_id_34,
  t0.map_point_id AS map_point_id_35,
  t0.gallery_id AS gallery_id_36,
  t0.facility_image_id AS facility_image_id_37,
  t0.facility_page_id AS facility_page_id_38,
  t0.facility_file_id AS facility_file_id_39,
  t0.facility_map_id AS facility_map_id_40
FROM
  kw_camps_locations t0
WHERE
  t0.web_id = ?
  AND t0.is_hidden = ?

SELECT t0.id AS id_1, t0.web_id AS web_id_2, t0.name AS name_3, t0.code AS code_4, t0.description AS description_5, t0.address_street AS address_street_6, t0.address_city AS address_city_7, t0.address_zip AS address_zip_8, t0.address_region AS address_region_9, t0.address_country AS address_country_10, t0.map_point_id AS map_point_id_11, t0.gallery_id AS gallery_id_12, t0.accommodation_type AS accommodation_type_13, t0.meals_info AS meals_info_14, t0.is_hidden AS is_hidden_15, t0.sort_num AS sort_num_16, t0.facility_room_count AS facility_room_count_17, t0.facility_capacity_total AS facility_capacity_total_18, t0.facility_capacity_min AS facility_capacity_min_19, t0.facility_seasonal_from AS facility_seasonal_from_20, t0.facility_seasonal_to AS facility_seasonal_to_21, t0.facility_short_pitch AS facility_short_pitch_22, t0.facility_long_description AS facility_long_description_23, t0.facility_features_xml AS facility_features_xml_24, t0.facility_surroundings_xml AS facility_surroundings_xml_25, t0.facility_transport_xml AS facility_transport_xml_26, t0.facility_is_top AS facility_is_top_27, t0.facility_whole_only AS facility_whole_only_28, t0.facility_sort_num AS facility_sort_num_29, t0.facility_image_id AS facility_image_id_30, t0.facility_page_id AS facility_page_id_31, t0.facility_file_id AS facility_file_id_32, t0.facility_map_id AS facility_map_id_33, t0.web_id AS web_id_34, t0.map_point_id AS map_point_id_35, t0.gallery_id AS gallery_id_36, t0.facility_image_id AS facility_image_id_37, t0.facility_page_id AS facility_page_id_38, t0.facility_file_id AS facility_file_id_39, t0.facility_map_id AS facility_map_id_40 FROM kw_camps_locations t0 WHERE t0.web_id = 2 AND t0.is_hidden = 0;

SELECT
  k0_.id AS id_0,
  k0_.name AS name_1,
  k0_.code AS code_2,
  k0_.is_for_all_projects AS is_for_all_projects_3
FROM
  kw_languages k0_
  LEFT JOIN kw_language_webs k2_ ON k0_.id = k2_.language_id
  LEFT JOIN kw_web k1_ ON k1_.id = k2_.web_id
WHERE
  k0_.is_for_all_projects = 1
  OR k1_.id = ?
GROUP BY
  k0_.id
ORDER BY
  k0_.id ASC

SELECT k0_.id AS id_0, k0_.name AS name_1, k0_.code AS code_2, k0_.is_for_all_projects AS is_for_all_projects_3 FROM kw_languages k0_ LEFT JOIN kw_language_webs k2_ ON k0_.id = k2_.language_id LEFT JOIN kw_web k1_ ON k1_.id = k2_.web_id WHERE k0_.is_for_all_projects = 1 OR k1_.id = 2 GROUP BY k0_.id ORDER BY k0_.id ASC;

SELECT
  k0_.id AS id_0,
  k0_.web_id AS web_id_1,
  k0_.name AS name_2,
  k0_.code AS code_3,
  k0_.description AS description_4,
  k0_.sort_num AS sort_num_5
FROM
  kw_facility_stay_types k0_
  INNER JOIN kw_facility_location_stay_types k2_ ON k0_.id = k2_.stay_type_id
  INNER JOIN kw_camps_locations k1_ ON k1_.id = k2_.location_id
WHERE
  k1_.id = ?
  AND k0_.web_id = ?
ORDER BY
  k0_.sort_num ASC

SELECT k0_.id AS id_0, k0_.web_id AS web_id_1, k0_.name AS name_2, k0_.code AS code_3, k0_.description AS description_4, k0_.sort_num AS sort_num_5 FROM kw_facility_stay_types k0_ INNER JOIN kw_facility_location_stay_types k2_ ON k0_.id = k2_.stay_type_id INNER JOIN kw_camps_locations k1_ ON k1_.id = k2_.location_id WHERE k1_.id = 4 AND k0_.web_id = 2 ORDER BY k0_.sort_num ASC;

SELECT
  t0.id AS id_1,
  t0.sub_constant_key AS sub_constant_key_2,
  t0.content AS content_3,
  t0.content_prefix AS content_prefix_4,
  t0.content_suffix AS content_suffix_5,
  t0.global_constant_id AS global_constant_id_6,
  t0.global_constant_id AS global_constant_id_7
FROM
  kw_global_sub_configs t0
WHERE
  t0.global_constant_id = ?
  AND t0.sub_constant_key = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.sub_constant_key AS sub_constant_key_2, t0.content AS content_3, t0.content_prefix AS content_prefix_4, t0.content_suffix AS content_suffix_5, t0.global_constant_id AS global_constant_id_6, t0.global_constant_id AS global_constant_id_7 FROM kw_global_sub_configs t0 WHERE t0.global_constant_id = 9 AND t0.sub_constant_key = 'page-42' LIMIT 1;

SELECT
  k0_.id AS id_0,
  k0_.web_id AS web_id_1,
  k0_.name AS name_2,
  k0_.description AS description_3,
  k0_.icon AS icon_4,
  k0_.category AS category_5,
  k0_.sort_num AS sort_num_6
FROM
  kw_facility_amenities k0_
  INNER JOIN kw_facility_location_amenities k2_ ON k0_.id = k2_.amenity_id
  INNER JOIN kw_camps_locations k1_ ON k1_.id = k2_.location_id
WHERE
  k1_.id = ?
  AND k0_.web_id = ?
ORDER BY
  k0_.sort_num ASC

SELECT k0_.id AS id_0, k0_.web_id AS web_id_1, k0_.name AS name_2, k0_.description AS description_3, k0_.icon AS icon_4, k0_.category AS category_5, k0_.sort_num AS sort_num_6 FROM kw_facility_amenities k0_ INNER JOIN kw_facility_location_amenities k2_ ON k0_.id = k2_.amenity_id INNER JOIN kw_camps_locations k1_ ON k1_.id = k2_.location_id WHERE k1_.id = 4 AND k0_.web_id = 2 ORDER BY k0_.sort_num ASC;

SELECT
  t0.id AS id_1,
  t0.location_id AS location_id_2,
  t0.name AS name_3,
  t0.code AS code_4,
  t0.bed_count AS bed_count_5,
  t0.room_count AS room_count_6,
  t0.price_per_bed_night AS price_per_bed_night_7,
  t0.description AS description_8,
  t0.sort_num AS sort_num_9,
  t0.is_active AS is_active_10,
  t0.image_id AS image_id_11,
  t0.gallery_id AS gallery_id_12,
  t0.page_id AS page_id_13,
  t0.file_id AS file_id_14,
  t0.location_id AS location_id_15,
  t0.image_id AS image_id_16,
  t0.gallery_id AS gallery_id_17,
  t0.page_id AS page_id_18,
  t0.file_id AS file_id_19
FROM
  kw_facility_rooms t0
WHERE
  t0.location_id = ?
  AND t0.is_active = ?
ORDER BY
  t0.sort_num ASC

SELECT t0.id AS id_1, t0.location_id AS location_id_2, t0.name AS name_3, t0.code AS code_4, t0.bed_count AS bed_count_5, t0.room_count AS room_count_6, t0.price_per_bed_night AS price_per_bed_night_7, t0.description AS description_8, t0.sort_num AS sort_num_9, t0.is_active AS is_active_10, t0.image_id AS image_id_11, t0.gallery_id AS gallery_id_12, t0.page_id AS page_id_13, t0.file_id AS file_id_14, t0.location_id AS location_id_15, t0.image_id AS image_id_16, t0.gallery_id AS gallery_id_17, t0.page_id AS page_id_18, t0.file_id AS file_id_19 FROM kw_facility_rooms t0 WHERE t0.location_id = 4 AND t0.is_active = 1 ORDER BY t0.sort_num ASC;

SELECT
  k0_.id AS id_0,
  k0_.web_id AS web_id_1,
  k0_.name AS name_2,
  k0_.code AS code_3,
  k0_.description AS description_4,
  k0_.sort_num AS sort_num_5
FROM
  kw_facility_target_groups k0_
  INNER JOIN kw_facility_location_target_groups k2_ ON k0_.id = k2_.target_group_id
  INNER JOIN kw_camps_locations k1_ ON k1_.id = k2_.location_id
WHERE
  k1_.id = ?
  AND k0_.web_id = ?
ORDER BY
  k0_.sort_num ASC

SELECT k0_.id AS id_0, k0_.web_id AS web_id_1, k0_.name AS name_2, k0_.code AS code_3, k0_.description AS description_4, k0_.sort_num AS sort_num_5 FROM kw_facility_target_groups k0_ INNER JOIN kw_facility_location_target_groups k2_ ON k0_.id = k2_.target_group_id INNER JOIN kw_camps_locations k1_ ON k1_.id = k2_.location_id WHERE k1_.id = 4 AND k0_.web_id = 2 ORDER BY k0_.sort_num ASC;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.group_id AS group_id_3,
  t0.tpl AS tpl_4,
  t0.kiwi_tpl AS kiwi_tpl_5,
  t0.module_type AS module_type_6,
  t0.group_id AS group_id_7
FROM
  kw_templates_modules_groups_templates t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.group_id AS group_id_3, t0.tpl AS tpl_4, t0.kiwi_tpl AS kiwi_tpl_5, t0.module_type AS module_type_6, t0.group_id AS group_id_7 FROM kw_templates_modules_groups_templates t0 WHERE t0.id = 29;

SELECT
  t0.id AS id_1,
  t0.location_id AS location_id_2,
  t0.name AS name_3,
  t0.description AS description_4,
  t0.price AS price_5,
  t0.unit AS unit_6,
  t0.pricing_unit_id AS pricing_unit_id_7,
  t0.is_optional AS is_optional_8,
  t0.sort_num AS sort_num_9,
  t0.location_id AS location_id_10,
  t0.pricing_unit_id AS pricing_unit_id_11
FROM
  kw_facility_extra_services t0
WHERE
  t0.location_id = ?
ORDER BY
  t0.sort_num ASC

SELECT t0.id AS id_1, t0.location_id AS location_id_2, t0.name AS name_3, t0.description AS description_4, t0.price AS price_5, t0.unit AS unit_6, t0.pricing_unit_id AS pricing_unit_id_7, t0.is_optional AS is_optional_8, t0.sort_num AS sort_num_9, t0.location_id AS location_id_10, t0.pricing_unit_id AS pricing_unit_id_11 FROM kw_facility_extra_services t0 WHERE t0.location_id = 4 ORDER BY t0.sort_num ASC;

SELECT
  t0.id AS id_1,
  t0.location_id AS location_id_2,
  t0.question AS question_3,
  t0.answer AS answer_4,
  t0.sort_num AS sort_num_5,
  t0.is_visible AS is_visible_6,
  t0.location_id AS location_id_7
FROM
  kw_facility_faq_items t0
WHERE
  t0.location_id = ?
  AND t0.is_visible = ?
ORDER BY
  t0.sort_num ASC,
  t0.id ASC

SELECT t0.id AS id_1, t0.location_id AS location_id_2, t0.question AS question_3, t0.answer AS answer_4, t0.sort_num AS sort_num_5, t0.is_visible AS is_visible_6, t0.location_id AS location_id_7 FROM kw_facility_faq_items t0 WHERE t0.location_id = 4 AND t0.is_visible = 1 ORDER BY t0.sort_num ASC, t0.id ASC;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.var_name AS var_name_3,
  t0.is_multilang AS is_multilang_4,
  t0.type AS type_5,
  t0.template_id AS template_id_6,
  t0.template_id AS template_id_7
FROM
  kw_templates_modules_groups_templates_variables t0
WHERE
  t0.template_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.var_name AS var_name_3, t0.is_multilang AS is_multilang_4, t0.type AS type_5, t0.template_id AS template_id_6, t0.template_id AS template_id_7 FROM kw_templates_modules_groups_templates_variables t0 WHERE t0.template_id = 42;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.page_name AS page_name_3,
  t0.parent_row_id AS parent_row_id_4,
  t0.prevent_changes AS prevent_changes_5,
  t0.sort_num AS sort_num_6,
  t0.layout_id AS layout_id_7,
  t0.in_menu_display AS in_menu_display_8,
  t0.image_id AS image_id_9,
  t0.gallery_id AS gallery_id_10,
  t0.redirect_id AS redirect_id_11,
  t0.redirect_suffix AS redirect_suffix_12,
  t0.is_templates_root AS is_templates_root_13,
  t0.system_folder AS system_folder_14,
  t0.opt_one AS opt_one_15,
  t0.opt_two AS opt_two_16,
  t0.opt_three AS opt_three_17,
  t0.web_id AS web_id_18,
  t0.parent_row_id AS parent_row_id_19,
  t0.layout_id AS layout_id_20,
  t0.image_id AS image_id_21,
  t0.gallery_id AS gallery_id_22,
  t0.redirect_id AS redirect_id_23,
  t0.web_id AS web_id_24
FROM
  kw_tree_page t0
WHERE
  t0.parent_row_id = ?
  AND t0.web_id = ?
ORDER BY
  t0.sort_num ASC

SELECT t0.id AS id_1, t0.name AS name_2, t0.page_name AS page_name_3, t0.parent_row_id AS parent_row_id_4, t0.prevent_changes AS prevent_changes_5, t0.sort_num AS sort_num_6, t0.layout_id AS layout_id_7, t0.in_menu_display AS in_menu_display_8, t0.image_id AS image_id_9, t0.gallery_id AS gallery_id_10, t0.redirect_id AS redirect_id_11, t0.redirect_suffix AS redirect_suffix_12, t0.is_templates_root AS is_templates_root_13, t0.system_folder AS system_folder_14, t0.opt_one AS opt_one_15, t0.opt_two AS opt_two_16, t0.opt_three AS opt_three_17, t0.web_id AS web_id_18, t0.parent_row_id AS parent_row_id_19, t0.layout_id AS layout_id_20, t0.image_id AS image_id_21, t0.gallery_id AS gallery_id_22, t0.redirect_id AS redirect_id_23, t0.web_id AS web_id_24 FROM kw_tree_page t0 WHERE t0.parent_row_id = 38 AND t0.web_id = 2 ORDER BY t0.sort_num ASC;

SELECT
  t0.id AS id_1,
  t0.namespace AS namespace_2,
  t0.page_id AS page_id_3,
  t0.placeholder_id AS placeholder_id_4,
  t0.template_id AS template_id_5,
  t0.template_dso_service AS template_dso_service_6,
  t0.template_dso_method AS template_dso_method_7,
  t0.article_id AS article_id_8,
  t0.gallery_id AS gallery_id_9,
  t0.database_namespace AS database_namespace_10,
  t0.database_query AS database_query_11,
  t0.map_id AS map_id_12,
  t0.mirror_id AS mirror_id_13,
  t0.language_id AS language_id_14,
  t0.prevent_changes AS prevent_changes_15,
  t0.calendar_id AS calendar_id_16,
  t0.blog_id AS blog_id_17,
  t0.article_group_id AS article_group_id_18,
  t0.is_active AS is_active_19,
  t0.sort_num AS sort_num_20,
  t0.page_id AS page_id_21,
  t0.placeholder_id AS placeholder_id_22,
  t0.template AS template_23,
  t0.article_id AS article_id_24,
  t0.gallery_id AS gallery_id_25,
  t0.map_id AS map_id_26,
  t0.mirror_id AS mirror_id_27,
  t0.language_id AS language_id_28,
  t0.calendar_id AS calendar_id_29,
  t0.blog_id AS blog_id_30,
  t0.article_group_id AS article_group_id_31
FROM
  kw_tree_page_modules t0
WHERE
  t0.page_id = ?
  AND t0.placeholder_id = ?
  AND t0.is_active = ?
ORDER BY
  t0.sort_num ASC

SELECT t0.id AS id_1, t0.namespace AS namespace_2, t0.page_id AS page_id_3, t0.placeholder_id AS placeholder_id_4, t0.template_id AS template_id_5, t0.template_dso_service AS template_dso_service_6, t0.template_dso_method AS template_dso_method_7, t0.article_id AS article_id_8, t0.gallery_id AS gallery_id_9, t0.database_namespace AS database_namespace_10, t0.database_query AS database_query_11, t0.map_id AS map_id_12, t0.mirror_id AS mirror_id_13, t0.language_id AS language_id_14, t0.prevent_changes AS prevent_changes_15, t0.calendar_id AS calendar_id_16, t0.blog_id AS blog_id_17, t0.article_group_id AS article_group_id_18, t0.is_active AS is_active_19, t0.sort_num AS sort_num_20, t0.page_id AS page_id_21, t0.placeholder_id AS placeholder_id_22, t0.template AS template_23, t0.article_id AS article_id_24, t0.gallery_id AS gallery_id_25, t0.map_id AS map_id_26, t0.mirror_id AS mirror_id_27, t0.language_id AS language_id_28, t0.calendar_id AS calendar_id_29, t0.blog_id AS blog_id_30, t0.article_group_id AS article_group_id_31 FROM kw_tree_page_modules t0 WHERE t0.page_id = 42 AND t0.placeholder_id = 4 AND t0.is_active = 1 ORDER BY t0.sort_num ASC;

SELECT
  k0_.id AS id_0,
  k0_.web_id AS web_id_1,
  k0_.name AS name_2,
  k0_.code AS code_3,
  k0_.description AS description_4,
  k0_.address_street AS address_street_5,
  k0_.address_city AS address_city_6,
  k0_.address_zip AS address_zip_7,
  k0_.address_region AS address_region_8,
  k0_.address_country AS address_country_9,
  k0_.map_point_id AS map_point_id_10,
  k0_.gallery_id AS gallery_id_11,
  k0_.accommodation_type AS accommodation_type_12,
  k0_.meals_info AS meals_info_13,
  k0_.is_hidden AS is_hidden_14,
  k0_.sort_num AS sort_num_15,
  k0_.facility_room_count AS facility_room_count_16,
  k0_.facility_capacity_total AS facility_capacity_total_17,
  k0_.facility_capacity_min AS facility_capacity_min_18,
  k0_.facility_seasonal_from AS facility_seasonal_from_19,
  k0_.facility_seasonal_to AS facility_seasonal_to_20,
  k0_.facility_short_pitch AS facility_short_pitch_21,
  k0_.facility_long_description AS facility_long_description_22,
  k0_.facility_features_xml AS facility_features_xml_23,
  k0_.facility_surroundings_xml AS facility_surroundings_xml_24,
  k0_.facility_transport_xml AS facility_transport_xml_25,
  k0_.facility_is_top AS facility_is_top_26,
  k0_.facility_whole_only AS facility_whole_only_27,
  k0_.facility_sort_num AS facility_sort_num_28,
  k0_.facility_image_id AS facility_image_id_29,
  k0_.facility_page_id AS facility_page_id_30,
  k0_.facility_file_id AS facility_file_id_31,
  k0_.facility_map_id AS facility_map_id_32,
  k0_.web_id AS web_id_33,
  k0_.map_point_id AS map_point_id_34,
  k0_.gallery_id AS gallery_id_35,
  k0_.facility_image_id AS facility_image_id_36,
  k0_.facility_page_id AS facility_page_id_37,
  k0_.facility_file_id AS facility_file_id_38,
  k0_.facility_map_id AS facility_map_id_39
FROM
  kw_camps_locations k0_
WHERE
  k0_.web_id = ?
  AND k0_.is_hidden = 0
ORDER BY
  k0_.facility_sort_num ASC,
  k0_.id ASC

SELECT k0_.id AS id_0, k0_.web_id AS web_id_1, k0_.name AS name_2, k0_.code AS code_3, k0_.description AS description_4, k0_.address_street AS address_street_5, k0_.address_city AS address_city_6, k0_.address_zip AS address_zip_7, k0_.address_region AS address_region_8, k0_.address_country AS address_country_9, k0_.map_point_id AS map_point_id_10, k0_.gallery_id AS gallery_id_11, k0_.accommodation_type AS accommodation_type_12, k0_.meals_info AS meals_info_13, k0_.is_hidden AS is_hidden_14, k0_.sort_num AS sort_num_15, k0_.facility_room_count AS facility_room_count_16, k0_.facility_capacity_total AS facility_capacity_total_17, k0_.facility_capacity_min AS facility_capacity_min_18, k0_.facility_seasonal_from AS facility_seasonal_from_19, k0_.facility_seasonal_to AS facility_seasonal_to_20, k0_.facility_short_pitch AS facility_short_pitch_21, k0_.facility_long_description AS facility_long_description_22, k0_.facility_features_xml AS facility_features_xml_23, k0_.facility_surroundings_xml AS facility_surroundings_xml_24, k0_.facility_transport_xml AS facility_transport_xml_25, k0_.facility_is_top AS facility_is_top_26, k0_.facility_whole_only AS facility_whole_only_27, k0_.facility_sort_num AS facility_sort_num_28, k0_.facility_image_id AS facility_image_id_29, k0_.facility_page_id AS facility_page_id_30, k0_.facility_file_id AS facility_file_id_31, k0_.facility_map_id AS facility_map_id_32, k0_.web_id AS web_id_33, k0_.map_point_id AS map_point_id_34, k0_.gallery_id AS gallery_id_35, k0_.facility_image_id AS facility_image_id_36, k0_.facility_page_id AS facility_page_id_37, k0_.facility_file_id AS facility_file_id_38, k0_.facility_map_id AS facility_map_id_39 FROM kw_camps_locations k0_ WHERE k0_.web_id = 2 AND k0_.is_hidden = 0 ORDER BY k0_.facility_sort_num ASC, k0_.id ASC;

SELECT
  t0.id AS id_1,
  t0.namespace AS namespace_2,
  t0.page_id AS page_id_3,
  t0.placeholder_id AS placeholder_id_4,
  t0.template_id AS template_id_5,
  t0.template_dso_service AS template_dso_service_6,
  t0.template_dso_method AS template_dso_method_7,
  t0.article_id AS article_id_8,
  t0.gallery_id AS gallery_id_9,
  t0.database_namespace AS database_namespace_10,
  t0.database_query AS database_query_11,
  t0.map_id AS map_id_12,
  t0.mirror_id AS mirror_id_13,
  t0.language_id AS language_id_14,
  t0.prevent_changes AS prevent_changes_15,
  t0.calendar_id AS calendar_id_16,
  t0.blog_id AS blog_id_17,
  t0.article_group_id AS article_group_id_18,
  t0.is_active AS is_active_19,
  t0.sort_num AS sort_num_20,
  t0.page_id AS page_id_21,
  t0.placeholder_id AS placeholder_id_22,
  t0.template AS template_23,
  t0.article_id AS article_id_24,
  t0.gallery_id AS gallery_id_25,
  t0.map_id AS map_id_26,
  t0.mirror_id AS mirror_id_27,
  t0.language_id AS language_id_28,
  t0.calendar_id AS calendar_id_29,
  t0.blog_id AS blog_id_30,
  t0.article_group_id AS article_group_id_31
FROM
  kw_tree_page_modules t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.namespace AS namespace_2, t0.page_id AS page_id_3, t0.placeholder_id AS placeholder_id_4, t0.template_id AS template_id_5, t0.template_dso_service AS template_dso_service_6, t0.template_dso_method AS template_dso_method_7, t0.article_id AS article_id_8, t0.gallery_id AS gallery_id_9, t0.database_namespace AS database_namespace_10, t0.database_query AS database_query_11, t0.map_id AS map_id_12, t0.mirror_id AS mirror_id_13, t0.language_id AS language_id_14, t0.prevent_changes AS prevent_changes_15, t0.calendar_id AS calendar_id_16, t0.blog_id AS blog_id_17, t0.article_group_id AS article_group_id_18, t0.is_active AS is_active_19, t0.sort_num AS sort_num_20, t0.page_id AS page_id_21, t0.placeholder_id AS placeholder_id_22, t0.template AS template_23, t0.article_id AS article_id_24, t0.gallery_id AS gallery_id_25, t0.map_id AS map_id_26, t0.mirror_id AS mirror_id_27, t0.language_id AS language_id_28, t0.calendar_id AS calendar_id_29, t0.blog_id AS blog_id_30, t0.article_group_id AS article_group_id_31 FROM kw_tree_page_modules t0 WHERE t0.id = 119;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.added AS added_3,
  t0.web_id AS web_id_4,
  t0.web_id AS web_id_5
FROM
  kw_templates_modules_groups t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.added AS added_3, t0.web_id AS web_id_4, t0.web_id AS web_id_5 FROM kw_templates_modules_groups t0 WHERE t0.id = 7;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.page_name AS page_name_3,
  t0.parent_row_id AS parent_row_id_4,
  t0.prevent_changes AS prevent_changes_5,
  t0.sort_num AS sort_num_6,
  t0.layout_id AS layout_id_7,
  t0.in_menu_display AS in_menu_display_8,
  t0.image_id AS image_id_9,
  t0.gallery_id AS gallery_id_10,
  t0.redirect_id AS redirect_id_11,
  t0.redirect_suffix AS redirect_suffix_12,
  t0.is_templates_root AS is_templates_root_13,
  t0.system_folder AS system_folder_14,
  t0.opt_one AS opt_one_15,
  t0.opt_two AS opt_two_16,
  t0.opt_three AS opt_three_17,
  t0.web_id AS web_id_18,
  t0.parent_row_id AS parent_row_id_19,
  t0.layout_id AS layout_id_20,
  t0.image_id AS image_id_21,
  t0.gallery_id AS gallery_id_22,
  t0.redirect_id AS redirect_id_23,
  t0.web_id AS web_id_24
FROM
  kw_tree_page t0
WHERE
  t0.parent_row_id = ?
  AND t0.web_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.page_name AS page_name_3, t0.parent_row_id AS parent_row_id_4, t0.prevent_changes AS prevent_changes_5, t0.sort_num AS sort_num_6, t0.layout_id AS layout_id_7, t0.in_menu_display AS in_menu_display_8, t0.image_id AS image_id_9, t0.gallery_id AS gallery_id_10, t0.redirect_id AS redirect_id_11, t0.redirect_suffix AS redirect_suffix_12, t0.is_templates_root AS is_templates_root_13, t0.system_folder AS system_folder_14, t0.opt_one AS opt_one_15, t0.opt_two AS opt_two_16, t0.opt_three AS opt_three_17, t0.web_id AS web_id_18, t0.parent_row_id AS parent_row_id_19, t0.layout_id AS layout_id_20, t0.image_id AS image_id_21, t0.gallery_id AS gallery_id_22, t0.redirect_id AS redirect_id_23, t0.web_id AS web_id_24 FROM kw_tree_page t0 WHERE t0.parent_row_id = 3 AND t0.web_id = 2;