Total spending of the NHS for: pilocarpine


Used for (BNF section):

Treatment Of Glaucoma and Drugs Acting On The Oropharynx
«

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 1641.758 msec
System CPU time 107.967 msec
Total CPU time 1749.725 msec
Elapsed time 1809.425 msec
Context switches 192 voluntary, 62 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.236.207.90
X-Forwarded-Proto https
X-Real-Ip 3.236.207.90

Response headers

Key Value
Cache-Control max-age=2419200
Content-Length 41079
Content-Type text/html; charset=utf-8
Expires Wed, 19 Apr 2023 17:02:57 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 /drugs/nhs/pilocarpine/
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
drugs.views.nhs_drug () {'slug': 'pilocarpine'} nhs_drug

No cookies

No session data

No GET data

No POST data

SQL queries from 1 connection

  •   default 70.08 ms (178 queries including 177 similar and 177 duplicates )
  Query Timeline Time (ms) Action
  +
SELECT ••• "drugs_nhs"."id", "drugs_nhs"."drugname_id", "drugs_nhs"."date", "drugs_nhs"."quantity", "drugs_nhs"."items", "drugs_nhs"."actual_cost", "drugs_nhs"."drugCode", "drugs_nhs"."op_name", "drugs_nhs"."bnf_section" FROM "drugs_nhs" INNER JOIN "drugs" ON ("drugs_nhs"."drugname_id" = "drugs"."id") WHERE "drugs"."name" = 'pilocarpine' ORDER BY "drugs_nhs"."date" ASC
5.101783940453673%
3.58

Connection: default

/usr/lib/python3.6/concurrent/futures/thread.py in _worker(69)
  work_item.run()
/usr/lib/python3.6/concurrent/futures/thread.py in run(56)
  result = self.fn(*self.args, **self.kwargs)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle(279)
  keepalive = self.handle_request(req, conn)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle_request(328)
  respiter = self.wsgi(environ, resp.start_response)
/home/protwis/gpcrdb_test/common/middleware/stats.py in __call__(34)
  response = self.get_response(request)
/home/protwis/gpcrdb_test/drugs/views.py in nhs_drug(421)
  for i in nhs_data:
  +
SELECT ••• "drugs"."id", "drugs"."name", "drugs"."synonym", "drugs"."drugtype", "drugs"."status", "drugs"."indication", "drugs"."approval", "drugs"."clinicalstatus", "drugs"."phasedate", "drugs"."phase", "drugs"."moa", "drugs"."targetlevel", "drugs"."externallink", "drugs"."novelty", "drugs"."references" FROM "drugs" WHERE "drugs"."id" = 695
  177 similar queries.   Duplicated 177 times.
0.8977534052715372%
0.63

Connection: default

/usr/lib/python3.6/concurrent/futures/thread.py in _worker(69)
  work_item.run()
/usr/lib/python3.6/concurrent/futures/thread.py in run(56)
  result = self.fn(*self.args, **self.kwargs)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle(279)
  keepalive = self.handle_request(req, conn)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle_request(328)
  respiter = self.wsgi(environ, resp.start_response)
/home/protwis/gpcrdb_test/common/middleware/stats.py in __call__(34)
  response = self.get_response(request)
/home/protwis/gpcrdb_test/drugs/views.py in nhs_drug(423)
  queryname = i.drugname.name
  +
SELECT ••• "drugs"."id", "drugs"."name", "drugs"."synonym", "drugs"."drugtype", "drugs"."status", "drugs"."indication", "drugs"."approval", "drugs"."clinicalstatus", "drugs"."phasedate", "drugs"."phase", "drugs"."moa", "drugs"."targetlevel", "drugs"."externallink", "drugs"."novelty", "drugs"."references" FROM "drugs" WHERE "drugs"."id" = 695
  177 similar queries.   Duplicated 177 times.
0.5606281212154199%
0.39

Connection: default

/usr/lib/python3.6/concurrent/futures/thread.py in _worker(69)
  work_item.run()
/usr/lib/python3.6/concurrent/futures/thread.py in run(56)
  result = self.fn(*self.args, **self.kwargs)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle(279)
  keepalive = self.handle_request(req, conn)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle_request(328)
  respiter = self.wsgi(environ, resp.start_response)
/home/protwis/gpcrdb_test/common/middleware/stats.py in __call__(34)
  response = self.get_response(request)
/home/protwis/gpcrdb_test/drugs/views.py in nhs_drug(423)
  queryname = i.drugname.name
  +
SELECT ••• "drugs"."id", "drugs"."name", "drugs"."synonym", "drugs"."drugtype", "drugs"."status", "drugs"."indication", "drugs"."approval", "drugs"."clinicalstatus", "drugs"."phasedate", "drugs"."phase", "drugs"."moa", "drugs"."targetlevel", "drugs"."externallink", "drugs"."novelty", "drugs"."references" FROM "drugs" WHERE "drugs"."id" = 695
  177 similar queries.   Duplicated 177 times.
0.45687109635455647%
0.32

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/drugs/views.py in nhs_drug(423)
  queryname = i.drugname.name
  +
SELECT ••• "drugs"."id", "drugs"."name", "drugs"."synonym", "drugs"."drugtype", "drugs"."status", "drugs"."indication", "drugs"."approval", "drugs"."clinicalstatus", "drugs"."phasedate", "drugs"."phase", "drugs"."moa", "drugs"."targetlevel", "drugs"."externallink", "drugs"."novelty", "drugs"."references" FROM "drugs" WHERE "drugs"."id" = 695
  177 similar queries.   Duplicated 177 times.
0.4861271754956524%
0.34

Connection: default

/usr/lib/python3.6/concurrent/futures/thread.py in _worker(69)
  work_item.run()
/usr/lib/python3.6/concurrent/futures/thread.py in run(56)
  result = self.fn(*self.args, **self.kwargs)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle(279)
  keepalive = self.handle_request(req, conn)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle_request(328)
  respiter = self.wsgi(environ, resp.start_response)
/home/protwis/gpcrdb_test/common/middleware/stats.py in __call__(34)
  response = self.get_response(request)
/home/protwis/gpcrdb_test/drugs/views.py in nhs_drug(423)
  queryname = i.drugname.name
  +
SELECT ••• "drugs"."id", "drugs"."name", "drugs"."synonym", "drugs"."drugtype", "drugs"."status", "drugs"."indication", "drugs"."approval", "drugs"."clinicalstatus", "drugs"."phasedate", "drugs"."phase", "drugs"."moa", "drugs"."targetlevel", "drugs"."externallink", "drugs"."novelty", "drugs"."references" FROM "drugs" WHERE "drugs"."id" = 695
  177 similar queries.   Duplicated 177 times.
0.5691327953843432%
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/drugs/views.py in nhs_drug(423)
  queryname = i.drugname.name
  +
SELECT ••• "drugs"."id", "drugs"."name", "drugs"."synonym", "drugs"."drugtype", "drugs"."status", "drugs"."indication", "drugs"."approval", "drugs"."clinicalstatus", "drugs"."phasedate", "drugs"."phase", "drugs"."moa", "drugs"."targetlevel", "drugs"."externallink", "drugs"."novelty", "drugs"."references" FROM "drugs" WHERE "drugs"."id" = 695
  177 similar queries.   Duplicated 177 times.
0.5623290560492047%
0.39

Connection: default

/usr/lib/python3.6/concurrent/futures/thread.py in _worker(69)
  work_item.run()
/usr/lib/python3.6/concurrent/futures/thread.py in run(56)
  result = self.fn(*self.args, **self.kwargs)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle(279)
  keepalive = self.handle_request(req, conn)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle_request(328)
  respiter = self.wsgi(environ, resp.start_response)
/home/protwis/gpcrdb_test/common/middleware/stats.py in __call__(34)
  response = self.get_response(request)
/home/protwis/gpcrdb_test/drugs/views.py in nhs_drug(423)
  queryname = i.drugname.name
  +
SELECT ••• "drugs"."id", "drugs"."name", "drugs"."synonym", "drugs"."drugtype", "drugs"."status", "drugs"."indication", "drugs"."approval", "drugs"."clinicalstatus", "drugs"."phasedate", "drugs"."phase", "drugs"."moa", "drugs"."targetlevel", "drugs"."externallink", "drugs"."novelty", "drugs"."references" FROM "drugs" WHERE "drugs"."id" = 695
  177 similar queries.   Duplicated 177 times.
0.5670916735838016%
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/drugs/views.py in nhs_drug(423)
  queryname = i.drugname.name
  +
SELECT ••• "drugs"."id", "drugs"."name", "drugs"."synonym", "drugs"."drugtype", "drugs"."status", "drugs"."indication", "drugs"."approval", "drugs"."clinicalstatus", "drugs"."phasedate", "drugs"."phase", "drugs"."moa", "drugs"."targetlevel", "drugs"."externallink", "drugs"."novelty", "drugs"."references" FROM "drugs" WHERE "drugs"."id" = 695
  177 similar queries.   Duplicated 177 times.
0.584441208888405%
0.41

Connection: default

/usr/lib/python3.6/concurrent/futures/thread.py in _worker(69)
  work_item.run()
/usr/lib/python3.6/concurrent/futures/thread.py in run(56)
  result = self.fn(*self.args, **self.kwargs)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle(279)
  keepalive = self.handle_request(req, conn)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle_request(328)
  respiter = self.wsgi(environ, resp.start_response)
/home/protwis/gpcrdb_test/common/middleware/stats.py in __call__(34)
  response = self.get_response(request)
/home/protwis/gpcrdb_test/drugs/views.py in nhs_drug(423)
  queryname = i.drugname.name
  +
SELECT ••• "drugs"."id", "drugs"."name", "drugs"."synonym", "drugs"."drugtype", "drugs"."status", "drugs"."indication", "drugs"."approval", "drugs"."clinicalstatus", "drugs"."phasedate", "drugs"."phase", "drugs"."moa", "drugs"."targetlevel", "drugs"."externallink", "drugs"."novelty", "drugs"."references" FROM "drugs" WHERE "drugs"."id" = 695
  177 similar queries.   Duplicated 177 times.
0.5715141041516417%
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/drugs/views.py in nhs_drug(423)
  queryname = i.drugname.name
  +
SELECT ••• "drugs"."id", "drugs"."name", "drugs"."synonym", "drugs"."drugtype", "drugs"."status", "drugs"."indication", "drugs"."approval", "drugs"."clinicalstatus", "drugs"."phasedate", "drugs"."phase", "drugs"."moa", "drugs"."targetlevel", "drugs"."externallink", "drugs"."novelty", "drugs"."references" FROM "drugs" WHERE "drugs"."id" = 695
  177 similar queries.   Duplicated 177 times.
0.5772972825865096%
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/drugs/views.py in nhs_drug(423)
  queryname = i.drugname.name
  +
SELECT ••• "drugs"."id", "drugs"."name", "drugs"."synonym", "drugs"."drugtype", "drugs"."status", "drugs"."indication", "drugs"."approval", "drugs"."clinicalstatus", "drugs"."phasedate", "drugs"."phase", "drugs"."moa", "drugs"."targetlevel", "drugs"."externallink", "drugs"."novelty", "drugs"."references" FROM "drugs" WHERE "drugs"."id" = 695
  177 similar queries.   Duplicated 177 times.
0.5636898039162324%
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/drugs/views.py in nhs_drug(423)
  queryname = i.drugname.name
  +
SELECT ••• "drugs"."id", "drugs"."name", "drugs"."synonym", "drugs"."drugtype", "drugs"."status", "drugs"."indication", "drugs"."approval", "drugs"."clinicalstatus", "drugs"."phasedate", "drugs"."phase", "drugs"."moa", "drugs"."targetlevel", "drugs"."externallink", "drugs"."novelty", "drugs"."references" FROM "drugs" WHERE "drugs"."id" = 695
  177 similar queries.   Duplicated 177 times.
0.5830804610213773%
0.41

Connection: default

/usr/lib/python3.6/concurrent/futures/thread.py in _worker(69)
  work_item.run()
/usr/lib/python3.6/concurrent/futures/thread.py in run(56)
  result = self.fn(*self.args, **self.kwargs)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle(279)
  keepalive = self.handle_request(req, conn)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle_request(328)
  respiter = self.wsgi(environ, resp.start_response)
/home/protwis/gpcrdb_test/common/middleware/stats.py in __call__(34)
  response = self.get_response(request)
/home/protwis/gpcrdb_test/drugs/views.py in nhs_drug(423)
  queryname = i.drugname.name
  +
SELECT ••• "drugs"."id", "drugs"."name", "drugs"."synonym", "drugs"."drugtype", "drugs"."status", "drugs"."indication", "drugs"."approval", "drugs"."clinicalstatus", "drugs"."phasedate", "drugs"."phase", "drugs"."moa", "drugs"."targetlevel", "drugs"."externallink", "drugs"."novelty", "drugs"."references" FROM "drugs" WHERE "drugs"."id" = 695
  177 similar queries.   Duplicated 177 times.
0.5691327953843432%
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/drugs/views.py in nhs_drug(423)
  queryname = i.drugname.name
  +
SELECT ••• "drugs"."id", "drugs"."name", "drugs"."synonym", "drugs"."drugtype", "drugs"."status", "drugs"."indication", "drugs"."approval", "drugs"."clinicalstatus", "drugs"."phasedate", "drugs"."phase", "drugs"."moa", "drugs"."targetlevel", "drugs"."externallink", "drugs"."novelty", "drugs"."references" FROM "drugs" WHERE "drugs"."id" = 695
  177 similar queries.   Duplicated 177 times.
0.5858019567554328%
0.41

Connection: default

/usr/lib/python3.6/concurrent/futures/thread.py in _worker(69)
  work_item.run()
/usr/lib/python3.6/concurrent/futures/thread.py in run(56)
  result = self.fn(*self.args, **self.kwargs)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle(279)
  keepalive = self.handle_request(req, conn)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle_request(328)
  respiter = self.wsgi(environ, resp.start_response)
/home/protwis/gpcrdb_test/common/middleware/stats.py in __call__(34)
  response = self.get_response(request)
/home/protwis/gpcrdb_test/drugs/views.py in nhs_drug(423)
  queryname = i.drugname.name
  +
SELECT ••• "drugs"."id", "drugs"."name", "drugs"."synonym", "drugs"."drugtype", "drugs"."status", "drugs"."indication", "drugs"."approval", "drugs"."clinicalstatus", "drugs"."phasedate", "drugs"."phase", "drugs"."moa", "drugs"."targetlevel", "drugs"."externallink", "drugs"."novelty", "drugs"."references" FROM "drugs" WHERE "drugs"."id" = 695
  177 similar queries.   Duplicated 177 times.
0.56505055178326%
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/drugs/views.py in nhs_drug(423)
  queryname = i.drugname.name
  +
SELECT ••• "drugs"."id", "drugs"."name", "drugs"."synonym", "drugs"."drugtype", "drugs"."status", "drugs"."indication", "drugs"."approval", "drugs"."clinicalstatus", "drugs"."phasedate", "drugs"."phase", "drugs"."moa", "drugs"."targetlevel", "drugs"."externallink", "drugs"."novelty", "drugs"."references" FROM "drugs" WHERE "drugs"."id" = 695
  177 similar queries.   Duplicated 177 times.
0.5677720475173155%
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/drugs/views.py in nhs_drug(423)
  queryname = i.drugname.name
  +
SELECT ••• "drugs"."id", "drugs"."name", "drugs"."synonym", "drugs"."drugtype", "drugs"."status", "drugs"."indication", "drugs"."approval", "drugs"."clinicalstatus", "drugs"."phasedate", "drugs"."phase", "drugs"."moa", "drugs"."targetlevel", "drugs"."externallink", "drugs"."novelty", "drugs"."references" FROM "drugs" WHERE "drugs"."id" = 695
  177 similar queries.   Duplicated 177 times.
0.5647103648165032%
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/drugs/views.py in nhs_drug(423)
  queryname = i.drugname.name
  +
SELECT ••• "drugs"."id", "drugs"."name", "drugs"."synonym", "drugs"."drugtype", "drugs"."status", "drugs"."indication", "drugs"."approval", "drugs"."clinicalstatus", "drugs"."phasedate", "drugs"."phase", "drugs"."moa", "drugs"."targetlevel", "drugs"."externallink", "drugs"."novelty", "drugs"."references" FROM "drugs" WHERE "drugs"."id" = 695
  177 similar queries.   Duplicated 177 times.
0.5640299908829893%
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/drugs/views.py in nhs_drug(423)
  queryname = i.drugname.name
  +
SELECT ••• "drugs"."id", "drugs"."name", "drugs"."synonym", "drugs"."drugtype", "drugs"."status", "drugs"."indication", "drugs"."approval", "drugs"."clinicalstatus", "drugs"."phasedate", "drugs"."phase", "drugs"."moa", "drugs"."targetlevel", "drugs"."externallink", "drugs"."novelty", "drugs"."references" FROM "drugs" WHERE "drugs"."id" = 695
  177 similar queries.   Duplicated 177 times.
0.49020941909673554%
0.34

Connection: default

/usr/lib/python3.6/concurrent/futures/thread.py in _worker(69)
  work_item.run()
/usr/lib/python3.6/concurrent/futures/thread.py in run(56)
  result = self.fn(*self.args, **self.kwargs)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle(279)
  keepalive = self.handle_request(req, conn)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle_request(328)
  respiter = self.wsgi(environ, resp.start_response)
/home/protwis/gpcrdb_test/common/middleware/stats.py in __call__(34)
  response = self.get_response(request)
/home/protwis/gpcrdb_test/drugs/views.py in nhs_drug(423)
  queryname = i.drugname.name
  +
SELECT ••• "drugs"."id", "drugs"."name", "drugs"."synonym", "drugs"."drugtype", "drugs"."status", "drugs"."indication", "drugs"."approval", "drugs"."clinicalstatus", "drugs"."phasedate", "drugs"."phase", "drugs"."moa", "drugs"."targetlevel", "drugs"."externallink", "drugs"."novelty", "drugs"."references" FROM "drugs" WHERE "drugs"."id" = 695
  177 similar queries.   Duplicated 177 times.
0.483405679761597%
0.34

Connection: default

/usr/lib/python3.6/concurrent/futures/thread.py in _worker(69)
  work_item.run()
/usr/lib/python3.6/concurrent/futures/thread.py in run(56)
  result = self.fn(*self.args, **self.kwargs)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle(279)
  keepalive = self.handle_request(req, conn)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle_request(328)
  respiter = self.wsgi(environ, resp.start_response)
/home/protwis/gpcrdb_test/common/middleware/stats.py in __call__(34)
  response = self.get_response(request)
/home/protwis/gpcrdb_test/drugs/views.py in nhs_drug(423)
  queryname = i.drugname.name
  +
SELECT ••• "drugs"."id", "drugs"."name", "drugs"."synonym", "drugs"."drugtype", "drugs"."status", "drugs"."indication", "drugs"."approval", "drugs"."clinicalstatus", "drugs"."phasedate", "drugs"."phase", "drugs"."moa", "drugs"."targetlevel", "drugs"."externallink", "drugs"."novelty", "drugs"."references" FROM "drugs" WHERE "drugs"."id" = 695
  177 similar queries.   Duplicated 177 times.
