Query Metrics
11
Database Queries
3
Different statements
7.44 ms
Query time
1
Invalid entities
Queries
| #▲ | Time | Info | ||||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | 1.43 ms |
SELECT w0_.option_id AS option_id_0, w0_.option_name AS option_name_1, w0_.option_value AS option_value_2, w0_.autoload AS autoload_3 FROM wp_options w0_ WHERE w0_.option_name LIKE ? ORDER BY w0_.option_id ASC
Parameters:
[
"options_top_hero_media_list%"
]
|
||||||||||||||||||||||||||||||||
| 2 | 0.62 ms |
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
Parameters:
[ "attachment" "1134" ]
|
||||||||||||||||||||||||||||||||
| 3 | 0.72 ms |
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
Parameters:
[ "attachment" "1878" ]
|
||||||||||||||||||||||||||||||||
| 4 | 0.57 ms |
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
Parameters:
[ "attachment" "1881" ]
|
||||||||||||||||||||||||||||||||
| 5 | 0.54 ms |
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
Parameters:
[ "attachment" "1882" ]
|
||||||||||||||||||||||||||||||||
| 6 | 0.54 ms |
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
Parameters:
[ "attachment" "1888" ]
|
||||||||||||||||||||||||||||||||
| 7 | 0.58 ms |
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
Parameters:
[ "attachment" "1890" ]
|
||||||||||||||||||||||||||||||||
| 8 | 0.51 ms |
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
Parameters:
[ "attachment" "1879" ]
|
||||||||||||||||||||||||||||||||
| 9 | 0.59 ms |
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
Parameters:
[ "attachment" "1880" ]
|
||||||||||||||||||||||||||||||||
| 10 | 0.77 ms |
SELECT p.id, p.post_type, p.post_name, p.post_title, p.post_status, p.post_excerpt, p.post_date, 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 (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, category_id, category_name, category_slug ORDER BY post_date DESC LIMIT 2
Parameters:
[ "news" "news" "publish" "news_category" ]
|
||||||||||||||||||||||||||||||||
| 11 | 0.57 ms |
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
Parameters:
[ "attachment" "5739" ]
|
Database Connections
| Name | Service |
|---|---|
| default | doctrine.dbal.default_connection |
Entity Managers
| Name | Service |
|---|---|
| default | doctrine.orm.default_entity_manager |
Second Level Cache
Second Level Cache is not enabled.
Entities Mapping
| Class | Mapping errors |
|---|---|
| App\Entity\WordPressOptionEntity |
|