Symfony Profiler

SELECT
  r0_.id AS id_0,
  r0_.title AS title_1,
  r0_.slug AS slug_2,
  r0_.path AS path_3,
  r0_.position AS position_4,
  r0_.date_created AS date_created_5,
  r0_.visibility AS visibility_6,
  r0_.parent_id AS parent_id_7,
  r0_.route_name AS route_name_8,
  r0_.template AS template_9,
  r0_.layout_type AS layout_type_10,
  r0_.controller AS controller_11,
  r0_.content_type AS content_type_12,
  r0_.controller AS controller_13,
  r0_.content_type AS content_type_14,
  r0_.url AS url_15,
  r0_.permanent AS permanent_16,
  r0_.route_type AS route_type_17
FROM
  route r0_
WHERE
  r0_.route_type IN (
    'list', 'post', 'page', 'taxon', 'url'
  )
ORDER BY
  r0_.position ASC

SELECT r0_.id AS id_0, r0_.title AS title_1, r0_.slug AS slug_2, r0_.path AS path_3, r0_.position AS position_4, r0_.date_created AS date_created_5, r0_.visibility AS visibility_6, r0_.parent_id AS parent_id_7, r0_.route_name AS route_name_8, r0_.template AS template_9, r0_.layout_type AS layout_type_10, r0_.controller AS controller_11, r0_.content_type AS content_type_12, r0_.controller AS controller_13, r0_.content_type AS content_type_14, r0_.url AS url_15, r0_.permanent AS permanent_16, r0_.route_type AS route_type_17 FROM route r0_ WHERE r0_.route_type IN ('list', 'post', 'page', 'taxon', 'url') ORDER BY r0_.position ASC;

SELECT
  DISTINCT id_0