0.584441208888405%
0.41

Connection: default

/usr/lib/python3.6/concurrent/futures/thread.py in _worker(69)
  work_item.run()
/usr/lib/python3.6/concurrent/futures/thread.py in run(56)
  result = self.fn(*self.args, **self.kwargs)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle(279)
  keepalive = self.handle_request(req, conn)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle_request(328)
  respiter = self.wsgi(environ, resp.start_response)
/home/protwis/gpcrdb_test/common/middleware/stats.py in __call__(34)
  response = self.get_response(request)
/home/protwis/gpcrdb_test/drugs/views.py in nhs_drug(423)
  queryname = i.drugname.name
  +
SELECT ••• "drugs"."id", "drugs"."name", "drugs"."synonym", "drugs"."drugtype", "drugs"."status", "drugs"."indication", "drugs"."approval", "drugs"."clinicalstatus", "drugs"."phasedate", "drugs"."phase", "drugs"."moa", "drugs"."targetlevel", "drugs"."externallink", "drugs"."novelty", "drugs"."references" FROM "drugs" WHERE "drugs"."id" = 695
  177 similar queries.   Duplicated 177 times.
0.5674318605505586%
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/drugs/views.py in nhs_drug(423)
  queryname = i.drugname.name
  +
SELECT ••• "drugs"."id", "drugs"."name", "drugs"."synonym", "drugs"."drugtype", "drugs"."status", "drugs"."indication", "drugs"."approval", "drugs"."clinicalstatus", "drugs"."phasedate", "drugs"."phase", "drugs"."moa", "drugs"."targetlevel", "drugs"."externallink", "drugs"."novelty", "drugs"."references" FROM "drugs" WHERE "drugs"."id" = 695
  177 similar queries.   Duplicated 177 times.
0.49939446719917263%
0.35

Connection: default

/usr/lib/python3.6/concurrent/futures/thread.py in _worker(69)
  work_item.run()
/usr/lib/python3.6/concurrent/futures/thread.py in run(56)
  result = self.fn(*self.args, **self.kwargs)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle(279)
  keepalive = self.handle_request(req, conn)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle_request(328)
  respiter = self.wsgi(environ, resp.start_response)
/home/protwis/gpcrdb_test/common/middleware/stats.py in __call__(34)
  response = self.get_response(request)
/home/protwis/gpcrdb_test/drugs/views.py in nhs_drug(423)
  queryname = i.drugname.name
  +
SELECT ••• "drugs"."id", "drugs"."name", "drugs"."synonym", "drugs"."drugtype", "drugs"."status", "drugs"."indication", "drugs"."approval", "drugs"."clinicalstatus", "drugs"."phasedate", "drugs"."phase", "drugs"."moa", "drugs"."targetlevel", "drugs"."externallink", "drugs"."novelty", "drugs"."references" FROM "drugs" WHERE "drugs"."id" = 695
  177 similar queries.   Duplicated 177 times.
0.4861271754956524%
0.34

Connection: default

/usr/lib/python3.6/concurrent/futures/thread.py in _worker(69)
  work_item.run()
/usr/lib/python3.6/concurrent/futures/thread.py in run(56)
  result = self.fn(*self.args, **self.kwargs)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle(279)
  keepalive = self.handle_request(req, conn)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle_request(328)
  respiter = self.wsgi(environ, resp.start_response)
/home/protwis/gpcrdb_test/common/middleware/stats.py in __call__(34)
  response = self.get_response(request)
/home/protwis/gpcrdb_test/drugs/views.py in nhs_drug(423)
  queryname = i.drugname.name
  +
SELECT ••• "drugs"."id", "drugs"."name", "drugs"."synonym", "drugs"."drugtype", "drugs"."status", "drugs"."indication", "drugs"."approval", "drugs"."clinicalstatus", "drugs"."phasedate", "drugs"."phase", "drugs"."moa", "drugs"."targetlevel", "drugs"."externallink", "drugs"."novelty", "drugs"."references" FROM "drugs" WHERE "drugs"."id" = 695
  177 similar queries.   Duplicated 177 times.
0.45823184422158425%
0.32

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/drugs/views.py in nhs_drug(423)
  queryname = i.drugname.name
  +
SELECT ••• "drugs"."id", "drugs"."name", "drugs"."synonym", "drugs"."drugtype", "drugs"."status", "drugs"."indication", "drugs"."approval", "drugs"."clinicalstatus", "drugs"."phasedate", "drugs"."phase", "drugs"."moa", "drugs"."targetlevel", "drugs"."externallink", "drugs"."novelty", "drugs"."references" FROM "drugs" WHERE "drugs"."id" = 695
  177 similar queries.   Duplicated 177 times.
0.48442624066186774%
0.34

Connection: default

/usr/lib/python3.6/concurrent/futures/thread.py in _worker(69)
  work_item.run()
/usr/lib/python3.6/concurrent/futures/thread.py in run(56)
  result = self.fn(*self.args, **self.kwargs)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle(279)
  keepalive = self.handle_request(req, conn)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle_request(328)
  respiter = self.wsgi(environ, resp.start_response)
/home/protwis/gpcrdb_test/common/middleware/stats.py in __call__(34)
  response = self.get_response(request)
/home/protwis/gpcrdb_test/drugs/views.py in nhs_drug(423)
  queryname = i.drugname.name
  +
SELECT ••• "drugs"."id", "drugs"."name", "drugs"."synonym", "drugs"."drugtype", "drugs"."status", "drugs"."indication", "drugs"."approval", "drugs"."clinicalstatus", "drugs"."phasedate", "drugs"."phase", "drugs"."moa", "drugs"."targetlevel", "drugs"."externallink", "drugs"."novelty", "drugs"."references" FROM "drugs" WHERE "drugs"."id" = 695
  177 similar queries.   Duplicated 177 times.
0.5725346650519125%
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/drugs/views.py in nhs_drug(423)
  queryname = i.drugname.name
  +
SELECT ••• "drugs"."id", "drugs"."name", "drugs"."synonym", "drugs"."drugtype", "drugs"."status", "drugs"."indication", "drugs"."approval", "drugs"."clinicalstatus", "drugs"."phasedate", "drugs"."phase", "drugs"."moa", "drugs"."targetlevel", "drugs"."externallink", "drugs"."novelty", "drugs"."references" FROM "drugs" WHERE "drugs"."id" = 695
  177 similar queries.   Duplicated 177 times.
0.4766019404264583%
0.33

Connection: default

/usr/lib/python3.6/concurrent/futures/thread.py in _worker(69)
  work_item.run()
/usr/lib/python3.6/concurrent/futures/thread.py in run(56)
  result = self.fn(*self.args, **self.kwargs)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle(279)
  keepalive = self.handle_request(req, conn)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle_request(328)
  respiter = self.wsgi(environ, resp.start_response)
/home/protwis/gpcrdb_test/common/middleware/stats.py in __call__(34)
  response = self.get_response(request)
/home/protwis/gpcrdb_test/drugs/views.py in nhs_drug(423)
  queryname = i.drugname.name
  +
SELECT ••• "drugs"."id", "drugs"."name", "drugs"."synonym", "drugs"."drugtype", "drugs"."status", "drugs"."indication", "drugs"."approval", "drugs"."clinicalstatus", "drugs"."phasedate", "drugs"."phase", "drugs"."moa", "drugs"."targetlevel", "drugs"."externallink", "drugs"."novelty", "drugs"."references" FROM "drugs" WHERE "drugs"."id" = 695
  177 similar queries.   Duplicated 177 times.
0.5681122344840724%
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/drugs/views.py in nhs_drug(423)
  queryname = i.drugname.name
  +
SELECT ••• "drugs"."id", "drugs"."name", "drugs"."synonym", "drugs"."drugtype", "drugs"."status", "drugs"."indication", "drugs"."approval", "drugs"."clinicalstatus", "drugs"."phasedate", "drugs"."phase", "drugs"."moa", "drugs"."targetlevel", "drugs"."externallink", "drugs"."novelty", "drugs"."references" FROM "drugs" WHERE "drugs"."id" = 695
  177 similar queries.   Duplicated 177 times.
0.4466654873518485%
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/drugs/views.py in nhs_drug(423)
  queryname = i.drugname.name
  +
SELECT ••• "drugs"."id", "drugs"."name", "drugs"."synonym", "drugs"."drugtype", "drugs"."status", "drugs"."indication", "drugs"."approval", "drugs"."clinicalstatus", "drugs"."phasedate", "drugs"."phase", "drugs"."moa", "drugs"."targetlevel", "drugs"."externallink", "drugs"."novelty", "drugs"."references" FROM "drugs" WHERE "drugs"."id" = 695
  177 similar queries.   Duplicated 177 times.
0.48816829729619404%
0.34

Connection: default

/usr/lib/python3.6/concurrent/futures/thread.py in _worker(69)
  work_item.run()
/usr/lib/python3.6/concurrent/futures/thread.py in run(56)
  result = self.fn(*self.args, **self.kwargs)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle(279)
  keepalive = self.handle_request(req, conn)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle_request(328)
  respiter = self.wsgi(environ, resp.start_response)
/home/protwis/gpcrdb_test/common/middleware/stats.py in __call__(34)
  response = self.get_response(request)
/home/protwis/gpcrdb_test/drugs/views.py in nhs_drug(423)
  queryname = i.drugname.name
  +
SELECT ••• "drugs"."id", "drugs"."name", "drugs"."synonym", "drugs"."drugtype", "drugs"."status", "drugs"."indication", "drugs"."approval", "drugs"."clinicalstatus", "drugs"."phasedate", "drugs"."phase", "drugs"."moa", "drugs"."targetlevel", "drugs"."externallink", "drugs"."novelty", "drugs"."references" FROM "drugs" WHERE "drugs"."id" = 695
  177 similar queries.   Duplicated 177 times.
0.41604866034372495%
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/drugs/views.py in nhs_drug(423)
  queryname = i.drugname.name
  +
SELECT ••• "drugs"."id", "drugs"."name", "drugs"."synonym", "drugs"."drugtype", "drugs"."status", "drugs"."indication", "drugs"."approval", "drugs"."clinicalstatus", "drugs"."phasedate", "drugs"."phase", "drugs"."moa", "drugs"."targetlevel", "drugs"."externallink", "drugs"."novelty", "drugs"."references" FROM "drugs" WHERE "drugs"."id" = 695
  177 similar queries.   Duplicated 177 times.
0.4885084842629509%
0.34

Connection: default

/usr/lib/python3.6/concurrent/futures/thread.py in _worker(69)
  work_item.run()
/usr/lib/python3.6/concurrent/futures/thread.py in run(56)
  result = self.fn(*self.args, **self.kwargs)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle(279)
  keepalive = self.handle_request(req, conn)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle_request(328)
  respiter = self.wsgi(environ, resp.start_response)
/home/protwis/gpcrdb_test/common/middleware/stats.py in __call__(34)
  response = self.get_response(request)
/home/protwis/gpcrdb_test/drugs/views.py in nhs_drug(423)
  queryname = i.drugname.name
  +
SELECT ••• "drugs"."id", "drugs"."name", "drugs"."synonym", "drugs"."drugtype", "drugs"."status", "drugs"."indication", "drugs"."approval", "drugs"."clinicalstatus", "drugs"."phasedate", "drugs"."phase", "drugs"."moa", "drugs"."targetlevel", "drugs"."externallink", "drugs"."novelty", "drugs"."references" FROM "drugs" WHERE "drugs"."id" = 695
  177 similar queries.   Duplicated 177 times.
0.5885234524894882%
0.41

Connection: default

/usr/lib/python3.6/concurrent/futures/thread.py in _worker(69)
  work_item.run()
/usr/lib/python3.6/concurrent/futures/thread.py in run(56)
  result = self.fn(*self.args, **self.kwargs)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle(279)
  keepalive = self.handle_request(req, conn)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle_request(328)
  respiter = self.wsgi(environ, resp.start_response)
/home/protwis/gpcrdb_test/common/middleware/stats.py in __call__(34)
  response = self.get_response(request)
/home/protwis/gpcrdb_test/drugs/views.py in nhs_drug(423)
  queryname = i.drugname.name
  +
SELECT ••• "drugs"."id", "drugs"."name", "drugs"."synonym", "drugs"."drugtype", "drugs"."status", "drugs"."indication", "drugs"."approval", "drugs"."clinicalstatus", "drugs"."phasedate", "drugs"."phase", "drugs"."moa", "drugs"."targetlevel", "drugs"."externallink", "drugs"."novelty", "drugs"."references" FROM "drugs" WHERE "drugs"."id" = 695
  177 similar queries.   Duplicated 177 times.
0.5956673787913838%
0.42

Connection: default

/usr/lib/python3.6/concurrent/futures/thread.py in _worker(69)
  work_item.run()
/usr/lib/python3.6/concurrent/futures/thread.py in run(56)
  result = self.fn(*self.args, **self.kwargs)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle(279)
  keepalive = self.handle_request(req, conn)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle_request(328)
  respiter = self.wsgi(environ, resp.start_response)
/home/protwis/gpcrdb_test/common/middleware/stats.py in __call__(34)
  response = self.get_response(request)
/home/protwis/gpcrdb_test/drugs/views.py in nhs_drug(423)
  queryname = i.drugname.name
  +
SELECT ••• "drugs"."id", "drugs"."name", "drugs"."synonym", "drugs"."drugtype", "drugs"."status", "drugs"."indication", "drugs"."approval", "drugs"."clinicalstatus", "drugs"."phasedate", "drugs"."phase", "drugs"."moa", "drugs"."targetlevel", "drugs"."externallink", "drugs"."novelty", "drugs"."references" FROM "drugs" WHERE "drugs"."id" = 695
  177 similar queries.   Duplicated 177 times.
0.5198056852045885%
0.36

Connection: default

/usr/lib/python3.6/concurrent/futures/thread.py in _worker(69)
  work_item.run()
/usr/lib/python3.6/concurrent/futures/thread.py in run(56)
  result = self.fn(*self.args, **self.kwargs)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle(279)
  keepalive = self.handle_request(req, conn)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle_request(328)
  respiter = self.wsgi(environ, resp.start_response)
/home/protwis/gpcrdb_test/common/middleware/stats.py in __call__(34)
  response = self.get_response(request)
/home/protwis/gpcrdb_test/drugs/views.py in nhs_drug(423)
  queryname = i.drugname.name
  +
SELECT ••• "drugs"."id", "drugs"."name", "drugs"."synonym", "drugs"."drugtype", "drugs"."status", "drugs"."indication", "drugs"."approval", "drugs"."clinicalstatus", "drugs"."phasedate", "drugs"."phase", "drugs"."moa", "drugs"."targetlevel", "drugs"."externallink", "drugs"."novelty", "drugs"."references" FROM "drugs" WHERE "drugs"."id" = 695
  177 similar queries.   Duplicated 177 times.
0.49939446719917263%
0.35

Connection: default

/usr/lib/python3.6/concurrent/futures/thread.py in _worker(69)
  work_item.run()
/usr/lib/python3.6/concurrent/futures/thread.py in run(56)
  result = self.fn(*self.args, **self.kwargs)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle(279)
  keepalive = self.handle_request(req, conn)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle_request(328)
  respiter = self.wsgi(environ, resp.start_response)
/home/protwis/gpcrdb_test/common/middleware/stats.py in __call__(34)
  response = self.get_response(request)
/home/protwis/gpcrdb_test/drugs/views.py in nhs_drug(423)
  queryname = i.drugname.name
  +
SELECT ••• "drugs"."id", "drugs"."name", "drugs"."synonym", "drugs"."drugtype", "drugs"."status", "drugs"."indication", "drugs"."approval", "drugs"."clinicalstatus", "drugs"."phasedate", "drugs"."phase", "drugs"."moa", "drugs"."targetlevel", "drugs"."externallink", "drugs"."novelty", "drugs"."references" FROM "drugs" WHERE "drugs"."id" = 695
  177 similar queries.   Duplicated 177 times.
0.5738954129189402%
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/drugs/views.py in nhs_drug(423)
  queryname = i.drugname.name
  +
SELECT ••• "drugs"."id", "drugs"."name", "drugs"."synonym", "drugs"."drugtype", "drugs"."status", "drugs"."indication", "drugs"."approval", "drugs"."clinicalstatus", "drugs"."phasedate", "drugs"."phase", "drugs"."moa", "drugs"."targetlevel", "drugs"."externallink", "drugs"."novelty", "drugs"."references" FROM "drugs" WHERE "drugs"."id" = 695
  177 similar queries.   Duplicated 177 times.
0.4742206316591599%
0.33

Connection: default

/usr/lib/python3.6/concurrent/futures/thread.py in _worker(69)
  work_item.run()
/usr/lib/python3.6/concurrent/futures/thread.py in run(56)
  result = self.fn(*self.args, **self.kwargs)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle(279)
  keepalive = self.handle_request(req, conn)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle_request(328)
  respiter = self.wsgi(environ, resp.start_response)
/home/protwis/gpcrdb_test/common/middleware/stats.py in __call__(34)
  response = self.get_response(request)
/home/protwis/gpcrdb_test/drugs/views.py in nhs_drug(423)
  queryname = i.drugname.name
  +
SELECT ••• "drugs"."id", "drugs"."name", "drugs"."synonym", "drugs"."drugtype", "drugs"."status", "drugs"."indication", "drugs"."approval", "drugs"."clinicalstatus", "drugs"."phasedate", "drugs"."phase", "drugs"."moa", "drugs"."targetlevel", "drugs"."externallink", "drugs"."novelty", "drugs"."references" FROM "drugs" WHERE "drugs"."id" = 695
  177 similar queries.   Duplicated 177 times.
0.5609683081821769%
0.39

Connection: default

/usr/lib/python3.6/concurrent/futures/thread.py in _worker(69)
  work_item.run()
/usr/lib/python3.6/concurrent/futures/thread.py in run(56)
  result = self.fn(*self.args, **self.kwargs)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle(279)
  keepalive = self.handle_request(req, conn)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle_request(328)
  respiter = self.wsgi(environ, resp.start_response)
/home/protwis/gpcrdb_test/common/middleware/stats.py in __call__(34)
  response = self.get_response(request)
/home/protwis/gpcrdb_test/drugs/views.py in nhs_drug(423)
  queryname = i.drugname.name
  +
SELECT ••• "drugs"."id", "drugs"."name", "drugs"."synonym", "drugs"."drugtype", "drugs"."status", "drugs"."indication", "drugs"."approval", "drugs"."clinicalstatus", "drugs"."phasedate", "drugs"."phase", "drugs"."moa", "drugs"."targetlevel", "drugs"."externallink", "drugs"."novelty", "drugs"."references" FROM "drugs" WHERE "drugs"."id" = 695
  177 similar queries.   Duplicated 177 times.
0.5922655091238145%
0.42

Connection: default

/usr/lib/python3.6/concurrent/futures/thread.py in _worker(69)
  work_item.run()
/usr/lib/python3.6/concurrent/futures/thread.py in run(56)
  result = self.fn(*self.args, **self.kwargs)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle(279)
  keepalive = self.handle_request(req, conn)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle_request(328)
  respiter = self.wsgi(environ, resp.start_response)
