Symfony Profiler

SELECT
  p0_.id AS id_0,
  p0_.template AS template_1,
  p0_.content_type AS content_type_2,
  p0_.assigned_function AS assigned_function_3,
  p0_.valid_from AS valid_from_4,
  p0_.valid_to AS valid_to_5,
  p1_.id AS id_6,
  p1_.lang AS lang_7,
  p1_.title AS title_8,
  p1_.is_titlevisible AS is_titlevisible_9,
  p1_.title_tag AS title_tag_10,
  p1_.is_title_tag_automatic AS is_title_tag_automatic_11,
  p1_.meta_description AS meta_description_12,
  p1_.meta_keywords AS meta_keywords_13,
  p1_.tags AS tags_14,
  p1_.created_at AS created_at_15,
  p1_.updated_at AS updated_at_16,
  p1_.created_by AS created_by_17,
  p1_.updated_by AS updated_by_18,
  p1_.is_updated_at_automatic AS is_updated_at_automatic_19,
  p1_.is_active AS is_active_20,
  p1_.is_searchable AS is_searchable_21,
  p1_.is_language_active AS is_language_active_22,
  p1_.page_id AS page_id_23,
  p1_.test_field AS test_field_24,
  p1_.page_id AS page_id_25
FROM
  page p0_
  INNER JOIN page_translation p1_ ON p0_.id = p1_.page_id
WHERE
  p1_.is_active = 1
  AND p0_.content_type LIKE ?
  AND (
    ? BETWEEN p0_.valid_from
    AND p0_.valid_to
  )
  AND p1_.lang = ?
LIMIT
  1

SELECT p0_.id AS id_0, p0_.template AS template_1, p0_.content_type AS content_type_2, p0_.assigned_function AS assigned_function_3, p0_.valid_from AS valid_from_4, p0_.valid_to AS valid_to_5, p1_.id AS id_6, p1_.lang AS lang_7, p1_.title AS title_8, p1_.is_titlevisible AS is_titlevisible_9, p1_.title_tag AS title_tag_10, p1_.is_title_tag_automatic AS is_title_tag_automatic_11, p1_.meta_description AS meta_description_12, p1_.meta_keywords AS meta_keywords_13, p1_.tags AS tags_14, p1_.created_at AS created_at_15, p1_.updated_at AS updated_at_16, p1_.created_by AS created_by_17, p1_.updated_by AS updated_by_18, p1_.is_updated_at_automatic AS is_updated_at_automatic_19, p1_.is_active AS is_active_20, p1_.is_searchable AS is_searchable_21, p1_.is_language_active AS is_language_active_22, p1_.page_id AS page_id_23, p1_.test_field AS test_field_24, p1_.page_id AS page_id_25 FROM page p0_ INNER JOIN page_translation p1_ ON p0_.id = p1_.page_id WHERE p1_.is_active = 1 AND p0_.content_type LIKE 'error_page' AND ('2025-12-10 00:54:49' BETWEEN p0_.valid_from AND p0_.valid_to) AND p1_.lang = 'hu' LIMIT 1;

SELECT
  m0_.id AS id_0,
  m0_.page_id AS page_id_1,
  m0_.menu_group AS menu_group_2,
  m0_.is_popup AS is_popup_3,
  m0_.path AS path_4,
  m0_.level AS level_5,
  m0_.clone_parent_menu_id AS clone_parent_menu_id_6,
  m0_.is_internal AS is_internal_7,
  m0_.is_concated AS is_concated_8,
  m0_.is_archive AS is_archive_9,
  m0_.special_attribute AS special_attribute_10,
  m0_.is_editable AS is_editable_11,
  m1_.id AS id_12,
  m1_.lang AS lang_13,
  m1_.is_language_active AS is_language_active_14,
  m1_.is_active AS is_active_15,
  m1_.name AS name_16,
  m1_.slug AS slug_17,
  m1_.concated_slug AS concated_slug_18,
  m1_.concated_slug_archive AS concated_slug_archive_19,
  m1_.is_slug_visible AS is_slug_visible_20,
  m1_.url AS url_21,
  m1_.visibility AS visibility_22,
  m1_.dynamic_route_generator AS dynamic_route_generator_23,
  m1_.is_automatic_dynamic_route_generator AS is_automatic_dynamic_route_generator_24,
  m1_.menu_id AS menu_id_25,
  m0_.clone_parent_menu_id AS clone_parent_menu_id_26,
  m0_.page_id AS page_id_27,
  m1_.menu_id AS menu_id_28
