Symfony Profiler

SELECT 
  DISTINCT r0_.attributes ->> 'flat_disposition' AS sclr_0 
FROM 
  unit_portal u1_ 
  INNER JOIN realpad_units r0_ ON u1_.rp_id = r0_.id 
WHERE 
  u1_.is_visible = true 
  AND r0_.attributes ->> 'flat_status' IN ('0', '1') 
  AND r0_.attributes ->> 'flat_type' IN ('1', '2', '4', '6') 
  AND r0_.attributes ->> 'flat_area' <> '0' 
  AND r0_.attributes ->> 'flat_price' <> '0' 
ORDER BY 
  r0_.attributes ->> 'flat_disposition' ASC

SELECT DISTINCT r0_.attributes ->> 'flat_disposition' AS sclr_0 FROM unit_portal u1_ INNER JOIN realpad_units r0_ ON u1_.rp_id = r0_.id WHERE u1_.is_visible = true AND r0_.attributes ->> 'flat_status' IN ('0', '1') AND r0_.attributes ->> 'flat_type' IN ('1', '2', '4', '6') AND r0_.attributes ->> 'flat_area' <> '0' AND r0_.attributes ->> 'flat_price' <> '0' ORDER BY r0_.attributes ->> 'flat_disposition' ASC;

SELECT 
  u0_.id AS id_0, 
  u0_.coordinates AS coordinates_1, 
  u0_.is_visible AS is_visible_2, 
  r1_.plan AS plan_3, 
  r1_.attributes AS attributes_4, 
  r1_.id AS id_5, 
  r2_.floor_no AS floor_no_6, 
  r2_.plan AS plan_7, 
  r2_.id AS id_8, 
  r3_.name AS name_9, 
  r3_.plan AS plan_10, 
  r3_.id AS id_11, 
  r4_.name AS name_12, 
  r4_.description AS description_13, 
  r4_.plan AS plan_14, 
  r4_.id AS id_15, 
  u0_.rp_id AS rp_id_16, 
  r1_.floor_id AS floor_id_17, 
  r1_.building_id AS building_id_18, 
  r1_.project_id AS project_id_19, 
  r2_.building_id AS building_id_20, 
  r2_.project_id AS project_id_21, 
  r3_.project_id AS project_id_22 
FROM 
  unit_portal u0_ 
  INNER JOIN realpad_units r1_ ON u0_.rp_id = r1_.id 
  INNER JOIN realpad_floors r2_ ON r1_.floor_id = r2_.id 
  INNER JOIN realpad_buildings r3_ ON r2_.building_id = r3_.id 
  INNER JOIN realpad_projects r4_ ON r3_.project_id = r4_.id 
  INNER JOIN project_portal p5_ ON (p5_.rp_id = r4_.id) 
WHERE 
  u0_.is_visible = true 
  AND r1_.attributes ->> 'flat_status' IN ('0', '1') 
  AND r1_.attributes ->> 'flat_type' IN ('1', '2', '4', '6') 
  AND r1_.attributes ->> 'flat_area' <> '0' 
  AND r1_.attributes ->> 'flat_price' <> '0' 
  AND r1_.attributes ->> ? = ? 
ORDER BY 
  r1_.attributes ->> ? ASC 
LIMIT 
  30

SELECT u0_.id AS id_0, u0_.coordinates AS coordinates_1, u0_.is_visible AS is_visible_2, r1_.plan AS plan_3, r1_.attributes AS attributes_4, r1_.id AS id_5, r2_.floor_no AS floor_no_6, r2_.plan AS plan_7, r2_.id AS id_8, r3_.name AS name_9, r3_.plan AS plan_10, r3_.id AS id_11, r4_.name AS name_12, r4_.description AS description_13, r4_.plan AS plan_14, r4_.id AS id_15, u0_.rp_id AS rp_id_16, r1_.floor_id AS floor_id_17, r1_.building_id AS building_id_18, r1_.project_id AS project_id_19, r2_.building_id AS building_id_20, r2_.project_id AS project_id_21, r3_.project_id AS project_id_22 FROM unit_portal u0_ INNER JOIN realpad_units r1_ ON u0_.rp_id = r1_.id INNER JOIN realpad_floors r2_ ON r1_.floor_id = r2_.id INNER JOIN realpad_buildings r3_ ON r2_.building_id = r3_.id INNER JOIN realpad_projects r4_ ON r3_.project_id = r4_.id INNER JOIN project_portal p5_ ON (p5_.rp_id = r4_.id) WHERE u0_.is_visible = true AND r1_.attributes ->> 'flat_status' IN ('0', '1') AND r1_.attributes ->> 'flat_type' IN ('1', '2', '4', '6') AND r1_.attributes ->> 'flat_area' <> '0' AND r1_.attributes ->> 'flat_price' <> '0' AND r1_.attributes ->> 'flat_disposition' = '3+kk' ORDER BY r1_.attributes ->> 'flat_internal_id' ASC LIMIT 30;

