Symfony Profiler

SELECT
  l0_.id AS id_0,
  l0_.name AS name_1,
  l0_.locale AS locale_2,
  l0_.is_right_to_left AS is_right_to_left_3,
  l0_.short AS short_4
FROM
  language l0_
  INNER JOIN language_project l1_ ON l0_.id = l1_.language_id
  INNER JOIN project p2_ ON l1_.project_id = p2_.id
WHERE
  p2_.id = ?
ORDER BY
  l1_.is_default DESC
LIMIT
  1

SELECT l0_.id AS id_0, l0_.name AS name_1, l0_.locale AS locale_2, l0_.is_right_to_left AS is_right_to_left_3, l0_.short AS short_4 FROM language l0_ INNER JOIN language_project l1_ ON l0_.id = l1_.language_id INNER JOIN project p2_ ON l1_.project_id = p2_.id WHERE p2_.id = 17 ORDER BY l1_.is_default DESC LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.uri_test AS uri_test_3,
  t0.db_name_test AS db_name_test_4,
  t0.db_user_test AS db_user_test_5,
  t0.db_password_test AS db_password_test_6,
  t0.uri_prod AS uri_prod_7,
  t0.db_name_prod AS db_name_prod_8,
  t0.db_user_prod AS db_user_prod_9,
  t0.db_password_prod AS db_password_prod_10,
  t0.css_path_test AS css_path_test_11,
  t0.css_path_prod AS css_path_prod_12,
  t0.deepl_api_key AS deepl_api_key_13
FROM
  project t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.uri_test AS uri_test_3, t0.db_name_test AS db_name_test_4, t0.db_user_test AS db_user_test_5, t0.db_password_test AS db_password_test_6, t0.uri_prod AS uri_prod_7, t0.db_name_prod AS db_name_prod_8, t0.db_user_prod AS db_user_prod_9, t0.db_password_prod AS db_password_prod_10, t0.css_path_test AS css_path_test_11, t0.css_path_prod AS css_path_prod_12, t0.deepl_api_key AS deepl_api_key_13 FROM project t0 WHERE t0.id = 17;

SELECT
  t0.id AS id_1,
  t0.email AS email_2,
  t0.password AS password_3,
  t0.name AS name_4,
  t0.phone AS phone_5,
  t0.is_greendot AS is_greendot_6
FROM
  user t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.email AS email_2, t0.password AS password_3, t0.name AS name_4, t0.phone AS phone_5, t0.is_greendot AS is_greendot_6 FROM user t0 WHERE t0.id = 24;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.uri_test AS uri_test_3,
  t0.db_name_test AS db_name_test_4,
  t0.db_user_test AS db_user_test_5,
  t0.db_password_test AS db_password_test_6,
  t0.uri_prod AS uri_prod_7,
  t0.db_name_prod AS db_name_prod_8,
  t0.db_user_prod AS db_user_prod_9,
  t0.db_password_prod AS db_password_prod_10,
  t0.css_path_test AS css_path_test_11,
  t0.css_path_prod AS css_path_prod_12,
  t0.deepl_api_key AS deepl_api_key_13
FROM
  project t0

SELECT t0.id AS id_1, t0.name AS name_2, t0.uri_test AS uri_test_3, t0.db_name_test AS db_name_test_4, t0.db_user_test AS db_user_test_5, t0.db_password_test AS db_password_test_6, t0.uri_prod AS uri_prod_7, t0.db_name_prod AS db_name_prod_8, t0.db_user_prod AS db_user_prod_9, t0.db_password_prod AS db_password_prod_10, t0.css_path_test AS css_path_test_11, t0.css_path_prod AS css_path_prod_12, t0.deepl_api_key AS deepl_api_key_13 FROM project t0;

SELECT
  t0.id AS id_1,
  t0.sequence AS sequence_2,
  t0.is_menu_item AS is_menu_item_3,
  t0.category_super_id AS category_super_id_4,
  t0.category_sub_id AS category_sub_id_5
