Structure information

PTH1 receptor

PROTEIN CLASS

Class B1 (Secretin)

PDB CODE

6FJ3

SPECIES

Homo sapiens

RESOLUTION

2.500

PREFERRED CHAIN

A

PUBLICATION DATE

Nov. 21, 2018

NGL is a WebGL based 3D viewer powered by MMTF.

Download PDB file

Ligand Interaction Browser

Download list in excel
Ligand Amino Acid Generic Number Segment Interaction Type
Ligand Amino Acid Generic Number Segment Interaction Type
ePTH M32 N-term polar (hydrogen bond with backbone)
ePTH M32 N-term polar (hydrogen bond with backbone)
ePTH I38 N-term hydrophobic
ePTH L41 N-term hydrophobic
ePTH E111 N-term polar (charge-assisted hydrogen bond)
ePTH H114 N-term polar (hydrogen bond)
ePTH I115 N-term hydrophobic
ePTH I135 N-term hydrophobic
ePTH D137 N-term polar (charge-assisted hydrogen bond)
ePTH D137 N-term polar (charge-assisted hydrogen bond)
ePTH F138 N-term hydrophobic
ePTH T163 N-term polar (hydrogen bond with backbone)
ePTH T163 N-term polar (hydrogen bond with backbone)
ePTH L174 N-term polar (hydrogen bond with backbone)
ePTH F184 1.36x36 TM1 aromatic (edge-to-face)
ePTH Y195 1.47x47 TM1 polar (charge-assisted hydrogen bond)
ePTH R233 2.60x60 TM2 polar (charge-charge)
ePTH M240 2.67x67 TM2 hydrophobic
ePTH L244 2.71x71 TM2 hydrophobic
ePTH Y245 2.72x72 TM2 polar (hydrogen bond)
ePTH Y245 2.72x72 TM2 polar (hydrogen bond)
ePTH F288 3.36x36 TM3 hydrophobic
ePTH W352 45.51x51 ECL2 hydrophobic
ePTH L354 ECL2 hydrophobic
ePTH Y429 ECL3 polar (charge-assisted hydrogen bond)
ePTH E444 7.42x41 TM7 polar (charge-assisted hydrogen bond)
ePTH M445 7.43x42 TM7 hydrophobic
ePTH N448 7.46x45 TM7 polar (charge-assisted hydrogen bond)

Ligands

ePTH

3D interaction viewer Download PDB file

NGL is a WebGL based 3D viewer powered by MMTF.


Residue Diagrams

T L S A L S V S Y G V T Y I M G L R D F 1 M H L F L S F M L R A V S I F V K D A V 2 V L I W Y Y N T A L F Y L F F T V A V R 3 Y L W G F T V G F W G L P A V F V A V W V 4 F L I F N L V I S A L I P V Q I I W K K N 5 L V L M P L F G V H Y I V F M A T 6 I A V F F G Q F S N F L M E Y H M Q V 7
Download: PNG | SVG
ICL1 R R L H ICL1ECL1 L D E A E R L T E E E L R A I A Q A P P P P A T A A A ECL1ICL2 A F F ICL2ECL2 N T G C W D L S S ECL2ICL3 R E T N A G R C ICL3ECL3 P Y T E V S ECL3N-term M G T A R I A P G L A L L L C C P V L S S A Y A L V D A D D V M T K E E Q I F L L H R A Q A Q C E K R L K E V L Q R P A S I M E S D K G W T S A S T S G K P R K D K A S G K L Y P E S E E D K E A P T G S R Y R G R P C L P E W D H I L C W P L G A P G E V V A V P C P D Y I Y D F N H K G H A Y R R C D R N G S W E L V P G H N R T W A N Y S E C V K N-termC-term S G S S S Y S Y G P M V S H T S V T N V G P R V G L G L P L S P R L L P T A T T N G H P Q L P G H A K P G T P A L E T L E T T P P A M A A P K D D G F L N G S C S G L D E E A S G P E R P P A L L Q E E W E T V M C-term F L T N E T R E R E V F D R L G M I Y T V G Y S V S L A S L T V A V L I L A Y F C T R N Y I H M H L F L S F M L R A V S I F V K D A V L Y S G A T G Y A G C R V A V T F F L Y F L A T N Y Y W I L V E G L Y L H S L I F M S E K K Y L W G F T V F G W G L P A V F V A V W V S V R A T L A G N K K W I I Q V P I L A S I V L N F I L F I N I V R V L A T K L D T R Q Q Y R K L L K S T L V L M P L F G V H Y I V F M A T G T L W Q V Q M H Y E M L F N S F Q G F F V A I I Y C F C N G E I K K W T L K R K V Q A E S W S R A L D F A R
Download: PNG | SVG

Residue Table


GPCRdb(A)
GPCRdb(B)
PTH1 receptor
TM1
1x32 1.36x36 F184
1x43 1.47x47 Y195
TM2
2x53 2.60x60 R233
2x60 2.67x67 K240
2x64 2.71x71 L244
2x65 2.72x72 Y245
TM3
3x32 3.36x36 F288
ECL2
45x51 45.51x51 W352
TM7
7x37 7.42x41 E444
7x38 7.43x42 M445
7x41 7.46x45 N448
«

Versions

Package Name Version
Django 2.2.1
Python 3.6.7
debug_toolbar Debug Toolbar 1.11
polymorphic Polymorphic 2.0.3
rest_framework Django REST framework 3.9.3
rest_framework_swagger Rest_Framework_Swagger 2.2.0

Time

Resource usage

Resource Value
User CPU time 9338.635 msec
System CPU time 1576.936 msec
Total CPU time 10915.571 msec
Elapsed time 9630.902 msec
Context switches 315483 voluntary, 407 involuntary

Browser timing

Timing attribute Timeline Milliseconds since navigation start (+length)

Settings from protwis.settings

