Query Metrics

13 Database Queries
10 Different statements
5.33 ms Query time
0 Invalid entities

Grouped Statements

Show all queries

Time Count Info
1.12 ms
(21.08%)
1
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"
]
1.03 ms
(19.37%)
1
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
]
0.95 ms
(17.74%)
2
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
]
0.66 ms
(12.47%)
1
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"
]
0.57 ms
(10.61%)
2
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
]
0.27 ms
(5.01%)
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.24 ms
(4.54%)
1
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
]
0.20 ms
(3.66%)
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.18 ms
(3.44%)
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"
]
0.11 ms
(2.07%)
1
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
]

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.