alpha-1 subunit (gpa1_yeast)

FAMILY

G-Protein Alpha GPa1 family GPa1

GENE

ORGANISM

strain ATCC 204508 / S288c (Saccharomyces cerevisiae)

ALT. NAMES

Guanine nucleotide-binding protein alpha-1 subunit, Guanine nucleotide-binding protein alpha-1 subunit, GP1-alpha, GP1-alpha

SOURCE

SWISSPROT

SEQUENCE

HN                
M
G
C
T
V
S
T
Q
T
I
10
                   
G
D
E
S
D
P
F
L
Q
N
20
                   
K
R
A
N
D
V
I
E
Q
S
30
                   
L
Q
L
E
K
Q
R
D
K
N
40
S1                
E
I
K
L
L
L
L
G
A
G
50
s1h1 H1        
E
S
G
K
S
T
V
L
K
Q
60
          h1ha  
L
K
L
L
H
Q
G
G
F
S
70
HA                
H
Q
E
R
L
Q
Y
A
Q
V
80
                   
I
W
A
D
A
I
Q
S
M
K
90
                   
I
L
I
I
Q
A
R
K
L
G
100
hahb            
I
Q
L
D
C
D
D
P
I
N
110
                   
N
K
D
L
F
A
C
K
R
I
120
                   
L
L
K
A
K
A
L
D
Y
I
130
                   
N
A
S
V
A
G
G
S
D
F
140
                   
L
N
D
Y
V
L
K
Y
S
E
150
                   
R
Y
E
T
R
R
R
V
Q
S
160
                   
T
G
R
A
K
A
A
F
D
E
170
          HB      
D
G
N
I
S
N
V
K
S
D
180
                   
T
D
R
D
A
E
T
V
T
Q
190
hbhc            
N
E
D
A
D
R
N
N
S
S
200
                   
R
I
N
L
Q
D
I
C
K
D
210
                   
L
N
Q
E
G
D
D
Q
M
F
220
                   
V
R
K
T
S
R
E
I
Q
G
230
                HC
Q
N
R
R
N
L
I
H
E
D
240
                   
I
A
K
A
I
K
Q
L
W
N
250
hchd HD        
N
D
K
G
I
K
Q
C
F
A
260
        hdhe    
R
S
N
E
F
Q
L
E
G
S
270
HE                
A
A
Y
Y
F
D
N
I
E
K
280
    hehf        
F
A
S
P
N
Y
V
C
T
D
290
HF       hfs2  
E
D
I
L
K
G
R
I
K
T
300
    S2            
T
G
I
T
E
T
E
F
N
I
310
s2s3 S3        
G
S
S
K
F
K
V
L
D
A
320
s3h2 H2        
G
G
Q
R
S
E
R
K
K
W
330
      h2s4   S4
I
H
C
F
E
G
I
T
A
V
340
          s4h3  
L
F
V
L
A
M
S
E
Y
D
350
                   
Q
M
L
F
E
D
E
R
V
N
360
H3                
R
M
H
E
S
I
M
L
F
D
370
                   
T
L
L
N
S
K
W
F
K
D
380
h3s5 S5        
T
P
F
I
L
F
L
N
K
I
390
HG                
D
L
F
E
E
K
V
K
S
M
400
        hgh4    
P
I
R
K
Y
F
P
D
Y
Q
410
    H4            
G
R
V
G
D
A
E
A
G
L
420
                   
K
Y
F
E
K
I
F
L
S
L
430
h4s6     S6    
N
K
T
N
K
P
I
Y
V
K
440
  s6h5   H5    
R
T
C
A
T
D
T
Q
T
M
450
                   
K
F
V
L
S
A
V
T
D
L
460
                   
I
I
Q
Q
N
L
K
K
I
G
470
   
I
I

LINKS

DIAGRAMS

D K N hns1 G A G E S G s1h1 Q G G F S h1ha G I Q L D C D D P I N N K D L F A C K R I L L K A K A L D Y I N A S V A G G S D F L N D Y V L K Y S E R Y E T R R R V Q S T G R A K A A F D E D G N I S hahb Q N E D A D R N N S S R I N L Q D I C K D L N Q E G D D Q M F V R K T S R E I Q G Q N R R N L I H hbhc N D hchd F Q L E G hdhe S P N Y V C T hehf G R I K T T G hfs2 G S s2s3 G G Q s3h2 F E G I T h2s4 M S E Y D Q M L F E D E R V N s4h3 K D T h3s5 K s5hg Y F P D Y Q G R hgh4 L N K T N K P h4s6 T C A T D s6h5 M G C T V S T Q T I G D E S D P F L Q N K R A N D V I E Q S L Q L E K Q R E I K L L L L K S T V L K Q L K L L H H Q E R L Q Y A Q V I W A D A I Q S M K I L I I Q A R K L N V K S D T D R D A E T V T E D I A K A I K Q L W N K G I K Q C F A R S N E S A A Y Y F D N I E K F A D E D I L K I T E T E F N I S K F K V L D A R S E R K K W I H C A V L F V L A R M H E S I M L F D T L L N S K W F P F I L F L N I D L F E E K V K S M P I R K V G D A E A G L K Y F E K I F L S I Y V K R T Q T M K F V L S A V T D L I I Q Q N L K K I G I I
Pick color:
 
 
 
 
 
 
 
 
 
 
 
 















