MySQL Debugger Results
Count SQL query Time to execute
1 SELECT code FROM shop_languages WHERE id = ? 0.0161
2 SELECT id, word, lang_1 as text FROM shop_language_words 0.0207
3 SELECT * FROM currency 0.0113
4 SELECT * FROM shop_redirects WHERE old_url = ? 0.0057
5 SELECT id FROM fm_brands WHERE seo_url IN('jbm','tecna','ntc','track-o','cmc','m3srl','c4','znd','magmaweld','jomar','mgi','seppi','telka') 0.0049
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.006
7 SELECT * FROM `shop_languages` WHERE id = ? 0.0038
8 SELECT `id` as `value`, `name` as `title` FROM `shop_properties` ORDER by `value` ASC 0.0063
9 SELECT `id` as `value`, `name` as `title` FROM `shop_properties` ORDER by `value` ASC 0.0085
10 SELECT COUNT(*) AS count FROM shop_products WHERE is_available = 1 AND active = 1 AND archive = 0 0.0096
11 SELECT COUNT(*) AS count FROM shop_products WHERE archive = 1 0.0088
12 SELECT `id` as `value`, `t` as `title` FROM `fm_brands` ORDER by `value` ASC 0.019
13 SELECT * FROM `shop_categories` WHERE id = ? 0.009
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.0108
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.0063
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.0091
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.0105
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.0137
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.0072
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.0082
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.0116
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.0078
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.0082
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.0244
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.0084
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.0075
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.0246
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.015
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.013
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.0116
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.0122
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.015
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.0096
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.032
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.3456
36 SQLSTATE[HY000]: General error: 2006 MySQL server has gone away 1.3456
- - All Queries Time 3.0876 


#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