Query Metrics
27
Database Queries
17
Different statements
25.13 ms
Query time
0
Invalid entities
Grouped Statements
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. |