SELECT 
  DISTINCT r0_.floor_no AS floor_no_0 
FROM 
  unit_portal u1_ 
  INNER JOIN realpad_units r2_ ON u1_.rp_id = r2_.id 
  INNER JOIN realpad_floors r0_ ON r2_.floor_id = r0_.id 
WHERE 
  u1_.is_visible = true 
  AND r2_.attributes ->> 'flat_status' IN ('0', '1') 
  AND r2_.attributes ->> 'flat_type' IN ('1', '2', '4', '6') 
  AND r2_.attributes ->> 'flat_area' <> '0' 
  AND r2_.attributes ->> 'flat_price' <> '0' 
ORDER BY 
  r0_.floor_no ASC

SELECT DISTINCT r0_.floor_no AS floor_no_0 FROM unit_portal u1_ INNER JOIN realpad_units r2_ ON u1_.rp_id = r2_.id INNER JOIN realpad_floors r0_ ON r2_.floor_id = r0_.id WHERE u1_.is_visible = true AND r2_.attributes ->> 'flat_status' IN ('0', '1') AND r2_.attributes ->> 'flat_type' IN ('1', '2', '4', '6') AND r2_.attributes ->> 'flat_area' <> '0' AND r2_.attributes ->> 'flat_price' <> '0' ORDER BY r0_.floor_no ASC;

SELECT 
  t0.id AS id_1, 
  t0.original_name AS original_name_2, 
  t0.hash AS hash_3, 
  t0.mime_type AS mime_type_4, 
  t0.alias AS alias_5, 
  t0.url AS url_6, 
  t0.abs_path AS abs_path_7, 
  t0.created_at AS created_at_8 
FROM 
  file t0 
WHERE 
  t0.id = ?

SELECT t0.id AS id_1, t0.original_name AS original_name_2, t0.hash AS hash_3, t0.mime_type AS mime_type_4, t0.alias AS alias_5, t0.url AS url_6, t0.abs_path AS abs_path_7, t0.created_at AS created_at_8 FROM file t0 WHERE t0.id = '1721';

SELECT 
  t0.id AS id_1, 
  t0.content_id AS content_id_2, 
  t0.content_type AS content_type_3, 
  t0.sort_order AS sort_order_4, 
  t0.news_render_method AS news_render_method_5, 
  t0.news_render_count AS news_render_count_6, 
  t0.page_id AS page_id_7 
FROM 
  page_content t0 
WHERE 
  t0.page_id = ? 
ORDER BY 
  t0.sort_order ASC

SELECT t0.id AS id_1, t0.content_id AS content_id_2, t0.content_type AS content_type_3, t0.sort_order AS sort_order_4, t0.news_render_method AS news_render_method_5, t0.news_render_count AS news_render_count_6, t0.page_id AS page_id_7 FROM page_content t0 WHERE t0.page_id = 4 ORDER BY t0.sort_order ASC;

SELECT 
  t0.id AS id_1, 
  t0.image_name AS image_name_2, 
  t0.imageSize AS imagesize_3, 
  t0.text_position AS text_position_4, 
  t0.background_color AS background_color_5 
FROM 
  block_richtext t0 
WHERE 
  t0.id = ?

SELECT t0.id AS id_1, t0.image_name AS image_name_2, t0.imageSize AS imagesize_3, t0.text_position AS text_position_4, t0.background_color AS background_color_5 FROM block_richtext t0 WHERE t0.id = 29;

SELECT 
  t0.name AS name_1, 
  t0.id AS id_2, 
  t0.locale AS locale_3, 
  t0.translatable_id AS translatable_id_4 
FROM 
  menu_item_translation t0 
