ネイチャーテクノロジーデータベース NatureTech Database

History
+ –
Request History
4 previous requests available
====
Session
+ –
Session
- Config
  userAgent146b278961f0b80dc105e136efd48481
  time1714776314
  timeout10
====
Request
+ –
Request

Cake Params
- controllersearches
- actionresult
- named(empty)
- pass
  00
  183
- plugin(null)
- form(empty)
- url
  urlsearches/result/0/83
- isAjax(false)
$_GET
- urlsearches/result/0/83
Cookie
- 0(empty)
Current Route
- keys
  0controller
  1action
- options(empty)
- defaults
  plugin(null)
  actionindex
- template/:controller/:action/*
- _greedy(true)
- _compiledRoute#^/(?:([^/]+))/(?:([^/]+))(?:/(?P<_args_>.*))?[/]*$#
- __headerMap
  typecontent_type
  methodrequest_method
  serverserver_name
====

Sql Log

+ –

Sql Logs

default

Query	Affected	Num. rows	Took (ms)	Actions
SHOW FULL COLUMNS FROM `contents`	16	16	2	maybe slow
SELECT CHARACTER_SET_NAME FROM INFORMATION_SCHEMA.COLLATIONS WHERE COLLATION_NAME= 'utf8_general_ci';	1	1	1
SHOW FULL COLUMNS FROM `users`	10	10	1	maybe slow
SHOW FULL COLUMNS FROM `groups`	4	4	1	maybe slow
SHOW FULL COLUMNS FROM `permissions`	5	5	1	maybe slow
SHOW FULL COLUMNS FROM `groups_permissions`	3	3	1	maybe slow
SHOW FULL COLUMNS FROM `groups_users`	3	3	1	maybe slow
SHOW FULL COLUMNS FROM `contents_searches`	6	6	1	maybe slow
SHOW FULL COLUMNS FROM `attachments`	11	11	1	maybe slow
SHOW FULL COLUMNS FROM `attachments_revs`	13	13	9	maybe slow
SHOW FULL COLUMNS FROM `contents_related_items`	5	5	1	maybe slow
SHOW FULL COLUMNS FROM `related_items`	6	6	1	maybe slow
SHOW FULL COLUMNS FROM `contents_related_items_revs`	8	8	2	maybe slow
SHOW FULL COLUMNS FROM `contents_tags`	5	5	9	maybe slow
SHOW FULL COLUMNS FROM `tags`	7	7	1	maybe slow
SHOW FULL COLUMNS FROM `tag_groups`	6	6	9	maybe slow
SHOW FULL COLUMNS FROM `contents_tags_revs`	7	7	1	maybe slow
SHOW FULL COLUMNS FROM `contents_revs`	18	18	1	maybe slow
SELECT `TagGroup`.`id`, `TagGroup`.`code`, `TagGroup`.`name`, `TagGroup`.`created`, `TagGroup`.`modified`, `TagGroup`.`flag` FROM `tag_groups` AS `TagGroup` WHERE `flag` = 1	9	9	0
SELECT `Tag`.`id`, `Tag`.`tag_group_id`, `Tag`.`name`, `Tag`.`comment`, `Tag`.`created`, `Tag`.`modified`, `Tag`.`flag` FROM `tags` AS `Tag` WHERE `Tag`.`flag` = 1 AND `Tag`.`tag_group_id` IN (1, 2, 3, 4, 5, 6, 7, 8, 9)	129	129	0
SELECT `TagGroup`.`code`, `TagGroup`.`name` FROM `tag_groups` AS `TagGroup` WHERE id IN (1, 2, 3, 4, 5, 6)	6	6	0
SELECT MATCH (`related_items`, `tags`) AGAINST (' +"\|83\|"' IN BOOLEAN MODE) as score, content_id FROM `contents_searches` as `ContentsSearch` WHERE MATCH (`related_items`, `tags`) AGAINST (' +"\|83\|"' IN BOOLEAN MODE) ORDER BY score desc LIMIT 0, 11	4	4	0
SELECT `Content`.`id`, `Content`.`user_id`, `Content`.`last_edit_user_id`, `Content`.`post_date`, `Content`.`post_date_year`, `Content`.`post_date_month`, `Content`.`post_date_day`, `Content`.`title`, `Content`.`title_en`, `Content`.`content`, `Content`.`plain_content`, `Content`.`page_view`, `Content`.`flag`, `Content`.`mod_count`, `Content`.`created`, `Content`.`modified` FROM `contents` AS `Content` WHERE id IN (5, 63, 65, 67)	4	4	0
SELECT `Attachment`.`file_name`, `Attachment`.`dir`, `Attachment`.`model`, `Attachment`.`foreign_key` FROM `attachments` AS `Attachment` WHERE `file_name` <> 'default.jpg' AND `Attachment`.`foreign_key` IN (5, 63, 65, 67)	5	5	0
SELECT `ContentsRelatedItem`.`content`, `ContentsRelatedItem`.`related_item_id`, `ContentsRelatedItem`.`content_id` FROM `contents_related_items` AS `ContentsRelatedItem` WHERE `ContentsRelatedItem`.`content_id` IN (5, 63, 65, 67)	43	43	0
SELECT `RelatedItem`.`code`, `RelatedItem`.`name` FROM `related_items` AS `RelatedItem` WHERE `RelatedItem`.`id` = 1	1	1	0
SELECT `RelatedItem`.`code`, `RelatedItem`.`name` FROM `related_items` AS `RelatedItem` WHERE `RelatedItem`.`id` = 2	1	1	0
SELECT `RelatedItem`.`code`, `RelatedItem`.`name` FROM `related_items` AS `RelatedItem` WHERE `RelatedItem`.`id` = 5	1	1	0
SELECT `RelatedItem`.`code`, `RelatedItem`.`name` FROM `related_items` AS `RelatedItem` WHERE `RelatedItem`.`id` = 6	1	1	0
SELECT `RelatedItem`.`code`, `RelatedItem`.`name` FROM `related_items` AS `RelatedItem` WHERE `RelatedItem`.`id` = 7	1	1	0
SELECT `RelatedItem`.`code`, `RelatedItem`.`name` FROM `related_items` AS `RelatedItem` WHERE `RelatedItem`.`id` = 8	1	1	0
SELECT `RelatedItem`.`code`, `RelatedItem`.`name` FROM `related_items` AS `RelatedItem` WHERE `RelatedItem`.`id` = 9	1	1	0
SELECT `RelatedItem`.`code`, `RelatedItem`.`name` FROM `related_items` AS `RelatedItem` WHERE `RelatedItem`.`id` = 9	1	1	0
SELECT `RelatedItem`.`code`, `RelatedItem`.`name` FROM `related_items` AS `RelatedItem` WHERE `RelatedItem`.`id` = 9	1	1	0
SELECT `RelatedItem`.`code`, `RelatedItem`.`name` FROM `related_items` AS `RelatedItem` WHERE `RelatedItem`.`id` = 11	1	1	0
SELECT `RelatedItem`.`code`, `RelatedItem`.`name` FROM `related_items` AS `RelatedItem` WHERE `RelatedItem`.`id` = 1	1	1	0
SELECT `RelatedItem`.`code`, `RelatedItem`.`name` FROM `related_items` AS `RelatedItem` WHERE `RelatedItem`.`id` = 2	1	1	0
SELECT `RelatedItem`.`code`, `RelatedItem`.`name` FROM `related_items` AS `RelatedItem` WHERE `RelatedItem`.`id` = 5	1	1	0
SELECT `RelatedItem`.`code`, `RelatedItem`.`name` FROM `related_items` AS `RelatedItem` WHERE `RelatedItem`.`id` = 6	1	1	0
SELECT `RelatedItem`.`code`, `RelatedItem`.`name` FROM `related_items` AS `RelatedItem` WHERE `RelatedItem`.`id` = 7	1	1	0
SELECT `RelatedItem`.`code`, `RelatedItem`.`name` FROM `related_items` AS `RelatedItem` WHERE `RelatedItem`.`id` = 8	1	1	0
SELECT `RelatedItem`.`code`, `RelatedItem`.`name` FROM `related_items` AS `RelatedItem` WHERE `RelatedItem`.`id` = 9	1	1	0
SELECT `RelatedItem`.`code`, `RelatedItem`.`name` FROM `related_items` AS `RelatedItem` WHERE `RelatedItem`.`id` = 9	1	1	0
SELECT `RelatedItem`.`code`, `RelatedItem`.`name` FROM `related_items` AS `RelatedItem` WHERE `RelatedItem`.`id` = 9	1	1	0
SELECT `RelatedItem`.`code`, `RelatedItem`.`name` FROM `related_items` AS `RelatedItem` WHERE `RelatedItem`.`id` = 4	1	1	0
SELECT `RelatedItem`.`code`, `RelatedItem`.`name` FROM `related_items` AS `RelatedItem` WHERE `RelatedItem`.`id` = 11	1	1	0
SELECT `RelatedItem`.`code`, `RelatedItem`.`name` FROM `related_items` AS `RelatedItem` WHERE `RelatedItem`.`id` = 1	1	1	0
SELECT `RelatedItem`.`code`, `RelatedItem`.`name` FROM `related_items` AS `RelatedItem` WHERE `RelatedItem`.`id` = 2	1	1	0
SELECT `RelatedItem`.`code`, `RelatedItem`.`name` FROM `related_items` AS `RelatedItem` WHERE `RelatedItem`.`id` = 5	1	1	0
SELECT `RelatedItem`.`code`, `RelatedItem`.`name` FROM `related_items` AS `RelatedItem` WHERE `RelatedItem`.`id` = 6	1	1	0
SELECT `RelatedItem`.`code`, `RelatedItem`.`name` FROM `related_items` AS `RelatedItem` WHERE `RelatedItem`.`id` = 7	1	1	0
SELECT `RelatedItem`.`code`, `RelatedItem`.`name` FROM `related_items` AS `RelatedItem` WHERE `RelatedItem`.`id` = 8	1	1	0
SELECT `RelatedItem`.`code`, `RelatedItem`.`name` FROM `related_items` AS `RelatedItem` WHERE `RelatedItem`.`id` = 9	1	1	0
SELECT `RelatedItem`.`code`, `RelatedItem`.`name` FROM `related_items` AS `RelatedItem` WHERE `RelatedItem`.`id` = 9	1	1	0
SELECT `RelatedItem`.`code`, `RelatedItem`.`name` FROM `related_items` AS `RelatedItem` WHERE `RelatedItem`.`id` = 9	1	1	0
SELECT `RelatedItem`.`code`, `RelatedItem`.`name` FROM `related_items` AS `RelatedItem` WHERE `RelatedItem`.`id` = 4	1	1	0
SELECT `RelatedItem`.`code`, `RelatedItem`.`name` FROM `related_items` AS `RelatedItem` WHERE `RelatedItem`.`id` = 11	1	1	0
SELECT `RelatedItem`.`code`, `RelatedItem`.`name` FROM `related_items` AS `RelatedItem` WHERE `RelatedItem`.`id` = 1	1	1	0
SELECT `RelatedItem`.`code`, `RelatedItem`.`name` FROM `related_items` AS `RelatedItem` WHERE `RelatedItem`.`id` = 2	1	1	0
SELECT `RelatedItem`.`code`, `RelatedItem`.`name` FROM `related_items` AS `RelatedItem` WHERE `RelatedItem`.`id` = 5	1	1	0
SELECT `RelatedItem`.`code`, `RelatedItem`.`name` FROM `related_items` AS `RelatedItem` WHERE `RelatedItem`.`id` = 6	1	1	0
SELECT `RelatedItem`.`code`, `RelatedItem`.`name` FROM `related_items` AS `RelatedItem` WHERE `RelatedItem`.`id` = 7	1	1	0
SELECT `RelatedItem`.`code`, `RelatedItem`.`name` FROM `related_items` AS `RelatedItem` WHERE `RelatedItem`.`id` = 8	1	1	0
SELECT `RelatedItem`.`code`, `RelatedItem`.`name` FROM `related_items` AS `RelatedItem` WHERE `RelatedItem`.`id` = 9	1	1	0
SELECT `RelatedItem`.`code`, `RelatedItem`.`name` FROM `related_items` AS `RelatedItem` WHERE `RelatedItem`.`id` = 9	1	1	0
SELECT `RelatedItem`.`code`, `RelatedItem`.`name` FROM `related_items` AS `RelatedItem` WHERE `RelatedItem`.`id` = 9	1	1	0
SELECT `RelatedItem`.`code`, `RelatedItem`.`name` FROM `related_items` AS `RelatedItem` WHERE `RelatedItem`.`id` = 4	1	1	0
SELECT `RelatedItem`.`code`, `RelatedItem`.`name` FROM `related_items` AS `RelatedItem` WHERE `RelatedItem`.`id` = 11	1	1	0
SELECT `ContentsTag`.`id`, `ContentsTag`.`tag_group_id`, `ContentsTag`.`mod_count`, `ContentsTag`.`tag_id`, `ContentsTag`.`content_id` FROM `contents_tags` AS `ContentsTag` WHERE `ContentsTag`.`content_id` IN (5, 63, 65, 67)	14	14	0
SELECT `Tag`.`name`, `Tag`.`comment`, `Tag`.`tag_group_id` FROM `tags` AS `Tag` WHERE `Tag`.`id` = 62	1	1	0
SELECT `TagGroup`.`code`, `TagGroup`.`name` FROM `tag_groups` AS `TagGroup` WHERE `TagGroup`.`id` = 6	1	1	0
SELECT `Tag`.`name`, `Tag`.`comment`, `Tag`.`tag_group_id` FROM `tags` AS `Tag` WHERE `Tag`.`id` = 83	1	1	0
SELECT `TagGroup`.`code`, `TagGroup`.`name` FROM `tag_groups` AS `TagGroup` WHERE `TagGroup`.`id` = 6	1	1	0
SELECT `Tag`.`name`, `Tag`.`comment`, `Tag`.`tag_group_id` FROM `tags` AS `Tag` WHERE `Tag`.`id` = 100	1	1	0
SELECT `TagGroup`.`code`, `TagGroup`.`name` FROM `tag_groups` AS `TagGroup` WHERE `TagGroup`.`id` = 7	1	1	0
SELECT `Tag`.`name`, `Tag`.`comment`, `Tag`.`tag_group_id` FROM `tags` AS `Tag` WHERE `Tag`.`id` = 65	1	1	0
SELECT `TagGroup`.`code`, `TagGroup`.`name` FROM `tag_groups` AS `TagGroup` WHERE `TagGroup`.`id` = 6	1	1	0
SELECT `Tag`.`name`, `Tag`.`comment`, `Tag`.`tag_group_id` FROM `tags` AS `Tag` WHERE `Tag`.`id` = 83	1	1	0
SELECT `TagGroup`.`code`, `TagGroup`.`name` FROM `tag_groups` AS `TagGroup` WHERE `TagGroup`.`id` = 6	1	1	0
SELECT `Tag`.`name`, `Tag`.`comment`, `Tag`.`tag_group_id` FROM `tags` AS `Tag` WHERE `Tag`.`id` = 100	1	1	0
SELECT `TagGroup`.`code`, `TagGroup`.`name` FROM `tag_groups` AS `TagGroup` WHERE `TagGroup`.`id` = 7	1	1	0
SELECT `Tag`.`name`, `Tag`.`comment`, `Tag`.`tag_group_id` FROM `tags` AS `Tag` WHERE `Tag`.`id` = 21	1	1	0
SELECT `TagGroup`.`code`, `TagGroup`.`name` FROM `tag_groups` AS `TagGroup` WHERE `TagGroup`.`id` = 2	1	1	0
SELECT `Tag`.`name`, `Tag`.`comment`, `Tag`.`tag_group_id` FROM `tags` AS `Tag` WHERE `Tag`.`id` = 62	1	1	0
SELECT `TagGroup`.`code`, `TagGroup`.`name` FROM `tag_groups` AS `TagGroup` WHERE `TagGroup`.`id` = 6	1	1	0
SELECT `Tag`.`name`, `Tag`.`comment`, `Tag`.`tag_group_id` FROM `tags` AS `Tag` WHERE `Tag`.`id` = 65	1	1	0
SELECT `TagGroup`.`code`, `TagGroup`.`name` FROM `tag_groups` AS `TagGroup` WHERE `TagGroup`.`id` = 6	1	1	0
SELECT `Tag`.`name`, `Tag`.`comment`, `Tag`.`tag_group_id` FROM `tags` AS `Tag` WHERE `Tag`.`id` = 83	1	1	0
SELECT `TagGroup`.`code`, `TagGroup`.`name` FROM `tag_groups` AS `TagGroup` WHERE `TagGroup`.`id` = 6	1	1	0
SELECT `Tag`.`name`, `Tag`.`comment`, `Tag`.`tag_group_id` FROM `tags` AS `Tag` WHERE `Tag`.`id` = 100	1	1	12	maybe slow
SELECT `TagGroup`.`code`, `TagGroup`.`name` FROM `tag_groups` AS `TagGroup` WHERE `TagGroup`.`id` = 7	1	1	0
SELECT `Tag`.`name`, `Tag`.`comment`, `Tag`.`tag_group_id` FROM `tags` AS `Tag` WHERE `Tag`.`id` = 43	1	1	0
SELECT `TagGroup`.`code`, `TagGroup`.`name` FROM `tag_groups` AS `TagGroup` WHERE `TagGroup`.`id` = 4	1	1	0
SELECT `Tag`.`name`, `Tag`.`comment`, `Tag`.`tag_group_id` FROM `tags` AS `Tag` WHERE `Tag`.`id` = 83	1	1	0
SELECT `TagGroup`.`code`, `TagGroup`.`name` FROM `tag_groups` AS `TagGroup` WHERE `TagGroup`.`id` = 6	1	1	0
SELECT `Tag`.`name`, `Tag`.`comment`, `Tag`.`tag_group_id` FROM `tags` AS `Tag` WHERE `Tag`.`id` = 92	1	1	0
SELECT `TagGroup`.`code`, `TagGroup`.`name` FROM `tag_groups` AS `TagGroup` WHERE `TagGroup`.`id` = 7	1	1	0

Query Explain:

Click an "Explain" link above, to see the query explanation.

====

Timer

+ –

Memory

Peak Memory Use 9.56 MB

Message	Memory use
Component intitailization	6.72 MB
Controller action start	6.76 MB
Controller render start	6.93 MB
View render complete	7.99 MB

Timers

Total Request Time: 1461 (ms)

Message	Time in ms	Graph
Core Processing (Derived)	349.98
Component initialization and startup	20.03
Controller action	101.56
Render Controller Action	214.39
» Rendering View	210.19
» » Rendering APP/views/searches/result.ctp	46.61
» » Rendering APP/views/layouts/default.ctp	161.78
» » » Rendering APP/views/elements/header.ctp	1.60
» » » Rendering APP/views/elements/search_sidebar.ctp	150.44
» » » Rendering APP/views/elements/footer.ctp	0.59

====

Log
+ –

Logs

====
Variables
+ –
View Variables
- contentsArray
- has_next(false)
- has_before(false)
- next_start
- before_start
- tag_id83
- res_store_list
  1水回収
  2集光
  3光エネルギーの利用
  4蓄力
  5保温
  6保冷
  7保水
  8季節察知
  9場所把握
  10広視野
  11酸素補給
  12消音
  13データ蓄積
  14消臭
  15受信
- res_prod_list
  16発光
  17発電
  18発熱
  19放熱
  20色変化
  21におい
  22噴射
  23鉱物生成
  24繊維生成
  25動力生成
  26発信
- move_list
  27穴掘り
  28移動
  29浮遊
  30逆流防止
  31空調
  32再生
  33再利用
  34循環
  35除去
  36吸上げ
  37対流
  38自己治療
  39修復
  40飛翔
  41分離
  42ろ過
- structure_list
  43開閉
  44拡大
  45形変化
  46機能分散
  47環境改良
  48サイズ変化
  49質変化
  50重力利用
  51分解
  52自然現象の利用
- efficiency_list
  53エネルギーの効率的使用
  54軽量化
  55空気・水抵抗回避
  56効率的配置
  57学習
  58高強度
  59刺す
  60自己鋭利
- defense_list
  61安定
  62害虫管理
  63吸着
  64接着
  65耐外敵
  66耐火災
  67耐風
  68耐寒
  69耐衝撃
  70耐熱
  71耐光
  72耐微生物・細菌
  73耐引っ張り
  74長期保存
  75遮光
  76防汚
  77防腐
  78調光
  79温度調節
  80やすらぎ
  81調湿
  82断熱
  83攻撃
  84生体組織制御
  85撥水
  86引掛け
  87被覆
  88休眠
  89凝固阻止
- env_sol_list
  90循環
  91共有
  92ネットワーク
  93コミュニティ
  94リデュース
  95リユーズ
  96リサイクル
  97省エネ
  98省資源
  99長寿命
  100自然との共生
  101モノからサービスへ
  102愛着
  103簡明
  104創エネ
  175その他
- func_class_list
  res_store資源/エネ/情報の収集・貯蔵
  res_prod資源/エネ/情報の発信・生産
  move移動・廃棄・循環
  structure形状・組織・システム
  efficiency効率（省エネ、省資源、軽い）
  defense防御・安定
- appl_ind_seg_list
  141鉱業
  142建設業
  143食料品
  144繊維製品
  145パルプ・紙
  146化学
  147医薬品
  148石油・石炭製品
  149ゴム製品
  150ガラス・土石製品
  151鉄鋼
  152非鉄金属
- Auth(null)
- $this->data(null)
- $this->validationErrors(empty)
- Loaded Helpers
  0simpleGraph
  1number
  2htmlToolbar
  3toolbar
  4navi
  5layout
  6session
  7form
  8diff
  9javascript
  10html
====

Request History

Session

Request

Cake Params

$_GET

Cookie

Current Route

Sql Logs

default

Query Explain:

Memory

Timers

Logs

View Variables