Подберите идеальную консоль с помощью нового калькулятора ресурсов UniFi OS

Развертывание UniFi настолько эффективно, насколько эффективно планирование, стоящее за ним. При создании системы своей мечты и определении способов оптимизации ее производительности необходимо учитывать два важных вопроса. Во-первых, можно ли легко интегрировать ваше оборудование в ваше пространство.

Мы расскажем вам о нашем Центре дизайна, интерактивном инструменте визуализации, который позволяет вам составить карту пользовательской сети, уникально подходящей для вашего местоположения. Ознакомьтесь с нашим кратким видеообзором, чтобы узнать больше.

Набор продуктов UniFi обширен, целостен и рассчитан на высокую масштабируемость, что позволяет создавать и поддерживать сети любого размера. Это означает, что у вас есть множество вариантов выбора идеальных устройств, приложений и функциональности, поэтому мы настоятельно рекомендуем не торопиться в процессе планирования. После завершения развертывания возникает важнейший следующий вопрос:

Есть ли у меня все необходимое для запуска всего этого?

Имея это в виду, мы очень рады представить калькулятор ресурсов консоли UniFi OS: совершенно новый модал, который не только одним щелчком мыши обеспечивает обработку данных и ограничение объема памяти для конкретной консоли, но и дает приблизительное представление о том, насколько хорошо каждая консоль может поддерживать различные типы развертывания.

Детализация - это название игры с нашим новым калькулятором. Нашим главным приоритетом является обеспечение того, чтобы каждый пользователь мог полностью охватить каждый компонент своей системы, чтобы он точно знал, какая консоль подходит именно ему. После выбора консоли и приложений, которые она будет запускать, у вас есть множество вариантов настройки, которые помогут вам указать, сколько устройств вы подключаете, как они будут функционировать и будут ли они иметь расширенные конфигурации.

По мере внесения настроек вы увидите, как влияют процессор и память каждой консоли, что поможет вам определить, правильную ли вы выбрали модель или вам требуется модель с более высокими характеристиками.

Купить продукцию UBIQUITI можно на официальном сайте поставщика в России.
Оригинал: https://blog.ui.com/2022/04/07/discover-your-perfect-console-with-the-new-unifi-os-resource-calculator/

Выберите обязательные опции

Queries: 297, Total time: 147.870 ms [By time] [By id] [By file]

1 (0.172)

SET time_zone = '+00:00'

/var/www/ubiquiti-russia.com/data/www/ubiquiti-russia.com/system/framework.php:84

2 (1.785)

DELETE
FROM `session`
WHERE `expire` < '2025-10-31 15:34:47'

/var/www/ubiquiti-russia.com/data/www/ubiquiti-russia.com/system/library/session/db.php:53

3 (0.388)

SELECT *
FROM translation
WHERE store_id = '0' AND language_id = '0' AND (route = 'engb' OR route = '')

/var/www/ubiquiti-russia.com/data/www/ubiquiti-russia.com/catalog/model/design/translation.php:6

4 (0.349)

SELECT `data`
FROM `session`
WHERE `session_id` = 'aa604af004f612d79fb9a4b4d1' AND `expire` > '2025-10-31 15:34:47'

/var/www/ubiquiti-russia.com/data/www/ubiquiti-russia.com/system/library/session/db.php:16

5 (0.353)

SELECT *
FROM store
WHERE REPLACE(`ssl`, 'www.', '') = 'https://ubiquiti-russia.com/'

/var/www/ubiquiti-russia.com/data/www/ubiquiti-russia.com/system/storage/modification/catalog/controller/startup/startup.php:6

6 (2.484)

SELECT *
FROM `setting`
WHERE store_id = '0' OR store_id = '0'
ORDER BY store_id ASC

/var/www/ubiquiti-russia.com/data/www/ubiquiti-russia.com/system/storage/modification/catalog/controller/startup/startup.php:25

7 (0.256)

SET time_zone = '+03:00'

/var/www/ubiquiti-russia.com/data/www/ubiquiti-russia.com/system/storage/modification/catalog/controller/startup/startup.php:40

8 (0.335)

SELECT *
FROM language
WHERE status = '1'
ORDER BY sort_order, name

/var/www/ubiquiti-russia.com/data/www/ubiquiti-russia.com/catalog/model/localisation/language.php:15

