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 
  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 = 3 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.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.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 
  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.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 
  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 = ? 
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 = 'homepage' LIMIT 1;

SELECT 
  t0.id AS id_1, 
  t0.text AS text_2, 
  t0.locale AS locale_3, 
  t0.translatable_id AS translatable_id_4 
FROM 
  block_richtext_translation t0 
WHERE 
  t0.translatable_id = ? 
  AND (
    (t0.locale = 'cs')
  )

SELECT t0.id AS id_1, t0.text AS text_2, t0.locale AS locale_3, t0.translatable_id AS translatable_id_4 FROM block_richtext_translation t0 WHERE t0.translatable_id = 29 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 = ? 
  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 
  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.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.id AS id_1, 
  t0.title AS title_2, 
  t0.locale AS locale_3, 
  t0.translatable_id AS translatable_id_4 
FROM 
  attribute_value_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_value_translation t0 WHERE t0.translatable_id = 6431 AND ((t0.locale = 'cs'));

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_.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 
  h0_.id AS id_0, 
  h0_.location AS location_1, 
  h0_.category AS category_2, 
  h0_.image_name AS image_name_3, 
  h0_.imageSize AS imagesize_4, 
  h0_.link AS link_5, 
  h0_.label_color AS label_color_6, 
  h0_.sort_order AS sort_order_7, 
  h0_.published AS published_8 
FROM 
  homepage_tile h0_ 
WHERE 
  h0_.published = true 
ORDER BY 
  h0_.sort_order ASC

SELECT h0_.id AS id_0, h0_.location AS location_1, h0_.category AS category_2, h0_.image_name AS image_name_3, h0_.imageSize AS imagesize_4, h0_.link AS link_5, h0_.label_color AS label_color_6, h0_.sort_order AS sort_order_7, h0_.published AS published_8 FROM homepage_tile h0_ WHERE h0_.published = true ORDER BY h0_.sort_order ASC;

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 
  t0.id AS id_1, 
  t0.value AS value_2, 
  t0.attribute_id AS attribute_id_3 
FROM 
  attribute_value t0 
WHERE 
  t0.attribute_id = ? 
ORDER BY 
  t0.value ASC

SELECT t0.id AS id_1, t0.value AS value_2, t0.attribute_id AS attribute_id_3 FROM attribute_value t0 WHERE t0.attribute_id = 674 ORDER BY t0.value ASC;

SELECT 
  t0.id AS id_1, 
  t0.key AS key_2, 
  t0.type AS type_3, 
  t0.required AS required_4, 
  t0.filterable AS filterable_5 
FROM 
  attribute t0 
WHERE 
  t0.key = ? 
LIMIT 
  1

SELECT t0.id AS id_1, t0.key AS key_2, t0.type AS type_3, t0.required AS required_4, t0.filterable AS filterable_5 FROM attribute t0 WHERE t0.key = 'flat_type' LIMIT 1;

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

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;

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 = 3 AND p0_.content_type = 'BlockSubpage';

SELECT 
  DISTINCT p0_.year AS year_0 
FROM 
  project_portal p0_ 
WHERE 
  p0_.year > 2000 
ORDER BY 
  p0_.year ASC

SELECT DISTINCT p0_.year AS year_0 FROM project_portal p0_ WHERE p0_.year > 2000 ORDER BY p0_.year ASC;

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 = ?

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 = 3;