Symfony Profiler

SELECT
  DISTINCT id_7
FROM
  (
    SELECT
      DISTINCT id_7,
      date_add_8
    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_.id AS id_7,
          a0_.date_add AS date_add_8,
          a0_.date_upd AS date_upd_9,
          a0_.deleted AS deleted_10,
          a0_.locked AS locked_11,
          a0_.is_draft AS is_draft_12,
          a0_.can_be_deleted AS can_be_deleted_13,
          a0_.owner_organization_id AS owner_organization_id_14,
          a1_.excerpt AS excerpt_15,
          a1_.intro AS intro_16,
          a1_.id AS id_17,
          a1_.locale AS locale_18,
          a1_.name AS name_19,
          a1_.description AS description_20,
          a1_.meta_description AS meta_description_21,
          a1_.work_keys AS work_keys_22,
          a1_.slug AS slug_23
        FROM
          app_blog_guide a0_
          INNER JOIN app_blog_guide_i18n a1_ ON a0_.id = a1_.entity_id
        WHERE
          a0_.deleted = 0
          AND a0_.deleted = 0
      ) dctrn_result_inner
    ORDER BY
      date_add_8 DESC
  ) dctrn_result
LIMIT
  5

SELECT DISTINCT id_7 FROM (SELECT DISTINCT id_7, date_add_8 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_.id AS id_7, a0_.date_add AS date_add_8, a0_.date_upd AS date_upd_9, a0_.deleted AS deleted_10, a0_.locked AS locked_11, a0_.is_draft AS is_draft_12, a0_.can_be_deleted AS can_be_deleted_13, a0_.owner_organization_id AS owner_organization_id_14, a1_.excerpt AS excerpt_15, a1_.intro AS intro_16, a1_.id AS id_17, a1_.locale AS locale_18, a1_.name AS name_19, a1_.description AS description_20, a1_.meta_description AS meta_description_21, a1_.work_keys AS work_keys_22, a1_.slug AS slug_23 FROM app_blog_guide a0_ INNER JOIN app_blog_guide_i18n a1_ ON a0_.id = a1_.entity_id WHERE a0_.deleted = 0 AND a0_.deleted = 0) dctrn_result_inner ORDER BY date_add_8 DESC) dctrn_result LIMIT 5;

SELECT
  t0.matricule AS matricule_1,
  t0.position AS position_2,
  t0.is_blocked AS is_blocked_3,
  t0.blog_roles AS blog_roles_4,
  t0.id AS id_5,
  t0.date_add AS date_add_6,
  t0.date_upd AS date_upd_7,
  t0.deleted AS deleted_8,
  t0.locked AS locked_9,
  t0.is_draft AS is_draft_10,
  t0.can_be_deleted AS can_be_deleted_11,
  t0.owner_organization_id AS owner_organization_id_12,
  t0.actor_id AS actor_id_13,
  t14.lastname AS lastname_15,
  t14.firstname AS firstname_16,
  t14.birth_place AS birth_place_17,
  t14.birth_date AS birth_date_18,
  t14.gender AS gender_19,
  t14.id AS id_20,
  t14.date_add AS date_add_21,
  t14.date_upd AS date_upd_22,
  t14.deleted AS deleted_23,
  t14.locked AS locked_24,
  t14.is_draft AS is_draft_25,
  t14.can_be_deleted AS can_be_deleted_26,
  t14.owner_organization_id AS owner_organization_id_27,
  t14.access_id AS access_id_28,
  t14.author_id AS author_id_29,
  t0.contact_id AS contact_id_30,
  t31.phone AS phone_32,
  t31.email AS email_33,
  t31.web_site AS web_site_34,
  t31.address AS address_35,
  t31.city AS city_36,
  t31.id AS id_37,
  t31.date_add AS date_add_38,
  t31.date_upd AS date_upd_39,
  t31.deleted AS deleted_40,
  t31.locked AS locked_41,
  t31.is_draft AS is_draft_42,
  t31.can_be_deleted AS can_be_deleted_43,
  t31.owner_organization_id AS owner_organization_id_44,
  t31.country_id AS country_id_45,
  t31.state_id AS state_id_46,
  t31.author_id AS author_id_47,
  t0.organization_id AS organization_id_48,
  t49.name AS name_50,
  t49.is_plateform_manager AS is_plateform_manager_51,
  t49.id AS id_52,
  t49.date_add AS date_add_53,
  t49.date_upd AS date_upd_54,
  t49.deleted AS deleted_55,
  t49.locked AS locked_56,
  t49.is_draft AS is_draft_57,
  t49.can_be_deleted AS can_be_deleted_58,
  t49.owner_organization_id AS owner_organization_id_59,
  t49.actor_id AS actor_id_60,
  t49.thumbnail_id AS thumbnail_id_61,
  t49.author_id AS author_id_62,
  t0.author_id AS author_id_63,
  t64.lastname AS lastname_65,
  t64.firstname AS firstname_66,
  t64.birth_place AS birth_place_67,
  t64.birth_date AS birth_date_68,
  t64.gender AS gender_69,
  t64.id AS id_70,
  t64.date_add AS date_add_71,
  t64.date_upd AS date_upd_72,
  t64.deleted AS deleted_73,
  t64.locked AS locked_74,
  t64.is_draft AS is_draft_75,
  t64.can_be_deleted AS can_be_deleted_76,
  t64.owner_organization_id AS owner_organization_id_77,
  t64.access_id AS access_id_78,
  t64.author_id AS author_id_79
