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
500
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
500
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- Roasted Gold Pickerel xRoasted Gold Pickerel
- Roasted Hellish Halibut xRoasted Hellish Halibut
- Roasted Hickory Nut xRoasted Hickory Nut
- Roasted Long-Whiskered Catfish xRoasted Long-Whiskered Catfish
- Roasted Majestic Acorn xRoasted Majestic Acorn
- Roasted Mutton Cut xRoasted Mutton Cut
- Roasted Mutton Steak xRoasted Mutton Steak
- Roasted Myrtle Acorns xRoasted Myrtle Acorns
- Roasted Pine Nut Stuffing xRoasted Pine Nut Stuffing
- Roasted Pine Nuts xRoasted Pine Nuts
- Roasted Popham Pike xRoasted Popham Pike
- Roasted Pork Cut xRoasted Pork Cut
- Roasted Pork Steak xRoasted Pork Steak
- Roasted Pumpkin Seeds xRoasted Pumpkin Seeds
- Roasted Rabbit Cut xRoasted Rabbit Cut
- Roasted Rabbit Steak xRoasted Rabbit Steak
- Roasted Raging Bullhead xRoasted Raging Bullhead
- Roasted Red Herring xRoasted Red Herring
- Roasted Red-Finned Mullet xRoasted Red-Finned Mullet
- Roasted Sargasso Eel xRoasted Sargasso Eel
- Roasted Shin Spinner xRoasted Shin Spinner
- Roasted Silt-Dwelling Mudsnapper xRoasted Silt-Dwelling Mudsnapper
- Roasted Squirrel Cut xRoasted Squirrel Cut
- Roasted Testicles xRoasted Testicles
- Roasted Tiger Trout xRoasted Tiger Trout
- Roasted Timber Rattler Cut xRoasted Timber Rattler Cut
- Roasted Timber Rattler Steak xRoasted Timber Rattler Steak
- Roasted Trunk-Nosed Lake Perch xRoasted Trunk-Nosed Lake Perch
- Roasted Venison Cut xRoasted Venison Cut
- Roasted Venison Steak xRoasted Venison Steak
- Roasted Walnut xRoasted Walnut
- Rock Maracas xRock Maracas
- Rocking Horse xRocking Horse
- Royal Jelly xRoyal Jelly
- Rusty Coin xRusty Coin
- Rye Bread xRye Bread
- Salamander xSalamander
- Salamander Tail xSalamander Tail
- Salted Radish xSalted Radish
- Salty Nuts xSalty Nuts
- Samhain Masque xSamhain Masque
- Sand xSand
- Sand Dollar xSand Dollar
- Sauce Chasseur xSauce Chasseur
- Saurkraut xSaurkraut
- Sausage Links xSausage Links
- Sauteed Shellshrooms xSauteed Shellshrooms
- Savage Charm xSavage Charm
- Scary Stroganoff xScary Stroganoff
- Scintillating Sand xScintillating Sand