Semantic search
Debug output SQLStore
ASK Query
[[:+]] [[Category:Craft]]
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
`salem_wikismw_object_ids` AS t0
INNER JOIN
(`salem_wikismw_object_ids` AS t2
INNER JOIN
(`salem_wikismw_fpt_inst` AS t3
INNER JOIN
`salem_wikit4` AS t4 ON t3.o_id=t4.id) ON t2.smw_id=t3.s_id) ON t0.smw_id=t2.smw_id
WHERE
(t2.smw_namespace=0)
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
`salem_wikismw_object_ids` AS t0
INNER JOIN
(`salem_wikismw_object_ids` AS t2
INNER JOIN
(`salem_wikismw_fpt_inst` AS t3
INNER JOIN
`salem_wikit4` AS t4 ON t3.o_id=t4.id) ON t2.smw_id=t3.s_id) ON t0.smw_id=t2.smw_id
WHERE
(t2.smw_namespace=0)
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 | t4 | ALL | PRIMARY | 24 | 100.00 | Using temporary; Using filesort | |||
1 | SIMPLE | t3 | ref | s_id, o_id, s_id_2, o_id_2 | o_id_2 | 5 | k56270_salemwiki.t4.id | 105 | 100.00 | Using index |
1 | SIMPLE | t2 | eq_ref | PRIMARY, smw_id, smw_namespace | PRIMARY | 4 | k56270_salemwiki.t3.s_id | 1 | 50.00 | Using where |
1 | SIMPLE | t0 | eq_ref | PRIMARY, smw_id, smw_iw, smw_iw_2 | PRIMARY | 4 | k56270_salemwiki.t3.s_id | 1 | 50.03 | Using where |
Auxilliary Tables
- Temporary table t4
Recursively computed hierarchy for element(s) (2591).
SELECT s_id FROM `salem_wikismw_fpt_subc` WHERE o_id=2591 LIMIT 1
Query Metrics
Query-Size:2Query-Depth:0
Errors and Warnings
None- 'Shroom-Stuffed Bellpepper x'Shroom-Stuffed Bellpepper
- 'Shrooms-on-a-Stick x'Shrooms-on-a-Stick
- A Face in the Dross xA Face in the Dross
- A Fish in the Reeds xA Fish in the Reeds
- A Rabbit in the Cabbage xA Rabbit in the Cabbage
- A Side of Venison xA Side of Venison
- A Snake in the Grass xA Snake in the Grass
- A Taste of Autumn xA Taste of Autumn
- A Taste of The New World xA Taste of The New World
- A Walk on the Wild Side xA Walk on the Wild Side
- Abandoned Cobweb xAbandoned Cobweb
- Absurdly Large Cookie xAbsurdly Large Cookie
- Acorn Indian xAcorn Indian
- Adventurer's Trailmix xAdventurer's Trailmix
- Aged Driftwood xAged Driftwood
- Ambergris xAmbergris
- Anadama Bread xAnadama Bread
- Angry Pistol Puffer xAngry Pistol Puffer
- Animal Bone Necklace xAnimal Bone Necklace
- Animal Canine xAnimal Canine
- Animal Crackers xAnimal Crackers
- Antlers of Furfur xAntlers of Furfur
- Any Bugs xAny Bugs
- Apple xApple
- Argomoon xArgomoon
- Argopelter Beak xArgopelter Beak
- Argopelter Breast xArgopelter Breast
- Argopelter Drumstick xArgopelter Drumstick
- Argopelter Jerky xArgopelter Jerky
- Argopelter Liver xArgopelter Liver
- Argopelter Thigh xArgopelter Thigh
- Argopelter Wing xArgopelter Wing
- Ashes of Maudney xAshes of Maudney
- Aspen xAspen
- Aspen Masque xAspen Masque
- Autumn Delight xAutumn Delight
- Autumn Gold xAutumn Gold
- Aztec Abattoir xAztec Abattoir
- Baby Bear xBaby Bear
- Baby Squid xBaby Squid
- Baguette xBaguette
- Bajgiel xBajgiel
- Baked Potato xBaked Potato
- Bar of Bubbly Soap xBar of Bubbly Soap
- Bar of Rose Scented Soap xBar of Rose Scented Soap
- Bat Fang xBat Fang
- Beaming-Proud Sunflower xBeaming-Proud Sunflower
- Beargarden Biscuit xBeargarden Biscuit
- Beautiful Seashell xBeautiful Seashell
- Beaver Dam xBeaver Dam