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)='CLS-SHOOTING-BRAKE-X218' LIMIT 1 |
0.033 |
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.02 |
4 |
SELECT MAX(qa_id) FROM lele_question_and_answer |
0.0272 |
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.062 |
10 |
SELECT * FROM 3w_banner WHERE b_positionId=2 ORDER BY RAND() LIMIT 1 |
0.0005 |
11 |
SELECT * FROM 3w_banner WHERE b_positionId=3 ORDER BY RAND() LIMIT 1 |
0.0025 |
12 |
SELECT * FROM 3w_banner WHERE b_positionId=3 ORDER BY RAND() LIMIT 1 |
0.0006 |
13 |
SELECT *
FROM `3w_manufacturers`
WHERE `is_active`='1' AND logo IS NOT NULL AND logo<>''
ORDER BY `show_order` desc, `name` DESC
|
0.0024 |
14 |
SELECT * FROM 3w_menu_positions WHERE is_active = '1' |
0.0002 |
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.0002 |
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.0002 |
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.0022 |
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=3379 LIMIT 1 |
0.0894 |
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=3379 LIMIT 1 |
0.3878 |
24 |
SELECT * FROM 3w_manufacturers WHERE id=133 LIMIT 1 |
0.007 |
25 |
SELECT * FROM 3w_manufacturers_modifications WHERE user_mod=0 AND parent_id=3379 |
0.0127 |
26 |
SELECT property_id, property_value FROM 3w_modification_values WHERE modification_id=54550 HAVING property_id IN (15,39,40) |
0.0611 |
27 |
SELECT property_id, property_value FROM 3w_modification_values WHERE modification_id=54549 HAVING property_id IN (15,39,40) |
0.0584 |
28 |
SELECT property_id, property_value FROM 3w_modification_values WHERE modification_id=54559 HAVING property_id IN (15,39,40) |
0.0091 |
29 |
SELECT property_id, property_value FROM 3w_modification_values WHERE modification_id=54560 HAVING property_id IN (15,39,40) |
0.0294 |
30 |
SELECT property_id, property_value FROM 3w_modification_values WHERE modification_id=54561 HAVING property_id IN (15,39,40) |
0.0147 |
31 |
SELECT property_id, property_value FROM 3w_modification_values WHERE modification_id=54562 HAVING property_id IN (15,39,40) |
0.0072 |
32 |
SELECT property_id, property_value FROM 3w_modification_values WHERE modification_id=54563 HAVING property_id IN (15,39,40) |
0.0062 |
33 |
SELECT property_id, property_value FROM 3w_modification_values WHERE modification_id=54564 HAVING property_id IN (15,39,40) |
0.0004 |
34 |
SELECT property_id, property_value FROM 3w_modification_values WHERE modification_id=54565 HAVING property_id IN (15,39,40) |
0.0116 |
35 |
SELECT property_id, property_value FROM 3w_modification_values WHERE modification_id=54566 HAVING property_id IN (15,39,40) |
0.0005 |
36 |
SELECT property_id, property_value FROM 3w_modification_values WHERE modification_id=54567 HAVING property_id IN (15,39,40) |
0.0003 |
37 |
SELECT property_id, property_value FROM 3w_modification_values WHERE modification_id=54568 HAVING property_id IN (15,39,40) |
0.0003 |
38 |
SELECT property_id, property_value FROM 3w_modification_values WHERE modification_id=54569 HAVING property_id IN (15,39,40) |
0.0135 |
39 |
SELECT property_id, property_value FROM 3w_modification_values WHERE modification_id=54570 HAVING property_id IN (15,39,40) |
0.0121 |
40 |
SELECT property_id, property_value FROM 3w_modification_values WHERE modification_id=54571 HAVING property_id IN (15,39,40) |
0.0138 |
41 |
SELECT property_id, property_value FROM 3w_modification_values WHERE modification_id=54572 HAVING property_id IN (15,39,40) |
0.0222 |
42 |
SELECT property_id, property_value FROM 3w_modification_values WHERE modification_id=54573 HAVING property_id IN (15,39,40) |
0.0143 |
43 |
SELECT property_id, property_value FROM 3w_modification_values WHERE modification_id=54574 HAVING property_id IN (15,39,40) |
0.0317 |
44 |
SELECT property_id, property_value FROM 3w_modification_values WHERE modification_id=54575 HAVING property_id IN (15,39,40) |
0.059 |
45 |
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=3379 AND mg.is_visible=1 ORDER BY mge.is_default DESC |
1.1508 |
46 |
SELECT * FROM 3w_comments WHERE comment_type=5 AND object_id=3379 ORDER BY id DESC |
6.8779 |
47 |
SELECT SUM(rate) FROM 3w_comments_rating WHERE comment_id = 4089275 |
0.0003 |
48 |
SELECT SUM(rate) FROM 3w_comments_rating WHERE comment_id = 4081005 |
0.0005 |
49 |
SELECT SUM(rate) FROM 3w_comments_rating WHERE comment_id = 4078049 |
0.0003 |
50 |
SELECT SUM(rate) FROM 3w_comments_rating WHERE comment_id = 4062834 |
0.0003 |
51 |
SELECT SUM(rate) FROM 3w_comments_rating WHERE comment_id = 4056390 |
0.0003 |
52 |
SELECT SUM(rate) FROM 3w_comments_rating WHERE comment_id = 4039348 |
0.0002 |
53 |
SELECT SUM(rate) FROM 3w_comments_rating WHERE comment_id = 4037410 |
0.0003 |
54 |
SELECT SUM(rate) FROM 3w_comments_rating WHERE comment_id = 3968664 |
0.0003 |
55 |
SELECT SUM(rate) FROM 3w_comments_rating WHERE comment_id = 3968647 |
0.0044 |
56 |
SELECT SUM(rate) FROM 3w_comments_rating WHERE comment_id = 3968631 |
0.0005 |
57 |
SELECT SUM(rate) FROM 3w_comments_rating WHERE comment_id = 3968619 |
0.0003 |
58 |
SELECT SUM(rate) FROM 3w_comments_rating WHERE comment_id = 3968607 |
0.0003 |
59 |
SELECT SUM(rate) FROM 3w_comments_rating WHERE comment_id = 3964186 |
0.0134 |
60 |
SELECT SUM(rate) FROM 3w_comments_rating WHERE comment_id = 3964171 |
0.0332 |
61 |
SELECT SUM(rate) FROM 3w_comments_rating WHERE comment_id = 3964154 |
0.019 |
62 |
SELECT SUM(rate) FROM 3w_comments_rating WHERE comment_id = 3964138 |
0.0367 |
63 |
SELECT SUM(rate) FROM 3w_comments_rating WHERE comment_id = 3964124 |
0.0005 |
64 |
SELECT SUM(rate) FROM 3w_comments_rating WHERE comment_id = 3960868 |
0.0003 |
65 |
SELECT SUM(rate) FROM 3w_comments_rating WHERE comment_id = 3960855 |
0.0003 |
66 |
SELECT SUM(rate) FROM 3w_comments_rating WHERE comment_id = 3960844 |
0.0444 |
67 |
SELECT SUM(rate) FROM 3w_comments_rating WHERE comment_id = 3960832 |
0.0225 |
68 |
SELECT SUM(rate) FROM 3w_comments_rating WHERE comment_id = 3960821 |
0.0226 |
69 |
SELECT SUM(rate) FROM 3w_comments_rating WHERE comment_id = 3957600 |
0.0333 |
70 |
SELECT SUM(rate) FROM 3w_comments_rating WHERE comment_id = 3957580 |
0.0268 |
71 |
SELECT SUM(rate) FROM 3w_comments_rating WHERE comment_id = 3957567 |
0.021 |
72 |
SELECT SUM(rate) FROM 3w_comments_rating WHERE comment_id = 3957556 |
0.0196 |
73 |
SELECT SUM(rate) FROM 3w_comments_rating WHERE comment_id = 3957545 |
0.0316 |
74 |
SELECT SUM(rate) FROM 3w_comments_rating WHERE comment_id = 3950057 |
0.0078 |
75 |
SELECT SUM(rate) FROM 3w_comments_rating WHERE comment_id = 3950041 |
0.019 |
76 |
SELECT SUM(rate) FROM 3w_comments_rating WHERE comment_id = 3950030 |
0.0215 |
77 |
SELECT SUM(rate) FROM 3w_comments_rating WHERE comment_id = 3950015 |
0.0087 |
78 |
SELECT SUM(rate) FROM 3w_comments_rating WHERE comment_id = 3950002 |
0.0273 |
79 |
SELECT SUM(rate) FROM 3w_comments_rating WHERE comment_id = 3942086 |
0.0119 |
80 |
SELECT SUM(rate) FROM 3w_comments_rating WHERE comment_id = 3942074 |
0.0472 |
81 |
SELECT SUM(rate) FROM 3w_comments_rating WHERE comment_id = 3942060 |
0.0003 |
82 |
SELECT SUM(rate) FROM 3w_comments_rating WHERE comment_id = 3942046 |
0.0123 |
83 |
SELECT SUM(rate) FROM 3w_comments_rating WHERE comment_id = 3942031 |
0.0002 |
84 |
SELECT SUM(rate) FROM 3w_comments_rating WHERE comment_id = 3934449 |
0.0002 |
85 |
SELECT SUM(rate) FROM 3w_comments_rating WHERE comment_id = 3934434 |
0.0002 |
86 |
SELECT SUM(rate) FROM 3w_comments_rating WHERE comment_id = 3934418 |
0.0002 |
87 |
SELECT SUM(rate) FROM 3w_comments_rating WHERE comment_id = 3934408 |
0.0003 |
88 |
SELECT SUM(rate) FROM 3w_comments_rating WHERE comment_id = 3934391 |
0.0002 |
89 |
SELECT SUM(rate) FROM 3w_comments_rating WHERE comment_id = 3930415 |
0.0002 |
90 |
SELECT SUM(rate) FROM 3w_comments_rating WHERE comment_id = 3930396 |
0.0003 |
91 |
SELECT SUM(rate) FROM 3w_comments_rating WHERE comment_id = 3930380 |
0.0002 |
92 |
SELECT SUM(rate) FROM 3w_comments_rating WHERE comment_id = 3930369 |
0.0002 |
93 |
SELECT SUM(rate) FROM 3w_comments_rating WHERE comment_id = 3930358 |
0.0014 |
94 |
SELECT SUM(rate) FROM 3w_comments_rating WHERE comment_id = 3926489 |
0.0018 |
95 |
SELECT SUM(rate) FROM 3w_comments_rating WHERE comment_id = 3926472 |
0.0061 |
96 |
SELECT SUM(rate) FROM 3w_comments_rating WHERE comment_id = 3926457 |
0.0021 |
97 |
SELECT SUM(rate) FROM 3w_comments_rating WHERE comment_id = 3926444 |
0.0031 |
98 |
SELECT SUM(rate) FROM 3w_comments_rating WHERE comment_id = 3926430 |
0.0028 |
99 |
SQLSTATE[HY000]: General error: 2013 Lost connection to MySQL server during query |
0.0028 |
- - |
All Queries Time |
9.5548 |