基本
文件
流(liu)程
錯誤
SQL
調試(shi)
- 請求信息 : 2024-04-29 03:56:50 HTTP/1.1 GET : //t4808.cn/ouzhoubeizhiboimportant/
- 運行時間 : 0.470675s [ 吞吐率:2.12req/s ] 內存消耗:6,246.30kb 文件加載:141
- 查詢信息 : 69 queries 6 writes
- 緩存信息 : 7 reads,4 writes
- [ LANG ] /mnt/7kzhanqun/vendor/thinkphp/lang/zh-cn.php
- [ DB ] INIT mysql
- [ LANG ] /mnt/7kzhanqun/vendor/thinkcmf/cmf/src/behavior/../lang/zh-cn.php
- [ LANG ] /mnt/7kzhanqun/vendor/thinkcmf/cmf-app/src/admin/lang/zh-cn.php
- [ LANG ] /mnt/7kzhanqun/vendor/thinkcmf/cmf-app/src/admin/lang/zh-cn/common.php
- [ LANG ] /mnt/7kzhanqun/vendor/thinkcmf/cmf-app/src/user/lang/zh-cn.php
- [ LANG ] /mnt/7kzhanqun/app/portal/lang/zh-cn/common.php
- [ LANG ] /mnt/7kzhanqun/app/portal//lang/zh-cn.php
- [ ROUTE ] array (
'rule' => 'ouzhoubeizhiboimportant',
'route' => 'portal/Competition/important',
'option' =>
array (
'merge_rule_regex' => false,
),
'var' =>
array (
),
)
- [ HEADER ] array (
'connection' => 'Close',
'host' => 't4808.cn',
'user-agent' => 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/73.0.3683.103 Safari/537.36',
'content-type' => 'text/html',
'accept' => 'text/html, application/xhtml+xml, */*',
'content-length' => '',
)
- [ PARAM ] array (
)
- [ LANG ] /mnt/7kzhanqun/app/portal/lang/zh-cn/home.php
- [ VIEW ] /mnt/7kzhanqun/public/themes/re_sport09/portal/competition.html [ array (
0 => 'site_info',
1 => 'event_info',
2 => 'categories',
3 => 'front_theme',
4 => 'com_type',
5 => 'navigation',
6 => 'pinyin',
7 => 'tdk',
8 => 'introduce',
9 => 'competition',
10 => 'theme_vars',
11 => 'theme_widgets',
) ]
- [ DB ] CONNECT:[ UseTime:0.002920s ] mysql:host=rm-3ns41jmtlb1g0zd6v.mysql.rds.aliyuncs.com;port=3306;dbname=daxiong;charset=utf8mb4
- [ SQL ] SHOW COLUMNS FROM `cmf_plugin_web` [ RunTime:0.001779s ]
- [ SQL ] SELECT `id` FROM `cmf_plugin_web` WHERE `web_url` LIKE '%t4808.cn%' LIMIT 1 [ RunTime:0.001544s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_plugin_web',
'partitions' => NULL,
'type' => 'ALL',
'possible_keys' => NULL,
'key' => NULL,
'key_len' => NULL,
'ref' => NULL,
'rows' => 77,
'filtered' => 11.109999656677246,
'extra' => 'Using where',
) ]
- [ SQL ] SELECT `id` FROM `cmf_plugin_web` WHERE `web_url` LIKE '%t4808.cn%' LIMIT 1 [ RunTime:0.001599s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_plugin_web',
'partitions' => NULL,
'type' => 'ALL',
'possible_keys' => NULL,
'key' => NULL,
'key_len' => NULL,
'ref' => NULL,
'rows' => 77,
'filtered' => 11.109999656677246,
'extra' => 'Using where',
) ]
- [ SQL ] SHOW COLUMNS FROM `cmf_plugin` [ RunTime:0.001673s ]
- [ SQL ] SELECT `config` FROM `cmf_plugin` WHERE `name` = 'Web' AND `site_id` = 57 LIMIT 1 [ RunTime:0.001565s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_plugin',
'partitions' => NULL,
'type' => 'ALL',
'possible_keys' => NULL,
'key' => NULL,
'key_len' => NULL,
'ref' => NULL,
'rows' => 84,
'filtered' => 1.1904761791229248,
'extra' => 'Using where',
) ]
- [ SQL ] SELECT `id` FROM `cmf_plugin_web` WHERE `web_url` LIKE '%t4808.cn%' LIMIT 1 [ RunTime:0.001499s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_plugin_web',
'partitions' => NULL,
'type' => 'ALL',
'possible_keys' => NULL,
'key' => NULL,
'key_len' => NULL,
'ref' => NULL,
'rows' => 77,
'filtered' => 11.109999656677246,
'extra' => 'Using where',
) ]
- [ SQL ] SHOW COLUMNS FROM `cmf_option` [ RunTime:0.001638s ]
- [ SQL ] SELECT `option_value` FROM `cmf_option` WHERE `option_name` = 'cdn_settings' AND `site_id` = 57 LIMIT 1 [ RunTime:0.001560s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_option',
'partitions' => NULL,
'type' => 'ref',
'possible_keys' => 'site_id',
'key' => 'site_id',
'key_len' => '5',
'ref' => 'const',
'rows' => 5,
'filtered' => 10.0,
'extra' => 'Using where',
) ]
- [ SQL ] SELECT `id` FROM `cmf_plugin_web` WHERE `web_url` LIKE '%t4808.cn%' LIMIT 1 [ RunTime:0.001560s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_plugin_web',
'partitions' => NULL,
'type' => 'ALL',
'possible_keys' => NULL,
'key' => NULL,
'key_len' => NULL,
'ref' => NULL,
'rows' => 77,
'filtered' => 11.109999656677246,
'extra' => 'Using where',
) ]
- [ SQL ] SELECT `id` FROM `cmf_plugin_web` WHERE `web_url` LIKE '%t4808.cn%' LIMIT 1 [ RunTime:0.001566s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_plugin_web',
'partitions' => NULL,
'type' => 'ALL',
'possible_keys' => NULL,
'key' => NULL,
'key_len' => NULL,
'ref' => NULL,
'rows' => 77,
'filtered' => 11.109999656677246,
'extra' => 'Using where',
) ]
- [ SQL ] SELECT `status` FROM `cmf_plugin_web` WHERE `id` = 57 LIMIT 1 [ RunTime:0.001461s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_plugin_web',
'partitions' => NULL,
'type' => 'const',
'possible_keys' => 'PRIMARY',
'key' => 'PRIMARY',
'key_len' => '8',
'ref' => 'const',
'rows' => 1,
'filtered' => 100.0,
'extra' => NULL,
) ]
- [ SQL ] SELECT `id` FROM `cmf_plugin_web` WHERE `web_url` LIKE '%t4808.cn%' LIMIT 1 [ RunTime:0.001533s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_plugin_web',
'partitions' => NULL,
'type' => 'ALL',
'possible_keys' => NULL,
'key' => NULL,
'key_len' => NULL,
'ref' => NULL,
'rows' => 77,
'filtered' => 11.109999656677246,
'extra' => 'Using where',
) ]
- [ SQL ] SELECT * FROM `cmf_plugin_web` WHERE `id` = 57 LIMIT 1 [ RunTime:0.001535s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_plugin_web',
'partitions' => NULL,
'type' => 'const',
'possible_keys' => 'PRIMARY',
'key' => 'PRIMARY',
'key_len' => '8',
'ref' => 'const',
'rows' => 1,
'filtered' => 100.0,
'extra' => NULL,
) ]
- [ SQL ] SELECT `id` FROM `cmf_plugin_web` WHERE `web_url` LIKE '%t4808.cn%' LIMIT 1 [ RunTime:0.001503s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_plugin_web',
'partitions' => NULL,
'type' => 'ALL',
'possible_keys' => NULL,
'key' => NULL,
'key_len' => NULL,
'ref' => NULL,
'rows' => 77,
'filtered' => 11.109999656677246,
'extra' => 'Using where',
) ]
- [ SQL ] SELECT `id` FROM `cmf_plugin_web` WHERE `web_url` LIKE '%t4808.cn%' LIMIT 1 [ RunTime:0.001512s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_plugin_web',
'partitions' => NULL,
'type' => 'ALL',
'possible_keys' => NULL,
'key' => NULL,
'key_len' => NULL,
'ref' => NULL,
'rows' => 77,
'filtered' => 11.109999656677246,
'extra' => 'Using where',
) ]
- [ SQL ] SELECT `id` FROM `cmf_plugin_web` WHERE `web_url` LIKE '%t4808.cn%' LIMIT 1 [ RunTime:0.001524s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_plugin_web',
'partitions' => NULL,
'type' => 'ALL',
'possible_keys' => NULL,
'key' => NULL,
'key_len' => NULL,
'ref' => NULL,
'rows' => 77,
'filtered' => 11.109999656677246,
'extra' => 'Using where',
) ]
- [ SQL ] SELECT `option_value` FROM `cmf_option` WHERE `option_name` = 'site_info' AND `site_id` = 57 LIMIT 1 [ RunTime:0.001635s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_option',
'partitions' => NULL,
'type' => 'ref',
'possible_keys' => 'site_id',
'key' => 'site_id',
'key_len' => '5',
'ref' => 'const',
'rows' => 5,
'filtered' => 10.0,
'extra' => 'Using where',
) ]
- [ SQL ] SELECT `option_value` FROM `cmf_option` WHERE `option_name` = 'admin_settings' AND `site_id` = 57 LIMIT 1 [ RunTime:0.001552s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_option',
'partitions' => NULL,
'type' => 'ref',
'possible_keys' => 'site_id',
'key' => 'site_id',
'key_len' => '5',
'ref' => 'const',
'rows' => 5,
'filtered' => 10.0,
'extra' => 'Using where',
) ]
- [ SQL ] SHOW COLUMNS FROM `cmf_portal_category` [ RunTime:0.001695s ]
- [ SQL ] SELECT `id`,`name` FROM `cmf_portal_category` WHERE `status` = 1 [ RunTime:0.001723s ]
- [ 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' => 468,
'filtered' => 9.999999046325684,
'extra' => 'Using where',
) ]
- [ SQL ] SELECT `id` FROM `cmf_plugin_web` WHERE `web_url` LIKE '%t4808.cn%' LIMIT 1 [ RunTime:0.001500s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_plugin_web',
'partitions' => NULL,
'type' => 'ALL',
'possible_keys' => NULL,
'key' => NULL,
'key_len' => NULL,
'ref' => NULL,
'rows' => 77,
'filtered' => 11.109999656677246,
'extra' => 'Using where',
) ]
- [ SQL ] SELECT * FROM `cmf_plugin_web` WHERE `id` = 57 LIMIT 1 [ RunTime:0.001534s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_plugin_web',
'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 `cmf_nami_competitions` [ RunTime:0.001862s ]
- [ SQL ] SELECT `pinyin` FROM `cmf_nami_competitions` WHERE `id` = 0 LIMIT 1 [ RunTime:0.001600s ]
- [ 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 `com_type` FROM `cmf_nami_competitions` WHERE `id` = 0 LIMIT 1 [ RunTime:0.001526s ]
- [ 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 `id` FROM `cmf_plugin_web` WHERE `web_url` LIKE '%t4808.cn%' LIMIT 1 [ RunTime:0.001498s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_plugin_web',
'partitions' => NULL,
'type' => 'ALL',
'possible_keys' => NULL,
'key' => NULL,
'key_len' => NULL,
'ref' => NULL,
'rows' => 77,
'filtered' => 11.109999656677246,
'extra' => 'Using where',
) ]
- [ SQL ] SELECT `competition_id` FROM `cmf_plugin_web` WHERE `id` = 57 LIMIT 1 [ RunTime:0.001468s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_plugin_web',
'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_nami_competitions` LIMIT 1 [ RunTime:0.001701s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_nami_competitions',
'partitions' => NULL,
'type' => 'ALL',
'possible_keys' => NULL,
'key' => NULL,
'key_len' => NULL,
'ref' => NULL,
'rows' => 3513,
'filtered' => 100.0,
'extra' => NULL,
) ]
- [ SQL ] SELECT `id` FROM `cmf_plugin_web` WHERE `web_url` LIKE '%t4808.cn%' LIMIT 1 [ RunTime:0.001497s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_plugin_web',
'partitions' => NULL,
'type' => 'ALL',
'possible_keys' => NULL,
'key' => NULL,
'key_len' => NULL,
'ref' => NULL,
'rows' => 77,
'filtered' => 11.109999656677246,
'extra' => 'Using where',
) ]
- [ SQL ] SELECT `id` FROM `cmf_plugin_web` WHERE `web_url` LIKE '%t4808.cn%' LIMIT 1 [ RunTime:0.001493s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_plugin_web',
'partitions' => NULL,
'type' => 'ALL',
'possible_keys' => NULL,
'key' => NULL,
'key_len' => NULL,
'ref' => NULL,
'rows' => 77,
'filtered' => 11.109999656677246,
'extra' => 'Using where',
) ]
- [ SQL ] SHOW COLUMNS FROM `cmf_nav_menu` [ RunTime:0.001644s ]
- [ SQL ] SELECT `name`,`href` FROM `cmf_nav_menu` WHERE `nav_id` = 1 AND `parent_id` = 0 AND `status` = 1 AND `site_id` = 57 [ RunTime:0.001672s ]
- [ 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' => 582,
'filtered' => 0.17182131111621857,
'extra' => 'Using where',
) ]
- [ SQL ] SELECT `id` FROM `cmf_plugin_web` WHERE `web_url` LIKE '%t4808.cn%' LIMIT 1 [ RunTime:0.001503s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_plugin_web',
'partitions' => NULL,
'type' => 'ALL',
'possible_keys' => NULL,
'key' => NULL,
'key_len' => NULL,
'ref' => NULL,
'rows' => 77,
'filtered' => 11.109999656677246,
'extra' => 'Using where',
) ]
- [ SQL ] SHOW COLUMNS FROM `cmf_nami_matches` [ RunTime:0.001809s ]
- [ SQL ] SELECT * FROM `cmf_nami_matches` WHERE `competition_id` = 1 AND `com_type` = 0 AND `match_time` > 1714334210 LIMIT 100 [ RunTime:0.003185s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_nami_matches',
'partitions' => NULL,
'type' => 'ref',
'possible_keys' => 'com_type,match_time,season_id',
'key' => 'season_id',
'key_len' => '5',
'ref' => 'const',
'rows' => 746,
'filtered' => 14.122657775878906,
'extra' => 'Using where',
) ]
- [ SQL ] SHOW COLUMNS FROM `cmf_nami_teams` [ RunTime:0.001808s ]
- [ SQL ] SELECT `short_name_zh` FROM `cmf_nami_teams` WHERE `cid` IN ('') AND `com_type` = 0 [ RunTime:0.001560s ]
- [ 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 `cmf_theme_file` [ RunTime:0.001710s ]
- [ SQL ] SELECT * FROM `cmf_theme_file` WHERE `theme` = 're_sport09' AND `file` = 'portal/article' LIMIT 1 [ RunTime:0.001668s ]
- [ 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' => 151,
'filtered' => 1.0000001192092896,
'extra' => 'Using where',
) ]
- [ SQL ] UPDATE `cmf_theme_file` SET `theme` = 're_sport09' , `action` = 'portal/Article/index' , `file` = 'portal/article' , `name` = '資訊詳情頁' , `more` = '[]' , `config_more` = '[]' , `description` = '資訊詳情頁模板文件' , `is_public` = 0 , `list_order` = 10 WHERE `theme` = 're_sport09' AND `file` = 'portal/article' [ RunTime:0.001695s ]
- [ SQL ] SELECT * FROM `cmf_theme_file` WHERE `theme` = 're_sport09' AND `file` = 'portal/competition' LIMIT 1 [ RunTime:0.001629s ]
- [ 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' => 151,
'filtered' => 1.0000001192092896,
'extra' => 'Using where',
) ]
- [ SQL ] UPDATE `cmf_theme_file` SET `theme` = 're_sport09' , `action` = 'portal/Competition/index' , `file` = 'portal/competition' , `name` = '賽程列表頁' , `more` = '{\"vars\":[]}' , `config_more` = '{\"vars\":[]}' , `description` = '賽程列表模板文件' , `is_public` = 0 , `list_order` = 0 WHERE `theme` = 're_sport09' AND `file` = 'portal/competition' [ RunTime:0.001649s ]
- [ SQL ] SELECT * FROM `cmf_theme_file` WHERE `theme` = 're_sport09' AND `file` = 'portal/index' LIMIT 1 [ RunTime:0.001615s ]
- [ 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' => 151,
'filtered' => 1.0000001192092896,
'extra' => 'Using where',
) ]
- [ SQL ] UPDATE `cmf_theme_file` SET `theme` = 're_sport09' , `action` = 'portal/Index/index' , `file` = 'portal/index' , `name` = '首頁' , `more` = '{\"vars\":[]}' , `config_more` = '{\"vars\":[]}' , `description` = '首頁模板文件' , `is_public` = 0 , `list_order` = 0 WHERE `theme` = 're_sport09' AND `file` = 'portal/index' [ RunTime:0.001690s ]
- [ SQL ] SELECT * FROM `cmf_theme_file` WHERE `theme` = 're_sport09' AND `file` = 'portal/list' LIMIT 1 [ RunTime:0.001658s ]
- [ 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' => 151,
'filtered' => 1.0000001192092896,
'extra' => 'Using where',
) ]
- [ SQL ] UPDATE `cmf_theme_file` SET `theme` = 're_sport09' , `action` = 'portal/List/index' , `file` = 'portal/list' , `name` = '資訊列表頁' , `more` = '[]' , `config_more` = '[]' , `description` = '資訊列表模板文件' , `is_public` = 0 , `list_order` = 10 WHERE `theme` = 're_sport09' AND `file` = 'portal/list' [ RunTime:0.001689s ]
- [ SQL ] SELECT * FROM `cmf_theme_file` WHERE `theme` = 're_sport09' AND `file` = 'portal/match' LIMIT 1 [ RunTime:0.001598s ]
- [ 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' => 151,
'filtered' => 1.0000001192092896,
'extra' => 'Using where',
) ]
- [ SQL ] UPDATE `cmf_theme_file` SET `theme` = 're_sport09' , `action` = 'portal/Match/index' , `file` = 'portal/match' , `name` = '賽事詳情頁' , `more` = '{\"vars\":[]}' , `config_more` = '{\"vars\":[]}' , `description` = '賽事詳情頁模板文件' , `is_public` = 0 , `list_order` = 10 WHERE `theme` = 're_sport09' AND `file` = 'portal/match' [ RunTime:0.001657s ]
- [ SQL ] SELECT * FROM `cmf_theme_file` WHERE `theme` = 're_sport09' [ RunTime:0.001666s ]
- [ 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' => 151,
'filtered' => 10.0,
'extra' => 'Using where',
) ]
- [ SQL ] SHOW COLUMNS FROM `cmf_theme` [ RunTime:0.001681s ]
- [ SQL ] UPDATE `cmf_theme` SET `name` = '7k_shanufs' , `version` = '1.0.2' , `demo_url` = '//www.shanufs.cn/' , `author` = '1408' , `lang` = 'zh-cn' , `author_url` = '' , `keywords` = '7k_shanufs' , `description` = '7k_shanufs' WHERE `theme` = 're_sport09' [ RunTime:0.001540s ]
- [ SQL ] SELECT `more` FROM `cmf_theme_file` WHERE `theme` = 're_sport09' AND ( `is_public` = 1 OR `file` = 'portal/competition' ) [ RunTime:0.001639s ]
- [ 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' => 151,
'filtered' => 1.899999976158142,
'extra' => 'Using where',
) ]
- [ SQL ] SELECT `id` FROM `cmf_plugin_web` WHERE `web_url` LIKE '%t4808.cn%' LIMIT 1 [ RunTime:0.001573s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_plugin_web',
'partitions' => NULL,
'type' => 'ALL',
'possible_keys' => NULL,
'key' => NULL,
'key_len' => NULL,
'ref' => NULL,
'rows' => 77,
'filtered' => 11.109999656677246,
'extra' => 'Using where',
) ]
- [ SQL ] SELECT `option_value` FROM `cmf_option` WHERE `option_name` = 'storage' AND `site_id` = 57 LIMIT 1 [ RunTime:0.001518s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_option',
'partitions' => NULL,
'type' => 'ref',
'possible_keys' => 'site_id',
'key' => 'site_id',
'key_len' => '5',
'ref' => 'const',
'rows' => 5,
'filtered' => 10.0,
'extra' => 'Using where',
) ]
- [ SQL ] SELECT `id` FROM `cmf_plugin_web` WHERE `web_url` LIKE '%t4808.cn%' LIMIT 1 [ RunTime:0.001532s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_plugin_web',
'partitions' => NULL,
'type' => 'ALL',
'possible_keys' => NULL,
'key' => NULL,
'key_len' => NULL,
'ref' => NULL,
'rows' => 77,
'filtered' => 11.109999656677246,
'extra' => 'Using where',
) ]
- [ SQL ] SELECT `config` FROM `cmf_plugin` WHERE `name` = 'Oss' AND `site_id` = 57 LIMIT 1 [ RunTime:0.001528s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_plugin',
'partitions' => NULL,
'type' => 'ALL',
'possible_keys' => NULL,
'key' => NULL,
'key_len' => NULL,
'ref' => NULL,
'rows' => 84,
'filtered' => 1.1904761791229248,
'extra' => 'Using where',
) ]
- [ SQL ] SELECT `id` FROM `cmf_plugin_web` WHERE `web_url` LIKE '%t4808.cn%' LIMIT 1 [ RunTime:0.001479s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_plugin_web',
'partitions' => NULL,
'type' => 'ALL',
'possible_keys' => NULL,
'key' => NULL,
'key_len' => NULL,
'ref' => NULL,
'rows' => 77,
'filtered' => 11.109999656677246,
'extra' => 'Using where',
) ]
- [ SQL ] SELECT `id` FROM `cmf_plugin_web` WHERE `web_url` LIKE '%t4808.cn%' LIMIT 1 [ RunTime:0.001819s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_plugin_web',
'partitions' => NULL,
'type' => 'ALL',
'possible_keys' => NULL,
'key' => NULL,
'key_len' => NULL,
'ref' => NULL,
'rows' => 77,
'filtered' => 11.109999656677246,
'extra' => 'Using where',
) ]
- [ SQL ] SHOW COLUMNS FROM `cmf_nav` [ RunTime:0.001685s ]
- [ SQL ] SELECT `id` FROM `cmf_nav` WHERE `is_main` = 1 LIMIT 1 [ RunTime:0.001516s ]
- [ 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 ] SELECT * FROM `cmf_nav_menu` WHERE `site_id` = 57 AND `nav_id` = 1 AND `status` = 1 ORDER BY `list_order` ASC [ RunTime:0.001738s ]
- [ 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' => 582,
'filtered' => 0.17182131111621857,
'extra' => 'Using where; Using filesort',
) ]
- [ SQL ] SELECT `id` FROM `cmf_plugin_web` WHERE `web_url` LIKE '%t4808.cn%' LIMIT 1 [ RunTime:0.001492s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_plugin_web',
'partitions' => NULL,
'type' => 'ALL',
'possible_keys' => NULL,
'key' => NULL,
'key_len' => NULL,
'ref' => NULL,
'rows' => 77,
'filtered' => 11.109999656677246,
'extra' => 'Using where',
) ]
- [ SQL ] SELECT * FROM `cmf_nami_matches` WHERE ( `match_time` > 1714319811 ) AND ( ( competition_id in (select cid from cmf_nami_competitions where recommend=1) ) ) ORDER BY `match_time` ASC LIMIT 1000 [ RunTime:0.015949s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_nami_matches',
'partitions' => NULL,
'type' => 'range',
'possible_keys' => 'match_time,season_id',
'key' => 'match_time',
'key_len' => '5',
'ref' => NULL,
'rows' => 16818,
'filtered' => 100.0,
'extra' => 'Using index condition',
) ]
- [ SQL ] SELECT * FROM `cmf_nami_competitions` WHERE `com_type` = 0 AND `cid` IN (315,108,238,266,10,120,175,121,142,151,1,201,13,435,465,2918,3,429,267,12,47,184,347,169,83,542,581,152,46,457,590,613,109,543,243,293,176,223,52,82,3265,568,567,195,130,168,57,159,544,161,202,186,158,220,492,316,396,398,491) [ RunTime:0.005087s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_nami_competitions',
'partitions' => NULL,
'type' => 'range',
'possible_keys' => 'cid',
'key' => 'cid',
'key_len' => '7',
'ref' => NULL,
'rows' => 59,
'filtered' => 100.0,
'extra' => 'Using index condition',
) ]
- [ SQL ] SELECT * FROM `cmf_nami_competitions` WHERE `com_type` = 1 AND `cid` IN (315,108,238,266,10,120,175,121,142,151,1,201,13,435,465,2918,3,429,267,12,47,184,347,169,83,542,581,152,46,457,590,613,109,543,243,293,176,223,52,82,3265,568,567,195,130,168,57,159,544,161,202,186,158,220,492,316,396,398,491) [ RunTime:0.002168s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_nami_competitions',
'partitions' => NULL,
'type' => 'range',
'possible_keys' => 'cid',
'key' => 'cid',
'key_len' => '7',
'ref' => NULL,
'rows' => 59,
'filtered' => 100.0,
'extra' => 'Using index condition',
) ]
- [ SQL ] SELECT `cid`,`short_name_zh`,`name_zh`,`logo` FROM `cmf_nami_teams` WHERE `com_type` = 0 AND `cid` IN (11006,11134,10278,11741,11343,10906,11060,11344,10648,10132,11054,10828,10493,11845,15323,16451,10458,14777,10252,15735,11372,10492,12206,16297,10491,10490,14825,10342,10826,10825,16157,10640,10059,18581,10496,10149,10208,10205,10031,10035,10029,10425,10974,10918,10148,10206,10600,10756,11304,15756,10818,17935,15945,13077,15217,16418,82053,74806,10639,10592,10199,10684,21596,68219,13189,10827,18440,11955,10140,19101,13770,11200,11575,10122,10123,12759,11393,10963,10678,10267,10153,10852,11040,10228,12568,10379,19328,10376,10043,11441,10811,10456,10015,10325,10174,10247,11523,24834,10813,10814,10138,34313,10438,10652,21947,10305,10218,10009,10767,10766,23094,53336,10393,76234,10245,10257,10016,10217,11071,20491,10700,45373,82052,16230,15569,10190,10416,23021,10417,10694,10238,10439,10415,10139,19717,30819,28419,13403,16822,48126,70422,48130,50542,10223,13157,10682,27727,27598,11135,17739,11076,12619,13402,12425,11503,10759,15645,12618,12015,21871,27611,27504,10171,10134,11056,10274,10907,18241,10296,16508,10764,21928,10052,15683,10242,10030,10368,50541,82054,30028,10230,33141,27993,10180,10183,10054,10411,10049,15734,14475,10336,10069,10066,10062,24121,12529,28038,25412,23959,31822,10593,25333,10527,21978,13756,15733,10909,11195,10337,18528,10061,20273,10334,11681,25413,10380,10526,10327,10457,16122,10898,10071,10908,10298,16160,10060,10525,10070,10972,10540,25763,17260,10727,10038,10051,10912,20678,10277,10976,10914,12094,10381,10082,10426,10085,10091,10427,10977,10077,10399,22288,10433,10443,10084,10329,10107,10455,10454,11265,10442,19950,21102,10039,10216,10965,10424,13408,11388,12524,12125,11482,10532,10294,13075,10068,11840,10250,11520,10042,10027,53112,34311,71374,18279,70469,10194,60824,60822,82055,60827,75181,74782,70423,53146,13026,10144,10324,10332,10590,10451,10302,10853,10047,10331,10913,10589,13568,10855,11274,70439,14346,48371,70441,60823,10215,10115,10008,10184,10290,10114,10175,10182,10006,10004,10022,10256,10538,10173,10023,10246,10130,10024,10101,11844,10681,10005,10365,10683,32737,10973,15475,10222,11260,10279,19620,10463,10092,10604,10118,10018,10010,10136,10021,10020,18737,10798,10846,20748,13802,12525,12214,11568,16263,12215,10387,12047,14101,12217,12866,10489,11666,10631,10632,11564,12663,13078,10237,15874,10858,14018,10488,11311,14994,15423,10896,27299,14272,15164,12669,69682,11801,29936,19654,14896,22971,28345,11401,18435,30960,12758,16752,35962,19501,24236,28749,10897,12458,56162,40366,18302,11802,40285,11472,31855,10300,10013,10465,10025,10040,10026,13407,10258,10928,12294,10014,10292,11847,19273,18400,21325,10398,16460,11262,10172,10133,23944,10002,10803,17327,24720,15571,35623,25693,10645,10964,10966,13572,10437,10744,10269,10273,42884,10400,11680,12321,29097,10266,12528,12431,11679,12433,15775,11194,16790,11627,10212,10181,10226,10808,10975,11078,10910,10595,10120,11574,11559,10464,10053,10240,10692,10109,11205,10757,10326,10251,11073,60286,10117,39883,17129,63659,11074,10460,55196,10110,12186,34314,10444,45111,16743,10098,10097,10461,12095,73924,26480,11072,10806,10096,34291,60821,74787,74666,14347,70460,71266,40074,70468,71376,74630,10432,10441,10375,10378,10421,53113,13028,69951,50536,10749,10423,10287,10647,10081,10075,10382,11007,11009,10012,10176,10729,11848,14343,10541,11264,10241,10371,10748,10079,10236,10521,10523,23373,16383,10696,10187,10633,10695,10522,11577,10249,10687,10746,10643,11198,20288,10420,16132,12727,24077,19905,32773,19025,31775,18401,25648,16639,10276,18816,32774,19876,13315,25728,31769,25764,10646,10293,21981,10143,11838,10203,18554,11151,10146,12260,19550,11709,10524,13571,16185,13999,30173,10899,13923,11364,22938,16450,32896,10188,11484,12296,62499,20979,24316,16300,10195,10967,22444,11578,15216,29434,29067,18759,10809,10220,10466,16285,10221,10301,10045,10531,10390,10080,10917,10467,10690,10044,10211,10210,10758,10807,10494,10147,12154,12153,10487,12434,10104,10440,10297,10244,10135,11207,10924,68331,44407,62603,12945,25681,15076,11055,15406,13289,23138,14299,25990,11057,21598,25349,62419,16620,14545,12391,12505,17859,14998,11572,13361,10377,11216,14637,11408,12344,15828,10801,14639,11206,19859,17673,10598,15968,14688,13360,12149,15235,10753,16007,13470,38802,10338,24114,25264,20475,10167,32639,52596,27849,19842,10093,53062,11303,61658,23810,10164,15674,27430,38730,11532,11946,10904,10108,33160,80473,82056,82057,19879,10529,23246,11339,11340,10750,43604,10197,10751,17249,43435,10112,24899,30642,10165,10083,10166,29566,19244,10428,21590,10105,21171,33035,10340,13335,10169,16524,10303,15857) [ RunTime:0.007369s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_nami_teams',
'partitions' => NULL,
'type' => 'range',
'possible_keys' => 'cid',
'key' => 'cid',
'key_len' => '7',
'ref' => NULL,
'rows' => 755,
'filtered' => 100.0,
'extra' => 'Using index condition',
) ]
- [ SQL ] SELECT `cid`,`short_name_zh`,`name_zh`,`logo` FROM `cmf_nami_teams` WHERE `com_type` = 0 AND `cid` IN (11867,10196,10116,10115,19417,10190,10130,10129,10122,10136,10131,10156,10722,10731,10724,10725,26990,40369,12296,14959,10316,19471,10246,10108,10740,11280,10345,11900,10135,10124,10154,10219,34753,25197,24884,12104,14163,10143,15747,12557,12417,24874,10193,10188,12568,14738,10266,11868,11137,10271,10192,12562,12256,10698,10191,11276,11281,10310,10723,12449,36251,10205,10692,10899,11526,11127,10142,35012,11531,14721,11530,12650,11850,37908,11537,11528,11517,10213,11533,11171,21874,14400,14436,27026,14960) [ RunTime:0.002203s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_nami_teams',
'partitions' => NULL,
'type' => 'range',
'possible_keys' => 'cid',
'key' => 'cid',
'key_len' => '7',
'ref' => NULL,
'rows' => 85,
'filtered' => 100.0,
'extra' => 'Using index condition',
) ]
- [ SQL ] SELECT `cid`,`short_name_zh`,`name_zh`,`logo` FROM `cmf_nami_teams` WHERE `com_type` = 1 AND `cid` IN (11006,11134,10278,11741,11343,10906,11060,11344,10648,10132,11054,10828,10493,11845,15323,16451,10458,14777,10252,15735,11372,10492,12206,16297,10491,10490,14825,10342,10826,10825,16157,10640,10059,18581,10496,10149,10208,10205,10031,10035,10029,10425,10974,10918,10148,10206,10600,10756,11304,15756,10818,17935,15945,13077,15217,16418,82053,74806,10639,10592,10199,10684,21596,68219,13189,10827,18440,11955,10140,19101,13770,11200,11575,10122,10123,12759,11393,10963,10678,10267,10153,10852,11040,10228,12568,10379,19328,10376,10043,11441,10811,10456,10015,10325,10174,10247,11523,24834,10813,10814,10138,34313,10438,10652,21947,10305,10218,10009,10767,10766,23094,53336,10393,76234,10245,10257,10016,10217,11071,20491,10700,45373,82052,16230,15569,10190,10416,23021,10417,10694,10238,10439,10415,10139,19717,30819,28419,13403,16822,48126,70422,48130,50542,10223,13157,10682,27727,27598,11135,17739,11076,12619,13402,12425,11503,10759,15645,12618,12015,21871,27611,27504,10171,10134,11056,10274,10907,18241,10296,16508,10764,21928,10052,15683,10242,10030,10368,50541,82054,30028,10230,33141,27993,10180,10183,10054,10411,10049,15734,14475,10336,10069,10066,10062,24121,12529,28038,25412,23959,31822,10593,25333,10527,21978,13756,15733,10909,11195,10337,18528,10061,20273,10334,11681,25413,10380,10526,10327,10457,16122,10898,10071,10908,10298,16160,10060,10525,10070,10972,10540,25763,17260,10727,10038,10051,10912,20678,10277,10976,10914,12094,10381,10082,10426,10085,10091,10427,10977,10077,10399,22288,10433,10443,10084,10329,10107,10455,10454,11265,10442,19950,21102,10039,10216,10965,10424,13408,11388,12524,12125,11482,10532,10294,13075,10068,11840,10250,11520,10042,10027,53112,34311,71374,18279,70469,10194,60824,60822,82055,60827,75181,74782,70423,53146,13026,10144,10324,10332,10590,10451,10302,10853,10047,10331,10913,10589,13568,10855,11274,70439,14346,48371,70441,60823,10215,10115,10008,10184,10290,10114,10175,10182,10006,10004,10022,10256,10538,10173,10023,10246,10130,10024,10101,11844,10681,10005,10365,10683,32737,10973,15475,10222,11260,10279,19620,10463,10092,10604,10118,10018,10010,10136,10021,10020,18737,10798,10846,20748,13802,12525,12214,11568,16263,12215,10387,12047,14101,12217,12866,10489,11666,10631,10632,11564,12663,13078,10237,15874,10858,14018,10488,11311,14994,15423,10896,27299,14272,15164,12669,69682,11801,29936,19654,14896,22971,28345,11401,18435,30960,12758,16752,35962,19501,24236,28749,10897,12458,56162,40366,18302,11802,40285,11472,31855,10300,10013,10465,10025,10040,10026,13407,10258,10928,12294,10014,10292,11847,19273,18400,21325,10398,16460,11262,10172,10133,23944,10002,10803,17327,24720,15571,35623,25693,10645,10964,10966,13572,10437,10744,10269,10273,42884,10400,11680,12321,29097,10266,12528,12431,11679,12433,15775,11194,16790,11627,10212,10181,10226,10808,10975,11078,10910,10595,10120,11574,11559,10464,10053,10240,10692,10109,11205,10757,10326,10251,11073,60286,10117,39883,17129,63659,11074,10460,55196,10110,12186,34314,10444,45111,16743,10098,10097,10461,12095,73924,26480,11072,10806,10096,34291,60821,74787,74666,14347,70460,71266,40074,70468,71376,74630,10432,10441,10375,10378,10421,53113,13028,69951,50536,10749,10423,10287,10647,10081,10075,10382,11007,11009,10012,10176,10729,11848,14343,10541,11264,10241,10371,10748,10079,10236,10521,10523,23373,16383,10696,10187,10633,10695,10522,11577,10249,10687,10746,10643,11198,20288,10420,16132,12727,24077,19905,32773,19025,31775,18401,25648,16639,10276,18816,32774,19876,13315,25728,31769,25764,10646,10293,21981,10143,11838,10203,18554,11151,10146,12260,19550,11709,10524,13571,16185,13999,30173,10899,13923,11364,22938,16450,32896,10188,11484,12296,62499,20979,24316,16300,10195,10967,22444,11578,15216,29434,29067,18759,10809,10220,10466,16285,10221,10301,10045,10531,10390,10080,10917,10467,10690,10044,10211,10210,10758,10807,10494,10147,12154,12153,10487,12434,10104,10440,10297,10244,10135,11207,10924,68331,44407,62603,12945,25681,15076,11055,15406,13289,23138,14299,25990,11057,21598,25349,62419,16620,14545,12391,12505,17859,14998,11572,13361,10377,11216,14637,11408,12344,15828,10801,14639,11206,19859,17673,10598,15968,14688,13360,12149,15235,10753,16007,13470,38802,10338,24114,25264,20475,10167,32639,52596,27849,19842,10093,53062,11303,61658,23810,10164,15674,27430,38730,11532,11946,10904,10108,33160,80473,82056,82057,19879,10529,23246,11339,11340,10750,43604,10197,10751,17249,43435,10112,24899,30642,10165,10083,10166,29566,19244,10428,21590,10105,21171,33035,10340,13335,10169,16524,10303,15857) [ RunTime:0.006870s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_nami_teams',
'partitions' => NULL,
'type' => 'range',
'possible_keys' => 'cid',
'key' => 'cid',
'key_len' => '7',
'ref' => NULL,
'rows' => 755,
'filtered' => 100.0,
'extra' => 'Using index condition',
) ]
- [ SQL ] SELECT `cid`,`short_name_zh`,`name_zh`,`logo` FROM `cmf_nami_teams` WHERE `com_type` = 1 AND `cid` IN (11867,10196,10116,10115,19417,10190,10130,10129,10122,10136,10131,10156,10722,10731,10724,10725,26990,40369,12296,14959,10316,19471,10246,10108,10740,11280,10345,11900,10135,10124,10154,10219,34753,25197,24884,12104,14163,10143,15747,12557,12417,24874,10193,10188,12568,14738,10266,11868,11137,10271,10192,12562,12256,10698,10191,11276,11281,10310,10723,12449,36251,10205,10692,10899,11526,11127,10142,35012,11531,14721,11530,12650,11850,37908,11537,11528,11517,10213,11533,11171,21874,14400,14436,27026,14960) [ RunTime:0.002346s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_nami_teams',
'partitions' => NULL,
'type' => 'range',
'possible_keys' => 'cid',
'key' => 'cid',
'key_len' => '7',
'ref' => NULL,
'rows' => 85,
'filtered' => 100.0,
'extra' => 'Using index condition',
) ]
- [ SQL ] SELECT `id` FROM `cmf_plugin_web` WHERE `web_url` LIKE '%t4808.cn%' LIMIT 1 [ RunTime:0.001812s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_plugin_web',
'partitions' => NULL,
'type' => 'ALL',
'possible_keys' => NULL,
'key' => NULL,
'key_len' => NULL,
'ref' => NULL,
'rows' => 77,
'filtered' => 11.109999656677246,
'extra' => 'Using where',
) ]
- [ SQL ] SELECT `id` FROM `cmf_nav` WHERE `is_main` = 1 LIMIT 1 [ RunTime:0.001496s ]
- [ 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 ] SELECT * FROM `cmf_nav_menu` WHERE `site_id` = 57 AND `nav_id` = 1 AND `status` = 1 ORDER BY `list_order` ASC [ RunTime:0.001740s ]
- [ 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' => 582,
'filtered' => 0.17182131111621857,
'extra' => 'Using where; Using filesort',
) ]
- [ SQL ] SELECT `id` FROM `cmf_plugin_web` WHERE `web_url` LIKE '%t4808.cn%' LIMIT 1 [ RunTime:0.001536s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_plugin_web',
'partitions' => NULL,
'type' => 'ALL',
'possible_keys' => NULL,
'key' => NULL,
'key_len' => NULL,
'ref' => NULL,
'rows' => 77,
'filtered' => 11.109999656677246,
'extra' => 'Using where',
) ]
- [ SQL ] SHOW COLUMNS FROM `cmf_link` [ RunTime:0.001641s ]
- [ SQL ] SELECT * FROM `cmf_link` WHERE `status` = 1 AND `site_id` = 57 ORDER BY `list_order` ASC [ RunTime:0.001564s ]
- [ 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' => 5,
'filtered' => 20.0,
'extra' => 'Using where; Using filesort',
) ]