Semantic search
From FANTOM5_SSTAR
Debug output SQLStore
ASK Query
[[Ancestors in anatomy facet::UBERON:0000480]]
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
`smw_object_ids` AS t0
INNER JOIN
`smw_di_blob` AS t1 ON t0.smw_id=t1.s_id
WHERE
(
(t1.o_hash='UBERON:0000480') AND t1.p_id=687)
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
260
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_di_blob` AS t1 ON t0.smw_id=t1.s_id
WHERE
(
(t1.o_hash='UBERON:0000480') AND t1.p_id=687)
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
260
SQL Explain
ID | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | t1 | ref | s_id, o_hash, s_id_2, p_id | p_id | 262 | const, const | 1765 | 100.00 | Using index condition; Using temporary; Using filesort |
1 | SIMPLE | t0 | eq_ref | PRIMARY, smw_id, smw_iw, smw_iw_2 | PRIMARY | 4 | resource_browser.t1.s_id | 1 | 50.00 | Using where |
Auxilliary Tables
No auxilliary tables used.Query Metrics
Query-Size:2Query-Depth:1
Errors and Warnings
NoneMouse (Mus musculus)
- 10323-105A8
- 10324-105A9
- 10325-105B1
- 10326-105B2
- 10327-105B3
- 10328-105B4
- 10329-105B5
- 10331-105B7
- 10332-105B8
- 10333-105B9
- 10334-105C1
- 10335-105C2
- 10336-105C3
- 10337-105C4
- 10338-105C5
- 10339-105C6
- 10340-105C7
- 10341-105C8
- 10342-105C9
- 10343-105D1
- 10344-105D2
- 10345-105D3
- 10346-105D4
- 10347-105D5
- 10349-105D7 (visual cortex - wildtype)
- 1035-18D5 (stomach, embryo E17)
- 10350-105D8 (visual cortex - Mecp knockout)
- 10352-105E1 (medial frontal gyrus, newborn, donor10223)
- 10353-105E2 (medial temporal gyrus, newborn, donor10223)
- 10354-105E3 (caudate nucleus, newborn, donor10223)
- 10355-105E4 (occipital cortex, newborn, donor10223)
- 10356-105E5 (parietal lobe, newborn, donor10223)
- 10357-105E6 (cerebellum, newborn, donor10223)
- 10358-105E7 (substantia nigra, newborn, donor10223)
- 10359-105E8 (spinal cord, newborn, donor10223)
- 10360-105E9 (amygdala, newborn, donor10223)
- 10361-105F1 (medulla oblongata, newborn, donor10223)
- 10362-105F2 (locus coeruleus, newborn, donor10223)
- 10363-105F3 (hippocampus, newborn, donor10223)
- 10364-105F4 (globus pallidus, newborn, donor10223)
- 10365-105F5 (putamen, newborn, donor10223)
- 10366-105F6 (thalamus, newborn, donor10223)
- 10367-105F7 (globus pallidus, adult, donor10258)
- 10368-105F8 (medial frontal gyrus, adult, donor10258)
- 10369-105F9 (spinal cord, adult, donor10258)
- 10370-105G1 (thalamus, adult, donor10258)
- 10371-105G2 (substantia nigra, adult, donor10258)
- 10372-105G3 (putamen, adult, donor10258)
- 10373-105G4 (parietal cortex, adult, donor10258)
- 10374-105G5 (hippocampus, adult, donor10258)