Semantische Suche
Debug output SQLStore
ASK Query
[[Kategorie:Tafel]]
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
`smw_object_ids` AS t0
INNER JOIN
`smw_fpt_inst` AS t1 ON t0.smw_id=t1.s_id
WHERE
(t1.o_id=157733)
AND t0.smw_iw!=':smw'
AND t0.smw_iw!=':smw-delete'
AND t0.smw_iw!=':smw-redi'
ORDER BY
t0.smw_sort ASC
LIMIT
55
OFFSET
50
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
`smw_object_ids` AS t0
INNER JOIN
`smw_fpt_inst` AS t1 ON t0.smw_id=t1.s_id
WHERE
(t1.o_id=157733)
AND t0.smw_iw!=':smw'
AND t0.smw_iw!=':smw-delete'
AND t0.smw_iw!=':smw-redi'
ORDER BY
t0.smw_sort ASC
LIMIT
55
OFFSET
50
SQL Explain
ID | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | t1 | ref | s_id, o_id, s_id_2, o_id_2 | o_id_2 | 5 | const | 3088 | 100.00 | Using index; Using temporary; Using filesort |
1 | SIMPLE | t0 | eq_ref | PRIMARY, smw_id, smw_iw, smw_iw_2 | PRIMARY | 4 | Interlinking_Pictura_wiki.t1.s_id | 1 | 50.00 | Using where |
Auxilliary Tables
No auxilliary tables used.Query Metrics
Query-Size:1Query-Depth:0
Errors and Warnings
None- Ad00341 01 051aAd00341 01 051a
- Ad00341 01 052aAd00341 01 052a
- Ad00341 01 053aAd00341 01 053a
- Ad00341 01 054aAd00341 01 054a
- Ad00341 01 055aAd00341 01 055a
- Ad00341 01 056aAd00341 01 056a
- Ad00341 01 057aAd00341 01 057a
- Ad00341 01 058aAd00341 01 058a
- Ad00341 01 059aAd00341 01 059a
- Ad00341 01 060aAd00341 01 060a
- Ad00341 01 061aAd00341 01 061a
- Ad00341 01 062aAd00341 01 062a
- Ad00341 01 063aAd00341 01 063a
- Ad00341 01 064aAd00341 01 064a
- Ad00341 01 065aAd00341 01 065a
- Ad00341 01 066aAd00341 01 066a
- Ad00341 01 067aAd00341 01 067a
- Ad00341 01 068aAd00341 01 068a
- Ad00341 01 069aAd00341 01 069a
- Ad00341 01 070aAd00341 01 070a
- Ad00341 01 071aAd00341 01 071a
- Ad00341 01 072aAd00341 01 072a
- Ad00341 01 073aAd00341 01 073a
- Ad00341 01 074aAd00341 01 074a
- Ad00341 01 075aAd00341 01 075a
- Ad00341 01 076aAd00341 01 076a
- Ad00341 01 077aAd00341 01 077a
- Ad00341 01 078aAd00341 01 078a
- Ad00341 01 079aAd00341 01 079a
- Ad00341 01 080aAd00341 01 080a
- Ad00341 01 081aAd00341 01 081a
- Ad00341 01 082aAd00341 01 082a
- Ad00341 01 083aAd00341 01 083a
- Ad00341 01 084aAd00341 01 084a
- Ad00341 01 085aAd00341 01 085a
- Ad00341 01 086aAd00341 01 086a
- Ad00341 01 087aAd00341 01 087a
- Ad00341 01 088aAd00341 01 088a
- Ad00341 01 089aAd00341 01 089a
- Ad00341 01 090aAd00341 01 090a
- Ad00341 01 091aAd00341 01 091a
- Ad00341 01 092aAd00341 01 092a
- Ad00341 01 093aAd00341 01 093a
- Ad00341 01 094aAd00341 01 094a
- Ad00341 01 095aAd00341 01 095a
- Ad00341 01 096aAd00341 01 096a
- Ad00341 01 097aAd00341 01 097a
- Ad00341 01 098aAd00341 01 098a
- Ad00341 01 099aAd00341 01 099a
- Ad00341 01 100aAd00341 01 100a