核货宝订货系统

基本文件流程错误 SQL 调试

/home/wwwroot/wstoms/dinghuo/index.php ( 1.02 KB )
/home/wwwroot/wstoms/dinghuo/vendor/autoload.php ( 0.75 KB )
/home/wwwroot/wstoms/dinghuo/vendor/composer/autoload_real.php ( 1.63 KB )
/home/wwwroot/wstoms/dinghuo/vendor/composer/platform_check.php ( 0.90 KB )
/home/wwwroot/wstoms/dinghuo/vendor/composer/ClassLoader.php ( 16.14 KB )
/home/wwwroot/wstoms/dinghuo/vendor/composer/autoload_static.php ( 14.68 KB )
/home/wwwroot/wstoms/dinghuo/vendor/topthink/think-helper/src/helper.php ( 7.35 KB )
/home/wwwroot/wstoms/dinghuo/vendor/symfony/polyfill-php80/bootstrap.php ( 1.50 KB )
/home/wwwroot/wstoms/dinghuo/vendor/symfony/polyfill-mbstring/bootstrap.php ( 4.75 KB )
/home/wwwroot/wstoms/dinghuo/vendor/symfony/deprecation-contracts/function.php ( 0.98 KB )
/home/wwwroot/wstoms/dinghuo/vendor/ralouphie/getallheaders/src/getallheaders.php ( 1.60 KB )
/home/wwwroot/wstoms/dinghuo/vendor/symfony/translation/Resources/functions.php ( 0.55 KB )
/home/wwwroot/wstoms/dinghuo/vendor/guzzlehttp/guzzle/src/functions_include.php ( 0.16 KB )
/home/wwwroot/wstoms/dinghuo/vendor/guzzlehttp/guzzle/src/functions.php ( 5.55 KB )
/home/wwwroot/wstoms/dinghuo/vendor/markbaker/complex/classes/src/functions/abs.php ( 0.81 KB )
/home/wwwroot/wstoms/dinghuo/vendor/markbaker/complex/classes/src/functions/acos.php ( 1.04 KB )
/home/wwwroot/wstoms/dinghuo/vendor/markbaker/complex/classes/src/functions/acosh.php ( 0.90 KB )
/home/wwwroot/wstoms/dinghuo/vendor/markbaker/complex/classes/src/functions/acot.php ( 0.74 KB )
/home/wwwroot/wstoms/dinghuo/vendor/markbaker/complex/classes/src/functions/acoth.php ( 0.76 KB )
/home/wwwroot/wstoms/dinghuo/vendor/markbaker/complex/classes/src/functions/acsc.php ( 0.83 KB )
/home/wwwroot/wstoms/dinghuo/vendor/markbaker/complex/classes/src/functions/acsch.php ( 0.86 KB )
/home/wwwroot/wstoms/dinghuo/vendor/markbaker/complex/classes/src/functions/argument.php ( 0.81 KB )
/home/wwwroot/wstoms/dinghuo/vendor/markbaker/complex/classes/src/functions/asec.php ( 0.83 KB )
/home/wwwroot/wstoms/dinghuo/vendor/markbaker/complex/classes/src/functions/asech.php ( 0.85 KB )
/home/wwwroot/wstoms/dinghuo/vendor/markbaker/complex/classes/src/functions/asin.php ( 1.01 KB )
/home/wwwroot/wstoms/dinghuo/vendor/markbaker/complex/classes/src/functions/asinh.php ( 0.91 KB )
/home/wwwroot/wstoms/dinghuo/vendor/markbaker/complex/classes/src/functions/atan.php ( 1.34 KB )
/home/wwwroot/wstoms/dinghuo/vendor/markbaker/complex/classes/src/functions/atanh.php ( 1.08 KB )
/home/wwwroot/wstoms/dinghuo/vendor/markbaker/complex/classes/src/functions/conjugate.php ( 0.74 KB )
/home/wwwroot/wstoms/dinghuo/vendor/markbaker/complex/classes/src/functions/cos.php ( 0.92 KB )
/home/wwwroot/wstoms/dinghuo/vendor/markbaker/complex/classes/src/functions/cosh.php ( 0.90 KB )
/home/wwwroot/wstoms/dinghuo/vendor/markbaker/complex/classes/src/functions/cot.php ( 0.83 KB )
/home/wwwroot/wstoms/dinghuo/vendor/markbaker/complex/classes/src/functions/coth.php ( 0.74 KB )
/home/wwwroot/wstoms/dinghuo/vendor/markbaker/complex/classes/src/functions/csc.php ( 0.82 KB )
/home/wwwroot/wstoms/dinghuo/vendor/markbaker/complex/classes/src/functions/csch.php ( 0.84 KB )
/home/wwwroot/wstoms/dinghuo/vendor/markbaker/complex/classes/src/functions/exp.php ( 0.92 KB )
/home/wwwroot/wstoms/dinghuo/vendor/markbaker/complex/classes/src/functions/inverse.php ( 0.87 KB )
/home/wwwroot/wstoms/dinghuo/vendor/markbaker/complex/classes/src/functions/ln.php ( 0.94 KB )
/home/wwwroot/wstoms/dinghuo/vendor/markbaker/complex/classes/src/functions/log2.php ( 1.06 KB )
/home/wwwroot/wstoms/dinghuo/vendor/markbaker/complex/classes/src/functions/log10.php ( 1.08 KB )
/home/wwwroot/wstoms/dinghuo/vendor/markbaker/complex/classes/src/functions/negative.php ( 0.76 KB )
/home/wwwroot/wstoms/dinghuo/vendor/markbaker/complex/classes/src/functions/pow.php ( 1.27 KB )
/home/wwwroot/wstoms/dinghuo/vendor/markbaker/complex/classes/src/functions/rho.php ( 0.84 KB )
/home/wwwroot/wstoms/dinghuo/vendor/markbaker/complex/classes/src/functions/sec.php ( 0.71 KB )
/home/wwwroot/wstoms/dinghuo/vendor/markbaker/complex/classes/src/functions/sech.php ( 0.74 KB )
/home/wwwroot/wstoms/dinghuo/vendor/markbaker/complex/classes/src/functions/sin.php ( 0.87 KB )
/home/wwwroot/wstoms/dinghuo/vendor/markbaker/complex/classes/src/functions/sinh.php ( 0.90 KB )
/home/wwwroot/wstoms/dinghuo/vendor/markbaker/complex/classes/src/functions/sqrt.php ( 0.81 KB )
/home/wwwroot/wstoms/dinghuo/vendor/markbaker/complex/classes/src/functions/tan.php ( 1.21 KB )
/home/wwwroot/wstoms/dinghuo/vendor/markbaker/complex/classes/src/functions/tanh.php ( 1.11 KB )
/home/wwwroot/wstoms/dinghuo/vendor/markbaker/complex/classes/src/functions/theta.php ( 1.25 KB )
/home/wwwroot/wstoms/dinghuo/vendor/markbaker/complex/classes/src/operations/add.php ( 1.26 KB )
/home/wwwroot/wstoms/dinghuo/vendor/markbaker/complex/classes/src/operations/subtract.php ( 1.28 KB )
/home/wwwroot/wstoms/dinghuo/vendor/markbaker/complex/classes/src/operations/multiply.php ( 1.41 KB )
/home/wwwroot/wstoms/dinghuo/vendor/markbaker/complex/classes/src/operations/divideby.php ( 1.75 KB )
/home/wwwroot/wstoms/dinghuo/vendor/markbaker/complex/classes/src/operations/divideinto.php ( 1.75 KB )
/home/wwwroot/wstoms/dinghuo/vendor/markbaker/matrix/classes/src/functions/adjoint.php ( 0.69 KB )
/home/wwwroot/wstoms/dinghuo/vendor/markbaker/matrix/classes/src/functions/antidiagonal.php ( 0.74 KB )
/home/wwwroot/wstoms/dinghuo/vendor/markbaker/matrix/classes/src/functions/cofactors.php ( 0.70 KB )
/home/wwwroot/wstoms/dinghuo/vendor/markbaker/matrix/classes/src/functions/determinant.php ( 0.71 KB )
/home/wwwroot/wstoms/dinghuo/vendor/markbaker/matrix/classes/src/functions/diagonal.php ( 0.70 KB )
/home/wwwroot/wstoms/dinghuo/vendor/markbaker/matrix/classes/src/functions/identity.php ( 0.70 KB )
/home/wwwroot/wstoms/dinghuo/vendor/markbaker/matrix/classes/src/functions/inverse.php ( 0.69 KB )
/home/wwwroot/wstoms/dinghuo/vendor/markbaker/matrix/classes/src/functions/minors.php ( 0.69 KB )
/home/wwwroot/wstoms/dinghuo/vendor/markbaker/matrix/classes/src/functions/trace.php ( 0.69 KB )
/home/wwwroot/wstoms/dinghuo/vendor/markbaker/matrix/classes/src/functions/transpose.php ( 0.71 KB )
/home/wwwroot/wstoms/dinghuo/vendor/markbaker/matrix/classes/src/operations/add.php ( 0.93 KB )
/home/wwwroot/wstoms/dinghuo/vendor/markbaker/matrix/classes/src/operations/directsum.php ( 0.95 KB )
/home/wwwroot/wstoms/dinghuo/vendor/markbaker/matrix/classes/src/operations/subtract.php ( 0.96 KB )
/home/wwwroot/wstoms/dinghuo/vendor/markbaker/matrix/classes/src/operations/multiply.php ( 0.98 KB )
/home/wwwroot/wstoms/dinghuo/vendor/markbaker/matrix/classes/src/operations/divideby.php ( 0.96 KB )
/home/wwwroot/wstoms/dinghuo/vendor/markbaker/matrix/classes/src/operations/divideinto.php ( 0.96 KB )
/home/wwwroot/wstoms/dinghuo/vendor/symfony/polyfill-php72/bootstrap.php ( 1.41 KB )
/home/wwwroot/wstoms/dinghuo/vendor/giteeres/think-addons/src/helper.php ( 9.01 KB )
/home/wwwroot/wstoms/dinghuo/vendor/symfony/var-dumper/Resources/functions/dump.php ( 0.79 KB )
/home/wwwroot/wstoms/dinghuo/vendor/topthink/think-captcha/src/helper.php ( 1.37 KB )
/home/wwwroot/wstoms/dinghuo/vendor/topthink/think-queue/src/common.php ( 1.01 KB )
/home/wwwroot/wstoms/dinghuo/vendor/topthink/framework/src/think/App.php ( 14.17 KB )
/home/wwwroot/wstoms/dinghuo/vendor/topthink/framework/src/think/Container.php ( 15.38 KB )
/home/wwwroot/wstoms/dinghuo/vendor/psr/container/src/ContainerInterface.php ( 1.07 KB )
/home/wwwroot/wstoms/dinghuo/app/provider.php ( 0.19 KB )
/home/wwwroot/wstoms/dinghuo/vendor/topthink/framework/src/think/Http.php ( 6.12 KB )
/home/wwwroot/wstoms/dinghuo/vendor/topthink/think-helper/src/helper/Str.php ( 7.27 KB )
/home/wwwroot/wstoms/dinghuo/vendor/topthink/framework/src/think/Env.php ( 4.64 KB )
/home/wwwroot/wstoms/dinghuo/app/common.php ( 121.85 KB )
/home/wwwroot/wstoms/dinghuo/vendor/topthink/framework/src/helper.php ( 18.44 KB )
/home/wwwroot/wstoms/dinghuo/vendor/topthink/framework/src/think/Config.php ( 5.03 KB )
/home/wwwroot/wstoms/dinghuo/config/app.php ( 1.21 KB )
/home/wwwroot/wstoms/dinghuo/vendor/topthink/framework/src/think/facade/Env.php ( 1.67 KB )
/home/wwwroot/wstoms/dinghuo/vendor/topthink/framework/src/think/Facade.php ( 2.71 KB )
/home/wwwroot/wstoms/dinghuo/config/cache.php ( 0.80 KB )
/home/wwwroot/wstoms/dinghuo/config/captcha.php ( 1.02 KB )
/home/wwwroot/wstoms/dinghuo/config/console.php ( 0.23 KB )
/home/wwwroot/wstoms/dinghuo/config/cookie.php ( 0.56 KB )
/home/wwwroot/wstoms/dinghuo/config/database.php ( 2.25 KB )
/home/wwwroot/wstoms/dinghuo/config/lang.php ( 0.81 KB )
/home/wwwroot/wstoms/dinghuo/config/log.php ( 1.37 KB )
/home/wwwroot/wstoms/dinghuo/config/middleware.php ( 0.19 KB )
/home/wwwroot/wstoms/dinghuo/config/queue.php ( 1.32 KB )
/home/wwwroot/wstoms/dinghuo/config/route.php ( 1.54 KB )
/home/wwwroot/wstoms/dinghuo/config/session.php ( 0.57 KB )
/home/wwwroot/wstoms/dinghuo/config/trace.php ( 0.34 KB )
/home/wwwroot/wstoms/dinghuo/config/view.php ( 0.82 KB )
/home/wwwroot/wstoms/dinghuo/app/event.php ( 0.25 KB )
/home/wwwroot/wstoms/dinghuo/vendor/topthink/framework/src/think/Event.php ( 6.96 KB )
/home/wwwroot/wstoms/dinghuo/app/service.php ( 0.13 KB )
/home/wwwroot/wstoms/dinghuo/app/AppService.php ( 0.26 KB )
/home/wwwroot/wstoms/dinghuo/vendor/topthink/framework/src/think/Service.php ( 1.67 KB )
/home/wwwroot/wstoms/dinghuo/vendor/topthink/framework/src/think/Lang.php ( 7.60 KB )
/home/wwwroot/wstoms/dinghuo/vendor/topthink/framework/src/lang/zh-cn.php ( 12.88 KB )
/home/wwwroot/wstoms/dinghuo/vendor/topthink/framework/src/think/initializer/Error.php ( 3.19 KB )
/home/wwwroot/wstoms/dinghuo/vendor/topthink/framework/src/think/initializer/RegisterService.php ( 1.33 KB )
/home/wwwroot/wstoms/dinghuo/vendor/services.php ( 0.28 KB )
/home/wwwroot/wstoms/dinghuo/vendor/topthink/framework/src/think/service/PaginatorService.php ( 1.52 KB )
/home/wwwroot/wstoms/dinghuo/vendor/topthink/framework/src/think/service/ValidateService.php ( 0.99 KB )
/home/wwwroot/wstoms/dinghuo/vendor/topthink/framework/src/think/service/ModelService.php ( 1.76 KB )
/home/wwwroot/wstoms/dinghuo/vendor/giteeres/think-addons/src/addons/Service.php ( 5.48 KB )
/home/wwwroot/wstoms/dinghuo/vendor/topthink/framework/src/think/facade/Lang.php ( 1.68 KB )
/home/wwwroot/wstoms/dinghuo/vendor/giteeres/think-addons/src/lang/zh-cn.php ( 0.43 KB )
/home/wwwroot/wstoms/dinghuo/vendor/topthink/framework/src/think/facade/Cache.php ( 2.02 KB )
/home/wwwroot/wstoms/dinghuo/vendor/topthink/framework/src/think/Cache.php ( 4.79 KB )
/home/wwwroot/wstoms/dinghuo/vendor/topthink/framework/src/think/Manager.php ( 3.98 KB )
/home/wwwroot/wstoms/dinghuo/vendor/psr/simple-cache/src/CacheInterface.php ( 4.50 KB )
/home/wwwroot/wstoms/dinghuo/vendor/topthink/think-helper/src/helper/Arr.php ( 15.54 KB )
/home/wwwroot/wstoms/dinghuo/vendor/topthink/framework/src/think/cache/driver/File.php ( 7.41 KB )
/home/wwwroot/wstoms/dinghuo/vendor/topthink/framework/src/think/cache/Driver.php ( 8.06 KB )
/home/wwwroot/wstoms/dinghuo/vendor/topthink/framework/src/think/contract/CacheHandlerInterface.php ( 2.25 KB )
/home/wwwroot/wstoms/dinghuo/addons/coupon/common/function.php ( 3.19 KB )
/home/wwwroot/wstoms/dinghuo/addons/custompage/common/function.php ( 11.21 KB )
/home/wwwroot/wstoms/dinghuo/addons/presale/common/function.php ( 7.01 KB )
/home/wwwroot/wstoms/dinghuo/vendor/topthink/framework/src/think/facade/Event.php ( 1.79 KB )
/home/wwwroot/wstoms/dinghuo/vendor/topthink/think-captcha/src/CaptchaService.php ( 0.52 KB )
/home/wwwroot/wstoms/dinghuo/vendor/topthink/think-multi-app/src/Service.php ( 1.08 KB )
/home/wwwroot/wstoms/dinghuo/vendor/topthink/think-queue/src/queue/Service.php ( 1.24 KB )
/home/wwwroot/wstoms/dinghuo/vendor/topthink/think-trace/src/Service.php ( 0.77 KB )
/home/wwwroot/wstoms/dinghuo/vendor/topthink/framework/src/think/Middleware.php ( 6.78 KB )
/home/wwwroot/wstoms/dinghuo/vendor/topthink/framework/src/think/initializer/BootService.php ( 0.77 KB )
/home/wwwroot/wstoms/dinghuo/vendor/topthink/think-orm/src/Paginator.php ( 11.39 KB )
/home/wwwroot/wstoms/dinghuo/vendor/topthink/framework/src/think/Validate.php ( 46.10 KB )
/home/wwwroot/wstoms/dinghuo/vendor/topthink/think-orm/src/Model.php ( 25.87 KB )
/home/wwwroot/wstoms/dinghuo/vendor/topthink/think-orm/src/model/concern/Attribute.php ( 17.06 KB )
/home/wwwroot/wstoms/dinghuo/vendor/topthink/think-orm/src/model/concern/RelationShip.php ( 26.03 KB )
/home/wwwroot/wstoms/dinghuo/vendor/topthink/think-orm/src/model/concern/ModelEvent.php ( 2.26 KB )
/home/wwwroot/wstoms/dinghuo/vendor/topthink/think-orm/src/model/concern/TimeStamp.php ( 5.36 KB )
/home/wwwroot/wstoms/dinghuo/vendor/topthink/think-orm/src/model/concern/Conversion.php ( 8.42 KB )
/home/wwwroot/wstoms/dinghuo/vendor/topthink/think-helper/src/contract/Arrayable.php ( 0.09 KB )
/home/wwwroot/wstoms/dinghuo/vendor/topthink/think-helper/src/contract/Jsonable.php ( 0.13 KB )
/home/wwwroot/wstoms/dinghuo/vendor/topthink/framework/src/think/Db.php ( 2.87 KB )
/home/wwwroot/wstoms/dinghuo/vendor/topthink/think-orm/src/DbManager.php ( 8.86 KB )
/home/wwwroot/wstoms/dinghuo/vendor/topthink/framework/src/think/Log.php ( 8.50 KB )
/home/wwwroot/wstoms/dinghuo/vendor/psr/log/Psr/Log/LoggerInterface.php ( 3.02 KB )
/home/wwwroot/wstoms/dinghuo/vendor/topthink/framework/src/think/Console.php ( 22.65 KB )
/home/wwwroot/wstoms/dinghuo/app/Request.php ( 0.13 KB )
/home/wwwroot/wstoms/dinghuo/vendor/topthink/framework/src/think/Request.php ( 54.04 KB )
/home/wwwroot/wstoms/dinghuo/app/middleware.php ( 0.33 KB )
/home/wwwroot/wstoms/dinghuo/vendor/topthink/framework/src/think/Pipeline.php ( 2.61 KB )
/home/wwwroot/wstoms/dinghuo/vendor/topthink/think-trace/src/TraceDebug.php ( 2.94 KB )
/home/wwwroot/wstoms/dinghuo/vendor/topthink/framework/src/think/middleware/SessionInit.php ( 2.02 KB )
/home/wwwroot/wstoms/dinghuo/vendor/topthink/framework/src/think/Session.php ( 1.80 KB )
/home/wwwroot/wstoms/dinghuo/vendor/topthink/framework/src/think/session/driver/File.php ( 6.28 KB )
/home/wwwroot/wstoms/dinghuo/vendor/topthink/framework/src/think/contract/SessionHandlerInterface.php ( 0.87 KB )
/home/wwwroot/wstoms/dinghuo/vendor/topthink/framework/src/think/session/Store.php ( 7.26 KB )
/home/wwwroot/wstoms/dinghuo/app/middleware/Init.php ( 0.25 KB )
/home/wwwroot/wstoms/dinghuo/vendor/topthink/think-orm/src/facade/Db.php ( 2.25 KB )
/home/wwwroot/wstoms/dinghuo/vendor/topthink/think-orm/src/db/connector/Mysql.php ( 4.37 KB )
/home/wwwroot/wstoms/dinghuo/vendor/topthink/think-orm/src/db/PDOConnection.php ( 47.13 KB )
/home/wwwroot/wstoms/dinghuo/vendor/topthink/think-orm/src/db/Connection.php ( 7.16 KB )
/home/wwwroot/wstoms/dinghuo/vendor/topthink/think-orm/src/db/ConnectionInterface.php ( 4.56 KB )
/home/wwwroot/wstoms/dinghuo/vendor/topthink/think-orm/src/db/builder/Mysql.php ( 13.88 KB )
/home/wwwroot/wstoms/dinghuo/vendor/topthink/think-orm/src/db/Builder.php ( 39.39 KB )
/home/wwwroot/wstoms/dinghuo/vendor/topthink/think-orm/src/db/Query.php ( 11.10 KB )
/home/wwwroot/wstoms/dinghuo/vendor/topthink/think-orm/src/db/BaseQuery.php ( 37.90 KB )
/home/wwwroot/wstoms/dinghuo/vendor/topthink/think-orm/src/db/concern/TimeFieldQuery.php ( 7.50 KB )
/home/wwwroot/wstoms/dinghuo/vendor/topthink/think-orm/src/db/concern/AggregateQuery.php ( 2.83 KB )
/home/wwwroot/wstoms/dinghuo/vendor/topthink/think-orm/src/db/concern/ModelRelationQuery.php ( 15.49 KB )
/home/wwwroot/wstoms/dinghuo/vendor/topthink/think-orm/src/db/concern/ResultOperation.php ( 7.10 KB )
/home/wwwroot/wstoms/dinghuo/vendor/topthink/think-orm/src/db/concern/Transaction.php ( 2.77 KB )
/home/wwwroot/wstoms/dinghuo/vendor/topthink/think-orm/src/db/concern/WhereQuery.php ( 16.06 KB )
/home/wwwroot/wstoms/dinghuo/vendor/topthink/think-orm/src/db/concern/JoinAndViewQuery.php ( 6.88 KB )
/home/wwwroot/wstoms/dinghuo/vendor/topthink/think-orm/src/db/concern/ParamsBind.php ( 2.75 KB )
/home/wwwroot/wstoms/dinghuo/vendor/topthink/think-orm/src/db/concern/TableFieldInfo.php ( 2.51 KB )
/home/wwwroot/wstoms/dinghuo/vendor/topthink/framework/src/think/log/driver/File.php ( 6.17 KB )
/home/wwwroot/wstoms/dinghuo/vendor/topthink/framework/src/think/contract/LogHandlerInterface.php ( 0.86 KB )
/home/wwwroot/wstoms/dinghuo/vendor/topthink/framework/src/think/log/Channel.php ( 6.54 KB )
/home/wwwroot/wstoms/dinghuo/vendor/topthink/framework/src/think/event/LogRecord.php ( 0.86 KB )
/home/wwwroot/wstoms/dinghuo/vendor/topthink/think-helper/src/Collection.php ( 15.83 KB )
/home/wwwroot/wstoms/dinghuo/vendor/topthink/framework/src/think/facade/Session.php ( 1.15 KB )
/home/wwwroot/wstoms/dinghuo/vendor/topthink/think-orm/src/db/Raw.php ( 1.47 KB )
/home/wwwroot/wstoms/dinghuo/app/middleware/ApiListener.php ( 8.54 KB )
/home/wwwroot/wstoms/dinghuo/vendor/topthink/think-multi-app/src/MultiApp.php ( 7.39 KB )
/home/wwwroot/wstoms/dinghuo/app/seller/common.php ( 2.95 KB )
/home/wwwroot/wstoms/dinghuo/app/seller/middleware.php ( 0.31 KB )
/home/wwwroot/wstoms/dinghuo/app/seller/middleware/Auth.php ( 4.13 KB )
/home/wwwroot/wstoms/dinghuo/app/seller/middleware/Action.php ( 1.44 KB )
/home/wwwroot/wstoms/dinghuo/vendor/topthink/framework/src/think/Route.php ( 23.74 KB )
/home/wwwroot/wstoms/dinghuo/vendor/topthink/framework/src/think/route/RuleName.php ( 5.30 KB )
/home/wwwroot/wstoms/dinghuo/vendor/topthink/framework/src/think/route/Domain.php ( 5.41 KB )
/home/wwwroot/wstoms/dinghuo/vendor/topthink/framework/src/think/route/RuleGroup.php ( 13.91 KB )
/home/wwwroot/wstoms/dinghuo/vendor/topthink/framework/src/think/route/Rule.php ( 22.98 KB )
/home/wwwroot/wstoms/dinghuo/vendor/topthink/framework/src/think/route/RuleItem.php ( 9.23 KB )
/home/wwwroot/wstoms/dinghuo/vendor/topthink/framework/src/think/route/dispatch/Url.php ( 3.42 KB )
/home/wwwroot/wstoms/dinghuo/vendor/topthink/framework/src/think/route/dispatch/Controller.php ( 6.61 KB )
/home/wwwroot/wstoms/dinghuo/vendor/topthink/framework/src/think/route/Dispatch.php ( 6.93 KB )
/home/wwwroot/wstoms/dinghuo/app/seller/controller/Index.php ( 4.83 KB )
/home/wwwroot/wstoms/dinghuo/app/seller/controller/Base.php ( 1.81 KB )
/home/wwwroot/wstoms/dinghuo/app/BaseController.php ( 5.91 KB )
/home/wwwroot/wstoms/dinghuo/vendor/topthink/framework/src/think/View.php ( 4.41 KB )
/home/wwwroot/wstoms/dinghuo/app/common/model/GoodsCats.php ( 11.20 KB )
/home/wwwroot/wstoms/dinghuo/app/common/model/Base.php ( 1.99 KB )
/home/wwwroot/wstoms/dinghuo/app/common/model/SellerGoods.php ( 52.00 KB )
/home/wwwroot/wstoms/dinghuo/addons/reward/Reward.php ( 10.04 KB )
/home/wwwroot/wstoms/dinghuo/vendor/giteeres/think-addons/src/addons/Addons.php ( 5.05 KB )
/home/wwwroot/wstoms/dinghuo/vendor/topthink/framework/src/think/facade/View.php ( 1.71 KB )
/home/wwwroot/wstoms/dinghuo/vendor/topthink/think-view/src/Think.php ( 8.42 KB )
/home/wwwroot/wstoms/dinghuo/vendor/topthink/think-template/src/Template.php ( 46.62 KB )
/home/wwwroot/wstoms/dinghuo/vendor/topthink/think-template/src/template/driver/File.php ( 2.33 KB )
/home/wwwroot/wstoms/dinghuo/addons/reward/model/Rewards.php ( 64.55 KB )
/home/wwwroot/wstoms/dinghuo/addons/coupon/Coupon.php ( 5.62 KB )
/home/wwwroot/wstoms/dinghuo/addons/coupon/model/Coupons.php ( 69.13 KB )
/home/wwwroot/wstoms/dinghuo/addons/pifa/Pifa.php ( 5.47 KB )
/home/wwwroot/wstoms/dinghuo/addons/pifa/model/Pifa.php ( 15.12 KB )
/home/wwwroot/wstoms/dinghuo/addons/presale/Presale.php ( 4.44 KB )
/home/wwwroot/wstoms/dinghuo/addons/presale/model/Goods.php ( 17.88 KB )
/home/wwwroot/wstoms/dinghuo/app/common/model/SellerNotices.php ( 2.50 KB )
/home/wwwroot/wstoms/dinghuo/vendor/topthink/think-orm/src/model/Collection.php ( 6.11 KB )
/home/wwwroot/wstoms/dinghuo/runtime/seller/temp/0999d9c652f7da2817cbdb11cbe088bf.php ( 61.00 KB )
/home/wwwroot/wstoms/dinghuo/vendor/topthink/framework/src/think/facade/Config.php ( 1.37 KB )
/home/wwwroot/wstoms/dinghuo/app/common/model/Tags.php ( 13.18 KB )
/home/wwwroot/wstoms/dinghuo/vendor/topthink/framework/src/think/cache/TagSet.php ( 3.23 KB )
/home/wwwroot/wstoms/dinghuo/vendor/topthink/framework/src/think/facade/Route.php ( 4.84 KB )
/home/wwwroot/wstoms/dinghuo/vendor/topthink/think-multi-app/src/Url.php ( 7.60 KB )
/home/wwwroot/wstoms/dinghuo/vendor/topthink/framework/src/think/route/Url.php ( 14.65 KB )
/home/wwwroot/wstoms/dinghuo/runtime/seller/temp/9fd9ed068e826b332b196fd5d773a2db.php ( 3.02 KB )
/home/wwwroot/wstoms/dinghuo/vendor/topthink/think-orm/src/paginator/driver/Bootstrap.php ( 5.41 KB )
/home/wwwroot/wstoms/dinghuo/addons/custompage/Custompage.php ( 13.56 KB )
/home/wwwroot/wstoms/dinghuo/addons/custompage/model/Index.php ( 13.82 KB )
/home/wwwroot/wstoms/dinghuo/addons/cron/Cron.php ( 1.64 KB )
/home/wwwroot/wstoms/dinghuo/vendor/topthink/framework/src/think/Response.php ( 8.60 KB )
/home/wwwroot/wstoms/dinghuo/vendor/topthink/framework/src/think/response/Html.php ( 0.98 KB )
/home/wwwroot/wstoms/dinghuo/vendor/topthink/framework/src/think/Cookie.php ( 6.28 KB )
/home/wwwroot/wstoms/dinghuo/vendor/topthink/think-trace/src/Html.php ( 4.49 KB )

