德德沐农业文库共享网

基本文件流程错误 SQL 调试

/www/wwwroot/www.dedemu.cn/public/index.php ( 0.97 KB )
/www/wwwroot/www.dedemu.cn/vendor/thinkphp/base.php ( 1.71 KB )
/www/wwwroot/www.dedemu.cn/vendor/thinkphp/library/think/Loader.php ( 12.70 KB )
/www/wwwroot/www.dedemu.cn/vendor/composer/autoload_static.php ( 24.35 KB )
/www/wwwroot/www.dedemu.cn/vendor/thinkphp/library/think/Error.php ( 4.00 KB )
/www/wwwroot/www.dedemu.cn/vendor/psr/log/Psr/Log/LoggerInterface.php ( 3.04 KB )
/www/wwwroot/www.dedemu.cn/vendor/thinkphp/library/think/Container.php ( 17.20 KB )
/www/wwwroot/www.dedemu.cn/vendor/thinkcmf/cmf/src/App.php ( 29.43 KB )
/www/wwwroot/www.dedemu.cn/vendor/thinkphp/library/think/Env.php ( 2.85 KB )
/www/wwwroot/www.dedemu.cn/vendor/thinkphp/library/think/Config.php ( 9.71 KB )
/www/wwwroot/www.dedemu.cn/vendor/thinkphp/convention.php ( 11.74 KB )
/www/wwwroot/www.dedemu.cn/app/tags.php ( 1.35 KB )
/www/wwwroot/www.dedemu.cn/vendor/thinkphp/library/think/Hook.php ( 5.58 KB )
/www/wwwroot/www.dedemu.cn/app/common.php ( 36.89 KB )
/www/wwwroot/www.dedemu.cn/vendor/thinkphp/helper.php ( 20.40 KB )
/www/wwwroot/www.dedemu.cn/vendor/thinkcmf/cmf-app/src/app.php ( 5.33 KB )
/www/wwwroot/www.dedemu.cn/vendor/thinkcmf/cmf-app/src/database.php ( 0.90 KB )
/www/wwwroot/www.dedemu.cn/vendor/thinkcmf/cmf-app/src/template.php ( 2.02 KB )
/www/wwwroot/www.dedemu.cn/vendor/thinkcmf/cmf-app/src/paginate.php ( 0.17 KB )
/www/wwwroot/www.dedemu.cn/vendor/thinkcmf/cmf-app/src/tags.php ( 1.34 KB )
/www/wwwroot/www.dedemu.cn/vendor/thinkcmf/cmf/src/behavior/InitHookBehavior.php ( 2.07 KB )
/www/wwwroot/www.dedemu.cn/app/app.php ( 6.23 KB )
/www/wwwroot/www.dedemu.cn/app/database.php ( 0.90 KB )
/www/wwwroot/www.dedemu.cn/app/template.php ( 2.03 KB )
/www/wwwroot/www.dedemu.cn/app/paginate.php ( 0.17 KB )
/www/wwwroot/www.dedemu.cn/data/config/database.php ( 0.60 KB )
/www/wwwroot/www.dedemu.cn/data/config/goods.php ( 0.63 KB )
/www/wwwroot/www.dedemu.cn/data/config/param.php ( 0.25 KB )
/www/wwwroot/www.dedemu.cn/vendor/symfony/deprecation-contracts/function.php ( 0.98 KB )
/www/wwwroot/www.dedemu.cn/vendor/symfony/polyfill-php80/bootstrap.php ( 1.50 KB )
/www/wwwroot/www.dedemu.cn/vendor/symfony/polyfill-mbstring/bootstrap.php ( 7.07 KB )
/www/wwwroot/www.dedemu.cn/vendor/ralouphie/getallheaders/src/getallheaders.php ( 1.60 KB )
/www/wwwroot/www.dedemu.cn/vendor/guzzlehttp/guzzle/src/functions_include.php ( 0.16 KB )
/www/wwwroot/www.dedemu.cn/vendor/guzzlehttp/guzzle/src/functions.php ( 5.55 KB )
/www/wwwroot/www.dedemu.cn/vendor/symfony/polyfill-php73/bootstrap.php ( 0.99 KB )
/www/wwwroot/www.dedemu.cn/vendor/adbario/php-dot-notation/src/helpers.php ( 0.57 KB )
/www/wwwroot/www.dedemu.cn/vendor/danielstjules/stringy/src/Create.php ( 0.55 KB )
/www/wwwroot/www.dedemu.cn/vendor/ezyang/htmlpurifier/library/HTMLPurifier.composer.php ( 0.10 KB )
/www/wwwroot/www.dedemu.cn/vendor/symfony/polyfill-ctype/bootstrap.php ( 1.56 KB )
/www/wwwroot/www.dedemu.cn/vendor/topthink/think-captcha/src/helper.php ( 1.54 KB )
/www/wwwroot/www.dedemu.cn/vendor/thinkphp/library/think/facade/Route.php ( 3.84 KB )
/www/wwwroot/www.dedemu.cn/vendor/thinkphp/library/think/Facade.php ( 3.44 KB )
/www/wwwroot/www.dedemu.cn/vendor/thinkphp/library/think/Route.php ( 25.84 KB )
/www/wwwroot/www.dedemu.cn/vendor/thinkphp/library/think/Request.php ( 57.54 KB )
/www/wwwroot/www.dedemu.cn/vendor/thinkphp/library/think/route/Domain.php ( 7.08 KB )
/www/wwwroot/www.dedemu.cn/vendor/thinkphp/library/think/route/RuleGroup.php ( 16.45 KB )
/www/wwwroot/www.dedemu.cn/vendor/thinkphp/library/think/route/Rule.php ( 28.92 KB )
/www/wwwroot/www.dedemu.cn/vendor/thinkphp/library/think/route/RuleItem.php ( 8.84 KB )
/www/wwwroot/www.dedemu.cn/vendor/thinkphp/library/think/route/RuleName.php ( 3.92 KB )
/www/wwwroot/www.dedemu.cn/vendor/thinkphp/library/think/facade/Validate.php ( 4.83 KB )
/www/wwwroot/www.dedemu.cn/vendor/thinkphp/library/think/Validate.php ( 43.93 KB )
/www/wwwroot/www.dedemu.cn/vendor/khanamiryan/qrcode-detector-decoder/lib/common/customFunctions.php ( 1.75 KB )
/www/wwwroot/www.dedemu.cn/vendor/mtdowling/jmespath.php/src/JmesPath.php ( 0.36 KB )
/www/wwwroot/www.dedemu.cn/vendor/songshenzong/support/src/StringsHelpers.php ( 0.18 KB )
/www/wwwroot/www.dedemu.cn/vendor/songshenzong/support/src/BashEchoHelpers.php ( 0.97 KB )
/www/wwwroot/www.dedemu.cn/vendor/thinkcmf/cmf/src/common.php ( 62.63 KB )
/www/wwwroot/www.dedemu.cn/vendor/overtrue/wechat/src/Kernel/Support/Helpers.php ( 2.54 KB )
/www/wwwroot/www.dedemu.cn/vendor/overtrue/wechat/src/Kernel/Helpers.php ( 1.89 KB )
/www/wwwroot/www.dedemu.cn/vendor/topthink/think-helper/src/helper.php ( 2.88 KB )
/www/wwwroot/www.dedemu.cn/vendor/thinkphp/library/think/Db.php ( 7.67 KB )
/www/wwwroot/www.dedemu.cn/vendor/thinkphp/library/think/Lang.php ( 7.56 KB )
/www/wwwroot/www.dedemu.cn/vendor/thinkcmf/cmf/src/Log.php ( 8.96 KB )
/www/wwwroot/www.dedemu.cn/vendor/thinkphp/library/think/log/driver/File.php ( 8.97 KB )
/www/wwwroot/www.dedemu.cn/vendor/thinkphp/lang/zh-cn.php ( 12.58 KB )
/www/wwwroot/www.dedemu.cn/data/route/route.php ( 0.47 KB )
/www/wwwroot/www.dedemu.cn/vendor/thinkphp/library/think/facade/Cache.php ( 2.06 KB )
/www/wwwroot/www.dedemu.cn/vendor/thinkphp/library/think/Cache.php ( 3.27 KB )
/www/wwwroot/www.dedemu.cn/vendor/thinkphp/library/think/cache/driver/File.php ( 7.99 KB )
/www/wwwroot/www.dedemu.cn/vendor/thinkphp/library/think/cache/Driver.php ( 8.64 KB )
/www/wwwroot/www.dedemu.cn/vendor/thinkphp/library/think/facade/Hook.php ( 1.46 KB )
/www/wwwroot/www.dedemu.cn/vendor/thinkcmf/cmf/src/behavior/LangBehavior.php ( 2.48 KB )
/www/wwwroot/www.dedemu.cn/vendor/thinkphp/library/think/facade/Lang.php ( 1.75 KB )
/www/wwwroot/www.dedemu.cn/vendor/thinkcmf/cmf/src/lang/zh-cn.php ( 3.14 KB )
/www/wwwroot/www.dedemu.cn/vendor/thinkphp/library/think/facade/Env.php ( 1.17 KB )
/www/wwwroot/www.dedemu.cn/vendor/thinkcmf/cmf-app/src/admin/lang/zh-cn.php ( 9.16 KB )
/www/wwwroot/www.dedemu.cn/vendor/thinkcmf/cmf-app/src/admin/lang/zh-cn/common.php ( 0.60 KB )
/www/wwwroot/www.dedemu.cn/vendor/thinkcmf/cmf-app/src/user/lang/zh-cn.php ( 4.13 KB )
/www/wwwroot/www.dedemu.cn/app/admin/lang/zh-cn/common.php ( 0.60 KB )
/www/wwwroot/www.dedemu.cn/app/portal/lang/zh-cn/common.php ( 0.76 KB )
/www/wwwroot/www.dedemu.cn/vendor/thinkphp/library/think/route/dispatch/Url.php ( 5.24 KB )
/www/wwwroot/www.dedemu.cn/vendor/thinkphp/library/think/route/Dispatch.php ( 9.26 KB )
/www/wwwroot/www.dedemu.cn/vendor/thinkcmf/cmf/src/route/dispatch/Module.php ( 5.15 KB )
/www/wwwroot/www.dedemu.cn/vendor/thinkphp/library/think/Middleware.php ( 5.34 KB )
/www/wwwroot/www.dedemu.cn/vendor/thinkphp/library/think/Cookie.php ( 7.35 KB )
/www/wwwroot/www.dedemu.cn/vendor/thinkphp/library/think/View.php ( 5.74 KB )
/www/wwwroot/www.dedemu.cn/vendor/thinkphp/library/think/view/driver/Think.php ( 6.12 KB )
/www/wwwroot/www.dedemu.cn/vendor/thinkphp/library/think/Template.php ( 47.31 KB )
/www/wwwroot/www.dedemu.cn/vendor/thinkphp/library/think/template/driver/File.php ( 2.29 KB )
/www/wwwroot/www.dedemu.cn/vendor/thinkphp/library/think/Session.php ( 14.13 KB )
/www/wwwroot/www.dedemu.cn/vendor/thinkphp/library/think/Debug.php ( 7.57 KB )
/www/wwwroot/www.dedemu.cn/vendor/thinkcmf/cmf/src/behavior/InitAppHookBehavior.php ( 2.05 KB )
/www/wwwroot/www.dedemu.cn/vendor/thinkphp/library/think/model/Collection.php ( 3.23 KB )
/www/wwwroot/www.dedemu.cn/vendor/thinkphp/library/think/Collection.php ( 13.60 KB )
/www/wwwroot/www.dedemu.cn/app/home/controller/IndexController.php ( 11.21 KB )
/www/wwwroot/www.dedemu.cn/vendor/thinkcmf/cmf/src/controller/HomeBaseController.php ( 8.91 KB )
/www/wwwroot/www.dedemu.cn/vendor/thinkcmf/cmf/src/controller/BaseController.php ( 2.97 KB )
/www/wwwroot/www.dedemu.cn/vendor/thinkphp/library/think/Controller.php ( 7.53 KB )
/www/wwwroot/www.dedemu.cn/vendor/thinkphp/library/traits/controller/Jump.php ( 4.76 KB )
/www/wwwroot/www.dedemu.cn/vendor/thinkphp/library/think/facade/Config.php ( 1.52 KB )
/www/wwwroot/www.dedemu.cn/vendor/thinkphp/library/think/facade/Cookie.php ( 1.58 KB )
/www/wwwroot/www.dedemu.cn/vendor/thinkphp/library/think/facade/View.php ( 1.76 KB )
/www/wwwroot/www.dedemu.cn/vendor/thinkcmf/cmf/src/behavior/HomeLangBehavior.php ( 1.52 KB )
/www/wwwroot/www.dedemu.cn/app/portal/lang/zh-cn/home.php ( 0.62 KB )
/www/wwwroot/www.dedemu.cn/vendor/thinkphp/library/think/facade/Session.php ( 2.05 KB )
/www/wwwroot/www.dedemu.cn/vendor/thinkphp/library/think/db/Connection.php ( 58.93 KB )
/www/wwwroot/www.dedemu.cn/vendor/thinkphp/library/think/db/connector/Mysql.php ( 6.22 KB )
/www/wwwroot/www.dedemu.cn/vendor/thinkphp/library/think/db/builder/Mysql.php ( 5.85 KB )
/www/wwwroot/www.dedemu.cn/vendor/thinkphp/library/think/db/Builder.php ( 36.76 KB )
/www/wwwroot/www.dedemu.cn/vendor/thinkphp/library/think/db/Query.php ( 105.00 KB )
/www/wwwroot/www.dedemu.cn/vendor/thinkphp/library/think/db/Expression.php ( 1.11 KB )
/www/wwwroot/www.dedemu.cn/vendor/thinkcmf/cmf/src/paginator/Bootstrap.php ( 7.37 KB )
/www/wwwroot/www.dedemu.cn/vendor/thinkphp/library/think/Paginator.php ( 9.83 KB )
/www/wwwroot/www.dedemu.cn/vendor/thinkphp/library/think/Response.php ( 9.68 KB )
/www/wwwroot/www.dedemu.cn/vendor/thinkphp/library/think/response/View.php ( 2.77 KB )
/www/wwwroot/www.dedemu.cn/data/runtime/temp/300145ab216c1fd1df7c110a2ebded89.php ( 51.80 KB )
/www/wwwroot/www.dedemu.cn/vendor/thinkphp/library/think/facade/Url.php ( 1.13 KB )
/www/wwwroot/www.dedemu.cn/vendor/thinkphp/library/think/Url.php ( 13.22 KB )
/www/wwwroot/www.dedemu.cn/app/portal/service/ApiService.php ( 17.48 KB )
/www/wwwroot/www.dedemu.cn/app/portal/model/PortalCategoryModel.php ( 9.36 KB )
/www/wwwroot/www.dedemu.cn/vendor/thinkphp/library/think/Model.php ( 28.59 KB )
/www/wwwroot/www.dedemu.cn/vendor/thinkphp/library/think/model/concern/Attribute.php ( 17.64 KB )
/www/wwwroot/www.dedemu.cn/vendor/thinkphp/library/think/model/concern/RelationShip.php ( 20.60 KB )
/www/wwwroot/www.dedemu.cn/vendor/thinkphp/library/think/model/concern/ModelEvent.php ( 6.04 KB )
/www/wwwroot/www.dedemu.cn/vendor/thinkphp/library/think/model/concern/TimeStamp.php ( 2.58 KB )
/www/wwwroot/www.dedemu.cn/vendor/thinkphp/library/think/model/concern/Conversion.php ( 7.84 KB )
/www/wwwroot/www.dedemu.cn/app/admin/service/ApiService.php ( 1.33 KB )
/www/wwwroot/www.dedemu.cn/vendor/thinkcmf/cmf/src/lib/Storage.php ( 3.90 KB )
/www/wwwroot/www.dedemu.cn/vendor/thinkcmf/cmf/src/model/OptionModel.php ( 0.91 KB )
/www/wwwroot/www.dedemu.cn/vendor/thinkcmf/cmf/src/lib/storage/Local.php ( 2.86 KB )
/www/wwwroot/www.dedemu.cn/vendor/thinkphp/library/think/debug/Html.php ( 4.02 KB )

