A1 receptor (aa1r_human)

FAMILY

Class A (Rhodopsin) Nucleotide receptors Adenosine receptors A1 receptor

GENE

ADORA1

ORGANISM

Human (Homo sapiens)

ALT. NAMES

Adenosine receptor A1

SOURCE

SWISSPROT

SEQUENCE

N-term TM1  
M
P
P
S
I
S
A
F
Q
A
10
                   
A
Y
I
G
I
E
V
L
I
A
20
                   
L
V
S
V
P
G
N
V
L
V
30
                   
I
W
A
V
K
V
N
Q
A
L
40
ICL1 TM2      
R
D
A
T
F
C
F
I
V
S
50
                   
L
A
V
A
D
V
A
V
G
A
60
                   
L
V
I
P
L
A
I
L
I
N
70
    ECL1 TM3  
I
G
P
Q
T
Y
F
H
T
C
80
                   
L
M
V
A
C
P
V
L
I
L
90
                   
T
Q
S
S
I
L
A
L
L
A
100
                   
I
A
V
D
R
Y
L
R
V
K
110
  ICL2          
I
P
L
R
Y
K
M
V
V
T
120
TM4              
P
R
R
A
A
V
A
I
A
G
130
                   
C
W
I
L
S
F
V
V
G
L
140
          ECL2  
T
P
M
F
G
W
N
N
L
S
150
                   
A
V
E
R
A
W
A
A
N
G
160
                   
S
M
G
E
P
V
I
K
C
E
170
          TM5    
F
E
K
V
I
S
M
E
Y
M
180
                   
V
Y
F
N
F
F
V
W
V
L
190
                   
P
P
L
L
L
M
V
L
I
Y
200
                   
L
E
V
F
Y
L
I
R
K
Q
210
          ICL3  
L
N
K
K
V
S
A
S
S
G
220
TM6              
D
P
Q
K
Y
Y
G
K
E
L
230
                   
K
I
A
K
S
L
A
L
I
L
240
                   
F
L
F
A
L
S
W
L
P
L
250
                   
H
I
L
N
C
I
T
L
F
C
260
ECL3   TM7    
P
S
C
H
K
P
S
I
L
T
270
                   
Y
I
A
I
F
L
T
H
G
N
280
                   
S
A
M
N
P
I
V
Y
A
F
290
  H8              
R
I
Q
K
F
R
V
T
F
L
300
                   
K
I
W
N
D
H
F
R
C
Q
310
        C-term
P
A
P
P
I
D
E
D
L
P
320
           
E
E
R
P
D
D

LINKS

DIAGRAMS

V N G P V S V L A I L V E I G I Y A A Q 1 V S L A V A D V A V G L A V I P L A I L I 2 A L L A L I S S Q T L I L V P C A V M L 3 A A V A I A G C W I L S F V V G L T P M 4 Y I L V M L L L P P L V W V F F N F Y V M Y 5 A L I L F L F A L S W L P L H I L N C I 6 I P N M A S N G H T L F I A I Y T L I 7
Pick color:
 
 
 
 
 
 
 
 
 
 
 
 




Invitro Mutant Data: Increased binding/potency: >5-fold, >10-fold; Reduced binding/potency: >5-fold, >10-fold; No/low effect (<5-fold); and N/A

ICL1 Q A L R ICL1ECL1 P Q T ECL1ICL2 P L R Y K M V V ICL2ECL2 W N N L S A V E R A W A A N G S M G E P V I K C E F E K V I ECL2ICL3 S A S S G ICL3ECL3 P S C H K ECL3N-term M P P S I N-termC-term I D E D L P E E R P D D C-term S A F Q A A Y I G I E V L I A L V S V P G N V L V I W A V K V N D A T F C F I V S L A V A D V A V G A L V I P L A I L I N I G Y F H T C L M V A C P V L I L T Q S S I L A L L A I A V D R Y L R V K I T P R R A A V A I A G C W I L S F V V G L T P M F G S M E Y M V Y F N F F V W V L P P L L L M V L I Y L E V F Y L I R K Q L N K K V D P Q K Y Y G K E L K I A K S L A L I L F L F A L S W L P L H I L N C I T L F C P S I L T Y I A I F L T H G N S A M N P I V Y A F R I Q K F L K H F R P P F R V T I W N D C Q P A
Pick color:
 
 
 
 
 
 
 
 
 
 
 
 




Invitro Mutant Data: Increased binding/potency: >5-fold, >10-fold; Reduced binding/potency: >5-fold, >10-fold; No/low effect (<5-fold); and N/A

MUTATIONS

ENDOGENOUS LIGANDS

adenosine

HOMOLOGY MODELS

STRUCTURES

View in Structures

«

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 1026.719 msec
System CPU time 67.652 msec
Total CPU time 1094.371 msec
Elapsed time 1384.654 msec
Context switches 195 voluntary, 8 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 35.172.111.47
X-Forwarded-Proto https
X-Real-Ip 35.172.111.47

Response headers

Key Value
Cache-Control max-age=604800
Content-Length 737747
Content-Type text/html; charset=utf-8
Expires Thu, 15 Jun 2023 20:48:15 GMT
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 /protein/aa1r_human/
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
protein.views.detail () {'slug': 'aa1r_human'} detail

No cookies

No session data

No GET data

No POST data

SQL queries from 1 connection

  •   default 297.53 ms (56 queries including 21 similar and 13 duplicates )
  Query Timeline Time (ms) Action
  +
SELECT ••• (1) AS "a" FROM "protein" WHERE "protein"."entry_name" = 'aa1r_human' LIMIT 1
0.6127039508426482%
1.82

Connection: default

/usr/lib/python3.6/concurrent/futures/thread.py in _worker(69)
  work_item.run()
/usr/lib/python3.6/concurrent/futures/thread.py in run(56)
  result = self.fn(*self.args, **self.kwargs)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle(279)
  keepalive = self.handle_request(req, conn)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle_request(328)
  respiter = self.wsgi(environ, resp.start_response)
/home/protwis/gpcrdb_test/common/middleware/stats.py in __call__(34)
  response = self.get_response(request)
/home/protwis/gpcrdb_test/protein/views.py in detail(37)
  if Protein.objects.filter(entry_name=slug).exists():
  +
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_sequence_type" ON ("protein"."sequence_type_id" = "protein_sequence_type"."id") WHERE ("protein"."entry_name" = 'aa1r_human' AND "protein_sequence_type"."slug" = 'wt')
0.3971437065624071%
1.18

Connection: default

/usr/lib/python3.6/concurrent/futures/thread.py in _worker(69)
  work_item.run()
/usr/lib/python3.6/concurrent/futures/thread.py in run(56)
  result = self.fn(*self.args, **self.kwargs)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle(279)
  keepalive = self.handle_request(req, conn)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle_request(328)
  respiter = self.wsgi(environ, resp.start_response)
/home/protwis/gpcrdb_test/common/middleware/stats.py in __call__(34)
  response = self.get_response(request)
/home/protwis/gpcrdb_test/protein/views.py in detail(38)
  p = Protein.objects.prefetch_related('web_links__web_resource').get(entry_name=slug, sequence_type__slug='wt')
  +
SELECT ••• ("protein_web_links"."protein_id") AS "_prefetch_related_val_protein_id", "web_link"."id", "web_link"."web_resource_id", "web_link"."index" FROM "web_link" INNER JOIN "protein_web_links" ON ("web_link"."id" = "protein_web_links"."weblink_id") WHERE "protein_web_links"."protein_id" IN (180)
0.6550146605006286%
1.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/protein/views.py in detail(38)
  p = Protein.objects.prefetch_related('web_links__web_resource').get(entry_name=slug, sequence_type__slug='wt')
  +
SELECT ••• "web_resource"."id", "web_resource"."slug", "web_resource"."name", "web_resource"."url" FROM "web_resource" WHERE "web_resource"."id" IN (8, 9, 5)
0.21299595884642417%
0.63

Connection: default

/usr/lib/python3.6/concurrent/futures/thread.py in _worker(69)
  work_item.run()
