Symfony Profiler

SELECT
  j0_.native_title_sort_key AS native_title_sort_key_0,
  j0_.slug AS slug_1,
  j0_.import_slug AS import_slug_2,
  j0_.import_slug_en AS import_slug_en_3,
  j0_.sort_articles_by_ord AS sort_articles_by_ord_4,
  j0_.id AS id_5,
  j0_.uuid AS uuid_6,
  j0_.stat AS stat_7,
  j0_.ord AS ord_8,
  j0_.created_at AS created_at_9,
  j0_.updated_at AS updated_at_10,
  j0_.languages AS languages_11,
  j0_.native_language AS native_language_12,
  j0_.native_title AS native_title_13,
  j0_.is_archived AS is_archived_14,
  j0_.archived_at AS archived_at_15,
  j0_.import_id AS import_id_16,
  j0_.newest_new_issue_id AS newest_new_issue_id_17,
  j0_.created_by_id AS created_by_id_18,
  j0_.updated_by_id AS updated_by_id_19
FROM
  journals j0_
WHERE
  (
    j0_.slug = ?
    OR j0_.import_slug = ?
    OR j0_.import_slug_en = ?
  )
  AND j0_.stat = 1
LIMIT
  1

SELECT j0_.native_title_sort_key AS native_title_sort_key_0, j0_.slug AS slug_1, j0_.import_slug AS import_slug_2, j0_.import_slug_en AS import_slug_en_3, j0_.sort_articles_by_ord AS sort_articles_by_ord_4, j0_.id AS id_5, j0_.uuid AS uuid_6, j0_.stat AS stat_7, j0_.ord AS ord_8, j0_.created_at AS created_at_9, j0_.updated_at AS updated_at_10, j0_.languages AS languages_11, j0_.native_language AS native_language_12, j0_.native_title AS native_title_13, j0_.is_archived AS is_archived_14, j0_.archived_at AS archived_at_15, j0_.import_id AS import_id_16, j0_.newest_new_issue_id AS newest_new_issue_id_17, j0_.created_by_id AS created_by_id_18, j0_.updated_by_id AS updated_by_id_19 FROM journals j0_ WHERE (j0_.slug = 'lista-czasopism' OR j0_.import_slug = 'lista-czasopism' OR j0_.import_slug_en = 'lista-czasopism') AND j0_.stat = 1 LIMIT 1;

SELECT
  p0_.id_name AS id_name_0,
  p0_.is_statable AS is_statable_1,
  p0_.is_editable AS is_editable_2,
  p0_.is_deletable AS is_deletable_3,
  p0_.is_sub_pageable AS is_sub_pageable_4,
  p0_.main_menu AS main_menu_5,
  p0_.id AS id_6,
  p0_.uuid AS uuid_7,
  p0_.stat AS stat_8,
  p0_.ord AS ord_9,
  p0_.created_at AS created_at_10,
  p0_.updated_at AS updated_at_11,
  p0_.languages AS languages_12,
  p0_.native_language AS native_language_13,
  p0_.native_title AS native_title_14,
  p0_.import_id AS import_id_15,
  p1_.title AS title_16,
  p1_.description AS description_17,
  p1_.id AS id_18,
  p1_.uuid AS uuid_19,
  p1_.created_at AS created_at_20,
  p1_.updated_at AS updated_at_21,
  p1_.lang AS lang_22,
  p1_.meta_title AS meta_title_23,
  p1_.meta_description AS meta_description_24,
  p1_.meta_keywords AS meta_keywords_25,
  p1_.slug AS slug_26,
  p2_.url AS url_27,
  p2_.file_path AS file_path_28,
  p2_.property AS property_29,
  p2_.name AS name_30,
  p2_.type AS type_31,
  p2_.version AS version_32,
  p2_.width AS width_33,
  p2_.height AS height_34,
  p2_.crop_x AS crop_x_35,
  p2_.crop_y AS crop_y_36,
  p2_.crop_width AS crop_width_37,
  p2_.crop_height AS crop_height_38,
  p2_.id AS id_39,
  p2_.uuid AS uuid_40,
  p2_.created_at AS created_at_41,
  p2_.updated_at AS updated_at_42,
  p3_.type AS type_43,
  p3_.id AS id_44,
  p3_.uuid AS uuid_45,
  p3_.stat AS stat_46,
  p3_.ord AS ord_47,
  p3_.created_at AS created_at_48,
  p3_.updated_at AS updated_at_49,
  p4_.title AS title_50,
  p4_.text AS text_51,
  p4_.alt AS alt_52,
  p4_.media_position AS media_position_53,
  p4_.home_left_block_title AS home_left_block_title_54,
  p4_.home_left_block_text AS home_left_block_text_55,
  p4_.home_left_block_button_title AS home_left_block_button_title_56,
  p4_.home_left_block_button_link AS home_left_block_button_link_57,
  p4_.home_right_block_title AS home_right_block_title_58,
  p4_.home_right_block_text AS home_right_block_text_59,
  p4_.home_right_block_button_title AS home_right_block_button_title_60,
  p4_.home_right_block_button_link AS home_right_block_button_link_61,
  p4_.id AS id_62,
  p4_.uuid AS uuid_63,
  p4_.created_at AS created_at_64,
  p4_.updated_at AS updated_at_65,
  p4_.lang AS lang_66,
  p0_.parent_id AS parent_id_67,
  p0_.media_id AS media_id_68,
  p1_.parent_id AS parent_id_69,
  p2_.parent_id AS parent_id_70,
  p2_.template_id AS template_id_71,
  p3_.parent_id AS parent_id_72,
  p4_.media_id AS media_id_73,
  p4_.parent_id AS parent_id_74