9 (0.394)

SELECT *
FROM `currency`
WHERE `status` = '1'
ORDER BY `title` ASC

/var/www/ubiquiti-russia.com/data/www/ubiquiti-russia.com/catalog/model/localisation/currency.php:15

10 (0.245)

SELECT *
FROM currency

/var/www/ubiquiti-russia.com/data/www/ubiquiti-russia.com/system/library/cart/currency.php:10

11 (0.473)

SELECT *
FROM seo_url
WHERE `store_id` = '0' AND `language_id` = '1' AND `keyword` = 'news-2024-07-24' LIMIT 1

/var/www/ubiquiti-russia.com/data/www/ubiquiti-russia.com/catalog/controller/jetcache/jetcache.php:383

12 (0.337)

DELETE
FROM cart
WHERE (api_id > '0' OR customer_id = '0') AND date_added < DATE_SUB(NOW(), INTERVAL 43200 MINUTE)

/var/www/ubiquiti-russia.com/data/www/ubiquiti-russia.com/catalog/controller/jetcache/jetcache.php:261

13 (0.282)

SELECT *
FROM cart
WHERE customer_id = '0' AND session_id = 'aa604af004f612d79fb9a4b4d1'

/var/www/ubiquiti-russia.com/data/www/ubiquiti-russia.com/catalog/controller/jetcache/jetcache.php:266

14 (0.428)

SELECT tr1.tax_class_id, tr2.tax_rate_id, tr2.name, tr2.rate, tr2.type, tr1.priority
FROM tax_rule tr1
LEFT JOIN tax_rate tr2 ON (tr1.tax_rate_id = tr2.tax_rate_id)
INNER JOIN tax_rate_to_customer_group tr2cg ON (tr2.tax_rate_id = tr2cg.tax_rate_id)
LEFT JOIN zone_to_geo_zone z2gz ON (tr2.geo_zone_id = z2gz.geo_zone_id)
LEFT JOIN geo_zone gz ON (tr2.geo_zone_id = gz.geo_zone_id)
WHERE tr1.based = 'shipping' AND tr2cg.customer_group_id = '1' AND z2gz.country_id = '176' AND (z2gz.zone_id = '0' OR z2gz.zone_id = '2761')
ORDER BY tr1.priority ASC

/var/www/ubiquiti-russia.com/data/www/ubiquiti-russia.com/system/storage/modification/system/library/cart/tax.php:16

15 (0.280)

SELECT tr1.tax_class_id, tr2.tax_rate_id, tr2.name, tr2.rate, tr2.type, tr1.priority
FROM tax_rule tr1
LEFT JOIN tax_rate tr2 ON (tr1.tax_rate_id = tr2.tax_rate_id)
INNER JOIN tax_rate_to_customer_group tr2cg ON (tr2.tax_rate_id = tr2cg.tax_rate_id)
LEFT JOIN zone_to_geo_zone z2gz ON (tr2.geo_zone_id = z2gz.geo_zone_id)
LEFT JOIN geo_zone gz ON (tr2.geo_zone_id = gz.geo_zone_id)
WHERE tr1.based = 'store' AND tr2cg.customer_group_id = '1' AND z2gz.country_id = '176' AND (z2gz.zone_id = '0' OR z2gz.zone_id = '2761')
ORDER BY tr1.priority ASC

/var/www/ubiquiti-russia.com/data/www/ubiquiti-russia.com/system/storage/modification/system/library/cart/tax.php:44

16 (0.286)

SELECT *
FROM weight_class wc
LEFT JOIN weight_class_description wcd ON (wc.weight_class_id = wcd.weight_class_id)
WHERE wcd.language_id = '1'

/var/www/ubiquiti-russia.com/data/www/ubiquiti-russia.com/system/library/cart/weight.php:10

17 (0.283)

SELECT *
FROM length_class mc
LEFT JOIN length_class_description mcd ON (mc.length_class_id = mcd.length_class_id)
WHERE mcd.language_id = '1'

/var/www/ubiquiti-russia.com/data/www/ubiquiti-russia.com/system/library/cart/length.php:10

18 (0.262)

DELETE
FROM cart
WHERE (api_id > '0' OR customer_id = '0') AND date_added < DATE_SUB(NOW(), INTERVAL 1 HOUR)

