Symfony Profiler

SELECT
  COUNT(DISTINCT o0_.id) AS sclr_0
FROM
  openform_search o0_
  LEFT JOIN openform_search_translation o1_ ON o0_.id = o1_.translatable_id
WHERE
  o0_.stat = 1
  AND (
    o1_.title IS NOT NULL
    AND o1_.title <> ''
    AND o1_.lang = ?
  )
  AND o1_.properties_fields LIKE ?
ORDER BY
  o0_.ord DESC

SELECT COUNT(DISTINCT o0_.id) AS sclr_0 FROM openform_search o0_ LEFT JOIN openform_search_translation o1_ ON o0_.id = o1_.translatable_id WHERE o0_.stat = 1 AND (o1_.title IS NOT NULL AND o1_.title <> '' AND o1_.lang = 'pl') AND o1_.properties_fields LIKE '%age|15%' ORDER BY o0_.ord DESC;

SELECT
  o0_.id AS id_0,
  o0_.created_at AS created_at_1,
  o0_.updated_at AS updated_at_2,
  o0_.stat AS stat_3,
  o0_.ord AS ord_4,
  o0_.entity_name AS entity_name_5,
  o0_.range_path AS range_path_6,
  o0_.root_parent AS root_parent_7,
  o0_.root_parent_id AS root_parent_id_8,
  o1_.id AS id_9,
  o1_.created_at AS created_at_10,
  o1_.updated_at AS updated_at_11,
  o1_.translatable_id AS translatable_id_12,
  o1_.lang AS lang_13,
  o1_.title AS title_14,
  o1_.text AS text_15,
  o1_.properties_fields AS properties_fields_16,
  o0_.page_id AS page_id_17,
  o0_.menu_page_id AS menu_page_id_18,
  o0_.news_id AS news_id_19,
  o0_.museum_id AS museum_id_20,
  o0_.museum_department_id AS museum_department_id_21,
  o0_.archive_id AS archive_id_22,
  o0_.archive_department_id AS archive_department_id_23,
  o0_.private_collection_id AS private_collection_id_24,
  o0_.private_collection_department_id AS private_collection_department_id_25,
  o0_.proposal_id AS proposal_id_26,
  o0_.antique_id AS antique_id_27,
  o0_.antique_suit_id AS antique_suit_id_28,
  o0_.relict_id AS relict_id_29,
  o0_.relict_pack_id AS relict_pack_id_30,
  o0_.about_us_id AS about_us_id_31,
  o0_.mission_id AS mission_id_32,
  o0_.exhibition_id AS exhibition_id_33,
  o0_.exhibition_department_id AS exhibition_department_id_34,
  o1_.translatable_id AS translatable_id_35
FROM
  openform_search o0_
  LEFT JOIN openform_search_translation o1_ ON o0_.id = o1_.translatable_id
WHERE
  o0_.stat = 1
  AND (
    o1_.title IS NOT NULL
    AND o1_.title <> ''
    AND o1_.lang = ?
  )
  AND o1_.properties_fields LIKE ?
GROUP BY
  o0_.id,
  o0_.created_at,
  o0_.updated_at,
  o0_.stat,
  o0_.ord,
  o0_.entity_name,
  o0_.range_path,
  o0_.root_parent,
  o0_.root_parent_id,
  o0_.page_id,
  o0_.menu_page_id,
  o0_.news_id,
  o0_.museum_id,
  o0_.museum_department_id,
  o0_.archive_id,
  o0_.archive_department_id,
  o0_.private_collection_id,
  o0_.private_collection_department_id,
  o0_.proposal_id,
  o0_.antique_id,
  o0_.antique_suit_id,
  o0_.relict_id,
  o0_.relict_pack_id,
  o0_.about_us_id,
  o0_.mission_id,
  o0_.exhibition_id,
  o0_.exhibition_department_id
ORDER BY
  o0_.ord DESC
LIMIT
  10

