Symfony Profiler

SELECT
  t0.context_type AS context_type_1,
  t0.id AS id_2,
  t0.date_add AS date_add_3,
  t0.date_upd AS date_upd_4,
  t0.deleted AS deleted_5,
  t0.locked AS locked_6,
  t0.is_draft AS is_draft_7,
  t0.can_be_deleted AS can_be_deleted_8,
  t0.owner_organization_id AS owner_organization_id_9,
  t0.actor_id AS actor_id_10,
  t11.lastname AS lastname_12,
  t11.firstname AS firstname_13,
  t11.birth_place AS birth_place_14,
  t11.birth_date AS birth_date_15,
  t11.gender AS gender_16,
  t11.id AS id_17,
  t11.date_add AS date_add_18,
  t11.date_upd AS date_upd_19,
  t11.deleted AS deleted_20,
  t11.locked AS locked_21,
  t11.is_draft AS is_draft_22,
  t11.can_be_deleted AS can_be_deleted_23,
  t11.owner_organization_id AS owner_organization_id_24,
  t11.access_id AS access_id_25,
  t11.author_id AS author_id_26,
  t0.organization_id AS organization_id_27,
  t28.name AS name_29,
  t28.is_plateform_manager AS is_plateform_manager_30,
  t28.id AS id_31,
  t28.date_add AS date_add_32,
  t28.date_upd AS date_upd_33,
  t28.deleted AS deleted_34,
  t28.locked AS locked_35,
  t28.is_draft AS is_draft_36,
  t28.can_be_deleted AS can_be_deleted_37,
  t28.owner_organization_id AS owner_organization_id_38,
  t28.actor_id AS actor_id_39,
  t28.thumbnail_id AS thumbnail_id_40,
  t28.author_id AS author_id_41,
  t0.author_id AS author_id_42,
  t43.lastname AS lastname_44,
  t43.firstname AS firstname_45,
  t43.birth_place AS birth_place_46,
  t43.birth_date AS birth_date_47,
  t43.gender AS gender_48,
  t43.id AS id_49,
  t43.date_add AS date_add_50,
  t43.date_upd AS date_upd_51,
  t43.deleted AS deleted_52,
  t43.locked AS locked_53,
  t43.is_draft AS is_draft_54,
  t43.can_be_deleted AS can_be_deleted_55,
  t43.owner_organization_id AS owner_organization_id_56,
  t43.access_id AS access_id_57,
  t43.author_id AS author_id_58
FROM
  app_core_user_workspace t0
  INNER JOIN app_core_user_actor t11 ON t0.actor_id = t11.id
  INNER JOIN app_core_user_organization t28 ON t0.organization_id = t28.id
  LEFT JOIN app_core_user_actor t43 ON t0.author_id = t43.id
WHERE
  t0.deleted = ?
LIMIT
  1

SELECT t0.context_type AS context_type_1, t0.id AS id_2, t0.date_add AS date_add_3, t0.date_upd AS date_upd_4, t0.deleted AS deleted_5, t0.locked AS locked_6, t0.is_draft AS is_draft_7, t0.can_be_deleted AS can_be_deleted_8, t0.owner_organization_id AS owner_organization_id_9, t0.actor_id AS actor_id_10, t11.lastname AS lastname_12, t11.firstname AS firstname_13, t11.birth_place AS birth_place_14, t11.birth_date AS birth_date_15, t11.gender AS gender_16, t11.id AS id_17, t11.date_add AS date_add_18, t11.date_upd AS date_upd_19, t11.deleted AS deleted_20, t11.locked AS locked_21, t11.is_draft AS is_draft_22, t11.can_be_deleted AS can_be_deleted_23, t11.owner_organization_id AS owner_organization_id_24, t11.access_id AS access_id_25, t11.author_id AS author_id_26, t0.organization_id AS organization_id_27, t28.name AS name_29, t28.is_plateform_manager AS is_plateform_manager_30, t28.id AS id_31, t28.date_add AS date_add_32, t28.date_upd AS date_upd_33, t28.deleted AS deleted_34, t28.locked AS locked_35, t28.is_draft AS is_draft_36, t28.can_be_deleted AS can_be_deleted_37, t28.owner_organization_id AS owner_organization_id_38, t28.actor_id AS actor_id_39, t28.thumbnail_id AS thumbnail_id_40, t28.author_id AS author_id_41, t0.author_id AS author_id_42, t43.lastname AS lastname_44, t43.firstname AS firstname_45, t43.birth_place AS birth_place_46, t43.birth_date AS birth_date_47, t43.gender AS gender_48, t43.id AS id_49, t43.date_add AS date_add_50, t43.date_upd AS date_upd_51, t43.deleted AS deleted_52, t43.locked AS locked_53, t43.is_draft AS is_draft_54, t43.can_be_deleted AS can_be_deleted_55, t43.owner_organization_id AS owner_organization_id_56, t43.access_id AS access_id_57, t43.author_id AS author_id_58 FROM app_core_user_workspace t0 INNER JOIN app_core_user_actor t11 ON t0.actor_id = t11.id INNER JOIN app_core_user_organization t28 ON t0.organization_id = t28.id LEFT JOIN app_core_user_actor t43 ON t0.author_id = t43.id WHERE t0.deleted = 0 LIMIT 1;

