宁波电信云主机 16核 16GB 99元季度活动 - 产品配置 | 冥雾云测试站

宁波电信云主机 16核 16GB 99元季度活动

产品型号

不同型号的产品，功能和性能有所差异，建议您根据实际需求选择！

数据中心

宁波电信机房

操作系统

CentOS

CentOS-7.6.1810-x64
CentOS-6.8.1607-x64
CentOS-8-Stream-x64
CentOS-7.9.2111-x64
CentOS-9-Stream-x64
CentOS-宝塔面板IP+:8888/install

Debian

Ubuntu

Windows

Fedora

Rocky

AlmaLinux

TencentOS-Server

CPU

16核

内存

16GB

系统盘

100G 100G

带宽

25Mbps 25Mbps

IP数量

1个 1个

网络类型

周期

月季半年年

主机名

主机密码

费用合计：

价格计算中...

注：以上是参考价格，具体扣费请以实际下单结果为准，具体资源及是否可订购以实际库存情况为准。

订单明细

{* === JSON-LD 结构化数据 === *}

首页产品中心个人中心

基本文件流程错误 SQL 调试

/www/wwwroot/zjmf.xn--s7qq40o.online/public/index.php ( 1.13 KB )
/www/wwwroot/zjmf.xn--s7qq40o.online/public/mwy/hook.php ( 18.79 KB )
/www/wwwroot/zjmf.xn--s7qq40o.online/vendor/thinkphp/base.php ( 1.71 KB )
/www/wwwroot/zjmf.xn--s7qq40o.online/vendor/thinkphp/library/think/Loader.php ( 12.81 KB )
/www/wwwroot/zjmf.xn--s7qq40o.online/vendor/composer/autoload_static.php ( 10.28 KB )
/www/wwwroot/zjmf.xn--s7qq40o.online/vendor/thinkphp/library/think/Error.php ( 4.00 KB )
/www/wwwroot/zjmf.xn--s7qq40o.online/vendor/psr/log/Psr/Log/LoggerInterface.php ( 3.16 KB )
/www/wwwroot/zjmf.xn--s7qq40o.online/vendor/thinkphp/library/think/Container.php ( 15.53 KB )
/www/wwwroot/zjmf.xn--s7qq40o.online/vendor/thinkcmf/cmf/src/App.php ( 30.58 KB )
/www/wwwroot/zjmf.xn--s7qq40o.online/vendor/thinkphp/library/think/Env.php ( 2.85 KB )
/www/wwwroot/zjmf.xn--s7qq40o.online/vendor/thinkphp/library/think/Config.php ( 9.71 KB )
/www/wwwroot/zjmf.xn--s7qq40o.online/vendor/thinkphp/convention.php ( 11.74 KB )
/www/wwwroot/zjmf.xn--s7qq40o.online/app/common.php ( 296.25 KB )
/www/wwwroot/zjmf.xn--s7qq40o.online/app/zjmf.php ( 19.22 KB )
/www/wwwroot/zjmf.xn--s7qq40o.online/app/v10.php ( 13.98 KB )
/www/wwwroot/zjmf.xn--s7qq40o.online/vendor/thinkphp/helper.php ( 20.48 KB )
/www/wwwroot/zjmf.xn--s7qq40o.online/vendor/thinkcmf/cmf-app/src/app.php ( 5.35 KB )
/www/wwwroot/zjmf.xn--s7qq40o.online/vendor/thinkcmf/cmf-app/src/database.php ( 0.90 KB )
/www/wwwroot/zjmf.xn--s7qq40o.online/vendor/thinkcmf/cmf-app/src/template.php ( 2.02 KB )
/www/wwwroot/zjmf.xn--s7qq40o.online/vendor/thinkcmf/cmf-app/src/paginate.php ( 0.17 KB )
/www/wwwroot/zjmf.xn--s7qq40o.online/vendor/thinkcmf/cmf-app/src/tags.php ( 1.35 KB )
/www/wwwroot/zjmf.xn--s7qq40o.online/vendor/thinkphp/library/think/Hook.php ( 5.64 KB )
/www/wwwroot/zjmf.xn--s7qq40o.online/app/app.php ( 42.00 KB )
/www/wwwroot/zjmf.xn--s7qq40o.online/vendor/thinkphp/library/think/facade/Lang.php ( 1.75 KB )
/www/wwwroot/zjmf.xn--s7qq40o.online/vendor/thinkphp/library/think/Facade.php ( 3.44 KB )
/www/wwwroot/zjmf.xn--s7qq40o.online/vendor/thinkphp/library/think/Lang.php ( 7.60 KB )
/www/wwwroot/zjmf.xn--s7qq40o.online/vendor/thinkcmf/cmf/src/Log.php ( 8.96 KB )
/www/wwwroot/zjmf.xn--s7qq40o.online/vendor/thinkphp/library/think/log/driver/File.php ( 8.97 KB )
/www/wwwroot/zjmf.xn--s7qq40o.online/app/common/lang/zh-cn.php ( 32.89 KB )
/www/wwwroot/zjmf.xn--s7qq40o.online/app/home/controller/HooksController.php ( 6.86 KB )
/www/wwwroot/zjmf.xn--s7qq40o.online/app/config/database.php ( 0.54 KB )
/www/wwwroot/zjmf.xn--s7qq40o.online/public/language/chinese_tw.php ( 43.41 KB )
/www/wwwroot/zjmf.xn--s7qq40o.online/public/language/chinese.php ( 43.83 KB )
/www/wwwroot/zjmf.xn--s7qq40o.online/public/language/english.php ( 48.21 KB )
/www/wwwroot/zjmf.xn--s7qq40o.online/vendor/thinkphp/library/think/Db.php ( 7.67 KB )
/www/wwwroot/zjmf.xn--s7qq40o.online/vendor/thinkphp/library/think/facade/Cookie.php ( 1.58 KB )
/www/wwwroot/zjmf.xn--s7qq40o.online/vendor/thinkphp/library/think/Cookie.php ( 7.35 KB )
/www/wwwroot/zjmf.xn--s7qq40o.online/vendor/thinkphp/library/think/db/Connection.php ( 59.37 KB )
/www/wwwroot/zjmf.xn--s7qq40o.online/vendor/thinkphp/library/think/db/connector/Mysql.php ( 6.22 KB )
/www/wwwroot/zjmf.xn--s7qq40o.online/vendor/thinkphp/library/think/db/builder/Mysql.php ( 5.85 KB )
/www/wwwroot/zjmf.xn--s7qq40o.online/vendor/thinkphp/library/think/db/Builder.php ( 37.07 KB )
/www/wwwroot/zjmf.xn--s7qq40o.online/vendor/thinkphp/library/think/db/Query.php ( 105.01 KB )
/www/wwwroot/zjmf.xn--s7qq40o.online/vendor/thinkphp/library/think/db/Expression.php ( 1.11 KB )
/www/wwwroot/zjmf.xn--s7qq40o.online/vendor/thinkphp/library/think/Request.php ( 57.65 KB )
/www/wwwroot/zjmf.xn--s7qq40o.online/app/middleware.php ( 0.05 KB )
/www/wwwroot/zjmf.xn--s7qq40o.online/vendor/thinkphp/library/think/Middleware.php ( 5.33 KB )
/www/wwwroot/zjmf.xn--s7qq40o.online/app/http/middleware/AppCheck.php ( 1.72 KB )
/www/wwwroot/zjmf.xn--s7qq40o.online/app/config/actionLog.php ( 0.17 KB )
/www/wwwroot/zjmf.xn--s7qq40o.online/app/config/cache.php ( 0.43 KB )
/www/wwwroot/zjmf.xn--s7qq40o.online/app/config/country.php ( 12.94 KB )
/www/wwwroot/zjmf.xn--s7qq40o.online/app/config/crypt.php ( 0.06 KB )
/www/wwwroot/zjmf.xn--s7qq40o.online/app/config/language.php ( 0.10 KB )
/www/wwwroot/zjmf.xn--s7qq40o.online/app/config/log.php ( 0.17 KB )
/www/wwwroot/zjmf.xn--s7qq40o.online/app/config/public.php ( 2.10 KB )
/www/wwwroot/zjmf.xn--s7qq40o.online/app/config/queue.php ( 0.12 KB )
/www/wwwroot/zjmf.xn--s7qq40o.online/app/config/state.php ( 0.60 KB )
/www/wwwroot/zjmf.xn--s7qq40o.online/app/config/template.php ( 0.02 KB )
/www/wwwroot/zjmf.xn--s7qq40o.online/vendor/ralouphie/getallheaders/src/getallheaders.php ( 1.60 KB )
/www/wwwroot/zjmf.xn--s7qq40o.online/vendor/symfony/polyfill-mbstring/bootstrap.php ( 7.20 KB )
/www/wwwroot/zjmf.xn--s7qq40o.online/vendor/ezyang/htmlpurifier/library/HTMLPurifier.composer.php ( 0.10 KB )
/www/wwwroot/zjmf.xn--s7qq40o.online/vendor/guzzlehttp/promises/src/functions_include.php ( 0.16 KB )
/www/wwwroot/zjmf.xn--s7qq40o.online/vendor/guzzlehttp/promises/src/functions.php ( 9.89 KB )
/www/wwwroot/zjmf.xn--s7qq40o.online/vendor/guzzlehttp/psr7/src/functions_include.php ( 0.15 KB )
/www/wwwroot/zjmf.xn--s7qq40o.online/vendor/guzzlehttp/psr7/src/functions.php ( 13.08 KB )
/www/wwwroot/zjmf.xn--s7qq40o.online/vendor/topthink/think-captcha/src/helper.php ( 1.93 KB )
/www/wwwroot/zjmf.xn--s7qq40o.online/vendor/thinkphp/library/think/facade/Route.php ( 3.83 KB )
/www/wwwroot/zjmf.xn--s7qq40o.online/vendor/thinkphp/library/think/Route.php ( 25.85 KB )
/www/wwwroot/zjmf.xn--s7qq40o.online/vendor/thinkphp/library/think/route/Domain.php ( 7.07 KB )
/www/wwwroot/zjmf.xn--s7qq40o.online/vendor/thinkphp/library/think/route/RuleGroup.php ( 16.45 KB )
/www/wwwroot/zjmf.xn--s7qq40o.online/vendor/thinkphp/library/think/route/Rule.php ( 28.92 KB )
/www/wwwroot/zjmf.xn--s7qq40o.online/vendor/thinkphp/library/think/route/RuleItem.php ( 8.84 KB )
/www/wwwroot/zjmf.xn--s7qq40o.online/vendor/thinkphp/library/think/route/RuleName.php ( 3.92 KB )
/www/wwwroot/zjmf.xn--s7qq40o.online/vendor/thinkphp/library/think/facade/Validate.php ( 4.83 KB )
/www/wwwroot/zjmf.xn--s7qq40o.online/vendor/thinkphp/library/think/Validate.php ( 44.11 KB )
/www/wwwroot/zjmf.xn--s7qq40o.online/vendor/topthink/think-helper/src/helper.php ( 2.88 KB )
/www/wwwroot/zjmf.xn--s7qq40o.online/vendor/guzzlehttp/guzzle/src/functions_include.php ( 0.16 KB )
/www/wwwroot/zjmf.xn--s7qq40o.online/vendor/guzzlehttp/guzzle/src/functions.php ( 5.56 KB )
/www/wwwroot/zjmf.xn--s7qq40o.online/vendor/thinkcmf/cmf/src/common.php ( 66.57 KB )
/www/wwwroot/zjmf.xn--s7qq40o.online/vendor/adbario/php-dot-notation/src/helpers.php ( 0.49 KB )
/www/wwwroot/zjmf.xn--s7qq40o.online/vendor/danielstjules/stringy/src/Create.php ( 0.55 KB )
/www/wwwroot/zjmf.xn--s7qq40o.online/vendor/mtdowling/jmespath.php/src/JmesPath.php ( 0.36 KB )
/www/wwwroot/zjmf.xn--s7qq40o.online/vendor/topthink/think-queue/src/common.php ( 1.19 KB )
/www/wwwroot/zjmf.xn--s7qq40o.online/vendor/thinkphp/library/think/Console.php ( 23.46 KB )
/www/wwwroot/zjmf.xn--s7qq40o.online/vendor/weiwei/api-doc/src/helper.php ( 2.90 KB )
/www/wwwroot/zjmf.xn--s7qq40o.online/vendor/thinkphp/lang/zh-cn.php ( 12.58 KB )
/www/wwwroot/zjmf.xn--s7qq40o.online/data/route/admin.php ( 73.88 KB )
/www/wwwroot/zjmf.xn--s7qq40o.online/vendor/thinkphp/library/think/exception/ErrorException.php ( 1.68 KB )
/www/wwwroot/zjmf.xn--s7qq40o.online/vendor/thinkphp/library/think/Exception.php ( 1.61 KB )
/www/wwwroot/zjmf.xn--s7qq40o.online/app/common/exception/Http.php ( 4.04 KB )
/www/wwwroot/zjmf.xn--s7qq40o.online/vendor/thinkphp/library/think/exception/Handle.php ( 9.00 KB )
/www/wwwroot/zjmf.xn--s7qq40o.online/vendor/thinkphp/library/think/facade/Config.php ( 1.52 KB )
/www/wwwroot/zjmf.xn--s7qq40o.online/vendor/thinkphp/library/think/route/Resource.php ( 3.97 KB )
/www/wwwroot/zjmf.xn--s7qq40o.online/data/route/api.php ( 3.35 KB )
/www/wwwroot/zjmf.xn--s7qq40o.online/data/route/home.php ( 42.20 KB )
/www/wwwroot/zjmf.xn--s7qq40o.online/data/route/openapi.php ( 11.11 KB )
/www/wwwroot/zjmf.xn--s7qq40o.online/data/route/route.php ( 0.02 KB )
/www/wwwroot/zjmf.xn--s7qq40o.online/vendor/thinkcmf/cmf/src/behavior/InitHookBehavior.php ( 4.32 KB )
/www/wwwroot/zjmf.xn--s7qq40o.online/vendor/thinkphp/library/think/Debug.php ( 7.57 KB )
/www/wwwroot/zjmf.xn--s7qq40o.online/vendor/thinkphp/library/think/Collection.php ( 13.60 KB )
/www/wwwroot/zjmf.xn--s7qq40o.online/public/plugins/addons/lai_pintuanba/LaiPintuanbaPlugin.php ( 1.32 KB )
/www/wwwroot/zjmf.xn--s7qq40o.online/app/admin/lib/Plugin.php ( 7.00 KB )
/www/wwwroot/zjmf.xn--s7qq40o.online/vendor/thinkphp/library/think/facade/Hook.php ( 1.46 KB )
/www/wwwroot/zjmf.xn--s7qq40o.online/vendor/thinkcmf/cmf/src/route/dispatch/Module.php ( 5.15 KB )
/www/wwwroot/zjmf.xn--s7qq40o.online/vendor/thinkphp/library/think/route/Dispatch.php ( 9.26 KB )
/www/wwwroot/zjmf.xn--s7qq40o.online/app/http/middleware/UserCheck.php ( 2.58 KB )
/www/wwwroot/zjmf.xn--s7qq40o.online/app/http/middleware/Check.php ( 8.42 KB )
/www/wwwroot/zjmf.xn--s7qq40o.online/app/home/tags.php ( 0.07 KB )
/www/wwwroot/zjmf.xn--s7qq40o.online/app/home/common.php ( 1.70 KB )
/www/wwwroot/zjmf.xn--s7qq40o.online/app/home/config/app.php ( 0.08 KB )
/www/wwwroot/zjmf.xn--s7qq40o.online/app/home/config/common.php ( 0.39 KB )
/www/wwwroot/zjmf.xn--s7qq40o.online/app/home/config/lang.php ( 26.07 KB )
/www/wwwroot/zjmf.xn--s7qq40o.online/vendor/thinkphp/library/think/View.php ( 5.74 KB )
/www/wwwroot/zjmf.xn--s7qq40o.online/vendor/thinkphp/library/think/view/driver/Think.php ( 9.37 KB )
/www/wwwroot/zjmf.xn--s7qq40o.online/vendor/thinkphp/library/think/Template.php ( 57.83 KB )
/www/wwwroot/zjmf.xn--s7qq40o.online/vendor/thinkphp/library/think/template/driver/File.php ( 2.29 KB )
/www/wwwroot/zjmf.xn--s7qq40o.online/vendor/thinkphp/library/think/Session.php ( 14.13 KB )
/www/wwwroot/zjmf.xn--s7qq40o.online/vendor/thinkphp/library/think/Cache.php ( 3.27 KB )
/www/wwwroot/zjmf.xn--s7qq40o.online/vendor/thinkphp/library/think/cache/driver/File.php ( 7.99 KB )
/www/wwwroot/zjmf.xn--s7qq40o.online/vendor/thinkphp/library/think/cache/Driver.php ( 8.64 KB )
/www/wwwroot/zjmf.xn--s7qq40o.online/vendor/thinkcmf/cmf/src/behavior/LangBehavior.php ( 2.46 KB )
/www/wwwroot/zjmf.xn--s7qq40o.online/vendor/thinkcmf/cmf/src/lang/zh-cn.php ( 3.14 KB )
/www/wwwroot/zjmf.xn--s7qq40o.online/vendor/thinkphp/library/think/facade/Env.php ( 1.17 KB )
/www/wwwroot/zjmf.xn--s7qq40o.online/vendor/thinkcmf/cmf-app/src/admin/lang/zh-cn.php ( 9.31 KB )
/www/wwwroot/zjmf.xn--s7qq40o.online/vendor/thinkcmf/cmf-app/src/admin/lang/zh-cn/common.php ( 0.60 KB )
/www/wwwroot/zjmf.xn--s7qq40o.online/vendor/thinkcmf/cmf-app/src/user/lang/zh-cn.php ( 4.13 KB )
/www/wwwroot/zjmf.xn--s7qq40o.online/app/admin/lang/zh-cn/common.php ( 0.02 KB )
/www/wwwroot/zjmf.xn--s7qq40o.online/vendor/thinkphp/library/think/facade/Session.php ( 2.05 KB )
/www/wwwroot/zjmf.xn--s7qq40o.online/vendor/thinkcmf/cmf/src/behavior/InitAppHookBehavior.php ( 2.12 KB )
/www/wwwroot/zjmf.xn--s7qq40o.online/app/home/controller/ViewCartController.php ( 37.37 KB )
/www/wwwroot/zjmf.xn--s7qq40o.online/app/home/controller/ViewBaseController.php ( 20.12 KB )
/www/wwwroot/zjmf.xn--s7qq40o.online/app/home/controller/CommonController.php ( 2.67 KB )
/www/wwwroot/zjmf.xn--s7qq40o.online/vendor/thinkcmf/cmf/src/controller/HomeBaseController.php ( 8.48 KB )
/www/wwwroot/zjmf.xn--s7qq40o.online/vendor/thinkcmf/cmf/src/controller/BaseController.php ( 4.27 KB )
/www/wwwroot/zjmf.xn--s7qq40o.online/vendor/thinkphp/library/think/Controller.php ( 7.72 KB )
/www/wwwroot/zjmf.xn--s7qq40o.online/vendor/thinkphp/library/traits/controller/Jump.php ( 4.76 KB )
/www/wwwroot/zjmf.xn--s7qq40o.online/app/home/model/ViewModel.php ( 31.05 KB )
/www/wwwroot/zjmf.xn--s7qq40o.online/vendor/thinkphp/library/think/Model.php ( 27.48 KB )
/www/wwwroot/zjmf.xn--s7qq40o.online/vendor/thinkphp/library/think/model/concern/Attribute.php ( 17.64 KB )
/www/wwwroot/zjmf.xn--s7qq40o.online/vendor/thinkphp/library/think/model/concern/RelationShip.php ( 19.85 KB )
/www/wwwroot/zjmf.xn--s7qq40o.online/vendor/thinkphp/library/think/model/concern/ModelEvent.php ( 6.04 KB )
/www/wwwroot/zjmf.xn--s7qq40o.online/vendor/thinkphp/library/think/model/concern/TimeStamp.php ( 2.58 KB )
/www/wwwroot/zjmf.xn--s7qq40o.online/vendor/thinkphp/library/think/model/concern/Conversion.php ( 7.84 KB )
/www/wwwroot/zjmf.xn--s7qq40o.online/app/home/controller/CartController.php ( 253.54 KB )
/www/wwwroot/zjmf.xn--s7qq40o.online/vendor/thinkphp/library/think/facade/Cache.php ( 2.06 KB )
/www/wwwroot/zjmf.xn--s7qq40o.online/vendor/thinkphp/library/think/facade/View.php ( 1.76 KB )
/www/wwwroot/zjmf.xn--s7qq40o.online/vendor/thinkcmf/cmf/src/behavior/HomeLangBehavior.php ( 1.52 KB )
/www/wwwroot/zjmf.xn--s7qq40o.online/app/common/logic/Product.php ( 50.23 KB )
/www/wwwroot/zjmf.xn--s7qq40o.online/app/common/model/ProductModel.php ( 54.58 KB )
/www/wwwroot/zjmf.xn--s7qq40o.online/app/common/logic/Renew.php ( 50.31 KB )
/www/wwwroot/zjmf.xn--s7qq40o.online/app/common/logic/Customfields.php ( 16.27 KB )
/www/wwwroot/zjmf.xn--s7qq40o.online/app/common/logic/Cart.php ( 29.35 KB )
/www/wwwroot/zjmf.xn--s7qq40o.online/app/common/logic/ConfigOptions.php ( 60.20 KB )
/www/wwwroot/zjmf.xn--s7qq40o.online/app/home/controller/UserController.php ( 68.88 KB )
/www/wwwroot/zjmf.xn--s7qq40o.online/app/common/logic/Shop.php ( 82.47 KB )
/www/wwwroot/zjmf.xn--s7qq40o.online/public/themes/clientarea/default/language/chinese.php ( 0.25 KB )
/www/wwwroot/zjmf.xn--s7qq40o.online/public/themes/clientarea/default/language/english.php ( 0.26 KB )
/www/wwwroot/zjmf.xn--s7qq40o.online/app/common/logic/Menu.php ( 32.34 KB )
/www/wwwroot/zjmf.xn--s7qq40o.online/vendor/thinkphp/library/think/template/taglib/Cx.php ( 23.95 KB )
/www/wwwroot/zjmf.xn--s7qq40o.online/vendor/thinkphp/library/think/template/TagLib.php ( 12.34 KB )
/www/wwwroot/zjmf.xn--s7qq40o.online/data/runtime/temp/7ed48a6707097fd97247e353811184db.php ( 100.88 KB )
/www/wwwroot/zjmf.xn--s7qq40o.online/public/ewy_config.php ( 0.47 KB )
/www/wwwroot/zjmf.xn--s7qq40o.online/public/themes/web/www/controller/header.php ( 4.47 KB )
/www/wwwroot/zjmf.xn--s7qq40o.online/public/themes/web/www/controller/common.php ( 4.76 KB )
/www/wwwroot/zjmf.xn--s7qq40o.online/public/ewy/verify.php ( 22.01 KB )
/www/wwwroot/zjmf.xn--s7qq40o.online/public/ewy/debug.php ( 1.51 KB )
/www/wwwroot/zjmf.xn--s7qq40o.online/public/ewy/data.php ( 1.74 KB )
/www/wwwroot/zjmf.xn--s7qq40o.online/public/ewy/auth_encrypt.php ( 15.11 KB )
/www/wwwroot/zjmf.xn--s7qq40o.online/public/ewy/RedisCache.php ( 13.34 KB )
/www/wwwroot/zjmf.xn--s7qq40o.online/public/themes/web/www/controller/index.php ( 4.46 KB )
/www/wwwroot/zjmf.xn--s7qq40o.online/public/themes/cart/server/controller/side_conf.php ( 3.49 KB )
/www/wwwroot/zjmf.xn--s7qq40o.online/public/themes/cart/server/controller/cart.php ( 1.94 KB )
/www/wwwroot/zjmf.xn--s7qq40o.online/vendor/thinkphp/library/think/Response.php ( 9.92 KB )
/www/wwwroot/zjmf.xn--s7qq40o.online/vendor/thinkphp/library/think/debug/Html.php ( 4.02 KB )

[ LANG ] /www/wwwroot/zjmf.xn--s7qq40o.online/app/common/lang/zh-cn.php
[ DB ] INIT mysql
[ LANG ] /www/wwwroot/zjmf.xn--s7qq40o.online/vendor/thinkphp/lang/zh-cn.php
[ DB ] INIT mysql
[ ROUTE ] array ( 'rule' => 'cart', 'route' => 'home/viewCart/cart', 'option' => array ( 'merge_rule_regex' => false, 'header' => array ( 'Access-Control-Allow-Credentials' => 'true', 'Access-Control-Allow-Methods' => 'GET, POST, PATCH, PUT, DELETE', 'Access-Control-Allow-Headers' => 'Authorization, Content-Type, If-Match, If-Modified-Since, If-None-Match, If-Unmodified-Since, X-Requested-With', 'Access-Control-Allow-Origin' => '*', ), 'middleware' => array ( 0 => array ( 0 => 'UserCheck', 1 => NULL, ), ), 'cross_domain' => true, ), 'var' => array ( ), )
[ HEADER ] array ( 'cookie' => 'PHPSESSID=9jmnt53fn2tst5m7pqbjgsqtnp', 'accept-encoding' => 'gzip, br, zstd, deflate', 'user-agent' => 'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)', 'accept' => '*/*', 'host' => 'zjmf.xn--s7qq40o.online', 'content-length' => '', 'content-type' => '', )
[ PARAM ] array ( 'action' => 'configureproduct', 'pid' => '37', )
[ LANG ] /www/wwwroot/zjmf.xn--s7qq40o.online/vendor/thinkcmf/cmf/src/behavior/../lang/zh-cn.php
[ LANG ] /www/wwwroot/zjmf.xn--s7qq40o.online/vendor/thinkcmf/cmf-app/src/admin/lang/zh-cn.php
[ LANG ] /www/wwwroot/zjmf.xn--s7qq40o.online/vendor/thinkcmf/cmf-app/src/admin/lang/zh-cn/common.php
[ LANG ] /www/wwwroot/zjmf.xn--s7qq40o.online/vendor/thinkcmf/cmf-app/src/user/lang/zh-cn.php
[ LANG ] /www/wwwroot/zjmf.xn--s7qq40o.online/app/admin/lang/zh-cn/common.php
[ DB ] INIT mysql
[ VIEW ] /www/wwwroot/zjmf.xn--s7qq40o.online/public/themes/cart/server/configureproduct.tpl [ array ( 0 => 'site_info', 1 => 'Setting', 2 => 'Verify', 3 => 'CartConfig', 4 => 'Title', 5 => 'addParam', 6 => 'Userinfo', 7 => 'AllowType', 8 => 'ShowBreadcrumb', 9 => 'CartShopData', 10 => 'CustomDepot', 11 => 'Lang', 12 => 'LanguageCheck', 13 => 'Language', 14 => 'Ver', 15 => 'TplName', 16 => 'RouteName', 17 => 'Date', 18 => 'Token', 19 => 'Get', 20 => 'Post', 21 => 'Nav', 22 => 'userInfo', 23 => 'setting', 24 => 'www_top', 25 => 'www_bottom', 26 => 'f_links', ) ]

