Zend Freamwork 打印mysql输出
vim /data/httpd/htdocs/www.80aj.com/library/Zend/Db/Adapter/Abstract.php
MYSQL优化前
select distinct(f_label_id) from label_relationship where f_label_channel_id=6 and f_label_id in (
select distinct(f_label_id) from label_relationship where f_label_channel_id=1 and f_label_id in (
select distinct(f_label_id) from label_relationship where f_label_channel_id=2)
)
MYSQL优化后
select f_label_id from label_relationship where f_label_channel_id in (1,2,6)
group by f_label_id HAVING COUNT(f_label_id) >=3
JavaScript获取自定义属性值