/usr/lib/python3.6/concurrent/futures/thread.py in run(56)
  result = self.fn(*self.args, **self.kwargs)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle(279)
  keepalive = self.handle_request(req, conn)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle_request(328)
  respiter = self.wsgi(environ, resp.start_response)
/home/protwis/gpcrdb_test/common/middleware/stats.py in __call__(34)
  response = self.get_response(request)
/home/protwis/gpcrdb_test/protein/views.py in detail(38)
  p = Protein.objects.prefetch_related('web_links__web_resource').get(entry_name=slug, sequence_type__slug='wt')
  +
SELECT ••• "protein_family"."id", "protein_family"."parent_id", "protein_family"."slug", "protein_family"."name" FROM "protein_family" WHERE "protein_family"."id" = 242
  5 similar queries.
0.1407952971005144%
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/protein/views.py in detail(62)
  if p.family.slug.startswith('100') or p.family.slug.startswith('200'):
  +
SELECT ••• "protein_family"."id", "protein_family"."parent_id", "protein_family"."slug", "protein_family"."name" FROM "protein_family" WHERE "protein_family"."id" = 241
  5 similar queries.
0.08325914267924556%
0.25

Connection: default

/usr/lib/python3.6/concurrent/futures/thread.py in _worker(69)
  work_item.run()
/usr/lib/python3.6/concurrent/futures/thread.py in run(56)
  result = self.fn(*self.args, **self.kwargs)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle(279)
  keepalive = self.handle_request(req, conn)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle_request(328)
  respiter = self.wsgi(environ, resp.start_response)
/home/protwis/gpcrdb_test/common/middleware/stats.py in __call__(34)
  response = self.get_response(request)
/home/protwis/gpcrdb_test/protein/views.py in detail(69)
  while pf.parent.parent:
  +
SELECT ••• "protein_family"."id", "protein_family"."parent_id", "protein_family"."slug", "protein_family"."name" FROM "protein_family" WHERE "protein_family"."id" = 240
  5 similar queries.
0.11547297844157155%
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/protein/views.py in detail(69)
  while pf.parent.parent:
  +
SELECT ••• "protein_family"."id", "protein_family"."parent_id", "protein_family"."slug", "protein_family"."name" FROM "protein_family" WHERE "protein_family"."id" = 2
  5 similar queries.
0.07420400974107928%
0.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/protein/views.py in detail(69)
  while pf.parent.parent:
  +
SELECT ••• "protein_family"."id", "protein_family"."parent_id", "protein_family"."slug", "protein_family"."name" FROM "protein_family" WHERE "protein_family"."id" = 1
  5 similar queries.
0.06010043985508581%
0.18

Connection: default

/usr/lib/python3.6/concurrent/futures/thread.py in _worker(69)
  work_item.run()
/usr/lib/python3.6/concurrent/futures/thread.py in run(56)
  result = self.fn(*self.args, **self.kwargs)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle(279)
  keepalive = self.handle_request(req, conn)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle_request(328)
  respiter = self.wsgi(environ, resp.start_response)
/home/protwis/gpcrdb_test/common/middleware/stats.py in __call__(34)
  response = self.get_response(request)
/home/protwis/gpcrdb_test/protein/views.py in detail(69)
  while pf.parent.parent:
  +
SELECT ••• "protein_conformation"."id", "protein_conformation"."protein_id", "protein_conformation"."state_id" FROM "protein_conformation" WHERE "protein_conformation"."protein_id" = 180
0.1920008718570475%
0.57

Connection: default

/usr/lib/python3.6/concurrent/futures/thread.py in _worker(69)
  work_item.run()
/usr/lib/python3.6/concurrent/futures/thread.py in run(56)
  result = self.fn(*self.args, **self.kwargs)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle(279)
  keepalive = self.handle_request(req, conn)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle_request(328)
  respiter = self.wsgi(environ, resp.start_response)
/home/protwis/gpcrdb_test/common/middleware/stats.py in __call__(34)
  response = self.get_response(request)
/home/protwis/gpcrdb_test/protein/views.py in detail(75)
  pc = ProteinConformation.objects.get(protein=p)
  +
SELECT ••• "gene"."name" FROM "gene" INNER JOIN "gene_proteins" ON ("gene"."id" = "gene_proteins"."gene_id") WHERE "gene_proteins"."protein_id" = 180 ORDER BY "gene"."position" ASC
0.31636871539717176%
0.94

Connection: default

/usr/lib/python3.6/concurrent/futures/thread.py in _worker(69)
  work_item.run()
/usr/lib/python3.6/concurrent/futures/thread.py in run(56)
  result = self.fn(*self.args, **self.kwargs)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle(279)
  keepalive = self.handle_request(req, conn)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle_request(328)
  respiter = self.wsgi(environ, resp.start_response)
/home/protwis/gpcrdb_test/common/middleware/stats.py in __call__(34)
  response = self.get_response(request)
/home/protwis/gpcrdb_test/protein/views.py in detail(85)
  if len(genes)>0:
  +
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"."protein_conformation_id" = 180 ORDER BY "residue"."sequence_number" ASC
0.329831213924711%
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/protein/views.py in detail(121)
  for i, r in enumerate(residues):
  +
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
  3 similar queries.   Duplicated 3 times.
0.22445510937879384%
0.67

Connection: default

/usr/lib/python3.6/concurrent/futures/thread.py in _worker(69)
  work_item.run()
/usr/lib/python3.6/concurrent/futures/thread.py in run(56)
  result = self.fn(*self.args, **self.kwargs)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle(279)
  keepalive = self.handle_request(req, conn)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle_request(328)
  respiter = self.wsgi(environ, resp.start_response)
/home/protwis/gpcrdb_test/common/middleware/stats.py in __call__(34)
  response = self.get_response(request)
/home/protwis/gpcrdb_test/protein/views.py in detail(121)
  for i, r in enumerate(residues):
  +
SELECT ••• "residue_generic_number"."id", "residue_generic_number"."scheme_id", "residue_generic_number"."protein_segment_id", "residue_generic_number"."label" FROM "residue_generic_number" WHERE "residue_generic_number"."id" IN (88576, 30722, 37378, 43010, 2, 6, 7, 4, 79876, 85510, 83467, 9, 10, 11, 15, 16, 17, 18, 19, 20, 12, 13, 23, 24, 66072, 27, 16414, 2079, 10270, 18462, 32802, 39458, 40994, 45089, 52780, 94253, 53806, 55347, 80949, 77366, 26168, 57400, 59448, 61496, 68152, 3646, 5694, 22078, 26174, 28226, 34882, 47169, 51266, 70718, 81989, 84547, 596, 89174, 63576, 24158, 7774, 13918, 69216, 30306, 98, 36962, 41570, 72295, 73322, 94325, 65656, 79480, 86651, 78461, 9854, 18046, 11390, 15998, 32386, 39042, 44673, 75396, 76414, 92800, 87176, 74380, 54927, 92307, 56984, 59032, 61080, 67736, 88056, 93849, 5278, 3230, 1695, 46753, 27810, 34466, 42146, 97436, 85164, 80559, 93361, 52404, 183, 63160, 89785, 187, 19646, 23742, 7358, 11966, 13502, 29890, 36546, 48833, 50881, 91838, 83146, 84171, 65240, 25307, 71900, 9438, 15582, 73952, 44257, 31970, 38626, 42722, 81632, 54507, 70898, 86259, 8190, 24574, 56568, 60664, 67320, 53500, 4862, 46337, 27394, 34050, 40706, 87809, 88322, 97537, 70419, 77076, 78102, 74007, 25880, 62744, 6942, 13086, 21278, 1313, 29474, 23326, 36130, 48417, 50466, 50465, 75046, 76072, 91437, 96047, 64824, 82746, 52027, 9022, 15166, 88894, 43841, 31554, 38210, 41282, 54087, 73034, NULL, 80210, 71509, 56152, 66904, 89432, 86875, 11102, 17246, 45921, 26978, 33634, 40290, 68964, 83810, 94561, 97637, 92526, 58232, 62328, 97144, 12670, 20862, 6526, 22910, 29058, 35714, 41858, 48001, 50049, 94078, 93066, 81293, 98194, 64408, 85912, 410, 11678, 2463, 8606, 929, 31138, 14750, 37794, 43426, 73635, 63992, 78761, 76714, 77739, 91563, 97198, 84911, 93615, 66488, 51642, 10686, 16830, 75712, 45505, 33218, 39874, 42434, 69573, 82370, 53191, 87493, 92098, 73674, 55758, 74704, 26584, 57816, 59864, 61912, 68568, 72668, 22494, 20446, 4062, 6110, 12254, 28642, 35298, 47585, 49633, 71138, 97259, 91122, 25592, 14334)
  6 similar queries.   Duplicated 3 times.
