https://hieiyuba.xyz/mypage/login Return to referer URL

Query Metrics

32 Database Queries
26 Different statements
4.55 ms Query time
5 Invalid entities

Grouped Statements

Show all queries

Time Count Info
0.65 ms
(14.37%)
2
SELECT t0.id AS id_1, t0.cart_key AS cart_key_2, t0.pre_order_id AS pre_order_id_3, t0.total_price AS total_price_4, t0.delivery_fee_total AS delivery_fee_total_5, t0.sort_no AS sort_no_6, t0.create_date AS create_date_7, t0.update_date AS update_date_8, t0.add_point AS add_point_9, t0.use_point AS use_point_10, t0.customer_id AS customer_id_11, t0.discriminator_type FROM dtb_cart t0 WHERE t0.customer_id = ? AND t0.discriminator_type IN ('cart')
Parameters:
[
  1
]
0.64 ms
(14.01%)
3
"COMMIT"
Parameters:
[]
0.58 ms
(12.69%)
2
SELECT t0.id AS id_1, t0.price AS price_2, t0.quantity AS quantity_3, t0.point_rate AS point_rate_4, t0.option_serial AS option_serial_5, t0.product_class_id AS product_class_id_6, t0.cart_id AS cart_id_7, t0.discriminator_type FROM dtb_cart_item t0 WHERE t0.cart_id = ? AND t0.discriminator_type IN ('cartitem') ORDER BY t0.id ASC
Parameters:
[
  66
]
0.22 ms
(4.79%)
1
SELECT t0.id AS id_1, t0.cart_key AS cart_key_2, t0.pre_order_id AS pre_order_id_3, t0.total_price AS total_price_4, t0.delivery_fee_total AS delivery_fee_total_5, t0.sort_no AS sort_no_6, t0.create_date AS create_date_7, t0.update_date AS update_date_8, t0.add_point AS add_point_9, t0.use_point AS use_point_10, t0.customer_id AS customer_id_11, t0.discriminator_type FROM dtb_cart t0 WHERE t0.cart_key IN (?) AND t0.discriminator_type IN ('cart') ORDER BY t0.id ASC
Parameters:
[
  "FmETXAHt6zG3HFGUQgXtqyDKW00nN7hj_1"
]
0.21 ms
(4.70%)
3
"START TRANSACTION"
Parameters:
[]
0.19 ms
(4.16%)
1
SELECT t0.id AS id_1, t0.cart_key AS cart_key_2, t0.pre_order_id AS pre_order_id_3, t0.total_price AS total_price_4, t0.delivery_fee_total AS delivery_fee_total_5, t0.sort_no AS sort_no_6, t0.create_date AS create_date_7, t0.update_date AS update_date_8, t0.add_point AS add_point_9, t0.use_point AS use_point_10, t0.customer_id AS customer_id_11, t0.discriminator_type FROM dtb_cart t0 WHERE t0.cart_key = ? AND t0.discriminator_type IN ('cart') LIMIT 1
Parameters:
[
  "1_1"
]
0.17 ms
(3.78%)
1
DELETE FROM dtb_cart WHERE id = ?
Parameters:
[
  66
]
0.17 ms
(3.76%)
1
SET SESSION time_zone = '+00:00'
Parameters:
[]
0.17 ms
(3.74%)
1
INSERT INTO dtb_cart (cart_key, pre_order_id, total_price, delivery_fee_total, sort_no, create_date, update_date, add_point, use_point, customer_id, discriminator_type) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[
  "1_1"
  null
  1728.0
  0
  null
  "2026-03-30 08:56:35"
  "2026-03-30 08:56:35"
  "0"
  "0"
  1
  "cart"
]
0.16 ms
(3.54%)
1
DELETE FROM dtb_cart_item WHERE id = ?
Parameters:
[
  80
]
0.12 ms
(2.70%)
1
INSERT INTO dtb_cart_item (price, quantity, point_rate, option_serial, product_class_id, cart_id, discriminator_type) VALUES (?, ?, ?, ?, ?, ?, ?)
Parameters:
[
  "864.00"
  2
  null
  "[]"
  138
  68
  "cartitem"
]
0.12 ms
(2.55%)
1
SELECT t0.id AS id_1, t0.name01 AS name01_2, t0.name02 AS name02_3, t0.kana01 AS kana01_4, t0.kana02 AS kana02_5, t0.company_name AS company_name_6, t0.postal_code AS postal_code_7, t0.addr01 AS addr01_8, t0.addr02 AS addr02_9, t0.email AS email_10, t0.phone_number AS phone_number_11, t0.birth AS birth_12, t0.password AS password_13, t0.salt AS salt_14, t0.secret_key AS secret_key_15, t0.first_buy_date AS first_buy_date_16, t0.last_buy_date AS last_buy_date_17, t0.buy_times AS buy_times_18, t0.buy_total AS buy_total_19, t0.note AS note_20, t0.reset_key AS reset_key_21, t0.reset_expire AS reset_expire_22, t0.point AS point_23, t0.create_date AS create_date_24, t0.update_date AS update_date_25, t0.v2_amazon_user_id AS v2_amazon_user_id_26, t0.plg_mailmag_flg AS plg_mailmag_flg_27, t0.plg_mailmag_bounce_times AS plg_mailmag_bounce_times_28, t0.plg_mailmag_first_bounce_date AS plg_mailmag_first_bounce_date_29, t0.plg_mailmag_last_bounce_date AS plg_mailmag_last_bounce_date_30, t0.customer_status_id AS customer_status_id_31, t0.sex_id AS sex_id_32, t0.job_id AS job_id_33, t0.country_id AS country_id_34, t0.pref_id AS pref_id_35, t0.discriminator_type FROM dtb_customer t0 WHERE t0.email = ? AND t0.customer_status_id = ? AND t0.discriminator_type IN ('customer') LIMIT 1
Parameters:
[
  "shimada@round-zero.jp"
  2
]
0.12 ms
(2.53%)
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.email_bcc AS email_bcc_34, t0.site_kit_site_id AS site_kit_site_id_35, t0.site_kit_site_secret AS site_kit_site_secret_36, t0.country_id AS country_id_37, t0.pref_id AS pref_id_38, t0.discriminator_type FROM dtb_base_info t0 WHERE t0.id = ? AND t0.discriminator_type IN ('baseinfo')
Parameters:
[
  1
]
0.10 ms
(2.09%)
1
SELECT t0.id AS id_1, t0.product_code AS product_code_2, t0.stock AS stock_3, t0.stock_unlimited AS stock_unlimited_4, t0.sale_limit AS sale_limit_5, t0.price01 AS price01_6, t0.price02 AS price02_7, t0.delivery_fee AS delivery_fee_8, t0.visible AS visible_9, t0.create_date AS create_date_10, t0.update_date AS update_date_11, t0.currency_code AS currency_code_12, t0.point_rate AS point_rate_13, t0.plg_sale_limit_min AS plg_sale_limit_min_14, t0.delivery_cool_type AS delivery_cool_type_15, t0.delivery_date_days AS delivery_date_days_16, t0.gmc_condition AS gmc_condition_17, t0.gmc_gtin AS gmc_gtin_18, t0.product_id AS product_id_19, t0.sale_type_id AS sale_type_id_20, t0.class_category_id1 AS class_category_id1_21, t0.class_category_id2 AS class_category_id2_22, t0.delivery_duration_id AS delivery_duration_id_23, t0.creator_id AS creator_id_24, t0.discriminator_type FROM dtb_product_class t0 WHERE t0.id = ? AND t0.discriminator_type IN ('productclass')
Parameters:
[
  138
]
0.09 ms
(2.09%)
1
SELECT t0.id AS id_1, t0.pinpoint_id AS pinpoint_id_2, t0.product_class_id AS product_class_id_3 FROM plg_product_pinpoint t0 WHERE t0.product_class_id = ?
Parameters:
[
  138
]
0.09 ms
(1.98%)
1
SELECT t0.id AS id_1, t0.name AS name_2, t0.note AS note_3, t0.description_list AS description_list_4, t0.description_detail AS description_detail_5, t0.search_word AS search_word_6, t0.free_area AS free_area_7, t0.create_date AS create_date_8, t0.update_date AS update_date_9, t0.description_overview AS description_overview_10, t0.plg_deliveryfreeproduct AS plg_deliveryfreeproduct_11, t0.reserve_date AS reserve_date_12, t0.gmc_hide AS gmc_hide_13, t0.gmc_category AS gmc_category_14, t0.gmc_brand AS gmc_brand_15, t0.shipping_name AS shipping_name_16, t0.creator_id AS creator_id_17, t0.product_status_id AS product_status_id_18, t0.discriminator_type FROM dtb_product t0 WHERE t0.id = ? AND t0.discriminator_type IN ('product')
Parameters:
[
  28
]
0.09 ms
(1.87%)
1
SELECT t0.id AS id_1, t0.name AS name_2, t0.sort_no AS sort_no_3, t0.discriminator_type FROM mtb_login_history_status t0 WHERE t0.id = ? AND t0.discriminator_type IN ('loginhistorystatus')
Parameters:
[
  1
]
0.08 ms
(1.84%)
1
SELECT t0.id AS id_1, t0.name AS name_2, t0.service_name AS service_name_3, t0.description AS description_4, t0.confirm_url AS confirm_url_5, t0.sort_no AS sort_no_6, t0.visible AS visible_7, t0.create_date AS create_date_8, t0.update_date AS update_date_9, t0.delivery_cool_flg AS delivery_cool_flg_10, t0.deliverydate_date_flg AS deliverydate_date_flg_11, t0.creator_id AS creator_id_12, t0.sale_type_id AS sale_type_id_13, t15.id AS id_14, t15.no_point_flg AS no_point_flg_16, t15.delivery_id AS delivery_id_17, t0.discriminator_type FROM dtb_delivery t0 LEFT JOIN plg_delivery_no_point t15 ON t15.delivery_id = t0.id WHERE t0.sale_type_id = ? AND t0.visible = ? AND t0.discriminator_type IN ('delivery')
Parameters:
[
  1
  1
]
0.08 ms
(1.76%)
1
SELECT t0.id AS id_1, t0.option_group_product_hidden AS option_group_product_hidden_2, t0.option_group_category_hidden AS option_group_category_hidden_3, t0.option1 AS option1_4, t0.discriminator_type FROM plg_customer_group_config t0 WHERE t0.id = ? AND t0.discriminator_type IN ('config')
Parameters:
[
  1
]
0.08 ms
(1.76%)
1
SELECT t0.id AS id_1, t0.name AS name_2, t0.backend_name AS backend_name_3, t0.option_non_member_display AS option_non_member_display_4, t0.sort_no AS sort_no_5, t0.discriminator_type FROM plg_customer_group t0 INNER JOIN plg_customer_group_customers_groups ON t0.id = plg_customer_group_customers_groups.group_id WHERE plg_customer_group_customers_groups.customer_id = ? AND t0.discriminator_type IN ('group') ORDER BY t0.sort_no ASC
Parameters:
[
  1
]
0.08 ms
(1.73%)
1
SELECT t0.id AS id_1, t0.tax_rate AS tax_rate_2, t0.tax_adjust AS tax_adjust_3, t0.apply_date AS apply_date_4, t0.create_date AS create_date_5, t0.update_date AS update_date_6, t0.product_class_id AS product_class_id_7, t0.creator_id AS creator_id_8, t0.country_id AS country_id_9, t0.pref_id AS pref_id_10, t0.product_id AS product_id_11, t0.rounding_type_id AS rounding_type_id_12, t0.discriminator_type FROM dtb_tax_rule t0 WHERE t0.product_class_id = ? AND t0.discriminator_type IN ('taxrule')
Parameters:
[
  138
]
0.08 ms
(1.71%)
1
SELECT t0.id AS id_1, t0.name AS name_2, t0.backend_name AS backend_name_3, t0.option_non_member_display AS option_non_member_display_4, t0.sort_no AS sort_no_5, t0.discriminator_type FROM plg_customer_group t0 INNER JOIN plg_customer_group_products_groups ON t0.id = plg_customer_group_products_groups.group_id WHERE plg_customer_group_products_groups.product_id = ? AND t0.discriminator_type IN ('group')
Parameters:
[
  28
]
0.07 ms
(1.62%)
1
SELECT t0.id AS id_1, t0.stock AS stock_2, t0.create_date AS create_date_3, t0.update_date AS update_date_4, t0.product_class_id AS product_class_id_5, t0.creator_id AS creator_id_6, t0.discriminator_type FROM dtb_product_stock t0 WHERE t0.product_class_id = ? AND t0.discriminator_type IN ('productstock')
Parameters:
[
  138
]
0.07 ms
(1.60%)
1
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:
[
  "CustomerRank42"
]
0.06 ms
(1.34%)
1
SELECT t0.name AS name_1, t0.value AS value_2, t0.discriminator_type FROM plg_deliveryfreeproduct_dtb_config t0 WHERE t0.name = ? AND t0.discriminator_type IN ('deliveryfreeconfig') LIMIT 1
Parameters:
[
  "condition"
]
0.06 ms
(1.29%)
1
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:
[]

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.
Plugin\PinpointSaleDx\Entity\PlgConfig
  • The mappings Plugin\PinpointSaleDx\Entity\PlgConfig#ConfigOptions and Plugin\PinpointSaleDx\Entity\PlgConfigOption#PlgConfig are inconsistent with each other.
