Semantic search
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_wikipage` AS t4 ON t2.s_id=t4.s_id) ON t0.smw_id=t2.s_id
WHERE
(
(t4.p_id=564 AND t4.o_id=699)
)
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
ID | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | t4 | ref | s_id, o_id, p_id, s_id_2, s_id_3, o_id_2, o_id_3 | o_id_3 | 9 | const, const | 90 | Using temporary; Using filesort | |
1 | SIMPLE | t2 | ref | s_id, o_id, s_id_2, o_id_2 | s_id_2 | 4 | mediawiki.t4.s_id | 1 | Using where; Using index | |
1 | SIMPLE | t3 | eq_ref | PRIMARY | PRIMARY | 4 | mediawiki.t2.o_id | 1 | ||
1 | SIMPLE | t0 | eq_ref | PRIMARY, smw_id, smw_iw, smw_iw_2 | PRIMARY | 4 | mediawiki.t4.s_id | 1 | Using where |
- Temporary table t3
Recursively computed hierarchy for element(s) (978).
SELECT s_id FROM `smw_fpt_subc` WHERE o_id=978 LIMIT 1
Query-Depth:1
Parkinson's Tracking Update, Playing with my Breath, Psychological Self-Monitoring for the Military, Putting Numbers to Sleep, QS Tools for Military Style Training, Quantified Brain and Music for Self-Tuning, Quantified Self for Preventative Care, Quantified/Unquantified, Quantifying My Mental and Experiential State, Quantifying The Effects Of Microaggressions, Quantifying the Emotional Self, Re-Living My Life with Mood Tracking, Reverse Mood Tracking, Rhythmanalysis, Science, Smell, Fashion, Self Tracking Awareness and Change, SenseOS, Sleep As A Galaxy, Sub-Perceptual Psilocybin Dosing, Technology for Mindfulness, The Coffee Experiment, The Effects of a Year in Ketosis, The Human Face of Big Data, Tracking After A Stroke: Doctors, Dogs, And All The Rest, Tracking Baby Milestones: Surprising Results Of Bringing Data To Parenting, Tracking Happiness, Tracking Media Consumption, Tracking What I Do Versus What I Say I'll Do, Tracking with Zenobase, Tracking your brain on booze, Boozerlyzer, Unobtrusive Smart Environments for Monitoring in Everyday Life, Visualizing Physiological Data, We Never Fight on Wednesday, What I'm Learning From My Meditation App, What If My Life Was The Economy Of A Small Country?, Why I Weighed My Whiskers, Words for Mood Measurement