https://clean-chem.jp/mypage/favorite

Query Metrics

5 Database Queries
4 Different statements
4.71 ms Query time
1 Invalid entities

Queries

Group similar statements

# Time Info
1 1.71 ms
SET SESSION time_zone = '+00:00'
Parameters:
[]
2 0.93 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.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.two_factor_auth_use AS two_factor_auth_use_34, t0.option_activate_device AS option_activate_device_35, t0.country_id AS country_id_36, t0.pref_id AS pref_id_37, t0.discriminator_type FROM dtb_base_info t0 WHERE t0.id = ? AND t0.discriminator_type IN ('baseinfo')
Parameters:
[
  1
]
3 0.83 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.code AS code_3, t0.enabled AS enabled_4, t0.version AS version_5, t0.source AS source_6, t0.initialized AS initialized_7, t0.create_date AS create_date_8, t0.update_date AS update_date_9, t0.discriminator_type FROM dtb_plugin t0 WHERE t0.code = ? AND t0.discriminator_type IN ('plugin') LIMIT 1
Parameters:
[
  "MailMagazine42"
]
4 0.58 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.code AS code_3, t0.enabled AS enabled_4, t0.version AS version_5, t0.source AS source_6, t0.initialized AS initialized_7, t0.create_date AS create_date_8, t0.update_date AS update_date_9, t0.discriminator_type FROM dtb_plugin t0 WHERE t0.code = ? AND t0.discriminator_type IN ('plugin') LIMIT 1
Parameters:
[
  "Coupon42"
]
5 0.67 ms
SELECT t0.id AS id_1, t0.coupon_id_always AS coupon_id_always_2, t0.coupon_id_during_period AS coupon_id_during_period_3, t0.period_start AS period_start_4, t0.period_end AS period_end_5, t0.include_receiving_mail_magazine AS include_receiving_mail_magazine_6, t0.send_reward_earning_mail AS send_reward_earning_mail_7 FROM plg_joolen_coupon_for_member_registration42_config t0 WHERE t0.id = ?
Parameters:
[
  1
]

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\Master\AbstractMasterEntity No errors.
Eccube\Entity\Master\ProductListOrderBy No errors.
Plugin\SortCategoryProduct42\Entity\Config No errors.
Eccube\Entity\Product No errors.
Plugin\Coupon42\Entity\Coupon No errors.
Eccube\Entity\BaseInfo No errors.
Eccube\Entity\MailTemplate No errors.
Eccube\Entity\Master\Country No errors.
Eccube\Entity\Master\Pref No errors.
Plugin\JoolenCouponForMemberRegistration42\Entity\Config No errors.
Plugin\JoolenCouponForMemberRegistration42\Entity\CustomerCoupon No errors.
Eccube\Entity\Plugin 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\Order No errors.
Eccube\Entity\Customer
  • The mappings Eccube\Entity\Customer#TwoFactorAuthCustomerCookies and Plugin\TwoFactorAuthCustomer42\Entity\TwoFactorAuthCustomerCookie#Customer are inconsistent with each other.