Setting Value
ABSOLUTE_URL_OVERRIDES {}
ADMINS []
ALLOWED_HOSTS ['*']
APPEND_SLASH True
AUTHENTICATION_BACKENDS ['django.contrib.auth.backends.ModelBackend']
AUTH_PASSWORD_VALIDATORS '********************'
AUTH_USER_MODEL 'auth.User'
BASE_DIR '/home/protwis/gpcrdb_test'
BUILD_CACHE_DIR '/home/protwis/gpcrdb_data/cache'
CACHES {'alignments': {'BACKEND': 'django.core.cache.backends.filebased.FileBasedCache', 'LOCATION': '/home/protwis/caches/test_alignment', 'OPTIONS': {'MAX_ENTRIES': 1000}}, 'default': {'BACKEND': 'django.core.cache.backends.filebased.FileBasedCache', 'LOCATION': '/home/protwis/caches/test/', 'OPTIONS': {'MAX_ENTRIES': 10000000}}}
CACHE_MIDDLEWARE_ALIAS 'default'
CACHE_MIDDLEWARE_KEY_PREFIX '********************'
CACHE_MIDDLEWARE_SECONDS 600
CSRF_COOKIE_AGE 31449600
CSRF_COOKIE_DOMAIN None
CSRF_COOKIE_HTTPONLY False
CSRF_COOKIE_NAME 'csrftoken'
CSRF_COOKIE_PATH '/'
CSRF_COOKIE_SAMESITE 'Lax'
CSRF_COOKIE_SECURE False
CSRF_FAILURE_VIEW 'django.views.csrf.csrf_failure'
CSRF_HEADER_NAME 'HTTP_X_CSRFTOKEN'
CSRF_TRUSTED_ORIGINS []
CSRF_USE_SESSIONS False
DATABASES {'default': {'ATOMIC_REQUESTS': False, 'AUTOCOMMIT': True, 'CONN_MAX_AGE': 0, 'ENGINE': 'django.db.backends.postgresql_psycopg2', 'HOST': 'localhost', 'NAME': 'protwis_202107', 'OPTIONS': {}, 'PASSWORD': '********************', 'PORT': '', 'TEST': {'CHARSET': None, 'COLLATION': None, 'MIRROR': None, 'NAME': None}, 'TIME_ZONE': None, 'USER': 'protwis'}}
DATABASE_ROUTERS []
DATA_DIR '/home/protwis/gpcrdb_data'
DATA_UPLOAD_MAX_MEMORY_SIZE 2621440
DATA_UPLOAD_MAX_NUMBER_FIELDS 1000
DATETIME_FORMAT 'N j, Y, P'
DATETIME_INPUT_FORMATS ['%Y-%m-%d %H:%M:%S', '%Y-%m-%d %H:%M:%S.%f', '%Y-%m-%d %H:%M', '%Y-%m-%d', '%m/%d/%Y %H:%M:%S', '%m/%d/%Y %H:%M:%S.%f', '%m/%d/%Y %H:%M', '%m/%d/%Y', '%m/%d/%y %H:%M:%S', '%m/%d/%y %H:%M:%S.%f', '%m/%d/%y %H:%M', '%m/%d/%y']
DATE_FORMAT 'N j, Y'
DATE_INPUT_FORMATS ['%Y-%m-%d', '%m/%d/%Y', '%m/%d/%y', '%b %d %Y', '%b %d, %Y', '%d %b %Y', '%d %b, %Y', '%B %d %Y', '%B %d, %Y', '%d %B %Y', '%d %B, %Y']
DEBUG True
DEBUG_PROPAGATE_EXCEPTIONS False
DEBUG_TOOLBAR_PATCH_SETTINGS False
DECIMAL_SEPARATOR '.'
DEFAULT_CHARSET 'utf-8'
DEFAULT_CONTENT_TYPE 'text/html'
DEFAULT_EXCEPTION_REPORTER_FILTER 'django.views.debug.SafeExceptionReporterFilter'
DEFAULT_FILE_STORAGE 'django.core.files.storage.FileSystemStorage'
DEFAULT_FROM_EMAIL 'webmaster@localhost'
DEFAULT_INDEX_TABLESPACE ''
DEFAULT_NUMBERING_SCHEME 'gpcrdb'
DEFAULT_PROTEIN_STATE 'inactive'
DEFAULT_SITE 'gpcr'
DEFAULT_TABLESPACE ''
DISALLOWED_USER_AGENTS []
DOCUMENTATION_URL 'https://docs.gpcrdb.org/'
EMAIL_BACKEND 'django.core.mail.backends.smtp.EmailBackend'
EMAIL_HOST 'localhost'
EMAIL_HOST_PASSWORD '********************'
EMAIL_HOST_USER ''
EMAIL_PORT 25
EMAIL_SSL_CERTFILE None
EMAIL_SSL_KEYFILE '********************'
EMAIL_SUBJECT_PREFIX '[Django] '
EMAIL_TIMEOUT None
EMAIL_USE_LOCALTIME False
EMAIL_USE_SSL False
EMAIL_USE_TLS False
FILE_CHARSET 'utf-8'
FILE_UPLOAD_DIRECTORY_PERMISSIONS None
FILE_UPLOAD_HANDLERS ['django.core.files.uploadhandler.MemoryFileUploadHandler', 'django.core.files.uploadhandler.TemporaryFileUploadHandler']
FILE_UPLOAD_MAX_MEMORY_SIZE 2621440
FILE_UPLOAD_PERMISSIONS None
FILE_UPLOAD_TEMP_DIR None
FIRST_DAY_OF_WEEK 0
FIXTURE_DIRS []
FORCE_SCRIPT_NAME None
FORMAT_MODULE_PATH None
FORM_RENDERER 'django.forms.renderers.DjangoTemplates'
GOOGLE_ANALYTICS_API '********************'
GOOGLE_ANALYTICS_KEY '********************'
IGNORABLE_404_URLS []
INSTALLED_APPS ('django.contrib.admin', 'django.contrib.auth', 'django.contrib.contenttypes', 'django.contrib.sessions', 'django.contrib.messages', 'django.contrib.staticfiles', 'django.contrib.humanize', 'debug_toolbar', 'rest_framework', 'rest_framework_swagger', 'polymorphic', 'common', 'api', 'news', 'pages', 'home', 'protein', 'family', 'residue', 'alignment', 'similaritysearch', 'similaritymatrix', 'structure', 'ligand', 'interaction', 'mutation', 'phylogenetic_trees', 'sitesearch', 'build_gpcr', 'construct', 'tools', 'drugs', 'signprot', 'signprot2', 'mutational_landscape', 'contactnetwork', 'seqsign', 'angles', 'hotspots')
INTERNAL_IPS '10.0.2.2'
LANGUAGES [('af', 'Afrikaans'), ('ar', 'Arabic'), ('ast', 'Asturian'), ('az', 'Azerbaijani'), ('bg', 'Bulgarian'), ('be', 'Belarusian'), ('bn', 'Bengali'), ('br', 'Breton'), ('bs', 'Bosnian'), ('ca', 'Catalan'), ('cs', 'Czech'), ('cy', 'Welsh'), ('da', 'Danish'), ('de', 'German'), ('dsb', 'Lower Sorbian'), ('el', 'Greek'), ('en', 'English'), ('en-au', 'Australian English'), ('en-gb', 'British English'), ('eo', 'Esperanto'), ('es', 'Spanish'), ('es-ar', 'Argentinian Spanish'), ('es-co', 'Colombian Spanish'), ('es-mx', 'Mexican Spanish'), ('es-ni', 'Nicaraguan Spanish'), ('es-ve', 'Venezuelan Spanish'), ('et', 'Estonian'), ('eu', 'Basque'), ('fa', 'Persian'), ('fi', 'Finnish'), ('fr', 'French'), ('fy', 'Frisian'), ('ga', 'Irish'), ('gd', 'Scottish Gaelic'), ('gl', 'Galician'), ('he', 'Hebrew'), ('hi', 'Hindi'), ('hr', 'Croatian'), ('hsb', 'Upper Sorbian'), ('hu', 'Hungarian'), ('hy', 'Armenian'), ('ia', 'Interlingua'), ('id', 'Indonesian'), ('io', 'Ido'), ('is', 'Icelandic'), ('it', 'Italian'), ('ja', 'Japanese'), ('ka', 'Georgian'), ('kab', 'Kabyle'), ('kk', 'Kazakh'), ('km', 'Khmer'), ('kn', 'Kannada'), ('ko', 'Korean'), ('lb', 'Luxembourgish'), ('lt', 'Lithuanian'), ('lv', 'Latvian'), ('mk', 'Macedonian'), ('ml', 'Malayalam'), ('mn', 'Mongolian'), ('mr', 'Marathi'), ('my', 'Burmese'), ('nb', 'Norwegian Bokmål'), ('ne', 'Nepali'), ('nl', 'Dutch'), ('nn', 'Norwegian Nynorsk'), ('os', 'Ossetic'), ('pa', 'Punjabi'), ('pl', 'Polish'), ('pt', 'Portuguese'), ('pt-br', 'Brazilian Portuguese'), ('ro', 'Romanian'), ('ru', 'Russian'), ('sk', 'Slovak'), ('sl', 'Slovenian'), ('sq', 'Albanian'), ('sr', 'Serbian'), ('sr-latn', 'Serbian Latin'), ('sv', 'Swedish'), ('sw', 'Swahili'), ('ta', 'Tamil'), ('te', 'Telugu'), ('th', 'Thai'), ('tr', 'Turkish'), ('tt', 'Tatar'), ('udm', 'Udmurt'), ('uk', 'Ukrainian'), ('ur', 'Urdu'), ('vi', 'Vietnamese'), ('zh-hans', 'Simplified Chinese'), ('zh-hant', 'Traditional Chinese')]
LANGUAGES_BIDI ['he', 'ar', 'fa', 'ur']
LANGUAGE_CODE 'en-us'
LANGUAGE_COOKIE_AGE None
LANGUAGE_COOKIE_DOMAIN None
LANGUAGE_COOKIE_NAME 'django_language'
LANGUAGE_COOKIE_PATH '/'
LOCALE_PATHS []
LOGGING {'disable_existing_loggers': False, 'formatters': {'verbose': {'datefmt': '%d/%b/%Y %H:%M:%S', 'format': '[%(asctime)s] %(levelname)s ' '[%(name)s:%(lineno)s] %(message)s'}, 'verbose_low': {'datefmt': '%d/%b/%Y %H:%M:%S', 'format': '[%(asctime)s] %(levelname)s ' '[%(name)s:%(lineno)s]'}}, 'handlers': {'build': {'class': 'logging.FileHandler', 'filename': 'logs/build.log', 'formatter': 'verbose', 'level': 'DEBUG'}, 'django': {'class': 'logging.FileHandler', 'filename': 'logs/django.log', 'formatter': 'verbose', 'level': 'WARNING'}, 'protwis': {'class': 'logging.FileHandler', 'filename': 'logs/protwis.log', 'formatter': 'verbose', 'level': 'DEBUG'}}, 'loggers': {'build': {'handlers': ['build'], 'level': 'DEBUG'}, 'django': {'handlers': ['django'], 'level': 'WARNING', 'propagate': True}, 'protwis': {'handlers': ['protwis'], 'level': 'DEBUG'}}, 'version': 1}
LOGGING_CONFIG 'logging.config.dictConfig'
LOGIN_REDIRECT_URL '/accounts/profile/'
LOGIN_URL '/accounts/login/'
LOGOUT_REDIRECT_URL None
MANAGERS []
MEDIA_ROOT '/protwis/media/protwis'
MEDIA_URL '/media/'
MESSAGE_STORAGE 'django.contrib.messages.storage.fallback.FallbackStorage'
MIDDLEWARE ('common.middleware.stats.StatsMiddleware', 'debug_toolbar.middleware.DebugToolbarMiddleware', 'django.contrib.sessions.middleware.SessionMiddleware', 'django.middleware.common.CommonMiddleware', 'django.middleware.csrf.CsrfViewMiddleware', 'django.contrib.auth.middleware.AuthenticationMiddleware', 'django.contrib.messages.middleware.MessageMiddleware', 'django.middleware.clickjacking.XFrameOptionsMiddleware')
MIGRATION_MODULES {}
MONTH_DAY_FORMAT 'F j'
NUMBER_GROUPING 0
PASSWORD_HASHERS '********************'
PASSWORD_RESET_TIMEOUT_DAYS '********************'
PREPEND_WWW False
REFERENCE_POSITIONS {'D1S1': 'D1S1x50', 'D1S2': 'D1S2x50', 'D1T1': 'D1T1x50', 'D1e1': 'D1e1x50', 'ECL1': '23x50', 'ECL2': '45x50', 'H8': '8x50', 'ICL1': '12x50', 'ICL2': '34x50', 'TM1': '1x50', 'TM2': '2x50', 'TM3': '3x50', 'TM4': '4x50', 'TM5': '5x50', 'TM6': '6x50', 'TM7': '7x50'}
ROOT_URLCONF 'protwis.urls'
SECRET_KEY '********************'
SECURE_BROWSER_XSS_FILTER False
SECURE_CONTENT_TYPE_NOSNIFF False
SECURE_HSTS_INCLUDE_SUBDOMAINS False
SECURE_HSTS_PRELOAD False
SECURE_HSTS_SECONDS 0
SECURE_PROXY_SSL_HEADER None
SECURE_REDIRECT_EXEMPT []
SECURE_SSL_HOST None
SECURE_SSL_REDIRECT False
SERVER_EMAIL 'root@localhost'
SESSION_CACHE_ALIAS 'default'
SESSION_COOKIE_AGE 86400
SESSION_COOKIE_DOMAIN None
SESSION_COOKIE_HTTPONLY True
SESSION_COOKIE_NAME 'sessionid'
SESSION_COOKIE_PATH '/'
SESSION_COOKIE_SAMESITE 'Lax'
SESSION_COOKIE_SECURE False
SESSION_ENGINE 'django.contrib.sessions.backends.db'
SESSION_EXPIRE_AT_BROWSER_CLOSE False
SESSION_FILE_PATH None
SESSION_SAVE_EVERY_REQUEST False
SESSION_SERIALIZER 'django.contrib.sessions.serializers.PickleSerializer'
SETTINGS_MODULE 'protwis.settings'
SHORT_DATETIME_FORMAT 'm/d/Y P'
SHORT_DATE_FORMAT 'm/d/Y'
SIGNING_BACKEND 'django.core.signing.TimestampSigner'
SILENCED_SYSTEM_CHECKS []
SITE_NAME 'gpcr'
SITE_TITLE 'GPCRdb'
STATICFILES_DIRS ('/home/protwis/gpcrdb_test/static',)
STATICFILES_FINDERS ['django.contrib.staticfiles.finders.FileSystemFinder', 'django.contrib.staticfiles.finders.AppDirectoriesFinder']
STATICFILES_STORAGE 'django.contrib.staticfiles.storage.StaticFilesStorage'
STATIC_ROOT '/home/protwis/static_test/'
STATIC_URL '/static/'
SWAGGER_SETTINGS {'USE_SESSION_AUTH': False}
TEMPLATES [{'APP_DIRS': True, 'BACKEND': 'django.template.backends.django.DjangoTemplates', 'DIRS': [], 'OPTIONS': {'context_processors': ['django.contrib.auth.context_processors.auth', 'django.template.context_processors.debug', 'django.template.context_processors.i18n', 'django.template.context_processors.media', 'django.template.context_processors.static', 'django.template.context_processors.tz', 'django.contrib.messages.context_processors.messages', 'protwis.context_processors.current_site', 'protwis.context_processors.canonical_tag', 'protwis.context_processors.documentation_url', 'protwis.context_processors.google_analytics', 'protwis.context_processors.site_title'], 'debug': True}}]
TEST_NON_SERIALIZED_APPS []
TEST_RUNNER 'django.test.runner.DiscoverRunner'
THOUSAND_SEPARATOR ','
TIME_FORMAT 'P'
TIME_INPUT_FORMATS ['%H:%M:%S', '%H:%M:%S.%f', '%H:%M']
TIME_ZONE 'Europe/Copenhagen'
USE_I18N True
USE_L10N True
USE_THOUSAND_SEPARATOR False
USE_TZ True
USE_X_FORWARDED_HOST False
USE_X_FORWARDED_PORT False
WSGI_APPLICATION None
X_FRAME_OPTIONS 'SAMEORIGIN'
YEAR_MONTH_FORMAT 'F Y'

