Created
October 7, 2010 00:54
-
-
Save palexander/614371 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 -t 50 /var/lib/mysql/mysql_data/slowlog | |
| Reading mysql slow query log from /var/lib/mysql/mysql_data/slowlog | |
| Count: 1 Time=15434.30s (15434s) Lock=0.00s (0s) Rows=0.0 (0), 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_canano_annotation DAT, obr_canano_element ET, obs_concept AS T1, obs_term TT, obr_context CXT, obr_canano_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 ('42785/npo:NPO_518', '40402/C7764222590860') AND ET.id IN (SELECT DISTINCT IT1.element_id FROM obr_canano_annotation AS IT1, obs_concept AS CT1, obr_canano_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='42785/npo:NPO_518' AND IT2.concept_id=CT2.id AND CT2.local_concept_id='40402/C7764222590860') ORDER BY score DESC LIMIT 0, 100 | |
| Count: 1 Time=8946.59s (8946s) Lock=0.00s (0s) Rows=1.0 (1), 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 IN ('40397/T25', '42298/MALIG') AND ET.id IN (SELECT DISTINCT IT1.element_id FROM obr_aers_aggregation AS IT1, obs_concept AS CT1, obr_aers_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='40397/T25' AND IT2.concept_id=CT2.id AND CT2.local_concept_id='42298/MALIG') | |
| Count: 1 Time=6365.73s (6365s) Lock=0.00s (0s) Rows=0.0 (0), 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', '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') ORDER BY IT.score DESC LIMIT 0, 10 | |
| Count: 1 Time=4546.06s (4546s) Lock=0.00s (0s) Rows=1.0 (1), 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 IN ('39331/TGMA:0000218', '40397/T25', '42280/10003553') | |
| Count: 1 Time=4407.76s (4407s) Lock=0.00s (0s) Rows=1.0 (1), 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 ('39331/TGMA:0000218', '42280/10003553') | |
| Count: 1 Time=4370.55s (4370s) Lock=0.00s (0s) Rows=1.0 (1), 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 IN ('42142/D011506', '42295/H33z.') | |
| Count: 1 Time=3991.26s (3991s) Lock=0.00s (0s) Rows=1.0 (1), 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 ('42142/D011506', '42295/H33z.') | |
| Count: 1 Time=3543.24s (3543s) Lock=0.00s (0s) Rows=10.0 (10), 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='42483/activity:Activity' ORDER BY IT.score DESC LIMIT 0,10 | |
| Count: 1 Time=3521.64s (3521s) Lock=0.00s (0s) Rows=1.0 (1), 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 ('39331/TGMA:0000218', '40397/T25', '42280/10003553') | |
| Count: 1 Time=3016.87s (3016s) Lock=0.00s (0s) Rows=1.0 (1), 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='38801/Treatment' | |
| Count: 1 Time=2938.69s (2938s) Lock=0.00s (0s) Rows=1.0 (1), 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 IN ('42142/D011506', '42295/H33z.') | |
| Count: 1 Time=2810.82s (2810s) Lock=0.00s (0s) Rows=1.0 (1), 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 ('42280/10011224', '42280/10003553') | |
| Count: 1 Time=2804.14s (2804s) Lock=0.00s (0s) Rows=1.0 (1), 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 IN ('40397/T25', '42298/MALIG') AND ET.id IN (SELECT DISTINCT IT1.element_id FROM obr_ct_aggregation AS IT1, obs_concept AS CT1, obr_ct_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='40397/T25' AND IT2.concept_id=CT2.id AND CT2.local_concept_id='42298/MALIG') | |
| Count: 1 Time=2785.77s (2785s) Lock=0.03s (0s) Rows=10.0 (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_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='40397/T25' ORDER BY IT.score DESC LIMIT 0, 10 | |
| Count: 1 Time=2742.45s (2742s) Lock=0.00s (0s) Rows=0.0 (0), ri-api[ri-api]@ncbostage-obr1.Stanford.EDU | |
| INSERT INTO resource_index_log.obr_service_log_stage (date_accessed, ip_address, request_url, http_method, application_id, email, local_ontology_ids, virtual_ontology_ids, virtual, local_semantic_type_ids, level_max, mapping_types, filter_number, min_term_size, with_synonyms, additional_stop_words, stop_words_case_senstive, local_concept_ids, local_element_id, resource_id, obr_service_log_stage.mode, with_context, elementDetails, counts, obr_service_log_stage.from, number, obr_service_log_stage.format) VALUES ('2010-07-15 11:40:51', '171.67.213.40' ,'/', 'POST', null, null, '40397', '1347', 0, null ,0, null, 0 ,0, 0, null, 0, '40397/T25,', null, 'GM', 'UNION' ,0, 0, 1, 0, 0, 'xml') | |
| Count: 2 Time=2735.85s (5471s) Lock=0.00s (0s) Rows=10.0 (20), 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 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: 1 Time=2675.68s (2675s) Lock=0.00s (0s) Rows=1.0 (1), 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/Melanoma' | |
| Count: 2 Time=2631.86s (5263s) Lock=0.00s (0s) Rows=2.0 (4), 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 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: 1 Time=2562.32s (2562s) Lock=0.00s (0s) Rows=1.0 (1), 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 ('40397/T25', '42298/MALIG') AND ET.id IN (SELECT DISTINCT IT1.element_id FROM obr_rxrd_aggregation AS IT1, obs_concept AS CT1, obr_rxrd_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='40397/T25' AND IT2.concept_id=CT2.id AND CT2.local_concept_id='42298/MALIG') | |
| Count: 1 Time=2411.75s (2411s) Lock=0.00s (0s) Rows=1.0 (1), 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='38801/Treatment' | |
| Count: 1 Time=2322.89s (2322s) Lock=0.05s (0s) Rows=10.0 (10), 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 ('40397/T25') ORDER BY score DESC LIMIT 0, 10 | |
| Count: 1 Time=2253.63s (2253s) Lock=0.00s (0s) Rows=10.0 (10), 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 10,10 | |
| 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: 1 Time=2186.91s (2186s) Lock=0.00s (0s) Rows=1.0 (1), ri-api[ri-api]@ncbostage-obr1.Stanford.EDU | |
| SELECT COUNT(*) 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 IN ('42142/D011506', '42295/H33z.') | |
| Count: 1 Time=2165.01s (2165s) Lock=0.00s (0s) Rows=1.0 (1), 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 IN ('42280/10011224', '42280/10003553') | |
| Count: 1 Time=1985.23s (1985s) Lock=0.00s (0s) Rows=1.0 (1), 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 IN ('42142/D011506', '42295/H33z.') | |
| Count: 1 Time=1969.58s (1969s) Lock=0.00s (0s) Rows=1.0 (1), 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 IN ('42280/10011224', '42280/10003553') | |
| Count: 1 Time=1875.18s (1875s) Lock=0.00s (0s) Rows=1.0 (1), 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 IN ('42280/10007050', '40400/LP7106-0', '40399/CDR0000041060', '40397/T25', '42693/Conceptual_Entities', '40400/MTHU010328', '40400/LP74584-1') AND ET.id IN (SELECT DISTINCT IT1.element_id FROM obr_aers_aggregation AS IT1, obs_concept AS CT1, obr_aers_aggregation AS IT2, obs_concept AS CT2, obr_aers_aggregation AS IT3, obs_concept AS CT3, obr_aers_aggregation AS IT4, obs_concept AS CT4, obr_aers_aggregation AS IT5, obs_concept AS CT5, obr_aers_aggregation AS IT6, obs_concept AS CT6, obr_aers_aggregation AS IT7, obs_concept AS CT7 WHERE IT1.element_id=IT2.element_id AND IT2.element_id=IT3.element_id AND IT3.element_id=IT4.element_id AND IT4.element_id=IT5.element_id AND IT5.element_id=IT6.element_id AND IT6.element_id=IT7.element_id AND IT1.concept_id=CT1.id AND CT1.local_concept_id='42280/10007050' AND IT2.concept_id=CT2.id AND CT2.local_concept_id='40400/LP7106-0' AND IT3.concept_id=CT3.id AND CT3.local_concept_id='40399/CDR0000041060' AND IT4.concept_id=CT4.id AND CT4.local_concept_id='40397/T25' AND IT5.concept_id=CT5.id AND CT5.local_concept_id='42693/Conceptual_Entities' AND IT6.concept_id=CT6.id AND CT6.local_concept_id='40400/MTHU010328' AND IT7.concept_id=CT7.id AND CT7.local_concept_id='40400/LP74584-1') | |
| Count: 1 Time=1845.63s (1845s) Lock=0.00s (0s) Rows=1.0 (1), ri-api[ri-api]@ncbostage-obr1.Stanford.EDU | |
| SELECT COUNT(*) 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 IN ('42280/10011224', '42280/10003553') | |
| Count: 1 Time=1723.09s (1723s) Lock=0.00s (0s) Rows=1.0 (1), ri-api[ri-api]@ncbostage-obr1.Stanford.EDU | |
| SELECT COUNT(*) FROM obr_omim_aggregation IT, obr_omim_element ET, obs_concept AS T1 WHERE IT.element_id=ET.id AND IT.concept_id=T1.id AND T1.local_concept_id IN ('42142/D011506', '42295/H33z.') | |
| Count: 1 Time=1716.72s (1716s) Lock=0.00s (0s) Rows=1.0 (1), 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='38801/Treatment' | |
| Count: 1 Time=1698.00s (1697s) Lock=0.00s (0s) Rows=1.0 (1), ri-api[ri-api]@ncbostage-obr1.Stanford.EDU | |
| SELECT COUNT(*) FROM obr_upkb_aggregation IT, obr_upkb_element ET, obs_concept AS T1 WHERE IT.element_id=ET.id AND IT.concept_id=T1.id AND T1.local_concept_id IN ('42142/D011506', '42295/H33z.') | |
| Count: 1 Time=1681.40s (1681s) Lock=0.00s (0s) Rows=1.0 (1), 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/363660007' | |
| Count: 2 Time=1664.75s (3329s) Lock=0.00s (0s) Rows=2.0 (4), ri-api[ri-api]@ncbostage-obr1.Stanford.EDU | |
| SELECT CXT.name, COUNT(EAT.concept_id) FROM obr_ae_map_annotation EAT, obr_ae_element ET, obs_concept AS T1, obs_concept AS T2, obr_context CXT , obr_ae_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_ae_map_annotation AS IT1, obs_concept AS CT1, obr_ae_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: 1 Time=1607.69s (1607s) Lock=0.00s (0s) Rows=1.0 (1), ri-api[ri-api]@ncbostage-obr1.Stanford.EDU | |
| SELECT COUNT(*) 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 IN ('42142/D011506', '42295/H33z.') | |
| Count: 1 Time=1527.72s (1527s) Lock=0.00s (0s) Rows=1.0 (1), 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='44038/CHEBI:24431' | |
| Count: 1 Time=1503.53s (1503s) Lock=0.00s (0s) Rows=1.0 (1), 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='42184/MPATH:359' | |
| Count: 1 Time=1474.49s (1474s) Lock=0.00s (0s) Rows=10.0 (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_ae_map_annotation EAT, obr_ae_element ET, obs_concept AS T1, obs_concept AS T2, obr_context CXT , obr_ae_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_ae_map_annotation AS IT1, obs_concept AS CT1, obr_ae_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: 1 Time=1436.87s (1436s) Lock=0.00s (0s) Rows=1.0 (1), 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='42671/JERMOntology:Person' | |
| Count: 1 Time=1379.93s (1379s) Lock=0.00s (0s) Rows=10.0 (10), ri-api[ri-api]@ncbostage-obr1.Stanford.EDU | |
| SELECT ET.local_element_id, SUM(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='42789/363660007' GROUP BY IT.element_id ORDER BY IT.score DESC LIMIT 0,10 | |
| Count: 1 Time=1354.11s (1354s) Lock=0.00s (0s) Rows=1.0 (1), ri-api[ri-api]@ncbostage-obr1.Stanford.EDU | |
| SELECT COUNT(*) FROM obr_dbk_aggregation IT, obr_dbk_element ET, obs_concept AS T1 WHERE IT.element_id=ET.id AND IT.concept_id=T1.id AND T1.local_concept_id IN ('42280/10011224', '42280/10003553') | |
| Count: 1 Time=1279.31s (1279s) Lock=0.00s (0s) Rows=1.0 (1), 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/404684003' | |
| Count: 1 Time=1261.73s (1261s) Lock=0.00s (0s) Rows=1.0 (1), ri-api[ri-api]@ncbostage-obr1.Stanford.EDU | |
| SELECT COUNT(*) 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 IN ('42280/10011224', '42280/10003553') | |
| Count: 1 Time=1237.03s (1237s) Lock=0.00s (0s) Rows=10.0 (10), 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-GEOD-8052' ORDER BY IT.score DESC LIMIT 0, 10 | |
| Count: 1 Time=1210.61s (1210s) Lock=0.00s (0s) Rows=1.0 (1), 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='42838/Conceptual_Entities' | |
| Count: 1 Time=1178.44s (1178s) Lock=0.00s (0s) Rows=1.0 (1), 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/Xa0CE' | |
| Count: 1 Time=1130.88s (1130s) Lock=0.00s (0s) Rows=1.0 (1), 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 IN ('40404/1345', '40397/T25') AND ET.id IN (SELECT DISTINCT IT1.element_id FROM obr_aers_aggregation AS IT1, obs_concept AS CT1, obr_aers_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='40404/1345' AND IT2.concept_id=CT2.id AND CT2.local_concept_id='40397/T25') | |
| Count: 2 Time=1117.07s (2234s) Lock=0.00s (0s) Rows=1.0 (2), 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 IN ('42693/Neoplasm', '4525/Melanoma') AND ET.id IN (SELECT DISTINCT IT1.element_id FROM obr_ct_aggregation AS IT1, obs_concept AS CT1, obr_ct_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: 1 Time=1041.38s (1041s) Lock=0.07s (0s) Rows=10.0 (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_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='40397/T25' ORDER BY IT.score DESC LIMIT 0, 10 | |
| Count: 1 Time=974.52s (974s) Lock=0.00s (0s) Rows=1.0 (1), 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 IN ('39966/Cell', '29684/birnlex_406') AND ET.id IN (SELECT DISTINCT IT1.element_id FROM obr_aers_aggregation AS IT1, obs_concept AS CT1, obr_aers_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='39966/Cell' AND IT2.concept_id=CT2.id AND CT2.local_concept_id='29684/birnlex_406') | |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment