一个特定的id在第一个和所有id之后按desc顺序

Question

我需要先获取一个特定的id，然后按降序获取所有id。这就是我所做的，但当我取消对订单行的注释时，它将不起作用，

$result = $this->Practicetestanswers->find('all',
['contain' => ['Practicetestquestions' =>
['Practicetestconceptassignment' => ['Practicetestconcept', 'Practicetest']
]]])
->where(['Practicetestanswers.user_id' => $student_id,
'Practicetestquestions.is_active' => 'y',
'Practicetest.is_active' => 'y'
])
->select([
'id' => 'Practicetest.id',
'test_code' => 'Practicetest.test_code',
'test_title' => 'Practicetest.test_title',
'time_taken' => 'SUM(Practicetestanswers.time_taken)',
])
->group('Practicetest.id')
//    ->order(["FIELD(Practicetest.id, '228')" => 'DESC'])   //need like this
->order(["Practicetest.id" => 'DESC'])
->hydrate(false)
->toArray();

Answer 1

只需按条件用订单替换此行

->order(['FIELD(Practicetest.id, "228")'=> 'DESC', "Practicetest.id" => 'DESC' ])