Query Metrics

9 Database Queries
8 Different statements
3.33 ms Query time
0 Invalid entities

Grouped Statements

Show all queries

Time Count Info
1.69 ms
(50.69%)
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_.stock_quantity AS stock_quantity_8, p0_.cost_min AS cost_min_9, p0_.create_time AS create_time_10, s1_.product_id AS product_id_11, s1_.group_id AS group_id_12, s1_.product_type AS product_type_13, s1_.is_show_in_catalog AS is_show_in_catalog_14, s1_.presence AS presence_15, s1_.presence_str AS presence_str_16, s1_.rating AS rating_17, p2_.product_id AS product_id_18, p2_.url_code AS url_code_19, p2_.rating AS rating_20, p2_.seo_title AS seo_title_21, p2_.seo_description AS seo_description_22, p2_.seo_keyword AS seo_keyword_23, p3_.id AS id_24, p3_.default AS default_25, p3_.change_data AS change_data_26, p3_.show_img AS show_img_27, p3_.show_price AS show_price_28, p3_.show_presence AS show_presence_29, p3_.features_sharing AS features_sharing_30, p3_.manual_sharing AS manual_sharing_31, p3_.features AS features_32, p0_.category_id AS category_id_33, s1_.category_id AS category_id_34, s1_.catalog_product_id AS catalog_product_id_35, s1_.product_id AS product_id_36, p2_.product_id AS product_id_37, p3_.product_id AS product_id_38 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:
[
  281
]
0.54 ms
(16.23%)
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:
[
  "gcld1l9t"
]
0.34 ms
(10.31%)
1
INSERT INTO wishlist (user_id, code, name, is_default, date_updated) VALUES (?, ?, ?, ?, ?)
Parameters:
[
  null
  "gcld1l9t"
  null
  1
  "2026-06-06 03:47:26"
]
0.23 ms
(6.89%)
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.17 ms
(5.04%)
1
"COMMIT"
Parameters:
[]
0.14 ms
(4.32%)
2
SELECT t0.setting_id AS setting_id_1, t0.ln_id AS ln_id_2, t0.setting_value AS setting_value_3, t0.setting_id AS setting_id_4 FROM kk_settings_ln t0 WHERE t0.setting_id = ?
Parameters:
[
  15
]
0.13 ms
(3.87%)
1
"START TRANSACTION"
Parameters:
[]
0.09 ms
(2.64%)
1
SELECT k0_.id AS id_0, k0_.name AS name_1, k0_.code AS code_2, k0_.active AS active_3, k0_.default AS default_4 FROM kk_language k0_ WHERE k0_.code = ? LIMIT 1
Parameters:
[
  "en"
]

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.