答：您好， SELECT `id`,`pic_url`,`title`,`commission_rate`,`coupon_price`,`price`,`quan`,`shop_type`,`volume`,`add_time` FROM `tqk_items` WHERE `ems` = 1 AND `status` = \’underway\’ AND ( `title` LIKE \’%儲(chǔ)物架%\’ OR `tags` LIKE \’%儲(chǔ)物架%\’ ) ORDER BY `ordid` asc,`coupon_start_time` DESC LIMIT 0,20 | SELECT `id`,`pic_url`,`title`,`commission_rate`,`coupon_price`,`price`,`quan`,`shop_type`,`volume`,`add_time` FROM `tqk_items` WHERE `ems` = 1 AND `status` = \’underway\’ AND ( `title` LIKE \’%桂圓%\’ OR `tags` LIKE \’%桂圓%\’ ) ORDER BY `ordid` asc,`coupon_start_time` DESC LIMIT 0,20 | SELECT `id`,`pic_url`,`title`,`commission_rate`,`coupon_price`,`price`,`quan`,`shop_type`,`volume`,`add_time` FROM `tqk_items` WHERE `ems` = 1 AND `status` = \’underway\’ AND ( `title` LIKE \’%泳鏡%\’ OR `tags` LIKE \’%泳鏡%\’ ) ORDER BY `ordid` asc,`volume` DESC LIMIT 0,20 | SELECT `id`,`pic_url`,`title`,`commission_rate`,`coupon_price`,`price`,`quan`,`shop_type`,`volume`,`add_time` FROM `tqk_items` WHERE `ems` = 1 AND `status` = \’underway\’ AND ( `title` LIKE \’%輔食%\’ OR `tags` LIKE \’%輔食%\’ ) ORDER BY `ordid` asc,`coupon_start_time` DESC LIMIT 0,20 | SELECT COUNT(1) AS tp_count FROM `tqk_items` WHERE `ems` = 1 AND `status` = \’underway\’ AND ( `title` LIKE \’%減負(fù)%\’ OR `tags` LIKE \’%減負(fù)%\’ ) LIMIT 1 您還是檢查優(yōu)化下您的程序吧，站點(diǎn)開啟后服務(wù)器cpu又出現(xiàn)異常了。 這種查詢語(yǔ)句全部是用like的效率特別低，而且創(chuàng)建索引都無(wú)法創(chuàng)建。 非常感謝您對(duì)我司的支持，謝謝！
