问：http://www.meihuiw.com 网站访问 响应时间一直很慢 相同的程序放在万网阿里云服务器 一切正常 速度也很快 为什么在西部数码服务器上 响应时间 访问时间 一直很慢 麻烦帮助排除一下 非常感谢
下图为我阿里云服务器配置 麻烦帮助找一下原因呢 非常感谢
,服务器 访问一直很慢
答：您好，测试静态内容打开很快，网站访问慢主要是mysql执行慢
SELECT g.goods_id,g.click_count,g.goods_brief,g.keywords, g.goods_name, g.shop_price, g.goods_thumb, SUM(og.goods_number) as goods_number FROM `meihuiw`.`fds_goods` AS g, `meihuiw`.`fds_order_info` AS o, `meihuiw`.`fds_order_goods` AS og WHERE g.is_on_sale = 1 AND g.is_alone_sale = 1 AND g.is_delete = 0 AND (g.cat_id IN ('2','1','33','53','6','3','37','38','39','40','4','41','42','43','44','28','46','5','29','30','59','60','16','18','19','20','21','61','62','63','22','25','31','32','50','51','58','52','54','55','56','57','65','64','66') OR g.goods_id IN ('145','146','485','493','494','519','928','932','937','938','1686','1702','1703','1705','1707','1710','1888','1889','1890','1891','1892','1893','1894','1895','1896','1897','1898','1899','1900','1901','1902','1903','1904','1905','1906','1907','1908','1909','1910','1911','1912','1913','1914','1915','1916','1917','1918','1919','1920','1921','1922','1923','1924','1925','1926','1927','1928','1929','1930','1933','1934','1935','1936','1939','1940','1943','1944','1945','1946','1947','1948','1949','1950','1951','1983') ) AND g.goods_number > 0 AND og.order_id = o.order_id AND og.goods_id = g.goods_id AND (o.order_status = '1' OR o.order_status = '5') AND (o.pay_status = '2' OR o.pay_status = '1') AND (o.shipping_status = '1' OR o.shipping_status = '2') GROUP BY g.goods_id ORDER BY goods_number DESC, g.goods_id DESC LIMIT 12
SELECT g.goods_id,g.click_count,g.goods_brief,g.keywords, g.goods_name, g.shop_price, g.goods_thumb, SUM(og.goods_number) as goods_number FROM `meihuiw`.`fds_goods` AS g, `meihuiw`.`fds_order_info` AS o, `meihuiw`.`fds_order_goods` AS og WHERE g.is_on_sale = 1 AND g.is_alone_sale = 1 AND g.is_delete = 0 AND (g.cat_id IN ('4','41','42','43','44') OR g.goods_id IN ('') ) AND g.goods_number > 0 AND og.order_id = o.order_id AND og.goods_id = g.goods_id AND (o.order_status = '1' OR o.order_status = '5') AND (o.pay_status = '2' OR o.pay_status = '1') AND (o.shipping_status = '1' OR o.shipping_status = '2') GROUP BY g.goods_id ORDER BY goods_number DESC, g.goods_id DESC LIMIT 6
建议尝试创建索引，并联系程序方优化数据库查询 ,非常感谢您长期对我司的支持!
问：mysql执行慢是访问那个页面出现的呢？
答：您好，http://www.meihuiw.com/ 我司测试的首页，完全打开要15-18秒才能打开,非常感谢您长期对我司的支持!
