Nature Technology Database

Mokuzu-shoi Camouflage by Attaching Debris to Its Shell: Mokuzu-shoi (Spider crab) camouflages itself by using hook-like hairs to attach small pieces of s...

African Clawed Frog’s Skin Have Antibacterial Effects: African clawed frog’s skin produces the antibiotic peptide magainin which protects the frog from ...

Biofilm Created From an Aggregation of Various Life Forms: Bacteria secrete adherent substances to form small colonies (known as an aggregate cell colony). ...

Seaweed Alginates Have a High Viscosity and Water Absorbing Ability: Seaweed and kelp can withstand rough currents without tearing due to the soft, yet tough conditio...

Springboks Facilitate Body Heat Dissipation: The springbok’s fur is only 4mm long, which is extremely short given the size of their bodies. Ho...

Frog Skin Has Antimicrobial Effects: Frogs protect themselves against pathogenic microorganisms by means of several different types of...

Bacteria Control Flagellum Rotation: Bacteria control their movements by manipulating their flagellum, which are made up of protein fl...

Melanin Creates the Beautiful Blue Color of Blue-Black Grassquit Feathers: The color of the blue-black grassquit feathers’ comes from melanin, which reflects a blue color i...

Eucalyptus Resists Bushfires: Eucalyptus leaves produce substances that suppress plant growth. These leaves fall after being ex...

Bamboo Possesses High Tensile Strength: Despite being tall, bamboo does not break easily even under multi-lateral pressure from from typh...

<<Previous

Next>>

Query	Affected	Num. rows	Took (ms)	Actions
SHOW FULL COLUMNS FROM `contents`	16	16	11	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	10
SHOW FULL COLUMNS FROM `groups`	4	4	2	maybe slow
SHOW FULL COLUMNS FROM `permissions`	5	5	2	maybe slow
SHOW FULL COLUMNS FROM `groups_permissions`	3	3	2	maybe slow
SHOW FULL COLUMNS FROM `groups_users`	3	3	2	maybe slow
SHOW FULL COLUMNS FROM `contents_searches`	6	6	6
SHOW FULL COLUMNS FROM `attachments`	11	11	6	maybe slow
SHOW FULL COLUMNS FROM `attachments_revs`	13	13	7	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	10	maybe slow
SHOW FULL COLUMNS FROM `tag_groups`	6	6	10	maybe slow
SHOW FULL COLUMNS FROM `contents_tags_revs`	7	7	2	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 110, 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 (88, 87, 86, 85, 84, 83, 82, 81, 80, 79) 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 (88, 87, 86, 85, 84, 83, 82, 81, 80, 79)	11	11	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 (88, 87, 86, 85, 84, 83, 82, 81, 80, 79)	10	10	8	maybe slow
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	0
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	8	maybe slow
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)	426.03
Component initialization and startup	19.09
Controller action	64.40
Render Controller Action	107.79
» Rendering View	93.31
» » Rendering APP/views/contents/lists.ctp	54.20
» » Rendering APP/views/layouts/default.ctp	35.55
» » » Rendering APP/views/elements/header.ctp	1.86
» » » Rendering APP/views/elements/simple_sidebar.ctp	0.22
» » » Rendering APP/views/elements/footer.ctp	0.56

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