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 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.0002
3 SELECT MAX(qa_id) FROM lele_question_and_answer 0.0003
4 SELECT * FROM lele_question_and_answer WHERE qa_id >= 1 ORDER BY qa_id ASC LIMIT 1 0.0003
5 SELECT * FROM 3w_meta WHERE meta_langId='' LIMIT 1 0.0001
6 SELECT config_value FROM 3w_config WHERE config_title = 'site_logo' 0.0002
7 SELECT * FROM 3w_banner_position WHERE bp_isactive=1 ORDER BY bp_id ASC 0.0001
8 SELECT * FROM 3w_banner WHERE b_positionId=1 ORDER BY RAND() LIMIT 1 0.0008
9 SELECT * FROM 3w_banner WHERE b_positionId=2 ORDER BY RAND() LIMIT 1 0.0006
10 SELECT * FROM 3w_banner WHERE b_positionId=3 ORDER BY RAND() LIMIT 1 0.0007
11 SELECT * FROM 3w_banner WHERE b_positionId=3 ORDER BY RAND() LIMIT 1 0.0008
12 SELECT * FROM `3w_manufacturers` WHERE `is_active`='1' AND logo IS NOT NULL AND logo<>'' ORDER BY `show_order` desc, `name` DESC 0.0023
13 SELECT * FROM 3w_menu_positions WHERE is_active = '1' 0.0001
14 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.0003
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 = 2 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 = 3 ORDER BY m.menu_order DESC 0.0003
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 = 4 ORDER BY m.menu_order DESC 0.0002
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 = 5 ORDER BY m.menu_order DESC 0.0002
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 = 6 ORDER BY m.menu_order DESC 0.0002
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 = 7 ORDER BY m.menu_order DESC 0.0006
21 UPDATE `3w_user_diary` SET `views_cnt`=`views_cnt` + 1 WHERE id = '338211' LIMIT 1 0.0002
22 SELECT * FROM `3w_user_diary` WHERE id = '338211' LIMIT 1 0.001
23 SELECT * FROM `3w_user_diary_images` WHERE diary_id = '338211' ORDER BY id DESC 0.0015
24 SELECT d.*, s.name AS section_name FROM 3w_user_diary AS d LEFT JOIN 3w_user_diary_sections AS s ON s.id=d.section_id WHERE member_id = '' ORDER BY RAND() LIMIT 5 0.0051
25 SELECT * FROM `3w_user_diary_images` WHERE diary_id = '381969' 0.0026
26 SELECT * FROM `3w_user_diary_images` WHERE diary_id = '381945' 0.0032
27 SELECT * FROM `3w_user_diary_images` WHERE diary_id = '381917' 0.0022
28 SELECT * FROM `3w_user_diary_images` WHERE diary_id = '382024' 0.0022
29 SELECT * FROM `3w_user_diary_images` WHERE diary_id = '382063' 0.0017
30 SELECT ug.* FROM 3w_user_garage ug WHERE ug.id= 0.0009
31 SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1 0.0009
- - All Queries Time 0.0301


A database error has occured. Please, try again later!