API: Who

From Elder Tale Online MUSH
Revision as of 00:11, 23 March 2019 by Liminality (talk | contribs)
Jump to: navigation, search


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< 		1h 55m 7s 1h 51m 7s
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< 		20h 49m 25s 17h 17m 2s
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< 		1d 11h 43m 11s 3h 9m 50s
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< 		3d 23h 26m 59s 20h 30m 21s
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 0h 18m 7s 5h 43m 36s
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 6h 4m 42s 3d 7h 26m 8s
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< 		6d 17h 39m 59s 7h 49m 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
>18359< 		7d 17h 41m 48s 1d 10h 42m 38s
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 1h 24m 16s 18h 55m 58s
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 1h 24m 20s 4d 20h 59m 50s

Liminality

Retrieved from "https://wiki.eldertaleonline.com/index.php?title=API:Who&oldid=528"