| 1 | collection("weblog")/user[info/nick="misof"]/@ID/normalize-space() | 0.00830984115601 |
| 2 | data(collection('weblog')/user[@ID='u134']/blog/post[@ID='p16015']/@accessCount) | 0.00381684303284 |
| 3 | update replace $i in collection("weblog")/user[@ID="u134"]/blog/post[@ID="p16015"]/@accessCount with attribute accessCount {378} | 0.0173699855804 |
| 4 |
let $all := collection("weblog")/user/blog/post[@status="published"][../../@ID="u134"][@ID="p16015"],
$list :=
subsequence(
for $i in $all
return $i,1,1),
$last := count($all),
$posts:=
(for $current in $list
let $user := $current/ancestor::user
return
<post>{$current/@ID}{$current/@lang}{$current/@accessCount}
<user>{$user/@ID}{$user/@type}
{$user/info/nick}
{$user/info/realName}
</user>
{$current/*}
</post>
)
return <module name="Articles"><newPosts last="{$last}" end="1" start="1">{$posts}</newPosts></module>
| 0.0408718585968 |
| 5 | for $i in collection("weblog")/user/blog/post[@status="published"][../../@ID="u134"][@ID!="p16015"]
order by (
xs:integer($i/date/@timestamp)
)
descending
return
<post>
{$i/@status}
{$i/@private}
{$i/@ID}
{$i/title}
{$i/date}
</post> | 0.0252768993378 |
| 6 | let $tags := for $tags in collection("weblog")/user/blog/post[@ID="p16015"][../../@ID="u134"][@status="published"][contains("sk",@lang)]/tags,
$tag in distinct-values($tags/tag),
$tagCanonical in collection("weblog")/tags/tag[alt=$tag][normalize-space(data(@canonical))!=""]
return <tag id="{$tagCanonical/@id}">{normalize-space(data($tagCanonical/@canonical))}</tag>
let $tags:=subsequence(
(for
$tag in distinct-values($tags)
order by count($tags[.=$tag]) descending
return
<tag id="{subsequence($tags[.=$tag]/@id,1,1)}" count="{count($tags[.=$tag])}">{$tag}</tag>
),1,50)
let $maxTagCount := max($tags/@count)
let $minTagCount := min($tags/@count)
let $tagsResult:= for
$tag in $tags
order by lower-case($tag/text()) ascending
return
<tag percent="{(($tag/@count - $minTagCount)div ($maxTagCount - $minTagCount+1))}">{$tag/text()}</tag>
return
$tagsResult
| 0.0417749881744 |
| 7 | collection("weblog")/user[@ID="u134"]/info | 0.00400900840759 |
| 8 | collection("weblog")/user[@ID="u134"]/blog/title | 0.00284314155579 |
| 9 | let $bg := collection("weblog")/user[@ID="u134"]/blog/background,
$color := collection("weblog")/user[@ID="u134"]/blog/colorscheme
return
<customizations>
<blogBackground>{$bg}</blogBackground>
<colorScheme>{$color}</colorScheme>
</customizations>
| 0.00905203819275 |
| * | total time | 0.153324604034 |