In the recent project, encountered the data table to heavy request, to thinkphp to have a more accurate understanding and experience.
Two ways to go weight:
$test _data = M (' hot '); Materialized datasheet
$data = $test _data->distinct (true)->field (' Descriprion ')->order (' Description desc ')-> Select (); Using distinct method to
$data = $test _data->group (' description ')->order (' Description desc ')->select (); Using group method to
dump ($data);
For two ways of going heavy:
Using distinct to heavy, easy to use, but only for a single field to weight, and the final result is only to go heavy fields, the actual application value is not particularly large.
Use group to go heavy, the final display result is all the fields, and the single field to go to redo, the effect is good, but the final display results to remove the heavy field, sorted by the first field, may still need to deal with.