Query Metrics
17
Database Queries
14
Different statements
3.92 ms
Query time
5
Invalid entities
Queries
#▲ | Time | Info |
---|---|---|
1 | 0.13 ms |
SET SESSION time_zone = '+00:00'
Parameters:
[] |
2 | 0.11 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.email AS email_13, t0.work_id AS work_id_14, t0.authority_id AS authority_id_15, t0.creator_id AS creator_id_16, t0.discriminator_type FROM dtb_member t0 WHERE t0.login_id = ? AND t0.work_id = ? AND t0.discriminator_type IN ('member') LIMIT 1
Parameters:
[ "rootuser" 1 ] |
3 | 0.06 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.08 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.option_product_tax_rule AS option_product_tax_rule_25, t0.option_customer_activate AS option_customer_activate_26, t0.option_remember_me AS option_remember_me_27, t0.authentication_key AS authentication_key_28, t0.php_path AS php_path_29, t0.option_point AS option_point_30, t0.basic_point_rate AS basic_point_rate_31, t0.point_conversion_rate AS point_conversion_rate_32, t0.chainstore_from_email AS chainstore_from_email_33, t0.magazine_chainstore_from_email AS magazine_chainstore_from_email_34, t0.magazine_customer_from_email AS magazine_customer_from_email_35, t0.option_chainstore_activate AS option_chainstore_activate_36, t0.country_id AS country_id_37, t0.pref_id AS pref_id_38, t0.retail_usage_fee_product_id AS retail_usage_fee_product_id_39, t0.discriminator_type FROM dtb_base_info t0 WHERE t0.id = ? AND t0.discriminator_type IN ('baseinfo')
Parameters:
[
1
]
|
5 | 0.05 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.06 ms |
SET SESSION TRANSACTION ISOLATION LEVEL READ COMMITTED
Parameters:
[] |
7 | 0.02 ms |
"START TRANSACTION"
Parameters:
[] |
8 | 0.09 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
]
|
9 | 0.68 ms |
SELECT t1.order_status_id as status, COUNT(t1.id) as count FROM dtb_order t1 WHERE t1.order_status_id NOT IN (:excludes) GROUP BY t1.order_status_id ORDER BY t1.order_status_id
Parameters:
[ "excludes" => [ 3 5 7 8 9 ] ] |
10 | 0.29 ms |
SELECT SUM(d0_.payment_total) AS sclr_0, COUNT(d0_.id) AS sclr_1 FROM dtb_order d0_ WHERE ((? <= d0_.order_date AND d0_.order_date < ?) AND d0_.order_status_id NOT IN (?)) AND d0_.discriminator_type IN ('order')
Parameters:
[ "2025-07-08 15:00:00" "2025-07-09 15:00:00" [ 3 7 8 9 ] ] |
11 | 0.17 ms |
SELECT SUM(d0_.payment_total) AS sclr_0, COUNT(d0_.id) AS sclr_1 FROM dtb_order d0_ WHERE ((? <= d0_.order_date AND d0_.order_date < ?) AND d0_.order_status_id NOT IN (?)) AND d0_.discriminator_type IN ('order')
Parameters:
[ "2025-07-07 15:00:00" "2025-07-08 15:00:00" [ 3 7 8 9 ] ] |
12 | 0.19 ms |
SELECT SUM(d0_.payment_total) AS sclr_0, COUNT(d0_.id) AS sclr_1 FROM dtb_order d0_ WHERE ((? <= d0_.order_date AND d0_.order_date < ?) AND d0_.order_status_id NOT IN (?)) AND d0_.discriminator_type IN ('order')
Parameters:
[ "2025-06-30 15:00:00" "2025-07-31 15:00:00" [ 3 7 8 9 ] ] |
13 | 0.71 ms |
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') WHERE ((d1_.stock_unlimited = ? AND d1_.stock = 0) AND d1_.visible = ?) AND d0_.discriminator_type IN ('product')
Parameters:
[ 0 1 ] |
14 | 0.28 ms |
SELECT count(d0_.id) AS sclr_0 FROM dtb_product d0_ WHERE (d0_.product_status_id IN (?)) AND d0_.discriminator_type IN ('product')
Parameters:
[ [ 1 2 ] ] |
15 | 0.38 ms |
SELECT count(d0_.id) AS sclr_0 FROM dtb_customer d0_ WHERE (d0_.customer_status_id = ?) AND d0_.discriminator_type IN ('customer')
Parameters:
[
2
]
|
16 | 0.07 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.code AS code_3, t0.enabled AS enabled_4, t0.version AS version_5, t0.source AS source_6, t0.initialized AS initialized_7, t0.create_date AS create_date_8, t0.update_date AS update_date_9, t0.discriminator_type FROM dtb_plugin t0 WHERE t0.discriminator_type IN ('plugin')
Parameters:
[] |
17 | 0.55 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 NOT IN (?) AND t0.discriminator_type IN ('orderstatus') ORDER BY t0.sort_no ASC
Parameters:
[ [ 3 5 7 8 9 ] ] |
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\ProductClass | No errors. |
Plugin\KokokaraSelect\Entity\KsCartSelectItemGroup | No errors. |
Plugin\KokokaraSelect\Entity\KsSelectItem | No errors. |
Plugin\KokokaraSelect\Entity\KsCartSelectItem | No errors. |
Plugin\KokokaraSelect\Entity\KsSelectItemGroup |
|
Plugin\KokokaraSelect\Entity\PlgConfig |
|
Plugin\KokokaraSelect\Entity\PlgConfigOption |
|
Eccube\Entity\Product | No errors. |
Eccube\Entity\Master\AbstractMasterEntity | No errors. |
Customize\Entity\Master\ContractType | 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\DeviceType | No errors. |
Eccube\Entity\AuthorityRole | No errors. |
Eccube\Entity\Layout | No errors. |
Eccube\Entity\Order |
|
Customize\Entity\ChainStore |
|
Eccube\Entity\Shipping | 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\Master\OrderStatus | No errors. |
Eccube\Entity\Customer | No errors. |
Plugin\ZeusPayment4\Entity\Config | No errors. |
Eccube\Entity\MailTemplate | No errors. |
Eccube\Entity\MailHistory | No errors. |
Plugin\Coupon4\Entity\Coupon | No errors. |
Plugin\Coupon4\Entity\CouponOrder | No errors. |
Eccube\Entity\Category | 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\Delivery | No errors. |
Eccube\Entity\DeliveryFee | No errors. |
Eccube\Entity\ProductStock | No errors. |
Plugin\DeliveryPlus4\Entity\DeliveryPlusConfig | No errors. |
Eccube\Entity\Payment | No errors. |
Eccube\Entity\Plugin | No errors. |