酯香香

基本文件流程错误 SQL 调试

/www/dev/zhihuagong/public/index.php ( 1.51 KB )
/www/dev/zhihuagong/thinkphp/base.php ( 1.71 KB )
/www/dev/zhihuagong/thinkphp/library/think/Loader.php ( 12.70 KB )
/www/dev/zhihuagong/vendor/composer/autoload_static.php ( 21.91 KB )
/www/dev/zhihuagong/thinkphp/library/think/Error.php ( 4.00 KB )
/www/dev/zhihuagong/vendor/psr/log/Psr/Log/LoggerInterface.php ( 3.04 KB )
/www/dev/zhihuagong/thinkphp/library/think/Container.php ( 17.20 KB )
/www/dev/zhihuagong/thinkphp/library/think/App.php ( 27.58 KB )
/www/dev/zhihuagong/thinkphp/library/think/Env.php ( 2.85 KB )
/www/dev/zhihuagong/thinkphp/library/think/Config.php ( 9.71 KB )
/www/dev/zhihuagong/thinkphp/convention.php ( 11.74 KB )
/www/dev/zhihuagong/application/tags.php ( 1.08 KB )
/www/dev/zhihuagong/thinkphp/library/think/Hook.php ( 5.58 KB )
/www/dev/zhihuagong/application/common/behavior/Config.php ( 1.68 KB )
/www/dev/zhihuagong/application/common.php ( 32.83 KB )
/www/dev/zhihuagong/thinkphp/library/think/facade/Request.php ( 6.32 KB )
/www/dev/zhihuagong/thinkphp/library/think/Facade.php ( 3.44 KB )
/www/dev/zhihuagong/thinkphp/library/think/Request.php ( 57.54 KB )
/www/dev/zhihuagong/application/function.php ( 0.68 KB )
/www/dev/zhihuagong/thinkphp/helper.php ( 20.40 KB )
/www/dev/zhihuagong/config/addons.php ( 1.33 KB )
/www/dev/zhihuagong/config/app.php ( 6.17 KB )
/www/dev/zhihuagong/thinkphp/library/think/facade/Env.php ( 1.17 KB )
/www/dev/zhihuagong/config/cache.php ( 1.59 KB )
/www/dev/zhihuagong/config/captcha.php ( 0.96 KB )
/www/dev/zhihuagong/config/constant.php ( 1.33 KB )
/www/dev/zhihuagong/config/cookie.php ( 1.12 KB )
/www/dev/zhihuagong/config/database.php ( 2.36 KB )
/www/dev/zhihuagong/config/info.php ( 0.82 KB )
/www/dev/zhihuagong/config/log.php ( 1.01 KB )
/www/dev/zhihuagong/config/session.php ( 1.06 KB )
/www/dev/zhihuagong/config/template.php ( 2.24 KB )
/www/dev/zhihuagong/config/token.php ( 1.43 KB )
/www/dev/zhihuagong/config/trace.php ( 0.84 KB )
/www/dev/zhihuagong/config/version.php ( 0.92 KB )
/www/dev/zhihuagong/vendor/symfony/polyfill-php80/bootstrap.php ( 1.46 KB )
/www/dev/zhihuagong/vendor/symfony/polyfill-mbstring/bootstrap.php ( 7.07 KB )
/www/dev/zhihuagong/vendor/symfony/var-dumper/Resources/functions/dump.php ( 0.79 KB )
/www/dev/zhihuagong/vendor/symfony/deprecation-contracts/function.php ( 0.98 KB )
/www/dev/zhihuagong/vendor/ralouphie/getallheaders/src/getallheaders.php ( 1.60 KB )
/www/dev/zhihuagong/vendor/guzzlehttp/psr7/src/functions_include.php ( 0.15 KB )
/www/dev/zhihuagong/vendor/guzzlehttp/psr7/src/functions.php ( 13.09 KB )
/www/dev/zhihuagong/vendor/symfony/polyfill-intl-normalizer/bootstrap.php ( 0.71 KB )
/www/dev/zhihuagong/vendor/symfony/polyfill-php72/bootstrap.php ( 1.89 KB )
/www/dev/zhihuagong/vendor/guzzlehttp/promises/src/functions_include.php ( 0.16 KB )
/www/dev/zhihuagong/vendor/guzzlehttp/promises/src/functions.php ( 9.89 KB )
/www/dev/zhihuagong/vendor/symfony/polyfill-intl-idn/bootstrap.php ( 4.52 KB )
/www/dev/zhihuagong/vendor/guzzlehttp/guzzle/src/functions_include.php ( 0.16 KB )
/www/dev/zhihuagong/vendor/guzzlehttp/guzzle/src/functions.php ( 9.70 KB )
/www/dev/zhihuagong/vendor/symfony/polyfill-ctype/bootstrap.php ( 1.56 KB )
/www/dev/zhihuagong/vendor/khanamiryan/qrcode-detector-decoder/lib/common/customFunctions.php ( 1.75 KB )
/www/dev/zhihuagong/vendor/tightenco/collect/src/Collect/Support/helpers.php ( 3.61 KB )
/www/dev/zhihuagong/vendor/tightenco/collect/src/Collect/Support/alias.php ( 1.21 KB )
/www/dev/zhihuagong/vendor/tightenco/collect/src/Collect/Contracts/Support/Arrayable.php ( 0.19 KB )
/www/dev/zhihuagong/vendor/tightenco/collect/src/Collect/Contracts/Support/Jsonable.php ( 0.24 KB )
/www/dev/zhihuagong/vendor/tightenco/collect/src/Collect/Contracts/Support/Htmlable.php ( 0.19 KB )
/www/dev/zhihuagong/vendor/tightenco/collect/src/Collect/Support/Arr.php ( 16.36 KB )
/www/dev/zhihuagong/vendor/tightenco/collect/src/Collect/Support/Traits/Macroable.php ( 2.63 KB )
/www/dev/zhihuagong/vendor/tightenco/collect/src/Collect/Support/Collection.php ( 33.51 KB )
/www/dev/zhihuagong/vendor/tightenco/collect/src/Collect/Support/Traits/EnumeratesValues.php ( 26.07 KB )
/www/dev/zhihuagong/vendor/tightenco/collect/src/Collect/Support/Enumerable.php ( 23.81 KB )
/www/dev/zhihuagong/vendor/tightenco/collect/src/Collect/Support/HigherOrderCollectionProxy.php ( 1.40 KB )
/www/dev/zhihuagong/vendor/tightenco/collect/src/Collect/Support/HigherOrderWhenProxy.php ( 1.30 KB )
/www/dev/zhihuagong/vendor/tightenco/collect/src/Collect/Support/LazyCollection.php ( 33.64 KB )
/www/dev/zhihuagong/vendor/overtrue/pinyin/src/const.php ( 0.49 KB )
/www/dev/zhihuagong/vendor/topthink/think-captcha/src/helper.php ( 1.54 KB )
/www/dev/zhihuagong/thinkphp/library/think/facade/Route.php ( 3.84 KB )
/www/dev/zhihuagong/thinkphp/library/think/Route.php ( 25.84 KB )
/www/dev/zhihuagong/thinkphp/library/think/route/Domain.php ( 7.08 KB )
/www/dev/zhihuagong/thinkphp/library/think/route/RuleGroup.php ( 16.45 KB )
/www/dev/zhihuagong/thinkphp/library/think/route/Rule.php ( 28.92 KB )
/www/dev/zhihuagong/thinkphp/library/think/route/RuleItem.php ( 8.84 KB )
/www/dev/zhihuagong/thinkphp/library/think/route/RuleName.php ( 3.92 KB )
/www/dev/zhihuagong/thinkphp/library/think/facade/Validate.php ( 4.83 KB )
/www/dev/zhihuagong/thinkphp/library/think/Validate.php ( 43.93 KB )
/www/dev/zhihuagong/vendor/topthink/think-helper/src/helper.php ( 7.35 KB )
/www/dev/zhihuagong/vendor/overtrue/wechat/src/Kernel/Support/Helpers.php ( 2.54 KB )
/www/dev/zhihuagong/vendor/overtrue/wechat/src/Kernel/Helpers.php ( 1.89 KB )
/www/dev/zhihuagong/thinkphp/library/think/Db.php ( 7.67 KB )
/www/dev/zhihuagong/thinkphp/library/think/Lang.php ( 7.38 KB )
/www/dev/zhihuagong/thinkphp/library/think/Log.php ( 8.92 KB )
/www/dev/zhihuagong/thinkphp/library/think/log/driver/File.php ( 8.97 KB )
/www/dev/zhihuagong/thinkphp/lang/zh-cn.php ( 12.58 KB )
/www/dev/zhihuagong/route/route.php ( 0.67 KB )
/www/dev/zhihuagong/route/route_cms.php ( 2.89 KB )
/www/dev/zhihuagong/route/router_api.php ( 0.84 KB )
/www/dev/zhihuagong/route/router_h5.php ( 0.92 KB )
/www/dev/zhihuagong/thinkphp/library/think/facade/Config.php ( 1.52 KB )
/www/dev/zhihuagong/extend/libs/Cache_factory.php ( 2.92 KB )
/www/dev/zhihuagong/thinkphp/library/think/facade/Cache.php ( 2.06 KB )
/www/dev/zhihuagong/thinkphp/library/think/Cache.php ( 3.27 KB )
/www/dev/zhihuagong/thinkphp/library/think/cache/driver/File.php ( 7.99 KB )
/www/dev/zhihuagong/thinkphp/library/think/cache/Driver.php ( 8.64 KB )
/www/dev/zhihuagong/application/common/behavior/InitHook.php ( 1.47 KB )
/www/dev/zhihuagong/thinkphp/library/think/facade/Hook.php ( 1.46 KB )
/www/dev/zhihuagong/addons/phpmailer/Phpmailer.php ( 2.00 KB )
/www/dev/zhihuagong/extend/sys/Addons.php ( 6.49 KB )
/www/dev/zhihuagong/thinkphp/library/think/View.php ( 5.74 KB )
/www/dev/zhihuagong/thinkphp/library/think/view/driver/Think.php ( 6.12 KB )
/www/dev/zhihuagong/thinkphp/library/think/Template.php ( 47.31 KB )
/www/dev/zhihuagong/thinkphp/library/think/template/driver/File.php ( 2.29 KB )
/www/dev/zhihuagong/application/cms/behavior/Hooks.php ( 1.10 KB )
/www/dev/zhihuagong/extend/sys/Hooks.php ( 2.48 KB )
/www/dev/zhihuagong/application/cms/function.php ( 10.81 KB )
/www/dev/zhihuagong/thinkphp/library/think/route/dispatch/Module.php ( 5.19 KB )
/www/dev/zhihuagong/thinkphp/library/think/route/Dispatch.php ( 9.26 KB )
/www/dev/zhihuagong/thinkphp/library/think/Middleware.php ( 5.34 KB )
/www/dev/zhihuagong/thinkphp/library/think/Cookie.php ( 7.35 KB )
/www/dev/zhihuagong/thinkphp/library/think/Session.php ( 14.13 KB )
/www/dev/zhihuagong/thinkphp/library/think/Debug.php ( 7.57 KB )
/www/dev/zhihuagong/application/h5/controller/Goods.php ( 3.46 KB )
/www/dev/zhihuagong/application/cms/controller/Cmsbase.php ( 11.29 KB )
/www/dev/zhihuagong/application/member/controller/MemberBase.php ( 2.70 KB )
/www/dev/zhihuagong/application/common/controller/Homebase.php ( 2.38 KB )
/www/dev/zhihuagong/application/common/controller/Base.php ( 0.87 KB )
/www/dev/zhihuagong/thinkphp/library/think/Controller.php ( 7.53 KB )
/www/dev/zhihuagong/thinkphp/library/traits/controller/Jump.php ( 4.76 KB )
/www/dev/zhihuagong/application/member/service/User.php ( 13.62 KB )
/www/dev/zhihuagong/thinkphp/library/think/facade/Cookie.php ( 1.58 KB )
/www/dev/zhihuagong/thinkphp/library/think/facade/Url.php ( 1.13 KB )
/www/dev/zhihuagong/thinkphp/library/think/Url.php ( 13.22 KB )
/www/dev/zhihuagong/thinkphp/library/think/cache/driver/Redis.php ( 7.24 KB )
/www/dev/zhihuagong/thinkphp/library/think/db/Connection.php ( 58.93 KB )
/www/dev/zhihuagong/thinkphp/library/think/db/connector/Mysql.php ( 6.22 KB )
/www/dev/zhihuagong/thinkphp/library/think/db/builder/Mysql.php ( 5.85 KB )
/www/dev/zhihuagong/thinkphp/library/think/db/Builder.php ( 36.76 KB )
/www/dev/zhihuagong/thinkphp/library/think/db/Query.php ( 105.00 KB )
/www/dev/zhihuagong/application/cms/service/GoodsService.php ( 14.62 KB )
/www/dev/zhihuagong/application/cms/service/Base.php ( 0.62 KB )
/www/dev/zhihuagong/application/common/model/Goods.php ( 0.08 KB )
/www/dev/zhihuagong/thinkphp/library/think/Model.php ( 28.52 KB )
/www/dev/zhihuagong/thinkphp/library/think/model/concern/Attribute.php ( 17.64 KB )
/www/dev/zhihuagong/thinkphp/library/think/model/concern/RelationShip.php ( 20.60 KB )
/www/dev/zhihuagong/thinkphp/library/think/model/concern/ModelEvent.php ( 6.04 KB )
/www/dev/zhihuagong/thinkphp/library/think/model/concern/TimeStamp.php ( 2.58 KB )
/www/dev/zhihuagong/thinkphp/library/think/model/concern/Conversion.php ( 7.84 KB )
/www/dev/zhihuagong/application/cms/service/ComponentsService.php ( 12.91 KB )
/www/dev/zhihuagong/application/admin/model/Config.php ( 3.34 KB )
/www/dev/zhihuagong/application/links/model/Links.php ( 0.84 KB )
/www/dev/zhihuagong/application/admin/model/Poster.php ( 0.07 KB )
/www/dev/zhihuagong/application/admin/model/Base.php ( 4.15 KB )
/www/dev/zhihuagong/thinkphp/library/think/facade/Session.php ( 2.05 KB )
/www/dev/zhihuagong/application/admin/model/GoodsCategory.php ( 0.09 KB )
/www/dev/zhihuagong/thinkphp/library/think/exception/ErrorException.php ( 1.68 KB )
/www/dev/zhihuagong/thinkphp/library/think/Exception.php ( 1.61 KB )
/www/dev/zhihuagong/thinkphp/library/think/exception/Handle.php ( 8.96 KB )
/www/dev/zhihuagong/thinkphp/library/think/db/Expression.php ( 1.11 KB )
/www/dev/zhihuagong/thinkphp/library/think/model/Collection.php ( 3.23 KB )
/www/dev/zhihuagong/thinkphp/library/think/Collection.php ( 13.60 KB )
/www/dev/zhihuagong/application/common/service/WxH5.php ( 2.88 KB )
/www/dev/zhihuagong/runtime/temp/b6ff3624389fb0a498422c709bf315f7.php ( 26.84 KB )
/www/dev/zhihuagong/thinkphp/library/think/Response.php ( 9.68 KB )
/www/dev/zhihuagong/thinkphp/library/think/debug/Html.php ( 4.02 KB )