/var/www/ubiquiti-russia.com/data/www/ubiquiti-russia.com/system/storage/modification/system/library/cart/cart.php:15

19 (0.451)

SELECT *
FROM `event`
WHERE `trigger` LIKE 'catalog/%' AND status = '1'
ORDER BY `sort_order` ASC

/var/www/ubiquiti-russia.com/data/www/ubiquiti-russia.com/catalog/model/setting/event.php:4

20 (0.296)

SELECT language_id
FROM language
WHERE code = '0' AND status = '1' LIMIT 1

/var/www/ubiquiti-russia.com/data/www/ubiquiti-russia.com/system/storage/modification/system/library/seopro.php:659

21 (0.348)

SELECT *
FROM seo_url
WHERE keyword = 'news-2024-07-24' AND store_id = '0'

/var/www/ubiquiti-russia.com/data/www/ubiquiti-russia.com/system/storage/modification/catalog/controller/startup/seo_url.php:39

22 (0.259)

SELECT *
FROM translation
WHERE store_id = '0' AND language_id = '1' AND (route = 'extension/module/prostore_news' OR route = 'ru-ru')

/var/www/ubiquiti-russia.com/data/www/ubiquiti-russia.com/catalog/model/design/translation.php:6

23 (0.291)

SELECT *
FROM seo_url
WHERE `query` = 'extension/module/prostore_news/getnewslist'

/var/www/ubiquiti-russia.com/data/www/ubiquiti-russia.com/system/storage/modification/catalog/controller/startup/seo_url.php:275

24 (2.043)

SELECT DISTINCT *
FROM prostore_news i
LEFT JOIN prostore_news_description id ON (i.news_id = id.news_id)
LEFT JOIN prostore_news_to_store i2s ON (i.news_id = i2s.news_id)
WHERE i.news_id = '62' AND id.language_id = '1' AND i2s.store_id = '0' AND i.status = '1'

/var/www/ubiquiti-russia.com/data/www/ubiquiti-russia.com/catalog/model/extension/module/prostorenews.php:4

25 (0.292)

SELECT *
FROM translation
WHERE store_id = '0' AND language_id = '1' AND (route = 'extension/theme/prostore' OR route = 'ru-ru')

/var/www/ubiquiti-russia.com/data/www/ubiquiti-russia.com/catalog/model/design/translation.php:6

26 (0.605)

SELECT *
FROM prostore_news_related pr
LEFT JOIN product p ON (pr.related_id = p.product_id)
LEFT JOIN product_to_store p2s ON (p.product_id = p2s.product_id)
WHERE pr.news_id = '62' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'

/var/www/ubiquiti-russia.com/data/www/ubiquiti-russia.com/catalog/model/extension/module/prostorenews.php:41

27 (0.285)

SELECT *
FROM translation
WHERE store_id = '0' AND language_id = '1' AND (route = 'extension/module/prostore_news' OR route = 'ru-ru')

/var/www/ubiquiti-russia.com/data/www/ubiquiti-russia.com/catalog/model/design/translation.php:6

28 (0.486)

SELECT *
FROM prostore_news_to_layout
WHERE news_id = '62' AND store_id = '0'

/var/www/ubiquiti-russia.com/data/www/ubiquiti-russia.com/catalog/model/extension/module/prostorenews.php:21

29 (0.403)

SELECT COUNT(*) as total
FROM information_schema.TABLES
WHERE TABLE_SCHEMA = 'ubiquiti-russia.com' AND TABLE_NAME = 'ocdevwizard_setting'

/var/www/ubiquiti-russia.com/data/www/ubiquiti-russia.com/catalog/model/extension/ocdevwizard/helper.php:55

30 (0.282)

SELECT *
FROM ocdevwizard_setting
WHERE store_id = '0' AND `key` = 'form_builder_form_data'

/var/www/ubiquiti-russia.com/data/www/ubiquiti-russia.com/catalog/model/extension/ocdevwizard/helper.php:15

31 (0.365)

SELECT *
FROM layout_module
WHERE layout_id = '21' AND position = 'column_left'
ORDER BY sort_order

/var/www/ubiquiti-russia.com/data/www/ubiquiti-russia.com/catalog/model/design/layout.php:14

