MySQL学习书籍：MySQL必知必会+高性能MySQL+深入浅出MySQL第三版+技术内幕- 电子书下载

基本文件流程错误 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' => '51017', ), )
[ 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' => 'a0ccee76b8202a7e-CMH', 'x-forwarded-for' => '216.73.216.94', 'host' => 'manboo.info', 'content-length' => '', 'content-type' => '', )
[ PARAM ] array ( 'id' => '51017', )
[ 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.000400s ] mysql:host=127.0.0.1;port=3306;dbname=manboo_infoac;charset=utf8mb4
[ SQL ] SHOW COLUMNS FROM `config` [ RunTime:0.000639s ]
[ SQL ] SELECT `value` FROM `config` WHERE `name` = 'maintenance_mode' LIMIT 1 [ RunTime:0.000302s ]
[ 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.000293s ] mysql:host=127.0.0.1;port=3306;dbname=manboo_infoac;charset=utf8mb4
[ SQL ] SHOW COLUMNS FROM `resources` [ RunTime:0.000590s ]
[ SQL ] SELECT * FROM `resources` WHERE `id` = 51017 LIMIT 1 [ RunTime:0.000353s ]
[ 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.000308s ] mysql:host=127.0.0.1;port=3306;dbname=manboo_infoac;charset=utf8mb4
[ SQL ] SELECT * FROM `resources` WHERE `jd_skuName` LIKE '%%' AND `id` <> 51017 LIMIT 10 [ RunTime:0.001329s ]
[ 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.000310s ] mysql:host=127.0.0.1;port=3306;dbname=manboo_infoac;charset=utf8mb4
[ SQL ] SELECT * FROM `resources` WHERE `jd_cate3` = '数据库' AND `id` <> 51017 LIMIT 10 [ RunTime:0.000702s ]
[ 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.000324s ] mysql:host=127.0.0.1;port=3306;dbname=manboo_infoac;charset=utf8mb4
[ SQL ] UPDATE `resources` SET `views` = `views` + 1 WHERE `id` = 51017 [ RunTime:0.031452s ]
[ DB ] CONNECT:[ UseTime:0.000468s ] mysql:host=127.0.0.1;port=3306;dbname=manboo_infoac;charset=utf8mb4
[ SQL ] SHOW COLUMNS FROM `keywords` [ RunTime:0.000704s ]
[ SQL ] SELECT * FROM `keywords` WHERE `is_audit` = 1 ORDER BY `search_count` DESC LIMIT 30 [ RunTime:0.000447s ]
[ 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.000270s ] mysql:host=127.0.0.1;port=3306;dbname=manboo_infoac;charset=utf8mb4
[ SQL ] SELECT * FROM `resources` WHERE `id` <> 51017 ORDER BY `id` DESC LIMIT 10 [ RunTime:0.000513s ]
[ 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.000817s ] 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.003212s ]
[ 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.000441s ] 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.002971s ]
[ 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.000277s ] 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.000524s ]
[ 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.000445s ] mysql:host=127.0.0.1;port=3306;dbname=manboo_infoac;charset=utf8mb4
[ SQL ] SELECT DISTINCT `jd_cate3` FROM `resources` WHERE `jd_cate2` = '二手书' AND ( jd_cate3 <> "" ) ORDER BY `jd_cate3` ASC [ RunTime:0.000807s ]
[ 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.000243s ] 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.000473s ]
[ 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.000251s ] 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.000542s ]
[ 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.000275s ] mysql:host=127.0.0.1;port=3306;dbname=manboo_infoac;charset=utf8mb4
[ SQL ] SELECT DISTINCT `jd_cate3` FROM `resources` WHERE `jd_cate2` = '动漫' AND ( jd_cate3 <> "" ) ORDER BY `jd_cate3` ASC [ RunTime:0.000832s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'resources', 'partitions' => NULL, 'type' => 'ref', 'possible_keys' => 'jd_cate2,jd_cate3', 'key' => 'jd_cate2', 'key_len' => '403', 'ref' => 'const', 'rows' => 98, 'filtered' => 100.0, 'extra' => 'Using index condition; Using where; Using temporary; Using filesort', ) ]
[ DB ] CONNECT:[ UseTime:0.000237s ] 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.044510s ]
[ 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.000335s ] 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.000417s ]
[ 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.000246s ] 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.000494s ]
[ 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.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.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' => 18, 'filtered' => 100.0, 'extra' => 'Using index condition; Using where; Using temporary; Using filesort', ) ]
[ DB ] CONNECT:[ UseTime:0.000349s ] mysql:host=127.0.0.1;port=3306;dbname=manboo_infoac;charset=utf8mb4
[ SQL ] SELECT DISTINCT `jd_cate3` FROM `resources` WHERE `jd_cate2` = '国学/古籍' AND ( jd_cate3 <> "" ) ORDER BY `jd_cate3` ASC [ RunTime:0.000574s ]
[ 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.000335s ] 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.000917s ]
[ 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.000284s ] 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.000929s ]
[ 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.000312s ] 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.000445s ]
[ 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.001073s ] 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.000402s ]
[ 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.000255s ] 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.000459s ]
[ 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.000260s ] 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' => 17, '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.000443s ]
[ 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.011230s ] 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.006336s ]
[ 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.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.000968s ]
[ 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.000318s ] 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.064398s ]
[ 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.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.000467s ]
[ 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.000551s ] mysql:host=127.0.0.1;port=3306;dbname=manboo_infoac;charset=utf8mb4
[ SQL ] SELECT DISTINCT `jd_cate3` FROM `resources` WHERE `jd_cate2` = '心理学' AND ( jd_cate3 <> "" ) ORDER BY `jd_cate3` ASC [ RunTime:0.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.000739s ] 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.000503s ]
[ 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.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.000648s ]
[ 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.000438s ] 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.000679s ]
[ 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.000451s ] 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.000465s ]
[ 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.000347s ] 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.000396s ]
[ 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.000301s ] 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' => 5, 'filtered' => 100.0, 'extra' => 'Using index condition; Using where; Using temporary; Using filesort', ) ]
[ DB ] CONNECT:[ UseTime:0.000387s ] 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.000612s ]
[ 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.000267s ] 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.000553s ]
[ 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.000515s ] 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.000620s ]
[ 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.000429s ] 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.000433s ]
[ 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.000387s ] 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' => 2, 'filtered' => 100.0, 'extra' => 'Using index condition; Using where; Using temporary; Using filesort', ) ]
[ DB ] CONNECT:[ UseTime:0.001243s ] 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.001276s ]
[ 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.000412s ] 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.000690s ]
[ 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.001012s ] 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.000974s ]
[ 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.000469s ] 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.000945s ]
[ 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.001383s ] mysql:host=127.0.0.1;port=3306;dbname=manboo_infoac;charset=utf8mb4
[ SQL ] SELECT DISTINCT `jd_cate3` FROM `resources` WHERE `jd_cate2` = '港台图书' AND ( jd_cate3 <> "" ) ORDER BY `jd_cate3` ASC [ RunTime:0.000670s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'resources', 'partitions' => NULL, 'type' => 'ref', 'possible_keys' => 'jd_cate2,jd_cate3', 'key' => 'jd_cate2', 'key_len' => '403', 'ref' => 'const', 'rows' => 9, '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.000542s ]
[ 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.000289s ] mysql:host=127.0.0.1;port=3306;dbname=manboo_infoac;charset=utf8mb4
[ SQL ] SELECT DISTINCT `jd_cate3` FROM `resources` WHERE `jd_cate2` = '电子与通信' AND ( jd_cate3 <> "" ) ORDER BY `jd_cate3` ASC [ RunTime:0.000601s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'resources', 'partitions' => NULL, 'type' => 'ref', 'possible_keys' => 'jd_cate2,jd_cate3', 'key' => 'jd_cate2', 'key_len' => '403', 'ref' => 'const', 'rows' => 7, 'filtered' => 100.0, 'extra' => 'Using index condition; Using where; Using temporary; Using filesort', ) ]
[ DB ] CONNECT:[ UseTime:0.000425s ] mysql:host=127.0.0.1;port=3306;dbname=manboo_infoac;charset=utf8mb4
[ SQL ] SELECT DISTINCT `jd_cate3` FROM `resources` WHERE `jd_cate2` = '白酒' AND ( jd_cate3 <> "" ) ORDER BY `jd_cate3` ASC [ RunTime:0.000602s ]
[ 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.000314s ] 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.000719s ]
[ 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.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.000854s ]
[ 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.000289s ] 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.000660s ]
[ 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.000324s ] 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.000807s ]
[ 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.000908s ] 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.000870s ]
[ 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.000469s ] 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.050156s ]
[ 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.000286s ] 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.007539s ]
[ 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.000715s ] 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.000906s ]
[ 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.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.000988s ]
[ 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.001783s ] 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.030928s ]
[ 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.000382s ] mysql:host=127.0.0.1;port=3306;dbname=manboo_infoac;charset=utf8mb4
[ SQL ] SELECT DISTINCT `jd_cate3` FROM `resources` WHERE `jd_cate2` = '艺术' AND ( jd_cate3 <> "" ) ORDER BY `jd_cate3` ASC [ RunTime:0.000622s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'resources', 'partitions' => NULL, 'type' => 'ref', 'possible_keys' => 'jd_cate2,jd_cate3', 'key' => 'jd_cate2', 'key_len' => '403', 'ref' => 'const', 'rows' => 1, 'filtered' => 100.0, 'extra' => 'Using index condition; Using where; Using temporary; Using filesort', ) ]
[ DB ] CONNECT:[ UseTime:0.000582s ] 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.000531s ]
[ 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.000343s ] mysql:host=127.0.0.1;port=3306;dbname=manboo_infoac;charset=utf8mb4
[ SQL ] SELECT DISTINCT `jd_cate3` FROM `resources` WHERE `jd_cate2` = '计算机与互联网' AND ( jd_cate3 <> "" ) ORDER BY `jd_cate3` ASC [ RunTime:0.074318s ]
[ 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.000364s ] mysql:host=127.0.0.1;port=3306;dbname=manboo_infoac;charset=utf8mb4
[ SQL ] SELECT DISTINCT `jd_cate3` FROM `resources` WHERE `jd_cate2` = '身体护理' AND ( jd_cate3 <> "" ) ORDER BY `jd_cate3` ASC [ RunTime:0.000544s ]
[ 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.000258s ] 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.000486s ]
[ 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.000383s ] 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.000610s ]
[ 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.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.000584s ]
[ 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.000358s ] 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.001402s ]
[ 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.000285s ] 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.000345s ]
[ 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.000220s ] 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.000423s ]
[ 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.000225s ] 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.000436s ]
[ 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', ) ]

时光漫步

资源详情

MySQL学习书籍：MySQL必知必会+高性能MySQL+深入浅出MySQL第三版+技术内幕

书籍详情介绍

书籍资料

下载地址

相关资源