WHERE 
  t0.translatable_id = ? 
  AND (
    (t0.locale = 'cs')
  )

SELECT t0.name AS name_1, t0.id AS id_2, t0.locale AS locale_3, t0.translatable_id AS translatable_id_4 FROM menu_item_translation t0 WHERE t0.translatable_id = 9 AND ((t0.locale = 'cs'));

SELECT 
  t0.id AS id_1, 
  t0.image_name AS image_name_2, 
  t0.imageSize AS imagesize_3, 
  t0.type AS type_4, 
  t0.slug AS slug_5, 
  t0.seo_title AS seo_title_6, 
  t0.seo_description AS seo_description_7, 
  t0.published AS published_8, 
  t0.breadcrumbs AS breadcrumbs_9, 
  t0.news_media_type AS news_media_type_10, 
  t0.news_to_date AS news_to_date_11, 
  t0.updated_at AS updated_at_12, 
  t0.header AS header_13, 
  t0.units_filter AS units_filter_14, 
  t0.newsletter AS newsletter_15, 
  t0.footer AS footer_16, 
  t0.parent_page_id AS parent_page_id_17, 
  t18.id AS id_19, 
  t18.image_name AS image_name_20, 
  t18.imageSize AS imagesize_21, 
  t18.type AS type_22, 
  t18.slug AS slug_23, 
  t18.seo_title AS seo_title_24, 
  t18.seo_description AS seo_description_25, 
  t18.published AS published_26, 
  t18.breadcrumbs AS breadcrumbs_27, 
  t18.news_media_type AS news_media_type_28, 
  t18.news_to_date AS news_to_date_29, 
  t18.updated_at AS updated_at_30, 
  t18.header AS header_31, 
  t18.units_filter AS units_filter_32, 
  t18.newsletter AS newsletter_33, 
  t18.footer AS footer_34, 
  t18.parent_page_id AS parent_page_id_35, 
  t18.project_portal_id AS project_portal_id_36, 
  t18.unit_content_page AS unit_content_page_37, 
  t18.banner_id AS banner_id_38, 
  t0.project_portal_id AS project_portal_id_39, 
  t0.unit_content_page AS unit_content_page_40, 
  t41.id AS id_42, 
  t41.image_name AS image_name_43, 
  t41.imageSize AS imagesize_44, 
  t41.type AS type_45, 
  t41.slug AS slug_46, 
  t41.seo_title AS seo_title_47, 
  t41.seo_description AS seo_description_48, 
  t41.published AS published_49, 
  t41.breadcrumbs AS breadcrumbs_50, 
  t41.news_media_type AS news_media_type_51, 
  t41.news_to_date AS news_to_date_52, 
  t41.updated_at AS updated_at_53, 
  t41.header AS header_54, 
  t41.units_filter AS units_filter_55, 
  t41.newsletter AS newsletter_56, 
  t41.footer AS footer_57, 
  t41.parent_page_id AS parent_page_id_58, 
  t41.project_portal_id AS project_portal_id_59, 
  t41.unit_content_page AS unit_content_page_60, 
  t41.banner_id AS banner_id_61, 
  t62.id AS id_63, 
  t62.content_id AS content_id_64, 
  t62.content_type AS content_type_65, 
  t62.sort_order AS sort_order_66, 
  t62.news_render_method AS news_render_method_67, 
  t62.news_render_count AS news_render_count_68, 
  t62.page_id AS page_id_69, 
  t0.banner_id AS banner_id_70 
FROM 
  page t0 
  LEFT JOIN page t18 ON t0.parent_page_id = t18.id 
  LEFT JOIN page t41 ON t0.unit_content_page = t41.id 
  LEFT JOIN page_content t62 ON t62.page_id = t0.id 
WHERE 
  t0.id IN (?)

