CakePHP-3.0 sort / order me

Question

Why should I use the order key in my queries, but should I use sorting in the content or in the table? This bothers me a little, and moreover, it is not indicated in the fr document, perhaps in the eng doc document?

Does anyone know why these naming options are?

Answer 1

I think that “sorting” is mainly used for pagination, and perhaps “order” is used for the initial request. There is no "SORT" in the standard MYSQL, since it is Cake who decides to differentiate the two.