GET http://staging.usui-home.co.jp/reform/construction/4126

Query Metrics

6 Database Queries
6 Different statements
4.41 ms Query time
3 Invalid entities

Queries

Group similar statements

# Time Info
1 2.23 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"
  "4126"
]
2 0.59 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:
[
  4126
]
3 0.31 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:
[
  4126
]
4 0.34 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:
[
  29
]
5 0.35 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:
[
  29
]
6 0.61 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"
  "3976"
]

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
  • The field 'App\Entity\WordPressPostEntity#id' has the property type 'int' that differs from the metadata field type 'string' returned by the 'bigint' DBAL type.
  • The field 'App\Entity\WordPressPostEntity#postAuthor' has the property type 'int' that differs from the metadata field type 'string' returned by the 'bigint' DBAL type.
  • The field 'App\Entity\WordPressPostEntity#postParent' has the property type 'int' that differs from the metadata field type 'string' returned by the 'bigint' DBAL type.
  • The field 'App\Entity\WordPressPostEntity#commentCount' has the property type 'int' that differs from the metadata field type 'string' returned by the 'bigint' DBAL type.
App\Entity\StaffAttributeEntity No errors.
App\Entity\WordPressPostMetaEntity No errors.
App\Entity\WordPressTermRelationshipEntity No errors.
App\Entity\ManagementSeminarApplicationEntity No errors.
App\Entity\WordPressTermTaxonomyEntity
  • The field 'App\Entity\WordPressTermTaxonomyEntity#id' has the property type 'int' that differs from the metadata field type 'string' returned by the 'bigint' DBAL type.
App\Entity\WordPressTermEntity
  • The field 'App\Entity\WordPressTermEntity#id' has the property type 'int' that differs from the metadata field type 'string' returned by the 'bigint' DBAL type.