Symfony Profiler

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_.status = ?
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_.status = 'published' ORDER BY c0_.date_published DESC;

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,
  p1_.parent_id AS parent_id_18,
  u2_.id AS id_19,
  u2_.username AS username_20,
  u2_.firstname AS firstname_21,
  u2_.lastname AS lastname_22,
  u2_.gender AS gender_23,
  u2_.dob AS dob_24,
  u2_.contact_number AS contact_number_25,
  u2_.email AS email_26,
  u2_.address AS address_27,
  u2_.city AS city_28,
  u2_.country AS country_29,
  u2_.postal_code AS postal_code_30,
  u2_.roles AS roles_31,
  u2_.date_registered AS date_registered_32,
  u2_.date_deactivated AS date_deactivated_33,
  u2_.password AS password_34,
  u2_.salt AS salt_35,
  u2_.is_logged_in AS is_logged_in_36,
  u2_.account_status AS account_status_37,
  u2_.date_last_active AS date_last_active_38,
  u2_.is_active AS is_active_39,
  u2_.is_activated AS is_activated_40,
  u2_.is_phone_verify AS is_phone_verify_41,
  u2_.created_at AS created_at_42,
  u2_.thumbnail AS thumbnail_43,
  r4_.id AS id_44,
  r4_.title AS title_45,
  r4_.slug AS slug_46,
  r4_.path AS path_47,
  r4_.position AS position_48,
  r4_.date_created AS date_created_49,
  r4_.visibility AS visibility_50,
  r4_.parent_id AS parent_id_51,
  r4_.route_name AS route_name_52,
  r4_.template AS template_53,
  r4_.layout_type AS layout_type_54,
  c0_.content_type AS content_type_55,
  c0_.user_id AS user_id_56,
  c0_.term_id AS term_id_57,
  p1_.route_id AS route_id_58,
  u2_.user_type AS user_type_59,
  r4_.route_type AS route_type_60
FROM
  page p1_
  INNER JOIN contents c0_ ON p1_.id = c0_.id
  LEFT JOIN users u2_ ON c0_.user_id = u2_.id
  LEFT JOIN user_admin u3_ ON u2_.id = u3_.id
  LEFT JOIN route r4_ ON p1_.route_id = r4_.id
  AND r4_.route_type IN ('page')
WHERE
  r4_.id = ?
  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, p1_.parent_id AS parent_id_18, u2_.id AS id_19, u2_.username AS username_20, u2_.firstname AS firstname_21, u2_.lastname AS lastname_22, u2_.gender AS gender_23, u2_.dob AS dob_24, u2_.contact_number AS contact_number_25, u2_.email AS email_26, u2_.address AS address_27, u2_.city AS city_28, u2_.country AS country_29, u2_.postal_code AS postal_code_30, u2_.roles AS roles_31, u2_.date_registered AS date_registered_32, u2_.date_deactivated AS date_deactivated_33, u2_.password AS password_34, u2_.salt AS salt_35, u2_.is_logged_in AS is_logged_in_36, u2_.account_status AS account_status_37, u2_.date_last_active AS date_last_active_38, u2_.is_active AS is_active_39, u2_.is_activated AS is_activated_40, u2_.is_phone_verify AS is_phone_verify_41, u2_.created_at AS created_at_42, u2_.thumbnail AS thumbnail_43, r4_.id AS id_44, r4_.title AS title_45, r4_.slug AS slug_46, r4_.path AS path_47, r4_.position AS position_48, r4_.date_created AS date_created_49, r4_.visibility AS visibility_50, r4_.parent_id AS parent_id_51, r4_.route_name AS route_name_52, r4_.template AS template_53, r4_.layout_type AS layout_type_54, c0_.content_type AS content_type_55, c0_.user_id AS user_id_56, c0_.term_id AS term_id_57, p1_.route_id AS route_id_58, u2_.user_type AS user_type_59, r4_.route_type AS route_type_60 FROM page p1_ INNER JOIN contents c0_ ON p1_.id = c0_.id LEFT JOIN users u2_ ON c0_.user_id = u2_.id LEFT JOIN user_admin u3_ ON u2_.id = u3_.id LEFT JOIN route r4_ ON p1_.route_id = r4_.id AND r4_.route_type IN ('page') WHERE r4_.id = '126' AND c0_.status = 'published';

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,
  p1_.parent_id AS parent_id_18,
  u2_.id AS id_19,
  u2_.username AS username_20,
  u2_.firstname AS firstname_21,
  u2_.lastname AS lastname_22,
  u2_.gender AS gender_23,
  u2_.dob AS dob_24,
  u2_.contact_number AS contact_number_25,
  u2_.email AS email_26,
  u2_.address AS address_27,
  u2_.city AS city_28,
  u2_.country AS country_29,
  u2_.postal_code AS postal_code_30,
  u2_.roles AS roles_31,
  u2_.date_registered AS date_registered_32,
  u2_.date_deactivated AS date_deactivated_33,
  u2_.password AS password_34,
  u2_.salt AS salt_35,
  u2_.is_logged_in AS is_logged_in_36,
  u2_.account_status AS account_status_37,
  u2_.date_last_active AS date_last_active_38,
  u2_.is_active AS is_active_39,
  u2_.is_activated AS is_activated_40,
  u2_.is_phone_verify AS is_phone_verify_41,
  u2_.created_at AS created_at_42,
  u2_.thumbnail AS thumbnail_43,
  c0_.content_type AS content_type_44,
  c0_.user_id AS user_id_45,
  c0_.term_id AS term_id_46,
  p1_.route_id AS route_id_47,
  u2_.user_type AS user_type_48
