食品原料与配料-批发供应商-食品加工包装在线

食品原料与配料 > 食品配料 > 茶

杭州茗宝生物科技有限公司

主营产品: 食品原料与配料健康天然原料营养保健品天然健康产品健康器械及用品加工包装机械产业服务

详细地址: 浙江省杭州市余杭区闲林镇闲林工业区闲兴路28号

已发布 10条产品浙江省杭州市余杭区闲林镇闲林工业区闲兴路28号

收藏拨打电话

易晓食品(衢州)有限公司

主营产品: 食品原料与配料健康天然原料营养保健品天然健康产品健康器械及用品加工包装机械产业服务

详细地址: 深圳市福田区深南中路6009号绿军广场C栋28楼I室

已发布 18条产品深圳市福田区深南中路6009号绿军广场C栋28楼I室

收藏拨打电话

湖州意诺茶业有限公司

主营产品: 食品原料与配料健康天然原料营养保健品天然健康产品健康器械及用品加工包装机械产业服务

详细地址: 浙江省湖州市长兴县经济开发区太湖大道

已发布 6条产品中国浙江杭州市

收藏拨打电话

浙江省茶叶集团股份有限公司

主营产品: 食品原料与配料健康天然原料营养保健品天然健康产品健康器械及用品加工包装机械产业服务

详细地址: 浙江省杭州市体育场路218号

已发布 5条产品中国浙江杭州市

收藏拨打电话

杭州宝达茶业有限公司

主营产品: 食品原料与配料健康天然原料营养保健品天然健康产品健康器械及用品加工包装机械产业服务

详细地址: 杭州市江干区凤起东路189号新城时代广场2-1601室

已发布 2条产品中国浙江杭州市

收藏拨打电话

浙江骆驼九宇有机食品有限公司

主营产品: 食品原料与配料健康天然原料营养保健品天然健康产品健康器械及用品加工包装机械产业服务

详细地址: 杭州市余杭区瓶窑镇茶场路16号

已发布 2条产品中国浙江杭州市

收藏拨打电话

杭州九曲红梅茶业有限公司

主营产品: 食品原料与配料健康天然原料营养保健品天然健康产品健康器械及用品加工包装机械产业服务

详细地址: NO 232 LINGSHAN HANGZHOU ZHEJIANG CHINA

已发布 7条产品中国浙江杭州市

收藏拨打电话

海宁康尔福保健饮料食品有限责任公司

主营产品: 食品原料与配料健康天然原料营养保健品天然健康产品健康器械及用品加工包装机械产业服务

详细地址: 海宁市斜桥镇工业园区云和路3号

已发布 5条产品浙江省海宁市斜桥工业园区云和路3号

收藏拨打电话

杭州绿润制茶有限公司

主营产品: 食品原料与配料健康天然原料营养保健品天然健康产品健康器械及用品加工包装机械产业服务

详细地址: 浙江省杭州市上城区惠民路56号1号楼

已发布 16条产品中国浙江杭州市

收藏拨打电话

浙江省诸暨绿剑茶业有限公司

主营产品: 食品原料与配料健康天然原料营养保健品天然健康产品健康器械及用品加工包装机械产业服务

详细地址: 浙江省诸暨市同山镇绿剑

已发布 5条产品中国浙江杭州市

收藏拨打电话

基本文件流程错误 SQL 调试

