VPAC1 receptor (vipr1_human)

FAMILY

Class B1 (Secretin) Peptide receptors VIP and PACAP receptors VPAC1 receptor

GENE

VIPR1

ORGANISM

Human (Homo sapiens)

ALT. NAMES

Vasoactive intestinal polypeptide receptor 1, VIP-R-1, Pituitary adenylate cyclase-activating polypeptide type II receptor, PACAP type II receptor, PACAP-R-2, PACAP-R2, VPAC1

SOURCE

SWISSPROT

SEQUENCE

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

LINKS

ChEMBL

Guide To Pharmacology

UniProt

DIAGRAMS

L L T A L S L G Y G I T Y G T K V S G Y 1 M H L F I S F I L R A A A V F I K D L A 2 V L L W F F N A M V C Y Q F F V M A A K 3 Y F W G Y I L G I W G V P S T F T M V W T 4 F L I F N V L I S T L I P G K I I W W L S 5 L L L I P L F G V H Y I M F A F F 6 I A V V F G Q F S G V V L E F V M K V 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 R K L H ICL1ECL1 F D S G E S D Q C S E G ECL1ICL2 S F F ICL2ECL2 D Y G C W D T I ECL2ICL3 R P P D I R K ICL3ECL3 P D N F K ECL3N-term M R P P S P L P A R W L C V L A G A L A W A L G P A G G Q A A R L Q E E C D Y V Q M I E V Q H K Q C L E E A Q L E N E T I G C S K M W D N L T C W P A T P R G Q V V V L A C P L I F K L F S S I Q G R N V S R S C T D E G W T H L E P G P Y P I A C G L D D K A N-termC-term Y R H P S G G S N G A T C S T Q V S M L T R V S P G A R R S S S F Q A E V S L V C-term A S L D E Q Q T M F Y G S V K T G Y T I G Y G L S L A T L L V A T A I L S L F C T R N Y I H M H L F I S F I L R A A A V F I K D L A L S V G C K A A M V F F Q Y C V M A N F F W L L V E G L Y L Y T L L A V S E R K Y F W G Y I L I G W G V P S T F T M V W T I A R I H F E N S S L W W I I K G P I L T S I L V N F I L F I C I I R I L L Q K L S D S S P Y S R L A R S T L L L I P L F G V H Y I M F A F F P E V K M V F E L V V G S F Q G F V V A I L Y C F L N G E L R R W H L G W N V Q A E K W R R Q G V L P K
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

197 mutation data points available.

ENDOGENOUS LIGANDS

secretin,

GHRH,

VIP,

PACAP-27,

PACAP-38,

PHM,

PHV,

PHI

HOMOLOGY MODELS

vipr1_human intermediate,

vipr1_human inactive

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 932.641 msec
System CPU time 47.680 msec
Total CPU time 980.321 msec
Elapsed time 1107.031 msec
Context switches 127 voluntary, 17 involuntary

Browser timing

Timing attribute Timeline Milliseconds since navigation start (+length)

Settings from protwis.settings

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

Headers

Request headers

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

Response headers

Key Value
Cache-Control max-age=604800
Content-Length 928204
Content-Type text/html; charset=utf-8
Expires Thu, 08 Jun 2023 06:21:26 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/vipr1_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': 'vipr1_human'} detail

No cookies

No session data

No GET data

No POST data

SQL queries from 1 connection

  •   default 131.23 ms (56 queries including 25 similar and 15 duplicates )
  Query Timeline Time (ms) Action
  +
SELECT ••• (1) AS "a" FROM "protein" WHERE "protein"."entry_name" = 'vipr1_human' LIMIT 1
1.9274337280009304%
 2.53

Connection: default

/usr/lib/python3.6/concurrent/futures/thread.py in _worker(69)
  work_item.run()
