API: Who

Name	Connected For	Idle For
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 ID select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE t1 ref s_id,o_hash,s_id_2,p_id o_hash 258 const 1 Using index condition; Using where; Using temporary; Using filesort 1 SIMPLE t0 eq_ref PRIMARY,smw_id,smw_iw,smw_iw_2 PRIMARY 4 eldertale_wiki.t1.s_id 1 Using where Auxilliary Tables No auxilliary tables used. Query Metrics Query-Size:2 Query-Depth:1 Errors and Warnings None >60435<	2d 14h 18m 9s	22h 42m 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 ID select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE t1 ref s_id,o_hash,s_id_2,p_id o_hash 258 const 1 Using index condition; Using where; Using temporary; Using filesort 1 SIMPLE t0 eq_ref PRIMARY,smw_id,smw_iw,smw_iw_2 PRIMARY 4 eldertale_wiki.t1.s_id 1 Using where Auxilliary Tables No auxilliary tables used. Query Metrics Query-Size:2 Query-Depth:1 Errors and Warnings None >32382<	2d 14h 18m 9s	4m 21s
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 ID select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE t1 ref s_id,o_hash,s_id_2,p_id o_hash 258 const 1 Using index condition; Using where; Using temporary; Using filesort 1 SIMPLE t0 eq_ref PRIMARY,smw_id,smw_iw,smw_iw_2 PRIMARY 4 eldertale_wiki.t1.s_id 1 Using where Auxilliary Tables No auxilliary tables used. Query Metrics Query-Size:2 Query-Depth:1 Errors and Warnings None >18359<	6d 22h 54m 54s	5d 20h 21m 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 ID select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE t1 ref s_id,o_hash,s_id_2,p_id o_hash 258 const 1 Using index condition; Using where; Using temporary; Using filesort 1 SIMPLE t0 eq_ref PRIMARY,smw_id,smw_iw,smw_iw_2 PRIMARY 4 eldertale_wiki.t1.s_id 1 Using where Auxilliary Tables No auxilliary tables used. Query Metrics Query-Size:2 Query-Depth:1 Errors and Warnings None >21866<	10d 16h 57m 48s	9d 17h 54m 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 ID select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE t1 ref s_id,o_hash,s_id_2,p_id o_hash 258 const 1 Using index condition; Using where; Using temporary; Using filesort 1 SIMPLE t0 eq_ref PRIMARY,smw_id,smw_iw,smw_iw_2 PRIMARY 4 eldertale_wiki.t1.s_id 1 Using where Auxilliary Tables No auxilliary tables used. Query Metrics Query-Size:2 Query-Depth:1 Errors and Warnings None >21394<	18d 10h 36m 15s	23h 18m 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 ID select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE t1 ref s_id,o_hash,s_id_2,p_id o_hash 258 const 1 Using index condition; Using where; Using temporary; Using filesort 1 SIMPLE t0 eq_ref PRIMARY,smw_id,smw_iw,smw_iw_2 PRIMARY 4 eldertale_wiki.t1.s_id 1 Using where Auxilliary Tables No auxilliary tables used. Query Metrics Query-Size:2 Query-Depth:1 Errors and Warnings None >84357<	18d 22h 11m 32s	2h 19m 36s

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

ID	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	t1	ref	s_id,o_hash,s_id_2,p_id	o_hash	258	const	1	Using index condition; Using where; Using temporary; Using filesort
1	SIMPLE	t0	eq_ref	PRIMARY,smw_id,smw_iw,smw_iw_2	PRIMARY	4	eldertale_wiki.t1.s_id	1	Using where

Auxilliary Tables

No auxilliary tables used.

Query Metrics

Query-Size:2
Query-Depth:1

Errors and Warnings

None