SHOW FULL COLUMNS FROM `tp_specials` [ RunTime:0.001937s ]
SHOW FULL COLUMNS FROM `tp_document` [ RunTime:0.001195s ]
SELECT COUNT(*) AS think_count FROM `tp_document` `a` INNER JOIN `tp_specials` `b` ON `a`.`id`=`b`.`data_id` WHERE `a`.`status` = '1' AND `a`.`check_status` = '1' AND `a`.`convert_status` = '1' AND `b`.`name` = '煤化工行业分析' AND `a`.`character` = '1' LIMIT 1 [ RunTime:0.002780s ]
SHOW FULL COLUMNS FROM `tp_special_manage` [ RunTime:0.001579s ]
SELECT * FROM `tp_special_manage` WHERE `name` = '煤化工行业分析' LIMIT 1 [ RunTime:0.000858s ]
SELECT `uniqid`,`title`,`doc_type`,`down_num`,`pay_way`,`price` FROM `tp_document` `a` INNER JOIN `tp_specials` `b` ON `a`.`id`=`b`.`data_id` WHERE `a`.`status` = '1' AND `a`.`check_status` = '1' AND `a`.`convert_status` = '1' AND `a`.`create_time` > '1683734399' AND `b`.`name` = '煤化工行业分析' ORDER BY `down_num` DESC LIMIT 10 [ RunTime:0.000987s ]
SELECT `uniqid`,`title`,`doc_type`,`down_num`,`pay_way`,`price` FROM `tp_document` `a` INNER JOIN `tp_specials` `b` ON `a`.`id`=`b`.`data_id` WHERE `a`.`status` = '1' AND `a`.`check_status` = '1' AND `a`.`convert_status` = '1' AND `a`.`create_time` > '1707580799' AND `b`.`name` = '煤化工行业分析' ORDER BY `down_num` DESC LIMIT 10 [ RunTime:0.001352s ]
SELECT `uniqid`,`title`,`doc_type`,`down_num`,`pay_way`,`price` FROM `tp_document` `a` INNER JOIN `tp_specials` `b` ON `a`.`id`=`b`.`data_id` WHERE `a`.`status` = '1' AND `a`.`check_status` = '1' AND `a`.`convert_status` = '1' AND `a`.`create_time` > '0' AND `b`.`name` = '煤化工行业分析' ORDER BY `down_num` DESC LIMIT 10 [ RunTime:0.000932s ]
