Semantische Suche
Debug output SQLStore
ASK Query
[[Klassifikation von Bertuch::~*Pflanzen*]]
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 '%Pflanzen%') 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
100
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 '%Pflanzen%') 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
100
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
Ad00341 06 004a
Pflanzen. CXIX.
Pflanzen. CXIX.
Ad00341 06 020a
Pflanzen. CXX.
Pflanzen. CXX.
Ad00341 06 026a
Pflanzen. CXXI.
Pflanzen. CXXI.
Ad00341 06 029a
Pflanzen. CXXII.
Pflanzen. CXXII.
Ad00341 06 041a
Pflanzen. CXXIII.
Pflanzen. CXXIII.
Ad00341 06 042a
Pflanzen. CXXIV.
Pflanzen. CXXIV.
Ad00341 06 046a
Pflanzen CXXV.
Pflanzen CXXV.
Ad00341 06 051a
Pflanzen CXXVI.
Pflanzen CXXVI.
Ad00341 06 054a
Pflanzen CXXVII.
Pflanzen CXXVII.
Ad00341 06 059a
Pflanzen CXXVIII.
Pflanzen CXXVIII.
Ad00341 06 064a
Pflanzen CXXIX.
Pflanzen CXXIX.
Ad00341 06 069a
Pflanzen CXXX.
Pflanzen CXXX.
Ad00341 06 072a
Pflanzen CXXXI.
Pflanzen CXXXI.
Ad00341 06 084a
Pflanzen. CXXXII.
Pflanzen. CXXXII.
Ad00341 06 089a
Pflanzen. CXXXIII.
Pflanzen. CXXXIII.
Ad00341 06 096a
Pflanzen CXXXIV.
Pflanzen CXXXIV.
Ad00341 06 100a
Pflanzen CXXXIV.
Pflanzen CXXXIV.
Ad00341 07 011a
Pflanzen. CLXXXVI.
Pflanzen. CLXXXVI.
Ad00341 07 015a
Pflanzen. CXXXVII.
Pflanzen. CXXXVII.
Ad00341 07 019a
Pflanzen. CXXXVIII.
Pflanzen. CXXXVIII.