FROM
  app_core_user_collaborator t0
  INNER JOIN app_core_user_actor t14 ON t0.actor_id = t14.id
  LEFT JOIN app_core_location_contact t31 ON t0.contact_id = t31.id
  INNER JOIN app_core_user_organization t49 ON t0.organization_id = t49.id
  LEFT JOIN app_core_user_actor t64 ON t0.author_id = t64.id
WHERE
  t0.actor_id = ?
  AND t0.organization_id = ?
LIMIT
  1

SELECT t0.matricule AS matricule_1, t0.position AS position_2, t0.is_blocked AS is_blocked_3, t0.blog_roles AS blog_roles_4, t0.id AS id_5, t0.date_add AS date_add_6, t0.date_upd AS date_upd_7, t0.deleted AS deleted_8, t0.locked AS locked_9, t0.is_draft AS is_draft_10, t0.can_be_deleted AS can_be_deleted_11, t0.owner_organization_id AS owner_organization_id_12, t0.actor_id AS actor_id_13, t14.lastname AS lastname_15, t14.firstname AS firstname_16, t14.birth_place AS birth_place_17, t14.birth_date AS birth_date_18, t14.gender AS gender_19, t14.id AS id_20, t14.date_add AS date_add_21, t14.date_upd AS date_upd_22, t14.deleted AS deleted_23, t14.locked AS locked_24, t14.is_draft AS is_draft_25, t14.can_be_deleted AS can_be_deleted_26, t14.owner_organization_id AS owner_organization_id_27, t14.access_id AS access_id_28, t14.author_id AS author_id_29, t0.contact_id AS contact_id_30, t31.phone AS phone_32, t31.email AS email_33, t31.web_site AS web_site_34, t31.address AS address_35, t31.city AS city_36, t31.id AS id_37, t31.date_add AS date_add_38, t31.date_upd AS date_upd_39, t31.deleted AS deleted_40, t31.locked AS locked_41, t31.is_draft AS is_draft_42, t31.can_be_deleted AS can_be_deleted_43, t31.owner_organization_id AS owner_organization_id_44, t31.country_id AS country_id_45, t31.state_id AS state_id_46, t31.author_id AS author_id_47, t0.organization_id AS organization_id_48, t49.name AS name_50, t49.is_plateform_manager AS is_plateform_manager_51, t49.id AS id_52, t49.date_add AS date_add_53, t49.date_upd AS date_upd_54, t49.deleted AS deleted_55, t49.locked AS locked_56, t49.is_draft AS is_draft_57, t49.can_be_deleted AS can_be_deleted_58, t49.owner_organization_id AS owner_organization_id_59, t49.actor_id AS actor_id_60, t49.thumbnail_id AS thumbnail_id_61, t49.author_id AS author_id_62, t0.author_id AS author_id_63, t64.lastname AS lastname_65, t64.firstname AS firstname_66, t64.birth_place AS birth_place_67, t64.birth_date AS birth_date_68, t64.gender AS gender_69, t64.id AS id_70, t64.date_add AS date_add_71, t64.date_upd AS date_upd_72, t64.deleted AS deleted_73, t64.locked AS locked_74, t64.is_draft AS is_draft_75, t64.can_be_deleted AS can_be_deleted_76, t64.owner_organization_id AS owner_organization_id_77, t64.access_id AS access_id_78, t64.author_id AS author_id_79 FROM app_core_user_collaborator t0 INNER JOIN app_core_user_actor t14 ON t0.actor_id = t14.id LEFT JOIN app_core_location_contact t31 ON t0.contact_id = t31.id INNER JOIN app_core_user_organization t49 ON t0.organization_id = t49.id LEFT JOIN app_core_user_actor t64 ON t0.author_id = t64.id WHERE t0.actor_id = 1 AND t0.organization_id = 1 LIMIT 1;

