Sandbox

From IMAGE
Revision as of 14:55, 1 August 2017 by Oostenrijr (talk | contribs)
Jump to: navigation, search
SQLStore debug output
ASK Query
[[:Category:+]]
SQL Query
SELECT DISTINCT
  t1.smw_id AS id,
  t1.smw_title AS t,
  t1.smw_namespace AS ns,
  t1.smw_iw AS iw,
  t1.smw_subobject AS so,
  t1.smw_sortkey AS sortkey, t1.smw_sort
FROM
  `smw_object_ids` AS t1
WHERE
  t1.smw_namespace='14'
  AND t1.smw_iw!=':smw'
  AND t1.smw_iw!=':smw-delete'
  AND t1.smw_iw!=':smw-redi'
ORDER BY
  t1.smw_sort ASC
LIMIT
  55
OFFSET
  0
SQL Explain
IDselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEt1refsmw_iw,smw_iw_2,smw_namespacesmw_namespace4const42Using where; Using filesort
Auxilliary Tables
No auxilliary tables used.
Query Metrics
Query-Size:1
Query-Depth:0
Errors and Warnings
None