| 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 |