［SQL语句］

SELECT catid,catname,arrchildid,pclink,target FROM `www_aipedu_net` . `db_category` WHERE siteid = 0 AND `display`=1 AND parentid=0 ORDER BY listorder ASC LIMIT 20;

SELECT setting FROM `www_aipedu_net` . `db_model_field` WHERE (modelid = '4' AND field = 'country') LIMIT 1;

SELECT setting FROM `www_aipedu_net` . `db_model_field` WHERE (modelid = '4' AND field = 'major') LIMIT 1;

SELECT COUNT(*) AS total FROM `www_aipedu_net` . `db_college` WHERE status=1 AND catid=3 AND `status` = 1 ;

SELECT title,entitle,url,thumb,slogo,nature,fees,address,lang,major,focusmajor,country FROM `www_aipedu_net` . `db_college` WHERE status=1 AND catid=3 AND `status` = 1 ORDER BY id ASC,listorder DESC LIMIT 0,7;

SELECT url,thumb,title FROM `www_aipedu_net` . `db_recruit` WHERE status=1 ORDER BY id DESC LIMIT 1;

SELECT title,url,thumb,slogo FROM `www_aipedu_net` . `db_college` WHERE status=1 AND catid=3 ORDER BY listorder ASC,id DESC LIMIT 10;

［其他信息］

服务器信息：Apache/2.4.55 (Win64) OpenSSL/1.1.1s mod_fcgid/2.3.9a

路由信息：模块( index )，控制器( index )，方法( lists )，参数( catid=3 )

框架版本：2.9