错误语句:SELECT * FROM `tp_goods` `g` INNER JOIN `tp_store` `s` ON `s`.`store_id`=`g`.`store_id` WHERE `goods_id` IN (:where_goods_id_in_0,:where_goods_id_in_1,:where_goods_id_in_2,:where_goods_id_in_3,:where_goods_id_in_4,:where_goods_id_in_5,:where_goods_id_in_6,:where_goods_id_in_7,:where_goods_id_in_8,:where_goods_id_in_9,:where_goods_id_in_10,:where_goods_id_in_11,:where_goods_id_in_12,:where_goods_id_in_13,:where_goods_id_in_14,:where_goods_id_in_15,:where_goods_id_in_16,:where_goods_id_in_17,:where_goods_id_in_18,:where_goods_id_in_19,:where_goods_id_in_20,:where_goods_id_in_21,:where_goods_id_in_22,:where_goods_id_in_23,:where_goods_id_in_24,:where_goods_id_in_25,:where_goods_id_in_26,:where_goods_id_in_27,:where_goods_id_in_28,:where_goods_id_in_29,:where_goods_id_in_30,:where_goods_id_in_31,:where_goods_id_in_32,:where_goods_id_in_33,:where_goods_id_in_34,:where_goods_id_in_35,:where_goods_id_in_36,:where_goods_id_in_37,:where_goods_id_in_38,:where_goods_id_in_39,:where_goods_id_in_40,:where_goods_id_in_41,:where_goods_id_in_42,:where_goods_id_in_43,:where_goods_id_in_44,:where_goods_id_in_45,:where_goods_id_in_46,:where_goods_id_in_47,:where_goods_id_in_48,:where_goods_id_in_49,:where_goods_id_in_50,:where_goods_id_in_51,:where_goods_id_in_52,:where_goods_id_in_53,:where_goods_id_in_54,:where_goods_id_in_55,:where_goods_id_in_56,:where_goods_id_in_57,:where_goods_id_in_58,:where_goods_id_in_59,:where_goods_id_in_60,:where_goods_id_in_61,:where_goods_id_in_62,:where_goods_id_in_63,:where_goods_id_in_64,:where_goods_id_in_65,:where_goods_id_in_66,:where_goods_id_in_67,:where_goods_id_in_68,:where_goods_id_in_69,:where_goods_id_in_70,:where_goods_id_in_71,:where_goods_id_in_72,:where_goods_id_in_73,:where_goods_id_in_74,:where_goods_id_in_75,:where_goods_id_in_76,:where_goods_id_in_77,:where_goods_id_in_78,:where_goods_id_in_79,:where_goods_id_in_80,:where_goods_id_in_81,:where_goods_id_in_82,:where_goods_id_in_83,:where_goods_id_in_84,:where_goods_id_in_85,:where_goods_id_in_86,:where_goods_id_in_87,:where_goods_id_in_88,:where_goods_id_in_89,:where_goods_id_in_90,:where_goods_id_in_91,:where_goods_id_in_92,:where_goods_id_in_93,:where_goods_id_in_94,:where_goods_id_in_95,:where_goods_id_in_96,:where_goods_id_in_97,:where_goods_id_in_98,:where_goods_id_in_99,:where_goods_id_in_100,:where_goods_id_in_101,:where_goods_id_in_102,:where_goods_id_in_103,:where_goods_id_in_104,:where_goods_id_in_105,:where_goods_id_in_106,:where_goods_id_in_107,:where_goods_id_in_108,:where_goods_id_in_109,:where_goods_id_in_110,:where_goods_id_in_111,:where_goods_id_in_112,:where_goods_id_in_113,:where_goods_id_in_114,:where_goods_id_in_115,:where_goods_id_in_116,:where_goods_id_in_117,:where_goods_id_in_118,:where_goods_id_in_119,:where_goods_id_in_120,:where_goods_id_in_121,:where_goods_id_in_122,:where_goods_id_in_123,:where_goods_id_in_124,:where_goods_id_in_125,:where_goods_id_in_126,:where_goods_id_in_127,:where_goods_id_in_128,:where_goods_id_in_129,:where_goods_id_in_130,:where_goods_id_in_131,:where_goods_id_in_132,:where_goods_id_in_133,:where_goods_id_in_134,:where_goods_id_in_135,:where_goods_id_in_136,:where_goods_id_in_137,:where_goods_id_in_138,:where_goods_id_in_139,:where_goods_id_in_140,:where_goods_id_in_141,:where_goods_id_in_142,:where_goods_id_in_143,:where_goods_id_in_144,:where_goods_id_in_145,:where_goods_id_in_146,:where_goods_id_in_147,:where_goods_id_in_148,:where_goods_id_in_149,:where_goods_id_in_150,:where_goods_id_in_151,:where_goods_id_in_152,:where_goods_id_in_153,:where_goods_id_in_154,:where_goods_id_in_155,:where_goods_id_in_156,:where_goods_id_in_157,:where_goods_id_in_158,:where_goods_id_in_159,:where_goods_id_in_160,:where_goods_id_in_161,:where_goods_id_in_162,:where_goods_id_in_163,:where_goods_id_in_164,:where_goods_id_in_165,:where_goods_id_in_166,:where_goods_id_in_167,:where_goods_id_in_168,:where_goods_id_in_169,:where_goods_id_in_170,:where_goods_id_in_171,:where_goods_id_in_172,:where_goods_id_in_173,:where_goods_id_in_174,:where_goods_id_in_175,:where_goods_id_in_176,:where_goods_id_in_177,:where_goods_id_in_178,:where_goods_id_in_179,:where_goods_id_in_180,:where_goods_id_in_181,:where_goods_id_in_182,:where_goods_id_in_183,:where_goods_id_in_184,:where_goods_id_in_185,:where_goods_id_in_186,:where_goods_id_in_187,:where_goods_id_in_188,:where_goods_id_in_189,:where_goods_id_in_190,:where_goods_id_in_191,:where_goods_id_in_192,:where_goods_id_in_193,:where_goods_id_in_194,:where_goods_id_in_195,:where_goods_id_in_196,:where_goods_id_in_197,:where_goods_id_in_198,:where_goods_id_in_199,:where_goods_id_in_200,:where_goods_id_in_201,:where_goods_id_in_202,:where_goods_id_in_203,:where_goods_id_in_204,:where_goods_id_in_205,:where_goods_id_in_206,:where_goods_id_in_207,:where_goods_id_in_208,:where_goods_id_in_209,:where_goods_id_in_210,:where_goods_id_in_211,:where_goods_id_in_212,:where_goods_id_in_213,:where_goods_id_in_214,:where_goods_id_in_215,:where_goods_id_in_216,:where_goods_id_in_217,:where_goods_id_in_218,:where_goods_id_in_219,:where_goods_id_in_220,:where_goods_id_in_221,:where_goods_id_in_222,:where_goods_id_in_223,:where_goods_id_in_224,:where_goods_id_in_225,:where_goods_id_in_226) ORDER BY 357 asc LIMIT 0,40

