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::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< 		2h 43m 58s 2h 17m 55s
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< 		2d 18h 56m 9s 1d 3h 20m 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
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< 		2d 18h 56m 9s 3h 57m 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
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 3h 32m 54s 6d 0h 59m 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
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
>21866< 		10d 21h 35m 48s 9d 22h 32m 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
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< 		18d 15h 14m 15s 1d 3h 56m 30s
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< 		19d 2h 49m 32s 49m 9s
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"