Symfony Profiler

SELECT
  p.id,
  p.post_type,
  p.post_name,
  p.post_title,
  p.post_status,
  p.post_excerpt,
  p.post_date,
  p.post_modified,
  p.post_content,
  MAX(
    CASE WHEN pm_self.meta_key = '_thumbnail_id' THEN pm_self.meta_value END
  ) AS `thumbnail_id`,
  category.term_id AS category_id,
  category.name AS category_name,
  category.slug AS category_slug
FROM
  wp_posts p
  LEFT JOIN wp_postmeta pm_self ON p.id = pm_self.post_id
  INNER JOIN wp_term_relationships tr_0 ON p.id = tr_0.object_id
  INNER JOIN wp_term_taxonomy tt_0 ON tr_0.term_taxonomy_id = tt_0.term_taxonomy_id
  INNER JOIN wp_terms category ON tt_0.term_id = category.term_id
WHERE
  (p.post_type = ?)
  AND (p.post_type = ?)
  AND (p.post_status = ?)
  AND (p.post_name = ?)
  AND (tt_0.taxonomy = ?)
GROUP BY
  p.id,
  p.post_type,
  p.post_name,
  p.post_title,
  p.post_status,
  p.post_excerpt,
  p.post_date,
  p.post_modified,
  p.post_content,
  category_id,
  category_name,
  category_slug
LIMIT
  1

SELECT p.id, p.post_type, p.post_name, p.post_title, p.post_status, p.post_excerpt, p.post_date, p.post_modified, p.post_content, MAX(CASE WHEN pm_self.meta_key = '_thumbnail_id' THEN pm_self.meta_value END) AS `thumbnail_id`, category.term_id AS category_id, category.name AS category_name, category.slug AS category_slug FROM wp_posts p LEFT JOIN wp_postmeta pm_self ON p.id = pm_self.post_id INNER JOIN wp_term_relationships tr_0 ON p.id = tr_0.object_id INNER JOIN wp_term_taxonomy tt_0 ON tr_0.term_taxonomy_id = tt_0.term_taxonomy_id INNER JOIN wp_terms category ON tt_0.term_id = category.term_id WHERE (p.post_type = 'menu') AND (p.post_type = 'menu') AND (p.post_status = 'publish') AND (p.post_name = 'earthquake-resistance') AND (tt_0.taxonomy = 'reform_category') GROUP BY p.id, p.post_type, p.post_name, p.post_title, p.post_status, p.post_excerpt, p.post_date, p.post_modified, p.post_content, category_id, category_name, category_slug LIMIT 1;

SELECT
  p.id,
  p.post_author,
  p.post_date,
  p.post_date_gmt,
  p.post_content,
  p.post_title,
  p.post_excerpt,
  p.post_status,
  p.comment_status,
  p.ping_status,
  p.post_password,
  p.post_name,
  p.to_ping,
  p.pinged,
  p.post_modified,
  p.post_modified_gmt,
  p.post_content_filtered,
  p.post_parent,
  p.guid,
  p.menu_order,
  p.post_type,
  p.post_mime_type,
  p.comment_count,
  MAX(
    CASE WHEN pm_self.meta_key = '_wp_attached_file' THEN pm_self.meta_value END
  ) AS `attached_file`,
  MAX(
    CASE WHEN pm_self.meta_key = '_wp_attachment_metadata' THEN pm_self.meta_value END
  ) AS `attachment_metadata`
FROM
  wp_posts p
  LEFT JOIN wp_postmeta pm_self ON p.id = pm_self.post_id
WHERE
  (p.post_type = ?)
  AND (p.id = ?)
GROUP BY
  p.id,
  p.post_author,
  p.post_date,
  p.post_date_gmt,
  p.post_content,
  p.post_title,
  p.post_excerpt,
  p.post_status,
  p.comment_status,
  p.ping_status,
  p.post_password,
  p.post_name,
  p.to_ping,
  p.pinged,
  p.post_modified,
  p.post_modified_gmt,
  p.post_content_filtered,
  p.post_parent,
  p.guid,
  p.menu_order,
  p.post_type,
  p.post_mime_type,
  p.comment_count,
  p.id
LIMIT
  1

