安静
PHP技术博客

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

 

 

赞(0) 打赏
未经允许不得转载:AJ's Blog » 111122 一些工作记录
分享到: 更多 (0)

评论 抢沙发

  • 昵称 (必填)
  • 邮箱 (必填)
  • 网址

觉得文章有用就打赏一下文章作者

支付宝扫一扫打赏

微信扫一扫打赏