Nature Technology Database

Lobster’s Compound Eyes Can See 360 degrees: Lobsters, with their compound eyes, have a 360 degree range of vision without changing the positi...

Platelets That Locate and Seal Wounds: When there is damage to a vessel, platelets first carry out emergency treatment by blocking the w...

Termites Nests Have Excellent Air Conditioning: The termite nests in the savanna constantly maintain a temperature of 30°C despite the great diff...

Rowan Berries Don’t Spoil: Even after rowan berries become fully red and ripe, they do not go bad, staying on the end of its...

Morpho Butterfly Wings Use Color Structure: Morpho butterfly wings are characterized by “structural color,” which produces color due to light...

Chuckwalla Can Cool and Store/Replenish Water: Chuckwalla live in the desert, and when it is hot outside, they lower their temperature through b...

Bird’s Wings Change Shape: When a bird flies, its wings constantly fine-tune their direction, shape, width, and surface area...

American Tree Frog Changes Color to Match its Surroundings: The American Tree Frog can instantly change the color of its body. This is to adapt to the temper...

Worms Don’t Get Muddy: Even when they are in the ground, worms do not get muddy. This is because a negative charge is na...

Spider Silk Promotes Cell Division and is Antibacterial: Spider silk fiber is made up of two types of proteins, fibroin and sericin. Each fiber contains t...

<<Previous

Next>>

Query	Affected	Num. rows	Took (ms)	Actions
SHOW FULL COLUMNS FROM `contents`	16	16	7	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	3	maybe slow
SHOW FULL COLUMNS FROM `groups`	4	4	6	maybe slow
SHOW FULL COLUMNS FROM `permissions`	5	5	7	maybe slow
SHOW FULL COLUMNS FROM `groups_permissions`	3	3	6	maybe slow
SHOW FULL COLUMNS FROM `groups_users`	3	3	6	maybe slow
SHOW FULL COLUMNS FROM `contents_searches`	6	6	2	maybe slow
SHOW FULL COLUMNS FROM `attachments`	11	11	6	maybe slow
SHOW FULL COLUMNS FROM `attachments_revs`	13	13	3	maybe slow
SHOW FULL COLUMNS FROM `contents_related_items`	5	5	6	maybe slow
SHOW FULL COLUMNS FROM `related_items`	6	6	2	maybe slow
SHOW FULL COLUMNS FROM `contents_related_items_revs`	8	8	6	maybe slow
SHOW FULL COLUMNS FROM `contents_tags`	5	5	2	maybe slow
SHOW FULL COLUMNS FROM `tags`	7	7	6	maybe slow
SHOW FULL COLUMNS FROM `tag_groups`	6	6	2	maybe slow
SHOW FULL COLUMNS FROM `contents_tags_revs`	7	7	6	maybe slow
SHOW FULL COLUMNS FROM `contents_revs`	18	18	3	maybe slow
SELECT `Content`.`id` FROM `contents` AS `Content` WHERE `flag` = 1 ORDER BY `id` desc LIMIT 90, 11	11	11	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 IN (110, 109, 107, 106, 104, 103, 102, 101, 100, 99) ORDER BY `id` desc	10	10	0
SELECT `Attachment`.`file_name`, `Attachment`.`dir`, `Attachment`.`foreign_key` FROM `attachments` AS `Attachment` WHERE `file_name` <> 'default.jpg' AND `Attachment`.`foreign_key` IN (110, 109, 107, 106, 104, 103, 102, 101, 100, 99)	14	14	0
SELECT `ContentsRelatedItem`.`content`, `ContentsRelatedItem`.`related_item_id`, `ContentsRelatedItem`.`content_id` FROM `contents_related_items` AS `ContentsRelatedItem` WHERE `related_item_id` = '1' AND `ContentsRelatedItem`.`content_id` IN (110, 109, 107, 106, 104, 103, 102, 101, 100, 99)	10	10	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` = 1	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` = 1	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` = 1	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` = 1	1	1	0
SELECT `RelatedItem`.`code`, `RelatedItem`.`name` FROM `related_items` AS `RelatedItem` WHERE `RelatedItem`.`id` = 1	1	1	4	maybe slow
SELECT `RelatedItem`.`code`, `RelatedItem`.`name` FROM `related_items` AS `RelatedItem` WHERE `RelatedItem`.`id` = 1	1	1	0
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

Message	Memory use
Component intitailization	6.79 MB
Controller action start	6.83 MB
Controller render start	6.93 MB
View render complete	7.95 MB

Message	Time in ms	Graph
Core Processing (Derived)	431.75
Component initialization and startup	29.52
Controller action	80.31
Render Controller Action	113.41
» Rendering View	100.88
» » Rendering APP/views/contents/lists.ctp	65.77
» » Rendering APP/views/layouts/default.ctp	28.58
» » » Rendering APP/views/elements/header.ctp	1.90
» » » Rendering APP/views/elements/simple_sidebar.ctp	0.23
» » » Rendering APP/views/elements/footer.ctp	0.81

default

Query Explain:

Memory

Timers

Request History

Session

Request

Cake Params

$_GET

Cookie

Current Route

Sql Logs

default

Query Explain:

Memory

Timers

Logs

View Variables