Query Metrics
82
Database Queries
24
Different statements
179.16 ms
Query time
0
Invalid entities
Queries
| #▲ | Time | Info |
|---|---|---|
| 1 | 1.11 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 | 0.60 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_.code = ? AND (NOT (c0_.category_left BETWEEN 76 AND 553)) ORDER BY c0_.category_id ASC LIMIT 1
Parameters:
[
"rozetki-vimikach"
]
|
| 3 | 0.68 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.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:
[
1278
]
|
| 5 | 1.03 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
]
|
| 6 | 0.38 ms |
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:
[] |
| 7 | 0.10 ms |
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:
[] |
| 8 | 0.41 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
]
|
| 9 | 0.64 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_.category_left < ? AND c0_.category_right > ? AND c0_.category_id > 0 ORDER BY c0_.category_left ASC
Parameters:
[ 36 39 ] |
| 10 | 0.86 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, k1_.id AS id_15, k1_.ln_id AS ln_id_16, k1_.category_name AS category_name_17, k1_.category_description AS category_description_18, k1_.short_desc AS short_desc_19, k1_.meta_title AS meta_title_20, k1_.meta_keywords AS meta_keywords_21, k1_.meta_description AS meta_description_22, k1_.category_id AS category_id_23 FROM Categories c0_ LEFT JOIN kk_categories_ln k1_ ON c0_.category_id = k1_.category_id WHERE c0_.active = 1 AND c0_.category_left > ? AND c0_.category_right < ? AND c0_.category_level = ? AND c0_.category_id > 0 AND c0_.is_empty = 0 ORDER BY c0_.category_left ASC
Parameters:
[ 36 39 2 ] |
| 11 | 0.66 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_.category_id = ? AND (NOT (c0_.category_left BETWEEN 76 AND 553)) LIMIT 1
Parameters:
[
1297
]
|
| 12 | 115.91 ms |
SELECT p0_.product_id AS product_id_0, p0_.product AS product_1, p0_.pn AS pn_2, p0_.description AS description_3, p0_.detail_description AS detail_description_4, p0_.deleted AS deleted_5, p0_.pic AS pic_6, p0_.warranty AS warranty_7, p0_.cost_min AS cost_min_8, p0_.create_time AS create_time_9, s1_.product_id AS product_id_10, s1_.group_id AS group_id_11, s1_.product_type AS product_type_12, s1_.is_show_in_catalog AS is_show_in_catalog_13, s1_.presence AS presence_14, s1_.presence_str AS presence_str_15, s1_.rating AS rating_16, p2_.product_id AS product_id_17, p2_.url_code AS url_code_18, p2_.rating AS rating_19, p2_.seo_title AS seo_title_20, p2_.seo_description AS seo_description_21, p2_.seo_keyword AS seo_keyword_22, p3_.id AS id_23, p3_.default AS default_24, p3_.change_data AS change_data_25, p3_.show_img AS show_img_26, p3_.show_price AS show_price_27, p3_.show_presence AS show_presence_28, p3_.features_sharing AS features_sharing_29, p3_.manual_sharing AS manual_sharing_30, p3_.features AS features_31, p0_.category_id AS category_id_32, s1_.category_id AS category_id_33, s1_.catalog_product_id AS catalog_product_id_34, s1_.product_id AS product_id_35, p2_.product_id AS product_id_36, p3_.product_id AS product_id_37 FROM Products p0_ INNER JOIN sf_product_index s1_ ON p0_.product_id = s1_.product_id INNER JOIN Products_Data p2_ ON p0_.product_id = p2_.product_id LEFT JOIN products_groups p3_ ON p0_.product_id = p3_.product_id INNER JOIN Products_Categoryes p5_ ON p0_.product_id = p5_.product_id INNER JOIN Categories c4_ ON c4_.category_id = p5_.category_id WHERE p0_.deleted = 0 AND p2_.url_code <> '' AND c4_.category_left >= ? AND c4_.category_right <= ? AND s1_.is_show_in_catalog = ? AND s1_.presence >= ? ORDER BY IF(s1_.presence = 0, 1, 0) ASC, s1_.rating DESC LIMIT 60
Parameters:
[ 37 38 1 1 ] |
| 13 | 1.10 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" ] |
| 14 | 0.92 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
]
|
| 15 | 0.35 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
]
|
| 16 | 2.14 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
]
|
| 17 | 0.85 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
]
|
| 18 | 1.29 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 ] |
| 19 | 0.78 ms |
SELECT t0.category_id AS category_id_1, t0.category_name AS category_name_2, t0.category_left AS category_left_3, t0.category_level AS category_level_4, t0.category_right AS category_right_5, t0.description AS description_6, t0.short_desc AS short_desc_7, t0.code AS code_8, t0.img AS img_9, t0.meta_title AS meta_title_10, t0.meta_keywords AS meta_keywords_11, t0.meta_description AS meta_description_12, t0.active AS active_13, t0.is_empty AS is_empty_14, t0.category_top AS category_top_15 FROM Categories t0 WHERE t0.category_id = ?
Parameters:
[
1259
]
|
| 20 | 0.79 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 ] |
| 21 | 0.36 ms |
SELECT t0.category_id AS category_id_1, t0.category_name AS category_name_2, t0.category_left AS category_left_3, t0.category_level AS category_level_4, t0.category_right AS category_right_5, t0.description AS description_6, t0.short_desc AS short_desc_7, t0.code AS code_8, t0.img AS img_9, t0.meta_title AS meta_title_10, t0.meta_keywords AS meta_keywords_11, t0.meta_description AS meta_description_12, t0.active AS active_13, t0.is_empty AS is_empty_14, t0.category_top AS category_top_15 FROM Categories t0 WHERE t0.category_id = ?
Parameters:
[
1260
]
|
| 22 | 0.36 ms |
SELECT t0.category_id AS category_id_1, t0.category_name AS category_name_2, t0.category_left AS category_left_3, t0.category_level AS category_level_4, t0.category_right AS category_right_5, t0.description AS description_6, t0.short_desc AS short_desc_7, t0.code AS code_8, t0.img AS img_9, t0.meta_title AS meta_title_10, t0.meta_keywords AS meta_keywords_11, t0.meta_description AS meta_description_12, t0.active AS active_13, t0.is_empty AS is_empty_14, t0.category_top AS category_top_15 FROM Categories t0 WHERE t0.category_id = ?
Parameters:
[
1265
]
|
| 23 | 0.35 ms |
SELECT t0.category_id AS category_id_1, t0.category_name AS category_name_2, t0.category_left AS category_left_3, t0.category_level AS category_level_4, t0.category_right AS category_right_5, t0.description AS description_6, t0.short_desc AS short_desc_7, t0.code AS code_8, t0.img AS img_9, t0.meta_title AS meta_title_10, t0.meta_keywords AS meta_keywords_11, t0.meta_description AS meta_description_12, t0.active AS active_13, t0.is_empty AS is_empty_14, t0.category_top AS category_top_15 FROM Categories t0 WHERE t0.category_id = ?
Parameters:
[
1266
]
|
| 24 | 0.35 ms |
SELECT t0.category_id AS category_id_1, t0.category_name AS category_name_2, t0.category_left AS category_left_3, t0.category_level AS category_level_4, t0.category_right AS category_right_5, t0.description AS description_6, t0.short_desc AS short_desc_7, t0.code AS code_8, t0.img AS img_9, t0.meta_title AS meta_title_10, t0.meta_keywords AS meta_keywords_11, t0.meta_description AS meta_description_12, t0.active AS active_13, t0.is_empty AS is_empty_14, t0.category_top AS category_top_15 FROM Categories t0 WHERE t0.category_id = ?
Parameters:
[
1267
]
|
| 25 | 0.36 ms |
SELECT t0.category_id AS category_id_1, t0.category_name AS category_name_2, t0.category_left AS category_left_3, t0.category_level AS category_level_4, t0.category_right AS category_right_5, t0.description AS description_6, t0.short_desc AS short_desc_7, t0.code AS code_8, t0.img AS img_9, t0.meta_title AS meta_title_10, t0.meta_keywords AS meta_keywords_11, t0.meta_description AS meta_description_12, t0.active AS active_13, t0.is_empty AS is_empty_14, t0.category_top AS category_top_15 FROM Categories t0 WHERE t0.category_id = ?
Parameters:
[
1272
]
|
| 26 | 0.31 ms |
SELECT t0.category_id AS category_id_1, t0.category_name AS category_name_2, t0.category_left AS category_left_3, t0.category_level AS category_level_4, t0.category_right AS category_right_5, t0.description AS description_6, t0.short_desc AS short_desc_7, t0.code AS code_8, t0.img AS img_9, t0.meta_title AS meta_title_10, t0.meta_keywords AS meta_keywords_11, t0.meta_description AS meta_description_12, t0.active AS active_13, t0.is_empty AS is_empty_14, t0.category_top AS category_top_15 FROM Categories t0 WHERE t0.category_id = ?
Parameters:
[
1261
]
|
| 27 | 0.89 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 ] |
| 28 | 0.33 ms |
SELECT t0.category_id AS category_id_1, t0.category_name AS category_name_2, t0.category_left AS category_left_3, t0.category_level AS category_level_4, t0.category_right AS category_right_5, t0.description AS description_6, t0.short_desc AS short_desc_7, t0.code AS code_8, t0.img AS img_9, t0.meta_title AS meta_title_10, t0.meta_keywords AS meta_keywords_11, t0.meta_description AS meta_description_12, t0.active AS active_13, t0.is_empty AS is_empty_14, t0.category_top AS category_top_15 FROM Categories t0 WHERE t0.category_id = ?
Parameters:
[
1262
]
|
| 29 | 0.50 ms |
SELECT t0.category_id AS category_id_1, t0.category_name AS category_name_2, t0.category_left AS category_left_3, t0.category_level AS category_level_4, t0.category_right AS category_right_5, t0.description AS description_6, t0.short_desc AS short_desc_7, t0.code AS code_8, t0.img AS img_9, t0.meta_title AS meta_title_10, t0.meta_keywords AS meta_keywords_11, t0.meta_description AS meta_description_12, t0.active AS active_13, t0.is_empty AS is_empty_14, t0.category_top AS category_top_15 FROM Categories t0 WHERE t0.category_id = ?
Parameters:
[
1263
]
|
| 30 | 0.67 ms |
SELECT t0.category_id AS category_id_1, t0.category_name AS category_name_2, t0.category_left AS category_left_3, t0.category_level AS category_level_4, t0.category_right AS category_right_5, t0.description AS description_6, t0.short_desc AS short_desc_7, t0.code AS code_8, t0.img AS img_9, t0.meta_title AS meta_title_10, t0.meta_keywords AS meta_keywords_11, t0.meta_description AS meta_description_12, t0.active AS active_13, t0.is_empty AS is_empty_14, t0.category_top AS category_top_15 FROM Categories t0 WHERE t0.category_id = ?
Parameters:
[
1264
]
|
| 31 | 0.40 ms |
SELECT t0.category_id AS category_id_1, t0.category_name AS category_name_2, t0.category_left AS category_left_3, t0.category_level AS category_level_4, t0.category_right AS category_right_5, t0.description AS description_6, t0.short_desc AS short_desc_7, t0.code AS code_8, t0.img AS img_9, t0.meta_title AS meta_title_10, t0.meta_keywords AS meta_keywords_11, t0.meta_description AS meta_description_12, t0.active AS active_13, t0.is_empty AS is_empty_14, t0.category_top AS category_top_15 FROM Categories t0 WHERE t0.category_id = ?
Parameters:
[
1269
]
|
| 32 | 0.50 ms |
SELECT t0.category_id AS category_id_1, t0.category_name AS category_name_2, t0.category_left AS category_left_3, t0.category_level AS category_level_4, t0.category_right AS category_right_5, t0.description AS description_6, t0.short_desc AS short_desc_7, t0.code AS code_8, t0.img AS img_9, t0.meta_title AS meta_title_10, t0.meta_keywords AS meta_keywords_11, t0.meta_description AS meta_description_12, t0.active AS active_13, t0.is_empty AS is_empty_14, t0.category_top AS category_top_15 FROM Categories t0 WHERE t0.category_id = ?
Parameters:
[
1270
]
|
| 33 | 0.81 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 ] |
| 34 | 0.43 ms |
SELECT t0.category_id AS category_id_1, t0.category_name AS category_name_2, t0.category_left AS category_left_3, t0.category_level AS category_level_4, t0.category_right AS category_right_5, t0.description AS description_6, t0.short_desc AS short_desc_7, t0.code AS code_8, t0.img AS img_9, t0.meta_title AS meta_title_10, t0.meta_keywords AS meta_keywords_11, t0.meta_description AS meta_description_12, t0.active AS active_13, t0.is_empty AS is_empty_14, t0.category_top AS category_top_15 FROM Categories t0 WHERE t0.category_id = ?
Parameters:
[
1271
]
|
| 35 | 0.33 ms |
SELECT t0.category_id AS category_id_1, t0.category_name AS category_name_2, t0.category_left AS category_left_3, t0.category_level AS category_level_4, t0.category_right AS category_right_5, t0.description AS description_6, t0.short_desc AS short_desc_7, t0.code AS code_8, t0.img AS img_9, t0.meta_title AS meta_title_10, t0.meta_keywords AS meta_keywords_11, t0.meta_description AS meta_description_12, t0.active AS active_13, t0.is_empty AS is_empty_14, t0.category_top AS category_top_15 FROM Categories t0 WHERE t0.category_id = ?
Parameters:
[
1289
]
|
| 36 | 0.28 ms |
SELECT t0.category_id AS category_id_1, t0.category_name AS category_name_2, t0.category_left AS category_left_3, t0.category_level AS category_level_4, t0.category_right AS category_right_5, t0.description AS description_6, t0.short_desc AS short_desc_7, t0.code AS code_8, t0.img AS img_9, t0.meta_title AS meta_title_10, t0.meta_keywords AS meta_keywords_11, t0.meta_description AS meta_description_12, t0.active AS active_13, t0.is_empty AS is_empty_14, t0.category_top AS category_top_15 FROM Categories t0 WHERE t0.category_id = ?
Parameters:
[
1290
]
|
| 37 | 0.28 ms |
SELECT t0.category_id AS category_id_1, t0.category_name AS category_name_2, t0.category_left AS category_left_3, t0.category_level AS category_level_4, t0.category_right AS category_right_5, t0.description AS description_6, t0.short_desc AS short_desc_7, t0.code AS code_8, t0.img AS img_9, t0.meta_title AS meta_title_10, t0.meta_keywords AS meta_keywords_11, t0.meta_description AS meta_description_12, t0.active AS active_13, t0.is_empty AS is_empty_14, t0.category_top AS category_top_15 FROM Categories t0 WHERE t0.category_id = ?
Parameters:
[
1293
]
|
| 38 | 0.40 ms |
SELECT t0.category_id AS category_id_1, t0.category_name AS category_name_2, t0.category_left AS category_left_3, t0.category_level AS category_level_4, t0.category_right AS category_right_5, t0.description AS description_6, t0.short_desc AS short_desc_7, t0.code AS code_8, t0.img AS img_9, t0.meta_title AS meta_title_10, t0.meta_keywords AS meta_keywords_11, t0.meta_description AS meta_description_12, t0.active AS active_13, t0.is_empty AS is_empty_14, t0.category_top AS category_top_15 FROM Categories t0 WHERE t0.category_id = ?
Parameters:
[
1294
]
|
| 39 | 0.26 ms |
SELECT t0.category_id AS category_id_1, t0.category_name AS category_name_2, t0.category_left AS category_left_3, t0.category_level AS category_level_4, t0.category_right AS category_right_5, t0.description AS description_6, t0.short_desc AS short_desc_7, t0.code AS code_8, t0.img AS img_9, t0.meta_title AS meta_title_10, t0.meta_keywords AS meta_keywords_11, t0.meta_description AS meta_description_12, t0.active AS active_13, t0.is_empty AS is_empty_14, t0.category_top AS category_top_15 FROM Categories t0 WHERE t0.category_id = ?
Parameters:
[
1273
]
|
| 40 | 0.69 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 ] |
| 41 | 0.47 ms |
SELECT t0.category_id AS category_id_1, t0.category_name AS category_name_2, t0.category_left AS category_left_3, t0.category_level AS category_level_4, t0.category_right AS category_right_5, t0.description AS description_6, t0.short_desc AS short_desc_7, t0.code AS code_8, t0.img AS img_9, t0.meta_title AS meta_title_10, t0.meta_keywords AS meta_keywords_11, t0.meta_description AS meta_description_12, t0.active AS active_13, t0.is_empty AS is_empty_14, t0.category_top AS category_top_15 FROM Categories t0 WHERE t0.category_id = ?
Parameters:
[
1285
]
|
| 42 | 0.59 ms |
SELECT t0.category_id AS category_id_1, t0.category_name AS category_name_2, t0.category_left AS category_left_3, t0.category_level AS category_level_4, t0.category_right AS category_right_5, t0.description AS description_6, t0.short_desc AS short_desc_7, t0.code AS code_8, t0.img AS img_9, t0.meta_title AS meta_title_10, t0.meta_keywords AS meta_keywords_11, t0.meta_description AS meta_description_12, t0.active AS active_13, t0.is_empty AS is_empty_14, t0.category_top AS category_top_15 FROM Categories t0 WHERE t0.category_id = ?
Parameters:
[
1291
]
|
| 43 | 0.43 ms |
SELECT t0.category_id AS category_id_1, t0.category_name AS category_name_2, t0.category_left AS category_left_3, t0.category_level AS category_level_4, t0.category_right AS category_right_5, t0.description AS description_6, t0.short_desc AS short_desc_7, t0.code AS code_8, t0.img AS img_9, t0.meta_title AS meta_title_10, t0.meta_keywords AS meta_keywords_11, t0.meta_description AS meta_description_12, t0.active AS active_13, t0.is_empty AS is_empty_14, t0.category_top AS category_top_15 FROM Categories t0 WHERE t0.category_id = ?
Parameters:
[
1292
]
|
| 44 | 0.57 ms |
SELECT t0.category_id AS category_id_1, t0.category_name AS category_name_2, t0.category_left AS category_left_3, t0.category_level AS category_level_4, t0.category_right AS category_right_5, t0.description AS description_6, t0.short_desc AS short_desc_7, t0.code AS code_8, t0.img AS img_9, t0.meta_title AS meta_title_10, t0.meta_keywords AS meta_keywords_11, t0.meta_description AS meta_description_12, t0.active AS active_13, t0.is_empty AS is_empty_14, t0.category_top AS category_top_15 FROM Categories t0 WHERE t0.category_id = ?
Parameters:
[
1274
]
|
| 45 | 0.75 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 ] |
| 46 | 0.44 ms |
SELECT t0.category_id AS category_id_1, t0.category_name AS category_name_2, t0.category_left AS category_left_3, t0.category_level AS category_level_4, t0.category_right AS category_right_5, t0.description AS description_6, t0.short_desc AS short_desc_7, t0.code AS code_8, t0.img AS img_9, t0.meta_title AS meta_title_10, t0.meta_keywords AS meta_keywords_11, t0.meta_description AS meta_description_12, t0.active AS active_13, t0.is_empty AS is_empty_14, t0.category_top AS category_top_15 FROM Categories t0 WHERE t0.category_id = ?
Parameters:
[
1276
]
|
| 47 | 0.29 ms |
SELECT t0.category_id AS category_id_1, t0.category_name AS category_name_2, t0.category_left AS category_left_3, t0.category_level AS category_level_4, t0.category_right AS category_right_5, t0.description AS description_6, t0.short_desc AS short_desc_7, t0.code AS code_8, t0.img AS img_9, t0.meta_title AS meta_title_10, t0.meta_keywords AS meta_keywords_11, t0.meta_description AS meta_description_12, t0.active AS active_13, t0.is_empty AS is_empty_14, t0.category_top AS category_top_15 FROM Categories t0 WHERE t0.category_id = ?
Parameters:
[
1302
]
|
| 48 | 0.32 ms |
SELECT t0.category_id AS category_id_1, t0.category_name AS category_name_2, t0.category_left AS category_left_3, t0.category_level AS category_level_4, t0.category_right AS category_right_5, t0.description AS description_6, t0.short_desc AS short_desc_7, t0.code AS code_8, t0.img AS img_9, t0.meta_title AS meta_title_10, t0.meta_keywords AS meta_keywords_11, t0.meta_description AS meta_description_12, t0.active AS active_13, t0.is_empty AS is_empty_14, t0.category_top AS category_top_15 FROM Categories t0 WHERE t0.category_id = ?
Parameters:
[
1303
]
|
| 49 | 0.30 ms |
SELECT t0.category_id AS category_id_1, t0.category_name AS category_name_2, t0.category_left AS category_left_3, t0.category_level AS category_level_4, t0.category_right AS category_right_5, t0.description AS description_6, t0.short_desc AS short_desc_7, t0.code AS code_8, t0.img AS img_9, t0.meta_title AS meta_title_10, t0.meta_keywords AS meta_keywords_11, t0.meta_description AS meta_description_12, t0.active AS active_13, t0.is_empty AS is_empty_14, t0.category_top AS category_top_15 FROM Categories t0 WHERE t0.category_id = ?
Parameters:
[
1275
]
|
| 50 | 0.69 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 ] |
| 51 | 0.59 ms |
SELECT t0.category_id AS category_id_1, t0.category_name AS category_name_2, t0.category_left AS category_left_3, t0.category_level AS category_level_4, t0.category_right AS category_right_5, t0.description AS description_6, t0.short_desc AS short_desc_7, t0.code AS code_8, t0.img AS img_9, t0.meta_title AS meta_title_10, t0.meta_keywords AS meta_keywords_11, t0.meta_description AS meta_description_12, t0.active AS active_13, t0.is_empty AS is_empty_14, t0.category_top AS category_top_15 FROM Categories t0 WHERE t0.category_id = ?
Parameters:
[
1280
]
|
| 52 | 0.44 ms |
SELECT t0.category_id AS category_id_1, t0.category_name AS category_name_2, t0.category_left AS category_left_3, t0.category_level AS category_level_4, t0.category_right AS category_right_5, t0.description AS description_6, t0.short_desc AS short_desc_7, t0.code AS code_8, t0.img AS img_9, t0.meta_title AS meta_title_10, t0.meta_keywords AS meta_keywords_11, t0.meta_description AS meta_description_12, t0.active AS active_13, t0.is_empty AS is_empty_14, t0.category_top AS category_top_15 FROM Categories t0 WHERE t0.category_id = ?
Parameters:
[
1281
]
|
| 53 | 0.31 ms |
SELECT t0.category_id AS category_id_1, t0.category_name AS category_name_2, t0.category_left AS category_left_3, t0.category_level AS category_level_4, t0.category_right AS category_right_5, t0.description AS description_6, t0.short_desc AS short_desc_7, t0.code AS code_8, t0.img AS img_9, t0.meta_title AS meta_title_10, t0.meta_keywords AS meta_keywords_11, t0.meta_description AS meta_description_12, t0.active AS active_13, t0.is_empty AS is_empty_14, t0.category_top AS category_top_15 FROM Categories t0 WHERE t0.category_id = ?
Parameters:
[
1277
]
|
| 54 | 0.74 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 ] |
| 55 | 0.32 ms |
SELECT t0.category_id AS category_id_1, t0.category_name AS category_name_2, t0.category_left AS category_left_3, t0.category_level AS category_level_4, t0.category_right AS category_right_5, t0.description AS description_6, t0.short_desc AS short_desc_7, t0.code AS code_8, t0.img AS img_9, t0.meta_title AS meta_title_10, t0.meta_keywords AS meta_keywords_11, t0.meta_description AS meta_description_12, t0.active AS active_13, t0.is_empty AS is_empty_14, t0.category_top AS category_top_15 FROM Categories t0 WHERE t0.category_id = ?
Parameters:
[
1286
]
|
| 56 | 0.34 ms |
SELECT t0.category_id AS category_id_1, t0.category_name AS category_name_2, t0.category_left AS category_left_3, t0.category_level AS category_level_4, t0.category_right AS category_right_5, t0.description AS description_6, t0.short_desc AS short_desc_7, t0.code AS code_8, t0.img AS img_9, t0.meta_title AS meta_title_10, t0.meta_keywords AS meta_keywords_11, t0.meta_description AS meta_description_12, t0.active AS active_13, t0.is_empty AS is_empty_14, t0.category_top AS category_top_15 FROM Categories t0 WHERE t0.category_id = ?
Parameters:
[
1287
]
|
| 57 | 0.30 ms |
SELECT t0.category_id AS category_id_1, t0.category_name AS category_name_2, t0.category_left AS category_left_3, t0.category_level AS category_level_4, t0.category_right AS category_right_5, t0.description AS description_6, t0.short_desc AS short_desc_7, t0.code AS code_8, t0.img AS img_9, t0.meta_title AS meta_title_10, t0.meta_keywords AS meta_keywords_11, t0.meta_description AS meta_description_12, t0.active AS active_13, t0.is_empty AS is_empty_14, t0.category_top AS category_top_15 FROM Categories t0 WHERE t0.category_id = ?
Parameters:
[
1288
]
|
| 58 | 0.67 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 ] |
| 59 | 0.84 ms |
SELECT t0.category_id AS category_id_1, t0.category_name AS category_name_2, t0.category_left AS category_left_3, t0.category_level AS category_level_4, t0.category_right AS category_right_5, t0.description AS description_6, t0.short_desc AS short_desc_7, t0.code AS code_8, t0.img AS img_9, t0.meta_title AS meta_title_10, t0.meta_keywords AS meta_keywords_11, t0.meta_description AS meta_description_12, t0.active AS active_13, t0.is_empty AS is_empty_14, t0.category_top AS category_top_15 FROM Categories t0 WHERE t0.category_id = ?
Parameters:
[
1279
]
|
| 60 | 0.33 ms |
SELECT t0.category_id AS category_id_1, t0.category_name AS category_name_2, t0.category_left AS category_left_3, t0.category_level AS category_level_4, t0.category_right AS category_right_5, t0.description AS description_6, t0.short_desc AS short_desc_7, t0.code AS code_8, t0.img AS img_9, t0.meta_title AS meta_title_10, t0.meta_keywords AS meta_keywords_11, t0.meta_description AS meta_description_12, t0.active AS active_13, t0.is_empty AS is_empty_14, t0.category_top AS category_top_15 FROM Categories t0 WHERE t0.category_id = ?
Parameters:
[
1283
]
|
| 61 | 0.29 ms |
SELECT t0.category_id AS category_id_1, t0.category_name AS category_name_2, t0.category_left AS category_left_3, t0.category_level AS category_level_4, t0.category_right AS category_right_5, t0.description AS description_6, t0.short_desc AS short_desc_7, t0.code AS code_8, t0.img AS img_9, t0.meta_title AS meta_title_10, t0.meta_keywords AS meta_keywords_11, t0.meta_description AS meta_description_12, t0.active AS active_13, t0.is_empty AS is_empty_14, t0.category_top AS category_top_15 FROM Categories t0 WHERE t0.category_id = ?
Parameters:
[
1284
]
|
| 62 | 0.27 ms |
SELECT t0.category_id AS category_id_1, t0.category_name AS category_name_2, t0.category_left AS category_left_3, t0.category_level AS category_level_4, t0.category_right AS category_right_5, t0.description AS description_6, t0.short_desc AS short_desc_7, t0.code AS code_8, t0.img AS img_9, t0.meta_title AS meta_title_10, t0.meta_keywords AS meta_keywords_11, t0.meta_description AS meta_description_12, t0.active AS active_13, t0.is_empty AS is_empty_14, t0.category_top AS category_top_15 FROM Categories t0 WHERE t0.category_id = ?
Parameters:
[
1295
]
|
| 63 | 0.53 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 ] |
| 64 | 0.27 ms |
SELECT t0.category_id AS category_id_1, t0.category_name AS category_name_2, t0.category_left AS category_left_3, t0.category_level AS category_level_4, t0.category_right AS category_right_5, t0.description AS description_6, t0.short_desc AS short_desc_7, t0.code AS code_8, t0.img AS img_9, t0.meta_title AS meta_title_10, t0.meta_keywords AS meta_keywords_11, t0.meta_description AS meta_description_12, t0.active AS active_13, t0.is_empty AS is_empty_14, t0.category_top AS category_top_15 FROM Categories t0 WHERE t0.category_id = ?
Parameters:
[
1298
]
|
| 65 | 0.28 ms |
SELECT t0.category_id AS category_id_1, t0.category_name AS category_name_2, t0.category_left AS category_left_3, t0.category_level AS category_level_4, t0.category_right AS category_right_5, t0.description AS description_6, t0.short_desc AS short_desc_7, t0.code AS code_8, t0.img AS img_9, t0.meta_title AS meta_title_10, t0.meta_keywords AS meta_keywords_11, t0.meta_description AS meta_description_12, t0.active AS active_13, t0.is_empty AS is_empty_14, t0.category_top AS category_top_15 FROM Categories t0 WHERE t0.category_id = ?
Parameters:
[
1299
]
|
| 66 | 0.27 ms |
SELECT t0.category_id AS category_id_1, t0.category_name AS category_name_2, t0.category_left AS category_left_3, t0.category_level AS category_level_4, t0.category_right AS category_right_5, t0.description AS description_6, t0.short_desc AS short_desc_7, t0.code AS code_8, t0.img AS img_9, t0.meta_title AS meta_title_10, t0.meta_keywords AS meta_keywords_11, t0.meta_description AS meta_description_12, t0.active AS active_13, t0.is_empty AS is_empty_14, t0.category_top AS category_top_15 FROM Categories t0 WHERE t0.category_id = ?
Parameters:
[
1296
]
|
| 67 | 0.27 ms |
SELECT t0.category_id AS category_id_1, t0.category_name AS category_name_2, t0.category_left AS category_left_3, t0.category_level AS category_level_4, t0.category_right AS category_right_5, t0.description AS description_6, t0.short_desc AS short_desc_7, t0.code AS code_8, t0.img AS img_9, t0.meta_title AS meta_title_10, t0.meta_keywords AS meta_keywords_11, t0.meta_description AS meta_description_12, t0.active AS active_13, t0.is_empty AS is_empty_14, t0.category_top AS category_top_15 FROM Categories t0 WHERE t0.category_id = ?
Parameters:
[
1301
]
|
| 68 | 0.48 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
]
|
| 69 | 0.68 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 ] |
| 70 | 0.63 ms |
SELECT DATABASE()
Parameters:
[] |
| 71 | 5.66 ms |
SELECT TABLE_NAME FROM information_schema.TABLES WHERE TABLE_SCHEMA = ? AND TABLE_TYPE = 'BASE TABLE' ORDER BY TABLE_NAME
Parameters:
[
"elektrofortecia"
]
|
| 72 | 0.16 ms |
SELECT DATABASE()
Parameters:
[] |
| 73 | 3.77 ms |
SELECT TABLE_NAME FROM information_schema.TABLES WHERE TABLE_SCHEMA = ? AND TABLE_TYPE = 'BASE TABLE' ORDER BY TABLE_NAME
Parameters:
[
"elektrofortecia"
]
|
| 74 | 0.22 ms |
SELECT DATABASE()
Parameters:
[] |
| 75 | 1.04 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" ] |
| 76 | 0.16 ms |
SELECT DATABASE()
Parameters:
[] |
| 77 | 7.20 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" ] |
| 78 | 6.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" ] |
| 79 | 0.22 ms |
SELECT DATABASE()
Parameters:
[] |
| 80 | 0.38 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" ] |
| 81 | 0.29 ms |
SELECT * FROM doctrine_migration_versions
Parameters:
[] |
| 82 | 0.24 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.