SELECT
  t0.email AS email_1,
  t0.token AS token_2,
  t0.confirmation_token AS confirmation_token_3,
  t0.context_type AS context_type_4,
  t0.password AS password_5,
  t0.is_active AS is_active_6,
  t0.is_blocked AS is_blocked_7,
  t0.roles AS roles_8,
  t0.id AS id_9,
  t0.date_add AS date_add_10,
  t0.date_upd AS date_upd_11,
  t0.deleted AS deleted_12,
  t0.locked AS locked_13,
  t0.is_draft AS is_draft_14,
  t0.can_be_deleted AS can_be_deleted_15,
  t0.owner_organization_id AS owner_organization_id_16,
  t17.lastname AS lastname_18,
  t17.firstname AS firstname_19,
  t17.birth_place AS birth_place_20,
  t17.birth_date AS birth_date_21,
  t17.gender AS gender_22,
  t17.id AS id_23,
  t17.date_add AS date_add_24,
  t17.date_upd AS date_upd_25,
  t17.deleted AS deleted_26,
  t17.locked AS locked_27,
  t17.is_draft AS is_draft_28,
  t17.can_be_deleted AS can_be_deleted_29,
  t17.owner_organization_id AS owner_organization_id_30,
  t17.access_id AS access_id_31,
  t17.author_id AS author_id_32,
  t0.author_id AS author_id_33,
  t34.lastname AS lastname_35,
  t34.firstname AS firstname_36,
  t34.birth_place AS birth_place_37,
  t34.birth_date AS birth_date_38,
  t34.gender AS gender_39,
  t34.id AS id_40,
  t34.date_add AS date_add_41,
  t34.date_upd AS date_upd_42,
  t34.deleted AS deleted_43,
  t34.locked AS locked_44,
  t34.is_draft AS is_draft_45,
  t34.can_be_deleted AS can_be_deleted_46,
  t34.owner_organization_id AS owner_organization_id_47,
  t34.access_id AS access_id_48,
  t34.author_id AS author_id_49
FROM
  app_core_user_access t0
  LEFT JOIN app_core_user_actor t17 ON t17.access_id = t0.id
  LEFT JOIN app_core_user_actor t34 ON t0.author_id = t34.id
WHERE
  t0.id IN (?)