SELECT o0_.id AS id_0, o0_.created_at AS created_at_1, o0_.updated_at AS updated_at_2, o0_.stat AS stat_3, o0_.ord AS ord_4, o0_.entity_name AS entity_name_5, o0_.range_path AS range_path_6, o0_.root_parent AS root_parent_7, o0_.root_parent_id AS root_parent_id_8, o1_.id AS id_9, o1_.created_at AS created_at_10, o1_.updated_at AS updated_at_11, o1_.translatable_id AS translatable_id_12, o1_.lang AS lang_13, o1_.title AS title_14, o1_.text AS text_15, o1_.properties_fields AS properties_fields_16, o0_.page_id AS page_id_17, o0_.menu_page_id AS menu_page_id_18, o0_.news_id AS news_id_19, o0_.museum_id AS museum_id_20, o0_.museum_department_id AS museum_department_id_21, o0_.archive_id AS archive_id_22, o0_.archive_department_id AS archive_department_id_23, o0_.private_collection_id AS private_collection_id_24, o0_.private_collection_department_id AS private_collection_department_id_25, o0_.proposal_id AS proposal_id_26, o0_.antique_id AS antique_id_27, o0_.antique_suit_id AS antique_suit_id_28, o0_.relict_id AS relict_id_29, o0_.relict_pack_id AS relict_pack_id_30, o0_.about_us_id AS about_us_id_31, o0_.mission_id AS mission_id_32, o0_.exhibition_id AS exhibition_id_33, o0_.exhibition_department_id AS exhibition_department_id_34, o1_.translatable_id AS translatable_id_35 FROM openform_search o0_ LEFT JOIN openform_search_translation o1_ ON o0_.id = o1_.translatable_id WHERE o0_.stat = 1 AND (o1_.title IS NOT NULL AND o1_.title <> '' AND o1_.lang = 'pl') AND o1_.properties_fields LIKE '%age|15%' GROUP BY o0_.id, o0_.created_at, o0_.updated_at, o0_.stat, o0_.ord, o0_.entity_name, o0_.range_path, o0_.root_parent, o0_.root_parent_id, o0_.page_id, o0_.menu_page_id, o0_.news_id, o0_.museum_id, o0_.museum_department_id, o0_.archive_id, o0_.archive_department_id, o0_.private_collection_id, o0_.private_collection_department_id, o0_.proposal_id, o0_.antique_id, o0_.antique_suit_id, o0_.relict_id, o0_.relict_pack_id, o0_.about_us_id, o0_.mission_id, o0_.exhibition_id, o0_.exhibition_department_id ORDER BY o0_.ord DESC LIMIT 10;

SELECT
  COUNT(DISTINCT o0_.id) AS sclr_0
FROM
  openform_search o0_
  LEFT JOIN openform_search_translation o1_ ON o0_.id = o1_.translatable_id
WHERE
  o0_.stat = 1
  AND (
    o1_.title IS NOT NULL
    AND o1_.title <> ''
    AND o1_.lang = ?
  )
  AND (
    (
      (
        o0_.root_parent = 'Museum'
        AND o0_.root_parent_id IN (?)
      )
    )
  )
  AND o1_.properties_fields LIKE ?
ORDER BY
  o0_.ord DESC

SELECT COUNT(DISTINCT o0_.id) AS sclr_0 FROM openform_search o0_ LEFT JOIN openform_search_translation o1_ ON o0_.id = o1_.translatable_id WHERE o0_.stat = 1 AND (o1_.title IS NOT NULL AND o1_.title <> '' AND o1_.lang = 'pl') AND (((o0_.root_parent = 'Museum' AND o0_.root_parent_id IN (3)))) AND o1_.properties_fields LIKE '%age|15%' ORDER BY o0_.ord DESC;

SELECT
  COUNT(DISTINCT o0_.id) AS sclr_0
FROM
  openform_search o0_
  LEFT JOIN openform_search_translation o1_ ON o0_.id = o1_.translatable_id
WHERE
  o0_.stat = 1
  AND (
    o1_.title IS NOT NULL
    AND o1_.title <> ''
    AND o1_.lang = ?
  )
  AND (o0_.root_parent = 'Exhibition')
  AND o1_.properties_fields LIKE ?
ORDER BY
  o0_.ord DESC

SELECT COUNT(DISTINCT o0_.id) AS sclr_0 FROM openform_search o0_ LEFT JOIN openform_search_translation o1_ ON o0_.id = o1_.translatable_id WHERE o0_.stat = 1 AND (o1_.title IS NOT NULL AND o1_.title <> '' AND o1_.lang = 'pl') AND (o0_.root_parent = 'Exhibition') AND o1_.properties_fields LIKE '%age|15%' ORDER BY o0_.ord DESC;

SELECT
  COUNT(DISTINCT o0_.id) AS sclr_0
FROM
  openform_search o0_
  LEFT JOIN openform_search_translation o1_ ON o0_.id = o1_.translatable_id
