基本文件流程错误 SQL 调试

/data/shop/shop/public/index.php ( 2.52 KB )
/data/shop/shop/public/saas.php ( 5.88 KB )
/data/shop/shop/public/thinkphp/start.php ( 0.74 KB )
/data/shop/shop/public/thinkphp/base.php ( 2.66 KB )
/data/shop/shop/public/thinkphp/library/think/Loader.php ( 20.87 KB )
/data/shop/shop/public/vendor/composer/autoload_namespaces.php ( 0.15 KB )
/data/shop/shop/public/vendor/composer/autoload_psr4.php ( 0.43 KB )
/data/shop/shop/public/vendor/composer/autoload_classmap.php ( 0.82 KB )
/data/shop/shop/public/vendor/composer/autoload_files.php ( 0.42 KB )
/data/shop/shop/public/vendor/topthink/think-helper/src/helper.php ( 2.97 KB )
/data/shop/shop/public/vendor/l-addons/think-addons/src/common.php ( 6.80 KB )
/data/shop/shop/public/thinkphp/library/think/Route.php ( 60.43 KB )
/data/shop/shop/public/thinkphp/library/think/Config.php ( 6.58 KB )
/data/shop/shop/public/thinkphp/library/think/Console.php ( 23.47 KB )
/data/shop/shop/public/thinkphp/library/think/Hook.php ( 4.86 KB )
/data/shop/shop/public/vendor/topthink/think-queue/src/common.php ( 1.22 KB )
/data/shop/shop/public/thinkphp/library/think/Error.php ( 3.93 KB )
/data/shop/shop/public/thinkphp/convention.php ( 10.39 KB )
/data/shop/shop/public/thinkphp/library/think/App.php ( 22.85 KB )
/data/shop/shop/public/thinkphp/library/think/Request.php ( 50.20 KB )
/data/shop/shop/public/application/config.php ( 19.02 KB )
/data/shop/shop/public/application/database.php ( 1.89 KB )
/data/shop/shop/public/application/extra/addons.php ( 0.23 KB )
/data/shop/shop/public/application/tags.php ( 1.12 KB )
/data/shop/shop/public/application/common.php ( 79.89 KB )
/data/shop/shop/public/thinkphp/library/think/Env.php ( 1.25 KB )
/data/shop/shop/public/thinkphp/helper.php ( 23.02 KB )
/data/shop/shop/public/application/function.php ( 49.83 KB )
/data/shop/shop/public/thinkphp/library/think/Debug.php ( 7.37 KB )
/data/shop/shop/public/thinkphp/library/think/Log.php ( 6.27 KB )
/data/shop/shop/public/application/common/behavior/Cross.php ( 0.40 KB )
/data/shop/shop/public/thinkphp/library/think/Lang.php ( 7.49 KB )
/data/shop/shop/public/thinkphp/lang/zh-cn.php ( 248.19 KB )
/data/shop/shop/public/application/lang/zh-cn.php ( 243.15 KB )
/data/shop/shop/public/application/route.php ( 1.28 KB )
/data/shop/shop/public/application/home/config.php ( 0.48 KB )
/data/shop/shop/public/application/home/html.php ( 0.86 KB )
/data/shop/shop/public/application/home/common.php ( 1.32 KB )
/data/shop/shop/public/application/home/controller/Goods.php ( 37.74 KB )
/data/shop/shop/public/application/home/controller/Base.php ( 5.17 KB )
/data/shop/shop/public/thinkphp/library/think/Controller.php ( 8.12 KB )
/data/shop/shop/public/thinkphp/library/traits/controller/Jump.php ( 5.06 KB )
/data/shop/shop/public/thinkphp/library/think/View.php ( 7.01 KB )
/data/shop/shop/public/thinkphp/library/think/view/driver/Think.php ( 5.90 KB )
/data/shop/shop/public/thinkphp/library/think/Template.php ( 46.46 KB )
/data/shop/shop/public/thinkphp/library/think/template/driver/File.php ( 2.24 KB )
/data/shop/shop/public/thinkphp/library/think/Cache.php ( 6.34 KB )
/data/shop/shop/public/thinkphp/library/think/cache/driver/File.php ( 7.48 KB )
/data/shop/shop/public/thinkphp/library/think/cache/Driver.php ( 6.21 KB )
/data/shop/shop/public/thinkphp/library/think/Cookie.php ( 7.80 KB )
/data/shop/shop/public/application/common/logic/UsersLogic.php ( 72.94 KB )
/data/shop/shop/public/application/common/model/Users.php ( 20.46 KB )
/data/shop/shop/public/thinkphp/library/think/Model.php ( 70.39 KB )
/data/shop/shop/public/thinkphp/library/think/Db.php ( 6.85 KB )
/data/shop/shop/public/thinkphp/library/think/db/connector/Mysql.php ( 4.02 KB )
/data/shop/shop/public/thinkphp/library/think/db/Connection.php ( 31.20 KB )
/data/shop/shop/public/thinkphp/library/think/db/Query.php ( 93.21 KB )
/data/shop/shop/public/thinkphp/library/think/db/builder/Mysql.php ( 4.34 KB )
/data/shop/shop/public/thinkphp/library/think/db/Builder.php ( 31.50 KB )
/data/shop/shop/public/application/common/logic/NavigationLogic.php ( 7.81 KB )
/data/shop/shop/public/application/common/model/Navigation.php ( 0.74 KB )
/data/shop/shop/public/thinkphp/library/think/Collection.php ( 11.14 KB )
/data/shop/shop/public/application/common/logic/CommonCategoryLogic.php ( 10.19 KB )
/data/shop/shop/public/application/common/logic/BrandLogic.php ( 6.93 KB )
/data/shop/shop/public/application/common/model/Brand.php ( 3.11 KB )
/data/shop/shop/public/thinkphp/library/think/model/Collection.php ( 2.77 KB )
/data/shop/shop/public/application/common/model/BrandRegion.php ( 0.17 KB )
/data/shop/shop/public/thinkphp/library/think/Session.php ( 10.97 KB )
/data/shop/shop/public/application/common/logic/User.php ( 9.25 KB )
/data/shop/shop/public/thinkphp/library/think/Url.php ( 13.03 KB )
/data/shop/shop/public/addons/assistact/Assistact.php ( 2.34 KB )
/data/shop/shop/public/vendor/l-addons/think-addons/src/Addons.php ( 4.50 KB )
/data/shop/shop/public/thinkphp/library/think/Page.php ( 6.75 KB )
/data/shop/shop/public/application/common/model/Goods.php ( 30.43 KB )
/data/shop/shop/public/application/common/logic/GoodsLogic.php ( 73.77 KB )
/data/shop/shop/public/application/common/logic/UserLevelLogic.php ( 5.08 KB )
/data/shop/shop/public/application/common/model/UserLevel.php ( 1.93 KB )
/data/shop/shop/public/runtime/temp/f4037d9ac8f4e617712353fb44e7efdc.php ( 67.74 KB )
/data/shop/shop/public/thinkphp/library/think/model/relation/HasMany.php ( 9.82 KB )
/data/shop/shop/public/thinkphp/library/think/model/Relation.php ( 3.75 KB )
/data/shop/shop/public/application/common/model/GoodsImages.php ( 0.49 KB )
/data/shop/shop/public/thinkphp/library/think/exception/ErrorException.php ( 1.89 KB )
/data/shop/shop/public/thinkphp/library/think/Exception.php ( 1.66 KB )
/data/shop/shop/public/thinkphp/library/think/template/taglib/Cx.php ( 30.32 KB )
/data/shop/shop/public/thinkphp/library/think/template/TagLib.php ( 12.63 KB )
/data/shop/shop/public/runtime/temp/bb5b5eec6653dbde7e914842444b31a1.php ( 20.36 KB )
/data/shop/shop/public/thinkphp/library/think/Response.php ( 8.66 KB )
/data/shop/shop/public/thinkphp/library/think/exception/HttpResponseException.php ( 0.96 KB )
/data/shop/shop/public/thinkphp/library/think/debug/Html.php ( 4.27 KB )

