$this->debug(false, '', $master);
// 返回结果集
return $this->getResult($pdo, $procedure);
} catch (\PDOException $e) {
if ($this->isBreak($e)) {
return $this->close()->query($sql, $bind, $master, $pdo);
}
throw new PDOException($e, $this->config, $this->getLastsql());
} catch (\Throwable $e) {
if ($this->isBreak($e)) {
return $this->close()->query($sql, $bind, $master, $pdo);
}
throw $e;
} catch (\Exception $e) {
if ($this->isBreak($e)) {
return $this->close()->query($sql, $bind, $master, $pdo);
SQLSTATE | 42000 |
Driver Error Code | 1055 |
Driver Error Message | Expression #5 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'gpccart.op.products_name' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by |
Error Code | 10501 |
Error Message | SQLSTATE[42000]: Syntax error or access violation: 1055 Expression #5 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'gpccart.op.products_name' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by |
Error SQL | SELECT p.products_id,p.manufacturers_series_id, p.products_price, p.products_image, op.products_name,sum(op.products_quantity) as sale FROM `orders_products` `op` INNER JOIN `products` `p` ON `op`.`products_id`=`p`.`products_id` WHERE `p`.`manufacturers_id` = '9' AND `p`.`manufacturers_series_id` IN ('83','90','99','5604','6246','100','1433','3785','3786','3794','5605','5606','101','1472','3788','3801','3802','5608','5609','102','1499','5611','5612','5613','5614','5615','103','1421','3776','3777','3789','3791','3796','3800','3885','4043','5616','5617','5618','5619','5620','5621','5622','5623','8090','8196','104','1736','5672','5624','5671','91','106','1429','1555','3784','3793','3797','3823','4014','4042','5625','5626','5627','5628','8091','107','1446','1490','1724','3795','5629','5630','5631','5632','5633','5634','5635','108','1509','6485','3792','5636','5637','5638','5639','5640','6486','110','1812','3886','92','112','1530','3817','5643','5644','5646','113','344','93','114','1496','3855','3856','5647','5648','7244','8208','94','116','1598','5649','5650','5651','5652','5653','117','1615','118','1593','119','3840','8209','120','1465','95','121','1501','3815','3893','3896','4044','5654','5655','122','360','96','123','1422','3798','3799','5656','124','364','365','366','125','1842','1974','97','126','1528','3808','127','1780') GROUP BY `op`.`products_id` ORDER BY `sale` DESC LIMIT 0,5 |
type | mysql |
hostname | rm-wz9n99e7id2n306u6ao.mysql.rds.aliyuncs.com |
database | gpccart |
hostport | 3306 |
dsn | |
params | [] |
charset | utf8 |
prefix | |
debug | true |
deploy | 0 |
rw_separate | false |
master_num | 1 |
slave_no | |
read_master | false |
fields_strict | true |
resultset_type | array |
auto_timestamp | false |
datetime_format | Y-m-d H:i:s |
sql_explain | false |
builder | |
query | \think\db\Query |
break_reconnect | false |
break_match_str | [] |
db2 | { "type": "mysql", "hostname": "127.0.0.1", "database": "gpccart", "username": "gpccart", "password": "gpc0771", "hostport": "", "params": [], "charset": "utf8", "prefix": "" } |
db3 | { "type": "mysql", "hostname": "127.0.0.1", "database": "test", "username": "gpccart", "password": "gpc0771", "hostport": "", "params": [], "charset": "utf8", "prefix": "" } |
USER | www |
HOME | /home/www |
HTTP_USER_AGENT | claudebot |
HTTP_ACCEPT | */* |
HTTP_CONNECTION | close |
HTTP_HOST | www.gpcang.com |
PHP_ADMIN_VALUE | open_basedir=/www/wwwroot/www.gpcang.com/:/www/wwwroot/www.gpcang.com/images/:/www/wwwroot/www.gpcang.com/tp5/:/www/wwwroot/www.gpcang.com/tp5/application/:/tmp/ |
PATH_INFO | |
REDIRECT_STATUS | 200 |
SERVER_NAME | www.gpcang.com |
SERVER_PORT | 443 |
SERVER_ADDR | 172.18.36.102 |
REMOTE_PORT | 40312 |
REMOTE_ADDR | 39.108.54.53 |
SERVER_SOFTWARE | nginx/1.8.1 |
GATEWAY_INTERFACE | CGI/1.1 |
HTTPS | on |
SERVER_PROTOCOL | HTTP/1.0 |
DOCUMENT_ROOT | /www/wwwroot/www.gpcang.com |
DOCUMENT_URI | /tp5/tp7.php |
REQUEST_URI | /tp5/tp7.php?s=Brand/brand_cate/b_id/9.html |
SCRIPT_NAME | /tp5/tp7.php |
CONTENT_LENGTH | |
CONTENT_TYPE | |
REQUEST_METHOD | GET |
QUERY_STRING | s=Brand/brand_cate/b_id/9.html |
SCRIPT_FILENAME | /www/wwwroot/www.gpcang.com/tp5/tp7.php |
FCGI_ROLE | RESPONDER |
PHP_SELF | /tp5/tp7.php |
REQUEST_TIME_FLOAT | 1710823818.7635 |
REQUEST_TIME | 1710823818 |
APP_PATH | /www/wwwroot/www.gpcang.com/tp5/application/ |
THINK_VERSION | 5.0.15 |
THINK_START_TIME | 1710823818.7639 |
THINK_START_MEM | 422408 |
EXT | .php |
DS | / |
THINK_PATH | /www/wwwroot/www.gpcang.com/tp5/thinkphp/ |
LIB_PATH | /www/wwwroot/www.gpcang.com/tp5/thinkphp/library/ |
CORE_PATH | /www/wwwroot/www.gpcang.com/tp5/thinkphp/library/think/ |
TRAIT_PATH | /www/wwwroot/www.gpcang.com/tp5/thinkphp/library/traits/ |
ROOT_PATH | /www/wwwroot/www.gpcang.com/tp5/ |
EXTEND_PATH | /www/wwwroot/www.gpcang.com/tp5/extend/ |
VENDOR_PATH | /www/wwwroot/www.gpcang.com/tp5/vendor/ |
RUNTIME_PATH | /www/wwwroot/www.gpcang.com/tp5/runtime/ |
LOG_PATH | /www/wwwroot/www.gpcang.com/tp5/runtime/log/ |
CACHE_PATH | /www/wwwroot/www.gpcang.com/tp5/runtime/cache/ |
TEMP_PATH | /www/wwwroot/www.gpcang.com/tp5/runtime/temp/ |
CONF_PATH | /www/wwwroot/www.gpcang.com/tp5/application/ |
CONF_EXT | .php |
ENV_PREFIX | PHP_ |