FROM
  (
    SELECT
      DISTINCT id_0,
      date_published_15
    FROM
      (
        SELECT
          c0_.id AS id_0,
          c0_.unique_id AS unique_id_1,
          c0_.title AS title_2,
          c0_.slug AS slug_3,
          c0_.summary AS summary_4,
          c0_.body AS body_5,
          c0_.icon AS icon_6,
          c0_.thumbnail AS thumbnail_7,
          c0_.status AS status_8,
          c0_.is_featured AS is_featured_9,
          c0_.promoted AS promoted_10,
          c0_.publish_on_socialmedia AS publish_on_socialmedia_11,
          c0_.is_published_social_media AS is_published_social_media_12,
          c0_.is_home AS is_home_13,
          c0_.date_created AS date_created_14,
          c0_.date_published AS date_published_15,
          c0_.meta_keywords AS meta_keywords_16,
          c0_.meta_description AS meta_description_17,
          p2_.parent_id AS parent_id_18,
          p3_.price AS price_19,
          p3_.sku AS sku_20,
          p3_.brand AS brand_21,
          p3_.country AS country_22,
          p3_.vendor_code AS vendor_code_23,
          e4_.event_date AS event_date_24,
          e4_.end_date AS end_date_25,
          e4_.event_time AS event_time_26,
          e4_.event_venue AS event_venue_27,
          e4_.country AS country_28,
          e4_.is_register_require AS is_register_require_29,
          e4_.price AS price_30,
          v6_.youtube_video_id AS youtube_video_id_31,
          d7_.file_name AS file_name_32,
          d7_.extension AS extension_33,
          a8_.audio_file AS audio_file_34,
          a8_.audio_author AS audio_author_35,
          p9_.year AS year_36,
          p9_.client AS client_37,
          p9_.location AS location_38,
          p9_.project_name AS project_name_39,
          h10_.price AS price_40,
          h10_.bedrooms AS bedrooms_41,
          h10_.bathrooms AS bathrooms_42,
          h10_.is_furnished AS is_furnished_43,
          h10_.square_meters AS square_meters_44,
          h10_.house_type AS house_type_45,
          h10_.location AS location_46,
          l11_.price AS price_47,
          l11_.plot_size AS plot_size_48,
          l11_.location AS location_49,
          u12_.id AS id_50,
          u12_.username AS username_51,
          u12_.firstname AS firstname_52,
          u12_.lastname AS lastname_53,
          u12_.gender AS gender_54,
          u12_.dob AS dob_55,
          u12_.contact_number AS contact_number_56,
          u12_.email AS email_57,
          u12_.address AS address_58,
          u12_.city AS city_59,
          u12_.country AS country_60,
          u12_.postal_code AS postal_code_61,
          u12_.roles AS roles_62,
          u12_.date_registered AS date_registered_63,
          u12_.date_deactivated AS date_deactivated_64,
          u12_.password AS password_65,
          u12_.salt AS salt_66,
          u12_.is_logged_in AS is_logged_in_67,
          u12_.account_status AS account_status_68,
          u12_.date_last_active AS date_last_active_69,
          u12_.is_active AS is_active_70,
          u12_.is_activated AS is_activated_71,
          u12_.is_phone_verify AS is_phone_verify_72,
          u12_.created_at AS created_at_73,
          u12_.thumbnail AS thumbnail_74,
          c0_.content_type AS content_type_75,
          u12_.user_type AS user_type_76
        FROM
          contents c0_
          LEFT JOIN article a1_ ON c0_.id = a1_.id
          LEFT JOIN page p2_ ON c0_.id = p2_.id
          LEFT JOIN product p3_ ON c0_.id = p3_.id
          LEFT JOIN events e4_ ON c0_.id = e4_.id
          LEFT JOIN album a5_ ON c0_.id = a5_.id
          LEFT JOIN video v6_ ON c0_.id = v6_.id
          LEFT JOIN document d7_ ON c0_.id = d7_.id
          LEFT JOIN audio a8_ ON c0_.id = a8_.id
          LEFT JOIN project p9_ ON c0_.id = p9_.id
          LEFT JOIN house h10_ ON c0_.id = h10_.id
          LEFT JOIN land l11_ ON c0_.id = l11_.id
          LEFT JOIN users u12_ ON c0_.user_id = u12_.id
          LEFT JOIN user_admin u13_ ON u12_.id = u13_.id
        WHERE
          (
            c0_.content_type IN ('house')
          )
          AND c0_.status = ?
      ) dctrn_result_inner
    ORDER BY
      date_published_15 DESC
  ) dctrn_result
LIMIT
  20

