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=5100)
)
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
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 | 70 | 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
A Life Of Fractals, A Million Heartbeats, A Quest for High Fidelity Activity Tracking, A Reversed Calendar, A Year of Diabetes Data, Arterial Stiffness, Blood Oxygen On Mt. Everest, Butterfly Project: Swimming Goggles To Measure Heart Rate, Connecting my Mind and Body, Data from my iPhone ECG, ECG and Activity Monitoring: What Can We Learn?, Effect of Ketogenic Diet On Heart Rate Variability, Every Heart Beat, Experience Sampling of My Stress, Finding The Optimal Training Zone, From April Zero to Gyroscope, Heart Rate Variability and Flow, How I Measured This Talk, How I Zapped My Brain With A 9v Battery To Overcome Analysis Paralysis, How My Life Automation System Quantifies My Life, Impact of work-related stress, Improving My Blood Pressure With Anaerobic Interval Training, Learning about Biases and Gaps in my Self-Collected Data, Lessons from a year of heart rate data, Lies, Damn Lies, and Correlations, Life in the Fast Lane: Learning from Vitals, Making Sense of My Bio-signals, Measuring Exhaustion and Readiness, Measuring the Moment, My Biological Rhythms In Sickness And In Health, My Life In 40 Variables, Online Activity Aggregation, Owning My Quantified Self Data, Parkinson's Tracking Update, Personal Comfort, Playing with my Breath, Putting Numbers to Sleep, QS Adventures with my Kids, QS Tools for Military Style Training, Quantifying Motivation with a Smart Shirt, Quantifying The Effects Of Microaggressions, Quantifying with Kids, Rhythmanalysis, Sensing Breath and Air, Stressing Out Loud, The Effects of a Year in Ketosis, Three Marathons On Zero Calories, Tinké: Monitoring Fitness Levels and Relaxation Indexes, Tracking Glucose As A Person Without Diabetes, Tracking My Sleep And Resting Heart Rate