[ BEHAVIOR ] Run Closure @app_init [ RunTime:0.000011s ]
[ BEHAVIOR ] Run app\common\behavior\Cross @app_init [ RunTime:0.000013s ]
[ LANG ] /data/shop/shop/public/thinkphp/lang/zh-cn.php
[ LANG ] /data/shop/shop/public/application/lang/zh-cn.php
[ ROUTE ] array ( 'type' => 'module', 'module' => array ( 0 => 'home', 1 => 'Goods', 2 => 'goodsList', ), )
[ HEADER ] array ( 'accept-encoding' => 'gzip, br, zstd, deflate', 'user-agent' => 'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)', 'accept' => '*/*', 'x-forwarded-for' => '3.129.216.70', 'x-forwarded-proto' => 'https', 'x-forwarded-host' => 'shop-test.huibaibio.com', 'host' => 'shop-test.huibaibio.com', 'content-type' => '', 'content-length' => '', )
[ PARAM ] array ( 'id' => '568', 'price' => '1723-3446', 'p' => '3', )
[ CACHE ] INIT File
[ DB ] INIT mysql
[ SESSION ] INIT array ( 'id' => '', 'var_session_id' => '', 'prefix' => 'think', 'type' => '', 'auto_start' => true, )
[ BEHAVIOR ] Run Closure @action_begin [ RunTime:0.002681s ]
[ RUN ] app\home\controller\Goods->goodsList[ /data/shop/shop/public/application/home/controller/Goods.php ]
[ VIEW ] ./template/pc/rainbow/goods/goodsList.html [ array ( 0 => 'action', 1 => 'template_now_time', 2 => 'maxNavId', 3 => 'tpShopConfig', 4 => 'goods_category_tree', 5 => 'brand_list', 6 => 'username', 7 => 'head_pic', 8 => 'wx_qr', 9 => 'mobile_url', 10 => 'thumb_empty', 11 => 'user', 12 => 'hotGoodsList', 13 => 'goods_list', 14 => 'filter_menu', 15 => 'filter_brand', 16 => 'filter_price', 17 => 'goodsCate', 18 => 'goods_category', 19 => 'filter_param', 20 => 'cat_id', 21 => 'page', ) ]
[ VIEW ] ./template/pc/rainbow/public/dispatch_jump.html [ array ( 0 => 'action', 1 => 'template_now_time', 2 => 'maxNavId', 3 => 'tpShopConfig', 4 => 'goods_category_tree', 5 => 'brand_list', 6 => 'username', 7 => 'head_pic', 8 => 'wx_qr', 9 => 'mobile_url', 10 => 'thumb_empty', 11 => 'user', 12 => 'hotGoodsList', 13 => 'goods_list', 14 => 'filter_menu', 15 => 'filter_brand', 16 => 'filter_price', 17 => 'goodsCate', 18 => 'goods_category', 19 => 'filter_param', 20 => 'cat_id', 21 => 'page', 22 => 'code', 23 => 'msg', 24 => 'data', 25 => 'url', 26 => 'wait', ) ]

