https://muyu-sen.com/kanri/order/774/edit Return to referer URL

Method
POST
HTTP Status
302
IP
123.100.222.204
Profiled on
Token
d69ed8

Query Metrics

41 Database Queries
29 Different statements
28.73 ms Query time
2 Invalid entities

Queries

Group similar statements

#▲ Time Info
1 0.78 ms 
SET SESSION time_zone = '+00:00'
Parameters: 
[]
View formatted query    View runnable query    Explain query
2 0.79 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: 
[
  "muyu-sen_admin"
  1
]
View formatted query    View runnable query    Explain query
3 0.79 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: 
[
  1
]
View formatted query    View runnable query    Explain query
4 0.63 ms 
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.rounding_type_id AS rounding_type_id_5, t0.discriminator_type FROM plg_customer_group_config t0 WHERE t0.id = ? AND t0.discriminator_type IN ('config')
Parameters: 
[
  1
]
View formatted query    View runnable query    Explain query
5 0.90 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.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
]
View formatted query    View runnable query    Explain query
6 0.63 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: 
[
  1
]
View formatted query    View runnable query    Explain query
7 0.43 ms 
SET SESSION TRANSACTION ISOLATION LEVEL READ COMMITTED
Parameters: 
[]
View formatted query    View runnable query    Explain query
8 0.71 ms 
"START TRANSACTION"
Parameters: 
[]
View formatted query    View runnable query    Explain query
9 0.86 ms 
SELECT t0.id AS id_1, t0.contract_code AS contract_code_2, t0.environmental_setting AS environmental_setting_3, t0.credit_payment_setting AS credit_payment_setting_4, t0.use_payment AS use_payment_5, t0.use_convenience AS use_convenience_6, t0.card_expiration_notification_days AS card_expiration_notification_days_7, t0.regular AS regular_8, t0.block_mode AS block_mode_9, t0.access_frequency_time AS access_frequency_time_10, t0.access_frequency AS access_frequency_11, t0.block_time AS block_time_12, t0.white_list AS white_list_13, t0.regular_order_notification_email AS regular_order_notification_email_14, t0.next_delivery_date_changeable_range_days AS next_delivery_date_changeable_range_days_15, t0.first_delivery_days AS first_delivery_days_16, t0.next_delivery_days_at_regular_resumption AS next_delivery_days_at_regular_resumption_17, t0.next_delivery_days_after_re_payment AS next_delivery_days_after_re_payment_18, t0.regular_order_deadline AS regular_order_deadline_19, t0.regular_delivery_notification_email_days AS regular_delivery_notification_email_days_20, t0.regular_stoppable_count AS regular_stoppable_count_21, t0.regular_cancelable_count AS regular_cancelable_count_22, t0.regular_resumable_period AS regular_resumable_period_23, t0.regular_specified_count_notification_mail AS regular_specified_count_notification_mail_24, t0.regular_point_magnification AS regular_point_magnification_25 FROM plg_eccube_payment_lite42_config t0 WHERE t0.id = ?
Parameters: 
[
  1
]
View formatted query    View runnable query    Explain query
10 0.97 ms 
SELECT t0.id AS id_1, t0.pre_order_id AS pre_order_id_2, t0.order_no AS order_no_3, t0.message AS message_4, t0.name01 AS name01_5, t0.name02 AS name02_6, t0.kana01 AS kana01_7, t0.kana02 AS kana02_8, t0.company_name AS company_name_9, t0.email AS email_10, t0.phone_number AS phone_number_11, t0.postal_code AS postal_code_12, t0.addr01 AS addr01_13, t0.addr02 AS addr02_14, t0.birth AS birth_15, t0.subtotal AS subtotal_16, t0.discount AS discount_17, t0.delivery_fee_total AS delivery_fee_total_18, t0.charge AS charge_19, t0.tax AS tax_20, t0.total AS total_21, t0.payment_total AS payment_total_22, t0.payment_method AS payment_method_23, t0.note AS note_24, t0.create_date AS create_date_25, t0.update_date AS update_date_26, t0.order_date AS order_date_27, t0.payment_date AS payment_date_28, t0.currency_code AS currency_code_29, t0.complete_message AS complete_message_30, t0.complete_mail_message AS complete_mail_message_31, t0.trans_code AS trans_code_32, t0.gmo_epsilon_order_no AS gmo_epsilon_order_no_33, t0.add_point AS add_point_34, t0.use_point AS use_point_35, t0.customer_id AS customer_id_36, t0.country_id AS country_id_37, t0.pref_id AS pref_id_38, t0.sex_id AS sex_id_39, t0.job_id AS job_id_40, t0.payment_id AS payment_id_41, t0.device_type_id AS device_type_id_42, t0.order_status_id AS order_status_id_43, t0.order_status_id AS order_status_id_44, t0.order_status_id AS order_status_id_45, t0.payment_status_id AS payment_status_id_46, t0.regular_order_id AS regular_order_id_47, t0.discriminator_type FROM dtb_order t0 WHERE t0.id = ? AND t0.discriminator_type IN ('order')
Parameters: 
[
  "774"
]
View formatted query    View runnable query    Explain query
11 0.86 ms 
SELECT t0.id AS id_1, t0.product_name AS product_name_2, t0.product_code AS product_code_3, t0.class_name1 AS class_name1_4, t0.class_name2 AS class_name2_5, t0.class_category_name1 AS class_category_name1_6, t0.class_category_name2 AS class_category_name2_7, t0.price AS price_8, t0.quantity AS quantity_9, t0.tax AS tax_10, t0.tax_rate AS tax_rate_11, t0.tax_adjust AS tax_adjust_12, t0.tax_rule_id AS tax_rule_id_13, t0.currency_code AS currency_code_14, t0.processor_name AS processor_name_15, t0.point_rate AS point_rate_16, t0.order_id AS order_id_17, t0.product_id AS product_id_18, t0.product_class_id AS product_class_id_19, t0.shipping_id AS shipping_id_20, t0.rounding_type_id AS rounding_type_id_21, t0.tax_type_id AS tax_type_id_22, t0.tax_display_type_id AS tax_display_type_id_23, t0.order_item_type_id AS order_item_type_id_24, t0.discriminator_type FROM dtb_order_item t0 WHERE t0.order_id = ? AND t0.discriminator_type IN ('orderitem')
Parameters: 
[
  774
]
View formatted query    View runnable query    Explain query
12 0.65 ms 
SELECT t0.id AS id_1, t0.name AS name_2, t0.sort_no AS sort_no_3, t0.discriminator_type FROM mtb_pref t0 WHERE t0.id = ? AND t0.discriminator_type IN ('pref')
Parameters: 
[
  44
]
View formatted query    View runnable query    Explain query
13 2.25 ms 
SELECT t0.id AS id_1, t0.payment_method AS payment_method_2, t0.charge AS charge_3, t0.rule_max AS rule_max_4, t0.sort_no AS sort_no_5, t0.fixed AS fixed_6, t0.payment_image AS payment_image_7, t0.rule_min AS rule_min_8, t0.method_class AS method_class_9, t0.visible AS visible_10, t0.create_date AS create_date_11, t0.update_date AS update_date_12, t0.creator_id AS creator_id_13, t0.discriminator_type FROM dtb_payment t0 WHERE t0.id = ? AND t0.discriminator_type IN ('payment')
Parameters: 
[
  7
]
View formatted query    View runnable query    Explain query
14 1.06 ms 
SELECT t0.display_order_count AS display_order_count_1, t0.id AS id_2, t0.name AS name_3, t0.sort_no AS sort_no_4, t0.discriminator_type FROM mtb_order_status t0 WHERE t0.discriminator_type IN ('orderstatus') ORDER BY t0.sort_no ASC
Parameters: 
[]
View formatted query    View runnable query    Explain query
15 0.88 ms 
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.phone_number AS phone_number_7, t0.postal_code AS postal_code_8, t0.addr01 AS addr01_9, t0.addr02 AS addr02_10, t0.delivery_name AS delivery_name_11, t0.time_id AS time_id_12, t0.delivery_time AS delivery_time_13, t0.delivery_date AS delivery_date_14, t0.shipping_date AS shipping_date_15, t0.tracking_number AS tracking_number_16, t0.note AS note_17, t0.sort_no AS sort_no_18, t0.create_date AS create_date_19, t0.update_date AS update_date_20, t0.mail_send_date AS mail_send_date_21, t0.order_id AS order_id_22, t0.country_id AS country_id_23, t0.pref_id AS pref_id_24, t0.delivery_id AS delivery_id_25, t0.creator_id AS creator_id_26, t0.discriminator_type FROM dtb_shipping t0 WHERE t0.order_id = ? AND t0.discriminator_type IN ('shipping') ORDER BY t0.name01 ASC, t0.name02 ASC, t0.id ASC
Parameters: 
[
  774
]
View formatted query    View runnable query    Explain query
16 0.70 ms 
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.creator_id AS creator_id_10, t0.sale_type_id AS sale_type_id_11, t0.delivery_company_id AS delivery_company_id_12, t0.discriminator_type FROM dtb_delivery t0 WHERE t0.id = ? AND t0.discriminator_type IN ('delivery')
Parameters: 
[
  5
]
View formatted query    View runnable query    Explain query
17 0.76 ms 
SELECT t0.id AS id_1, t0.product_name AS product_name_2, t0.product_code AS product_code_3, t0.class_name1 AS class_name1_4, t0.class_name2 AS class_name2_5, t0.class_category_name1 AS class_category_name1_6, t0.class_category_name2 AS class_category_name2_7, t0.price AS price_8, t0.quantity AS quantity_9, t0.tax AS tax_10, t0.tax_rate AS tax_rate_11, t0.tax_adjust AS tax_adjust_12, t0.tax_rule_id AS tax_rule_id_13, t0.currency_code AS currency_code_14, t0.processor_name AS processor_name_15, t0.point_rate AS point_rate_16, t0.order_id AS order_id_17, t0.product_id AS product_id_18, t0.product_class_id AS product_class_id_19, t0.shipping_id AS shipping_id_20, t0.rounding_type_id AS rounding_type_id_21, t0.tax_type_id AS tax_type_id_22, t0.tax_display_type_id AS tax_display_type_id_23, t0.order_item_type_id AS order_item_type_id_24, t0.discriminator_type FROM dtb_order_item t0 WHERE t0.shipping_id = ? AND t0.discriminator_type IN ('orderitem')
Parameters: 
[
  783
]
View formatted query    View runnable query    Explain query
18 0.66 ms 
SELECT t0.id AS id_1, t0.name AS name_2, t0.sort_no AS sort_no_3, t0.discriminator_type FROM plg_eccube_payment_lite42_payment_status t0 WHERE t0.id IN (?, ?, ?, ?) AND t0.discriminator_type IN ('paymentstatus') ORDER BY t0.sort_no ASC
Parameters: 
[
  0
  1
  5
  9
]
View formatted query    View runnable query    Explain query
19 0.56 ms 
SELECT t0.display_order_count AS display_order_count_1, t0.id AS id_2, t0.name AS name_3, t0.sort_no AS sort_no_4, t0.discriminator_type FROM mtb_order_status t0 WHERE t0.discriminator_type IN ('orderstatus') ORDER BY t0.sort_no ASC
Parameters: 
[]
View formatted query    View runnable query    Explain query
20 0.75 ms 
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.phone_number AS phone_number_7, t0.postal_code AS postal_code_8, t0.addr01 AS addr01_9, t0.addr02 AS addr02_10, t0.delivery_name AS delivery_name_11, t0.time_id AS time_id_12, t0.delivery_time AS delivery_time_13, t0.delivery_date AS delivery_date_14, t0.shipping_date AS shipping_date_15, t0.tracking_number AS tracking_number_16, t0.note AS note_17, t0.sort_no AS sort_no_18, t0.create_date AS create_date_19, t0.update_date AS update_date_20, t0.mail_send_date AS mail_send_date_21, t0.order_id AS order_id_22, t0.country_id AS country_id_23, t0.pref_id AS pref_id_24, t0.delivery_id AS delivery_id_25, t0.creator_id AS creator_id_26, t0.discriminator_type FROM dtb_shipping t0 WHERE t0.order_id = ? AND t0.discriminator_type IN ('shipping') ORDER BY t0.name01 ASC, t0.name02 ASC, t0.id ASC
Parameters: 
[
  774
]
View formatted query    View runnable query    Explain query
21 0.62 ms 
SELECT m0_.id AS id_0, m0_.name AS name_1, m0_.sort_no AS sort_no_2, m0_.discriminator_type AS discriminator_type_3 FROM mtb_pref m0_ WHERE (m0_.id IN (?)) AND m0_.discriminator_type IN ('pref') ORDER BY m0_.sort_no ASC
Parameters: 
[
  "44"
]
View formatted query    View runnable query    Explain query
22 0.60 ms 
SELECT d0_.id AS id_0, d0_.payment_method AS payment_method_1, d0_.charge AS charge_2, d0_.rule_max AS rule_max_3, d0_.sort_no AS sort_no_4, d0_.fixed AS fixed_5, d0_.payment_image AS payment_image_6, d0_.rule_min AS rule_min_7, d0_.method_class AS method_class_8, d0_.visible AS visible_9, d0_.create_date AS create_date_10, d0_.update_date AS update_date_11, d0_.discriminator_type AS discriminator_type_12, d0_.creator_id AS creator_id_13 FROM dtb_payment d0_ WHERE (d0_.id IN (?)) AND d0_.discriminator_type IN ('payment') ORDER BY d0_.visible DESC, d0_.sort_no ASC
Parameters: 
[
  "7"
]
View formatted query    View runnable query    Explain query
23 0.70 ms 
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.product_id AS product_id_14, t0.sale_type_id AS sale_type_id_15, t0.class_category_id1 AS class_category_id1_16, t0.class_category_id2 AS class_category_id2_17, t0.delivery_duration_id AS delivery_duration_id_18, t0.creator_id AS creator_id_19, t0.regular_discount_id AS regular_discount_id_20, t0.discriminator_type FROM dtb_product_class t0 WHERE t0.id = ? AND t0.discriminator_type IN ('productclass')
Parameters: 
[
  24
]
View formatted query    View runnable query    Explain query
24 0.61 ms 
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: 
[
  24
]
View formatted query    View runnable query    Explain query
25 0.69 ms 
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: 
[
  24
]
View formatted query    View runnable query    Explain query
26 0.63 ms 
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.product_id AS product_id_14, t0.sale_type_id AS sale_type_id_15, t0.class_category_id1 AS class_category_id1_16, t0.class_category_id2 AS class_category_id2_17, t0.delivery_duration_id AS delivery_duration_id_18, t0.creator_id AS creator_id_19, t0.regular_discount_id AS regular_discount_id_20, t0.discriminator_type FROM dtb_product_class t0 WHERE t0.id = ? AND t0.discriminator_type IN ('productclass')
Parameters: 
[
  73
]
View formatted query    View runnable query    Explain query
27 0.56 ms 
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: 
[
  73
]
View formatted query    View runnable query    Explain query
28 0.58 ms 
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: 
[
  73
]
View formatted query    View runnable query    Explain query
29 0.53 ms 
SELECT m0_.id AS id_0, m0_.name AS name_1, m0_.sort_no AS sort_no_2, m0_.discriminator_type AS discriminator_type_3 FROM mtb_pref m0_ WHERE (m0_.id IN (?)) AND m0_.discriminator_type IN ('pref') ORDER BY m0_.sort_no ASC
Parameters: 
[
  "44"
]
View formatted query    View runnable query    Explain query
30 0.59 ms 
SELECT d0_.id AS id_0, d0_.name AS name_1, d0_.service_name AS service_name_2, d0_.description AS description_3, d0_.confirm_url AS confirm_url_4, d0_.sort_no AS sort_no_5, d0_.visible AS visible_6, d0_.create_date AS create_date_7, d0_.update_date AS update_date_8, d0_.discriminator_type AS discriminator_type_9, d0_.creator_id AS creator_id_10, d0_.sale_type_id AS sale_type_id_11, d0_.delivery_company_id AS delivery_company_id_12 FROM dtb_delivery d0_ WHERE (d0_.id IN (?)) AND d0_.discriminator_type IN ('delivery') ORDER BY d0_.visible DESC, d0_.sort_no ASC
Parameters: 
[
  "5"
]
View formatted query    View runnable query    Explain query
31 0.83 ms 
SELECT t0.coupon_order_id AS coupon_order_id_1, t0.coupon_id AS coupon_id_2, t0.coupon_cd AS coupon_cd_3, t0.coupon_name AS coupon_name_4, t0.user_id AS user_id_5, t0.email AS email_6, t0.order_id AS order_id_7, t0.pre_order_id AS pre_order_id_8, t0.order_date AS order_date_9, t0.order_item_id AS order_item_id_10, t0.discount AS discount_11, t0.visible AS visible_12, t0.order_change_status AS order_change_status_13, t0.create_date AS create_date_14, t0.update_date AS update_date_15, t0.discriminator_type FROM plg_coupon_order t0 WHERE t0.pre_order_id = ? AND t0.discriminator_type IN ('couponorder') LIMIT 1
Parameters: 
[
  "f546dc0b0a909f1a7569efa2b74afcc60c660c6c"
]
View formatted query    View runnable query    Explain query
32 0.54 ms 
SELECT t0.coupon_order_id AS coupon_order_id_1, t0.coupon_id AS coupon_id_2, t0.coupon_cd AS coupon_cd_3, t0.coupon_name AS coupon_name_4, t0.user_id AS user_id_5, t0.email AS email_6, t0.order_id AS order_id_7, t0.pre_order_id AS pre_order_id_8, t0.order_date AS order_date_9, t0.order_item_id AS order_item_id_10, t0.discount AS discount_11, t0.visible AS visible_12, t0.order_change_status AS order_change_status_13, t0.create_date AS create_date_14, t0.update_date AS update_date_15, t0.discriminator_type FROM plg_coupon_order t0 WHERE t0.pre_order_id = ? AND t0.discriminator_type IN ('couponorder') LIMIT 1
Parameters: 
[
  "f546dc0b0a909f1a7569efa2b74afcc60c660c6c"
]
View formatted query    View runnable query    Explain query
33 0.54 ms 
SELECT t0.coupon_order_id AS coupon_order_id_1, t0.coupon_id AS coupon_id_2, t0.coupon_cd AS coupon_cd_3, t0.coupon_name AS coupon_name_4, t0.user_id AS user_id_5, t0.email AS email_6, t0.order_id AS order_id_7, t0.pre_order_id AS pre_order_id_8, t0.order_date AS order_date_9, t0.order_item_id AS order_item_id_10, t0.discount AS discount_11, t0.visible AS visible_12, t0.order_change_status AS order_change_status_13, t0.create_date AS create_date_14, t0.update_date AS update_date_15, t0.discriminator_type FROM plg_coupon_order t0 WHERE t0.pre_order_id = ? AND t0.discriminator_type IN ('couponorder') LIMIT 1
Parameters: 
[
  "f546dc0b0a909f1a7569efa2b74afcc60c660c6c"
]
View formatted query    View runnable query    Explain query
34 0.64 ms 
UPDATE dtb_order SET subtotal = ?, discount = ?, delivery_fee_total = ?, charge = ?, tax = ?, total = ?, payment_total = ?, use_point = ?, order_status_id = ?, update_date = ? WHERE id = ?
Parameters: 
[
  36058.0
  0
  0
  0
  3278.0
  36058.0
  36058.0
  0.0
  4
  "2025-09-13 08:40:32"
  774
]
View formatted query    View runnable query    Explain query
35 0.43 ms 
UPDATE dtb_order_item SET price = ?, quantity = ?, tax = ?, tax_rate = ? WHERE id = ?
Parameters: 
[
  9320
  2
  932.0
  10
  5728
]
View formatted query    View runnable query    Explain query
36 0.38 ms 
UPDATE dtb_order_item SET price = ?, quantity = ?, tax = ?, tax_rate = ? WHERE id = ?
Parameters: 
[
  7070
  2
  707.0
  10
  5729
]
View formatted query    View runnable query    Explain query
37 0.37 ms 
UPDATE dtb_order_item SET price = ?, quantity = ?, tax = ?, tax_rate = ? WHERE id = ?
Parameters: 
[
  0
  1
  0.0
  10
  5731
]
View formatted query    View runnable query    Explain query
38 0.39 ms 
UPDATE dtb_order_item SET price = ?, quantity = ?, tax = ?, tax_rate = ? WHERE id = ?
Parameters: 
[
  850
  0
  77.0
  10
  5737
]
View formatted query    View runnable query    Explain query
39 0.57 ms 
SELECT COUNT(d0_.id) AS sclr_0, SUM(d0_.total) AS sclr_1, MIN(d0_.id) AS sclr_2, MAX(d0_.id) AS sclr_3 FROM dtb_order d0_ WHERE (d0_.customer_id = ? AND d0_.order_status_id IN (?, ?, ?, ?)) AND d0_.discriminator_type IN ('order') GROUP BY d0_.customer_id
Parameters: 
[
  217
  1
  6
  5
  4
]
View formatted query    View runnable query    Explain query
40 0.68 ms 
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.gmo_epsilon_credit_card_expiration_date AS gmo_epsilon_credit_card_expiration_date_26, t0.card_change_request_mail_send_date AS card_change_request_mail_send_date_27, t0.customer_status_id AS customer_status_id_28, t0.sex_id AS sex_id_29, t0.job_id AS job_id_30, t0.country_id AS country_id_31, t0.pref_id AS pref_id_32, t0.discriminator_type FROM dtb_customer t0 WHERE t0.id = ? AND t0.discriminator_type IN ('customer')
Parameters: 
[
  217
]
View formatted query    View runnable query    Explain query
41 0.63 ms 
UPDATE dtb_customer SET first_buy_date = ?, last_buy_date = ?, buy_times = ?, update_date = ? WHERE id = ?
Parameters: 
[
  "2025-09-13 06:00:57"
  "2025-09-13 06:00:57"
  1
  "2025-09-13 08:40:32"
  217
]
View formatted query    View runnable query    Explain query

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\Category No errors.
Plugin\CustomerGroup42\Entity\Config No errors.
Eccube\Entity\Product 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.
Plugin\CustomerGroupPrice42\Entity\GroupPrice No errors.
Eccube\Entity\Master\RoundingType No errors.
Eccube\Entity\Master\Country No errors.
Eccube\Entity\Master\Pref No errors.
Eccube\Entity\Order No errors.
Eccube\Entity\Customer No errors.
Eccube\Entity\Delivery No errors.
Eccube\Entity\ProductClass
  • The field Eccube\Entity\ProductClass#ProductClassRegularCycle is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity Plugin\EccubePaymentLite42\Entity\ProductClassRegularCycle#ProductClass does not contain the required 'inversedBy="ProductClassRegularCycle"' attribute.