/www/msjglenew/website/public/index.php ( 6.31 KB )
/www/msjglenew/website/vendor/autoload.php ( 0.17 KB )
/www/msjglenew/website/vendor/composer/autoload_real.php ( 2.36 KB )
/www/msjglenew/website/vendor/composer/ClassLoader.php ( 13.11 KB )
/www/msjglenew/website/vendor/composer/autoload_static.php ( 8.75 KB )
/www/msjglenew/website/vendor/topthink/think-helper/src/helper.php ( 7.35 KB )
/www/msjglenew/website/vendor/symfony/polyfill-mbstring/bootstrap.php ( 6.42 KB )
/www/msjglenew/website/vendor/opis/closure/functions.php ( 0.95 KB )
/www/msjglenew/website/vendor/symfony/polyfill-php72/bootstrap.php ( 1.78 KB )
/www/msjglenew/website/vendor/ralouphie/getallheaders/src/getallheaders.php ( 1.60 KB )
/www/msjglenew/website/vendor/guzzlehttp/psr7/src/functions_include.php ( 0.15 KB )
/www/msjglenew/website/vendor/guzzlehttp/psr7/src/functions.php ( 26.06 KB )
/www/msjglenew/website/vendor/guzzlehttp/promises/src/functions_include.php ( 0.16 KB )
/www/msjglenew/website/vendor/guzzlehttp/promises/src/functions.php ( 11.77 KB )
/www/msjglenew/website/vendor/symfony/polyfill-intl-idn/bootstrap.php ( 4.50 KB )
/www/msjglenew/website/vendor/guzzlehttp/guzzle/src/functions_include.php ( 0.16 KB )
/www/msjglenew/website/vendor/guzzlehttp/guzzle/src/functions.php ( 9.70 KB )
/www/msjglenew/website/vendor/adbario/php-dot-notation/src/helpers.php ( 0.49 KB )
/www/msjglenew/website/vendor/danielstjules/stringy/src/Create.php ( 0.55 KB )
/www/msjglenew/website/vendor/mtdowling/jmespath.php/src/JmesPath.php ( 0.37 KB )
/www/msjglenew/website/vendor/symfony/var-dumper/Resources/functions/dump.php ( 0.79 KB )
/www/msjglenew/website/vendor/alibabacloud/client/src/Functions.php ( 5.32 KB )
/www/msjglenew/website/vendor/topthink/think-captcha/src/helper.php ( 1.37 KB )
/www/msjglenew/website/vendor/topthink/framework/src/think/App.php ( 14.18 KB )
/www/msjglenew/website/vendor/topthink/framework/src/think/Container.php ( 14.73 KB )
/www/msjglenew/website/vendor/psr/container/src/ContainerInterface.php ( 1.07 KB )
/www/msjglenew/website/app/provider.php ( 0.19 KB )
/www/msjglenew/website/vendor/topthink/framework/src/think/Http.php ( 6.16 KB )
/www/msjglenew/website/vendor/topthink/think-helper/src/helper/Str.php ( 7.27 KB )
/www/msjglenew/website/vendor/topthink/framework/src/think/facade/Route.php ( 0.98 KB )
/www/msjglenew/website/vendor/topthink/framework/src/think/Facade.php ( 2.71 KB )
/www/msjglenew/website/vendor/topthink/framework/src/think/Route.php ( 22.25 KB )
/www/msjglenew/website/vendor/topthink/framework/src/think/route/RuleName.php ( 4.87 KB )
/www/msjglenew/website/vendor/topthink/framework/src/think/route/Domain.php ( 5.41 KB )
/www/msjglenew/website/vendor/topthink/framework/src/think/route/RuleGroup.php ( 14.44 KB )
/www/msjglenew/website/vendor/topthink/framework/src/think/route/Rule.php ( 23.26 KB )
/www/msjglenew/website/vendor/topthink/framework/src/think/route/RuleItem.php ( 9.20 KB )
/www/msjglenew/website/app/Request.php ( 0.13 KB )
/www/msjglenew/website/vendor/topthink/framework/src/think/Request.php ( 52.82 KB )
/www/msjglenew/website/vendor/topthink/framework/src/think/Env.php ( 4.15 KB )
/www/msjglenew/website/app/common.php ( 38.00 KB )
/www/msjglenew/website/app/common_global.php ( 9.62 KB )
/www/msjglenew/website/vendor/topthink/framework/src/think/facade/Request.php ( 0.99 KB )
/www/msjglenew/website/app/common_goods.php ( 39.89 KB )
/www/msjglenew/website/app/common_upload.php ( 26.57 KB )
/www/msjglenew/website/vendor/topthink/framework/src/helper.php ( 18.33 KB )
/www/msjglenew/website/vendor/topthink/framework/src/think/Config.php ( 4.91 KB )
/www/msjglenew/website/config/app.php ( 1.07 KB )
/www/msjglenew/website/vendor/topthink/framework/src/think/facade/Env.php ( 0.97 KB )
/www/msjglenew/website/config/cache.php ( 0.82 KB )
/www/msjglenew/website/config/captcha.php ( 1.08 KB )
/www/msjglenew/website/config/console.php ( 0.23 KB )
/www/msjglenew/website/config/cookie.php ( 0.49 KB )
/www/msjglenew/website/config/database.php ( 2.11 KB )
/www/msjglenew/website/config/filesystem.php ( 0.63 KB )
/www/msjglenew/website/config/jump.php ( 0.28 KB )
/www/msjglenew/website/config/lang.php ( 0.75 KB )
/www/msjglenew/website/config/log.php ( 1.45 KB )
/www/msjglenew/website/config/middleware.php ( 0.19 KB )
/www/msjglenew/website/config/route.php ( 1.54 KB )
/www/msjglenew/website/config/trace.php ( 0.34 KB )
/www/msjglenew/website/config/view.php ( 0.82 KB )
/www/msjglenew/website/app/event.php ( 0.25 KB )
/www/msjglenew/website/vendor/topthink/framework/src/think/Event.php ( 7.34 KB )
/www/msjglenew/website/app/service.php ( 0.13 KB )
/www/msjglenew/website/app/AppService.php ( 0.26 KB )
/www/msjglenew/website/vendor/topthink/framework/src/think/Service.php ( 1.67 KB )
/www/msjglenew/website/vendor/topthink/framework/src/think/Lang.php ( 7.70 KB )
/www/msjglenew/website/vendor/topthink/framework/src/lang/zh-cn.php ( 12.88 KB )
/www/msjglenew/website/vendor/topthink/framework/src/think/initializer/Error.php ( 3.19 KB )
/www/msjglenew/website/vendor/topthink/framework/src/think/initializer/RegisterService.php ( 1.33 KB )
/www/msjglenew/website/vendor/services.php ( 0.21 KB )
/www/msjglenew/website/vendor/topthink/framework/src/think/service/PaginatorService.php ( 1.52 KB )
/www/msjglenew/website/vendor/topthink/framework/src/think/service/ValidateService.php ( 0.99 KB )
/www/msjglenew/website/vendor/topthink/framework/src/think/service/ModelService.php ( 1.51 KB )
/www/msjglenew/website/vendor/topthink/think-captcha/src/CaptchaService.php ( 0.52 KB )
/www/msjglenew/website/vendor/topthink/think-multi-app/src/Service.php ( 1.05 KB )
/www/msjglenew/website/vendor/topthink/think-trace/src/Service.php ( 0.77 KB )
/www/msjglenew/website/vendor/topthink/framework/src/think/Middleware.php ( 6.78 KB )
/www/msjglenew/website/vendor/topthink/framework/src/think/initializer/BootService.php ( 0.77 KB )
/www/msjglenew/website/vendor/topthink/think-orm/src/Paginator.php ( 11.07 KB )
/www/msjglenew/website/vendor/topthink/framework/src/think/Validate.php ( 45.60 KB )
/www/msjglenew/website/vendor/topthink/think-orm/src/Model.php ( 25.18 KB )
/www/msjglenew/website/vendor/topthink/think-orm/src/model/concern/Attribute.php ( 16.98 KB )
/www/msjglenew/website/vendor/topthink/think-orm/src/model/concern/RelationShip.php ( 26.03 KB )
/www/msjglenew/website/vendor/topthink/think-orm/src/model/concern/ModelEvent.php ( 2.26 KB )
/www/msjglenew/website/vendor/topthink/think-orm/src/model/concern/TimeStamp.php ( 5.36 KB )
/www/msjglenew/website/vendor/topthink/think-orm/src/model/concern/Conversion.php ( 7.73 KB )
/www/msjglenew/website/vendor/topthink/think-helper/src/contract/Arrayable.php ( 0.09 KB )
/www/msjglenew/website/vendor/topthink/think-helper/src/contract/Jsonable.php ( 0.13 KB )
/www/msjglenew/website/vendor/topthink/framework/src/think/Db.php ( 2.78 KB )
/www/msjglenew/website/vendor/topthink/think-orm/src/DbManager.php ( 9.12 KB )
/www/msjglenew/website/vendor/topthink/framework/src/think/Log.php ( 8.50 KB )
/www/msjglenew/website/vendor/topthink/framework/src/think/Manager.php ( 3.97 KB )
/www/msjglenew/website/vendor/psr/log/Psr/Log/LoggerInterface.php ( 3.04 KB )
/www/msjglenew/website/vendor/topthink/framework/src/think/Cache.php ( 4.79 KB )
/www/msjglenew/website/vendor/psr/simple-cache/src/CacheInterface.php ( 4.50 KB )
/www/msjglenew/website/vendor/topthink/framework/src/think/Console.php ( 21.27 KB )
/www/msjglenew/website/vendor/topthink/framework/src/think/Pipeline.php ( 2.60 KB )
/www/msjglenew/website/vendor/topthink/think-trace/src/TraceDebug.php ( 2.94 KB )
/www/msjglenew/website/vendor/topthink/think-multi-app/src/MultiApp.php ( 7.39 KB )
/www/msjglenew/website/app/home/common.php ( 0.01 KB )
/www/msjglenew/website/app/home/config/jump.php ( 0.35 KB )
/www/msjglenew/website/app/home/config/session.php ( 0.57 KB )
/www/msjglenew/website/app/home/middleware.php ( 0.25 KB )
/www/msjglenew/website/app/home/lang/zh-cn.php ( 19.46 KB )
/www/msjglenew/website/vendor/topthink/framework/src/think/middleware/SessionInit.php ( 2.02 KB )
/www/msjglenew/website/vendor/topthink/framework/src/think/Session.php ( 1.80 KB )
/www/msjglenew/website/vendor/topthink/think-helper/src/helper/Arr.php ( 15.54 KB )
/www/msjglenew/website/vendor/topthink/framework/src/think/session/driver/File.php ( 6.31 KB )
/www/msjglenew/website/vendor/topthink/framework/src/think/contract/SessionHandlerInterface.php ( 0.87 KB )
/www/msjglenew/website/vendor/topthink/framework/src/think/session/Store.php ( 7.26 KB )
/www/msjglenew/website/vendor/topthink/framework/src/think/route/dispatch/Controller.php ( 7.17 KB )
/www/msjglenew/website/vendor/topthink/framework/src/think/route/Dispatch.php ( 6.75 KB )
/www/msjglenew/website/app/home/controller/Storelist.php ( 23.90 KB )
/www/msjglenew/website/app/home/controller/BaseMall.php ( 2.33 KB )
/www/msjglenew/website/app/home/controller/BaseHome.php ( 13.97 KB )
/www/msjglenew/website/app/BaseController.php ( 7.05 KB )
/www/msjglenew/website/vendor/topthink/framework/src/think/facade/Cache.php ( 0.98 KB )
/www/msjglenew/website/vendor/topthink/framework/src/think/cache/driver/File.php ( 7.61 KB )
/www/msjglenew/website/vendor/topthink/framework/src/think/cache/Driver.php ( 7.81 KB )
/www/msjglenew/website/vendor/topthink/framework/src/think/contract/CacheHandlerInterface.php ( 2.25 KB )
/www/msjglenew/website/vendor/topthink/framework/src/think/facade/Config.php ( 0.98 KB )
/www/msjglenew/website/vendor/topthink/framework/src/think/facade/Session.php ( 0.99 KB )
/www/msjglenew/website/app/common/model/Articleclass.php ( 5.54 KB )
/www/msjglenew/website/app/common/model/BaseModel.php ( 2.67 KB )
/www/msjglenew/website/app/common/model/Article.php ( 10.64 KB )
/www/msjglenew/website/vendor/topthink/think-orm/src/facade/Db.php ( 2.25 KB )
/www/msjglenew/website/vendor/topthink/think-orm/src/db/connector/Mysql.php ( 4.41 KB )
/www/msjglenew/website/vendor/topthink/think-orm/src/db/PDOConnection.php ( 46.19 KB )
/www/msjglenew/website/vendor/topthink/think-orm/src/db/Connection.php ( 5.97 KB )
/www/msjglenew/website/vendor/topthink/think-orm/src/db/ConnectionInterface.php ( 4.88 KB )
/www/msjglenew/website/vendor/topthink/think-orm/src/db/builder/Mysql.php ( 13.81 KB )
/www/msjglenew/website/vendor/topthink/think-orm/src/db/Builder.php ( 38.86 KB )
/www/msjglenew/website/vendor/topthink/think-orm/src/db/Query.php ( 11.46 KB )
/www/msjglenew/website/vendor/topthink/think-orm/src/db/BaseQuery.php ( 34.47 KB )
/www/msjglenew/website/vendor/topthink/think-orm/src/db/concern/TimeFieldQuery.php ( 7.50 KB )
/www/msjglenew/website/vendor/topthink/think-orm/src/db/concern/AggregateQuery.php ( 2.83 KB )
/www/msjglenew/website/vendor/topthink/think-orm/src/db/concern/ModelRelationQuery.php ( 15.49 KB )
/www/msjglenew/website/vendor/topthink/think-orm/src/db/concern/ResultOperation.php ( 7.10 KB )
/www/msjglenew/website/vendor/topthink/think-orm/src/db/concern/Transaction.php ( 2.77 KB )
/www/msjglenew/website/vendor/topthink/think-orm/src/db/concern/WhereQuery.php ( 16.50 KB )
/www/msjglenew/website/vendor/topthink/think-orm/src/db/concern/JoinAndViewQuery.php ( 6.88 KB )
/www/msjglenew/website/vendor/topthink/think-orm/src/db/concern/ParamsBind.php ( 2.75 KB )
/www/msjglenew/website/vendor/topthink/think-orm/src/db/concern/TableFieldInfo.php ( 2.51 KB )
/www/msjglenew/website/vendor/topthink/framework/src/think/log/driver/File.php ( 5.94 KB )
/www/msjglenew/website/vendor/topthink/framework/src/think/contract/LogHandlerInterface.php ( 0.86 KB )
/www/msjglenew/website/vendor/topthink/framework/src/think/log/Channel.php ( 6.41 KB )
/www/msjglenew/website/vendor/topthink/think-helper/src/Collection.php ( 15.83 KB )
/www/msjglenew/website/vendor/topthink/think-orm/src/db/Raw.php ( 1.17 KB )
/www/msjglenew/website/vendor/topthink/framework/src/think/facade/View.php ( 0.98 KB )
/www/msjglenew/website/vendor/topthink/framework/src/think/View.php ( 4.31 KB )
/www/msjglenew/website/vendor/topthink/framework/src/think/facade/Cookie.php ( 0.98 KB )
/www/msjglenew/website/vendor/topthink/framework/src/think/Cookie.php ( 6.15 KB )
/www/msjglenew/website/app/common/model/Cart.php ( 7.86 KB )
/www/msjglenew/website/app/common/model/Adv.php ( 6.42 KB )
/www/msjglenew/website/app/common/model/Home.php ( 35.47 KB )
/www/msjglenew/website/app/common/model/Goodsclass.php ( 33.11 KB )
/www/msjglenew/website/vendor/topthink/framework/src/think/facade/Lang.php ( 0.98 KB )
/www/msjglenew/website/app/home/lang/zh-cn/storelist.lang.php ( 3.59 KB )
/www/msjglenew/website/app/common/model/Search.php ( 16.53 KB )
/www/msjglenew/website/app/common/model/Goods.php ( 100.21 KB )
/www/msjglenew/website/app/common/model/Master.php ( 1.79 KB )
/www/msjglenew/website/app/common/model/Store.php ( 32.95 KB )
/www/msjglenew/website/vendor/topthink/think-orm/src/db/Fetch.php ( 12.88 KB )
/www/msjglenew/website/vendor/topthink/think-orm/src/paginator/driver/Bootstrap.php ( 6.44 KB )
/www/msjglenew/website/app/common/model/CompanyIntroduction.php ( 11.03 KB )
/www/msjglenew/website/app/common/model/Snscompany.php ( 1.06 KB )
/www/msjglenew/website/vendor/topthink/think-multi-app/src/Url.php ( 7.35 KB )
/www/msjglenew/website/vendor/topthink/framework/src/think/route/Url.php ( 14.57 KB )
/www/msjglenew/website/app/common/model/Seo.php ( 3.32 KB )
/www/msjglenew/website/vendor/topthink/think-view/src/Think.php ( 8.42 KB )
/www/msjglenew/website/vendor/topthink/think-template/src/Template.php ( 46.62 KB )
/www/msjglenew/website/vendor/topthink/think-template/src/template/driver/File.php ( 2.33 KB )
/www/msjglenew/website/runtime/home/temp/7a8d2037c74e9d07cdfa88e6812c96c7.php ( 27.95 KB )
/www/msjglenew/website/vendor/topthink/framework/src/think/Response.php ( 8.54 KB )
/www/msjglenew/website/vendor/topthink/framework/src/think/response/Html.php ( 0.98 KB )
/www/msjglenew/website/vendor/topthink/think-trace/src/Html.php ( 4.37 KB )

