| 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 | SELECT id, parent_id FROM shop_categories WHERE seo_url = 'elektricheski-hrastorezi' | 0,0006 |
| 4 | SELECT id, parent_id FROM shop_categories WHERE active = 1 | 0,0004 |
| 5 | SELECT COUNT(*) FROM shop_products WHERE category_id IN (621) AND active = 1 AND archive = 0 | 0,0005 |
| 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,0001 |
| 7 | SELECT * FROM `shop_languages` WHERE id = ? | 0,0001 |
| 8 | SELECT `id` as `value`, `t` as `title` FROM `fm_brands` ORDER by `value` ASC | 0,0018 |
| 9 | SELECT * FROM shop_promocodes WHERE active = 1 AND is_badge = 1 | 0,0006 |
| 10 | SELECT `id` as `value`, `t` as `title` FROM `fm_brands` ORDER by `value` ASC | 0,0011 |
| 11 | SELECT `id` as `value`, `name` as `title` FROM `shop_properties` ORDER by `value` ASC | 0,0002 |
| 12 | SELECT id, name FROM shop_properties | 0,0002 |
| 13 | SELECT * FROM `shop_categories` WHERE id = ? | 0,0002 |
| 14 | SELECT * FROM `shop_categories` WHERE id = ? | 0,0002 |
| 15 | SELECT * FROM `shop_categories` WHERE id = ? | 0,0002 |
| 16 | SELECT * FROM `shop_categories` WHERE id = ? | 0,0002 |
| 17 | SELECT id, name, active_products, active, shown_name, seo_url, icon, parent_id, main_image FROM shop_categories WHERE active_products > 0 AND parent_id = ? ORDER BY name ASC | 0,0003 |
| 18 | SELECT id, name, active_products, active, shown_name, seo_url, parent_id, main_image FROM shop_categories WHERE active_products > 0 AND parent_id = ? ORDER BY name ASC | 0,0001 |
| 19 | SELECT id, name, active_products, active, shown_name, seo_url, parent_id, main_image FROM shop_categories WHERE active_products > 0 AND parent_id = ? ORDER BY name ASC | 0,0001 |
| 20 | SELECT id, name, active_products, active, shown_name, seo_url, parent_id, main_image FROM shop_categories WHERE active_products > 0 AND parent_id = ? ORDER BY name ASC | 0,0001 |
| 21 | SELECT id, name, active_products, active, shown_name, seo_url, parent_id, main_image FROM shop_categories WHERE active_products > 0 AND parent_id = ? ORDER BY name ASC | 0,0001 |
| 22 | SELECT id, name, active_products, active, shown_name, seo_url, parent_id, main_image FROM shop_categories WHERE active_products > 0 AND parent_id = ? ORDER BY name ASC | 0,0001 |
| 23 | SELECT id, name, active_products, active, shown_name, seo_url, parent_id, main_image FROM shop_categories WHERE active_products > 0 AND parent_id = ? ORDER BY name ASC | 0,0001 |
| 24 | SELECT id, name, active_products, active, shown_name, seo_url, parent_id, main_image FROM shop_categories WHERE active_products > 0 AND parent_id = ? ORDER BY name ASC | 0,0001 |
| 25 | SELECT id, name, active_products, active, shown_name, seo_url, parent_id, main_image FROM shop_categories WHERE active_products > 0 AND parent_id = ? ORDER BY name ASC | 0,0001 |
| 26 | SELECT id, name, active_products, active, shown_name, seo_url, parent_id, main_image FROM shop_categories WHERE active_products > 0 AND parent_id = ? ORDER BY name ASC | 0,0001 |
| 27 | SELECT id, name, active_products, active, shown_name, seo_url, parent_id, main_image FROM shop_categories WHERE active_products > 0 AND parent_id = ? ORDER BY name ASC | 0,0001 |
| 28 | SELECT id, name, active_products, active, shown_name, seo_url, parent_id, main_image FROM shop_categories WHERE active_products > 0 AND parent_id = ? ORDER BY name ASC | 0,0001 |
| 29 | SELECT id, name, active_products, active, shown_name, seo_url, parent_id, main_image FROM shop_categories WHERE active_products > 0 AND parent_id = ? ORDER BY name ASC | 0,0001 |
| 30 | SELECT id, name, active_products, active, shown_name, seo_url, parent_id, main_image FROM shop_categories WHERE active_products > 0 AND parent_id = ? ORDER BY name ASC | 0,0001 |
| 31 | SELECT id, name, active_products, active, shown_name, seo_url, parent_id, main_image FROM shop_categories WHERE active_products > 0 AND parent_id = ? ORDER BY name ASC | 0,0001 |
| 32 | SELECT id, name, active_products, active, shown_name, seo_url, parent_id, main_image FROM shop_categories WHERE active_products > 0 AND parent_id = ? ORDER BY name ASC | 0,0002 |
| 33 | SELECT id, name, active_products, active, shown_name, seo_url, parent_id, main_image FROM shop_categories WHERE active_products > 0 AND parent_id = ? ORDER BY name ASC | 0,0001 |
| 34 | SELECT id, name, active_products, active, shown_name, seo_url, parent_id, main_image FROM shop_categories WHERE active_products > 0 AND parent_id = ? ORDER BY name ASC | 0,0001 |
| 35 | SELECT id, name, active_products, active, shown_name, seo_url, parent_id, main_image FROM shop_categories WHERE active_products > 0 AND parent_id = ? ORDER BY name ASC | 0,0001 |
| 36 | SELECT id, name, active_products, active, shown_name, seo_url, parent_id, main_image FROM shop_categories WHERE active_products > 0 AND parent_id = ? ORDER BY name ASC | 0,0001 |
| 37 | SELECT id, name, active_products, active, shown_name, seo_url, parent_id, main_image FROM shop_categories WHERE active_products > 0 AND parent_id = ? ORDER BY name ASC | 0,0001 |
| 38 | SELECT id, name, active_products, active, shown_name, seo_url, parent_id, main_image FROM shop_categories WHERE active_products > 0 AND parent_id = ? ORDER BY name ASC | 0,0001 |
| 39 | SELECT id, name, active_products, active, shown_name, seo_url, parent_id, main_image FROM shop_categories WHERE active_products > 0 AND parent_id = ? ORDER BY name ASC | 0,0002 |
| 40 | SELECT id, name, active_products, active, shown_name, seo_url, parent_id, main_image FROM shop_categories WHERE active_products > 0 AND parent_id = ? ORDER BY name ASC | 0,0002 |
| 41 | SELECT id, name, active_products, active, shown_name, seo_url, parent_id, main_image FROM shop_categories WHERE active_products > 0 AND parent_id = ? ORDER BY name ASC | 0,0002 |
| 42 | SELECT id, name, active_products, active, shown_name, seo_url, parent_id, main_image FROM shop_categories WHERE active_products > 0 AND parent_id = ? ORDER BY name ASC | 0,0002 |
| 43 | SELECT id, name, active_products, active, shown_name, seo_url, parent_id, main_image FROM shop_categories WHERE active_products > 0 AND parent_id = ? ORDER BY name ASC | 0,0002 |
| 44 | SELECT id, name, active_products, active, shown_name, seo_url, parent_id, main_image FROM shop_categories WHERE active_products > 0 AND parent_id = ? ORDER BY name ASC | 0,0003 |
| 45 | SELECT id, name, active_products, active, shown_name, seo_url, parent_id, main_image FROM shop_categories WHERE active_products > 0 AND parent_id = ? ORDER BY name ASC | 0,0002 |
| 46 | SELECT id, name, active_products, active, shown_name, seo_url, parent_id, main_image FROM shop_categories WHERE active_products > 0 AND parent_id = ? ORDER BY name ASC | 0,0002 |
| 47 | SELECT id, name, active_products, active, shown_name, seo_url, parent_id, main_image FROM shop_categories WHERE active_products > 0 AND parent_id = ? ORDER BY name ASC | 0,0001 |
| 48 | SELECT id, name, active_products, active, shown_name, seo_url, parent_id, main_image FROM shop_categories WHERE active_products > 0 AND parent_id = ? ORDER BY name ASC | 0,0001 |
| 49 | SELECT id, name, active_products, active, shown_name, seo_url, parent_id, main_image FROM shop_categories WHERE active_products > 0 AND parent_id = ? ORDER BY name ASC | 0,0001 |
| 50 | SELECT id, name, active_products, active, shown_name, seo_url, parent_id, main_image FROM shop_categories WHERE active_products > 0 AND parent_id = ? ORDER BY name ASC | 0,0001 |
| 51 | SELECT id, name, active_products, active, shown_name, seo_url, parent_id, main_image FROM shop_categories WHERE active_products > 0 AND parent_id = ? ORDER BY name ASC | 0,0001 |
| 52 | SELECT id, name, active_products, active, shown_name, seo_url, parent_id, main_image FROM shop_categories WHERE active_products > 0 AND parent_id = ? ORDER BY name ASC | 0,0001 |
| 53 | SELECT id, name, active_products, active, shown_name, seo_url, parent_id, main_image FROM shop_categories WHERE active_products > 0 AND parent_id = ? ORDER BY name ASC | 0,0001 |
| 54 | SELECT id, name, active_products, active, shown_name, seo_url, parent_id, main_image FROM shop_categories WHERE active_products > 0 AND parent_id = ? ORDER BY name ASC | 0,0001 |
| 55 | SELECT id, name, active_products, active, shown_name, seo_url, parent_id, main_image FROM shop_categories WHERE active_products > 0 AND parent_id = ? ORDER BY name ASC | 0,0001 |
| 56 | SELECT id, name, active_products, active, shown_name, seo_url, parent_id, main_image FROM shop_categories WHERE active_products > 0 AND parent_id = ? ORDER BY name ASC | 0,0001 |
| 57 | SELECT id, name, active_products, active, shown_name, seo_url, parent_id, main_image FROM shop_categories WHERE active_products > 0 AND parent_id = ? ORDER BY name ASC | 0,0001 |
| 58 | SELECT id, name, active_products, active, shown_name, seo_url, parent_id, main_image FROM shop_categories WHERE active_products > 0 AND parent_id = ? ORDER BY name ASC | 0,0002 |
| 59 | SELECT id, name, active_products, active, shown_name, seo_url, parent_id, main_image FROM shop_categories WHERE active_products > 0 AND parent_id = ? ORDER BY name ASC | 0,0001 |
| 60 | SELECT id, name, active_products, active, shown_name, seo_url, parent_id, main_image FROM shop_categories WHERE active_products > 0 AND parent_id = ? ORDER BY name ASC | 0,0001 |
| 61 | SELECT id, name, active_products, active, shown_name, seo_url, parent_id, main_image FROM shop_categories WHERE active_products > 0 AND parent_id = ? ORDER BY name ASC | 0,0001 |
| 62 | SELECT id, name, active_products, active, shown_name, seo_url, parent_id, main_image FROM shop_categories WHERE active_products > 0 AND parent_id = ? ORDER BY name ASC | 0,0001 |
| 63 | SELECT id, name, active_products, active, shown_name, seo_url, parent_id, main_image FROM shop_categories WHERE active_products > 0 AND parent_id = ? ORDER BY name ASC | 0,0001 |
| 64 | SELECT id, name, active_products, active, shown_name, seo_url, parent_id, main_image FROM shop_categories WHERE active_products > 0 AND parent_id = ? ORDER BY name ASC | 0,0001 |
| 65 | SELECT id, name, active_products, active, shown_name, seo_url, parent_id, main_image FROM shop_categories WHERE active_products > 0 AND parent_id = ? ORDER BY name ASC | 0,0001 |
| 66 | SELECT id, name, active_products, active, shown_name, seo_url, parent_id, main_image FROM shop_categories WHERE active_products > 0 AND parent_id = ? ORDER BY name ASC | 0,0001 |
| 67 | SELECT id, name, active_products, active, shown_name, seo_url, parent_id, main_image FROM shop_categories WHERE active_products > 0 AND parent_id = ? ORDER BY name ASC | 0,0001 |
| 68 | SELECT id, name, active_products, active, shown_name, seo_url, parent_id, main_image FROM shop_categories WHERE active_products > 0 AND parent_id = ? ORDER BY name ASC | 0,0001 |
| 69 | SELECT id, name, active_products, active, shown_name, seo_url, parent_id, main_image FROM shop_categories WHERE active_products > 0 AND parent_id = ? ORDER BY name ASC | 0,0001 |
| 70 | SELECT id, name, active_products, active, shown_name, seo_url, parent_id, main_image FROM shop_categories WHERE active_products > 0 AND parent_id = ? ORDER BY name ASC | 0,0001 |
| 71 | SELECT id, name, active_products, active, shown_name, seo_url, parent_id, main_image FROM shop_categories WHERE active_products > 0 AND parent_id = ? ORDER BY name ASC | 0,0001 |
| 72 | SELECT id, name, active_products, active, shown_name, seo_url, parent_id, main_image FROM shop_categories WHERE active_products > 0 AND parent_id = ? ORDER BY name ASC | 0,0001 |
| 73 | SELECT id, name, active_products, active, shown_name, seo_url, parent_id, main_image FROM shop_categories WHERE active_products > 0 AND parent_id = ? ORDER BY name ASC | 0,0001 |
| 74 | SELECT id, name, active_products, active, shown_name, seo_url, parent_id, main_image FROM shop_categories WHERE active_products > 0 AND parent_id = ? ORDER BY name ASC | 0,0001 |
| 75 | SELECT id, name, active_products, active, shown_name, seo_url, parent_id, main_image FROM shop_categories WHERE active_products > 0 AND parent_id = ? ORDER BY name ASC | 0,0001 |
| 76 | SELECT id, name, active_products, active, shown_name, seo_url, parent_id, main_image FROM shop_categories WHERE active_products > 0 AND parent_id = ? ORDER BY name ASC | 0,0001 |
| 77 | 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 , 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.active = 1 AND p.id IN (SELECT product_id FROM shop_product_categories WHERE category_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,0009 |
| 78 | SQLSTATE[HY000]: General error: 1021 Disk full (/var/tmp/#sql_76b3_2.MAI); waiting for someone to free some space... (errno: 28 "No space left on device") | 0,0009 |
| - - | All Queries Time | 0,0166 |
#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(331): Database->fetchAll('SELECT p.id, p....', Array)
#3 /home/mashini/public_html/app/modules/Store/models/Search.model.php(178): Search->getAllProducts(621)
#4 /home/mashini/public_html/app/modules/Store/front/Categories.controller.php(19): Search->load(621, false)
#5 /home/mashini/public_html/app/modules/Store/front/Categories.controller.php(283): CategoriesController->prepareViewData(false)
#6 /home/mashini/public_html/app/system/Controller.class.php(209): CategoriesController->indexAction()
#7 /home/mashini/public_html/index.php(126): Controller->Start()
#8 {main}'lang' is not set in the Registry