Query Metrics

8 Database Queries
7 Different statements
1.95 ms Query time
0 Invalid entities

Grouped Statements

Show all queries

Time Count Info
0.88 ms
(45.18%)
1
SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.active AS active_2, s0_.weight AS weight_3, s0_.description AS description_4, s0_.full_description AS full_description_5, s0_.code AS code_6, s0_.meta_title AS meta_title_7, s0_.meta_desc AS meta_desc_8, s0_.meta_keywords AS meta_keywords_9 FROM static_pages s0_ WHERE s0_.code = ? AND s0_.active = ? ORDER BY s0_.id ASC LIMIT 1
Parameters:
[
  "contacts"
  1
]
0.28 ms
(14.59%)
1
SELECT t0.id AS id_1, t0.ln_id AS ln_id_2, t0.name AS name_3, t0.description AS description_4, t0.preview_text AS preview_text_5, t0.meta_title AS meta_title_6, t0.meta_keywords AS meta_keywords_7, t0.meta_desc AS meta_desc_8, t0.data_id AS data_id_9 FROM kk_static_pages_ln t0 WHERE t0.data_id = ?
Parameters:
[
  4
]
0.23 ms
(11.96%)
2
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:
[]
0.21 ms
(10.67%)
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.13 ms
(6.46%)
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
]
0.11 ms
(5.90%)
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:
[
  "uk"
]
0.10 ms
(5.23%)
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
]

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.