SELECT DISTINCT id_0 FROM (SELECT DISTINCT id_0, date_published_15 FROM (SELECT c0_.id AS id_0, c0_.unique_id AS unique_id_1, c0_.title AS title_2, c0_.slug AS slug_3, c0_.summary AS summary_4, c0_.body AS body_5, c0_.icon AS icon_6, c0_.thumbnail AS thumbnail_7, c0_.status AS status_8, c0_.is_featured AS is_featured_9, c0_.promoted AS promoted_10, c0_.publish_on_socialmedia AS publish_on_socialmedia_11, c0_.is_published_social_media AS is_published_social_media_12, c0_.is_home AS is_home_13, c0_.date_created AS date_created_14, c0_.date_published AS date_published_15, c0_.meta_keywords AS meta_keywords_16, c0_.meta_description AS meta_description_17, p2_.parent_id AS parent_id_18, p3_.price AS price_19, p3_.sku AS sku_20, p3_.brand AS brand_21, p3_.country AS country_22, p3_.vendor_code AS vendor_code_23, e4_.event_date AS event_date_24, e4_.end_date AS end_date_25, e4_.event_time AS event_time_26, e4_.event_venue AS event_venue_27, e4_.country AS country_28, e4_.is_register_require AS is_register_require_29, e4_.price AS price_30, v6_.youtube_video_id AS youtube_video_id_31, d7_.file_name AS file_name_32, d7_.extension AS extension_33, a8_.audio_file AS audio_file_34, a8_.audio_author AS audio_author_35, p9_.year AS year_36, p9_.client AS client_37, p9_.location AS location_38, p9_.project_name AS project_name_39, h10_.price AS price_40, h10_.bedrooms AS bedrooms_41, h10_.bathrooms AS bathrooms_42, h10_.is_furnished AS is_furnished_43, h10_.square_meters AS square_meters_44, h10_.house_type AS house_type_45, h10_.location AS location_46, l11_.price AS price_47, l11_.plot_size AS plot_size_48, l11_.location AS location_49, u12_.id AS id_50, u12_.username AS username_51, u12_.firstname AS firstname_52, u12_.lastname AS lastname_53, u12_.gender AS gender_54, u12_.dob AS dob_55, u12_.contact_number AS contact_number_56, u12_.email AS email_57, u12_.address AS address_58, u12_.city AS city_59, u12_.country AS country_60, u12_.postal_code AS postal_code_61, u12_.roles AS roles_62, u12_.date_registered AS date_registered_63, u12_.date_deactivated AS date_deactivated_64, u12_.password AS password_65, u12_.salt AS salt_66, u12_.is_logged_in AS is_logged_in_67, u12_.account_status AS account_status_68, u12_.date_last_active AS date_last_active_69, u12_.is_active AS is_active_70, u12_.is_activated AS is_activated_71, u12_.is_phone_verify AS is_phone_verify_72, u12_.created_at AS created_at_73, u12_.thumbnail AS thumbnail_74, c0_.content_type AS content_type_75, u12_.user_type AS user_type_76 FROM contents c0_ LEFT JOIN article a1_ ON c0_.id = a1_.id LEFT JOIN page p2_ ON c0_.id = p2_.id LEFT JOIN product p3_ ON c0_.id = p3_.id LEFT JOIN events e4_ ON c0_.id = e4_.id LEFT JOIN album a5_ ON c0_.id = a5_.id LEFT JOIN video v6_ ON c0_.id = v6_.id LEFT JOIN document d7_ ON c0_.id = d7_.id LEFT JOIN audio a8_ ON c0_.id = a8_.id LEFT JOIN project p9_ ON c0_.id = p9_.id LEFT JOIN house h10_ ON c0_.id = h10_.id LEFT JOIN land l11_ ON c0_.id = l11_.id LEFT JOIN users u12_ ON c0_.user_id = u12_.id LEFT JOIN user_admin u13_ ON u12_.id = u13_.id WHERE (c0_.content_type IN ('house')) AND c0_.status = 'published') dctrn_result_inner ORDER BY date_published_15 DESC) dctrn_result LIMIT 20;