FROM
  p_category_category t0
WHERE
  t0.category_super_id = ?
ORDER BY
  t0.sequence ASC

SELECT t0.id AS id_1, t0.sequence AS sequence_2, t0.is_menu_item AS is_menu_item_3, t0.category_super_id AS category_super_id_4, t0.category_sub_id AS category_sub_id_5 FROM p_category_category t0 WHERE t0.category_super_id = 1 ORDER BY t0.sequence ASC;

SELECT
  t0.id AS id_1,
  t0.sequence AS sequence_2,
  t0.is_menu_item AS is_menu_item_3,
  t0.category_super_id AS category_super_id_4,
  t0.category_sub_id AS category_sub_id_5
FROM
  p_category_category t0
WHERE
  t0.category_sub_id = ?
ORDER BY
  t0.sequence ASC

SELECT t0.id AS id_1, t0.sequence AS sequence_2, t0.is_menu_item AS is_menu_item_3, t0.category_super_id AS category_super_id_4, t0.category_sub_id AS category_sub_id_5 FROM p_category_category t0 WHERE t0.category_sub_id = 1 ORDER BY t0.sequence ASC;

SELECT
  CASE WHEN p0_.published_at IS NULL THEN 0 ELSE 1 END AS sclr_0,
  p0_.id AS id_1,
  p0_.name AS name_2,
  p0_.menu_name AS menu_name_3,
  p0_.description AS description_4,
  p0_.html AS html_5,
  p0_.title AS title_6,
  p0_.is_active AS is_active_7,
  p0_.slug AS slug_8,
  p0_.javascript AS javascript_9,
  p0_.sequence AS sequence_10,
  p0_.is_menu AS is_menu_11,
  p0_.latitude AS latitude_12,
  p0_.longitude AS longitude_13,
  p0_.state AS state_14,
  p0_.has_comments AS has_comments_15,
  p0_.is_indexable AS is_indexable_16,
  p0_.created_at AS created_at_17,
  p0_.published_at AS published_at_18,
  p1_.id AS id_19,
  p1_.name AS name_20,
  l2_.id AS id_21,
  l2_.name AS name_22,
  l2_.color AS color_23,
  c3_.id AS id_24,
  c3_.name AS name_25,
  c3_.template AS template_26,
  c3_.slug_prefix AS slug_prefix_27,
  u4_.id AS id_28,
  u4_.name AS name_29,
  u4_.extension AS extension_30,
  u4_.mime AS mime_31,
  u4_.title AS title_32,
  u4_.short_description AS short_description_33,
  u4_.description AS description_34,
  u4_.created AS created_35,
  u4_.path AS path_36,
  u4_.original_name AS original_name_37,
  u4_.width AS width_38,
  u4_.height AS height_39,
  u4_.sequence AS sequence_40,
  u4_.note AS note_41,
  u4_.icon AS icon_42,
  c5_.id AS id_43,
  c5_.sequence AS sequence_44,
  m6_.id AS id_45,
  m6_.name AS name_46,
  m6_.template AS template_47,
  m6_.controller_name AS controller_name_48,
  s7_.id AS id_49,
  s7_.name AS name_50,
  s7_.template AS template_51,
  s7_.controller_name AS controller_name_52,
  p0_.category_type_id AS category_type_id_53,
  p0_.upload_id AS upload_id_54,
  p1_.label_type_id AS label_type_id_55,
  u4_.upload_group_id AS upload_group_id_56,
  u4_.upload_type_id AS upload_type_id_57,
  c5_.category_id AS category_id_58,
  c5_.menu_type_id AS menu_type_id_59