SELECT
  a0_.email AS email_0,
  a0_.token AS token_1,
  a0_.confirmation_token AS confirmation_token_2,
  a0_.context_type AS context_type_3,
  a0_.password AS password_4,
  a0_.is_active AS is_active_5,
  a0_.is_blocked AS is_blocked_6,
  a0_.roles AS roles_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,
  a0_.author_id AS author_id_16
FROM
  app_core_user_access a0_
WHERE
  a0_.email = ?
  AND a0_.is_active = 1

SELECT a0_.email AS email_0, a0_.token AS token_1, a0_.confirmation_token AS confirmation_token_2, a0_.context_type AS context_type_3, a0_.password AS password_4, a0_.is_active AS is_active_5, a0_.is_blocked AS is_blocked_6, a0_.roles AS roles_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, a0_.author_id AS author_id_16 FROM app_core_user_access a0_ WHERE a0_.email = 'admin@technique.loc' AND a0_.is_active = 1;

SELECT
  a0_.context_type AS context_type_0,
  a0_.id AS id_1,
  a0_.date_add AS date_add_2,
  a0_.date_upd AS date_upd_3,
  a0_.deleted AS deleted_4,
  a0_.locked AS locked_5,
  a0_.is_draft AS is_draft_6,
  a0_.can_be_deleted AS can_be_deleted_7,
  a0_.owner_organization_id AS owner_organization_id_8,
  a1_.lastname AS lastname_9,
  a1_.firstname AS firstname_10,
  a1_.birth_place AS birth_place_11,
  a1_.birth_date AS birth_date_12,
  a1_.gender AS gender_13,
  a1_.id AS id_14,
  a1_.date_add AS date_add_15,
  a1_.date_upd AS date_upd_16,
  a1_.deleted AS deleted_17,
  a1_.locked AS locked_18,
  a1_.is_draft AS is_draft_19,
  a1_.can_be_deleted AS can_be_deleted_20,
  a1_.owner_organization_id AS owner_organization_id_21,
  a0_.actor_id AS actor_id_22,
  a0_.organization_id AS organization_id_23,
  a0_.author_id AS author_id_24,
  a1_.access_id AS access_id_25,
  a1_.author_id AS author_id_26
FROM
  app_core_user_workspace a0_
  INNER JOIN app_core_user_actor a1_ ON a0_.actor_id = a1_.id
WHERE
  a1_.access_id = ?

SELECT a0_.context_type AS context_type_0, a0_.id AS id_1, a0_.date_add AS date_add_2, a0_.date_upd AS date_upd_3, a0_.deleted AS deleted_4, a0_.locked AS locked_5, a0_.is_draft AS is_draft_6, a0_.can_be_deleted AS can_be_deleted_7, a0_.owner_organization_id AS owner_organization_id_8, a1_.lastname AS lastname_9, a1_.firstname AS firstname_10, a1_.birth_place AS birth_place_11, a1_.birth_date AS birth_date_12, a1_.gender AS gender_13, a1_.id AS id_14, a1_.date_add AS date_add_15, a1_.date_upd AS date_upd_16, a1_.deleted AS deleted_17, a1_.locked AS locked_18, a1_.is_draft AS is_draft_19, a1_.can_be_deleted AS can_be_deleted_20, a1_.owner_organization_id AS owner_organization_id_21, a0_.actor_id AS actor_id_22, a0_.organization_id AS organization_id_23, a0_.author_id AS author_id_24, a1_.access_id AS access_id_25, a1_.author_id AS author_id_26 FROM app_core_user_workspace a0_ INNER JOIN app_core_user_actor a1_ ON a0_.actor_id = a1_.id WHERE a1_.access_id = 1;

