挖泥清淤船
产品分类：清淤设备系列
日期：2021-03-05 预览：524
24小时咨询热线 :139-6460-2986
立即咨询
基本
文件
流程
错误
SQL
调试
- 请求信息 : 2023-12-12 02:06:04 HTTP/1.1 GET : www.sdxinshan.com/productshow/wnqyc.html
- 运行时间 : 0.218393s [ 吞吐率：4.58req/s ] 内存消耗：1,275.60kb 文件加载：135
- 查询信息 : 64 queries 3 writes
- 缓存信息 : 1 reads,0 writes
- 配置加载 : 67
- [ CACHE ] INIT File
- [ BEHAVIOR ] Run cmf\behavior\InitHookBehavior @app_init [ RunTime:0.006798s ]
- [ 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/wnqyc.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' => 'Wed, 22 Mar 2023 08:41:10 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' => 'wnqyc',
)
- [ 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.004925s ]
- [ LANG ] D:\wwwroot\xinshan\wwwroot/./app/portal\lang\zh-cn.php
- [ BEHAVIOR ] Run cmf\behavior\InitAppHookBehavior @module_init [ RunTime:0.001139s ]
- [ LANG ] D:\wwwroot\xinshan\wwwroot/./app/portal\lang\zh-cn\home.php
- [ BEHAVIOR ] Run cmf\behavior\HomeLangBehavior @home_init [ RunTime:0.001173s ]
- [ 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.003362s ] mysql:host=localhost;port=3306;dbname=xinshan;charset=utf8
- [ SQL ] SHOW COLUMNS FROM `cmf_liuliang` [ RunTime:0.002215s ]
- [ 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=wnqyc' , '127.0.0.1' , '未知' , '本机地址' , 1702317964 , '2023-12-12' , '未知' , '') [ RunTime:0.000680s ]
- [ SQL ] SHOW COLUMNS FROM `cmf_portal_post` [ RunTime:0.002445s ]
- [ SQL ] SELECT * FROM `cmf_portal_post` WHERE ( post_url = "wnqyc" ) LIMIT 1 [ RunTime:0.001223s ]
- [ 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.001822s ]
- [ SQL ] SELECT * FROM `cmf_portal_category_post` WHERE ( post_id = "1028" ) LIMIT 1 [ RunTime:0.000548s ]
- [ 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.001858s ]
- [ SQL ] SELECT `list_tpl` FROM `cmf_portal_category` WHERE `id` = 18 LIMIT 1 [ RunTime:0.000501s ]
- [ 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` = 18 AND `relation`.`post_id` = 1028 AND ( `post`.`published_time` < '1702317964' and `post`.`published_time` > '0' ) LIMIT 1 [ RunTime:0.000819s ]
- [ 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` = 18 AND `relation`.`post_id` < 1028 AND ( `post`.`published_time` < '1702317964' and `post`.`published_time` > '0' ) ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001348s ]
- [ 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' => 11,
'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` = 18 AND `relation`.`post_id` > 1028 AND ( `post`.`published_time` < '1702317964' and `post`.`published_time` > '0' ) ORDER BY `id` ASC LIMIT 1 [ RunTime:0.001284s ]
- [ 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' => 11,
'filtered' => 33.329998016357422,
'extra' => 'Using where; Using temporary; Using filesort',
) ]
- [ SQL ] SELECT * FROM `cmf_portal_category` WHERE `id` = 18 AND `status` = 1 LIMIT 1 [ RunTime:0.000485s ]
- [ 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 ] UPDATE `cmf_portal_post` SET `post_hits`=`post_hits`+1 WHERE `id` = 1028 [ RunTime:0.002750s ]
- [ SQL ] SHOW COLUMNS FROM `cmf_theme_file` [ RunTime:0.002008s ]
- [ SQL ] SELECT * FROM `cmf_theme_file` WHERE `theme` = 'test' [ RunTime:0.000413s ]
- [ 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.001654s ]
- [ 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.002501s ]
- [ SQL ] SELECT `more` FROM `cmf_theme_file` WHERE `theme` = 'test' AND ( `is_public` = 1 OR `file` = 'portal/product_show' ) [ RunTime:0.000408s ]
- [ 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.002247s ]
- [ SQL ] SELECT * FROM `cmf_nav_menu` WHERE ( status=1 ) AND ( parent_id=0 ) ORDER BY `list_order` ASC [ RunTime:0.000426s ]
- [ 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.000392s ]
- [ 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.000396s ]
- [ 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.002107s ]
- [ 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.000382s ]
- [ 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.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=6 ) ORDER BY `list_order` ASC [ RunTime:0.000358s ]
- [ 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.000346s ]
- [ 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.000407s ]
- [ 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.000400s ]
- [ 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.000417s ]
- [ 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.000417s ]
- [ 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.001892s ]
- [ 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.000629s ]
- [ 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` = 6 ORDER BY `p`.`id` ASC [ RunTime:0.001742s ]
- [ 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.000597s ]
- [ 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.000420s ]
- [ 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.001735s ]
- [ 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.000614s ]
- [ 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.000402s ]
- [ 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.001375s ]
- [ 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.000504s ]
- [ 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.000401s ]
- [ 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.001660s ]
- [ 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.000458s ]
- [ 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.000439s ]
- [ 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.001955s ]
- [ 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.000545s ]
- [ 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.000418s ]
- [ 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.001709s ]
- [ 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.000473s ]
- [ 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.000401s ]
- [ 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.001319s ]
- [ 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.000408s ]
- [ 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.000362s ]
- [ 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.000337s ]
- [ 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.000306s ]
- [ 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.000394s ]
- [ 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=1028 [ RunTime:0.000591s ]
- [ 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=18 [ RunTime:0.000465s ]
- [ 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.002259s ]
- [ SQL ] SELECT `option_value` FROM `cmf_option` WHERE `option_name` = 'storage' LIMIT 1 [ RunTime:0.000385s ]
- [ 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.001451s ]
- [ SQL ] SELECT * FROM `cmf_plugin_guestbook` WHERE ( recommended=1 ) [ RunTime:0.000374s ]
- [ 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` = 18 AND `p`.`id` <> 1028 AND ( p.delete_time=0 ) ORDER BY `p`.`id` ASC LIMIT 4 [ RunTime:0.001375s ]
- [ 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` = 18 AND `p`.`id` <> 1028 AND ( p.delete_time=0 ) ORDER BY `p`.`id` ASC LIMIT 4,4 [ RunTime:0.001400s ]
- [ 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.221684s
