Query Metrics
36
Database Queries
27
Different statements
28.94 ms
Query time
0
Invalid entities
Queries
| #▲ | Time | Info |
|---|---|---|
| 1 | 0.29 ms |
SET SESSION time_zone = '+00:00'
Parameters:
[] |
| 2 | 0.14 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:
[ "motto" 1 ] |
| 3 | 0.14 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
]
|
| 4 | 0.17 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.country_id AS country_id_35, t0.pref_id AS pref_id_36, t0.discriminator_type FROM dtb_base_info t0 WHERE t0.id = ? AND t0.discriminator_type IN ('baseinfo')
Parameters:
[
1
]
|
| 5 | 0.10 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
]
|
| 6 | 0.13 ms |
SET SESSION TRANSACTION ISOLATION LEVEL READ COMMITTED
Parameters:
[] |
| 7 | 0.06 ms |
"START TRANSACTION"
Parameters:
[] |
| 8 | 0.59 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.add_point AS add_point_32, t0.use_point AS use_point_33, t0.customer_id AS customer_id_34, t0.country_id AS country_id_35, t0.pref_id AS pref_id_36, t0.sex_id AS sex_id_37, t0.job_id AS job_id_38, t0.payment_id AS payment_id_39, t0.device_type_id AS device_type_id_40, t0.order_status_id AS order_status_id_41, t0.order_status_id AS order_status_id_42, t0.order_status_id AS order_status_id_43, t0.discriminator_type FROM dtb_order t0 WHERE t0.pre_order_id = ? AND t0.discriminator_type IN ('order') LIMIT 1
Parameters:
[
"db72780acfba3bbb127ba0e7078fec9f6078ef66"
]
|
| 9 | 0.17 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:
[
"32"
]
|
| 10 | 0.11 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:
[
"4"
]
|
| 11 | 0.15 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.sort_no AS sort_no_3, t0.discriminator_type FROM mtb_order_item_type t0 WHERE t0.id = ? AND t0.discriminator_type IN ('orderitemtype')
Parameters:
[
"1"
]
|
| 12 | 0.08 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.sort_no AS sort_no_3, t0.discriminator_type FROM mtb_tax_type t0 WHERE t0.id = ? AND t0.discriminator_type IN ('taxtype')
Parameters:
[
"1"
]
|
| 13 | 0.12 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.deliveryplus_weight AS deliveryplus_weight_14, t0.deliveryplus_size AS deliveryplus_size_15, t0.product_id AS product_id_16, t0.sale_type_id AS sale_type_id_17, t0.class_category_id1 AS class_category_id1_18, t0.class_category_id2 AS class_category_id2_19, t0.delivery_duration_id AS delivery_duration_id_20, t0.creator_id AS creator_id_21, t0.discriminator_type FROM dtb_product_class t0 WHERE t0.id = ? AND t0.discriminator_type IN ('productclass')
Parameters:
[
"68"
]
|
| 14 | 0.09 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:
[
68
]
|
| 15 | 0.11 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:
[
68
]
|
| 16 | 0.61 ms |
SELECT d0_.id AS id_0, d0_.tax_rate AS tax_rate_1, d0_.tax_adjust AS tax_adjust_2, d0_.apply_date AS apply_date_3, d0_.create_date AS create_date_4, d0_.update_date AS update_date_5, d0_.discriminator_type AS discriminator_type_6, d0_.product_class_id AS product_class_id_7, d0_.creator_id AS creator_id_8, d0_.country_id AS country_id_9, d0_.pref_id AS pref_id_10, d0_.product_id AS product_id_11, d0_.rounding_type_id AS rounding_type_id_12 FROM dtb_tax_rule d0_ WHERE (d0_.apply_date < ? AND d0_.pref_id IS NULL AND d0_.country_id IS NULL AND (d0_.product_id IS NULL OR d0_.product_id = ?) AND (d0_.product_class_id IS NULL OR d0_.product_class_id = ?)) AND d0_.discriminator_type IN ('taxrule') ORDER BY d0_.apply_date DESC
Parameters:
[ "2025-01-21 03:49:34" 59 68 ] |
| 17 | 0.10 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.deliveryplus_weight AS deliveryplus_weight_14, t0.deliveryplus_size AS deliveryplus_size_15, t0.product_id AS product_id_16, t0.sale_type_id AS sale_type_id_17, t0.class_category_id1 AS class_category_id1_18, t0.class_category_id2 AS class_category_id2_19, t0.delivery_duration_id AS delivery_duration_id_20, t0.creator_id AS creator_id_21, t0.discriminator_type FROM dtb_product_class t0 WHERE t0.id = ? AND t0.discriminator_type IN ('productclass')
Parameters:
[
"28"
]
|
| 18 | 0.10 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:
[
28
]
|
| 19 | 0.12 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:
[
28
]
|
| 20 | 0.31 ms |
SELECT d0_.id AS id_0, d0_.tax_rate AS tax_rate_1, d0_.tax_adjust AS tax_adjust_2, d0_.apply_date AS apply_date_3, d0_.create_date AS create_date_4, d0_.update_date AS update_date_5, d0_.discriminator_type AS discriminator_type_6, d0_.product_class_id AS product_class_id_7, d0_.creator_id AS creator_id_8, d0_.country_id AS country_id_9, d0_.pref_id AS pref_id_10, d0_.product_id AS product_id_11, d0_.rounding_type_id AS rounding_type_id_12 FROM dtb_tax_rule d0_ WHERE (d0_.apply_date < ? AND d0_.pref_id IS NULL AND d0_.country_id IS NULL AND (d0_.product_id IS NULL OR d0_.product_id = ?) AND (d0_.product_class_id IS NULL OR d0_.product_class_id = ?)) AND d0_.discriminator_type IN ('taxrule') ORDER BY d0_.apply_date DESC
Parameters:
[ "2025-01-21 03:49:34" 19 28 ] |
| 21 | 0.16 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.deliveryplus_weight_min AS deliveryplus_weight_min_10, t0.deliveryplus_weight_max AS deliveryplus_weight_max_11, t0.deliveryplus_size_min AS deliveryplus_size_min_12, t0.deliveryplus_size_max AS deliveryplus_size_max_13, t0.deliveryplus_subtotal_min AS deliveryplus_subtotal_min_14, t0.deliveryplus_subtotal_max AS deliveryplus_subtotal_max_15, t0.creator_id AS creator_id_16, t0.sale_type_id AS sale_type_id_17, t0.discriminator_type FROM dtb_delivery t0 WHERE t0.id = ? AND t0.discriminator_type IN ('delivery')
Parameters:
[
"3"
]
|
| 22 | 0.15 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:
[
"32"
]
|
| 23 | 0.13 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_.deliveryplus_weight_min AS deliveryplus_weight_min_9, d0_.deliveryplus_weight_max AS deliveryplus_weight_max_10, d0_.deliveryplus_size_min AS deliveryplus_size_min_11, d0_.deliveryplus_size_max AS deliveryplus_size_max_12, d0_.deliveryplus_subtotal_min AS deliveryplus_subtotal_min_13, d0_.deliveryplus_subtotal_max AS deliveryplus_subtotal_max_14, d0_.discriminator_type AS discriminator_type_15, d0_.creator_id AS creator_id_16, d0_.sale_type_id AS sale_type_id_17 FROM dtb_delivery d0_ WHERE (d0_.id IN (?)) AND d0_.discriminator_type IN ('delivery') ORDER BY d0_.visible DESC, d0_.sort_no ASC
Parameters:
[
"3"
]
|
| 24 | 0.43 ms |
SELECT d0_.id AS id_0, d0_.delivery_time AS delivery_time_1, d0_.sort_no AS sort_no_2, d0_.visible AS visible_3, d0_.create_date AS create_date_4, d0_.update_date AS update_date_5, d0_.discriminator_type AS discriminator_type_6, d0_.delivery_id AS delivery_id_7 FROM dtb_delivery_time d0_ WHERE (d0_.delivery_id = ? AND d0_.id IN (?)) AND d0_.discriminator_type IN ('deliverytime')
Parameters:
[ 3 "7" ] |
| 25 | 0.22 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.id = ? AND t0.discriminator_type IN ('orderstatus')
Parameters:
[
1
]
|
| 26 | 0.11 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.sort_no AS sort_no_3, t0.discriminator_type FROM mtb_tax_display_type t0 WHERE t0.id = ? AND t0.discriminator_type IN ('taxdisplaytype')
Parameters:
[
1
]
|
| 27 | 2.38 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:
[
"db72780acfba3bbb127ba0e7078fec9f6078ef66"
]
|
| 28 | 1.63 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:
[
"db72780acfba3bbb127ba0e7078fec9f6078ef66"
]
|
| 29 | 0.09 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:
[
"db72780acfba3bbb127ba0e7078fec9f6078ef66"
]
|
| 30 | 13.22 ms |
INSERT INTO dtb_order (pre_order_id, order_no, message, name01, name02, kana01, kana02, company_name, email, phone_number, postal_code, addr01, addr02, birth, subtotal, discount, delivery_fee_total, charge, tax, total, payment_total, payment_method, note, create_date, update_date, order_date, payment_date, currency_code, complete_message, complete_mail_message, add_point, use_point, customer_id, country_id, pref_id, sex_id, job_id, payment_id, device_type_id, order_status_id, discriminator_type) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[ "db72780acfba3bbb127ba0e7078fec9f6078ef66" null null "岩佐" "由美子" "イワサ" "ユミコ" null "kanri@kaorime.co.jp" "09038813127" "6990101" "松江市東出雲町揖屋" "2510-32" null 2484.0 0 0 0 184.0 2484.0 2484.0 "代金引換" "20240111新聞広告から電話注文" "2025-01-21 03:49:34" "2025-01-21 03:49:34" "2025-01-21 03:49:34" null "JPY" null null "0" 0.0 null null 32 null null 4 null 1 "order" ] |
| 31 | 0.71 ms |
INSERT INTO dtb_shipping (name01, name02, kana01, kana02, company_name, phone_number, postal_code, addr01, addr02, delivery_name, time_id, delivery_time, delivery_date, shipping_date, tracking_number, note, sort_no, create_date, update_date, mail_send_date, order_id, country_id, pref_id, delivery_id, creator_id, discriminator_type) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[ "岩佐" "由美子" "イワサ" "ユミコ" null "09038813127" "6990101" "松江市東出雲町揖屋" "2510-32" "佐川急便" 7 "18時～20時" null null null null null "2025-01-21 03:49:34" "2025-01-21 03:49:34" null 373 null 32 3 1 "shipping" ] |
| 32 | 2.33 ms |
INSERT INTO dtb_order_item (product_name, product_code, class_name1, class_name2, class_category_name1, class_category_name2, price, quantity, tax, tax_rate, tax_adjust, tax_rule_id, currency_code, processor_name, point_rate, order_id, product_id, product_class_id, shipping_id, rounding_type_id, tax_type_id, tax_display_type_id, order_item_type_id, discriminator_type) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[ "【お徳用】しそ入りひじきふりかけ130g×2個" "05010331" null null null null 1000 2 80.0 8 "0" null "JPY" null "1" 373 59 68 378 2 1 1 1 "orderitem" ] |
| 33 | 0.17 ms |
INSERT INTO dtb_order_item (product_name, product_code, class_name1, class_name2, class_category_name1, class_category_name2, price, quantity, tax, tax_rate, tax_adjust, tax_rule_id, currency_code, processor_name, point_rate, order_id, product_id, product_class_id, shipping_id, rounding_type_id, tax_type_id, tax_display_type_id, order_item_type_id, discriminator_type) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[ "がごめ昆布入りわかめスープ 4ｇ×8パック入" "151044" null null null null 300 1 24.0 8 "0" null "JPY" null "1" 373 19 28 378 2 1 1 1 "orderitem" ] |
| 34 | 0.33 ms |
UPDATE dtb_order SET order_no = ?, update_date = ? WHERE id = ?
Parameters:
[ 373 "2025-01-21 03:49:34" 373 ] |
| 35 | 0.31 ms |
SELECT t0.order_id AS order_id_1, t0.memo01 AS memo01_2, t0.memo02 AS memo02_3, t0.memo03 AS memo03_4, t0.memo04 AS memo04_5, t0.memo05 AS memo05_6, t0.memo06 AS memo06_7, t0.memo07 AS memo07_8, t0.memo08 AS memo08_9, t0.memo09 AS memo09_10, t0.memo10 AS memo10_11, t0.rollback_date AS rollback_date_12 FROM plg_vt4g_order_payment t0 WHERE t0.order_id = ?
Parameters:
[
373
]
|
| 36 | 2.86 ms |
SELECT t0.payment_id AS payment_id_1, t0.payment_method AS payment_method_2, t0.del_flg AS del_flg_3, t0.create_date AS create_date_4, t0.update_date AS update_date_5, t0.memo01 AS memo01_6, t0.memo02 AS memo02_7, t0.memo03 AS memo03_8, t0.memo04 AS memo04_9, t0.memo05 AS memo05_10, t0.memo06 AS memo06_11, t0.memo07 AS memo07_12, t0.memo08 AS memo08_13, t0.memo09 AS memo09_14, t0.memo10 AS memo10_15, t0.plugin_code AS plugin_code_16, t0.payment_id AS payment_id_17 FROM plg_vt4g_payment_method t0 WHERE t0.payment_id = ?
Parameters:
[
4
]
|
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. |
| 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\Category | No errors. |
| Eccube\Entity\Order | No errors. |
| Eccube\Entity\Customer | No errors. |
| Eccube\Entity\Delivery | No errors. |
| Eccube\Entity\ProductClass | No errors. |
| 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. |
| Eccube\Entity\Master\OrderStatus | No errors. |
| Eccube\Entity\Payment | No errors. |
| Eccube\Entity\ProductStock | 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\DeliveryTime | No errors. |
| Eccube\Entity\Master\SaleType | No errors. |
| Eccube\Entity\Shipping | No errors. |
| Eccube\Entity\PaymentOption | No errors. |
| Eccube\Entity\TaxRule | No errors. |
| Eccube\Entity\ClassCategory | No errors. |
| Eccube\Entity\DeliveryDuration | No errors. |
| Eccube\Entity\Master\RoundingType | No errors. |
| Eccube\Entity\DeliveryFee | No errors. |
| Eccube\Entity\MailHistory | No errors. |
| Eccube\Entity\ClassName | No errors. |
| Eccube\Entity\Master\ProductStatus | No errors. |
| Eccube\Entity\Master\CustomerStatus | No errors. |
| Plugin\VeriTrans4G2\Entity\Vt4gOrderPayment | No errors. |
| Plugin\VeriTrans4G2\Entity\Vt4gPaymentMethod | No errors. |