Query Metrics
41
Database Queries
12
Different statements
41.78 ms
Query time
4
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
17.34 ms (41.50%) |
3 |
SELECT t0.term_order AS term_order_1, t0.object_id AS object_id_2, t0.term_taxonomy_id AS term_taxonomy_id_3 FROM wp_term_relationships t0 WHERE t0.object_id = ?
Parameters:
[
4956
]
|
||||||||||||||||||||||||||||||||
|
11.79 ms (28.23%) |
25 |
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" "5730" ]
|
||||||||||||||||||||||||||||||||
|
3.89 ms (9.31%) |
2 |
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_reform_hero_media_list%"
]
|
||||||||||||||||||||||||||||||||
|
3.14 ms (7.52%) |
3 |
SELECT t0.meta_id AS meta_id_1, t0.meta_key AS meta_key_2, t0.meta_value AS meta_value_3, t0.post_id AS post_id_4 FROM wp_postmeta t0 WHERE t0.post_id = ?
Parameters:
[
4956
]
|
||||||||||||||||||||||||||||||||
|
1.89 ms (4.52%) |
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 (46) ORDER BY w0_.post_date DESC LIMIT 3
Parameters:
[ "construction" "publish" "reform_category" ]
|
||||||||||||||||||||||||||||||||
|
0.98 ms (2.33%) |
1 |
SELECT t0.ID AS ID_1, t0.post_author AS post_author_2, t0.post_date AS post_date_3, t0.post_date_gmt AS post_date_gmt_4, t0.post_content AS post_content_5, t0.post_title AS post_title_6, t0.post_excerpt AS post_excerpt_7, t0.post_status AS post_status_8, t0.comment_status AS comment_status_9, t0.ping_status AS ping_status_10, t0.post_password AS post_password_11, t0.post_name AS post_name_12, t0.to_ping AS to_ping_13, t0.pinged AS pinged_14, t0.post_modified AS post_modified_15, t0.post_modified_gmt AS post_modified_gmt_16, t0.post_content_filtered AS post_content_filtered_17, t0.post_parent AS post_parent_18, t0.guid AS guid_19, t0.menu_order AS menu_order_20, t0.post_type AS post_type_21, t0.post_mime_type AS post_mime_type_22, t0.comment_count AS comment_count_23, t24.uid AS uid_25, t24.first_name AS first_name_26, t24.last_name AS last_name_27, t24.first_name_katakana AS first_name_katakana_28, t24.last_name_katakana AS last_name_katakana_29, t24.affiliation AS affiliation_30, t24.department AS department_31, t24.license AS license_32, t24.hobby AS hobby_33, t24.greeting AS greeting_34, t24.message AS message_35, t24.created_at AS created_at_36, t24.updated_at AS updated_at_37, t24.post_uid AS post_uid_38 FROM wp_posts t0 LEFT JOIN staff_attribute t24 ON t24.post_uid = t0.ID WHERE t0.post_type = ? AND t0.post_status = ? ORDER BY t0.post_date DESC LIMIT 3
Parameters:
[ "construction" "publish" ]
|
||||||||||||||||||||||||||||||||
|
0.75 ms (1.79%) |
1 |
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 = ?) AND (category.term_id IN (?)) 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 10
Parameters:
[ "column" "column" "publish" "column_category" 63 ]
|
||||||||||||||||||||||||||||||||
|
0.52 ms (1.26%) |
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
Parameters:
[ "635" "column_tag" ]
|
||||||||||||||||||||||||||||||||
|
0.43 ms (1.03%) |
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_1 ON tt.term_taxonomy_id = tr_1.term_taxonomy_id INNER JOIN wp_posts p_1 ON tr_1.object_id = p_1.id LEFT JOIN wp_postmeta pm_1 ON p_1.id = pm_1.post_id WHERE (p_1.id = ?) AND (taxonomy = ?) GROUP BY p.term_id, p.name, p.slug, p_1.id, tt.taxonomy
Parameters:
[ "1369" "column_tag" ]
|
||||||||||||||||||||||||||||||||
|
0.40 ms (0.96%) |
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_2 ON tt.term_taxonomy_id = tr_2.term_taxonomy_id INNER JOIN wp_posts p_2 ON tr_2.object_id = p_2.id LEFT JOIN wp_postmeta pm_2 ON p_2.id = pm_2.post_id WHERE (p_2.id = ?) AND (taxonomy = ?) GROUP BY p.term_id, p.name, p.slug, p_2.id, tt.taxonomy
Parameters:
[ "1456" "column_tag" ]
|
||||||||||||||||||||||||||||||||
|
0.34 ms (0.83%) |
1 |
SELECT t0.term_taxonomy_id AS term_taxonomy_id_1, t0.taxonomy AS taxonomy_2, t0.description AS description_3, t0.count AS count_4, t0.term_id AS term_id_5, t0.parent AS parent_6 FROM wp_term_taxonomy t0 WHERE t0.term_taxonomy_id = ?
Parameters:
[
46
]
|
||||||||||||||||||||||||||||||||
|
0.30 ms (0.72%) |
1 |
SELECT t0.term_id AS term_id_1, t0.name AS name_2, t0.slug AS slug_3, t0.term_group AS term_group_4 FROM wp_terms t0 WHERE t0.term_id = ?
Parameters:
[
46
]
|
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 |
|
| App\Entity\WordPressPostEntity |
|
| App\Entity\StaffAttributeEntity | No errors. |
| App\Entity\WordPressPostMetaEntity | No errors. |
| App\Entity\WordPressTermRelationshipEntity | No errors. |
| App\Entity\ManagementSeminarApplicationEntity | No errors. |
| App\Entity\WordPressTermTaxonomyEntity |
|
| App\Entity\WordPressTermEntity |
|