thinkphp to heavy distinct and group by____php

Source: Internet
Author: User

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.

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.