Symfony Profiler

• Request / Response
• Performance
• Validator
• Forms
• Exception
• Logs 6
• Events
• Routing
• Cache
• Translation
• Security
• Twig
• HTTP Client
• Doctrine
• Debug
• Messages
• Emails
• Notifications
• Serializer
• EasyAdmin
• Configuration

Query Metrics

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

[
  "column"
  "column"
  "publish"
  "crimeprevention"
  "column_category"
]

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 = 'column') AND (p.post_type = 'column') AND (p.post_status = 'publish') AND (p.post_name = 'crimeprevention') AND (tt_0.taxonomy = 'column_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

[
  "attachment"
  "3557"
]

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 = '3557') 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.term_id, p.name, p.slug, tt.taxonomy, tt.term_taxonomy_id, tt.count FROM wp_terms p INNER JOIN wp_term_taxonomy tt ON p.term_id = tt.term_id INNER JOIN wp_term_relationships tr_0 ON tt.term_taxonomy_id = tr_0.term_taxonomy_id INNER JOIN wp_posts p_0 ON tr_0.object_id = p_0.id LEFT JOIN wp_postmeta pm_0 ON p_0.id = pm_0.post_id WHERE (p_0.id = ?) AND (taxonomy = ?) GROUP BY p.term_id, p.name, p.slug, p_0.id, tt.taxonomy

[
  "1369"
  "column_tag"
]

SELECT
  p.term_id,
  p.name,
  p.slug,
  tt.taxonomy,
  tt.term_taxonomy_id,
  tt.count
FROM
  wp_terms p
  INNER JOIN wp_term_taxonomy tt ON p.term_id = tt.term_id
  INNER JOIN wp_term_relationships tr_0 ON tt.term_taxonomy_id = tr_0.term_taxonomy_id
  INNER JOIN wp_posts p_0 ON tr_0.object_id = p_0.id
  LEFT JOIN wp_postmeta pm_0 ON p_0.id = pm_0.post_id
WHERE
  (p_0.id = ?)
  AND (taxonomy = ?)
GROUP BY
  p.term_id,
  p.name,
  p.slug,
  p_0.id,
  tt.taxonomy

SELECT p.term_id, p.name, p.slug, tt.taxonomy, tt.term_taxonomy_id, tt.count FROM wp_terms p INNER JOIN wp_term_taxonomy tt ON p.term_id = tt.term_id INNER JOIN wp_term_relationships tr_0 ON tt.term_taxonomy_id = tr_0.term_taxonomy_id INNER JOIN wp_posts p_0 ON tr_0.object_id = p_0.id LEFT JOIN wp_postmeta pm_0 ON p_0.id = pm_0.post_id WHERE (p_0.id = '1369') AND (taxonomy = 'column_tag') GROUP BY p.term_id, p.name, p.slug, p_0.id, tt.taxonomy;