Nature Technology Database

History
+ –
Request History
4 previous requests available
====
Session
+ –
Session
- Config
  userAgent146b278961f0b80dc105e136efd48481
  time1714166924
  timeout10
====
Request
+ –
Request

Cake Params
- controllersearches
- actionresult
- named(empty)
- pass
  010
  13
- plugin(null)
- form(empty)
- url
  urlsearches/result/10/3
- isAjax(false)
$_GET
- urlsearches/result/10/3
Cookie
- 0(empty)
Current Route
- keys
  0controller
  1action
- options(empty)
- defaults
  plugin(null)
  actionindex
- template/:controller/:action/*
- _greedy(true)
- _compiledRoute#^/(?:([^/]+))/(?:([^/]+))(?:/(?P<_args_>.*))?[/]*$#
- __headerMap
  typecontent_type
  methodrequest_method
  serverserver_name
====

Sql Log

+ –

Sql Logs

default

Query	Affected	Num. rows	Took (ms)	Actions
SHOW FULL COLUMNS FROM `contents`	16	16	2	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	1	maybe slow
SHOW FULL COLUMNS FROM `groups`	4	4	1	maybe slow
SHOW FULL COLUMNS FROM `permissions`	5	5	1	maybe slow
SHOW FULL COLUMNS FROM `groups_permissions`	3	3	1	maybe slow
SHOW FULL COLUMNS FROM `groups_users`	3	3	1	maybe slow
SHOW FULL COLUMNS FROM `contents_searches`	6	6	1	maybe slow
SHOW FULL COLUMNS FROM `attachments`	11	11	1	maybe slow
SHOW FULL COLUMNS FROM `attachments_revs`	13	13	13
SHOW FULL COLUMNS FROM `contents_related_items`	5	5	1	maybe slow
SHOW FULL COLUMNS FROM `related_items`	6	6	1	maybe slow
SHOW FULL COLUMNS FROM `contents_related_items_revs`	8	8	1	maybe slow
SHOW FULL COLUMNS FROM `contents_tags`	5	5	1	maybe slow
SHOW FULL COLUMNS FROM `tags`	7	7	1	maybe slow
SHOW FULL COLUMNS FROM `tag_groups`	6	6	1	maybe slow
SHOW FULL COLUMNS FROM `contents_tags_revs`	7	7	1	maybe slow
SHOW FULL COLUMNS FROM `contents_revs`	18	18	1	maybe slow
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
SELECT MATCH (`related_items`, `tags`) AGAINST (' +"\|3\|"' IN BOOLEAN MODE) as score, content_id FROM `contents_searches` as `ContentsSearch` WHERE MATCH (`related_items`, `tags`) AGAINST (' +"\|3\|"' IN BOOLEAN MODE) AND content_id not in (124, 133, 163) ORDER BY score desc LIMIT 10, 11	2	2	0
SELECT `Content`.`id`, `Content`.`user_id`, `Content`.`last_edit_user_id`, `Content`.`post_date`, `Content`.`post_date_year`, `Content`.`post_date_month`, `Content`.`post_date_day`, `Content`.`title`, `Content`.`title_en`, `Content`.`content`, `Content`.`plain_content`, `Content`.`page_view`, `Content`.`flag`, `Content`.`mod_count`, `Content`.`created`, `Content`.`modified` FROM `contents` AS `Content` WHERE id IN (130, 162)	2	2	0
SELECT `Attachment`.`file_name`, `Attachment`.`dir`, `Attachment`.`model`, `Attachment`.`foreign_key` FROM `attachments` AS `Attachment` WHERE `file_name` <> 'default.jpg' AND `Attachment`.`foreign_key` IN (130, 162)	4	4	0
SELECT `ContentsRelatedItem`.`content`, `ContentsRelatedItem`.`related_item_id`, `ContentsRelatedItem`.`content_id` FROM `contents_related_items` AS `ContentsRelatedItem` WHERE `ContentsRelatedItem`.`content_id` IN (130, 162)	22	22	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` = 2	1	1	0
SELECT `RelatedItem`.`code`, `RelatedItem`.`name` FROM `related_items` AS `RelatedItem` WHERE `RelatedItem`.`id` = 4	1	1	0
SELECT `RelatedItem`.`code`, `RelatedItem`.`name` FROM `related_items` AS `RelatedItem` WHERE `RelatedItem`.`id` = 6	1	1	0
SELECT `RelatedItem`.`code`, `RelatedItem`.`name` FROM `related_items` AS `RelatedItem` WHERE `RelatedItem`.`id` = 7	1	1	0
SELECT `RelatedItem`.`code`, `RelatedItem`.`name` FROM `related_items` AS `RelatedItem` WHERE `RelatedItem`.`id` = 8	1	1	0
SELECT `RelatedItem`.`code`, `RelatedItem`.`name` FROM `related_items` AS `RelatedItem` WHERE `RelatedItem`.`id` = 9	1	1	0
SELECT `RelatedItem`.`code`, `RelatedItem`.`name` FROM `related_items` AS `RelatedItem` WHERE `RelatedItem`.`id` = 9	1	1	0
SELECT `RelatedItem`.`code`, `RelatedItem`.`name` FROM `related_items` AS `RelatedItem` WHERE `RelatedItem`.`id` = 9	1	1	0
SELECT `RelatedItem`.`code`, `RelatedItem`.`name` FROM `related_items` AS `RelatedItem` WHERE `RelatedItem`.`id` = 11	1	1	0
SELECT `RelatedItem`.`code`, `RelatedItem`.`name` FROM `related_items` AS `RelatedItem` WHERE `RelatedItem`.`id` = 12	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` = 2	1	1	0
SELECT `RelatedItem`.`code`, `RelatedItem`.`name` FROM `related_items` AS `RelatedItem` WHERE `RelatedItem`.`id` = 4	1	1	0
SELECT `RelatedItem`.`code`, `RelatedItem`.`name` FROM `related_items` AS `RelatedItem` WHERE `RelatedItem`.`id` = 6	1	1	0
SELECT `RelatedItem`.`code`, `RelatedItem`.`name` FROM `related_items` AS `RelatedItem` WHERE `RelatedItem`.`id` = 7	1	1	0
SELECT `RelatedItem`.`code`, `RelatedItem`.`name` FROM `related_items` AS `RelatedItem` WHERE `RelatedItem`.`id` = 8	1	1	0
SELECT `RelatedItem`.`code`, `RelatedItem`.`name` FROM `related_items` AS `RelatedItem` WHERE `RelatedItem`.`id` = 9	1	1	0
SELECT `RelatedItem`.`code`, `RelatedItem`.`name` FROM `related_items` AS `RelatedItem` WHERE `RelatedItem`.`id` = 9	1	1	0
SELECT `RelatedItem`.`code`, `RelatedItem`.`name` FROM `related_items` AS `RelatedItem` WHERE `RelatedItem`.`id` = 9	1	1	0
SELECT `RelatedItem`.`code`, `RelatedItem`.`name` FROM `related_items` AS `RelatedItem` WHERE `RelatedItem`.`id` = 11	1	1	0
SELECT `RelatedItem`.`code`, `RelatedItem`.`name` FROM `related_items` AS `RelatedItem` WHERE `RelatedItem`.`id` = 12	1	1	12	maybe slow
SELECT `ContentsTag`.`id`, `ContentsTag`.`tag_group_id`, `ContentsTag`.`mod_count`, `ContentsTag`.`tag_id`, `ContentsTag`.`content_id` FROM `contents_tags` AS `ContentsTag` WHERE `ContentsTag`.`content_id` IN (130, 162)	8	8	0
SELECT `Tag`.`name`, `Tag`.`comment`, `Tag`.`tag_group_id` FROM `tags` AS `Tag` WHERE `Tag`.`id` = 2	1	1	0
SELECT `TagGroup`.`code`, `TagGroup`.`name` FROM `tag_groups` AS `TagGroup` WHERE `TagGroup`.`id` = 1	1	1	0
SELECT `Tag`.`name`, `Tag`.`comment`, `Tag`.`tag_group_id` FROM `tags` AS `Tag` WHERE `Tag`.`id` = 3	1	1	0
SELECT `TagGroup`.`code`, `TagGroup`.`name` FROM `tag_groups` AS `TagGroup` WHERE `TagGroup`.`id` = 1	1	1	0
SELECT `Tag`.`name`, `Tag`.`comment`, `Tag`.`tag_group_id` FROM `tags` AS `Tag` WHERE `Tag`.`id` = 97	1	1	0
SELECT `TagGroup`.`code`, `TagGroup`.`name` FROM `tag_groups` AS `TagGroup` WHERE `TagGroup`.`id` = 7	1	1	0
SELECT `Tag`.`name`, `Tag`.`comment`, `Tag`.`tag_group_id` FROM `tags` AS `Tag` WHERE `Tag`.`id` = 2	1	1	0
SELECT `TagGroup`.`code`, `TagGroup`.`name` FROM `tag_groups` AS `TagGroup` WHERE `TagGroup`.`id` = 1	1	1	0
SELECT `Tag`.`name`, `Tag`.`comment`, `Tag`.`tag_group_id` FROM `tags` AS `Tag` WHERE `Tag`.`id` = 3	1	1	0
SELECT `TagGroup`.`code`, `TagGroup`.`name` FROM `tag_groups` AS `TagGroup` WHERE `TagGroup`.`id` = 1	1	1	0
SELECT `Tag`.`name`, `Tag`.`comment`, `Tag`.`tag_group_id` FROM `tags` AS `Tag` WHERE `Tag`.`id` = 29	1	1	0
SELECT `TagGroup`.`code`, `TagGroup`.`name` FROM `tag_groups` AS `TagGroup` WHERE `TagGroup`.`id` = 3	1	1	0
SELECT `Tag`.`name`, `Tag`.`comment`, `Tag`.`tag_group_id` FROM `tags` AS `Tag` WHERE `Tag`.`id` = 44	1	1	0
SELECT `TagGroup`.`code`, `TagGroup`.`name` FROM `tag_groups` AS `TagGroup` WHERE `TagGroup`.`id` = 4	1	1	0
SELECT `Tag`.`name`, `Tag`.`comment`, `Tag`.`tag_group_id` FROM `tags` AS `Tag` WHERE `Tag`.`id` = 104	1	1	0
SELECT `TagGroup`.`code`, `TagGroup`.`name` FROM `tag_groups` AS `TagGroup` WHERE `TagGroup`.`id` = 7	1	1	0

Query Explain:

Click an "Explain" link above, to see the query explanation.

====

Timer

+ –

Memory

Peak Memory Use 9.47 MB

Message	Memory use
Component intitailization	6.72 MB
Controller action start	6.76 MB
Controller render start	6.89 MB
View render complete	7.95 MB

Timers

Total Request Time: 1156 (ms)

Message	Time in ms	Graph
Core Processing (Derived)	352.56
Component initialization and startup	20.00
Controller action	74.08
Render Controller Action	142.92
» Rendering View	139.37
» » Rendering APP/views/searches/result.ctp	32.08
» » Rendering APP/views/layouts/default.ctp	105.48
» » » Rendering APP/views/elements/header.ctp	9.73
» » » Rendering APP/views/elements/search_sidebar.ctp	87.53
» » » Rendering APP/views/elements/footer.ctp	0.44

====

Log
+ –

Logs

====
Variables
+ –
View Variables
- contentsArray
- has_next(false)
- has_before(true)
- next_start
- before_start0
- tag_id3
- res_store_list
  1Water recovery
  2Light collecting
  3Uses light energy
  4Storage power
  5Heat insulation
  6Cold insulation
  7Water retention
  8Season sensing
  9Location detection
  10Wide field
  11Oxygen supply
  12Silencing
  13Data storage
  14Deodorizing
  15Reception
- res_prod_list
  16Luminescence
  17Power generation
  18Heat generation
  19Heat release
  20Color changing
  21Scent
  22Spray
  23Mineral formation
  24Fiber production
  25Power generation
  26Transmission
- move_list
  27Excavation
  28Movement
  29Floating
  30Backflow prevention
  31Air
  32Regeneration
  33Reuse
  34Circulation
  35Removal
  36Suction
  37Convection
  38Self-medicating
  39Repair
  40Flight
  41Separation
  42Filtration
- structure_list
  43Opening and closing
  44Expansion
  45Shape changing
  46Distributed features
  47Environmental improvement
  48Size changing
  49Quality changing
  50Gravity use
  51Decomposition
  52Use of natural phenomena
- efficiency_list
  53Efficient use of energy
  54Weight-saving
  55Air or water resistance evasion
  56Efficient arrangement
  57Learning
  58High intensity
  59Bite/sting
  60Self-sharpening
- defense_list
  61Stability
  62Pest control
  63Absorption
  64Adhesion
  65Resistance to outside threats
  66Fire resistance
  67Wind resistance
  68Cold resistance
  69Shock resistance
  70Heat resistance
  71Light resistance
  72Microbe/germ resistance
  73Tensile resistance
  74Long-term preservation
  75Shading
  76Dirt resistance
  77Preservative
  78Light control
  79Temperature control
  80Comfort
  81Humidification
  82Insulation
  83Attack
  84Living tissue control
  85Water repellent
  86Attachment
  87Coating
  88Dormancy
  89Anti-coagulant
- env_sol_list
  90Circulation
  91Sharing
  92Network
  93Community
  94Reduce
  95Reuse
  96Recycle
  97Energy saving
  98Resource saving
  99Long life
  100Coexistence with nature
  101From “goods” to “services”
  102Attachment
  103Concise
  104Energy creation
  175Other
- func_class_list
  res_storeResources/Energy/Information Collection or Storage
  res_prodResources/Energy/Information Transmission or Production
  moveTransportation/Disposal/Circulation
  structureShape/Organization/System
  efficiencyEfficiency (low energy, low resource, light)
  defenseResistance/Stability
- appl_ind_seg_list
  141Mining
  142Construction
  143Foods
  144Textiles
  145Pulp/paper
  146Chemistry
  147Pharmaceuticals
  148Petroleum/coal products
  149Rubber products
  150Glass/stone products
  151Iron and steel
  152Non-ferrous metals
- Auth(null)
- $this->data(null)
- $this->validationErrors(empty)
- Loaded Helpers
  0simpleGraph
  1number
  2htmlToolbar
  3toolbar
  4navi
  5layout
  6session
  7form
  8diff
  9javascript
  10html
====

Request History

Session

Request

Cake Params

$_GET

Cookie

Current Route

Sql Logs

default

Query Explain:

Memory

Timers

Logs

View Variables