API: Who

Name	Connected For	Idle For
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 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 >24040<	1d 6h 46m 29s	1d 3h 14m 6s
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 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 >21259<	1d 21h 40m 15s	12s
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 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 >21143<	4d 9h 24m 3s	1d 6h 27m 25s
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 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 >21330<	4d 10h 15m 11s	15h 40m 40s
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<	6d 16h 1m 46s	7h 30m 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<	7d 3h 37m 3s	3s
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<	8d 3h 38m 52s	1d 20h 39m 42s
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<	12d 11h 21m 20s	7h 55m 29s
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<	12d 11h 21m 24s	5d 6h 56m 54s

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