破碎机
产品分类：破碎设备系列
日期：2021-03-05 预览：481
24小时咨询热线 :139-6460-2986
立即咨询
基本
文件
流程
错误
SQL
调试
- 请求信息 : 2023-12-12 01:57:18 HTTP/1.1 GET : www.sdxinshan.com/productshow/psj93254.html
- 运行时间 : 0.261833s [ 吞吐率：3.82req/s ] 内存消耗：1,275.52kb 文件加载：135
- 查询信息 : 64 queries 3 writes
- 缓存信息 : 1 reads,0 writes
- 配置加载 : 67
- [ CACHE ] INIT File
- [ BEHAVIOR ] Run cmf\behavior\InitHookBehavior @app_init [ RunTime:0.003446s ]
- [ 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/psj93254.html',
'x-real-ip' => '44.220.249.141',
'x-forwarded-for' => '44.220.249.141',
'user-agent' => 'CCBot/2.0 (https://commoncrawl.org/faq/)',
'if-modified-since' => 'Tue, 07 Feb 2023 07:16:01 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' => 'psj93254',
)
- [ 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.002532s ]
- [ LANG ] D:\wwwroot\xinshan\wwwroot/./app/portal\lang\zh-cn.php
- [ BEHAVIOR ] Run cmf\behavior\InitAppHookBehavior @module_init [ RunTime:0.000785s ]
- [ LANG ] D:\wwwroot\xinshan\wwwroot/./app/portal\lang\zh-cn\home.php
- [ BEHAVIOR ] Run cmf\behavior\HomeLangBehavior @home_init [ RunTime:0.001204s ]
- [ 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.015127s ] mysql:host=localhost;port=3306;dbname=xinshan;charset=utf8
- [ SQL ] SHOW COLUMNS FROM `cmf_liuliang` [ RunTime:0.003098s ]
- [ 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=psj93254' , '127.0.0.1' , '未知' , '本机地址' , 1702317438 , '2023-12-12' , '未知' , '') [ RunTime:0.000839s ]
- [ SQL ] SHOW COLUMNS FROM `cmf_portal_post` [ RunTime:0.002404s ]
- [ SQL ] SELECT * FROM `cmf_portal_post` WHERE ( post_url = "psj93254" ) LIMIT 1 [ RunTime:0.001346s ]
- [ 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.002168s ]
- [ SQL ] SELECT * FROM `cmf_portal_category_post` WHERE ( post_id = "1066" ) LIMIT 1 [ RunTime:0.000718s ]
- [ 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.002172s ]
- [ SQL ] SELECT `list_tpl` FROM `cmf_portal_category` WHERE `id` = 6 LIMIT 1 [ RunTime:0.000606s ]
- [ 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` = 1066 AND ( `post`.`published_time` < '1702317438' and `post`.`published_time` > '0' ) LIMIT 1 [ RunTime:0.001082s ]
- [ 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` < 1066 AND ( `post`.`published_time` < '1702317438' and `post`.`published_time` > '0' ) ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001573s ]
- [ 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` > 1066 AND ( `post`.`published_time` < '1702317438' and `post`.`published_time` > '0' ) ORDER BY `id` ASC LIMIT 1 [ RunTime:0.001975s ]
- [ 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.000961s ]
- [ 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.000427s ]
- [ 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` = 1066 [ RunTime:0.003627s ]
- [ SQL ] SHOW COLUMNS FROM `cmf_theme_file` [ RunTime:0.002578s ]
- [ SQL ] SELECT * FROM `cmf_theme_file` WHERE `theme` = 'test' [ RunTime:0.000477s ]
- [ 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.002020s ]
- [ 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.002715s ]
- [ SQL ] SELECT `more` FROM `cmf_theme_file` WHERE `theme` = 'test' AND ( `is_public` = 1 OR `file` = 'portal/product_show' ) [ RunTime:0.000439s ]
- [ 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.002545s ]
- [ SQL ] SELECT * FROM `cmf_nav_menu` WHERE ( status=1 ) AND ( parent_id=0 ) ORDER BY `list_order` ASC [ RunTime:0.000509s ]
- [ 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.000497s ]
- [ 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.000509s ]
- [ 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.002355s ]
- [ 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.000423s ]
- [ 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.000411s ]
- [ 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.000456s ]
- [ 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.000461s ]
- [ 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.000403s ]
- [ 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.000414s ]
- [ 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.000577s ]
- [ 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.000474s ]
- [ 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.002116s ]
- [ 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.000677s ]
- [ 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.000404s ]
- [ 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.001811s ]
- [ 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.000496s ]
- [ 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.000631s ]
- [ 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.003105s ]
- [ 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.000809s ]
- [ 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.000568s ]
- [ 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.001884s ]
- [ 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.000730s ]
- [ 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.000505s ]
- [ 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.001970s ]
- [ 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.000730s ]
- [ 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.000588s ]
- [ 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.002578s ]
- [ 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.000982s ]
- [ 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.000755s ]
- [ 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.002072s ]
- [ 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.000749s ]
- [ 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` = 35 ORDER BY `p`.`id` ASC [ RunTime:0.001324s ]
- [ 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.000430s ]
- [ 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.000347s ]
- [ 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.000361s ]
- [ 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.000505s ]
- [ 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.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_category_post where post_id=1066 [ RunTime:0.000675s ]
- [ 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.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 ] SHOW COLUMNS FROM `cmf_option` [ RunTime:0.002714s ]
- [ SQL ] SELECT `option_value` FROM `cmf_option` WHERE `option_name` = 'storage' LIMIT 1 [ RunTime:0.000548s ]
- [ 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.001872s ]
- [ SQL ] SELECT * FROM `cmf_plugin_guestbook` WHERE ( recommended=1 ) [ RunTime:0.000596s ]
- [ 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' => 252,
'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` <> 1066 AND ( p.delete_time=0 ) ORDER BY `p`.`id` ASC LIMIT 4 [ RunTime:0.001904s ]
- [ 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` <> 1066 AND ( p.delete_time=0 ) ORDER BY `p`.`id` ASC LIMIT 4,4 [ RunTime:0.001629s ]
- [ 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.267262s