FROM
  pages p0_
  LEFT JOIN page_translations p1_ ON p0_.id = p1_.parent_id
  AND (p1_.lang = ?)
  LEFT JOIN page_thumbs p2_ ON p0_.id = p2_.parent_id
  LEFT JOIN page_blocks p3_ ON p0_.id = p3_.parent_id
  AND (p3_.stat = 1)
  LEFT JOIN page_block_translations p4_ ON p3_.id = p4_.parent_id
  AND (p1_.lang = ?)
WHERE
  p0_.stat = 1
  AND p1_.slug = ?
  AND (
    p1_.title IS NOT NULL
    AND p1_.title <> ''
  )
ORDER BY
  p2_.property asc,
  p2_.name asc,
  p2_.type asc,
  p3_.ord desc

SELECT p0_.id_name AS id_name_0, p0_.is_statable AS is_statable_1, p0_.is_editable AS is_editable_2, p0_.is_deletable AS is_deletable_3, p0_.is_sub_pageable AS is_sub_pageable_4, p0_.main_menu AS main_menu_5, p0_.id AS id_6, p0_.uuid AS uuid_7, p0_.stat AS stat_8, p0_.ord AS ord_9, p0_.created_at AS created_at_10, p0_.updated_at AS updated_at_11, p0_.languages AS languages_12, p0_.native_language AS native_language_13, p0_.native_title AS native_title_14, p0_.import_id AS import_id_15, p1_.title AS title_16, p1_.description AS description_17, p1_.id AS id_18, p1_.uuid AS uuid_19, p1_.created_at AS created_at_20, p1_.updated_at AS updated_at_21, p1_.lang AS lang_22, p1_.meta_title AS meta_title_23, p1_.meta_description AS meta_description_24, p1_.meta_keywords AS meta_keywords_25, p1_.slug AS slug_26, p2_.url AS url_27, p2_.file_path AS file_path_28, p2_.property AS property_29, p2_.name AS name_30, p2_.type AS type_31, p2_.version AS version_32, p2_.width AS width_33, p2_.height AS height_34, p2_.crop_x AS crop_x_35, p2_.crop_y AS crop_y_36, p2_.crop_width AS crop_width_37, p2_.crop_height AS crop_height_38, p2_.id AS id_39, p2_.uuid AS uuid_40, p2_.created_at AS created_at_41, p2_.updated_at AS updated_at_42, p3_.type AS type_43, p3_.id AS id_44, p3_.uuid AS uuid_45, p3_.stat AS stat_46, p3_.ord AS ord_47, p3_.created_at AS created_at_48, p3_.updated_at AS updated_at_49, p4_.title AS title_50, p4_.text AS text_51, p4_.alt AS alt_52, p4_.media_position AS media_position_53, p4_.home_left_block_title AS home_left_block_title_54, p4_.home_left_block_text AS home_left_block_text_55, p4_.home_left_block_button_title AS home_left_block_button_title_56, p4_.home_left_block_button_link AS home_left_block_button_link_57, p4_.home_right_block_title AS home_right_block_title_58, p4_.home_right_block_text AS home_right_block_text_59, p4_.home_right_block_button_title AS home_right_block_button_title_60, p4_.home_right_block_button_link AS home_right_block_button_link_61, p4_.id AS id_62, p4_.uuid AS uuid_63, p4_.created_at AS created_at_64, p4_.updated_at AS updated_at_65, p4_.lang AS lang_66, p0_.parent_id AS parent_id_67, p0_.media_id AS media_id_68, p1_.parent_id AS parent_id_69, p2_.parent_id AS parent_id_70, p2_.template_id AS template_id_71, p3_.parent_id AS parent_id_72, p4_.media_id AS media_id_73, p4_.parent_id AS parent_id_74 FROM pages p0_ LEFT JOIN page_translations p1_ ON p0_.id = p1_.parent_id AND (p1_.lang = 'pl') LEFT JOIN page_thumbs p2_ ON p0_.id = p2_.parent_id LEFT JOIN page_blocks p3_ ON p0_.id = p3_.parent_id AND (p3_.stat = 1) LEFT JOIN page_block_translations p4_ ON p3_.id = p4_.parent_id AND (p1_.lang = 'pl') WHERE p0_.stat = 1 AND p1_.slug = 'lista-czasopism' AND (p1_.title IS NOT NULL AND p1_.title <> '') ORDER BY p2_.property asc, p2_.name asc, p2_.type asc, p3_.ord desc;

