Nature Technology Database

Honeybees Spread Information Efficiently: Honeybees do a dance that tells their fellow bees the distance, direction, and even the quality o...

Argiope Amoena Spiders Spin Multiple Types of Silk: In the middle of an Argiope spider’s web, one can see a thick white band of spider silk that refl...

Melastome Plants Use Rainwater to Disperse Seeds: The fruit of the melastome plant ripens during the rainy season. Melastome fruit is triangular, w...

Wallaby Milk Fights Bacteria: Wallaby milk contains a compound that prevents bacteria from multiplying. This protects baby wall...

Gypsy Moth Caterpillars Regulate Their Body Temperature: Gypsy moth caterpillars have an effective system of temperature regulation that takes place not i...

Plants Grow Upward: Plants have evolved to be taller and taller, in order to absorb more light than the plants around...

Bee Venom is Largely Comprised of the Anti-bacterial Peptide Melittin: Melittin, an antibacterial peptide, prevents bacteria from spreading and even breaks bacteria dow...

Sunflowers Shift to Face the Sun: Sunflowers face East in the morning and West in the evening, then return to face East in the even...

Honeybees Produce Propolis that Fights Bacteria: Honeybees protect their nests from microbes by covering them in a substance called propolis. Prop...

Solidago Canadensis (“Goldenrod”) Inhibits the Growth of Other Plants: The Goldenrod plant releases polyacetylene chemicals (cis-DMS) from its roots that prevent plant ...

<<Previous

Next>>

Query	Affected	Num. rows	Took (ms)	Actions
SHOW FULL COLUMNS FROM `contents`	16	16	4	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	10	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	10	maybe slow
SHOW FULL COLUMNS FROM `attachments`	11	11	3	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	2	maybe slow
SHOW FULL COLUMNS FROM `contents_related_items_revs`	8	8	2	maybe slow
SHOW FULL COLUMNS FROM `contents_tags`	5	5	10	maybe slow
SHOW FULL COLUMNS FROM `tags`	7	7	3	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 140, 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 (57, 56, 55, 54, 53, 52, 51, 50, 49, 48) 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 (57, 56, 55, 54, 53, 52, 51, 50, 49, 48)	12	12	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 (57, 56, 55, 54, 53, 52, 51, 50, 49, 48)	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	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)	388.12
Component initialization and startup	11.15
Controller action	67.73
Render Controller Action	104.09
» Rendering View	99.27
» » Rendering APP/views/contents/lists.ctp	62.54
» » Rendering APP/views/layouts/default.ctp	34.40
» » » Rendering APP/views/elements/header.ctp	1.88
» » » Rendering APP/views/elements/simple_sidebar.ctp	0.20
» » » Rendering APP/views/elements/footer.ctp	0.53

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