Query Metrics
10
Database Queries
9
Different statements
1.61 ms
Query time
0
Invalid entities
Queries
| #▲ | Time | Info |
|---|---|---|
| 1 | 0.22 ms |
SET SESSION time_zone = '+00:00'
Parameters:
[] |
| 2 | 0.24 ms |
SELECT t0.id AS id_1, t0.company_name AS company_name_2, t0.company_kana AS company_kana_3, t0.postal_code AS postal_code_4, t0.addr01 AS addr01_5, t0.addr02 AS addr02_6, t0.phone_number AS phone_number_7, t0.business_hour AS business_hour_8, t0.email01 AS email01_9, t0.email02 AS email02_10, t0.email03 AS email03_11, t0.email04 AS email04_12, t0.shop_name AS shop_name_13, t0.shop_kana AS shop_kana_14, t0.shop_name_eng AS shop_name_eng_15, t0.update_date AS update_date_16, t0.good_traded AS good_traded_17, t0.message AS message_18, t0.delivery_free_amount AS delivery_free_amount_19, t0.delivery_free_quantity AS delivery_free_quantity_20, t0.option_mypage_order_status_display AS option_mypage_order_status_display_21, t0.option_nostock_hidden AS option_nostock_hidden_22, t0.option_favorite_product AS option_favorite_product_23, t0.option_product_delivery_fee AS option_product_delivery_fee_24, t0.invoice_registration_number AS invoice_registration_number_25, t0.option_product_tax_rule AS option_product_tax_rule_26, t0.option_customer_activate AS option_customer_activate_27, t0.option_remember_me AS option_remember_me_28, t0.option_mail_notifier AS option_mail_notifier_29, t0.authentication_key AS authentication_key_30, t0.php_path AS php_path_31, t0.option_point AS option_point_32, t0.basic_point_rate AS basic_point_rate_33, t0.point_conversion_rate AS point_conversion_rate_34, t0.country_id AS country_id_35, t0.pref_id AS pref_id_36, t0.discriminator_type FROM dtb_base_info t0 WHERE t0.id = ? AND t0.discriminator_type IN ('baseinfo')
Parameters:
[
1
]
|
| 3 | 0.14 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.department AS department_3, t0.login_id AS login_id_4, t0.password AS password_5, t0.salt AS salt_6, t0.sort_no AS sort_no_7, t0.two_factor_auth_key AS two_factor_auth_key_8, t0.two_factor_auth_enabled AS two_factor_auth_enabled_9, t0.create_date AS create_date_10, t0.update_date AS update_date_11, t0.login_date AS login_date_12, t0.work_id AS work_id_13, t0.authority_id AS authority_id_14, t0.creator_id AS creator_id_15, t0.discriminator_type FROM dtb_member t0 WHERE t0.login_id = ? AND t0.work_id = ? AND t0.discriminator_type IN ('member') LIMIT 1
Parameters:
[ "kinkodo" 1 ] |
| 4 | 0.11 ms |
SELECT t0.id AS id_1, t0.deny_url AS deny_url_2, t0.create_date AS create_date_3, t0.update_date AS update_date_4, t0.authority_id AS authority_id_5, t0.creator_id AS creator_id_6, t0.discriminator_type FROM dtb_authority_role t0 WHERE t0.authority_id = ? AND t0.discriminator_type IN ('authorityrole')
Parameters:
[
0
]
|
| 5 | 0.06 ms |
SELECT t0.id AS id_1, t0.deny_url AS deny_url_2, t0.create_date AS create_date_3, t0.update_date AS update_date_4, t0.authority_id AS authority_id_5, t0.creator_id AS creator_id_6, t0.discriminator_type FROM dtb_authority_role t0 WHERE t0.authority_id = ? AND t0.discriminator_type IN ('authorityrole')
Parameters:
[
0
]
|
| 6 | 0.12 ms |
SET SESSION TRANSACTION ISOLATION LEVEL READ COMMITTED
Parameters:
[] |
| 7 | 0.04 ms |
"START TRANSACTION"
Parameters:
[] |
| 8 | 0.12 ms |
SELECT t0.id AS id_1, t0.publish_date AS publish_date_2, t0.title AS title_3, t0.eyecatch_image AS eyecatch_image_4, t0.blog_description AS blog_description_5, t0.url AS url_6, t0.link_method AS link_method_7, t0.create_date AS create_date_8, t0.update_date AS update_date_9, t0.visible AS visible_10, t0.author AS author_11, t0.description AS description_12, t0.keyword AS keyword_13, t0.meta_robots AS meta_robots_14, t0.meta_tags AS meta_tags_15, t0.creator_id AS creator_id_16, t0.discriminator_type FROM plg_blogs t0 WHERE t0.id = ? AND t0.discriminator_type IN ('blogs')
Parameters:
[
"260"
]
|
| 9 | 0.12 ms |
SELECT p0_.id AS id_0, p0_.category_name AS category_name_1, p0_.hierarchy AS hierarchy_2, p0_.sort_no AS sort_no_3, p0_.create_date AS create_date_4, p0_.update_date AS update_date_5, p1_.id AS id_6, p1_.category_name AS category_name_7, p1_.hierarchy AS hierarchy_8, p1_.sort_no AS sort_no_9, p1_.create_date AS create_date_10, p1_.update_date AS update_date_11, p2_.id AS id_12, p2_.category_name AS category_name_13, p2_.hierarchy AS hierarchy_14, p2_.sort_no AS sort_no_15, p2_.create_date AS create_date_16, p2_.update_date AS update_date_17, p3_.id AS id_18, p3_.category_name AS category_name_19, p3_.hierarchy AS hierarchy_20, p3_.sort_no AS sort_no_21, p3_.create_date AS create_date_22, p3_.update_date AS update_date_23, p4_.id AS id_24, p4_.category_name AS category_name_25, p4_.hierarchy AS hierarchy_26, p4_.sort_no AS sort_no_27, p4_.create_date AS create_date_28, p4_.update_date AS update_date_29, p0_.discriminator_type AS discriminator_type_30, p0_.parent_category_id AS parent_category_id_31, p0_.creator_id AS creator_id_32, p1_.discriminator_type AS discriminator_type_33, p1_.parent_category_id AS parent_category_id_34, p1_.creator_id AS creator_id_35, p2_.discriminator_type AS discriminator_type_36, p2_.parent_category_id AS parent_category_id_37, p2_.creator_id AS creator_id_38, p3_.discriminator_type AS discriminator_type_39, p3_.parent_category_id AS parent_category_id_40, p3_.creator_id AS creator_id_41, p4_.discriminator_type AS discriminator_type_42, p4_.parent_category_id AS parent_category_id_43, p4_.creator_id AS creator_id_44 FROM plg_blogscategory p0_ LEFT JOIN plg_blogscategory p1_ ON p0_.id = p1_.parent_category_id AND p1_.discriminator_type IN ('category') LEFT JOIN plg_blogscategory p2_ ON p1_.id = p2_.parent_category_id AND p2_.discriminator_type IN ('category') LEFT JOIN plg_blogscategory p3_ ON p2_.id = p3_.parent_category_id AND p3_.discriminator_type IN ('category') LEFT JOIN plg_blogscategory p4_ ON p3_.id = p4_.parent_category_id AND p4_.discriminator_type IN ('category') WHERE (p0_.parent_category_id IS NULL) AND p0_.discriminator_type IN ('category') ORDER BY p0_.sort_no DESC, p1_.sort_no DESC, p2_.sort_no DESC, p3_.sort_no DESC, p4_.sort_no DESC
Parameters:
[] |
| 10 | 0.43 ms |
SELECT t0.blogs_id AS blogs_id_1, t0.category_id AS category_id_2, t0.blogs_id AS blogs_id_3, t0.category_id AS category_id_4, t0.discriminator_type FROM plg_blogs_category t0 WHERE t0.blogs_id = ? AND t0.discriminator_type IN ('blogscategory')
Parameters:
[
260
]
|
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 |
|---|---|
| Eccube\Entity\AbstractEntity | No errors. |
| Eccube\Entity\BaseInfo | No errors. |
| Eccube\Entity\Master\AbstractMasterEntity | No errors. |
| Eccube\Entity\Master\Country | No errors. |
| Eccube\Entity\Master\Pref | No errors. |
| Eccube\Entity\Product | No errors. |
| Plugin\TabaBannerManager2\Entity\Area | No errors. |
| Plugin\TabaBannerManager2\Entity\Banner | No errors. |
| Eccube\Entity\Page | No errors. |
| Eccube\Entity\PageLayout | No errors. |
| Eccube\Entity\Block | No errors. |
| Eccube\Entity\BlockPosition | No errors. |
| Eccube\Entity\Master\DeviceType | No errors. |
| Eccube\Entity\AuthorityRole | No errors. |
| Eccube\Entity\Layout | No errors. |
| Eccube\Entity\Member | No errors. |
| Eccube\Entity\Master\Work | No errors. |
| Eccube\Entity\Master\Authority | No errors. |
| Plugin\Blogs42\Entity\Blogs | No errors. |
| Plugin\Blogs42\Entity\Category | No errors. |
| Plugin\Blogs42\Entity\BlogsCategory | No errors. |