SHOW FULL COLUMNS FROM `tp_specials` [ RunTime:0.001112s ]
SHOW FULL COLUMNS FROM `tp_document` [ RunTime:0.001075s ]
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` = '储氢设备行业分析' LIMIT 1 [ RunTime:0.000777s ]
SELECT `a`.`id`,`a`.`title`,`a`.`down_num`,`a`.`doc_type`,`a`.`pay_way`,`a`.`price`,a.check_time as update_time,`a`.`uniqid`,`a`.`hits`,`a`.`author`,`a`.`description`,`a`.`tags`,`a`.`producer`,`a`.`check_time` 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` = '储氢设备行业分析' ORDER BY `a`.`sort` ASC,`a`.`check_time` DESC LIMIT 0,15 [ RunTime:0.001061s ]
SHOW FULL COLUMNS FROM `tp_tags` [ RunTime:0.000985s ]
SELECT `name` FROM `tp_tags` WHERE `module_id` = 26 AND `status` = 1 AND `data_id` = 3259 GROUP BY `name` ORDER BY `num` DESC LIMIT 25 [ RunTime:0.000815s ]
SELECT name,count(*) as num FROM `tp_specials` WHERE `module_id` = 26 AND `status` = 1 AND `data_id` = 3259 GROUP BY `name` ORDER BY `num` DESC LIMIT 10 [ RunTime:0.000758s ]
SHOW FULL COLUMNS FROM `tp_special_manage` [ RunTime:0.000873s ]
SELECT * FROM `tp_special_manage` WHERE `name` = '储氢设备行业分析' LIMIT 1 [ RunTime:0.001311s ]
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.000770s ]
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.000705s ]
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.000648s ]