Changes between Initial Version and Version 1 of Ticket #117
- Timestamp:
- 10/18/2012 03:01:48 PM (13 years ago)
Legend:
- Unmodified
- Added
- Removed
- Modified
-
Ticket #117 – Description
initial v1 2 2 应用上线后,功能检查一切正常,突然1点数据库负载变高,去到了4左右,让dba抓了下慢语句,发现大量类似如下的SQL语句 3 3 {{{ 4 4 5 SELECT t0.IMG1, t0.IMG2, t0.IMG3, t1.id, t1.BIG_PIC_PATH, t1.BRAND_NAME, t1.LAST_COUNT_ORDER, t1.CREATE_DATE, t1.FORUM_PATH, t1.HOT_NEW, t1.MID_PATH, t1.name, t1.ORDER_KEY, t1.price, t1.PRICE_CONFIG, t1.PUB_URL, t1.REVIEW_STATUS, t1.SHORT_NAME, t1.PIC_PATH, t1.SMALLTYPE_ID, t1.TYPE_ID, t1.VARIANCE_ID FROM ENT_PRODUCT t0 LEFT OUTER JOIN V_PDL_PRODUCT t1 ON t0.PRODUCT_ID = t1.id WHERE t0.id = $1 6 5 7 }}} 6 8
![(please configure the [header_logo] section in trac.ini)](http://www1.pconline.com.cn/global/2008/images/jss/m_logo091125.jpg)