Query Metrics
13
Database Queries
10
Different statements
5.33 ms
Query time
0
Invalid entities
Queries
| #▲ | Time | Info |
|---|---|---|
| 1 | 0.24 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
]
|
| 2 | 0.18 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:
[
"en"
]
|
| 3 | 0.11 ms |
SELECT t0.data_id AS data_id_1, t0.ln_id AS ln_id_2, t0.product AS product_3, t0.static AS static_4, t0.news AS news_5, t0.category AS category_6, t0.subcategory AS subcategory_7, t0.main AS main_8, t0.catalog AS catalog_9, t0.data_id AS data_id_10 FROM kk_seo_templates_ln t0 WHERE t0.data_id = ?
Parameters:
[
1
]
|
| 4 | 1.12 ms |
SELECT b0_.id AS id_0, b0_.name AS name_1, b0_.active AS active_2, b0_.weight AS weight_3, b0_.alt AS alt_4, b0_.title AS title_5, b0_.link AS link_6, b1_.id AS id_7, b1_.name AS name_8, b1_.code AS code_9, k2_.id AS id_10, k2_.ln_id AS ln_id_11, k2_.alt AS alt_12, k2_.title AS title_13, b0_.type_id AS type_id_14, k2_.banner_id AS banner_id_15 FROM banners b0_ INNER JOIN banners_type b1_ ON b0_.type_id = b1_.id LEFT JOIN kk_banners_ln k2_ ON b0_.id = k2_.banner_id WHERE b0_.active = ? AND b1_.code = ? ORDER BY b0_.weight DESC
Parameters:
[ 1 "main" ] |
| 5 | 0.63 ms |
SELECT t0.id AS id_1, t0.lang_id AS lang_id_2, t0.name AS name_3, t0.point AS point_4, t0.banner_id AS banner_id_5 FROM kk_banners_images t0 WHERE t0.banner_id = ?
Parameters:
[
2
]
|
| 6 | 0.30 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.point AS point_3, t0.banner_id AS banner_id_4 FROM banners_images t0 WHERE t0.banner_id = ?
Parameters:
[
2
]
|
| 7 | 0.31 ms |
SELECT t0.id AS id_1, t0.lang_id AS lang_id_2, t0.name AS name_3, t0.point AS point_4, t0.banner_id AS banner_id_5 FROM kk_banners_images t0 WHERE t0.banner_id = ?
Parameters:
[
3
]
|
| 8 | 0.26 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.point AS point_3, t0.banner_id AS banner_id_4 FROM banners_images t0 WHERE t0.banner_id = ?
Parameters:
[
3
]
|
| 9 | 0.66 ms |
SELECT f0_.feature_id AS feature_id_0, f0_.feature_name AS feature_name_1, f0_.coment AS coment_2, f0_.code AS code_3, f0_.in_short_list AS in_short_list_4, f0_.in_full_list AS in_full_list_5, f0_.in_individual_selection AS in_individual_selection_6, f0_.weight AS weight_7, f0_.img AS img_8, f0_.type AS type_9, f0_.format AS format_10, f0_.multivalues AS multivalues_11, f0_.use_as AS use_as_12, f0_.feature_section_id AS feature_section_id_13 FROM Feature f0_ WHERE f0_.use_as = ? LIMIT 1
Parameters:
[
"brend"
]
|
| 10 | 1.03 ms |
SELECT f0_.value AS value_0, f0_.id AS id_1, f0_.code AS code_2, f1_.feature_id AS feature_id_3, f1_.value_id AS value_id_4, f1_.weight AS weight_5, f1_.img AS img_6, f1_.url AS url_7, f1_.description AS description_8, f1_.color AS color_9, k2_.value_id AS value_id_10, k2_.feature_id AS feature_id_11, k2_.ln_id AS ln_id_12, k2_.value AS value_13, k2_.url AS url_14, k2_.description AS description_15, f0_.id AS id_16, f0_.feature_id AS feature_id_17, f0_.feature_id AS feature_id_18, k2_.value_id AS value_id_19, k2_.feature_id AS feature_id_20 FROM Feature_Values_string f0_ INNER JOIN Feature_Value_Settings f1_ ON f0_.id = f1_.value_id AND f0_.feature_id = f1_.feature_id LEFT JOIN kk_features_values_ln k2_ ON f1_.value_id = k2_.value_id AND f1_.feature_id = k2_.feature_id WHERE f0_.feature_id = ? AND f0_.value <> '' AND f1_.img <> '' ORDER BY f1_.weight ASC LIMIT 20
Parameters:
[
1
]
|
| 11 | 0.27 ms |
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" ] |
| 12 | 0.10 ms |
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
]
|
| 13 | 0.09 ms |
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:
[
17
]
|
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.