[ DB ] CONNECT:[ UseTime:0.000412s ] mysql:host=127.0.0.1;port=3306;dbname=www_dedemu_cn;charset=utf8mb4
[ SQL ] SHOW COLUMNS FROM `cmf_project_msg` [ RunTime:0.000795s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `cmf_project_msg` WHERE `user_id` IS NULL AND `status` = 1 [ RunTime:0.000280s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => NULL, 'type' => NULL, 'possible_keys' => NULL, 'key' => NULL, 'key_len' => NULL, 'ref' => NULL, 'rows' => NULL, 'extra' => 'Impossible WHERE', ) ]
[ SQL ] SHOW COLUMNS FROM `cmf_project_library` [ RunTime:0.000860s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `cmf_project_library` WHERE `user_id` = 0 AND `status` = 2 [ RunTime:0.000261s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'cmf_project_library', 'type' => 'ref', 'possible_keys' => 'user_id', 'key' => 'user_id', 'key_len' => '4', 'ref' => 'const', 'rows' => 1, 'extra' => 'Using where', ) ]
[ SQL ] SHOW COLUMNS FROM `cmf_portal_post` [ RunTime:0.000821s ]
[ SQL ] SELECT * FROM `cmf_portal_post` WHERE `post_type` = 1 AND `post_status` = 1 AND `delete_time` = 0 ORDER BY `published_time` DESC LIMIT 10 [ RunTime:0.001561s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'cmf_portal_post', 'type' => 'ref', 'possible_keys' => 'type_status_date', 'key' => 'type_status_date', 'key_len' => '2', 'ref' => 'const,const', 'rows' => 305, 'extra' => 'Using where; Using filesort', ) ]
[ SQL ] SELECT * FROM `cmf_portal_post` WHERE `post_type` = 1 AND `post_status` = 1 AND `delete_time` = 0 ORDER BY `post_hits` DESC LIMIT 10 [ RunTime:0.001541s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'cmf_portal_post', 'type' => 'ref', 'possible_keys' => 'type_status_date', 'key' => 'type_status_date', 'key_len' => '2', 'ref' => 'const,const', 'rows' => 305, 'extra' => 'Using where; Using filesort', ) ]
[ SQL ] SELECT `a`.*,`b`.`user_nickname` FROM `cmf_project_library` `a` INNER JOIN `cmf_user` `b` ON `b`.`id`=`a`.`user_id` WHERE `recommend` = 1 AND `status` = 2 ORDER BY `is_top` DESC,`update_at` DESC,`id` DESC LIMIT 10 [ RunTime:0.002414s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'a', 'type' => 'ALL', 'possible_keys' => 'user_id', 'key' => NULL, 'key_len' => NULL, 'ref' => NULL, 'rows' => 2779, 'extra' => 'Using where; Using filesort', ) ]
[ SQL ] SELECT `a`.*,`b`.`user_nickname` FROM `cmf_project_library` `a` INNER JOIN `cmf_user` `b` ON `b`.`id`=`a`.`user_id` WHERE `status` = 2 ORDER BY `id` DESC LIMIT 10 [ RunTime:0.000446s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'a', 'type' => 'index', 'possible_keys' => 'user_id', 'key' => 'PRIMARY', 'key_len' => '4', 'ref' => NULL, 'rows' => 10, 'extra' => 'Using where', ) ]
[ SQL ] SHOW COLUMNS FROM `cmf_goods_category` [ RunTime:0.000804s ]
[ SQL ] SELECT * FROM `cmf_goods_category` WHERE `is_show` = 1 ORDER BY `list_order` ASC [ RunTime:0.000281s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'cmf_goods_category', 'type' => 'ALL', 'possible_keys' => NULL, 'key' => NULL, 'key_len' => NULL, 'ref' => NULL, 'rows' => 9, 'extra' => 'Using where; Using filesort', ) ]
[ SQL ] SHOW COLUMNS FROM `cmf_goods` [ RunTime:0.000876s ]
[ SQL ] SELECT * FROM `cmf_goods` WHERE `cat_id` = 11 AND `is_show` = 1 ORDER BY `goods_id` DESC LIMIT 11 [ RunTime:0.000791s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'cmf_goods', 'type' => 'ref', 'possible_keys' => 'cat_id', 'key' => 'cat_id', 'key_len' => '4', 'ref' => 'const', 'rows' => 9, 'extra' => 'Using where', ) ]
[ SQL ] SELECT * FROM `cmf_goods` WHERE `cat_id` = 9 AND `is_show` = 1 ORDER BY `goods_id` DESC LIMIT 11 [ RunTime:0.000242s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'cmf_goods', 'type' => 'ref', 'possible_keys' => 'cat_id', 'key' => 'cat_id', 'key_len' => '4', 'ref' => 'const', 'rows' => 1, 'extra' => 'Using where', ) ]
[ SQL ] SELECT * FROM `cmf_goods` WHERE `cat_id` = 7 AND `is_show` = 1 ORDER BY `goods_id` DESC LIMIT 11 [ RunTime:0.000779s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'cmf_goods', 'type' => 'ref', 'possible_keys' => 'cat_id', 'key' => 'cat_id', 'key_len' => '4', 'ref' => 'const', 'rows' => 7, 'extra' => 'Using where', ) ]
[ SQL ] SELECT * FROM `cmf_goods` WHERE `cat_id` = 8 AND `is_show` = 1 ORDER BY `goods_id` DESC LIMIT 11 [ RunTime:0.000416s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'cmf_goods', 'type' => 'ref', 'possible_keys' => 'cat_id', 'key' => 'cat_id', 'key_len' => '4', 'ref' => 'const', 'rows' => 12, 'extra' => 'Using where', ) ]
[ SQL ] SELECT * FROM `cmf_goods` WHERE `cat_id` = 6 AND `is_show` = 1 ORDER BY `goods_id` DESC LIMIT 11 [ RunTime:0.000320s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'cmf_goods', 'type' => 'ref', 'possible_keys' => 'cat_id', 'key' => 'cat_id', 'key_len' => '4', 'ref' => 'const', 'rows' => 1, 'extra' => 'Using where', ) ]
[ SQL ] SELECT * FROM `cmf_goods` WHERE `cat_id` = 4 AND `is_show` = 1 ORDER BY `goods_id` DESC LIMIT 11 [ RunTime:0.000373s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'cmf_goods', 'type' => 'ref', 'possible_keys' => 'cat_id', 'key' => 'cat_id', 'key_len' => '4', 'ref' => 'const', 'rows' => 6, 'extra' => 'Using where', ) ]
[ SQL ] SELECT * FROM `cmf_goods` WHERE `cat_id` = 1 AND `is_show` = 1 ORDER BY `goods_id` DESC LIMIT 11 [ RunTime:0.000457s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'cmf_goods', 'type' => 'ref', 'possible_keys' => 'cat_id', 'key' => 'cat_id', 'key_len' => '4', 'ref' => 'const', 'rows' => 4, 'extra' => 'Using where', ) ]
[ SQL ] SELECT * FROM `cmf_goods` WHERE `cat_id` = 2 AND `is_show` = 1 ORDER BY `goods_id` DESC LIMIT 11 [ RunTime:0.000284s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'cmf_goods', 'type' => 'ref', 'possible_keys' => 'cat_id', 'key' => 'cat_id', 'key_len' => '4', 'ref' => 'const', 'rows' => 1, 'extra' => 'Using where', ) ]
[ SQL ] SELECT * FROM `cmf_goods` WHERE `cat_id` = 3 AND `is_show` = 1 ORDER BY `goods_id` DESC LIMIT 11 [ RunTime:0.000252s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'cmf_goods', 'type' => 'ref', 'possible_keys' => 'cat_id', 'key' => 'cat_id', 'key_len' => '4', 'ref' => 'const', 'rows' => 1, 'extra' => 'Using where', ) ]
[ SQL ] SELECT * FROM `cmf_goods` WHERE `cat_id` = 5 AND `is_show` = 1 ORDER BY `goods_id` DESC LIMIT 11 [ RunTime:0.000422s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'cmf_goods', 'type' => 'ref', 'possible_keys' => 'cat_id', 'key' => 'cat_id', 'key_len' => '4', 'ref' => 'const', 'rows' => 1, 'extra' => 'Using where', ) ]
[ SQL ] SHOW COLUMNS FROM `cmf_notice` [ RunTime:0.000794s ]
[ SQL ] SELECT * FROM `cmf_notice` ORDER BY `id` DESC LIMIT 6 [ RunTime:0.000281s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'cmf_notice', 'type' => 'index', 'possible_keys' => NULL, 'key' => 'PRIMARY', 'key_len' => '4', 'ref' => NULL, 'rows' => 6, 'extra' => NULL, ) ]
[ SQL ] SHOW COLUMNS FROM `cmf_user` [ RunTime:0.000884s ]
[ SQL ] SELECT * FROM `cmf_user` WHERE `user_type` = 2 AND `user_status` = 1 ORDER BY `farm_coin` DESC LIMIT 8 [ RunTime:0.000837s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'cmf_user', 'type' => 'ALL', 'possible_keys' => NULL, 'key' => NULL, 'key_len' => NULL, 'ref' => NULL, 'rows' => 941, 'extra' => 'Using where; Using filesort', ) ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `cmf_project_library` WHERE `user_id` = 5 AND `status` = 2 [ RunTime:0.002241s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'cmf_project_library', 'type' => 'ref', 'possible_keys' => 'user_id', 'key' => 'user_id', 'key_len' => '4', 'ref' => 'const', 'rows' => 1945, 'extra' => 'Using where', ) ]
[ SQL ] SELECT * FROM `cmf_project_library` WHERE `user_id` = 5 AND `status` = 2 ORDER BY `id` DESC LIMIT 3 [ RunTime:0.000311s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'cmf_project_library', 'type' => 'ref', 'possible_keys' => 'user_id', 'key' => 'user_id', 'key_len' => '4', 'ref' => 'const', 'rows' => 1945, 'extra' => 'Using where', ) ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `cmf_project_library` WHERE `user_id` = 6 AND `status` = 2 [ RunTime:0.000887s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'cmf_project_library', 'type' => 'ref', 'possible_keys' => 'user_id', 'key' => 'user_id', 'key_len' => '4', 'ref' => 'const', 'rows' => 660, 'extra' => 'Using where', ) ]
[ SQL ] SELECT * FROM `cmf_project_library` WHERE `user_id` = 6 AND `status` = 2 ORDER BY `id` DESC LIMIT 3 [ RunTime:0.000294s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'cmf_project_library', 'type' => 'ref', 'possible_keys' => 'user_id', 'key' => 'user_id', 'key_len' => '4', 'ref' => 'const', 'rows' => 660, 'extra' => 'Using where', ) ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `cmf_project_library` WHERE `user_id` = 446 AND `status` = 2 [ RunTime:0.000226s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'cmf_project_library', 'type' => 'ref', 'possible_keys' => 'user_id', 'key' => 'user_id', 'key_len' => '4', 'ref' => 'const', 'rows' => 33, 'extra' => 'Using where', ) ]
[ SQL ] SELECT * FROM `cmf_project_library` WHERE `user_id` = 446 AND `status` = 2 ORDER BY `id` DESC LIMIT 3 [ RunTime:0.000292s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'cmf_project_library', 'type' => 'ref', 'possible_keys' => 'user_id', 'key' => 'user_id', 'key_len' => '4', 'ref' => 'const', 'rows' => 33, 'extra' => 'Using where', ) ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `cmf_project_library` WHERE `user_id` = 389 AND `status` = 2 [ RunTime:0.000223s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'cmf_project_library', 'type' => 'ref', 'possible_keys' => 'user_id', 'key' => 'user_id', 'key_len' => '4', 'ref' => 'const', 'rows' => 36, 'extra' => 'Using where', ) ]
[ SQL ] SELECT * FROM `cmf_project_library` WHERE `user_id` = 389 AND `status` = 2 ORDER BY `id` DESC LIMIT 3 [ RunTime:0.000311s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'cmf_project_library', 'type' => 'ref', 'possible_keys' => 'user_id', 'key' => 'user_id', 'key_len' => '4', 'ref' => 'const', 'rows' => 36, 'extra' => 'Using where', ) ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `cmf_project_library` WHERE `user_id` = 444 AND `status` = 2 [ RunTime:0.000217s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'cmf_project_library', 'type' => 'ref', 'possible_keys' => 'user_id', 'key' => 'user_id', 'key_len' => '4', 'ref' => 'const', 'rows' => 31, 'extra' => 'Using where', ) ]
[ SQL ] SELECT * FROM `cmf_project_library` WHERE `user_id` = 444 AND `status` = 2 ORDER BY `id` DESC LIMIT 3 [ RunTime:0.000325s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'cmf_project_library', 'type' => 'ref', 'possible_keys' => 'user_id', 'key' => 'user_id', 'key_len' => '4', 'ref' => 'const', 'rows' => 31, 'extra' => 'Using where', ) ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `cmf_project_library` WHERE `user_id` = 453 AND `status` = 2 [ RunTime:0.000215s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'cmf_project_library', 'type' => 'ref', 'possible_keys' => 'user_id', 'key' => 'user_id', 'key_len' => '4', 'ref' => 'const', 'rows' => 27, 'extra' => 'Using where', ) ]
[ SQL ] SELECT * FROM `cmf_project_library` WHERE `user_id` = 453 AND `status` = 2 ORDER BY `id` DESC LIMIT 3 [ RunTime:0.000318s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'cmf_project_library', 'type' => 'ref', 'possible_keys' => 'user_id', 'key' => 'user_id', 'key_len' => '4', 'ref' => 'const', 'rows' => 27, 'extra' => 'Using where', ) ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `cmf_project_library` WHERE `user_id` = 679 AND `status` = 2 [ RunTime:0.000220s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'cmf_project_library', 'type' => 'ref', 'possible_keys' => 'user_id', 'key' => 'user_id', 'key_len' => '4', 'ref' => 'const', 'rows' => 6, 'extra' => 'Using where', ) ]
[ SQL ] SELECT * FROM `cmf_project_library` WHERE `user_id` = 679 AND `status` = 2 ORDER BY `id` DESC LIMIT 3 [ RunTime:0.000297s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'cmf_project_library', 'type' => 'ref', 'possible_keys' => 'user_id', 'key' => 'user_id', 'key_len' => '4', 'ref' => 'const', 'rows' => 6, 'extra' => 'Using where', ) ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `cmf_project_library` WHERE `user_id` = 185 AND `status` = 2 [ RunTime:0.000305s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'cmf_project_library', 'type' => 'ref', 'possible_keys' => 'user_id', 'key' => 'user_id', 'key_len' => '4', 'ref' => 'const', 'rows' => 101, 'extra' => 'Using where', ) ]
[ SQL ] SELECT * FROM `cmf_project_library` WHERE `user_id` = 185 AND `status` = 2 ORDER BY `id` DESC LIMIT 3 [ RunTime:0.000299s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'cmf_project_library', 'type' => 'ref', 'possible_keys' => 'user_id', 'key' => 'user_id', 'key_len' => '4', 'ref' => 'const', 'rows' => 101, 'extra' => 'Using where', ) ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM ( SELECT count(*) AS think_count FROM `cmf_user` `a` LEFT JOIN `cmf_project_question` `q` ON `q`.`accept_user_id`=a.id and q.status=2 LEFT JOIN `cmf_project_user_cate` `b` ON `b`.`user_id`=`a`.`id` WHERE `is_expert` = 3 AND `user_status` = 1 GROUP BY `a`.`id` ) `_group_count_` [ RunTime:0.001161s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'PRIMARY', 'table' => '<derived2>', 'type' => 'ALL', 'possible_keys' => NULL, 'key' => NULL, 'key_len' => NULL, 'ref' => NULL, 'rows' => 81867, 'extra' => NULL, ) ]
[ SQL ] SELECT a.*,count( distinct q.id) as solve FROM `cmf_user` `a` LEFT JOIN `cmf_project_question` `q` ON `q`.`accept_user_id`=a.id and q.status=2 LEFT JOIN `cmf_project_user_cate` `b` ON `b`.`user_id`=`a`.`id` WHERE `is_expert` = 3 AND `user_status` = 1 GROUP BY `a`.`id` ORDER BY `solve` DESC LIMIT 0,15 [ RunTime:0.004350s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'a', 'type' => 'ALL', 'possible_keys' => 'PRIMARY,user_login,user_nickname', 'key' => NULL, 'key_len' => NULL, 'ref' => NULL, 'rows' => 941, 'extra' => 'Using where; Using temporary; Using filesort', ) ]
[ SQL ] SHOW COLUMNS FROM `cmf_project_user_cate` [ RunTime:0.000669s ]
[ SQL ] SELECT `id`,`cate_one_id`,`cate_two_id`,`cate_three_id` FROM `cmf_project_user_cate` WHERE `user_id` = 6 [ RunTime:0.000248s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'cmf_project_user_cate', 'type' => 'ref', 'possible_keys' => 'user_id', 'key' => 'user_id', 'key_len' => '4', 'ref' => 'const', 'rows' => 2, 'extra' => NULL, ) ]
[ SQL ] SHOW COLUMNS FROM `cmf_portal_category` [ RunTime:0.000679s ]
[ SQL ] SELECT `name` FROM `cmf_portal_category` WHERE `id` = 1 LIMIT 1 [ RunTime:0.000230s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'cmf_portal_category', 'type' => 'const', 'possible_keys' => 'PRIMARY', 'key' => 'PRIMARY', 'key_len' => '8', 'ref' => 'const', 'rows' => 1, 'extra' => NULL, ) ]
[ SQL ] SELECT `name` FROM `cmf_portal_category` WHERE `id` = 193 LIMIT 1 [ RunTime:0.000189s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'cmf_portal_category', 'type' => 'const', 'possible_keys' => 'PRIMARY', 'key' => 'PRIMARY', 'key_len' => '8', 'ref' => 'const', 'rows' => 1, 'extra' => NULL, ) ]
[ SQL ] SELECT `name` FROM `cmf_portal_category` WHERE `id` = 393 LIMIT 1 [ RunTime:0.000156s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'cmf_portal_category', 'type' => 'const', 'possible_keys' => 'PRIMARY', 'key' => 'PRIMARY', 'key_len' => '8', 'ref' => 'const', 'rows' => 1, 'extra' => NULL, ) ]
[ SQL ] SELECT `name` FROM `cmf_portal_category` WHERE `id` = 551 LIMIT 1 [ RunTime:0.000163s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'cmf_portal_category', 'type' => 'const', 'possible_keys' => 'PRIMARY', 'key' => 'PRIMARY', 'key_len' => '8', 'ref' => 'const', 'rows' => 1, 'extra' => NULL, ) ]
[ SQL ] SHOW COLUMNS FROM `cmf_project_question` [ RunTime:0.000704s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `cmf_project_question` `a` WHERE `a`.`status` = 2 AND `a`.`accept_user_id` = 6 [ RunTime:0.000265s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'a', 'type' => 'ALL', 'possible_keys' => NULL, 'key' => NULL, 'key_len' => NULL, 'ref' => NULL, 'rows' => 87, 'extra' => 'Using where', ) ]
[ SQL ] SELECT `id`,`cate_one_id`,`cate_two_id`,`cate_three_id` FROM `cmf_project_user_cate` WHERE `user_id` = 5 [ RunTime:0.000186s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'cmf_project_user_cate', 'type' => 'ref', 'possible_keys' => 'user_id', 'key' => 'user_id', 'key_len' => '4', 'ref' => 'const', 'rows' => 3, 'extra' => NULL, ) ]
[ SQL ] SELECT `name` FROM `cmf_portal_category` WHERE `id` = 1 LIMIT 1 [ RunTime:0.000202s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'cmf_portal_category', 'type' => 'const', 'possible_keys' => 'PRIMARY', 'key' => 'PRIMARY', 'key_len' => '8', 'ref' => 'const', 'rows' => 1, 'extra' => NULL, ) ]
[ SQL ] SELECT `name` FROM `cmf_portal_category` WHERE `id` = 193 LIMIT 1 [ RunTime:0.000150s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'cmf_portal_category', 'type' => 'const', 'possible_keys' => 'PRIMARY', 'key' => 'PRIMARY', 'key_len' => '8', 'ref' => 'const', 'rows' => 1, 'extra' => NULL, ) ]
[ SQL ] SELECT `name` FROM `cmf_portal_category` WHERE `id` = 393 LIMIT 1 [ RunTime:0.000215s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'cmf_portal_category', 'type' => 'const', 'possible_keys' => 'PRIMARY', 'key' => 'PRIMARY', 'key_len' => '8', 'ref' => 'const', 'rows' => 1, 'extra' => NULL, ) ]
[ SQL ] SELECT `name` FROM `cmf_portal_category` WHERE `id` = 551 LIMIT 1 [ RunTime:0.000150s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'cmf_portal_category', 'type' => 'const', 'possible_keys' => 'PRIMARY', 'key' => 'PRIMARY', 'key_len' => '8', 'ref' => 'const', 'rows' => 1, 'extra' => NULL, ) ]
[ SQL ] SELECT `name` FROM `cmf_portal_category` WHERE `id` = 2 LIMIT 1 [ RunTime:0.000167s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'cmf_portal_category', 'type' => 'const', 'possible_keys' => 'PRIMARY', 'key' => 'PRIMARY', 'key_len' => '8', 'ref' => 'const', 'rows' => 1, 'extra' => NULL, ) ]
[ SQL ] SELECT `name` FROM `cmf_portal_category` WHERE `id` = 270 LIMIT 1 [ RunTime:0.000202s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'cmf_portal_category', 'type' => 'const', 'possible_keys' => 'PRIMARY', 'key' => 'PRIMARY', 'key_len' => '8', 'ref' => 'const', 'rows' => 1, 'extra' => NULL, ) ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `cmf_project_question` `a` WHERE `a`.`status` = 2 AND `a`.`accept_user_id` = 5 [ RunTime:0.000210s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'a', 'type' => 'ALL', 'possible_keys' => NULL, 'key' => NULL, 'key_len' => NULL, 'ref' => NULL, 'rows' => 87, 'extra' => 'Using where', ) ]
[ SQL ] SELECT `id`,`cate_one_id`,`cate_two_id`,`cate_three_id` FROM `cmf_project_user_cate` WHERE `user_id` = 19 [ RunTime:0.000198s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'cmf_project_user_cate', 'type' => 'ref', 'possible_keys' => 'user_id', 'key' => 'user_id', 'key_len' => '4', 'ref' => 'const', 'rows' => 3, 'extra' => NULL, ) ]
[ SQL ] SELECT `name` FROM `cmf_portal_category` WHERE `id` = 1 LIMIT 1 [ RunTime:0.000158s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'cmf_portal_category', 'type' => 'const', 'possible_keys' => 'PRIMARY', 'key' => 'PRIMARY', 'key_len' => '8', 'ref' => 'const', 'rows' => 1, 'extra' => NULL, ) ]
[ SQL ] SELECT `name` FROM `cmf_portal_category` WHERE `id` = 193 LIMIT 1 [ RunTime:0.000142s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'cmf_portal_category', 'type' => 'const', 'possible_keys' => 'PRIMARY', 'key' => 'PRIMARY', 'key_len' => '8', 'ref' => 'const', 'rows' => 1, 'extra' => NULL, ) ]
[ SQL ] SELECT `name` FROM `cmf_portal_category` WHERE `id` = 2 LIMIT 1 [ RunTime:0.000190s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'cmf_portal_category', 'type' => 'const', 'possible_keys' => 'PRIMARY', 'key' => 'PRIMARY', 'key_len' => '8', 'ref' => 'const', 'rows' => 1, 'extra' => NULL, ) ]
[ SQL ] SELECT `name` FROM `cmf_portal_category` WHERE `id` = 250 LIMIT 1 [ RunTime:0.000155s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'cmf_portal_category', 'type' => 'const', 'possible_keys' => 'PRIMARY', 'key' => 'PRIMARY', 'key_len' => '8', 'ref' => 'const', 'rows' => 1, 'extra' => NULL, ) ]
[ SQL ] SELECT `name` FROM `cmf_portal_category` WHERE `id` = 393 LIMIT 1 [ RunTime:0.000166s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'cmf_portal_category', 'type' => 'const', 'possible_keys' => 'PRIMARY', 'key' => 'PRIMARY', 'key_len' => '8', 'ref' => 'const', 'rows' => 1, 'extra' => NULL, ) ]
[ SQL ] SELECT `name` FROM `cmf_portal_category` WHERE `id` = 545 LIMIT 1 [ RunTime:0.000142s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'cmf_portal_category', 'type' => 'const', 'possible_keys' => 'PRIMARY', 'key' => 'PRIMARY', 'key_len' => '8', 'ref' => 'const', 'rows' => 1, 'extra' => NULL, ) ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `cmf_project_question` `a` WHERE `a`.`status` = 2 AND `a`.`accept_user_id` = 19 [ RunTime:0.000200s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'a', 'type' => 'ALL', 'possible_keys' => NULL, 'key' => NULL, 'key_len' => NULL, 'ref' => NULL, 'rows' => 87, 'extra' => 'Using where', ) ]
[ SQL ] SELECT `id`,`cate_one_id`,`cate_two_id`,`cate_three_id` FROM `cmf_project_user_cate` WHERE `user_id` = 21 [ RunTime:0.000189s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'cmf_project_user_cate', 'type' => 'ref', 'possible_keys' => 'user_id', 'key' => 'user_id', 'key_len' => '4', 'ref' => 'const', 'rows' => 1, 'extra' => NULL, ) ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `cmf_project_question` `a` WHERE `a`.`status` = 2 AND `a`.`accept_user_id` = 21 [ RunTime:0.000203s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'a', 'type' => 'ALL', 'possible_keys' => NULL, 'key' => NULL, 'key_len' => NULL, 'ref' => NULL, 'rows' => 87, 'extra' => 'Using where', ) ]
[ SQL ] SELECT `id`,`cate_one_id`,`cate_two_id`,`cate_three_id` FROM `cmf_project_user_cate` WHERE `user_id` = 22 [ RunTime:0.000219s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'cmf_project_user_cate', 'type' => 'ref', 'possible_keys' => 'user_id', 'key' => 'user_id', 'key_len' => '4', 'ref' => 'const', 'rows' => 3, 'extra' => NULL, ) ]
[ SQL ] SELECT `name` FROM `cmf_portal_category` WHERE `id` = 397 LIMIT 1 [ RunTime:0.000200s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'cmf_portal_category', 'type' => 'const', 'possible_keys' => 'PRIMARY', 'key' => 'PRIMARY', 'key_len' => '8', 'ref' => 'const', 'rows' => 1, 'extra' => NULL, ) ]
[ SQL ] SELECT `name` FROM `cmf_portal_category` WHERE `id` = 609 LIMIT 1 [ RunTime:0.000189s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'cmf_portal_category', 'type' => 'const', 'possible_keys' => 'PRIMARY', 'key' => 'PRIMARY', 'key_len' => '8', 'ref' => 'const', 'rows' => 1, 'extra' => NULL, ) ]
[ SQL ] SELECT `name` FROM `cmf_portal_category` WHERE `id` = 398 LIMIT 1 [ RunTime:0.000146s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'cmf_portal_category', 'type' => 'const', 'possible_keys' => 'PRIMARY', 'key' => 'PRIMARY', 'key_len' => '8', 'ref' => 'const', 'rows' => 1, 'extra' => NULL, ) ]
[ SQL ] SELECT `name` FROM `cmf_portal_category` WHERE `id` = 631 LIMIT 1 [ RunTime:0.000165s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'cmf_portal_category', 'type' => 'const', 'possible_keys' => 'PRIMARY', 'key' => 'PRIMARY', 'key_len' => '8', 'ref' => 'const', 'rows' => 1, 'extra' => NULL, ) ]
[ SQL ] SELECT `name` FROM `cmf_portal_category` WHERE `id` = 611 LIMIT 1 [ RunTime:0.000152s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'cmf_portal_category', 'type' => 'const', 'possible_keys' => 'PRIMARY', 'key' => 'PRIMARY', 'key_len' => '8', 'ref' => 'const', 'rows' => 1, 'extra' => NULL, ) ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `cmf_project_question` `a` WHERE `a`.`status` = 2 AND `a`.`accept_user_id` = 22 [ RunTime:0.000225s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'a', 'type' => 'ALL', 'possible_keys' => NULL, 'key' => NULL, 'key_len' => NULL, 'ref' => NULL, 'rows' => 87, 'extra' => 'Using where', ) ]
[ SQL ] SELECT `id`,`cate_one_id`,`cate_two_id`,`cate_three_id` FROM `cmf_project_user_cate` WHERE `user_id` = 23 [ RunTime:0.000252s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'cmf_project_user_cate', 'type' => 'ref', 'possible_keys' => 'user_id', 'key' => 'user_id', 'key_len' => '4', 'ref' => 'const', 'rows' => 3, 'extra' => NULL, ) ]
[ SQL ] SELECT `name` FROM `cmf_portal_category` WHERE `id` = 393 LIMIT 1 [ RunTime:0.000169s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'cmf_portal_category', 'type' => 'const', 'possible_keys' => 'PRIMARY', 'key' => 'PRIMARY', 'key_len' => '8', 'ref' => 'const', 'rows' => 1, 'extra' => NULL, ) ]
[ SQL ] SELECT `name` FROM `cmf_portal_category` WHERE `id` = 552 LIMIT 1 [ RunTime:0.000154s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'cmf_portal_category', 'type' => 'const', 'possible_keys' => 'PRIMARY', 'key' => 'PRIMARY', 'key_len' => '8', 'ref' => 'const', 'rows' => 1, 'extra' => NULL, ) ]
[ SQL ] SELECT `name` FROM `cmf_portal_category` WHERE `id` = 398 LIMIT 1 [ RunTime:0.000151s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'cmf_portal_category', 'type' => 'const', 'possible_keys' => 'PRIMARY', 'key' => 'PRIMARY', 'key_len' => '8', 'ref' => 'const', 'rows' => 1, 'extra' => NULL, ) ]
[ SQL ] SELECT `name` FROM `cmf_portal_category` WHERE `id` = 619 LIMIT 1 [ RunTime:0.000147s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'cmf_portal_category', 'type' => 'const', 'possible_keys' => 'PRIMARY', 'key' => 'PRIMARY', 'key_len' => '8', 'ref' => 'const', 'rows' => 1, 'extra' => NULL, ) ]
[ SQL ] SELECT `name` FROM `cmf_portal_category` WHERE `id` = 620 LIMIT 1 [ RunTime:0.000160s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'cmf_portal_category', 'type' => 'const', 'possible_keys' => 'PRIMARY', 'key' => 'PRIMARY', 'key_len' => '8', 'ref' => 'const', 'rows' => 1, 'extra' => NULL, ) ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `cmf_project_question` `a` WHERE `a`.`status` = 2 AND `a`.`accept_user_id` = 23 [ RunTime:0.000321s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'a', 'type' => 'ALL', 'possible_keys' => NULL, 'key' => NULL, 'key_len' => NULL, 'ref' => NULL, 'rows' => 87, 'extra' => 'Using where', ) ]
[ SQL ] SELECT `id`,`cate_one_id`,`cate_two_id`,`cate_three_id` FROM `cmf_project_user_cate` WHERE `user_id` = 27 [ RunTime:0.000252s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'cmf_project_user_cate', 'type' => 'ref', 'possible_keys' => 'user_id', 'key' => 'user_id', 'key_len' => '4', 'ref' => 'const', 'rows' => 3, 'extra' => NULL, ) ]
[ SQL ] SELECT `name` FROM `cmf_portal_category` WHERE `id` = 1 LIMIT 1 [ RunTime:0.000207s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'cmf_portal_category', 'type' => 'const', 'possible_keys' => 'PRIMARY', 'key' => 'PRIMARY', 'key_len' => '8', 'ref' => 'const', 'rows' => 1, 'extra' => NULL, ) ]
[ SQL ] SELECT `name` FROM `cmf_portal_category` WHERE `id` = 183 LIMIT 1 [ RunTime:0.000180s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'cmf_portal_category', 'type' => 'const', 'possible_keys' => 'PRIMARY', 'key' => 'PRIMARY', 'key_len' => '8', 'ref' => 'const', 'rows' => 1, 'extra' => NULL, ) ]
[ SQL ] SELECT `name` FROM `cmf_portal_category` WHERE `id` = 393 LIMIT 1 [ RunTime:0.000179s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'cmf_portal_category', 'type' => 'const', 'possible_keys' => 'PRIMARY', 'key' => 'PRIMARY', 'key_len' => '8', 'ref' => 'const', 'rows' => 1, 'extra' => NULL, ) ]
[ SQL ] SELECT `name` FROM `cmf_portal_category` WHERE `id` = 536 LIMIT 1 [ RunTime:0.000190s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'cmf_portal_category', 'type' => 'const', 'possible_keys' => 'PRIMARY', 'key' => 'PRIMARY', 'key_len' => '8', 'ref' => 'const', 'rows' => 1, 'extra' => NULL, ) ]
[ SQL ] SELECT `name` FROM `cmf_portal_category` WHERE `id` = 394 LIMIT 1 [ RunTime:0.000146s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'cmf_portal_category', 'type' => 'const', 'possible_keys' => 'PRIMARY', 'key' => 'PRIMARY', 'key_len' => '8', 'ref' => 'const', 'rows' => 1, 'extra' => NULL, ) ]
[ SQL ] SELECT `name` FROM `cmf_portal_category` WHERE `id` = 571 LIMIT 1 [ RunTime:0.000184s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'cmf_portal_category', 'type' => 'const', 'possible_keys' => 'PRIMARY', 'key' => 'PRIMARY', 'key_len' => '8', 'ref' => 'const', 'rows' => 1, 'extra' => NULL, ) ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `cmf_project_question` `a` WHERE `a`.`status` = 2 AND `a`.`accept_user_id` = 27 [ RunTime:0.000208s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'a', 'type' => 'ALL', 'possible_keys' => NULL, 'key' => NULL, 'key_len' => NULL, 'ref' => NULL, 'rows' => 87, 'extra' => 'Using where', ) ]
[ SQL ] SELECT `id`,`cate_one_id`,`cate_two_id`,`cate_three_id` FROM `cmf_project_user_cate` WHERE `user_id` = 34 [ RunTime:0.000181s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'cmf_project_user_cate', 'type' => 'ref', 'possible_keys' => 'user_id', 'key' => 'user_id', 'key_len' => '4', 'ref' => 'const', 'rows' => 1, 'extra' => NULL, ) ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `cmf_project_question` `a` WHERE `a`.`status` = 2 AND `a`.`accept_user_id` = 34 [ RunTime:0.000211s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'a', 'type' => 'ALL', 'possible_keys' => NULL, 'key' => NULL, 'key_len' => NULL, 'ref' => NULL, 'rows' => 87, 'extra' => 'Using where', ) ]
[ SQL ] SELECT `id`,`cate_one_id`,`cate_two_id`,`cate_three_id` FROM `cmf_project_user_cate` WHERE `user_id` = 94 [ RunTime:0.000191s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'cmf_project_user_cate', 'type' => 'ref', 'possible_keys' => 'user_id', 'key' => 'user_id', 'key_len' => '4', 'ref' => 'const', 'rows' => 3, 'extra' => NULL, ) ]
[ SQL ] SELECT `name` FROM `cmf_portal_category` WHERE `id` = 1 LIMIT 1 [ RunTime:0.000175s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'cmf_portal_category', 'type' => 'const', 'possible_keys' => 'PRIMARY', 'key' => 'PRIMARY', 'key_len' => '8', 'ref' => 'const', 'rows' => 1, 'extra' => NULL, ) ]
[ SQL ] SELECT `name` FROM `cmf_portal_category` WHERE `id` = 177 LIMIT 1 [ RunTime:0.000197s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'cmf_portal_category', 'type' => 'const', 'possible_keys' => 'PRIMARY', 'key' => 'PRIMARY', 'key_len' => '8', 'ref' => 'const', 'rows' => 1, 'extra' => NULL, ) ]
[ SQL ] SELECT `name` FROM `cmf_portal_category` WHERE `id` = 206 LIMIT 1 [ RunTime:0.000156s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'cmf_portal_category', 'type' => 'const', 'possible_keys' => 'PRIMARY', 'key' => 'PRIMARY', 'key_len' => '8', 'ref' => 'const', 'rows' => 1, 'extra' => NULL, ) ]
[ SQL ] SELECT `name` FROM `cmf_portal_category` WHERE `id` = 207 LIMIT 1 [ RunTime:0.000144s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'cmf_portal_category', 'type' => 'const', 'possible_keys' => 'PRIMARY', 'key' => 'PRIMARY', 'key_len' => '8', 'ref' => 'const', 'rows' => 1, 'extra' => NULL, ) ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `cmf_project_question` `a` WHERE `a`.`status` = 2 AND `a`.`accept_user_id` = 94 [ RunTime:0.000217s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'a', 'type' => 'ALL', 'possible_keys' => NULL, 'key' => NULL, 'key_len' => NULL, 'ref' => NULL, 'rows' => 87, 'extra' => 'Using where', ) ]
[ SQL ] SELECT `id`,`cate_one_id`,`cate_two_id`,`cate_three_id` FROM `cmf_project_user_cate` WHERE `user_id` = 101 [ RunTime:0.000200s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'cmf_project_user_cate', 'type' => 'ref', 'possible_keys' => 'user_id', 'key' => 'user_id', 'key_len' => '4', 'ref' => 'const', 'rows' => 3, 'extra' => NULL, ) ]
[ SQL ] SELECT `name` FROM `cmf_portal_category` WHERE `id` = 3 LIMIT 1 [ RunTime:0.000173s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'cmf_portal_category', 'type' => 'const', 'possible_keys' => 'PRIMARY', 'key' => 'PRIMARY', 'key_len' => '8', 'ref' => 'const', 'rows' => 1, 'extra' => NULL, ) ]
[ SQL ] SELECT `name` FROM `cmf_portal_category` WHERE `id` = 348 LIMIT 1 [ RunTime:0.000148s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'cmf_portal_category', 'type' => 'const', 'possible_keys' => 'PRIMARY', 'key' => 'PRIMARY', 'key_len' => '8', 'ref' => 'const', 'rows' => 1, 'extra' => NULL, ) ]
[ SQL ] SELECT `name` FROM `cmf_portal_category` WHERE `id` = 366 LIMIT 1 [ RunTime:0.000143s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'cmf_portal_category', 'type' => 'const', 'possible_keys' => 'PRIMARY', 'key' => 'PRIMARY', 'key_len' => '8', 'ref' => 'const', 'rows' => 1, 'extra' => NULL, ) ]
[ SQL ] SELECT `name` FROM `cmf_portal_category` WHERE `id` = 393 LIMIT 1 [ RunTime:0.000169s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'cmf_portal_category', 'type' => 'const', 'possible_keys' => 'PRIMARY', 'key' => 'PRIMARY', 'key_len' => '8', 'ref' => 'const', 'rows' => 1, 'extra' => NULL, ) ]
[ SQL ] SELECT `name` FROM `cmf_portal_category` WHERE `id` = 550 LIMIT 1 [ RunTime:0.000144s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'cmf_portal_category', 'type' => 'const', 'possible_keys' => 'PRIMARY', 'key' => 'PRIMARY', 'key_len' => '8', 'ref' => 'const', 'rows' => 1, 'extra' => NULL, ) ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `cmf_project_question` `a` WHERE `a`.`status` = 2 AND `a`.`accept_user_id` = 101 [ RunTime:0.000204s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'a', 'type' => 'ALL', 'possible_keys' => NULL, 'key' => NULL, 'key_len' => NULL, 'ref' => NULL, 'rows' => 87, 'extra' => 'Using where', ) ]
[ SQL ] SELECT `id`,`cate_one_id`,`cate_two_id`,`cate_three_id` FROM `cmf_project_user_cate` WHERE `user_id` = 104 [ RunTime:0.000198s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'cmf_project_user_cate', 'type' => 'ref', 'possible_keys' => 'user_id', 'key' => 'user_id', 'key_len' => '4', 'ref' => 'const', 'rows' => 2, 'extra' => NULL, ) ]
[ SQL ] SELECT `name` FROM `cmf_portal_category` WHERE `id` = 393 LIMIT 1 [ RunTime:0.000150s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'cmf_portal_category', 'type' => 'const', 'possible_keys' => 'PRIMARY', 'key' => 'PRIMARY', 'key_len' => '8', 'ref' => 'const', 'rows' => 1, 'extra' => NULL, ) ]
[ SQL ] SELECT `name` FROM `cmf_portal_category` WHERE `id` = 550 LIMIT 1 [ RunTime:0.000180s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'cmf_portal_category', 'type' => 'const', 'possible_keys' => 'PRIMARY', 'key' => 'PRIMARY', 'key_len' => '8', 'ref' => 'const', 'rows' => 1, 'extra' => NULL, ) ]
[ SQL ] SELECT `name` FROM `cmf_portal_category` WHERE `id` = 3 LIMIT 1 [ RunTime:0.000161s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'cmf_portal_category', 'type' => 'const', 'possible_keys' => 'PRIMARY', 'key' => 'PRIMARY', 'key_len' => '8', 'ref' => 'const', 'rows' => 1, 'extra' => NULL, ) ]
[ SQL ] SELECT `name` FROM `cmf_portal_category` WHERE `id` = 347 LIMIT 1 [ RunTime:0.000155s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'cmf_portal_category', 'type' => 'const', 'possible_keys' => 'PRIMARY', 'key' => 'PRIMARY', 'key_len' => '8', 'ref' => 'const', 'rows' => 1, 'extra' => NULL, ) ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `cmf_project_question` `a` WHERE `a`.`status` = 2 AND `a`.`accept_user_id` = 104 [ RunTime:0.000205s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'a', 'type' => 'ALL', 'possible_keys' => NULL, 'key' => NULL, 'key_len' => NULL, 'ref' => NULL, 'rows' => 87, 'extra' => 'Using where', ) ]
[ SQL ] SELECT `id`,`cate_one_id`,`cate_two_id`,`cate_three_id` FROM `cmf_project_user_cate` WHERE `user_id` = 106 [ RunTime:0.000192s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'cmf_project_user_cate', 'type' => 'ref', 'possible_keys' => 'user_id', 'key' => 'user_id', 'key_len' => '4', 'ref' => 'const', 'rows' => 3, 'extra' => NULL, ) ]
[ SQL ] SELECT `name` FROM `cmf_portal_category` WHERE `id` = 2 LIMIT 1 [ RunTime:0.000175s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'cmf_portal_category', 'type' => 'const', 'possible_keys' => 'PRIMARY', 'key' => 'PRIMARY', 'key_len' => '8', 'ref' => 'const', 'rows' => 1, 'extra' => NULL, ) ]
[ SQL ] SELECT `name` FROM `cmf_portal_category` WHERE `id` = 251 LIMIT 1 [ RunTime:0.000167s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'cmf_portal_category', 'type' => 'const', 'possible_keys' => 'PRIMARY', 'key' => 'PRIMARY', 'key_len' => '8', 'ref' => 'const', 'rows' => 1, 'extra' => NULL, ) ]
[ SQL ] SELECT `name` FROM `cmf_portal_category` WHERE `id` = 320 LIMIT 1 [ RunTime:0.000169s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'cmf_portal_category', 'type' => 'const', 'possible_keys' => 'PRIMARY', 'key' => 'PRIMARY', 'key_len' => '8', 'ref' => 'const', 'rows' => 1, 'extra' => NULL, ) ]
[ SQL ] SELECT `name` FROM `cmf_portal_category` WHERE `id` = 340 LIMIT 1 [ RunTime:0.000151s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'cmf_portal_category', 'type' => 'const', 'possible_keys' => 'PRIMARY', 'key' => 'PRIMARY', 'key_len' => '8', 'ref' => 'const', 'rows' => 1, 'extra' => NULL, ) ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `cmf_project_question` `a` WHERE `a`.`status` = 2 AND `a`.`accept_user_id` = 106 [ RunTime:0.000265s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'a', 'type' => 'ALL', 'possible_keys' => NULL, 'key' => NULL, 'key_len' => NULL, 'ref' => NULL, 'rows' => 87, 'extra' => 'Using where', ) ]
[ SQL ] SELECT `id`,`cate_one_id`,`cate_two_id`,`cate_three_id` FROM `cmf_project_user_cate` WHERE `user_id` = 119 [ RunTime:0.000178s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'cmf_project_user_cate', 'type' => 'ref', 'possible_keys' => 'user_id', 'key' => 'user_id', 'key_len' => '4', 'ref' => 'const', 'rows' => 1, 'extra' => NULL, ) ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `cmf_project_question` `a` WHERE `a`.`status` = 2 AND `a`.`accept_user_id` = 119 [ RunTime:0.000237s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'a', 'type' => 'ALL', 'possible_keys' => NULL, 'key' => NULL, 'key_len' => NULL, 'ref' => NULL, 'rows' => 87, 'extra' => 'Using where', ) ]
[ SQL ] SELECT `id`,`cate_one_id`,`cate_two_id`,`cate_three_id` FROM `cmf_project_user_cate` WHERE `user_id` = 143 [ RunTime:0.000180s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'cmf_project_user_cate', 'type' => 'ref', 'possible_keys' => 'user_id', 'key' => 'user_id', 'key_len' => '4', 'ref' => 'const', 'rows' => 3, 'extra' => NULL, ) ]
[ SQL ] SELECT `name` FROM `cmf_portal_category` WHERE `id` = 2 LIMIT 1 [ RunTime:0.000151s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'cmf_portal_category', 'type' => 'const', 'possible_keys' => 'PRIMARY', 'key' => 'PRIMARY', 'key_len' => '8', 'ref' => 'const', 'rows' => 1, 'extra' => NULL, ) ]
[ SQL ] SELECT `name` FROM `cmf_portal_category` WHERE `id` = 250 LIMIT 1 [ RunTime:0.000170s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'cmf_portal_category', 'type' => 'const', 'possible_keys' => 'PRIMARY', 'key' => 'PRIMARY', 'key_len' => '8', 'ref' => 'const', 'rows' => 1, 'extra' => NULL, ) ]
[ SQL ] SELECT `name` FROM `cmf_portal_category` WHERE `id` = 394 LIMIT 1 [ RunTime:0.000219s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'cmf_portal_category', 'type' => 'const', 'possible_keys' => 'PRIMARY', 'key' => 'PRIMARY', 'key_len' => '8', 'ref' => 'const', 'rows' => 1, 'extra' => NULL, ) ]
[ SQL ] SELECT `name` FROM `cmf_portal_category` WHERE `id` = 576 LIMIT 1 [ RunTime:0.000167s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'cmf_portal_category', 'type' => 'const', 'possible_keys' => 'PRIMARY', 'key' => 'PRIMARY', 'key_len' => '8', 'ref' => 'const', 'rows' => 1, 'extra' => NULL, ) ]
[ SQL ] SELECT `name` FROM `cmf_portal_category` WHERE `id` = 1 LIMIT 1 [ RunTime:0.000176s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'cmf_portal_category', 'type' => 'const', 'possible_keys' => 'PRIMARY', 'key' => 'PRIMARY', 'key_len' => '8', 'ref' => 'const', 'rows' => 1, 'extra' => NULL, ) ]
[ SQL ] SELECT `name` FROM `cmf_portal_category` WHERE `id` = 204 LIMIT 1 [ RunTime:0.000161s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'cmf_portal_category', 'type' => 'const', 'possible_keys' => 'PRIMARY', 'key' => 'PRIMARY', 'key_len' => '8', 'ref' => 'const', 'rows' => 1, 'extra' => NULL, ) ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `cmf_project_question` `a` WHERE `a`.`status` = 2 AND `a`.`accept_user_id` = 143 [ RunTime:0.000243s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'a', 'type' => 'ALL', 'possible_keys' => NULL, 'key' => NULL, 'key_len' => NULL, 'ref' => NULL, 'rows' => 87, 'extra' => 'Using where', ) ]
[ SQL ] SELECT `id`,`cate_one_id`,`cate_two_id`,`cate_three_id` FROM `cmf_project_user_cate` WHERE `user_id` = 159 [ RunTime:0.000180s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'cmf_project_user_cate', 'type' => 'ref', 'possible_keys' => 'user_id', 'key' => 'user_id', 'key_len' => '4', 'ref' => 'const', 'rows' => 3, 'extra' => NULL, ) ]
[ SQL ] SELECT `name` FROM `cmf_portal_category` WHERE `id` = 1 LIMIT 1 [ RunTime:0.000188s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'cmf_portal_category', 'type' => 'const', 'possible_keys' => 'PRIMARY', 'key' => 'PRIMARY', 'key_len' => '8', 'ref' => 'const', 'rows' => 1, 'extra' => NULL, ) ]
[ SQL ] SELECT `name` FROM `cmf_portal_category` WHERE `id` = 230 LIMIT 1 [ RunTime:0.000146s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'cmf_portal_category', 'type' => 'const', 'possible_keys' => 'PRIMARY', 'key' => 'PRIMARY', 'key_len' => '8', 'ref' => 'const', 'rows' => 1, 'extra' => NULL, ) ]
[ SQL ] SELECT `name` FROM `cmf_portal_category` WHERE `id` = 183 LIMIT 1 [ RunTime:0.000180s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'cmf_portal_category', 'type' => 'const', 'possible_keys' => 'PRIMARY', 'key' => 'PRIMARY', 'key_len' => '8', 'ref' => 'const', 'rows' => 1, 'extra' => NULL, ) ]
[ SQL ] SELECT `name` FROM `cmf_portal_category` WHERE `id` = 184 LIMIT 1 [ RunTime:0.000201s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'cmf_portal_category', 'type' => 'const', 'possible_keys' => 'PRIMARY', 'key' => 'PRIMARY', 'key_len' => '8', 'ref' => 'const', 'rows' => 1, 'extra' => NULL, ) ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `cmf_project_question` `a` WHERE `a`.`status` = 2 AND `a`.`accept_user_id` = 159 [ RunTime:0.000207s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'a', 'type' => 'ALL', 'possible_keys' => NULL, 'key' => NULL, 'key_len' => NULL, 'ref' => NULL, 'rows' => 87, 'extra' => 'Using where', ) ]
[ SQL ] SELECT `a`.*,`b`.`name` FROM `cmf_project_question` `a` LEFT JOIN `cmf_portal_category` `b` ON `b`.`id`=`a`.`cate_id` ORDER BY `id` DESC LIMIT 10 [ RunTime:0.000242s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'a', 'type' => 'index', 'possible_keys' => NULL, 'key' => 'PRIMARY', 'key_len' => '4', 'ref' => NULL, 'rows' => 10, 'extra' => NULL, ) ]
[ SQL ] SHOW COLUMNS FROM `cmf_fly_book` [ RunTime:0.000835s ]
[ SQL ] SELECT * FROM `cmf_fly_book` WHERE `status` = 1 ORDER BY `browse` DESC,`list_order` DESC,`id` DESC LIMIT 12 [ RunTime:0.000404s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'cmf_fly_book', 'type' => 'ALL', 'possible_keys' => NULL, 'key' => NULL, 'key_len' => NULL, 'ref' => NULL, 'rows' => 45, 'extra' => 'Using where; Using filesort', ) ]
[ SQL ] SHOW COLUMNS FROM `cmf_fly_book_test` [ RunTime:0.000688s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `cmf_fly_book_test` WHERE `book_id` = 7 AND `status` = 1 [ RunTime:0.001707s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'cmf_fly_book_test', 'type' => 'ALL', 'possible_keys' => NULL, 'key' => NULL, 'key_len' => NULL, 'ref' => NULL, 'rows' => 6276, 'extra' => 'Using where', ) ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `cmf_fly_book_test` WHERE `book_id` = 1 AND `status` = 1 [ RunTime:0.001748s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'cmf_fly_book_test', 'type' => 'ALL', 'possible_keys' => NULL, 'key' => NULL, 'key_len' => NULL, 'ref' => NULL, 'rows' => 6276, 'extra' => 'Using where', ) ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `cmf_fly_book_test` WHERE `book_id` = 17 AND `status` = 1 [ RunTime:0.001685s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'cmf_fly_book_test', 'type' => 'ALL', 'possible_keys' => NULL, 'key' => NULL, 'key_len' => NULL, 'ref' => NULL, 'rows' => 6276, 'extra' => 'Using where', ) ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `cmf_fly_book_test` WHERE `book_id` = 2 AND `status` = 1 [ RunTime:0.001695s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'cmf_fly_book_test', 'type' => 'ALL', 'possible_keys' => NULL, 'key' => NULL, 'key_len' => NULL, 'ref' => NULL, 'rows' => 6276, 'extra' => 'Using where', ) ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `cmf_fly_book_test` WHERE `book_id` = 3 AND `status` = 1 [ RunTime:0.002966s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'cmf_fly_book_test', 'type' => 'ALL', 'possible_keys' => NULL, 'key' => NULL, 'key_len' => NULL, 'ref' => NULL, 'rows' => 6276, 'extra' => 'Using where', ) ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `cmf_fly_book_test` WHERE `book_id` = 14 AND `status` = 1 [ RunTime:0.002953s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'cmf_fly_book_test', 'type' => 'ALL', 'possible_keys' => NULL, 'key' => NULL, 'key_len' => NULL, 'ref' => NULL, 'rows' => 6276, 'extra' => 'Using where', ) ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `cmf_fly_book_test` WHERE `book_id` = 13 AND `status` = 1 [ RunTime:0.002936s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'cmf_fly_book_test', 'type' => 'ALL', 'possible_keys' => NULL, 'key' => NULL, 'key_len' => NULL, 'ref' => NULL, 'rows' => 6276, 'extra' => 'Using where', ) ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `cmf_fly_book_test` WHERE `book_id` = 6 AND `status` = 1 [ RunTime:0.002957s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'cmf_fly_book_test', 'type' => 'ALL', 'possible_keys' => NULL, 'key' => NULL, 'key_len' => NULL, 'ref' => NULL, 'rows' => 6276, 'extra' => 'Using where', ) ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `cmf_fly_book_test` WHERE `book_id` = 19 AND `status` = 1 [ RunTime:0.002221s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'cmf_fly_book_test', 'type' => 'ALL', 'possible_keys' => NULL, 'key' => NULL, 'key_len' => NULL, 'ref' => NULL, 'rows' => 6276, 'extra' => 'Using where', ) ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `cmf_fly_book_test` WHERE `book_id` = 5 AND `status` = 1 [ RunTime:0.002198s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'cmf_fly_book_test', 'type' => 'ALL', 'possible_keys' => NULL, 'key' => NULL, 'key_len' => NULL, 'ref' => NULL, 'rows' => 6276, 'extra' => 'Using where', ) ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `cmf_fly_book_test` WHERE `book_id` = 8 AND `status` = 1 [ RunTime:0.002193s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'cmf_fly_book_test', 'type' => 'ALL', 'possible_keys' => NULL, 'key' => NULL, 'key_len' => NULL, 'ref' => NULL, 'rows' => 6276, 'extra' => 'Using where', ) ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `cmf_fly_book_test` WHERE `book_id` = 32 AND `status` = 1 [ RunTime:0.002395s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'cmf_fly_book_test', 'type' => 'ALL', 'possible_keys' => NULL, 'key' => NULL, 'key_len' => NULL, 'ref' => NULL, 'rows' => 6276, 'extra' => 'Using where', ) ]
[ SQL ] SHOW COLUMNS FROM `cmf_project_partner` [ RunTime:0.000888s ]
[ SQL ] SELECT * FROM `cmf_project_partner` WHERE `status` = 1 ORDER BY `list_order` ASC [ RunTime:0.000357s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'cmf_project_partner', 'type' => 'ALL', 'possible_keys' => NULL, 'key' => NULL, 'key_len' => NULL, 'ref' => NULL, 'rows' => 3, 'extra' => 'Using where; Using filesort', ) ]
[ SQL ] SELECT * FROM `cmf_portal_category` WHERE `status` = 1 AND `delete_time` = 0 AND `parent_id` = 0 ORDER BY `list_order` ASC [ RunTime:0.000810s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'cmf_portal_category', 'type' => 'ALL', 'possible_keys' => NULL, 'key' => NULL, 'key_len' => NULL, 'ref' => NULL, 'rows' => 640, 'extra' => 'Using where; Using filesort', ) ]
[ SQL ] SELECT * FROM `cmf_portal_category` WHERE `status` = 1 AND `delete_time` = 0 AND `parent_id` = 2 ORDER BY `list_order` ASC [ RunTime:0.000806s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'cmf_portal_category', 'type' => 'ALL', 'possible_keys' => NULL, 'key' => NULL, 'key_len' => NULL, 'ref' => NULL, 'rows' => 640, 'extra' => 'Using where; Using filesort', ) ]
[ SQL ] SELECT * FROM `cmf_portal_category` WHERE `status` = 1 AND `delete_time` = 0 AND `parent_id` = 28 ORDER BY `list_order` ASC [ RunTime:0.000682s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'cmf_portal_category', 'type' => 'ALL', 'possible_keys' => NULL, 'key' => NULL, 'key_len' => NULL, 'ref' => NULL, 'rows' => 640, 'extra' => 'Using where; Using filesort', ) ]
[ SQL ] SELECT * FROM `cmf_portal_category` WHERE `status` = 1 AND `delete_time` = 0 AND `parent_id` = 29 ORDER BY `list_order` ASC [ RunTime:0.000686s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'cmf_portal_category', 'type' => 'ALL', 'possible_keys' => NULL, 'key' => NULL, 'key_len' => NULL, 'ref' => NULL, 'rows' => 640, 'extra' => 'Using where; Using filesort', ) ]
[ SQL ] SELECT * FROM `cmf_portal_category` WHERE `status` = 1 AND `delete_time` = 0 AND `parent_id` = 30 ORDER BY `list_order` ASC [ RunTime:0.000734s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'cmf_portal_category', 'type' => 'ALL', 'possible_keys' => NULL, 'key' => NULL, 'key_len' => NULL, 'ref' => NULL, 'rows' => 640, 'extra' => 'Using where; Using filesort', ) ]
[ SQL ] SELECT * FROM `cmf_portal_category` WHERE `status` = 1 AND `delete_time` = 0 AND `parent_id` = 31 ORDER BY `list_order` ASC [ RunTime:0.000871s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'cmf_portal_category', 'type' => 'ALL', 'possible_keys' => NULL, 'key' => NULL, 'key_len' => NULL, 'ref' => NULL, 'rows' => 640, 'extra' => 'Using where; Using filesort', ) ]
[ SQL ] SELECT * FROM `cmf_portal_category` WHERE `status` = 1 AND `delete_time` = 0 AND `parent_id` = 32 ORDER BY `list_order` ASC [ RunTime:0.000716s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'cmf_portal_category', 'type' => 'ALL', 'possible_keys' => NULL, 'key' => NULL, 'key_len' => NULL, 'ref' => NULL, 'rows' => 640, 'extra' => 'Using where; Using filesort', ) ]
[ SQL ] SELECT * FROM `cmf_portal_category` WHERE `status` = 1 AND `delete_time` = 0 AND `parent_id` = 33 ORDER BY `list_order` ASC [ RunTime:0.000734s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'cmf_portal_category', 'type' => 'ALL', 'possible_keys' => NULL, 'key' => NULL, 'key_len' => NULL, 'ref' => NULL, 'rows' => 640, 'extra' => 'Using where; Using filesort', ) ]
[ SQL ] SELECT * FROM `cmf_portal_category` WHERE `status` = 1 AND `delete_time` = 0 AND `parent_id` = 34 ORDER BY `list_order` ASC [ RunTime:0.000826s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'cmf_portal_category', 'type' => 'ALL', 'possible_keys' => NULL, 'key' => NULL, 'key_len' => NULL, 'ref' => NULL, 'rows' => 640, 'extra' => 'Using where; Using filesort', ) ]
[ SQL ] SELECT * FROM `cmf_portal_category` WHERE `status` = 1 AND `delete_time` = 0 AND `parent_id` = 35 ORDER BY `list_order` ASC [ RunTime:0.000723s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'cmf_portal_category', 'type' => 'ALL', 'possible_keys' => NULL, 'key' => NULL, 'key_len' => NULL, 'ref' => NULL, 'rows' => 640, 'extra' => 'Using where; Using filesort', ) ]
[ SQL ] SELECT * FROM `cmf_portal_category` WHERE `status` = 1 AND `delete_time` = 0 AND `parent_id` = 1 ORDER BY `list_order` ASC [ RunTime:0.000635s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'cmf_portal_category', 'type' => 'ALL', 'possible_keys' => NULL, 'key' => NULL, 'key_len' => NULL, 'ref' => NULL, 'rows' => 640, 'extra' => 'Using where; Using filesort', ) ]
[ SQL ] SELECT * FROM `cmf_portal_category` WHERE `status` = 1 AND `delete_time` = 0 AND `parent_id` = 19 ORDER BY `list_order` ASC [ RunTime:0.000499s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'cmf_portal_category', 'type' => 'ALL', 'possible_keys' => NULL, 'key' => NULL, 'key_len' => NULL, 'ref' => NULL, 'rows' => 640, 'extra' => 'Using where; Using filesort', ) ]
[ SQL ] SELECT * FROM `cmf_portal_category` WHERE `status` = 1 AND `delete_time` = 0 AND `parent_id` = 21 ORDER BY `list_order` ASC [ RunTime:0.000539s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'cmf_portal_category', 'type' => 'ALL', 'possible_keys' => NULL, 'key' => NULL, 'key_len' => NULL, 'ref' => NULL, 'rows' => 640, 'extra' => 'Using where; Using filesort', ) ]
[ SQL ] SELECT * FROM `cmf_portal_category` WHERE `status` = 1 AND `delete_time` = 0 AND `parent_id` = 22 ORDER BY `list_order` ASC [ RunTime:0.000515s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'cmf_portal_category', 'type' => 'ALL', 'possible_keys' => NULL, 'key' => NULL, 'key_len' => NULL, 'ref' => NULL, 'rows' => 640, 'extra' => 'Using where; Using filesort', ) ]
[ SQL ] SELECT * FROM `cmf_portal_category` WHERE `status` = 1 AND `delete_time` = 0 AND `parent_id` = 23 ORDER BY `list_order` ASC [ RunTime:0.000497s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'cmf_portal_category', 'type' => 'ALL', 'possible_keys' => NULL, 'key' => NULL, 'key_len' => NULL, 'ref' => NULL, 'rows' => 640, 'extra' => 'Using where; Using filesort', ) ]
[ SQL ] SELECT * FROM `cmf_portal_category` WHERE `status` = 1 AND `delete_time` = 0 AND `parent_id` = 24 ORDER BY `list_order` ASC [ RunTime:0.000519s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'cmf_portal_category', 'type' => 'ALL', 'possible_keys' => NULL, 'key' => NULL, 'key_len' => NULL, 'ref' => NULL, 'rows' => 640, 'extra' => 'Using where; Using filesort', ) ]
[ SQL ] SELECT * FROM `cmf_portal_category` WHERE `status` = 1 AND `delete_time` = 0 AND `parent_id` = 25 ORDER BY `list_order` ASC [ RunTime:0.000526s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'cmf_portal_category', 'type' => 'ALL', 'possible_keys' => NULL, 'key' => NULL, 'key_len' => NULL, 'ref' => NULL, 'rows' => 640, 'extra' => 'Using where; Using filesort', ) ]
[ SQL ] SELECT * FROM `cmf_portal_category` WHERE `status` = 1 AND `delete_time` = 0 AND `parent_id` = 26 ORDER BY `list_order` ASC [ RunTime:0.000519s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'cmf_portal_category', 'type' => 'ALL', 'possible_keys' => NULL, 'key' => NULL, 'key_len' => NULL, 'ref' => NULL, 'rows' => 640, 'extra' => 'Using where; Using filesort', ) ]
[ SQL ] SELECT * FROM `cmf_portal_category` WHERE `status` = 1 AND `delete_time` = 0 AND `parent_id` = 27 ORDER BY `list_order` ASC [ RunTime:0.000507s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'cmf_portal_category', 'type' => 'ALL', 'possible_keys' => NULL, 'key' => NULL, 'key_len' => NULL, 'ref' => NULL, 'rows' => 640, 'extra' => 'Using where; Using filesort', ) ]
[ SQL ] SELECT * FROM `cmf_portal_category` WHERE `status` = 1 AND `delete_time` = 0 AND `parent_id` = 3 ORDER BY `list_order` ASC [ RunTime:0.000496s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'cmf_portal_category', 'type' => 'ALL', 'possible_keys' => NULL, 'key' => NULL, 'key_len' => NULL, 'ref' => NULL, 'rows' => 640, 'extra' => 'Using where; Using filesort', ) ]
[ SQL ] SELECT * FROM `cmf_portal_category` WHERE `status` = 1 AND `delete_time` = 0 AND `parent_id` = 36 ORDER BY `list_order` ASC [ RunTime:0.000551s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'cmf_portal_category', 'type' => 'ALL', 'possible_keys' => NULL, 'key' => NULL, 'key_len' => NULL, 'ref' => NULL, 'rows' => 640, 'extra' => 'Using where; Using filesort', ) ]
[ SQL ] SELECT * FROM `cmf_portal_category` WHERE `status` = 1 AND `delete_time` = 0 AND `parent_id` = 37 ORDER BY `list_order` ASC [ RunTime:0.000541s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'cmf_portal_category', 'type' => 'ALL', 'possible_keys' => NULL, 'key' => NULL, 'key_len' => NULL, 'ref' => NULL, 'rows' => 640, 'extra' => 'Using where; Using filesort', ) ]
[ SQL ] SELECT * FROM `cmf_portal_category` WHERE `status` = 1 AND `delete_time` = 0 AND `parent_id` = 38 ORDER BY `list_order` ASC [ RunTime:0.000533s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'cmf_portal_category', 'type' => 'ALL', 'possible_keys' => NULL, 'key' => NULL, 'key_len' => NULL, 'ref' => NULL, 'rows' => 640, 'extra' => 'Using where; Using filesort', ) ]
[ SQL ] SELECT * FROM `cmf_portal_category` WHERE `status` = 1 AND `delete_time` = 0 AND `parent_id` = 39 ORDER BY `list_order` ASC [ RunTime:0.000500s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'cmf_portal_category', 'type' => 'ALL', 'possible_keys' => NULL, 'key' => NULL, 'key_len' => NULL, 'ref' => NULL, 'rows' => 640, 'extra' => 'Using where; Using filesort', ) ]
[ SQL ] SELECT * FROM `cmf_portal_category` WHERE `status` = 1 AND `delete_time` = 0 AND `parent_id` = 4 ORDER BY `list_order` ASC [ RunTime:0.000509s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'cmf_portal_category', 'type' => 'ALL', 'possible_keys' => NULL, 'key' => NULL, 'key_len' => NULL, 'ref' => NULL, 'rows' => 640, 'extra' => 'Using where; Using filesort', ) ]
[ SQL ] SELECT * FROM `cmf_portal_category` WHERE `status` = 1 AND `delete_time` = 0 AND `parent_id` = 388 ORDER BY `list_order` ASC [ RunTime:0.000506s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'cmf_portal_category', 'type' => 'ALL', 'possible_keys' => NULL, 'key' => NULL, 'key_len' => NULL, 'ref' => NULL, 'rows' => 640, 'extra' => 'Using where; Using filesort', ) ]
[ SQL ] SELECT * FROM `cmf_portal_category` WHERE `status` = 1 AND `delete_time` = 0 AND `parent_id` = 389 ORDER BY `list_order` ASC [ RunTime:0.000547s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'cmf_portal_category', 'type' => 'ALL', 'possible_keys' => NULL, 'key' => NULL, 'key_len' => NULL, 'ref' => NULL, 'rows' => 640, 'extra' => 'Using where; Using filesort', ) ]
[ SQL ] SELECT * FROM `cmf_portal_category` WHERE `status` = 1 AND `delete_time` = 0 AND `parent_id` = 390 ORDER BY `list_order` ASC [ RunTime:0.000516s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'cmf_portal_category', 'type' => 'ALL', 'possible_keys' => NULL, 'key' => NULL, 'key_len' => NULL, 'ref' => NULL, 'rows' => 640, 'extra' => 'Using where; Using filesort', ) ]
[ SQL ] SELECT * FROM `cmf_portal_category` WHERE `status` = 1 AND `delete_time` = 0 AND `parent_id` = 419 ORDER BY `list_order` ASC [ RunTime:0.000489s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'cmf_portal_category', 'type' => 'ALL', 'possible_keys' => NULL, 'key' => NULL, 'key_len' => NULL, 'ref' => NULL, 'rows' => 640, 'extra' => 'Using where; Using filesort', ) ]
[ SQL ] SELECT * FROM `cmf_portal_category` WHERE `status` = 1 AND `delete_time` = 0 AND `parent_id` = 5 ORDER BY `list_order` ASC [ RunTime:0.000621s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'cmf_portal_category', 'type' => 'ALL', 'possible_keys' => NULL, 'key' => NULL, 'key_len' => NULL, 'ref' => NULL, 'rows' => 640, 'extra' => 'Using where; Using filesort', ) ]
[ SQL ] SELECT * FROM `cmf_portal_category` WHERE `status` = 1 AND `delete_time` = 0 AND `parent_id` = 420 ORDER BY `list_order` ASC [ RunTime:0.000546s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'cmf_portal_category', 'type' => 'ALL', 'possible_keys' => NULL, 'key' => NULL, 'key_len' => NULL, 'ref' => NULL, 'rows' => 640, 'extra' => 'Using where; Using filesort', ) ]
[ SQL ] SELECT * FROM `cmf_portal_category` WHERE `status` = 1 AND `delete_time` = 0 AND `parent_id` = 421 ORDER BY `list_order` ASC [ RunTime:0.000528s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'cmf_portal_category', 'type' => 'ALL', 'possible_keys' => NULL, 'key' => NULL, 'key_len' => NULL, 'ref' => NULL, 'rows' => 640, 'extra' => 'Using where; Using filesort', ) ]
[ SQL ] SELECT * FROM `cmf_portal_category` WHERE `status` = 1 AND `delete_time` = 0 AND `parent_id` = 422 ORDER BY `list_order` ASC [ RunTime:0.000536s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'cmf_portal_category', 'type' => 'ALL', 'possible_keys' => NULL, 'key' => NULL, 'key_len' => NULL, 'ref' => NULL, 'rows' => 640, 'extra' => 'Using where; Using filesort', ) ]
[ SQL ] SELECT * FROM `cmf_portal_category` WHERE `status` = 1 AND `delete_time` = 0 AND `parent_id` = 6 ORDER BY `list_order` ASC [ RunTime:0.000505s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'cmf_portal_category', 'type' => 'ALL', 'possible_keys' => NULL, 'key' => NULL, 'key_len' => NULL, 'ref' => NULL, 'rows' => 640, 'extra' => 'Using where; Using filesort', ) ]
[ SQL ] SELECT * FROM `cmf_portal_category` WHERE `status` = 1 AND `delete_time` = 0 AND `parent_id` = 76 ORDER BY `list_order` ASC [ RunTime:0.000540s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'cmf_portal_category', 'type' => 'ALL', 'possible_keys' => NULL, 'key' => NULL, 'key_len' => NULL, 'ref' => NULL, 'rows' => 640, 'extra' => 'Using where; Using filesort', ) ]
[ SQL ] SELECT * FROM `cmf_portal_category` WHERE `status` = 1 AND `delete_time` = 0 AND `parent_id` = 77 ORDER BY `list_order` ASC [ RunTime:0.000511s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'cmf_portal_category', 'type' => 'ALL', 'possible_keys' => NULL, 'key' => NULL, 'key_len' => NULL, 'ref' => NULL, 'rows' => 640, 'extra' => 'Using where; Using filesort', ) ]
[ SQL ] SELECT * FROM `cmf_portal_category` WHERE `status` = 1 AND `delete_time` = 0 AND `parent_id` = 78 ORDER BY `list_order` ASC [ RunTime:0.000499s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'cmf_portal_category', 'type' => 'ALL', 'possible_keys' => NULL, 'key' => NULL, 'key_len' => NULL, 'ref' => NULL, 'rows' => 640, 'extra' => 'Using where; Using filesort', ) ]
[ SQL ] SELECT * FROM `cmf_portal_category` WHERE `status` = 1 AND `delete_time` = 0 AND `parent_id` = 79 ORDER BY `list_order` ASC [ RunTime:0.000514s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'cmf_portal_category', 'type' => 'ALL', 'possible_keys' => NULL, 'key' => NULL, 'key_len' => NULL, 'ref' => NULL, 'rows' => 640, 'extra' => 'Using where; Using filesort', ) ]
[ SQL ] SELECT * FROM `cmf_portal_category` WHERE `status` = 1 AND `delete_time` = 0 AND `parent_id` = 80 ORDER BY `list_order` ASC [ RunTime:0.000497s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'cmf_portal_category', 'type' => 'ALL', 'possible_keys' => NULL, 'key' => NULL, 'key_len' => NULL, 'ref' => NULL, 'rows' => 640, 'extra' => 'Using where; Using filesort', ) ]
[ SQL ] SELECT * FROM `cmf_portal_category` WHERE `status` = 1 AND `delete_time` = 0 AND `parent_id` = 81 ORDER BY `list_order` ASC [ RunTime:0.000494s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'cmf_portal_category', 'type' => 'ALL', 'possible_keys' => NULL, 'key' => NULL, 'key_len' => NULL, 'ref' => NULL, 'rows' => 640, 'extra' => 'Using where; Using filesort', ) ]
[ SQL ] SELECT * FROM `cmf_portal_category` WHERE `status` = 1 AND `delete_time` = 0 AND `parent_id` = 82 ORDER BY `list_order` ASC [ RunTime:0.000494s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'cmf_portal_category', 'type' => 'ALL', 'possible_keys' => NULL, 'key' => NULL, 'key_len' => NULL, 'ref' => NULL, 'rows' => 640, 'extra' => 'Using where; Using filesort', ) ]
[ SQL ] SELECT * FROM `cmf_portal_category` WHERE `status` = 1 AND `delete_time` = 0 AND `parent_id` = 444 ORDER BY `list_order` ASC [ RunTime:0.000491s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'cmf_portal_category', 'type' => 'ALL', 'possible_keys' => NULL, 'key' => NULL, 'key_len' => NULL, 'ref' => NULL, 'rows' => 640, 'extra' => 'Using where; Using filesort', ) ]
[ SQL ] SELECT * FROM `cmf_portal_category` WHERE `status` = 1 AND `delete_time` = 0 AND `parent_id` = 83 ORDER BY `list_order` ASC [ RunTime:0.000478s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'cmf_portal_category', 'type' => 'ALL', 'possible_keys' => NULL, 'key' => NULL, 'key_len' => NULL, 'ref' => NULL, 'rows' => 640, 'extra' => 'Using where; Using filesort', ) ]
[ SQL ] SELECT * FROM `cmf_portal_category` WHERE `status` = 1 AND `delete_time` = 0 AND `parent_id` = 393 ORDER BY `list_order` ASC [ RunTime:0.000480s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'cmf_portal_category', 'type' => 'ALL', 'possible_keys' => NULL, 'key' => NULL, 'key_len' => NULL, 'ref' => NULL, 'rows' => 640, 'extra' => 'Using where; Using filesort', ) ]
[ SQL ] SELECT * FROM `cmf_portal_category` WHERE `status` = 1 AND `delete_time` = 0 AND `parent_id` = 522 ORDER BY `list_order` ASC [ RunTime:0.000494s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'cmf_portal_category', 'type' => 'ALL', 'possible_keys' => NULL, 'key' => NULL, 'key_len' => NULL, 'ref' => NULL, 'rows' => 640, 'extra' => 'Using where; Using filesort', ) ]
[ SQL ] SELECT * FROM `cmf_portal_category` WHERE `status` = 1 AND `delete_time` = 0 AND `parent_id` = 523 ORDER BY `list_order` ASC [ RunTime:0.000505s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'cmf_portal_category', 'type' => 'ALL', 'possible_keys' => NULL, 'key' => NULL, 'key_len' => NULL, 'ref' => NULL, 'rows' => 640, 'extra' => 'Using where; Using filesort', ) ]
[ SQL ] SELECT * FROM `cmf_portal_category` WHERE `status` = 1 AND `delete_time` = 0 AND `parent_id` = 524 ORDER BY `list_order` ASC [ RunTime:0.000563s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'cmf_portal_category', 'type' => 'ALL', 'possible_keys' => NULL, 'key' => NULL, 'key_len' => NULL, 'ref' => NULL, 'rows' => 640, 'extra' => 'Using where; Using filesort', ) ]
[ SQL ] SELECT * FROM `cmf_portal_category` WHERE `status` = 1 AND `delete_time` = 0 AND `parent_id` = 525 ORDER BY `list_order` ASC [ RunTime:0.000496s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'cmf_portal_category', 'type' => 'ALL', 'possible_keys' => NULL, 'key' => NULL, 'key_len' => NULL, 'ref' => NULL, 'rows' => 640, 'extra' => 'Using where; Using filesort', ) ]
[ SQL ] SELECT * FROM `cmf_portal_category` WHERE `status` = 1 AND `delete_time` = 0 AND `parent_id` = 394 ORDER BY `list_order` ASC [ RunTime:0.000697s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'cmf_portal_category', 'type' => 'ALL', 'possible_keys' => NULL, 'key' => NULL, 'key_len' => NULL, 'ref' => NULL, 'rows' => 640, 'extra' => 'Using where; Using filesort', ) ]
[ SQL ] SELECT * FROM `cmf_portal_category` WHERE `status` = 1 AND `delete_time` = 0 AND `parent_id` = 561 ORDER BY `list_order` ASC [ RunTime:0.000567s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'cmf_portal_category', 'type' => 'ALL', 'possible_keys' => NULL, 'key' => NULL, 'key_len' => NULL, 'ref' => NULL, 'rows' => 640, 'extra' => 'Using where; Using filesort', ) ]
[ SQL ] SELECT * FROM `cmf_portal_category` WHERE `status` = 1 AND `delete_time` = 0 AND `parent_id` = 562 ORDER BY `list_order` ASC [ RunTime:0.000512s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'cmf_portal_category', 'type' => 'ALL', 'possible_keys' => NULL, 'key' => NULL, 'key_len' => NULL, 'ref' => NULL, 'rows' => 640, 'extra' => 'Using where; Using filesort', ) ]
[ SQL ] SELECT * FROM `cmf_portal_category` WHERE `status` = 1 AND `delete_time` = 0 AND `parent_id` = 563 ORDER BY `list_order` ASC [ RunTime:0.000508s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'cmf_portal_category', 'type' => 'ALL', 'possible_keys' => NULL, 'key' => NULL, 'key_len' => NULL, 'ref' => NULL, 'rows' => 640, 'extra' => 'Using where; Using filesort', ) ]
[ SQL ] SELECT * FROM `cmf_portal_category` WHERE `status` = 1 AND `delete_time` = 0 AND `parent_id` = 395 ORDER BY `list_order` ASC [ RunTime:0.000496s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'cmf_portal_category', 'type' => 'ALL', 'possible_keys' => NULL, 'key' => NULL, 'key_len' => NULL, 'ref' => NULL, 'rows' => 640, 'extra' => 'Using where; Using filesort', ) ]
[ SQL ] SELECT * FROM `cmf_portal_category` WHERE `status` = 1 AND `delete_time` = 0 AND `parent_id` = 579 ORDER BY `list_order` ASC [ RunTime:0.000485s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'cmf_portal_category', 'type' => 'ALL', 'possible_keys' => NULL, 'key' => NULL, 'key_len' => NULL, 'ref' => NULL, 'rows' => 640, 'extra' => 'Using where; Using filesort', ) ]
[ SQL ] SELECT * FROM `cmf_portal_category` WHERE `status` = 1 AND `delete_time` = 0 AND `parent_id` = 580 ORDER BY `list_order` ASC [ RunTime:0.000500s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'cmf_portal_category', 'type' => 'ALL', 'possible_keys' => NULL, 'key' => NULL, 'key_len' => NULL, 'ref' => NULL, 'rows' => 640, 'extra' => 'Using where; Using filesort', ) ]
[ SQL ] SELECT * FROM `cmf_portal_category` WHERE `status` = 1 AND `delete_time` = 0 AND `parent_id` = 581 ORDER BY `list_order` ASC [ RunTime:0.000466s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'cmf_portal_category', 'type' => 'ALL', 'possible_keys' => NULL, 'key' => NULL, 'key_len' => NULL, 'ref' => NULL, 'rows' => 640, 'extra' => 'Using where; Using filesort', ) ]
[ SQL ] SELECT * FROM `cmf_portal_category` WHERE `status` = 1 AND `delete_time` = 0 AND `parent_id` = 582 ORDER BY `list_order` ASC [ RunTime:0.000463s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'cmf_portal_category', 'type' => 'ALL', 'possible_keys' => NULL, 'key' => NULL, 'key_len' => NULL, 'ref' => NULL, 'rows' => 640, 'extra' => 'Using where; Using filesort', ) ]
[ SQL ] SELECT * FROM `cmf_portal_category` WHERE `status` = 1 AND `delete_time` = 0 AND `parent_id` = 396 ORDER BY `list_order` ASC [ RunTime:0.000488s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'cmf_portal_category', 'type' => 'ALL', 'possible_keys' => NULL, 'key' => NULL, 'key_len' => NULL, 'ref' => NULL, 'rows' => 640, 'extra' => 'Using where; Using filesort', ) ]
[ SQL ] SELECT * FROM `cmf_portal_category` WHERE `status` = 1 AND `delete_time` = 0 AND `parent_id` = 589 ORDER BY `list_order` ASC [ RunTime:0.000499s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'cmf_portal_category', 'type' => 'ALL', 'possible_keys' => NULL, 'key' => NULL, 'key_len' => NULL, 'ref' => NULL, 'rows' => 640, 'extra' => 'Using where; Using filesort', ) ]
[ SQL ] SELECT * FROM `cmf_portal_category` WHERE `status` = 1 AND `delete_time` = 0 AND `parent_id` = 590 ORDER BY `list_order` ASC [ RunTime:0.000508s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'cmf_portal_category', 'type' => 'ALL', 'possible_keys' => NULL, 'key' => NULL, 'key_len' => NULL, 'ref' => NULL, 'rows' => 640, 'extra' => 'Using where; Using filesort', ) ]
[ SQL ] SELECT * FROM `cmf_portal_category` WHERE `status` = 1 AND `delete_time` = 0 AND `parent_id` = 591 ORDER BY `list_order` ASC [ RunTime:0.000510s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'cmf_portal_category', 'type' => 'ALL', 'possible_keys' => NULL, 'key' => NULL, 'key_len' => NULL, 'ref' => NULL, 'rows' => 640, 'extra' => 'Using where; Using filesort', ) ]
[ SQL ] SELECT * FROM `cmf_portal_category` WHERE `status` = 1 AND `delete_time` = 0 AND `parent_id` = 592 ORDER BY `list_order` ASC [ RunTime:0.000533s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'cmf_portal_category', 'type' => 'ALL', 'possible_keys' => NULL, 'key' => NULL, 'key_len' => NULL, 'ref' => NULL, 'rows' => 640, 'extra' => 'Using where; Using filesort', ) ]
[ SQL ] SELECT * FROM `cmf_portal_category` WHERE `status` = 1 AND `delete_time` = 0 AND `parent_id` = 397 ORDER BY `list_order` ASC [ RunTime:0.000507s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'cmf_portal_category', 'type' => 'ALL', 'possible_keys' => NULL, 'key' => NULL, 'key_len' => NULL, 'ref' => NULL, 'rows' => 640, 'extra' => 'Using where; Using filesort', ) ]
[ SQL ] SELECT * FROM `cmf_portal_category` WHERE `status` = 1 AND `delete_time` = 0 AND `parent_id` = 601 ORDER BY `list_order` ASC [ RunTime:0.000506s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'cmf_portal_category', 'type' => 'ALL', 'possible_keys' => NULL, 'key' => NULL, 'key_len' => NULL, 'ref' => NULL, 'rows' => 640, 'extra' => 'Using where; Using filesort', ) ]
[ SQL ] SELECT * FROM `cmf_portal_category` WHERE `status` = 1 AND `delete_time` = 0 AND `parent_id` = 602 ORDER BY `list_order` ASC [ RunTime:0.000727s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'cmf_portal_category', 'type' => 'ALL', 'possible_keys' => NULL, 'key' => NULL, 'key_len' => NULL, 'ref' => NULL, 'rows' => 640, 'extra' => 'Using where; Using filesort', ) ]
[ SQL ] SELECT * FROM `cmf_portal_category` WHERE `status` = 1 AND `delete_time` = 0 AND `parent_id` = 603 ORDER BY `list_order` ASC [ RunTime:0.000679s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'cmf_portal_category', 'type' => 'ALL', 'possible_keys' => NULL, 'key' => NULL, 'key_len' => NULL, 'ref' => NULL, 'rows' => 640, 'extra' => 'Using where; Using filesort', ) ]
[ SQL ] SELECT * FROM `cmf_portal_category` WHERE `status` = 1 AND `delete_time` = 0 AND `parent_id` = 604 ORDER BY `list_order` ASC [ RunTime:0.000673s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'cmf_portal_category', 'type' => 'ALL', 'possible_keys' => NULL, 'key' => NULL, 'key_len' => NULL, 'ref' => NULL, 'rows' => 640, 'extra' => 'Using where; Using filesort', ) ]
[ SQL ] SELECT * FROM `cmf_portal_category` WHERE `status` = 1 AND `delete_time` = 0 AND `parent_id` = 616 ORDER BY `list_order` ASC [ RunTime:0.000636s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'cmf_portal_category', 'type' => 'ALL', 'possible_keys' => NULL, 'key' => NULL, 'key_len' => NULL, 'ref' => NULL, 'rows' => 640, 'extra' => 'Using where; Using filesort', ) ]
[ SQL ] SELECT * FROM `cmf_portal_category` WHERE `status` = 1 AND `delete_time` = 0 AND `parent_id` = 398 ORDER BY `list_order` ASC [ RunTime:0.000735s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'cmf_portal_category', 'type' => 'ALL', 'possible_keys' => NULL, 'key' => NULL, 'key_len' => NULL, 'ref' => NULL, 'rows' => 640, 'extra' => 'Using where; Using filesort', ) ]
[ SQL ] SELECT * FROM `cmf_portal_category` WHERE `status` = 1 AND `delete_time` = 0 AND `parent_id` = 617 ORDER BY `list_order` ASC [ RunTime:0.000763s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'cmf_portal_category', 'type' => 'ALL', 'possible_keys' => NULL, 'key' => NULL, 'key_len' => NULL, 'ref' => NULL, 'rows' => 640, 'extra' => 'Using where; Using filesort', ) ]
[ SQL ] SELECT * FROM `cmf_portal_category` WHERE `status` = 1 AND `delete_time` = 0 AND `parent_id` = 618 ORDER BY `list_order` ASC [ RunTime:0.000680s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'cmf_portal_category', 'type' => 'ALL', 'possible_keys' => NULL, 'key' => NULL, 'key_len' => NULL, 'ref' => NULL, 'rows' => 640, 'extra' => 'Using where; Using filesort', ) ]
[ SQL ] SELECT * FROM `cmf_portal_category` WHERE `status` = 1 AND `delete_time` = 0 AND `parent_id` = 399 ORDER BY `list_order` ASC [ RunTime:0.000682s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'cmf_portal_category', 'type' => 'ALL', 'possible_keys' => NULL, 'key' => NULL, 'key_len' => NULL, 'ref' => NULL, 'rows' => 640, 'extra' => 'Using where; Using filesort', ) ]
[ SQL ] SELECT * FROM `cmf_portal_category` WHERE `status` = 1 AND `delete_time` = 0 AND `parent_id` = 632 ORDER BY `list_order` ASC [ RunTime:0.000697s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'cmf_portal_category', 'type' => 'ALL', 'possible_keys' => NULL, 'key' => NULL, 'key_len' => NULL, 'ref' => NULL, 'rows' => 640, 'extra' => 'Using where; Using filesort', ) ]
[ SQL ] SELECT * FROM `cmf_portal_category` WHERE `status` = 1 AND `delete_time` = 0 AND `parent_id` = 633 ORDER BY `list_order` ASC [ RunTime:0.000663s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'cmf_portal_category', 'type' => 'ALL', 'possible_keys' => NULL, 'key' => NULL, 'key_len' => NULL, 'ref' => NULL, 'rows' => 640, 'extra' => 'Using where; Using filesort', ) ]
[ SQL ] SHOW COLUMNS FROM `cmf_slide` [ RunTime:0.000897s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `cmf_slide` WHERE `id` = 1 AND `status` = 1 AND `delete_time` = 0 [ RunTime:0.000250s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'cmf_slide', 'type' => 'const', 'possible_keys' => 'PRIMARY', 'key' => 'PRIMARY', 'key_len' => '4', 'ref' => 'const', 'rows' => 1, 'extra' => NULL, ) ]
[ SQL ] SHOW COLUMNS FROM `cmf_slide_item` [ RunTime:0.000811s ]
[ SQL ] SELECT * FROM `cmf_slide_item` WHERE `status` = 1 AND `slide_id` = 1 ORDER BY `list_order` ASC [ RunTime:0.000364s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'cmf_slide_item', 'type' => 'ref', 'possible_keys' => 'slide_id', 'key' => 'slide_id', 'key_len' => '4', 'ref' => 'const', 'rows' => 4, 'extra' => 'Using where; Using filesort', ) ]
[ SQL ] SHOW COLUMNS FROM `cmf_option` [ RunTime:0.000767s ]
[ SQL ] SELECT `option_value` FROM `cmf_option` WHERE `option_name` = 'storage' LIMIT 1 [ RunTime:0.000405s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => NULL, 'type' => NULL, 'possible_keys' => NULL, 'key' => NULL, 'key_len' => NULL, 'ref' => NULL, 'rows' => NULL, 'extra' => 'Impossible WHERE noticed after reading const tables', ) ]
[ SQL ] SHOW COLUMNS FROM `cmf_link` [ RunTime:0.000848s ]
[ SQL ] SELECT * FROM `cmf_link` WHERE `status` = 1 ORDER BY `list_order` ASC [ RunTime:0.000326s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'cmf_link', 'type' => 'ALL', 'possible_keys' => 'status', 'key' => NULL, 'key_len' => NULL, 'ref' => NULL, 'rows' => 18, 'extra' => 'Using where; Using filesort', ) ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `cmf_slide` WHERE `id` = 3 AND `status` = 1 AND `delete_time` = 0 [ RunTime:0.000233s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'cmf_slide', 'type' => 'const', 'possible_keys' => 'PRIMARY', 'key' => 'PRIMARY', 'key_len' => '4', 'ref' => 'const', 'rows' => 1, 'extra' => NULL, ) ]
[ SQL ] SELECT * FROM `cmf_slide_item` WHERE `status` = 1 AND `slide_id` = 3 ORDER BY `list_order` ASC [ RunTime:0.000290s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'cmf_slide_item', 'type' => 'ref', 'possible_keys' => 'slide_id', 'key' => 'slide_id', 'key_len' => '4', 'ref' => 'const', 'rows' => 1, 'extra' => 'Using where; Using filesort', ) ]
[ SQL ] SELECT * FROM `cmf_portal_category` WHERE `status` = 1 AND `delete_time` = 0 AND `parent_id` = 0 AND `status` = 1 AND `is_expert` = 1 ORDER BY `list_order` ASC [ RunTime:0.000921s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'cmf_portal_category', 'type' => 'ALL', 'possible_keys' => NULL, 'key' => NULL, 'key_len' => NULL, 'ref' => NULL, 'rows' => 640, 'extra' => 'Using where; Using filesort', ) ]

