[ DB ] CONNECT:[ UseTime:0.018537s ] mysql:host=123.56.126.100;port=3306;dbname=xmanedu;charset=utf8
[ SQL ] SHOW COLUMNS FROM `clt_new_bg_promote_type` [ RunTime:0.013398s ]
[ SQL ] SELECT `id` FROM `clt_new_bg_promote_type` WHERE `is_hot` = 1 [ RunTime:0.012478s ]
[ SQL ] SHOW COLUMNS FROM `clt_new_bg_promote` [ RunTime:0.013047s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `clt_new_bg_promote` `p` LEFT JOIN `clt_new_bg_promote_type` `t` ON `p`.`type`=`t`.`id` WHERE `p`.`phase` LIKE '%%' AND `p`.`open` = 1 AND `type` = 1 [ RunTime:0.013322s ]
[ SQL ] SELECT `p`.`id`,`p`.`phase`,`p`.`add_time`,`p`.`title`,`p`.`thumbnail`,`p`.`target_object`,`p`.`activity_time`,`t`.`bg_promote_type`,`t`.`pro_title`,`t`.`pro_describe`,`t`.`pro_keyword`,`t`.`rewrite` FROM `clt_new_bg_promote` `p` LEFT JOIN `clt_new_bg_promote_type` `t` ON `p`.`type`=`t`.`id` WHERE `p`.`phase` LIKE '%%' AND `p`.`open` = 1 AND `type` = 1 ORDER BY `sort` DESC,`add_time` DESC LIMIT 32,8 [ RunTime:0.012795s ]
[ SQL ] SELECT `id`,`bg_promote_type` AS `article_type` FROM `clt_new_bg_promote_type` WHERE `is_hot` = 1 [ RunTime:0.012389s ]