MUTATIONS

0 mutation data points available.

STRUCTURES

No structures available

RECEPTOR COMPLEX 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 847.989 msec
System CPU time 15.972 msec
Total CPU time 863.961 msec
Elapsed time 892.202 msec
Context switches 42 voluntary, 16 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 44.211.84.185
X-Forwarded-Proto https
X-Real-Ip 44.211.84.185

Response headers

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

WSGI environ

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

Key Value
PATH_INFO /signprot/gpa1_yeast/
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
signprot.views.signprotdetail () {'slug': 'gpa1_yeast'} signprotdetail

No cookies

No session data

No GET data

No POST data

SQL queries from 1 connection

  •   default 25.97 ms (22 queries including 11 similar and 6 duplicates )
  Query Timeline Time (ms) Action
  +
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" = 'gpa1_yeast' AND "protein_sequence_type"."slug" = 'wt')
11.036027764515774%
2.87

Connection: default

/usr/lib/python3.6/concurrent/futures/thread.py in _worker(69)
  work_item.run()
/usr/lib/python3.6/concurrent/futures/thread.py in run(56)
  result = self.fn(*self.args, **self.kwargs)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle(279)
  keepalive = self.handle_request(req, conn)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle_request(328)
  respiter = self.wsgi(environ, resp.start_response)
/home/protwis/gpcrdb_test/common/middleware/stats.py in __call__(34)
  response = self.get_response(request)
/home/protwis/gpcrdb_test/signprot/views.py in signprotdetail(1016)
  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 (55563)
3.143707077013478%
0.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/signprot/views.py in signprotdetail(1016)
  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" = 555
  5 similar queries.
1.8794300194645415%
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/signprot/views.py in signprotdetail(1019)
  if p.family.slug.startswith("00"):
  +
SELECT ••• "protein_family"."id", "protein_family"."parent_id", "protein_family"."slug", "protein_family"."name" FROM "protein_family" WHERE "protein_family"."id" = 554
  5 similar queries.
1.021888427779206%
0.27

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/signprot/views.py in signprotdetail(1025)
  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" = 533
  5 similar queries.
1.421278783649785%
0.37

Connection: default

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

Connection: default

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

Connection: default

/usr/lib/python3.6/concurrent/futures/thread.py in _worker(69)
  work_item.run()
/usr/lib/python3.6/concurrent/futures/thread.py in run(56)
  result = self.fn(*self.args, **self.kwargs)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle(279)
  keepalive = self.handle_request(req, conn)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle_request(328)
  respiter = self.wsgi(environ, resp.start_response)
/home/protwis/gpcrdb_test/common/middleware/stats.py in __call__(34)
  response = self.get_response(request)
/home/protwis/gpcrdb_test/signprot/views.py in signprotdetail(1049)
  pc = ProteinConformation.objects.get(protein=p)
  +
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" = 55863 ORDER BY "residue"."sequence_number" ASC
20.05582283594697%
5.21

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/signprot/views.py in signprotdetail(1062)
  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 (22, 23, 24, 25, 26, 27, 28, 29, 30, 31, 32, 33, 34, 35, 36, 37, 38, 39, 40, 41, 42, 43, 44, 45, 46, 47, 48, 49, 50, 51, 52, 53, 54, 55, 56, 57, 58) ORDER BY "protein_segment"."id" ASC
  2 similar queries.   Duplicated 2 times.
