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
  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_.slug = ?
  AND c0_.status = ?

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_.slug = '5-bedroom-ensuite-house-with-boys-quarters-for-sale' AND c0_.status = 'published';

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
  t0.id AS id_1,
  t0.caption AS caption_2,
  t0.file_name AS file_name_3,
  t0.dateCreated AS dateCreated_4,
  t0.content_id AS content_id_5
FROM
  photos t0
WHERE
  t0.content_id = ?

SELECT t0.id AS id_1, t0.caption AS caption_2, t0.file_name AS file_name_3, t0.dateCreated AS dateCreated_4, t0.content_id AS content_id_5 FROM photos t0 WHERE t0.content_id = 212;

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,
  h1_.price AS price_18,
  h1_.bedrooms AS bedrooms_19,
  h1_.bathrooms AS bathrooms_20,
  h1_.is_furnished AS is_furnished_21,
  h1_.square_meters AS square_meters_22,
  h1_.house_type AS house_type_23,
  h1_.location AS location_24,
  u2_.id AS id_25,
  u2_.username AS username_26,
  u2_.firstname AS firstname_27,
  u2_.lastname AS lastname_28,
  u2_.gender AS gender_29,
  u2_.dob AS dob_30,
  u2_.contact_number AS contact_number_31,
  u2_.email AS email_32,
  u2_.address AS address_33,
  u2_.city AS city_34,
  u2_.country AS country_35,
  u2_.postal_code AS postal_code_36,
  u2_.roles AS roles_37,
  u2_.date_registered AS date_registered_38,
  u2_.date_deactivated AS date_deactivated_39,
  u2_.password AS password_40,
  u2_.salt AS salt_41,
  u2_.is_logged_in AS is_logged_in_42,
  u2_.account_status AS account_status_43,
  u2_.date_last_active AS date_last_active_44,
  u2_.is_active AS is_active_45,
  u2_.is_activated AS is_activated_46,
  u2_.is_phone_verify AS is_phone_verify_47,
  u2_.created_at AS created_at_48,
  u2_.thumbnail AS thumbnail_49,
  c0_.content_type AS content_type_50,
  c0_.user_id AS user_id_51,
  c0_.term_id AS term_id_52,
  u2_.user_type AS user_type_53
FROM
  house h1_
  INNER JOIN contents c0_ ON h1_.id = c0_.id
  LEFT JOIN users u2_ ON c0_.user_id = u2_.id
  LEFT JOIN user_admin u3_ ON u2_.id = u3_.id
WHERE
  c0_.status = ?
  AND c0_.id NOT IN (?)
ORDER BY
  c0_.date_published DESC
LIMIT
  3

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, h1_.price AS price_18, h1_.bedrooms AS bedrooms_19, h1_.bathrooms AS bathrooms_20, h1_.is_furnished AS is_furnished_21, h1_.square_meters AS square_meters_22, h1_.house_type AS house_type_23, h1_.location AS location_24, u2_.id AS id_25, u2_.username AS username_26, u2_.firstname AS firstname_27, u2_.lastname AS lastname_28, u2_.gender AS gender_29, u2_.dob AS dob_30, u2_.contact_number AS contact_number_31, u2_.email AS email_32, u2_.address AS address_33, u2_.city AS city_34, u2_.country AS country_35, u2_.postal_code AS postal_code_36, u2_.roles AS roles_37, u2_.date_registered AS date_registered_38, u2_.date_deactivated AS date_deactivated_39, u2_.password AS password_40, u2_.salt AS salt_41, u2_.is_logged_in AS is_logged_in_42, u2_.account_status AS account_status_43, u2_.date_last_active AS date_last_active_44, u2_.is_active AS is_active_45, u2_.is_activated AS is_activated_46, u2_.is_phone_verify AS is_phone_verify_47, u2_.created_at AS created_at_48, u2_.thumbnail AS thumbnail_49, c0_.content_type AS content_type_50, c0_.user_id AS user_id_51, c0_.term_id AS term_id_52, u2_.user_type AS user_type_53 FROM house h1_ INNER JOIN contents c0_ ON h1_.id = c0_.id LEFT JOIN users u2_ ON c0_.user_id = u2_.id LEFT JOIN user_admin u3_ ON u2_.id = u3_.id WHERE c0_.status = 'published' AND c0_.id NOT IN ('212') ORDER BY c0_.date_published DESC LIMIT 3;