基本文件流程错误 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.000010s ]
[ BEHAVIOR ] Run app\common\behavior\Cross @app_init [ RunTime:0.000015s ]
[ 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.135.190.40', 'x-forwarded-proto' => 'https', 'x-forwarded-host' => 'shop-test.huibaibio.com', 'host' => 'shop-test.huibaibio.com', 'content-type' => '', 'content-length' => '', )
[ PARAM ] array ( 'id' => '701', 'price' => '3798-7596', 'p' => '147', )
[ 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.000221s ]
[ 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('8fc225b8daa09e1...', 'https://hbaisho...', 30) #5 /data/shop/shop/public/thinkphp/library/think/db/Query.php(425): think\db\Query->cacheData('8fc225b8daa09e1...', '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(10819, 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.008847s ] mysql:host=127.0.0.1;port=3306;dbname=shop;charset=utf8mb4
[ SQL ] SHOW COLUMNS FROM `m_navigation` [ RunTime:0.007331s ]
[ SQL ] SELECT `id` FROM `m_navigation` WHERE `url` = '/index.php?m=Home&c=Goods&a=goodsList' AND `is_show` = 1 LIMIT 1 [ RunTime:0.010081s ]
[ SQL ] SHOW COLUMNS FROM `m_brand` [ RunTime:0.007624s ]
[ SQL ] SELECT `id`,`name`,`logo`,`is_hot` FROM `m_brand` WHERE `is_show` = 1 ORDER BY `sort` desc,`id` desc [ RunTime:0.009509s ]
[ SQL ] SHOW COLUMNS FROM `m_brand_region` [ RunTime:0.007575s ]
[ 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.002137s ]
[ 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.002783s ]
[ 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.003153s ]
[ 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.002867s ]
[ 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.002266s ]
[ 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.002630s ]
[ 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.002688s ]
[ 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.003058s ]
[ 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.000604s ]
[ 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.000754s ]
[ 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.001278s ]
[ 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.001030s ]
[ 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.000855s ]
[ 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.000371s ]
[ 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.000799s ]
[ 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.000978s ]
[ 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.000771s ]
[ 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.000645s ]
[ 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.000696s ]
[ 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.000744s ]
[ 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.000691s ]
[ 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.000686s ]
[ 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.000697s ]
[ 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.002102s ]
[ 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.000429s ]
[ 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.000378s ]
[ 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.000327s ]
[ 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.000355s ]
[ 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.000817s ]
[ 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.000326s ]
[ 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.000336s ]
[ 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.000413s ]
[ 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.000452s ]
[ 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.003647s ]
[ 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.001618s ]
[ 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.000812s ]
[ 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.000323s ]
[ 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.000363s ]
[ 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.000309s ]
[ 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.000303s ]
[ 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.000353s ]
[ 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.000379s ]
[ 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.000281s ]
[ 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.000368s ]
[ 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.000349s ]
[ 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.000329s ]
[ 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.000340s ]
[ 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.000316s ]
[ 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.000343s ]
[ 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.000337s ]
[ 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.000364s ]
[ 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.000315s ]
[ 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.000355s ]
[ 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.000380s ]
[ SQL ] SHOW COLUMNS FROM `m_users` [ RunTime:0.002288s ]
[ SQL ] SELECT * FROM `m_users` WHERE `user_id` = 0 LIMIT 1 [ RunTime:0.000603s ]
[ SQL ] SHOW COLUMNS FROM `m_wx_user` [ RunTime:0.002845s ]
[ SQL ] SELECT `qr` FROM `m_wx_user` LIMIT 1 [ RunTime:0.000242s ]
[ SQL ] SHOW COLUMNS FROM `m_goods` [ RunTime:0.002454s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `m_goods` WHERE `market_price` BETWEEN 3798 AND 7596 AND `cat_id` = 701 AND `exchange_integral` = 0 AND `is_on_sale` = 1 AND `is_virtual` <> 2 LIMIT 1 [ RunTime:0.014197s ]
[ SQL ] SELECT `goods_id` FROM `m_goods` WHERE `market_price` BETWEEN 3798 AND 7596 AND `cat_id` = 701 AND `exchange_integral` = 0 AND `is_on_sale` = 1 AND `is_virtual` <> 2 ORDER BY sort desc LIMIT 2920,20 [ RunTime:0.024966s ]
[ 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 (10819,10849,10852,10858,10864,10882,10900,10915,10930,10933,10939,10945,10948,10951,10957,10960,10963,10966,10969,10972) ORDER BY sort desc [ RunTime:0.000738s ]
[ SQL ] SELECT * FROM `m_brand` WHERE `id` IN (69) ORDER BY `sort` desc,`id` desc LIMIT 30 [ RunTime:0.000561s ]
[ 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.000515s ]
[ SQL ] SELECT `original_img` FROM `m_goods` WHERE `goods_id` = 10939 LIMIT 1 [ RunTime:0.001474s ]
[ SQL ] SHOW COLUMNS FROM `m_goods_images` [ RunTime:0.002087s ]
[ SQL ] SELECT * FROM `m_goods_images` WHERE `goods_id` = 10939 ORDER BY `img_id` [ RunTime:0.001287s ]
[ SQL ] SELECT `original_img` FROM `m_goods` WHERE `goods_id` = 10972 LIMIT 1 [ RunTime:0.001204s ]
[ SQL ] SELECT * FROM `m_goods_images` WHERE `goods_id` = 10972 ORDER BY `img_id` [ RunTime:0.001340s ]
[ SQL ] SELECT `original_img` FROM `m_goods` WHERE `goods_id` = 10969 LIMIT 1 [ RunTime:0.001268s ]
[ SQL ] SELECT * FROM `m_goods_images` WHERE `goods_id` = 10969 ORDER BY `img_id` [ RunTime:0.001377s ]
[ SQL ] SELECT `original_img` FROM `m_goods` WHERE `goods_id` = 10966 LIMIT 1 [ RunTime:0.001184s ]
[ SQL ] SELECT * FROM `m_goods_images` WHERE `goods_id` = 10966 ORDER BY `img_id` [ RunTime:0.001745s ]
[ SQL ] SELECT `original_img` FROM `m_goods` WHERE `goods_id` = 10963 LIMIT 1 [ RunTime:0.003588s ]
[ SQL ] SELECT * FROM `m_goods_images` WHERE `goods_id` = 10963 ORDER BY `img_id` [ RunTime:0.002677s ]
[ SQL ] SELECT `original_img` FROM `m_goods` WHERE `goods_id` = 10960 LIMIT 1 [ RunTime:0.006667s ]
[ SQL ] SELECT * FROM `m_goods_images` WHERE `goods_id` = 10960 ORDER BY `img_id` [ RunTime:0.021747s ]
[ SQL ] SELECT `original_img` FROM `m_goods` WHERE `goods_id` = 10957 LIMIT 1 [ RunTime:0.006818s ]
[ SQL ] SELECT * FROM `m_goods_images` WHERE `goods_id` = 10957 ORDER BY `img_id` [ RunTime:0.006011s ]
[ SQL ] SELECT `original_img` FROM `m_goods` WHERE `goods_id` = 10951 LIMIT 1 [ RunTime:0.004742s ]
[ SQL ] SELECT * FROM `m_goods_images` WHERE `goods_id` = 10951 ORDER BY `img_id` [ RunTime:0.002880s ]
[ SQL ] SELECT `original_img` FROM `m_goods` WHERE `goods_id` = 10948 LIMIT 1 [ RunTime:0.008280s ]
[ SQL ] SELECT * FROM `m_goods_images` WHERE `goods_id` = 10948 ORDER BY `img_id` [ RunTime:0.009536s ]
[ SQL ] SELECT `original_img` FROM `m_goods` WHERE `goods_id` = 10945 LIMIT 1 [ RunTime:0.004824s ]
[ SQL ] SELECT * FROM `m_goods_images` WHERE `goods_id` = 10945 ORDER BY `img_id` [ RunTime:0.008639s ]
[ SQL ] SELECT `original_img` FROM `m_goods` WHERE `goods_id` = 10819 LIMIT 1 [ RunTime:0.009737s ]

试剂

耗材

通用仪器

高端仪器

服务

药品