[10501] PDOException in Connection.php line 404

SQLSTATE[42S22]: Column not found: 1054 Unknown column '357' in 'order clause'

  1. // 调试结束
  2. $this->debug(false);
  3. // 返回结果集
  4. return $this->getResult($pdo, $procedure);
  5. } catch (\PDOException $e) {
  6. if ($this->config['break_reconnect'] && $this->isBreak($e)) {
  7. return $this->close()->query($sql, $bind, $master, $pdo);
  8. }
  9. echo '错误语句:'. $sql;
  10. throw new PDOException($e, $this->config, $this->getLastsql());
  11. }
  12. }
  13. /**
  14. * 执行语句
  15. * @access public
  16. * @param string $sql sql指令
  17. * @param array $bind 参数绑定
  18. * @return int

Call Stack

  1. in Connection.php line 404
  2. at Connection->query('SELECT * FROM `tp_go...', ['where_goods_id_in_0' => ['24', 1], 'where_goods_id_in_1' => ['25', 1], 'where_goods_id_in_2' => ['29', 1], ...], false, false) in Query.php line 225
  3. at Query->query('SELECT * FROM `tp_go...', ['where_goods_id_in_0' => ['24', 1], 'where_goods_id_in_1' => ['25', 1], 'where_goods_id_in_2' => ['29', 1], ...], false, false) in Query.php line 2299
  4. at Query->select() in Query.php line 1323
  5. at Query->paginate(['list_rows' => 40, 'page' => 1, 'query' => '']) in Goods.php line 303
  6. at Goods->goodsList()
  7. at ReflectionMethod->invokeArgs(object(Goods), []) in App.php line 227
  8. at App::invokeMethod([object(Goods), 'goodsList'], []) in App.php line 405
  9. at App::module(['Home', 'Goods', 'goodsList'], ['app_namespace' => 'app', 'app_debug' => true, 'app_trace' => false, ...], false) in App.php line 133
  10. at App::run() in start.php line 18
  11. at require('/www/wwwroot/guangdi...') in index.php line 54

Exception Datas

PDO Error Info
SQLSTATE 42S22
Driver Error Code 1054
Driver Error Message Unknown column '357' in 'order clause'
Database Status
Error Code 10501
Error Message SQLSTATE[42S22]: Column not found: 1054 Unknown column '357' in 'order clause'
Error SQL SELECT * FROM `tp_goods` `g` INNER JOIN `tp_store` `s` ON `s`.`store_id`=`g`.`store_id` WHERE `goods_id` IN (24,25,29,30,31,35,36,37,38,39,42,44,45,46,48,49,51,52,53,54,56,57,61,62,64,66,67,68,69,70,72,73,74,75,76,77,78,79,80,81,82,84,85,87,88,89,90,92,94,95,96,97,98,99,100,101,102,103,104,105,106,107,108,109,110,111,112,113,114,116,117,118,120,121,122,123,124,125,126,127,128,133,136,137,139,140,142,143,144,145,146,147,148,151,153,154,155,156,157,159,160,161,162,163,164,165,166,167,168,169,170,172,173,174,176,177,178,179,180,181,182,183,184,185,186,187,188,189,192,197,198,199,200,202,203,205,206,207,208,209,210,211,212,213,214,215,216,217,218,219,220,221,222,223,224,225,226,227,230,231,232,233,234,235,236,237,238,239,240,241,242,243,244,245,246,247,248,249,250,251,252,253,254,255,256,257,258,259,260,261,262,263,264,265,266,267,268,269,270,271,272,273,274,275,276,277,278,279,280,281,282,283,284,285,286,287,288,289,290,291,292,293,294,295,296,297,298) ORDER BY 357 asc LIMIT 0,40
Database Config
type mysql
hostname 139.159.251.101
database guangdiancheng
username guangdiancheng
password iz4XAEyBLzAT33k5
hostport 3306
dsn
params []
charset utf8
prefix tp_
debug true
deploy 0
rw_separate false
master_num 1
slave_no
fields_strict true
result_type 2
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

Environment Variables

GET Data

id
brand_id
sort
357
POST Data
empty
Files
empty

Cookies

is_mobile
0
Session
empty

Server/Request Data

USER
www
HOME
/home/www
FCGI_ROLE
RESPONDER
SCRIPT_FILENAME
/www/wwwroot/guangdiancheng.com/index.php
QUERY_STRING
s=/goodsList/brand_id/357.html
REQUEST_METHOD
GET
CONTENT_TYPE
CONTENT_LENGTH
SCRIPT_NAME
/index.php
REQUEST_URI
/goodsList/brand_id/357.html
DOCUMENT_URI
/index.php
DOCUMENT_ROOT
/www/wwwroot/guangdiancheng.com
SERVER_PROTOCOL
HTTP/1.1
REQUEST_SCHEME
http
GATEWAY_INTERFACE
CGI/1.1
SERVER_SOFTWARE
nginx/1.22.1
REMOTE_ADDR
35.173.178.60
REMOTE_PORT
41220
SERVER_ADDR
192.168.0.199
SERVER_PORT
80
SERVER_NAME
www.guangdiancheng.com
REDIRECT_STATUS
200
PATH_INFO
/goodsList/brand_id/357.html
HTTP_ACCEPT
*/*
HTTP_USER_AGENT
claudebot
HTTP_HOST
www.guangdiancheng.com
PHP_SELF
/index.php
REQUEST_TIME_FLOAT
1711667897.9747
REQUEST_TIME
1711667897
Environment Variables
empty

