GET http://staging.usui-home.co.jp/reform/menu/corridor

Query Metrics

21 Database Queries
8 Different statements
34.04 ms Query time
3 Invalid entities

Queries

Group similar statements

# Time Info
1 3.41 ms
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"
  "corridor"
  "reform_category"
]
2 11.17 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"
  "1941"
]
3 1.18 ms
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 (39) ORDER BY w0_.post_date DESC LIMIT 100
Parameters:
[
  "construction"
  "publish"
  "reform_category"
]
4 11.15 ms
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:
[
  3883
]
5 0.37 ms
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:
[
  1705
]
6 0.31 ms
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:
[
  1507
]
7 0.31 ms
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:
[
  1178
]
8 0.53 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:
[
  3883
]
9 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:
[
  3883
]
10 0.43 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:
[
  39
]
11 0.37 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:
[
  39
]
12 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"
  "3779"
]
13 0.47 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:
[
  1705
]
14 0.38 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:
[
  1705
]
15 0.52 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"
  "3458"
]
16 0.50 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:
[
  1507
]
17 0.34 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:
[
  1507
]
18 0.50 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"
  "3397"
]
19 0.49 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:
[
  1178
]
20 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:
[
  1178
]
21 0.46 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"
  "3352"
]

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\WordPressTermRelationshipEntity 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.
App\Entity\WordPressPostMetaEntity No errors.
App\Entity\StaffAttributeEntity No errors.
App\Entity\ManagementSeminarApplicationEntity No errors.