破碎机
产品分类：破碎设备系列
日期：2021-03-19 预览：357
24小时咨询热线 :139-6460-2986
立即咨询
基本
文件
流程
错误
SQL
调试
- 请求信息 : 2023-03-22 18:25:46 HTTP/1.1 GET : www.sdxinshan.com/productshow/psj1958.html
- 运行时间 : 0.256651s [ 吞吐率：3.90req/s ] 内存消耗：1,276.00kb 文件加载：135
- 查询信息 : 64 queries 3 writes
- 缓存信息 : 1 reads,0 writes
- 配置加载 : 67
- [ CACHE ] INIT File
- [ BEHAVIOR ] Run cmf\behavior\InitHookBehavior @app_init [ RunTime:0.002840s ]
- [ LANG ] D:\wwwroot\xinshan\wwwroot\simplewind\thinkphp\lang\zh-cn.php
- [ ROUTE ] array (
'type' => 'module',
'module' =>
array (
0 => 'portal',
1 => 'Article',
2 => 'index',
),
)
- [ HEADER ] array (
'content-type' => '',
'content-length' => '0',
'x-original-url' => '/productshow/psj1958.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' => 'Fri, 12 Aug 2022 06:42:33 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 (
'url' => 'psj1958',
)
- [ 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.001792s ]
- [ LANG ] D:\wwwroot\xinshan\wwwroot/./app/portal\lang\zh-cn.php
- [ BEHAVIOR ] Run cmf\behavior\InitAppHookBehavior @module_init [ RunTime:0.000739s ]
- [ LANG ] D:\wwwroot\xinshan\wwwroot/./app/portal\lang\zh-cn\home.php
- [ BEHAVIOR ] Run cmf\behavior\HomeLangBehavior @home_init [ RunTime:0.001164s ]
- [ DB ] INIT mysql
- [ RUN ] app\portal\controller\ArticleController->index[ D:\wwwroot\xinshan\wwwroot\app\portal\controller\ArticleController.php ]
- [ VIEW ] D:\wwwroot\xinshan\wwwroot/themes/test/portal\product_show.html [ array (
0 => 'site_info',
1 => 'banner_show',
2 => 'category',
3 => 'categoryId',
4 => 'article',
5 => 'prev_article',
6 => 'next_article',
7 => 'theme_vars',
8 => 'theme_widgets',
) ]
- [ DB ] CONNECT:[ UseTime:0.016756s ] mysql:host=localhost;port=3306;dbname=xinshan;charset=utf8
- [ SQL ] SHOW COLUMNS FROM `cmf_liuliang` [ RunTime:0.002335s ]
- [ SQL ] INSERT INTO `cmf_liuliang` (`llurl` , `fwurl` , `ip` , `ssyq` , `city` , `addtime` , `addtime1` , `keyword` , `zhongduan`) VALUES ('未开发' , 'www.sdxinshan.com/index.php?s=portal/Article/index&url=psj1958' , '127.0.0.1' , '未知' , '本机地址' , 1679480746 , '2023-03-22' , '未知' , '') [ RunTime:0.000579s ]
- [ SQL ] SHOW COLUMNS FROM `cmf_portal_post` [ RunTime:0.002773s ]
- [ SQL ] SELECT * FROM `cmf_portal_post` WHERE ( post_url = "psj1958" ) LIMIT 1 [ RunTime:0.005080s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_portal_post',
'partitions' => NULL,
'type' => 'ALL',
'possible_keys' => NULL,
'key' => NULL,
'key_len' => NULL,
'ref' => NULL,
'rows' => 212,
'filtered' => 10,
'extra' => 'Using where',
) ]
- [ SQL ] SHOW COLUMNS FROM `cmf_portal_category_post` [ RunTime:0.002048s ]
- [ SQL ] SELECT * FROM `cmf_portal_category_post` WHERE ( post_id = "1106" ) LIMIT 1 [ RunTime:0.001416s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_portal_category_post',
'partitions' => NULL,
'type' => 'ALL',
'possible_keys' => NULL,
'key' => NULL,
'key_len' => NULL,
'ref' => NULL,
'rows' => 216,
'filtered' => 10,
'extra' => 'Using where',
) ]
- [ SQL ] SHOW COLUMNS FROM `cmf_portal_category` [ RunTime:0.001937s ]
- [ SQL ] SELECT `list_tpl` FROM `cmf_portal_category` WHERE `id` = 6 LIMIT 1 [ RunTime:0.001020s ]
- [ 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 `post`.* FROM `cmf_portal_post` `post` INNER JOIN `cmf_portal_category_post` `relation` ON `post`.`id`=`relation`.`post_id` WHERE `post`.`post_type` = 1 AND `post`.`post_status` = 1 AND `post`.`delete_time` = 0 AND `relation`.`category_id` = 6 AND `relation`.`post_id` = 1106 AND ( `post`.`published_time` < '1679480746' and `post`.`published_time` > '0' ) LIMIT 1 [ RunTime:0.001429s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => '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 `post`.* FROM `cmf_portal_post` `post` INNER JOIN `cmf_portal_category_post` `relation` ON `post`.`id`=`relation`.`post_id` WHERE `post`.`post_type` = 1 AND `post`.`post_status` = 1 AND `post`.`delete_time` = 0 AND `relation`.`category_id` = 6 AND `relation`.`post_id` < 1106 AND ( `post`.`published_time` < '1679480746' and `post`.`published_time` > '0' ) ORDER BY `id` DESC LIMIT 1 [ RunTime:0.002514s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'relation',
'partitions' => NULL,
'type' => 'ref',
'possible_keys' => 'term_taxonomy_id',
'key' => 'term_taxonomy_id',
'key_len' => '8',
'ref' => 'const',
'rows' => 18,
'filtered' => 33.329998016357422,
'extra' => 'Using where; Using temporary; Using filesort',
) ]
- [ SQL ] SELECT `post`.* FROM `cmf_portal_post` `post` INNER JOIN `cmf_portal_category_post` `relation` ON `post`.`id`=`relation`.`post_id` WHERE `post`.`post_type` = 1 AND `post`.`post_status` = 1 AND `post`.`delete_time` = 0 AND `relation`.`category_id` = 6 AND `relation`.`post_id` > 1106 AND ( `post`.`published_time` < '1679480746' and `post`.`published_time` > '0' ) ORDER BY `id` ASC LIMIT 1 [ RunTime:0.004110s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'relation',
'partitions' => NULL,
'type' => 'ref',
'possible_keys' => 'term_taxonomy_id',
'key' => 'term_taxonomy_id',
'key_len' => '8',
'ref' => 'const',
'rows' => 18,
'filtered' => 33.329998016357422,
'extra' => 'Using where; Using temporary; Using filesort',
) ]
- [ SQL ] SELECT * FROM `cmf_portal_category` WHERE `id` = 6 AND `status` = 1 LIMIT 1 [ RunTime:0.000538s ]
- [ 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.000408s ]
- [ 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 ] UPDATE `cmf_portal_post` SET `post_hits`=`post_hits`+1 WHERE `id` = 1106 [ RunTime:0.003066s ]
- [ SQL ] SHOW COLUMNS FROM `cmf_theme_file` [ RunTime:0.002644s ]
- [ SQL ] SELECT * FROM `cmf_theme_file` WHERE `theme` = 'test' [ RunTime:0.000481s ]
- [ 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.002079s ]
- [ 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.003500s ]
- [ SQL ] SELECT `more` FROM `cmf_theme_file` WHERE `theme` = 'test' AND ( `is_public` = 1 OR `file` = 'portal/product_show' ) [ RunTime:0.000451s ]
- [ 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.003233s ]
- [ SQL ] SELECT * FROM `cmf_nav_menu` WHERE ( status=1 ) AND ( parent_id=0 ) ORDER BY `list_order` ASC [ RunTime:0.000555s ]
- [ 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.000522s ]
- [ 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.000480s ]
- [ 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.005061s ]
- [ 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.000435s ]
- [ 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.000502s ]
- [ 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.000387s ]
- [ 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.000334s ]
- [ 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.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=1 ) ORDER BY `list_order` ASC [ RunTime:0.000381s ]
- [ 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.000390s ]
- [ 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.000411s ]
- [ 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.003125s ]
- [ 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.000616s ]
- [ 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.000414s ]
- [ 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.002499s ]
- [ 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.000483s ]
- [ 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.000414s ]
- [ 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.003177s ]
- [ 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.000582s ]
- [ 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.000370s ]
- [ 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.002054s ]
- [ 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.000464s ]
- [ 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.000438s ]
- [ 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.002102s ]
- [ 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.000470s ]
- [ 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` = 19 ORDER BY `p`.`id` ASC [ RunTime:0.003864s ]
- [ 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.000609s ]
- [ 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.000397s ]
- [ 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.003213s ]
- [ 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.000527s ]
- [ 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.000478s ]
- [ 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.002237s ]
- [ 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.000434s ]
- [ 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.000387s ]
- [ 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.000406s ]
- [ 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.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 name,alias from cmf_portal_category where id=6 [ RunTime:0.000538s ]
- [ 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_post where post_id=1106 [ RunTime:0.001004s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_portal_category_post',
'partitions' => NULL,
'type' => 'ALL',
'possible_keys' => NULL,
'key' => NULL,
'key_len' => NULL,
'ref' => NULL,
'rows' => 216,
'filtered' => 10,
'extra' => 'Using where',
) ]
- [ SQL ] select * from cmf_portal_category where id=6 [ RunTime:0.000541s ]
- [ 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_option` [ RunTime:0.002943s ]
- [ SQL ] SELECT `option_value` FROM `cmf_option` WHERE `option_name` = 'storage' LIMIT 1 [ RunTime:0.000559s ]
- [ 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_plugin_guestbook` [ RunTime:0.001888s ]
- [ SQL ] SELECT * FROM `cmf_plugin_guestbook` WHERE ( recommended=1 ) [ RunTime:0.000449s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_plugin_guestbook',
'partitions' => NULL,
'type' => 'ALL',
'possible_keys' => NULL,
'key' => NULL,
'key_len' => NULL,
'ref' => NULL,
'rows' => 120,
'filtered' => 10,
'extra' => 'Using where',
) ]
- [ 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 AND `p`.`id` <> 1106 AND ( p.delete_time=0 ) ORDER BY `p`.`id` ASC LIMIT 4 [ RunTime:0.003383s ]
- [ 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_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 AND `p`.`id` <> 1106 AND ( p.delete_time=0 ) ORDER BY `p`.`id` ASC LIMIT 4,4 [ RunTime:0.002333s ]
- [ 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',
) ]
0.259943s