3.3034632193617104%
0.86

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/signprot/views.py in signprotdetail(1062)
  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 (104624, 104625, 104626, 104627, 104628, 104629, 104630, 104631, 104632, 104633, 104634, 104636, 104637, 104638, 104639, 104640, 104641, 104642, 104643, 104644, 104645, 104646, 104647, 104648, 104649, 104650, 104651, 104652, 104653, 104654, 104655, 104656, 104657, 104658, 104659, 104660, 104661, 104662, 104663, 104664, 104665, 104666, 104667, 104668, 104669, 104670, 104671, 104672, 104673, 104674, 104675, 104676, 104677, 104678, 104679, 104680, 104681, 104682, 104683, 104684, 104685, 104686, 104687, 104688, 104689, 104690, 104691, 104692, 104708, 104709, 104710, 104711, 104712, 104713, 104714, 104715, 104716, 104717, 104718, 104719, 104720, 104721, 104722, 104723, 104724, 104725, 104726, 104727, 104728, 104729, 104730, 104731, 104732, 104733, 104734, 104735, 104736, 104737, 104740, 104741, 104742, 104743, 104744, 104745, 104746, 104747, 104748, 104749, 104750, 104751, 104752, 104753, 104754, 104755, 104756, 104757, 104758, 104759, 104760, 104761, 104762, 104763, 104764, 104765, 104766, 104767, 104768, 104769, 104770, 104771, 104772, 104773, 104774, 104775, 104776, 104777, 104778, 104779, 104780, 104781, 104782, 104783, 104784, 104785, 104786, 104787, 104788, 104789, 104790, 104791, 104792, 104793, 104794, 104795, 104796, 104797, 104798, 104799, 104800, 104801, 104802, 104803, 104804, 104805, 104806, 104807, 104808, 104809, 104810, 104811, 104812, 104813, 104814, 104815, 104816, 104817, 104818, 104819, 104820, 104821, 104822, 104823, 104824, 104825, 104826, 104827, 104828, 104829, 104830, 104831, 104832, 104833, 104834, 104835, 104836, 104837, 104838, 104839, 104840, 104841, 104842, 104843, 104844, 104845, 104846, 104847, 104848, 104849, 104850, 104851, 104852, 104853, 104854, 104855, 104856, 104857, 104858, 104859, 104860, 104861, 104862, 104863, 104864, 104865, 104866, 104867, 104868, 104869, 104870, 104871, 104872, 104873, 104874, 104875, 104876, 104877, 104878, 104879, 104880, 104881, 104882, 104883, 104884, 104885, 104886, 104887, 104888, 104889, 104890, 104891, 104892, 104893, 104894, 104895, 104896, 104897, 104898, 104899, 104900, 104901, 104902, 104903, 104904, 104905, 104906, 104907, 104908, 104909, 104910, 104911, 104912, 104913, 104914, 104915, 104916, 104917, 104918, 104919, 104920, 104921, 104922, 104923, 104924, 104925, 104928, 104929, 104930, 104931, 104932, 104933, 104934, 104935, 104936, 104937, 104938, 104939, 104940, 104941, 104955, 104956, 104957, 104958, 104959, 104960, 104961, 104962, 104963, 104964, 104965, 104966, 104967, 104968, 104969, 104970, 104971, 104972, 104975, 104976, 104977, 104978, 104979, 104982, 104983, 104984, 104985, 104986, 104987, 104988, 104989, 104990, 104991, 104992, 104993, 104994, 104995, 104996, 104997, 104998, 104999, 105000, 105001, 105002, 105003, 105004, 105005, 105006, 105007, 105008, 105009, 105010, 105011, 105012, 105013, 105014, 105015, 105016, 105017, 105020, 105021, 105025, 105027, 105032, 105053, 105054, 105055, 105056, 105057, 105058, 105059, 105060, 105061, 105062, 105063, 105064, 105065, 105066, 105067, 105068, 105069, 105070, 105071, 105072, 105073, 105074, 105075, 105076, 105077, 105078, 105079, 105080, 105081, 105082, 105083, 105084, 105085, 105086, 105087, 105088, 105089, 105090, 105091, 105092, 105093, 105094, 105095, 105096, 105097, 105098, 105099, 105100, 105101, 105102, 105103, 105104, 105105, 105106, 105107, 105108, 105109, 105110, 105111, 105112, 105113, 105114, 105115, 105116, 105117, 105118, 105119, 105120, 105121, 105122, 105123, 105124, 105125, 105126, 105127, 105128, 105129, 105130, 105131, 105132, 105133, 105134, 105135, 105136, 105137, 105138, 105139, 105140, 105141, 105142, 105143, 105144, 105145, 105146, 105147, 105148, 105149, 105150, 105151, 105152, 105153, 105154, 105155, 105156, 105157, 105158, 105159, 105160, 105161, 105162)
  4 similar queries.   Duplicated 4 times.
