Nature Technology Database

The Praying Mantis Can Predict Snowfall: In Autumn, praying mantises lay their eggs on grass stems and small twigs, where they will remain...

Owls Are Silent Night Hunters: Unlike most other birds, the owl is nocturnal. It hides in the darkness of night until it silentl...

Shipworms Are Master Diggers and the Original Shield Tunnelers: The shipworm has a long thin body about 10cm long. It is a relative of the clam (there are very s...

Papilio Nireus Adorns Itself with the Latest LEDs: Native to eastern and central Africa, Papilio nireus is a butterfly with pretty, bright blue wing...

Listen to the Light of the Firefly! See the Sound of Insects!: The faint glow of fireflies in the darkness or the chirping song of insects on a long autumn nigh...

Spider Silk Is Lightweight and Strong: A strand of spider silk is about as strong as a steel wire of the same thickness. Spider silk 4cm...

Life with Fluctuations: Have you ever gazed intently at the flickering flames of a candle or bonfire, and felt yourself g...

Crayfish Recycle Themselves with Resourceful Molting: Crayfish enclose their body in hard shells, and as they grow larger they shed their old, smaller ...

Bones Exemplify a Minimal Weight Design Method: Bones fulfill the critical role of supporting the body and protecting organs from external impact...

Savior of the 21st Century!? Tree-Loving Termites: Termites are notorious for their voracious appetite for house pillars. Timber (like that used to ...

<<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	2	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	10	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	3	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	10	maybe slow
SHOW FULL COLUMNS FROM `contents_tags`	5	5	22	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	15	maybe slow
SHOW FULL COLUMNS FROM `contents_revs`	18	18	27	maybe slow
SELECT `Content`.`id` FROM `contents` AS `Content` WHERE `flag` = 1 ORDER BY `id` desc LIMIT 10, 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 (197, 196, 194, 193, 192, 191, 190, 189, 188, 187) 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 (197, 196, 194, 193, 192, 191, 190, 189, 188, 187)	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 (197, 196, 194, 193, 192, 191, 190, 189, 188, 187)	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)	547.33
Component initialization and startup	59.77
Controller action	64.56
Render Controller Action	77.37
» Rendering View	73.06
» » Rendering APP/views/contents/lists.ctp	39.53
» » Rendering APP/views/layouts/default.ctp	23.49
» » » Rendering APP/views/elements/header.ctp	13.85
» » » Rendering APP/views/elements/simple_sidebar.ctp	0.23
» » » Rendering APP/views/elements/footer.ctp	0.58

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