FROM
  menu m0_
  INNER JOIN menu_translation m1_ ON m0_.id = m1_.menu_id
WHERE
  m1_.is_active = 1
  AND m1_.lang = ?
  AND (
    LOCATE(m1_.concated_slug, ?) = 1
    OR LOCATE(m1_.concated_slug_archive, ?) = 1
    OR LOCATE(
      CONCAT(m1_.lang, '/', m1_.concated_slug),
      ?
    ) = 1
    OR LOCATE(
      CONCAT(
        m1_.lang, '/', m1_.concated_slug_archive
      ),
      ?
    ) = 1
  )
ORDER BY
  m1_.concated_slug DESC
LIMIT
  1

SELECT m0_.id AS id_0, m0_.page_id AS page_id_1, m0_.menu_group AS menu_group_2, m0_.is_popup AS is_popup_3, m0_.path AS path_4, m0_.level AS level_5, m0_.clone_parent_menu_id AS clone_parent_menu_id_6, m0_.is_internal AS is_internal_7, m0_.is_concated AS is_concated_8, m0_.is_archive AS is_archive_9, m0_.special_attribute AS special_attribute_10, m0_.is_editable AS is_editable_11, m1_.id AS id_12, m1_.lang AS lang_13, m1_.is_language_active AS is_language_active_14, m1_.is_active AS is_active_15, m1_.name AS name_16, m1_.slug AS slug_17, m1_.concated_slug AS concated_slug_18, m1_.concated_slug_archive AS concated_slug_archive_19, m1_.is_slug_visible AS is_slug_visible_20, m1_.url AS url_21, m1_.visibility AS visibility_22, m1_.dynamic_route_generator AS dynamic_route_generator_23, m1_.is_automatic_dynamic_route_generator AS is_automatic_dynamic_route_generator_24, m1_.menu_id AS menu_id_25, m0_.clone_parent_menu_id AS clone_parent_menu_id_26, m0_.page_id AS page_id_27, m1_.menu_id AS menu_id_28 FROM menu m0_ INNER JOIN menu_translation m1_ ON m0_.id = m1_.menu_id WHERE m1_.is_active = 1 AND m1_.lang = 'hu' AND (LOCATE(m1_.concated_slug, 'dolgozok-nyilvantartasa') = 1 OR LOCATE(m1_.concated_slug_archive, 'dolgozok-nyilvantartasa') = 1 OR LOCATE(CONCAT(m1_.lang, '/', m1_.concated_slug), 'dolgozok-nyilvantartasa') = 1 OR LOCATE(CONCAT(m1_.lang, '/', m1_.concated_slug_archive), 'dolgozok-nyilvantartasa') = 1) ORDER BY m1_.concated_slug DESC LIMIT 1;

