MySQL Debugger Results
Count SQL query Time to execute
1 SELECT config_value FROM 3w_config WHERE config_title = 'default_lang' 0.0002
2 SELECT * FROM 3w_route WHERE UPPER(route_seo_url)='BMW-5ER-E39-530D184HP-VS-ALFA_ROMEO-147-5-DOORS-1.916VJTD150HP' LIMIT 1 0.0171
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.0003
4 SELECT MAX(qa_id) FROM lele_question_and_answer 0.0003
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.0009
10 SELECT * FROM 3w_banner WHERE b_positionId=2 ORDER BY RAND() LIMIT 1 0.0007
11 SELECT * FROM 3w_banner WHERE b_positionId=3 ORDER BY RAND() LIMIT 1 0.0006
12 SELECT * FROM 3w_banner WHERE b_positionId=3 ORDER BY RAND() LIMIT 1 0.0007
13 SELECT * FROM `3w_manufacturers` WHERE `is_active`='1' AND logo IS NOT NULL AND logo<>'' ORDER BY `show_order` desc, `name` DESC 0.0018
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.0003
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.0002
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.0002
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.0002
22 SELECT id, parent_id, serie_id, name FROM 3w_manufacturers_modifications WHERE tag='5er-E39-530d184Hp' LIMIT 1 0.0002
23 SELECT parent_id FROM 3w_manufacturers_series WHERE id=670 LIMIT 1 0.0001
24 SELECT * FROM 3w_manufacturers WHERE id=86 LIMIT 1 0.0002
25 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=1456 LIMIT 1 0.0004
26 SELECT * FROM 3w_modification_categories ORDER BY order_id ASC 0.0007
27 SELECT mp.name_bg AS property_name, mv.property_value FROM 3w_modification_properties AS mp, 3w_modification_values AS mv WHERE mp.id=mv.property_id AND mp.category_id=2 AND mv.modification_id=4812 0.0001
28 SELECT mp.name_bg AS property_name, mv.property_value FROM 3w_modification_properties AS mp, 3w_modification_values AS mv WHERE mp.id=mv.property_id AND mp.category_id=7 AND mv.modification_id=4812 0.0002
29 SELECT mp.name_bg AS property_name, mv.property_value FROM 3w_modification_properties AS mp, 3w_modification_values AS mv WHERE mp.id=mv.property_id AND mp.category_id=1 AND mv.modification_id=4812 0.0002
30 SELECT mp.name_bg AS property_name, mv.property_value FROM 3w_modification_properties AS mp, 3w_modification_values AS mv WHERE mp.id=mv.property_id AND mp.category_id=3 AND mv.modification_id=4812 0.0002
31 SELECT mp.name_bg AS property_name, mv.property_value FROM 3w_modification_properties AS mp, 3w_modification_values AS mv WHERE mp.id=mv.property_id AND mp.category_id=4 AND mv.modification_id=4812 0.0001
32 SELECT mp.name_bg AS property_name, mv.property_value FROM 3w_modification_properties AS mp, 3w_modification_values AS mv WHERE mp.id=mv.property_id AND mp.category_id=5 AND mv.modification_id=4812 0.0001
33 SELECT mp.name_bg AS property_name, mv.property_value FROM 3w_modification_properties AS mp, 3w_modification_values AS mv WHERE mp.id=mv.property_id AND mp.category_id=6 AND mv.modification_id=4812 0.0002
34 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=1456 AND mg.is_visible=1 ORDER BY mge.is_default DESC LIMIT 1 0.0001
35 SELECT image_path FROM 3w_manufacturers_galleries WHERE model_id=1456 LIMIT 1 0.0001
36 SELECT msm.id, msm.name FROM 3w_manufacturers_series_models AS msm, 3w_manufacturers_series AS ms WHERE ms.id=msm.parent_id AND ms.parent_id=86 ORDER BY name ASC 0.0017
37 SELECT * FROM 3w_manufacturers_modifications WHERE user_mod=0 AND parent_id=1456 0.0028
38 SELECT id, parent_id, serie_id, name FROM 3w_manufacturers_modifications WHERE tag='147-5-doors-1.916VJTD150Hp' LIMIT 1 0.0012
39 SELECT parent_id FROM 3w_manufacturers_series WHERE id=90 LIMIT 1 0.0002
40 SELECT * FROM 3w_manufacturers WHERE id=11 LIMIT 1 0.0002
41 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=148 LIMIT 1 0.0004
42 SELECT * FROM 3w_modification_categories ORDER BY order_id ASC 0.0004
43 SELECT mp.name_bg AS property_name, mv.property_value FROM 3w_modification_properties AS mp, 3w_modification_values AS mv WHERE mp.id=mv.property_id AND mp.category_id=2 AND mv.modification_id=369 0.0009
44 SELECT mp.name_bg AS property_name, mv.property_value FROM 3w_modification_properties AS mp, 3w_modification_values AS mv WHERE mp.id=mv.property_id AND mp.category_id=7 AND mv.modification_id=369 0.0006
45 SELECT mp.name_bg AS property_name, mv.property_value FROM 3w_modification_properties AS mp, 3w_modification_values AS mv WHERE mp.id=mv.property_id AND mp.category_id=1 AND mv.modification_id=369 0.0005
46 SELECT mp.name_bg AS property_name, mv.property_value FROM 3w_modification_properties AS mp, 3w_modification_values AS mv WHERE mp.id=mv.property_id AND mp.category_id=3 AND mv.modification_id=369 0.0038
47 SELECT mp.name_bg AS property_name, mv.property_value FROM 3w_modification_properties AS mp, 3w_modification_values AS mv WHERE mp.id=mv.property_id AND mp.category_id=4 AND mv.modification_id=369 0.0006
48 SELECT mp.name_bg AS property_name, mv.property_value FROM 3w_modification_properties AS mp, 3w_modification_values AS mv WHERE mp.id=mv.property_id AND mp.category_id=5 AND mv.modification_id=369 0.0005
49 SELECT mp.name_bg AS property_name, mv.property_value FROM 3w_modification_properties AS mp, 3w_modification_values AS mv WHERE mp.id=mv.property_id AND mp.category_id=6 AND mv.modification_id=369 0.0005
50 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=148 AND mg.is_visible=1 ORDER BY mge.is_default DESC LIMIT 1 0.0618
51 SQLSTATE[HY000]: General error: 3 Error writing file '/tmp/MYa4tOgs' (Errcode: 28) 0.0618
- - All Queries Time 0.1653


A database error has occured. Please, try again later!