错误语句:SELECT * FROM `tp_goods` WHERE `goods_id` IN (: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,:where_goods_id_in_227,:where_goods_id_in_228,:where_goods_id_in_229,:where_goods_id_in_230,:where_goods_id_in_231,:where_goods_id_in_232,:where_goods_id_in_233,:where_goods_id_in_234,:where_goods_id_in_235,:where_goods_id_in_236,:where_goods_id_in_237,:where_goods_id_in_238,:where_goods_id_in_239,:where_goods_id_in_240,:where_goods_id_in_241,:where_goods_id_in_242,:where_goods_id_in_243,:where_goods_id_in_244,:where_goods_id_in_245,:where_goods_id_in_246,:where_goods_id_in_247,:where_goods_id_in_248,:where_goods_id_in_249,:where_goods_id_in_250,:where_goods_id_in_251,:where_goods_id_in_252,:where_goods_id_in_253,:where_goods_id_in_254,:where_goods_id_in_255,:where_goods_id_in_256,:where_goods_id_in_257,:where_goods_id_in_258,:where_goods_id_in_259,:where_goods_id_in_260,:where_goods_id_in_261,:where_goods_id_in_262,:where_goods_id_in_263,:where_goods_id_in_264,:where_goods_id_in_265,:where_goods_id_in_266,:where_goods_id_in_267,:where_goods_id_in_268,:where_goods_id_in_269,:where_goods_id_in_270,:where_goods_id_in_271,:where_goods_id_in_272,:where_goods_id_in_273,:where_goods_id_in_274,:where_goods_id_in_275,:where_goods_id_in_276,:where_goods_id_in_277,:where_goods_id_in_278,:where_goods_id_in_279,:where_goods_id_in_280,:where_goods_id_in_281,:where_goods_id_in_282,:where_goods_id_in_283,:where_goods_id_in_284,:where_goods_id_in_285,:where_goods_id_in_286,:where_goods_id_in_287,:where_goods_id_in_288,:where_goods_id_in_289,:where_goods_id_in_290,:where_goods_id_in_291,:where_goods_id_in_292,:where_goods_id_in_293,:where_goods_id_in_294,:where_goods_id_in_295,:where_goods_id_in_296,:where_goods_id_in_297,:where_goods_id_in_298,:where_goods_id_in_299,:where_goods_id_in_300,:where_goods_id_in_301,:where_goods_id_in_302,:where_goods_id_in_303,:where_goods_id_in_304,:where_goods_id_in_305,:where_goods_id_in_306,:where_goods_id_in_307,:where_goods_id_in_308,:where_goods_id_in_309,:where_goods_id_in_310,:where_goods_id_in_311,:where_goods_id_in_312,:where_goods_id_in_313,:where_goods_id_in_314,:where_goods_id_in_315,:where_goods_id_in_316,:where_goods_id_in_317,:where_goods_id_in_318,:where_goods_id_in_319,:where_goods_id_in_320,:where_goods_id_in_321,:where_goods_id_in_322,:where_goods_id_in_323,:where_goods_id_in_324,:where_goods_id_in_325,:where_goods_id_in_326,:where_goods_id_in_327,:where_goods_id_in_328,:where_goods_id_in_329,:where_goods_id_in_330,:where_goods_id_in_331,:where_goods_id_in_332,:where_goods_id_in_333,:where_goods_id_in_334,:where_goods_id_in_335,:where_goods_id_in_336,:where_goods_id_in_337,:where_goods_id_in_338,:where_goods_id_in_339,:where_goods_id_in_340,:where_goods_id_in_341,:where_goods_id_in_342,:where_goods_id_in_343,:where_goods_id_in_344,:where_goods_id_in_345,:where_goods_id_in_346,:where_goods_id_in_347,:where_goods_id_in_348,:where_goods_id_in_349,:where_goods_id_in_350,:where_goods_id_in_351,:where_goods_id_in_352,:where_goods_id_in_353,:where_goods_id_in_354,:where_goods_id_in_355,:where_goods_id_in_356,:where_goods_id_in_357,:where_goods_id_in_358,:where_goods_id_in_359,:where_goods_id_in_360,:where_goods_id_in_361,:where_goods_id_in_362,:where_goods_id_in_363,:where_goods_id_in_364,:where_goods_id_in_365,:where_goods_id_in_366,:where_goods_id_in_367,:where_goods_id_in_368,:where_goods_id_in_369,:where_goods_id_in_370,:where_goods_id_in_371,:where_goods_id_in_372,:where_goods_id_in_373,:where_goods_id_in_374,:where_goods_id_in_375,:where_goods_id_in_376,:where_goods_id_in_377,:where_goods_id_in_378,:where_goods_id_in_379,:where_goods_id_in_380,:where_goods_id_in_381,:where_goods_id_in_382) ORDER BY `comment_` desc LIMIT 0,20

