Excel搜索结果 - 时光漫步

基本文件流程错误 SQL 调试

/www/wwwroot/manboo.info/public/index.php ( 0.85 KB )
/www/wwwroot/manboo.info/thinkphp/base.php ( 1.71 KB )
/www/wwwroot/manboo.info/thinkphp/library/think/Loader.php ( 12.70 KB )
/www/wwwroot/manboo.info/vendor/composer/autoload_static.php ( 3.78 KB )
/www/wwwroot/manboo.info/thinkphp/library/think/Error.php ( 4.00 KB )
/www/wwwroot/manboo.info/thinkphp/library/think/Container.php ( 17.20 KB )
/www/wwwroot/manboo.info/thinkphp/library/think/App.php ( 27.58 KB )
/www/wwwroot/manboo.info/thinkphp/library/think/Env.php ( 2.85 KB )
/www/wwwroot/manboo.info/thinkphp/library/think/Config.php ( 9.71 KB )
/www/wwwroot/manboo.info/thinkphp/convention.php ( 11.74 KB )
/www/wwwroot/manboo.info/application/tags.php ( 0.96 KB )
/www/wwwroot/manboo.info/thinkphp/library/think/Hook.php ( 5.58 KB )
/www/wwwroot/manboo.info/application/common.php ( 0.60 KB )
/www/wwwroot/manboo.info/thinkphp/helper.php ( 20.40 KB )
/www/wwwroot/manboo.info/application/provider.php ( 0.62 KB )
/www/wwwroot/manboo.info/config/app.php ( 5.72 KB )
/www/wwwroot/manboo.info/thinkphp/library/think/facade/Env.php ( 1.17 KB )
/www/wwwroot/manboo.info/thinkphp/library/think/Facade.php ( 3.44 KB )
/www/wwwroot/manboo.info/config/cache.php ( 0.95 KB )
/www/wwwroot/manboo.info/config/console.php ( 0.91 KB )
/www/wwwroot/manboo.info/config/cookie.php ( 1.11 KB )
/www/wwwroot/manboo.info/config/database.php ( 2.43 KB )
/www/wwwroot/manboo.info/config/log.php ( 1.16 KB )
/www/wwwroot/manboo.info/config/middleware.php ( 0.85 KB )
/www/wwwroot/manboo.info/config/paginate.php ( 0.15 KB )
/www/wwwroot/manboo.info/config/session.php ( 1.06 KB )
/www/wwwroot/manboo.info/config/template.php ( 1.39 KB )
/www/wwwroot/manboo.info/config/trace.php ( 0.84 KB )
/www/wwwroot/manboo.info/vendor/symfony/polyfill-mbstring/bootstrap.php ( 8.26 KB )
/www/wwwroot/manboo.info/vendor/symfony/polyfill-mbstring/bootstrap80.php ( 9.77 KB )
/www/wwwroot/manboo.info/vendor/ezyang/htmlpurifier/library/HTMLPurifier.composer.php ( 0.10 KB )
/www/wwwroot/manboo.info/vendor/topthink/think-captcha/src/helper.php ( 1.54 KB )
/www/wwwroot/manboo.info/thinkphp/library/think/facade/Route.php ( 3.84 KB )
/www/wwwroot/manboo.info/thinkphp/library/think/Route.php ( 25.84 KB )
/www/wwwroot/manboo.info/thinkphp/library/think/Request.php ( 57.54 KB )
/www/wwwroot/manboo.info/thinkphp/library/think/route/Domain.php ( 7.08 KB )
/www/wwwroot/manboo.info/thinkphp/library/think/route/RuleGroup.php ( 16.45 KB )
/www/wwwroot/manboo.info/thinkphp/library/think/route/Rule.php ( 28.92 KB )
/www/wwwroot/manboo.info/thinkphp/library/think/route/RuleItem.php ( 8.84 KB )
/www/wwwroot/manboo.info/thinkphp/library/think/route/RuleName.php ( 3.92 KB )
/www/wwwroot/manboo.info/thinkphp/library/think/facade/Validate.php ( 4.83 KB )
/www/wwwroot/manboo.info/thinkphp/library/think/Validate.php ( 43.93 KB )
/www/wwwroot/manboo.info/thinkphp/library/think/Db.php ( 7.67 KB )
/www/wwwroot/manboo.info/thinkphp/library/think/Lang.php ( 7.56 KB )
/www/wwwroot/manboo.info/thinkphp/library/think/Log.php ( 8.92 KB )
/www/wwwroot/manboo.info/thinkphp/library/think/log/driver/File.php ( 8.97 KB )
/www/wwwroot/manboo.info/thinkphp/lang/zh-cn.php ( 12.58 KB )
/www/wwwroot/manboo.info/route/route.php ( 1.30 KB )
/www/wwwroot/manboo.info/thinkphp/library/think/route/dispatch/Module.php ( 5.19 KB )
/www/wwwroot/manboo.info/thinkphp/library/think/route/Dispatch.php ( 9.26 KB )
/www/wwwroot/manboo.info/thinkphp/library/think/Middleware.php ( 5.34 KB )
/www/wwwroot/manboo.info/thinkphp/library/think/Cookie.php ( 7.35 KB )
/www/wwwroot/manboo.info/thinkphp/library/think/View.php ( 5.74 KB )
/www/wwwroot/manboo.info/thinkphp/library/think/view/driver/Think.php ( 6.12 KB )
/www/wwwroot/manboo.info/thinkphp/library/think/Template.php ( 47.31 KB )
/www/wwwroot/manboo.info/thinkphp/library/think/template/driver/File.php ( 2.29 KB )
/www/wwwroot/manboo.info/thinkphp/library/think/Session.php ( 14.13 KB )
/www/wwwroot/manboo.info/thinkphp/library/think/Debug.php ( 7.57 KB )
/www/wwwroot/manboo.info/thinkphp/library/think/Cache.php ( 3.27 KB )
/www/wwwroot/manboo.info/thinkphp/library/think/cache/driver/File.php ( 7.99 KB )
/www/wwwroot/manboo.info/thinkphp/library/think/cache/Driver.php ( 8.64 KB )
/www/wwwroot/manboo.info/application/index/controller/Search.php ( 11.45 KB )
/www/wwwroot/manboo.info/application/common/controller/BaseController.php ( 1.37 KB )
/www/wwwroot/manboo.info/thinkphp/library/think/Controller.php ( 7.53 KB )
/www/wwwroot/manboo.info/thinkphp/library/traits/controller/Jump.php ( 4.76 KB )
/www/wwwroot/manboo.info/application/common/service/ConfigService.php ( 0.60 KB )
/www/wwwroot/manboo.info/thinkphp/library/think/facade/Cache.php ( 2.06 KB )
/www/wwwroot/manboo.info/application/common/model/Config.php ( 0.49 KB )
/www/wwwroot/manboo.info/thinkphp/library/think/Model.php ( 28.59 KB )
/www/wwwroot/manboo.info/thinkphp/library/think/model/concern/Attribute.php ( 17.64 KB )
/www/wwwroot/manboo.info/thinkphp/library/think/model/concern/RelationShip.php ( 20.60 KB )
/www/wwwroot/manboo.info/thinkphp/library/think/model/concern/ModelEvent.php ( 6.04 KB )
/www/wwwroot/manboo.info/thinkphp/library/think/model/concern/TimeStamp.php ( 2.58 KB )
/www/wwwroot/manboo.info/thinkphp/library/think/model/concern/Conversion.php ( 7.84 KB )
/www/wwwroot/manboo.info/thinkphp/library/think/db/Connection.php ( 58.93 KB )
/www/wwwroot/manboo.info/thinkphp/library/think/db/connector/Mysql.php ( 6.22 KB )
/www/wwwroot/manboo.info/thinkphp/library/think/db/builder/Mysql.php ( 5.85 KB )
/www/wwwroot/manboo.info/thinkphp/library/think/db/Builder.php ( 36.76 KB )
/www/wwwroot/manboo.info/thinkphp/library/think/db/Query.php ( 105.00 KB )
/www/wwwroot/manboo.info/application/common/paginator/HomePaginator.php ( 5.03 KB )
/www/wwwroot/manboo.info/thinkphp/library/think/Paginator.php ( 9.83 KB )
/www/wwwroot/manboo.info/thinkphp/library/think/Collection.php ( 13.60 KB )
/www/wwwroot/manboo.info/thinkphp/library/think/db/Expression.php ( 1.11 KB )
/www/wwwroot/manboo.info/thinkphp/library/think/Response.php ( 9.68 KB )
/www/wwwroot/manboo.info/thinkphp/library/think/response/View.php ( 2.77 KB )
/www/wwwroot/manboo.info/runtime/temp/1502e1661058d0f848417d949a8e6d44.php ( 26.63 KB )
/www/wwwroot/manboo.info/thinkphp/library/think/facade/Url.php ( 1.13 KB )
/www/wwwroot/manboo.info/thinkphp/library/think/Url.php ( 13.22 KB )
/www/wwwroot/manboo.info/thinkphp/library/think/debug/Html.php ( 4.02 KB )