全部商品分类

登录后查看文档

网站公告

推荐文档查看更多

最新文档查看更多

小沐子

赚得农币：7303

文档数量：1946篇

小德子

赚得农币：4838

文档数量：634篇

@

赚得农币：1599

文档数量：33篇

庆丰年

赚得农币：1331

文档数量：36篇

喆卍

赚得农币：1300

文档数量：31篇

蓁蓁

赚得农币：1197

文档数量：27篇

小农夫

赚得农币：829

文档数量：6篇

七棵树

赚得农币：795

文档数量：101篇

专家答疑 专家申请

小德子

解决问题：26个

小沐子

解决问题：1个

山水蒙

解决问题：1个

桃子李子栗子梨

解决问题：0个

Kevin Wu

解决问题：0个

锦华生态

解决问题：0个

魅力苹果

解决问题：0个

严令

解决问题：0个

郑勇健

解决问题：0个

小点点

解决问题：0个

氮磷钾

解决问题：0个

张晨

解决问题：0个

绿烧小鱼

解决问题：0个

专业植医

解决问题：0个

吉祥草

解决问题：0个

悬赏问答

近期提问查看更多

热门文章查看更多

最新文章查看更多

热门书籍 查看更多

《土壤肥料学》2

中国农业出版社

总题数：154

《植物学》1

中国农业出版社

总题数：215

《作物种子学》

中国农业出版社

推荐文档
查看更多

最新文档
查看更多

专家答疑
专家申请

近期提问
查看更多

热门文章
查看更多

最新文章
查看更多

热门书籍
查看更多