基本文件流程错误 SQL 调试

/data/shop/shop/public/index.php ( 3.07 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/application/common/model/Config.php ( 0.16 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/thinkphp/library/think/model/Collection.php ( 2.77 KB )
/data/shop/shop/public/thinkphp/library/think/Collection.php ( 11.14 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/application/common/logic/NavigationLogic.php ( 7.81 KB )
/data/shop/shop/public/application/common/model/Navigation.php ( 0.74 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/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.000021s ]
[ BEHAVIOR ] Run app\common\behavior\Cross @app_init [ RunTime:0.000022s ]
[ 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 ( 'cookie' => 'PHPSESSID=42v2vof0t7kg34nl5e7adplr70; is_mobile=0; sl-session=4Z/UOhtpzGiod5h9l08tQg==', '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' => '216.73.216.138', 'x-forwarded-proto' => 'https', 'x-forwarded-host' => 'shop-test.huibaibio.com', 'host' => 'shop-test.huibaibio.com', 'content-type' => '', 'content-length' => '', )
[ PARAM ] array ( 'id' => '527', 'price' => '960-1920', 'p' => '11', )
[ 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.000124s ]
[ 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_get_contents(/data/shop/shop/public/runtime/cache/02ca1ea87eb0bb666465ffa6de939c29/9c/2709e8ae04dc00ce09c4fb5c6b6833.php): failed to open stream: No such file or directory #0 [internal function]: think\Error::appError(2, 'file_get_conten...', '/data/shop/shop...', 113, Array) #1 /data/shop/shop/public/thinkphp/library/think/cache/driver/File.php(113): file_get_contents('/data/shop/shop...') #2 /data/shop/shop/public/thinkphp/library/think/Cache.php(133): think\cache\driver\File->get('fc14de25f3ea2da...', false) #3 /data/shop/shop/public/thinkphp/library/think/db/Query.php(407): think\Cache::get('fc14de25f3ea2da...') #4 /data/shop/shop/public/application/common.php(93): think\db\Query->value('original_img') #5 /data/shop/shop/public/runtime/temp/f4037d9ac8f4e617712353fb44e7efdc.php(572): goods_thumb_images(24721, 236, 236) #6 /data/shop/shop/public/thinkphp/library/think/template/driver/File.php(50): include('/data/shop/shop...') #7 /data/shop/shop/public/thinkphp/library/think/Template.php(200): think\template\driver\File->read('/data/shop/shop...', Array) #8 /data/shop/shop/public/thinkphp/library/think/view/driver/Think.php(90): think\Template->fetch('./template/pc/r...', Array, Array) #9 /data/shop/shop/public/thinkphp/library/think/View.php(163): think\view\driver\Think->fetch('./template/pc/r...', Array, Array) #10 /data/shop/shop/public/thinkphp/library/think/Controller.php(170): think\View->fetch('', Array, Array, Array) #11 /data/shop/shop/public/application/home/controller/Goods.php(445): think\Controller->fetch() #12 [internal function]: app\home\controller\Goods->goodsList() #13 /data/shop/shop/public/thinkphp/library/think/App.php(346): ReflectionMethod->invokeArgs(Object(app\home\controller\Goods), Array) #14 /data/shop/shop/public/thinkphp/library/think/App.php(614): think\App::invokeMethod(Array, Array) #15 /data/shop/shop/public/thinkphp/library/think/App.php(459): think\App::module(Array, Array, false) #16 /data/shop/shop/public/thinkphp/library/think/App.php(142): think\App::exec(Array, Array) #17 /data/shop/shop/public/thinkphp/start.php(19): think\App::run() #18 /data/shop/shop/public/index.php(84): require('/data/shop/shop...') #19 {main}

[ DB ] CONNECT:[ UseTime:0.000550s ] mysql:host=127.0.0.1;port=3306;dbname=shop;charset=utf8mb4
[ SQL ] SHOW COLUMNS FROM `m_config` [ RunTime:0.001593s ]
[ SQL ] SELECT * FROM `m_config` WHERE `inc_type` = 'shop_info' [ RunTime:0.000563s ]
[ SQL ] SHOW COLUMNS FROM `m_navigation` [ RunTime:0.001097s ]
[ SQL ] SELECT `id` FROM `m_navigation` WHERE `url` = '/index.php?m=Home&c=Goods&a=goodsList' AND `is_show` = 1 LIMIT 1 [ RunTime:0.001584s ]
[ SQL ] SELECT * FROM `m_config` [ RunTime:0.000540s ]
[ SQL ] SHOW COLUMNS FROM `m_goods_category` [ RunTime:0.001491s ]
[ SQL ] SELECT `c`.*,count(s.id) as has_children FROM `m_goods_category` `c` LEFT JOIN `m_goods_category` `s` ON `s`.`parent_id`=`c`.`id` WHERE `c`.`is_show` = 1 GROUP BY `c`.`id` ORDER BY parent_id asc,sort_order asc [ RunTime:0.001600s ]
[ SQL ] SHOW COLUMNS FROM `m_brand` [ RunTime:0.001556s ]
[ SQL ] SELECT `id`,`name`,`logo`,`is_hot` FROM `m_brand` WHERE `is_show` = 1 ORDER BY `sort` desc,`id` desc [ RunTime:0.003109s ]
[ SQL ] SHOW COLUMNS FROM `m_brand_region` [ RunTime:0.001301s ]
[ 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.000344s ]
[ 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.000236s ]
[ 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.002615s ]
[ 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.000262s ]
[ 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.000622s ]
[ 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.000325s ]
[ 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.000272s ]
[ 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.001348s ]
[ 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.000258s ]
[ 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.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` = 230 [ RunTime:0.000227s ]
[ 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.000342s ]
[ 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.000402s ]
[ 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.000253s ]
[ 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.001238s ]
[ 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.000243s ]
[ 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.003142s ]
[ 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.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` = 195 [ RunTime:0.000365s ]
[ 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.000331s ]
[ 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.000328s ]
[ 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.000283s ]
[ 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.000767s ]
[ 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.000287s ]
[ 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.000372s ]
[ 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.000396s ]
[ 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.000347s ]
[ 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.000350s ]
[ 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.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` = 106 [ RunTime:0.000393s ]
[ 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.000361s ]
[ 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.000399s ]
[ 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.000356s ]
[ 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.000392s ]
[ 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.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` = 99 [ RunTime:0.000585s ]
[ 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.000356s ]
[ 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.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` = 96 [ RunTime:0.000331s ]
[ 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.000346s ]
[ 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.000350s ]
[ 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.000392s ]
[ 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.000354s ]
[ 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.000380s ]
[ 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.000348s ]
[ 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.000370s ]
[ 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.000763s ]
[ 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.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` = 61 [ RunTime:0.000383s ]
[ 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.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` = 57 [ 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` = 56 [ RunTime:0.000222s ]
[ 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.000308s ]
[ 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.000372s ]
[ SQL ] SHOW COLUMNS FROM `m_users` [ RunTime:0.002130s ]
[ SQL ] SELECT * FROM `m_users` WHERE `user_id` = 0 LIMIT 1 [ RunTime:0.000574s ]
[ SQL ] SHOW COLUMNS FROM `m_wx_user` [ RunTime:0.001497s ]
[ SQL ] SELECT `qr` FROM `m_wx_user` LIMIT 1 [ RunTime:0.000328s ]
[ SQL ] SHOW COLUMNS FROM `m_goods` [ RunTime:0.002333s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `m_goods` WHERE `market_price` BETWEEN 960 AND 1920 AND `cat_id` IN (527,528,529,534,535,544,545,552,553,557,560,564,568,569,580,595,598,608,609,610,618,623,624,625,626,627,628,629,630,631,632,633,634,635,636,640,680,681,708,709,730,759,773,774,775) AND `exchange_integral` = 0 AND `is_on_sale` = 1 AND `is_virtual` <> 2 LIMIT 1 [ RunTime:0.002109s ]
[ SQL ] SELECT `goods_id` FROM `m_goods` WHERE `market_price` BETWEEN 960 AND 1920 AND `cat_id` IN (527,528,529,534,535,544,545,552,553,557,560,564,568,569,580,595,598,608,609,610,618,623,624,625,626,627,628,629,630,631,632,633,634,635,636,640,680,681,708,709,730,759,773,774,775) AND `exchange_integral` = 0 AND `is_on_sale` = 1 AND `is_virtual` <> 2 ORDER BY sort desc LIMIT 200,20 [ RunTime:0.002228s ]
[ 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 (25176,24722,25164,24779,25175,25177,24718,24721,24719,24723,24720,25163,24717,24804,24806,24805,25160,25159,25161,25162) ORDER BY sort desc [ RunTime:0.000627s ]
[ SQL ] SELECT * FROM `m_brand` WHERE `id` IN (61,92,56) ORDER BY `sort` desc,`id` desc LIMIT 30 [ RunTime:0.000489s ]
[ 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.000408s ]
[ SQL ] SELECT * FROM `m_navigation` where is_show = 1 and position = 'top' ORDER BY `sort` DESC [ RunTime:0.001314s ]
[ SQL ] SELECT `original_img` FROM `m_goods` WHERE `goods_id` = 55 LIMIT 1 [ RunTime:0.000326s ]
[ SQL ] SELECT * FROM `m_config` WHERE `inc_type` = 'oss' [ RunTime:0.000528s ]
[ SQL ] SELECT `original_img` FROM `m_goods` WHERE `goods_id` = 56 LIMIT 1 [ RunTime:0.000319s ]
[ SQL ] SELECT `original_img` FROM `m_goods` WHERE `goods_id` = 69 LIMIT 1 [ RunTime:0.000305s ]
[ SQL ] SELECT `original_img` FROM `m_goods` WHERE `goods_id` = 3051 LIMIT 1 [ RunTime:0.000298s ]
[ SQL ] SELECT `original_img` FROM `m_goods` WHERE `goods_id` = 3054 LIMIT 1 [ RunTime:0.000361s ]
[ SQL ] SELECT `original_img` FROM `m_goods` WHERE `goods_id` = 24806 LIMIT 1 [ RunTime:0.000327s ]
[ SQL ] SHOW COLUMNS FROM `m_goods_images` [ RunTime:0.001173s ]
[ SQL ] SELECT * FROM `m_goods_images` WHERE `goods_id` = 24806 ORDER BY `img_id` [ RunTime:0.000402s ]
[ SQL ] SELECT `original_img` FROM `m_goods` WHERE `goods_id` = 25177 LIMIT 1 [ RunTime:0.000324s ]
[ SQL ] SELECT * FROM `m_goods_images` WHERE `goods_id` = 25177 ORDER BY `img_id` [ RunTime:0.000369s ]
[ SQL ] SELECT `original_img` FROM `m_goods` WHERE `goods_id` = 25176 LIMIT 1 [ RunTime:0.000349s ]
[ SQL ] SELECT * FROM `m_goods_images` WHERE `goods_id` = 25176 ORDER BY `img_id` [ RunTime:0.000377s ]
[ SQL ] SELECT `original_img` FROM `m_goods` WHERE `goods_id` = 25175 LIMIT 1 [ RunTime:0.000402s ]
[ SQL ] SELECT * FROM `m_goods_images` WHERE `goods_id` = 25175 ORDER BY `img_id` [ RunTime:0.000257s ]
[ SQL ] SELECT `original_img` FROM `m_goods` WHERE `goods_id` = 25164 LIMIT 1 [ RunTime:0.000258s ]
[ SQL ] SELECT * FROM `m_goods_images` WHERE `goods_id` = 25164 ORDER BY `img_id` [ RunTime:0.000366s ]
[ SQL ] SELECT `original_img` FROM `m_goods` WHERE `goods_id` = 25163 LIMIT 1 [ RunTime:0.000327s ]
[ SQL ] SELECT * FROM `m_goods_images` WHERE `goods_id` = 25163 ORDER BY `img_id` [ RunTime:0.000346s ]
[ SQL ] SELECT `original_img` FROM `m_goods` WHERE `goods_id` = 25162 LIMIT 1 [ RunTime:0.000343s ]
[ SQL ] SELECT * FROM `m_goods_images` WHERE `goods_id` = 25162 ORDER BY `img_id` [ RunTime:0.000329s ]
[ SQL ] SELECT `original_img` FROM `m_goods` WHERE `goods_id` = 25161 LIMIT 1 [ RunTime:0.000329s ]
[ SQL ] SELECT * FROM `m_goods_images` WHERE `goods_id` = 25161 ORDER BY `img_id` [ RunTime:0.000286s ]
[ SQL ] SELECT `original_img` FROM `m_goods` WHERE `goods_id` = 25160 LIMIT 1 [ RunTime:0.005007s ]
[ SQL ] SELECT * FROM `m_goods_images` WHERE `goods_id` = 25160 ORDER BY `img_id` [ RunTime:0.006484s ]
[ SQL ] SELECT `original_img` FROM `m_goods` WHERE `goods_id` = 25159 LIMIT 1 [ RunTime:0.006645s ]
[ SQL ] SELECT * FROM `m_goods_images` WHERE `goods_id` = 25159 ORDER BY `img_id` [ RunTime:0.000403s ]
[ SQL ] SELECT `original_img` FROM `m_goods` WHERE `goods_id` = 24717 LIMIT 1 [ RunTime:0.003192s ]
[ SQL ] SELECT * FROM `m_goods_images` WHERE `goods_id` = 24717 ORDER BY `img_id` [ RunTime:0.000333s ]
[ SQL ] SELECT `original_img` FROM `m_goods` WHERE `goods_id` = 24805 LIMIT 1 [ RunTime:0.000316s ]
[ SQL ] SELECT * FROM `m_goods_images` WHERE `goods_id` = 24805 ORDER BY `img_id` [ RunTime:0.000280s ]
[ SQL ] SELECT `original_img` FROM `m_goods` WHERE `goods_id` = 24804 LIMIT 1 [ RunTime:0.000311s ]
[ SQL ] SELECT * FROM `m_goods_images` WHERE `goods_id` = 24804 ORDER BY `img_id` [ RunTime:0.000343s ]
[ SQL ] SELECT `original_img` FROM `m_goods` WHERE `goods_id` = 24779 LIMIT 1 [ RunTime:0.000312s ]
[ SQL ] SELECT * FROM `m_goods_images` WHERE `goods_id` = 24779 ORDER BY `img_id` [ RunTime:0.000372s ]
[ SQL ] SELECT `original_img` FROM `m_goods` WHERE `goods_id` = 24723 LIMIT 1 [ RunTime:0.000303s ]
[ SQL ] SELECT * FROM `m_goods_images` WHERE `goods_id` = 24723 ORDER BY `img_id` [ RunTime:0.000550s ]
[ SQL ] SELECT `original_img` FROM `m_goods` WHERE `goods_id` = 24722 LIMIT 1 [ RunTime:0.000321s ]
[ SQL ] SELECT * FROM `m_goods_images` WHERE `goods_id` = 24722 ORDER BY `img_id` [ RunTime:0.000305s ]

试剂

耗材

通用仪器

高端仪器

服务

药品