Query Metrics
16
Database Queries
15
Different statements
3.12 ms
Query time
4
Invalid entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
0.91 ms (29.23%) |
1 |
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" ] |
|
0.27 ms (8.56%) |
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.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"
]
|
|
0.22 ms (7.06%) |
1 |
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
]
|
|
0.20 ms (6.45%) |
2 |
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
]
|
|
0.19 ms (6.07%) |
1 |
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
]
|
|
0.18 ms (5.90%) |
1 |
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
]
|
|
0.16 ms (5.10%) |
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.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
]
|
|
0.16 ms (5.07%) |
1 |
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"
]
|
|
0.15 ms (4.97%) |
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.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
]
|
|
0.14 ms (4.56%) |
1 |
SET SESSION time_zone = '+00:00'
Parameters:
[] |
|
0.13 ms (4.17%) |
1 |
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 ] |
|
0.13 ms (4.14%) |
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.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
]
|
|
0.13 ms (4.04%) |
1 |
SET SESSION TRANSACTION ISOLATION LEVEL READ COMMITTED
Parameters:
[] |
|
0.10 ms (3.08%) |
1 |
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
]
|
|
0.05 ms (1.61%) |
1 |
"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 |
|---|---|
| Eccube\Entity\AbstractEntity | No errors. |
| Eccube\Entity\Order | No errors. |
| Eccube\Entity\Customer |
|
| Customize\Entity\ProductStore | No errors. |
| Eccube\Entity\Product |
|
| 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 |
|
| 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 |
|
| 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. |