Nature Technology Database

Venus Flytrap Catches Flies Quickly: The Venus flytrap has red, predatory leaves with nectaries that produce nectar to attract flies. ...

Cupedidae Beetle Respond to Infrared Rays: The adult cupedidae beetle possesses a special sensory organ that detects the infrared rays that ...

Cabbage Can Attract the Natural Enemy of the Cabbageworm: When eaten by cabbageworms, cabbage emits a scent that attracts wasps that are the natural enemie...

Buprestid Beetle Detects Smoke from Forest Fires: The Buprestid Beetle have a strong sense of smell through their antennae. They are able to detect...

Rosemary Possesses Allelopathic Effects: When forest fires occur and burn rosemary plants, the seeds that were previously prevented from b...

The Larva of the Buzzer Midge Can Live Without Oxygen: The larva of the buzzer midge inhabit places where almost no oxygen exists, such as the mud at th...

L. Augustus Weevils Appear the Same Shade of Green from Every Angle: Lamprocyphus augustus weevils have exoskeletons made of chitin scales, which have the same molecu...

Human Lungs Filter Carbon Dioxide Efficiently: Human lungs conduct an efficient exchange of gases by taking in oxygen from the air and releasing...

Perennials Enrich Soil: Perennials have very deep, widespread root systems. The roots plow soil as they grow, creating an...

Bluegill Pectoral Fins Lower Water Resistance: Bluegills sweep their pectoral fins forward, then cup the top and bottom of the fins into a U-sha...

<<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	11	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	10	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	2	maybe slow
SHOW FULL COLUMNS FROM `contents_related_items_revs`	8	8	14	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	2	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 130, 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 (67, 66, 65, 64, 63, 62, 61, 60, 59, 58) 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 (67, 66, 65, 64, 63, 62, 61, 60, 59, 58)	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 (67, 66, 65, 64, 63, 62, 61, 60, 59, 58)	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)	384.41
Component initialization and startup	18.47
Controller action	55.14
Render Controller Action	104.87
» Rendering View	99.89
» » Rendering APP/views/contents/lists.ctp	64.20
» » Rendering APP/views/layouts/default.ctp	23.65
» » » Rendering APP/views/elements/header.ctp	1.75
» » » 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