基本
文件
流程
错误
SQL
调试
- 请求信息 : 2024-03-19 17:42:45 HTTP/1.1 GET : http://jh.inmotiongame.com/info/allnews.html
- 运行时间 : 0.116917s [ 吞吐率:8.55req/s ] 内存消耗:4,740.28kb 文件加载:116
- 查询信息 : 24 queries 8 writes
- 缓存信息 : 5 reads,0 writes
- [ LANG ] /home/www/xyzjh/vendor/thinkphp/lang/zh-cn.php
- [ DB ] INIT mysql
- [ LANG ] /home/www/xyzjh/app/portal//lang/zh-cn.php
- [ ROUTE ] array (
'rule' => 'info/allnews',
'route' => 'portal/List/index?id=10',
'option' =>
array (
'merge_rule_regex' => false,
),
'var' =>
array (
),
)
- [ HEADER ] array (
'host' => 'jh.inmotiongame.com',
'user-agent' => 'claudebot',
'accept' => '*/*',
'content-length' => '',
'content-type' => '',
)
- [ PARAM ] array (
'id' => '10',
)
- [ LANG ] /home/www/xyzjh/vendor/thinkcmf/cmf/src/behavior/../lang/zh-cn.php
- [ LANG ] /home/www/xyzjh/vendor/thinkcmf/cmf-app/src/admin/lang/zh-cn.php
- [ LANG ] /home/www/xyzjh/vendor/thinkcmf/cmf-app/src/admin/lang/zh-cn/common.php
- [ LANG ] /home/www/xyzjh/vendor/thinkcmf/cmf-app/src/user/lang/zh-cn.php
- [ LANG ] /home/www/xyzjh/app/portal/lang/zh-cn/common.php
- [ LANG ] /home/www/xyzjh/app/portal/lang/zh-cn/home.php
- [ VIEW ] /home/www/xyzjh/public/themes/web_v1/portal/info/allnews.html [ array (
0 => 'site_info',
1 => 'category',
2 => 'theme_vars',
3 => 'theme_widgets',
) ]
- [ DB ] CONNECT:[ UseTime:0.000497s ] mysql:host=127.0.0.1;port=3306;dbname=5website;charset=utf8
- [ SQL ] SHOW COLUMNS FROM `ow_hook` [ RunTime:0.001604s ]
- [ SQL ] SELECT `hook` FROM `ow_hook` WHERE `type` = 1 OR ( `type` = 3 AND ( `app` = '' or `app` = 'cmf' ) ) [ RunTime:0.000606s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'ow_hook',
'partitions' => NULL,
'type' => 'ALL',
'possible_keys' => NULL,
'key' => NULL,
'key_len' => NULL,
'ref' => NULL,
'rows' => 70,
'filtered' => 11.710000038146973,
'extra' => 'Using where',
) ]
- [ SQL ] SHOW COLUMNS FROM `ow_hook_plugin` [ RunTime:0.000922s ]
- [ SQL ] SELECT `hook`,`plugin` FROM `ow_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.000550s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'ow_hook_plugin',
'partitions' => NULL,
'type' => 'ALL',
'possible_keys' => NULL,
'key' => NULL,
'key_len' => NULL,
'ref' => NULL,
'rows' => 1,
'filtered' => 100.0,
'extra' => 'Using where; Using filesort',
) ]
- [ SQL ] SHOW COLUMNS FROM `ow_portal_category` [ RunTime:0.001187s ]
- [ SQL ] SELECT * FROM `ow_portal_category` WHERE `id` = 10 AND `status` = 1 LIMIT 1 [ RunTime:0.000522s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'ow_portal_category',
'partitions' => NULL,
'type' => 'const',
'possible_keys' => 'PRIMARY',
'key' => 'PRIMARY',
'key_len' => '8',
'ref' => 'const',
'rows' => 1,
'filtered' => 100.0,
'extra' => NULL,
) ]
- [ SQL ] SHOW COLUMNS FROM `ow_theme_file` [ RunTime:0.001084s ]
- [ SQL ] SELECT * FROM `ow_theme_file` WHERE `theme` = 'web_v1' AND `file` = 'portal/article' LIMIT 1 [ RunTime:0.000543s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'ow_theme_file',
'partitions' => NULL,
'type' => 'ALL',
'possible_keys' => NULL,
'key' => NULL,
'key_len' => NULL,
'ref' => NULL,
'rows' => 26,
'filtered' => 3.846153736114502,
'extra' => 'Using where',
) ]
- [ SQL ] UPDATE `ow_theme_file` SET `theme` = 'web_v1' , `action` = 'portal/Article/index' , `file` = 'portal/article' , `name` = '文章页' , `more` = '[]' , `config_more` = '[]' , `description` = '文章页模板文件' , `is_public` = 0 , `list_order` = 10 WHERE `theme` = 'web_v1' AND `file` = 'portal/article' [ RunTime:0.010151s ]
- [ SQL ] SELECT * FROM `ow_theme_file` WHERE `theme` = 'web_v1' AND `file` = 'portal/index' LIMIT 1 [ RunTime:0.000441s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'ow_theme_file',
'partitions' => NULL,
'type' => 'ALL',
'possible_keys' => NULL,
'key' => NULL,
'key_len' => NULL,
'ref' => NULL,
'rows' => 26,
'filtered' => 3.846153736114502,
'extra' => 'Using where',
) ]
- [ SQL ] UPDATE `ow_theme_file` SET `theme` = 'web_v1' , `action` = 'portal/Index/index' , `file` = 'portal/index' , `name` = '首页' , `more` = '{\"widgets\":{\"allnews\":{\"title\":\"\\u9996\\u9875\\u6700\\u65b0\\u4fe1\\u606f(\\u5305\\u542b\\u653b\\u7565-\\u516c\\u544a)\",\"name\":\"allnew\",\"display\":1,\"vars\":{\"allnewId\":{\"title\":\"\\u6700\\u65b0\",\"value\":\"10\",\"type\":\"text\",\"tip\":\"\\u4e2d\\u90e8\\u53f3\\u4e0a\\u6700\\u65b0\\u6587\\u7ae0\",\"rule\":{\"require\":true}}}},\"notices\":{\"title\":\"\\u9996\\u9875-\\u516c\\u544a\",\"name\":\"notice\",\"display\":1,\"vars\":{\"noticeId\":{\"title\":\"\\u516c\\u544a\",\"value\":\"4\",\"type\":\"text\",\"tip\":\"\\u4e2d\\u90e8\\u53f3\\u4e0a\\u516c\\u544a\\u6587\\u7ae0\",\"rule\":{\"require\":true}}}},\"gongls\":{\"title\":\"\\u9996\\u9875-\\u653b\\u7565\",\"name\":\"gongl\",\"display\":1,\"vars\":{\"gonglId\":{\"title\":\"\\u653b\\u7565\",\"value\":\"2\",\"type\":\"text\",\"tip\":\"\",\"rule\":{\"require\":true}}}},\"activity\":{\"title\":\"\\u9996\\u9875-\\u6d3b\\u52a8\",\"name\":\"activit\",\"display\":1,\"vars\":{\"activityId\":{\"title\":\"\\u6d3b\\u52a8\",\"value\":\"3\",\"type\":\"text\",\"tip\":\"\",\"rule\":{\"require\":true}}}},\"complexs\":{\"title\":\"\\u9996\\u9875-\\u7efc\\u5408\",\"name\":\"complex\",\"display\":1,\"vars\":{\"complexId\":{\"title\":\"\\u7efc\\u5408\",\"value\":\"1\",\"type\":\"text\",\"tip\":\"\",\"rule\":{\"require\":true}}}}}}' , `config_more` = '{\"widgets\":{\"allnews\":{\"title\":\"\\u9996\\u9875\\u6700\\u65b0\\u4fe1\\u606f(\\u5305\\u542b\\u653b\\u7565-\\u516c\\u544a)\",\"name\":\"allnew\",\"display\":1,\"vars\":{\"allnewId\":{\"title\":\"\\u6700\\u65b0\",\"value\":\"1\",\"type\":\"text\",\"tip\":\"\\u4e2d\\u90e8\\u53f3\\u4e0a\\u6700\\u65b0\\u6587\\u7ae0\",\"rule\":{\"require\":true}}}},\"notices\":{\"title\":\"\\u9996\\u9875-\\u516c\\u544a\",\"name\":\"notice\",\"display\":1,\"vars\":{\"noticeId\":{\"title\":\"\\u516c\\u544a\",\"value\":\"2\",\"type\":\"text\",\"tip\":\"\\u4e2d\\u90e8\\u53f3\\u4e0a\\u516c\\u544a\\u6587\\u7ae0\",\"rule\":{\"require\":true}}}},\"gongls\":{\"title\":\"\\u9996\\u9875-\\u653b\\u7565\",\"name\":\"gongl\",\"display\":1,\"vars\":{\"gonglId\":{\"title\":\"\\u653b\\u7565\",\"value\":\"5\",\"type\":\"text\",\"tip\":\"\",\"rule\":{\"require\":true}}}},\"activity\":{\"title\":\"\\u9996\\u9875-\\u6d3b\\u52a8\",\"name\":\"activit\",\"display\":1,\"vars\":{\"activityId\":{\"title\":\"\\u6d3b\\u52a8\",\"value\":\"\",\"type\":\"text\",\"tip\":\"\",\"rule\":{\"require\":true}}}},\"complexs\":{\"title\":\"\\u9996\\u9875-\\u7efc\\u5408\",\"name\":\"complex\",\"display\":1,\"vars\":{\"complexId\":{\"title\":\"\\u7efc\\u5408\",\"value\":\"\",\"type\":\"text\",\"tip\":\"\",\"rule\":{\"require\":true}}}}}}' , `description` = '首页文件' , `is_public` = 0 , `list_order` = 5 WHERE `theme` = 'web_v1' AND `file` = 'portal/index' [ RunTime:0.003921s ]
- [ SQL ] SELECT * FROM `ow_theme_file` WHERE `theme` = 'web_v1' AND `file` = 'portal/info/activity' LIMIT 1 [ RunTime:0.000380s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'ow_theme_file',
'partitions' => NULL,
'type' => 'ALL',
'possible_keys' => NULL,
'key' => NULL,
'key_len' => NULL,
'ref' => NULL,
'rows' => 26,
'filtered' => 3.846153736114502,
'extra' => 'Using where',
) ]
- [ SQL ] UPDATE `ow_theme_file` SET `theme` = 'web_v1' , `action` = 'portal/List/index' , `file` = 'portal/info/activity' , `name` = '活动最新列表页' , `more` = '{\"widgets\":{\"activities\":{\"title\":\"\\u6d3b\\u52a8\\u5217\\u8868\\u6700\\u65b0\\u4fe1\\u606f\",\"name\":\"activity\",\"display\":1,\"vars\":{\"activityId\":{\"title\":\"\\u5305\\u542b\\u6d3b\\u52a8\\u6700\\u65b0\\u4fe1\\u606f\",\"value\":\"3\",\"type\":\"text\",\"tip\":\"\\u5206\\u7c7b\",\"rule\":{\"require\":true}}}}}}' , `config_more` = '{\"widgets\":{\"activities\":{\"title\":\"\\u6d3b\\u52a8\\u5217\\u8868\\u6700\\u65b0\\u4fe1\\u606f\",\"name\":\"activity\",\"display\":1,\"vars\":{\"activityId\":{\"title\":\"\\u5305\\u542b\\u6d3b\\u52a8\\u6700\\u65b0\\u4fe1\\u606f\",\"value\":\"\",\"type\":\"text\",\"tip\":\"\\u5206\\u7c7b\",\"rule\":{\"require\":true}}}}}}' , `description` = '最新活动页面' , `is_public` = 0 , `list_order` = 5 WHERE `theme` = 'web_v1' AND `file` = 'portal/info/activity' [ RunTime:0.004653s ]
- [ SQL ] SELECT * FROM `ow_theme_file` WHERE `theme` = 'web_v1' AND `file` = 'portal/info/allnews' LIMIT 1 [ RunTime:0.000373s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'ow_theme_file',
'partitions' => NULL,
'type' => 'ALL',
'possible_keys' => NULL,
'key' => NULL,
'key_len' => NULL,
'ref' => NULL,
'rows' => 26,
'filtered' => 3.846153736114502,
'extra' => 'Using where',
) ]
- [ SQL ] UPDATE `ow_theme_file` SET `theme` = 'web_v1' , `action` = 'portal/List/index' , `file` = 'portal/info/allnews' , `name` = '资讯最新列表页' , `more` = '{\"widgets\":{\"lastests\":{\"title\":\"\\u8d44\\u8baf\\u5217\\u8868\\u6700\\u65b0\\u4fe1\\u606f\",\"name\":\"lastest\",\"display\":1,\"vars\":{\"lastestId\":{\"title\":\"\\u5305\\u542b\\u516c\\u544a\\u548c\\u653b\\u7565\\u7684\\u6700\\u65b0\\u4fe1\\u606f\",\"value\":\"10\",\"type\":\"text\",\"tip\":\"\\u5206\\u7c7bid(\\u5305\\u542b\\u516c\\u544a\\u548c\\u653b\\u7565)\",\"rule\":{\"require\":true}}}}}}' , `config_more` = '{\"widgets\":{\"lastests\":{\"title\":\"\\u8d44\\u8baf\\u5217\\u8868\\u6700\\u65b0\\u4fe1\\u606f\",\"name\":\"lastest\",\"display\":1,\"vars\":{\"lastestId\":{\"title\":\"\\u5305\\u542b\\u516c\\u544a\\u548c\\u653b\\u7565\\u7684\\u6700\\u65b0\\u4fe1\\u606f\",\"value\":\"\",\"type\":\"text\",\"tip\":\"\\u5206\\u7c7bid(\\u5305\\u542b\\u516c\\u544a\\u548c\\u653b\\u7565)\",\"rule\":{\"require\":true}}}}}}' , `description` = '最新信息页面' , `is_public` = 0 , `list_order` = 5 WHERE `theme` = 'web_v1' AND `file` = 'portal/info/allnews' [ RunTime:0.004429s ]
- [ SQL ] SELECT * FROM `ow_theme_file` WHERE `theme` = 'web_v1' AND `file` = 'portal/info/gongl' LIMIT 1 [ RunTime:0.000366s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'ow_theme_file',
'partitions' => NULL,
'type' => 'ALL',
'possible_keys' => NULL,
'key' => NULL,
'key_len' => NULL,
'ref' => NULL,
'rows' => 26,
'filtered' => 3.846153736114502,
'extra' => 'Using where',
) ]
- [ SQL ] UPDATE `ow_theme_file` SET `theme` = 'web_v1' , `action` = 'portal/List/index' , `file` = 'portal/info/gongl' , `name` = '攻略列表页' , `more` = '{\"widgets\":{\"gongls\":{\"title\":\"\\u653b\\u7565\\u5217\\u8868\\u6700\\u65b0\\u4fe1\\u606f\",\"name\":\"gongl\",\"display\":1,\"vars\":{\"gonglId\":{\"title\":\"\\u653b\\u7565\\u7684\\u6700\\u65b0\\u4fe1\\u606f\",\"value\":\"2\",\"type\":\"text\",\"tip\":\"\\u653b\\u7565\\u7684\\u6700\\u65b0\\u4fe1\\u606f\",\"rule\":{\"require\":true}}}}}}' , `config_more` = '{\"widgets\":{\"gongls\":{\"title\":\"\\u653b\\u7565\\u5217\\u8868\\u6700\\u65b0\\u4fe1\\u606f\",\"name\":\"gongl\",\"display\":1,\"vars\":{\"gonglId\":{\"title\":\"\\u653b\\u7565\\u7684\\u6700\\u65b0\\u4fe1\\u606f\",\"value\":\"\",\"type\":\"text\",\"tip\":\"\\u653b\\u7565\\u7684\\u6700\\u65b0\\u4fe1\\u606f\",\"rule\":{\"require\":true}}}}}}' , `description` = '攻略信息页面' , `is_public` = 0 , `list_order` = 5 WHERE `theme` = 'web_v1' AND `file` = 'portal/info/gongl' [ RunTime:0.006856s ]
- [ SQL ] SELECT * FROM `ow_theme_file` WHERE `theme` = 'web_v1' AND `file` = 'portal/info/notice' LIMIT 1 [ RunTime:0.000381s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'ow_theme_file',
'partitions' => NULL,
'type' => 'ALL',
'possible_keys' => NULL,
'key' => NULL,
'key_len' => NULL,
'ref' => NULL,
'rows' => 26,
'filtered' => 3.846153736114502,
'extra' => 'Using where',
) ]
- [ SQL ] UPDATE `ow_theme_file` SET `theme` = 'web_v1' , `action` = 'portal/List/index' , `file` = 'portal/info/notice' , `name` = '公告列表页' , `more` = '{\"widgets\":{\"notices\":{\"title\":\"\\u516c\\u544a\\u5217\\u8868\\u6700\\u65b0\\u4fe1\\u606f\",\"name\":\"notice\",\"display\":1,\"vars\":{\"noticeId\":{\"title\":\"\\u516c\\u544a\\u7684\\u6700\\u65b0\\u4fe1\\u606f\",\"value\":\"4\",\"type\":\"text\",\"tip\":\"\\u653b\\u7565\\u7684\\u5206\\u7c7bid\",\"rule\":{\"require\":true}}}}}}' , `config_more` = '{\"widgets\":{\"notices\":{\"title\":\"\\u516c\\u544a\\u5217\\u8868\\u6700\\u65b0\\u4fe1\\u606f\",\"name\":\"notice\",\"display\":1,\"vars\":{\"noticeId\":{\"title\":\"\\u516c\\u544a\\u7684\\u6700\\u65b0\\u4fe1\\u606f\",\"value\":\"\",\"type\":\"text\",\"tip\":\"\\u653b\\u7565\\u7684\\u5206\\u7c7bid\",\"rule\":{\"require\":true}}}}}}' , `description` = '公告信息页面' , `is_public` = 0 , `list_order` = 5 WHERE `theme` = 'web_v1' AND `file` = 'portal/info/notice' [ RunTime:0.004316s ]
- [ SQL ] SELECT * FROM `ow_theme_file` WHERE `theme` = 'web_v1' AND `file` = 'portal/info/zonghe' LIMIT 1 [ RunTime:0.000388s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'ow_theme_file',
'partitions' => NULL,
'type' => 'ALL',
'possible_keys' => NULL,
'key' => NULL,
'key_len' => NULL,
'ref' => NULL,
'rows' => 26,
'filtered' => 3.846153736114502,
'extra' => 'Using where',
) ]
- [ SQL ] UPDATE `ow_theme_file` SET `theme` = 'web_v1' , `action` = 'portal/List/index' , `file` = 'portal/info/zonghe' , `name` = '综合列表页' , `more` = '{\"widgets\":{\"zonghe\":{\"title\":\"\\u7efc\\u5408\\u5217\\u8868\\u6700\\u65b0\\u4fe1\\u606f\",\"name\":\"zonghe\",\"display\":1,\"vars\":{\"zhId\":{\"title\":\"\\u7efc\\u5408\\u7684\\u6700\\u65b0\\u4fe1\\u606f\",\"value\":\"1\",\"type\":\"text\",\"tip\":\"\\u7efc\\u5408\\u7684\\u6700\\u65b0\\u4fe1\\u606f\",\"rule\":{\"require\":true}}}}}}' , `config_more` = '{\"widgets\":{\"zonghe\":{\"title\":\"\\u7efc\\u5408\\u5217\\u8868\\u6700\\u65b0\\u4fe1\\u606f\",\"name\":\"zonghe\",\"display\":1,\"vars\":{\"zhId\":{\"title\":\"\\u7efc\\u5408\\u7684\\u6700\\u65b0\\u4fe1\\u606f\",\"value\":\"\",\"type\":\"text\",\"tip\":\"\\u7efc\\u5408\\u7684\\u6700\\u65b0\\u4fe1\\u606f\",\"rule\":{\"require\":true}}}}}}' , `description` = '综合信息页面' , `is_public` = 0 , `list_order` = 5 WHERE `theme` = 'web_v1' AND `file` = 'portal/info/zonghe' [ RunTime:0.005295s ]
- [ SQL ] SELECT * FROM `ow_theme_file` WHERE `theme` = 'web_v1' [ RunTime:0.000431s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'ow_theme_file',
'partitions' => NULL,
'type' => 'ALL',
'possible_keys' => NULL,
'key' => NULL,
'key_len' => NULL,
'ref' => NULL,
'rows' => 26,
'filtered' => 10.0,
'extra' => 'Using where',
) ]
- [ SQL ] SHOW COLUMNS FROM `ow_theme` [ RunTime:0.001229s ]
- [ SQL ] UPDATE `ow_theme` SET `name` = '4web' , `version` = '1.0.0' , `author` = 'join' , `lang` = 'zh-cn' , `author_url` = '' , `keywords` = '江湖官网' , `description` = '江湖官网' WHERE `theme` = 'web_v1' [ RunTime:0.000594s ]
- [ SQL ] SELECT `more` FROM `ow_theme_file` WHERE `theme` = 'web_v1' AND ( `is_public` = 1 OR `file` = 'portal/info/allnews' ) [ RunTime:0.000401s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'ow_theme_file',
'partitions' => NULL,
'type' => 'ALL',
'possible_keys' => NULL,
'key' => NULL,
'key_len' => NULL,
'ref' => NULL,
'rows' => 26,
'filtered' => 3.846153736114502,
'extra' => 'Using where',
) ]
- [ SQL ] SHOW COLUMNS FROM `ow_portal_post` [ RunTime:0.001242s ]
- [ SQL ] SELECT COUNT(*) AS tp_count FROM ( SELECT count(*) AS think_count FROM `ow_portal_post` `post` INNER JOIN `ow_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`.`create_time` >= 0 ) AND ( `category_post`.`category_id` = '10' ) AND ( `post`.`published_time` > 0 and `post`.`published_time` < 1710841365 ) GROUP BY `post`.`id` ) `_group_count_` [ RunTime:0.000955s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'PRIMARY',
'table' => '<derived2>',
'partitions' => NULL,
'type' => 'ALL',
'possible_keys' => NULL,
'key' => NULL,
'key_len' => NULL,
'ref' => NULL,
'rows' => 2,
'filtered' => 100.0,
'extra' => NULL,
) ]
- [ SQL ] SELECT post.*,min(category_post.category_id) as category_id FROM `ow_portal_post` `post` INNER JOIN `ow_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`.`create_time` >= 0 ) AND ( `category_post`.`category_id` = '10' ) AND ( `post`.`published_time` > 0 and `post`.`published_time` < 1710841365 ) GROUP BY `post`.`id` ORDER BY `post`.`published_time` DESC LIMIT 0,16 [ RunTime:0.000631s ]
- [ 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' => 3,
'filtered' => 100.0,
'extra' => 'Using index condition; Using temporary; Using filesort',
) ]
- [ SQL ] SHOW COLUMNS FROM `ow_portal_category_post` [ RunTime:0.001070s ]
- [ SQL ] SELECT `ow_portal_category`.*,`pivot`.`id` AS `pivot__id`,`pivot`.`post_id` AS `pivot__post_id`,`pivot`.`category_id` AS `pivot__category_id`,`pivot`.`list_order` AS `pivot__list_order`,`pivot`.`status` AS `pivot__status` FROM `ow_portal_category` INNER JOIN `ow_portal_category_post` `pivot` ON `pivot`.`category_id`=`ow_portal_category`.`id` WHERE `pivot`.`post_id` = 40 [ RunTime:0.000656s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'pivot',
'partitions' => NULL,
'type' => 'ALL',
'possible_keys' => 'term_taxonomy_id',
'key' => NULL,
'key_len' => NULL,
'ref' => NULL,
'rows' => 44,
'filtered' => 10.0,
'extra' => 'Using where',
) ]
- [ SQL ] SELECT `ow_portal_category`.*,`pivot`.`id` AS `pivot__id`,`pivot`.`post_id` AS `pivot__post_id`,`pivot`.`category_id` AS `pivot__category_id`,`pivot`.`list_order` AS `pivot__list_order`,`pivot`.`status` AS `pivot__status` FROM `ow_portal_category` INNER JOIN `ow_portal_category_post` `pivot` ON `pivot`.`category_id`=`ow_portal_category`.`id` WHERE `pivot`.`post_id` = 39 [ RunTime:0.000371s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'pivot',
'partitions' => NULL,
'type' => 'ALL',
'possible_keys' => 'term_taxonomy_id',
'key' => NULL,
'key_len' => NULL,
'ref' => NULL,
'rows' => 44,
'filtered' => 10.0,
'extra' => 'Using where',
) ]
- [ SQL ] SELECT `ow_portal_category`.*,`pivot`.`id` AS `pivot__id`,`pivot`.`post_id` AS `pivot__post_id`,`pivot`.`category_id` AS `pivot__category_id`,`pivot`.`list_order` AS `pivot__list_order`,`pivot`.`status` AS `pivot__status` FROM `ow_portal_category` INNER JOIN `ow_portal_category_post` `pivot` ON `pivot`.`category_id`=`ow_portal_category`.`id` WHERE `pivot`.`post_id` = 38 [ RunTime:0.000394s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'pivot',
'partitions' => NULL,
'type' => 'ALL',
'possible_keys' => 'term_taxonomy_id',
'key' => NULL,
'key_len' => NULL,
'ref' => NULL,
'rows' => 44,
'filtered' => 10.0,
'extra' => 'Using where',
) ]
0.122924s