SELECT t0.id AS id_1, t0.image_name AS image_name_2, t0.imageSize AS imagesize_3, t0.type AS type_4, t0.slug AS slug_5, t0.seo_title AS seo_title_6, t0.seo_description AS seo_description_7, t0.published AS published_8, t0.breadcrumbs AS breadcrumbs_9, t0.news_media_type AS news_media_type_10, t0.news_to_date AS news_to_date_11, t0.updated_at AS updated_at_12, t0.header AS header_13, t0.units_filter AS units_filter_14, t0.newsletter AS newsletter_15, t0.footer AS footer_16, t0.parent_page_id AS parent_page_id_17, t18.id AS id_19, t18.image_name AS image_name_20, t18.imageSize AS imagesize_21, t18.type AS type_22, t18.slug AS slug_23, t18.seo_title AS seo_title_24, t18.seo_description AS seo_description_25, t18.published AS published_26, t18.breadcrumbs AS breadcrumbs_27, t18.news_media_type AS news_media_type_28, t18.news_to_date AS news_to_date_29, t18.updated_at AS updated_at_30, t18.header AS header_31, t18.units_filter AS units_filter_32, t18.newsletter AS newsletter_33, t18.footer AS footer_34, t18.parent_page_id AS parent_page_id_35, t18.project_portal_id AS project_portal_id_36, t18.unit_content_page AS unit_content_page_37, t18.banner_id AS banner_id_38, t0.project_portal_id AS project_portal_id_39, t0.unit_content_page AS unit_content_page_40, t41.id AS id_42, t41.image_name AS image_name_43, t41.imageSize AS imagesize_44, t41.type AS type_45, t41.slug AS slug_46, t41.seo_title AS seo_title_47, t41.seo_description AS seo_description_48, t41.published AS published_49, t41.breadcrumbs AS breadcrumbs_50, t41.news_media_type AS news_media_type_51, t41.news_to_date AS news_to_date_52, t41.updated_at AS updated_at_53, t41.header AS header_54, t41.units_filter AS units_filter_55, t41.newsletter AS newsletter_56, t41.footer AS footer_57, t41.parent_page_id AS parent_page_id_58, t41.project_portal_id AS project_portal_id_59, t41.unit_content_page AS unit_content_page_60, t41.banner_id AS banner_id_61, t62.id AS id_63, t62.content_id AS content_id_64, t62.content_type AS content_type_65, t62.sort_order AS sort_order_66, t62.news_render_method AS news_render_method_67, t62.news_render_count AS news_render_count_68, t62.page_id AS page_id_69, t0.banner_id AS banner_id_70 FROM page t0 LEFT JOIN page t18 ON t0.parent_page_id = t18.id LEFT JOIN page t41 ON t0.unit_content_page = t41.id LEFT JOIN page_content t62 ON t62.page_id = t0.id WHERE t0.id IN (134);

SELECT 
  t0.id AS id_1, 
  t0.name AS name_2, 
  t0.structure AS structure_3, 
  t0.publish AS publish_4, 
  t0.count AS count_5, 
  t0.created_at AS created_at_6, 
  t0.sliderType AS slidertype_7 
FROM 
  gallery t0 
WHERE 
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.structure AS structure_3, t0.publish AS publish_4, t0.count AS count_5, t0.created_at AS created_at_6, t0.sliderType AS slidertype_7 FROM gallery t0 WHERE t0.id = 131;

SELECT 
  p0_.id AS id_0, 
  p0_.image_name AS image_name_1, 
  p0_.imageSize AS imagesize_2, 
  p0_.type AS type_3, 
  p0_.slug AS slug_4, 
  p0_.seo_title AS seo_title_5, 
  p0_.seo_description AS seo_description_6, 
  p0_.published AS published_7, 
  p0_.breadcrumbs AS breadcrumbs_8, 
  p0_.news_media_type AS news_media_type_9, 
  p0_.news_to_date AS news_to_date_10, 
  p0_.updated_at AS updated_at_11, 
  p0_.header AS header_12, 
  p0_.units_filter AS units_filter_13, 
  p0_.newsletter AS newsletter_14, 
  p0_.footer AS footer_15, 
  p0_.parent_page_id AS parent_page_id_16, 
  p0_.project_portal_id AS project_portal_id_17, 
  p0_.unit_content_page AS unit_content_page_18, 
  p0_.banner_id AS banner_id_19 
FROM 
  page p0_ 
WHERE 
  p0_.published = true 
  AND p0_.type = ? 
ORDER BY 
  p0_.id DESC 
LIMIT 
  50

