|
+
|
SELECT ••• "ligand_assayexperiment"."id", "ligand_assayexperiment"."ligand_id", "ligand_assayexperiment"."protein_id", "ligand_assayexperiment"."assay_id", "ligand_assayexperiment"."assay_type", "ligand_assayexperiment"."assay_description", "ligand_assayexperiment"."pchembl_value", "ligand_assayexperiment"."published_value", "ligand_assayexperiment"."published_relation", "ligand_assayexperiment"."published_type", "ligand_assayexperiment"."published_units", "ligand_assayexperiment"."standard_value", "ligand_assayexperiment"."standard_relation", "ligand_assayexperiment"."standard_type", "ligand_assayexperiment"."standard_units", "ligand_assayexperiment"."publication_id", "ligand_assayexperiment"."chembl", "ligand_assayexperiment"."smiles", "ligand_assayexperiment"."activity", "ligand_assayexperiment"."document_chembl_id", "ligand_assayexperiment"."cell_line" FROM "ligand_assayexperiment" INNER JOIN "ligand" ON ("ligand_assayexperiment"."ligand_id" = "ligand"."id") INNER JOIN "ligand_properities" ON ("ligand"."properities_id" = "ligand_properities"."id") INNER JOIN "ligand_properities_web_links" ON ("ligand_properities"."id" = "ligand_properities_web_links"."ligandproperities_id") INNER JOIN "web_link" ON ("ligand_properities_web_links"."weblink_id" = "web_link"."id") INNER JOIN "web_resource" ON ("web_link"."web_resource_id" = "web_resource"."id") INNER JOIN "protein" ON ("ligand_assayexperiment"."protein_id" = "protein"."id") INNER JOIN "protein_family" ON ("protein"."family_id" = "protein_family"."id") WHERE ("web_resource"."slug" = 'chembl_ligand' AND "protein_family"."slug" = '001_001_001_004')
|
|
25.89
|
|
|
Connection: default
/usr/lib/python3.6/concurrent/futures/thread.py in _worker(69)
work_item.run()
/usr/lib/python3.6/concurrent/futures/thread.py in run(56)
result = self.fn(*self.args, **self.kwargs)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle(279)
keepalive = self.handle_request(req, conn)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle_request(328)
respiter = self.wsgi(environ, resp.start_response)
/home/protwis/gpcrdb_test/common/middleware/stats.py in __call__(34)
response = self.get_response(request)
/home/protwis/gpcrdb_test/ligand/views.py in TargetDetails(334)
if not ps:
|
|
+
|
SELECT ••• "ligand_assayexperiment"."standard_type", "ligand_assayexperiment"."standard_relation", "ligand_assayexperiment"."standard_value", "ligand_assayexperiment"."assay_description", "ligand_assayexperiment"."assay_type", "ligand_assayexperiment"."pchembl_value", "ligand_assayexperiment"."ligand_id", "ligand"."properities_id", "web_link"."index", "species"."common_name", "protein"."entry_name", "ligand_properities"."mw", "ligand_properities"."logp", "ligand_properities"."rotatable_bonds", "ligand_properities"."smiles", "ligand_properities"."hdon", "ligand_properities"."hacc", "ligand_assayexperiment"."protein_id", COUNT(DISTINCT "ligand_assayexperiment"."protein_id") AS "num_targets" FROM "ligand_assayexperiment" INNER JOIN "ligand" ON ("ligand_assayexperiment"."ligand_id" = "ligand"."id") INNER JOIN "ligand_properities" ON ("ligand"."properities_id" = "ligand_properities"."id") INNER JOIN "ligand_properities_web_links" ON ("ligand_properities"."id" = "ligand_properities_web_links"."ligandproperities_id") INNER JOIN "web_link" ON ("ligand_properities_web_links"."weblink_id" = "web_link"."id") INNER JOIN "web_resource" ON ("web_link"."web_resource_id" = "web_resource"."id") INNER JOIN "protein" ON ("ligand_assayexperiment"."protein_id" = "protein"."id") INNER JOIN "protein_family" ON ("protein"."family_id" = "protein_family"."id") INNER JOIN "species" ON ("protein"."species_id" = "species"."id") WHERE ("web_resource"."slug" = 'chembl_ligand' AND "protein_family"."slug" = '001_001_001_004') GROUP BY "ligand_assayexperiment"."standard_type", "ligand_assayexperiment"."standard_relation", "ligand_assayexperiment"."standard_value", "ligand_assayexperiment"."assay_description", "ligand_assayexperiment"."assay_type", "ligand_assayexperiment"."pchembl_value", "ligand_assayexperiment"."ligand_id", "ligand"."properities_id", "web_link"."index", "species"."common_name", "protein"."entry_name", "ligand_properities"."mw", "ligand_properities"."logp", "ligand_properities"."rotatable_bonds", "ligand_properities"."smiles", "ligand_properities"."hdon", "ligand_properities"."hacc", "ligand_assayexperiment"."protein_id"
|
|
9.94
|
|
|
Connection: default
/usr/lib/python3.6/concurrent/futures/thread.py in _worker(69)
work_item.run()
/usr/lib/python3.6/concurrent/futures/thread.py in run(56)
result = self.fn(*self.args, **self.kwargs)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle(279)
keepalive = self.handle_request(req, conn)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle_request(328)
respiter = self.wsgi(environ, resp.start_response)
/home/protwis/gpcrdb_test/common/middleware/stats.py in __call__(34)
response = self.get_response(request)
/home/protwis/gpcrdb_test/ligand/views.py in TargetDetails(357)
for record in ps:
|
|
+
|
SELECT ••• "ligand_ligandvendorlink"."id", "ligand_ligandvendorlink"."vendor_id", "ligand_ligandvendorlink"."lp_id", "ligand_ligandvendorlink"."url", "ligand_ligandvendorlink"."vendor_external_id", "ligand_ligandvendorlink"."sid" FROM "ligand_ligandvendorlink" INNER JOIN "ligand_ligandvendors" ON ("ligand_ligandvendorlink"."vendor_id" = "ligand_ligandvendors"."id") WHERE ("ligand_ligandvendorlink"."lp_id" = 52389 AND NOT ("ligand_ligandvendors"."name" IN ('ZINC', 'ChEMBL', 'BindingDB', 'SureChEMBL', 'eMolecules', 'MolPort', 'PubChem')))
76 similar queries.
Duplicated 2 times.
|
|
3.39
|
|
|
Connection: default
/usr/lib/python3.6/concurrent/futures/thread.py in _worker(69)
work_item.run()
/usr/lib/python3.6/concurrent/futures/thread.py in run(56)
result = self.fn(*self.args, **self.kwargs)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle(279)
keepalive = self.handle_request(req, conn)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle_request(328)
respiter = self.wsgi(environ, resp.start_response)
/home/protwis/gpcrdb_test/common/middleware/stats.py in __call__(34)
response = self.get_response(request)
/home/protwis/gpcrdb_test/ligand/views.py in TargetDetails(359)
vendor__name__in=['ZINC', 'ChEMBL', 'BindingDB', 'SureChEMBL', 'eMolecules', 'MolPort', 'PubChem'])) > 0 else 'No'
|
|
+
|
SELECT ••• "ligand_ligandvendorlink"."id", "ligand_ligandvendorlink"."vendor_id", "ligand_ligandvendorlink"."lp_id", "ligand_ligandvendorlink"."url", "ligand_ligandvendorlink"."vendor_external_id", "ligand_ligandvendorlink"."sid" FROM "ligand_ligandvendorlink" INNER JOIN "ligand_ligandvendors" ON ("ligand_ligandvendorlink"."vendor_id" = "ligand_ligandvendors"."id") WHERE ("ligand_ligandvendorlink"."lp_id" = 52389 AND NOT ("ligand_ligandvendors"."name" IN ('ZINC', 'ChEMBL', 'BindingDB', 'SureChEMBL', 'eMolecules', 'MolPort', 'PubChem')))
76 similar queries.
Duplicated 2 times.
|
|
0.76
|
|
|
Connection: default
/usr/lib/python3.6/concurrent/futures/thread.py in _worker(69)
work_item.run()
/usr/lib/python3.6/concurrent/futures/thread.py in run(56)
result = self.fn(*self.args, **self.kwargs)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle(279)
keepalive = self.handle_request(req, conn)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle_request(328)
respiter = self.wsgi(environ, resp.start_response)
/home/protwis/gpcrdb_test/common/middleware/stats.py in __call__(34)
response = self.get_response(request)
/home/protwis/gpcrdb_test/ligand/views.py in TargetDetails(359)
vendor__name__in=['ZINC', 'ChEMBL', 'BindingDB', 'SureChEMBL', 'eMolecules', 'MolPort', 'PubChem'])) > 0 else 'No'
|
|
+
|
SELECT ••• "ligand_ligandvendorlink"."id", "ligand_ligandvendorlink"."vendor_id", "ligand_ligandvendorlink"."lp_id", "ligand_ligandvendorlink"."url", "ligand_ligandvendorlink"."vendor_external_id", "ligand_ligandvendorlink"."sid" FROM "ligand_ligandvendorlink" INNER JOIN "ligand_ligandvendors" ON ("ligand_ligandvendorlink"."vendor_id" = "ligand_ligandvendors"."id") WHERE ("ligand_ligandvendorlink"."lp_id" = 55327 AND NOT ("ligand_ligandvendors"."name" IN ('ZINC', 'ChEMBL', 'BindingDB', 'SureChEMBL', 'eMolecules', 'MolPort', 'PubChem')))
76 similar queries.
Duplicated 2 times.
|
|
1.64
|
|
|
Connection: default
/usr/lib/python3.6/concurrent/futures/thread.py in _worker(69)
work_item.run()
/usr/lib/python3.6/concurrent/futures/thread.py in run(56)
result = self.fn(*self.args, **self.kwargs)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle(279)
keepalive = self.handle_request(req, conn)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle_request(328)
respiter = self.wsgi(environ, resp.start_response)
/home/protwis/gpcrdb_test/common/middleware/stats.py in __call__(34)
response = self.get_response(request)
/home/protwis/gpcrdb_test/ligand/views.py in TargetDetails(359)
vendor__name__in=['ZINC', 'ChEMBL', 'BindingDB', 'SureChEMBL', 'eMolecules', 'MolPort', 'PubChem'])) > 0 else 'No'
|
|
+
|
SELECT ••• "ligand_ligandvendorlink"."id", "ligand_ligandvendorlink"."vendor_id", "ligand_ligandvendorlink"."lp_id", "ligand_ligandvendorlink"."url", "ligand_ligandvendorlink"."vendor_external_id", "ligand_ligandvendorlink"."sid" FROM "ligand_ligandvendorlink" INNER JOIN "ligand_ligandvendors" ON ("ligand_ligandvendorlink"."vendor_id" = "ligand_ligandvendors"."id") WHERE ("ligand_ligandvendorlink"."lp_id" = 55327 AND NOT ("ligand_ligandvendors"."name" IN ('ZINC', 'ChEMBL', 'BindingDB', 'SureChEMBL', 'eMolecules', 'MolPort', 'PubChem')))
76 similar queries.
Duplicated 2 times.
|
|
0.66
|
|
|
Connection: default
/usr/lib/python3.6/concurrent/futures/thread.py in _worker(69)
work_item.run()
/usr/lib/python3.6/concurrent/futures/thread.py in run(56)
result = self.fn(*self.args, **self.kwargs)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle(279)
keepalive = self.handle_request(req, conn)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle_request(328)
respiter = self.wsgi(environ, resp.start_response)
/home/protwis/gpcrdb_test/common/middleware/stats.py in __call__(34)
response = self.get_response(request)
/home/protwis/gpcrdb_test/ligand/views.py in TargetDetails(359)
vendor__name__in=['ZINC', 'ChEMBL', 'BindingDB', 'SureChEMBL', 'eMolecules', 'MolPort', 'PubChem'])) > 0 else 'No'
|
|
+
|
SELECT ••• "ligand_ligandvendorlink"."id", "ligand_ligandvendorlink"."vendor_id", "ligand_ligandvendorlink"."lp_id", "ligand_ligandvendorlink"."url", "ligand_ligandvendorlink"."vendor_external_id", "ligand_ligandvendorlink"."sid" FROM "ligand_ligandvendorlink" INNER JOIN "ligand_ligandvendors" ON ("ligand_ligandvendorlink"."vendor_id" = "ligand_ligandvendors"."id") WHERE ("ligand_ligandvendorlink"."lp_id" = 55836 AND NOT ("ligand_ligandvendors"."name" IN ('ZINC', 'ChEMBL', 'BindingDB', 'SureChEMBL', 'eMolecules', 'MolPort', 'PubChem')))
76 similar queries.
Duplicated 2 times.
|
|
1.65
|
|
|
Connection: default
/usr/lib/python3.6/concurrent/futures/thread.py in _worker(69)
work_item.run()
/usr/lib/python3.6/concurrent/futures/thread.py in run(56)
result = self.fn(*self.args, **self.kwargs)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle(279)
keepalive = self.handle_request(req, conn)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle_request(328)
respiter = self.wsgi(environ, resp.start_response)
/home/protwis/gpcrdb_test/common/middleware/stats.py in __call__(34)
response = self.get_response(request)
/home/protwis/gpcrdb_test/ligand/views.py in TargetDetails(359)
vendor__name__in=['ZINC', 'ChEMBL', 'BindingDB', 'SureChEMBL', 'eMolecules', 'MolPort', 'PubChem'])) > 0 else 'No'
|
|
+
|
SELECT ••• "ligand_ligandvendorlink"."id", "ligand_ligandvendorlink"."vendor_id", "ligand_ligandvendorlink"."lp_id", "ligand_ligandvendorlink"."url", "ligand_ligandvendorlink"."vendor_external_id", "ligand_ligandvendorlink"."sid" FROM "ligand_ligandvendorlink" INNER JOIN "ligand_ligandvendors" ON ("ligand_ligandvendorlink"."vendor_id" = "ligand_ligandvendors"."id") WHERE ("ligand_ligandvendorlink"."lp_id" = 55836 AND NOT ("ligand_ligandvendors"."name" IN ('ZINC', 'ChEMBL', 'BindingDB', 'SureChEMBL', 'eMolecules', 'MolPort', 'PubChem')))
76 similar queries.
Duplicated 2 times.
|
|
0.65
|
|
|
Connection: default
/usr/lib/python3.6/concurrent/futures/thread.py in _worker(69)
work_item.run()
/usr/lib/python3.6/concurrent/futures/thread.py in run(56)
result = self.fn(*self.args, **self.kwargs)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle(279)
keepalive = self.handle_request(req, conn)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle_request(328)
respiter = self.wsgi(environ, resp.start_response)
/home/protwis/gpcrdb_test/common/middleware/stats.py in __call__(34)
response = self.get_response(request)
/home/protwis/gpcrdb_test/ligand/views.py in TargetDetails(359)
vendor__name__in=['ZINC', 'ChEMBL', 'BindingDB', 'SureChEMBL', 'eMolecules', 'MolPort', 'PubChem'])) > 0 else 'No'
|
|
+
|
SELECT ••• "ligand_ligandvendorlink"."id", "ligand_ligandvendorlink"."vendor_id", "ligand_ligandvendorlink"."lp_id", "ligand_ligandvendorlink"."url", "ligand_ligandvendorlink"."vendor_external_id", "ligand_ligandvendorlink"."sid" FROM "ligand_ligandvendorlink" INNER JOIN "ligand_ligandvendors" ON ("ligand_ligandvendorlink"."vendor_id" = "ligand_ligandvendors"."id") WHERE ("ligand_ligandvendorlink"."lp_id" = 57229 AND NOT ("ligand_ligandvendors"."name" IN ('ZINC', 'ChEMBL', 'BindingDB', 'SureChEMBL', 'eMolecules', 'MolPort', 'PubChem')))
76 similar queries.
Duplicated 2 times.
|
|
0.67
|
|
|
Connection: default
/usr/lib/python3.6/concurrent/futures/thread.py in _worker(69)
work_item.run()
/usr/lib/python3.6/concurrent/futures/thread.py in run(56)
result = self.fn(*self.args, **self.kwargs)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle(279)
keepalive = self.handle_request(req, conn)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle_request(328)
respiter = self.wsgi(environ, resp.start_response)
/home/protwis/gpcrdb_test/common/middleware/stats.py in __call__(34)
response = self.get_response(request)
/home/protwis/gpcrdb_test/ligand/views.py in TargetDetails(359)
vendor__name__in=['ZINC', 'ChEMBL', 'BindingDB', 'SureChEMBL', 'eMolecules', 'MolPort', 'PubChem'])) > 0 else 'No'
|
|
+
|
SELECT ••• "ligand_ligandvendorlink"."id", "ligand_ligandvendorlink"."vendor_id", "ligand_ligandvendorlink"."lp_id", "ligand_ligandvendorlink"."url", "ligand_ligandvendorlink"."vendor_external_id", "ligand_ligandvendorlink"."sid" FROM "ligand_ligandvendorlink" INNER JOIN "ligand_ligandvendors" ON ("ligand_ligandvendorlink"."vendor_id" = "ligand_ligandvendors"."id") WHERE ("ligand_ligandvendorlink"."lp_id" = 57229 AND NOT ("ligand_ligandvendors"."name" IN ('ZINC', 'ChEMBL', 'BindingDB', 'SureChEMBL', 'eMolecules', 'MolPort', 'PubChem')))
76 similar queries.
Duplicated 2 times.
|
|
0.64
|
|
|
Connection: default
/usr/lib/python3.6/concurrent/futures/thread.py in _worker(69)
work_item.run()
/usr/lib/python3.6/concurrent/futures/thread.py in run(56)
result = self.fn(*self.args, **self.kwargs)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle(279)
keepalive = self.handle_request(req, conn)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle_request(328)
respiter = self.wsgi(environ, resp.start_response)
/home/protwis/gpcrdb_test/common/middleware/stats.py in __call__(34)
response = self.get_response(request)
/home/protwis/gpcrdb_test/ligand/views.py in TargetDetails(359)
vendor__name__in=['ZINC', 'ChEMBL', 'BindingDB', 'SureChEMBL', 'eMolecules', 'MolPort', 'PubChem'])) > 0 else 'No'
|
|
+
|
SELECT ••• "ligand_ligandvendorlink"."id", "ligand_ligandvendorlink"."vendor_id", "ligand_ligandvendorlink"."lp_id", "ligand_ligandvendorlink"."url", "ligand_ligandvendorlink"."vendor_external_id", "ligand_ligandvendorlink"."sid" FROM "ligand_ligandvendorlink" INNER JOIN "ligand_ligandvendors" ON ("ligand_ligandvendorlink"."vendor_id" = "ligand_ligandvendors"."id") WHERE ("ligand_ligandvendorlink"."lp_id" = 61337 AND NOT ("ligand_ligandvendors"."name" IN ('ZINC', 'ChEMBL', 'BindingDB', 'SureChEMBL', 'eMolecules', 'MolPort', 'PubChem')))
76 similar queries.
Duplicated 2 times.
|
|
0.70
|
|
|
Connection: default
/usr/lib/python3.6/concurrent/futures/thread.py in _worker(69)
work_item.run()
/usr/lib/python3.6/concurrent/futures/thread.py in run(56)
result = self.fn(*self.args, **self.kwargs)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle(279)
keepalive = self.handle_request(req, conn)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle_request(328)
respiter = self.wsgi(environ, resp.start_response)
/home/protwis/gpcrdb_test/common/middleware/stats.py in __call__(34)
response = self.get_response(request)
/home/protwis/gpcrdb_test/ligand/views.py in TargetDetails(359)
vendor__name__in=['ZINC', 'ChEMBL', 'BindingDB', 'SureChEMBL', 'eMolecules', 'MolPort', 'PubChem'])) > 0 else 'No'
|
|
+
|
SELECT ••• "ligand_ligandvendorlink"."id", "ligand_ligandvendorlink"."vendor_id", "ligand_ligandvendorlink"."lp_id", "ligand_ligandvendorlink"."url", "ligand_ligandvendorlink"."vendor_external_id", "ligand_ligandvendorlink"."sid" FROM "ligand_ligandvendorlink" INNER JOIN "ligand_ligandvendors" ON ("ligand_ligandvendorlink"."vendor_id" = "ligand_ligandvendors"."id") WHERE ("ligand_ligandvendorlink"."lp_id" = 61337 AND NOT ("ligand_ligandvendors"."name" IN ('ZINC', 'ChEMBL', 'BindingDB', 'SureChEMBL', 'eMolecules', 'MolPort', 'PubChem')))
76 similar queries.
Duplicated 2 times.
|
|
0.66
|
|
|
Connection: default
/usr/lib/python3.6/concurrent/futures/thread.py in _worker(69)
work_item.run()
/usr/lib/python3.6/concurrent/futures/thread.py in run(56)
result = self.fn(*self.args, **self.kwargs)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle(279)
keepalive = self.handle_request(req, conn)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle_request(328)
respiter = self.wsgi(environ, resp.start_response)
/home/protwis/gpcrdb_test/common/middleware/stats.py in __call__(34)
response = self.get_response(request)
/home/protwis/gpcrdb_test/ligand/views.py in TargetDetails(359)
vendor__name__in=['ZINC', 'ChEMBL', 'BindingDB', 'SureChEMBL', 'eMolecules', 'MolPort', 'PubChem'])) > 0 else 'No'
|
|
+
|
SELECT ••• "ligand_ligandvendorlink"."id", "ligand_ligandvendorlink"."vendor_id", "ligand_ligandvendorlink"."lp_id", "ligand_ligandvendorlink"."url", "ligand_ligandvendorlink"."vendor_external_id", "ligand_ligandvendorlink"."sid" FROM "ligand_ligandvendorlink" INNER JOIN "ligand_ligandvendors" ON ("ligand_ligandvendorlink"."vendor_id" = "ligand_ligandvendors"."id") WHERE ("ligand_ligandvendorlink"."lp_id" = 61072 AND NOT ("ligand_ligandvendors"."name" IN ('ZINC', 'ChEMBL', 'BindingDB', 'SureChEMBL', 'eMolecules', 'MolPort', 'PubChem')))
76 similar queries.
Duplicated 2 times.
|
|
1.75
|
|
|
Connection: default
/usr/lib/python3.6/concurrent/futures/thread.py in _worker(69)
work_item.run()
/usr/lib/python3.6/concurrent/futures/thread.py in run(56)
result = self.fn(*self.args, **self.kwargs)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle(279)
keepalive = self.handle_request(req, conn)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle_request(328)
respiter = self.wsgi(environ, resp.start_response)
/home/protwis/gpcrdb_test/common/middleware/stats.py in __call__(34)
response = self.get_response(request)
/home/protwis/gpcrdb_test/ligand/views.py in TargetDetails(359)
vendor__name__in=['ZINC', 'ChEMBL', 'BindingDB', 'SureChEMBL', 'eMolecules', 'MolPort', 'PubChem'])) > 0 else 'No'
|
|
+
|
SELECT ••• "ligand_ligandvendorlink"."id", "ligand_ligandvendorlink"."vendor_id", "ligand_ligandvendorlink"."lp_id", "ligand_ligandvendorlink"."url", "ligand_ligandvendorlink"."vendor_external_id", "ligand_ligandvendorlink"."sid" FROM "ligand_ligandvendorlink" INNER JOIN "ligand_ligandvendors" ON ("ligand_ligandvendorlink"."vendor_id" = "ligand_ligandvendors"."id") WHERE ("ligand_ligandvendorlink"."lp_id" = 61072 AND NOT ("ligand_ligandvendors"."name" IN ('ZINC', 'ChEMBL', 'BindingDB', 'SureChEMBL', 'eMolecules', 'MolPort', 'PubChem')))
76 similar queries.
Duplicated 2 times.
|
|
0.64
|
|
|
Connection: default
/usr/lib/python3.6/concurrent/futures/thread.py in _worker(69)
work_item.run()
/usr/lib/python3.6/concurrent/futures/thread.py in run(56)
result = self.fn(*self.args, **self.kwargs)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle(279)
keepalive = self.handle_request(req, conn)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle_request(328)
respiter = self.wsgi(environ, resp.start_response)
/home/protwis/gpcrdb_test/common/middleware/stats.py in __call__(34)
response = self.get_response(request)
/home/protwis/gpcrdb_test/ligand/views.py in TargetDetails(359)
vendor__name__in=['ZINC', 'ChEMBL', 'BindingDB', 'SureChEMBL', 'eMolecules', 'MolPort', 'PubChem'])) > 0 else 'No'
|
|
+
|
SELECT ••• "ligand_ligandvendorlink"."id", "ligand_ligandvendorlink"."vendor_id", "ligand_ligandvendorlink"."lp_id", "ligand_ligandvendorlink"."url", "ligand_ligandvendorlink"."vendor_external_id", "ligand_ligandvendorlink"."sid" FROM "ligand_ligandvendorlink" INNER JOIN "ligand_ligandvendors" ON ("ligand_ligandvendorlink"."vendor_id" = "ligand_ligandvendors"."id") WHERE ("ligand_ligandvendorlink"."lp_id" = 20322 AND NOT ("ligand_ligandvendors"."name" IN ('ZINC', 'ChEMBL', 'BindingDB', 'SureChEMBL', 'eMolecules', 'MolPort', 'PubChem')))
76 similar queries.
Duplicated 2 times.
|
|
0.69
|
|
|
Connection: default
/usr/lib/python3.6/concurrent/futures/thread.py in _worker(69)
work_item.run()
/usr/lib/python3.6/concurrent/futures/thread.py in run(56)
result = self.fn(*self.args, **self.kwargs)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle(279)
keepalive = self.handle_request(req, conn)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle_request(328)
respiter = self.wsgi(environ, resp.start_response)
/home/protwis/gpcrdb_test/common/middleware/stats.py in __call__(34)
response = self.get_response(request)
/home/protwis/gpcrdb_test/ligand/views.py in TargetDetails(359)
vendor__name__in=['ZINC', 'ChEMBL', 'BindingDB', 'SureChEMBL', 'eMolecules', 'MolPort', 'PubChem'])) > 0 else 'No'
|
|
+
|
SELECT ••• "ligand_ligandvendorlink"."id", "ligand_ligandvendorlink"."vendor_id", "ligand_ligandvendorlink"."lp_id", "ligand_ligandvendorlink"."url", "ligand_ligandvendorlink"."vendor_external_id", "ligand_ligandvendorlink"."sid" FROM "ligand_ligandvendorlink" INNER JOIN "ligand_ligandvendors" ON ("ligand_ligandvendorlink"."vendor_id" = "ligand_ligandvendors"."id") WHERE ("ligand_ligandvendorlink"."lp_id" = 60796 AND NOT ("ligand_ligandvendors"."name" IN ('ZINC', 'ChEMBL', 'BindingDB', 'SureChEMBL', 'eMolecules', 'MolPort', 'PubChem')))
76 similar queries.
Duplicated 2 times.
|
|
1.62
|
|
|
Connection: default
/usr/lib/python3.6/concurrent/futures/thread.py in _worker(69)
work_item.run()
/usr/lib/python3.6/concurrent/futures/thread.py in run(56)
result = self.fn(*self.args, **self.kwargs)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle(279)
keepalive = self.handle_request(req, conn)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle_request(328)
respiter = self.wsgi(environ, resp.start_response)
/home/protwis/gpcrdb_test/common/middleware/stats.py in __call__(34)
response = self.get_response(request)
/home/protwis/gpcrdb_test/ligand/views.py in TargetDetails(359)
vendor__name__in=['ZINC', 'ChEMBL', 'BindingDB', 'SureChEMBL', 'eMolecules', 'MolPort', 'PubChem'])) > 0 else 'No'
|
|
+
|
SELECT ••• "ligand_ligandvendorlink"."id", "ligand_ligandvendorlink"."vendor_id", "ligand_ligandvendorlink"."lp_id", "ligand_ligandvendorlink"."url", "ligand_ligandvendorlink"."vendor_external_id", "ligand_ligandvendorlink"."sid" FROM "ligand_ligandvendorlink" INNER JOIN "ligand_ligandvendors" ON ("ligand_ligandvendorlink"."vendor_id" = "ligand_ligandvendors"."id") WHERE ("ligand_ligandvendorlink"."lp_id" = 20322 AND NOT ("ligand_ligandvendors"."name" IN ('ZINC', 'ChEMBL', 'BindingDB', 'SureChEMBL', 'eMolecules', 'MolPort', 'PubChem')))
76 similar queries.
Duplicated 2 times.
|
|
0.64
|
|
|
Connection: default
/usr/lib/python3.6/concurrent/futures/thread.py in _worker(69)
work_item.run()
/usr/lib/python3.6/concurrent/futures/thread.py in run(56)
result = self.fn(*self.args, **self.kwargs)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle(279)
keepalive = self.handle_request(req, conn)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle_request(328)
respiter = self.wsgi(environ, resp.start_response)
/home/protwis/gpcrdb_test/common/middleware/stats.py in __call__(34)
response = self.get_response(request)
/home/protwis/gpcrdb_test/ligand/views.py in TargetDetails(359)
vendor__name__in=['ZINC', 'ChEMBL', 'BindingDB', 'SureChEMBL', 'eMolecules', 'MolPort', 'PubChem'])) > 0 else 'No'
|
|
+
|
SELECT ••• "ligand_ligandvendorlink"."id", "ligand_ligandvendorlink"."vendor_id", "ligand_ligandvendorlink"."lp_id", "ligand_ligandvendorlink"."url", "ligand_ligandvendorlink"."vendor_external_id", "ligand_ligandvendorlink"."sid" FROM "ligand_ligandvendorlink" INNER JOIN "ligand_ligandvendors" ON ("ligand_ligandvendorlink"."vendor_id" = "ligand_ligandvendors"."id") WHERE ("ligand_ligandvendorlink"."lp_id" = 60796 AND NOT ("ligand_ligandvendors"."name" IN ('ZINC', 'ChEMBL', 'BindingDB', 'SureChEMBL', 'eMolecules', 'MolPort', 'PubChem')))
76 similar queries.
Duplicated 2 times.
|
|
0.63
|
|
|
Connection: default
/usr/lib/python3.6/concurrent/futures/thread.py in _worker(69)
work_item.run()
/usr/lib/python3.6/concurrent/futures/thread.py in run(56)
result = self.fn(*self.args, **self.kwargs)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle(279)
keepalive = self.handle_request(req, conn)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle_request(328)
respiter = self.wsgi(environ, resp.start_response)
/home/protwis/gpcrdb_test/common/middleware/stats.py in __call__(34)
response = self.get_response(request)
/home/protwis/gpcrdb_test/ligand/views.py in TargetDetails(359)
vendor__name__in=['ZINC', 'ChEMBL', 'BindingDB', 'SureChEMBL', 'eMolecules', 'MolPort', 'PubChem'])) > 0 else 'No'
|
|
+
|
SELECT ••• "ligand_ligandvendorlink"."id", "ligand_ligandvendorlink"."vendor_id", "ligand_ligandvendorlink"."lp_id", "ligand_ligandvendorlink"."url", "ligand_ligandvendorlink"."vendor_external_id", "ligand_ligandvendorlink"."sid" FROM "ligand_ligandvendorlink" INNER JOIN "ligand_ligandvendors" ON ("ligand_ligandvendorlink"."vendor_id" = "ligand_ligandvendors"."id") WHERE ("ligand_ligandvendorlink"."lp_id" = 57572 AND NOT ("ligand_ligandvendors"."name" IN ('ZINC', 'ChEMBL', 'BindingDB', 'SureChEMBL', 'eMolecules', 'MolPort', 'PubChem')))
76 similar queries.
Duplicated 2 times.
|
|
2.04
|
|
|
Connection: default
/usr/lib/python3.6/concurrent/futures/thread.py in _worker(69)
work_item.run()
/usr/lib/python3.6/concurrent/futures/thread.py in run(56)
result = self.fn(*self.args, **self.kwargs)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle(279)
keepalive = self.handle_request(req, conn)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle_request(328)
respiter = self.wsgi(environ, resp.start_response)
/home/protwis/gpcrdb_test/common/middleware/stats.py in __call__(34)
response = self.get_response(request)
/home/protwis/gpcrdb_test/ligand/views.py in TargetDetails(359)
vendor__name__in=['ZINC', 'ChEMBL', 'BindingDB', 'SureChEMBL', 'eMolecules', 'MolPort', 'PubChem'])) > 0 else 'No'
|
|
+
|
SELECT ••• "ligand_ligandvendorlink"."id", "ligand_ligandvendorlink"."vendor_id", "ligand_ligandvendorlink"."lp_id", "ligand_ligandvendorlink"."url", "ligand_ligandvendorlink"."vendor_external_id", "ligand_ligandvendorlink"."sid" FROM "ligand_ligandvendorlink" INNER JOIN "ligand_ligandvendors" ON ("ligand_ligandvendorlink"."vendor_id" = "ligand_ligandvendors"."id") WHERE ("ligand_ligandvendorlink"."lp_id" = 57572 AND NOT ("ligand_ligandvendors"."name" IN ('ZINC', 'ChEMBL', 'BindingDB', 'SureChEMBL', 'eMolecules', 'MolPort', 'PubChem')))
76 similar queries.
Duplicated 2 times.
|
|
0.64
|
|
|
Connection: default
/usr/lib/python3.6/concurrent/futures/thread.py in _worker(69)
work_item.run()
/usr/lib/python3.6/concurrent/futures/thread.py in run(56)
result = self.fn(*self.args, **self.kwargs)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle(279)
keepalive = self.handle_request(req, conn)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle_request(328)
respiter = self.wsgi(environ, resp.start_response)
/home/protwis/gpcrdb_test/common/middleware/stats.py in __call__(34)
response = self.get_response(request)
/home/protwis/gpcrdb_test/ligand/views.py in TargetDetails(359)
vendor__name__in=['ZINC', 'ChEMBL', 'BindingDB', 'SureChEMBL', 'eMolecules', 'MolPort', 'PubChem'])) > 0 else 'No'
|
|
+
|
SELECT ••• "ligand_ligandvendorlink"."id", "ligand_ligandvendorlink"."vendor_id", "ligand_ligandvendorlink"."lp_id", "ligand_ligandvendorlink"."url", "ligand_ligandvendorlink"."vendor_external_id", "ligand_ligandvendorlink"."sid" FROM "ligand_ligandvendorlink" INNER JOIN "ligand_ligandvendors" ON ("ligand_ligandvendorlink"."vendor_id" = "ligand_ligandvendors"."id") WHERE ("ligand_ligandvendorlink"."lp_id" = 58724 AND NOT ("ligand_ligandvendors"."name" IN ('ZINC', 'ChEMBL', 'BindingDB', 'SureChEMBL', 'eMolecules', 'MolPort', 'PubChem')))
76 similar queries.
Duplicated 2 times.
|
|
0.66
|
|
|
Connection: default
/usr/lib/python3.6/concurrent/futures/thread.py in _worker(69)
work_item.run()
/usr/lib/python3.6/concurrent/futures/thread.py in run(56)
result = self.fn(*self.args, **self.kwargs)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle(279)
keepalive = self.handle_request(req, conn)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle_request(328)
respiter = self.wsgi(environ, resp.start_response)
/home/protwis/gpcrdb_test/common/middleware/stats.py in __call__(34)
response = self.get_response(request)
/home/protwis/gpcrdb_test/ligand/views.py in TargetDetails(359)
vendor__name__in=['ZINC', 'ChEMBL', 'BindingDB', 'SureChEMBL', 'eMolecules', 'MolPort', 'PubChem'])) > 0 else 'No'
|
|
+
|
SELECT ••• "ligand_ligandvendorlink"."id", "ligand_ligandvendorlink"."vendor_id", "ligand_ligandvendorlink"."lp_id", "ligand_ligandvendorlink"."url", "ligand_ligandvendorlink"."vendor_external_id", "ligand_ligandvendorlink"."sid" FROM "ligand_ligandvendorlink" INNER JOIN "ligand_ligandvendors" ON ("ligand_ligandvendorlink"."vendor_id" = "ligand_ligandvendors"."id") WHERE ("ligand_ligandvendorlink"."lp_id" = 58724 AND NOT ("ligand_ligandvendors"."name" IN ('ZINC', 'ChEMBL', 'BindingDB', 'SureChEMBL', 'eMolecules', 'MolPort', 'PubChem')))
76 similar queries.
Duplicated 2 times.
|
|
0.65
|
|
|
Connection: default
/usr/lib/python3.6/concurrent/futures/thread.py in _worker(69)
work_item.run()
/usr/lib/python3.6/concurrent/futures/thread.py in run(56)
result = self.fn(*self.args, **self.kwargs)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle(279)
keepalive = self.handle_request(req, conn)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle_request(328)
respiter = self.wsgi(environ, resp.start_response)
/home/protwis/gpcrdb_test/common/middleware/stats.py in __call__(34)
response = self.get_response(request)
/home/protwis/gpcrdb_test/ligand/views.py in TargetDetails(359)
vendor__name__in=['ZINC', 'ChEMBL', 'BindingDB', 'SureChEMBL', 'eMolecules', 'MolPort', 'PubChem'])) > 0 else 'No'
|
|
+
|
SELECT ••• "ligand_ligandvendorlink"."id", "ligand_ligandvendorlink"."vendor_id", "ligand_ligandvendorlink"."lp_id", "ligand_ligandvendorlink"."url", "ligand_ligandvendorlink"."vendor_external_id", "ligand_ligandvendorlink"."sid" FROM "ligand_ligandvendorlink" INNER JOIN "ligand_ligandvendors" ON ("ligand_ligandvendorlink"."vendor_id" = "ligand_ligandvendors"."id") WHERE ("ligand_ligandvendorlink"."lp_id" = 28685 AND NOT ("ligand_ligandvendors"."name" IN ('ZINC', 'ChEMBL', 'BindingDB', 'SureChEMBL', 'eMolecules', 'MolPort', 'PubChem')))
76 similar queries.
Duplicated 2 times.
|
|
0.68
|
|
|
Connection: default
/usr/lib/python3.6/concurrent/futures/thread.py in _worker(69)
work_item.run()
/usr/lib/python3.6/concurrent/futures/thread.py in run(56)
result = self.fn(*self.args, **self.kwargs)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle(279)
keepalive = self.handle_request(req, conn)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle_request(328)
respiter = self.wsgi(environ, resp.start_response)
/home/protwis/gpcrdb_test/common/middleware/stats.py in __call__(34)
response = self.get_response(request)
/home/protwis/gpcrdb_test/ligand/views.py in TargetDetails(359)
vendor__name__in=['ZINC', 'ChEMBL', 'BindingDB', 'SureChEMBL', 'eMolecules', 'MolPort', 'PubChem'])) > 0 else 'No'
|
|
+
|
SELECT ••• "ligand_ligandvendorlink"."id", "ligand_ligandvendorlink"."vendor_id", "ligand_ligandvendorlink"."lp_id", "ligand_ligandvendorlink"."url", "ligand_ligandvendorlink"."vendor_external_id", "ligand_ligandvendorlink"."sid" FROM "ligand_ligandvendorlink" INNER JOIN "ligand_ligandvendors" ON ("ligand_ligandvendorlink"."vendor_id" = "ligand_ligandvendors"."id") WHERE ("ligand_ligandvendorlink"."lp_id" = 28685 AND NOT ("ligand_ligandvendors"."name" IN ('ZINC', 'ChEMBL', 'BindingDB', 'SureChEMBL', 'eMolecules', 'MolPort', 'PubChem')))
76 similar queries.
Duplicated 2 times.
|
|
0.63
|
|
|
Connection: default
/usr/lib/python3.6/concurrent/futures/thread.py in _worker(69)
work_item.run()
/usr/lib/python3.6/concurrent/futures/thread.py in run(56)
result = self.fn(*self.args, **self.kwargs)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle(279)
keepalive = self.handle_request(req, conn)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle_request(328)
respiter = self.wsgi(environ, resp.start_response)
/home/protwis/gpcrdb_test/common/middleware/stats.py in __call__(34)
response = self.get_response(request)
/home/protwis/gpcrdb_test/ligand/views.py in TargetDetails(359)
vendor__name__in=['ZINC', 'ChEMBL', 'BindingDB', 'SureChEMBL', 'eMolecules', 'MolPort', 'PubChem'])) > 0 else 'No'
|
|
+
|
SELECT ••• "ligand_ligandvendorlink"."id", "ligand_ligandvendorlink"."vendor_id", "ligand_ligandvendorlink"."lp_id", "ligand_ligandvendorlink"."url", "ligand_ligandvendorlink"."vendor_external_id", "ligand_ligandvendorlink"."sid" FROM "ligand_ligandvendorlink" INNER JOIN "ligand_ligandvendors" ON ("ligand_ligandvendorlink"."vendor_id" = "ligand_ligandvendors"."id") WHERE ("ligand_ligandvendorlink"."lp_id" = 62201 AND NOT ("ligand_ligandvendors"."name" IN ('ZINC', 'ChEMBL', 'BindingDB', 'SureChEMBL', 'eMolecules', 'MolPort', 'PubChem')))
76 similar queries.
Duplicated 2 times.
|
|
0.53
|
|
|
Connection: default
/usr/lib/python3.6/concurrent/futures/thread.py in _worker(69)
work_item.run()
/usr/lib/python3.6/concurrent/futures/thread.py in run(56)
result = self.fn(*self.args, **self.kwargs)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle(279)
keepalive = self.handle_request(req, conn)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle_request(328)
respiter = self.wsgi(environ, resp.start_response)
/home/protwis/gpcrdb_test/common/middleware/stats.py in __call__(34)
response = self.get_response(request)
/home/protwis/gpcrdb_test/ligand/views.py in TargetDetails(359)
vendor__name__in=['ZINC', 'ChEMBL', 'BindingDB', 'SureChEMBL', 'eMolecules', 'MolPort', 'PubChem'])) > 0 else 'No'
|
|
+
|
SELECT ••• "ligand_ligandvendorlink"."id", "ligand_ligandvendorlink"."vendor_id", "ligand_ligandvendorlink"."lp_id", "ligand_ligandvendorlink"."url", "ligand_ligandvendorlink"."vendor_external_id", "ligand_ligandvendorlink"."sid" FROM "ligand_ligandvendorlink" INNER JOIN "ligand_ligandvendors" ON ("ligand_ligandvendorlink"."vendor_id" = "ligand_ligandvendors"."id") WHERE ("ligand_ligandvendorlink"."lp_id" = 62201 AND NOT ("ligand_ligandvendors"."name" IN ('ZINC', 'ChEMBL', 'BindingDB', 'SureChEMBL', 'eMolecules', 'MolPort', 'PubChem')))
76 similar queries.
Duplicated 2 times.
|
|
0.51
|
|
|
Connection: default
/usr/lib/python3.6/concurrent/futures/thread.py in _worker(69)
work_item.run()
/usr/lib/python3.6/concurrent/futures/thread.py in run(56)
result = self.fn(*self.args, **self.kwargs)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle(279)
keepalive = self.handle_request(req, conn)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle_request(328)
respiter = self.wsgi(environ, resp.start_response)
/home/protwis/gpcrdb_test/common/middleware/stats.py in __call__(34)
response = self.get_response(request)
/home/protwis/gpcrdb_test/ligand/views.py in TargetDetails(359)
vendor__name__in=['ZINC', 'ChEMBL', 'BindingDB', 'SureChEMBL', 'eMolecules', 'MolPort', 'PubChem'])) > 0 else 'No'
|
|
+
|
SELECT ••• "ligand_ligandvendorlink"."id", "ligand_ligandvendorlink"."vendor_id", "ligand_ligandvendorlink"."lp_id", "ligand_ligandvendorlink"."url", "ligand_ligandvendorlink"."vendor_external_id", "ligand_ligandvendorlink"."sid" FROM "ligand_ligandvendorlink" INNER JOIN "ligand_ligandvendors" ON ("ligand_ligandvendorlink"."vendor_id" = "ligand_ligandvendors"."id") WHERE ("ligand_ligandvendorlink"."lp_id" = 59663 AND NOT ("ligand_ligandvendors"."name" IN ('ZINC', 'ChEMBL', 'BindingDB', 'SureChEMBL', 'eMolecules', 'MolPort', 'PubChem')))
76 similar queries.
Duplicated 2 times.
|
|
1.69
|
|
|
Connection: default
/usr/lib/python3.6/concurrent/futures/thread.py in _worker(69)
work_item.run()
/usr/lib/python3.6/concurrent/futures/thread.py in run(56)
result = self.fn(*self.args, **self.kwargs)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle(279)
keepalive = self.handle_request(req, conn)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle_request(328)
respiter = self.wsgi(environ, resp.start_response)
/home/protwis/gpcrdb_test/common/middleware/stats.py in __call__(34)
response = self.get_response(request)
/home/protwis/gpcrdb_test/ligand/views.py in TargetDetails(359)
vendor__name__in=['ZINC', 'ChEMBL', 'BindingDB', 'SureChEMBL', 'eMolecules', 'MolPort', 'PubChem'])) > 0 else 'No'
|
|
+
|
SELECT ••• "ligand_ligandvendorlink"."id", "ligand_ligandvendorlink"."vendor_id", "ligand_ligandvendorlink"."lp_id", "ligand_ligandvendorlink"."url", "ligand_ligandvendorlink"."vendor_external_id", "ligand_ligandvendorlink"."sid" FROM "ligand_ligandvendorlink" INNER JOIN "ligand_ligandvendors" ON ("ligand_ligandvendorlink"."vendor_id" = "ligand_ligandvendors"."id") WHERE ("ligand_ligandvendorlink"."lp_id" = 59663 AND NOT ("ligand_ligandvendors"."name" IN ('ZINC', 'ChEMBL', 'BindingDB', 'SureChEMBL', 'eMolecules', 'MolPort', 'PubChem')))
76 similar queries.
Duplicated 2 times.
|
|
0.65
|
|
|
Connection: default
/usr/lib/python3.6/concurrent/futures/thread.py in _worker(69)
work_item.run()
/usr/lib/python3.6/concurrent/futures/thread.py in run(56)
result = self.fn(*self.args, **self.kwargs)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle(279)
keepalive = self.handle_request(req, conn)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle_request(328)
respiter = self.wsgi(environ, resp.start_response)
/home/protwis/gpcrdb_test/common/middleware/stats.py in __call__(34)
response = self.get_response(request)
/home/protwis/gpcrdb_test/ligand/views.py in TargetDetails(359)
vendor__name__in=['ZINC', 'ChEMBL', 'BindingDB', 'SureChEMBL', 'eMolecules', 'MolPort', 'PubChem'])) > 0 else 'No'
|
|
+
|
SELECT ••• "ligand_ligandvendorlink"."id", "ligand_ligandvendorlink"."vendor_id", "ligand_ligandvendorlink"."lp_id", "ligand_ligandvendorlink"."url", "ligand_ligandvendorlink"."vendor_external_id", "ligand_ligandvendorlink"."sid" FROM "ligand_ligandvendorlink" INNER JOIN "ligand_ligandvendors" ON ("ligand_ligandvendorlink"."vendor_id" = "ligand_ligandvendors"."id") WHERE ("ligand_ligandvendorlink"."lp_id" = 56103 AND NOT ("ligand_ligandvendors"."name" IN ('ZINC', 'ChEMBL', 'BindingDB', 'SureChEMBL', 'eMolecules', 'MolPort', 'PubChem')))
76 similar queries.
Duplicated 2 times.
|
|
1.76
|
|
|
Connection: default
/usr/lib/python3.6/concurrent/futures/thread.py in _worker(69)
work_item.run()
/usr/lib/python3.6/concurrent/futures/thread.py in run(56)
result = self.fn(*self.args, **self.kwargs)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle(279)
keepalive = self.handle_request(req, conn)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle_request(328)
respiter = self.wsgi(environ, resp.start_response)
/home/protwis/gpcrdb_test/common/middleware/stats.py in __call__(34)
response = self.get_response(request)
/home/protwis/gpcrdb_test/ligand/views.py in TargetDetails(359)
vendor__name__in=['ZINC', 'ChEMBL', 'BindingDB', 'SureChEMBL', 'eMolecules', 'MolPort', 'PubChem'])) > 0 else 'No'
|
|
+
|
SELECT ••• "ligand_ligandvendorlink"."id", "ligand_ligandvendorlink"."vendor_id", "ligand_ligandvendorlink"."lp_id", "ligand_ligandvendorlink"."url", "ligand_ligandvendorlink"."vendor_external_id", "ligand_ligandvendorlink"."sid" FROM "ligand_ligandvendorlink" INNER JOIN "ligand_ligandvendors" ON ("ligand_ligandvendorlink"."vendor_id" = "ligand_ligandvendors"."id") WHERE ("ligand_ligandvendorlink"."lp_id" = 56103 AND NOT ("ligand_ligandvendors"."name" IN ('ZINC', 'ChEMBL', 'BindingDB', 'SureChEMBL', 'eMolecules', 'MolPort', 'PubChem')))
76 similar queries.
Duplicated 2 times.
|
|
0.63
|
|
|
Connection: default
/usr/lib/python3.6/concurrent/futures/thread.py in _worker(69)
work_item.run()
/usr/lib/python3.6/concurrent/futures/thread.py in run(56)
result = self.fn(*self.args, **self.kwargs)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle(279)
keepalive = self.handle_request(req, conn)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle_request(328)
respiter = self.wsgi(environ, resp.start_response)
/home/protwis/gpcrdb_test/common/middleware/stats.py in __call__(34)
response = self.get_response(request)
/home/protwis/gpcrdb_test/ligand/views.py in TargetDetails(359)
vendor__name__in=['ZINC', 'ChEMBL', 'BindingDB', 'SureChEMBL', 'eMolecules', 'MolPort', 'PubChem'])) > 0 else 'No'
|
|
+
|
SELECT ••• "ligand_ligandvendorlink"."id", "ligand_ligandvendorlink"."vendor_id", "ligand_ligandvendorlink"."lp_id", "ligand_ligandvendorlink"."url", "ligand_ligandvendorlink"."vendor_external_id", "ligand_ligandvendorlink"."sid" FROM "ligand_ligandvendorlink" INNER JOIN "ligand_ligandvendors" ON ("ligand_ligandvendorlink"."vendor_id" = "ligand_ligandvendors"."id") WHERE ("ligand_ligandvendorlink"."lp_id" = 84201 AND NOT ("ligand_ligandvendors"."name" IN ('ZINC', 'ChEMBL', 'BindingDB', 'SureChEMBL', 'eMolecules', 'MolPort', 'PubChem')))
76 similar queries.
|
|
0.68
|
|
|
Connection: default
/usr/lib/python3.6/concurrent/futures/thread.py in _worker(69)
work_item.run()
/usr/lib/python3.6/concurrent/futures/thread.py in run(56)
result = self.fn(*self.args, **self.kwargs)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle(279)
keepalive = self.handle_request(req, conn)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle_request(328)
respiter = self.wsgi(environ, resp.start_response)
/home/protwis/gpcrdb_test/common/middleware/stats.py in __call__(34)
response = self.get_response(request)
/home/protwis/gpcrdb_test/ligand/views.py in TargetDetails(359)
vendor__name__in=['ZINC', 'ChEMBL', 'BindingDB', 'SureChEMBL', 'eMolecules', 'MolPort', 'PubChem'])) > 0 else 'No'
|
|
+
|
SELECT ••• "ligand_ligandvendorlink"."id", "ligand_ligandvendorlink"."vendor_id", "ligand_ligandvendorlink"."lp_id", "ligand_ligandvendorlink"."url", "ligand_ligandvendorlink"."vendor_external_id", "ligand_ligandvendorlink"."sid" FROM "ligand_ligandvendorlink" INNER JOIN "ligand_ligandvendors" ON ("ligand_ligandvendorlink"."vendor_id" = "ligand_ligandvendors"."id") WHERE ("ligand_ligandvendorlink"."lp_id" = 41319 AND NOT ("ligand_ligandvendors"."name" IN ('ZINC', 'ChEMBL', 'BindingDB', 'SureChEMBL', 'eMolecules', 'MolPort', 'PubChem')))
76 similar queries.
Duplicated 2 times.
|
|
2.52
|
|
|
Connection: default
/usr/lib/python3.6/concurrent/futures/thread.py in _worker(69)
work_item.run()
/usr/lib/python3.6/concurrent/futures/thread.py in run(56)
result = self.fn(*self.args, **self.kwargs)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle(279)
keepalive = self.handle_request(req, conn)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle_request(328)
respiter = self.wsgi(environ, resp.start_response)
/home/protwis/gpcrdb_test/common/middleware/stats.py in __call__(34)
response = self.get_response(request)
/home/protwis/gpcrdb_test/ligand/views.py in TargetDetails(359)
vendor__name__in=['ZINC', 'ChEMBL', 'BindingDB', 'SureChEMBL', 'eMolecules', 'MolPort', 'PubChem'])) > 0 else 'No'
|
|
+
|
SELECT ••• "ligand_ligandvendorlink"."id", "ligand_ligandvendorlink"."vendor_id", "ligand_ligandvendorlink"."lp_id", "ligand_ligandvendorlink"."url", "ligand_ligandvendorlink"."vendor_external_id", "ligand_ligandvendorlink"."sid" FROM "ligand_ligandvendorlink" INNER JOIN "ligand_ligandvendors" ON ("ligand_ligandvendorlink"."vendor_id" = "ligand_ligandvendors"."id") WHERE ("ligand_ligandvendorlink"."lp_id" = 41319 AND NOT ("ligand_ligandvendors"."name" IN ('ZINC', 'ChEMBL', 'BindingDB', 'SureChEMBL', 'eMolecules', 'MolPort', 'PubChem')))
76 similar queries.
Duplicated 2 times.
|
|
0.66
|
|
|
Connection: default
/usr/lib/python3.6/concurrent/futures/thread.py in _worker(69)
work_item.run()
/usr/lib/python3.6/concurrent/futures/thread.py in run(56)
result = self.fn(*self.args, **self.kwargs)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle(279)
keepalive = self.handle_request(req, conn)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle_request(328)
respiter = self.wsgi(environ, resp.start_response)
/home/protwis/gpcrdb_test/common/middleware/stats.py in __call__(34)
response = self.get_response(request)
/home/protwis/gpcrdb_test/ligand/views.py in TargetDetails(359)
vendor__name__in=['ZINC', 'ChEMBL', 'BindingDB', 'SureChEMBL', 'eMolecules', 'MolPort', 'PubChem'])) > 0 else 'No'
|
|
+
|
SELECT ••• "ligand_ligandvendorlink"."id", "ligand_ligandvendorlink"."vendor_id", "ligand_ligandvendorlink"."lp_id", "ligand_ligandvendorlink"."url", "ligand_ligandvendorlink"."vendor_external_id", "ligand_ligandvendorlink"."sid" FROM "ligand_ligandvendorlink" INNER JOIN "ligand_ligandvendors" ON ("ligand_ligandvendorlink"."vendor_id" = "ligand_ligandvendors"."id") WHERE ("ligand_ligandvendorlink"."lp_id" = 57182 AND NOT ("ligand_ligandvendors"."name" IN ('ZINC', 'ChEMBL', 'BindingDB', 'SureChEMBL', 'eMolecules', 'MolPort', 'PubChem')))
76 similar queries.
Duplicated 2 times.
|
|
1.83
|
|
|
Connection: default
/usr/lib/python3.6/concurrent/futures/thread.py in _worker(69)
work_item.run()
/usr/lib/python3.6/concurrent/futures/thread.py in run(56)
result = self.fn(*self.args, **self.kwargs)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle(279)
keepalive = self.handle_request(req, conn)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle_request(328)
respiter = self.wsgi(environ, resp.start_response)
/home/protwis/gpcrdb_test/common/middleware/stats.py in __call__(34)
response = self.get_response(request)
/home/protwis/gpcrdb_test/ligand/views.py in TargetDetails(359)
vendor__name__in=['ZINC', 'ChEMBL', 'BindingDB', 'SureChEMBL', 'eMolecules', 'MolPort', 'PubChem'])) > 0 else 'No'
|
|
+
|
SELECT ••• "ligand_ligandvendorlink"."id", "ligand_ligandvendorlink"."vendor_id", "ligand_ligandvendorlink"."lp_id", "ligand_ligandvendorlink"."url", "ligand_ligandvendorlink"."vendor_external_id", "ligand_ligandvendorlink"."sid" FROM "ligand_ligandvendorlink" INNER JOIN "ligand_ligandvendors" ON ("ligand_ligandvendorlink"."vendor_id" = "ligand_ligandvendors"."id") WHERE ("ligand_ligandvendorlink"."lp_id" = 57182 AND NOT ("ligand_ligandvendors"."name" IN ('ZINC', 'ChEMBL', 'BindingDB', 'SureChEMBL', 'eMolecules', 'MolPort', 'PubChem')))
76 similar queries.
Duplicated 2 times.
|
|
0.66
|
|
|
Connection: default
/usr/lib/python3.6/concurrent/futures/thread.py in _worker(69)
work_item.run()
/usr/lib/python3.6/concurrent/futures/thread.py in run(56)
result = self.fn(*self.args, **self.kwargs)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle(279)
keepalive = self.handle_request(req, conn)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle_request(328)
respiter = self.wsgi(environ, resp.start_response)
/home/protwis/gpcrdb_test/common/middleware/stats.py in __call__(34)
response = self.get_response(request)
/home/protwis/gpcrdb_test/ligand/views.py in TargetDetails(359)
vendor__name__in=['ZINC', 'ChEMBL', 'BindingDB', 'SureChEMBL', 'eMolecules', 'MolPort', 'PubChem'])) > 0 else 'No'
|
|
+
|
SELECT ••• "ligand_ligandvendorlink"."id", "ligand_ligandvendorlink"."vendor_id", "ligand_ligandvendorlink"."lp_id", "ligand_ligandvendorlink"."url", "ligand_ligandvendorlink"."vendor_external_id", "ligand_ligandvendorlink"."sid" FROM "ligand_ligandvendorlink" INNER JOIN "ligand_ligandvendors" ON ("ligand_ligandvendorlink"."vendor_id" = "ligand_ligandvendors"."id") WHERE ("ligand_ligandvendorlink"."lp_id" = 3855 AND NOT ("ligand_ligandvendors"."name" IN ('ZINC', 'ChEMBL', 'BindingDB', 'SureChEMBL', 'eMolecules', 'MolPort', 'PubChem')))
76 similar queries.
|
|
0.72
|
|
|
Connection: default
/usr/lib/python3.6/concurrent/futures/thread.py in _worker(69)
work_item.run()
/usr/lib/python3.6/concurrent/futures/thread.py in run(56)
result = self.fn(*self.args, **self.kwargs)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle(279)
keepalive = self.handle_request(req, conn)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle_request(328)
respiter = self.wsgi(environ, resp.start_response)
/home/protwis/gpcrdb_test/common/middleware/stats.py in __call__(34)
response = self.get_response(request)
/home/protwis/gpcrdb_test/ligand/views.py in TargetDetails(359)
vendor__name__in=['ZINC', 'ChEMBL', 'BindingDB', 'SureChEMBL', 'eMolecules', 'MolPort', 'PubChem'])) > 0 else 'No'
|
|
+
|
SELECT ••• "ligand_ligandvendorlink"."id", "ligand_ligandvendorlink"."vendor_id", "ligand_ligandvendorlink"."lp_id", "ligand_ligandvendorlink"."url", "ligand_ligandvendorlink"."vendor_external_id", "ligand_ligandvendorlink"."sid" FROM "ligand_ligandvendorlink" INNER JOIN "ligand_ligandvendors" ON ("ligand_ligandvendorlink"."vendor_id" = "ligand_ligandvendors"."id") WHERE ("ligand_ligandvendorlink"."lp_id" = 59424 AND NOT ("ligand_ligandvendors"."name" IN ('ZINC', 'ChEMBL', 'BindingDB', 'SureChEMBL', 'eMolecules', 'MolPort', 'PubChem')))
76 similar queries.
Duplicated 2 times.
|
|
0.69
|
|
|
Connection: default
/usr/lib/python3.6/concurrent/futures/thread.py in _worker(69)
work_item.run()
/usr/lib/python3.6/concurrent/futures/thread.py in run(56)
result = self.fn(*self.args, **self.kwargs)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle(279)
keepalive = self.handle_request(req, conn)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle_request(328)
respiter = self.wsgi(environ, resp.start_response)
/home/protwis/gpcrdb_test/common/middleware/stats.py in __call__(34)
response = self.get_response(request)
/home/protwis/gpcrdb_test/ligand/views.py in TargetDetails(359)
vendor__name__in=['ZINC', 'ChEMBL', 'BindingDB', 'SureChEMBL', 'eMolecules', 'MolPort', 'PubChem'])) > 0 else 'No'
|
|
+
|
SELECT ••• "ligand_ligandvendorlink"."id", "ligand_ligandvendorlink"."vendor_id", "ligand_ligandvendorlink"."lp_id", "ligand_ligandvendorlink"."url", "ligand_ligandvendorlink"."vendor_external_id", "ligand_ligandvendorlink"."sid" FROM "ligand_ligandvendorlink" INNER JOIN "ligand_ligandvendors" ON ("ligand_ligandvendorlink"."vendor_id" = "ligand_ligandvendors"."id") WHERE ("ligand_ligandvendorlink"."lp_id" = 59424 AND NOT ("ligand_ligandvendors"."name" IN ('ZINC', 'ChEMBL', 'BindingDB', 'SureChEMBL', 'eMolecules', 'MolPort', 'PubChem')))
76 similar queries.
Duplicated 2 times.
|
|
0.64
|
|
|
Connection: default
/usr/lib/python3.6/concurrent/futures/thread.py in _worker(69)
work_item.run()
/usr/lib/python3.6/concurrent/futures/thread.py in run(56)
result = self.fn(*self.args, **self.kwargs)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle(279)
keepalive = self.handle_request(req, conn)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle_request(328)
respiter = self.wsgi(environ, resp.start_response)
/home/protwis/gpcrdb_test/common/middleware/stats.py in __call__(34)
response = self.get_response(request)
/home/protwis/gpcrdb_test/ligand/views.py in TargetDetails(359)
vendor__name__in=['ZINC', 'ChEMBL', 'BindingDB', 'SureChEMBL', 'eMolecules', 'MolPort', 'PubChem'])) > 0 else 'No'
|
|
+
|
SELECT ••• "ligand_ligandvendorlink"."id", "ligand_ligandvendorlink"."vendor_id", "ligand_ligandvendorlink"."lp_id", "ligand_ligandvendorlink"."url", "ligand_ligandvendorlink"."vendor_external_id", "ligand_ligandvendorlink"."sid" FROM "ligand_ligandvendorlink" INNER JOIN "ligand_ligandvendors" ON ("ligand_ligandvendorlink"."vendor_id" = "ligand_ligandvendors"."id") WHERE ("ligand_ligandvendorlink"."lp_id" = 141345 AND NOT ("ligand_ligandvendors"."name" IN ('ZINC', 'ChEMBL', 'BindingDB', 'SureChEMBL', 'eMolecules', 'MolPort', 'PubChem')))
76 similar queries.
Duplicated 2 times.
|
|
0.68
|
|
|
Connection: default
/usr/lib/python3.6/concurrent/futures/thread.py in _worker(69)
work_item.run()
/usr/lib/python3.6/concurrent/futures/thread.py in run(56)
result = self.fn(*self.args, **self.kwargs)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle(279)
keepalive = self.handle_request(req, conn)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle_request(328)
respiter = self.wsgi(environ, resp.start_response)
/home/protwis/gpcrdb_test/common/middleware/stats.py in __call__(34)
response = self.get_response(request)
/home/protwis/gpcrdb_test/ligand/views.py in TargetDetails(359)
vendor__name__in=['ZINC', 'ChEMBL', 'BindingDB', 'SureChEMBL', 'eMolecules', 'MolPort', 'PubChem'])) > 0 else 'No'
|
|
+
|
SELECT ••• "ligand_ligandvendorlink"."id", "ligand_ligandvendorlink"."vendor_id", "ligand_ligandvendorlink"."lp_id", "ligand_ligandvendorlink"."url", "ligand_ligandvendorlink"."vendor_external_id", "ligand_ligandvendorlink"."sid" FROM "ligand_ligandvendorlink" INNER JOIN "ligand_ligandvendors" ON ("ligand_ligandvendorlink"."vendor_id" = "ligand_ligandvendors"."id") WHERE ("ligand_ligandvendorlink"."lp_id" = 141345 AND NOT ("ligand_ligandvendors"."name" IN ('ZINC', 'ChEMBL', 'BindingDB', 'SureChEMBL', 'eMolecules', 'MolPort', 'PubChem')))
76 similar queries.
Duplicated 2 times.
|
|
0.64
|
|
|
Connection: default
/usr/lib/python3.6/concurrent/futures/thread.py in _worker(69)
work_item.run()
/usr/lib/python3.6/concurrent/futures/thread.py in run(56)
result = self.fn(*self.args, **self.kwargs)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle(279)
keepalive = self.handle_request(req, conn)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle_request(328)
respiter = self.wsgi(environ, resp.start_response)
/home/protwis/gpcrdb_test/common/middleware/stats.py in __call__(34)
response = self.get_response(request)
/home/protwis/gpcrdb_test/ligand/views.py in TargetDetails(359)
vendor__name__in=['ZINC', 'ChEMBL', 'BindingDB', 'SureChEMBL', 'eMolecules', 'MolPort', 'PubChem'])) > 0 else 'No'
|
|
+
|
SELECT ••• "ligand_ligandvendorlink"."id", "ligand_ligandvendorlink"."vendor_id", "ligand_ligandvendorlink"."lp_id", "ligand_ligandvendorlink"."url", "ligand_ligandvendorlink"."vendor_external_id", "ligand_ligandvendorlink"."sid" FROM "ligand_ligandvendorlink" INNER JOIN "ligand_ligandvendors" ON ("ligand_ligandvendorlink"."vendor_id" = "ligand_ligandvendors"."id") WHERE ("ligand_ligandvendorlink"."lp_id" = 83731 AND NOT ("ligand_ligandvendors"."name" IN ('ZINC', 'ChEMBL', 'BindingDB', 'SureChEMBL', 'eMolecules', 'MolPort', 'PubChem')))
76 similar queries.
Duplicated 3 times.
|
|
0.68
|
|
|
Connection: default
/usr/lib/python3.6/concurrent/futures/thread.py in _worker(69)
work_item.run()
/usr/lib/python3.6/concurrent/futures/thread.py in run(56)
result = self.fn(*self.args, **self.kwargs)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle(279)
keepalive = self.handle_request(req, conn)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle_request(328)
respiter = self.wsgi(environ, resp.start_response)
/home/protwis/gpcrdb_test/common/middleware/stats.py in __call__(34)
response = self.get_response(request)
/home/protwis/gpcrdb_test/ligand/views.py in TargetDetails(359)
vendor__name__in=['ZINC', 'ChEMBL', 'BindingDB', 'SureChEMBL', 'eMolecules', 'MolPort', 'PubChem'])) > 0 else 'No'
|
|
+
|
SELECT ••• "ligand_ligandvendorlink"."id", "ligand_ligandvendorlink"."vendor_id", "ligand_ligandvendorlink"."lp_id", "ligand_ligandvendorlink"."url", "ligand_ligandvendorlink"."vendor_external_id", "ligand_ligandvendorlink"."sid" FROM "ligand_ligandvendorlink" INNER JOIN "ligand_ligandvendors" ON ("ligand_ligandvendorlink"."vendor_id" = "ligand_ligandvendors"."id") WHERE ("ligand_ligandvendorlink"."lp_id" = 83731 AND NOT ("ligand_ligandvendors"."name" IN ('ZINC', 'ChEMBL', 'BindingDB', 'SureChEMBL', 'eMolecules', 'MolPort', 'PubChem')))
76 similar queries.
Duplicated 3 times.
|
|
0.66
|
|
|
Connection: default
/usr/lib/python3.6/concurrent/futures/thread.py in _worker(69)
work_item.run()
/usr/lib/python3.6/concurrent/futures/thread.py in run(56)
result = self.fn(*self.args, **self.kwargs)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle(279)
keepalive = self.handle_request(req, conn)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle_request(328)
respiter = self.wsgi(environ, resp.start_response)
/home/protwis/gpcrdb_test/common/middleware/stats.py in __call__(34)
response = self.get_response(request)
/home/protwis/gpcrdb_test/ligand/views.py in TargetDetails(359)
vendor__name__in=['ZINC', 'ChEMBL', 'BindingDB', 'SureChEMBL', 'eMolecules', 'MolPort', 'PubChem'])) > 0 else 'No'
|
|
+
|
SELECT ••• "ligand_ligandvendorlink"."id", "ligand_ligandvendorlink"."vendor_id", "ligand_ligandvendorlink"."lp_id", "ligand_ligandvendorlink"."url", "ligand_ligandvendorlink"."vendor_external_id", "ligand_ligandvendorlink"."sid" FROM "ligand_ligandvendorlink" INNER JOIN "ligand_ligandvendors" ON ("ligand_ligandvendorlink"."vendor_id" = "ligand_ligandvendors"."id") WHERE ("ligand_ligandvendorlink"."lp_id" = 83731 AND NOT ("ligand_ligandvendors"."name" IN ('ZINC', 'ChEMBL', 'BindingDB', 'SureChEMBL', 'eMolecules', 'MolPort', 'PubChem')))
76 similar queries.
Duplicated 3 times.
|
|
0.62
|
|
|
Connection: default
/usr/lib/python3.6/concurrent/futures/thread.py in _worker(69)
work_item.run()
/usr/lib/python3.6/concurrent/futures/thread.py in run(56)
result = self.fn(*self.args, **self.kwargs)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle(279)
keepalive = self.handle_request(req, conn)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle_request(328)
respiter = self.wsgi(environ, resp.start_response)
/home/protwis/gpcrdb_test/common/middleware/stats.py in __call__(34)
response = self.get_response(request)
/home/protwis/gpcrdb_test/ligand/views.py in TargetDetails(359)
vendor__name__in=['ZINC', 'ChEMBL', 'BindingDB', 'SureChEMBL', 'eMolecules', 'MolPort', 'PubChem'])) > 0 else 'No'
|
|
+
|
SELECT ••• "ligand_ligandvendorlink"."id", "ligand_ligandvendorlink"."vendor_id", "ligand_ligandvendorlink"."lp_id", "ligand_ligandvendorlink"."url", "ligand_ligandvendorlink"."vendor_external_id", "ligand_ligandvendorlink"."sid" FROM "ligand_ligandvendorlink" INNER JOIN "ligand_ligandvendors" ON ("ligand_ligandvendorlink"."vendor_id" = "ligand_ligandvendors"."id") WHERE ("ligand_ligandvendorlink"."lp_id" = 26466 AND NOT ("ligand_ligandvendors"."name" IN ('ZINC', 'ChEMBL', 'BindingDB', 'SureChEMBL', 'eMolecules', 'MolPort', 'PubChem')))
76 similar queries.
|
|
0.79
|
|
|
Connection: default
/usr/lib/python3.6/concurrent/futures/thread.py in _worker(69)
work_item.run()
/usr/lib/python3.6/concurrent/futures/thread.py in run(56)
result = self.fn(*self.args, **self.kwargs)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle(279)
keepalive = self.handle_request(req, conn)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle_request(328)
respiter = self.wsgi(environ, resp.start_response)
/home/protwis/gpcrdb_test/common/middleware/stats.py in __call__(34)
response = self.get_response(request)
/home/protwis/gpcrdb_test/ligand/views.py in TargetDetails(359)
vendor__name__in=['ZINC', 'ChEMBL', 'BindingDB', 'SureChEMBL', 'eMolecules', 'MolPort', 'PubChem'])) > 0 else 'No'
|
|
+
|
SELECT ••• "ligand_ligandvendorlink"."id", "ligand_ligandvendorlink"."vendor_id", "ligand_ligandvendorlink"."lp_id", "ligand_ligandvendorlink"."url", "ligand_ligandvendorlink"."vendor_external_id", "ligand_ligandvendorlink"."sid" FROM "ligand_ligandvendorlink" INNER JOIN "ligand_ligandvendors" ON ("ligand_ligandvendorlink"."vendor_id" = "ligand_ligandvendors"."id") WHERE ("ligand_ligandvendorlink"."lp_id" = 94150 AND NOT ("ligand_ligandvendors"."name" IN ('ZINC', 'ChEMBL', 'BindingDB', 'SureChEMBL', 'eMolecules', 'MolPort', 'PubChem')))
76 similar queries.
|
|
0.66
|
|
|
Connection: default
/usr/lib/python3.6/concurrent/futures/thread.py in _worker(69)
work_item.run()
/usr/lib/python3.6/concurrent/futures/thread.py in run(56)
result = self.fn(*self.args, **self.kwargs)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle(279)
keepalive = self.handle_request(req, conn)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle_request(328)
respiter = self.wsgi(environ, resp.start_response)
/home/protwis/gpcrdb_test/common/middleware/stats.py in __call__(34)
response = self.get_response(request)
/home/protwis/gpcrdb_test/ligand/views.py in TargetDetails(359)
vendor__name__in=['ZINC', 'ChEMBL', 'BindingDB', 'SureChEMBL', 'eMolecules', 'MolPort', 'PubChem'])) > 0 else 'No'
|
|
+
|
SELECT ••• "ligand_ligandvendorlink"."id", "ligand_ligandvendorlink"."vendor_id", "ligand_ligandvendorlink"."lp_id", "ligand_ligandvendorlink"."url", "ligand_ligandvendorlink"."vendor_external_id", "ligand_ligandvendorlink"."sid" FROM "ligand_ligandvendorlink" INNER JOIN "ligand_ligandvendors" ON ("ligand_ligandvendorlink"."vendor_id" = "ligand_ligandvendors"."id") WHERE ("ligand_ligandvendorlink"."lp_id" = 52138 AND NOT ("ligand_ligandvendors"."name" IN ('ZINC', 'ChEMBL', 'BindingDB', 'SureChEMBL', 'eMolecules', 'MolPort', 'PubChem')))
76 similar queries.
Duplicated 2 times.
|
|
0.66
|
|
|
Connection: default
/usr/lib/python3.6/concurrent/futures/thread.py in _worker(69)
work_item.run()
/usr/lib/python3.6/concurrent/futures/thread.py in run(56)
result = self.fn(*self.args, **self.kwargs)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle(279)
keepalive = self.handle_request(req, conn)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle_request(328)
respiter = self.wsgi(environ, resp.start_response)
/home/protwis/gpcrdb_test/common/middleware/stats.py in __call__(34)
response = self.get_response(request)
/home/protwis/gpcrdb_test/ligand/views.py in TargetDetails(359)
vendor__name__in=['ZINC', 'ChEMBL', 'BindingDB', 'SureChEMBL', 'eMolecules', 'MolPort', 'PubChem'])) > 0 else 'No'
|
|
+
|
SELECT ••• "ligand_ligandvendorlink"."id", "ligand_ligandvendorlink"."vendor_id", "ligand_ligandvendorlink"."lp_id", "ligand_ligandvendorlink"."url", "ligand_ligandvendorlink"."vendor_external_id", "ligand_ligandvendorlink"."sid" FROM "ligand_ligandvendorlink" INNER JOIN "ligand_ligandvendors" ON ("ligand_ligandvendorlink"."vendor_id" = "ligand_ligandvendors"."id") WHERE ("ligand_ligandvendorlink"."lp_id" = 52138 AND NOT ("ligand_ligandvendors"."name" IN ('ZINC', 'ChEMBL', 'BindingDB', 'SureChEMBL', 'eMolecules', 'MolPort', 'PubChem')))
76 similar queries.
Duplicated 2 times.
|
|
0.62
|
|
|
Connection: default
/usr/lib/python3.6/concurrent/futures/thread.py in _worker(69)
work_item.run()
/usr/lib/python3.6/concurrent/futures/thread.py in run(56)
result = self.fn(*self.args, **self.kwargs)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle(279)
keepalive = self.handle_request(req, conn)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle_request(328)
respiter = self.wsgi(environ, resp.start_response)
/home/protwis/gpcrdb_test/common/middleware/stats.py in __call__(34)
response = self.get_response(request)
/home/protwis/gpcrdb_test/ligand/views.py in TargetDetails(359)
vendor__name__in=['ZINC', 'ChEMBL', 'BindingDB', 'SureChEMBL', 'eMolecules', 'MolPort', 'PubChem'])) > 0 else 'No'
|
|
+
|
SELECT ••• "ligand_ligandvendorlink"."id", "ligand_ligandvendorlink"."vendor_id", "ligand_ligandvendorlink"."lp_id", "ligand_ligandvendorlink"."url", "ligand_ligandvendorlink"."vendor_external_id", "ligand_ligandvendorlink"."sid" FROM "ligand_ligandvendorlink" INNER JOIN "ligand_ligandvendors" ON ("ligand_ligandvendorlink"."vendor_id" = "ligand_ligandvendors"."id") WHERE ("ligand_ligandvendorlink"."lp_id" = 56105 AND NOT ("ligand_ligandvendors"."name" IN ('ZINC', 'ChEMBL', 'BindingDB', 'SureChEMBL', 'eMolecules', 'MolPort', 'PubChem')))
76 similar queries.
|
|
0.66
|
|
|
Connection: default
/usr/lib/python3.6/concurrent/futures/thread.py in _worker(69)
work_item.run()
/usr/lib/python3.6/concurrent/futures/thread.py in run(56)
result = self.fn(*self.args, **self.kwargs)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle(279)
keepalive = self.handle_request(req, conn)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle_request(328)
respiter = self.wsgi(environ, resp.start_response)
/home/protwis/gpcrdb_test/common/middleware/stats.py in __call__(34)
response = self.get_response(request)
/home/protwis/gpcrdb_test/ligand/views.py in TargetDetails(359)
vendor__name__in=['ZINC', 'ChEMBL', 'BindingDB', 'SureChEMBL', 'eMolecules', 'MolPort', 'PubChem'])) > 0 else 'No'
|
|
+
|
SELECT ••• "ligand_ligandvendorlink"."id", "ligand_ligandvendorlink"."vendor_id", "ligand_ligandvendorlink"."lp_id", "ligand_ligandvendorlink"."url", "ligand_ligandvendorlink"."vendor_external_id", "ligand_ligandvendorlink"."sid" FROM "ligand_ligandvendorlink" INNER JOIN "ligand_ligandvendors" ON ("ligand_ligandvendorlink"."vendor_id" = "ligand_ligandvendors"."id") WHERE ("ligand_ligandvendorlink"."lp_id" = 96760 AND NOT ("ligand_ligandvendors"."name" IN ('ZINC', 'ChEMBL', 'BindingDB', 'SureChEMBL', 'eMolecules', 'MolPort', 'PubChem')))
76 similar queries.
Duplicated 2 times.
|
|
0.67
|
|
|
Connection: default
/usr/lib/python3.6/concurrent/futures/thread.py in _worker(69)
work_item.run()
/usr/lib/python3.6/concurrent/futures/thread.py in run(56)
result = self.fn(*self.args, **self.kwargs)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle(279)
keepalive = self.handle_request(req, conn)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle_request(328)
respiter = self.wsgi(environ, resp.start_response)
/home/protwis/gpcrdb_test/common/middleware/stats.py in __call__(34)
response = self.get_response(request)
/home/protwis/gpcrdb_test/ligand/views.py in TargetDetails(359)
vendor__name__in=['ZINC', 'ChEMBL', 'BindingDB', 'SureChEMBL', 'eMolecules', 'MolPort', 'PubChem'])) > 0 else 'No'
|
|
+
|
SELECT ••• "ligand_ligandvendorlink"."id", "ligand_ligandvendorlink"."vendor_id", "ligand_ligandvendorlink"."lp_id", "ligand_ligandvendorlink"."url", "ligand_ligandvendorlink"."vendor_external_id", "ligand_ligandvendorlink"."sid" FROM "ligand_ligandvendorlink" INNER JOIN "ligand_ligandvendors" ON ("ligand_ligandvendorlink"."vendor_id" = "ligand_ligandvendors"."id") WHERE ("ligand_ligandvendorlink"."lp_id" = 96760 AND NOT ("ligand_ligandvendors"."name" IN ('ZINC', 'ChEMBL', 'BindingDB', 'SureChEMBL', 'eMolecules', 'MolPort', 'PubChem')))
76 similar queries.
Duplicated 2 times.
|
|
0.65
|
|
|
Connection: default
/usr/lib/python3.6/concurrent/futures/thread.py in _worker(69)
work_item.run()
/usr/lib/python3.6/concurrent/futures/thread.py in run(56)
result = self.fn(*self.args, **self.kwargs)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle(279)
keepalive = self.handle_request(req, conn)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle_request(328)
respiter = self.wsgi(environ, resp.start_response)
/home/protwis/gpcrdb_test/common/middleware/stats.py in __call__(34)
response = self.get_response(request)
/home/protwis/gpcrdb_test/ligand/views.py in TargetDetails(359)
vendor__name__in=['ZINC', 'ChEMBL', 'BindingDB', 'SureChEMBL', 'eMolecules', 'MolPort', 'PubChem'])) > 0 else 'No'
|
|
+
|
SELECT ••• "ligand_ligandvendorlink"."id", "ligand_ligandvendorlink"."vendor_id", "ligand_ligandvendorlink"."lp_id", "ligand_ligandvendorlink"."url", "ligand_ligandvendorlink"."vendor_external_id", "ligand_ligandvendorlink"."sid" FROM "ligand_ligandvendorlink" INNER JOIN "ligand_ligandvendors" ON ("ligand_ligandvendorlink"."vendor_id" = "ligand_ligandvendors"."id") WHERE ("ligand_ligandvendorlink"."lp_id" = 96014 AND NOT ("ligand_ligandvendors"."name" IN ('ZINC', 'ChEMBL', 'BindingDB', 'SureChEMBL', 'eMolecules', 'MolPort', 'PubChem')))
76 similar queries.
|
|
0.67
|
|
|
Connection: default
/usr/lib/python3.6/concurrent/futures/thread.py in _worker(69)
work_item.run()
/usr/lib/python3.6/concurrent/futures/thread.py in run(56)
result = self.fn(*self.args, **self.kwargs)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle(279)
keepalive = self.handle_request(req, conn)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle_request(328)
respiter = self.wsgi(environ, resp.start_response)
/home/protwis/gpcrdb_test/common/middleware/stats.py in __call__(34)
response = self.get_response(request)
/home/protwis/gpcrdb_test/ligand/views.py in TargetDetails(359)
vendor__name__in=['ZINC', 'ChEMBL', 'BindingDB', 'SureChEMBL', 'eMolecules', 'MolPort', 'PubChem'])) > 0 else 'No'
|
|
+
|
SELECT ••• "ligand_ligandvendorlink"."id", "ligand_ligandvendorlink"."vendor_id", "ligand_ligandvendorlink"."lp_id", "ligand_ligandvendorlink"."url", "ligand_ligandvendorlink"."vendor_external_id", "ligand_ligandvendorlink"."sid" FROM "ligand_ligandvendorlink" INNER JOIN "ligand_ligandvendors" ON ("ligand_ligandvendorlink"."vendor_id" = "ligand_ligandvendors"."id") WHERE ("ligand_ligandvendorlink"."lp_id" = 26049 AND NOT ("ligand_ligandvendors"."name" IN ('ZINC', 'ChEMBL', 'BindingDB', 'SureChEMBL', 'eMolecules', 'MolPort', 'PubChem')))
76 similar queries.
|
|
0.65
|
|
|
Connection: default
/usr/lib/python3.6/concurrent/futures/thread.py in _worker(69)
work_item.run()
/usr/lib/python3.6/concurrent/futures/thread.py in run(56)
result = self.fn(*self.args, **self.kwargs)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle(279)
keepalive = self.handle_request(req, conn)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle_request(328)
respiter = self.wsgi(environ, resp.start_response)
/home/protwis/gpcrdb_test/common/middleware/stats.py in __call__(34)
response = self.get_response(request)
/home/protwis/gpcrdb_test/ligand/views.py in TargetDetails(359)
vendor__name__in=['ZINC', 'ChEMBL', 'BindingDB', 'SureChEMBL', 'eMolecules', 'MolPort', 'PubChem'])) > 0 else 'No'
|
|
+
|
SELECT ••• "ligand_ligandvendorlink"."id", "ligand_ligandvendorlink"."vendor_id", "ligand_ligandvendorlink"."lp_id", "ligand_ligandvendorlink"."url", "ligand_ligandvendorlink"."vendor_external_id", "ligand_ligandvendorlink"."sid" FROM "ligand_ligandvendorlink" INNER JOIN "ligand_ligandvendors" ON ("ligand_ligandvendorlink"."vendor_id" = "ligand_ligandvendors"."id") WHERE ("ligand_ligandvendorlink"."lp_id" = 97756 AND NOT ("ligand_ligandvendors"."name" IN ('ZINC', 'ChEMBL', 'BindingDB', 'SureChEMBL', 'eMolecules', 'MolPort', 'PubChem')))
76 similar queries.
|
|
0.74
|
|
|
Connection: default
/usr/lib/python3.6/concurrent/futures/thread.py in _worker(69)
work_item.run()
/usr/lib/python3.6/concurrent/futures/thread.py in run(56)
result = self.fn(*self.args, **self.kwargs)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle(279)
keepalive = self.handle_request(req, conn)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle_request(328)
respiter = self.wsgi(environ, resp.start_response)
/home/protwis/gpcrdb_test/common/middleware/stats.py in __call__(34)
response = self.get_response(request)
/home/protwis/gpcrdb_test/ligand/views.py in TargetDetails(359)
vendor__name__in=['ZINC', 'ChEMBL', 'BindingDB', 'SureChEMBL', 'eMolecules', 'MolPort', 'PubChem'])) > 0 else 'No'
|
|
+
|
SELECT ••• "ligand_ligandvendorlink"."id", "ligand_ligandvendorlink"."vendor_id", "ligand_ligandvendorlink"."lp_id", "ligand_ligandvendorlink"."url", "ligand_ligandvendorlink"."vendor_external_id", "ligand_ligandvendorlink"."sid" FROM "ligand_ligandvendorlink" INNER JOIN "ligand_ligandvendors" ON ("ligand_ligandvendorlink"."vendor_id" = "ligand_ligandvendors"."id") WHERE ("ligand_ligandvendorlink"."lp_id" = 14405 AND NOT ("ligand_ligandvendors"."name" IN ('ZINC', 'ChEMBL', 'BindingDB', 'SureChEMBL', 'eMolecules', 'MolPort', 'PubChem')))
76 similar queries.
|
|
0.68
|
|
|
Connection: default
/usr/lib/python3.6/concurrent/futures/thread.py in _worker(69)
work_item.run()
/usr/lib/python3.6/concurrent/futures/thread.py in run(56)
result = self.fn(*self.args, **self.kwargs)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle(279)
keepalive = self.handle_request(req, conn)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle_request(328)
respiter = self.wsgi(environ, resp.start_response)
/home/protwis/gpcrdb_test/common/middleware/stats.py in __call__(34)
response = self.get_response(request)
/home/protwis/gpcrdb_test/ligand/views.py in TargetDetails(359)
vendor__name__in=['ZINC', 'ChEMBL', 'BindingDB', 'SureChEMBL', 'eMolecules', 'MolPort', 'PubChem'])) > 0 else 'No'
|
|
+
|
SELECT ••• "ligand_ligandvendorlink"."id", "ligand_ligandvendorlink"."vendor_id", "ligand_ligandvendorlink"."lp_id", "ligand_ligandvendorlink"."url", "ligand_ligandvendorlink"."vendor_external_id", "ligand_ligandvendorlink"."sid" FROM "ligand_ligandvendorlink" INNER JOIN "ligand_ligandvendors" ON ("ligand_ligandvendorlink"."vendor_id" = "ligand_ligandvendors"."id") WHERE ("ligand_ligandvendorlink"."lp_id" = 135532 AND NOT ("ligand_ligandvendors"."name" IN ('ZINC', 'ChEMBL', 'BindingDB', 'SureChEMBL', 'eMolecules', 'MolPort', 'PubChem')))
76 similar queries.
Duplicated 2 times.
|
|
0.65
|
|
|
Connection: default
/usr/lib/python3.6/concurrent/futures/thread.py in _worker(69)
work_item.run()
/usr/lib/python3.6/concurrent/futures/thread.py in run(56)
result = self.fn(*self.args, **self.kwargs)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle(279)
keepalive = self.handle_request(req, conn)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle_request(328)
respiter = self.wsgi(environ, resp.start_response)
/home/protwis/gpcrdb_test/common/middleware/stats.py in __call__(34)
response = self.get_response(request)
/home/protwis/gpcrdb_test/ligand/views.py in TargetDetails(359)
vendor__name__in=['ZINC', 'ChEMBL', 'BindingDB', 'SureChEMBL', 'eMolecules', 'MolPort', 'PubChem'])) > 0 else 'No'
|
|
+
|
SELECT ••• "ligand_ligandvendorlink"."id", "ligand_ligandvendorlink"."vendor_id", "ligand_ligandvendorlink"."lp_id", "ligand_ligandvendorlink"."url", "ligand_ligandvendorlink"."vendor_external_id", "ligand_ligandvendorlink"."sid" FROM "ligand_ligandvendorlink" INNER JOIN "ligand_ligandvendors" ON ("ligand_ligandvendorlink"."vendor_id" = "ligand_ligandvendors"."id") WHERE ("ligand_ligandvendorlink"."lp_id" = 20174 AND NOT ("ligand_ligandvendors"."name" IN ('ZINC', 'ChEMBL', 'BindingDB', 'SureChEMBL', 'eMolecules', 'MolPort', 'PubChem')))
76 similar queries.
|
|
0.63
|
|
|
Connection: default
/usr/lib/python3.6/concurrent/futures/thread.py in _worker(69)
work_item.run()
/usr/lib/python3.6/concurrent/futures/thread.py in run(56)
result = self.fn(*self.args, **self.kwargs)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle(279)
keepalive = self.handle_request(req, conn)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle_request(328)
respiter = self.wsgi(environ, resp.start_response)
/home/protwis/gpcrdb_test/common/middleware/stats.py in __call__(34)
response = self.get_response(request)
/home/protwis/gpcrdb_test/ligand/views.py in TargetDetails(359)
vendor__name__in=['ZINC', 'ChEMBL', 'BindingDB', 'SureChEMBL', 'eMolecules', 'MolPort', 'PubChem'])) > 0 else 'No'
|
|
+
|
SELECT ••• "ligand_ligandvendorlink"."id", "ligand_ligandvendorlink"."vendor_id", "ligand_ligandvendorlink"."lp_id", "ligand_ligandvendorlink"."url", "ligand_ligandvendorlink"."vendor_external_id", "ligand_ligandvendorlink"."sid" FROM "ligand_ligandvendorlink" INNER JOIN "ligand_ligandvendors" ON ("ligand_ligandvendorlink"."vendor_id" = "ligand_ligandvendors"."id") WHERE ("ligand_ligandvendorlink"."lp_id" = 19480 AND NOT ("ligand_ligandvendors"."name" IN ('ZINC', 'ChEMBL', 'BindingDB', 'SureChEMBL', 'eMolecules', 'MolPort', 'PubChem')))
76 similar queries.
|
|
0.65
|
|
|
Connection: default
/usr/lib/python3.6/concurrent/futures/thread.py in _worker(69)
work_item.run()
/usr/lib/python3.6/concurrent/futures/thread.py in run(56)
result = self.fn(*self.args, **self.kwargs)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle(279)
keepalive = self.handle_request(req, conn)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle_request(328)
respiter = self.wsgi(environ, resp.start_response)
/home/protwis/gpcrdb_test/common/middleware/stats.py in __call__(34)
response = self.get_response(request)
/home/protwis/gpcrdb_test/ligand/views.py in TargetDetails(359)
vendor__name__in=['ZINC', 'ChEMBL', 'BindingDB', 'SureChEMBL', 'eMolecules', 'MolPort', 'PubChem'])) > 0 else 'No'
|
|
+
|
SELECT ••• "ligand_ligandvendorlink"."id", "ligand_ligandvendorlink"."vendor_id", "ligand_ligandvendorlink"."lp_id", "ligand_ligandvendorlink"."url", "ligand_ligandvendorlink"."vendor_external_id", "ligand_ligandvendorlink"."sid" FROM "ligand_ligandvendorlink" INNER JOIN "ligand_ligandvendors" ON ("ligand_ligandvendorlink"."vendor_id" = "ligand_ligandvendors"."id") WHERE ("ligand_ligandvendorlink"."lp_id" = 135532 AND NOT ("ligand_ligandvendors"."name" IN ('ZINC', 'ChEMBL', 'BindingDB', 'SureChEMBL', 'eMolecules', 'MolPort', 'PubChem')))
76 similar queries.
Duplicated 2 times.
|
|
0.62
|
|
|
Connection: default
/usr/lib/python3.6/concurrent/futures/thread.py in _worker(69)
work_item.run()
/usr/lib/python3.6/concurrent/futures/thread.py in run(56)
result = self.fn(*self.args, **self.kwargs)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle(279)
keepalive = self.handle_request(req, conn)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle_request(328)
respiter = self.wsgi(environ, resp.start_response)
/home/protwis/gpcrdb_test/common/middleware/stats.py in __call__(34)
response = self.get_response(request)
/home/protwis/gpcrdb_test/ligand/views.py in TargetDetails(359)
vendor__name__in=['ZINC', 'ChEMBL', 'BindingDB', 'SureChEMBL', 'eMolecules', 'MolPort', 'PubChem'])) > 0 else 'No'
|
|
+
|
SELECT ••• "ligand_ligandvendorlink"."id", "ligand_ligandvendorlink"."vendor_id", "ligand_ligandvendorlink"."lp_id", "ligand_ligandvendorlink"."url", "ligand_ligandvendorlink"."vendor_external_id", "ligand_ligandvendorlink"."sid" FROM "ligand_ligandvendorlink" INNER JOIN "ligand_ligandvendors" ON ("ligand_ligandvendorlink"."vendor_id" = "ligand_ligandvendors"."id") WHERE ("ligand_ligandvendorlink"."lp_id" = 107373 AND NOT ("ligand_ligandvendors"."name" IN ('ZINC', 'ChEMBL', 'BindingDB', 'SureChEMBL', 'eMolecules', 'MolPort', 'PubChem')))
76 similar queries.
|
|
0.65
|
|
|
Connection: default
/usr/lib/python3.6/concurrent/futures/thread.py in _worker(69)
work_item.run()
/usr/lib/python3.6/concurrent/futures/thread.py in run(56)
result = self.fn(*self.args, **self.kwargs)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle(279)
keepalive = self.handle_request(req, conn)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle_request(328)
respiter = self.wsgi(environ, resp.start_response)
/home/protwis/gpcrdb_test/common/middleware/stats.py in __call__(34)
response = self.get_response(request)
/home/protwis/gpcrdb_test/ligand/views.py in TargetDetails(359)
vendor__name__in=['ZINC', 'ChEMBL', 'BindingDB', 'SureChEMBL', 'eMolecules', 'MolPort', 'PubChem'])) > 0 else 'No'
|
|
+
|
SELECT ••• "ligand_ligandvendorlink"."id", "ligand_ligandvendorlink"."vendor_id", "ligand_ligandvendorlink"."lp_id", "ligand_ligandvendorlink"."url", "ligand_ligandvendorlink"."vendor_external_id", "ligand_ligandvendorlink"."sid" FROM "ligand_ligandvendorlink" INNER JOIN "ligand_ligandvendors" ON ("ligand_ligandvendorlink"."vendor_id" = "ligand_ligandvendors"."id") WHERE ("ligand_ligandvendorlink"."lp_id" = 121116 AND NOT ("ligand_ligandvendors"."name" IN ('ZINC', 'ChEMBL', 'BindingDB', 'SureChEMBL', 'eMolecules', 'MolPort', 'PubChem')))
76 similar queries.
Duplicated 2 times.
|
|
0.64
|
|
|
Connection: default
/usr/lib/python3.6/concurrent/futures/thread.py in _worker(69)
work_item.run()
/usr/lib/python3.6/concurrent/futures/thread.py in run(56)
result = self.fn(*self.args, **self.kwargs)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle(279)
keepalive = self.handle_request(req, conn)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle_request(328)
respiter = self.wsgi(environ, resp.start_response)
/home/protwis/gpcrdb_test/common/middleware/stats.py in __call__(34)
response = self.get_response(request)
/home/protwis/gpcrdb_test/ligand/views.py in TargetDetails(359)
vendor__name__in=['ZINC', 'ChEMBL', 'BindingDB', 'SureChEMBL', 'eMolecules', 'MolPort', 'PubChem'])) > 0 else 'No'
|
|
+
|
SELECT ••• "ligand_ligandvendorlink"."id", "ligand_ligandvendorlink"."vendor_id", "ligand_ligandvendorlink"."lp_id", "ligand_ligandvendorlink"."url", "ligand_ligandvendorlink"."vendor_external_id", "ligand_ligandvendorlink"."sid" FROM "ligand_ligandvendorlink" INNER JOIN "ligand_ligandvendors" ON ("ligand_ligandvendorlink"."vendor_id" = "ligand_ligandvendors"."id") WHERE ("ligand_ligandvendorlink"."lp_id" = 121116 AND NOT ("ligand_ligandvendors"."name" IN ('ZINC', 'ChEMBL', 'BindingDB', 'SureChEMBL', 'eMolecules', 'MolPort', 'PubChem')))
76 similar queries.
Duplicated 2 times.
|
|
0.62
|
|
|
Connection: default
/usr/lib/python3.6/concurrent/futures/thread.py in _worker(69)
work_item.run()
/usr/lib/python3.6/concurrent/futures/thread.py in run(56)
result = self.fn(*self.args, **self.kwargs)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle(279)
keepalive = self.handle_request(req, conn)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle_request(328)
respiter = self.wsgi(environ, resp.start_response)
/home/protwis/gpcrdb_test/common/middleware/stats.py in __call__(34)
response = self.get_response(request)
/home/protwis/gpcrdb_test/ligand/views.py in TargetDetails(359)
vendor__name__in=['ZINC', 'ChEMBL', 'BindingDB', 'SureChEMBL', 'eMolecules', 'MolPort', 'PubChem'])) > 0 else 'No'
|
|
+
|
SELECT ••• "ligand_ligandvendorlink"."id", "ligand_ligandvendorlink"."vendor_id", "ligand_ligandvendorlink"."lp_id", "ligand_ligandvendorlink"."url", "ligand_ligandvendorlink"."vendor_external_id", "ligand_ligandvendorlink"."sid" FROM "ligand_ligandvendorlink" INNER JOIN "ligand_ligandvendors" ON ("ligand_ligandvendorlink"."vendor_id" = "ligand_ligandvendors"."id") WHERE ("ligand_ligandvendorlink"."lp_id" = 121140 AND NOT ("ligand_ligandvendors"."name" IN ('ZINC', 'ChEMBL', 'BindingDB', 'SureChEMBL', 'eMolecules', 'MolPort', 'PubChem')))
76 similar queries.
Duplicated 2 times.
|
|
0.65
|
|
|
Connection: default
/usr/lib/python3.6/concurrent/futures/thread.py in _worker(69)
work_item.run()
/usr/lib/python3.6/concurrent/futures/thread.py in run(56)
result = self.fn(*self.args, **self.kwargs)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle(279)
keepalive = self.handle_request(req, conn)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle_request(328)
respiter = self.wsgi(environ, resp.start_response)
/home/protwis/gpcrdb_test/common/middleware/stats.py in __call__(34)
response = self.get_response(request)
/home/protwis/gpcrdb_test/ligand/views.py in TargetDetails(359)
vendor__name__in=['ZINC', 'ChEMBL', 'BindingDB', 'SureChEMBL', 'eMolecules', 'MolPort', 'PubChem'])) > 0 else 'No'
|
|
+
|
SELECT ••• "ligand_ligandvendorlink"."id", "ligand_ligandvendorlink"."vendor_id", "ligand_ligandvendorlink"."lp_id", "ligand_ligandvendorlink"."url", "ligand_ligandvendorlink"."vendor_external_id", "ligand_ligandvendorlink"."sid" FROM "ligand_ligandvendorlink" INNER JOIN "ligand_ligandvendors" ON ("ligand_ligandvendorlink"."vendor_id" = "ligand_ligandvendors"."id") WHERE ("ligand_ligandvendorlink"."lp_id" = 121140 AND NOT ("ligand_ligandvendors"."name" IN ('ZINC', 'ChEMBL', 'BindingDB', 'SureChEMBL', 'eMolecules', 'MolPort', 'PubChem')))
76 similar queries.
Duplicated 2 times.
|
|
0.62
|
|
|
Connection: default
/usr/lib/python3.6/concurrent/futures/thread.py in _worker(69)
work_item.run()
/usr/lib/python3.6/concurrent/futures/thread.py in run(56)
result = self.fn(*self.args, **self.kwargs)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle(279)
keepalive = self.handle_request(req, conn)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle_request(328)
respiter = self.wsgi(environ, resp.start_response)
/home/protwis/gpcrdb_test/common/middleware/stats.py in __call__(34)
response = self.get_response(request)
/home/protwis/gpcrdb_test/ligand/views.py in TargetDetails(359)
vendor__name__in=['ZINC', 'ChEMBL', 'BindingDB', 'SureChEMBL', 'eMolecules', 'MolPort', 'PubChem'])) > 0 else 'No'
|
|
+
|
SELECT ••• "ligand_ligandvendorlink"."id", "ligand_ligandvendorlink"."vendor_id", "ligand_ligandvendorlink"."lp_id", "ligand_ligandvendorlink"."url", "ligand_ligandvendorlink"."vendor_external_id", "ligand_ligandvendorlink"."sid" FROM "ligand_ligandvendorlink" INNER JOIN "ligand_ligandvendors" ON ("ligand_ligandvendorlink"."vendor_id" = "ligand_ligandvendors"."id") WHERE ("ligand_ligandvendorlink"."lp_id" = 98172 AND NOT ("ligand_ligandvendors"."name" IN ('ZINC', 'ChEMBL', 'BindingDB', 'SureChEMBL', 'eMolecules', 'MolPort', 'PubChem')))
76 similar queries.
|
|
0.64
|
|
|
Connection: default
/usr/lib/python3.6/concurrent/futures/thread.py in _worker(69)
work_item.run()
/usr/lib/python3.6/concurrent/futures/thread.py in run(56)
result = self.fn(*self.args, **self.kwargs)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle(279)
keepalive = self.handle_request(req, conn)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle_request(328)
respiter = self.wsgi(environ, resp.start_response)
/home/protwis/gpcrdb_test/common/middleware/stats.py in __call__(34)
response = self.get_response(request)
/home/protwis/gpcrdb_test/ligand/views.py in TargetDetails(359)
vendor__name__in=['ZINC', 'ChEMBL', 'BindingDB', 'SureChEMBL', 'eMolecules', 'MolPort', 'PubChem'])) > 0 else 'No'
|
|
+
|
SELECT ••• "ligand_ligandvendorlink"."id", "ligand_ligandvendorlink"."vendor_id", "ligand_ligandvendorlink"."lp_id", "ligand_ligandvendorlink"."url", "ligand_ligandvendorlink"."vendor_external_id", "ligand_ligandvendorlink"."sid" FROM "ligand_ligandvendorlink" INNER JOIN "ligand_ligandvendors" ON ("ligand_ligandvendorlink"."vendor_id" = "ligand_ligandvendors"."id") WHERE ("ligand_ligandvendorlink"."lp_id" = 87887 AND NOT ("ligand_ligandvendors"."name" IN ('ZINC', 'ChEMBL', 'BindingDB', 'SureChEMBL', 'eMolecules', 'MolPort', 'PubChem')))
76 similar queries.
Duplicated 3 times.
|
|
0.76
|
|
|
Connection: default
/usr/lib/python3.6/concurrent/futures/thread.py in _worker(69)
work_item.run()
/usr/lib/python3.6/concurrent/futures/thread.py in run(56)
result = self.fn(*self.args, **self.kwargs)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle(279)
keepalive = self.handle_request(req, conn)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle_request(328)
respiter = self.wsgi(environ, resp.start_response)
/home/protwis/gpcrdb_test/common/middleware/stats.py in __call__(34)
response = self.get_response(request)
/home/protwis/gpcrdb_test/ligand/views.py in TargetDetails(359)
vendor__name__in=['ZINC', 'ChEMBL', 'BindingDB', 'SureChEMBL', 'eMolecules', 'MolPort', 'PubChem'])) > 0 else 'No'
|
|
+
|
SELECT ••• "ligand_ligandvendorlink"."id", "ligand_ligandvendorlink"."vendor_id", "ligand_ligandvendorlink"."lp_id", "ligand_ligandvendorlink"."url", "ligand_ligandvendorlink"."vendor_external_id", "ligand_ligandvendorlink"."sid" FROM "ligand_ligandvendorlink" INNER JOIN "ligand_ligandvendors" ON ("ligand_ligandvendorlink"."vendor_id" = "ligand_ligandvendors"."id") WHERE ("ligand_ligandvendorlink"."lp_id" = 22838 AND NOT ("ligand_ligandvendors"."name" IN ('ZINC', 'ChEMBL', 'BindingDB', 'SureChEMBL', 'eMolecules', 'MolPort', 'PubChem')))
76 similar queries.
|
|
0.65
|
|
|
Connection: default
/usr/lib/python3.6/concurrent/futures/thread.py in _worker(69)
work_item.run()
/usr/lib/python3.6/concurrent/futures/thread.py in run(56)
result = self.fn(*self.args, **self.kwargs)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle(279)
keepalive = self.handle_request(req, conn)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle_request(328)
respiter = self.wsgi(environ, resp.start_response)
/home/protwis/gpcrdb_test/common/middleware/stats.py in __call__(34)
response = self.get_response(request)
/home/protwis/gpcrdb_test/ligand/views.py in TargetDetails(359)
vendor__name__in=['ZINC', 'ChEMBL', 'BindingDB', 'SureChEMBL', 'eMolecules', 'MolPort', 'PubChem'])) > 0 else 'No'
|
|
+
|
SELECT ••• "ligand_ligandvendorlink"."id", "ligand_ligandvendorlink"."vendor_id", "ligand_ligandvendorlink"."lp_id", "ligand_ligandvendorlink"."url", "ligand_ligandvendorlink"."vendor_external_id", "ligand_ligandvendorlink"."sid" FROM "ligand_ligandvendorlink" INNER JOIN "ligand_ligandvendors" ON ("ligand_ligandvendorlink"."vendor_id" = "ligand_ligandvendors"."id") WHERE ("ligand_ligandvendorlink"."lp_id" = 121613 AND NOT ("ligand_ligandvendors"."name" IN ('ZINC', 'ChEMBL', 'BindingDB', 'SureChEMBL', 'eMolecules', 'MolPort', 'PubChem')))
76 similar queries.
Duplicated 2 times.
|
|
0.64
|
|
|
Connection: default
/usr/lib/python3.6/concurrent/futures/thread.py in _worker(69)
work_item.run()
/usr/lib/python3.6/concurrent/futures/thread.py in run(56)
result = self.fn(*self.args, **self.kwargs)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle(279)
keepalive = self.handle_request(req, conn)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle_request(328)
respiter = self.wsgi(environ, resp.start_response)
/home/protwis/gpcrdb_test/common/middleware/stats.py in __call__(34)
response = self.get_response(request)
/home/protwis/gpcrdb_test/ligand/views.py in TargetDetails(359)
vendor__name__in=['ZINC', 'ChEMBL', 'BindingDB', 'SureChEMBL', 'eMolecules', 'MolPort', 'PubChem'])) > 0 else 'No'
|
|
+
|
SELECT ••• "ligand_ligandvendorlink"."id", "ligand_ligandvendorlink"."vendor_id", "ligand_ligandvendorlink"."lp_id", "ligand_ligandvendorlink"."url", "ligand_ligandvendorlink"."vendor_external_id", "ligand_ligandvendorlink"."sid" FROM "ligand_ligandvendorlink" INNER JOIN "ligand_ligandvendors" ON ("ligand_ligandvendorlink"."vendor_id" = "ligand_ligandvendors"."id") WHERE ("ligand_ligandvendorlink"."lp_id" = 121613 AND NOT ("ligand_ligandvendors"."name" IN ('ZINC', 'ChEMBL', 'BindingDB', 'SureChEMBL', 'eMolecules', 'MolPort', 'PubChem')))
76 similar queries.
Duplicated 2 times.
|
|
0.62
|
|
|
Connection: default
/usr/lib/python3.6/concurrent/futures/thread.py in _worker(69)
work_item.run()
/usr/lib/python3.6/concurrent/futures/thread.py in run(56)
result = self.fn(*self.args, **self.kwargs)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle(279)
keepalive = self.handle_request(req, conn)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle_request(328)
respiter = self.wsgi(environ, resp.start_response)
/home/protwis/gpcrdb_test/common/middleware/stats.py in __call__(34)
response = self.get_response(request)
/home/protwis/gpcrdb_test/ligand/views.py in TargetDetails(359)
vendor__name__in=['ZINC', 'ChEMBL', 'BindingDB', 'SureChEMBL', 'eMolecules', 'MolPort', 'PubChem'])) > 0 else 'No'
|
|
+
|
SELECT ••• "ligand_ligandvendorlink"."id", "ligand_ligandvendorlink"."vendor_id", "ligand_ligandvendorlink"."lp_id", "ligand_ligandvendorlink"."url", "ligand_ligandvendorlink"."vendor_external_id", "ligand_ligandvendorlink"."sid" FROM "ligand_ligandvendorlink" INNER JOIN "ligand_ligandvendors" ON ("ligand_ligandvendorlink"."vendor_id" = "ligand_ligandvendors"."id") WHERE ("ligand_ligandvendorlink"."lp_id" = 121602 AND NOT ("ligand_ligandvendors"."name" IN ('ZINC', 'ChEMBL', 'BindingDB', 'SureChEMBL', 'eMolecules', 'MolPort', 'PubChem')))
76 similar queries.
Duplicated 2 times.
|
|
0.62
|
|
|
Connection: default
/usr/lib/python3.6/concurrent/futures/thread.py in _worker(69)
work_item.run()
/usr/lib/python3.6/concurrent/futures/thread.py in run(56)
result = self.fn(*self.args, **self.kwargs)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle(279)
keepalive = self.handle_request(req, conn)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle_request(328)
respiter = self.wsgi(environ, resp.start_response)
/home/protwis/gpcrdb_test/common/middleware/stats.py in __call__(34)
response = self.get_response(request)
/home/protwis/gpcrdb_test/ligand/views.py in TargetDetails(359)
vendor__name__in=['ZINC', 'ChEMBL', 'BindingDB', 'SureChEMBL', 'eMolecules', 'MolPort', 'PubChem'])) > 0 else 'No'
|
|
+
|
SELECT ••• "ligand_ligandvendorlink"."id", "ligand_ligandvendorlink"."vendor_id", "ligand_ligandvendorlink"."lp_id", "ligand_ligandvendorlink"."url", "ligand_ligandvendorlink"."vendor_external_id", "ligand_ligandvendorlink"."sid" FROM "ligand_ligandvendorlink" INNER JOIN "ligand_ligandvendors" ON ("ligand_ligandvendorlink"."vendor_id" = "ligand_ligandvendors"."id") WHERE ("ligand_ligandvendorlink"."lp_id" = 121602 AND NOT ("ligand_ligandvendors"."name" IN ('ZINC', 'ChEMBL', 'BindingDB', 'SureChEMBL', 'eMolecules', 'MolPort', 'PubChem')))
76 similar queries.
Duplicated 2 times.
|
|
0.64
|
|
|
Connection: default
/usr/lib/python3.6/concurrent/futures/thread.py in _worker(69)
work_item.run()
/usr/lib/python3.6/concurrent/futures/thread.py in run(56)
result = self.fn(*self.args, **self.kwargs)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle(279)
keepalive = self.handle_request(req, conn)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle_request(328)
respiter = self.wsgi(environ, resp.start_response)
/home/protwis/gpcrdb_test/common/middleware/stats.py in __call__(34)
response = self.get_response(request)
/home/protwis/gpcrdb_test/ligand/views.py in TargetDetails(359)
vendor__name__in=['ZINC', 'ChEMBL', 'BindingDB', 'SureChEMBL', 'eMolecules', 'MolPort', 'PubChem'])) > 0 else 'No'
|
|
+
|
SELECT ••• "ligand_ligandvendorlink"."id", "ligand_ligandvendorlink"."vendor_id", "ligand_ligandvendorlink"."lp_id", "ligand_ligandvendorlink"."url", "ligand_ligandvendorlink"."vendor_external_id", "ligand_ligandvendorlink"."sid" FROM "ligand_ligandvendorlink" INNER JOIN "ligand_ligandvendors" ON ("ligand_ligandvendorlink"."vendor_id" = "ligand_ligandvendors"."id") WHERE ("ligand_ligandvendorlink"."lp_id" = 87887 AND NOT ("ligand_ligandvendors"."name" IN ('ZINC', 'ChEMBL', 'BindingDB', 'SureChEMBL', 'eMolecules', 'MolPort', 'PubChem')))
76 similar queries.
Duplicated 3 times.
|
|
0.75
|
|
|
Connection: default
/usr/lib/python3.6/concurrent/futures/thread.py in _worker(69)
work_item.run()
/usr/lib/python3.6/concurrent/futures/thread.py in run(56)
result = self.fn(*self.args, **self.kwargs)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle(279)
keepalive = self.handle_request(req, conn)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle_request(328)
respiter = self.wsgi(environ, resp.start_response)
/home/protwis/gpcrdb_test/common/middleware/stats.py in __call__(34)
response = self.get_response(request)
/home/protwis/gpcrdb_test/ligand/views.py in TargetDetails(359)
vendor__name__in=['ZINC', 'ChEMBL', 'BindingDB', 'SureChEMBL', 'eMolecules', 'MolPort', 'PubChem'])) > 0 else 'No'
|
|
+
|
SELECT ••• "ligand_ligandvendorlink"."id", "ligand_ligandvendorlink"."vendor_id", "ligand_ligandvendorlink"."lp_id", "ligand_ligandvendorlink"."url", "ligand_ligandvendorlink"."vendor_external_id", "ligand_ligandvendorlink"."sid" FROM "ligand_ligandvendorlink" INNER JOIN "ligand_ligandvendors" ON ("ligand_ligandvendorlink"."vendor_id" = "ligand_ligandvendors"."id") WHERE ("ligand_ligandvendorlink"."lp_id" = 87887 AND NOT ("ligand_ligandvendors"."name" IN ('ZINC', 'ChEMBL', 'BindingDB', 'SureChEMBL', 'eMolecules', 'MolPort', 'PubChem')))
76 similar queries.
Duplicated 3 times.
|
|
0.72
|
|
|
Connection: default
/usr/lib/python3.6/concurrent/futures/thread.py in _worker(69)
work_item.run()
/usr/lib/python3.6/concurrent/futures/thread.py in run(56)
result = self.fn(*self.args, **self.kwargs)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle(279)
keepalive = self.handle_request(req, conn)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle_request(328)
respiter = self.wsgi(environ, resp.start_response)
/home/protwis/gpcrdb_test/common/middleware/stats.py in __call__(34)
response = self.get_response(request)
/home/protwis/gpcrdb_test/ligand/views.py in TargetDetails(359)
vendor__name__in=['ZINC', 'ChEMBL', 'BindingDB', 'SureChEMBL', 'eMolecules', 'MolPort', 'PubChem'])) > 0 else 'No'
|
|
+
|
SELECT ••• "ligand_ligandvendorlink"."id", "ligand_ligandvendorlink"."vendor_id", "ligand_ligandvendorlink"."lp_id", "ligand_ligandvendorlink"."url", "ligand_ligandvendorlink"."vendor_external_id", "ligand_ligandvendorlink"."sid" FROM "ligand_ligandvendorlink" INNER JOIN "ligand_ligandvendors" ON ("ligand_ligandvendorlink"."vendor_id" = "ligand_ligandvendors"."id") WHERE ("ligand_ligandvendorlink"."lp_id" = 121002 AND NOT ("ligand_ligandvendors"."name" IN ('ZINC', 'ChEMBL', 'BindingDB', 'SureChEMBL', 'eMolecules', 'MolPort', 'PubChem')))
76 similar queries.
Duplicated 2 times.
|
|
0.65
|
|
|
Connection: default
/usr/lib/python3.6/concurrent/futures/thread.py in _worker(69)
work_item.run()
/usr/lib/python3.6/concurrent/futures/thread.py in run(56)
result = self.fn(*self.args, **self.kwargs)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle(279)
keepalive = self.handle_request(req, conn)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle_request(328)
respiter = self.wsgi(environ, resp.start_response)
/home/protwis/gpcrdb_test/common/middleware/stats.py in __call__(34)
response = self.get_response(request)
/home/protwis/gpcrdb_test/ligand/views.py in TargetDetails(359)
vendor__name__in=['ZINC', 'ChEMBL', 'BindingDB', 'SureChEMBL', 'eMolecules', 'MolPort', 'PubChem'])) > 0 else 'No'
|
|
+
|
SELECT ••• "ligand_ligandvendorlink"."id", "ligand_ligandvendorlink"."vendor_id", "ligand_ligandvendorlink"."lp_id", "ligand_ligandvendorlink"."url", "ligand_ligandvendorlink"."vendor_external_id", "ligand_ligandvendorlink"."sid" FROM "ligand_ligandvendorlink" INNER JOIN "ligand_ligandvendors" ON ("ligand_ligandvendorlink"."vendor_id" = "ligand_ligandvendors"."id") WHERE ("ligand_ligandvendorlink"."lp_id" = 121002 AND NOT ("ligand_ligandvendors"."name" IN ('ZINC', 'ChEMBL', 'BindingDB', 'SureChEMBL', 'eMolecules', 'MolPort', 'PubChem')))
76 similar queries.
Duplicated 2 times.
|
|
0.64
|
|
|
Connection: default
/usr/lib/python3.6/concurrent/futures/thread.py in _worker(69)
work_item.run()
/usr/lib/python3.6/concurrent/futures/thread.py in run(56)
result = self.fn(*self.args, **self.kwargs)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle(279)
keepalive = self.handle_request(req, conn)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle_request(328)
respiter = self.wsgi(environ, resp.start_response)
/home/protwis/gpcrdb_test/common/middleware/stats.py in __call__(34)
response = self.get_response(request)
/home/protwis/gpcrdb_test/ligand/views.py in TargetDetails(359)
vendor__name__in=['ZINC', 'ChEMBL', 'BindingDB', 'SureChEMBL', 'eMolecules', 'MolPort', 'PubChem'])) > 0 else 'No'
|
|
+
|
SELECT ••• "ligand_ligandvendorlink"."id", "ligand_ligandvendorlink"."vendor_id", "ligand_ligandvendorlink"."lp_id", "ligand_ligandvendorlink"."url", "ligand_ligandvendorlink"."vendor_external_id", "ligand_ligandvendorlink"."sid" FROM "ligand_ligandvendorlink" INNER JOIN "ligand_ligandvendors" ON ("ligand_ligandvendorlink"."vendor_id" = "ligand_ligandvendors"."id") WHERE ("ligand_ligandvendorlink"."lp_id" = 23785 AND NOT ("ligand_ligandvendors"."name" IN ('ZINC', 'ChEMBL', 'BindingDB', 'SureChEMBL', 'eMolecules', 'MolPort', 'PubChem')))
76 similar queries.
|
|
0.68
|
|
|
Connection: default
/usr/lib/python3.6/concurrent/futures/thread.py in _worker(69)
work_item.run()
/usr/lib/python3.6/concurrent/futures/thread.py in run(56)
result = self.fn(*self.args, **self.kwargs)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle(279)
keepalive = self.handle_request(req, conn)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle_request(328)
respiter = self.wsgi(environ, resp.start_response)
/home/protwis/gpcrdb_test/common/middleware/stats.py in __call__(34)
response = self.get_response(request)
/home/protwis/gpcrdb_test/ligand/views.py in TargetDetails(359)
vendor__name__in=['ZINC', 'ChEMBL', 'BindingDB', 'SureChEMBL', 'eMolecules', 'MolPort', 'PubChem'])) > 0 else 'No'
|
|
+
|
SELECT ••• "ligand_ligandvendorlink"."id", "ligand_ligandvendorlink"."vendor_id", "ligand_ligandvendorlink"."lp_id", "ligand_ligandvendorlink"."url", "ligand_ligandvendorlink"."vendor_external_id", "ligand_ligandvendorlink"."sid" FROM "ligand_ligandvendorlink" INNER JOIN "ligand_ligandvendors" ON ("ligand_ligandvendorlink"."vendor_id" = "ligand_ligandvendors"."id") WHERE ("ligand_ligandvendorlink"."lp_id" = 130214 AND NOT ("ligand_ligandvendors"."name" IN ('ZINC', 'ChEMBL', 'BindingDB', 'SureChEMBL', 'eMolecules', 'MolPort', 'PubChem')))
76 similar queries.
|
|
0.73
|
|
|
Connection: default
/usr/lib/python3.6/concurrent/futures/thread.py in _worker(69)
work_item.run()
/usr/lib/python3.6/concurrent/futures/thread.py in run(56)
result = self.fn(*self.args, **self.kwargs)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle(279)
keepalive = self.handle_request(req, conn)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle_request(328)
respiter = self.wsgi(environ, resp.start_response)
/home/protwis/gpcrdb_test/common/middleware/stats.py in __call__(34)
response = self.get_response(request)
/home/protwis/gpcrdb_test/ligand/views.py in TargetDetails(359)
vendor__name__in=['ZINC', 'ChEMBL', 'BindingDB', 'SureChEMBL', 'eMolecules', 'MolPort', 'PubChem'])) > 0 else 'No'
|
|
+
|
SELECT ••• "ligand_ligandvendorlink"."id", "ligand_ligandvendorlink"."vendor_id", "ligand_ligandvendorlink"."lp_id", "ligand_ligandvendorlink"."url", "ligand_ligandvendorlink"."vendor_external_id", "ligand_ligandvendorlink"."sid" FROM "ligand_ligandvendorlink" INNER JOIN "ligand_ligandvendors" ON ("ligand_ligandvendorlink"."vendor_id" = "ligand_ligandvendors"."id") WHERE ("ligand_ligandvendorlink"."lp_id" = 45256 AND NOT ("ligand_ligandvendors"."name" IN ('ZINC', 'ChEMBL', 'BindingDB', 'SureChEMBL', 'eMolecules', 'MolPort', 'PubChem')))
76 similar queries.
|
|
0.65
|
|
|
Connection: default
/usr/lib/python3.6/concurrent/futures/thread.py in _worker(69)
work_item.run()
/usr/lib/python3.6/concurrent/futures/thread.py in run(56)
result = self.fn(*self.args, **self.kwargs)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle(279)
keepalive = self.handle_request(req, conn)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle_request(328)
respiter = self.wsgi(environ, resp.start_response)
/home/protwis/gpcrdb_test/common/middleware/stats.py in __call__(34)
response = self.get_response(request)
/home/protwis/gpcrdb_test/ligand/views.py in TargetDetails(359)
vendor__name__in=['ZINC', 'ChEMBL', 'BindingDB', 'SureChEMBL', 'eMolecules', 'MolPort', 'PubChem'])) > 0 else 'No'
|
|
+
|
SELECT ••• "ligand_ligandvendorlink"."id", "ligand_ligandvendorlink"."vendor_id", "ligand_ligandvendorlink"."lp_id", "ligand_ligandvendorlink"."url", "ligand_ligandvendorlink"."vendor_external_id", "ligand_ligandvendorlink"."sid" FROM "ligand_ligandvendorlink" INNER JOIN "ligand_ligandvendors" ON ("ligand_ligandvendorlink"."vendor_id" = "ligand_ligandvendors"."id") WHERE ("ligand_ligandvendorlink"."lp_id" = 42750 AND NOT ("ligand_ligandvendors"."name" IN ('ZINC', 'ChEMBL', 'BindingDB', 'SureChEMBL', 'eMolecules', 'MolPort', 'PubChem')))
76 similar queries.
|
|
0.64
|
|
|
Connection: default
/usr/lib/python3.6/concurrent/futures/thread.py in _worker(69)
work_item.run()
/usr/lib/python3.6/concurrent/futures/thread.py in run(56)
result = self.fn(*self.args, **self.kwargs)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle(279)
keepalive = self.handle_request(req, conn)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle_request(328)
respiter = self.wsgi(environ, resp.start_response)
/home/protwis/gpcrdb_test/common/middleware/stats.py in __call__(34)
response = self.get_response(request)
/home/protwis/gpcrdb_test/ligand/views.py in TargetDetails(359)
vendor__name__in=['ZINC', 'ChEMBL', 'BindingDB', 'SureChEMBL', 'eMolecules', 'MolPort', 'PubChem'])) > 0 else 'No'
|