MySQL Debugger Results | ||
Count | SQL query | Time to execute |
1 | SELECT code FROM shop_languages WHERE id = ? | 0.0003 |
2 | SELECT id, word, lang_1 as text FROM shop_language_words | 0.0016 |
3 | SELECT * FROM currency | 0.0013 |
4 | SELECT * FROM shop_redirects WHERE old_url = ? | 0.0007 |
5 | SELECT id FROM fm_brands WHERE seo_url IN('jbm','ibix','airtec','giant','sanica','heracles','znd','tubes','atmos','komodo','eureka','unimec') | 0.0007 |
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.0004 |
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.0007 |
10 | SELECT COUNT(*) AS count FROM shop_products WHERE is_available = 1 AND active = 1 AND archive = 0 | 0.0005 |
11 | SELECT COUNT(*) AS count FROM shop_products WHERE archive = 1 | 0.0071 |
12 | SELECT `id` as `value`, `t` as `title` FROM `fm_brands` ORDER by `value` ASC | 0.001 |
13 | SELECT * FROM `shop_categories` WHERE id = ? | 0.0235 |
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.0095 |
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.001 |
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.0022 |
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.0003 |
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.0003 |
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.0002 |
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.0003 |
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.0004 |
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.0005 |
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.0003 |
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.0003 |
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.0003 |
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.0024 |
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.0003 |
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.0003 |
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.0005 |
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.0005 |
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.0045 |
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.0081 |
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.0059 |
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.0004 |
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.0003 |
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.0003 |
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.0003 |
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.0003 |
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.0008 |
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.005 |
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.0008 |
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.0009 |
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.0006 |
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.0008 |
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.0005 |
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.0005 |
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.0097 |
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.0115 |
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.0006 |
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.0006 |
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.0004 |
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.0012 |
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.0005 |
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.0045 |
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.0007 |
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.0006 |
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.0026 |
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.004 |
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.0006 |
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.0003 |
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.0003 |
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.0006 |
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.0009 |
68 | 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.0003 |
69 | 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.0006 |
70 | 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.0005 |
71 | 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.0003 |
72 | 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.0019 |
73 | 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.0004 |
74 | 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.0003 |
75 | 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.0003 |
76 | 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.0004 |
77 | 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.0006 |
78 | 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.0005 |
79 | 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.0005 |
80 | 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.0005 |
81 | 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.0003 |
82 | 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.002 |
83 | 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.0003 |
84 | 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.0004 |
85 | 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.0004 |
86 | 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.0024 |
87 | 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.0004 |
88 | 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.0038 |
89 | 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.0012 |
90 | 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.001 |
91 | 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.0005 |
92 | 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.0004 |
93 | 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.0006 |
94 | 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.0004 |
95 | 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.0037 |
96 | 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 |
97 | 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.0007 |
98 | 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.0023 |
99 | 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.1251 |
100 | 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.8415 |
101 | SQLSTATE[HY000]: General error: 2006 MySQL server has gone away | 0.8415 |
- - | All Queries Time | 1.9707 |
#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