河南安之跃电子科技有限公司政采电商系统-一站式政府采购平台

基本文件流程错误 SQL 调试

/www/wwwroot/ytdnc.com/public/index.php ( 0.44 KB )
/www/wwwroot/ytdnc.com/vendor/thinkphp/base.php ( 1.71 KB )
/www/wwwroot/ytdnc.com/vendor/thinkphp/library/think/Loader.php ( 12.70 KB )
/www/wwwroot/ytdnc.com/vendor/composer/autoload_static.php ( 6.58 KB )
/www/wwwroot/ytdnc.com/vendor/thinkphp/library/think/Error.php ( 4.00 KB )
/www/wwwroot/ytdnc.com/vendor/thinkphp/library/think/Container.php ( 15.53 KB )
/www/wwwroot/ytdnc.com/vendor/thinkcmf/cmf/src/App.php ( 28.97 KB )
/www/wwwroot/ytdnc.com/vendor/thinkphp/library/think/Env.php ( 2.85 KB )
/www/wwwroot/ytdnc.com/vendor/thinkphp/library/think/Config.php ( 9.71 KB )
/www/wwwroot/ytdnc.com/vendor/thinkphp/convention.php ( 11.74 KB )
/www/wwwroot/ytdnc.com/vendor/thinkphp/helper.php ( 20.29 KB )
/www/wwwroot/ytdnc.com/vendor/thinkcmf/cmf-app/src/app.php ( 5.31 KB )
/www/wwwroot/ytdnc.com/vendor/thinkcmf/cmf-app/src/database.php ( 0.90 KB )
/www/wwwroot/ytdnc.com/vendor/thinkcmf/cmf-app/src/template.php ( 2.32 KB )
/www/wwwroot/ytdnc.com/vendor/thinkcmf/cmf-app/src/paginate.php ( 0.17 KB )
/www/wwwroot/ytdnc.com/vendor/thinkcmf/cmf-app/src/tags.php ( 1.35 KB )
/www/wwwroot/ytdnc.com/vendor/thinkphp/library/think/Hook.php ( 5.58 KB )
/www/wwwroot/ytdnc.com/data/config/database.php ( 0.52 KB )
/www/wwwroot/ytdnc.com/data/config/template.php ( 0.23 KB )
/www/wwwroot/ytdnc.com/vendor/ezyang/htmlpurifier/library/HTMLPurifier.composer.php ( 0.10 KB )
/www/wwwroot/ytdnc.com/vendor/topthink/think-captcha/src/helper.php ( 1.54 KB )
/www/wwwroot/ytdnc.com/vendor/thinkphp/library/think/facade/Route.php ( 3.83 KB )
/www/wwwroot/ytdnc.com/vendor/thinkphp/library/think/Facade.php ( 3.44 KB )
/www/wwwroot/ytdnc.com/vendor/thinkphp/library/think/Route.php ( 25.79 KB )
/www/wwwroot/ytdnc.com/vendor/thinkphp/library/think/Request.php ( 57.17 KB )
/www/wwwroot/ytdnc.com/vendor/thinkphp/library/think/route/Domain.php ( 7.07 KB )
/www/wwwroot/ytdnc.com/vendor/thinkphp/library/think/route/RuleGroup.php ( 16.45 KB )
/www/wwwroot/ytdnc.com/vendor/thinkphp/library/think/route/Rule.php ( 28.92 KB )
/www/wwwroot/ytdnc.com/vendor/thinkphp/library/think/route/RuleItem.php ( 8.84 KB )
/www/wwwroot/ytdnc.com/vendor/thinkphp/library/think/route/RuleName.php ( 3.92 KB )
/www/wwwroot/ytdnc.com/vendor/thinkphp/library/think/facade/Validate.php ( 4.83 KB )
/www/wwwroot/ytdnc.com/vendor/thinkphp/library/think/Validate.php ( 43.85 KB )
/www/wwwroot/ytdnc.com/vendor/thinkcmf/cmf/src/common.php ( 78.82 KB )
/www/wwwroot/ytdnc.com/vendor/topthink/think-helper/src/helper.php ( 2.88 KB )
/www/wwwroot/ytdnc.com/vendor/thinkphp/library/think/Db.php ( 7.67 KB )
/www/wwwroot/ytdnc.com/vendor/thinkphp/library/think/Lang.php ( 7.38 KB )
/www/wwwroot/ytdnc.com/vendor/thinkcmf/cmf/src/Log.php ( 8.85 KB )
/www/wwwroot/ytdnc.com/vendor/thinkphp/library/think/log/driver/File.php ( 8.95 KB )
/www/wwwroot/ytdnc.com/vendor/thinkphp/lang/zh-cn.php ( 12.58 KB )
/www/wwwroot/ytdnc.com/data/route/route.php ( 0.02 KB )
/www/wwwroot/ytdnc.com/vendor/thinkcmf/cmf/src/behavior/InitHookBehavior.php ( 2.00 KB )
/www/wwwroot/ytdnc.com/vendor/thinkphp/library/think/facade/Cache.php ( 2.06 KB )
/www/wwwroot/ytdnc.com/vendor/thinkphp/library/think/Cache.php ( 3.27 KB )
/www/wwwroot/ytdnc.com/vendor/thinkphp/library/think/cache/driver/File.php ( 7.91 KB )
/www/wwwroot/ytdnc.com/vendor/thinkphp/library/think/cache/Driver.php ( 8.64 KB )
/www/wwwroot/ytdnc.com/vendor/thinkphp/library/think/Collection.php ( 13.58 KB )
/www/wwwroot/ytdnc.com/vendor/thinkphp/library/think/facade/Hook.php ( 1.46 KB )
/www/wwwroot/ytdnc.com/vendor/thinkphp/library/think/route/dispatch/Url.php ( 5.23 KB )
/www/wwwroot/ytdnc.com/vendor/thinkphp/library/think/route/Dispatch.php ( 9.27 KB )
/www/wwwroot/ytdnc.com/vendor/thinkcmf/cmf/src/route/dispatch/Module.php ( 5.17 KB )
/www/wwwroot/ytdnc.com/vendor/thinkphp/library/think/Middleware.php ( 5.34 KB )
/www/wwwroot/ytdnc.com/vendor/thinkphp/library/think/Cookie.php ( 7.35 KB )
/www/wwwroot/ytdnc.com/vendor/thinkphp/library/think/View.php ( 5.71 KB )
/www/wwwroot/ytdnc.com/vendor/thinkphp/library/think/view/driver/Think.php ( 6.12 KB )
/www/wwwroot/ytdnc.com/vendor/thinkphp/library/think/Template.php ( 47.31 KB )
/www/wwwroot/ytdnc.com/vendor/thinkphp/library/think/template/driver/File.php ( 2.29 KB )
/www/wwwroot/ytdnc.com/vendor/thinkphp/library/think/Session.php ( 14.13 KB )
/www/wwwroot/ytdnc.com/vendor/thinkphp/library/think/Debug.php ( 7.57 KB )
/www/wwwroot/ytdnc.com/vendor/thinkcmf/cmf/src/behavior/LangBehavior.php ( 2.46 KB )
/www/wwwroot/ytdnc.com/vendor/thinkphp/library/think/facade/Lang.php ( 1.75 KB )
/www/wwwroot/ytdnc.com/vendor/thinkcmf/cmf/src/lang/zh-cn.php ( 3.08 KB )
/www/wwwroot/ytdnc.com/vendor/thinkphp/library/think/facade/Env.php ( 1.17 KB )
/www/wwwroot/ytdnc.com/vendor/thinkcmf/cmf-app/src/mjyx/lang/zh-cn.php ( 9.31 KB )
/www/wwwroot/ytdnc.com/vendor/thinkcmf/cmf-app/src/mjyx/lang/zh-cn/common.php ( 0.60 KB )
/www/wwwroot/ytdnc.com/vendor/thinkcmf/cmf-app/src/user/lang/zh-cn.php ( 4.13 KB )
/www/wwwroot/ytdnc.com/vendor/thinkcmf/cmf/src/behavior/InitAppHookBehavior.php ( 2.01 KB )
/www/wwwroot/ytdnc.com/vendor/thinkcmf/cmf-app/src/portal/controller/IndexController.php ( 8.57 KB )
/www/wwwroot/ytdnc.com/vendor/thinkcmf/cmf/src/controller/HomeBaseController.php ( 8.81 KB )
/www/wwwroot/ytdnc.com/vendor/thinkcmf/cmf/src/controller/BaseController.php ( 2.24 KB )
/www/wwwroot/ytdnc.com/vendor/thinkphp/library/think/Controller.php ( 7.47 KB )
/www/wwwroot/ytdnc.com/vendor/thinkphp/library/traits/controller/Jump.php ( 4.76 KB )
/www/wwwroot/ytdnc.com/vendor/thinkphp/library/think/facade/Config.php ( 1.52 KB )
/www/wwwroot/ytdnc.com/vendor/thinkphp/library/think/facade/Cookie.php ( 1.58 KB )
/www/wwwroot/ytdnc.com/vendor/thinkphp/library/think/facade/View.php ( 1.76 KB )
/www/wwwroot/ytdnc.com/vendor/thinkcmf/cmf/src/behavior/HomeLangBehavior.php ( 1.51 KB )
/www/wwwroot/ytdnc.com/vendor/thinkcmf/cmf-app/src/portal/model/GoodsCategoryModel.php ( 0.38 KB )
/www/wwwroot/ytdnc.com/vendor/thinkphp/library/think/Model.php ( 27.26 KB )
/www/wwwroot/ytdnc.com/vendor/thinkphp/library/think/model/concern/Attribute.php ( 17.64 KB )
/www/wwwroot/ytdnc.com/vendor/thinkphp/library/think/model/concern/RelationShip.php ( 19.85 KB )
/www/wwwroot/ytdnc.com/vendor/thinkphp/library/think/model/concern/ModelEvent.php ( 6.04 KB )
/www/wwwroot/ytdnc.com/vendor/thinkphp/library/think/model/concern/TimeStamp.php ( 2.58 KB )
/www/wwwroot/ytdnc.com/vendor/thinkphp/library/think/model/concern/Conversion.php ( 7.66 KB )
/www/wwwroot/ytdnc.com/vendor/thinkphp/library/think/model/concern/SoftDelete.php ( 5.54 KB )
/www/wwwroot/ytdnc.com/vendor/thinkphp/library/think/db/Connection.php ( 58.94 KB )
/www/wwwroot/ytdnc.com/vendor/thinkphp/library/think/db/connector/Mysql.php ( 5.58 KB )
/www/wwwroot/ytdnc.com/vendor/thinkphp/library/think/db/builder/Mysql.php ( 5.51 KB )
/www/wwwroot/ytdnc.com/vendor/thinkphp/library/think/db/Builder.php ( 36.45 KB )
/www/wwwroot/ytdnc.com/vendor/thinkphp/library/think/db/Query.php ( 104.50 KB )
/www/wwwroot/ytdnc.com/vendor/thinkphp/library/think/model/Collection.php ( 2.80 KB )
/www/wwwroot/ytdnc.com/vendor/thinkphp/library/think/facade/Session.php ( 2.05 KB )
/www/wwwroot/ytdnc.com/vendor/thinkcmf/cmf-app/src/portal/model/SlideModel.php ( 0.23 KB )
/www/wwwroot/ytdnc.com/vendor/thinkcmf/cmf-app/src/mjyx/model/ThemeModel.php ( 8.12 KB )
/www/wwwroot/ytdnc.com/data/runtime/temp/1540adf70333a0eb3c5c48ee34475464.php ( 17.72 KB )
/www/wwwroot/ytdnc.com/vendor/thinkphp/library/think/facade/Url.php ( 1.13 KB )
/www/wwwroot/ytdnc.com/vendor/thinkphp/library/think/Url.php ( 13.01 KB )
/www/wwwroot/ytdnc.com/vendor/thinkcmf/cmf-app/src/mjyx/model/RouteModel.php ( 6.50 KB )
/www/wwwroot/ytdnc.com/vendor/thinkcmf/cmf-app/src/user/url.php ( 0.98 KB )
/www/wwwroot/ytdnc.com/vendor/thinkphp/library/think/Response.php ( 9.68 KB )
/www/wwwroot/ytdnc.com/vendor/thinkphp/library/think/debug/Html.php ( 4.02 KB )