FROM
  p_category p0_
  LEFT JOIN p_category_category p8_ ON p0_.id = p8_.category_sub_id
  LEFT JOIN category_label c9_ ON p0_.id = c9_.category_id
  LEFT JOIN p_label p1_ ON p1_.id = c9_.label_id
  LEFT JOIN label_type l2_ ON p1_.label_type_id = l2_.id
  LEFT JOIN category_type c3_ ON p0_.category_type_id = c3_.id
  LEFT JOIN upload u4_ ON p0_.upload_id = u4_.id
  LEFT JOIN category_menu_type c5_ ON p0_.id = c5_.category_id
  LEFT JOIN menu_type m6_ ON c5_.menu_type_id = m6_.id
  LEFT JOIN category_sub_menu_type c10_ ON p0_.id = c10_.category_id
  LEFT JOIN sub_menu_type s7_ ON s7_.id = c10_.sub_menu_type_id
WHERE
  p0_.id IN (
    SELECT
      p11_.id
    FROM
      p_category p11_
      LEFT JOIN p_category_category p12_ ON p11_.id = p12_.category_sub_id
    WHERE
      p12_.category_super_id = ?
  )
  AND p0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
ORDER BY
  p8_.sequence ASC,
  sclr_0 DESC,
  p0_.published_at DESC

SELECT CASE WHEN p0_.published_at IS NULL THEN 0 ELSE 1 END AS sclr_0, p0_.id AS id_1, p0_.name AS name_2, p0_.menu_name AS menu_name_3, p0_.description AS description_4, p0_.html AS html_5, p0_.title AS title_6, p0_.is_active AS is_active_7, p0_.slug AS slug_8, p0_.javascript AS javascript_9, p0_.sequence AS sequence_10, p0_.is_menu AS is_menu_11, p0_.latitude AS latitude_12, p0_.longitude AS longitude_13, p0_.state AS state_14, p0_.has_comments AS has_comments_15, p0_.is_indexable AS is_indexable_16, p0_.created_at AS created_at_17, p0_.published_at AS published_at_18, p1_.id AS id_19, p1_.name AS name_20, l2_.id AS id_21, l2_.name AS name_22, l2_.color AS color_23, c3_.id AS id_24, c3_.name AS name_25, c3_.template AS template_26, c3_.slug_prefix AS slug_prefix_27, u4_.id AS id_28, u4_.name AS name_29, u4_.extension AS extension_30, u4_.mime AS mime_31, u4_.title AS title_32, u4_.short_description AS short_description_33, u4_.description AS description_34, u4_.created AS created_35, u4_.path AS path_36, u4_.original_name AS original_name_37, u4_.width AS width_38, u4_.height AS height_39, u4_.sequence AS sequence_40, u4_.note AS note_41, u4_.icon AS icon_42, c5_.id AS id_43, c5_.sequence AS sequence_44, m6_.id AS id_45, m6_.name AS name_46, m6_.template AS template_47, m6_.controller_name AS controller_name_48, s7_.id AS id_49, s7_.name AS name_50, s7_.template AS template_51, s7_.controller_name AS controller_name_52, p0_.category_type_id AS category_type_id_53, p0_.upload_id AS upload_id_54, p1_.label_type_id AS label_type_id_55, u4_.upload_group_id AS upload_group_id_56, u4_.upload_type_id AS upload_type_id_57, c5_.category_id AS category_id_58, c5_.menu_type_id AS menu_type_id_59 FROM p_category p0_ LEFT JOIN p_category_category p8_ ON p0_.id = p8_.category_sub_id LEFT JOIN category_label c9_ ON p0_.id = c9_.category_id LEFT JOIN p_label p1_ ON p1_.id = c9_.label_id LEFT JOIN label_type l2_ ON p1_.label_type_id = l2_.id LEFT JOIN category_type c3_ ON p0_.category_type_id = c3_.id LEFT JOIN upload u4_ ON p0_.upload_id = u4_.id LEFT JOIN category_menu_type c5_ ON p0_.id = c5_.category_id LEFT JOIN menu_type m6_ ON c5_.menu_type_id = m6_.id LEFT JOIN category_sub_menu_type c10_ ON p0_.id = c10_.category_id LEFT JOIN sub_menu_type s7_ ON s7_.id = c10_.sub_menu_type_id WHERE p0_.id IN (SELECT p11_.id FROM p_category p11_ LEFT JOIN p_category_category p12_ ON p11_.id = p12_.category_sub_id WHERE p12_.category_super_id = '2') AND p0_.id IN (400, 399, 398, 397, 396, 395, 394, 393, 392, 391, 390, 158) ORDER BY p8_.sequence ASC, sclr_0 DESC, p0_.published_at DESC;