Plugin\PinpointSaleDx\Entity\PlgConfigOption
  • The association Plugin\PinpointSaleDx\Entity\PlgConfigOption#PlgConfig refers to the inverse side field Plugin\PinpointSaleDx\Entity\PlgConfig#PlgConfigOptions which does not exist.
Eccube\Entity\Category No errors.
Plugin\CustomerGroup42\Entity\Config No errors.
Eccube\Entity\Product 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.
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\Order
  • The mappings Eccube\Entity\Order#AmazonPayV2AmazonTradings and Plugin\AmazonPayV2_42\Entity\AmazonTrading#Order are inconsistent with each other.
  • 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\Customer No errors.
Eccube\Entity\Master\CustomerStatus No errors.
Eccube\Entity\Master\Sex No errors.
Eccube\Entity\Master\Job No errors.
Eccube\Entity\CustomerFavoriteProduct No errors.
Eccube\Entity\CustomerAddress No errors.
Plugin\MailMag\Entity\MailJob No errors.
Plugin\CustomerGroup42\Entity\Group No errors.
Eccube\Entity\Member No errors.
Eccube\Entity\Master\LoginHistoryStatus No errors.
Eccube\Entity\Master\OrderItemType No errors.
Eccube\Entity\Master\OrderStatus No errors.
Eccube\Entity\Delivery
  • The mappings Eccube\Entity\Delivery#ColdFees and Plugin\DeliveryCool42\Entity\DeliveryColdFee#Delivery are inconsistent with each other.
  • The mappings Eccube\Entity\Delivery#CoolFees and Plugin\DeliveryCool42\Entity\DeliveryCoolFee#Delivery are inconsistent with each other.
