show columns from `xyh_visitor` [ runtime:0.0072s ]
select * from `xyh_visitor` where ( datetime = 1599321600 ) limit 1 [ runtime:0.0004s ]
select * from `xyh_visitor` where ( datetime = 1599321600 and find_in_set('173.208.198.218',ips) ) limit 1 [ runtime:0.0004s ]
show columns from `xyh_category` [ runtime:0.0078s ]
select * from `xyh_category` where `id` = 5 limit 1 [ runtime:0.0004s ]
select * from `xyh_category` where `id` = 23 limit 1 [ runtime:0.0002s ]
show columns from `xyh_category_access` [ runtime:0.0074s ]
select `roleid` from `xyh_category_access` where `catid` = 17 and `flag` = 0 and `action` = 'visit' [ runtime:0.0002s ]
show columns from `xyh_article` [ runtime:0.0084s ]
select * from `xyh_article` where `status` = 0 and `id` = 84 limit 1 [ runtime:0.0004s ]
show columns from `xyh_category` [ runtime:0.0114s ]
select article.id as id,article.title as title,article.shorttitle as shorttitle,article.color as color,article.copyfrom as copyfrom,article.author as author,article.keywords as keywords,article.litpic as litpic,article.content as content,article.description as description,article.publishtime as publishtime,article.updatetime as updatetime,article.click as click,article.cid as cid,article.commentflag as commentflag,article.flag as flag,article.jumpurl as jumpurl,article.status as status,article.userid as userid,article.aid as aid,article.pictureurls as pictureurls,article.orderlist as orderlist,article.banner as banner,article.downlink as downlink,category.name as catename,category.ename as ename,category.modelid as modelid from xyh_article article left join xyh_category category on article.cid = category.id where article.status = 0 and article.cid = '17' and article.id < '84' order by article.id desc limit 1 [ runtime:0.0006s ]
select article.id as id,article.title as title,article.shorttitle as shorttitle,article.color as color,article.copyfrom as copyfrom,article.author as author,article.keywords as keywords,article.litpic as litpic,article.content as content,article.description as description,article.publishtime as publishtime,article.updatetime as updatetime,article.click as click,article.cid as cid,article.commentflag as commentflag,article.flag as flag,article.jumpurl as jumpurl,article.status as status,article.userid as userid,article.aid as aid,article.pictureurls as pictureurls,article.orderlist as orderlist,article.banner as banner,article.downlink as downlink,category.name as catename,category.ename as ename,category.modelid as modelid from xyh_article article left join xyh_category category on article.cid = category.id where article.status = 0 and article.cid = '17' and article.id > '84' order by article.id asc limit 1 [ runtime:0.0004s ]
show columns from `xyh_link` [ runtime:0.0070s ]
select * from `xyh_link` order by sort asc limit 30 [ runtime:0.0004s ]