0.544349717247464%
1.62

Connection: default

/usr/lib/python3.6/concurrent/futures/thread.py in _worker(69)
  work_item.run()
/usr/lib/python3.6/concurrent/futures/thread.py in run(56)
  result = self.fn(*self.args, **self.kwargs)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle(279)
  keepalive = self.handle_request(req, conn)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle_request(328)
  respiter = self.wsgi(environ, resp.start_response)
/home/protwis/gpcrdb_test/common/middleware/stats.py in __call__(34)
  response = self.get_response(request)
/home/protwis/gpcrdb_test/protein/views.py in detail(121)
  for i, r in enumerate(residues):
  +
SELECT ••• "residue_generic_number"."id", "residue_generic_number"."scheme_id", "residue_generic_number"."protein_segment_id", "residue_generic_number"."label" FROM "residue_generic_number" WHERE "residue_generic_number"."id" IN (47617, 28674, 35330, 49665, 71172, 88068, 90119, 90635, 64024, 25625, 88601, 24606, 8222, 32, 2080, 14366, 30754, 37410, 43043, 79903, 85541, 93630, 83498, 52781, 84575, 91181, 94257, 66104, 68600, 572, 10302, 16446, 18494, 45121, 32834, 39490, 41026, 51265, 71, 80979, 77399, 26200, 57432, 59480, 61528, 68184, 22110, 20062, 3678, 5726, 28258, 34914, 47201, 49249, 53859, 70752, 82022, 89186, 118, 4094, 20478, 26230, 63608, 69245, 13950, 7806, 24190, 94335, 30338, 36994, 41602, 72323, 138, 73356, 86668, 65688, 79512, 87193, 78491, 92829, 16030, 9886, 1696, 18078, 11422, 32418, 39074, 44705, 75426, 76446, 74409, 52403, 92339, 93876, 22526, 97459, 57016, 59064, 61112, 67768, 5310, 3262, 21694, 46785, 27842, 34498, 42178, 50882, 85196, 93390, 80591, 63192, 89816, 90330, 19678, 23774, 224, 7390, 29922, 11998, 13534, 36578, 48865, 84193, 91871, 83178, 246, 98040, 65272, 90874, 9470, 17662, 15614, 44289, 32002, 38658, 42755, 70910, 71935, 81664, 97548, 86285, 98064, 87826, 88343, 25368, 56600, 58648, 60696, 67352, 74011, 4894, 2847, 1312, 46369, 27426, 34082, 40738, 77091, 79141, 59896, 98089, 53553, 78131, 25912, 62776, 52026, 74041, 19262, 23358, 6974, 13118, 21310, 29506, 36162, 48449, 50498, 98113, 70469, 75076, 91462, NULL, 88916, 64856, 98137, 82778, 96089, 9054, 15198, 43873, 31586, 38242, 41314, 73062, 61944, 80234, 89457, 12286, 98166, 60280, 66936, 71545, 86907, 97654, 17278, 11134, 4478, 45953, 27010, 33666, 40322, 68995, 83841, 97152, 92552, 76096, 94607, 58264, 62360, 98202, 81307, 94104, 6558, 12702, 928, 2464, 20894, 29090, 22942, 35746, 41890, 48033, 50081, 93099, 53164, 97203, 64440, 85944, 91578, 51645, 18878, 8638, 11710, 14782, 31170, 37826, 43459, 84933, 77766, 78791, 76744, 73679, 66520, 75738, 92123, 73692, 10718, 16862, 87519, 45537, 26594, 33250, 39906, 42467, 69603, 82402, 74732, 91126, 53239, 57848, 97270, 72701, 6142)
  6 similar queries.   Duplicated 3 times.
0.39626223344453254%
1.18

Connection: default

/usr/lib/python3.6/concurrent/futures/thread.py in _worker(69)
  work_item.run()
/usr/lib/python3.6/concurrent/futures/thread.py in run(56)
  result = self.fn(*self.args, **self.kwargs)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle(279)
  keepalive = self.handle_request(req, conn)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle_request(328)
  respiter = self.wsgi(environ, resp.start_response)
/home/protwis/gpcrdb_test/common/middleware/stats.py in __call__(34)
  response = self.get_response(request)
/home/protwis/gpcrdb_test/protein/views.py in detail(121)
  for i, r in enumerate(residues):
  +
SELECT ••• "species"."id", "species"."latin_name", "species"."common_name" FROM "species" WHERE "species"."id" = 1
0.22918301064739394%
0.68

Connection: default

/usr/lib/python3.6/concurrent/futures/thread.py in _worker(69)
  work_item.run()
/usr/lib/python3.6/concurrent/futures/thread.py in run(56)
  result = self.fn(*self.args, **self.kwargs)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle(279)
  keepalive = self.handle_request(req, conn)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle_request(328)
  respiter = self.wsgi(environ, resp.start_response)
/home/protwis/gpcrdb_test/common/middleware/stats.py in __call__(34)
  response = self.get_response(request)
/home/protwis/gpcrdb_test/protein/views.py in detail(156)
  return render(request, 'protein/protein_detail.html', context)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/django/shortcuts.py in render(36)
  content = loader.render_to_string(template_name, context, request, using=using)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/django/template/loader.py in render_to_string(62)
  return template.render(context, request)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/django/template/backends/django.py in render(61)
  return self.template.render(context)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/django/template/base.py in render(171)
  return self._render(context)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/django/test/utils.py in instrumented_test_render(96)
  return self.nodelist.render(context)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/django/template/base.py in render(937)
  bit = node.render_annotated(context)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/django/template/base.py in render_annotated(904)
  return self.render(context)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/django/template/loader_tags.py in render(150)
  return compiled_parent._render(context)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/django/test/utils.py in instrumented_test_render(96)
  return self.nodelist.render(context)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/django/template/base.py in render(937)
  bit = node.render_annotated(context)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/django/template/base.py in render_annotated(904)
  return self.render(context)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/django/template/loader_tags.py in render(62)
  result = block.nodelist.render(context)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/django/template/base.py in render(937)
  bit = node.render_annotated(context)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/django/template/base.py in render_annotated(904)
  return self.render(context)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/django/template/defaulttags.py in render(309)
  return nodelist.render(context)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/django/template/base.py in render(937)
  bit = node.render_annotated(context)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/django/template/base.py in render_annotated(904)
  return self.render(context)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/django/template/loader_tags.py in render(188)
  return template.render(context)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/django/template/base.py in render(173)
  return self._render(context)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/django/test/utils.py in instrumented_test_render(96)
  return self.nodelist.render(context)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/django/template/base.py in render(937)
  bit = node.render_annotated(context)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/django/template/base.py in render_annotated(904)
  return self.render(context)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/django/template/base.py in render(987)
  output = self.filter_expression.resolve(context)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/django/template/base.py in resolve(671)
  obj = self.var.resolve(context)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/django/template/base.py in resolve(796)
  value = self._resolve_lookup(context)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/django/template/base.py in _resolve_lookup(837)
  current = getattr(current, bit)
1 {% extends "home/base.html" %}
2 {% load static %}
3 {% load structure_extras %}
4

/home/protwis/gpcrdb_test/protein/templates/protein/protein_detail.html

  +
