SHOW FULL COLUMNS FROM `tb_article_content` [ RunTime:0.005287s ]
SELECT `a`.*,`b`.`name`,b.avatar as avatar_author FROM `tb_article_content` `a` LEFT JOIN `tb_article_author` `b` ON `author`=`b`.`id` WHERE `status` = 2 AND `a`.`id` = '1138' LIMIT 1 [ RunTime:0.008352s ]
select a.id ,`title` ,`m_reading`,`create_at`,cover,video,video_length,b.name,level_limit
FROM `tb_article_content` a
left join tb_article_author b on b.id=a.author
WHERE status=2
and video <> ''
and a.id <> 1138
and `create_at` >='2025-05-22'
ORDER BY `m_reading` desc,m_reading desc LIMIT 5 [ RunTime:0.007010s ]
select
B.job,
user_id,
B.name,
intro,
level,
B.desc,
ava,
B.position,
B.status
from tb_article_content A,tb_adviser B,tb_article_author C
WHERE C.id=A.author
and C.userid=B.user_id
and B.status=1
and A.id=1138 limit 1 [ RunTime:0.005410s ]
select a.`id` ,`title` ,`m_reading`,`create_at` ,cover,type,level_limit,ac.name_cate as typen
FROM `tb_article_content` a
left join tb_article_category ac on ac.id_cate=a.cate_id
WHERE status=2
and video = ''
and a.id <> 1138
and `create_at` >='2025-06-14'
and show_type=1
ORDER BY `m_reading` desc,m_reading desc LIMIT 5 [ RunTime:0.007319s ]
SHOW FULL COLUMNS FROM `tb_advisercount_copy1` [ RunTime:0.007921s ]
SHOW FULL COLUMNS FROM `tb_collection_articles` [ RunTime:0.010092s ]
SELECT `a`.`collection_id`,`b`.`name` FROM `tb_collection_articles` `a` LEFT JOIN `tb_article_collection` `b` ON `b`.`id`=`a`.`collection_id` WHERE `article_id` = 1138 AND `b`.`status` = '2' ORDER BY `a`.`create_at` DESC [ RunTime:0.007143s ]