| 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.0003 |
| 3 | SELECT MAX(qa_id) FROM lele_question_and_answer | 0.0047 |
| 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.0006 |
| 9 | SELECT * FROM 3w_banner WHERE b_positionId=2 ORDER BY RAND() LIMIT 1 | 0.0005 |
| 10 | SELECT * FROM 3w_banner WHERE b_positionId=3 ORDER BY RAND() LIMIT 1 | 0.0005 |
| 11 | SELECT * FROM 3w_banner WHERE b_positionId=3 ORDER BY RAND() LIMIT 1 | 0.0005 |
| 12 | SELECT * FROM `3w_manufacturers` WHERE `is_active`='1' AND logo IS NOT NULL AND logo<>'' ORDER BY `show_order` desc, `name` DESC | 0.0401 |
| 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.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 = 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.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 = 7 ORDER BY m.menu_order DESC | 0.0101 |
| 21 | SELECT * FROM 3w_offers WHERE id=1399 AND is_expired=0 LIMIT 1 | 0.0063 |
| 22 | SELECT * FROM 3w_offer_values WHERE offer_id=1399 | 0.0147 |
| 23 | SELECT name FROM 3w_offer_params WHERE id=2 LIMIT 1 | 0.0001 |
| 24 | SELECT value FROM 3w_offer_param_values WHERE id='8' LIMIT 1 | 0.0001 |
| 25 | SELECT name FROM 3w_offer_params WHERE id=3 LIMIT 1 | 0.0001 |
| 26 | SELECT value FROM 3w_offer_param_values WHERE id='9' LIMIT 1 | 0.0022 |
| 27 | SELECT name FROM 3w_offer_params WHERE id=13 LIMIT 1 | 0.0001 |
| 28 | SELECT value FROM 3w_offer_param_values WHERE id='215' LIMIT 1 | 0.0031 |
| 29 | SELECT name FROM 3w_offer_params WHERE id=11 LIMIT 1 | 0.0001 |
| 30 | SELECT value FROM 3w_offer_param_values WHERE id='122' LIMIT 1 | 0.0061 |
| 31 | SELECT name FROM 3w_offer_params WHERE id=1 LIMIT 1 | 0.0242 |
| 32 | SELECT value FROM 3w_offer_param_values WHERE id='2' LIMIT 1 | 0.0001 |
| 33 | SELECT name FROM 3w_offer_params WHERE id=12 LIMIT 1 | 0.0001 |
| 34 | SELECT value FROM 3w_offer_param_values WHERE id='115' LIMIT 1 | 0.003 |
| 35 | SELECT * FROM 3w_offer_images WHERE offer_id=1399 | 0.0088 |
| 36 | UPDATE 3w_offers SET views_cnt=views_cnt+1 WHERE id=1399 LIMIT 1 | 0.0837 |
| 37 | SELECT city FROM 3w_cities WHERE id=214 LIMIT 1 | 0.0001 |
| 38 | SELECT * FROM 3w_offer_categories WHERE id=1 LIMIT 1 | 0.0001 |
| 39 | SELECT COUNT(*) FROM `3w_comments` WHERE object_id = '1399' AND comment_type = '8' | 7.3945 |
| 40 | SELECT * FROM `3w_comments` WHERE object_id = '1399' AND comment_type = '8' ORDER BY id DESC LIMIT 5 | 2.4048 |
| 41 | SQLSTATE[HY000]: General error: 2013 Lost connection to MySQL server during query | 2.4048 |
| - - | All Queries Time | 12.4157 |