Query Metrics
9
Database Queries
8
Different statements
1.45 ms
Query time
0
Invalid entities
Queries
| #▲ | 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.
Entities Mapping
| Class | Mapping errors |
|---|---|
| SoftUa\CategoryBundle\Entity\Category | No errors. |
| SoftUa\CategoryBundle\Entity\CategoryTranslation | No errors. |
| SoftUa\CatalogFiltersBundle\Entity\FilterIndex | No errors. |
| SoftUa\CatalogFiltersBundle\Entity\Filter | No errors. |
| SoftUa\CatalogFiltersBundle\Entity\FilterValueIndex | No errors. |
| SoftUa\CatalogFiltersBundle\Entity\FilterProductIndex | No errors. |
| SoftUa\ProductBundle\Entity\Product | No errors. |
| SoftUa\CoreBundle\Entity\DataLanguage | No errors. |
| SoftUa\SeoBundle\Entity\SeoTemplate | No errors. |
| SoftUa\SeoBundle\Entity\SeoTemplateTranslation | No errors. |
| SoftUa\CurrencyBundle\Entity\Currency | No errors. |