/usr/lib/python3.6/concurrent/futures/thread.py in run(56)
  result = self.fn(*self.args, **self.kwargs)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle(279)
  keepalive = self.handle_request(req, conn)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle_request(328)
  respiter = self.wsgi(environ, resp.start_response)
/home/protwis/gpcrdb_test/common/middleware/stats.py in __call__(34)
  response = self.get_response(request)
/home/protwis/gpcrdb_test/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" = 'vipr1_human' AND "protein_sequence_type"."slug" = 'wt')
0.8618857202032626%
 1.13

Connection: default

/usr/lib/python3.6/concurrent/futures/thread.py in _worker(69)
  work_item.run()
/usr/lib/python3.6/concurrent/futures/thread.py in run(56)
  result = self.fn(*self.args, **self.kwargs)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle(279)
  keepalive = self.handle_request(req, conn)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle_request(328)
  respiter = self.wsgi(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 (303)
2.857449116221946%
 3.75

Connection: default

/usr/lib/python3.6/concurrent/futures/thread.py in _worker(69)
  work_item.run()
/usr/lib/python3.6/concurrent/futures/thread.py in run(56)
  result = self.fn(*self.args, **self.kwargs)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle(279)
  keepalive = self.handle_request(req, conn)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle_request(328)
  respiter = self.wsgi(environ, resp.start_response)
/home/protwis/gpcrdb_test/common/middleware/stats.py in __call__(34)
  response = self.get_response(request)
/home/protwis/gpcrdb_test/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.3455536761860467%
 0.45

Connection: default

/usr/lib/python3.6/concurrent/futures/thread.py in _worker(69)
  work_item.run()
/usr/lib/python3.6/concurrent/futures/thread.py in run(56)
  result = self.fn(*self.args, **self.kwargs)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle(279)
  keepalive = self.handle_request(req, conn)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle_request(328)
  respiter = self.wsgi(environ, resp.start_response)
/home/protwis/gpcrdb_test/common/middleware/stats.py in __call__(34)
  response = self.get_response(request)
/home/protwis/gpcrdb_test/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" = 394
  5 similar queries.
0.30449419626068047%
 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(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" = 392
  5 similar queries.
0.22437370667180212%
 0.29

Connection: default

/usr/lib/python3.6/concurrent/futures/thread.py in _worker(69)
  work_item.run()
/usr/lib/python3.6/concurrent/futures/thread.py in run(56)
  result = self.fn(*self.args, **self.kwargs)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle(279)
  keepalive = self.handle_request(req, conn)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle_request(328)
  respiter = self.wsgi(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" = 369
  5 similar queries.
0.1771371368461596%
 0.23

Connection: default

/usr/lib/python3.6/concurrent/futures/thread.py in _worker(69)
  work_item.run()
/usr/lib/python3.6/concurrent/futures/thread.py in run(56)
  result = self.fn(*self.args, **self.kwargs)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle(279)
  keepalive = self.handle_request(req, conn)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle_request(328)
  respiter = self.wsgi(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" = 368
  5 similar queries.
0.23018743834265043%
 0.30

Connection: default

/usr/lib/python3.6/concurrent/futures/thread.py in _worker(69)
  work_item.run()
/usr/lib/python3.6/concurrent/futures/thread.py in run(56)
  result = self.fn(*self.args, **self.kwargs)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle(279)
  keepalive = self.handle_request(req, conn)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle_request(328)
  respiter = self.wsgi(environ, resp.start_response)
/home/protwis/gpcrdb_test/common/middleware/stats.py in __call__(34)
  response = self.get_response(request)
/home/protwis/gpcrdb_test/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.23890803584892292%
 0.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(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" = 303
0.387884909914411%
 0.51

Connection: default

/usr/lib/python3.6/concurrent/futures/thread.py in _worker(69)
  work_item.run()
/usr/lib/python3.6/concurrent/futures/thread.py in run(56)
  result = self.fn(*self.args, **self.kwargs)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle(279)
  keepalive = self.handle_request(req, conn)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle_request(328)
  respiter = self.wsgi(environ, resp.start_response)
/home/protwis/gpcrdb_test/common/middleware/stats.py in __call__(34)
  response = self.get_response(request)
/home/protwis/gpcrdb_test/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" = 303 ORDER BY "gene"."position" ASC
0.7034615321726461%
 0.92

Connection: default

/usr/lib/python3.6/concurrent/futures/thread.py in _worker(69)
  work_item.run()
/usr/lib/python3.6/concurrent/futures/thread.py in run(56)
  result = self.fn(*self.args, **self.kwargs)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle(279)
  keepalive = self.handle_request(req, conn)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle_request(328)
  respiter = self.wsgi(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" = 303 ORDER BY "residue"."sequence_number" ASC
3.131239542095959%
 4.11

Connection: default

/usr/lib/python3.6/concurrent/futures/thread.py in _worker(69)
  work_item.run()
/usr/lib/python3.6/concurrent/futures/thread.py in run(56)
  result = self.fn(*self.args, **self.kwargs)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle(279)
  keepalive = self.handle_request(req, conn)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle_request(328)
  respiter = self.wsgi(environ, resp.start_response)
/home/protwis/gpcrdb_test/common/middleware/stats.py in __call__(34)
  response = self.get_response(request)
/home/protwis/gpcrdb_test/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.45546954058802264%
 0.60

Connection: default

/usr/lib/python3.6/concurrent/futures/thread.py in _worker(69)
  work_item.run()
/usr/lib/python3.6/concurrent/futures/thread.py in run(56)
  result = self.fn(*self.args, **self.kwargs)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle(279)
  keepalive = self.handle_request(req, conn)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle_request(328)
  respiter = self.wsgi(environ, resp.start_response)
/home/protwis/gpcrdb_test/common/middleware/stats.py in __call__(34)
  response = self.get_response(request)
/home/protwis/gpcrdb_test/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, 1, 30722, 37378, 43010, 2, 6, 4, 79876, 85510, 9, 83467, 10, 11, 12, 15, 13, 17, 18, 19, 20, 21, 23, 24, 66072, 27, 16414, 2079, 10270, 18462, 32802, 39458, 45089, 52780, 94253, 53806, 55347, 77366, 57400, 59448, 61496, 68152, 3646, 5694, 22078, 26174, 28226, 34882, 47169, 51266, 70718, 84547, 596, 89174, 63576, 7774, 13918, 30306, 98, 36962, 72295, 73322, 94323, 94325, 119, 65656, 79480, 86651, 78461, 9854, 18046, 11390, 15998, 126, 32386, 39042, 44673, 75396, 76414, 136, 87176, 74380, 53902, 54927, 92307, 56984, 59032, 61080, 67736, 88056, 93849, 3230, 1695, 5278, 46753, 27810, 34466, 97436, 85164, 80559, 93361, 52404, 183, 63160, 89785, 187, 188, 19646, 23742, 7358, 11966, 13502, 29890, 36546, 48833, 50881, 91838, 84171, 65240, 71900, 9438, 15582, 44257, 31970, 38626, 54507, 70898, 86259, 8190, 56568, 60664, 67320, 98042, 53500, 4862, 46337, 27394, 34050, 87809, 88322, 97537, 77076, 78102, 74007, 62744, 100122, 53532, 6942, 13086, 21278, 1313, 29474, 23326, 36130, 48417, 50466, 50465, 75046, 76072, 91437, 96047, 98103, 64824, 52027, 9022, 15166, 88894, 43841, 31554, 38210, 73034, 54603, NULL, 80210, 71509, 56152, 66904, 89432, 86875, 11102, 17246, 45921, 26978, 33634, 40290, 83810, 94561, 97637, 92526, 98167, 58232, 62328, 97144, 12670, 20862, 6526, 22910, 29058, 35714, 48001, 50049, 94078, 94599, 93066, 64408, 85912, 410, 11678, 2463, 8606, 929, 14750, 31138, 37794, 43426, 78761, 76714, 77739, 91563, 53165, 97198, 84911, 93615, 66488, 51642, 10686, 16830, 75712, 45505, 33218, 39874, 92098, 87493, 53191, 73674, 55758, 74704, 92800, 26584, 57816, 59864, 61912, 72668, 22494, 20446, 4062, 6110, 12254, 28642, 35298, 47585, 49633, 54247, 71138, 97259, 91122, 63992, 14334)
  6 similar queries.   Duplicated 3 times.
1.2270607407784224%
 1.61

Connection: default

/usr/lib/python3.6/concurrent/futures/thread.py in _worker(69)
  work_item.run()
/usr/lib/python3.6/concurrent/futures/thread.py in run(56)
  result = self.fn(*self.args, **self.kwargs)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle(279)
  keepalive = self.handle_request(req, conn)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle_request(328)
  respiter = self.wsgi(environ, resp.start_response)
/home/protwis/gpcrdb_test/common/middleware/stats.py in __call__(34)
  response = self.get_response(request)
/home/protwis/gpcrdb_test/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 (48641, 29698, 36354, 50690, 95239, 54793, 96779, 80407, 65048, 89624, 9246, 11294, 15390, 31778, 38434, 96804, 94757, 41, 71721, 92208, 84020, 85045, 56376, 60472, 67128, 93240, 93754, 61, 4670, 17470, 97338, 27202, 33858, 40514, 94278, 86092, 91726, 98898, 99410, 19454, 98391, 62552, 94810, 11870, 2655, 1120, 6750, 12894, 29282, 35938, 98403, 98402, 98404, 48225, 50273, 53345, 76904, 90218, 90735, 94833, 78964, 94328, 120, 51834, 64632, 88184, 77949, 8830, 14974, 19070, 87680, 130, 31362, 38018, 75909, 74892, 55960, 66712, 53404, 10910, 17054, 26786, 33442, 40098, 54436, 95398, 88741, 91305, 71338, 80051, 94388, 89271, 60088, 62136, 72888, 91322, 4286, 6334, 12478, 49857, 28866, 35522, 70853, 99026, 94418, 83669, 7166, 94423, 98519, 64216, 14558, 2271, 736, 8414, 30946, 37602, 85727, 97508, 53991, 73825, 52972, 94959, 77552, 66296, 51450, 16638, 10494, 18686, 84734, 33026, 39682, 92424, 86794, 98573, 55571, 92948, 59672, 61720, 68376, 283, 76571, 285, 3870, 5918, 98075, 49441, 28450, 35106, 72483, 78627, 93991, 73512, 100137, 97586, 75573, 94518, 311, 26422, 63800, 317, 7998, 11582, 14142, 54079, 30530, 37186, 74564, 87363, 91972, 93510, 70986, NULL, 79695, 99154, 85331, 98647, 65880, 90971, 349, 10078, 18270, 16222, 1887, 32610, 39266, 90463, 91485, 98141, 52588, 55150, 55155, 59256, 95097, 61304, 67960, 84348, 88441, 5502, 12158, 3454, 51073, 28034, 34690, 80770, 89980, 77200, 63384, 97180, 413, 19870, 7582, 13726, 49057, 30114, 36770, 87965, 98206, 97702, 440, 65464, 15806, 9662, 17854, 72127, 32194, 38850, 79300, 86472, 94153, 94666, 53710, 78287, 54736, 96209, 98770, 99282, 75219, 89043, 97232, 56792, 53721, 60888, 67544, 3038, 1503, 5086, 96736, 27618, 34274, 73184, 76263, 74224, 52211, 92661, 96758, 62968, 13310, 87039)
  6 similar queries.   Duplicated 3 times.
0.8190094491307562%
 1.07