| MySQL Debugger Results | ||
| Count | SQL query | Time to execute |
| 1 | SELECT id, word, lang_1 as text FROM shop_language_words | 0,0027 |
| 2 | INSERT INTO shop_logs (add_date, ip, url, user_agent) VALUES ('2023-09-23 00:43:48', '35.175.191.46', '/brand-166/bgs_technic', 'CCBot/2.0 (https://commoncrawl.org/faq/)') | 0,0018 |
| 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,0006 |
| 4 | SELECT * FROM `shop_languages` WHERE id = ? | 0,0002 |
| 5 | SELECT `id` as `value`, `t` as `title` FROM `fm_brands` ORDER by `value` ASC | 0,013 |
| 6 | SELECT `id` as `value`, `t` as `title` FROM `fm_brands` ORDER by `value` ASC | 0,0006 |
| 7 | SELECT `id` as `value`, `name` as `title` FROM `shop_properties` ORDER by `value` ASC | 0,0005 |
| 8 | SELECT * FROM `fm_brands` WHERE id = ? | 0,0003 |
| 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_products AS p LEFT JOIN shop_categories AS c ON c.id = p.category_id WHERE p.brand_id = '166' AND c.parent_id != 0 AND p.active = 1 GROUP BY c.id ORDER BY sortorder ASC, name ASC | 0,0007 |
| 10 | SELECT p.* 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, pp.instorage DESC, p.priority DESC, IF(IF(p.is_promo = 1 OR p.is_promocatalog = 1,p.price_promo_to,"0000-00-00 00:00:00") = "0000-00-00 00:00:00","9999-99-99 00:00:00",p.price_promo_to) ASC, p.views DESC | 0,0016 |
| 11 | SELECT id, parent_id, name, active, shown_name, seo_url, active_products FROM shop_categories WHERE id IN () ORDER BY name ASC | 0,0004 |
| 12 | SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ') ORDER BY name ASC' at line 1 | 0,0004 |
| - - | All Queries Time | 0,0228 |
#0 /home/cmx/public_html/app/system/Database.class.php(503): Registry::get('lang')
#1 /home/cmx/public_html/app/system/Database.class.php(129): Database->onDbError('SELECT id, pare...', 'SQLSTATE[42000]...')
#2 /home/cmx/public_html/app/modules/Store/models/Search.model.php(303): Database->fetchAll('SELECT id, pare...')
#3 /home/cmx/public_html/app/modules/Store/front/Brands.controller.php(40): Search->getRemainingCategories(true)
#4 /home/cmx/public_html/app/system/Controller.class.php(176): BrandsController->indexAction()
#5 /home/cmx/public_html/index.php(110): Controller->Start()
#6 {main}'lang' is not set in the Registry