Semantic search
Jump to navigation
Jump to search
Query-Depth:1
Debug output SQLStore
ASK Query
[[Body Size::≤0.75]]
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
`mr_smw_object_ids` AS t0
INNER JOIN
`mr_smw_di_number` AS t1 ON t0.smw_id=t1.s_id
WHERE
(
(t1.o_sortkey<='0.75') AND t1.p_id=21435)
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
0
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
`mr_smw_object_ids` AS t0
INNER JOIN
`mr_smw_di_number` AS t1 ON t0.smw_id=t1.s_id
WHERE
(
(t1.o_sortkey<='0.75') AND t1.p_id=21435)
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
0
SQL Explain
ID | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | t1 | range | s_id, p_id, o_sortkey, p_id_2, s_id_2 | p_id | 13 | 48 | 100.00 | Using index condition; Using temporary; Using filesort | |
1 | SIMPLE | t0 | eq_ref | PRIMARY, smw_id, smw_iw, smw_iw_2 | PRIMARY | 4 | rimworld_wiki_new.t1.s_id | 1 | 50.01 | Using where |
Auxilliary Tables
No auxilliary tables used.Query Metrics
Query-Size:2Query-Depth:1
Errors and Warnings
NoneBody Size | Type | |
---|---|---|
Agrihand | 0.7 | Mechanoid |
Alphabeaver | 0.45 | Animal |
Arctic fox | 0.55 | Animal |
Barkskin | 0.65 | Animal |
Berrymaker | 0.667 | Animal |
Boomrat | 0.2 | Animal |
Capybara | 0.75 | Animal |
Carrier | 0.667 | Animal |
Cassowary | 0.6 | Animal |
Cat | 0.32 | Animal |
Chicken | 0.3 | Animal |
Chinchilla | 0.35 | Animal |
Clawer | 0.667 | Animal |
Cleansweeper | 0.3 | Mechanoid |
Cobra | 0.25 | Animal |
Constructoid | 0.7 | Mechanoid |
Duck | 0.3 | Animal |
Emu | 0.6 | Animal |
Fabricor | 0.7 | Mechanoid |
Fennec fox | 0.55 | Animal |
Gaumaker | 0.667 | Animal |
Gazelle | 0.7 | Animal |
Goat | 0.75 | Animal |
Goose | 0.6 | Animal |
Guinea pig | 0.2 | Animal |
Hare | 0.2 | Animal |
Iguana | 0.4 | Animal |
Immature dryad | 0.667 | Animal |
Labrador retriever | 0.75 | Animal |
Lifter | 0.7 | Mechanoid |
Lynx | 0.6 | Animal |
Medicinemaker | 0.667 | Animal |
Megascarab | 0.2 | Animal |
Militor | 0.7 | Mechanoid |
Monkey | 0.35 | Animal |
Paramedic | 0.7 | Mechanoid |
Raccoon | 0.4 | Animal |
Rat | 0.2 | Animal |
Red fox | 0.55 | Animal |
Sheep | 0.75 | Animal |
Snowhare | 0.2 | Animal |
Squirrel | 0.2 | Animal |
Tortoise | 0.5 | Animal |
Turkey | 0.6 | Animal |
War urchin | 0.7 | Mechanoid |
Waste rat | 0.3 | Animal |
Woodmaker | 0.667 | Animal |
Yorkshire terrier | 0.32 | Animal |