Semantic search
Jump to navigation
Jump to search
Query-Depth:0
Debug output SQLStore
ASK Query
[[Category:Logs]] [[Category:Chapter 2, Act 2]]
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=6302)
)
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
`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=6302)
)
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 | t4 | ref | s_id, o_id, s_id_2, o_id_2 | o_id_2 | 5 | const | 304 | 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-11-29: Seeking The Root Of The Problem
- 2019-12-02: A Last Gasp
- 2019-12-03: Icy Sielje
- 2019-12-04: Salvage Your Past
- 2019-12-11: A Crimson Bride-to-be
- 2019-12-12: Lunata Croze, Fifth Matriarch of the Bonne Contractors
- 2019-12-12: You Will Shine Brightly One Day
- 2019-12-14: First Impressions
- 2019-12-15: I Still Have Something to Tell You
- 2019-12-17: Asleep and Drowning
- 2019-12-17: The Great and Powerful.. Who?
- 2019-12-20: Atop A Cold Cold Mountain
- 2019-12-22: A Party for Ghosts
- 2019-12-22: Like A Natural
- 2019-12-22: Young ARMS and the Case of the Missing Canine
- 2019-12-29: Asset
- 2020-01-02: Leisure Time is Leisure Time
- 2020-01-09: It Is In Our Nature
- 2020-01-10: The Privilege Of Spiritual Sight
- 2020-01-11: The Devil vs the Dragon
- 2020-01-12: V. Vuong's Lectures in Advanced Geology: The Under Traffic Walking Tour
- 2020-01-13: Icy Truth
- 2020-01-14: Wyvern Worries and the Codex's Call
- 2020-01-15: Her Fertile Craft
- 2020-01-17: Wolves on a Train
- 2020-01-18: To All the Fools Still Left
- 2020-01-18: Wolves on a Boat
- 2020-01-21: Absolute Cucco
- 2020-01-22: A Place of Respite (and Party)
- 2020-01-22: About That Kiss
- 2020-01-23: We Are What We Must
- 2020-01-24: The Unbeatable Love We Share
- 2020-01-25: Managing Expectations
- 2020-01-25: The Lifeweaver Beckons
- 2020-01-26: Unworthy
- 2020-01-27: Channelers of Light
- 2020-01-28: The Fabled 'Hanging Out' Activity
- 2020-01-28: What My Values Are
- 2020-02-01: Call It An Opportunity
- 2020-02-01: One Wild Party
- 2020-02-02: Warms the Heart
- 2020-02-07: Deja Coo
- 2020-02-07: My Core Essence
- 2020-02-09: Start from Level One
- 2020-02-09: They Grow Up So Fast
- 2020-02-11: Not the Robot Bees!
- 2020-02-14: Of Changes and Decisions
- 2020-02-14: The Hazards To Truth
- 2020-02-15: In A Green Space
- 2020-02-15: So Long To Return