orderby
$test = (new Query())->select('shop_name,add_time,state')->from('{{%shop_info}}')
->orderBy(["field(state,0,1,3,2,5,4,6)" => true,'add_time' => SORT_DESC])->all();
addOrderBy
$test = (new Query())->select('shop_name,add_time,state')->from('{{%shop_info}}')
->orderBy(['field(state,0,1,3,2,5,4,6)' => true])->addOrderBy('add_time DESC')->all();