https://noiezam.com/noiezam_fix/nzcustomplugin/7/edit

Query Metrics

11 Database Queries
10 Different statements
2.77 ms Query time
0 Invalid entities

Grouped Statements

Show all queries

Time Count Info
0.55 ms
(19.70%)
2
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
]
0.40 ms
(14.55%)
1
SELECT t0.id AS id_1, t0.field_name AS field_name_2, t0.label AS label_3, t0.field_type AS field_type_4, t0.required AS required_5, t0.required_type AS required_type_6, t0.placeholder AS placeholder_7, t0.help_text AS help_text_8, t0.options AS options_9, t0.sort_no AS sort_no_10, t0.max_file_size AS max_file_size_11, t0.allowed_extensions AS allowed_extensions_12, t0.form_id AS form_id_13 FROM plg_nzcustomplugin_form_field t0 WHERE t0.form_id = ? ORDER BY t0.sort_no ASC
Parameters:
[
  7
]
0.33 ms
(11.80%)
1
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:
[
  "noiezam"
  1
]
0.31 ms
(11.05%)
1
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.authentication_key AS authentication_key_29, t0.php_path AS php_path_30, t0.option_point AS option_point_31, t0.basic_point_rate AS basic_point_rate_32, t0.point_conversion_rate AS point_conversion_rate_33, t0.country_id AS country_id_34, t0.pref_id AS pref_id_35, t0.discriminator_type FROM dtb_base_info t0 WHERE t0.id = ? AND t0.discriminator_type IN ('baseinfo')
Parameters:
[
  1
]
0.27 ms
(9.74%)
1
SELECT t0.id AS id_1, t0.layout_name AS layout_name_2, t0.create_date AS create_date_3, t0.update_date AS update_date_4, t0.device_type_id AS device_type_id_5, t0.discriminator_type FROM dtb_layout t0 WHERE t0.id = ? AND t0.discriminator_type IN ('layout')
Parameters:
[
  1
]
0.27 ms
(9.71%)
1
SELECT d0_.id AS id_0, d0_.layout_name AS layout_name_1, d0_.create_date AS create_date_2, d0_.update_date AS update_date_3, d0_.discriminator_type AS discriminator_type_4, d0_.device_type_id AS device_type_id_5 FROM dtb_layout d0_ WHERE d0_.discriminator_type IN ('layout')
Parameters:
[]
0.25 ms
(8.91%)
1
SELECT t0.id AS id_1, t0.name AS name_2, t0.form_key AS form_key_3, t0.description AS description_4, t0.is_active AS is_active_5, t0.create_date AS create_date_6, t0.update_date AS update_date_7, t0.send_customer_mail AS send_customer_mail_8, t0.send_admin_mail AS send_admin_mail_9, t0.admin_mail_address AS admin_mail_address_10, t0.mail_subject AS mail_subject_11, t0.mail_template AS mail_template_12, t0.complete_message AS complete_message_13, t0.publish_start_date AS publish_start_date_14, t0.publish_end_date AS publish_end_date_15, t0.require_login AS require_login_16, t0.layout_id AS layout_id_17, t0.layout_id_mobile AS layout_id_mobile_18 FROM plg_nzcustomplugin_form t0 WHERE t0.id = ?
Parameters:
[
  "7"
]
0.14 ms
(5.23%)
1
SET SESSION TRANSACTION ISOLATION LEVEL READ COMMITTED
Parameters:
[]
0.13 ms
(4.87%)
1
"START TRANSACTION"
Parameters:
[]
0.12 ms
(4.44%)
1
SET SESSION time_zone = '+00:00'
Parameters:
[]

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\Product No errors.
Plugin\NZCategoryBackground42\Entity\CategoryBackground No errors.
Eccube\Entity\BaseInfo 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\AbstractMasterEntity 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.
Eccube\Entity\Master\Country No errors.
Eccube\Entity\Master\Pref No errors.
Plugin\NZCustomPlugin\Entity\CustomForm No errors.
Plugin\NZCustomPlugin\Entity\FormField No errors.
Plugin\NZCustomPlugin\Entity\FormSubmission No errors.