WHERE
  o0_.stat = 1
  AND (
    o1_.title IS NOT NULL
    AND o1_.title <> ''
    AND o1_.lang = ?
  )
  AND (o0_.root_parent = 'Museum')
  AND o1_.properties_fields LIKE ?
ORDER BY
  o0_.ord DESC

SELECT COUNT(DISTINCT o0_.id) AS sclr_0 FROM openform_search o0_ LEFT JOIN openform_search_translation o1_ ON o0_.id = o1_.translatable_id WHERE o0_.stat = 1 AND (o1_.title IS NOT NULL AND o1_.title <> '' AND o1_.lang = 'pl') AND (o0_.root_parent = 'Museum') AND o1_.properties_fields LIKE '%age|15%' ORDER BY o0_.ord DESC;

SELECT
  COUNT(DISTINCT o0_.id) AS sclr_0
FROM
  openform_search o0_
  LEFT JOIN openform_search_translation o1_ ON o0_.id = o1_.translatable_id
WHERE
  o0_.stat = 1
  AND (
    o1_.title IS NOT NULL
    AND o1_.title <> ''
    AND o1_.lang = ?
  )
  AND (
    (
      (
        o0_.root_parent = 'Exhibition'
        AND o0_.root_parent_id IN (?)
      )
    )
  )
  AND o1_.properties_fields LIKE ?
ORDER BY
  o0_.ord DESC

SELECT COUNT(DISTINCT o0_.id) AS sclr_0 FROM openform_search o0_ LEFT JOIN openform_search_translation o1_ ON o0_.id = o1_.translatable_id WHERE o0_.stat = 1 AND (o1_.title IS NOT NULL AND o1_.title <> '' AND o1_.lang = 'pl') AND (((o0_.root_parent = 'Exhibition' AND o0_.root_parent_id IN (11)))) AND o1_.properties_fields LIKE '%age|15%' ORDER BY o0_.ord DESC;

SELECT
  o0_.id AS id_0,
  o0_.created_at AS created_at_1,
  o0_.updated_at AS updated_at_2,
  o0_.stat AS stat_3,
  o0_.ord AS ord_4,
  o0_.image_path AS image_path_5,
  o0_.publish_date AS publish_date_6,
  o0_.menu_variant AS menu_variant_7,
  o0_.logo_visible AS logo_visible_8,
  o0_.background AS background_9,
  o0_.header_background AS header_background_10,
  o0_.show_header AS show_header_11,
  o0_.header_height AS header_height_12,
  o1_.id AS id_13,
  o1_.created_at AS created_at_14,
  o1_.updated_at AS updated_at_15,
  o1_.translatable_id AS translatable_id_16,
  o1_.lang AS lang_17,
  o1_.meta_title AS meta_title_18,
  o1_.meta_description AS meta_description_19,
  o1_.meta_keywords AS meta_keywords_20,
  o1_.title AS title_21,
  o1_.slug AS slug_22,
  o1_.title_html AS title_html_23,
  o1_.text AS text_24,
  o1_.short_lead AS short_lead_25,
  o1_.alt AS alt_26,
  o1_.translatable_id AS translatable_id_27
FROM
  openform_archive o0_
  LEFT JOIN openform_archive_translation o1_ ON o0_.id = o1_.translatable_id
WHERE
  o0_.stat = 1
  AND (
    o1_.lang = ?
    AND o1_.title IS NOT NULL
    AND o1_.slug IS NOT NULL
  )
ORDER BY
  o1_.title ASC

SELECT o0_.id AS id_0, o0_.created_at AS created_at_1, o0_.updated_at AS updated_at_2, o0_.stat AS stat_3, o0_.ord AS ord_4, o0_.image_path AS image_path_5, o0_.publish_date AS publish_date_6, o0_.menu_variant AS menu_variant_7, o0_.logo_visible AS logo_visible_8, o0_.background AS background_9, o0_.header_background AS header_background_10, o0_.show_header AS show_header_11, o0_.header_height AS header_height_12, o1_.id AS id_13, o1_.created_at AS created_at_14, o1_.updated_at AS updated_at_15, o1_.translatable_id AS translatable_id_16, o1_.lang AS lang_17, o1_.meta_title AS meta_title_18, o1_.meta_description AS meta_description_19, o1_.meta_keywords AS meta_keywords_20, o1_.title AS title_21, o1_.slug AS slug_22, o1_.title_html AS title_html_23, o1_.text AS text_24, o1_.short_lead AS short_lead_25, o1_.alt AS alt_26, o1_.translatable_id AS translatable_id_27 FROM openform_archive o0_ LEFT JOIN openform_archive_translation o1_ ON o0_.id = o1_.translatable_id WHERE o0_.stat = 1 AND (o1_.lang = 'pl' AND o1_.title IS NOT NULL AND o1_.slug IS NOT NULL) ORDER BY o1_.title ASC;

