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.0001 |
4 |
SELECT * FROM lele_question_and_answer WHERE qa_id >= 1 ORDER BY qa_id ASC LIMIT 1 |
0.0001 |
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.0001 |
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.0005 |
9 |
SELECT * FROM 3w_banner WHERE b_positionId=2 ORDER BY RAND() LIMIT 1 |
0.0004 |
10 |
SELECT * FROM 3w_banner WHERE b_positionId=3 ORDER BY RAND() LIMIT 1 |
0.0004 |
11 |
SELECT * FROM 3w_banner WHERE b_positionId=3 ORDER BY RAND() LIMIT 1 |
0.0004 |
12 |
SELECT *
FROM `3w_manufacturers`
WHERE `is_active`='1' AND logo IS NOT NULL AND logo<>''
ORDER BY `show_order` desc, `name` DESC
|
0.0011 |
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.0001 |
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.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 = 3 ORDER BY m.menu_order DESC |
0.0001 |
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.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 = 5 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 = 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.0001 |
21 |
SELECT COUNT(*) FROM lele_posts p LEFT JOIN ipb_topics t ON p.topic_id = t.tid WHERE p.author_id = 1515 AND t.forum_id NOT IN (38, 102) |
0.0002 |
22 |
SELECT p.*, t.title FROM lele_posts p
LEFT JOIN ipb_topics t ON p.topic_id = t.tid
WHERE p.author_id = 1515 AND t.forum_id NOT IN (38, 102)
ORDER BY p.pid DESC LIMIT 0, 10 |
0.003 |
23 |
SELECT COUNT(*) FROM `3w_user_comments` WHERE to_member_id = '1515' |
0.0588 |
24 |
SELECT * FROM `3w_user_comments` WHERE to_member_id = '1515' ORDER BY id DESC LIMIT 5 |
0.2277 |
25 |
SELECT members_display_name FROM lele_members WHERE member_id="1515" LIMIT 1 |
0.0003 |
26 |
UPDATE `ipb_members` SET `members_profile_views`=`members_profile_views` + 1 WHERE member_id = 1515 |
0.0443 |
27 |
SELECT * FROM lele_members WHERE member_id=1515 LIMIT 1 |
0.0002 |
28 |
SELECT * FROM lele_profile_portal WHERE pp_member_id=1515 LIMIT 1 |
0.0002 |
29 |
SELECT * FROM lele_pfields_content WHERE member_id=1515 LIMIT 1 |
0.0001 |
30 |
SELECT COUNT(id) FROM ipb_sessions WHERE member_id = 1515 |
0.0001 |
31 |
SELECT COUNT(friends_id) FROM lele_profile_friends WHERE friends_member_id=1515 AND friends_approved=1 |
0.0001 |
32 |
SELECT COUNT(tid) FROM lele_topics WHERE starter_id=1515 AND forum_id NOT IN (38, 102) |
0.0001 |
33 |
SELECT COUNT(*) FROM lele_posts p LEFT JOIN ipb_topics t ON p.topic_id = t.tid WHERE p.author_id = 1515 AND t.forum_id NOT IN (38, 102) |
0.0001 |
34 |
SELECT title FROM lele_titles WHERE posts>399 ORDER BY posts ASC LIMIT 1 |
0.0001 |
35 |
SELECT g.*, m.name AS man_name, md.name AS mode_name FROM 3w_user_garage AS g LEFT JOIN 3w_manufacturers AS m ON m.id=g.manufacturer_id LEFT JOIN 3w_manufacturers_modifications AS md ON md.id=g.modification_id WHERE g.member_id=1515 ORDER BY g.id ASC |
10.1274 |
36 |
SQLSTATE[HY000]: General error: 2013 Lost connection to MySQL server during query |
10.1274 |
- - |
All Queries Time |
20.5946 |