SELECT ••• "protein_alias"."name" FROM "protein_alias" WHERE "protein_alias"."protein_id" = 180 ORDER BY "protein_alias"."position" ASC
0.16499574088216226%
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/protein/views.py in detail(156)
  return render(request, 'protein/protein_detail.html', context)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/django/shortcuts.py in render(36)
  content = loader.render_to_string(template_name, context, request, using=using)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/django/template/loader.py in render_to_string(62)
  return template.render(context, request)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/django/template/backends/django.py in render(61)
  return self.template.render(context)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/django/template/base.py in render(171)
  return self._render(context)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/django/test/utils.py in instrumented_test_render(96)
  return self.nodelist.render(context)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/django/template/base.py in render(937)
  bit = node.render_annotated(context)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/django/template/base.py in render_annotated(904)
  return self.render(context)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/django/template/loader_tags.py in render(150)
  return compiled_parent._render(context)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/django/test/utils.py in instrumented_test_render(96)
  return self.nodelist.render(context)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/django/template/base.py in render(937)
  bit = node.render_annotated(context)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/django/template/base.py in render_annotated(904)
  return self.render(context)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/django/template/loader_tags.py in render(62)
  result = block.nodelist.render(context)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/django/template/base.py in render(937)
  bit = node.render_annotated(context)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/django/template/base.py in render_annotated(904)
  return self.render(context)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/django/template/defaulttags.py in render(309)
  return nodelist.render(context)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/django/template/base.py in render(937)
  bit = node.render_annotated(context)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/django/template/base.py in render_annotated(904)
  return self.render(context)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/django/template/loader_tags.py in render(188)
  return template.render(context)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/django/template/base.py in render(173)
  return self._render(context)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/django/test/utils.py in instrumented_test_render(96)
  return self.nodelist.render(context)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/django/template/base.py in render(937)
  bit = node.render_annotated(context)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/django/template/base.py in render_annotated(904)
  return self.render(context)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/django/template/base.py in render(987)
  output = self.filter_expression.resolve(context)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/django/template/base.py in resolve(696)
  new_obj = func(obj, autoescape=context.autoescape, *arg_vals)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/django/template/defaultfilters.py in join(529)
  value = [conditional_escape(v) for v in value]
42 <h4>DIAGRAMS</h4>
43 </div>
44 <div class="col-md-10">
45 {{ p.get_helical_box }}
46 <p><div class="btn-group">
47 <button type="button" class="btn btn-sm btn-primary dropdown-toggle" data-toggle="dropdown"
48 aria-haspopup="true" aria-expanded="false">
49 <span class="glyphicon glyphicon-download"></span> Download <span class="caret"></span>

/home/protwis/gpcrdb_test/protein/templates/protein/protein_detail.html

  +
SELECT ••• "protein_source"."id", "protein_source"."name" FROM "protein_source" WHERE "protein_source"."id" = 1
0.1649156069623555%
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/protein/views.py in detail(156)
  return render(request, 'protein/protein_detail.html', context)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/django/shortcuts.py in render(36)
  content = loader.render_to_string(template_name, context, request, using=using)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/django/template/loader.py in render_to_string(62)
  return template.render(context, request)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/django/template/backends/django.py in render(61)
  return self.template.render(context)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/django/template/base.py in render(171)
  return self._render(context)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/django/test/utils.py in instrumented_test_render(96)
  return self.nodelist.render(context)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/django/template/base.py in render(937)
  bit = node.render_annotated(context)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/django/template/base.py in render_annotated(904)
  return self.render(context)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/django/template/loader_tags.py in render(150)
  return compiled_parent._render(context)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/django/test/utils.py in instrumented_test_render(96)
  return self.nodelist.render(context)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/django/template/base.py in render(937)
  bit = node.render_annotated(context)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/django/template/base.py in render_annotated(904)
  return self.render(context)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/django/template/loader_tags.py in render(62)
  result = block.nodelist.render(context)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/django/template/base.py in render(937)
  bit = node.render_annotated(context)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/django/template/base.py in render_annotated(904)
  return self.render(context)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/django/template/defaulttags.py in render(309)
  return nodelist.render(context)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/django/template/base.py in render(937)
  bit = node.render_annotated(context)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/django/template/base.py in render_annotated(904)
  return self.render(context)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/django/template/loader_tags.py in render(188)
  return template.render(context)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/django/template/base.py in render(173)
  return self._render(context)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/django/test/utils.py in instrumented_test_render(96)
  return self.nodelist.render(context)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/django/template/base.py in render(937)
  bit = node.render_annotated(context)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/django/template/base.py in render_annotated(904)
  return self.render(context)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/django/template/base.py in render(987)
  output = self.filter_expression.resolve(context)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/django/template/base.py in resolve(671)
  obj = self.var.resolve(context)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/django/template/base.py in resolve(796)
  value = self._resolve_lookup(context)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/django/template/base.py in _resolve_lookup(837)
  current = getattr(current, bit)
1 {% extends "home/base.html" %}
2 {% load static %}
3 {% load structure_extras %}
4

/home/protwis/gpcrdb_test/protein/templates/protein/protein_detail.html

  +
SELECT ••• DISTINCT ON ("web_resource"."slug") "web_link"."id", "web_link"."web_resource_id", "web_link"."index" FROM "web_link" INNER JOIN "protein_web_links" ON ("web_link"."id" = "protein_web_links"."weblink_id") INNER JOIN "web_resource" ON ("web_link"."web_resource_id" = "web_resource"."id") WHERE "protein_web_links"."protein_id" = 180
0.39906692063776983%
1.19

Connection: default

/usr/lib/python3.6/concurrent/futures/thread.py in _worker(69)
  work_item.run()
/usr/lib/python3.6/concurrent/futures/thread.py in run(56)
  result = self.fn(*self.args, **self.kwargs)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle(279)
  keepalive = self.handle_request(req, conn)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle_request(328)
  respiter = self.wsgi(environ, resp.start_response)
/home/protwis/gpcrdb_test/common/middleware/stats.py in __call__(34)
  response = self.get_response(request)
/home/protwis/gpcrdb_test/protein/views.py in detail(156)
  return render(request, 'protein/protein_detail.html', context)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/django/shortcuts.py in render(36)
  content = loader.render_to_string(template_name, context, request, using=using)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/django/template/loader.py in render_to_string(62)
  return template.render(context, request)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/django/template/backends/django.py in render(61)
  return self.template.render(context)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/django/template/base.py in render(171)
  return self._render(context)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/django/test/utils.py in instrumented_test_render(96)
  return self.nodelist.render(context)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/django/template/base.py in render(937)
  bit = node.render_annotated(context)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/django/template/base.py in render_annotated(904)
  return self.render(context)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/django/template/loader_tags.py in render(150)
  return compiled_parent._render(context)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/django/test/utils.py in instrumented_test_render(96)
  return self.nodelist.render(context)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/django/template/base.py in render(937)
  bit = node.render_annotated(context)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/django/template/base.py in render_annotated(904)
  return self.render(context)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/django/template/loader_tags.py in render(62)
  result = block.nodelist.render(context)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/django/template/base.py in render(937)
  bit = node.render_annotated(context)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/django/template/base.py in render_annotated(904)
  return self.render(context)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/django/template/defaulttags.py in render(309)
  return nodelist.render(context)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/django/template/base.py in render(937)
  bit = node.render_annotated(context)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/django/template/base.py in render_annotated(904)
  return self.render(context)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/django/template/defaulttags.py in render(166)
  len_values = len(values)
29 <h4>LINKS</h4>
30 </div>
31 <div class="col-md-10">
32 {% for link in protein_links %}
33 <p><a href="{{ link }}">{{ link.web_resource.name }}</a></p>
34 {% empty %}
35 No links available
36 {% endfor %}

/home/protwis/gpcrdb_test/protein/templates/protein/protein_detail.html

  +
SELECT ••• "web_resource"."id", "web_resource"."slug", "web_resource"."name", "web_resource"."url" FROM "web_resource" WHERE "web_resource"."id" = 9
  3 similar queries.
