Semantic search
Jump to navigation
Jump to search
Query-Depth:0
Debug output SQLStore
ASK Query
[[Category:Logs]] [[Category:Chapter 2, Act 1]]
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
`wiki_smw_object_ids` AS t0
INNER JOIN
(`wiki_smw_fpt_inst` AS t2
INNER JOIN
`wiki_smw_fpt_inst` AS t4 ON t2.s_id=t4.s_id) ON t0.smw_id=t2.s_id
WHERE
(t2.o_id=3750
AND (t4.o_id=4871)
)
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
`wiki_smw_object_ids` AS t0
INNER JOIN
(`wiki_smw_fpt_inst` AS t2
INNER JOIN
`wiki_smw_fpt_inst` AS t4 ON t2.s_id=t4.s_id) ON t0.smw_id=t2.s_id
WHERE
(t2.o_id=3750
AND (t4.o_id=4871)
)
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 | t4 | ref | s_id, o_id, s_id_2, o_id_2 | o_id_2 | 5 | const | 418 | Using index; Using temporary; Using filesort | |
1 | SIMPLE | t2 | ref | s_id, o_id, s_id_2, o_id_2 | s_id_2 | 9 | dc_wiki.t4.s_id, const | 1 | Using index | |
1 | SIMPLE | t0 | eq_ref | PRIMARY, smw_id, smw_iw, smw_iw_2 | PRIMARY | 4 | dc_wiki.t4.s_id | 1 | Using where |
Auxilliary Tables
No auxilliary tables used.Query Metrics
Query-Size:2Query-Depth:0
Errors and Warnings
None- 2019-03-20: A Dragonmaster Cannot Live on Fish Alone
- 2019-03-23: Spira-ted Away
- 2019-03-23: What's Up, Spira? We Brought You a New Religion
- 2019-03-24: Dealing With Spira
- 2019-03-24: Making Talia Cry
- 2019-03-24: This Is Spira
- 2019-03-27: ARMing Up With the Alias Queen
- 2019-03-27: Declassified Secrets
- 2019-03-27: I Want You to Hit Me as Hard as You Can
- 2019-03-27: Personal Monster
- 2019-03-27: Questions and Chocobos
- 2019-03-28: Waylaid At Besaid
- 2019-03-29: Kindness Singularity
- 2019-03-29: Luca Out, Watch Where You're Going
- 2019-03-29: What Is Love
- 2019-03-30: Friendship Denied!
- 2019-03-31: I Wish I Were A Bird
- 2019-03-31: Touchdown in a Strange Land
- 2019-04-01: Interview with the Vampire
- 2019-04-02: As Subtle As A Sledgehammer
- 2019-04-02: Forbidden Al-Bhed Machina 'Kotatsu'
- 2019-04-04: An Ocean More Vast Than Any Other
- 2019-04-04: Rude Awakening
- 2019-04-04: To Be Crimson is Noble
- 2019-04-04: Trailblazing
- 2019-04-05: Welcome to the Space Jam
- 2019-04-06: A Little Light Heresy
- 2019-04-06: Being O'aka Is Suffering
- 2019-04-06: Drifter's Logic
- 2019-04-06: Queen Anastasia Sends Her Regards
- 2019-04-07: Friendly Fire (and Flowers)
- 2019-04-07: Stories for the Children
- 2019-04-08: Chance Meeting by the Moonflow
- 2019-04-08: The Lunies and the Maester
- 2019-04-08: Trust Just Wasn't in the Cards
- 2019-04-08: Whose Choice?
- 2019-04-09: The Pyres that Fly
- 2019-04-10: Lessons in Sin
- 2019-04-11: A Million Memories
- 2019-04-11: Love Hurts So Much
- 2019-04-11: Ties Deeper Than Blood and Time
- 2019-04-12: Birds Of a Roc's Feather Kind Of Have To Be Duct Taped Together
- 2019-04-12: Family Reunion
- 2019-04-12: Sorcery Consultation
- 2019-04-13: Nightroad Hijinks
- 2019-04-14: I'll Walk into the Sun
- 2019-04-14: So Much Can Happen in 6 Months
- 2019-04-14: The Runner
- 2019-04-15: Hard Losses and Hard Truths
- 2019-04-15: I Accept The Yevon