https://mu-ecshop.com/cldadm/shipping/notify_mail_order/23 Return to referer URL

Method
PUT
HTTP Status
200
IP
114.161.109.136
Profiled on
Token
834ffe

Query Metrics

16 Database Queries
15 Different statements
3.12 ms Query time
4 Invalid entities

Queries

Group similar statements

#▲ Time Info
1 0.14 ms 
SET SESSION time_zone = '+00:00'
Parameters: 
[]
View formatted query    View runnable query    Explain query
2 0.13 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.store_id AS store_id_16, t0.discriminator_type FROM dtb_member t0 WHERE t0.login_id = ? AND t0.work_id = ? AND t0.discriminator_type IN ('member') LIMIT 1
Parameters: 
[
  "mitoadmin"
  1
]
View formatted query    View runnable query    Explain query
3 0.13 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: 
[
  4
]
View formatted query    View runnable query    Explain query
4 0.13 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.option_mail_notifier AS option_mail_notifier_29, t0.authentication_key AS authentication_key_30, t0.php_path AS php_path_31, t0.option_point AS option_point_32, t0.basic_point_rate AS basic_point_rate_33, t0.point_conversion_rate AS point_conversion_rate_34, t0.contact_school_visible_type AS contact_school_visible_type_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
]
View formatted query    View runnable query    Explain query
5 0.07 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: 
[
  4
]
View formatted query    View runnable query    Explain query
6 0.13 ms 
SET SESSION TRANSACTION ISOLATION LEVEL READ COMMITTED
Parameters: 
[]
View formatted query    View runnable query    Explain query
7 0.05 ms 
"START TRANSACTION"
Parameters: 
[]
View formatted query    View runnable query    Explain query
8 0.27 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.tel2_01 AS tel2_01_22, t0.tel2_02 AS tel2_02_23, t0.tel2_03 AS tel2_03_24, t0.fax01 AS fax01_25, t0.fax02 AS fax02_26, t0.fax03 AS fax03_27, t0.shipping_schedule_date AS shipping_schedule_date_28, t0.order_id AS order_id_29, t0.country_id AS country_id_30, t0.pref_id AS pref_id_31, t0.delivery_id AS delivery_id_32, t0.creator_id AS creator_id_33, t0.fee_id AS fee_id_34, t0.discriminator_type FROM dtb_shipping t0 WHERE t0.id = ? AND t0.discriminator_type IN ('shipping')
Parameters: 
[
  "23"
]
View formatted query    View runnable query    Explain query
9 0.16 ms 
SELECT t0.id AS id_1, t0.name AS name_2, t0.file_name AS file_name_3, t0.mail_subject AS mail_subject_4, t0.create_date AS create_date_5, t0.update_date AS update_date_6, t0.creator_id AS creator_id_7, t0.discriminator_type FROM dtb_mail_template t0 WHERE t0.id = ? AND t0.discriminator_type IN ('mailtemplate')
Parameters: 
[
  "13"
]
View formatted query    View runnable query    Explain query
10 0.19 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.phone_number2 AS phone_number2_32, t0.fax01 AS fax01_33, t0.fax02 AS fax02_34, t0.fax03 AS fax03_35, t0.zip01 AS zip01_36, t0.zip02 AS zip02_37, t0.temporary_order_date AS temporary_order_date_38, t0.formal_order_date AS formal_order_date_39, t0.commit_date AS commit_date_40, t0.delivery_date AS delivery_date_41, t0.prev_school AS prev_school_42, t0.school_year AS school_year_43, t0.school_class AS school_class_44, t0.prev_school_year AS prev_school_year_45, t0.prev_school_class AS prev_school_class_46, t0.student_number AS student_number_47, t0.free1 AS free1_48, t0.free2 AS free2_49, t0.admission_year AS admission_year_50, t0.stocking_date AS stocking_date_51, t0.order_school_year AS order_school_year_52, t0.order_school_class AS order_school_class_53, t0.gmo_payment_gateway_payment_status AS gmo_payment_gateway_payment_status_54, t0.add_point AS add_point_55, t0.use_point AS use_point_56, t0.customer_id AS customer_id_57, t0.country_id AS country_id_58, t0.pref_id AS pref_id_59, t0.sex_id AS sex_id_60, t0.job_id AS job_id_61, t0.payment_id AS payment_id_62, t0.device_type_id AS device_type_id_63, t0.order_status_id AS order_status_id_64, t0.order_status_id AS order_status_id_65, t0.order_status_id AS order_status_id_66, t0.school_id AS school_id_67, t0.discriminator_type FROM dtb_order t0 WHERE t0.id = ? AND t0.discriminator_type IN ('order')
Parameters: 
[
  22
]
View formatted query    View runnable query    Explain query
11 0.18 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.set_product_class AS set_product_class_17, t0.set_product_price AS set_product_price_18, t0.remarks AS remarks_19, t0.order_id AS order_id_20, t0.product_id AS product_id_21, t0.product_class_id AS product_class_id_22, t0.shipping_id AS shipping_id_23, t0.rounding_type_id AS rounding_type_id_24, t0.tax_type_id AS tax_type_id_25, t0.tax_display_type_id AS tax_display_type_id_26, t0.order_item_type_id AS order_item_type_id_27, t0.delivery_period_id AS delivery_period_id_28, t0.brother_id AS brother_id_29, t0.discriminator_type FROM dtb_order_item t0 WHERE t0.order_id = ? AND t0.discriminator_type IN ('orderitem')
Parameters: 
[
  22
]
View formatted query    View runnable query    Explain query
12 0.16 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.tel2_01 AS tel2_01_22, t0.tel2_02 AS tel2_02_23, t0.tel2_03 AS tel2_03_24, t0.fax01 AS fax01_25, t0.fax02 AS fax02_26, t0.fax03 AS fax03_27, t0.shipping_schedule_date AS shipping_schedule_date_28, t0.order_id AS order_id_29, t0.country_id AS country_id_30, t0.pref_id AS pref_id_31, t0.delivery_id AS delivery_id_32, t0.creator_id AS creator_id_33, t0.fee_id AS fee_id_34, 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: 
[
  22
]
View formatted query    View runnable query    Explain query
13 0.10 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.set_product_class AS set_product_class_17, t0.set_product_price AS set_product_price_18, t0.remarks AS remarks_19, t0.order_id AS order_id_20, t0.product_id AS product_id_21, t0.product_class_id AS product_class_id_22, t0.shipping_id AS shipping_id_23, t0.rounding_type_id AS rounding_type_id_24, t0.tax_type_id AS tax_type_id_25, t0.tax_display_type_id AS tax_display_type_id_26, t0.order_item_type_id AS order_item_type_id_27, t0.delivery_period_id AS delivery_period_id_28, t0.brother_id AS brother_id_29, t0.discriminator_type FROM dtb_order_item t0 WHERE t0.shipping_id = ? AND t0.discriminator_type IN ('orderitem')
Parameters: 
[
  23
]
View formatted query    View runnable query    Explain query
14 0.15 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.student_type AS student_type_26, t0.dr01 AS dr01_27, t0.dr02 AS dr02_28, t0.dr03 AS dr03_29, t0.dr04 AS dr04_30, t0.dr05 AS dr05_31, t0.dr11 AS dr11_32, t0.dr12 AS dr12_33, t0.dr13 AS dr13_34, t0.dr21 AS dr21_35, t0.dr22 AS dr22_36, t0.dr31 AS dr31_37, t0.dr32 AS dr32_38, t0.dr41 AS dr41_39, t0.dr42 AS dr42_40, t0.dr43 AS dr43_41, t0.examno AS examno_42, t0.zip01 AS zip01_43, t0.zip02 AS zip02_44, t0.tel01 AS tel01_45, t0.tel02 AS tel02_46, t0.tel03 AS tel03_47, t0.fax01 AS fax01_48, t0.fax02 AS fax02_49, t0.fax03 AS fax03_50, t0.prev_school AS prev_school_51, t0.tel0201 AS tel0201_52, t0.tel2_02 AS tel2_02_53, t0.tel2_03 AS tel2_03_54, t0.admission_year AS admission_year_55, t0.school_year AS school_year_56, t0.hissu_flg AS hissu_flg_57, t0.prev_school_year AS prev_school_year_58, t0.prev_school_class AS prev_school_class_59, t0.contractor_name01 AS contractor_name01_60, t0.contractor_name02 AS contractor_name02_61, t0.contractor_birth AS contractor_birth_62, t0.school_class AS school_class_63, t0.student_number AS student_number_64, t0.free1 AS free1_65, t0.free2 AS free2_66, t0.plg_mailmagazine_flg AS plg_mailmagazine_flg_67, t0.customer_status_id AS customer_status_id_68, t0.sex_id AS sex_id_69, t0.job_id AS job_id_70, t0.country_id AS country_id_71, t0.pref_id AS pref_id_72, t0.school_id AS school_id_73, t0.customer_address_id AS customer_address_id_74, t0.discriminator_type FROM dtb_customer t0 WHERE t0.id = ? AND t0.discriminator_type IN ('customer')
Parameters: 
[
  13
]
View formatted query    View runnable query    Explain query
15 0.22 ms 
SELECT t0.school_id AS school_id_1, t0.school_name AS school_name_2, t0.school_kana AS school_kana_3, t0.school_order AS school_order_4, t0.customer_selfdel_flg AS customer_selfdel_flg_5, t0.school_email AS school_email_6, t0.target_student AS target_student_7, t0.online_flag AS online_flag_8, t0.school_measuring_flag AS school_measuring_flag_9, t0.store_measuring_flag AS store_measuring_flag_10, t0.online_order_deadline AS online_order_deadline_11, t0.school_measuring_date AS school_measuring_date_12, t0.store_measuring_deadline AS store_measuring_deadline_13, t0.purchase_flag AS purchase_flag_14, t0.online_order_start_date AS online_order_start_date_15, t0.online_order_end_date AS online_order_end_date_16, t0.members_registration_type AS members_registration_type_17, t0.school_key AS school_key_18, t0.visible_school_key AS visible_school_key_19, t0.create_date AS create_date_20, t0.update_date AS update_date_21, t0.school_code AS school_code_22, t0.entry_url AS entry_url_23, t0.delivery_free_type AS delivery_free_type_24, t0.delivery_free_amount AS delivery_free_amount_25, t0.delivery_free_quantity AS delivery_free_quantity_26, t0.measure_plugin_type AS measure_plugin_type_27, t0.default_sex_products_filtering_flag AS default_sex_products_filtering_flag_28, t0.measuring_registration_required_flag AS measuring_registration_required_flag_29, t0.top_page_popup_flag AS top_page_popup_flag_30, t0.reg_data_popup_flag AS reg_data_popup_flag_31, t0.chat_bot_flag AS chat_bot_flag_32, t0.measuring_data_confirmation_flag AS measuring_data_confirmation_flag_33, t0.size_recommend_flag AS size_recommend_flag_34, t0.item_visible_type AS item_visible_type_35, t0.sale_start_date AS sale_start_date_36, t0.sale_end_date AS sale_end_date_37, t0.reservation_site_url AS reservation_site_url_38, t0.name_notation AS name_notation_39, t0.name01_entry_sample AS name01_entry_sample_40, t0.name02_entry_sample AS name02_entry_sample_41, t0.kana_notation AS kana_notation_42, t0.kana01_entry_sample AS kana01_entry_sample_43, t0.kana02_entry_sample AS kana02_entry_sample_44, t0.name_visible_type AS name_visible_type_45, t0.addr_notation AS addr_notation_46, t0.zip01_entry_sample AS zip01_entry_sample_47, t0.zip02_entry_sample AS zip02_entry_sample_48, t0.addr01_entry_sample AS addr01_entry_sample_49, t0.addr02_entry_sample AS addr02_entry_sample_50, t0.addr_visible_type AS addr_visible_type_51, t0.addr_visible_all AS addr_visible_all_52, t0.tel_notation AS tel_notation_53, t0.tel1_01_entry_sample AS tel1_01_entry_sample_54, t0.tel1_02_entry_sample AS tel1_02_entry_sample_55, t0.tel1_03_entry_sample AS tel1_03_entry_sample_56, t0.tel01_visible_type AS tel01_visible_type_57, t0.tel02_visible_type AS tel02_visible_type_58, t0.tel2_notation AS tel2_notation_59, t0.tel2_01_entry_sample AS tel2_01_entry_sample_60, t0.tel2_02_entry_sample AS tel2_02_entry_sample_61, t0.tel2_03_entry_sample AS tel2_03_entry_sample_62, t0.email_notation AS email_notation_63, t0.email_entry_sample AS email_entry_sample_64, t0.email_visible_type AS email_visible_type_65, t0.password_notation AS password_notation_66, t0.password_entry_sample AS password_entry_sample_67, t0.password_visible_type AS password_visible_type_68, t0.adyear_visible_type AS adyear_visible_type_69, t0.adyear_notation AS adyear_notation_70, t0.adyear_entry_sample AS adyear_entry_sample_71, t0.exam_number_visible_type AS exam_number_visible_type_72, t0.exam_number_notation AS exam_number_notation_73, t0.exam_number_entry_sample AS exam_number_entry_sample_74, t0.prev_school_visible_type AS prev_school_visible_type_75, t0.prev_school_notation AS prev_school_notation_76, t0.prev_school_entry_sample AS prev_school_entry_sample_77, t0.prev_year_class_visible_type AS prev_year_class_visible_type_78, t0.prev_year_class_notation AS prev_year_class_notation_79, t0.prev_year_entry_sample AS prev_year_entry_sample_80, t0.prev_class_entry_sample AS prev_class_entry_sample_81, t0.birth_visible_type AS birth_visible_type_82, t0.birth_notation AS birth_notation_83, t0.birth_entry_sample AS birth_entry_sample_84, t0.parents_name_visible_type AS parents_name_visible_type_85, t0.parents_name_notation AS parents_name_notation_86, t0.parents_name01_entry_sample AS parents_name01_entry_sample_87, t0.parents_name02_entry_sample AS parents_name02_entry_sample_88, t0.parents_birth_visible_type AS parents_birth_visible_type_89, t0.parents_birth_notation AS parents_birth_notation_90, t0.parents_birth_entry_sample AS parents_birth_entry_sample_91, t0.current_year_visible_type AS current_year_visible_type_92, t0.current_year_class_notation AS current_year_class_notation_93, t0.current_year_entry_sample AS current_year_entry_sample_94, t0.current_class_notation AS current_class_notation_95, t0.student_number_visible_type AS student_number_visible_type_96, t0.student_number_notation AS student_number_notation_97, t0.student_number_entry_sample AS student_number_entry_sample_98, t0.freeitem1_visible_type AS freeitem1_visible_type_99, t0.freeitem1_name AS freeitem1_name_100, t0.freeitem1_notation AS freeitem1_notation_101, t0.freeitem1_entry_sample AS freeitem1_entry_sample_102, t0.freeitem2_visible_type AS freeitem2_visible_type_103, t0.freeitem2_name AS freeitem2_name_104, t0.freeitem2_notation AS freeitem2_notation_105, t0.freeitem2_entry_sample AS freeitem2_entry_sample_106, t0.sex_visible_type AS sex_visible_type_107, t0.fax_visible_type AS fax_visible_type_108, t0.measure_height_visible_type AS measure_height_visible_type_109, t0.measure_weight_visible_type AS measure_weight_visible_type_110, t0.measure_shoulder_visible_type AS measure_shoulder_visible_type_111, t0.measure_sleeve1_visible_type AS measure_sleeve1_visible_type_112, t0.measure_sleeve2_visible_type AS measure_sleeve2_visible_type_113, t0.measure_total_visible_type AS measure_total_visible_type_114, t0.measure_neck_visible_type AS measure_neck_visible_type_115, t0.measure_bust_visible_type AS measure_bust_visible_type_116, t0.measure_waist_visible_type AS measure_waist_visible_type_117, t0.measure_hips_visible_type AS measure_hips_visible_type_118, t0.measure_inseam_visible_type AS measure_inseam_visible_type_119, t0.measure_skirt_visible_type AS measure_skirt_visible_type_120, t0.measure_slacks_visible_type AS measure_slacks_visible_type_121, t0.enter_year_class AS enter_year_class_122, t0.visible_commodity_alert AS visible_commodity_alert_123, t0.visible_flg AS visible_flg_124, t0.brother_flg AS brother_flg_125, t0.require_school_key AS require_school_key_126, t0.require_brothers AS require_brothers_127, t0.product_sexvisible_type AS product_sexvisible_type_128, t0.report_measure_flag AS report_measure_flag_129, t0.report_grade_flag AS report_grade_flag_130, t0.report_class_flag AS report_class_flag_131, t0.report_storemail_flag AS report_storemail_flag_132, t0.report_tax_flag AS report_tax_flag_133, t0.order_delivery_notation AS order_delivery_notation_134, t0.order_payment_notation AS order_payment_notation_135, t0.addr01_max_length AS addr01_max_length_136, t0.addr02_max_length AS addr02_max_length_137, t0.recommend_id AS recommend_id_138, t0.discriminator_type FROM dtb_school t0 WHERE t0.school_id = ? AND t0.discriminator_type IN ('school')
Parameters: 
[
  1
]
View formatted query    View runnable query    Explain query
16 0.91 ms 
INSERT INTO dtb_mail_history (send_date, mail_subject, mail_body, mail_html_body, order_id, creator_id, discriminator_type) VALUES (?, ?, ?, ?, ?, ?, ?)
Parameters: 
[
  "2025-03-15 06:55:05"
  "[mito uniform] 商品を発送いたしました。"
  """
    出荷お知らせメールです。\n
    \n
    --------------------\n
    藤田 昊希 様\n
    \n
    mito uniformでございます。\n
    お客様が注文された以下の商品を発送いたしました。商品の到着まで、今しばらくお待ちください。\n
    \n
    ************************************************\n
    　ご請求金額\n
    ************************************************\n
    \n
    ご注文番号：22\n
    お支払い合計：￥49,150\n
    お支払い方法：クレジットカード決済（ソニーペイメント）\n
    \n
    ************************************************\n
    　ご注文商品明細\n
    ************************************************\n
    \n
    商品コード: \n
    商品名: 男性用ジャケット  M  \n
    単価： ￥25,600\n
    数量： 1\n
    \n
    商品コード: \n
    商品名: 男性用長袖シャツ  M  \n
    単価： ￥3,500\n
    数量： 1\n
    \n
    商品コード: \n
    商品名: 男性用半袖ポロシャツ  M  \n
    単価： ￥4,400\n
    数量： 1\n
    \n
    商品コード: \n
    商品名: スラックス  ウエスト：70  \n
    単価： ￥12,300\n
    数量： 1\n
    \n
    商品コード: \n
    商品名: ネクタイ（細目・短め）    \n
    単価： ￥2,400\n
    数量： 1\n
    \n
    商品コード: \n
    商品名: 手数料    \n
    単価： ￥0\n
    数量： 1\n
    \n
    商品コード: \n
    商品名: 送料    \n
    単価： ￥950\n
    数量： 1\n
    \n
    \n
    -------------------------------------------------\n
    小　計 ￥48,200　送　料 ￥950\n
    ============================================\n
    合　計 ￥49,150\n
    \n
    ************************************************\n
    　ご注文者情報\n
    ************************************************\n
    お名前　：藤田 昊希 様\n
    フリガナ：フジタ コウキ 様\n
    電話番号：08038367661\n
    メールアドレス：yukie4777@icloud.com\n
    所属：\n
    \n
    ************************************************\n
    　配送情報\n
    ************************************************\n
    \n
    ◎お届け先【ご指定の住所に配送：新入生】\n
    \n
    商品名: 男性用ジャケット  M  \n
    数量：1\n
    \n
    商品名: 男性用長袖シャツ  M  \n
    数量：1\n
    \n
    商品名: 男性用半袖ポロシャツ  M  \n
    数量：1\n
    \n
    商品名: スラックス  ウエスト：70  \n
    数量：1\n
    \n
    商品名: ネクタイ（細目・短め）    \n
    数量：1\n
    \n
    \n
    ＜商品のお届けについて＞\n
    お買い物ガイドの\n
    【商品のお届けについて】https://mu-ecshop.com/help/guide#guide_05\n
    をご参照ください。\n
    \n
    ================================================\n
    本メールは自動配信メールです。\n
    このメッセージへの返信としてご質問をお送りいただいても\n
    内容の確認およびご返答ができませんので、ご了承ください。\n
    \n
    ご質問やご不明な点がございましたら、下記までお願いいたします。\n
    -------------------------------------------------\n
    「mito uniform」\n
    ■URL：https://mu-ecshop.com/\n
    ■メールアドレス：inquiry@mu-ecshop.com\n
    ■電話番号：0757818360(受付:９時～１８時（日・祝 休み）)\n
    -------------------------------------------------\n
    """
  null
  22
  15
  "mailhistory"
]
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\Order 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.
Customize\Entity\ProductStore No errors.
Eccube\Entity\Product
  • The field Eccube\Entity\Product#ProductSchool is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity Customize\Entity\ProductSchool#Product does not contain the required 'inversedBy="ProductSchool"' attribute.
  • The field Eccube\Entity\Product#ProductStore is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity Customize\Entity\ProductStore#Product does not contain the required 'inversedBy="ProductStore"' attribute.
