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 ('land')
          )
          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 ('land')) 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 ('land')
  )
  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 ('land')) AND c0_.status = 'published' AND c0_.id IN (216, 217, 220, 221, 226, 227, 228, 229, 230, 237, 239, 215, 218, 225, 244, 249, 250, 252, 210, 208) ORDER BY c0_.date_published DESC;