SELECT
  p0_.id AS id_0,
  p0_.name AS name_1,
  p0_.menu_name AS menu_name_2,
  p0_.description AS description_3,
  p0_.html AS html_4,
  p0_.title AS title_5,
  p0_.is_active AS is_active_6,
  p0_.slug AS slug_7,
  p0_.javascript AS javascript_8,
  p0_.sequence AS sequence_9,
  p0_.is_menu AS is_menu_10,
  p0_.latitude AS latitude_11,
  p0_.longitude AS longitude_12,
  p0_.state AS state_13,
  p0_.has_comments AS has_comments_14,
  p0_.is_indexable AS is_indexable_15,
  p0_.created_at AS created_at_16,
  p0_.published_at AS published_at_17,
  p0_.category_type_id AS category_type_id_18,
  p0_.upload_id AS upload_id_19
FROM
  p_category p0_

SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.menu_name AS menu_name_2, p0_.description AS description_3, p0_.html AS html_4, p0_.title AS title_5, p0_.is_active AS is_active_6, p0_.slug AS slug_7, p0_.javascript AS javascript_8, p0_.sequence AS sequence_9, p0_.is_menu AS is_menu_10, p0_.latitude AS latitude_11, p0_.longitude AS longitude_12, p0_.state AS state_13, p0_.has_comments AS has_comments_14, p0_.is_indexable AS is_indexable_15, p0_.created_at AS created_at_16, p0_.published_at AS published_at_17, p0_.category_type_id AS category_type_id_18, p0_.upload_id AS upload_id_19 FROM p_category p0_;

SELECT
  COUNT(*) AS dctrn_count
FROM
  (
    SELECT
      DISTINCT id_1
    FROM
      (
        SELECT
          CASE WHEN p0_.published_at IS NULL THEN 0 ELSE 1 END AS sclr_0,
          p0_.id AS id_1,
          p0_.name AS name_2,
          p0_.menu_name AS menu_name_3,
          p0_.description AS description_4,
          p0_.html AS html_5,
          p0_.title AS title_6,
          p0_.is_active AS is_active_7,
          p0_.slug AS slug_8,
          p0_.javascript AS javascript_9,
          p0_.sequence AS sequence_10,
          p0_.is_menu AS is_menu_11,
          p0_.latitude AS latitude_12,
          p0_.longitude AS longitude_13,
          p0_.state AS state_14,
          p0_.has_comments AS has_comments_15,
          p0_.is_indexable AS is_indexable_16,
          p0_.created_at AS created_at_17,
          p0_.published_at AS published_at_18,
          p1_.id AS id_19,
          p1_.name AS name_20,
          l2_.id AS id_21,
          l2_.name AS name_22,
          l2_.color AS color_23,
          c3_.id AS id_24,
          c3_.name AS name_25,
          c3_.template AS template_26,
          c3_.slug_prefix AS slug_prefix_27,
          u4_.id AS id_28,
          u4_.name AS name_29,
          u4_.extension AS extension_30,
          u4_.mime AS mime_31,
          u4_.title AS title_32,
          u4_.short_description AS short_description_33,
          u4_.description AS description_34,
          u4_.created AS created_35,
          u4_.path AS path_36,
          u4_.original_name AS original_name_37,
          u4_.width AS width_38,
          u4_.height AS height_39,
          u4_.sequence AS sequence_40,
          u4_.note AS note_41,
          u4_.icon AS icon_42,
          c5_.id AS id_43,
          c5_.sequence AS sequence_44,
          m6_.id AS id_45,
          m6_.name AS name_46,
          m6_.template AS template_47,
          m6_.controller_name AS controller_name_48,
          s7_.id AS id_49,
          s7_.name AS name_50,
          s7_.template AS template_51,
          s7_.controller_name AS controller_name_52
        FROM
          p_category p0_
          LEFT JOIN p_category_category p8_ ON p0_.id = p8_.category_sub_id
          LEFT JOIN category_label c9_ ON p0_.id = c9_.category_id
          LEFT JOIN p_label p1_ ON p1_.id = c9_.label_id
          LEFT JOIN label_type l2_ ON p1_.label_type_id = l2_.id
          LEFT JOIN category_type c3_ ON p0_.category_type_id = c3_.id
          LEFT JOIN upload u4_ ON p0_.upload_id = u4_.id
          LEFT JOIN category_menu_type c5_ ON p0_.id = c5_.category_id
          LEFT JOIN menu_type m6_ ON c5_.menu_type_id = m6_.id
          LEFT JOIN category_sub_menu_type c10_ ON p0_.id = c10_.category_id
          LEFT JOIN sub_menu_type s7_ ON s7_.id = c10_.sub_menu_type_id
        WHERE
          p0_.id IN (
            SELECT
              p11_.id
            FROM
              p_category p11_
              LEFT JOIN p_category_category p12_ ON p11_.id = p12_.category_sub_id
            WHERE
              p12_.category_super_id = ?
          )
        ORDER BY
          p8_.sequence ASC,
          sclr_0 DESC,
          p0_.published_at DESC
      ) dctrn_result
  ) dctrn_table