[ DB ] CONNECT:[ UseTime:0.000545s ] mysql:host=127.0.0.1;port=3306;dbname=ytdnc;charset=utf8
[ SQL ] SHOW COLUMNS FROM `cmf_goods_category` [ RunTime:0.004622s ]
[ SQL ] SELECT `id`,`parent_id`,`name`,`thumb` FROM `cmf_goods_category` WHERE ( `parent_id` = 0 AND `status` = 1 ) AND `cmf_goods_category`.`delete_time` = '0' ORDER BY `list_order` LIMIT 9 [ RunTime:0.000804s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'cmf_goods_category', 'type' => 'ALL', 'possible_keys' => NULL, 'key' => NULL, 'key_len' => NULL, 'ref' => NULL, 'rows' => 184, 'extra' => 'Using where; Using filesort', ) ]
[ SQL ] SELECT `id`,`parent_id`,`name` FROM `cmf_goods_category` WHERE ( `parent_id` = 2 AND `status` = 1 ) AND `cmf_goods_category`.`delete_time` = '0' ORDER BY `list_order` [ RunTime:0.000600s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'cmf_goods_category', 'type' => 'ALL', 'possible_keys' => NULL, 'key' => NULL, 'key_len' => NULL, 'ref' => NULL, 'rows' => 184, 'extra' => 'Using where; Using filesort', ) ]
[ SQL ] SELECT `id`,`parent_id`,`name` FROM `cmf_goods_category` WHERE ( `parent_id` = 55 AND `status` = 1 ) AND `cmf_goods_category`.`delete_time` = '0' ORDER BY `list_order` [ RunTime:0.000459s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'cmf_goods_category', 'type' => 'ALL', 'possible_keys' => NULL, 'key' => NULL, 'key_len' => NULL, 'ref' => NULL, 'rows' => 184, 'extra' => 'Using where; Using filesort', ) ]
[ SQL ] SELECT `id`,`parent_id`,`name` FROM `cmf_goods_category` WHERE ( `parent_id` = 56 AND `status` = 1 ) AND `cmf_goods_category`.`delete_time` = '0' ORDER BY `list_order` [ RunTime:0.000409s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'cmf_goods_category', 'type' => 'ALL', 'possible_keys' => NULL, 'key' => NULL, 'key_len' => NULL, 'ref' => NULL, 'rows' => 184, 'extra' => 'Using where; Using filesort', ) ]
[ SQL ] SELECT `id`,`parent_id`,`name` FROM `cmf_goods_category` WHERE ( `parent_id` = 57 AND `status` = 1 ) AND `cmf_goods_category`.`delete_time` = '0' ORDER BY `list_order` [ RunTime:0.000388s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'cmf_goods_category', 'type' => 'ALL', 'possible_keys' => NULL, 'key' => NULL, 'key_len' => NULL, 'ref' => NULL, 'rows' => 184, 'extra' => 'Using where; Using filesort', ) ]
[ SQL ] SELECT `id`,`parent_id`,`name` FROM `cmf_goods_category` WHERE ( `parent_id` = 58 AND `status` = 1 ) AND `cmf_goods_category`.`delete_time` = '0' ORDER BY `list_order` [ RunTime:0.000380s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'cmf_goods_category', 'type' => 'ALL', 'possible_keys' => NULL, 'key' => NULL, 'key_len' => NULL, 'ref' => NULL, 'rows' => 184, 'extra' => 'Using where; Using filesort', ) ]
[ SQL ] SELECT `id`,`parent_id`,`name` FROM `cmf_goods_category` WHERE ( `parent_id` = 59 AND `status` = 1 ) AND `cmf_goods_category`.`delete_time` = '0' ORDER BY `list_order` [ RunTime:0.000798s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'cmf_goods_category', 'type' => 'ALL', 'possible_keys' => NULL, 'key' => NULL, 'key_len' => NULL, 'ref' => NULL, 'rows' => 184, 'extra' => 'Using where; Using filesort', ) ]
[ SQL ] SELECT `id`,`parent_id`,`name` FROM `cmf_goods_category` WHERE ( `parent_id` = 60 AND `status` = 1 ) AND `cmf_goods_category`.`delete_time` = '0' ORDER BY `list_order` [ RunTime:0.000422s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'cmf_goods_category', 'type' => 'ALL', 'possible_keys' => NULL, 'key' => NULL, 'key_len' => NULL, 'ref' => NULL, 'rows' => 184, 'extra' => 'Using where; Using filesort', ) ]
[ SQL ] SELECT `id`,`parent_id`,`name` FROM `cmf_goods_category` WHERE ( `parent_id` = 61 AND `status` = 1 ) AND `cmf_goods_category`.`delete_time` = '0' ORDER BY `list_order` [ RunTime:0.000378s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'cmf_goods_category', 'type' => 'ALL', 'possible_keys' => NULL, 'key' => NULL, 'key_len' => NULL, 'ref' => NULL, 'rows' => 184, 'extra' => 'Using where; Using filesort', ) ]
[ SQL ] SELECT `id`,`parent_id`,`name` FROM `cmf_goods_category` WHERE ( `parent_id` = 62 AND `status` = 1 ) AND `cmf_goods_category`.`delete_time` = '0' ORDER BY `list_order` [ RunTime:0.000371s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'cmf_goods_category', 'type' => 'ALL', 'possible_keys' => NULL, 'key' => NULL, 'key_len' => NULL, 'ref' => NULL, 'rows' => 184, 'extra' => 'Using where; Using filesort', ) ]
[ SQL ] SELECT `id`,`parent_id`,`name` FROM `cmf_goods_category` WHERE ( `parent_id` = 63 AND `status` = 1 ) AND `cmf_goods_category`.`delete_time` = '0' ORDER BY `list_order` [ RunTime:0.000377s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'cmf_goods_category', 'type' => 'ALL', 'possible_keys' => NULL, 'key' => NULL, 'key_len' => NULL, 'ref' => NULL, 'rows' => 184, 'extra' => 'Using where; Using filesort', ) ]
[ SQL ] SELECT `id`,`parent_id`,`name` FROM `cmf_goods_category` WHERE ( `parent_id` = 3 AND `status` = 1 ) AND `cmf_goods_category`.`delete_time` = '0' ORDER BY `list_order` [ RunTime:0.000376s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'cmf_goods_category', 'type' => 'ALL', 'possible_keys' => NULL, 'key' => NULL, 'key_len' => NULL, 'ref' => NULL, 'rows' => 184, 'extra' => 'Using where; Using filesort', ) ]
[ SQL ] SELECT `id`,`parent_id`,`name` FROM `cmf_goods_category` WHERE ( `parent_id` = 87 AND `status` = 1 ) AND `cmf_goods_category`.`delete_time` = '0' ORDER BY `list_order` [ RunTime:0.000424s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'cmf_goods_category', 'type' => 'ALL', 'possible_keys' => NULL, 'key' => NULL, 'key_len' => NULL, 'ref' => NULL, 'rows' => 184, 'extra' => 'Using where; Using filesort', ) ]
[ SQL ] SELECT `id`,`parent_id`,`name` FROM `cmf_goods_category` WHERE ( `parent_id` = 88 AND `status` = 1 ) AND `cmf_goods_category`.`delete_time` = '0' ORDER BY `list_order` [ RunTime:0.000459s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'cmf_goods_category', 'type' => 'ALL', 'possible_keys' => NULL, 'key' => NULL, 'key_len' => NULL, 'ref' => NULL, 'rows' => 184, 'extra' => 'Using where; Using filesort', ) ]
[ SQL ] SELECT `id`,`parent_id`,`name` FROM `cmf_goods_category` WHERE ( `parent_id` = 89 AND `status` = 1 ) AND `cmf_goods_category`.`delete_time` = '0' ORDER BY `list_order` [ RunTime:0.000409s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'cmf_goods_category', 'type' => 'ALL', 'possible_keys' => NULL, 'key' => NULL, 'key_len' => NULL, 'ref' => NULL, 'rows' => 184, 'extra' => 'Using where; Using filesort', ) ]
[ SQL ] SELECT `id`,`parent_id`,`name` FROM `cmf_goods_category` WHERE ( `parent_id` = 4 AND `status` = 1 ) AND `cmf_goods_category`.`delete_time` = '0' ORDER BY `list_order` [ RunTime:0.000448s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'cmf_goods_category', 'type' => 'ALL', 'possible_keys' => NULL, 'key' => NULL, 'key_len' => NULL, 'ref' => NULL, 'rows' => 184, 'extra' => 'Using where; Using filesort', ) ]
[ SQL ] SELECT `id`,`parent_id`,`name` FROM `cmf_goods_category` WHERE ( `parent_id` = 105 AND `status` = 1 ) AND `cmf_goods_category`.`delete_time` = '0' ORDER BY `list_order` [ RunTime:0.000402s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'cmf_goods_category', 'type' => 'ALL', 'possible_keys' => NULL, 'key' => NULL, 'key_len' => NULL, 'ref' => NULL, 'rows' => 184, 'extra' => 'Using where; Using filesort', ) ]
[ SQL ] SELECT `id`,`parent_id`,`name` FROM `cmf_goods_category` WHERE ( `parent_id` = 5 AND `status` = 1 ) AND `cmf_goods_category`.`delete_time` = '0' ORDER BY `list_order` [ RunTime:0.000424s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'cmf_goods_category', 'type' => 'ALL', 'possible_keys' => NULL, 'key' => NULL, 'key_len' => NULL, 'ref' => NULL, 'rows' => 184, 'extra' => 'Using where; Using filesort', ) ]
[ SQL ] SELECT `id`,`parent_id`,`name` FROM `cmf_goods_category` WHERE ( `parent_id` = 114 AND `status` = 1 ) AND `cmf_goods_category`.`delete_time` = '0' ORDER BY `list_order` [ RunTime:0.000424s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'cmf_goods_category', 'type' => 'ALL', 'possible_keys' => NULL, 'key' => NULL, 'key_len' => NULL, 'ref' => NULL, 'rows' => 184, 'extra' => 'Using where; Using filesort', ) ]
[ SQL ] SELECT `id`,`parent_id`,`name` FROM `cmf_goods_category` WHERE ( `parent_id` = 115 AND `status` = 1 ) AND `cmf_goods_category`.`delete_time` = '0' ORDER BY `list_order` [ RunTime:0.000440s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'cmf_goods_category', 'type' => 'ALL', 'possible_keys' => NULL, 'key' => NULL, 'key_len' => NULL, 'ref' => NULL, 'rows' => 184, 'extra' => 'Using where; Using filesort', ) ]
[ SQL ] SELECT `id`,`parent_id`,`name` FROM `cmf_goods_category` WHERE ( `parent_id` = 116 AND `status` = 1 ) AND `cmf_goods_category`.`delete_time` = '0' ORDER BY `list_order` [ RunTime:0.000400s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'cmf_goods_category', 'type' => 'ALL', 'possible_keys' => NULL, 'key' => NULL, 'key_len' => NULL, 'ref' => NULL, 'rows' => 184, 'extra' => 'Using where; Using filesort', ) ]
[ SQL ] SELECT `id`,`parent_id`,`name` FROM `cmf_goods_category` WHERE ( `parent_id` = 117 AND `status` = 1 ) AND `cmf_goods_category`.`delete_time` = '0' ORDER BY `list_order` [ RunTime:0.000379s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'cmf_goods_category', 'type' => 'ALL', 'possible_keys' => NULL, 'key' => NULL, 'key_len' => NULL, 'ref' => NULL, 'rows' => 184, 'extra' => 'Using where; Using filesort', ) ]
[ SQL ] SELECT `id`,`parent_id`,`name` FROM `cmf_goods_category` WHERE ( `parent_id` = 118 AND `status` = 1 ) AND `cmf_goods_category`.`delete_time` = '0' ORDER BY `list_order` [ RunTime:0.000382s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'cmf_goods_category', 'type' => 'ALL', 'possible_keys' => NULL, 'key' => NULL, 'key_len' => NULL, 'ref' => NULL, 'rows' => 184, 'extra' => 'Using where; Using filesort', ) ]
[ SQL ] SELECT `id`,`parent_id`,`name` FROM `cmf_goods_category` WHERE ( `parent_id` = 119 AND `status` = 1 ) AND `cmf_goods_category`.`delete_time` = '0' ORDER BY `list_order` [ RunTime:0.000391s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'cmf_goods_category', 'type' => 'ALL', 'possible_keys' => NULL, 'key' => NULL, 'key_len' => NULL, 'ref' => NULL, 'rows' => 184, 'extra' => 'Using where; Using filesort', ) ]
[ SQL ] SELECT `id`,`parent_id`,`name` FROM `cmf_goods_category` WHERE ( `parent_id` = 120 AND `status` = 1 ) AND `cmf_goods_category`.`delete_time` = '0' ORDER BY `list_order` [ RunTime:0.000394s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'cmf_goods_category', 'type' => 'ALL', 'possible_keys' => NULL, 'key' => NULL, 'key_len' => NULL, 'ref' => NULL, 'rows' => 184, 'extra' => 'Using where; Using filesort', ) ]
[ SQL ] SELECT `id`,`parent_id`,`name` FROM `cmf_goods_category` WHERE ( `parent_id` = 6 AND `status` = 1 ) AND `cmf_goods_category`.`delete_time` = '0' ORDER BY `list_order` [ RunTime:0.000388s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'cmf_goods_category', 'type' => 'ALL', 'possible_keys' => NULL, 'key' => NULL, 'key_len' => NULL, 'ref' => NULL, 'rows' => 184, 'extra' => 'Using where; Using filesort', ) ]
[ SQL ] SELECT `id`,`parent_id`,`name` FROM `cmf_goods_category` WHERE ( `parent_id` = 161 AND `status` = 1 ) AND `cmf_goods_category`.`delete_time` = '0' ORDER BY `list_order` [ RunTime:0.000393s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'cmf_goods_category', 'type' => 'ALL', 'possible_keys' => NULL, 'key' => NULL, 'key_len' => NULL, 'ref' => NULL, 'rows' => 184, 'extra' => 'Using where; Using filesort', ) ]
[ SQL ] SELECT `id`,`parent_id`,`name` FROM `cmf_goods_category` WHERE ( `parent_id` = 162 AND `status` = 1 ) AND `cmf_goods_category`.`delete_time` = '0' ORDER BY `list_order` [ RunTime:0.000474s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'cmf_goods_category', 'type' => 'ALL', 'possible_keys' => NULL, 'key' => NULL, 'key_len' => NULL, 'ref' => NULL, 'rows' => 184, 'extra' => 'Using where; Using filesort', ) ]
[ SQL ] SELECT `id`,`parent_id`,`name` FROM `cmf_goods_category` WHERE ( `parent_id` = 7 AND `status` = 1 ) AND `cmf_goods_category`.`delete_time` = '0' ORDER BY `list_order` [ RunTime:0.000428s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'cmf_goods_category', 'type' => 'ALL', 'possible_keys' => NULL, 'key' => NULL, 'key_len' => NULL, 'ref' => NULL, 'rows' => 184, 'extra' => 'Using where; Using filesort', ) ]
[ SQL ] SELECT `id`,`parent_id`,`name` FROM `cmf_goods_category` WHERE ( `parent_id` = 169 AND `status` = 1 ) AND `cmf_goods_category`.`delete_time` = '0' ORDER BY `list_order` [ RunTime:0.000491s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'cmf_goods_category', 'type' => 'ALL', 'possible_keys' => NULL, 'key' => NULL, 'key_len' => NULL, 'ref' => NULL, 'rows' => 184, 'extra' => 'Using where; Using filesort', ) ]
[ SQL ] SELECT `id`,`parent_id`,`name` FROM `cmf_goods_category` WHERE ( `parent_id` = 170 AND `status` = 1 ) AND `cmf_goods_category`.`delete_time` = '0' ORDER BY `list_order` [ RunTime:0.000568s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'cmf_goods_category', 'type' => 'ALL', 'possible_keys' => NULL, 'key' => NULL, 'key_len' => NULL, 'ref' => NULL, 'rows' => 184, 'extra' => 'Using where; Using filesort', ) ]
[ SQL ] SELECT `id`,`parent_id`,`name` FROM `cmf_goods_category` WHERE ( `parent_id` = 1 AND `status` = 1 ) AND `cmf_goods_category`.`delete_time` = '0' ORDER BY `list_order` [ RunTime:0.000417s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'cmf_goods_category', 'type' => 'ALL', 'possible_keys' => NULL, 'key' => NULL, 'key_len' => NULL, 'ref' => NULL, 'rows' => 184, 'extra' => 'Using where; Using filesort', ) ]
[ SQL ] SELECT `id`,`parent_id`,`name` FROM `cmf_goods_category` WHERE ( `parent_id` = 11 AND `status` = 1 ) AND `cmf_goods_category`.`delete_time` = '0' ORDER BY `list_order` [ RunTime:0.000399s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'cmf_goods_category', 'type' => 'ALL', 'possible_keys' => NULL, 'key' => NULL, 'key_len' => NULL, 'ref' => NULL, 'rows' => 184, 'extra' => 'Using where; Using filesort', ) ]
[ SQL ] SELECT `id`,`parent_id`,`name` FROM `cmf_goods_category` WHERE ( `parent_id` = 8 AND `status` = 1 ) AND `cmf_goods_category`.`delete_time` = '0' ORDER BY `list_order` [ RunTime:0.000420s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'cmf_goods_category', 'type' => 'ALL', 'possible_keys' => NULL, 'key' => NULL, 'key_len' => NULL, 'ref' => NULL, 'rows' => 184, 'extra' => 'Using where; Using filesort', ) ]
[ SQL ] SELECT `id`,`parent_id`,`name` FROM `cmf_goods_category` WHERE ( `parent_id` = 9 AND `status` = 1 ) AND `cmf_goods_category`.`delete_time` = '0' ORDER BY `list_order` [ RunTime:0.000386s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'cmf_goods_category', 'type' => 'ALL', 'possible_keys' => NULL, 'key' => NULL, 'key_len' => NULL, 'ref' => NULL, 'rows' => 184, 'extra' => 'Using where; Using filesort', ) ]
[ SQL ] SELECT `id`,`parent_id`,`name` FROM `cmf_goods_category` WHERE ( `parent_id` = 10 AND `status` = 1 ) AND `cmf_goods_category`.`delete_time` = '0' ORDER BY `list_order` [ RunTime:0.000458s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'cmf_goods_category', 'type' => 'ALL', 'possible_keys' => NULL, 'key' => NULL, 'key_len' => NULL, 'ref' => NULL, 'rows' => 184, 'extra' => 'Using where; Using filesort', ) ]
[ SQL ] SELECT `id`,`parent_id`,`name` FROM `cmf_goods_category` WHERE ( `parent_id` = 12 AND `status` = 1 ) AND `cmf_goods_category`.`delete_time` = '0' ORDER BY `list_order` [ RunTime:0.000451s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'cmf_goods_category', 'type' => 'ALL', 'possible_keys' => NULL, 'key' => NULL, 'key_len' => NULL, 'ref' => NULL, 'rows' => 184, 'extra' => 'Using where; Using filesort', ) ]
[ SQL ] SELECT `id`,`parent_id`,`name` FROM `cmf_goods_category` WHERE ( `parent_id` = 13 AND `status` = 1 ) AND `cmf_goods_category`.`delete_time` = '0' ORDER BY `list_order` [ RunTime:0.000371s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'cmf_goods_category', 'type' => 'ALL', 'possible_keys' => NULL, 'key' => NULL, 'key_len' => NULL, 'ref' => NULL, 'rows' => 184, 'extra' => 'Using where; Using filesort', ) ]
[ SQL ] SELECT `id`,`parent_id`,`name` FROM `cmf_goods_category` WHERE ( `parent_id` = 14 AND `status` = 1 ) AND `cmf_goods_category`.`delete_time` = '0' ORDER BY `list_order` [ RunTime:0.000389s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'cmf_goods_category', 'type' => 'ALL', 'possible_keys' => NULL, 'key' => NULL, 'key_len' => NULL, 'ref' => NULL, 'rows' => 184, 'extra' => 'Using where; Using filesort', ) ]
[ SQL ] SHOW COLUMNS FROM `cmf_byte_options` [ RunTime:0.004736s ]
[ SQL ] SELECT `config` FROM `cmf_byte_options` WHERE `name` = 'shop' LIMIT 1 [ RunTime:0.000362s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'cmf_byte_options', 'type' => 'ALL', 'possible_keys' => NULL, 'key' => NULL, 'key_len' => NULL, 'ref' => NULL, 'rows' => 18, 'extra' => 'Using where', ) ]
[ SQL ] SHOW COLUMNS FROM `cmf_shop_nav` [ RunTime:0.004280s ]
[ SQL ] SELECT * FROM `cmf_shop_nav` WHERE `status` = 1 ORDER BY `list_order` [ RunTime:0.001181s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'cmf_shop_nav', 'type' => 'ALL', 'possible_keys' => NULL, 'key' => NULL, 'key_len' => NULL, 'ref' => NULL, 'rows' => 6, 'extra' => 'Using where; Using filesort', ) ]
[ SQL ] SHOW COLUMNS FROM `cmf_slide` [ RunTime:0.002516s ]
[ SQL ] SELECT `id` FROM `cmf_slide` WHERE ( `keyword` = 'PC_INDEX_SWIPER' AND `status` = 1 ) AND `cmf_slide`.`delete_time` = '0' LIMIT 1 [ RunTime:0.000500s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'cmf_slide', 'type' => 'ALL', 'possible_keys' => NULL, 'key' => NULL, 'key_len' => NULL, 'ref' => NULL, 'rows' => 4, 'extra' => 'Using where', ) ]
[ DB ] CONNECT:[ UseTime:0.000406s ] mysql:host=127.0.0.1;port=3306;dbname=ytdnc;charset=utf8
[ SQL ] SHOW COLUMNS FROM `cmf_slide_item` [ RunTime:0.002301s ]
[ SQL ] SELECT `url`,`image` FROM `cmf_slide_item` WHERE `slide_id` = 1 AND `status` = 1 ORDER BY `list_order` [ RunTime:0.000940s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'cmf_slide_item', 'type' => 'ALL', 'possible_keys' => NULL, 'key' => NULL, 'key_len' => NULL, 'ref' => NULL, 'rows' => 12, 'extra' => 'Using where; Using filesort', ) ]
[ SQL ] SELECT `id` FROM `cmf_slide` WHERE ( `keyword` = 'PC_INDEX_RECOMMEND' AND `status` = 1 ) AND `cmf_slide`.`delete_time` = '0' LIMIT 1 [ RunTime:0.000286s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'cmf_slide', 'type' => 'ALL', 'possible_keys' => NULL, 'key' => NULL, 'key_len' => NULL, 'ref' => NULL, 'rows' => 4, 'extra' => 'Using where', ) ]
[ DB ] CONNECT:[ UseTime:0.000402s ] mysql:host=127.0.0.1;port=3306;dbname=ytdnc;charset=utf8
[ SQL ] SELECT `url`,`image` FROM `cmf_slide_item` WHERE `slide_id` = 3 AND `status` = 1 ORDER BY `list_order` [ RunTime:0.000353s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'cmf_slide_item', 'type' => 'ALL', 'possible_keys' => NULL, 'key' => NULL, 'key_len' => NULL, 'ref' => NULL, 'rows' => 12, 'extra' => 'Using where; Using filesort', ) ]
[ SQL ] SELECT `id`,`name`,`des`,`adv` FROM `cmf_goods_category` WHERE `floor` <> 0 ORDER BY `floor` [ RunTime:0.000347s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'cmf_goods_category', 'type' => 'ALL', 'possible_keys' => NULL, 'key' => NULL, 'key_len' => NULL, 'ref' => NULL, 'rows' => 184, 'extra' => 'Using where; Using filesort', ) ]
[ SQL ] SELECT `id` FROM `cmf_goods_category` WHERE `parent_id` = 6 [ RunTime:0.000333s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'cmf_goods_category', 'type' => 'ALL', 'possible_keys' => NULL, 'key' => NULL, 'key_len' => NULL, 'ref' => NULL, 'rows' => 184, 'extra' => 'Using where', ) ]
[ SQL ] SELECT `id` FROM `cmf_goods_category` WHERE `parent_id` IN (161,162) [ RunTime:0.000331s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'cmf_goods_category', 'type' => 'ALL', 'possible_keys' => NULL, 'key' => NULL, 'key_len' => NULL, 'ref' => NULL, 'rows' => 184, 'extra' => 'Using where', ) ]
[ SQL ] SHOW COLUMNS FROM `cmf_goods` [ RunTime:0.008511s ]
[ SQL ] SELECT `a`.`id`,`a`.`post_title`,`a`.`thumbnail`,`a`.`price`,`b`.`category_id` FROM `cmf_goods` `a` INNER JOIN `cmf_goods_category_post` `b` ON `a`.`id`=`b`.`post_id` WHERE `a`.`price` <> '0' AND `a`.`post_status` = '1' AND `b`.`category_id` IN ('161','162','163','164','165','166','167','168') ORDER BY `a`.`list_order` DESC,`a`.`create_time` DESC LIMIT 8 [ RunTime:0.042817s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'b', 'type' => 'range', 'possible_keys' => 'term_taxonomy_id', 'key' => 'term_taxonomy_id', 'key_len' => '8', 'ref' => NULL, 'rows' => 3806, 'extra' => 'Using index condition; Using temporary; Using filesort', ) ]
[ SQL ] SELECT `id` FROM `cmf_goods_category` WHERE `parent_id` = 7 [ RunTime:0.000383s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'cmf_goods_category', 'type' => 'ALL', 'possible_keys' => NULL, 'key' => NULL, 'key_len' => NULL, 'ref' => NULL, 'rows' => 184, 'extra' => 'Using where', ) ]
[ SQL ] SELECT `id` FROM `cmf_goods_category` WHERE `parent_id` IN (169,170) [ RunTime:0.000291s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'cmf_goods_category', 'type' => 'ALL', 'possible_keys' => NULL, 'key' => NULL, 'key_len' => NULL, 'ref' => NULL, 'rows' => 184, 'extra' => 'Using where', ) ]
[ SQL ] SELECT `a`.`id`,`a`.`post_title`,`a`.`thumbnail`,`a`.`price`,`b`.`category_id` FROM `cmf_goods` `a` INNER JOIN `cmf_goods_category_post` `b` ON `a`.`id`=`b`.`post_id` WHERE `a`.`price` <> '0' AND `a`.`post_status` = '1' AND `b`.`category_id` IN ('169','170','171','172','173','174','175','176','177','178','179','180','181','182') ORDER BY `a`.`list_order` DESC,`a`.`create_time` DESC LIMIT 8 [ RunTime:0.001727s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'b', 'type' => 'range', 'possible_keys' => 'term_taxonomy_id', 'key' => 'term_taxonomy_id', 'key_len' => '8', 'ref' => NULL, 'rows' => 1666, 'extra' => 'Using index condition; Using temporary; Using filesort', ) ]
[ SQL ] SELECT `id` FROM `cmf_goods_category` WHERE `parent_id` = 1 [ RunTime:0.000312s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'cmf_goods_category', 'type' => 'ALL', 'possible_keys' => NULL, 'key' => NULL, 'key_len' => NULL, 'ref' => NULL, 'rows' => 184, 'extra' => 'Using where', ) ]
[ SQL ] SELECT `id` FROM `cmf_goods_category` WHERE `parent_id` IN (8,9,10,11,12,13,14) [ RunTime:0.000356s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'cmf_goods_category', 'type' => 'ALL', 'possible_keys' => NULL, 'key' => NULL, 'key_len' => NULL, 'ref' => NULL, 'rows' => 184, 'extra' => 'Using where', ) ]
[ SQL ] SELECT `a`.`id`,`a`.`post_title`,`a`.`thumbnail`,`a`.`price`,`b`.`category_id` FROM `cmf_goods` `a` INNER JOIN `cmf_goods_category_post` `b` ON `a`.`id`=`b`.`post_id` WHERE `a`.`price` <> '0' AND `a`.`post_status` = '1' AND `b`.`category_id` IN ('8','9','10','11','12','13','14','15','16','17','18','19','20','21','22','23','24','25','26','27','28','29','30','31','32','33','34','35','36','37','38','39','40','41','42','43','44','45','46','47','48','49','50','51','52','53','54') ORDER BY `a`.`list_order` DESC,`a`.`create_time` DESC LIMIT 8 [ RunTime:0.036364s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'b', 'type' => 'ALL', 'possible_keys' => 'term_taxonomy_id', 'key' => NULL, 'key_len' => NULL, 'ref' => NULL, 'rows' => 28710, 'extra' => 'Using where; Using temporary; Using filesort', ) ]
[ SQL ] SELECT `id` FROM `cmf_goods_category` WHERE `parent_id` = 2 [ RunTime:0.000378s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'cmf_goods_category', 'type' => 'ALL', 'possible_keys' => NULL, 'key' => NULL, 'key_len' => NULL, 'ref' => NULL, 'rows' => 184, 'extra' => 'Using where', ) ]
[ SQL ] SELECT `id` FROM `cmf_goods_category` WHERE `parent_id` IN (55,56,57,58,59,60,61,62,63) [ RunTime:0.000345s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'cmf_goods_category', 'type' => 'ALL', 'possible_keys' => NULL, 'key' => NULL, 'key_len' => NULL, 'ref' => NULL, 'rows' => 184, 'extra' => 'Using where', ) ]
[ SQL ] SELECT `a`.`id`,`a`.`post_title`,`a`.`thumbnail`,`a`.`price`,`b`.`category_id` FROM `cmf_goods` `a` INNER JOIN `cmf_goods_category_post` `b` ON `a`.`id`=`b`.`post_id` WHERE `a`.`price` <> '0' AND `a`.`post_status` = '1' AND `b`.`category_id` IN ('55','56','57','58','59','60','61','62','63','64','65','66','67','68','69','70','71','72','73','74','75','76','77','78','79','80','81','82','83','84','85','86') ORDER BY `a`.`list_order` DESC,`a`.`create_time` DESC LIMIT 8 [ RunTime:0.022189s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'b', 'type' => 'range', 'possible_keys' => 'term_taxonomy_id', 'key' => 'term_taxonomy_id', 'key_len' => '8', 'ref' => NULL, 'rows' => 3808, 'extra' => 'Using index condition; Using temporary; Using filesort', ) ]
[ SQL ] SELECT `id` FROM `cmf_goods_category` WHERE `parent_id` = 3 [ RunTime:0.000333s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'cmf_goods_category', 'type' => 'ALL', 'possible_keys' => NULL, 'key' => NULL, 'key_len' => NULL, 'ref' => NULL, 'rows' => 184, 'extra' => 'Using where', ) ]
[ SQL ] SELECT `id` FROM `cmf_goods_category` WHERE `parent_id` IN (87,88,89) [ RunTime:0.000305s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'cmf_goods_category', 'type' => 'ALL', 'possible_keys' => NULL, 'key' => NULL, 'key_len' => NULL, 'ref' => NULL, 'rows' => 184, 'extra' => 'Using where', ) ]
[ SQL ] SELECT `a`.`id`,`a`.`post_title`,`a`.`thumbnail`,`a`.`price`,`b`.`category_id` FROM `cmf_goods` `a` INNER JOIN `cmf_goods_category_post` `b` ON `a`.`id`=`b`.`post_id` WHERE `a`.`price` <> '0' AND `a`.`post_status` = '1' AND `b`.`category_id` IN ('87','88','89','90','91','92','93','94','95','96','97','98','99','100','101','102','103','104') ORDER BY `a`.`list_order` DESC,`a`.`create_time` DESC LIMIT 8 [ RunTime:0.005962s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'b', 'type' => 'range', 'possible_keys' => 'term_taxonomy_id', 'key' => 'term_taxonomy_id', 'key_len' => '8', 'ref' => NULL, 'rows' => 2142, 'extra' => 'Using index condition; Using temporary; Using filesort', ) ]
[ SQL ] SELECT `id` FROM `cmf_goods_category` WHERE `parent_id` = 5 [ RunTime:0.000286s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'cmf_goods_category', 'type' => 'ALL', 'possible_keys' => NULL, 'key' => NULL, 'key_len' => NULL, 'ref' => NULL, 'rows' => 184, 'extra' => 'Using where', ) ]
[ SQL ] SELECT `id` FROM `cmf_goods_category` WHERE `parent_id` IN (114,115,116,117,118,119,120) [ RunTime:0.000363s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'cmf_goods_category', 'type' => 'ALL', 'possible_keys' => NULL, 'key' => NULL, 'key_len' => NULL, 'ref' => NULL, 'rows' => 184, 'extra' => 'Using where', ) ]
[ SQL ] SELECT `a`.`id`,`a`.`post_title`,`a`.`thumbnail`,`a`.`price`,`b`.`category_id` FROM `cmf_goods` `a` INNER JOIN `cmf_goods_category_post` `b` ON `a`.`id`=`b`.`post_id` WHERE `a`.`price` <> '0' AND `a`.`post_status` = '1' AND `b`.`category_id` IN ('114','115','116','117','118','119','120','121','122','123','124','125','126','127','128','129','130','131','132','133','134','135','136','137','138','139','140','141','142','143','144','145','146','147','148','149','150','151','152','153','154','155','156','157','158','159','160') ORDER BY `a`.`list_order` DESC,`a`.`create_time` DESC LIMIT 8 [ RunTime:0.021948s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'b', 'type' => 'ALL', 'possible_keys' => 'term_taxonomy_id', 'key' => NULL, 'key_len' => NULL, 'ref' => NULL, 'rows' => 28710, 'extra' => 'Using where; Using temporary; Using filesort', ) ]
[ SQL ] SHOW COLUMNS FROM `cmf_footer_nav` [ RunTime:0.006489s ]
[ SQL ] SELECT * FROM `cmf_footer_nav` ORDER BY `list_order` [ RunTime:0.000337s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'cmf_footer_nav', 'type' => 'ALL', 'possible_keys' => NULL, 'key' => NULL, 'key_len' => NULL, 'ref' => NULL, 'rows' => 4, 'extra' => 'Using filesort', ) ]
[ SQL ] SHOW COLUMNS FROM `cmf_footer_nav_list` [ RunTime:0.003296s ]
[ SQL ] SELECT * FROM `cmf_footer_nav_list` WHERE `nav_id` = 4 ORDER BY `list_order` [ RunTime:0.001626s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'cmf_footer_nav_list', 'type' => 'ALL', 'possible_keys' => NULL, 'key' => NULL, 'key_len' => NULL, 'ref' => NULL, 'rows' => 11, 'extra' => 'Using where; Using filesort', ) ]
[ SQL ] SELECT * FROM `cmf_footer_nav_list` WHERE `nav_id` = 1 ORDER BY `list_order` [ RunTime:0.000304s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'cmf_footer_nav_list', 'type' => 'ALL', 'possible_keys' => NULL, 'key' => NULL, 'key_len' => NULL, 'ref' => NULL, 'rows' => 11, 'extra' => 'Using where; Using filesort', ) ]
[ SQL ] SELECT * FROM `cmf_footer_nav_list` WHERE `nav_id` = 2 ORDER BY `list_order` [ RunTime:0.000359s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'cmf_footer_nav_list', 'type' => 'ALL', 'possible_keys' => NULL, 'key' => NULL, 'key_len' => NULL, 'ref' => NULL, 'rows' => 11, 'extra' => 'Using where; Using filesort', ) ]
[ SQL ] SELECT * FROM `cmf_footer_nav_list` WHERE `nav_id` = 5 ORDER BY `list_order` [ RunTime:0.000294s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'cmf_footer_nav_list', 'type' => 'ALL', 'possible_keys' => NULL, 'key' => NULL, 'key_len' => NULL, 'ref' => NULL, 'rows' => 11, 'extra' => 'Using where; Using filesort', ) ]
[ SQL ] SHOW COLUMNS FROM `cmf_theme_file` [ RunTime:0.002792s ]
[ SQL ] SELECT * FROM `cmf_theme_file` WHERE `theme` = 'default' [ RunTime:0.000767s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'cmf_theme_file', 'type' => 'ALL', 'possible_keys' => NULL, 'key' => NULL, 'key_len' => NULL, 'ref' => NULL, 'rows' => 1, 'extra' => 'Using where', ) ]
[ SQL ] SHOW COLUMNS FROM `cmf_theme` [ RunTime:0.002651s ]
[ SQL ] UPDATE `cmf_theme` SET `name` = 'default' , `version` = '1.0.0' , `demo_url` = 'http://demo.thinkcmf.com' , `author` = 'ThinkCMF' , `lang` = 'zh-cn' , `author_url` = 'http://www.thinkcmf.com' , `keywords` = 'ThinkCMF默认模板' , `description` = 'ThinkCMF默认模板' WHERE `theme` = 'default' [ RunTime:0.002002s ]
[ SQL ] SELECT `more` FROM `cmf_theme_file` WHERE `theme` = 'default' AND ( `is_public` = 1 OR `file` = 'portal/index' ) [ RunTime:0.000321s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'cmf_theme_file', 'type' => 'ALL', 'possible_keys' => NULL, 'key' => NULL, 'key_len' => NULL, 'ref' => NULL, 'rows' => 1, 'extra' => 'Using where', ) ]