SELECT
  o0_.id AS id_0,
  o0_.created_at AS created_at_1,
  o0_.updated_at AS updated_at_2,
  o0_.stat AS stat_3,
  o0_.ord AS ord_4,
  o0_.image_path AS image_path_5,
  o0_.publish_date AS publish_date_6,
  o0_.menu_variant AS menu_variant_7,
  o0_.logo_visible AS logo_visible_8,
  o0_.background AS background_9,
  o0_.header_background AS header_background_10,
  o0_.show_header AS show_header_11,
  o0_.header_height AS header_height_12,
  o1_.id AS id_13,
  o1_.created_at AS created_at_14,
  o1_.updated_at AS updated_at_15,
  o1_.translatable_id AS translatable_id_16,
  o1_.lang AS lang_17,
  o1_.meta_title AS meta_title_18,
  o1_.meta_description AS meta_description_19,
  o1_.meta_keywords AS meta_keywords_20,
  o1_.title AS title_21,
  o1_.slug AS slug_22,
  o1_.title_html AS title_html_23,
  o1_.text AS text_24,
  o1_.short_lead AS short_lead_25,
  o1_.alt AS alt_26,
  o1_.translatable_id AS translatable_id_27
FROM
  openform_private_collection o0_
  LEFT JOIN openform_private_collection_translation o1_ ON o0_.id = o1_.translatable_id
WHERE
  o0_.stat = 1
  AND (
    o1_.lang = ?
    AND o1_.title IS NOT NULL
    AND o1_.slug IS NOT NULL
  )
ORDER BY
  o1_.title ASC

SELECT o0_.id AS id_0, o0_.created_at AS created_at_1, o0_.updated_at AS updated_at_2, o0_.stat AS stat_3, o0_.ord AS ord_4, o0_.image_path AS image_path_5, o0_.publish_date AS publish_date_6, o0_.menu_variant AS menu_variant_7, o0_.logo_visible AS logo_visible_8, o0_.background AS background_9, o0_.header_background AS header_background_10, o0_.show_header AS show_header_11, o0_.header_height AS header_height_12, o1_.id AS id_13, o1_.created_at AS created_at_14, o1_.updated_at AS updated_at_15, o1_.translatable_id AS translatable_id_16, o1_.lang AS lang_17, o1_.meta_title AS meta_title_18, o1_.meta_description AS meta_description_19, o1_.meta_keywords AS meta_keywords_20, o1_.title AS title_21, o1_.slug AS slug_22, o1_.title_html AS title_html_23, o1_.text AS text_24, o1_.short_lead AS short_lead_25, o1_.alt AS alt_26, o1_.translatable_id AS translatable_id_27 FROM openform_private_collection o0_ LEFT JOIN openform_private_collection_translation o1_ ON o0_.id = o1_.translatable_id WHERE o0_.stat = 1 AND (o1_.lang = 'pl' AND o1_.title IS NOT NULL AND o1_.slug IS NOT NULL) ORDER BY o1_.title ASC;

SELECT
  o0_.id AS id_0,
  o0_.created_at AS created_at_1,
  o0_.updated_at AS updated_at_2,
  o0_.stat AS stat_3,
  o0_.ord AS ord_4,
  o0_.image_path AS image_path_5,
  o0_.publish_date AS publish_date_6,
  o0_.background AS background_7,
  o0_.show_header AS show_header_8,
  o0_.header_height AS header_height_9,
  o0_.logo_visible AS logo_visible_10,
  o0_.header_background AS header_background_11,
  o1_.id AS id_12,
  o1_.created_at AS created_at_13,
  o1_.updated_at AS updated_at_14,
  o1_.translatable_id AS translatable_id_15,
  o1_.lang AS lang_16,
  o1_.meta_title AS meta_title_17,
  o1_.meta_description AS meta_description_18,
  o1_.meta_keywords AS meta_keywords_19,
  o1_.title AS title_20,
  o1_.slug AS slug_21,
  o1_.title_html AS title_html_22,
  o1_.text AS text_23,
  o1_.short_lead AS short_lead_24,
  o1_.alt AS alt_25,
  o1_.translatable_id AS translatable_id_26