file_put_contents(/data/shop/shop/public/runtime/cache/02ca1ea87eb0bb666465ffa6de939c29/0c/1228ff1d63d40d0f45f1137fb4eeb1.php): failed to open stream: No such file or directory #0 [internal function]: think\Error::appError(2, 'file_put_conten...', '/data/shop/shop...', 159, Array) #1 /data/shop/shop/public/thinkphp/library/think/cache/driver/File.php(159): file_put_contents('/data/shop/shop...', '<?php\n//0000000...') #2 /data/shop/shop/public/thinkphp/library/think/cache/Driver.php(200): think\cache\driver\File->set('tag_94d17d76441...', '/data/shop/shop...', 0) #3 /data/shop/shop/public/thinkphp/library/think/cache/driver/File.php(161): think\cache\Driver->setTagItem('/data/shop/shop...') #4 /data/shop/shop/public/thinkphp/library/think/db/Query.php(2407): think\cache\driver\File->set('3ad23c8f82bb16a...', 'https://hbaisho...', 30) #5 /data/shop/shop/public/thinkphp/library/think/db/Query.php(425): think\db\Query->cacheData('3ad23c8f82bb16a...', 'https://hbaisho...', Array) #6 /data/shop/shop/public/application/common.php(93): think\db\Query->value('original_img') #7 /data/shop/shop/public/runtime/temp/f4037d9ac8f4e617712353fb44e7efdc.php(572): goods_thumb_images(24824, 236, 236) #8 /data/shop/shop/public/thinkphp/library/think/template/driver/File.php(50): include('/data/shop/shop...') #9 /data/shop/shop/public/thinkphp/library/think/Template.php(200): think\template\driver\File->read('/data/shop/shop...', Array) #10 /data/shop/shop/public/thinkphp/library/think/view/driver/Think.php(90): think\Template->fetch('./template/pc/r...', Array, Array) #11 /data/shop/shop/public/thinkphp/library/think/View.php(163): think\view\driver\Think->fetch('./template/pc/r...', Array, Array) #12 /data/shop/shop/public/thinkphp/library/think/Controller.php(170): think\View->fetch('', Array, Array, Array) #13 /data/shop/shop/public/application/home/controller/Goods.php(445): think\Controller->fetch() #14 [internal function]: app\home\controller\Goods->goodsList() #15 /data/shop/shop/public/thinkphp/library/think/App.php(346): ReflectionMethod->invokeArgs(Object(app\home\controller\Goods), Array) #16 /data/shop/shop/public/thinkphp/library/think/App.php(614): think\App::invokeMethod(Array, Array) #17 /data/shop/shop/public/thinkphp/library/think/App.php(459): think\App::module(Array, Array, false) #18 /data/shop/shop/public/thinkphp/library/think/App.php(142): think\App::exec(Array, Array) #19 /data/shop/shop/public/thinkphp/start.php(19): think\App::run() #20 /data/shop/shop/public/index.php(63): require('/data/shop/shop...') #21 {main}