Headers

Request headers

Key Value
Accept text/html,application/xhtml+xml,application/xml;q=0.9,*/*;q=0.8
Accept-Encoding br,gzip
Accept-Language en-US,en;q=0.5
Connection close
Host test.gpcrdb.org
User-Agent CCBot/2.0 (https://commoncrawl.org/faq/)
X-Forwarded-For 3.223.3.251
X-Forwarded-Proto https
X-Real-Ip 3.223.3.251

Response headers

Key Value
Content-Length 571622
Content-Type text/html; charset=utf-8
Vary Cookie
X-Frame-Options SAMEORIGIN

WSGI environ

Since the WSGI environ inherits the environment of the server, only a significant subset is shown below.

Key Value
PATH_INFO /interaction/6FJ3
QUERY_STRING
REMOTE_ADDR
REQUEST_METHOD GET
SCRIPT_NAME
SERVER_NAME test.gpcrdb.org
SERVER_PORT 443
SERVER_PROTOCOL HTTP/1.0
SERVER_SOFTWARE gunicorn/19.9.0

Request

View information

View function Arguments Keyword arguments URL name
interaction.views.StructureDetails () {'pdbname': '6FJ3'} structure_details

No cookies

No session data

No GET data

No POST data

SQL queries from 1 connection

  •   default 550.30 ms (369 queries including 352 similar and 160 duplicates )
  Query Timeline Time (ms) Action
  +
SELECT ••• "ligand"."name", "interaction_structure_ligand"."pdb_reference", "interaction_structure_ligand"."annotated", COUNT(DISTINCT "interaction_residue_fragment"."id") AS "numRes" FROM "interaction_residue_fragment" INNER JOIN "interaction_structure_ligand" ON ("interaction_residue_fragment"."structure_ligand_pair_id" = "interaction_structure_ligand"."id") INNER JOIN "ligand" ON ("interaction_structure_ligand"."ligand_id" = "ligand"."id") INNER JOIN "structure" ON ("interaction_structure_ligand"."structure_id" = "structure"."id") INNER JOIN "web_link" ON ("structure"."pdb_code_id" = "web_link"."id") WHERE "web_link"."index" = '6FJ3' GROUP BY "ligand"."name", "interaction_structure_ligand"."pdb_reference", "interaction_structure_ligand"."annotated" ORDER BY "numRes" DESC
2.7415373804059664%
15.09

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/interaction/views.py in StructureDetails(126)
  for structure in structures:
  +
SELECT ••• "structure"."id", "structure"."protein_conformation_id", "structure"."structure_type_id", "structure"."pdb_code_id", "structure"."state_id", "structure"."author_state_id", "structure"."publication_id", "structure"."preferred_chain", "structure"."resolution", "structure"."publication_date", "structure"."pdb_data_id", "structure"."representative", "structure"."distance_representative", "structure"."contact_representative", "structure"."contact_representative_score", "structure"."inactive_class_contacts_fraction", "structure"."active_class_contacts_fraction", "structure"."class_contact_representative", "structure"."annotated", "structure"."refined", "structure"."distance", "structure"."tm6_angle", "structure"."gprot_bound_likeness", "structure"."sodium", "structure"."signprot_complex_id", "structure"."stats_text_id", "structure"."mammal", "structure"."closest_to_human" FROM "structure" INNER JOIN "web_link" ON ("structure"."pdb_code_id" = "web_link"."id") WHERE "web_link"."index" = '6FJ3'
1.387622226044475%
7.64

Connection: default

/usr/lib/python3.6/concurrent/futures/thread.py in _worker(69)
  work_item.run()
/usr/lib/python3.6/concurrent/futures/thread.py in run(56)
  result = self.fn(*self.args, **self.kwargs)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle(279)
  keepalive = self.handle_request(req, conn)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle_request(328)
  respiter = self.wsgi(environ, resp.start_response)
/home/protwis/gpcrdb_test/common/middleware/stats.py in __call__(34)
  response = self.get_response(request)
/home/protwis/gpcrdb_test/interaction/views.py in StructureDetails(134)
  crystal = Structure.objects.get(pdb_code__index=pdbname)
  +
SELECT ••• "protein_conformation"."id", "protein_conformation"."protein_id", "protein_conformation"."state_id" FROM "protein_conformation" WHERE "protein_conformation"."id" = 55360
0.10865981462843585%
0.60

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/interaction/views.py in StructureDetails(135)
  p = Protein.objects.get(protein=crystal.protein_conformation.protein)
  +
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" = 55360
0.1927541926961368%
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/interaction/views.py in StructureDetails(135)
  p = Protein.objects.get(protein=crystal.protein_conformation.protein)
  +
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" INNER JOIN "protein" T2 ON ("protein"."id" = T2."parent_id") WHERE T2."id" = 55360
0.1345250097373578%
0.74

Connection: default

/usr/lib/python3.6/concurrent/futures/thread.py in _worker(69)
  work_item.run()
/usr/lib/python3.6/concurrent/futures/thread.py in run(56)
  result = self.fn(*self.args, **self.kwargs)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle(279)
  keepalive = self.handle_request(req, conn)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle_request(328)
  respiter = self.wsgi(environ, resp.start_response)
/home/protwis/gpcrdb_test/common/middleware/stats.py in __call__(34)
  response = self.get_response(request)
/home/protwis/gpcrdb_test/interaction/views.py in StructureDetails(135)
  p = Protein.objects.get(protein=crystal.protein_conformation.protein)
  +
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" = 300 ORDER BY "residue"."sequence_number" ASC
  2 similar queries.   Duplicated 2 times.
1.3127128083839625%
7.22

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/interaction/views.py in StructureDetails(141)
  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.16836205727516018%
0.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/interaction/views.py in StructureDetails(141)
  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 (48641, 29698, 36354, 50690, 95239, 54793, 96779, 80407, 65048, 89624, 9246, 11294, 15390, 31778, 38434, 96804, 94757, 41, 71721, 92208, 84020, 85045, 56376, 60472, 67128, 93240, 93754, 61, 4670, 17470, 97338, 27202, 33858, 40514, 94278, 86092, 91726, 98898, 97875, 99410, 19454, 98391, 62552, 84054, 94810, 11870, 2655, 1120, 6750, 12894, 29282, 35938, 98403, 98402, 98404, 48225, 50273, 53345, 76904, 90218, 90735, 94833, 78964, 95861, 94328, 120, 51834, 64632, 88184, 77949, 8830, 14974, 19070, 96385, 130, 31362, 38018, 75909, 87680, 74892, 55960, 66712, 53404, 10910, 17054, 26786, 33442, 40098, 54436, 95398, 88741, 91305, 71338, 80051, 94388, 89271, 60088, 62136, 72888, 91322, 4286, 6334, 12478, 49857, 28866, 35522, 70853, 99026, 94418, 83669, 7166, 94423, 98519, 64216, 14558, 2271, 736, 8414, 30946, 37602, 85727, 97508, 53991, 73825, 52972, 94959, 77552, 84726, 66296, 51450, 16638, 10494, 18686, 84734, 33026, 39682, 92424, 86794, 98573, 55571, 92948, 26392, 59672, 61720, 283, 68376, 285, 3870, 5918, 76571, 49441, 28450, 35106, 72483, 78627, 93991, 73512, 100137, 97586, 75573, 94518, 311, 26422, 63800, 317, 7998, 11582, 14142, 54079, 30530, 37186, 74564, 87363, 95558, 91972, 93510, 70986, NULL, 79695, 99154, 85331, 98647, 65880, 90971, 349, 10078, 18270, 16222, 1887, 32610, 39266, 90463, 91485, 98141, 52588, 55150, 55155, 59256, 95097, 61304, 67960, 84348, 88441, 5502, 12158, 3454, 51073, 28034, 34690, 80770, 89980, 98075, 77200, 63384, 97180, 413, 19870, 7582, 13726, 49057, 30114, 36770, 84385, 87965, 97702, 98206, 440, 65464, 15806, 9662, 17854, 72127, 32194, 38850, 79300, 86472, 94153, 94666, 53710, 78287, 97232, 96209, 98770, 99282, 75219, 89043, 56792, 53721, 95706, 60888, 67544, 98269, 3038, 1503, 5086, 96736, 27618, 34274, 73184, 76263, 74224, 52211, 92661, 96758, 62968, 13310, 87039)
  4 similar queries.   Duplicated 2 times.
0.45097289093596044%
2.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/interaction/views.py in StructureDetails(141)
  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, 1, 97794, 30722, 37378, 43010, 2, 6, 4, 79876, 85510, 83467, 9, 10, 11, 15, 12, 17, 18, 19, 20, 21, 13, 23, 24, 66072, 27, 16414, 2079, 10270, 18462, 32802, 39458, 45089, 52780, 94253, 53806, 55347, 77366, 26168, 57400, 59448, 61496, 68152, 3646, 5694, 22078, 26174, 28226, 34882, 47169, 51266, 70718, 84544, 84547, 596, 89174, 63576, 24158, 7774, 13918, 98, 30306, 36962, 72295, 73322, 94323, 94325, 119, 65656, 79480, 86651, 78461, 9854, 18046, 11390, 15998, 126, 32386, 39042, 44673, 75396, 76414, 136, 87176, 74380, 53902, 54927, 92307, 56984, 59032, 61080, 67736, 88056, 93849, 3230, 1695, 5278, 46753, 27810, 34466, 97436, 85164, 80559, 93361, 52404, 183, 63160, 89785, 187, 188, 19646, 23742, 7358, 11966, 13502, 29890, 36546, 48833, 50881, 91838, 84171, 65240, 71900, 9438, 15582, 84191, 44257, 31970, 38626, 70898, 86259, 94078, 8190, 24574, 56568, 60664, 67320, 98042, 53500, 4862, 46337, 27394, 34050, 87809, 88322, 97537, 77076, 78102, 74007, 62744, 100122, 53532, 6942, 13086, 21278, 1313, 23326, 29474, 36130, 48417, 50466, 50465, 75046, 76072, 91437, 96047, 98103, 64824, 25403, 52027, 9022, 15166, 88894, 43841, 31554, 38210, 73034, 54603, NULL, 80210, 71509, 56152, 66904, 89432, 86875, 11102, 17246, 45921, 26978, 33634, 40290, 83810, 94561, 97637, 92526, 98167, 58232, 62328, 97144, 12670, 20862, 6526, 22910, 29058, 35714, 48001, 50049, 83838, 94599, 93066, 64408, 85912, 410, 11678, 2463, 8606, 929, 24990, 14750, 31138, 37794, 43426, 78761, 76714, 77739, 91563, 53165, 97198, 84911, 93615, 66488, 51642, 10686, 16830, 75712, 45505, 33218, 39874, 92098, 87493, 53191, 73674, 55758, 74704, 92800, 98264, 26584, 57816, 59864, 61912, 72668, 22494, 20446, 4062, 6110, 12254, 28642, 35298, 47585, 49633, 54247, 71138, 97259, 91122, 63992, 14334)
  4 similar queries.   Duplicated 2 times.
0.3357709582816499%
1.85

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/interaction/views.py in StructureDetails(141)
  for r in residuelist:
  +
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 "web_link" ON ("structure"."pdb_code_id" = "web_link"."id") INNER JOIN "interaction_type_residue_fragment" ON ("interaction_residue_fragment"."interaction_type_id" = "interaction_type_residue_fragment"."id") INNER JOIN "structure_rotamer" ON ("interaction_residue_fragment"."rotamer_id" = "structure_rotamer"."id") INNER JOIN "residue" ON ("structure_rotamer"."residue_id" = "residue"."id") WHERE ("interaction_structure_ligand"."annotated" = true AND "web_link"."index" = '6FJ3' AND NOT ("interaction_type_residue_fragment"."type" = 'hidden' AND "interaction_type_residue_fragment"."type" IS NOT NULL)) ORDER BY "residue"."sequence_number" ASC
3.0650472830497186%
16.87

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/interaction/views.py in StructureDetails(153)
  for residue in residues:
  +
SELECT ••• "interaction_type_residue_fragment"."id", "interaction_type_residue_fragment"."slug", "interaction_type_residue_fragment"."name", "interaction_type_residue_fragment"."type", "interaction_type_residue_fragment"."direction" FROM "interaction_type_residue_fragment" WHERE "interaction_type_residue_fragment"."id" = 5
  28 similar queries.   Duplicated 5 times.
0.08877350884117427%
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/interaction/views.py in StructureDetails(154)
  key = residue.interaction_type.name
  +
SELECT ••• "structure_rotamer"."id", "structure_rotamer"."residue_id", "structure_rotamer"."structure_id", "structure_rotamer"."pdbdata_id", "structure_rotamer"."missing_atoms" FROM "structure_rotamer" WHERE "structure_rotamer"."id" = 50369
  28 similar queries.
0.09817509567306047%
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/interaction/views.py in StructureDetails(155)
  aa = residue.rotamer.residue.amino_acid
  +
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" = 23606053
  28 similar queries.   Duplicated 2 times.
0.07300310512317161%
0.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/interaction/views.py in StructureDetails(155)
  aa = residue.rotamer.residue.amino_acid
  +
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" = 1
  28 similar queries.   Duplicated 14 times.
0.0774656094719471%
0.43

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/interaction/views.py in StructureDetails(164)
  if residue.rotamer.residue.protein_segment:
  +
SELECT ••• "interaction_structure_ligand"."id", "interaction_structure_ligand"."structure_id", "interaction_structure_ligand"."ligand_id", "interaction_structure_ligand"."ligand_role_id", "interaction_structure_ligand"."pdb_reference", "interaction_structure_ligand"."pdb_file_id", "interaction_structure_ligand"."annotated" FROM "interaction_structure_ligand" WHERE "interaction_structure_ligand"."id" = 312
  28 similar queries.   Duplicated 28 times.
0.08942338811526779%
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/interaction/views.py in StructureDetails(172)
  ligand = residue.structure_ligand_pair.ligand.name
  +
SELECT ••• "ligand"."id", "ligand"."properities_id", "ligand"."name", "ligand"."pdbe", "ligand"."canonical", "ligand"."ambigious_alias", "ligand"."endogenous" FROM "ligand" WHERE "ligand"."id" = 167
  28 similar queries.   Duplicated 28 times.
0.08487423319661318%
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/interaction/views.py in StructureDetails(172)
  ligand = residue.structure_ligand_pair.ligand.name
  +
SELECT ••• "interaction_type_residue_fragment"."id", "interaction_type_residue_fragment"."slug", "interaction_type_residue_fragment"."name", "interaction_type_residue_fragment"."type", "interaction_type_residue_fragment"."direction" FROM "interaction_type_residue_fragment" WHERE "interaction_type_residue_fragment"."id" = 5
  28 similar queries.   Duplicated 5 times.
0.07694570605267229%
0.42

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/interaction/views.py in StructureDetails(154)
  key = residue.interaction_type.name
  +
SELECT ••• "structure_rotamer"."id", "structure_rotamer"."residue_id", "structure_rotamer"."structure_id", "structure_rotamer"."pdbdata_id", "structure_rotamer"."missing_atoms" FROM "structure_rotamer" WHERE "structure_rotamer"."id" = 50370
  28 similar queries.
0.06052542306057611%
0.33

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/interaction/views.py in StructureDetails(155)
  aa = residue.rotamer.residue.amino_acid
  +
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" = 23606053
  28 similar queries.   Duplicated 2 times.
0.08331452293878873%
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/interaction/views.py in StructureDetails(155)
  aa = residue.rotamer.residue.amino_acid
  +
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" = 1
  28 similar queries.   Duplicated 14 times.
0.0681939984948796%
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/interaction/views.py in StructureDetails(164)
  if residue.rotamer.residue.protein_segment:
  +
SELECT ••• "interaction_structure_ligand"."id", "interaction_structure_ligand"."structure_id", "interaction_structure_ligand"."ligand_id", "interaction_structure_ligand"."ligand_role_id", "interaction_structure_ligand"."pdb_reference", "interaction_structure_ligand"."pdb_file_id", "interaction_structure_ligand"."annotated" FROM "interaction_structure_ligand" WHERE "interaction_structure_ligand"."id" = 312
  28 similar queries.   Duplicated 28 times.
0.06702421580151127%
0.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/interaction/views.py in StructureDetails(172)
  ligand = residue.structure_ligand_pair.ligand.name
  +
SELECT ••• "ligand"."id", "ligand"."properities_id", "ligand"."name", "ligand"."pdbe", "ligand"."canonical", "ligand"."ambigious_alias", "ligand"."endogenous" FROM "ligand" WHERE "ligand"."id" = 167
  28 similar queries.   Duplicated 28 times.
0.0662010353876595%
0.36

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/interaction/views.py in StructureDetails(172)
  ligand = residue.structure_ligand_pair.ligand.name
  +
SELECT ••• "interaction_type_residue_fragment"."id", "interaction_type_residue_fragment"."slug", "interaction_type_residue_fragment"."name", "interaction_type_residue_fragment"."type", "interaction_type_residue_fragment"."direction" FROM "interaction_type_residue_fragment" WHERE "interaction_type_residue_fragment"."id" = 3
  28 similar queries.   Duplicated 11 times.
0.09098309837309222%
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/interaction/views.py in StructureDetails(154)
  key = residue.interaction_type.name
  +
SELECT ••• "structure_rotamer"."id", "structure_rotamer"."residue_id", "structure_rotamer"."structure_id", "structure_rotamer"."pdbdata_id", "structure_rotamer"."missing_atoms" FROM "structure_rotamer" WHERE "structure_rotamer"."id" = 50014
  28 similar queries.
0.07824546460085931%
0.43

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/interaction/views.py in StructureDetails(155)
  aa = residue.rotamer.residue.amino_acid
  +
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" = 23606059
  28 similar queries.
0.08383442635806355%
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/interaction/views.py in StructureDetails(155)
  aa = residue.rotamer.residue.amino_acid
  +
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" = 1
  28 similar queries.   Duplicated 14 times.
0.07898199444483196%
0.43

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/interaction/views.py in StructureDetails(164)
  if residue.rotamer.residue.protein_segment:
  +
SELECT ••• "interaction_structure_ligand"."id", "interaction_structure_ligand"."structure_id", "interaction_structure_ligand"."ligand_id", "interaction_structure_ligand"."ligand_role_id", "interaction_structure_ligand"."pdb_reference", "interaction_structure_ligand"."pdb_file_id", "interaction_structure_ligand"."annotated" FROM "interaction_structure_ligand" WHERE "interaction_structure_ligand"."id" = 312
  28 similar queries.   Duplicated 28 times.
0.0806716805574751%
0.44

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/interaction/views.py in StructureDetails(172)
  ligand = residue.structure_ligand_pair.ligand.name
  +
SELECT ••• "ligand"."id", "ligand"."properities_id", "ligand"."name", "ligand"."pdbe", "ligand"."canonical", "ligand"."ambigious_alias", "ligand"."endogenous" FROM "ligand" WHERE "ligand"."id" = 167
  28 similar queries.   Duplicated 28 times.
0.08608734117492108%
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/interaction/views.py in StructureDetails(172)
  ligand = residue.structure_ligand_pair.ligand.name
  +
SELECT ••• "interaction_type_residue_fragment"."id", "interaction_type_residue_fragment"."slug", "interaction_type_residue_fragment"."name", "interaction_type_residue_fragment"."type", "interaction_type_residue_fragment"."direction" FROM "interaction_type_residue_fragment" WHERE "interaction_type_residue_fragment"."id" = 3
  28 similar queries.   Duplicated 11 times.
0.07036026274185798%
0.39

Connection: default

/usr/lib/python3.6/concurrent/futures/thread.py in _worker(69)
  work_item.run()
/usr/lib/python3.6/concurrent/futures/thread.py in run(56)
  result = self.fn(*self.args, **self.kwargs)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle(279)
  keepalive = self.handle_request(req, conn)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle_request(328)
  respiter = self.wsgi(environ, resp.start_response)
/home/protwis/gpcrdb_test/common/middleware/stats.py in __call__(34)
  response = self.get_response(request)
/home/protwis/gpcrdb_test/interaction/views.py in StructureDetails(154)
  key = residue.interaction_type.name
  +
SELECT ••• "structure_rotamer"."id", "structure_rotamer"."residue_id", "structure_rotamer"."structure_id", "structure_rotamer"."pdbdata_id", "structure_rotamer"."missing_atoms" FROM "structure_rotamer" WHERE "structure_rotamer"."id" = 50016
  28 similar queries.
0.08643394345443761%
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/interaction/views.py in StructureDetails(155)
  aa = residue.rotamer.residue.amino_acid
  +
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" = 23606062
  28 similar queries.
0.06741414336596738%
0.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/interaction/views.py in StructureDetails(155)
  aa = residue.rotamer.residue.amino_acid
  +
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" = 1
  28 similar queries.   Duplicated 14 times.
0.09098309837309222%
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/interaction/views.py in StructureDetails(164)
  if residue.rotamer.residue.protein_segment:
  +
SELECT ••• "interaction_structure_ligand"."id", "interaction_structure_ligand"."structure_id", "interaction_structure_ligand"."ligand_id", "interaction_structure_ligand"."ligand_role_id", "interaction_structure_ligand"."pdb_reference", "interaction_structure_ligand"."pdb_file_id", "interaction_structure_ligand"."annotated" FROM "interaction_structure_ligand" WHERE "interaction_structure_ligand"."id" = 312
  28 similar queries.   Duplicated 28 times.
0.0873870997231081%
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/interaction/views.py in StructureDetails(172)
  ligand = residue.structure_ligand_pair.ligand.name
  +
SELECT ••• "ligand"."id", "ligand"."properities_id", "ligand"."name", "ligand"."pdbe", "ligand"."canonical", "ligand"."ambigious_alias", "ligand"."endogenous" FROM "ligand" WHERE "ligand"."id" = 167
  28 similar queries.   Duplicated 28 times.
0.0722232499942594%
0.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/interaction/views.py in StructureDetails(172)
  ligand = residue.structure_ligand_pair.ligand.name
  +
SELECT ••• "interaction_type_residue_fragment"."id", "interaction_type_residue_fragment"."slug", "interaction_type_residue_fragment"."name", "interaction_type_residue_fragment"."type", "interaction_type_residue_fragment"."direction" FROM "interaction_type_residue_fragment" WHERE "interaction_type_residue_fragment"."id" = 11
  28 similar queries.   Duplicated 4 times.
0.08275129423457436%
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/interaction/views.py in StructureDetails(154)
  key = residue.interaction_type.name
  +
SELECT ••• "structure_rotamer"."id", "structure_rotamer"."residue_id", "structure_rotamer"."structure_id", "structure_rotamer"."pdbdata_id", "structure_rotamer"."missing_atoms" FROM "structure_rotamer" WHERE "structure_rotamer"."id" = 50383
  28 similar queries.
0.07421621310147951%
0.41

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/interaction/views.py in StructureDetails(155)
  aa = residue.rotamer.residue.amino_acid
  +
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" = 23606088
  28 similar queries.
0.08231804138517868%
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/interaction/views.py in StructureDetails(155)
  aa = residue.rotamer.residue.amino_acid
  +
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" = 1
  28 similar queries.   Duplicated 14 times.
0.08088830698217295%
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/interaction/views.py in StructureDetails(164)
  if residue.rotamer.residue.protein_segment:
  +
SELECT ••• "interaction_structure_ligand"."id", "interaction_structure_ligand"."structure_id", "interaction_structure_ligand"."ligand_id", "interaction_structure_ligand"."ligand_role_id", "interaction_structure_ligand"."pdb_reference", "interaction_structure_ligand"."pdb_file_id", "interaction_structure_ligand"."annotated" FROM "interaction_structure_ligand" WHERE "interaction_structure_ligand"."id" = 312
  28 similar queries.   Duplicated 28 times.
0.08335784822372831%
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/interaction/views.py in StructureDetails(172)
  ligand = residue.structure_ligand_pair.ligand.name
  +
SELECT ••• "ligand"."id", "ligand"."properities_id", "ligand"."name", "ligand"."pdbe", "ligand"."canonical", "ligand"."ambigious_alias", "ligand"."endogenous" FROM "ligand" WHERE "ligand"."id" = 167
  28 similar queries.   Duplicated 28 times.
0.07568927278942482%
0.42

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/interaction/views.py in StructureDetails(172)
  ligand = residue.structure_ligand_pair.ligand.name
  +
SELECT ••• "interaction_type_residue_fragment"."id", "interaction_type_residue_fragment"."slug", "interaction_type_residue_fragment"."name", "interaction_type_residue_fragment"."type", "interaction_type_residue_fragment"."direction" FROM "interaction_type_residue_fragment" WHERE "interaction_type_residue_fragment"."id" = 8
  28 similar queries.
0.08171148739602474%
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/interaction/views.py in StructureDetails(154)
  key = residue.interaction_type.name
  +
SELECT ••• "structure_rotamer"."id", "structure_rotamer"."residue_id", "structure_rotamer"."structure_id", "structure_rotamer"."pdbdata_id", "structure_rotamer"."missing_atoms" FROM "structure_rotamer" WHERE "structure_rotamer"."id" = 50380
  28 similar queries.
0.08158151154120602%
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/interaction/views.py in StructureDetails(155)
  aa = residue.rotamer.residue.amino_acid
  +
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" = 23606091
  28 similar queries.
0.06243173559791709%
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/interaction/views.py in StructureDetails(155)
  aa = residue.rotamer.residue.amino_acid
  +
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" = 1
  28 similar queries.   Duplicated 14 times.
0.08574073889540454%
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/interaction/views.py in StructureDetails(164)
  if residue.rotamer.residue.protein_segment:
  +
SELECT ••• "interaction_structure_ligand"."id", "interaction_structure_ligand"."structure_id", "interaction_structure_ligand"."ligand_id", "interaction_structure_ligand"."ligand_role_id", "interaction_structure_ligand"."pdb_reference", "interaction_structure_ligand"."pdb_file_id", "interaction_structure_ligand"."annotated" FROM "interaction_structure_ligand" WHERE "interaction_structure_ligand"."id" = 312
  28 similar queries.   Duplicated 28 times.
0.06602773424790122%
0.36

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/interaction/views.py in StructureDetails(172)
  ligand = residue.structure_ligand_pair.ligand.name
  +
SELECT ••• "ligand"."id", "ligand"."properities_id", "ligand"."name", "ligand"."pdbe", "ligand"."canonical", "ligand"."ambigious_alias", "ligand"."endogenous" FROM "ligand" WHERE "ligand"."id" = 167
  28 similar queries.   Duplicated 28 times.
0.07204994885450113%
0.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/interaction/views.py in StructureDetails(172)
  ligand = residue.structure_ligand_pair.ligand.name
  +
SELECT ••• "interaction_type_residue_fragment"."id", "interaction_type_residue_fragment"."slug", "interaction_type_residue_fragment"."name", "interaction_type_residue_fragment"."type", "interaction_type_residue_fragment"."direction" FROM "interaction_type_residue_fragment" WHERE "interaction_type_residue_fragment"."id" = 3
  28 similar queries.   Duplicated 11 times.
0.07997847599844202%
0.44

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/interaction/views.py in StructureDetails(154)
  key = residue.interaction_type.name
  +
SELECT ••• "structure_rotamer"."id", "structure_rotamer"."residue_id", "structure_rotamer"."structure_id", "structure_rotamer"."pdbdata_id", "structure_rotamer"."missing_atoms" FROM "structure_rotamer" WHERE "structure_rotamer"."id" = 50021
  28 similar queries.
0.07837544045567801%
0.43

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/interaction/views.py in StructureDetails(155)
  aa = residue.rotamer.residue.amino_acid
  +
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" = 23606092
  28 similar queries.
0.07352300854244642%
0.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/interaction/views.py in StructureDetails(155)
  aa = residue.rotamer.residue.amino_acid
  +
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" = 1
  28 similar queries.   Duplicated 14 times.
0.09418916945862024%
0.52

Connection: default

/usr/lib/python3.6/concurrent/futures/thread.py in _worker(69)
  work_item.run()
/usr/lib/python3.6/concurrent/futures/thread.py in run(56)
  result = self.fn(*self.args, **self.kwargs)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle(279)
  keepalive = self.handle_request(req, conn)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle_request(328)
  respiter = self.wsgi(environ, resp.start_response)
/home/protwis/gpcrdb_test/common/middleware/stats.py in __call__(34)
  response = self.get_response(request)
/home/protwis/gpcrdb_test/interaction/views.py in StructureDetails(164)
  if residue.rotamer.residue.protein_segment:
  +
SELECT ••• "interaction_structure_ligand"."id", "interaction_structure_ligand"."structure_id", "interaction_structure_ligand"."ligand_id", "interaction_structure_ligand"."ligand_role_id", "interaction_structure_ligand"."pdb_reference", "interaction_structure_ligand"."pdb_file_id", "interaction_structure_ligand"."annotated" FROM "interaction_structure_ligand" WHERE "interaction_structure_ligand"."id" = 312
  28 similar queries.   Duplicated 28 times.
0.08998661681948217%
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/interaction/views.py in StructureDetails(172)
  ligand = residue.structure_ligand_pair.ligand.name
  +
SELECT ••• "ligand"."id", "ligand"."properities_id", "ligand"."name", "ligand"."pdbe", "ligand"."canonical", "ligand"."ambigious_alias", "ligand"."endogenous" FROM "ligand" WHERE "ligand"."id" = 167
  28 similar queries.   Duplicated 28 times.
0.07629582677857877%
0.42

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/interaction/views.py in StructureDetails(172)
  ligand = residue.structure_ligand_pair.ligand.name
  +
SELECT ••• "interaction_type_residue_fragment"."id", "interaction_type_residue_fragment"."slug", "interaction_type_residue_fragment"."name", "interaction_type_residue_fragment"."type", "interaction_type_residue_fragment"."direction" FROM "interaction_type_residue_fragment" WHERE "interaction_type_residue_fragment"."id" = 3
  28 similar queries.   Duplicated 11 times.
0.06784739621536306%
0.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/interaction/views.py in StructureDetails(154)
  key = residue.interaction_type.name
  +
SELECT ••• "structure_rotamer"."id", "structure_rotamer"."residue_id", "structure_rotamer"."structure_id", "structure_rotamer"."pdbdata_id", "structure_rotamer"."missing_atoms" FROM "structure_rotamer" WHERE "structure_rotamer"."id" = 50023
  28 similar queries.
0.07308975569305076%
0.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/interaction/views.py in StructureDetails(155)
  aa = residue.rotamer.residue.amino_acid
  +
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" = 23606112
  28 similar queries.
0.38264891658626216%
2.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/interaction/views.py in StructureDetails(155)
  aa = residue.rotamer.residue.amino_acid
  +
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" = 1
  28 similar queries.   Duplicated 14 times.
0.06810734792500046%
0.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/interaction/views.py in StructureDetails(164)
  if residue.rotamer.residue.protein_segment:
  +
SELECT ••• "interaction_structure_ligand"."id", "interaction_structure_ligand"."structure_id", "interaction_structure_ligand"."ligand_id", "interaction_structure_ligand"."ligand_role_id", "interaction_structure_ligand"."pdb_reference", "interaction_structure_ligand"."pdb_file_id", "interaction_structure_ligand"."annotated" FROM "interaction_structure_ligand" WHERE "interaction_structure_ligand"."id" = 312
  28 similar queries.   Duplicated 28 times.
0.06407809642562066%
0.35

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/interaction/views.py in StructureDetails(172)
  ligand = residue.structure_ligand_pair.ligand.name
  +
SELECT ••• "ligand"."id", "ligand"."properities_id", "ligand"."name", "ligand"."pdbe", "ligand"."canonical", "ligand"."ambigious_alias", "ligand"."endogenous" FROM "ligand" WHERE "ligand"."id" = 167
  28 similar queries.   Duplicated 28 times.
0.21844608666530047%
1.20

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/interaction/views.py in StructureDetails(172)
  ligand = residue.structure_ligand_pair.ligand.name
  +
SELECT ••• "interaction_type_residue_fragment"."id", "interaction_type_residue_fragment"."slug", "interaction_type_residue_fragment"."name", "interaction_type_residue_fragment"."type", "interaction_type_residue_fragment"."direction" FROM "interaction_type_residue_fragment" WHERE "interaction_type_residue_fragment"."id" = 11
  28 similar queries.   Duplicated 4 times.
0.13309527533435206%
0.73

Connection: default

/usr/lib/python3.6/concurrent/futures/thread.py in _worker(69)
  work_item.run()
/usr/lib/python3.6/concurrent/futures/thread.py in run(56)
  result = self.fn(*self.args, **self.kwargs)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle(279)
  keepalive = self.handle_request(req, conn)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle_request(328)
  respiter = self.wsgi(environ, resp.start_response)
/home/protwis/gpcrdb_test/common/middleware/stats.py in __call__(34)
  response = self.get_response(request)
/home/protwis/gpcrdb_test/interaction/views.py in StructureDetails(154)
  key = residue.interaction_type.name
  +
SELECT ••• "structure_rotamer"."id", "structure_rotamer"."residue_id", "structure_rotamer"."structure_id", "structure_rotamer"."pdbdata_id", "structure_rotamer"."missing_atoms" FROM "structure_rotamer" WHERE "structure_rotamer"."id" = 50376
  28 similar queries.
0.07911197029965067%
0.44

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/interaction/views.py in StructureDetails(155)
  aa = residue.rotamer.residue.amino_acid
  +
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" = 23606114
  28 similar queries.   Duplicated 2 times.
0.07932859672434851%
0.44

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/interaction/views.py in StructureDetails(155)
  aa = residue.rotamer.residue.amino_acid
  +
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" = 1
  28 similar queries.   Duplicated 14 times.
0.06992700989246231%
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/interaction/views.py in StructureDetails(164)
  if residue.rotamer.residue.protein_segment:
  +
SELECT ••• "interaction_structure_ligand"."id", "interaction_structure_ligand"."structure_id", "interaction_structure_ligand"."ligand_id", "interaction_structure_ligand"."ligand_role_id", "interaction_structure_ligand"."pdb_reference", "interaction_structure_ligand"."pdb_file_id", "interaction_structure_ligand"."annotated" FROM "interaction_structure_ligand" WHERE "interaction_structure_ligand"."id" = 312
  28 similar queries.   Duplicated 28 times.
0.06897385362379181%
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/interaction/views.py in StructureDetails(172)
  ligand = residue.structure_ligand_pair.ligand.name
  +
SELECT ••• "ligand"."id", "ligand"."properities_id", "ligand"."name", "ligand"."pdbe", "ligand"."canonical", "ligand"."ambigious_alias", "ligand"."endogenous" FROM "ligand" WHERE "ligand"."id" = 167
  28 similar queries.   Duplicated 28 times.
0.7821513690140163%
4.30

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/interaction/views.py in StructureDetails(172)
  ligand = residue.structure_ligand_pair.ligand.name
  +
SELECT ••• "interaction_type_residue_fragment"."id", "interaction_type_residue_fragment"."slug", "interaction_type_residue_fragment"."name", "interaction_type_residue_fragment"."type", "interaction_type_residue_fragment"."direction" FROM "interaction_type_residue_fragment" WHERE "interaction_type_residue_fragment"."id" = 11
  28 similar queries.   Duplicated 4 times.
0.10813991120916105%
0.60

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/interaction/views.py in StructureDetails(154)
  key = residue.interaction_type.name
  +
SELECT ••• "structure_rotamer"."id", "structure_rotamer"."residue_id", "structure_rotamer"."structure_id", "structure_rotamer"."pdbdata_id", "structure_rotamer"."missing_atoms" FROM "structure_rotamer" WHERE "structure_rotamer"."id" = 50375
  28 similar queries.
0.0954456027218677%
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/interaction/views.py in StructureDetails(155)
  aa = residue.rotamer.residue.amino_acid
  +
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" = 23606114
  28 similar queries.   Duplicated 2 times.
0.065247879118989%
0.36

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/interaction/views.py in StructureDetails(155)
  aa = residue.rotamer.residue.amino_acid
  +
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" = 1
  28 similar queries.   Duplicated 14 times.
1.9082188498783208%
10.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/interaction/views.py in StructureDetails(164)
  if residue.rotamer.residue.protein_segment:
  +
SELECT ••• "interaction_structure_ligand"."id", "interaction_structure_ligand"."structure_id", "interaction_structure_ligand"."ligand_id", "interaction_structure_ligand"."ligand_role_id", "interaction_structure_ligand"."pdb_reference", "interaction_structure_ligand"."pdb_file_id", "interaction_structure_ligand"."annotated" FROM "interaction_structure_ligand" WHERE "interaction_structure_ligand"."id" = 312
  28 similar queries.   Duplicated 28 times.
0.12676978373317516%
0.70

Connection: default

/usr/lib/python3.6/concurrent/futures/thread.py in _worker(69)
  work_item.run()
/usr/lib/python3.6/concurrent/futures/thread.py in run(56)
  result = self.fn(*self.args, **self.kwargs)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle(279)
  keepalive = self.handle_request(req, conn)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle_request(328)
  respiter = self.wsgi(environ, resp.start_response)
/home/protwis/gpcrdb_test/common/middleware/stats.py in __call__(34)
  response = self.get_response(request)
/home/protwis/gpcrdb_test/interaction/views.py in StructureDetails(172)
  ligand = residue.structure_ligand_pair.ligand.name
  +
SELECT ••• "ligand"."id", "ligand"."properities_id", "ligand"."name", "ligand"."pdbe", "ligand"."canonical", "ligand"."ambigious_alias", "ligand"."endogenous" FROM "ligand" WHERE "ligand"."id" = 167
  28 similar queries.   Duplicated 28 times.
0.09696198769475257%
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/interaction/views.py in StructureDetails(172)
  ligand = residue.structure_ligand_pair.ligand.name
  +
SELECT ••• "interaction_type_residue_fragment"."id", "interaction_type_residue_fragment"."slug", "interaction_type_residue_fragment"."name", "interaction_type_residue_fragment"."type", "interaction_type_residue_fragment"."direction" FROM "interaction_type_residue_fragment" WHERE "interaction_type_residue_fragment"."id" = 3
  28 similar queries.   Duplicated 11 times.
1.9035830443897874%
10.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/interaction/views.py in StructureDetails(154)
  key = residue.interaction_type.name
  +
SELECT ••• "structure_rotamer"."id", "structure_rotamer"."residue_id", "structure_rotamer"."structure_id", "structure_rotamer"."pdbdata_id", "structure_rotamer"."missing_atoms" FROM "structure_rotamer" WHERE "structure_rotamer"."id" = 50027
  28 similar queries.
0.08652059402431675%
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/interaction/views.py in StructureDetails(155)
  aa = residue.rotamer.residue.amino_acid
  +
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" = 23606115
  28 similar queries.
0.06936378118824793%
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/interaction/views.py in StructureDetails(155)
  aa = residue.rotamer.residue.amino_acid
  +
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" = 1
  28 similar queries.   Duplicated 14 times.
0.17230465820466084%
0.95

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/interaction/views.py in StructureDetails(164)
  if residue.rotamer.residue.protein_segment:
  +
SELECT ••• "interaction_structure_ligand"."id", "interaction_structure_ligand"."structure_id", "interaction_structure_ligand"."ligand_id", "interaction_structure_ligand"."ligand_role_id", "interaction_structure_ligand"."pdb_reference", "interaction_structure_ligand"."pdb_file_id", "interaction_structure_ligand"."annotated" FROM "interaction_structure_ligand" WHERE "interaction_structure_ligand"."id" = 312
  28 similar queries.   Duplicated 28 times.
0.10545374354290786%
0.58

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/interaction/views.py in StructureDetails(172)
  ligand = residue.structure_ligand_pair.ligand.name
  +
SELECT ••• "ligand"."id", "ligand"."properities_id", "ligand"."name", "ligand"."pdbe", "ligand"."canonical", "ligand"."ambigious_alias", "ligand"."endogenous" FROM "ligand" WHERE "ligand"."id" = 167
  28 similar queries.   Duplicated 28 times.
0.507858990061613%
2.79

Connection: default

/usr/lib/python3.6/concurrent/futures/thread.py in _worker(69)
  work_item.run()
/usr/lib/python3.6/concurrent/futures/thread.py in run(56)
  result = self.fn(*self.args, **self.kwargs)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle(279)
  keepalive = self.handle_request(req, conn)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle_request(328)
  respiter = self.wsgi(environ, resp.start_response)
/home/protwis/gpcrdb_test/common/middleware/stats.py in __call__(34)
  response = self.get_response(request)
/home/protwis/gpcrdb_test/interaction/views.py in StructureDetails(172)
  ligand = residue.structure_ligand_pair.ligand.name
  +
SELECT ••• "interaction_type_residue_fragment"."id", "interaction_type_residue_fragment"."slug", "interaction_type_residue_fragment"."name", "interaction_type_residue_fragment"."type", "interaction_type_residue_fragment"."direction" FROM "interaction_type_residue_fragment" WHERE "interaction_type_residue_fragment"."id" = 5
  28 similar queries.   Duplicated 5 times.
0.07217992470931983%
0.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/interaction/views.py in StructureDetails(154)
  key = residue.interaction_type.name
  +
SELECT ••• "structure_rotamer"."id", "structure_rotamer"."residue_id", "structure_rotamer"."structure_id", "structure_rotamer"."pdbdata_id", "structure_rotamer"."missing_atoms" FROM "structure_rotamer" WHERE "structure_rotamer"."id" = 50371
  28 similar queries.
0.06754411922078608%
0.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/interaction/views.py in StructureDetails(155)
  aa = residue.rotamer.residue.amino_acid
  +
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" = 23606140
  28 similar queries.   Duplicated 2 times.
0.06191183217864228%
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/interaction/views.py in StructureDetails(155)
  aa = residue.rotamer.residue.amino_acid
  +
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" = 1
  28 similar queries.   Duplicated 14 times.
0.177200415402832%
0.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/interaction/views.py in StructureDetails(164)
  if residue.rotamer.residue.protein_segment:
  +
SELECT ••• "interaction_structure_ligand"."id", "interaction_structure_ligand"."structure_id", "interaction_structure_ligand"."ligand_id", "interaction_structure_ligand"."ligand_role_id", "interaction_structure_ligand"."pdb_reference", "interaction_structure_ligand"."pdb_file_id", "interaction_structure_ligand"."annotated" FROM "interaction_structure_ligand" WHERE "interaction_structure_ligand"."id" = 312
  28 similar queries.   Duplicated 28 times.
0.10190107017786329%
0.56

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/interaction/views.py in StructureDetails(172)
  ligand = residue.structure_ligand_pair.ligand.name
  +
SELECT ••• "ligand"."id", "ligand"."properities_id", "ligand"."name", "ligand"."pdbe", "ligand"."canonical", "ligand"."ambigious_alias", "ligand"."endogenous" FRO