Query Metrics

6 Database Queries
6 Different statements
3.04 ms Query time
0 Invalid entities

Grouped Statements

Show all queries

Time Count Info
1.40 ms
(45.95%)
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:
[
  12
]
0.76 ms
(25.02%)
1
INSERT INTO wishlist (user_id, code, name, is_default, date_updated) VALUES (?, ?, ?, ?, ?)
Parameters:
[
  null
  "9kykde3s"
  null
  1
  "2025-12-25 08:45:33"
]
0.46 ms
(15.24%)
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:
[
  "9kykde3s"
]
0.16 ms
(5.13%)
1
"COMMIT"
Parameters:
[]
0.14 ms
(4.77%)
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.12 ms
(3.88%)
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.