SELECT
  t0.lastname AS lastname_1,
  t0.firstname AS firstname_2,
  t0.birth_place AS birth_place_3,
  t0.birth_date AS birth_date_4,
  t0.gender AS gender_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.access_id AS access_id_14,
  t15.email AS email_16,
  t15.token AS token_17,
  t15.confirmation_token AS confirmation_token_18,
  t15.context_type AS context_type_19,
  t15.password AS password_20,
  t15.is_active AS is_active_21,
  t15.is_blocked AS is_blocked_22,
  t15.roles AS roles_23,
  t15.id AS id_24,
  t15.date_add AS date_add_25,
  t15.date_upd AS date_upd_26,
  t15.deleted AS deleted_27,
  t15.locked AS locked_28,
  t15.is_draft AS is_draft_29,
  t15.can_be_deleted AS can_be_deleted_30,
  t15.owner_organization_id AS owner_organization_id_31,
  t15.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_actor t0
  INNER JOIN app_core_user_access t15 ON t0.access_id = t15.id
  LEFT JOIN app_core_user_actor t34 ON t0.author_id = t34.id
WHERE
  t0.access_id = ?

SELECT t0.lastname AS lastname_1, t0.firstname AS firstname_2, t0.birth_place AS birth_place_3, t0.birth_date AS birth_date_4, t0.gender AS gender_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.access_id AS access_id_14, t15.email AS email_16, t15.token AS token_17, t15.confirmation_token AS confirmation_token_18, t15.context_type AS context_type_19, t15.password AS password_20, t15.is_active AS is_active_21, t15.is_blocked AS is_blocked_22, t15.roles AS roles_23, t15.id AS id_24, t15.date_add AS date_add_25, t15.date_upd AS date_upd_26, t15.deleted AS deleted_27, t15.locked AS locked_28, t15.is_draft AS is_draft_29, t15.can_be_deleted AS can_be_deleted_30, t15.owner_organization_id AS owner_organization_id_31, t15.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_actor t0 INNER JOIN app_core_user_access t15 ON t0.access_id = t15.id LEFT JOIN app_core_user_actor t34 ON t0.author_id = t34.id WHERE t0.access_id = 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.actor_id = ?
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.actor_id = 1 LIMIT 1;

SELECT
  t0.name AS name_1,
  t0.is_plateform_manager AS is_plateform_manager_2,
  t0.id AS id_3,
  t0.date_add AS date_add_4,
  t0.date_upd AS date_upd_5,
  t0.deleted AS deleted_6,
  t0.locked AS locked_7,
  t0.is_draft AS is_draft_8,
  t0.can_be_deleted AS can_be_deleted_9,
  t0.owner_organization_id AS owner_organization_id_10,
  t0.actor_id AS actor_id_11,
  t12.lastname AS lastname_13,
  t12.firstname AS firstname_14,
  t12.birth_place AS birth_place_15,
  t12.birth_date AS birth_date_16,
  t12.gender AS gender_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.access_id AS access_id_26,
  t12.author_id AS author_id_27,
  t0.thumbnail_id AS thumbnail_id_28,
  t29.filename AS filename_30,
  t29.original_name AS original_name_31,
  t29.mime_type AS mime_type_32,
  t29.extension AS extension_33,
  t29.size AS size_34,
  t29.url AS url_35,
  t29.id AS id_36,
  t29.date_add AS date_add_37,
  t29.date_upd AS date_upd_38,
  t29.deleted AS deleted_39,
  t29.locked AS locked_40,
  t29.is_draft AS is_draft_41,
  t29.can_be_deleted AS can_be_deleted_42,
  t29.owner_organization_id AS owner_organization_id_43,
  t29.author_id AS author_id_44,
  t0.author_id AS author_id_45,
  t46.lastname AS lastname_47,
  t46.firstname AS firstname_48,
  t46.birth_place AS birth_place_49,
  t46.birth_date AS birth_date_50,
  t46.gender AS gender_51,
  t46.id AS id_52,
  t46.date_add AS date_add_53,
  t46.date_upd AS date_upd_54,
  t46.deleted AS deleted_55,
  t46.locked AS locked_56,
  t46.is_draft AS is_draft_57,
  t46.can_be_deleted AS can_be_deleted_58,
  t46.owner_organization_id AS owner_organization_id_59,
  t46.access_id AS access_id_60,
  t46.author_id AS author_id_61
FROM
  app_core_user_organization t0
  INNER JOIN app_core_user_actor t12 ON t0.actor_id = t12.id
  LEFT JOIN app_core_attachment t29 ON t0.thumbnail_id = t29.id
  LEFT JOIN app_core_user_actor t46 ON t0.author_id = t46.id
