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=695)
)
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 | 95 | 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
Owning My Quantified Self Data, Parkinson's Tracking Update, Project Faster: Tracking to Improve Cycling Performance, Putting My Blood Metrics in Context, QS Adventures with my Kids, QS Tools for Military Style Training, Quantifying with Kids, Rhythmanalysis, Running Cold - Does it Burn More Calories?, Running Storytelling, Salt & Carb, Setting Goals And Holding Myself To Account, Sleep As A Galaxy, Smartphone Disengagement, Tales of Weight Tracking, The Dashboard Of My Life, The Effects of a Year in Ketosis, The Weight of Things Lost, Three Marathons On Zero Calories, Tinké: Monitoring Fitness Levels and Relaxation Indexes, To Teach Quantified Self, First Know Thyself, Tracking After A Stroke: Doctors, Dogs, And All The Rest, Tracking Baby Milestones: Surprising Results Of Bringing Data To Parenting, Tracking Media Consumption, Tracking Pregnancy and Baby Growth, Tracking my Son's Diabetes, Tracking with Zenobase, Understanding Fitness With Muscle Activation Data, Understanding My Blood Glucose, Unobtrusive Smart Environments for Monitoring in Everyday Life, Using Genetics to Come Back From Injury, Using Running And Cycling Data To Inform My Fashion, Using Self Tracking to Exercise More Efficiently, VO2Max (Show and Tell Talk), Weight and exercise tracking with the Hacker Diet, What Causes My Heart Rhythm Disorder, What If My Life Was The Economy Of A Small Country?