SELECT
  c0_.id AS id_0,
  c0_.unique_id AS unique_id_1,
  c0_.title AS title_2,
  c0_.slug AS slug_3,
  c0_.summary AS summary_4,
  c0_.body AS body_5,
  c0_.icon AS icon_6,
  c0_.thumbnail AS thumbnail_7,
  c0_.status AS status_8,
  c0_.is_featured AS is_featured_9,
  c0_.promoted AS promoted_10,
  c0_.publish_on_socialmedia AS publish_on_socialmedia_11,
  c0_.is_published_social_media AS is_published_social_media_12,
  c0_.is_home AS is_home_13,
  c0_.date_created AS date_created_14,
  c0_.date_published AS date_published_15,
  c0_.meta_keywords AS meta_keywords_16,
  c0_.meta_description AS meta_description_17,
  p2_.parent_id AS parent_id_18,
  p3_.price AS price_19,
  p3_.sku AS sku_20,
  p3_.brand AS brand_21,
  p3_.country AS country_22,
  p3_.vendor_code AS vendor_code_23,
  e4_.event_date AS event_date_24,
  e4_.end_date AS end_date_25,
  e4_.event_time AS event_time_26,
  e4_.event_venue AS event_venue_27,
  e4_.country AS country_28,
  e4_.is_register_require AS is_register_require_29,
  e4_.price AS price_30,
  v6_.youtube_video_id AS youtube_video_id_31,
  d7_.file_name AS file_name_32,
  d7_.extension AS extension_33,
  a8_.audio_file AS audio_file_34,
  a8_.audio_author AS audio_author_35,
  p9_.year AS year_36,
  p9_.client AS client_37,
  p9_.location AS location_38,
  p9_.project_name AS project_name_39,
  h10_.price AS price_40,
  h10_.bedrooms AS bedrooms_41,
  h10_.bathrooms AS bathrooms_42,
  h10_.is_furnished AS is_furnished_43,
  h10_.square_meters AS square_meters_44,
  h10_.house_type AS house_type_45,
  h10_.location AS location_46,
  l11_.price AS price_47,
  l11_.plot_size AS plot_size_48,
  l11_.location AS location_49,
  u12_.id AS id_50,
  u12_.username AS username_51,
  u12_.firstname AS firstname_52,
  u12_.lastname AS lastname_53,
  u12_.gender AS gender_54,
  u12_.dob AS dob_55,
  u12_.contact_number AS contact_number_56,
  u12_.email AS email_57,
  u12_.address AS address_58,
  u12_.city AS city_59,
  u12_.country AS country_60,
  u12_.postal_code AS postal_code_61,
  u12_.roles AS roles_62,
  u12_.date_registered AS date_registered_63,
  u12_.date_deactivated AS date_deactivated_64,
  u12_.password AS password_65,
  u12_.salt AS salt_66,
  u12_.is_logged_in AS is_logged_in_67,
  u12_.account_status AS account_status_68,
  u12_.date_last_active AS date_last_active_69,
  u12_.is_active AS is_active_70,
  u12_.is_activated AS is_activated_71,
  u12_.is_phone_verify AS is_phone_verify_72,
  u12_.created_at AS created_at_73,
  u12_.thumbnail AS thumbnail_74,
  c0_.content_type AS content_type_75,
  c0_.user_id AS user_id_76,
  c0_.term_id AS term_id_77,
  p2_.route_id AS route_id_78,
  u12_.user_type AS user_type_79
FROM
  contents c0_
  LEFT JOIN article a1_ ON c0_.id = a1_.id
  LEFT JOIN page p2_ ON c0_.id = p2_.id
  LEFT JOIN product p3_ ON c0_.id = p3_.id
  LEFT JOIN events e4_ ON c0_.id = e4_.id
  LEFT JOIN album a5_ ON c0_.id = a5_.id
  LEFT JOIN video v6_ ON c0_.id = v6_.id
  LEFT JOIN document d7_ ON c0_.id = d7_.id
  LEFT JOIN audio a8_ ON c0_.id = a8_.id
  LEFT JOIN project p9_ ON c0_.id = p9_.id
  LEFT JOIN house h10_ ON c0_.id = h10_.id
  LEFT JOIN land l11_ ON c0_.id = l11_.id
  LEFT JOIN users u12_ ON c0_.user_id = u12_.id
  LEFT JOIN user_admin u13_ ON u12_.id = u13_.id
WHERE
  (
    c0_.content_type IN ('house')
  )
  AND c0_.status = ?
  AND c0_.id IN (
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?
  )
ORDER BY
  c0_.date_published DESC

