Created
October 7, 2010 00:56
-
-
Save palexander/614374 to your computer and use it in GitHub Desktop.
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| [palexand@ncboprod-ridb2 mysql_data]$ sudo mysqldumpslow -a -s c -t 50 /var/lib/mysql/mysql_data/slowlog | |
| Reading mysql slow query log from /var/lib/mysql/mysql_data/slowlog | |
| Count: 18 Time=14.34s (258s) Lock=0.00s (0s) Rows=1.0 (18), ri-api[ri-api]@ncbostage-obr1.Stanford.EDU | |
| SELECT COUNT(*) FROM obr_rxrd_aggregation IT, obr_rxrd_element ET, obs_concept AS T1 WHERE IT.element_id=ET.id AND IT.concept_id=T1.id AND T1.local_concept_id IN ('42789/108369006', '42838/Neoplasm') | |
| Count: 11 Time=639.36s (7032s) Lock=0.00s (0s) Rows=1.0 (11), ri-api[ri-api]@ncbostage-obr1.Stanford.EDU | |
| SELECT COUNT(*) FROM obr_aers_aggregation IT, obr_aers_element ET, obs_concept AS T1 WHERE IT.element_id=ET.id AND IT.concept_id=T1.id AND T1.local_concept_id='40397/T25' | |
| Count: 10 Time=556.78s (5567s) Lock=0.00s (0s) Rows=1.0 (10), ri-api[ri-api]@ncbostage-obr1.Stanford.EDU | |
| SELECT ET.local_element_id, T1.local_concept_id, IT.score FROM obr_aers_aggregation IT, obr_aers_element ET, obs_concept AS T1 WHERE IT.element_id=ET.id AND IT.concept_id=T1.id AND T1.local_concept_id='4525/Phenomenon' ORDER BY IT.score DESC LIMIT 0,10 | |
| Count: 8 Time=35.60s (284s) Lock=0.00s (0s) Rows=1.0 (8), ri-api[ri-api]@ncbostage-obr1.Stanford.EDU | |
| SELECT COUNT(*) FROM obr_rxrd_aggregation IT, obr_rxrd_element ET, obs_concept AS T1 WHERE IT.element_id=ET.id AND IT.concept_id=T1.id AND T1.local_concept_id='42789/370115009' | |
| Count: 8 Time=21.56s (172s) Lock=0.00s (0s) Rows=0.0 (0), ri-api[ri-api]@ncbostage-obr1.Stanford.EDU | |
| SELECT COUNT(*) FROM obr_aers_aggregation IT, obr_aers_element ET, obs_concept AS T1 WHERE IT.element_id=ET.id AND IT.concept_id=T1.id AND T1.local_concept_id='4525/Phenomenon' | |
| Count: 8 Time=25.62s (204s) Lock=0.00s (0s) Rows=1.0 (8), ri-api[ri-api]@ncbostage-obr1.Stanford.EDU | |
| SELECT COUNT(*) FROM obr_ae_aggregation IT, obr_ae_element ET, obs_concept AS T1 WHERE IT.element_id=ET.id AND IT.concept_id=T1.id AND T1.local_concept_id='42789/370115009' | |
| Count: 8 Time=47.47s (379s) Lock=0.00s (0s) Rows=1.0 (8), ri-api[ri-api]@ncbostage-obr1.Stanford.EDU | |
| SELECT COUNT(*) FROM obr_ct_aggregation IT, obr_ct_element ET, obs_concept AS T1 WHERE IT.element_id=ET.id AND IT.concept_id=T1.id AND T1.local_concept_id='42789/370115009' | |
| Count: 8 Time=27.06s (216s) Lock=0.00s (0s) Rows=1.0 (8), ri-api[ri-api]@ncbostage-obr1.Stanford.EDU | |
| SELECT COUNT(*) FROM obr_geo_aggregation IT, obr_geo_element ET, obs_concept AS T1 WHERE IT.element_id=ET.id AND IT.concept_id=T1.id AND T1.local_concept_id='42789/370115009' | |
| Count: 7 Time=532.13s (3724s) Lock=0.00s (0s) Rows=1.0 (7), ri-api[ri-api]@ncbostage-obr1.Stanford.EDU | |
| SELECT COUNT(*) FROM obr_aers_aggregation IT, obr_aers_element ET, obs_concept AS T1 WHERE IT.element_id=ET.id AND IT.concept_id=T1.id AND T1.local_concept_id='42789/370115009' | |
| Count: 6 Time=345.43s (2072s) Lock=0.00s (0s) Rows=10.0 (60), ri-api[ri-api]@ncbostage-obr1.Stanford.EDU | |
| SELECT ET.local_element_id, T1.local_concept_id, IT.score FROM obr_aers_aggregation IT, obr_aers_element ET, obs_concept AS T1 WHERE IT.element_id=ET.id AND IT.concept_id=T1.id AND T1.local_concept_id='40397/T25' ORDER BY IT.score DESC LIMIT 0,10 | |
| Count: 6 Time=97.89s (587s) Lock=0.00s (0s) Rows=10.0 (60), ri-api[ri-api]@ncbostage-obr1.Stanford.EDU | |
| SELECT ET.local_element_id, T1.local_concept_id, IT.score FROM obr_pcm_aggregation IT, obr_pcm_element ET, obs_concept AS T1 WHERE IT.element_id=ET.id AND IT.concept_id=T1.id AND T1.local_concept_id='4525/Phenomenon' ORDER BY IT.score DESC LIMIT 0,10 | |
| Count: 6 Time=359.37s (2156s) Lock=0.00s (0s) Rows=10.0 (60), ri-api[ri-api]@ncbostage-obr1.Stanford.EDU | |
| SELECT ET.local_element_id, T1.local_concept_id, IT.score FROM obr_ct_aggregation IT, obr_ct_element ET, obs_concept AS T1 WHERE IT.element_id=ET.id AND IT.concept_id=T1.id AND T1.local_concept_id='40397/T25' ORDER BY IT.score DESC LIMIT 0,10 | |
| Count: 6 Time=42.54s (255s) Lock=0.02s (0s) Rows=10.0 (60), ri-api[ri-api]@ncbostage-obr1.Stanford.EDU | |
| SELECT ET.local_element_id, T1.local_concept_id as local_concept_id, CXT.name, T2.local_concept_id as mapped_local_concept_id, MAPT.mapping_type, EAT.position_from, EAT.position_to, IT.score FROM obr_ct_map_annotation EAT, obr_ct_element ET, obs_concept AS T1, obs_concept AS T2, obr_context CXT , obr_ct_aggregation IT, obs_mapping_type MAPT WHERE EAT.element_id= ET.id AND EAT.concept_id= T1.id AND EAT.context_id= CXT.id AND EAT.mapped_concept_id= T2.id AND EAT.element_id= IT.element_id AND EAT.concept_id=IT.concept_id AND EAT.mapping_type=MAPT.id AND T1.local_concept_id='42693/Melanoma' ORDER BY IT.score DESC LIMIT 0, 10 | |
| Count: 6 Time=71.22s (427s) Lock=0.00s (0s) Rows=1.0 (6), ri-api[ri-api]@ncbostage-obr1.Stanford.EDU | |
| SELECT COUNT(*) FROM obr_rxrd_aggregation IT, obr_rxrd_element ET, obs_concept AS T1 WHERE IT.element_id=ET.id AND IT.concept_id=T1.id AND T1.local_concept_id='40397/T25' | |
| Count: 5 Time=11.80s (58s) Lock=0.00s (0s) Rows=10.0 (50), ri-api[ri-api]@ncbostage-obr1.Stanford.EDU | |
| SELECT ET.local_element_id, T1.local_concept_id, IT.score FROM obr_bsm_aggregation IT, obr_bsm_element ET, obs_concept AS T1 WHERE IT.element_id=ET.id AND IT.concept_id=T1.id AND T1.local_concept_id='4525/Phenomenon' ORDER BY IT.score DESC LIMIT 0,10 | |
| Count: 5 Time=57.65s (288s) Lock=0.00s (0s) Rows=1.0 (5), ri-api[ri-api]@ncbostage-obr1.Stanford.EDU | |
| SELECT COUNT(*) FROM obr_rxrd_aggregation IT, obr_rxrd_element ET, obs_concept AS T1 WHERE IT.element_id=ET.id AND IT.concept_id=T1.id AND T1.local_concept_id='4525/Phenomenon' | |
| Count: 5 Time=448.65s (2243s) Lock=0.00s (0s) Rows=10.0 (50), ri-api[ri-api]@ncbostage-obr1.Stanford.EDU | |
| SELECT ET.local_element_id, T1.local_concept_id, IT.score FROM obr_rxrd_aggregation IT, obr_rxrd_element ET, obs_concept AS T1 WHERE IT.element_id=ET.id AND IT.concept_id=T1.id AND T1.local_concept_id='4525/Phenomenon' ORDER BY IT.score DESC LIMIT 0,10 | |
| Count: 5 Time=75.30s (376s) Lock=0.00s (0s) Rows=1.0 (5), ri-api[ri-api]@ncbostage-obr1.Stanford.EDU | |
| SELECT COUNT(*) FROM obr_ct_aggregation IT, obr_ct_element ET, obs_concept AS T1 WHERE IT.element_id=ET.id AND IT.concept_id=T1.id AND T1.local_concept_id='42295/X77oL' | |
| Count: 5 Time=2212.96s (11064s) Lock=0.00s (0s) Rows=1.0 (5), ri-api[ri-api]@ncbostage-obr1.Stanford.EDU | |
| SELECT COUNT(*) FROM obr_aers_aggregation IT, obr_aers_element ET, obs_concept AS T1 WHERE IT.element_id=ET.id AND IT.concept_id=T1.id AND T1.local_concept_id='42295/X77oL' | |
| Count: 5 Time=200.84s (1004s) Lock=0.00s (0s) Rows=1.0 (5), ri-api[ri-api]@ncbostage-obr1.Stanford.EDU | |
| SELECT COUNT(*) FROM obr_ct_aggregation IT, obr_ct_element ET, obs_concept AS T1 WHERE IT.element_id=ET.id AND IT.concept_id=T1.id AND T1.local_concept_id='40397/T25' | |
| Count: 5 Time=84.29s (421s) Lock=0.00s (0s) Rows=10.0 (50), ri-api[ri-api]@ncbostage-obr1.Stanford.EDU | |
| SELECT ET.local_element_id, T1.local_concept_id, IT.score FROM obr_smd_aggregation IT, obr_smd_element ET, obs_concept AS T1 WHERE IT.element_id=ET.id AND IT.concept_id=T1.id AND T1.local_concept_id='4525/Phenomenon' ORDER BY IT.score DESC LIMIT 0,10 | |
| Count: 5 Time=70.14s (350s) Lock=0.04s (0s) Rows=10.0 (50), ri-api[ri-api]@ncbostage-obr1.Stanford.EDU | |
| SELECT ET.local_element_id, T1.local_concept_id as local_concept_id, CXT.name, T2.local_concept_id as mapped_local_concept_id, MAPT.mapping_type, EAT.position_from, EAT.position_to, IT.score FROM obr_aers_map_annotation EAT, obr_aers_element ET, obs_concept AS T1, obs_concept AS T2, obr_context CXT , obr_aers_aggregation IT, obs_mapping_type MAPT WHERE EAT.element_id= ET.id AND EAT.concept_id= T1.id AND EAT.context_id= CXT.id AND EAT.mapped_concept_id= T2.id AND EAT.element_id= IT.element_id AND EAT.concept_id=IT.concept_id AND EAT.mapping_type=MAPT.id AND T1.local_concept_id='42693/Melanoma' ORDER BY IT.score DESC LIMIT 0, 10 | |
| Count: 5 Time=261.07s (1305s) Lock=0.00s (0s) Rows=0.0 (0), dbsync[dbsync]@localhost | |
| FLUSH TABLES WITH READ LOCK | |
| Count: 5 Time=124.17s (620s) Lock=0.02s (0s) Rows=10.0 (50), ri-api[ri-api]@ncbostage-obr1.Stanford.EDU | |
| SELECT ET.local_element_id, T1.local_concept_id, CXT.name, DAT.term_id, TT.name, DAT.position_from, DAT.position_to, IT.score FROM obr_ct_annotation DAT, obr_ct_element ET, obs_concept AS T1, obs_term TT, obr_context CXT, obr_ct_aggregation IT WHERE DAT.element_id=ET.id AND DAT.concept_id=T1.id AND DAT.term_id=TT.id AND DAT.context_id= CXT.id AND DAT.element_id=IT.element_id AND DAT.concept_id=IT.concept_id AND TT.name REGEXP '[^0-9]+' AND T1.local_concept_id IN ('42693/Melanoma') ORDER BY score DESC LIMIT 0, 10 | |
| Count: 4 Time=82.82s (331s) Lock=0.00s (0s) Rows=0.0 (0), ri-api[ri-api]@ncbostage-obr1.Stanford.EDU | |
| SELECT CXT.name, COUNT(EAT.concept_id) FROM obr_geo_map_annotation EAT, obr_geo_element ET, obs_concept AS T1, obs_concept AS T2, obr_context CXT , obr_geo_aggregation IT, obs_mapping_type MAPT WHERE EAT.element_id= ET.id AND EAT.concept_id= T1.id AND EAT.context_id= CXT.id AND EAT.mapped_concept_id= T2.id AND EAT.element_id= IT.element_id AND EAT.concept_id=IT.concept_id AND EAT.mapping_type=MAPT.id AND T1.local_concept_id IN ('39966/Skin', '42693/Melanoma') AND ET.id IN (SELECT DISTINCT IT1.element_id FROM obr_geo_map_annotation AS IT1, obs_concept AS CT1, obr_geo_map_annotation AS IT2, obs_concept AS CT2 WHERE IT1.element_id=IT2.element_id AND IT1.concept_id=CT1.id AND CT1.local_concept_id='39966/Skin' AND IT2.concept_id=CT2.id AND CT2.local_concept_id='42693/Melanoma') GROUP BY CXT.name | |
| Count: 4 Time=451.55s (1806s) Lock=0.00s (0s) Rows=2.5 (10), ri-api[ri-api]@ncbostage-obr1.Stanford.EDU | |
| SELECT ET.local_element_id, T1.local_concept_id as local_concept_id, CXT.name, T2.local_concept_id as mapped_local_concept_id, MAPT.mapping_type, EAT.position_from, EAT.position_to, IT.score FROM obr_geo_map_annotation EAT, obr_geo_element ET, obs_concept AS T1, obs_concept AS T2, obr_context CXT , obr_geo_aggregation IT, obs_mapping_type MAPT WHERE EAT.element_id= ET.id AND EAT.concept_id= T1.id AND EAT.context_id= CXT.id AND EAT.mapped_concept_id= T2.id AND EAT.element_id= IT.element_id AND EAT.concept_id=IT.concept_id AND EAT.mapping_type=MAPT.id AND T1.local_concept_id IN ('39966/Skin', '42693/Melanoma') AND ET.id IN (SELECT DISTINCT IT1.element_id FROM obr_geo_map_annotation AS IT1, obs_concept AS CT1, obr_geo_map_annotation AS IT2, obs_concept AS CT2 WHERE IT1.element_id=IT2.element_id AND IT1.concept_id=CT1.id AND CT1.local_concept_id='39966/Skin' AND IT2.concept_id=CT2.id AND CT2.local_concept_id='42693/Melanoma') ORDER BY IT.score DESC LIMIT 0, 10 | |
| Count: 4 Time=23.14s (92s) Lock=0.01s (0s) Rows=10.0 (40), ri-api[ri-api]@ncbostage-obr1.Stanford.EDU | |
| SELECT ET.local_element_id, T1.local_concept_id, CXT.name, DAT.term_id, TT.name, DAT.position_from, DAT.position_to, IT.score FROM obr_ae_annotation DAT, obr_ae_element ET, obs_concept AS T1, obs_term TT, obr_context CXT, obr_ae_aggregation IT WHERE DAT.element_id=ET.id AND DAT.concept_id=T1.id AND DAT.term_id=TT.id AND DAT.context_id= CXT.id AND DAT.element_id=IT.element_id AND DAT.concept_id=IT.concept_id AND ET.local_element_id='E-GEOD-9118' ORDER BY IT.score DESC LIMIT 0,10 | |
| Count: 4 Time=97.14s (388s) Lock=0.03s (0s) Rows=7.5 (30), ri-api[ri-api]@ncbostage-obr1.Stanford.EDU | |
| SELECT ET.local_element_id, T1.local_concept_id, CXT.name, DAT.term_id, TT.name, DAT.position_from, DAT.position_to, IT.score FROM obr_aers_annotation DAT, obr_aers_element ET, obs_concept AS T1, obs_term TT, obr_context CXT, obr_aers_aggregation IT WHERE DAT.element_id=ET.id AND DAT.concept_id=T1.id AND DAT.term_id=TT.id AND DAT.context_id= CXT.id AND DAT.element_id=IT.element_id AND DAT.concept_id=IT.concept_id AND TT.name REGEXP '[^0-9]+' AND T1.local_concept_id IN ('42693/Melanoma') ORDER BY score DESC LIMIT 0, 10 | |
| Count: 4 Time=43.40s (173s) Lock=0.00s (0s) Rows=1.0 (4), ri-api[ri-api]@ncbostage-obr1.Stanford.EDU | |
| SELECT COUNT(*) FROM obr_aers_aggregation IT, obr_aers_element ET, obs_concept AS T1 WHERE IT.element_id=ET.id AND IT.concept_id=T1.id AND T1.local_concept_id='29684/birnlex_406' | |
| Count: 3 Time=420.40s (1261s) Lock=0.00s (0s) Rows=1.0 (3), ri-api[ri-api]@ncbostage-obr1.Stanford.EDU | |
| SELECT COUNT(*) FROM obr_aers_aggregation IT, obr_aers_element ET, obs_concept AS T1 WHERE IT.element_id=ET.id AND IT.concept_id=T1.id AND T1.local_concept_id='42693/Melanoma' | |
| Count: 3 Time=26.29s (78s) Lock=0.00s (0s) Rows=100.0 (300), ri-api[ri-api]@ncbostage-obr1.Stanford.EDU | |
| SELECT ET.local_element_id, T1.local_concept_id, IT.score FROM obr_ae_aggregation IT, obr_ae_element ET, obs_concept AS T1 WHERE IT.element_id=ET.id AND IT.concept_id=T1.id AND ET.local_element_id='E-GEOD-7368' ORDER BY IT.score DESC LIMIT 0,100 | |
| Count: 3 Time=55.67s (167s) Lock=0.00s (0s) Rows=10.0 (30), ri-api[ri-api]@ncbostage-obr1.Stanford.EDU | |
| SELECT ET.local_element_id, T1.local_concept_id, IT.score FROM obr_rxrd_aggregation IT, obr_rxrd_element ET, obs_concept AS T1 WHERE IT.element_id=ET.id AND IT.concept_id=T1.id AND T1.local_concept_id='38802/NCBITaxon:1' ORDER BY IT.score DESC LIMIT 0,10 | |
| Count: 3 Time=14.13s (42s) Lock=0.00s (0s) Rows=100.0 (300), ri-api[ri-api]@ncbostage-obr1.Stanford.EDU | |
| SELECT ET.local_element_id, T1.local_concept_id, IT.score FROM obr_rxrd_aggregation IT, obr_rxrd_element ET, obs_concept AS T1 WHERE IT.element_id=ET.id AND IT.concept_id=T1.id AND T1.local_concept_id IN ('42789/108369006', '42838/Neoplasm') ORDER BY IT.score DESC LIMIT 0, 100 | |
| Count: 3 Time=163.60s (490s) Lock=0.00s (0s) Rows=10.0 (30), ri-api[ri-api]@ncbostage-obr1.Stanford.EDU | |
| SELECT ET.local_element_id, T1.local_concept_id, IT.score FROM obr_cdd_aggregation IT, obr_cdd_element ET, obs_concept AS T1 WHERE IT.element_id=ET.id AND IT.concept_id=T1.id AND T1.local_concept_id='4525/Phenomenon' ORDER BY IT.score DESC LIMIT 0,10 | |
| Count: 3 Time=136.57s (409s) Lock=0.00s (0s) Rows=0.0 (0), ri-api[ri-api]@DNab4120b2.Stanford.EDU | |
| SELECT DISTINCT IT1.element_id | |
| FROM obr_geo_map_annotation AS IT1, obs_concept AS CT1, obr_geo_map_annotation AS IT2, obs_concept AS CT2, obr_geo_map_annotation AS IT3, obs_concept AS CT3, obr_geo_map_annotation AS IT4, obs_concept AS CT4 | |
| WHERE IT1.element_id=IT2.element_id | |
| AND IT2.element_id=IT3.element_id | |
| AND IT3.element_id=IT4.element_id | |
| AND IT1.concept_id=CT1.id | |
| AND CT1.local_concept_id='13342/FBsp:00000004' | |
| AND IT2.concept_id=CT2.id | |
| AND CT2.local_concept_id='29684/birnlex_516' | |
| AND IT3.concept_id=CT3.id | |
| AND CT3.local_concept_id='13352/EHDAA:1' | |
| AND IT4.concept_id=CT4.id | |
| AND CT4.local_concept_id='39544/Homo_sapiens' | |
| Count: 3 Time=45.63s (136s) Lock=0.00s (0s) Rows=1.0 (3), ri-api[ri-api]@ncbostage-obr1.Stanford.EDU | |
| SELECT COUNT(*) FROM obr_aers_aggregation IT, obr_aers_element ET, obs_concept AS T1 WHERE IT.element_id=ET.id AND IT.concept_id=T1.id AND T1.local_concept_id='39927/DOID:162' | |
| Count: 3 Time=307.21s (921s) Lock=0.00s (0s) Rows=0.0 (0), ri-api[ri-api]@ncbostage-obr1.Stanford.EDU | |
| SELECT CXT.name, COUNT(EAT.concept_id) FROM obr_geo_map_annotation EAT, obr_geo_element ET, obs_concept AS T1, obs_concept AS T2, obr_context CXT , obr_geo_aggregation IT, obs_mapping_type MAPT WHERE EAT.element_id= ET.id AND EAT.concept_id= T1.id AND EAT.context_id= CXT.id AND EAT.mapped_concept_id= T2.id AND EAT.element_id= IT.element_id AND EAT.concept_id=IT.concept_id AND EAT.mapping_type=MAPT.id AND T1.local_concept_id IN ('39966/Skin', '42693/Melanoma', '42693/Keratosis', '39966/Cell') AND ET.id IN (SELECT IT1.element_id FROM obr_geo_map_annotation AS IT1, obs_concept AS CT1, obr_geo_map_annotation AS IT2, obs_concept AS CT2, obr_geo_map_annotation AS IT3, obs_concept AS CT3, obr_geo_map_annotation AS IT4, obs_concept AS CT4 WHERE IT1.element_id=IT2.element_id AND IT2.element_id=IT3.element_id AND IT3.element_id=IT4.element_id AND IT1.concept_id=CT1.id AND CT1.local_concept_id='39966/Skin' AND IT2.concept_id=CT2.id AND CT2.local_concept_id='42693/Melanoma' AND IT3.concept_id=CT3.id AND CT3.local_concept_id='42693/Keratosis' AND IT4.concept_id=CT4.id AND CT4.local_concept_id='39966/Cell') GROUP BY CXT.name | |
| Count: 3 Time=38.03s (114s) Lock=0.00s (0s) Rows=10.0 (30), ri-api[ri-api]@ncbostage-obr1.Stanford.EDU | |
| SELECT ET.local_element_id, T1.local_concept_id, IT.score FROM obr_rxrd_aggregation IT, obr_rxrd_element ET, obs_concept AS T1 WHERE IT.element_id=ET.id AND IT.concept_id=T1.id AND T1.local_concept_id='40397/T25' ORDER BY IT.score DESC LIMIT 0,10 | |
| Count: 3 Time=23.11s (69s) Lock=0.00s (0s) Rows=33.3 (100), ri-api[ri-api]@DNab4120b4.Stanford.EDU | |
| select * from `resource_index`.`obr_canano_element` limit 0, 50 | |
| Count: 3 Time=17.23s (51s) Lock=0.00s (0s) Rows=1.0 (3), ri-api[ri-api]@ncbostage-obr1.Stanford.EDU | |
| SELECT COUNT(*) FROM obr_geo_aggregation IT, obr_geo_element ET, obs_concept AS T1 WHERE IT.element_id=ET.id AND IT.concept_id=T1.id AND T1.local_concept_id IN ('42693/Neoplasm', '4525/Melanoma') AND ET.id IN (SELECT DISTINCT IT1.element_id FROM obr_geo_aggregation AS IT1, obs_concept AS CT1, obr_geo_aggregation AS IT2, obs_concept AS CT2 WHERE IT1.element_id=IT2.element_id AND IT1.concept_id=CT1.id AND CT1.local_concept_id='42693/Neoplasm' AND IT2.concept_id=CT2.id AND CT2.local_concept_id='4525/Melanoma') | |
| Count: 3 Time=28.05s (84s) Lock=0.00s (0s) Rows=10.0 (30), ri-api[ri-api]@ncbostage-obr1.Stanford.EDU | |
| SELECT ET.local_element_id, T1.local_concept_id, IT.score FROM obr_ct_aggregation IT, obr_ct_element ET, obs_concept AS T1 WHERE IT.element_id=ET.id AND IT.concept_id=T1.id AND T1.local_concept_id='38802/NCBITaxon:1' ORDER BY IT.score DESC LIMIT 0,10 | |
| Count: 3 Time=336.70s (1010s) Lock=5.48s (16s) Rows=100.0 (300), ri-api[ri-api]@ncbostage-obr1.Stanford.EDU | |
| SELECT ET.local_element_id, T1.local_concept_id, CXT.name, DAT.term_id, TT.name, DAT.position_from, DAT.position_to, IT.score FROM obr_geo_annotation DAT, obr_geo_element ET, obs_concept AS T1, obs_term TT, obr_context CXT, obr_geo_aggregation IT WHERE DAT.element_id=ET.id AND DAT.concept_id=T1.id AND DAT.term_id=TT.id AND DAT.context_id= CXT.id AND DAT.element_id=IT.element_id AND DAT.concept_id=IT.concept_id AND TT.name REGEXP '[^0-9]+' AND T1.local_concept_id IN ('42693/Melanoma') ORDER BY score DESC LIMIT 0, 100 | |
| Count: 3 Time=32.01s (96s) Lock=0.00s (0s) Rows=10.0 (30), ri-api[ri-api]@ncbostage-obr1.Stanford.EDU | |
| SELECT ET.local_element_id, T1.local_concept_id, IT.score FROM obr_ct_aggregation IT, obr_ct_element ET, obs_concept AS T1 WHERE IT.element_id=ET.id AND IT.concept_id=T1.id AND T1.local_concept_id='42693/Melanoma' ORDER BY IT.score DESC LIMIT 0,10 | |
| Count: 3 Time=135.26s (405s) Lock=0.00s (0s) Rows=10.0 (30), ri-api[ri-api]@ncbostage-obr1.Stanford.EDU | |
| SELECT ET.local_element_id, T1.local_concept_id, IT.score FROM obr_aers_aggregation IT, obr_aers_element ET, obs_concept AS T1 WHERE IT.element_id=ET.id AND IT.concept_id=T1.id AND T1.local_concept_id='38802/NCBITaxon:1' ORDER BY IT.score DESC LIMIT 0,10 | |
| Count: 3 Time=59.96s (179s) Lock=0.00s (0s) Rows=10.0 (30), ri-api[ri-api]@ncbostage-obr1.Stanford.EDU | |
| SELECT ET.local_element_id, T1.local_concept_id, IT.score FROM obr_cdd_aggregation IT, obr_cdd_element ET, obs_concept AS T1 WHERE IT.element_id=ET.id AND IT.concept_id=T1.id AND T1.local_concept_id='42693/Melanoma' ORDER BY IT.score DESC LIMIT 0,10 | |
| Count: 3 Time=58.14s (174s) Lock=0.00s (0s) Rows=1.0 (3), ri-api[ri-api]@ncbostage-obr1.Stanford.EDU | |
| SELECT ET.local_element_id, T1.local_concept_id, IT.score FROM obr_ct_aggregation IT, obr_ct_element ET, obs_concept AS T1 WHERE IT.element_id=ET.id AND IT.concept_id=T1.id AND T1.local_concept_id IN ('39966/Skin', '13356/EHDA:7501', '40398/MTHU012006', '40643/BTO:0001253', '3093/MFO:0003200', '40398/MTHU008281', '40724/UBERON:0002097', '40398/MTHU000083', '13352/EHDAA:6530', '13356/EHDA:8740', '40393/S', '40400/LP76007-1', '42838/Skin', '40245/MAT:0000284', '40400/MTHU001414', '44169/EFO_0000962', '13356/EHDA:6531', '42295/7N7..', '42142/D012867', '40400/LP36760-4', '13356/EHDA:9922', '40958/XAO:0000023', '42837/PMA_701', '42571/MA:0000151', '42545/10531:SKN', '39927/FMA:7163', '40726/Skin') ORDER BY IT.score DESC LIMIT 0, 1 | |
| Count: 3 Time=79.76s (239s) Lock=0.08s (0s) Rows=10.0 (30), ri-api[ri-api]@ncbostage-obr1.Stanford.EDU | |
| SELECT ET.local_element_id, T1.local_concept_id, CXT.name, DAT.term_id, TT.name, DAT.position_from, DAT.position_to, IT.score FROM obr_rxrd_annotation DAT, obr_rxrd_element ET, obs_concept AS T1, obs_term TT, obr_context CXT, obr_rxrd_aggregation IT WHERE DAT.element_id=ET.id AND DAT.concept_id=T1.id AND DAT.term_id=TT.id AND DAT.context_id= CXT.id AND DAT.element_id=IT.element_id AND DAT.concept_id=IT.concept_id AND TT.name REGEXP '[^0-9]+' AND T1.local_concept_id IN ('42693/Melanoma') ORDER BY score DESC LIMIT 0, 10 | |
| Count: 3 Time=12.83s (38s) Lock=0.02s (0s) Rows=50.0 (150), ri-api[ri-api]@ncbostage-obr1.Stanford.EDU | |
| SELECT ET.local_element_id, T1.local_concept_id, CXT.name, DAT.term_id, TT.name, DAT.position_from, DAT.position_to, IT.score FROM obr_ae_annotation DAT, obr_ae_element ET, obs_concept AS T1, obs_term TT, obr_context CXT, obr_ae_aggregation IT WHERE DAT.element_id=ET.id AND DAT.concept_id=T1.id AND DAT.term_id=TT.id AND DAT.context_id= CXT.id AND DAT.element_id=IT.element_id AND DAT.concept_id=IT.concept_id AND TT.name REGEXP '[^0-9]+' AND ET.local_element_id='E-FPMI-5' ORDER BY IT.score DESC LIMIT 0, 50 | |
| Count: 3 Time=33.62s (100s) Lock=0.01s (0s) Rows=10.0 (30), ri-api[ri-api]@ncbostage-obr1.Stanford.EDU | |
| SELECT ET.local_element_id, T1.local_concept_id as local_concept_id, CXT.name, T2.local_concept_id as mapped_local_concept_id, MAPT.mapping_type, EAT.position_from, EAT.position_to, IT.score FROM obr_rxrd_map_annotation EAT, obr_rxrd_element ET, obs_concept AS T1, obs_concept AS T2, obr_context CXT , obr_rxrd_aggregation IT, obs_mapping_type MAPT WHERE EAT.element_id= ET.id AND EAT.concept_id= T1.id AND EAT.context_id= CXT.id AND EAT.mapped_concept_id= T2.id AND EAT.element_id= IT.element_id AND EAT.concept_id=IT.concept_id AND EAT.mapping_type=MAPT.id AND T1.local_concept_id='42693/Melanoma' ORDER BY IT.score DESC LIMIT 0, 10 |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment