تست

Debug output SQLStore

ASK Query

[[رده:فرآیندها]]

SQL Query

SELECT outer_q.smw_id AS id, outer_q.smw_title AS t, outer_q.smw_namespace AS ns, outer_q.smw_iw AS iw, outer_q.smw_subobject AS so, outer_q.smw_sortkey AS sortkey, inner_q.sf0
FROM
  `hafasmw_object_ids` AS outer_q
INNER JOIN
  (SELECT DISTINCT
  t0.smw_id AS s_id, t0.smw_sort AS sf0
FROM
  `hafasmw_object_ids` AS t0
INNER JOIN
  `hafasmw_fpt_inst` AS t1 ON t0.smw_id=t1.s_id
WHERE
  (t1.o_id=615)
  AND t0.smw_iw!=':smw'
  AND t0.smw_iw!=':smw-delete'
  AND t0.smw_iw!=':smw-redi'
ORDER BY
  t0.smw_sort ASC
LIMIT
  76) AS inner_q ON outer_q.smw_id = inner_q.s_id
ORDER BY
  inner_q.sf0 ASC
LIMIT
  55

SQL Explain

ID	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	PRIMARY	<derived2>	ALL					48		Using filesort
1	PRIMARY	outer_q	eq_ref	PRIMARY, smw_id	PRIMARY	4	inner_q.s_id	1
2	DERIVED	t1	ref	s_id, s_id_2, o_id	o_id	5	const	48		Using index; Using temporary; Using filesort
2	DERIVED	t0	eq_ref	PRIMARY, smw_id, smw_iw, smw_iw_2	PRIMARY	4	eaacir1_mediawiki.t1.s_id	1		Using where

Auxilliary Tables

No auxilliary tables used.

Query Metrics

Query-Size:1
Query-Depth:0

Errors and Warnings

None