FROM
  openform_exhibition o0_
  LEFT JOIN openform_exhibition_translation o1_ ON o0_.id = o1_.translatable_id
WHERE
  o0_.stat = 1
  AND (
    o1_.lang = ?
    AND o1_.title IS NOT NULL
    AND o1_.slug IS NOT NULL
  )
ORDER BY
  o1_.title ASC

SELECT o0_.id AS id_0, o0_.created_at AS created_at_1, o0_.updated_at AS updated_at_2, o0_.stat AS stat_3, o0_.ord AS ord_4, o0_.image_path AS image_path_5, o0_.publish_date AS publish_date_6, o0_.background AS background_7, o0_.show_header AS show_header_8, o0_.header_height AS header_height_9, o0_.logo_visible AS logo_visible_10, o0_.header_background AS header_background_11, o1_.id AS id_12, o1_.created_at AS created_at_13, o1_.updated_at AS updated_at_14, o1_.translatable_id AS translatable_id_15, o1_.lang AS lang_16, o1_.meta_title AS meta_title_17, o1_.meta_description AS meta_description_18, o1_.meta_keywords AS meta_keywords_19, o1_.title AS title_20, o1_.slug AS slug_21, o1_.title_html AS title_html_22, o1_.text AS text_23, o1_.short_lead AS short_lead_24, o1_.alt AS alt_25, o1_.translatable_id AS translatable_id_26 FROM openform_exhibition o0_ LEFT JOIN openform_exhibition_translation o1_ ON o0_.id = o1_.translatable_id WHERE o0_.stat = 1 AND (o1_.lang = 'pl' AND o1_.title IS NOT NULL AND o1_.slug IS NOT NULL) ORDER BY o1_.title ASC;

SELECT
  COUNT(DISTINCT o0_.id) AS sclr_0
FROM
  openform_search o0_
  LEFT JOIN openform_search_translation o1_ ON o0_.id = o1_.translatable_id
WHERE
  o0_.stat = 1
  AND (
    o1_.title IS NOT NULL
    AND o1_.title <> ''
    AND o1_.lang = ?
  )
  AND (
    (
      (
        o0_.root_parent = 'Archive'
        AND o0_.root_parent_id IN (?)
      )
    )
  )
  AND o1_.properties_fields LIKE ?
ORDER BY
  o0_.ord DESC

SELECT COUNT(DISTINCT o0_.id) AS sclr_0 FROM openform_search o0_ LEFT JOIN openform_search_translation o1_ ON o0_.id = o1_.translatable_id WHERE o0_.stat = 1 AND (o1_.title IS NOT NULL AND o1_.title <> '' AND o1_.lang = 'pl') AND (((o0_.root_parent = 'Archive' AND o0_.root_parent_id IN (1)))) AND o1_.properties_fields LIKE '%age|15%' ORDER BY o0_.ord DESC;

SELECT
  o0_.id AS id_0,
  o0_.created_at AS created_at_1,
  o0_.updated_at AS updated_at_2,
  o0_.stat AS stat_3,
  o0_.ord AS ord_4,
  o0_.image_path AS image_path_5,
  o0_.publish_date AS publish_date_6,
  o0_.menu_variant AS menu_variant_7,
  o0_.logo_visible AS logo_visible_8,
  o0_.background AS background_9,
  o0_.header_background AS header_background_10,
  o0_.show_header AS show_header_11,
  o0_.header_height AS header_height_12,
  o1_.id AS id_13,
  o1_.created_at AS created_at_14,
  o1_.updated_at AS updated_at_15,
  o1_.translatable_id AS translatable_id_16,
  o1_.lang AS lang_17,
  o1_.meta_title AS meta_title_18,
  o1_.meta_description AS meta_description_19,
  o1_.meta_keywords AS meta_keywords_20,
  o1_.title AS title_21,
  o1_.slug AS slug_22,
  o1_.title_html AS title_html_23,
  o1_.text AS text_24,
  o1_.short_lead AS short_lead_25,
  o1_.alt AS alt_26,
  o1_.translatable_id AS translatable_id_27
FROM
  openform_museum o0_
  LEFT JOIN openform_museum_translation o1_ ON o0_.id = o1_.translatable_id
WHERE
  o0_.stat = 1
  AND (
    o1_.lang = ?
    AND o1_.title IS NOT NULL
    AND o1_.slug IS NOT NULL
  )
ORDER BY
  o1_.title ASC