SELECT
  p0_.id AS id_0,
  p0_.template AS template_1,
  p0_.content_type AS content_type_2,
  p0_.assigned_function AS assigned_function_3,
  p0_.valid_from AS valid_from_4,
  p0_.valid_to AS valid_to_5,
  p1_.id AS id_6,
  p1_.lang AS lang_7,
  p1_.title AS title_8,
  p1_.is_titlevisible AS is_titlevisible_9,
  p1_.title_tag AS title_tag_10,
  p1_.is_title_tag_automatic AS is_title_tag_automatic_11,
  p1_.meta_description AS meta_description_12,
  p1_.meta_keywords AS meta_keywords_13,
  p1_.tags AS tags_14,
  p1_.created_at AS created_at_15,
  p1_.updated_at AS updated_at_16,
  p1_.created_by AS created_by_17,
  p1_.updated_by AS updated_by_18,
  p1_.is_updated_at_automatic AS is_updated_at_automatic_19,
  p1_.is_active AS is_active_20,
  p1_.is_searchable AS is_searchable_21,
  p1_.is_language_active AS is_language_active_22,
  p1_.page_id AS page_id_23,
  p1_.test_field AS test_field_24,
  p1_.page_id AS page_id_25
FROM
  page p0_
  INNER JOIN page_translation p1_ ON p0_.id = p1_.page_id
WHERE
  p1_.lang = ?
  AND p0_.id = ?
LIMIT
  1

SELECT p0_.id AS id_0, p0_.template AS template_1, p0_.content_type AS content_type_2, p0_.assigned_function AS assigned_function_3, p0_.valid_from AS valid_from_4, p0_.valid_to AS valid_to_5, p1_.id AS id_6, p1_.lang AS lang_7, p1_.title AS title_8, p1_.is_titlevisible AS is_titlevisible_9, p1_.title_tag AS title_tag_10, p1_.is_title_tag_automatic AS is_title_tag_automatic_11, p1_.meta_description AS meta_description_12, p1_.meta_keywords AS meta_keywords_13, p1_.tags AS tags_14, p1_.created_at AS created_at_15, p1_.updated_at AS updated_at_16, p1_.created_by AS created_by_17, p1_.updated_by AS updated_by_18, p1_.is_updated_at_automatic AS is_updated_at_automatic_19, p1_.is_active AS is_active_20, p1_.is_searchable AS is_searchable_21, p1_.is_language_active AS is_language_active_22, p1_.page_id AS page_id_23, p1_.test_field AS test_field_24, p1_.page_id AS page_id_25 FROM page p0_ INNER JOIN page_translation p1_ ON p0_.id = p1_.page_id WHERE p1_.lang = 'hu' AND p0_.id = 6 LIMIT 1;

SELECT
  m0_.id AS id_0,
  m0_.page_id AS page_id_1,
  m0_.menu_group AS menu_group_2,
  m0_.is_popup AS is_popup_3,
  m0_.path AS path_4,
  m0_.level AS level_5,
  m0_.clone_parent_menu_id AS clone_parent_menu_id_6,
  m0_.is_internal AS is_internal_7,
  m0_.is_concated AS is_concated_8,
  m0_.is_archive AS is_archive_9,
  m0_.special_attribute AS special_attribute_10,
  m0_.is_editable AS is_editable_11,
  m1_.id AS id_12,
  m1_.lang AS lang_13,
  m1_.is_language_active AS is_language_active_14,
  m1_.is_active AS is_active_15,
  m1_.name AS name_16,
  m1_.slug AS slug_17,
  m1_.concated_slug AS concated_slug_18,
  m1_.concated_slug_archive AS concated_slug_archive_19,
  m1_.is_slug_visible AS is_slug_visible_20,
  m1_.url AS url_21,
  m1_.visibility AS visibility_22,
  m1_.dynamic_route_generator AS dynamic_route_generator_23,
  m1_.is_automatic_dynamic_route_generator AS is_automatic_dynamic_route_generator_24,
  m1_.menu_id AS menu_id_25,
  p2_.id AS id_26,
  p2_.template AS template_27,
  p2_.content_type AS content_type_28,
  p2_.assigned_function AS assigned_function_29,
  p2_.valid_from AS valid_from_30,
  p2_.valid_to AS valid_to_31,
  p3_.id AS id_32,
  p3_.lang AS lang_33,
  p3_.title AS title_34,
  p3_.is_titlevisible AS is_titlevisible_35,
  p3_.title_tag AS title_tag_36,
  p3_.is_title_tag_automatic AS is_title_tag_automatic_37,
  p3_.meta_description AS meta_description_38,
  p3_.meta_keywords AS meta_keywords_39,
  p3_.tags AS tags_40,
  p3_.created_at AS created_at_41,
  p3_.updated_at AS updated_at_42,
  p3_.created_by AS created_by_43,
  p3_.updated_by AS updated_by_44,
  p3_.is_updated_at_automatic AS is_updated_at_automatic_45,
  p3_.is_active AS is_active_46,
  p3_.is_searchable AS is_searchable_47,
  p3_.is_language_active AS is_language_active_48,
  p3_.page_id AS page_id_49,
  p3_.test_field AS test_field_50,
  m0_.clone_parent_menu_id AS clone_parent_menu_id_51,
  m0_.page_id AS page_id_52,
  m1_.menu_id AS menu_id_53,
  p3_.page_id AS page_id_54