SELECT t0.email AS email_1, t0.token AS token_2, t0.confirmation_token AS confirmation_token_3, t0.context_type AS context_type_4, t0.password AS password_5, t0.is_active AS is_active_6, t0.is_blocked AS is_blocked_7, t0.roles AS roles_8, t0.id AS id_9, t0.date_add AS date_add_10, t0.date_upd AS date_upd_11, t0.deleted AS deleted_12, t0.locked AS locked_13, t0.is_draft AS is_draft_14, t0.can_be_deleted AS can_be_deleted_15, t0.owner_organization_id AS owner_organization_id_16, t17.lastname AS lastname_18, t17.firstname AS firstname_19, t17.birth_place AS birth_place_20, t17.birth_date AS birth_date_21, t17.gender AS gender_22, t17.id AS id_23, t17.date_add AS date_add_24, t17.date_upd AS date_upd_25, t17.deleted AS deleted_26, t17.locked AS locked_27, t17.is_draft AS is_draft_28, t17.can_be_deleted AS can_be_deleted_29, t17.owner_organization_id AS owner_organization_id_30, t17.access_id AS access_id_31, t17.author_id AS author_id_32, t0.author_id AS author_id_33, t34.lastname AS lastname_35, t34.firstname AS firstname_36, t34.birth_place AS birth_place_37, t34.birth_date AS birth_date_38, t34.gender AS gender_39, t34.id AS id_40, t34.date_add AS date_add_41, t34.date_upd AS date_upd_42, t34.deleted AS deleted_43, t34.locked AS locked_44, t34.is_draft AS is_draft_45, t34.can_be_deleted AS can_be_deleted_46, t34.owner_organization_id AS owner_organization_id_47, t34.access_id AS access_id_48, t34.author_id AS author_id_49 FROM app_core_user_access t0 LEFT JOIN app_core_user_actor t17 ON t17.access_id = t0.id LEFT JOIN app_core_user_actor t34 ON t0.author_id = t34.id WHERE t0.id IN (1);

SELECT
  t0.context_type AS context_type_1,
  t0.id AS id_2,
  t0.date_add AS date_add_3,
  t0.date_upd AS date_upd_4,
  t0.deleted AS deleted_5,
  t0.locked AS locked_6,
  t0.is_draft AS is_draft_7,
  t0.can_be_deleted AS can_be_deleted_8,
  t0.owner_organization_id AS owner_organization_id_9,
  t0.actor_id AS actor_id_10,
  t11.lastname AS lastname_12,
  t11.firstname AS firstname_13,
  t11.birth_place AS birth_place_14,
  t11.birth_date AS birth_date_15,
  t11.gender AS gender_16,
  t11.id AS id_17,
  t11.date_add AS date_add_18,
  t11.date_upd AS date_upd_19,
  t11.deleted AS deleted_20,
  t11.locked AS locked_21,
  t11.is_draft AS is_draft_22,
  t11.can_be_deleted AS can_be_deleted_23,
  t11.owner_organization_id AS owner_organization_id_24,
  t11.access_id AS access_id_25,
  t11.author_id AS author_id_26,
  t0.organization_id AS organization_id_27,
  t28.name AS name_29,
  t28.is_plateform_manager AS is_plateform_manager_30,
  t28.id AS id_31,
  t28.date_add AS date_add_32,
  t28.date_upd AS date_upd_33,
  t28.deleted AS deleted_34,
  t28.locked AS locked_35,
  t28.is_draft AS is_draft_36,
  t28.can_be_deleted AS can_be_deleted_37,
  t28.owner_organization_id AS owner_organization_id_38,
  t28.actor_id AS actor_id_39,
  t28.thumbnail_id AS thumbnail_id_40,
  t28.author_id AS author_id_41,
  t0.author_id AS author_id_42,
  t43.lastname AS lastname_44,
  t43.firstname AS firstname_45,
  t43.birth_place AS birth_place_46,
  t43.birth_date AS birth_date_47,
  t43.gender AS gender_48,
  t43.id AS id_49,
  t43.date_add AS date_add_50,
  t43.date_upd AS date_upd_51,
  t43.deleted AS deleted_52,
  t43.locked AS locked_53,
  t43.is_draft AS is_draft_54,
  t43.can_be_deleted AS can_be_deleted_55,
  t43.owner_organization_id AS owner_organization_id_56,
  t43.access_id AS access_id_57,
  t43.author_id AS author_id_58
FROM
  app_core_user_workspace t0
  INNER JOIN app_core_user_actor t11 ON t0.actor_id = t11.id
  INNER JOIN app_core_user_organization t28 ON t0.organization_id = t28.id
  LEFT JOIN app_core_user_actor t43 ON t0.author_id = t43.id
WHERE
  t0.deleted = ?
LIMIT
  1

