Query Metrics
6
Database Queries
6
Different statements
2.68 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
1.30 ms (48.38%) |
1 |
SELECT p0_.product_id AS product_id_0, p0_.product AS product_1, p0_.pn AS pn_2, p0_.description AS description_3, p0_.detail_description AS detail_description_4, p0_.deleted AS deleted_5, p0_.pic AS pic_6, p0_.warranty AS warranty_7, p0_.cost_min AS cost_min_8, p0_.create_time AS create_time_9, s1_.product_id AS product_id_10, s1_.group_id AS group_id_11, s1_.product_type AS product_type_12, s1_.is_show_in_catalog AS is_show_in_catalog_13, s1_.presence AS presence_14, s1_.presence_str AS presence_str_15, s1_.rating AS rating_16, p2_.product_id AS product_id_17, p2_.url_code AS url_code_18, p2_.rating AS rating_19, p2_.seo_title AS seo_title_20, p2_.seo_description AS seo_description_21, p2_.seo_keyword AS seo_keyword_22, p3_.id AS id_23, p3_.default AS default_24, p3_.change_data AS change_data_25, p3_.show_img AS show_img_26, p3_.show_price AS show_price_27, p3_.show_presence AS show_presence_28, p3_.features_sharing AS features_sharing_29, p3_.manual_sharing AS manual_sharing_30, p3_.features AS features_31, p0_.category_id AS category_id_32, s1_.category_id AS category_id_33, s1_.catalog_product_id AS catalog_product_id_34, s1_.product_id AS product_id_35, p2_.product_id AS product_id_36, p3_.product_id AS product_id_37 FROM Products p0_ INNER JOIN sf_product_index s1_ ON p0_.product_id = s1_.product_id INNER JOIN Products_Data p2_ ON p0_.product_id = p2_.product_id LEFT JOIN products_groups p3_ ON p0_.product_id = p3_.product_id INNER JOIN wishlist_product w4_ ON (p0_.product_id = w4_.product_id) WHERE p0_.deleted = 0 AND p2_.url_code <> '' AND w4_.wishlist_id = ? ORDER BY p0_.product_id DESC LIMIT 100
Parameters:
[
11
]
|
|
0.49 ms (18.13%) |
1 |
INSERT INTO wishlist (user_id, code, name, is_default, date_updated) VALUES (?, ?, ?, ?, ?)
Parameters:
[ null "23nkl7la" null 1 "2025-12-25 06:44:53" ] |
|
0.39 ms (14.38%) |
1 |
SELECT t0.id AS id_1, t0.user_id AS user_id_2, t0.code AS code_3, t0.name AS name_4, t0.is_default AS is_default_5, t0.date_updated AS date_updated_6 FROM wishlist t0 WHERE t0.code = ? LIMIT 1
Parameters:
[
"23nkl7la"
]
|
|
0.27 ms (9.87%) |
1 |
SELECT s0_.setting_id AS setting_id_0, s0_.type AS type_1, s0_.setting_name AS setting_name_2, s0_.setting_value AS setting_value_3, s0_.description AS description_4 FROM store_settings s0_ LEFT JOIN kk_settings_ln k1_ ON s0_.setting_id = k1_.setting_id WHERE s0_.type = 'site' AND s0_.setting_name IN (?, ?, ?) LIMIT 3
Parameters:
[ "notify_top" "datepicker" "notify_url" ] |
|
0.15 ms (5.51%) |
1 |
"COMMIT"
Parameters:
[] |
|
0.10 ms (3.72%) |
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 |
|---|---|
| SoftUa\WishlistBundle\Entity\Wishlist | No errors. |
| SoftUa\ProductBundle\Entity\Product | No errors. |
| SoftUa\ProductBundle\Entity\ProductIndex | No errors. |
| SoftUa\ProductBundle\Entity\ProductData | No errors. |
| SoftUa\ProductBundle\Entity\GroupSettings | No errors. |
| SoftUa\WishlistBundle\Entity\WishlistProduct | No errors. |
| SoftUa\CategoryBundle\Entity\Category | No errors. |
| SoftUa\HeaderNotificationBundle\Entity\StoreSettings | No errors. |
| SoftUa\HeaderNotificationBundle\Entity\StoreSettingsTranslation | No errors. |