SELECT o0_.id AS id_0, o0_.created_at AS created_at_1, o0_.updated_at AS updated_at_2, o0_.stat AS stat_3, o0_.ord AS ord_4, o0_.image_path AS image_path_5, o0_.publish_date AS publish_date_6, o0_.menu_variant AS menu_variant_7, o0_.logo_visible AS logo_visible_8, o0_.background AS background_9, o0_.header_background AS header_background_10, o0_.show_header AS show_header_11, o0_.header_height AS header_height_12, o1_.id AS id_13, o1_.created_at AS created_at_14, o1_.updated_at AS updated_at_15, o1_.translatable_id AS translatable_id_16, o1_.lang AS lang_17, o1_.meta_title AS meta_title_18, o1_.meta_description AS meta_description_19, o1_.meta_keywords AS meta_keywords_20, o1_.title AS title_21, o1_.slug AS slug_22, o1_.title_html AS title_html_23, o1_.text AS text_24, o1_.short_lead AS short_lead_25, o1_.alt AS alt_26, o1_.translatable_id AS translatable_id_27 FROM openform_museum o0_ LEFT JOIN openform_museum_translation o1_ ON o0_.id = o1_.translatable_id WHERE o0_.stat = 1 AND (o1_.lang = 'pl' AND o1_.title IS NOT NULL AND o1_.slug IS NOT NULL) ORDER BY o1_.title ASC;

SELECT
  o0_.id AS id_0,
  o0_.created_at AS created_at_1,
  o0_.updated_at AS updated_at_2,
  o0_.stat AS stat_3,
  o0_.ord AS ord_4,
  o0_.image_path AS image_path_5,
  o0_.parent_id AS parent_id_6,
  o0_.admin_module_id AS admin_module_id_7,
  o0_.idname AS idname_8,
  o0_.is_not_searchable AS is_not_searchable_9,
  o0_.statable AS statable_10,
  o0_.editable AS editable_11,
  o0_.deletable AS deletable_12,
  o0_.subpageable AS subpageable_13,
  o0_.main_menu AS main_menu_14,
  o0_.main_menu_column AS main_menu_column_15,
  o0_.blank AS blank_16,
  o0_.foot_menu AS foot_menu_17,
  o0_.foot_menu_ord AS foot_menu_ord_18,
  o0_.foot_menu2 AS foot_menu2_19,
  o0_.foot_menu2ord AS foot_menu2ord_20,
  o0_.background AS background_21,
  o0_.show_children AS show_children_22,
  o0_.template_id AS template_id_23,
  o0_.main_content_padding_top AS main_content_padding_top_24,
  o0_.main_content_padding_bottom AS main_content_padding_bottom_25,
  o1_.id AS id_26,
  o1_.created_at AS created_at_27,
  o1_.updated_at AS updated_at_28,
  o1_.translatable_id AS translatable_id_29,
  o1_.lang AS lang_30,
  o1_.meta_title AS meta_title_31,
  o1_.meta_description AS meta_description_32,
  o1_.meta_keywords AS meta_keywords_33,
  o1_.title AS title_34,
  o1_.slug AS slug_35,
  o1_.title_html AS title_html_36,
  o1_.text AS text_37,
  o1_.sub_title AS sub_title_38,
  o1_.short_lead AS short_lead_39,
  o1_.link AS link_40,
  o1_.alt AS alt_41,
  o0_.parent_id AS parent_id_42,
  o0_.admin_module_id AS admin_module_id_43,
  o1_.translatable_id AS translatable_id_44
FROM
  openform_page o0_
  LEFT JOIN openform_page_translation o1_ ON o0_.id = o1_.translatable_id
WHERE
  o0_.idname = ?
  AND (
    o1_.title IS NOT NULL
    AND o1_.title <> ''
  )
  AND o1_.lang = ?
  AND (
    o1_.slug IS NOT NULL
    AND o1_.slug <> ''
  )

