- 広く浅く根を張って効率よく栄養を吸収する熱帯雨林の木
- 熱帯雨林の土壌は20cm程しかないため、木は主根を地下に浅くしか張れず、幹の近くに巨大な側根をおろす...
- 地面を高速で歩き回るゴキブリ
- ゴキブリは6本脚を規則正しく動かして歩くが、歩行中は必ず3本の脚が地面と接して体を支えるように脚を...
| Query | Error | 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 | 13 | maybe slow | |
| SHOW FULL COLUMNS FROM `groups_permissions` | 3 | 3 | 1 | maybe slow | |
| SHOW FULL COLUMNS FROM `groups_users` | 3 | 3 | 9 | maybe slow | |
| SHOW FULL COLUMNS FROM `contents_searches` | 6 | 6 | 1 | maybe slow | |
| SHOW FULL COLUMNS FROM `attachments` | 11 | 11 | 9 | maybe slow | |
| SHOW FULL COLUMNS FROM `attachments_revs` | 13 | 13 | 1 | 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 | 1 | maybe slow | |
| SHOW FULL COLUMNS FROM `contents_tags` | 5 | 5 | 1 | maybe slow | |
| SHOW FULL COLUMNS FROM `tags` | 7 | 7 | 1 | maybe slow | |
| SHOW FULL COLUMNS FROM `tag_groups` | 6 | 6 | 1 | 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 (' +"|61|"' IN BOOLEAN MODE) as score, content_id FROM `contents_searches` as `ContentsSearch` WHERE MATCH (`related_items`, `tags`) AGAINST (' +"|61|"' IN BOOLEAN MODE) ORDER BY score desc LIMIT 0, 11 | 2 | 2 | 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 (36, 97) | 2 | 2 | 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 (36, 97) | 3 | 3 | 0 | ||
| SELECT `ContentsRelatedItem`.`content`, `ContentsRelatedItem`.`related_item_id`, `ContentsRelatedItem`.`content_id` FROM `contents_related_items` AS `ContentsRelatedItem` WHERE `ContentsRelatedItem`.`content_id` IN (36, 97) | 22 | 22 | 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 | 8 | maybe slow | |
| 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 (36, 97) | 7 | 7 | 0 | ||
| SELECT `Tag`.`name`, `Tag`.`comment`, `Tag`.`tag_group_id` FROM `tags` AS `Tag` WHERE `Tag`.`id` = 56 | 1 | 1 | 0 | ||
| SELECT `TagGroup`.`code`, `TagGroup`.`name` FROM `tag_groups` AS `TagGroup` WHERE `TagGroup`.`id` = 5 | 1 | 1 | 0 | ||
| SELECT `Tag`.`name`, `Tag`.`comment`, `Tag`.`tag_group_id` FROM `tags` AS `Tag` WHERE `Tag`.`id` = 58 | 1 | 1 | 0 | ||
| SELECT `TagGroup`.`code`, `TagGroup`.`name` FROM `tag_groups` AS `TagGroup` WHERE `TagGroup`.`id` = 5 | 1 | 1 | 0 | ||
| SELECT `Tag`.`name`, `Tag`.`comment`, `Tag`.`tag_group_id` FROM `tags` AS `Tag` WHERE `Tag`.`id` = 61 | 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` = 97 | 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` = 28 | 1 | 1 | 0 | ||
| SELECT `TagGroup`.`code`, `TagGroup`.`name` FROM `tag_groups` AS `TagGroup` WHERE `TagGroup`.`id` = 3 | 1 | 1 | 0 | ||
| SELECT `Tag`.`name`, `Tag`.`comment`, `Tag`.`tag_group_id` FROM `tags` AS `Tag` WHERE `Tag`.`id` = 61 | 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` = 175 | 1 | 1 | 0 | ||
| SELECT `TagGroup`.`code`, `TagGroup`.`name` FROM `tag_groups` AS `TagGroup` WHERE `TagGroup`.`id` = 7 | 1 | 1 | 0 |
Peak Memory Use 9.81 MB
| Message | Memory use |
|---|---|
| Component intitailization | 6.72 MB |
| Controller action start | 6.76 MB |
| Controller render start | 6.89 MB |
| View render complete | 7.94 MB |
Total Request Time: 1138 (ms)
| Message | Time in ms | Graph |
|---|---|---|
| Core Processing (Derived) | 321.56 | |
| Component initialization and startup | 17.35 | |
| Controller action | 70.58 | |
| Render Controller Action | 156.48 | |
| » Rendering View | 144.94 | |
| » » Rendering APP/views/searches/result.ctp | 32.03 | |
| » » Rendering APP/views/layouts/default.ctp | 111.16 | |
| » » » Rendering APP/views/elements/header.ctp | 9.78 | |
| » » » Rendering APP/views/elements/search_sidebar.ctp | 84.96 | |
| » » » Rendering APP/views/elements/footer.ctp | 0.49 |