FROM
  menu m0_
  INNER JOIN menu_translation m1_ ON m0_.id = m1_.menu_id
  INNER JOIN page p2_ ON m0_.page_id = p2_.id
  INNER JOIN page_translation p3_ ON p2_.id = p3_.page_id
WHERE
  m1_.lang = ?
  AND p3_.lang = ?
  AND m0_.is_concated = 1
  AND m0_.path LIKE ?
  AND m0_.level = ?
  AND m1_.is_active = 1
ORDER BY
  m0_.path ASC

SELECT m0_.id AS id_0, m0_.page_id AS page_id_1, m0_.menu_group AS menu_group_2, m0_.is_popup AS is_popup_3, m0_.path AS path_4, m0_.level AS level_5, m0_.clone_parent_menu_id AS clone_parent_menu_id_6, m0_.is_internal AS is_internal_7, m0_.is_concated AS is_concated_8, m0_.is_archive AS is_archive_9, m0_.special_attribute AS special_attribute_10, m0_.is_editable AS is_editable_11, m1_.id AS id_12, m1_.lang AS lang_13, m1_.is_language_active AS is_language_active_14, m1_.is_active AS is_active_15, m1_.name AS name_16, m1_.slug AS slug_17, m1_.concated_slug AS concated_slug_18, m1_.concated_slug_archive AS concated_slug_archive_19, m1_.is_slug_visible AS is_slug_visible_20, m1_.url AS url_21, m1_.visibility AS visibility_22, m1_.dynamic_route_generator AS dynamic_route_generator_23, m1_.is_automatic_dynamic_route_generator AS is_automatic_dynamic_route_generator_24, m1_.menu_id AS menu_id_25, p2_.id AS id_26, p2_.template AS template_27, p2_.content_type AS content_type_28, p2_.assigned_function AS assigned_function_29, p2_.valid_from AS valid_from_30, p2_.valid_to AS valid_to_31, p3_.id AS id_32, p3_.lang AS lang_33, p3_.title AS title_34, p3_.is_titlevisible AS is_titlevisible_35, p3_.title_tag AS title_tag_36, p3_.is_title_tag_automatic AS is_title_tag_automatic_37, p3_.meta_description AS meta_description_38, p3_.meta_keywords AS meta_keywords_39, p3_.tags AS tags_40, p3_.created_at AS created_at_41, p3_.updated_at AS updated_at_42, p3_.created_by AS created_by_43, p3_.updated_by AS updated_by_44, p3_.is_updated_at_automatic AS is_updated_at_automatic_45, p3_.is_active AS is_active_46, p3_.is_searchable AS is_searchable_47, p3_.is_language_active AS is_language_active_48, p3_.page_id AS page_id_49, p3_.test_field AS test_field_50, m0_.clone_parent_menu_id AS clone_parent_menu_id_51, m0_.page_id AS page_id_52, m1_.menu_id AS menu_id_53, p3_.page_id AS page_id_54 FROM menu m0_ INNER JOIN menu_translation m1_ ON m0_.id = m1_.menu_id INNER JOIN page p2_ ON m0_.page_id = p2_.id INNER JOIN page_translation p3_ ON p2_.id = p3_.page_id WHERE m1_.lang = 'hu' AND p3_.lang = 'hu' AND m0_.is_concated = 1 AND m0_.path LIKE '%' AND m0_.level = 1 AND m1_.is_active = 1 ORDER BY m0_.path ASC;

