锡锭库存最新消息_库存查询_库存数据分析(2025-10-09)

基础金属	铜电解铜铜精矿铜管铜棒废铜铜排铜合金精铜杆再生铜杆铜板带铝铝土矿氧化铝电解铝铝辅料铝棒铝合金锭废铝铝杆铝型材铝板卷铅铅精矿铅锭铅蓄电池再生精铅还原铅废铅蓄电池铅合金锌锌精矿电解锌锌合金氧化锌锌粉锡锡精矿锡锭锡材
稀有金属	稀土稀土矿稀土氧化物稀土金属钕铁硼稀散金属锑铋铟锗镓硒钽锆贵金属白银钨钨精矿钨粉碳化钨钨酸钠钨条钨铁钨材钼钼精矿工业氧化钼钼铁钼化工高纯三氧化钼钼金属钛钛精矿钛渣四氯化钛海绵钛钛金属钛白粉
新能源	锂锂矿锂化合物金属锂镍镍矿镍铁精炼镍镍盐高冰镍 MHP 钴电解钴钴粉氯化钴四氧化三钴硫酸钴钴中间品氧化钴碳酸钴钴酸锂锰锰矿电解锰电池级硫酸锰锂电正负极三元前驱体磷酸铁正极材料石油焦针状焦包覆沥青人造石墨硅碳负极硅氧负极电解液隔膜隔膜电解液电芯

三级分类	片区	省份	城市	库存	涨跌	单位
锡锭	华东	上海	上海	2152	-459	吨
锡锭	华东	江苏	—	739	-132	吨
锡锭	华东	山东	—	40	-40	吨
锡锭	华北	天津	天津	130	-30	吨
锡锭	华南	广东	—	5289	-734	吨

基本文件流程错误 SQL 调试

