MySQL Debugger Results |
Count |
SQL query |
Time to execute |
1 |
SELECT config_value FROM 3w_config WHERE config_title = 'default_lang' |
0.0001 |
2 |
SELECT * FROM 3w_route WHERE UPPER(route_seo_url)='CABRIOLET-89' LIMIT 1 |
0.0012 |
3 |
SELECT rule_power FROM 3w_access_rules WHERE rule_section=:section AND rule_package=:package AND rule_controller=:controller AND rule_action=:action LIMIT 1 |
0.0037 |
4 |
SELECT MAX(qa_id) FROM lele_question_and_answer |
0.0001 |
5 |
SELECT * FROM lele_question_and_answer WHERE qa_id >= 1 ORDER BY qa_id ASC LIMIT 1 |
0.0001 |
6 |
SELECT * FROM 3w_meta WHERE meta_langId='' LIMIT 1 |
0.0001 |
7 |
SELECT config_value FROM 3w_config WHERE config_title = 'site_logo' |
0.0001 |
8 |
SELECT * FROM 3w_banner_position WHERE bp_isactive=1 ORDER BY bp_id ASC |
0.0001 |
9 |
SELECT * FROM 3w_banner WHERE b_positionId=1 ORDER BY RAND() LIMIT 1 |
0.0007 |
10 |
SELECT * FROM 3w_banner WHERE b_positionId=2 ORDER BY RAND() LIMIT 1 |
0.0028 |
11 |
SELECT * FROM 3w_banner WHERE b_positionId=3 ORDER BY RAND() LIMIT 1 |
0.0004 |
12 |
SELECT * FROM 3w_banner WHERE b_positionId=3 ORDER BY RAND() LIMIT 1 |
0.0004 |
13 |
SELECT *
FROM `3w_manufacturers`
WHERE `is_active`='1' AND logo IS NOT NULL AND logo<>''
ORDER BY `show_order` desc, `name` DESC
|
0.0021 |
14 |
SELECT * FROM 3w_menu_positions WHERE is_active = '1' |
0.0468 |
15 |
SELECT m.*, ml.menu_name, r.route_seo_url FROM 3w_menus AS m LEFT JOIN 3w_menu_lang AS ml ON (ml.menu_id=m.menu_id AND ml.lang_id=1) LEFT JOIN 3w_route r ON m.menu_routeId=r.id WHERE m.menu_isactive=1 AND m.menu_position_id = 1 ORDER BY m.menu_order DESC |
0.0001 |
16 |
SELECT m.*, ml.menu_name, r.route_seo_url FROM 3w_menus AS m LEFT JOIN 3w_menu_lang AS ml ON (ml.menu_id=m.menu_id AND ml.lang_id=1) LEFT JOIN 3w_route r ON m.menu_routeId=r.id WHERE m.menu_isactive=1 AND m.menu_position_id = 2 ORDER BY m.menu_order DESC |
0.0007 |
17 |
SELECT m.*, ml.menu_name, r.route_seo_url FROM 3w_menus AS m LEFT JOIN 3w_menu_lang AS ml ON (ml.menu_id=m.menu_id AND ml.lang_id=1) LEFT JOIN 3w_route r ON m.menu_routeId=r.id WHERE m.menu_isactive=1 AND m.menu_position_id = 3 ORDER BY m.menu_order DESC |
0.0001 |
18 |
SELECT m.*, ml.menu_name, r.route_seo_url FROM 3w_menus AS m LEFT JOIN 3w_menu_lang AS ml ON (ml.menu_id=m.menu_id AND ml.lang_id=1) LEFT JOIN 3w_route r ON m.menu_routeId=r.id WHERE m.menu_isactive=1 AND m.menu_position_id = 4 ORDER BY m.menu_order DESC |
0.0001 |
19 |
SELECT m.*, ml.menu_name, r.route_seo_url FROM 3w_menus AS m LEFT JOIN 3w_menu_lang AS ml ON (ml.menu_id=m.menu_id AND ml.lang_id=1) LEFT JOIN 3w_route r ON m.menu_routeId=r.id WHERE m.menu_isactive=1 AND m.menu_position_id = 5 ORDER BY m.menu_order DESC |
0.0001 |
20 |
SELECT m.*, ml.menu_name, r.route_seo_url FROM 3w_menus AS m LEFT JOIN 3w_menu_lang AS ml ON (ml.menu_id=m.menu_id AND ml.lang_id=1) LEFT JOIN 3w_route r ON m.menu_routeId=r.id WHERE m.menu_isactive=1 AND m.menu_position_id = 6 ORDER BY m.menu_order DESC |
0.004 |
21 |
SELECT m.*, ml.menu_name, r.route_seo_url FROM 3w_menus AS m LEFT JOIN 3w_menu_lang AS ml ON (ml.menu_id=m.menu_id AND ml.lang_id=1) LEFT JOIN 3w_route r ON m.menu_routeId=r.id WHERE m.menu_isactive=1 AND m.menu_position_id = 7 ORDER BY m.menu_order DESC |
0.0032 |
22 |
UPDATE 3w_manufacturers_series_models SET views_cnt=views_cnt+1 WHERE id=708 LIMIT 1 |
0.06 |
23 |
SELECT msm.*, m.id AS man_id, m.name AS man_name FROM 3w_manufacturers_series_models AS msm LEFT JOIN 3w_manufacturers_series AS ms ON ms.id=msm.parent_id LEFT JOIN 3w_manufacturers AS m ON m.id=ms.parent_id WHERE msm.id=708 LIMIT 1 |
0.6783 |
24 |
SELECT * FROM 3w_manufacturers WHERE id=41 LIMIT 1 |
0.0274 |
25 |
SELECT * FROM 3w_manufacturers_modifications WHERE user_mod=0 AND parent_id=708 |
0.0054 |
26 |
SELECT property_id, property_value FROM 3w_modification_values WHERE modification_id=2118 HAVING property_id IN (15,39,40) |
0.0005 |
27 |
SELECT property_id, property_value FROM 3w_modification_values WHERE modification_id=2119 HAVING property_id IN (15,39,40) |
0.0048 |
28 |
SELECT property_id, property_value FROM 3w_modification_values WHERE modification_id=2120 HAVING property_id IN (15,39,40) |
0.0001 |
29 |
SELECT property_id, property_value FROM 3w_modification_values WHERE modification_id=2121 HAVING property_id IN (15,39,40) |
0.0001 |
30 |
SELECT property_id, property_value FROM 3w_modification_values WHERE modification_id=2122 HAVING property_id IN (15,39,40) |
0.0001 |
31 |
SELECT mge.image FROM 3w_manufacturers_galleries_extended AS mge LEFT JOIN 3w_manufacturers_galleries AS mg ON mg.id = mge.parent_id WHERE mg.model_id=708 AND mg.is_visible=1 ORDER BY mge.is_default DESC |
0.0001 |
32 |
SELECT * FROM 3w_comments WHERE comment_type=5 AND object_id=708 ORDER BY id DESC |
8.1548 |
33 |
SELECT SUM(rate) FROM 3w_comments_rating WHERE comment_id = 4089061 |
0.0003 |
34 |
SELECT SUM(rate) FROM 3w_comments_rating WHERE comment_id = 4088444 |
0.0008 |
35 |
SELECT SUM(rate) FROM 3w_comments_rating WHERE comment_id = 4080762 |
0.0006 |
36 |
SELECT SUM(rate) FROM 3w_comments_rating WHERE comment_id = 4080126 |
0.0202 |
37 |
SELECT SUM(rate) FROM 3w_comments_rating WHERE comment_id = 4077811 |
0.0433 |
38 |
SELECT SUM(rate) FROM 3w_comments_rating WHERE comment_id = 4077191 |
0.0696 |
39 |
SELECT SUM(rate) FROM 3w_comments_rating WHERE comment_id = 4064252 |
0.0195 |
40 |
SELECT SUM(rate) FROM 3w_comments_rating WHERE comment_id = 4063742 |
0.0332 |
41 |
SELECT SUM(rate) FROM 3w_comments_rating WHERE comment_id = 4062088 |
0.05 |
42 |
SELECT SUM(rate) FROM 3w_comments_rating WHERE comment_id = 4061277 |
0.0439 |
43 |
SELECT SUM(rate) FROM 3w_comments_rating WHERE comment_id = 4057498 |
0.002 |
44 |
SELECT SUM(rate) FROM 3w_comments_rating WHERE comment_id = 4056028 |
0.0231 |
45 |
SELECT SUM(rate) FROM 3w_comments_rating WHERE comment_id = 4040288 |
0.0457 |
46 |
SELECT SUM(rate) FROM 3w_comments_rating WHERE comment_id = 3962937 |
0.0378 |
47 |
SELECT SUM(rate) FROM 3w_comments_rating WHERE comment_id = 3962920 |
0.0508 |
48 |
SELECT SUM(rate) FROM 3w_comments_rating WHERE comment_id = 3962905 |
0.0798 |
49 |
SELECT SUM(rate) FROM 3w_comments_rating WHERE comment_id = 3962890 |
0.013 |
50 |
SELECT SUM(rate) FROM 3w_comments_rating WHERE comment_id = 3962878 |
0.0231 |
51 |
SELECT SUM(rate) FROM 3w_comments_rating WHERE comment_id = 3959334 |
0.0303 |
52 |
SELECT SUM(rate) FROM 3w_comments_rating WHERE comment_id = 3959316 |
0.0215 |
53 |
SELECT SUM(rate) FROM 3w_comments_rating WHERE comment_id = 3959306 |
0.0171 |
54 |
SELECT SUM(rate) FROM 3w_comments_rating WHERE comment_id = 3959291 |
0.0059 |
55 |
SELECT SUM(rate) FROM 3w_comments_rating WHERE comment_id = 3959285 |
0.0006 |
56 |
SELECT SUM(rate) FROM 3w_comments_rating WHERE comment_id = 3902784 |
0.0003 |
57 |
SELECT SUM(rate) FROM 3w_comments_rating WHERE comment_id = 3902760 |
0.0003 |
58 |
SELECT SUM(rate) FROM 3w_comments_rating WHERE comment_id = 3902740 |
0.0003 |
59 |
SELECT SUM(rate) FROM 3w_comments_rating WHERE comment_id = 3902727 |
0.0003 |
60 |
SELECT SUM(rate) FROM 3w_comments_rating WHERE comment_id = 3902706 |
0.0003 |
61 |
SELECT SUM(rate) FROM 3w_comments_rating WHERE comment_id = 3890883 |
0.0003 |
62 |
SELECT SUM(rate) FROM 3w_comments_rating WHERE comment_id = 3890873 |
0.0003 |
63 |
SELECT SUM(rate) FROM 3w_comments_rating WHERE comment_id = 3890860 |
0.0003 |
64 |
SELECT SUM(rate) FROM 3w_comments_rating WHERE comment_id = 3890848 |
0.0296 |
65 |
SELECT SUM(rate) FROM 3w_comments_rating WHERE comment_id = 3890835 |
0.0306 |
66 |
SELECT SUM(rate) FROM 3w_comments_rating WHERE comment_id = 3886461 |
0.0177 |
67 |
SELECT SUM(rate) FROM 3w_comments_rating WHERE comment_id = 3886444 |
0.024 |
68 |
SELECT SUM(rate) FROM 3w_comments_rating WHERE comment_id = 3886432 |
0.037 |
69 |
SELECT SUM(rate) FROM 3w_comments_rating WHERE comment_id = 3886422 |
0.0008 |
70 |
SELECT SUM(rate) FROM 3w_comments_rating WHERE comment_id = 3886411 |
0.0023 |
71 |
SELECT SUM(rate) FROM 3w_comments_rating WHERE comment_id = 3847076 |
0.0002 |
72 |
SELECT SUM(rate) FROM 3w_comments_rating WHERE comment_id = 3847067 |
0.0003 |
73 |
SELECT SUM(rate) FROM 3w_comments_rating WHERE comment_id = 3847063 |
0.0004 |
74 |
SELECT SUM(rate) FROM 3w_comments_rating WHERE comment_id = 3805368 |
0.0004 |
75 |
SELECT SUM(rate) FROM 3w_comments_rating WHERE comment_id = 3805352 |
0.0004 |
76 |
SELECT SUM(rate) FROM 3w_comments_rating WHERE comment_id = 3805325 |
0.0003 |
77 |
SELECT SUM(rate) FROM 3w_comments_rating WHERE comment_id = 3805309 |
0.0003 |
78 |
SELECT SUM(rate) FROM 3w_comments_rating WHERE comment_id = 3805294 |
0.0004 |
79 |
SELECT SUM(rate) FROM 3w_comments_rating WHERE comment_id = 3787147 |
0.0004 |
80 |
SELECT SUM(rate) FROM 3w_comments_rating WHERE comment_id = 3787129 |
0.0004 |
81 |
SELECT SUM(rate) FROM 3w_comments_rating WHERE comment_id = 3787106 |
0.0004 |
82 |
SELECT SUM(rate) FROM 3w_comments_rating WHERE comment_id = 3787093 |
0.0004 |
83 |
SELECT SUM(rate) FROM 3w_comments_rating WHERE comment_id = 3787077 |
0.0004 |
84 |
SELECT SUM(rate) FROM 3w_comments_rating WHERE comment_id = 3773084 |
0.0003 |
85 |
SELECT SUM(rate) FROM 3w_comments_rating WHERE comment_id = 3408125 |
0.0004 |
86 |
SELECT SUM(rate) FROM 3w_comments_rating WHERE comment_id = 3405265 |
0.0002 |
87 |
SELECT SUM(rate) FROM 3w_comments_rating WHERE comment_id = 3402021 |
0.0005 |
88 |
SELECT SUM(rate) FROM 3w_comments_rating WHERE comment_id = 3309212 |
0.0004 |
89 |
SELECT SUM(rate) FROM 3w_comments_rating WHERE comment_id = 3309201 |
0.0005 |
90 |
SELECT SUM(rate) FROM 3w_comments_rating WHERE comment_id = 3309183 |
0.0004 |
91 |
SELECT SUM(rate) FROM 3w_comments_rating WHERE comment_id = 3309156 |
0.0005 |
92 |
SELECT SUM(rate) FROM 3w_comments_rating WHERE comment_id = 3309132 |
0.0005 |
93 |
SELECT SUM(rate) FROM 3w_comments_rating WHERE comment_id = 3306488 |
0.0005 |
94 |
SELECT SUM(rate) FROM 3w_comments_rating WHERE comment_id = 3306471 |
0.0008 |
95 |
SELECT SUM(rate) FROM 3w_comments_rating WHERE comment_id = 3306461 |
0.0011 |
96 |
SELECT SUM(rate) FROM 3w_comments_rating WHERE comment_id = 3306447 |
0.0009 |
97 |
SELECT SUM(rate) FROM 3w_comments_rating WHERE comment_id = 3306431 |
0.0032 |
98 |
SELECT SUM(rate) FROM 3w_comments_rating WHERE comment_id = 3305104 |
0.007 |
99 |
SELECT SUM(rate) FROM 3w_comments_rating WHERE comment_id = 3305090 |
0.0102 |
100 |
SELECT SUM(rate) FROM 3w_comments_rating WHERE comment_id = 3305068 |
0.0009 |
101 |
SELECT SUM(rate) FROM 3w_comments_rating WHERE comment_id = 3305038 |
0.0121 |
102 |
SELECT SUM(rate) FROM 3w_comments_rating WHERE comment_id = 3305016 |
0.0016 |
103 |
SELECT SUM(rate) FROM 3w_comments_rating WHERE comment_id = 3302157 |
0.0007 |
104 |
SELECT SUM(rate) FROM 3w_comments_rating WHERE comment_id = 3302137 |
0.0006 |
105 |
SELECT SUM(rate) FROM 3w_comments_rating WHERE comment_id = 3302118 |
0.0007 |
106 |
SELECT SUM(rate) FROM 3w_comments_rating WHERE comment_id = 3302106 |
0.0044 |
107 |
SELECT SUM(rate) FROM 3w_comments_rating WHERE comment_id = 3302093 |
0.0024 |
108 |
SELECT SUM(rate) FROM 3w_comments_rating WHERE comment_id = 3297753 |
0.0277 |
109 |
SELECT SUM(rate) FROM 3w_comments_rating WHERE comment_id = 3297737 |
0.0027 |
110 |
SELECT SUM(rate) FROM 3w_comments_rating WHERE comment_id = 3297718 |
0.0022 |
111 |
SELECT SUM(rate) FROM 3w_comments_rating WHERE comment_id = 3297699 |
0.0026 |
112 |
SELECT SUM(rate) FROM 3w_comments_rating WHERE comment_id = 3297674 |
0.0023 |
113 |
SELECT SUM(rate) FROM 3w_comments_rating WHERE comment_id = 3293380 |
0.0029 |
114 |
SELECT SUM(rate) FROM 3w_comments_rating WHERE comment_id = 3293368 |
0.0028 |
115 |
SELECT SUM(rate) FROM 3w_comments_rating WHERE comment_id = 3293352 |
0.0061 |
116 |
SELECT SUM(rate) FROM 3w_comments_rating WHERE comment_id = 3293329 |
0.0112 |
117 |
SELECT SUM(rate) FROM 3w_comments_rating WHERE comment_id = 3293308 |
0.0069 |
118 |
SELECT SUM(rate) FROM 3w_comments_rating WHERE comment_id = 3274872 |
0.017 |
119 |
SELECT SUM(rate) FROM 3w_comments_rating WHERE comment_id = 3274863 |
0.0025 |
120 |
SELECT SUM(rate) FROM 3w_comments_rating WHERE comment_id = 3274847 |
0.0091 |
121 |
SELECT SUM(rate) FROM 3w_comments_rating WHERE comment_id = 3274825 |
0.0025 |
122 |
SELECT SUM(rate) FROM 3w_comments_rating WHERE comment_id = 3274801 |
0.0214 |
123 |
SELECT SUM(rate) FROM 3w_comments_rating WHERE comment_id = 3256967 |
0.0006 |
124 |
SELECT SUM(rate) FROM 3w_comments_rating WHERE comment_id = 3256957 |
0.0028 |
125 |
SELECT SUM(rate) FROM 3w_comments_rating WHERE comment_id = 3256935 |
0.0006 |
126 |
SELECT SUM(rate) FROM 3w_comments_rating WHERE comment_id = 3256907 |
0.0196 |
127 |
SELECT SUM(rate) FROM 3w_comments_rating WHERE comment_id = 3256879 |
0.012 |
128 |
SELECT SUM(rate) FROM 3w_comments_rating WHERE comment_id = 3255608 |
0.0037 |
129 |
SELECT SUM(rate) FROM 3w_comments_rating WHERE comment_id = 3255583 |
0.0005 |
130 |
SELECT SUM(rate) FROM 3w_comments_rating WHERE comment_id = 3255555 |
0.0026 |
131 |
SELECT SUM(rate) FROM 3w_comments_rating WHERE comment_id = 3255524 |
0.0014 |
132 |
SELECT SUM(rate) FROM 3w_comments_rating WHERE comment_id = 3255502 |
0.0152 |
133 |
SELECT SUM(rate) FROM 3w_comments_rating WHERE comment_id = 3252475 |
0.0128 |
134 |
SELECT SUM(rate) FROM 3w_comments_rating WHERE comment_id = 3252452 |
0.0035 |
135 |
SELECT SUM(rate) FROM 3w_comments_rating WHERE comment_id = 3252432 |
0.0231 |
136 |
SELECT SUM(rate) FROM 3w_comments_rating WHERE comment_id = 3252412 |
0.0053 |
137 |
SELECT SUM(rate) FROM 3w_comments_rating WHERE comment_id = 3252392 |
0.014 |
138 |
SELECT SUM(rate) FROM 3w_comments_rating WHERE comment_id = 3241986 |
0.0327 |
139 |
SELECT SUM(rate) FROM 3w_comments_rating WHERE comment_id = 3241971 |
0.0035 |
140 |
SELECT SUM(rate) FROM 3w_comments_rating WHERE comment_id = 3241946 |
0.012 |
141 |
SELECT SUM(rate) FROM 3w_comments_rating WHERE comment_id = 3241910 |
0.1244 |
142 |
SELECT SUM(rate) FROM 3w_comments_rating WHERE comment_id = 3241875 |
0.1006 |
143 |
SELECT SUM(rate) FROM 3w_comments_rating WHERE comment_id = 3238922 |
0.0228 |
144 |
SELECT SUM(rate) FROM 3w_comments_rating WHERE comment_id = 3238897 |
0.0154 |
145 |
SELECT SUM(rate) FROM 3w_comments_rating WHERE comment_id = 3238873 |
0.0186 |
146 |
SELECT SUM(rate) FROM 3w_comments_rating WHERE comment_id = 3238850 |
0.1062 |
147 |
SELECT SUM(rate) FROM 3w_comments_rating WHERE comment_id = 3238827 |
0.4403 |
148 |
SELECT SUM(rate) FROM 3w_comments_rating WHERE comment_id = 3234728 |
0.0051 |
149 |
SELECT SUM(rate) FROM 3w_comments_rating WHERE comment_id = 3234707 |
0.0306 |
150 |
SQLSTATE[HY000]: General error: 2013 Lost connection to MySQL server during query |
0.0306 |
- - |
All Queries Time |
11.011 |