[0] Exception in Mysql.php line 113

不支持的数据表达式:rand()

  1. if ('__TABLE__' == $table) {
  2. $table = $this->query->getTable();
  3. }
  4. if (isset($options['alias'][$table])) {
  5. $table = $options['alias'][$table];
  6. }
  7. }
  8. if ($strict && !preg_match('/^[\w\.\*]+$/', $key)) {
  9. throw new Exception('not support data:' . $key);
  10. }
  11. if ('*' != $key && ($strict || !preg_match('/[,\'\"\*\(\)`.\s]/', $key))) {
  12. $key = '`' . $key . '`';
  13. }
  14. if (isset($table)) {
  15. if (strpos($table, '.')) {
  16. $table = str_replace('.', '`.`', $table);
  17. }
  18. $key = '`' . $table . '`.' . $key;

Call Stack

  1. in Mysql.php line 113
  2. at Mysql->parseKey('rand()', ['multi' => ['AND' => ['gc_id_1' => [1], 'goods_id' => [['neq', 65]]]], 'where' => ['AND' => ['gc_id_1' => 1, 'goods_id' => ['neq', 65]]], 'order' => ['rand()'], ...], true) in Builder.php line 596
  3. at Builder->parseOrder(['rand()'], ['multi' => ['AND' => ['gc_id_1' => [1], 'goods_id' => [['neq', 65]]]], 'where' => ['AND' => ['gc_id_1' => 1, 'goods_id' => ['neq', 65]]], 'order' => ['rand()'], ...]) in Builder.php line 722
  4. at Builder->select(['multi' => ['AND' => ['gc_id_1' => [1], 'goods_id' => [['neq', 65]]]], 'where' => ['AND' => ['gc_id_1' => 1, 'goods_id' => ['neq', 65]]], 'order' => ['rand()'], ...]) in Query.php line 2511
  5. at Query->select() in Goods.php line 104
  6. at Goods->getGoodsGcRandList(1, 65, 2) in Goods.php line 38
  7. at Goods->index()
  8. at ReflectionMethod->invokeArgs(object(Goods), []) in App.php line 343
  9. at App::invokeMethod([object(Goods), 'index'], []) in App.php line 611
  10. at App::module(['home', 'goods', 'index'], ['app_host' => '', 'app_debug' => true, 'app_trace' => false, ...], null) in App.php line 457
  11. at App::exec(['type' => 'module', 'module' => ['home', 'goods', 'index']], ['app_host' => '', 'app_debug' => true, 'app_trace' => false, ...]) in App.php line 139
  12. at App::run() in start.php line 19
  13. at require('D:\wwwroot\LyCases\D...') in index.php line 17

Environment Variables

GET Data
empty
POST Data
empty
Files
empty

Cookies

cart_goods_num
0
Session
empty

Server/Request Data

_FCGI_X_PIPE_
\\.\pipe\IISFCGI-917d05dc-0729-44ad-8896-a6135ae72bd6
PHP_FCGI_MAX_REQUESTS
200
PHPRC
D:\Program Files\php56\
ALLUSERSPROFILE
C:\ProgramData
APPDATA
C:\Windows\system32\config\systemprofile\AppData\Roaming
APP_POOL_CONFIG
C:\inetpub\temp\apppools\DSShop\DSShop.config
APP_POOL_ID
DSShop
CommonProgramFiles
C:\Program Files\Common Files
CommonProgramFiles(x86)
C:\Program Files (x86)\Common Files
CommonProgramW6432
C:\Program Files\Common Files
COMPUTERNAME
iZ25c0h3kjrZ
ComSpec
C:\Windows\system32\cmd.exe
FP_NO_HOST_CHECK
NO
LOCALAPPDATA
C:\Windows\system32\config\systemprofile\AppData\Local
NUMBER_OF_PROCESSORS
4
OS
Windows_NT
Path
C:\Windows\system32;C:\Windows;C:\Windows\System32\Wbem;C:\Windows\System32\WindowsPowerShell\v1.0\;D:\Program Files\Redis;D:\Program Files\MySQL\MySQL Server 5.6\bin;D:\Program Files (x86)\Microsoft SQL Server\150\DTS\Binn\;C:\unoconv\;D:\Program Files\php56\;D:\Program Files\LibreOfficePortable;D:\ZKEYS\server\PHP\php\5.2;D:\ZKEYS\server\PHP\php\5.3;D:\ZKEYS\server\PHP\php\5.4;D:\ZKEYS\server\PHP\php\5.5;D:\ZKEYS\server\PHP\php\5.6;D:\ZKEYS\server\PHP\php\7.0;D:\ZKEYS\server\PHP\php\7.1;D:\ZKEYS\server\PHP\php\7.2;D:\ZKEYS\server\PHP\php\7.3;D:\ZKEYS\server\PHP\php\7.4;D:\ZKEYS\server\PHP\php\8.0;
PATHEXT
.COM;.EXE;.BAT;.CMD;.VBS;.VBE;.JS;.JSE;.WSF;.WSH;.MSC
PROCESSOR_ARCHITECTURE
AMD64
PROCESSOR_IDENTIFIER
Intel64 Family 6 Model 85 Stepping 4, GenuineIntel
PROCESSOR_LEVEL
6
PROCESSOR_REVISION
5504
ProgramData
C:\ProgramData
ProgramFiles
C:\Program Files
ProgramFiles(x86)
C:\Program Files (x86)
ProgramW6432
C:\Program Files
PSModulePath
C:\Program Files\WindowsPowerShell\Modules;C:\Windows\system32\WindowsPowerShell\v1.0\Modules
PUBLIC
C:\Users\Public
SystemDrive
C:
SystemRoot
C:\Windows
TEMP
C:\Windows\TEMP
TMP
C:\Windows\TEMP
USERDOMAIN
WORKGROUP
USERNAME
iZ25c0h3kjrZ$
USERPROFILE
C:\Windows\system32\config\systemprofile
windir
C:\Windows
ORIG_PATH_INFO
/index.php/home/goods/index/goods_id/65.html
URL
/index.php
SERVER_SOFTWARE
Microsoft-IIS/8.5
SERVER_PROTOCOL
HTTP/1.1
SERVER_PORT_SECURE
0
SERVER_PORT
80
SERVER_NAME
shop.ha185.com.cn
SCRIPT_NAME
/index.php
SCRIPT_FILENAME
D:\wwwroot\LyCases\DSShop\public\index.php
REQUEST_URI
/index.php/home/goods/index/goods_id/65.html
REQUEST_METHOD
GET
REMOTE_USER
REMOTE_PORT
42590
REMOTE_HOST
34.203.221.104
REMOTE_ADDR
34.203.221.104
QUERY_STRING
PATH_TRANSLATED
D:\wwwroot\LyCases\DSShop\public\index.php\home\goods\index\goods_id\65.html
PATH_INFO
/home/goods/index/goods_id/65.html
LOGON_USER
LOCAL_ADDR
172.17.10.30
INSTANCE_META_PATH
/LM/W3SVC/23
INSTANCE_NAME
DSSHOP
INSTANCE_ID
23
HTTPS_SERVER_SUBJECT
HTTPS_SERVER_ISSUER
HTTPS_SECRETKEYSIZE
HTTPS_KEYSIZE
HTTPS
off
GATEWAY_INTERFACE
CGI/1.1
DOCUMENT_ROOT
D:\wwwroot\LyCases\DSShop\public
CONTENT_TYPE
CONTENT_LENGTH
0
CERT_SUBJECT
CERT_SERIALNUMBER
CERT_ISSUER
CERT_FLAGS
CERT_COOKIE
AUTH_USER
AUTH_PASSWORD
AUTH_TYPE
APPL_PHYSICAL_PATH
D:\wwwroot\LyCases\DSShop\public\
APPL_MD_PATH
/LM/W3SVC/23/ROOT
IIS_UrlRewriteModule
7.1.0871.0
WEBSOCKET_VERSION
13
HTTP_USER_AGENT
claudebot
HTTP_HOST
shop.ha185.com.cn
HTTP_ACCEPT
*/*
FCGI_ROLE
RESPONDER
PHP_SELF
/index.php/home/goods/index/goods_id/65.html
REQUEST_TIME_FLOAT
1711653133.9741
REQUEST_TIME
1711653133
Environment Variables
empty

ThinkPHP Constants

APP_PATH
D:\wwwroot\LyCases\DSShop\public/../application/
THINK_VERSION
5.0.24
THINK_START_TIME
1711653133.9747
THINK_START_MEM
269048
EXT
.php
DS
\
THINK_PATH
D:\wwwroot\LyCases\DSShop\thinkphp\
LIB_PATH
D:\wwwroot\LyCases\DSShop\thinkphp\library\
CORE_PATH
D:\wwwroot\LyCases\DSShop\thinkphp\library\think\
TRAIT_PATH
D:\wwwroot\LyCases\DSShop\thinkphp\library\traits\
ROOT_PATH
D:\wwwroot\LyCases\DSShop\
EXTEND_PATH
D:\wwwroot\LyCases\DSShop\extend\
VENDOR_PATH
D:\wwwroot\LyCases\DSShop\vendor\
RUNTIME_PATH
D:\wwwroot\LyCases\DSShop\runtime\
LOG_PATH
D:\wwwroot\LyCases\DSShop\runtime\log\
CACHE_PATH
D:\wwwroot\LyCases\DSShop\runtime\cache\
TEMP_PATH
D:\wwwroot\LyCases\DSShop\runtime\temp\
CONF_PATH
D:\wwwroot\LyCases\DSShop\public/../application/
CONF_EXT
.php
ENV_PREFIX
PHP_
IS_CLI
false
IS_WIN
true
BASE_SITE_ROOT
PLUGINS_SITE_ROOT
/static/plugins
ADMIN_SITE_ROOT
/static/admin
HOME_SITE_ROOT
/static/home
REWRITE_MODEL
false
BASE_SITE_URL
http://shop.ha185.com.cn/index.php
HOME_SITE_URL
http://shop.ha185.com.cn/index.php/home
ADMIN_SITE_URL
http://shop.ha185.com.cn/index.php/admin
MOBILE_SITE_URL
http://shop.ha185.com.cn/index.php/mobile
WAP_SITE_URL
http://shop.ha185.com.cn/
UPLOAD_SITE_URL
http://shop.ha185.com.cn/uploads
EXAMPLES_SITE_URL
http://shop.ha185.com.cn/examples
SESSION_EXPIRE
3600
PUBLIC_PATH
D:\wwwroot\LyCases\DSShop\public
PLUGINS_PATH
D:\wwwroot\LyCases\DSShop\plugins
BASE_DATA_PATH
D:\wwwroot\LyCases\DSShop\public/data
BASE_UPLOAD_PATH
D:\wwwroot\LyCases\DSShop\public/uploads
TIMESTAMP
1711653133
DIR_HOME
home
DIR_ADMIN
admin
DIR_MOBILE
mobile
DIR_WAP
wap
DIR_UPLOAD
public/uploads
ATTACH_PATH
home
ATTACH_COMMON
home/common
ATTACH_AVATAR
home/avatar
ATTACH_INVITER
home/inviter
ATTACH_EDITOR
home/editor
ATTACH_MEMBERTAG
home/membertag
ATTACH_GOODS
home/store/goods
ATTACH_LOGIN
home/login
ATTACH_WAYBILL
home/waybill
ATTACH_ARTICLE
home/article
ATTACH_BRAND
home/brand
ATTACH_GOODS_CLASS
home/goods_class
ATTACH_ADV
home/adv
ATTACH_APPADV
home/appadv
ATTACH_ACTIVITY
home/activity
ATTACH_WATERMARK
home/watermark
ATTACH_POINTPROD
home/pointprod
ATTACH_GROUPBUY
home/groupbuy
ATTACH_VOUCHER
home/voucher
ATTACH_MOBILE
mobile
ATTACH_MALBUM
home/member
TPL_SHOP_NAME
default
TPL_ADMIN_NAME
default
TPL_DELIVERY_NAME
default
TPL_MEMBER_NAME
default
DEFAULT_CONNECT_SMS_TIME
60
MD5_KEY
a2382918dbb49c8643f19bc3ab90ecf9
CHARSET
UTF-8
ALLOW_IMG_EXT
jpg,png,gif,bmp,jpeg
HTTP_TYPE
http://
DEFAULT_SPEC_COLOR_ID
1
GOODS_IMAGES_WIDTH
240,480,1280
GOODS_IMAGES_HEIGHT
240,480,1280
GOODS_IMAGES_EXT
_240,_480,_1280
COMMON_IMAGES_EXT
_small,_normal,_big
ORDER_STATE_CANCEL
0
ORDER_STATE_NEW
10
ORDER_STATE_PAY
20
ORDER_STATE_SEND
30
ORDER_STATE_SUCCESS
40
ORDER_DEL_STATE_DEFAULT
0
ORDER_DEL_STATE_DELETE
1
ORDER_DEL_STATE_DROP
2
ORDER_EVALUATE_TIME
1296000
OFFLINE_ORDER_CANCEL_TIME
3