基本
文件
流程
錯(cuò)誤
SQL
調(diào)試
- 請(qǐng)求信息 : 2024-07-23 22:34:51 HTTP/1.1 GET : http://m.openmooc.net/
- 運(yùn)行時(shí)間 : 0.132333s [ 吞吐率：7.56req/s ] 內(nèi)存消耗：1,456.85kb 文件加載：112
- 查詢(xún)信息 : 27 queries 11 writes
- 緩存信息 : 6 reads,0 writes
- [ LANG ] /home/yzyydq666hy5zey3y3dkqo64666/wwwroot/vendor/thinkphp/lang/zh-cn.php
- [ LANG ] /home/yzyydq666hy5zey3y3dkqo64666/wwwroot/vendor/thinkcmf/cmf/src/behavior/../lang/zh-cn.php
- [ LANG ] /home/yzyydq666hy5zey3y3dkqo64666/wwwroot/vendor/thinkcmf/cmf-app/src/admin/lang/zh-cn.php
- [ LANG ] /home/yzyydq666hy5zey3y3dkqo64666/wwwroot/vendor/thinkcmf/cmf-app/src/admin/lang/zh-cn/common.php
- [ LANG ] /home/yzyydq666hy5zey3y3dkqo64666/wwwroot/vendor/thinkcmf/cmf-app/src/user/lang/zh-cn.php
- [ LANG ] /home/yzyydq666hy5zey3y3dkqo64666/wwwroot/app/portal/lang/zh-cn/common.php
- [ LANG ] /home/yzyydq666hy5zey3y3dkqo64666/wwwroot/app/portal//lang/zh-cn.php
- [ ROUTE ] array (
)
- [ HEADER ] array (
'x-forwarded-for' => '154.221.72.34',
'x-real-ip' => '154.221.72.34',
'host' => 'm.openmooc.net',
'connection' => 'close',
'content-type' => 'application/x-www-form-urlencoded; Charset=UTF-8',
'accept' => 'text/html,application/xhtml+xml,application/xml;q=0.9,*/*;q=0.8',
'accept-encoding' => 'gzip, deflate',
'accept-language' => 'zh-CN,zh',
'cookie' => 't=92d7540e476b153862b4ea2356ede7b3; r=8148',
'referer' => 'http://www.baidu.com',
'user-agent' => 'Mozilla/5.0 (Windows NT 10.0; WOW64; Trident/7.0; rv:11.0) like Gecko',
)
- [ PARAM ] array (
)
- [ DB ] INIT mysql
- [ LANG ] /home/yzyydq666hy5zey3y3dkqo64666/wwwroot/app/portal/lang/zh-cn/home.php
- [ VIEW ] /home/yzyydq666hy5zey3y3dkqo64666/wwwroot/public/themes/yayu/portal/index.html [ array (
0 => 'site_info',
1 => 'theme_vars',
2 => 'theme_widgets',
) ]
- [ DB ] CONNECT:[ UseTime:0.000706s ] mysql:host=127.0.0.1;port=3306;dbname=yzyydq666;charset=utf8mb4
- [ SQL ] SHOW COLUMNS FROM `vbs_plugin` [ RunTime:0.001022s ]
- [ SQL ] SELECT `config` FROM `vbs_plugin` WHERE `name` = 'LeoxieSwitchLang' LIMIT 1 [ RunTime:0.000243s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'vbs_plugin',
'partitions' => NULL,
'type' => 'ALL',
'possible_keys' => NULL,
'key' => NULL,
'key_len' => NULL,
'ref' => NULL,
'rows' => 1,
'filtered' => 100.0,
'extra' => 'Using where',
) ]
- [ SQL ] SHOW COLUMNS FROM `vbs_theme_file` [ RunTime:0.001129s ]
- [ SQL ] SELECT * FROM `vbs_theme_file` WHERE `theme` = 'yayu' AND `file` = 'portal/article' LIMIT 1 [ RunTime:0.000333s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'vbs_theme_file',
'partitions' => NULL,
'type' => 'ALL',
'possible_keys' => NULL,
'key' => NULL,
'key_len' => NULL,
'ref' => NULL,
'rows' => 23,
'filtered' => 4.3478260040283203,
'extra' => 'Using where',
) ]
- [ SQL ] UPDATE `vbs_theme_file` SET `theme` = 'yayu' , `action` = 'portal/Article/index' , `file` = 'portal/article' , `name` = '文章頁(yè)' , `more` = '{\"vars\":{\"baidu_map_info_window_text\":{\"title\":\"\\u767e\\u5ea6\\u5730\\u56fe\\u6807\\u6ce8\\u6587\\u5b57\",\"name\":\"baidu_map_info_window_text\",\"value\":\"\",\"type\":\"text\",\"tip\":\"\\u767e\\u5ea6\\u5730\\u56fe\\u6807\\u6ce8\\u6587\\u5b57,\\u652f\\u6301\\u7b80\\u5355html\\u4ee3\\u7801\",\"rule\":[]},\"company_location\":{\"title\":\"\\u516c\\u53f8\\u5750\\u6807\",\"value\":\"\",\"type\":\"location\",\"tip\":\"\",\"rule\":{\"require\":true}}}}' , `config_more` = '{\"vars\":{\"baidu_map_info_window_text\":{\"title\":\"\\u767e\\u5ea6\\u5730\\u56fe\\u6807\\u6ce8\\u6587\\u5b57\",\"name\":\"baidu_map_info_window_text\",\"value\":\"\",\"type\":\"text\",\"tip\":\"\\u767e\\u5ea6\\u5730\\u56fe\\u6807\\u6ce8\\u6587\\u5b57,\\u652f\\u6301\\u7b80\\u5355html\\u4ee3\\u7801\",\"rule\":[]},\"company_location\":{\"title\":\"\\u516c\\u53f8\\u5750\\u6807\",\"value\":\"\",\"type\":\"location\",\"tip\":\"\",\"rule\":{\"require\":true}}}}' , `description` = '文章頁(yè)面' , `is_public` = 0 , `list_order` = 45 WHERE `theme` = 'yayu' AND `file` = 'portal/article' [ RunTime:0.002379s ]
- [ SQL ] SELECT * FROM `vbs_theme_file` WHERE `theme` = 'yayu' AND `file` = 'portal/article_simple' LIMIT 1 [ RunTime:0.000249s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'vbs_theme_file',
'partitions' => NULL,
'type' => 'ALL',
'possible_keys' => NULL,
'key' => NULL,
'key_len' => NULL,
'ref' => NULL,
'rows' => 23,
'filtered' => 4.3478260040283203,
'extra' => 'Using where',
) ]
- [ SQL ] UPDATE `vbs_theme_file` SET `theme` = 'yayu' , `action` = 'portal/Article/index' , `file` = 'portal/article_simple' , `name` = '簡(jiǎn)單文章頁(yè)' , `more` = '{\"vars\":{\"baidu_map_info_window_text\":{\"title\":\"\\u767e\\u5ea6\\u5730\\u56fe\\u6807\\u6ce8\\u6587\\u5b57\",\"name\":\"baidu_map_info_window_text\",\"value\":\"\",\"type\":\"text\",\"tip\":\"\\u767e\\u5ea6\\u5730\\u56fe\\u6807\\u6ce8\\u6587\\u5b57,\\u652f\\u6301\\u7b80\\u5355html\\u4ee3\\u7801\",\"rule\":[]},\"company_location\":{\"title\":\"\\u516c\\u53f8\\u5750\\u6807\",\"value\":\"\",\"type\":\"location\",\"tip\":\"\",\"rule\":{\"require\":true}}}}' , `config_more` = '{\"vars\":{\"baidu_map_info_window_text\":{\"title\":\"\\u767e\\u5ea6\\u5730\\u56fe\\u6807\\u6ce8\\u6587\\u5b57\",\"name\":\"baidu_map_info_window_text\",\"value\":\"\",\"type\":\"text\",\"tip\":\"\\u767e\\u5ea6\\u5730\\u56fe\\u6807\\u6ce8\\u6587\\u5b57,\\u652f\\u6301\\u7b80\\u5355html\\u4ee3\\u7801\",\"rule\":[]},\"company_location\":{\"title\":\"\\u516c\\u53f8\\u5750\\u6807\",\"value\":\"\",\"type\":\"location\",\"tip\":\"\",\"rule\":{\"require\":true}}}}' , `description` = '簡(jiǎn)單文章頁(yè)面，無(wú)右側(cè)推薦邊欄' , `is_public` = 0 , `list_order` = 50 WHERE `theme` = 'yayu' AND `file` = 'portal/article_simple' [ RunTime:0.001935s ]
- [ SQL ] SELECT * FROM `vbs_theme_file` WHERE `theme` = 'yayu' AND `file` = 'portal/index' LIMIT 1 [ RunTime:0.000230s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'vbs_theme_file',
'partitions' => NULL,
'type' => 'ALL',
'possible_keys' => NULL,
'key' => NULL,
'key_len' => NULL,
'ref' => NULL,
'rows' => 23,
'filtered' => 4.3478260040283203,
'extra' => 'Using where',
) ]
- [ SQL ] UPDATE `vbs_theme_file` SET `theme` = 'yayu' , `action` = 'portal/Index/index' , `file` = 'portal/index' , `name` = '首頁(yè)' , `more` = '{\"vars\":[]}' , `config_more` = '{\"vars\":[]}' , `description` = '首頁(yè)模板' , `is_public` = 0 , `list_order` = 10 WHERE `theme` = 'yayu' AND `file` = 'portal/index' [ RunTime:0.001946s ]
- [ SQL ] SELECT * FROM `vbs_theme_file` WHERE `theme` = 'yayu' AND `file` = 'portal/list' LIMIT 1 [ RunTime:0.000239s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'vbs_theme_file',
'partitions' => NULL,
'type' => 'ALL',
'possible_keys' => NULL,
'key' => NULL,
'key_len' => NULL,
'ref' => NULL,
'rows' => 23,
'filtered' => 4.3478260040283203,
'extra' => 'Using where',
) ]
- [ SQL ] UPDATE `vbs_theme_file` SET `theme` = 'yayu' , `action` = 'portal/List/index' , `file` = 'portal/list' , `name` = 'list' , `more` = '{\"vars\":[]}' , `config_more` = '{\"vars\":[]}' , `description` = '產(chǎn)品列表頁(yè)' , `is_public` = 0 , `list_order` = 10 WHERE `theme` = 'yayu' AND `file` = 'portal/list' [ RunTime:0.001854s ]
- [ SQL ] SELECT * FROM `vbs_theme_file` WHERE `theme` = 'yayu' AND `file` = 'portal/list1' LIMIT 1 [ RunTime:0.000231s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'vbs_theme_file',
'partitions' => NULL,
'type' => 'ALL',
'possible_keys' => NULL,
'key' => NULL,
'key_len' => NULL,
'ref' => NULL,
'rows' => 23,
'filtered' => 4.3478260040283203,
'extra' => 'Using where',
) ]
- [ SQL ] UPDATE `vbs_theme_file` SET `theme` = 'yayu' , `action` = 'portal/List/index' , `file` = 'portal/list1' , `name` = 'list' , `more` = '{\"vars\":[]}' , `config_more` = '{\"vars\":[]}' , `description` = '產(chǎn)品列表頁(yè)' , `is_public` = 0 , `list_order` = 10 WHERE `theme` = 'yayu' AND `file` = 'portal/list1' [ RunTime:0.001848s ]
- [ SQL ] SELECT * FROM `vbs_theme_file` WHERE `theme` = 'yayu' AND `file` = 'portal/list2' LIMIT 1 [ RunTime:0.000285s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'vbs_theme_file',
'partitions' => NULL,
'type' => 'ALL',
'possible_keys' => NULL,
'key' => NULL,
'key_len' => NULL,
'ref' => NULL,
'rows' => 23,
'filtered' => 4.3478260040283203,
'extra' => 'Using where',
) ]
- [ SQL ] UPDATE `vbs_theme_file` SET `theme` = 'yayu' , `action` = 'portal/List/index' , `file` = 'portal/list2' , `name` = 'list' , `more` = '{\"vars\":[]}' , `config_more` = '{\"vars\":[]}' , `description` = '產(chǎn)品列表頁(yè)' , `is_public` = 0 , `list_order` = 10 WHERE `theme` = 'yayu' AND `file` = 'portal/list2' [ RunTime:0.001687s ]
- [ SQL ] SELECT * FROM `vbs_theme_file` WHERE `theme` = 'yayu' AND `file` = 'portal/list3' LIMIT 1 [ RunTime:0.000290s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'vbs_theme_file',
'partitions' => NULL,
'type' => 'ALL',
'possible_keys' => NULL,
'key' => NULL,
'key_len' => NULL,
'ref' => NULL,
'rows' => 23,
'filtered' => 4.3478260040283203,
'extra' => 'Using where',
) ]
- [ SQL ] UPDATE `vbs_theme_file` SET `theme` = 'yayu' , `action` = 'portal/List/index' , `file` = 'portal/list3' , `name` = 'list3' , `more` = '{\"vars\":[]}' , `config_more` = '{\"vars\":[]}' , `description` = '產(chǎn)品列表頁(yè)' , `is_public` = 0 , `list_order` = 10 WHERE `theme` = 'yayu' AND `file` = 'portal/list3' [ RunTime:0.001701s ]
- [ SQL ] SELECT * FROM `vbs_theme_file` WHERE `theme` = 'yayu' AND `file` = 'portal/page' LIMIT 1 [ RunTime:0.000339s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'vbs_theme_file',
'partitions' => NULL,
'type' => 'ALL',
'possible_keys' => NULL,
'key' => NULL,
'key_len' => NULL,
'ref' => NULL,
'rows' => 23,
'filtered' => 4.3478260040283203,
'extra' => 'Using where',
) ]
- [ SQL ] UPDATE `vbs_theme_file` SET `theme` = 'yayu' , `action` = 'portal/Page/index' , `file` = 'portal/page' , `name` = '單頁(yè)面' , `more` = '{\"vars\":[]}' , `config_more` = '{\"vars\":[]}' , `description` = '關(guān)于我們' , `is_public` = 0 , `list_order` = 10 WHERE `theme` = 'yayu' AND `file` = 'portal/page' [ RunTime:0.001920s ]
- [ SQL ] SELECT * FROM `vbs_theme_file` WHERE `theme` = 'yayu' AND `file` = 'portal/page1' LIMIT 1 [ RunTime:0.000283s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'vbs_theme_file',
'partitions' => NULL,
'type' => 'ALL',
'possible_keys' => NULL,
'key' => NULL,
'key_len' => NULL,
'ref' => NULL,
'rows' => 23,
'filtered' => 4.3478260040283203,
'extra' => 'Using where',
) ]
- [ SQL ] UPDATE `vbs_theme_file` SET `theme` = 'yayu' , `action` = 'portal/Page/index' , `file` = 'portal/page1' , `name` = '單頁(yè)面' , `more` = '{\"vars\":[]}' , `config_more` = '{\"vars\":[]}' , `description` = '關(guān)于我們' , `is_public` = 0 , `list_order` = 10 WHERE `theme` = 'yayu' AND `file` = 'portal/page1' [ RunTime:0.001818s ]
- [ SQL ] SELECT * FROM `vbs_theme_file` WHERE `theme` = 'yayu' AND `file` = 'public/header' LIMIT 1 [ RunTime:0.000330s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'vbs_theme_file',
'partitions' => NULL,
'type' => 'ALL',
'possible_keys' => NULL,
'key' => NULL,
'key_len' => NULL,
'ref' => NULL,
'rows' => 23,
'filtered' => 4.3478260040283203,
'extra' => 'Using where',
) ]
- [ SQL ] UPDATE `vbs_theme_file` SET `theme` = 'yayu' , `action` = 'public/Header' , `file` = 'public/header' , `name` = '頭部信息' , `more` = '{\"vars\":{\"logo\":{\"title\":\"\\u7f51\\u7ad9LOGO\",\"value\":\"default\\/20211104\\/5005ebf5c3831639e38ef194f564e648.png\",\"type\":\"image\",\"tip\":\"\\u8bf7\\u9009\\u62e9LOGO\\u56fe\\u7247\\uff0c\\u5efa\\u8bae\\u56fe\\u7247\\u5e95\\u8272\\u4e3a\\u767d\\u8272(.jpg)\\u6216\\u900f\\u660e(.png)\\u3002\"},\"phone\":{\"title\":\"phone\",\"value\":\"18652407493\",\"type\":\"text\",\"tip\":\"phone\"},\"dizhi\":{\"title\":\"dizhi\",\"value\":\"\\u6c5f\\u82cf\\u7701\\u626c\\u5dde\\u5e02\\u4eea\\u5f81\\u5e02\\u5927\\u4eea\\u9547\\u8def\\u4e1c\\u6751\\u6768\\u534e\\u8def\\u5317\\u4fa7\",\"type\":\"text\",\"tip\":\"\\u5730\\u5740\"}}}' , `config_more` = '{\"vars\":{\"logo\":{\"title\":\"\\u7f51\\u7ad9LOGO\",\"value\":\"\",\"type\":\"image\",\"tip\":\"\\u8bf7\\u9009\\u62e9LOGO\\u56fe\\u7247\\uff0c\\u5efa\\u8bae\\u56fe\\u7247\\u5e95\\u8272\\u4e3a\\u767d\\u8272(.jpg)\\u6216\\u900f\\u660e(.png)\\u3002\"},\"phone\":{\"title\":\"phone\",\"value\":\"\",\"type\":\"text\",\"tip\":\"phone\"},\"dizhi\":{\"title\":\"dizhi\",\"value\":\"\",\"type\":\"text\",\"tip\":\"\\u5730\\u5740\"}}}' , `description` = '網(wǎng)站頭部信息內(nèi)容' , `is_public` = 1 , `list_order` = 1 WHERE `theme` = 'yayu' AND `file` = 'public/header' [ RunTime:0.001864s ]
- [ SQL ] SELECT * FROM `vbs_theme_file` WHERE `theme` = 'yayu' [ RunTime:0.000240s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'vbs_theme_file',
'partitions' => NULL,
'type' => 'ALL',
'possible_keys' => NULL,
'key' => NULL,
'key_len' => NULL,
'ref' => NULL,
'rows' => 23,
'filtered' => 9.9999990463256836,
'extra' => 'Using where',
) ]
- [ SQL ] SHOW COLUMNS FROM `vbs_theme` [ RunTime:0.001001s ]
- [ SQL ] UPDATE `vbs_theme` SET `name` = 'yayu' , `version` = '1.0.2' , `demo_url` = '' , `author` = 'hikari' , `lang` = 'zh-cn' , `author_url` = '' , `keywords` = '' , `description` = '' WHERE `theme` = 'yayu' [ RunTime:0.001951s ]
- [ SQL ] SELECT `more` FROM `vbs_theme_file` WHERE `theme` = 'yayu' AND ( `is_public` = 1 OR `file` = 'portal/index' ) [ RunTime:0.000223s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'vbs_theme_file',
'partitions' => NULL,
'type' => 'ALL',
'possible_keys' => NULL,
'key' => NULL,
'key_len' => NULL,
'ref' => NULL,
'rows' => 23,
'filtered' => 4.3478260040283203,
'extra' => 'Using where',
) ]
- [ SQL ] SHOW COLUMNS FROM `vbs_option` [ RunTime:0.000838s ]
- [ SQL ] SELECT `option_value` FROM `vbs_option` WHERE `option_name` = 'storage' LIMIT 1 [ RunTime:0.000190s ]
- [ 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 ] SHOW COLUMNS FROM `vbs_nav_menu` [ RunTime:0.000714s ]
- [ SQL ] SELECT * FROM `vbs_nav_menu` WHERE `nav_id` = 1 AND `status` = 1 ORDER BY `list_order` ASC [ RunTime:0.000243s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'vbs_nav_menu',
'partitions' => NULL,
'type' => 'ALL',
'possible_keys' => NULL,
'key' => NULL,
'key_len' => NULL,
'ref' => NULL,
'rows' => 7,
'filtered' => 14.285713195800781,
'extra' => 'Using where; Using filesort',
) ]
- [ SQL ] SHOW COLUMNS FROM `vbs_portal_category` [ RunTime:0.001021s ]
- [ SQL ] SELECT `path` FROM `vbs_portal_category` WHERE `id` = 1 LIMIT 1 [ RunTime:0.000244s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'vbs_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 `vbs_portal_category` WHERE `status` = 1 AND `delete_time` = 0 AND `path` LIKE '0-1-%' [ RunTime:0.000266s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'vbs_portal_category',
'partitions' => NULL,
'type' => 'ALL',
'possible_keys' => NULL,
'key' => NULL,
'key_len' => NULL,
'ref' => NULL,
'rows' => 9,
'filtered' => 11.111111640930176,
'extra' => 'Using where',
) ]
- [ SQL ] SHOW COLUMNS FROM `vbs_portal_post` [ RunTime:0.000838s ]
- [ SQL ] SELECT post.*,min(category_post.category_id) as category_id FROM `vbs_portal_post` `post` INNER JOIN `vbs_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` = '1' ) AND ( `post`.`published_time` > 0 AND `post`.`published_time` < 1721745292 ) GROUP BY `post`.`id` ORDER BY `post`.`published_time` DESC LIMIT 8 [ RunTime:0.004301s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'post',
'partitions' => NULL,
'type' => 'index',
'possible_keys' => 'PRIMARY,type_status_date,parent_id,user_id,create_time',
'key' => 'PRIMARY',
'key_len' => '8',
'ref' => NULL,
'rows' => 81,
'filtered' => 1.2345678806304932,
'extra' => 'Using where; Using temporary; Using filesort',
) ]
- [ SQL ] SELECT post.*,min(category_post.category_id) as category_id FROM `vbs_portal_post` `post` INNER JOIN `vbs_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` = '5' ) AND ( `post`.`published_time` > 0 AND `post`.`published_time` < 1721745292 ) GROUP BY `post`.`id` ORDER BY `post`.`published_time` DESC LIMIT 4 [ RunTime:0.000805s ]
- [ 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' => 4,
'filtered' => 100.0,
'extra' => 'Using index condition; Using temporary; Using filesort',
) ]
- [ SQL ] SELECT post.*,min(category_post.category_id) as category_id FROM `vbs_portal_post` `post` INNER JOIN `vbs_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` = '6' ) AND ( `post`.`published_time` > 0 AND `post`.`published_time` < 1721745292 ) GROUP BY `post`.`id` ORDER BY `post`.`published_time` DESC LIMIT 4 [ RunTime:0.000773s ]
- [ 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' => 4,
'filtered' => 100.0,
'extra' => 'Using index condition; Using temporary; Using filesort',
) ]