[ LANG ] /www/wwwroot/manboo.info/thinkphp/lang/zh-cn.php
[ ROUTE ] array ( 'rule' => 'search/<keyword>', 'route' => 'index/Search/index', 'option' => array ( 'merge_rule_regex' => false, 'validate' => array ( 0 => array ( 'keyword' => 'require|regex:/^[\\x{4e00}-\\x{9fa5}a-zA-Z0-9\\s]+$/u', ), 1 => NULL, 2 => array ( ), 3 => false, ), ), 'var' => array ( 'keyword' => 'Excel', ), )
[ HEADER ] array ( 'x-forwarded-proto' => 'https', 'cf-visitor' => '{"scheme":"https"}', 'cf-ipcountry' => 'US', 'cf-connecting-ip' => '216.73.216.60', 'cdn-loop' => 'cloudflare; loops=1', 'user-agent' => 'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; [email protected])', 'accept-encoding' => 'gzip, br', 'accept' => '*/*', 'cf-ray' => 'a0ce6e83ae1fd858-CMH', 'x-forwarded-for' => '216.73.216.60', 'host' => 'manboo.info', 'content-length' => '', 'content-type' => '', )
[ PARAM ] array ( 'page' => '11', 'keyword' => 'Excel', )
[ DB ] INIT mysql
[ DB ] INIT mysql
[ DB ] INIT mysql
[ DB ] INIT mysql
[ DB ] INIT mysql
[ DB ] INIT mysql
[ DB ] INIT mysql
[ DB ] INIT mysql
[ DB ] INIT mysql
[ DB ] INIT mysql
[ DB ] INIT mysql
[ DB ] INIT mysql
[ DB ] INIT mysql
[ DB ] INIT mysql
[ DB ] INIT mysql
[ DB ] INIT mysql
[ DB ] INIT mysql
[ DB ] INIT mysql
[ DB ] INIT mysql
[ DB ] INIT mysql
[ DB ] INIT mysql
[ DB ] INIT mysql
[ DB ] INIT mysql
[ DB ] INIT mysql
[ DB ] INIT mysql
[ DB ] INIT mysql
[ DB ] INIT mysql
[ DB ] INIT mysql
[ DB ] INIT mysql
[ DB ] INIT mysql
[ DB ] INIT mysql
[ DB ] INIT mysql
[ DB ] INIT mysql
[ DB ] INIT mysql
[ DB ] INIT mysql
[ DB ] INIT mysql
[ DB ] INIT mysql
[ DB ] INIT mysql
[ DB ] INIT mysql
[ DB ] INIT mysql
[ DB ] INIT mysql
[ DB ] INIT mysql
[ DB ] INIT mysql
[ DB ] INIT mysql
[ DB ] INIT mysql
[ DB ] INIT mysql
[ DB ] INIT mysql
[ DB ] INIT mysql
[ DB ] INIT mysql
[ DB ] INIT mysql
[ DB ] INIT mysql
[ DB ] INIT mysql
[ DB ] INIT mysql
[ DB ] INIT mysql
[ DB ] INIT mysql
[ DB ] INIT mysql
[ DB ] INIT mysql
[ DB ] INIT mysql
[ DB ] INIT mysql
[ DB ] INIT mysql
[ DB ] INIT mysql
[ DB ] INIT mysql
[ DB ] INIT mysql
[ DB ] INIT mysql
[ DB ] INIT mysql
[ DB ] INIT mysql
[ DB ] INIT mysql
[ DB ] INIT mysql
[ VIEW ] /www/wwwroot/manboo.info/application/index/view/search/list.html [ array ( 0 => 'site_title', 1 => 'site_keywords', 2 => 'site_description', 3 => 'icp_number', 4 => 'contact_info', 5 => 'email_address', 6 => 'wechat_qrcode_url', 7 => 'site_logo_url', 8 => 'footer_copyright', 9 => 'maintenance_mode', 10 => 'hot_keywords', 11 => 'recentResources', 12 => 'cateGroup', 13 => 'keyword', 14 => 'count', 15 => 'list', 16 => 'page', ) ]

