| MySQL Debugger Results | ||
| Count | SQL query | Time to execute |
| 1 | SELECT config_value FROM 3w_config WHERE config_title = 'default_lang' | 0.0607 |
| 2 | SELECT * FROM 3w_route WHERE UPPER(route_seo_url)='E-KLASSE-CABRIO-A124' LIMIT 1 | 0.0209 |
| 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.0218 |
| 4 | SELECT MAX(qa_id) FROM lele_question_and_answer | 0.0185 |
| 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.0219 |
| 9 | SELECT * FROM 3w_banner WHERE b_positionId=1 ORDER BY RAND() LIMIT 1 | 0.0575 |
| 10 | SELECT * FROM 3w_banner WHERE b_positionId=2 ORDER BY RAND() LIMIT 1 | 0.0059 |
| 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.0026 |
| 13 | SELECT * FROM `3w_manufacturers` WHERE `is_active`='1' AND logo IS NOT NULL AND logo<>'' ORDER BY `show_order` desc, `name` DESC | 0.002 |
| 14 | SELECT * FROM 3w_menu_positions WHERE is_active = '1' | 0.0245 |
| 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.0005 |
| 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.0017 |
| 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.0001 |
| 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=2001 LIMIT 1 | 0.0088 |
| 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=2001 LIMIT 1 | 0.0132 |
| 24 | SELECT * FROM 3w_manufacturers WHERE id=133 LIMIT 1 | 0.0126 |
| 25 | SELECT * FROM 3w_manufacturers_modifications WHERE user_mod=0 AND parent_id=2001 | 0.0007 |
| 26 | SELECT property_id, property_value FROM 3w_modification_values WHERE modification_id=6541 HAVING property_id IN (15,39,40) | 0.0142 |
| 27 | SELECT property_id, property_value FROM 3w_modification_values WHERE modification_id=6542 HAVING property_id IN (15,39,40) | 0.0007 |
| 28 | SELECT property_id, property_value FROM 3w_modification_values WHERE modification_id=6543 HAVING property_id IN (15,39,40) | 0.0003 |
| 29 | 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=2001 AND mg.is_visible=1 ORDER BY mge.is_default DESC | 1.3259 |
| 30 | SELECT * FROM 3w_comments WHERE comment_type=5 AND object_id=2001 ORDER BY id DESC | 7.4911 |
| 31 | SELECT SUM(rate) FROM 3w_comments_rating WHERE comment_id = 4087664 | 0.0047 |
| 32 | SELECT SUM(rate) FROM 3w_comments_rating WHERE comment_id = 4079344 | 0.0048 |
| 33 | SELECT SUM(rate) FROM 3w_comments_rating WHERE comment_id = 4076544 | 0.0017 |
| 34 | SELECT SUM(rate) FROM 3w_comments_rating WHERE comment_id = 4061041 | 0.0564 |
| 35 | SELECT SUM(rate) FROM 3w_comments_rating WHERE comment_id = 4058425 | 0.0043 |
| 36 | SELECT SUM(rate) FROM 3w_comments_rating WHERE comment_id = 4058126 | 0.01 |
| 37 | SELECT SUM(rate) FROM 3w_comments_rating WHERE comment_id = 4040679 | 0.0072 |
| 38 | SELECT SUM(rate) FROM 3w_comments_rating WHERE comment_id = 4038953 | 0.0998 |
| 39 | SELECT SUM(rate) FROM 3w_comments_rating WHERE comment_id = 3975879 | 0.0227 |
| 40 | SELECT SUM(rate) FROM 3w_comments_rating WHERE comment_id = 3975868 | 0.0378 |
| 41 | SELECT SUM(rate) FROM 3w_comments_rating WHERE comment_id = 3975857 | 0.014 |
| 42 | SELECT SUM(rate) FROM 3w_comments_rating WHERE comment_id = 3975851 | 0.0084 |
| 43 | SELECT SUM(rate) FROM 3w_comments_rating WHERE comment_id = 3975837 | 0.0031 |
| 44 | SELECT SUM(rate) FROM 3w_comments_rating WHERE comment_id = 3971929 | 0.0095 |
| 45 | SELECT SUM(rate) FROM 3w_comments_rating WHERE comment_id = 3971914 | 0.0002 |
| 46 | SELECT SUM(rate) FROM 3w_comments_rating WHERE comment_id = 3971903 | 0.0002 |
| 47 | SELECT SUM(rate) FROM 3w_comments_rating WHERE comment_id = 3971890 | 0.0002 |
| 48 | SELECT SUM(rate) FROM 3w_comments_rating WHERE comment_id = 3971877 | 0.0061 |
| 49 | SELECT SUM(rate) FROM 3w_comments_rating WHERE comment_id = 3967645 | 0.0003 |
| 50 | SELECT SUM(rate) FROM 3w_comments_rating WHERE comment_id = 3967637 | 0.0043 |
| 51 | SELECT SUM(rate) FROM 3w_comments_rating WHERE comment_id = 3967624 | 0.0002 |
| 52 | SELECT SUM(rate) FROM 3w_comments_rating WHERE comment_id = 3967612 | 0.0002 |
| 53 | SELECT SUM(rate) FROM 3w_comments_rating WHERE comment_id = 3967600 | 0.0025 |
| 54 | SELECT SUM(rate) FROM 3w_comments_rating WHERE comment_id = 3956849 | 0.0486 |
| 55 | SELECT SUM(rate) FROM 3w_comments_rating WHERE comment_id = 3956836 | 0.0046 |
| 56 | SELECT SUM(rate) FROM 3w_comments_rating WHERE comment_id = 3956822 | 0.0009 |
| 57 | SELECT SUM(rate) FROM 3w_comments_rating WHERE comment_id = 3956806 | 0.001 |
| 58 | SELECT SUM(rate) FROM 3w_comments_rating WHERE comment_id = 3956792 | 0.0088 |
| 59 | SELECT SUM(rate) FROM 3w_comments_rating WHERE comment_id = 3953110 | 0.0002 |
| 60 | SELECT SUM(rate) FROM 3w_comments_rating WHERE comment_id = 3953100 | 0.0002 |
| 61 | SELECT SUM(rate) FROM 3w_comments_rating WHERE comment_id = 3953090 | 0.0002 |
| 62 | SELECT SUM(rate) FROM 3w_comments_rating WHERE comment_id = 3953080 | 0.0504 |
| 63 | SELECT SUM(rate) FROM 3w_comments_rating WHERE comment_id = 3953068 | 0.0198 |
| 64 | SELECT SUM(rate) FROM 3w_comments_rating WHERE comment_id = 3949155 | 0.0209 |
| 65 | SELECT SUM(rate) FROM 3w_comments_rating WHERE comment_id = 3949138 | 0.0007 |
| 66 | SELECT SUM(rate) FROM 3w_comments_rating WHERE comment_id = 3949125 | 0.0012 |
| 67 | SELECT SUM(rate) FROM 3w_comments_rating WHERE comment_id = 3949117 | 0.0003 |
| 68 | SELECT SUM(rate) FROM 3w_comments_rating WHERE comment_id = 3949108 | 0.0006 |
| 69 | SELECT SUM(rate) FROM 3w_comments_rating WHERE comment_id = 3945076 | 0.0105 |
| 70 | SELECT SUM(rate) FROM 3w_comments_rating WHERE comment_id = 3945069 | 0.0007 |
| 71 | SELECT SUM(rate) FROM 3w_comments_rating WHERE comment_id = 3945056 | 0.0011 |
| 72 | SELECT SUM(rate) FROM 3w_comments_rating WHERE comment_id = 3945036 | 0.0002 |
| 73 | SELECT SUM(rate) FROM 3w_comments_rating WHERE comment_id = 3945024 | 0.0002 |
| 74 | SELECT SUM(rate) FROM 3w_comments_rating WHERE comment_id = 3933459 | 0.0002 |
| 75 | SELECT SUM(rate) FROM 3w_comments_rating WHERE comment_id = 3933447 | 0.0005 |
| 76 | SELECT SUM(rate) FROM 3w_comments_rating WHERE comment_id = 3933435 | 0.0006 |
| 77 | SELECT SUM(rate) FROM 3w_comments_rating WHERE comment_id = 3933422 | 0.0004 |
| 78 | SELECT SUM(rate) FROM 3w_comments_rating WHERE comment_id = 3933407 | 0.0019 |
| 79 | SELECT SUM(rate) FROM 3w_comments_rating WHERE comment_id = 3929503 | 0.0002 |
| 80 | SELECT SUM(rate) FROM 3w_comments_rating WHERE comment_id = 3929492 | 0.0002 |
| 81 | SELECT SUM(rate) FROM 3w_comments_rating WHERE comment_id = 3929482 | 0.0007 |
| 82 | SELECT SUM(rate) FROM 3w_comments_rating WHERE comment_id = 3929468 | 0.0047 |
| 83 | SELECT SUM(rate) FROM 3w_comments_rating WHERE comment_id = 3929457 | 0.002 |
| 84 | SELECT SUM(rate) FROM 3w_comments_rating WHERE comment_id = 3925438 | 0.0408 |
| 85 | SELECT SUM(rate) FROM 3w_comments_rating WHERE comment_id = 3925426 | 0.0005 |
| 86 | SELECT SUM(rate) FROM 3w_comments_rating WHERE comment_id = 3925409 | 0.0002 |
| 87 | SELECT SUM(rate) FROM 3w_comments_rating WHERE comment_id = 3925391 | 0.0002 |
| 88 | SELECT SUM(rate) FROM 3w_comments_rating WHERE comment_id = 3925378 | 0.0002 |
| 89 | SELECT SUM(rate) FROM 3w_comments_rating WHERE comment_id = 3921112 | 0.0173 |
| 90 | SELECT SUM(rate) FROM 3w_comments_rating WHERE comment_id = 3921098 | 0.0038 |
| 91 | SELECT SUM(rate) FROM 3w_comments_rating WHERE comment_id = 3921087 | 0.0208 |
| 92 | SELECT SUM(rate) FROM 3w_comments_rating WHERE comment_id = 3921077 | 0.0015 |
| 93 | SELECT SUM(rate) FROM 3w_comments_rating WHERE comment_id = 3921065 | 0.0043 |
| 94 | SELECT SUM(rate) FROM 3w_comments_rating WHERE comment_id = 3916952 | 0.0242 |
| 95 | SELECT SUM(rate) FROM 3w_comments_rating WHERE comment_id = 3916931 | 0.0292 |
| 96 | SELECT SUM(rate) FROM 3w_comments_rating WHERE comment_id = 3916911 | 0.0028 |
| 97 | SELECT SUM(rate) FROM 3w_comments_rating WHERE comment_id = 3916893 | 0.0093 |
| 98 | SELECT SUM(rate) FROM 3w_comments_rating WHERE comment_id = 3916876 | 0.0086 |
| 99 | SELECT SUM(rate) FROM 3w_comments_rating WHERE comment_id = 3907775 | 0.0266 |
| 100 | SELECT SUM(rate) FROM 3w_comments_rating WHERE comment_id = 3907764 | 0.0199 |
| 101 | SELECT SUM(rate) FROM 3w_comments_rating WHERE comment_id = 3907749 | 0.0018 |
| 102 | SELECT SUM(rate) FROM 3w_comments_rating WHERE comment_id = 3907734 | 0.0032 |
| 103 | SELECT SUM(rate) FROM 3w_comments_rating WHERE comment_id = 3907717 | 0.037 |
| 104 | SELECT SUM(rate) FROM 3w_comments_rating WHERE comment_id = 3903708 | 0.0088 |
| 105 | SELECT SUM(rate) FROM 3w_comments_rating WHERE comment_id = 3903691 | 0.0262 |
| 106 | SELECT SUM(rate) FROM 3w_comments_rating WHERE comment_id = 3903666 | 0.0009 |
| 107 | SELECT SUM(rate) FROM 3w_comments_rating WHERE comment_id = 3903640 | 0.0025 |
| 108 | SELECT SUM(rate) FROM 3w_comments_rating WHERE comment_id = 3903624 | 0.0002 |
| 109 | SELECT SUM(rate) FROM 3w_comments_rating WHERE comment_id = 3900461 | 0.0002 |
| 110 | SELECT SUM(rate) FROM 3w_comments_rating WHERE comment_id = 3900443 | 0.0071 |
| 111 | SELECT SUM(rate) FROM 3w_comments_rating WHERE comment_id = 3900425 | 0.0003 |
| 112 | SELECT SUM(rate) FROM 3w_comments_rating WHERE comment_id = 3900400 | 0.0156 |
| 113 | SELECT SUM(rate) FROM 3w_comments_rating WHERE comment_id = 3900379 | 0.0274 |
| 114 | SELECT SUM(rate) FROM 3w_comments_rating WHERE comment_id = 3887408 | 0.0495 |
| 115 | SELECT SUM(rate) FROM 3w_comments_rating WHERE comment_id = 3887399 | 0.0109 |
| 116 | SELECT SUM(rate) FROM 3w_comments_rating WHERE comment_id = 3887390 | 0.0027 |
| 117 | SELECT SUM(rate) FROM 3w_comments_rating WHERE comment_id = 3887378 | 0.0017 |
| 118 | SELECT SUM(rate) FROM 3w_comments_rating WHERE comment_id = 3887368 | 0.0003 |
| 119 | SELECT SUM(rate) FROM 3w_comments_rating WHERE comment_id = 3878610 | 0.0016 |
| 120 | SELECT SUM(rate) FROM 3w_comments_rating WHERE comment_id = 3878593 | 0.001 |
| 121 | SELECT SUM(rate) FROM 3w_comments_rating WHERE comment_id = 3878572 | 0.0146 |
| 122 | SELECT SUM(rate) FROM 3w_comments_rating WHERE comment_id = 3878554 | 0.0037 |
| 123 | SELECT SUM(rate) FROM 3w_comments_rating WHERE comment_id = 3878534 | 0.0298 |
| 124 | SELECT SUM(rate) FROM 3w_comments_rating WHERE comment_id = 3855500 | 0.0114 |
| 125 | SELECT SUM(rate) FROM 3w_comments_rating WHERE comment_id = 3855490 | 0.0179 |
| 126 | SELECT SUM(rate) FROM 3w_comments_rating WHERE comment_id = 3855478 | 0.0091 |
| 127 | SELECT SUM(rate) FROM 3w_comments_rating WHERE comment_id = 3855463 | 0.0065 |
| 128 | SELECT SUM(rate) FROM 3w_comments_rating WHERE comment_id = 3855446 | 0.0079 |
| 129 | SELECT SUM(rate) FROM 3w_comments_rating WHERE comment_id = 3847709 | 0.0074 |
| 130 | SELECT SUM(rate) FROM 3w_comments_rating WHERE comment_id = 3847706 | 0.0067 |
| 131 | SELECT SUM(rate) FROM 3w_comments_rating WHERE comment_id = 3801526 | 0.0214 |
| 132 | SELECT SUM(rate) FROM 3w_comments_rating WHERE comment_id = 3801511 | 0.0124 |
| 133 | SELECT SUM(rate) FROM 3w_comments_rating WHERE comment_id = 3801499 | 0.0088 |
| 134 | SELECT SUM(rate) FROM 3w_comments_rating WHERE comment_id = 3801484 | 0.0015 |
| 135 | SELECT SUM(rate) FROM 3w_comments_rating WHERE comment_id = 3801472 | 0.0017 |
| 136 | SELECT SUM(rate) FROM 3w_comments_rating WHERE comment_id = 3796636 | 0.0002 |
| 137 | SELECT SUM(rate) FROM 3w_comments_rating WHERE comment_id = 3796617 | 0.0311 |
| 138 | SELECT SUM(rate) FROM 3w_comments_rating WHERE comment_id = 3796597 | 0.0325 |
| 139 | SELECT SUM(rate) FROM 3w_comments_rating WHERE comment_id = 3796580 | 0.011 |
| 140 | SELECT SUM(rate) FROM 3w_comments_rating WHERE comment_id = 3796568 | 0.0533 |
| 141 | SELECT SUM(rate) FROM 3w_comments_rating WHERE comment_id = 3773877 | 0.0045 |
| 142 | SELECT SUM(rate) FROM 3w_comments_rating WHERE comment_id = 3405285 | 0.0475 |
| 143 | SELECT SUM(rate) FROM 3w_comments_rating WHERE comment_id = 3401262 | 0.0091 |
| 144 | SELECT SUM(rate) FROM 3w_comments_rating WHERE comment_id = 3301384 | 0.0259 |
| 145 | SELECT SUM(rate) FROM 3w_comments_rating WHERE comment_id = 3301366 | 0.0239 |
| 146 | SELECT SUM(rate) FROM 3w_comments_rating WHERE comment_id = 3301340 | 0.0162 |
| 147 | SELECT SUM(rate) FROM 3w_comments_rating WHERE comment_id = 3301318 | 0.0056 |
| 148 | SELECT SUM(rate) FROM 3w_comments_rating WHERE comment_id = 3301296 | 0.0241 |
| 149 | SELECT SUM(rate) FROM 3w_comments_rating WHERE comment_id = 3287379 | 0.0005 |
| 150 | SELECT SUM(rate) FROM 3w_comments_rating WHERE comment_id = 3287357 | 0.0004 |
| 151 | SELECT SUM(rate) FROM 3w_comments_rating WHERE comment_id = 3287328 | 0.0002 |
| 152 | SELECT SUM(rate) FROM 3w_comments_rating WHERE comment_id = 3287302 | 0.0003 |
| 153 | SELECT SUM(rate) FROM 3w_comments_rating WHERE comment_id = 3287278 | 0.0033 |
| 154 | SELECT SUM(rate) FROM 3w_comments_rating WHERE comment_id = 3283085 | 0.0075 |
| 155 | SELECT SUM(rate) FROM 3w_comments_rating WHERE comment_id = 3283056 | 0.0005 |
| 156 | SELECT SUM(rate) FROM 3w_comments_rating WHERE comment_id = 3283030 | 0.0029 |
| 157 | SELECT SUM(rate) FROM 3w_comments_rating WHERE comment_id = 3283005 | 0.0029 |
| 158 | SQLSTATE[HY000]: General error: 2013 Lost connection to MySQL server during query | 0.0029 |
| - - | All Queries Time | 10.4645 |