MySQL Debugger Results |
Count |
SQL query |
Time to execute |
1 |
SELECT config_value FROM 3w_config WHERE config_title = 'default_lang' |
0.0607 |
2 |
SELECT * FROM 3w_route WHERE UPPER(route_seo_url)='E-KLASSE-CABRIO-A124' LIMIT 1 |
0.0209 |
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.0218 |
4 |
SELECT MAX(qa_id) FROM lele_question_and_answer |
0.0185 |
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.0219 |
9 |
SELECT * FROM 3w_banner WHERE b_positionId=1 ORDER BY RAND() LIMIT 1 |
0.0575 |
10 |
SELECT * FROM 3w_banner WHERE b_positionId=2 ORDER BY RAND() LIMIT 1 |
0.0059 |
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.0026 |
13 |
SELECT *
FROM `3w_manufacturers`
WHERE `is_active`='1' AND logo IS NOT NULL AND logo<>''
ORDER BY `show_order` desc, `name` DESC
|
0.002 |
14 |
SELECT * FROM 3w_menu_positions WHERE is_active = '1' |
0.0245 |
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.0005 |
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.0017 |
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.0001 |
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.0001 |
22 |
UPDATE 3w_manufacturers_series_models SET views_cnt=views_cnt+1 WHERE id=2001 LIMIT 1 |
0.0088 |
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=2001 LIMIT 1 |
0.0132 |
24 |
SELECT * FROM 3w_manufacturers WHERE id=133 LIMIT 1 |
0.0126 |
25 |
SELECT * FROM 3w_manufacturers_modifications WHERE user_mod=0 AND parent_id=2001 |
0.0007 |
26 |
SELECT property_id, property_value FROM 3w_modification_values WHERE modification_id=6541 HAVING property_id IN (15,39,40) |
0.0142 |
27 |
SELECT property_id, property_value FROM 3w_modification_values WHERE modification_id=6542 HAVING property_id IN (15,39,40) |
0.0007 |
28 |
SELECT property_id, property_value FROM 3w_modification_values WHERE modification_id=6543 HAVING property_id IN (15,39,40) |
0.0003 |
29 |
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=2001 AND mg.is_visible=1 ORDER BY mge.is_default DESC |
1.3259 |
30 |
SELECT * FROM 3w_comments WHERE comment_type=5 AND object_id=2001 ORDER BY id DESC |
7.4911 |
31 |
SELECT SUM(rate) FROM 3w_comments_rating WHERE comment_id = 4087664 |
0.0047 |
32 |
SELECT SUM(rate) FROM 3w_comments_rating WHERE comment_id = 4079344 |
0.0048 |
33 |
SELECT SUM(rate) FROM 3w_comments_rating WHERE comment_id = 4076544 |
0.0017 |
34 |
SELECT SUM(rate) FROM 3w_comments_rating WHERE comment_id = 4061041 |
0.0564 |
35 |
SELECT SUM(rate) FROM 3w_comments_rating WHERE comment_id = 4058425 |
0.0043 |
36 |
SELECT SUM(rate) FROM 3w_comments_rating WHERE comment_id = 4058126 |
0.01 |
37 |
SELECT SUM(rate) FROM 3w_comments_rating WHERE comment_id = 4040679 |
0.0072 |
38 |
SELECT SUM(rate) FROM 3w_comments_rating WHERE comment_id = 4038953 |
0.0998 |
39 |
SELECT SUM(rate) FROM 3w_comments_rating WHERE comment_id = 3975879 |
0.0227 |
40 |
SELECT SUM(rate) FROM 3w_comments_rating WHERE comment_id = 3975868 |
0.0378 |
41 |
SELECT SUM(rate) FROM 3w_comments_rating WHERE comment_id = 3975857 |
0.014 |
42 |
SELECT SUM(rate) FROM 3w_comments_rating WHERE comment_id = 3975851 |
0.0084 |
43 |
SELECT SUM(rate) FROM 3w_comments_rating WHERE comment_id = 3975837 |
0.0031 |
44 |
SELECT SUM(rate) FROM 3w_comments_rating WHERE comment_id = 3971929 |
0.0095 |
45 |
SELECT SUM(rate) FROM 3w_comments_rating WHERE comment_id = 3971914 |
0.0002 |
46 |
SELECT SUM(rate) FROM 3w_comments_rating WHERE comment_id = 3971903 |
0.0002 |
47 |
SELECT SUM(rate) FROM 3w_comments_rating WHERE comment_id = 3971890 |
0.0002 |
48 |
SELECT SUM(rate) FROM 3w_comments_rating WHERE comment_id = 3971877 |
0.0061 |
49 |
SELECT SUM(rate) FROM 3w_comments_rating WHERE comment_id = 3967645 |
0.0003 |
50 |
SELECT SUM(rate) FROM 3w_comments_rating WHERE comment_id = 3967637 |
0.0043 |
51 |
SELECT SUM(rate) FROM 3w_comments_rating WHERE comment_id = 3967624 |
0.0002 |
52 |
SELECT SUM(rate) FROM 3w_comments_rating WHERE comment_id = 3967612 |
0.0002 |
53 |
SELECT SUM(rate) FROM 3w_comments_rating WHERE comment_id = 3967600 |
0.0025 |
54 |
SELECT SUM(rate) FROM 3w_comments_rating WHERE comment_id = 3956849 |
0.0486 |
55 |
SELECT SUM(rate) FROM 3w_comments_rating WHERE comment_id = 3956836 |
0.0046 |
56 |
SELECT SUM(rate) FROM 3w_comments_rating WHERE comment_id = 3956822 |
0.0009 |
57 |
SELECT SUM(rate) FROM 3w_comments_rating WHERE comment_id = 3956806 |
0.001 |
58 |
SELECT SUM(rate) FROM 3w_comments_rating WHERE comment_id = 3956792 |
0.0088 |
59 |
SELECT SUM(rate) FROM 3w_comments_rating WHERE comment_id = 3953110 |
0.0002 |
60 |
SELECT SUM(rate) FROM 3w_comments_rating WHERE comment_id = 3953100 |
0.0002 |
61 |
SELECT SUM(rate) FROM 3w_comments_rating WHERE comment_id = 3953090 |
0.0002 |
62 |
SELECT SUM(rate) FROM 3w_comments_rating WHERE comment_id = 3953080 |
0.0504 |
63 |
SELECT SUM(rate) FROM 3w_comments_rating WHERE comment_id = 3953068 |
0.0198 |
64 |
SELECT SUM(rate) FROM 3w_comments_rating WHERE comment_id = 3949155 |
0.0209 |
65 |
SELECT SUM(rate) FROM 3w_comments_rating WHERE comment_id = 3949138 |
0.0007 |
66 |
SELECT SUM(rate) FROM 3w_comments_rating WHERE comment_id = 3949125 |
0.0012 |
67 |
SELECT SUM(rate) FROM 3w_comments_rating WHERE comment_id = 3949117 |
0.0003 |
68 |
SELECT SUM(rate) FROM 3w_comments_rating WHERE comment_id = 3949108 |
0.0006 |
69 |
SELECT SUM(rate) FROM 3w_comments_rating WHERE comment_id = 3945076 |
0.0105 |
70 |
SELECT SUM(rate) FROM 3w_comments_rating WHERE comment_id = 3945069 |
0.0007 |
71 |
SELECT SUM(rate) FROM 3w_comments_rating WHERE comment_id = 3945056 |
0.0011 |
72 |
SELECT SUM(rate) FROM 3w_comments_rating WHERE comment_id = 3945036 |
0.0002 |
73 |
SELECT SUM(rate) FROM 3w_comments_rating WHERE comment_id = 3945024 |
0.0002 |
74 |
SELECT SUM(rate) FROM 3w_comments_rating WHERE comment_id = 3933459 |
0.0002 |
75 |
SELECT SUM(rate) FROM 3w_comments_rating WHERE comment_id = 3933447 |
0.0005 |
76 |
SELECT SUM(rate) FROM 3w_comments_rating WHERE comment_id = 3933435 |
0.0006 |
77 |
SELECT SUM(rate) FROM 3w_comments_rating WHERE comment_id = 3933422 |
0.0004 |
78 |
SELECT SUM(rate) FROM 3w_comments_rating WHERE comment_id = 3933407 |
0.0019 |
79 |
SELECT SUM(rate) FROM 3w_comments_rating WHERE comment_id = 3929503 |
0.0002 |
80 |
SELECT SUM(rate) FROM 3w_comments_rating WHERE comment_id = 3929492 |
0.0002 |
81 |
SELECT SUM(rate) FROM 3w_comments_rating WHERE comment_id = 3929482 |
0.0007 |
82 |
SELECT SUM(rate) FROM 3w_comments_rating WHERE comment_id = 3929468 |
0.0047 |
83 |
SELECT SUM(rate) FROM 3w_comments_rating WHERE comment_id = 3929457 |
0.002 |
84 |
SELECT SUM(rate) FROM 3w_comments_rating WHERE comment_id = 3925438 |
0.0408 |
85 |
SELECT SUM(rate) FROM 3w_comments_rating WHERE comment_id = 3925426 |
0.0005 |
86 |
SELECT SUM(rate) FROM 3w_comments_rating WHERE comment_id = 3925409 |
0.0002 |
87 |
SELECT SUM(rate) FROM 3w_comments_rating WHERE comment_id = 3925391 |
0.0002 |
88 |
SELECT SUM(rate) FROM 3w_comments_rating WHERE comment_id = 3925378 |
0.0002 |
89 |
SELECT SUM(rate) FROM 3w_comments_rating WHERE comment_id = 3921112 |
0.0173 |
90 |
SELECT SUM(rate) FROM 3w_comments_rating WHERE comment_id = 3921098 |
0.0038 |
91 |
SELECT SUM(rate) FROM 3w_comments_rating WHERE comment_id = 3921087 |
0.0208 |
92 |
SELECT SUM(rate) FROM 3w_comments_rating WHERE comment_id = 3921077 |
0.0015 |
93 |
SELECT SUM(rate) FROM 3w_comments_rating WHERE comment_id = 3921065 |
0.0043 |
94 |
SELECT SUM(rate) FROM 3w_comments_rating WHERE comment_id = 3916952 |
0.0242 |
95 |
SELECT SUM(rate) FROM 3w_comments_rating WHERE comment_id = 3916931 |
0.0292 |
96 |
SELECT SUM(rate) FROM 3w_comments_rating WHERE comment_id = 3916911 |
0.0028 |
97 |
SELECT SUM(rate) FROM 3w_comments_rating WHERE comment_id = 3916893 |
0.0093 |
98 |
SELECT SUM(rate) FROM 3w_comments_rating WHERE comment_id = 3916876 |
0.0086 |
99 |
SELECT SUM(rate) FROM 3w_comments_rating WHERE comment_id = 3907775 |
0.0266 |
100 |
SELECT SUM(rate) FROM 3w_comments_rating WHERE comment_id = 3907764 |
0.0199 |
101 |
SELECT SUM(rate) FROM 3w_comments_rating WHERE comment_id = 3907749 |
0.0018 |
102 |
SELECT SUM(rate) FROM 3w_comments_rating WHERE comment_id = 3907734 |
0.0032 |
103 |
SELECT SUM(rate) FROM 3w_comments_rating WHERE comment_id = 3907717 |
0.037 |
104 |
SELECT SUM(rate) FROM 3w_comments_rating WHERE comment_id = 3903708 |
0.0088 |
105 |
SELECT SUM(rate) FROM 3w_comments_rating WHERE comment_id = 3903691 |
0.0262 |
106 |
SELECT SUM(rate) FROM 3w_comments_rating WHERE comment_id = 3903666 |
0.0009 |
107 |
SELECT SUM(rate) FROM 3w_comments_rating WHERE comment_id = 3903640 |
0.0025 |
108 |
SELECT SUM(rate) FROM 3w_comments_rating WHERE comment_id = 3903624 |
0.0002 |
109 |
SELECT SUM(rate) FROM 3w_comments_rating WHERE comment_id = 3900461 |
0.0002 |
110 |
SELECT SUM(rate) FROM 3w_comments_rating WHERE comment_id = 3900443 |
0.0071 |
111 |
SELECT SUM(rate) FROM 3w_comments_rating WHERE comment_id = 3900425 |
0.0003 |
112 |
SELECT SUM(rate) FROM 3w_comments_rating WHERE comment_id = 3900400 |
0.0156 |
113 |
SELECT SUM(rate) FROM 3w_comments_rating WHERE comment_id = 3900379 |
0.0274 |
114 |
SELECT SUM(rate) FROM 3w_comments_rating WHERE comment_id = 3887408 |
0.0495 |
115 |
SELECT SUM(rate) FROM 3w_comments_rating WHERE comment_id = 3887399 |
0.0109 |
116 |
SELECT SUM(rate) FROM 3w_comments_rating WHERE comment_id = 3887390 |
0.0027 |
117 |
SELECT SUM(rate) FROM 3w_comments_rating WHERE comment_id = 3887378 |
0.0017 |
118 |
SELECT SUM(rate) FROM 3w_comments_rating WHERE comment_id = 3887368 |
0.0003 |
119 |
SELECT SUM(rate) FROM 3w_comments_rating WHERE comment_id = 3878610 |
0.0016 |
120 |
SELECT SUM(rate) FROM 3w_comments_rating WHERE comment_id = 3878593 |
0.001 |
121 |
SELECT SUM(rate) FROM 3w_comments_rating WHERE comment_id = 3878572 |
0.0146 |
122 |
SELECT SUM(rate) FROM 3w_comments_rating WHERE comment_id = 3878554 |
0.0037 |
123 |
SELECT SUM(rate) FROM 3w_comments_rating WHERE comment_id = 3878534 |
0.0298 |
124 |
SELECT SUM(rate) FROM 3w_comments_rating WHERE comment_id = 3855500 |
0.0114 |
125 |
SELECT SUM(rate) FROM 3w_comments_rating WHERE comment_id = 3855490 |
0.0179 |
126 |
SELECT SUM(rate) FROM 3w_comments_rating WHERE comment_id = 3855478 |
0.0091 |
127 |
SELECT SUM(rate) FROM 3w_comments_rating WHERE comment_id = 3855463 |
0.0065 |
128 |
SELECT SUM(rate) FROM 3w_comments_rating WHERE comment_id = 3855446 |
0.0079 |
129 |
SELECT SUM(rate) FROM 3w_comments_rating WHERE comment_id = 3847709 |
0.0074 |
130 |
SELECT SUM(rate) FROM 3w_comments_rating WHERE comment_id = 3847706 |
0.0067 |
131 |
SELECT SUM(rate) FROM 3w_comments_rating WHERE comment_id = 3801526 |
0.0214 |
132 |
SELECT SUM(rate) FROM 3w_comments_rating WHERE comment_id = 3801511 |
0.0124 |
133 |
SELECT SUM(rate) FROM 3w_comments_rating WHERE comment_id = 3801499 |
0.0088 |
134 |
SELECT SUM(rate) FROM 3w_comments_rating WHERE comment_id = 3801484 |
0.0015 |
135 |
SELECT SUM(rate) FROM 3w_comments_rating WHERE comment_id = 3801472 |
0.0017 |
136 |
SELECT SUM(rate) FROM 3w_comments_rating WHERE comment_id = 3796636 |
0.0002 |
137 |
SELECT SUM(rate) FROM 3w_comments_rating WHERE comment_id = 3796617 |
0.0311 |
138 |
SELECT SUM(rate) FROM 3w_comments_rating WHERE comment_id = 3796597 |
0.0325 |
139 |
SELECT SUM(rate) FROM 3w_comments_rating WHERE comment_id = 3796580 |
0.011 |
140 |
SELECT SUM(rate) FROM 3w_comments_rating WHERE comment_id = 3796568 |
0.0533 |
141 |
SELECT SUM(rate) FROM 3w_comments_rating WHERE comment_id = 3773877 |
0.0045 |
142 |
SELECT SUM(rate) FROM 3w_comments_rating WHERE comment_id = 3405285 |
0.0475 |
143 |
SELECT SUM(rate) FROM 3w_comments_rating WHERE comment_id = 3401262 |
0.0091 |
144 |
SELECT SUM(rate) FROM 3w_comments_rating WHERE comment_id = 3301384 |
0.0259 |
145 |
SELECT SUM(rate) FROM 3w_comments_rating WHERE comment_id = 3301366 |
0.0239 |
146 |
SELECT SUM(rate) FROM 3w_comments_rating WHERE comment_id = 3301340 |
0.0162 |
147 |
SELECT SUM(rate) FROM 3w_comments_rating WHERE comment_id = 3301318 |
0.0056 |
148 |
SELECT SUM(rate) FROM 3w_comments_rating WHERE comment_id = 3301296 |
0.0241 |
149 |
SELECT SUM(rate) FROM 3w_comments_rating WHERE comment_id = 3287379 |
0.0005 |
150 |
SELECT SUM(rate) FROM 3w_comments_rating WHERE comment_id = 3287357 |
0.0004 |
151 |
SELECT SUM(rate) FROM 3w_comments_rating WHERE comment_id = 3287328 |
0.0002 |
152 |
SELECT SUM(rate) FROM 3w_comments_rating WHERE comment_id = 3287302 |
0.0003 |
153 |
SELECT SUM(rate) FROM 3w_comments_rating WHERE comment_id = 3287278 |
0.0033 |
154 |
SELECT SUM(rate) FROM 3w_comments_rating WHERE comment_id = 3283085 |
0.0075 |
155 |
SELECT SUM(rate) FROM 3w_comments_rating WHERE comment_id = 3283056 |
0.0005 |
156 |
SELECT SUM(rate) FROM 3w_comments_rating WHERE comment_id = 3283030 |
0.0029 |
157 |
SELECT SUM(rate) FROM 3w_comments_rating WHERE comment_id = 3283005 |
0.0029 |
158 |
SQLSTATE[HY000]: General error: 2013 Lost connection to MySQL server during query |
0.0029 |
- - |
All Queries Time |
10.4645 |