SELECT p0_.id AS id_0, p0_.image_name AS image_name_1, p0_.imageSize AS imagesize_2, p0_.type AS type_3, p0_.slug AS slug_4, p0_.seo_title AS seo_title_5, p0_.seo_description AS seo_description_6, p0_.published AS published_7, p0_.breadcrumbs AS breadcrumbs_8, p0_.news_media_type AS news_media_type_9, p0_.news_to_date AS news_to_date_10, p0_.updated_at AS updated_at_11, p0_.header AS header_12, p0_.units_filter AS units_filter_13, p0_.newsletter AS newsletter_14, p0_.footer AS footer_15, p0_.parent_page_id AS parent_page_id_16, p0_.project_portal_id AS project_portal_id_17, p0_.unit_content_page AS unit_content_page_18, p0_.banner_id AS banner_id_19 FROM page p0_ WHERE p0_.published = true AND p0_.type = 'news_page' ORDER BY p0_.id DESC LIMIT 50;

SELECT 
  t0.id AS id_1, 
  t0.title AS title_2, 
  t0.locale AS locale_3, 
  t0.translatable_id AS translatable_id_4 
FROM 
  attribute_translation t0 
WHERE 
  t0.translatable_id = ? 
  AND (
    (t0.locale = 'cs')
  )

SELECT t0.id AS id_1, t0.title AS title_2, t0.locale AS locale_3, t0.translatable_id AS translatable_id_4 FROM attribute_translation t0 WHERE t0.translatable_id = 667 AND ((t0.locale = 'cs'));

SELECT 
  m0_.id AS id_0, 
  m0_.link AS link_1, 
  m0_.item_order AS item_order_2, 
  m0_.targetBlank AS targetblank_3, 
  m0_.menu_id AS menu_id_4 
FROM 
  menu_item m0_ 
WHERE 
  m0_.menu_id = ? 
ORDER BY 
  m0_.item_order ASC

SELECT m0_.id AS id_0, m0_.link AS link_1, m0_.item_order AS item_order_2, m0_.targetBlank AS targetblank_3, m0_.menu_id AS menu_id_4 FROM menu_item m0_ WHERE m0_.menu_id = 1 ORDER BY m0_.item_order ASC;

SELECT 
  t0.id AS id_1, 
  t0.image_name AS image_name_2, 
  t0.imageSize AS imagesize_3, 
  t0.type AS type_4, 
  t0.slug AS slug_5, 
  t0.seo_title AS seo_title_6, 
  t0.seo_description AS seo_description_7, 
  t0.published AS published_8, 
  t0.breadcrumbs AS breadcrumbs_9, 
  t0.news_media_type AS news_media_type_10, 
  t0.news_to_date AS news_to_date_11, 
  t0.updated_at AS updated_at_12, 
  t0.header AS header_13, 
  t0.units_filter AS units_filter_14, 
  t0.newsletter AS newsletter_15, 
  t0.footer AS footer_16, 
  t0.parent_page_id AS parent_page_id_17, 
  t18.id AS id_19, 
  t18.image_name AS image_name_20, 
  t18.imageSize AS imagesize_21, 
  t18.type AS type_22, 
  t18.slug AS slug_23, 
  t18.seo_title AS seo_title_24, 
  t18.seo_description AS seo_description_25, 
  t18.published AS published_26, 
  t18.breadcrumbs AS breadcrumbs_27, 
  t18.news_media_type AS news_media_type_28, 
  t18.news_to_date AS news_to_date_29, 
  t18.updated_at AS updated_at_30, 
  t18.header AS header_31, 
  t18.units_filter AS units_filter_32, 
  t18.newsletter AS newsletter_33, 
  t18.footer AS footer_34, 
  t18.parent_page_id AS parent_page_id_35, 
  t18.project_portal_id AS project_portal_id_36, 
  t18.unit_content_page AS unit_content_page_37, 
  t18.banner_id AS banner_id_38, 
  t0.project_portal_id AS project_portal_id_39, 
  t0.unit_content_page AS unit_content_page_40, 
  t41.id AS id_42, 
  t41.image_name AS image_name_43, 
  t41.imageSize AS imagesize_44, 
  t41.type AS type_45, 
  t41.slug AS slug_46, 
  t41.seo_title AS seo_title_47, 
  t41.seo_description AS seo_description_48, 
  t41.published AS published_49, 
  t41.breadcrumbs AS breadcrumbs_50, 
  t41.news_media_type AS news_media_type_51, 
  t41.news_to_date AS news_to_date_52, 
  t41.updated_at AS updated_at_53, 
  t41.header AS header_54, 
  t41.units_filter AS units_filter_55, 
  t41.newsletter AS newsletter_56, 
  t41.footer AS footer_57, 
  t41.parent_page_id AS parent_page_id_58, 
  t41.project_portal_id AS project_portal_id_59, 
  t41.unit_content_page AS unit_content_page_60, 
  t41.banner_id AS banner_id_61, 
  t0.banner_id AS banner_id_62 