/websites/wwwroot/cmcc/public/index.php ( 0.75 KB )
/websites/wwwroot/cmcc/thinkphp/start.php ( 0.72 KB )
/websites/wwwroot/cmcc/thinkphp/base.php ( 2.60 KB )
/websites/wwwroot/cmcc/thinkphp/library/think/Loader.php ( 21.07 KB )
/websites/wwwroot/cmcc/thinkphp/library/think/Error.php ( 3.75 KB )
/websites/wwwroot/cmcc/thinkphp/library/think/Config.php ( 6.38 KB )
/websites/wwwroot/cmcc/thinkphp/convention.php ( 10.37 KB )
/websites/wwwroot/cmcc/thinkphp/library/think/App.php ( 21.51 KB )
/websites/wwwroot/cmcc/thinkphp/library/think/Request.php ( 49.78 KB )
/websites/wwwroot/cmcc/application/config.php ( 10.22 KB )
/websites/wwwroot/cmcc/application/database.php ( 1.96 KB )
/websites/wwwroot/cmcc/thinkphp/library/think/Hook.php ( 4.71 KB )
/websites/wwwroot/cmcc/application/tags.php ( 0.96 KB )
/websites/wwwroot/cmcc/application/common.php ( 28.86 KB )
/websites/wwwroot/cmcc/thinkphp/library/think/Env.php ( 1.21 KB )
/websites/wwwroot/cmcc/thinkphp/helper.php ( 17.30 KB )
/websites/wwwroot/cmcc/thinkphp/library/think/Lang.php ( 7.41 KB )
/websites/wwwroot/cmcc/thinkphp/library/think/Log.php ( 6.05 KB )
/websites/wwwroot/cmcc/thinkphp/lang/zh-cn.php ( 11.81 KB )
/websites/wwwroot/cmcc/application/route.php ( 2.86 KB )
/websites/wwwroot/cmcc/thinkphp/library/think/Route.php ( 60.23 KB )
/websites/wwwroot/cmcc/application/index/controller/Store.php ( 17.14 KB )
/websites/wwwroot/cmcc/application/index/controller/Base.php ( 3.63 KB )
/websites/wwwroot/cmcc/thinkphp/library/think/Controller.php ( 6.07 KB )
/websites/wwwroot/cmcc/thinkphp/library/traits/controller/Jump.php ( 4.90 KB )
/websites/wwwroot/cmcc/thinkphp/library/think/View.php ( 6.77 KB )
/websites/wwwroot/cmcc/thinkphp/library/think/view/driver/Think.php ( 5.64 KB )
/websites/wwwroot/cmcc/thinkphp/library/think/Template.php ( 44.90 KB )
/websites/wwwroot/cmcc/thinkphp/library/think/template/driver/File.php ( 2.24 KB )
/websites/wwwroot/cmcc/application/common/library/RedisUtil.php ( 0.83 KB )
/websites/wwwroot/cmcc/thinkphp/library/think/Cache.php ( 6.10 KB )
/websites/wwwroot/cmcc/thinkphp/library/think/cache/driver/Redis.php ( 6.54 KB )
/websites/wwwroot/cmcc/thinkphp/library/think/cache/Driver.php ( 5.98 KB )
/websites/wwwroot/cmcc/application/admin/model/Para.php ( 0.09 KB )
/websites/wwwroot/cmcc/thinkphp/library/think/Model.php ( 69.14 KB )
/websites/wwwroot/cmcc/thinkphp/library/think/Db.php ( 6.67 KB )
/websites/wwwroot/cmcc/thinkphp/library/think/db/connector/Mysql.php ( 3.89 KB )
/websites/wwwroot/cmcc/thinkphp/library/think/db/Connection.php ( 29.97 KB )
/websites/wwwroot/cmcc/thinkphp/library/think/db/Query.php ( 93.77 KB )
/websites/wwwroot/cmcc/thinkphp/library/think/db/builder/Mysql.php ( 4.53 KB )
/websites/wwwroot/cmcc/thinkphp/library/think/db/Builder.php ( 31.55 KB )
/websites/wwwroot/cmcc/thinkphp/library/think/Debug.php ( 7.13 KB )
/websites/wwwroot/cmcc/application/admin/model/Cate.php ( 0.59 KB )
/websites/wwwroot/cmcc/application/admin/model/Area.php ( 0.09 KB )
/websites/wwwroot/cmcc/application/admin/model/News.php ( 3.74 KB )
/websites/wwwroot/cmcc/application/common/consts/NewsConst.php ( 0.28 KB )
/websites/wwwroot/cmcc/application/admin/model/IndexCate.php ( 0.45 KB )
/websites/wwwroot/cmcc/runtime/temp/fc8d6f4264db82f70f5649e28093b318.php ( 133.25 KB )
/websites/wwwroot/cmcc/thinkphp/library/think/Response.php ( 8.28 KB )
/websites/wwwroot/cmcc/thinkphp/library/think/debug/Html.php ( 4.17 KB )