7.944654596202579%
2.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/signprot/views.py in signprotdetail(1062)
  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 (104624, 104625, 104626, 104627, 104628, 104629, 104630, 104631, 104632, 104633, 104634, 104636, 104637, 104638, 104639, 104640, 104641, 104642, 104643, 104644, 104645, 104646, 104647, 104648, 104649, 104650, 104651, 104652, 104653, 104654, 104655, 104656, 104657, 104658, 104659, 104660, 104661, 104662, 104663, 104664, 104665, 104666, 104667, 104668, 104669, 104670, 104671, 104672, 104673, 104674, 104675, 104676, 104677, 104678, 104679, 104680, 104681, 104682, 104683, 104684, 104685, 104686, 104687, 104688, 104689, 104690, 104691, 104692, 104708, 104709, 104710, 104711, 104712, 104713, 104714, 104715, 104716, 104717, 104718, 104719, 104720, 104721, 104722, 104723, 104724, 104725, 104726, 104727, 104728, 104729, 104730, 104731, 104732, 104733, 104734, 104735, 104736, 104737, 104740, 104741, 104742, 104743, 104744, 104745, 104746, 104747, 104748, 104749, 104750, 104751, 104752, 104753, 104754, 104755, 104756, 104757, 104758, 104759, 104760, 104761, 104762, 104763, 104764, 104765, 104766, 104767, 104768, 104769, 104770, 104771, 104772, 104773, 104774, 104775, 104776, 104777, 104778, 104779, 104780, 104781, 104782, 104783, 104784, 104785, 104786, 104787, 104788, 104789, 104790, 104791, 104792, 104793, 104794, 104795, 104796, 104797, 104798, 104799, 104800, 104801, 104802, 104803, 104804, 104805, 104806, 104807, 104808, 104809, 104810, 104811, 104812, 104813, 104814, 104815, 104816, 104817, 104818, 104819, 104820, 104821, 104822, 104823, 104824, 104825, 104826, 104827, 104828, 104829, 104830, 104831, 104832, 104833, 104834, 104835, 104836, 104837, 104838, 104839, 104840, 104841, 104842, 104843, 104844, 104845, 104846, 104847, 104848, 104849, 104850, 104851, 104852, 104853, 104854, 104855, 104856, 104857, 104858, 104859, 104860, 104861, 104862, 104863, 104864, 104865, 104866, 104867, 104868, 104869, 104870, 104871, 104872, 104873, 104874, 104875, 104876, 104877, 104878, 104879, 104880, 104881, 104882, 104883, 104884, 104885, 104886, 104887, 104888, 104889, 104890, 104891, 104892, 104893, 104894, 104895, 104896, 104897, 104898, 104899, 104900, 104901, 104902, 104903, 104904, 104905, 104906, 104907, 104908, 104909, 104910, 104911, 104912, 104913, 104914, 104915, 104916, 104917, 104918, 104919, 104920, 104921, 104922, 104923, 104924, 104925, 104928, 104929, 104930, 104931, 104932, 104933, 104934, 104935, 104936, 104937, 104938, 104939, 104940, 104941, 104955, 104956, 104957, 104958, 104959, 104960, 104961, 104962, 104963, 104964, 104965, 104966, 104967, 104968, 104969, 104970, 104971, 104972, 104975, 104976, 104977, 104978, 104979, 104982, 104983, 104984, 104985, 104986, 104987, 104988, 104989, 104990, 104991, 104992, 104993, 104994, 104995, 104996, 104997, 104998, 104999, 105000, 105001, 105002, 105003, 105004, 105005, 105006, 105007, 105008, 105009, 105010, 105011, 105012, 105013, 105014, 105015, 105016, 105017, 105020, 105021, 105025, 105027, 105032, 105053, 105054, 105055, 105056, 105057, 105058, 105059, 105060, 105061, 105062, 105063, 105064, 105065, 105066, 105067, 105068, 105069, 105070, 105071, 105072, 105073, 105074, 105075, 105076, 105077, 105078, 105079, 105080, 105081, 105082, 105083, 105084, 105085, 105086, 105087, 105088, 105089, 105090, 105091, 105092, 105093, 105094, 105095, 105096, 105097, 105098, 105099, 105100, 105101, 105102, 105103, 105104, 105105, 105106, 105107, 105108, 105109, 105110, 105111, 105112, 105113, 105114, 105115, 105116, 105117, 105118, 105119, 105120, 105121, 105122, 105123, 105124, 105125, 105126, 105127, 105128, 105129, 105130, 105131, 105132, 105133, 105134, 105135, 105136, 105137, 105138, 105139, 105140, 105141, 105142, 105143, 105144, 105145, 105146, 105147, 105148, 105149, 105150, 105151, 105152, 105153, 105154, 105155, 105156, 105157, 105158, 105159, 105160, 105161, 105162)
  4 similar queries.   Duplicated 4 times.
