[10501] PDOException in Connection.php line 687

SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'index' at line 1

            $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);

Call Stack

in Connection.php line 687
at Connection->query(' SELECT * from ( SEL...', [], false, false) in Query.php line 315
at Query->query(' SELECT * from ( SEL...') in Index.php line 271
at Index->case_info('index')
at ReflectionMethod->invokeArgs(object(Index), ['index']) in Container.php line 395
at Container->invokeReflectMethod(object(Index), object(ReflectionMethod), ['_c' => '1', 'id' => 'index']) in Module.php line 132
at Module->think\route\dispatch\{closure}(object(Request), object(Closure), null)
at call_user_func_array(object(Closure), [object(Request), object(Closure), null]) in Middleware.php line 185
at Middleware->think\{closure}(object(Request))
at call_user_func(object(Closure), object(Request)) in Middleware.php line 130
at Middleware->dispatch(object(Request), 'controller') in Module.php line 137
at Module->exec() in Dispatch.php line 168
at Dispatch->run() in App.php line 432
at App->think\{closure}(object(Request), object(Closure), null)
at call_user_func_array(object(Closure), [object(Request), object(Closure), null]) in Middleware.php line 185
at Middleware->think\{closure}(object(Request))
at call_user_func(object(Closure), object(Request)) in Middleware.php line 130
at Middleware->dispatch(object(Request)) in App.php line 435
at App->run() in index.php line 21

Exception Datas

PDO Error Info
SQLSTATE	42000
Driver Error Code	1064
Driver Error Message	You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'index' at line 1

Database Status
Error Code	10501
Error Message	SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'index' at line 1
Error SQL	SELECT * from ( SELECT @rank:=@rank+1 as rank,a.* from (( SELECT `xzd_article`.*,xzd_cooper_company.name as company_name FROM `xzd_article` LEFT JOIN `xzd_cooper_company` ON `xzd_cooper_company`.`id`=`xzd_article`.`cooper_company_id` WHERE `xzd_article`.`valid` = '1' AND ( concat(',',xzd_article.site,',') REGEXP ',35,\|,4,' ) ORDER BY xzd_article.sort asc,xzd_article.publish_time asc,xzd_article.id asc )) a,(SELECT @rank:=0) b) a where 1 and id=index

Database Config
type	mysql
hostname	127.0.0.1
database	xinzhidi_four_xi
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	[]
xzd_redis_config	{ "hostname": "127.0.0.1", "hostport": "6379", "password": false, "database": 0 }

Environment Variables

GET Data
_c	1

Server/Request Data
USER	www
HOME	/home/www
HTTP_ACCEPT	/
HTTP_HOST	www.xinzhidi.cn
PATH_INFO
REDIRECT_STATUS	200
SERVER_NAME	xinzhidi.four.xinzhidi.cn
SERVER_PORT	80
SERVER_ADDR	10.0.8.10
REMOTE_PORT	56362
REMOTE_ADDR	43.138.21.33
SERVER_SOFTWARE	nginx/1.22.1
GATEWAY_INTERFACE	CGI/1.1
REQUEST_SCHEME	http
SERVER_PROTOCOL	HTTP/1.1
DOCUMENT_ROOT	/www/wwwroot/xinzhidi.four.xinzhidi.cn/xinzhidi_web/public
DOCUMENT_URI	index.html
REQUEST_URI	/index/index/case_info/id/index?_c=1
SCRIPT_NAME	index.html
CONTENT_LENGTH
CONTENT_TYPE
REQUEST_METHOD	GET
QUERY_STRING	s=/index/index/case_info/id/index&_c=1
SCRIPT_FILENAME	/www/wwwroot/xinzhidi.four.xinzhidi.cn/xinzhidi_web/publicindex.html
FCGI_ROLE	RESPONDER
PHP_SELF	index.html
REQUEST_TIME_FLOAT	1697372088.1746
REQUEST_TIME	1697372088