Nature Technology Database

Silkworms and Spiders Use an Environmentally-Friendly Process to Produce Fibers: Man-made fibers such as nylon and polyester are synthesized in chemical plants fuelled by oil. Th...

Fishes’ Super Sensors Suggest Ways to Reduce Accidents: At aquariums or on television, you may have seen a school of fish all change their direction simu...

Trees Have “Elevators” Able to Bring Water Up Thirty Stories: The world’s largest trees are 111.4m tall. Despite reaching the height of a 30-story building, th...

Octopus’ Powerful Suction Cups Stick to Anything!: Normal rubber suction cups can only stick to smooth, flat surfaces, but the suction cups on an oc...

Silkworms Are Nature’s Thread Factories: Silkworms make silk thread. When a silkworm is preparing to change into a pupa, it spins silk thr...

Sea Turtle Offers Safety Lessons in Navigation: Florida sea turtles seasonally migrate through the North Atlantic, swim around the European coast...

Learning How to Recycle from Fallen Leaves: During the summer, leaves withstand wind and rain, staying firmly attached to tree branches, but ...

Plant Opals Are Gemstones Made by Plants: Plant opal is a type of small, glassy stone that can be found growing inside the cells of some pl...

Quiet of Snowy Mornings: Accumulated snow has the ability to dampen sound. If you look at snow under a microscope, you’ll ...

Bears Make Great Astronauts – Their Bones Remain Strong through Hibernation: Humans’ and most animals’ bones become weak and brittle when not used regularly. Without the appl...

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	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	2	maybe slow
SHOW FULL COLUMNS FROM `contents_related_items`	5	5	2	maybe slow
SHOW FULL COLUMNS FROM `related_items`	6	6	6
SHOW FULL COLUMNS FROM `contents_related_items_revs`	8	8	6	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 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 (208, 207, 205, 204, 203, 202, 201, 200, 199, 198) 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 (208, 207, 205, 204, 203, 202, 201, 200, 199, 198)	10	10	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 (208, 207, 205, 204, 203, 202, 201, 200, 199, 198)	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	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 `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.96 MB

Message	Time in ms	Graph
Core Processing (Derived)	434.30
Component initialization and startup	17.41
Controller action	62.84
Render Controller Action	86.37
» Rendering View	73.12
» » Rendering APP/views/contents/lists.ctp	49.98
» » Rendering APP/views/layouts/default.ctp	20.69
» » » Rendering APP/views/elements/header.ctp	2.14
» » » Rendering APP/views/elements/simple_sidebar.ctp	0.19
» » » 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