Spark大数据商业实战三部曲：内核解密商业案例性能调优- 电子书下载

基本文件流程错误 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' => '51002', ), )
[ 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' => 'a0d3d2fe3b90cf46-CMH', 'x-forwarded-for' => '216.73.216.60', 'host' => 'manboo.info', 'content-length' => '', 'content-type' => '', )
[ PARAM ] array ( 'id' => '51002', )
[ 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.000584s ] mysql:host=127.0.0.1;port=3306;dbname=manboo_infoac;charset=utf8mb4
[ SQL ] SHOW COLUMNS FROM `config` [ RunTime:0.000894s ]
[ SQL ] SELECT `value` FROM `config` WHERE `name` = 'maintenance_mode' LIMIT 1 [ RunTime:0.000391s ]
[ 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.000507s ] mysql:host=127.0.0.1;port=3306;dbname=manboo_infoac;charset=utf8mb4
[ SQL ] SHOW COLUMNS FROM `resources` [ RunTime:0.000658s ]
[ SQL ] SELECT * FROM `resources` WHERE `id` = 51002 LIMIT 1 [ RunTime:0.001068s ]
[ 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.000403s ] mysql:host=127.0.0.1;port=3306;dbname=manboo_infoac;charset=utf8mb4
[ SQL ] SELECT * FROM `resources` WHERE `jd_skuName` LIKE '%%' AND `id` <> 51002 LIMIT 10 [ RunTime:0.001907s ]
[ 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.000664s ] mysql:host=127.0.0.1;port=3306;dbname=manboo_infoac;charset=utf8mb4
[ SQL ] SELECT * FROM `resources` WHERE `jd_cate3` = '数据库' AND `id` <> 51002 LIMIT 10 [ RunTime:0.000853s ]
[ 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' => 2075, 'filtered' => 100.0, 'extra' => 'Using where', ) ]
[ DB ] CONNECT:[ UseTime:0.000583s ] mysql:host=127.0.0.1;port=3306;dbname=manboo_infoac;charset=utf8mb4
[ SQL ] UPDATE `resources` SET `views` = `views` + 1 WHERE `id` = 51002 [ RunTime:0.000467s ]
[ DB ] CONNECT:[ UseTime:0.000584s ] mysql:host=127.0.0.1;port=3306;dbname=manboo_infoac;charset=utf8mb4
[ SQL ] SHOW COLUMNS FROM `keywords` [ RunTime:0.001016s ]
[ SQL ] SELECT * FROM `keywords` WHERE `is_audit` = 1 ORDER BY `search_count` DESC LIMIT 30 [ RunTime:0.000634s ]
[ 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.000651s ] mysql:host=127.0.0.1;port=3306;dbname=manboo_infoac;charset=utf8mb4
[ SQL ] SELECT * FROM `resources` WHERE `id` <> 51002 ORDER BY `id` DESC LIMIT 10 [ RunTime:0.000821s ]
[ 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.000472s ] 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.003944s ]
[ 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.000530s ] 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.005163s ]
[ 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.000455s ] 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.000595s ]
[ 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.000533s ] 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.001224s ]
[ 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.000447s ] 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.000598s ]
[ 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.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.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.000264s ] 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.000935s ]
[ 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.000573s ] 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.051820s ]
[ 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.000596s ] 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.000571s ]
[ 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.000450s ] 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.000745s ]
[ 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.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.000712s ]
[ 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.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.000532s ]
[ 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.000357s ] 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.001149s ]
[ 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.000398s ] 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.001493s ]
[ 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.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.000539s ]
[ 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.000392s ] 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.000557s ]
[ 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.000529s ] 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.000545s ]
[ 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.000283s ] 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' => 18, 'filtered' => 100.0, 'extra' => 'Using index condition; Using where; Using temporary; Using filesort', ) ]
[ DB ] CONNECT:[ UseTime:0.000431s ] 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.000760s ]
[ 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.000405s ] 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.009913s ]
[ 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.000419s ] 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.000723s ]
[ 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.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.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' => 14, '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.000408s ]
[ 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.000406s ] 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.001125s ]
[ 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.001004s ] 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.001010s ]
[ 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.000595s ] 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.000645s ]
[ 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.000456s ] 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.000585s ]
[ 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.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.000504s ]
[ 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.000523s ] 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.000624s ]
[ 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.000307s ] 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.000490s ]
[ 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.000549s ] 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' => 33, 'filtered' => 100.0, 'extra' => 'Using index condition; Using where; Using temporary; Using filesort', ) ]
[ DB ] CONNECT:[ UseTime:0.000506s ] 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.000580s ]
[ 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.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.000839s ]
[ 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.001201s ] 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.001039s ]
[ 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.000589s ] 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.000669s ]
[ 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.000493s ] 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.001481s ]
[ 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.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.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' => 37, 'filtered' => 100.0, 'extra' => 'Using index condition; Using where; Using temporary; Using filesort', ) ]
[ DB ] CONNECT:[ UseTime:0.000597s ] 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.000780s ]
[ 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.000525s ] 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.001377s ]
[ 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.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.000586s ]
[ 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.000957s ] 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' => 1, 'filtered' => 100.0, 'extra' => 'Using index condition; Using where; Using temporary; Using filesort', ) ]
[ DB ] CONNECT:[ UseTime:0.000385s ] 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.000625s ]
[ 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.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.000581s ]
[ 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.000456s ] 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.000869s ]
[ 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.000398s ] 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.000840s ]
[ 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.000484s ] 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.000803s ]
[ 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.000507s ] 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' => 59, '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.000563s ]
[ 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.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.067088s ]
[ 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.000522s ] 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.001058s ]
[ 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.000453s ] 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.001146s ]
[ 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.000440s ] 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.000598s ]
[ 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.000403s ] 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.022385s ]
[ 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.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.000632s ]
[ 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.000431s ] 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.000709s ]
[ 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.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.079694s ]
[ 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.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.000645s ]
[ 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.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.000641s ]
[ 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.001335s ] 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.001504s ]
[ 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.000354s ] 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.000778s ]
[ 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.000502s ] 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.001584s ]
[ 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.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.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' => 5, 'filtered' => 100.0, 'extra' => 'Using index condition; Using where; Using temporary; Using filesort', ) ]
[ DB ] CONNECT:[ UseTime:0.000370s ] 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.000476s ]
[ 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.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.000479s ]
[ 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', ) ]

时光漫步

资源详情

Spark大数据商业实战三部曲：内核解密商业案例性能调优

书籍详情介绍

书籍资料

下载地址

相关资源

时光漫步

资源详情

Spark大数据商业实战三部曲：内核解密 商业案例 性能调优

书籍详情介绍

书籍资料

下载地址

相关资源

Spark大数据商业实战三部曲：内核解密商业案例性能调优