0.13582699407249396%
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/protein/views.py in detail(156)
  return render(request, 'protein/protein_detail.html', context)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/django/shortcuts.py in render(36)
  content = loader.render_to_string(template_name, context, request, using=using)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/django/template/loader.py in render_to_string(62)
  return template.render(context, request)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/django/template/backends/django.py in render(61)
  return self.template.render(context)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/django/template/base.py in render(171)
  return self._render(context)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/django/test/utils.py in instrumented_test_render(96)
  return self.nodelist.render(context)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/django/template/base.py in render(937)
  bit = node.render_annotated(context)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/django/template/base.py in render_annotated(904)
  return self.render(context)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/django/template/loader_tags.py in render(150)
  return compiled_parent._render(context)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/django/test/utils.py in instrumented_test_render(96)
  return self.nodelist.render(context)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/django/template/base.py in render(937)
  bit = node.render_annotated(context)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/django/template/base.py in render_annotated(904)
  return self.render(context)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/django/template/loader_tags.py in render(62)
  result = block.nodelist.render(context)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/django/template/base.py in render(937)
  bit = node.render_annotated(context)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/django/template/base.py in render_annotated(904)
  return self.render(context)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/django/template/defaulttags.py in render(309)
  return nodelist.render(context)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/django/template/base.py in render(937)
  bit = node.render_annotated(context)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/django/template/base.py in render_annotated(904)
  return self.render(context)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/django/template/defaulttags.py in render(209)
  nodelist.append(node.render_annotated(context))
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/django/template/base.py in render_annotated(904)
  return self.render(context)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/django/template/base.py in render(993)
  return render_value_in_context(output, context)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/django/template/base.py in render_value_in_context(972)
  value = str(value)
/home/protwis/gpcrdb_test/common/models.py in __str__(49)
  return Template(str(self.web_resource)).substitute(index=self.index)
30 </div>
31 <div class="col-md-10">
32 {% for link in protein_links %}
33 <p><a href="{{ link }}">{{ link.web_resource.name }}</a></p>
34 {% empty %}
35 No links available
36 {% endfor %}
37 </div>

/home/protwis/gpcrdb_test/protein/templates/protein/protein_detail.html

  +
SELECT ••• "web_resource"."id", "web_resource"."slug", "web_resource"."name", "web_resource"."url" FROM "web_resource" WHERE "web_resource"."id" = 5
  3 similar queries.
0.1131490947671749%
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/protein/views.py in detail(156)
  return render(request, 'protein/protein_detail.html', context)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/django/shortcuts.py in render(36)
  content = loader.render_to_string(template_name, context, request, using=using)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/django/template/loader.py in render_to_string(62)
  return template.render(context, request)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/django/template/backends/django.py in render(61)
  return self.template.render(context)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/django/template/base.py in render(171)
  return self._render(context)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/django/test/utils.py in instrumented_test_render(96)
  return self.nodelist.render(context)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/django/template/base.py in render(937)
  bit = node.render_annotated(context)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/django/template/base.py in render_annotated(904)
  return self.render(context)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/django/template/loader_tags.py in render(150)
  return compiled_parent._render(context)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/django/test/utils.py in instrumented_test_render(96)
  return self.nodelist.render(context)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/django/template/base.py in render(937)
  bit = node.render_annotated(context)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/django/template/base.py in render_annotated(904)
  return self.render(context)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/django/template/loader_tags.py in render(62)
  result = block.nodelist.render(context)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/django/template/base.py in render(937)
  bit = node.render_annotated(context)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/django/template/base.py in render_annotated(904)
  return self.render(context)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/django/template/defaulttags.py in render(309)
  return nodelist.render(context)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/django/template/base.py in render(937)
  bit = node.render_annotated(context)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/django/template/base.py in render_annotated(904)
  return self.render(context)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/django/template/defaulttags.py in render(209)
  nodelist.append(node.render_annotated(context))
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/django/template/base.py in render_annotated(904)
  return self.render(context)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/django/template/base.py in render(993)
  return render_value_in_context(output, context)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/django/template/base.py in render_value_in_context(972)
  value = str(value)
/home/protwis/gpcrdb_test/common/models.py in __str__(49)
  return Template(str(self.web_resource)).substitute(index=self.index)
30 </div>
31 <div class="col-md-10">
32 {% for link in protein_links %}
33 <p><a href="{{ link }}">{{ link.web_resource.name }}</a></p>
34 {% empty %}
35 No links available
36 {% endfor %}
37 </div>

/home/protwis/gpcrdb_test/protein/templates/protein/protein_detail.html

  +
SELECT ••• "web_resource"."id", "web_resource"."slug", "web_resource"."name", "web_resource"."url" FROM "web_resource" WHERE "web_resource"."id" = 8
  3 similar queries.
0.11435110356427661%
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/protein/views.py in detail(156)
  return render(request, 'protein/protein_detail.html', context)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/django/shortcuts.py in render(36)
  content = loader.render_to_string(template_name, context, request, using=using)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/django/template/loader.py in render_to_string(62)
  return template.render(context, request)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/django/template/backends/django.py in render(61)
  return self.template.render(context)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/django/template/base.py in render(171)
  return self._render(context)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/django/test/utils.py in instrumented_test_render(96)
  return self.nodelist.render(context)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/django/template/base.py in render(937)
  bit = node.render_annotated(context)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/django/template/base.py in render_annotated(904)
  return self.render(context)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/django/template/loader_tags.py in render(150)
  return compiled_parent._render(context)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/django/test/utils.py in instrumented_test_render(96)
  return self.nodelist.render(context)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/django/template/base.py in render(937)
  bit = node.render_annotated(context)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/django/template/base.py in render_annotated(904)
  return self.render(context)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/django/template/loader_tags.py in render(62)
  result = block.nodelist.render(context)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/django/template/base.py in render(937)
  bit = node.render_annotated(context)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/django/template/base.py in render_annotated(904)
  return self.render(context)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/django/template/defaulttags.py in render(309)
  return nodelist.render(context)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/django/template/base.py in render(937)
  bit = node.render_annotated(context)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/django/template/base.py in render_annotated(904)
  return self.render(context)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/django/template/defaulttags.py in render(209)
  nodelist.append(node.render_annotated(context))
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/django/template/base.py in render_annotated(904)
  return self.render(context)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/django/template/base.py in render(993)
  return render_value_in_context(output, context)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/django/template/base.py in render_value_in_context(972)
  value = str(value)
/home/protwis/gpcrdb_test/common/models.py in __str__(49)
  return Template(str(self.web_resource)).substitute(index=self.index)
30 </div>
31 <div class="col-md-10">
32 {% for link in protein_links %}
33 <p><a href="{{ link }}">{{ link.web_resource.name }}</a></p>
34 {% empty %}
35 No links available
36 {% endfor %}
37 </div>

/home/protwis/gpcrdb_test/protein/templates/protein/protein_detail.html

  +
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") INNER JOIN "protein" ON ("protein_conformation"."protein_id" = "protein"."id") WHERE "protein"."entry_name" = 'aa1r_human' ORDER BY "residue"."sequence_number" ASC
  2 similar queries.   Duplicated 2 times.
0.39978812591603086%
1.19

Connection: default

/usr/lib/python3.6/concurrent/futures/thread.py in _worker(69)
  work_item.run()
/usr/lib/python3.6/concurrent/futures/thread.py in run(56)
  result = self.fn(*self.args, **self.kwargs)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle(279)
  keepalive = self.handle_request(req, conn)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle_request(328)
  respiter = self.wsgi(environ, resp.start_response)
/home/protwis/gpcrdb_test/common/middleware/stats.py in __call__(34)
  response = self.get_response(request)