[ DB ] CONNECT:[ UseTime:0.001483s ] mysql:host=127.0.0.1;port=3306;dbname=manboo_infoac;charset=utf8mb4
[ SQL ] SHOW COLUMNS FROM `config` [ RunTime:0.001661s ]
[ SQL ] SELECT `value` FROM `config` WHERE `name` = 'maintenance_mode' LIMIT 1 [ RunTime:0.000410s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'config', 'partitions' => NULL, 'type' => 'const', 'possible_keys' => 'name', 'key' => 'name', 'key_len' => '1022', 'ref' => 'const', 'rows' => 1, 'filtered' => 100.0, 'extra' => NULL, ) ]
[ DB ] CONNECT:[ UseTime:0.000833s ] mysql:host=127.0.0.1;port=3306;dbname=manboo_infoac;charset=utf8mb4
[ SQL ] SHOW COLUMNS FROM `resources` [ RunTime:0.001207s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `resources` WHERE `title` LIKE '%Excel%' OR `jd_skuName` LIKE '%Excel%' OR `douban_info` LIKE '%Excel%' [ RunTime:0.064779s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'resources', 'partitions' => NULL, 'type' => 'ALL', 'possible_keys' => NULL, 'key' => NULL, 'key_len' => NULL, 'ref' => NULL, 'rows' => 49978, 'filtered' => 29.7641658782959, 'extra' => 'Using where', ) ]
[ SQL ] SELECT * FROM `resources` WHERE `title` LIKE '%Excel%' OR `jd_skuName` LIKE '%Excel%' OR `douban_info` LIKE '%Excel%' ORDER BY `time` DESC LIMIT 150,15 [ RunTime:0.066524s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'resources', 'partitions' => NULL, 'type' => 'ALL', 'possible_keys' => NULL, 'key' => NULL, 'key_len' => NULL, 'ref' => NULL, 'rows' => 49978, 'filtered' => 29.7641658782959, 'extra' => 'Using where; Using filesort', ) ]
[ DB ] CONNECT:[ UseTime:0.001788s ] mysql:host=127.0.0.1;port=3306;dbname=manboo_infoac;charset=utf8mb4
[ SQL ] SHOW COLUMNS FROM `keywords` [ RunTime:0.000927s ]
[ SQL ] SELECT * FROM `keywords` WHERE `is_audit` = 1 ORDER BY `search_count` DESC LIMIT 30 [ RunTime:0.000601s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'keywords', 'partitions' => NULL, 'type' => 'ALL', 'possible_keys' => NULL, 'key' => NULL, 'key_len' => NULL, 'ref' => NULL, 'rows' => 231, 'filtered' => 10.0, 'extra' => 'Using where; Using filesort', ) ]
[ DB ] CONNECT:[ UseTime:0.000453s ] mysql:host=127.0.0.1;port=3306;dbname=manboo_infoac;charset=utf8mb4
[ SQL ] SELECT * FROM `resources` ORDER BY `id` DESC LIMIT 10 [ RunTime:0.000569s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'resources', 'partitions' => NULL, 'type' => 'index', 'possible_keys' => NULL, 'key' => 'PRIMARY', 'key_len' => '8', 'ref' => NULL, 'rows' => 10, 'filtered' => 100.0, 'extra' => NULL, ) ]
[ DB ] CONNECT:[ UseTime:0.000471s ] mysql:host=127.0.0.1;port=3306;dbname=manboo_infoac;charset=utf8mb4
[ SQL ] SELECT DISTINCT `jd_cate2` FROM `resources` WHERE ( jd_cate2 <> "" ) ORDER BY `jd_cate2` ASC [ RunTime:0.003655s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'resources', 'partitions' => NULL, 'type' => 'range', 'possible_keys' => 'jd_cate2', 'key' => 'jd_cate2', 'key_len' => '403', 'ref' => NULL, 'rows' => 64, 'filtered' => 100.0, 'extra' => 'Using where; Using index for group-by', ) ]
[ DB ] CONNECT:[ UseTime:0.000490s ] mysql:host=127.0.0.1;port=3306;dbname=manboo_infoac;charset=utf8mb4
[ SQL ] SELECT DISTINCT `jd_cate3` FROM `resources` WHERE `jd_cate2` = '中小学教辅' AND ( jd_cate3 <> "" ) ORDER BY `jd_cate3` ASC [ RunTime:0.004484s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'resources', 'partitions' => NULL, 'type' => 'ref', 'possible_keys' => 'jd_cate2,jd_cate3', 'key' => 'jd_cate2', 'key_len' => '403', 'ref' => 'const', 'rows' => 604, 'filtered' => 100.0, 'extra' => 'Using index condition; Using where; Using temporary; Using filesort', ) ]
[ DB ] CONNECT:[ UseTime:0.000755s ] mysql:host=127.0.0.1;port=3306;dbname=manboo_infoac;charset=utf8mb4
[ SQL ] SELECT DISTINCT `jd_cate3` FROM `resources` WHERE `jd_cate2` = '书法' AND ( jd_cate3 <> "" ) ORDER BY `jd_cate3` ASC [ RunTime:0.000561s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'resources', 'partitions' => NULL, 'type' => 'ref', 'possible_keys' => 'jd_cate2,jd_cate3', 'key' => 'jd_cate2', 'key_len' => '403', 'ref' => 'const', 'rows' => 6, 'filtered' => 100.0, 'extra' => 'Using index condition; Using where; Using temporary; Using filesort', ) ]
[ DB ] CONNECT:[ UseTime:0.000414s ] mysql:host=127.0.0.1;port=3306;dbname=manboo_infoac;charset=utf8mb4
[ SQL ] SELECT DISTINCT `jd_cate3` FROM `resources` WHERE `jd_cate2` = '二手书' AND ( jd_cate3 <> "" ) ORDER BY `jd_cate3` ASC [ RunTime:0.000880s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'resources', 'partitions' => NULL, 'type' => 'ref', 'possible_keys' => 'jd_cate2,jd_cate3', 'key' => 'jd_cate2', 'key_len' => '403', 'ref' => 'const', 'rows' => 28, 'filtered' => 100.0, 'extra' => 'Using index condition; Using where; Using temporary; Using filesort', ) ]
[ DB ] CONNECT:[ UseTime:0.001041s ] mysql:host=127.0.0.1;port=3306;dbname=manboo_infoac;charset=utf8mb4
[ SQL ] SELECT DISTINCT `jd_cate3` FROM `resources` WHERE `jd_cate2` = '传记' AND ( jd_cate3 <> "" ) ORDER BY `jd_cate3` ASC [ RunTime:0.000796s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'resources', 'partitions' => NULL, 'type' => 'ref', 'possible_keys' => 'jd_cate2,jd_cate3', 'key' => 'jd_cate2', 'key_len' => '403', 'ref' => 'const', 'rows' => 2, 'filtered' => 100.0, 'extra' => 'Using index condition; Using where; Using temporary; Using filesort', ) ]
[ DB ] CONNECT:[ UseTime:0.003935s ] mysql:host=127.0.0.1;port=3306;dbname=manboo_infoac;charset=utf8mb4
[ SQL ] SELECT DISTINCT `jd_cate3` FROM `resources` WHERE `jd_cate2` = '养生/保健' AND ( jd_cate3 <> "" ) ORDER BY `jd_cate3` ASC [ RunTime:0.000697s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'resources', 'partitions' => NULL, 'type' => 'ref', 'possible_keys' => 'jd_cate2,jd_cate3', 'key' => 'jd_cate2', 'key_len' => '403', 'ref' => 'const', 'rows' => 15, 'filtered' => 100.0, 'extra' => 'Using index condition; Using where; Using temporary; Using filesort', ) ]
[ DB ] CONNECT:[ UseTime:0.002976s ] mysql:host=127.0.0.1;port=3306;dbname=manboo_infoac;charset=utf8mb4
[ SQL ] SELECT DISTINCT `jd_cate3` FROM `resources` WHERE `jd_cate2` = '动漫' AND ( jd_cate3 <> "" ) ORDER BY `jd_cate3` ASC [ RunTime:0.001621s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'resources', 'partitions' => NULL, 'type' => 'ref', 'possible_keys' => 'jd_cate2,jd_cate3', 'key' => 'jd_cate2', 'key_len' => '403', 'ref' => 'const', 'rows' => 98, 'filtered' => 100.0, 'extra' => 'Using index condition; Using where; Using temporary; Using filesort', ) ]
[ DB ] CONNECT:[ UseTime:0.000560s ] mysql:host=127.0.0.1;port=3306;dbname=manboo_infoac;charset=utf8mb4
[ SQL ] SELECT DISTINCT `jd_cate3` FROM `resources` WHERE `jd_cate2` = '励志与成功' AND ( jd_cate3 <> "" ) ORDER BY `jd_cate3` ASC [ RunTime:0.063254s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'resources', 'partitions' => NULL, 'type' => 'ref', 'possible_keys' => 'jd_cate2,jd_cate3', 'key' => 'jd_cate2', 'key_len' => '403', 'ref' => 'const', 'rows' => 10444, 'filtered' => 100.0, 'extra' => 'Using index condition; Using where; Using temporary; Using filesort', ) ]
[ DB ] CONNECT:[ UseTime:0.000465s ] mysql:host=127.0.0.1;port=3306;dbname=manboo_infoac;charset=utf8mb4
[ SQL ] SELECT DISTINCT `jd_cate3` FROM `resources` WHERE `jd_cate2` = '医学' AND ( jd_cate3 <> "" ) ORDER BY `jd_cate3` ASC [ RunTime:0.000437s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'resources', 'partitions' => NULL, 'type' => 'ref', 'possible_keys' => 'jd_cate2,jd_cate3', 'key' => 'jd_cate2', 'key_len' => '403', 'ref' => 'const', 'rows' => 13, 'filtered' => 100.0, 'extra' => 'Using index condition; Using where; Using temporary; Using filesort', ) ]
[ DB ] CONNECT:[ UseTime:0.001033s ] mysql:host=127.0.0.1;port=3306;dbname=manboo_infoac;charset=utf8mb4
[ SQL ] SELECT DISTINCT `jd_cate3` FROM `resources` WHERE `jd_cate2` = '历史' AND ( jd_cate3 <> "" ) ORDER BY `jd_cate3` ASC [ RunTime:0.000517s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'resources', 'partitions' => NULL, 'type' => 'ref', 'possible_keys' => 'jd_cate2,jd_cate3', 'key' => 'jd_cate2', 'key_len' => '403', 'ref' => 'const', 'rows' => 27, 'filtered' => 100.0, 'extra' => 'Using index condition; Using where; Using temporary; Using filesort', ) ]
[ DB ] CONNECT:[ UseTime:0.000292s ] mysql:host=127.0.0.1;port=3306;dbname=manboo_infoac;charset=utf8mb4
[ SQL ] SELECT DISTINCT `jd_cate3` FROM `resources` WHERE `jd_cate2` = '哲学' AND ( jd_cate3 <> "" ) ORDER BY `jd_cate3` ASC [ RunTime:0.000535s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'resources', 'partitions' => NULL, 'type' => 'ref', 'possible_keys' => 'jd_cate2,jd_cate3', 'key' => 'jd_cate2', 'key_len' => '403', 'ref' => 'const', 'rows' => 18, 'filtered' => 100.0, 'extra' => 'Using index condition; Using where; Using temporary; Using filesort', ) ]
[ DB ] CONNECT:[ UseTime:0.000492s ] mysql:host=127.0.0.1;port=3306;dbname=manboo_infoac;charset=utf8mb4
[ SQL ] SELECT DISTINCT `jd_cate3` FROM `resources` WHERE `jd_cate2` = '国学/古籍' AND ( jd_cate3 <> "" ) ORDER BY `jd_cate3` ASC [ RunTime:0.000382s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'resources', 'partitions' => NULL, 'type' => 'ref', 'possible_keys' => 'jd_cate2,jd_cate3', 'key' => 'jd_cate2', 'key_len' => '403', 'ref' => 'const', 'rows' => 4, 'filtered' => 100.0, 'extra' => 'Using index condition; Using where; Using temporary; Using filesort', ) ]
[ DB ] CONNECT:[ UseTime:0.000388s ] mysql:host=127.0.0.1;port=3306;dbname=manboo_infoac;charset=utf8mb4
[ SQL ] SELECT DISTINCT `jd_cate3` FROM `resources` WHERE `jd_cate2` = '外语学习' AND ( jd_cate3 <> "" ) ORDER BY `jd_cate3` ASC [ RunTime:0.001046s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'resources', 'partitions' => NULL, 'type' => 'ref', 'possible_keys' => 'jd_cate2,jd_cate3', 'key' => 'jd_cate2', 'key_len' => '403', 'ref' => 'const', 'rows' => 106, 'filtered' => 100.0, 'extra' => 'Using index condition; Using where; Using temporary; Using filesort', ) ]
[ DB ] CONNECT:[ UseTime:0.000425s ] mysql:host=127.0.0.1;port=3306;dbname=manboo_infoac;charset=utf8mb4
[ SQL ] SELECT DISTINCT `jd_cate3` FROM `resources` WHERE `jd_cate2` = '大中专教材教辅' AND ( jd_cate3 <> "" ) ORDER BY `jd_cate3` ASC [ RunTime:0.001265s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'resources', 'partitions' => NULL, 'type' => 'ref', 'possible_keys' => 'jd_cate2,jd_cate3', 'key' => 'jd_cate2', 'key_len' => '403', 'ref' => 'const', 'rows' => 106, 'filtered' => 100.0, 'extra' => 'Using index condition; Using where; Using temporary; Using filesort', ) ]
[ DB ] CONNECT:[ UseTime:0.000629s ] mysql:host=127.0.0.1;port=3306;dbname=manboo_infoac;charset=utf8mb4
[ SQL ] SELECT DISTINCT `jd_cate3` FROM `resources` WHERE `jd_cate2` = '套装书' AND ( jd_cate3 <> "" ) ORDER BY `jd_cate3` ASC [ RunTime:0.000558s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'resources', 'partitions' => NULL, 'type' => 'ref', 'possible_keys' => 'jd_cate2,jd_cate3', 'key' => 'jd_cate2', 'key_len' => '403', 'ref' => 'const', 'rows' => 5, 'filtered' => 100.0, 'extra' => 'Using index condition; Using where; Using temporary; Using filesort', ) ]
[ DB ] CONNECT:[ UseTime:0.001056s ] mysql:host=127.0.0.1;port=3306;dbname=manboo_infoac;charset=utf8mb4
[ SQL ] SELECT DISTINCT `jd_cate3` FROM `resources` WHERE `jd_cate2` = '婚恋与两性' AND ( jd_cate3 <> "" ) ORDER BY `jd_cate3` ASC [ RunTime:0.000728s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'resources', 'partitions' => NULL, 'type' => 'ref', 'possible_keys' => 'jd_cate2,jd_cate3', 'key' => 'jd_cate2', 'key_len' => '403', 'ref' => 'const', 'rows' => 2, 'filtered' => 100.0, 'extra' => 'Using index condition; Using where; Using temporary; Using filesort', ) ]
[ DB ] CONNECT:[ UseTime:0.000349s ] mysql:host=127.0.0.1;port=3306;dbname=manboo_infoac;charset=utf8mb4
[ SQL ] SELECT DISTINCT `jd_cate3` FROM `resources` WHERE `jd_cate2` = '字典词典/工具书' AND ( jd_cate3 <> "" ) ORDER BY `jd_cate3` ASC [ RunTime:0.000597s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'resources', 'partitions' => NULL, 'type' => 'ref', 'possible_keys' => 'jd_cate2,jd_cate3', 'key' => 'jd_cate2', 'key_len' => '403', 'ref' => 'const', 'rows' => 2, 'filtered' => 100.0, 'extra' => 'Using index condition; Using where; Using temporary; Using filesort', ) ]
[ DB ] CONNECT:[ UseTime:0.004358s ] mysql:host=127.0.0.1;port=3306;dbname=manboo_infoac;charset=utf8mb4
[ SQL ] SELECT DISTINCT `jd_cate3` FROM `resources` WHERE `jd_cate2` = '学习用品' AND ( jd_cate3 <> "" ) ORDER BY `jd_cate3` ASC [ RunTime:0.000597s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'resources', 'partitions' => NULL, 'type' => 'ref', 'possible_keys' => 'jd_cate2,jd_cate3', 'key' => 'jd_cate2', 'key_len' => '403', 'ref' => 'const', 'rows' => 17, 'filtered' => 100.0, 'extra' => 'Using index condition; Using where; Using temporary; Using filesort', ) ]
[ DB ] CONNECT:[ UseTime:0.001694s ] mysql:host=127.0.0.1;port=3306;dbname=manboo_infoac;charset=utf8mb4
[ SQL ] SELECT DISTINCT `jd_cate3` FROM `resources` WHERE `jd_cate2` = '学历考试辅导' AND ( jd_cate3 <> "" ) ORDER BY `jd_cate3` ASC [ RunTime:0.000554s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'resources', 'partitions' => NULL, 'type' => 'ref', 'possible_keys' => 'jd_cate2,jd_cate3', 'key' => 'jd_cate2', 'key_len' => '403', 'ref' => 'const', 'rows' => 20, 'filtered' => 100.0, 'extra' => 'Using index condition; Using where; Using temporary; Using filesort', ) ]
[ DB ] CONNECT:[ UseTime:0.000788s ] mysql:host=127.0.0.1;port=3306;dbname=manboo_infoac;charset=utf8mb4
[ SQL ] SELECT DISTINCT `jd_cate3` FROM `resources` WHERE `jd_cate2` = '家教' AND ( jd_cate3 <> "" ) ORDER BY `jd_cate3` ASC [ RunTime:0.009128s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'resources', 'partitions' => NULL, 'type' => 'ref', 'possible_keys' => 'jd_cate2,jd_cate3', 'key' => 'jd_cate2', 'key_len' => '403', 'ref' => 'const', 'rows' => 1580, 'filtered' => 100.0, 'extra' => 'Using index condition; Using where; Using temporary; Using filesort', ) ]
[ DB ] CONNECT:[ UseTime:0.000900s ] mysql:host=127.0.0.1;port=3306;dbname=manboo_infoac;charset=utf8mb4
[ SQL ] SELECT DISTINCT `jd_cate3` FROM `resources` WHERE `jd_cate2` = '小说' AND ( jd_cate3 <> "" ) ORDER BY `jd_cate3` ASC [ RunTime:0.001027s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'resources', 'partitions' => NULL, 'type' => 'ref', 'possible_keys' => 'jd_cate2,jd_cate3', 'key' => 'jd_cate2', 'key_len' => '403', 'ref' => 'const', 'rows' => 44, 'filtered' => 100.0, 'extra' => 'Using index condition; Using where; Using temporary; Using filesort', ) ]
[ DB ] CONNECT:[ UseTime:0.000592s ] mysql:host=127.0.0.1;port=3306;dbname=manboo_infoac;charset=utf8mb4
[ SQL ] SELECT DISTINCT `jd_cate3` FROM `resources` WHERE `jd_cate2` = '工业技术' AND ( jd_cate3 <> "" ) ORDER BY `jd_cate3` ASC [ RunTime:0.001113s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'resources', 'partitions' => NULL, 'type' => 'ref', 'possible_keys' => 'jd_cate2,jd_cate3', 'key' => 'jd_cate2', 'key_len' => '403', 'ref' => 'const', 'rows' => 13, 'filtered' => 100.0, 'extra' => 'Using index condition; Using where; Using temporary; Using filesort', ) ]
[ DB ] CONNECT:[ UseTime:0.001373s ] mysql:host=127.0.0.1;port=3306;dbname=manboo_infoac;charset=utf8mb4
[ SQL ] SELECT DISTINCT `jd_cate3` FROM `resources` WHERE `jd_cate2` = '建筑' AND ( jd_cate3 <> "" ) ORDER BY `jd_cate3` ASC [ RunTime:0.000832s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'resources', 'partitions' => NULL, 'type' => 'ref', 'possible_keys' => 'jd_cate2,jd_cate3', 'key' => 'jd_cate2', 'key_len' => '403', 'ref' => 'const', 'rows' => 1, 'filtered' => 100.0, 'extra' => 'Using index condition; Using where; Using temporary; Using filesort', ) ]
[ DB ] CONNECT:[ UseTime:0.000311s ] mysql:host=127.0.0.1;port=3306;dbname=manboo_infoac;charset=utf8mb4
[ SQL ] SELECT DISTINCT `jd_cate3` FROM `resources` WHERE `jd_cate2` = '心理学' AND ( jd_cate3 <> "" ) ORDER BY `jd_cate3` ASC [ RunTime:0.001165s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'resources', 'partitions' => NULL, 'type' => 'ref', 'possible_keys' => 'jd_cate2,jd_cate3', 'key' => 'jd_cate2', 'key_len' => '403', 'ref' => 'const', 'rows' => 212, 'filtered' => 100.0, 'extra' => 'Using index condition; Using where; Using temporary; Using filesort', ) ]
[ DB ] CONNECT:[ UseTime:0.000603s ] mysql:host=127.0.0.1;port=3306;dbname=manboo_infoac;charset=utf8mb4
[ SQL ] SELECT DISTINCT `jd_cate3` FROM `resources` WHERE `jd_cate2` = '护理护具' AND ( jd_cate3 <> "" ) ORDER BY `jd_cate3` ASC [ RunTime:0.000673s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'resources', 'partitions' => NULL, 'type' => 'ref', 'possible_keys' => 'jd_cate2,jd_cate3', 'key' => 'jd_cate2', 'key_len' => '403', 'ref' => 'const', 'rows' => 2, 'filtered' => 100.0, 'extra' => 'Using index condition; Using where; Using temporary; Using filesort', ) ]
[ DB ] CONNECT:[ UseTime:0.000510s ] mysql:host=127.0.0.1;port=3306;dbname=manboo_infoac;charset=utf8mb4
[ SQL ] SELECT DISTINCT `jd_cate3` FROM `resources` WHERE `jd_cate2` = '政治/军事' AND ( jd_cate3 <> "" ) ORDER BY `jd_cate3` ASC [ RunTime:0.000658s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'resources', 'partitions' => NULL, 'type' => 'ref', 'possible_keys' => 'jd_cate2,jd_cate3', 'key' => 'jd_cate2', 'key_len' => '403', 'ref' => 'const', 'rows' => 24, 'filtered' => 100.0, 'extra' => 'Using index condition; Using where; Using temporary; Using filesort', ) ]
[ DB ] CONNECT:[ UseTime:0.000364s ] mysql:host=127.0.0.1;port=3306;dbname=manboo_infoac;charset=utf8mb4
[ SQL ] SELECT DISTINCT `jd_cate3` FROM `resources` WHERE `jd_cate2` = '教学/实验用品' AND ( jd_cate3 <> "" ) ORDER BY `jd_cate3` ASC [ RunTime:0.000678s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'resources', 'partitions' => NULL, 'type' => 'ref', 'possible_keys' => 'jd_cate2,jd_cate3', 'key' => 'jd_cate2', 'key_len' => '403', 'ref' => 'const', 'rows' => 19, 'filtered' => 100.0, 'extra' => 'Using index condition; Using where; Using temporary; Using filesort', ) ]
[ DB ] CONNECT:[ UseTime:0.000498s ] mysql:host=127.0.0.1;port=3306;dbname=manboo_infoac;charset=utf8mb4
[ SQL ] SELECT DISTINCT `jd_cate3` FROM `resources` WHERE `jd_cate2` = '文创用品' AND ( jd_cate3 <> "" ) ORDER BY `jd_cate3` ASC [ RunTime:0.000452s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'resources', 'partitions' => NULL, 'type' => 'ref', 'possible_keys' => 'jd_cate2,jd_cate3', 'key' => 'jd_cate2', 'key_len' => '403', 'ref' => 'const', 'rows' => 1, 'filtered' => 100.0, 'extra' => 'Using index condition; Using where; Using temporary; Using filesort', ) ]
[ DB ] CONNECT:[ UseTime:0.001561s ] mysql:host=127.0.0.1;port=3306;dbname=manboo_infoac;charset=utf8mb4
[ SQL ] SELECT DISTINCT `jd_cate3` FROM `resources` WHERE `jd_cate2` = '文化' AND ( jd_cate3 <> "" ) ORDER BY `jd_cate3` ASC [ RunTime:0.001192s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'resources', 'partitions' => NULL, 'type' => 'ref', 'possible_keys' => 'jd_cate2,jd_cate3', 'key' => 'jd_cate2', 'key_len' => '403', 'ref' => 'const', 'rows' => 4, 'filtered' => 100.0, 'extra' => 'Using index condition; Using where; Using temporary; Using filesort', ) ]
[ DB ] CONNECT:[ UseTime:0.000608s ] mysql:host=127.0.0.1;port=3306;dbname=manboo_infoac;charset=utf8mb4
[ SQL ] SELECT DISTINCT `jd_cate3` FROM `resources` WHERE `jd_cate2` = '文化用品' AND ( jd_cate3 <> "" ) ORDER BY `jd_cate3` ASC [ RunTime:0.001117s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'resources', 'partitions' => NULL, 'type' => 'ref', 'possible_keys' => 'jd_cate2,jd_cate3', 'key' => 'jd_cate2', 'key_len' => '403', 'ref' => 'const', 'rows' => 5, 'filtered' => 100.0, 'extra' => 'Using index condition; Using where; Using temporary; Using filesort', ) ]
[ DB ] CONNECT:[ UseTime:0.000734s ] mysql:host=127.0.0.1;port=3306;dbname=manboo_infoac;charset=utf8mb4
[ SQL ] SELECT DISTINCT `jd_cate3` FROM `resources` WHERE `jd_cate2` = '文学' AND ( jd_cate3 <> "" ) ORDER BY `jd_cate3` ASC [ RunTime:0.000578s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'resources', 'partitions' => NULL, 'type' => 'ref', 'possible_keys' => 'jd_cate2,jd_cate3', 'key' => 'jd_cate2', 'key_len' => '403', 'ref' => 'const', 'rows' => 33, 'filtered' => 100.0, 'extra' => 'Using index condition; Using where; Using temporary; Using filesort', ) ]
[ DB ] CONNECT:[ UseTime:0.000607s ] mysql:host=127.0.0.1;port=3306;dbname=manboo_infoac;charset=utf8mb4
[ SQL ] SELECT DISTINCT `jd_cate3` FROM `resources` WHERE `jd_cate2` = '旅游/地图' AND ( jd_cate3 <> "" ) ORDER BY `jd_cate3` ASC [ RunTime:0.000635s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'resources', 'partitions' => NULL, 'type' => 'ref', 'possible_keys' => 'jd_cate2,jd_cate3', 'key' => 'jd_cate2', 'key_len' => '403', 'ref' => 'const', 'rows' => 16, 'filtered' => 100.0, 'extra' => 'Using index condition; Using where; Using temporary; Using filesort', ) ]
[ DB ] CONNECT:[ UseTime:0.000327s ] mysql:host=127.0.0.1;port=3306;dbname=manboo_infoac;charset=utf8mb4
[ SQL ] SELECT DISTINCT `jd_cate3` FROM `resources` WHERE `jd_cate2` = '日文图书' AND ( jd_cate3 <> "" ) ORDER BY `jd_cate3` ASC [ RunTime:0.000714s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'resources', 'partitions' => NULL, 'type' => 'ref', 'possible_keys' => 'jd_cate2,jd_cate3', 'key' => 'jd_cate2', 'key_len' => '403', 'ref' => 'const', 'rows' => 1, 'filtered' => 100.0, 'extra' => 'Using index condition; Using where; Using temporary; Using filesort', ) ]
[ DB ] CONNECT:[ UseTime:0.000829s ] mysql:host=127.0.0.1;port=3306;dbname=manboo_infoac;charset=utf8mb4
[ SQL ] SELECT DISTINCT `jd_cate3` FROM `resources` WHERE `jd_cate2` = '早教/智能玩具' AND ( jd_cate3 <> "" ) ORDER BY `jd_cate3` ASC [ RunTime:0.000601s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'resources', 'partitions' => NULL, 'type' => 'ref', 'possible_keys' => 'jd_cate2,jd_cate3', 'key' => 'jd_cate2', 'key_len' => '403', 'ref' => 'const', 'rows' => 1, 'filtered' => 100.0, 'extra' => 'Using index condition; Using where; Using temporary; Using filesort', ) ]
[ DB ] CONNECT:[ UseTime:0.000458s ] mysql:host=127.0.0.1;port=3306;dbname=manboo_infoac;charset=utf8mb4
[ SQL ] SELECT DISTINCT `jd_cate3` FROM `resources` WHERE `jd_cate2` = '服务产品' AND ( jd_cate3 <> "" ) ORDER BY `jd_cate3` ASC [ RunTime:0.000516s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'resources', 'partitions' => NULL, 'type' => 'ref', 'possible_keys' => 'jd_cate2,jd_cate3', 'key' => 'jd_cate2', 'key_len' => '403', 'ref' => 'const', 'rows' => 2, 'filtered' => 100.0, 'extra' => 'Using index condition; Using where; Using temporary; Using filesort', ) ]
[ DB ] CONNECT:[ UseTime:0.000428s ] mysql:host=127.0.0.1;port=3306;dbname=manboo_infoac;charset=utf8mb4
[ SQL ] SELECT DISTINCT `jd_cate3` FROM `resources` WHERE `jd_cate2` = '本册纸签' AND ( jd_cate3 <> "" ) ORDER BY `jd_cate3` ASC [ RunTime:0.001313s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'resources', 'partitions' => NULL, 'type' => 'ref', 'possible_keys' => 'jd_cate2,jd_cate3', 'key' => 'jd_cate2', 'key_len' => '403', 'ref' => 'const', 'rows' => 162, 'filtered' => 100.0, 'extra' => 'Using index condition; Using where; Using temporary; Using filesort', ) ]
[ DB ] CONNECT:[ UseTime:0.002650s ] mysql:host=127.0.0.1;port=3306;dbname=manboo_infoac;charset=utf8mb4
[ SQL ] SELECT DISTINCT `jd_cate3` FROM `resources` WHERE `jd_cate2` = '杂志/期刊' AND ( jd_cate3 <> "" ) ORDER BY `jd_cate3` ASC [ RunTime:0.000599s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'resources', 'partitions' => NULL, 'type' => 'ref', 'possible_keys' => 'jd_cate2,jd_cate3', 'key' => 'jd_cate2', 'key_len' => '403', 'ref' => 'const', 'rows' => 37, 'filtered' => 100.0, 'extra' => 'Using index condition; Using where; Using temporary; Using filesort', ) ]
[ DB ] CONNECT:[ UseTime:0.000434s ] mysql:host=127.0.0.1;port=3306;dbname=manboo_infoac;charset=utf8mb4
[ SQL ] SELECT DISTINCT `jd_cate3` FROM `resources` WHERE `jd_cate2` = '棋牌麻将' AND ( jd_cate3 <> "" ) ORDER BY `jd_cate3` ASC [ RunTime:0.000767s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'resources', 'partitions' => NULL, 'type' => 'ref', 'possible_keys' => 'jd_cate2,jd_cate3', 'key' => 'jd_cate2', 'key_len' => '403', 'ref' => 'const', 'rows' => 5, 'filtered' => 100.0, 'extra' => 'Using index condition; Using where; Using temporary; Using filesort', ) ]
[ DB ] CONNECT:[ UseTime:0.000594s ] mysql:host=127.0.0.1;port=3306;dbname=manboo_infoac;charset=utf8mb4
[ SQL ] SELECT DISTINCT `jd_cate3` FROM `resources` WHERE `jd_cate2` = '法律' AND ( jd_cate3 <> "" ) ORDER BY `jd_cate3` ASC [ RunTime:0.000565s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'resources', 'partitions' => NULL, 'type' => 'ref', 'possible_keys' => 'jd_cate2,jd_cate3', 'key' => 'jd_cate2', 'key_len' => '403', 'ref' => 'const', 'rows' => 7, 'filtered' => 100.0, 'extra' => 'Using index condition; Using where; Using temporary; Using filesort', ) ]
[ DB ] CONNECT:[ UseTime:0.000743s ] mysql:host=127.0.0.1;port=3306;dbname=manboo_infoac;charset=utf8mb4
[ SQL ] SELECT DISTINCT `jd_cate3` FROM `resources` WHERE `jd_cate2` = '港台图书' AND ( jd_cate3 <> "" ) ORDER BY `jd_cate3` ASC [ RunTime:0.000736s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'resources', 'partitions' => NULL, 'type' => 'ref', 'possible_keys' => 'jd_cate2,jd_cate3', 'key' => 'jd_cate2', 'key_len' => '403', 'ref' => 'const', 'rows' => 9, 'filtered' => 100.0, 'extra' => 'Using index condition; Using where; Using temporary; Using filesort', ) ]
[ DB ] CONNECT:[ UseTime:0.000887s ] mysql:host=127.0.0.1;port=3306;dbname=manboo_infoac;charset=utf8mb4
[ SQL ] SELECT DISTINCT `jd_cate3` FROM `resources` WHERE `jd_cate2` = '电动车配件' AND ( jd_cate3 <> "" ) ORDER BY `jd_cate3` ASC [ RunTime:0.000663s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'resources', 'partitions' => NULL, 'type' => 'ref', 'possible_keys' => 'jd_cate2,jd_cate3', 'key' => 'jd_cate2', 'key_len' => '403', 'ref' => 'const', 'rows' => 1, 'filtered' => 100.0, 'extra' => 'Using index condition; Using where; Using temporary; Using filesort', ) ]
[ DB ] CONNECT:[ UseTime:0.000697s ] mysql:host=127.0.0.1;port=3306;dbname=manboo_infoac;charset=utf8mb4
[ SQL ] SELECT DISTINCT `jd_cate3` FROM `resources` WHERE `jd_cate2` = '电子与通信' AND ( jd_cate3 <> "" ) ORDER BY `jd_cate3` ASC [ RunTime:0.000817s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'resources', 'partitions' => NULL, 'type' => 'ref', 'possible_keys' => 'jd_cate2,jd_cate3', 'key' => 'jd_cate2', 'key_len' => '403', 'ref' => 'const', 'rows' => 7, 'filtered' => 100.0, 'extra' => 'Using index condition; Using where; Using temporary; Using filesort', ) ]
[ DB ] CONNECT:[ UseTime:0.000536s ] mysql:host=127.0.0.1;port=3306;dbname=manboo_infoac;charset=utf8mb4
[ SQL ] SELECT DISTINCT `jd_cate3` FROM `resources` WHERE `jd_cate2` = '白酒' AND ( jd_cate3 <> "" ) ORDER BY `jd_cate3` ASC [ RunTime:0.000705s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'resources', 'partitions' => NULL, 'type' => 'ref', 'possible_keys' => 'jd_cate2,jd_cate3', 'key' => 'jd_cate2', 'key_len' => '403', 'ref' => 'const', 'rows' => 4, 'filtered' => 100.0, 'extra' => 'Using index condition; Using where; Using temporary; Using filesort', ) ]
[ DB ] CONNECT:[ UseTime:0.001315s ] mysql:host=127.0.0.1;port=3306;dbname=manboo_infoac;charset=utf8mb4
[ SQL ] SELECT DISTINCT `jd_cate3` FROM `resources` WHERE `jd_cate2` = '益智玩具' AND ( jd_cate3 <> "" ) ORDER BY `jd_cate3` ASC [ RunTime:0.000773s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'resources', 'partitions' => NULL, 'type' => 'ref', 'possible_keys' => 'jd_cate2,jd_cate3', 'key' => 'jd_cate2', 'key_len' => '403', 'ref' => 'const', 'rows' => 32, 'filtered' => 100.0, 'extra' => 'Using index condition; Using where; Using temporary; Using filesort', ) ]
[ DB ] CONNECT:[ UseTime:0.001714s ] mysql:host=127.0.0.1;port=3306;dbname=manboo_infoac;charset=utf8mb4
[ SQL ] SELECT DISTINCT `jd_cate3` FROM `resources` WHERE `jd_cate2` = '社会科学' AND ( jd_cate3 <> "" ) ORDER BY `jd_cate3` ASC [ RunTime:0.000813s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'resources', 'partitions' => NULL, 'type' => 'ref', 'possible_keys' => 'jd_cate2,jd_cate3', 'key' => 'jd_cate2', 'key_len' => '403', 'ref' => 'const', 'rows' => 57, 'filtered' => 100.0, 'extra' => 'Using index condition; Using where; Using temporary; Using filesort', ) ]
[ DB ] CONNECT:[ UseTime:0.004599s ] mysql:host=127.0.0.1;port=3306;dbname=manboo_infoac;charset=utf8mb4
[ SQL ] SELECT DISTINCT `jd_cate3` FROM `resources` WHERE `jd_cate2` = '科学与自然' AND ( jd_cate3 <> "" ) ORDER BY `jd_cate3` ASC [ RunTime:0.000622s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'resources', 'partitions' => NULL, 'type' => 'ref', 'possible_keys' => 'jd_cate2,jd_cate3', 'key' => 'jd_cate2', 'key_len' => '403', 'ref' => 'const', 'rows' => 14, 'filtered' => 100.0, 'extra' => 'Using index condition; Using where; Using temporary; Using filesort', ) ]
[ DB ] CONNECT:[ UseTime:0.002687s ] mysql:host=127.0.0.1;port=3306;dbname=manboo_infoac;charset=utf8mb4
[ SQL ] SELECT DISTINCT `jd_cate3` FROM `resources` WHERE `jd_cate2` = '科普读物' AND ( jd_cate3 <> "" ) ORDER BY `jd_cate3` ASC [ RunTime:0.000682s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'resources', 'partitions' => NULL, 'type' => 'ref', 'possible_keys' => 'jd_cate2,jd_cate3', 'key' => 'jd_cate2', 'key_len' => '403', 'ref' => 'const', 'rows' => 58, 'filtered' => 100.0, 'extra' => 'Using index condition; Using where; Using temporary; Using filesort', ) ]
[ DB ] CONNECT:[ UseTime:0.000473s ] mysql:host=127.0.0.1;port=3306;dbname=manboo_infoac;charset=utf8mb4
[ SQL ] SELECT DISTINCT `jd_cate3` FROM `resources` WHERE `jd_cate2` = '积木拼插' AND ( jd_cate3 <> "" ) ORDER BY `jd_cate3` ASC [ RunTime:0.000455s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'resources', 'partitions' => NULL, 'type' => 'ref', 'possible_keys' => 'jd_cate2,jd_cate3', 'key' => 'jd_cate2', 'key_len' => '403', 'ref' => 'const', 'rows' => 2, 'filtered' => 100.0, 'extra' => 'Using index condition; Using where; Using temporary; Using filesort', ) ]
[ DB ] CONNECT:[ UseTime:0.000482s ] mysql:host=127.0.0.1;port=3306;dbname=manboo_infoac;charset=utf8mb4
[ SQL ] SELECT DISTINCT `jd_cate3` FROM `resources` WHERE `jd_cate2` = '童书' AND ( jd_cate3 <> "" ) ORDER BY `jd_cate3` ASC [ RunTime:0.067513s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'resources', 'partitions' => NULL, 'type' => 'ref', 'possible_keys' => 'jd_cate2,jd_cate3', 'key' => 'jd_cate2', 'key_len' => '403', 'ref' => 'const', 'rows' => 12756, 'filtered' => 100.0, 'extra' => 'Using index condition; Using where; Using temporary; Using filesort', ) ]
[ DB ] CONNECT:[ UseTime:0.009307s ] mysql:host=127.0.0.1;port=3306;dbname=manboo_infoac;charset=utf8mb4
[ SQL ] SELECT DISTINCT `jd_cate3` FROM `resources` WHERE `jd_cate2` = '管理' AND ( jd_cate3 <> "" ) ORDER BY `jd_cate3` ASC [ RunTime:0.004429s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'resources', 'partitions' => NULL, 'type' => 'ref', 'possible_keys' => 'jd_cate2,jd_cate3', 'key' => 'jd_cate2', 'key_len' => '403', 'ref' => 'const', 'rows' => 92, 'filtered' => 100.0, 'extra' => 'Using index condition; Using where; Using temporary; Using filesort', ) ]
[ DB ] CONNECT:[ UseTime:0.001372s ] mysql:host=127.0.0.1;port=3306;dbname=manboo_infoac;charset=utf8mb4
[ SQL ] SELECT DISTINCT `jd_cate3` FROM `resources` WHERE `jd_cate2` = '经济' AND ( jd_cate3 <> "" ) ORDER BY `jd_cate3` ASC [ RunTime:0.001133s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'resources', 'partitions' => NULL, 'type' => 'ref', 'possible_keys' => 'jd_cate2,jd_cate3', 'key' => 'jd_cate2', 'key_len' => '403', 'ref' => 'const', 'rows' => 99, 'filtered' => 100.0, 'extra' => 'Using index condition; Using where; Using temporary; Using filesort', ) ]
[ DB ] CONNECT:[ UseTime:0.000733s ] mysql:host=127.0.0.1;port=3306;dbname=manboo_infoac;charset=utf8mb4
[ SQL ] SELECT DISTINCT `jd_cate3` FROM `resources` WHERE `jd_cate2` = '绘图计算用品' AND ( jd_cate3 <> "" ) ORDER BY `jd_cate3` ASC [ RunTime:0.000517s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'resources', 'partitions' => NULL, 'type' => 'ref', 'possible_keys' => 'jd_cate2,jd_cate3', 'key' => 'jd_cate2', 'key_len' => '403', 'ref' => 'const', 'rows' => 1, 'filtered' => 100.0, 'extra' => 'Using index condition; Using where; Using temporary; Using filesort', ) ]
[ DB ] CONNECT:[ UseTime:0.000389s ] mysql:host=127.0.0.1;port=3306;dbname=manboo_infoac;charset=utf8mb4
[ SQL ] SELECT DISTINCT `jd_cate3` FROM `resources` WHERE `jd_cate2` = '考试' AND ( jd_cate3 <> "" ) ORDER BY `jd_cate3` ASC [ RunTime:0.032291s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'resources', 'partitions' => NULL, 'type' => 'ref', 'possible_keys' => 'jd_cate2,jd_cate3', 'key' => 'jd_cate2', 'key_len' => '403', 'ref' => 'const', 'rows' => 6042, 'filtered' => 100.0, 'extra' => 'Using index condition; Using where; Using temporary; Using filesort', ) ]
[ DB ] CONNECT:[ UseTime:0.000658s ] mysql:host=127.0.0.1;port=3306;dbname=manboo_infoac;charset=utf8mb4
[ SQL ] SELECT DISTINCT `jd_cate3` FROM `resources` WHERE `jd_cate2` = '艺术' AND ( jd_cate3 <> "" ) ORDER BY `jd_cate3` ASC [ RunTime:0.000666s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'resources', 'partitions' => NULL, 'type' => 'ref', 'possible_keys' => 'jd_cate2,jd_cate3', 'key' => 'jd_cate2', 'key_len' => '403', 'ref' => 'const', 'rows' => 1, 'filtered' => 100.0, 'extra' => 'Using index condition; Using where; Using temporary; Using filesort', ) ]
[ DB ] CONNECT:[ UseTime:0.000386s ] mysql:host=127.0.0.1;port=3306;dbname=manboo_infoac;charset=utf8mb4
[ SQL ] SELECT DISTINCT `jd_cate3` FROM `resources` WHERE `jd_cate2` = '计算机' AND ( jd_cate3 <> "" ) ORDER BY `jd_cate3` ASC [ RunTime:0.000683s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'resources', 'partitions' => NULL, 'type' => 'ref', 'possible_keys' => 'jd_cate2,jd_cate3', 'key' => 'jd_cate2', 'key_len' => '403', 'ref' => 'const', 'rows' => 1, 'filtered' => 100.0, 'extra' => 'Using index condition; Using where; Using temporary; Using filesort', ) ]
[ DB ] CONNECT:[ UseTime:0.001576s ] mysql:host=127.0.0.1;port=3306;dbname=manboo_infoac;charset=utf8mb4
[ SQL ] SELECT DISTINCT `jd_cate3` FROM `resources` WHERE `jd_cate2` = '计算机与互联网' AND ( jd_cate3 <> "" ) ORDER BY `jd_cate3` ASC [ RunTime:0.103971s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'resources', 'partitions' => NULL, 'type' => 'ref', 'possible_keys' => 'jd_cate2,jd_cate3', 'key' => 'jd_cate2', 'key_len' => '403', 'ref' => 'const', 'rows' => 16380, 'filtered' => 100.0, 'extra' => 'Using index condition; Using where; Using temporary; Using filesort', ) ]
[ DB ] CONNECT:[ UseTime:0.000538s ] mysql:host=127.0.0.1;port=3306;dbname=manboo_infoac;charset=utf8mb4
[ SQL ] SELECT DISTINCT `jd_cate3` FROM `resources` WHERE `jd_cate2` = '身体护理' AND ( jd_cate3 <> "" ) ORDER BY `jd_cate3` ASC [ RunTime:0.000738s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'resources', 'partitions' => NULL, 'type' => 'ref', 'possible_keys' => 'jd_cate2,jd_cate3', 'key' => 'jd_cate2', 'key_len' => '403', 'ref' => 'const', 'rows' => 1, 'filtered' => 100.0, 'extra' => 'Using index condition; Using where; Using temporary; Using filesort', ) ]
[ DB ] CONNECT:[ UseTime:0.000986s ] mysql:host=127.0.0.1;port=3306;dbname=manboo_infoac;charset=utf8mb4
[ SQL ] SELECT DISTINCT `jd_cate3` FROM `resources` WHERE `jd_cate2` = '软件' AND ( jd_cate3 <> "" ) ORDER BY `jd_cate3` ASC [ RunTime:0.000682s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'resources', 'partitions' => NULL, 'type' => 'ref', 'possible_keys' => 'jd_cate2,jd_cate3', 'key' => 'jd_cate2', 'key_len' => '403', 'ref' => 'const', 'rows' => 1, 'filtered' => 100.0, 'extra' => 'Using index condition; Using where; Using temporary; Using filesort', ) ]
[ DB ] CONNECT:[ UseTime:0.000809s ] mysql:host=127.0.0.1;port=3306;dbname=manboo_infoac;charset=utf8mb4
[ SQL ] SELECT DISTINCT `jd_cate3` FROM `resources` WHERE `jd_cate2` = '运动/健身' AND ( jd_cate3 <> "" ) ORDER BY `jd_cate3` ASC [ RunTime:0.000864s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'resources', 'partitions' => NULL, 'type' => 'ref', 'possible_keys' => 'jd_cate2,jd_cate3', 'key' => 'jd_cate2', 'key_len' => '403', 'ref' => 'const', 'rows' => 2, 'filtered' => 100.0, 'extra' => 'Using index condition; Using where; Using temporary; Using filesort', ) ]
[ DB ] CONNECT:[ UseTime:0.000325s ] mysql:host=127.0.0.1;port=3306;dbname=manboo_infoac;charset=utf8mb4
[ SQL ] SELECT DISTINCT `jd_cate3` FROM `resources` WHERE `jd_cate2` = '进口原版' AND ( jd_cate3 <> "" ) ORDER BY `jd_cate3` ASC [ RunTime:0.000761s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'resources', 'partitions' => NULL, 'type' => 'ref', 'possible_keys' => 'jd_cate2,jd_cate3', 'key' => 'jd_cate2', 'key_len' => '403', 'ref' => 'const', 'rows' => 10, 'filtered' => 100.0, 'extra' => 'Using index condition; Using where; Using temporary; Using filesort', ) ]
[ DB ] CONNECT:[ UseTime:0.000348s ] mysql:host=127.0.0.1;port=3306;dbname=manboo_infoac;charset=utf8mb4
[ SQL ] SELECT DISTINCT `jd_cate3` FROM `resources` WHERE `jd_cate2` = '金融与投资' AND ( jd_cate3 <> "" ) ORDER BY `jd_cate3` ASC [ RunTime:0.002001s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'resources', 'partitions' => NULL, 'type' => 'ref', 'possible_keys' => 'jd_cate2,jd_cate3', 'key' => 'jd_cate2', 'key_len' => '403', 'ref' => 'const', 'rows' => 661, 'filtered' => 100.0, 'extra' => 'Using index condition; Using where; Using temporary; Using filesort', ) ]
[ DB ] CONNECT:[ UseTime:0.001134s ] mysql:host=127.0.0.1;port=3306;dbname=manboo_infoac;charset=utf8mb4
[ SQL ] SELECT DISTINCT `jd_cate3` FROM `resources` WHERE `jd_cate2` = '青少年素质培养' AND ( jd_cate3 <> "" ) ORDER BY `jd_cate3` ASC [ RunTime:0.000604s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'resources', 'partitions' => NULL, 'type' => 'ref', 'possible_keys' => 'jd_cate2,jd_cate3', 'key' => 'jd_cate2', 'key_len' => '403', 'ref' => 'const', 'rows' => 5, 'filtered' => 100.0, 'extra' => 'Using index condition; Using where; Using temporary; Using filesort', ) ]
[ DB ] CONNECT:[ UseTime:0.000657s ] mysql:host=127.0.0.1;port=3306;dbname=manboo_infoac;charset=utf8mb4
[ SQL ] SELECT DISTINCT `jd_cate3` FROM `resources` WHERE `jd_cate2` = '青春文学' AND ( jd_cate3 <> "" ) ORDER BY `jd_cate3` ASC [ RunTime:0.002271s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'resources', 'partitions' => NULL, 'type' => 'ref', 'possible_keys' => 'jd_cate2,jd_cate3', 'key' => 'jd_cate2', 'key_len' => '403', 'ref' => 'const', 'rows' => 50, 'filtered' => 100.0, 'extra' => 'Using index condition; Using where; Using temporary; Using filesort', ) ]
[ DB ] CONNECT:[ UseTime:0.000503s ] mysql:host=127.0.0.1;port=3306;dbname=manboo_infoac;charset=utf8mb4
[ SQL ] SELECT DISTINCT `jd_cate3` FROM `resources` WHERE `jd_cate2` = '音乐' AND ( jd_cate3 <> "" ) ORDER BY `jd_cate3` ASC [ RunTime:0.000689s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'resources', 'partitions' => NULL, 'type' => 'ref', 'possible_keys' => 'jd_cate2,jd_cate3', 'key' => 'jd_cate2', 'key_len' => '403', 'ref' => 'const', 'rows' => 3, 'filtered' => 100.0, 'extra' => 'Using index condition; Using where; Using temporary; Using filesort', ) ]

时光漫步

Excel数据控的高效分析手册（异步图书出品）

随身查——Excel函数与公式综合应用技巧（异步图书出品）

活用数据+对比Excel轻松学习Python数据分析（京东套装共2册）

Python+Excel/Word/PPT一本通（图灵出品）

职称计算机考试专用辅导教材：24小时零基础过关·Excel 2003中文电子表格一本通（双色版）

全国职称计算机考试讲义真题预测三合一 Excel 2007中文电子表格（2015年-2016年考试专用）

时光漫步

Excel数据控的高效分析手册（异步图书出品）

随身查——Excel函数与公式综合应用技巧（异步图书出品）

活用数据+对比Excel轻松学习Python数据分析（京东套装共2册）

Python+Excel/Word/PPT一本通（图灵出品）

职称计算机考试专用辅导教材：24小时零基础过关·Excel 2003中文电子表格一本通（双色版）

全国职称计算机考试讲义 真题 预测三合一 Excel 2007中文电子表格（2015年-2016年考试专用）

全国职称计算机考试讲义真题预测三合一 Excel 2007中文电子表格（2015年-2016年考试专用）