SELECT o0_.id AS id_0, o0_.created_at AS created_at_1, o0_.updated_at AS updated_at_2, o0_.stat AS stat_3, o0_.ord AS ord_4, o0_.image_path AS image_path_5, o0_.parent_id AS parent_id_6, o0_.admin_module_id AS admin_module_id_7, o0_.idname AS idname_8, o0_.is_not_searchable AS is_not_searchable_9, o0_.statable AS statable_10, o0_.editable AS editable_11, o0_.deletable AS deletable_12, o0_.subpageable AS subpageable_13, o0_.main_menu AS main_menu_14, o0_.main_menu_column AS main_menu_column_15, o0_.blank AS blank_16, o0_.foot_menu AS foot_menu_17, o0_.foot_menu_ord AS foot_menu_ord_18, o0_.foot_menu2 AS foot_menu2_19, o0_.foot_menu2ord AS foot_menu2ord_20, o0_.background AS background_21, o0_.show_children AS show_children_22, o0_.template_id AS template_id_23, o0_.main_content_padding_top AS main_content_padding_top_24, o0_.main_content_padding_bottom AS main_content_padding_bottom_25, o1_.id AS id_26, o1_.created_at AS created_at_27, o1_.updated_at AS updated_at_28, o1_.translatable_id AS translatable_id_29, o1_.lang AS lang_30, o1_.meta_title AS meta_title_31, o1_.meta_description AS meta_description_32, o1_.meta_keywords AS meta_keywords_33, o1_.title AS title_34, o1_.slug AS slug_35, o1_.title_html AS title_html_36, o1_.text AS text_37, o1_.sub_title AS sub_title_38, o1_.short_lead AS short_lead_39, o1_.link AS link_40, o1_.alt AS alt_41, o0_.parent_id AS parent_id_42, o0_.admin_module_id AS admin_module_id_43, o1_.translatable_id AS translatable_id_44 FROM openform_page o0_ LEFT JOIN openform_page_translation o1_ ON o0_.id = o1_.translatable_id WHERE o0_.idname = 'page_search' AND (o1_.title IS NOT NULL AND o1_.title <> '') AND o1_.lang = 'pl' AND (o1_.slug IS NOT NULL AND o1_.slug <> '');

SELECT
  o0_.id AS id_0,
  o0_.created_at AS created_at_1,
  o0_.updated_at AS updated_at_2,
  o0_.stat AS stat_3,
  o0_.ord AS ord_4,
  o0_.image_path AS image_path_5,
  o0_.parent_id AS parent_id_6,
  o0_.admin_module_id AS admin_module_id_7,
  o0_.idname AS idname_8,
  o0_.is_not_searchable AS is_not_searchable_9,
  o0_.statable AS statable_10,
  o0_.editable AS editable_11,
  o0_.deletable AS deletable_12,
  o0_.subpageable AS subpageable_13,
  o0_.main_menu AS main_menu_14,
  o0_.main_menu_column AS main_menu_column_15,
  o0_.blank AS blank_16,
  o0_.foot_menu AS foot_menu_17,
  o0_.foot_menu_ord AS foot_menu_ord_18,
  o0_.foot_menu2 AS foot_menu2_19,
  o0_.foot_menu2ord AS foot_menu2ord_20,
  o0_.background AS background_21,
  o0_.show_children AS show_children_22,
  o0_.template_id AS template_id_23,
  o0_.main_content_padding_top AS main_content_padding_top_24,
  o0_.main_content_padding_bottom AS main_content_padding_bottom_25,
  o1_.id AS id_26,
  o1_.created_at AS created_at_27,
  o1_.updated_at AS updated_at_28,
  o1_.translatable_id AS translatable_id_29,
  o1_.lang AS lang_30,
  o1_.meta_title AS meta_title_31,
  o1_.meta_description AS meta_description_32,
  o1_.meta_keywords AS meta_keywords_33,
  o1_.title AS title_34,
  o1_.slug AS slug_35,
  o1_.title_html AS title_html_36,
  o1_.text AS text_37,
  o1_.sub_title AS sub_title_38,
  o1_.short_lead AS short_lead_39,
  o1_.link AS link_40,
  o1_.alt AS alt_41,
  o0_.parent_id AS parent_id_42,
  o0_.admin_module_id AS admin_module_id_43,
  o1_.translatable_id AS translatable_id_44
FROM
  openform_page o0_
  LEFT JOIN openform_page_translation o1_ ON o0_.id = o1_.translatable_id
WHERE
  o0_.stat = 1
  AND o0_.foot_menu = 1
  AND o1_.lang = ?
  AND o1_.title IS NOT NULL
  AND o1_.slug IS NOT NULL
ORDER BY
  o0_.foot_menu_ord ASC