6.314040177751662%
1.64

Connection: default

/usr/lib/python3.6/concurrent/futures/thread.py in _worker(69)
  work_item.run()
/usr/lib/python3.6/concurrent/futures/thread.py in run(56)
  result = self.fn(*self.args, **self.kwargs)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle(279)
  keepalive = self.handle_request(req, conn)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle_request(328)
  respiter = self.wsgi(environ, resp.start_response)
/home/protwis/gpcrdb_test/common/middleware/stats.py in __call__(34)
  response = self.get_response(request)
/home/protwis/gpcrdb_test/signprot/views.py in signprotdetail(1062)
  for i, r in enumerate(residues):
  +
SELECT ••• "species"."id", "species"."latin_name", "species"."common_name" FROM "species" WHERE "species"."id" = 2
2.8710198685225308%
0.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/signprot/views.py in signprotdetail(1094)
  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/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
4 {% block addon_css %}

/home/protwis/gpcrdb_test/signprot/templates/signprot/signprot_details.html

  +
SELECT ••• "protein_alias"."name" FROM "protein_alias" WHERE "protein_alias"."protein_id" = 55563 ORDER BY "protein_alias"."position" ASC
2.5129457563627016%
0.65

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/signprot/views.py in signprotdetail(1094)
  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/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]
1 {% extends "home/base.html" %}
2 {% load static %}
3
4 {% block addon_css %}

/home/protwis/gpcrdb_test/signprot/templates/signprot/signprot_details.html

  +
SELECT ••• "protein_source"."id", "protein_source"."name" FROM "protein_source" WHERE "protein_source"."id" = 1
1.9308457894156965%
0.50

Connection: default

/usr/lib/python3.6/concurrent/futures/thread.py in _worker(69)
  work_item.run()
/usr/lib/python3.6/concurrent/futures/thread.py in run(56)
  result = self.fn(*self.args, **self.kwargs)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle(279)
  keepalive = self.handle_request(req, conn)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle_request(328)
  respiter = self.wsgi(environ, resp.start_response)
/home/protwis/gpcrdb_test/common/middleware/stats.py in __call__(34)
  response = self.get_response(request)
/home/protwis/gpcrdb_test/signprot/views.py in signprotdetail(1094)
  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/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)