ThinkPHP Constants

PLUGIN_PATH
/www/wwwroot/guangdiancheng.com/plugins/
UPLOAD_PATH
public/upload/
TPSHOP_CACHE_TIME
31104000
SITE_URL
http://www.guangdiancheng.com
INSTALL_DATE
1463741583
SERIALNUMBER
20160520065303oCWIoa
APP_PATH
/www/wwwroot/guangdiancheng.com/application/
NOW_TIME
1711667897
THINK_VERSION
5.0.7
THINK_START_TIME
1711667897.975
THINK_START_MEM
273168
EXT
.php
DS
/
THINK_PATH
/www/wwwroot/guangdiancheng.com/thinkphp/
LIB_PATH
/www/wwwroot/guangdiancheng.com/thinkphp/library/
CORE_PATH
/www/wwwroot/guangdiancheng.com/thinkphp/library/think/
TRAIT_PATH
/www/wwwroot/guangdiancheng.com/thinkphp/library/traits/
ROOT_PATH
/www/wwwroot/guangdiancheng.com/
EXTEND_PATH
/www/wwwroot/guangdiancheng.com/extend/
VENDOR_PATH
/www/wwwroot/guangdiancheng.com/vendor/
RUNTIME_PATH
/www/wwwroot/guangdiancheng.com/runtime/
LOG_PATH
/www/wwwroot/guangdiancheng.com/runtime/log/
CACHE_PATH
/www/wwwroot/guangdiancheng.com/runtime/cache/
TEMP_PATH
/www/wwwroot/guangdiancheng.com/runtime/temp/
CONF_PATH
/www/wwwroot/guangdiancheng.com/application/
CONF_EXT
.php
ENV_PREFIX
PHP_
IS_CLI
false
IS_WIN
false
IS_AJAX
false
IS_GET
true
IS_POST
false
MODULE_NAME
home
CONTROLLER_NAME
Goods
ACTION_NAME
goodsList
PREFIX
tp_
SESSION_ID