|
+
|
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_004_003_001')
|
|
122.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(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_004_003_001') 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"
|
|
12.03
|
|
|
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" = 85221 AND NOT ("ligand_ligandvendors"."name" IN ('ZINC', 'ChEMBL', 'BindingDB', 'SureChEMBL', 'eMolecules', 'MolPort', 'PubChem')))
294 similar queries.
|
|
1.11
|
|
|
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" = 34544 AND NOT ("ligand_ligandvendors"."name" IN ('ZINC', 'ChEMBL', 'BindingDB', 'SureChEMBL', 'eMolecules', 'MolPort', 'PubChem')))
294 similar queries.
|
|
0.59
|
|
|
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" = 109152 AND NOT ("ligand_ligandvendors"."name" IN ('ZINC', 'ChEMBL', 'BindingDB', 'SureChEMBL', 'eMolecules', 'MolPort', 'PubChem')))
294 similar queries.
|
|
0.54
|
|
|
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" = 75155 AND NOT ("ligand_ligandvendors"."name" IN ('ZINC', 'ChEMBL', 'BindingDB', 'SureChEMBL', 'eMolecules', 'MolPort', 'PubChem')))
294 similar queries.
|
|
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" = 2889 AND NOT ("ligand_ligandvendors"."name" IN ('ZINC', 'ChEMBL', 'BindingDB', 'SureChEMBL', 'eMolecules', 'MolPort', 'PubChem')))
294 similar queries.
Duplicated 6 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" = 2889 AND NOT ("ligand_ligandvendors"."name" IN ('ZINC', 'ChEMBL', 'BindingDB', 'SureChEMBL', 'eMolecules', 'MolPort', 'PubChem')))
294 similar queries.
Duplicated 6 times.
|
|
0.47
|
|
|
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" = 70699 AND NOT ("ligand_ligandvendors"."name" IN ('ZINC', 'ChEMBL', 'BindingDB', 'SureChEMBL', 'eMolecules', 'MolPort', 'PubChem')))
294 similar queries.
Duplicated 2 times.
|
|
0.49
|
|
|
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" = 70699 AND NOT ("ligand_ligandvendors"."name" IN ('ZINC', 'ChEMBL', 'BindingDB', 'SureChEMBL', 'eMolecules', 'MolPort', 'PubChem')))
294 similar queries.
Duplicated 2 times.
|
|
0.47
|
|
|
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" = 71310 AND NOT ("ligand_ligandvendors"."name" IN ('ZINC', 'ChEMBL', 'BindingDB', 'SureChEMBL', 'eMolecules', 'MolPort', 'PubChem')))
294 similar queries.
Duplicated 2 times.
|
|
0.49
|
|
|
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" = 71310 AND NOT ("ligand_ligandvendors"."name" IN ('ZINC', 'ChEMBL', 'BindingDB', 'SureChEMBL', 'eMolecules', 'MolPort', 'PubChem')))
294 similar queries.
Duplicated 2 times.
|
|
0.46
|
|
|
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" = 104607 AND NOT ("ligand_ligandvendors"."name" IN ('ZINC', 'ChEMBL', 'BindingDB', 'SureChEMBL', 'eMolecules', 'MolPort', 'PubChem')))
294 similar queries.
|
|
0.48
|
|
|
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" = 4950 AND NOT ("ligand_ligandvendors"."name" IN ('ZINC', 'ChEMBL', 'BindingDB', 'SureChEMBL', 'eMolecules', 'MolPort', 'PubChem')))
294 similar queries.
Duplicated 3 times.
|
|
0.47
|
|
|
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" = 4950 AND NOT ("ligand_ligandvendors"."name" IN ('ZINC', 'ChEMBL', 'BindingDB', 'SureChEMBL', 'eMolecules', 'MolPort', 'PubChem')))
294 similar queries.
Duplicated 3 times.
|
|
0.46
|
|
|
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" = 4950 AND NOT ("ligand_ligandvendors"."name" IN ('ZINC', 'ChEMBL', 'BindingDB', 'SureChEMBL', 'eMolecules', 'MolPort', 'PubChem')))
294 similar queries.
Duplicated 3 times.
|
|
0.46
|
|
|
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" = 47467 AND NOT ("ligand_ligandvendors"."name" IN ('ZINC', 'ChEMBL', 'BindingDB', 'SureChEMBL', 'eMolecules', 'MolPort', 'PubChem')))
294 similar queries.
Duplicated 3 times.
|
|
0.49
|
|
|
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" = 47467 AND NOT ("ligand_ligandvendors"."name" IN ('ZINC', 'ChEMBL', 'BindingDB', 'SureChEMBL', 'eMolecules', 'MolPort', 'PubChem')))
294 similar queries.
Duplicated 3 times.
|
|
0.47
|
|
|
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" = 47467 AND NOT ("ligand_ligandvendors"."name" IN ('ZINC', 'ChEMBL', 'BindingDB', 'SureChEMBL', 'eMolecules', 'MolPort', 'PubChem')))
294 similar queries.
Duplicated 3 times.
|
|
0.45
|
|
|
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" = 60337 AND NOT ("ligand_ligandvendors"."name" IN ('ZINC', 'ChEMBL', 'BindingDB', 'SureChEMBL', 'eMolecules', 'MolPort', 'PubChem')))
294 similar queries.
|
|
0.48
|
|
|
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" = 112065 AND NOT ("ligand_ligandvendors"."name" IN ('ZINC', 'ChEMBL', 'BindingDB', 'SureChEMBL', 'eMolecules', 'MolPort', 'PubChem')))
294 similar queries.
Duplicated 2 times.
|
|
0.47
|
|
|
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" = 112065 AND NOT ("ligand_ligandvendors"."name" IN ('ZINC', 'ChEMBL', 'BindingDB', 'SureChEMBL', 'eMolecules', 'MolPort', 'PubChem')))
294 similar queries.
Duplicated 2 times.
|
|
0.46
|
|
|
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" = 85230 AND NOT ("ligand_ligandvendors"."name" IN ('ZINC', 'ChEMBL', 'BindingDB', 'SureChEMBL', 'eMolecules', 'MolPort', 'PubChem')))
294 similar queries.
|
|
0.48
|
|
|
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" = 2889 AND NOT ("ligand_ligandvendors"."name" IN ('ZINC', 'ChEMBL', 'BindingDB', 'SureChEMBL', 'eMolecules', 'MolPort', 'PubChem')))
294 similar queries.
Duplicated 6 times.
|
|
0.46
|
|
|
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" = 2889 AND NOT ("ligand_ligandvendors"."name" IN ('ZINC', 'ChEMBL', 'BindingDB', 'SureChEMBL', 'eMolecules', 'MolPort', 'PubChem')))
294 similar queries.
Duplicated 6 times.
|
|
0.47
|
|
|
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" = 110656 AND NOT ("ligand_ligandvendors"."name" IN ('ZINC', 'ChEMBL', 'BindingDB', 'SureChEMBL', 'eMolecules', 'MolPort', 'PubChem')))
294 similar queries.
Duplicated 2 times.
|
|
0.46
|
|
|
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" = 110656 AND NOT ("ligand_ligandvendors"."name" IN ('ZINC', 'ChEMBL', 'BindingDB', 'SureChEMBL', 'eMolecules', 'MolPort', 'PubChem')))
294 similar queries.
Duplicated 2 times.
|
|
0.46
|
|
|
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" = 102736 AND NOT ("ligand_ligandvendors"."name" IN ('ZINC', 'ChEMBL', 'BindingDB', 'SureChEMBL', 'eMolecules', 'MolPort', 'PubChem')))
294 similar queries.
|
|
0.47
|
|
|
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" = 74903 AND NOT ("ligand_ligandvendors"."name" IN ('ZINC', 'ChEMBL', 'BindingDB', 'SureChEMBL', 'eMolecules', 'MolPort', 'PubChem')))
294 similar queries.
Duplicated 2 times.
|
|
0.48
|
|
|
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" = 74903 AND NOT ("ligand_ligandvendors"."name" IN ('ZINC', 'ChEMBL', 'BindingDB', 'SureChEMBL', 'eMolecules', 'MolPort', 'PubChem')))
294 similar queries.
Duplicated 2 times.
|
|
0.46
|
|
|
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" = 2889 AND NOT ("ligand_ligandvendors"."name" IN ('ZINC', 'ChEMBL', 'BindingDB', 'SureChEMBL', 'eMolecules', 'MolPort', 'PubChem')))
294 similar queries.
Duplicated 6 times.
|
|
0.46
|
|
|
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" = 2889 AND NOT ("ligand_ligandvendors"."name" IN ('ZINC', 'ChEMBL', 'BindingDB', 'SureChEMBL', 'eMolecules', 'MolPort', 'PubChem')))
294 similar queries.
Duplicated 6 times.
|
|
0.47
|
|
|
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" = 110331 AND NOT ("ligand_ligandvendors"."name" IN ('ZINC', 'ChEMBL', 'BindingDB', 'SureChEMBL', 'eMolecules', 'MolPort', 'PubChem')))
294 similar queries.
Duplicated 2 times.
|
|
0.49
|
|
|
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" = 110331 AND NOT ("ligand_ligandvendors"."name" IN ('ZINC', 'ChEMBL', 'BindingDB', 'SureChEMBL', 'eMolecules', 'MolPort', 'PubChem')))
294 similar queries.
Duplicated 2 times.
|
|
0.46
|
|
|
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" = 111912 AND NOT ("ligand_ligandvendors"."name" IN ('ZINC', 'ChEMBL', 'BindingDB', 'SureChEMBL', 'eMolecules', 'MolPort', 'PubChem')))
294 similar queries.
Duplicated 2 times.
|
|
0.47
|
|
|
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" = 111912 AND NOT ("ligand_ligandvendors"."name" IN ('ZINC', 'ChEMBL', 'BindingDB', 'SureChEMBL', 'eMolecules', 'MolPort', 'PubChem')))
294 similar queries.
Duplicated 2 times.
|
|
0.46
|
|
|
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" = 20440 AND NOT ("ligand_ligandvendors"."name" IN ('ZINC', 'ChEMBL', 'BindingDB', 'SureChEMBL', 'eMolecules', 'MolPort', 'PubChem')))
294 similar queries.
|
|
0.48
|
|
|
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" = 9727 AND NOT ("ligand_ligandvendors"."name" IN ('ZINC', 'ChEMBL', 'BindingDB', 'SureChEMBL', 'eMolecules', 'MolPort', 'PubChem')))
294 similar queries.
Duplicated 2 times.
|
|
0.47
|
|
|
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" = 9727 AND NOT ("ligand_ligandvendors"."name" IN ('ZINC', 'ChEMBL', 'BindingDB', 'SureChEMBL', 'eMolecules', 'MolPort', 'PubChem')))
294 similar queries.
Duplicated 2 times.
|
|
0.46
|
|
|
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" = 74239 AND NOT ("ligand_ligandvendors"."name" IN ('ZINC', 'ChEMBL', 'BindingDB', 'SureChEMBL', 'eMolecules', 'MolPort', 'PubChem')))
294 similar queries.
Duplicated 2 times.
|
|
0.48
|
|
|
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" = 74239 AND NOT ("ligand_ligandvendors"."name" IN ('ZINC', 'ChEMBL', 'BindingDB', 'SureChEMBL', 'eMolecules', 'MolPort', 'PubChem')))
294 similar queries.
Duplicated 2 times.
|
|
0.46
|
|
|
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" = 110716 AND NOT ("ligand_ligandvendors"."name" IN ('ZINC', 'ChEMBL', 'BindingDB', 'SureChEMBL', 'eMolecules', 'MolPort', 'PubChem')))
294 similar queries.
Duplicated 2 times.
|
|
0.48
|
|
|
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" = 110716 AND NOT ("ligand_ligandvendors"."name" IN ('ZINC', 'ChEMBL', 'BindingDB', 'SureChEMBL', 'eMolecules', 'MolPort', 'PubChem')))
294 similar queries.
Duplicated 2 times.
|
|
0.46
|
|
|
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" = 2891 AND NOT ("ligand_ligandvendors"."name" IN ('ZINC', 'ChEMBL', 'BindingDB', 'SureChEMBL', 'eMolecules', 'MolPort', 'PubChem')))
294 similar queries.
|
|
0.50
|
|
|
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" = 111332 AND NOT ("ligand_ligandvendors"."name" IN ('ZINC', 'ChEMBL', 'BindingDB', 'SureChEMBL', 'eMolecules', 'MolPort', 'PubChem')))
294 similar queries.
Duplicated 2 times.
|
|
0.47
|
|
|
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" = 111332 AND NOT ("ligand_ligandvendors"."name" IN ('ZINC', 'ChEMBL', 'BindingDB', 'SureChEMBL', 'eMolecules', 'MolPort', 'PubChem')))
294 similar queries.
Duplicated 2 times.
|
|
0.46
|
|
|
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" = 84462 AND NOT ("ligand_ligandvendors"."name" IN ('ZINC', 'ChEMBL', 'BindingDB', 'SureChEMBL', 'eMolecules', 'MolPort', 'PubChem')))
294 similar queries.
|
|
0.48
|
|
|
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" = 90605 AND NOT ("ligand_ligandvendors"."name" IN ('ZINC', 'ChEMBL', 'BindingDB', 'SureChEMBL', 'eMolecules', 'MolPort', 'PubChem')))
294 similar queries.
Duplicated 4 times.
|
|
0.47
|
|
|
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" = 44096 AND NOT ("ligand_ligandvendors"."name" IN ('ZINC', 'ChEMBL', 'BindingDB', 'SureChEMBL', 'eMolecules', 'MolPort', 'PubChem')))
294 similar queries.
Duplicated 2 times.
|
|
0.48
|
|
|
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" = 90605 AND NOT ("ligand_ligandvendors"."name" IN ('ZINC', 'ChEMBL', 'BindingDB', 'SureChEMBL', 'eMolecules', 'MolPort', 'PubChem')))
294 similar queries.
Duplicated 4 times.
|
|
0.46
|
|
|
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" = 77557 AND NOT ("ligand_ligandvendors"."name" IN ('ZINC', 'ChEMBL', 'BindingDB', 'SureChEMBL', 'eMolecules', 'MolPort', 'PubChem')))
294 similar queries.
Duplicated 3 times.
|
|
0.50
|
|
|
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" = 77557 AND NOT ("ligand_ligandvendors"."name" IN ('ZINC', 'ChEMBL', 'BindingDB', 'SureChEMBL', 'eMolecules', 'MolPort', 'PubChem')))
294 similar queries.
Duplicated 3 times.
|
|
0.46
|
|
|
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" = 82089 AND NOT ("ligand_ligandvendors"."name" IN ('ZINC', 'ChEMBL', 'BindingDB', 'SureChEMBL', 'eMolecules', 'MolPort', 'PubChem')))
294 similar queries.
|
|
0.49
|
|
|
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" = 143762 AND NOT ("ligand_ligandvendors"."name" IN ('ZINC', 'ChEMBL', 'BindingDB', 'SureChEMBL', 'eMolecules', 'MolPort', 'PubChem')))
294 similar queries.
Duplicated 2 times.
|
|
0.49
|
|
|
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" = 130269 AND NOT ("ligand_ligandvendors"."name" IN ('ZINC', 'ChEMBL', 'BindingDB', 'SureChEMBL', 'eMolecules', 'MolPort', 'PubChem')))
294 similar queries.
Duplicated 6 times.
|
|
0.49
|
|
|
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" = 130269 AND NOT ("ligand_ligandvendors"."name" IN ('ZINC', 'ChEMBL', 'BindingDB', 'SureChEMBL', 'eMolecules', 'MolPort', 'PubChem')))
294 similar queries.
Duplicated 6 times.
|
|
0.46
|
|
|
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" = 130269 AND NOT ("ligand_ligandvendors"."name" IN ('ZINC', 'ChEMBL', 'BindingDB', 'SureChEMBL', 'eMolecules', 'MolPort', 'PubChem')))
294 similar queries.
Duplicated 6 times.
|
|
0.47
|
|
|
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" = 130269 AND NOT ("ligand_ligandvendors"."name" IN ('ZINC', 'ChEMBL', 'BindingDB', 'SureChEMBL', 'eMolecules', 'MolPort', 'PubChem')))
294 similar queries.
Duplicated 6 times.
|
|
0.46
|
|
|
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" = 124301 AND NOT ("ligand_ligandvendors"."name" IN ('ZINC', 'ChEMBL', 'BindingDB', 'SureChEMBL', 'eMolecules', 'MolPort', 'PubChem')))
294 similar queries.
Duplicated 4 times.
|
|
0.49
|
|
|
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" = 124301 AND NOT ("ligand_ligandvendors"."name" IN ('ZINC', 'ChEMBL', 'BindingDB', 'SureChEMBL', 'eMolecules', 'MolPort', 'PubChem')))
294 similar queries.
Duplicated 4 times.
|
|
0.45
|
|
|
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" = 103107 AND NOT ("ligand_ligandvendors"."name" IN ('ZINC', 'ChEMBL', 'BindingDB', 'SureChEMBL', 'eMolecules', 'MolPort', 'PubChem')))
294 similar queries.
Duplicated 2 times.
|
|
0.48
|
|
|
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" = 103107 AND NOT ("ligand_ligandvendors"."name" IN ('ZINC', 'ChEMBL', 'BindingDB', 'SureChEMBL', 'eMolecules', 'MolPort', 'PubChem')))
294 similar queries.
Duplicated 2 times.
|
|
0.45
|
|
|
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" = 22630 AND NOT ("ligand_ligandvendors"."name" IN ('ZINC', 'ChEMBL', 'BindingDB', 'SureChEMBL', 'eMolecules', 'MolPort', 'PubChem')))
294 similar queries.
|
|
0.47
|
|
|
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" = 69616 AND NOT ("ligand_ligandvendors"."name" IN ('ZINC', 'ChEMBL', 'BindingDB', 'SureChEMBL', 'eMolecules', 'MolPort', 'PubChem')))
294 similar queries.
Duplicated 2 times.
|
|
0.46
|
|
|
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" = 90158 AND NOT ("ligand_ligandvendors"."name" IN ('ZINC', 'ChEMBL', 'BindingDB', 'SureChEMBL', 'eMolecules', 'MolPort', 'PubChem')))
294 similar queries.
Duplicated 4 times.
|
|
0.48
|
|
|
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" = 90158 AND NOT ("ligand_ligandvendors"."name" IN ('ZINC', 'ChEMBL', 'BindingDB', 'SureChEMBL', 'eMolecules', 'MolPort', 'PubChem')))
294 similar queries.
Duplicated 4 times.
|
|
0.46
|
|
|
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" = 110849 AND NOT ("ligand_ligandvendors"."name" IN ('ZINC', 'ChEMBL', 'BindingDB', 'SureChEMBL', 'eMolecules', 'MolPort', 'PubChem')))
294 similar queries.
Duplicated 2 times.
|
|
0.46
|
|
|
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" = 40410 AND NOT ("ligand_ligandvendors"."name" IN ('ZINC', 'ChEMBL', 'BindingDB', 'SureChEMBL', 'eMolecules', 'MolPort', 'PubChem')))
294 similar queries.
Duplicated 4 times.
|
|
0.49
|
|
|
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" = 90605 AND NOT ("ligand_ligandvendors"."name" IN ('ZINC', 'ChEMBL', 'BindingDB', 'SureChEMBL', 'eMolecules', 'MolPort', 'PubChem')))
294 similar queries.
Duplicated 4 times.
|
|
0.45
|
|
|
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" = 110849 AND NOT ("ligand_ligandvendors"."name" IN ('ZINC', 'ChEMBL', 'BindingDB', 'SureChEMBL', 'eMolecules', 'MolPort', 'PubChem')))
294 similar queries.
Duplicated 2 times.
|
|
0.47
|
|
|
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" = 40410 AND NOT ("ligand_ligandvendors"."name" IN ('ZINC', 'ChEMBL', 'BindingDB', 'SureChEMBL', 'eMolecules', 'MolPort', 'PubChem')))
294 similar queries.
Duplicated 4 times.
|
|
0.45
|
|
|
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" = 90605 AND NOT ("ligand_ligandvendors"."name" IN ('ZINC', 'ChEMBL', 'BindingDB', 'SureChEMBL', 'eMolecules', 'MolPort', 'PubChem')))
294 similar queries.
Duplicated 4 times.
|
|
0.47
|
|
|
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" = 91548 AND NOT ("ligand_ligandvendors"."name" IN ('ZINC', 'ChEMBL', 'BindingDB', 'SureChEMBL', 'eMolecules', 'MolPort', 'PubChem')))
294 similar queries.
Duplicated 4 times.
|
|
0.48
|
|
|
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" = 91548 AND NOT ("ligand_ligandvendors"."name" IN ('ZINC', 'ChEMBL', 'BindingDB', 'SureChEMBL', 'eMolecules', 'MolPort', 'PubChem')))
294 similar queries.
Duplicated 4 times.
|
|
0.46
|
|
|
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" = 96733 AND NOT ("ligand_ligandvendors"."name" IN ('ZINC', 'ChEMBL', 'BindingDB', 'SureChEMBL', 'eMolecules', 'MolPort', 'PubChem')))
294 similar queries.
Duplicated 2 times.
|
|
0.48
|
|
|
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" = 8089 AND NOT ("ligand_ligandvendors"."name" IN ('ZINC', 'ChEMBL', 'BindingDB', 'SureChEMBL', 'eMolecules', 'MolPort', 'PubChem')))
294 similar queries.
Duplicated 2 times.
|
|
0.47
|
|
|
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" = 110748 AND NOT ("ligand_ligandvendors"."name" IN ('ZINC', 'ChEMBL', 'BindingDB', 'SureChEMBL', 'eMolecules', 'MolPort', 'PubChem')))
294 similar queries.
|
|
0.49
|
|
|
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" = 82860 AND NOT ("ligand_ligandvendors"."name" IN ('ZINC', 'ChEMBL', 'BindingDB', 'SureChEMBL', 'eMolecules', 'MolPort', 'PubChem')))
294 similar queries.
Duplicated 3 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" = 110952 AND NOT ("ligand_ligandvendors"."name" IN ('ZINC', 'ChEMBL', 'BindingDB', 'SureChEMBL', 'eMolecules', 'MolPort', 'PubChem')))
294 similar queries.
Duplicated 2 times.
|
|
0.48
|
|
|
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" = 110952 AND NOT ("ligand_ligandvendors"."name" IN ('ZINC', 'ChEMBL', 'BindingDB', 'SureChEMBL', 'eMolecules', 'MolPort', 'PubChem')))
294 similar queries.
Duplicated 2 times.
|
|
0.46
|
|
|
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" = 40570 AND NOT ("ligand_ligandvendors"."name" IN ('ZINC', 'ChEMBL', 'BindingDB', 'SureChEMBL', 'eMolecules', 'MolPort', 'PubChem')))
294 similar queries.
Duplicated 3 times.
|
|
0.48
|
|
|
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" = 40570 AND NOT ("ligand_ligandvendors"."name" IN ('ZINC', 'ChEMBL', 'BindingDB', 'SureChEMBL', 'eMolecules', 'MolPort', 'PubChem')))
294 similar queries.
Duplicated 3 times.
|
|
0.45
|
|