/home/protwis/gpcrdb_test/common/middleware/stats.py in __call__(34)
  response = self.get_response(request)
/home/protwis/gpcrdb_test/drugs/views.py in nhs_drug(423)
  queryname = i.drugname.name
  +
SELECT ••• "drugs"."id", "drugs"."name", "drugs"."synonym", "drugs"."drugtype", "drugs"."status", "drugs"."indication", "drugs"."approval", "drugs"."clinicalstatus", "drugs"."phasedate", "drugs"."phase", "drugs"."moa", "drugs"."targetlevel", "drugs"."externallink", "drugs"."novelty", "drugs"."references" FROM "drugs" WHERE "drugs"."id" = 695
  177 similar queries.   Duplicated 177 times.
0.4936112887643049%
0.35

Connection: default

/usr/lib/python3.6/concurrent/futures/thread.py in _worker(69)
  work_item.run()
/usr/lib/python3.6/concurrent/futures/thread.py in run(56)
  result = self.fn(*self.args, **self.kwargs)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle(279)
  keepalive = self.handle_request(req, conn)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle_request(328)
  respiter = self.wsgi(environ, resp.start_response)
/home/protwis/gpcrdb_test/common/middleware/stats.py in __call__(34)
  response = self.get_response(request)
/home/protwis/gpcrdb_test/drugs/views.py in nhs_drug(423)
  queryname = i.drugname.name
  +
SELECT ••• "drugs"."id", "drugs"."name", "drugs"."synonym", "drugs"."drugtype", "drugs"."status", "drugs"."indication", "drugs"."approval", "drugs"."clinicalstatus", "drugs"."phasedate", "drugs"."phase", "drugs"."moa", "drugs"."targetlevel", "drugs"."externallink", "drugs"."novelty", "drugs"."references" FROM "drugs" WHERE "drugs"."id" = 695
  177 similar queries.   Duplicated 177 times.
0.5755963477527248%
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/drugs/views.py in nhs_drug(423)
  queryname = i.drugname.name
  +
SELECT ••• "drugs"."id", "drugs"."name", "drugs"."synonym", "drugs"."drugtype", "drugs"."status", "drugs"."indication", "drugs"."approval", "drugs"."clinicalstatus", "drugs"."phasedate", "drugs"."phase", "drugs"."moa", "drugs"."targetlevel", "drugs"."externallink", "drugs"."novelty", "drugs"."references" FROM "drugs" WHERE "drugs"."id" = 695
  177 similar queries.   Duplicated 177 times.
0.48068418402754154%
0.34

Connection: default

/usr/lib/python3.6/concurrent/futures/thread.py in _worker(69)
  work_item.run()
/usr/lib/python3.6/concurrent/futures/thread.py in run(56)
  result = self.fn(*self.args, **self.kwargs)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle(279)
  keepalive = self.handle_request(req, conn)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle_request(328)
  respiter = self.wsgi(environ, resp.start_response)
/home/protwis/gpcrdb_test/common/middleware/stats.py in __call__(34)
  response = self.get_response(request)
/home/protwis/gpcrdb_test/drugs/views.py in nhs_drug(423)
  queryname = i.drugname.name
  +
SELECT ••• "drugs"."id", "drugs"."name", "drugs"."synonym", "drugs"."drugtype", "drugs"."status", "drugs"."indication", "drugs"."approval", "drugs"."clinicalstatus", "drugs"."phasedate", "drugs"."phase", "drugs"."moa", "drugs"."targetlevel", "drugs"."externallink", "drugs"."novelty", "drugs"."references" FROM "drugs" WHERE "drugs"."id" = 695
  177 similar queries.   Duplicated 177 times.
0.5647103648165032%
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/drugs/views.py in nhs_drug(423)
  queryname = i.drugname.name
  +
SELECT ••• "drugs"."id", "drugs"."name", "drugs"."synonym", "drugs"."drugtype", "drugs"."status", "drugs"."indication", "drugs"."approval", "drugs"."clinicalstatus", "drugs"."phasedate", "drugs"."phase", "drugs"."moa", "drugs"."targetlevel", "drugs"."externallink", "drugs"."novelty", "drugs"."references" FROM "drugs" WHERE "drugs"."id" = 695
  177 similar queries.   Duplicated 177 times.
0.5609683081821769%
0.39

Connection: default

/usr/lib/python3.6/concurrent/futures/thread.py in _worker(69)
  work_item.run()
/usr/lib/python3.6/concurrent/futures/thread.py in run(56)
  result = self.fn(*self.args, **self.kwargs)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle(279)
  keepalive = self.handle_request(req, conn)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle_request(328)
  respiter = self.wsgi(environ, resp.start_response)
/home/protwis/gpcrdb_test/common/middleware/stats.py in __call__(34)
  response = self.get_response(request)
/home/protwis/gpcrdb_test/drugs/views.py in nhs_drug(423)
  queryname = i.drugname.name
  +
SELECT ••• "drugs"."id", "drugs"."name", "drugs"."synonym", "drugs"."drugtype", "drugs"."status", "drugs"."indication", "drugs"."approval", "drugs"."clinicalstatus", "drugs"."phasedate", "drugs"."phase", "drugs"."moa", "drugs"."targetlevel", "drugs"."externallink", "drugs"."novelty", "drugs"."references" FROM "drugs" WHERE "drugs"."id" = 695
  177 similar queries.   Duplicated 177 times.
0.5813795261875927%
0.41

Connection: default

/usr/lib/python3.6/concurrent/futures/thread.py in _worker(69)
  work_item.run()
/usr/lib/python3.6/concurrent/futures/thread.py in run(56)
  result = self.fn(*self.args, **self.kwargs)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle(279)
  keepalive = self.handle_request(req, conn)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle_request(328)
  respiter = self.wsgi(environ, resp.start_response)
/home/protwis/gpcrdb_test/common/middleware/stats.py in __call__(34)
  response = self.get_response(request)
/home/protwis/gpcrdb_test/drugs/views.py in nhs_drug(423)
  queryname = i.drugname.name
  +
SELECT ••• "drugs"."id", "drugs"."name", "drugs"."synonym", "drugs"."drugtype", "drugs"."status", "drugs"."indication", "drugs"."approval", "drugs"."clinicalstatus", "drugs"."phasedate", "drugs"."phase", "drugs"."moa", "drugs"."targetlevel", "drugs"."externallink", "drugs"."novelty", "drugs"."references" FROM "drugs" WHERE "drugs"."id" = 695
  177 similar queries.   Duplicated 177 times.
0.5684524214508294%
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/drugs/views.py in nhs_drug(423)
  queryname = i.drugname.name
  +
SELECT ••• "drugs"."id", "drugs"."name", "drugs"."synonym", "drugs"."drugtype", "drugs"."status", "drugs"."indication", "drugs"."approval", "drugs"."clinicalstatus", "drugs"."phasedate", "drugs"."phase", "drugs"."moa", "drugs"."targetlevel", "drugs"."externallink", "drugs"."novelty", "drugs"."references" FROM "drugs" WHERE "drugs"."id" = 695
  177 similar queries.   Duplicated 177 times.
0.5010954020329573%
0.35

Connection: default

/usr/lib/python3.6/concurrent/futures/thread.py in _worker(69)
  work_item.run()
/usr/lib/python3.6/concurrent/futures/thread.py in run(56)
  result = self.fn(*self.args, **self.kwargs)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle(279)
  keepalive = self.handle_request(req, conn)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle_request(328)
  respiter = self.wsgi(environ, resp.start_response)
/home/protwis/gpcrdb_test/common/middleware/stats.py in __call__(34)
  response = self.get_response(request)
/home/protwis/gpcrdb_test/drugs/views.py in nhs_drug(423)
  queryname = i.drugname.name
  +
SELECT ••• "drugs"."id", "drugs"."name", "drugs"."synonym", "drugs"."drugtype", "drugs"."status", "drugs"."indication", "drugs"."approval", "drugs"."clinicalstatus", "drugs"."phasedate", "drugs"."phase", "drugs"."moa", "drugs"."targetlevel", "drugs"."externallink", "drugs"."novelty", "drugs"."references" FROM "drugs" WHERE "drugs"."id" = 695
  177 similar queries.   Duplicated 177 times.
0.5793384043870511%
0.41

Connection: default

/usr/lib/python3.6/concurrent/futures/thread.py in _worker(69)
  work_item.run()
/usr/lib/python3.6/concurrent/futures/thread.py in run(56)
  result = self.fn(*self.args, **self.kwargs)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle(279)
  keepalive = self.handle_request(req, conn)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle_request(328)
  respiter = self.wsgi(environ, resp.start_response)
/home/protwis/gpcrdb_test/common/middleware/stats.py in __call__(34)
  response = self.get_response(request)
/home/protwis/gpcrdb_test/drugs/views.py in nhs_drug(423)
  queryname = i.drugname.name
  +
SELECT ••• "drugs"."id", "drugs"."name", "drugs"."synonym", "drugs"."drugtype", "drugs"."status", "drugs"."indication", "drugs"."approval", "drugs"."clinicalstatus", "drugs"."phasedate", "drugs"."phase", "drugs"."moa", "drugs"."targetlevel", "drugs"."externallink", "drugs"."novelty", "drugs"."references" FROM "drugs" WHERE "drugs"."id" = 695
  177 similar queries.   Duplicated 177 times.
0.48442624066186774%
0.34

Connection: default

/usr/lib/python3.6/concurrent/futures/thread.py in _worker(69)
  work_item.run()
/usr/lib/python3.6/concurrent/futures/thread.py in run(56)
  result = self.fn(*self.args, **self.kwargs)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle(279)
  keepalive = self.handle_request(req, conn)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle_request(328)
  respiter = self.wsgi(environ, resp.start_response)
/home/protwis/gpcrdb_test/common/middleware/stats.py in __call__(34)
  response = self.get_response(request)
/home/protwis/gpcrdb_test/drugs/views.py in nhs_drug(423)
  queryname = i.drugname.name
  +
SELECT ••• "drugs"."id", "drugs"."name", "drugs"."synonym", "drugs"."drugtype", "drugs"."status", "drugs"."indication", "drugs"."approval", "drugs"."clinicalstatus", "drugs"."phasedate", "drugs"."phase", "drugs"."moa", "drugs"."targetlevel", "drugs"."externallink", "drugs"."novelty", "drugs"."references" FROM "drugs" WHERE "drugs"."id" = 695
  177 similar queries.   Duplicated 177 times.
0.5830804610213773%
0.41

Connection: default

/usr/lib/python3.6/concurrent/futures/thread.py in _worker(69)
  work_item.run()
/usr/lib/python3.6/concurrent/futures/thread.py in run(56)
  result = self.fn(*self.args, **self.kwargs)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle(279)
  keepalive = self.handle_request(req, conn)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle_request(328)
  respiter = self.wsgi(environ, resp.start_response)
/home/protwis/gpcrdb_test/common/middleware/stats.py in __call__(34)
  response = self.get_response(request)
/home/protwis/gpcrdb_test/drugs/views.py in nhs_drug(423)
  queryname = i.drugname.name
  +
SELECT ••• "drugs"."id", "drugs"."name", "drugs"."synonym", "drugs"."drugtype", "drugs"."status", "drugs"."indication", "drugs"."approval", "drugs"."clinicalstatus", "drugs"."phasedate", "drugs"."phase", "drugs"."moa", "drugs"."targetlevel", "drugs"."externallink", "drugs"."novelty", "drugs"."references" FROM "drugs" WHERE "drugs"."id" = 695
  177 similar queries.   Duplicated 177 times.
0.5932860700240852%
0.42

Connection: default

/usr/lib/python3.6/concurrent/futures/thread.py in _worker(69)
  work_item.run()
/usr/lib/python3.6/concurrent/futures/thread.py in run(56)
  result = self.fn(*self.args, **self.kwargs)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle(279)
  keepalive = self.handle_request(req, conn)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle_request(328)
  respiter = self.wsgi(environ, resp.start_response)
/home/protwis/gpcrdb_test/common/middleware/stats.py in __call__(34)
  response = self.get_response(request)
/home/protwis/gpcrdb_test/drugs/views.py in nhs_drug(423)
  queryname = i.drugname.name
  +
SELECT ••• "drugs"."id", "drugs"."name", "drugs"."synonym", "drugs"."drugtype", "drugs"."status", "drugs"."indication", "drugs"."approval", "drugs"."clinicalstatus", "drugs"."phasedate", "drugs"."phase", "drugs"."moa", "drugs"."targetlevel", "drugs"."externallink", "drugs"."novelty", "drugs"."references" FROM "drugs" WHERE "drugs"."id" = 695
  177 similar queries.   Duplicated 177 times.
0.49497203663133255%
0.35

Connection: default

/usr/lib/python3.6/concurrent/futures/thread.py in _worker(69)
  work_item.run()
/usr/lib/python3.6/concurrent/futures/thread.py in run(56)
  result = self.fn(*self.args, **self.kwargs)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle(279)
  keepalive = self.handle_request(req, conn)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle_request(328)
  respiter = self.wsgi(environ, resp.start_response)
/home/protwis/gpcrdb_test/common/middleware/stats.py in __call__(34)
  response = self.get_response(request)
/home/protwis/gpcrdb_test/drugs/views.py in nhs_drug(423)
  queryname = i.drugname.name
  +
SELECT ••• "drugs"."id", "drugs"."name", "drugs"."synonym", "drugs"."drugtype", "drugs"."status", "drugs"."indication", "drugs"."approval", "drugs"."clinicalstatus", "drugs"."phasedate", "drugs"."phase", "drugs"."moa", "drugs"."targetlevel", "drugs"."externallink", "drugs"."novelty", "drugs"."references" FROM "drugs" WHERE "drugs"."id" = 695
  177 similar queries.   Duplicated 177 times.
0.4112860428091279%
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/drugs/views.py in nhs_drug(423)
  queryname = i.drugname.name
  +
SELECT ••• "drugs"."id", "drugs"."name", "drugs"."synonym", "drugs"."drugtype", "drugs"."status", "drugs"."indication", "drugs"."approval", "drugs"."clinicalstatus", "drugs"."phasedate", "drugs"."phase", "drugs"."moa", "drugs"."targetlevel", "drugs"."externallink", "drugs"."novelty", "drugs"."references" FROM "drugs" WHERE "drugs"."id" = 695
  177 similar queries.   Duplicated 177 times.
0.40176080773993383%
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/drugs/views.py in nhs_drug(423)
  queryname = i.drugname.name
  +
SELECT ••• "drugs"."id", "drugs"."name", "drugs"."synonym", "drugs"."drugtype", "drugs"."status", "drugs"."indication", "drugs"."approval", "drugs"."clinicalstatus", "drugs"."phasedate", "drugs"."phase", "drugs"."moa", "drugs"."targetlevel", "drugs"."externallink", "drugs"."novelty", "drugs"."references" FROM "drugs" WHERE "drugs"."id" = 695
  177 similar queries.   Duplicated 177 times.
0.4891888581964648%
0.34

Connection: default

/usr/lib/python3.6/concurrent/futures/thread.py in _worker(69)
  work_item.run()
/usr/lib/python3.6/concurrent/futures/thread.py in run(56)
  result = self.fn(*self.args, **self.kwargs)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle(279)
  keepalive = self.handle_request(req, conn)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle_request(328)
  respiter = self.wsgi(environ, resp.start_response)
/home/protwis/gpcrdb_test/common/middleware/stats.py in __call__(34)
  response = self.get_response(request)
/home/protwis/gpcrdb_test/drugs/views.py in nhs_drug(423)
  queryname = i.drugname.name
  +
SELECT ••• "drugs"."id", "drugs"."name", "drugs"."synonym", "drugs"."drugtype", "drugs"."status", "drugs"."indication", "drugs"."approval", "drugs"."clinicalstatus", "drugs"."phasedate", "drugs"."phase", "drugs"."moa", "drugs"."targetlevel", "drugs"."externallink", "drugs"."novelty", "drugs"."references" FROM "drugs" WHERE "drugs"."id" = 695
  177 similar queries.   Duplicated 177 times.
0.5606281212154199%
0.39

Connection: default

/usr/lib/python3.6/concurrent/futures/thread.py in _worker(69)
  work_item.run()
/usr/lib/python3.6/concurrent/futures/thread.py in run(56)
  result = self.fn(*self.args, **self.kwargs)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle(279)
  keepalive = self.handle_request(req, conn)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle_request(328)
  respiter = self.wsgi(environ, resp.start_response)
/home/protwis/gpcrdb_test/common/middleware/stats.py in __call__(34)
  response = self.get_response(request)
/home/protwis/gpcrdb_test/drugs/views.py in nhs_drug(423)
  queryname = i.drugname.name
  +
SELECT ••• "drugs"."id", "drugs"."name", "drugs"."synonym", "drugs"."drugtype", "drugs"."status", "drugs"."indication", "drugs"."approval", "drugs"."clinicalstatus", "drugs"."phasedate", "drugs"."phase", "drugs"."moa", "drugs"."targetlevel", "drugs"."externallink", "drugs"."novelty", "drugs"."references" FROM "drugs" WHERE "drugs"."id" = 695
  177 similar queries.   Duplicated 177 times.
0.5909047612567868%
0.41

Connection: default

/usr/lib/python3.6/concurrent/futures/thread.py in _worker(69)
  work_item.run()
/usr/lib/python3.6/concurrent/futures/thread.py in run(56)
  result = self.fn(*self.args, **self.kwargs)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle(279)
  keepalive = self.handle_request(req, conn)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle_request(328)
  respiter = self.wsgi(environ, resp.start_response)
/home/protwis/gpcrdb_test/common/middleware/stats.py in __call__(34)
  response = self.get_response(request)
/home/protwis/gpcrdb_test/drugs/views.py in nhs_drug(423)
  queryname = i.drugname.name
  +
SELECT ••• "drugs"."id", "drugs"."name", "drugs"."synonym", "drugs"."drugtype", "drugs"."status", "drugs"."indication", "drugs"."approval", "drugs"."clinicalstatus", "drugs"."phasedate", "drugs"."phase", "drugs"."moa", "drugs"."targetlevel", "drugs"."externallink", "drugs"."novelty", "drugs"."references" FROM "drugs" WHERE "drugs"."id" = 695
  177 similar queries.   Duplicated 177 times.
0.5871627046224605%
0.41

Connection: default

/usr/lib/python3.6/concurrent/futures/thread.py in _worker(69)
  work_item.run()
/usr/lib/python3.6/concurrent/futures/thread.py in run(56)
  result = self.fn(*self.args, **self.kwargs)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle(279)
  keepalive = self.handle_request(req, conn)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle_request(328)
  respiter = self.wsgi(environ, resp.start_response)
/home/protwis/gpcrdb_test/common/middleware/stats.py in __call__(34)
  response = self.get_response(request)
/home/protwis/gpcrdb_test/drugs/views.py in nhs_drug(423)
  queryname = i.drugname.name
  +
SELECT ••• "drugs"."id", "drugs"."name", "drugs"."synonym", "drugs"."drugtype", "drugs"."status", "drugs"."indication", "drugs"."approval", "drugs"."clinicalstatus", "drugs"."phasedate", "drugs"."phase", "drugs"."moa", "drugs"."targetlevel", "drugs"."externallink", "drugs"."novelty", "drugs"."references" FROM "drugs" WHERE "drugs"."id" = 695
  177 similar queries.   Duplicated 177 times.