SELECT c0_.id AS id_0, c0_.unique_id AS unique_id_1, c0_.title AS title_2, c0_.slug AS slug_3, c0_.summary AS summary_4, c0_.body AS body_5, c0_.icon AS icon_6, c0_.thumbnail AS thumbnail_7, c0_.status AS status_8, c0_.is_featured AS is_featured_9, c0_.promoted AS promoted_10, c0_.publish_on_socialmedia AS publish_on_socialmedia_11, c0_.is_published_social_media AS is_published_social_media_12, c0_.is_home AS is_home_13, c0_.date_created AS date_created_14, c0_.date_published AS date_published_15, c0_.meta_keywords AS meta_keywords_16, c0_.meta_description AS meta_description_17, p2_.parent_id AS parent_id_18, p3_.price AS price_19, p3_.sku AS sku_20, p3_.brand AS brand_21, p3_.country AS country_22, p3_.vendor_code AS vendor_code_23, e4_.event_date AS event_date_24, e4_.end_date AS end_date_25, e4_.event_time AS event_time_26, e4_.event_venue AS event_venue_27, e4_.country AS country_28, e4_.is_register_require AS is_register_require_29, e4_.price AS price_30, v6_.youtube_video_id AS youtube_video_id_31, d7_.file_name AS file_name_32, d7_.extension AS extension_33, a8_.audio_file AS audio_file_34, a8_.audio_author AS audio_author_35, p9_.year AS year_36, p9_.client AS client_37, p9_.location AS location_38, p9_.project_name AS project_name_39, h10_.price AS price_40, h10_.bedrooms AS bedrooms_41, h10_.bathrooms AS bathrooms_42, h10_.is_furnished AS is_furnished_43, h10_.square_meters AS square_meters_44, h10_.house_type AS house_type_45, h10_.location AS location_46, l11_.price AS price_47, l11_.plot_size AS plot_size_48, l11_.location AS location_49, u12_.id AS id_50, u12_.username AS username_51, u12_.firstname AS firstname_52, u12_.lastname AS lastname_53, u12_.gender AS gender_54, u12_.dob AS dob_55, u12_.contact_number AS contact_number_56, u12_.email AS email_57, u12_.address AS address_58, u12_.city AS city_59, u12_.country AS country_60, u12_.postal_code AS postal_code_61, u12_.roles AS roles_62, u12_.date_registered AS date_registered_63, u12_.date_deactivated AS date_deactivated_64, u12_.password AS password_65, u12_.salt AS salt_66, u12_.is_logged_in AS is_logged_in_67, u12_.account_status AS account_status_68, u12_.date_last_active AS date_last_active_69, u12_.is_active AS is_active_70, u12_.is_activated AS is_activated_71, u12_.is_phone_verify AS is_phone_verify_72, u12_.created_at AS created_at_73, u12_.thumbnail AS thumbnail_74, c0_.content_type AS content_type_75, c0_.user_id AS user_id_76, c0_.term_id AS term_id_77, p2_.route_id AS route_id_78, u12_.user_type AS user_type_79 FROM contents c0_ LEFT JOIN article a1_ ON c0_.id = a1_.id LEFT JOIN page p2_ ON c0_.id = p2_.id LEFT JOIN product p3_ ON c0_.id = p3_.id LEFT JOIN events e4_ ON c0_.id = e4_.id LEFT JOIN album a5_ ON c0_.id = a5_.id LEFT JOIN video v6_ ON c0_.id = v6_.id LEFT JOIN document d7_ ON c0_.id = d7_.id LEFT JOIN audio a8_ ON c0_.id = a8_.id LEFT JOIN project p9_ ON c0_.id = p9_.id LEFT JOIN house h10_ ON c0_.id = h10_.id LEFT JOIN land l11_ ON c0_.id = l11_.id LEFT JOIN users u12_ ON c0_.user_id = u12_.id LEFT JOIN user_admin u13_ ON u12_.id = u13_.id WHERE (c0_.content_type IN ('house')) AND c0_.status = 'published' AND c0_.id IN (197, 198, 211, 212, 219, 222, 223, 224, 231, 232, 233, 234, 235, 236, 238, 240, 241, 242, 243, 245) ORDER BY c0_.date_published DESC;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.slug AS slug_3,
  t0.description AS description_4,
  t0.weight AS weight_5,
  t0.path AS path_6,
  t0.lvl AS lvl_7,
  t0.createdAt AS createdAt_8,
  t0.updatedAt AS updatedAt_9,
  t0.is_enable AS is_enable_10,
  t0.icon AS icon_11,
  t0.thumbnail AS thumbnail_12,
  t0.vid AS vid_13,
  t14.id AS id_15,
  t14.human_label AS human_label_16,
  t14.name AS name_17,
  t14.description AS description_18,
  t14.is_orderable AS is_orderable_19,
  t14.weight AS weight_20,
  t14.createdAt AS createdAt_21,
  t14.updatedAt AS updatedAt_22,
  t0.pid AS pid_23,
  t24.id AS id_25,
  t24.name AS name_26,
  t24.slug AS slug_27,
  t24.description AS description_28,
  t24.weight AS weight_29,
  t24.path AS path_30,
  t24.lvl AS lvl_31,
  t24.createdAt AS createdAt_32,
  t24.updatedAt AS updatedAt_33,
  t24.is_enable AS is_enable_34,
  t24.icon AS icon_35,
  t24.thumbnail AS thumbnail_36,
  t24.vid AS vid_37,
  t24.pid AS pid_38,
  t24.route_id AS route_id_39,
  t0.route_id AS route_id_40
