|
+
|
SELECT ••• "protein"."id", "protein"."parent_id", "protein"."family_id", "protein"."species_id", "protein"."source_id", "protein"."residue_numbering_scheme_id", "protein"."sequence_type_id", "protein"."entry_name", "protein"."accession", "protein"."name", "protein"."sequence" FROM "protein" WHERE "protein"."entry_name" = 'tshr_human'
|
|
3.99
|
|
|
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/mutational_landscape/views.py in render_variants(89)
proteins.append(Protein.objects.get(entry_name=protein.lower()))
|
|
+
|
SELECT ••• "residue_position_set"."id", "residue_position_set"."name", "residue_position_set"."set_type", "residue_position_set"."protein_group" FROM "residue_position_set" WHERE "residue_position_set"."name" = 'State (micro-)switches'
3 similar queries.
|
|
0.55
|
|
|
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/mutational_landscape/views.py in render_variants(128)
micro_switches_rset = ResiduePositionSet.objects.get(name="State (micro-)switches")
|
|
+
|
SELECT ••• "residue_generic_number_equivalent"."id", "residue_generic_number_equivalent"."default_generic_number_id", "residue_generic_number_equivalent"."scheme_id", "residue_generic_number_equivalent"."label" FROM "residue_generic_number_equivalent" INNER JOIN "residue_position_set_residue_position" ON ("residue_generic_number_equivalent"."id" = "residue_position_set_residue_position"."residuegenericnumberequivalent_id") WHERE "residue_position_set_residue_position"."residuepositionset_id" = 2
3 similar queries.
|
|
1.66
|
|
|
Connection: default
/usr/lib/python3.6/concurrent/futures/thread.py in _worker(69)
work_item.run()
/usr/lib/python3.6/concurrent/futures/thread.py in run(56)
result = self.fn(*self.args, **self.kwargs)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle(279)
keepalive = self.handle_request(req, conn)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle_request(328)
respiter = self.wsgi(environ, resp.start_response)
/home/protwis/gpcrdb_test/common/middleware/stats.py in __call__(34)
response = self.get_response(request)
/home/protwis/gpcrdb_test/mutational_landscape/views.py in render_variants(130)
for residue in micro_switches_rset.residue_position.all():
|
|
+
|
SELECT ••• "residue"."id", "residue"."protein_conformation_id", "residue"."protein_segment_id", "residue"."generic_number_id", "residue"."display_generic_number_id", "residue"."sequence_number", "residue"."amino_acid" FROM "residue" INNER JOIN "residue_generic_number" ON ("residue"."generic_number_id" = "residue_generic_number"."id") INNER JOIN "protein_conformation" ON ("residue"."protein_conformation_id" = "protein_conformation"."id") WHERE ("residue_generic_number"."label" IN ('5x47', '5x50', '6x30', '6x44', '6x50', '6x48', '6x34', '5x58', '3x40', '3x49', '3x50', '7x53', '7x50', '7x49', '7x43') AND "protein_conformation"."protein_id" = 139) ORDER BY "residue"."sequence_number" ASC
2 similar queries.
Duplicated 2 times.
|
|
9.61
|
|
|
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/mutational_landscape/views.py in render_variants(135)
for ms in ms_object:
|
|
+
|
SELECT ••• "residue_position_set"."id", "residue_position_set"."name", "residue_position_set"."set_type", "residue_position_set"."protein_group" FROM "residue_position_set" WHERE "residue_position_set"."name" = 'Sodium ion pocket'
3 similar queries.
|
|
0.34
|
|
|
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/mutational_landscape/views.py in render_variants(139)
sodium_pocket_rset = ResiduePositionSet.objects.get(name="Sodium ion pocket")
|
|
+
|
SELECT ••• "residue_generic_number_equivalent"."id", "residue_generic_number_equivalent"."default_generic_number_id", "residue_generic_number_equivalent"."scheme_id", "residue_generic_number_equivalent"."label" FROM "residue_generic_number_equivalent" INNER JOIN "residue_position_set_residue_position" ON ("residue_generic_number_equivalent"."id" = "residue_position_set_residue_position"."residuegenericnumberequivalent_id") WHERE "residue_position_set_residue_position"."residuepositionset_id" = 3
3 similar queries.
|
|
1.04
|
|
|
Connection: default
/usr/lib/python3.6/concurrent/futures/thread.py in _worker(69)
work_item.run()
/usr/lib/python3.6/concurrent/futures/thread.py in run(56)
result = self.fn(*self.args, **self.kwargs)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle(279)
keepalive = self.handle_request(req, conn)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle_request(328)
respiter = self.wsgi(environ, resp.start_response)
/home/protwis/gpcrdb_test/common/middleware/stats.py in __call__(34)
response = self.get_response(request)
/home/protwis/gpcrdb_test/mutational_landscape/views.py in render_variants(141)
for residue in sodium_pocket_rset.residue_position.all():
|
|
+
|
SELECT ••• "residue"."id", "residue"."protein_conformation_id", "residue"."protein_segment_id", "residue"."generic_number_id", "residue"."display_generic_number_id", "residue"."sequence_number", "residue"."amino_acid" FROM "residue" INNER JOIN "residue_generic_number" ON ("residue"."generic_number_id" = "residue_generic_number"."id") INNER JOIN "protein_conformation" ON ("residue"."protein_conformation_id" = "protein_conformation"."id") WHERE ("residue_generic_number"."label" IN ('5x47', '5x50', '6x30', '6x44', '6x50', '6x48', '6x34', '5x58', '3x40', '3x49', '3x50', '7x53', '7x50', '7x49', '7x43') AND "protein_conformation"."protein_id" = 139) ORDER BY "residue"."sequence_number" ASC
2 similar queries.
Duplicated 2 times.
|
|
1.37
|
|
|
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/mutational_landscape/views.py in render_variants(146)
for sp in sp_object:
|
|
+
|
SELECT ••• "residue_ptm"."id", "residue_ptm"."protein_id", "residue_ptm"."residue_id", "residue_ptm"."modification" FROM "residue_ptm" WHERE "residue_ptm"."protein_id" IN (139)
|
|
3.57
|
|
|
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/mutational_landscape/views.py in render_variants(149)
for ptm in ptms:
|
|
+
|
SELECT ••• "residue"."id", "residue"."protein_conformation_id", "residue"."protein_segment_id", "residue"."generic_number_id", "residue"."display_generic_number_id", "residue"."sequence_number", "residue"."amino_acid" FROM "residue" WHERE "residue"."id" IN (54112, 53987, 53923, 55077, 54118, 54987, 55083, 53887, 54195, 53909, 54197, 54008, 54235, 54108, 54078, 55071) ORDER BY "residue"."sequence_number" ASC
|
|
3.90
|
|
|
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/mutational_landscape/views.py in render_variants(149)
for ptm in ptms:
|
|
+
|
SELECT ••• "residue_position_set"."id", "residue_position_set"."name", "residue_position_set"."set_type", "residue_position_set"."protein_group" FROM "residue_position_set" WHERE "residue_position_set"."name" = 'G-protein interface'
3 similar queries.
|
|
0.34
|
|
|
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/mutational_landscape/views.py in render_variants(154)
rset = ResiduePositionSet.objects.get(name='G-protein interface')
|
|
+
|
SELECT ••• "residue_generic_number_equivalent"."id", "residue_generic_number_equivalent"."default_generic_number_id", "residue_generic_number_equivalent"."scheme_id", "residue_generic_number_equivalent"."label" FROM "residue_generic_number_equivalent" INNER JOIN "residue_position_set_residue_position" ON ("residue_generic_number_equivalent"."id" = "residue_position_set_residue_position"."residuegenericnumberequivalent_id") WHERE "residue_position_set_residue_position"."residuepositionset_id" = 1
3 similar queries.
|
|
1.06
|
|
|
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/mutational_landscape/views.py in render_variants(156)
for residue in rset.residue_position.all():
|
|
+
|
SELECT ••• "protein_family"."id", "protein_family"."parent_id", "protein_family"."slug", "protein_family"."name" FROM "protein_family" WHERE "protein_family"."id" = 187
|
|
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/mutational_landscape/views.py in render_variants(163)
orthologs = Protein.objects.filter(family__slug=proteins[0].family.slug, sequence_type__slug='wt')
|
|
+
|
SELECT ••• "interaction_residue_fragment"."id", "interaction_residue_fragment"."structure_ligand_pair_id", "interaction_residue_fragment"."rotamer_id", "interaction_residue_fragment"."fragment_id", "interaction_residue_fragment"."interaction_type_id" FROM "interaction_residue_fragment" INNER JOIN "interaction_structure_ligand" ON ("interaction_residue_fragment"."structure_ligand_pair_id" = "interaction_structure_ligand"."id") INNER JOIN "structure" ON ("interaction_structure_ligand"."structure_id" = "structure"."id") INNER JOIN "protein_conformation" ON ("structure"."protein_conformation_id" = "protein_conformation"."id") INNER JOIN "protein" ON ("protein_conformation"."protein_id" = "protein"."id") INNER JOIN "interaction_type_residue_fragment" ON ("interaction_residue_fragment"."interaction_type_id" = "interaction_type_residue_fragment"."id") WHERE ("interaction_structure_ligand"."annotated" = true AND "protein"."parent_id" IN (SELECT ••• U0."id" FROM "protein" U0 INNER JOIN "protein_family" U1 ON (U0."family_id" = U1."id") INNER JOIN "protein_sequence_type" U2 ON (U0."sequence_type_id" = U2."id") WHERE (U1."slug" = '001_003_003_003' AND U2."slug" = 'wt')) AND NOT ("interaction_type_residue_fragment"."type" = 'hidden' AND "interaction_type_residue_fragment"."type" IS NOT NULL))
|
|
130.40
|
|
|
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/mutational_landscape/views.py in render_variants(170)
for interaction in interactions:
|
|
+
|
SELECT ••• "mutation_natural"."id", "mutation_natural"."protein_id", "mutation_natural"."residue_id", "mutation_natural"."amino_acid", "mutation_natural"."type", "mutation_natural"."allele_frequency", "mutation_natural"."allele_count", "mutation_natural"."allele_number", "mutation_natural"."number_homozygotes", "mutation_natural"."sift_score", "mutation_natural"."polyphen_score" FROM "mutation_natural" WHERE "mutation_natural"."protein_id" IN (139)
|
|
11.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/mutational_landscape/views.py in render_variants(190)
for NM in NMs:
|
|
+
|
SELECT ••• "residue"."id", "residue"."protein_conformation_id", "residue"."protein_segment_id", "residue"."generic_number_id", "residue"."display_generic_number_id", "residue"."sequence_number", "residue"."amino_acid" FROM "residue" WHERE "residue"."id" IN (54280, 54285, 54797, 54799, 54800, 54801, 54803, 54805, 54806, 54807, 54808, 54297, 54298, 54809, 54812, 54815, 54305, 54306, 54819, 54310, 54822, 54314, 54827, 54316, 54826, 54318, 54830, 54321, 54834, 53812, 54324, 54839, 53818, 54842, 53820, 54847, 54849, 53826, 53828, 54855, 53832, 54856, 54860, 53837, 53839, 54863, 53841, 53842, 54867, 53844, 54869, 53846, 54872, 53850, 53851, 53852, 54876, 54877, 54878, 54881, 54882, 53858, 53859, 53861, 53862, 54883, 54887, 54890, 53867, 53866, 54892, 54894, 54898, 53878, 53879, 54907, 53887, 54916, 53893, 54918, 54924, 53900, 53902, 53903, 54927, 54930, 54933, 53911, 54936, 53913, 54935, 53915, 54938, 53919, 54948, 54950, 53927, 53930, 53931, 54957, 53934, 54959, 54960, 53937, 54961, 54965, 53942, 54969, 54970, 53947, 54972, 54975, 53953, 54977, 53955, 54981, 54982, 54983, 53963, 54988, 53965, 54990, 53970, 53972, 54997, 53974, 53975, 55003, 53988, 53991, 54010, 54014, 54024, 54025, 54026, 55048, 55050, 54029, 54030, 55056, 54033, 55058, 54035, 54038, 55062, 54042, 54043, 55067, 54048, 54050, 55074, 55076, 55077, 54054, 54055, 54057, 55083, 54061, 54064, 55089, 55091, 55093, 54076, 55103, 55107, 54084, 54085, 55109, 54087, 55110, 54089, 54092, 54100, 54101, 54104, 54108, 54111, 54113, 54114, 54115, 54117, 54120, 54130, 54133, 54136, 54138, 54143, 54144, 54145, 54148, 54150, 54154, 54155, 54156, 54157, 54160, 54163, 54164, 54170, 54174, 54178, 54182, 54183, 54184, 54185, 54189, 54198, 54199, 54200, 54202, 54203, 54208, 54209, 54210, 54213, 54217, 54218, 54220, 54225, 54229, 54231, 54232, 54234, 54242, 54250, 54254, 54257, 54258, 54260, 54262, 54264, 54267, 54269) ORDER BY "residue"."sequence_number" ASC
|
|
1.96
|
|
|
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/mutational_landscape/views.py in render_variants(190)
for NM in NMs:
|
|
+
|
SELECT ••• "residue_generic_number"."id", "residue_generic_number"."scheme_id", "residue_generic_number"."protein_segment_id", "residue_generic_number"."label" FROM "residue_generic_number" WHERE "residue_generic_number"."id" IN (92800, 44673, 12670, 32386, 35714, 37378, 39042, 40706, 43010, 48001, 2, 87176, 87809, 10, 11, 12, 21, 56984, 61080, 97436, 16414, 2079, 3230, 929, 1695, 27810, 34466, 37794, 40994, 42146, 50465, 9854, 77739, 91563, 25005, 97198, 80559, 93361, 55347, 52404, 14334, 59448, 61496, 63160, 82746, 89785, 22078, 11966, 15166, 13502, 28226, 29890, 31554, 33218, 36546, 38210, 39874, 41282, 54087, NULL, 74704, 71509, 57816, 61912, 63576, 25307, 65656, 66904, 24158, 11102, 17246, 45921, 98, 40290, 47585, 81632, 83810, 97259, 92526, 94078, 94325, 63992, 78461, 6526)
2 similar queries.
|
|
2.28
|
|
|
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/mutational_landscape/views.py in render_variants(190)
for NM in NMs:
|
|
+
|
SELECT ••• "residue_generic_number"."id", "residue_generic_number"."scheme_id", "residue_generic_number"."protein_segment_id", "residue_generic_number"."label" FROM "residue_generic_number" WHERE "residue_generic_number"."id" IN (81664, 45953, 40322, 47617, 48033, 96773, 66936, 83841, 87193, 92552, 90635, 17278, 87826, 25368, 25, 64024, 44705, 63608, 65688, 6558, 12702, 1312, 2080, 2464, 9886, 14366, 32418, 35746, 95527, 37410, 39074, 40738, 43043, 52781, 82778, 89816, 97203, 97459, 61112, 91578, 16446, 3262, 94783, 27842, 34498, 37826, 41026, 42178, 50882, 77766, 90330, NULL, 80591, 93390, 96210, 59480, 61528, 63192, 25051, 96732, 78491, 11998, 15198, 13534, 49249, 28258, 29922, 31586, 33250, 36578, 38242, 39906, 41314, 96483, 92829, 74732, 94104, 118, 97270, 61944, 71545, 90874, 11134, 94335)
2 similar queries.
|
|
0.81
|
|
|
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/mutational_landscape/views.py in render_variants(190)
for NM in NMs:
|
|
+
|
SELECT ••• "protein_segment"."id", "protein_segment"."slug", "protein_segment"."name", "protein_segment"."category", "protein_segment"."fully_aligned", "protein_segment"."partial", "protein_segment"."proteinfamily" FROM "protein_segment" WHERE "protein_segment"."id" IN (1, 5, 6, 7, 8, 10, 11, 12, 13, 14, 15, 16, 17, 18, 20, 21) ORDER BY "protein_segment"."id" ASC
2 similar queries.
Duplicated 2 times.
|
|
0.76
|
|
|
Connection: default
/usr/lib/python3.6/concurrent/futures/thread.py in _worker(69)
work_item.run()
/usr/lib/python3.6/concurrent/futures/thread.py in run(56)
result = self.fn(*self.args, **self.kwargs)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle(279)
keepalive = self.handle_request(req, conn)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle_request(328)
respiter = self.wsgi(environ, resp.start_response)
/home/protwis/gpcrdb_test/common/middleware/stats.py in __call__(34)
response = self.get_response(request)
/home/protwis/gpcrdb_test/mutational_landscape/views.py in render_variants(190)
for NM in NMs:
|
|
+
|
SELECT ••• "protein"."id", "protein"."parent_id", "protein"."family_id", "protein"."species_id", "protein"."source_id", "protein"."residue_numbering_scheme_id", "protein"."sequence_type_id", "protein"."entry_name", "protein"."accession", "protein"."name", "protein"."sequence" FROM "protein" WHERE "protein"."id" IN (139)
|
|
0.38
|
|
|
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/mutational_landscape/views.py in render_variants(190)
for NM in NMs:
|
|
+
|
SELECT ••• "residue"."id", "residue"."protein_conformation_id", "residue"."protein_segment_id", "residue"."generic_number_id", "residue"."display_generic_number_id", "residue"."sequence_number", "residue"."amino_acid" FROM "residue" INNER JOIN "protein_conformation" ON ("residue"."protein_conformation_id" = "protein_conformation"."id") WHERE "protein_conformation"."protein_id" = 139 ORDER BY "residue"."sequence_number" ASC
|
|
1.82
|
|
|
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/mutational_landscape/views.py in render_variants(237)
for r in residuelist:
|
|
+
|
SELECT ••• "protein_segment"."id", "protein_segment"."slug", "protein_segment"."name", "protein_segment"."category", "protein_segment"."fully_aligned", "protein_segment"."partial", "protein_segment"."proteinfamily" FROM "protein_segment" WHERE "protein_segment"."id" IN (1, 5, 6, 7, 8, 10, 11, 12, 13, 14, 15, 16, 17, 18, 20, 21) ORDER BY "protein_segment"."id" ASC
2 similar queries.
Duplicated 2 times.
|
|
0.51
|
|
|
Connection: default
/usr/lib/python3.6/concurrent/futures/thread.py in _worker(69)
work_item.run()
/usr/lib/python3.6/concurrent/futures/thread.py in run(56)
result = self.fn(*self.args, **self.kwargs)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle(279)
keepalive = self.handle_request(req, conn)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle_request(328)
respiter = self.wsgi(environ, resp.start_response)
/home/protwis/gpcrdb_test/common/middleware/stats.py in __call__(34)
response = self.get_response(request)
/home/protwis/gpcrdb_test/mutational_landscape/views.py in render_variants(237)
for r in residuelist:
|
|
+
|
SELECT ••• "residue_generic_number"."id", "residue_generic_number"."scheme_id", "residue_generic_number"."protein_segment_id", "residue_generic_number"."label" FROM "residue_generic_number" WHERE "residue_generic_number"."id" IN (47617, 28674, 35330, 49665, 96773, 71172, 88068, 90119, 90635, 64024, 25, 25625, 88601, 96797, 8222, 14366, 32, 2080, 30754, 37410, 43043, 79903, 85541, 93630, 83498, 52781, 91181, 94257, 96307, 66104, 572, 10302, 16446, 94783, 18494, 32834, 39490, 41026, 45121, 51265, 71, 80979, 95830, 77399, 59480, 61528, 3678, 5726, 84575, 47201, 28258, 34914, 49249, 53859, 82022, 89186, 76446, 94324, 118, 4094, 26230, 63608, 13950, 7806, 94335, 30338, 36994, 41602, 96387, 95366, 72323, 92123, 138, 73356, 86668, 148, 65688, 79512, 87193, 78491, 92829, 16030, 94366, 1696, 9886, 18078, 11422, 32418, 39074, 44705, 75426, 74409, 52403, 92339, 93876, 97459, 59064, 61112, 3262, 5310, 46785, 27842, 34498, 42178, 50882, 85196, 93390, 80591, 94936, 63192, 89816, 90330, 19678, 7390, 224, 11998, 29922, 13534, 36578, 48865, 96483, 84193, 91871, 83178, 246, 65272, 90874, 9470, 17662, 15614, 44289, 32002, 38658, 42755, 70910, 71935, 81664, 97548, 86285, 87826, 88343, 25368, 60696, 67352, 94491, 4894, 2847, 1312, 46369, 27426, 34082, 40738, 96031, 77091, 95527, 79141, 53553, 78131, 25912, 62776, 52026, 74041, 19262, 6974, 13118, 48449, 29506, 36162, 50498, 96574, 75076, 76096, 91462, NULL, 88916, 64856, 96089, 82778, 9054, 15198, 95073, 31586, 38242, 41314, 43873, 73062, 61944, 80234, 89457, 96117, 97654, 60280, 66936, 71545, 86907, 17278, 11134, 4478, 45953, 27010, 33666, 40322, 83841, 97152, 92552, 96654, 94607, 62360, 94104, 81307, 6558, 12702, 928, 2464, 29090, 35746, 41890, 48033, 50081, 93099, 53164, 94638, 96690, 97203, 64440, 85944, 91578, 95677, 18878, 8638, 11710, 14782, 31170, 37826, 43459, 51645, 77766, 78791, 76744, 84933, 96210, 66520, 75738, 25051, 96732, 73692, 10718, 16862, 87519, 45537, 26594, 33250, 39906, 42467, 82402, 95210, 74732, 96754, 91126, 53239, 59896, 97270, 72701, 6142)
2 similar queries.
|
|
1.93
|
|
|
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/mutational_landscape/views.py in render_variants(237)
for r in residuelist:
|
|
+
|
SELECT ••• "residue_generic_number"."id", "residue_generic_number"."scheme_id", "residue_generic_number"."protein_segment_id", "residue_generic_number"."label" FROM "residue_generic_number" WHERE "residue_generic_number"."id" IN (88576, 30722, 37378, 43010, 2, 6, 4, 79876, 85510, 9, 83467, 10, 11, 12, 15, 13, 17, 18, 19, 20, 21, 23, 24, 66072, 27, 16414, 2079, 10270, 18462, 32802, 39458, 40994, 45089, 52780, 94253, 53806, 55347, 80949, 77366, 57400, 59448, 61496, 3646, 5694, 22078, 26174, 28226, 34882, 47169, 51266, 81989, 84547, 596, 89174, 63576, 24158, 7774, 13918, 30306, 98, 36962, 41570, 72295, 73322, 94325, 65656, 79480, 86651, 78461, 9854, 18046, 11390, 15998, 126, 32386, 39042, 44673, 75396, 76414, 87176, 92800, 74380, 54927, 92307, 56984, 59032, 61080, 88056, 93849, 97436, 3230, 1695, 5278, 46753, 27810, 34466, 42146, 85164, 80559, 93361, 52404, 183, 63160, 89785, 187, 19646, 23742, 7358, 11966, 13502, 29890, 36546, 48833, 50881, 91838, 83146, 84171, 65240, 25307, 71900, 9438, 15582, 81632, 44257, 31970, 38626, 42722, 54507, 70898, 86259, 8190, 24574, 56568, 60664, 67320, 53500, 4862, 46337, 27394, 34050, 40706, 87809, 88322, 97537, 77076, 78102, 74007, 25880, 62744, 6942, 13086, 21278, 1313, 29474, 23326, 36130, 48417, 50466, 50465, 75046, 76072, 91437, 96047, 64824, 82746, 52027, 9022, 15166, 88894, 43841, 31554, 38210, 41282, 54087, 73034, NULL, 80210, 71509, 56152, 66904, 89432, 86875, 11102, 17246, 45921, 26978, 33634, 40290, 95588, 83810, 94561, 97637, 92526, 58232, 62328, 97144, 12670, 20862, 6526, 22910, 29058, 35714, 41858, 48001, 50049, 94078, 93066, 81293, 64408, 85912, 410, 11678, 2463, 8606, 929, 24990, 14750, 31138, 37794, 43426, 63992, 78761, 76714, 77739, 91563, 25005, 97198, 84911, 93615, 95153, 66488, 51642, 10686, 16830, 75712, 45505, 33218, 39874, 42434, 82370, 87493, 53191, 92098, 73674, 55758, 74704, 26584, 57816, 59864, 61912, 72668, 22494, 20446, 4062, 6110, 28642, 35298, 47585, 49633, 71138, 97259, 91122, 25592, 14334)
2 similar queries.
|
|
1.98
|
|
|
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/mutational_landscape/views.py in render_variants(237)
for r in residuelist:
|