SELECT
  c0_.id AS id_0,
  c0_.content_id AS content_id_1,
  c0_.inner_content_id AS inner_content_id_2,
  c0_.lang AS lang_3,
  c0_.place_id AS place_id_4,
  i1_.id AS id_5,
  i1_.lang AS lang_6,
  i1_.refer AS refer_7,
  i1_.content AS content_8,
  i1_.is_shared_content AS is_shared_content_9,
  c0_.inner_content_id AS inner_content_id_10
FROM
  content_connector c0_
  INNER JOIN inner_content i1_ ON c0_.inner_content_id = i1_.id
WHERE
  c0_.lang = ?
  AND c0_.content_id IN (?, ?, ?, ?, ?, ?, ?)

SELECT c0_.id AS id_0, c0_.content_id AS content_id_1, c0_.inner_content_id AS inner_content_id_2, c0_.lang AS lang_3, c0_.place_id AS place_id_4, i1_.id AS id_5, i1_.lang AS lang_6, i1_.refer AS refer_7, i1_.content AS content_8, i1_.is_shared_content AS is_shared_content_9, c0_.inner_content_id AS inner_content_id_10 FROM content_connector c0_ INNER JOIN inner_content i1_ ON c0_.inner_content_id = i1_.id WHERE c0_.lang = 'hu' AND c0_.content_id IN (2, 5, 8, 10, 11, 6, 16);

SELECT
  DATABASE()

SELECT DATABASE();

SELECT
  TABLE_NAME
FROM
  information_schema.TABLES
WHERE
  TABLE_SCHEMA = ?
  AND TABLE_TYPE = 'BASE TABLE'
ORDER BY
  TABLE_NAME

SELECT TABLE_NAME
FROM information_schema.TABLES
WHERE TABLE_SCHEMA = 'eduhub'
  AND TABLE_TYPE = 'BASE TABLE'
ORDER BY TABLE_NAME;

SELECT
  DATABASE()

SELECT DATABASE();

SELECT
  t0.id AS id_1,
  t0.group_name AS group_name_2,
  t0.name AS name_3,
  t0.key_id AS key_id_4,
  t0.value AS value_5
FROM
  system_config t0
WHERE
  t0.key_id = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.group_name AS group_name_2, t0.name AS name_3, t0.key_id AS key_id_4, t0.value AS value_5 FROM system_config t0 WHERE t0.key_id = 'COOKIEALERTENABLED' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.group_name AS group_name_2,
  t0.name AS name_3,
  t0.key_id AS key_id_4,
  t0.value AS value_5
FROM
  system_config t0
WHERE
  t0.key_id = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.group_name AS group_name_2, t0.name AS name_3, t0.key_id AS key_id_4, t0.value AS value_5 FROM system_config t0 WHERE t0.key_id = 'GOOGLEECOMMERCE' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.group_name AS group_name_2,
  t0.name AS name_3,
  t0.key_id AS key_id_4,
  t0.value AS value_5
FROM
  system_config t0
WHERE
  t0.key_id = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.group_name AS group_name_2, t0.name AS name_3, t0.key_id AS key_id_4, t0.value AS value_5 FROM system_config t0 WHERE t0.key_id = 'GOOGLEANALYTICS' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.group_name AS group_name_2,
  t0.name AS name_3,
  t0.key_id AS key_id_4,
  t0.value AS value_5
FROM
  system_config t0