SELECT t0.context_type AS context_type_1, t0.id AS id_2, t0.date_add AS date_add_3, t0.date_upd AS date_upd_4, t0.deleted AS deleted_5, t0.locked AS locked_6, t0.is_draft AS is_draft_7, t0.can_be_deleted AS can_be_deleted_8, t0.owner_organization_id AS owner_organization_id_9, t0.actor_id AS actor_id_10, t11.lastname AS lastname_12, t11.firstname AS firstname_13, t11.birth_place AS birth_place_14, t11.birth_date AS birth_date_15, t11.gender AS gender_16, t11.id AS id_17, t11.date_add AS date_add_18, t11.date_upd AS date_upd_19, t11.deleted AS deleted_20, t11.locked AS locked_21, t11.is_draft AS is_draft_22, t11.can_be_deleted AS can_be_deleted_23, t11.owner_organization_id AS owner_organization_id_24, t11.access_id AS access_id_25, t11.author_id AS author_id_26, t0.organization_id AS organization_id_27, t28.name AS name_29, t28.is_plateform_manager AS is_plateform_manager_30, t28.id AS id_31, t28.date_add AS date_add_32, t28.date_upd AS date_upd_33, t28.deleted AS deleted_34, t28.locked AS locked_35, t28.is_draft AS is_draft_36, t28.can_be_deleted AS can_be_deleted_37, t28.owner_organization_id AS owner_organization_id_38, t28.actor_id AS actor_id_39, t28.thumbnail_id AS thumbnail_id_40, t28.author_id AS author_id_41, t0.author_id AS author_id_42, t43.lastname AS lastname_44, t43.firstname AS firstname_45, t43.birth_place AS birth_place_46, t43.birth_date AS birth_date_47, t43.gender AS gender_48, t43.id AS id_49, t43.date_add AS date_add_50, t43.date_upd AS date_upd_51, t43.deleted AS deleted_52, t43.locked AS locked_53, t43.is_draft AS is_draft_54, t43.can_be_deleted AS can_be_deleted_55, t43.owner_organization_id AS owner_organization_id_56, t43.access_id AS access_id_57, t43.author_id AS author_id_58 FROM app_core_user_workspace t0 INNER JOIN app_core_user_actor t11 ON t0.actor_id = t11.id INNER JOIN app_core_user_organization t28 ON t0.organization_id = t28.id LEFT JOIN app_core_user_actor t43 ON t0.author_id = t43.id WHERE t0.deleted = 0 LIMIT 1;

SELECT
  DISTINCT id_9
FROM
  (
    SELECT
      DISTINCT id_9,
      publish_date_1
    FROM
      (
        SELECT
          a0_.type AS type_0,
          a0_.publish_date AS publish_date_1,
          a0_.expiry_date AS expiry_date_2,
          a0_.source_url AS source_url_3,
          a0_.location AS location_4,
          a0_.status AS status_5,
          a0_.is_editor_choice AS is_editor_choice_6,
          a0_.hide_title AS hide_title_7,
          a0_.hide_excerpt AS hide_excerpt_8,
          a0_.id AS id_9,
          a0_.date_add AS date_add_10,
          a0_.date_upd AS date_upd_11,
          a0_.deleted AS deleted_12,
          a0_.locked AS locked_13,
          a0_.is_draft AS is_draft_14,
          a0_.can_be_deleted AS can_be_deleted_15,
          a0_.owner_organization_id AS owner_organization_id_16,
          a1_.excerpt AS excerpt_17,
          a1_.intro AS intro_18,
          a1_.id AS id_19,
          a1_.locale AS locale_20,
          a1_.name AS name_21,
          a1_.description AS description_22,
          a1_.meta_description AS meta_description_23,
          a1_.work_keys AS work_keys_24,
          a1_.slug AS slug_25,
          a2_.color AS color_26,
          a2_.bg_color AS bg_color_27,
          a2_.type AS type_28,
          a2_.target AS target_29,
          a2_.target_menu AS target_menu_30,
          a2_.client_type AS client_type_31,
          a2_.position AS position_32,
          a2_.status AS status_33,
          a2_.id AS id_34,
          a2_.date_add AS date_add_35,
          a2_.date_upd AS date_upd_36,
          a2_.deleted AS deleted_37,
          a2_.locked AS locked_38,
          a2_.is_draft AS is_draft_39,
          a2_.can_be_deleted AS can_be_deleted_40,
          a2_.owner_organization_id AS owner_organization_id_41
        FROM
          app_blog_post a0_
          INNER JOIN app_blog_post_i18n a1_ ON a0_.id = a1_.entity_id
          LEFT JOIN app_blog_post_category a3_ ON a0_.id = a3_.post_id
          LEFT JOIN app_business_category a2_ ON a2_.id = a3_.category_id
        WHERE
          a0_.deleted = 0
          AND a0_.status = 'published'
          AND a0_.type = 'post'
          AND a2_.id = '8'
          AND a0_.deleted = 0
      ) dctrn_result_inner
    ORDER BY
      publish_date_1 DESC
  ) dctrn_result