[ DB ] CONNECT:[ UseTime:0.000699s ] mysql:host=127.0.0.1;port=3306;dbname=ysscdb;charset=utf8mb4
[ SQL ] SHOW COLUMNS FROM `tb_para` [ RunTime:0.001050s ]
[ SQL ] SELECT * FROM `tb_para` WHERE `id` = 1 LIMIT 1 [ RunTime:0.000618s ]
[ SQL ] SHOW COLUMNS FROM `tb_cate` [ RunTime:0.000670s ]
[ SQL ] SELECT * FROM `tb_cate` WHERE `id` = 54 LIMIT 1 [ RunTime:0.000435s ]
[ SQL ] select distinct date_format(dt,'%Y-%m-%d') as dtt from tb_store where cate_cid=54 and date_format(dt,'%Y-%m-%d')<'2025-10-09' order by dtt desc limit 1 [ RunTime:0.002795s ]
[ SQL ] select * from tb_store where cate_cid=54 and date_format(dt,'%Y-%m-%d')='2025-10-09' [ RunTime:0.005170s ]
[ SQL ] select num from tb_store where cate_aid=1 and cate_bid=14 and cate_cid=54 and area_aid=1 and area_bid=9 and area_cid=41 and mode01=-1 and mode02=-1 and mode03=-1 and mode04=-1 and mode05=2657 and date_format(dt,'%Y-%m-%d')='2025-08-29' [ RunTime:0.003618s ]
[ SQL ] SELECT * FROM `tb_cate` WHERE `id` = 1 LIMIT 1 [ RunTime:0.000419s ]
[ SQL ] SELECT * FROM `tb_cate` WHERE `id` = 14 LIMIT 1 [ RunTime:0.000418s ]
[ SQL ] SELECT * FROM `tb_cate` WHERE `id` = 54 LIMIT 1 [ RunTime:0.000420s ]
[ SQL ] SHOW COLUMNS FROM `tb_area` [ RunTime:0.000668s ]
[ SQL ] SELECT * FROM `tb_area` WHERE `id` = 1 LIMIT 1 [ RunTime:0.000397s ]
[ SQL ] SELECT * FROM `tb_area` WHERE `id` = 9 LIMIT 1 [ RunTime:0.000433s ]
[ SQL ] SELECT * FROM `tb_area` WHERE `id` = 41 LIMIT 1 [ RunTime:0.000405s ]
[ SQL ] SELECT * FROM `tb_cate` WHERE `id` = 2657 LIMIT 1 [ RunTime:0.000390s ]
[ SQL ] select num from tb_store where cate_aid=1 and cate_bid=14 and cate_cid=54 and area_aid=1 and area_bid=10 and area_cid=385 and mode01=-1 and mode02=-1 and mode03=-1 and mode04=-1 and mode05=2657 and date_format(dt,'%Y-%m-%d')='2025-08-29' [ RunTime:0.003511s ]
[ SQL ] SELECT * FROM `tb_cate` WHERE `id` = 1 LIMIT 1 [ RunTime:0.000407s ]
[ SQL ] SELECT * FROM `tb_cate` WHERE `id` = 14 LIMIT 1 [ RunTime:0.000381s ]
[ SQL ] SELECT * FROM `tb_cate` WHERE `id` = 54 LIMIT 1 [ RunTime:0.000413s ]
[ SQL ] SELECT * FROM `tb_area` WHERE `id` = 1 LIMIT 1 [ RunTime:0.000371s ]
[ SQL ] SELECT * FROM `tb_area` WHERE `id` = 10 LIMIT 1 [ RunTime:0.000366s ]
[ SQL ] SELECT * FROM `tb_area` WHERE `id` = 385 LIMIT 1 [ RunTime:0.000408s ]
[ SQL ] SELECT * FROM `tb_cate` WHERE `id` = 2657 LIMIT 1 [ RunTime:0.000396s ]
[ SQL ] select num from tb_store where cate_aid=1 and cate_bid=14 and cate_cid=54 and area_aid=1 and area_bid=15 and area_cid=390 and mode01=-1 and mode02=-1 and mode03=-1 and mode04=-1 and mode05=2657 and date_format(dt,'%Y-%m-%d')='2025-08-29' [ RunTime:0.003465s ]
[ SQL ] SELECT * FROM `tb_cate` WHERE `id` = 1 LIMIT 1 [ RunTime:0.000404s ]
[ SQL ] SELECT * FROM `tb_cate` WHERE `id` = 14 LIMIT 1 [ RunTime:0.000381s ]
[ SQL ] SELECT * FROM `tb_cate` WHERE `id` = 54 LIMIT 1 [ RunTime:0.000392s ]
[ SQL ] SELECT * FROM `tb_area` WHERE `id` = 1 LIMIT 1 [ RunTime:0.000370s ]
[ SQL ] SELECT * FROM `tb_area` WHERE `id` = 15 LIMIT 1 [ RunTime:0.000364s ]
[ SQL ] SELECT * FROM `tb_area` WHERE `id` = 390 LIMIT 1 [ RunTime:0.000403s ]
[ SQL ] SELECT * FROM `tb_cate` WHERE `id` = 2657 LIMIT 1 [ RunTime:0.000403s ]
[ SQL ] select num from tb_store where cate_aid=1 and cate_bid=14 and cate_cid=54 and area_aid=2 and area_bid=17 and area_cid=119 and mode01=-1 and mode02=-1 and mode03=-1 and mode04=-1 and mode05=2657 and date_format(dt,'%Y-%m-%d')='2025-08-29' [ RunTime:0.003473s ]
[ SQL ] SELECT * FROM `tb_cate` WHERE `id` = 1 LIMIT 1 [ RunTime:0.000421s ]
[ SQL ] SELECT * FROM `tb_cate` WHERE `id` = 14 LIMIT 1 [ RunTime:0.000439s ]
[ SQL ] SELECT * FROM `tb_cate` WHERE `id` = 54 LIMIT 1 [ RunTime:0.000412s ]
[ SQL ] SELECT * FROM `tb_area` WHERE `id` = 2 LIMIT 1 [ RunTime:0.000387s ]
[ SQL ] SELECT * FROM `tb_area` WHERE `id` = 17 LIMIT 1 [ RunTime:0.000374s ]
[ SQL ] SELECT * FROM `tb_area` WHERE `id` = 119 LIMIT 1 [ RunTime:0.000374s ]
[ SQL ] SELECT * FROM `tb_cate` WHERE `id` = 2657 LIMIT 1 [ RunTime:0.000417s ]
[ SQL ] select num from tb_store where cate_aid=1 and cate_bid=14 and cate_cid=54 and area_aid=3 and area_bid=21 and area_cid=394 and mode01=-1 and mode02=-1 and mode03=-1 and mode04=-1 and mode05=2657 and date_format(dt,'%Y-%m-%d')='2025-08-29' [ RunTime:0.003547s ]
[ SQL ] SELECT * FROM `tb_cate` WHERE `id` = 1 LIMIT 1 [ RunTime:0.000383s ]
[ SQL ] SELECT * FROM `tb_cate` WHERE `id` = 14 LIMIT 1 [ RunTime:0.000390s ]
[ SQL ] SELECT * FROM `tb_cate` WHERE `id` = 54 LIMIT 1 [ RunTime:0.000362s ]
[ SQL ] SELECT * FROM `tb_area` WHERE `id` = 3 LIMIT 1 [ RunTime:0.000373s ]
[ SQL ] SELECT * FROM `tb_area` WHERE `id` = 21 LIMIT 1 [ RunTime:0.000366s ]
[ SQL ] SELECT * FROM `tb_area` WHERE `id` = 394 LIMIT 1 [ RunTime:0.000365s ]
[ SQL ] SELECT * FROM `tb_cate` WHERE `id` = 2657 LIMIT 1 [ RunTime:0.000383s ]
[ SQL ] SHOW COLUMNS FROM `tb_news` [ RunTime:0.000750s ]
[ SQL ] SELECT `id`,`title`,`url` FROM `tb_news` WHERE `cate_id` = 98 ORDER BY `submit_date` DESC LIMIT 10 [ RunTime:0.003734s ]
[ SQL ] select cate_cid,area_cid,date_format(dt,'%Y-%m-%d') as dtt from tb_price where check_status=1 group by cate_cid,area_cid,date_format(dt,'%Y-%m-%d') order by date_format(dt,'%Y-%m-%d') desc limit 8 [ RunTime:3.879387s ]
[ SQL ] SELECT * FROM `tb_cate` WHERE `id` IN (36,37) [ RunTime:0.000370s ]
[ SQL ] SELECT * FROM `tb_area` WHERE `id` IN (397,403,395,48,119,382,391,390) [ RunTime:0.000409s ]
[ SQL ] SELECT * FROM `tb_area` WHERE `id` = 24 LIMIT 1 [ RunTime:0.000285s ]
[ SQL ] SELECT * FROM `tb_area` WHERE `id` = 31 LIMIT 1 [ RunTime:0.000258s ]
[ SQL ] SELECT * FROM `tb_area` WHERE `id` = 22 LIMIT 1 [ RunTime:0.000279s ]
[ SQL ] SELECT * FROM `tb_area` WHERE `id` = 18 LIMIT 1 [ RunTime:0.000254s ]
[ SQL ] SELECT * FROM `tb_area` WHERE `id` = 15 LIMIT 1 [ RunTime:0.000270s ]
[ DB ] CONNECT:[ UseTime:0.001632s ] mysql:host=pc-m5epcw1px949b110u.rwlb.rds.aliyuncs.com;port=3306;dbname=yousedb;charset=utf8
[ SQL ] SHOW COLUMNS FROM `tb_meet_view` [ RunTime:0.002744s ]
[ SQL ] SELECT `id`,`title`,`tb_name`,`start_date`,`end_date`,`city_id` FROM `tb_meet_view` ORDER BY `start_date` DESC LIMIT 8 [ RunTime:0.010861s ]
[ SQL ] SHOW COLUMNS FROM `tb_area` [ RunTime:0.005775s ]
[ SQL ] SELECT `id`,`name`,`pid` FROM `tb_area` WHERE `id` IN (225,118,98,204,272) [ RunTime:0.001114s ]
[ SQL ] SELECT `id`,`name` FROM `tb_area` WHERE `id` IN (10,12,18,19,23) [ RunTime:0.001158s ]
[ SQL ] SHOW COLUMNS FROM `tb_index_cate` [ RunTime:0.000608s ]
[ SQL ] SELECT * FROM `tb_index_cate` WHERE `cate_aid` = 1 ORDER BY `sortid` ASC [ RunTime:0.000383s ]
[ SQL ] select dt,num from tb_price where check_status=1 and cate_aid=1 and cate_bid=10 and cate_cid=27 and area_aid=1 and area_bid=9 and area_cid=41 and mode01=113 and mode02=-1 and mode03=941 and mode04=-1 and mode05=1899 order by dt desc limit 2 [ RunTime:0.000425s ]
[ SQL ] SELECT * FROM `tb_cate` WHERE `id` = 10 LIMIT 1 [ RunTime:0.000279s ]
[ SQL ] select dt,num from tb_price where check_status=1 and cate_aid=1 and cate_bid=11 and cate_cid=38 and area_aid=1 and area_bid=14 and area_cid=91 and mode01=184 and mode02=621 and mode03=1095 and mode04=-1 and mode05=1899 order by dt desc limit 2 [ RunTime:0.000326s ]
[ SQL ] SELECT * FROM `tb_cate` WHERE `id` = 11 LIMIT 1 [ RunTime:0.000271s ]
[ SQL ] select dt,num from tb_price where check_status=1 and cate_aid=1 and cate_bid=12 and cate_cid=46 and area_aid=1 and area_bid=9 and area_cid=41 and mode01=325 and mode02=-1 and mode03=1231 and mode04=-1 and mode05=1899 order by dt desc limit 2 [ RunTime:0.000334s ]
[ SQL ] SELECT * FROM `tb_cate` WHERE `id` = 12 LIMIT 1 [ RunTime:0.000299s ]
[ SQL ] select dt,num from tb_price where check_status=1 and cate_aid=1 and cate_bid=13 and cate_cid=49 and area_aid=1 and area_bid=9 and area_cid=41 and mode01=377 and mode02=696 and mode03=1275 and mode04=-1 and mode05=1899 order by dt desc limit 2 [ RunTime:0.000404s ]
[ SQL ] SELECT * FROM `tb_cate` WHERE `id` = 13 LIMIT 1 [ RunTime:0.000276s ]
[ SQL ] select dt,num from tb_price where check_status=1 and cate_aid=1 and cate_bid=14 and cate_cid=54 and area_aid=1 and area_bid=9 and area_cid=41 and mode01=419 and mode02=-1 and mode03=1400 and mode04=-1 and mode05=1899 order by dt desc limit 2 [ RunTime:0.000409s ]
[ SQL ] SELECT * FROM `tb_cate` WHERE `id` = 14 LIMIT 1 [ RunTime:0.000278s ]
[ SQL ] SHOW COLUMNS FROM `tb_advert` [ RunTime:0.000541s ]
[ SQL ] SELECT * FROM `tb_advert` WHERE `id` = 1 LIMIT 1 [ RunTime:0.000343s ]
[ SQL ] SELECT * FROM `tb_cate` WHERE `pid` = 10 AND `id` < 3242 ORDER BY `sortid` ASC LIMIT 8 [ RunTime:0.001281s ]
[ SQL ] SELECT * FROM `tb_cate` WHERE `pid` = 11 AND `id` < 3242 ORDER BY `sortid` ASC LIMIT 8 [ RunTime:0.001354s ]
[ SQL ] SELECT * FROM `tb_cate` WHERE `pid` = 2 AND `id` < 3242 ORDER BY `sortid` ASC LIMIT 6 [ RunTime:0.001265s ]
[ SQL ] SELECT * FROM `tb_cate` WHERE `pid` = 12 AND `id` < 3242 ORDER BY `sortid` ASC LIMIT 5 [ RunTime:0.001326s ]
[ SQL ] SELECT * FROM `tb_cate` WHERE `pid` = 13 AND `id` < 3242 ORDER BY `sortid` ASC LIMIT 5 [ RunTime:0.001232s ]
[ SQL ] SELECT * FROM `tb_cate` WHERE `pid` = 3 AND `id` < 3242 ORDER BY `sortid` ASC LIMIT 6 [ RunTime:0.001257s ]
[ SQL ] SELECT * FROM `tb_cate` WHERE `pid` = 10 AND `id` < 3242 ORDER BY `sortid` ASC [ RunTime:0.001257s ]
[ SQL ] SELECT * FROM `tb_cate` WHERE `pid` = 11 AND `id` < 3242 ORDER BY `sortid` ASC [ RunTime:0.001241s ]
[ SQL ] SELECT * FROM `tb_cate` WHERE `pid` = 12 AND `id` < 3242 ORDER BY `sortid` ASC [ RunTime:0.001234s ]
[ SQL ] SELECT * FROM `tb_cate` WHERE `pid` = 13 AND `id` < 3242 ORDER BY `sortid` ASC [ RunTime:0.001314s ]
[ SQL ] SELECT * FROM `tb_cate` WHERE `pid` = 14 AND `id` < 3242 ORDER BY `sortid` ASC [ RunTime:0.001236s ]
[ SQL ] SELECT * FROM `tb_cate` WHERE `pid` = 19 AND `id` < 3242 ORDER BY `sortid` ASC [ RunTime:0.001224s ]
[ SQL ] SELECT * FROM `tb_cate` WHERE `pid` = 15 AND `id` < 3242 ORDER BY `sortid` ASC [ RunTime:0.001239s ]
[ SQL ] SELECT * FROM `tb_cate` WHERE `pid` = 16 AND `id` < 3242 ORDER BY `sortid` ASC [ RunTime:0.001311s ]
[ SQL ] SELECT * FROM `tb_cate` WHERE `pid` = 17 AND `id` < 3242 ORDER BY `sortid` ASC [ RunTime:0.001297s ]
[ SQL ] SELECT * FROM `tb_cate` WHERE `pid` = 3 AND `id` < 3242 ORDER BY `sortid` ASC [ RunTime:0.001319s ]
[ SQL ] SELECT * FROM `tb_advert` WHERE `id` = 42 LIMIT 1 [ RunTime:0.000299s ]
[ SQL ] SELECT * FROM `tb_advert` WHERE `id` = 43 LIMIT 1 [ RunTime:0.000308s ]
[ SQL ] SELECT * FROM `tb_advert` WHERE `id` = 44 LIMIT 1 [ RunTime:0.000296s ]
[ SQL ] SELECT * FROM `tb_para` WHERE `id` = 1 LIMIT 1 [ RunTime:0.000366s ]

2025年10月09日锡锭库存数据