Plugin\Coupon42\Entity\Coupon No errors.
Plugin\Coupon42\Entity\CouponOrder No errors.
Eccube\Entity\Master\TaxType No errors.
Eccube\Entity\Master\TaxDisplayType No errors.
Eccube\Entity\Master\OrderItemType No errors.
Eccube\Entity\OrderItem No errors.
Plugin\EccubePaymentLite42\Entity\Config No errors.
Plugin\EccubePaymentLite42\Entity\GmoEpsilonPayment No errors.
Plugin\EccubePaymentLite42\Entity\ConvenienceStore No errors.
Plugin\EccubePaymentLite42\Entity\IpBlackList No errors.
Plugin\EccubePaymentLite42\Entity\MyPageRegularSetting No errors.
Eccube\Entity\Master\OrderStatus No errors.
Eccube\Entity\ProductStock No errors.
Eccube\Entity\Payment No errors.
Eccube\Entity\Master\Sex No errors.
Eccube\Entity\Master\Job No errors.
Eccube\Entity\Master\CustomerOrderStatus No errors.
Eccube\Entity\Master\OrderStatusColor No errors.
Plugin\EccubePaymentLite42\Entity\PaymentStatus No errors.
Plugin\EccubePaymentLite42\Entity\RegularOrder No errors.
Eccube\Entity\Shipping No errors.
Eccube\Entity\MailHistory No errors.
Eccube\Entity\PaymentOption No errors.
Eccube\Entity\DeliveryTime No errors.
Eccube\Entity\Master\SaleType No errors.
Plugin\EccubePaymentLite42\Entity\DeliveryCompany No errors.
Eccube\Entity\DeliveryFee No errors.
Eccube\Entity\TaxRule No errors.
Eccube\Entity\ClassCategory No errors.
Eccube\Entity\DeliveryDuration No errors.
Plugin\EccubePaymentLite42\Entity\RegularDiscount No errors.
Plugin\EccubePaymentLite42\Entity\ProductClassRegularCycle No errors.
Eccube\Entity\ClassName No errors.
Eccube\Entity\Master\ProductStatus No errors.
Plugin\EccubePaymentLite42\Entity\RegularStatus No errors.
Plugin\EccubePaymentLite42\Entity\RegularCycle
  • The field Plugin\EccubePaymentLite42\Entity\RegularCycle#ProductClassRegularCycle is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity Plugin\EccubePaymentLite42\Entity\ProductClassRegularCycle#RegularCycle does not contain the required 'inversedBy="ProductClassRegularCycle"' attribute.
Plugin\EccubePaymentLite42\Entity\RegularCycleType No errors.
Eccube\Entity\Master\CustomerStatus No errors.
Eccube\Entity\CustomerFavoriteProduct No errors.
Eccube\Entity\CustomerAddress No errors.
Plugin\CustomerGroup42\Entity\Group No errors.