Difference between revisions of "API: Who"

From Elder Tale Online MUSH
Jump to: navigation, search
m
m
Line 17: Line 17:
 
|}
 
|}
  
−
{{#ask: [[Characterid::{{#replace:"18359"|"|}}]] | format=plainlist | limit=1 | default=Default}}
+
{{#ask: [[Characterid::18359]]
 +
| format=debug | limit=1 | default=Default}}

Revision as of 00:11, 23 March 2019


Name Connected For Idle For
SQLStore debug output
ASK Query
[[Characterid::19702]]
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='19702') 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
IDselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEt1refs_id,o_hash,s_id_2,p_ido_hash258const1Using index condition; Using where; Using temporary; Using filesort
1SIMPLEt0eq_refPRIMARY,smw_id,smw_iw,smw_iw_2PRIMARY4eldertale_wiki.t1.s_id1Using where
Auxilliary Tables
No auxilliary tables used.
Query Metrics
Query-Size:2
Query-Depth:1
Errors and Warnings
None
>19702< 		3h 53m 1s 3h 53m 0s
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
IDselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEt1refs_id,o_hash,s_id_2,p_ido_hash258const1Using index condition; Using where; Using temporary; Using filesort
1SIMPLEt0eq_refPRIMARY,smw_id,smw_iw,smw_iw_2PRIMARY4eldertale_wiki.t1.s_id1Using where
Auxilliary Tables
No auxilliary tables used.
Query Metrics
Query-Size:2
Query-Depth:1
Errors and Warnings
None
>24040< 		1d 13h 41m 30s 1d 10h 9m 7s
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
IDselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEt1refs_id,o_hash,s_id_2,p_ido_hash258const1Using index condition; Using where; Using temporary; Using filesort
1SIMPLEt0eq_refPRIMARY,smw_id,smw_iw,smw_iw_2PRIMARY4eldertale_wiki.t1.s_id1Using where
Auxilliary Tables
No auxilliary tables used.
Query Metrics
Query-Size:2
Query-Depth:1
Errors and Warnings
None
>21259< 		2d 4h 35m 16s 4h 16m 15s
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
IDselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEt1refs_id,o_hash,s_id_2,p_ido_hash258const1Using index condition; Using where; Using temporary; Using filesort
1SIMPLEt0eq_refPRIMARY,smw_id,smw_iw,smw_iw_2PRIMARY4eldertale_wiki.t1.s_id1Using where
Auxilliary Tables
No auxilliary tables used.
Query Metrics
Query-Size:2
Query-Depth:1
Errors and Warnings
None
>21143< 		4d 16h 19m 4s 1d 13h 22m 26s
SQLStore debug output
ASK Query
[[Characterid::21330]]
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='21330') 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
IDselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEt1refs_id,o_hash,s_id_2,p_ido_hash258const1Using index condition; Using where; Using temporary; Using filesort
1SIMPLEt0eq_refPRIMARY,smw_id,smw_iw,smw_iw_2PRIMARY4eldertale_wiki.t1.s_id1Using where
Auxilliary Tables
No auxilliary tables used.
Query Metrics
Query-Size:2
Query-Depth:1
Errors and Warnings
None
>21330< 		4d 17h 10m 12s 4h 17m 21s
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
IDselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEt1refs_id,o_hash,s_id_2,p_ido_hash258const1Using index condition; Using where; Using temporary; Using filesort
1SIMPLEt0eq_refPRIMARY,smw_id,smw_iw,smw_iw_2PRIMARY4eldertale_wiki.t1.s_id1Using where
Auxilliary Tables
No auxilliary tables used.
Query Metrics
Query-Size:2
Query-Depth:1
Errors and Warnings
None
>21394< 		6d 22h 56m 47s 14h 25m 31s
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
IDselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEt1refs_id,o_hash,s_id_2,p_ido_hash258const1Using index condition; Using where; Using temporary; Using filesort
1SIMPLEt0eq_refPRIMARY,smw_id,smw_iw,smw_iw_2PRIMARY4eldertale_wiki.t1.s_id1Using where
Auxilliary Tables
No auxilliary tables used.
Query Metrics
Query-Size:2
Query-Depth:1
Errors and Warnings
None
>84357< 		7d 10h 32m 4s 3h 8m 19s
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
IDselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEt1refs_id,o_hash,s_id_2,p_ido_hash258const1Using index condition; Using where; Using temporary; Using filesort
1SIMPLEt0eq_refPRIMARY,smw_id,smw_iw,smw_iw_2PRIMARY4eldertale_wiki.t1.s_id1Using where
Auxilliary Tables
No auxilliary tables used.
Query Metrics
Query-Size:2
Query-Depth:1
Errors and Warnings
None
>18359< 		8d 10h 33m 53s 2d 3h 34m 43s
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
IDselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEt1refs_id,o_hash,s_id_2,p_ido_hash258const1Using index condition; Using where; Using temporary; Using filesort
1SIMPLEt0eq_refPRIMARY,smw_id,smw_iw,smw_iw_2PRIMARY4eldertale_wiki.t1.s_id1Using where
Auxilliary Tables
No auxilliary tables used.
Query Metrics
Query-Size:2
Query-Depth:1
Errors and Warnings
None
>60435< 		12d 18h 16m 21s 14h 50m 30s
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
IDselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEt1refs_id,o_hash,s_id_2,p_ido_hash258const1Using index condition; Using where; Using temporary; Using filesort
1SIMPLEt0eq_refPRIMARY,smw_id,smw_iw,smw_iw_2PRIMARY4eldertale_wiki.t1.s_id1Using where
Auxilliary Tables
No auxilliary tables used.
Query Metrics
Query-Size:2
Query-Depth:1
Errors and Warnings
None
>32382< 		12d 18h 16m 25s 2h 44m 39s
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
IDselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEt1refs_id,o_hash,s_id_2,p_ido_hash258const1Using index condition; Using where; Using temporary; Using filesort
1SIMPLEt0eq_refPRIMARY,smw_id,smw_iw,smw_iw_2PRIMARY4eldertale_wiki.t1.s_id1Using where
Auxilliary Tables
No auxilliary tables used.
Query Metrics
Query-Size:2
Query-Depth:1
Errors and Warnings
None
Retrieved from "https://wiki.eldertaleonline.com/index.php?title=API:Who&oldid=529"