FROM 
  page t0 
  LEFT JOIN page t18 ON t0.parent_page_id = t18.id 
  LEFT JOIN page t41 ON t0.unit_content_page = t41.id 
WHERE 
  t0.type = ? 
  AND t0.published = ? 
LIMIT 
  1

SELECT t0.id AS id_1, t0.image_name AS image_name_2, t0.imageSize AS imagesize_3, t0.type AS type_4, t0.slug AS slug_5, t0.seo_title AS seo_title_6, t0.seo_description AS seo_description_7, t0.published AS published_8, t0.breadcrumbs AS breadcrumbs_9, t0.news_media_type AS news_media_type_10, t0.news_to_date AS news_to_date_11, t0.updated_at AS updated_at_12, t0.header AS header_13, t0.units_filter AS units_filter_14, t0.newsletter AS newsletter_15, t0.footer AS footer_16, t0.parent_page_id AS parent_page_id_17, t18.id AS id_19, t18.image_name AS image_name_20, t18.imageSize AS imagesize_21, t18.type AS type_22, t18.slug AS slug_23, t18.seo_title AS seo_title_24, t18.seo_description AS seo_description_25, t18.published AS published_26, t18.breadcrumbs AS breadcrumbs_27, t18.news_media_type AS news_media_type_28, t18.news_to_date AS news_to_date_29, t18.updated_at AS updated_at_30, t18.header AS header_31, t18.units_filter AS units_filter_32, t18.newsletter AS newsletter_33, t18.footer AS footer_34, t18.parent_page_id AS parent_page_id_35, t18.project_portal_id AS project_portal_id_36, t18.unit_content_page AS unit_content_page_37, t18.banner_id AS banner_id_38, t0.project_portal_id AS project_portal_id_39, t0.unit_content_page AS unit_content_page_40, t41.id AS id_42, t41.image_name AS image_name_43, t41.imageSize AS imagesize_44, t41.type AS type_45, t41.slug AS slug_46, t41.seo_title AS seo_title_47, t41.seo_description AS seo_description_48, t41.published AS published_49, t41.breadcrumbs AS breadcrumbs_50, t41.news_media_type AS news_media_type_51, t41.news_to_date AS news_to_date_52, t41.updated_at AS updated_at_53, t41.header AS header_54, t41.units_filter AS units_filter_55, t41.newsletter AS newsletter_56, t41.footer AS footer_57, t41.parent_page_id AS parent_page_id_58, t41.project_portal_id AS project_portal_id_59, t41.unit_content_page AS unit_content_page_60, t41.banner_id AS banner_id_61, t0.banner_id AS banner_id_62 FROM page t0 LEFT JOIN page t18 ON t0.parent_page_id = t18.id LEFT JOIN page t41 ON t0.unit_content_page = t41.id WHERE t0.type = 'price_list' AND t0.published = 1 LIMIT 1;

SELECT 
  t0.id AS id_1, 
  t0.slug AS slug_2 
FROM 
  menu t0 
WHERE 
  t0.slug = ? 
LIMIT 
  1

SELECT t0.id AS id_1, t0.slug AS slug_2 FROM menu t0 WHERE t0.slug = 'header' LIMIT 1;

SELECT 
  t0.title AS title_1, 
  t0.description AS description_2, 
  t0.id AS id_3, 
  t0.locale AS locale_4, 
  t0.translatable_id AS translatable_id_5 
FROM 
  page_translation t0 
WHERE 
  t0.translatable_id = ? 
  AND (
    (t0.locale = 'cs')
  )

SELECT t0.title AS title_1, t0.description AS description_2, t0.id AS id_3, t0.locale AS locale_4, t0.translatable_id AS translatable_id_5 FROM page_translation t0 WHERE t0.translatable_id = 3 AND ((t0.locale = 'cs'));

