学生风采News
礼仪队服务中国西部不锈钢城乐山沙湾投资促进会
2013-04-07
基本
文件
流程
错误
SQL
调试
请求信息 : 2025-01-15 23:10:38 HTTP/1.0 GET : cj.lszyxy.edu.cn/sxfc/673.html 运行时间 : 0.703125s [ 吞吐率：1.42req/s ] 内存消耗：5,590.71kb 文件加载：158 查询信息 : 30 queries 1 writes 缓存信息 : 1 reads,0 writes 配置加载 : 67
[ CACHE ] INIT File [ BEHAVIOR ] Run cmf\behavior\InitHookBehavior @app_init [ RunTime:0.000000s ] [ LANG ] D:\IIS_WebSite\think_cjx\simplewind\thinkphp\lang\zh-cn.php [ ROUTE ] array (
'type' => 'module',
'module' =>
array (
0 => 'portal',
1 => 'Article',
2 => 'index',
),
'convert' => false,
) [ HEADER ] array (
'content-type' => '',
'content-length' => '0',
'x-original-url' => '/sxfc/673.html',
'x-forwarded-for' => '3.141.32.252',
'user-agent' => 'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)',
'host' => 'cj.lszyxy.edu.cn',
'cookie' => 'aoji_uuid=bb43fbf6d5c04671bf61ec31ab6418c7_20250115; aoji_session_uuid=11f7f843fedd4c1c81e11538138561f7_20250115',
'accept-encoding' => 'gzip, br, zstd, deflate',
'accept' => '*/*',
'connection' => 'close',
) [ PARAM ] array (
'id' => '673',
'cid' => '29',
) [ LANG ] D:\IIS_WebSite\think_cjx\simplewind\cmf\behavior/../lang\zh-cn.php [ LANG ] D:\IIS_WebSite\think_cjx\public/../app/admin\lang\zh-cn\common.php [ LANG ] D:\IIS_WebSite\think_cjx\public/../app/portal\lang\zh-cn\common.php [ BEHAVIOR ] Run cmf\behavior\LangBehavior @app_begin [ RunTime:0.000000s ] [ LANG ] D:\IIS_WebSite\think_cjx\public/../app/portal\lang\zh-cn.php [ BEHAVIOR ] Run cmf\behavior\InitAppHookBehavior @module_init [ RunTime:0.015625s ] [ LANG ] D:\IIS_WebSite\think_cjx\public/../app/portal\lang\zh-cn\home.php [ BEHAVIOR ] Run cmf\behavior\HomeLangBehavior @home_init [ RunTime:0.000000s ] [ RUN ] app\portal\controller\ArticleController->index[ D:\IIS_WebSite\think_cjx\app\portal\controller\ArticleController.php ] [ DB ] INIT mysql [ VIEW ] D:\IIS_WebSite\think_cjx\public/themes/zhiyuan/portal\article.html [ array (
0 => 'site_info',
1 => 'category',
2 => 'article',
3 => 'prev_article',
4 => 'next_article',
5 => 'theme_vars',
6 => 'theme_widgets',
) ]
[ DB ] CONNECT:[ UseTime:0.031250s ] mysql:host=10.0.10.105;port=3306;dbname=thinkcmf5;charset=utf8mb4 [ SQL ] SHOW COLUMNS FROM `cmf_portal_post` [ RunTime:0.000000s ] [ SQL ] SELECT `post`.* FROM `cmf_portal_post` `post` INNER JOIN `cmf_portal_category_post` `relation` ON `post`.`id`=`relation`.`post_id` WHERE `post`.`post_type` = 1 AND `post`.`post_status` = 1 AND `post`.`delete_time` = 0 AND `relation`.`category_id` = '29' AND `relation`.`post_id` = '673' AND ( `post`.`published_time` < '1736953838' and `post`.`published_time` > '0' ) LIMIT 1 [ RunTime:0.000000s ] [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'post',
'partitions' => NULL,
'type' => 'const',
'possible_keys' => 'PRIMARY,type_status_date',
'key' => 'PRIMARY',
'key_len' => '8',
'ref' => 'const',
'rows' => 1,
'filtered' => 100.0,
'extra' => NULL,
) ] [ SQL ] SELECT `post`.* FROM `cmf_portal_post` `post` INNER JOIN `cmf_portal_category_post` `relation` ON `post`.`id`=`relation`.`post_id` WHERE `post`.`post_type` = 1 AND `post`.`post_status` = 1 AND `post`.`delete_time` = 0 AND `relation`.`category_id` = '29' AND `relation`.`post_id` < '673' AND ( `post`.`published_time` < '1736953838' and `post`.`published_time` > '0' ) ORDER BY `id` DESC LIMIT 1 [ RunTime:0.015625s ] [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'relation',
'partitions' => NULL,
'type' => 'ref',
'possible_keys' => 'term_taxonomy_id',
'key' => 'term_taxonomy_id',
'key_len' => '8',
'ref' => 'const',
'rows' => 223,
'filtered' => 33.32999801635742,
'extra' => 'Using index condition; Using where; Using temporary; Using filesort',
) ] [ SQL ] SELECT `post`.* FROM `cmf_portal_post` `post` INNER JOIN `cmf_portal_category_post` `relation` ON `post`.`id`=`relation`.`post_id` WHERE `post`.`post_type` = 1 AND `post`.`post_status` = 1 AND `post`.`delete_time` = 0 AND `relation`.`category_id` = '29' AND `relation`.`post_id` > '673' AND ( `post`.`published_time` < '1736953838' and `post`.`published_time` > '0' ) ORDER BY `id` ASC LIMIT 1 [ RunTime:0.015625s ] [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'relation',
'partitions' => NULL,
'type' => 'ref',
'possible_keys' => 'term_taxonomy_id',
'key' => 'term_taxonomy_id',
'key_len' => '8',
'ref' => 'const',
'rows' => 223,
'filtered' => 33.32999801635742,
'extra' => 'Using index condition; Using where; Using temporary; Using filesort',
) ] [ SQL ] SHOW COLUMNS FROM `cmf_portal_category` [ RunTime:0.000000s ] [ SQL ] SELECT * FROM `cmf_portal_category` WHERE `id` = 29 AND `status` = 1 LIMIT 1 [ RunTime:0.015625s ] [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_portal_category',
'partitions' => NULL,
'type' => 'const',
'possible_keys' => 'PRIMARY',
'key' => 'PRIMARY',
'key_len' => '8',
'ref' => 'const',
'rows' => 1,
'filtered' => 100.0,
'extra' => NULL,
) ] [ SQL ] UPDATE `cmf_portal_post` SET `post_hits`=`post_hits`+1 WHERE `id` = 673 [ RunTime:0.000000s ] [ SQL ] SHOW COLUMNS FROM `cmf_theme_file` [ RunTime:0.015625s ] [ SQL ] SELECT `more` FROM `cmf_theme_file` WHERE `theme` = 'zhiyuan' AND ( `is_public` = 1 OR `file` = 'portal/article' ) [ RunTime:0.000000s ] [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_theme_file',
'partitions' => NULL,
'type' => 'ALL',
'possible_keys' => NULL,
'key' => NULL,
'key_len' => NULL,
'ref' => NULL,
'rows' => 8,
'filtered' => 12.5,
'extra' => 'Using where',
) ] [ SQL ] SHOW COLUMNS FROM `cmf_nav` [ RunTime:0.000000s ] [ SQL ] SELECT `id` FROM `cmf_nav` WHERE `is_main` = 1 LIMIT 1 [ RunTime:0.015625s ] [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_nav',
'partitions' => NULL,
'type' => 'ALL',
'possible_keys' => NULL,
'key' => NULL,
'key_len' => NULL,
'ref' => NULL,
'rows' => 2,
'filtered' => 50.0,
'extra' => 'Using where',
) ] [ SQL ] SHOW COLUMNS FROM `cmf_nav_menu` [ RunTime:0.015625s ] [ SQL ] SELECT * FROM `cmf_nav_menu` WHERE `nav_id` = 1 AND `status` = 1 ORDER BY `list_order` ASC [ RunTime:0.000000s ] [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_nav_menu',
'partitions' => NULL,
'type' => 'ALL',
'possible_keys' => NULL,
'key' => NULL,
'key_len' => NULL,
'ref' => NULL,
'rows' => 42,
'filtered' => 2.3809523582458496,
'extra' => 'Using where; Using filesort',
) ] [ SQL ] SHOW COLUMNS FROM `cmf_option` [ RunTime:0.000000s ] [ SQL ] SELECT `option_value` FROM `cmf_option` WHERE `option_name` = 'storage' LIMIT 1 [ RunTime:0.031250s ] [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => NULL,
'partitions' => NULL,
'type' => NULL,
'possible_keys' => NULL,
'key' => NULL,
'key_len' => NULL,
'ref' => NULL,
'rows' => NULL,
'filtered' => NULL,
'extra' => 'no matching row in const table',
) ] [ SQL ] SELECT * FROM `cmf_portal_category` WHERE `delete_time` = 0 ORDER BY `list_order` ASC [ RunTime:0.015625s ] [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_portal_category',
'partitions' => NULL,
'type' => 'ALL',
'possible_keys' => NULL,
'key' => NULL,
'key_len' => NULL,
'ref' => NULL,
'rows' => 54,
'filtered' => 10.0,
'extra' => 'Using where; Using filesort',
) ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `cmf_portal_post` `a` INNER JOIN `cmf_user` `u` ON `a`.`user_id`=`u`.`id` INNER JOIN `cmf_portal_category_post` `b` ON `a`.`id`=`b`.`post_id` WHERE `a`.`create_time` >= 0 AND `a`.`delete_time` = 0 AND ( `b`.`category_id` IN ('41','42','43') AND `a`.`post_type` = 1 ) LIMIT 1 [ RunTime:0.000000s ] [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'b',
'partitions' => NULL,
'type' => 'range',
'possible_keys' => 'term_taxonomy_id',
'key' => 'term_taxonomy_id',
'key_len' => '8',
'ref' => NULL,
'rows' => 85,
'filtered' => 100.0,
'extra' => 'Using index condition',
) ] [ SQL ] SELECT `a`.*,b.id AS post_category_id,`b`.`list_order`,`b`.`category_id`,`u`.`user_login`,`u`.`user_nickname`,`u`.`user_email` FROM `cmf_portal_post` `a` INNER JOIN `cmf_user` `u` ON `a`.`user_id`=`u`.`id` INNER JOIN `cmf_portal_category_post` `b` ON `a`.`id`=`b`.`post_id` WHERE `a`.`create_time` >= 0 AND `a`.`delete_time` = 0 AND ( `b`.`category_id` IN ('41','42','43') AND `a`.`post_type` = 1 ) ORDER BY `update_time` DESC LIMIT 0,10 [ RunTime:0.031250s ] [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'b',
'partitions' => NULL,
'type' => 'range',
'possible_keys' => 'term_taxonomy_id',
'key' => 'term_taxonomy_id',
'key_len' => '8',
'ref' => NULL,
'rows' => 85,
'filtered' => 100.0,
'extra' => 'Using index condition; Using temporary; Using filesort',
) ] [ SQL ] SELECT * FROM `cmf_portal_category` WHERE `status` = 1 AND `delete_time` = 0 AND `id` = 22 LIMIT 1 [ RunTime:0.000000s ] [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_portal_category',
'partitions' => NULL,
'type' => 'const',
'possible_keys' => 'PRIMARY',
'key' => 'PRIMARY',
'key_len' => '8',
'ref' => 'const',
'rows' => 1,
'filtered' => 100.0,
'extra' => NULL,
) ] [ SQL ] SELECT `path` FROM `cmf_portal_category` WHERE `id` = 22 LIMIT 1 [ RunTime:0.000000s ] [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_portal_category',
'partitions' => NULL,
'type' => 'const',
'possible_keys' => 'PRIMARY',
'key' => 'PRIMARY',
'key_len' => '8',
'ref' => 'const',
'rows' => 1,
'filtered' => 100.0,
'extra' => NULL,
) ] [ SQL ] SELECT * FROM `cmf_portal_category` WHERE `status` = 1 AND `delete_time` = 0 AND `path` LIKE '0-21-22-%' [ RunTime:0.000000s ] [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_portal_category',
'partitions' => NULL,
'type' => 'ALL',
'possible_keys' => NULL,
'key' => NULL,
'key_len' => NULL,
'ref' => NULL,
'rows' => 54,
'filtered' => 1.8518518209457397,
'extra' => 'Using where',
) ] [ SQL ] SELECT `post`.*,`category_post`.`category_id` FROM `cmf_portal_post` `post` INNER JOIN `cmf_portal_category_post` `category_post` ON `post`.`id`=`category_post`.`post_id` WHERE `post`.`post_status` = 1 AND `post`.`post_type` = 1 AND `post`.`delete_time` = 0 AND ( post.is_top=1 ) AND ( `category_post`.`category_id` = '22' ) AND ( `post`.`published_time` > '0' and `post`.`published_time` < 1736953839 ) GROUP BY `post`.`id` ORDER BY `category_post`.`list_order`,`post`.`published_time` DESC LIMIT 1 [ RunTime:0.015625s ] [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'category_post',
'partitions' => NULL,
'type' => 'ref',
'possible_keys' => 'term_taxonomy_id',
'key' => 'term_taxonomy_id',
'key_len' => '8',
'ref' => 'const',
'rows' => 104,
'filtered' => 100.0,
'extra' => 'Using index condition; Using temporary; Using filesort',
) ] [ SQL ] SELECT `post`.*,`category_post`.`category_id` FROM `cmf_portal_post` `post` INNER JOIN `cmf_portal_category_post` `category_post` ON `post`.`id`=`category_post`.`post_id` WHERE `post`.`post_status` = 1 AND `post`.`post_type` = 1 AND `post`.`delete_time` = 0 AND ( `category_post`.`category_id` = '22' ) AND ( `post`.`published_time` > '0' and `post`.`published_time` < 1736953839 ) GROUP BY `post`.`id` ORDER BY `post`.`recommended`,`post`.`is_top`,`category_post`.`list_order`,`post`.`published_time` DESC LIMIT 5 [ RunTime:0.015625s ] [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'category_post',
'partitions' => NULL,
'type' => 'ref',
'possible_keys' => 'term_taxonomy_id',
'key' => 'term_taxonomy_id',
'key_len' => '8',
'ref' => 'const',
'rows' => 104,
'filtered' => 100.0,
'extra' => 'Using index condition; Using temporary; Using filesort',
) ] [ SQL ] SELECT * FROM `cmf_portal_category` WHERE `status` = 1 AND `delete_time` = 0 AND `id` = 44 LIMIT 1 [ RunTime:0.015625s ] [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_portal_category',
'partitions' => NULL,
'type' => 'const',
'possible_keys' => 'PRIMARY',
'key' => 'PRIMARY',
'key_len' => '8',
'ref' => 'const',
'rows' => 1,
'filtered' => 100.0,
'extra' => NULL,
) ] [ SQL ] SELECT `path` FROM `cmf_portal_category` WHERE `id` = 44 LIMIT 1 [ RunTime:0.015625s ] [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_portal_category',
'partitions' => NULL,
'type' => 'const',
'possible_keys' => 'PRIMARY',
'key' => 'PRIMARY',
'key_len' => '8',
'ref' => 'const',
'rows' => 1,
'filtered' => 100.0,
'extra' => NULL,
) ] [ SQL ] SELECT * FROM `cmf_portal_category` WHERE `status` = 1 AND `delete_time` = 0 AND `path` LIKE '0-8-44-%' [ RunTime:0.015625s ] [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_portal_category',
'partitions' => NULL,
'type' => 'ALL',
'possible_keys' => NULL,
'key' => NULL,
'key_len' => NULL,
'ref' => NULL,
'rows' => 54,
'filtered' => 1.8518518209457397,
'extra' => 'Using where',
) ] [ SQL ] SELECT `post`.*,`category_post`.`category_id` FROM `cmf_portal_post` `post` INNER JOIN `cmf_portal_category_post` `category_post` ON `post`.`id`=`category_post`.`post_id` WHERE `post`.`post_status` = 1 AND `post`.`post_type` = 1 AND `post`.`delete_time` = 0 AND ( post.is_top=1 ) AND ( `category_post`.`category_id` = '44' ) AND ( `post`.`published_time` > '0' and `post`.`published_time` < 1736953839 ) GROUP BY `post`.`id` ORDER BY `category_post`.`list_order`,`post`.`published_time` DESC LIMIT 1 [ RunTime:0.015625s ] [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'category_post',
'partitions' => NULL,
'type' => 'ref',
'possible_keys' => 'term_taxonomy_id',
'key' => 'term_taxonomy_id',
'key_len' => '8',
'ref' => 'const',
'rows' => 2082,
'filtered' => 100.0,
'extra' => 'Using index condition; Using temporary; Using filesort',
) ] [ SQL ] SELECT `post`.*,`category_post`.`category_id` FROM `cmf_portal_post` `post` INNER JOIN `cmf_portal_category_post` `category_post` ON `post`.`id`=`category_post`.`post_id` WHERE `post`.`post_status` = 1 AND `post`.`post_type` = 1 AND `post`.`delete_time` = 0 AND ( post.id != 5218 ) AND ( `category_post`.`category_id` = '44' ) AND ( `post`.`published_time` > '0' and `post`.`published_time` < 1736953839 ) GROUP BY `post`.`id` ORDER BY `post`.`recommended`,`post`.`is_top`,`category_post`.`list_order`,`post`.`published_time` DESC LIMIT 5 [ RunTime:0.031250s ] [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'category_post',
'partitions' => NULL,
'type' => 'ref',
'possible_keys' => 'term_taxonomy_id',
'key' => 'term_taxonomy_id',
'key_len' => '8',
'ref' => 'const',
'rows' => 2082,
'filtered' => 100.0,
'extra' => 'Using index condition; Using where; Using temporary; Using filesort',
) ] [ SQL ] SELECT * FROM `cmf_nav_menu` WHERE `nav_id` = 2 AND `status` = 1 ORDER BY `list_order` ASC [ RunTime:0.015625s ] [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_nav_menu',
'partitions' => NULL,
'type' => 'ALL',
'possible_keys' => NULL,
'key' => NULL,
'key_len' => NULL,
'ref' => NULL,
'rows' => 42,
'filtered' => 2.3809523582458496,
'extra' => 'Using where; Using filesort',
) ] [ SQL ] SHOW COLUMNS FROM `cmf_link` [ RunTime:0.000000s ] [ SQL ] SELECT * FROM `cmf_link` WHERE `status` = 1 ORDER BY `list_order` ASC [ RunTime:0.015625s ] [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_link',
'partitions' => NULL,
'type' => 'ALL',
'possible_keys' => 'status',
'key' => NULL,
'key_len' => NULL,
'ref' => NULL,
'rows' => 9,
'filtered' => 100.0,
'extra' => 'Using where; Using filesort',
) ]
0.703125s