FROM
  taxonomy_term t0
  LEFT JOIN taxonomy_vocabulary t14 ON t0.vid = t14.id
  LEFT JOIN taxonomy_term t24 ON t0.pid = t24.id
WHERE
  t0.id IN (?)

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.description AS description_4, t0.weight AS weight_5, t0.path AS path_6, t0.lvl AS lvl_7, t0.createdAt AS createdAt_8, t0.updatedAt AS updatedAt_9, t0.is_enable AS is_enable_10, t0.icon AS icon_11, t0.thumbnail AS thumbnail_12, t0.vid AS vid_13, t14.id AS id_15, t14.human_label AS human_label_16, t14.name AS name_17, t14.description AS description_18, t14.is_orderable AS is_orderable_19, t14.weight AS weight_20, t14.createdAt AS createdAt_21, t14.updatedAt AS updatedAt_22, t0.pid AS pid_23, t24.id AS id_25, t24.name AS name_26, t24.slug AS slug_27, t24.description AS description_28, t24.weight AS weight_29, t24.path AS path_30, t24.lvl AS lvl_31, t24.createdAt AS createdAt_32, t24.updatedAt AS updatedAt_33, t24.is_enable AS is_enable_34, t24.icon AS icon_35, t24.thumbnail AS thumbnail_36, t24.vid AS vid_37, t24.pid AS pid_38, t24.route_id AS route_id_39, t0.route_id AS route_id_40 FROM taxonomy_term t0 LEFT JOIN taxonomy_vocabulary t14 ON t0.vid = t14.id LEFT JOIN taxonomy_term t24 ON t0.pid = t24.id WHERE t0.id IN (22);

SELECT
  COUNT(*) AS dctrn_count
