Semantische Suche
Aus DotAWiki
Zur Navigation springenZur Suche springenDebug output SQLStore
ASK Query
[[Kategorie:Helden]] [[BasisAngriffszeit::+]]
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_fpt_inst` AS t2
INNER JOIN
`t3` AS t3 ON t2.o_id=t3.id
INNER JOIN
`smw_di_number` AS t4 ON t2.s_id=t4.s_id) ON t0.smw_id=t2.s_id
WHERE
(
(t4.p_id=522)
)
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
50
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_fpt_inst` AS t2
INNER JOIN
`t3` AS t3 ON t2.o_id=t3.id
INNER JOIN
`smw_di_number` AS t4 ON t2.s_id=t4.s_id) ON t0.smw_id=t2.s_id
WHERE
(
(t4.p_id=522)
)
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
50
SQL Explain
ID | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | t3 | ALL | PRIMARY | 4 | Using temporary; Using filesort | ||||
1 | SIMPLE | t2 | ref | s_id, o_id, s_id_2, o_id_2 | o_id_2 | 5 | db_dswiki.t3.id | 13 | Using index | |
1 | SIMPLE | t4 | ref | s_id, p_id, p_id_2, s_id_2 | s_id | 8 | db_dswiki.t2.s_id, const | 1 | Using index | |
1 | SIMPLE | t0 | eq_ref | PRIMARY, smw_id, smw_iw, smw_iw_2 | PRIMARY | 4 | db_dswiki.t2.s_id | 1 | Using where |
Auxilliary Tables
- Temporary table t3
Recursively computed hierarchy for element(s) (635).
SELECT s_id FROM `smw_fpt_subc` WHERE o_id=635 LIMIT 1
Query Metrics
Query-Size:2Query-Depth:1
Errors and Warnings
None- Lesale Deathbringer, Venomancer (BasisAngriffszeit: 1,7)
- Leshrac the Malicious, Tormented Soul (BasisAngriffszeit: 1,7)
- Leviathan, Tidehunter (BasisAngriffszeit: 1,7)
- Lina Inverse, Slayer (BasisAngriffszeit: 1,7)
- Lion, Demon Witch (BasisAngriffszeit: 1,7)
- Lucifer, Doom Bringer (BasisAngriffszeit: 1,7)
- Luna Moonfang, Moon Rider (BasisAngriffszeit: 1,7)
- Magina, Anti-Mage (BasisAngriffszeit: 1,45)
- Magnus, Magnataur (BasisAngriffszeit: 1,7)
- Mangix, Pandaren Brewmaster (BasisAngriffszeit: 1,7)
- Medusa, Gorgon (BasisAngriffszeit: 1,7)
- Meepo, Geomancer (BasisAngriffszeit: 1,7)
- Mercurial, Spectre (BasisAngriffszeit: 1,7)
- Mirana Nightshade, Priestess of the Moon (BasisAngriffszeit: 1,7)
- Mogul Kahn, Axe (BasisAngriffszeit: 1,7)
- Morphling (BasisAngriffszeit: 1,6)
- Mortred, Phantom Assassin (BasisAngriffszeit: 1,7)
- N'aix, Lifestealer (BasisAngriffszeit: 1,7)
- Nerif, Oracle (BasisAngriffszeit: 1,4)
- Nessaj, Chaos Knight (BasisAngriffszeit: 1,7)
- Nevermore, Shadow Fiend (BasisAngriffszeit: 1,7)
- Nortrom, Silencer (BasisAngriffszeit: 1,7)
- Puck, Faerie Dragon (BasisAngriffszeit: 1,7)
- Pudge, Butcher (BasisAngriffszeit: 1,7)
- Pugna, Oblivion (BasisAngriffszeit: 1,7)
- Purist Thunderwrath, Omniknight (BasisAngriffszeit: 1,7)
- Raigor Stonehoof, Earthshaker (BasisAngriffszeit: 1,7)
- Raijin Thunderkeg, Storm Spirit (BasisAngriffszeit: 1,7)
- Rattletrap, Clockwerk Goblin (BasisAngriffszeit: 1,7)
- Razor, Lightning Revenant (BasisAngriffszeit: 1,7)
- Razzil Darkbrew, Alchemist (BasisAngriffszeit: 1,7)
- Rexxar, Beastmaster (BasisAngriffszeit: 1,7)
- Rhasta, Shadow Shaman (BasisAngriffszeit: 1,7)
- Rigwarl, Bristleback (BasisAngriffszeit: 1,7)
- Rikimaru, Stealth Assassin (BasisAngriffszeit: 1,7)
- Rizzrak, Goblin Shredder (BasisAngriffszeit: 1,7)
- Rooftrellen, Treant Protector (BasisAngriffszeit: 1,9)
- Rotund'jere, Necrolyte (BasisAngriffszeit: 1,7)
- Rubick, Grand Magus (BasisAngriffszeit: 1,7)
- Rylai Crestfall, Crystal Maiden (BasisAngriffszeit: 1,7)
- Shendelzare Silkwood, Vengeful Spirit (BasisAngriffszeit: 1,7)
- Slardar, Slithereen Guard (BasisAngriffszeit: 1,7)
- Slark, Murloc Nightcrawler (BasisAngriffszeit: 1,7)
- Slithice, Naga Siren (BasisAngriffszeit: 1,7)
- Squee Spleen and Spoon, Goblin Techies (BasisAngriffszeit: 1,7)
- Strygwyr, Bloodseeker (BasisAngriffszeit: 1,7)
- Sven, Rogue Knight (BasisAngriffszeit: 1,7)
- Syllabear, Lone Druid (BasisAngriffszeit: 1,7)
- Terrorblade, Soul Keeper (BasisAngriffszeit: 1,5)
- Thrall, Disruptor (BasisAngriffszeit: 1,7)