Difference between revisions of "API: Who"
From Elder Tale Online MUSH
Liminality (talk | contribs) m |
Liminality (talk | contribs) m |
||
Line 11: | Line 11: | ||
!style="text-align:left;"| Idle For{{#for_external_table:<nowiki/> | !style="text-align:left;"| Idle For{{#for_external_table:<nowiki/> | ||
{{!}}- | {{!}}- | ||
− | {{!}} {{#ask: [[Characterid: | + | {{!}} {{#ask: [[Characterid::{{{CharacterId}}}]] | format=debug| limit=1 | default={{{Name}}} }} >{{{CharacterId}}}< |
{{!}} {{{OnFor}}} | {{!}} {{{OnFor}}} | ||
{{!}} {{{Idlefor}}} | {{!}} {{{Idlefor}}} |
Revision as of 00:11, 23 March 2019
Name | Connected For | Idle For | ||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SQLStore debug output ASK Query [[Characterid::60435]] SQL Query SELECT DISTINCT t0.smw_id AS id, t0.smw_title AS t, t0.smw_namespace AS ns, t0.smw_iw AS iw, t0.smw_subobject AS so, t0.smw_sortkey AS sortkey, t0.smw_sort FROM `wiki_smw_object_ids` AS t0 INNER JOIN `wiki_smw_di_blob` AS t1 ON t0.smw_id=t1.s_id WHERE ( (t1.o_hash='60435') AND t1.p_id='596') AND t0.smw_iw!=':smw' AND t0.smw_iw!=':smw-delete' AND t0.smw_iw!=':smw-redi' ORDER BY t0.smw_sort ASC LIMIT 6 OFFSET 0 SQL Explain
Auxilliary Tables No auxilliary tables used.Query Metrics Query-Size:2Query-Depth:1 Errors and Warnings None |
2d 15h 18m 0s | 23h 42m 2s | ||||||||||||||||||||||||||||||
SQLStore debug output ASK Query [[Characterid::32382]] SQL Query SELECT DISTINCT t0.smw_id AS id, t0.smw_title AS t, t0.smw_namespace AS ns, t0.smw_iw AS iw, t0.smw_subobject AS so, t0.smw_sortkey AS sortkey, t0.smw_sort FROM `wiki_smw_object_ids` AS t0 INNER JOIN `wiki_smw_di_blob` AS t1 ON t0.smw_id=t1.s_id WHERE ( (t1.o_hash='32382') AND t1.p_id='596') AND t0.smw_iw!=':smw' AND t0.smw_iw!=':smw-delete' AND t0.smw_iw!=':smw-redi' ORDER BY t0.smw_sort ASC LIMIT 6 OFFSET 0 SQL Explain
Auxilliary Tables No auxilliary tables used.Query Metrics Query-Size:2Query-Depth:1 Errors and Warnings None |
2d 15h 18m 0s | 19m 34s | ||||||||||||||||||||||||||||||
SQLStore debug output ASK Query [[Characterid::18359]] SQL Query SELECT DISTINCT t0.smw_id AS id, t0.smw_title AS t, t0.smw_namespace AS ns, t0.smw_iw AS iw, t0.smw_subobject AS so, t0.smw_sortkey AS sortkey, t0.smw_sort FROM `wiki_smw_object_ids` AS t0 INNER JOIN `wiki_smw_di_blob` AS t1 ON t0.smw_id=t1.s_id WHERE ( (t1.o_hash='18359') AND t1.p_id='596') AND t0.smw_iw!=':smw' AND t0.smw_iw!=':smw-delete' AND t0.smw_iw!=':smw-redi' ORDER BY t0.smw_sort ASC LIMIT 6 OFFSET 0 SQL Explain
Auxilliary Tables No auxilliary tables used.Query Metrics Query-Size:2Query-Depth:1 Errors and Warnings None |
6d 23h 54m 45s | 5d 21h 21m 39s | ||||||||||||||||||||||||||||||
SQLStore debug output ASK Query [[Characterid::21866]] SQL Query SELECT DISTINCT t0.smw_id AS id, t0.smw_title AS t, t0.smw_namespace AS ns, t0.smw_iw AS iw, t0.smw_subobject AS so, t0.smw_sortkey AS sortkey, t0.smw_sort FROM `wiki_smw_object_ids` AS t0 INNER JOIN `wiki_smw_di_blob` AS t1 ON t0.smw_id=t1.s_id WHERE ( (t1.o_hash='21866') AND t1.p_id='596') AND t0.smw_iw!=':smw' AND t0.smw_iw!=':smw-delete' AND t0.smw_iw!=':smw-redi' ORDER BY t0.smw_sort ASC LIMIT 6 OFFSET 0 SQL Explain
Auxilliary Tables No auxilliary tables used.Query Metrics Query-Size:2Query-Depth:1 Errors and Warnings None |
10d 17h 57m 39s | 9d 18h 54m 14s | ||||||||||||||||||||||||||||||
SQLStore debug output ASK Query [[Characterid::21394]] SQL Query SELECT DISTINCT t0.smw_id AS id, t0.smw_title AS t, t0.smw_namespace AS ns, t0.smw_iw AS iw, t0.smw_subobject AS so, t0.smw_sortkey AS sortkey, t0.smw_sort FROM `wiki_smw_object_ids` AS t0 INNER JOIN `wiki_smw_di_blob` AS t1 ON t0.smw_id=t1.s_id WHERE ( (t1.o_hash='21394') AND t1.p_id='596') AND t0.smw_iw!=':smw' AND t0.smw_iw!=':smw-delete' AND t0.smw_iw!=':smw-redi' ORDER BY t0.smw_sort ASC LIMIT 6 OFFSET 0 SQL Explain
Auxilliary Tables No auxilliary tables used.Query Metrics Query-Size:2Query-Depth:1 Errors and Warnings None |
18d 11h 36m 6s | 1d 0h 18m 21s | ||||||||||||||||||||||||||||||
SQLStore debug output ASK Query [[Characterid::84357]] SQL Query SELECT DISTINCT t0.smw_id AS id, t0.smw_title AS t, t0.smw_namespace AS ns, t0.smw_iw AS iw, t0.smw_subobject AS so, t0.smw_sortkey AS sortkey, t0.smw_sort FROM `wiki_smw_object_ids` AS t0 INNER JOIN `wiki_smw_di_blob` AS t1 ON t0.smw_id=t1.s_id WHERE ( (t1.o_hash='84357') AND t1.p_id='596') AND t0.smw_iw!=':smw' AND t0.smw_iw!=':smw-delete' AND t0.smw_iw!=':smw-redi' ORDER BY t0.smw_sort ASC LIMIT 6 OFFSET 0 SQL Explain
Auxilliary Tables No auxilliary tables used.Query Metrics Query-Size:2Query-Depth:1 Errors and Warnings None |
18d 23h 11m 23s | 3h 19m 27s |