Nature Technology Database

Dog Paws Have Traction on Snowy Roads: The pads on the bottom of dogs’ feet are covered with small cone-shaped protrusions that act like...

Feather Mites Cling to Feathers: Feather mites are covered from head to toe with long bristly hairs that help them cling to feathe...

Young Knifefish Attach Themselves to the Bottom of a River: The young ghost knifefish has a special organ to attach itself to the bottom of the river. The or...

Insect Ganglia Control Each Body Segment: Insect bodies are divided into three segments: head, thorax, and abdomen. Each segment has a coll...

Plants Produce Clean Energy: Plants perform photosynthesis, using sunlight, water and carbon dioxide to produce nutrients and ...

Mussels Produce Sticky Glue-like Collagen: Mussels are able to create strongly adhesive materials in the water where it is difficult to main...

Cerebrospinal Fluid Protects the Brain: Cerebrospinal fluid is found in the subarachnoid space and the ventricular system. It acts as a “...

Chloroplasts in Plants Perform Photosynthesis: Chloroplasts found in plants utilize carbon dioxide, water absorbed through the roots, and the su...

Pseudochoricystis and Botryococcus Braunii: Oil-producing microalga Pseudochoricystis and Botryococcus braunii produce oil by performing phot...

Rock Dwelling Cellana: Cellana create the dents in rock that they inhabit. These dents perfectly fit their body size, wh...

<<Previous

Next>>

Query	Affected	Num. rows	Took (ms)	Actions
SHOW FULL COLUMNS FROM `contents`	16	16	3	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	14	maybe slow
SHOW FULL COLUMNS FROM `groups`	4	4	1	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	10	maybe slow
SHOW FULL COLUMNS FROM `contents_searches`	6	6	2	maybe slow
SHOW FULL COLUMNS FROM `attachments`	11	11	2	maybe slow
SHOW FULL COLUMNS FROM `attachments_revs`	13	13	3	maybe slow
SHOW FULL COLUMNS FROM `contents_related_items`	5	5	2	maybe slow
SHOW FULL COLUMNS FROM `related_items`	6	6	3	maybe slow
SHOW FULL COLUMNS FROM `contents_related_items_revs`	8	8	11	maybe slow
SHOW FULL COLUMNS FROM `contents_tags`	5	5	5
SHOW FULL COLUMNS FROM `tags`	7	7	2	maybe slow
SHOW FULL COLUMNS FROM `tag_groups`	6	6	2	maybe slow
SHOW FULL COLUMNS FROM `contents_tags_revs`	7	7	2	maybe slow
SHOW FULL COLUMNS FROM `contents_revs`	18	18	11	maybe slow
SELECT `Content`.`id` FROM `contents` AS `Content` WHERE `flag` = 1 ORDER BY `id` desc LIMIT 150, 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 (47, 46, 44, 43, 42, 41, 40, 39, 38, 37) 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 (47, 46, 44, 43, 42, 41, 40, 39, 38, 37)	15	15	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 (47, 46, 44, 43, 42, 41, 40, 39, 38, 37)	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	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 `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)	518.42
Component initialization and startup	10.14
Controller action	64.03
Render Controller Action	103.15
» Rendering View	86.69
» » Rendering APP/views/contents/lists.ctp	54.29
» » Rendering APP/views/layouts/default.ctp	30.06
» » » Rendering APP/views/elements/header.ctp	1.91
» » » Rendering APP/views/elements/simple_sidebar.ctp	0.19
» » » Rendering APP/views/elements/footer.ctp	8.79

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