Semantic search
SQLStore debug output
ASK Query
[[Part of::Property:Phyllary]]
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_wikipage` AS t1 ON t0.smw_id=t1.s_id
WHERE
(t1.p_id='2719' AND t1.o_id='3486')
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
600
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_wikipage` AS t1 ON t0.smw_id=t1.s_id
WHERE
(t1.p_id='2719' AND t1.o_id='3486')
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
600
SQL Explain
ID | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | t1 | ref | s_id,o_id,p_id,s_id_2,s_id_3,o_id_2,o_id_3 | o_id | 5 | const | 831 | Using where; Using temporary; Using filesort |
1 | SIMPLE | t0 | eq_ref | PRIMARY,smw_id,smw_iw,smw_iw_2 | PRIMARY | 4 | mediawiki.t1.s_id | 1 | Using where |
Auxilliary Tables
No auxilliary tables used.Query Metrics
Query-Size:2Query-Depth:1
Errors and Warnings
NoneP
- Protonematal appendage some measurement
- Purple-tinged; purple-tinged apex architecture
- Purple-tinged; purple-tinged apex course
- Purple-tinged; purple-tinged apex pubescence or relief
- Purple-tinged; purple-tinged apex shape
R
- Rachis apex density
- Rachis apex shape
- Replum apex shape
- Rhizome apex architecture
- Rhizome apex fragility
- Rhizome apex pubescence
S
S cont.
- Segment apex fragility
- Segment apex shape
- Sepal apex shape
- Sepal tip length
- Sepal tip orientation
- Sepal tip some measurement
- Sepal tip width
- Sheath apex architecture or shape
- Sheath apex shape
- Shoot apex coloration
- Shoot apex position relational
- Shoot apex shape
- Shoot tip architecture
- Shoot tip quantity
- Shorter apex shape
- Slender apex position
- Slender apex shape
S cont.
- Slender appendage length or size
- Slender appendage some measurement
- Slender tip orientation
- Slender tip quantity
- Slender tip shape
- Spathe apex shape
- Spathe apex texture
- Spike apex coloration
- Spikelet apex shape
- Spine tip atypical some measurement
- Spine tip coloration
- Spine tip duration
- Spine tip orientation
- Spine tip pubescence
- Spine tip shape
- Spine tip some measurement