$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` = '11' AND `p`.`manufacturers_series_id` IN ('7330','7332','7333','7338','7339','7340','7341','7334','7342','7351','7352','7353','7354','7343','7355','7356','7357','7358','7359','7367','7344','7360','7361','7362','7345','7346','7347','7363','7364','7348','7349','7365','7366','7350','7335','7336','7368','7369','7372','7379','7380','7381','7382','7373','7383','7384','7385','7386','7387','7388','7374','7389','7390','7391','7392','7375','7376','7377','7378','7370','7371','7394','7395','7401','7402','7403','7404','7405','7396','7397','7398','7399','7400','7406','7393','8183','8184','7407','7408','7409','7410','7411','7412','7414','7415','7416','7435','7436','7417','7437','7438','7439','7440','7418','7441','7442','7443','7419','7420','7444','7445','7446','7421','7422','7447','7448','7449','7423','7424','7450','7451','7452','7425','7426','7427','7428','7430','7431','7432','7433','7434','7453','7454','7457','7455','7456','7458','7459','7460','7461','7462','7463','7464','7465','7467','7468','7469','7466','7470','7471','7472','7473','7474','7475','7476','7477','7478','7479','7480','7482','7483','7481','7484','7485','7486','7487','7488','7489','7490','7491','7492','7493','7494','7495','7496','7497','7498','7499','7500','7501','7502','7503','8033') 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 | 56728 |
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/11.html |
SCRIPT_NAME | /tp5/tp7.php |
CONTENT_LENGTH | |
CONTENT_TYPE | |
REQUEST_METHOD | GET |
QUERY_STRING | s=Brand/brand_cate/b_id/11.html |
SCRIPT_FILENAME | /www/wwwroot/www.gpcang.com/tp5/tp7.php |
FCGI_ROLE | RESPONDER |
PHP_SELF | /tp5/tp7.php |
REQUEST_TIME_FLOAT | 1710854341.134 |
REQUEST_TIME | 1710854341 |
APP_PATH | /www/wwwroot/www.gpcang.com/tp5/application/ |
THINK_VERSION | 5.0.15 |
THINK_START_TIME | 1710854341.1344 |
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_ |