Query Metrics
43
Database Queries
18
Different statements
6.56 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
1.73 ms (26.45%) |
20 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.delivery_id AS delivery_id_3, t0.discriminator_type FROM plg_expresslink_dtb_delivtype t0 WHERE t0.name = ? AND t0.discriminator_type IN ('delivtype')
Parameters:
[
"sagawa_delivtype_super"
]
|
|
1.42 ms (21.59%) |
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_.add_point AS add_point_31, d0_.use_point AS use_point_32, d1_.id AS id_33, d1_.product_name AS product_name_34, d1_.product_code AS product_code_35, d1_.class_name1 AS class_name1_36, d1_.class_name2 AS class_name2_37, d1_.class_category_name1 AS class_category_name1_38, d1_.class_category_name2 AS class_category_name2_39, d1_.price AS price_40, d1_.quantity AS quantity_41, d1_.tax AS tax_42, d1_.tax_rate AS tax_rate_43, d1_.tax_adjust AS tax_adjust_44, d1_.tax_rule_id AS tax_rule_id_45, d1_.currency_code AS currency_code_46, d1_.processor_name AS processor_name_47, d1_.point_rate AS point_rate_48, m2_.id AS id_49, m2_.name AS name_50, m2_.sort_no AS sort_no_51, d3_.id AS id_52, d3_.name01 AS name01_53, d3_.name02 AS name02_54, d3_.kana01 AS kana01_55, d3_.kana02 AS kana02_56, d3_.company_name AS company_name_57, d3_.phone_number AS phone_number_58, d3_.postal_code AS postal_code_59, d3_.addr01 AS addr01_60, d3_.addr02 AS addr02_61, d3_.delivery_name AS delivery_name_62, d3_.time_id AS time_id_63, d3_.delivery_time AS delivery_time_64, d3_.delivery_date AS delivery_date_65, d3_.shipping_date AS shipping_date_66, d3_.tracking_number AS tracking_number_67, d3_.note AS note_68, d3_.sort_no AS sort_no_69, d3_.create_date AS create_date_70, d3_.update_date AS update_date_71, d3_.mail_send_date AS mail_send_date_72, d0_.discriminator_type AS discriminator_type_73, d0_.customer_id AS customer_id_74, d0_.country_id AS country_id_75, d0_.pref_id AS pref_id_76, d0_.sex_id AS sex_id_77, d0_.job_id AS job_id_78, d0_.payment_id AS payment_id_79, d0_.device_type_id AS device_type_id_80, d0_.order_status_id AS order_status_id_81, d0_.order_status_id AS order_status_id_82, d0_.order_status_id AS order_status_id_83, d1_.discriminator_type AS discriminator_type_84, d1_.order_id AS order_id_85, d1_.product_id AS product_id_86, d1_.product_class_id AS product_class_id_87, d1_.shipping_id AS shipping_id_88, d1_.rounding_type_id AS rounding_type_id_89, d1_.tax_type_id AS tax_type_id_90, d1_.tax_display_type_id AS tax_display_type_id_91, d1_.order_item_type_id AS order_item_type_id_92, m2_.discriminator_type AS discriminator_type_93, d3_.discriminator_type AS discriminator_type_94, d3_.order_id AS order_id_95, d3_.country_id AS country_id_96, d3_.pref_id AS pref_id_97, d3_.delivery_id AS delivery_id_98, d3_.creator_id AS creator_id_99 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 NOT IN (?, ?) AND d0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)) AND d0_.discriminator_type IN ('order') ORDER BY d0_.update_date DESC, d0_.id DESC
Parameters:
[ 8 7 255 253 254 248 251 252 249 244 245 242 243 241 236 235 234 233 232 231 227 228 226 224 223 222 221 219 216 213 214 212 211 209 205 204 161 160 156 143 35 142 141 140 138 139 135 137 127 128 130 134 ] |
|
0.54 ms (8.25%) |
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:
[ "motto" 1 ] |
|
0.34 ms (5.19%) |
3 |
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
]
|
|
0.34 ms (5.15%) |
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 NOT IN (?, ?)) AND d0_.discriminator_type IN ('order')
Parameters:
[ 8 7 ] |
|
0.30 ms (4.65%) |
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.29 ms (4.50%) |
4 |
SELECT t0.name AS name_1, t0.value AS value_2, t0.discriminator_type FROM plg_expresslink_dtb_config t0 WHERE t0.name = ? AND t0.discriminator_type IN ('expresslinkconfig') LIMIT 1
Parameters:
[
"ehiden2_use"
]
|
|
0.24 ms (3.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.22 ms (3.38%) |
1 |
SET SESSION time_zone = '+00:00'
Parameters:
[] |
|
0.18 ms (2.81%) |
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
]
|
|
0.15 ms (2.32%) |
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.15 ms (2.24%) |
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.14 ms (2.17%) |
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:
[
5
]
|
|
0.14 ms (2.15%) |
1 |
SELECT d0_.id AS id_0, d1_.id AS id_1, p2_.memo04 AS memo04_2 FROM dtb_shipping d0_ LEFT JOIN plg_vt4g_order_payment p2_ ON (p2_.order_id = d0_.order_id) INNER JOIN dtb_order d1_ ON (d1_.id = d0_.order_id) AND d1_.discriminator_type IN ('order') WHERE (d0_.id IN (257, 255, 256, 250, 253, 254, 251, 246, 247, 244, 245, 243, 238, 237, 236, 235, 234, 233, 229, 230, 228, 226, 225, 224, 222, 220, 217, 214, 215, 213, 212, 210, 206, 205, 162, 161, 157, 144, 35, 143, 142, 141, 139, 140, 136, 138, 128, 129, 131, 135)) AND d0_.discriminator_type IN ('shipping')
Parameters:
[] |
|
0.10 ms (1.51%) |
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 NOT IN (?, ?)) AND d0_.discriminator_type IN ('order') ORDER BY d0_.update_date DESC, d0_.id DESC LIMIT 50
Parameters:
[ 8 7 ] |
|
0.10 ms (1.49%) |
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:
[] |
|
0.10 ms (1.46%) |
1 |
SET SESSION TRANSACTION ISOLATION LEVEL READ COMMITTED
Parameters:
[] |
|
0.07 ms (1.05%) |
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. |
| 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. |
| Plugin\Coupon42\Entity\Coupon | No errors. |
| Plugin\Coupon42\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\Order | No errors. |
| Eccube\Entity\Master\OrderStatus | No errors. |
| Eccube\Entity\Delivery | No errors. |
| Eccube\Entity\Payment | No errors. |
| Eccube\Entity\Csv | No errors. |
| Eccube\Entity\Master\CsvType | No errors. |
| Eccube\Entity\Shipping | No errors. |
| Eccube\Entity\Customer | No errors. |
| Eccube\Entity\Master\Sex | 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\Master\Job | No errors. |
| Eccube\Entity\Master\CustomerOrderStatus | No errors. |
| Eccube\Entity\Master\OrderStatusColor | No errors. |
| Eccube\Entity\Master\RoundingType | No errors. |
| Plugin\ExpressLink42\Entity\ExpressLinkConfig | No errors. |
| Plugin\ExpressLink42\Entity\Cod | No errors. |
| Plugin\ExpressLink42\Entity\Delivtype | No errors. |
| Plugin\VeriTrans4G2\Entity\Vt4gOrderPayment | No errors. |