Difference between revisions of "API: Who"
From Elder Tale Online MUSH
Liminality (talk | contribs) m |
Liminality (talk | contribs) m |
||
Line 18: | Line 18: | ||
{{#ask: [[Characterid::18359]] | {{#ask: [[Characterid::18359]] | ||
− | + | | limit=1 | default=Default}} |
Revision as of 00:12, 23 March 2019
Name | Connected For | Idle For | ||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 |
3h 47m 58s | 36m 26s | ||||||||||||||||||||||||||||||
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 20h 0m 9s | 1d 4h 24m 11s | ||||||||||||||||||||||||||||||
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 20h 0m 9s | 5h 1m 43s | ||||||||||||||||||||||||||||||
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 |
7d 4h 36m 54s | 6d 2h 3m 48s | ||||||||||||||||||||||||||||||
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 22h 39m 48s | 9d 23h 36m 23s | ||||||||||||||||||||||||||||||
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 16h 18m 15s | 23s | ||||||||||||||||||||||||||||||
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 |
19d 3h 53m 32s | 1h 53m 9s |