Customize\Entity\SetProductSchool No errors.
Customize\Entity\ProductSchool 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.
Customize\Entity\Store No errors.
Eccube\Entity\Master\Country No errors.
Eccube\Entity\Master\Pref No errors.
Eccube\Entity\MailTemplate No errors.
Eccube\Entity\MailHistory No errors.
Customize\Entity\School
  • The field Customize\Entity\School#SchoolDelivery is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity Customize\Entity\SchoolDelivery#School does not contain the required 'inversedBy="SchoolDelivery"' attribute.
Eccube\Entity\OrderItem No errors.
Eccube\Entity\Category No errors.
Eccube\Entity\Delivery No errors.
Eccube\Entity\Shipping No errors.
Eccube\Entity\ProductStock No errors.
Eccube\Entity\Master\OrderStatus No errors.
Eccube\Entity\OrderPdf No errors.
Eccube\Entity\ProductClass No errors.
Eccube\Entity\Master\OrderItemType No errors.
Eccube\Entity\Payment No errors.
Customize\Entity\SetProduct
  • The field Customize\Entity\SetProduct#SetProductImage is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity Customize\Entity\SetProductImage#SetProduct does not contain the required 'inversedBy="SetProductImage"' attribute.
  • The field Customize\Entity\SetProduct#SetProductSchool is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity Customize\Entity\SetProductSchool#SetProduct does not contain the required 'inversedBy="SetProductSchool"' attribute.
  • The field Customize\Entity\SetProduct#SetProductProduct is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity Customize\Entity\SetProductProduct#SetProduct does not contain the required 'inversedBy="SetProductProduct"' attribute.
Customize\Entity\SetProductProduct No errors.
Customize\Entity\DeliveryPeriod No errors.
Eccube\Entity\DeliveryFee 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.
Eccube\Entity\Master\RoundingType No errors.
Eccube\Entity\Master\TaxType No errors.
Eccube\Entity\Master\TaxDisplayType No errors.
Customize\Entity\Brother No errors.
Eccube\Entity\Master\CustomerStatus No errors.
Eccube\Entity\CustomerAddress No errors.
Eccube\Entity\CustomerFavoriteProduct No errors.
Plugin\ContactManagement42\Entity\Contact No errors.
Customize\Entity\Recommend No errors.
Customize\Entity\SchoolDelivery No errors.
Eccube\Entity\Master\SaleType No errors.