CONNECT:[ UseTime:0.001155s ] mysql:host=rm-uf69zgo46hs59i1amrw.rwlb.rds.aliyuncs.com;port=3306;dbname=sjgle_new;charset=utf8
SHOW FULL COLUMNS FROM `ds_articleclass` [ RunTime:0.000993s ]
SELECT * FROM `ds_articleclass` WHERE `ac_id` <= 7 ORDER BY `ac_sort` ASC [ RunTime:0.000744s ]
SHOW FULL COLUMNS FROM `ds_article` [ RunTime:0.003387s ]
SELECT `article`.`article_id`,`article`.`ac_id`,`article`.`article_url`,`article`.`article_title`,`article`.`article_time`,`article_class`.`ac_name`,`article_class`.`ac_parent_id` FROM `ds_article` `article` LEFT JOIN `ds_articleclass` `article_class` ON `article`.`ac_id`=`article_class`.`ac_id` WHERE ( article.article_show = '1' and (article_class.ac_id <= 7 or (article_class.ac_parent_id > 0 and article_class.ac_parent_id <= 7)) ) ORDER BY `article_sort` ASC,`article_time` DESC LIMIT 300 [ RunTime:0.001192s ]
SHOW FULL COLUMNS FROM `ds_cart` [ RunTime:0.000890s ]
SELECT * FROM `ds_cart` WHERE `buyer_id` IS NULL [ RunTime:0.002716s ]
SHOW FULL COLUMNS FROM `ds_adv` [ RunTime:0.000903s ]
SELECT * FROM `ds_adv` WHERE `ap_id` = 21 AND `adv_enabled` = 1 AND `adv_startdate` < 1653249600 AND `adv_enddate` > 1653249600 ORDER BY `adv_sort` ASC,`adv_id` ASC [ RunTime:0.002824s ]
SHOW FULL COLUMNS FROM `ds_v_goodsclass_forselect` [ RunTime:0.001071s ]
SELECT * FROM `ds_v_goodsclass_forselect` WHERE ( gc_idthree =687 ) LIMIT 1 [ RunTime:0.003012s ]
SHOW FULL COLUMNS FROM `ds_v_storelist` [ RunTime:0.003986s ]
SELECT COUNT(*) AS think_count FROM ( SELECT count(*) AS think_count FROM `ds_v_storelist` `v` WHERE `v`.`gc_id_3` = 687 GROUP BY `v`.`store_id` ) `_group_count_` [ RunTime:0.245530s ]
SELECT distinct v.store_id FROM `ds_v_storelist` `v` WHERE `v`.`gc_id_3` = 687 GROUP BY `v`.`store_id` LIMIT 0,10 [ RunTime:0.244741s ]
SELECT `goods`.`goods_id` AS `goods_id`, `goods`.`store_id` AS `store_id`, `goods`.`goods_name` AS `goods_name`, `goods`.`goods_image` AS `goods_image`, `goods`.`goods_price` AS `goods_price`, `goods`.`goods_salenum` AS `goods_salenum`, `company`.`shopname` AS `shopname`, (CASE WHEN ( `gtag`.`gtag_name` = '推荐' ) THEN 1 ELSE 0 END ) AS `recommend` FROM ( `ds_goods` `goods` LEFT JOIN ( SELECT `sns`.`goods_id` AS `goods_id`, `sns`.`gtag_id` AS `gtag_id`, tag.gtag_name FROM ( `ds_snsgtaggoods` `sns` LEFT JOIN `ds_snsgoodstag` `tag` ON (( `tag`.`gtag_id` = `sns`.`gtag_id` ))) WHERE (( `tag`.`isplatform` = '1' )) ) gtag ON goods.goods_id = gtag.goods_id LEFT JOIN `ds_company_introduction` `company` ON (( `goods`.`store_id` = `company`.`store_id` ))) WHERE (( `goods`.`state` <> '2' ) AND ( `goods`.`goods_state` = '1' ) AND ( `goods`.`goods_verify` = '1' ) AND goods.store_id = 77584) ORDER BY recommend DESC, `goods`.`on_shelf_time` DESC, `goods`.`goods_sort` DESC LIMIT 0 [ RunTime:0.000929s ]
SELECT `goods`.`goods_id` AS `goods_id`, `goods`.`store_id` AS `store_id`, `goods`.`goods_name` AS `goods_name`, `goods`.`goods_image` AS `goods_image`, `goods`.`goods_price` AS `goods_price`, `goods`.`goods_salenum` AS `goods_salenum`, `company`.`shopname` AS `shopname`, (CASE WHEN ( `gtag`.`gtag_name` = '推荐' ) THEN 1 ELSE 0 END ) AS `recommend` FROM ( `ds_goods` `goods` LEFT JOIN ( SELECT `sns`.`goods_id` AS `goods_id`, `sns`.`gtag_id` AS `gtag_id`, tag.gtag_name FROM ( `ds_snsgtaggoods` `sns` LEFT JOIN `ds_snsgoodstag` `tag` ON (( `tag`.`gtag_id` = `sns`.`gtag_id` ))) WHERE (( `tag`.`isplatform` = '1' )) ) gtag ON goods.goods_id = gtag.goods_id LEFT JOIN `ds_company_introduction` `company` ON (( `goods`.`store_id` = `company`.`store_id` ))) WHERE (( `goods`.`state` <> '2' ) AND ( `goods`.`goods_state` = '1' ) AND ( `goods`.`goods_verify` = '1' ) AND goods.store_id = 109656) ORDER BY recommend DESC, `goods`.`on_shelf_time` DESC, `goods`.`goods_sort` DESC LIMIT 0 [ RunTime:0.000940s ]
SELECT `goods`.`goods_id` AS `goods_id`, `goods`.`store_id` AS `store_id`, `goods`.`goods_name` AS `goods_name`, `goods`.`goods_image` AS `goods_image`, `goods`.`goods_price` AS `goods_price`, `goods`.`goods_salenum` AS `goods_salenum`, `company`.`shopname` AS `shopname`, (CASE WHEN ( `gtag`.`gtag_name` = '推荐' ) THEN 1 ELSE 0 END ) AS `recommend` FROM ( `ds_goods` `goods` LEFT JOIN ( SELECT `sns`.`goods_id` AS `goods_id`, `sns`.`gtag_id` AS `gtag_id`, tag.gtag_name FROM ( `ds_snsgtaggoods` `sns` LEFT JOIN `ds_snsgoodstag` `tag` ON (( `tag`.`gtag_id` = `sns`.`gtag_id` ))) WHERE (( `tag`.`isplatform` = '1' )) ) gtag ON goods.goods_id = gtag.goods_id LEFT JOIN `ds_company_introduction` `company` ON (( `goods`.`store_id` = `company`.`store_id` ))) WHERE (( `goods`.`state` <> '2' ) AND ( `goods`.`goods_state` = '1' ) AND ( `goods`.`goods_verify` = '1' ) AND goods.store_id = 109853) ORDER BY recommend DESC, `goods`.`on_shelf_time` DESC, `goods`.`goods_sort` DESC LIMIT 0 [ RunTime:0.000912s ]
SELECT `goods`.`goods_id` AS `goods_id`, `goods`.`store_id` AS `store_id`, `goods`.`goods_name` AS `goods_name`, `goods`.`goods_image` AS `goods_image`, `goods`.`goods_price` AS `goods_price`, `goods`.`goods_salenum` AS `goods_salenum`, `company`.`shopname` AS `shopname`, (CASE WHEN ( `gtag`.`gtag_name` = '推荐' ) THEN 1 ELSE 0 END ) AS `recommend` FROM ( `ds_goods` `goods` LEFT JOIN ( SELECT `sns`.`goods_id` AS `goods_id`, `sns`.`gtag_id` AS `gtag_id`, tag.gtag_name FROM ( `ds_snsgtaggoods` `sns` LEFT JOIN `ds_snsgoodstag` `tag` ON (( `tag`.`gtag_id` = `sns`.`gtag_id` ))) WHERE (( `tag`.`isplatform` = '1' )) ) gtag ON goods.goods_id = gtag.goods_id LEFT JOIN `ds_company_introduction` `company` ON (( `goods`.`store_id` = `company`.`store_id` ))) WHERE (( `goods`.`state` <> '2' ) AND ( `goods`.`goods_state` = '1' ) AND ( `goods`.`goods_verify` = '1' ) AND goods.store_id = 109922) ORDER BY recommend DESC, `goods`.`on_shelf_time` DESC, `goods`.`goods_sort` DESC LIMIT 0 [ RunTime:0.003222s ]
SHOW FULL COLUMNS FROM `ds_company_introduction` [ RunTime:0.003394s ]
SELECT company.ty_name,company.store_id,company.shopname,mastertype.name companytype, GROUP_CONCAT(class.gc_name SEPARATOR " ") ptype, company.year, masterusd.name yearmoney, company.introduce,company.company_address,company.company_address_detail, company.num,company.register_no,company.legal_person, date_format( from_unixtime( company.year ), "%Y-%m-%d" ) AS year, company.registration_authority,company.registration_status, company.business_scope,store.grade_id,company.tel, area.area_name,area1.area_name as area_name1,area2.area_name as area_name2,company.company_province_id,sj.auth_verify FROM `ds_company_introduction` `company` LEFT JOIN `ds_store` `store` ON `store`.`store_id`=`company`.`store_id` LEFT JOIN `ds_goodsclass` `class` ON FIND_IN_SET( class.gc_id, company.ptype ) LEFT JOIN `ds_master` `masterusd` ON `masterusd`.`status`=0 and masterusd.id=company.yearmoney and masterusd.type = "zczj" LEFT JOIN `ds_master` `mastertype` ON `mastertype`.`status`=0 and mastertype.id=company.companytype and mastertype.type = "QYLX" LEFT JOIN `ds_area` `area` ON `area`.`area_id`=`company`.`company_province_id` LEFT JOIN `ds_area` `area1` ON `area1`.`area_id`=`company`.`company_city_id` LEFT JOIN `ds_area` `area2` ON `area2`.`area_id`=`company`.`company_area_id` LEFT JOIN `ds_storejoinin` `sj` ON `company`.`userid`=`sj`.`member_id` WHERE `company`.`store_id` IN (77473,77584,109627,109629,109635,109656,109660,109853,109880,109922) GROUP BY `company`.`store_id` [ RunTime:0.007962s ]
SHOW FULL COLUMNS FROM `ds_goods` [ RunTime:0.003045s ]
SELECT COUNT(*) AS think_count FROM `ds_goods` WHERE ( store_id=77473 ) [ RunTime:0.000641s ]
SELECT COUNT(*) AS think_count FROM `ds_goods` WHERE ( store_id=77584 ) [ RunTime:0.000957s ]
SELECT COUNT(*) AS think_count FROM `ds_goods` WHERE ( store_id=109627 ) [ RunTime:0.000611s ]
SELECT COUNT(*) AS think_count FROM `ds_goods` WHERE ( store_id=109629 ) [ RunTime:0.000899s ]
SELECT COUNT(*) AS think_count FROM `ds_goods` WHERE ( store_id=109635 ) [ RunTime:0.000671s ]
SELECT COUNT(*) AS think_count FROM `ds_goods` WHERE ( store_id=109656 ) [ RunTime:0.002402s ]
SELECT COUNT(*) AS think_count FROM `ds_goods` WHERE ( store_id=109660 ) [ RunTime:0.002343s ]
SELECT COUNT(*) AS think_count FROM `ds_goods` WHERE ( store_id=109853 ) [ RunTime:0.000614s ]
SELECT COUNT(*) AS think_count FROM `ds_goods` WHERE ( store_id=109880 ) [ RunTime:0.000723s ]
SELECT COUNT(*) AS think_count FROM `ds_goods` WHERE ( store_id=109922 ) [ RunTime:0.002399s ]

0.625215s

ShowPageTrace