36 <p><div class="btn-group ">
37 <div class="col-md-6">
38 <input type="range" class="range-slider vertical-range" id="fader" value="0.80" min="0.01" max="0.99" step="0.05" oninput="outputUpdate(value)">
39 <input type="text" maxlength="4" size="3" value="0.80" name="cutoff" title="A bold text"/>
40 <!-- <span class="tooltip">Info</span> -->
41 <script type="text/javascript">
42 function outputUpdate(vol) {
43 document.querySelector('input[name=cutoff]').value = vol;

/home/protwis/gpcrdb_test/signprot/templates/signprot/signprot_details.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" = 'gpa1_yeast' ORDER BY "residue"."sequence_number" ASC
6.2084542216019685%
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/signprot/views.py in signprotdetail(1094)
  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_gprotein_plot(64)
  return DrawGproteinPlot(residuelist,self.get_protein_class(),str(self))
/home/protwis/gpcrdb_test/common/diagrams_gprotein.py in __init__(36)
  for r in self.sequence:
32 </div>
33 <div class="col-md-10" style="height:500px">
34 {% if 'Alpha' in families %}
35 {{ p.get_gprotein_plot }}
36 <p><div class="btn-group ">
37 <div class="col-md-6">
38 <input type="range" class="range-slider vertical-range" id="fader" value="0.80" min="0.01" max="0.99" step="0.05" oninput="outputUpdate(value)">
39 <input type="text" maxlength="4" size="3" value="0.80" name="cutoff" title="A bold text"/>

/home/protwis/gpcrdb_test/signprot/templates/signprot/signprot_details.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 (22, 23, 24, 25, 26, 27, 28, 29, 30, 31, 32, 33, 34, 35, 36, 37, 38, 39, 40, 41, 42, 43, 44, 45, 46, 47, 48, 49, 50, 51, 52, 53, 54, 55, 56, 57, 58) ORDER BY "protein_segment"."id" ASC
  2 similar queries.   Duplicated 2 times.
2.1805795291784493%
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/signprot/views.py in signprotdetail(1094)
  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_gprotein_plot(64)
  return DrawGproteinPlot(residuelist,self.get_protein_class(),str(self))
/home/protwis/gpcrdb_test/common/diagrams_gprotein.py in __init__(36)
  for r in self.sequence:
32 </div>
33 <div class="col-md-10" style="height:500px">
34 {% if 'Alpha' in families %}
35 {{ p.get_gprotein_plot }}
36 <p><div class="btn-group ">
37 <div class="col-md-6">
38 <input type="range" class="range-slider vertical-range" id="fader" value="0.80" min="0.01" max="0.99" step="0.05" oninput="outputUpdate(value)">
39 <input type="text" maxlength="4" size="3" value="0.80" name="cutoff" title="A bold text"/>

/home/protwis/gpcrdb_test/signprot/templates/signprot/signprot_details.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 (104624, 104625, 104626, 104627, 104628, 104629, 104630, 104631, 104632, 104633, 104634, 104636, 104637, 104638, 104639, 104640, 104641, 104642, 104643, 104644, 104645, 104646, 104647, 104648, 104649, 104650, 104651, 104652, 104653, 104654, 104655, 104656, 104657, 104658, 104659, 104660, 104661, 104662, 104663, 104664, 104665, 104666, 104667, 104668, 104669, 104670, 104671, 104672, 104673, 104674, 104675, 104676, 104677, 104678, 104679, 104680, 104681, 104682, 104683, 104684, 104685, 104686, 104687, 104688, 104689, 104690, 104691, 104692, 104708, 104709, 104710, 104711, 104712, 104713, 104714, 104715, 104716, 104717, 104718, 104719, 104720, 104721, 104722, 104723, 104724, 104725, 104726, 104727, 104728, 104729, 104730, 104731, 104732, 104733, 104734, 104735, 104736, 104737, 104740, 104741, 104742, 104743, 104744, 104745, 104746, 104747, 104748, 104749, 104750, 104751, 104752, 104753, 104754, 104755, 104756, 104757, 104758, 104759, 104760, 104761, 104762, 104763, 104764, 104765, 104766, 104767, 104768, 104769, 104770, 104771, 104772, 104773, 104774, 104775, 104776, 104777, 104778, 104779, 104780, 104781, 104782, 104783, 104784, 104785, 104786, 104787, 104788, 104789, 104790, 104791, 104792, 104793, 104794, 104795, 104796, 104797, 104798, 104799, 104800, 104801, 104802, 104803, 104804, 104805, 104806, 104807, 104808, 104809, 104810, 104811, 104812, 104813, 104814, 104815, 104816, 104817, 104818, 104819, 104820, 104821, 104822, 104823, 104824, 104825, 104826, 104827, 104828, 104829, 104830, 104831, 104832, 104833, 104834, 104835, 104836, 104837, 104838, 104839, 104840, 104841, 104842, 104843, 104844, 104845, 104846, 104847, 104848, 104849, 104850, 104851, 104852, 104853, 104854, 104855, 104856, 104857, 104858, 104859, 104860, 104861, 104862, 104863, 104864, 104865, 104866, 104867, 104868, 104869, 104870, 104871, 104872, 104873, 104874, 104875, 104876, 104877, 104878, 104879, 104880, 104881, 104882, 104883, 104884, 104885, 104886, 104887, 104888, 104889, 104890, 104891, 104892, 104893, 104894, 104895, 104896, 104897, 104898, 104899, 104900, 104901, 104902, 104903, 104904, 104905, 104906, 104907, 104908, 104909, 104910, 104911, 104912, 104913, 104914, 104915, 104916, 104917, 104918, 104919, 104920, 104921, 104922, 104923, 104924, 104925, 104928, 104929, 104930, 104931, 104932, 104933, 104934, 104935, 104936, 104937, 104938, 104939, 104940, 104941, 104955, 104956, 104957, 104958, 104959, 104960, 104961, 104962, 104963, 104964, 104965, 104966, 104967, 104968, 104969, 104970, 104971, 104972, 104975, 104976, 104977, 104978, 104979, 104982, 104983, 104984, 104985, 104986, 104987, 104988, 104989, 104990, 104991, 104992, 104993, 104994, 104995, 104996, 104997, 104998, 104999, 105000, 105001, 105002, 105003, 105004, 105005, 105006, 105007, 105008, 105009, 105010, 105011, 105012, 105013, 105014, 105015, 105016, 105017, 105020, 105021, 105025, 105027, 105032, 105053, 105054, 105055, 105056, 105057, 105058, 105059, 105060, 105061, 105062, 105063, 105064, 105065, 105066, 105067, 105068, 105069, 105070, 105071, 105072, 105073, 105074, 105075, 105076, 105077, 105078, 105079, 105080, 105081, 105082, 105083, 105084, 105085, 105086, 105087, 105088, 105089, 105090, 105091, 105092, 105093, 105094, 105095, 105096, 105097, 105098, 105099, 105100, 105101, 105102, 105103, 105104, 105105, 105106, 105107, 105108, 105109, 105110, 105111, 105112, 105113, 105114, 105115, 105116, 105117, 105118, 105119, 105120, 105121, 105122, 105123, 105124, 105125, 105126, 105127, 105128, 105129, 105130, 105131, 105132, 105133, 105134, 105135, 105136, 105137, 105138, 105139, 105140, 105141, 105142, 105143, 105144, 105145, 105146, 105147, 105148, 105149, 105150, 105151, 105152, 105153, 105154, 105155, 105156, 105157, 105158, 105159, 105160, 105161, 105162)
  4 similar queries.   Duplicated 4 times.
6.1212310404348305%
1.59

Connection: default

/usr/lib/python3.6/concurrent/futures/thread.py in _worker(69)
  work_item.run()
/usr/lib/python3.6/concurrent/futures/thread.py in run(56)
  result = self.fn(*self.args, **self.kwargs)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle(279)
  keepalive = self.handle_request(req, conn)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle_request(328)
  respiter = self.wsgi(environ, resp.start_response)
/home/protwis/gpcrdb_test/common/middleware/stats.py in __call__(34)
  response = self.get_response(request)
/home/protwis/gpcrdb_test/signprot/views.py in signprotdetail(1094)
  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_gprotein_plot(64)
  return DrawGproteinPlot(residuelist,self.get_protein_class(),str(self))
/home/protwis/gpcrdb_test/common/diagrams_gprotein.py in __init__(36)
  for r in self.sequence:
32 </div>
33 <div class="col-md-10" style="height:500px">
34 {% if 'Alpha' in families %}
35 {{ p.get_gprotein_plot }}
36 <p><div class="btn-group ">
37 <div class="col-md-6">
38 <input type="range" class="range-slider vertical-range" id="fader" value="0.80" min="0.01" max="0.99" step="0.05" oninput="outputUpdate(value)">
39 <input type="text" maxlength="4" size="3" value="0.80" name="cutoff" title="A bold text"/>

/home/protwis/gpcrdb_test/signprot/templates/signprot/signprot_details.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 (104624, 104625, 104626, 104627, 104628, 104629, 104630, 104631, 104632, 104633, 104634, 104636, 104637, 104638, 104639, 104640, 104641, 104642, 104643, 104644, 104645, 104646, 104647, 104648, 104649, 104650, 104651, 104652, 104653, 104654, 104655, 104656, 104657, 104658, 104659, 104660, 104661, 104662, 104663, 104664, 104665, 104666, 104667, 104668, 104669, 104670, 104671, 104672, 104673, 104674, 104675, 104676, 104677, 104678, 104679, 104680, 104681, 104682, 104683, 104684, 104685, 104686, 104687, 104688, 104689, 104690, 104691, 104692, 104708, 104709, 104710, 104711, 104712, 104713, 104714, 104715, 104716, 104717, 104718, 104719, 104720, 104721, 104722, 104723, 104724, 104725, 104726, 104727, 104728, 104729, 104730, 104731, 104732, 104733, 104734, 104735, 104736, 104737, 104740, 104741, 104742, 104743, 104744, 104745, 104746, 104747, 104748, 104749, 104750, 104751, 104752, 104753, 104754, 104755, 104756, 104757, 104758, 104759, 104760, 104761, 104762, 104763, 104764, 104765, 104766, 104767, 104768, 104769, 104770, 104771, 104772, 104773, 104774, 104775, 104776, 104777, 104778, 104779, 104780, 104781, 104782, 104783, 104784, 104785, 104786, 104787, 104788, 104789, 104790, 104791, 104792, 104793, 104794, 104795, 104796, 104797, 104798, 104799, 104800, 104801, 104802, 104803, 104804, 104805, 104806, 104807, 104808, 104809, 104810, 104811, 104812, 104813, 104814, 104815, 104816, 104817, 104818, 104819, 104820, 104821, 104822, 104823, 104824, 104825, 104826, 104827, 104828, 104829, 104830, 104831, 104832, 104833, 104834, 104835, 104836, 104837, 104838, 104839, 104840, 104841, 104842, 104843, 104844, 104845, 104846, 104847, 104848, 104849, 104850, 104851, 104852, 104853, 104854, 104855, 104856, 104857, 104858, 104859, 104860, 104861, 104862, 104863, 104864, 104865, 104866, 104867, 104868, 104869, 104870, 104871, 104872, 104873, 104874, 104875, 104876, 104877, 104878, 104879, 104880, 104881, 104882, 104883, 104884, 104885, 104886, 104887, 104888, 104889, 104890, 104891, 104892, 104893, 104894, 104895, 104896, 104897, 104898, 104899, 104900, 104901, 104902, 104903, 104904, 104905, 104906, 104907, 104908, 104909, 104910, 104911, 104912, 104913, 104914, 104915, 104916, 104917, 104918, 104919, 104920, 104921, 104922, 104923, 104924, 104925, 104928, 104929, 104930, 104931, 104932, 104933, 104934, 104935, 104936, 104937, 104938, 104939, 104940, 104941, 104955, 104956, 104957, 104958, 104959, 104960, 104961, 104962, 104963, 104964, 104965, 104966, 104967, 104968, 104969, 104970, 104971, 104972, 104975, 104976, 104977, 104978, 104979, 104982, 104983, 104984, 104985, 104986, 104987, 104988, 104989, 104990, 104991, 104992, 104993, 104994, 104995, 104996, 104997, 104998, 104999, 105000, 105001, 105002, 105003, 105004, 105005, 105006, 105007, 105008, 105009, 105010, 105011, 105012, 105013, 105014, 105015, 105016, 105017, 105020, 105021, 105025, 105027, 105032, 105053, 105054, 105055, 105056, 105057, 105058, 105059, 105060, 105061, 105062, 105063, 105064, 105065, 105066, 105067, 105068, 105069, 105070, 105071, 105072, 105073, 105074, 105075, 105076, 105077, 105078, 105079, 105080, 105081, 105082, 105083, 105084, 105085, 105086, 105087, 105088, 105089, 105090, 105091, 105092, 105093, 105094, 105095, 105096, 105097, 105098, 105099, 105100, 105101, 105102, 105103, 105104, 105105, 105106, 105107, 105108, 105109, 105110, 105111, 105112, 105113, 105114, 105115, 105116, 105117, 105118, 105119, 105120, 105121, 105122, 105123, 105124, 105125, 105126, 105127, 105128, 105129, 105130, 105131, 105132, 105133, 105134, 105135, 105136, 105137, 105138, 105139, 105140, 105141, 105142, 105143, 105144, 105145, 105146, 105147, 105148, 105149, 105150, 105151, 105152, 105153, 105154, 105155, 105156, 105157, 105158, 105159, 105160, 105161, 105162)
  4 similar queries.   Duplicated 4 times.
6.225898857835396%
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/signprot/views.py in signprotdetail(1094)
  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_gprotein_plot(64)
  return DrawGproteinPlot(residuelist,self.get_protein_class(),str(self))
/home/protwis/gpcrdb_test/common/diagrams_gprotein.py in __init__(36)
  for r in self.sequence:
32 </div>
33 <div class="col-md-10" style="height:500px">
34 {% if 'Alpha' in families %}
35 {{ p.get_gprotein_plot }}
36 <p><div class="btn-group ">
37 <div class="col-md-6">
38 <input type="range" class="range-slider vertical-range" id="fader" value="0.80" min="0.01" max="0.99" step="0.05" oninput="outputUpdate(value)">
39 <input type="text" maxlength="4" size="3" value="0.80" name="cutoff" title="A bold text"/>

/home/protwis/gpcrdb_test/signprot/templates/signprot/signprot_details.html

  +
SELECT ••• "mutation_experiment"."id", "mutation_experiment"."submitting_group", "mutation_experiment"."refs_id", "mutation_experiment"."data_container", "mutation_experiment"."data_container_number", "mutation_experiment"."review_id", "mutation_experiment"."protein_id", "mutation_experiment"."residue_id", "mutation_experiment"."mutation_id", "mutation_experiment"."ligand_id", "mutation_experiment"."ligand_role_id", "mutation_experiment"."ligand_ref_id", "mutation_experiment"."raw_id", "mutation_experiment"."optional_id", "mutation_experiment"."exp_type_id", "mutation_experiment"."exp_func_id", "mutation_experiment"."exp_measure_id", "mutation_experiment"."exp_qual_id", "mutation_experiment"."wt_value", "mutation_experiment"."wt_unit", "mutation_experiment"."mu_value", "mutation_experiment"."mu_sign", "mutation_experiment"."foldchange", "mutation_experiment"."opt_receptor_expression", "mutation_experiment"."opt_basal_activity", "mutation_experiment"."opt_gain_of_activity", "mutation_experiment"."opt_ligand_emax", "mutation_experiment"."opt_agonist" FROM "mutation_experiment" WHERE "mutation_experiment"."protein_id" = 55563
6.1386756766682575%
1.59

Connection: default

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