<?php
$app = Db::table('app', 'as A')
->field('A.id,A.name,A.state,A.mode,A.app_bb,IFNULL(U.us,0) as unum,IFNULL(Q.qs,0) as qnum,IFNULL(L.zx,0) as znum')->JOIN("(SELECT appid,COUNT(*) AS us FROM {$DP}user GROUP BY appid) AS U", 'A.id=U.appid')
->JOIN("(SELECT appid,COUNT(*) AS qs FROM {$DP}user_log where `type` = 'clock' GROUP BY appid) AS Q", 'A.id=Q.appid')
->JOIN("(SELECT appid,COUNT(*) AS zx FROM {$DP}user_logon where `last_t` > {$UTT} GROUP BY appid) AS L", 'A.id=L.appid');
if ($so) {
$app = $app->where('A.uuid', $user_id)->where('A.id', 'like', "%{$so}%")->whereOr('A.name', 'like', "%{$so}%")->whereOr('A.appkey', 'like', "%{$so}%")->order('id desc');
} else {
$app = $app->where('A.uuid', $user_id)->order('id desc')->limit($bnums, $ENUMS);
}
// var_dump($app,$user_id);
$res = $app->select(); //false
//die($sql);
foreach ($res as $k => $v) {
$rows = $res[$k];
?>
大佬麻烦给我解释一下这串代码意思,最近再学PHP,MySQL,从开源的源码上看到但不懂望大佬指点。