[SQL语句]
SELECT mobname,catid,type,pclink FROM `fpapx` . `lys_category` WHERE siteid = 0 AND `display`=1 AND parentid=0 ORDER BY listorder ASC LIMIT 20; [ RunTime:0.000344s ]
SELECT COUNT(*) AS total FROM `fpapx` . `lys_article` WHERE status=1 AND catid=12; [ RunTime:0.000194s ]
SELECT id,catid,title,inputtime,color,flag FROM `fpapx` . `lys_article` WHERE status=1 AND catid=12 ORDER BY listorder ASC,id DESC LIMIT 20,20; [ RunTime:0.000717s ]
SELECT id,catid,title,inputtime,color FROM `fpapx` . `lys_article` WHERE status=1 AND catid=12 ORDER BY `click` DESC LIMIT 10; [ RunTime:0.000620s ]
[其他信息]
WEB服务器:Apache
PHP版本:8.3.8
路由信息:模块( mobile ),控制器( index ),方法( lists ),参数( catid=12&page=2 )