SELECT COUNT(*) AS dctrn_count FROM (SELECT DISTINCT id_1 FROM (SELECT CASE WHEN p0_.published_at IS NULL THEN 0 ELSE 1 END AS sclr_0, p0_.id AS id_1, p0_.name AS name_2, p0_.menu_name AS menu_name_3, p0_.description AS description_4, p0_.html AS html_5, p0_.title AS title_6, p0_.is_active AS is_active_7, p0_.slug AS slug_8, p0_.javascript AS javascript_9, p0_.sequence AS sequence_10, p0_.is_menu AS is_menu_11, p0_.latitude AS latitude_12, p0_.longitude AS longitude_13, p0_.state AS state_14, p0_.has_comments AS has_comments_15, p0_.is_indexable AS is_indexable_16, p0_.created_at AS created_at_17, p0_.published_at AS published_at_18, p1_.id AS id_19, p1_.name AS name_20, l2_.id AS id_21, l2_.name AS name_22, l2_.color AS color_23, c3_.id AS id_24, c3_.name AS name_25, c3_.template AS template_26, c3_.slug_prefix AS slug_prefix_27, u4_.id AS id_28, u4_.name AS name_29, u4_.extension AS extension_30, u4_.mime AS mime_31, u4_.title AS title_32, u4_.short_description AS short_description_33, u4_.description AS description_34, u4_.created AS created_35, u4_.path AS path_36, u4_.original_name AS original_name_37, u4_.width AS width_38, u4_.height AS height_39, u4_.sequence AS sequence_40, u4_.note AS note_41, u4_.icon AS icon_42, c5_.id AS id_43, c5_.sequence AS sequence_44, m6_.id AS id_45, m6_.name AS name_46, m6_.template AS template_47, m6_.controller_name AS controller_name_48, s7_.id AS id_49, s7_.name AS name_50, s7_.template AS template_51, s7_.controller_name AS controller_name_52 FROM p_category p0_ LEFT JOIN p_category_category p8_ ON p0_.id = p8_.category_sub_id LEFT JOIN category_label c9_ ON p0_.id = c9_.category_id LEFT JOIN p_label p1_ ON p1_.id = c9_.label_id LEFT JOIN label_type l2_ ON p1_.label_type_id = l2_.id LEFT JOIN category_type c3_ ON p0_.category_type_id = c3_.id LEFT JOIN upload u4_ ON p0_.upload_id = u4_.id LEFT JOIN category_menu_type c5_ ON p0_.id = c5_.category_id LEFT JOIN menu_type m6_ ON c5_.menu_type_id = m6_.id LEFT JOIN category_sub_menu_type c10_ ON p0_.id = c10_.category_id LEFT JOIN sub_menu_type s7_ ON s7_.id = c10_.sub_menu_type_id WHERE p0_.id IN (SELECT p11_.id FROM p_category p11_ LEFT JOIN p_category_category p12_ ON p11_.id = p12_.category_sub_id WHERE p12_.category_super_id = '2') ORDER BY p8_.sequence ASC, sclr_0 DESC, p0_.published_at DESC) dctrn_result) dctrn_table;

