商品详情

基本文件流程错误 SQL 调试

/www/wwwroot/jufengdj.com/public/index.php ( 3.07 KB )
/www/wwwroot/jufengdj.com/vendor/autoload.php ( 0.75 KB )
/www/wwwroot/jufengdj.com/vendor/composer/autoload_real.php ( 2.46 KB )
/www/wwwroot/jufengdj.com/vendor/composer/platform_check.php ( 0.90 KB )
/www/wwwroot/jufengdj.com/vendor/composer/ClassLoader.php ( 13.16 KB )
/www/wwwroot/jufengdj.com/vendor/composer/autoload_static.php ( 5.05 KB )
/www/wwwroot/jufengdj.com/vendor/topthink/think-helper/src/helper.php ( 7.35 KB )
/www/wwwroot/jufengdj.com/vendor/opis/closure/functions.php ( 0.79 KB )
/www/wwwroot/jufengdj.com/vendor/symfony/polyfill-mbstring/bootstrap.php ( 4.75 KB )
/www/wwwroot/jufengdj.com/vendor/symfony/polyfill-php72/bootstrap.php ( 1.41 KB )
/www/wwwroot/jufengdj.com/vendor/symfony/var-dumper/Resources/functions/dump.php ( 0.79 KB )
/www/wwwroot/jufengdj.com/vendor/topthink/think-captcha/src/helper.php ( 1.28 KB )
/www/wwwroot/jufengdj.com/vendor/topthink/framework/src/think/App.php ( 14.82 KB )
/www/wwwroot/jufengdj.com/vendor/topthink/framework/src/think/Container.php ( 15.31 KB )
/www/wwwroot/jufengdj.com/vendor/psr/container/src/ContainerInterface.php ( 1.07 KB )
/www/wwwroot/jufengdj.com/app/provider.php ( 0.20 KB )
/www/wwwroot/jufengdj.com/vendor/topthink/framework/src/think/Http.php ( 6.16 KB )
/www/wwwroot/jufengdj.com/vendor/topthink/think-helper/src/helper/Str.php ( 7.27 KB )
/www/wwwroot/jufengdj.com/app/Request.php ( 0.16 KB )
/www/wwwroot/jufengdj.com/vendor/topthink/framework/src/think/Request.php ( 52.82 KB )
/www/wwwroot/jufengdj.com/vendor/topthink/framework/src/think/Env.php ( 4.15 KB )
/www/wwwroot/jufengdj.com/app/common.php ( 153.78 KB )
/www/wwwroot/jufengdj.com/app/function.php ( 120.93 KB )
/www/wwwroot/jufengdj.com/vendor/topthink/framework/src/helper.php ( 21.13 KB )
/www/wwwroot/jufengdj.com/vendor/topthink/framework/src/think/Config.php ( 4.91 KB )
/www/wwwroot/jufengdj.com/config/app.php ( 8.50 KB )
/www/wwwroot/jufengdj.com/vendor/topthink/framework/src/think/facade/Env.php ( 0.97 KB )
/www/wwwroot/jufengdj.com/vendor/topthink/framework/src/think/Facade.php ( 2.71 KB )
/www/wwwroot/jufengdj.com/config/cache.php ( 0.89 KB )
/www/wwwroot/jufengdj.com/config/captcha.php ( 1.06 KB )
/www/wwwroot/jufengdj.com/config/console.php ( 0.24 KB )
/www/wwwroot/jufengdj.com/config/cookie.php ( 0.50 KB )
/www/wwwroot/jufengdj.com/config/database.php ( 2.47 KB )
/www/wwwroot/jufengdj.com/config/filesystem.php ( 1.11 KB )
/www/wwwroot/jufengdj.com/config/jump.php ( 0.38 KB )
/www/wwwroot/jufengdj.com/config/lang.php ( 0.80 KB )
/www/wwwroot/jufengdj.com/config/log.php ( 1.44 KB )
/www/wwwroot/jufengdj.com/config/middleware.php ( 0.20 KB )
/www/wwwroot/jufengdj.com/config/route.php ( 1.59 KB )
/www/wwwroot/jufengdj.com/config/session.php ( 0.68 KB )
/www/wwwroot/jufengdj.com/config/trace.php ( 0.35 KB )
/www/wwwroot/jufengdj.com/config/view.php ( 0.89 KB )
/www/wwwroot/jufengdj.com/app/event.php ( 0.27 KB )
/www/wwwroot/jufengdj.com/vendor/topthink/framework/src/think/Event.php ( 7.29 KB )
/www/wwwroot/jufengdj.com/vendor/topthink/framework/src/think/Lang.php ( 7.71 KB )
/www/wwwroot/jufengdj.com/vendor/topthink/framework/src/lang/zh-cn.php ( 12.88 KB )
/www/wwwroot/jufengdj.com/vendor/topthink/framework/src/think/initializer/Error.php ( 3.31 KB )
/www/wwwroot/jufengdj.com/vendor/topthink/framework/src/think/initializer/RegisterService.php ( 1.33 KB )
/www/wwwroot/jufengdj.com/vendor/services.php ( 0.22 KB )
/www/wwwroot/jufengdj.com/vendor/topthink/framework/src/think/service/PaginatorService.php ( 1.52 KB )
/www/wwwroot/jufengdj.com/vendor/topthink/framework/src/think/Service.php ( 1.67 KB )
/www/wwwroot/jufengdj.com/vendor/topthink/framework/src/think/service/ValidateService.php ( 0.99 KB )
/www/wwwroot/jufengdj.com/vendor/topthink/framework/src/think/service/ModelService.php ( 1.51 KB )
/www/wwwroot/jufengdj.com/vendor/topthink/think-captcha/src/CaptchaService.php ( 0.46 KB )
/www/wwwroot/jufengdj.com/vendor/topthink/think-multi-app/src/Service.php ( 0.94 KB )
/www/wwwroot/jufengdj.com/vendor/topthink/framework/src/think/Middleware.php ( 6.81 KB )
/www/wwwroot/jufengdj.com/vendor/topthink/framework/src/think/Console.php ( 21.99 KB )
/www/wwwroot/jufengdj.com/vendor/topthink/think-trace/src/Service.php ( 0.77 KB )
/www/wwwroot/jufengdj.com/vendor/topthink/framework/src/think/initializer/BootService.php ( 0.77 KB )
/www/wwwroot/jufengdj.com/vendor/topthink/think-orm/src/Paginator.php ( 11.07 KB )
/www/wwwroot/jufengdj.com/vendor/topthink/framework/src/think/Validate.php ( 47.23 KB )
/www/wwwroot/jufengdj.com/vendor/topthink/think-orm/src/Model.php ( 23.72 KB )
/www/wwwroot/jufengdj.com/vendor/topthink/think-orm/src/model/concern/Attribute.php ( 16.98 KB )
/www/wwwroot/jufengdj.com/vendor/topthink/think-orm/src/model/concern/RelationShip.php ( 24.05 KB )
/www/wwwroot/jufengdj.com/vendor/topthink/think-orm/src/model/concern/ModelEvent.php ( 2.26 KB )
/www/wwwroot/jufengdj.com/vendor/topthink/think-orm/src/model/concern/TimeStamp.php ( 5.36 KB )
/www/wwwroot/jufengdj.com/vendor/topthink/think-orm/src/model/concern/Conversion.php ( 7.73 KB )
/www/wwwroot/jufengdj.com/vendor/topthink/think-helper/src/contract/Arrayable.php ( 0.09 KB )
/www/wwwroot/jufengdj.com/vendor/topthink/think-helper/src/contract/Jsonable.php ( 0.13 KB )
/www/wwwroot/jufengdj.com/vendor/topthink/framework/src/think/Db.php ( 2.78 KB )
/www/wwwroot/jufengdj.com/vendor/topthink/think-orm/src/DbManager.php ( 9.12 KB )
/www/wwwroot/jufengdj.com/vendor/topthink/framework/src/think/Log.php ( 8.50 KB )
/www/wwwroot/jufengdj.com/vendor/topthink/framework/src/think/Manager.php ( 3.97 KB )
/www/wwwroot/jufengdj.com/vendor/psr/log/Psr/Log/LoggerInterface.php ( 3.02 KB )
/www/wwwroot/jufengdj.com/vendor/topthink/framework/src/think/Cache.php ( 4.79 KB )
/www/wwwroot/jufengdj.com/vendor/psr/simple-cache/src/CacheInterface.php ( 4.50 KB )
/www/wwwroot/jufengdj.com/vendor/topthink/framework/src/think/Route.php ( 22.25 KB )
/www/wwwroot/jufengdj.com/vendor/topthink/framework/src/think/route/RuleName.php ( 4.87 KB )
/www/wwwroot/jufengdj.com/vendor/topthink/framework/src/think/route/Domain.php ( 5.42 KB )
/www/wwwroot/jufengdj.com/vendor/topthink/framework/src/think/route/RuleGroup.php ( 14.44 KB )
/www/wwwroot/jufengdj.com/vendor/topthink/framework/src/think/route/Rule.php ( 23.28 KB )
/www/wwwroot/jufengdj.com/vendor/topthink/framework/src/think/route/RuleItem.php ( 9.20 KB )
/www/wwwroot/jufengdj.com/app/middleware.php ( 0.26 KB )
/www/wwwroot/jufengdj.com/vendor/topthink/framework/src/think/Pipeline.php ( 2.60 KB )
/www/wwwroot/jufengdj.com/vendor/topthink/think-multi-app/src/MultiApp.php ( 7.98 KB )
/www/wwwroot/jufengdj.com/vendor/topthink/framework/src/think/exception/ErrorException.php ( 1.73 KB )
/www/wwwroot/jufengdj.com/vendor/topthink/framework/src/think/Exception.php ( 1.69 KB )
/www/wwwroot/jufengdj.com/app/mobile/config/view.php ( 1.28 KB )
/www/wwwroot/jufengdj.com/vendor/topthink/think-trace/src/TraceDebug.php ( 2.94 KB )
/www/wwwroot/jufengdj.com/vendor/topthink/framework/src/think/middleware/SessionInit.php ( 2.10 KB )
/www/wwwroot/jufengdj.com/vendor/topthink/framework/src/think/Session.php ( 1.80 KB )
/www/wwwroot/jufengdj.com/vendor/topthink/think-helper/src/helper/Arr.php ( 15.54 KB )
/www/wwwroot/jufengdj.com/vendor/topthink/framework/src/think/session/driver/File.php ( 6.30 KB )
/www/wwwroot/jufengdj.com/vendor/topthink/framework/src/think/contract/SessionHandlerInterface.php ( 0.87 KB )
/www/wwwroot/jufengdj.com/vendor/topthink/framework/src/think/session/Store.php ( 7.57 KB )
/www/wwwroot/jufengdj.com/vendor/topthink/framework/src/think/route/dispatch/Url.php ( 3.46 KB )
/www/wwwroot/jufengdj.com/vendor/topthink/framework/src/think/route/dispatch/Controller.php ( 9.03 KB )
/www/wwwroot/jufengdj.com/vendor/topthink/framework/src/think/route/Dispatch.php ( 6.76 KB )
/www/wwwroot/jufengdj.com/vendor/topthink/framework/src/think/facade/Config.php ( 0.98 KB )
/www/wwwroot/jufengdj.com/vendor/topthink/framework/src/think/facade/View.php ( 0.98 KB )
/www/wwwroot/jufengdj.com/vendor/topthink/framework/src/think/View.php ( 4.89 KB )
/www/wwwroot/jufengdj.com/vendor/topthink/framework/src/think/facade/Cache.php ( 0.98 KB )
/www/wwwroot/jufengdj.com/vendor/topthink/framework/src/think/cache/driver/File.php ( 7.78 KB )
/www/wwwroot/jufengdj.com/vendor/topthink/framework/src/think/cache/Driver.php ( 7.78 KB )
/www/wwwroot/jufengdj.com/vendor/topthink/framework/src/think/contract/CacheHandlerInterface.php ( 2.25 KB )
/www/wwwroot/jufengdj.com/vendor/opis/closure/src/SerializableClosure.php ( 20.41 KB )
/www/wwwroot/jufengdj.com/vendor/opis/closure/src/ClosureContext.php ( 0.61 KB )
/www/wwwroot/jufengdj.com/vendor/opis/closure/src/ClosureScope.php ( 0.57 KB )
/www/wwwroot/jufengdj.com/app/mobile/controller/Goods.php ( 97.20 KB )
/www/wwwroot/jufengdj.com/app/mobile/controller/MobileBase.php ( 19.60 KB )
/www/wwwroot/jufengdj.com/app/BaseController.php ( 2.13 KB )
/www/wwwroot/jufengdj.com/vendor/liliuwei/thinkphp-jump/src/Jump.php ( 4.32 KB )
/www/wwwroot/jufengdj.com/vendor/topthink/framework/src/think/facade/Session.php ( 0.99 KB )
/www/wwwroot/jufengdj.com/vendor/topthink/framework/src/think/facade/Cookie.php ( 0.98 KB )
/www/wwwroot/jufengdj.com/vendor/topthink/framework/src/think/Cookie.php ( 5.46 KB )
/www/wwwroot/jufengdj.com/vendor/topthink/think-orm/src/facade/Db.php ( 2.25 KB )
/www/wwwroot/jufengdj.com/vendor/topthink/think-orm/src/db/connector/Mysql.php ( 4.43 KB )
/www/wwwroot/jufengdj.com/vendor/topthink/think-orm/src/db/PDOConnection.php ( 47.45 KB )
/www/wwwroot/jufengdj.com/vendor/topthink/think-orm/src/db/Connection.php ( 5.82 KB )
/www/wwwroot/jufengdj.com/vendor/topthink/think-orm/src/db/ConnectionInterface.php ( 4.88 KB )
/www/wwwroot/jufengdj.com/vendor/topthink/think-orm/src/db/builder/Mysql.php ( 13.82 KB )
/www/wwwroot/jufengdj.com/vendor/topthink/think-orm/src/db/Builder.php ( 40.24 KB )
/www/wwwroot/jufengdj.com/vendor/topthink/think-orm/src/db/Query.php ( 12.29 KB )
/www/wwwroot/jufengdj.com/vendor/topthink/think-orm/src/db/BaseQuery.php ( 36.25 KB )
/www/wwwroot/jufengdj.com/vendor/topthink/think-orm/src/db/concern/TimeFieldQuery.php ( 7.50 KB )
/www/wwwroot/jufengdj.com/vendor/topthink/think-orm/src/db/concern/AggregateQuery.php ( 2.83 KB )
/www/wwwroot/jufengdj.com/vendor/topthink/think-orm/src/db/concern/ModelRelationQuery.php ( 15.86 KB )
/www/wwwroot/jufengdj.com/vendor/topthink/think-orm/src/db/concern/ResultOperation.php ( 7.20 KB )
/www/wwwroot/jufengdj.com/vendor/topthink/think-orm/src/db/concern/Transaction.php ( 2.77 KB )
/www/wwwroot/jufengdj.com/vendor/topthink/think-orm/src/db/concern/WhereQuery.php ( 16.53 KB )
/www/wwwroot/jufengdj.com/vendor/topthink/think-orm/src/db/concern/JoinAndViewQuery.php ( 7.18 KB )
/www/wwwroot/jufengdj.com/vendor/topthink/think-orm/src/db/concern/ParamsBind.php ( 2.75 KB )
/www/wwwroot/jufengdj.com/vendor/topthink/think-orm/src/db/concern/TableFieldInfo.php ( 2.51 KB )
/www/wwwroot/jufengdj.com/vendor/topthink/think-orm/src/db/Raw.php ( 1.17 KB )
/www/wwwroot/jufengdj.com/vendor/topthink/framework/src/think/log/driver/File.php ( 5.94 KB )
/www/wwwroot/jufengdj.com/vendor/topthink/framework/src/think/contract/LogHandlerInterface.php ( 0.86 KB )
/www/wwwroot/jufengdj.com/vendor/topthink/framework/src/think/log/Channel.php ( 6.41 KB )
/www/wwwroot/jufengdj.com/vendor/topthink/think-orm/src/db/CacheItem.php ( 4.56 KB )
/www/wwwroot/jufengdj.com/vendor/topthink/think-helper/src/Collection.php ( 17.29 KB )
/www/wwwroot/jufengdj.com/vendor/topthink/framework/src/think/route/Dispatchs.php ( 7.94 KB )
/www/wwwroot/jufengdj.com/app/common/logic/GoodsLogic.php ( 57.06 KB )
/www/wwwroot/jufengdj.com/app/common/model/Goods.php ( 11.22 KB )
/www/wwwroot/jufengdj.com/vendor/topthink/framework/src/think/facade/Route.php ( 0.98 KB )
/www/wwwroot/jufengdj.com/vendor/topthink/think-multi-app/src/Url.php ( 7.35 KB )
/www/wwwroot/jufengdj.com/vendor/topthink/framework/src/think/route/Url.php ( 14.90 KB )
/www/wwwroot/jufengdj.com/app/common/model/PromOrder.php ( 2.32 KB )
/www/wwwroot/jufengdj.com/vendor/topthink/think-orm/src/model/Collection.php ( 6.11 KB )
/www/wwwroot/jufengdj.com/vendor/topthink/think-view/src/Think.php ( 9.05 KB )
/www/wwwroot/jufengdj.com/vendor/topthink/think-template/src/Template.php ( 47.91 KB )
/www/wwwroot/jufengdj.com/vendor/topthink/think-template/src/template/driver/File.php ( 2.33 KB )
/www/wwwroot/jufengdj.com/runtime/mobile/temp/da1b74cbb197aca47b7d33707c986e34.php ( 146.99 KB )
/www/wwwroot/jufengdj.com/vendor/topthink/think-orm/src/model/relation/HasMany.php ( 11.67 KB )
/www/wwwroot/jufengdj.com/vendor/topthink/think-orm/src/model/Relation.php ( 6.05 KB )
/www/wwwroot/jufengdj.com/app/common/model/GoodsAttr.php ( 0.90 KB )
/www/wwwroot/jufengdj.com/app/common/model/SpecGoodsPrice.php ( 1.05 KB )
/www/wwwroot/jufengdj.com/vendor/topthink/framework/src/think/Response.php ( 8.50 KB )
/www/wwwroot/jufengdj.com/vendor/topthink/framework/src/think/response/Html.php ( 0.98 KB )
/www/wwwroot/jufengdj.com/vendor/topthink/think-trace/src/Html.php ( 4.36 KB )

