| 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)='CABRIOLET-89' LIMIT 1 | 0.0012 |
| 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.0037 |
| 4 | SELECT MAX(qa_id) FROM lele_question_and_answer | 0.0001 |
| 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.0007 |
| 10 | SELECT * FROM 3w_banner WHERE b_positionId=2 ORDER BY RAND() LIMIT 1 | 0.0028 |
| 11 | SELECT * FROM 3w_banner WHERE b_positionId=3 ORDER BY RAND() LIMIT 1 | 0.0004 |
| 12 | SELECT * FROM 3w_banner WHERE b_positionId=3 ORDER BY RAND() LIMIT 1 | 0.0004 |
| 13 | SELECT * FROM `3w_manufacturers` WHERE `is_active`='1' AND logo IS NOT NULL AND logo<>'' ORDER BY `show_order` desc, `name` DESC | 0.0021 |
| 14 | SELECT * FROM 3w_menu_positions WHERE is_active = '1' | 0.0468 |
| 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.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 = 2 ORDER BY m.menu_order DESC | 0.0007 |
| 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.004 |
| 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.0032 |
| 22 | UPDATE 3w_manufacturers_series_models SET views_cnt=views_cnt+1 WHERE id=708 LIMIT 1 | 0.06 |
| 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=708 LIMIT 1 | 0.6783 |
| 24 | SELECT * FROM 3w_manufacturers WHERE id=41 LIMIT 1 | 0.0274 |
| 25 | SELECT * FROM 3w_manufacturers_modifications WHERE user_mod=0 AND parent_id=708 | 0.0054 |
| 26 | SELECT property_id, property_value FROM 3w_modification_values WHERE modification_id=2118 HAVING property_id IN (15,39,40) | 0.0005 |
| 27 | SELECT property_id, property_value FROM 3w_modification_values WHERE modification_id=2119 HAVING property_id IN (15,39,40) | 0.0048 |
| 28 | SELECT property_id, property_value FROM 3w_modification_values WHERE modification_id=2120 HAVING property_id IN (15,39,40) | 0.0001 |
| 29 | SELECT property_id, property_value FROM 3w_modification_values WHERE modification_id=2121 HAVING property_id IN (15,39,40) | 0.0001 |
| 30 | SELECT property_id, property_value FROM 3w_modification_values WHERE modification_id=2122 HAVING property_id IN (15,39,40) | 0.0001 |
| 31 | 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=708 AND mg.is_visible=1 ORDER BY mge.is_default DESC | 0.0001 |
| 32 | SELECT * FROM 3w_comments WHERE comment_type=5 AND object_id=708 ORDER BY id DESC | 8.1548 |
| 33 | SELECT SUM(rate) FROM 3w_comments_rating WHERE comment_id = 4089061 | 0.0003 |
| 34 | SELECT SUM(rate) FROM 3w_comments_rating WHERE comment_id = 4088444 | 0.0008 |
| 35 | SELECT SUM(rate) FROM 3w_comments_rating WHERE comment_id = 4080762 | 0.0006 |
| 36 | SELECT SUM(rate) FROM 3w_comments_rating WHERE comment_id = 4080126 | 0.0202 |
| 37 | SELECT SUM(rate) FROM 3w_comments_rating WHERE comment_id = 4077811 | 0.0433 |
| 38 | SELECT SUM(rate) FROM 3w_comments_rating WHERE comment_id = 4077191 | 0.0696 |
| 39 | SELECT SUM(rate) FROM 3w_comments_rating WHERE comment_id = 4064252 | 0.0195 |
| 40 | SELECT SUM(rate) FROM 3w_comments_rating WHERE comment_id = 4063742 | 0.0332 |
| 41 | SELECT SUM(rate) FROM 3w_comments_rating WHERE comment_id = 4062088 | 0.05 |
| 42 | SELECT SUM(rate) FROM 3w_comments_rating WHERE comment_id = 4061277 | 0.0439 |
| 43 | SELECT SUM(rate) FROM 3w_comments_rating WHERE comment_id = 4057498 | 0.002 |
| 44 | SELECT SUM(rate) FROM 3w_comments_rating WHERE comment_id = 4056028 | 0.0231 |
| 45 | SELECT SUM(rate) FROM 3w_comments_rating WHERE comment_id = 4040288 | 0.0457 |
| 46 | SELECT SUM(rate) FROM 3w_comments_rating WHERE comment_id = 3962937 | 0.0378 |
| 47 | SELECT SUM(rate) FROM 3w_comments_rating WHERE comment_id = 3962920 | 0.0508 |
| 48 | SELECT SUM(rate) FROM 3w_comments_rating WHERE comment_id = 3962905 | 0.0798 |
| 49 | SELECT SUM(rate) FROM 3w_comments_rating WHERE comment_id = 3962890 | 0.013 |
| 50 | SELECT SUM(rate) FROM 3w_comments_rating WHERE comment_id = 3962878 | 0.0231 |
| 51 | SELECT SUM(rate) FROM 3w_comments_rating WHERE comment_id = 3959334 | 0.0303 |
| 52 | SELECT SUM(rate) FROM 3w_comments_rating WHERE comment_id = 3959316 | 0.0215 |
| 53 | SELECT SUM(rate) FROM 3w_comments_rating WHERE comment_id = 3959306 | 0.0171 |
| 54 | SELECT SUM(rate) FROM 3w_comments_rating WHERE comment_id = 3959291 | 0.0059 |
| 55 | SELECT SUM(rate) FROM 3w_comments_rating WHERE comment_id = 3959285 | 0.0006 |
| 56 | SELECT SUM(rate) FROM 3w_comments_rating WHERE comment_id = 3902784 | 0.0003 |
| 57 | SELECT SUM(rate) FROM 3w_comments_rating WHERE comment_id = 3902760 | 0.0003 |
| 58 | SELECT SUM(rate) FROM 3w_comments_rating WHERE comment_id = 3902740 | 0.0003 |
| 59 | SELECT SUM(rate) FROM 3w_comments_rating WHERE comment_id = 3902727 | 0.0003 |
| 60 | SELECT SUM(rate) FROM 3w_comments_rating WHERE comment_id = 3902706 | 0.0003 |
| 61 | SELECT SUM(rate) FROM 3w_comments_rating WHERE comment_id = 3890883 | 0.0003 |
| 62 | SELECT SUM(rate) FROM 3w_comments_rating WHERE comment_id = 3890873 | 0.0003 |
| 63 | SELECT SUM(rate) FROM 3w_comments_rating WHERE comment_id = 3890860 | 0.0003 |
| 64 | SELECT SUM(rate) FROM 3w_comments_rating WHERE comment_id = 3890848 | 0.0296 |
| 65 | SELECT SUM(rate) FROM 3w_comments_rating WHERE comment_id = 3890835 | 0.0306 |
| 66 | SELECT SUM(rate) FROM 3w_comments_rating WHERE comment_id = 3886461 | 0.0177 |
| 67 | SELECT SUM(rate) FROM 3w_comments_rating WHERE comment_id = 3886444 | 0.024 |
| 68 | SELECT SUM(rate) FROM 3w_comments_rating WHERE comment_id = 3886432 | 0.037 |
| 69 | SELECT SUM(rate) FROM 3w_comments_rating WHERE comment_id = 3886422 | 0.0008 |
| 70 | SELECT SUM(rate) FROM 3w_comments_rating WHERE comment_id = 3886411 | 0.0023 |
| 71 | SELECT SUM(rate) FROM 3w_comments_rating WHERE comment_id = 3847076 | 0.0002 |
| 72 | SELECT SUM(rate) FROM 3w_comments_rating WHERE comment_id = 3847067 | 0.0003 |
| 73 | SELECT SUM(rate) FROM 3w_comments_rating WHERE comment_id = 3847063 | 0.0004 |
| 74 | SELECT SUM(rate) FROM 3w_comments_rating WHERE comment_id = 3805368 | 0.0004 |
| 75 | SELECT SUM(rate) FROM 3w_comments_rating WHERE comment_id = 3805352 | 0.0004 |
| 76 | SELECT SUM(rate) FROM 3w_comments_rating WHERE comment_id = 3805325 | 0.0003 |
| 77 | SELECT SUM(rate) FROM 3w_comments_rating WHERE comment_id = 3805309 | 0.0003 |
| 78 | SELECT SUM(rate) FROM 3w_comments_rating WHERE comment_id = 3805294 | 0.0004 |
| 79 | SELECT SUM(rate) FROM 3w_comments_rating WHERE comment_id = 3787147 | 0.0004 |
| 80 | SELECT SUM(rate) FROM 3w_comments_rating WHERE comment_id = 3787129 | 0.0004 |
| 81 | SELECT SUM(rate) FROM 3w_comments_rating WHERE comment_id = 3787106 | 0.0004 |
| 82 | SELECT SUM(rate) FROM 3w_comments_rating WHERE comment_id = 3787093 | 0.0004 |
| 83 | SELECT SUM(rate) FROM 3w_comments_rating WHERE comment_id = 3787077 | 0.0004 |
| 84 | SELECT SUM(rate) FROM 3w_comments_rating WHERE comment_id = 3773084 | 0.0003 |
| 85 | SELECT SUM(rate) FROM 3w_comments_rating WHERE comment_id = 3408125 | 0.0004 |
| 86 | SELECT SUM(rate) FROM 3w_comments_rating WHERE comment_id = 3405265 | 0.0002 |
| 87 | SELECT SUM(rate) FROM 3w_comments_rating WHERE comment_id = 3402021 | 0.0005 |
| 88 | SELECT SUM(rate) FROM 3w_comments_rating WHERE comment_id = 3309212 | 0.0004 |
| 89 | SELECT SUM(rate) FROM 3w_comments_rating WHERE comment_id = 3309201 | 0.0005 |
| 90 | SELECT SUM(rate) FROM 3w_comments_rating WHERE comment_id = 3309183 | 0.0004 |
| 91 | SELECT SUM(rate) FROM 3w_comments_rating WHERE comment_id = 3309156 | 0.0005 |
| 92 | SELECT SUM(rate) FROM 3w_comments_rating WHERE comment_id = 3309132 | 0.0005 |
| 93 | SELECT SUM(rate) FROM 3w_comments_rating WHERE comment_id = 3306488 | 0.0005 |
| 94 | SELECT SUM(rate) FROM 3w_comments_rating WHERE comment_id = 3306471 | 0.0008 |
| 95 | SELECT SUM(rate) FROM 3w_comments_rating WHERE comment_id = 3306461 | 0.0011 |
| 96 | SELECT SUM(rate) FROM 3w_comments_rating WHERE comment_id = 3306447 | 0.0009 |
| 97 | SELECT SUM(rate) FROM 3w_comments_rating WHERE comment_id = 3306431 | 0.0032 |
| 98 | SELECT SUM(rate) FROM 3w_comments_rating WHERE comment_id = 3305104 | 0.007 |
| 99 | SELECT SUM(rate) FROM 3w_comments_rating WHERE comment_id = 3305090 | 0.0102 |
| 100 | SELECT SUM(rate) FROM 3w_comments_rating WHERE comment_id = 3305068 | 0.0009 |
| 101 | SELECT SUM(rate) FROM 3w_comments_rating WHERE comment_id = 3305038 | 0.0121 |
| 102 | SELECT SUM(rate) FROM 3w_comments_rating WHERE comment_id = 3305016 | 0.0016 |
| 103 | SELECT SUM(rate) FROM 3w_comments_rating WHERE comment_id = 3302157 | 0.0007 |
| 104 | SELECT SUM(rate) FROM 3w_comments_rating WHERE comment_id = 3302137 | 0.0006 |
| 105 | SELECT SUM(rate) FROM 3w_comments_rating WHERE comment_id = 3302118 | 0.0007 |
| 106 | SELECT SUM(rate) FROM 3w_comments_rating WHERE comment_id = 3302106 | 0.0044 |
| 107 | SELECT SUM(rate) FROM 3w_comments_rating WHERE comment_id = 3302093 | 0.0024 |
| 108 | SELECT SUM(rate) FROM 3w_comments_rating WHERE comment_id = 3297753 | 0.0277 |
| 109 | SELECT SUM(rate) FROM 3w_comments_rating WHERE comment_id = 3297737 | 0.0027 |
| 110 | SELECT SUM(rate) FROM 3w_comments_rating WHERE comment_id = 3297718 | 0.0022 |
| 111 | SELECT SUM(rate) FROM 3w_comments_rating WHERE comment_id = 3297699 | 0.0026 |
| 112 | SELECT SUM(rate) FROM 3w_comments_rating WHERE comment_id = 3297674 | 0.0023 |
| 113 | SELECT SUM(rate) FROM 3w_comments_rating WHERE comment_id = 3293380 | 0.0029 |
| 114 | SELECT SUM(rate) FROM 3w_comments_rating WHERE comment_id = 3293368 | 0.0028 |
| 115 | SELECT SUM(rate) FROM 3w_comments_rating WHERE comment_id = 3293352 | 0.0061 |
| 116 | SELECT SUM(rate) FROM 3w_comments_rating WHERE comment_id = 3293329 | 0.0112 |
| 117 | SELECT SUM(rate) FROM 3w_comments_rating WHERE comment_id = 3293308 | 0.0069 |
| 118 | SELECT SUM(rate) FROM 3w_comments_rating WHERE comment_id = 3274872 | 0.017 |
| 119 | SELECT SUM(rate) FROM 3w_comments_rating WHERE comment_id = 3274863 | 0.0025 |
| 120 | SELECT SUM(rate) FROM 3w_comments_rating WHERE comment_id = 3274847 | 0.0091 |
| 121 | SELECT SUM(rate) FROM 3w_comments_rating WHERE comment_id = 3274825 | 0.0025 |
| 122 | SELECT SUM(rate) FROM 3w_comments_rating WHERE comment_id = 3274801 | 0.0214 |
| 123 | SELECT SUM(rate) FROM 3w_comments_rating WHERE comment_id = 3256967 | 0.0006 |
| 124 | SELECT SUM(rate) FROM 3w_comments_rating WHERE comment_id = 3256957 | 0.0028 |
| 125 | SELECT SUM(rate) FROM 3w_comments_rating WHERE comment_id = 3256935 | 0.0006 |
| 126 | SELECT SUM(rate) FROM 3w_comments_rating WHERE comment_id = 3256907 | 0.0196 |
| 127 | SELECT SUM(rate) FROM 3w_comments_rating WHERE comment_id = 3256879 | 0.012 |
| 128 | SELECT SUM(rate) FROM 3w_comments_rating WHERE comment_id = 3255608 | 0.0037 |
| 129 | SELECT SUM(rate) FROM 3w_comments_rating WHERE comment_id = 3255583 | 0.0005 |
| 130 | SELECT SUM(rate) FROM 3w_comments_rating WHERE comment_id = 3255555 | 0.0026 |
| 131 | SELECT SUM(rate) FROM 3w_comments_rating WHERE comment_id = 3255524 | 0.0014 |
| 132 | SELECT SUM(rate) FROM 3w_comments_rating WHERE comment_id = 3255502 | 0.0152 |
| 133 | SELECT SUM(rate) FROM 3w_comments_rating WHERE comment_id = 3252475 | 0.0128 |
| 134 | SELECT SUM(rate) FROM 3w_comments_rating WHERE comment_id = 3252452 | 0.0035 |
| 135 | SELECT SUM(rate) FROM 3w_comments_rating WHERE comment_id = 3252432 | 0.0231 |
| 136 | SELECT SUM(rate) FROM 3w_comments_rating WHERE comment_id = 3252412 | 0.0053 |
| 137 | SELECT SUM(rate) FROM 3w_comments_rating WHERE comment_id = 3252392 | 0.014 |
| 138 | SELECT SUM(rate) FROM 3w_comments_rating WHERE comment_id = 3241986 | 0.0327 |
| 139 | SELECT SUM(rate) FROM 3w_comments_rating WHERE comment_id = 3241971 | 0.0035 |
| 140 | SELECT SUM(rate) FROM 3w_comments_rating WHERE comment_id = 3241946 | 0.012 |
| 141 | SELECT SUM(rate) FROM 3w_comments_rating WHERE comment_id = 3241910 | 0.1244 |
| 142 | SELECT SUM(rate) FROM 3w_comments_rating WHERE comment_id = 3241875 | 0.1006 |
| 143 | SELECT SUM(rate) FROM 3w_comments_rating WHERE comment_id = 3238922 | 0.0228 |
| 144 | SELECT SUM(rate) FROM 3w_comments_rating WHERE comment_id = 3238897 | 0.0154 |
| 145 | SELECT SUM(rate) FROM 3w_comments_rating WHERE comment_id = 3238873 | 0.0186 |
| 146 | SELECT SUM(rate) FROM 3w_comments_rating WHERE comment_id = 3238850 | 0.1062 |
| 147 | SELECT SUM(rate) FROM 3w_comments_rating WHERE comment_id = 3238827 | 0.4403 |
| 148 | SELECT SUM(rate) FROM 3w_comments_rating WHERE comment_id = 3234728 | 0.0051 |
| 149 | SELECT SUM(rate) FROM 3w_comments_rating WHERE comment_id = 3234707 | 0.0306 |
| 150 | SQLSTATE[HY000]: General error: 2013 Lost connection to MySQL server during query | 0.0306 |
| - - | All Queries Time | 11.011 |