WHERE
  t0.id IN (?)

SELECT t0.name AS name_1, t0.is_plateform_manager AS is_plateform_manager_2, t0.id AS id_3, t0.date_add AS date_add_4, t0.date_upd AS date_upd_5, t0.deleted AS deleted_6, t0.locked AS locked_7, t0.is_draft AS is_draft_8, t0.can_be_deleted AS can_be_deleted_9, t0.owner_organization_id AS owner_organization_id_10, t0.actor_id AS actor_id_11, t12.lastname AS lastname_13, t12.firstname AS firstname_14, t12.birth_place AS birth_place_15, t12.birth_date AS birth_date_16, t12.gender AS gender_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.access_id AS access_id_26, t12.author_id AS author_id_27, t0.thumbnail_id AS thumbnail_id_28, t29.filename AS filename_30, t29.original_name AS original_name_31, t29.mime_type AS mime_type_32, t29.extension AS extension_33, t29.size AS size_34, t29.url AS url_35, t29.id AS id_36, t29.date_add AS date_add_37, t29.date_upd AS date_upd_38, t29.deleted AS deleted_39, t29.locked AS locked_40, t29.is_draft AS is_draft_41, t29.can_be_deleted AS can_be_deleted_42, t29.owner_organization_id AS owner_organization_id_43, t29.author_id AS author_id_44, t0.author_id AS author_id_45, t46.lastname AS lastname_47, t46.firstname AS firstname_48, t46.birth_place AS birth_place_49, t46.birth_date AS birth_date_50, t46.gender AS gender_51, t46.id AS id_52, t46.date_add AS date_add_53, t46.date_upd AS date_upd_54, t46.deleted AS deleted_55, t46.locked AS locked_56, t46.is_draft AS is_draft_57, t46.can_be_deleted AS can_be_deleted_58, t46.owner_organization_id AS owner_organization_id_59, t46.access_id AS access_id_60, t46.author_id AS author_id_61 FROM app_core_user_organization t0 INNER JOIN app_core_user_actor t12 ON t0.actor_id = t12.id LEFT JOIN app_core_attachment t29 ON t0.thumbnail_id = t29.id LEFT JOIN app_core_user_actor t46 ON t0.author_id = t46.id WHERE t0.id IN (1);

SELECT
  COUNT(*) AS dctrn_count
FROM
  (
    SELECT
      DISTINCT id_7
    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_.id AS id_7,
          a0_.date_add AS date_add_8,
          a0_.date_upd AS date_upd_9,
          a0_.deleted AS deleted_10,
          a0_.locked AS locked_11,
          a0_.is_draft AS is_draft_12,
          a0_.can_be_deleted AS can_be_deleted_13,
          a0_.owner_organization_id AS owner_organization_id_14,
          a1_.excerpt AS excerpt_15,
          a1_.intro AS intro_16,
          a1_.id AS id_17,
          a1_.locale AS locale_18,
          a1_.name AS name_19,
          a1_.description AS description_20,
          a1_.meta_description AS meta_description_21,
          a1_.work_keys AS work_keys_22,
          a1_.slug AS slug_23
        FROM
          app_blog_guide a0_
          INNER JOIN app_blog_guide_i18n a1_ ON a0_.id = a1_.entity_id
        WHERE
          a0_.deleted = 0
          AND a0_.deleted = 0
        ORDER BY
          a0_.date_add DESC
      ) dctrn_result
  ) dctrn_table

SELECT COUNT(*) AS dctrn_count FROM (SELECT DISTINCT id_7 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_.id AS id_7, a0_.date_add AS date_add_8, a0_.date_upd AS date_upd_9, a0_.deleted AS deleted_10, a0_.locked AS locked_11, a0_.is_draft AS is_draft_12, a0_.can_be_deleted AS can_be_deleted_13, a0_.owner_organization_id AS owner_organization_id_14, a1_.excerpt AS excerpt_15, a1_.intro AS intro_16, a1_.id AS id_17, a1_.locale AS locale_18, a1_.name AS name_19, a1_.description AS description_20, a1_.meta_description AS meta_description_21, a1_.work_keys AS work_keys_22, a1_.slug AS slug_23 FROM app_blog_guide a0_ INNER JOIN app_blog_guide_i18n a1_ ON a0_.id = a1_.entity_id WHERE a0_.deleted = 0 AND a0_.deleted = 0 ORDER BY a0_.date_add DESC) dctrn_result) dctrn_table;