Query Metrics
6
Database Queries
6
Different statements
4.44 ms
Query time
3
Invalid entities
Queries
| #▲ | Time | Info | ||||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | 2.33 ms |
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 = ? AND t0.post_name = ? LIMIT 1
Parameters:
[ "construction" "publish" "5112" ]
|
||||||||||||||||||||||||||||||||
| 2 | 0.57 ms |
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:
[
5112
]
|
||||||||||||||||||||||||||||||||
| 3 | 0.32 ms |
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:
[
5112
]
|
||||||||||||||||||||||||||||||||
| 4 | 0.31 ms |
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:
[
27
]
|
||||||||||||||||||||||||||||||||
| 5 | 0.30 ms |
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:
[
27
]
|
||||||||||||||||||||||||||||||||
| 6 | 0.60 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" "5113" ]
|
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\StaffAttributeEntity | No errors. |
| App\Entity\WordPressPostMetaEntity | No errors. |
| App\Entity\WordPressTermRelationshipEntity | No errors. |
| App\Entity\ManagementSeminarApplicationEntity | No errors. |
| App\Entity\WordPressTermTaxonomyEntity |
|
| App\Entity\WordPressTermEntity |
|
| App\Entity\CommonPrefectureEntity | No errors. |
| App\Entity\ManagementInquiryEntity | No errors. |