0.49803371933214496%
0.35

Connection: default

/usr/lib/python3.6/concurrent/futures/thread.py in _worker(69)
  work_item.run()
/usr/lib/python3.6/concurrent/futures/thread.py in run(56)
  result = self.fn(*self.args, **self.kwargs)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle(279)
  keepalive = self.handle_request(req, conn)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle_request(328)
  respiter = self.wsgi(environ, resp.start_response)
/home/protwis/gpcrdb_test/common/middleware/stats.py in __call__(34)
  response = self.get_response(request)
/home/protwis/gpcrdb_test/drugs/views.py in nhs_drug(423)
  queryname = i.drugname.name
  +
SELECT ••• "drugs"."id", "drugs"."name", "drugs"."synonym", "drugs"."drugtype", "drugs"."status", "drugs"."indication", "drugs"."approval", "drugs"."clinicalstatus", "drugs"."phasedate", "drugs"."phase", "drugs"."moa", "drugs"."targetlevel", "drugs"."externallink", "drugs"."novelty", "drugs"."references" FROM "drugs" WHERE "drugs"."id" = 695
  177 similar queries.   Duplicated 177 times.
0.4119664167426418%
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/drugs/views.py in nhs_drug(423)
  queryname = i.drugname.name
  +
SELECT ••• "drugs"."id", "drugs"."name", "drugs"."synonym", "drugs"."drugtype", "drugs"."status", "drugs"."indication", "drugs"."approval", "drugs"."clinicalstatus", "drugs"."phasedate", "drugs"."phase", "drugs"."moa", "drugs"."targetlevel", "drugs"."externallink", "drugs"."novelty", "drugs"."references" FROM "drugs" WHERE "drugs"."id" = 695
  177 similar queries.   Duplicated 177 times.
0.40890473404182937%
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/drugs/views.py in nhs_drug(423)
  queryname = i.drugname.name
  +
SELECT ••• "drugs"."id", "drugs"."name", "drugs"."synonym", "drugs"."drugtype", "drugs"."status", "drugs"."indication", "drugs"."approval", "drugs"."clinicalstatus", "drugs"."phasedate", "drugs"."phase", "drugs"."moa", "drugs"."targetlevel", "drugs"."externallink", "drugs"."novelty", "drugs"."references" FROM "drugs" WHERE "drugs"."id" = 695
  177 similar queries.   Duplicated 177 times.
0.39359632053776755%
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/drugs/views.py in nhs_drug(423)
  queryname = i.drugname.name
  +
SELECT ••• "drugs"."id", "drugs"."name", "drugs"."synonym", "drugs"."drugtype", "drugs"."status", "drugs"."indication", "drugs"."approval", "drugs"."clinicalstatus", "drugs"."phasedate", "drugs"."phase", "drugs"."moa", "drugs"."targetlevel", "drugs"."externallink", "drugs"."novelty", "drugs"."references" FROM "drugs" WHERE "drugs"."id" = 695
  177 similar queries.   Duplicated 177 times.
0.5670916735838016%
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/drugs/views.py in nhs_drug(423)
  queryname = i.drugname.name
  +
SELECT ••• "drugs"."id", "drugs"."name", "drugs"."synonym", "drugs"."drugtype", "drugs"."status", "drugs"."indication", "drugs"."approval", "drugs"."clinicalstatus", "drugs"."phasedate", "drugs"."phase", "drugs"."moa", "drugs"."targetlevel", "drugs"."externallink", "drugs"."novelty", "drugs"."references" FROM "drugs" WHERE "drugs"."id" = 695
  177 similar queries.   Duplicated 177 times.
0.5966879396916546%
0.42

Connection: default

/usr/lib/python3.6/concurrent/futures/thread.py in _worker(69)
  work_item.run()
/usr/lib/python3.6/concurrent/futures/thread.py in run(56)
  result = self.fn(*self.args, **self.kwargs)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle(279)
  keepalive = self.handle_request(req, conn)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle_request(328)
  respiter = self.wsgi(environ, resp.start_response)
/home/protwis/gpcrdb_test/common/middleware/stats.py in __call__(34)
  response = self.get_response(request)
/home/protwis/gpcrdb_test/drugs/views.py in nhs_drug(423)
  queryname = i.drugname.name
  +
SELECT ••• "drugs"."id", "drugs"."name", "drugs"."synonym", "drugs"."drugtype", "drugs"."status", "drugs"."indication", "drugs"."approval", "drugs"."clinicalstatus", "drugs"."phasedate", "drugs"."phase", "drugs"."moa", "drugs"."targetlevel", "drugs"."externallink", "drugs"."novelty", "drugs"."references" FROM "drugs" WHERE "drugs"."id" = 695
  177 similar queries.   Duplicated 177 times.
0.5667514866170448%
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/drugs/views.py in nhs_drug(423)
  queryname = i.drugname.name
  +
SELECT ••• "drugs"."id", "drugs"."name", "drugs"."synonym", "drugs"."drugtype", "drugs"."status", "drugs"."indication", "drugs"."approval", "drugs"."clinicalstatus", "drugs"."phasedate", "drugs"."phase", "drugs"."moa", "drugs"."targetlevel", "drugs"."externallink", "drugs"."novelty", "drugs"."references" FROM "drugs" WHERE "drugs"."id" = 695
  177 similar queries.   Duplicated 177 times.
0.4898692321299787%
0.34

Connection: default

/usr/lib/python3.6/concurrent/futures/thread.py in _worker(69)
  work_item.run()
/usr/lib/python3.6/concurrent/futures/thread.py in run(56)
  result = self.fn(*self.args, **self.kwargs)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle(279)
  keepalive = self.handle_request(req, conn)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle_request(328)
  respiter = self.wsgi(environ, resp.start_response)
/home/protwis/gpcrdb_test/common/middleware/stats.py in __call__(34)
  response = self.get_response(request)
/home/protwis/gpcrdb_test/drugs/views.py in nhs_drug(423)
  queryname = i.drugname.name
  +
SELECT ••• "drugs"."id", "drugs"."name", "drugs"."synonym", "drugs"."drugtype", "drugs"."status", "drugs"."indication", "drugs"."approval", "drugs"."clinicalstatus", "drugs"."phasedate", "drugs"."phase", "drugs"."moa", "drugs"."targetlevel", "drugs"."externallink", "drugs"."novelty", "drugs"."references" FROM "drugs" WHERE "drugs"."id" = 695
  177 similar queries.   Duplicated 177 times.
0.5643701778497462%
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/drugs/views.py in nhs_drug(423)
  queryname = i.drugname.name
  +
SELECT ••• "drugs"."id", "drugs"."name", "drugs"."synonym", "drugs"."drugtype", "drugs"."status", "drugs"."indication", "drugs"."approval", "drugs"."clinicalstatus", "drugs"."phasedate", "drugs"."phase", "drugs"."moa", "drugs"."targetlevel", "drugs"."externallink", "drugs"."novelty", "drugs"."references" FROM "drugs" WHERE "drugs"."id" = 695
  177 similar queries.   Duplicated 177 times.
0.4857869885288955%
0.34

Connection: default

/usr/lib/python3.6/concurrent/futures/thread.py in _worker(69)
  work_item.run()
/usr/lib/python3.6/concurrent/futures/thread.py in run(56)
  result = self.fn(*self.args, **self.kwargs)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle(279)
  keepalive = self.handle_request(req, conn)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle_request(328)
  respiter = self.wsgi(environ, resp.start_response)
/home/protwis/gpcrdb_test/common/middleware/stats.py in __call__(34)
  response = self.get_response(request)
/home/protwis/gpcrdb_test/drugs/views.py in nhs_drug(423)
  queryname = i.drugname.name
  +
SELECT ••• "drugs"."id", "drugs"."name", "drugs"."synonym", "drugs"."drugtype", "drugs"."status", "drugs"."indication", "drugs"."approval", "drugs"."clinicalstatus", "drugs"."phasedate", "drugs"."phase", "drugs"."moa", "drugs"."targetlevel", "drugs"."externallink", "drugs"."novelty", "drugs"."references" FROM "drugs" WHERE "drugs"."id" = 695
  177 similar queries.   Duplicated 177 times.
0.4851066145953816%
0.34

Connection: default

/usr/lib/python3.6/concurrent/futures/thread.py in _worker(69)
  work_item.run()
/usr/lib/python3.6/concurrent/futures/thread.py in run(56)
  result = self.fn(*self.args, **self.kwargs)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle(279)
  keepalive = self.handle_request(req, conn)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle_request(328)
  respiter = self.wsgi(environ, resp.start_response)
/home/protwis/gpcrdb_test/common/middleware/stats.py in __call__(34)
  response = self.get_response(request)
/home/protwis/gpcrdb_test/drugs/views.py in nhs_drug(423)
  queryname = i.drugname.name
  +
SELECT ••• "drugs"."id", "drugs"."name", "drugs"."synonym", "drugs"."drugtype", "drugs"."status", "drugs"."indication", "drugs"."approval", "drugs"."clinicalstatus", "drugs"."phasedate", "drugs"."phase", "drugs"."moa", "drugs"."targetlevel", "drugs"."externallink", "drugs"."novelty", "drugs"."references" FROM "drugs" WHERE "drugs"."id" = 695
  177 similar queries.   Duplicated 177 times.
0.410605668875614%
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/drugs/views.py in nhs_drug(423)
  queryname = i.drugname.name
  +
SELECT ••• "drugs"."id", "drugs"."name", "drugs"."synonym", "drugs"."drugtype", "drugs"."status", "drugs"."indication", "drugs"."approval", "drugs"."clinicalstatus", "drugs"."phasedate", "drugs"."phase", "drugs"."moa", "drugs"."targetlevel", "drugs"."externallink", "drugs"."novelty", "drugs"."references" FROM "drugs" WHERE "drugs"."id" = 695
  177 similar queries.   Duplicated 177 times.
0.4211514648450788%
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/drugs/views.py in nhs_drug(423)
  queryname = i.drugname.name
  +
SELECT ••• "drugs"."id", "drugs"."name", "drugs"."synonym", "drugs"."drugtype", "drugs"."status", "drugs"."indication", "drugs"."approval", "drugs"."clinicalstatus", "drugs"."phasedate", "drugs"."phase", "drugs"."moa", "drugs"."targetlevel", "drugs"."externallink", "drugs"."novelty", "drugs"."references" FROM "drugs" WHERE "drugs"."id" = 695
  177 similar queries.   Duplicated 177 times.
0.5691327953843432%
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/drugs/views.py in nhs_drug(423)
  queryname = i.drugname.name
  +
SELECT ••• "drugs"."id", "drugs"."name", "drugs"."synonym", "drugs"."drugtype", "drugs"."status", "drugs"."indication", "drugs"."approval", "drugs"."clinicalstatus", "drugs"."phasedate", "drugs"."phase", "drugs"."moa", "drugs"."targetlevel", "drugs"."externallink", "drugs"."novelty", "drugs"."references" FROM "drugs" WHERE "drugs"."id" = 695
  177 similar queries.   Duplicated 177 times.
0.5007552150662004%
0.35

Connection: default

/usr/lib/python3.6/concurrent/futures/thread.py in _worker(69)
  work_item.run()
/usr/lib/python3.6/concurrent/futures/thread.py in run(56)
  result = self.fn(*self.args, **self.kwargs)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle(279)
  keepalive = self.handle_request(req, conn)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle_request(328)
  respiter = self.wsgi(environ, resp.start_response)
/home/protwis/gpcrdb_test/common/middleware/stats.py in __call__(34)
  response = self.get_response(request)
/home/protwis/gpcrdb_test/drugs/views.py in nhs_drug(423)
  queryname = i.drugname.name
  +
SELECT ••• "drugs"."id", "drugs"."name", "drugs"."synonym", "drugs"."drugtype", "drugs"."status", "drugs"."indication", "drugs"."approval", "drugs"."clinicalstatus", "drugs"."phasedate", "drugs"."phase", "drugs"."moa", "drugs"."targetlevel", "drugs"."externallink", "drugs"."novelty", "drugs"."references" FROM "drugs" WHERE "drugs"."id" = 695
  177 similar queries.   Duplicated 177 times.
0.41979071697805115%
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/drugs/views.py in nhs_drug(423)
  queryname = i.drugname.name
  +
SELECT ••• "drugs"."id", "drugs"."name", "drugs"."synonym", "drugs"."drugtype", "drugs"."status", "drugs"."indication", "drugs"."approval", "drugs"."clinicalstatus", "drugs"."phasedate", "drugs"."phase", "drugs"."moa", "drugs"."targetlevel", "drugs"."externallink", "drugs"."novelty", "drugs"."references" FROM "drugs" WHERE "drugs"."id" = 695
  177 similar queries.   Duplicated 177 times.
0.49939446719917263%
0.35

Connection: default

/usr/lib/python3.6/concurrent/futures/thread.py in _worker(69)
  work_item.run()
/usr/lib/python3.6/concurrent/futures/thread.py in run(56)
  result = self.fn(*self.args, **self.kwargs)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle(279)
  keepalive = self.handle_request(req, conn)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle_request(328)
  respiter = self.wsgi(environ, resp.start_response)
/home/protwis/gpcrdb_test/common/middleware/stats.py in __call__(34)
  response = self.get_response(request)
/home/protwis/gpcrdb_test/drugs/views.py in nhs_drug(423)
  queryname = i.drugname.name
  +
SELECT ••• "drugs"."id", "drugs"."name", "drugs"."synonym", "drugs"."drugtype", "drugs"."status", "drugs"."indication", "drugs"."approval", "drugs"."clinicalstatus", "drugs"."phasedate", "drugs"."phase", "drugs"."moa", "drugs"."targetlevel", "drugs"."externallink", "drugs"."novelty", "drugs"."references" FROM "drugs" WHERE "drugs"."id" = 695
  177 similar queries.   Duplicated 177 times.
0.5888636394562451%
0.41

Connection: default

/usr/lib/python3.6/concurrent/futures/thread.py in _worker(69)
  work_item.run()
/usr/lib/python3.6/concurrent/futures/thread.py in run(56)
  result = self.fn(*self.args, **self.kwargs)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle(279)
  keepalive = self.handle_request(req, conn)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle_request(328)
  respiter = self.wsgi(environ, resp.start_response)
/home/protwis/gpcrdb_test/common/middleware/stats.py in __call__(34)
  response = self.get_response(request)
/home/protwis/gpcrdb_test/drugs/views.py in nhs_drug(423)
  queryname = i.drugname.name
  +
SELECT ••• "drugs"."id", "drugs"."name", "drugs"."synonym", "drugs"."drugtype", "drugs"."status", "drugs"."indication", "drugs"."approval", "drugs"."clinicalstatus", "drugs"."phasedate", "drugs"."phase", "drugs"."moa", "drugs"."targetlevel", "drugs"."externallink", "drugs"."novelty", "drugs"."references" FROM "drugs" WHERE "drugs"."id" = 695
  177 similar queries.   Duplicated 177 times.
0.5636898039162324%
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/drugs/views.py in nhs_drug(423)
  queryname = i.drugname.name
  +
SELECT ••• "drugs"."id", "drugs"."name", "drugs"."synonym", "drugs"."drugtype", "drugs"."status", "drugs"."indication", "drugs"."approval", "drugs"."clinicalstatus", "drugs"."phasedate", "drugs"."phase", "drugs"."moa", "drugs"."targetlevel", "drugs"."externallink", "drugs"."novelty", "drugs"."references" FROM "drugs" WHERE "drugs"."id" = 695
  177 similar queries.   Duplicated 177 times.
0.5633496169494754%
0.39

Connection: default

/usr/lib/python3.6/concurrent/futures/thread.py in _worker(69)
  work_item.run()
/usr/lib/python3.6/concurrent/futures/thread.py in run(56)
  result = self.fn(*self.args, **self.kwargs)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle(279)
  keepalive = self.handle_request(req, conn)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle_request(328)
  respiter = self.wsgi(environ, resp.start_response)
/home/protwis/gpcrdb_test/common/middleware/stats.py in __call__(34)
  response = self.get_response(request)
/home/protwis/gpcrdb_test/drugs/views.py in nhs_drug(423)
  queryname = i.drugname.name
  +
SELECT ••• "drugs"."id", "drugs"."name", "drugs"."synonym", "drugs"."drugtype", "drugs"."status", "drugs"."indication", "drugs"."approval", "drugs"."clinicalstatus", "drugs"."phasedate", "drugs"."phase", "drugs"."moa", "drugs"."targetlevel", "drugs"."externallink", "drugs"."novelty", "drugs"."references" FROM "drugs" WHERE "drugs"."id" = 695
  177 similar queries.   Duplicated 177 times.
0.5660711126835308%
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/drugs/views.py in nhs_drug(423)
  queryname = i.drugname.name
  +
SELECT ••• "drugs"."id", "drugs"."name", "drugs"."synonym", "drugs"."drugtype", "drugs"."status", "drugs"."indication", "drugs"."approval", "drugs"."clinicalstatus", "drugs"."phasedate", "drugs"."phase", "drugs"."moa", "drugs"."targetlevel", "drugs"."externallink", "drugs"."novelty", "drugs"."references" FROM "drugs" WHERE "drugs"."id" = 695
  177 similar queries.   Duplicated 177 times.
0.565730925716774%
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/drugs/views.py in nhs_drug(423)
  queryname = i.drugname.name
  +
SELECT ••• "drugs"."id", "drugs"."name", "drugs"."synonym", "drugs"."drugtype", "drugs"."status", "drugs"."indication", "drugs"."approval", "drugs"."clinicalstatus", "drugs"."phasedate", "drugs"."phase", "drugs"."moa", "drugs"."targetlevel", "drugs"."externallink", "drugs"."novelty", "drugs"."references" FROM "drugs" WHERE "drugs"."id" = 695
  177 similar queries.   Duplicated 177 times.
0.6055328008273347%
0.42

Connection: default

/usr/lib/python3.6/concurrent/futures/thread.py in _worker(69)
  work_item.run()
/usr/lib/python3.6/concurrent/futures/thread.py in run(56)
  result = self.fn(*self.args, **self.kwargs)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle(279)
  keepalive = self.handle_request(req, conn)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle_request(328)
  respiter = self.wsgi(environ, resp.start_response)
/home/protwis/gpcrdb_test/common/middleware/stats.py in __call__(34)
  response = self.get_response(request)
/home/protwis/gpcrdb_test/drugs/views.py in nhs_drug(423)
  queryname = i.drugname.name
  +
SELECT ••• "drugs"."id", "drugs"."name", "drugs"."synonym", "drugs"."drugtype", "drugs"."status", "drugs"."indication", "drugs"."approval", "drugs"."clinicalstatus", "drugs"."phasedate", "drugs"."phase", "drugs"."moa", "drugs"."targetlevel", "drugs"."externallink", "drugs"."novelty", "drugs"."references" FROM "drugs" WHERE "drugs"."id" = 695
  177 similar queries.   Duplicated 177 times.
0.5922655091238145%
0.42

