49 queries took 28 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1DESC `eshop_products`40403
2DESC `eshop_categories`23231
3DESC `eshop_manufacturers`553
4DESC `eshop_suppliers`332
5DESC `eshop_gimages`883
6DESC `eshop_options`331
7DESC `eshop_orders`15153
8DESC `eshop_clients`11111
9DESC `eshop_clients_addresses`771
10DESC `eshop_billing_methods`551
11DESC `eshop_shipping_methods`660
12DESC `brands`881
13DESC `brands_models`441
14DESC `contact_emails`17171
15DESC `users`12121
16 SELECT * FROM eshop_defaults 440
17 SELECT EshopCategory.id, EshopCategory.left_id, EshopCategory.right_id, EshopCategory.c_name, EshopCategory.c_urlrw, EshopCategory.c_menu_name, EshopCategory.c_level FROM eshop_categories EshopCategory WHERE EshopCategory.c_level = 2 AND EshopCategory.c_status = 1 AND 1 GROUP BY EshopCategory.id ORDER BY EshopCategory.left_id ASC 441
18SELECT `EshopCategory`.`id`, `EshopCategory`.`left_id`, `EshopCategory`.`right_id`, `EshopCategory`.`c_name`, `EshopCategory`.`c_menu_name`, `EshopCategory`.`c_urlrw` FROM `eshop_categories` AS `EshopCategory` WHERE `EshopCategory`.`c_menu` = 1 AND `EshopCategory`.`c_status` = 1 ORDER BY `EshopCategory`.`left_id` ASC 550
19SELECT `EshopCategory`.`id`, `EshopCategory`.`c_name`, `EshopCategory`.`c_menu_name`, `EshopCategory`.`c_urlrw` FROM `eshop_categories` AS `EshopCategory` WHERE `EshopCategory`.`left_id` < 3 AND `EshopCategory`.`right_id` > 12 AND `EshopCategory`.`c_level` > 1 ORDER BY `EshopCategory`.`left_id` ASC 110
20SELECT `EshopCategory`.`id`, `EshopCategory`.`c_name`, `EshopCategory`.`c_menu_name`, `EshopCategory`.`c_urlrw` FROM `eshop_categories` AS `EshopCategory` WHERE `EshopCategory`.`left_id` < 20 AND `EshopCategory`.`right_id` > 21 AND `EshopCategory`.`c_level` > 1 ORDER BY `EshopCategory`.`left_id` ASC 220
21SELECT `EshopCategory`.`id`, `EshopCategory`.`c_name`, `EshopCategory`.`c_menu_name`, `EshopCategory`.`c_urlrw` FROM `eshop_categories` AS `EshopCategory` WHERE `EshopCategory`.`left_id` < 73 AND `EshopCategory`.`right_id` > 74 AND `EshopCategory`.`c_level` > 1 ORDER BY `EshopCategory`.`left_id` ASC 110
22SELECT `EshopCategory`.`id`, `EshopCategory`.`c_name`, `EshopCategory`.`c_menu_name`, `EshopCategory`.`c_urlrw` FROM `eshop_categories` AS `EshopCategory` WHERE `EshopCategory`.`left_id` < 75 AND `EshopCategory`.`right_id` > 76 AND `EshopCategory`.`c_level` > 1 ORDER BY `EshopCategory`.`left_id` ASC 110
23SELECT `EshopCategory`.`id`, `EshopCategory`.`c_name`, `EshopCategory`.`c_menu_name`, `EshopCategory`.`c_urlrw` FROM `eshop_categories` AS `EshopCategory` WHERE `EshopCategory`.`left_id` < 77 AND `EshopCategory`.`right_id` > 78 AND `EshopCategory`.`c_level` > 1 ORDER BY `EshopCategory`.`left_id` ASC 110
24 SELECT Category.id, Category.c_name, Category.c_urlrw, Article.id, Article.a_title, Article.a_urlrw, COUNT(TotalArticle.id) as articles FROM cms_categories Category INNER JOIN cms_articles TotalArticle ON TotalArticle.category_id = Category.id INNER JOIN cms_articles Article ON (Article.category_id = Category.id AND Article.a_urlrw = 'index') WHERE Category.level = 1 AND Category.c_menu = 1 AND Category.c_status = 1 AND Category.root_id = 1 GROUP BY Category.id ORDER BY Category.c_order ASC 003
25 SELECT Article.id, Article.a_title, Article.a_urlrw, Category.id, Category.c_name, Category.c_urlrw FROM cms_articles Article INNER JOIN cms_categories Category ON Category.id = Article.category_id WHERE Article.category_id = 1 AND Article.a_status = 1 AND Article.a_show_menu = 1 AND Article.a_urlrw <> 'index' ORDER BY Article.a_order ASC 550
26SELECT `Brand`.`id`, `Brand`.`b_name`, `Brand`.`b_urlrw` FROM `brands` AS `Brand` WHERE `Brand`.`b_status` = 1 1611611
27SELECT `EshopCategory`.`id`, `EshopCategory`.`left_id`, `EshopCategory`.`right_id`, `EshopCategory`.`c_name`, `EshopCategory`.`c_urlrw`, `EshopCategory`.`page_description`, `EshopCategory`.`page_keywords` FROM `eshop_categories` AS `EshopCategory` WHERE `EshopCategory`.`c_level` = 2 AND `EshopCategory`.`c_status` = 1 ORDER BY `EshopCategory`.`left_id` ASC LIMIT 2220
28SELECT `EshopCategory`.`id`, `EshopCategory`.`left_id`, `EshopCategory`.`right_id`, `EshopCategory`.`c_level`, `EshopCategory`.`c_name`, `EshopCategory`.`c_urlrw`, `EshopCategory`.`c_image`, `EshopCategory`.`page_description`, `EshopCategory`.`page_keywords` FROM `eshop_categories` AS `EshopCategory` WHERE `EshopCategory`.`left_id` > 2 AND `EshopCategory`.`right_id` < 71 AND `EshopCategory`.`c_status` = 1 AND `EshopCategory`.`c_level` = 3 ORDER BY `EshopCategory`.`left_id` ASC 660
29SELECT `EshopCategory`.`id`, `EshopCategory`.`left_id`, `EshopCategory`.`right_id`, `EshopCategory`.`c_level`, `EshopCategory`.`c_name`, `EshopCategory`.`c_urlrw`, `EshopCategory`.`c_image`, `EshopCategory`.`c_description` FROM `eshop_categories` AS `EshopCategory` WHERE `EshopCategory`.`left_id` > 3 AND `EshopCategory`.`right_id` < 12 AND `EshopCategory`.`c_status` = 1 AND `EshopCategory`.`c_level` = 4 440
30SELECT `EshopCategory`.`id`, `EshopCategory`.`c_name`, `EshopCategory`.`c_menu_name`, `EshopCategory`.`c_urlrw` FROM `eshop_categories` AS `EshopCategory` WHERE `EshopCategory`.`left_id` < 4 AND `EshopCategory`.`right_id` > 5 AND `EshopCategory`.`c_level` > 1 ORDER BY `EshopCategory`.`left_id` ASC 220
31SELECT `EshopCategory`.`id`, `EshopCategory`.`c_name`, `EshopCategory`.`c_menu_name`, `EshopCategory`.`c_urlrw` FROM `eshop_categories` AS `EshopCategory` WHERE `EshopCategory`.`left_id` < 6 AND `EshopCategory`.`right_id` > 7 AND `EshopCategory`.`c_level` > 1 ORDER BY `EshopCategory`.`left_id` ASC 220
32SELECT `EshopCategory`.`id`, `EshopCategory`.`c_name`, `EshopCategory`.`c_menu_name`, `EshopCategory`.`c_urlrw` FROM `eshop_categories` AS `EshopCategory` WHERE `EshopCategory`.`left_id` < 8 AND `EshopCategory`.`right_id` > 9 AND `EshopCategory`.`c_level` > 1 ORDER BY `EshopCategory`.`left_id` ASC 220
33SELECT `EshopCategory`.`id`, `EshopCategory`.`c_name`, `EshopCategory`.`c_menu_name`, `EshopCategory`.`c_urlrw` FROM `eshop_categories` AS `EshopCategory` WHERE `EshopCategory`.`left_id` < 10 AND `EshopCategory`.`right_id` > 11 AND `EshopCategory`.`c_level` > 1 ORDER BY `EshopCategory`.`left_id` ASC 220
34SELECT `EshopCategory`.`id`, `EshopCategory`.`left_id`, `EshopCategory`.`right_id`, `EshopCategory`.`c_level`, `EshopCategory`.`c_name`, `EshopCategory`.`c_urlrw`, `EshopCategory`.`c_image`, `EshopCategory`.`c_description` FROM `eshop_categories` AS `EshopCategory` WHERE `EshopCategory`.`left_id` > 13 AND `EshopCategory`.`right_id` < 26 AND `EshopCategory`.`c_status` = 1 AND `EshopCategory`.`c_level` = 4 660
35SELECT `EshopCategory`.`id`, `EshopCategory`.`c_name`, `EshopCategory`.`c_menu_name`, `EshopCategory`.`c_urlrw` FROM `eshop_categories` AS `EshopCategory` WHERE `EshopCategory`.`left_id` < 14 AND `EshopCategory`.`right_id` > 15 AND `EshopCategory`.`c_level` > 1 ORDER BY `EshopCategory`.`left_id` ASC 220
36SELECT `EshopCategory`.`id`, `EshopCategory`.`c_name`, `EshopCategory`.`c_menu_name`, `EshopCategory`.`c_urlrw` FROM `eshop_categories` AS `EshopCategory` WHERE `EshopCategory`.`left_id` < 16 AND `EshopCategory`.`right_id` > 17 AND `EshopCategory`.`c_level` > 1 ORDER BY `EshopCategory`.`left_id` ASC 220
37SELECT `EshopCategory`.`id`, `EshopCategory`.`c_name`, `EshopCategory`.`c_menu_name`, `EshopCategory`.`c_urlrw` FROM `eshop_categories` AS `EshopCategory` WHERE `EshopCategory`.`left_id` < 18 AND `EshopCategory`.`right_id` > 19 AND `EshopCategory`.`c_level` > 1 ORDER BY `EshopCategory`.`left_id` ASC 220
38SELECT `EshopCategory`.`id`, `EshopCategory`.`c_name`, `EshopCategory`.`c_menu_name`, `EshopCategory`.`c_urlrw` FROM `eshop_categories` AS `EshopCategory` WHERE `EshopCategory`.`left_id` < 22 AND `EshopCategory`.`right_id` > 23 AND `EshopCategory`.`c_level` > 1 ORDER BY `EshopCategory`.`left_id` ASC 220
39SELECT `EshopCategory`.`id`, `EshopCategory`.`c_name`, `EshopCategory`.`c_menu_name`, `EshopCategory`.`c_urlrw` FROM `eshop_categories` AS `EshopCategory` WHERE `EshopCategory`.`left_id` < 24 AND `EshopCategory`.`right_id` > 25 AND `EshopCategory`.`c_level` > 1 ORDER BY `EshopCategory`.`left_id` ASC 220
40SELECT `EshopCategory`.`id`, `EshopCategory`.`c_name`, `EshopCategory`.`c_menu_name`, `EshopCategory`.`c_urlrw` FROM `eshop_categories` AS `EshopCategory` WHERE `EshopCategory`.`left_id` < 13 AND `EshopCategory`.`right_id` > 26 AND `EshopCategory`.`c_level` > 1 ORDER BY `EshopCategory`.`left_id` ASC 110
41SELECT `EshopCategory`.`id`, `EshopCategory`.`left_id`, `EshopCategory`.`right_id`, `EshopCategory`.`c_level`, `EshopCategory`.`c_name`, `EshopCategory`.`c_urlrw`, `EshopCategory`.`c_image`, `EshopCategory`.`c_description` FROM `eshop_categories` AS `EshopCategory` WHERE `EshopCategory`.`left_id` > 27 AND `EshopCategory`.`right_id` < 36 AND `EshopCategory`.`c_status` = 1 AND `EshopCategory`.`c_level` = 4 000
42SELECT `EshopCategory`.`id`, `EshopCategory`.`c_name`, `EshopCategory`.`c_menu_name`, `EshopCategory`.`c_urlrw` FROM `eshop_categories` AS `EshopCategory` WHERE `EshopCategory`.`left_id` < 27 AND `EshopCategory`.`right_id` > 36 AND `EshopCategory`.`c_level` > 1 ORDER BY `EshopCategory`.`left_id` ASC 110
43SELECT `EshopCategory`.`id`, `EshopCategory`.`left_id`, `EshopCategory`.`right_id`, `EshopCategory`.`c_level`, `EshopCategory`.`c_name`, `EshopCategory`.`c_urlrw`, `EshopCategory`.`c_image`, `EshopCategory`.`c_description` FROM `eshop_categories` AS `EshopCategory` WHERE `EshopCategory`.`left_id` > 37 AND `EshopCategory`.`right_id` < 50 AND `EshopCategory`.`c_status` = 1 AND `EshopCategory`.`c_level` = 4 000
44SELECT `EshopCategory`.`id`, `EshopCategory`.`c_name`, `EshopCategory`.`c_menu_name`, `EshopCategory`.`c_urlrw` FROM `eshop_categories` AS `EshopCategory` WHERE `EshopCategory`.`left_id` < 37 AND `EshopCategory`.`right_id` > 50 AND `EshopCategory`.`c_level` > 1 ORDER BY `EshopCategory`.`left_id` ASC 110
45SELECT `EshopCategory`.`id`, `EshopCategory`.`left_id`, `EshopCategory`.`right_id`, `EshopCategory`.`c_level`, `EshopCategory`.`c_name`, `EshopCategory`.`c_urlrw`, `EshopCategory`.`c_image`, `EshopCategory`.`c_description` FROM `eshop_categories` AS `EshopCategory` WHERE `EshopCategory`.`left_id` > 51 AND `EshopCategory`.`right_id` < 60 AND `EshopCategory`.`c_status` = 1 AND `EshopCategory`.`c_level` = 4 000
46SELECT `EshopCategory`.`id`, `EshopCategory`.`c_name`, `EshopCategory`.`c_menu_name`, `EshopCategory`.`c_urlrw` FROM `eshop_categories` AS `EshopCategory` WHERE `EshopCategory`.`left_id` < 51 AND `EshopCategory`.`right_id` > 60 AND `EshopCategory`.`c_level` > 1 ORDER BY `EshopCategory`.`left_id` ASC 110
47SELECT `EshopCategory`.`id`, `EshopCategory`.`left_id`, `EshopCategory`.`right_id`, `EshopCategory`.`c_level`, `EshopCategory`.`c_name`, `EshopCategory`.`c_urlrw`, `EshopCategory`.`c_image`, `EshopCategory`.`c_description` FROM `eshop_categories` AS `EshopCategory` WHERE `EshopCategory`.`left_id` > 61 AND `EshopCategory`.`right_id` < 70 AND `EshopCategory`.`c_status` = 1 AND `EshopCategory`.`c_level` = 4 000
48SELECT `EshopCategory`.`id`, `EshopCategory`.`c_name`, `EshopCategory`.`c_menu_name`, `EshopCategory`.`c_urlrw` FROM `eshop_categories` AS `EshopCategory` WHERE `EshopCategory`.`left_id` < 61 AND `EshopCategory`.`right_id` > 70 AND `EshopCategory`.`c_level` > 1 ORDER BY `EshopCategory`.`left_id` ASC 110
49SELECT `EshopCategory`.`id`, `EshopCategory`.`left_id`, `EshopCategory`.`right_id`, `EshopCategory`.`c_name`, `EshopCategory`.`c_urlrw`, `EshopCategory`.`c_image`, `EshopCategory`.`page_description`, `EshopCategory`.`page_keywords` FROM `eshop_categories` AS `EshopCategory` WHERE `EshopCategory`.`left_id` > 72 AND `EshopCategory`.`right_id` < 79 AND `EshopCategory`.`c_status` = 1 330