Semantische Suche
Debug output SQLStore
ASK Query
[[Klassifikation von Bertuch::~*Fische*]]
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_di_blob` AS t1 ON t0.smw_id=t1.s_id
WHERE
(
(t1.o_hash LIKE '%Fische%') AND t1.p_id=157912)
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
180
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_di_blob` AS t1 ON t0.smw_id=t1.s_id
WHERE
(
(t1.o_hash LIKE '%Fische%') AND t1.p_id=157912)
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
180
SQL Explain
ID | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | t1 | ref | s_id, p_id, s_id_2 | p_id | 4 | const | 2966 | 11.11 | Using index condition; 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:2Query-Depth:1
Errors and Warnings
None
Ad99999 09 034a
Fische. LI.
Fische. LI.
Ad99999 09 039a
Fische, LII
Fische, LII
Ad99999 09 044a
Fische. LIII.
Fische. LIII.
Ad99999 09 049a
Fische LIV.
Fische LIV.
Ad99999 09 058a
Fische LV.
Fische LV.
Ad99999 09 064a
Fische. LVI
Fische. LVI
Ad99999 10 009a
Fische LVII.
Fische LVII.
Ad99999 10 045a
Fische. LVIII.
Fische. LVIII.
Ad99999 10 055a
Fische LIX.
Fische LIX.
Ad99999 10 060a
Fische. LX.
Fische. LX.
Ad99999 10 070a
Fische LXI.
Fische LXI.
Ad99999 10 075a
Fische. LXII.
Fische. LXII.
Ad99999 10 080a
Fische. LXIII
Fische. LXIII
Ad99999 10 100a
Fische. LXIV.
Fische. LXIV.
Ad99999 11 004a
Fische. LXV.
Fische. LXV.
Ad99999 11 009a
Fische. LXVI.
Fische. LXVI.
Ad99999 11 020a
Fische. LXVII.
Fische. LXVII.
Ad99999 11 029a
Fische. LXVIII.
Fische. LXVIII.
Ad99999 11 050a
Fische. LXIX.
Fische. LXIX.
Ad99999 11 075a
Fische. LXX.
Fische. LXX.
Ad99999 11 088a
Fische. LXXI.
Fische. LXXI.
Ad99999 11 089a
Fische. LXXII.
Fische. LXXII.