/home/protwis/gpcrdb_test/protein/views.py in detail(156)
  return render(request, 'protein/protein_detail.html', context)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/django/shortcuts.py in render(36)
  content = loader.render_to_string(template_name, context, request, using=using)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/django/template/loader.py in render_to_string(62)
  return template.render(context, request)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/django/template/backends/django.py in render(61)
  return self.template.render(context)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/django/template/base.py in render(171)
  return self._render(context)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/django/test/utils.py in instrumented_test_render(96)
  return self.nodelist.render(context)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/django/template/base.py in render(937)
  bit = node.render_annotated(context)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/django/template/base.py in render_annotated(904)
  return self.render(context)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/django/template/loader_tags.py in render(150)
  return compiled_parent._render(context)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/django/test/utils.py in instrumented_test_render(96)
  return self.nodelist.render(context)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/django/template/base.py in render(937)
  bit = node.render_annotated(context)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/django/template/base.py in render_annotated(904)
  return self.render(context)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/django/template/loader_tags.py in render(62)
  result = block.nodelist.render(context)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/django/template/base.py in render(937)
  bit = node.render_annotated(context)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/django/template/base.py in render_annotated(904)
  return self.render(context)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/django/template/defaulttags.py in render(309)
  return nodelist.render(context)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/django/template/base.py in render(937)
  bit = node.render_annotated(context)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/django/template/base.py in render_annotated(904)
  return self.render(context)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/django/template/base.py in render(987)
  output = self.filter_expression.resolve(context)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/django/template/base.py in resolve(671)
  obj = self.var.resolve(context)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/django/template/base.py in resolve(796)
  value = self._resolve_lookup(context)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/django/template/base.py in _resolve_lookup(858)
  current = current()
/home/protwis/gpcrdb_test/protein/models.py in get_helical_box(48)
  return DrawHelixBox(residuelist,self.get_protein_class(),str(self))
/home/protwis/gpcrdb_test/common/diagrams_gpcr.py in __init__(1217)
  for r in residue_list:
42 <h4>DIAGRAMS</h4>
43 </div>
44 <div class="col-md-10">
45 {{ p.get_helical_box }}
46 <p><div class="btn-group">
47 <button type="button" class="btn btn-sm btn-primary dropdown-toggle" data-toggle="dropdown"
48 aria-haspopup="true" aria-expanded="false">
49 <span class="glyphicon glyphicon-download"></span> Download <span class="caret"></span>

/home/protwis/gpcrdb_test/protein/templates/protein/protein_detail.html

  +
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
  3 similar queries.   Duplicated 3 times.
0.16010757177394863%
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/protein/views.py in detail(156)
  return render(request, 'protein/protein_detail.html', context)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/django/shortcuts.py in render(36)
  content = loader.render_to_string(template_name, context, request, using=using)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/django/template/loader.py in render_to_string(62)
  return template.render(context, request)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/django/template/backends/django.py in render(61)
  return self.template.render(context)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/django/template/base.py in render(171)
  return self._render(context)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/django/test/utils.py in instrumented_test_render(96)
  return self.nodelist.render(context)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/django/template/base.py in render(937)
  bit = node.render_annotated(context)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/django/template/base.py in render_annotated(904)
  return self.render(context)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/django/template/loader_tags.py in render(150)
  return compiled_parent._render(context)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/django/test/utils.py in instrumented_test_render(96)
  return self.nodelist.render(context)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/django/template/base.py in render(937)
  bit = node.render_annotated(context)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/django/template/base.py in render_annotated(904)
  return self.render(context)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/django/template/loader_tags.py in render(62)
  result = block.nodelist.render(context)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/django/template/base.py in render(937)
  bit = node.render_annotated(context)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/django/template/base.py in render_annotated(904)
  return self.render(context)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/django/template/defaulttags.py in render(309)
  return nodelist.render(context)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/django/template/base.py in render(937)
  bit = node.render_annotated(context)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/django/template/base.py in render_annotated(904)
  return self.render(context)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/django/template/base.py in render(987)
  output = self.filter_expression.resolve(context)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/django/template/base.py in resolve(671)
  obj = self.var.resolve(context)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/django/template/base.py in resolve(796)
  value = self._resolve_lookup(context)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/django/template/base.py in _resolve_lookup(858)
  current = current()
/home/protwis/gpcrdb_test/protein/models.py in get_helical_box(48)
  return DrawHelixBox(residuelist,self.get_protein_class(),str(self))
/home/protwis/gpcrdb_test/common/diagrams_gpcr.py in __init__(1217)
  for r in residue_list:
42 <h4>DIAGRAMS</h4>
43 </div>
44 <div class="col-md-10">
45 {{ p.get_helical_box }}
46 <p><div class="btn-group">
47 <button type="button" class="btn btn-sm btn-primary dropdown-toggle" data-toggle="dropdown"
48 aria-haspopup="true" aria-expanded="false">
49 <span class="glyphicon glyphicon-download"></span> Download <span class="caret"></span>

/home/protwis/gpcrdb_test/protein/templates/protein/protein_detail.html

  +
SELECT ••• "residue_generic_number"."id", "residue_generic_number"."scheme_id", "residue_generic_number"."protein_segment_id", "residue_generic_number"."label" FROM "residue_generic_number" WHERE "residue_generic_number"."id" IN (47617, 28674, 35330, 49665, 71172, 88068, 90119, 90635, 64024, 25625, 88601, 24606, 8222, 32, 2080, 14366, 30754, 37410, 43043, 79903, 85541, 93630, 83498, 52781, 84575, 91181, 94257, 66104, 68600, 572, 10302, 16446, 18494, 45121, 32834, 39490, 41026, 51265, 71, 80979, 77399, 26200, 57432, 59480, 61528, 68184, 22110, 20062, 3678, 5726, 28258, 34914, 47201, 49249, 53859, 70752, 82022, 89186, 118, 4094, 20478, 26230, 63608, 69245, 13950, 7806, 24190, 94335, 30338, 36994, 41602, 72323, 138, 73356, 86668, 65688, 79512, 87193, 78491, 92829, 16030, 9886, 1696, 18078, 11422, 32418, 39074, 44705, 75426, 76446, 74409, 52403, 92339, 93876, 22526, 97459, 57016, 59064, 61112, 67768, 5310, 3262, 21694, 46785, 27842, 34498, 42178, 50882, 85196, 93390, 80591, 63192, 89816, 90330, 19678, 23774, 224, 7390, 29922, 11998, 13534, 36578, 48865, 84193, 91871, 83178, 246, 98040, 65272, 90874, 9470, 17662, 15614, 44289, 32002, 38658, 42755, 70910, 71935, 81664, 97548, 86285, 98064, 87826, 88343, 25368, 56600, 58648, 60696, 67352, 74011, 4894, 2847, 1312, 46369, 27426, 34082, 40738, 77091, 79141, 59896, 98089, 53553, 78131, 25912, 62776, 52026, 74041, 19262, 23358, 6974, 13118, 21310, 29506, 36162, 48449, 50498, 98113, 70469, 75076, 91462, NULL, 88916, 64856, 98137, 82778, 96089, 9054, 15198, 43873, 31586, 38242, 41314, 73062, 61944, 80234, 89457, 12286, 98166, 60280, 66936, 71545, 86907, 97654, 17278, 11134, 4478, 45953, 27010, 33666, 40322, 68995, 83841, 97152, 92552, 76096, 94607, 58264, 62360, 98202, 81307, 94104, 6558, 12702, 928, 2464, 20894, 29090, 22942, 35746, 41890, 48033, 50081, 93099, 53164, 97203, 64440, 85944, 91578, 51645, 18878, 8638, 11710, 14782, 31170, 37826, 43459, 84933, 77766, 78791, 76744, 73679, 66520, 75738, 92123, 73692, 10718, 16862, 87519, 45537, 26594, 33250, 39906, 42467, 69603, 82402, 74732, 91126, 53239, 57848, 97270, 72701, 6142)
  6 similar queries.   Duplicated 3 times.
0.4411372285363299%
1.31

Connection: default

/usr/lib/python3.6/concurrent/futures/thread.py in _worker(69)
  work_item.run()
/usr/lib/python3.6/concurrent/futures/thread.py in run(56)
  result = self.fn(*self.args, **self.kwargs)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle(279)
  keepalive = self.handle_request(req, conn)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle_request(328)
  respiter = self.wsgi(environ, resp.start_response)
/home/protwis/gpcrdb_test/common/middleware/stats.py in __call__(34)
  response = self.get_response(request)