Connection: default

/usr/lib/python3.6/concurrent/futures/thread.py in _worker(69)
  work_item.run()
/usr/lib/python3.6/concurrent/futures/thread.py in run(56)
  result = self.fn(*self.args, **self.kwargs)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle(279)
  keepalive = self.handle_request(req, conn)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle_request(328)
  respiter = self.wsgi(environ, resp.start_response)
/home/protwis/gpcrdb_test/common/middleware/stats.py in __call__(34)
  response = self.get_response(request)
/home/protwis/gpcrdb_test/drugs/views.py in nhs_drug(423)
  queryname = i.drugname.name
  +
SELECT ••• "drugs"."id", "drugs"."name", "drugs"."synonym", "drugs"."drugtype", "drugs"."status", "drugs"."indication", "drugs"."approval", "drugs"."clinicalstatus", "drugs"."phasedate", "drugs"."phase", "drugs"."moa", "drugs"."targetlevel", "drugs"."externallink", "drugs"."novelty", "drugs"."references" FROM "drugs" WHERE "drugs"."id" = 695
  177 similar queries.   Duplicated 177 times.
0.487828110329437%
0.34

Connection: default

/usr/lib/python3.6/concurrent/futures/thread.py in _worker(69)
  work_item.run()
/usr/lib/python3.6/concurrent/futures/thread.py in run(56)
  result = self.fn(*self.args, **self.kwargs)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle(279)
  keepalive = self.handle_request(req, conn)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle_request(328)
  respiter = self.wsgi(environ, resp.start_response)
/home/protwis/gpcrdb_test/common/middleware/stats.py in __call__(34)
  response = self.get_response(request)
/home/protwis/gpcrdb_test/drugs/views.py in nhs_drug(423)
  queryname = i.drugname.name
  +
SELECT ••• "drugs"."id", "drugs"."name", "drugs"."synonym", "drugs"."drugtype", "drugs"."status", "drugs"."indication", "drugs"."approval", "drugs"."clinicalstatus", "drugs"."phasedate", "drugs"."phase", "drugs"."moa", "drugs"."targetlevel", "drugs"."externallink", "drugs"."novelty", "drugs"."references" FROM "drugs" WHERE "drugs"."id" = 695
  177 similar queries.   Duplicated 177 times.
0.6317271972676183%
0.44

Connection: default

/usr/lib/python3.6/concurrent/futures/thread.py in _worker(69)
  work_item.run()
/usr/lib/python3.6/concurrent/futures/thread.py in run(56)
  result = self.fn(*self.args, **self.kwargs)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle(279)
  keepalive = self.handle_request(req, conn)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle_request(328)
  respiter = self.wsgi(environ, resp.start_response)
/home/protwis/gpcrdb_test/common/middleware/stats.py in __call__(34)
  response = self.get_response(request)
/home/protwis/gpcrdb_test/drugs/views.py in nhs_drug(423)
  queryname = i.drugname.name
  +
SELECT ••• "drugs"."id", "drugs"."name", "drugs"."synonym", "drugs"."drugtype", "drugs"."status", "drugs"."indication", "drugs"."approval", "drugs"."clinicalstatus", "drugs"."phasedate", "drugs"."phase", "drugs"."moa", "drugs"."targetlevel", "drugs"."externallink", "drugs"."novelty", "drugs"."references" FROM "drugs" WHERE "drugs"."id" = 695
  177 similar queries.   Duplicated 177 times.
0.5912449482235437%
0.41

Connection: default

/usr/lib/python3.6/concurrent/futures/thread.py in _worker(69)
  work_item.run()
/usr/lib/python3.6/concurrent/futures/thread.py in run(56)
  result = self.fn(*self.args, **self.kwargs)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle(279)
  keepalive = self.handle_request(req, conn)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle_request(328)
  respiter = self.wsgi(environ, resp.start_response)
/home/protwis/gpcrdb_test/common/middleware/stats.py in __call__(34)
  response = self.get_response(request)
/home/protwis/gpcrdb_test/drugs/views.py in nhs_drug(423)
  queryname = i.drugname.name
  +
SELECT ••• "drugs"."id", "drugs"."name", "drugs"."synonym", "drugs"."drugtype", "drugs"."status", "drugs"."indication", "drugs"."approval", "drugs"."clinicalstatus", "drugs"."phasedate", "drugs"."phase", "drugs"."moa", "drugs"."targetlevel", "drugs"."externallink", "drugs"."novelty", "drugs"."references" FROM "drugs" WHERE "drugs"."id" = 695
  177 similar queries.   Duplicated 177 times.
0.5007552150662004%
0.35

Connection: default

/usr/lib/python3.6/concurrent/futures/thread.py in _worker(69)
  work_item.run()
/usr/lib/python3.6/concurrent/futures/thread.py in run(56)
  result = self.fn(*self.args, **self.kwargs)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle(279)
  keepalive = self.handle_request(req, conn)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle_request(328)
  respiter = self.wsgi(environ, resp.start_response)
/home/protwis/gpcrdb_test/common/middleware/stats.py in __call__(34)
  response = self.get_response(request)
/home/protwis/gpcrdb_test/drugs/views.py in nhs_drug(423)
  queryname = i.drugname.name
  +
SELECT ••• "drugs"."id", "drugs"."name", "drugs"."synonym", "drugs"."drugtype", "drugs"."status", "drugs"."indication", "drugs"."approval", "drugs"."clinicalstatus", "drugs"."phasedate", "drugs"."phase", "drugs"."moa", "drugs"."targetlevel", "drugs"."externallink", "drugs"."novelty", "drugs"."references" FROM "drugs" WHERE "drugs"."id" = 695
  177 similar queries.   Duplicated 177 times.
0.599069248458953%
0.42

Connection: default

/usr/lib/python3.6/concurrent/futures/thread.py in _worker(69)
  work_item.run()
/usr/lib/python3.6/concurrent/futures/thread.py in run(56)
  result = self.fn(*self.args, **self.kwargs)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle(279)
  keepalive = self.handle_request(req, conn)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle_request(328)
  respiter = self.wsgi(environ, resp.start_response)
/home/protwis/gpcrdb_test/common/middleware/stats.py in __call__(34)
  response = self.get_response(request)
/home/protwis/gpcrdb_test/drugs/views.py in nhs_drug(423)
  queryname = i.drugname.name
  +
SELECT ••• "drugs"."id", "drugs"."name", "drugs"."synonym", "drugs"."drugtype", "drugs"."status", "drugs"."indication", "drugs"."approval", "drugs"."clinicalstatus", "drugs"."phasedate", "drugs"."phase", "drugs"."moa", "drugs"."targetlevel", "drugs"."externallink", "drugs"."novelty", "drugs"."references" FROM "drugs" WHERE "drugs"."id" = 695
  177 similar queries.   Duplicated 177 times.
0.5674318605505586%
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/drugs/views.py in nhs_drug(423)
  queryname = i.drugname.name
  +
SELECT ••• "drugs"."id", "drugs"."name", "drugs"."synonym", "drugs"."drugtype", "drugs"."status", "drugs"."indication", "drugs"."approval", "drugs"."clinicalstatus", "drugs"."phasedate", "drugs"."phase", "drugs"."moa", "drugs"."targetlevel", "drugs"."externallink", "drugs"."novelty", "drugs"."references" FROM "drugs" WHERE "drugs"."id" = 695
  177 similar queries.   Duplicated 177 times.
0.5732150389854264%
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/drugs/views.py in nhs_drug(423)
  queryname = i.drugname.name
  +
SELECT ••• "drugs"."id", "drugs"."name", "drugs"."synonym", "drugs"."drugtype", "drugs"."status", "drugs"."indication", "drugs"."approval", "drugs"."clinicalstatus", "drugs"."phasedate", "drugs"."phase", "drugs"."moa", "drugs"."targetlevel", "drugs"."externallink", "drugs"."novelty", "drugs"."references" FROM "drugs" WHERE "drugs"."id" = 695
  177 similar queries.   Duplicated 177 times.
0.47762250132672923%
0.33

Connection: default

/usr/lib/python3.6/concurrent/futures/thread.py in _worker(69)
  work_item.run()
/usr/lib/python3.6/concurrent/futures/thread.py in run(56)
  result = self.fn(*self.args, **self.kwargs)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle(279)
  keepalive = self.handle_request(req, conn)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle_request(328)
  respiter = self.wsgi(environ, resp.start_response)
/home/protwis/gpcrdb_test/common/middleware/stats.py in __call__(34)
  response = self.get_response(request)
/home/protwis/gpcrdb_test/drugs/views.py in nhs_drug(423)
  queryname = i.drugname.name
  +
SELECT ••• "drugs"."id", "drugs"."name", "drugs"."synonym", "drugs"."drugtype", "drugs"."status", "drugs"."indication", "drugs"."approval", "drugs"."clinicalstatus", "drugs"."phasedate", "drugs"."phase", "drugs"."moa", "drugs"."targetlevel", "drugs"."externallink", "drugs"."novelty", "drugs"."references" FROM "drugs" WHERE "drugs"."id" = 695
  177 similar queries.   Duplicated 177 times.
0.42047109091156504%
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/drugs/views.py in nhs_drug(423)
  queryname = i.drugname.name
  +
SELECT ••• "drugs"."id", "drugs"."name", "drugs"."synonym", "drugs"."drugtype", "drugs"."status", "drugs"."indication", "drugs"."approval", "drugs"."clinicalstatus", "drugs"."phasedate", "drugs"."phase", "drugs"."moa", "drugs"."targetlevel", "drugs"."externallink", "drugs"."novelty", "drugs"."references" FROM "drugs" WHERE "drugs"."id" = 695
  177 similar queries.   Duplicated 177 times.
0.4738804446924029%
0.33

Connection: default

/usr/lib/python3.6/concurrent/futures/thread.py in _worker(69)
  work_item.run()
/usr/lib/python3.6/concurrent/futures/thread.py in run(56)
  result = self.fn(*self.args, **self.kwargs)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle(279)
  keepalive = self.handle_request(req, conn)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle_request(328)
  respiter = self.wsgi(environ, resp.start_response)
/home/protwis/gpcrdb_test/common/middleware/stats.py in __call__(34)
  response = self.get_response(request)
/home/protwis/gpcrdb_test/drugs/views.py in nhs_drug(423)
  queryname = i.drugname.name
  +
SELECT ••• "drugs"."id", "drugs"."name", "drugs"."synonym", "drugs"."drugtype", "drugs"."status", "drugs"."indication", "drugs"."approval", "drugs"."clinicalstatus", "drugs"."phasedate", "drugs"."phase", "drugs"."moa", "drugs"."targetlevel", "drugs"."externallink", "drugs"."novelty", "drugs"."references" FROM "drugs" WHERE "drugs"."id" = 695
  177 similar queries.   Duplicated 177 times.
0.5694729823511001%
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/drugs/views.py in nhs_drug(423)
  queryname = i.drugname.name
  +
SELECT ••• "drugs"."id", "drugs"."name", "drugs"."synonym", "drugs"."drugtype", "drugs"."status", "drugs"."indication", "drugs"."approval", "drugs"."clinicalstatus", "drugs"."phasedate", "drugs"."phase", "drugs"."moa", "drugs"."targetlevel", "drugs"."externallink", "drugs"."novelty", "drugs"."references" FROM "drugs" WHERE "drugs"."id" = 695
  177 similar queries.   Duplicated 177 times.
0.492930914830791%
0.35

Connection: default

/usr/lib/python3.6/concurrent/futures/thread.py in _worker(69)
  work_item.run()
/usr/lib/python3.6/concurrent/futures/thread.py in run(56)
  result = self.fn(*self.args, **self.kwargs)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle(279)
  keepalive = self.handle_request(req, conn)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle_request(328)
  respiter = self.wsgi(environ, resp.start_response)
/home/protwis/gpcrdb_test/common/middleware/stats.py in __call__(34)
  response = self.get_response(request)
/home/protwis/gpcrdb_test/drugs/views.py in nhs_drug(423)
  queryname = i.drugname.name
  +
SELECT ••• "drugs"."id", "drugs"."name", "drugs"."synonym", "drugs"."drugtype", "drugs"."status", "drugs"."indication", "drugs"."approval", "drugs"."clinicalstatus", "drugs"."phasedate", "drugs"."phase", "drugs"."moa", "drugs"."targetlevel", "drugs"."externallink", "drugs"."novelty", "drugs"."references" FROM "drugs" WHERE "drugs"."id" = 695
  177 similar queries.   Duplicated 177 times.
0.4436038046510362%
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/drugs/views.py in nhs_drug(423)
  queryname = i.drugname.name
  +
SELECT ••• "drugs"."id", "drugs"."name", "drugs"."synonym", "drugs"."drugtype", "drugs"."status", "drugs"."indication", "drugs"."approval", "drugs"."clinicalstatus", "drugs"."phasedate", "drugs"."phase", "drugs"."moa", "drugs"."targetlevel", "drugs"."externallink", "drugs"."novelty", "drugs"."references" FROM "drugs" WHERE "drugs"."id" = 695
  177 similar queries.   Duplicated 177 times.
0.5725346650519125%
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/drugs/views.py in nhs_drug(423)
  queryname = i.drugname.name
  +
SELECT ••• "drugs"."id", "drugs"."name", "drugs"."synonym", "drugs"."drugtype", "drugs"."status", "drugs"."indication", "drugs"."approval", "drugs"."clinicalstatus", "drugs"."phasedate", "drugs"."phase", "drugs"."moa", "drugs"."targetlevel", "drugs"."externallink", "drugs"."novelty", "drugs"."references" FROM "drugs" WHERE "drugs"."id" = 695
  177 similar queries.   Duplicated 177 times.
0.5735552259521833%
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/drugs/views.py in nhs_drug(423)
  queryname = i.drugname.name
  +
SELECT ••• "drugs"."id", "drugs"."name", "drugs"."synonym", "drugs"."drugtype", "drugs"."status", "drugs"."indication", "drugs"."approval", "drugs"."clinicalstatus", "drugs"."phasedate", "drugs"."phase", "drugs"."moa", "drugs"."targetlevel", "drugs"."externallink", "drugs"."novelty", "drugs"."references" FROM "drugs" WHERE "drugs"."id" = 695
  177 similar queries.   Duplicated 177 times.
0.5477010164786567%
0.38

Connection: default

/usr/lib/python3.6/concurrent/futures/thread.py in _worker(69)
  work_item.run()
/usr/lib/python3.6/concurrent/futures/thread.py in run(56)
  result = self.fn(*self.args, **self.kwargs)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle(279)
  keepalive = self.handle_request(req, conn)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle_request(328)
  respiter = self.wsgi(environ, resp.start_response)
/home/protwis/gpcrdb_test/common/middleware/stats.py in __call__(34)
  response = self.get_response(request)
/home/protwis/gpcrdb_test/drugs/views.py in nhs_drug(423)
  queryname = i.drugname.name
  +
SELECT ••• "drugs"."id", "drugs"."name", "drugs"."synonym", "drugs"."drugtype", "drugs"."status", "drugs"."indication", "drugs"."approval", "drugs"."clinicalstatus", "drugs"."phasedate", "drugs"."phase", "drugs"."moa", "drugs"."targetlevel", "drugs"."externallink", "drugs"."novelty", "drugs"."references" FROM "drugs" WHERE "drugs"."id" = 695
  177 similar queries.   Duplicated 177 times.
0.5674318605505586%
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/drugs/views.py in nhs_drug(423)
  queryname = i.drugname.name
  +
SELECT ••• "drugs"."id", "drugs"."name", "drugs"."synonym", "drugs"."drugtype", "drugs"."status", "drugs"."indication", "drugs"."approval", "drugs"."clinicalstatus", "drugs"."phasedate", "drugs"."phase", "drugs"."moa", "drugs"."targetlevel", "drugs"."externallink", "drugs"."novelty", "drugs"."references" FROM "drugs" WHERE "drugs"."id" = 695
  177 similar queries.   Duplicated 177 times.
0.5732150389854264%
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/drugs/views.py in nhs_drug(423)
  queryname = i.drugname.name
  +
SELECT ••• "drugs"."id", "drugs"."name", "drugs"."synonym", "drugs"."drugtype", "drugs"."status", "drugs"."indication", "drugs"."approval", "drugs"."clinicalstatus", "drugs"."phasedate", "drugs"."phase", "drugs"."moa", "drugs"."targetlevel", "drugs"."externallink", "drugs"."novelty", "drugs"."references" FROM "drugs" WHERE "drugs"."id" = 695
  177 similar queries.   Duplicated 177 times.
0.5687926084175863%
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/drugs/views.py in nhs_drug(423)
  queryname = i.drugname.name
  +
SELECT ••• "drugs"."id", "drugs"."name", "drugs"."synonym", "drugs"."drugtype", "drugs"."status", "drugs"."indication", "drugs"."approval", "drugs"."clinicalstatus", "drugs"."phasedate", "drugs"."phase", "drugs"."moa", "drugs"."targetlevel", "drugs"."externallink", "drugs"."novelty", "drugs"."references" FROM "drugs" WHERE "drugs"."id" = 695
  177 similar queries.   Duplicated 177 times.
0.4827253058280831%
0.34

Connection: default

/usr/lib/python3.6/concurrent/futures/thread.py in _worker(69)
  work_item.run()
/usr/lib/python3.6/concurrent/futures/thread.py in run(56)
  result = self.fn(*self.args, **self.kwargs)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle(279)
  keepalive = self.handle_request(req, conn)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle_request(328)
  respiter = self.wsgi(environ, resp.start_response)
/home/protwis/gpcrdb_test/common/middleware/stats.py in __call__(34)
  response = self.get_response(request)
/home/protwis/gpcrdb_test/drugs/views.py in nhs_drug(423)
  queryname = i.drugname.name
  +
SELECT ••• "drugs"."id", "drugs"."name", "drugs"."synonym", "drugs"."drugtype", "drugs"."status", "drugs"."indication", "drugs"."approval", "drugs"."clinicalstatus", "drugs"."phasedate", "drugs"."phase", "drugs"."moa", "drugs"."targetlevel", "drugs"."externallink", "drugs"."novelty", "drugs"."references" FROM "drugs" WHERE "drugs"."id" = 695
  177 similar queries.   Duplicated 177 times.
0.5892038264230021%
0.41

Connection: default

/usr/lib/python3.6/concurrent/futures/thread.py in _worker(69)
  work_item.run()
/usr/lib/python3.6/concurrent/futures/thread.py in run(56)
  result = self.fn(*self.args, **self.kwargs)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle(279)
  keepalive = self.handle_request(req, conn)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle_request(328)
  respiter = self.wsgi(environ, resp.start_response)
/home/protwis/gpcrdb_test/common/middleware/stats.py in __call__(34)
  response = self.get_response(request)
/home/protwis/gpcrdb_test/drugs/views.py in nhs_drug(423)
  queryname = i.drugname.name
  +
SELECT ••• "drugs"."id", "drugs"."name", "drugs"."synonym", "drugs"."drugtype", "drugs"."status", "drugs"."indication", "drugs"."approval", "drugs"."clinicalstatus", "drugs"."phasedate", "drugs"."phase", "drugs"."moa", "drugs"."targetlevel", "drugs"."externallink", "drugs"."novelty", "drugs"."references" FROM "drugs" WHERE "drugs"."id" = 695
  177 similar queries.   Duplicated 177 times.
