Nature Technology Database

Ixodid Ticks Drink Water from the Air: The tick is an insect that resembles the spider, with a maximum length of 1cm, although many tick...

Penguin’s Feathers Act Like a Natural Down Jacket: The King penguin lives on top of the ice in the extremely cold climate of the South Pole. The pen...

Penguin Has All-Seeing Eyes: The King penguin lives on islands mainly found in the extremely cold climate of the South Pole. T...

Dolphin’s Fat Holds the Key to Its Amazing Athletic Abilities: The bottlenose dolphin lives in many oceans around the world. The dolphin can maintain a constant...

Limber Pines Withstand Strong Wind: The Limber Pine, found in the Rocky Mountain area of the Midwestern United States, grows 12–15m t...

Termites Nests Are Always Comfortable: Termites living in savanna zones spend decades building dirt nests that are 6–7m high. A savanna ...

Japanese Silk Moth Can Deactivate Cancer Cells: One moth species that has been in Japan for a very long time is the Japanese Silk Moth. Females l...

Alsomitra Seeds Glide Through the Air without Help from the Wind: Alsomitra macrocarpa is a vine in the tropical islands of Asia that winds around tall trees as it...

Beehives Are Light and Sturdy: Beehives are composed from many tubes that are clustered and closely stuck together in what is ca...

Dolphin Echolocation Suggests New Types of Underwater Acoustic Communication: Pods consist of a few, up to several dozen dolphins; in order to communicate with other dolphins ...

<<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	2	maybe slow
SHOW FULL COLUMNS FROM `groups`	4	4	2	maybe slow
SHOW FULL COLUMNS FROM `permissions`	5	5	10	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	10	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	10	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	10	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 50, 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 (154, 153, 152, 151, 150, 149, 148, 147, 146, 145) 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 (154, 153, 152, 151, 150, 149, 148, 147, 146, 145)	12	12	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 (154, 153, 152, 151, 150, 149, 148, 147, 146, 145)	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)	487.22
Component initialization and startup	18.26
Controller action	62.87
Render Controller Action	107.19
» Rendering View	94.73
» » Rendering APP/views/contents/lists.ctp	47.35
» » Rendering APP/views/layouts/default.ctp	20.56
» » » Rendering APP/views/elements/header.ctp	1.84
» » » Rendering APP/views/elements/simple_sidebar.ctp	0.19
» » » 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