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,0161 |
3 | 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,0125 |
4 | SELECT * FROM `shop_languages` WHERE id = ? | 0,0133 |
5 | SELECT `id` as `value`, `t` as `title` FROM `fm_brands` ORDER by `value` ASC | 0,0059 |
6 | SELECT `id` as `value`, `t` as `title` FROM `fm_brands` ORDER by `value` ASC | 0,001 |
7 | SELECT `id` as `value`, `name` as `title` FROM `shop_properties` ORDER by `value` ASC | 0,0015 |
8 | SELECT * FROM `fm_brands` WHERE id = ? | 0,0007 |
9 | SELECT c.id, c.parent_id, c.name, c.active, c.shown_name, c.seo_url, COUNT(p.id) as active_products 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 = '123' GROUP BY c.id ORDER BY sortorder ASC, name ASC | 2,6667 |
10 | SQLSTATE[HY000]: General error: 2006 MySQL server has gone away | 2,6667 |
- - | All Queries Time | 5,3853 |
#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 c.id, c....', 'SQLSTATE[HY000]...') #2 /home/mashini/public_html/app/modules/Store/models/Categories.model.php(81): Database->fetchAll('SELECT c.id, c....', Array) #3 /home/mashini/public_html/app/modules/Store/models/Search.model.php(86): Categories->getCategoriesWithBrands(123) #4 /home/mashini/public_html/app/modules/Store/front/Brands.controller.php(13): Search->loadBrand(123, 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