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 = 'oklima' 0,0006
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,0001
6 SELECT `id` as `value`, `t` as `title` FROM `fm_brands` ORDER by `value` ASC 0,0011
7 SELECT * FROM shop_promocodes WHERE active = 1 AND is_badge = 1 0,0002
8 SELECT `id` as `value`, `t` as `title` FROM `fm_brands` ORDER by `value` ASC 0,001
9 SELECT `id` as `value`, `name` as `title` FROM `shop_properties` ORDER by `value` ASC 0,0002
10 SELECT id, name FROM shop_properties 0,0002
11 SELECT * FROM `fm_brands` WHERE id = ? 0,0002
12 SELECT c.id, c.parent_id, c.name, c.active, c.shown_name, c.seo_url, COUNT(p.id) AS active_products, c.main_image 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 = ? GROUP BY c.id ORDER BY sortorder ASC, name ASC 0,0006
13 SELECT parent_id FROM shop_categories WHERE id = ? 0,0002
14 SELECT parent_id FROM shop_categories WHERE id = ? 0,0001
15 SELECT parent_id FROM shop_categories WHERE id = ? 0,0001
16 SELECT parent_id FROM shop_categories WHERE id = ? 0,0001
17 SELECT p.id, p.is_onsale, p.priority, p.name, p.second_name, p.product_code, p.description, p.brand_id, p.is_new, 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.instorage + pp.other_instorage) > 10,10,(pp.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 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 p.not_instock ASC, IF(pp.instorage > 0,1,0) DESC, p.priority DESC, p.is_onsale DESC, p.is_promocatalog DESC, p.is_promo DESC, ROUND((1 - (p.price_shop / p.price_sell)) * 100, 0) DESC, p.views DESC 0,0006
18 SQLSTATE[HY000]: General error: 1021 Disk full (/var/tmp/#sql_76b3_1.MAI); waiting for someone to free some space... (errno: 28 "No space left on device") 0,0006
- - All Queries Time 0,0073 


#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[HY000]...')
#2 /home/mashini/public_html/app/modules/Store/models/Search.model.php(489): Database->fetchAll('SELECT p.id, p....', Array)
#3 /home/mashini/public_html/app/modules/Store/models/Search.model.php(285): Search->getAllBrandProducts(253, 0)
#4 /home/mashini/public_html/app/modules/Store/front/Brands.controller.php(24): Search->loadBrand(253, 0)
#5 /home/mashini/public_html/app/system/Controller.class.php(209): BrandsController->indexAction()
#6 /home/mashini/public_html/index.php(126): Controller->Start()
#7 {main}

'lang' is not set in the Registry