32 (0.370)

SELECT DISTINCT f.sort_order, f2l.form_id
FROM ocdw_form_builder_form f
LEFT JOIN ocdw_form_builder_form_to_layout_for_module f2l ON (f.form_id = f2l.form_id)
WHERE f2l.layout_id = '21' AND f.position = 'column_left' AND f.display_type = '2' AND f.status = '1'
ORDER BY f.sort_order ASC

/var/www/ubiquiti-russia.com/data/www/ubiquiti-russia.com/catalog/model/extension/ocdevwizard/form_builder.php:15

33 (0.270)

SELECT *
FROM theme
WHERE store_id = '0' AND theme = 'prostore' AND route = 'common/column_left'

/var/www/ubiquiti-russia.com/data/www/ubiquiti-russia.com/catalog/model/design/theme.php:4

34 (0.536)

SELECT *
FROM prostore_news_to_layout
WHERE news_id = '62' AND store_id = '0'

/var/www/ubiquiti-russia.com/data/www/ubiquiti-russia.com/catalog/model/extension/module/prostorenews.php:21

35 (0.354)

SELECT *
FROM layout_module
WHERE layout_id = '21' AND position = 'column_right'
ORDER BY sort_order

/var/www/ubiquiti-russia.com/data/www/ubiquiti-russia.com/catalog/model/design/layout.php:14

36 (0.388)

SELECT DISTINCT f.sort_order, f2l.form_id
FROM ocdw_form_builder_form f
LEFT JOIN ocdw_form_builder_form_to_layout_for_module f2l ON (f.form_id = f2l.form_id)
WHERE f2l.layout_id = '21' AND f.position = 'column_right' AND f.display_type = '2' AND f.status = '1'
ORDER BY f.sort_order ASC

/var/www/ubiquiti-russia.com/data/www/ubiquiti-russia.com/catalog/model/extension/ocdevwizard/form_builder.php:15

37 (0.251)

SELECT *
FROM theme
WHERE store_id = '0' AND theme = 'prostore' AND route = 'common/column_right'

/var/www/ubiquiti-russia.com/data/www/ubiquiti-russia.com/catalog/model/design/theme.php:4

38 (0.323)

SELECT *
FROM prostore_news_to_layout
WHERE news_id = '62' AND store_id = '0'

/var/www/ubiquiti-russia.com/data/www/ubiquiti-russia.com/catalog/model/extension/module/prostorenews.php:21

39 (0.280)

SELECT *
FROM layout_module
WHERE layout_id = '21' AND position = 'content_top'
ORDER BY sort_order

/var/www/ubiquiti-russia.com/data/www/ubiquiti-russia.com/catalog/model/design/layout.php:14

40 (0.403)

SELECT DISTINCT f.sort_order, f2l.form_id
FROM ocdw_form_builder_form f
LEFT JOIN ocdw_form_builder_form_to_layout_for_module f2l ON (f.form_id = f2l.form_id)
WHERE f2l.layout_id = '21' AND f.position = 'content_top' AND f.display_type = '2' AND f.status = '1'
ORDER BY f.sort_order ASC

/var/www/ubiquiti-russia.com/data/www/ubiquiti-russia.com/catalog/model/extension/ocdevwizard/form_builder.php:15

41 (0.240)

SELECT *
FROM theme
WHERE store_id = '0' AND theme = 'prostore' AND route = 'common/content_top'

/var/www/ubiquiti-russia.com/data/www/ubiquiti-russia.com/catalog/model/design/theme.php:4

42 (0.258)

SELECT *
FROM prostore_news_to_layout
WHERE news_id = '62' AND store_id = '0'

/var/www/ubiquiti-russia.com/data/www/ubiquiti-russia.com/catalog/model/extension/module/prostorenews.php:21

43 (0.240)

SELECT *
FROM layout_module
WHERE layout_id = '21' AND position = 'content_bottom'
ORDER BY sort_order

/var/www/ubiquiti-russia.com/data/www/ubiquiti-russia.com/catalog/model/design/layout.php:14

44 (0.317)

