Query Metrics
67
Database Queries
16
Different statements
36.48 ms
Query time
0
Invalid entities
Queries
| #▲ | Time | Info |
|---|---|---|
| 1 | 0.28 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 | 1.82 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.22 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 | 0.11 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.52 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.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:
[
1289
]
|
| 7 | 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:
[
1290
]
|
| 8 | 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:
[
1293
]
|
| 9 | 0.10 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.10 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.11 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.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:
[
1266
]
|
| 13 | 0.09 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.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:
[
1265
]
|
| 15 | 0.09 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.09 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.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:
[
1262
]
|
| 18 | 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:
[
1263
]
|
| 19 | 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:
[
1264
]
|
| 20 | 0.10 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.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:
[
1278
]
|
| 22 | 0.21 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.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:
[
1072
]
|
| 24 | 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:
[
1274
]
|
| 25 | 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:
[
1301
]
|
| 26 | 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:
[
1276
]
|
| 27 | 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:
[
1302
]
|
| 28 | 0.22 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.22 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.22 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.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:
[
1281
]
|
| 32 | 0.16 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.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:
[
1284
]
|
| 34 | 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:
[
1145
]
|
| 35 | 0.13 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 | 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:
[
1286
]
|
| 37 | 0.13 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.34 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.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:
[
1283
]
|
| 40 | 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:
[
1296
]
|
| 41 | 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:
[
1273
]
|
| 42 | 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:
[
1292
]
|
| 43 | 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:
[
1291
]
|
| 44 | 0.47 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.10 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.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:
[
1298
]
|
| 47 | 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:
[
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.77 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.27 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 | 0.93 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 1781890397 1781890397 1 ] |
| 52 | 0.24 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" ] |
| 53 | 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:
[
15
]
|
| 54 | 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
]
|
| 55 | 0.42 ms |
SELECT DATABASE()
Parameters:
[] |
| 56 | 5.88 ms |
SELECT TABLE_NAME FROM information_schema.TABLES WHERE TABLE_SCHEMA = ? AND TABLE_TYPE = 'BASE TABLE' ORDER BY TABLE_NAME
Parameters:
[
"elektrofortecia"
]
|
| 57 | 0.17 ms |
SELECT DATABASE()
Parameters:
[] |
| 58 | 4.19 ms |
SELECT TABLE_NAME FROM information_schema.TABLES WHERE TABLE_SCHEMA = ? AND TABLE_TYPE = 'BASE TABLE' ORDER BY TABLE_NAME
Parameters:
[
"elektrofortecia"
]
|
| 59 | 0.15 ms |
SELECT DATABASE()
Parameters:
[] |
| 60 | 0.73 ms |
SELECT t.TABLE_NAME, t.ENGINE, t.AUTO_INCREMENT, t.TABLE_COMMENT, t.CREATE_OPTIONS, t.TABLE_COLLATION, ccsa.CHARACTER_SET_NAME FROM information_schema.TABLES t INNER JOIN information_schema.COLLATION_CHARACTER_SET_APPLICABILITY ccsa ON /*M!101001 ccsa.FULL_COLLATION_NAME = t.TABLE_COLLATION OR */ ccsa.COLLATION_NAME = t.TABLE_COLLATION WHERE t.TABLE_SCHEMA = ? AND t.TABLE_NAME = ? AND t.TABLE_TYPE = 'BASE TABLE'
Parameters:
[ "elektrofortecia" "doctrine_migration_versions" ] |
| 61 | 0.08 ms |
SELECT DATABASE()
Parameters:
[] |
| 62 | 4.41 ms |
SELECT DISTINCT k.CONSTRAINT_NAME, k.COLUMN_NAME, k.REFERENCED_TABLE_NAME, k.REFERENCED_COLUMN_NAME, k.ORDINAL_POSITION /*!50116, c.UPDATE_RULE, c.DELETE_RULE */ FROM information_schema.key_column_usage k /*!50116 INNER JOIN information_schema.referential_constraints c ON c.CONSTRAINT_NAME = k.CONSTRAINT_NAME AND c.TABLE_NAME = k.TABLE_NAME */ WHERE k.TABLE_SCHEMA = ? AND k.TABLE_NAME = ? AND k.REFERENCED_COLUMN_NAME IS NOT NULL /*!50116 AND c.CONSTRAINT_SCHEMA = 'elektrofortecia' */ ORDER BY k.ORDINAL_POSITION
Parameters:
[ "elektrofortecia" "doctrine_migration_versions" ] |
| 63 | 4.21 ms |
SELECT c.COLUMN_NAME AS field, c.COLUMN_TYPE AS TYPE, c.IS_NULLABLE AS `null`, c.COLUMN_KEY AS `key`, c.COLUMN_DEFAULT AS `default`, c.EXTRA, c.COLUMN_COMMENT AS COMMENT, c.CHARACTER_SET_NAME AS characterset, c.COLLATION_NAME AS COLLATION FROM information_schema.COLUMNS c INNER JOIN information_schema.TABLES t ON t.TABLE_NAME = c.TABLE_NAME WHERE c.TABLE_SCHEMA = ? AND t.TABLE_SCHEMA = ? AND t.TABLE_TYPE = 'BASE TABLE' AND t.TABLE_NAME = ? ORDER BY ORDINAL_POSITION
Parameters:
[ "elektrofortecia" "elektrofortecia" "doctrine_migration_versions" ] |
| 64 | 0.18 ms |
SELECT DATABASE()
Parameters:
[] |
| 65 | 0.31 ms |
SELECT NON_UNIQUE AS Non_Unique, INDEX_NAME AS Key_name, COLUMN_NAME AS Column_Name, SUB_PART AS Sub_Part, INDEX_TYPE AS Index_Type FROM information_schema.STATISTICS WHERE TABLE_SCHEMA = ? AND TABLE_NAME = ? ORDER BY SEQ_IN_INDEX
Parameters:
[ "elektrofortecia" "doctrine_migration_versions" ] |
| 66 | 0.17 ms |
SELECT * FROM doctrine_migration_versions
Parameters:
[] |
| 67 | 0.30 ms |
SELECT DATABASE()
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\CoreBundle\Entity\DataLanguage | No errors. |
| SoftUa\ArticleBundle\Entity\Article | No errors. |
| SoftUa\ArticleBundle\Entity\ArticleTranslation | No errors. |
| SoftUa\HeaderNotificationBundle\Entity\StoreSettings | No errors. |
| SoftUa\HeaderNotificationBundle\Entity\StoreSettingsTranslation | No errors. |