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::{{#replace:{{{CharacterId}}}|"|}}]] | format= | + | {{!}} {{#ask: [[Characterid::{{#replace:{{{CharacterId}}}|"|}}]] | format=debug| limit=1 | default={{{Name}}} }} >{{{CharacterId}}}< |
{{!}} {{{OnFor}}} | {{!}} {{{OnFor}}} | ||
{{!}} {{{Idlefor}}} | {{!}} {{{Idlefor}}} |
Revision as of 00:10, 23 March 2019
Name | Connected For | Idle For | ||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SQLStore debug output ASK Query [[Characterid::24040]] 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='24040') 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 |
10h 18m 11s | 10h 18m 11s | ||||||||||||||||||||||||||||||
SQLStore debug output ASK Query [[Characterid::21259]] 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='21259') 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 |
1d 5h 27m 57s | 15h 17m 50s | ||||||||||||||||||||||||||||||
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 |
1d 11h 5m 15s | 11h 32m 1s | ||||||||||||||||||||||||||||||
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 |
1d 22h 41m 15s | 16h 29m 3s | ||||||||||||||||||||||||||||||
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 |
1d 22h 41m 19s | 1d 22h 41m 19s | ||||||||||||||||||||||||||||||
SQLStore debug output ASK Query [[Characterid::21143]] 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='21143') 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 |
4d 3h 55m 9s | 3d 13h 15m 8s | ||||||||||||||||||||||||||||||
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 |
4d 14h 53m 12s | 4d 14h 52m 51s | ||||||||||||||||||||||||||||||
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 |
32d 21h 31m 12s | 17h 8m 55s |