SELECT
  (
    SELECT
      COUNT(DISTINCT j0_.id) AS sclr_1
    FROM
      journals j0_
      LEFT JOIN journal_partners j1_ ON j0_.id = j1_.parent_id
      LEFT JOIN partners p2_ ON j1_.partner_id = p2_.id
    WHERE
      j0_.stat = 1
      AND j1_.stat = 1
      AND p2_.id = p3_.id
  ) AS sclr_0,
  p3_.id AS id_2,
  p3_.uuid AS uuid_3,
  p3_.stat AS stat_4,
  p3_.ord AS ord_5,
  p3_.created_at AS created_at_6,
  p3_.updated_at AS updated_at_7,
  p3_.languages AS languages_8,
  p3_.native_language AS native_language_9,
  p3_.native_title AS native_title_10,
  p4_.title AS title_11,
  p4_.alt AS alt_12,
  p4_.description AS description_13,
  p4_.id AS id_14,
  p4_.uuid AS uuid_15,
  p4_.created_at AS created_at_16,
  p4_.updated_at AS updated_at_17,
  p4_.lang AS lang_18,
  p4_.slug AS slug_19,
  p4_.parent_id AS parent_id_20,
  p4_.media_id AS media_id_21
FROM
  partners p3_
  LEFT JOIN partner_translations p4_ ON p3_.id = p4_.parent_id
  AND (
    p4_.lang = ?
    OR p4_.lang = p3_.native_language
  )
WHERE
  p3_.stat = 1
ORDER BY
  p3_.ord DESC

SELECT (SELECT COUNT(DISTINCT j0_.id) AS sclr_1 FROM journals j0_ LEFT JOIN journal_partners j1_ ON j0_.id = j1_.parent_id LEFT JOIN partners p2_ ON j1_.partner_id = p2_.id WHERE j0_.stat = 1 AND j1_.stat = 1 AND p2_.id = p3_.id) AS sclr_0, p3_.id AS id_2, p3_.uuid AS uuid_3, p3_.stat AS stat_4, p3_.ord AS ord_5, p3_.created_at AS created_at_6, p3_.updated_at AS updated_at_7, p3_.languages AS languages_8, p3_.native_language AS native_language_9, p3_.native_title AS native_title_10, p4_.title AS title_11, p4_.alt AS alt_12, p4_.description AS description_13, p4_.id AS id_14, p4_.uuid AS uuid_15, p4_.created_at AS created_at_16, p4_.updated_at AS updated_at_17, p4_.lang AS lang_18, p4_.slug AS slug_19, p4_.parent_id AS parent_id_20, p4_.media_id AS media_id_21 FROM partners p3_ LEFT JOIN partner_translations p4_ ON p3_.id = p4_.parent_id AND (p4_.lang = 'pl' OR p4_.lang = p3_.native_language) WHERE p3_.stat = 1 ORDER BY p3_.ord DESC;

SELECT
  GROUP_CONCAT(DISTINCT language SEPARATOR ',') AS unique_languages