SELECT
  DISTINCT id_1
FROM
  (
    SELECT
      DISTINCT id_1,
      sequence_54,
      sclr_0,
      published_at_18
    FROM
      (
        SELECT
          CASE WHEN p0_.published_at IS NULL THEN 0 ELSE 1 END AS sclr_0,
          p0_.id AS id_1,
          p0_.name AS name_2,
          p0_.menu_name AS menu_name_3,
          p0_.description AS description_4,
          p0_.html AS html_5,
          p0_.title AS title_6,
          p0_.is_active AS is_active_7,
          p0_.slug AS slug_8,
          p0_.javascript AS javascript_9,
          p0_.sequence AS sequence_10,
          p0_.is_menu AS is_menu_11,
          p0_.latitude AS latitude_12,
          p0_.longitude AS longitude_13,
          p0_.state AS state_14,
          p0_.has_comments AS has_comments_15,
          p0_.is_indexable AS is_indexable_16,
          p0_.created_at AS created_at_17,
          p0_.published_at AS published_at_18,
          p1_.id AS id_19,
          p1_.name AS name_20,
          l2_.id AS id_21,
          l2_.name AS name_22,
          l2_.color AS color_23,
          c3_.id AS id_24,
          c3_.name AS name_25,
          c3_.template AS template_26,
          c3_.slug_prefix AS slug_prefix_27,
          u4_.id AS id_28,
          u4_.name AS name_29,
          u4_.extension AS extension_30,
          u4_.mime AS mime_31,
          u4_.title AS title_32,
          u4_.short_description AS short_description_33,
          u4_.description AS description_34,
          u4_.created AS created_35,
          u4_.path AS path_36,
          u4_.original_name AS original_name_37,
          u4_.width AS width_38,
          u4_.height AS height_39,
          u4_.sequence AS sequence_40,
          u4_.note AS note_41,
          u4_.icon AS icon_42,
          c5_.id AS id_43,
          c5_.sequence AS sequence_44,
          m6_.id AS id_45,
          m6_.name AS name_46,
          m6_.template AS template_47,
          m6_.controller_name AS controller_name_48,
          s7_.id AS id_49,
          s7_.name AS name_50,
          s7_.template AS template_51,
          s7_.controller_name AS controller_name_52,
          p8_.id AS id_53,
          p8_.sequence AS sequence_54,
          p8_.is_menu_item AS is_menu_item_55
        FROM
          p_category p0_
          LEFT JOIN p_category_category p8_ ON p0_.id = p8_.category_sub_id
          LEFT JOIN category_label c9_ ON p0_.id = c9_.category_id
          LEFT JOIN p_label p1_ ON p1_.id = c9_.label_id
          LEFT JOIN label_type l2_ ON p1_.label_type_id = l2_.id
          LEFT JOIN category_type c3_ ON p0_.category_type_id = c3_.id
          LEFT JOIN upload u4_ ON p0_.upload_id = u4_.id
          LEFT JOIN category_menu_type c5_ ON p0_.id = c5_.category_id
          LEFT JOIN menu_type m6_ ON c5_.menu_type_id = m6_.id
          LEFT JOIN category_sub_menu_type c10_ ON p0_.id = c10_.category_id
          LEFT JOIN sub_menu_type s7_ ON s7_.id = c10_.sub_menu_type_id
        WHERE
          p0_.id IN (
            SELECT
              p11_.id
            FROM
              p_category p11_
              LEFT JOIN p_category_category p12_ ON p11_.id = p12_.category_sub_id
            WHERE
              p12_.category_super_id = ?
          )
        ORDER BY
          p8_.sequence ASC
      ) dctrn_result_inner
    ORDER BY
      sequence_54 ASC,
      sclr_0 DESC,
      published_at_18 DESC
  ) dctrn_result
