| MySQL Debugger Results | ||
| Count | SQL query | Time to execute |
| 1 | SELECT code FROM shop_languages WHERE id = ? | 0.0008 |
| 2 | SELECT id, word, lang_1 as text FROM shop_language_words | 0.0018 |
| 3 | SELECT * FROM currency | 0.0013 |
| 4 | SELECT * FROM shop_redirects WHERE old_url = ? | 0.0034 |
| 5 | SELECT id FROM fm_brands WHERE seo_url IN('norcar','golz','snorkel','alpin','saro','m3srl','rokamat','znd','ramtec','smart-group','burak-treyler') | 0.0013 |
| 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.0027 |
| 7 | SELECT * FROM `shop_languages` WHERE id = ? | 0.0048 |
| 8 | SELECT `id` as `value`, `name` as `title` FROM `shop_properties` ORDER by `value` ASC | 0.006 |
| 9 | SELECT `id` as `value`, `name` as `title` FROM `shop_properties` ORDER by `value` ASC | 0.0062 |
| 10 | SELECT COUNT(*) AS count FROM shop_products WHERE is_available = 1 AND active = 1 AND archive = 0 | 0.0038 |
| 11 | SELECT COUNT(*) AS count FROM shop_products WHERE archive = 1 | 0.0095 |
| 12 | SELECT `id` as `value`, `t` as `title` FROM `fm_brands` ORDER by `value` ASC | 0.0204 |
| 13 | SELECT * FROM `shop_categories` WHERE id = ? | 0.0021 |
| 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.002 |
| 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.002 |
| 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.0021 |
| 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.0019 |
| 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.0016 |
| 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.0017 |
| 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.0018 |
| 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.0017 |
| 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.0019 |
| 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.0018 |
| 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.002 |
| 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.0019 |
| 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.0017 |
| 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.0019 |
| 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.0062 |
| 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.0075 |
| 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.0016 |
| 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.0017 |
| 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.0048 |
| 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.0019 |
| 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.002 |
| 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 | 0.0036 |
| 36 | SELECT * FROM shop_categories WHERE ((active = 1 AND template != 1) OR (active_products > 0 AND template = 1)) AND parent_id = 652 ORDER BY name ASC | 0.0027 |
| 37 | SELECT * FROM shop_categories WHERE ((active = 1 AND template != 1) OR (active_products > 0 AND template = 1)) AND parent_id = 645 ORDER BY name ASC | 0.0004 |
| 38 | SELECT * FROM shop_categories WHERE ((active = 1 AND template != 1) OR (active_products > 0 AND template = 1)) AND parent_id = 647 ORDER BY name ASC | 0.0003 |
| 39 | SELECT * FROM shop_categories WHERE ((active = 1 AND template != 1) OR (active_products > 0 AND template = 1)) AND parent_id = 2576 ORDER BY name ASC | 0.0004 |
| 40 | SELECT * FROM shop_categories WHERE ((active = 1 AND template != 1) OR (active_products > 0 AND template = 1)) AND parent_id = 2669 ORDER BY name ASC | 0.0003 |
| 41 | SELECT * FROM shop_categories WHERE ((active = 1 AND template != 1) OR (active_products > 0 AND template = 1)) AND parent_id = 642 ORDER BY name ASC | 0.0002 |
| 42 | SELECT * FROM shop_categories WHERE ((active = 1 AND template != 1) OR (active_products > 0 AND template = 1)) AND parent_id = 643 ORDER BY name ASC | 0.0002 |
| 43 | SELECT * FROM shop_categories WHERE ((active = 1 AND template != 1) OR (active_products > 0 AND template = 1)) AND parent_id = 142 ORDER BY name ASC | 0.001 |
| 44 | SELECT * FROM shop_categories WHERE ((active = 1 AND template != 1) OR (active_products > 0 AND template = 1)) AND parent_id = 404 ORDER BY name ASC | 0.0004 |
| 45 | SELECT * FROM shop_categories WHERE ((active = 1 AND template != 1) OR (active_products > 0 AND template = 1)) AND parent_id = 143 ORDER BY name ASC | 0.0012 |
| 46 | SELECT * FROM shop_categories WHERE ((active = 1 AND template != 1) OR (active_products > 0 AND template = 1)) AND parent_id = 2637 ORDER BY name ASC | 0.0003 |
| 47 | SELECT * FROM shop_categories WHERE ((active = 1 AND template != 1) OR (active_products > 0 AND template = 1)) AND parent_id = 176 ORDER BY name ASC | 0.0007 |
| 48 | SELECT * FROM shop_categories WHERE ((active = 1 AND template != 1) OR (active_products > 0 AND template = 1)) AND parent_id = 197 ORDER BY name ASC | 0.0021 |
| 49 | SELECT * FROM shop_categories WHERE ((active = 1 AND template != 1) OR (active_products > 0 AND template = 1)) AND parent_id = 462 ORDER BY name ASC | 0.0021 |
| 50 | SELECT * FROM shop_categories WHERE ((active = 1 AND template != 1) OR (active_products > 0 AND template = 1)) AND parent_id = 267 ORDER BY name ASC | 0.0026 |
| 51 | SELECT * FROM shop_categories WHERE ((active = 1 AND template != 1) OR (active_products > 0 AND template = 1)) AND parent_id = 447 ORDER BY name ASC | 0.0016 |
| 52 | SELECT * FROM shop_categories WHERE ((active = 1 AND template != 1) OR (active_products > 0 AND template = 1)) AND parent_id = 291 ORDER BY name ASC | 0.002 |
| 53 | SELECT * FROM shop_categories WHERE ((active = 1 AND template != 1) OR (active_products > 0 AND template = 1)) AND parent_id = 473 ORDER BY name ASC | 0.0018 |
| 54 | SELECT * FROM shop_categories WHERE ((active = 1 AND template != 1) OR (active_products > 0 AND template = 1)) AND parent_id = 225 ORDER BY name ASC | 0.0016 |
| 55 | SELECT * FROM shop_categories WHERE ((active = 1 AND template != 1) OR (active_products > 0 AND template = 1)) AND parent_id = 159 ORDER BY name ASC | 0.0018 |
| 56 | SELECT * FROM shop_categories WHERE ((active = 1 AND template != 1) OR (active_products > 0 AND template = 1)) AND parent_id = 337 ORDER BY name ASC | 0.0016 |
| 57 | SELECT * FROM shop_categories WHERE ((active = 1 AND template != 1) OR (active_products > 0 AND template = 1)) AND parent_id = 314 ORDER BY name ASC | 0.0014 |
| 58 | SELECT * FROM shop_categories WHERE ((active = 1 AND template != 1) OR (active_products > 0 AND template = 1)) AND parent_id = 424 ORDER BY name ASC | 0.0029 |
| 59 | SELECT * FROM shop_categories WHERE ((active = 1 AND template != 1) OR (active_products > 0 AND template = 1)) AND parent_id = 361 ORDER BY name ASC | 0.003 |
| 60 | SELECT * FROM shop_categories WHERE ((active = 1 AND template != 1) OR (active_products > 0 AND template = 1)) AND parent_id = 249 ORDER BY name ASC | 0.0025 |
| 61 | SELECT * FROM shop_categories WHERE ((active = 1 AND template != 1) OR (active_products > 0 AND template = 1)) AND parent_id = 472 ORDER BY name ASC | 0.0027 |
| 62 | SELECT * FROM shop_categories WHERE ((active = 1 AND template != 1) OR (active_products > 0 AND template = 1)) AND parent_id = 384 ORDER BY name ASC | 0.0031 |
| 63 | SELECT * FROM shop_categories WHERE ((active = 1 AND template != 1) OR (active_products > 0 AND template = 1)) AND parent_id = 2296 ORDER BY name ASC | 0.0016 |
| 64 | SELECT * FROM shop_categories WHERE ((active = 1 AND template != 1) OR (active_products > 0 AND template = 1)) AND parent_id = 2305 ORDER BY name ASC | 0.0031 |
| 65 | SELECT * FROM shop_categories WHERE ((active = 1 AND template != 1) OR (active_products > 0 AND template = 1)) AND parent_id = 2302 ORDER BY name ASC | 0.003 |
| 66 | SELECT * FROM shop_categories WHERE ((active = 1 AND template != 1) OR (active_products > 0 AND template = 1)) AND parent_id = 2507 ORDER BY name ASC | 0.0026 |
| 67 | SELECT * FROM shop_categories WHERE ((active = 1 AND template != 1) OR (active_products > 0 AND template = 1)) AND parent_id = 2807 ORDER BY name ASC | 0.0026 |
| 68 | SELECT * FROM shop_categories WHERE ((active = 1 AND template != 1) OR (active_products > 0 AND template = 1)) AND parent_id = 2813 ORDER BY name ASC | 0.0025 |
| 69 | SELECT * FROM shop_categories WHERE ((active = 1 AND template != 1) OR (active_products > 0 AND template = 1)) AND parent_id = 2299 ORDER BY name ASC | 0.0026 |
| 70 | SELECT * FROM shop_categories WHERE ((active = 1 AND template != 1) OR (active_products > 0 AND template = 1)) AND parent_id = 2816 ORDER BY name ASC | 0.0019 |
| 71 | SELECT * FROM shop_categories WHERE ((active = 1 AND template != 1) OR (active_products > 0 AND template = 1)) AND parent_id = 2810 ORDER BY name ASC | 0.007 |
| 72 | SELECT * FROM shop_categories WHERE ((active = 1 AND template != 1) OR (active_products > 0 AND template = 1)) AND parent_id = 669 ORDER BY name ASC | 0.0008 |
| 73 | SELECT * FROM shop_categories WHERE ((active = 1 AND template != 1) OR (active_products > 0 AND template = 1)) AND parent_id = 673 ORDER BY name ASC | 0.006 |
| 74 | SELECT * FROM shop_categories WHERE ((active = 1 AND template != 1) OR (active_products > 0 AND template = 1)) AND parent_id = 677 ORDER BY name ASC | 0.004 |
| 75 | SELECT * FROM shop_categories WHERE ((active = 1 AND template != 1) OR (active_products > 0 AND template = 1)) AND parent_id = 2609 ORDER BY name ASC | 0.004 |
| 76 | SELECT * FROM shop_categories WHERE ((active = 1 AND template != 1) OR (active_products > 0 AND template = 1)) AND parent_id = 2594 ORDER BY name ASC | 0.004 |
| 77 | SELECT * FROM shop_categories WHERE ((active = 1 AND template != 1) OR (active_products > 0 AND template = 1)) AND parent_id = 676 ORDER BY name ASC | 0.0039 |
| 78 | SELECT * FROM shop_categories WHERE ((active = 1 AND template != 1) OR (active_products > 0 AND template = 1)) AND parent_id = 670 ORDER BY name ASC | 0.0041 |
| 79 | SELECT * FROM shop_categories WHERE ((active = 1 AND template != 1) OR (active_products > 0 AND template = 1)) AND parent_id = 474 ORDER BY name ASC | 0.0043 |
| 80 | SELECT * FROM shop_categories WHERE ((active = 1 AND template != 1) OR (active_products > 0 AND template = 1)) AND parent_id = 534 ORDER BY name ASC | 0.0038 |
| 81 | SELECT * FROM shop_categories WHERE ((active = 1 AND template != 1) OR (active_products > 0 AND template = 1)) AND parent_id = 575 ORDER BY name ASC | 0.0006 |
| 82 | SELECT * FROM shop_categories WHERE ((active = 1 AND template != 1) OR (active_products > 0 AND template = 1)) AND parent_id = 483 ORDER BY name ASC | 0.0032 |
| 83 | SELECT * FROM shop_categories WHERE ((active = 1 AND template != 1) OR (active_products > 0 AND template = 1)) AND parent_id = 519 ORDER BY name ASC | 0.0039 |
| 84 | SELECT * FROM shop_categories WHERE ((active = 1 AND template != 1) OR (active_products > 0 AND template = 1)) AND parent_id = 562 ORDER BY name ASC | 0.0026 |
| 85 | SELECT * FROM shop_categories WHERE ((active = 1 AND template != 1) OR (active_products > 0 AND template = 1)) AND parent_id = 582 ORDER BY name ASC | 0.0006 |
| 86 | SELECT * FROM shop_categories WHERE ((active = 1 AND template != 1) OR (active_products > 0 AND template = 1)) AND parent_id = 502 ORDER BY name ASC | 0.001 |
| 87 | SELECT * FROM shop_categories WHERE ((active = 1 AND template != 1) OR (active_products > 0 AND template = 1)) AND parent_id = 475 ORDER BY name ASC | 0.0018 |
| 88 | SELECT * FROM shop_categories WHERE ((active = 1 AND template != 1) OR (active_products > 0 AND template = 1)) AND parent_id = 546 ORDER BY name ASC | 0.001 |
| 89 | SELECT * FROM shop_categories WHERE ((active = 1 AND template != 1) OR (active_products > 0 AND template = 1)) AND parent_id = 2675 ORDER BY name ASC | 0.0051 |
| 90 | SELECT * FROM shop_categories WHERE ((active = 1 AND template != 1) OR (active_products > 0 AND template = 1)) AND parent_id = 509 ORDER BY name ASC | 0.0041 |
| 91 | SELECT * FROM shop_categories WHERE ((active = 1 AND template != 1) OR (active_products > 0 AND template = 1)) AND parent_id = 5 ORDER BY name ASC | 0.0025 |
| 92 | SELECT * FROM shop_categories WHERE ((active = 1 AND template != 1) OR (active_products > 0 AND template = 1)) AND parent_id = 6 ORDER BY name ASC | 0.0055 |
| 93 | SELECT * FROM shop_categories WHERE ((active = 1 AND template != 1) OR (active_products > 0 AND template = 1)) AND parent_id = 78 ORDER BY name ASC | 0.0041 |
| 94 | SELECT * FROM shop_categories WHERE ((active = 1 AND template != 1) OR (active_products > 0 AND template = 1)) AND parent_id = 17 ORDER BY name ASC | 0.0037 |
| 95 | SELECT * FROM shop_categories WHERE ((active = 1 AND template != 1) OR (active_products > 0 AND template = 1)) AND parent_id = 35 ORDER BY name ASC | 0.0034 |
| 96 | SELECT * FROM shop_categories WHERE ((active = 1 AND template != 1) OR (active_products > 0 AND template = 1)) AND parent_id = 138 ORDER BY name ASC | 0.0046 |
| 97 | SELECT * FROM shop_categories WHERE ((active = 1 AND template != 1) OR (active_products > 0 AND template = 1)) AND parent_id = 68 ORDER BY name ASC | 0.004 |
| 98 | SELECT * FROM shop_categories WHERE ((active = 1 AND template != 1) OR (active_products > 0 AND template = 1)) AND parent_id = 100 ORDER BY name ASC | 0.004 |
| 99 | SELECT * FROM shop_categories WHERE ((active = 1 AND template != 1) OR (active_products > 0 AND template = 1)) AND parent_id = 59 ORDER BY name ASC | 0.0026 |
| 100 | SELECT * FROM shop_categories WHERE ((active = 1 AND template != 1) OR (active_products > 0 AND template = 1)) AND parent_id = 49 ORDER BY name ASC | 0.0071 |
| 101 | SELECT * FROM shop_categories WHERE ((active = 1 AND template != 1) OR (active_products > 0 AND template = 1)) AND parent_id = 2658 ORDER BY name ASC | 0.0007 |
| 102 | SELECT * FROM shop_categories WHERE ((active = 1 AND template != 1) OR (active_products > 0 AND template = 1)) AND parent_id = 113 ORDER BY name ASC | 0.0034 |
| 103 | SELECT * FROM shop_categories WHERE ((active = 1 AND template != 1) OR (active_products > 0 AND template = 1)) AND parent_id = 91 ORDER BY name ASC | 0.0551 |
| 104 | SELECT * FROM shop_categories WHERE ((active = 1 AND template != 1) OR (active_products > 0 AND template = 1)) AND parent_id = 108 ORDER BY name ASC | 0.1487 |
| 105 | SELECT * FROM shop_categories WHERE ((active = 1 AND template != 1) OR (active_products > 0 AND template = 1)) AND parent_id = 26 ORDER BY name ASC | 0.026 |
| 106 | SELECT * FROM shop_categories WHERE ((active = 1 AND template != 1) OR (active_products > 0 AND template = 1)) AND parent_id = 2618 ORDER BY name ASC | 0.0338 |
| 107 | SELECT GROUP_CONCAT(product_id) FROM shop_product_categories WHERE category_id = '1' | 0.0206 |
| 108 | SQLSTATE[08S01]: Communication link failure: 1053 Server shutdown in progress | 0.0206 |
| - - | All Queries Time | 0.5964 |
#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(251): Database->fetchOne()
#3 /var/www/bautrax.bg/www/app/modules/Store/models/Search.model.php(80): 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