| MySQL Debugger Results | ||
| Count | SQL query | Time to execute |
| 1 | SELECT code FROM shop_languages WHERE id = ? | 0.0252 |
| 2 | SELECT id, word, lang_1 as text FROM shop_language_words | 0.0125 |
| 3 | SELECT * FROM currency | 0.0651 |
| 4 | SELECT * FROM shop_redirects WHERE old_url = ? | 0.01 |
| 5 | SELECT id FROM fm_brands WHERE seo_url IN('jbm','mase','geda','mechbadger','golz','maltech','sirl','znd','almac','mgi','fraste','geoplast','acmar') | 0.0317 |
| 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.0269 |
| 7 | SELECT * FROM `shop_languages` WHERE id = ? | 0.0359 |
| 8 | SELECT `id` as `value`, `name` as `title` FROM `shop_properties` ORDER by `value` ASC | 0.0163 |
| 9 | SELECT `id` as `value`, `name` as `title` FROM `shop_properties` ORDER by `value` ASC | 0.019 |
| 10 | SELECT COUNT(*) AS count FROM shop_products WHERE is_available = 1 AND active = 1 AND archive = 0 | 0.0988 |
| 11 | SELECT COUNT(*) AS count FROM shop_products WHERE archive = 1 | 0.304 |
| 12 | SELECT `id` as `value`, `t` as `title` FROM `fm_brands` ORDER by `value` ASC | 0.0309 |
| 13 | SELECT * FROM `shop_categories` WHERE id = ? | 0.006 |
| 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.0375 |
| 15 | SELECT * FROM shop_categories WHERE ((active = 1 AND template != 1) OR (active_products > 0 AND template = 1)) AND parent_id = 653 ORDER BY name ASC | 0.0087 |
| 16 | SELECT * FROM shop_categories WHERE ((active = 1 AND template != 1) OR (active_products > 0 AND template = 1)) AND parent_id = 2323 ORDER BY name ASC | 0.0153 |
| 17 | SELECT * FROM shop_categories WHERE ((active = 1 AND template != 1) OR (active_products > 0 AND template = 1)) AND parent_id = 2480 ORDER BY name ASC | 0.0037 |
| 18 | SELECT * FROM shop_categories WHERE ((active = 1 AND template != 1) OR (active_products > 0 AND template = 1)) AND parent_id = 654 ORDER BY name ASC | 0.0482 |
| 19 | SELECT * FROM shop_categories WHERE ((active = 1 AND template != 1) OR (active_products > 0 AND template = 1)) AND parent_id = 657 ORDER BY name ASC | 0.0095 |
| 20 | SELECT * FROM shop_categories WHERE ((active = 1 AND template != 1) OR (active_products > 0 AND template = 1)) AND parent_id = 2684 ORDER BY name ASC | 0.0053 |
| 21 | SELECT * FROM shop_categories WHERE ((active = 1 AND template != 1) OR (active_products > 0 AND template = 1)) AND parent_id = 656 ORDER BY name ASC | 0.0046 |
| 22 | SELECT * FROM shop_categories WHERE ((active = 1 AND template != 1) OR (active_products > 0 AND template = 1)) AND parent_id = 2398 ORDER BY name ASC | 0.016 |
| 23 | SELECT * FROM shop_categories WHERE ((active = 1 AND template != 1) OR (active_products > 0 AND template = 1)) AND parent_id = 2634 ORDER BY name ASC | 0.0085 |
| 24 | SELECT * FROM shop_categories WHERE ((active = 1 AND template != 1) OR (active_products > 0 AND template = 1)) AND parent_id = 2591 ORDER BY name ASC | 0.0046 |
| 25 | SELECT * FROM shop_categories WHERE ((active = 1 AND template != 1) OR (active_products > 0 AND template = 1)) AND parent_id = 2477 ORDER BY name ASC | 0.0033 |
| 26 | SELECT * FROM shop_categories WHERE ((active = 1 AND template != 1) OR (active_products > 0 AND template = 1)) AND parent_id = 2537 ORDER BY name ASC | 0.0131 |
| 27 | SELECT * FROM shop_categories WHERE ((active = 1 AND template != 1) OR (active_products > 0 AND template = 1)) AND parent_id = 2600 ORDER BY name ASC | 0.0265 |
| 28 | SELECT * FROM shop_categories WHERE ((active = 1 AND template != 1) OR (active_products > 0 AND template = 1)) AND parent_id = 667 ORDER BY name ASC | 0.0104 |
| 29 | SELECT * FROM shop_categories WHERE ((active = 1 AND template != 1) OR (active_products > 0 AND template = 1)) AND parent_id = 2678 ORDER BY name ASC | 0.0072 |
| 30 | SELECT * FROM shop_categories WHERE ((active = 1 AND template != 1) OR (active_products > 0 AND template = 1)) AND parent_id = 583 ORDER BY name ASC | 0.0059 |
| 31 | SELECT * FROM shop_categories WHERE ((active = 1 AND template != 1) OR (active_products > 0 AND template = 1)) AND parent_id = 614 ORDER BY name ASC | 0.005 |
| 32 | SELECT * FROM shop_categories WHERE ((active = 1 AND template != 1) OR (active_products > 0 AND template = 1)) AND parent_id = 625 ORDER BY name ASC | 0.025 |
| 33 | SELECT * FROM shop_categories WHERE ((active = 1 AND template != 1) OR (active_products > 0 AND template = 1)) AND parent_id = 635 ORDER BY name ASC | 0.0455 |
| 34 | SELECT * FROM shop_categories WHERE ((active = 1 AND template != 1) OR (active_products > 0 AND template = 1)) AND parent_id = 640 ORDER BY name ASC | 0.4189 |
| 35 | SELECT * FROM shop_categories WHERE ((active = 1 AND template != 1) OR (active_products > 0 AND template = 1)) AND parent_id = 2666 ORDER BY name ASC | 1.4474 |
| 36 | SQLSTATE[HY000]: General error: 2006 MySQL server has gone away | 1.4474 |
| - - | All Queries Time | 4.2998 |
#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(135): Database->onDbError()
#2 /var/www/bautrax.bg/www/app/modules/Store/models/Categories.model.php(248): Database->fetchAll()
#3 /var/www/bautrax.bg/www/app/modules/Store/models/Search.model.php(77): Categories->getCategoriesWithParentBySort()
#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