| 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 = 'bosch-akumulatorni-takeri' | 0,0005 |
| 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 * FROM `shop_categories` WHERE id = ? | 0,0002 |
| 13 | 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,0234 |
| 14 | SELECT parent_id FROM shop_categories WHERE id = ? | 0,0003 |
| 15 | SELECT parent_id FROM shop_categories WHERE id = ? | 0,0017 |
| 16 | SELECT parent_id FROM shop_categories WHERE id = ? | 0,0027 |
| 17 | SELECT parent_id FROM shop_categories WHERE id = ? | 0,0011 |
| 18 | SELECT parent_id FROM shop_categories WHERE id = ? | 0,0001 |
| 19 | SELECT parent_id FROM shop_categories WHERE id = ? | 0,0001 |
| 20 | SELECT parent_id FROM shop_categories WHERE id = ? | 0,0001 |
| 21 | SELECT parent_id FROM shop_categories WHERE id = ? | 0,0001 |
| 22 | SELECT parent_id FROM shop_categories WHERE id = ? | 0,0001 |
| 23 | SELECT parent_id FROM shop_categories WHERE id = ? | 0,0001 |
| 24 | SELECT parent_id FROM shop_categories WHERE id = ? | 0,0001 |
| 25 | SELECT parent_id FROM shop_categories WHERE id = ? | 0,0001 |
| 26 | SELECT parent_id FROM shop_categories WHERE id = ? | 0,0001 |
| 27 | SELECT parent_id FROM shop_categories WHERE id = ? | 0,0001 |
| 28 | SELECT parent_id FROM shop_categories WHERE id = ? | 0,0001 |
| 29 | SELECT parent_id FROM shop_categories WHERE id = ? | 0,0001 |
| 30 | SELECT parent_id FROM shop_categories WHERE id = ? | 0,0001 |
| 31 | SELECT parent_id FROM shop_categories WHERE id = ? | 0,0001 |
| 32 | SELECT parent_id FROM shop_categories WHERE id = ? | 0,0001 |
| 33 | SELECT parent_id FROM shop_categories WHERE id = ? | 0,0001 |
| 34 | SELECT parent_id FROM shop_categories WHERE id = ? | 0,0001 |
| 35 | SELECT parent_id FROM shop_categories WHERE id = ? | 0,0001 |
| 36 | SELECT parent_id FROM shop_categories WHERE id = ? | 0,0001 |
| 37 | SELECT parent_id FROM shop_categories WHERE id = ? | 0,0001 |
| 38 | SELECT parent_id FROM shop_categories WHERE id = ? | 0,0001 |
| 39 | SELECT parent_id FROM shop_categories WHERE id = ? | 0,0001 |
| 40 | SELECT parent_id FROM shop_categories WHERE id = ? | 0,0001 |
| 41 | SELECT parent_id FROM shop_categories WHERE id = ? | 0,0001 |
| 42 | SELECT parent_id FROM shop_categories WHERE id = ? | 0,0001 |
| 43 | SELECT parent_id FROM shop_categories WHERE id = ? | 0,0001 |
| 44 | SELECT parent_id FROM shop_categories WHERE id = ? | 0,0001 |
| 45 | SELECT parent_id FROM shop_categories WHERE id = ? | 0,0001 |
| 46 | SELECT parent_id FROM shop_categories WHERE id = ? | 0,0001 |
| 47 | SELECT parent_id FROM shop_categories WHERE id = ? | 0,0001 |
| 48 | SELECT parent_id FROM shop_categories WHERE id = ? | 0,0001 |
| 49 | SELECT parent_id FROM shop_categories WHERE id = ? | 0,0001 |
| 50 | SELECT parent_id FROM shop_categories WHERE id = ? | 0,0001 |
| 51 | SELECT parent_id FROM shop_categories WHERE id = ? | 0,0001 |
| 52 | SELECT parent_id FROM shop_categories WHERE id = ? | 0,0001 |
| 53 | SELECT parent_id FROM shop_categories WHERE id = ? | 0,0001 |
| 54 | SELECT parent_id FROM shop_categories WHERE id = ? | 0,0001 |
| 55 | SELECT parent_id FROM shop_categories WHERE id = ? | 0,0001 |
| 56 | SELECT parent_id FROM shop_categories WHERE id = ? | 0,0001 |
| 57 | SELECT parent_id FROM shop_categories WHERE id = ? | 0,0001 |
| 58 | SELECT parent_id FROM shop_categories WHERE id = ? | 0,0001 |
| 59 | SELECT parent_id FROM shop_categories WHERE id = ? | 0,0001 |
| 60 | SELECT parent_id FROM shop_categories WHERE id = ? | 0,0001 |
| 61 | SELECT parent_id FROM shop_categories WHERE id = ? | 0,0001 |
| 62 | SELECT parent_id FROM shop_categories WHERE id = ? | 0,0001 |
| 63 | SELECT parent_id FROM shop_categories WHERE id = ? | 0,0001 |
| 64 | SELECT parent_id FROM shop_categories WHERE id = ? | 0,0001 |
| 65 | SELECT parent_id FROM shop_categories WHERE id = ? | 0,0001 |
| 66 | SELECT parent_id FROM shop_categories WHERE id = ? | 0,0001 |
| 67 | SELECT parent_id FROM shop_categories WHERE id = ? | 0,0001 |
| 68 | SELECT parent_id FROM shop_categories WHERE id = ? | 0,0001 |
| 69 | SELECT parent_id FROM shop_categories WHERE id = ? | 0,0001 |
| 70 | SELECT parent_id FROM shop_categories WHERE id = ? | 0,0001 |
| 71 | SELECT parent_id FROM shop_categories WHERE id = ? | 0,0001 |
| 72 | SELECT parent_id FROM shop_categories WHERE id = ? | 0,0001 |
| 73 | SELECT parent_id FROM shop_categories WHERE id = ? | 0,0001 |
| 74 | SELECT parent_id FROM shop_categories WHERE id = ? | 0,0001 |
| 75 | SELECT parent_id FROM shop_categories WHERE id = ? | 0,0001 |
| 76 | SELECT parent_id FROM shop_categories WHERE id = ? | 0,0001 |
| 77 | SELECT parent_id FROM shop_categories WHERE id = ? | 0,0001 |
| 78 | SELECT parent_id FROM shop_categories WHERE id = ? | 0,0001 |
| 79 | SELECT parent_id FROM shop_categories WHERE id = ? | 0,0001 |
| 80 | SELECT parent_id FROM shop_categories WHERE id = ? | 0,0001 |
| 81 | SELECT parent_id FROM shop_categories WHERE id = ? | 0,0001 |
| 82 | SELECT parent_id FROM shop_categories WHERE id = ? | 0,0001 |
| 83 | SELECT parent_id FROM shop_categories WHERE id = ? | 0,0001 |
| 84 | SELECT parent_id FROM shop_categories WHERE id = ? | 0,0001 |
| 85 | SELECT parent_id FROM shop_categories WHERE id = ? | 0,0001 |
| 86 | SELECT parent_id FROM shop_categories WHERE id = ? | 0,0001 |
| 87 | SELECT parent_id FROM shop_categories WHERE id = ? | 0,0001 |
| 88 | SELECT parent_id FROM shop_categories WHERE id = ? | 0,0001 |
| 89 | SELECT parent_id FROM shop_categories WHERE id = ? | 0,0001 |
| 90 | SELECT parent_id FROM shop_categories WHERE id = ? | 0,0001 |
| 91 | SELECT parent_id FROM shop_categories WHERE id = ? | 0,0001 |
| 92 | SELECT parent_id FROM shop_categories WHERE id = ? | 0,0001 |
| 93 | SELECT parent_id FROM shop_categories WHERE id = ? | 0,0001 |
| 94 | SELECT parent_id FROM shop_categories WHERE id = ? | 0,0001 |
| 95 | SELECT parent_id FROM shop_categories WHERE id = ? | 0,0001 |
| 96 | SELECT parent_id FROM shop_categories WHERE id = ? | 0,0001 |
| 97 | SELECT parent_id FROM shop_categories WHERE id = ? | 0,0001 |
| 98 | SELECT parent_id FROM shop_categories WHERE id = ? | 0,0001 |
| 99 | SELECT parent_id FROM shop_categories WHERE id = ? | 0,0001 |
| 100 | SELECT parent_id FROM shop_categories WHERE id = ? | 0,0001 |
| 101 | SELECT parent_id FROM shop_categories WHERE id = ? | 0,0001 |
| 102 | SELECT parent_id FROM shop_categories WHERE id = ? | 0,0001 |
| 103 | SELECT parent_id FROM shop_categories WHERE id = ? | 0,0001 |
| 104 | SELECT parent_id FROM shop_categories WHERE id = ? | 0,0001 |
| 105 | SELECT parent_id FROM shop_categories WHERE id = ? | 0,0001 |
| 106 | SELECT parent_id FROM shop_categories WHERE id = ? | 0,0001 |
| 107 | SELECT parent_id FROM shop_categories WHERE id = ? | 0,0001 |
| 108 | SELECT parent_id FROM shop_categories WHERE id = ? | 0,0001 |
| 109 | SELECT parent_id FROM shop_categories WHERE id = ? | 0,0001 |
| 110 | SELECT parent_id FROM shop_categories WHERE id = ? | 0,0001 |
| 111 | SELECT parent_id FROM shop_categories WHERE id = ? | 0,0001 |
| 112 | SELECT parent_id FROM shop_categories WHERE id = ? | 0,0001 |
| 113 | SELECT parent_id FROM shop_categories WHERE id = ? | 0,0001 |
| 114 | SELECT parent_id FROM shop_categories WHERE id = ? | 0,0001 |
| 115 | SELECT parent_id FROM shop_categories WHERE id = ? | 0,0001 |
| 116 | SELECT parent_id FROM shop_categories WHERE id = ? | 0,0001 |
| 117 | SELECT parent_id FROM shop_categories WHERE id = ? | 0,0001 |
| 118 | SELECT parent_id FROM shop_categories WHERE id = ? | 0,0001 |
| 119 | SELECT parent_id FROM shop_categories WHERE id = ? | 0,0001 |
| 120 | SELECT parent_id FROM shop_categories WHERE id = ? | 0,0001 |
| 121 | SELECT parent_id FROM shop_categories WHERE id = ? | 0,0001 |
| 122 | SELECT parent_id FROM shop_categories WHERE id = ? | 0,0001 |
| 123 | SELECT parent_id FROM shop_categories WHERE id = ? | 0,0001 |
| 124 | SELECT parent_id FROM shop_categories WHERE id = ? | 0,0001 |
| 125 | SELECT parent_id FROM shop_categories WHERE id = ? | 0,0001 |
| 126 | SELECT parent_id FROM shop_categories WHERE id = ? | 0,0001 |
| 127 | SELECT parent_id FROM shop_categories WHERE id = ? | 0,0001 |
| 128 | SELECT parent_id FROM shop_categories WHERE id = ? | 0,0001 |
| 129 | SELECT parent_id FROM shop_categories WHERE id = ? | 0,0001 |
| 130 | SELECT parent_id FROM shop_categories WHERE id = ? | 0,0001 |
| 131 | SELECT parent_id FROM shop_categories WHERE id = ? | 0,0001 |
| 132 | SELECT parent_id FROM shop_categories WHERE id = ? | 0,0001 |
| 133 | SELECT parent_id FROM shop_categories WHERE id = ? | 0,0001 |
| 134 | SELECT parent_id FROM shop_categories WHERE id = ? | 0,0001 |
| 135 | SELECT parent_id FROM shop_categories WHERE id = ? | 0,0001 |
| 136 | SELECT parent_id FROM shop_categories WHERE id = ? | 0,0001 |
| 137 | SELECT parent_id FROM shop_categories WHERE id = ? | 0,0001 |
| 138 | SELECT parent_id FROM shop_categories WHERE id = ? | 0,0001 |
| 139 | SELECT parent_id FROM shop_categories WHERE id = ? | 0,0001 |
| 140 | SELECT parent_id FROM shop_categories WHERE id = ? | 0,0001 |
| 141 | SELECT parent_id FROM shop_categories WHERE id = ? | 0,0001 |
| 142 | SELECT parent_id FROM shop_categories WHERE id = ? | 0,0001 |
| 143 | SELECT parent_id FROM shop_categories WHERE id = ? | 0,0001 |
| 144 | SELECT parent_id FROM shop_categories WHERE id = ? | 0,0001 |
| 145 | SELECT parent_id FROM shop_categories WHERE id = ? | 0,0001 |
| 146 | SELECT parent_id FROM shop_categories WHERE id = ? | 0,0001 |
| 147 | SELECT parent_id FROM shop_categories WHERE id = ? | 0,0001 |
| 148 | SELECT parent_id FROM shop_categories WHERE id = ? | 0,0001 |
| 149 | SELECT parent_id FROM shop_categories WHERE id = ? | 0,0001 |
| 150 | SELECT parent_id FROM shop_categories WHERE id = ? | 0,0001 |
| 151 | SELECT parent_id FROM shop_categories WHERE id = ? | 0,0001 |
| 152 | SELECT parent_id FROM shop_categories WHERE id = ? | 0,0001 |
| 153 | SELECT parent_id FROM shop_categories WHERE id = ? | 0,0001 |
| 154 | SELECT parent_id FROM shop_categories WHERE id = ? | 0,0001 |
| 155 | SELECT parent_id FROM shop_categories WHERE id = ? | 0,0001 |
| 156 | SELECT parent_id FROM shop_categories WHERE id = ? | 0,0001 |
| 157 | SELECT parent_id FROM shop_categories WHERE id = ? | 0,0001 |
| 158 | SELECT parent_id FROM shop_categories WHERE id = ? | 0,0001 |
| 159 | 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 p.brand_id = ? 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,0008 |
| 160 | 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,0008 |
| - - | All Queries Time | 0,05 |
#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(486): Database->fetchAll('SELECT p.id, p....', Array)
#3 /home/mashini/public_html/app/modules/Store/models/Search.model.php(285): Search->getAllBrandProducts(11, 246)
#4 /home/mashini/public_html/app/modules/Store/front/Brands.controller.php(24): Search->loadBrand(11, 246)
#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