SELECT o0_.id AS id_0, o0_.created_at AS created_at_1, o0_.updated_at AS updated_at_2, o0_.stat AS stat_3, o0_.ord AS ord_4, o0_.image_path AS image_path_5, o0_.parent_id AS parent_id_6, o0_.admin_module_id AS admin_module_id_7, o0_.idname AS idname_8, o0_.is_not_searchable AS is_not_searchable_9, o0_.statable AS statable_10, o0_.editable AS editable_11, o0_.deletable AS deletable_12, o0_.subpageable AS subpageable_13, o0_.main_menu AS main_menu_14, o0_.main_menu_column AS main_menu_column_15, o0_.blank AS blank_16, o0_.foot_menu AS foot_menu_17, o0_.foot_menu_ord AS foot_menu_ord_18, o0_.foot_menu2 AS foot_menu2_19, o0_.foot_menu2ord AS foot_menu2ord_20, o0_.background AS background_21, o0_.show_children AS show_children_22, o0_.template_id AS template_id_23, o0_.main_content_padding_top AS main_content_padding_top_24, o0_.main_content_padding_bottom AS main_content_padding_bottom_25, o1_.id AS id_26, o1_.created_at AS created_at_27, o1_.updated_at AS updated_at_28, o1_.translatable_id AS translatable_id_29, o1_.lang AS lang_30, o1_.meta_title AS meta_title_31, o1_.meta_description AS meta_description_32, o1_.meta_keywords AS meta_keywords_33, o1_.title AS title_34, o1_.slug AS slug_35, o1_.title_html AS title_html_36, o1_.text AS text_37, o1_.sub_title AS sub_title_38, o1_.short_lead AS short_lead_39, o1_.link AS link_40, o1_.alt AS alt_41, o0_.parent_id AS parent_id_42, o0_.admin_module_id AS admin_module_id_43, o1_.translatable_id AS translatable_id_44 FROM openform_page o0_ LEFT JOIN openform_page_translation o1_ ON o0_.id = o1_.translatable_id WHERE o0_.stat = 1 AND o0_.foot_menu = 1 AND o1_.lang = 'pl' AND o1_.title IS NOT NULL AND o1_.slug IS NOT NULL ORDER BY o0_.foot_menu_ord ASC;

SELECT
  COUNT(DISTINCT o0_.id) AS sclr_0
FROM
  openform_search o0_
  LEFT JOIN openform_search_translation o1_ ON o0_.id = o1_.translatable_id
WHERE
  o0_.stat = 1
  AND (
    o1_.title IS NOT NULL
    AND o1_.title <> ''
    AND o1_.lang = ?
  )
  AND (
    o0_.root_parent = 'PrivateCollection'
  )
  AND o1_.properties_fields LIKE ?
ORDER BY
  o0_.ord DESC

SELECT COUNT(DISTINCT o0_.id) AS sclr_0 FROM openform_search o0_ LEFT JOIN openform_search_translation o1_ ON o0_.id = o1_.translatable_id WHERE o0_.stat = 1 AND (o1_.title IS NOT NULL AND o1_.title <> '' AND o1_.lang = 'pl') AND (o0_.root_parent = 'PrivateCollection') AND o1_.properties_fields LIKE '%age|15%' ORDER BY o0_.ord DESC;

SELECT
  COUNT(DISTINCT o0_.id) AS sclr_0
FROM
  openform_search o0_
  LEFT JOIN openform_search_translation o1_ ON o0_.id = o1_.translatable_id
WHERE
  o0_.stat = 1
  AND (
    o1_.title IS NOT NULL
    AND o1_.title <> ''
    AND o1_.lang = ?
  )
  AND (
    (
      (
        o0_.root_parent = 'PrivateCollection'
        AND o0_.root_parent_id IN (?)
      )
    )
  )
  AND o1_.properties_fields LIKE ?
ORDER BY
  o0_.ord DESC

SELECT COUNT(DISTINCT o0_.id) AS sclr_0 FROM openform_search o0_ LEFT JOIN openform_search_translation o1_ ON o0_.id = o1_.translatable_id WHERE o0_.stat = 1 AND (o1_.title IS NOT NULL AND o1_.title <> '' AND o1_.lang = 'pl') AND (((o0_.root_parent = 'PrivateCollection' AND o0_.root_parent_id IN (2)))) AND o1_.properties_fields LIKE '%age|15%' ORDER BY o0_.ord DESC;

SELECT
  COUNT(DISTINCT o0_.id) AS sclr_0
FROM
  openform_search o0_
  LEFT JOIN openform_search_translation o1_ ON o0_.id = o1_.translatable_id
WHERE
  o0_.stat = 1
  AND (
    o1_.title IS NOT NULL
    AND o1_.title <> ''
    AND o1_.lang = ?
  )
  AND (o0_.root_parent = 'Archive')
  AND o1_.properties_fields LIKE ?
ORDER BY
  o0_.ord DESC