SELECT 
  t0.key AS key_1, 
  t0.type AS type_2, 
  t0.name AS name_3, 
  t0.id AS id_4 
FROM 
  realpad_attribute_types t0 
WHERE 
  t0.key = ? 
LIMIT 
  1

SELECT t0.key AS key_1, t0.type AS type_2, t0.name AS name_3, t0.id AS id_4 FROM realpad_attribute_types t0 WHERE t0.key = 'flat_status' LIMIT 1;

SELECT 
  t0.name AS name_1, 
  t0.id AS id_2, 
  t0.locale AS locale_3, 
  t0.translatable_id AS translatable_id_4 
FROM 
  menu_translation t0 
WHERE 
  t0.translatable_id = ? 
  AND (
    (t0.locale = 'cs')
  )

SELECT t0.name AS name_1, t0.id AS id_2, t0.locale AS locale_3, t0.translatable_id AS translatable_id_4 FROM menu_translation t0 WHERE t0.translatable_id = 12 AND ((t0.locale = 'cs'));

SELECT 
  a0_.id AS id_0, 
  a0_.key AS key_1, 
  a0_.type AS type_2, 
  a0_.required AS required_3, 
  a0_.filterable AS filterable_4 
FROM 
  attribute a0_

SELECT a0_.id AS id_0, a0_.key AS key_1, a0_.type AS type_2, a0_.required AS required_3, a0_.filterable AS filterable_4 FROM attribute a0_;

SELECT 
  r0_.id AS id_0, 
  r0_.name AS name_1 
FROM 
  realpad_projects r0_

SELECT r0_.id AS id_0, r0_.name AS name_1 FROM realpad_projects r0_;

SELECT 
  t0.id AS id_1, 
  t0.name AS name_2, 
  t0.structure AS structure_3, 
  t0.publish AS publish_4, 
  t0.created_at AS created_at_5 
FROM 
  banner t0 
WHERE 
  t0.id IN (?)

SELECT t0.id AS id_1, t0.name AS name_2, t0.structure AS structure_3, t0.publish AS publish_4, t0.created_at AS created_at_5 FROM banner t0 WHERE t0.id IN (53, 28, 27);

SELECT 
  p0_.id AS id_0, 
  p0_.year AS year_1, 
  p0_.vr_space_url AS vr_space_url_2, 
  p0_.show_in_filters AS show_in_filters_3, 
  p0_.display_name AS display_name_4, 
  p0_.rp_id AS rp_id_5, 
  p0_.development_area_id AS development_area_id_6, 
  p0_.banner_id AS banner_id_7 
FROM 
  project_portal p0_ 
WHERE 
  p0_.show_in_filters = true

SELECT p0_.id AS id_0, p0_.year AS year_1, p0_.vr_space_url AS vr_space_url_2, p0_.show_in_filters AS show_in_filters_3, p0_.display_name AS display_name_4, p0_.rp_id AS rp_id_5, p0_.development_area_id AS development_area_id_6, p0_.banner_id AS banner_id_7 FROM project_portal p0_ WHERE p0_.show_in_filters = true;

SELECT 
  p0_.id AS id_0, 
  p0_.year AS year_1, 
  p0_.vr_space_url AS vr_space_url_2, 
  p0_.show_in_filters AS show_in_filters_3, 
  p0_.display_name AS display_name_4, 
  p0_.rp_id AS rp_id_5, 
  p0_.development_area_id AS development_area_id_6, 
  p0_.banner_id AS banner_id_7 
FROM 
  project_portal p0_ 
WHERE 
  p0_.display_name IS NOT NULL

SELECT p0_.id AS id_0, p0_.year AS year_1, p0_.vr_space_url AS vr_space_url_2, p0_.show_in_filters AS show_in_filters_3, p0_.display_name AS display_name_4, p0_.rp_id AS rp_id_5, p0_.development_area_id AS development_area_id_6, p0_.banner_id AS banner_id_7 FROM project_portal p0_ WHERE p0_.display_name IS NOT NULL;

SELECT 
  t0.id AS id_1, 
  t0.title AS title_2, 
  t3.id AS id_4, 
  t3.sort_order AS sort_order_5, 
  t3.page_id AS page_id_6, 
  t3.blockSubpage_id AS blocksubpage_id_7 
FROM 
  block_subpage t0 
  LEFT JOIN block_subpage_tab t3 ON t3.blockSubpage_id = t0.id 
