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

Query Metrics

27 Database Queries
17 Different statements
25.13 ms Query time
0 Invalid entities

Grouped Statements

Show all queries

Time Count Info
10.26 ms
(40.81%)
8
SELECT COALESCE(COUNT(d0_.id), 0) AS sclr_0 FROM dtb_order d0_ WHERE (d0_.order_status_id = ?) AND d0_.discriminator_type IN ('order')
Parameters:
[
  1
]
2.62 ms
(10.44%)
1
SELECT d0_.id AS id_0, d0_.pre_order_id AS pre_order_id_1, d0_.order_no AS order_no_2, d0_.message AS message_3, d0_.name01 AS name01_4, d0_.name02 AS name02_5, d0_.kana01 AS kana01_6, d0_.kana02 AS kana02_7, d0_.company_name AS company_name_8, d0_.email AS email_9, d0_.phone_number AS phone_number_10, d0_.postal_code AS postal_code_11, d0_.addr01 AS addr01_12, d0_.addr02 AS addr02_13, d0_.birth AS birth_14, d0_.subtotal AS subtotal_15, d0_.discount AS discount_16, d0_.delivery_fee_total AS delivery_fee_total_17, d0_.charge AS charge_18, d0_.tax AS tax_19, d0_.total AS total_20, d0_.payment_total AS payment_total_21, d0_.payment_method AS payment_method_22, d0_.note AS note_23, d0_.create_date AS create_date_24, d0_.update_date AS update_date_25, d0_.order_date AS order_date_26, d0_.payment_date AS payment_date_27, d0_.currency_code AS currency_code_28, d0_.complete_message AS complete_message_29, d0_.complete_mail_message AS complete_mail_message_30, d0_.univa_pay_charge_id AS univa_pay_charge_id_31, d0_.univa_pay_subscription_id AS univa_pay_subscription_id_32, d0_.univa_pay_charge_amount AS univa_pay_charge_amount_33, d0_.add_point AS add_point_34, d0_.use_point AS use_point_35, d1_.id AS id_36, d1_.product_name AS product_name_37, d1_.product_code AS product_code_38, d1_.class_name1 AS class_name1_39, d1_.class_name2 AS class_name2_40, d1_.class_category_name1 AS class_category_name1_41, d1_.class_category_name2 AS class_category_name2_42, d1_.price AS price_43, d1_.quantity AS quantity_44, d1_.tax AS tax_45, d1_.tax_rate AS tax_rate_46, d1_.tax_adjust AS tax_adjust_47, d1_.tax_rule_id AS tax_rule_id_48, d1_.currency_code AS currency_code_49, d1_.processor_name AS processor_name_50, d1_.point_rate AS point_rate_51, m2_.id AS id_52, m2_.name AS name_53, m2_.sort_no AS sort_no_54, d3_.id AS id_55, d3_.name01 AS name01_56, d3_.name02 AS name02_57, d3_.kana01 AS kana01_58, d3_.kana02 AS kana02_59, d3_.company_name AS company_name_60, d3_.phone_number AS phone_number_61, d3_.postal_code AS postal_code_62, d3_.addr01 AS addr01_63, d3_.addr02 AS addr02_64, d3_.delivery_name AS delivery_name_65, d3_.time_id AS time_id_66, d3_.delivery_time AS delivery_time_67, d3_.delivery_date AS delivery_date_68, d3_.shipping_date AS shipping_date_69, d3_.tracking_number AS tracking_number_70, d3_.note AS note_71, d3_.sort_no AS sort_no_72, d3_.create_date AS create_date_73, d3_.update_date AS update_date_74, d3_.mail_send_date AS mail_send_date_75, d3_.gp_title AS gp_title_76, d3_.gp_name AS gp_name_77, d0_.discriminator_type AS discriminator_type_78, d0_.customer_id AS customer_id_79, d0_.country_id AS country_id_80, d0_.pref_id AS pref_id_81, d0_.sex_id AS sex_id_82, d0_.job_id AS job_id_83, d0_.payment_id AS payment_id_84, d0_.device_type_id AS device_type_id_85, d0_.order_status_id AS order_status_id_86, d0_.order_status_id AS order_status_id_87, d0_.order_status_id AS order_status_id_88, d1_.discriminator_type AS discriminator_type_89, d1_.order_id AS order_id_90, d1_.product_id AS product_id_91, d1_.product_class_id AS product_class_id_92, d1_.shipping_id AS shipping_id_93, d1_.rounding_type_id AS rounding_type_id_94, d1_.tax_type_id AS tax_type_id_95, d1_.tax_display_type_id AS tax_display_type_id_96, d1_.order_item_type_id AS order_item_type_id_97, m2_.discriminator_type AS discriminator_type_98, d3_.discriminator_type AS discriminator_type_99, d3_.order_id AS order_id_100, d3_.country_id AS country_id_101, d3_.pref_id AS pref_id_102, d3_.delivery_id AS delivery_id_103, d3_.creator_id AS creator_id_104, d3_.gp_check AS gp_check_105, d3_.gp_tie AS gp_tie_106, d3_.gp_kind AS gp_kind_107 FROM dtb_order d0_ LEFT JOIN dtb_order_item d1_ ON d0_.id = d1_.order_id AND d1_.discriminator_type IN ('orderitem') LEFT JOIN mtb_pref m2_ ON d0_.pref_id = m2_.id AND m2_.discriminator_type IN ('pref') INNER JOIN dtb_shipping d3_ ON d0_.id = d3_.order_id AND d3_.discriminator_type IN ('shipping') WHERE (d0_.order_status_id IN (?) AND d0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)) AND d0_.discriminator_type IN ('order') ORDER BY d0_.update_date DESC, d0_.id DESC
Parameters:
[
  7
  5530
  5528
  5529
  5527
  5525
  5526
  5524
  5523
  5518
  5516
  5513
  5506
  5271
]
1.75 ms
(6.95%)
3
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:
[
  47
]
1.40 ms
(5.56%)
1
SELECT count(DISTINCT d0_.id) AS sclr_0 FROM dtb_order d0_ LEFT JOIN dtb_order_item d1_ ON d0_.id = d1_.order_id AND d1_.discriminator_type IN ('orderitem') LEFT JOIN mtb_pref m2_ ON d0_.pref_id = m2_.id AND m2_.discriminator_type IN ('pref') INNER JOIN dtb_shipping d3_ ON d0_.id = d3_.order_id AND d3_.discriminator_type IN ('shipping') WHERE (d0_.order_status_id IN (?)) AND d0_.discriminator_type IN ('order')
Parameters:
[
  7
]
1.12 ms
(4.47%)
1
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:
[]
1.11 ms
(4.43%)
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:
[
  0
]
1.08 ms
(4.28%)
1
SELECT DISTINCT d0_.id AS id_0, d0_.update_date AS update_date_1, d0_.id AS id_2 FROM dtb_order d0_ LEFT JOIN dtb_order_item d1_ ON d0_.id = d1_.order_id AND d1_.discriminator_type IN ('orderitem') LEFT JOIN mtb_pref m2_ ON d0_.pref_id = m2_.id AND m2_.discriminator_type IN ('pref') INNER JOIN dtb_shipping d3_ ON d0_.id = d3_.order_id AND d3_.discriminator_type IN ('shipping') WHERE (d0_.order_status_id IN (?)) AND d0_.discriminator_type IN ('order') ORDER BY d0_.update_date DESC, d0_.id DESC LIMIT 50
Parameters:
[
  7
]
0.80 ms
(3.19%)
1
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_.discriminator_type IN ('payment') ORDER BY d0_.sort_no DESC
Parameters:
[]
0.80 ms
(3.19%)
1
SELECT t0.id AS id_1, t0.name AS name_2, t0.sort_no AS sort_no_3, t0.discriminator_type FROM mtb_order_status_color t0 WHERE t0.id = ? AND t0.discriminator_type IN ('orderstatuscolor')
Parameters:
[
  7
]
0.70 ms
(2.80%)
1
SELECT m0_.display_order_count AS display_order_count_0, m0_.id AS id_1, m0_.name AS name_2, m0_.sort_no AS sort_no_3, m0_.discriminator_type AS discriminator_type_4 FROM mtb_order_status m0_ WHERE m0_.discriminator_type IN ('orderstatus') ORDER BY m0_.sort_no ASC
Parameters:
[]
0.69 ms
(2.74%)
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.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
]
0.66 ms
(2.64%)
1
SELECT t0.id AS id_1, t0.name AS name_2, t0.sort_no AS sort_no_3, t0.discriminator_type FROM mtb_page_max t0 WHERE t0.discriminator_type IN ('pagemax')
Parameters:
[]
0.59 ms
(2.34%)
1
SELECT m0_.display_order_count AS display_order_count_0, m0_.id AS id_1, m0_.name AS name_2, m0_.sort_no AS sort_no_3, m0_.discriminator_type AS discriminator_type_4 FROM mtb_order_status m0_ WHERE (m0_.id IN (?)) AND m0_.discriminator_type IN ('orderstatus') ORDER BY m0_.sort_no ASC
Parameters:
[
  "7"
]
0.54 ms
(2.14%)
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.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
]
0.38 ms
(1.51%)
1
SET SESSION TRANSACTION ISOLATION LEVEL READ COMMITTED
Parameters:
[]
0.35 ms
(1.38%)
1
SET SESSION time_zone = '+00:00'
Parameters:
[]
0.28 ms
(1.13%)
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\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\ProductClass No errors.
Eccube\Entity\Csv No errors.
Eccube\Entity\Master\CsvType No errors.
Eccube\Entity\Order No errors.
Eccube\Entity\Shipping No errors.
Eccube\Entity\Customer No errors.
Eccube\Entity\Payment No errors.
Eccube\Entity\Master\Sex No errors.
Eccube\Entity\Master\OrderStatus No errors.
Eccube\Entity\Master\PageMax No errors.
Eccube\Entity\Master\ProductStatus No errors.
Eccube\Entity\ProductStock No errors.
Eccube\Entity\OrderPdf No errors.
Eccube\Entity\MailTemplate No errors.
Eccube\Entity\MailHistory No errors.
Eccube\Entity\PaymentOption No errors.
Eccube\Entity\OrderItem 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.
Eccube\Entity\Master\OrderItemType No errors.
Eccube\Entity\Delivery No errors.
Plugin\Noshidelivery\Entity\NoshideliveryCheck No errors.
Plugin\Noshidelivery\Entity\NoshideliveryTie No errors.
Plugin\Noshidelivery\Entity\NoshideliveryKind No errors.