SHOW FULL COLUMNS FROM `tp_tags` [ RunTime:0.014390s ]
SELECT `data_id` FROM `tp_tags` WHERE `module_id` = 26 AND `status` = 1 AND `name` = '傲农生物' ORDER BY `num` DESC LIMIT 30 [ RunTime:0.000925s ]
SHOW FULL COLUMNS FROM `tp_document` [ RunTime:0.001136s ]
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` = '傲农生物' LIMIT 1 [ RunTime:0.001037s ]
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_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` = '傲农生物' ORDER BY `a`.`sort` ASC,`a`.`check_time` DESC LIMIT 0,15 [ RunTime:0.001109s ]
SELECT `name` FROM `tp_tags` WHERE `module_id` = 26 AND `status` = 1 AND `data_id` IN (62065,62687) GROUP BY `name` ORDER BY `num` DESC LIMIT 25 [ RunTime:0.001133s ]
SHOW FULL COLUMNS FROM `tp_specials` [ RunTime:0.001001s ]
SELECT name,count(*) as num FROM `tp_specials` WHERE `module_id` = 26 AND `status` = 1 AND `data_id` IN (62065,62687) GROUP BY `name` ORDER BY `num` DESC LIMIT 10 [ RunTime:0.000867s ]
SHOW FULL COLUMNS FROM `tp_tag_manage` [ RunTime:0.001030s ]
SELECT * FROM `tp_tag_manage` WHERE `name` = '傲农生物' LIMIT 1 [ RunTime:0.000825s ]
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.000847s ]
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.000816s ]
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.000786s ]
扫码关注微信公众号
扫码进入微信小程序