WHERE 
  t0.id = ?

SELECT t0.id AS id_1, t0.title AS title_2, t3.id AS id_4, t3.sort_order AS sort_order_5, t3.page_id AS page_id_6, t3.blockSubpage_id AS blocksubpage_id_7 FROM block_subpage t0 LEFT JOIN block_subpage_tab t3 ON t3.blockSubpage_id = t0.id WHERE t0.id = 2;

SELECT 
  p0_.id AS id_0, 
  p0_.content_id AS content_id_1, 
  p0_.content_type AS content_type_2, 
  p0_.sort_order AS sort_order_3, 
  p0_.news_render_method AS news_render_method_4, 
  p0_.news_render_count AS news_render_count_5, 
  p0_.page_id AS page_id_6 
FROM 
  page_content p0_ 
WHERE 
  p0_.page_id = ? 
  AND p0_.content_type = ?

SELECT p0_.id AS id_0, p0_.content_id AS content_id_1, p0_.content_type AS content_type_2, p0_.sort_order AS sort_order_3, p0_.news_render_method AS news_render_method_4, p0_.news_render_count AS news_render_count_5, p0_.page_id AS page_id_6 FROM page_content p0_ WHERE p0_.page_id = 4 AND p0_.content_type = 'BlockSubpage';

SELECT 
  t0.value AS value_1, 
  t0.name AS name_2, 
  t0.priority AS priority_3, 
  t0.id AS id_4, 
  t0.attribute_type_id AS attribute_type_id_5 
FROM 
  realpad_attribute_type_enums t0 
WHERE 
  t0.attribute_type_id = ?

SELECT t0.value AS value_1, t0.name AS name_2, t0.priority AS priority_3, t0.id AS id_4, t0.attribute_type_id AS attribute_type_id_5 FROM realpad_attribute_type_enums t0 WHERE t0.attribute_type_id = 10;

SELECT 
  t0.key AS key_1, 
  t0.type AS type_2, 
  t0.name AS name_3, 
  t0.id AS id_4 
FROM 
  realpad_attribute_types t0

SELECT t0.key AS key_1, t0.type AS type_2, t0.name AS name_3, t0.id AS id_4 FROM realpad_attribute_types t0;

SELECT 
  p0_.id AS id_0, 
  p0_.image_name AS image_name_1, 
  p0_.imageSize AS imagesize_2, 
  p0_.type AS type_3, 
  p0_.slug AS slug_4, 
  p0_.seo_title AS seo_title_5, 
  p0_.seo_description AS seo_description_6, 
  p0_.published AS published_7, 
  p0_.breadcrumbs AS breadcrumbs_8, 
  p0_.news_media_type AS news_media_type_9, 
  p0_.news_to_date AS news_to_date_10, 
  p0_.updated_at AS updated_at_11, 
  p0_.header AS header_12, 
  p0_.units_filter AS units_filter_13, 
  p0_.newsletter AS newsletter_14, 
  p0_.footer AS footer_15, 
  p0_.parent_page_id AS parent_page_id_16, 
  p0_.project_portal_id AS project_portal_id_17, 
  p0_.unit_content_page AS unit_content_page_18, 
  p0_.banner_id AS banner_id_19 
FROM 
  page p0_ 
WHERE 
  p0_.published = true 
  AND p0_.type = ? 
LIMIT 
  1

SELECT p0_.id AS id_0, p0_.image_name AS image_name_1, p0_.imageSize AS imagesize_2, p0_.type AS type_3, p0_.slug AS slug_4, p0_.seo_title AS seo_title_5, p0_.seo_description AS seo_description_6, p0_.published AS published_7, p0_.breadcrumbs AS breadcrumbs_8, p0_.news_media_type AS news_media_type_9, p0_.news_to_date AS news_to_date_10, p0_.updated_at AS updated_at_11, p0_.header AS header_12, p0_.units_filter AS units_filter_13, p0_.newsletter AS newsletter_14, p0_.footer AS footer_15, p0_.parent_page_id AS parent_page_id_16, p0_.project_portal_id AS project_portal_id_17, p0_.unit_content_page AS unit_content_page_18, p0_.banner_id AS banner_id_19 FROM page p0_ WHERE p0_.published = true AND p0_.type = 'homepage' LIMIT 1;