MySQL Debugger Results
Count	SQL query	Time to execute
1	SELECT id, word, lang_1 as text FROM shop_language_words	0,001
2	SELECT local_url FROM shop_seo WHERE seo_url = ?	0,0002
3	SELECT id, parent_id FROM shop_categories WHERE seo_url = 'ured-za-zapazvane-na-danni-12v-dc'	0,0015
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,0013
7	*SELECT FROM shop_promocodes WHERE active = 1 AND is_badge = 1**	0,0003
8	SELECT `id` as `value`, `name` as `title` FROM `shop_properties` ORDER by `value` ASC	0,0004
9	*SELECT FROM `shop_products` WHERE id = ?**	0,0008
10	*SELECT FROM `shop_categories` WHERE id = ?**	0,0003
11	SELECT id FROM shop_products WHERE active = 1 AND not_instock = 0 AND category_id = ? ORDER BY views DESC LIMIT 2	0,0003
12	SELECT id FROM shop_products WHERE category_id = ? AND active = 1 AND not_instock = 0 AND price_sell > 0 ORDER BY price_sell ASC LIMIT 2	0,0003
13	SELECT id FROM shop_products WHERE category_id = ? AND active = 1 AND not_instock = 0 ORDER BY price_sell DESC LIMIT 2	0,0002
14	SELECT id FROM shop_products WHERE category_id = ? AND active = 1 AND is_onsale = 1 AND not_instock = 0 ORDER BY RAND() LIMIT 1	0,0005
15	SELECT id FROM shop_products WHERE category_id = ? AND active = 1 AND is_onsale = 1 AND not_instock = 0 ORDER BY RAND() LIMIT 1	0,0003
16	SELECT id FROM shop_products WHERE category_id = ? AND active = 1 AND is_onsale = 0 AND not_instock = 0 AND is_promo = 1 AND is_promocatalog = 0 ORDER BY RAND() LIMIT 1	0,0003
17	SELECT id FROM shop_products WHERE category_id = ? AND active = 1 AND is_onsale = 0 AND not_instock = 0 AND is_promo = 1 AND is_promocatalog = 1 ORDER BY RAND() LIMIT 1	0,0003
18	SELECT `id` as `value`, `t` as `title` FROM `fm_brands` ORDER by `value` ASC	0,0013
19	SELECT p.id, p.is_onsale, p.priority, p.name, p.second_name, p.product_code, p.description, p.brand_id, p.model, p.active, p.not_instock, p.not_instock_status, p.price_sell, p.price_shop, p.price_promo, p.price_dealer, p.is_promo, p.is_top_landing, p.image, p.images, p.category_id, p.properties, p.seo_url, p.price_promo_to, p.promo_description, p.is_promocatalog, p.promo_quantity, IF((pp.moneta_instorage + pp.other_instorage) > 10,10,(pp.moneta_instorage + pp.other_instorage)) last_qty, COALESCE(( SELECT CASE WHEN SUM(quantity) <= 5 THEN CONCAT(CAST(SUM(quantity) AS CHAR),"+") WHEN SUM(quantity) <= 10 THEN '5+' WHEN SUM(quantity) <= 20 THEN '10+' WHEN SUM(quantity) <= 30 THEN '20+' WHEN SUM(quantity) <= 40 THEN '30+' WHEN SUM(quantity) <= 50 THEN '40+' WHEN SUM(quantity) <= 60 THEN '50+' WHEN SUM(quantity) >= 60 THEN '60+' ELSE '0' END AS total_ordered_quantity FROM shop_order_items WHERE product_id = p.id ),0) total_ordered_quantity , b.t AS brand_name FROM shop_products AS p LEFT JOIN fm_pr AS pp ON pp.id = p.id LEFT JOIN fm_brands AS b ON b.id = p.brand_id WHERE p.id IN () ORDER BY FIELD(p.id, )	0,0003
20	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 FIELD(p.id, )' at line 23	0,0003
- -	All Queries Time	0,0103

#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 p.id, p....', 'SQLSTATE[42000]...')
#2 /home/mashini/public_html/app/modules/Store/models/Products.model.php(506): Database->fetchAll('SELECT p.id, p....')
#3 /home/mashini/public_html/app/modules/Store/front/Products.controller.php(118): Products->getTenOffers('581')
#4 /home/mashini/public_html/app/system/Controller.class.php(209): ProductsController->viewAction()
#5 /home/mashini/public_html/index.php(126): Controller->Start()
#6 {main}

'lang' is not set in the Registry