FROM
  (
    SELECT
      SUBSTRING_INDEX(
        SUBSTRING_INDEX(
          publication_languages, ',', numbers.n
        ),
        ',',
        -1
      ) AS language
    FROM
      journal_datas CROSS
      JOIN (
        SELECT
          1 AS n
        UNION ALL
        SELECT
          2
        UNION ALL
        SELECT
          3
      ) numbers
    WHERE
      n <= 1 + (
        LENGTH(publication_languages) - LENGTH(
          REPLACE(publication_languages, ',', '')
        )
      )
  ) AS subquery;

SELECT GROUP_CONCAT(DISTINCT language SEPARATOR ',') AS unique_languages
            FROM (
                SELECT SUBSTRING_INDEX(SUBSTRING_INDEX(publication_languages, ',', numbers.n), ',', -1) AS language
                FROM journal_datas CROSS JOIN
                    (SELECT 1 AS n UNION ALL SELECT 2 UNION ALL SELECT 3) numbers
                WHERE n <= 1 + (LENGTH(publication_languages) - LENGTH(REPLACE(publication_languages, ',', '')))
            ) AS subquery;;

SELECT
  d0_.id AS id_0,
  d0_.uuid AS uuid_1,
  d0_.stat AS stat_2,
  d0_.ord AS ord_3,
  d0_.created_at AS created_at_4,
  d0_.updated_at AS updated_at_5,
  d0_.languages AS languages_6,
  d0_.native_language AS native_language_7,
  d0_.native_title AS native_title_8,
  d1_.title AS title_9,
  d1_.id AS id_10,
  d1_.uuid AS uuid_11,
  d1_.created_at AS created_at_12,
  d1_.updated_at AS updated_at_13,
  d1_.lang AS lang_14,
  d2_.id AS id_15,
  d2_.uuid AS uuid_16,
  d2_.stat AS stat_17,
  d2_.ord AS ord_18,
  d2_.created_at AS created_at_19,
  d2_.updated_at AS updated_at_20,
  d2_.languages AS languages_21,
  d2_.native_language AS native_language_22,
  d2_.native_title AS native_title_23,
  d3_.title AS title_24,
  d3_.id AS id_25,
  d3_.uuid AS uuid_26,
  d3_.created_at AS created_at_27,
  d3_.updated_at AS updated_at_28,
  d3_.lang AS lang_29,
  d0_.parent_id AS parent_id_30,
  d1_.parent_id AS parent_id_31,
  d2_.parent_id AS parent_id_32,
  d3_.parent_id AS parent_id_33
FROM
  domains d0_
  LEFT JOIN domain_translations d1_ ON d0_.id = d1_.parent_id
  AND (
    d1_.lang = ?
    OR d1_.lang = d0_.native_language
  )
  LEFT JOIN domains d2_ ON d0_.id = d2_.parent_id
  AND (d2_.stat = 1)
  LEFT JOIN domain_translations d3_ ON d2_.id = d3_.parent_id
WHERE
  d0_.stat = 1
  AND d0_.parent_id IS NULL
ORDER BY
  d0_.ord DESC,
  d2_.ord DESC

SELECT d0_.id AS id_0, d0_.uuid AS uuid_1, d0_.stat AS stat_2, d0_.ord AS ord_3, d0_.created_at AS created_at_4, d0_.updated_at AS updated_at_5, d0_.languages AS languages_6, d0_.native_language AS native_language_7, d0_.native_title AS native_title_8, d1_.title AS title_9, d1_.id AS id_10, d1_.uuid AS uuid_11, d1_.created_at AS created_at_12, d1_.updated_at AS updated_at_13, d1_.lang AS lang_14, d2_.id AS id_15, d2_.uuid AS uuid_16, d2_.stat AS stat_17, d2_.ord AS ord_18, d2_.created_at AS created_at_19, d2_.updated_at AS updated_at_20, d2_.languages AS languages_21, d2_.native_language AS native_language_22, d2_.native_title AS native_title_23, d3_.title AS title_24, d3_.id AS id_25, d3_.uuid AS uuid_26, d3_.created_at AS created_at_27, d3_.updated_at AS updated_at_28, d3_.lang AS lang_29, d0_.parent_id AS parent_id_30, d1_.parent_id AS parent_id_31, d2_.parent_id AS parent_id_32, d3_.parent_id AS parent_id_33 FROM domains d0_ LEFT JOIN domain_translations d1_ ON d0_.id = d1_.parent_id AND (d1_.lang = 'pl' OR d1_.lang = d0_.native_language) LEFT JOIN domains d2_ ON d0_.id = d2_.parent_id AND (d2_.stat = 1) LEFT JOIN domain_translations d3_ ON d2_.id = d3_.parent_id WHERE d0_.stat = 1 AND d0_.parent_id IS NULL ORDER BY d0_.ord DESC, d2_.ord DESC;

