Semantic search
SQLStore debug output
ASK Query
[[Medium::Rush Duel]] [[Card type::Spell Card]]
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 t2
INNER JOIN
`smw_di_wikipage` AS t4 ON t2.s_id=t4.s_id) ON t0.smw_id=t2.s_id
WHERE
(
(t2.o_hash='Rush Duel') AND t2.p_id='599'
AND (t4.p_id='596' AND t4.o_id='1329')
)
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 t2
INNER JOIN
`smw_di_wikipage` AS t4 ON t2.s_id=t4.s_id) ON t0.smw_id=t2.s_id
WHERE
(
(t2.o_hash='Rush Duel') AND t2.p_id='599'
AND (t4.p_id='596' AND t4.o_id='1329')
)
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 | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | t2 | ref | s_id,o_hash,s_id_2,p_id | o_hash | 258 | const | 2117 | Using index condition; Using where; Using temporary; Using filesort |
1 | SIMPLE | t0 | eq_ref | PRIMARY,smw_id,smw_iw,smw_iw_2 | PRIMARY | 4 | ygowiki.t2.s_id | 1 | Using where |
1 | SIMPLE | t4 | ref | s_id,o_id,p_id,s_id_2,s_id_3,o_id_2,o_id_3 | s_id_3 | 13 | ygowiki.t2.s_id,const,const | 1 | Using index; Distinct |
Auxilliary Tables
No auxilliary tables used.Query Metrics
Query-Size:4Query-Depth:1
Errors and Warnings
NoneName | Japanese name | [[Property]] |
---|---|---|
300 Light-Year Red Cloak | 300 | Normal Spell Card |
7 Shift | Normal Spell Card | |
Abyss Flash | アビス・フラッシュ | Normal Spell Card |
Abysskite Mapping | アビスカイト・マッピング | Normal Spell Card |
Abysskite Party | アビスカイト・パーティ | Normal Spell Card |
Abysskite Violate Halo | アビスカイト・ヴァイオレートヘイロー | Equip Spell Card |
Accelerator | Equip Spell Card | |
Advance Impact | アドバンス・インパクト | Normal Spell Card |
Against Buster | アゲインスト・バスター | Normal Spell Card |
Ancient Barrier | エンシェント・バリア | Normal Spell Card |
Ancient Rules | Normal Spell Card | |
Ancient Telescope | Normal Spell Card | |
Angel Judge | エンジェルジャッジ | Normal Spell Card |
Apocalypse - Beast Gear World | Field Spell Card | |
Apocalypse - Beast Over World | Field Spell Card | |
Apocalypse - Legend of the Warrior | Normal Spell Card | |
Apocalypse - The Unstoppable Beast-Warrior | Normal Spell Card | |
Aqua Boost | アクア・ブースト | Normal Spell Card |
Area 33 | エリア33 | Field Spell Card |
Armaments of Ascension | Equip Spell Card | |
Atrium's Wind | Normal Spell Card | |
Attribute Shift Bomb | Normal Spell Card | |
Aura Buster | オーラ・バスター | Equip Spell Card |
Auto Reverse | オートリバース | Normal Spell Card |
Autumn Leaves of Blisstopia | Field Spell Card | |
Avian Spell Tactics | Normal Spell Card | |
B.B.B. - Beast Brave Brandish | Normal Spell Card | |
Back Beat | バックビート | Normal Spell Card |
Back To The Fusion | バック・トゥ・ザ☆フュージョン | Normal Spell Card |
Barrage of Steel | Normal Spell Card | |
Beast Battlefield Barrier | Field Spell Card | |
Beast Swords - Tiger Sabre | Equip Spell Card | |
Berserker Colosseum | バーサーカーコロシアム | Field Spell Card |
Best Bite | ジャスト・ミート | Normal Spell Card |
Big Umi | Field Spell Card | |
Bizarrmor | Normal Spell Card | |
Black Luster Jersey Ritual | カオスのジャージ | Normal Spell Card |
Blades of Divine Wind | Normal Spell Card | |
Blaze Fiend Assault | Normal Spell Card | |
Blazing Chestnut | Normal Spell Card | |
Bleach Mortar | Normal Spell Card | |
Block Attack | 『 | Normal Spell Card |
Blue Medicine | ブルー・ポーション | Normal Spell Card |
Blue Tooth Reconnect | ブルー・トゥース・リコネクト | Normal Spell Card |
Bobble Header | ボブルヘッダー | Normal Spell Card |
Bonded Bowing | オジギプス | Normal Spell Card |
Bubble Kingdom | バブル・キングダム | Field Spell Card |
Bubbleburst Shock! | バブリーマン・ショック! | Normal Spell Card |
Burst Breath of Destruction | Normal Spell Card | |
Burst Stream of Destruction | Normal Spell Card |