POST https://elektrofortecia.url.org.ua/category/api/Q2F0ZWdvcnk6MTAwOQ==/filters/

Query Metrics

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

Queries

Group similar statements

# Time Info
1 0.27 ms
SELECT c0_.category_id AS category_id_0, c0_.category_left AS category_left_1, c0_.category_right AS category_right_2, c0_.active AS active_3 FROM Categories c0_ WHERE c0_.active = ? ORDER BY c0_.category_left ASC
Parameters:
[
  0
]
2 0.15 ms
SELECT c0_.category_id AS category_id_0, c0_.category_name AS category_name_1, c0_.category_left AS category_left_2, c0_.category_level AS category_level_3, c0_.category_right AS category_right_4, c0_.description AS description_5, c0_.short_desc AS short_desc_6, c0_.code AS code_7, c0_.img AS img_8, c0_.meta_title AS meta_title_9, c0_.meta_keywords AS meta_keywords_10, c0_.meta_description AS meta_description_11, c0_.active AS active_12, c0_.is_empty AS is_empty_13, c0_.category_top AS category_top_14 FROM Categories c0_ WHERE c0_.active = 1 AND c0_.category_id = ? LIMIT 1
Parameters:
[
  1009
]
3 0.16 ms
SELECT f0_.id AS id_0, f0_.feature_id AS feature_id_1, f0_.category_id AS category_id_2, f0_.code AS code_3, f0_.is_slider AS is_slider_4, f0_.view_settings AS view_settings_5, f0_.logic AS logic_6, f1_.id AS id_7, f1_.code AS code_8, f1_.name AS name_9, f1_.weight AS weight_10, f1_.category_id AS category_id_11, f1_.active AS active_12, f1_.auto_settings AS auto_settings_13, f1_.logic AS logic_14, f1_.feature_id AS feature_id_15, f2_.id AS id_16, f2_.feature_id AS feature_id_17, f2_.value_id AS value_id_18, f2_.code AS code_19, f2_.img AS img_20, f2_.value AS value_21, f2_.description AS description_22, f2_.json_path AS json_path_23, f2_.facet_size AS facet_size_24, f0_.filter_id AS filter_id_25, f2_.filter_id AS filter_id_26 FROM filters_list_index f0_ LEFT JOIN filters f1_ ON f0_.filter_id = f1_.id LEFT JOIN filters_value_index f2_ ON f1_.id = f2_.filter_id AND (f0_.feature_id > 0 AND f0_.is_slider = 1) WHERE f0_.category_id = ? ORDER BY f0_.id ASC
Parameters:
[
  1009
]
4 0.17 ms
SELECT MIN(f0_.price_selling) AS sclr_0, MAX(f0_.price_selling) AS sclr_1 FROM filters_product_index f0_ INNER JOIN Products p1_ ON f0_.catalog_product_id = p1_.product_id INNER JOIN Products_Categoryes p3_ ON p1_.product_id = p3_.product_id INNER JOIN Categories c2_ ON c2_.category_id = p3_.category_id WHERE c2_.category_id = ? AND f0_.price_selling > 0
Parameters:
[
  1009
]
5 0.15 ms
SELECT f0_.id AS id_0, f0_.feature_id AS feature_id_1, f0_.value_id AS value_id_2, f0_.code AS code_3, f0_.img AS img_4, f0_.value AS value_5, f0_.description AS description_6, f0_.json_path AS json_path_7, f0_.facet_size AS facet_size_8, f0_.filter_id AS filter_id_9 FROM filters_value_index f0_ LEFT JOIN filters f1_ ON f0_.filter_id = f1_.id LEFT JOIN filters_list_index f2_ ON f1_.id = f2_.filter_id AND (f2_.feature_id > 0 AND f2_.is_slider = 1) WHERE f2_.id IS NULL AND f0_.filter_id IN (?) ORDER BY f0_.id ASC
Parameters:
[
  18
]
6 0.15 ms
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:
[
  "uk"
]
7 0.14 ms
SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.as_default AS as_default_2, s0_.product AS product_3, s0_.static AS static_4, s0_.news AS news_5, s0_.category AS category_6, s0_.subcategory AS subcategory_7, s0_.main AS main_8, s0_.catalog AS catalog_9 FROM seo_templates s0_ WHERE s0_.as_default = ? LIMIT 1
Parameters:
[
  1
]
8 0.17 ms
SELECT t0.currency_id AS currency_id_1, t0.currency AS currency_2, t0.is_cash AS is_cash_3, t0.rate AS rate_4 FROM Currencies t0
Parameters:
[]
9 0.09 ms
SELECT t0.currency_id AS currency_id_1, t0.currency AS currency_2, t0.is_cash AS is_cash_3, t0.rate AS rate_4 FROM Currencies t0
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.