Query Metrics
65
Database Queries
8
Different statements
32.88 ms
Query time
3
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
8.37 ms (25.44%) |
16 |
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" "1884" ]
|
||||||||||||||||||||||||||||||||
|
7.63 ms (23.20%) |
15 |
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:
[
5108
]
|
||||||||||||||||||||||||||||||||
|
5.02 ms (15.26%) |
15 |
SELECT t0.uid AS uid_1, t0.first_name AS first_name_2, t0.last_name AS last_name_3, t0.first_name_katakana AS first_name_katakana_4, t0.last_name_katakana AS last_name_katakana_5, t0.affiliation AS affiliation_6, t0.department AS department_7, t0.license AS license_8, t0.hobby AS hobby_9, t0.greeting AS greeting_10, t0.message AS message_11, t0.created_at AS created_at_12, t0.updated_at AS updated_at_13, t0.post_uid AS post_uid_14 FROM staff_attribute t0 WHERE t0.post_uid = ?
Parameters:
[
5108
]
|
||||||||||||||||||||||||||||||||
|
4.78 ms (14.54%) |
15 |
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:
[
5108
]
|
||||||||||||||||||||||||||||||||
|
3.77 ms (11.46%) |
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 = ?) 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
Parameters:
[ "menu" "menu" "publish" "washbasin" "reform_category" ]
|
||||||||||||||||||||||||||||||||
|
2.62 ms (7.98%) |
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 (31) ORDER BY w0_.post_date DESC LIMIT 100
Parameters:
[ "construction" "publish" "reform_category" ]
|
||||||||||||||||||||||||||||||||
|
0.35 ms (1.07%) |
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:
[
31
]
|
||||||||||||||||||||||||||||||||
|
0.34 ms (1.05%) |
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:
[
31
]
|
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\WordPressPostEntity |
|
| App\Entity\WordPressTermRelationshipEntity | No errors. |
| App\Entity\WordPressTermTaxonomyEntity |
|
| App\Entity\WordPressTermEntity |
|
| App\Entity\WordPressPostMetaEntity | No errors. |
| App\Entity\StaffAttributeEntity | No errors. |
| App\Entity\ManagementSeminarApplicationEntity | No errors. |
| App\Entity\CommonPrefectureEntity | No errors. |
| App\Entity\ManagementInquiryEntity | No errors. |