https://iseya-mizunasu.jp/isyecshops23/order/6350/mail Return to referer URL

Method
POST
HTTP Status
302
IP
122.18.150.178
Profiled on
Token
b53946

Query Metrics

11 Database Queries
10 Different statements
6.80 ms Query time
0 Invalid entities

Queries

Group similar statements

#▲ Time Info
1 0.29 ms 
SET SESSION time_zone = '+00:00'
Parameters: 
[]
View formatted query    View runnable query    Explain query
2 0.66 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: 
[
  "isey9336"
  1
]
View formatted query    View runnable query    Explain query
3 0.57 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: 
[
  0
]
View formatted query    View runnable query    Explain query
4 0.78 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
5 0.51 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: 
[
  0
]
View formatted query    View runnable query    Explain query
6 0.33 ms 
SET SESSION TRANSACTION ISOLATION LEVEL READ COMMITTED
Parameters: 
[]
View formatted query    View runnable query    Explain query
7 0.30 ms 
"START TRANSACTION"
Parameters: 
[]
View formatted query    View runnable query    Explain query
8 1.02 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.univa_pay_charge_id AS univa_pay_charge_id_32, t0.univa_pay_subscription_id AS univa_pay_subscription_id_33, t0.univa_pay_charge_amount AS univa_pay_charge_amount_34, t0.add_point AS add_point_35, t0.use_point AS use_point_36, t0.customer_id AS customer_id_37, t0.country_id AS country_id_38, t0.pref_id AS pref_id_39, t0.sex_id AS sex_id_40, t0.job_id AS job_id_41, t0.payment_id AS payment_id_42, t0.device_type_id AS device_type_id_43, t0.order_status_id AS order_status_id_44, t0.order_status_id AS order_status_id_45, t0.order_status_id AS order_status_id_46, t0.discriminator_type FROM dtb_order t0 WHERE t0.id = ? AND t0.discriminator_type IN ('order')
Parameters: 
[
  "6350"
]
View formatted query    View runnable query    Explain query
9 0.87 ms 
SELECT t0.id AS id_1, t0.send_date AS send_date_2, t0.mail_subject AS mail_subject_3, t0.mail_body AS mail_body_4, t0.mail_html_body AS mail_html_body_5, t0.order_id AS order_id_6, t0.creator_id AS creator_id_7, t0.discriminator_type FROM dtb_mail_history t0 WHERE t0.order_id = ? AND t0.discriminator_type IN ('mailhistory')
Parameters: 
[
  6350
]
View formatted query    View runnable query    Explain query
10 0.61 ms 
SELECT d0_.id AS id_0, d0_.name AS name_1, d0_.file_name AS file_name_2, d0_.mail_subject AS mail_subject_3, d0_.create_date AS create_date_4, d0_.update_date AS update_date_5, d0_.discriminator_type AS discriminator_type_6, d0_.creator_id AS creator_id_7 FROM dtb_mail_template d0_ WHERE (d0_.id IN (?)) AND d0_.discriminator_type IN ('mailtemplate') ORDER BY d0_.id ASC
Parameters: 
[
  "8"
]
View formatted query    View runnable query    Explain query
11 0.87 ms 
INSERT INTO dtb_mail_history (send_date, mail_subject, mail_body, mail_html_body, order_id, creator_id, discriminator_type) VALUES (?, ?, ?, ?, ?, ?, ?)
Parameters: 
[
  "2025-07-28 04:22:23"
  "[水なす漬　いせや　|　ダイワフード株式会社] 商品出荷のお知らせ"
  """
    中川 正 様\r\n
    \r\n
    お客さまがご注文された以下の商品を発送いたしました。商品の到着まで、今しばらくお待ちください。\r\n
    \r\n
    送り状番号：4406-8906-0066\r\n
    ************************************************\r\n
    　ご注文商品明細\r\n
    ************************************************\r\n
    商品コード：A3-1\r\n
    商品名：水なすぬか漬　7袋    \r\n
    数量：1\r\n
    ============================================\r\n
    小　計：￥4,428\r\n
    手数料：￥0\r\n
    送　料：￥0\r\n
    -------------------------------------------------\r\n
    合　計：￥4,428\r\n
    ============================================\r\n
    お支払い合計：￥4,428\r\n
        (8 %対象：￥4,428 内消費税：￥328)\r\n
        \r\n
    ************************************************\r\n
    　ご注文者情報\r\n
    ************************************************\r\n
    お名前：中川 正 様\r\n
    お名前(カナ)：ナカガワ タダシ 様\r\n
    会社名：合同会社TMK環境\r\n
    郵便番号：〒5580013\r\n
    住所：大阪府大阪市住吉区我孫子東3丁目13番3－1401\r\n
    電話番号：09067522914\r\n
    \r\n
    ************************************************\r\n
    　配送情報\r\n
    ************************************************\r\n
    お名前：岡田 準也 様\r\n
    お名前(カナ)：オカダ ジュンヤ 様\r\n
    会社名：岡田建鋼株式会社\r\n
    郵便番号：〒6392344\r\n
    住所：奈良県御所市東佐味232-3\r\n
    電話番号：0745662101\r\n
    \r\n
    配送方法：ヤマト運輸\r\n
    お届け日：2025/07/28\r\n
    お届け時間：14時～16時\r\n
    \r\n
    のし：希望する\r\n
    のしの種類：紅白蝶結び表書き（上段）：御中元\r\n
    表書き[その他]：合同会社TMK環境お名前（下段）：なし\r\n
    --------------------------------------------------\r\n
    このメールは、配信専用のアドレスで配信されています。\r\n
    お手数をお掛けいたしますが、このメールの内容についてのお問い合わせは\r\n
    下記の連絡先までお願いいたします。\r\n
    \r\n
    泉州水なす漬利休の郷いせや\r\n
    https://iseya-mizunasu.jp/\r\n
    \r\n
    〒590-0024\r\n
    大阪府堺市堺区向陵中町1-1-1\r\n
    お問い合わせ窓口\r\n
    Email: webshop@daiwafood.co.jp\r\n
    TEL　: 072-255-1611 ( 9:00 - 17:00 日曜定休)
    """
  null
  6350
  2
  "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\Product No errors.
Plugin\OrderStatusEx\Entity\OrderStatusEx 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.
Eccube\Entity\Master\Country No errors.
Eccube\Entity\Master\Pref No errors.
Eccube\Entity\MailTemplate No errors.
Eccube\Entity\MailHistory No errors.
Eccube\Entity\Order No errors.
Eccube\Entity\Customer No errors.
Eccube\Entity\Master\Sex No errors.
Eccube\Entity\Master\Job No errors.
Eccube\Entity\Payment No errors.
Eccube\Entity\Master\CustomerOrderStatus No errors.
Eccube\Entity\Master\OrderStatusColor No errors.
Eccube\Entity\Master\OrderStatus No errors.
Eccube\Entity\OrderItem No errors.
Eccube\Entity\Shipping No errors.
Eccube\Entity\Master\CustomerStatus No errors.