/home/protwis/gpcrdb_test/protein/views.py in detail(156)
  return render(request, 'protein/protein_detail.html', context)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/django/shortcuts.py in render(36)
  content = loader.render_to_string(template_name, context, request, using=using)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/django/template/loader.py in render_to_string(62)
  return template.render(context, request)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/django/template/backends/django.py in render(61)
  return self.template.render(context)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/django/template/base.py in render(171)
  return self._render(context)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/django/test/utils.py in instrumented_test_render(96)
  return self.nodelist.render(context)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/django/template/base.py in render(937)
  bit = node.render_annotated(context)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/django/template/base.py in render_annotated(904)
  return self.render(context)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/django/template/loader_tags.py in render(150)
  return compiled_parent._render(context)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/django/test/utils.py in instrumented_test_render(96)
  return self.nodelist.render(context)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/django/template/base.py in render(937)
  bit = node.render_annotated(context)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/django/template/base.py in render_annotated(904)
  return self.render(context)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/django/template/loader_tags.py in render(62)
  result = block.nodelist.render(context)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/django/template/base.py in render(937)
  bit = node.render_annotated(context)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/django/template/base.py in render_annotated(904)
  return self.render(context)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/django/template/defaulttags.py in render(309)
  return nodelist.render(context)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/django/template/base.py in render(937)
  bit = node.render_annotated(context)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/django/template/base.py in render_annotated(904)
  return self.render(context)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/django/template/base.py in render(987)
  output = self.filter_expression.resolve(context)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/django/template/base.py in resolve(671)
  obj = self.var.resolve(context)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/django/template/base.py in resolve(796)
  value = self._resolve_lookup(context)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/django/template/base.py in _resolve_lookup(858)
  current = current()
/home/protwis/gpcrdb_test/protein/models.py in get_helical_box(48)
  return DrawHelixBox(residuelist,self.get_protein_class(),str(self))
/home/protwis/gpcrdb_test/common/diagrams_gpcr.py in __init__(1217)
  for r in residue_list:
42 <h4>DIAGRAMS</h4>
43 </div>
44 <div class="col-md-10">
45 {{ p.get_helical_box }}
46 <p><div class="btn-group">
47 <button type="button" class="btn btn-sm btn-primary dropdown-toggle" data-toggle="dropdown"
48 aria-haspopup="true" aria-expanded="false">
49 <span class="glyphicon glyphicon-download"></span> Download <span class="caret"></span>

/home/protwis/gpcrdb_test/protein/templates/protein/protein_detail.html

  +
SELECT ••• "residue_generic_number"."id", "residue_generic_number"."scheme_id", "residue_generic_number"."protein_segment_id", "residue_generic_number"."label" FROM "residue_generic_number" WHERE "residue_generic_number"."id" IN (88576, 30722, 37378, 43010, 2, 6, 7, 4, 79876, 85510, 83467, 9, 10, 11, 15, 16, 17, 18, 19, 20, 12, 13, 23, 24, 66072, 27, 16414, 2079, 10270, 18462, 32802, 39458, 40994, 45089, 52780, 94253, 53806, 55347, 80949, 77366, 26168, 57400, 59448, 61496, 68152, 3646, 5694, 22078, 26174, 28226, 34882, 47169, 51266, 70718, 81989, 84547, 596, 89174, 63576, 24158, 7774, 13918, 69216, 30306, 98, 36962, 41570, 72295, 73322, 94325, 65656, 79480, 86651, 78461, 9854, 18046, 11390, 15998, 32386, 39042, 44673, 75396, 76414, 92800, 87176, 74380, 54927, 92307, 56984, 59032, 61080, 67736, 88056, 93849, 5278, 3230, 1695, 46753, 27810, 34466, 42146, 97436, 85164, 80559, 93361, 52404, 183, 63160, 89785, 187, 19646, 23742, 7358, 11966, 13502, 29890, 36546, 48833, 50881, 91838, 83146, 84171, 65240, 25307, 71900, 9438, 15582, 73952, 44257, 31970, 38626, 42722, 81632, 54507, 70898, 86259, 8190, 24574, 56568, 60664, 67320, 53500, 4862, 46337, 27394, 34050, 40706, 87809, 88322, 97537, 70419, 77076, 78102, 74007, 25880, 62744, 6942, 13086, 21278, 1313, 29474, 23326, 36130, 48417, 50466, 50465, 75046, 76072, 91437, 96047, 64824, 82746, 52027, 9022, 15166, 88894, 43841, 31554, 38210, 41282, 54087, 73034, NULL, 80210, 71509, 56152, 66904, 89432, 86875, 11102, 17246, 45921, 26978, 33634, 40290, 68964, 83810, 94561, 97637, 92526, 58232, 62328, 97144, 12670, 20862, 6526, 22910, 29058, 35714, 41858, 48001, 50049, 94078, 93066, 81293, 98194, 64408, 85912, 410, 11678, 2463, 8606, 929, 31138, 14750, 37794, 43426, 73635, 63992, 78761, 76714, 77739, 91563, 97198, 84911, 93615, 66488, 51642, 10686, 16830, 75712, 45505, 33218, 39874, 42434, 69573, 82370, 53191, 87493, 92098, 73674, 55758, 74704, 26584, 57816, 59864, 61912, 68568, 72668, 22494, 20446, 4062, 6110, 12254, 28642, 35298, 47585, 49633, 71138, 97259, 91122, 25592, 14334)
  6 similar queries.   Duplicated 3 times.
0.42446937321651945%
1.26

Connection: default

/usr/lib/python3.6/concurrent/futures/thread.py in _worker(69)
  work_item.run()
/usr/lib/python3.6/concurrent/futures/thread.py in run(56)
  result = self.fn(*self.args, **self.kwargs)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle(279)
  keepalive = self.handle_request(req, conn)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle_request(328)
  respiter = self.wsgi(environ, resp.start_response)
/home/protwis/gpcrdb_test/common/middleware/stats.py in __call__(34)
  response = self.get_response(request)
/home/protwis/gpcrdb_test/protein/views.py in detail(156)
  return render(request, 'protein/protein_detail.html', context)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/django/shortcuts.py in render(36)
  content = loader.render_to_string(template_name, context, request, using=using)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/django/template/loader.py in render_to_string(62)
  return template.render(context, request)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/django/template/backends/django.py in render(61)
  return self.template.render(context)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/django/template/base.py in render(171)
  return self._render(context)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/django/test/utils.py in instrumented_test_render(96)
  return self.nodelist.render(context)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/django/template/base.py in render(937)
  bit = node.render_annotated(context)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/django/template/base.py in render_annotated(904)
  return self.render(context)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/django/template/loader_tags.py in render(150)
  return compiled_parent._render(context)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/django/test/utils.py in instrumented_test_render(96)
  return self.nodelist.render(context)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/django/template/base.py in render(937)
  bit = node.render_annotated(context)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/django/template/base.py in render_annotated(904)
  return self.render(context)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/django/template/loader_tags.py in render(62)
  result = block.nodelist.render(context)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/django/template/base.py in render(937)
  bit = node.render_annotated(context)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/django/template/base.py in render_annotated(904)
  return self.render(context)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/django/template/defaulttags.py in render(309)
  return nodelist.render(context)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/django/template/base.py in render(937)
  bit = node.render_annotated(context)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/django/template/base.py in render_annotated(904)
  return self.render(context)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/django/template/base.py in render(987)
  output = self.filter_expression.resolve(context)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/django/template/base.py in resolve(671)
  obj = self.var.resolve(context)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/django/template/base.py in resolve(796)
  value = self._resolve_lookup(context)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/django/template/base.py in _resolve_lookup(858)
  current = current()
/home/protwis/gpcrdb_test/protein/models.py in get_helical_box(48)
  return DrawHelixBox(residuelist,self.get_protein_class(),str(self))
/home/protwis/gpcrdb_test/common/diagrams_gpcr.py in __init__(1217)
  for r in residue_list:
42 <h4>DIAGRAMS</h4>
43 </div>
44 <div class="col-md-10">
45 {{ p.get_helical_box }}
46 <p><div class="btn-group">
47 <button type="button" class="btn btn-sm btn-primary dropdown-toggle" data-toggle="dropdown"
48 aria-haspopup="true" aria-expanded="false">
49 <span class="glyphicon glyphicon-download"></span> Download <span class="caret"></span>

/home/protwis/gpcrdb_test/protein/templates/protein/protein_detail.html

  +
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") INNER JOIN "protein" ON ("protein_conformation"."protein_id" = "protein"."id") WHERE "protein"."entry_name" = 'aa1r_human' ORDER BY "residue"."sequence_number" ASC
  2 similar queries.   Duplicated 2 times.
