基本
文件
流程
错误
SQL
调试
请求信息 : 2022-05-29 00:55:44 HTTP/1.1 GET : http://minicky.cn/portal/mini_list/index/id/400 运行时间 : 0.053705s [ 吞吐率:18.62req/s ] 内存消耗:1,294.47kb 文件加载:95 查询信息 : 44 queries 1 writes 缓存信息 : 32 reads,18 writes 会话信息 : SESSION_ID=lpvlijuu1339nq6tg6cgi9u3m7
/data/wwwroot/mini/public/index.php ( 2.05 KB ) /data/wwwroot/mini/vendor/thinkphp/base.php ( 1.71 KB ) /data/wwwroot/mini/vendor/thinkphp/library/think/Loader.php ( 12.70 KB ) /data/wwwroot/mini/vendor/composer/autoload_static.php ( 6.05 KB ) /data/wwwroot/mini/vendor/thinkphp/library/think/Error.php ( 4.00 KB ) /data/wwwroot/mini/vendor/thinkphp/library/think/Container.php ( 15.53 KB ) /data/wwwroot/mini/vendor/thinkcmf/cmf/src/App.php ( 29.40 KB ) /data/wwwroot/mini/vendor/thinkphp/library/think/Env.php ( 2.85 KB ) /data/wwwroot/mini/vendor/thinkphp/library/think/Config.php ( 9.71 KB ) /data/wwwroot/mini/vendor/thinkphp/convention.php ( 11.74 KB ) /data/wwwroot/mini/app/tags.php ( 1.35 KB ) /data/wwwroot/mini/vendor/thinkphp/library/think/Hook.php ( 5.58 KB ) /data/wwwroot/mini/vendor/thinkphp/helper.php ( 20.40 KB ) /data/wwwroot/mini/vendor/thinkcmf/cmf-app/src/app.php ( 5.31 KB ) /data/wwwroot/mini/vendor/thinkcmf/cmf-app/src/database.php ( 0.90 KB ) /data/wwwroot/mini/vendor/thinkcmf/cmf-app/src/template.php ( 2.02 KB ) /data/wwwroot/mini/vendor/thinkcmf/cmf-app/src/paginate.php ( 0.17 KB ) /data/wwwroot/mini/vendor/thinkcmf/cmf-app/src/tags.php ( 1.35 KB ) /data/wwwroot/mini/app/app.php ( 5.31 KB ) /data/wwwroot/mini/app/database.php ( 0.90 KB ) /data/wwwroot/mini/app/template.php ( 2.02 KB ) /data/wwwroot/mini/app/paginate.php ( 0.17 KB ) /data/wwwroot/mini/data/config/database.php ( 0.51 KB ) /data/wwwroot/mini/vendor/ezyang/htmlpurifier/library/HTMLPurifier.composer.php ( 0.10 KB ) /data/wwwroot/mini/vendor/topthink/think-captcha/src/helper.php ( 1.54 KB ) /data/wwwroot/mini/vendor/thinkphp/library/think/facade/Route.php ( 3.83 KB ) /data/wwwroot/mini/vendor/thinkphp/library/think/Facade.php ( 3.44 KB ) /data/wwwroot/mini/vendor/thinkphp/library/think/Route.php ( 25.79 KB ) /data/wwwroot/mini/vendor/thinkphp/library/think/Request.php ( 57.50 KB ) /data/wwwroot/mini/vendor/thinkphp/library/think/route/Domain.php ( 7.07 KB ) /data/wwwroot/mini/vendor/thinkphp/library/think/route/RuleGroup.php ( 16.45 KB ) /data/wwwroot/mini/vendor/thinkphp/library/think/route/Rule.php ( 28.92 KB ) /data/wwwroot/mini/vendor/thinkphp/library/think/route/RuleItem.php ( 8.84 KB ) /data/wwwroot/mini/vendor/thinkphp/library/think/route/RuleName.php ( 3.92 KB ) /data/wwwroot/mini/vendor/thinkphp/library/think/facade/Validate.php ( 4.83 KB ) /data/wwwroot/mini/vendor/thinkphp/library/think/Validate.php ( 43.85 KB ) /data/wwwroot/mini/vendor/thinkcmf/cmf/src/common.php ( 81.20 KB ) /data/wwwroot/mini/vendor/topthink/think-helper/src/helper.php ( 2.88 KB ) /data/wwwroot/mini/vendor/thinkphp/library/think/Db.php ( 7.67 KB ) /data/wwwroot/mini/vendor/thinkphp/library/think/Lang.php ( 7.38 KB ) /data/wwwroot/mini/vendor/thinkcmf/cmf/src/behavior/InitHookBehavior.php ( 2.07 KB ) /data/wwwroot/mini/vendor/thinkphp/library/think/facade/Cache.php ( 2.06 KB ) /data/wwwroot/mini/vendor/thinkphp/library/think/Cache.php ( 3.27 KB ) /data/wwwroot/mini/vendor/thinkphp/library/think/cache/driver/File.php ( 7.99 KB ) /data/wwwroot/mini/vendor/thinkphp/library/think/cache/Driver.php ( 8.64 KB ) /data/wwwroot/mini/vendor/thinkphp/library/think/db/Connection.php ( 58.93 KB ) /data/wwwroot/mini/vendor/thinkcmf/cmf/src/Log.php ( 8.96 KB ) /data/wwwroot/mini/vendor/thinkphp/library/think/log/driver/File.php ( 8.97 KB ) /data/wwwroot/mini/vendor/thinkphp/library/think/db/connector/Mysql.php ( 6.24 KB ) /data/wwwroot/mini/vendor/thinkphp/library/think/db/builder/Mysql.php ( 5.54 KB ) /data/wwwroot/mini/vendor/thinkphp/library/think/db/Builder.php ( 36.78 KB ) /data/wwwroot/mini/vendor/thinkphp/library/think/db/Query.php ( 105.00 KB ) /data/wwwroot/mini/vendor/thinkphp/library/think/Debug.php ( 7.57 KB ) /data/wwwroot/mini/vendor/thinkphp/library/think/Collection.php ( 13.59 KB ) /data/wwwroot/mini/vendor/thinkphp/library/think/route/dispatch/Url.php ( 5.24 KB ) /data/wwwroot/mini/vendor/thinkphp/library/think/route/Dispatch.php ( 9.26 KB ) /data/wwwroot/mini/vendor/thinkcmf/cmf/src/route/dispatch/Module.php ( 5.15 KB ) /data/wwwroot/mini/vendor/thinkphp/library/think/Middleware.php ( 5.34 KB ) /data/wwwroot/mini/vendor/thinkphp/library/think/Cookie.php ( 7.35 KB ) /data/wwwroot/mini/vendor/thinkphp/library/think/View.php ( 5.74 KB ) /data/wwwroot/mini/vendor/thinkphp/library/think/view/driver/Think.php ( 6.12 KB ) /data/wwwroot/mini/vendor/thinkphp/library/think/Template.php ( 47.31 KB ) /data/wwwroot/mini/vendor/thinkphp/library/think/template/driver/File.php ( 2.29 KB ) /data/wwwroot/mini/vendor/thinkphp/library/think/Session.php ( 14.13 KB ) /data/wwwroot/mini/app/portal/lang/cn.php ( 7.76 KB ) /data/wwwroot/mini/vendor/thinkcmf/cmf/src/behavior/LangBehavior.php ( 2.46 KB ) /data/wwwroot/mini/vendor/thinkphp/library/think/facade/Lang.php ( 1.75 KB ) /data/wwwroot/mini/vendor/thinkphp/library/think/facade/Env.php ( 1.17 KB ) /data/wwwroot/mini/vendor/thinkcmf/cmf/src/behavior/InitAppHookBehavior.php ( 2.01 KB ) /data/wwwroot/mini/app/portal/controller/MiniListController.php ( 4.43 KB ) /data/wwwroot/mini/vendor/thinkcmf/cmf/src/controller/HomeBaseController.php ( 13.43 KB ) /data/wwwroot/mini/vendor/thinkcmf/cmf/src/controller/BaseController.php ( 2.24 KB ) /data/wwwroot/mini/vendor/thinkphp/library/think/Controller.php ( 7.53 KB ) /data/wwwroot/mini/vendor/thinkphp/library/traits/controller/Jump.php ( 4.76 KB ) /data/wwwroot/mini/vendor/thinkphp/library/think/facade/Config.php ( 1.52 KB ) /data/wwwroot/mini/vendor/thinkphp/library/think/facade/Hook.php ( 1.46 KB ) /data/wwwroot/mini/vendor/thinkphp/library/think/facade/Cookie.php ( 1.58 KB ) /data/wwwroot/mini/vendor/thinkphp/library/think/facade/View.php ( 1.76 KB ) /data/wwwroot/mini/vendor/thinkcmf/cmf/src/behavior/HomeLangBehavior.php ( 1.52 KB ) /data/wwwroot/mini/vendor/thinkphp/library/think/db/Expression.php ( 1.11 KB ) /data/wwwroot/mini/vendor/thinkphp/library/think/facade/Session.php ( 2.05 KB ) /data/wwwroot/mini/app/admin/model/ThemeModel.php ( 8.12 KB ) /data/wwwroot/mini/vendor/thinkphp/library/think/Model.php ( 27.48 KB ) /data/wwwroot/mini/vendor/thinkphp/library/think/model/concern/Attribute.php ( 17.64 KB ) /data/wwwroot/mini/vendor/thinkphp/library/think/model/concern/RelationShip.php ( 19.85 KB ) /data/wwwroot/mini/vendor/thinkphp/library/think/model/concern/ModelEvent.php ( 6.04 KB ) /data/wwwroot/mini/vendor/thinkphp/library/think/model/concern/TimeStamp.php ( 2.58 KB ) /data/wwwroot/mini/vendor/thinkphp/library/think/model/concern/Conversion.php ( 7.83 KB ) /data/wwwroot/mini/data/runtime/temp/aa70a152217069ab5adadc8a57456cce.php ( 10.33 KB ) /data/wwwroot/mini/vendor/thinkcmf/cmf/src/lib/Storage.php ( 3.89 KB ) /data/wwwroot/mini/vendor/thinkcmf/cmf/src/lib/storage/Local.php ( 2.86 KB ) /data/wwwroot/mini/vendor/thinkphp/library/think/facade/Url.php ( 1.13 KB ) /data/wwwroot/mini/vendor/thinkphp/library/think/Url.php ( 13.22 KB ) /data/wwwroot/mini/vendor/thinkphp/library/think/Response.php ( 9.68 KB ) /data/wwwroot/mini/vendor/thinkphp/library/think/debug/Html.php ( 4.02 KB )
[ DB ] INIT mysql [ LANG ] /data/wwwroot/mini/app/portal//lang/cn.php [ ROUTE ] array (
) [ HEADER ] array (
'user-agent' => 'CCBot/2.0 (https://commoncrawl.org/faq/)',
'accept' => 'text/html,application/xhtml+xml,application/xml;q=0.9,*/*;q=0.8',
'accept-language' => 'en-US,en;q=0.5',
'accept-encoding' => 'br,gzip',
'host' => 'minicky.cn',
'connection' => 'Keep-Alive',
) [ PARAM ] array (
'id' => '400',
) [ VIEW ] /data/wwwroot/mini/public/themes/default/portal/mini_list/list_alone.html [ array (
0 => 'site_info',
1 => 'nav_top_list_menu',
2 => 'nav_bottom_list_menu',
3 => 'cateid',
4 => 'id',
5 => 'lang',
6 => 'cate_info',
7 => 'content',
8 => 'theme_vars',
9 => 'theme_widgets',
) ]
[ DB ] CONNECT:[ UseTime:0.000345s ] mysql:host=localhost;port=3306;dbname=miniqijt01;charset=utf8 [ SQL ] SHOW COLUMNS FROM `miniqi_hook` [ RunTime:0.000908s ] [ SQL ] SELECT `hook` FROM `miniqi_hook` WHERE `type` = 1 OR ( `type` = 3 AND ( `app` = '' or `app` = 'cmf' ) ) [ RunTime:0.000332s ] [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'miniqi_hook',
'type' => 'ALL',
'possible_keys' => NULL,
'key' => NULL,
'key_len' => NULL,
'ref' => NULL,
'rows' => 56,
'extra' => 'Using where',
) ] [ SQL ] SHOW COLUMNS FROM `miniqi_hook_plugin` [ RunTime:0.000809s ] [ SQL ] SELECT `hook`,`plugin` FROM `miniqi_hook_plugin` WHERE `status` = 1 AND `hook` IN ('app_begin','module_init','action_begin','view_filter','app_end','log_write','response_end','admin_init','home_init','send_mobile_verification_code','body_start','before_head_end','footer_start','before_footer','before_footer_end','before_body_end','left_sidebar_start','before_left_sidebar_end','right_sidebar_start','before_right_sidebar_end','comment','guestbook','switch_theme','after_content','before_content','log_write_done','switch_admin_theme','captcha_image') ORDER BY `list_order` ASC [ RunTime:0.000394s ] [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'miniqi_hook_plugin',
'type' => 'ALL',
'possible_keys' => NULL,
'key' => NULL,
'key_len' => NULL,
'ref' => NULL,
'rows' => 1,
'extra' => 'Using where; Using filesort',
) ] [ SQL ] SELECT `hook` FROM `miniqi_hook` WHERE `type` = 1 OR ( `type` = 3 AND ( `app` = '' or `app` = 'cmf' ) ) [ RunTime:0.000320s ] [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'miniqi_hook',
'type' => 'ALL',
'possible_keys' => NULL,
'key' => NULL,
'key_len' => NULL,
'ref' => NULL,
'rows' => 56,
'extra' => 'Using where',
) ] [ SQL ] SELECT `hook`,`plugin` FROM `miniqi_hook_plugin` WHERE `status` = 1 AND `hook` IN ('app_begin','module_init','action_begin','view_filter','app_end','log_write','response_end','admin_init','home_init','send_mobile_verification_code','body_start','before_head_end','footer_start','before_footer','before_footer_end','before_body_end','left_sidebar_start','before_left_sidebar_end','right_sidebar_start','before_right_sidebar_end','comment','guestbook','switch_theme','after_content','before_content','log_write_done','switch_admin_theme','captcha_image') ORDER BY `list_order` ASC [ RunTime:0.000368s ] [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'miniqi_hook_plugin',
'type' => 'ALL',
'possible_keys' => NULL,
'key' => NULL,
'key_len' => NULL,
'ref' => NULL,
'rows' => 1,
'extra' => 'Using where; Using filesort',
) ] [ SQL ] SHOW COLUMNS FROM `miniqi_option` [ RunTime:0.000807s ] [ SQL ] SELECT `option_value` FROM `miniqi_option` WHERE `option_name` = 'cdn_settings' LIMIT 1 [ RunTime:0.000209s ] [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => NULL,
'type' => NULL,
'possible_keys' => NULL,
'key' => NULL,
'key_len' => NULL,
'ref' => NULL,
'rows' => NULL,
'extra' => 'Impossible WHERE noticed after reading const tables',
) ] [ SQL ] SHOW COLUMNS FROM `miniqi_nav_menu` [ RunTime:0.000802s ] [ SQL ] SELECT `id`,`nav_id`,`name`,`parent_id`,`href`,`icon`,`target` FROM `miniqi_nav_menu` WHERE ( lang='cn' and status=1 and nav_id=1 ) ORDER BY `list_order` ASC,`id` ASC [ RunTime:0.000255s ] [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'miniqi_nav_menu',
'type' => 'ALL',
'possible_keys' => NULL,
'key' => NULL,
'key_len' => NULL,
'ref' => NULL,
'rows' => 1,
'extra' => 'Using where; Using filesort',
) ] [ SQL ] SELECT `id`,`nav_id`,`name`,`parent_id`,`href`,`icon`,`target` FROM `miniqi_nav_menu` WHERE ( lang='cn' and status=1 and nav_id=2 ) ORDER BY `list_order` ASC,`id` ASC [ RunTime:0.000271s ] [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'miniqi_nav_menu',
'type' => 'ALL',
'possible_keys' => NULL,
'key' => NULL,
'key_len' => NULL,
'ref' => NULL,
'rows' => 1,
'extra' => 'Using where; Using filesort',
) ] [ SQL ] SHOW COLUMNS FROM `miniqi_category` [ RunTime:0.000968s ] [ SQL ] SELECT * FROM `miniqi_category` WHERE ( id=400 ) LIMIT 1 [ RunTime:0.000477s ] [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'miniqi_category',
'type' => 'const',
'possible_keys' => 'PRIMARY',
'key' => 'PRIMARY',
'key_len' => '3',
'ref' => 'const',
'rows' => 1,
'extra' => NULL,
) ] [ SQL ] SHOW COLUMNS FROM `miniqi_maintb` [ RunTime:0.000869s ] [ SQL ] SELECT `id` FROM `miniqi_maintb` WHERE ( category=400 ) LIMIT 1 [ RunTime:0.001186s ] [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'miniqi_maintb',
'type' => 'ALL',
'possible_keys' => NULL,
'key' => NULL,
'key_len' => NULL,
'ref' => NULL,
'rows' => 1957,
'extra' => 'Using where',
) ] [ SQL ] SHOW COLUMNS FROM `miniqi_channel` [ RunTime:0.000737s ] [ SQL ] SELECT `m`.*,`c`.* FROM `miniqi_maintb` `m` LEFT JOIN `miniqi_alone` `c` ON `m`.`id`=`c`.`id` WHERE ( m.id=2119 ) LIMIT 1 [ RunTime:0.000449s ] [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'm',
'type' => 'const',
'possible_keys' => 'PRIMARY',
'key' => 'PRIMARY',
'key_len' => '3',
'ref' => 'const',
'rows' => 1,
'extra' => NULL,
) ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `miniqi_maintb` WHERE ( category=400 and id>2119 ) [ RunTime:0.000293s ] [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'miniqi_maintb',
'type' => 'range',
'possible_keys' => 'PRIMARY',
'key' => 'PRIMARY',
'key_len' => '3',
'ref' => NULL,
'rows' => 4,
'extra' => 'Using index condition; Using where',
) ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `miniqi_maintb` WHERE ( category=400 and id<2119 ) [ RunTime:0.001027s ] [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'miniqi_maintb',
'type' => 'ALL',
'possible_keys' => 'PRIMARY',
'key' => NULL,
'key_len' => NULL,
'ref' => NULL,
'rows' => 1957,
'extra' => 'Using where',
) ] [ SQL ] SHOW COLUMNS FROM `miniqi_theme_file` [ RunTime:0.000748s ] [ SQL ] SELECT * FROM `miniqi_theme_file` WHERE `theme` = 'default' [ RunTime:0.000223s ] [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'miniqi_theme_file',
'type' => 'ALL',
'possible_keys' => NULL,
'key' => NULL,
'key_len' => NULL,
'ref' => NULL,
'rows' => 1,
'extra' => 'Using where',
) ] [ SQL ] SHOW COLUMNS FROM `miniqi_theme` [ RunTime:0.000734s ] [ SQL ] UPDATE `miniqi_theme` SET `name` = 'default' , `version` = '1.0.0' , `demo_url` = 'http://demo.thinkcmf.com' , `author` = 'ThinkCMF' , `lang` = 'zh-cn' , `author_url` = 'http://www.thinkcmf.com' , `keywords` = 'ThinkCMF默认模板' , `description` = 'ThinkCMF默认模板' WHERE `theme` = 'default' [ RunTime:0.000302s ] [ SQL ] SELECT `more` FROM `miniqi_theme_file` WHERE `theme` = 'default' AND ( `is_public` = 1 OR `file` = 'portal/mini_list/list_alone' ) [ RunTime:0.000221s ] [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'miniqi_theme_file',
'type' => 'ALL',
'possible_keys' => NULL,
'key' => NULL,
'key_len' => NULL,
'ref' => NULL,
'rows' => 1,
'extra' => 'Using where',
) ] [ SQL ] SHOW COLUMNS FROM `miniqi_cmsinfo` [ RunTime:0.000687s ] [ SQL ] SHOW COLUMNS FROM `miniqi_flash_ad` [ RunTime:0.000687s ] [ SQL ] SELECT * FROM `miniqi_flash_ad` WHERE ( number ='1'and lang='cn' ) [ RunTime:0.000183s ] [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'miniqi_flash_ad',
'type' => 'ALL',
'possible_keys' => NULL,
'key' => NULL,
'key_len' => NULL,
'ref' => NULL,
'rows' => 6,
'extra' => 'Using where',
) ] [ SQL ] SELECT * FROM `miniqi_flash_ad` WHERE ( number ='6'and lang='cn' ) [ RunTime:0.000191s ] [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'miniqi_flash_ad',
'type' => 'ALL',
'possible_keys' => NULL,
'key' => NULL,
'key_len' => NULL,
'ref' => NULL,
'rows' => 6,
'extra' => 'Using where',
) ] [ SQL ] SELECT `option_value` FROM `miniqi_option` WHERE `option_name` = 'storage' LIMIT 1 [ RunTime:0.000186s ] [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => NULL,
'type' => NULL,
'possible_keys' => NULL,
'key' => NULL,
'key_len' => NULL,
'ref' => NULL,
'rows' => NULL,
'extra' => 'Impossible WHERE noticed after reading const tables',
) ] [ SQL ] SELECT * FROM `miniqi_category` WHERE ( id=400 ) LIMIT 1 [ RunTime:0.000275s ] [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'miniqi_category',
'type' => 'const',
'possible_keys' => 'PRIMARY',
'key' => 'PRIMARY',
'key_len' => '3',
'ref' => 'const',
'rows' => 1,
'extra' => NULL,
) ] [ SQL ] SELECT * FROM `miniqi_channel` WHERE ( id=1 ) LIMIT 1 [ RunTime:0.000211s ] [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'miniqi_channel',
'type' => 'const',
'possible_keys' => 'PRIMARY',
'key' => 'PRIMARY',
'key_len' => '3',
'ref' => 'const',
'rows' => 1,
'extra' => NULL,
) ] [ SQL ] SELECT * FROM `miniqi_category` WHERE ( cate_parent=13 ) [ RunTime:0.000272s ] [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'miniqi_category',
'type' => 'ALL',
'possible_keys' => NULL,
'key' => NULL,
'key_len' => NULL,
'ref' => NULL,
'rows' => 357,
'extra' => 'Using where',
) ] [ SQL ] SELECT * FROM `miniqi_category` WHERE ( cate_parent=40 ) [ RunTime:0.000279s ] [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'miniqi_category',
'type' => 'ALL',
'possible_keys' => NULL,
'key' => NULL,
'key_len' => NULL,
'ref' => NULL,
'rows' => 357,
'extra' => 'Using where',
) ] [ SQL ] SELECT * FROM `miniqi_category` WHERE ( cate_parent=330 ) [ RunTime:0.000248s ] [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'miniqi_category',
'type' => 'ALL',
'possible_keys' => NULL,
'key' => NULL,
'key_len' => NULL,
'ref' => NULL,
'rows' => 357,
'extra' => 'Using where',
) ] [ SQL ] SELECT * FROM `miniqi_category` WHERE ( cate_parent=60 ) [ RunTime:0.000250s ] [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'miniqi_category',
'type' => 'ALL',
'possible_keys' => NULL,
'key' => NULL,
'key_len' => NULL,
'ref' => NULL,
'rows' => 357,
'extra' => 'Using where',
) ] [ SQL ] SELECT * FROM `miniqi_category` WHERE ( cate_parent=331 ) [ RunTime:0.000265s ] [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'miniqi_category',
'type' => 'ALL',
'possible_keys' => NULL,
'key' => NULL,
'key_len' => NULL,
'ref' => NULL,
'rows' => 357,
'extra' => 'Using where',
) ] [ SQL ] SELECT * FROM `miniqi_category` WHERE ( cate_parent=332 ) [ RunTime:0.000252s ] [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'miniqi_category',
'type' => 'ALL',
'possible_keys' => NULL,
'key' => NULL,
'key_len' => NULL,
'ref' => NULL,
'rows' => 357,
'extra' => 'Using where',
) ] [ SQL ] SELECT * FROM `miniqi_category` WHERE ( cate_parent=333 ) [ RunTime:0.000242s ] [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'miniqi_category',
'type' => 'ALL',
'possible_keys' => NULL,
'key' => NULL,
'key_len' => NULL,
'ref' => NULL,
'rows' => 357,
'extra' => 'Using where',
) ] [ SQL ] SELECT * FROM `miniqi_category` WHERE ( cate_parent=334 ) [ RunTime:0.000266s ] [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'miniqi_category',
'type' => 'ALL',
'possible_keys' => NULL,
'key' => NULL,
'key_len' => NULL,
'ref' => NULL,
'rows' => 357,
'extra' => 'Using where',
) ] [ SQL ] SELECT * FROM `miniqi_category` WHERE ( cate_parent=335 ) [ RunTime:0.000256s ] [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'miniqi_category',
'type' => 'ALL',
'possible_keys' => NULL,
'key' => NULL,
'key_len' => NULL,
'ref' => NULL,
'rows' => 357,
'extra' => 'Using where',
) ] [ SQL ] SELECT * FROM `miniqi_category` WHERE ( cate_parent=400 ) [ RunTime:0.000257s ] [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'miniqi_category',
'type' => 'ALL',
'possible_keys' => NULL,
'key' => NULL,
'key_len' => NULL,
'ref' => NULL,
'rows' => 357,
'extra' => 'Using where',
) ] [ SQL ] SELECT * FROM `miniqi_category` WHERE ( cate_parent=369 ) [ RunTime:0.000238s ] [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'miniqi_category',
'type' => 'ALL',
'possible_keys' => NULL,
'key' => NULL,
'key_len' => NULL,
'ref' => NULL,
'rows' => 357,
'extra' => 'Using where',
) ] [ SQL ] SELECT * FROM `miniqi_category` WHERE ( cate_parent=384 ) [ RunTime:0.000242s ] [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'miniqi_category',
'type' => 'ALL',
'possible_keys' => NULL,
'key' => NULL,
'key_len' => NULL,
'ref' => NULL,
'rows' => 357,
'extra' => 'Using where',
) ] [ SQL ] SELECT * FROM `miniqi_category` WHERE ( cate_parent=401 ) [ RunTime:0.000256s ] [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'miniqi_category',
'type' => 'ALL',
'possible_keys' => NULL,
'key' => NULL,
'key_len' => NULL,
'ref' => NULL,
'rows' => 357,
'extra' => 'Using where',
) ] [ SQL ] SELECT `m`.*,`f`.* FROM `miniqi_maintb` `m` LEFT JOIN `miniqi_alone` `f` ON `f`.`id`=`m`.`id` WHERE ( m.id=f.id and m.verify=0 and m.category in (13,40,330,60,331,332,333,334,335,400,369,384,401) and m.lang='cn' ) GROUP BY `m`.`id` ORDER BY `m`.`id` ASC LIMIT 0,20 [ RunTime:0.000373s ] [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'f',
'type' => 'ALL',
'possible_keys' => 'PRIMARY',
'key' => NULL,
'key_len' => NULL,
'ref' => NULL,
'rows' => 61,
'extra' => 'Using where; Using temporary; Using filesort',
) ]
0.054788s