0.604172052960307%
0.42

Connection: default

/usr/lib/python3.6/concurrent/futures/thread.py in _worker(69)
  work_item.run()
/usr/lib/python3.6/concurrent/futures/thread.py in run(56)
  result = self.fn(*self.args, **self.kwargs)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle(279)
  keepalive = self.handle_request(req, conn)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle_request(328)
  respiter = self.wsgi(environ, resp.start_response)
/home/protwis/gpcrdb_test/common/middleware/stats.py in __call__(34)
  response = self.get_response(request)
/home/protwis/gpcrdb_test/drugs/views.py in nhs_drug(423)
  queryname = i.drugname.name
  +
SELECT ••• "drugs"."id", "drugs"."name", "drugs"."synonym", "drugs"."drugtype", "drugs"."status", "drugs"."indication", "drugs"."approval", "drugs"."clinicalstatus", "drugs"."phasedate", "drugs"."phase", "drugs"."moa", "drugs"."targetlevel", "drugs"."externallink", "drugs"."novelty", "drugs"."references" FROM "drugs" WHERE "drugs"."id" = 695
  177 similar queries.   Duplicated 177 times.
0.4871477363959232%
0.34

Connection: default

/usr/lib/python3.6/concurrent/futures/thread.py in _worker(69)
  work_item.run()
/usr/lib/python3.6/concurrent/futures/thread.py in run(56)
  result = self.fn(*self.args, **self.kwargs)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle(279)
  keepalive = self.handle_request(req, conn)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle_request(328)
  respiter = self.wsgi(environ, resp.start_response)
/home/protwis/gpcrdb_test/common/middleware/stats.py in __call__(34)
  response = self.get_response(request)
/home/protwis/gpcrdb_test/drugs/views.py in nhs_drug(423)
  queryname = i.drugname.name
  +
SELECT ••• "drugs"."id", "drugs"."name", "drugs"."synonym", "drugs"."drugtype", "drugs"."status", "drugs"."indication", "drugs"."approval", "drugs"."clinicalstatus", "drugs"."phasedate", "drugs"."phase", "drugs"."moa", "drugs"."targetlevel", "drugs"."externallink", "drugs"."novelty", "drugs"."references" FROM "drugs" WHERE "drugs"."id" = 695
  177 similar queries.   Duplicated 177 times.
0.5000748411326865%
0.35

Connection: default

/usr/lib/python3.6/concurrent/futures/thread.py in _worker(69)
  work_item.run()
/usr/lib/python3.6/concurrent/futures/thread.py in run(56)
  result = self.fn(*self.args, **self.kwargs)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle(279)
  keepalive = self.handle_request(req, conn)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle_request(328)
  respiter = self.wsgi(environ, resp.start_response)
/home/protwis/gpcrdb_test/common/middleware/stats.py in __call__(34)
  response = self.get_response(request)
/home/protwis/gpcrdb_test/drugs/views.py in nhs_drug(423)
  queryname = i.drugname.name
  +
SELECT ••• "drugs"."id", "drugs"."name", "drugs"."synonym", "drugs"."drugtype", "drugs"."status", "drugs"."indication", "drugs"."approval", "drugs"."clinicalstatus", "drugs"."phasedate", "drugs"."phase", "drugs"."moa", "drugs"."targetlevel", "drugs"."externallink", "drugs"."novelty", "drugs"."references" FROM "drugs" WHERE "drugs"."id" = 695
  177 similar queries.   Duplicated 177 times.
0.4374804392494115%
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/drugs/views.py in nhs_drug(423)
  queryname = i.drugname.name
  +
SELECT ••• "drugs"."id", "drugs"."name", "drugs"."synonym", "drugs"."drugtype", "drugs"."status", "drugs"."indication", "drugs"."approval", "drugs"."clinicalstatus", "drugs"."phasedate", "drugs"."phase", "drugs"."moa", "drugs"."targetlevel", "drugs"."externallink", "drugs"."novelty", "drugs"."references" FROM "drugs" WHERE "drugs"."id" = 695
  177 similar queries.   Duplicated 177 times.
0.44088230891698077%
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/drugs/views.py in nhs_drug(423)
  queryname = i.drugname.name
  +
SELECT ••• "drugs"."id", "drugs"."name", "drugs"."synonym", "drugs"."drugtype", "drugs"."status", "drugs"."indication", "drugs"."approval", "drugs"."clinicalstatus", "drugs"."phasedate", "drugs"."phase", "drugs"."moa", "drugs"."targetlevel", "drugs"."externallink", "drugs"."novelty", "drugs"."references" FROM "drugs" WHERE "drugs"."id" = 695
  177 similar queries.   Duplicated 177 times.
0.5589271863816353%
0.39

Connection: default

/usr/lib/python3.6/concurrent/futures/thread.py in _worker(69)
  work_item.run()
/usr/lib/python3.6/concurrent/futures/thread.py in run(56)
  result = self.fn(*self.args, **self.kwargs)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle(279)
  keepalive = self.handle_request(req, conn)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle_request(328)
  respiter = self.wsgi(environ, resp.start_response)
/home/protwis/gpcrdb_test/common/middleware/stats.py in __call__(34)
  response = self.get_response(request)
/home/protwis/gpcrdb_test/drugs/views.py in nhs_drug(423)
  queryname = i.drugname.name
  +
SELECT ••• "drugs"."id", "drugs"."name", "drugs"."synonym", "drugs"."drugtype", "drugs"."status", "drugs"."indication", "drugs"."approval", "drugs"."clinicalstatus", "drugs"."phasedate", "drugs"."phase", "drugs"."moa", "drugs"."targetlevel", "drugs"."externallink", "drugs"."novelty", "drugs"."references" FROM "drugs" WHERE "drugs"."id" = 695
  177 similar queries.   Duplicated 177 times.
0.48748792336268015%
0.34

Connection: default

/usr/lib/python3.6/concurrent/futures/thread.py in _worker(69)
  work_item.run()
/usr/lib/python3.6/concurrent/futures/thread.py in run(56)
  result = self.fn(*self.args, **self.kwargs)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle(279)
  keepalive = self.handle_request(req, conn)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle_request(328)
  respiter = self.wsgi(environ, resp.start_response)
/home/protwis/gpcrdb_test/common/middleware/stats.py in __call__(34)
  response = self.get_response(request)
/home/protwis/gpcrdb_test/drugs/views.py in nhs_drug(423)
  queryname = i.drugname.name
  +
SELECT ••• "drugs"."id", "drugs"."name", "drugs"."synonym", "drugs"."drugtype", "drugs"."status", "drugs"."indication", "drugs"."approval", "drugs"."clinicalstatus", "drugs"."phasedate", "drugs"."phase", "drugs"."moa", "drugs"."targetlevel", "drugs"."externallink", "drugs"."novelty", "drugs"."references" FROM "drugs" WHERE "drugs"."id" = 695
  177 similar queries.   Duplicated 177 times.
0.5313720420743241%
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/drugs/views.py in nhs_drug(423)
  queryname = i.drugname.name
  +
SELECT ••• "drugs"."id", "drugs"."name", "drugs"."synonym", "drugs"."drugtype", "drugs"."status", "drugs"."indication", "drugs"."approval", "drugs"."clinicalstatus", "drugs"."phasedate", "drugs"."phase", "drugs"."moa", "drugs"."targetlevel", "drugs"."externallink", "drugs"."novelty", "drugs"."references" FROM "drugs" WHERE "drugs"."id" = 695
  177 similar queries.   Duplicated 177 times.
0.5565458776143368%
0.39

Connection: default

/usr/lib/python3.6/concurrent/futures/thread.py in _worker(69)
  work_item.run()
/usr/lib/python3.6/concurrent/futures/thread.py in run(56)
  result = self.fn(*self.args, **self.kwargs)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle(279)
  keepalive = self.handle_request(req, conn)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle_request(328)
  respiter = self.wsgi(environ, resp.start_response)
/home/protwis/gpcrdb_test/common/middleware/stats.py in __call__(34)
  response = self.get_response(request)
/home/protwis/gpcrdb_test/drugs/views.py in nhs_drug(423)
  queryname = i.drugname.name
  +
SELECT ••• "drugs"."id", "drugs"."name", "drugs"."synonym", "drugs"."drugtype", "drugs"."status", "drugs"."indication", "drugs"."approval", "drugs"."clinicalstatus", "drugs"."phasedate", "drugs"."phase", "drugs"."moa", "drugs"."targetlevel", "drugs"."externallink", "drugs"."novelty", "drugs"."references" FROM "drugs" WHERE "drugs"."id" = 695
  177 similar queries.   Duplicated 177 times.
0.5909047612567868%
0.41

Connection: default

/usr/lib/python3.6/concurrent/futures/thread.py in _worker(69)
  work_item.run()
/usr/lib/python3.6/concurrent/futures/thread.py in run(56)
  result = self.fn(*self.args, **self.kwargs)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle(279)
  keepalive = self.handle_request(req, conn)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle_request(328)
  respiter = self.wsgi(environ, resp.start_response)
/home/protwis/gpcrdb_test/common/middleware/stats.py in __call__(34)
  response = self.get_response(request)
/home/protwis/gpcrdb_test/drugs/views.py in nhs_drug(423)
  queryname = i.drugname.name
  +
SELECT ••• "drugs"."id", "drugs"."name", "drugs"."synonym", "drugs"."drugtype", "drugs"."status", "drugs"."indication", "drugs"."approval", "drugs"."clinicalstatus", "drugs"."phasedate", "drugs"."phase", "drugs"."moa", "drugs"."targetlevel", "drugs"."externallink", "drugs"."novelty", "drugs"."references" FROM "drugs" WHERE "drugs"."id" = 695
  177 similar queries.   Duplicated 177 times.
0.5017757759664712%
0.35

Connection: default

/usr/lib/python3.6/concurrent/futures/thread.py in _worker(69)
  work_item.run()
/usr/lib/python3.6/concurrent/futures/thread.py in run(56)
  result = self.fn(*self.args, **self.kwargs)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle(279)
  keepalive = self.handle_request(req, conn)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle_request(328)
  respiter = self.wsgi(environ, resp.start_response)
/home/protwis/gpcrdb_test/common/middleware/stats.py in __call__(34)
  response = self.get_response(request)
/home/protwis/gpcrdb_test/drugs/views.py in nhs_drug(423)
  queryname = i.drugname.name
  +
SELECT ••• "drugs"."id", "drugs"."name", "drugs"."synonym", "drugs"."drugtype", "drugs"."status", "drugs"."indication", "drugs"."approval", "drugs"."clinicalstatus", "drugs"."phasedate", "drugs"."phase", "drugs"."moa", "drugs"."targetlevel", "drugs"."externallink", "drugs"."novelty", "drugs"."references" FROM "drugs" WHERE "drugs"."id" = 695
  177 similar queries.   Duplicated 177 times.
0.4361196913823837%
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/drugs/views.py in nhs_drug(423)
  queryname = i.drugname.name
  +
SELECT ••• "drugs"."id", "drugs"."name", "drugs"."synonym", "drugs"."drugtype", "drugs"."status", "drugs"."indication", "drugs"."approval", "drugs"."clinicalstatus", "drugs"."phasedate", "drugs"."phase", "drugs"."moa", "drugs"."targetlevel", "drugs"."externallink", "drugs"."novelty", "drugs"."references" FROM "drugs" WHERE "drugs"."id" = 695
  177 similar queries.   Duplicated 177 times.
0.48816829729619404%
0.34

Connection: default

/usr/lib/python3.6/concurrent/futures/thread.py in _worker(69)
  work_item.run()
/usr/lib/python3.6/concurrent/futures/thread.py in run(56)
  result = self.fn(*self.args, **self.kwargs)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle(279)
  keepalive = self.handle_request(req, conn)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle_request(328)
  respiter = self.wsgi(environ, resp.start_response)
/home/protwis/gpcrdb_test/common/middleware/stats.py in __call__(34)
  response = self.get_response(request)
/home/protwis/gpcrdb_test/drugs/views.py in nhs_drug(423)
  queryname = i.drugname.name
  +
SELECT ••• "drugs"."id", "drugs"."name", "drugs"."synonym", "drugs"."drugtype", "drugs"."status", "drugs"."indication", "drugs"."approval", "drugs"."clinicalstatus", "drugs"."phasedate", "drugs"."phase", "drugs"."moa", "drugs"."targetlevel", "drugs"."externallink", "drugs"."novelty", "drugs"."references" FROM "drugs" WHERE "drugs"."id" = 695
  177 similar queries.   Duplicated 177 times.
0.4143477255099403%
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/drugs/views.py in nhs_drug(423)
  queryname = i.drugname.name
  +
SELECT ••• "drugs"."id", "drugs"."name", "drugs"."synonym", "drugs"."drugtype", "drugs"."status", "drugs"."indication", "drugs"."approval", "drugs"."clinicalstatus", "drugs"."phasedate", "drugs"."phase", "drugs"."moa", "drugs"."targetlevel", "drugs"."externallink", "drugs"."novelty", "drugs"."references" FROM "drugs" WHERE "drugs"."id" = 695
  177 similar queries.   Duplicated 177 times.
0.4136673515764264%
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/drugs/views.py in nhs_drug(423)
  queryname = i.drugname.name
  +
SELECT ••• "drugs"."id", "drugs"."name", "drugs"."synonym", "drugs"."drugtype", "drugs"."status", "drugs"."indication", "drugs"."approval", "drugs"."clinicalstatus", "drugs"."phasedate", "drugs"."phase", "drugs"."moa", "drugs"."targetlevel", "drugs"."externallink", "drugs"."novelty", "drugs"."references" FROM "drugs" WHERE "drugs"."id" = 695
  177 similar queries.   Duplicated 177 times.
0.5313720420743241%
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/drugs/views.py in nhs_drug(423)
  queryname = i.drugname.name
  +
SELECT ••• "drugs"."id", "drugs"."name", "drugs"."synonym", "drugs"."drugtype", "drugs"."status", "drugs"."indication", "drugs"."approval", "drugs"."clinicalstatus", "drugs"."phasedate", "drugs"."phase", "drugs"."moa", "drugs"."targetlevel", "drugs"."externallink", "drugs"."novelty", "drugs"."references" FROM "drugs" WHERE "drugs"."id" = 695
  177 similar queries.   Duplicated 177 times.
0.4803439970607846%
0.34

Connection: default

/usr/lib/python3.6/concurrent/futures/thread.py in _worker(69)
  work_item.run()
/usr/lib/python3.6/concurrent/futures/thread.py in run(56)
  result = self.fn(*self.args, **self.kwargs)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle(279)
  keepalive = self.handle_request(req, conn)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle_request(328)
  respiter = self.wsgi(environ, resp.start_response)
/home/protwis/gpcrdb_test/common/middleware/stats.py in __call__(34)
  response = self.get_response(request)
/home/protwis/gpcrdb_test/drugs/views.py in nhs_drug(423)
  queryname = i.drugname.name
  +
SELECT ••• "drugs"."id", "drugs"."name", "drugs"."synonym", "drugs"."drugtype", "drugs"."status", "drugs"."indication", "drugs"."approval", "drugs"."clinicalstatus", "drugs"."phasedate", "drugs"."phase", "drugs"."moa", "drugs"."targetlevel", "drugs"."externallink", "drugs"."novelty", "drugs"."references" FROM "drugs" WHERE "drugs"."id" = 695
  177 similar queries.   Duplicated 177 times.
0.5871627046224605%
0.41

Connection: default

/usr/lib/python3.6/concurrent/futures/thread.py in _worker(69)
  work_item.run()
/usr/lib/python3.6/concurrent/futures/thread.py in run(56)
  result = self.fn(*self.args, **self.kwargs)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle(279)
  keepalive = self.handle_request(req, conn)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle_request(328)
  respiter = self.wsgi(environ, resp.start_response)
/home/protwis/gpcrdb_test/common/middleware/stats.py in __call__(34)
  response = self.get_response(request)
/home/protwis/gpcrdb_test/drugs/views.py in nhs_drug(423)
  queryname = i.drugname.name
  +
SELECT ••• "drugs"."id", "drugs"."name", "drugs"."synonym", "drugs"."drugtype", "drugs"."status", "drugs"."indication", "drugs"."approval", "drugs"."clinicalstatus", "drugs"."phasedate", "drugs"."phase", "drugs"."moa", "drugs"."targetlevel", "drugs"."externallink", "drugs"."novelty", "drugs"."references" FROM "drugs" WHERE "drugs"."id" = 695
  177 similar queries.   Duplicated 177 times.
0.48646736246240935%
0.34

Connection: default

/usr/lib/python3.6/concurrent/futures/thread.py in _worker(69)
  work_item.run()
/usr/lib/python3.6/concurrent/futures/thread.py in run(56)
  result = self.fn(*self.args, **self.kwargs)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle(279)
  keepalive = self.handle_request(req, conn)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle_request(328)
  respiter = self.wsgi(environ, resp.start_response)
/home/protwis/gpcrdb_test/common/middleware/stats.py in __call__(34)
  response = self.get_response(request)
/home/protwis/gpcrdb_test/drugs/views.py in nhs_drug(423)
  queryname = i.drugname.name
  +
SELECT ••• "drugs"."id", "drugs"."name", "drugs"."synonym", "drugs"."drugtype", "drugs"."status", "drugs"."indication", "drugs"."approval", "drugs"."clinicalstatus", "drugs"."phasedate", "drugs"."phase", "drugs"."moa", "drugs"."targetlevel", "drugs"."externallink", "drugs"."novelty", "drugs"."references" FROM "drugs" WHERE "drugs"."id" = 695
  177 similar queries.   Duplicated 177 times.
0.5616486821156907%
0.39

Connection: default

/usr/lib/python3.6/concurrent/futures/thread.py in _worker(69)
  work_item.run()
/usr/lib/python3.6/concurrent/futures/thread.py in run(56)
  result = self.fn(*self.args, **self.kwargs)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle(279)
  keepalive = self.handle_request(req, conn)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle_request(328)
  respiter = self.wsgi(environ, resp.start_response)
/home/protwis/gpcrdb_test/common/middleware/stats.py in __call__(34)
  response = self.get_response(request)
/home/protwis/gpcrdb_test/drugs/views.py in nhs_drug(423)
  queryname = i.drugname.name
  +
SELECT ••• "drugs"."id", "drugs"."name", "drugs"."synonym", "drugs"."drugtype", "drugs"."status", "drugs"."indication", "drugs"."approval", "drugs"."clinicalstatus", "drugs"."phasedate", "drugs"."phase", "drugs"."moa", "drugs"."targetlevel", "drugs"."externallink", "drugs"."novelty", "drugs"."references" FROM "drugs" WHERE "drugs"."id" = 695
  177 similar queries.   Duplicated 177 times.
0.5936262569908421%
0.42

Connection: default

/usr/lib/python3.6/concurrent/futures/thread.py in _worker(69)
  work_item.run()
