Semantic search
Jump to navigation
Jump to search
Debug output SQLStore
ASK Query
[[Uses symbol::Wood||wooden]]OR[[Uses material::Wood||Wooden]]
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
`smw_object_ids` AS t0
INNER JOIN
`t1` AS t1 ON t0.smw_id=t1.id
WHERE
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
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, t0.smw_sort
FROM
`smw_object_ids` AS t0
INNER JOIN
`t1` AS t1 ON t0.smw_id=t1.id
WHERE
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
10
SQL Explain
ID | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | t1 | ALL | PRIMARY | 4133 | Using temporary; Using filesort | ||||
1 | SIMPLE | t0 | eq_ref | PRIMARY, smw_id, smw_iw, smw_iw_2 | PRIMARY | 4 | drwiki.t1.id | 1 | Using where |
Auxilliary Tables
- Temporary table t1
INSERT IGNORE INTO `t1` SELECT DISTINCT t2.s_id FROM `smw_di_blob` AS t2 INNER JOIN `t3` AS t3 ON t2.p_id=t3.id WHERE ((t2.o_hash='Wood') OR (t2.o_hash='wooden'))
INSERT IGNORE INTO `t1` SELECT DISTINCT t4.s_id FROM `smw_di_wikipage` AS t4 INNER JOIN `t6` AS t6 ON t4.o_id=t6.id WHERE t4.p_id=2021246 - Temporary table t3
Recursively computed hierarchy for element(s) (2021227).
SELECT s_id FROM `smw_fpt_subp` WHERE o_id=2021227 LIMIT 1 - Temporary table t6
INSERT IGNORE INTO `t6` (id) VALUES (28224)
INSERT IGNORE INTO `t6` (id) VALUES (28224)
Query Metrics
Query-Size:6Query-Depth:1
Errors and Warnings
NoneItem | Source is | Rarity is |
---|---|---|
"HEDGE-PIG" arrow | ||
"JACK-A-NAPE" bolt | ||
"JOLTHEAD" bolt | ||
"LEWDSTER" arrow | ||
"MAGGOT"-PIE bolt | ||
"MUMBLE-NEWS" arrow | ||
"OPEN SEASON" spear | Famous Last Words (2) , Famous Last Words (1) | |
"RETURN THIS" spear | Famous Last Words (2) , Famous Last Words (1) | |
"SEE MY POINT?" spear | Famous Last Words (2) , Famous Last Words (1) | |
"SHOVE OFF" spear | Famous Last Words (3) | |
"SKAINSMATE" arrow | ||
"SNERT" arrow | ||
"SNERT" spear | Famous Last Words (3) | |
"THAT'S MINE" spear | Famous Last Words (3) | |
"THIS WON'T HURT" spear | Famous Last Words (2) , Famous Last Words (1) | |
"TICKLE TICKLE" spear | Famous Last Words (3) | |
"TOE-LICKER" spear | Famous Last Words (3) | |
"VIPER-LICKER" bolt | ||
"WHIPSTER" bolt | ||
"WORM-HEAD" arrow | ||
"YOU WIN" arrow | ||
"YOU WIN" bolt | ||
Abalone-inlaid walnut crossbow | Zareen's Fortune (1) | |
Abassi (1) | Kilora's Weaponry | |
Acanth bank book with openwork carvings | Fenwyrthie's Curio Shop , Estate Holder gifts | |
Acanth wood arbalest carved with tiny vines | Ratchet Shack | |
Adder stamp | Stamped! | |
Adderwood broom with bound khor'vela bristles | Real Life Costume Contest 2013 , Pumpkin Contest 2013 | auction |
Adderwood latchbow set with serpent's heart rubies | Snake Pit | |
Adderwood log | Bare Necessities (4) | |
Adderwood plank | Bare Necessities (3) , Bare Necessities (2), Bare Necessities (1) | |
Adderwood shortbow shaped like twin serpents | Snake Pit | |
Adderwood-framed sieve of fine tyrium wires | Item:Dark serpentine-hide bag with a black gold adder clasp | auction |
Admiral's light crossbow crafted from smooth ebonwood | Item:Admiral's sailcloth backpack adorned with gleaming brass buttons , Curse of the Ghost Ship/End Loot, Item:Admiral's sailcloth backpack adorned with gleaming brass buttons | |
Adorably plump frog-shaped picnic basket | Tavern Troupe Performing Order/Gifts and prizes | |
Adze | Struan's Weapons and Armor, Struan's Weapons and Armor | |
Aged cherrywood humidor trimmed with a thin golden band | Dunshade: Echo of Tears/End loot | |
Aged iroko thigh quiver elaborately carved and set with pitch pearls | Hollow Eve Festival 410/Auction | |
Aged mistwood case | Just In Case (2) | |
Alabaster and khor'vela mask with a pyrope icesilk blindfold binding the eyes | Split Personalities (3) , Item:Red gold music box with its gilding flaking to reveal wood corrupted by bone bits | |
Albarco balalaika set with smoke rubies along the fretboard | Musiceum (3) , Hollow Eve Festival 417/Auction, Item:E'erdream instrument case set with two lotus flower sapphire clasps | |
Albatross stamp | Stamped! | |
Alchemist's canister painted with herbs | Yaks and Packs | |
Aldamalm violincello inlaid with strips of niello | Musiceum (3) | |
Aldamalm wood key | Item:Sweetheart's token box intricately carved from aldamalm wood with an openwork lid , Item:Suitor's token box intricately carved from aldamalm wood with an openwork lid, Limited Treasures (1) | |
Aldamalm-handled parasol made from turbaurs panels fringed with faesoul blossoms | Item:Rounded hen basket of pure white alerce splint-woven with aldamalm , Limited Treasures (1) | |
Alder carving case with a wild boar clasp of rust-red carnelian | Altared Visions | |
Alder gut-stringed shortbow with a cracked leather grip | Ogre deadeye | |
Alerce bangles dangling emerald pivuh charms | Hollow Eve Festival 417/Raffles | |
Alerce bellows with supple doeskin-wrapped handles | Which Craft (1) | festival |