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, t4.o_sortkey
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
t4.o_sortkey 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, t4.o_sortkey
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
t4.o_sortkey 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_2 | 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- Boush, Tinker (BasisAngriffszeit: 1,7)
- Banehallow, Lycanthrope (BasisAngriffszeit: 1,7)
- Dazzle, Shadow Priest (BasisAngriffszeit: 1,7)
- Syllabear, Lone Druid (BasisAngriffszeit: 1,7)
- Tresdin, Legion Commander (BasisAngriffszeit: 1,7)
- Crixalis, Sand King (BasisAngriffszeit: 1,7)
- Thrall, Disruptor (BasisAngriffszeit: 1,7)
- Kardel Sharpeye, Dwarven Sniper (BasisAngriffszeit: 1,7)
- N'aix, Lifestealer (BasisAngriffszeit: 1,7)
- Zeus, Lord of Olympus (BasisAngriffszeit: 1,7)
- Kael, Invoker (BasisAngriffszeit: 1,7)
- Rexxar, Beastmaster (BasisAngriffszeit: 1,7)
- King Leoric, Skeleton King (BasisAngriffszeit: 1,7)
- Darchrow, Enigma (BasisAngriffszeit: 1,7)
- Lesale Deathbringer, Venomancer (BasisAngriffszeit: 1,7)
- Vol'Jin, Witch Doctor (BasisAngriffszeit: 1,7)
- Sven, Rogue Knight (BasisAngriffszeit: 1,7)
- Icarus, Phoenix (BasisAngriffszeit: 1,7)
- Knight Davion, Dragon Knight (BasisAngriffszeit: 1,7)
- Pudge, Butcher (BasisAngriffszeit: 1,7)
- Jin'zakk, Batrider (BasisAngriffszeit: 1,7)
- Clinkz, Bone Fletcher (BasisAngriffszeit: 1,7)
- Azgalor, Pit Lord (BasisAngriffszeit: 1,7)
- Furion, Prophet (BasisAngriffszeit: 1,7)
- Black Arachnia, Broodmother (BasisAngriffszeit: 1,7)
- Lina Inverse, Slayer (BasisAngriffszeit: 1,7)
- Rizzrak, Goblin Shredder (BasisAngriffszeit: 1,7)
- Leshrac the Malicious, Tormented Soul (BasisAngriffszeit: 1,7)
- Mogul Kahn, Axe (BasisAngriffszeit: 1,7)
- Eredar, Shadow Demon (BasisAngriffszeit: 1,7)
- Jah'rakal, Troll Warlord (BasisAngriffszeit: 1,7)
- Pugna, Oblivion (BasisAngriffszeit: 1,7)
- Aiushtha, Enchantress (BasisAngriffszeit: 1,7)
- Rattletrap, Clockwerk Goblin (BasisAngriffszeit: 1,7)
- Jakiro, Twin Head Dragon (BasisAngriffszeit: 1,7)
- Lucifer, Doom Bringer (BasisAngriffszeit: 1,7)
- Ezalor, Keeper of the Light (BasisAngriffszeit: 1,7)
- Magnus, Magnataur (BasisAngriffszeit: 1,7)
- Harbinger, Obsidian Destroyer (BasisAngriffszeit: 1,7)
- Slithice, Naga Siren (BasisAngriffszeit: 1,7)
- Rubick, Grand Magus (BasisAngriffszeit: 1,7)
- Slark, Murloc Nightcrawler (BasisAngriffszeit: 1,7)
- Lanaya, Templar Assassin (BasisAngriffszeit: 1,7)
- Darkterror, Faceless Void (BasisAngriffszeit: 1,7)
- Dirge, Undying (BasisAngriffszeit: 1,7)
- Tiny, Stone Giant (BasisAngriffszeit: 1,7)
- Mortred, Phantom Assassin (BasisAngriffszeit: 1,7)
- Auroth, the Winter Wyvern (BasisAngriffszeit: 1,7)
- Kel'Thuzad, Lich (BasisAngriffszeit: 1,7)
- Strygwyr, Bloodseeker (BasisAngriffszeit: 1,7)