Semantic search
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_blob` AS t2
INNER JOIN
`mr_smw_di_blob` AS t4 ON t2.s_id=t4.s_id
INNER JOIN
`mr_smw_di_blob` AS t6 ON t2.s_id=t6.s_id
INNER JOIN
`mr_smw_di_blob` AS t8 ON t2.s_id=t8.s_id
INNER JOIN
`mr_smw_di_blob` AS t10 ON t2.s_id=t10.s_id) ON t0.smw_id=t2.s_id
WHERE
(
(t2.o_hash NOT LIKE '%spot') AND t2.p_id=2936
AND (
(t4.o_hash NOT LIKE '%meat') AND t4.p_id=2936)
AND (
(t6.o_hash!='Plant') AND t6.p_id=23516)
AND (
(t8.o_hash!='Animal') AND t8.p_id=23516)
AND (
(t10.o_hash!='Egg') AND t10.p_id=87825)
)
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
2
ID | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | t10 | range | s_id, p_id, s_id_2, o_hash | p_id | 262 | 802 | 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.t10.s_id | 1 | 50.01 | Using where |
1 | SIMPLE | t8 | ref | s_id, p_id, s_id_2, o_hash | s_id | 8 | rimworld_wiki_new.t10.s_id, const | 1 | 60.23 | Using where; Distinct |
1 | SIMPLE | t2 | ref | s_id, p_id, s_id_2 | s_id | 8 | rimworld_wiki_new.t10.s_id, const | 1 | 88.89 | Using where; Distinct |
1 | SIMPLE | t4 | ref | s_id, p_id, s_id_2 | s_id | 8 | rimworld_wiki_new.t10.s_id, const | 1 | 88.89 | Using where; Distinct |
1 | SIMPLE | t6 | ref | s_id, p_id, s_id_2, o_hash | s_id | 8 | rimworld_wiki_new.t10.s_id, const | 1 | 100.00 | Using where; Distinct |
Query-Depth:1
Aesthetic shaper, Agave fruit, Airwire headset, Alpaca wool, Ambrosia, Ancient ATM, Ancient air conditioner, Ancient barrel, Ancient bed, Ancient car, Ancient car frame, Ancient comms console, Ancient concrete barrier, Ancient container, Ancient crate, Ancient cryptosleep pod, Ancient display bank, Ancient dropship, Ancient dropship engine, Ancient enemy terminal, Ancient engine block, Ancient equipment blocks, Ancient exostrider cannon, Ancient exostrider head, Ancient exostrider leg, Ancient exostrider midsection, Ancient fence, Ancient generator, Ancient giant wheel, Ancient hydrant, Ancient jet engine, Ancient kitchen sink, Ancient lamp, Ancient lamppost, Ancient large crate, Ancient locker bank, Ancient long crate, Ancient machine, Ancient macro-engine block, Ancient mech drop beacon, Ancient mechanoid shell, Ancient mega-cannon barrel, Ancient mega-cannon platform, Ancient microwave, Ancient nav beacon, Ancient operating table, Ancient oven, Ancient pipeline section, Ancient pipes, Ancient pod car