SHOW FULL COLUMNS FROM `t_assure` [ RunTime:0.000807s ]
SHOW FULL COLUMNS FROM `t_assure_type` [ RunTime:0.000546s ]
SELECT `a_id` FROM `t_assure_type` WHERE `cate_id` = 107 [ RunTime:0.000187s ]
SELECT COUNT(*) AS think_count FROM `t_assure` WHERE `cate_id` = 1 AND `id` IN (SELECT `a_id` FROM `t_assure_type` WHERE `cate_id` = 107) AND `status` IN (2,3,4) AND `is_show` = 0 LIMIT 1 [ RunTime:0.000369s ]
SHOW FULL COLUMNS FROM `t_agent` [ RunTime:0.000672s ]
SHOW FULL COLUMNS FROM `t_company` [ RunTime:0.000703s ]
SELECT `id`,`name`,`brand`,`logo` FROM `t_company` WHERE `status` = 2 ORDER BY `is_recommend` DESC,`sort_time` DESC LIMIT 4 [ RunTime:0.000197s ]
SHOW FULL COLUMNS FROM `t_need` [ RunTime:0.000639s ]
SELECT `id`,`title`,`is_recommend` FROM `t_need` WHERE `form` = 1 AND `is_del` = 0 AND `status` = 2 ORDER BY `is_recommend` DESC,`create_time` DESC LIMIT 5 [ RunTime:0.007751s ]
SELECT `id`,`title`,`is_recommend` FROM `t_need` WHERE `form` = 2 AND `is_del` = 0 AND `status` = 2 ORDER BY `is_recommend` DESC,`create_time` DESC LIMIT 5 [ RunTime:0.005079s ]
SELECT `id`,`title`,`is_recommend` FROM `t_need` WHERE `form` = 9 AND `is_del` = 0 AND `status` = 2 ORDER BY `is_recommend` DESC,`create_time` DESC LIMIT 5 [ RunTime:0.003227s ]
SELECT `id`,`title`,`is_recommend` FROM `t_need` WHERE `form` = 10 AND `is_del` = 0 AND `status` = 2 ORDER BY `is_recommend` DESC,`create_time` DESC LIMIT 5 [ RunTime:0.001940s ]
SELECT `id`,`title`,`is_recommend` FROM `t_need` WHERE `form` = 5 AND `is_del` = 0 AND `status` = 2 ORDER BY `is_recommend` DESC,`create_time` DESC LIMIT 5 [ RunTime:0.002325s ]
SELECT `id`,`title`,`is_recommend` FROM `t_need` WHERE `form` = 8 AND `is_del` = 0 AND `status` = 2 ORDER BY `is_recommend` DESC,`create_time` DESC LIMIT 5 [ RunTime:0.002042s ]