LIMIT
  10

SELECT DISTINCT id_9 FROM (SELECT DISTINCT id_9, publish_date_1 FROM (SELECT a0_.type AS type_0, a0_.publish_date AS publish_date_1, a0_.expiry_date AS expiry_date_2, a0_.source_url AS source_url_3, a0_.location AS location_4, a0_.status AS status_5, a0_.is_editor_choice AS is_editor_choice_6, a0_.hide_title AS hide_title_7, a0_.hide_excerpt AS hide_excerpt_8, a0_.id AS id_9, a0_.date_add AS date_add_10, a0_.date_upd AS date_upd_11, a0_.deleted AS deleted_12, a0_.locked AS locked_13, a0_.is_draft AS is_draft_14, a0_.can_be_deleted AS can_be_deleted_15, a0_.owner_organization_id AS owner_organization_id_16, a1_.excerpt AS excerpt_17, a1_.intro AS intro_18, a1_.id AS id_19, a1_.locale AS locale_20, a1_.name AS name_21, a1_.description AS description_22, a1_.meta_description AS meta_description_23, a1_.work_keys AS work_keys_24, a1_.slug AS slug_25, a2_.color AS color_26, a2_.bg_color AS bg_color_27, a2_.type AS type_28, a2_.target AS target_29, a2_.target_menu AS target_menu_30, a2_.client_type AS client_type_31, a2_.position AS position_32, a2_.status AS status_33, a2_.id AS id_34, a2_.date_add AS date_add_35, a2_.date_upd AS date_upd_36, a2_.deleted AS deleted_37, a2_.locked AS locked_38, a2_.is_draft AS is_draft_39, a2_.can_be_deleted AS can_be_deleted_40, a2_.owner_organization_id AS owner_organization_id_41 FROM app_blog_post a0_ INNER JOIN app_blog_post_i18n a1_ ON a0_.id = a1_.entity_id LEFT JOIN app_blog_post_category a3_ ON a0_.id = a3_.post_id LEFT JOIN app_business_category a2_ ON a2_.id = a3_.category_id WHERE a0_.deleted = 0 AND a0_.status = 'published' AND a0_.type = 'post' AND a2_.id = '8' AND a0_.deleted = 0) dctrn_result_inner ORDER BY publish_date_1 DESC) dctrn_result LIMIT 10;

SELECT
  COUNT(*) AS dctrn_count
FROM
  (
    SELECT
      DISTINCT id_9
    FROM
      (
        SELECT
          a0_.type AS type_0,
          a0_.publish_date AS publish_date_1,
          a0_.expiry_date AS expiry_date_2,
          a0_.source_url AS source_url_3,
          a0_.location AS location_4,
          a0_.status AS status_5,
          a0_.is_editor_choice AS is_editor_choice_6,
          a0_.hide_title AS hide_title_7,
          a0_.hide_excerpt AS hide_excerpt_8,
          a0_.id AS id_9,
          a0_.date_add AS date_add_10,
          a0_.date_upd AS date_upd_11,
          a0_.deleted AS deleted_12,
          a0_.locked AS locked_13,
          a0_.is_draft AS is_draft_14,
          a0_.can_be_deleted AS can_be_deleted_15,
          a0_.owner_organization_id AS owner_organization_id_16,
          a1_.excerpt AS excerpt_17,
          a1_.intro AS intro_18,
          a1_.id AS id_19,
          a1_.locale AS locale_20,
          a1_.name AS name_21,
          a1_.description AS description_22,
          a1_.meta_description AS meta_description_23,
          a1_.work_keys AS work_keys_24,
          a1_.slug AS slug_25,
          a2_.color AS color_26,
          a2_.bg_color AS bg_color_27,
          a2_.type AS type_28,
          a2_.target AS target_29,
          a2_.target_menu AS target_menu_30,
          a2_.client_type AS client_type_31,
          a2_.position AS position_32,
          a2_.status AS status_33,
          a2_.id AS id_34,
          a2_.date_add AS date_add_35,
          a2_.date_upd AS date_upd_36,
          a2_.deleted AS deleted_37,
          a2_.locked AS locked_38,
          a2_.is_draft AS is_draft_39,
          a2_.can_be_deleted AS can_be_deleted_40,
          a2_.owner_organization_id AS owner_organization_id_41
        FROM
          app_blog_post a0_
          INNER JOIN app_blog_post_i18n a1_ ON a0_.id = a1_.entity_id
          LEFT JOIN app_blog_post_category a3_ ON a0_.id = a3_.post_id
          LEFT JOIN app_business_category a2_ ON a2_.id = a3_.category_id
        WHERE
          a0_.deleted = 0
          AND a0_.status = 'published'
          AND a0_.type = 'post'
          AND a2_.id = '8'
          AND a0_.deleted = 0
        ORDER BY
          a0_.publish_date DESC
      ) dctrn_result
  ) dctrn_table

