Query Metrics
53
Database Queries
21
Different statements
54.32 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
20.28 ms (37.32%) |
32 |
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.order_id AS order_id_22, t0.country_id AS country_id_23, t0.pref_id AS pref_id_24, t0.delivery_id AS delivery_id_25, t0.creator_id AS creator_id_26, t0.vendor_id AS vendor_id_27, t0.order_status_id AS order_status_id_28, t0.order_status_id AS order_status_id_29, 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:
[
20
]
|
|
4.76 ms (8.76%) |
1 |
SELECT count(DISTINCT d0_.id) AS sclr_0 FROM dtb_product d0_ INNER JOIN dtb_product_class d1_ ON d0_.id = d1_.product_id AND d1_.discriminator_type IN ('productclass') LEFT JOIN dtb_product_image d2_ ON d0_.id = d2_.product_id AND d2_.discriminator_type IN ('productimage') LEFT JOIN dtb_tax_rule d3_ ON d1_.id = d3_.product_class_id AND d3_.discriminator_type IN ('taxrule') LEFT JOIN dtb_product_stock d4_ ON d1_.id = d4_.product_class_id AND d4_.discriminator_type IN ('productstock') WHERE (d1_.visible = ? AND d0_.product_status_id IN (?, ?) AND d0_.vendor_id IN (?)) AND d0_.discriminator_type IN ('product')
Parameters:
[ 1 1 2 7 ] |
|
4.64 ms (8.54%) |
1 |
SELECT d0_.id AS id_0, d0_.name AS name_1, d0_.note AS note_2, d0_.description_list AS description_list_3, d0_.description_detail AS description_detail_4, d0_.search_word AS search_word_5, d0_.free_area AS free_area_6, d0_.create_date AS create_date_7, d0_.update_date AS update_date_8, d1_.id AS id_9, d1_.product_code AS product_code_10, d1_.stock AS stock_11, d1_.stock_unlimited AS stock_unlimited_12, d1_.sale_limit AS sale_limit_13, d1_.price01 AS price01_14, d1_.price02 AS price02_15, d1_.delivery_fee AS delivery_fee_16, d1_.visible AS visible_17, d1_.create_date AS create_date_18, d1_.update_date AS update_date_19, d1_.currency_code AS currency_code_20, d1_.point_rate AS point_rate_21, d1_.retail_price AS retail_price_22, d1_.reserved_price AS reserved_price_23, d1_.reserved_retail_price AS reserved_retail_price_24, d1_.price_update_datetime AS price_update_datetime_25, d2_.id AS id_26, d2_.file_name AS file_name_27, d2_.sort_no AS sort_no_28, d2_.create_date AS create_date_29, d3_.id AS id_30, d3_.tax_rate AS tax_rate_31, d3_.tax_adjust AS tax_adjust_32, d3_.apply_date AS apply_date_33, d3_.create_date AS create_date_34, d3_.update_date AS update_date_35, d4_.id AS id_36, d4_.stock AS stock_37, d4_.create_date AS create_date_38, d4_.update_date AS update_date_39, d0_.discriminator_type AS discriminator_type_40, d0_.creator_id AS creator_id_41, d0_.product_status_id AS product_status_id_42, d0_.vendor_id AS vendor_id_43, d1_.discriminator_type AS discriminator_type_44, d1_.product_id AS product_id_45, d1_.sale_type_id AS sale_type_id_46, d1_.class_category_id1 AS class_category_id1_47, d1_.class_category_id2 AS class_category_id2_48, d1_.delivery_duration_id AS delivery_duration_id_49, d1_.creator_id AS creator_id_50, d2_.discriminator_type AS discriminator_type_51, d2_.product_id AS product_id_52, d2_.creator_id AS creator_id_53, d3_.discriminator_type AS discriminator_type_54, d3_.product_class_id AS product_class_id_55, d3_.creator_id AS creator_id_56, d3_.country_id AS country_id_57, d3_.pref_id AS pref_id_58, d3_.product_id AS product_id_59, d3_.rounding_type_id AS rounding_type_id_60, d4_.discriminator_type AS discriminator_type_61, d4_.product_class_id AS product_class_id_62, d4_.creator_id AS creator_id_63 FROM dtb_product d0_ INNER JOIN dtb_product_class d1_ ON d0_.id = d1_.product_id AND d1_.discriminator_type IN ('productclass') LEFT JOIN dtb_product_image d2_ ON d0_.id = d2_.product_id AND d2_.discriminator_type IN ('productimage') LEFT JOIN dtb_tax_rule d3_ ON d1_.id = d3_.product_class_id AND d3_.discriminator_type IN ('taxrule') LEFT JOIN dtb_product_stock d4_ ON d1_.id = d4_.product_class_id AND d4_.discriminator_type IN ('productstock') WHERE (d1_.visible = ? AND d0_.product_status_id IN (?, ?) AND d0_.vendor_id IN (?) AND d0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)) AND d0_.discriminator_type IN ('product') ORDER BY d0_.update_date DESC, d0_.id DESC, d2_.sort_no ASC
Parameters:
[ 1 1 2 7 3675 3674 3673 3672 3671 3670 3669 3666 3668 3667 3665 3664 3663 3662 3661 3660 3659 3658 3657 3656 3655 3654 3653 3652 3651 3650 3649 91 90 3457 3458 3459 3460 3461 3462 3093 3094 3095 3096 1865 1866 1867 1868 1827 1869 1825 1826 1743 1744 1745 ] |
|
3.08 ms (5.66%) |
1 |
SELECT d0_.id AS id_0, d0_.category_name AS category_name_1, d0_.hierarchy AS hierarchy_2, d0_.sort_no AS sort_no_3, d0_.create_date AS create_date_4, d0_.update_date AS update_date_5, d1_.id AS id_6, d1_.category_name AS category_name_7, d1_.hierarchy AS hierarchy_8, d1_.sort_no AS sort_no_9, d1_.create_date AS create_date_10, d1_.update_date AS update_date_11, d2_.id AS id_12, d2_.category_name AS category_name_13, d2_.hierarchy AS hierarchy_14, d2_.sort_no AS sort_no_15, d2_.create_date AS create_date_16, d2_.update_date AS update_date_17, d3_.id AS id_18, d3_.category_name AS category_name_19, d3_.hierarchy AS hierarchy_20, d3_.sort_no AS sort_no_21, d3_.create_date AS create_date_22, d3_.update_date AS update_date_23, d4_.id AS id_24, d4_.category_name AS category_name_25, d4_.hierarchy AS hierarchy_26, d4_.sort_no AS sort_no_27, d4_.create_date AS create_date_28, d4_.update_date AS update_date_29, d0_.discriminator_type AS discriminator_type_30, d0_.parent_category_id AS parent_category_id_31, d0_.creator_id AS creator_id_32, d1_.discriminator_type AS discriminator_type_33, d1_.parent_category_id AS parent_category_id_34, d1_.creator_id AS creator_id_35, d2_.discriminator_type AS discriminator_type_36, d2_.parent_category_id AS parent_category_id_37, d2_.creator_id AS creator_id_38, d3_.discriminator_type AS discriminator_type_39, d3_.parent_category_id AS parent_category_id_40, d3_.creator_id AS creator_id_41, d4_.discriminator_type AS discriminator_type_42, d4_.parent_category_id AS parent_category_id_43, d4_.creator_id AS creator_id_44 FROM dtb_category d0_ LEFT JOIN dtb_category d1_ ON d0_.id = d1_.parent_category_id AND d1_.discriminator_type IN ('category') LEFT JOIN dtb_category d2_ ON d1_.id = d2_.parent_category_id AND d2_.discriminator_type IN ('category') LEFT JOIN dtb_category d3_ ON d2_.id = d3_.parent_category_id AND d3_.discriminator_type IN ('category') LEFT JOIN dtb_category d4_ ON d3_.id = d4_.parent_category_id AND d4_.discriminator_type IN ('category') WHERE (d0_.parent_category_id IS NULL) AND d0_.discriminator_type IN ('category') ORDER BY d0_.sort_no DESC, d1_.sort_no DESC, d2_.sort_no DESC, d3_.sort_no DESC, d4_.sort_no DESC
Parameters:
[] |
|
2.52 ms (4.64%) |
1 |
SELECT DISTINCT d0_.id AS id_0, d0_.update_date AS update_date_1, d0_.id AS id_2 FROM dtb_product d0_ INNER JOIN dtb_product_class d1_ ON d0_.id = d1_.product_id AND d1_.discriminator_type IN ('productclass') LEFT JOIN dtb_product_image d2_ ON d0_.id = d2_.product_id AND d2_.discriminator_type IN ('productimage') LEFT JOIN dtb_tax_rule d3_ ON d1_.id = d3_.product_class_id AND d3_.discriminator_type IN ('taxrule') LEFT JOIN dtb_product_stock d4_ ON d1_.id = d4_.product_class_id AND d4_.discriminator_type IN ('productstock') WHERE (d1_.visible = ? AND d0_.product_status_id IN (?, ?) AND d0_.vendor_id IN (?)) AND d0_.discriminator_type IN ('product') ORDER BY d0_.update_date DESC, d0_.id DESC LIMIT 50
Parameters:
[ 1 1 2 7 ] |
|
2.52 ms (4.63%) |
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.emailcc1 AS emailcc1_32, t0.emailcc2 AS emailcc2_33, t0.emailcc3 AS emailcc3_34, t0.emailcc4 AS emailcc4_35, t0.emailcc5 AS emailcc5_36, t0.emailcc6 AS emailcc6_37, t0.emailcc7 AS emailcc7_38, t0.emailcc8 AS emailcc8_39, t0.emailcc9 AS emailcc9_40, t0.emailcc10 AS emailcc10_41, t0.sub_total_retail_price AS sub_total_retail_price_42, t0.add_point AS add_point_43, t0.use_point AS use_point_44, t0.customer_id AS customer_id_45, t0.country_id AS country_id_46, t0.pref_id AS pref_id_47, t0.sex_id AS sex_id_48, t0.job_id AS job_id_49, t0.payment_id AS payment_id_50, t0.device_type_id AS device_type_id_51, t0.order_status_id AS order_status_id_52, t0.order_status_id AS order_status_id_53, t0.order_status_id AS order_status_id_54, t0.discriminator_type FROM dtb_order t0 WHERE t0.order_status_id = ? AND t0.discriminator_type IN ('order')
Parameters:
[
1
]
|
|
2.15 ms (3.96%) |
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:
[
1
]
|
|
2.07 ms (3.82%) |
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.logo_filename AS logo_filename_13, t0.email AS email_14, t0.emailcc1 AS emailcc1_15, t0.emailcc2 AS emailcc2_16, t0.emailcc3 AS emailcc3_17, t0.emailcc4 AS emailcc4_18, t0.emailcc5 AS emailcc5_19, t0.emailcc6 AS emailcc6_20, t0.emailcc7 AS emailcc7_21, t0.emailcc8 AS emailcc8_22, t0.emailcc9 AS emailcc9_23, t0.emailcc10 AS emailcc10_24, t0.work_id AS work_id_25, t0.authority_id AS authority_id_26, t0.creator_id AS creator_id_27, t0.discriminator_type FROM dtb_member t0 WHERE t0.login_id = ? AND t0.work_id = ? AND t0.discriminator_type IN ('member') LIMIT 1
Parameters:
[ "inter-support@jtmc-market.jp" 1 ] |
|
1.86 ms (3.43%) |
1 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.sort_no AS sort_no_3, t0.discriminator_type FROM mtb_product_status t0 WHERE t0.id IN (?, ?) AND t0.discriminator_type IN ('productstatus')
Parameters:
[ 1 2 ] |
|
1.68 ms (3.10%) |
1 |
SELECT p0_.id AS id_0, p0_.url_path AS url_path_1, p0_.selector AS selector_2 FROM plg_wysiwyg_editor_settings p0_ ORDER BY p0_.id DESC
Parameters:
[] |
|
1.66 ms (3.05%) |
1 |
SELECT d0_.id AS id_0, d0_.name AS name_1, d0_.sort_no AS sort_no_2, d0_.discriminator_type AS discriminator_type_3 FROM dtb_tag d0_ WHERE d0_.discriminator_type IN ('tag') ORDER BY d0_.sort_no DESC
Parameters:
[] |
|
1.51 ms (2.77%) |
1 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.sort_no AS sort_no_3, t0.discriminator_type FROM mtb_authority t0 WHERE t0.id = ? AND t0.discriminator_type IN ('authority')
Parameters:
[
1
]
|
|
1.39 ms (2.57%) |
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.84 ms (1.54%) |
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.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
]
|
|
0.72 ms (1.33%) |
1 |
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 AND d0_.product_class_id IS NULL) AND d0_.discriminator_type IN ('taxrule') ORDER BY d0_.apply_date DESC
Parameters:
[
"2026-02-04 06:59:02"
]
|
|
0.71 ms (1.30%) |
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.logo_filename AS logo_filename_13, t0.email AS email_14, t0.emailcc1 AS emailcc1_15, t0.emailcc2 AS emailcc2_16, t0.emailcc3 AS emailcc3_17, t0.emailcc4 AS emailcc4_18, t0.emailcc5 AS emailcc5_19, t0.emailcc6 AS emailcc6_20, t0.emailcc7 AS emailcc7_21, t0.emailcc8 AS emailcc8_22, t0.emailcc9 AS emailcc9_23, t0.emailcc10 AS emailcc10_24, t0.work_id AS work_id_25, t0.authority_id AS authority_id_26, t0.creator_id AS creator_id_27, t0.discriminator_type FROM dtb_member t0 WHERE t0.discriminator_type IN ('member')
Parameters:
[] |
|
0.50 ms (0.92%) |
1 |
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_product_status m0_ WHERE m0_.discriminator_type IN ('productstatus') ORDER BY m0_.sort_no ASC
Parameters:
[] |
|
0.49 ms (0.90%) |
1 |
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_product_status m0_ WHERE (m0_.id IN (?, ?)) AND m0_.discriminator_type IN ('productstatus') ORDER BY m0_.sort_no ASC
Parameters:
[ "1" "2" ] |
|
0.40 ms (0.74%) |
1 |
SET SESSION TRANSACTION ISOLATION LEVEL READ COMMITTED
Parameters:
[] |
|
0.29 ms (0.54%) |
1 |
SET SESSION time_zone = '+00:00'
Parameters:
[] |
|
0.26 ms (0.48%) |
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\Member | 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\Master\Work | No errors. |
| Eccube\Entity\Master\Authority | No errors. |
| Customize\Entity\VendorGroup | No errors. |
| Eccube\Entity\Master\Country | No errors. |
| Eccube\Entity\Master\Pref | 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\ProductClass | No errors. |
| Eccube\Entity\ProductImage | No errors. |
| Eccube\Entity\Category | No errors. |
| Eccube\Entity\Master\PageMax | No errors. |
| Eccube\Entity\Master\ProductStatus | No errors. |
| Eccube\Entity\Tag | No errors. |
| Eccube\Entity\ProductCategory | No errors. |
| Eccube\Entity\TaxRule | No errors. |
| Eccube\Entity\ProductStock | No errors. |
| Eccube\Entity\Master\SaleType | No errors. |
| Eccube\Entity\ClassCategory | No errors. |
| Eccube\Entity\DeliveryDuration | No errors. |
| Eccube\Entity\Master\RoundingType | No errors. |
| Eccube\Entity\ProductTag | No errors. |
| Eccube\Entity\CustomerFavoriteProduct | No errors. |
| Plugin\AttachWysiwygEditor42\Entity\AweConfig | 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\MailHistory | No errors. |
| Eccube\Entity\Delivery | No errors. |