FROM
  page p1_
  INNER JOIN contents c0_ ON p1_.id = c0_.id
  LEFT JOIN users u2_ ON c0_.user_id = u2_.id
  LEFT JOIN user_admin u3_ ON u2_.id = u3_.id
WHERE
  p1_.parent_id = ?
  AND c0_.status = ?
  AND c0_.id NOT IN (?)
ORDER BY
  c0_.date_published DESC
LIMIT
  4

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, p1_.parent_id AS parent_id_18, u2_.id AS id_19, u2_.username AS username_20, u2_.firstname AS firstname_21, u2_.lastname AS lastname_22, u2_.gender AS gender_23, u2_.dob AS dob_24, u2_.contact_number AS contact_number_25, u2_.email AS email_26, u2_.address AS address_27, u2_.city AS city_28, u2_.country AS country_29, u2_.postal_code AS postal_code_30, u2_.roles AS roles_31, u2_.date_registered AS date_registered_32, u2_.date_deactivated AS date_deactivated_33, u2_.password AS password_34, u2_.salt AS salt_35, u2_.is_logged_in AS is_logged_in_36, u2_.account_status AS account_status_37, u2_.date_last_active AS date_last_active_38, u2_.is_active AS is_active_39, u2_.is_activated AS is_activated_40, u2_.is_phone_verify AS is_phone_verify_41, u2_.created_at AS created_at_42, u2_.thumbnail AS thumbnail_43, c0_.content_type AS content_type_44, c0_.user_id AS user_id_45, c0_.term_id AS term_id_46, p1_.route_id AS route_id_47, u2_.user_type AS user_type_48 FROM page p1_ INNER JOIN contents c0_ ON p1_.id = c0_.id LEFT JOIN users u2_ ON c0_.user_id = u2_.id LEFT JOIN user_admin u3_ ON u2_.id = u3_.id WHERE p1_.parent_id = 172 AND c0_.status = 'published' AND c0_.id NOT IN (172) ORDER BY c0_.date_published DESC LIMIT 4;

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 (3, 19, 21, 20, 18, 16, 4, 11, 17, 15, 8);

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,
  t1_.id AS id_12,
  t1_.human_label AS human_label_13,
  t1_.name AS name_14,
  t1_.description AS description_15,
  t1_.is_orderable AS is_orderable_16,
  t1_.weight AS weight_17,
  t1_.createdAt AS createdAt_18,
  t1_.updatedAt AS updatedAt_19,
  t0_.vid AS vid_20,
  t0_.pid AS pid_21,
  t0_.route_id AS route_id_22
FROM
  taxonomy_term t0_
  INNER JOIN taxonomy_vocabulary t1_ ON t0_.vid = t1_.id