[ DB ] CONNECT:[ UseTime:0.000344s ] mysql:host=127.0.0.1;port=3306;dbname=yzncms;charset=utf8
[ SQL ] SHOW COLUMNS FROM `yzn_poster` [ RunTime:0.000839s ]
[ SQL ] SELECT * FROM `yzn_poster` WHERE `cate_id` = 99 AND `p_c_id` = 52 AND `status` = 1 LIMIT 1 [ RunTime:0.000348s ]
[ SQL ] SELECT * FROM `yzn_poster` WHERE `cate_id` = 99 AND `p_c_id` = 55 AND `status` = 1 LIMIT 1 [ RunTime:0.000213s ]
[ SQL ] SHOW COLUMNS FROM `yzn_goods_property` [ RunTime:0.000687s ]
[ SQL ] SELECT `g`.`name`,`p`.`price`,`p`.`unit`,`p`.`type`,`p`.`thumb`,p.id as p_id,`p`.`value`,`p`.`is_where`,`p`.`sku_unit`,`p`.`repeat_type`,`p`.`goods_id` FROM `yzn_goods_property` `p` LEFT JOIN `yzn_goods` `g` ON `p`.`goods_id`=`g`.`id` WHERE `p`.`status` = 1 AND `p`.`is_del` = 0 AND `g`.`is_del` = 0 AND `p`.`is_where` LIKE '%2%' AND `p`.`recommend` = 1 GROUP BY `p`.`goods_id`,`p`.`repeat_type` ORDER BY `p`.`sort` DESC,`g`.`id` DESC LIMIT 0,15 [ RunTime:0.002297s ]
[ SQL ] SHOW COLUMNS FROM `yzn_goods_category` [ RunTime:0.000605s ]
[ SQL ] SELECT * FROM `yzn_goods_category` WHERE `hot_search` = 1 AND `status` = 1 ORDER BY `listorder` ASC,`id` DESC [ RunTime:0.000396s ]
[ SQL ] SELECT * FROM `yzn_goods_category` WHERE `is_show` > 0 AND `status` = 1 ORDER BY `listorder` ASC [ RunTime:0.000304s ]
[ SQL ] SELECT * FROM `yzn_goods_category` WHERE `id` IN (1,2,7,16,17,34,92,95,38) [ RunTime:0.000227s ]
[ SQL ] SELECT `id`,`catname` FROM `yzn_goods_category` WHERE `pid` = 1 AND `status` = 1 ORDER BY `listorder` ASC,`id` DESC [ RunTime:0.000194s ]
[ SQL ] SELECT `id`,`catname` FROM `yzn_goods_category` WHERE `pid` = 2 AND `status` = 1 ORDER BY `listorder` ASC,`id` DESC [ RunTime:0.000162s ]
[ SQL ] SELECT `id`,`catname` FROM `yzn_goods_category` WHERE `pid` = 7 AND `status` = 1 ORDER BY `listorder` ASC,`id` DESC [ RunTime:0.000162s ]
[ SQL ] SELECT `id`,`catname` FROM `yzn_goods_category` WHERE `pid` = 16 AND `status` = 1 ORDER BY `listorder` ASC,`id` DESC [ RunTime:0.000160s ]
[ SQL ] SELECT `id`,`catname` FROM `yzn_goods_category` WHERE `pid` = 17 AND `status` = 1 ORDER BY `listorder` ASC,`id` DESC [ RunTime:0.000167s ]
[ SQL ] SELECT `id`,`catname` FROM `yzn_goods_category` WHERE `pid` IN (34,92) AND `status` = 1 ORDER BY `listorder` ASC,`id` DESC [ RunTime:0.000166s ]
[ SQL ] SELECT `id`,`catname` FROM `yzn_goods_category` WHERE `pid` IN (95,38) AND `status` = 1 ORDER BY `listorder` ASC,`id` DESC [ RunTime:0.000163s ]
[ SQL ] SELECT `id`,`catname` FROM `yzn_goods_category` WHERE `pid` = 1 AND `status` = 1 [ RunTime:0.000155s ]
[ SQL ] SELECT * FROM `yzn_goods_category` WHERE `status` = 1 AND `id` = 1 [ RunTime:0.000173s ]
[ SQL ] SELECT `id` FROM `yzn_goods_category` WHERE `status` = 1 AND ( arrparentid like '0,1,%' ) [ RunTime:0.000166s ]
[ SQL ] SHOW COLUMNS FROM `yzn_goods` [ RunTime:0.000602s ]
[ SQL ] SELECT `g`.`name`,p.id as p_id,`p`.`price`,`p`.`type`,`p`.`thumb`,`p`.`unit`,`p`.`is_where`,`p`.`goods_id`,`p`.`repeat_type` FROM `yzn_goods` `g` LEFT JOIN `yzn_goods_property` `p` ON `p`.`goods_id`=`g`.`id` WHERE `p`.`status` = 1 AND `p`.`is_del` = 0 AND `g`.`is_del` = 0 AND `p`.`is_where` LIKE '%2%' AND `g`.`cate_id` IN (25,26,29,30,48,1) AND `p`.`hot_sale` = '1' GROUP BY `p`.`repeat_type`,`p`.`goods_id` ORDER BY `p`.`sort` DESC,`p`.`id` DESC LIMIT 0,10 [ RunTime:0.000988s ]
[ SQL ] SELECT `id`,`catname` FROM `yzn_goods_category` WHERE `pid` = 2 AND `status` = 1 [ RunTime:0.000196s ]
[ SQL ] SELECT * FROM `yzn_goods_category` WHERE `status` = 1 AND `id` = 2 [ RunTime:0.000163s ]
[ SQL ] SELECT `id` FROM `yzn_goods_category` WHERE `status` = 1 AND ( arrparentid like '0,2,%' ) [ RunTime:0.000164s ]
[ SQL ] SELECT `g`.`name`,p.id as p_id,`p`.`price`,`p`.`type`,`p`.`thumb`,`p`.`unit`,`p`.`is_where`,`p`.`goods_id`,`p`.`repeat_type` FROM `yzn_goods` `g` LEFT JOIN `yzn_goods_property` `p` ON `p`.`goods_id`=`g`.`id` WHERE `p`.`status` = 1 AND `p`.`is_del` = 0 AND `g`.`is_del` = 0 AND `p`.`is_where` LIKE '%2%' AND `g`.`cate_id` IN (42,43,2) AND `p`.`hot_sale` = '1' GROUP BY `p`.`repeat_type`,`p`.`goods_id` ORDER BY `p`.`sort` DESC,`p`.`id` DESC LIMIT 0,10 [ RunTime:0.000866s ]
[ SQL ] SELECT `id`,`catname` FROM `yzn_goods_category` WHERE `pid` = 7 AND `status` = 1 [ RunTime:0.000174s ]
[ SQL ] SELECT * FROM `yzn_goods_category` WHERE `status` = 1 AND `id` = 7 [ RunTime:0.000157s ]
[ SQL ] SELECT `id` FROM `yzn_goods_category` WHERE `status` = 1 AND ( arrparentid like '0,7,%' ) [ RunTime:0.000152s ]
[ SQL ] SELECT `g`.`name`,p.id as p_id,`p`.`price`,`p`.`type`,`p`.`thumb`,`p`.`unit`,`p`.`is_where`,`p`.`goods_id`,`p`.`repeat_type` FROM `yzn_goods` `g` LEFT JOIN `yzn_goods_property` `p` ON `p`.`goods_id`=`g`.`id` WHERE `p`.`status` = 1 AND `p`.`is_del` = 0 AND `g`.`is_del` = 0 AND `p`.`is_where` LIKE '%2%' AND `g`.`cate_id` IN (10,14,32,33,49,50,51,52,53,54,55,56,57,58,96,97,7) AND `p`.`hot_sale` = '1' GROUP BY `p`.`repeat_type`,`p`.`goods_id` ORDER BY `p`.`sort` DESC,`p`.`id` DESC LIMIT 0,10 [ RunTime:0.000893s ]
[ SQL ] SELECT `id`,`catname` FROM `yzn_goods_category` WHERE `pid` = 16 AND `status` = 1 [ RunTime:0.000186s ]
[ SQL ] SELECT * FROM `yzn_goods_category` WHERE `status` = 1 AND `id` = 16 [ RunTime:0.000160s ]
[ SQL ] SELECT `id` FROM `yzn_goods_category` WHERE `status` = 1 AND ( arrparentid like '0,16,%' ) [ RunTime:0.000151s ]
[ SQL ] SELECT `g`.`name`,p.id as p_id,`p`.`price`,`p`.`type`,`p`.`thumb`,`p`.`unit`,`p`.`is_where`,`p`.`goods_id`,`p`.`repeat_type` FROM `yzn_goods` `g` LEFT JOIN `yzn_goods_property` `p` ON `p`.`goods_id`=`g`.`id` WHERE `p`.`status` = 1 AND `p`.`is_del` = 0 AND `g`.`is_del` = 0 AND `p`.`is_where` LIKE '%2%' AND `g`.`cate_id` IN (59,60,61,62,63,16) AND `p`.`hot_sale` = '1' GROUP BY `p`.`repeat_type`,`p`.`goods_id` ORDER BY `p`.`sort` DESC,`p`.`id` DESC LIMIT 0,10 [ RunTime:0.000876s ]
[ SQL ] SELECT `id`,`catname` FROM `yzn_goods_category` WHERE `pid` = 17 AND `status` = 1 [ RunTime:0.000190s ]
[ SQL ] SELECT * FROM `yzn_goods_category` WHERE `status` = 1 AND `id` = 17 [ RunTime:0.000181s ]
[ SQL ] SELECT `id` FROM `yzn_goods_category` WHERE `status` = 1 AND ( arrparentid like '0,17,%' ) [ RunTime:0.000157s ]
[ SQL ] SELECT `g`.`name`,p.id as p_id,`p`.`price`,`p`.`type`,`p`.`thumb`,`p`.`unit`,`p`.`is_where`,`p`.`goods_id`,`p`.`repeat_type` FROM `yzn_goods` `g` LEFT JOIN `yzn_goods_property` `p` ON `p`.`goods_id`=`g`.`id` WHERE `p`.`status` = 1 AND `p`.`is_del` = 0 AND `g`.`is_del` = 0 AND `p`.`is_where` LIKE '%2%' AND `g`.`cate_id` IN (40,64,65,66,67,68,100,17) AND `p`.`hot_sale` = '1' GROUP BY `p`.`repeat_type`,`p`.`goods_id` ORDER BY `p`.`sort` DESC,`p`.`id` DESC LIMIT 0,10 [ RunTime:0.000860s ]
[ SQL ] SELECT `id`,`catname` FROM `yzn_goods_category` WHERE `pid` = 34 AND `status` = 1 [ RunTime:0.000168s ]
[ SQL ] SELECT `id`,`catname` FROM `yzn_goods_category` WHERE `pid` = 92 AND `status` = 1 [ RunTime:0.000148s ]
[ SQL ] SELECT * FROM `yzn_goods_category` WHERE `status` = 1 AND `id` IN (34,92) [ RunTime:0.000199s ]
[ SQL ] SELECT `id` FROM `yzn_goods_category` WHERE `status` = 1 AND ( arrparentid like '0,34,%' or arrparentid like '0,92,%' ) [ RunTime:0.000166s ]
[ SQL ] SELECT `g`.`name`,p.id as p_id,`p`.`price`,`p`.`type`,`p`.`thumb`,`p`.`unit`,`p`.`is_where`,`p`.`goods_id`,`p`.`repeat_type` FROM `yzn_goods` `g` LEFT JOIN `yzn_goods_property` `p` ON `p`.`goods_id`=`g`.`id` WHERE `p`.`status` = 1 AND `p`.`is_del` = 0 AND `g`.`is_del` = 0 AND `p`.`is_where` LIKE '%2%' AND `g`.`cate_id` IN (35,70,71,93,94,34,92) AND `p`.`hot_sale` = '1' GROUP BY `p`.`repeat_type`,`p`.`goods_id` ORDER BY `p`.`sort` DESC,`p`.`id` DESC LIMIT 0,10 [ RunTime:0.000859s ]
[ SQL ] SELECT `id`,`catname` FROM `yzn_goods_category` WHERE `pid` = 95 AND `status` = 1 [ RunTime:0.000171s ]
[ SQL ] SELECT `id`,`catname` FROM `yzn_goods_category` WHERE `pid` = 38 AND `status` = 1 [ RunTime:0.000170s ]
[ SQL ] SELECT * FROM `yzn_goods_category` WHERE `status` = 1 AND `id` IN (95,38) [ RunTime:0.000235s ]
[ SQL ] SELECT `id` FROM `yzn_goods_category` WHERE `status` = 1 AND ( arrparentid like '0,38,%' or arrparentid like '0,95,%' ) [ RunTime:0.000167s ]
[ SQL ] SELECT `g`.`name`,p.id as p_id,`p`.`price`,`p`.`type`,`p`.`thumb`,`p`.`unit`,`p`.`is_where`,`p`.`goods_id`,`p`.`repeat_type` FROM `yzn_goods` `g` LEFT JOIN `yzn_goods_property` `p` ON `p`.`goods_id`=`g`.`id` WHERE `p`.`status` = 1 AND `p`.`is_del` = 0 AND `g`.`is_del` = 0 AND `p`.`is_where` LIKE '%2%' AND `g`.`cate_id` IN (47,74,75,76,77,78,79,80,81,82,83,99,95,38) AND `p`.`hot_sale` = '1' GROUP BY `p`.`repeat_type`,`p`.`goods_id` ORDER BY `p`.`sort` DESC,`p`.`id` DESC LIMIT 0,10 [ RunTime:0.000881s ]
[ SQL ] SELECT g.id as goods_id,`g`.*,p.id as p_id,`p`.*,`d`.*,`c`.`catname`,b.name as b_name FROM `yzn_goods` `g` LEFT JOIN `yzn_goods_property` `p` ON `p`.`goods_id`=`g`.`id` LEFT JOIN `yzn_goods_data` `d` ON `d`.`goods_id`=`g`.`id` LEFT JOIN `yzn_brand` `b` ON `b`.`id`=`g`.`brand_id` LEFT JOIN `yzn_goods_category` `c` ON `c`.`id`=`g`.`cate_id` WHERE `p`.`status` = 1 AND `p`.`is_del` = 0 AND `g`.`is_del` = 0 AND `p`.`id` = '324' LIMIT 1 [ RunTime:0.004100s ]
[ SQL ] SELECT `g`.`name`,`p`.`price`,`p`.`unit`,`p`.`type`,`p`.`thumb`,p.id as p_id,`p`.`value`,`p`.`is_where`,`p`.`sku_unit`,`p`.`repeat_type`,`p`.`goods_id` FROM `yzn_goods_property` `p` LEFT JOIN `yzn_goods` `g` ON `p`.`goods_id`=`g`.`id` WHERE `p`.`status` = 1 AND `p`.`is_del` = 0 AND `g`.`is_del` = 0 AND `p`.`is_where` LIKE '%2%' AND `p`.`recommend` = 1 GROUP BY `p`.`goods_id`,`p`.`repeat_type` ORDER BY `p`.`sort` DESC,`g`.`id` DESC LIMIT 0,8 [ RunTime:0.000777s ]