Semantic search
Jump to navigation
Jump to search
Debug output SQLStore
ASK Query
[[Uses symbol::glaysker flower||glaysker blossom||glaysker]]OR[[Uses material::Glaysker flower||Glaysker blossom||Glaysker]]
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
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
`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
0
SQL Explain
ID | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | t1 | ALL | PRIMARY | 91 | 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='glaysker flower') OR (t2.o_hash='glaysker blossom') OR (t2.o_hash='glaysker'))
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 (34092)
INSERT IGNORE INTO `t6` (id) VALUES (34092)
INSERT IGNORE INTO `t6` (id) VALUES (34092)
Query Metrics
Query-Size:8Query-Depth:1
Errors and Warnings
NoneItem | Rare item |
---|---|
Item:Anlora-avtoma teapot bejeweled with saffron topaz globemallow blossoms | |
Armor:Black leather gauntlets with bronze charms sewn into the cuffs | |
Template:BEFlowers | |
Armor:Black leather gauntlets with bronze charms sewn into the cuffs | |
Item:Black spidersilk robe intricately embroidered with an assortment of flowering plants | |
Breaking and Entering/Rooms and Loot/Material options | |
Weapon:Broadsword with a glaysker flower handguard | |
Item:Cheese-stuffed glayskers | |
Weapon:Clerical collar set with a glaysker-pink tab | true |
Item:Cobalt silk gown embroidered with gold rings along the hem | |
Item:Cobalt silk slippers embroidered with purple and white glaysker flowers | |
Item:Dainty comb carved with blossoms | |
Item:Dainty glaysker flower haircomb set with ruby chips | |
Item:Dark purple glaysker | |
Item:Dark suede duffel bag with thick leather straps | |
Item:Decorative paper cutout blossoms | true |
Item:Decorative paper cutout garlands | true |
Item:Deep green jade engraved with a graceful glaysker flower | |
Item:Delicate gold-link bracelet with a diamond dusted glaysker charm | |
Item:Delicate gold-link bracelet with a diamond-dusted glaysker charm | true |
Item:Delicate gold-link necklace with three dangling glaysker charms | true |
Item:Delicate sandalwood fan dangling a ruby glaysker flower charm | |
Item:Diaphanous silk dance veil adorned with blossoms | |
Item:Eraser in the shape of a blossom | |
Weapon:Etched briquet marked with a simple blossom | |
Item:Etched snow quartz mixing stick | true |
Item:Exquisite haircomb twined in blossoms | |
Item:Festive Lorethew tart in a sweet glaysker glaze | |
Item:Filigree earrings threaded with beads | |
Item:Fluffy kitchen towel delicately embroidered with blossoms | |
Item:Fluted glass vase filled with blooms | |
Item:Fluttery skirt with a glittery gauze overlay | |
Item:Fragile blossom with delicate petals | true |
Item:Gaethzen blossom with a short stem | false |
Item:Gardening apron embroidered with blossoms | |
Item:Glaysker flower | |
Item:Glaysker flower circlet | |
Item:Golden mail belt with dangling gold flowers | |
Item:Graceful fan painted with swirling blossoms | |
Template:HE2020Flowers | |
Item:Hammered toe bells in the shape of blossoms | true |
Item:Hand-tooled contract case adorned with a diamond flower | |
Talk:Hollow Eve Festival 436/Game prizes | |
Hollow Eve Festival 436/Game prizes/Material options | |
Item:Black spidersilk robe intricately embroidered with an assortment of flowering plants | |
Item:Cobalt silk gown embroidered with gold rings along the hem | |
Item:Cobalt silk slippers embroidered with purple and white glaysker flowers | |
Item:Dainty glaysker flower haircomb set with ruby chips | |
Item:Deep green jade engraved with a graceful glaysker flower | |
Item:Delicate gold-link bracelet with a diamond dusted glaysker charm |