Nature Technology Database

Kingfishers Are Master Divers with a Special Beak: The kingfisher, also known as the “flying jewel,” extends its beautiful body in a straight line, ...

Abalone’s Sturdy Shell Is Tough Enough to Beat with a Hammer or Run Over With a Car!: Materials made by firing clay, like pottery or brick, are called ceramics. Ceramics are used broa...

The Super Rubber of Insects’ Bodies: We use our muscles to produce energy when we exercise, but half of this energy is wasted as heat,...

Insects’ Compound Eyes See Panoramic View: If you look closely at the eyes of an insect, you’ll notice that they are covered in lots of tiny...

Water-walking Ninjas: Gerridae, or water striders, have the unique ability to stand and walk on the surface of water. T...

Once it Sticks, it Never Comes Loose! Nature’s Strongest Glue: Humans have invented many types of adhesives, like epoxy and acrylic glues, but adhesives also ex...

The Beauty of Wild Silk: Silk, which consists of the proteins sericin and fibroin, has many properties that make it useful...

Asleep at -272°C: The tardigrade, or water bear, is a type of invertebrate animal that is extremely difficult to ki...

Nata De Coco is Both Delicious and Useful: Upon hearing “nata de coco” many people probably think of the unique texture it adds to desserts....

Patience Is the Best Path to Water?: The Namib Desert in southwestern Africa is said to be one of the hottest, driest places on Earth....

<<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	10
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	10	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	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 20, 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 (186, 185, 183, 182, 181, 180, 179, 178, 177, 176) 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 (186, 185, 183, 182, 181, 180, 179, 178, 177, 176)	17	17	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 (186, 185, 183, 182, 181, 180, 179, 178, 177, 176)	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)	405.16
Component initialization and startup	19.07
Controller action	52.71
Render Controller Action	83.97
» Rendering View	71.35
» » Rendering APP/views/contents/lists.ctp	47.73
» » Rendering APP/views/layouts/default.ctp	21.20
» » » Rendering APP/views/elements/header.ctp	1.73
» » » 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