Sandbox: Difference between revisions

From IMAGE
Jump to navigation Jump to search
No edit summary
No edit summary
Line 1: Line 1:
{{#ask:[[IMAGE_land_management:+]]|format=debug}}
{{#ask:[[Category:+]]|format=debug}}

Revision as of 15:55, 1 August 2017

Debug output SQLStore
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_lenrefrowsfilteredExtra
1SIMPLEt1refsmw_iw, smw_iw_2, smw_namespacesmw_namespace4const4350.01Using index condition; Using where; Using filesort
Auxilliary Tables
No auxilliary tables used.
Query Metrics
Query-Size:1
Query-Depth:0
Errors and Warnings
None