FROM
  (
    SELECT
      DISTINCT id_0
    FROM
      (
        SELECT
          c0_.id AS id_0,
          c0_.unique_id AS unique_id_1,
          c0_.title AS title_2,
          c0_.slug AS slug_3,
          c0_.summary AS summary_4,
          c0_.body AS body_5,
          c0_.icon AS icon_6,
          c0_.thumbnail AS thumbnail_7,
          c0_.status AS status_8,
          c0_.is_featured AS is_featured_9,
          c0_.promoted AS promoted_10,
          c0_.publish_on_socialmedia AS publish_on_socialmedia_11,
          c0_.is_published_social_media AS is_published_social_media_12,
          c0_.is_home AS is_home_13,
          c0_.date_created AS date_created_14,
          c0_.date_published AS date_published_15,
          c0_.meta_keywords AS meta_keywords_16,
          c0_.meta_description AS meta_description_17,
          p2_.parent_id AS parent_id_18,
          p3_.price AS price_19,
          p3_.sku AS sku_20,
          p3_.brand AS brand_21,
          p3_.country AS country_22,
          p3_.vendor_code AS vendor_code_23,
          e4_.event_date AS event_date_24,
          e4_.end_date AS end_date_25,
          e4_.event_time AS event_time_26,
          e4_.event_venue AS event_venue_27,
          e4_.country AS country_28,
          e4_.is_register_require AS is_register_require_29,
          e4_.price AS price_30,
          v6_.youtube_video_id AS youtube_video_id_31,
          d7_.file_name AS file_name_32,
          d7_.extension AS extension_33,
          a8_.audio_file AS audio_file_34,
          a8_.audio_author AS audio_author_35,
          p9_.year AS year_36,
          p9_.client AS client_37,
          p9_.location AS location_38,
          p9_.project_name AS project_name_39,
          h10_.price AS price_40,
          h10_.bedrooms AS bedrooms_41,
          h10_.bathrooms AS bathrooms_42,
          h10_.is_furnished AS is_furnished_43,
          h10_.square_meters AS square_meters_44,
          h10_.house_type AS house_type_45,
          h10_.location AS location_46,
          l11_.price AS price_47,
          l11_.plot_size AS plot_size_48,
          l11_.location AS location_49,
          u12_.id AS id_50,
          u12_.username AS username_51,
          u12_.firstname AS firstname_52,
          u12_.lastname AS lastname_53,
          u12_.gender AS gender_54,
          u12_.dob AS dob_55,
          u12_.contact_number AS contact_number_56,
          u12_.email AS email_57,
          u12_.address AS address_58,
          u12_.city AS city_59,
          u12_.country AS country_60,
          u12_.postal_code AS postal_code_61,
          u12_.roles AS roles_62,
          u12_.date_registered AS date_registered_63,
          u12_.date_deactivated AS date_deactivated_64,
          u12_.password AS password_65,
          u12_.salt AS salt_66,
          u12_.is_logged_in AS is_logged_in_67,
          u12_.account_status AS account_status_68,
          u12_.date_last_active AS date_last_active_69,
          u12_.is_active AS is_active_70,
          u12_.is_activated AS is_activated_71,
          u12_.is_phone_verify AS is_phone_verify_72,
          u12_.created_at AS created_at_73,
          u12_.thumbnail AS thumbnail_74,
          c0_.content_type AS content_type_75,
          u12_.user_type AS user_type_76
        FROM
          contents c0_
          LEFT JOIN article a1_ ON c0_.id = a1_.id
          LEFT JOIN page p2_ ON c0_.id = p2_.id
          LEFT JOIN product p3_ ON c0_.id = p3_.id
          LEFT JOIN events e4_ ON c0_.id = e4_.id
          LEFT JOIN album a5_ ON c0_.id = a5_.id
          LEFT JOIN video v6_ ON c0_.id = v6_.id
          LEFT JOIN document d7_ ON c0_.id = d7_.id
          LEFT JOIN audio a8_ ON c0_.id = a8_.id
          LEFT JOIN project p9_ ON c0_.id = p9_.id
          LEFT JOIN house h10_ ON c0_.id = h10_.id
          LEFT JOIN land l11_ ON c0_.id = l11_.id
          LEFT JOIN users u12_ ON c0_.user_id = u12_.id
          LEFT JOIN user_admin u13_ ON u12_.id = u13_.id
        WHERE
          (
            c0_.content_type IN ('house')
          )
          AND c0_.status = ?
        ORDER BY
          c0_.date_published DESC
      ) dctrn_result
  ) dctrn_table