SELECT
  i0_.title AS title_0,
  i0_.show_in_journal_list AS show_in_journal_list_1,
  i0_.id AS id_2,
  i0_.uuid AS uuid_3,
  i0_.stat AS stat_4,
  i0_.ord AS ord_5,
  i0_.created_at AS created_at_6,
  i0_.updated_at AS updated_at_7,
  i0_.languages AS languages_8,
  i0_.native_language AS native_language_9,
  i0_.native_title AS native_title_10,
  i1_.alt AS alt_11,
  i1_.description AS description_12,
  i1_.id AS id_13,
  i1_.uuid AS uuid_14,
  i1_.created_at AS created_at_15,
  i1_.updated_at AS updated_at_16,
  i1_.lang AS lang_17,
  i1_.parent_id AS parent_id_18,
  i1_.media_id AS media_id_19
FROM
  indexation_databases i0_
  LEFT JOIN indexation_database_translations i1_ ON i0_.id = i1_.parent_id
  AND (
    i1_.lang = ?
    OR i1_.lang = i0_.native_language
  )
WHERE
  i0_.stat = 1
  AND i0_.show_in_journal_list = 1

SELECT i0_.title AS title_0, i0_.show_in_journal_list AS show_in_journal_list_1, i0_.id AS id_2, i0_.uuid AS uuid_3, i0_.stat AS stat_4, i0_.ord AS ord_5, i0_.created_at AS created_at_6, i0_.updated_at AS updated_at_7, i0_.languages AS languages_8, i0_.native_language AS native_language_9, i0_.native_title AS native_title_10, i1_.alt AS alt_11, i1_.description AS description_12, i1_.id AS id_13, i1_.uuid AS uuid_14, i1_.created_at AS created_at_15, i1_.updated_at AS updated_at_16, i1_.lang AS lang_17, i1_.parent_id AS parent_id_18, i1_.media_id AS media_id_19 FROM indexation_databases i0_ LEFT JOIN indexation_database_translations i1_ ON i0_.id = i1_.parent_id AND (i1_.lang = 'pl' OR i1_.lang = i0_.native_language) WHERE i0_.stat = 1 AND i0_.show_in_journal_list = 1;

SELECT
  p0_.id_name AS id_name_0,
  p0_.is_statable AS is_statable_1,
  p0_.is_editable AS is_editable_2,
  p0_.is_deletable AS is_deletable_3,
  p0_.is_sub_pageable AS is_sub_pageable_4,
  p0_.main_menu AS main_menu_5,
  p0_.id AS id_6,
  p0_.uuid AS uuid_7,
  p0_.stat AS stat_8,
  p0_.ord AS ord_9,
  p0_.created_at AS created_at_10,
  p0_.updated_at AS updated_at_11,
  p0_.languages AS languages_12,
  p0_.native_language AS native_language_13,
  p0_.native_title AS native_title_14,
  p0_.import_id AS import_id_15,
  p1_.title AS title_16,
  p1_.description AS description_17,
  p1_.id AS id_18,
  p1_.uuid AS uuid_19,
  p1_.created_at AS created_at_20,
  p1_.updated_at AS updated_at_21,
  p1_.lang AS lang_22,
  p1_.meta_title AS meta_title_23,
  p1_.meta_description AS meta_description_24,
  p1_.meta_keywords AS meta_keywords_25,
  p1_.slug AS slug_26,
  p2_.type AS type_27,
  p2_.id AS id_28,
  p2_.uuid AS uuid_29,
  p2_.stat AS stat_30,
  p2_.ord AS ord_31,
  p2_.created_at AS created_at_32,
  p2_.updated_at AS updated_at_33,
  p3_.title AS title_34,
  p3_.text AS text_35,
  p3_.alt AS alt_36,
  p3_.media_position AS media_position_37,
  p3_.home_left_block_title AS home_left_block_title_38,
  p3_.home_left_block_text AS home_left_block_text_39,
  p3_.home_left_block_button_title AS home_left_block_button_title_40,
  p3_.home_left_block_button_link AS home_left_block_button_link_41,
  p3_.home_right_block_title AS home_right_block_title_42,
  p3_.home_right_block_text AS home_right_block_text_43,
  p3_.home_right_block_button_title AS home_right_block_button_title_44,
  p3_.home_right_block_button_link AS home_right_block_button_link_45,
  p3_.id AS id_46,
  p3_.uuid AS uuid_47,
  p3_.created_at AS created_at_48,
  p3_.updated_at AS updated_at_49,
  p3_.lang AS lang_50,
  p0_.parent_id AS parent_id_51,
  p0_.media_id AS media_id_52,
  p1_.parent_id AS parent_id_53,
  p2_.parent_id AS parent_id_54,
  p3_.media_id AS media_id_55,
  p3_.parent_id AS parent_id_56
