[10501] PDOException in Connection.php line 694

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 'AND t1.`id` <> 6941 AND t1.`newtype` = 'article' AND t1.`online` = '1' ORDER BY' 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 694
at Connection->query('SELECT *,t1.id as ne...', [], false, false) in Query.php line 335
at Query->query('SELECT *,t1.id as ne...')
at call_user_func_array([object(Query), 'query'], ['SELECT *,t1.id as ne...']) in Db.php line 195
at Db::__callStatic('query', ['SELECT *,t1.id as ne...']) in Index.php line 2143
at Index->detail('', '6941', '')
at ReflectionMethod->invokeArgs(object(Index), ['', '6941', '']) in Container.php line 395
at Container->invokeReflectMethod(object(Index), object(ReflectionMethod), ['shengcheng' => '68541e8304037', 'id' => '6941', 'convert' => false]) in Module.php line 131
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 136
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 27

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 'AND t1.`id` <> 6941 AND t1.`newtype` = 'article' AND t1.`online` = '1' ORDER BY' 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 'AND t1.`id` <> 6941 AND t1.`newtype` = 'article' AND t1.`online` = '1' ORDER BY' at line 1
Error SQL	SELECT ,t1.id as newsid FROM `xy_article` AS t1 JOIN (SELECT ROUND(RAND() ((SELECT MAX(id) FROM `xy_article`)-(SELECT MIN(id) FROM `xy_article`))+(SELECT MIN(id) FROM `xy_article`)) AS id) AS t2 WHERE t1.delete_time='0' AND t1.id >= t2.id AND t1.`categoryid` = AND t1.`id` <> 6941 AND t1.`newtype` = 'article' AND t1.`online` = '1' ORDER BY t1.id LIMIT 6

Database Config
type	mysql
hostname	127.0.0.1
database	tzsucai
hostport
dsn
params	[]
charset	utf8mb4
prefix	xy_
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	true
break_match_str	[]
db_config1	{ "type": "mysql", "hostname": "127.0.0.1", "database": "ousa_xuanyingit", "username": "ousa_xuanyingit", "password": "YTJt4tnwwD3rhxM7", "charset": "utf8", "prefix": "task_" }

Environment Variables

GET Data
shengcheng	68541e8304037

Session
xuanying_tz	{ "state": "659e41b130ee870c4211fe872ef7fd5e" }

Server/Request Data
USER	www
HOME	/home/www
HTTP_X5_UUID	6f78eae805e11ecae9749b2e4bbc8b05
HTTP_X_SINFO	on
HTTP_X_FORWARDED_PROTO	http
HTTP_WL_PROXY_CLIENT_IP	36.153.81.208
HTTP_WEB_SERVER_TYPE	nginx
HTTP_X_CLIENT_IP	8.129.188.198
HTTP_X_TRUE_IP	36.153.81.208
HTTP_X_REAL_IP	8.129.188.198
HTTP_EAGLEEYE_RPCID	0.1
HTTP_ALI_CDN_APPVIEW_NAME	cdn-tengine
HTTP_ACCEPT	/
HTTP_ALI_SWIFT_FORCE_TTL_CODE	400=0
HTTP_ALI_CDN_FORWARD_CLIENT_IP	8.129.188.198
HTTP_ALI_CDN_REAL_IP	8.129.188.198
HTTP_X_CLIENT_SCHEME	https
HTTP_ALI_SWIFT_STAT_HOST	www.tzsucai.com
HTTP_ALI_SWIFT_LOG_HOST	www.tzsucai.com
HTTP_ALI_PROXY_IS_FREE	0
HTTP_ALI_PROXY_IS_HOT	0
HTTP_VIA	cn2466.l1, kunlun8.cn2466, l2cn8393.l2, cache60.l2cn8393
HTTP_EAGLEEYE_TRACEID	7ce1a79c17503432990938363e
HTTP_X_FORWARDED_FOR	8.129.188.198, 36.153.81.208
HTTP_HOST	www.tzsucai.com
PATH_INFO
REDIRECT_STATUS	200
SERVER_NAME	d.tzsucai.com
SERVER_PORT	80
SERVER_ADDR	172.18.159.67
REMOTE_PORT	30316
REMOTE_ADDR	36.153.81.208
SERVER_SOFTWARE	nginx/1.21.4
GATEWAY_INTERFACE	CGI/1.1
REQUEST_SCHEME	http
SERVER_PROTOCOL	HTTP/1.1
DOCUMENT_ROOT	/www/wwwroot/tzsucai.com/public
DOCUMENT_URI	/index.php
REQUEST_URI	/3dmax/6941?shengcheng=68541e8304037
SCRIPT_NAME	/index.php
CONTENT_LENGTH
CONTENT_TYPE
REQUEST_METHOD	GET
QUERY_STRING	s=/3dmax/6941&shengcheng=68541e8304037
SCRIPT_FILENAME	/www/wwwroot/tzsucai.com/public/index.php
FCGI_ROLE	RESPONDER
PHP_SELF	/index.php
REQUEST_TIME_FLOAT	1750343305.3138
REQUEST_TIME	1750343305

ThinkPHP Constants
FILTER_VALIDATE_BOOL	258
HTMLPURIFIER_PREFIX	/www/wwwroot/tzsucai.com/vendor/ezyang/htmlpurifier/library
PINYIN_DEFAULT	4096
PINYIN_TONE	2
PINYIN_NO_TONE	4
PINYIN_ASCII_TONE	8
PINYIN_NAME	16
PINYIN_KEEP_NUMBER	32
PINYIN_KEEP_ENGLISH	64
PINYIN_UMLAUT_V	128
PINYIN_KEEP_PUNCTUATION	256