MySQL Debugger Results
Count SQL query Time to execute
1 SELECT * FROM 3w_rewrites WHERE old_url = 'akumulatoren-udaren-vintovert-18-v-xr-liion-dewalt-dcd795d2' LIMIT 1 0,0002
2 SELECT * FROM 3w_config 0,0007
3 SELECT config_value FROM 3w_config WHERE config_title = 'default_lang' 0,0001
4 SELECT * FROM 3w_route WHERE UPPER(route_seo_url)='AKUMULATOREN-UDAREN-VINTOVERT-18-V-XR-LIION-DEWALT-DCD795D2' LIMIT 1 0,0303
5 SELECT * FROM 3w_lang ORDER BY lang_id DESC 0,0001
6 SELECT m.*, mp.mp_location FROM 3w_menus m LEFT JOIN 3w_menu_positions mp on mp.mp_id = m.menu_position WHERE m.menu_isactive=1 ORDER BY m.menu_position ASC, m.menu_order ASC, m.menu_id DESC 0,0003
7 SELECT * FROM 3w_cms_blocks WHERE block_title = 'contact_us' AND block_langId = '16' 0,0001
8 SELECT * FROM 3w_meta WHERE meta_langId = '16' 0,0001
9 SELECT config_value FROM 3w_config WHERE config_title = 'site_logo' 0,0001
10 SELECT pc1.category_id, pc1.category_parent_id, pc1.category_name, pc0.category_name category_parent_name, pc1.category_seo_url, pc1.category_seo_name, pc1.category_description, pc1.category_description_plain, pc1.category_description_bottom, pc1.category_headertext, pc1.category_footertext, pc1.category_picture, pc1.category_meta_description, pc1.category_meta_keywords, pc1.category_search_keywords, (select count(distinct p.product_id) from 3w_products p LEFT JOIN 3w_products_cat_rel pcr ON pcr.product_id = p.product_id where pcr.category_id = pc1.category_id AND p.deleted = 0 AND p.product_shown) counts /* count(distinct pcr.product_id) counts */ FROM 3w_product_categories pc1 LEFT JOIN 3w_product_categories pc0 ON pc0.category_id = pc1.category_parent_id ORDER BY pc1.category_name ASC LIMIT 0, 99999407370 0,0087
11 SELECT GROUP_CONCAT(category_id) FROM 3w_product_categories WHERE category_seo_url LIKE '%drugi%' 0,0001
12 SELECT pc1.category_id, pc1.category_parent_id, pc1.category_name, pc0.category_name category_parent_name, pc1.category_seo_url, pc1.category_seo_name, pc1.category_description, pc1.category_description_plain, pc1.category_description_bottom, pc1.category_headertext, pc1.category_footertext, pc1.category_picture, pc1.category_meta_description, pc1.category_meta_keywords, pc1.category_search_keywords, (select count(distinct p.product_id) from 3w_products p LEFT JOIN 3w_products_cat_rel pcr ON pcr.product_id = p.product_id where pcr.category_id = pc1.category_id AND p.deleted = 0 AND p.product_shown) counts /* count(distinct pcr.product_id) counts */ FROM 3w_product_categories pc1 LEFT JOIN 3w_product_categories pc0 ON pc0.category_id = pc1.category_parent_id ORDER BY pc1.category_name ASC LIMIT 0, 99999407370 0,0085
13 SELECT GROUP_CONCAT(category_id) FROM 3w_product_categories WHERE category_seo_url LIKE '%drugi%' 0,0001
14 SELECT m.manufacturer_id, m.manufacturer_name, m.manufacturer_seo_url, m.manufacturer_site, m.manufacturer_seo_name, m.manufacturer_description, m.manufacturer_description_plain, m.manufacturer_description_bottom, m.manufacturer_headertext, m.manufacturer_footertext, m.manufacturer_meta_keywords, (SELECT mg.image_filename FROM 3w_manufacturers_gallery mg WHERE mg.manufacturer_id = m.manufacturer_id LIMIT 1) image_filename, count(distinct p.product_id) counts FROM 3w_manufacturers m /* LEFT JOIN 3w_manufacturers_gallery mg on mg.manufacturer_id = m.manufacturer_id */ LEFT JOIN 3w_products p on p.product_manufacturer_id = m.manufacturer_id WHERE m.is_active = '1' AND p.product_id IS NOT NULL GROUP BY m.manufacturer_id ORDER BY manufacturer_name ASC 0,0035
15 SELECT pi.id, pi.item_seo_name, pi.item_name, p.property_id, p.property_seo_name, p.property_name FROM 3w_property_items pi LEFT JOIN 3w_properties p on p.property_id = pi.property_id WHERE p.is_active = 1 ORDER BY p.property_name ASC, pi.item_order ASC, pi.item_name ASC 0,0054
16 SELECT MIN(product_price_sell) AS price FROM 3w_products 0,0001
17 SELECT MAX(product_price_sell) AS price FROM 3w_products 0,0001
18 SELECT * FROM 3w_cms_blocks WHERE block_title = 'copyright' AND block_langId = '16' 0,0001
19 SELECT * FROM 3w_cms_blocks WHERE block_title = 'footer_block' 0,0001
20 SELECT b.* FROM 3w_banner b LEFT JOIN 3w_banner_position bp ON b.b_positionId = bp.bp_id WHERE b.b_isactive = '1' AND b.b_positionId = '24' AND bp.bp_isactive = '1' AND b.b_datePublish < NOW() ORDER BY (RAND() * (100-b_priority)) LIMIT 1 0,0004
21 SELECT COUNT(*) FROM 3w_products WHERE deleted = 0 0,0001
22 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,0001
23 SELECT p.*, p.product_name translated_name, po.origin_name, p.product_sale_count, p.product_onsale , (SELECT image_filename FROM 3w_products_gallery pg WHERE pg.id = p.main_image LIMIT 1) image_filename , GROUP_CONCAT(pcr.category_id) categoryIds FROM 3w_products p LEFT JOIN 3w_product_origins po ON po.origin_id = p.product_origin_id INNER JOIN 3w_products_cat_rel pcr ON pcr.product_id = p.product_id INNER JOIN 3w_product_categories pc ON pc.category_id = pcr.category_id WHERE ( p.product_id = "24594" ) AND ( p.deleted = '0' ) LIMIT 0, 1 0,0025
24 SELECT pi.id, pi.item_seo_name, pi.item_name, pp.property_id, pp.property_seo_name, pp.property_name, pp.*, count(DISTINCT p.product_id) products FROM 3w_property_items pi LEFT JOIN 3w_properties pp ON pp.property_id = pi.property_id INNER JOIN 3w_property_product_items ppi ON ppi.item_id = pi.id INNER JOIN 3w_products p ON p.product_id = ppi.product_id INNER JOIN 3w_products_cat_rel pcr ON pcr.product_id = p.product_id AND pcr.category_id = '1264' WHERE ( pcr.category_id = "1264" ) AND ( p.deleted = '0' ) AND ( p.product_shown ) GROUP BY pi.id ORDER BY pp.property_order ASC, pi.item_order ASC, pi.item_name ASC LIMIT 0, 99999407370 0,0032
25 SELECT pc.category_id, pc.category_parent_id, pc.category_name, pc.category_picture FROM 3w_product_categories AS pc, 3w_products_cat_rel AS cr WHERE pc.category_id=cr.category_id AND cr.product_id=24594 LIMIT 1 0,0016
26 select id, image_filename FROM 3w_products_gallery where product_id = '24594' ORDER BY show_order ASC 0,0005
27 SELECT pi.id, pi.item_seo_name, pi.item_name, pp.property_id, pp.property_seo_name, pp.property_name, pp.*, count(DISTINCT p.product_id) products FROM 3w_property_items pi LEFT JOIN 3w_properties pp ON pp.property_id = pi.property_id INNER JOIN 3w_property_product_items ppi ON ppi.item_id = pi.id INNER JOIN 3w_products p ON p.product_id = ppi.product_id WHERE ( p.product_id = "24594" ) AND ( p.deleted = '0' ) GROUP BY pi.id ORDER BY pp.property_order ASC, pi.item_order ASC, pi.item_name ASC LIMIT 0, 99999407370 0,0006
28 SELECT * FROM 3w_product_reviews WHERE product_id='24594' AND review_status<2 ORDER BY id DESC 0,0002
29 SELECT AVG(cm_rating) AS rating_sum FROM 3w_product_comments WHERE product_id = '24594' AND cm_isactive = '1' 0,0002
30 SELECT COUNT(cm_id) FROM 3w_product_comments WHERE product_id = '24594' AND cm_isactive = '1' 0,0002
31 SELECT pc.*, u.user_username, u.user_avatar FROM 3w_product_comments pc LEFT JOIN 3w_users u ON (u.user_id = pc.user_id) WHERE product_id='24594' AND cm_isactive = 1 ORDER BY cm_date ASC LIMIT 5 0,0003
32 SELECT COUNT(cm_id) FROM 3w_product_comments WHERE product_id='24594' AND cm_isactive = 1 ORDER BY cm_date ASC 0,0002
33 SELECT product_id FROM 3w_products WHERE product_id=24594 AND deleted = 0 0,0013
34 UPDATE 3w_products SET product_views = product_views + 1 WHERE product_id = '24594' 0,0019
35 INSERT INTO 3w_products_recet_viewed (product_id, viewed_time) VALUES ('24594', '2017-03-26 23:56:58') 0,0002
36 SELECT GROUP_CONCAT(id) FROM ( SELECT v.id FROM 3w_products_recet_viewed v ORDER BY v.id DESC LIMIT 15) a 0,0003
37 DELETE FROM 3w_products_recet_viewed WHERE id not in (8030150,8030149,8030148,8030147,8030146,8030145,8030144,8030143,8030142,8030141,8030140,8030139,8030138,8030137,8030136) 0,0002
38 SELECT * FROM `3w_products_price` WHERE product_id = '24594' 0,0002
39 SELECT MIN(product_price_sell) AS minPrice, MAX(product_price_sell) AS maxPrice FROM 3w_products_price WHERE product_id = :id 0,0003
40 SELECT MIN(product_price_promo) AS minPrice, MAX(product_price_promo) AS maxPrice FROM 3w_products_price WHERE product_id = :id AND product_price_promo != 0.00 AND (product_price_promo_expire_date > NOW() OR product_price_promo_expire_date LIKE '0000-00-00 00:00:00') 0,0003
41 SELECT m.manufacturer_id, m.manufacturer_name, m.manufacturer_seo_url, count(DISTINCT p.product_id) products FROM 3w_manufacturers m INNER JOIN 3w_products p ON p.product_manufacturer_id = m.manufacturer_id INNER JOIN 3w_products_cat_rel pcr ON pcr.product_id = p.product_id AND pcr.category_id = '1264' WHERE ( pcr.category_id = "1264" ) AND ( p.product_manufacturer_id <> "13" ) AND ( p.deleted = '0' ) AND ( p.product_shown ) GROUP BY m.manufacturer_id ORDER BY products DESC, m.manufacturer_name ASC LIMIT 0, 3 0,0026
42 SELECT p.product_id, p.product_name, p.product_second_name, p.product_name translated_name, p.product_seo_url, p.product_price_sell, p.product_price_promo, p.product_technical_data, p.product_exquisite, p.product_notinstock, p.product_price_promo_expire_date, p.product_description, p.product_code, m.manufacturer_name, m.manufacturer_seo_url, p.product_file, p.product_sale_count, p.product_onsale, CONCAT( '/public/upload/manufacturers/', p.product_manufacturer_id,'/thumb80/', (SELECT mg.image_filename FROM 3w_manufacturers_gallery mg WHERE mg.manufacturer_id = p.product_manufacturer_id LIMIT 1 ) ) manufacturer_image_location /*(SELECT m.manufacturer_name FROM 3w_manufacturers m WHERE m.manufacturer_id = p.product_manufacturer_id LIMIT 1 ) manufacturer_name,*/ , (SELECT image_filename FROM 3w_products_gallery pg WHERE pg.id = p.main_image LIMIT 1) image_filename FROM 3w_products p LEFT JOIN 3w_manufacturers m ON m.manufacturer_id = p.product_manufacturer_id INNER JOIN 3w_products_cat_rel pcr ON pcr.product_id = p.product_id AND pcr.category_id = '1264' WHERE ( pcr.category_id = "1264" ) AND ( p.product_id <> "24594" ) AND ( p.product_notinstock = '0' ) AND ( p.deleted = '0' ) AND ( p.product_shown ) ORDER BY RAND() LIMIT 0, 4 0,0093
43 SQLSTATE[HY000]: General error: 1030 Got error -1 from storage engine 0,0093
- - All Queries Time 0,0947