[ DB ] CONNECT:[ UseTime:0.000812s ] mysql:host=localhost;port=3306;dbname=zjmf376;charset=utf8mb4
[ SQL ] SHOW COLUMNS FROM `shd_plugin` [ RunTime:0.000484s ]
[ SQL ] SELECT * FROM `shd_plugin` WHERE `name` = 'AiAssistant' AND `status` = 1 LIMIT 1 [ RunTime:0.000263s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'shd_plugin', 'partitions' => NULL, 'type' => 'ALL', 'possible_keys' => NULL, 'key' => NULL, 'key_len' => NULL, 'ref' => NULL, 'rows' => 5, 'filtered' => 20.0, 'extra' => 'Using where', ) ]
[ SQL ] SELECT * FROM `shd_plugin` WHERE `name` = 'AutoProducts' AND `status` = 1 LIMIT 1 [ RunTime:0.000187s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'shd_plugin', 'partitions' => NULL, 'type' => 'ALL', 'possible_keys' => NULL, 'key' => NULL, 'key_len' => NULL, 'ref' => NULL, 'rows' => 5, 'filtered' => 20.0, 'extra' => 'Using where', ) ]
[ SQL ] SELECT * FROM `shd_plugin` WHERE `name` = 'LaiPintuanba' AND `status` = 1 LIMIT 1 [ RunTime:0.000179s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'shd_plugin', 'partitions' => NULL, 'type' => 'ALL', 'possible_keys' => NULL, 'key' => NULL, 'key_len' => NULL, 'ref' => NULL, 'rows' => 5, 'filtered' => 20.0, 'extra' => 'Using where', ) ]
[ SQL ] SHOW COLUMNS FROM `shd_hook_plugin` [ RunTime:0.000264s ]
[ SQL ] SELECT `hook`,`plugin` FROM `shd_hook_plugin` WHERE `status` = 1 AND `hook` IN ('ticket_add_note','ticket_admin_reply','ticket_close','ticket_delete','ticket_delete_reply','ticket_department_change','ticket_open','ticket_open_admin','ticket_status_change','ticket_title_change','ticket_user_reply','after_cron','before_cron','after_five_minute_cron','after_daily_cron','before_daily_cron','cron_config_save','after_module_change_package','after_module_change_package_failed','after_module_crack_password','after_module_crack_password_failed','after_module_create','after_module_create_failed','after_module_suspend','after_module_suspend_failed','after_module_terminate','after_module_terminate_failed','after_module_unsuspend','after_module_unsuspend_failed','after_module_on','after_module_on_failed','after_module_off','after_module_off_failed','after_module_reboot','after_module_reboot_failed','after_module_hard_off','after_module_hard_off_failed','after_module_hard_reboot','after_module_hard_reboot_failed','after_module_reinstall','after_module_reinstall_failed','after_module_rescue_system','after_module_rescue_system_failed','after_module_sync','after_module_sync_failed','before_module_change_package','before_module_crack_password','before_module_create','before_module_renew','before_module_suspend','before_module_terminate','before_module_unsuspend','before_module_on','before_module_off','before_module_reboot','before_module_hard_off','before_module_hard_reboot','before_module_reinstall','before_module_rescue_system','before_module_sync','after_admin_add_account','after_admin_edit_account','after_admin_delete_account','admin_logout','admin_login','auth_admin_login','add_admin','edit_admin','delete_admin','after_admin_edit_service','transfer_service','service_delete','product_delete','product_create','product_edit','cancellation_request','after_product_upgrade','invoice_paid_before_email','invoice_paid','invoice_mark_unpaid','invoice_mark_cancelled','invoice_delete','invoice_refunded','invoice_notes','renew_invoice_create','flow_packet_invoice_create','invoice_combine','order_pass_check','order_cancel','order_delete','client_add','client_edit','client_close','pre_client_delete','client_delete','custom_captcha_check','client_details_validate','client_login','client_api_login','client_reset_password','client_logout','shopping_cart_modify_num','shopping_cart_settle','shopping_cart_add_product','shopping_cart_remove_product','shopping_cart_clear','server_add','server_delete','server_edit','before_delete_log','log_activity','affiliate_activation','custom_field_save','before_email_send','custom_host_create','after_shop_add_promo','check_divert_invoice','product_divert_upgrade','product_divert_delete','before_create_ticket','host_status_custom','after_sign_contract','client_area_head_output','client_area_footer_output','template_after_servicedetail_suspended','template_after_service_domainstatus_selected','template_custom_clientarea_captcha_html') ORDER BY `list_order` ASC [ RunTime:0.000568s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'shd_hook_plugin', 'partitions' => NULL, 'type' => 'ALL', 'possible_keys' => NULL, 'key' => NULL, 'key_len' => NULL, 'ref' => NULL, 'rows' => 1, 'filtered' => 100.0, 'extra' => 'Using where; Using filesort', ) ]
[ SQL ] SELECT `value` FROM `shd_configuration` WHERE ( setting = 'cancellation_time' ) LIMIT 1 [ RunTime:0.000271s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'shd_configuration', 'partitions' => NULL, 'type' => 'ref', 'possible_keys' => 'setting', 'key' => 'setting', 'key_len' => '130', 'ref' => 'const', 'rows' => 1, 'filtered' => 100.0, 'extra' => 'Using where', ) ]
[ SQL ] SELECT `value` FROM `shd_configuration` WHERE ( setting = 'main_tenance_mode' ) LIMIT 1 [ RunTime:0.000162s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'shd_configuration', 'partitions' => NULL, 'type' => 'ref', 'possible_keys' => 'setting', 'key' => 'setting', 'key_len' => '130', 'ref' => 'const', 'rows' => 1, 'filtered' => 100.0, 'extra' => 'Using where', ) ]
[ SQL ] SHOW COLUMNS FROM `shd_clients` [ RunTime:0.000558s ]
[ SQL ] SELECT `status` FROM `shd_clients` WHERE `id` IS NULL LIMIT 1 [ RunTime:0.000147s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => NULL, 'partitions' => NULL, 'type' => NULL, 'possible_keys' => NULL, 'key' => NULL, 'key_len' => NULL, 'ref' => NULL, 'rows' => NULL, 'filtered' => NULL, 'extra' => 'Impossible WHERE', ) ]
[ SQL ] SELECT `value` FROM `shd_configuration` WHERE ( setting = 'cookie_clientarea_nmae' ) LIMIT 1 [ RunTime:0.000145s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'shd_configuration', 'partitions' => NULL, 'type' => 'ref', 'possible_keys' => 'setting', 'key' => 'setting', 'key_len' => '130', 'ref' => 'const', 'rows' => 1, 'filtered' => 100.0, 'extra' => 'Using where', ) ]
[ SQL ] SHOW COLUMNS FROM `shd_hook` [ RunTime:0.000278s ]
[ SQL ] SELECT `hook` FROM `shd_hook` WHERE `app` = 'home' [ RunTime:0.000151s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'shd_hook', 'partitions' => NULL, 'type' => 'ALL', 'possible_keys' => NULL, 'key' => NULL, 'key_len' => NULL, 'ref' => NULL, 'rows' => 25, 'filtered' => 10.0, 'extra' => 'Using where', ) ]
[ SQL ] SELECT `hook`,`plugin` FROM `shd_hook_plugin` WHERE `status` = 1 AND `hook` IN ('home_user_action_log_add','global_alipay_handle','user_test','wxpay_handle','global_wxpay_handle') ORDER BY `list_order` ASC [ RunTime:0.000183s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'shd_hook_plugin', 'partitions' => NULL, 'type' => 'ALL', 'possible_keys' => NULL, 'key' => NULL, 'key_len' => NULL, 'ref' => NULL, 'rows' => 1, 'filtered' => 100.0, 'extra' => 'Using where; Using filesort', ) ]
[ SQL ] SELECT `value` FROM `shd_configuration` WHERE ( setting = 'cancellation_time' ) LIMIT 1 [ RunTime:0.000189s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'shd_configuration', 'partitions' => NULL, 'type' => 'ref', 'possible_keys' => 'setting', 'key' => 'setting', 'key_len' => '130', 'ref' => 'const', 'rows' => 1, 'filtered' => 100.0, 'extra' => 'Using where', ) ]
[ SQL ] SELECT `value` FROM `shd_configuration` WHERE ( setting = 'domain' ) LIMIT 1 [ RunTime:0.000172s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'shd_configuration', 'partitions' => NULL, 'type' => 'ref', 'possible_keys' => 'setting', 'key' => 'setting', 'key_len' => '130', 'ref' => 'const', 'rows' => 1, 'filtered' => 100.0, 'extra' => 'Using where', ) ]
[ SQL ] SELECT `value` FROM `shd_configuration` WHERE ( setting = 'main_tenance_mode' ) LIMIT 1 [ RunTime:0.000138s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'shd_configuration', 'partitions' => NULL, 'type' => 'ref', 'possible_keys' => 'setting', 'key' => 'setting', 'key_len' => '130', 'ref' => 'const', 'rows' => 1, 'filtered' => 100.0, 'extra' => 'Using where', ) ]
[ SQL ] SELECT `id` FROM `shd_clients` WHERE `id` IS NULL LIMIT 1 [ RunTime:0.000131s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => NULL, 'partitions' => NULL, 'type' => NULL, 'possible_keys' => NULL, 'key' => NULL, 'key_len' => NULL, 'ref' => NULL, 'rows' => NULL, 'filtered' => NULL, 'extra' => 'Impossible WHERE', ) ]
[ SQL ] SELECT `status` FROM `shd_clients` WHERE `id` IS NULL LIMIT 1 [ RunTime:0.000124s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => NULL, 'partitions' => NULL, 'type' => NULL, 'possible_keys' => NULL, 'key' => NULL, 'key_len' => NULL, 'ref' => NULL, 'rows' => NULL, 'filtered' => NULL, 'extra' => 'Impossible WHERE', ) ]
[ SQL ] SELECT `value` FROM `shd_configuration` WHERE ( setting = 'VIEW_TEMPLATE_SETTING_NAME' ) LIMIT 1 [ RunTime:0.000239s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'shd_configuration', 'partitions' => NULL, 'type' => 'ref', 'possible_keys' => 'setting', 'key' => 'setting', 'key_len' => '130', 'ref' => 'const', 'rows' => 1, 'filtered' => 100.0, 'extra' => 'Using where', ) ]
[ SQL ] SELECT `value` FROM `shd_configuration` WHERE ( setting = 'zjmf_authorize' ) LIMIT 1 [ RunTime:0.000162s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'shd_configuration', 'partitions' => NULL, 'type' => 'ref', 'possible_keys' => 'setting', 'key' => 'setting', 'key_len' => '130', 'ref' => 'const', 'rows' => 1, 'filtered' => 100.0, 'extra' => 'Using where', ) ]
[ SQL ] SHOW COLUMNS FROM `shd_products` [ RunTime:0.000714s ]
[ SQL ] SELECT * FROM `shd_products` WHERE `id` = 37 LIMIT 1 [ RunTime:0.000383s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'shd_products', 'partitions' => NULL, 'type' => 'const', 'possible_keys' => 'PRIMARY', 'key' => 'PRIMARY', 'key_len' => '4', 'ref' => 'const', 'rows' => 1, 'filtered' => 100.0, 'extra' => NULL, ) ]
[ SQL ] SHOW COLUMNS FROM `shd_zjmf_finance_api` [ RunTime:0.000291s ]
[ SQL ] SELECT * FROM `shd_zjmf_finance_api` WHERE `type` = 'v10' AND `id` = 3 LIMIT 1 [ RunTime:0.000186s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => NULL, 'partitions' => NULL, 'type' => NULL, 'possible_keys' => NULL, 'key' => NULL, 'key_len' => NULL, 'ref' => NULL, 'rows' => NULL, 'filtered' => NULL, 'extra' => 'Impossible WHERE noticed after reading const tables', ) ]
[ SQL ] SELECT * FROM `shd_products` WHERE `id` = 37 LIMIT 1 [ RunTime:0.000301s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'shd_products', 'partitions' => NULL, 'type' => 'const', 'possible_keys' => 'PRIMARY', 'key' => 'PRIMARY', 'key_len' => '4', 'ref' => 'const', 'rows' => 1, 'filtered' => 100.0, 'extra' => NULL, ) ]
[ SQL ] SELECT * FROM `shd_zjmf_finance_api` WHERE `id` = 3 LIMIT 1 [ RunTime:0.000150s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'shd_zjmf_finance_api', 'partitions' => NULL, 'type' => 'const', 'possible_keys' => 'PRIMARY', 'key' => 'PRIMARY', 'key_len' => '4', 'ref' => 'const', 'rows' => 1, 'filtered' => 100.0, 'extra' => NULL, ) ]
[ SQL ] SELECT * FROM `shd_products` WHERE `id` = 37 LIMIT 1 [ RunTime:0.000364s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'shd_products', 'partitions' => NULL, 'type' => 'const', 'possible_keys' => 'PRIMARY', 'key' => 'PRIMARY', 'key_len' => '4', 'ref' => 'const', 'rows' => 1, 'filtered' => 100.0, 'extra' => NULL, ) ]
[ SQL ] SELECT * FROM `shd_zjmf_finance_api` WHERE `id` = 3 LIMIT 1 [ RunTime:0.000162s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'shd_zjmf_finance_api', 'partitions' => NULL, 'type' => 'const', 'possible_keys' => 'PRIMARY', 'key' => 'PRIMARY', 'key_len' => '4', 'ref' => 'const', 'rows' => 1, 'filtered' => 100.0, 'extra' => NULL, ) ]
[ SQL ] SELECT * FROM `shd_zjmf_finance_api` WHERE `id` = 3 LIMIT 1 [ RunTime:0.000145s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'shd_zjmf_finance_api', 'partitions' => NULL, 'type' => 'const', 'possible_keys' => 'PRIMARY', 'key' => 'PRIMARY', 'key_len' => '4', 'ref' => 'const', 'rows' => 1, 'filtered' => 100.0, 'extra' => NULL, ) ]
[ SQL ] SHOW COLUMNS FROM `shd_currencies` [ RunTime:0.000846s ]
[ SQL ] SELECT `code` FROM `shd_currencies` WHERE `default` = 1 LIMIT 1 [ RunTime:0.000333s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'shd_currencies', 'partitions' => NULL, 'type' => 'ref', 'possible_keys' => 'default', 'key' => 'default', 'key_len' => '1', 'ref' => 'const', 'rows' => 1, 'filtered' => 100.0, 'extra' => NULL, ) ]
[ SQL ] SELECT `s`.`id`,`s`.`name`,`s`.`noc` FROM `shd_products` `p` LEFT JOIN `shd_server_groups` `sg` ON `sg`.`id`=`p`.`server_group` LEFT JOIN `shd_servers` `s` ON `s`.`gid`=`sg`.`id` WHERE `p`.`id` = 37 [ RunTime:0.000316s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'p', 'partitions' => NULL, 'type' => 'const', 'possible_keys' => 'PRIMARY', 'key' => 'PRIMARY', 'key_len' => '4', 'ref' => 'const', 'rows' => 1, 'filtered' => 100.0, 'extra' => NULL, ) ]
[ SQL ] SELECT * FROM `shd_currencies` WHERE `id` = 0 LIMIT 1 [ RunTime:0.000225s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => NULL, 'partitions' => NULL, 'type' => NULL, 'possible_keys' => NULL, 'key' => NULL, 'key_len' => NULL, 'ref' => NULL, 'rows' => NULL, 'filtered' => NULL, 'extra' => 'no matching row in const table', ) ]
[ SQL ] SELECT `currency` FROM `shd_clients` WHERE `id` IS NULL LIMIT 1 [ RunTime:0.000155s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => NULL, 'partitions' => NULL, 'type' => NULL, 'possible_keys' => NULL, 'key' => NULL, 'key_len' => NULL, 'ref' => NULL, 'rows' => NULL, 'filtered' => NULL, 'extra' => 'Impossible WHERE', ) ]
[ DB ] CONNECT:[ UseTime:0.000827s ] mysql:host=localhost;port=3306;dbname=zjmf376;charset=utf8mb4
[ SQL ] SELECT `id` FROM `shd_currencies` WHERE `default` = 1 LIMIT 1 [ RunTime:0.000261s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'shd_currencies', 'partitions' => NULL, 'type' => 'ref', 'possible_keys' => 'default', 'key' => 'default', 'key_len' => '1', 'ref' => 'const', 'rows' => 1, 'filtered' => 100.0, 'extra' => 'Using index', ) ]
[ SQL ] SELECT `id`,`code`,`prefix`,`suffix` FROM `shd_currencies` [ RunTime:0.000147s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'shd_currencies', 'partitions' => NULL, 'type' => 'ALL', 'possible_keys' => NULL, 'key' => NULL, 'key_len' => NULL, 'ref' => NULL, 'rows' => 1, 'filtered' => 100.0, 'extra' => NULL, ) ]
[ SQL ] SELECT * FROM `shd_products` WHERE `id` = 37 LIMIT 1 [ RunTime:0.000475s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'shd_products', 'partitions' => NULL, 'type' => 'const', 'possible_keys' => 'PRIMARY', 'key' => 'PRIMARY', 'key_len' => '4', 'ref' => 'const', 'rows' => 1, 'filtered' => 100.0, 'extra' => NULL, ) ]
[ SQL ] SHOW COLUMNS FROM `shd_pricing` [ RunTime:0.000439s ]
[ SQL ] SELECT * FROM `shd_pricing` WHERE `type` = 'product' AND `currency` = 1 AND `relid` = 37 LIMIT 1 [ RunTime:0.000333s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'shd_pricing', 'partitions' => NULL, 'type' => 'ref', 'possible_keys' => 'typerelid', 'key' => 'typerelid', 'key_len' => '5', 'ref' => 'const,const', 'rows' => 1, 'filtered' => 10.0, 'extra' => 'Using where', ) ]
[ SQL ] SHOW COLUMNS FROM `shd_customfields` [ RunTime:0.000324s ]
[ SQL ] SELECT `id`,`fieldname`,`description`,`fieldtype`,`fieldoptions`,`regexpr`,`required` FROM `shd_customfields` WHERE `type` = 'product' AND `relid` = 37 AND `showorder` = 1 ORDER BY `sortorder` DESC [ RunTime:0.000281s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'shd_customfields', 'partitions' => NULL, 'type' => 'ref', 'possible_keys' => 'serviceid,type', 'key' => 'serviceid', 'key_len' => '4', 'ref' => 'const', 'rows' => 1, 'filtered' => 100.0, 'extra' => 'Using index condition; Using where; Using filesort', ) ]
[ SQL ] SELECT `id`,`name`,`description`,`pay_type`,`host`,`password`,`allow_qty`,`stock_control`,`qty` FROM `shd_products` WHERE `id` = 37 LIMIT 1 [ RunTime:0.000208s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'shd_products', 'partitions' => NULL, 'type' => 'const', 'possible_keys' => 'PRIMARY', 'key' => 'PRIMARY', 'key_len' => '4', 'ref' => 'const', 'rows' => 1, 'filtered' => 100.0, 'extra' => NULL, ) ]
[ SQL ] SELECT * FROM `shd_pricing` WHERE `type` = 'product' AND `relid` = 37 AND `currency` = 1 LIMIT 1 [ RunTime:0.000272s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'shd_pricing', 'partitions' => NULL, 'type' => 'ref', 'possible_keys' => 'typerelid', 'key' => 'typerelid', 'key_len' => '5', 'ref' => 'const,const', 'rows' => 1, 'filtered' => 10.0, 'extra' => 'Using where', ) ]
[ SQL ] SELECT pcg.id as pcgid,p.id as pid,`pcg`.`name`,`pcg`.`description`,`pco`.`id`,`pco`.`is_discount`,`pco`.`option_name`,`pco`.`linkage_pid`,`pco`.`linkage_top_pid`,`pco`.`option_type`,`pco`.`qty_minimum`,`pco`.`qty_maximum`,`pco`.`order`,`pco`.`hidden`,`pco`.`upstream_id`,`pco`.`upgrade`,`pco`.`auto`,`pco`.`notes`,`pco`.`qty_stage`,`pco`.`unit` FROM `shd_products` `p` INNER JOIN `shd_product_config_links` `pcl` ON `pcl`.`pid`=`p`.`id` INNER JOIN `shd_product_config_groups` `pcg` ON `pcg`.`id`=`pcl`.`gid` LEFT JOIN `shd_product_config_options` `pco` ON `pco`.`gid`=`pcg`.`id` WHERE `p`.`id` = 37 AND ( `pco`.`hidden` = 0 ) ORDER BY `pco`.`order` ASC,`pco`.`id` ASC [ RunTime:0.007453s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'p', 'partitions' => NULL, 'type' => 'const', 'possible_keys' => 'PRIMARY', 'key' => 'PRIMARY', 'key_len' => '4', 'ref' => 'const', 'rows' => 1, 'filtered' => 100.0, 'extra' => 'Using index; Using temporary; Using filesort', ) ]
[ SQL ] SELECT `api_type`,`upstream_price_type`,`upstream_price_value` FROM `shd_products` WHERE `id` = 37 LIMIT 1 [ RunTime:0.000138s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'shd_products', 'partitions' => NULL, 'type' => 'const', 'possible_keys' => 'PRIMARY', 'key' => 'PRIMARY', 'key_len' => '4', 'ref' => 'const', 'rows' => 1, 'filtered' => 100.0, 'extra' => NULL, ) ]
[ SQL ] SHOW COLUMNS FROM `shd_product_config_options_sub` [ RunTime:0.000414s ]
[ SQL ] SELECT * FROM `shd_product_config_options_sub` WHERE `config_id` = 161 AND ( `hidden` = 0 ) ORDER BY `sort_order` ASC,`id` ASC [ RunTime:0.000258s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'shd_product_config_options_sub', 'partitions' => NULL, 'type' => 'ref', 'possible_keys' => 'configid', 'key' => 'configid', 'key_len' => '5', 'ref' => 'const,const', 'rows' => 1, 'filtered' => 100.0, 'extra' => 'Using index condition; Using filesort', ) ]
[ SQL ] SELECT * FROM `shd_pricing` WHERE `type` = 'configoptions' AND `relid` = 533 [ RunTime:0.000256s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'shd_pricing', 'partitions' => NULL, 'type' => 'ref', 'possible_keys' => 'typerelid', 'key' => 'typerelid', 'key_len' => '5', 'ref' => 'const,const', 'rows' => 1, 'filtered' => 100.0, 'extra' => NULL, ) ]
[ SQL ] SELECT * FROM `shd_product_config_options_sub` WHERE `config_id` = 168 AND ( `hidden` = 0 ) ORDER BY `sort_order` ASC,`id` ASC [ RunTime:0.000344s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'shd_product_config_options_sub', 'partitions' => NULL, 'type' => 'ref', 'possible_keys' => 'configid', 'key' => 'configid', 'key_len' => '5', 'ref' => 'const,const', 'rows' => 29, 'filtered' => 100.0, 'extra' => 'Using index condition; Using filesort', ) ]
[ SQL ] SELECT * FROM `shd_pricing` WHERE `type` = 'configoptions' AND `relid` = 541 [ RunTime:0.000281s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'shd_pricing', 'partitions' => NULL, 'type' => 'ref', 'possible_keys' => 'typerelid', 'key' => 'typerelid', 'key_len' => '5', 'ref' => 'const,const', 'rows' => 1, 'filtered' => 100.0, 'extra' => NULL, ) ]
[ SQL ] SELECT * FROM `shd_pricing` WHERE `type` = 'configoptions' AND `relid` = 542 [ RunTime:0.000291s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'shd_pricing', 'partitions' => NULL, 'type' => 'ref', 'possible_keys' => 'typerelid', 'key' => 'typerelid', 'key_len' => '5', 'ref' => 'const,const', 'rows' => 1, 'filtered' => 100.0, 'extra' => NULL, ) ]
[ SQL ] SELECT * FROM `shd_pricing` WHERE `type` = 'configoptions' AND `relid` = 543 [ RunTime:0.000230s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'shd_pricing', 'partitions' => NULL, 'type' => 'ref', 'possible_keys' => 'typerelid', 'key' => 'typerelid', 'key_len' => '5', 'ref' => 'const,const', 'rows' => 1, 'filtered' => 100.0, 'extra' => NULL, ) ]
[ SQL ] SELECT * FROM `shd_pricing` WHERE `type` = 'configoptions' AND `relid` = 544 [ RunTime:0.000273s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'shd_pricing', 'partitions' => NULL, 'type' => 'ref', 'possible_keys' => 'typerelid', 'key' => 'typerelid', 'key_len' => '5', 'ref' => 'const,const', 'rows' => 1, 'filtered' => 100.0, 'extra' => NULL, ) ]
[ SQL ] SELECT * FROM `shd_pricing` WHERE `type` = 'configoptions' AND `relid` = 545 [ RunTime:0.000223s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'shd_pricing', 'partitions' => NULL, 'type' => 'ref', 'possible_keys' => 'typerelid', 'key' => 'typerelid', 'key_len' => '5', 'ref' => 'const,const', 'rows' => 1, 'filtered' => 100.0, 'extra' => NULL, ) ]
[ SQL ] SELECT * FROM `shd_pricing` WHERE `type` = 'configoptions' AND `relid` = 546 [ RunTime:0.000227s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'shd_pricing', 'partitions' => NULL, 'type' => 'ref', 'possible_keys' => 'typerelid', 'key' => 'typerelid', 'key_len' => '5', 'ref' => 'const,const', 'rows' => 1, 'filtered' => 100.0, 'extra' => NULL, ) ]
[ SQL ] SELECT * FROM `shd_pricing` WHERE `type` = 'configoptions' AND `relid` = 547 [ RunTime:0.000210s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'shd_pricing', 'partitions' => NULL, 'type' => 'ref', 'possible_keys' => 'typerelid', 'key' => 'typerelid', 'key_len' => '5', 'ref' => 'const,const', 'rows' => 1, 'filtered' => 100.0, 'extra' => NULL, ) ]
[ SQL ] SELECT * FROM `shd_pricing` WHERE `type` = 'configoptions' AND `relid` = 548 [ RunTime:0.000230s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'shd_pricing', 'partitions' => NULL, 'type' => 'ref', 'possible_keys' => 'typerelid', 'key' => 'typerelid', 'key_len' => '5', 'ref' => 'const,const', 'rows' => 1, 'filtered' => 100.0, 'extra' => NULL, ) ]
[ SQL ] SELECT * FROM `shd_pricing` WHERE `type` = 'configoptions' AND `relid` = 549 [ RunTime:0.000251s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'shd_pricing', 'partitions' => NULL, 'type' => 'ref', 'possible_keys' => 'typerelid', 'key' => 'typerelid', 'key_len' => '5', 'ref' => 'const,const', 'rows' => 1, 'filtered' => 100.0, 'extra' => NULL, ) ]
[ SQL ] SELECT * FROM `shd_pricing` WHERE `type` = 'configoptions' AND `relid` = 550 [ RunTime:0.000239s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'shd_pricing', 'partitions' => NULL, 'type' => 'ref', 'possible_keys' => 'typerelid', 'key' => 'typerelid', 'key_len' => '5', 'ref' => 'const,const', 'rows' => 1, 'filtered' => 100.0, 'extra' => NULL, ) ]
[ SQL ] SELECT * FROM `shd_pricing` WHERE `type` = 'configoptions' AND `relid` = 551 [ RunTime:0.000292s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'shd_pricing', 'partitions' => NULL, 'type' => 'ref', 'possible_keys' => 'typerelid', 'key' => 'typerelid', 'key_len' => '5', 'ref' => 'const,const', 'rows' => 1, 'filtered' => 100.0, 'extra' => NULL, ) ]
[ SQL ] SELECT * FROM `shd_pricing` WHERE `type` = 'configoptions' AND `relid` = 552 [ RunTime:0.000310s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'shd_pricing', 'partitions' => NULL, 'type' => 'ref', 'possible_keys' => 'typerelid', 'key' => 'typerelid', 'key_len' => '5', 'ref' => 'const,const', 'rows' => 1, 'filtered' => 100.0, 'extra' => NULL, ) ]
[ SQL ] SELECT * FROM `shd_pricing` WHERE `type` = 'configoptions' AND `relid` = 553 [ RunTime:0.000280s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'shd_pricing', 'partitions' => NULL, 'type' => 'ref', 'possible_keys' => 'typerelid', 'key' => 'typerelid', 'key_len' => '5', 'ref' => 'const,const', 'rows' => 1, 'filtered' => 100.0, 'extra' => NULL, ) ]
[ SQL ] SELECT * FROM `shd_pricing` WHERE `type` = 'configoptions' AND `relid` = 554 [ RunTime:0.000297s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'shd_pricing', 'partitions' => NULL, 'type' => 'ref', 'possible_keys' => 'typerelid', 'key' => 'typerelid', 'key_len' => '5', 'ref' => 'const,const', 'rows' => 1, 'filtered' => 100.0, 'extra' => NULL, ) ]
[ SQL ] SELECT * FROM `shd_pricing` WHERE `type` = 'configoptions' AND `relid` = 555 [ RunTime:0.000241s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'shd_pricing', 'partitions' => NULL, 'type' => 'ref', 'possible_keys' => 'typerelid', 'key' => 'typerelid', 'key_len' => '5', 'ref' => 'const,const', 'rows' => 1, 'filtered' => 100.0, 'extra' => NULL, ) ]
[ SQL ] SELECT * FROM `shd_pricing` WHERE `type` = 'configoptions' AND `relid` = 556 [ RunTime:0.000289s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'shd_pricing', 'partitions' => NULL, 'type' => 'ref', 'possible_keys' => 'typerelid', 'key' => 'typerelid', 'key_len' => '5', 'ref' => 'const,const', 'rows' => 1, 'filtered' => 100.0, 'extra' => NULL, ) ]
[ SQL ] SELECT * FROM `shd_pricing` WHERE `type` = 'configoptions' AND `relid` = 557 [ RunTime:0.000261s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'shd_pricing', 'partitions' => NULL, 'type' => 'ref', 'possible_keys' => 'typerelid', 'key' => 'typerelid', 'key_len' => '5', 'ref' => 'const,const', 'rows' => 1, 'filtered' => 100.0, 'extra' => NULL, ) ]
[ SQL ] SELECT * FROM `shd_pricing` WHERE `type` = 'configoptions' AND `relid` = 558 [ RunTime:0.000248s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'shd_pricing', 'partitions' => NULL, 'type' => 'ref', 'possible_keys' => 'typerelid', 'key' => 'typerelid', 'key_len' => '5', 'ref' => 'const,const', 'rows' => 1, 'filtered' => 100.0, 'extra' => NULL, ) ]
[ SQL ] SELECT * FROM `shd_pricing` WHERE `type` = 'configoptions' AND `relid` = 559 [ RunTime:0.000228s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'shd_pricing', 'partitions' => NULL, 'type' => 'ref', 'possible_keys' => 'typerelid', 'key' => 'typerelid', 'key_len' => '5', 'ref' => 'const,const', 'rows' => 1, 'filtered' => 100.0, 'extra' => NULL, ) ]
[ SQL ] SELECT * FROM `shd_pricing` WHERE `type` = 'configoptions' AND `relid` = 560 [ RunTime:0.000242s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'shd_pricing', 'partitions' => NULL, 'type' => 'ref', 'possible_keys' => 'typerelid', 'key' => 'typerelid', 'key_len' => '5', 'ref' => 'const,const', 'rows' => 1, 'filtered' => 100.0, 'extra' => NULL, ) ]
[ SQL ] SELECT * FROM `shd_pricing` WHERE `type` = 'configoptions' AND `relid` = 561 [ RunTime:0.000257s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'shd_pricing', 'partitions' => NULL, 'type' => 'ref', 'possible_keys' => 'typerelid', 'key' => 'typerelid', 'key_len' => '5', 'ref' => 'const,const', 'rows' => 1, 'filtered' => 100.0, 'extra' => NULL, ) ]
[ SQL ] SELECT * FROM `shd_pricing` WHERE `type` = 'configoptions' AND `relid` = 562 [ RunTime:0.000227s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'shd_pricing', 'partitions' => NULL, 'type' => 'ref', 'possible_keys' => 'typerelid', 'key' => 'typerelid', 'key_len' => '5', 'ref' => 'const,const', 'rows' => 1, 'filtered' => 100.0, 'extra' => NULL, ) ]
[ SQL ] SELECT * FROM `shd_pricing` WHERE `type` = 'configoptions' AND `relid` = 563 [ RunTime:0.000224s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'shd_pricing', 'partitions' => NULL, 'type' => 'ref', 'possible_keys' => 'typerelid', 'key' => 'typerelid', 'key_len' => '5', 'ref' => 'const,const', 'rows' => 1, 'filtered' => 100.0, 'extra' => NULL, ) ]
[ SQL ] SELECT * FROM `shd_pricing` WHERE `type` = 'configoptions' AND `relid` = 564 [ RunTime:0.000229s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'shd_pricing', 'partitions' => NULL, 'type' => 'ref', 'possible_keys' => 'typerelid', 'key' => 'typerelid', 'key_len' => '5', 'ref' => 'const,const', 'rows' => 1, 'filtered' => 100.0, 'extra' => NULL, ) ]
[ SQL ] SELECT * FROM `shd_pricing` WHERE `type` = 'configoptions' AND `relid` = 565 [ RunTime:0.000241s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'shd_pricing', 'partitions' => NULL, 'type' => 'ref', 'possible_keys' => 'typerelid', 'key' => 'typerelid', 'key_len' => '5', 'ref' => 'const,const', 'rows' => 1, 'filtered' => 100.0, 'extra' => NULL, ) ]
[ SQL ] SELECT * FROM `shd_pricing` WHERE `type` = 'configoptions' AND `relid` = 566 [ RunTime:0.000250s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'shd_pricing', 'partitions' => NULL, 'type' => 'ref', 'possible_keys' => 'typerelid', 'key' => 'typerelid', 'key_len' => '5', 'ref' => 'const,const', 'rows' => 1, 'filtered' => 100.0, 'extra' => NULL, ) ]
[ SQL ] SELECT * FROM `shd_pricing` WHERE `type` = 'configoptions' AND `relid` = 567 [ RunTime:0.000262s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'shd_pricing', 'partitions' => NULL, 'type' => 'ref', 'possible_keys' => 'typerelid', 'key' => 'typerelid', 'key_len' => '5', 'ref' => 'const,const', 'rows' => 1, 'filtered' => 100.0, 'extra' => NULL, ) ]
[ SQL ] SELECT * FROM `shd_pricing` WHERE `type` = 'configoptions' AND `relid` = 568 [ RunTime:0.000248s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'shd_pricing', 'partitions' => NULL, 'type' => 'ref', 'possible_keys' => 'typerelid', 'key' => 'typerelid', 'key_len' => '5', 'ref' => 'const,const', 'rows' => 1, 'filtered' => 100.0, 'extra' => NULL, ) ]
[ SQL ] SELECT * FROM `shd_pricing` WHERE `type` = 'configoptions' AND `relid` = 569 [ RunTime:0.000234s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'shd_pricing', 'partitions' => NULL, 'type' => 'ref', 'possible_keys' => 'typerelid', 'key' => 'typerelid', 'key_len' => '5', 'ref' => 'const,const', 'rows' => 1, 'filtered' => 100.0, 'extra' => NULL, ) ]
[ SQL ] SELECT * FROM `shd_product_config_options_sub` WHERE `config_id` = 162 AND ( `hidden` = 0 ) ORDER BY `sort_order` ASC,`id` ASC [ RunTime:0.000220s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'shd_product_config_options_sub', 'partitions' => NULL, 'type' => 'ref', 'possible_keys' => 'configid', 'key' => 'configid', 'key_len' => '5', 'ref' => 'const,const', 'rows' => 1, 'filtered' => 100.0, 'extra' => 'Using index condition; Using filesort', ) ]
[ SQL ] SELECT * FROM `shd_pricing` WHERE `type` = 'configoptions' AND `relid` = 534 [ RunTime:0.000249s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'shd_pricing', 'partitions' => NULL, 'type' => 'ref', 'possible_keys' => 'typerelid', 'key' => 'typerelid', 'key_len' => '5', 'ref' => 'const,const', 'rows' => 1, 'filtered' => 100.0, 'extra' => NULL, ) ]
[ SQL ] SELECT * FROM `shd_product_config_options_sub` WHERE `config_id` = 163 AND ( `hidden` = 0 ) ORDER BY `sort_order` ASC,`id` ASC [ RunTime:0.000200s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'shd_product_config_options_sub', 'partitions' => NULL, 'type' => 'ref', 'possible_keys' => 'configid', 'key' => 'configid', 'key_len' => '5', 'ref' => 'const,const', 'rows' => 1, 'filtered' => 100.0, 'extra' => 'Using index condition; Using filesort', ) ]
[ SQL ] SELECT * FROM `shd_pricing` WHERE `type` = 'configoptions' AND `relid` = 535 [ RunTime:0.000235s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'shd_pricing', 'partitions' => NULL, 'type' => 'ref', 'possible_keys' => 'typerelid', 'key' => 'typerelid', 'key_len' => '5', 'ref' => 'const,const', 'rows' => 1, 'filtered' => 100.0, 'extra' => NULL, ) ]
[ SQL ] SELECT * FROM `shd_product_config_options_sub` WHERE `config_id` = 164 AND ( `hidden` = 0 ) ORDER BY `sort_order` ASC,`id` ASC [ RunTime:0.000218s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'shd_product_config_options_sub', 'partitions' => NULL, 'type' => 'ref', 'possible_keys' => 'configid', 'key' => 'configid', 'key_len' => '5', 'ref' => 'const,const', 'rows' => 1, 'filtered' => 100.0, 'extra' => 'Using index condition; Using filesort', ) ]
[ SQL ] SELECT * FROM `shd_pricing` WHERE `type` = 'configoptions' AND `relid` = 536 [ RunTime:0.000239s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'shd_pricing', 'partitions' => NULL, 'type' => 'ref', 'possible_keys' => 'typerelid', 'key' => 'typerelid', 'key_len' => '5', 'ref' => 'const,const', 'rows' => 1, 'filtered' => 100.0, 'extra' => NULL, ) ]
[ SQL ] SELECT * FROM `shd_product_config_options_sub` WHERE `config_id` = 166 AND ( `hidden` = 0 ) ORDER BY `sort_order` ASC,`id` ASC [ RunTime:0.000216s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'shd_product_config_options_sub', 'partitions' => NULL, 'type' => 'ref', 'possible_keys' => 'configid', 'key' => 'configid', 'key_len' => '5', 'ref' => 'const,const', 'rows' => 1, 'filtered' => 100.0, 'extra' => 'Using index condition; Using filesort', ) ]
[ SQL ] SELECT * FROM `shd_pricing` WHERE `type` = 'configoptions' AND `relid` = 539 [ RunTime:0.000234s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'shd_pricing', 'partitions' => NULL, 'type' => 'ref', 'possible_keys' => 'typerelid', 'key' => 'typerelid', 'key_len' => '5', 'ref' => 'const,const', 'rows' => 1, 'filtered' => 100.0, 'extra' => NULL, ) ]
[ SQL ] SELECT * FROM `shd_product_config_options_sub` WHERE `config_id` = 167 AND ( `hidden` = 0 ) ORDER BY `sort_order` ASC,`id` ASC [ RunTime:0.000203s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'shd_product_config_options_sub', 'partitions' => NULL, 'type' => 'ref', 'possible_keys' => 'configid', 'key' => 'configid', 'key_len' => '5', 'ref' => 'const,const', 'rows' => 1, 'filtered' => 100.0, 'extra' => 'Using index condition; Using filesort', ) ]
[ SQL ] SELECT * FROM `shd_pricing` WHERE `type` = 'configoptions' AND `relid` = 540 [ RunTime:0.000234s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'shd_pricing', 'partitions' => NULL, 'type' => 'ref', 'possible_keys' => 'typerelid', 'key' => 'typerelid', 'key_len' => '5', 'ref' => 'const,const', 'rows' => 1, 'filtered' => 100.0, 'extra' => NULL, ) ]
[ SQL ] SELECT * FROM `shd_product_config_options_sub` WHERE `config_id` = 165 AND ( `hidden` = 0 ) ORDER BY `sort_order` ASC,`id` ASC [ RunTime:0.000224s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'shd_product_config_options_sub', 'partitions' => NULL, 'type' => 'ref', 'possible_keys' => 'configid', 'key' => 'configid', 'key_len' => '5', 'ref' => 'const,const', 'rows' => 2, 'filtered' => 100.0, 'extra' => 'Using index condition; Using filesort', ) ]
[ SQL ] SELECT * FROM `shd_pricing` WHERE `type` = 'configoptions' AND `relid` = 537 [ RunTime:0.000248s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'shd_pricing', 'partitions' => NULL, 'type' => 'ref', 'possible_keys' => 'typerelid', 'key' => 'typerelid', 'key_len' => '5', 'ref' => 'const,const', 'rows' => 1, 'filtered' => 100.0, 'extra' => NULL, ) ]
[ SQL ] SELECT * FROM `shd_pricing` WHERE `type` = 'configoptions' AND `relid` = 538 [ RunTime:0.000259s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'shd_pricing', 'partitions' => NULL, 'type' => 'ref', 'possible_keys' => 'typerelid', 'key' => 'typerelid', 'key_len' => '5', 'ref' => 'const,const', 'rows' => 1, 'filtered' => 100.0, 'extra' => NULL, ) ]
[ SQL ] SELECT `id`,`prefix`,`suffix` FROM `shd_currencies` WHERE `id` = 1 LIMIT 1 [ RunTime:0.000176s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'shd_currencies', 'partitions' => NULL, 'type' => 'const', 'possible_keys' => 'PRIMARY', 'key' => 'PRIMARY', 'key_len' => '4', 'ref' => 'const', 'rows' => 1, 'filtered' => 100.0, 'extra' => NULL, ) ]
[ SQL ] SHOW COLUMNS FROM `shd_user_product_bates` [ RunTime:0.000532s ]
[ SQL ] SELECT `a`.`type`,`a`.`bates` FROM `shd_user_product_bates` `a` LEFT JOIN `shd_user_products` `b` ON `a`.`products`=`b`.`gid` LEFT JOIN `shd_clients` `c` ON `a`.`user`=`c`.`groupid` WHERE `c`.`id` = 0 AND `b`.`pid` = 37 LIMIT 1 [ RunTime:0.000443s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => NULL, 'partitions' => NULL, 'type' => NULL, 'possible_keys' => NULL, 'key' => NULL, 'key_len' => NULL, 'ref' => NULL, 'rows' => NULL, 'filtered' => NULL, 'extra' => 'no matching row in const table', ) ]
[ SQL ] SELECT `a`.`type`,`a`.`bates` FROM `shd_user_product_bates` `a` LEFT JOIN `shd_user_products` `b` ON `a`.`products`=`b`.`gid` LEFT JOIN `shd_clients` `c` ON `a`.`user`=`c`.`groupid` WHERE `c`.`id` = 0 AND `b`.`pid` = 37 LIMIT 1 [ RunTime:0.000190s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => NULL, 'partitions' => NULL, 'type' => NULL, 'possible_keys' => NULL, 'key' => NULL, 'key_len' => NULL, 'ref' => NULL, 'rows' => NULL, 'filtered' => NULL, 'extra' => 'no matching row in const table', ) ]
[ SQL ] SELECT `a`.`type`,`a`.`bates` FROM `shd_user_product_bates` `a` LEFT JOIN `shd_user_products` `b` ON `a`.`products`=`b`.`gid` LEFT JOIN `shd_clients` `c` ON `a`.`user`=`c`.`groupid` WHERE `c`.`id` = 0 AND `b`.`pid` = 37 LIMIT 1 [ RunTime:0.000201s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => NULL, 'partitions' => NULL, 'type' => NULL, 'possible_keys' => NULL, 'key' => NULL, 'key_len' => NULL, 'ref' => NULL, 'rows' => NULL, 'filtered' => NULL, 'extra' => 'no matching row in const table', ) ]
[ SQL ] SELECT `a`.`type`,`a`.`bates` FROM `shd_user_product_bates` `a` LEFT JOIN `shd_user_products` `b` ON `a`.`products`=`b`.`gid` LEFT JOIN `shd_clients` `c` ON `a`.`user`=`c`.`groupid` WHERE `c`.`id` = 0 AND `b`.`pid` = 37 LIMIT 1 [ RunTime:0.000179s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => NULL, 'partitions' => NULL, 'type' => NULL, 'possible_keys' => NULL, 'key' => NULL, 'key_len' => NULL, 'ref' => NULL, 'rows' => NULL, 'filtered' => NULL, 'extra' => 'no matching row in const table', ) ]
[ SQL ] SELECT `a`.`type`,`a`.`bates` FROM `shd_user_product_bates` `a` LEFT JOIN `shd_user_products` `b` ON `a`.`products`=`b`.`gid` LEFT JOIN `shd_clients` `c` ON `a`.`user`=`c`.`groupid` WHERE `c`.`id` = 0 AND `b`.`pid` = 37 LIMIT 1 [ RunTime:0.000182s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => NULL, 'partitions' => NULL, 'type' => NULL, 'possible_keys' => NULL, 'key' => NULL, 'key_len' => NULL, 'ref' => NULL, 'rows' => NULL, 'filtered' => NULL, 'extra' => 'no matching row in const table', ) ]
[ SQL ] SELECT `a`.`type`,`a`.`bates` FROM `shd_user_product_bates` `a` LEFT JOIN `shd_user_products` `b` ON `a`.`products`=`b`.`gid` LEFT JOIN `shd_clients` `c` ON `a`.`user`=`c`.`groupid` WHERE `c`.`id` = 0 AND `b`.`pid` = 37 LIMIT 1 [ RunTime:0.000177s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => NULL, 'partitions' => NULL, 'type' => NULL, 'possible_keys' => NULL, 'key' => NULL, 'key_len' => NULL, 'ref' => NULL, 'rows' => NULL, 'filtered' => NULL, 'extra' => 'no matching row in const table', ) ]
[ SQL ] SELECT `a`.`type`,`a`.`bates` FROM `shd_user_product_bates` `a` LEFT JOIN `shd_user_products` `b` ON `a`.`products`=`b`.`gid` LEFT JOIN `shd_clients` `c` ON `a`.`user`=`c`.`groupid` WHERE `c`.`id` = 0 AND `b`.`pid` = 37 LIMIT 1 [ RunTime:0.000168s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => NULL, 'partitions' => NULL, 'type' => NULL, 'possible_keys' => NULL, 'key' => NULL, 'key_len' => NULL, 'ref' => NULL, 'rows' => NULL, 'filtered' => NULL, 'extra' => 'no matching row in const table', ) ]
[ SQL ] SELECT `a`.`type`,`a`.`bates` FROM `shd_user_product_bates` `a` LEFT JOIN `shd_user_products` `b` ON `a`.`products`=`b`.`gid` LEFT JOIN `shd_clients` `c` ON `a`.`user`=`c`.`groupid` WHERE `c`.`id` = 0 AND `b`.`pid` = 37 LIMIT 1 [ RunTime:0.000201s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => NULL, 'partitions' => NULL, 'type' => NULL, 'possible_keys' => NULL, 'key' => NULL, 'key_len' => NULL, 'ref' => NULL, 'rows' => NULL, 'filtered' => NULL, 'extra' => 'no matching row in const table', ) ]
[ SQL ] SELECT `allow_qty`,`pay_type` FROM `shd_products` WHERE `id` = 37 LIMIT 1 [ RunTime:0.000183s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'shd_products', 'partitions' => NULL, 'type' => 'const', 'possible_keys' => 'PRIMARY', 'key' => 'PRIMARY', 'key_len' => '4', 'ref' => 'const', 'rows' => 1, 'filtered' => 100.0, 'extra' => NULL, ) ]
[ SQL ] SELECT `type` FROM `shd_products` WHERE `id` = 37 AND `hidden` = 0 AND `p_uid` > 0 LIMIT 1 [ RunTime:0.000154s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => NULL, 'partitions' => NULL, 'type' => NULL, 'possible_keys' => NULL, 'key' => NULL, 'key_len' => NULL, 'ref' => NULL, 'rows' => NULL, 'filtered' => NULL, 'extra' => 'Impossible WHERE noticed after reading const tables', ) ]
[ SQL ] SHOW COLUMNS FROM `shd_product_config_options` [ RunTime:0.000453s ]
[ SQL ] SELECT `a`.`id` FROM `shd_product_config_options` `a` LEFT JOIN `shd_product_config_links` `b` ON `b`.`gid`=`a`.`gid` LEFT JOIN `shd_product_config_groups` `c` ON `a`.`gid`=`c`.`id` WHERE `b`.`pid` = 37 ORDER BY `a`.`order` ASC,`a`.`id` ASC [ RunTime:0.000297s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'b', 'partitions' => NULL, 'type' => 'index', 'possible_keys' => 'gpid', 'key' => 'gpid', 'key_len' => '8', 'ref' => NULL, 'rows' => 15, 'filtered' => 10.0, 'extra' => 'Using where; Using index; Using temporary; Using filesort', ) ]
[ SQL ] SHOW COLUMNS FROM `shd_product_config_options_links` [ RunTime:0.000386s ]
[ SQL ] SELECT * FROM `shd_product_config_options_links` WHERE `config_id` IN (161,168,162,163,164,166,167,165) AND `type` = 'condition' AND `relation_id` = 0 [ RunTime:0.000274s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'shd_product_config_options_links', 'partitions' => NULL, 'type' => 'range', 'possible_keys' => 'config_id', 'key' => 'config_id', 'key_len' => '4', 'ref' => NULL, 'rows' => 8, 'filtered' => 1.0000001192092896, 'extra' => 'Using index condition; Using where', ) ]
[ SQL ] SELECT * FROM `shd_product_config_options_links` WHERE `config_id` = 161 AND `type` = 'condition' [ RunTime:0.000192s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'shd_product_config_options_links', 'partitions' => NULL, 'type' => 'ref', 'possible_keys' => 'config_id', 'key' => 'config_id', 'key_len' => '4', 'ref' => 'const', 'rows' => 1, 'filtered' => 10.0, 'extra' => 'Using where', ) ]
[ SQL ] SELECT * FROM `shd_product_config_options_links` WHERE `config_id` = 168 AND `type` = 'condition' [ RunTime:0.000196s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'shd_product_config_options_links', 'partitions' => NULL, 'type' => 'ref', 'possible_keys' => 'config_id', 'key' => 'config_id', 'key_len' => '4', 'ref' => 'const', 'rows' => 1, 'filtered' => 10.0, 'extra' => 'Using where', ) ]
[ SQL ] SELECT * FROM `shd_product_config_options_links` WHERE `config_id` = 162 AND `type` = 'condition' [ RunTime:0.000191s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'shd_product_config_options_links', 'partitions' => NULL, 'type' => 'ref', 'possible_keys' => 'config_id', 'key' => 'config_id', 'key_len' => '4', 'ref' => 'const', 'rows' => 1, 'filtered' => 10.0, 'extra' => 'Using where', ) ]
[ SQL ] SELECT * FROM `shd_product_config_options_links` WHERE `config_id` = 163 AND `type` = 'condition' [ RunTime:0.000190s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'shd_product_config_options_links', 'partitions' => NULL, 'type' => 'ref', 'possible_keys' => 'config_id', 'key' => 'config_id', 'key_len' => '4', 'ref' => 'const', 'rows' => 1, 'filtered' => 10.0, 'extra' => 'Using where', ) ]
[ SQL ] SELECT * FROM `shd_product_config_options_links` WHERE `config_id` = 164 AND `type` = 'condition' [ RunTime:0.000185s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'shd_product_config_options_links', 'partitions' => NULL, 'type' => 'ref', 'possible_keys' => 'config_id', 'key' => 'config_id', 'key_len' => '4', 'ref' => 'const', 'rows' => 1, 'filtered' => 10.0, 'extra' => 'Using where', ) ]
[ SQL ] SELECT * FROM `shd_product_config_options_links` WHERE `config_id` = 166 AND `type` = 'condition' [ RunTime:0.000162s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'shd_product_config_options_links', 'partitions' => NULL, 'type' => 'ref', 'possible_keys' => 'config_id', 'key' => 'config_id', 'key_len' => '4', 'ref' => 'const', 'rows' => 1, 'filtered' => 10.0, 'extra' => 'Using where', ) ]
[ SQL ] SELECT * FROM `shd_product_config_options_links` WHERE `config_id` = 167 AND `type` = 'condition' [ RunTime:0.000163s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'shd_product_config_options_links', 'partitions' => NULL, 'type' => 'ref', 'possible_keys' => 'config_id', 'key' => 'config_id', 'key_len' => '4', 'ref' => 'const', 'rows' => 1, 'filtered' => 10.0, 'extra' => 'Using where', ) ]
[ SQL ] SELECT * FROM `shd_product_config_options_links` WHERE `config_id` = 165 AND `type` = 'condition' [ RunTime:0.000162s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'shd_product_config_options_links', 'partitions' => NULL, 'type' => 'ref', 'possible_keys' => 'config_id', 'key' => 'config_id', 'key_len' => '4', 'ref' => 'const', 'rows' => 1, 'filtered' => 10.0, 'extra' => 'Using where', ) ]
[ SQL ] SELECT `currency` FROM `shd_clients` WHERE `id` = 0 LIMIT 1 [ RunTime:0.000376s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => NULL, 'partitions' => NULL, 'type' => NULL, 'possible_keys' => NULL, 'key' => NULL, 'key_len' => NULL, 'ref' => NULL, 'rows' => NULL, 'filtered' => NULL, 'extra' => 'no matching row in const table', ) ]
[ SQL ] SELECT * FROM `shd_currencies` WHERE `default` = 1 LIMIT 1 [ RunTime:0.000172s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'shd_currencies', 'partitions' => NULL, 'type' => 'ref', 'possible_keys' => 'default', 'key' => 'default', 'key_len' => '1', 'ref' => 'const', 'rows' => 1, 'filtered' => 100.0, 'extra' => NULL, ) ]
[ SQL ] SELECT * FROM `shd_products` WHERE `id` = 37 LIMIT 1 [ RunTime:0.000456s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'shd_products', 'partitions' => NULL, 'type' => 'const', 'possible_keys' => 'PRIMARY', 'key' => 'PRIMARY', 'key_len' => '4', 'ref' => 'const', 'rows' => 1, 'filtered' => 100.0, 'extra' => NULL, ) ]
[ SQL ] SELECT * FROM `shd_pricing` WHERE `type` = 'product' AND `currency` = 1 AND `relid` = 37 LIMIT 1 [ RunTime:0.000281s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'shd_pricing', 'partitions' => NULL, 'type' => 'ref', 'possible_keys' => 'typerelid', 'key' => 'typerelid', 'key_len' => '5', 'ref' => 'const,const', 'rows' => 1, 'filtered' => 10.0, 'extra' => 'Using where', ) ]
[ SQL ] SELECT a.id as productid,`a`.`name`,`a`.`pay_type`,`b`.*,`a`.`api_type`,`a`.`upstream_version`,`a`.`upstream_price_type`,`a`.`upstream_price_value`,`a`.`hidden`,`a`.`stock_control`,`a`.`qty` FROM `shd_products` `a` LEFT JOIN `shd_pricing` `b` ON `a`.`id`=`b`.`relid` WHERE `a`.`id` = '37' AND `b`.`type` = 'product' AND `b`.`currency` = 1 LIMIT 1 [ RunTime:0.000321s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'a', 'partitions' => NULL, 'type' => 'const', 'possible_keys' => 'PRIMARY', 'key' => 'PRIMARY', 'key_len' => '4', 'ref' => 'const', 'rows' => 1, 'filtered' => 100.0, 'extra' => NULL, ) ]
[ SQL ] SELECT `a`.`type`,`a`.`bates` FROM `shd_user_product_bates` `a` LEFT JOIN `shd_user_products` `b` ON `a`.`products`=`b`.`gid` LEFT JOIN `shd_clients` `c` ON `a`.`user`=`c`.`groupid` WHERE `c`.`id` = '' AND `b`.`pid` = '37' LIMIT 1 [ RunTime:0.000184s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => NULL, 'partitions' => NULL, 'type' => NULL, 'possible_keys' => NULL, 'key' => NULL, 'key_len' => NULL, 'ref' => NULL, 'rows' => NULL, 'filtered' => NULL, 'extra' => 'no matching row in const table', ) ]
[ SQL ] SELECT `a`.* FROM `shd_product_config_options` `a` LEFT JOIN `shd_product_config_links` `b` ON `b`.`gid`=`a`.`gid` WHERE `b`.`pid` = '37' AND `a`.`hidden` = 0 ORDER BY `a`.`order` ASC [ RunTime:0.000333s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'b', 'partitions' => NULL, 'type' => 'index', 'possible_keys' => 'gpid', 'key' => 'gpid', 'key_len' => '8', 'ref' => NULL, 'rows' => 15, 'filtered' => 10.0, 'extra' => 'Using where; Using index; Using temporary; Using filesort', ) ]
[ SQL ] SELECT * FROM `shd_product_config_options_sub` WHERE `config_id` = 161 AND `id` = 533 LIMIT 1 [ RunTime:0.000183s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'shd_product_config_options_sub', 'partitions' => NULL, 'type' => 'const', 'possible_keys' => 'PRIMARY,configid', 'key' => 'PRIMARY', 'key_len' => '4', 'ref' => 'const', 'rows' => 1, 'filtered' => 100.0, 'extra' => NULL, ) ]
[ SQL ] SELECT * FROM `shd_product_config_options_sub` WHERE `config_id` = 168 AND `id` = 564 LIMIT 1 [ RunTime:0.000173s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'shd_product_config_options_sub', 'partitions' => NULL, 'type' => 'const', 'possible_keys' => 'PRIMARY,configid', 'key' => 'PRIMARY', 'key_len' => '4', 'ref' => 'const', 'rows' => 1, 'filtered' => 100.0, 'extra' => NULL, ) ]
[ SQL ] SELECT * FROM `shd_product_config_options_sub` WHERE `config_id` = 162 AND `id` = 534 LIMIT 1 [ RunTime:0.000163s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'shd_product_config_options_sub', 'partitions' => NULL, 'type' => 'const', 'possible_keys' => 'PRIMARY,configid', 'key' => 'PRIMARY', 'key_len' => '4', 'ref' => 'const', 'rows' => 1, 'filtered' => 100.0, 'extra' => NULL, ) ]
[ SQL ] SELECT * FROM `shd_product_config_options_sub` WHERE `config_id` = 163 AND `id` = 535 LIMIT 1 [ RunTime:0.000163s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'shd_product_config_options_sub', 'partitions' => NULL, 'type' => 'const', 'possible_keys' => 'PRIMARY,configid', 'key' => 'PRIMARY', 'key_len' => '4', 'ref' => 'const', 'rows' => 1, 'filtered' => 100.0, 'extra' => NULL, ) ]
[ SQL ] SELECT * FROM `shd_product_config_options_sub` WHERE `config_id` = 165 AND `id` = 537 LIMIT 1 [ RunTime:0.000162s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'shd_product_config_options_sub', 'partitions' => NULL, 'type' => 'const', 'possible_keys' => 'PRIMARY,configid', 'key' => 'PRIMARY', 'key_len' => '4', 'ref' => 'const', 'rows' => 1, 'filtered' => 100.0, 'extra' => NULL, ) ]
[ SQL ] SELECT `option_type`,`unit` FROM `shd_product_config_options` WHERE `id` = 161 LIMIT 1 [ RunTime:0.000199s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'shd_product_config_options', 'partitions' => NULL, 'type' => 'const', 'possible_keys' => 'PRIMARY', 'key' => 'PRIMARY', 'key_len' => '4', 'ref' => 'const', 'rows' => 1, 'filtered' => 100.0, 'extra' => NULL, ) ]
[ SQL ] SELECT `pco`.`is_discount`,pcos.option_name as suboption_name,`pco`.`option_type`,pco.option_name as option_name,`pco`.`hidden`,`p`.*,`pco`.`is_rebate` FROM `shd_product_config_options_sub` `pcos` LEFT JOIN `shd_product_config_options` `pco` ON `pco`.`id`=`pcos`.`config_id` LEFT JOIN `shd_pricing` `p` ON `p`.`relid`=`pcos`.`id` WHERE `pcos`.`id` = '533' AND `pcos`.`config_id` = 161 AND `p`.`type` = 'configoptions' AND `p`.`currency` = 1 LIMIT 1 [ RunTime:0.000296s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'pcos', 'partitions' => NULL, 'type' => 'const', 'possible_keys' => 'PRIMARY,configid', 'key' => 'PRIMARY', 'key_len' => '4', 'ref' => 'const', 'rows' => 1, 'filtered' => 100.0, 'extra' => NULL, ) ]
[ SQL ] SELECT `option_type`,`unit` FROM `shd_product_config_options` WHERE `id` = 168 LIMIT 1 [ RunTime:0.000194s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'shd_product_config_options', 'partitions' => NULL, 'type' => 'const', 'possible_keys' => 'PRIMARY', 'key' => 'PRIMARY', 'key_len' => '4', 'ref' => 'const', 'rows' => 1, 'filtered' => 100.0, 'extra' => NULL, ) ]
[ SQL ] SELECT `pco`.`is_discount`,pcos.option_name as suboption_name,`pco`.`option_type`,pco.option_name as option_name,`pco`.`hidden`,`p`.*,`pco`.`is_rebate` FROM `shd_product_config_options_sub` `pcos` LEFT JOIN `shd_product_config_options` `pco` ON `pco`.`id`=`pcos`.`config_id` LEFT JOIN `shd_pricing` `p` ON `p`.`relid`=`pcos`.`id` WHERE `pcos`.`id` = '564' AND `pcos`.`config_id` = 168 AND `p`.`type` = 'configoptions' AND `p`.`currency` = 1 LIMIT 1 [ RunTime:0.000307s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'pcos', 'partitions' => NULL, 'type' => 'const', 'possible_keys' => 'PRIMARY,configid', 'key' => 'PRIMARY', 'key_len' => '4', 'ref' => 'const', 'rows' => 1, 'filtered' => 100.0, 'extra' => NULL, ) ]
[ SQL ] SELECT `option_type`,`unit` FROM `shd_product_config_options` WHERE `id` = 162 LIMIT 1 [ RunTime:0.000145s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'shd_product_config_options', 'partitions' => NULL, 'type' => 'const', 'possible_keys' => 'PRIMARY', 'key' => 'PRIMARY', 'key_len' => '4', 'ref' => 'const', 'rows' => 1, 'filtered' => 100.0, 'extra' => NULL, ) ]
[ SQL ] SELECT `pco`.`is_discount`,pcos.option_name as suboption_name,`pco`.`option_type`,pco.option_name as option_name,`pco`.`hidden`,`p`.*,`pco`.`is_rebate` FROM `shd_product_config_options_sub` `pcos` LEFT JOIN `shd_product_config_options` `pco` ON `pco`.`id`=`pcos`.`config_id` LEFT JOIN `shd_pricing` `p` ON `p`.`relid`=`pcos`.`id` WHERE `pcos`.`id` = '534' AND `pcos`.`config_id` = 162 AND `p`.`type` = 'configoptions' AND `p`.`currency` = 1 LIMIT 1 [ RunTime:0.000271s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'pcos', 'partitions' => NULL, 'type' => 'const', 'possible_keys' => 'PRIMARY,configid', 'key' => 'PRIMARY', 'key_len' => '4', 'ref' => 'const', 'rows' => 1, 'filtered' => 100.0, 'extra' => NULL, ) ]
[ SQL ] SELECT `option_type`,`unit` FROM `shd_product_config_options` WHERE `id` = 163 LIMIT 1 [ RunTime:0.000154s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'shd_product_config_options', 'partitions' => NULL, 'type' => 'const', 'possible_keys' => 'PRIMARY', 'key' => 'PRIMARY', 'key_len' => '4', 'ref' => 'const', 'rows' => 1, 'filtered' => 100.0, 'extra' => NULL, ) ]
[ SQL ] SELECT `pco`.`is_discount`,pcos.option_name as suboption_name,`pco`.`option_type`,pco.option_name as option_name,`pco`.`hidden`,`p`.*,`pco`.`is_rebate` FROM `shd_product_config_options_sub` `pcos` LEFT JOIN `shd_product_config_options` `pco` ON `pco`.`id`=`pcos`.`config_id` LEFT JOIN `shd_pricing` `p` ON `p`.`relid`=`pcos`.`id` WHERE `pcos`.`id` = '535' AND `pcos`.`config_id` = 163 AND `p`.`type` = 'configoptions' AND `p`.`currency` = 1 LIMIT 1 [ RunTime:0.000285s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'pcos', 'partitions' => NULL, 'type' => 'const', 'possible_keys' => 'PRIMARY,configid', 'key' => 'PRIMARY', 'key_len' => '4', 'ref' => 'const', 'rows' => 1, 'filtered' => 100.0, 'extra' => NULL, ) ]
[ SQL ] SELECT `option_type`,`unit` FROM `shd_product_config_options` WHERE `id` = 164 LIMIT 1 [ RunTime:0.000147s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'shd_product_config_options', 'partitions' => NULL, 'type' => 'const', 'possible_keys' => 'PRIMARY', 'key' => 'PRIMARY', 'key_len' => '4', 'ref' => 'const', 'rows' => 1, 'filtered' => 100.0, 'extra' => NULL, ) ]
[ SQL ] SELECT pcos.option_name as suboption_name,`pcos`.`qty_minimum`,`pcos`.`qty_maximum`,`pco`.`option_type`,`pco`.`hidden`,pco.option_name as option_name,pco.qty_minimum as min,pco.qty_maximum as max,`pco`.`is_discount`,`p`.*,`pco`.`is_rebate` FROM `shd_product_config_options_sub` `pcos` LEFT JOIN `shd_product_config_options` `pco` ON `pco`.`id`=`pcos`.`config_id` LEFT JOIN `shd_pricing` `p` ON `p`.`relid`=`pcos`.`id` WHERE `pcos`.`config_id` = 164 AND `p`.`type` = 'configoptions' AND `currency` = 1 [ RunTime:0.000293s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'pcos', 'partitions' => NULL, 'type' => 'ref', 'possible_keys' => 'PRIMARY,configid', 'key' => 'configid', 'key_len' => '4', 'ref' => 'const', 'rows' => 1, 'filtered' => 100.0, 'extra' => NULL, ) ]
[ SQL ] SELECT `a`.`qty_minimum`,`a`.`qty_maximum` FROM `shd_product_config_options_sub` `a` LEFT JOIN `shd_pricing` `b` ON `a`.`id`=`b`.`relid` WHERE `b`.`type` = 'configoptions' AND `b`.`currency` = 1 AND `a`.`config_id` = 164 [ RunTime:0.000211s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'a', 'partitions' => NULL, 'type' => 'ref', 'possible_keys' => 'PRIMARY,configid', 'key' => 'configid', 'key_len' => '4', 'ref' => 'const', 'rows' => 1, 'filtered' => 100.0, 'extra' => NULL, ) ]
[ SQL ] SELECT * FROM `shd_product_config_options_sub` `a` LEFT JOIN `shd_pricing` `b` ON `a`.`id`=`b`.`relid` WHERE `b`.`type` = 'configoptions' AND `b`.`currency` = 1 AND `a`.`config_id` = 164 AND `a`.`qty_minimum` <= '100' AND `a`.`qty_maximum` >= '100' LIMIT 1 [ RunTime:0.000304s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'a', 'partitions' => NULL, 'type' => 'ref', 'possible_keys' => 'PRIMARY,configid', 'key' => 'configid', 'key_len' => '4', 'ref' => 'const', 'rows' => 1, 'filtered' => 11.108888626098633, 'extra' => 'Using where', ) ]
[ SQL ] SELECT `option_type`,`unit` FROM `shd_product_config_options` WHERE `id` = 166 LIMIT 1 [ RunTime:0.000155s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'shd_product_config_options', 'partitions' => NULL, 'type' => 'const', 'possible_keys' => 'PRIMARY', 'key' => 'PRIMARY', 'key_len' => '4', 'ref' => 'const', 'rows' => 1, 'filtered' => 100.0, 'extra' => NULL, ) ]
[ SQL ] SELECT pcos.option_name as suboption_name,`pcos`.`qty_minimum`,`pcos`.`qty_maximum`,`pco`.`option_type`,`pco`.`hidden`,pco.option_name as option_name,pco.qty_minimum as min,pco.qty_maximum as max,`pco`.`is_discount`,`p`.*,`pco`.`is_rebate` FROM `shd_product_config_options_sub` `pcos` LEFT JOIN `shd_product_config_options` `pco` ON `pco`.`id`=`pcos`.`config_id` LEFT JOIN `shd_pricing` `p` ON `p`.`relid`=`pcos`.`id` WHERE `pcos`.`config_id` = 166 AND `p`.`type` = 'configoptions' AND `currency` = 1 [ RunTime:0.000292s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'pcos', 'partitions' => NULL, 'type' => 'ref', 'possible_keys' => 'PRIMARY,configid', 'key' => 'configid', 'key_len' => '4', 'ref' => 'const', 'rows' => 1, 'filtered' => 100.0, 'extra' => NULL, ) ]
[ SQL ] SELECT `option_type`,`unit` FROM `shd_product_config_options` WHERE `id` = 167 LIMIT 1 [ RunTime:0.000155s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'shd_product_config_options', 'partitions' => NULL, 'type' => 'const', 'possible_keys' => 'PRIMARY', 'key' => 'PRIMARY', 'key_len' => '4', 'ref' => 'const', 'rows' => 1, 'filtered' => 100.0, 'extra' => NULL, ) ]
[ SQL ] SELECT pcos.option_name as suboption_name,`pcos`.`qty_minimum`,`pcos`.`qty_maximum`,`pco`.`option_type`,`pco`.`hidden`,pco.option_name as option_name,pco.qty_minimum as min,pco.qty_maximum as max,`pco`.`is_discount`,`p`.*,`pco`.`is_rebate` FROM `shd_product_config_options_sub` `pcos` LEFT JOIN `shd_product_config_options` `pco` ON `pco`.`id`=`pcos`.`config_id` LEFT JOIN `shd_pricing` `p` ON `p`.`relid`=`pcos`.`id` WHERE `pcos`.`config_id` = 167 AND `p`.`type` = 'configoptions' AND `currency` = 1 [ RunTime:0.000295s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'pcos', 'partitions' => NULL, 'type' => 'ref', 'possible_keys' => 'PRIMARY,configid', 'key' => 'configid', 'key_len' => '4', 'ref' => 'const', 'rows' => 1, 'filtered' => 100.0, 'extra' => NULL, ) ]
[ SQL ] SELECT `option_type`,`unit` FROM `shd_product_config_options` WHERE `id` = 165 LIMIT 1 [ RunTime:0.000161s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'shd_product_config_options', 'partitions' => NULL, 'type' => 'const', 'possible_keys' => 'PRIMARY', 'key' => 'PRIMARY', 'key_len' => '4', 'ref' => 'const', 'rows' => 1, 'filtered' => 100.0, 'extra' => NULL, ) ]
[ SQL ] SELECT `pco`.`is_discount`,pcos.option_name as suboption_name,`pco`.`option_type`,pco.option_name as option_name,`pco`.`hidden`,`p`.*,`pco`.`is_rebate` FROM `shd_product_config_options_sub` `pcos` LEFT JOIN `shd_product_config_options` `pco` ON `pco`.`id`=`pcos`.`config_id` LEFT JOIN `shd_pricing` `p` ON `p`.`relid`=`pcos`.`id` WHERE `pcos`.`id` = '537' AND `pcos`.`config_id` = 165 AND `p`.`type` = 'configoptions' AND `p`.`currency` = 1 LIMIT 1 [ RunTime:0.000326s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'pcos', 'partitions' => NULL, 'type' => 'const', 'possible_keys' => 'PRIMARY,configid', 'key' => 'PRIMARY', 'key_len' => '4', 'ref' => 'const', 'rows' => 1, 'filtered' => 100.0, 'extra' => NULL, ) ]
[ SQL ] SELECT * FROM `shd_product_config_options_links` WHERE `config_id` = 161 AND `type` = 'condition' [ RunTime:0.000191s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'shd_product_config_options_links', 'partitions' => NULL, 'type' => 'ref', 'possible_keys' => 'config_id', 'key' => 'config_id', 'key_len' => '4', 'ref' => 'const', 'rows' => 1, 'filtered' => 10.0, 'extra' => 'Using where', ) ]
[ SQL ] SELECT * FROM `shd_product_config_options_links` WHERE `config_id` = 168 AND `type` = 'condition' [ RunTime:0.000164s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'shd_product_config_options_links', 'partitions' => NULL, 'type' => 'ref', 'possible_keys' => 'config_id', 'key' => 'config_id', 'key_len' => '4', 'ref' => 'const', 'rows' => 1, 'filtered' => 10.0, 'extra' => 'Using where', ) ]
[ SQL ] SELECT * FROM `shd_product_config_options_links` WHERE `config_id` = 162 AND `type` = 'condition' [ RunTime:0.000165s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'shd_product_config_options_links', 'partitions' => NULL, 'type' => 'ref', 'possible_keys' => 'config_id', 'key' => 'config_id', 'key_len' => '4', 'ref' => 'const', 'rows' => 1, 'filtered' => 10.0, 'extra' => 'Using where', ) ]
[ SQL ] SELECT * FROM `shd_product_config_options_links` WHERE `config_id` = 163 AND `type` = 'condition' [ RunTime:0.000163s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'shd_product_config_options_links', 'partitions' => NULL, 'type' => 'ref', 'possible_keys' => 'config_id', 'key' => 'config_id', 'key_len' => '4', 'ref' => 'const', 'rows' => 1, 'filtered' => 10.0, 'extra' => 'Using where', ) ]
[ SQL ] SELECT * FROM `shd_product_config_options_links` WHERE `config_id` = 164 AND `type` = 'condition' [ RunTime:0.000167s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'shd_product_config_options_links', 'partitions' => NULL, 'type' => 'ref', 'possible_keys' => 'config_id', 'key' => 'config_id', 'key_len' => '4', 'ref' => 'const', 'rows' => 1, 'filtered' => 10.0, 'extra' => 'Using where', ) ]
[ SQL ] SELECT * FROM `shd_product_config_options_links` WHERE `config_id` = 166 AND `type` = 'condition' [ RunTime:0.000159s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'shd_product_config_options_links', 'partitions' => NULL, 'type' => 'ref', 'possible_keys' => 'config_id', 'key' => 'config_id', 'key_len' => '4', 'ref' => 'const', 'rows' => 1, 'filtered' => 10.0, 'extra' => 'Using where', ) ]
[ SQL ] SELECT * FROM `shd_product_config_options_links` WHERE `config_id` = 167 AND `type` = 'condition' [ RunTime:0.000158s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'shd_product_config_options_links', 'partitions' => NULL, 'type' => 'ref', 'possible_keys' => 'config_id', 'key' => 'config_id', 'key_len' => '4', 'ref' => 'const', 'rows' => 1, 'filtered' => 10.0, 'extra' => 'Using where', ) ]
[ SQL ] SELECT * FROM `shd_product_config_options_links` WHERE `config_id` = 165 AND `type` = 'condition' [ RunTime:0.000166s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'shd_product_config_options_links', 'partitions' => NULL, 'type' => 'ref', 'possible_keys' => 'config_id', 'key' => 'config_id', 'key_len' => '4', 'ref' => 'const', 'rows' => 1, 'filtered' => 10.0, 'extra' => 'Using where', ) ]
[ SQL ] SELECT `currency` FROM `shd_clients` WHERE `id` = 0 LIMIT 1 [ RunTime:0.000142s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => NULL, 'partitions' => NULL, 'type' => NULL, 'possible_keys' => NULL, 'key' => NULL, 'key_len' => NULL, 'ref' => NULL, 'rows' => NULL, 'filtered' => NULL, 'extra' => 'no matching row in const table', ) ]
[ SQL ] SELECT * FROM `shd_currencies` WHERE `default` = 1 LIMIT 1 [ RunTime:0.000167s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'shd_currencies', 'partitions' => NULL, 'type' => 'ref', 'possible_keys' => 'default', 'key' => 'default', 'key_len' => '1', 'ref' => 'const', 'rows' => 1, 'filtered' => 100.0, 'extra' => NULL, ) ]
[ SQL ] SELECT * FROM `shd_products` WHERE `id` = 37 LIMIT 1 [ RunTime:0.000386s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'shd_products', 'partitions' => NULL, 'type' => 'const', 'possible_keys' => 'PRIMARY', 'key' => 'PRIMARY', 'key_len' => '4', 'ref' => 'const', 'rows' => 1, 'filtered' => 100.0, 'extra' => NULL, ) ]
[ SQL ] SELECT * FROM `shd_pricing` WHERE `type` = 'product' AND `currency` = 1 AND `relid` = 37 LIMIT 1 [ RunTime:0.000246s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'shd_pricing', 'partitions' => NULL, 'type' => 'ref', 'possible_keys' => 'typerelid', 'key' => 'typerelid', 'key_len' => '5', 'ref' => 'const,const', 'rows' => 1, 'filtered' => 10.0, 'extra' => 'Using where', ) ]
[ SQL ] SELECT a.id as productid,`a`.`name`,`a`.`pay_type`,`b`.*,`a`.`api_type`,`a`.`upstream_version`,`a`.`upstream_price_type`,`a`.`upstream_price_value`,`a`.`hidden`,`a`.`stock_control`,`a`.`qty` FROM `shd_products` `a` LEFT JOIN `shd_pricing` `b` ON `a`.`id`=`b`.`relid` WHERE `a`.`id` = '37' AND `b`.`type` = 'product' AND `b`.`currency` = 1 LIMIT 1 [ RunTime:0.000310s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'a', 'partitions' => NULL, 'type' => 'const', 'possible_keys' => 'PRIMARY', 'key' => 'PRIMARY', 'key_len' => '4', 'ref' => 'const', 'rows' => 1, 'filtered' => 100.0, 'extra' => NULL, ) ]
[ SQL ] SELECT `a`.`type`,`a`.`bates` FROM `shd_user_product_bates` `a` LEFT JOIN `shd_user_products` `b` ON `a`.`products`=`b`.`gid` LEFT JOIN `shd_clients` `c` ON `a`.`user`=`c`.`groupid` WHERE `c`.`id` = '' AND `b`.`pid` = '37' LIMIT 1 [ RunTime:0.000196s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => NULL, 'partitions' => NULL, 'type' => NULL, 'possible_keys' => NULL, 'key' => NULL, 'key_len' => NULL, 'ref' => NULL, 'rows' => NULL, 'filtered' => NULL, 'extra' => 'no matching row in const table', ) ]
[ SQL ] SELECT `a`.* FROM `shd_product_config_options` `a` LEFT JOIN `shd_product_config_links` `b` ON `b`.`gid`=`a`.`gid` WHERE `b`.`pid` = '37' AND `a`.`hidden` = 0 ORDER BY `a`.`order` ASC [ RunTime:0.000341s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'b', 'partitions' => NULL, 'type' => 'index', 'possible_keys' => 'gpid', 'key' => 'gpid', 'key_len' => '8', 'ref' => NULL, 'rows' => 15, 'filtered' => 10.0, 'extra' => 'Using where; Using index; Using temporary; Using filesort', ) ]
[ SQL ] SELECT * FROM `shd_product_config_options_sub` WHERE `config_id` = 161 AND `id` = 533 LIMIT 1 [ RunTime:0.000182s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'shd_product_config_options_sub', 'partitions' => NULL, 'type' => 'const', 'possible_keys' => 'PRIMARY,configid', 'key' => 'PRIMARY', 'key_len' => '4', 'ref' => 'const', 'rows' => 1, 'filtered' => 100.0, 'extra' => NULL, ) ]
[ SQL ] SELECT * FROM `shd_product_config_options_sub` WHERE `config_id` = 168 AND `id` = 564 LIMIT 1 [ RunTime:0.000172s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'shd_product_config_options_sub', 'partitions' => NULL, 'type' => 'const', 'possible_keys' => 'PRIMARY,configid', 'key' => 'PRIMARY', 'key_len' => '4', 'ref' => 'const', 'rows' => 1, 'filtered' => 100.0, 'extra' => NULL, ) ]
[ SQL ] SELECT * FROM `shd_product_config_options_sub` WHERE `config_id` = 162 AND `id` = 534 LIMIT 1 [ RunTime:0.000178s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'shd_product_config_options_sub', 'partitions' => NULL, 'type' => 'const', 'possible_keys' => 'PRIMARY,configid', 'key' => 'PRIMARY', 'key_len' => '4', 'ref' => 'const', 'rows' => 1, 'filtered' => 100.0, 'extra' => NULL, ) ]
[ SQL ] SELECT * FROM `shd_product_config_options_sub` WHERE `config_id` = 163 AND `id` = 535 LIMIT 1 [ RunTime:0.000205s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'shd_product_config_options_sub', 'partitions' => NULL, 'type' => 'const', 'possible_keys' => 'PRIMARY,configid', 'key' => 'PRIMARY', 'key_len' => '4', 'ref' => 'const', 'rows' => 1, 'filtered' => 100.0, 'extra' => NULL, ) ]
[ SQL ] SELECT * FROM `shd_product_config_options_sub` WHERE `config_id` = 165 AND `id` = 537 LIMIT 1 [ RunTime:0.000155s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'shd_product_config_options_sub', 'partitions' => NULL, 'type' => 'const', 'possible_keys' => 'PRIMARY,configid', 'key' => 'PRIMARY', 'key_len' => '4', 'ref' => 'const', 'rows' => 1, 'filtered' => 100.0, 'extra' => NULL, ) ]
[ SQL ] SELECT `option_type`,`unit` FROM `shd_product_config_options` WHERE `id` = 161 LIMIT 1 [ RunTime:0.000140s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'shd_product_config_options', 'partitions' => NULL, 'type' => 'const', 'possible_keys' => 'PRIMARY', 'key' => 'PRIMARY', 'key_len' => '4', 'ref' => 'const', 'rows' => 1, 'filtered' => 100.0, 'extra' => NULL, ) ]
[ SQL ] SELECT `pco`.`is_discount`,pcos.option_name as suboption_name,`pco`.`option_type`,pco.option_name as option_name,`pco`.`hidden`,`p`.*,`pco`.`is_rebate` FROM `shd_product_config_options_sub` `pcos` LEFT JOIN `shd_product_config_options` `pco` ON `pco`.`id`=`pcos`.`config_id` LEFT JOIN `shd_pricing` `p` ON `p`.`relid`=`pcos`.`id` WHERE `pcos`.`id` = '533' AND `pcos`.`config_id` = 161 AND `p`.`type` = 'configoptions' AND `p`.`currency` = 1 LIMIT 1 [ RunTime:0.000284s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'pcos', 'partitions' => NULL, 'type' => 'const', 'possible_keys' => 'PRIMARY,configid', 'key' => 'PRIMARY', 'key_len' => '4', 'ref' => 'const', 'rows' => 1, 'filtered' => 100.0, 'extra' => NULL, ) ]
[ SQL ] SELECT `option_type`,`unit` FROM `shd_product_config_options` WHERE `id` = 168 LIMIT 1 [ RunTime:0.000152s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'shd_product_config_options', 'partitions' => NULL, 'type' => 'const', 'possible_keys' => 'PRIMARY', 'key' => 'PRIMARY', 'key_len' => '4', 'ref' => 'const', 'rows' => 1, 'filtered' => 100.0, 'extra' => NULL, ) ]
[ SQL ] SELECT `pco`.`is_discount`,pcos.option_name as suboption_name,`pco`.`option_type`,pco.option_name as option_name,`pco`.`hidden`,`p`.*,`pco`.`is_rebate` FROM `shd_product_config_options_sub` `pcos` LEFT JOIN `shd_product_config_options` `pco` ON `pco`.`id`=`pcos`.`config_id` LEFT JOIN `shd_pricing` `p` ON `p`.`relid`=`pcos`.`id` WHERE `pcos`.`id` = '564' AND `pcos`.`config_id` = 168 AND `p`.`type` = 'configoptions' AND `p`.`currency` = 1 LIMIT 1 [ RunTime:0.000270s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'pcos', 'partitions' => NULL, 'type' => 'const', 'possible_keys' => 'PRIMARY,configid', 'key' => 'PRIMARY', 'key_len' => '4', 'ref' => 'const', 'rows' => 1, 'filtered' => 100.0, 'extra' => NULL, ) ]
[ SQL ] SELECT `option_type`,`unit` FROM `shd_product_config_options` WHERE `id` = 162 LIMIT 1 [ RunTime:0.000162s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'shd_product_config_options', 'partitions' => NULL, 'type' => 'const', 'possible_keys' => 'PRIMARY', 'key' => 'PRIMARY', 'key_len' => '4', 'ref' => 'const', 'rows' => 1, 'filtered' => 100.0, 'extra' => NULL, ) ]
[ SQL ] SELECT `pco`.`is_discount`,pcos.option_name as suboption_name,`pco`.`option_type`,pco.option_name as option_name,`pco`.`hidden`,`p`.*,`pco`.`is_rebate` FROM `shd_product_config_options_sub` `pcos` LEFT JOIN `shd_product_config_options` `pco` ON `pco`.`id`=`pcos`.`config_id` LEFT JOIN `shd_pricing` `p` ON `p`.`relid`=`pcos`.`id` WHERE `pcos`.`id` = '534' AND `pcos`.`config_id` = 162 AND `p`.`type` = 'configoptions' AND `p`.`currency` = 1 LIMIT 1 [ RunTime:0.000295s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'pcos', 'partitions' => NULL, 'type' => 'const', 'possible_keys' => 'PRIMARY,configid', 'key' => 'PRIMARY', 'key_len' => '4', 'ref' => 'const', 'rows' => 1, 'filtered' => 100.0, 'extra' => NULL, ) ]
[ SQL ] SELECT `option_type`,`unit` FROM `shd_product_config_options` WHERE `id` = 163 LIMIT 1 [ RunTime:0.000150s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'shd_product_config_options', 'partitions' => NULL, 'type' => 'const', 'possible_keys' => 'PRIMARY', 'key' => 'PRIMARY', 'key_len' => '4', 'ref' => 'const', 'rows' => 1, 'filtered' => 100.0, 'extra' => NULL, ) ]
[ SQL ] SELECT `pco`.`is_discount`,pcos.option_name as suboption_name,`pco`.`option_type`,pco.option_name as option_name,`pco`.`hidden`,`p`.*,`pco`.`is_rebate` FROM `shd_product_config_options_sub` `pcos` LEFT JOIN `shd_product_config_options` `pco` ON `pco`.`id`=`pcos`.`config_id` LEFT JOIN `shd_pricing` `p` ON `p`.`relid`=`pcos`.`id` WHERE `pcos`.`id` = '535' AND `pcos`.`config_id` = 163 AND `p`.`type` = 'configoptions' AND `p`.`currency` = 1 LIMIT 1 [ RunTime:0.000294s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'pcos', 'partitions' => NULL, 'type' => 'const', 'possible_keys' => 'PRIMARY,configid', 'key' => 'PRIMARY', 'key_len' => '4', 'ref' => 'const', 'rows' => 1, 'filtered' => 100.0, 'extra' => NULL, ) ]
[ SQL ] SELECT `option_type`,`unit` FROM `shd_product_config_options` WHERE `id` = 164 LIMIT 1 [ RunTime:0.000146s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'shd_product_config_options', 'partitions' => NULL, 'type' => 'const', 'possible_keys' => 'PRIMARY', 'key' => 'PRIMARY', 'key_len' => '4', 'ref' => 'const', 'rows' => 1, 'filtered' => 100.0, 'extra' => NULL, ) ]
[ SQL ] SELECT pcos.option_name as suboption_name,`pcos`.`qty_minimum`,`pcos`.`qty_maximum`,`pco`.`option_type`,`pco`.`hidden`,pco.option_name as option_name,pco.qty_minimum as min,pco.qty_maximum as max,`pco`.`is_discount`,`p`.*,`pco`.`is_rebate` FROM `shd_product_config_options_sub` `pcos` LEFT JOIN `shd_product_config_options` `pco` ON `pco`.`id`=`pcos`.`config_id` LEFT JOIN `shd_pricing` `p` ON `p`.`relid`=`pcos`.`id` WHERE `pcos`.`config_id` = 164 AND `p`.`type` = 'configoptions' AND `currency` = 1 [ RunTime:0.000288s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'pcos', 'partitions' => NULL, 'type' => 'ref', 'possible_keys' => 'PRIMARY,configid', 'key' => 'configid', 'key_len' => '4', 'ref' => 'const', 'rows' => 1, 'filtered' => 100.0, 'extra' => NULL, ) ]
[ SQL ] SELECT `a`.`qty_minimum`,`a`.`qty_maximum` FROM `shd_product_config_options_sub` `a` LEFT JOIN `shd_pricing` `b` ON `a`.`id`=`b`.`relid` WHERE `b`.`type` = 'configoptions' AND `b`.`currency` = 1 AND `a`.`config_id` = 164 [ RunTime:0.000199s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'a', 'partitions' => NULL, 'type' => 'ref', 'possible_keys' => 'PRIMARY,configid', 'key' => 'configid', 'key_len' => '4', 'ref' => 'const', 'rows' => 1, 'filtered' => 100.0, 'extra' => NULL, ) ]
[ SQL ] SELECT * FROM `shd_product_config_options_sub` `a` LEFT JOIN `shd_pricing` `b` ON `a`.`id`=`b`.`relid` WHERE `b`.`type` = 'configoptions' AND `b`.`currency` = 1 AND `a`.`config_id` = 164 AND `a`.`qty_minimum` <= '100' AND `a`.`qty_maximum` >= '100' LIMIT 1 [ RunTime:0.000293s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'a', 'partitions' => NULL, 'type' => 'ref', 'possible_keys' => 'PRIMARY,configid', 'key' => 'configid', 'key_len' => '4', 'ref' => 'const', 'rows' => 1, 'filtered' => 11.108888626098633, 'extra' => 'Using where', ) ]
[ SQL ] SELECT `option_type`,`unit` FROM `shd_product_config_options` WHERE `id` = 166 LIMIT 1 [ RunTime:0.000149s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'shd_product_config_options', 'partitions' => NULL, 'type' => 'const', 'possible_keys' => 'PRIMARY', 'key' => 'PRIMARY', 'key_len' => '4', 'ref' => 'const', 'rows' => 1, 'filtered' => 100.0, 'extra' => NULL, ) ]
[ SQL ] SELECT pcos.option_name as suboption_name,`pcos`.`qty_minimum`,`pcos`.`qty_maximum`,`pco`.`option_type`,`pco`.`hidden`,pco.option_name as option_name,pco.qty_minimum as min,pco.qty_maximum as max,`pco`.`is_discount`,`p`.*,`pco`.`is_rebate` FROM `shd_product_config_options_sub` `pcos` LEFT JOIN `shd_product_config_options` `pco` ON `pco`.`id`=`pcos`.`config_id` LEFT JOIN `shd_pricing` `p` ON `p`.`relid`=`pcos`.`id` WHERE `pcos`.`config_id` = 166 AND `p`.`type` = 'configoptions' AND `currency` = 1 [ RunTime:0.000287s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'pcos', 'partitions' => NULL, 'type' => 'ref', 'possible_keys' => 'PRIMARY,configid', 'key' => 'configid', 'key_len' => '4', 'ref' => 'const', 'rows' => 1, 'filtered' => 100.0, 'extra' => NULL, ) ]
[ SQL ] SELECT `option_type`,`unit` FROM `shd_product_config_options` WHERE `id` = 167 LIMIT 1 [ RunTime:0.000163s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'shd_product_config_options', 'partitions' => NULL, 'type' => 'const', 'possible_keys' => 'PRIMARY', 'key' => 'PRIMARY', 'key_len' => '4', 'ref' => 'const', 'rows' => 1, 'filtered' => 100.0, 'extra' => NULL, ) ]
[ SQL ] SELECT pcos.option_name as suboption_name,`pcos`.`qty_minimum`,`pcos`.`qty_maximum`,`pco`.`option_type`,`pco`.`hidden`,pco.option_name as option_name,pco.qty_minimum as min,pco.qty_maximum as max,`pco`.`is_discount`,`p`.*,`pco`.`is_rebate` FROM `shd_product_config_options_sub` `pcos` LEFT JOIN `shd_product_config_options` `pco` ON `pco`.`id`=`pcos`.`config_id` LEFT JOIN `shd_pricing` `p` ON `p`.`relid`=`pcos`.`id` WHERE `pcos`.`config_id` = 167 AND `p`.`type` = 'configoptions' AND `currency` = 1 [ RunTime:0.000305s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'pcos', 'partitions' => NULL, 'type' => 'ref', 'possible_keys' => 'PRIMARY,configid', 'key' => 'configid', 'key_len' => '4', 'ref' => 'const', 'rows' => 1, 'filtered' => 100.0, 'extra' => NULL, ) ]
[ SQL ] SELECT `option_type`,`unit` FROM `shd_product_config_options` WHERE `id` = 165 LIMIT 1 [ RunTime:0.000153s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'shd_product_config_options', 'partitions' => NULL, 'type' => 'const', 'possible_keys' => 'PRIMARY', 'key' => 'PRIMARY', 'key_len' => '4', 'ref' => 'const', 'rows' => 1, 'filtered' => 100.0, 'extra' => NULL, ) ]
[ SQL ] SELECT `pco`.`is_discount`,pcos.option_name as suboption_name,`pco`.`option_type`,pco.option_name as option_name,`pco`.`hidden`,`p`.*,`pco`.`is_rebate` FROM `shd_product_config_options_sub` `pcos` LEFT JOIN `shd_product_config_options` `pco` ON `pco`.`id`=`pcos`.`config_id` LEFT JOIN `shd_pricing` `p` ON `p`.`relid`=`pcos`.`id` WHERE `pcos`.`id` = '537' AND `pcos`.`config_id` = 165 AND `p`.`type` = 'configoptions' AND `p`.`currency` = 1 LIMIT 1 [ RunTime:0.000295s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'pcos', 'partitions' => NULL, 'type' => 'const', 'possible_keys' => 'PRIMARY,configid', 'key' => 'PRIMARY', 'key_len' => '4', 'ref' => 'const', 'rows' => 1, 'filtered' => 100.0, 'extra' => NULL, ) ]
[ SQL ] SELECT * FROM `shd_product_config_options_links` WHERE `config_id` = 161 AND `type` = 'condition' [ RunTime:0.000182s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'shd_product_config_options_links', 'partitions' => NULL, 'type' => 'ref', 'possible_keys' => 'config_id', 'key' => 'config_id', 'key_len' => '4', 'ref' => 'const', 'rows' => 1, 'filtered' => 10.0, 'extra' => 'Using where', ) ]
[ SQL ] SELECT * FROM `shd_product_config_options_links` WHERE `config_id` = 168 AND `type` = 'condition' [ RunTime:0.000166s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'shd_product_config_options_links', 'partitions' => NULL, 'type' => 'ref', 'possible_keys' => 'config_id', 'key' => 'config_id', 'key_len' => '4', 'ref' => 'const', 'rows' => 1, 'filtered' => 10.0, 'extra' => 'Using where', ) ]
[ SQL ] SELECT * FROM `shd_product_config_options_links` WHERE `config_id` = 162 AND `type` = 'condition' [ RunTime:0.000170s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'shd_product_config_options_links', 'partitions' => NULL, 'type' => 'ref', 'possible_keys' => 'config_id', 'key' => 'config_id', 'key_len' => '4', 'ref' => 'const', 'rows' => 1, 'filtered' => 10.0, 'extra' => 'Using where', ) ]
[ SQL ] SELECT * FROM `shd_product_config_options_links` WHERE `config_id` = 163 AND `type` = 'condition' [ RunTime:0.000158s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'shd_product_config_options_links', 'partitions' => NULL, 'type' => 'ref', 'possible_keys' => 'config_id', 'key' => 'config_id', 'key_len' => '4', 'ref' => 'const', 'rows' => 1, 'filtered' => 10.0, 'extra' => 'Using where', ) ]
[ SQL ] SELECT * FROM `shd_product_config_options_links` WHERE `config_id` = 164 AND `type` = 'condition' [ RunTime:0.000161s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'shd_product_config_options_links', 'partitions' => NULL, 'type' => 'ref', 'possible_keys' => 'config_id', 'key' => 'config_id', 'key_len' => '4', 'ref' => 'const', 'rows' => 1, 'filtered' => 10.0, 'extra' => 'Using where', ) ]
[ SQL ] SELECT * FROM `shd_product_config_options_links` WHERE `config_id` = 166 AND `type` = 'condition' [ RunTime:0.000182s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'shd_product_config_options_links', 'partitions' => NULL, 'type' => 'ref', 'possible_keys' => 'config_id', 'key' => 'config_id', 'key_len' => '4', 'ref' => 'const', 'rows' => 1, 'filtered' => 10.0, 'extra' => 'Using where', ) ]
[ SQL ] SELECT * FROM `shd_product_config_options_links` WHERE `config_id` = 167 AND `type` = 'condition' [ RunTime:0.000233s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'shd_product_config_options_links', 'partitions' => NULL, 'type' => 'ref', 'possible_keys' => 'config_id', 'key' => 'config_id', 'key_len' => '4', 'ref' => 'const', 'rows' => 1, 'filtered' => 10.0, 'extra' => 'Using where', ) ]
[ SQL ] SELECT * FROM `shd_product_config_options_links` WHERE `config_id` = 165 AND `type` = 'condition' [ RunTime:0.000181s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'shd_product_config_options_links', 'partitions' => NULL, 'type' => 'ref', 'possible_keys' => 'config_id', 'key' => 'config_id', 'key_len' => '4', 'ref' => 'const', 'rows' => 1, 'filtered' => 10.0, 'extra' => 'Using where', ) ]
[ SQL ] SELECT `currency` FROM `shd_clients` WHERE `id` = 0 LIMIT 1 [ RunTime:0.000158s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => NULL, 'partitions' => NULL, 'type' => NULL, 'possible_keys' => NULL, 'key' => NULL, 'key_len' => NULL, 'ref' => NULL, 'rows' => NULL, 'filtered' => NULL, 'extra' => 'no matching row in const table', ) ]
[ SQL ] SELECT * FROM `shd_currencies` WHERE `default` = 1 LIMIT 1 [ RunTime:0.000164s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'shd_currencies', 'partitions' => NULL, 'type' => 'ref', 'possible_keys' => 'default', 'key' => 'default', 'key_len' => '1', 'ref' => 'const', 'rows' => 1, 'filtered' => 100.0, 'extra' => NULL, ) ]
[ SQL ] SELECT * FROM `shd_products` WHERE `id` = 37 LIMIT 1 [ RunTime:0.000383s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'shd_products', 'partitions' => NULL, 'type' => 'const', 'possible_keys' => 'PRIMARY', 'key' => 'PRIMARY', 'key_len' => '4', 'ref' => 'const', 'rows' => 1, 'filtered' => 100.0, 'extra' => NULL, ) ]
[ SQL ] SELECT * FROM `shd_pricing` WHERE `type` = 'product' AND `currency` = 1 AND `relid` = 37 LIMIT 1 [ RunTime:0.000262s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'shd_pricing', 'partitions' => NULL, 'type' => 'ref', 'possible_keys' => 'typerelid', 'key' => 'typerelid', 'key_len' => '5', 'ref' => 'const,const', 'rows' => 1, 'filtered' => 10.0, 'extra' => 'Using where', ) ]
[ SQL ] SELECT a.id as productid,`a`.`name`,`a`.`pay_type`,`b`.*,`a`.`api_type`,`a`.`upstream_version`,`a`.`upstream_price_type`,`a`.`upstream_price_value`,`a`.`hidden`,`a`.`stock_control`,`a`.`qty` FROM `shd_products` `a` LEFT JOIN `shd_pricing` `b` ON `a`.`id`=`b`.`relid` WHERE `a`.`id` = '37' AND `b`.`type` = 'product' AND `b`.`currency` = 1 LIMIT 1 [ RunTime:0.000291s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'a', 'partitions' => NULL, 'type' => 'const', 'possible_keys' => 'PRIMARY', 'key' => 'PRIMARY', 'key_len' => '4', 'ref' => 'const', 'rows' => 1, 'filtered' => 100.0, 'extra' => NULL, ) ]
[ SQL ] SELECT `a`.`type`,`a`.`bates` FROM `shd_user_product_bates` `a` LEFT JOIN `shd_user_products` `b` ON `a`.`products`=`b`.`gid` LEFT JOIN `shd_clients` `c` ON `a`.`user`=`c`.`groupid` WHERE `c`.`id` = '' AND `b`.`pid` = '37' LIMIT 1 [ RunTime:0.000190s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => NULL, 'partitions' => NULL, 'type' => NULL, 'possible_keys' => NULL, 'key' => NULL, 'key_len' => NULL, 'ref' => NULL, 'rows' => NULL, 'filtered' => NULL, 'extra' => 'no matching row in const table', ) ]
[ SQL ] SELECT `a`.* FROM `shd_product_config_options` `a` LEFT JOIN `shd_product_config_links` `b` ON `b`.`gid`=`a`.`gid` WHERE `b`.`pid` = '37' AND `a`.`hidden` = 0 ORDER BY `a`.`order` ASC [ RunTime:0.000321s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'b', 'partitions' => NULL, 'type' => 'index', 'possible_keys' => 'gpid', 'key' => 'gpid', 'key_len' => '8', 'ref' => NULL, 'rows' => 15, 'filtered' => 10.0, 'extra' => 'Using where; Using index; Using temporary; Using filesort', ) ]
[ SQL ] SELECT * FROM `shd_product_config_options_sub` WHERE `config_id` = 161 AND `id` = 533 LIMIT 1 [ RunTime:0.000167s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'shd_product_config_options_sub', 'partitions' => NULL, 'type' => 'const', 'possible_keys' => 'PRIMARY,configid', 'key' => 'PRIMARY', 'key_len' => '4', 'ref' => 'const', 'rows' => 1, 'filtered' => 100.0, 'extra' => NULL, ) ]
[ SQL ] SELECT * FROM `shd_product_config_options_sub` WHERE `config_id` = 168 AND `id` = 564 LIMIT 1 [ RunTime:0.000178s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'shd_product_config_options_sub', 'partitions' => NULL, 'type' => 'const', 'possible_keys' => 'PRIMARY,configid', 'key' => 'PRIMARY', 'key_len' => '4', 'ref' => 'const', 'rows' => 1, 'filtered' => 100.0, 'extra' => NULL, ) ]
[ SQL ] SELECT * FROM `shd_product_config_options_sub` WHERE `config_id` = 162 AND `id` = 534 LIMIT 1 [ RunTime:0.000169s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'shd_product_config_options_sub', 'partitions' => NULL, 'type' => 'const', 'possible_keys' => 'PRIMARY,configid', 'key' => 'PRIMARY', 'key_len' => '4', 'ref' => 'const', 'rows' => 1, 'filtered' => 100.0, 'extra' => NULL, ) ]
[ SQL ] SELECT * FROM `shd_product_config_options_sub` WHERE `config_id` = 163 AND `id` = 535 LIMIT 1 [ RunTime:0.000162s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'shd_product_config_options_sub', 'partitions' => NULL, 'type' => 'const', 'possible_keys' => 'PRIMARY,configid', 'key' => 'PRIMARY', 'key_len' => '4', 'ref' => 'const', 'rows' => 1, 'filtered' => 100.0, 'extra' => NULL, ) ]
[ SQL ] SELECT * FROM `shd_product_config_options_sub` WHERE `config_id` = 165 AND `id` = 537 LIMIT 1 [ RunTime:0.000165s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'shd_product_config_options_sub', 'partitions' => NULL, 'type' => 'const', 'possible_keys' => 'PRIMARY,configid', 'key' => 'PRIMARY', 'key_len' => '4', 'ref' => 'const', 'rows' => 1, 'filtered' => 100.0, 'extra' => NULL, ) ]
[ SQL ] SELECT `option_type`,`unit` FROM `shd_product_config_options` WHERE `id` = 161 LIMIT 1 [ RunTime:0.000140s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'shd_product_config_options', 'partitions' => NULL, 'type' => 'const', 'possible_keys' => 'PRIMARY', 'key' => 'PRIMARY', 'key_len' => '4', 'ref' => 'const', 'rows' => 1, 'filtered' => 100.0, 'extra' => NULL, ) ]
[ SQL ] SELECT `pco`.`is_discount`,pcos.option_name as suboption_name,`pco`.`option_type`,pco.option_name as option_name,`pco`.`hidden`,`p`.*,`pco`.`is_rebate` FROM `shd_product_config_options_sub` `pcos` LEFT JOIN `shd_product_config_options` `pco` ON `pco`.`id`=`pcos`.`config_id` LEFT JOIN `shd_pricing` `p` ON `p`.`relid`=`pcos`.`id` WHERE `pcos`.`id` = '533' AND `pcos`.`config_id` = 161 AND `p`.`type` = 'configoptions' AND `p`.`currency` = 1 LIMIT 1 [ RunTime:0.000302s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'pcos', 'partitions' => NULL, 'type' => 'const', 'possible_keys' => 'PRIMARY,configid', 'key' => 'PRIMARY', 'key_len' => '4', 'ref' => 'const', 'rows' => 1, 'filtered' => 100.0, 'extra' => NULL, ) ]
[ SQL ] SELECT `option_type`,`unit` FROM `shd_product_config_options` WHERE `id` = 168 LIMIT 1 [ RunTime:0.000153s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'shd_product_config_options', 'partitions' => NULL, 'type' => 'const', 'possible_keys' => 'PRIMARY', 'key' => 'PRIMARY', 'key_len' => '4', 'ref' => 'const', 'rows' => 1, 'filtered' => 100.0, 'extra' => NULL, ) ]
[ SQL ] SELECT `pco`.`is_discount`,pcos.option_name as suboption_name,`pco`.`option_type`,pco.option_name as option_name,`pco`.`hidden`,`p`.*,`pco`.`is_rebate` FROM `shd_product_config_options_sub` `pcos` LEFT JOIN `shd_product_config_options` `pco` ON `pco`.`id`=`pcos`.`config_id` LEFT JOIN `shd_pricing` `p` ON `p`.`relid`=`pcos`.`id` WHERE `pcos`.`id` = '564' AND `pcos`.`config_id` = 168 AND `p`.`type` = 'configoptions' AND `p`.`currency` = 1 LIMIT 1 [ RunTime:0.000280s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'pcos', 'partitions' => NULL, 'type' => 'const', 'possible_keys' => 'PRIMARY,configid', 'key' => 'PRIMARY', 'key_len' => '4', 'ref' => 'const', 'rows' => 1, 'filtered' => 100.0, 'extra' => NULL, ) ]
[ SQL ] SELECT `option_type`,`unit` FROM `shd_product_config_options` WHERE `id` = 162 LIMIT 1 [ RunTime:0.000144s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'shd_product_config_options', 'partitions' => NULL, 'type' => 'const', 'possible_keys' => 'PRIMARY', 'key' => 'PRIMARY', 'key_len' => '4', 'ref' => 'const', 'rows' => 1, 'filtered' => 100.0, 'extra' => NULL, ) ]
[ SQL ] SELECT `pco`.`is_discount`,pcos.option_name as suboption_name,`pco`.`option_type`,pco.option_name as option_name,`pco`.`hidden`,`p`.*,`pco`.`is_rebate` FROM `shd_product_config_options_sub` `pcos` LEFT JOIN `shd_product_config_options` `pco` ON `pco`.`id`=`pcos`.`config_id` LEFT JOIN `shd_pricing` `p` ON `p`.`relid`=`pcos`.`id` WHERE `pcos`.`id` = '534' AND `pcos`.`config_id` = 162 AND `p`.`type` = 'configoptions' AND `p`.`currency` = 1 LIMIT 1 [ RunTime:0.000282s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'pcos', 'partitions' => NULL, 'type' => 'const', 'possible_keys' => 'PRIMARY,configid', 'key' => 'PRIMARY', 'key_len' => '4', 'ref' => 'const', 'rows' => 1, 'filtered' => 100.0, 'extra' => NULL, ) ]
[ SQL ] SELECT `option_type`,`unit` FROM `shd_product_config_options` WHERE `id` = 163 LIMIT 1 [ RunTime:0.000164s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'shd_product_config_options', 'partitions' => NULL, 'type' => 'const', 'possible_keys' => 'PRIMARY', 'key' => 'PRIMARY', 'key_len' => '4', 'ref' => 'const', 'rows' => 1, 'filtered' => 100.0, 'extra' => NULL, ) ]
[ SQL ] SELECT `pco`.`is_discount`,pcos.option_name as suboption_name,`pco`.`option_type`,pco.option_name as option_name,`pco`.`hidden`,`p`.*,`pco`.`is_rebate` FROM `shd_product_config_options_sub` `pcos` LEFT JOIN `shd_product_config_options` `pco` ON `pco`.`id`=`pcos`.`config_id` LEFT JOIN `shd_pricing` `p` ON `p`.`relid`=`pcos`.`id` WHERE `pcos`.`id` = '535' AND `pcos`.`config_id` = 163 AND `p`.`type` = 'configoptions' AND `p`.`currency` = 1 LIMIT 1 [ RunTime:0.000288s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'pcos', 'partitions' => NULL, 'type' => 'const', 'possible_keys' => 'PRIMARY,configid', 'key' => 'PRIMARY', 'key_len' => '4', 'ref' => 'const', 'rows' => 1, 'filtered' => 100.0, 'extra' => NULL, ) ]
[ SQL ] SELECT `option_type`,`unit` FROM `shd_product_config_options` WHERE `id` = 164 LIMIT 1 [ RunTime:0.000172s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'shd_product_config_options', 'partitions' => NULL, 'type' => 'const', 'possible_keys' => 'PRIMARY', 'key' => 'PRIMARY', 'key_len' => '4', 'ref' => 'const', 'rows' => 1, 'filtered' => 100.0, 'extra' => NULL, ) ]
[ SQL ] SELECT pcos.option_name as suboption_name,`pcos`.`qty_minimum`,`pcos`.`qty_maximum`,`pco`.`option_type`,`pco`.`hidden`,pco.option_name as option_name,pco.qty_minimum as min,pco.qty_maximum as max,`pco`.`is_discount`,`p`.*,`pco`.`is_rebate` FROM `shd_product_config_options_sub` `pcos` LEFT JOIN `shd_product_config_options` `pco` ON `pco`.`id`=`pcos`.`config_id` LEFT JOIN `shd_pricing` `p` ON `p`.`relid`=`pcos`.`id` WHERE `pcos`.`config_id` = 164 AND `p`.`type` = 'configoptions' AND `currency` = 1 [ RunTime:0.000308s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'pcos', 'partitions' => NULL, 'type' => 'ref', 'possible_keys' => 'PRIMARY,configid', 'key' => 'configid', 'key_len' => '4', 'ref' => 'const', 'rows' => 1, 'filtered' => 100.0, 'extra' => NULL, ) ]
[ SQL ] SELECT `a`.`qty_minimum`,`a`.`qty_maximum` FROM `shd_product_config_options_sub` `a` LEFT JOIN `shd_pricing` `b` ON `a`.`id`=`b`.`relid` WHERE `b`.`type` = 'configoptions' AND `b`.`currency` = 1 AND `a`.`config_id` = 164 [ RunTime:0.000195s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'a', 'partitions' => NULL, 'type' => 'ref', 'possible_keys' => 'PRIMARY,configid', 'key' => 'configid', 'key_len' => '4', 'ref' => 'const', 'rows' => 1, 'filtered' => 100.0, 'extra' => NULL, ) ]
[ SQL ] SELECT * FROM `shd_product_config_options_sub` `a` LEFT JOIN `shd_pricing` `b` ON `a`.`id`=`b`.`relid` WHERE `b`.`type` = 'configoptions' AND `b`.`currency` = 1 AND `a`.`config_id` = 164 AND `a`.`qty_minimum` <= '100' AND `a`.`qty_maximum` >= '100' LIMIT 1 [ RunTime:0.000272s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'a', 'partitions' => NULL, 'type' => 'ref', 'possible_keys' => 'PRIMARY,configid', 'key' => 'configid', 'key_len' => '4', 'ref' => 'const', 'rows' => 1, 'filtered' => 11.108888626098633, 'extra' => 'Using where', ) ]
[ SQL ] SELECT `option_type`,`unit` FROM `shd_product_config_options` WHERE `id` = 166 LIMIT 1 [ RunTime:0.000164s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'shd_product_config_options', 'partitions' => NULL, 'type' => 'const', 'possible_keys' => 'PRIMARY', 'key' => 'PRIMARY', 'key_len' => '4', 'ref' => 'const', 'rows' => 1, 'filtered' => 100.0, 'extra' => NULL, ) ]
[ SQL ] SELECT pcos.option_name as suboption_name,`pcos`.`qty_minimum`,`pcos`.`qty_maximum`,`pco`.`option_type`,`pco`.`hidden`,pco.option_name as option_name,pco.qty_minimum as min,pco.qty_maximum as max,`pco`.`is_discount`,`p`.*,`pco`.`is_rebate` FROM `shd_product_config_options_sub` `pcos` LEFT JOIN `shd_product_config_options` `pco` ON `pco`.`id`=`pcos`.`config_id` LEFT JOIN `shd_pricing` `p` ON `p`.`relid`=`pcos`.`id` WHERE `pcos`.`config_id` = 166 AND `p`.`type` = 'configoptions' AND `currency` = 1 [ RunTime:0.000309s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'pcos', 'partitions' => NULL, 'type' => 'ref', 'possible_keys' => 'PRIMARY,configid', 'key' => 'configid', 'key_len' => '4', 'ref' => 'const', 'rows' => 1, 'filtered' => 100.0, 'extra' => NULL, ) ]
[ SQL ] SELECT `option_type`,`unit` FROM `shd_product_config_options` WHERE `id` = 167 LIMIT 1 [ RunTime:0.000150s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'shd_product_config_options', 'partitions' => NULL, 'type' => 'const', 'possible_keys' => 'PRIMARY', 'key' => 'PRIMARY', 'key_len' => '4', 'ref' => 'const', 'rows' => 1, 'filtered' => 100.0, 'extra' => NULL, ) ]
[ SQL ] SELECT pcos.option_name as suboption_name,`pcos`.`qty_minimum`,`pcos`.`qty_maximum`,`pco`.`option_type`,`pco`.`hidden`,pco.option_name as option_name,pco.qty_minimum as min,pco.qty_maximum as max,`pco`.`is_discount`,`p`.*,`pco`.`is_rebate` FROM `shd_product_config_options_sub` `pcos` LEFT JOIN `shd_product_config_options` `pco` ON `pco`.`id`=`pcos`.`config_id` LEFT JOIN `shd_pricing` `p` ON `p`.`relid`=`pcos`.`id` WHERE `pcos`.`config_id` = 167 AND `p`.`type` = 'configoptions' AND `currency` = 1 [ RunTime:0.000286s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'pcos', 'partitions' => NULL, 'type' => 'ref', 'possible_keys' => 'PRIMARY,configid', 'key' => 'configid', 'key_len' => '4', 'ref' => 'const', 'rows' => 1, 'filtered' => 100.0, 'extra' => NULL, ) ]
[ SQL ] SELECT `option_type`,`unit` FROM `shd_product_config_options` WHERE `id` = 165 LIMIT 1 [ RunTime:0.000146s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'shd_product_config_options', 'partitions' => NULL, 'type' => 'const', 'possible_keys' => 'PRIMARY', 'key' => 'PRIMARY', 'key_len' => '4', 'ref' => 'const', 'rows' => 1, 'filtered' => 100.0, 'extra' => NULL, ) ]
[ SQL ] SELECT `pco`.`is_discount`,pcos.option_name as suboption_name,`pco`.`option_type`,pco.option_name as option_name,`pco`.`hidden`,`p`.*,`pco`.`is_rebate` FROM `shd_product_config_options_sub` `pcos` LEFT JOIN `shd_product_config_options` `pco` ON `pco`.`id`=`pcos`.`config_id` LEFT JOIN `shd_pricing` `p` ON `p`.`relid`=`pcos`.`id` WHERE `pcos`.`id` = '537' AND `pcos`.`config_id` = 165 AND `p`.`type` = 'configoptions' AND `p`.`currency` = 1 LIMIT 1 [ RunTime:0.000279s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'pcos', 'partitions' => NULL, 'type' => 'const', 'possible_keys' => 'PRIMARY,configid', 'key' => 'PRIMARY', 'key_len' => '4', 'ref' => 'const', 'rows' => 1, 'filtered' => 100.0, 'extra' => NULL, ) ]
[ SQL ] SELECT * FROM `shd_product_config_options_links` WHERE `config_id` = 161 AND `type` = 'condition' [ RunTime:0.000202s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'shd_product_config_options_links', 'partitions' => NULL, 'type' => 'ref', 'possible_keys' => 'config_id', 'key' => 'config_id', 'key_len' => '4', 'ref' => 'const', 'rows' => 1, 'filtered' => 10.0, 'extra' => 'Using where', ) ]
[ SQL ] SELECT * FROM `shd_product_config_options_links` WHERE `config_id` = 168 AND `type` = 'condition' [ RunTime:0.000169s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'shd_product_config_options_links', 'partitions' => NULL, 'type' => 'ref', 'possible_keys' => 'config_id', 'key' => 'config_id', 'key_len' => '4', 'ref' => 'const', 'rows' => 1, 'filtered' => 10.0, 'extra' => 'Using where', ) ]
[ SQL ] SELECT * FROM `shd_product_config_options_links` WHERE `config_id` = 162 AND `type` = 'condition' [ RunTime:0.000185s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'shd_product_config_options_links', 'partitions' => NULL, 'type' => 'ref', 'possible_keys' => 'config_id', 'key' => 'config_id', 'key_len' => '4', 'ref' => 'const', 'rows' => 1, 'filtered' => 10.0, 'extra' => 'Using where', ) ]
[ SQL ] SELECT * FROM `shd_product_config_options_links` WHERE `config_id` = 163 AND `type` = 'condition' [ RunTime:0.000168s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'shd_product_config_options_links', 'partitions' => NULL, 'type' => 'ref', 'possible_keys' => 'config_id', 'key' => 'config_id', 'key_len' => '4', 'ref' => 'const', 'rows' => 1, 'filtered' => 10.0, 'extra' => 'Using where', ) ]
[ SQL ] SELECT * FROM `shd_product_config_options_links` WHERE `config_id` = 164 AND `type` = 'condition' [ RunTime:0.000157s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'shd_product_config_options_links', 'partitions' => NULL, 'type' => 'ref', 'possible_keys' => 'config_id', 'key' => 'config_id', 'key_len' => '4', 'ref' => 'const', 'rows' => 1, 'filtered' => 10.0, 'extra' => 'Using where', ) ]
[ SQL ] SELECT * FROM `shd_product_config_options_links` WHERE `config_id` = 166 AND `type` = 'condition' [ RunTime:0.000158s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'shd_product_config_options_links', 'partitions' => NULL, 'type' => 'ref', 'possible_keys' => 'config_id', 'key' => 'config_id', 'key_len' => '4', 'ref' => 'const', 'rows' => 1, 'filtered' => 10.0, 'extra' => 'Using where', ) ]
[ SQL ] SELECT * FROM `shd_product_config_options_links` WHERE `config_id` = 167 AND `type` = 'condition' [ RunTime:0.000159s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'shd_product_config_options_links', 'partitions' => NULL, 'type' => 'ref', 'possible_keys' => 'config_id', 'key' => 'config_id', 'key_len' => '4', 'ref' => 'const', 'rows' => 1, 'filtered' => 10.0, 'extra' => 'Using where', ) ]
[ SQL ] SELECT * FROM `shd_product_config_options_links` WHERE `config_id` = 165 AND `type` = 'condition' [ RunTime:0.000180s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'shd_product_config_options_links', 'partitions' => NULL, 'type' => 'ref', 'possible_keys' => 'config_id', 'key' => 'config_id', 'key_len' => '4', 'ref' => 'const', 'rows' => 1, 'filtered' => 10.0, 'extra' => 'Using where', ) ]
[ SQL ] SELECT `currency` FROM `shd_clients` WHERE `id` = 0 LIMIT 1 [ RunTime:0.000148s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => NULL, 'partitions' => NULL, 'type' => NULL, 'possible_keys' => NULL, 'key' => NULL, 'key_len' => NULL, 'ref' => NULL, 'rows' => NULL, 'filtered' => NULL, 'extra' => 'no matching row in const table', ) ]
[ SQL ] SELECT * FROM `shd_currencies` WHERE `default` = 1 LIMIT 1 [ RunTime:0.000162s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'shd_currencies', 'partitions' => NULL, 'type' => 'ref', 'possible_keys' => 'default', 'key' => 'default', 'key_len' => '1', 'ref' => 'const', 'rows' => 1, 'filtered' => 100.0, 'extra' => NULL, ) ]
[ SQL ] SELECT * FROM `shd_products` WHERE `id` = 37 LIMIT 1 [ RunTime:0.000369s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'shd_products', 'partitions' => NULL, 'type' => 'const', 'possible_keys' => 'PRIMARY', 'key' => 'PRIMARY', 'key_len' => '4', 'ref' => 'const', 'rows' => 1, 'filtered' => 100.0, 'extra' => NULL, ) ]
[ SQL ] SELECT * FROM `shd_pricing` WHERE `type` = 'product' AND `currency` = 1 AND `relid` = 37 LIMIT 1 [ RunTime:0.000260s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'shd_pricing', 'partitions' => NULL, 'type' => 'ref', 'possible_keys' => 'typerelid', 'key' => 'typerelid', 'key_len' => '5', 'ref' => 'const,const', 'rows' => 1, 'filtered' => 10.0, 'extra' => 'Using where', ) ]
[ SQL ] SELECT a.id as productid,`a`.`name`,`a`.`pay_type`,`b`.*,`a`.`api_type`,`a`.`upstream_version`,`a`.`upstream_price_type`,`a`.`upstream_price_value`,`a`.`hidden`,`a`.`stock_control`,`a`.`qty` FROM `shd_products` `a` LEFT JOIN `shd_pricing` `b` ON `a`.`id`=`b`.`relid` WHERE `a`.`id` = '37' AND `b`.`type` = 'product' AND `b`.`currency` = 1 LIMIT 1 [ RunTime:0.000287s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'a', 'partitions' => NULL, 'type' => 'const', 'possible_keys' => 'PRIMARY', 'key' => 'PRIMARY', 'key_len' => '4', 'ref' => 'const', 'rows' => 1, 'filtered' => 100.0, 'extra' => NULL, ) ]
[ SQL ] SELECT `a`.`type`,`a`.`bates` FROM `shd_user_product_bates` `a` LEFT JOIN `shd_user_products` `b` ON `a`.`products`=`b`.`gid` LEFT JOIN `shd_clients` `c` ON `a`.`user`=`c`.`groupid` WHERE `c`.`id` = '' AND `b`.`pid` = '37' LIMIT 1 [ RunTime:0.000181s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => NULL, 'partitions' => NULL, 'type' => NULL, 'possible_keys' => NULL, 'key' => NULL, 'key_len' => NULL, 'ref' => NULL, 'rows' => NULL, 'filtered' => NULL, 'extra' => 'no matching row in const table', ) ]
[ SQL ] SELECT `a`.* FROM `shd_product_config_options` `a` LEFT JOIN `shd_product_config_links` `b` ON `b`.`gid`=`a`.`gid` WHERE `b`.`pid` = '37' AND `a`.`hidden` = 0 ORDER BY `a`.`order` ASC [ RunTime:0.000313s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'b', 'partitions' => NULL, 'type' => 'index', 'possible_keys' => 'gpid', 'key' => 'gpid', 'key_len' => '8', 'ref' => NULL, 'rows' => 15, 'filtered' => 10.0, 'extra' => 'Using where; Using index; Using temporary; Using filesort', ) ]
[ SQL ] SELECT * FROM `shd_product_config_options_sub` WHERE `config_id` = 161 AND `id` = 533 LIMIT 1 [ RunTime:0.000166s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'shd_product_config_options_sub', 'partitions' => NULL, 'type' => 'const', 'possible_keys' => 'PRIMARY,configid', 'key' => 'PRIMARY', 'key_len' => '4', 'ref' => 'const', 'rows' => 1, 'filtered' => 100.0, 'extra' => NULL, ) ]
[ SQL ] SELECT * FROM `shd_product_config_options_sub` WHERE `config_id` = 168 AND `id` = 564 LIMIT 1 [ RunTime:0.000156s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'shd_product_config_options_sub', 'partitions' => NULL, 'type' => 'const', 'possible_keys' => 'PRIMARY,configid', 'key' => 'PRIMARY', 'key_len' => '4', 'ref' => 'const', 'rows' => 1, 'filtered' => 100.0, 'extra' => NULL, ) ]
[ SQL ] SELECT * FROM `shd_product_config_options_sub` WHERE `config_id` = 162 AND `id` = 534 LIMIT 1 [ RunTime:0.000158s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'shd_product_config_options_sub', 'partitions' => NULL, 'type' => 'const', 'possible_keys' => 'PRIMARY,configid', 'key' => 'PRIMARY', 'key_len' => '4', 'ref' => 'const', 'rows' => 1, 'filtered' => 100.0, 'extra' => NULL, ) ]
[ SQL ] SELECT * FROM `shd_product_config_options_sub` WHERE `config_id` = 163 AND `id` = 535 LIMIT 1 [ RunTime:0.000178s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'shd_product_config_options_sub', 'partitions' => NULL, 'type' => 'const', 'possible_keys' => 'PRIMARY,configid', 'key' => 'PRIMARY', 'key_len' => '4', 'ref' => 'const', 'rows' => 1, 'filtered' => 100.0, 'extra' => NULL, ) ]
[ SQL ] SELECT * FROM `shd_product_config_options_sub` WHERE `config_id` = 165 AND `id` = 537 LIMIT 1 [ RunTime:0.000172s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'shd_product_config_options_sub', 'partitions' => NULL, 'type' => 'const', 'possible_keys' => 'PRIMARY,configid', 'key' => 'PRIMARY', 'key_len' => '4', 'ref' => 'const', 'rows' => 1, 'filtered' => 100.0, 'extra' => NULL, ) ]
[ SQL ] SELECT `option_type`,`unit` FROM `shd_product_config_options` WHERE `id` = 161 LIMIT 1 [ RunTime:0.000146s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'shd_product_config_options', 'partitions' => NULL, 'type' => 'const', 'possible_keys' => 'PRIMARY', 'key' => 'PRIMARY', 'key_len' => '4', 'ref' => 'const', 'rows' => 1, 'filtered' => 100.0, 'extra' => NULL, ) ]
[ SQL ] SELECT `pco`.`is_discount`,pcos.option_name as suboption_name,`pco`.`option_type`,pco.option_name as option_name,`pco`.`hidden`,`p`.*,`pco`.`is_rebate` FROM `shd_product_config_options_sub` `pcos` LEFT JOIN `shd_product_config_options` `pco` ON `pco`.`id`=`pcos`.`config_id` LEFT JOIN `shd_pricing` `p` ON `p`.`relid`=`pcos`.`id` WHERE `pcos`.`id` = '533' AND `pcos`.`config_id` = 161 AND `p`.`type` = 'configoptions' AND `p`.`currency` = 1 LIMIT 1 [ RunTime:0.000280s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'pcos', 'partitions' => NULL, 'type' => 'const', 'possible_keys' => 'PRIMARY,configid', 'key' => 'PRIMARY', 'key_len' => '4', 'ref' => 'const', 'rows' => 1, 'filtered' => 100.0, 'extra' => NULL, ) ]
[ SQL ] SELECT `option_type`,`unit` FROM `shd_product_config_options` WHERE `id` = 168 LIMIT 1 [ RunTime:0.000150s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'shd_product_config_options', 'partitions' => NULL, 'type' => 'const', 'possible_keys' => 'PRIMARY', 'key' => 'PRIMARY', 'key_len' => '4', 'ref' => 'const', 'rows' => 1, 'filtered' => 100.0, 'extra' => NULL, ) ]
[ SQL ] SELECT `pco`.`is_discount`,pcos.option_name as suboption_name,`pco`.`option_type`,pco.option_name as option_name,`pco`.`hidden`,`p`.*,`pco`.`is_rebate` FROM `shd_product_config_options_sub` `pcos` LEFT JOIN `shd_product_config_options` `pco` ON `pco`.`id`=`pcos`.`config_id` LEFT JOIN `shd_pricing` `p` ON `p`.`relid`=`pcos`.`id` WHERE `pcos`.`id` = '564' AND `pcos`.`config_id` = 168 AND `p`.`type` = 'configoptions' AND `p`.`currency` = 1 LIMIT 1 [ RunTime:0.000293s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'pcos', 'partitions' => NULL, 'type' => 'const', 'possible_keys' => 'PRIMARY,configid', 'key' => 'PRIMARY', 'key_len' => '4', 'ref' => 'const', 'rows' => 1, 'filtered' => 100.0, 'extra' => NULL, ) ]
[ SQL ] SELECT `option_type`,`unit` FROM `shd_product_config_options` WHERE `id` = 162 LIMIT 1 [ RunTime:0.000189s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'shd_product_config_options', 'partitions' => NULL, 'type' => 'const', 'possible_keys' => 'PRIMARY', 'key' => 'PRIMARY', 'key_len' => '4', 'ref' => 'const', 'rows' => 1, 'filtered' => 100.0, 'extra' => NULL, ) ]
[ SQL ] SELECT `pco`.`is_discount`,pcos.option_name as suboption_name,`pco`.`option_type`,pco.option_name as option_name,`pco`.`hidden`,`p`.*,`pco`.`is_rebate` FROM `shd_product_config_options_sub` `pcos` LEFT JOIN `shd_product_config_options` `pco` ON `pco`.`id`=`pcos`.`config_id` LEFT JOIN `shd_pricing` `p` ON `p`.`relid`=`pcos`.`id` WHERE `pcos`.`id` = '534' AND `pcos`.`config_id` = 162 AND `p`.`type` = 'configoptions' AND `p`.`currency` = 1 LIMIT 1 [ RunTime:0.000284s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'pcos', 'partitions' => NULL, 'type' => 'const', 'possible_keys' => 'PRIMARY,configid', 'key' => 'PRIMARY', 'key_len' => '4', 'ref' => 'const', 'rows' => 1, 'filtered' => 100.0, 'extra' => NULL, ) ]
[ SQL ] SELECT `option_type`,`unit` FROM `shd_product_config_options` WHERE `id` = 163 LIMIT 1 [ RunTime:0.000146s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'shd_product_config_options', 'partitions' => NULL, 'type' => 'const', 'possible_keys' => 'PRIMARY', 'key' => 'PRIMARY', 'key_len' => '4', 'ref' => 'const', 'rows' => 1, 'filtered' => 100.0, 'extra' => NULL, ) ]
[ SQL ] SELECT `pco`.`is_discount`,pcos.option_name as suboption_name,`pco`.`option_type`,pco.option_name as option_name,`pco`.`hidden`,`p`.*,`pco`.`is_rebate` FROM `shd_product_config_options_sub` `pcos` LEFT JOIN `shd_product_config_options` `pco` ON `pco`.`id`=`pcos`.`config_id` LEFT JOIN `shd_pricing` `p` ON `p`.`relid`=`pcos`.`id` WHERE `pcos`.`id` = '535' AND `pcos`.`config_id` = 163 AND `p`.`type` = 'configoptions' AND `p`.`currency` = 1 LIMIT 1 [ RunTime:0.000281s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'pcos', 'partitions' => NULL, 'type' => 'const', 'possible_keys' => 'PRIMARY,configid', 'key' => 'PRIMARY', 'key_len' => '4', 'ref' => 'const', 'rows' => 1, 'filtered' => 100.0, 'extra' => NULL, ) ]
[ SQL ] SELECT `option_type`,`unit` FROM `shd_product_config_options` WHERE `id` = 164 LIMIT 1 [ RunTime:0.000154s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'shd_product_config_options', 'partitions' => NULL, 'type' => 'const', 'possible_keys' => 'PRIMARY', 'key' => 'PRIMARY', 'key_len' => '4', 'ref' => 'const', 'rows' => 1, 'filtered' => 100.0, 'extra' => NULL, ) ]
[ SQL ] SELECT pcos.option_name as suboption_name,`pcos`.`qty_minimum`,`pcos`.`qty_maximum`,`pco`.`option_type`,`pco`.`hidden`,pco.option_name as option_name,pco.qty_minimum as min,pco.qty_maximum as max,`pco`.`is_discount`,`p`.*,`pco`.`is_rebate` FROM `shd_product_config_options_sub` `pcos` LEFT JOIN `shd_product_config_options` `pco` ON `pco`.`id`=`pcos`.`config_id` LEFT JOIN `shd_pricing` `p` ON `p`.`relid`=`pcos`.`id` WHERE `pcos`.`config_id` = 164 AND `p`.`type` = 'configoptions' AND `currency` = 1 [ RunTime:0.000295s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'pcos', 'partitions' => NULL, 'type' => 'ref', 'possible_keys' => 'PRIMARY,configid', 'key' => 'configid', 'key_len' => '4', 'ref' => 'const', 'rows' => 1, 'filtered' => 100.0, 'extra' => NULL, ) ]
[ SQL ] SELECT `a`.`qty_minimum`,`a`.`qty_maximum` FROM `shd_product_config_options_sub` `a` LEFT JOIN `shd_pricing` `b` ON `a`.`id`=`b`.`relid` WHERE `b`.`type` = 'configoptions' AND `b`.`currency` = 1 AND `a`.`config_id` = 164 [ RunTime:0.000207s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'a', 'partitions' => NULL, 'type' => 'ref', 'possible_keys' => 'PRIMARY,configid', 'key' => 'configid', 'key_len' => '4', 'ref' => 'const', 'rows' => 1, 'filtered' => 100.0, 'extra' => NULL, ) ]
[ SQL ] SELECT * FROM `shd_product_config_options_sub` `a` LEFT JOIN `shd_pricing` `b` ON `a`.`id`=`b`.`relid` WHERE `b`.`type` = 'configoptions' AND `b`.`currency` = 1 AND `a`.`config_id` = 164 AND `a`.`qty_minimum` <= '100' AND `a`.`qty_maximum` >= '100' LIMIT 1 [ RunTime:0.000287s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'a', 'partitions' => NULL, 'type' => 'ref', 'possible_keys' => 'PRIMARY,configid', 'key' => 'configid', 'key_len' => '4', 'ref' => 'const', 'rows' => 1, 'filtered' => 11.108888626098633, 'extra' => 'Using where', ) ]
[ SQL ] SELECT `option_type`,`unit` FROM `shd_product_config_options` WHERE `id` = 166 LIMIT 1 [ RunTime:0.000241s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'shd_product_config_options', 'partitions' => NULL, 'type' => 'const', 'possible_keys' => 'PRIMARY', 'key' => 'PRIMARY', 'key_len' => '4', 'ref' => 'const', 'rows' => 1, 'filtered' => 100.0, 'extra' => NULL, ) ]
[ SQL ] SELECT pcos.option_name as suboption_name,`pcos`.`qty_minimum`,`pcos`.`qty_maximum`,`pco`.`option_type`,`pco`.`hidden`,pco.option_name as option_name,pco.qty_minimum as min,pco.qty_maximum as max,`pco`.`is_discount`,`p`.*,`pco`.`is_rebate` FROM `shd_product_config_options_sub` `pcos` LEFT JOIN `shd_product_config_options` `pco` ON `pco`.`id`=`pcos`.`config_id` LEFT JOIN `shd_pricing` `p` ON `p`.`relid`=`pcos`.`id` WHERE `pcos`.`config_id` = 166 AND `p`.`type` = 'configoptions' AND `currency` = 1 [ RunTime:0.000404s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'pcos', 'partitions' => NULL, 'type' => 'ref', 'possible_keys' => 'PRIMARY,configid', 'key' => 'configid', 'key_len' => '4', 'ref' => 'const', 'rows' => 1, 'filtered' => 100.0, 'extra' => NULL, ) ]
[ SQL ] SELECT `option_type`,`unit` FROM `shd_product_config_options` WHERE `id` = 167 LIMIT 1 [ RunTime:0.000169s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'shd_product_config_options', 'partitions' => NULL, 'type' => 'const', 'possible_keys' => 'PRIMARY', 'key' => 'PRIMARY', 'key_len' => '4', 'ref' => 'const', 'rows' => 1, 'filtered' => 100.0, 'extra' => NULL, ) ]
[ SQL ] SELECT pcos.option_name as suboption_name,`pcos`.`qty_minimum`,`pcos`.`qty_maximum`,`pco`.`option_type`,`pco`.`hidden`,pco.option_name as option_name,pco.qty_minimum as min,pco.qty_maximum as max,`pco`.`is_discount`,`p`.*,`pco`.`is_rebate` FROM `shd_product_config_options_sub` `pcos` LEFT JOIN `shd_product_config_options` `pco` ON `pco`.`id`=`pcos`.`config_id` LEFT JOIN `shd_pricing` `p` ON `p`.`relid`=`pcos`.`id` WHERE `pcos`.`config_id` = 167 AND `p`.`type` = 'configoptions' AND `currency` = 1 [ RunTime:0.000329s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'pcos', 'partitions' => NULL, 'type' => 'ref', 'possible_keys' => 'PRIMARY,configid', 'key' => 'configid', 'key_len' => '4', 'ref' => 'const', 'rows' => 1, 'filtered' => 100.0, 'extra' => NULL, ) ]
[ SQL ] SELECT `option_type`,`unit` FROM `shd_product_config_options` WHERE `id` = 165 LIMIT 1 [ RunTime:0.018220s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'shd_product_config_options', 'partitions' => NULL, 'type' => 'const', 'possible_keys' => 'PRIMARY', 'key' => 'PRIMARY', 'key_len' => '4', 'ref' => 'const', 'rows' => 1, 'filtered' => 100.0, 'extra' => NULL, ) ]
[ SQL ] SELECT `pco`.`is_discount`,pcos.option_name as suboption_name,`pco`.`option_type`,pco.option_name as option_name,`pco`.`hidden`,`p`.*,`pco`.`is_rebate` FROM `shd_product_config_options_sub` `pcos` LEFT JOIN `shd_product_config_options` `pco` ON `pco`.`id`=`pcos`.`config_id` LEFT JOIN `shd_pricing` `p` ON `p`.`relid`=`pcos`.`id` WHERE `pcos`.`id` = '537' AND `pcos`.`config_id` = 165 AND `p`.`type` = 'configoptions' AND `p`.`currency` = 1 LIMIT 1 [ RunTime:0.000474s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'pcos', 'partitions' => NULL, 'type' => 'const', 'possible_keys' => 'PRIMARY,configid', 'key' => 'PRIMARY', 'key_len' => '4', 'ref' => 'const', 'rows' => 1, 'filtered' => 100.0, 'extra' => NULL, ) ]
[ SQL ] SELECT `value` FROM `shd_configuration` WHERE ( setting = 'language' ) LIMIT 1 [ RunTime:0.000320s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'shd_configuration', 'partitions' => NULL, 'type' => 'ref', 'possible_keys' => 'setting', 'key' => 'setting', 'key_len' => '130', 'ref' => 'const', 'rows' => 1, 'filtered' => 100.0, 'extra' => 'Using where', ) ]
[ SQL ] SELECT `value` FROM `shd_configuration` WHERE ( setting = 'order_page_style' ) LIMIT 1 [ RunTime:0.000274s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'shd_configuration', 'partitions' => NULL, 'type' => 'ref', 'possible_keys' => 'setting', 'key' => 'setting', 'key_len' => '130', 'ref' => 'const', 'rows' => 1, 'filtered' => 100.0, 'extra' => 'Using where', ) ]
[ SQL ] SELECT `value` FROM `shd_configuration` WHERE ( setting = 'VIEW_TEMPLATE_SETTING_NAME' ) LIMIT 1 [ RunTime:0.000239s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'shd_configuration', 'partitions' => NULL, 'type' => 'ref', 'possible_keys' => 'setting', 'key' => 'setting', 'key_len' => '130', 'ref' => 'const', 'rows' => 1, 'filtered' => 100.0, 'extra' => 'Using where', ) ]
[ SQL ] SELECT `value` FROM `shd_configuration` WHERE ( setting = 'VIEW_TEMPLATE_SETTING_NAME' ) LIMIT 1 [ RunTime:0.000240s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'shd_configuration', 'partitions' => NULL, 'type' => 'ref', 'possible_keys' => 'setting', 'key' => 'setting', 'key_len' => '130', 'ref' => 'const', 'rows' => 1, 'filtered' => 100.0, 'extra' => 'Using where', ) ]
[ SQL ] SHOW COLUMNS FROM `shd_system_message` [ RunTime:0.000613s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `shd_system_message` WHERE `delete_time` = 0 AND `read_time` = 0 AND `type` = 1 AND `uid` = 0 [ RunTime:0.000260s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'shd_system_message', 'partitions' => NULL, 'type' => 'ref', 'possible_keys' => 'uid', 'key' => 'uid', 'key_len' => '4', 'ref' => 'const', 'rows' => 1, 'filtered' => 100.0, 'extra' => 'Using where', ) ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `shd_system_message` WHERE `delete_time` = 0 AND `read_time` = 0 AND `type` = 2 AND `uid` = 0 [ RunTime:0.000245s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'shd_system_message', 'partitions' => NULL, 'type' => 'ref', 'possible_keys' => 'uid', 'key' => 'uid', 'key_len' => '4', 'ref' => 'const', 'rows' => 1, 'filtered' => 100.0, 'extra' => 'Using where', ) ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `shd_system_message` WHERE `delete_time` = 0 AND `read_time` = 0 AND `type` = 3 AND `uid` = 0 [ RunTime:0.000242s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'shd_system_message', 'partitions' => NULL, 'type' => 'ref', 'possible_keys' => 'uid', 'key' => 'uid', 'key_len' => '4', 'ref' => 'const', 'rows' => 1, 'filtered' => 100.0, 'extra' => 'Using where', ) ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `shd_system_message` WHERE `delete_time` = 0 AND `read_time` = 0 AND `type` = 4 AND `uid` = 0 [ RunTime:0.000223s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'shd_system_message', 'partitions' => NULL, 'type' => 'ref', 'possible_keys' => 'uid', 'key' => 'uid', 'key_len' => '4', 'ref' => 'const', 'rows' => 1, 'filtered' => 100.0, 'extra' => 'Using where', ) ]
[ SQL ] SELECT `value` FROM `shd_configuration` WHERE ( setting = 'record_no' ) LIMIT 1 [ RunTime:0.000210s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'shd_configuration', 'partitions' => NULL, 'type' => 'ref', 'possible_keys' => 'setting', 'key' => 'setting', 'key_len' => '130', 'ref' => 'const', 'rows' => 1, 'filtered' => 100.0, 'extra' => 'Using where', ) ]
[ SQL ] SELECT `value` FROM `shd_configuration` WHERE ( setting = 'company_email' ) LIMIT 1 [ RunTime:0.000211s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'shd_configuration', 'partitions' => NULL, 'type' => 'ref', 'possible_keys' => 'setting', 'key' => 'setting', 'key_len' => '130', 'ref' => 'const', 'rows' => 1, 'filtered' => 100.0, 'extra' => 'Using where', ) ]
[ SQL ] SELECT `value` FROM `shd_configuration` WHERE ( setting = 'company_profile' ) LIMIT 1 [ RunTime:0.000219s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'shd_configuration', 'partitions' => NULL, 'type' => 'ref', 'possible_keys' => 'setting', 'key' => 'setting', 'key_len' => '130', 'ref' => 'const', 'rows' => 1, 'filtered' => 100.0, 'extra' => 'Using where', ) ]
[ SQL ] SELECT `value` FROM `shd_configuration` WHERE ( setting = 'main_address' ) LIMIT 1 [ RunTime:0.000206s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'shd_configuration', 'partitions' => NULL, 'type' => 'ref', 'possible_keys' => 'setting', 'key' => 'setting', 'key_len' => '130', 'ref' => 'const', 'rows' => 1, 'filtered' => 100.0, 'extra' => 'Using where', ) ]
[ SQL ] SELECT `value` FROM `shd_configuration` WHERE ( setting = 'main_phone' ) LIMIT 1 [ RunTime:0.000221s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'shd_configuration', 'partitions' => NULL, 'type' => 'ref', 'possible_keys' => 'setting', 'key' => 'setting', 'key_len' => '130', 'ref' => 'const', 'rows' => 1, 'filtered' => 100.0, 'extra' => 'Using where', ) ]
[ SQL ] SELECT `value` FROM `shd_configuration` WHERE ( setting = 'company_name' ) LIMIT 1 [ RunTime:0.000214s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'shd_configuration', 'partitions' => NULL, 'type' => 'ref', 'possible_keys' => 'setting', 'key' => 'setting', 'key_len' => '130', 'ref' => 'const', 'rows' => 1, 'filtered' => 100.0, 'extra' => 'Using where', ) ]
[ SQL ] SELECT `value` FROM `shd_configuration` WHERE ( setting = 'company_qq' ) LIMIT 1 [ RunTime:0.000206s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'shd_configuration', 'partitions' => NULL, 'type' => 'ref', 'possible_keys' => 'setting', 'key' => 'setting', 'key_len' => '130', 'ref' => 'const', 'rows' => 1, 'filtered' => 100.0, 'extra' => 'Using where', ) ]
[ SQL ] SELECT `value` FROM `shd_configuration` WHERE ( setting = 'map' ) LIMIT 1 [ RunTime:0.000374s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'shd_configuration', 'partitions' => NULL, 'type' => 'ref', 'possible_keys' => 'setting', 'key' => 'setting', 'key_len' => '130', 'ref' => 'const', 'rows' => 1, 'filtered' => 100.0, 'extra' => 'Using where', ) ]
[ SQL ] SELECT `value` FROM `shd_configuration` WHERE ( setting = 'allow_user_language' ) LIMIT 1 [ RunTime:0.000211s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'shd_configuration', 'partitions' => NULL, 'type' => 'ref', 'possible_keys' => 'setting', 'key' => 'setting', 'key_len' => '130', 'ref' => 'const', 'rows' => 1, 'filtered' => 100.0, 'extra' => 'Using where', ) ]
[ SQL ] SELECT `value` FROM `shd_configuration` WHERE ( setting = 'login_header_footer' ) LIMIT 1 [ RunTime:0.000193s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'shd_configuration', 'partitions' => NULL, 'type' => 'ref', 'possible_keys' => 'setting', 'key' => 'setting', 'key_len' => '130', 'ref' => 'const', 'rows' => 1, 'filtered' => 100.0, 'extra' => 'Using where', ) ]
[ SQL ] SELECT `value` FROM `shd_configuration` WHERE ( setting = 'logo_url' ) LIMIT 1 [ RunTime:0.000184s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'shd_configuration', 'partitions' => NULL, 'type' => 'ref', 'possible_keys' => 'setting', 'key' => 'setting', 'key_len' => '130', 'ref' => 'const', 'rows' => 1, 'filtered' => 100.0, 'extra' => 'Using where', ) ]
[ SQL ] SELECT `value` FROM `shd_configuration` WHERE ( setting = 'logo_url_home' ) LIMIT 1 [ RunTime:0.000146s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'shd_configuration', 'partitions' => NULL, 'type' => 'ref', 'possible_keys' => 'setting', 'key' => 'setting', 'key_len' => '130', 'ref' => 'const', 'rows' => 1, 'filtered' => 100.0, 'extra' => 'Using where', ) ]
[ SQL ] SELECT `value` FROM `shd_configuration` WHERE ( setting = 'logo_url_home_mini' ) LIMIT 1 [ RunTime:0.000159s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'shd_configuration', 'partitions' => NULL, 'type' => 'ref', 'possible_keys' => 'setting', 'key' => 'setting', 'key_len' => '130', 'ref' => 'const', 'rows' => 1, 'filtered' => 100.0, 'extra' => 'Using where', ) ]
[ SQL ] SELECT `value` FROM `shd_configuration` WHERE ( setting = 'logo_url_bill' ) LIMIT 1 [ RunTime:0.000161s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'shd_configuration', 'partitions' => NULL, 'type' => 'ref', 'possible_keys' => 'setting', 'key' => 'setting', 'key_len' => '130', 'ref' => 'const', 'rows' => 1, 'filtered' => 100.0, 'extra' => 'Using where', ) ]
[ SQL ] SELECT `value` FROM `shd_configuration` WHERE ( setting = 'www_logo' ) LIMIT 1 [ RunTime:0.000164s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'shd_configuration', 'partitions' => NULL, 'type' => 'ref', 'possible_keys' => 'setting', 'key' => 'setting', 'key_len' => '130', 'ref' => 'const', 'rows' => 1, 'filtered' => 100.0, 'extra' => 'Using where', ) ]
[ SQL ] SELECT `value` FROM `shd_configuration` WHERE ( setting = 'seo_keywords' ) LIMIT 1 [ RunTime:0.000167s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'shd_configuration', 'partitions' => NULL, 'type' => 'ref', 'possible_keys' => 'setting', 'key' => 'setting', 'key_len' => '130', 'ref' => 'const', 'rows' => 1, 'filtered' => 100.0, 'extra' => 'Using where', ) ]
[ SQL ] SELECT `value` FROM `shd_configuration` WHERE ( setting = 'seo_desc' ) LIMIT 1 [ RunTime:0.000209s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'shd_configuration', 'partitions' => NULL, 'type' => 'ref', 'possible_keys' => 'setting', 'key' => 'setting', 'key_len' => '130', 'ref' => 'const', 'rows' => 1, 'filtered' => 100.0, 'extra' => 'Using where', ) ]
[ SQL ] SELECT `value` FROM `shd_configuration` WHERE ( setting = 'server_clause_url' ) LIMIT 1 [ RunTime:0.000204s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'shd_configuration', 'partitions' => NULL, 'type' => 'ref', 'possible_keys' => 'setting', 'key' => 'setting', 'key_len' => '130', 'ref' => 'const', 'rows' => 1, 'filtered' => 100.0, 'extra' => 'Using where', ) ]
[ SQL ] SELECT `value` FROM `shd_configuration` WHERE ( setting = 'privacy_clause_url' ) LIMIT 1 [ RunTime:0.000180s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'shd_configuration', 'partitions' => NULL, 'type' => 'ref', 'possible_keys' => 'setting', 'key' => 'setting', 'key_len' => '130', 'ref' => 'const', 'rows' => 1, 'filtered' => 100.0, 'extra' => 'Using where', ) ]
[ SQL ] SELECT `value` FROM `shd_configuration` WHERE ( setting = 'cart_product_description' ) LIMIT 1 [ RunTime:0.000188s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'shd_configuration', 'partitions' => NULL, 'type' => 'ref', 'possible_keys' => 'setting', 'key' => 'setting', 'key_len' => '130', 'ref' => 'const', 'rows' => 1, 'filtered' => 100.0, 'extra' => 'Using where', ) ]
[ SQL ] SELECT `value` FROM `shd_configuration` WHERE ( setting = 'main_tenance_mode' ) LIMIT 1 [ RunTime:0.000148s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'shd_configuration', 'partitions' => NULL, 'type' => 'ref', 'possible_keys' => 'setting', 'key' => 'setting', 'key_len' => '130', 'ref' => 'const', 'rows' => 1, 'filtered' => 100.0, 'extra' => 'Using where', ) ]
[ SQL ] SELECT `value` FROM `shd_configuration` WHERE ( setting = 'system_url' ) LIMIT 1 [ RunTime:0.000151s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'shd_configuration', 'partitions' => NULL, 'type' => 'ref', 'possible_keys' => 'setting', 'key' => 'setting', 'key_len' => '130', 'ref' => 'const', 'rows' => 1, 'filtered' => 100.0, 'extra' => 'Using where', ) ]
[ SQL ] SELECT `value` FROM `shd_configuration` WHERE ( setting = 'custom_login_background_img' ) LIMIT 1 [ RunTime:0.000148s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'shd_configuration', 'partitions' => NULL, 'type' => 'ref', 'possible_keys' => 'setting', 'key' => 'setting', 'key_len' => '130', 'ref' => 'const', 'rows' => 1, 'filtered' => 100.0, 'extra' => 'Using where', ) ]
[ SQL ] SELECT `value` FROM `shd_configuration` WHERE ( setting = 'custom_login_background_char' ) LIMIT 1 [ RunTime:0.000179s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'shd_configuration', 'partitions' => NULL, 'type' => 'ref', 'possible_keys' => 'setting', 'key' => 'setting', 'key_len' => '130', 'ref' => 'const', 'rows' => 1, 'filtered' => 100.0, 'extra' => 'Using where', ) ]
[ SQL ] SELECT `value` FROM `shd_configuration` WHERE ( setting = 'custom_login_background_description' ) LIMIT 1 [ RunTime:0.000177s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'shd_configuration', 'partitions' => NULL, 'type' => 'ref', 'possible_keys' => 'setting', 'key' => 'setting', 'key_len' => '130', 'ref' => 'const', 'rows' => 1, 'filtered' => 100.0, 'extra' => 'Using where', ) ]
[ SQL ] SELECT `value` FROM `shd_configuration` WHERE ( setting = 'certifi_open' ) LIMIT 1 [ RunTime:0.000147s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'shd_configuration', 'partitions' => NULL, 'type' => 'ref', 'possible_keys' => 'setting', 'key' => 'setting', 'key_len' => '130', 'ref' => 'const', 'rows' => 1, 'filtered' => 100.0, 'extra' => 'Using where', ) ]
[ SQL ] SELECT `setting`,`value` FROM `shd_configuration` WHERE `setting` IN ('certifi_open','certifi_is_upload','certifi_business_open','certifi_business_is_upload','certifi_business_is_author','certifi_business_author_path') [ RunTime:0.000209s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'shd_configuration', 'partitions' => NULL, 'type' => 'range', 'possible_keys' => 'setting', 'key' => 'setting', 'key_len' => '130', 'ref' => NULL, 'rows' => 6, 'filtered' => 100.0, 'extra' => 'Using where', ) ]
[ SQL ] SELECT `value` FROM `shd_configuration` WHERE ( setting = 'VIEW_TEMPLATE_SETTING_NAME' ) LIMIT 1 [ RunTime:0.000201s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'shd_configuration', 'partitions' => NULL, 'type' => 'ref', 'possible_keys' => 'setting', 'key' => 'setting', 'key_len' => '130', 'ref' => 'const', 'rows' => 1, 'filtered' => 100.0, 'extra' => 'Using where', ) ]
[ SQL ] SELECT `value` FROM `shd_configuration` WHERE ( setting = 'themes_templates' ) LIMIT 1 [ RunTime:0.000171s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'shd_configuration', 'partitions' => NULL, 'type' => 'ref', 'possible_keys' => 'setting', 'key' => 'setting', 'key_len' => '130', 'ref' => 'const', 'rows' => 1, 'filtered' => 100.0, 'extra' => 'Using where', ) ]
[ SQL ] SELECT `value` FROM `shd_configuration` WHERE ( setting = 'zjmf_authorize' ) LIMIT 1 [ RunTime:0.000149s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'shd_configuration', 'partitions' => NULL, 'type' => 'ref', 'possible_keys' => 'setting', 'key' => 'setting', 'key_len' => '130', 'ref' => 'const', 'rows' => 1, 'filtered' => 100.0, 'extra' => 'Using where', ) ]
[ SQL ] SELECT `value` FROM `shd_configuration` WHERE ( setting = 'second_verify_action_home_type' ) LIMIT 1 [ RunTime:0.000165s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'shd_configuration', 'partitions' => NULL, 'type' => 'ref', 'possible_keys' => 'setting', 'key' => 'setting', 'key_len' => '130', 'ref' => 'const', 'rows' => 1, 'filtered' => 100.0, 'extra' => 'Using where', ) ]
[ SQL ] SELECT `phone_code`,`phonenumber`,`email` FROM `shd_clients` WHERE `id` IS NULL LIMIT 1 [ RunTime:0.000127s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => NULL, 'partitions' => NULL, 'type' => NULL, 'possible_keys' => NULL, 'key' => NULL, 'key_len' => NULL, 'ref' => NULL, 'rows' => NULL, 'filtered' => NULL, 'extra' => 'Impossible WHERE', ) ]
[ SQL ] SELECT `value` FROM `shd_configuration` WHERE ( setting = 'is_captcha' ) LIMIT 1 [ RunTime:0.000166s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'shd_configuration', 'partitions' => NULL, 'type' => 'ref', 'possible_keys' => 'setting', 'key' => 'setting', 'key_len' => '130', 'ref' => 'const', 'rows' => 1, 'filtered' => 100.0, 'extra' => 'Using where', ) ]
[ SQL ] SELECT `value` FROM `shd_configuration` WHERE ( setting = 'allow_register_email_captcha' ) LIMIT 1 [ RunTime:0.000161s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'shd_configuration', 'partitions' => NULL, 'type' => 'ref', 'possible_keys' => 'setting', 'key' => 'setting', 'key_len' => '130', 'ref' => 'const', 'rows' => 1, 'filtered' => 100.0, 'extra' => 'Using where', ) ]
[ SQL ] SELECT `value` FROM `shd_configuration` WHERE ( setting = 'allow_register_phone_captcha' ) LIMIT 1 [ RunTime:0.000154s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'shd_configuration', 'partitions' => NULL, 'type' => 'ref', 'possible_keys' => 'setting', 'key' => 'setting', 'key_len' => '130', 'ref' => 'const', 'rows' => 1, 'filtered' => 100.0, 'extra' => 'Using where', ) ]
[ SQL ] SELECT `value` FROM `shd_configuration` WHERE ( setting = 'allow_login_phone_captcha' ) LIMIT 1 [ RunTime:0.000147s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'shd_configuration', 'partitions' => NULL, 'type' => 'ref', 'possible_keys' => 'setting', 'key' => 'setting', 'key_len' => '130', 'ref' => 'const', 'rows' => 1, 'filtered' => 100.0, 'extra' => 'Using where', ) ]
[ SQL ] SELECT `value` FROM `shd_configuration` WHERE ( setting = 'allow_login_email_captcha' ) LIMIT 1 [ RunTime:0.000129s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'shd_configuration', 'partitions' => NULL, 'type' => 'ref', 'possible_keys' => 'setting', 'key' => 'setting', 'key_len' => '130', 'ref' => 'const', 'rows' => 1, 'filtered' => 100.0, 'extra' => 'Using where', ) ]
[ SQL ] SELECT `value` FROM `shd_configuration` WHERE ( setting = 'allow_login_code_captcha' ) LIMIT 1 [ RunTime:0.000129s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'shd_configuration', 'partitions' => NULL, 'type' => 'ref', 'possible_keys' => 'setting', 'key' => 'setting', 'key_len' => '130', 'ref' => 'const', 'rows' => 1, 'filtered' => 100.0, 'extra' => 'Using where', ) ]
[ SQL ] SELECT `value` FROM `shd_configuration` WHERE ( setting = 'allow_login_id_captcha' ) LIMIT 1 [ RunTime:0.000152s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'shd_configuration', 'partitions' => NULL, 'type' => 'ref', 'possible_keys' => 'setting', 'key' => 'setting', 'key_len' => '130', 'ref' => 'const', 'rows' => 1, 'filtered' => 100.0, 'extra' => 'Using where', ) ]
[ SQL ] SELECT `value` FROM `shd_configuration` WHERE ( setting = 'allow_phone_forgetpwd_captcha' ) LIMIT 1 [ RunTime:0.000157s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'shd_configuration', 'partitions' => NULL, 'type' => 'ref', 'possible_keys' => 'setting', 'key' => 'setting', 'key_len' => '130', 'ref' => 'const', 'rows' => 1, 'filtered' => 100.0, 'extra' => 'Using where', ) ]
[ SQL ] SELECT `value` FROM `shd_configuration` WHERE ( setting = 'allow_email_forgetpwd_captcha' ) LIMIT 1 [ RunTime:0.000159s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'shd_configuration', 'partitions' => NULL, 'type' => 'ref', 'possible_keys' => 'setting', 'key' => 'setting', 'key_len' => '130', 'ref' => 'const', 'rows' => 1, 'filtered' => 100.0, 'extra' => 'Using where', ) ]
[ SQL ] SELECT `value` FROM `shd_configuration` WHERE ( setting = 'allow_resetpwd_captcha' ) LIMIT 1 [ RunTime:0.000154s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'shd_configuration', 'partitions' => NULL, 'type' => 'ref', 'possible_keys' => 'setting', 'key' => 'setting', 'key_len' => '130', 'ref' => 'const', 'rows' => 1, 'filtered' => 100.0, 'extra' => 'Using where', ) ]
[ SQL ] SELECT `value` FROM `shd_configuration` WHERE ( setting = 'allow_phone_bind_captcha' ) LIMIT 1 [ RunTime:0.000148s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'shd_configuration', 'partitions' => NULL, 'type' => 'ref', 'possible_keys' => 'setting', 'key' => 'setting', 'key_len' => '130', 'ref' => 'const', 'rows' => 1, 'filtered' => 100.0, 'extra' => 'Using where', ) ]
[ SQL ] SELECT `value` FROM `shd_configuration` WHERE ( setting = 'allow_email_bind_captcha' ) LIMIT 1 [ RunTime:0.000155s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'shd_configuration', 'partitions' => NULL, 'type' => 'ref', 'possible_keys' => 'setting', 'key' => 'setting', 'key_len' => '130', 'ref' => 'const', 'rows' => 1, 'filtered' => 100.0, 'extra' => 'Using where', ) ]
[ SQL ] SELECT `value` FROM `shd_configuration` WHERE ( setting = 'allow_cancel_captcha' ) LIMIT 1 [ RunTime:0.000142s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'shd_configuration', 'partitions' => NULL, 'type' => 'ref', 'possible_keys' => 'setting', 'key' => 'setting', 'key_len' => '130', 'ref' => 'const', 'rows' => 1, 'filtered' => 100.0, 'extra' => 'Using where', ) ]
[ SQL ] SELECT `value` FROM `shd_configuration` WHERE ( setting = 'allow_login_admin_captcha' ) LIMIT 1 [ RunTime:0.000142s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'shd_configuration', 'partitions' => NULL, 'type' => 'ref', 'possible_keys' => 'setting', 'key' => 'setting', 'key_len' => '130', 'ref' => 'const', 'rows' => 1, 'filtered' => 100.0, 'extra' => 'Using where', ) ]
[ SQL ] SELECT `value` FROM `shd_configuration` WHERE ( setting = 'allow_cancel_sms_captcha' ) LIMIT 1 [ RunTime:0.000164s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'shd_configuration', 'partitions' => NULL, 'type' => 'ref', 'possible_keys' => 'setting', 'key' => 'setting', 'key_len' => '130', 'ref' => 'const', 'rows' => 1, 'filtered' => 100.0, 'extra' => 'Using where', ) ]
[ SQL ] SELECT `value` FROM `shd_configuration` WHERE ( setting = 'allow_cancel_email_captcha' ) LIMIT 1 [ RunTime:0.000146s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'shd_configuration', 'partitions' => NULL, 'type' => 'ref', 'possible_keys' => 'setting', 'key' => 'setting', 'key_len' => '130', 'ref' => 'const', 'rows' => 1, 'filtered' => 100.0, 'extra' => 'Using where', ) ]
[ SQL ] SELECT `value` FROM `shd_configuration` WHERE ( setting = 'allow_setpwd_captcha' ) LIMIT 1 [ RunTime:0.000164s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'shd_configuration', 'partitions' => NULL, 'type' => 'ref', 'possible_keys' => 'setting', 'key' => 'setting', 'key_len' => '130', 'ref' => 'const', 'rows' => 1, 'filtered' => 100.0, 'extra' => 'Using where', ) ]
[ SQL ] SELECT `value` FROM `shd_configuration` WHERE ( setting = 'login_error_switch' ) LIMIT 1 [ RunTime:0.000155s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'shd_configuration', 'partitions' => NULL, 'type' => 'ref', 'possible_keys' => 'setting', 'key' => 'setting', 'key_len' => '130', 'ref' => 'const', 'rows' => 1, 'filtered' => 100.0, 'extra' => 'Using where', ) ]
[ SQL ] SELECT `fieldname`,`id` FROM `shd_customfields` WHERE `type` = 'depot' ORDER BY `id` DESC [ RunTime:0.000209s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'shd_customfields', 'partitions' => NULL, 'type' => 'ref', 'possible_keys' => 'type', 'key' => 'type', 'key_len' => '131', 'ref' => 'const', 'rows' => 1, 'filtered' => 100.0, 'extra' => 'Using where', ) ]
[ SQL ] SELECT `value` FROM `shd_configuration` WHERE ( setting = 'language' ) LIMIT 1 [ RunTime:0.000179s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'shd_configuration', 'partitions' => NULL, 'type' => 'ref', 'possible_keys' => 'setting', 'key' => 'setting', 'key_len' => '130', 'ref' => 'const', 'rows' => 1, 'filtered' => 100.0, 'extra' => 'Using where', ) ]
[ SQL ] SELECT `value` FROM `shd_configuration` WHERE ( setting = 'VIEW_TEMPLATE_SETTING_NAME' ) LIMIT 1 [ RunTime:0.000165s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'shd_configuration', 'partitions' => NULL, 'type' => 'ref', 'possible_keys' => 'setting', 'key' => 'setting', 'key_len' => '130', 'ref' => 'const', 'rows' => 1, 'filtered' => 100.0, 'extra' => 'Using where', ) ]
[ SQL ] SELECT `value` FROM `shd_configuration` WHERE ( setting = 'language' ) LIMIT 1 [ RunTime:0.000188s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'shd_configuration', 'partitions' => NULL, 'type' => 'ref', 'possible_keys' => 'setting', 'key' => 'setting', 'key_len' => '130', 'ref' => 'const', 'rows' => 1, 'filtered' => 100.0, 'extra' => 'Using where', ) ]
[ SQL ] SELECT `value` FROM `shd_configuration` WHERE ( setting = 'beta_version' ) LIMIT 1 [ RunTime:0.000147s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'shd_configuration', 'partitions' => NULL, 'type' => 'ref', 'possible_keys' => 'setting', 'key' => 'setting', 'key_len' => '130', 'ref' => 'const', 'rows' => 1, 'filtered' => 100.0, 'extra' => 'Using where', ) ]
[ SQL ] SHOW COLUMNS FROM `shd_menu_active` [ RunTime:0.000472s ]
[ SQL ] SELECT `menuid` FROM `shd_menu_active` WHERE `type` = 'client' LIMIT 1 [ RunTime:0.000163s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'shd_menu_active', 'partitions' => NULL, 'type' => 'ALL', 'possible_keys' => NULL, 'key' => NULL, 'key_len' => NULL, 'ref' => NULL, 'rows' => 3, 'filtered' => 33.333335876464844, 'extra' => 'Using where', ) ]
[ SQL ] SHOW COLUMNS FROM `shd_menus` [ RunTime:0.000363s ]
[ SQL ] SELECT * FROM `shd_menus` WHERE `id` = 55 LIMIT 1 [ RunTime:0.000179s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'shd_menus', 'partitions' => NULL, 'type' => 'const', 'possible_keys' => 'PRIMARY', 'key' => 'PRIMARY', 'key_len' => '4', 'ref' => 'const', 'rows' => 1, 'filtered' => 100.0, 'extra' => NULL, ) ]
[ SQL ] SELECT `is_open_credit_limit` FROM `shd_clients` WHERE `id` IS NULL AND `status` = 1 LIMIT 1 [ RunTime:0.000136s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => NULL, 'partitions' => NULL, 'type' => NULL, 'possible_keys' => NULL, 'key' => NULL, 'key_len' => NULL, 'ref' => NULL, 'rows' => NULL, 'filtered' => NULL, 'extra' => 'Impossible WHERE', ) ]
[ SQL ] SELECT `setting`,`value` FROM `shd_configuration` WHERE `setting` IN ('allow_resource_api','affiliate_enabled','voucher_manager','credit_limit','addfunds_enabled','certifi_open','contract_open') [ RunTime:0.000224s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'shd_configuration', 'partitions' => NULL, 'type' => 'range', 'possible_keys' => 'setting', 'key' => 'setting', 'key_len' => '130', 'ref' => NULL, 'rows' => 7, 'filtered' => 100.0, 'extra' => 'Using where', ) ]
[ SQL ] SHOW COLUMNS FROM `shd_nav` [ RunTime:0.000351s ]
[ SQL ] SELECT `id` FROM `shd_nav` WHERE `url` = 'affiliates' [ RunTime:0.000179s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'shd_nav', 'partitions' => NULL, 'type' => 'ALL', 'possible_keys' => NULL, 'key' => NULL, 'key_len' => NULL, 'ref' => NULL, 'rows' => 50, 'filtered' => 10.0, 'extra' => 'Using where', ) ]
[ SQL ] SELECT `id` FROM `shd_nav` WHERE `url` = 'verified' [ RunTime:0.000145s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'shd_nav', 'partitions' => NULL, 'type' => 'ALL', 'possible_keys' => NULL, 'key' => NULL, 'key_len' => NULL, 'ref' => NULL, 'rows' => 50, 'filtered' => 10.0, 'extra' => 'Using where', ) ]
[ SQL ] SELECT `id` FROM `shd_nav` WHERE `url` = 'contract' [ RunTime:0.000134s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'shd_nav', 'partitions' => NULL, 'type' => 'ALL', 'possible_keys' => NULL, 'key' => NULL, 'key_len' => NULL, 'ref' => NULL, 'rows' => 50, 'filtered' => 10.0, 'extra' => 'Using where', ) ]
[ SQL ] SELECT `name` FROM `shd_plugin` WHERE `module` = 'addons' AND `status` = 0 [ RunTime:0.000314s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'shd_plugin', 'partitions' => NULL, 'type' => 'ALL', 'possible_keys' => NULL, 'key' => NULL, 'key_len' => NULL, 'ref' => NULL, 'rows' => 5, 'filtered' => 20.0, 'extra' => 'Using where', ) ]
[ SQL ] SELECT `id`,`url`,`lang` FROM `shd_nav` WHERE `id` IN (1,2,8,305,306,307,3,12,13,14,15,17,303,4,19,24,37,304,35,20,21,22,23,5,25,26,27,28,29,7,331) AND `url` <> 'credit' AND `id` NOT IN (7,20,21,22,23,14,304) [ RunTime:0.000305s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'shd_nav', 'partitions' => NULL, 'type' => 'ALL', 'possible_keys' => 'PRIMARY', 'key' => NULL, 'key_len' => NULL, 'ref' => NULL, 'rows' => 50, 'filtered' => 43.19999694824219, 'extra' => 'Using where', ) ]
[ SQL ] SELECT `value` FROM `shd_configuration` WHERE ( setting = 'VIEW_TEMPLATE_SETTING_NAME' ) LIMIT 1 [ RunTime:0.000157s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'shd_configuration', 'partitions' => NULL, 'type' => 'ref', 'possible_keys' => 'setting', 'key' => 'setting', 'key_len' => '130', 'ref' => 'const', 'rows' => 1, 'filtered' => 100.0, 'extra' => 'Using where', ) ]
[ SQL ] SELECT `value` FROM `shd_configuration` WHERE ( setting = 'themes_templates' ) LIMIT 1 [ RunTime:0.000168s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'shd_configuration', 'partitions' => NULL, 'type' => 'ref', 'possible_keys' => 'setting', 'key' => 'setting', 'key_len' => '130', 'ref' => 'const', 'rows' => 1, 'filtered' => 100.0, 'extra' => 'Using where', ) ]
[ SQL ] SELECT `menuid` FROM `shd_menu_active` WHERE `type` = 'www_top' LIMIT 1 [ RunTime:0.000124s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'shd_menu_active', 'partitions' => NULL, 'type' => 'ALL', 'possible_keys' => NULL, 'key' => NULL, 'key_len' => NULL, 'ref' => NULL, 'rows' => 3, 'filtered' => 33.333335876464844, 'extra' => 'Using where', ) ]
[ SQL ] SELECT `menuid` FROM `shd_menu_active` WHERE `type` = 'www_bottom' LIMIT 1 [ RunTime:0.000120s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'shd_menu_active', 'partitions' => NULL, 'type' => 'ALL', 'possible_keys' => NULL, 'key' => NULL, 'key_len' => NULL, 'ref' => NULL, 'rows' => 3, 'filtered' => 33.333335876464844, 'extra' => 'Using where', ) ]
[ SQL ] SHOW COLUMNS FROM `shd_friendly_links` [ RunTime:0.000734s ]
[ SQL ] SELECT * FROM `shd_friendly_links` WHERE `is_open` = 1 [ RunTime:0.000162s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'shd_friendly_links', 'partitions' => NULL, 'type' => 'ALL', 'possible_keys' => NULL, 'key' => NULL, 'key_len' => NULL, 'ref' => NULL, 'rows' => 1, 'filtered' => 100.0, 'extra' => 'Using where', ) ]
[ SQL ] SELECT `value` FROM `shd_configuration` WHERE ( setting = 'VIEW_TEMPLATE_SETTING_NAME' ) LIMIT 1 [ RunTime:0.000148s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'shd_configuration', 'partitions' => NULL, 'type' => 'ref', 'possible_keys' => 'setting', 'key' => 'setting', 'key_len' => '130', 'ref' => 'const', 'rows' => 1, 'filtered' => 100.0, 'extra' => 'Using where', ) ]
[ SQL ] SELECT `value` FROM `shd_configuration` WHERE ( setting = 'themes_templates' ) LIMIT 1 [ RunTime:0.000149s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'shd_configuration', 'partitions' => NULL, 'type' => 'ref', 'possible_keys' => 'setting', 'key' => 'setting', 'key_len' => '130', 'ref' => 'const', 'rows' => 1, 'filtered' => 100.0, 'extra' => 'Using where', ) ]
[ SQL ] SELECT `value` FROM `shd_configuration` WHERE ( setting = 'clientarea_default_themes' ) LIMIT 1 [ RunTime:0.000167s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'shd_configuration', 'partitions' => NULL, 'type' => 'ref', 'possible_keys' => 'setting', 'key' => 'setting', 'key_len' => '130', 'ref' => 'const', 'rows' => 1, 'filtered' => 100.0, 'extra' => 'Using where', ) ]
[ SQL ] SELECT `value` FROM `shd_configuration` WHERE ( setting = 'clientarea_default_themes' ) LIMIT 1 [ RunTime:0.000151s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'shd_configuration', 'partitions' => NULL, 'type' => 'ref', 'possible_keys' => 'setting', 'key' => 'setting', 'key_len' => '130', 'ref' => 'const', 'rows' => 1, 'filtered' => 100.0, 'extra' => 'Using where', ) ]
[ SQL ] SELECT `value` FROM `shd_configuration` WHERE ( setting = 'clientarea_default_themes' ) LIMIT 1 [ RunTime:0.000147s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'shd_configuration', 'partitions' => NULL, 'type' => 'ref', 'possible_keys' => 'setting', 'key' => 'setting', 'key_len' => '130', 'ref' => 'const', 'rows' => 1, 'filtered' => 100.0, 'extra' => 'Using where', ) ]
[ SQL ] SELECT `value` FROM `shd_configuration` WHERE ( setting = 'themes_templates' ) LIMIT 1 [ RunTime:0.000176s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'shd_configuration', 'partitions' => NULL, 'type' => 'ref', 'possible_keys' => 'setting', 'key' => 'setting', 'key_len' => '130', 'ref' => 'const', 'rows' => 1, 'filtered' => 100.0, 'extra' => 'Using where', ) ]
[ SQL ] SHOW COLUMNS FROM `shd_product_first_groups` [ RunTime:0.000670s ]
[ SQL ] SELECT `id` FROM `shd_product_first_groups` WHERE `hidden` = 0 ORDER BY `order` ASC LIMIT 1 [ RunTime:0.000201s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'shd_product_first_groups', 'partitions' => NULL, 'type' => 'ALL', 'possible_keys' => NULL, 'key' => NULL, 'key_len' => NULL, 'ref' => NULL, 'rows' => 1, 'filtered' => 100.0, 'extra' => 'Using where; Using filesort', ) ]
[ SQL ] SELECT * FROM `shd_product_first_groups` WHERE `hidden` = 0 AND `id` = 1 LIMIT 1 [ RunTime:0.000164s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'shd_product_first_groups', 'partitions' => NULL, 'type' => 'const', 'possible_keys' => 'PRIMARY', 'key' => 'PRIMARY', 'key_len' => '4', 'ref' => 'const', 'rows' => 1, 'filtered' => 100.0, 'extra' => NULL, ) ]
[ SQL ] SHOW COLUMNS FROM `shd_product_groups` [ RunTime:0.000340s ]
[ SQL ] SELECT `id` FROM `shd_product_groups` WHERE `hidden` = 0 AND `gid` = 1 ORDER BY `order` ASC LIMIT 1 [ RunTime:0.000162s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'shd_product_groups', 'partitions' => NULL, 'type' => 'index', 'possible_keys' => NULL, 'key' => 'order', 'key_len' => '4', 'ref' => NULL, 'rows' => 1, 'filtered' => 33.333335876464844, 'extra' => 'Using where', ) ]
[ SQL ] SELECT * FROM `shd_product_groups` WHERE `hidden` = 0 AND `id` = 1 AND `gid` = 1 LIMIT 1 [ RunTime:0.000166s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'shd_product_groups', 'partitions' => NULL, 'type' => 'const', 'possible_keys' => 'PRIMARY', 'key' => 'PRIMARY', 'key_len' => '4', 'ref' => 'const', 'rows' => 1, 'filtered' => 100.0, 'extra' => NULL, ) ]
[ SQL ] SELECT `gid` FROM `shd_products` WHERE `id` = 37 LIMIT 1 [ RunTime:0.000613s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'shd_products', 'partitions' => NULL, 'type' => 'const', 'possible_keys' => 'PRIMARY', 'key' => 'PRIMARY', 'key_len' => '4', 'ref' => 'const', 'rows' => 1, 'filtered' => 100.0, 'extra' => NULL, ) ]
[ SQL ] SELECT `gid` FROM `shd_product_groups` WHERE `id` = 3 LIMIT 1 [ RunTime:0.000115s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'shd_product_groups', 'partitions' => NULL, 'type' => 'const', 'possible_keys' => 'PRIMARY', 'key' => 'PRIMARY', 'key_len' => '4', 'ref' => 'const', 'rows' => 1, 'filtered' => 100.0, 'extra' => NULL, ) ]
[ SQL ] SELECT `gid` FROM `shd_products` WHERE `id` = 37 LIMIT 1 [ RunTime:0.000157s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'shd_products', 'partitions' => NULL, 'type' => 'const', 'possible_keys' => 'PRIMARY', 'key' => 'PRIMARY', 'key_len' => '4', 'ref' => 'const', 'rows' => 1, 'filtered' => 100.0, 'extra' => NULL, ) ]
[ SQL ] SELECT * FROM `shd_products` WHERE `hidden` = 0 AND `gid` = 3 ORDER BY `order` ASC [ RunTime:0.011574s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'shd_products', 'partitions' => NULL, 'type' => 'ref', 'possible_keys' => 'gid', 'key' => 'gid', 'key_len' => '4', 'ref' => 'const', 'rows' => 14, 'filtered' => 10.0, 'extra' => 'Using index condition; Using where; Using filesort', ) ]

0.915939s

新闻中心

帮助中心

了解我们

更多

产品列表

网站资讯

关于我们

宁波电信云主机 16核 16GB 99元 季度活动

宁波电信云主机 16核 16GB 99元季度活动