/usr/lib/python3.6/concurrent/futures/thread.py in run(56)
  result = self.fn(*self.args, **self.kwargs)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle(279)
  keepalive = self.handle_request(req, conn)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle_request(328)
  respiter = self.wsgi(environ, resp.start_response)
/home/protwis/gpcrdb_test/common/middleware/stats.py in __call__(34)
  response = self.get_response(request)
/home/protwis/gpcrdb_test/drugs/views.py in nhs_drug(423)
  queryname = i.drugname.name
  +
SELECT ••• "drugs"."id", "drugs"."name", "drugs"."synonym", "drugs"."drugtype", "drugs"."status", "drugs"."indication", "drugs"."approval", "drugs"."clinicalstatus", "drugs"."phasedate", "drugs"."phase", "drugs"."moa", "drugs"."targetlevel", "drugs"."externallink", "drugs"."novelty", "drugs"."references" FROM "drugs" WHERE "drugs"."id" = 695
  177 similar queries.   Duplicated 177 times.
0.6092748574616609%
0.43

Connection: default

/usr/lib/python3.6/concurrent/futures/thread.py in _worker(69)
  work_item.run()
/usr/lib/python3.6/concurrent/futures/thread.py in run(56)
  result = self.fn(*self.args, **self.kwargs)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle(279)
  keepalive = self.handle_request(req, conn)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle_request(328)
  respiter = self.wsgi(environ, resp.start_response)
/home/protwis/gpcrdb_test/common/middleware/stats.py in __call__(34)
  response = self.get_response(request)
/home/protwis/gpcrdb_test/drugs/views.py in nhs_drug(423)
  queryname = i.drugname.name
  +
SELECT ••• "drugs"."id", "drugs"."name", "drugs"."synonym", "drugs"."drugtype", "drugs"."status", "drugs"."indication", "drugs"."approval", "drugs"."clinicalstatus", "drugs"."phasedate", "drugs"."phase", "drugs"."moa", "drugs"."targetlevel", "drugs"."externallink", "drugs"."novelty", "drugs"."references" FROM "drugs" WHERE "drugs"."id" = 695
  177 similar queries.   Duplicated 177 times.
0.5681122344840724%
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/drugs/views.py in nhs_drug(423)
  queryname = i.drugname.name
  +
SELECT ••• "drugs"."id", "drugs"."name", "drugs"."synonym", "drugs"."drugtype", "drugs"."status", "drugs"."indication", "drugs"."approval", "drugs"."clinicalstatus", "drugs"."phasedate", "drugs"."phase", "drugs"."moa", "drugs"."targetlevel", "drugs"."externallink", "drugs"."novelty", "drugs"."references" FROM "drugs" WHERE "drugs"."id" = 695
  177 similar queries.   Duplicated 177 times.
0.5796785913538081%
0.41

Connection: default

/usr/lib/python3.6/concurrent/futures/thread.py in _worker(69)
  work_item.run()
/usr/lib/python3.6/concurrent/futures/thread.py in run(56)
  result = self.fn(*self.args, **self.kwargs)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle(279)
  keepalive = self.handle_request(req, conn)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle_request(328)
  respiter = self.wsgi(environ, resp.start_response)
/home/protwis/gpcrdb_test/common/middleware/stats.py in __call__(34)
  response = self.get_response(request)
/home/protwis/gpcrdb_test/drugs/views.py in nhs_drug(423)
  queryname = i.drugname.name
  +
SELECT ••• "drugs"."id", "drugs"."name", "drugs"."synonym", "drugs"."drugtype", "drugs"."status", "drugs"."indication", "drugs"."approval", "drugs"."clinicalstatus", "drugs"."phasedate", "drugs"."phase", "drugs"."moa", "drugs"."targetlevel", "drugs"."externallink", "drugs"."novelty", "drugs"."references" FROM "drugs" WHERE "drugs"."id" = 695
  177 similar queries.   Duplicated 177 times.
0.4851066145953816%
0.34

Connection: default

/usr/lib/python3.6/concurrent/futures/thread.py in _worker(69)
  work_item.run()
/usr/lib/python3.6/concurrent/futures/thread.py in run(56)
  result = self.fn(*self.args, **self.kwargs)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle(279)
  keepalive = self.handle_request(req, conn)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle_request(328)
  respiter = self.wsgi(environ, resp.start_response)
/home/protwis/gpcrdb_test/common/middleware/stats.py in __call__(34)
  response = self.get_response(request)
/home/protwis/gpcrdb_test/drugs/views.py in nhs_drug(423)
  queryname = i.drugname.name
  +
SELECT ••• "drugs"."id", "drugs"."name", "drugs"."synonym", "drugs"."drugtype", "drugs"."status", "drugs"."indication", "drugs"."approval", "drugs"."clinicalstatus", "drugs"."phasedate", "drugs"."phase", "drugs"."moa", "drugs"."targetlevel", "drugs"."externallink", "drugs"."novelty", "drugs"."references" FROM "drugs" WHERE "drugs"."id" = 695
  177 similar queries.   Duplicated 177 times.
0.565730925716774%
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/drugs/views.py in nhs_drug(423)
  queryname = i.drugname.name
  +
SELECT ••• "drugs"."id", "drugs"."name", "drugs"."synonym", "drugs"."drugtype", "drugs"."status", "drugs"."indication", "drugs"."approval", "drugs"."clinicalstatus", "drugs"."phasedate", "drugs"."phase", "drugs"."moa", "drugs"."targetlevel", "drugs"."externallink", "drugs"."novelty", "drugs"."references" FROM "drugs" WHERE "drugs"."id" = 695
  177 similar queries.   Duplicated 177 times.
0.5841010219216481%
0.41

Connection: default

/usr/lib/python3.6/concurrent/futures/thread.py in _worker(69)
  work_item.run()
/usr/lib/python3.6/concurrent/futures/thread.py in run(56)
  result = self.fn(*self.args, **self.kwargs)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle(279)
  keepalive = self.handle_request(req, conn)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle_request(328)
  respiter = self.wsgi(environ, resp.start_response)
/home/protwis/gpcrdb_test/common/middleware/stats.py in __call__(34)
  response = self.get_response(request)
/home/protwis/gpcrdb_test/drugs/views.py in nhs_drug(423)
  queryname = i.drugname.name
  +
SELECT ••• "drugs"."id", "drugs"."name", "drugs"."synonym", "drugs"."drugtype", "drugs"."status", "drugs"."indication", "drugs"."approval", "drugs"."clinicalstatus", "drugs"."phasedate", "drugs"."phase", "drugs"."moa", "drugs"."targetlevel", "drugs"."externallink", "drugs"."novelty", "drugs"."references" FROM "drugs" WHERE "drugs"."id" = 695
  177 similar queries.   Duplicated 177 times.
0.5616486821156907%
0.39

Connection: default

/usr/lib/python3.6/concurrent/futures/thread.py in _worker(69)
  work_item.run()
/usr/lib/python3.6/concurrent/futures/thread.py in run(56)
  result = self.fn(*self.args, **self.kwargs)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle(279)
  keepalive = self.handle_request(req, conn)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle_request(328)
  respiter = self.wsgi(environ, resp.start_response)
/home/protwis/gpcrdb_test/common/middleware/stats.py in __call__(34)
  response = self.get_response(request)
/home/protwis/gpcrdb_test/drugs/views.py in nhs_drug(423)
  queryname = i.drugname.name
  +
SELECT ••• "drugs"."id", "drugs"."name", "drugs"."synonym", "drugs"."drugtype", "drugs"."status", "drugs"."indication", "drugs"."approval", "drugs"."clinicalstatus", "drugs"."phasedate", "drugs"."phase", "drugs"."moa", "drugs"."targetlevel", "drugs"."externallink", "drugs"."novelty", "drugs"."references" FROM "drugs" WHERE "drugs"."id" = 695
  177 similar queries.   Duplicated 177 times.
0.5119813849691791%
0.36

Connection: default

/usr/lib/python3.6/concurrent/futures/thread.py in _worker(69)
  work_item.run()
/usr/lib/python3.6/concurrent/futures/thread.py in run(56)
  result = self.fn(*self.args, **self.kwargs)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle(279)
  keepalive = self.handle_request(req, conn)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle_request(328)
  respiter = self.wsgi(environ, resp.start_response)
/home/protwis/gpcrdb_test/common/middleware/stats.py in __call__(34)
  response = self.get_response(request)
/home/protwis/gpcrdb_test/drugs/views.py in nhs_drug(423)
  queryname = i.drugname.name
  +
SELECT ••• "drugs"."id", "drugs"."name", "drugs"."synonym", "drugs"."drugtype", "drugs"."status", "drugs"."indication", "drugs"."approval", "drugs"."clinicalstatus", "drugs"."phasedate", "drugs"."phase", "drugs"."moa", "drugs"."targetlevel", "drugs"."externallink", "drugs"."novelty", "drugs"."references" FROM "drugs" WHERE "drugs"."id" = 695
  177 similar queries.   Duplicated 177 times.
0.570153356284614%
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/drugs/views.py in nhs_drug(423)
  queryname = i.drugname.name
  +
SELECT ••• "drugs"."id", "drugs"."name", "drugs"."synonym", "drugs"."drugtype", "drugs"."status", "drugs"."indication", "drugs"."approval", "drugs"."clinicalstatus", "drugs"."phasedate", "drugs"."phase", "drugs"."moa", "drugs"."targetlevel", "drugs"."externallink", "drugs"."novelty", "drugs"."references" FROM "drugs" WHERE "drugs"."id" = 695
  177 similar queries.   Duplicated 177 times.
0.4861271754956524%
0.34

Connection: default

/usr/lib/python3.6/concurrent/futures/thread.py in _worker(69)
  work_item.run()
/usr/lib/python3.6/concurrent/futures/thread.py in run(56)
  result = self.fn(*self.args, **self.kwargs)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle(279)
  keepalive = self.handle_request(req, conn)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle_request(328)
  respiter = self.wsgi(environ, resp.start_response)
/home/protwis/gpcrdb_test/common/middleware/stats.py in __call__(34)
  response = self.get_response(request)
/home/protwis/gpcrdb_test/drugs/views.py in nhs_drug(423)
  queryname = i.drugname.name
  +
SELECT ••• "drugs"."id", "drugs"."name", "drugs"."synonym", "drugs"."drugtype", "drugs"."status", "drugs"."indication", "drugs"."approval", "drugs"."clinicalstatus", "drugs"."phasedate", "drugs"."phase", "drugs"."moa", "drugs"."targetlevel", "drugs"."externallink", "drugs"."novelty", "drugs"."references" FROM "drugs" WHERE "drugs"."id" = 695
  177 similar queries.   Duplicated 177 times.
0.49939446719917263%
0.35

Connection: default

/usr/lib/python3.6/concurrent/futures/thread.py in _worker(69)
  work_item.run()
/usr/lib/python3.6/concurrent/futures/thread.py in run(56)
  result = self.fn(*self.args, **self.kwargs)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle(279)
  keepalive = self.handle_request(req, conn)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle_request(328)
  respiter = self.wsgi(environ, resp.start_response)
/home/protwis/gpcrdb_test/common/middleware/stats.py in __call__(34)
  response = self.get_response(request)
/home/protwis/gpcrdb_test/drugs/views.py in nhs_drug(423)
  queryname = i.drugname.name
  +
SELECT ••• "drugs"."id", "drugs"."name", "drugs"."synonym", "drugs"."drugtype", "drugs"."status", "drugs"."indication", "drugs"."approval", "drugs"."clinicalstatus", "drugs"."phasedate", "drugs"."phase", "drugs"."moa", "drugs"."targetlevel", "drugs"."externallink", "drugs"."novelty", "drugs"."references" FROM "drugs" WHERE "drugs"."id" = 695
  177 similar queries.   Duplicated 177 times.
0.5687926084175863%
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/drugs/views.py in nhs_drug(423)
  queryname = i.drugname.name
  +
SELECT ••• "drugs"."id", "drugs"."name", "drugs"."synonym", "drugs"."drugtype", "drugs"."status", "drugs"."indication", "drugs"."approval", "drugs"."clinicalstatus", "drugs"."phasedate", "drugs"."phase", "drugs"."moa", "drugs"."targetlevel", "drugs"."externallink", "drugs"."novelty", "drugs"."references" FROM "drugs" WHERE "drugs"."id" = 695
  177 similar queries.   Duplicated 177 times.
0.5715141041516417%
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/drugs/views.py in nhs_drug(423)
  queryname = i.drugname.name
  +
SELECT ••• "drugs"."id", "drugs"."name", "drugs"."synonym", "drugs"."drugtype", "drugs"."status", "drugs"."indication", "drugs"."approval", "drugs"."clinicalstatus", "drugs"."phasedate", "drugs"."phase", "drugs"."moa", "drugs"."targetlevel", "drugs"."externallink", "drugs"."novelty", "drugs"."references" FROM "drugs" WHERE "drugs"."id" = 695
  177 similar queries.   Duplicated 177 times.
0.4653757705234797%
0.33

Connection: default

/usr/lib/python3.6/concurrent/futures/thread.py in _worker(69)
  work_item.run()
/usr/lib/python3.6/concurrent/futures/thread.py in run(56)
  result = self.fn(*self.args, **self.kwargs)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle(279)
  keepalive = self.handle_request(req, conn)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle_request(328)
  respiter = self.wsgi(environ, resp.start_response)
/home/protwis/gpcrdb_test/common/middleware/stats.py in __call__(34)
  response = self.get_response(request)
/home/protwis/gpcrdb_test/drugs/views.py in nhs_drug(423)
  queryname = i.drugname.name
  +
SELECT ••• "drugs"."id", "drugs"."name", "drugs"."synonym", "drugs"."drugtype", "drugs"."status", "drugs"."indication", "drugs"."approval", "drugs"."clinicalstatus", "drugs"."phasedate", "drugs"."phase", "drugs"."moa", "drugs"."targetlevel", "drugs"."externallink", "drugs"."novelty", "drugs"."references" FROM "drugs" WHERE "drugs"."id" = 695
  177 similar queries.   Duplicated 177 times.
0.47626175345970145%
0.33

Connection: default

/usr/lib/python3.6/concurrent/futures/thread.py in _worker(69)
  work_item.run()
/usr/lib/python3.6/concurrent/futures/thread.py in run(56)
  result = self.fn(*self.args, **self.kwargs)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle(279)
  keepalive = self.handle_request(req, conn)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle_request(328)
  respiter = self.wsgi(environ, resp.start_response)
/home/protwis/gpcrdb_test/common/middleware/stats.py in __call__(34)
  response = self.get_response(request)
/home/protwis/gpcrdb_test/drugs/views.py in nhs_drug(423)
  queryname = i.drugname.name
  +
SELECT ••• "drugs"."id", "drugs"."name", "drugs"."synonym", "drugs"."drugtype", "drugs"."status", "drugs"."indication", "drugs"."approval", "drugs"."clinicalstatus", "drugs"."phasedate", "drugs"."phase", "drugs"."moa", "drugs"."targetlevel", "drugs"."externallink", "drugs"."novelty", "drugs"."references" FROM "drugs" WHERE "drugs"."id" = 695
  177 similar queries.   Duplicated 177 times.
1.710119881887085%
1.20

Connection: default

/usr/lib/python3.6/concurrent/futures/thread.py in _worker(69)
  work_item.run()
/usr/lib/python3.6/concurrent/futures/thread.py in run(56)
  result = self.fn(*self.args, **self.kwargs)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle(279)
  keepalive = self.handle_request(req, conn)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle_request(328)
  respiter = self.wsgi(environ, resp.start_response)
/home/protwis/gpcrdb_test/common/middleware/stats.py in __call__(34)
  response = self.get_response(request)
/home/protwis/gpcrdb_test/drugs/views.py in nhs_drug(423)
  queryname = i.drugname.name
  +
SELECT ••• "drugs"."id", "drugs"."name", "drugs"."synonym", "drugs"."drugtype", "drugs"."status", "drugs"."indication", "drugs"."approval", "drugs"."clinicalstatus", "drugs"."phasedate", "drugs"."phase", "drugs"."moa", "drugs"."targetlevel", "drugs"."externallink", "drugs"."novelty", "drugs"."references" FROM "drugs" WHERE "drugs"."id" = 695
  177 similar queries.   Duplicated 177 times.
0.47320007075888915%
0.33

Connection: default

/usr/lib/python3.6/concurrent/futures/thread.py in _worker(69)
  work_item.run()
/usr/lib/python3.6/concurrent/futures/thread.py in run(56)
  result = self.fn(*self.args, **self.kwargs)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle(279)
  keepalive = self.handle_request(req, conn)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle_request(328)
  respiter = self.wsgi(environ, resp.start_response)
/home/protwis/gpcrdb_test/common/middleware/stats.py in __call__(34)
  response = self.get_response(request)
/home/protwis/gpcrdb_test/drugs/views.py in nhs_drug(423)
  queryname = i.drugname.name
  +
SELECT ••• "drugs"."id", "drugs"."name", "drugs"."synonym", "drugs"."drugtype", "drugs"."status", "drugs"."indication", "drugs"."approval", "drugs"."clinicalstatus", "drugs"."phasedate", "drugs"."phase", "drugs"."moa", "drugs"."targetlevel", "drugs"."externallink", "drugs"."novelty", "drugs"."references" FROM "drugs" WHERE "drugs"."id" = 695
  177 similar queries.   Duplicated 177 times.
0.4561907224210426%
0.32

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/drugs/views.py in nhs_drug(423)
  queryname = i.drugname.name
  +
SELECT ••• "drugs"."id", "drugs"."name", "drugs"."synonym", "drugs"."drugtype", "drugs"."status", "drugs"."indication", "drugs"."approval", "drugs"."clinicalstatus", "drugs"."phasedate", "drugs"."phase", "drugs"."moa", "drugs"."targetlevel", "drugs"."externallink", "drugs"."novelty", "drugs"."references" FROM "drugs" WHERE "drugs"."id" = 695
  177 similar queries.   Duplicated 177 times.
0.5517832600797399%
0.39

Connection: default

/usr/lib/python3.6/concurrent/futures/thread.py in _worker(69)
  work_item.run()
/usr/lib/python3.6/concurrent/futures/thread.py in run(56)
  result = self.fn(*self.args, **self.kwargs)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle(279)
  keepalive = self.handle_request(req, conn)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle_request(328)
  respiter = self.wsgi(environ, resp.start_response)
/home/protwis/gpcrdb_test/common/middleware/stats.py in __call__(34)
  response = self.get_response(request)
/home/protwis/gpcrdb_test/drugs/views.py in nhs_drug(423)
  queryname = i.drugname.name
  +
SELECT ••• "drugs"."id", "drugs"."name", "drugs"."synonym", "drugs"."drugtype", "drugs"."status", "drugs"."indication", "drugs"."approval", "drugs"."clinicalstatus", "drugs"."phasedate", "drugs"."phase", "drugs"."moa", "drugs"."targetlevel", "drugs"."externallink", "drugs"."novelty", "drugs"."references" FROM "drugs" WHERE "drugs"."id" = 695
  177 similar queries.   Duplicated 177 times.
0.5004150280994435%
0.35

Connection: default

/usr/lib/python3.6/concurrent/futures/thread.py in _worker(69)
  work_item.run()
