MySQL Debugger Results
Count	SQL query	Time to execute
1	SELECT code FROM shop_languages WHERE id = ?	0.0098
2	SELECT id, word, lang_1 as text FROM shop_language_words	0.0121
3	*SELECT FROM currency**	0.0207
4	*SELECT FROM shop_redirects WHERE old_url = ?**	0.0111
5	SELECT id FROM fm_brands WHERE seo_url IN('cm','malaguti','brokk','ringer','mbw-europe','kardesler','green-lifter','smart-lift')	0.0081
6	SELECT t.id,t.language,t.code,t.flag,t.active FROM `shop_languages` AS t WHERE 1 AND t.`active` = '1' ORDER BY id DESC LIMIT 0, 300	0.0142
7	*SELECT FROM `shop_languages` WHERE id = ?**	0.0098
8	SELECT `id` as `value`, `name` as `title` FROM `shop_properties` ORDER by `value` ASC	0.0087
9	SELECT `id` as `value`, `name` as `title` FROM `shop_properties` ORDER by `value` ASC	0.0102
10	*SELECT COUNT() AS count FROM shop_products WHERE is_available = 1 AND active = 1 AND archive = 0**	0.0269
11	*SELECT COUNT() AS count FROM shop_products WHERE archive = 1**	0.017
12	SELECT `id` as `value`, `t` as `title` FROM `fm_brands` ORDER by `value` ASC	0.0145
13	*SELECT FROM `shop_categories` WHERE id = ?**	0.0012
14	*SELECT FROM shop_categories WHERE ((active = 1 AND template != 1) OR (active_products > 0 AND template = 1)) AND parent_id = ? ORDER BY name ASC**	0.0025
15	*SELECT FROM shop_categories WHERE ((active = 1 AND template != 1) OR (active_products > 0 AND template = 1)) AND parent_id = 653 ORDER BY name ASC**	0.0283
16	*SELECT FROM shop_categories WHERE ((active = 1 AND template != 1) OR (active_products > 0 AND template = 1)) AND parent_id = 2323 ORDER BY name ASC**	0.8751
17	*SELECT FROM shop_categories WHERE ((active = 1 AND template != 1) OR (active_products > 0 AND template = 1)) AND parent_id = 2480 ORDER BY name ASC**	0.3035
18	SQLSTATE[HY000]: General error: 2006 MySQL server has gone away	0.3035
- -	All Queries Time	1.6772

#0 /var/www/bautrax.bg/www/app/system/Database.class.php(536): Registry::get()
#1 /var/www/bautrax.bg/www/app/system/Database.class.php(135): Database->onDbError()
#2 /var/www/bautrax.bg/www/app/modules/Store/models/Categories.model.php(248): Database->fetchAll()
#3 /var/www/bautrax.bg/www/app/modules/Store/models/Search.model.php(77): Categories->getCategoriesWithParentBySort()
#4 /var/www/bautrax.bg/www/app/modules/Store/front/Categories.controller.php(28): Search->load()
#5 /var/www/bautrax.bg/www/app/system/Controller.class.php(257): CategoriesController->indexAction()
#6 /var/www/bautrax.bg/www/index.php(124): Controller->Start()
#7 {main}

'lang' is not set in the Registry