SELECT DISTINCT f.sort_order, f2l.form_id
FROM ocdw_form_builder_form f
LEFT JOIN ocdw_form_builder_form_to_layout_for_module f2l ON (f.form_id = f2l.form_id)
WHERE f2l.layout_id = '21' AND f.position = 'content_bottom' AND f.display_type = '2' AND f.status = '1'
ORDER BY f.sort_order ASC

/var/www/ubiquiti-russia.com/data/www/ubiquiti-russia.com/catalog/model/extension/ocdevwizard/form_builder.php:15

45 (0.240)

SELECT *
FROM theme
WHERE store_id = '0' AND theme = 'prostore' AND route = 'common/content_bottom'

/var/www/ubiquiti-russia.com/data/www/ubiquiti-russia.com/catalog/model/design/theme.php:4

46 (0.379)

SELECT *
FROM translation
WHERE store_id = '0' AND language_id = '1' AND (route = 'common/footer' OR route = 'ru-ru')

/var/www/ubiquiti-russia.com/data/www/ubiquiti-russia.com/catalog/model/design/translation.php:6

47 (1.132)

SELECT *
FROM information i
LEFT JOIN information_description id ON (i.information_id = id.information_id)
LEFT JOIN information_to_store i2s ON (i.information_id = i2s.information_id)
WHERE id.language_id = '1' AND i2s.store_id = '0' AND i.status = '1'
ORDER BY i.sort_order, LCASE(id.title) ASC

/var/www/ubiquiti-russia.com/data/www/ubiquiti-russia.com/catalog/model/catalog/information.php:10

48 (0.340)

SELECT *
FROM theme
WHERE store_id = '0' AND theme = 'prostore' AND route = 'extension/module/microdatapro/company'

/var/www/ubiquiti-russia.com/data/www/ubiquiti-russia.com/catalog/model/design/theme.php:4

49 (0.462)

SELECT *
FROM translation
WHERE store_id = '0' AND language_id = '1' AND (route = 'extension/theme/prostore' OR route = 'ru-ru')

/var/www/ubiquiti-russia.com/data/www/ubiquiti-russia.com/catalog/model/design/translation.php:6

50 (0.298)

SELECT *
FROM translation
WHERE store_id = '0' AND language_id = '1' AND (route = 'checkout/checkout' OR route = 'ru-ru')

/var/www/ubiquiti-russia.com/data/www/ubiquiti-russia.com/catalog/model/design/translation.php:6

51 (0.309)

SELECT *
FROM theme
WHERE store_id = '0' AND theme = 'prostore' AND route = 'product/buyclick_form'

/var/www/ubiquiti-russia.com/data/www/ubiquiti-russia.com/catalog/model/design/theme.php:4

52 (0.482)

SELECT *
FROM translation
WHERE store_id = '0' AND language_id = '1' AND (route = 'extension/theme/prostore' OR route = 'ru-ru')

/var/www/ubiquiti-russia.com/data/www/ubiquiti-russia.com/catalog/model/design/translation.php:6

53 (0.356)

SELECT *
FROM seo_url
WHERE `query` = 'extension/module/prostore_news/getnewslist'

/var/www/ubiquiti-russia.com/data/www/ubiquiti-russia.com/system/storage/modification/catalog/controller/startup/seo_url.php:275

54 (0.334)

SELECT *
FROM seo_url
WHERE `query` = 'extension/module/prostore_news/getnewslist'

/var/www/ubiquiti-russia.com/data/www/ubiquiti-russia.com/system/storage/modification/catalog/controller/startup/seo_url.php:275

55 (0.560)

SELECT DISTINCT *
FROM information i
LEFT JOIN information_description id ON (i.information_id = id.information_id)
LEFT JOIN information_to_store i2s ON (i.information_id = i2s.information_id)
WHERE i.information_id = '8' AND id.language_id = '1' AND i2s.store_id = '0' AND i.status = '1'

/var/www/ubiquiti-russia.com/data/www/ubiquiti-russia.com/catalog/model/catalog/information.php:4

56 (0.531)

SELECT *
FROM setting
WHERE store_id = '0' AND `code` = 'theme_prostoresoclinks'

/var/www/ubiquiti-russia.com/data/www/ubiquiti-russia.com/catalog/model/setting/setting.php:6

57 (0.452)

SELECT *
FROM setting
WHERE store_id = '0' AND `code` = 'theme_prostoremeslinks'

