比如在controller里面你執(zhí)行
$query= ReleaseForm::find()->where(['type'=>1])->all();
注:源代碼是這些:
$query= ReleaseForm::find()->where(['type'=>1]);
$pagination = new Pagination([
'defaultPageSize' => 5,
'totalCount' => $query->count(),
]);
$property_data= $query
->offset($pagination->offset)
->limit($pagination->limit)
->all();
在網(wǎng)頁(yè)里你點(diǎn)擊底部的log就可以看到:
10 21:01:36.667 info yii\\\\db\\\\Command::query SELECT COUNT(*) FROM `releases` WHERE `type`=1
E:\\\\web\\\\Apache24\\\\htdocs\\\\basic\\\\controllers\\\\PropertyController.php (14)
11 21:01:36.667 info yii\\\\db\\\\Connection::open Opening DB connection: mysql:host=localhost;dbname=xunwu
E:\\\\web\\\\Apache24\\\\htdocs\\\\basic\\\\controllers\\\\PropertyController.php (14)
12 21:01:36.669 info yii\\\\db\\\\Command::query SELECT * FROM `releases` WHERE `type`=1 LIMIT 5
E:\\\\web\\\\Apache24\\\\htdocs\\\\basic\\\\controllers\\\\PropertyController.php (20)
13 21:01:36.670 info yii\\\\db\\\\Command::query SHOW FULL COLUMNS FROM `releases`
E:\\\\web\\\\Apache24\\\\htdocs\\\\basic\\\\controllers\\\\PropertyController.php (20)
14 21:01:36.674 info yii\\\\db\\\\Command::query SHOW CREATE TABLE `releases`
這樣就知道你執(zhí)行了什么sql語(yǔ)句了
相關(guān)學(xué)習(xí)推薦:yii教程
更多關(guān)于云服務(wù)器,域名注冊(cè),虛擬主機(jī)的問(wèn)題,請(qǐng)?jiān)L問(wèn)西部數(shù)碼官網(wǎng):m.ps-sw.cn