MySQL Debugger Results
Count	SQL query	Time to execute
1	SELECT id, word, lang_1 as text FROM shop_language_words	0,0009
2	SELECT local_url FROM shop_seo WHERE seo_url = ?	0,0002
3	INSERT INTO shop_logs (add_date, ip, url, user_agent) VALUES ('2023-06-10 23:29:06', '44.200.82.149', '/geko', 'CCBot/2.0 (https://commoncrawl.org/faq/)')	0,0002
4	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
5	*SELECT FROM `shop_languages` WHERE id = ?**	0,0002
6	SELECT `id` as `value`, `t` as `title` FROM `fm_brands` ORDER by `value` ASC	0,0016
7	SELECT `id` as `value`, `t` as `title` FROM `fm_brands` ORDER by `value` ASC	0,0009
8	SELECT `id` as `value`, `name` as `title` FROM `shop_properties` ORDER by `value` ASC	0,0002
9	*SELECT FROM `fm_brands` WHERE id = ?**	0,0002
10	SELECT c.id, c.parent_id, c.name, c.active, c.shown_name, c.seo_url, COUNT(p.id) as active_products FROM shop_categories AS c LEFT JOIN shop_product_categories AS pc ON c.id = pc.category_id LEFT JOIN shop_products AS p ON pc.product_id = p.id WHERE p.active = 1 AND c.parent_id != 0 AND p.brand_id = '21' GROUP BY c.id ORDER BY sortorder ASC, name ASC	0,001
11	*SELECT p. FROM shop_products as p LEFT JOIN fm_pr AS pp ON pp.id = p.id WHERE p.active = 1 AND brand_id = ? ORDER BY pp.instorage DESC, p.priority DESC, p.views DESC**	0,0013
12	SELECT id, parent_id, name, active, shown_name, seo_url, active_products FROM shop_categories WHERE id IN () ORDER BY name ASC	0,0001
13	SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ') ORDER BY name ASC' at line 1	0,0001
- -	All Queries Time	0,0071

#0 /home/mashini/public_html/app/system/Database.class.php(503): Registry::get('lang')
#1 /home/mashini/public_html/app/system/Database.class.php(129): Database->onDbError('SELECT id, pare...', 'SQLSTATE[42000]...')
#2 /home/mashini/public_html/app/modules/Store/models/Search.model.php(279): Database->fetchAll('SELECT id, pare...')
#3 /home/mashini/public_html/app/modules/Store/front/Brands.controller.php(15): Search->getRemainingCategories(true)
#4 /home/mashini/public_html/app/system/Controller.class.php(209): BrandsController->indexAction()
#5 /home/mashini/public_html/index.php(106): Controller->Start()
#6 {main}

'lang' is not set in the Registry