SELECT p.id, p.post_author, p.post_date, p.post_date_gmt, p.post_content, p.post_title, p.post_excerpt, p.post_status, p.comment_status, p.ping_status, p.post_password, p.post_name, p.to_ping, p.pinged, p.post_modified, p.post_modified_gmt, p.post_content_filtered, p.post_parent, p.guid, p.menu_order, p.post_type, p.post_mime_type, p.comment_count, MAX(CASE WHEN pm_self.meta_key = '_wp_attached_file' THEN pm_self.meta_value END) AS `attached_file`, MAX(CASE WHEN pm_self.meta_key = '_wp_attachment_metadata' THEN pm_self.meta_value END) AS `attachment_metadata` FROM wp_posts p LEFT JOIN wp_postmeta pm_self ON p.id = pm_self.post_id WHERE (p.post_type = 'attachment') AND (p.id = '1953') GROUP BY p.id, p.post_author, p.post_date, p.post_date_gmt, p.post_content, p.post_title, p.post_excerpt, p.post_status, p.comment_status, p.ping_status, p.post_password, p.post_name, p.to_ping, p.pinged, p.post_modified, p.post_modified_gmt, p.post_content_filtered, p.post_parent, p.guid, p.menu_order, p.post_type, p.post_mime_type, p.comment_count, p.id LIMIT 1;

SELECT
  w0_.ID AS ID_0,
  w0_.post_author AS post_author_1,
  w0_.post_date AS post_date_2,
  w0_.post_date_gmt AS post_date_gmt_3,
  w0_.post_content AS post_content_4,
  w0_.post_title AS post_title_5,
  w0_.post_excerpt AS post_excerpt_6,
  w0_.post_status AS post_status_7,
  w0_.comment_status AS comment_status_8,
  w0_.ping_status AS ping_status_9,
  w0_.post_password AS post_password_10,
  w0_.post_name AS post_name_11,
  w0_.to_ping AS to_ping_12,
  w0_.pinged AS pinged_13,
  w0_.post_modified AS post_modified_14,
  w0_.post_modified_gmt AS post_modified_gmt_15,
  w0_.post_content_filtered AS post_content_filtered_16,
  w0_.post_parent AS post_parent_17,
  w0_.guid AS guid_18,
  w0_.menu_order AS menu_order_19,
  w0_.post_type AS post_type_20,
  w0_.post_mime_type AS post_mime_type_21,
  w0_.comment_count AS comment_count_22
FROM
  wp_posts w0_
  LEFT JOIN wp_term_relationships w1_ ON w0_.ID = w1_.object_id
  INNER JOIN wp_term_taxonomy w2_ ON w1_.term_taxonomy_id = w2_.term_taxonomy_id
  INNER JOIN wp_terms w3_ ON w2_.term_id = w3_.term_id
WHERE
  w0_.post_type = ?
  AND w0_.post_status = ?
  AND w2_.taxonomy = ?
  AND w2_.term_taxonomy_id IN (47)
ORDER BY
  w0_.post_date DESC
LIMIT
  100

SELECT w0_.ID AS ID_0, w0_.post_author AS post_author_1, w0_.post_date AS post_date_2, w0_.post_date_gmt AS post_date_gmt_3, w0_.post_content AS post_content_4, w0_.post_title AS post_title_5, w0_.post_excerpt AS post_excerpt_6, w0_.post_status AS post_status_7, w0_.comment_status AS comment_status_8, w0_.ping_status AS ping_status_9, w0_.post_password AS post_password_10, w0_.post_name AS post_name_11, w0_.to_ping AS to_ping_12, w0_.pinged AS pinged_13, w0_.post_modified AS post_modified_14, w0_.post_modified_gmt AS post_modified_gmt_15, w0_.post_content_filtered AS post_content_filtered_16, w0_.post_parent AS post_parent_17, w0_.guid AS guid_18, w0_.menu_order AS menu_order_19, w0_.post_type AS post_type_20, w0_.post_mime_type AS post_mime_type_21, w0_.comment_count AS comment_count_22 FROM wp_posts w0_ LEFT JOIN wp_term_relationships w1_ ON w0_.ID = w1_.object_id INNER JOIN wp_term_taxonomy w2_ ON w1_.term_taxonomy_id = w2_.term_taxonomy_id INNER JOIN wp_terms w3_ ON w2_.term_id = w3_.term_id WHERE w0_.post_type = 'construction' AND w0_.post_status = 'publish' AND w2_.taxonomy = 'reform_category' AND w2_.term_taxonomy_id IN (47) ORDER BY w0_.post_date DESC LIMIT 100;