查询速度很慢

cxc_forever

2018-09-06 11:42:27 [SQL Time]sql 执行时间：8685ms, exec KSQL: SELECT BAS_StockArchives,BAS_StockArchives.version as version,BAS_StockArchives.fCustomerCode as fCustomerCode,BAS_StockArchives.fStockCode as fStockCode,BAS_StockArchives.fStockName as fStockName,BAS_StockArchives.fNormsType as fNormsType,BAS_StockArchives.fUnitName as fUnitName,BAS_StockArchives.fMnemonicCode as fMnemonicCode  FROM BAS_StockArchives BAS_StockArchives WHERE (BAS_StockArchives.fEnabled = 1 and length(BAS_StockArchives.fStockCode) > 10) ORDER BY BAS_StockArchives.fStockCode asc LIMIT 0, 20
  --> sql:SELECT  BAS_StockArchives.fID, BAS_StockArchives.FCUSTOMERCODE AS fCustomerCode, BAS_StockArchives.FMNEMONICCODE AS fMnemonicCode, BAS_StockArchives.FNORMSTYPE AS fNormsType, BAS_StockArchives.FSTOCKCODE AS fStockCode, BAS_StockArchives.FSTOCKNAME AS fStockName, BAS_StockArchives.FUNITNAME AS fUnitName, BAS_StockArchives.VERSION AS version FROM BAS_StockArchives BAS_StockArchives  WHERE  (BAS_StockArchives.FENABLED = ?) AND (CHAR_LENGTH(BAS_StockArchives.FSTOCKCODE) > ?)   ORDER BY BAS_StockArchives.FSTOCKCODE ASC
--> binds:[1, 10]

这张表大概1万8千条数据，但是现在查20条都很慢，数据库是mysql8.0    我用workbench只要1秒不到，在用平台做界面展示需要8秒多

jishuang

http://docs.wex5.com/bex5-deploy-question-list-10027/

cxc_forever

jishuang 发表于 2018-9-6 13:29
http://docs.wex5.com/bex5-deploy-question-list-10027/

结帖