FROM
  pages p0_
  LEFT JOIN page_translations p1_ ON p0_.id = p1_.parent_id
  AND (p1_.lang = ?)
  LEFT JOIN page_blocks p2_ ON p0_.id = p2_.parent_id
  AND (p2_.stat = 1)
  LEFT JOIN page_block_translations p3_ ON p2_.id = p3_.parent_id
  AND (p1_.lang = ?)
WHERE
  p0_.id_name = ?
ORDER BY
  p2_.ord desc

SELECT p0_.id_name AS id_name_0, p0_.is_statable AS is_statable_1, p0_.is_editable AS is_editable_2, p0_.is_deletable AS is_deletable_3, p0_.is_sub_pageable AS is_sub_pageable_4, p0_.main_menu AS main_menu_5, p0_.id AS id_6, p0_.uuid AS uuid_7, p0_.stat AS stat_8, p0_.ord AS ord_9, p0_.created_at AS created_at_10, p0_.updated_at AS updated_at_11, p0_.languages AS languages_12, p0_.native_language AS native_language_13, p0_.native_title AS native_title_14, p0_.import_id AS import_id_15, p1_.title AS title_16, p1_.description AS description_17, p1_.id AS id_18, p1_.uuid AS uuid_19, p1_.created_at AS created_at_20, p1_.updated_at AS updated_at_21, p1_.lang AS lang_22, p1_.meta_title AS meta_title_23, p1_.meta_description AS meta_description_24, p1_.meta_keywords AS meta_keywords_25, p1_.slug AS slug_26, p2_.type AS type_27, p2_.id AS id_28, p2_.uuid AS uuid_29, p2_.stat AS stat_30, p2_.ord AS ord_31, p2_.created_at AS created_at_32, p2_.updated_at AS updated_at_33, p3_.title AS title_34, p3_.text AS text_35, p3_.alt AS alt_36, p3_.media_position AS media_position_37, p3_.home_left_block_title AS home_left_block_title_38, p3_.home_left_block_text AS home_left_block_text_39, p3_.home_left_block_button_title AS home_left_block_button_title_40, p3_.home_left_block_button_link AS home_left_block_button_link_41, p3_.home_right_block_title AS home_right_block_title_42, p3_.home_right_block_text AS home_right_block_text_43, p3_.home_right_block_button_title AS home_right_block_button_title_44, p3_.home_right_block_button_link AS home_right_block_button_link_45, p3_.id AS id_46, p3_.uuid AS uuid_47, p3_.created_at AS created_at_48, p3_.updated_at AS updated_at_49, p3_.lang AS lang_50, p0_.parent_id AS parent_id_51, p0_.media_id AS media_id_52, p1_.parent_id AS parent_id_53, p2_.parent_id AS parent_id_54, p3_.media_id AS media_id_55, p3_.parent_id AS parent_id_56 FROM pages p0_ LEFT JOIN page_translations p1_ ON p0_.id = p1_.parent_id AND (p1_.lang = 'pl') LEFT JOIN page_blocks p2_ ON p0_.id = p2_.parent_id AND (p2_.stat = 1) LEFT JOIN page_block_translations p3_ ON p2_.id = p3_.parent_id AND (p1_.lang = 'pl') WHERE p0_.id_name = 'page_faq' ORDER BY p2_.ord desc;

