SQL与关系数据库理论（第三版）- 电子书下载

基本文件流程错误 SQL 调试

/www/wwwroot/manboo.info/public/index.php ( 0.85 KB )
/www/wwwroot/manboo.info/thinkphp/base.php ( 1.71 KB )
/www/wwwroot/manboo.info/thinkphp/library/think/Loader.php ( 12.70 KB )
/www/wwwroot/manboo.info/vendor/composer/autoload_static.php ( 3.78 KB )
/www/wwwroot/manboo.info/thinkphp/library/think/Error.php ( 4.00 KB )
/www/wwwroot/manboo.info/thinkphp/library/think/Container.php ( 17.20 KB )
/www/wwwroot/manboo.info/thinkphp/library/think/App.php ( 27.58 KB )
/www/wwwroot/manboo.info/thinkphp/library/think/Env.php ( 2.85 KB )
/www/wwwroot/manboo.info/thinkphp/library/think/Config.php ( 9.71 KB )
/www/wwwroot/manboo.info/thinkphp/convention.php ( 11.74 KB )
/www/wwwroot/manboo.info/application/tags.php ( 0.96 KB )
/www/wwwroot/manboo.info/thinkphp/library/think/Hook.php ( 5.58 KB )
/www/wwwroot/manboo.info/application/common.php ( 0.60 KB )
/www/wwwroot/manboo.info/thinkphp/helper.php ( 20.40 KB )
/www/wwwroot/manboo.info/application/provider.php ( 0.62 KB )
/www/wwwroot/manboo.info/config/app.php ( 5.72 KB )
/www/wwwroot/manboo.info/thinkphp/library/think/facade/Env.php ( 1.17 KB )
/www/wwwroot/manboo.info/thinkphp/library/think/Facade.php ( 3.44 KB )
/www/wwwroot/manboo.info/config/cache.php ( 0.95 KB )
/www/wwwroot/manboo.info/config/console.php ( 0.91 KB )
/www/wwwroot/manboo.info/config/cookie.php ( 1.11 KB )
/www/wwwroot/manboo.info/config/database.php ( 2.43 KB )
/www/wwwroot/manboo.info/config/log.php ( 1.16 KB )
/www/wwwroot/manboo.info/config/middleware.php ( 0.85 KB )
/www/wwwroot/manboo.info/config/paginate.php ( 0.15 KB )
/www/wwwroot/manboo.info/config/session.php ( 1.06 KB )
/www/wwwroot/manboo.info/config/template.php ( 1.39 KB )
/www/wwwroot/manboo.info/config/trace.php ( 0.84 KB )
/www/wwwroot/manboo.info/vendor/symfony/polyfill-mbstring/bootstrap.php ( 8.26 KB )
/www/wwwroot/manboo.info/vendor/symfony/polyfill-mbstring/bootstrap80.php ( 9.77 KB )
/www/wwwroot/manboo.info/vendor/ezyang/htmlpurifier/library/HTMLPurifier.composer.php ( 0.10 KB )
/www/wwwroot/manboo.info/vendor/topthink/think-captcha/src/helper.php ( 1.54 KB )
/www/wwwroot/manboo.info/thinkphp/library/think/facade/Route.php ( 3.84 KB )
/www/wwwroot/manboo.info/thinkphp/library/think/Route.php ( 25.84 KB )
/www/wwwroot/manboo.info/thinkphp/library/think/Request.php ( 57.54 KB )
/www/wwwroot/manboo.info/thinkphp/library/think/route/Domain.php ( 7.08 KB )
/www/wwwroot/manboo.info/thinkphp/library/think/route/RuleGroup.php ( 16.45 KB )
/www/wwwroot/manboo.info/thinkphp/library/think/route/Rule.php ( 28.92 KB )
/www/wwwroot/manboo.info/thinkphp/library/think/route/RuleItem.php ( 8.84 KB )
/www/wwwroot/manboo.info/thinkphp/library/think/route/RuleName.php ( 3.92 KB )
/www/wwwroot/manboo.info/thinkphp/library/think/facade/Validate.php ( 4.83 KB )
/www/wwwroot/manboo.info/thinkphp/library/think/Validate.php ( 43.93 KB )
/www/wwwroot/manboo.info/thinkphp/library/think/Db.php ( 7.67 KB )
/www/wwwroot/manboo.info/thinkphp/library/think/Lang.php ( 7.56 KB )
/www/wwwroot/manboo.info/thinkphp/library/think/Log.php ( 8.92 KB )
/www/wwwroot/manboo.info/thinkphp/library/think/log/driver/File.php ( 8.97 KB )
/www/wwwroot/manboo.info/thinkphp/lang/zh-cn.php ( 12.58 KB )
/www/wwwroot/manboo.info/route/route.php ( 1.30 KB )
/www/wwwroot/manboo.info/thinkphp/library/think/route/dispatch/Module.php ( 5.19 KB )
/www/wwwroot/manboo.info/thinkphp/library/think/route/Dispatch.php ( 9.26 KB )
/www/wwwroot/manboo.info/thinkphp/library/think/Middleware.php ( 5.34 KB )
/www/wwwroot/manboo.info/thinkphp/library/think/Cookie.php ( 7.35 KB )
/www/wwwroot/manboo.info/thinkphp/library/think/View.php ( 5.74 KB )
/www/wwwroot/manboo.info/thinkphp/library/think/view/driver/Think.php ( 6.12 KB )
/www/wwwroot/manboo.info/thinkphp/library/think/Template.php ( 47.31 KB )
/www/wwwroot/manboo.info/thinkphp/library/think/template/driver/File.php ( 2.29 KB )
/www/wwwroot/manboo.info/thinkphp/library/think/Session.php ( 14.13 KB )
/www/wwwroot/manboo.info/thinkphp/library/think/Debug.php ( 7.57 KB )
/www/wwwroot/manboo.info/thinkphp/library/think/Cache.php ( 3.27 KB )
/www/wwwroot/manboo.info/thinkphp/library/think/cache/driver/File.php ( 7.99 KB )
/www/wwwroot/manboo.info/thinkphp/library/think/cache/Driver.php ( 8.64 KB )
/www/wwwroot/manboo.info/application/index/controller/Search.php ( 11.45 KB )
/www/wwwroot/manboo.info/application/common/controller/BaseController.php ( 1.37 KB )
/www/wwwroot/manboo.info/thinkphp/library/think/Controller.php ( 7.53 KB )
/www/wwwroot/manboo.info/thinkphp/library/traits/controller/Jump.php ( 4.76 KB )
/www/wwwroot/manboo.info/application/common/service/ConfigService.php ( 0.60 KB )
/www/wwwroot/manboo.info/thinkphp/library/think/facade/Cache.php ( 2.06 KB )
/www/wwwroot/manboo.info/application/common/model/Config.php ( 0.49 KB )
/www/wwwroot/manboo.info/thinkphp/library/think/Model.php ( 28.59 KB )
/www/wwwroot/manboo.info/thinkphp/library/think/model/concern/Attribute.php ( 17.64 KB )
/www/wwwroot/manboo.info/thinkphp/library/think/model/concern/RelationShip.php ( 20.60 KB )
/www/wwwroot/manboo.info/thinkphp/library/think/model/concern/ModelEvent.php ( 6.04 KB )
/www/wwwroot/manboo.info/thinkphp/library/think/model/concern/TimeStamp.php ( 2.58 KB )
/www/wwwroot/manboo.info/thinkphp/library/think/model/concern/Conversion.php ( 7.84 KB )
/www/wwwroot/manboo.info/thinkphp/library/think/db/Connection.php ( 58.93 KB )
/www/wwwroot/manboo.info/thinkphp/library/think/db/connector/Mysql.php ( 6.22 KB )
/www/wwwroot/manboo.info/thinkphp/library/think/db/builder/Mysql.php ( 5.85 KB )
/www/wwwroot/manboo.info/thinkphp/library/think/db/Builder.php ( 36.76 KB )
/www/wwwroot/manboo.info/thinkphp/library/think/db/Query.php ( 105.00 KB )
/www/wwwroot/manboo.info/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.93 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' => '51158', ), )
[ HEADER ] array ( 'x-forwarded-proto' => 'https', 'cf-visitor' => '{"scheme":"https"}', 'cf-ipcountry' => 'US', 'cf-connecting-ip' => '216.73.216.94', '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' => 'a0cc40c95e7536cd-CMH', 'x-forwarded-for' => '216.73.216.94', 'host' => 'manboo.info', 'content-length' => '', 'content-type' => '', )
[ PARAM ] array ( 'id' => '51158', )
[ 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.000842s ] mysql:host=127.0.0.1;port=3306;dbname=manboo_infoac;charset=utf8mb4
[ SQL ] SHOW COLUMNS FROM `config` [ RunTime:0.000876s ]
[ SQL ] SELECT `value` FROM `config` WHERE `name` = 'maintenance_mode' LIMIT 1 [ RunTime:0.000385s ]
[ 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.000405s ] mysql:host=127.0.0.1;port=3306;dbname=manboo_infoac;charset=utf8mb4
[ SQL ] SHOW COLUMNS FROM `resources` [ RunTime:0.000889s ]
[ SQL ] SELECT * FROM `resources` WHERE `id` = 51158 LIMIT 1 [ RunTime:0.000549s ]
[ 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.000710s ] mysql:host=127.0.0.1;port=3306;dbname=manboo_infoac;charset=utf8mb4
[ SQL ] SELECT * FROM `resources` WHERE `jd_skuName` LIKE '%%' AND `id` <> 51158 LIMIT 10 [ RunTime:0.001196s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'resources', 'partitions' => NULL, 'type' => 'range', 'possible_keys' => 'PRIMARY,id_2,id', 'key' => 'PRIMARY', 'key_len' => '8', 'ref' => NULL, 'rows' => 49977, 'filtered' => 11.110000610351562, 'extra' => 'Using index condition; Using where', ) ]
[ DB ] CONNECT:[ UseTime:0.000546s ] mysql:host=127.0.0.1;port=3306;dbname=manboo_infoac;charset=utf8mb4
[ SQL ] SELECT * FROM `resources` WHERE `jd_cate3` = '数据库' AND `id` <> 51158 LIMIT 10 [ RunTime:0.000634s ]
[ 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' => 99.99800109863281, 'extra' => 'Using where', ) ]
[ DB ] CONNECT:[ UseTime:0.000311s ] mysql:host=127.0.0.1;port=3306;dbname=manboo_infoac;charset=utf8mb4
[ SQL ] UPDATE `resources` SET `views` = `views` + 1 WHERE `id` = 51158 [ RunTime:0.026766s ]
[ DB ] CONNECT:[ UseTime:0.000863s ] mysql:host=127.0.0.1;port=3306;dbname=manboo_infoac;charset=utf8mb4
[ SQL ] SHOW COLUMNS FROM `keywords` [ RunTime:0.000648s ]
[ SQL ] SELECT * FROM `keywords` WHERE `is_audit` = 1 ORDER BY `search_count` DESC LIMIT 30 [ RunTime:0.000456s ]
[ 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.000491s ] mysql:host=127.0.0.1;port=3306;dbname=manboo_infoac;charset=utf8mb4
[ SQL ] SELECT * FROM `resources` WHERE `id` <> 51158 ORDER BY `id` DESC LIMIT 10 [ RunTime:0.000722s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'resources', 'partitions' => NULL, 'type' => 'range', 'possible_keys' => 'PRIMARY,id_2,id', 'key' => 'PRIMARY', 'key_len' => '8', 'ref' => NULL, 'rows' => 49977, 'filtered' => 100.0, 'extra' => 'Using index condition', ) ]
[ DB ] CONNECT:[ UseTime:0.000635s ] 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.003530s ]
[ 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.000322s ] 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.003616s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'resources', 'partitions' => NULL, 'type' => 'ref', 'possible_keys' => 'jd_cate2,jd_cate3', 'key' => 'jd_cate2', 'key_len' => '403', 'ref' => 'const', 'rows' => 604, 'filtered' => 100.0, 'extra' => 'Using index condition; Using where; Using temporary; Using filesort', ) ]
[ DB ] CONNECT:[ UseTime:0.000400s ] 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.000643s ]
[ 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.000680s ] 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.000858s ]
[ 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.001405s ] 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.000732s ]
[ 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.000683s ] 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.000996s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'resources', 'partitions' => NULL, 'type' => 'ref', 'possible_keys' => 'jd_cate2,jd_cate3', 'key' => 'jd_cate2', 'key_len' => '403', 'ref' => 'const', 'rows' => 15, 'filtered' => 100.0, 'extra' => 'Using index condition; Using where; Using temporary; Using filesort', ) ]
[ DB ] CONNECT:[ UseTime:0.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.001159s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'resources', 'partitions' => NULL, 'type' => 'ref', 'possible_keys' => 'jd_cate2,jd_cate3', 'key' => 'jd_cate2', 'key_len' => '403', 'ref' => 'const', 'rows' => 98, 'filtered' => 100.0, 'extra' => 'Using index condition; Using where; Using temporary; Using filesort', ) ]
[ DB ] CONNECT:[ UseTime:0.000339s ] 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.072495s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'resources', 'partitions' => NULL, 'type' => 'ref', 'possible_keys' => 'jd_cate2,jd_cate3', 'key' => 'jd_cate2', 'key_len' => '403', 'ref' => 'const', 'rows' => 10444, 'filtered' => 100.0, 'extra' => 'Using index condition; Using where; Using temporary; Using filesort', ) ]
[ DB ] CONNECT:[ UseTime:0.000563s ] 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.000644s ]
[ 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.000630s ] 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' => 27, 'filtered' => 100.0, 'extra' => 'Using index condition; Using where; Using temporary; Using filesort', ) ]
[ DB ] CONNECT:[ UseTime:0.000521s ] 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.000509s ]
[ 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.001308s ] 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' => 4, 'filtered' => 100.0, 'extra' => 'Using index condition; Using where; Using temporary; Using filesort', ) ]
[ DB ] CONNECT:[ UseTime:0.000381s ] 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.000911s ]
[ 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.000331s ] 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.000922s ]
[ 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.000273s ] 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.000424s ] 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.000560s ]
[ 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.000462s ] 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.000849s ]
[ 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.000977s ] 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.001170s ]
[ 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.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.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' => 20, 'filtered' => 100.0, 'extra' => 'Using index condition; Using where; Using temporary; Using filesort', ) ]
[ DB ] CONNECT:[ UseTime:0.000395s ] 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.010886s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'resources', 'partitions' => NULL, 'type' => 'ref', 'possible_keys' => 'jd_cate2,jd_cate3', 'key' => 'jd_cate2', 'key_len' => '403', 'ref' => 'const', 'rows' => 1580, 'filtered' => 100.0, 'extra' => 'Using index condition; Using where; Using temporary; Using filesort', ) ]
[ DB ] CONNECT:[ UseTime:0.000998s ] 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.001023s ]
[ 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.000350s ] 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' => 13, 'filtered' => 100.0, 'extra' => 'Using index condition; Using where; Using temporary; Using filesort', ) ]
[ DB ] CONNECT:[ UseTime:0.000649s ] 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' => 1, 'filtered' => 100.0, 'extra' => 'Using index condition; Using where; Using temporary; Using filesort', ) ]
[ DB ] CONNECT:[ UseTime:0.000511s ] 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.001501s ]
[ 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.000330s ] 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.000404s ]
[ 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.000299s ] 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.000568s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'resources', 'partitions' => NULL, 'type' => 'ref', 'possible_keys' => 'jd_cate2,jd_cate3', 'key' => 'jd_cate2', 'key_len' => '403', 'ref' => 'const', 'rows' => 24, 'filtered' => 100.0, 'extra' => 'Using index condition; Using where; Using temporary; Using filesort', ) ]
[ DB ] CONNECT:[ UseTime:0.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.000518s ]
[ 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.000332s ] mysql:host=127.0.0.1;port=3306;dbname=manboo_infoac;charset=utf8mb4
[ SQL ] SELECT DISTINCT `jd_cate3` FROM `resources` WHERE `jd_cate2` = '文创用品' AND ( jd_cate3 <> "" ) ORDER BY `jd_cate3` ASC [ RunTime:0.000382s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'resources', 'partitions' => NULL, 'type' => 'ref', 'possible_keys' => 'jd_cate2,jd_cate3', 'key' => 'jd_cate2', 'key_len' => '403', 'ref' => 'const', 'rows' => 1, 'filtered' => 100.0, 'extra' => 'Using index condition; Using where; Using temporary; Using filesort', ) ]
[ DB ] CONNECT:[ UseTime:0.000266s ] 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.000391s ]
[ 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.000294s ] 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.000464s ]
[ 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.000253s ] 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.000617s ]
[ 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.000272s ] 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.000897s ]
[ 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.000265s ] 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.000425s ]
[ 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.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.000400s ]
[ 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.000435s ] 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.000418s ]
[ 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.003704s ] 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.001655s ]
[ 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.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.045253s ]
[ 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.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.000636s ]
[ 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.000386s ] mysql:host=127.0.0.1;port=3306;dbname=manboo_infoac;charset=utf8mb4
[ SQL ] SELECT DISTINCT `jd_cate3` FROM `resources` WHERE `jd_cate2` = '法律' AND ( jd_cate3 <> "" ) ORDER BY `jd_cate3` ASC [ RunTime:0.000696s ]
[ 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.000435s ] 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.000628s ]
[ 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.001380s ] 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.000481s ]
[ 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.000625s ] 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' => 7, '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.000684s ]
[ 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.000436s ] 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.001126s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'resources', 'partitions' => NULL, 'type' => 'ref', 'possible_keys' => 'jd_cate2,jd_cate3', 'key' => 'jd_cate2', 'key_len' => '403', 'ref' => 'const', 'rows' => 32, 'filtered' => 100.0, 'extra' => 'Using index condition; Using where; Using temporary; Using filesort', ) ]
[ DB ] CONNECT:[ UseTime:0.000308s ] 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.000693s ]
[ 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.001377s ] 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' => 14, 'filtered' => 100.0, 'extra' => 'Using index condition; Using where; Using temporary; Using filesort', ) ]
[ DB ] CONNECT:[ UseTime:0.000917s ] mysql:host=127.0.0.1;port=3306;dbname=manboo_infoac;charset=utf8mb4
[ SQL ] SELECT DISTINCT `jd_cate3` FROM `resources` WHERE `jd_cate2` = '科普读物' AND ( jd_cate3 <> "" ) ORDER BY `jd_cate3` ASC [ RunTime:0.000705s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'resources', 'partitions' => NULL, 'type' => 'ref', 'possible_keys' => 'jd_cate2,jd_cate3', 'key' => 'jd_cate2', 'key_len' => '403', 'ref' => 'const', 'rows' => 58, 'filtered' => 100.0, 'extra' => 'Using index condition; Using where; Using temporary; Using filesort', ) ]
[ DB ] CONNECT:[ UseTime:0.000331s ] 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.000379s ]
[ 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.000321s ] 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.070038s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'resources', 'partitions' => NULL, 'type' => 'ref', 'possible_keys' => 'jd_cate2,jd_cate3', 'key' => 'jd_cate2', 'key_len' => '403', 'ref' => 'const', 'rows' => 12756, 'filtered' => 100.0, 'extra' => 'Using index condition; Using where; Using temporary; Using filesort', ) ]
[ DB ] CONNECT:[ UseTime:0.000974s ] 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.000852s ]
[ 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.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.000904s ]
[ 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.000782s ] 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' => 1, 'filtered' => 100.0, 'extra' => 'Using index condition; Using where; Using temporary; Using filesort', ) ]
[ DB ] CONNECT:[ UseTime:0.000320s ] 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.025630s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'resources', 'partitions' => NULL, 'type' => 'ref', 'possible_keys' => 'jd_cate2,jd_cate3', 'key' => 'jd_cate2', 'key_len' => '403', 'ref' => 'const', 'rows' => 6042, 'filtered' => 100.0, 'extra' => 'Using index condition; Using where; Using temporary; Using filesort', ) ]
[ DB ] CONNECT:[ UseTime:0.000336s ] mysql:host=127.0.0.1;port=3306;dbname=manboo_infoac;charset=utf8mb4
[ SQL ] SELECT DISTINCT `jd_cate3` FROM `resources` WHERE `jd_cate2` = '艺术' AND ( jd_cate3 <> "" ) ORDER BY `jd_cate3` ASC [ RunTime:0.000666s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'resources', 'partitions' => NULL, 'type' => 'ref', 'possible_keys' => 'jd_cate2,jd_cate3', 'key' => 'jd_cate2', 'key_len' => '403', 'ref' => 'const', 'rows' => 1, 'filtered' => 100.0, 'extra' => 'Using index condition; Using where; Using temporary; Using filesort', ) ]
[ DB ] CONNECT:[ UseTime:0.000415s ] mysql:host=127.0.0.1;port=3306;dbname=manboo_infoac;charset=utf8mb4
[ SQL ] SELECT DISTINCT `jd_cate3` FROM `resources` WHERE `jd_cate2` = '计算机' AND ( jd_cate3 <> "" ) ORDER BY `jd_cate3` ASC [ RunTime:0.000517s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'resources', 'partitions' => NULL, 'type' => 'ref', 'possible_keys' => 'jd_cate2,jd_cate3', 'key' => 'jd_cate2', 'key_len' => '403', 'ref' => 'const', 'rows' => 1, 'filtered' => 100.0, 'extra' => 'Using index condition; Using where; Using temporary; Using filesort', ) ]
[ DB ] CONNECT:[ UseTime:0.000365s ] 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.095688s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'resources', 'partitions' => NULL, 'type' => 'ref', 'possible_keys' => 'jd_cate2,jd_cate3', 'key' => 'jd_cate2', 'key_len' => '403', 'ref' => 'const', 'rows' => 16380, 'filtered' => 100.0, 'extra' => 'Using index condition; Using where; Using temporary; Using filesort', ) ]
[ DB ] CONNECT:[ UseTime:0.000361s ] 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.000664s ]
[ 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.000489s ] 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.001089s ]
[ 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.000683s ] 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.000737s ]
[ 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.000418s ] 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.000687s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'resources', 'partitions' => NULL, 'type' => 'ref', 'possible_keys' => 'jd_cate2,jd_cate3', 'key' => 'jd_cate2', 'key_len' => '403', 'ref' => 'const', 'rows' => 10, 'filtered' => 100.0, 'extra' => 'Using index condition; Using where; Using temporary; Using filesort', ) ]
[ DB ] CONNECT:[ UseTime:0.000369s ] 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.001754s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'resources', 'partitions' => NULL, 'type' => 'ref', 'possible_keys' => 'jd_cate2,jd_cate3', 'key' => 'jd_cate2', 'key_len' => '403', 'ref' => 'const', 'rows' => 661, 'filtered' => 100.0, 'extra' => 'Using index condition; Using where; Using temporary; Using filesort', ) ]
[ DB ] CONNECT:[ UseTime:0.000381s ] 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.000434s ]
[ 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.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.000543s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'resources', 'partitions' => NULL, 'type' => 'ref', 'possible_keys' => 'jd_cate2,jd_cate3', 'key' => 'jd_cate2', 'key_len' => '403', 'ref' => 'const', 'rows' => 50, 'filtered' => 100.0, 'extra' => 'Using index condition; Using where; Using temporary; Using filesort', ) ]
[ DB ] CONNECT:[ UseTime:0.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.000606s ]
[ 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', ) ]

时光漫步

资源详情

SQL与关系数据库理论（第三版）

书籍详情介绍

书籍资料

下载地址

相关资源