SELECT COUNT(*) AS dctrn_count FROM (SELECT DISTINCT id_0 FROM (SELECT c0_.id AS id_0, c0_.unique_id AS unique_id_1, c0_.title AS title_2, c0_.slug AS slug_3, c0_.summary AS summary_4, c0_.body AS body_5, c0_.icon AS icon_6, c0_.thumbnail AS thumbnail_7, c0_.status AS status_8, c0_.is_featured AS is_featured_9, c0_.promoted AS promoted_10, c0_.publish_on_socialmedia AS publish_on_socialmedia_11, c0_.is_published_social_media AS is_published_social_media_12, c0_.is_home AS is_home_13, c0_.date_created AS date_created_14, c0_.date_published AS date_published_15, c0_.meta_keywords AS meta_keywords_16, c0_.meta_description AS meta_description_17, p2_.parent_id AS parent_id_18, p3_.price AS price_19, p3_.sku AS sku_20, p3_.brand AS brand_21, p3_.country AS country_22, p3_.vendor_code AS vendor_code_23, e4_.event_date AS event_date_24, e4_.end_date AS end_date_25, e4_.event_time AS event_time_26, e4_.event_venue AS event_venue_27, e4_.country AS country_28, e4_.is_register_require AS is_register_require_29, e4_.price AS price_30, v6_.youtube_video_id AS youtube_video_id_31, d7_.file_name AS file_name_32, d7_.extension AS extension_33, a8_.audio_file AS audio_file_34, a8_.audio_author AS audio_author_35, p9_.year AS year_36, p9_.client AS client_37, p9_.location AS location_38, p9_.project_name AS project_name_39, h10_.price AS price_40, h10_.bedrooms AS bedrooms_41, h10_.bathrooms AS bathrooms_42, h10_.is_furnished AS is_furnished_43, h10_.square_meters AS square_meters_44, h10_.house_type AS house_type_45, h10_.location AS location_46, l11_.price AS price_47, l11_.plot_size AS plot_size_48, l11_.location AS location_49, u12_.id AS id_50, u12_.username AS username_51, u12_.firstname AS firstname_52, u12_.lastname AS lastname_53, u12_.gender AS gender_54, u12_.dob AS dob_55, u12_.contact_number AS contact_number_56, u12_.email AS email_57, u12_.address AS address_58, u12_.city AS city_59, u12_.country AS country_60, u12_.postal_code AS postal_code_61, u12_.roles AS roles_62, u12_.date_registered AS date_registered_63, u12_.date_deactivated AS date_deactivated_64, u12_.password AS password_65, u12_.salt AS salt_66, u12_.is_logged_in AS is_logged_in_67, u12_.account_status AS account_status_68, u12_.date_last_active AS date_last_active_69, u12_.is_active AS is_active_70, u12_.is_activated AS is_activated_71, u12_.is_phone_verify AS is_phone_verify_72, u12_.created_at AS created_at_73, u12_.thumbnail AS thumbnail_74, c0_.content_type AS content_type_75, u12_.user_type AS user_type_76 FROM contents c0_ LEFT JOIN article a1_ ON c0_.id = a1_.id LEFT JOIN page p2_ ON c0_.id = p2_.id LEFT JOIN product p3_ ON c0_.id = p3_.id LEFT JOIN events e4_ ON c0_.id = e4_.id LEFT JOIN album a5_ ON c0_.id = a5_.id LEFT JOIN video v6_ ON c0_.id = v6_.id LEFT JOIN document d7_ ON c0_.id = d7_.id LEFT JOIN audio a8_ ON c0_.id = a8_.id LEFT JOIN project p9_ ON c0_.id = p9_.id LEFT JOIN house h10_ ON c0_.id = h10_.id LEFT JOIN land l11_ ON c0_.id = l11_.id LEFT JOIN users u12_ ON c0_.user_id = u12_.id LEFT JOIN user_admin u13_ ON u12_.id = u13_.id WHERE (c0_.content_type IN ('house')) AND c0_.status = 'published' ORDER BY c0_.date_published DESC) dctrn_result) dctrn_table;