各位高手帮帮忙哦

2016-07-07 15:21 来源：www.chinab4c.com 作者：ecshop专家

| 54 | root | localhost | shop | Query| 0 | Sorting result | SELECT img_id, img_desc, thumb_url, img_url FROM `shop`.`yufu_goods_gallery` WHERE goods_id = '3147' |


| 83 | root | localhost | shop | Query| 0 | Sending data | SELECT b.brand_id, b.brand_name, COUNT(*) AS goods_num FROM `shop`.`yufu_brand`AS b, `shop`.`yufu_go |

| 99 | root | localhost | shop | Query| 0 | Sending data | SELECT COUNT(*) FROM `shop`.`yufu_goods` AS g WHERE g.is_on_sale = 1 AND g.is_alone_sale = 1 AND g.i |

| 100 | root | localhost | shop | Query| 0 | Copying to tmp table | SELECT a.attr_id, MIN(a.goods_attr_id ) AS goods_id, a.attr_value AS attr_value FROM `shop`.`yufu_go |



| 100 | root | localhost | shop | Query|79 | Copying to tmp table | SELECT DISTINCT(b.goods_id) FROM `shop`.`yufu_goods_attr` AS a, `shop`.`yufu_goods_attr` AS b, `shop |

| 101 | root | localhost | shop | Query|76 | Locked| UPDATE `shop`.`yufu_goods` SET click_count = click_count + 1 WHERE goods_id = '3005'|

| 102 | root | localhost | shop | Query|74 | Locked| SELECT goods_name FROM `shop`.`yufu_goods`WHERE goods_id = '3123'|

| 104 | root | localhost | shop | Query|43 | Locked| SELECT goods_name FROM `shop`.`yufu_goods`WHERE goods_id = '3123'|


直接导致mysql挂了