User:Dl88008/sandbox7

Debug Output by SQLStore

Ask query

[[Category:Success Stories]]

SQL Query

SELECT DISTINCT
  t2.smw_id AS id,t2.smw_title AS t,t2.smw_namespace AS ns,t2.smw_iw AS iw,t2.smw_subobject AS so,t2.smw_sortkey AS sortkey
FROM
  `mw_smw_object_ids` AS t2
INNER JOIN
  `mw_smw_fpt_inst` AS t0 ON t2.smw_id=t0.s_id
INNER JOIN
  `mw_t1` AS t1 ON t0.o_id=t1.id
ORDER BY
  t2.smw_sortkey ASC
LIMIT
  55
OFFSET
  0

SQL Explain

ID	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	t1	ALL	PRIMARY				2	Using temporary; Using filesort
1	SIMPLE	t0	ref	s_id,o_id	o_id	5	dl88008_scnped.t1.id	38
1	SIMPLE	t2	eq_ref	PRIMARY,smw_id	PRIMARY	4	dl88008_scnped.t0.s_id	1

Auxilliary Tables Used

• Temporary table t1
    Recursively computed hierarchy for element(s) ('274').

Query Metrics

Query-Size:1
Query-Depth:0

Errors and Warnings

None