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
25
OFFSET
80
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
25
OFFSET
80
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
Ad99998 04 010a
Fische XXIX.
Fische XXIX.
Ad99998 04 014a
Fische XXX.
Fische XXX.
Ad99998 04 019a
Fische XXXI.
Fische XXXI.
Ad99998 04 024a
Fische XXXII.
Fische XXXII.
Ad99998 04 050a
Fische. XXXIII.
Fische. XXXIII.
Ad99998 04 054a
Fische. XXXIV. IV.
Fische. XXXIV. IV.
Ad99998 04 075a
Fische. XXXV.
Fische. XXXV.
Ad99998 04 078a
Fische. XXXVI.
Fische. XXXVI.
Ad99998 04 086a
Fische XXXVII.
Fische XXXVII.
Ad99998 04 094a
Fische. XXXVIII.
Fische. XXXVIII.
Ad99998 04 099a
Fische. XXXIX.
Fische. XXXIX.
Ad99998 05 005a
Fische XL.
Fische XL.
Ad99998 06 010a
Fische XLI.
Fische XLI.
Ad99998 08 035a
Fische. XLII.
Fische. XLII.
Ad99998 08 037a
Fische. XLIII.
Fische. XLIII.
Ad99998 09 005a
Fische. XLIV.
Fische. XLIV.
Ad99998 09 006a
Fische. XLV.
Fische. XLV.
Ad99998 09 010a
Fische. XLVI.
Fische. XLVI.
Ad99998 09 011a
Fische XLVII.
Fische XLVII.
Ad99998 09 021a
Fische. XLVIII.
Fische. XLVIII.