LIMIT
  30

SELECT DISTINCT id_1 FROM (SELECT DISTINCT id_1, sequence_54, sclr_0, published_at_18 FROM (SELECT CASE WHEN p0_.published_at IS NULL THEN 0 ELSE 1 END AS sclr_0, p0_.id AS id_1, p0_.name AS name_2, p0_.menu_name AS menu_name_3, p0_.description AS description_4, p0_.html AS html_5, p0_.title AS title_6, p0_.is_active AS is_active_7, p0_.slug AS slug_8, p0_.javascript AS javascript_9, p0_.sequence AS sequence_10, p0_.is_menu AS is_menu_11, p0_.latitude AS latitude_12, p0_.longitude AS longitude_13, p0_.state AS state_14, p0_.has_comments AS has_comments_15, p0_.is_indexable AS is_indexable_16, p0_.created_at AS created_at_17, p0_.published_at AS published_at_18, p1_.id AS id_19, p1_.name AS name_20, l2_.id AS id_21, l2_.name AS name_22, l2_.color AS color_23, c3_.id AS id_24, c3_.name AS name_25, c3_.template AS template_26, c3_.slug_prefix AS slug_prefix_27, u4_.id AS id_28, u4_.name AS name_29, u4_.extension AS extension_30, u4_.mime AS mime_31, u4_.title AS title_32, u4_.short_description AS short_description_33, u4_.description AS description_34, u4_.created AS created_35, u4_.path AS path_36, u4_.original_name AS original_name_37, u4_.width AS width_38, u4_.height AS height_39, u4_.sequence AS sequence_40, u4_.note AS note_41, u4_.icon AS icon_42, c5_.id AS id_43, c5_.sequence AS sequence_44, m6_.id AS id_45, m6_.name AS name_46, m6_.template AS template_47, m6_.controller_name AS controller_name_48, s7_.id AS id_49, s7_.name AS name_50, s7_.template AS template_51, s7_.controller_name AS controller_name_52, p8_.id AS id_53, p8_.sequence AS sequence_54, p8_.is_menu_item AS is_menu_item_55 FROM p_category p0_ LEFT JOIN p_category_category p8_ ON p0_.id = p8_.category_sub_id LEFT JOIN category_label c9_ ON p0_.id = c9_.category_id LEFT JOIN p_label p1_ ON p1_.id = c9_.label_id LEFT JOIN label_type l2_ ON p1_.label_type_id = l2_.id LEFT JOIN category_type c3_ ON p0_.category_type_id = c3_.id LEFT JOIN upload u4_ ON p0_.upload_id = u4_.id LEFT JOIN category_menu_type c5_ ON p0_.id = c5_.category_id LEFT JOIN menu_type m6_ ON c5_.menu_type_id = m6_.id LEFT JOIN category_sub_menu_type c10_ ON p0_.id = c10_.category_id LEFT JOIN sub_menu_type s7_ ON s7_.id = c10_.sub_menu_type_id WHERE p0_.id IN (SELECT p11_.id FROM p_category p11_ LEFT JOIN p_category_category p12_ ON p11_.id = p12_.category_sub_id WHERE p12_.category_super_id = '2') ORDER BY p8_.sequence ASC) dctrn_result_inner ORDER BY sequence_54 ASC, sclr_0 DESC, published_at_18 DESC) dctrn_result LIMIT 30;