[10501] PDOException in Connection.php line 391

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

  1. // 调试结束
  2. $this->debug(false);
  3. // 返回结果集
  4. return $this->getResult($pdo, $procedure);
  5. } catch (\PDOException $e) {
  6. if ($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. } catch (\Throwable $e) {
  12. if ($this->isBreak($e)) {
  13. return $this->close()->query($sql, $bind, $master, $pdo);
  14. }
  15. echo '错误语句:'. $sql;
  16. throw $e;
  17. } catch (\Exception $e) {
  18. if ($this->isBreak($e)) {
  19. return $this->close()->query($sql, $bind, $master, $pdo);

Call Stack

  1. in Connection.php line 391
  2. at Connection->query('SELECT * FROM `tp_go...', ['where_goods_id_in_1' => ['200', 1], 'where_goods_id_in_2' => ['203', 1], 'where_goods_id_in_3' => ['204', 1], ...], false, false) in Query.php line 227
  3. at Query->query('SELECT * FROM `tp_go...', ['where_goods_id_in_1' => ['200', 1], 'where_goods_id_in_2' => ['203', 1], 'where_goods_id_in_3' => ['204', 1], ...], false, false) in Query.php line 2344
  4. at Query->select() in Goods.php line 189
  5. at Goods->goodsList()
  6. at ReflectionMethod->invokeArgs(object(Goods), []) in App.php line 346
  7. at App::invokeMethod([object(Goods), 'goodsList'], []) in App.php line 614
  8. at App::module(['Home', 'Goods', 'goodsList'], ['app_host' => '', 'app_debug' => true, 'app_trace' => false, ...], null) in App.php line 460
  9. at App::exec(['type' => 'module', 'module' => ['Home', 'Goods', 'goodsList']], ['app_host' => '', 'app_debug' => true, 'app_trace' => false, ...]) in App.php line 142
  10. at App::run() in start.php line 19
  11. at require('/usr/home/cj/hzcj/th...') in index.php line 50

Exception Datas

PDO Error Info
SQLSTATE 42S22
Driver Error Code 1054
Driver Error Message Unknown column 'comment_' in 'order clause'
Database Status
Error Code 10501
Error Message SQLSTATE[42S22]: Column not found: 1054 Unknown column 'comment_' in 'order clause'
Error SQL SELECT * FROM `tp_goods` WHERE `goods_id` IN (200,203,204,205,206,207,208,209,210,211,212,213,214,215,216,217,218,219,220,221,222,223,224,225,226,227,228,229,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,264,265,266,267,268,269,270,271,272,273,274,275,276,277,278,279,337,338,341,342,343,344,345,346,347,348,349,350,351,352,353,354,355,356,357,358,359,360,361,362,363,364,365,366,367,368,369,370,371,372,373,374,375,376,377,378,379,380,381,382,385,386,387,388,389,390,391,394,395,396,397,398,399,400,402,403,404,405,406,407,408,409,410,411,412,413,414,415,416,418,419,420,421,422,423,424,425,426,427,428,429,430,432,434,436,438,439,440,441,442,443,444,445,446,447,448,449,450,451,452,453,454,455,457,459,460,461,462,463,464,465,466,467,468,473,475,477,478,479,480,481,483,485,486,488,490,495,496,497,498,499,500,503,504,506,507,508,509,513,523,524,525,526,527,528,529,530,531,532,533,534,535,536,537,538,539,540,541,561,580,581,582,583,586,587,588,597,601,611,612,613,614,615,616,617,618,619,620,621,622,623,624,630,631,632,633,635,636,637,638,639,640,642,644,645,646,647,648,649,650,651,652,653,654,655,656,657,658,659,660,661,662,663,664,665,666,668,669,670,671,672,673,694,695,696,697,698,699,700,701,702,704,705,706,707,708,709,710,711,712,713,714,715,716,717,718,719,720,721,722,723,724,725,726,727,728,729,732,733,734,735,736,737,738,739,740,741,742,743,744,745,746,747,748,750,753,755,757,758,759,760,761,762,763,764,765,766,767,770,772,773,779,780,781,782,783,784,785,786,788,789) ORDER BY `comment_` desc LIMIT 0,20
Database Config
type mysql
hostname localhost
database cj_purchase
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
359
sort
comment_
POST Data
empty
Files
empty

Cookies

is_mobile
0
Session
empty

Server/Request Data

HOME
/nonexistent
USER
www
FCGI_ROLE
RESPONDER
SCRIPT_FILENAME
/home/cj/hzcj/index.php
QUERY_STRING
s=/Home/Goods/goodsList/id/359/sort/comment_count
REQUEST_METHOD
GET
CONTENT_TYPE
CONTENT_LENGTH
SCRIPT_NAME
/index.php
REQUEST_URI
/Home/Goods/goodsList/id/359/sort/comment_count
DOCUMENT_URI
/index.php
DOCUMENT_ROOT
/home/cj/hzcj
SERVER_PROTOCOL
HTTP/1.1
REQUEST_SCHEME
http
GATEWAY_INTERFACE
CGI/1.1
SERVER_SOFTWARE
nginx/1.12.1
REMOTE_ADDR
54.146.154.243
REMOTE_PORT
54858
SERVER_ADDR
172.18.175.231
SERVER_PORT
80
SERVER_NAME
www.gzcjgs.com
REDIRECT_STATUS
200
PATH_INFO
/Home/Goods/goodsList/id/359/sort/comment_count
HTTP_ACCEPT
*/*
HTTP_USER_AGENT
claudebot
HTTP_HOST
gzcjgs.com
PHP_SELF
/index.php
REQUEST_TIME_FLOAT
1711670630.865
REQUEST_TIME
1711670630
argv
[ "s=\/Home\/Goods\/goodsList\/id\/359\/sort\/comment_count" ]
argc
1

Environment Variables

HOME
/nonexistent
USER
www
FCGI_ROLE
RESPONDER
SCRIPT_FILENAME
/home/cj/hzcj/index.php
QUERY_STRING
s=/Home/Goods/goodsList/id/359/sort/comment_count
REQUEST_METHOD
GET
CONTENT_TYPE
CONTENT_LENGTH
SCRIPT_NAME
/index.php
REQUEST_URI
/Home/Goods/goodsList/id/359/sort/comment_count
DOCUMENT_URI
/index.php
DOCUMENT_ROOT
/home/cj/hzcj
SERVER_PROTOCOL
HTTP/1.1
REQUEST_SCHEME
http
GATEWAY_INTERFACE
CGI/1.1
SERVER_SOFTWARE
nginx/1.12.1
REMOTE_ADDR
54.146.154.243
REMOTE_PORT
54858
SERVER_ADDR
172.18.175.231
SERVER_PORT
80
SERVER_NAME
www.gzcjgs.com
REDIRECT_STATUS
200
PATH_INFO
HTTP_ACCEPT
*/*
HTTP_USER_AGENT
claudebot
HTTP_HOST
gzcjgs.com
PHP_SELF
/index.php
REQUEST_TIME_FLOAT
1711670630.865
REQUEST_TIME
1711670630
argv
[ "s=\/Home\/Goods\/goodsList\/id\/359\/sort\/comment_count" ]
argc
1

ThinkPHP Constants

PLUGIN_PATH
/usr/home/cj/hzcj/plugins/
UPLOAD_PATH
public/upload/
TPSHOP_CACHE_TIME
1
SITE_URL
http://gzcjgs.com
INSTALL_DATE
1463741583
SERIALNUMBER
20160520065303oCWIoa
APP_PATH
/usr/home/cj/hzcj/application/
NOW_TIME
1711670630
THINK_VERSION
5.0.15
THINK_START_TIME
1711670630.8656
THINK_START_MEM
275944
EXT
.php
DS
/
THINK_PATH
/usr/home/cj/hzcj/thinkphp/
LIB_PATH
/usr/home/cj/hzcj/thinkphp/library/
CORE_PATH
/usr/home/cj/hzcj/thinkphp/library/think/
TRAIT_PATH
/usr/home/cj/hzcj/thinkphp/library/traits/
ROOT_PATH
/usr/home/cj/hzcj/
EXTEND_PATH
/usr/home/cj/hzcj/extend/
VENDOR_PATH
/usr/home/cj/hzcj/vendor/
RUNTIME_PATH
/usr/home/cj/hzcj/runtime/
LOG_PATH
/usr/home/cj/hzcj/runtime/log/
CACHE_PATH
/usr/home/cj/hzcj/runtime/cache/
TEMP_PATH
/usr/home/cj/hzcj/runtime/temp/
CONF_PATH
/usr/home/cj/hzcj/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