[ DB ] CONNECT:[ UseTime:0.003725s ] mysql:host=127.0.0.1;port=3306;dbname=shop;charset=utf8mb4
[ SQL ] SHOW COLUMNS FROM `m_navigation` [ RunTime:0.005946s ]
[ SQL ] SELECT `id` FROM `m_navigation` WHERE `url` = '/index.php?m=Home&c=Goods&a=goodsList' AND `is_show` = 1 LIMIT 1 [ RunTime:0.012023s ]
[ SQL ] SHOW COLUMNS FROM `m_brand` [ RunTime:0.008108s ]
[ SQL ] SELECT `id`,`name`,`logo`,`is_hot` FROM `m_brand` WHERE `is_show` = 1 ORDER BY `sort` desc,`id` desc [ RunTime:0.006142s ]
[ SQL ] SHOW COLUMNS FROM `m_brand_region` [ RunTime:0.005232s ]
[ SQL ] SELECT a.name as province,b.name as city FROM `m_brand_region` `br` LEFT JOIN `m_region` `a` ON `a`.`id`=`br`.`provinceId` LEFT JOIN `m_region` `b` ON `b`.`id`=`br`.`cityId` WHERE `br`.`brandId` = 103 [ RunTime:0.002747s ]
[ SQL ] SELECT a.name as province,b.name as city FROM `m_brand_region` `br` LEFT JOIN `m_region` `a` ON `a`.`id`=`br`.`provinceId` LEFT JOIN `m_region` `b` ON `b`.`id`=`br`.`cityId` WHERE `br`.`brandId` = 116 [ RunTime:0.002626s ]
[ SQL ] SELECT a.name as province,b.name as city FROM `m_brand_region` `br` LEFT JOIN `m_region` `a` ON `a`.`id`=`br`.`provinceId` LEFT JOIN `m_region` `b` ON `b`.`id`=`br`.`cityId` WHERE `br`.`brandId` = 238 [ RunTime:0.002822s ]
[ SQL ] SELECT a.name as province,b.name as city FROM `m_brand_region` `br` LEFT JOIN `m_region` `a` ON `a`.`id`=`br`.`provinceId` LEFT JOIN `m_region` `b` ON `b`.`id`=`br`.`cityId` WHERE `br`.`brandId` = 237 [ RunTime:0.002600s ]
[ SQL ] SELECT a.name as province,b.name as city FROM `m_brand_region` `br` LEFT JOIN `m_region` `a` ON `a`.`id`=`br`.`provinceId` LEFT JOIN `m_region` `b` ON `b`.`id`=`br`.`cityId` WHERE `br`.`brandId` = 236 [ RunTime:0.002484s ]
[ SQL ] SELECT a.name as province,b.name as city FROM `m_brand_region` `br` LEFT JOIN `m_region` `a` ON `a`.`id`=`br`.`provinceId` LEFT JOIN `m_region` `b` ON `b`.`id`=`br`.`cityId` WHERE `br`.`brandId` = 235 [ RunTime:0.002149s ]
[ SQL ] SELECT a.name as province,b.name as city FROM `m_brand_region` `br` LEFT JOIN `m_region` `a` ON `a`.`id`=`br`.`provinceId` LEFT JOIN `m_region` `b` ON `b`.`id`=`br`.`cityId` WHERE `br`.`brandId` = 234 [ RunTime:0.002309s ]
[ SQL ] SELECT a.name as province,b.name as city FROM `m_brand_region` `br` LEFT JOIN `m_region` `a` ON `a`.`id`=`br`.`provinceId` LEFT JOIN `m_region` `b` ON `b`.`id`=`br`.`cityId` WHERE `br`.`brandId` = 233 [ RunTime:0.002480s ]
[ SQL ] SELECT a.name as province,b.name as city FROM `m_brand_region` `br` LEFT JOIN `m_region` `a` ON `a`.`id`=`br`.`provinceId` LEFT JOIN `m_region` `b` ON `b`.`id`=`br`.`cityId` WHERE `br`.`brandId` = 232 [ RunTime:0.002527s ]
[ SQL ] SELECT a.name as province,b.name as city FROM `m_brand_region` `br` LEFT JOIN `m_region` `a` ON `a`.`id`=`br`.`provinceId` LEFT JOIN `m_region` `b` ON `b`.`id`=`br`.`cityId` WHERE `br`.`brandId` = 231 [ RunTime:0.002659s ]
[ SQL ] SELECT a.name as province,b.name as city FROM `m_brand_region` `br` LEFT JOIN `m_region` `a` ON `a`.`id`=`br`.`provinceId` LEFT JOIN `m_region` `b` ON `b`.`id`=`br`.`cityId` WHERE `br`.`brandId` = 230 [ RunTime:0.002644s ]
[ SQL ] SELECT a.name as province,b.name as city FROM `m_brand_region` `br` LEFT JOIN `m_region` `a` ON `a`.`id`=`br`.`provinceId` LEFT JOIN `m_region` `b` ON `b`.`id`=`br`.`cityId` WHERE `br`.`brandId` = 229 [ RunTime:0.002206s ]
[ SQL ] SELECT a.name as province,b.name as city FROM `m_brand_region` `br` LEFT JOIN `m_region` `a` ON `a`.`id`=`br`.`provinceId` LEFT JOIN `m_region` `b` ON `b`.`id`=`br`.`cityId` WHERE `br`.`brandId` = 228 [ RunTime:0.002297s ]
[ SQL ] SELECT a.name as province,b.name as city FROM `m_brand_region` `br` LEFT JOIN `m_region` `a` ON `a`.`id`=`br`.`provinceId` LEFT JOIN `m_region` `b` ON `b`.`id`=`br`.`cityId` WHERE `br`.`brandId` = 200 [ RunTime:0.002188s ]
[ SQL ] SELECT a.name as province,b.name as city FROM `m_brand_region` `br` LEFT JOIN `m_region` `a` ON `a`.`id`=`br`.`provinceId` LEFT JOIN `m_region` `b` ON `b`.`id`=`br`.`cityId` WHERE `br`.`brandId` = 199 [ RunTime:0.002347s ]
[ SQL ] SELECT a.name as province,b.name as city FROM `m_brand_region` `br` LEFT JOIN `m_region` `a` ON `a`.`id`=`br`.`provinceId` LEFT JOIN `m_region` `b` ON `b`.`id`=`br`.`cityId` WHERE `br`.`brandId` = 198 [ RunTime:0.002713s ]
[ SQL ] SELECT a.name as province,b.name as city FROM `m_brand_region` `br` LEFT JOIN `m_region` `a` ON `a`.`id`=`br`.`provinceId` LEFT JOIN `m_region` `b` ON `b`.`id`=`br`.`cityId` WHERE `br`.`brandId` = 197 [ RunTime:0.002519s ]
[ SQL ] SELECT a.name as province,b.name as city FROM `m_brand_region` `br` LEFT JOIN `m_region` `a` ON `a`.`id`=`br`.`provinceId` LEFT JOIN `m_region` `b` ON `b`.`id`=`br`.`cityId` WHERE `br`.`brandId` = 196 [ RunTime:0.002540s ]
[ SQL ] SELECT a.name as province,b.name as city FROM `m_brand_region` `br` LEFT JOIN `m_region` `a` ON `a`.`id`=`br`.`provinceId` LEFT JOIN `m_region` `b` ON `b`.`id`=`br`.`cityId` WHERE `br`.`brandId` = 195 [ RunTime:0.002220s ]
[ SQL ] SELECT a.name as province,b.name as city FROM `m_brand_region` `br` LEFT JOIN `m_region` `a` ON `a`.`id`=`br`.`provinceId` LEFT JOIN `m_region` `b` ON `b`.`id`=`br`.`cityId` WHERE `br`.`brandId` = 194 [ RunTime:0.002288s ]
[ SQL ] SELECT a.name as province,b.name as city FROM `m_brand_region` `br` LEFT JOIN `m_region` `a` ON `a`.`id`=`br`.`provinceId` LEFT JOIN `m_region` `b` ON `b`.`id`=`br`.`cityId` WHERE `br`.`brandId` = 193 [ RunTime:0.002343s ]
[ SQL ] SELECT a.name as province,b.name as city FROM `m_brand_region` `br` LEFT JOIN `m_region` `a` ON `a`.`id`=`br`.`provinceId` LEFT JOIN `m_region` `b` ON `b`.`id`=`br`.`cityId` WHERE `br`.`brandId` = 192 [ RunTime:0.002581s ]
[ SQL ] SELECT a.name as province,b.name as city FROM `m_brand_region` `br` LEFT JOIN `m_region` `a` ON `a`.`id`=`br`.`provinceId` LEFT JOIN `m_region` `b` ON `b`.`id`=`br`.`cityId` WHERE `br`.`brandId` = 191 [ RunTime:0.002644s ]
[ SQL ] SELECT a.name as province,b.name as city FROM `m_brand_region` `br` LEFT JOIN `m_region` `a` ON `a`.`id`=`br`.`provinceId` LEFT JOIN `m_region` `b` ON `b`.`id`=`br`.`cityId` WHERE `br`.`brandId` = 190 [ RunTime:0.002606s ]
[ SQL ] SELECT a.name as province,b.name as city FROM `m_brand_region` `br` LEFT JOIN `m_region` `a` ON `a`.`id`=`br`.`provinceId` LEFT JOIN `m_region` `b` ON `b`.`id`=`br`.`cityId` WHERE `br`.`brandId` = 158 [ RunTime:0.003076s ]
[ SQL ] SELECT a.name as province,b.name as city FROM `m_brand_region` `br` LEFT JOIN `m_region` `a` ON `a`.`id`=`br`.`provinceId` LEFT JOIN `m_region` `b` ON `b`.`id`=`br`.`cityId` WHERE `br`.`brandId` = 157 [ RunTime:0.003384s ]
[ SQL ] SELECT a.name as province,b.name as city FROM `m_brand_region` `br` LEFT JOIN `m_region` `a` ON `a`.`id`=`br`.`provinceId` LEFT JOIN `m_region` `b` ON `b`.`id`=`br`.`cityId` WHERE `br`.`brandId` = 109 [ RunTime:0.002620s ]
[ SQL ] SELECT a.name as province,b.name as city FROM `m_brand_region` `br` LEFT JOIN `m_region` `a` ON `a`.`id`=`br`.`provinceId` LEFT JOIN `m_region` `b` ON `b`.`id`=`br`.`cityId` WHERE `br`.`brandId` = 108 [ RunTime:0.003146s ]
[ SQL ] SELECT a.name as province,b.name as city FROM `m_brand_region` `br` LEFT JOIN `m_region` `a` ON `a`.`id`=`br`.`provinceId` LEFT JOIN `m_region` `b` ON `b`.`id`=`br`.`cityId` WHERE `br`.`brandId` = 107 [ RunTime:0.004302s ]
[ SQL ] SELECT a.name as province,b.name as city FROM `m_brand_region` `br` LEFT JOIN `m_region` `a` ON `a`.`id`=`br`.`provinceId` LEFT JOIN `m_region` `b` ON `b`.`id`=`br`.`cityId` WHERE `br`.`brandId` = 106 [ RunTime:0.004525s ]
[ SQL ] SELECT a.name as province,b.name as city FROM `m_brand_region` `br` LEFT JOIN `m_region` `a` ON `a`.`id`=`br`.`provinceId` LEFT JOIN `m_region` `b` ON `b`.`id`=`br`.`cityId` WHERE `br`.`brandId` = 105 [ RunTime:0.004427s ]
[ SQL ] SELECT a.name as province,b.name as city FROM `m_brand_region` `br` LEFT JOIN `m_region` `a` ON `a`.`id`=`br`.`provinceId` LEFT JOIN `m_region` `b` ON `b`.`id`=`br`.`cityId` WHERE `br`.`brandId` = 104 [ RunTime:0.003661s ]
[ SQL ] SELECT a.name as province,b.name as city FROM `m_brand_region` `br` LEFT JOIN `m_region` `a` ON `a`.`id`=`br`.`provinceId` LEFT JOIN `m_region` `b` ON `b`.`id`=`br`.`cityId` WHERE `br`.`brandId` = 102 [ RunTime:0.005675s ]
[ SQL ] SELECT a.name as province,b.name as city FROM `m_brand_region` `br` LEFT JOIN `m_region` `a` ON `a`.`id`=`br`.`provinceId` LEFT JOIN `m_region` `b` ON `b`.`id`=`br`.`cityId` WHERE `br`.`brandId` = 101 [ RunTime:0.004042s ]
[ SQL ] SELECT a.name as province,b.name as city FROM `m_brand_region` `br` LEFT JOIN `m_region` `a` ON `a`.`id`=`br`.`provinceId` LEFT JOIN `m_region` `b` ON `b`.`id`=`br`.`cityId` WHERE `br`.`brandId` = 100 [ RunTime:0.003678s ]
[ SQL ] SELECT a.name as province,b.name as city FROM `m_brand_region` `br` LEFT JOIN `m_region` `a` ON `a`.`id`=`br`.`provinceId` LEFT JOIN `m_region` `b` ON `b`.`id`=`br`.`cityId` WHERE `br`.`brandId` = 99 [ RunTime:0.002507s ]
[ SQL ] SELECT a.name as province,b.name as city FROM `m_brand_region` `br` LEFT JOIN `m_region` `a` ON `a`.`id`=`br`.`provinceId` LEFT JOIN `m_region` `b` ON `b`.`id`=`br`.`cityId` WHERE `br`.`brandId` = 98 [ RunTime:0.002649s ]
[ SQL ] SELECT a.name as province,b.name as city FROM `m_brand_region` `br` LEFT JOIN `m_region` `a` ON `a`.`id`=`br`.`provinceId` LEFT JOIN `m_region` `b` ON `b`.`id`=`br`.`cityId` WHERE `br`.`brandId` = 97 [ RunTime:0.002743s ]
[ SQL ] SELECT a.name as province,b.name as city FROM `m_brand_region` `br` LEFT JOIN `m_region` `a` ON `a`.`id`=`br`.`provinceId` LEFT JOIN `m_region` `b` ON `b`.`id`=`br`.`cityId` WHERE `br`.`brandId` = 96 [ RunTime:0.002546s ]
[ SQL ] SELECT a.name as province,b.name as city FROM `m_brand_region` `br` LEFT JOIN `m_region` `a` ON `a`.`id`=`br`.`provinceId` LEFT JOIN `m_region` `b` ON `b`.`id`=`br`.`cityId` WHERE `br`.`brandId` = 95 [ RunTime:0.002446s ]
[ SQL ] SELECT a.name as province,b.name as city FROM `m_brand_region` `br` LEFT JOIN `m_region` `a` ON `a`.`id`=`br`.`provinceId` LEFT JOIN `m_region` `b` ON `b`.`id`=`br`.`cityId` WHERE `br`.`brandId` = 94 [ RunTime:0.002556s ]
[ SQL ] SELECT a.name as province,b.name as city FROM `m_brand_region` `br` LEFT JOIN `m_region` `a` ON `a`.`id`=`br`.`provinceId` LEFT JOIN `m_region` `b` ON `b`.`id`=`br`.`cityId` WHERE `br`.`brandId` = 93 [ RunTime:0.002638s ]
[ SQL ] SELECT a.name as province,b.name as city FROM `m_brand_region` `br` LEFT JOIN `m_region` `a` ON `a`.`id`=`br`.`provinceId` LEFT JOIN `m_region` `b` ON `b`.`id`=`br`.`cityId` WHERE `br`.`brandId` = 92 [ RunTime:0.002151s ]
[ SQL ] SELECT a.name as province,b.name as city FROM `m_brand_region` `br` LEFT JOIN `m_region` `a` ON `a`.`id`=`br`.`provinceId` LEFT JOIN `m_region` `b` ON `b`.`id`=`br`.`cityId` WHERE `br`.`brandId` = 91 [ RunTime:0.002026s ]
[ SQL ] SELECT a.name as province,b.name as city FROM `m_brand_region` `br` LEFT JOIN `m_region` `a` ON `a`.`id`=`br`.`provinceId` LEFT JOIN `m_region` `b` ON `b`.`id`=`br`.`cityId` WHERE `br`.`brandId` = 80 [ RunTime:0.002108s ]
[ SQL ] SELECT a.name as province,b.name as city FROM `m_brand_region` `br` LEFT JOIN `m_region` `a` ON `a`.`id`=`br`.`provinceId` LEFT JOIN `m_region` `b` ON `b`.`id`=`br`.`cityId` WHERE `br`.`brandId` = 70 [ RunTime:0.002004s ]
[ SQL ] SELECT a.name as province,b.name as city FROM `m_brand_region` `br` LEFT JOIN `m_region` `a` ON `a`.`id`=`br`.`provinceId` LEFT JOIN `m_region` `b` ON `b`.`id`=`br`.`cityId` WHERE `br`.`brandId` = 69 [ RunTime:0.002251s ]
[ SQL ] SELECT a.name as province,b.name as city FROM `m_brand_region` `br` LEFT JOIN `m_region` `a` ON `a`.`id`=`br`.`provinceId` LEFT JOIN `m_region` `b` ON `b`.`id`=`br`.`cityId` WHERE `br`.`brandId` = 63 [ RunTime:0.002139s ]
[ SQL ] SELECT a.name as province,b.name as city FROM `m_brand_region` `br` LEFT JOIN `m_region` `a` ON `a`.`id`=`br`.`provinceId` LEFT JOIN `m_region` `b` ON `b`.`id`=`br`.`cityId` WHERE `br`.`brandId` = 61 [ RunTime:0.002160s ]
[ SQL ] SELECT a.name as province,b.name as city FROM `m_brand_region` `br` LEFT JOIN `m_region` `a` ON `a`.`id`=`br`.`provinceId` LEFT JOIN `m_region` `b` ON `b`.`id`=`br`.`cityId` WHERE `br`.`brandId` = 58 [ RunTime:0.002158s ]
[ SQL ] SELECT a.name as province,b.name as city FROM `m_brand_region` `br` LEFT JOIN `m_region` `a` ON `a`.`id`=`br`.`provinceId` LEFT JOIN `m_region` `b` ON `b`.`id`=`br`.`cityId` WHERE `br`.`brandId` = 57 [ RunTime:0.002162s ]
[ SQL ] SELECT a.name as province,b.name as city FROM `m_brand_region` `br` LEFT JOIN `m_region` `a` ON `a`.`id`=`br`.`provinceId` LEFT JOIN `m_region` `b` ON `b`.`id`=`br`.`cityId` WHERE `br`.`brandId` = 56 [ RunTime:0.001967s ]
[ SQL ] SELECT a.name as province,b.name as city FROM `m_brand_region` `br` LEFT JOIN `m_region` `a` ON `a`.`id`=`br`.`provinceId` LEFT JOIN `m_region` `b` ON `b`.`id`=`br`.`cityId` WHERE `br`.`brandId` = 55 [ RunTime:0.002001s ]
[ SQL ] SELECT a.name as province,b.name as city FROM `m_brand_region` `br` LEFT JOIN `m_region` `a` ON `a`.`id`=`br`.`provinceId` LEFT JOIN `m_region` `b` ON `b`.`id`=`br`.`cityId` WHERE `br`.`brandId` = 54 [ RunTime:0.002717s ]
[ SQL ] SHOW COLUMNS FROM `m_users` [ RunTime:0.005680s ]
[ SQL ] SELECT * FROM `m_users` WHERE `user_id` = 0 LIMIT 1 [ RunTime:0.004667s ]
[ SQL ] SHOW COLUMNS FROM `m_wx_user` [ RunTime:0.005209s ]
[ SQL ] SELECT `qr` FROM `m_wx_user` LIMIT 1 [ RunTime:0.002859s ]
[ SQL ] SHOW COLUMNS FROM `m_goods` [ RunTime:0.011658s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `m_goods` WHERE `market_price` BETWEEN 1723 AND 3446 AND `cat_id` IN (568,569,580,598,626,628,629,630,635,636,708,774,775) AND `exchange_integral` = 0 AND `is_on_sale` = 1 AND `is_virtual` <> 2 LIMIT 1 [ RunTime:0.007742s ]
[ SQL ] SELECT `goods_id` FROM `m_goods` WHERE `market_price` BETWEEN 1723 AND 3446 AND `cat_id` IN (568,569,580,598,626,628,629,630,635,636,708,774,775) AND `exchange_integral` = 0 AND `is_on_sale` = 1 AND `is_virtual` <> 2 ORDER BY sort desc LIMIT 40,20 [ RunTime:0.004699s ]
[ SQL ] SELECT `goods_id`,`goods_sn`,`cat_id`,`brand_id`,`goods_name`,`prom_type`,`prom_id`,`store_count`,`sort`,`exchange_integral`,`is_hot`,`is_new`,`is_on_sale`,`is_virtual`,`enquiry`,`market_price`,`generalMemberPrice`,`agentPrice` FROM `m_goods` WHERE `goods_id` IN (24824,24096,24100,24830,24831,24836,24842,24837,24834,24138,24142,24149,24150,24153,24143,24144,24151,24152,24154,24146) ORDER BY sort desc [ RunTime:0.003583s ]
[ SQL ] SELECT `brand_id` FROM `m_goods` WHERE `market_price` BETWEEN 1723 AND 3446 AND `cat_id` IN (568,569,580,598,626,628,629,630,635,636,708,774,775) AND `exchange_integral` = 0 AND `is_on_sale` = 1 AND `is_virtual` <> 2 GROUP BY `brand_id` [ RunTime:0.007452s ]
[ SQL ] SELECT * FROM `m_brand` WHERE `id` IN (92,61,237) ORDER BY `sort` desc,`id` desc LIMIT 30 [ RunTime:0.003448s ]
[ SQL ] SELECT `goods_id`,`goods_sn`,`cat_id`,`brand_id`,`goods_name`,`prom_type`,`prom_id`,`store_count`,`sort`,`exchange_integral`,`is_hot`,`is_new`,`is_on_sale`,`is_virtual`,`enquiry`,`market_price`,`generalMemberPrice`,`agentPrice` FROM `m_goods` WHERE `is_hot` = 1 AND `is_on_sale` = 1 AND `exchange_integral` = 0 AND `is_virtual` <> 2 LIMIT 0,5 [ RunTime:0.002299s ]
[ SQL ] SELECT `original_img` FROM `m_goods` WHERE `goods_id` = 24152 LIMIT 1 [ RunTime:0.004792s ]
[ SQL ] SHOW COLUMNS FROM `m_goods_images` [ RunTime:0.003018s ]
[ SQL ] SELECT * FROM `m_goods_images` WHERE `goods_id` = 24152 ORDER BY `img_id` [ RunTime:0.002347s ]
[ SQL ] SELECT `original_img` FROM `m_goods` WHERE `goods_id` = 24842 LIMIT 1 [ RunTime:0.001045s ]
[ SQL ] SELECT * FROM `m_goods_images` WHERE `goods_id` = 24842 ORDER BY `img_id` [ RunTime:0.000443s ]
[ SQL ] SELECT `original_img` FROM `m_goods` WHERE `goods_id` = 24837 LIMIT 1 [ RunTime:0.000393s ]
[ SQL ] SELECT * FROM `m_goods_images` WHERE `goods_id` = 24837 ORDER BY `img_id` [ RunTime:0.002963s ]
[ SQL ] SELECT `original_img` FROM `m_goods` WHERE `goods_id` = 24836 LIMIT 1 [ RunTime:0.000332s ]
[ SQL ] SELECT * FROM `m_goods_images` WHERE `goods_id` = 24836 ORDER BY `img_id` [ RunTime:0.000337s ]
[ SQL ] SELECT `original_img` FROM `m_goods` WHERE `goods_id` = 24834 LIMIT 1 [ RunTime:0.000279s ]
[ SQL ] SELECT * FROM `m_goods_images` WHERE `goods_id` = 24834 ORDER BY `img_id` [ RunTime:0.000319s ]
[ SQL ] SELECT `original_img` FROM `m_goods` WHERE `goods_id` = 24831 LIMIT 1 [ RunTime:0.007775s ]
[ SQL ] SELECT * FROM `m_goods_images` WHERE `goods_id` = 24831 ORDER BY `img_id` [ RunTime:0.002776s ]
[ SQL ] SELECT `original_img` FROM `m_goods` WHERE `goods_id` = 24830 LIMIT 1 [ RunTime:0.000301s ]
[ SQL ] SELECT * FROM `m_goods_images` WHERE `goods_id` = 24830 ORDER BY `img_id` [ RunTime:0.001942s ]
[ SQL ] SELECT `original_img` FROM `m_goods` WHERE `goods_id` = 24824 LIMIT 1 [ RunTime:0.003404s ]

试剂

耗材

通用仪器

高端仪器

服务

药品