SHOW FULL COLUMNS FROM `cms_home_links` [ RunTime:0.000886s ]
SELECT * FROM `cms_home_links` ORDER BY `sort` DESC [ RunTime:0.000211s ]
SHOW FULL COLUMNS FROM `cms_home_vote` [ RunTime:0.000766s ]
SELECT `id`,`title`,`image`,`start_time`,`end_time`,`max_option`,`min_option`,`rule`,`type` FROM `cms_home_vote` WHERE ( `type` = 3 ) AND `cms_home_vote`.`delete_time` IS NULL ORDER BY `end_time` DESC LIMIT 5 [ RunTime:0.000223s ]
SELECT * FROM `cms_home_vote` WHERE ( `type` = 3 AND ( CURRENT_DATE() >= end_time ) ) AND `cms_home_vote`.`delete_time` IS NULL ORDER BY `end_time` ASC LIMIT 10 [ RunTime:0.000231s ]
select t1.* from (SELECT
a.*,
( @rowNum := @rowNum + 1 ) AS rank #计算行号
FROM
cms_home_voteoption AS a,
( SELECT ( @rowNum := 0 ) ) b
where a.vote_id = 3
ORDER BY
a.num DESC
) as t1 limit 0,2 [ RunTime:0.000584s ]
select t1.* from (SELECT
a.*,
( @rowNum := @rowNum + 1 ) AS rank #计算行号
FROM
cms_home_voteoption AS a,
( SELECT ( @rowNum := 0 ) ) b
where a.vote_id = 4
ORDER BY
a.num DESC
) as t1 limit 0,2 [ RunTime:0.002875s ]
SHOW FULL COLUMNS FROM `cms_home_votecon` [ RunTime:0.000722s ]
SELECT * FROM `cms_home_votecon` WHERE ( `vote_id` = 4 AND `voteoption_id` = 433 AND `member_id` = 0 ) AND `cms_home_votecon`.`delete_time` IS NULL LIMIT 1 [ RunTime:0.008926s ]
SELECT * FROM `cms_home_votecon` WHERE ( `vote_id` = 4 AND `voteoption_id` = 445 AND `member_id` = 0 ) AND `cms_home_votecon`.`delete_time` IS NULL LIMIT 1 [ RunTime:0.008787s ]
SELECT * FROM `cms_home_vote` WHERE ( `id` = 4 ) AND `cms_home_vote`.`delete_time` IS NULL LIMIT 1 [ RunTime:0.000160s ]
SHOW FULL COLUMNS FROM `cms_home_voteoption` [ RunTime:0.000718s ]
SELECT COUNT(*) AS think_count FROM `cms_home_voteoption` WHERE ( `vote_id` = 4 ) AND `cms_home_voteoption`.`delete_time` IS NULL LIMIT 1 [ RunTime:0.000488s ]
SHOW FULL COLUMNS FROM `cms_home_information` [ RunTime:0.000746s ]
SELECT `t1`.*,t2.title as school_name,`t2`.`sub_title`,t2.logo as school_logo,`t2`.`address`,`t2`.`province`,`t2`.`city`,`t2`.`area`,`t2`.`phone` FROM `cms_home_information` `t1` INNER JOIN `cms_home_school` `t2` ON `t1`.`school_id`=`t2`.`id` WHERE ( `t1`.`id` = '11' ) AND `t1`.`delete_time` IS NULL LIMIT 1 [ RunTime:0.000226s ]