SELECT COUNT(*) AS dctrn_count FROM (SELECT DISTINCT id_9 FROM (SELECT a0_.type AS type_0, a0_.publish_date AS publish_date_1, a0_.expiry_date AS expiry_date_2, a0_.source_url AS source_url_3, a0_.location AS location_4, a0_.status AS status_5, a0_.is_editor_choice AS is_editor_choice_6, a0_.hide_title AS hide_title_7, a0_.hide_excerpt AS hide_excerpt_8, a0_.id AS id_9, a0_.date_add AS date_add_10, a0_.date_upd AS date_upd_11, a0_.deleted AS deleted_12, a0_.locked AS locked_13, a0_.is_draft AS is_draft_14, a0_.can_be_deleted AS can_be_deleted_15, a0_.owner_organization_id AS owner_organization_id_16, a1_.excerpt AS excerpt_17, a1_.intro AS intro_18, a1_.id AS id_19, a1_.locale AS locale_20, a1_.name AS name_21, a1_.description AS description_22, a1_.meta_description AS meta_description_23, a1_.work_keys AS work_keys_24, a1_.slug AS slug_25, a2_.color AS color_26, a2_.bg_color AS bg_color_27, a2_.type AS type_28, a2_.target AS target_29, a2_.target_menu AS target_menu_30, a2_.client_type AS client_type_31, a2_.position AS position_32, a2_.status AS status_33, a2_.id AS id_34, a2_.date_add AS date_add_35, a2_.date_upd AS date_upd_36, a2_.deleted AS deleted_37, a2_.locked AS locked_38, a2_.is_draft AS is_draft_39, a2_.can_be_deleted AS can_be_deleted_40, a2_.owner_organization_id AS owner_organization_id_41 FROM app_blog_post a0_ INNER JOIN app_blog_post_i18n a1_ ON a0_.id = a1_.entity_id LEFT JOIN app_blog_post_category a3_ ON a0_.id = a3_.post_id LEFT JOIN app_business_category a2_ ON a2_.id = a3_.category_id WHERE a0_.deleted = 0 AND a0_.status = 'published' AND a0_.type = 'post' AND a2_.id = '8' AND a0_.deleted = 0 ORDER BY a0_.publish_date DESC) dctrn_result) dctrn_table;

