Query Metrics

68 Database Queries
12 Different statements
33.88 ms Query time
0 Invalid entities

Queries

Group similar statements

# Time Info
1 0.32 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 2.14 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_.is_empty = 0 AND c0_.category_id > 0 AND (NOT (c0_.category_left BETWEEN 76 AND 553)) ORDER BY c0_.category_left ASC LIMIT 50
Parameters:
[]
3 0.91 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:
[
  "ru"
]
4 3.25 ms
SELECT t0.id AS id_1, t0.ln_id AS ln_id_2, t0.category_name AS category_name_3, t0.category_description AS category_description_4, t0.short_desc AS short_desc_5, t0.meta_title AS meta_title_6, t0.meta_keywords AS meta_keywords_7, t0.meta_description AS meta_description_8, t0.category_id AS category_id_9 FROM kk_categories_ln t0 WHERE t0.category_id = ?
Parameters:
[
  1270
]
5 0.45 ms
SELECT t0.id AS id_1, t0.ln_id AS ln_id_2, t0.category_name AS category_name_3, t0.category_description AS category_description_4, t0.short_desc AS short_desc_5, t0.meta_title AS meta_title_6, t0.meta_keywords AS meta_keywords_7, t0.meta_description AS meta_description_8, t0.category_id AS category_id_9 FROM kk_categories_ln t0 WHERE t0.category_id = ?
Parameters:
[
  1271
]
6 0.33 ms
SELECT t0.id AS id_1, t0.ln_id AS ln_id_2, t0.category_name AS category_name_3, t0.category_description AS category_description_4, t0.short_desc AS short_desc_5, t0.meta_title AS meta_title_6, t0.meta_keywords AS meta_keywords_7, t0.meta_description AS meta_description_8, t0.category_id AS category_id_9 FROM kk_categories_ln t0 WHERE t0.category_id = ?
Parameters:
[
  1289
]
7 0.20 ms
SELECT t0.id AS id_1, t0.ln_id AS ln_id_2, t0.category_name AS category_name_3, t0.category_description AS category_description_4, t0.short_desc AS short_desc_5, t0.meta_title AS meta_title_6, t0.meta_keywords AS meta_keywords_7, t0.meta_description AS meta_description_8, t0.category_id AS category_id_9 FROM kk_categories_ln t0 WHERE t0.category_id = ?
Parameters:
[
  1290
]
8 0.39 ms
SELECT t0.id AS id_1, t0.ln_id AS ln_id_2, t0.category_name AS category_name_3, t0.category_description AS category_description_4, t0.short_desc AS short_desc_5, t0.meta_title AS meta_title_6, t0.meta_keywords AS meta_keywords_7, t0.meta_description AS meta_description_8, t0.category_id AS category_id_9 FROM kk_categories_ln t0 WHERE t0.category_id = ?
Parameters:
[
  1293
]
9 0.42 ms
SELECT t0.id AS id_1, t0.ln_id AS ln_id_2, t0.category_name AS category_name_3, t0.category_description AS category_description_4, t0.short_desc AS short_desc_5, t0.meta_title AS meta_title_6, t0.meta_keywords AS meta_keywords_7, t0.meta_description AS meta_description_8, t0.category_id AS category_id_9 FROM kk_categories_ln t0 WHERE t0.category_id = ?
Parameters:
[
  1294
]
10 0.24 ms
SELECT t0.id AS id_1, t0.ln_id AS ln_id_2, t0.category_name AS category_name_3, t0.category_description AS category_description_4, t0.short_desc AS short_desc_5, t0.meta_title AS meta_title_6, t0.meta_keywords AS meta_keywords_7, t0.meta_description AS meta_description_8, t0.category_id AS category_id_9 FROM kk_categories_ln t0 WHERE t0.category_id = ?
Parameters:
[
  1259
]
11 0.23 ms
SELECT t0.id AS id_1, t0.ln_id AS ln_id_2, t0.category_name AS category_name_3, t0.category_description AS category_description_4, t0.short_desc AS short_desc_5, t0.meta_title AS meta_title_6, t0.meta_keywords AS meta_keywords_7, t0.meta_description AS meta_description_8, t0.category_id AS category_id_9 FROM kk_categories_ln t0 WHERE t0.category_id = ?
Parameters:
[
  1260
]
12 0.24 ms
SELECT t0.id AS id_1, t0.ln_id AS ln_id_2, t0.category_name AS category_name_3, t0.category_description AS category_description_4, t0.short_desc AS short_desc_5, t0.meta_title AS meta_title_6, t0.meta_keywords AS meta_keywords_7, t0.meta_description AS meta_description_8, t0.category_id AS category_id_9 FROM kk_categories_ln t0 WHERE t0.category_id = ?
Parameters:
[
  1266
]
13 0.25 ms
SELECT t0.id AS id_1, t0.ln_id AS ln_id_2, t0.category_name AS category_name_3, t0.category_description AS category_description_4, t0.short_desc AS short_desc_5, t0.meta_title AS meta_title_6, t0.meta_keywords AS meta_keywords_7, t0.meta_description AS meta_description_8, t0.category_id AS category_id_9 FROM kk_categories_ln t0 WHERE t0.category_id = ?
Parameters:
[
  1267
]
14 0.24 ms
SELECT t0.id AS id_1, t0.ln_id AS ln_id_2, t0.category_name AS category_name_3, t0.category_description AS category_description_4, t0.short_desc AS short_desc_5, t0.meta_title AS meta_title_6, t0.meta_keywords AS meta_keywords_7, t0.meta_description AS meta_description_8, t0.category_id AS category_id_9 FROM kk_categories_ln t0 WHERE t0.category_id = ?
Parameters:
[
  1265
]
15 0.26 ms
SELECT t0.id AS id_1, t0.ln_id AS ln_id_2, t0.category_name AS category_name_3, t0.category_description AS category_description_4, t0.short_desc AS short_desc_5, t0.meta_title AS meta_title_6, t0.meta_keywords AS meta_keywords_7, t0.meta_description AS meta_description_8, t0.category_id AS category_id_9 FROM kk_categories_ln t0 WHERE t0.category_id = ?
Parameters:
[
  1272
]
16 0.36 ms
SELECT t0.id AS id_1, t0.ln_id AS ln_id_2, t0.category_name AS category_name_3, t0.category_description AS category_description_4, t0.short_desc AS short_desc_5, t0.meta_title AS meta_title_6, t0.meta_keywords AS meta_keywords_7, t0.meta_description AS meta_description_8, t0.category_id AS category_id_9 FROM kk_categories_ln t0 WHERE t0.category_id = ?
Parameters:
[
  1261
]
17 0.49 ms
SELECT t0.id AS id_1, t0.ln_id AS ln_id_2, t0.category_name AS category_name_3, t0.category_description AS category_description_4, t0.short_desc AS short_desc_5, t0.meta_title AS meta_title_6, t0.meta_keywords AS meta_keywords_7, t0.meta_description AS meta_description_8, t0.category_id AS category_id_9 FROM kk_categories_ln t0 WHERE t0.category_id = ?
Parameters:
[
  1262
]
18 2.14 ms
SELECT t0.id AS id_1, t0.ln_id AS ln_id_2, t0.category_name AS category_name_3, t0.category_description AS category_description_4, t0.short_desc AS short_desc_5, t0.meta_title AS meta_title_6, t0.meta_keywords AS meta_keywords_7, t0.meta_description AS meta_description_8, t0.category_id AS category_id_9 FROM kk_categories_ln t0 WHERE t0.category_id = ?
Parameters:
[
  1263
]
19 0.40 ms
SELECT t0.id AS id_1, t0.ln_id AS ln_id_2, t0.category_name AS category_name_3, t0.category_description AS category_description_4, t0.short_desc AS short_desc_5, t0.meta_title AS meta_title_6, t0.meta_keywords AS meta_keywords_7, t0.meta_description AS meta_description_8, t0.category_id AS category_id_9 FROM kk_categories_ln t0 WHERE t0.category_id = ?
Parameters:
[
  1264
]
20 0.28 ms
SELECT t0.id AS id_1, t0.ln_id AS ln_id_2, t0.category_name AS category_name_3, t0.category_description AS category_description_4, t0.short_desc AS short_desc_5, t0.meta_title AS meta_title_6, t0.meta_keywords AS meta_keywords_7, t0.meta_description AS meta_description_8, t0.category_id AS category_id_9 FROM kk_categories_ln t0 WHERE t0.category_id = ?
Parameters:
[
  1269
]
21 0.30 ms
SELECT t0.id AS id_1, t0.ln_id AS ln_id_2, t0.category_name AS category_name_3, t0.category_description AS category_description_4, t0.short_desc AS short_desc_5, t0.meta_title AS meta_title_6, t0.meta_keywords AS meta_keywords_7, t0.meta_description AS meta_description_8, t0.category_id AS category_id_9 FROM kk_categories_ln t0 WHERE t0.category_id = ?
Parameters:
[
  1278
]
22 0.29 ms
SELECT t0.id AS id_1, t0.ln_id AS ln_id_2, t0.category_name AS category_name_3, t0.category_description AS category_description_4, t0.short_desc AS short_desc_5, t0.meta_title AS meta_title_6, t0.meta_keywords AS meta_keywords_7, t0.meta_description AS meta_description_8, t0.category_id AS category_id_9 FROM kk_categories_ln t0 WHERE t0.category_id = ?
Parameters:
[
  1297
]
23 0.26 ms
SELECT t0.id AS id_1, t0.ln_id AS ln_id_2, t0.category_name AS category_name_3, t0.category_description AS category_description_4, t0.short_desc AS short_desc_5, t0.meta_title AS meta_title_6, t0.meta_keywords AS meta_keywords_7, t0.meta_description AS meta_description_8, t0.category_id AS category_id_9 FROM kk_categories_ln t0 WHERE t0.category_id = ?
Parameters:
[
  1072
]
24 0.32 ms
SELECT t0.id AS id_1, t0.ln_id AS ln_id_2, t0.category_name AS category_name_3, t0.category_description AS category_description_4, t0.short_desc AS short_desc_5, t0.meta_title AS meta_title_6, t0.meta_keywords AS meta_keywords_7, t0.meta_description AS meta_description_8, t0.category_id AS category_id_9 FROM kk_categories_ln t0 WHERE t0.category_id = ?
Parameters:
[
  1274
]
25 0.31 ms
SELECT t0.id AS id_1, t0.ln_id AS ln_id_2, t0.category_name AS category_name_3, t0.category_description AS category_description_4, t0.short_desc AS short_desc_5, t0.meta_title AS meta_title_6, t0.meta_keywords AS meta_keywords_7, t0.meta_description AS meta_description_8, t0.category_id AS category_id_9 FROM kk_categories_ln t0 WHERE t0.category_id = ?
Parameters:
[
  1301
]
26 0.51 ms
SELECT t0.id AS id_1, t0.ln_id AS ln_id_2, t0.category_name AS category_name_3, t0.category_description AS category_description_4, t0.short_desc AS short_desc_5, t0.meta_title AS meta_title_6, t0.meta_keywords AS meta_keywords_7, t0.meta_description AS meta_description_8, t0.category_id AS category_id_9 FROM kk_categories_ln t0 WHERE t0.category_id = ?
Parameters:
[
  1276
]
27 0.68 ms
SELECT t0.id AS id_1, t0.ln_id AS ln_id_2, t0.category_name AS category_name_3, t0.category_description AS category_description_4, t0.short_desc AS short_desc_5, t0.meta_title AS meta_title_6, t0.meta_keywords AS meta_keywords_7, t0.meta_description AS meta_description_8, t0.category_id AS category_id_9 FROM kk_categories_ln t0 WHERE t0.category_id = ?
Parameters:
[
  1302
]
28 0.35 ms
SELECT t0.id AS id_1, t0.ln_id AS ln_id_2, t0.category_name AS category_name_3, t0.category_description AS category_description_4, t0.short_desc AS short_desc_5, t0.meta_title AS meta_title_6, t0.meta_keywords AS meta_keywords_7, t0.meta_description AS meta_description_8, t0.category_id AS category_id_9 FROM kk_categories_ln t0 WHERE t0.category_id = ?
Parameters:
[
  1303
]
29 0.31 ms
SELECT t0.id AS id_1, t0.ln_id AS ln_id_2, t0.category_name AS category_name_3, t0.category_description AS category_description_4, t0.short_desc AS short_desc_5, t0.meta_title AS meta_title_6, t0.meta_keywords AS meta_keywords_7, t0.meta_description AS meta_description_8, t0.category_id AS category_id_9 FROM kk_categories_ln t0 WHERE t0.category_id = ?
Parameters:
[
  1275
]
30 0.38 ms
SELECT t0.id AS id_1, t0.ln_id AS ln_id_2, t0.category_name AS category_name_3, t0.category_description AS category_description_4, t0.short_desc AS short_desc_5, t0.meta_title AS meta_title_6, t0.meta_keywords AS meta_keywords_7, t0.meta_description AS meta_description_8, t0.category_id AS category_id_9 FROM kk_categories_ln t0 WHERE t0.category_id = ?
Parameters:
[
  1280
]
31 0.36 ms
SELECT t0.id AS id_1, t0.ln_id AS ln_id_2, t0.category_name AS category_name_3, t0.category_description AS category_description_4, t0.short_desc AS short_desc_5, t0.meta_title AS meta_title_6, t0.meta_keywords AS meta_keywords_7, t0.meta_description AS meta_description_8, t0.category_id AS category_id_9 FROM kk_categories_ln t0 WHERE t0.category_id = ?
Parameters:
[
  1281
]
32 0.31 ms
SELECT t0.id AS id_1, t0.ln_id AS ln_id_2, t0.category_name AS category_name_3, t0.category_description AS category_description_4, t0.short_desc AS short_desc_5, t0.meta_title AS meta_title_6, t0.meta_keywords AS meta_keywords_7, t0.meta_description AS meta_description_8, t0.category_id AS category_id_9 FROM kk_categories_ln t0 WHERE t0.category_id = ?
Parameters:
[
  1279
]
33 0.36 ms
SELECT t0.id AS id_1, t0.ln_id AS ln_id_2, t0.category_name AS category_name_3, t0.category_description AS category_description_4, t0.short_desc AS short_desc_5, t0.meta_title AS meta_title_6, t0.meta_keywords AS meta_keywords_7, t0.meta_description AS meta_description_8, t0.category_id AS category_id_9 FROM kk_categories_ln t0 WHERE t0.category_id = ?
Parameters:
[
  1284
]
34 0.46 ms
SELECT t0.id AS id_1, t0.ln_id AS ln_id_2, t0.category_name AS category_name_3, t0.category_description AS category_description_4, t0.short_desc AS short_desc_5, t0.meta_title AS meta_title_6, t0.meta_keywords AS meta_keywords_7, t0.meta_description AS meta_description_8, t0.category_id AS category_id_9 FROM kk_categories_ln t0 WHERE t0.category_id = ?
Parameters:
[
  1145
]
35 1.15 ms
SELECT t0.id AS id_1, t0.ln_id AS ln_id_2, t0.category_name AS category_name_3, t0.category_description AS category_description_4, t0.short_desc AS short_desc_5, t0.meta_title AS meta_title_6, t0.meta_keywords AS meta_keywords_7, t0.meta_description AS meta_description_8, t0.category_id AS category_id_9 FROM kk_categories_ln t0 WHERE t0.category_id = ?
Parameters:
[
  1277
]
36 1.07 ms
SELECT t0.id AS id_1, t0.ln_id AS ln_id_2, t0.category_name AS category_name_3, t0.category_description AS category_description_4, t0.short_desc AS short_desc_5, t0.meta_title AS meta_title_6, t0.meta_keywords AS meta_keywords_7, t0.meta_description AS meta_description_8, t0.category_id AS category_id_9 FROM kk_categories_ln t0 WHERE t0.category_id = ?
Parameters:
[
  1286
]
37 0.72 ms
SELECT t0.id AS id_1, t0.ln_id AS ln_id_2, t0.category_name AS category_name_3, t0.category_description AS category_description_4, t0.short_desc AS short_desc_5, t0.meta_title AS meta_title_6, t0.meta_keywords AS meta_keywords_7, t0.meta_description AS meta_description_8, t0.category_id AS category_id_9 FROM kk_categories_ln t0 WHERE t0.category_id = ?
Parameters:
[
  1287
]
38 0.69 ms
SELECT t0.id AS id_1, t0.ln_id AS ln_id_2, t0.category_name AS category_name_3, t0.category_description AS category_description_4, t0.short_desc AS short_desc_5, t0.meta_title AS meta_title_6, t0.meta_keywords AS meta_keywords_7, t0.meta_description AS meta_description_8, t0.category_id AS category_id_9 FROM kk_categories_ln t0 WHERE t0.category_id = ?
Parameters:
[
  1288
]
39 0.68 ms
SELECT t0.id AS id_1, t0.ln_id AS ln_id_2, t0.category_name AS category_name_3, t0.category_description AS category_description_4, t0.short_desc AS short_desc_5, t0.meta_title AS meta_title_6, t0.meta_keywords AS meta_keywords_7, t0.meta_description AS meta_description_8, t0.category_id AS category_id_9 FROM kk_categories_ln t0 WHERE t0.category_id = ?
Parameters:
[
  1283
]
40 0.74 ms
SELECT t0.id AS id_1, t0.ln_id AS ln_id_2, t0.category_name AS category_name_3, t0.category_description AS category_description_4, t0.short_desc AS short_desc_5, t0.meta_title AS meta_title_6, t0.meta_keywords AS meta_keywords_7, t0.meta_description AS meta_description_8, t0.category_id AS category_id_9 FROM kk_categories_ln t0 WHERE t0.category_id = ?
Parameters:
[
  1296
]
41 0.65 ms
SELECT t0.id AS id_1, t0.ln_id AS ln_id_2, t0.category_name AS category_name_3, t0.category_description AS category_description_4, t0.short_desc AS short_desc_5, t0.meta_title AS meta_title_6, t0.meta_keywords AS meta_keywords_7, t0.meta_description AS meta_description_8, t0.category_id AS category_id_9 FROM kk_categories_ln t0 WHERE t0.category_id = ?
Parameters:
[
  1273
]
42 0.46 ms
SELECT t0.id AS id_1, t0.ln_id AS ln_id_2, t0.category_name AS category_name_3, t0.category_description AS category_description_4, t0.short_desc AS short_desc_5, t0.meta_title AS meta_title_6, t0.meta_keywords AS meta_keywords_7, t0.meta_description AS meta_description_8, t0.category_id AS category_id_9 FROM kk_categories_ln t0 WHERE t0.category_id = ?
Parameters:
[
  1292
]
43 0.29 ms
SELECT t0.id AS id_1, t0.ln_id AS ln_id_2, t0.category_name AS category_name_3, t0.category_description AS category_description_4, t0.short_desc AS short_desc_5, t0.meta_title AS meta_title_6, t0.meta_keywords AS meta_keywords_7, t0.meta_description AS meta_description_8, t0.category_id AS category_id_9 FROM kk_categories_ln t0 WHERE t0.category_id = ?
Parameters:
[
  1291
]
44 0.27 ms
SELECT t0.id AS id_1, t0.ln_id AS ln_id_2, t0.category_name AS category_name_3, t0.category_description AS category_description_4, t0.short_desc AS short_desc_5, t0.meta_title AS meta_title_6, t0.meta_keywords AS meta_keywords_7, t0.meta_description AS meta_description_8, t0.category_id AS category_id_9 FROM kk_categories_ln t0 WHERE t0.category_id = ?
Parameters:
[
  1285
]
45 0.92 ms
SELECT t0.id AS id_1, t0.ln_id AS ln_id_2, t0.category_name AS category_name_3, t0.category_description AS category_description_4, t0.short_desc AS short_desc_5, t0.meta_title AS meta_title_6, t0.meta_keywords AS meta_keywords_7, t0.meta_description AS meta_description_8, t0.category_id AS category_id_9 FROM kk_categories_ln t0 WHERE t0.category_id = ?
Parameters:
[
  1295
]
46 0.54 ms
SELECT t0.id AS id_1, t0.ln_id AS ln_id_2, t0.category_name AS category_name_3, t0.category_description AS category_description_4, t0.short_desc AS short_desc_5, t0.meta_title AS meta_title_6, t0.meta_keywords AS meta_keywords_7, t0.meta_description AS meta_description_8, t0.category_id AS category_id_9 FROM kk_categories_ln t0 WHERE t0.category_id = ?
Parameters:
[
  1298
]
47 0.31 ms
SELECT t0.id AS id_1, t0.ln_id AS ln_id_2, t0.category_name AS category_name_3, t0.category_description AS category_description_4, t0.short_desc AS short_desc_5, t0.meta_title AS meta_title_6, t0.meta_keywords AS meta_keywords_7, t0.meta_description AS meta_description_8, t0.category_id AS category_id_9 FROM kk_categories_ln t0 WHERE t0.category_id = ?
Parameters:
[
  1299
]
48 0.29 ms
SELECT t0.id AS id_1, t0.ln_id AS ln_id_2, t0.category_name AS category_name_3, t0.category_description AS category_description_4, t0.short_desc AS short_desc_5, t0.meta_title AS meta_title_6, t0.meta_keywords AS meta_keywords_7, t0.meta_description AS meta_description_8, t0.category_id AS category_id_9 FROM kk_categories_ln t0 WHERE t0.category_id = ?
Parameters:
[
  1093
]
49 0.85 ms
SELECT COUNT(DISTINCT c0_.category_id) AS sclr_0 FROM Categories c0_ WHERE c0_.active = 1 AND c0_.is_empty = 0 AND c0_.category_id > 0 AND (NOT (c0_.category_left BETWEEN 76 AND 553)) ORDER BY c0_.category_id ASC
Parameters:
[]
50 0.26 ms
SELECT n0_.id AS id_0, n0_.name AS name_1, n0_.description AS description_2, n0_.preview_text AS preview_text_3, n0_.code AS code_4, n0_.weight AS weight_5, n0_.is_section AS is_section_6, n0_.active AS active_7, n0_.pic AS pic_8, n0_.meta_title AS meta_title_9, n0_.meta_keywords AS meta_keywords_10, n0_.meta_desc AS meta_desc_11, n0_.views AS views_12, n0_.date AS date_13, n0_.date_start AS date_start_14, n0_.date_finish AS date_finish_15, n0_.p_id AS p_id_16 FROM news_data n0_ WHERE n0_.active = ? AND n0_.is_section = ? AND n0_.code = ? ORDER BY n0_.id ASC LIMIT 1
Parameters:
[
  1
  1
  "news"
]
51 1.00 ms
SELECT n0_.id AS id_0, n0_.name AS name_1, n0_.description AS description_2, n0_.preview_text AS preview_text_3, n0_.code AS code_4, n0_.weight AS weight_5, n0_.is_section AS is_section_6, n0_.active AS active_7, n0_.pic AS pic_8, n0_.meta_title AS meta_title_9, n0_.meta_keywords AS meta_keywords_10, n0_.meta_desc AS meta_desc_11, n0_.views AS views_12, n0_.date AS date_13, n0_.date_start AS date_start_14, n0_.date_finish AS date_finish_15, k1_.id AS id_16, k1_.ln_id AS ln_id_17, k1_.name AS name_18, k1_.description AS description_19, k1_.preview_text AS preview_text_20, k1_.meta_title AS meta_title_21, k1_.meta_keywords AS meta_keywords_22, k1_.meta_desc AS meta_desc_23, n0_.p_id AS p_id_24, k1_.data_id AS data_id_25 FROM news_data n0_ LEFT JOIN kk_news_data_ln k1_ ON n0_.id = k1_.data_id WHERE n0_.active = ? AND n0_.is_section = ? AND (n0_.date_start IS NULL OR n0_.date_start <= ?) AND (n0_.date_finish IS NULL OR n0_.date_finish >= ?) AND n0_.p_id = ? ORDER BY n0_.date DESC, n0_.weight ASC, n0_.name ASC LIMIT 20
Parameters:
[
  1
  0
  1785889020
  1785889020
  1
]
52 0.34 ms
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, k1_.id AS id_10, k1_.ln_id AS ln_id_11, k1_.name AS name_12, k1_.description AS description_13, k1_.preview_text AS preview_text_14, k1_.meta_title AS meta_title_15, k1_.meta_keywords AS meta_keywords_16, k1_.meta_desc AS meta_desc_17, k1_.data_id AS data_id_18 FROM static_pages s0_ LEFT JOIN kk_static_pages_ln k1_ ON s0_.id = k1_.data_id WHERE s0_.active = ? ORDER BY s0_.weight ASC LIMIT 20
Parameters:
[
  1
]
53 0.39 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"
]
54 0.81 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
]
55 0.32 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
]
56 0.54 ms
SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.lft AS lft_2, s0_.level AS level_3, s0_.rgt AS rgt_4, s0_.is_published AS is_published_5, s0_.is_active AS is_active_6, s0_.is_menu_item AS is_menu_item_7, s0_.is_hot_filter AS is_hot_filter_8, s0_.img AS img_9, s0_.filters AS filters_10, s0_.category_id AS category_id_11 FROM site_menu s0_ WHERE s0_.id = ? AND s0_.is_active = 1 AND s0_.is_menu_item = 1 LIMIT 1
Parameters:
[
  1
]
57 0.25 ms
SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.lft AS lft_2, s0_.level AS level_3, s0_.rgt AS rgt_4, s0_.is_published AS is_published_5, s0_.is_active AS is_active_6, s0_.is_menu_item AS is_menu_item_7, s0_.is_hot_filter AS is_hot_filter_8, s0_.img AS img_9, s0_.filters AS filters_10, k1_.id AS id_11, k1_.ln_id AS ln_id_12, k1_.name AS name_13, s0_.category_id AS category_id_14, k1_.menu_id AS menu_id_15 FROM site_menu s0_ LEFT JOIN kk_site_menu_ln k1_ ON s0_.id = k1_.menu_id WHERE s0_.is_active = 1 AND s0_.lft > ? AND s0_.rgt < ? AND s0_.level = ? AND s0_.id > 0 AND s0_.is_menu_item = ? ORDER BY s0_.lft ASC
Parameters:
[
  2
  87
  2
  1
]
58 0.13 ms
SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.lft AS lft_2, s0_.level AS level_3, s0_.rgt AS rgt_4, s0_.is_published AS is_published_5, s0_.is_active AS is_active_6, s0_.is_menu_item AS is_menu_item_7, s0_.is_hot_filter AS is_hot_filter_8, s0_.img AS img_9, s0_.filters AS filters_10, k1_.id AS id_11, k1_.ln_id AS ln_id_12, k1_.name AS name_13, s0_.category_id AS category_id_14, k1_.menu_id AS menu_id_15 FROM site_menu s0_ LEFT JOIN kk_site_menu_ln k1_ ON s0_.id = k1_.menu_id WHERE s0_.is_active = 1 AND s0_.lft > ? AND s0_.rgt < ? AND s0_.level = ? AND s0_.id > 0 AND s0_.is_menu_item = ? ORDER BY s0_.lft ASC
Parameters:
[
  3
  14
  3
  1
]
59 0.12 ms
SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.lft AS lft_2, s0_.level AS level_3, s0_.rgt AS rgt_4, s0_.is_published AS is_published_5, s0_.is_active AS is_active_6, s0_.is_menu_item AS is_menu_item_7, s0_.is_hot_filter AS is_hot_filter_8, s0_.img AS img_9, s0_.filters AS filters_10, k1_.id AS id_11, k1_.ln_id AS ln_id_12, k1_.name AS name_13, s0_.category_id AS category_id_14, k1_.menu_id AS menu_id_15 FROM site_menu s0_ LEFT JOIN kk_site_menu_ln k1_ ON s0_.id = k1_.menu_id WHERE s0_.is_active = 1 AND s0_.lft > ? AND s0_.rgt < ? AND s0_.level = ? AND s0_.id > 0 AND s0_.is_menu_item = ? ORDER BY s0_.lft ASC
Parameters:
[
  15
  24
  3
  1
]
60 0.14 ms
SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.lft AS lft_2, s0_.level AS level_3, s0_.rgt AS rgt_4, s0_.is_published AS is_published_5, s0_.is_active AS is_active_6, s0_.is_menu_item AS is_menu_item_7, s0_.is_hot_filter AS is_hot_filter_8, s0_.img AS img_9, s0_.filters AS filters_10, k1_.id AS id_11, k1_.ln_id AS ln_id_12, k1_.name AS name_13, s0_.category_id AS category_id_14, k1_.menu_id AS menu_id_15 FROM site_menu s0_ LEFT JOIN kk_site_menu_ln k1_ ON s0_.id = k1_.menu_id WHERE s0_.is_active = 1 AND s0_.lft > ? AND s0_.rgt < ? AND s0_.level = ? AND s0_.id > 0 AND s0_.is_menu_item = ? ORDER BY s0_.lft ASC
Parameters:
[
  25
  36
  3
  1
]
61 0.12 ms
SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.lft AS lft_2, s0_.level AS level_3, s0_.rgt AS rgt_4, s0_.is_published AS is_published_5, s0_.is_active AS is_active_6, s0_.is_menu_item AS is_menu_item_7, s0_.is_hot_filter AS is_hot_filter_8, s0_.img AS img_9, s0_.filters AS filters_10, k1_.id AS id_11, k1_.ln_id AS ln_id_12, k1_.name AS name_13, s0_.category_id AS category_id_14, k1_.menu_id AS menu_id_15 FROM site_menu s0_ LEFT JOIN kk_site_menu_ln k1_ ON s0_.id = k1_.menu_id WHERE s0_.is_active = 1 AND s0_.lft > ? AND s0_.rgt < ? AND s0_.level = ? AND s0_.id > 0 AND s0_.is_menu_item = ? ORDER BY s0_.lft ASC
Parameters:
[
  37
  44
  3
  1
]
62 0.12 ms
SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.lft AS lft_2, s0_.level AS level_3, s0_.rgt AS rgt_4, s0_.is_published AS is_published_5, s0_.is_active AS is_active_6, s0_.is_menu_item AS is_menu_item_7, s0_.is_hot_filter AS is_hot_filter_8, s0_.img AS img_9, s0_.filters AS filters_10, k1_.id AS id_11, k1_.ln_id AS ln_id_12, k1_.name AS name_13, s0_.category_id AS category_id_14, k1_.menu_id AS menu_id_15 FROM site_menu s0_ LEFT JOIN kk_site_menu_ln k1_ ON s0_.id = k1_.menu_id WHERE s0_.is_active = 1 AND s0_.lft > ? AND s0_.rgt < ? AND s0_.level = ? AND s0_.id > 0 AND s0_.is_menu_item = ? ORDER BY s0_.lft ASC
Parameters:
[
  45
  52
  3
  1
]
63 0.16 ms
SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.lft AS lft_2, s0_.level AS level_3, s0_.rgt AS rgt_4, s0_.is_published AS is_published_5, s0_.is_active AS is_active_6, s0_.is_menu_item AS is_menu_item_7, s0_.is_hot_filter AS is_hot_filter_8, s0_.img AS img_9, s0_.filters AS filters_10, k1_.id AS id_11, k1_.ln_id AS ln_id_12, k1_.name AS name_13, s0_.category_id AS category_id_14, k1_.menu_id AS menu_id_15 FROM site_menu s0_ LEFT JOIN kk_site_menu_ln k1_ ON s0_.id = k1_.menu_id WHERE s0_.is_active = 1 AND s0_.lft > ? AND s0_.rgt < ? AND s0_.level = ? AND s0_.id > 0 AND s0_.is_menu_item = ? ORDER BY s0_.lft ASC
Parameters:
[
  53
  58
  3
  1
]
64 0.10 ms
SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.lft AS lft_2, s0_.level AS level_3, s0_.rgt AS rgt_4, s0_.is_published AS is_published_5, s0_.is_active AS is_active_6, s0_.is_menu_item AS is_menu_item_7, s0_.is_hot_filter AS is_hot_filter_8, s0_.img AS img_9, s0_.filters AS filters_10, k1_.id AS id_11, k1_.ln_id AS ln_id_12, k1_.name AS name_13, s0_.category_id AS category_id_14, k1_.menu_id AS menu_id_15 FROM site_menu s0_ LEFT JOIN kk_site_menu_ln k1_ ON s0_.id = k1_.menu_id WHERE s0_.is_active = 1 AND s0_.lft > ? AND s0_.rgt < ? AND s0_.level = ? AND s0_.id > 0 AND s0_.is_menu_item = ? ORDER BY s0_.lft ASC
Parameters:
[
  59
  66
  3
  1
]
65 0.11 ms
SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.lft AS lft_2, s0_.level AS level_3, s0_.rgt AS rgt_4, s0_.is_published AS is_published_5, s0_.is_active AS is_active_6, s0_.is_menu_item AS is_menu_item_7, s0_.is_hot_filter AS is_hot_filter_8, s0_.img AS img_9, s0_.filters AS filters_10, k1_.id AS id_11, k1_.ln_id AS ln_id_12, k1_.name AS name_13, s0_.category_id AS category_id_14, k1_.menu_id AS menu_id_15 FROM site_menu s0_ LEFT JOIN kk_site_menu_ln k1_ ON s0_.id = k1_.menu_id WHERE s0_.is_active = 1 AND s0_.lft > ? AND s0_.rgt < ? AND s0_.level = ? AND s0_.id > 0 AND s0_.is_menu_item = ? ORDER BY s0_.lft ASC
Parameters:
[
  67
  70
  3
  1
]
66 0.12 ms
SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.lft AS lft_2, s0_.level AS level_3, s0_.rgt AS rgt_4, s0_.is_published AS is_published_5, s0_.is_active AS is_active_6, s0_.is_menu_item AS is_menu_item_7, s0_.is_hot_filter AS is_hot_filter_8, s0_.img AS img_9, s0_.filters AS filters_10, k1_.id AS id_11, k1_.ln_id AS ln_id_12, k1_.name AS name_13, s0_.category_id AS category_id_14, k1_.menu_id AS menu_id_15 FROM site_menu s0_ LEFT JOIN kk_site_menu_ln k1_ ON s0_.id = k1_.menu_id WHERE s0_.is_active = 1 AND s0_.lft > ? AND s0_.rgt < ? AND s0_.level = ? AND s0_.id > 0 AND s0_.is_menu_item = ? ORDER BY s0_.lft ASC
Parameters:
[
  77
  82
  3
  1
]
67 0.33 ms
SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.lft AS lft_2, s0_.level AS level_3, s0_.rgt AS rgt_4, s0_.is_published AS is_published_5, s0_.is_active AS is_active_6, s0_.is_menu_item AS is_menu_item_7, s0_.is_hot_filter AS is_hot_filter_8, s0_.img AS img_9, s0_.filters AS filters_10, s0_.category_id AS category_id_11 FROM site_menu s0_ WHERE s0_.id = ? AND s0_.is_active = 1 AND s0_.is_menu_item = 1 LIMIT 1
Parameters:
[
  2
]
68 0.17 ms
SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.lft AS lft_2, s0_.level AS level_3, s0_.rgt AS rgt_4, s0_.is_published AS is_published_5, s0_.is_active AS is_active_6, s0_.is_menu_item AS is_menu_item_7, s0_.is_hot_filter AS is_hot_filter_8, s0_.img AS img_9, s0_.filters AS filters_10, k1_.id AS id_11, k1_.ln_id AS ln_id_12, k1_.name AS name_13, s0_.category_id AS category_id_14, k1_.menu_id AS menu_id_15 FROM site_menu s0_ LEFT JOIN kk_site_menu_ln k1_ ON s0_.id = k1_.menu_id WHERE s0_.is_active = 1 AND s0_.lft > ? AND s0_.rgt < ? AND s0_.level = ? AND s0_.id > 0 AND s0_.is_menu_item = ? ORDER BY s0_.lft ASC
Parameters:
[
  88
  89
  2
  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.