MySQL Debugger Results
Count	SQL query	Time to execute
1	SELECT code FROM shop_languages WHERE id = ?	0.0002
2	SELECT id, word, lang_1 as text FROM shop_language_words	0.0013
3	*SELECT FROM currency**	0.0002
4	*SELECT FROM shop_redirects WHERE old_url = ?**	0.0002
5	SELECT local_url FROM shop_seo WHERE seo_url = ?	0.0001
6	SELECT seo_url FROM shop_seo WHERE local_url = ?	0.0044
7	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.0002
8	*SELECT FROM `shop_languages` WHERE id = ?**	0.0002
9	SELECT `id` as `value`, `name` as `title` FROM `shop_properties` ORDER by `value` ASC	0.0008
10	SELECT `id` as `value`, `name` as `title` FROM `shop_properties` ORDER by `value` ASC	0.0008
11	*SELECT COUNT() AS count FROM shop_products WHERE is_available = 1 AND active = 1 AND archive = 0**	0.0003
12	*SELECT COUNT() AS count FROM shop_products WHERE archive = 1**	0.0071
13	*SELECT FROM shop_categories WHERE id = '0'**	0.0003
14	SELECT sc., (SELECT COUNT() FROM shop_marketplace spc WHERE spc.parent_category_id = sc.id AND spc.active = 1 AND spc.status = 1) active_products FROM shop_categories sc WHERE sc.template = 6 AND sc.parent_id = AND sc.active = 1	0.0002
15	SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND sc.active = 1' at line 1	0.0002
- -	All Queries Time	0.0165

#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/Marketplace.model.php(35): Database->fetchAll()
#3 /var/www/bautrax.bg/www/app/modules/Store/front/Marketplace.controller.php(59): Marketplace->load()
#4 /var/www/bautrax.bg/www/app/system/Controller.class.php(257): MarketplaceController->indexAction()
#5 /var/www/bautrax.bg/www/index.php(124): Controller->Start()
#6 {main}

'lang' is not set in the Registry