CONNECT:[ UseTime:0.000390s ] mysql:host=127.0.0.1;port=3306;dbname=wstoms_dinghuo;charset=utf8mb4
SHOW FULL COLUMNS FROM `wst_sys_configs` [ RunTime:0.000543s ]
SELECT `fieldCode`,`fieldValue` FROM `wst_sys_configs` [ RunTime:0.000305s ]
SHOW FULL COLUMNS FROM `wst_datas` [ RunTime:0.000404s ]
SELECT `dataVal` FROM `wst_datas` WHERE `catId` = 3 [ RunTime:0.000254s ]
SHOW FULL COLUMNS FROM `wst_addons` [ RunTime:0.000461s ]
SELECT `addonId`,`name` FROM `wst_addons` WHERE ( status =1 and dataFlag = 1 ) [ RunTime:0.000189s ]
SHOW FULL COLUMNS FROM `wst_sellers` [ RunTime:0.000738s ]
SELECT * FROM `wst_sellers` WHERE `sellerId` = 0 AND `dataFlag` = 1 LIMIT 1 [ RunTime:0.000368s ]
SELECT `fieldCode`,`fieldValue` FROM `wst_sys_configs` [ RunTime:0.000270s ]
SELECT `dataVal` FROM `wst_datas` WHERE `catId` = 3 [ RunTime:0.000227s ]
SELECT `addonId`,`name` FROM `wst_addons` WHERE ( status =1 and dataFlag = 1 ) [ RunTime:0.000184s ]
SHOW FULL COLUMNS FROM `wst_goods_cats` [ RunTime:0.000543s ]
SELECT `catName`,`catId` FROM `wst_goods_cats` WHERE `dataFlag` = 1 AND `isShow` = 1 AND `parentId` = 0 AND `isFloor` = 1 ORDER BY `catSort` LIMIT 10 [ RunTime:0.000302s ]
SELECT `parentId`,`catName`,`catId` FROM `wst_goods_cats` WHERE `dataFlag` = 1 AND `isShow` = 1 AND `parentId` IN (57,67,70,81) AND `isFloor` = 1 ORDER BY `catSort` ASC [ RunTime:0.000270s ]
SHOW FULL COLUMNS FROM `wst_seller_goods` [ RunTime:0.000532s ]
SELECT `areaIdPath` FROM `wst_sellers` WHERE `sellerId` = 0 LIMIT 1 [ RunTime:0.000156s ]
SHOW FULL COLUMNS FROM `wst_goods` [ RunTime:0.000680s ]
SELECT `g`.`goodsId`,`g`.`isSpec`,`g`.`goodsTips`,`g`.`goodsName`,`g`.`goodsImg`,g.goodsPrice defaultGoodsPrice,`g`.`saleNum`,`sgs`.`platformPrice`,`g`.`marketPrice`,`g`.`minOrder`,`g`.`goodsUnit` FROM `wst_goods` `g` INNER JOIN `wst_seller_goods` `sgs` ON `sgs`.`goodsId`=g.goodsId AND sgs.sellerId=0 and sgs.dataFlag=1 INNER JOIN `wst_recommends` `r` ON `g`.`goodsId`=`r`.`dataId` WHERE `r`.`goodsCatId` = 0 AND `g`.`isSale` = 1 AND `g`.`dataFlag` = 1 AND `r`.`dataType` = 1 ORDER BY `r`.`dataSort` ASC LIMIT 5 [ RunTime:0.000542s ]
SELECT gs.id goodsSpecId,`g`.`goodsId`,`g`.`goodsCatId`,`g`.`goodsImg`,`g`.`goodsUnit`,`g`.`goodsTips`,`g`.`goodsName`,`g`.`goodsPrice`,g.goodsPrice defaultGoodsPrice,`g`.`goodsStock`,`g`.`saleNum`,`g`.`isSpec`,`g`.`goodsSn`,`gs`.`specStock`,`gs`.`specIds`,g.goodsPrice as platformPrice,`g`.`marketPrice`,`g`.`minOrder` FROM `wst_goods` `g` LEFT JOIN `wst_goods_specs` `gs` ON `g`.`goodsId`=gs.goodsId and gs.isDefault=1 WHERE `g`.`dataFlag` = 1 AND `g`.`isHot` = 1 AND `g`.`isSale` = 1 LIMIT 5 [ RunTime:0.000620s ]
SELECT `areaIdPath` FROM `wst_sellers` WHERE `sellerId` = 0 LIMIT 1 [ RunTime:0.000206s ]
SELECT gs.id goodsSpecId,`g`.`goodsId`,`g`.`goodsCatId`,`g`.`goodsImg`,`g`.`goodsUnit`,`g`.`goodsTips`,`g`.`goodsName`,`g`.`goodsPrice`,g.goodsPrice defaultGoodsPrice,`g`.`goodsStock`,`g`.`saleNum`,`g`.`isSpec`,`g`.`goodsSn`,`gs`.`specStock`,`gs`.`specIds`,g.goodsPrice as platformPrice,`g`.`marketPrice`,`g`.`minOrder` FROM `wst_goods` `g` LEFT JOIN `wst_goods_specs` `gs` ON `g`.`goodsId`=gs.goodsId and gs.isDefault=1 WHERE `g`.`dataFlag` = 1 AND `g`.`isHot` = 1 AND `g`.`isSale` = 1 LIMIT 2 [ RunTime:0.000501s ]
SHOW FULL COLUMNS FROM `wst_reward_goods` [ RunTime:0.000573s ]
SELECT COUNT(*) AS think_count FROM `wst_reward_goods` `rg` INNER JOIN `wst_rewards` `r` ON `rg`.`rewardId`=`r`.`rewardId` WHERE ( r.dataFlag=1 and goodsId=93 and startDate<="2023-12-01" and endDate>="2023-12-01" ) [ RunTime:0.000406s ]
SHOW FULL COLUMNS FROM `wst_rewards` [ RunTime:0.000411s ]
SELECT COUNT(*) AS think_count FROM `wst_rewards` WHERE ( dataFlag=1 and useObjects=0 and startDate<="2023-12-01" and endDate>="2023-12-01" ) [ RunTime:0.000220s ]
SELECT COUNT(*) AS think_count FROM `wst_reward_goods` `rg` INNER JOIN `wst_rewards` `r` ON `rg`.`rewardId`=`r`.`rewardId` WHERE ( r.dataFlag=1 and goodsId=94 and startDate<="2023-12-01" and endDate>="2023-12-01" ) [ RunTime:0.000292s ]
SELECT COUNT(*) AS think_count FROM `wst_rewards` WHERE ( dataFlag=1 and useObjects=0 and startDate<="2023-12-01" and endDate>="2023-12-01" ) [ RunTime:0.000246s ]
SHOW FULL COLUMNS FROM `wst_coupon_goods` [ RunTime:0.000510s ]
SELECT COUNT(*) AS think_count FROM `wst_coupon_goods` `cg` INNER JOIN `wst_coupons` `c` ON `cg`.`couponId`=`c`.`couponId` WHERE `endDate` >= '2023-12-01' AND `goodsId` = 93 AND `dataFlag` = 1 [ RunTime:0.000338s ]
SHOW FULL COLUMNS FROM `wst_coupons` [ RunTime:0.000422s ]
SELECT COUNT(*) AS think_count FROM `wst_coupons` WHERE ( couponType=2 and dataFlag=1 and useObjects=0 and startDate<="2023-12-01" and endDate>="2023-12-01" ) [ RunTime:0.000233s ]
SELECT COUNT(*) AS think_count FROM `wst_coupon_goods` `cg` INNER JOIN `wst_coupons` `c` ON `cg`.`couponId`=`c`.`couponId` WHERE `endDate` >= '2023-12-01' AND `goodsId` = 94 AND `dataFlag` = 1 [ RunTime:0.000243s ]
SELECT COUNT(*) AS think_count FROM `wst_coupons` WHERE ( couponType=2 and dataFlag=1 and useObjects=0 and startDate<="2023-12-01" and endDate>="2023-12-01" ) [ RunTime:0.000231s ]
SELECT `goodsId`,`isPifa`,`goodsPrice` FROM `wst_goods` WHERE `goodsId` = 93 LIMIT 1 [ RunTime:0.000226s ]
SELECT `goodsId`,`isPifa`,`goodsPrice` FROM `wst_goods` WHERE `goodsId` = 94 LIMIT 1 [ RunTime:0.000171s ]
SHOW FULL COLUMNS FROM `wst_presales` [ RunTime:0.000617s ]
SELECT * FROM `wst_presales` WHERE `startTime` <= '2023-12-01 07:58:35' AND `endTime` >= '2023-12-01 07:58:35' AND `dataFlag` = 1 AND `isSale` = 1 AND `goodsId` = 93 LIMIT 1 [ RunTime:0.000301s ]
SELECT * FROM `wst_presales` WHERE `startTime` <= '2023-12-01 07:58:35' AND `endTime` >= '2023-12-01 07:58:35' AND `dataFlag` = 1 AND `isSale` = 1 AND `goodsId` = 94 LIMIT 1 [ RunTime:0.000287s ]
SELECT `areaIdPath` FROM `wst_sellers` WHERE `sellerId` = 0 LIMIT 1 [ RunTime:0.000176s ]
SELECT gs.id goodsSpecId,`g`.`goodsId`,`g`.`goodsCatId`,`g`.`goodsImg`,`g`.`goodsUnit`,`g`.`goodsTips`,`g`.`goodsName`,`g`.`goodsPrice`,g.goodsPrice defaultGoodsPrice,`g`.`goodsStock`,`g`.`saleNum`,`g`.`isSpec`,`g`.`goodsSn`,`gs`.`specStock`,`gs`.`specIds`,g.goodsPrice as platformPrice,`g`.`marketPrice`,`g`.`minOrder` FROM `wst_goods` `g` LEFT JOIN `wst_goods_specs` `gs` ON `g`.`goodsId`=gs.goodsId and gs.isDefault=1 WHERE `g`.`dataFlag` = 1 AND `g`.`isNew` = 1 AND `g`.`isSale` = 1 LIMIT 2 [ RunTime:0.000329s ]
SELECT COUNT(*) AS think_count FROM `wst_reward_goods` `rg` INNER JOIN `wst_rewards` `r` ON `rg`.`rewardId`=`r`.`rewardId` WHERE ( r.dataFlag=1 and goodsId=93 and startDate<="2023-12-01" and endDate>="2023-12-01" ) [ RunTime:0.000249s ]
SELECT COUNT(*) AS think_count FROM `wst_rewards` WHERE ( dataFlag=1 and useObjects=0 and startDate<="2023-12-01" and endDate>="2023-12-01" ) [ RunTime:0.000196s ]
SELECT COUNT(*) AS think_count FROM `wst_reward_goods` `rg` INNER JOIN `wst_rewards` `r` ON `rg`.`rewardId`=`r`.`rewardId` WHERE ( r.dataFlag=1 and goodsId=94 and startDate<="2023-12-01" and endDate>="2023-12-01" ) [ RunTime:0.000198s ]
SELECT COUNT(*) AS think_count FROM `wst_rewards` WHERE ( dataFlag=1 and useObjects=0 and startDate<="2023-12-01" and endDate>="2023-12-01" ) [ RunTime:0.000178s ]
SELECT COUNT(*) AS think_count FROM `wst_coupon_goods` `cg` INNER JOIN `wst_coupons` `c` ON `cg`.`couponId`=`c`.`couponId` WHERE `endDate` >= '2023-12-01' AND `goodsId` = 93 AND `dataFlag` = 1 [ RunTime:0.000197s ]
SELECT COUNT(*) AS think_count FROM `wst_coupons` WHERE ( couponType=2 and dataFlag=1 and useObjects=0 and startDate<="2023-12-01" and endDate>="2023-12-01" ) [ RunTime:0.000199s ]
SELECT COUNT(*) AS think_count FROM `wst_coupon_goods` `cg` INNER JOIN `wst_coupons` `c` ON `cg`.`couponId`=`c`.`couponId` WHERE `endDate` >= '2023-12-01' AND `goodsId` = 94 AND `dataFlag` = 1 [ RunTime:0.000216s ]
SELECT COUNT(*) AS think_count FROM `wst_coupons` WHERE ( couponType=2 and dataFlag=1 and useObjects=0 and startDate<="2023-12-01" and endDate>="2023-12-01" ) [ RunTime:0.000207s ]
SELECT `goodsId`,`isPifa`,`goodsPrice` FROM `wst_goods` WHERE `goodsId` = 93 LIMIT 1 [ RunTime:0.000170s ]
SELECT `goodsId`,`isPifa`,`goodsPrice` FROM `wst_goods` WHERE `goodsId` = 94 LIMIT 1 [ RunTime:0.000134s ]
SELECT * FROM `wst_presales` WHERE `startTime` <= '2023-12-01 07:58:35' AND `endTime` >= '2023-12-01 07:58:35' AND `dataFlag` = 1 AND `isSale` = 1 AND `goodsId` = 93 LIMIT 1 [ RunTime:0.000232s ]
SELECT * FROM `wst_presales` WHERE `startTime` <= '2023-12-01 07:58:35' AND `endTime` >= '2023-12-01 07:58:35' AND `dataFlag` = 1 AND `isSale` = 1 AND `goodsId` = 94 LIMIT 1 [ RunTime:0.000243s ]
SHOW FULL COLUMNS FROM `wst_seller_notices` [ RunTime:0.000543s ]
SELECT * FROM `wst_seller_notices` WHERE `dataFlag` = 1 AND `isShow` = 1 ORDER BY `isUp` DESC,`upTime` DESC,`noticeId` DESC LIMIT 10 [ RunTime:0.000372s ]
SHOW FULL COLUMNS FROM `wst_ads` [ RunTime:0.000574s ]
SELECT `adId`,`adName`,`adURL`,`adFile`,`positionWidth`,`positionHeight` FROM `wst_ads` `a` LEFT JOIN `wst_ad_positions` `ap` ON `a`.`adPositionId`=ap.positionId and ap.dataFlag=1 WHERE ( a.dataFlag=1 and ap.positionCode='index-top-ads' and adStartDate<= '2023-12-01' and adEndDate>='2023-12-01' and a.sellerId=0 and a.adSrc=1 ) ORDER BY `adSort` ASC LIMIT 1 [ RunTime:0.000418s ]
SHOW FULL COLUMNS FROM `wst_navs` [ RunTime:0.000497s ]
SELECT * FROM `wst_navs` WHERE `isShow` = 1 ORDER BY `navSort` ASC [ RunTime:0.000244s ]
SELECT `catName`,`catId`,`catImg` FROM `wst_goods_cats` WHERE `dataFlag` = 1 AND `isShow` = 1 AND `parentId` = 0 ORDER BY `catSort` ASC [ RunTime:0.000259s ]
SELECT `catName`,`catId`,`parentId`,`catImg` FROM `wst_goods_cats` WHERE `dataFlag` = 1 AND `isShow` = 1 AND `parentId` IN (40,54,57,67,68,69,70,74,75,76,77,81,84) ORDER BY `catSort` ASC [ RunTime:0.000288s ]
SELECT `catName`,`catId`,`parentId`,`catImg` FROM `wst_goods_cats` WHERE `dataFlag` = 1 AND `isShow` = 1 AND `parentId` IN (41,55,56,59,78,79,82,83,86,87,88,42,60,44) ORDER BY `catSort` ASC [ RunTime:0.000302s ]
SELECT `catName`,`catId`,`catImg` FROM `wst_goods_cats` WHERE `dataFlag` = 1 AND `isShow` = 1 AND `parentId` = 0 ORDER BY `catSort` ASC [ RunTime:0.000240s ]
SELECT `catName`,`catId`,`parentId`,`catImg` FROM `wst_goods_cats` WHERE `dataFlag` = 1 AND `isShow` = 1 AND `parentId` IN (40,54,57,67,68,69,70,74,75,76,77,81,84) ORDER BY `catSort` ASC [ RunTime:0.000276s ]
SELECT `catName`,`catId`,`parentId`,`catImg` FROM `wst_goods_cats` WHERE `dataFlag` = 1 AND `isShow` = 1 AND `parentId` IN (41,55,56,59,78,79,82,83,86,87,88,42,60,44) ORDER BY `catSort` ASC [ RunTime:0.000267s ]
SELECT `adId`,`adName`,`adURL`,`adFile`,`positionWidth`,`positionHeight` FROM `wst_ads` `a` LEFT JOIN `wst_ad_positions` `ap` ON `a`.`adPositionId`=ap.positionId and ap.dataFlag=1 WHERE ( a.dataFlag=1 and ap.positionCode='wall-left-top' and adStartDate<= '2023-12-01' and adEndDate>='2023-12-01' and a.sellerId=0 and a.adSrc=1 ) ORDER BY `adSort` ASC LIMIT 1 [ RunTime:0.000389s ]
SELECT `adId`,`adName`,`adURL`,`adFile`,`positionWidth`,`positionHeight` FROM `wst_ads` `a` LEFT JOIN `wst_ad_positions` `ap` ON `a`.`adPositionId`=ap.positionId and ap.dataFlag=1 WHERE ( a.dataFlag=1 and ap.positionCode='wall-left-bottom' and adStartDate<= '2023-12-01' and adEndDate>='2023-12-01' and a.sellerId=0 and a.adSrc=1 ) ORDER BY `adSort` ASC LIMIT 1 [ RunTime:0.000321s ]
SELECT `adId`,`adName`,`adURL`,`adFile`,`positionWidth`,`positionHeight` FROM `wst_ads` `a` LEFT JOIN `wst_ad_positions` `ap` ON `a`.`adPositionId`=ap.positionId and ap.dataFlag=1 WHERE ( a.dataFlag=1 and ap.positionCode='wall-center' and adStartDate<= '2023-12-01' and adEndDate>='2023-12-01' and a.sellerId=0 and a.adSrc=1 ) ORDER BY `adSort` ASC LIMIT 1 [ RunTime:0.000306s ]
SELECT `adId`,`adName`,`adURL`,`adFile`,`positionWidth`,`positionHeight` FROM `wst_ads` `a` LEFT JOIN `wst_ad_positions` `ap` ON `a`.`adPositionId`=ap.positionId and ap.dataFlag=1 WHERE ( a.dataFlag=1 and ap.positionCode='wall-right-top' and adStartDate<= '2023-12-01' and adEndDate>='2023-12-01' and a.sellerId=0 and a.adSrc=1 ) ORDER BY `adSort` ASC LIMIT 1 [ RunTime:0.000280s ]
SELECT `adId`,`adName`,`adURL`,`adFile`,`positionWidth`,`positionHeight` FROM `wst_ads` `a` LEFT JOIN `wst_ad_positions` `ap` ON `a`.`adPositionId`=ap.positionId and ap.dataFlag=1 WHERE ( a.dataFlag=1 and ap.positionCode='wall-right-bottom' and adStartDate<= '2023-12-01' and adEndDate>='2023-12-01' and a.sellerId=0 and a.adSrc=1 ) ORDER BY `adSort` ASC LIMIT 1 [ RunTime:0.000268s ]
SELECT `areaIdPath` FROM `wst_sellers` WHERE `sellerId` = 0 LIMIT 1 [ RunTime:0.000210s ]
SELECT COUNT(*) AS think_count FROM `wst_presales` `p` INNER JOIN `wst_goods` `g` ON `p`.`goodsId`=`g`.`goodsId` LEFT JOIN `wst_goods_specs` `gs` ON `g`.`goodsId`=gs.goodsId and gs.isDefault=1 WHERE `p`.`startTime` <= '2023-12-01 07:58:35' AND `p`.`endTime` >= '2023-12-01 07:58:35' AND `p`.`dataFlag` = 1 AND `p`.`isSale` = 1 AND `g`.`dataFlag` = 1 AND `g`.`isSale` = 1 [ RunTime:0.000361s ]
SELECT `p`.`goodsId`,`p`.`goodsImg`,`p`.`goodsName`,`g`.`goodsPrice`,`p`.`reduceMoney`,`p`.`startTime`,`p`.`endTime`,`p`.`id`,`p`.`goodsNum`,`p`.`orderNum`,`g`.`gallery`,`g`.`goodsUnit`,`g`.`isSpec`,`gs`.`specIds`,gs.id goodsSpecId FROM `wst_presales` `p` INNER JOIN `wst_goods` `g` ON `p`.`goodsId`=`g`.`goodsId` LEFT JOIN `wst_goods_specs` `gs` ON `g`.`goodsId`=gs.goodsId and gs.isDefault=1 WHERE `p`.`startTime` <= '2023-12-01 07:58:35' AND `p`.`endTime` >= '2023-12-01 07:58:35' AND `p`.`dataFlag` = 1 AND `p`.`isSale` = 1 AND `g`.`dataFlag` = 1 AND `g`.`isSale` = 1 ORDER BY `p`.`startTime`,`p`.`id` LIMIT 0,15 [ RunTime:0.000412s ]
SHOW FULL COLUMNS FROM `wst_spec_cats` [ RunTime:0.000516s ]
SELECT `gc`.`isAllowImg`,`gc`.`catName`,`sit`.`catId`,`sit`.`itemId`,`sit`.`itemName`,`sit`.`itemImg` FROM `wst_spec_cats` `gc` INNER JOIN `wst_spec_items` `sit` ON `gc`.`catId`=`sit`.`catId` WHERE `sit`.`goodsId` = 101 AND `gc`.`isShow` = 1 AND `sit`.`dataFlag` = 1 ORDER BY `gc`.`isAllowImg` DESC,`gc`.`catSort` ASC,`gc`.`catId` ASC [ RunTime:0.000394s ]
SHOW FULL COLUMNS FROM `wst_goods_specs` [ RunTime:0.000378s ]
SELECT `specIds` FROM `wst_goods_specs` WHERE `goodsId` = 101 AND `isDefault` = 1 LIMIT 1 [ RunTime:0.000185s ]
SHOW FULL COLUMNS FROM `wst_spec_items` [ RunTime:0.000376s ]
SELECT `catId` FROM `wst_spec_items` WHERE `itemId` = 153 LIMIT 1 [ RunTime:0.000158s ]
SELECT `id`,`isDefault`,`productNo`,`specIds`,`marketPrice`,specPrice as specPrice,`specStock`,specPrice guidePrice FROM `wst_goods_specs` WHERE `goodsId` = 101 [ RunTime:0.000228s ]
SELECT `gc`.`isAllowImg`,`gc`.`catName`,`sit`.`catId`,`sit`.`itemId`,`sit`.`itemName`,`sit`.`itemImg` FROM `wst_spec_cats` `gc` INNER JOIN `wst_spec_items` `sit` ON `gc`.`catId`=`sit`.`catId` WHERE `sit`.`goodsId` = 113 AND `gc`.`isShow` = 1 AND `sit`.`dataFlag` = 1 ORDER BY `gc`.`isAllowImg` DESC,`gc`.`catSort` ASC,`gc`.`catId` ASC [ RunTime:0.000263s ]
SELECT `specIds` FROM `wst_goods_specs` WHERE `goodsId` = 113 AND `isDefault` = 1 LIMIT 1 [ RunTime:0.000160s ]
SELECT `catId` FROM `wst_spec_items` WHERE `itemId` = 170 LIMIT 1 [ RunTime:0.000142s ]
SELECT `id`,`isDefault`,`productNo`,`specIds`,`marketPrice`,specPrice as specPrice,`specStock`,specPrice guidePrice FROM `wst_goods_specs` WHERE `goodsId` = 113 [ RunTime:0.000165s ]
SELECT `gc`.`isAllowImg`,`gc`.`catName`,`sit`.`catId`,`sit`.`itemId`,`sit`.`itemName`,`sit`.`itemImg` FROM `wst_spec_cats` `gc` INNER JOIN `wst_spec_items` `sit` ON `gc`.`catId`=`sit`.`catId` WHERE `sit`.`goodsId` = 104 AND `gc`.`isShow` = 1 AND `sit`.`dataFlag` = 1 ORDER BY `gc`.`isAllowImg` DESC,`gc`.`catSort` ASC,`gc`.`catId` ASC [ RunTime:0.000267s ]
SELECT `specIds` FROM `wst_goods_specs` WHERE `goodsId` = 104 AND `isDefault` = 1 LIMIT 1 [ RunTime:0.000201s ]
SELECT `catId` FROM `wst_spec_items` WHERE `itemId` = 163 LIMIT 1 [ RunTime:0.000154s ]
SELECT `id`,`isDefault`,`productNo`,`specIds`,`marketPrice`,specPrice as specPrice,`specStock`,specPrice guidePrice FROM `wst_goods_specs` WHERE `goodsId` = 104 [ RunTime:0.000207s ]
SELECT `gc`.`isAllowImg`,`gc`.`catName`,`sit`.`catId`,`sit`.`itemId`,`sit`.`itemName`,`sit`.`itemImg` FROM `wst_spec_cats` `gc` INNER JOIN `wst_spec_items` `sit` ON `gc`.`catId`=`sit`.`catId` WHERE `sit`.`goodsId` = 105 AND `gc`.`isShow` = 1 AND `sit`.`dataFlag` = 1 ORDER BY `gc`.`isAllowImg` DESC,`gc`.`catSort` ASC,`gc`.`catId` ASC [ RunTime:0.000290s ]
SELECT `specIds` FROM `wst_goods_specs` WHERE `goodsId` = 105 AND `isDefault` = 1 LIMIT 1 [ RunTime:0.000171s ]
SELECT `catId` FROM `wst_spec_items` WHERE `itemId` = 166 LIMIT 1 [ RunTime:0.000135s ]
SELECT `id`,`isDefault`,`productNo`,`specIds`,`marketPrice`,specPrice as specPrice,`specStock`,specPrice guidePrice FROM `wst_goods_specs` WHERE `goodsId` = 105 [ RunTime:0.000186s ]
SELECT `catName`,`itemId`,`itemName` FROM `wst_spec_items` `s` LEFT JOIN `wst_spec_cats` `sc` ON `s`.`catId`=`sc`.`catId` WHERE `s`.`goodsId` IN (101,113,104,105) AND `s`.`dataFlag` = 1 [ RunTime:0.000260s ]
SELECT `adId`,`adName`,`adURL`,`adFile`,`positionWidth`,`positionHeight` FROM `wst_ads` `a` LEFT JOIN `wst_ad_positions` `ap` ON `a`.`adPositionId`=ap.positionId and ap.dataFlag=1 WHERE ( a.dataFlag=1 and ap.positionCode='ads-1-1' and adStartDate<= '2023-12-01' and adEndDate>='2023-12-01' and a.sellerId=0 and a.adSrc=1 ) ORDER BY `adSort` ASC LIMIT 1 [ RunTime:0.000298s ]
SELECT `areaIdPath` FROM `wst_sellers` WHERE `sellerId` = 0 LIMIT 1 [ RunTime:0.000166s ]
SELECT `parentId` FROM `wst_goods_cats` WHERE `catId` = 57 LIMIT 1 [ RunTime:0.000164s ]
SELECT gs.id goodsSpecId,`g`.`goodsId`,`g`.`goodsCatId`,`g`.`goodsImg`,`g`.`goodsUnit`,`g`.`goodsTips`,`g`.`goodsName`,`g`.`goodsPrice`,g.goodsPrice defaultGoodsPrice,`g`.`goodsStock`,`g`.`saleNum`,`g`.`isSpec`,`g`.`goodsSn`,`gs`.`specStock`,`gs`.`specIds`,g.goodsPrice as platformPrice,`g`.`marketPrice`,`g`.`minOrder` FROM `wst_goods` `g` LEFT JOIN `wst_goods_specs` `gs` ON `g`.`goodsId`=gs.goodsId and gs.isDefault=1 WHERE `g`.`dataFlag` = 1 AND `g`.`isReCom` = 1 AND `g`.`goodsCatIdPath` LIKE '57_%' AND `g`.`isSale` = 1 LIMIT 8 [ RunTime:0.000406s ]
SELECT COUNT(*) AS think_count FROM `wst_reward_goods` `rg` INNER JOIN `wst_rewards` `r` ON `rg`.`rewardId`=`r`.`rewardId` WHERE ( r.dataFlag=1 and goodsId=102 and startDate<="2023-12-01" and endDate>="2023-12-01" ) [ RunTime:0.000249s ]
SELECT COUNT(*) AS think_count FROM `wst_rewards` WHERE ( dataFlag=1 and useObjects=0 and startDate<="2023-12-01" and endDate>="2023-12-01" ) [ RunTime:0.000170s ]
SELECT COUNT(*) AS think_count FROM `wst_reward_goods` `rg` INNER JOIN `wst_rewards` `r` ON `rg`.`rewardId`=`r`.`rewardId` WHERE ( r.dataFlag=1 and goodsId=103 and startDate<="2023-12-01" and endDate>="2023-12-01" ) [ RunTime:0.000206s ]
SELECT COUNT(*) AS think_count FROM `wst_rewards` WHERE ( dataFlag=1 and useObjects=0 and startDate<="2023-12-01" and endDate>="2023-12-01" ) [ RunTime:0.000176s ]
SELECT COUNT(*) AS think_count FROM `wst_reward_goods` `rg` INNER JOIN `wst_rewards` `r` ON `rg`.`rewardId`=`r`.`rewardId` WHERE ( r.dataFlag=1 and goodsId=115 and startDate<="2023-12-01" and endDate>="2023-12-01" ) [ RunTime:0.000209s ]
SELECT COUNT(*) AS think_count FROM `wst_rewards` WHERE ( dataFlag=1 and useObjects=0 and startDate<="2023-12-01" and endDate>="2023-12-01" ) [ RunTime:0.000169s ]
SELECT COUNT(*) AS think_count FROM `wst_reward_goods` `rg` INNER JOIN `wst_rewards` `r` ON `rg`.`rewardId`=`r`.`rewardId` WHERE ( r.dataFlag=1 and goodsId=117 and startDate<="2023-12-01" and endDate>="2023-12-01" ) [ RunTime:0.000195s ]
SELECT COUNT(*) AS think_count FROM `wst_rewards` WHERE ( dataFlag=1 and useObjects=0 and startDate<="2023-12-01" and endDate>="2023-12-01" ) [ RunTime:0.000182s ]
SELECT COUNT(*) AS think_count FROM `wst_reward_goods` `rg` INNER JOIN `wst_rewards` `r` ON `rg`.`rewardId`=`r`.`rewardId` WHERE ( r.dataFlag=1 and goodsId=118 and startDate<="2023-12-01" and endDate>="2023-12-01" ) [ RunTime:0.000186s ]
SELECT COUNT(*) AS think_count FROM `wst_rewards` WHERE ( dataFlag=1 and useObjects=0 and startDate<="2023-12-01" and endDate>="2023-12-01" ) [ RunTime:0.000163s ]
SELECT COUNT(*) AS think_count FROM `wst_reward_goods` `rg` INNER JOIN `wst_rewards` `r` ON `rg`.`rewardId`=`r`.`rewardId` WHERE ( r.dataFlag=1 and goodsId=119 and startDate<="2023-12-01" and endDate>="2023-12-01" ) [ RunTime:0.000178s ]
SELECT COUNT(*) AS think_count FROM `wst_rewards` WHERE ( dataFlag=1 and useObjects=0 and startDate<="2023-12-01" and endDate>="2023-12-01" ) [ RunTime:0.000164s ]
SELECT COUNT(*) AS think_count FROM `wst_reward_goods` `rg` INNER JOIN `wst_rewards` `r` ON `rg`.`rewardId`=`r`.`rewardId` WHERE ( r.dataFlag=1 and goodsId=123 and startDate<="2023-12-01" and endDate>="2023-12-01" ) [ RunTime:0.000183s ]
SELECT COUNT(*) AS think_count FROM `wst_rewards` WHERE ( dataFlag=1 and useObjects=0 and startDate<="2023-12-01" and endDate>="2023-12-01" ) [ RunTime:0.000156s ]
SELECT COUNT(*) AS think_count FROM `wst_reward_goods` `rg` INNER JOIN `wst_rewards` `r` ON `rg`.`rewardId`=`r`.`rewardId` WHERE ( r.dataFlag=1 and goodsId=132 and startDate<="2023-12-01" and endDate>="2023-12-01" ) [ RunTime:0.000190s ]
SELECT COUNT(*) AS think_count FROM `wst_rewards` WHERE ( dataFlag=1 and useObjects=0 and startDate<="2023-12-01" and endDate>="2023-12-01" ) [ RunTime:0.000157s ]
SELECT COUNT(*) AS think_count FROM `wst_coupon_goods` `cg` INNER JOIN `wst_coupons` `c` ON `cg`.`couponId`=`c`.`couponId` WHERE `endDate` >= '2023-12-01' AND `goodsId` = 102 AND `dataFlag` = 1 [ RunTime:0.000191s ]
SELECT COUNT(*) AS think_count FROM `wst_coupons` WHERE ( couponType=2 and dataFlag=1 and useObjects=0 and startDate<="2023-12-01" and endDate>="2023-12-01" ) [ RunTime:0.000193s ]
SELECT COUNT(*) AS think_count FROM `wst_coupon_goods` `cg` INNER JOIN `wst_coupons` `c` ON `cg`.`couponId`=`c`.`couponId` WHERE `endDate` >= '2023-12-01' AND `goodsId` = 103 AND `dataFlag` = 1 [ RunTime:0.000191s ]
SELECT COUNT(*) AS think_count FROM `wst_coupons` WHERE ( couponType=2 and dataFlag=1 and useObjects=0 and startDate<="2023-12-01" and endDate>="2023-12-01" ) [ RunTime:0.000173s ]
SELECT COUNT(*) AS think_count FROM `wst_coupon_goods` `cg` INNER JOIN `wst_coupons` `c` ON `cg`.`couponId`=`c`.`couponId` WHERE `endDate` >= '2023-12-01' AND `goodsId` = 115 AND `dataFlag` = 1 [ RunTime:0.000176s ]
SELECT COUNT(*) AS think_count FROM `wst_coupons` WHERE ( couponType=2 and dataFlag=1 and useObjects=0 and startDate<="2023-12-01" and endDate>="2023-12-01" ) [ RunTime:0.000182s ]
SELECT COUNT(*) AS think_count FROM `wst_coupon_goods` `cg` INNER JOIN `wst_coupons` `c` ON `cg`.`couponId`=`c`.`couponId` WHERE `endDate` >= '2023-12-01' AND `goodsId` = 117 AND `dataFlag` = 1 [ RunTime:0.000181s ]
SELECT COUNT(*) AS think_count FROM `wst_coupons` WHERE ( couponType=2 and dataFlag=1 and useObjects=0 and startDate<="2023-12-01" and endDate>="2023-12-01" ) [ RunTime:0.000226s ]
SELECT COUNT(*) AS think_count FROM `wst_coupon_goods` `cg` INNER JOIN `wst_coupons` `c` ON `cg`.`couponId`=`c`.`couponId` WHERE `endDate` >= '2023-12-01' AND `goodsId` = 118 AND `dataFlag` = 1 [ RunTime:0.000202s ]
SELECT COUNT(*) AS think_count FROM `wst_coupons` WHERE ( couponType=2 and dataFlag=1 and useObjects=0 and startDate<="2023-12-01" and endDate>="2023-12-01" ) [ RunTime:0.000206s ]
SELECT COUNT(*) AS think_count FROM `wst_coupon_goods` `cg` INNER JOIN `wst_coupons` `c` ON `cg`.`couponId`=`c`.`couponId` WHERE `endDate` >= '2023-12-01' AND `goodsId` = 119 AND `dataFlag` = 1 [ RunTime:0.000177s ]
SELECT COUNT(*) AS think_count FROM `wst_coupons` WHERE ( couponType=2 and dataFlag=1 and useObjects=0 and startDate<="2023-12-01" and endDate>="2023-12-01" ) [ RunTime:0.000204s ]
SELECT COUNT(*) AS think_count FROM `wst_coupon_goods` `cg` INNER JOIN `wst_coupons` `c` ON `cg`.`couponId`=`c`.`couponId` WHERE `endDate` >= '2023-12-01' AND `goodsId` = 123 AND `dataFlag` = 1 [ RunTime:0.000183s ]
SELECT COUNT(*) AS think_count FROM `wst_coupons` WHERE ( couponType=2 and dataFlag=1 and useObjects=0 and startDate<="2023-12-01" and endDate>="2023-12-01" ) [ RunTime:0.000174s ]
SELECT COUNT(*) AS think_count FROM `wst_coupon_goods` `cg` INNER JOIN `wst_coupons` `c` ON `cg`.`couponId`=`c`.`couponId` WHERE `endDate` >= '2023-12-01' AND `goodsId` = 132 AND `dataFlag` = 1 [ RunTime:0.000184s ]
SELECT COUNT(*) AS think_count FROM `wst_coupons` WHERE ( couponType=2 and dataFlag=1 and useObjects=0 and startDate<="2023-12-01" and endDate>="2023-12-01" ) [ RunTime:0.000176s ]
SELECT `goodsId`,`isPifa`,`goodsPrice` FROM `wst_goods` WHERE `goodsId` = 102 LIMIT 1 [ RunTime:0.000154s ]
SELECT `goodsId`,`isPifa`,`goodsPrice` FROM `wst_goods` WHERE `goodsId` = 103 LIMIT 1 [ RunTime:0.000134s ]
SELECT `goodsId`,`isPifa`,`goodsPrice` FROM `wst_goods` WHERE `goodsId` = 115 LIMIT 1 [ RunTime:0.000135s ]
SELECT `goodsId`,`isPifa`,`goodsPrice` FROM `wst_goods` WHERE `goodsId` = 117 LIMIT 1 [ RunTime:0.000139s ]
SELECT `goodsId`,`isPifa`,`goodsPrice` FROM `wst_goods` WHERE `goodsId` = 118 LIMIT 1 [ RunTime:0.000129s ]
SELECT `goodsId`,`isPifa`,`goodsPrice` FROM `wst_goods` WHERE `goodsId` = 119 LIMIT 1 [ RunTime:0.000154s ]
SELECT `goodsId`,`isPifa`,`goodsPrice` FROM `wst_goods` WHERE `goodsId` = 123 LIMIT 1 [ RunTime:0.000173s ]
SELECT `goodsId`,`isPifa`,`goodsPrice` FROM `wst_goods` WHERE `goodsId` = 132 LIMIT 1 [ RunTime:0.000157s ]
SELECT * FROM `wst_presales` WHERE `startTime` <= '2023-12-01 07:58:35' AND `endTime` >= '2023-12-01 07:58:35' AND `dataFlag` = 1 AND `isSale` = 1 AND `goodsId` = 102 LIMIT 1 [ RunTime:0.000233s ]
SELECT * FROM `wst_presales` WHERE `startTime` <= '2023-12-01 07:58:35' AND `endTime` >= '2023-12-01 07:58:35' AND `dataFlag` = 1 AND `isSale` = 1 AND `goodsId` = 103 LIMIT 1 [ RunTime:0.000249s ]
SELECT * FROM `wst_presales` WHERE `startTime` <= '2023-12-01 07:58:35' AND `endTime` >= '2023-12-01 07:58:35' AND `dataFlag` = 1 AND `isSale` = 1 AND `goodsId` = 115 LIMIT 1 [ RunTime:0.000218s ]
SELECT * FROM `wst_presales` WHERE `startTime` <= '2023-12-01 07:58:35' AND `endTime` >= '2023-12-01 07:58:35' AND `dataFlag` = 1 AND `isSale` = 1 AND `goodsId` = 117 LIMIT 1 [ RunTime:0.000204s ]
SELECT * FROM `wst_presales` WHERE `startTime` <= '2023-12-01 07:58:35' AND `endTime` >= '2023-12-01 07:58:35' AND `dataFlag` = 1 AND `isSale` = 1 AND `goodsId` = 118 LIMIT 1 [ RunTime:0.000198s ]
SELECT * FROM `wst_presales` WHERE `startTime` <= '2023-12-01 07:58:35' AND `endTime` >= '2023-12-01 07:58:35' AND `dataFlag` = 1 AND `isSale` = 1 AND `goodsId` = 119 LIMIT 1 [ RunTime:0.000199s ]
SELECT * FROM `wst_presales` WHERE `startTime` <= '2023-12-01 07:58:35' AND `endTime` >= '2023-12-01 07:58:35' AND `dataFlag` = 1 AND `isSale` = 1 AND `goodsId` = 123 LIMIT 1 [ RunTime:0.000199s ]
SELECT * FROM `wst_presales` WHERE `startTime` <= '2023-12-01 07:58:35' AND `endTime` >= '2023-12-01 07:58:35' AND `dataFlag` = 1 AND `isSale` = 1 AND `goodsId` = 132 LIMIT 1 [ RunTime:0.000198s ]
SELECT `areaIdPath` FROM `wst_sellers` WHERE `sellerId` = 0 LIMIT 1 [ RunTime:0.000154s ]
SELECT `parentId` FROM `wst_goods_cats` WHERE `catId` = 59 LIMIT 1 [ RunTime:0.000148s ]
SELECT `parentId` FROM `wst_goods_cats` WHERE `catId` = 57 LIMIT 1 [ RunTime:0.000132s ]
SELECT gs.id goodsSpecId,`g`.`goodsId`,`g`.`goodsCatId`,`g`.`goodsImg`,`g`.`goodsUnit`,`g`.`goodsTips`,`g`.`goodsName`,`g`.`goodsPrice`,g.goodsPrice defaultGoodsPrice,`g`.`goodsStock`,`g`.`saleNum`,`g`.`isSpec`,`g`.`goodsSn`,`gs`.`specStock`,`gs`.`specIds`,g.goodsPrice as platformPrice,`g`.`marketPrice`,`g`.`minOrder` FROM `wst_goods` `g` LEFT JOIN `wst_goods_specs` `gs` ON `g`.`goodsId`=gs.goodsId and gs.isDefault=1 WHERE `g`.`dataFlag` = 1 AND `g`.`isReCom` = 1 AND `g`.`goodsCatIdPath` LIKE '57_59_%' AND `g`.`isSale` = 1 LIMIT 10 [ RunTime:0.000438s ]
SELECT COUNT(*) AS think_count FROM `wst_reward_goods` `rg` INNER JOIN `wst_rewards` `r` ON `rg`.`rewardId`=`r`.`rewardId` WHERE ( r.dataFlag=1 and goodsId=102 and startDate<="2023-12-01" and endDate>="2023-12-01" ) [ RunTime:0.000223s ]
SELECT COUNT(*) AS think_count FROM `wst_rewards` WHERE ( dataFlag=1 and useObjects=0 and startDate<="2023-12-01" and endDate>="2023-12-01" ) [ RunTime:0.000163s ]
SELECT COUNT(*) AS think_count FROM `wst_reward_goods` `rg` INNER JOIN `wst_rewards` `r` ON `rg`.`rewardId`=`r`.`rewardId` WHERE ( r.dataFlag=1 and goodsId=115 and startDate<="2023-12-01" and endDate>="2023-12-01" ) [ RunTime:0.000183s ]
SELECT COUNT(*) AS think_count FROM `wst_rewards` WHERE ( dataFlag=1 and useObjects=0 and startDate<="2023-12-01" and endDate>="2023-12-01" ) [ RunTime:0.000167s ]
SELECT COUNT(*) AS think_count FROM `wst_reward_goods` `rg` INNER JOIN `wst_rewards` `r` ON `rg`.`rewardId`=`r`.`rewardId` WHERE ( r.dataFlag=1 and goodsId=117 and startDate<="2023-12-01" and endDate>="2023-12-01" ) [ RunTime:0.000184s ]
SELECT COUNT(*) AS think_count FROM `wst_rewards` WHERE ( dataFlag=1 and useObjects=0 and startDate<="2023-12-01" and endDate>="2023-12-01" ) [ RunTime:0.000154s ]
SELECT COUNT(*) AS think_count FROM `wst_reward_goods` `rg` INNER JOIN `wst_rewards` `r` ON `rg`.`rewardId`=`r`.`rewardId` WHERE ( r.dataFlag=1 and goodsId=118 and startDate<="2023-12-01" and endDate>="2023-12-01" ) [ RunTime:0.000171s ]
SELECT COUNT(*) AS think_count FROM `wst_rewards` WHERE ( dataFlag=1 and useObjects=0 and startDate<="2023-12-01" and endDate>="2023-12-01" ) [ RunTime:0.000150s ]
SELECT COUNT(*) AS think_count FROM `wst_reward_goods` `rg` INNER JOIN `wst_rewards` `r` ON `rg`.`rewardId`=`r`.`rewardId` WHERE ( r.dataFlag=1 and goodsId=119 and startDate<="2023-12-01" and endDate>="2023-12-01" ) [ RunTime:0.000171s ]
SELECT COUNT(*) AS think_count FROM `wst_rewards` WHERE ( dataFlag=1 and useObjects=0 and startDate<="2023-12-01" and endDate>="2023-12-01" ) [ RunTime:0.000162s ]
SELECT COUNT(*) AS think_count FROM `wst_coupon_goods` `cg` INNER JOIN `wst_coupons` `c` ON `cg`.`couponId`=`c`.`couponId` WHERE `endDate` >= '2023-12-01' AND `goodsId` = 102 AND `dataFlag` = 1 [ RunTime:0.000176s ]
SELECT COUNT(*) AS think_count FROM `wst_coupons` WHERE ( couponType=2 and dataFlag=1 and useObjects=0 and startDate<="2023-12-01" and endDate>="2023-12-01" ) [ RunTime:0.000178s ]
SELECT COUNT(*) AS think_count FROM `wst_coupon_goods` `cg` INNER JOIN `wst_coupons` `c` ON `cg`.`couponId`=`c`.`couponId` WHERE `endDate` >= '2023-12-01' AND `goodsId` = 115 AND `dataFlag` = 1 [ RunTime:0.000172s ]
SELECT COUNT(*) AS think_count FROM `wst_coupons` WHERE ( couponType=2 and dataFlag=1 and useObjects=0 and startDate<="2023-12-01" and endDate>="2023-12-01" ) [ RunTime:0.000197s ]
SELECT COUNT(*) AS think_count FROM `wst_coupon_goods` `cg` INNER JOIN `wst_coupons` `c` ON `cg`.`couponId`=`c`.`couponId` WHERE `endDate` >= '2023-12-01' AND `goodsId` = 117 AND `dataFlag` = 1 [ RunTime:0.000194s ]
SELECT COUNT(*) AS think_count FROM `wst_coupons` WHERE ( couponType=2 and dataFlag=1 and useObjects=0 and startDate<="2023-12-01" and endDate>="2023-12-01" ) [ RunTime:0.000184s ]
SELECT COUNT(*) AS think_count FROM `wst_coupon_goods` `cg` INNER JOIN `wst_coupons` `c` ON `cg`.`couponId`=`c`.`couponId` WHERE `endDate` >= '2023-12-01' AND `goodsId` = 118 AND `dataFlag` = 1 [ RunTime:0.000204s ]
SELECT COUNT(*) AS think_count FROM `wst_coupons` WHERE ( couponType=2 and dataFlag=1 and useObjects=0 and startDate<="2023-12-01" and endDate>="2023-12-01" ) [ RunTime:0.000175s ]
SELECT COUNT(*) AS think_count FROM `wst_coupon_goods` `cg` INNER JOIN `wst_coupons` `c` ON `cg`.`couponId`=`c`.`couponId` WHERE `endDate` >= '2023-12-01' AND `goodsId` = 119 AND `dataFlag` = 1 [ RunTime:0.000172s ]
SELECT COUNT(*) AS think_count FROM `wst_coupons` WHERE ( couponType=2 and dataFlag=1 and useObjects=0 and startDate<="2023-12-01" and endDate>="2023-12-01" ) [ RunTime:0.000178s ]
SELECT `goodsId`,`isPifa`,`goodsPrice` FROM `wst_goods` WHERE `goodsId` = 102 LIMIT 1 [ RunTime:0.000161s ]
SELECT `goodsId`,`isPifa`,`goodsPrice` FROM `wst_goods` WHERE `goodsId` = 115 LIMIT 1 [ RunTime:0.000139s ]
SELECT `goodsId`,`isPifa`,`goodsPrice` FROM `wst_goods` WHERE `goodsId` = 117 LIMIT 1 [ RunTime:0.000125s ]
SELECT `goodsId`,`isPifa`,`goodsPrice` FROM `wst_goods` WHERE `goodsId` = 118 LIMIT 1 [ RunTime:0.000144s ]
SELECT `goodsId`,`isPifa`,`goodsPrice` FROM `wst_goods` WHERE `goodsId` = 119 LIMIT 1 [ RunTime:0.000135s ]
SELECT * FROM `wst_presales` WHERE `startTime` <= '2023-12-01 07:58:35' AND `endTime` >= '2023-12-01 07:58:35' AND `dataFlag` = 1 AND `isSale` = 1 AND `goodsId` = 102 LIMIT 1 [ RunTime:0.000215s ]
SELECT * FROM `wst_presales` WHERE `startTime` <= '2023-12-01 07:58:35' AND `endTime` >= '2023-12-01 07:58:35' AND `dataFlag` = 1 AND `isSale` = 1 AND `goodsId` = 115 LIMIT 1 [ RunTime:0.000209s ]
SELECT * FROM `wst_presales` WHERE `startTime` <= '2023-12-01 07:58:35' AND `endTime` >= '2023-12-01 07:58:35' AND `dataFlag` = 1 AND `isSale` = 1 AND `goodsId` = 117 LIMIT 1 [ RunTime:0.000212s ]
SELECT * FROM `wst_presales` WHERE `startTime` <= '2023-12-01 07:58:35' AND `endTime` >= '2023-12-01 07:58:35' AND `dataFlag` = 1 AND `isSale` = 1 AND `goodsId` = 118 LIMIT 1 [ RunTime:0.000205s ]
SELECT * FROM `wst_presales` WHERE `startTime` <= '2023-12-01 07:58:35' AND `endTime` >= '2023-12-01 07:58:35' AND `dataFlag` = 1 AND `isSale` = 1 AND `goodsId` = 119 LIMIT 1 [ RunTime:0.000197s ]
SELECT `areaIdPath` FROM `wst_sellers` WHERE `sellerId` = 0 LIMIT 1 [ RunTime:0.000151s ]
SELECT `parentId` FROM `wst_goods_cats` WHERE `catId` = 60 LIMIT 1 [ RunTime:0.000126s ]
SELECT `parentId` FROM `wst_goods_cats` WHERE `catId` = 57 LIMIT 1 [ RunTime:0.000116s ]
SELECT gs.id goodsSpecId,`g`.`goodsId`,`g`.`goodsCatId`,`g`.`goodsImg`,`g`.`goodsUnit`,`g`.`goodsTips`,`g`.`goodsName`,`g`.`goodsPrice`,g.goodsPrice defaultGoodsPrice,`g`.`goodsStock`,`g`.`saleNum`,`g`.`isSpec`,`g`.`goodsSn`,`gs`.`specStock`,`gs`.`specIds`,g.goodsPrice as platformPrice,`g`.`marketPrice`,`g`.`minOrder` FROM `wst_goods` `g` LEFT JOIN `wst_goods_specs` `gs` ON `g`.`goodsId`=gs.goodsId and gs.isDefault=1 WHERE `g`.`dataFlag` = 1 AND `g`.`isReCom` = 1 AND `g`.`goodsCatIdPath` LIKE '57_60_%' AND `g`.`isSale` = 1 LIMIT 10 [ RunTime:0.000459s ]
SELECT COUNT(*) AS think_count FROM `wst_reward_goods` `rg` INNER JOIN `wst_rewards` `r` ON `rg`.`rewardId`=`r`.`rewardId` WHERE ( r.dataFlag=1 and goodsId=103 and startDate<="2023-12-01" and endDate>="2023-12-01" ) [ RunTime:0.000237s ]
SELECT COUNT(*) AS think_count FROM `wst_rewards` WHERE ( dataFlag=1 and useObjects=0 and startDate<="2023-12-01" and endDate>="2023-12-01" ) [ RunTime:0.000182s ]
SELECT COUNT(*) AS think_count FROM `wst_reward_goods` `rg` INNER JOIN `wst_rewards` `r` ON `rg`.`rewardId`=`r`.`rewardId` WHERE ( r.dataFlag=1 and goodsId=123 and startDate<="2023-12-01" and endDate>="2023-12-01" ) [ RunTime:0.000207s ]
SELECT COUNT(*) AS think_count FROM `wst_rewards` WHERE ( dataFlag=1 and useObjects=0 and startDate<="2023-12-01" and endDate>="2023-12-01" ) [ RunTime:0.000161s ]
SELECT COUNT(*) AS think_count FROM `wst_reward_goods` `rg` INNER JOIN `wst_rewards` `r` ON `rg`.`rewardId`=`r`.`rewardId` WHERE ( r.dataFlag=1 and goodsId=132 and startDate<="2023-12-01" and endDate>="2023-12-01" ) [ RunTime:0.000191s ]
SELECT COUNT(*) AS think_count FROM `wst_rewards` WHERE ( dataFlag=1 and useObjects=0 and startDate<="2023-12-01" and endDate>="2023-12-01" ) [ RunTime:0.000161s ]
SELECT COUNT(*) AS think_count FROM `wst_reward_goods` `rg` INNER JOIN `wst_rewards` `r` ON `rg`.`rewardId`=`r`.`rewardId` WHERE ( r.dataFlag=1 and goodsId=133 and startDate<="2023-12-01" and endDate>="2023-12-01" ) [ RunTime:0.000177s ]
SELECT COUNT(*) AS think_count FROM `wst_rewards` WHERE ( dataFlag=1 and useObjects=0 and startDate<="2023-12-01" and endDate>="2023-12-01" ) [ RunTime:0.000150s ]
SELECT COUNT(*) AS think_count FROM `wst_reward_goods` `rg` INNER JOIN `wst_rewards` `r` ON `rg`.`rewardId`=`r`.`rewardId` WHERE ( r.dataFlag=1 and goodsId=134 and startDate<="2023-12-01" and endDate>="2023-12-01" ) [ RunTime:0.000180s ]
SELECT COUNT(*) AS think_count FROM `wst_rewards` WHERE ( dataFlag=1 and useObjects=0 and startDate<="2023-12-01" and endDate>="2023-12-01" ) [ RunTime:0.000150s ]
SELECT COUNT(*) AS think_count FROM `wst_coupon_goods` `cg` INNER JOIN `wst_coupons` `c` ON `cg`.`couponId`=`c`.`couponId` WHERE `endDate` >= '2023-12-01' AND `goodsId` = 103 AND `dataFlag` = 1 [ RunTime:0.000177s ]
SELECT COUNT(*) AS think_count FROM `wst_coupons` WHERE ( couponType=2 and dataFlag=1 and useObjects=0 and startDate<="2023-12-01" and endDate>="2023-12-01" ) [ RunTime:0.000167s ]
SELECT COUNT(*) AS think_count FROM `wst_coupon_goods` `cg` INNER JOIN `wst_coupons` `c` ON `cg`.`couponId`=`c`.`couponId` WHERE `endDate` >= '2023-12-01' AND `goodsId` = 123 AND `dataFlag` = 1 [ RunTime:0.000181s ]
SELECT COUNT(*) AS think_count FROM `wst_coupons` WHERE ( couponType=2 and dataFlag=1 and useObjects=0 and startDate<="2023-12-01" and endDate>="2023-12-01" ) [ RunTime:0.000175s ]
SELECT COUNT(*) AS think_count FROM `wst_coupon_goods` `cg` INNER JOIN `wst_coupons` `c` ON `cg`.`couponId`=`c`.`couponId` WHERE `endDate` >= '2023-12-01' AND `goodsId` = 132 AND `dataFlag` = 1 [ RunTime:0.000170s ]
SELECT COUNT(*) AS think_count FROM `wst_coupons` WHERE ( couponType=2 and dataFlag=1 and useObjects=0 and startDate<="2023-12-01" and endDate>="2023-12-01" ) [ RunTime:0.000168s ]
SELECT COUNT(*) AS think_count FROM `wst_coupon_goods` `cg` INNER JOIN `wst_coupons` `c` ON `cg`.`couponId`=`c`.`couponId` WHERE `endDate` >= '2023-12-01' AND `goodsId` = 133 AND `dataFlag` = 1 [ RunTime:0.000182s ]
SELECT COUNT(*) AS think_count FROM `wst_coupons` WHERE ( couponType=2 and dataFlag=1 and useObjects=0 and startDate<="2023-12-01" and endDate>="2023-12-01" ) [ RunTime:0.000177s ]
SELECT COUNT(*) AS think_count FROM `wst_coupon_goods` `cg` INNER JOIN `wst_coupons` `c` ON `cg`.`couponId`=`c`.`couponId` WHERE `endDate` >= '2023-12-01' AND `goodsId` = 134 AND `dataFlag` = 1 [ RunTime:0.000168s ]
SELECT COUNT(*) AS think_count FROM `wst_coupons` WHERE ( couponType=2 and dataFlag=1 and useObjects=0 and startDate<="2023-12-01" and endDate>="2023-12-01" ) [ RunTime:0.000160s ]
SELECT `goodsId`,`isPifa`,`goodsPrice` FROM `wst_goods` WHERE `goodsId` = 103 LIMIT 1 [ RunTime:0.000152s ]
SELECT `goodsId`,`isPifa`,`goodsPrice` FROM `wst_goods` WHERE `goodsId` = 123 LIMIT 1 [ RunTime:0.000142s ]
SELECT `goodsId`,`isPifa`,`goodsPrice` FROM `wst_goods` WHERE `goodsId` = 132 LIMIT 1 [ RunTime:0.000129s ]
SELECT `goodsId`,`isPifa`,`goodsPrice` FROM `wst_goods` WHERE `goodsId` = 133 LIMIT 1 [ RunTime:0.000127s ]
SELECT `goodsId`,`isPifa`,`goodsPrice` FROM `wst_goods` WHERE `goodsId` = 134 LIMIT 1 [ RunTime:0.000123s ]
SELECT * FROM `wst_presales` WHERE `startTime` <= '2023-12-01 07:58:35' AND `endTime` >= '2023-12-01 07:58:35' AND `dataFlag` = 1 AND `isSale` = 1 AND `goodsId` = 103 LIMIT 1 [ RunTime:0.000249s ]
SELECT * FROM `wst_presales` WHERE `startTime` <= '2023-12-01 07:58:35' AND `endTime` >= '2023-12-01 07:58:35' AND `dataFlag` = 1 AND `isSale` = 1 AND `goodsId` = 123 LIMIT 1 [ RunTime:0.000216s ]
SELECT * FROM `wst_presales` WHERE `startTime` <= '2023-12-01 07:58:35' AND `endTime` >= '2023-12-01 07:58:35' AND `dataFlag` = 1 AND `isSale` = 1 AND `goodsId` = 132 LIMIT 1 [ RunTime:0.000199s ]
SELECT * FROM `wst_presales` WHERE `startTime` <= '2023-12-01 07:58:35' AND `endTime` >= '2023-12-01 07:58:35' AND `dataFlag` = 1 AND `isSale` = 1 AND `goodsId` = 133 LIMIT 1 [ RunTime:0.000202s ]
SELECT * FROM `wst_presales` WHERE `startTime` <= '2023-12-01 07:58:35' AND `endTime` >= '2023-12-01 07:58:35' AND `dataFlag` = 1 AND `isSale` = 1 AND `goodsId` = 134 LIMIT 1 [ RunTime:0.000198s ]
SELECT `adId`,`adName`,`adURL`,`adFile`,`positionWidth`,`positionHeight` FROM `wst_ads` `a` LEFT JOIN `wst_ad_positions` `ap` ON `a`.`adPositionId`=ap.positionId and ap.dataFlag=1 WHERE ( a.dataFlag=1 and ap.positionCode='ads-2-1' and adStartDate<= '2023-12-01' and adEndDate>='2023-12-01' and a.sellerId=0 and a.adSrc=1 ) ORDER BY `adSort` ASC LIMIT 1 [ RunTime:0.000286s ]
SELECT `areaIdPath` FROM `wst_sellers` WHERE `sellerId` = 0 LIMIT 1 [ RunTime:0.000162s ]
SELECT `parentId` FROM `wst_goods_cats` WHERE `catId` = 67 LIMIT 1 [ RunTime:0.000129s ]
SELECT gs.id goodsSpecId,`g`.`goodsId`,`g`.`goodsCatId`,`g`.`goodsImg`,`g`.`goodsUnit`,`g`.`goodsTips`,`g`.`goodsName`,`g`.`goodsPrice`,g.goodsPrice defaultGoodsPrice,`g`.`goodsStock`,`g`.`saleNum`,`g`.`isSpec`,`g`.`goodsSn`,`gs`.`specStock`,`gs`.`specIds`,g.goodsPrice as platformPrice,`g`.`marketPrice`,`g`.`minOrder` FROM `wst_goods` `g` LEFT JOIN `wst_goods_specs` `gs` ON `g`.`goodsId`=gs.goodsId and gs.isDefault=1 WHERE `g`.`dataFlag` = 1 AND `g`.`isReCom` = 1 AND `g`.`goodsCatIdPath` LIKE '67_%' AND `g`.`isSale` = 1 LIMIT 8 [ RunTime:0.000365s ]
SELECT COUNT(*) AS think_count FROM `wst_reward_goods` `rg` INNER JOIN `wst_rewards` `r` ON `rg`.`rewardId`=`r`.`rewardId` WHERE ( r.dataFlag=1 and goodsId=106 and startDate<="2023-12-01" and endDate>="2023-12-01" ) [ RunTime:0.000206s ]
SELECT COUNT(*) AS think_count FROM `wst_rewards` WHERE ( dataFlag=1 and useObjects=0 and startDate<="2023-12-01" and endDate>="2023-12-01" ) [ RunTime:0.000159s ]
SELECT COUNT(*) AS think_count FROM `wst_reward_goods` `rg` INNER JOIN `wst_rewards` `r` ON `rg`.`rewardId`=`r`.`rewardId` WHERE ( r.dataFlag=1 and goodsId=141 and startDate<="2023-12-01" and endDate>="2023-12-01" ) [ RunTime:0.000187s ]
SELECT COUNT(*) AS think_count FROM `wst_rewards` WHERE ( dataFlag=1 and useObjects=0 and startDate<="2023-12-01" and endDate>="2023-12-01" ) [ RunTime:0.000161s ]
SELECT COUNT(*) AS think_count FROM `wst_reward_goods` `rg` INNER JOIN `wst_rewards` `r` ON `rg`.`rewardId`=`r`.`rewardId` WHERE ( r.dataFlag=1 and goodsId=142 and startDate<="2023-12-01" and endDate>="2023-12-01" ) [ RunTime:0.000173s ]
SELECT COUNT(*) AS think_count FROM `wst_rewards` WHERE ( dataFlag=1 and useObjects=0 and startDate<="2023-12-01" and endDate>="2023-12-01" ) [ RunTime:0.000149s ]
SELECT COUNT(*) AS think_count FROM `wst_reward_goods` `rg` INNER JOIN `wst_rewards` `r` ON `rg`.`rewardId`=`r`.`rewardId` WHERE ( r.dataFlag=1 and goodsId=143 and startDate<="2023-12-01" and endDate>="2023-12-01" ) [ RunTime:0.000187s ]
SELECT COUNT(*) AS think_count FROM `wst_rewards` WHERE ( dataFlag=1 and useObjects=0 and startDate<="2023-12-01" and endDate>="2023-12-01" ) [ RunTime:0.000182s ]
SELECT COUNT(*) AS think_count FROM `wst_reward_goods` `rg` INNER JOIN `wst_rewards` `r` ON `rg`.`rewardId`=`r`.`rewardId` WHERE ( r.dataFlag=1 and goodsId=150 and startDate<="2023-12-01" and endDate>="2023-12-01" ) [ RunTime:0.000176s ]
SELECT COUNT(*) AS think_count FROM `wst_rewards` WHERE ( dataFlag=1 and useObjects=0 and startDate<="2023-12-01" and endDate>="2023-12-01" ) [ RunTime:0.000149s ]
SELECT COUNT(*) AS think_count FROM `wst_reward_goods` `rg` INNER JOIN `wst_rewards` `r` ON `rg`.`rewardId`=`r`.`rewardId` WHERE ( r.dataFlag=1 and goodsId=151 and startDate<="2023-12-01" and endDate>="2023-12-01" ) [ RunTime:0.000187s ]
SELECT COUNT(*) AS think_count FROM `wst_rewards` WHERE ( dataFlag=1 and useObjects=0 and startDate<="2023-12-01" and endDate>="2023-12-01" ) [ RunTime:0.000154s ]
SELECT COUNT(*) AS think_count FROM `wst_reward_goods` `rg` INNER JOIN `wst_rewards` `r` ON `rg`.`rewardId`=`r`.`rewardId` WHERE ( r.dataFlag=1 and goodsId=152 and startDate<="2023-12-01" and endDate>="2023-12-01" ) [ RunTime:0.000179s ]
SELECT COUNT(*) AS think_count FROM `wst_rewards` WHERE ( dataFlag=1 and useObjects=0 and startDate<="2023-12-01" and endDate>="2023-12-01" ) [ RunTime:0.000149s ]
SELECT COUNT(*) AS think_count FROM `wst_reward_goods` `rg` INNER JOIN `wst_rewards` `r` ON `rg`.`rewardId`=`r`.`rewardId` WHERE ( r.dataFlag=1 and goodsId=153 and startDate<="2023-12-01" and endDate>="2023-12-01" ) [ RunTime:0.000169s ]
SELECT COUNT(*) AS think_count FROM `wst_rewards` WHERE ( dataFlag=1 and useObjects=0 and startDate<="2023-12-01" and endDate>="2023-12-01" ) [ RunTime:0.000151s ]
SELECT COUNT(*) AS think_count FROM `wst_coupon_goods` `cg` INNER JOIN `wst_coupons` `c` ON `cg`.`couponId`=`c`.`couponId` WHERE `endDate` >= '2023-12-01' AND `goodsId` = 106 AND `dataFlag` = 1 [ RunTime:0.000176s ]
SELECT COUNT(*) AS think_count FROM `wst_coupons` WHERE ( couponType=2 and dataFlag=1 and useObjects=0 and startDate<="2023-12-01" and endDate>="2023-12-01" ) [ RunTime:0.000166s ]
SELECT COUNT(*) AS think_count FROM `wst_coupon_goods` `cg` INNER JOIN `wst_coupons` `c` ON `cg`.`couponId`=`c`.`couponId` WHERE `endDate` >= '2023-12-01' AND `goodsId` = 141 AND `dataFlag` = 1 [ RunTime:0.000169s ]
SELECT COUNT(*) AS think_count FROM `wst_coupons` WHERE ( couponType=2 and dataFlag=1 and useObjects=0 and startDate<="2023-12-01" and endDate>="2023-12-01" ) [ RunTime:0.000165s ]
SELECT COUNT(*) AS think_count FROM `wst_coupon_goods` `cg` INNER JOIN `wst_coupons` `c` ON `cg`.`couponId`=`c`.`couponId` WHERE `endDate` >= '2023-12-01' AND `goodsId` = 142 AND `dataFlag` = 1 [ RunTime:0.000179s ]
SELECT COUNT(*) AS think_count FROM `wst_coupons` WHERE ( couponType=2 and dataFlag=1 and useObjects=0 and startDate<="2023-12-01" and endDate>="2023-12-01" ) [ RunTime:0.000162s ]
SELECT COUNT(*) AS think_count FROM `wst_coupon_goods` `cg` INNER JOIN `wst_coupons` `c` ON `cg`.`couponId`=`c`.`couponId` WHERE `endDate` >= '2023-12-01' AND `goodsId` = 143 AND `dataFlag` = 1 [ RunTime:0.000167s ]
SELECT COUNT(*) AS think_count FROM `wst_coupons` WHERE ( couponType=2 and dataFlag=1 and useObjects=0 and startDate<="2023-12-01" and endDate>="2023-12-01" ) [ RunTime:0.000169s ]
SELECT COUNT(*) AS think_count FROM `wst_coupon_goods` `cg` INNER JOIN `wst_coupons` `c` ON `cg`.`couponId`=`c`.`couponId` WHERE `endDate` >= '2023-12-01' AND `goodsId` = 150 AND `dataFlag` = 1 [ RunTime:0.000208s ]
SELECT COUNT(*) AS think_count FROM `wst_coupons` WHERE ( couponType=2 and dataFlag=1 and useObjects=0 and startDate<="2023-12-01" and endDate>="2023-12-01" ) [ RunTime:0.000169s ]
SELECT COUNT(*) AS think_count FROM `wst_coupon_goods` `cg` INNER JOIN `wst_coupons` `c` ON `cg`.`couponId`=`c`.`couponId` WHERE `endDate` >= '2023-12-01' AND `goodsId` = 151 AND `dataFlag` = 1 [ RunTime:0.000179s ]
SELECT COUNT(*) AS think_count FROM `wst_coupons` WHERE ( couponType=2 and dataFlag=1 and useObjects=0 and startDate<="2023-12-01" and endDate>="2023-12-01" ) [ RunTime:0.000166s ]
SELECT COUNT(*) AS think_count FROM `wst_coupon_goods` `cg` INNER JOIN `wst_coupons` `c` ON `cg`.`couponId`=`c`.`couponId` WHERE `endDate` >= '2023-12-01' AND `goodsId` = 152 AND `dataFlag` = 1 [ RunTime:0.000170s ]
SELECT COUNT(*) AS think_count FROM `wst_coupons` WHERE ( couponType=2 and dataFlag=1 and useObjects=0 and startDate<="2023-12-01" and endDate>="2023-12-01" ) [ RunTime:0.000161s ]
SELECT COUNT(*) AS think_count FROM `wst_coupon_goods` `cg` INNER JOIN `wst_coupons` `c` ON `cg`.`couponId`=`c`.`couponId` WHERE `endDate` >= '2023-12-01' AND `goodsId` = 153 AND `dataFlag` = 1 [ RunTime:0.000167s ]
SELECT COUNT(*) AS think_count FROM `wst_coupons` WHERE ( couponType=2 and dataFlag=1 and useObjects=0 and startDate<="2023-12-01" and endDate>="2023-12-01" ) [ RunTime:0.000162s ]
SELECT `goodsId`,`isPifa`,`goodsPrice` FROM `wst_goods` WHERE `goodsId` = 106 LIMIT 1 [ RunTime:0.000149s ]
SELECT `goodsId`,`isPifa`,`goodsPrice` FROM `wst_goods` WHERE `goodsId` = 141 LIMIT 1 [ RunTime:0.000137s ]
SELECT `goodsId`,`isPifa`,`goodsPrice` FROM `wst_goods` WHERE `goodsId` = 142 LIMIT 1 [ RunTime:0.000127s ]
SELECT `goodsId`,`isPifa`,`goodsPrice` FROM `wst_goods` WHERE `goodsId` = 143 LIMIT 1 [ RunTime:0.000127s ]
SELECT `goodsId`,`isPifa`,`goodsPrice` FROM `wst_goods` WHERE `goodsId` = 150 LIMIT 1 [ RunTime:0.000137s ]
SELECT `goodsId`,`isPifa`,`goodsPrice` FROM `wst_goods` WHERE `goodsId` = 151 LIMIT 1 [ RunTime:0.000126s ]
SELECT `goodsId`,`isPifa`,`goodsPrice` FROM `wst_goods` WHERE `goodsId` = 152 LIMIT 1 [ RunTime:0.000133s ]
SELECT `goodsId`,`isPifa`,`goodsPrice` FROM `wst_goods` WHERE `goodsId` = 153 LIMIT 1 [ RunTime:0.000143s ]
SELECT * FROM `wst_presales` WHERE `startTime` <= '2023-12-01 07:58:35' AND `endTime` >= '2023-12-01 07:58:35' AND `dataFlag` = 1 AND `isSale` = 1 AND `goodsId` = 106 LIMIT 1 [ RunTime:0.000234s ]
SELECT * FROM `wst_presales` WHERE `startTime` <= '2023-12-01 07:58:35' AND `endTime` >= '2023-12-01 07:58:35' AND `dataFlag` = 1 AND `isSale` = 1 AND `goodsId` = 141 LIMIT 1 [ RunTime:0.000208s ]
SELECT * FROM `wst_presales` WHERE `startTime` <= '2023-12-01 07:58:35' AND `endTime` >= '2023-12-01 07:58:35' AND `dataFlag` = 1 AND `isSale` = 1 AND `goodsId` = 142 LIMIT 1 [ RunTime:0.000222s ]
SELECT * FROM `wst_presales` WHERE `startTime` <= '2023-12-01 07:58:35' AND `endTime` >= '2023-12-01 07:58:35' AND `dataFlag` = 1 AND `isSale` = 1 AND `goodsId` = 143 LIMIT 1 [ RunTime:0.000216s ]
SELECT * FROM `wst_presales` WHERE `startTime` <= '2023-12-01 07:58:35' AND `endTime` >= '2023-12-01 07:58:35' AND `dataFlag` = 1 AND `isSale` = 1 AND `goodsId` = 150 LIMIT 1 [ RunTime:0.000200s ]
SELECT * FROM `wst_presales` WHERE `startTime` <= '2023-12-01 07:58:35' AND `endTime` >= '2023-12-01 07:58:35' AND `dataFlag` = 1 AND `isSale` = 1 AND `goodsId` = 151 LIMIT 1 [ RunTime:0.000200s ]
SELECT * FROM `wst_presales` WHERE `startTime` <= '2023-12-01 07:58:35' AND `endTime` >= '2023-12-01 07:58:35' AND `dataFlag` = 1 AND `isSale` = 1 AND `goodsId` = 152 LIMIT 1 [ RunTime:0.000200s ]
SELECT * FROM `wst_presales` WHERE `startTime` <= '2023-12-01 07:58:35' AND `endTime` >= '2023-12-01 07:58:35' AND `dataFlag` = 1 AND `isSale` = 1 AND `goodsId` = 153 LIMIT 1 [ RunTime:0.000201s ]
SELECT `adId`,`adName`,`adURL`,`adFile`,`positionWidth`,`positionHeight` FROM `wst_ads` `a` LEFT JOIN `wst_ad_positions` `ap` ON `a`.`adPositionId`=ap.positionId and ap.dataFlag=1 WHERE ( a.dataFlag=1 and ap.positionCode='ads-3-1' and adStartDate<= '2023-12-01' and adEndDate>='2023-12-01' and a.sellerId=0 and a.adSrc=1 ) ORDER BY `adSort` ASC LIMIT 1 [ RunTime:0.000288s ]
SELECT `areaIdPath` FROM `wst_sellers` WHERE `sellerId` = 0 LIMIT 1 [ RunTime:0.000156s ]
SELECT `parentId` FROM `wst_goods_cats` WHERE `catId` = 70 LIMIT 1 [ RunTime:0.000137s ]
SELECT gs.id goodsSpecId,`g`.`goodsId`,`g`.`goodsCatId`,`g`.`goodsImg`,`g`.`goodsUnit`,`g`.`goodsTips`,`g`.`goodsName`,`g`.`goodsPrice`,g.goodsPrice defaultGoodsPrice,`g`.`goodsStock`,`g`.`saleNum`,`g`.`isSpec`,`g`.`goodsSn`,`gs`.`specStock`,`gs`.`specIds`,g.goodsPrice as platformPrice,`g`.`marketPrice`,`g`.`minOrder` FROM `wst_goods` `g` LEFT JOIN `wst_goods_specs` `gs` ON `g`.`goodsId`=gs.goodsId and gs.isDefault=1 WHERE `g`.`dataFlag` = 1 AND `g`.`isReCom` = 1 AND `g`.`goodsCatIdPath` LIKE '70_%' AND `g`.`isSale` = 1 LIMIT 8 [ RunTime:0.000512s ]
SELECT COUNT(*) AS think_count FROM `wst_reward_goods` `rg` INNER JOIN `wst_rewards` `r` ON `rg`.`rewardId`=`r`.`rewardId` WHERE ( r.dataFlag=1 and goodsId=139 and startDate<="2023-12-01" and endDate>="2023-12-01" ) [ RunTime:0.000218s ]
SELECT COUNT(*) AS think_count FROM `wst_rewards` WHERE ( dataFlag=1 and useObjects=0 and startDate<="2023-12-01" and endDate>="2023-12-01" ) [ RunTime:0.000173s ]
SELECT COUNT(*) AS think_count FROM `wst_reward_goods` `rg` INNER JOIN `wst_rewards` `r` ON `rg`.`rewardId`=`r`.`rewardId` WHERE ( r.dataFlag=1 and goodsId=140 and startDate<="2023-12-01" and endDate>="2023-12-01" ) [ RunTime:0.000193s ]
SELECT COUNT(*) AS think_count FROM `wst_rewards` WHERE ( dataFlag=1 and useObjects=0 and startDate<="2023-12-01" and endDate>="2023-12-01" ) [ RunTime:0.000155s ]
SELECT COUNT(*) AS think_count FROM `wst_reward_goods` `rg` INNER JOIN `wst_rewards` `r` ON `rg`.`rewardId`=`r`.`rewardId` WHERE ( r.dataFlag=1 and goodsId=147 and startDate<="2023-12-01" and endDate>="2023-12-01" ) [ RunTime:0.000179s ]
SELECT COUNT(*) AS think_count FROM `wst_rewards` WHERE ( dataFlag=1 and useObjects=0 and startDate<="2023-12-01" and endDate>="2023-12-01" ) [ RunTime:0.000150s ]
SELECT COUNT(*) AS think_count FROM `wst_reward_goods` `rg` INNER JOIN `wst_rewards` `r` ON `rg`.`rewardId`=`r`.`rewardId` WHERE ( r.dataFlag=1 and goodsId=148 and startDate<="2023-12-01" and endDate>="2023-12-01" ) [ RunTime:0.000172s ]
SELECT COUNT(*) AS think_count FROM `wst_rewards` WHERE ( dataFlag=1 and useObjects=0 and startDate<="2023-12-01" and endDate>="2023-12-01" ) [ RunTime:0.000150s ]
SELECT COUNT(*) AS think_count FROM `wst_reward_goods` `rg` INNER JOIN `wst_rewards` `r` ON `rg`.`rewardId`=`r`.`rewardId` WHERE ( r.dataFlag=1 and goodsId=144 and startDate<="2023-12-01" and endDate>="2023-12-01" ) [ RunTime:0.000172s ]
SELECT COUNT(*) AS think_count FROM `wst_rewards` WHERE ( dataFlag=1 and useObjects=0 and startDate<="2023-12-01" and endDate>="2023-12-01" ) [ RunTime:0.000151s ]
SELECT COUNT(*) AS think_count FROM `wst_reward_goods` `rg` INNER JOIN `wst_rewards` `r` ON `rg`.`rewardId`=`r`.`rewardId` WHERE ( r.dataFlag=1 and goodsId=146 and startDate<="2023-12-01" and endDate>="2023-12-01" ) [ RunTime:0.000190s ]
SELECT COUNT(*) AS think_count FROM `wst_rewards` WHERE ( dataFlag=1 and useObjects=0 and startDate<="2023-12-01" and endDate>="2023-12-01" ) [ RunTime:0.000151s ]
SELECT COUNT(*) AS think_count FROM `wst_reward_goods` `rg` INNER JOIN `wst_rewards` `r` ON `rg`.`rewardId`=`r`.`rewardId` WHERE ( r.dataFlag=1 and goodsId=149 and startDate<="2023-12-01" and endDate>="2023-12-01" ) [ RunTime:0.000176s ]
SELECT COUNT(*) AS think_count FROM `wst_rewards` WHERE ( dataFlag=1 and useObjects=0 and startDate<="2023-12-01" and endDate>="2023-12-01" ) [ RunTime:0.000168s ]
SELECT COUNT(*) AS think_count FROM `wst_reward_goods` `rg` INNER JOIN `wst_rewards` `r` ON `rg`.`rewardId`=`r`.`rewardId` WHERE ( r.dataFlag=1 and goodsId=145 and startDate<="2023-12-01" and endDate>="2023-12-01" ) [ RunTime:0.000206s ]
SELECT COUNT(*) AS think_count FROM `wst_rewards` WHERE ( dataFlag=1 and useObjects=0 and startDate<="2023-12-01" and endDate>="2023-12-01" ) [ RunTime:0.000155s ]
SELECT COUNT(*) AS think_count FROM `wst_coupon_goods` `cg` INNER JOIN `wst_coupons` `c` ON `cg`.`couponId`=`c`.`couponId` WHERE `endDate` >= '2023-12-01' AND `goodsId` = 139 AND `dataFlag` = 1 [ RunTime:0.000177s ]
SELECT COUNT(*) AS think_count FROM `wst_coupons` WHERE ( couponType=2 and dataFlag=1 and useObjects=0 and startDate<="2023-12-01" and endDate>="2023-12-01" ) [ RunTime:0.000170s ]
SELECT COUNT(*) AS think_count FROM `wst_coupon_goods` `cg` INNER JOIN `wst_coupons` `c` ON `cg`.`couponId`=`c`.`couponId` WHERE `endDate` >= '2023-12-01' AND `goodsId` = 140 AND `dataFlag` = 1 [ RunTime:0.000180s ]
SELECT COUNT(*) AS think_count FROM `wst_coupons` WHERE ( couponType=2 and dataFlag=1 and useObjects=0 and startDate<="2023-12-01" and endDate>="2023-12-01" ) [ RunTime:0.000163s ]
SELECT COUNT(*) AS think_count FROM `wst_coupon_goods` `cg` INNER JOIN `wst_coupons` `c` ON `cg`.`couponId`=`c`.`couponId` WHERE `endDate` >= '2023-12-01' AND `goodsId` = 147 AND `dataFlag` = 1 [ RunTime:0.000170s ]
SELECT COUNT(*) AS think_count FROM `wst_coupons` WHERE ( couponType=2 and dataFlag=1 and useObjects=0 and startDate<="2023-12-01" and endDate>="2023-12-01" ) [ RunTime:0.000163s ]
SELECT COUNT(*) AS think_count FROM `wst_coupon_goods` `cg` INNER JOIN `wst_coupons` `c` ON `cg`.`couponId`=`c`.`couponId` WHERE `endDate` >= '2023-12-01' AND `goodsId` = 148 AND `dataFlag` = 1 [ RunTime:0.000180s ]
SELECT COUNT(*) AS think_count FROM `wst_coupons` WHERE ( couponType=2 and dataFlag=1 and useObjects=0 and startDate<="2023-12-01" and endDate>="2023-12-01" ) [ RunTime:0.000163s ]
SELECT COUNT(*) AS think_count FROM `wst_coupon_goods` `cg` INNER JOIN `wst_coupons` `c` ON `cg`.`couponId`=`c`.`couponId` WHERE `endDate` >= '2023-12-01' AND `goodsId` = 144 AND `dataFlag` = 1 [ RunTime:0.000202s ]
SELECT COUNT(*) AS think_count FROM `wst_coupons` WHERE ( couponType=2 and dataFlag=1 and useObjects=0 and startDate<="2023-12-01" and endDate>="2023-12-01" ) [ RunTime:0.000217s ]
SELECT COUNT(*) AS think_count FROM `wst_coupon_goods` `cg` INNER JOIN `wst_coupons` `c` ON `cg`.`couponId`=`c`.`couponId` WHERE `endDate` >= '2023-12-01' AND `goodsId` = 146 AND `dataFlag` = 1 [ RunTime:0.000220s ]
SELECT COUNT(*) AS think_count FROM `wst_coupons` WHERE ( couponType=2 and dataFlag=1 and useObjects=0 and startDate<="2023-12-01" and endDate>="2023-12-01" ) [ RunTime:0.000178s ]
SELECT COUNT(*) AS think_count FROM `wst_coupon_goods` `cg` INNER JOIN `wst_coupons` `c` ON `cg`.`couponId`=`c`.`couponId` WHERE `endDate` >= '2023-12-01' AND `goodsId` = 149 AND `dataFlag` = 1 [ RunTime:0.000201s ]
SELECT COUNT(*) AS think_count FROM `wst_coupons` WHERE ( couponType=2 and dataFlag=1 and useObjects=0 and startDate<="2023-12-01" and endDate>="2023-12-01" ) [ RunTime:0.000178s ]
SELECT COUNT(*) AS think_count FROM `wst_coupon_goods` `cg` INNER JOIN `wst_coupons` `c` ON `cg`.`couponId`=`c`.`couponId` WHERE `endDate` >= '2023-12-01' AND `goodsId` = 145 AND `dataFlag` = 1 [ RunTime:0.000174s ]
SELECT COUNT(*) AS think_count FROM `wst_coupons` WHERE ( couponType=2 and dataFlag=1 and useObjects=0 and startDate<="2023-12-01" and endDate>="2023-12-01" ) [ RunTime:0.000164s ]
SELECT `goodsId`,`isPifa`,`goodsPrice` FROM `wst_goods` WHERE `goodsId` = 139 LIMIT 1 [ RunTime:0.000165s ]
SELECT `goodsId`,`isPifa`,`goodsPrice` FROM `wst_goods` WHERE `goodsId` = 140 LIMIT 1 [ RunTime:0.000145s ]
SELECT `goodsId`,`isPifa`,`goodsPrice` FROM `wst_goods` WHERE `goodsId` = 147 LIMIT 1 [ RunTime:0.000131s ]
SELECT `goodsId`,`isPifa`,`goodsPrice` FROM `wst_goods` WHERE `goodsId` = 148 LIMIT 1 [ RunTime:0.000128s ]
SELECT `goodsId`,`isPifa`,`goodsPrice` FROM `wst_goods` WHERE `goodsId` = 144 LIMIT 1 [ RunTime:0.000142s ]
SELECT `goodsId`,`isPifa`,`goodsPrice` FROM `wst_goods` WHERE `goodsId` = 146 LIMIT 1 [ RunTime:0.000133s ]
SELECT `goodsId`,`isPifa`,`goodsPrice` FROM `wst_goods` WHERE `goodsId` = 149 LIMIT 1 [ RunTime:0.000133s ]
SELECT `goodsId`,`isPifa`,`goodsPrice` FROM `wst_goods` WHERE `goodsId` = 145 LIMIT 1 [ RunTime:0.000126s ]
SELECT * FROM `wst_presales` WHERE `startTime` <= '2023-12-01 07:58:35' AND `endTime` >= '2023-12-01 07:58:35' AND `dataFlag` = 1 AND `isSale` = 1 AND `goodsId` = 139 LIMIT 1 [ RunTime:0.000238s ]
SELECT * FROM `wst_presales` WHERE `startTime` <= '2023-12-01 07:58:35' AND `endTime` >= '2023-12-01 07:58:35' AND `dataFlag` = 1 AND `isSale` = 1 AND `goodsId` = 140 LIMIT 1 [ RunTime:0.000236s ]
SELECT * FROM `wst_presales` WHERE `startTime` <= '2023-12-01 07:58:35' AND `endTime` >= '2023-12-01 07:58:35' AND `dataFlag` = 1 AND `isSale` = 1 AND `goodsId` = 147 LIMIT 1 [ RunTime:0.000213s ]
SELECT * FROM `wst_presales` WHERE `startTime` <= '2023-12-01 07:58:35' AND `endTime` >= '2023-12-01 07:58:35' AND `dataFlag` = 1 AND `isSale` = 1 AND `goodsId` = 148 LIMIT 1 [ RunTime:0.000209s ]
SELECT * FROM `wst_presales` WHERE `startTime` <= '2023-12-01 07:58:35' AND `endTime` >= '2023-12-01 07:58:35' AND `dataFlag` = 1 AND `isSale` = 1 AND `goodsId` = 144 LIMIT 1 [ RunTime:0.000210s ]
SELECT * FROM `wst_presales` WHERE `startTime` <= '2023-12-01 07:58:35' AND `endTime` >= '2023-12-01 07:58:35' AND `dataFlag` = 1 AND `isSale` = 1 AND `goodsId` = 146 LIMIT 1 [ RunTime:0.000205s ]
SELECT * FROM `wst_presales` WHERE `startTime` <= '2023-12-01 07:58:35' AND `endTime` >= '2023-12-01 07:58:35' AND `dataFlag` = 1 AND `isSale` = 1 AND `goodsId` = 149 LIMIT 1 [ RunTime:0.000196s ]
SELECT * FROM `wst_presales` WHERE `startTime` <= '2023-12-01 07:58:35' AND `endTime` >= '2023-12-01 07:58:35' AND `dataFlag` = 1 AND `isSale` = 1 AND `goodsId` = 145 LIMIT 1 [ RunTime:0.000213s ]
SELECT `areaIdPath` FROM `wst_sellers` WHERE `sellerId` = 0 LIMIT 1 [ RunTime:0.000151s ]
SELECT `parentId` FROM `wst_goods_cats` WHERE `catId` = 86 LIMIT 1 [ RunTime:0.000142s ]
SELECT `parentId` FROM `wst_goods_cats` WHERE `catId` = 70 LIMIT 1 [ RunTime:0.000118s ]
SELECT gs.id goodsSpecId,`g`.`goodsId`,`g`.`goodsCatId`,`g`.`goodsImg`,`g`.`goodsUnit`,`g`.`goodsTips`,`g`.`goodsName`,`g`.`goodsPrice`,g.goodsPrice defaultGoodsPrice,`g`.`goodsStock`,`g`.`saleNum`,`g`.`isSpec`,`g`.`goodsSn`,`gs`.`specStock`,`gs`.`specIds`,g.goodsPrice as platformPrice,`g`.`marketPrice`,`g`.`minOrder` FROM `wst_goods` `g` LEFT JOIN `wst_goods_specs` `gs` ON `g`.`goodsId`=gs.goodsId and gs.isDefault=1 WHERE `g`.`dataFlag` = 1 AND `g`.`isReCom` = 1 AND `g`.`goodsCatIdPath` LIKE '70_86_%' AND `g`.`isSale` = 1 LIMIT 10 [ RunTime:0.000455s ]
SELECT COUNT(*) AS think_count FROM `wst_reward_goods` `rg` INNER JOIN `wst_rewards` `r` ON `rg`.`rewardId`=`r`.`rewardId` WHERE ( r.dataFlag=1 and goodsId=139 and startDate<="2023-12-01" and endDate>="2023-12-01" ) [ RunTime:0.000223s ]
SELECT COUNT(*) AS think_count FROM `wst_rewards` WHERE ( dataFlag=1 and useObjects=0 and startDate<="2023-12-01" and endDate>="2023-12-01" ) [ RunTime:0.000182s ]
SELECT COUNT(*) AS think_count FROM `wst_reward_goods` `rg` INNER JOIN `wst_rewards` `r` ON `rg`.`rewardId`=`r`.`rewardId` WHERE ( r.dataFlag=1 and goodsId=140 and startDate<="2023-12-01" and endDate>="2023-12-01" ) [ RunTime:0.000196s ]
SELECT COUNT(*) AS think_count FROM `wst_rewards` WHERE ( dataFlag=1 and useObjects=0 and startDate<="2023-12-01" and endDate>="2023-12-01" ) [ RunTime:0.000163s ]
SELECT COUNT(*) AS think_count FROM `wst_reward_goods` `rg` INNER JOIN `wst_rewards` `r` ON `rg`.`rewardId`=`r`.`rewardId` WHERE ( r.dataFlag=1 and goodsId=147 and startDate<="2023-12-01" and endDate>="2023-12-01" ) [ RunTime:0.000302s ]
SELECT COUNT(*) AS think_count FROM `wst_rewards` WHERE ( dataFlag=1 and useObjects=0 and startDate<="2023-12-01" and endDate>="2023-12-01" ) [ RunTime:0.000241s ]
SELECT COUNT(*) AS think_count FROM `wst_reward_goods` `rg` INNER JOIN `wst_rewards` `r` ON `rg`.`rewardId`=`r`.`rewardId` WHERE ( r.dataFlag=1 and goodsId=148 and startDate<="2023-12-01" and endDate>="2023-12-01" ) [ RunTime:0.000219s ]
SELECT COUNT(*) AS think_count FROM `wst_rewards` WHERE ( dataFlag=1 and useObjects=0 and startDate<="2023-12-01" and endDate>="2023-12-01" ) [ RunTime:0.000191s ]
SELECT COUNT(*) AS think_count FROM `wst_coupon_goods` `cg` INNER JOIN `wst_coupons` `c` ON `cg`.`couponId`=`c`.`couponId` WHERE `endDate` >= '2023-12-01' AND `goodsId` = 139 AND `dataFlag` = 1 [ RunTime:0.000259s ]
SELECT COUNT(*) AS think_count FROM `wst_coupons` WHERE ( couponType=2 and dataFlag=1 and useObjects=0 and startDate<="2023-12-01" and endDate>="2023-12-01" ) [ RunTime:0.000234s ]
SELECT COUNT(*) AS think_count FROM `wst_coupon_goods` `cg` INNER JOIN `wst_coupons` `c` ON `cg`.`couponId`=`c`.`couponId` WHERE `endDate` >= '2023-12-01' AND `goodsId` = 140 AND `dataFlag` = 1 [ RunTime:0.000267s ]
SELECT COUNT(*) AS think_count FROM `wst_coupons` WHERE ( couponType=2 and dataFlag=1 and useObjects=0 and startDate<="2023-12-01" and endDate>="2023-12-01" ) [ RunTime:0.000280s ]
SELECT COUNT(*) AS think_count FROM `wst_coupon_goods` `cg` INNER JOIN `wst_coupons` `c` ON `cg`.`couponId`=`c`.`couponId` WHERE `endDate` >= '2023-12-01' AND `goodsId` = 147 AND `dataFlag` = 1 [ RunTime:0.000310s ]
SELECT COUNT(*) AS think_count FROM `wst_coupons` WHERE ( couponType=2 and dataFlag=1 and useObjects=0 and startDate<="2023-12-01" and endDate>="2023-12-01" ) [ RunTime:0.000198s ]
SELECT COUNT(*) AS think_count FROM `wst_coupon_goods` `cg` INNER JOIN `wst_coupons` `c` ON `cg`.`couponId`=`c`.`couponId` WHERE `endDate` >= '2023-12-01' AND `goodsId` = 148 AND `dataFlag` = 1 [ RunTime:0.000231s ]
SELECT COUNT(*) AS think_count FROM `wst_coupons` WHERE ( couponType=2 and dataFlag=1 and useObjects=0 and startDate<="2023-12-01" and endDate>="2023-12-01" ) [ RunTime:0.000193s ]
SELECT `goodsId`,`isPifa`,`goodsPrice` FROM `wst_goods` WHERE `goodsId` = 139 LIMIT 1 [ RunTime:0.000156s ]
SELECT `goodsId`,`isPifa`,`goodsPrice` FROM `wst_goods` WHERE `goodsId` = 140 LIMIT 1 [ RunTime:0.000150s ]
SELECT `goodsId`,`isPifa`,`goodsPrice` FROM `wst_goods` WHERE `goodsId` = 147 LIMIT 1 [ RunTime:0.000142s ]
SELECT `goodsId`,`isPifa`,`goodsPrice` FROM `wst_goods` WHERE `goodsId` = 148 LIMIT 1 [ RunTime:0.000131s ]
SELECT * FROM `wst_presales` WHERE `startTime` <= '2023-12-01 07:58:35' AND `endTime` >= '2023-12-01 07:58:35' AND `dataFlag` = 1 AND `isSale` = 1 AND `goodsId` = 139 LIMIT 1 [ RunTime:0.000239s ]
SELECT * FROM `wst_presales` WHERE `startTime` <= '2023-12-01 07:58:35' AND `endTime` >= '2023-12-01 07:58:35' AND `dataFlag` = 1 AND `isSale` = 1 AND `goodsId` = 140 LIMIT 1 [ RunTime:0.000214s ]
SELECT * FROM `wst_presales` WHERE `startTime` <= '2023-12-01 07:58:35' AND `endTime` >= '2023-12-01 07:58:35' AND `dataFlag` = 1 AND `isSale` = 1 AND `goodsId` = 147 LIMIT 1 [ RunTime:0.000203s ]
SELECT * FROM `wst_presales` WHERE `startTime` <= '2023-12-01 07:58:35' AND `endTime` >= '2023-12-01 07:58:35' AND `dataFlag` = 1 AND `isSale` = 1 AND `goodsId` = 148 LIMIT 1 [ RunTime:0.000237s ]
SELECT `areaIdPath` FROM `wst_sellers` WHERE `sellerId` = 0 LIMIT 1 [ RunTime:0.000190s ]
SELECT `parentId` FROM `wst_goods_cats` WHERE `catId` = 87 LIMIT 1 [ RunTime:0.000141s ]
SELECT `parentId` FROM `wst_goods_cats` WHERE `catId` = 70 LIMIT 1 [ RunTime:0.000121s ]
SELECT gs.id goodsSpecId,`g`.`goodsId`,`g`.`goodsCatId`,`g`.`goodsImg`,`g`.`goodsUnit`,`g`.`goodsTips`,`g`.`goodsName`,`g`.`goodsPrice`,g.goodsPrice defaultGoodsPrice,`g`.`goodsStock`,`g`.`saleNum`,`g`.`isSpec`,`g`.`goodsSn`,`gs`.`specStock`,`gs`.`specIds`,g.goodsPrice as platformPrice,`g`.`marketPrice`,`g`.`minOrder` FROM `wst_goods` `g` LEFT JOIN `wst_goods_specs` `gs` ON `g`.`goodsId`=gs.goodsId and gs.isDefault=1 WHERE `g`.`dataFlag` = 1 AND `g`.`isReCom` = 1 AND `g`.`goodsCatIdPath` LIKE '70_87_%' AND `g`.`isSale` = 1 LIMIT 10 [ RunTime:0.000335s ]
SELECT COUNT(*) AS think_count FROM `wst_reward_goods` `rg` INNER JOIN `wst_rewards` `r` ON `rg`.`rewardId`=`r`.`rewardId` WHERE ( r.dataFlag=1 and goodsId=144 and startDate<="2023-12-01" and endDate>="2023-12-01" ) [ RunTime:0.000220s ]
SELECT COUNT(*) AS think_count FROM `wst_rewards` WHERE ( dataFlag=1 and useObjects=0 and startDate<="2023-12-01" and endDate>="2023-12-01" ) [ RunTime:0.000161s ]
SELECT COUNT(*) AS think_count FROM `wst_reward_goods` `rg` INNER JOIN `wst_rewards` `r` ON `rg`.`rewardId`=`r`.`rewardId` WHERE ( r.dataFlag=1 and goodsId=146 and startDate<="2023-12-01" and endDate>="2023-12-01" ) [ RunTime:0.000190s ]
SELECT COUNT(*) AS think_count FROM `wst_rewards` WHERE ( dataFlag=1 and useObjects=0 and startDate<="2023-12-01" and endDate>="2023-12-01" ) [ RunTime:0.000178s ]
SELECT COUNT(*) AS think_count FROM `wst_reward_goods` `rg` INNER JOIN `wst_rewards` `r` ON `rg`.`rewardId`=`r`.`rewardId` WHERE ( r.dataFlag=1 and goodsId=149 and startDate<="2023-12-01" and endDate>="2023-12-01" ) [ RunTime:0.000180s ]
SELECT COUNT(*) AS think_count FROM `wst_rewards` WHERE ( dataFlag=1 and useObjects=0 and startDate<="2023-12-01" and endDate>="2023-12-01" ) [ RunTime:0.000155s ]
SELECT COUNT(*) AS think_count FROM `wst_coupon_goods` `cg` INNER JOIN `wst_coupons` `c` ON `cg`.`couponId`=`c`.`couponId` WHERE `endDate` >= '2023-12-01' AND `goodsId` = 144 AND `dataFlag` = 1 [ RunTime:0.000192s ]
SELECT COUNT(*) AS think_count FROM `wst_coupons` WHERE ( couponType=2 and dataFlag=1 and useObjects=0 and startDate<="2023-12-01" and endDate>="2023-12-01" ) [ RunTime:0.000181s ]
SELECT COUNT(*) AS think_count FROM `wst_coupon_goods` `cg` INNER JOIN `wst_coupons` `c` ON `cg`.`couponId`=`c`.`couponId` WHERE `endDate` >= '2023-12-01' AND `goodsId` = 146 AND `dataFlag` = 1 [ RunTime:0.000170s ]
SELECT COUNT(*) AS think_count FROM `wst_coupons` WHERE ( couponType=2 and dataFlag=1 and useObjects=0 and startDate<="2023-12-01" and endDate>="2023-12-01" ) [ RunTime:0.000163s ]
SELECT COUNT(*) AS think_count FROM `wst_coupon_goods` `cg` INNER JOIN `wst_coupons` `c` ON `cg`.`couponId`=`c`.`couponId` WHERE `endDate` >= '2023-12-01' AND `goodsId` = 149 AND `dataFlag` = 1 [ RunTime:0.000181s ]
SELECT COUNT(*) AS think_count FROM `wst_coupons` WHERE ( couponType=2 and dataFlag=1 and useObjects=0 and startDate<="2023-12-01" and endDate>="2023-12-01" ) [ RunTime:0.000169s ]
SELECT `goodsId`,`isPifa`,`goodsPrice` FROM `wst_goods` WHERE `goodsId` = 144 LIMIT 1 [ RunTime:0.000147s ]
SELECT `goodsId`,`isPifa`,`goodsPrice` FROM `wst_goods` WHERE `goodsId` = 146 LIMIT 1 [ RunTime:0.000133s ]
SELECT `goodsId`,`isPifa`,`goodsPrice` FROM `wst_goods` WHERE `goodsId` = 149 LIMIT 1 [ RunTime:0.000152s ]
SELECT * FROM `wst_presales` WHERE `startTime` <= '2023-12-01 07:58:35' AND `endTime` >= '2023-12-01 07:58:35' AND `dataFlag` = 1 AND `isSale` = 1 AND `goodsId` = 144 LIMIT 1 [ RunTime:0.000227s ]
SELECT * FROM `wst_presales` WHERE `startTime` <= '2023-12-01 07:58:35' AND `endTime` >= '2023-12-01 07:58:35' AND `dataFlag` = 1 AND `isSale` = 1 AND `goodsId` = 146 LIMIT 1 [ RunTime:0.000207s ]
SELECT * FROM `wst_presales` WHERE `startTime` <= '2023-12-01 07:58:35' AND `endTime` >= '2023-12-01 07:58:35' AND `dataFlag` = 1 AND `isSale` = 1 AND `goodsId` = 149 LIMIT 1 [ RunTime:0.000211s ]
SELECT `areaIdPath` FROM `wst_sellers` WHERE `sellerId` = 0 LIMIT 1 [ RunTime:0.000145s ]
SELECT `parentId` FROM `wst_goods_cats` WHERE `catId` = 88 LIMIT 1 [ RunTime:0.000129s ]
SELECT `parentId` FROM `wst_goods_cats` WHERE `catId` = 70 LIMIT 1 [ RunTime:0.000128s ]
SELECT gs.id goodsSpecId,`g`.`goodsId`,`g`.`goodsCatId`,`g`.`goodsImg`,`g`.`goodsUnit`,`g`.`goodsTips`,`g`.`goodsName`,`g`.`goodsPrice`,g.goodsPrice defaultGoodsPrice,`g`.`goodsStock`,`g`.`saleNum`,`g`.`isSpec`,`g`.`goodsSn`,`gs`.`specStock`,`gs`.`specIds`,g.goodsPrice as platformPrice,`g`.`marketPrice`,`g`.`minOrder` FROM `wst_goods` `g` LEFT JOIN `wst_goods_specs` `gs` ON `g`.`goodsId`=gs.goodsId and gs.isDefault=1 WHERE `g`.`dataFlag` = 1 AND `g`.`isReCom` = 1 AND `g`.`goodsCatIdPath` LIKE '70_88_%' AND `g`.`isSale` = 1 LIMIT 10 [ RunTime:0.000347s ]
SELECT COUNT(*) AS think_count FROM `wst_reward_goods` `rg` INNER JOIN `wst_rewards` `r` ON `rg`.`rewardId`=`r`.`rewardId` WHERE ( r.dataFlag=1 and goodsId=145 and startDate<="2023-12-01" and endDate>="2023-12-01" ) [ RunTime:0.000213s ]
SELECT COUNT(*) AS think_count FROM `wst_rewards` WHERE ( dataFlag=1 and useObjects=0 and startDate<="2023-12-01" and endDate>="2023-12-01" ) [ RunTime:0.000159s ]
SELECT COUNT(*) AS think_count FROM `wst_coupon_goods` `cg` INNER JOIN `wst_coupons` `c` ON `cg`.`couponId`=`c`.`couponId` WHERE `endDate` >= '2023-12-01' AND `goodsId` = 145 AND `dataFlag` = 1 [ RunTime:0.000180s ]
SELECT COUNT(*) AS think_count FROM `wst_coupons` WHERE ( couponType=2 and dataFlag=1 and useObjects=0 and startDate<="2023-12-01" and endDate>="2023-12-01" ) [ RunTime:0.000170s ]
SELECT `goodsId`,`isPifa`,`goodsPrice` FROM `wst_goods` WHERE `goodsId` = 145 LIMIT 1 [ RunTime:0.000156s ]
SELECT * FROM `wst_presales` WHERE `startTime` <= '2023-12-01 07:58:35' AND `endTime` >= '2023-12-01 07:58:35' AND `dataFlag` = 1 AND `isSale` = 1 AND `goodsId` = 145 LIMIT 1 [ RunTime:0.000225s ]
SELECT `adId`,`adName`,`adURL`,`adFile`,`positionWidth`,`positionHeight` FROM `wst_ads` `a` LEFT JOIN `wst_ad_positions` `ap` ON `a`.`adPositionId`=ap.positionId and ap.dataFlag=1 WHERE ( a.dataFlag=1 and ap.positionCode='ads-4-1' and adStartDate<= '2023-12-01' and adEndDate>='2023-12-01' and a.sellerId=0 and a.adSrc=1 ) ORDER BY `adSort` ASC LIMIT 1 [ RunTime:0.000321s ]
SELECT `areaIdPath` FROM `wst_sellers` WHERE `sellerId` = 0 LIMIT 1 [ RunTime:0.000219s ]
SELECT `parentId` FROM `wst_goods_cats` WHERE `catId` = 81 LIMIT 1 [ RunTime:0.000198s ]
SELECT gs.id goodsSpecId,`g`.`goodsId`,`g`.`goodsCatId`,`g`.`goodsImg`,`g`.`goodsUnit`,`g`.`goodsTips`,`g`.`goodsName`,`g`.`goodsPrice`,g.goodsPrice defaultGoodsPrice,`g`.`goodsStock`,`g`.`saleNum`,`g`.`isSpec`,`g`.`goodsSn`,`gs`.`specStock`,`gs`.`specIds`,g.goodsPrice as platformPrice,`g`.`marketPrice`,`g`.`minOrder` FROM `wst_goods` `g` LEFT JOIN `wst_goods_specs` `gs` ON `g`.`goodsId`=gs.goodsId and gs.isDefault=1 WHERE `g`.`dataFlag` = 1 AND `g`.`isReCom` = 1 AND `g`.`goodsCatIdPath` LIKE '81_%' AND `g`.`isSale` = 1 LIMIT 8 [ RunTime:0.000695s ]
SELECT COUNT(*) AS think_count FROM `wst_reward_goods` `rg` INNER JOIN `wst_rewards` `r` ON `rg`.`rewardId`=`r`.`rewardId` WHERE ( r.dataFlag=1 and goodsId=154 and startDate<="2023-12-01" and endDate>="2023-12-01" ) [ RunTime:0.000245s ]
SELECT COUNT(*) AS think_count FROM `wst_rewards` WHERE ( dataFlag=1 and useObjects=0 and startDate<="2023-12-01" and endDate>="2023-12-01" ) [ RunTime:0.000201s ]
SELECT COUNT(*) AS think_count FROM `wst_reward_goods` `rg` INNER JOIN `wst_rewards` `r` ON `rg`.`rewardId`=`r`.`rewardId` WHERE ( r.dataFlag=1 and goodsId=155 and startDate<="2023-12-01" and endDate>="2023-12-01" ) [ RunTime:0.000216s ]
SELECT COUNT(*) AS think_count FROM `wst_rewards` WHERE ( dataFlag=1 and useObjects=0 and startDate<="2023-12-01" and endDate>="2023-12-01" ) [ RunTime:0.000170s ]
SELECT COUNT(*) AS think_count FROM `wst_reward_goods` `rg` INNER JOIN `wst_rewards` `r` ON `rg`.`rewardId`=`r`.`rewardId` WHERE ( r.dataFlag=1 and goodsId=156 and startDate<="2023-12-01" and endDate>="2023-12-01" ) [ RunTime:0.000249s ]
SELECT COUNT(*) AS think_count FROM `wst_rewards` WHERE ( dataFlag=1 and useObjects=0 and startDate<="2023-12-01" and endDate>="2023-12-01" ) [ RunTime:0.000217s ]
SELECT COUNT(*) AS think_count FROM `wst_reward_goods` `rg` INNER JOIN `wst_rewards` `r` ON `rg`.`rewardId`=`r`.`rewardId` WHERE ( r.dataFlag=1 and goodsId=157 and startDate<="2023-12-01" and endDate>="2023-12-01" ) [ RunTime:0.000230s ]
SELECT COUNT(*) AS think_count FROM `wst_rewards` WHERE ( dataFlag=1 and useObjects=0 and startDate<="2023-12-01" and endDate>="2023-12-01" ) [ RunTime:0.000215s ]
SELECT COUNT(*) AS think_count FROM `wst_reward_goods` `rg` INNER JOIN `wst_rewards` `r` ON `rg`.`rewardId`=`r`.`rewardId` WHERE ( r.dataFlag=1 and goodsId=158 and startDate<="2023-12-01" and endDate>="2023-12-01" ) [ RunTime:0.000206s ]
SELECT COUNT(*) AS think_count FROM `wst_rewards` WHERE ( dataFlag=1 and useObjects=0 and startDate<="2023-12-01" and endDate>="2023-12-01" ) [ RunTime:0.000163s ]
SELECT COUNT(*) AS think_count FROM `wst_reward_goods` `rg` INNER JOIN `wst_rewards` `r` ON `rg`.`rewardId`=`r`.`rewardId` WHERE ( r.dataFlag=1 and goodsId=159 and startDate<="2023-12-01" and endDate>="2023-12-01" ) [ RunTime:0.000200s ]
SELECT COUNT(*) AS think_count FROM `wst_rewards` WHERE ( dataFlag=1 and useObjects=0 and startDate<="2023-12-01" and endDate>="2023-12-01" ) [ RunTime:0.000182s ]
SELECT COUNT(*) AS think_count FROM `wst_reward_goods` `rg` INNER JOIN `wst_rewards` `r` ON `rg`.`rewardId`=`r`.`rewardId` WHERE ( r.dataFlag=1 and goodsId=160 and startDate<="2023-12-01" and endDate>="2023-12-01" ) [ RunTime:0.000235s ]
SELECT COUNT(*) AS think_count FROM `wst_rewards` WHERE ( dataFlag=1 and useObjects=0 and startDate<="2023-12-01" and endDate>="2023-12-01" ) [ RunTime:0.000194s ]
SELECT COUNT(*) AS think_count FROM `wst_reward_goods` `rg` INNER JOIN `wst_rewards` `r` ON `rg`.`rewardId`=`r`.`rewardId` WHERE ( r.dataFlag=1 and goodsId=161 and startDate<="2023-12-01" and endDate>="2023-12-01" ) [ RunTime:0.000196s ]
SELECT COUNT(*) AS think_count FROM `wst_rewards` WHERE ( dataFlag=1 and useObjects=0 and startDate<="2023-12-01" and endDate>="2023-12-01" ) [ RunTime:0.000165s ]
SELECT COUNT(*) AS think_count FROM `wst_coupon_goods` `cg` INNER JOIN `wst_coupons` `c` ON `cg`.`couponId`=`c`.`couponId` WHERE `endDate` >= '2023-12-01' AND `goodsId` = 154 AND `dataFlag` = 1 [ RunTime:0.000220s ]
SELECT COUNT(*) AS think_count FROM `wst_coupons` WHERE ( couponType=2 and dataFlag=1 and useObjects=0 and startDate<="2023-12-01" and endDate>="2023-12-01" ) [ RunTime:0.000197s ]
SELECT COUNT(*) AS think_count FROM `wst_coupon_goods` `cg` INNER JOIN `wst_coupons` `c` ON `cg`.`couponId`=`c`.`couponId` WHERE `endDate` >= '2023-12-01' AND `goodsId` = 155 AND `dataFlag` = 1 [ RunTime:0.000188s ]
SELECT COUNT(*) AS think_count FROM `wst_coupons` WHERE ( couponType=2 and dataFlag=1 and useObjects=0 and startDate<="2023-12-01" and endDate>="2023-12-01" ) [ RunTime:0.000190s ]
SELECT COUNT(*) AS think_count FROM `wst_coupon_goods` `cg` INNER JOIN `wst_coupons` `c` ON `cg`.`couponId`=`c`.`couponId` WHERE `endDate` >= '2023-12-01' AND `goodsId` = 156 AND `dataFlag` = 1 [ RunTime:0.000175s ]
SELECT COUNT(*) AS think_count FROM `wst_coupons` WHERE ( couponType=2 and dataFlag=1 and useObjects=0 and startDate<="2023-12-01" and endDate>="2023-12-01" ) [ RunTime:0.000191s ]
SELECT COUNT(*) AS think_count FROM `wst_coupon_goods` `cg` INNER JOIN `wst_coupons` `c` ON `cg`.`couponId`=`c`.`couponId` WHERE `endDate` >= '2023-12-01' AND `goodsId` = 157 AND `dataFlag` = 1 [ RunTime:0.000179s ]
SELECT COUNT(*) AS think_count FROM `wst_coupons` WHERE ( couponType=2 and dataFlag=1 and useObjects=0 and startDate<="2023-12-01" and endDate>="2023-12-01" ) [ RunTime:0.000182s ]
SELECT COUNT(*) AS think_count FROM `wst_coupon_goods` `cg` INNER JOIN `wst_coupons` `c` ON `cg`.`couponId`=`c`.`couponId` WHERE `endDate` >= '2023-12-01' AND `goodsId` = 158 AND `dataFlag` = 1 [ RunTime:0.000174s ]
SELECT COUNT(*) AS think_count FROM `wst_coupons` WHERE ( couponType=2 and dataFlag=1 and useObjects=0 and startDate<="2023-12-01" and endDate>="2023-12-01" ) [ RunTime:0.000171s ]
SELECT COUNT(*) AS think_count FROM `wst_coupon_goods` `cg` INNER JOIN `wst_coupons` `c` ON `cg`.`couponId`=`c`.`couponId` WHERE `endDate` >= '2023-12-01' AND `goodsId` = 159 AND `dataFlag` = 1 [ RunTime:0.000199s ]
SELECT COUNT(*) AS think_count FROM `wst_coupons` WHERE ( couponType=2 and dataFlag=1 and useObjects=0 and startDate<="2023-12-01" and endDate>="2023-12-01" ) [ RunTime:0.000193s ]
SELECT COUNT(*) AS think_count FROM `wst_coupon_goods` `cg` INNER JOIN `wst_coupons` `c` ON `cg`.`couponId`=`c`.`couponId` WHERE `endDate` >= '2023-12-01' AND `goodsId` = 160 AND `dataFlag` = 1 [ RunTime:0.000206s ]
SELECT COUNT(*) AS think_count FROM `wst_coupons` WHERE ( couponType=2 and dataFlag=1 and useObjects=0 and startDate<="2023-12-01" and endDate>="2023-12-01" ) [ RunTime:0.000173s ]
SELECT COUNT(*) AS think_count FROM `wst_coupon_goods` `cg` INNER JOIN `wst_coupons` `c` ON `cg`.`couponId`=`c`.`couponId` WHERE `endDate` >= '2023-12-01' AND `goodsId` = 161 AND `dataFlag` = 1 [ RunTime:0.000175s ]
SELECT COUNT(*) AS think_count FROM `wst_coupons` WHERE ( couponType=2 and dataFlag=1 and useObjects=0 and startDate<="2023-12-01" and endDate>="2023-12-01" ) [ RunTime:0.000185s ]
SELECT `goodsId`,`isPifa`,`goodsPrice` FROM `wst_goods` WHERE `goodsId` = 154 LIMIT 1 [ RunTime:0.000213s ]
SELECT `goodsId`,`isPifa`,`goodsPrice` FROM `wst_goods` WHERE `goodsId` = 155 LIMIT 1 [ RunTime:0.000162s ]
SELECT `goodsId`,`isPifa`,`goodsPrice` FROM `wst_goods` WHERE `goodsId` = 156 LIMIT 1 [ RunTime:0.000146s ]
SELECT `goodsId`,`isPifa`,`goodsPrice` FROM `wst_goods` WHERE `goodsId` = 157 LIMIT 1 [ RunTime:0.000154s ]
SELECT `goodsId`,`isPifa`,`goodsPrice` FROM `wst_goods` WHERE `goodsId` = 158 LIMIT 1 [ RunTime:0.000136s ]
SELECT `goodsId`,`isPifa`,`goodsPrice` FROM `wst_goods` WHERE `goodsId` = 159 LIMIT 1 [ RunTime:0.000136s ]
SELECT `goodsId`,`isPifa`,`goodsPrice` FROM `wst_goods` WHERE `goodsId` = 160 LIMIT 1 [ RunTime:0.000137s ]
SELECT `goodsId`,`isPifa`,`goodsPrice` FROM `wst_goods` WHERE `goodsId` = 161 LIMIT 1 [ RunTime:0.000136s ]
SELECT * FROM `wst_presales` WHERE `startTime` <= '2023-12-01 07:58:35' AND `endTime` >= '2023-12-01 07:58:35' AND `dataFlag` = 1 AND `isSale` = 1 AND `goodsId` = 154 LIMIT 1 [ RunTime:0.000239s ]
SELECT * FROM `wst_presales` WHERE `startTime` <= '2023-12-01 07:58:35' AND `endTime` >= '2023-12-01 07:58:35' AND `dataFlag` = 1 AND `isSale` = 1 AND `goodsId` = 155 LIMIT 1 [ RunTime:0.000211s ]
SELECT * FROM `wst_presales` WHERE `startTime` <= '2023-12-01 07:58:35' AND `endTime` >= '2023-12-01 07:58:35' AND `dataFlag` = 1 AND `isSale` = 1 AND `goodsId` = 156 LIMIT 1 [ RunTime:0.000209s ]
SELECT * FROM `wst_presales` WHERE `startTime` <= '2023-12-01 07:58:35' AND `endTime` >= '2023-12-01 07:58:35' AND `dataFlag` = 1 AND `isSale` = 1 AND `goodsId` = 157 LIMIT 1 [ RunTime:0.000231s ]
SELECT * FROM `wst_presales` WHERE `startTime` <= '2023-12-01 07:58:35' AND `endTime` >= '2023-12-01 07:58:35' AND `dataFlag` = 1 AND `isSale` = 1 AND `goodsId` = 158 LIMIT 1 [ RunTime:0.000218s ]
SELECT * FROM `wst_presales` WHERE `startTime` <= '2023-12-01 07:58:35' AND `endTime` >= '2023-12-01 07:58:35' AND `dataFlag` = 1 AND `isSale` = 1 AND `goodsId` = 159 LIMIT 1 [ RunTime:0.000227s ]
SELECT * FROM `wst_presales` WHERE `startTime` <= '2023-12-01 07:58:35' AND `endTime` >= '2023-12-01 07:58:35' AND `dataFlag` = 1 AND `isSale` = 1 AND `goodsId` = 160 LIMIT 1 [ RunTime:0.000254s ]
SELECT * FROM `wst_presales` WHERE `startTime` <= '2023-12-01 07:58:35' AND `endTime` >= '2023-12-01 07:58:35' AND `dataFlag` = 1 AND `isSale` = 1 AND `goodsId` = 161 LIMIT 1 [ RunTime:0.000210s ]
SELECT `areaIdPath` FROM `wst_sellers` WHERE `sellerId` = 0 LIMIT 1 [ RunTime:0.000184s ]
SELECT `parentId` FROM `wst_goods_cats` WHERE `catId` = 82 LIMIT 1 [ RunTime:0.000161s ]
SELECT `parentId` FROM `wst_goods_cats` WHERE `catId` = 81 LIMIT 1 [ RunTime:0.000121s ]
SELECT gs.id goodsSpecId,`g`.`goodsId`,`g`.`goodsCatId`,`g`.`goodsImg`,`g`.`goodsUnit`,`g`.`goodsTips`,`g`.`goodsName`,`g`.`goodsPrice`,g.goodsPrice defaultGoodsPrice,`g`.`goodsStock`,`g`.`saleNum`,`g`.`isSpec`,`g`.`goodsSn`,`gs`.`specStock`,`gs`.`specIds`,g.goodsPrice as platformPrice,`g`.`marketPrice`,`g`.`minOrder` FROM `wst_goods` `g` LEFT JOIN `wst_goods_specs` `gs` ON `g`.`goodsId`=gs.goodsId and gs.isDefault=1 WHERE `g`.`dataFlag` = 1 AND `g`.`isReCom` = 1 AND `g`.`goodsCatIdPath` LIKE '81_82_%' AND `g`.`isSale` = 1 LIMIT 10 [ RunTime:0.000647s ]
SELECT COUNT(*) AS think_count FROM `wst_reward_goods` `rg` INNER JOIN `wst_rewards` `r` ON `rg`.`rewardId`=`r`.`rewardId` WHERE ( r.dataFlag=1 and goodsId=154 and startDate<="2023-12-01" and endDate>="2023-12-01" ) [ RunTime:0.000231s ]
SELECT COUNT(*) AS think_count FROM `wst_rewards` WHERE ( dataFlag=1 and useObjects=0 and startDate<="2023-12-01" and endDate>="2023-12-01" ) [ RunTime:0.000170s ]
SELECT COUNT(*) AS think_count FROM `wst_reward_goods` `rg` INNER JOIN `wst_rewards` `r` ON `rg`.`rewardId`=`r`.`rewardId` WHERE ( r.dataFlag=1 and goodsId=155 and startDate<="2023-12-01" and endDate>="2023-12-01" ) [ RunTime:0.000194s ]
SELECT COUNT(*) AS think_count FROM `wst_rewards` WHERE ( dataFlag=1 and useObjects=0 and startDate<="2023-12-01" and endDate>="2023-12-01" ) [ RunTime:0.000156s ]
SELECT COUNT(*) AS think_count FROM `wst_reward_goods` `rg` INNER JOIN `wst_rewards` `r` ON `rg`.`rewardId`=`r`.`rewardId` WHERE ( r.dataFlag=1 and goodsId=156 and startDate<="2023-12-01" and endDate>="2023-12-01" ) [ RunTime:0.000189s ]
SELECT COUNT(*) AS think_count FROM `wst_rewards` WHERE ( dataFlag=1 and useObjects=0 and startDate<="2023-12-01" and endDate>="2023-12-01" ) [ RunTime:0.000154s ]
SELECT COUNT(*) AS think_count FROM `wst_reward_goods` `rg` INNER JOIN `wst_rewards` `r` ON `rg`.`rewardId`=`r`.`rewardId` WHERE ( r.dataFlag=1 and goodsId=157 and startDate<="2023-12-01" and endDate>="2023-12-01" ) [ RunTime:0.000190s ]
SELECT COUNT(*) AS think_count FROM `wst_rewards` WHERE ( dataFlag=1 and useObjects=0 and startDate<="2023-12-01" and endDate>="2023-12-01" ) [ RunTime:0.000163s ]
SELECT COUNT(*) AS think_count FROM `wst_reward_goods` `rg` INNER JOIN `wst_rewards` `r` ON `rg`.`rewardId`=`r`.`rewardId` WHERE ( r.dataFlag=1 and goodsId=158 and startDate<="2023-12-01" and endDate>="2023-12-01" ) [ RunTime:0.000178s ]
SELECT COUNT(*) AS think_count FROM `wst_rewards` WHERE ( dataFlag=1 and useObjects=0 and startDate<="2023-12-01" and endDate>="2023-12-01" ) [ RunTime:0.000180s ]
SELECT COUNT(*) AS think_count FROM `wst_reward_goods` `rg` INNER JOIN `wst_rewards` `r` ON `rg`.`rewardId`=`r`.`rewardId` WHERE ( r.dataFlag=1 and goodsId=159 and startDate<="2023-12-01" and endDate>="2023-12-01" ) [ RunTime:0.000193s ]
SELECT COUNT(*) AS think_count FROM `wst_rewards` WHERE ( dataFlag=1 and useObjects=0 and startDate<="2023-12-01" and endDate>="2023-12-01" ) [ RunTime:0.000175s ]
SELECT COUNT(*) AS think_count FROM `wst_reward_goods` `rg` INNER JOIN `wst_rewards` `r` ON `rg`.`rewardId`=`r`.`rewardId` WHERE ( r.dataFlag=1 and goodsId=160 and startDate<="2023-12-01" and endDate>="2023-12-01" ) [ RunTime:0.000186s ]
SELECT COUNT(*) AS think_count FROM `wst_rewards` WHERE ( dataFlag=1 and useObjects=0 and startDate<="2023-12-01" and endDate>="2023-12-01" ) [ RunTime:0.000166s ]
SELECT COUNT(*) AS think_count FROM `wst_coupon_goods` `cg` INNER JOIN `wst_coupons` `c` ON `cg`.`couponId`=`c`.`couponId` WHERE `endDate` >= '2023-12-01' AND `goodsId` = 154 AND `dataFlag` = 1 [ RunTime:0.000223s ]
SELECT COUNT(*) AS think_count FROM `wst_coupons` WHERE ( couponType=2 and dataFlag=1 and useObjects=0 and startDate<="2023-12-01" and endDate>="2023-12-01" ) [ RunTime:0.000182s ]
SELECT COUNT(*) AS think_count FROM `wst_coupon_goods` `cg` INNER JOIN `wst_coupons` `c` ON `cg`.`couponId`=`c`.`couponId` WHERE `endDate` >= '2023-12-01' AND `goodsId` = 155 AND `dataFlag` = 1 [ RunTime:0.000175s ]
SELECT COUNT(*) AS think_count FROM `wst_coupons` WHERE ( couponType=2 and dataFlag=1 and useObjects=0 and startDate<="2023-12-01" and endDate>="2023-12-01" ) [ RunTime:0.000187s ]
SELECT COUNT(*) AS think_count FROM `wst_coupon_goods` `cg` INNER JOIN `wst_coupons` `c` ON `cg`.`couponId`=`c`.`couponId` WHERE `endDate` >= '2023-12-01' AND `goodsId` = 156 AND `dataFlag` = 1 [ RunTime:0.000306s ]
SELECT COUNT(*) AS think_count FROM `wst_coupons` WHERE ( couponType=2 and dataFlag=1 and useObjects=0 and startDate<="2023-12-01" and endDate>="2023-12-01" ) [ RunTime:0.000265s ]
SELECT COUNT(*) AS think_count FROM `wst_coupon_goods` `cg` INNER JOIN `wst_coupons` `c` ON `cg`.`couponId`=`c`.`couponId` WHERE `endDate` >= '2023-12-01' AND `goodsId` = 157 AND `dataFlag` = 1 [ RunTime:0.000195s ]
SELECT COUNT(*) AS think_count FROM `wst_coupons` WHERE ( couponType=2 and dataFlag=1 and useObjects=0 and startDate<="2023-12-01" and endDate>="2023-12-01" ) [ RunTime:0.000234s ]
SELECT COUNT(*) AS think_count FROM `wst_coupon_goods` `cg` INNER JOIN `wst_coupons` `c` ON `cg`.`couponId`=`c`.`couponId` WHERE `endDate` >= '2023-12-01' AND `goodsId` = 158 AND `dataFlag` = 1 [ RunTime:0.000217s ]
SELECT COUNT(*) AS think_count FROM `wst_coupons` WHERE ( couponType=2 and dataFlag=1 and useObjects=0 and startDate<="2023-12-01" and endDate>="2023-12-01" ) [ RunTime:0.000177s ]
SELECT COUNT(*) AS think_count FROM `wst_coupon_goods` `cg` INNER JOIN `wst_coupons` `c` ON `cg`.`couponId`=`c`.`couponId` WHERE `endDate` >= '2023-12-01' AND `goodsId` = 159 AND `dataFlag` = 1 [ RunTime:0.000208s ]
SELECT COUNT(*) AS think_count FROM `wst_coupons` WHERE ( couponType=2 and dataFlag=1 and useObjects=0 and startDate<="2023-12-01" and endDate>="2023-12-01" ) [ RunTime:0.000237s ]
SELECT COUNT(*) AS think_count FROM `wst_coupon_goods` `cg` INNER JOIN `wst_coupons` `c` ON `cg`.`couponId`=`c`.`couponId` WHERE `endDate` >= '2023-12-01' AND `goodsId` = 160 AND `dataFlag` = 1 [ RunTime:0.000209s ]
SELECT COUNT(*) AS think_count FROM `wst_coupons` WHERE ( couponType=2 and dataFlag=1 and useObjects=0 and startDate<="2023-12-01" and endDate>="2023-12-01" ) [ RunTime:0.000198s ]
SELECT `goodsId`,`isPifa`,`goodsPrice` FROM `wst_goods` WHERE `goodsId` = 154 LIMIT 1 [ RunTime:0.000201s ]
SELECT `goodsId`,`isPifa`,`goodsPrice` FROM `wst_goods` WHERE `goodsId` = 155 LIMIT 1 [ RunTime:0.000176s ]
SELECT `goodsId`,`isPifa`,`goodsPrice` FROM `wst_goods` WHERE `goodsId` = 156 LIMIT 1 [ RunTime:0.000152s ]
SELECT `goodsId`,`isPifa`,`goodsPrice` FROM `wst_goods` WHERE `goodsId` = 157 LIMIT 1 [ RunTime:0.000162s ]
SELECT `goodsId`,`isPifa`,`goodsPrice` FROM `wst_goods` WHERE `goodsId` = 158 LIMIT 1 [ RunTime:0.000184s ]
SELECT `goodsId`,`isPifa`,`goodsPrice` FROM `wst_goods` WHERE `goodsId` = 159 LIMIT 1 [ RunTime:0.000165s ]
SELECT `goodsId`,`isPifa`,`goodsPrice` FROM `wst_goods` WHERE `goodsId` = 160 LIMIT 1 [ RunTime:0.000145s ]
SELECT * FROM `wst_presales` WHERE `startTime` <= '2023-12-01 07:58:35' AND `endTime` >= '2023-12-01 07:58:35' AND `dataFlag` = 1 AND `isSale` = 1 AND `goodsId` = 154 LIMIT 1 [ RunTime:0.000257s ]
SELECT * FROM `wst_presales` WHERE `startTime` <= '2023-12-01 07:58:35' AND `endTime` >= '2023-12-01 07:58:35' AND `dataFlag` = 1 AND `isSale` = 1 AND `goodsId` = 155 LIMIT 1 [ RunTime:0.000284s ]
SELECT * FROM `wst_presales` WHERE `startTime` <= '2023-12-01 07:58:35' AND `endTime` >= '2023-12-01 07:58:35' AND `dataFlag` = 1 AND `isSale` = 1 AND `goodsId` = 156 LIMIT 1 [ RunTime:0.000255s ]
SELECT * FROM `wst_presales` WHERE `startTime` <= '2023-12-01 07:58:35' AND `endTime` >= '2023-12-01 07:58:35' AND `dataFlag` = 1 AND `isSale` = 1 AND `goodsId` = 157 LIMIT 1 [ RunTime:0.000239s ]
SELECT * FROM `wst_presales` WHERE `startTime` <= '2023-12-01 07:58:35' AND `endTime` >= '2023-12-01 07:58:35' AND `dataFlag` = 1 AND `isSale` = 1 AND `goodsId` = 158 LIMIT 1 [ RunTime:0.000228s ]
SELECT * FROM `wst_presales` WHERE `startTime` <= '2023-12-01 07:58:35' AND `endTime` >= '2023-12-01 07:58:35' AND `dataFlag` = 1 AND `isSale` = 1 AND `goodsId` = 159 LIMIT 1 [ RunTime:0.000211s ]
SELECT * FROM `wst_presales` WHERE `startTime` <= '2023-12-01 07:58:35' AND `endTime` >= '2023-12-01 07:58:35' AND `dataFlag` = 1 AND `isSale` = 1 AND `goodsId` = 160 LIMIT 1 [ RunTime:0.000214s ]
SELECT `areaIdPath` FROM `wst_sellers` WHERE `sellerId` = 0 LIMIT 1 [ RunTime:0.000183s ]
SELECT `parentId` FROM `wst_goods_cats` WHERE `catId` = 83 LIMIT 1 [ RunTime:0.000155s ]
SELECT `parentId` FROM `wst_goods_cats` WHERE `catId` = 81 LIMIT 1 [ RunTime:0.000135s ]
SELECT gs.id goodsSpecId,`g`.`goodsId`,`g`.`goodsCatId`,`g`.`goodsImg`,`g`.`goodsUnit`,`g`.`goodsTips`,`g`.`goodsName`,`g`.`goodsPrice`,g.goodsPrice defaultGoodsPrice,`g`.`goodsStock`,`g`.`saleNum`,`g`.`isSpec`,`g`.`goodsSn`,`gs`.`specStock`,`gs`.`specIds`,g.goodsPrice as platformPrice,`g`.`marketPrice`,`g`.`minOrder` FROM `wst_goods` `g` LEFT JOIN `wst_goods_specs` `gs` ON `g`.`goodsId`=gs.goodsId and gs.isDefault=1 WHERE `g`.`dataFlag` = 1 AND `g`.`isReCom` = 1 AND `g`.`goodsCatIdPath` LIKE '81_83_%' AND `g`.`isSale` = 1 LIMIT 10 [ RunTime:0.000510s ]
SELECT COUNT(*) AS think_count FROM `wst_reward_goods` `rg` INNER JOIN `wst_rewards` `r` ON `rg`.`rewardId`=`r`.`rewardId` WHERE ( r.dataFlag=1 and goodsId=161 and startDate<="2023-12-01" and endDate>="2023-12-01" ) [ RunTime:0.000244s ]
SELECT COUNT(*) AS think_count FROM `wst_rewards` WHERE ( dataFlag=1 and useObjects=0 and startDate<="2023-12-01" and endDate>="2023-12-01" ) [ RunTime:0.000190s ]
SELECT COUNT(*) AS think_count FROM `wst_coupon_goods` `cg` INNER JOIN `wst_coupons` `c` ON `cg`.`couponId`=`c`.`couponId` WHERE `endDate` >= '2023-12-01' AND `goodsId` = 161 AND `dataFlag` = 1 [ RunTime:0.000233s ]
SELECT COUNT(*) AS think_count FROM `wst_coupons` WHERE ( couponType=2 and dataFlag=1 and useObjects=0 and startDate<="2023-12-01" and endDate>="2023-12-01" ) [ RunTime:0.000211s ]
SELECT `goodsId`,`isPifa`,`goodsPrice` FROM `wst_goods` WHERE `goodsId` = 161 LIMIT 1 [ RunTime:0.000153s ]
SELECT * FROM `wst_presales` WHERE `startTime` <= '2023-12-01 07:58:35' AND `endTime` >= '2023-12-01 07:58:35' AND `dataFlag` = 1 AND `isSale` = 1 AND `goodsId` = 161 LIMIT 1 [ RunTime:0.000259s ]
SHOW FULL COLUMNS FROM `wst_custom_pages` [ RunTime:0.000658s ]
SELECT `id` FROM `wst_custom_pages` WHERE `dataFlag` = 1 AND `isIndex` = 1 AND `pageType` = 4 LIMIT 1 [ RunTime:0.000244s ]
SELECT `attr` FROM `wst_custom_pages` WHERE `dataFlag` = 1 AND `id` IS NULL LIMIT 1 [ RunTime:0.000173s ]
SELECT `adId`,`adName`,`adURL`,`adFile`,`positionWidth`,`positionHeight` FROM `wst_ads` `a` LEFT JOIN `wst_ad_positions` `ap` ON `a`.`adPositionId`=ap.positionId and ap.dataFlag=1 WHERE ( a.dataFlag=1 and ap.positionCode='home-pop-ads' and adStartDate<= '2023-12-01' and adEndDate>='2023-12-01' and a.sellerId=0 and a.adSrc=1 ) ORDER BY `adSort` ASC LIMIT 1 [ RunTime:0.000349s ]
SELECT * FROM `wst_navs` WHERE `isShow` = 1 ORDER BY `navSort` ASC [ RunTime:0.000231s ]

美肤/个护

男装/女装/童衣

手机/运营商/数码

家用电器

电脑/办公

家具/家居/家装

男鞋/运动/户外

女鞋/箱包

图书/文艺/教育

食品/饮料

蔬菜/生鲜/水果

家纺/服装/床上用品

男鞋/运动/户外