基本
文件
流程
错误
SQL
调试
- 请求信息 : 2022-05-19 21:02:39 HTTP/1.1 GET : www.sdxinshan.com/contact.html
- 运行时间 : 0.254279s [ 吞吐率：3.93req/s ] 内存消耗：1,047.03kb 文件加载：118
- 查询信息 : 47 queries 2 writes
- 缓存信息 : 0 reads,0 writes
- 配置加载 : 67
- [ CACHE ] INIT File
- [ BEHAVIOR ] Run cmf\behavior\InitHookBehavior @app_init [ RunTime:0.006489s ]
- [ LANG ] D:\wwwroot\xinshan\wwwroot\simplewind\thinkphp\lang\zh-cn.php
- [ ROUTE ] array (
'type' => 'module',
'module' =>
array (
0 => 'portal',
1 => 'Page',
2 => 'index',
),
'convert' => false,
)
- [ HEADER ] array (
'content-type' => '',
'content-length' => '0',
'x-original-url' => '/contact.html',
'x-real-ip' => '3.238.180.255',
'x-forwarded-for' => '3.238.180.255',
'user-agent' => 'CCBot/2.0 (https://commoncrawl.org/faq/)',
'if-modified-since' => 'Sun, 05 Dec 2021 05:45:17 GMT',
'host' => 'www.sdxinshan.com',
'accept-language' => 'en-US,en;q=0.5',
'accept-encoding' => 'br,gzip',
'accept' => 'text/html,application/xhtml+xml,application/xml;q=0.9,*/*;q=0.8',
'connection' => 'close',
)
- [ PARAM ] array (
'id' => '222',
)
- [ LANG ] D:\wwwroot\xinshan\wwwroot\simplewind\cmf\behavior/../lang\zh-cn.php
- [ LANG ] D:\wwwroot\xinshan\wwwroot/./app/admin\lang\zh-cn\common.php
- [ LANG ] D:\wwwroot\xinshan\wwwroot/./app/portal\lang\zh-cn\common.php
- [ BEHAVIOR ] Run cmf\behavior\LangBehavior @app_begin [ RunTime:0.004887s ]
- [ LANG ] D:\wwwroot\xinshan\wwwroot/./app/portal\lang\zh-cn.php
- [ BEHAVIOR ] Run cmf\behavior\InitAppHookBehavior @module_init [ RunTime:0.001119s ]
- [ LANG ] D:\wwwroot\xinshan\wwwroot/./app/portal\lang\zh-cn\home.php
- [ BEHAVIOR ] Run cmf\behavior\HomeLangBehavior @home_init [ RunTime:0.001750s ]
- [ DB ] INIT mysql
- [ RUN ] app\portal\controller\PageController->index[ D:\wwwroot\xinshan\wwwroot\app\portal\controller\PageController.php ]
- [ VIEW ] D:\wwwroot\xinshan\wwwroot/themes/test/portal\contact.html [ array (
0 => 'site_info',
1 => 'banner_show',
2 => 'l_id',
3 => 'page',
4 => 'theme_vars',
5 => 'theme_widgets',
) ]
- [ DB ] CONNECT:[ UseTime:0.008201s ] mysql:host=localhost;port=3306;dbname=xinshan;charset=utf8
- [ SQL ] SHOW COLUMNS FROM `cmf_liuliang` [ RunTime:0.002819s ]
- [ SQL ] INSERT INTO `cmf_liuliang` (`llurl` , `fwurl` , `ip` , `ssyq` , `city` , `addtime` , `addtime1` , `keyword` , `zhongduan`) VALUES ('未开发' , 'www.sdxinshan.com/index.php?s=contact.html' , '127.0.0.1' , '未知' , '本机地址' , 1652965359 , '2022-05-19' , '未知' , '') [ RunTime:0.000914s ]
- [ SQL ] SHOW COLUMNS FROM `cmf_portal_post` [ RunTime:0.003426s ]
- [ SQL ] SELECT * FROM `cmf_portal_post` WHERE `post_type` = 2 AND `post_status` = 1 AND `delete_time` = 0 AND `id` = 222 AND ( `published_time` < 1652965359 and `published_time` > 0 ) LIMIT 1 [ RunTime:0.001665s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_portal_post',
'partitions' => NULL,
'type' => 'const',
'possible_keys' => 'PRIMARY,type_status_date',
'key' => 'PRIMARY',
'key_len' => '8',
'ref' => 'const',
'rows' => 1,
'filtered' => 100,
'extra' => NULL,
) ]
- [ SQL ] SELECT * FROM `cmf_portal_post` WHERE `id` = 222 LIMIT 1 [ RunTime:0.001007s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_portal_post',
'partitions' => NULL,
'type' => 'const',
'possible_keys' => 'PRIMARY',
'key' => 'PRIMARY',
'key_len' => '8',
'ref' => 'const',
'rows' => 1,
'filtered' => 100,
'extra' => NULL,
) ]
- [ SQL ] SHOW COLUMNS FROM `cmf_theme_file` [ RunTime:0.003752s ]
- [ SQL ] SELECT * FROM `cmf_theme_file` WHERE `theme` = 'test' [ RunTime:0.000862s ]
- [ 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_theme` [ RunTime:0.002629s ]
- [ SQL ] UPDATE `cmf_theme` SET `name`='simpleboot3',`version`='1.0.2',`demo_url`='http://demo.thinkcmf.com',`author`='ThinkCMF',`lang`='zh-cn',`author_url`='http://www.thinkcmf.com',`keywords`='ThinkCMF模板',`description`='ThinkCMF默认模板' WHERE `theme` = 'test' [ RunTime:0.002806s ]
- [ SQL ] SELECT `more` FROM `cmf_theme_file` WHERE `theme` = 'test' AND ( `is_public` = 1 OR `file` = 'portal/contact' ) [ RunTime:0.000763s ]
- [ 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_menu` [ RunTime:0.003486s ]
- [ SQL ] SELECT * FROM `cmf_nav_menu` WHERE ( status=1 ) AND ( parent_id=0 ) ORDER BY `list_order` ASC [ RunTime:0.000936s ]
- [ 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' => 13,
'filtered' => 7.6923074722290039,
'extra' => 'Using where; Using filesort',
) ]
- [ SQL ] SELECT * FROM `cmf_nav_menu` WHERE ( parent_id=10 ) ORDER BY `list_order` ASC [ RunTime:0.000965s ]
- [ 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' => 13,
'filtered' => 10,
'extra' => 'Using where; Using filesort',
) ]
- [ SQL ] SELECT * FROM `cmf_nav_menu` WHERE ( parent_id=1 ) ORDER BY `list_order` ASC [ RunTime:0.000650s ]
- [ 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' => 13,
'filtered' => 10,
'extra' => 'Using where; Using filesort',
) ]
- [ SQL ] SELECT * FROM `cmf_portal_post` `p` INNER JOIN `cmf_portal_category_post` `h` ON `p`.`id`=`h`.`post_id` INNER JOIN `cmf_portal_category` `c` ON `h`.`category_id`=`c`.`id` WHERE ( h.category_id in (5,6,8,16,17,18,19,20,21,22) ) AND ( p.is_top=1 ) AND ( p.delete_time=0 ) ORDER BY `p`.`id` ASC LIMIT 5,2 [ RunTime:0.006032s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'p',
'partitions' => NULL,
'type' => 'ALL',
'possible_keys' => 'PRIMARY',
'key' => NULL,
'key_len' => NULL,
'ref' => NULL,
'rows' => 212,
'filtered' => 1.0000001192092896,
'extra' => 'Using where; Using temporary; Using filesort',
) ]
- [ SQL ] SELECT * FROM `cmf_nav_menu` WHERE ( parent_id=5 ) ORDER BY `list_order` ASC [ RunTime:0.000872s ]
- [ 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' => 13,
'filtered' => 10,
'extra' => 'Using where; Using filesort',
) ]
- [ SQL ] SELECT * FROM `cmf_nav_menu` WHERE ( parent_id=9 ) ORDER BY `list_order` ASC [ RunTime:0.000795s ]
- [ 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' => 13,
'filtered' => 10,
'extra' => 'Using where; Using filesort',
) ]
- [ SQL ] SELECT * FROM `cmf_nav_menu` WHERE ( parent_id=6 ) ORDER BY `list_order` ASC [ RunTime:0.000742s ]
- [ 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' => 13,
'filtered' => 10,
'extra' => 'Using where; Using filesort',
) ]
- [ SQL ] SELECT * FROM `cmf_nav_menu` WHERE ( status=1 ) AND ( parent_id=0 ) ORDER BY `list_order` ASC [ RunTime:0.000677s ]
- [ 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' => 13,
'filtered' => 7.6923074722290039,
'extra' => 'Using where; Using filesort',
) ]
- [ SQL ] SELECT * FROM `cmf_nav_menu` WHERE ( parent_id=10 ) ORDER BY `list_order` ASC [ RunTime:0.000519s ]
- [ 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' => 13,
'filtered' => 10,
'extra' => 'Using where; Using filesort',
) ]
- [ SQL ] SELECT * FROM `cmf_nav_menu` WHERE ( parent_id=1 ) ORDER BY `list_order` ASC [ RunTime:0.000485s ]
- [ 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' => 13,
'filtered' => 10,
'extra' => 'Using where; Using filesort',
) ]
- [ SQL ] SHOW COLUMNS FROM `cmf_portal_category` [ RunTime:0.001353s ]
- [ SQL ] SELECT * FROM `cmf_portal_category` WHERE `id` = 5 LIMIT 1 [ RunTime:0.000807s ]
- [ 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,
'extra' => NULL,
) ]
- [ SQL ] SELECT * FROM `cmf_portal_category` WHERE `id` = 1 LIMIT 1 [ RunTime:0.000670s ]
- [ 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,
'extra' => NULL,
) ]
- [ SQL ] SELECT * FROM `cmf_portal_post` `p` INNER JOIN `cmf_portal_category_post` `h` ON `p`.`id`=`h`.`post_id` INNER JOIN `cmf_portal_category` `c` ON `h`.`category_id`=`c`.`id` WHERE `h`.`category_id` = 5 ORDER BY `p`.`id` ASC [ RunTime:0.002513s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'c',
'partitions' => NULL,
'type' => 'const',
'possible_keys' => 'PRIMARY',
'key' => 'PRIMARY',
'key_len' => '8',
'ref' => 'const',
'rows' => 1,
'filtered' => 100,
'extra' => 'Using temporary; Using filesort',
) ]
- [ SQL ] SELECT * FROM `cmf_portal_category` WHERE `id` = 6 LIMIT 1 [ RunTime:0.001726s ]
- [ 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,
'extra' => NULL,
) ]
- [ SQL ] SELECT * FROM `cmf_portal_category` WHERE `id` = 1 LIMIT 1 [ RunTime:0.000681s ]
- [ 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,
'extra' => NULL,
) ]
- [ SQL ] SELECT * FROM `cmf_portal_post` `p` INNER JOIN `cmf_portal_category_post` `h` ON `p`.`id`=`h`.`post_id` INNER JOIN `cmf_portal_category` `c` ON `h`.`category_id`=`c`.`id` WHERE `h`.`category_id` = 6 ORDER BY `p`.`id` ASC [ RunTime:0.002481s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'c',
'partitions' => NULL,
'type' => 'const',
'possible_keys' => 'PRIMARY',
'key' => 'PRIMARY',
'key_len' => '8',
'ref' => 'const',
'rows' => 1,
'filtered' => 100,
'extra' => 'Using temporary; Using filesort',
) ]
- [ SQL ] SELECT * FROM `cmf_portal_category` WHERE `id` = 8 LIMIT 1 [ RunTime:0.000708s ]
- [ 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,
'extra' => NULL,
) ]
- [ SQL ] SELECT * FROM `cmf_portal_category` WHERE `id` = 1 LIMIT 1 [ RunTime:0.000442s ]
- [ 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,
'extra' => NULL,
) ]
- [ SQL ] SELECT * FROM `cmf_portal_post` `p` INNER JOIN `cmf_portal_category_post` `h` ON `p`.`id`=`h`.`post_id` INNER JOIN `cmf_portal_category` `c` ON `h`.`category_id`=`c`.`id` WHERE `h`.`category_id` = 8 ORDER BY `p`.`id` ASC [ RunTime:0.002380s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'c',
'partitions' => NULL,
'type' => 'const',
'possible_keys' => 'PRIMARY',
'key' => 'PRIMARY',
'key_len' => '8',
'ref' => 'const',
'rows' => 1,
'filtered' => 100,
'extra' => 'Using temporary; Using filesort',
) ]
- [ SQL ] SELECT * FROM `cmf_portal_category` WHERE `id` = 17 LIMIT 1 [ RunTime:0.000902s ]
- [ 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,
'extra' => NULL,
) ]
- [ SQL ] SELECT * FROM `cmf_portal_category` WHERE `id` = 1 LIMIT 1 [ RunTime:0.000690s ]
- [ 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,
'extra' => NULL,
) ]
- [ SQL ] SELECT * FROM `cmf_portal_post` `p` INNER JOIN `cmf_portal_category_post` `h` ON `p`.`id`=`h`.`post_id` INNER JOIN `cmf_portal_category` `c` ON `h`.`category_id`=`c`.`id` WHERE `h`.`category_id` = 17 ORDER BY `p`.`id` ASC [ RunTime:0.001907s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'c',
'partitions' => NULL,
'type' => 'const',
'possible_keys' => 'PRIMARY',
'key' => 'PRIMARY',
'key_len' => '8',
'ref' => 'const',
'rows' => 1,
'filtered' => 100,
'extra' => 'Using temporary; Using filesort',
) ]
- [ SQL ] SELECT * FROM `cmf_portal_category` WHERE `id` = 18 LIMIT 1 [ RunTime:0.000851s ]
- [ 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,
'extra' => NULL,
) ]
- [ SQL ] SELECT * FROM `cmf_portal_category` WHERE `id` = 1 LIMIT 1 [ RunTime:0.000670s ]
- [ 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,
'extra' => NULL,
) ]
- [ SQL ] SELECT * FROM `cmf_portal_post` `p` INNER JOIN `cmf_portal_category_post` `h` ON `p`.`id`=`h`.`post_id` INNER JOIN `cmf_portal_category` `c` ON `h`.`category_id`=`c`.`id` WHERE `h`.`category_id` = 18 ORDER BY `p`.`id` ASC [ RunTime:0.002267s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'c',
'partitions' => NULL,
'type' => 'const',
'possible_keys' => 'PRIMARY',
'key' => 'PRIMARY',
'key_len' => '8',
'ref' => 'const',
'rows' => 1,
'filtered' => 100,
'extra' => 'Using temporary; Using filesort',
) ]
- [ SQL ] SELECT * FROM `cmf_portal_category` WHERE `id` = 19 LIMIT 1 [ RunTime:0.000790s ]
- [ 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,
'extra' => NULL,
) ]
- [ SQL ] SELECT * FROM `cmf_portal_category` WHERE `id` = 1 LIMIT 1 [ RunTime:0.000534s ]
- [ 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,
'extra' => NULL,
) ]
- [ SQL ] SELECT * FROM `cmf_portal_post` `p` INNER JOIN `cmf_portal_category_post` `h` ON `p`.`id`=`h`.`post_id` INNER JOIN `cmf_portal_category` `c` ON `h`.`category_id`=`c`.`id` WHERE `h`.`category_id` = 19 ORDER BY `p`.`id` ASC [ RunTime:0.002438s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'c',
'partitions' => NULL,
'type' => 'const',
'possible_keys' => 'PRIMARY',
'key' => 'PRIMARY',
'key_len' => '8',
'ref' => 'const',
'rows' => 1,
'filtered' => 100,
'extra' => 'Using temporary; Using filesort',
) ]
- [ SQL ] SELECT * FROM `cmf_portal_category` WHERE `id` = 20 LIMIT 1 [ RunTime:0.000935s ]
- [ 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,
'extra' => NULL,
) ]
- [ SQL ] SELECT * FROM `cmf_portal_category` WHERE `id` = 1 LIMIT 1 [ RunTime:0.000537s ]
- [ 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,
'extra' => NULL,
) ]
- [ SQL ] SELECT * FROM `cmf_portal_post` `p` INNER JOIN `cmf_portal_category_post` `h` ON `p`.`id`=`h`.`post_id` INNER JOIN `cmf_portal_category` `c` ON `h`.`category_id`=`c`.`id` WHERE `h`.`category_id` = 20 ORDER BY `p`.`id` ASC [ RunTime:0.002133s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'c',
'partitions' => NULL,
'type' => 'const',
'possible_keys' => 'PRIMARY',
'key' => 'PRIMARY',
'key_len' => '8',
'ref' => 'const',
'rows' => 1,
'filtered' => 100,
'extra' => 'Using temporary; Using filesort',
) ]
- [ SQL ] SELECT * FROM `cmf_portal_category` WHERE `id` = 35 LIMIT 1 [ RunTime:0.000713s ]
- [ 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,
'extra' => NULL,
) ]
- [ SQL ] SELECT * FROM `cmf_portal_category` WHERE `id` = 1 LIMIT 1 [ RunTime:0.000387s ]
- [ 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,
'extra' => NULL,
) ]
- [ SQL ] SELECT * FROM `cmf_portal_post` `p` INNER JOIN `cmf_portal_category_post` `h` ON `p`.`id`=`h`.`post_id` INNER JOIN `cmf_portal_category` `c` ON `h`.`category_id`=`c`.`id` WHERE `h`.`category_id` = 35 ORDER BY `p`.`id` ASC [ RunTime:0.001523s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'c',
'partitions' => NULL,
'type' => 'const',
'possible_keys' => 'PRIMARY',
'key' => 'PRIMARY',
'key_len' => '8',
'ref' => 'const',
'rows' => 1,
'filtered' => 100,
'extra' => 'Using temporary; Using filesort',
) ]
- [ SQL ] SELECT * FROM `cmf_nav_menu` WHERE ( parent_id=5 ) ORDER BY `list_order` ASC [ RunTime:0.000455s ]
- [ 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' => 13,
'filtered' => 10,
'extra' => 'Using where; Using filesort',
) ]
- [ SQL ] SELECT * FROM `cmf_nav_menu` WHERE ( parent_id=9 ) ORDER BY `list_order` ASC [ RunTime:0.000367s ]
- [ 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' => 13,
'filtered' => 10,
'extra' => 'Using where; Using filesort',
) ]
- [ SQL ] SELECT * FROM `cmf_nav_menu` WHERE ( parent_id=6 ) ORDER BY `list_order` ASC [ RunTime:0.000540s ]
- [ 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' => 13,
'filtered' => 10,
'extra' => 'Using where; Using filesort',
) ]
0.258697s