Eccube\Entity\Payment No errors.
Plugin\DeliveryFreeProduct42\Entity\DeliveryFreeConfig No errors.
Plugin\ProductOption42\Entity\Option No errors.
Plugin\ProductOption42\Entity\OptionCategory No errors.
Eccube\Entity\ProductClass No errors.
Eccube\Entity\Cart No errors.
Eccube\Entity\CartItem No errors.
Eccube\Entity\Master\SaleType No errors.
Eccube\Entity\ClassCategory No errors.
Eccube\Entity\DeliveryDuration No errors.
Eccube\Entity\Master\Work No errors.
Eccube\Entity\Master\Authority No errors.
Eccube\Entity\ClassName No errors.
Eccube\Entity\Master\ProductStatus No errors.
Eccube\Entity\ProductStock No errors.
Eccube\Entity\TaxRule No errors.
Eccube\Entity\Master\RoundingType No errors.
Plugin\PinpointSaleDx\Entity\ProductPinpoint No errors.
Plugin\PointExDx\Entity\ProductClassPointExDx No errors.
Plugin\PinpointSaleDx\Entity\Pinpoint No errors.
Plugin\PointExDx\Entity\DeliveryNoPoint No errors.
Eccube\Entity\PaymentOption No errors.
Eccube\Entity\DeliveryFee No errors.
Eccube\Entity\DeliveryTime No errors.
Plugin\DeliveryCool42\Entity\DeliveryColdFee No errors.
Plugin\DeliveryCool42\Entity\DeliveryCoolFee No errors.
Plugin\DeliveryDate42\Entity\DeliveryDate No errors.
Eccube\Entity\ProductCategory No errors.
Eccube\Entity\ProductImage No errors.
Eccube\Entity\ProductTag No errors.
Plugin\RelatedProduct42\Entity\RelatedProduct No errors.
Plugin\ProductOption42\Entity\ProductOption No errors.
Plugin\HiddenDeliveryDate42\Entity\Hiddenday
  • The association Plugin\HiddenDeliveryDate42\Entity\Hiddenday#Delivery refers to the inverse side field Eccube\Entity\Delivery#Hiddendays which does not exist.
Eccube\Entity\Plugin No errors.