1、Yii 设置hostInfo生成绝对的url

源链接

Yii 中,可以设置请求地址中的hostInfo 来达到生成绝对的Url

Yii::app()->request->setHostInfo('http://127.0.0.1');
echo Yii::$app->request->hostInfo;

同样,也可以在 config目录下,进行配置项的设置

'components' => [
'request' => [
'hostInfo' => '',
'baseUrl' => '',
]
]

2、生成环境开启 SCHEMA CACHE缓存

# 对应 db 配置项
enableSchemaCache=true

在没有开启schema缓存的情况下,Yii框架会在每次查表时,执行以下语句,可能会造成数据库响应变慢,甚至直接拖垮数据库。

SELECT
kcu.constraint_name,
kcu.column_name,
kcu.referenced_table_name,
kcu.referenced_column_name
FROM information_schema.referential_constraints AS rc
JOIN information_schema.key_column_usage AS kcu ON
(
kcu.constraint_catalog = rc.constraint_catalog OR
(kcu.constraint_catalog IS NULL AND rc.constraint_catalog IS NULL)
) AND
kcu.constraint_schema = rc.constraint_schema AND
kcu.constraint_name = rc.constraint_name
WHERE rc.constraint_schema = database() AND kcu.table_schema = database()
AND rc.table_name = 'table1' AND kcu.table_name = 'table1'