MySQL Debugger Results
Count SQL query Time to execute
1 SELECT code FROM shop_languages WHERE id = ? 0.0058
2 SELECT id, word, lang_1 as text FROM shop_language_words 0.0018
3 SELECT * FROM currency 0.0002
4 SELECT * FROM shop_redirects WHERE old_url = ? 0.0006
5 SELECT id FROM fm_brands WHERE seo_url IN('sany','jumbo','mpc','elsea','giant','acf','ltmg','saro','gmvas','vimpo','atmos','emiliana-serbatoi') 0.0009
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.0023
7 SELECT * FROM `shop_languages` WHERE id = ? 0.0002
8 SELECT `id` as `value`, `name` as `title` FROM `shop_properties` ORDER by `value` ASC 0.0006
9 SELECT `id` as `value`, `name` as `title` FROM `shop_properties` ORDER by `value` ASC 0.0008
10 SELECT COUNT(*) AS count FROM shop_products WHERE is_available = 1 AND active = 1 AND archive = 0 0.0054
11 SELECT COUNT(*) AS count FROM shop_products WHERE archive = 1 0.0038
12 SELECT `id` as `value`, `t` as `title` FROM `fm_brands` ORDER by `value` ASC 0.0144
13 SELECT * FROM `shop_categories` WHERE id = ? 0.0175
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.0324
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.0021
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.0002
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.0002
18 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.0002
19 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.0002
20 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.0003
21 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.0003
22 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.0003
23 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.0004
24 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.0003
25 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.0003
26 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.0004
27 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.0004
28 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.0004
29 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.0005
30 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.0003
31 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.0003
32 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.0003
33 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
34 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.0003
35 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.0003
36 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.0005
37 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.0003
38 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.0004
39 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.0003
40 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.0003
41 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.0096
42 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.0003
43 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.0044
44 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.0003
45 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.0048
46 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.0037
47 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.0003
48 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.0006
49 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.0008
50 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.0005
51 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.0006
52 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.0007
53 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.0004
54 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.0006
55 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.0014
56 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.0007
57 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.0005
58 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.0006
59 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.0008
60 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.0014
61 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.0006
62 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.0021
63 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.0006
64 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.0014
65 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.0017
66 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.0018
67 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.0011
68 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.0008
69 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.0013
70 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.0009
71 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.0011
72 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.0012
73 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.0004
74 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.0024
75 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 1.5371
76 SQLSTATE[HY000]: General error: 2006 MySQL server has gone away 1.5372
- - All Queries Time 3.2215


#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(72): 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