SELECT
  c0_.is_mourning_version_active AS is_mourning_version_active_0,
  c0_.home_journals_per_page AS home_journals_per_page_1,
  c0_.home_is_journals_alphabetical_asc_order AS home_is_journals_alphabetical_asc_order_2,
  c0_.home_is_unpublished_journals_excluded AS home_is_unpublished_journals_excluded_3,
  c0_.home_is_closed_journals_excluded AS home_is_closed_journals_excluded_4,
  c0_.home_is_unscientific_journals_excluded AS home_is_unscientific_journals_excluded_5,
  c0_.home_is_industry_journals_excluded AS home_is_industry_journals_excluded_6,
  c0_.alert_a_is_visible AS alert_a_is_visible_7,
  c0_.alert_a_type AS alert_a_type_8,
  c0_.alert_a_is_take_off_active AS alert_a_is_take_off_active_9,
  c0_.alert_a_take_off_date_time AS alert_a_take_off_date_time_10,
  c0_.alert_b_is_visible AS alert_b_is_visible_11,
  c0_.alert_b_type AS alert_b_type_12,
  c0_.alert_b_is_take_off_active AS alert_b_is_take_off_active_13,
  c0_.alert_b_take_off_date_time AS alert_b_take_off_date_time_14,
  c0_.alert_c_is_visible AS alert_c_is_visible_15,
  c0_.alert_c_type AS alert_c_type_16,
  c0_.alert_c_is_take_off_active AS alert_c_is_take_off_active_17,
  c0_.alert_c_take_off_date_time AS alert_c_take_off_date_time_18,
  c0_.contact_map AS contact_map_19,
  c0_.link_facebook AS link_facebook_20,
  c0_.link_instagram AS link_instagram_21,
  c0_.additional_head_code AS additional_head_code_22,
  c0_.additional_body_code AS additional_body_code_23,
  c0_.error_report_email AS error_report_email_24,
  c0_.payu_secret AS payu_secret_25,
  c0_.payu_client_id AS payu_client_id_26,
  c0_.payu_second_key AS payu_second_key_27,
  c0_.payu_sandbox AS payu_sandbox_28,
  c0_.id AS id_29,
  c0_.uuid AS uuid_30,
  c0_.created_at AS created_at_31,
  c0_.updated_at AS updated_at_32
FROM
  configs c0_
ORDER BY
  c0_.created_at ASC
LIMIT
  1

SELECT c0_.is_mourning_version_active AS is_mourning_version_active_0, c0_.home_journals_per_page AS home_journals_per_page_1, c0_.home_is_journals_alphabetical_asc_order AS home_is_journals_alphabetical_asc_order_2, c0_.home_is_unpublished_journals_excluded AS home_is_unpublished_journals_excluded_3, c0_.home_is_closed_journals_excluded AS home_is_closed_journals_excluded_4, c0_.home_is_unscientific_journals_excluded AS home_is_unscientific_journals_excluded_5, c0_.home_is_industry_journals_excluded AS home_is_industry_journals_excluded_6, c0_.alert_a_is_visible AS alert_a_is_visible_7, c0_.alert_a_type AS alert_a_type_8, c0_.alert_a_is_take_off_active AS alert_a_is_take_off_active_9, c0_.alert_a_take_off_date_time AS alert_a_take_off_date_time_10, c0_.alert_b_is_visible AS alert_b_is_visible_11, c0_.alert_b_type AS alert_b_type_12, c0_.alert_b_is_take_off_active AS alert_b_is_take_off_active_13, c0_.alert_b_take_off_date_time AS alert_b_take_off_date_time_14, c0_.alert_c_is_visible AS alert_c_is_visible_15, c0_.alert_c_type AS alert_c_type_16, c0_.alert_c_is_take_off_active AS alert_c_is_take_off_active_17, c0_.alert_c_take_off_date_time AS alert_c_take_off_date_time_18, c0_.contact_map AS contact_map_19, c0_.link_facebook AS link_facebook_20, c0_.link_instagram AS link_instagram_21, c0_.additional_head_code AS additional_head_code_22, c0_.additional_body_code AS additional_body_code_23, c0_.error_report_email AS error_report_email_24, c0_.payu_secret AS payu_secret_25, c0_.payu_client_id AS payu_client_id_26, c0_.payu_second_key AS payu_second_key_27, c0_.payu_sandbox AS payu_sandbox_28, c0_.id AS id_29, c0_.uuid AS uuid_30, c0_.created_at AS created_at_31, c0_.updated_at AS updated_at_32 FROM configs c0_ ORDER BY c0_.created_at ASC LIMIT 1;