WHERE
  t0.key_id = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.group_name AS group_name_2, t0.name AS name_3, t0.key_id AS key_id_4, t0.value AS value_5 FROM system_config t0 WHERE t0.key_id = 'GOOGLEACCOUNT' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.group_name AS group_name_2,
  t0.name AS name_3,
  t0.key_id AS key_id_4,
  t0.value AS value_5
FROM
  system_config t0
WHERE
  t0.key_id = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.group_name AS group_name_2, t0.name AS name_3, t0.key_id AS key_id_4, t0.value AS value_5 FROM system_config t0 WHERE t0.key_id = 'GOOGLEACCOUNT' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.group_name AS group_name_2,
  t0.name AS name_3,
  t0.key_id AS key_id_4,
  t0.value AS value_5
FROM
  system_config t0
WHERE
  t0.key_id = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.group_name AS group_name_2, t0.name AS name_3, t0.key_id AS key_id_4, t0.value AS value_5 FROM system_config t0 WHERE t0.key_id = 'GOOGLEECOMMERCE' LIMIT 1;

SELECT
  p0_.id AS id_0,
  p1_.title AS title_1,
  m2_.concated_slug AS concated_slug_2
FROM
  menu m3_
  INNER JOIN page p0_ ON m3_.page_id = p0_.id
  INNER JOIN menu_translation m2_ ON m3_.id = m2_.menu_id
  INNER JOIN page_translation p1_ ON p0_.id = p1_.page_id
WHERE
  p0_.content_type IN (?, ?)
  AND p1_.lang = ?
  AND m2_.lang = ?

SELECT p0_.id AS id_0, p1_.title AS title_1, m2_.concated_slug AS concated_slug_2 FROM menu m3_ INNER JOIN page p0_ ON m3_.page_id = p0_.id INNER JOIN menu_translation m2_ ON m3_.id = m2_.menu_id INNER JOIN page_translation p1_ ON p0_.id = p1_.page_id WHERE p0_.content_type IN ('page', 'page_group') AND p1_.lang = 'hu' AND m2_.lang = 'hu';

SELECT
  m.id AS id0,
  m.page_id AS page_id13,
  m.menu_group AS menu_group2,
  m.is_popup AS is_popup3,
  m.path AS path4,
  m.level AS level5,
  m.clone_parent_menu_id AS clone_parent_menu_id12,
  m.is_internal AS is_internal7,
  m.is_concated AS is_concated8,
  m.is_archive AS is_archive9,
  m.special_attribute AS special_attribute10,
  m.is_editable AS is_editable11,
  t.id AS id,
  t.lang AS lang,
  t.is_language_active AS is_language_active,
  t.is_active AS is_active,
  t.name AS name,
  t.slug AS slug,
  t.concated_slug AS concated_slug,
  t.concated_slug_archive AS concated_slug_archive,
  t.is_slug_visible AS is_slug_visible,
  t.url AS url,
  t.visibility AS visibility,
  t.dynamic_route_generator AS dynamic_route_generator,
  t.is_automatic_dynamic_route_generator AS is_automatic_dynamic_route_generator,
  t.menu_id AS menu_id,
  t.menu_id mid
FROM
  (
    SELECT
      *
    FROM
      menu
    WHERE
      menu_group = "fo_menu"
      AND level <= 999
    ORDER BY
      path ASC
  ) m
  JOIN menu_translation t ON (m.id = t.menu_id)
WHERE
  t.lang = "hu"
  AND t.is_active = 1
  AND t.visibility IN (0, 2)

