基本
文件
流程
错误
SQL
调试
- 请求信息 : 2023-03-22 18:03:10 HTTP/1.1 GET : www.sdxinshan.com/doujiang.html
- 运行时间 : 0.175996s [ 吞吐率：5.68req/s ] 内存消耗：1,125.54kb 文件加载：122
- 查询信息 : 52 queries 2 writes
- 缓存信息 : 0 reads,0 writes
- 配置加载 : 67
- [ CACHE ] INIT File
- [ BEHAVIOR ] Run cmf\behavior\InitHookBehavior @app_init [ RunTime:0.003098s ]
- [ LANG ] D:\wwwroot\xinshan\wwwroot\simplewind\thinkphp\lang\zh-cn.php
- [ ROUTE ] array (
'type' => 'module',
'module' =>
array (
0 => 'portal',
1 => 'List',
2 => 'index',
),
'convert' => false,
)
- [ HEADER ] array (
'content-type' => '',
'content-length' => '0',
'x-original-url' => '/doujiang.html',
'x-real-ip' => '44.200.171.156',
'x-forwarded-for' => '44.200.171.156',
'user-agent' => 'CCBot/2.0 (https://commoncrawl.org/faq/)',
'if-modified-since' => 'Tue, 06 Dec 2022 04:31:56 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' => '18',
)
- [ 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.002191s ]
- [ LANG ] D:\wwwroot\xinshan\wwwroot/./app/portal\lang\zh-cn.php
- [ BEHAVIOR ] Run cmf\behavior\InitAppHookBehavior @module_init [ RunTime:0.000787s ]
- [ LANG ] D:\wwwroot\xinshan\wwwroot/./app/portal\lang\zh-cn\home.php
- [ BEHAVIOR ] Run cmf\behavior\HomeLangBehavior @home_init [ RunTime:0.001259s ]
- [ DB ] INIT mysql
- [ RUN ] app\portal\controller\ListController->index[ D:\wwwroot\xinshan\wwwroot\app\portal\controller\ListController.php ]
- [ VIEW ] D:\wwwroot\xinshan\wwwroot/themes/test/portal\product.html [ array (
0 => 'site_info',
1 => 'banner_show',
2 => 'l_p_art',
3 => 'page',
4 => 'category',
5 => 'theme_vars',
6 => 'theme_widgets',
) ]
- [ DB ] CONNECT:[ UseTime:0.004917s ] mysql:host=localhost;port=3306;dbname=xinshan;charset=utf8
- [ SQL ] SHOW COLUMNS FROM `cmf_liuliang` [ RunTime:0.001705s ]
- [ SQL ] INSERT INTO `cmf_liuliang` (`llurl` , `fwurl` , `ip` , `ssyq` , `city` , `addtime` , `addtime1` , `keyword` , `zhongduan`) VALUES ('未开发' , 'www.sdxinshan.com/index.php?s=doujiang.html' , '127.0.0.1' , '未知' , '本机地址' , 1679479390 , '2023-03-22' , '未知' , '') [ RunTime:0.000574s ]
- [ SQL ] SHOW COLUMNS FROM `cmf_portal_category` [ RunTime:0.002095s ]
- [ SQL ] SELECT * FROM `cmf_portal_category` WHERE `id` = 18 AND `status` = 1 LIMIT 1 [ RunTime:0.000642s ]
- [ 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.000421s ]
- [ 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 ] SHOW COLUMNS FROM `cmf_portal_post` [ RunTime:0.002259s ]
- [ SQL ] SELECT COUNT(*) AS tp_count 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' AND ( p.delete_time=0 ) LIMIT 1 [ RunTime:0.001542s ]
- [ 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 index',
) ]
- [ 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' AND ( p.delete_time=0 ) ORDER BY `p`.`id` ASC LIMIT 0,9 [ RunTime:0.001534s ]
- [ 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 ] SHOW COLUMNS FROM `cmf_theme_file` [ RunTime:0.002520s ]
- [ SQL ] SELECT * FROM `cmf_theme_file` WHERE `theme` = 'test' [ RunTime:0.000412s ]
- [ 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.001948s ]
- [ 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.003957s ]
- [ SQL ] SELECT `more` FROM `cmf_theme_file` WHERE `theme` = 'test' AND ( `is_public` = 1 OR `file` = 'portal/product' ) [ RunTime:0.001403s ]
- [ 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.002160s ]
- [ SQL ] SELECT * FROM `cmf_nav_menu` WHERE ( status=1 ) AND ( parent_id=0 ) ORDER BY `list_order` ASC [ RunTime:0.000409s ]
- [ 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.000415s ]
- [ 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.000366s ]
- [ 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.000599s ]
- [ 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.000375s ]
- [ 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.000372s ]
- [ 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.000333s ]
- [ 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.000602s ]
- [ 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.000493s ]
- [ 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.000447s ]
- [ 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_category` WHERE `id` = 5 LIMIT 1 [ RunTime:0.000479s ]
- [ 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.000570s ]
- [ 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.000718s ]
- [ 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.000454s ]
- [ 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.000349s ]
- [ 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.000583s ]
- [ 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.000526s ]
- [ 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.000347s ]
- [ 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.000601s ]
- [ 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.000571s ]
- [ 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.000398s ]
- [ 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.000596s ]
- [ 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.000508s ]
- [ 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.000476s ]
- [ 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.000702s ]
- [ 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.000535s ]
- [ 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.000328s ]
- [ 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.000789s ]
- [ 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.000764s ]
- [ 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.000453s ]
- [ 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.000630s ]
- [ 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.000632s ]
- [ 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.000433s ]
- [ 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.000558s ]
- [ 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.000666s ]
- [ 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.000472s ]
- [ 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.000515s ]
- [ 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 name,alias from cmf_portal_category where id=1 [ RunTime:0.000391s ]
- [ 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 name,alias from cmf_portal_category where id=18 [ RunTime:0.000598s ]
- [ 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 `parent_id` = 1 AND ( delete_time=0 ) ORDER BY `id` ASC [ RunTime:0.000779s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_portal_category',
'partitions' => NULL,
'type' => 'index',
'possible_keys' => NULL,
'key' => 'PRIMARY',
'key_len' => '8',
'ref' => NULL,
'rows' => 20,
'filtered' => 5,
'extra' => 'Using where',
) ]
0.179032s