SELECT
  t0.is_downloaded AS is_downloaded_1,
  t0.is_show_page AS is_show_page_2,
  t0.code AS code_3,
  t0.type AS type_4,
  t0.status AS status_5,
  t0.id AS id_6,
  t0.date_add AS date_add_7,
  t0.date_upd AS date_upd_8,
  t0.deleted AS deleted_9,
  t0.locked AS locked_10,
  t0.is_draft AS is_draft_11,
  t0.can_be_deleted AS can_be_deleted_12,
  t0.owner_organization_id AS owner_organization_id_13,
  t0.attachment_id AS attachment_id_14,
  t15.filename AS filename_16,
  t15.original_name AS original_name_17,
  t15.mime_type AS mime_type_18,
  t15.extension AS extension_19,
  t15.size AS size_20,
  t15.url AS url_21,
  t15.id AS id_22,
  t15.date_add AS date_add_23,
  t15.date_upd AS date_upd_24,
  t15.deleted AS deleted_25,
  t15.locked AS locked_26,
  t15.is_draft AS is_draft_27,
  t15.can_be_deleted AS can_be_deleted_28,
  t15.owner_organization_id AS owner_organization_id_29,
  t15.author_id AS author_id_30,
  t0.author_id AS author_id_31,
  t32.lastname AS lastname_33,
  t32.firstname AS firstname_34,
  t32.birth_place AS birth_place_35,
  t32.birth_date AS birth_date_36,
  t32.gender AS gender_37,
  t32.id AS id_38,
  t32.date_add AS date_add_39,
  t32.date_upd AS date_upd_40,
  t32.deleted AS deleted_41,
  t32.locked AS locked_42,
  t32.is_draft AS is_draft_43,
  t32.can_be_deleted AS can_be_deleted_44,
  t32.owner_organization_id AS owner_organization_id_45,
  t32.access_id AS access_id_46,
  t32.author_id AS author_id_47
FROM
  app_core_cms_page t0
  LEFT JOIN app_core_attachment t15 ON t0.attachment_id = t15.id
  LEFT JOIN app_core_user_actor t32 ON t0.author_id = t32.id
WHERE
  t0.code = ?
LIMIT
  1

SELECT t0.is_downloaded AS is_downloaded_1, t0.is_show_page AS is_show_page_2, t0.code AS code_3, t0.type AS type_4, t0.status AS status_5, t0.id AS id_6, t0.date_add AS date_add_7, t0.date_upd AS date_upd_8, t0.deleted AS deleted_9, t0.locked AS locked_10, t0.is_draft AS is_draft_11, t0.can_be_deleted AS can_be_deleted_12, t0.owner_organization_id AS owner_organization_id_13, t0.attachment_id AS attachment_id_14, t15.filename AS filename_16, t15.original_name AS original_name_17, t15.mime_type AS mime_type_18, t15.extension AS extension_19, t15.size AS size_20, t15.url AS url_21, t15.id AS id_22, t15.date_add AS date_add_23, t15.date_upd AS date_upd_24, t15.deleted AS deleted_25, t15.locked AS locked_26, t15.is_draft AS is_draft_27, t15.can_be_deleted AS can_be_deleted_28, t15.owner_organization_id AS owner_organization_id_29, t15.author_id AS author_id_30, t0.author_id AS author_id_31, t32.lastname AS lastname_33, t32.firstname AS firstname_34, t32.birth_place AS birth_place_35, t32.birth_date AS birth_date_36, t32.gender AS gender_37, t32.id AS id_38, t32.date_add AS date_add_39, t32.date_upd AS date_upd_40, t32.deleted AS deleted_41, t32.locked AS locked_42, t32.is_draft AS is_draft_43, t32.can_be_deleted AS can_be_deleted_44, t32.owner_organization_id AS owner_organization_id_45, t32.access_id AS access_id_46, t32.author_id AS author_id_47 FROM app_core_cms_page t0 LEFT JOIN app_core_attachment t15 ON t0.attachment_id = t15.id LEFT JOIN app_core_user_actor t32 ON t0.author_id = t32.id WHERE t0.code = 'app.post.desc' LIMIT 1;

SELECT
  t0.title AS title_1,
  t0.sub_title AS sub_title_2,
  t0.excerpt AS excerpt_3,
  t0.id AS id_4,
  t0.locale AS locale_5,
  t0.name AS name_6,
  t0.description AS description_7,
  t0.meta_description AS meta_description_8,
  t0.work_keys AS work_keys_9,
  t0.slug AS slug_10,
  t0.entity_id AS entity_id_11,
  t12.is_downloaded AS is_downloaded_13,
  t12.is_show_page AS is_show_page_14,
  t12.code AS code_15,
  t12.type AS type_16,
  t12.status AS status_17,
  t12.id AS id_18,
  t12.date_add AS date_add_19,
  t12.date_upd AS date_upd_20,
  t12.deleted AS deleted_21,
  t12.locked AS locked_22,
  t12.is_draft AS is_draft_23,
  t12.can_be_deleted AS can_be_deleted_24,
  t12.owner_organization_id AS owner_organization_id_25,
  t12.attachment_id AS attachment_id_26,
  t12.author_id AS author_id_27
