| MySQL Debugger Results | ||
| Count | SQL query | Time to execute |
| 1 | SELECT id, word, lang_1 as text FROM shop_language_words | 0,0013 |
| 2 | SELECT local_url FROM shop_seo WHERE seo_url = ? | 0,0005 |
| 3 | SELECT id, parent_id FROM shop_categories WHERE seo_url = 'maslo-za-ryazane-i-probivane-blinker-300-ml' | 0,0007 |
| 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,0002 |
| 6 | SELECT `id` as `value`, `t` as `title` FROM `fm_brands` ORDER by `value` ASC | 0,0021 |
| 7 | SELECT * FROM shop_promocodes WHERE active = 1 AND is_badge = 1 | 0,0002 |
| 8 | SELECT `id` as `value`, `name` as `title` FROM `shop_properties` ORDER by `value` ASC | 0,0005 |
| 9 | SELECT * FROM `shop_products` WHERE id = ? | 0,0003 |
| 10 | SELECT * FROM `shop_categories` WHERE id = ? | 0,0011 |
| 11 | SELECT id FROM shop_products WHERE active = 1 AND category_id = ? ORDER BY views DESC LIMIT 2 | 0,0004 |
| 12 | SELECT id FROM shop_products WHERE category_id = ? AND active = 1 AND price_sell > 0 ORDER BY price_sell ASC LIMIT 2 | 0,0002 |
| 13 | SELECT id FROM shop_products WHERE category_id = ? AND active = 1 ORDER BY price_sell DESC LIMIT 2 | 0,0003 |
| 14 | SELECT id FROM shop_products WHERE category_id = ? AND active = 1 AND is_onsale = 1 ORDER BY RAND() LIMIT 1 | 0,0003 |
| 15 | SELECT id FROM shop_products WHERE category_id = ? AND active = 1 AND is_onsale = 1 ORDER BY RAND() LIMIT 1 | 0,0002 |
| 16 | SELECT id FROM shop_products WHERE category_id = ? AND active = 1 AND is_onsale = 0 AND is_promo = 1 AND is_promocatalog = 0 ORDER BY RAND() LIMIT 1 | 0,0006 |
| 17 | SELECT id FROM shop_products WHERE category_id = ? AND active = 1 AND is_onsale = 0 AND is_promo = 1 AND is_promocatalog = 1 ORDER BY RAND() LIMIT 1 | 0,0002 |
| 18 | SELECT * FROM shop_products WHERE id IN () ORDER BY FIELD(id, ) | 0,0001 |
| 19 | 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 FIELD(id, )' at line 1 | 0,0001 |
| - - | All Queries Time | 0,0095 |
#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 * FROM s...', 'SQLSTATE[42000]...')
#2 /home/mashini/public_html/app/modules/Store/models/Products.model.php(561): Database->fetchAll('SELECT * FROM s...')
#3 /home/mashini/public_html/app/modules/Store/front/Products.controller.php(116): Products->getTenOffers('507')
#4 /home/mashini/public_html/app/system/Controller.class.php(209): ProductsController->viewAction()
#5 /home/mashini/public_html/index.php(126): Controller->Start()
#6 {main}'lang' is not set in the Registry