基于R语言的自动数据收集：网络抓取和文本挖掘实用指南- 电子书下载

基本文件流程错误 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.41 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 ( 12.52 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/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/666e545b83b2d49ed95a4366099a3ea7.php ( 41.88 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' => 'book/<id>', 'route' => 'index/Search/resources', 'option' => array ( 'merge_rule_regex' => false, ), 'var' => array ( 'id' => '48057', ), )
[ 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' => 'a0d314f8ef42962d-CMH', 'x-forwarded-for' => '216.73.216.60', 'host' => 'manboo.info', 'content-length' => '', 'content-type' => '', )
[ PARAM ] array ( 'id' => '48057', )
[ 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
[ DB ] INIT mysql
[ DB ] INIT mysql
[ DB ] INIT mysql
[ VIEW ] /www/wwwroot/manboo.info/application/index/view/search/resource.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 => 'cateGroup', 12 => 'data', 13 => 'relatedResources', 14 => 'relatedResources_cates', 15 => 'recentResources', ) ]

[ DB ] CONNECT:[ UseTime:0.000461s ] mysql:host=127.0.0.1;port=3306;dbname=manboo_infoac;charset=utf8mb4
[ SQL ] SHOW COLUMNS FROM `config` [ RunTime:0.000916s ]
[ SQL ] SELECT `value` FROM `config` WHERE `name` = 'maintenance_mode' LIMIT 1 [ RunTime:0.000514s ]
[ 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.000950s ] mysql:host=127.0.0.1;port=3306;dbname=manboo_infoac;charset=utf8mb4
[ SQL ] SHOW COLUMNS FROM `resources` [ RunTime:0.001074s ]
[ SQL ] SELECT * FROM `resources` WHERE `id` = 48057 LIMIT 1 [ RunTime:0.000960s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'resources', 'partitions' => NULL, 'type' => 'const', 'possible_keys' => 'PRIMARY,id_2,id', 'key' => 'PRIMARY', 'key_len' => '8', 'ref' => 'const', 'rows' => 1, 'filtered' => 100.0, 'extra' => NULL, ) ]
[ DB ] CONNECT:[ UseTime:0.000487s ] mysql:host=127.0.0.1;port=3306;dbname=manboo_infoac;charset=utf8mb4
[ SQL ] SELECT * FROM `resources` WHERE `jd_skuName` LIKE '%%' AND `id` <> 48057 LIMIT 10 [ RunTime:0.003596s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'resources', 'partitions' => NULL, 'type' => 'ALL', 'possible_keys' => 'PRIMARY,id_2,id', 'key' => NULL, 'key_len' => NULL, 'ref' => NULL, 'rows' => 49978, 'filtered' => 11.110000610351562, 'extra' => 'Using where', ) ]
[ DB ] CONNECT:[ UseTime:0.000881s ] mysql:host=127.0.0.1;port=3306;dbname=manboo_infoac;charset=utf8mb4
[ SQL ] SELECT * FROM `resources` WHERE `jd_cate3` = '编程语言与程序设计' AND `id` <> 48057 LIMIT 10 [ RunTime:0.001973s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'resources', 'partitions' => NULL, 'type' => 'ref', 'possible_keys' => 'PRIMARY,id_2,id,jd_cate3', 'key' => 'jd_cate3', 'key_len' => '403', 'ref' => 'const', 'rows' => 10538, 'filtered' => 100.0, 'extra' => 'Using where', ) ]
[ DB ] CONNECT:[ UseTime:0.000471s ] mysql:host=127.0.0.1;port=3306;dbname=manboo_infoac;charset=utf8mb4
[ SQL ] UPDATE `resources` SET `views` = `views` + 1 WHERE `id` = 48057 [ RunTime:0.000383s ]
[ DB ] CONNECT:[ UseTime:0.001196s ] mysql:host=127.0.0.1;port=3306;dbname=manboo_infoac;charset=utf8mb4
[ SQL ] SHOW COLUMNS FROM `keywords` [ RunTime:0.000959s ]
[ SQL ] SELECT * FROM `keywords` WHERE `is_audit` = 1 ORDER BY `search_count` DESC LIMIT 30 [ RunTime:0.001659s ]
[ 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.000662s ] mysql:host=127.0.0.1;port=3306;dbname=manboo_infoac;charset=utf8mb4
[ SQL ] SELECT * FROM `resources` WHERE `id` <> 48057 ORDER BY `id` DESC LIMIT 10 [ RunTime:0.000906s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'resources', 'partitions' => NULL, 'type' => 'index', 'possible_keys' => 'PRIMARY,id_2,id', 'key' => 'PRIMARY', 'key_len' => '8', 'ref' => NULL, 'rows' => 10, 'filtered' => 100.0, 'extra' => 'Using where', ) ]
[ DB ] CONNECT:[ UseTime:0.000331s ] 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.003380s ]
[ 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.000337s ] 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.003578s ]
[ 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' => 603, 'filtered' => 100.0, 'extra' => 'Using index condition; Using where; Using temporary; Using filesort', ) ]
[ DB ] CONNECT:[ UseTime:0.000802s ] 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.000615s ]
[ 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.000343s ] 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' => 28, 'filtered' => 100.0, 'extra' => 'Using index condition; Using where; Using temporary; Using filesort', ) ]
[ DB ] CONNECT:[ UseTime:0.000472s ] 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.000734s ]
[ 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.000391s ] 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.000634s ]
[ 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.000355s ] 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.001065s ]
[ 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.001144s ] 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.083055s ]
[ 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' => 10446, 'filtered' => 100.0, 'extra' => 'Using index condition; Using where; Using temporary; Using filesort', ) ]
[ DB ] CONNECT:[ UseTime:0.000566s ] 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.000478s ]
[ 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.000546s ] 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.001024s ]
[ 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.000551s ] 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' => 17, 'filtered' => 100.0, 'extra' => 'Using index condition; Using where; Using temporary; Using filesort', ) ]
[ DB ] CONNECT:[ UseTime:0.000452s ] 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.000520s ]
[ 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.000399s ] 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.000943s ]
[ 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.000319s ] 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.000921s ]
[ 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.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.000675s ]
[ 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.000351s ] 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.000567s ]
[ 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.000452s ] 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.000480s ]
[ 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.000353s ] 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.000710s ]
[ 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.000379s ] 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.000670s ]
[ 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.000376s ] 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.007703s ]
[ 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' => 1581, 'filtered' => 100.0, 'extra' => 'Using index condition; Using where; Using temporary; Using filesort', ) ]
[ DB ] CONNECT:[ UseTime:0.000362s ] 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.000971s ]
[ 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.000634s ] 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.000577s ]
[ 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.000366s ] 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.000546s ]
[ 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.000421s ] 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.001246s ]
[ 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.000445s ] 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.000566s ]
[ 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.001317s ] 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.000698s ]
[ 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' => 25, '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.000615s ]
[ 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.000452s ] 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.000541s ]
[ 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.000379s ] 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.000634s ]
[ 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.000449s ] 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.000614s ]
[ 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.000590s ] 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.001491s ]
[ 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.000835s ] 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.000744s ]
[ 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.000664s ] 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.000766s ]
[ 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.000616s ] 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.000616s ]
[ 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.000478s ] 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.000497s ]
[ 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.000340s ] 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.001252s ]
[ 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.000655s ] 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.000856s ]
[ 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.000593s ] 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.000675s ]
[ 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.000467s ] 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.000569s ]
[ 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.000410s ] 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.000605s ]
[ 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.000587s ] 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' => 1, 'filtered' => 100.0, 'extra' => 'Using index condition; Using where; Using temporary; Using filesort', ) ]
[ DB ] CONNECT:[ UseTime:0.000531s ] 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.000999s ]
[ 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.000547s ] 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.000770s ]
[ 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', ) ]
[ DB ] CONNECT:[ UseTime:0.000737s ] 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.000762s ]
[ 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.000477s ] 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.001081s ]
[ 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.000695s ] 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.000875s ]
[ 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.000445s ] 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.001110s ]
[ 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' => 59, 'filtered' => 100.0, 'extra' => 'Using index condition; Using where; Using temporary; Using filesort', ) ]
[ DB ] CONNECT:[ UseTime:0.000535s ] 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.000514s ]
[ 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.000323s ] 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.070173s ]
[ 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' => 12763, 'filtered' => 100.0, 'extra' => 'Using index condition; Using where; Using temporary; Using filesort', ) ]
[ DB ] CONNECT:[ UseTime:0.000692s ] 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.001399s ]
[ 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.000513s ] 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.001293s ]
[ 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.000411s ] 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.000717s ]
[ 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.000520s ] 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.029815s ]
[ 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' => 6039, 'filtered' => 100.0, 'extra' => 'Using index condition; Using where; Using temporary; Using filesort', ) ]
[ DB ] CONNECT:[ UseTime:0.000688s ] 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.000798s ]
[ 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.000373s ] 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.000547s ]
[ 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.000477s ] 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.118796s ]
[ 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' => 16381, 'filtered' => 100.0, 'extra' => 'Using index condition; Using where; Using temporary; Using filesort', ) ]
[ DB ] CONNECT:[ UseTime:0.000615s ] 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.000512s ]
[ 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.000540s ] 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.001725s ]
[ 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.000313s ] 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.001060s ]
[ 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.000298s ] 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.000655s ]
[ 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' => 11, 'filtered' => 100.0, 'extra' => 'Using index condition; Using where; Using temporary; Using filesort', ) ]
[ DB ] CONNECT:[ UseTime:0.000380s ] 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.001458s ]
[ 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' => 655, 'filtered' => 100.0, 'extra' => 'Using index condition; Using where; Using temporary; Using filesort', ) ]
[ DB ] CONNECT:[ UseTime:0.000604s ] 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.000713s ]
[ 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.000416s ] 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.000629s ]
[ 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' => 46, 'filtered' => 100.0, 'extra' => 'Using index condition; Using where; Using temporary; Using filesort', ) ]
[ DB ] CONNECT:[ UseTime:0.000360s ] 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.000475s ]
[ 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', ) ]

时光漫步

资源详情

基于R语言的自动数据收集：网络抓取和文本挖掘实用指南

书籍详情介绍

书籍资料

下载地址

相关资源