Semantic search
Jump to navigation
Jump to search
Query-Depth:1
Debug output SQLStore
ASK Query
[[Resource 1::+]] [[!Category:Building]] [[!Category:Furniture]] [[!Category:Miscellaneous]] [[!Category:Security]] [[!Category:Production]] [[!Category:Floor]]
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, idst12.smw_sort
FROM
`mr_smw_object_ids` AS t0
INNER JOIN
(`mr_smw_di_wikipage` AS t2
INNER JOIN
`mr_smw_object_ids` AS t5 ON t2.s_id=t5.smw_id
INNER JOIN
`mr_smw_object_ids` AS t6 ON t2.s_id=t6.smw_id
INNER JOIN
`mr_smw_object_ids` AS t7 ON t2.s_id=t7.smw_id
INNER JOIN
`mr_smw_object_ids` AS t8 ON t2.s_id=t8.smw_id
INNER JOIN
`mr_smw_object_ids` AS t9 ON t2.s_id=t9.smw_id
INNER JOIN
`mr_smw_object_ids` AS t10 ON t2.s_id=t10.smw_id) ON t0.smw_id=t2.s_id
LEFT OUTER JOIN
(`mr_smw_di_wikipage` AS t12
INNER JOIN
`mr_smw_object_ids` AS idst12 ON idst12.smw_id=t12.o_id) ON t0.smw_id=t12.s_id
AND (t12.p_id=197510)
WHERE
(t2.p_id=191170
AND (t5.smw_sortkey!='Building')
AND (t6.smw_sortkey!='Furniture')
AND (t7.smw_sortkey!='Miscellaneous')
AND (t8.smw_sortkey!='Security')
AND (t9.smw_sortkey!='Production')
AND (t10.smw_sortkey!='Floor')
)
AND t0.smw_iw!=':smw'
AND t0.smw_iw!=':smw-delete'
AND t0.smw_iw!=':smw-redi'
ORDER BY
idst12.smw_sort ASC
LIMIT
10
OFFSET
10
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, idst12.smw_sort
FROM
`mr_smw_object_ids` AS t0
INNER JOIN
(`mr_smw_di_wikipage` AS t2
INNER JOIN
`mr_smw_object_ids` AS t5 ON t2.s_id=t5.smw_id
INNER JOIN
`mr_smw_object_ids` AS t6 ON t2.s_id=t6.smw_id
INNER JOIN
`mr_smw_object_ids` AS t7 ON t2.s_id=t7.smw_id
INNER JOIN
`mr_smw_object_ids` AS t8 ON t2.s_id=t8.smw_id
INNER JOIN
`mr_smw_object_ids` AS t9 ON t2.s_id=t9.smw_id
INNER JOIN
`mr_smw_object_ids` AS t10 ON t2.s_id=t10.smw_id) ON t0.smw_id=t2.s_id
LEFT OUTER JOIN
(`mr_smw_di_wikipage` AS t12
INNER JOIN
`mr_smw_object_ids` AS idst12 ON idst12.smw_id=t12.o_id) ON t0.smw_id=t12.s_id
AND (t12.p_id=197510)
WHERE
(t2.p_id=191170
AND (t5.smw_sortkey!='Building')
AND (t6.smw_sortkey!='Furniture')
AND (t7.smw_sortkey!='Miscellaneous')
AND (t8.smw_sortkey!='Security')
AND (t9.smw_sortkey!='Production')
AND (t10.smw_sortkey!='Floor')
)
AND t0.smw_iw!=':smw'
AND t0.smw_iw!=':smw-delete'
AND t0.smw_iw!=':smw-redi'
ORDER BY
idst12.smw_sort ASC
LIMIT
10
OFFSET
10
SQL Explain
ID | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | t2 | ref | s_id, p_id, s_id_2, s_id_3 | p_id | 4 | const | 496 | 100.00 | Using index; Using temporary; Using filesort |
1 | SIMPLE | t5 | eq_ref | PRIMARY, smw_id, smw_sortkey | PRIMARY | 4 | rimworld_wiki_new.t2.s_id | 1 | 79.92 | Using where |
1 | SIMPLE | t8 | eq_ref | PRIMARY, smw_id, smw_sortkey | PRIMARY | 4 | rimworld_wiki_new.t2.s_id | 1 | 82.53 | Using where |
1 | SIMPLE | t9 | eq_ref | PRIMARY, smw_id, smw_sortkey | PRIMARY | 4 | rimworld_wiki_new.t2.s_id | 1 | 95.34 | Using where |
1 | SIMPLE | t7 | eq_ref | PRIMARY, smw_id, smw_sortkey | PRIMARY | 4 | rimworld_wiki_new.t2.s_id | 1 | 99.35 | Using where |
1 | SIMPLE | t0 | eq_ref | PRIMARY, smw_id, smw_iw, smw_iw_2 | PRIMARY | 4 | rimworld_wiki_new.t2.s_id | 1 | 50.01 | Using where |
1 | SIMPLE | t6 | eq_ref | PRIMARY, smw_id, smw_sortkey | PRIMARY | 4 | rimworld_wiki_new.t2.s_id | 1 | 100.00 | Using where |
1 | SIMPLE | t10 | eq_ref | PRIMARY, smw_id, smw_sortkey | PRIMARY | 4 | rimworld_wiki_new.t2.s_id | 1 | 100.00 | Using where |
1 | SIMPLE | t12 | ref | s_id, o_id, p_id, s_id_2, s_id_3, o_id_2, o_id_3 | s_id_3 | 8 | rimworld_wiki_new.t2.s_id, const | 1 | 100.00 | Using index |
1 | SIMPLE | idst12 | eq_ref | PRIMARY, smw_id | PRIMARY | 4 | rimworld_wiki_new.t12.o_id | 1 | 100.00 |
Auxilliary Tables
No auxilliary tables used.Query Metrics
Query-Size:7Query-Depth:1
Errors and Warnings
NoneProduction Facility 1 | Type | Type2 | |
---|---|---|---|
Stool | Building | Furniture | |
Rustic rug (medium) | Building | Floor | |
Vent | Building | Temperature | |
Spikecore stone tile | Floor | ||
Wall torch lamp | Building | Furniture |