SELECT m.id AS id0, m.page_id AS page_id13, m.menu_group AS menu_group2, m.is_popup AS is_popup3, m.path AS path4, m.level AS level5, m.clone_parent_menu_id AS clone_parent_menu_id12, m.is_internal AS is_internal7, m.is_concated AS is_concated8, m.is_archive AS is_archive9, m.special_attribute AS special_attribute10, m.is_editable AS is_editable11, t.id AS id, t.lang AS lang, t.is_language_active AS is_language_active, t.is_active AS is_active, t.name AS name, t.slug AS slug, t.concated_slug AS concated_slug, t.concated_slug_archive AS concated_slug_archive, t.is_slug_visible AS is_slug_visible, t.url AS url, t.visibility AS visibility, t.dynamic_route_generator AS dynamic_route_generator, t.is_automatic_dynamic_route_generator AS is_automatic_dynamic_route_generator, t.menu_id AS menu_id,t.menu_id mid  FROM (SELECT * FROM menu WHERE menu_group="fo_menu" AND level<=999 ORDER BY path ASC) m JOIN menu_translation t ON (m.id=t.menu_id) 
              WHERE t.lang = "hu" AND t.is_active = 1 AND t.visibility IN (0, 2);

SELECT
  m0_.id AS id_0,
  m0_.page_id AS page_id_1,
  m0_.menu_group AS menu_group_2,
  m0_.is_popup AS is_popup_3,
  m0_.path AS path_4,
  m0_.level AS level_5,
  m0_.clone_parent_menu_id AS clone_parent_menu_id_6,
  m0_.is_internal AS is_internal_7,
  m0_.is_concated AS is_concated_8,
  m0_.is_archive AS is_archive_9,
  m0_.special_attribute AS special_attribute_10,
  m0_.is_editable AS is_editable_11,
  m0_.clone_parent_menu_id AS clone_parent_menu_id_12,
  m0_.page_id AS page_id_13
FROM
  menu m0_
  INNER JOIN menu_translation m1_ ON m0_.id = m1_.menu_id
WHERE
  m1_.is_active = 1
  AND (
    (
      m1_.concated_slug <> ?
      AND (
        LOCATE(m1_.concated_slug, ?) = 1
        OR LOCATE(m1_.concated_slug_archive, ?) = 1
        OR LOCATE(
          CONCAT(m1_.lang, '/', m1_.concated_slug),
          ?
        ) = 1
        OR LOCATE(
          CONCAT(
            m1_.lang, '/', m1_.concated_slug_archive
          ),
          ?
        ) = 1
      )
    )
    OR (
      m1_.url <> ?
      AND (
        m1_.url = ?
        OR m1_.url = ?
      )
    )
  )
  AND m0_.menu_group = ?
ORDER BY
  m1_.concated_slug DESC
LIMIT
  1

SELECT m0_.id AS id_0, m0_.page_id AS page_id_1, m0_.menu_group AS menu_group_2, m0_.is_popup AS is_popup_3, m0_.path AS path_4, m0_.level AS level_5, m0_.clone_parent_menu_id AS clone_parent_menu_id_6, m0_.is_internal AS is_internal_7, m0_.is_concated AS is_concated_8, m0_.is_archive AS is_archive_9, m0_.special_attribute AS special_attribute_10, m0_.is_editable AS is_editable_11, m0_.clone_parent_menu_id AS clone_parent_menu_id_12, m0_.page_id AS page_id_13 FROM menu m0_ INNER JOIN menu_translation m1_ ON m0_.id = m1_.menu_id WHERE m1_.is_active = 1 AND ((m1_.concated_slug <> '' AND (LOCATE(m1_.concated_slug, 'hu/dolgozok-nyilvantartasa') = 1 OR LOCATE(m1_.concated_slug_archive, 'hu/dolgozok-nyilvantartasa') = 1 OR LOCATE(CONCAT(m1_.lang, '/', m1_.concated_slug), 'hu/dolgozok-nyilvantartasa') = 1 OR LOCATE(CONCAT(m1_.lang, '/', m1_.concated_slug_archive), 'hu/dolgozok-nyilvantartasa') = 1)) OR (m1_.url <> '' AND (m1_.url = 'hu/dolgozok-nyilvantartasa' OR m1_.url = '/hu/dolgozok-nyilvantartasa'))) AND m0_.menu_group = 'fo_menu' ORDER BY m1_.concated_slug DESC LIMIT 1;