111122 一些工作记录

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获取自定义属性值