Query Metrics
5
Database Queries
5
Different statements
2.86 ms
Query time
0
Invalid entities
Grouped Statements
Time▼ | Count | Info |
---|---|---|
1.12 ms (39.00%) |
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.74 ms (25.71%) |
1 |
SELECT t0.id AS id_1, t0.contract_code AS contract_code_2, t0.environmental_setting AS environmental_setting_3, t0.credit_payment_setting AS credit_payment_setting_4, t0.use_payment AS use_payment_5, t0.use_convenience AS use_convenience_6, t0.card_expiration_notification_days AS card_expiration_notification_days_7, t0.regular AS regular_8, t0.block_mode AS block_mode_9, t0.access_frequency_time AS access_frequency_time_10, t0.access_frequency AS access_frequency_11, t0.block_time AS block_time_12, t0.white_list AS white_list_13, t0.regular_order_notification_email AS regular_order_notification_email_14, t0.next_delivery_date_changeable_range_days AS next_delivery_date_changeable_range_days_15, t0.first_delivery_days AS first_delivery_days_16, t0.next_delivery_days_at_regular_resumption AS next_delivery_days_at_regular_resumption_17, t0.next_delivery_days_after_re_payment AS next_delivery_days_after_re_payment_18, t0.regular_order_deadline AS regular_order_deadline_19, t0.regular_delivery_notification_email_days AS regular_delivery_notification_email_days_20, t0.regular_stoppable_count AS regular_stoppable_count_21, t0.regular_cancelable_count AS regular_cancelable_count_22, t0.regular_resumable_period AS regular_resumable_period_23, t0.regular_specified_count_notification_mail AS regular_specified_count_notification_mail_24, t0.regular_point_magnification AS regular_point_magnification_25 FROM plg_eccube_payment_lite42_config t0 WHERE t0.id = ?
Parameters:
[
1
]
|
0.40 ms (14.06%) |
1 |
SET SESSION time_zone = '+00:00'
Parameters:
[] |
0.33 ms (11.72%) |
1 |
SET SESSION TRANSACTION ISOLATION LEVEL READ COMMITTED
Parameters:
[] |
0.27 ms (9.51%) |
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\QuantityDiscountDx\Entity\QdProductClass | No errors. |
Plugin\QuantityDiscountDx\Entity\QdConfig | 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\Country | No errors. |
Eccube\Entity\Master\Pref | No errors. |
Eccube\Entity\Order | No errors. |
Eccube\Entity\Master\OrderStatus | No errors. |
Eccube\Entity\Customer | No errors. |
Plugin\EccubePaymentLite42\Entity\Config | No errors. |
Plugin\EccubePaymentLite42\Entity\GmoEpsilonPayment | No errors. |
Plugin\EccubePaymentLite42\Entity\ConvenienceStore | No errors. |
Plugin\EccubePaymentLite42\Entity\IpBlackList | No errors. |
Plugin\EccubePaymentLite42\Entity\MyPageRegularSetting | No errors. |