CONNECT:[ UseTime:0.000299s ] mysql:host=127.0.0.1;port=3306;dbname=jufengdj_com;charset=utf8
SHOW FULL COLUMNS FROM `tp_wx_user` [ RunTime:0.000884s ]
SELECT * FROM `tp_wx_user` WHERE ( w_token = "xkopzw1490691329" ) ORDER BY `id` ASC LIMIT 1 [ RunTime:0.000282s ]
SHOW FULL COLUMNS FROM `tp_goods` [ RunTime:0.001090s ]
SELECT * FROM `tp_goods` WHERE `goods_id` = 154627 LIMIT 1 [ RunTime:0.000517s ]
UPDATE `tp_goods` SET `click_count` = 7 WHERE `goods_id` = 154627 [ RunTime:0.012485s ]
SHOW FULL COLUMNS FROM `tp_goods_visit` [ RunTime:0.000594s ]
SELECT * FROM `tp_goods_visit` WHERE `user_id` = 0 AND `openid` = '52.14.145.78' AND `goods_id` = 154627 AND `w_token` = 'xkopzw1490691329' AND ( DATE(FROM_UNIXTIME(visittime)) = CURDATE() ) LIMIT 1 [ RunTime:0.000757s ]
INSERT INTO `tp_goods_visit` SET `user_id` = 0 , `goods_id` = 154627 , `visittime` = 1746416429 , `cat_id` = 0 , `extend_cat_id` = 0 , `openid` = '52.14.145.78' , `w_token` = 'xkopzw1490691329' [ RunTime:0.002284s ]
SHOW FULL COLUMNS FROM `tp_prom_order` [ RunTime:0.000590s ]
SELECT * FROM `tp_prom_order` WHERE `start_time` <= 1746416429 AND `end_time` > 1746416429 AND `is_close` = 0 ORDER BY `id` DESC LIMIT 3 [ RunTime:0.000375s ]
SELECT goods_id, goods_name, goods_sn, shop_price, cost_price, commission, suppliers_id,(SELECT SUM(ag.goods_num) FROM `tp_order` as a left join `tp_order_goods` as ag on ag.order_id = a.order_id where od.goods_id = ag.goods_id and a.pay_status = 1 and a.order_status in(1,2,4) and a.pay_time Between 1745769600 and 1746374400) as ashu1 FROM `tp_goods` `od` WHERE ( is_on_sale=1 and brand_id = 43 ) ORDER BY `ashu1` DESC,`sort` DESC LIMIT 3 [ RunTime:0.426480s ]
SELECT goods_id, goods_name, goods_sn, shop_price, cost_price, commission, suppliers_id,(SELECT SUM(ag.goods_num) FROM `tp_order` as a left join `tp_order_goods` as ag on ag.order_id = a.order_id where od.goods_id = ag.goods_id and a.pay_status = 1 and a.order_status in(1,2,4) and a.pay_time Between 1745769600 and 1746374400) as ashu1 FROM `tp_goods` `od` WHERE ( is_on_sale=1 and brand_id in(42,49) ) ORDER BY `ashu1` DESC,`sort` DESC LIMIT 3 [ RunTime:0.180033s ]
SELECT goods_id, goods_name, goods_sn, shop_price, cost_price, commission, suppliers_id,(SELECT SUM(ag.goods_num) FROM `tp_order` as a left join `tp_order_goods` as ag on ag.order_id = a.order_id where od.goods_id = ag.goods_id and a.pay_status = 1 and a.order_status in(1,2,4) and a.pay_time Between 1745769600 and 1746374400) as ashu1 FROM `tp_goods` `od` WHERE ( is_on_sale=1 and brand_id = 18 ) ORDER BY `ashu1` DESC,`sort` DESC LIMIT 3 [ RunTime:0.045868s ]
SELECT goods_id, goods_name, goods_sn, shop_price, cost_price, commission, suppliers_id,(SELECT SUM(ag.goods_num) FROM `tp_order` as a left join `tp_order_goods` as ag on ag.order_id = a.order_id where od.goods_id = ag.goods_id and a.pay_status = 1 and a.order_status in(1,2,4) and a.pay_time Between 1745769600 and 1746374400) as ashu1 FROM `tp_goods` `od` WHERE ( is_on_sale=1 and brand_id = 30 ) ORDER BY `ashu1` DESC,`sort` DESC LIMIT 3 [ RunTime:0.008943s ]
SHOW FULL COLUMNS FROM `tp_suppliers` [ RunTime:0.000909s ]
SELECT `suppliers_name`,`suppliers_remark`,`suppliers_yunfei`,`suppliers_key`,`fromwxid`,`suppliers_piao`,`suppliers_type` FROM `tp_suppliers` WHERE ( suppliers_id = 117 ) LIMIT 1 [ RunTime:0.000184s ]
SHOW FULL COLUMNS FROM `tp_goods_label` [ RunTime:0.000561s ]
SELECT `label_name` FROM `tp_goods_label` WHERE `label_id` = 9 LIMIT 1 [ RunTime:0.000152s ]
SHOW FULL COLUMNS FROM `tp_region_control` [ RunTime:0.000552s ]
SELECT `str_region` FROM `tp_region_control` WHERE ( goods_id = 154627 ) LIMIT 1 [ RunTime:0.000202s ]
SELECT (COUNT(CASE WHEN o.order_status = 3 AND o.pay_status > 0 THEN 1 END) / COUNT(CASE WHEN o.order_status IN (1,2,3,4) AND o.pay_status IN (1,2,3,4,5) THEN 1 END)) as lu FROM tp_order o LEFT JOIN tp_order_goods og ON og.order_id = o.order_id LEFT JOIN tp_goods g ON og.goods_id = g.goods_id LEFT JOIN tp_suppliers s ON o.admin_qudao = s.suppliers_id WHERE o.prom_type IN (0,1,2,3,4,8) AND o.deleted = 0 AND o.pay_time >= 1743824429 and o.admin_qudao = s.suppliers_id and g.is_on_sale = 1 and og.goods_id = 154627 and o.zhuantai not in(17, 5, 103, 106, 114, 117, 18, 19, 107) [ RunTime:0.000409s ]
SHOW FULL COLUMNS FROM `tp_region` [ RunTime:0.000585s ]
SELECT `id`,`name`,`meidisn` FROM `tp_region` WHERE `level` = 1 AND `is_hot` = 0 ORDER BY `level` ASC [ RunTime:0.000167s ]
SELECT * FROM `tp_goods` WHERE `goods_id` = 138048 AND `is_on_sale` = 1 LIMIT 1 [ RunTime:0.000778s ]
SELECT * FROM `tp_wx_user` WHERE `w_token` = 'xkopzw1490691329' LIMIT 1 [ RunTime:0.000269s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 154627 LIMIT 1 [ RunTime:0.000508s ]
SELECT `label_name` FROM `tp_goods_label` WHERE `label_id` = 9 LIMIT 1 [ RunTime:0.000170s ]
SELECT `label_name` FROM `tp_goods_label` WHERE `label_id` = 9 LIMIT 1 [ RunTime:0.000205s ]
SELECT `label_name` FROM `tp_goods_label` WHERE `label_id` = 9 LIMIT 1 [ RunTime:0.000138s ]
SELECT `label_name` FROM `tp_goods_label` WHERE `label_id` = 9 LIMIT 1 [ RunTime:0.000159s ]
SELECT `label_name` FROM `tp_goods_label` WHERE `label_id` = 9 LIMIT 1 [ RunTime:0.000205s ]
SELECT `label_name` FROM `tp_goods_label` WHERE `label_id` = 9 LIMIT 1 [ RunTime:0.000132s ]
SELECT `label_name` FROM `tp_goods_label` WHERE `label_id` = 9 LIMIT 1 [ RunTime:0.000158s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 138048 LIMIT 1 [ RunTime:0.000195s ]
SELECT * FROM `tp_wx_user` WHERE ( w_token = "xkopzw1490691329" ) ORDER BY `id` ASC LIMIT 1 [ RunTime:0.000192s ]
SELECT `w_token`,`label_id`,`shop_price` FROM `tp_goods` WHERE `goods_id` = 138048 LIMIT 1 [ RunTime:0.000214s ]
SELECT `brand_id` FROM `tp_goods` WHERE `goods_id` = 138048 AND `is_on_sale` = 1 LIMIT 1 [ RunTime:0.000180s ]
SELECT `guize` FROM `tp_suppliers` WHERE `suppliers_id` = 317 LIMIT 1 [ RunTime:0.000142s ]
SELECT `label_name` FROM `tp_goods_label` WHERE `label_id` = 9 LIMIT 1 [ RunTime:0.000118s ]
SELECT `label_name` FROM `tp_goods_label` WHERE `label_id` = 9 LIMIT 1 [ RunTime:0.000115s ]
SHOW FULL COLUMNS FROM `tp_ad_goods` [ RunTime:0.000577s ]
SELECT * FROM `tp_ad_goods` `g` LEFT JOIN `tp_ad_goods_config` `c` ON `c`.`ad_goods_id`=`g`.`ad_goods_id` WHERE ( g.enabled =1 AND g.end_time > 1746416429 AND g.start_time <1746416429 and( c.goods_id = 154627 OR c.goods_id is null) ) GROUP BY `c`.`goods_id` ORDER BY `c`.`goods_id` ASC,`g`.`orderby` DESC LIMIT 1 [ RunTime:0.001000s ]
SELECT `label_name` FROM `tp_goods_label` WHERE `label_id` = 9 LIMIT 1 [ RunTime:0.000142s ]
SELECT `label_name` FROM `tp_goods_label` WHERE `label_id` = 9 LIMIT 1 [ RunTime:0.000241s ]
SELECT `label_name` FROM `tp_goods_label` WHERE `label_id` = 9 LIMIT 1 [ RunTime:0.000166s ]
SHOW FULL COLUMNS FROM `tp_comment` [ RunTime:0.000614s ]
SELECT sum(case when img !='' and img not like 'N;%' then 1 else 0 end) as img_sum,sum(case when ceil((deliver_rank+goods_rank+service_rank)/3)= 4 or ceil((deliver_rank+goods_rank+service_rank)/3)= 5 then 1 else 0 end) as high_sum,sum(case when ceil((deliver_rank+goods_rank+service_rank)/3)= 3 then 1 else 0 end) as center_sum,sum(case when ceil((deliver_rank+goods_rank+service_rank)/3)<=2 then 1 else 0 end) as low_sum,count(comment_id) as total_sum FROM `tp_comment` WHERE `is_show` = 1 AND `goods_id` = 154627 AND `username` <> 'admin' GROUP BY `goods_id` LIMIT 1 [ RunTime:0.000734s ]
SELECT sum(case when img !='' and img not like 'N;%' then 1 else 0 end) as img_sum,sum(case when ceil((deliver_rank+goods_rank+service_rank)/3)= 4 or ceil((deliver_rank+goods_rank+service_rank)/3)= 5 then 1 else 0 end) as high_sum,sum(case when ceil((deliver_rank+goods_rank+service_rank)/3)= 3 then 1 else 0 end) as center_sum,sum(case when ceil((deliver_rank+goods_rank+service_rank)/3)<=2 then 1 else 0 end) as low_sum,count(comment_id) as total_sum FROM `tp_comment` WHERE `is_show` = 1 AND `goods_id` = 154627 AND `username` <> 'admin' GROUP BY `goods_id` LIMIT 1 [ RunTime:0.000244s ]
SELECT sum(case when img !='' and img not like 'N;%' then 1 else 0 end) as img_sum,sum(case when ceil((deliver_rank+goods_rank+service_rank)/3)= 4 or ceil((deliver_rank+goods_rank+service_rank)/3)= 5 then 1 else 0 end) as high_sum,sum(case when ceil((deliver_rank+goods_rank+service_rank)/3)= 3 then 1 else 0 end) as center_sum,sum(case when ceil((deliver_rank+goods_rank+service_rank)/3)<=2 then 1 else 0 end) as low_sum,count(comment_id) as total_sum FROM `tp_comment` WHERE `is_show` = 1 AND `goods_id` = 154627 AND `username` <> 'admin' GROUP BY `goods_id` LIMIT 1 [ RunTime:0.000287s ]
SELECT sum(case when img !='' and img not like 'N;%' then 1 else 0 end) as img_sum,sum(case when ceil((deliver_rank+goods_rank+service_rank)/3)= 4 or ceil((deliver_rank+goods_rank+service_rank)/3)= 5 then 1 else 0 end) as high_sum,sum(case when ceil((deliver_rank+goods_rank+service_rank)/3)= 3 then 1 else 0 end) as center_sum,sum(case when ceil((deliver_rank+goods_rank+service_rank)/3)<=2 then 1 else 0 end) as low_sum,count(comment_id) as total_sum FROM `tp_comment` WHERE `is_show` = 1 AND `goods_id` = 154627 AND `username` <> 'admin' GROUP BY `goods_id` LIMIT 1 [ RunTime:0.000226s ]
SELECT sum(case when img !='' and img not like 'N;%' then 1 else 0 end) as img_sum,sum(case when ceil((deliver_rank+goods_rank+service_rank)/3)= 4 or ceil((deliver_rank+goods_rank+service_rank)/3)= 5 then 1 else 0 end) as high_sum,sum(case when ceil((deliver_rank+goods_rank+service_rank)/3)= 3 then 1 else 0 end) as center_sum,sum(case when ceil((deliver_rank+goods_rank+service_rank)/3)<=2 then 1 else 0 end) as low_sum,count(comment_id) as total_sum FROM `tp_comment` WHERE `is_show` = 1 AND `goods_id` = 154627 AND `username` <> 'admin' GROUP BY `goods_id` LIMIT 1 [ RunTime:0.000182s ]
SELECT sum(case when img !='' and img not like 'N;%' then 1 else 0 end) as img_sum,sum(case when ceil((deliver_rank+goods_rank+service_rank)/3)= 4 or ceil((deliver_rank+goods_rank+service_rank)/3)= 5 then 1 else 0 end) as high_sum,sum(case when ceil((deliver_rank+goods_rank+service_rank)/3)= 3 then 1 else 0 end) as center_sum,sum(case when ceil((deliver_rank+goods_rank+service_rank)/3)<=2 then 1 else 0 end) as low_sum,count(comment_id) as total_sum FROM `tp_comment` WHERE `is_show` = 1 AND `goods_id` = 154627 AND `username` <> 'admin' GROUP BY `goods_id` LIMIT 1 [ RunTime:0.000210s ]
SELECT sum(case when img !='' and img not like 'N;%' then 1 else 0 end) as img_sum,sum(case when ceil((deliver_rank+goods_rank+service_rank)/3)= 4 or ceil((deliver_rank+goods_rank+service_rank)/3)= 5 then 1 else 0 end) as high_sum,sum(case when ceil((deliver_rank+goods_rank+service_rank)/3)= 3 then 1 else 0 end) as center_sum,sum(case when ceil((deliver_rank+goods_rank+service_rank)/3)<=2 then 1 else 0 end) as low_sum,count(comment_id) as total_sum FROM `tp_comment` WHERE `is_show` = 1 AND `goods_id` = 154627 AND `username` <> 'admin' GROUP BY `goods_id` LIMIT 1 [ RunTime:0.000934s ]
SELECT sum(case when img !='' and img not like 'N;%' then 1 else 0 end) as img_sum,sum(case when ceil((deliver_rank+goods_rank+service_rank)/3)= 4 or ceil((deliver_rank+goods_rank+service_rank)/3)= 5 then 1 else 0 end) as high_sum,sum(case when ceil((deliver_rank+goods_rank+service_rank)/3)= 3 then 1 else 0 end) as center_sum,sum(case when ceil((deliver_rank+goods_rank+service_rank)/3)<=2 then 1 else 0 end) as low_sum,count(comment_id) as total_sum FROM `tp_comment` WHERE `is_show` = 1 AND `goods_id` = 154627 AND `username` <> 'admin' GROUP BY `goods_id` LIMIT 1 [ RunTime:0.000232s ]
SELECT sum(case when img !='' and img not like 'N;%' then 1 else 0 end) as img_sum,sum(case when ceil((deliver_rank+goods_rank+service_rank)/3)= 4 or ceil((deliver_rank+goods_rank+service_rank)/3)= 5 then 1 else 0 end) as high_sum,sum(case when ceil((deliver_rank+goods_rank+service_rank)/3)= 3 then 1 else 0 end) as center_sum,sum(case when ceil((deliver_rank+goods_rank+service_rank)/3)<=2 then 1 else 0 end) as low_sum,count(comment_id) as total_sum FROM `tp_comment` WHERE `is_show` = 1 AND `goods_id` = 154627 AND `username` <> 'admin' GROUP BY `goods_id` LIMIT 1 [ RunTime:0.000248s ]
SELECT sum(case when img !='' and img not like 'N;%' then 1 else 0 end) as img_sum,sum(case when ceil((deliver_rank+goods_rank+service_rank)/3)= 4 or ceil((deliver_rank+goods_rank+service_rank)/3)= 5 then 1 else 0 end) as high_sum,sum(case when ceil((deliver_rank+goods_rank+service_rank)/3)= 3 then 1 else 0 end) as center_sum,sum(case when ceil((deliver_rank+goods_rank+service_rank)/3)<=2 then 1 else 0 end) as low_sum,count(comment_id) as total_sum FROM `tp_comment` WHERE `is_show` = 1 AND `goods_id` = 154627 AND `username` <> 'admin' GROUP BY `goods_id` LIMIT 1 [ RunTime:0.000378s ]
SELECT sum(case when img !='' and img not like 'N;%' then 1 else 0 end) as img_sum,sum(case when ceil((deliver_rank+goods_rank+service_rank)/3)= 4 or ceil((deliver_rank+goods_rank+service_rank)/3)= 5 then 1 else 0 end) as high_sum,sum(case when ceil((deliver_rank+goods_rank+service_rank)/3)= 3 then 1 else 0 end) as center_sum,sum(case when ceil((deliver_rank+goods_rank+service_rank)/3)<=2 then 1 else 0 end) as low_sum,count(comment_id) as total_sum FROM `tp_comment` WHERE `is_show` = 1 AND `goods_id` = 154627 AND `username` <> 'admin' GROUP BY `goods_id` LIMIT 1 [ RunTime:0.000759s ]
SELECT sum(case when img !='' and img not like 'N;%' then 1 else 0 end) as img_sum,sum(case when ceil((deliver_rank+goods_rank+service_rank)/3)= 4 or ceil((deliver_rank+goods_rank+service_rank)/3)= 5 then 1 else 0 end) as high_sum,sum(case when ceil((deliver_rank+goods_rank+service_rank)/3)= 3 then 1 else 0 end) as center_sum,sum(case when ceil((deliver_rank+goods_rank+service_rank)/3)<=2 then 1 else 0 end) as low_sum,count(comment_id) as total_sum FROM `tp_comment` WHERE `is_show` = 1 AND `goods_id` = 154627 AND `username` <> 'admin' GROUP BY `goods_id` LIMIT 1 [ RunTime:0.000886s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 154375 LIMIT 1 [ RunTime:0.000439s ]
SELECT * FROM `tp_wx_user` WHERE ( w_token = "xkopzw1490691329" ) ORDER BY `id` ASC LIMIT 1 [ RunTime:0.000232s ]
SELECT `w_token`,`label_id`,`shop_price` FROM `tp_goods` WHERE `goods_id` = 154375 LIMIT 1 [ RunTime:0.000294s ]
SELECT `brand_id` FROM `tp_goods` WHERE `goods_id` = 154375 AND `is_on_sale` = 1 LIMIT 1 [ RunTime:0.000434s ]
SELECT `guize` FROM `tp_suppliers` WHERE `suppliers_id` = 46 LIMIT 1 [ RunTime:0.000286s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 2994 LIMIT 1 [ RunTime:0.000922s ]
SELECT * FROM `tp_wx_user` WHERE ( w_token = "xkopzw1490691329" ) ORDER BY `id` ASC LIMIT 1 [ RunTime:0.000475s ]
SELECT `w_token`,`label_id`,`shop_price` FROM `tp_goods` WHERE `goods_id` = 2994 LIMIT 1 [ RunTime:0.000317s ]
SELECT `brand_id` FROM `tp_goods` WHERE `goods_id` = 2994 AND `is_on_sale` = 1 LIMIT 1 [ RunTime:0.000696s ]
SELECT `guize` FROM `tp_suppliers` WHERE `suppliers_id` = 107 LIMIT 1 [ RunTime:0.000222s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 155699 LIMIT 1 [ RunTime:0.000199s ]
SELECT * FROM `tp_wx_user` WHERE ( w_token = "xkopzw1490691329" ) ORDER BY `id` ASC LIMIT 1 [ RunTime:0.003669s ]
SELECT `w_token`,`label_id`,`shop_price` FROM `tp_goods` WHERE `goods_id` = 155699 LIMIT 1 [ RunTime:0.000246s ]
SELECT `brand_id` FROM `tp_goods` WHERE `goods_id` = 155699 AND `is_on_sale` = 1 LIMIT 1 [ RunTime:0.000421s ]
SELECT `guize` FROM `tp_suppliers` WHERE `suppliers_id` = 107 LIMIT 1 [ RunTime:0.000125s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 143105 LIMIT 1 [ RunTime:0.000611s ]
SELECT * FROM `tp_wx_user` WHERE ( w_token = "xkopzw1490691329" ) ORDER BY `id` ASC LIMIT 1 [ RunTime:0.000434s ]
SELECT `w_token`,`label_id`,`shop_price` FROM `tp_goods` WHERE `goods_id` = 143105 LIMIT 1 [ RunTime:0.000323s ]
SELECT `brand_id` FROM `tp_goods` WHERE `goods_id` = 143105 AND `is_on_sale` = 1 LIMIT 1 [ RunTime:0.000285s ]
SELECT `guize` FROM `tp_suppliers` WHERE `suppliers_id` = 46 LIMIT 1 [ RunTime:0.000122s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 151506 LIMIT 1 [ RunTime:0.000833s ]
SELECT * FROM `tp_wx_user` WHERE ( w_token = "xkopzw1490691329" ) ORDER BY `id` ASC LIMIT 1 [ RunTime:0.000479s ]
SELECT `w_token`,`label_id`,`shop_price` FROM `tp_goods` WHERE `goods_id` = 151506 LIMIT 1 [ RunTime:0.000440s ]
SELECT `brand_id` FROM `tp_goods` WHERE `goods_id` = 151506 AND `is_on_sale` = 1 LIMIT 1 [ RunTime:0.000255s ]
SELECT `guize` FROM `tp_suppliers` WHERE `suppliers_id` = 46 LIMIT 1 [ RunTime:0.001135s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 143851 LIMIT 1 [ RunTime:0.000272s ]
SELECT * FROM `tp_wx_user` WHERE ( w_token = "xkopzw1490691329" ) ORDER BY `id` ASC LIMIT 1 [ RunTime:0.000348s ]
SELECT `w_token`,`label_id`,`shop_price` FROM `tp_goods` WHERE `goods_id` = 143851 LIMIT 1 [ RunTime:0.000443s ]
SELECT `brand_id` FROM `tp_goods` WHERE `goods_id` = 143851 AND `is_on_sale` = 1 LIMIT 1 [ RunTime:0.000408s ]
SELECT `guize` FROM `tp_suppliers` WHERE `suppliers_id` = 59 LIMIT 1 [ RunTime:0.000335s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 36297 LIMIT 1 [ RunTime:0.000316s ]
SELECT * FROM `tp_wx_user` WHERE ( w_token = "xkopzw1490691329" ) ORDER BY `id` ASC LIMIT 1 [ RunTime:0.000202s ]
SELECT `w_token`,`label_id`,`shop_price` FROM `tp_goods` WHERE `goods_id` = 36297 LIMIT 1 [ RunTime:0.000411s ]
SELECT `brand_id` FROM `tp_goods` WHERE `goods_id` = 36297 AND `is_on_sale` = 1 LIMIT 1 [ RunTime:0.000205s ]
SELECT `guize` FROM `tp_suppliers` WHERE `suppliers_id` = 95 LIMIT 1 [ RunTime:0.000333s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 57099 LIMIT 1 [ RunTime:0.000436s ]
SELECT * FROM `tp_wx_user` WHERE ( w_token = "xkopzw1490691329" ) ORDER BY `id` ASC LIMIT 1 [ RunTime:0.000182s ]
SELECT `w_token`,`label_id`,`shop_price` FROM `tp_goods` WHERE `goods_id` = 57099 LIMIT 1 [ RunTime:0.000372s ]
SELECT `brand_id` FROM `tp_goods` WHERE `goods_id` = 57099 AND `is_on_sale` = 1 LIMIT 1 [ RunTime:0.000438s ]
SELECT `guize` FROM `tp_suppliers` WHERE `suppliers_id` = 46 LIMIT 1 [ RunTime:0.000296s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 130963 LIMIT 1 [ RunTime:0.000274s ]
SELECT * FROM `tp_wx_user` WHERE ( w_token = "xkopzw1490691329" ) ORDER BY `id` ASC LIMIT 1 [ RunTime:0.000213s ]
SELECT `w_token`,`label_id`,`shop_price` FROM `tp_goods` WHERE `goods_id` = 130963 LIMIT 1 [ RunTime:0.000349s ]
SELECT `brand_id` FROM `tp_goods` WHERE `goods_id` = 130963 AND `is_on_sale` = 1 LIMIT 1 [ RunTime:0.000263s ]
SELECT `guize` FROM `tp_suppliers` WHERE `suppliers_id` = 117 LIMIT 1 [ RunTime:0.000208s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 173588 LIMIT 1 [ RunTime:0.000239s ]
SELECT * FROM `tp_wx_user` WHERE ( w_token = "xkopzw1490691329" ) ORDER BY `id` ASC LIMIT 1 [ RunTime:0.000402s ]
SELECT `w_token`,`label_id`,`shop_price` FROM `tp_goods` WHERE `goods_id` = 173588 LIMIT 1 [ RunTime:0.000209s ]
SELECT `brand_id` FROM `tp_goods` WHERE `goods_id` = 173588 AND `is_on_sale` = 1 LIMIT 1 [ RunTime:0.000231s ]
SELECT `guize` FROM `tp_suppliers` WHERE `suppliers_id` = 69 LIMIT 1 [ RunTime:0.000170s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 144835 LIMIT 1 [ RunTime:0.000547s ]
SELECT * FROM `tp_wx_user` WHERE ( w_token = "xkopzw1490691329" ) ORDER BY `id` ASC LIMIT 1 [ RunTime:0.000172s ]
SELECT `w_token`,`label_id`,`shop_price` FROM `tp_goods` WHERE `goods_id` = 144835 LIMIT 1 [ RunTime:0.000391s ]
SELECT `brand_id` FROM `tp_goods` WHERE `goods_id` = 144835 AND `is_on_sale` = 1 LIMIT 1 [ RunTime:0.000330s ]
SELECT `guize` FROM `tp_suppliers` WHERE `suppliers_id` = 46 LIMIT 1 [ RunTime:0.000267s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 108484 LIMIT 1 [ RunTime:0.000515s ]
SELECT * FROM `tp_wx_user` WHERE ( w_token = "xkopzw1490691329" ) ORDER BY `id` ASC LIMIT 1 [ RunTime:0.000224s ]
SELECT `w_token`,`label_id`,`shop_price` FROM `tp_goods` WHERE `goods_id` = 108484 LIMIT 1 [ RunTime:0.000330s ]
SELECT `brand_id` FROM `tp_goods` WHERE `goods_id` = 108484 AND `is_on_sale` = 1 LIMIT 1 [ RunTime:0.000324s ]
SELECT `guize` FROM `tp_suppliers` WHERE `suppliers_id` = 82 LIMIT 1 [ RunTime:0.000265s ]
SHOW FULL COLUMNS FROM `tp_goods_attr` [ RunTime:0.000699s ]
SELECT * FROM `tp_goods_attr` INNER JOIN `tp_goods_attribute` `b` ON `tp_goods_attr`.`attr_id`=`b`.`attr_id` WHERE `goods_id` = 154627 AND `attr_index` = 1 ORDER BY `b`.`order` DESC [ RunTime:0.001003s ]
SELECT sum(case when img !='' and img not like 'N;%' then 1 else 0 end) as img_sum,sum(case when ceil((deliver_rank+goods_rank+service_rank)/3)= 4 or ceil((deliver_rank+goods_rank+service_rank)/3)= 5 then 1 else 0 end) as high_sum,sum(case when ceil((deliver_rank+goods_rank+service_rank)/3)= 3 then 1 else 0 end) as center_sum,sum(case when ceil((deliver_rank+goods_rank+service_rank)/3)<=2 then 1 else 0 end) as low_sum,count(comment_id) as total_sum FROM `tp_comment` WHERE `is_show` = 1 AND `goods_id` = 154627 AND `username` <> 'admin' GROUP BY `goods_id` LIMIT 1 [ RunTime:0.000246s ]
SELECT sum(case when img !='' and img not like 'N;%' then 1 else 0 end) as img_sum,sum(case when ceil((deliver_rank+goods_rank+service_rank)/3)= 4 or ceil((deliver_rank+goods_rank+service_rank)/3)= 5 then 1 else 0 end) as high_sum,sum(case when ceil((deliver_rank+goods_rank+service_rank)/3)= 3 then 1 else 0 end) as center_sum,sum(case when ceil((deliver_rank+goods_rank+service_rank)/3)<=2 then 1 else 0 end) as low_sum,count(comment_id) as total_sum FROM `tp_comment` WHERE `is_show` = 1 AND `goods_id` = 154627 AND `username` <> 'admin' GROUP BY `goods_id` LIMIT 1 [ RunTime:0.000914s ]
SELECT sum(case when img !='' and img not like 'N;%' then 1 else 0 end) as img_sum,sum(case when ceil((deliver_rank+goods_rank+service_rank)/3)= 4 or ceil((deliver_rank+goods_rank+service_rank)/3)= 5 then 1 else 0 end) as high_sum,sum(case when ceil((deliver_rank+goods_rank+service_rank)/3)= 3 then 1 else 0 end) as center_sum,sum(case when ceil((deliver_rank+goods_rank+service_rank)/3)<=2 then 1 else 0 end) as low_sum,count(comment_id) as total_sum FROM `tp_comment` WHERE `is_show` = 1 AND `goods_id` = 154627 AND `username` <> 'admin' GROUP BY `goods_id` LIMIT 1 [ RunTime:0.000228s ]
SELECT sum(case when img !='' and img not like 'N;%' then 1 else 0 end) as img_sum,sum(case when ceil((deliver_rank+goods_rank+service_rank)/3)= 4 or ceil((deliver_rank+goods_rank+service_rank)/3)= 5 then 1 else 0 end) as high_sum,sum(case when ceil((deliver_rank+goods_rank+service_rank)/3)= 3 then 1 else 0 end) as center_sum,sum(case when ceil((deliver_rank+goods_rank+service_rank)/3)<=2 then 1 else 0 end) as low_sum,count(comment_id) as total_sum FROM `tp_comment` WHERE `is_show` = 1 AND `goods_id` = 154627 AND `username` <> 'admin' GROUP BY `goods_id` LIMIT 1 [ RunTime:0.000257s ]
SELECT sum(case when img !='' and img not like 'N;%' then 1 else 0 end) as img_sum,sum(case when ceil((deliver_rank+goods_rank+service_rank)/3)= 4 or ceil((deliver_rank+goods_rank+service_rank)/3)= 5 then 1 else 0 end) as high_sum,sum(case when ceil((deliver_rank+goods_rank+service_rank)/3)= 3 then 1 else 0 end) as center_sum,sum(case when ceil((deliver_rank+goods_rank+service_rank)/3)<=2 then 1 else 0 end) as low_sum,count(comment_id) as total_sum FROM `tp_comment` WHERE `is_show` = 1 AND `goods_id` = 154627 AND `username` <> 'admin' GROUP BY `goods_id` LIMIT 1 [ RunTime:0.000271s ]
SHOW FULL COLUMNS FROM `tp_spec_goods_price` [ RunTime:0.000883s ]
SELECT * FROM `tp_spec_goods_price` WHERE `goods_id` = 154627 AND `goods_id` = 154627 ORDER BY `item_id` [ RunTime:0.000450s ]
SELECT * FROM `tp_wx_user` WHERE ( w_token = "xkopzw1490691329" ) ORDER BY `id` ASC LIMIT 1 [ RunTime:0.000413s ]
SELECT `w_token`,`label_id`,`shop_price` FROM `tp_goods` WHERE `goods_id` = 154627 LIMIT 1 [ RunTime:0.000714s ]
SELECT `brand_id` FROM `tp_goods` WHERE `goods_id` = 154627 AND `is_on_sale` = 1 LIMIT 1 [ RunTime:0.000491s ]
SELECT `guize` FROM `tp_suppliers` WHERE `suppliers_id` = 117 LIMIT 1 [ RunTime:0.000270s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 154627 LIMIT 1 [ RunTime:0.000128s ]
SELECT * FROM `tp_wx_user` WHERE ( w_token = "xkopzw1490691329" ) ORDER BY `id` ASC LIMIT 1 [ RunTime:0.000257s ]
SELECT `w_token`,`label_id`,`shop_price` FROM `tp_goods` WHERE `goods_id` = 154627 LIMIT 1 [ RunTime:0.000192s ]
SELECT `brand_id` FROM `tp_goods` WHERE `goods_id` = 154627 AND `is_on_sale` = 1 LIMIT 1 [ RunTime:0.000419s ]
SELECT `guize` FROM `tp_suppliers` WHERE `suppliers_id` = 117 LIMIT 1 [ RunTime:0.000137s ]
SELECT `key` FROM `tp_spec_goods_price` WHERE `goods_id` = 154627 [ RunTime:0.000204s ]
SELECT `key` FROM `tp_spec_goods_price` WHERE `goods_id` = 154627 [ RunTime:0.000584s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 154627 LIMIT 1 [ RunTime:0.000138s ]
SELECT * FROM `tp_wx_user` WHERE ( w_token = "xkopzw1490691329" ) ORDER BY `id` ASC LIMIT 1 [ RunTime:0.000227s ]
SELECT `w_token`,`label_id`,`shop_price` FROM `tp_goods` WHERE `goods_id` = 154627 LIMIT 1 [ RunTime:0.000225s ]
SELECT `brand_id` FROM `tp_goods` WHERE `goods_id` = 154627 AND `is_on_sale` = 1 LIMIT 1 [ RunTime:0.000195s ]
SELECT `guize` FROM `tp_suppliers` WHERE `suppliers_id` = 117 LIMIT 1 [ RunTime:0.000144s ]

热销推荐

更多 >>

CXW-318-J725S