効率的に情報伝達するミツバチ

ミツバチは蜜源までの距離や方角、そして蜜の質までも示すことができるダンスをして、お互いに情報伝達を行っている。蜜を発見したミツバチは巣に戻ってきてから蜜源を教え、かつ蜜の量に適切なミツバチの数がその場所に向かう。また一箇所にミツバチが過剰に集まることなく、各蜜源に適切にミツバチが配置され、効率的に蜜を集める共同作業を行う。

資源/エネ/情報の発信・生産:: 発光

ジョブショッピングスケジュール問題の解決に応用されている。

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

Cake Params
- controllercontents
- actionview
- named(empty)
- pass
  057
- plugin(null)
- form(empty)
- url
  urlcontents/view/57
- isAjax(false)
$_GET
- urlcontents/view/57
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	1	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	2	maybe slow
SHOW FULL COLUMNS FROM `permissions`	5	5	1	maybe slow
SHOW FULL COLUMNS FROM `groups_permissions`	3	3	2	maybe slow
SHOW FULL COLUMNS FROM `groups_users`	3	3	5	maybe slow
SHOW FULL COLUMNS FROM `contents_searches`	6	6	0
SHOW FULL COLUMNS FROM `attachments`	11	11	0
SHOW FULL COLUMNS FROM `attachments_revs`	13	13	2	maybe slow
SHOW FULL COLUMNS FROM `contents_related_items`	5	5	2	maybe slow
SHOW FULL COLUMNS FROM `related_items`	6	6	2	maybe slow
SHOW FULL COLUMNS FROM `contents_related_items_revs`	8	8	3	maybe slow
SHOW FULL COLUMNS FROM `contents_tags`	5	5	0
SHOW FULL COLUMNS FROM `tags`	7	7	0
SHOW FULL COLUMNS FROM `tag_groups`	6	6	0
SHOW FULL COLUMNS FROM `contents_tags_revs`	7	7	0
SHOW FULL COLUMNS FROM `contents_revs`	18	18	1	maybe slow
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` = 57 LIMIT 1	1	1	3	maybe slow
SELECT `Attachment`.`file_name`, `Attachment`.`dir`, `Attachment`.`model`, `Attachment`.`foreign_key` FROM `attachments` AS `Attachment` WHERE `file_name` <> 'default.jpg' AND `Attachment`.`foreign_key` = (57)	1	1	0
SELECT `ContentsRelatedItem`.`content`, `ContentsRelatedItem`.`related_item_id`, `ContentsRelatedItem`.`content_id` FROM `contents_related_items` AS `ContentsRelatedItem` WHERE `ContentsRelatedItem`.`content_id` = (57)	11	11	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` = (57)	3	3	1	maybe slow
SELECT `Tag`.`name`, `Tag`.`comment`, `Tag`.`tag_group_id` FROM `tags` AS `Tag` WHERE `Tag`.`id` = 16	1	1	0
SELECT `TagGroup`.`code`, `TagGroup`.`name` FROM `tag_groups` AS `TagGroup` WHERE `TagGroup`.`id` = 2	1	1	3	maybe slow
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
SELECT `Tag`.`name`, `Tag`.`comment`, `Tag`.`tag_group_id` FROM `tags` AS `Tag` WHERE `Tag`.`id` = 93	1	1	0
SELECT `TagGroup`.`code`, `TagGroup`.`name` FROM `tag_groups` AS `TagGroup` WHERE `TagGroup`.`id` = 7	1	1	0
SELECT `RelatedItem`.`id`, `RelatedItem`.`code`, `RelatedItem`.`name`, `RelatedItem`.`created`, `RelatedItem`.`modified`, `RelatedItem`.`flag` FROM `related_items` AS `RelatedItem` WHERE `code` = 'function' LIMIT 1	1	1	0
SELECT `Content`.`id`, `Content`.`title`, `Content`.`title_en` FROM `contents` AS `Content` WHERE id = (NULL) ORDER BY `id` desc	0	0	0