SELECT
  f0_.working_title AS working_title_0,
  f0_.is_target_blank AS is_target_blank_1,
  f0_.id AS id_2,
  f0_.uuid AS uuid_3,
  f0_.stat AS stat_4,
  f0_.ord AS ord_5,
  f0_.created_at AS created_at_6,
  f0_.updated_at AS updated_at_7,
  f0_.languages AS languages_8,
  f0_.native_language AS native_language_9,
  f0_.native_title AS native_title_10,
  f1_.title AS title_11,
  f1_.link AS link_12,
  f1_.id AS id_13,
  f1_.uuid AS uuid_14,
  f1_.created_at AS created_at_15,
  f1_.updated_at AS updated_at_16,
  f1_.lang AS lang_17,
  f2_.working_title AS working_title_18,
  f2_.is_target_blank AS is_target_blank_19,
  f2_.id AS id_20,
  f2_.uuid AS uuid_21,
  f2_.stat AS stat_22,
  f2_.ord AS ord_23,
  f2_.created_at AS created_at_24,
  f2_.updated_at AS updated_at_25,
  f3_.title AS title_26,
  f3_.link AS link_27,
  f3_.id AS id_28,
  f3_.uuid AS uuid_29,
  f3_.created_at AS created_at_30,
  f3_.updated_at AS updated_at_31,
  f3_.lang AS lang_32,
  f1_.page_id AS page_id_33,
  f1_.parent_id AS parent_id_34,
  f2_.parent_id AS parent_id_35,
  f3_.page_id AS page_id_36,
  f3_.parent_id AS parent_id_37
FROM
  footer_menu_groups f0_
  LEFT JOIN footer_menu_group_translations f1_ ON f0_.id = f1_.parent_id
  AND (
    f1_.lang = ?
    OR f1_.lang = f0_.native_language
  )
  LEFT JOIN footer_menu_group_items f2_ ON f0_.id = f2_.parent_id
  AND (f2_.stat = 1)
  LEFT JOIN footer_menu_group_item_translations f3_ ON f2_.id = f3_.parent_id
  AND (
    f3_.lang = ?
    OR f3_.lang = f0_.native_language
  )
WHERE
  f0_.stat = 1
  AND (
    f1_.title IS NOT NULL
    AND f1_.title <> ''
  )
ORDER BY
  f0_.ord DESC,
  f2_.ord desc

SELECT f0_.working_title AS working_title_0, f0_.is_target_blank AS is_target_blank_1, f0_.id AS id_2, f0_.uuid AS uuid_3, f0_.stat AS stat_4, f0_.ord AS ord_5, f0_.created_at AS created_at_6, f0_.updated_at AS updated_at_7, f0_.languages AS languages_8, f0_.native_language AS native_language_9, f0_.native_title AS native_title_10, f1_.title AS title_11, f1_.link AS link_12, f1_.id AS id_13, f1_.uuid AS uuid_14, f1_.created_at AS created_at_15, f1_.updated_at AS updated_at_16, f1_.lang AS lang_17, f2_.working_title AS working_title_18, f2_.is_target_blank AS is_target_blank_19, f2_.id AS id_20, f2_.uuid AS uuid_21, f2_.stat AS stat_22, f2_.ord AS ord_23, f2_.created_at AS created_at_24, f2_.updated_at AS updated_at_25, f3_.title AS title_26, f3_.link AS link_27, f3_.id AS id_28, f3_.uuid AS uuid_29, f3_.created_at AS created_at_30, f3_.updated_at AS updated_at_31, f3_.lang AS lang_32, f1_.page_id AS page_id_33, f1_.parent_id AS parent_id_34, f2_.parent_id AS parent_id_35, f3_.page_id AS page_id_36, f3_.parent_id AS parent_id_37 FROM footer_menu_groups f0_ LEFT JOIN footer_menu_group_translations f1_ ON f0_.id = f1_.parent_id AND (f1_.lang = 'pl' OR f1_.lang = f0_.native_language) LEFT JOIN footer_menu_group_items f2_ ON f0_.id = f2_.parent_id AND (f2_.stat = 1) LEFT JOIN footer_menu_group_item_translations f3_ ON f2_.id = f3_.parent_id AND (f3_.lang = 'pl' OR f3_.lang = f0_.native_language) WHERE f0_.stat = 1 AND (f1_.title IS NOT NULL AND f1_.title <> '') ORDER BY f0_.ord DESC, f2_.ord desc;