0.3568363448995962%
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/protein/views.py in detail(156)
  return render(request, 'protein/protein_detail.html', context)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/django/shortcuts.py in render(36)
  content = loader.render_to_string(template_name, context, request, using=using)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/django/template/loader.py in render_to_string(62)
  return template.render(context, request)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/django/template/backends/django.py in render(61)
  return self.template.render(context)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/django/template/base.py in render(171)
  return self._render(context)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/django/test/utils.py in instrumented_test_render(96)
  return self.nodelist.render(context)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/django/template/base.py in render(937)
  bit = node.render_annotated(context)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/django/template/base.py in render_annotated(904)
  return self.render(context)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/django/template/loader_tags.py in render(150)
  return compiled_parent._render(context)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/django/test/utils.py in instrumented_test_render(96)
  return self.nodelist.render(context)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/django/template/base.py in render(937)
  bit = node.render_annotated(context)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/django/template/base.py in render_annotated(904)
  return self.render(context)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/django/template/loader_tags.py in render(62)
  result = block.nodelist.render(context)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/django/template/base.py in render(937)
  bit = node.render_annotated(context)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/django/template/base.py in render_annotated(904)
  return self.render(context)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/django/template/defaulttags.py in render(309)
  return nodelist.render(context)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/django/template/base.py in render(937)
  bit = node.render_annotated(context)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/django/template/base.py in render_annotated(904)
  return self.render(context)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/django/template/base.py in render(987)
  output = self.filter_expression.resolve(context)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/django/template/base.py in resolve(671)
  obj = self.var.resolve(context)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/django/template/base.py in resolve(796)
  value = self._resolve_lookup(context)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/django/template/base.py in _resolve_lookup(858)
  current = current()
/home/protwis/gpcrdb_test/protein/models.py in get_snake_plot(52)
  return DrawSnakePlot(residuelist,self.get_protein_class(),str(self))
/home/protwis/gpcrdb_test/common/diagrams_gpcr.py in __init__(50)
  for r in self.sequence:
67 </li>
68 </ul>
69 </div></p>
70 {{ p.get_snake_plot }}
71 <p><div class="btn-group">
72 <button type="button" class="btn btn-sm btn-primary dropdown-toggle" data-toggle="dropdown"
73 aria-haspopup="true" aria-expanded="false">
74 <span class="glyphicon glyphicon-download"></span> Download <span class="caret"></span>

/home/protwis/gpcrdb_test/protein/templates/protein/protein_detail.html

  +
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
  3 similar queries.   Duplicated 3 times.
0.1466450732464094%
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/protein/views.py in detail(156)
  return render(request, 'protein/protein_detail.html', context)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/django/shortcuts.py in render(36)
  content = loader.render_to_string(template_name, context, request, using=using)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/django/template/loader.py in render_to_string(62)
  return template.render(context, request)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/django/template/backends/django.py in render(61)
  return self.template.render(context)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/django/template/base.py in render(171)
  return self._render(context)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/django/test/utils.py in instrumented_test_render(96)
  return self.nodelist.render(context)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/django/template/base.py in render(937)
  bit = node.render_annotated(context)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/django/template/base.py in render_annotated(904)
  return self.render(context)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/django/template/loader_tags.py in render(150)
  return compiled_parent._render(context)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/django/test/utils.py in instrumented_test_render(96)
  return self.nodelist.render(context)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/django/template/base.py in render(937)
  bit = node.render_annotated(context)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/django/template/base.py in render_annotated(904)
  return self.render(context)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/django/template/loader_tags.py in render(62)
  result = block.nodelist.render(context)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/django/template/base.py in render(937)
  bit = node.render_annotated(context)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/django/template/base.py in render_annotated(904)
  return self.render(context)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/django/template/defaulttags.py in render(309)
  return nodelist.render(context)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/django/template/base.py in render(937)
  bit = node.render_annotated(context)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/django/template/base.py in render_annotated(904)
  return self.render(context)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/django/template/base.py in render(987)
  output = self.filter_expression.resolve(context)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/django/template/base.py in resolve(671)
  obj = self.var.resolve(context)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/django/template/base.py in resolve(796)
  value = self._resolve_lookup(context)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/django/template/base.py in _resolve_lookup(858)
  current = current()
/home/protwis/gpcrdb_test/protein/models.py in get_snake_plot(52)
  return DrawSnakePlot(residuelist,self.get_protein_class(),str(self))
/home/protwis/gpcrdb_test/common/diagrams_gpcr.py in __init__(50)
  for r in self.sequence:
67 </li>
68 </ul>
69 </div></p>
70 {{ p.get_snake_plot }}
71 <p><div class="btn-group">
72 <button type="button" class="btn btn-sm btn-primary dropdown-toggle" data-toggle="dropdown"
73 aria-haspopup="true" aria-expanded="false">
74 <span class="glyphicon glyphicon-download"></span> Download <span class="caret"></span>

/home/protwis/gpcrdb_test/protein/templates/protein/protein_detail.html

  +
SELECT ••• "residue_generic_number"."id", "residue_generic_number"."scheme_id", "residue_generic_number"."protein_segment_id", "residue_generic_number"."label" FROM "residue_generic_number" WHERE "residue_generic_number"."id" IN (47617, 28674, 35330, 49665, 71172, 88068, 90119, 90635, 64024, 25625, 88601, 24606, 8222, 32, 2080, 14366, 30754, 37410, 43043, 79903, 85541, 93630, 83498, 52781, 84575, 91181, 94257, 66104, 68600, 572, 10302, 16446, 18494, 45121, 32834, 39490, 41026, 51265, 71, 80979, 77399, 26200, 57432, 59480, 61528, 68184, 22110, 20062, 3678, 5726, 28258, 34914, 47201, 49249, 53859, 70752, 82022, 89186, 118, 4094, 20478, 26230, 63608, 69245, 13950, 7806, 24190, 94335, 30338, 36994, 41602, 72323, 138, 73356, 86668, 65688, 79512, 87193, 78491, 92829, 16030, 9886, 1696, 18078, 11422, 32418, 39074, 44705, 75426, 76446, 74409, 52403, 92339, 93876, 22526, 97459, 57016, 59064, 61112, 67768, 5310, 3262, 21694, 46785, 27842, 34498, 42178, 50882, 85196, 93390, 80591, 63192, 89816, 90330, 19678, 23774, 224, 7390, 29922, 11998, 13534, 36578, 48865, 84193, 91871, 83178, 246, 98040, 65272, 90874, 9470, 17662, 15614, 44289, 32002, 38658, 42755, 70910, 71935, 81664, 97548, 86285, 98064, 87826, 88343, 25368, 56600, 58648, 60696, 67352, 74011, 4894, 2847, 1312, 46369, 27426, 34082, 40738, 77091, 79141, 59896, 98089, 53553, 78131, 25912, 62776, 52026, 74041, 19262, 23358, 6974, 13118, 21310, 29506, 36162, 48449, 50498, 98113, 70469, 75076, 91462, NULL, 88916, 64856, 98137, 82778, 96089, 9054, 15198, 43873, 31586, 38242, 41314, 73062, 61944, 80234, 89457, 12286, 98166, 60280, 66936, 71545, 86907, 97654, 17278, 11134, 4478, 45953, 27010, 33666, 40322, 68995, 83841, 97152, 92552, 76096, 94607, 58264, 62360, 98202, 81307, 94104, 6558, 12702, 928, 2464, 20894, 29090, 22942, 35746, 41890, 48033, 50081, 93099, 53164, 97203, 64440, 85944, 91578, 51645, 18878, 8638, 11710, 14782, 31170, 37826, 43459, 84933, 77766, 78791, 76744, 73679, 66520, 75738, 92123, 73692, 10718, 16862, 87519, 45537, 26594, 33250, 39906, 42467, 69603, 82402, 74732, 91126, 53239, 57848, 97270, 72701, 6142)
  6 similar queries.   Duplicated 3 times.
0.40203187567062076%
1.20