| MySQL Debugger Results | ||
| Count | SQL query | Time to execute |
| 1 | SELECT code FROM shop_languages WHERE id = ? | 0.0011 |
| 2 | SELECT id, word, lang_1 as text FROM shop_language_words | 0.0022 |
| 3 | SELECT * FROM currency | 0.0165 |
| 4 | SELECT * FROM shop_redirects WHERE old_url = ? | 0.0081 |
| 5 | SELECT id FROM fm_brands WHERE seo_url IN('vogele','mecalac','case','renault','bell','hamm','kaeser','hyster') | 0.0085 |
| 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.0229 |
| 7 | SELECT * FROM `shop_languages` WHERE id = ? | 0.0032 |
| 8 | SELECT `id` as `value`, `name` as `title` FROM `shop_properties` ORDER by `value` ASC | 0.0056 |
| 9 | SELECT `id` as `value`, `name` as `title` FROM `shop_properties` ORDER by `value` ASC | 0.0133 |
| 10 | SELECT COUNT(*) AS count FROM shop_products WHERE is_available = 1 AND active = 1 AND archive = 0 | 0.0028 |
| 11 | SELECT COUNT(*) AS count FROM shop_products WHERE archive = 1 | 0.0337 |
| 12 | SELECT `id` as `value`, `t` as `title` FROM `fm_brands` ORDER by `value` ASC | 0.0036 |
| 13 | SELECT * FROM `shop_categories` WHERE id = ? | 0.0023 |
| 14 | SELECT * FROM shop_categories WHERE ((active = 1 AND template != 1) OR (active_products > 0 AND template = 1)) AND parent_id = ? ORDER BY name ASC | 0.0091 |
| 15 | SELECT * FROM shop_categories WHERE ((active = 1 AND template != 1) OR (active_products > 0 AND template = 1)) AND parent_id = 1319 ORDER BY name ASC | 0.0208 |
| 16 | SELECT * FROM shop_categories WHERE ((active = 1 AND template != 1) OR (active_products > 0 AND template = 1)) AND parent_id = 1321 ORDER BY name ASC | 0.0021 |
| 17 | SELECT * FROM shop_categories WHERE ((active = 1 AND template != 1) OR (active_products > 0 AND template = 1)) AND parent_id = 1249 ORDER BY name ASC | 0.0161 |
| 18 | SELECT * FROM shop_categories WHERE ((active = 1 AND template != 1) OR (active_products > 0 AND template = 1)) AND parent_id = 2329 ORDER BY name ASC | 0.0137 |
| 19 | SELECT * FROM shop_categories WHERE ((active = 1 AND template != 1) OR (active_products > 0 AND template = 1)) AND parent_id = 1271 ORDER BY name ASC | 0.0135 |
| 20 | SELECT * FROM shop_categories WHERE ((active = 1 AND template != 1) OR (active_products > 0 AND template = 1)) AND parent_id = 1302 ORDER BY name ASC | 0.0078 |
| 21 | SELECT * FROM shop_categories WHERE ((active = 1 AND template != 1) OR (active_products > 0 AND template = 1)) AND parent_id = 1274 ORDER BY name ASC | 0.0049 |
| 22 | SELECT * FROM shop_categories WHERE ((active = 1 AND template != 1) OR (active_products > 0 AND template = 1)) AND parent_id = 1265 ORDER BY name ASC | 0.0112 |
| 23 | SELECT * FROM shop_categories WHERE ((active = 1 AND template != 1) OR (active_products > 0 AND template = 1)) AND parent_id = 1253 ORDER BY name ASC | 0.0162 |
| 24 | SELECT * FROM shop_categories WHERE ((active = 1 AND template != 1) OR (active_products > 0 AND template = 1)) AND parent_id = 1275 ORDER BY name ASC | 0.0167 |
| 25 | SELECT * FROM shop_categories WHERE ((active = 1 AND template != 1) OR (active_products > 0 AND template = 1)) AND parent_id = 1270 ORDER BY name ASC | 0.0069 |
| 26 | SELECT * FROM shop_categories WHERE ((active = 1 AND template != 1) OR (active_products > 0 AND template = 1)) AND parent_id = 1303 ORDER BY name ASC | 0.0104 |
| 27 | SELECT * FROM shop_categories WHERE ((active = 1 AND template != 1) OR (active_products > 0 AND template = 1)) AND parent_id = 1308 ORDER BY name ASC | 0.0126 |
| 28 | SELECT * FROM shop_categories WHERE ((active = 1 AND template != 1) OR (active_products > 0 AND template = 1)) AND parent_id = 821 ORDER BY name ASC | 0.0115 |
| 29 | SELECT * FROM shop_categories WHERE ((active = 1 AND template != 1) OR (active_products > 0 AND template = 1)) AND parent_id = 822 ORDER BY name ASC | 0.0097 |
| 30 | SELECT * FROM shop_categories WHERE ((active = 1 AND template != 1) OR (active_products > 0 AND template = 1)) AND parent_id = 855 ORDER BY name ASC | 0.0081 |
| 31 | SELECT * FROM shop_categories WHERE ((active = 1 AND template != 1) OR (active_products > 0 AND template = 1)) AND parent_id = 876 ORDER BY name ASC | 0.0071 |
| 32 | SELECT * FROM shop_categories WHERE ((active = 1 AND template != 1) OR (active_products > 0 AND template = 1)) AND parent_id = 2361 ORDER BY name ASC | 0.012 |
| 33 | SELECT * FROM shop_categories WHERE ((active = 1 AND template != 1) OR (active_products > 0 AND template = 1)) AND parent_id = 2297 ORDER BY name ASC | 0.0091 |
| 34 | SELECT * FROM shop_categories WHERE ((active = 1 AND template != 1) OR (active_products > 0 AND template = 1)) AND parent_id = 2303 ORDER BY name ASC | 0.0084 |
| 35 | SELECT * FROM shop_categories WHERE ((active = 1 AND template != 1) OR (active_products > 0 AND template = 1)) AND parent_id = 1333 ORDER BY name ASC | 0.01 |
| 36 | SELECT * FROM shop_categories WHERE ((active = 1 AND template != 1) OR (active_products > 0 AND template = 1)) AND parent_id = 2354 ORDER BY name ASC | 0.005 |
| 37 | SELECT * FROM shop_categories WHERE ((active = 1 AND template != 1) OR (active_products > 0 AND template = 1)) AND parent_id = 2325 ORDER BY name ASC | 0.0089 |
| 38 | SELECT * FROM shop_categories WHERE ((active = 1 AND template != 1) OR (active_products > 0 AND template = 1)) AND parent_id = 1334 ORDER BY name ASC | 0.006 |
| 39 | SELECT * FROM shop_categories WHERE ((active = 1 AND template != 1) OR (active_products > 0 AND template = 1)) AND parent_id = 1145 ORDER BY name ASC | 0.0155 |
| 40 | SELECT * FROM shop_categories WHERE ((active = 1 AND template != 1) OR (active_products > 0 AND template = 1)) AND parent_id = 1190 ORDER BY name ASC | 0.0199 |
| 41 | SELECT * FROM shop_categories WHERE ((active = 1 AND template != 1) OR (active_products > 0 AND template = 1)) AND parent_id = 689 ORDER BY name ASC | 0.0105 |
| 42 | SELECT * FROM shop_categories WHERE ((active = 1 AND template != 1) OR (active_products > 0 AND template = 1)) AND parent_id = 2322 ORDER BY name ASC | 0.0195 |
| 43 | SELECT * FROM shop_categories WHERE ((active = 1 AND template != 1) OR (active_products > 0 AND template = 1)) AND parent_id = 690 ORDER BY name ASC | 0.0133 |
| 44 | SELECT * FROM shop_categories WHERE ((active = 1 AND template != 1) OR (active_products > 0 AND template = 1)) AND parent_id = 760 ORDER BY name ASC | 0.012 |
| 45 | SELECT * FROM shop_categories WHERE ((active = 1 AND template != 1) OR (active_products > 0 AND template = 1)) AND parent_id = 2334 ORDER BY name ASC | 0.0073 |
| 46 | SELECT * FROM shop_categories WHERE ((active = 1 AND template != 1) OR (active_products > 0 AND template = 1)) AND parent_id = 701 ORDER BY name ASC | 0.0052 |
| 47 | SELECT * FROM shop_categories WHERE ((active = 1 AND template != 1) OR (active_products > 0 AND template = 1)) AND parent_id = 719 ORDER BY name ASC | 0.01 |
| 48 | SELECT * FROM shop_categories WHERE ((active = 1 AND template != 1) OR (active_products > 0 AND template = 1)) AND parent_id = 818 ORDER BY name ASC | 0.0083 |
| 49 | SELECT * FROM shop_categories WHERE ((active = 1 AND template != 1) OR (active_products > 0 AND template = 1)) AND parent_id = 814 ORDER BY name ASC | 0.0066 |
| 50 | SELECT * FROM shop_categories WHERE ((active = 1 AND template != 1) OR (active_products > 0 AND template = 1)) AND parent_id = 751 ORDER BY name ASC | 0.0116 |
| 51 | SELECT * FROM shop_categories WHERE ((active = 1 AND template != 1) OR (active_products > 0 AND template = 1)) AND parent_id = 781 ORDER BY name ASC | 0.0033 |
| 52 | SELECT * FROM shop_categories WHERE ((active = 1 AND template != 1) OR (active_products > 0 AND template = 1)) AND parent_id = 742 ORDER BY name ASC | 0.0092 |
| 53 | SELECT * FROM shop_categories WHERE ((active = 1 AND template != 1) OR (active_products > 0 AND template = 1)) AND parent_id = 732 ORDER BY name ASC | 0.0076 |
| 54 | SELECT * FROM shop_categories WHERE ((active = 1 AND template != 1) OR (active_products > 0 AND template = 1)) AND parent_id = 793 ORDER BY name ASC | 0.0123 |
| 55 | SELECT * FROM shop_categories WHERE ((active = 1 AND template != 1) OR (active_products > 0 AND template = 1)) AND parent_id = 772 ORDER BY name ASC | 0.0096 |
| 56 | SELECT * FROM shop_categories WHERE ((active = 1 AND template != 1) OR (active_products > 0 AND template = 1)) AND parent_id = 788 ORDER BY name ASC | 0.0111 |
| 57 | SELECT * FROM shop_categories WHERE ((active = 1 AND template != 1) OR (active_products > 0 AND template = 1)) AND parent_id = 710 ORDER BY name ASC | 0.0142 |
| 58 | SELECT * FROM shop_categories WHERE ((active = 1 AND template != 1) OR (active_products > 0 AND template = 1)) AND parent_id = 2330 ORDER BY name ASC | 0.0488 |
| 59 | SELECT GROUP_CONCAT(product_id) FROM shop_product_categories WHERE category_id = '2' | 0.2625 |
| 60 | SQLSTATE[HY000]: General error: 2006 MySQL server has gone away | 0.2625 |
| - - | All Queries Time | 1.1624 |
#0 /var/www/bautrax.bg/www/app/system/Database.class.php(536): Registry::get()
#1 /var/www/bautrax.bg/www/app/system/Database.class.php(216): Database->onDbError()
#2 /var/www/bautrax.bg/www/app/modules/Store/models/Search.model.php(234): Database->fetchOne()
#3 /var/www/bautrax.bg/www/app/modules/Store/models/Search.model.php(75): Search->getAllProducts()
#4 /var/www/bautrax.bg/www/app/modules/Store/front/Categories.controller.php(28): Search->load()
#5 /var/www/bautrax.bg/www/app/system/Controller.class.php(257): CategoriesController->indexAction()
#6 /var/www/bautrax.bg/www/index.php(124): Controller->Start()
#7 {main}'lang' is not set in the Registry