Semantic search
Jump to navigation
Jump to search
Debug output SQLStore
ASK Query
[[Uses symbol::lightning||lightning bolt]]OR[[Uses material::Lightning||Lightning bolt]]
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
25
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
25
OFFSET
10
SQL Explain
ID | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | t1 | ALL | PRIMARY | 423 | 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='lightning') OR (t2.o_hash='lightning bolt'))
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 (67850)
INSERT IGNORE INTO `t6` (id) VALUES (21372)
Query Metrics
Query-Size:6Query-Depth:1
Errors and Warnings
NoneItem | Source is | Rare item |
---|---|---|
Armor:Golden suit of lamellar plate engraved with a figure hurling lightning from its hands | ||
Armor:Night-black jousting plate streaked with bolts of lightning | ||
Armor:Pair of white leather gloves embroidered along the cuffs with yellow lightning bolts | ||
Armor:Pair of white platemail gauntlets set with a small disc | ||
Armor:Pair of white-tinted mail gloves set with a small disc | ||
Armor:Shining golden suit of plate armor engraved with webwork patterns of lightning bolts | ||
Armor:Sturdy seordmaor-hide leathers embossed with a pattern of cascading lightning bolts | ||
Armor:Suit of finely woven golden battle mesh | ||
Armor:Suit of golden plate-reinforced mail engraved with forked lightning bolts | ||
Armor:White balaclava with yellow tinted links that form a lightning bolt | ||
Armor:White field plate armor set with a disc on the chest | ||
Armor:White helm engraved with lightning bolts around the crown | ||
Armor:White leather hood embroidered with yellow lightning bolts | ||
Armor:White leathers embroidered with yellow lightning bolts | ||
Armor:White suede tunic lined with chainmail | ||
Item:Articulated gold bracer studded with cambrinth lightning bolts | War and Craft (2) , War and Craft (1) | |
Item:Atulave amulet carved with jagged lightning bolts | Harawep Shrine 425 , Harawep Shrine 421 | |
Armor:Aubergine helm flanked by lurid green lightning bolts | Shiny's Shinies (2) , In Shining Armor | |
Item:Battered metal charm bracelet engraved with lightning bolts | Ghostly Galleria of Spiritual Souvenirs (2) , Ghostly Galleria of Spiritual Souvenirs (1) | |
Weapon:Battle axe engraved with lightning bolts | Hollow Eve Festival 410/Raffles |