/usr/lib/python3.6/concurrent/futures/thread.py in run(56)
  result = self.fn(*self.args, **self.kwargs)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle(279)
  keepalive = self.handle_request(req, conn)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle_request(328)
  respiter = self.wsgi(environ, resp.start_response)
/home/protwis/gpcrdb_test/common/middleware/stats.py in __call__(34)
  response = self.get_response(request)
/home/protwis/gpcrdb_test/drugs/views.py in nhs_drug(423)
  queryname = i.drugname.name
  +
SELECT ••• "drugs"."id", "drugs"."name", "drugs"."synonym", "drugs"."drugtype", "drugs"."status", "drugs"."indication", "drugs"."approval", "drugs"."clinicalstatus", "drugs"."phasedate", "drugs"."phase", "drugs"."moa", "drugs"."targetlevel", "drugs"."externallink", "drugs"."novelty", "drugs"."references" FROM "drugs" WHERE "drugs"."id" = 695
  177 similar queries.   Duplicated 177 times.
0.44598511341833474%
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/drugs/views.py in nhs_drug(423)
  queryname = i.drugname.name
  +
SELECT ••• "drugs"."id", "drugs"."name", "drugs"."synonym", "drugs"."drugtype", "drugs"."status", "drugs"."indication", "drugs"."approval", "drugs"."clinicalstatus", "drugs"."phasedate", "drugs"."phase", "drugs"."moa", "drugs"."targetlevel", "drugs"."externallink", "drugs"."novelty", "drugs"."references" FROM "drugs" WHERE "drugs"."id" = 695
  177 similar queries.   Duplicated 177 times.
0.45040754398617483%
0.32

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/drugs/views.py in nhs_drug(423)
  queryname = i.drugname.name
  +
SELECT ••• "drugs"."id", "drugs"."name", "drugs"."synonym", "drugs"."drugtype", "drugs"."status", "drugs"."indication", "drugs"."approval", "drugs"."clinicalstatus", "drugs"."phasedate", "drugs"."phase", "drugs"."moa", "drugs"."targetlevel", "drugs"."externallink", "drugs"."novelty", "drugs"."references" FROM "drugs" WHERE "drugs"."id" = 695
  177 similar queries.   Duplicated 177 times.
0.5626692430159616%
0.39

Connection: default

/usr/lib/python3.6/concurrent/futures/thread.py in _worker(69)
  work_item.run()
/usr/lib/python3.6/concurrent/futures/thread.py in run(56)
  result = self.fn(*self.args, **self.kwargs)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle(279)
  keepalive = self.handle_request(req, conn)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle_request(328)
  respiter = self.wsgi(environ, resp.start_response)
/home/protwis/gpcrdb_test/common/middleware/stats.py in __call__(34)
  response = self.get_response(request)
/home/protwis/gpcrdb_test/drugs/views.py in nhs_drug(423)
  queryname = i.drugname.name
  +
SELECT ••• "drugs"."id", "drugs"."name", "drugs"."synonym", "drugs"."drugtype", "drugs"."status", "drugs"."indication", "drugs"."approval", "drugs"."clinicalstatus", "drugs"."phasedate", "drugs"."phase", "drugs"."moa", "drugs"."targetlevel", "drugs"."externallink", "drugs"."novelty", "drugs"."references" FROM "drugs" WHERE "drugs"."id" = 695
  177 similar queries.   Duplicated 177 times.
0.5528038209800106%
0.39

Connection: default

/usr/lib/python3.6/concurrent/futures/thread.py in _worker(69)
  work_item.run()
/usr/lib/python3.6/concurrent/futures/thread.py in run(56)
  result = self.fn(*self.args, **self.kwargs)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle(279)
  keepalive = self.handle_request(req, conn)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle_request(328)
  respiter = self.wsgi(environ, resp.start_response)
/home/protwis/gpcrdb_test/common/middleware/stats.py in __call__(34)
  response = self.get_response(request)
/home/protwis/gpcrdb_test/drugs/views.py in nhs_drug(423)
  queryname = i.drugname.name
  +
SELECT ••• "drugs"."id", "drugs"."name", "drugs"."synonym", "drugs"."drugtype", "drugs"."status", "drugs"."indication", "drugs"."approval", "drugs"."clinicalstatus", "drugs"."phasedate", "drugs"."phase", "drugs"."moa", "drugs"."targetlevel", "drugs"."externallink", "drugs"."novelty", "drugs"."references" FROM "drugs" WHERE "drugs"."id" = 695
  177 similar queries.   Duplicated 177 times.
0.46197390085591045%
0.32

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/drugs/views.py in nhs_drug(423)
  queryname = i.drugname.name
  +
SELECT ••• "drugs"."id", "drugs"."name", "drugs"."synonym", "drugs"."drugtype", "drugs"."status", "drugs"."indication", "drugs"."approval", "drugs"."clinicalstatus", "drugs"."phasedate", "drugs"."phase", "drugs"."moa", "drugs"."targetlevel", "drugs"."externallink", "drugs"."novelty", "drugs"."references" FROM "drugs" WHERE "drugs"."id" = 695
  177 similar queries.   Duplicated 177 times.
0.41672903427723873%
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/drugs/views.py in nhs_drug(423)
  queryname = i.drugname.name
  +
SELECT ••• "drugs"."id", "drugs"."name", "drugs"."synonym", "drugs"."drugtype", "drugs"."status", "drugs"."indication", "drugs"."approval", "drugs"."clinicalstatus", "drugs"."phasedate", "drugs"."phase", "drugs"."moa", "drugs"."targetlevel", "drugs"."externallink", "drugs"."novelty", "drugs"."references" FROM "drugs" WHERE "drugs"."id" = 695
  177 similar queries.   Duplicated 177 times.
0.47149913592510445%
0.33

Connection: default

/usr/lib/python3.6/concurrent/futures/thread.py in _worker(69)
  work_item.run()
/usr/lib/python3.6/concurrent/futures/thread.py in run(56)
  result = self.fn(*self.args, **self.kwargs)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle(279)
  keepalive = self.handle_request(req, conn)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle_request(328)
  respiter = self.wsgi(environ, resp.start_response)
/home/protwis/gpcrdb_test/common/middleware/stats.py in __call__(34)
  response = self.get_response(request)
/home/protwis/gpcrdb_test/drugs/views.py in nhs_drug(423)
  queryname = i.drugname.name
  +
SELECT ••• "drugs"."id", "drugs"."name", "drugs"."synonym", "drugs"."drugtype", "drugs"."status", "drugs"."indication", "drugs"."approval", "drugs"."clinicalstatus", "drugs"."phasedate", "drugs"."phase", "drugs"."moa", "drugs"."targetlevel", "drugs"."externallink", "drugs"."novelty", "drugs"."references" FROM "drugs" WHERE "drugs"."id" = 695
  177 similar queries.   Duplicated 177 times.
0.4745608186259168%
0.33

Connection: default

/usr/lib/python3.6/concurrent/futures/thread.py in _worker(69)
  work_item.run()
/usr/lib/python3.6/concurrent/futures/thread.py in run(56)
  result = self.fn(*self.args, **self.kwargs)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle(279)
  keepalive = self.handle_request(req, conn)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle_request(328)
  respiter = self.wsgi(environ, resp.start_response)
/home/protwis/gpcrdb_test/common/middleware/stats.py in __call__(34)
  response = self.get_response(request)
/home/protwis/gpcrdb_test/drugs/views.py in nhs_drug(423)
  queryname = i.drugname.name
  +
SELECT ••• "drugs"."id", "drugs"."name", "drugs"."synonym", "drugs"."drugtype", "drugs"."status", "drugs"."indication", "drugs"."approval", "drugs"."clinicalstatus", "drugs"."phasedate", "drugs"."phase", "drugs"."moa", "drugs"."targetlevel", "drugs"."externallink", "drugs"."novelty", "drugs"."references" FROM "drugs" WHERE "drugs"."id" = 695
  177 similar queries.   Duplicated 177 times.
0.594306630924356%
0.42

Connection: default

/usr/lib/python3.6/concurrent/futures/thread.py in _worker(69)
  work_item.run()
/usr/lib/python3.6/concurrent/futures/thread.py in run(56)
  result = self.fn(*self.args, **self.kwargs)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle(279)
  keepalive = self.handle_request(req, conn)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle_request(328)
  respiter = self.wsgi(environ, resp.start_response)
/home/protwis/gpcrdb_test/common/middleware/stats.py in __call__(34)
  response = self.get_response(request)
/home/protwis/gpcrdb_test/drugs/views.py in nhs_drug(423)
  queryname = i.drugname.name
  +
SELECT ••• "drugs"."id", "drugs"."name", "drugs"."synonym", "drugs"."drugtype", "drugs"."status", "drugs"."indication", "drugs"."approval", "drugs"."clinicalstatus", "drugs"."phasedate", "drugs"."phase", "drugs"."moa", "drugs"."targetlevel", "drugs"."externallink", "drugs"."novelty", "drugs"."references" FROM "drugs" WHERE "drugs"."id" = 695
  177 similar queries.   Duplicated 177 times.
0.5674318605505586%
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/drugs/views.py in nhs_drug(423)
  queryname = i.drugname.name
  +
SELECT ••• "drugs"."id", "drugs"."name", "drugs"."synonym", "drugs"."drugtype", "drugs"."status", "drugs"."indication", "drugs"."approval", "drugs"."clinicalstatus", "drugs"."phasedate", "drugs"."phase", "drugs"."moa", "drugs"."targetlevel", "drugs"."externallink", "drugs"."novelty", "drugs"."references" FROM "drugs" WHERE "drugs"."id" = 695
  177 similar queries.   Duplicated 177 times.
0.5599477472819061%
0.39

Connection: default

/usr/lib/python3.6/concurrent/futures/thread.py in _worker(69)
  work_item.run()
/usr/lib/python3.6/concurrent/futures/thread.py in run(56)
  result = self.fn(*self.args, **self.kwargs)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle(279)
  keepalive = self.handle_request(req, conn)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle_request(328)
  respiter = self.wsgi(environ, resp.start_response)
/home/protwis/gpcrdb_test/common/middleware/stats.py in __call__(34)
  response = self.get_response(request)
/home/protwis/gpcrdb_test/drugs/views.py in nhs_drug(423)
  queryname = i.drugname.name
  +
SELECT ••• "drugs"."id", "drugs"."name", "drugs"."synonym", "drugs"."drugtype", "drugs"."status", "drugs"."indication", "drugs"."approval", "drugs"."clinicalstatus", "drugs"."phasedate", "drugs"."phase", "drugs"."moa", "drugs"."targetlevel", "drugs"."externallink", "drugs"."novelty", "drugs"."references" FROM "drugs" WHERE "drugs"."id" = 695
  177 similar queries.   Duplicated 177 times.
0.4847664276286247%
0.34

Connection: default

/usr/lib/python3.6/concurrent/futures/thread.py in _worker(69)
  work_item.run()
/usr/lib/python3.6/concurrent/futures/thread.py in run(56)
  result = self.fn(*self.args, **self.kwargs)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle(279)
  keepalive = self.handle_request(req, conn)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle_request(328)
  respiter = self.wsgi(environ, resp.start_response)
/home/protwis/gpcrdb_test/common/middleware/stats.py in __call__(34)
  response = self.get_response(request)
/home/protwis/gpcrdb_test/drugs/views.py in nhs_drug(423)
  queryname = i.drugname.name
  +
SELECT ••• "drugs"."id", "drugs"."name", "drugs"."synonym", "drugs"."drugtype", "drugs"."status", "drugs"."indication", "drugs"."approval", "drugs"."clinicalstatus", "drugs"."phasedate", "drugs"."phase", "drugs"."moa", "drugs"."targetlevel", "drugs"."externallink", "drugs"."novelty", "drugs"."references" FROM "drugs" WHERE "drugs"."id" = 695
  177 similar queries.   Duplicated 177 times.
0.5824000870878635%
0.41

Connection: default

/usr/lib/python3.6/concurrent/futures/thread.py in _worker(69)
  work_item.run()
/usr/lib/python3.6/concurrent/futures/thread.py in run(56)
  result = self.fn(*self.args, **self.kwargs)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle(279)
  keepalive = self.handle_request(req, conn)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle_request(328)
  respiter = self.wsgi(environ, resp.start_response)
/home/protwis/gpcrdb_test/common/middleware/stats.py in __call__(34)
  response = self.get_response(request)
/home/protwis/gpcrdb_test/drugs/views.py in nhs_drug(423)
  queryname = i.drugname.name
  +
SELECT ••• "drugs"."id", "drugs"."name", "drugs"."synonym", "drugs"."drugtype", "drugs"."status", "drugs"."indication", "drugs"."approval", "drugs"."clinicalstatus", "drugs"."phasedate", "drugs"."phase", "drugs"."moa", "drugs"."targetlevel", "drugs"."externallink", "drugs"."novelty", "drugs"."references" FROM "drugs" WHERE "drugs"."id" = 695
  177 similar queries.   Duplicated 177 times.
0.487828110329437%
0.34

Connection: default

/usr/lib/python3.6/concurrent/futures/thread.py in _worker(69)
  work_item.run()
/usr/lib/python3.6/concurrent/futures/thread.py in run(56)
  result = self.fn(*self.args, **self.kwargs)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle(279)
  keepalive = self.handle_request(req, conn)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle_request(328)
  respiter = self.wsgi(environ, resp.start_response)
/home/protwis/gpcrdb_test/common/middleware/stats.py in __call__(34)
  response = self.get_response(request)
/home/protwis/gpcrdb_test/drugs/views.py in nhs_drug(423)
  queryname = i.drugname.name
  +
SELECT ••• "drugs"."id", "drugs"."name", "drugs"."synonym", "drugs"."drugtype", "drugs"."status", "drugs"."indication", "drugs"."approval", "drugs"."clinicalstatus", "drugs"."phasedate", "drugs"."phase", "drugs"."moa", "drugs"."targetlevel", "drugs"."externallink", "drugs"."novelty", "drugs"."references" FROM "drugs" WHERE "drugs"."id" = 695
  177 similar queries.   Duplicated 177 times.
0.5830804610213773%
0.41

Connection: default

/usr/lib/python3.6/concurrent/futures/thread.py in _worker(69)
  work_item.run()
/usr/lib/python3.6/concurrent/futures/thread.py in run(56)
  result = self.fn(*self.args, **self.kwargs)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle(279)
  keepalive = self.handle_request(req, conn)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle_request(328)
  respiter = self.wsgi(environ, resp.start_response)
/home/protwis/gpcrdb_test/common/middleware/stats.py in __call__(34)
  response = self.get_response(request)
/home/protwis/gpcrdb_test/drugs/views.py in nhs_drug(423)
  queryname = i.drugname.name
  +
SELECT ••• "drugs"."id", "drugs"."name", "drugs"."synonym", "drugs"."drugtype", "drugs"."status", "drugs"."indication", "drugs"."approval", "drugs"."clinicalstatus", "drugs"."phasedate", "drugs"."phase", "drugs"."moa", "drugs"."targetlevel", "drugs"."externallink", "drugs"."novelty", "drugs"."references" FROM "drugs" WHERE "drugs"."id" = 695
  177 similar queries.   Duplicated 177 times.
0.5636898039162324%
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/drugs/views.py in nhs_drug(423)
  queryname = i.drugname.name
  +
SELECT ••• "drugs"."id", "drugs"."name", "drugs"."synonym", "drugs"."drugtype", "drugs"."status", "drugs"."indication", "drugs"."approval", "drugs"."clinicalstatus", "drugs"."phasedate", "drugs"."phase", "drugs"."moa", "drugs"."targetlevel", "drugs"."externallink", "drugs"."novelty", "drugs"."references" FROM "drugs" WHERE "drugs"."id" = 695
  177 similar queries.   Duplicated 177 times.
0.4854468015621386%
0.34

Connection: default

/usr/lib/python3.6/concurrent/futures/thread.py in _worker(69)
  work_item.run()
/usr/lib/python3.6/concurrent/futures/thread.py in run(56)
  result = self.fn(*self.args, **self.kwargs)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle(279)
  keepalive = self.handle_request(req, conn)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle_request(328)
  respiter = self.wsgi(environ, resp.start_response)
/home/protwis/gpcrdb_test/common/middleware/stats.py in __call__(34)
  response = self.get_response(request)
/home/protwis/gpcrdb_test/drugs/views.py in nhs_drug(423)
  queryname = i.drugname.name
  +
SELECT ••• "drugs"."id", "drugs"."name", "drugs"."synonym", "drugs"."drugtype", "drugs"."status", "drugs"."indication", "drugs"."approval", "drugs"."clinicalstatus", "drugs"."phasedate", "drugs"."phase", "drugs"."moa", "drugs"."targetlevel", "drugs"."externallink", "drugs"."novelty", "drugs"."references" FROM "drugs" WHERE "drugs"."id" = 695
  177 similar queries.   Duplicated 177 times.
0.5619888690824477%
0.39

Connection: default

/usr/lib/python3.6/concurrent/futures/thread.py in _worker(69)
  work_item.run()
/usr/lib/python3.6/concurrent/futures/thread.py in run(56)
  result = self.fn(*self.args, **self.kwargs)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle(279)
  keepalive = self.handle_request(req, conn)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle_request(328)
  respiter = self.wsgi(environ, resp.start_response)
/home/protwis/gpcrdb_test/common/middleware/stats.py in __call__(34)
  response = self.get_response(request)
/home/protwis/gpcrdb_test/drugs/views.py in nhs_drug(423)
  queryname = i.drugname.name
  +
SELECT ••• "drugs"."id", "drugs"."name", "drugs"."synonym", "drugs"."drugtype", "drugs"."status", "drugs"."indication", "drugs"."approval", "drugs"."clinicalstatus", "drugs"."phasedate", "drugs"."phase", "drugs"."moa", "drugs"."targetlevel", "drugs"."externallink", "drugs"."novelty", "drugs"."references" FROM "drugs" WHERE "drugs"."id" = 695
  177 similar queries.   Duplicated 177 times.
0.5007552150662004%
0.35

Connection: default

/usr/lib/python3.6/concurrent/futures/thread.py in _worker(69)
  work_item.run()
/usr/lib/python3.6/concurrent/futures/thread.py in run(56)
  result = self.fn(*self.args, **self.kwargs)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle(279)
  keepalive = self.handle_request(req, conn)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle_request(328)
  respiter = self.wsgi(environ, resp.start_response)
/home/protwis/gpcrdb_test/common/middleware/stats.py in __call__(34)
  response = self.get_response(request)
/home/protwis/gpcrdb_test/drugs/views.py in nhs_drug(423)
  queryname = i.drugname.name
  +
SELECT ••• "drugs"."id", "drugs"."name", "drugs"."synonym", "drugs"."drugtype", "drugs"."status", "drugs"."indication", "drugs"."approval", "drugs"."clinicalstatus", "drugs"."phasedate", "drugs"."phase", "drugs"."moa", "drugs"."targetlevel", "drugs"."externallink", "drugs"."novelty", "drugs"."references" FROM "drugs" WHERE "drugs"."id" = 695
  177 similar queries.   Duplicated 177 times.
0.5732150389854264%
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/drugs/views.py in nhs_drug