Query Explain:

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

====

Timer

+ –

Memory

Peak Memory Use 8.79 MB

Message	Memory use
Component intitailization	6.79 MB
Controller action start	6.83 MB
Controller render start	6.90 MB
View render complete	7.93 MB

Timers

Total Request Time: 438 (ms)

Message	Time in ms	Graph
Core Processing (Derived)	138.32
Component initialization and startup	8.34
Controller action	24.84
Render Controller Action	41.58
» Rendering View	31.72
» » Rendering APP/views/contents/view.ctp	14.10
» » Rendering APP/views/layouts/default.ctp	11.93
» » » Rendering APP/views/elements/header.ctp	0.92
» » » Rendering APP/views/elements/content_sidebar.ctp	0.21
» » » Rendering APP/views/elements/footer.ctp	0.18

====

Log
+ –

Logs

====
Variables
+ –
View Variables
- content
  contentsTags
  0
  id998
  tag_group_id2
  mod_count2
  tag_id16
  content_id57
  Tag
  name発光
  comment(null)
  tag_group_id2
  TagGroup
  coderes_prod
  name資源/エネ/情報の発信・生産
  1
  id999
  tag_group_id7
  mod_count2
  tag_id92
  content_id57
  Tag
  nameネットワーク
  comment(null)
  tag_group_id7
  TagGroup
  codeenv_sol
  name環境ソリューション分類
  2
  id1000
  tag_group_id7
  mod_count2
  tag_id93
  content_id57
  Tag
  nameコミュニティ
  comment(null)
  tag_group_id7
  TagGroup
  codeenv_sol
  name環境ソリューション分類
  attachments
  0
  file_nameMQ==.jpeg
  dirimg/Content/57
  modelContent
  foreign_key57
  contentsRelatedItems
  function
  0ミツバチは蜜源までの距離や方角、そして蜜の質までも示すことができるダンスをして、お互いに情報伝達を行っている。蜜を発見したミツバチは巣に戻ってきてから蜜源を教え、かつ蜜の量に適切なミツバチの数がその場所に向かう。また一箇所にミツバチが過剰に集まることなく、各蜜源に適切にミツバチが配置され、効率的に蜜を集める共同作業を行う。
  ref_info
  0
  reg_num
  0
  appl_tech
  0ジョブショッピングスケジュール問題の解決に応用されている。
  product
  0
  appl_tech_sugg
  0
  img_exp
  0①尻振りダンス：採餌蜂を召集する。 ②身震いダンス：貯蜜蜂を召集する。 ③振動：内勤蜂を採餌蜂にする。 50秒以上待つときは→② Photo by <a href="http://www.flickr.com/photos/da100fotos/" target="_blank">Danny Perez Photography</a> / <a href="http://creativecommons.org/licenses/by-nc-nd/2.0/" target="_blank">CC BY-NC-ND 2.0</a><br /><span style="font-size:80%;">すごい自然データベースより引用</span>
  1
  2
  reg_info
  0
  related_content_id
  0
  properties
  id57
  user_id29
  last_edit_user_id29
  post_date2011-02-04
  post_date_year
  post_date_month
  post_date_day
  title効率的に情報伝達するミツバチ
  title_en
  content
  plain_content
  page_view0
  flag1
  mod_count2
  created2011-02-04 17:47:44
  modified2011-02-10 15:51:09
- related_contentsArray
- Auth(null)
- $this->data(null)
- $this->validationErrors(empty)
- Loaded Helpers
  0simpleGraph
  1number
  2htmlToolbar
  3toolbar
  4navi
  5layout
  6session
  7form
  8contentElement
  9javascript
  10html
====

効率的に情報伝達するミツバチ

Request History

Session

Request

Cake Params

$_GET

Cookie

Current Route

Sql Logs

default

Query Explain:

Memory

Timers

Logs

View Variables