MySQL Debugger Results
Count SQL query Time to execute
1 SELECT * FROM 3w_rewrites WHERE old_url = 'ygloshlaif-rtr-max-600-w-115-mm' LIMIT 1 0,0003
2 SELECT * FROM 3w_config 0,0001
3 SELECT config_value FROM 3w_config WHERE config_title = 'default_lang' 0,0002
4 SELECT * FROM 3w_route WHERE UPPER(route_seo_url)='YGLOSHLAIF-RTR-MAX-600-W-115-MM' LIMIT 1 0,0306
5 SELECT * FROM 3w_lang ORDER BY lang_id DESC 0,0002
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,0004
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,7301
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,0087
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,132
15 SQLSTATE[HY000]: General error: 1030 Got error -1 from storage engine 0,1321
- - All Queries Time 1,0352