Nature Technology Database

The Parthenium Argentatum Resists Termites and Fungi: The secretions of the parthenium argentatum have the effect of repelling termites and fungi that ...

Self-Assembling Molecules: Molecules, the smallest structures that comprise matter, assemble themselves into distinct patterns.

Hydrophobic Butterfly Wings: Morpho butterflies’ wings are hydrophobic (water-repellant) due to small oblong cells and minute ...

Anti-Reflective Moth Eyes: Moths have compound eyes that are covered by 200nm hexagonal bumps (facets) that are each spaced ...

Maple Seeds Remain Airborne for Long Periods of Time: When a maple seed rotates in the air, it forms a small vortex of air at the wing (a wingtip vorte...

Birdwing Butterfly Wings Absorb Light Efficiently: Birdwing butterflies absorb light energy efficiently, due not only to their black pigmentation, b...

Plants Create Energy through Photosynthesis: Plants create energy from sunlight through the process of photosynthesis. Sunlight is absorbed by...

Red Roses Appear Black: Black roses appear black even though they contain the same pigment as red roses on account of the...

Superhydrophobic Rose Petals Absorb Water Droplets: Rose petals are superhydrophobic due to their uneven surface, which is both hydrophilic (water at...

Heat-Generating Skunk Cabbage: The skunk cabbage can bloom early in the spring because it can generate enough heat to melt snow ...

<<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	2	maybe slow
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	2	maybe slow
SHOW FULL COLUMNS FROM `attachments`	11	11	2	maybe slow
SHOW FULL COLUMNS FROM `attachments_revs`	13	13	2	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	2	maybe slow
SHOW FULL COLUMNS FROM `tags`	7	7	2	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 180, 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 (16, 15, 14, 13, 12, 11, 10, 9, 8, 7) 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 (16, 15, 14, 13, 12, 11, 10, 9, 8, 7)	19	19	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 (16, 15, 14, 13, 12, 11, 10, 9, 8, 7)	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.94 MB
View render complete	7.96 MB

Message	Time in ms	Graph
Core Processing (Derived)	455.34
Component initialization and startup	17.67
Controller action	58.48
Render Controller Action	86.31
» Rendering View	73.64
» » Rendering APP/views/contents/lists.ctp	50.86
» » Rendering APP/views/layouts/default.ctp	20.56
» » » Rendering APP/views/elements/header.ctp	1.69
» » » Rendering APP/views/elements/simple_sidebar.ctp	0.20
» » » Rendering APP/views/elements/footer.ctp	0.50

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