Semantic search
Jump to navigation
Jump to search
Debug output SQLStore
ASK Query
[[Noun is::orlog]]
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
`smw_di_blob` AS t1 ON t0.smw_id=t1.s_id
WHERE
(
(t1.o_hash='orlog') AND t1.p_id=2021224)
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
`smw_object_ids` AS t0
INNER JOIN
`smw_di_blob` AS t1 ON t0.smw_id=t1.s_id
WHERE
(
(t1.o_hash='orlog') AND t1.p_id=2021224)
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 | t1 | ref | s_id, p_id, o_hash, s_id_2 | p_id | 262 | const, const | 28 | Using index condition; Using temporary; Using filesort | |
1 | SIMPLE | t0 | eq_ref | PRIMARY, smw_id, smw_iw, smw_iw_2 | PRIMARY | 4 | drwiki.t1.s_id | 1 | Using where |
Auxilliary Tables
No auxilliary tables used.Query Metrics
Query-Size:2Query-Depth:1
Errors and Warnings
NoneItem | Source is | Rare item | Is incomplete |
---|---|---|---|
Item:Bleached oak grandfather orlog | Perobler's Orlogs | true | |
Item:Brass orlog | Voi's Fine Heirlooms (2) , Voi's Fine Heirlooms (1), Perobler's Orlogs | true | |
Item:Crystal orlog showcasing shining star-kissed kertig clockwork | Item:Shadowbark tinkerer's box with a star-kissed kertig-lined keyhole , Hollow Eve Festival 443/Auction | true | |
Item:Dark walnut grandfather orlog | Perobler's Orlogs | true | |
Item:Dysfunctional green gold orlog displaying an intricate mass of gears | Smaller Side of Life (3) , Smaller Side of Life (2) | true | |
Item:Everdusk damite orlog | Item:Dark nightsilk pouch hung with a tiny everdusk damite orlog charm | true | |
Item:Forgeheart iron orlog | Item:Orange firesilk pouch hung with a tiny forgeheart iron orlog charm | true | |
Item:Glowing truegold orlog | Item:Metallic samite pouch hung with a tiny truegold orlog charm | true | |
Item:Glowing truegold orlog strung on a gleaming chain of dawnfire steel | Item:Canvas sack pinned with a truegold orlog , Aesthene's Close 441/Raffle | true | |
Item:Gold orlog | Voi's Fine Heirlooms (2) , Voi's Fine Heirlooms (1), Perobler's Orlogs | true | |
Item:Goldenglow glaes orlog | Tick Tock | true | |
Item:Goldenglow glaes orlog suspended from a fine silver chain | Tick Tock | true | |
Item:Honey oak grandfather orlog | Perobler's Orlogs | true | |
Item:Brass orlog | true | ||
Item:Gold orlog | true | ||
Item:Silver orlog | true | ||
Item:Kertig orlog | Tick Tock | true | |
Item:Kertig orlog suspended from a forged iron chain | Tick Tock | true | |
Item:Luminescent starshine orlog | Item:Sleek moonsilk pouch hung with a tiny luminescent starshine orlog charm | true | |
Item:Oceanic orichalcum orlog | Tick Tock | true | |
Item:Oceanic orichalcum orlog suspended from a braided kelpzyte chain | Tick Tock | true | |
Item:Scuffed and rusted brass orlog | Corroded Corner (2) , Corroded Corner (1) | true | |
Item:Silver orlog | Voi's Fine Heirlooms (2) , Voi's Fine Heirlooms (1), Perobler's Orlogs | true | |
Item:Silversteel orlog | Tick Tock | true | |
Item:Silversteel orlog suspended from a box-linked tyrium chain | Tick Tock | true | |
Item:Small ornamental orlog of polished silversteel | Aesthene's Close 441/Vault, Aesthene's Close 449/End Loot , Aesthene's Close 445/Vault | true | |
Item:Starshine orlog depicting a comical fire maiden wearing a grass tutu | Aesthene's Close 449/End Loot | true | |
Item:Unremarkable icesteel orlog | Smaller Side of Life (2) , Item:Plain unimportant-looking bag | true |