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
  t0_.id AS id_0,
  t0_.name AS name_1,
  t0_.slug AS slug_2,
  t0_.description AS description_3,
  t0_.weight AS weight_4,
  t0_.path AS path_5,
  t0_.lvl AS lvl_6,
  t0_.createdAt AS createdAt_7,
  t0_.updatedAt AS updatedAt_8,
  t0_.is_enable AS is_enable_9,
  t0_.icon AS icon_10,
  t0_.thumbnail AS thumbnail_11,
  t0_.vid AS vid_12,
  t0_.pid AS pid_13,
  t0_.route_id AS route_id_14
FROM
  taxonomy_term t0_
  LEFT JOIN route r1_ ON t0_.route_id = r1_.id
  AND r1_.route_type IN ('taxon')
WHERE
  r1_.id = ?

SELECT t0_.id AS id_0, t0_.name AS name_1, t0_.slug AS slug_2, t0_.description AS description_3, t0_.weight AS weight_4, t0_.path AS path_5, t0_.lvl AS lvl_6, t0_.createdAt AS createdAt_7, t0_.updatedAt AS updatedAt_8, t0_.is_enable AS is_enable_9, t0_.icon AS icon_10, t0_.thumbnail AS thumbnail_11, t0_.vid AS vid_12, t0_.pid AS pid_13, t0_.route_id AS route_id_14 FROM taxonomy_term t0_ LEFT JOIN route r1_ ON t0_.route_id = r1_.id AND r1_.route_type IN ('taxon') WHERE r1_.id = '207';

SELECT
  t0.id AS id_1,
  t0.human_label AS human_label_2,
  t0.name AS name_3,
  t0.description AS description_4,
  t0.is_orderable AS is_orderable_5,
  t0.weight AS weight_6,
  t0.createdAt AS createdAt_7,
  t0.updatedAt AS updatedAt_8
FROM
  taxonomy_vocabulary t0
WHERE
  t0.id IN (?)

SELECT t0.id AS id_1, t0.human_label AS human_label_2, t0.name AS name_3, t0.description AS description_4, t0.is_orderable AS is_orderable_5, t0.weight AS weight_6, t0.createdAt AS createdAt_7, t0.updatedAt AS updatedAt_8 FROM taxonomy_vocabulary t0 WHERE t0.id IN (5);

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,
          t14_.id AS id_75,
          t14_.name AS name_76,
          t14_.slug AS slug_77,
          t14_.description AS description_78,
          t14_.weight AS weight_79,
          t14_.path AS path_80,
          t14_.lvl AS lvl_81,
          t14_.createdAt AS createdAt_82,
          t14_.updatedAt AS updatedAt_83,
          t14_.is_enable AS is_enable_84,
          t14_.icon AS icon_85,
          t14_.thumbnail AS thumbnail_86,
          c0_.content_type AS content_type_87,
          u12_.user_type AS user_type_88
        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
          LEFT JOIN taxonomy_term t14_ ON c0_.term_id = t14_.id
        WHERE
          t14_.id = ?
          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, t14_.id AS id_75, t14_.name AS name_76, t14_.slug AS slug_77, t14_.description AS description_78, t14_.weight AS weight_79, t14_.path AS path_80, t14_.lvl AS lvl_81, t14_.createdAt AS createdAt_82, t14_.updatedAt AS updatedAt_83, t14_.is_enable AS is_enable_84, t14_.icon AS icon_85, t14_.thumbnail AS thumbnail_86, c0_.content_type AS content_type_87, u12_.user_type AS user_type_88 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 LEFT JOIN taxonomy_term t14_ ON c0_.term_id = t14_.id WHERE t14_.id = 24 AND c0_.status = 'published') dctrn_result_inner ORDER BY date_published_15 DESC) dctrn_result LIMIT 20;