SHOW FULL COLUMNS FROM `cms_home_links` [ RunTime:0.000870s ]
SELECT * FROM `cms_home_links` ORDER BY `sort` DESC [ RunTime:0.000205s ]
SHOW FULL COLUMNS FROM `cms_home_vote` [ RunTime:0.000745s ]
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.000240s ]
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.000229s ]
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.000528s ]
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.002827s ]
SHOW FULL COLUMNS FROM `cms_home_votecon` [ RunTime:0.000727s ]
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.008753s ]
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.008667s ]
SELECT * FROM `cms_home_vote` WHERE ( `id` = 4 ) AND `cms_home_vote`.`delete_time` IS NULL LIMIT 1 [ RunTime:0.000156s ]
SHOW FULL COLUMNS FROM `cms_home_voteoption` [ RunTime:0.000734s ]
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.000511s ]
SHOW FULL COLUMNS FROM `cms_home_information` [ RunTime:0.000704s ]
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.000219s ]
