既然担心select结果顺序会变，为啥不排下序 order by 一下。
分页的大小看你业务需求，如果是页面展示一般每页20-50这样就行。

顺便说下 limit i500, (i+1)500-1 你这个分页写的有问题啊，不能这么搞，limit 后面第一个参数是起始位置，第二个参数是往后查询的条数。改成 limit (i-1)*500 , 500;

<?php
$json = '{"code":200,"message":"操作成功","data":[{"id":1,"goods_id":1,"property_name_id":1,"property_value_id":1,"property_name":{"title":"份量","is_sale":true},"property_value":{"id":1,"value":"小份","image":""}},{"id":2,"goods_id":1,"property_name_id":1,"property_value_id":2,"property_name":{"title":"份量","is_sale":true},"property_value":{"id":2,"value":"中份","image":""}},{"id":3,"goods_id":1,"property_name_id":2,"property_value_id":4,"property_name":{"title":"温度","is_sale":true},"property_value":{"id":4,"value":"常温","image":""}},{"id":4,"goods_id":1,"property_name_id":2,"property_value_id":5,"property_name":{"title":"温度","is_sale":true},"property_value":{"id":5,"value":"加冰","image":""}}]}';
$arr = json_decode($json, true);
// 自己加逻辑判断保证key都存在
$newArr = [];
$newArr['code'] = $arr['code'];
$newArr['message'] = $arr['message'];

foreach ($arr['data'] as $v) {
    $id = $v['property_name_id'];

    if (!isset($newArr['data'][$id]['property_id']) && $newArr['data'][$id]['property_id'] != $v['property_value']['id']) {
        $newArr['data'][$id] = [
            'property_id' => $id,
            'property_name' => $v['property_name']['title'],
            'is_sale' => $v['property_name']['is_sale'],
        ];
    }

    $newArr['data'][$id]['item'][] = [
        'id' => $v['property_value']['id'],
        'value' => $v['property_value']['value'],
        'image' => $v['property_value']['image'],
    ];
}

$newArr['data'] = array_values($newArr['data']);
var_dump($newArr);
die;

额，重新启动了阿里云实例，然后就正常了。。。

索引只用在where语句之后

1:你改的是php.ini的类容和nginx无关，重启nginx没用。你需要重启php-fpm
2:多个php.ini表示你系统里面安装了多个php版本，phpinfo里面可以找到对应的php.ini 的文件路径
3：安装nginx不会安装自己的php的，很明显你的系统里安装了多个php版本，导致php -v 和phpinfo里面的版本不一致，
http://www.czc123.top/wordpre... 看下这个解决版本不一致问题
4:没什么难的，就是配置上的一些问题，环境搭好了直接用就行了。linux上其实也有类似的一件安装包 nginx-php-mysql
http://www.czc123.top/wordpre...

问题描述

之前安装的版本是3.3.1的，后来项升级下，就把3.3.1源码目录删除了，重新下载了4.4.12的，编译的时候报错

问题出现的环境背景及自己尝试过哪些方法

php7.2 centos7

相关代码

// 请把代码文本粘贴到下方（请勿用图片代替代码）
/bin/sh /swoole-4.4.12/libtool --mode=compile g++ -I. -I/swoole-4.4.12 -DPHP_ATOM_INC -I/swoole-4.4.12/include -I/swoole-4.4.12/main -I/swoole-4.4.12 -I/usr/local/php/include/php -I/usr/local/php/include/php/main -I/usr/local/php/include/php/TSRM -I/usr/local/php/include/php/Zend -I/usr/local/php/include/php/ext -I/usr/local/php/include/php/ext/date/lib -I/swoole-4.4.12 -I/swoole-4.4.12/include -I/swoole-4.4.12/thirdparty/hiredis -DHAVE_CONFIG_H -g -O2 -Wall -Wno-unused-function -Wno-deprecated -Wno-deprecated-declarations -std=c++11 -c /swoole-4.4.12/swoole_http_server_coro.cc -o swoole_http_server_coro.lo
g++ -I. -I/swoole-4.4.12 -DPHP_ATOM_INC -I/swoole-4.4.12/include -I/swoole-4.4.12/main -I/swoole-4.4.12 -I/usr/local/php/include/php -I/usr/local/php/include/php/main -I/usr/local/php/include/php/TSRM -I/usr/local/php/include/php/Zend -I/usr/local/php/include/php/ext -I/usr/local/php/include/php/ext/date/lib -I/swoole-4.4.12 -I/swoole-4.4.12/include -I/swoole-4.4.12/thirdparty/hiredis -DHAVE_CONFIG_H -g -O2 -Wall -Wno-unused-function -Wno-deprecated -Wno-deprecated-declarations -std=c++11 -c /swoole-4.4.12/swoole_http_server_coro.cc -fPIC -DPIC -o .libs/swoole_http_server_coro.o
g++: 编译器内部错误：已杀死(程序 cc1plus)
Please submit a full bug report,
with preprocessed source if appropriate.
See http://bugzilla.redhat.com/bu... for instructions.
make: * [swoole_http_server_coro.lo] 错误 1

你期待的结果是什么？实际看到的错误信息又是什么？

改何如解决