SHOW FULL COLUMNS FROM `tp_tags` [ RunTime:0.005160s ]
SHOW FULL COLUMNS FROM `tp_document` [ RunTime:0.001357s ]
SELECT COUNT(*) AS think_count FROM `tp_document` `a` INNER JOIN `tp_tags` `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` = '2' LIMIT 1 [ RunTime:0.000970s ]
SHOW FULL COLUMNS FROM `tp_tag_manage` [ RunTime:0.000985s ]
SELECT * FROM `tp_tag_manage` WHERE `name` = '合资公司' LIMIT 1 [ RunTime:0.000718s ]
SELECT `uniqid`,`title`,`doc_type`,`down_num`,`pay_way`,`price` FROM `tp_document` `a` INNER JOIN `tp_tags` `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.000851s ]
SELECT `uniqid`,`title`,`doc_type`,`down_num`,`pay_way`,`price` FROM `tp_document` `a` INNER JOIN `tp_tags` `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.000757s ]
SELECT `uniqid`,`title`,`doc_type`,`down_num`,`pay_way`,`price` FROM `tp_document` `a` INNER JOIN `tp_tags` `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.000879s ]