FROM
  app_core_cms_page_i18n t0
  INNER JOIN app_core_cms_page t12 ON t0.entity_id = t12.id
WHERE
  t0.entity_id = ?

SELECT t0.title AS title_1, t0.sub_title AS sub_title_2, t0.excerpt AS excerpt_3, t0.id AS id_4, t0.locale AS locale_5, t0.name AS name_6, t0.description AS description_7, t0.meta_description AS meta_description_8, t0.work_keys AS work_keys_9, t0.slug AS slug_10, t0.entity_id AS entity_id_11, t12.is_downloaded AS is_downloaded_13, t12.is_show_page AS is_show_page_14, t12.code AS code_15, t12.type AS type_16, t12.status AS status_17, t12.id AS id_18, t12.date_add AS date_add_19, t12.date_upd AS date_upd_20, t12.deleted AS deleted_21, t12.locked AS locked_22, t12.is_draft AS is_draft_23, t12.can_be_deleted AS can_be_deleted_24, t12.owner_organization_id AS owner_organization_id_25, t12.attachment_id AS attachment_id_26, t12.author_id AS author_id_27 FROM app_core_cms_page_i18n t0 INNER JOIN app_core_cms_page t12 ON t0.entity_id = t12.id WHERE t0.entity_id = 7;

SELECT
  DISTINCT id_8
FROM
  (
    SELECT
      DISTINCT id_8,
      position_6
    FROM
      (
        SELECT
          a0_.color AS color_0,
          a0_.bg_color AS bg_color_1,
          a0_.type AS type_2,
          a0_.target AS target_3,
          a0_.target_menu AS target_menu_4,
          a0_.client_type AS client_type_5,
          a0_.position AS position_6,
          a0_.status AS status_7,
          a0_.id AS id_8,
          a0_.date_add AS date_add_9,
          a0_.date_upd AS date_upd_10,
          a0_.deleted AS deleted_11,
          a0_.locked AS locked_12,
          a0_.is_draft AS is_draft_13,
          a0_.can_be_deleted AS can_be_deleted_14,
          a0_.owner_organization_id AS owner_organization_id_15,
          a1_.id AS id_16,
          a1_.locale AS locale_17,
          a1_.name AS name_18,
          a1_.description AS description_19,
          a1_.meta_description AS meta_description_20,
          a1_.work_keys AS work_keys_21,
          a1_.slug AS slug_22
        FROM
          app_business_category a0_
          INNER JOIN app_business_category_i18n a1_ ON a0_.id = a1_.entity_id
        WHERE
          a0_.deleted = 0
          AND a0_.status = 'published'
          AND a0_.type = 'post'
          AND a0_.deleted = 0
      ) dctrn_result_inner
    ORDER BY
      position_6 ASC
  ) dctrn_result
LIMIT
  10

SELECT DISTINCT id_8 FROM (SELECT DISTINCT id_8, position_6 FROM (SELECT a0_.color AS color_0, a0_.bg_color AS bg_color_1, a0_.type AS type_2, a0_.target AS target_3, a0_.target_menu AS target_menu_4, a0_.client_type AS client_type_5, a0_.position AS position_6, a0_.status AS status_7, a0_.id AS id_8, a0_.date_add AS date_add_9, a0_.date_upd AS date_upd_10, a0_.deleted AS deleted_11, a0_.locked AS locked_12, a0_.is_draft AS is_draft_13, a0_.can_be_deleted AS can_be_deleted_14, a0_.owner_organization_id AS owner_organization_id_15, a1_.id AS id_16, a1_.locale AS locale_17, a1_.name AS name_18, a1_.description AS description_19, a1_.meta_description AS meta_description_20, a1_.work_keys AS work_keys_21, a1_.slug AS slug_22 FROM app_business_category a0_ INNER JOIN app_business_category_i18n a1_ ON a0_.id = a1_.entity_id WHERE a0_.deleted = 0 AND a0_.status = 'published' AND a0_.type = 'post' AND a0_.deleted = 0) dctrn_result_inner ORDER BY position_6 ASC) dctrn_result LIMIT 10;