/var/www/ubiquiti-russia.com/data/www/ubiquiti-russia.com/catalog/model/setting/setting.php:6

58 (0.482)

SELECT *
FROM country
WHERE country_id = '176' AND status = '1'

/var/www/ubiquiti-russia.com/data/www/ubiquiti-russia.com/catalog/model/localisation/country.php:4

59 (0.402)

SELECT *
FROM zone
WHERE zone_id = '2761' AND status = '1'

/var/www/ubiquiti-russia.com/data/www/ubiquiti-russia.com/catalog/model/localisation/zone.php:4

60 (0.519)

/var/www/ubiquiti-russia.com/data/www/ubiquiti-russia.com/catalog/model/catalog/information.php:4

61 (0.354)

SELECT *
FROM theme
WHERE store_id = '0' AND theme = 'prostore' AND route = 'extension/module/callback'

/var/www/ubiquiti-russia.com/data/www/ubiquiti-russia.com/catalog/model/design/theme.php:4

62 (0.332)

SELECT *
FROM theme
WHERE store_id = '0' AND theme = 'prostore' AND route = 'common/footer'

/var/www/ubiquiti-russia.com/data/www/ubiquiti-russia.com/catalog/model/design/theme.php:4

63 (3.344)

SELECT language_id
FROM language
WHERE code = 'ru-ru'

/var/www/ubiquiti-russia.com/data/www/ubiquiti-russia.com/catalog/model/extension/ocdevwizard/form_builder.php:741

64 (0.438)

SELECT form_id
FROM ocdw_form_builder_form
WHERE display_type IN (1,3) AND selector_module_call_status = '1'

/var/www/ubiquiti-russia.com/data/www/ubiquiti-russia.com/catalog/model/extension/ocdevwizard/form_builder.php:39

65 (0.367)

SELECT *
FROM extension
WHERE `type` = 'analytics'

/var/www/ubiquiti-russia.com/data/www/ubiquiti-russia.com/catalog/model/setting/extension.php:4

66 (0.332)

SELECT *
FROM translation
WHERE store_id = '0' AND language_id = '1' AND (route = 'common/header' OR route = 'ru-ru')

/var/www/ubiquiti-russia.com/data/www/ubiquiti-russia.com/catalog/model/design/translation.php:6

67 (0.275)

SELECT *
FROM translation
WHERE store_id = '0' AND language_id = '1' AND (route = 'extension/theme/prostore' OR route = 'ru-ru')

/var/www/ubiquiti-russia.com/data/www/ubiquiti-russia.com/catalog/model/design/translation.php:6

68 (0.502)

SELECT *
FROM setting
WHERE store_id = '0' AND `code` = 'theme_prostoremeslinks'

/var/www/ubiquiti-russia.com/data/www/ubiquiti-russia.com/catalog/model/setting/setting.php:6

69 (0.322)

SELECT *
FROM cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = 'aa604af004f612d79fb9a4b4d1'

/var/www/ubiquiti-russia.com/data/www/ubiquiti-russia.com/system/storage/modification/system/library/cart/cart.php:36

70 (0.232)

SELECT *
FROM cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = 'aa604af004f612d79fb9a4b4d1'

/var/www/ubiquiti-russia.com/data/www/ubiquiti-russia.com/system/storage/modification/system/library/cart/cart.php:36

71 (0.327)

SELECT *
FROM seo_url
WHERE `query` = 'extension/module/prostore_news/getnewslist'

/var/www/ubiquiti-russia.com/data/www/ubiquiti-russia.com/system/storage/modification/catalog/controller/startup/seo_url.php:275

72 (0.316)

SELECT *
FROM seo_url
WHERE `query` = 'extension/module/prostore_news/getnewslist'

/var/www/ubiquiti-russia.com/data/www/ubiquiti-russia.com/system/storage/modification/catalog/controller/startup/seo_url.php:275

73 (0.266)

SELECT *
FROM translation
WHERE store_id = '0' AND language_id = '1' AND (route = 'product/compare' OR route = 'ru-ru')

/var/www/ubiquiti-russia.com/data/www/ubiquiti-russia.com/catalog/model/design/translation.php:6

74 (1.258)

SELECT *
FROM category c
LEFT JOIN category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '0' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)