Semantic search
From FANTOM5_SSTAR
Debug output SQLStore
ASK Query
[[Ancestors in anatomy facet::UBERON:0001062]]
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:0001062') 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
10
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:0001062') 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
10
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 | 2401 | 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
NoneHuman (Homo sapiens)
- 10011-101C2 (bladder, adult, pool1)
- 10012-101C3 (brain, adult, pool1)
- 10013-101C4 (cervix, adult, pool1)
- 10014-101C5 (colon, adult, pool1)
- 10015-101C6 (esophagus, adult, pool1)
- 10016-101C7 (heart, adult, pool1)
- 10017-101C8 (kidney, adult, pool1)
- 10018-101C9 (liver, adult, pool1)
- 10019-101D1 (lung, adult, pool1)
- 10020-101D2 (ovary, adult, pool1)
- 10021-101D3 (placenta, adult, pool1)
- 10022-101D4 (prostate, adult, pool1)
- 10023-101D5 (skeletal muscle, adult, pool1)
- 10024-101D6 (small intestine, adult, pool1)
- 10025-101D7 (spleen, adult, pool1)
- 10026-101D8 (testis, adult, pool1)
- 10027-101D9 (thymus, adult, pool1)
- 10028-101E1 (thyroid, adult, pool1)
- 10029-101E2 (trachea, adult, pool1)
- 10030-101E3 (retina, adult, pool1)
- 10031-101E4 (temporal lobe, adult, pool1)
- 10032-101E5 (postcentral gyrus, adult, pool1)
- 10033-101E6 (pons, adult, pool1)
- 10034-101E7 (parietal lobe, adult, pool1)
- 10035-101E8 (paracentral gyrus, adult, pool1)
- 10036-101E9 (occipital pole, adult, pool1)
- 10037-101F1 (nucleus accumbens, adult, pool1)
- 10038-101F2 (medulla oblongata, adult, pool1)
- 10039-101F3 (insula, adult, pool1)
- 10040-101F4 (frontal lobe, adult, pool1)
- 10041-101F5 (dura mater, adult, donor1)
- 10042-101F6 (corpus callosum, adult, pool1)
- 10043-101F7 (thymus, fetal, pool1)
- 10044-101F8 (spleen, fetal, pool1)
- 10045-101F9 (kidney, fetal, pool1)
- 10046-101G1 (heart, fetal, pool1)
- 10047-101G2 (tonsil, adult, pool1)
- 10048-101G3 (smooth muscle, adult, pool1)
- 10049-101G4 (pancreas, adult, donor1)
- 10050-101G5 (heart, adult, diseased post-infarction, donor1)
- 10051-101G6 (heart, adult, diseased, donor1)
- 10052-101G7 (aorta, adult, pool1)
- 10053-101G8 (blood, adult, pool1)
- 10054-101G9 (eye, fetal, donor1)
- 10055-101H1 (uterus, fetal, donor1)
- 10056-101H2 (spinal cord, fetal, donor1)
- 10057-101H3 (umbilical cord, fetal, donor1)
- 10058-101H4 (trachea, fetal, donor1)
- 10059-101H5 (tongue, fetal, donor1)
- 10060-101H6 (thyroid, fetal, donor1)