WHERE
  t1_.name = ?

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, t1_.id AS id_12, t1_.human_label AS human_label_13, t1_.name AS name_14, t1_.description AS description_15, t1_.is_orderable AS is_orderable_16, t1_.weight AS weight_17, t1_.createdAt AS createdAt_18, t1_.updatedAt AS updatedAt_19, t0_.vid AS vid_20, t0_.pid AS pid_21, t0_.route_id AS route_id_22 FROM taxonomy_term t0_ INNER JOIN taxonomy_vocabulary t1_ ON t0_.vid = t1_.id WHERE t1_.name = 'properties';

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.slug AS slug_3,
  t0.path AS path_4,
  t0.position AS position_5,
  t0.date_created AS date_created_6,
  t0.visibility AS visibility_7,
  t0.parent_id AS parent_id_8,
  t0.route_name AS route_name_9,
  t0.template AS template_10,
  t0.layout_type AS layout_type_11,
  t0.route_type,
  t0.controller AS controller_12,
  t0.content_type AS content_type_13,
  t0.controller AS controller_14,
  t0.content_type AS content_type_15,
  t0.url AS url_16,
  t0.permanent AS permanent_17
FROM
  route t0
WHERE
  t0.id IN (?, ?, ?)
  AND t0.route_type IN (
    'list', 'post', 'page', 'taxon', 'url'
  )

SELECT t0.id AS id_1, t0.title AS title_2, t0.slug AS slug_3, t0.path AS path_4, t0.position AS position_5, t0.date_created AS date_created_6, t0.visibility AS visibility_7, t0.parent_id AS parent_id_8, t0.route_name AS route_name_9, t0.template AS template_10, t0.layout_type AS layout_type_11, t0.route_type, t0.controller AS controller_12, t0.content_type AS content_type_13, t0.controller AS controller_14, t0.content_type AS content_type_15, t0.url AS url_16, t0.permanent AS permanent_17 FROM route t0 WHERE t0.id IN (175, 176, 177) AND t0.route_type IN ('list', 'post', 'page', 'taxon', 'url');

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.settings AS settings_3,
  t0.enabled AS enabled_4,
  t0.position AS position_5,
  t0.parent AS parent_6,
  t0.created_at AS created_at_7,
  t0.updated_at AS updated_at_8,
  t0.type AS type_9,
  t0.ttl AS ttl_10
FROM
  blocks t0

SELECT t0.id AS id_1, t0.name AS name_2, t0.settings AS settings_3, t0.enabled AS enabled_4, t0.position AS position_5, t0.parent AS parent_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.type AS type_9, t0.ttl AS ttl_10 FROM blocks t0;

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.slug AS slug_3,
  t0.path AS path_4,
  t0.position AS position_5,
  t0.date_created AS date_created_6,
  t0.visibility AS visibility_7,
  t0.parent_id AS parent_id_8,
  t0.route_name AS route_name_9,
  t0.template AS template_10,
  t0.layout_type AS layout_type_11,
  t0.route_type,
  t0.controller AS controller_12,
  t0.content_type AS content_type_13,
  t0.controller AS controller_14,
  t0.content_type AS content_type_15,
  t0.url AS url_16,
  t0.permanent AS permanent_17
FROM
  route t0
WHERE
  t0.id IN (?, ?)
  AND t0.route_type IN (
    'list', 'post', 'page', 'taxon', 'url'
  )

SELECT t0.id AS id_1, t0.title AS title_2, t0.slug AS slug_3, t0.path AS path_4, t0.position AS position_5, t0.date_created AS date_created_6, t0.visibility AS visibility_7, t0.parent_id AS parent_id_8, t0.route_name AS route_name_9, t0.template AS template_10, t0.layout_type AS layout_type_11, t0.route_type, t0.controller AS controller_12, t0.content_type AS content_type_13, t0.controller AS controller_14, t0.content_type AS content_type_15, t0.url AS url_16, t0.permanent AS permanent_17 FROM route t0 WHERE t0.id IN (201, 134) AND t0.route_type IN ('list', 'post', 'page', 'taxon', 'url');