https://xs501433.xsrv.jp/shop/kakiyama_manage/login

Query Metrics

8 Database Queries
7 Different statements
0.48 ms Query time
4 Invalid entities

Queries

Group similar statements

# Time Info
1 0.15 ms
SET SESSION time_zone = '+00:00'
Parameters:
[]
2 0.08 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.email05 AS email05_13, t0.email06 AS email06_14, t0.email07 AS email07_15, t0.email08 AS email08_16, t0.shop_name AS shop_name_17, t0.shop_kana AS shop_kana_18, t0.shop_name_eng AS shop_name_eng_19, t0.update_date AS update_date_20, t0.good_traded AS good_traded_21, t0.message AS message_22, t0.delivery_free_amount AS delivery_free_amount_23, t0.delivery_free_quantity AS delivery_free_quantity_24, t0.option_mypage_order_status_display AS option_mypage_order_status_display_25, t0.option_nostock_hidden AS option_nostock_hidden_26, t0.option_favorite_product AS option_favorite_product_27, t0.option_product_delivery_fee AS option_product_delivery_fee_28, t0.invoice_registration_number AS invoice_registration_number_29, t0.option_product_tax_rule AS option_product_tax_rule_30, t0.option_customer_activate AS option_customer_activate_31, t0.option_remember_me AS option_remember_me_32, t0.option_mail_notifier AS option_mail_notifier_33, t0.authentication_key AS authentication_key_34, t0.php_path AS php_path_35, t0.option_point AS option_point_36, t0.basic_point_rate AS basic_point_rate_37, t0.point_conversion_rate AS point_conversion_rate_38, t0.country_id AS country_id_39, t0.pref_id AS pref_id_40, t0.discriminator_type FROM dtb_base_info t0 WHERE t0.id = ? AND t0.discriminator_type IN ('baseinfo')
Parameters:
[
  1
]
3 0.05 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.03 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.03 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
]
6 0.04 ms
SELECT t0.id AS id_1, t0.point AS point_2, t0.first_order_point AS first_order_point_3, t0.start_time AS start_time_4 FROM plg_entry_point t0
Parameters:
[]
7 0.06 ms
SET SESSION TRANSACTION ISOLATION LEVEL READ COMMITTED
Parameters:
[]
8 0.04 ms
"START TRANSACTION"
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
Plugin\ProductDisplayRank42\Entity\Config No errors.
Eccube\Entity\AbstractEntity 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\AbstractMasterEntity 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.
Plugin\PointExDx\Entity\EntryPoint 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\Order
  • The field Eccube\Entity\Order#orderPointExDx is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity Plugin\PointExDx\Entity\OrderPointExDx#Order does not contain the required 'inversedBy="orderPointExDx"' attribute.
Eccube\Entity\Master\OrderStatus No errors.
Eccube\Entity\Customer
  • The field Eccube\Entity\Customer#Contacts is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity Plugin\ContactManagement42\Entity\Contact#Customer does not contain the required 'inversedBy="Contacts"' attribute.
Plugin\MultiCutDx\Entity\PlgConfig
  • The mappings Plugin\MultiCutDx\Entity\PlgConfig#ConfigOptions and Plugin\MultiCutDx\Entity\PlgConfigOption#PlgConfig are inconsistent with each other.
Plugin\MultiCutDx\Entity\PlgConfigOption
  • The association Plugin\MultiCutDx\Entity\PlgConfigOption#PlgConfig refers to the inverse side field Plugin\MultiCutDx\Entity\PlgConfig#PlgConfigOptions which does not exist.