基本文件流程错误 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/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/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/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/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.53 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.000014s ]
[ BEHAVIOR ] Run app\common\behavior\Cross @app_init [ RunTime:0.000018s ]
[ 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' => '216.73.216.129', 'x-forwarded-proto' => 'https', 'x-forwarded-host' => 'shop-test.huibaibio.com', 'host' => 'shop-test.huibaibio.com', 'content-type' => '', 'content-length' => '', )
[ PARAM ] array ( 'id' => '542', 'price' => '0.00-2900', 'p' => '66', )
[ 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.000176s ]
[ 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', ) ]

[ DB ] CONNECT:[ UseTime:0.001503s ] mysql:host=127.0.0.1;port=3306;dbname=shop;charset=utf8mb4
[ SQL ] SHOW COLUMNS FROM `m_navigation` [ RunTime:0.006045s ]
[ SQL ] SELECT `id` FROM `m_navigation` WHERE `url` = '/index.php?m=Home&c=Goods&a=goodsList' AND `is_show` = 1 LIMIT 1 [ RunTime:0.003016s ]
[ SQL ] SHOW COLUMNS FROM `m_brand` [ RunTime:0.003194s ]
[ SQL ] SELECT `id`,`name`,`logo`,`is_hot` FROM `m_brand` WHERE `is_show` = 1 ORDER BY `sort` desc,`id` desc [ RunTime:0.003195s ]
[ SQL ] SHOW COLUMNS FROM `m_brand_region` [ RunTime:0.002199s ]
[ 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.001290s ]
[ 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.000774s ]
[ 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.000805s ]
[ 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.001862s ]
[ 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.001888s ]
[ 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.000775s ]
[ 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.000690s ]
[ 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.000748s ]
[ 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.000687s ]
[ 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.000711s ]
[ 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.000729s ]
[ 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.001292s ]
[ 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.001436s ]
[ 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.001156s ]
[ 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.000733s ]
[ 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.001355s ]
[ 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.001452s ]
[ 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.001139s ]
[ 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.000668s ]
[ 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.000741s ]
[ 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.000752s ]
[ 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.001316s ]
[ 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.001800s ]
[ 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.000916s ]
[ 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.001422s ]
[ 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.001042s ]
[ 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.000839s ]
[ 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.000646s ]
[ 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.000871s ]
[ 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.000883s ]
[ 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.001561s ]
[ 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.001380s ]
[ 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.001194s ]
[ 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.000964s ]
[ 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.001172s ]
[ 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.001469s ]
[ 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.001179s ]
[ 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.000880s ]
[ 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.000768s ]
[ 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.001049s ]
[ 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.001481s ]
[ 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.001162s ]
[ 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.000731s ]
[ 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.000911s ]
[ 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.000776s ]
[ 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.001240s ]
[ 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.001396s ]
[ 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.001043s ]
[ 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.000733s ]
[ 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.000935s ]
[ 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.001419s ]
[ 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.001636s ]
[ 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.002746s ]
[ 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.002099s ]
[ SQL ] SHOW COLUMNS FROM `m_users` [ RunTime:0.005469s ]
[ SQL ] SELECT * FROM `m_users` WHERE `user_id` = 0 LIMIT 1 [ RunTime:0.002793s ]
[ SQL ] SHOW COLUMNS FROM `m_wx_user` [ RunTime:0.005930s ]
[ SQL ] SELECT `qr` FROM `m_wx_user` LIMIT 1 [ RunTime:0.003631s ]
[ SQL ] SHOW COLUMNS FROM `m_goods_category` [ RunTime:0.002018s ]
[ 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.002545s ]
[ SQL ] SHOW COLUMNS FROM `m_goods` [ RunTime:0.002932s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `m_goods` WHERE `market_price` <= 2900 AND `cat_id` = 542 AND `exchange_integral` = 0 AND `is_on_sale` = 1 AND `is_virtual` <> 2 LIMIT 1 [ RunTime:0.002376s ]
[ SQL ] SELECT `goods_id` FROM `m_goods` WHERE `market_price` <= 2900 AND `cat_id` = 542 AND `exchange_integral` = 0 AND `is_on_sale` = 1 AND `is_virtual` <> 2 ORDER BY sort desc LIMIT 1300,20 [ RunTime:0.008516s ]
[ 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 (1375,1376,1377,1378,1379,1380,1381,1382,1383,1384,1385,1386,1387,1388,1389,1390,1391,1392,1393,1394) ORDER BY sort desc [ RunTime:0.001434s ]
[ SQL ] SELECT `brand_id` FROM `m_goods` WHERE `market_price` <= 2900 AND `cat_id` = 542 AND `exchange_integral` = 0 AND `is_on_sale` = 1 AND `is_virtual` <> 2 GROUP BY `brand_id` [ RunTime:0.001749s ]
[ SQL ] SELECT * FROM `m_brand` WHERE `id` IN (55) ORDER BY `sort` desc,`id` desc LIMIT 30 [ RunTime:0.001482s ]
[ 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.003529s ]

试剂

耗材

通用仪器

高端仪器

服务

药品