Nature Technology Database

Light-Responsive Archaea: Archaea can sense light on account of the rhodpsin (a variety-specific protein) in their cell mem...

Bamboo is Light and Tough: Bamboo is light and tough. Bamboo has fibrovascular bundles hidden inside its hard skin, which ar...

Different Levels of Strength Revealed in the Interior and Exterior of Birds’ Eggshells: Birds’ eggshells are tough enough to withstand cracking, even when pecked by a bird’s pointed bea...

The Royal Water Lily Achieves Great Buoyancy: The backside of a royal water lily’s leaves has thick veins that stretch out like a spider’s web....

Ivy Attaches Strongly to Surfaces: The roots of the ivy plant have extremely strong adhesive properties, which makes it extremely di...

Human Heart Modifies Its Activity According to the Circumstances: In order to circulate blood through the body, the heart is always in motion. The heart is always ...

Ice Plants Isolate Salt: Ice plants separate water and salt from each other, allowing them to thrive in dry, salty regions...

Sunflowers Efficiently Distribute Seeds: Based on Fibonacci numbers, sunflower seeds always appear in one of the three following combinati...

The Leaves of the Mimosa Pudica Fold upon Contact: A grasshopper landing to graze on the leaves of the Mimosa Pudica causes the leaves to fold in on...

Turmeric is Able to Curb the Increase of Cancer Cells: Tumeric’s pigment is created by a substance called curcumin, which not only improves the function...

<<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	14	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	14	maybe slow
SHOW FULL COLUMNS FROM `contents_searches`	6	6	2	maybe slow
SHOW FULL COLUMNS FROM `attachments`	11	11	14	maybe slow
SHOW FULL COLUMNS FROM `attachments_revs`	13	13	11	maybe slow
SHOW FULL COLUMNS FROM `contents_related_items`	5	5	2	maybe slow
SHOW FULL COLUMNS FROM `related_items`	6	6	10	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	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	11	maybe slow
SELECT `Content`.`id` FROM `contents` AS `Content` WHERE `flag` = 1 ORDER BY `id` desc LIMIT 120, 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 (78, 77, 76, 74, 73, 72, 71, 70, 69, 68) 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 (78, 77, 76, 74, 73, 72, 71, 70, 69, 68)	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 (78, 77, 76, 74, 73, 72, 71, 70, 69, 68)	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	8	maybe slow
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)	452.01
Component initialization and startup	9.62
Controller action	62.60
Render Controller Action	95.18
» Rendering View	78.46
» » Rendering APP/views/contents/lists.ctp	56.75
» » Rendering APP/views/layouts/default.ctp	19.47
» » » Rendering APP/views/elements/header.ctp	1.72
» » » Rendering APP/views/elements/simple_sidebar.ctp	0.20
» » » Rendering APP/views/elements/footer.ctp	0.48

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