ジョブ別のVistar

表示するジョブを選択 カテゴリごとのVistarの一覧をご確認いただけます。

Basical Job / 基本ジョブ(フリーカテゴリ)
Act Universss / アクト・ユニバース(俳優・女優・演劇)
Film Universss / フィルム・ユニバース(映画・ドラマ・ビデオ撮影)
Visual Universss / ヴィジュアル・ユニバース(映像・視覚効果・アニメーション)
Story Universss / ストーリー・ユニバース(物語・出版)
Sports Universss / スポーツ・ユニバース(アスリート)
Music Universss / ミュージック・ユニバース(音楽)
Fashion Universss / ファッション・ユニバース(衣服・メイク・アクセサリー)
Cook Universss / クック・ユニバース(料理)
Life Style Universss / ライフスタイル・ユニバース(生活環境・生活様式)
Medical Universss / メディカル・ユニバース(医療・医学)
Art Universss / アート・ユニバース(芸術)
Nature Universss / ネイチャー・ユニバース(自然・植物・動物)
Virtual Universss / バーチャル・ユニバース(ウェブ、インターネット)
Game Universss / ゲーム・ユニバース(試合)
Education Universss / エデュケーション・ユニバース(教育)
Business Universss / ビジネス・ユニバース(事業)
役者 Actor
mariekai
Marie kai
甲斐 まり恵
役者 Actor
東京
ooba
Yoshikatu Ooba
大羽 良克 46歳
役者 Actor
どこでも行きます!
seiji430222
hanasiro seiji
花城誠治 51歳
役者 Actor
東京, 神奈川
momokokato
Momoko Kato
加藤 桃子 35歳
役者 Actor
東京, 神奈川, 愛知
YoshiKuroiwa
Yoshi Kuroiwa
黒岩よし 44歳
役者 Actor
東京, 大阪
aizwamatu1996
Yoshiki Suga
須賀 芳紀 24歳
役者 Actor
非公開
rise_kuze
Rise Kuze
久世 理瀬
役者 Actor
東京, 神奈川
miyawaki
Yusuke Miyawaki
みやわき ゆうすけ 37歳
役者 Actor
埼玉, 東京, 神奈川
noriinu
rino aoi
碧井 りの
役者 Actor
東京, 神奈川
matsushima
KEIJIRO MATSUSHIMA
松島 圭志郎 38歳
役者 Actor
東京
kosekikana
kana koseki
小関 可奈 48歳
役者 Actor
埼玉, 東京, 神奈川
ayumi-saotome
Ayumi Saotome
五月女 歩美 25歳
役者 Actor
東京, 神奈川
mumei
Michihiro Yoshida
吉田 道広 27歳
役者 Actor
東京, 神奈川
tongasunrise
Tonga Takayama
高山 トンガ 52歳
役者 Actor
全国・全世界何処にでもニーズがあれば行きます!
yuto_monsteractor
yuto suzuki
鈴木 雄登 23歳
役者 Actor
千葉
もっと見る
スタッフ注目のVistar
«

Versions

Package Name Version
Django 2.1.5
Python 3.6.4
debug_toolbar Debug Toolbar 1.11
django_extensions Django_Extensions 2.1.4
storages Storages 1.7.1

時刻

Resource usage

Resource Value
User CPU time 5472.000 msec
System CPU time 152.000 msec
Total CPU time 5624.000 msec
Elapsed time 5739.894 msec
Context switches 227 voluntary, 13 involuntary

Browser timing

Timing attribute Timeline Milliseconds since navigation start (+length)

Settings from vistar.settings

Setting Value
ABSOLUTE_URL_OVERRIDES {}
ADMINS (('developer', 'vistar@lion-garden.com'),)
ALLOWED_HOSTS ['127.0.0.1', 'dev.vistar.world', 'vistar.world']
APPEND_SLASH True
AUTHENTICATION_BACKENDS {'django.contrib.auth.backends.ModelBackend'}
AUTH_PASSWORD_VALIDATORS '********************'
AUTH_USER_MODEL 'accounts.CustomUser'
AWS_ACCESS_KEY_ID '********************'
AWS_DEFAULT_ACL 'public-read'
AWS_LOCATION 'media'
AWS_S3_CUSTOM_DOMAIN 's3-ap-northeast-1.amazonaws.com/test.cdn.vistar.world'
AWS_SECRET_ACCESS_KEY '********************'
AWS_STORAGE_BUCKET_NAME 'test.cdn.vistar.world'
AWS_UPLOAD_REGION 'ap-northeast-1'
BASE_DIR '/app/vistar'
BROKER_URL ''
CACHES {'default': {'BACKEND': 'django_redis.cache.RedisCache', 'LOCATION': 'redis://127.0.0.1:6379/1', 'OPTIONS': {'CLIENT_CLASS': 'django_redis.client.DefaultClient'}}}
CACHE_MIDDLEWARE_ALIAS 'default'
CACHE_MIDDLEWARE_KEY_PREFIX '********************'
CACHE_MIDDLEWARE_SECONDS 60
CELERY_ACCEPT_CONTENT ['appllication/json']
CELERY_ENABLE_UTC True
CELERY_RESULT_BACKEND ''
CELERY_RESULT_SERIALIZER 'json'
CELERY_SEND_TASK_ERROR_EMAILS True
CELERY_TASK_SERIALIZER 'json'
CELERY_TIMEZONE 'Asia/Tokyo'
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.mysql', 'HOST': '10.0.168.176', 'NAME': 'vistar', 'OPTIONS': {}, 'PASSWORD': '********************', 'PORT': '', 'TEST': {'CHARSET': None, 'COLLATION': None, 'MIRROR': None, 'NAME': None}, 'TIME_ZONE': None, 'USER': 'vistar'}}
DATABASE_ROUTERS []
DATA_UPLOAD_MAX_MEMORY_SIZE 524288000
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 1
DEBUG_PROPAGATE_EXCEPTIONS False
DEBUG_TOOLBAR_PANELS ['debug_toolbar.panels.versions.VersionsPanel', 'debug_toolbar.panels.timer.TimerPanel', 'debug_toolbar.panels.settings.SettingsPanel', 'debug_toolbar.panels.headers.HeadersPanel', 'debug_toolbar.panels.profiling.ProfilingPanel', 'debug_toolbar.panels.request.RequestPanel', 'debug_toolbar.panels.sql.SQLPanel', 'debug_toolbar.panels.staticfiles.StaticFilesPanel', 'debug_toolbar.panels.templates.TemplatesPanel', 'debug_toolbar.panels.cache.CachePanel', 'debug_toolbar.panels.signals.SignalsPanel', 'debug_toolbar.panels.logging.LoggingPanel', 'debug_toolbar.panels.redirects.RedirectsPanel']
DECIMAL_SEPARATOR '.'
DEFAULT_CHARSET 'utf-8'
DEFAULT_CONTENT_TYPE 'text/html'
DEFAULT_EXCEPTION_REPORTER_FILTER 'django.views.debug.SafeExceptionReporterFilter'
DEFAULT_FILE_STORAGE 'vistar.storage_backends.MediaStorage'
DEFAULT_FROM_EMAIL 'vistar@kiyoshi-kurahara.com'
DEFAULT_INDEX_TABLESPACE ''
DEFAULT_TABLESPACE ''
DISALLOWED_USER_AGENTS []
EMAIL_BACKEND 'django.core.mail.backends.smtp.EmailBackend'
EMAIL_HOST 'smtp.muumuu-mail.com'
EMAIL_HOST_PASSWORD '********************'
EMAIL_HOST_USER 'vistar@kiyoshi-kurahara.com'
EMAIL_PORT '465'
EMAIL_SSL_CERTFILE None
EMAIL_SSL_KEYFILE '********************'
EMAIL_SUBJECT_PREFIX '[Django] '
EMAIL_TIMEOUT None
EMAIL_USE_LOCALTIME False
EMAIL_USE_SSL 'True'
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.TemplatesSetting'
IGNORABLE_404_URLS []
INSTALLED_APPS ['accounts', 'search', 'django.contrib.admin', 'django.contrib.auth', 'django.contrib.contenttypes', 'django.contrib.sessions', 'django.contrib.messages', 'django.contrib.staticfiles', 'debug_toolbar.apps.DebugToolbarConfig', 'django_extensions', 'django.forms', 'storages']
INTERNAL_IPS ['127.0.0.1']
LANGUAGES ('ja-jp', 'Japanese')
LANGUAGES_BIDI ['he', 'ar', 'fa', 'ur']
LANGUAGE_CODE 'ja'
LANGUAGE_COOKIE_AGE None
LANGUAGE_COOKIE_DOMAIN None
LANGUAGE_COOKIE_NAME 'django_language'
LANGUAGE_COOKIE_PATH '/'
LOCALE_PATHS []
LOGGING {'disable_existing_loggers': False, 'filters': {'require_debug_false': {'()': 'django.utils.log.RequireDebugFalse'}}, 'formatters': {'simple': {'format': '%(levelname)s %(message)s'}, 'verbose': {'format': '%(levelname)s %(asctime)s %(module)s ' '%(process)d %(thread)d %(message)s'}}, 'handlers': {'console': {'class': 'logging.StreamHandler', 'formatter': 'simple', 'level': 'DEBUG'}, 'file_output': {'backupCount': 5, 'class': 'logging.handlers.RotatingFileHandler', 'filename': '/app/vistar/log/vistar.log', 'formatter': 'verbose', 'level': 'INFO', 'maxBytes': 1048576}, 'mail_admins': {'class': 'django.utils.log.AdminEmailHandler', 'filters': ['require_debug_false'], 'include_html': True, 'level': 'ERROR'}, 'null': {'class': 'logging.NullHandler', 'level': 'DEBUG'}, 'payment_output': {'backupCount': 5, 'class': 'logging.handlers.RotatingFileHandler', 'filename': '/app/vistar/log/payment.log', 'formatter': 'verbose', 'level': 'INFO', 'maxBytes': 1048576}}, 'loggers': {'django': {'handlers': ['null'], 'level': 'INFO', 'propagate': True}, 'django.request': {'handlers': ['mail_admins'], 'level': 'ERROR', 'propagate': True}, 'payment': {'handlers': ['payment_output'], 'level': 'INFO', 'propagate': True}, 'vistar': {'handlers': ['file_output'], 'level': 'INFO', 'propagate': True}}, 'version': 1}
LOGGING_CONFIG 'logging.config.dictConfig'
LOGIN_REDIRECT_URL '/'
LOGIN_URL '/login/'
LOGOUT_REDIRECT_URL None
MANAGERS (('vistar member', 'vistar@lion-garden.com'),)
MEDIAFILES_STORAGE 'storages.backends.s3boto3.S3Boto3Storage'
MEDIA_ROOT '/app/vistar/media'
MEDIA_URL 'https://s3-ap-northeast-1.amazonaws.com/test.cdn.vistar.world/media/'
MESSAGE_STORAGE 'django.contrib.messages.storage.fallback.FallbackStorage'
MIDDLEWARE ['django.middleware.security.SecurityMiddleware', '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', 'debug_toolbar.middleware.DebugToolbarMiddleware']
MIGRATION_MODULES {}
MONTH_DAY_FORMAT 'F j'
NUMBER_GROUPING 0
PASSWORD_HASHERS '********************'
PASSWORD_RESET_TIMEOUT_DAYS '********************'
PREPEND_WWW False
PROJECT_APP 'vistar'
PROJECT_APP_PATH '/app/vistar/vistar'
PROJECT_ROOT '/app/vistar'
ROOT_URLCONF 'vistar.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 ('HTTP_X_FORWARDED_PROTOCOL', 'https')
SECURE_REDIRECT_EXEMPT []
SECURE_SSL_HOST None
SECURE_SSL_REDIRECT False
SERVER_EMAIL 'root@localhost'
SESSION_CACHE_ALIAS 'default'
SESSION_COOKIE_AGE 1209600
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.cache'
SESSION_EXPIRE_AT_BROWSER_CLOSE False
SESSION_FILE_PATH None
SESSION_SAVE_EVERY_REQUEST False
SESSION_SERIALIZER 'django.contrib.sessions.serializers.JSONSerializer'
SETTINGS_MODULE 'vistar.settings'
SHORT_DATETIME_FORMAT 'm/d/Y P'
SHORT_DATE_FORMAT 'm/d/Y'
SIGNING_BACKEND 'django.core.signing.TimestampSigner'
SILENCED_SYSTEM_CHECKS []
STATICFILES_DIRS ['/app/vistar/static']
STATICFILES_FINDERS ['django.contrib.staticfiles.finders.FileSystemFinder', 'django.contrib.staticfiles.finders.AppDirectoriesFinder']
STATICFILES_STORAGE 'django.contrib.staticfiles.storage.StaticFilesStorage'
STATIC_ROOT None
STATIC_URL '/static/'
TEMPLATES [{'APP_DIRS': True, 'BACKEND': 'django.template.backends.django.DjangoTemplates', 'DIRS': ['/app/vistar/templates'], 'OPTIONS': {'context_processors': ['django.template.context_processors.debug', 'django.template.context_processors.request', 'django.contrib.auth.context_processors.auth', 'django.contrib.messages.context_processors.messages']}}]
TEMPLATE_CONTEXT_PROCESSORS ('django.contrib.auth.context_processors.auth', 'django.core.context_processors.csrf', 'django.core.context_processors.debug', 'django.core.context_processors.i18n', 'django.core.context_processors.media', 'django.core.context_processors.static', 'django.contrib.messages.context_processors.messages', 'django.core.context_processors.request')
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 'Asia/Tokyo'
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 'vistar.wsgi.application'
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 vistar.world
User-Agent CCBot/2.0 (https://commoncrawl.org/faq/)
X-Forwarded-For 3.214.224.224
X-Forwarded-Proto https
X-Real-Ip 3.214.224.224

Response headers

Key Value
Content-Type text/html; charset=utf-8

WSGI environ

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

Key Value
PATH_INFO /
QUERY_STRING
REMOTE_ADDR 127.0.0.1
REQUEST_METHOD GET
SCRIPT_NAME
SERVER_NAME 127.0.0.1
SERVER_PORT 8001
SERVER_PROTOCOL HTTP/1.0
SERVER_SOFTWARE gunicorn/19.8.1

Profiling

Call CumTime Per TotTime Per Count
- /app/vistar/home/views.py in index(55)
4.855 4.855 0.000 0.000 1
- /django/shortcuts.py in render(31)
4.795 4.795 0.000 0.000 1
- /django/template/loader.py in render_to_string(52)
4.794 4.794 0.000 0.000 1
- /django/template/backends/django.py in render(58)
4.789 4.789 0.000 0.000 1
- /django/template/base.py in render(165)
4.789 0.087 0.001 0.001 1
- /django/test/utils.py in instrumented_test_render(90)
4.789 0.018 0.001 0.001 1
- /django/template/base.py in render(933)
4.786 0.018 0.004 0.004 1
- /django/template/base.py in render_annotated(896)
4.786 0.001 0.003 0.003 1
- /django/template/base.py in render(985)
1.127 0.000 0.004 0.000 2823
- /django/template/base.py in resolve(668)
1.062 0.000 0.005 0.000 2849
/django/template/base.py in resolve(792)
2.925 0.001 0.004 0.000 4212
/django/template/defaultfilters.py in join(524)
0.780 0.021 0.000 0.000 38
- /django/template/loader_tags.py in render(48)
4.776 4.776 0.000 0.000 1
- /django/template/base.py in render(933)
4.776 4.776 0.000 0.000 1
/django/template/base.py in render_annotated(896)
4.786 0.001 0.003 0.003 1
- /django/template/defaulttags.py in render(155)
4.755 0.049 0.009 0.001 12
- {built-in method builtins.len}
0.879 0.003 0.000 0.000 253
/django/db/models/query.py in __len__(249)
1.823 0.020 0.000 0.000 90
- /django/template/base.py in render_annotated(896)
4.632 0.001 0.004 0.000 659
/django/template/base.py in render(985)
1.127 0.000 0.004 0.000 2823
/django/template/loader_tags.py in render(48)
4.776 4.776 0.000 0.000 1
/django/template/defaulttags.py in render(155)
4.755 0.049 0.009 0.001 12
/django/template/defaulttags.py in render(297)
1.818 0.002 0.002 0.000 803
/django/template/loader_tags.py in render(126)
4.786 4.786 0.000 0.000 1
/django/template/loader_tags.py in render(162)
4.227 0.021 0.002 0.000 49
/django/template/defaulttags.py in render(509)
1.668 0.035 0.001 0.000 47
- /django/template/defaulttags.py in render(297)
1.818 0.002 0.002 0.000 803
- /django/template/base.py in render(933)
0.840 0.002 0.003 0.000 345
/django/template/base.py in render_annotated(896)
4.786 0.001 0.003 0.003 1
- /django/template/smartif.py in eval(56)
0.973 0.001 0.001 0.000 655
/django/template/smartif.py in <lambda>(95)
0.965 0.007 0.000 0.000 132
- /django/template/loader_tags.py in render(126)
4.786 4.786 0.000 0.000 1
- /django/test/utils.py in instrumented_test_render(90)
4.781 4.781 0.000 0.000 1
/django/template/base.py in render(933)
4.786 0.018 0.004 0.004 1
- /django/template/loader_tags.py in render(162)
4.227 0.021 0.002 0.000 49
- /django/template/base.py in render(165)
4.211 0.020 0.001 0.000 49
/django/test/utils.py in instrumented_test_render(90)
4.789 0.018 0.001 0.001 1
- /django/template/defaulttags.py in render(509)
1.668 0.035 0.001 0.000 47
- /django/template/defaulttags.py in <dictcomp>(510)
1.661 0.035 0.000 0.000 47
/django/template/base.py in resolve(668)
1.660 0.035 0.000 0.000 47

Request

View information

View function Arguments Keyword arguments URL name
home.views.index () {} index

No cookies

No session data

No GET data

No POST data

SQL queries from 1 connection

  •   default 155.74 ms (220 queries including 209 similar and 142 duplicates )
  Query Timeline Time (ms) 操作
  +
SET SESSION TRANSACTION ISOLATION LEVEL READ COMMITTED
0.17268433823473128%
0.27

Connection: default

/usr/local/bin/gunicorn in <module>(11)
  sys.exit(run())
/usr/local/lib/python3.6/site-packages/gunicorn/app/wsgiapp.py in run(61)
  WSGIApplication("%(prog)s [OPTIONS] [APP_MODULE]").run()
/usr/local/lib/python3.6/site-packages/gunicorn/app/base.py in run(223)
  super(Application, self).run()
/usr/local/lib/python3.6/site-packages/gunicorn/app/base.py in run(72)
  Arbiter(self).run()
/usr/local/lib/python3.6/site-packages/gunicorn/arbiter.py in run(203)
  self.manage_workers()
/usr/local/lib/python3.6/site-packages/gunicorn/arbiter.py in manage_workers(545)
  self.spawn_workers()
/usr/local/lib/python3.6/site-packages/gunicorn/arbiter.py in spawn_workers(616)
  self.spawn_worker()
/usr/local/lib/python3.6/site-packages/gunicorn/arbiter.py in spawn_worker(583)
  worker.init_process()
/usr/local/lib/python3.6/site-packages/gunicorn/workers/base.py in init_process(134)
  self.run()
/usr/local/lib/python3.6/site-packages/gunicorn/workers/sync.py in run(124)
  self.run_for_one(timeout)
/usr/local/lib/python3.6/site-packages/gunicorn/workers/sync.py in run_for_one(68)
  self.accept(listener)
/usr/local/lib/python3.6/site-packages/gunicorn/workers/sync.py in accept(30)
  self.handle(listener, client, addr)
/usr/local/lib/python3.6/site-packages/gunicorn/workers/sync.py in handle(135)
  self.handle_request(listener, req, client, addr)
/usr/local/lib/python3.6/site-packages/gunicorn/workers/sync.py in handle_request(176)
  respiter = self.wsgi(environ, resp.start_response)
/usr/local/lib/python3.6/cProfile.py in runcall(109)
  return func(*args, **kw)
/app/vistar/home/views.py in index(66)
  top_jobs_id = list(top_jobs)
  +
SELECT ••• `accounts_jobmaster`.`id` FROM `accounts_jobmaster` LEFT OUTER JOIN `accounts_user_profile` ON (`accounts_jobmaster`.`id` = `accounts_user_profile`.`job_id`) GROUP BY `accounts_jobmaster`.`id` HAVING COUNT(`accounts_user_profile`.`job_id`) > 0 ORDER BY COUNT(`accounts_user_profile`.`job_id`) DESC LIMIT 3
0.8006552207159969%
1.25

Connection: default

/usr/local/bin/gunicorn in <module>(11)
  sys.exit(run())
/usr/local/lib/python3.6/site-packages/gunicorn/app/wsgiapp.py in run(61)
  WSGIApplication("%(prog)s [OPTIONS] [APP_MODULE]").run()
/usr/local/lib/python3.6/site-packages/gunicorn/app/base.py in run(223)
  super(Application, self).run()
/usr/local/lib/python3.6/site-packages/gunicorn/app/base.py in run(72)
  Arbiter(self).run()
/usr/local/lib/python3.6/site-packages/gunicorn/arbiter.py in run(203)
  self.manage_workers()
/usr/local/lib/python3.6/site-packages/gunicorn/arbiter.py in manage_workers(545)
  self.spawn_workers()
/usr/local/lib/python3.6/site-packages/gunicorn/arbiter.py in spawn_workers(616)
  self.spawn_worker()
/usr/local/lib/python3.6/site-packages/gunicorn/arbiter.py in spawn_worker(583)
  worker.init_process()
/usr/local/lib/python3.6/site-packages/gunicorn/workers/base.py in init_process(134)
  self.run()
/usr/local/lib/python3.6/site-packages/gunicorn/workers/sync.py in run(124)
  self.run_for_one(timeout)
/usr/local/lib/python3.6/site-packages/gunicorn/workers/sync.py in run_for_one(68)
  self.accept(listener)
/usr/local/lib/python3.6/site-packages/gunicorn/workers/sync.py in accept(30)
  self.handle(listener, client, addr)
/usr/local/lib/python3.6/site-packages/gunicorn/workers/sync.py in handle(135)
  self.handle_request(listener, req, client, addr)
/usr/local/lib/python3.6/site-packages/gunicorn/workers/sync.py in handle_request(176)
  respiter = self.wsgi(environ, resp.start_response)
/usr/local/lib/python3.6/cProfile.py in runcall(109)
  return func(*args, **kw)
/app/vistar/home/views.py in index(66)
  top_jobs_id = list(top_jobs)
  +
SELECT ••• `accounts_jobmaster`.`id`, `accounts_jobmaster`.`create_datetime`, `accounts_jobmaster`.`update_datetime`, `accounts_jobmaster`.`name`, `accounts_jobmaster`.`name_en`, `accounts_jobmaster`.`category_id` FROM `accounts_jobmaster` WHERE `accounts_jobmaster`.`id` = 6
  49 similar queries.   Duplicated 26 times.
0.37629264484128505%
0.59

Connection: default

/usr/local/bin/gunicorn in <module>(11)
  sys.exit(run())
/usr/local/lib/python3.6/site-packages/gunicorn/app/wsgiapp.py in run(61)
  WSGIApplication("%(prog)s [OPTIONS] [APP_MODULE]").run()
/usr/local/lib/python3.6/site-packages/gunicorn/app/base.py in run(223)
  super(Application, self).run()
/usr/local/lib/python3.6/site-packages/gunicorn/app/base.py in run(72)
  Arbiter(self).run()
/usr/local/lib/python3.6/site-packages/gunicorn/arbiter.py in run(203)
  self.manage_workers()
/usr/local/lib/python3.6/site-packages/gunicorn/arbiter.py in manage_workers(545)
  self.spawn_workers()
/usr/local/lib/python3.6/site-packages/gunicorn/arbiter.py in spawn_workers(616)
  self.spawn_worker()
/usr/local/lib/python3.6/site-packages/gunicorn/arbiter.py in spawn_worker(583)
  worker.init_process()
/usr/local/lib/python3.6/site-packages/gunicorn/workers/base.py in init_process(134)
  self.run()
/usr/local/lib/python3.6/site-packages/gunicorn/workers/sync.py in run(124)
  self.run_for_one(timeout)
/usr/local/lib/python3.6/site-packages/gunicorn/workers/sync.py in run_for_one(68)
  self.accept(listener)
/usr/local/lib/python3.6/site-packages/gunicorn/workers/sync.py in accept(30)
  self.handle(listener, client, addr)
/usr/local/lib/python3.6/site-packages/gunicorn/workers/sync.py in handle(135)
  self.handle_request(listener, req, client, addr)
/usr/local/lib/python3.6/site-packages/gunicorn/workers/sync.py in handle_request(176)
  respiter = self.wsgi(environ, resp.start_response)
/usr/local/lib/python3.6/cProfile.py in runcall(109)
  return func(*args, **kw)
/app/vistar/home/views.py in index(78)
  'selected_job_users': get_job_users(selected_job_ids),
/app/vistar/home/views.py in get_job_users(29)
  job = JobMaster.objects.get(pk=job_id)
  +
SELECT ••• `accounts_jobmaster`.`id`, `accounts_jobmaster`.`create_datetime`, `accounts_jobmaster`.`update_datetime`, `accounts_jobmaster`.`name`, `accounts_jobmaster`.`name_en`, `accounts_jobmaster`.`category_id` FROM `accounts_jobmaster` WHERE `accounts_jobmaster`.`id` = 1
  49 similar queries.   Duplicated 8 times.
0.3220991557144279%
0.50

Connection: default

/usr/local/bin/gunicorn in <module>(11)
  sys.exit(run())
/usr/local/lib/python3.6/site-packages/gunicorn/app/wsgiapp.py in run(61)
  WSGIApplication("%(prog)s [OPTIONS] [APP_MODULE]").run()
/usr/local/lib/python3.6/site-packages/gunicorn/app/base.py in run(223)
  super(Application, self).run()
/usr/local/lib/python3.6/site-packages/gunicorn/app/base.py in run(72)
  Arbiter(self).run()
/usr/local/lib/python3.6/site-packages/gunicorn/arbiter.py in run(203)
  self.manage_workers()
/usr/local/lib/python3.6/site-packages/gunicorn/arbiter.py in manage_workers(545)
  self.spawn_workers()
/usr/local/lib/python3.6/site-packages/gunicorn/arbiter.py in spawn_workers(616)
  self.spawn_worker()
/usr/local/lib/python3.6/site-packages/gunicorn/arbiter.py in spawn_worker(583)
  worker.init_process()
/usr/local/lib/python3.6/site-packages/gunicorn/workers/base.py in init_process(134)
  self.run()
/usr/local/lib/python3.6/site-packages/gunicorn/workers/sync.py in run(124)
  self.run_for_one(timeout)
/usr/local/lib/python3.6/site-packages/gunicorn/workers/sync.py in run_for_one(68)
  self.accept(listener)
/usr/local/lib/python3.6/site-packages/gunicorn/workers/sync.py in accept(30)
  self.handle(listener, client, addr)
/usr/local/lib/python3.6/site-packages/gunicorn/workers/sync.py in handle(135)
  self.handle_request(listener, req, client, addr)
/usr/local/lib/python3.6/site-packages/gunicorn/workers/sync.py in handle_request(176)
  respiter = self.wsgi(environ, resp.start_response)
/usr/local/lib/python3.6/cProfile.py in runcall(109)
  return func(*args, **kw)
/app/vistar/home/views.py in index(78)
  'selected_job_users': get_job_users(selected_job_ids),
/app/vistar/home/views.py in get_job_users(29)
  job = JobMaster.objects.get(pk=job_id)
  +
SELECT ••• `accounts_jobmaster`.`id`, `accounts_jobmaster`.`create_datetime`, `accounts_jobmaster`.`update_datetime`, `accounts_jobmaster`.`name`, `accounts_jobmaster`.`name_en`, `accounts_jobmaster`.`category_id` FROM `accounts_jobmaster` WHERE `accounts_jobmaster`.`id` = 40
  49 similar queries.   Duplicated 5 times.
0.33266229342559495%
0.52

Connection: default

/usr/local/bin/gunicorn in <module>(11)
  sys.exit(run())
/usr/local/lib/python3.6/site-packages/gunicorn/app/wsgiapp.py in run(61)
  WSGIApplication("%(prog)s [OPTIONS] [APP_MODULE]").run()
/usr/local/lib/python3.6/site-packages/gunicorn/app/base.py in run(223)
  super(Application, self).run()
/usr/local/lib/python3.6/site-packages/gunicorn/app/base.py in run(72)
  Arbiter(self).run()
/usr/local/lib/python3.6/site-packages/gunicorn/arbiter.py in run(203)
  self.manage_workers()
/usr/local/lib/python3.6/site-packages/gunicorn/arbiter.py in manage_workers(545)
  self.spawn_workers()
/usr/local/lib/python3.6/site-packages/gunicorn/arbiter.py in spawn_workers(616)
  self.spawn_worker()
/usr/local/lib/python3.6/site-packages/gunicorn/arbiter.py in spawn_worker(583)
  worker.init_process()
/usr/local/lib/python3.6/site-packages/gunicorn/workers/base.py in init_process(134)
  self.run()
/usr/local/lib/python3.6/site-packages/gunicorn/workers/sync.py in run(124)
  self.run_for_one(timeout)
/usr/local/lib/python3.6/site-packages/gunicorn/workers/sync.py in run_for_one(68)
  self.accept(listener)
/usr/local/lib/python3.6/site-packages/gunicorn/workers/sync.py in accept(30)
  self.handle(listener, client, addr)
/usr/local/lib/python3.6/site-packages/gunicorn/workers/sync.py in handle(135)
  self.handle_request(listener, req, client, addr)
/usr/local/lib/python3.6/site-packages/gunicorn/workers/sync.py in handle_request(176)
  respiter = self.wsgi(environ, resp.start_response)
/usr/local/lib/python3.6/cProfile.py in runcall(109)
  return func(*args, **kw)
/app/vistar/home/views.py in index(78)
  'selected_job_users': get_job_users(selected_job_ids),
/app/vistar/home/views.py in get_job_users(29)
  job = JobMaster.objects.get(pk=job_id)
  +
SELECT ••• `accounts_prefecturesmaster`.`id`, `accounts_prefecturesmaster`.`create_datetime`, `accounts_prefecturesmaster`.`update_datetime`, `accounts_prefecturesmaster`.`name` FROM `accounts_prefecturesmaster` ORDER BY `accounts_prefecturesmaster`.`id` ASC
0.4219131526373399%
0.66

Connection: default

/usr/local/bin/gunicorn in <module>(11)
  sys.exit(run())
/usr/local/lib/python3.6/site-packages/gunicorn/app/wsgiapp.py in run(61)
  WSGIApplication("%(prog)s [OPTIONS] [APP_MODULE]").run()
/usr/local/lib/python3.6/site-packages/gunicorn/app/base.py in run(223)
  super(Application, self).run()
/usr/local/lib/python3.6/site-packages/gunicorn/app/base.py in run(72)
  Arbiter(self).run()
/usr/local/lib/python3.6/site-packages/gunicorn/arbiter.py in run(203)
  self.manage_workers()
/usr/local/lib/python3.6/site-packages/gunicorn/arbiter.py in manage_workers(545)
  self.spawn_workers()
/usr/local/lib/python3.6/site-packages/gunicorn/arbiter.py in spawn_workers(616)
  self.spawn_worker()
/usr/local/lib/python3.6/site-packages/gunicorn/arbiter.py in spawn_worker(583)
  worker.init_process()
/usr/local/lib/python3.6/site-packages/gunicorn/workers/base.py in init_process(134)
  self.run()
/usr/local/lib/python3.6/site-packages/gunicorn/workers/sync.py in run(124)
  self.run_for_one(timeout)
/usr/local/lib/python3.6/site-packages/gunicorn/workers/sync.py in run_for_one(68)
  self.accept(listener)
/usr/local/lib/python3.6/site-packages/gunicorn/workers/sync.py in accept(30)
  self.handle(listener, client, addr)
/usr/local/lib/python3.6/site-packages/gunicorn/workers/sync.py in handle(135)
  self.handle_request(listener, req, client, addr)
/usr/local/lib/python3.6/site-packages/gunicorn/workers/sync.py in handle_request(176)
  respiter = self.wsgi(environ, resp.start_response)
/usr/local/lib/python3.6/cProfile.py in runcall(109)
  return func(*args, **kw)
/app/vistar/home/views.py in index(82)
  return render(request, 'home.html', context)
/usr/local/lib/python3.6/site-packages/django/shortcuts.py in render(36)
  content = loader.render_to_string(template_name, context, request, using=using)
/usr/local/lib/python3.6/site-packages/django/template/loader.py in render_to_string(62)
  return template.render(context, request)
/usr/local/lib/python3.6/site-packages/django/template/backends/django.py in render(61)
  return self.template.render(context)
/usr/local/lib/python3.6/site-packages/django/template/base.py in render(171)
  return self._render(context)
/usr/local/lib/python3.6/site-packages/django/test/utils.py in instrumented_test_render(96)
  return self.nodelist.render(context)
/usr/local/lib/python3.6/site-packages/django/template/base.py in render(937)
  bit = node.render_annotated(context)
/usr/local/lib/python3.6/site-packages/django/template/base.py in render_annotated(904)
  return self.render(context)
/usr/local/lib/python3.6/site-packages/django/template/loader_tags.py in render(150)
  return compiled_parent._render(context)
/usr/local/lib/python3.6/site-packages/django/test/utils.py in instrumented_test_render(96)
  return self.nodelist.render(context)
/usr/local/lib/python3.6/site-packages/django/template/base.py in render(937)
  bit = node.render_annotated(context)
/usr/local/lib/python3.6/site-packages/django/template/base.py in render_annotated(904)
  return self.render(context)
/usr/local/lib/python3.6/site-packages/django/template/loader_tags.py in render(62)
  result = block.nodelist.render(context)
/usr/local/lib/python3.6/site-packages/django/template/base.py in render(937)
  bit = node.render_annotated(context)
/usr/local/lib/python3.6/site-packages/django/template/base.py in render_annotated(904)
  return self.render(context)
/usr/local/lib/python3.6/site-packages/django/template/loader_tags.py in render(188)
  return template.render(context)
/usr/local/lib/python3.6/site-packages/django/template/base.py in render(173)
  return self._render(context)
/usr/local/lib/python3.6/site-packages/django/test/utils.py in instrumented_test_render(96)
  return self.nodelist.render(context)
/usr/local/lib/python3.6/site-packages/django/template/base.py in render(937)
  bit = node.render_annotated(context)
/usr/local/lib/python3.6/site-packages/django/template/base.py in render_annotated(904)
  return self.render(context)
/usr/local/lib/python3.6/site-packages/django/template/defaulttags.py in render(166)
  len_values = len(values)
/usr/local/lib/python3.6/site-packages/django/forms/boundfield.py in __len__(60)
  return len(self.subwidgets)
/usr/local/lib/python3.6/site-packages/django/forms/boundfield.py in subwidgets(49)
  for widget in self.field.widget.subwidgets(self.html_name, self.value(), attrs=attrs)
/usr/local/lib/python3.6/site-packages/django/forms/boundfield.py in <listcomp>(48)
  BoundWidget(self.field.widget, widget, self.form.renderer)
/usr/local/lib/python3.6/site-packages/django/forms/widgets.py in subwidgets(565)
  yield from self.options(name, value, attrs)
/usr/local/lib/python3.6/site-packages/django/forms/widgets.py in options(569)
  for group in self.optgroups(name, value, attrs):
/usr/local/lib/python3.6/site-packages/django/forms/widgets.py in optgroups(577)
  for index, (option_value, option_label) in enumerate(self.choices):
/usr/local/lib/python3.6/site-packages/django/forms/models.py in __iter__(1139)
  for obj in queryset:
74 {% include 'inc/home/artist.html' with user=user %}
75 {% endfor %}
76 <section class="vistar-list__section swiper-slide more">
77 <a title="" class="more-button-area" href="{% url 'search:index' %}?&q=&sort=1">
78 <div class="more-button">もっと見る</div>
79 </a>
80 </section>
81 </div>

/app/vistar/templates/home.html

  +
SELECT ••• `accounts_jobcategorymaster`.`id`, `accounts_jobcategorymaster`.`create_datetime`, `accounts_jobcategorymaster`.`update_datetime`, `accounts_jobcategorymaster`.`name` FROM `accounts_jobcategorymaster` ORDER BY `accounts_jobcategorymaster`.`id` ASC
0.48559815680901386%
0.76

Connection: default

/usr/local/bin/gunicorn in <module>(11)
  sys.exit(run())
/usr/local/lib/python3.6/site-packages/gunicorn/app/wsgiapp.py in run(61)
  WSGIApplication("%(prog)s [OPTIONS] [APP_MODULE]").run()
/usr/local/lib/python3.6/site-packages/gunicorn/app/base.py in run(223)
  super(Application, self).run()
/usr/local/lib/python3.6/site-packages/gunicorn/app/base.py in run(72)
  Arbiter(self).run()
/usr/local/lib/python3.6/site-packages/gunicorn/arbiter.py in run(203)
  self.manage_workers()
/usr/local/lib/python3.6/site-packages/gunicorn/arbiter.py in manage_workers(545)
  self.spawn_workers()
/usr/local/lib/python3.6/site-packages/gunicorn/arbiter.py in spawn_workers(616)
  self.spawn_worker()
/usr/local/lib/python3.6/site-packages/gunicorn/arbiter.py in spawn_worker(583)
  worker.init_process()
/usr/local/lib/python3.6/site-packages/gunicorn/workers/base.py in init_process(134)
  self.run()
/usr/local/lib/python3.6/site-packages/gunicorn/workers/sync.py in run(124)
  self.run_for_one(timeout)
/usr/local/lib/python3.6/site-packages/gunicorn/workers/sync.py in run_for_one(68)
  self.accept(listener)
/usr/local/lib/python3.6/site-packages/gunicorn/workers/sync.py in accept(30)
  self.handle(listener, client, addr)
/usr/local/lib/python3.6/site-packages/gunicorn/workers/sync.py in handle(135)
  self.handle_request(listener, req, client, addr)
/usr/local/lib/python3.6/site-packages/gunicorn/workers/sync.py in handle_request(176)
  respiter = self.wsgi(environ, resp.start_response)
/usr/local/lib/python3.6/cProfile.py in runcall(109)
  return func(*args, **kw)
/app/vistar/home/views.py in index(82)
  return render(request, 'home.html', context)
/usr/local/lib/python3.6/site-packages/django/shortcuts.py in render(36)
  content = loader.render_to_string(template_name, context, request, using=using)
/usr/local/lib/python3.6/site-packages/django/template/loader.py in render_to_string(62)
  return template.render(context, request)
/usr/local/lib/python3.6/site-packages/django/template/backends/django.py in render(61)
  return self.template.render(context)
/usr/local/lib/python3.6/site-packages/django/template/base.py in render(171)
  return self._render(context)
/usr/local/lib/python3.6/site-packages/django/test/utils.py in instrumented_test_render(96)
  return self.nodelist.render(context)
/usr/local/lib/python3.6/site-packages/django/template/base.py in render(937)
  bit = node.render_annotated(context)
/usr/local/lib/python3.6/site-packages/django/template/base.py in render_annotated(904)
  return self.render(context)
/usr/local/lib/python3.6/site-packages/django/template/loader_tags.py in render(150)
  return compiled_parent._render(context)
/usr/local/lib/python3.6/site-packages/django/test/utils.py in instrumented_test_render(96)
  return self.nodelist.render(context)
/usr/local/lib/python3.6/site-packages/django/template/base.py in render(937)
  bit = node.render_annotated(context)
/usr/local/lib/python3.6/site-packages/django/template/base.py in render_annotated(904)
  return self.render(context)
/usr/local/lib/python3.6/site-packages/django/template/loader_tags.py in render(62)
  result = block.nodelist.render(context)
/usr/local/lib/python3.6/site-packages/django/template/base.py in render(937)
  bit = node.render_annotated(context)
/usr/local/lib/python3.6/site-packages/django/template/base.py in render_annotated(904)
  return self.render(context)
/usr/local/lib/python3.6/site-packages/django/template/loader_tags.py in render(188)
  return template.render(context)
/usr/local/lib/python3.6/site-packages/django/template/base.py in render(173)
  return self._render(context)
/usr/local/lib/python3.6/site-packages/django/test/utils.py in instrumented_test_render(96)
  return self.nodelist.render(context)
/usr/local/lib/python3.6/site-packages/django/template/base.py in render(937)
  bit = node.render_annotated(context)
/usr/local/lib/python3.6/site-packages/django/template/base.py in render_annotated(904)
  return self.render(context)
/usr/local/lib/python3.6/site-packages/django/template/defaulttags.py in render(166)
  len_values = len(values)
1 {% extends 'base_home.html' %}
2 {% load static %}
3 {% load filters %}
4 {% block title %}{{ title }}{% endblock %}

/app/vistar/templates/home.html

  +
SELECT ••• `accounts_jobmaster`.`id`, `accounts_jobmaster`.`create_datetime`, `accounts_jobmaster`.`update_datetime`, `accounts_jobmaster`.`name`, `accounts_jobmaster`.`name_en`, `accounts_jobmaster`.`category_id` FROM `accounts_jobmaster` WHERE `accounts_jobmaster`.`category_id` = 1 ORDER BY `accounts_jobmaster`.`id` ASC
  34 similar queries.   Duplicated 2 times.
0.45498036634186295%
0.71

Connection: default

/usr/local/bin/gunicorn in <module>(11)
  sys.exit(run())
/usr/local/lib/python3.6/site-packages/gunicorn/app/wsgiapp.py in run(61)
  WSGIApplication("%(prog)s [OPTIONS] [APP_MODULE]").run()
/usr/local/lib/python3.6/site-packages/gunicorn/app/base.py in run(223)
  super(Application, self).run()
/usr/local/lib/python3.6/site-packages/gunicorn/app/base.py in run(72)
  Arbiter(self).run()
/usr/local/lib/python3.6/site-packages/gunicorn/arbiter.py in run(203)
  self.manage_workers()
/usr/local/lib/python3.6/site-packages/gunicorn/arbiter.py in manage_workers(545)
  self.spawn_workers()
/usr/local/lib/python3.6/site-packages/gunicorn/arbiter.py in spawn_workers(616)
  self.spawn_worker()
/usr/local/lib/python3.6/site-packages/gunicorn/arbiter.py in spawn_worker(583)
  worker.init_process()
/usr/local/lib/python3.6/site-packages/gunicorn/workers/base.py in init_process(134)
  self.run()
/usr/local/lib/python3.6/site-packages/gunicorn/workers/sync.py in run(124)
  self.run_for_one(timeout)
/usr/local/lib/python3.6/site-packages/gunicorn/workers/sync.py in run_for_one(68)
  self.accept(listener)
/usr/local/lib/python3.6/site-packages/gunicorn/workers/sync.py in accept(30)
  self.handle(listener, client, addr)
/usr/local/lib/python3.6/site-packages/gunicorn/workers/sync.py in handle(135)
  self.handle_request(listener, req, client, addr)
/usr/local/lib/python3.6/site-packages/gunicorn/workers/sync.py in handle_request(176)
  respiter = self.wsgi(environ, resp.start_response)
/usr/local/lib/python3.6/cProfile.py in runcall(109)
  return func(*args, **kw)
/app/vistar/home/views.py in index(82)
  return render(request, 'home.html', context)
/usr/local/lib/python3.6/site-packages/django/shortcuts.py in render(36)
  content = loader.render_to_string(template_name, context, request, using=using)
/usr/local/lib/python3.6/site-packages/django/template/loader.py in render_to_string(62)
  return template.render(context, request)
/usr/local/lib/python3.6/site-packages/django/template/backends/django.py in render(61)
  return self.template.render(context)
/usr/local/lib/python3.6/site-packages/django/template/base.py in render(171)
  return self._render(context)
/usr/local/lib/python3.6/site-packages/django/test/utils.py in instrumented_test_render(96)
  return self.nodelist.render(context)
/usr/local/lib/python3.6/site-packages/django/template/base.py in render(937)
  bit = node.render_annotated(context)
/usr/local/lib/python3.6/site-packages/django/template/base.py in render_annotated(904)
  return self.render(context)
/usr/local/lib/python3.6/site-packages/django/template/loader_tags.py in render(150)
  return compiled_parent._render(context)
/usr/local/lib/python3.6/site-packages/django/test/utils.py in instrumented_test_render(96)
  return self.nodelist.render(context)
/usr/local/lib/python3.6/site-packages/django/template/base.py in render(937)
  bit = node.render_annotated(context)
/usr/local/lib/python3.6/site-packages/django/template/base.py in render_annotated(904)
  return self.render(context)
/usr/local/lib/python3.6/site-packages/django/template/loader_tags.py in render(62)
  result = block.nodelist.render(context)
/usr/local/lib/python3.6/site-packages/django/template/base.py in render(937)
  bit = node.render_annotated(context)
/usr/local/lib/python3.6/site-packages/django/template/base.py in render_annotated(904)
  return self.render(context)
/usr/local/lib/python3.6/site-packages/django/template/loader_tags.py in render(188)
  return template.render(context)
/usr/local/lib/python3.6/site-packages/django/template/base.py in render(173)
  return self._render(context)
/usr/local/lib/python3.6/site-packages/django/test/utils.py in instrumented_test_render(96)
  return self.nodelist.render(context)
/usr/local/lib/python3.6/site-packages/django/template/base.py in render(937)
  bit = node.render_annotated(context)
/usr/local/lib/python3.6/site-packages/django/template/base.py in render_annotated(904)
  return self.render(context)
/usr/local/lib/python3.6/site-packages/django/template/defaulttags.py in render(209)
  nodelist.append(node.render_annotated(context))
/usr/local/lib/python3.6/site-packages/django/template/base.py in render_annotated(904)
  return self.render(context)
/usr/local/lib/python3.6/site-packages/django/template/defaulttags.py in render(166)
  len_values = len(values)
1 {% extends 'base_home.html' %}
2 {% load static %}
3 {% load filters %}
4 {% block title %}{{ title }}{% endblock %}

/app/vistar/templates/home.html

  +
SELECT ••• `accounts_jobmaster`.`id`, `accounts_jobmaster`.`create_datetime`, `accounts_jobmaster`.`update_datetime`, `accounts_jobmaster`.`name`, `accounts_jobmaster`.`name_en`, `accounts_jobmaster`.`category_id` FROM `accounts_jobmaster` WHERE `accounts_jobmaster`.`category_id` = 2 ORDER BY `accounts_jobmaster`.`id` ASC
  34 similar queries.   Duplicated 2 times.
0.5053466316603262%
0.79

Connection: default

/usr/local/bin/gunicorn in <module>(11)
  sys.exit(run())
/usr/local/lib/python3.6/site-packages/gunicorn/app/wsgiapp.py in run(61)
  WSGIApplication("%(prog)s [OPTIONS] [APP_MODULE]").run()
/usr/local/lib/python3.6/site-packages/gunicorn/app/base.py in run(223)
  super(Application, self).run()
/usr/local/lib/python3.6/site-packages/gunicorn/app/base.py in run(72)
  Arbiter(self).run()
/usr/local/lib/python3.6/site-packages/gunicorn/arbiter.py in run(203)
  self.manage_workers()
/usr/local/lib/python3.6/site-packages/gunicorn/arbiter.py in manage_workers(545)
  self.spawn_workers()
/usr/local/lib/python3.6/site-packages/gunicorn/arbiter.py in spawn_workers(616)
  self.spawn_worker()
/usr/local/lib/python3.6/site-packages/gunicorn/arbiter.py in spawn_worker(583)
  worker.init_process()
/usr/local/lib/python3.6/site-packages/gunicorn/workers/base.py in init_process(134)
  self.run()
/usr/local/lib/python3.6/site-packages/gunicorn/workers/sync.py in run(124)
  self.run_for_one(timeout)
/usr/local/lib/python3.6/site-packages/gunicorn/workers/sync.py in run_for_one(68)
  self.accept(listener)
/usr/local/lib/python3.6/site-packages/gunicorn/workers/sync.py in accept(30)
  self.handle(listener, client, addr)
/usr/local/lib/python3.6/site-packages/gunicorn/workers/sync.py in handle(135)
  self.handle_request(listener, req, client, addr)
/usr/local/lib/python3.6/site-packages/gunicorn/workers/sync.py in handle_request(176)
  respiter = self.wsgi(environ, resp.start_response)
/usr/local/lib/python3.6/cProfile.py in runcall(109)
  return func(*args, **kw)
/app/vistar/home/views.py in index(82)
  return render(request, 'home.html', context)
/usr/local/lib/python3.6/site-packages/django/shortcuts.py in render(36)
  content = loader.render_to_string(template_name, context, request, using=using)
/usr/local/lib/python3.6/site-packages/django/template/loader.py in render_to_string(62)
  return template.render(context, request)
/usr/local/lib/python3.6/site-packages/django/template/backends/django.py in render(61)
  return self.template.render(context)
/usr/local/lib/python3.6/site-packages/django/template/base.py in render(171)
  return self._render(context)
/usr/local/lib/python3.6/site-packages/django/test/utils.py in instrumented_test_render(96)
  return self.nodelist.render(context)
/usr/local/lib/python3.6/site-packages/django/template/base.py in render(937)
  bit = node.render_annotated(context)
/usr/local/lib/python3.6/site-packages/django/template/base.py in render_annotated(904)
  return self.render(context)
/usr/local/lib/python3.6/site-packages/django/template/loader_tags.py in render(150)
  return compiled_parent._render(context)
/usr/local/lib/python3.6/site-packages/django/test/utils.py in instrumented_test_render(96)
  return self.nodelist.render(context)
/usr/local/lib/python3.6/site-packages/django/template/base.py in render(937)
  bit = node.render_annotated(context)
/usr/local/lib/python3.6/site-packages/django/template/base.py in render_annotated(904)
  return self.render(context)
/usr/local/lib/python3.6/site-packages/django/template/loader_tags.py in render(62)
  result = block.nodelist.render(context)
/usr/local/lib/python3.6/site-packages/django/template/base.py in render(937)
  bit = node.render_annotated(context)
/usr/local/lib/python3.6/site-packages/django/template/base.py in render_annotated(904)
  return self.render(context)
/usr/local/lib/python3.6/site-packages/django/template/loader_tags.py in render(188)
  return template.render(context)
/usr/local/lib/python3.6/site-packages/django/template/base.py in render(173)
  return self._render(context)
/usr/local/lib/python3.6/site-packages/django/test/utils.py in instrumented_test_render(96)
  return self.nodelist.render(context)
/usr/local/lib/python3.6/site-packages/django/template/base.py in render(937)
  bit = node.render_annotated(context)
/usr/local/lib/python3.6/site-packages/django/template/base.py in render_annotated(904)
  return self.render(context)
/usr/local/lib/python3.6/site-packages/django/template/defaulttags.py in render(209)
  nodelist.append(node.render_annotated(context))
/usr/local/lib/python3.6/site-packages/django/template/base.py in render_annotated(904)
  return self.render(context)
/usr/local/lib/python3.6/site-packages/django/template/defaulttags.py in render(166)
  len_values = len(values)
1 {% extends 'base_home.html' %}
2 {% load static %}
3 {% load filters %}
4 {% block title %}{{ title }}{% endblock %}

/app/vistar/templates/home.html

  +
SELECT ••• `accounts_jobmaster`.`id`, `accounts_jobmaster`.`create_datetime`, `accounts_jobmaster`.`update_datetime`, `accounts_jobmaster`.`name`, `accounts_jobmaster`.`name_en`, `accounts_jobmaster`.`category_id` FROM `accounts_jobmaster` WHERE `accounts_jobmaster`.`category_id` = 3 ORDER BY `accounts_jobmaster`.`id` ASC
  34 similar queries.   Duplicated 2 times.
0.5143788798481357%
0.80

Connection: default

/usr/local/bin/gunicorn in <module>(11)
  sys.exit(run())
/usr/local/lib/python3.6/site-packages/gunicorn/app/wsgiapp.py in run(61)
  WSGIApplication("%(prog)s [OPTIONS] [APP_MODULE]").run()
/usr/local/lib/python3.6/site-packages/gunicorn/app/base.py in run(223)
  super(Application, self).run()
/usr/local/lib/python3.6/site-packages/gunicorn/app/base.py in run(72)
  Arbiter(self).run()
/usr/local/lib/python3.6/site-packages/gunicorn/arbiter.py in run(203)
  self.manage_workers()
/usr/local/lib/python3.6/site-packages/gunicorn/arbiter.py in manage_workers(545)
  self.spawn_workers()
/usr/local/lib/python3.6/site-packages/gunicorn/arbiter.py in spawn_workers(616)
  self.spawn_worker()
/usr/local/lib/python3.6/site-packages/gunicorn/arbiter.py in spawn_worker(583)
  worker.init_process()
/usr/local/lib/python3.6/site-packages/gunicorn/workers/base.py in init_process(134)
  self.run()
/usr/local/lib/python3.6/site-packages/gunicorn/workers/sync.py in run(124)
  self.run_for_one(timeout)
/usr/local/lib/python3.6/site-packages/gunicorn/workers/sync.py in run_for_one(68)
  self.accept(listener)
/usr/local/lib/python3.6/site-packages/gunicorn/workers/sync.py in accept(30)
  self.handle(listener, client, addr)
/usr/local/lib/python3.6/site-packages/gunicorn/workers/sync.py in handle(135)
  self.handle_request(listener, req, client, addr)
/usr/local/lib/python3.6/site-packages/gunicorn/workers/sync.py in handle_request(176)
  respiter = self.wsgi(environ, resp.start_response)
/usr/local/lib/python3.6/cProfile.py in runcall(109)
  return func(*args, **kw)
/app/vistar/home/views.py in index(82)
  return render(request, 'home.html', context)
/usr/local/lib/python3.6/site-packages/django/shortcuts.py in render(36)
  content = loader.render_to_string(template_name, context, request, using=using)
/usr/local/lib/python3.6/site-packages/django/template/loader.py in render_to_string(62)
  return template.render(context, request)
/usr/local/lib/python3.6/site-packages/django/template/backends/django.py in render(61)
  return self.template.render(context)
/usr/local/lib/python3.6/site-packages/django/template/base.py in render(171)
  return self._render(context)
/usr/local/lib/python3.6/site-packages/django/test/utils.py in instrumented_test_render(96)
  return self.nodelist.render(context)
/usr/local/lib/python3.6/site-packages/django/template/base.py in render(937)
  bit = node.render_annotated(context)
/usr/local/lib/python3.6/site-packages/django/template/base.py in render_annotated(904)
  return self.render(context)
/usr/local/lib/python3.6/site-packages/django/template/loader_tags.py in render(150)
  return compiled_parent._render(context)
/usr/local/lib/python3.6/site-packages/django/test/utils.py in instrumented_test_render(96)
  return self.nodelist.render(context)
/usr/local/lib/python3.6/site-packages/django/template/base.py in render(937)
  bit = node.render_annotated(context)
/usr/local/lib/python3.6/site-packages/django/template/base.py in render_annotated(904)
  return self.render(context)
/usr/local/lib/python3.6/site-packages/django/template/loader_tags.py in render(62)
  result = block.nodelist.render(context)
/usr/local/lib/python3.6/site-packages/django/template/base.py in render(937)
  bit = node.render_annotated(context)
/usr/local/lib/python3.6/site-packages/django/template/base.py in render_annotated(904)
  return self.render(context)
/usr/local/lib/python3.6/site-packages/django/template/loader_tags.py in render(188)
  return template.render(context)
/usr/local/lib/python3.6/site-packages/django/template/base.py in render(173)
  return self._render(context)
/usr/local/lib/python3.6/site-packages/django/test/utils.py in instrumented_test_render(96)
  return self.nodelist.render(context)
/usr/local/lib/python3.6/site-packages/django/template/base.py in render(937)
  bit = node.render_annotated(context)
/usr/local/lib/python3.6/site-packages/django/template/base.py in render_annotated(904)
  return self.render(context)
/usr/local/lib/python3.6/site-packages/django/template/defaulttags.py in render(209)
  nodelist.append(node.render_annotated(context))
/usr/local/lib/python3.6/site-packages/django/template/base.py in render_annotated(904)
  return self.render(context)
/usr/local/lib/python3.6/site-packages/django/template/defaulttags.py in render(166)
  len_values = len(values)
1 {% extends 'base_home.html' %}
2 {% load static %}
3 {% load filters %}
4 {% block title %}{{ title }}{% endblock %}

/app/vistar/templates/home.html

  +
SELECT ••• `accounts_jobmaster`.`id`, `accounts_jobmaster`.`create_datetime`, `accounts_jobmaster`.`update_datetime`, `accounts_jobmaster`.`name`, `accounts_jobmaster`.`name_en`, `accounts_jobmaster`.`category_id` FROM `accounts_jobmaster` WHERE `accounts_jobmaster`.`category_id` = 4 ORDER BY `accounts_jobmaster`.`id` ASC
  34 similar queries.   Duplicated 2 times.
0.563520433547913%
0.88

Connection: default

/usr/local/bin/gunicorn in <module>(11)
  sys.exit(run())
/usr/local/lib/python3.6/site-packages/gunicorn/app/wsgiapp.py in run(61)
  WSGIApplication("%(prog)s [OPTIONS] [APP_MODULE]").run()
/usr/local/lib/python3.6/site-packages/gunicorn/app/base.py in run(223)
  super(Application, self).run()
/usr/local/lib/python3.6/site-packages/gunicorn/app/base.py in run(72)
  Arbiter(self).run()
/usr/local/lib/python3.6/site-packages/gunicorn/arbiter.py in run(203)
  self.manage_workers()
/usr/local/lib/python3.6/site-packages/gunicorn/arbiter.py in manage_workers(545)
  self.spawn_workers()
/usr/local/lib/python3.6/site-packages/gunicorn/arbiter.py in spawn_workers(616)
  self.spawn_worker()
/usr/local/lib/python3.6/site-packages/gunicorn/arbiter.py in spawn_worker(583)
  worker.init_process()
/usr/local/lib/python3.6/site-packages/gunicorn/workers/base.py in init_process(134)
  self.run()
/usr/local/lib/python3.6/site-packages/gunicorn/workers/sync.py in run(124)
  self.run_for_one(timeout)
/usr/local/lib/python3.6/site-packages/gunicorn/workers/sync.py in run_for_one(68)
  self.accept(listener)
/usr/local/lib/python3.6/site-packages/gunicorn/workers/sync.py in accept(30)
  self.handle(listener, client, addr)
/usr/local/lib/python3.6/site-packages/gunicorn/workers/sync.py in handle(135)
  self.handle_request(listener, req, client, addr)
/usr/local/lib/python3.6/site-packages/gunicorn/workers/sync.py in handle_request(176)
  respiter = self.wsgi(environ, resp.start_response)
/usr/local/lib/python3.6/cProfile.py in runcall(109)
  return func(*args, **kw)
/app/vistar/home/views.py in index(82)
  return render(request, 'home.html', context)
/usr/local/lib/python3.6/site-packages/django/shortcuts.py in render(36)
  content = loader.render_to_string(template_name, context, request, using=using)
/usr/local/lib/python3.6/site-packages/django/template/loader.py in render_to_string(62)
  return template.render(context, request)
/usr/local/lib/python3.6/site-packages/django/template/backends/django.py in render(61)
  return self.template.render(context)
/usr/local/lib/python3.6/site-packages/django/template/base.py in render(171)
  return self._render(context)
/usr/local/lib/python3.6/site-packages/django/test/utils.py in instrumented_test_render(96)
  return self.nodelist.render(context)
/usr/local/lib/python3.6/site-packages/django/template/base.py in render(937)
  bit = node.render_annotated(context)
/usr/local/lib/python3.6/site-packages/django/template/base.py in render_annotated(904)
  return self.render(context)
/usr/local/lib/python3.6/site-packages/django/template/loader_tags.py in render(150)
  return compiled_parent._render(context)
/usr/local/lib/python3.6/site-packages/django/test/utils.py in instrumented_test_render(96)
  return self.nodelist.render(context)
/usr/local/lib/python3.6/site-packages/django/template/base.py in render(937)
  bit = node.render_annotated(context)
/usr/local/lib/python3.6/site-packages/django/template/base.py in render_annotated(904)
  return self.render(context)
/usr/local/lib/python3.6/site-packages/django/template/loader_tags.py in render(62)
  result = block.nodelist.render(context)
/usr/local/lib/python3.6/site-packages/django/template/base.py in render(937)
  bit = node.render_annotated(context)
/usr/local/lib/python3.6/site-packages/django/template/base.py in render_annotated(904)
  return self.render(context)
/usr/local/lib/python3.6/site-packages/django/template/loader_tags.py in render(188)
  return template.render(context)
/usr/local/lib/python3.6/site-packages/django/template/base.py in render(173)
  return self._render(context)
/usr/local/lib/python3.6/site-packages/django/test/utils.py in instrumented_test_render(96)
  return self.nodelist.render(context)
/usr/local/lib/python3.6/site-packages/django/template/base.py in render(937)
  bit = node.render_annotated(context)
/usr/local/lib/python3.6/site-packages/django/template/base.py in render_annotated(904)
  return self.render(context)
/usr/local/lib/python3.6/site-packages/django/template/defaulttags.py in render(209)
  nodelist.append(node.render_annotated(context))
/usr/local/lib/python3.6/site-packages/django/template/base.py in render_annotated(904)
  return self.render(context)
/usr/local/lib/python3.6/site-packages/django/template/defaulttags.py in render(166)
  len_values = len(values)
1 {% extends 'base_home.html' %}
2 {% load static %}
3 {% load filters %}
4 {% block title %}{{ title }}{% endblock %}

/app/vistar/templates/home.html

  +
SELECT ••• `accounts_jobmaster`.`id`, `accounts_jobmaster`.`create_datetime`, `accounts_jobmaster`.`update_datetime`, `accounts_jobmaster`.`name`, `accounts_jobmaster`.`name_en`, `accounts_jobmaster`.`category_id` FROM `accounts_jobmaster` WHERE `accounts_jobmaster`.`category_id` = 5 ORDER BY `accounts_jobmaster`.`id` ASC
  34 similar queries.   Duplicated 2 times.
0.46186936919697186%
0.72

Connection: default

/usr/local/bin/gunicorn in <module>(11)
  sys.exit(run())
/usr/local/lib/python3.6/site-packages/gunicorn/app/wsgiapp.py in run(61)
  WSGIApplication("%(prog)s [OPTIONS] [APP_MODULE]").run()
/usr/local/lib/python3.6/site-packages/gunicorn/app/base.py in run(223)
  super(Application, self).run()
/usr/local/lib/python3.6/site-packages/gunicorn/app/base.py in run(72)
  Arbiter(self).run()
/usr/local/lib/python3.6/site-packages/gunicorn/arbiter.py in run(203)
  self.manage_workers()
/usr/local/lib/python3.6/site-packages/gunicorn/arbiter.py in manage_workers(545)
  self.spawn_workers()
/usr/local/lib/python3.6/site-packages/gunicorn/arbiter.py in spawn_workers(616)
  self.spawn_worker()
/usr/local/lib/python3.6/site-packages/gunicorn/arbiter.py in spawn_worker(583)
  worker.init_process()
/usr/local/lib/python3.6/site-packages/gunicorn/workers/base.py in init_process(134)
  self.run()
/usr/local/lib/python3.6/site-packages/gunicorn/workers/sync.py in run(124)
  self.run_for_one(timeout)
/usr/local/lib/python3.6/site-packages/gunicorn/workers/sync.py in run_for_one(68)
  self.accept(listener)
/usr/local/lib/python3.6/site-packages/gunicorn/workers/sync.py in accept(30)
  self.handle(listener, client, addr)
/usr/local/lib/python3.6/site-packages/gunicorn/workers/sync.py in handle(135)
  self.handle_request(listener, req, client, addr)
/usr/local/lib/python3.6/site-packages/gunicorn/workers/sync.py in handle_request(176)
  respiter = self.wsgi(environ, resp.start_response)
/usr/local/lib/python3.6/cProfile.py in runcall(109)
  return func(*args, **kw)
/app/vistar/home/views.py in index(82)
  return render(request, 'home.html', context)
/usr/local/lib/python3.6/site-packages/django/shortcuts.py in render(36)
  content = loader.render_to_string(template_name, context, request, using=using)
/usr/local/lib/python3.6/site-packages/django/template/loader.py in render_to_string(62)
  return template.render(context, request)
/usr/local/lib/python3.6/site-packages/django/template/backends/django.py in render(61)
  return self.template.render(context)
/usr/local/lib/python3.6/site-packages/django/template/base.py in render(171)
  return self._render(context)
/usr/local/lib/python3.6/site-packages/django/test/utils.py in instrumented_test_render(96)
  return self.nodelist.render(context)
/usr/local/lib/python3.6/site-packages/django/template/base.py in render(937)
  bit = node.render_annotated(context)
/usr/local/lib/python3.6/site-packages/django/template/base.py in render_annotated(904)
  return self.render(context)
/usr/local/lib/python3.6/site-packages/django/template/loader_tags.py in render(150)
  return compiled_parent._render(context)
/usr/local/lib/python3.6/site-packages/django/test/utils.py in instrumented_test_render(96)
  return self.nodelist.render(context)
/usr/local/lib/python3.6/site-packages/django/template/base.py in render(937)
  bit = node.render_annotated(context)
/usr/local/lib/python3.6/site-packages/django/template/base.py in render_annotated(904)
  return self.render(context)
/usr/local/lib/python3.6/site-packages/django/template/loader_tags.py in render(62)
  result = block.nodelist.render(context)
/usr/local/lib/python3.6/site-packages/django/template/base.py in render(937)
  bit = node.render_annotated(context)
/usr/local/lib/python3.6/site-packages/django/template/base.py in render_annotated(904)
  return self.render(context)
/usr/local/lib/python3.6/site-packages/django/template/loader_tags.py in render(188)
  return template.render(context)
/usr/local/lib/python3.6/site-packages/django/template/base.py in render(173)
  return self._render(context)
/usr/local/lib/python3.6/site-packages/django/test/utils.py in instrumented_test_render(96)
  return self.nodelist.render(context)
/usr/local/lib/python3.6/site-packages/django/template/base.py in render(937)
  bit = node.render_annotated(context)
/usr/local/lib/python3.6/site-packages/django/template/base.py in render_annotated(904)
  return self.render(context)
/usr/local/lib/python3.6/site-packages/django/template/defaulttags.py in render(209)
  nodelist.append(node.render_annotated(context))
/usr/local/lib/python3.6/site-packages/django/template/base.py in render_annotated(904)
  return self.render(context)
/usr/local/lib/python3.6/site-packages/django/template/defaulttags.py in render(166)
  len_values = len(values)
1 {% extends 'base_home.html' %}
2 {% load static %}
3 {% load filters %}
4 {% block title %}{{ title }}{% endblock %}

/app/vistar/templates/home.html

  +
SELECT ••• `accounts_jobmaster`.`id`, `accounts_jobmaster`.`create_datetime`, `accounts_jobmaster`.`update_datetime`, `accounts_jobmaster`.`name`, `accounts_jobmaster`.`name_en`, `accounts_jobmaster`.`category_id` FROM `accounts_jobmaster` WHERE `accounts_jobmaster`.`category_id` = 6 ORDER BY `accounts_jobmaster`.`id` ASC
  34 similar queries.   Duplicated 2 times.
1.3281997504650078%
2.07

Connection: default

/usr/local/bin/gunicorn in <module>(11)
  sys.exit(run())
/usr/local/lib/python3.6/site-packages/gunicorn/app/wsgiapp.py in run(61)
  WSGIApplication("%(prog)s [OPTIONS] [APP_MODULE]").run()
/usr/local/lib/python3.6/site-packages/gunicorn/app/base.py in run(223)
  super(Application, self).run()
/usr/local/lib/python3.6/site-packages/gunicorn/app/base.py in run(72)
  Arbiter(self).run()
/usr/local/lib/python3.6/site-packages/gunicorn/arbiter.py in run(203)
  self.manage_workers()
/usr/local/lib/python3.6/site-packages/gunicorn/arbiter.py in manage_workers(545)
  self.spawn_workers()
/usr/local/lib/python3.6/site-packages/gunicorn/arbiter.py in spawn_workers(616)
  self.spawn_worker()
/usr/local/lib/python3.6/site-packages/gunicorn/arbiter.py in spawn_worker(583)
  worker.init_process()
/usr/local/lib/python3.6/site-packages/gunicorn/workers/base.py in init_process(134)
  self.run()
/usr/local/lib/python3.6/site-packages/gunicorn/workers/sync.py in run(124)
  self.run_for_one(timeout)
/usr/local/lib/python3.6/site-packages/gunicorn/workers/sync.py in run_for_one(68)
  self.accept(listener)
/usr/local/lib/python3.6/site-packages/gunicorn/workers/sync.py in accept(30)
  self.handle(listener, client, addr)
/usr/local/lib/python3.6/site-packages/gunicorn/workers/sync.py in handle(135)
  self.handle_request(listener, req, client, addr)
/usr/local/lib/python3.6/site-packages/gunicorn/workers/sync.py in handle_request(176)
  respiter = self.wsgi(environ, resp.start_response)
/usr/local/lib/python3.6/cProfile.py in runcall(109)
  return func(*args, **kw)
/app/vistar/home/views.py in index(82)
  return render(request, 'home.html', context)
/usr/local/lib/python3.6/site-packages/django/shortcuts.py in render(36)
  content = loader.render_to_string(template_name, context, request, using=using)
/usr/local/lib/python3.6/site-packages/django/template/loader.py in render_to_string(62)
  return template.render(context, request)
/usr/local/lib/python3.6/site-packages/django/template/backends/django.py in render(61)
  return self.template.render(context)
/usr/local/lib/python3.6/site-packages/django/template/base.py in render(171)
  return self._render(context)
/usr/local/lib/python3.6/site-packages/django/test/utils.py in instrumented_test_render(96)
  return self.nodelist.render(context)
/usr/local/lib/python3.6/site-packages/django/template/base.py in render(937)
  bit = node.render_annotated(context)
/usr/local/lib/python3.6/site-packages/django/template/base.py in render_annotated(904)
  return self.render(context)
/usr/local/lib/python3.6/site-packages/django/template/loader_tags.py in render(150)
  return compiled_parent._render(context)
/usr/local/lib/python3.6/site-packages/django/test/utils.py in instrumented_test_render(96)
  return self.nodelist.render(context)
/usr/local/lib/python3.6/site-packages/django/template/base.py in render(937)
  bit = node.render_annotated(context)
/usr/local/lib/python3.6/site-packages/django/template/base.py in render_annotated(904)
  return self.render(context)
/usr/local/lib/python3.6/site-packages/django/template/loader_tags.py in render(62)
  result = block.nodelist.render(context)
/usr/local/lib/python3.6/site-packages/django/template/base.py in render(937)
  bit = node.render_annotated(context)
/usr/local/lib/python3.6/site-packages/django/template/base.py in render_annotated(904)
  return self.render(context)
/usr/local/lib/python3.6/site-packages/django/template/loader_tags.py in render(188)
  return template.render(context)
/usr/local/lib/python3.6/site-packages/django/template/base.py in render(173)
  return self._render(context)
/usr/local/lib/python3.6/site-packages/django/test/utils.py in instrumented_test_render(96)
  return self.nodelist.render(context)
/usr/local/lib/python3.6/site-packages/django/template/base.py in render(937)
  bit = node.render_annotated(context)
/usr/local/lib/python3.6/site-packages/django/template/base.py in render_annotated(904)
  return self.render(context)
/usr/local/lib/python3.6/site-packages/django/template/defaulttags.py in render(209)
  nodelist.append(node.render_annotated(context))
/usr/local/lib/python3.6/site-packages/django/template/base.py in render_annotated(904)
  return self.render(context)
/usr/local/lib/python3.6/site-packages/django/template/defaulttags.py in render(166)
  len_values = len(values)
1 {% extends 'base_home.html' %}
2 {% load static %}
3 {% load filters %}
4 {% block title %}{{ title }}{% endblock %}

/app/vistar/templates/home.html

  +
SELECT ••• `accounts_jobmaster`.`id`, `accounts_jobmaster`.`create_datetime`, `accounts_jobmaster`.`update_datetime`, `accounts_jobmaster`.`name`, `accounts_jobmaster`.`name_en`, `accounts_jobmaster`.`category_id` FROM `accounts_jobmaster` WHERE `accounts_jobmaster`.`category_id` = 7 ORDER BY `accounts_jobmaster`.`id` ASC
  34 similar queries.   Duplicated 2 times.
0.512388723467771%
0.80

Connection: default

/usr/local/bin/gunicorn in <module>(11)
  sys.exit(run())
/usr/local/lib/python3.6/site-packages/gunicorn/app/wsgiapp.py in run(61)
  WSGIApplication("%(prog)s [OPTIONS] [APP_MODULE]").run()
/usr/local/lib/python3.6/site-packages/gunicorn/app/base.py in run(223)
  super(Application, self).run()
/usr/local/lib/python3.6/site-packages/gunicorn/app/base.py in run(72)
  Arbiter(self).run()
/usr/local/lib/python3.6/site-packages/gunicorn/arbiter.py in run(203)
  self.manage_workers()
/usr/local/lib/python3.6/site-packages/gunicorn/arbiter.py in manage_workers(545)
  self.spawn_workers()
/usr/local/lib/python3.6/site-packages/gunicorn/arbiter.py in spawn_workers(616)
  self.spawn_worker()
/usr/local/lib/python3.6/site-packages/gunicorn/arbiter.py in spawn_worker(583)
  worker.init_process()
/usr/local/lib/python3.6/site-packages/gunicorn/workers/base.py in init_process(134)
  self.run()
/usr/local/lib/python3.6/site-packages/gunicorn/workers/sync.py in run(124)
  self.run_for_one(timeout)
/usr/local/lib/python3.6/site-packages/gunicorn/workers/sync.py in run_for_one(68)
  self.accept(listener)
/usr/local/lib/python3.6/site-packages/gunicorn/workers/sync.py in accept(30)
  self.handle(listener, client, addr)
/usr/local/lib/python3.6/site-packages/gunicorn/workers/sync.py in handle(135)
  self.handle_request(listener, req, client, addr)
/usr/local/lib/python3.6/site-packages/gunicorn/workers/sync.py in handle_request(176)
  respiter = self.wsgi(environ, resp.start_response)
/usr/local/lib/python3.6/cProfile.py in runcall(109)
  return func(*args, **kw)
/app/vistar/home/views.py in index(82)
  return render(request, 'home.html', context)
/usr/local/lib/python3.6/site-packages/django/shortcuts.py in render(36)
  content = loader.render_to_string(template_name, context, request, using=using)
/usr/local/lib/python3.6/site-packages/django/template/loader.py in render_to_string(62)
  return template.render(context, request)
/usr/local/lib/python3.6/site-packages/django/template/backends/django.py in render(61)
  return self.template.render(context)
/usr/local/lib/python3.6/site-packages/django/template/base.py in render(171)
  return self._render(context)
/usr/local/lib/python3.6/site-packages/django/test/utils.py in instrumented_test_render(96)
  return self.nodelist.render(context)
/usr/local/lib/python3.6/site-packages/django/template/base.py in render(937)
  bit = node.render_annotated(context)
/usr/local/lib/python3.6/site-packages/django/template/base.py in render_annotated(904)
  return self.render(context)
/usr/local/lib/python3.6/site-packages/django/template/loader_tags.py in render(150)
  return compiled_parent._render(context)
/usr/local/lib/python3.6/site-packages/django/test/utils.py in instrumented_test_render(96)
  return self.nodelist.render(context)
/usr/local/lib/python3.6/site-packages/django/template/base.py in render(937)
  bit = node.render_annotated(context)
/usr/local/lib/python3.6/site-packages/django/template/base.py in render_annotated(904)
  return self.render(context)
/usr/local/lib/python3.6/site-packages/django/template/loader_tags.py in render(62)
  result = block.nodelist.render(context)
/usr/local/lib/python3.6/site-packages/django/template/base.py in render(937)
  bit = node.render_annotated(context)
/usr/local/lib/python3.6/site-packages/django/template/base.py in render_annotated(904)
  return self.render(context)
/usr/local/lib/python3.6/site-packages/django/template/loader_tags.py in render(188)
  return template.render(context)
/usr/local/lib/python3.6/site-packages/django/template/base.py in render(173)
  return self._render(context)
/usr/local/lib/python3.6/site-packages/django/test/utils.py in instrumented_test_render(96)
  return self.nodelist.render(context)
/usr/local/lib/python3.6/site-packages/django/template/base.py in render(937)
  bit = node.render_annotated(context)
/usr/local/lib/python3.6/site-packages/django/template/base.py in render_annotated(904)
  return self.render(context)
/usr/local/lib/python3.6/site-packages/django/template/defaulttags.py in render(209)
  nodelist.append(node.render_annotated(context))
/usr/local/lib/python3.6/site-packages/django/template/base.py in render_annotated(904)
  return self.render(context)
/usr/local/lib/python3.6/site-packages/django/template/defaulttags.py in render(166)
  len_values = len(values)
1 {% extends 'base_home.html' %}
2 {% load static %}
3 {% load filters %}
4 {% block title %}{{ title }}{% endblock %}

/app/vistar/templates/home.html

  +
SELECT ••• `accounts_jobmaster`.`id`, `accounts_jobmaster`.`create_datetime`, `accounts_jobmaster`.`update_datetime`, `accounts_jobmaster`.`name`, `accounts_jobmaster`.`name_en`, `accounts_jobmaster`.`category_id` FROM `accounts_jobmaster` WHERE `accounts_jobmaster`.`category_id` = 8 ORDER BY `accounts_jobmaster`.`id` ASC
  34 similar queries.   Duplicated 2 times.
0.5463744708863085%
0.85

Connection: default

/usr/local/bin/gunicorn in <module>(11)
  sys.exit(run())
/usr/local/lib/python3.6/site-packages/gunicorn/app/wsgiapp.py in run(61)
  WSGIApplication("%(prog)s [OPTIONS] [APP_MODULE]").run()
/usr/local/lib/python3.6/site-packages/gunicorn/app/base.py in run(223)
  super(Application, self).run()
/usr/local/lib/python3.6/site-packages/gunicorn/app/base.py in run(72)
  Arbiter(self).run()
/usr/local/lib/python3.6/site-packages/gunicorn/arbiter.py in run(203)
  self.manage_workers()
/usr/local/lib/python3.6/site-packages/gunicorn/arbiter.py in manage_workers(545)
  self.spawn_workers()
/usr/local/lib/python3.6/site-packages/gunicorn/arbiter.py in spawn_workers(616)
  self.spawn_worker()
/usr/local/lib/python3.6/site-packages/gunicorn/arbiter.py in spawn_worker(583)
  worker.init_process()
/usr/local/lib/python3.6/site-packages/gunicorn/workers/base.py in init_process(134)
  self.run()
/usr/local/lib/python3.6/site-packages/gunicorn/workers/sync.py in run(124)
  self.run_for_one(timeout)
/usr/local/lib/python3.6/site-packages/gunicorn/workers/sync.py in run_for_one(68)
  self.accept(listener)
/usr/local/lib/python3.6/site-packages/gunicorn/workers/sync.py in accept(30)
  self.handle(listener, client, addr)
/usr/local/lib/python3.6/site-packages/gunicorn/workers/sync.py in handle(135)
  self.handle_request(listener, req, client, addr)
/usr/local/lib/python3.6/site-packages/gunicorn/workers/sync.py in handle_request(176)
  respiter = self.wsgi(environ, resp.start_response)
/usr/local/lib/python3.6/cProfile.py in runcall(109)
  return func(*args, **kw)
/app/vistar/home/views.py in index(82)
  return render(request, 'home.html', context)
/usr/local/lib/python3.6/site-packages/django/shortcuts.py in render(36)
  content = loader.render_to_string(template_name, context, request, using=using)
/usr/local/lib/python3.6/site-packages/django/template/loader.py in render_to_string(62)
  return template.render(context, request)
/usr/local/lib/python3.6/site-packages/django/template/backends/django.py in render(61)
  return self.template.render(context)
/usr/local/lib/python3.6/site-packages/django/template/base.py in render(171)
  return self._render(context)
/usr/local/lib/python3.6/site-packages/django/test/utils.py in instrumented_test_render(96)
  return self.nodelist.render(context)
/usr/local/lib/python3.6/site-packages/django/template/base.py in render(937)
  bit = node.render_annotated(context)
/usr/local/lib/python3.6/site-packages/django/template/base.py in render_annotated(904)
  return self.render(context)
/usr/local/lib/python3.6/site-packages/django/template/loader_tags.py in render(150)
  return compiled_parent._render(context)
/usr/local/lib/python3.6/site-packages/django/test/utils.py in instrumented_test_render(96)
  return self.nodelist.render(context)
/usr/local/lib/python3.6/site-packages/django/template/base.py in render(937)
  bit = node.render_annotated(context)
/usr/local/lib/python3.6/site-packages/django/template/base.py in render_annotated(904)
  return self.render(context)
/usr/local/lib/python3.6/site-packages/django/template/loader_tags.py in render(62)
  result = block.nodelist.render(context)
/usr/local/lib/python3.6/site-packages/django/template/base.py in render(937)
  bit = node.render_annotated(context)
/usr/local/lib/python3.6/site-packages/django/template/base.py in render_annotated(904)
  return self.render(context)
/usr/local/lib/python3.6/site-packages/django/template/loader_tags.py in render(188)
  return template.render(context)
/usr/local/lib/python3.6/site-packages/django/template/base.py in render(173)
  return self._render(context)
/usr/local/lib/python3.6/site-packages/django/test/utils.py in instrumented_test_render(96)
  return self.nodelist.render(context)
/usr/local/lib/python3.6/site-packages/django/template/base.py in render(937)
  bit = node.render_annotated(context)
/usr/local/lib/python3.6/site-packages/django/template/base.py in render_annotated(904)
  return self.render(context)
/usr/local/lib/python3.6/site-packages/django/template/defaulttags.py in render(209)
  nodelist.append(node.render_annotated(context))
/usr/local/lib/python3.6/site-packages/django/template/base.py in render_annotated(904)
  return self.render(context)
/usr/local/lib/python3.6/site-packages/django/template/defaulttags.py in render(166)
  len_values = len(values)
1 {% extends 'base_home.html' %}
2 {% load static %}
3 {% load filters %}
4 {% block title %}{{ title }}{% endblock %}

/app/vistar/templates/home.html

  +
SELECT ••• `accounts_jobmaster`.`id`, `accounts_jobmaster`.`create_datetime`, `accounts_jobmaster`.`update_datetime`, `accounts_jobmaster`.`name`, `accounts_jobmaster`.`name_en`, `accounts_jobmaster`.`category_id` FROM `accounts_jobmaster` WHERE `accounts_jobmaster`.`category_id` = 9 ORDER BY `accounts_jobmaster`.`id` ASC
  34 similar queries.   Duplicated 2 times.
0.5125418124201067%
0.80

Connection: default

/usr/local/bin/gunicorn in <module>(11)
  sys.exit(run())
/usr/local/lib/python3.6/site-packages/gunicorn/app/wsgiapp.py in run(61)
  WSGIApplication("%(prog)s [OPTIONS] [APP_MODULE]").run()
/usr/local/lib/python3.6/site-packages/gunicorn/app/base.py in run(223)
  super(Application, self).run()
/usr/local/lib/python3.6/site-packages/gunicorn/app/base.py in run(72)
  Arbiter(self).run()
/usr/local/lib/python3.6/site-packages/gunicorn/arbiter.py in run(203)
  self.manage_workers()
/usr/local/lib/python3.6/site-packages/gunicorn/arbiter.py in manage_workers(545)
  self.spawn_workers()
/usr/local/lib/python3.6/site-packages/gunicorn/arbiter.py in spawn_workers(616)
  self.spawn_worker()
/usr/local/lib/python3.6/site-packages/gunicorn/arbiter.py in spawn_worker(583)
  worker.init_process()
/usr/local/lib/python3.6/site-packages/gunicorn/workers/base.py in init_process(134)
  self.run()
/usr/local/lib/python3.6/site-packages/gunicorn/workers/sync.py in run(124)
  self.run_for_one(timeout)
/usr/local/lib/python3.6/site-packages/gunicorn/workers/sync.py in run_for_one(68)
  self.accept(listener)
/usr/local/lib/python3.6/site-packages/gunicorn/workers/sync.py in accept(30)
  self.handle(listener, client, addr)
/usr/local/lib/python3.6/site-packages/gunicorn/workers/sync.py in handle(135)
  self.handle_request(listener, req, client, addr)
/usr/local/lib/python3.6/site-packages/gunicorn/workers/sync.py in handle_request(176)
  respiter = self.wsgi(environ, resp.start_response)
/usr/local/lib/python3.6/cProfile.py in runcall(109)
  return func(*args, **kw)
/app/vistar/home/views.py in index(82)
  return render(request, 'home.html', context)
/usr/local/lib/python3.6/site-packages/django/shortcuts.py in render(36)
  content = loader.render_to_string(template_name, context, request, using=using)
/usr/local/lib/python3.6/site-packages/django/template/loader.py in render_to_string(62)
  return template.render(context, request)
/usr/local/lib/python3.6/site-packages/django/template/backends/django.py in render(61)
  return self.template.render(context)
/usr/local/lib/python3.6/site-packages/django/template/base.py in render(171)
  return self._render(context)
/usr/local/lib/python3.6/site-packages/django/test/utils.py in instrumented_test_render(96)
  return self.nodelist.render(context)
/usr/local/lib/python3.6/site-packages/django/template/base.py in render(937)
  bit = node.render_annotated(context)
/usr/local/lib/python3.6/site-packages/django/template/base.py in render_annotated(904)
  return self.render(context)
/usr/local/lib/python3.6/site-packages/django/template/loader_tags.py in render(150)
  return compiled_parent._render(context)
/usr/local/lib/python3.6/site-packages/django/test/utils.py in instrumented_test_render(96)
  return self.nodelist.render(context)
/usr/local/lib/python3.6/site-packages/django/template/base.py in render(937)
  bit = node.render_annotated(context)
/usr/local/lib/python3.6/site-packages/django/template/base.py in render_annotated(904)
  return self.render(context)
/usr/local/lib/python3.6/site-packages/django/template/loader_tags.py in render(62)
  result = block.nodelist.render(context)
/usr/local/lib/python3.6/site-packages/django/template/base.py in render(937)
  bit = node.render_annotated(context)
/usr/local/lib/python3.6/site-packages/django/template/base.py in render_annotated(904)
  return self.render(context)
/usr/local/lib/python3.6/site-packages/django/template/loader_tags.py in render(188)
  return template.render(context)
/usr/local/lib/python3.6/site-packages/django/template/base.py in render(173)
  return self._render(context)
/usr/local/lib/python3.6/site-packages/django/test/utils.py in instrumented_test_render(96)
  return self.nodelist.render(context)
/usr/local/lib/python3.6/site-packages/django/template/base.py in render(937)
  bit = node.render_annotated(context)
/usr/local/lib/python3.6/site-packages/django/template/base.py in render_annotated(904)
  return self.render(context)
/usr/local/lib/python3.6/site-packages/django/template/defaulttags.py in render(209)
  nodelist.append(node.render_annotated(context))
/usr/local/lib/python3.6/site-packages/django/template/base.py in render_annotated(904)
  return self.render(context)
/usr/local/lib/python3.6/site-packages/django/template/defaulttags.py in render(166)
  len_values = len(values)
1 {% extends 'base_home.html' %}
2 {% load static %}
3 {% load filters %}
4 {% block title %}{{ title }}{% endblock %}

/app/vistar/templates/home.html

  +
SELECT ••• `accounts_jobmaster`.`id`, `accounts_jobmaster`.`create_datetime`, `accounts_jobmaster`.`update_datetime`, `accounts_jobmaster`.`name`, `accounts_jobmaster`.`name_en`, `accounts_jobmaster`.`category_id` FROM `accounts_jobmaster` WHERE `accounts_jobmaster`.`category_id` = 10 ORDER BY `accounts_jobmaster`.`id` ASC
  34 similar queries.   Duplicated 2 times.
0.48391417833332057%
0.75

Connection: default

/usr/local/bin/gunicorn in <module>(11)
  sys.exit(run())
/usr/local/lib/python3.6/site-packages/gunicorn/app/wsgiapp.py in run(61)
  WSGIApplication("%(prog)s [OPTIONS] [APP_MODULE]").run()
/usr/local/lib/python3.6/site-packages/gunicorn/app/base.py in run(223)
  super(Application, self).run()
/usr/local/lib/python3.6/site-packages/gunicorn/app/base.py in run(72)
  Arbiter(self).run()
/usr/local/lib/python3.6/site-packages/gunicorn/arbiter.py in run(203)
  self.manage_workers()
/usr/local/lib/python3.6/site-packages/gunicorn/arbiter.py in manage_workers(545)
  self.spawn_workers()
/usr/local/lib/python3.6/site-packages/gunicorn/arbiter.py in spawn_workers(616)
  self.spawn_worker()
/usr/local/lib/python3.6/site-packages/gunicorn/arbiter.py in spawn_worker(583)
  worker.init_process()
/usr/local/lib/python3.6/site-packages/gunicorn/workers/base.py in init_process(134)
  self.run()
/usr/local/lib/python3.6/site-packages/gunicorn/workers/sync.py in run(124)
  self.run_for_one(timeout)
/usr/local/lib/python3.6/site-packages/gunicorn/workers/sync.py in run_for_one(68)
  self.accept(listener)
/usr/local/lib/python3.6/site-packages/gunicorn/workers/sync.py in accept(30)
  self.handle(listener, client, addr)
/usr/local/lib/python3.6/site-packages/gunicorn/workers/sync.py in handle(135)
  self.handle_request(listener, req, client, addr)
/usr/local/lib/python3.6/site-packages/gunicorn/workers/sync.py in handle_request(176)
  respiter = self.wsgi(environ, resp.start_response)
/usr/local/lib/python3.6/cProfile.py in runcall(109)
  return func(*args, **kw)
/app/vistar/home/views.py in index(82)
  return render(request, 'home.html', context)
/usr/local/lib/python3.6/site-packages/django/shortcuts.py in render(36)
  content = loader.render_to_string(template_name, context, request, using=using)
/usr/local/lib/python3.6/site-packages/django/template/loader.py in render_to_string(62)
  return template.render(context, request)
/usr/local/lib/python3.6/site-packages/django/template/backends/django.py in render(61)
  return self.template.render(context)
/usr/local/lib/python3.6/site-packages/django/template/base.py in render(171)
  return self._render(context)
/usr/local/lib/python3.6/site-packages/django/test/utils.py in instrumented_test_render(96)
  return self.nodelist.render(context)
/usr/local/lib/python3.6/site-packages/django/template/base.py in render(937)
  bit = node.render_annotated(context)
/usr/local/lib/python3.6/site-packages/django/template/base.py in render_annotated(904)
  return self.render(context)
/usr/local/lib/python3.6/site-packages/django/template/loader_tags.py in render(150)
  return compiled_parent._render(context)
/usr/local/lib/python3.6/site-packages/django/test/utils.py in instrumented_test_render(96)
  return self.nodelist.render(context)
/usr/local/lib/python3.6/site-packages/django/template/base.py in render(937)
  bit = node.render_annotated(context)
/usr/local/lib/python3.6/site-packages/django/template/base.py in render_annotated(904)
  return self.render(context)
/usr/local/lib/python3.6/site-packages/django/template/loader_tags.py in render(62)
  result = block.nodelist.render(context)
/usr/local/lib/python3.6/site-packages/django/template/base.py in render(937)
  bit = node.render_annotated(context)
/usr/local/lib/python3.6/site-packages/django/template/base.py in render_annotated(904)
  return self.render(context)
/usr/local/lib/python3.6/site-packages/django/template/loader_tags.py in render(188)
  return template.render(context)
/usr/local/lib/python3.6/site-packages/django/template/base.py in render(173)
  return self._render(context)
/usr/local/lib/python3.6/site-packages/django/test/utils.py in instrumented_test_render(96)
  return self.nodelist.render(context)
/usr/local/lib/python3.6/site-packages/django/template/base.py in render(937)
  bit = node.render_annotated(context)
/usr/local/lib/python3.6/site-packages/django/template/base.py in render_annotated(904)
  return self.render(context)
/usr/local/lib/python3.6/site-packages/django/template/defaulttags.py in render(209)
  nodelist.append(node.render_annotated(context))
/usr/local/lib/python3.6/site-packages/django/template/base.py in render_annotated(904)
  return self.render(context)
/usr/local/lib/python3.6/site-packages/django/template/defaulttags.py in render(166)
  len_values = len(values)
1 {% extends 'base_home.html' %}
2 {% load static %}
3 {% load filters %}
4 {% block title %}{{ title }}{% endblock %}

/app/vistar/templates/home.html

  +
SELECT ••• `accounts_jobmaster`.`id`, `accounts_jobmaster`.`create_datetime`, `accounts_jobmaster`.`update_datetime`, `accounts_jobmaster`.`name`, `accounts_jobmaster`.`name_en`, `accounts_jobmaster`.`category_id` FROM `accounts_jobmaster` WHERE `accounts_jobmaster`.`category_id` = 11 ORDER BY `accounts_jobmaster`.`id` ASC
  34 similar queries.   Duplicated 2 times.
0.5260136402256531%
0.82

Connection: default

/usr/local/bin/gunicorn in <module>(11)
  sys.exit(run())
/usr/local/lib/python3.6/site-packages/gunicorn/app/wsgiapp.py in run(61)
  WSGIApplication("%(prog)s [OPTIONS] [APP_MODULE]").run()
/usr/local/lib/python3.6/site-packages/gunicorn/app/base.py in run(223)
  super(Application, self).run()
/usr/local/lib/python3.6/site-packages/gunicorn/app/base.py in run(72)
  Arbiter(self).run()
/usr/local/lib/python3.6/site-packages/gunicorn/arbiter.py in run(203)
  self.manage_workers()
/usr/local/lib/python3.6/site-packages/gunicorn/arbiter.py in manage_workers(545)
  self.spawn_workers()
/usr/local/lib/python3.6/site-packages/gunicorn/arbiter.py in spawn_workers(616)
  self.spawn_worker()
/usr/local/lib/python3.6/site-packages/gunicorn/arbiter.py in spawn_worker(583)
  worker.init_process()
/usr/local/lib/python3.6/site-packages/gunicorn/workers/base.py in init_process(134)
  self.run()
/usr/local/lib/python3.6/site-packages/gunicorn/workers/sync.py in run(124)
  self.run_for_one(timeout)
/usr/local/lib/python3.6/site-packages/gunicorn/workers/sync.py in run_for_one(68)
  self.accept(listener)
/usr/local/lib/python3.6/site-packages/gunicorn/workers/sync.py in accept(30)
  self.handle(listener, client, addr)
/usr/local/lib/python3.6/site-packages/gunicorn/workers/sync.py in handle(135)
  self.handle_request(listener, req, client, addr)
/usr/local/lib/python3.6/site-packages/gunicorn/workers/sync.py in handle_request(176)
  respiter = self.wsgi(environ, resp.start_response)
/usr/local/lib/python3.6/cProfile.py in runcall(109)
  return func(*args, **kw)
/app/vistar/home/views.py in index(82)
  return render(request, 'home.html', context)
/usr/local/lib/python3.6/site-packages/django/shortcuts.py in render(36)
  content = loader.render_to_string(template_name, context, request, using=using)
/usr/local/lib/python3.6/site-packages/django/template/loader.py in render_to_string(62)
  return template.render(context, request)
/usr/local/lib/python3.6/site-packages/django/template/backends/django.py in render(61)
  return self.template.render(context)
/usr/local/lib/python3.6/site-packages/django/template/base.py in render(171)
  return self._render(context)
/usr/local/lib/python3.6/site-packages/django/test/utils.py in instrumented_test_render(96)
  return self.nodelist.render(context)
/usr/local/lib/python3.6/site-packages/django/template/base.py in render(937)
  bit = node.render_annotated(context)
/usr/local/lib/python3.6/site-packages/django/template/base.py in render_annotated(904)
  return self.render(context)
/usr/local/lib/python3.6/site-packages/django/template/loader_tags.py in render(150)
  return compiled_parent._render(context)
/usr/local/lib/python3.6/site-packages/django/test/utils.py in instrumented_test_render(96)
  return self.nodelist.render(context)
/usr/local/lib/python3.6/site-packages/django/template/base.py in render(937)
  bit = node.render_annotated(context)
/usr/local/lib/python3.6/site-packages/django/template/base.py in render_annotated(904)
  return self.render(context)
/usr/local/lib/python3.6/site-packages/django/template/loader_tags.py in render(62)
  result = block.nodelist.render(context)
/usr/local/lib/python3.6/site-packages/django/template/base.py in render(937)
  bit = node.render_annotated(context)
/usr/local/lib/python3.6/site-packages/django/template/base.py in render_annotated(904)
  return self.render(context)
/usr/local/lib/python3.6/site-packages/django/template/loader_tags.py in render(188)
  return template.render(context)
/usr/local/lib/python3.6/site-packages/django/template/base.py in render(173)
  return self._render(context)
/usr/local/lib/python3.6/site-packages/django/test/utils.py in instrumented_test_render(96)
  return self.nodelist.render(context)
/usr/local/lib/python3.6/site-packages/django/template/base.py in render(937)
  bit = node.render_annotated(context)
/usr/local/lib/python3.6/site-packages/django/template/base.py in render_annotated(904)
  return self.render(context)
/usr/local/lib/python3.6/site-packages/django/template/defaulttags.py in render(209)
  nodelist.append(node.render_annotated(context))
/usr/local/lib/python3.6/site-packages/django/template/base.py in render_annotated(904)
  return self.render(context)
/usr/local/lib/python3.6/site-packages/django/template/defaulttags.py in render(166)
  len_values = len(values)
1 {% extends 'base_home.html' %}
2 {% load static %}
3 {% load filters %}
4 {% block title %}{{ title }}{% endblock %}

/app/vistar/templates/home.html

  +
SELECT ••• `accounts_jobmaster`.`id`, `accounts_jobmaster`.`create_datetime`, `accounts_jobmaster`.`update_datetime`, `accounts_jobmaster`.`name`, `accounts_jobmaster`.`name_en`, `accounts_jobmaster`.`category_id` FROM `accounts_jobmaster` WHERE `accounts_jobmaster`.`category_id` = 12 ORDER BY `accounts_jobmaster`.`id` ASC
  34 similar queries.   Duplicated 2 times.
0.5347397105087912%
0.83

Connection: default

/usr/local/bin/gunicorn in <module>(11)
  sys.exit(run())
/usr/local/lib/python3.6/site-packages/gunicorn/app/wsgiapp.py in run(61)
  WSGIApplication("%(prog)s [OPTIONS] [APP_MODULE]").run()
/usr/local/lib/python3.6/site-packages/gunicorn/app/base.py in run(223)
  super(Application, self).run()
/usr/local/lib/python3.6/site-packages/gunicorn/app/base.py in run(72)
  Arbiter(self).run()
/usr/local/lib/python3.6/site-packages/gunicorn/arbiter.py in run(203)
  self.manage_workers()
/usr/local/lib/python3.6/site-packages/gunicorn/arbiter.py in manage_workers(545)
  self.spawn_workers()
/usr/local/lib/python3.6/site-packages/gunicorn/arbiter.py in spawn_workers(616)
  self.spawn_worker()
/usr/local/lib/python3.6/site-packages/gunicorn/arbiter.py in spawn_worker(583)
  worker.init_process()
/usr/local/lib/python3.6/site-packages/gunicorn/workers/base.py in init_process(134)
  self.run()
/usr/local/lib/python3.6/site-packages/gunicorn/workers/sync.py in run(124)
  self.run_for_one(timeout)
/usr/local/lib/python3.6/site-packages/gunicorn/workers/sync.py in run_for_one(68)
  self.accept(listener)
/usr/local/lib/python3.6/site-packages/gunicorn/workers/sync.py in accept(30)
  self.handle(listener, client, addr)
/usr/local/lib/python3.6/site-packages/gunicorn/workers/sync.py in handle(135)
  self.handle_request(listener, req, client, addr)
/usr/local/lib/python3.6/site-packages/gunicorn/workers/sync.py in handle_request(176)
  respiter = self.wsgi(environ, resp.start_response)
/usr/local/lib/python3.6/cProfile.py in runcall(109)
  return func(*args, **kw)
/app/vistar/home/views.py in index(82)
  return render(request, 'home.html', context)
/usr/local/lib/python3.6/site-packages/django/shortcuts.py in render(36)
  content = loader.render_to_string(template_name, context, request, using=using)
/usr/local/lib/python3.6/site-packages/django/template/loader.py in render_to_string(62)
  return template.render(context, request)
/usr/local/lib/python3.6/site-packages/django/template/backends/django.py in render(61)
  return self.template.render(context)
/usr/local/lib/python3.6/site-packages/django/template/base.py in render(171)
  return self._render(context)
/usr/local/lib/python3.6/site-packages/django/test/utils.py in instrumented_test_render(96)
  return self.nodelist.render(context)
/usr/local/lib/python3.6/site-packages/django/template/base.py in render(937)
  bit = node.render_annotated(context)
/usr/local/lib/python3.6/site-packages/django/template/base.py in render_annotated(904)
  return self.render(context)
/usr/local/lib/python3.6/site-packages/django/template/loader_tags.py in render(150)
  return compiled_parent._render(context)
/usr/local/lib/python3.6/site-packages/django/test/utils.py in instrumented_test_render(96)
  return self.nodelist.render(context)
/usr/local/lib/python3.6/site-packages/django/template/base.py in render(937)
  bit = node.render_annotated(context)
/usr/local/lib/python3.6/site-packages/django/template/base.py in render_annotated(904)
  return self.render(context)
/usr/local/lib/python3.6/site-packages/django/template/loader_tags.py in render(62)
  result = block.nodelist.render(context)
/usr/local/lib/python3.6/site-packages/django/template/base.py in render(937)
  bit = node.render_annotated(context)
/usr/local/lib/python3.6/site-packages/django/template/base.py in render_annotated(904)
  return self.render(context)
/usr/local/lib/python3.6/site-packages/django/template/loader_tags.py in render(188)
  return template.render(context)
/usr/local/lib/python3.6/site-packages/django/template/base.py in render(173)
  return self._render(context)
/usr/local/lib/python3.6/site-packages/django/test/utils.py in instrumented_test_render(96)
  return self.nodelist.render(context)
/usr/local/lib/python3.6/site-packages/django/template/base.py in render(937)
  bit = node.render_annotated(context)
/usr/local/lib/python3.6/site-packages/django/template/base.py in render_annotated(904)
  return self.render(context)
/usr/local/lib/python3.6/site-packages/django/template/defaulttags.py in render(209)
  nodelist.append(node.render_annotated(context))
/usr/local/lib/python3.6/site-packages/django/template/base.py in render_annotated(904)
  return self.render(context)
/usr/local/lib/python3.6/site-packages/django/template/defaulttags.py in render(166)
  len_values = len(values)
1 {% extends 'base_home.html' %}
2 {% load static %}
3 {% load filters %}
4 {% block title %}{{ title }}{% endblock %}

/app/vistar/templates/home.html

  +
SELECT ••• `accounts_jobmaster`.`id`, `accounts_jobmaster`.`create_datetime`, `accounts_jobmaster`.`update_datetime`, `accounts_jobmaster`.`name`, `accounts_jobmaster`.`name_en`, `accounts_jobmaster`.`category_id` FROM `accounts_jobmaster` WHERE `accounts_jobmaster`.`category_id` = 13 ORDER BY `accounts_jobmaster`.`id` ASC
  34 similar queries.   Duplicated 2 times.
0.4364566031092366%
0.68

Connection: default

/usr/local/bin/gunicorn in <module>(11)
  sys.exit(run())
/usr/local/lib/python3.6/site-packages/gunicorn/app/wsgiapp.py in run(61)
  WSGIApplication("%(prog)s [OPTIONS] [APP_MODULE]").run()
/usr/local/lib/python3.6/site-packages/gunicorn/app/base.py in run(223)
  super(Application, self).run()
/usr/local/lib/python3.6/site-packages/gunicorn/app/base.py in run(72)
  Arbiter(self).run()
/usr/local/lib/python3.6/site-packages/gunicorn/arbiter.py in run(203)
  self.manage_workers()
/usr/local/lib/python3.6/site-packages/gunicorn/arbiter.py in manage_workers(545)
  self.spawn_workers()
/usr/local/lib/python3.6/site-packages/gunicorn/arbiter.py in spawn_workers(616)
  self.spawn_worker()
/usr/local/lib/python3.6/site-packages/gunicorn/arbiter.py in spawn_worker(583)
  worker.init_process()
/usr/local/lib/python3.6/site-packages/gunicorn/workers/base.py in init_process(134)
  self.run()
/usr/local/lib/python3.6/site-packages/gunicorn/workers/sync.py in run(124)
  self.run_for_one(timeout)
/usr/local/lib/python3.6/site-packages/gunicorn/workers/sync.py in run_for_one(68)
  self.accept(listener)
/usr/local/lib/python3.6/site-packages/gunicorn/workers/sync.py in accept(30)
  self.handle(listener, client, addr)
/usr/local/lib/python3.6/site-packages/gunicorn/workers/sync.py in handle(135)
  self.handle_request(listener, req, client, addr)
/usr/local/lib/python3.6/site-packages/gunicorn/workers/sync.py in handle_request(176)
  respiter = self.wsgi(environ, resp.start_response)
/usr/local/lib/python3.6/cProfile.py in runcall(109)
  return func(*args, **kw)
/app/vistar/home/views.py in index(82)
  return render(request, 'home.html', context)
/usr/local/lib/python3.6/site-packages/django/shortcuts.py in render(36)
  content = loader.render_to_string(template_name, context, request, using=using)
/usr/local/lib/python3.6/site-packages/django/template/loader.py in render_to_string(62)
  return template.render(context, request)
/usr/local/lib/python3.6/site-packages/django/template/backends/django.py in render(61)
  return self.template.render(context)
/usr/local/lib/python3.6/site-packages/django/template/base.py in render(171)
  return self._render(context)
/usr/local/lib/python3.6/site-packages/django/test/utils.py in instrumented_test_render(96)
  return self.nodelist.render(context)
/usr/local/lib/python3.6/site-packages/django/template/base.py in render(937)
  bit = node.render_annotated(context)
/usr/local/lib/python3.6/site-packages/django/template/base.py in render_annotated(904)
  return self.render(context)
/usr/local/lib/python3.6/site-packages/django/template/loader_tags.py in render(150)
  return compiled_parent._render(context)
/usr/local/lib/python3.6/site-packages/django/test/utils.py in instrumented_test_render(96)
  return self.nodelist.render(context)
/usr/local/lib/python3.6/site-packages/django/template/base.py in render(937)
  bit = node.render_annotated(context)
/usr/local/lib/python3.6/site-packages/django/template/base.py in render_annotated(904)
  return self.render(context)
/usr/local/lib/python3.6/site-packages/django/template/loader_tags.py in render(62)
  result = block.nodelist.render(context)
/usr/local/lib/python3.6/site-packages/django/template/base.py in render(937)
  bit = node.render_annotated(context)
/usr/local/lib/python3.6/site-packages/django/template/base.py in render_annotated(904)
  return self.render(context)
/usr/local/lib/python3.6/site-packages/django/template/loader_tags.py in render(188)
  return template.render(context)
/usr/local/lib/python3.6/site-packages/django/template/base.py in render(173)
  return self._render(context)
/usr/local/lib/python3.6/site-packages/django/test/utils.py in instrumented_test_render(96)
  return self.nodelist.render(context)
/usr/local/lib/python3.6/site-packages/django/template/base.py in render(937)
  bit = node.render_annotated(context)
/usr/local/lib/python3.6/site-packages/django/template/base.py in render_annotated(904)
  return self.render(context)
/usr/local/lib/python3.6/site-packages/django/template/defaulttags.py in render(209)
  nodelist.append(node.render_annotated(context))
/usr/local/lib/python3.6/site-packages/django/template/base.py in render_annotated(904)
  return self.render(context)
/usr/local/lib/python3.6/site-packages/django/template/defaulttags.py in render(166)
  len_values = len(values)
1 {% extends 'base_home.html' %}
2 {% load static %}
3 {% load filters %}
4 {% block title %}{{ title }}{% endblock %}

/app/vistar/templates/home.html

  +
SELECT ••• `accounts_jobmaster`.`id`, `accounts_jobmaster`.`create_datetime`, `accounts_jobmaster`.`update_datetime`, `accounts_jobmaster`.`name`, `accounts_jobmaster`.`name_en`, `accounts_jobmaster`.`category_id` FROM `accounts_jobmaster` WHERE `accounts_jobmaster`.`category_id` = 14 ORDER BY `accounts_jobmaster`.`id` ASC
  34 similar queries.   Duplicated 2 times.
0.4251280206363907%
0.66

Connection: default

/usr/local/bin/gunicorn in <module>(11)
  sys.exit(run())
/usr/local/lib/python3.6/site-packages/gunicorn/app/wsgiapp.py in run(61)
  WSGIApplication("%(prog)s [OPTIONS] [APP_MODULE]").run()
/usr/local/lib/python3.6/site-packages/gunicorn/app/base.py in run(223)
  super(Application, self).run()
/usr/local/lib/python3.6/site-packages/gunicorn/app/base.py in run(72)
  Arbiter(self).run()
/usr/local/lib/python3.6/site-packages/gunicorn/arbiter.py in run(203)
  self.manage_workers()
/usr/local/lib/python3.6/site-packages/gunicorn/arbiter.py in manage_workers(545)
  self.spawn_workers()
/usr/local/lib/python3.6/site-packages/gunicorn/arbiter.py in spawn_workers(616)
  self.spawn_worker()
/usr/local/lib/python3.6/site-packages/gunicorn/arbiter.py in spawn_worker(583)
  worker.init_process()
/usr/local/lib/python3.6/site-packages/gunicorn/workers/base.py in init_process(134)
  self.run()
/usr/local/lib/python3.6/site-packages/gunicorn/workers/sync.py in run(124)
  self.run_for_one(timeout)
/usr/local/lib/python3.6/site-packages/gunicorn/workers/sync.py in run_for_one(68)
  self.accept(listener)
/usr/local/lib/python3.6/site-packages/gunicorn/workers/sync.py in accept(30)
  self.handle(listener, client, addr)
/usr/local/lib/python3.6/site-packages/gunicorn/workers/sync.py in handle(135)
  self.handle_request(listener, req, client, addr)
/usr/local/lib/python3.6/site-packages/gunicorn/workers/sync.py in handle_request(176)
  respiter = self.wsgi(environ, resp.start_response)
/usr/local/lib/python3.6/cProfile.py in runcall(109)
  return func(*args, **kw)
/app/vistar/home/views.py in index(82)
  return render(request, 'home.html', context)
/usr/local/lib/python3.6/site-packages/django/shortcuts.py in render(36)
  content = loader.render_to_string(template_name, context, request, using=using)
/usr/local/lib/python3.6/site-packages/django/template/loader.py in render_to_string(62)
  return template.render(context, request)
/usr/local/lib/python3.6/site-packages/django/template/backends/django.py in render(61)
  return self.template.render(context)
/usr/local/lib/python3.6/site-packages/django/template/base.py in render(171)
  return self._render(context)
/usr/local/lib/python3.6/site-packages/django/test/utils.py in instrumented_test_render(96)
  return self.nodelist.render(context)
/usr/local/lib/python3.6/site-packages/django/template/base.py in render(937)
  bit = node.render_annotated(context)
/usr/local/lib/python3.6/site-packages/django/template/base.py in render_annotated(904)
  return self.render(context)
/usr/local/lib/python3.6/site-packages/django/template/loader_tags.py in render(150)
  return compiled_parent._render(context)
/usr/local/lib/python3.6/site-packages/django/test/utils.py in instrumented_test_render(96)
  return self.nodelist.render(context)
/usr/local/lib/python3.6/site-packages/django/template/base.py in render(937)
  bit = node.render_annotated(context)
/usr/local/lib/python3.6/site-packages/django/template/base.py in render_annotated(904)
  return self.render(context)
/usr/local/lib/python3.6/site-packages/django/template/loader_tags.py in render(62)
  result = block.nodelist.render(context)
/usr/local/lib/python3.6/site-packages/django/template/base.py in render(937)
  bit = node.render_annotated(context)
/usr/local/lib/python3.6/site-packages/django/template/base.py in render_annotated(904)
  return self.render(context)
/usr/local/lib/python3.6/site-packages/django/template/loader_tags.py in render(188)
  return template.render(context)
/usr/local/lib/python3.6/site-packages/django/template/base.py in render(173)
  return self._render(context)
/usr/local/lib/python3.6/site-packages/django/test/utils.py in instrumented_test_render(96)
  return self.nodelist.render(context)
/usr/local/lib/python3.6/site-packages/django/template/base.py in render(937)
  bit = node.render_annotated(context)
/usr/local/lib/python3.6/site-packages/django/template/base.py in render_annotated(904)
  return self.render(context)
/usr/local/lib/python3.6/site-packages/django/template/defaulttags.py in render(209)
  nodelist.append(node.render_annotated(context))
/usr/local/lib/python3.6/site-packages/django/template/base.py in render_annotated(904)
  return self.render(context)
/usr/local/lib/python3.6/site-packages/django/template/defaulttags.py in render(166)
  len_values = len(values)
1 {% extends 'base_home.html' %}
2 {% load static %}
3 {% load filters %}
4 {% block title %}{{ title }}{% endblock %}

/app/vistar/templates/home.html

  +
SELECT ••• `accounts_jobmaster`.`id`, `accounts_jobmaster`.`create_datetime`, `accounts_jobmaster`.`update_datetime`, `accounts_jobmaster`.`name`, `accounts_jobmaster`.`name_en`, `accounts_jobmaster`.`category_id` FROM `accounts_jobmaster` WHERE `accounts_jobmaster`.`category_id` = 15 ORDER BY `accounts_jobmaster`.`id` ASC
  34 similar queries.   Duplicated 2 times.
0.6073038739159389%
0.95

Connection: default

/usr/local/bin/gunicorn in <module>(11)
  sys.exit(run())
/usr/local/lib/python3.6/site-packages/gunicorn/app/wsgiapp.py in run(61)
  WSGIApplication("%(prog)s [OPTIONS] [APP_MODULE]").run()
/usr/local/lib/python3.6/site-packages/gunicorn/app/base.py in run(223)
  super(Application, self).run()
/usr/local/lib/python3.6/site-packages/gunicorn/app/base.py in run(72)
  Arbiter(self).run()
/usr/local/lib/python3.6/site-packages/gunicorn/arbiter.py in run(203)
  self.manage_workers()
/usr/local/lib/python3.6/site-packages/gunicorn/arbiter.py in manage_workers(545)
  self.spawn_workers()
/usr/local/lib/python3.6/site-packages/gunicorn/arbiter.py in spawn_workers(616)
  self.spawn_worker()
/usr/local/lib/python3.6/site-packages/gunicorn/arbiter.py in spawn_worker(583)
  worker.init_process()
/usr/local/lib/python3.6/site-packages/gunicorn/workers/base.py in init_process(134)
  self.run()
/usr/local/lib/python3.6/site-packages/gunicorn/workers/sync.py in run(124)
  self.run_for_one(timeout)
/usr/local/lib/python3.6/site-packages/gunicorn/workers/sync.py in run_for_one(68)
  self.accept(listener)
/usr/local/lib/python3.6/site-packages/gunicorn/workers/sync.py in accept(30)
  self.handle(listener, client, addr)
/usr/local/lib/python3.6/site-packages/gunicorn/workers/sync.py in handle(135)
  self.handle_request(listener, req, client, addr)
/usr/local/lib/python3.6/site-packages/gunicorn/workers/sync.py in handle_request(176)
  respiter = self.wsgi(environ, resp.start_response)
/usr/local/lib/python3.6/cProfile.py in runcall(109)
  return func(*args, **kw)
/app/vistar/home/views.py in index(82)
  return render(request, 'home.html', context)
/usr/local/lib/python3.6/site-packages/django/shortcuts.py in render(36)
  content = loader.render_to_string(template_name, context, request, using=using)
/usr/local/lib/python3.6/site-packages/django/template/loader.py in render_to_string(62)
  return template.render(context, request)
/usr/local/lib/python3.6/site-packages/django/template/backends/django.py in render(61)
  return self.template.render(context)
/usr/local/lib/python3.6/site-packages/django/template/base.py in render(171)
  return self._render(context)
/usr/local/lib/python3.6/site-packages/django/test/utils.py in instrumented_test_render(96)
  return self.nodelist.render(context)
/usr/local/lib/python3.6/site-packages/django/template/base.py in render(937)
  bit = node.render_annotated(context)
/usr/local/lib/python3.6/site-packages/django/template/base.py in render_annotated(904)
  return self.render(context)
/usr/local/lib/python3.6/site-packages/django/template/loader_tags.py in render(150)
  return compiled_parent._render(context)
/usr/local/lib/python3.6/site-packages/django/test/utils.py in instrumented_test_render(96)
  return self.nodelist.render(context)
/usr/local/lib/python3.6/site-packages/django/template/base.py in render(937)
  bit = node.render_annotated(context)
/usr/local/lib/python3.6/site-packages/django/template/base.py in render_annotated(904)
  return self.render(context)
/usr/local/lib/python3.6/site-packages/django/template/loader_tags.py in render(62)
  result = block.nodelist.render(context)
/usr/local/lib/python3.6/site-packages/django/template/base.py in render(937)
  bit = node.render_annotated(context)
/usr/local/lib/python3.6/site-packages/django/template/base.py in render_annotated(904)
  return self.render(context)
/usr/local/lib/python3.6/site-packages/django/template/loader_tags.py in render(188)
  return template.render(context)
/usr/local/lib/python3.6/site-packages/django/template/base.py in render(173)
  return self._render(context)
/usr/local/lib/python3.6/site-packages/django/test/utils.py in instrumented_test_render(96)
  return self.nodelist.render(context)
/usr/local/lib/python3.6/site-packages/django/template/base.py in render(937)
  bit = node.render_annotated(context)
/usr/local/lib/python3.6/site-packages/django/template/base.py in render_annotated(904)
  return self.render(context)
/usr/local/lib/python3.6/site-packages/django/template/defaulttags.py in render(209)
  nodelist.append(node.render_annotated(context))
/usr/local/lib/python3.6/site-packages/django/template/base.py in render_annotated(904)
  return self.render(context)
/usr/local/lib/python3.6/site-packages/django/template/defaulttags.py in render(166)
  len_values = len(values)
1 {% extends 'base_home.html' %}
2 {% load static %}
3 {% load filters %}
4 {% block title %}{{ title }}{% endblock %}

/app/vistar/templates/home.html

  +
SELECT ••• `accounts_jobmaster`.`id`, `accounts_jobmaster`.`create_datetime`, `accounts_jobmaster`.`update_datetime`, `accounts_jobmaster`.`name`, `accounts_jobmaster`.`name_en`, `accounts_jobmaster`.`category_id` FROM `accounts_jobmaster` WHERE `accounts_jobmaster`.`category_id` = 16 ORDER BY `accounts_jobmaster`.`id` ASC
  34 similar queries.   Duplicated 2 times.
0.4846796230949993%
0.75

Connection: default

/usr/local/bin/gunicorn in <module>(11)
  sys.exit(run())
/usr/local/lib/python3.6/site-packages/gunicorn/app/wsgiapp.py in run(61)
  WSGIApplication("%(prog)s [OPTIONS] [APP_MODULE]").run()
/usr/local/lib/python3.6/site-packages/gunicorn/app/base.py in run(223)
  super(Application, self).run()
/usr/local/lib/python3.6/site-packages/gunicorn/app/base.py in run(72)
  Arbiter(self).run()
/usr/local/lib/python3.6/site-packages/gunicorn/arbiter.py in run(203)
  self.manage_workers()
/usr/local/lib/python3.6/site-packages/gunicorn/arbiter.py in manage_workers(545)
  self.spawn_workers()
/usr/local/lib/python3.6/site-packages/gunicorn/arbiter.py in spawn_workers(616)
  self.spawn_worker()
/usr/local/lib/python3.6/site-packages/gunicorn/arbiter.py in spawn_worker(583)
  worker.init_process()
/usr/local/lib/python3.6/site-packages/gunicorn/workers/base.py in init_process(134)
  self.run()
/usr/local/lib/python3.6/site-packages/gunicorn/workers/sync.py in run(124)
  self.run_for_one(timeout)
/usr/local/lib/python3.6/site-packages/gunicorn/workers/sync.py in run_for_one(68)
  self.accept(listener)
/usr/local/lib/python3.6/site-packages/gunicorn/workers/sync.py in accept(30)
  self.handle(listener, client, addr)
/usr/local/lib/python3.6/site-packages/gunicorn/workers/sync.py in handle(135)
  self.handle_request(listener, req, client, addr)
/usr/local/lib/python3.6/site-packages/gunicorn/workers/sync.py in handle_request(176)
  respiter = self.wsgi(environ, resp.start_response)
/usr/local/lib/python3.6/cProfile.py in runcall(109)
  return func(*args, **kw)
/app/vistar/home/views.py in index(82)
  return render(request, 'home.html', context)
/usr/local/lib/python3.6/site-packages/django/shortcuts.py in render(36)
  content = loader.render_to_string(template_name, context, request, using=using)
/usr/local/lib/python3.6/site-packages/django/template/loader.py in render_to_string(62)
  return template.render(context, request)
/usr/local/lib/python3.6/site-packages/django/template/backends/django.py in render(61)
  return self.template.render(context)
/usr/local/lib/python3.6/site-packages/django/template/base.py in render(171)
  return self._render(context)
/usr/local/lib/python3.6/site-packages/django/test/utils.py in instrumented_test_render(96)
  return self.nodelist.render(context)
/usr/local/lib/python3.6/site-packages/django/template/base.py in render(937)
  bit = node.render_annotated(context)
/usr/local/lib/python3.6/site-packages/django/template/base.py in render_annotated(904)
  return self.render(context)
/usr/local/lib/python3.6/site-packages/django/template/loader_tags.py in render(150)
  return compiled_parent._render(context)
/usr/local/lib/python3.6/site-packages/django/test/utils.py in instrumented_test_render(96)
  return self.nodelist.render(context)
/usr/local/lib/python3.6/site-packages/django/template/base.py in render(937)
  bit = node.render_annotated(context)
/usr/local/lib/python3.6/site-packages/django/template/base.py in render_annotated(904)
  return self.render(context)
/usr/local/lib/python3.6/site-packages/django/template/loader_tags.py in render(62)
  result = block.nodelist.render(context)
/usr/local/lib/python3.6/site-packages/django/template/base.py in render(937)
  bit = node.render_annotated(context)
/usr/local/lib/python3.6/site-packages/django/template/base.py in render_annotated(904)
  return self.render(context)
/usr/local/lib/python3.6/site-packages/django/template/loader_tags.py in render(188)
  return template.render(context)
/usr/local/lib/python3.6/site-packages/django/template/base.py in render(173)
  return self._render(context)
/usr/local/lib/python3.6/site-packages/django/test/utils.py in instrumented_test_render(96)
  return self.nodelist.render(context)
/usr/local/lib/python3.6/site-packages/django/template/base.py in render(937)
  bit = node.render_annotated(context)
/usr/local/lib/python3.6/site-packages/django/template/base.py in render_annotated(904)
  return self.render(context)
/usr/local/lib/python3.6/site-packages/django/template/defaulttags.py in render(209)
  nodelist.append(node.render_annotated(context))
/usr/local/lib/python3.6/site-packages/django/template/base.py in render_annotated(904)
  return self.render(context)
/usr/local/lib/python3.6/site-packages/django/template/defaulttags.py in render(166)
  len_values = len(values)
1 {% extends 'base_home.html' %}
2 {% load static %}
3 {% load filters %}
4 {% block title %}{{ title }}{% endblock %}

/app/vistar/templates/home.html

  +
SELECT ••• `accounts_jobmaster`.`id`, `accounts_jobmaster`.`create_datetime`, `accounts_jobmaster`.`update_datetime`, `accounts_jobmaster`.`name`, `accounts_jobmaster`.`name_en`, `accounts_jobmaster`.`category_id` FROM `accounts_jobmaster` WHERE `accounts_jobmaster`.`category_id` = 17 ORDER BY `accounts_jobmaster`.`id` ASC
  34 similar queries.   Duplicated 2 times.
0.488047580046386%
0.76

Connection: default

/usr/local/bin/gunicorn in <module>(11)
  sys.exit(run())
/usr/local/lib/python3.6/site-packages/gunicorn/app/wsgiapp.py in run(61)
  WSGIApplication("%(prog)s [OPTIONS] [APP_MODULE]").run()
/usr/local/lib/python3.6/site-packages/gunicorn/app/base.py in run(223)
  super(Application, self).run()
/usr/local/lib/python3.6/site-packages/gunicorn/app/base.py in run(72)
  Arbiter(self).run()
/usr/local/lib/python3.6/site-packages/gunicorn/arbiter.py in run(203)
  self.manage_workers()
/usr/local/lib/python3.6/site-packages/gunicorn/arbiter.py in manage_workers(545)
  self.spawn_workers()
/usr/local/lib/python3.6/site-packages/gunicorn/arbiter.py in spawn_workers(616)
  self.spawn_worker()
/usr/local/lib/python3.6/site-packages/gunicorn/arbiter.py in spawn_worker(583)
  worker.init_process()
/usr/local/lib/python3.6/site-packages/gunicorn/workers/base.py in init_process(134)
  self.run()
/usr/local/lib/python3.6/site-packages/gunicorn/workers/sync.py in run(124)
  self.run_for_one(timeout)
/usr/local/lib/python3.6/site-packages/gunicorn/workers/sync.py in run_for_one(68)
  self.accept(listener)
/usr/local/lib/python3.6/site-packages/gunicorn/workers/sync.py in accept(30)
  self.handle(listener, client, addr)
/usr/local/lib/python3.6/site-packages/gunicorn/workers/sync.py in handle(135)
  self.handle_request(listener, req, client, addr)
/usr/local/lib/python3.6/site-packages/gunicorn/workers/sync.py in handle_request(176)
  respiter = self.wsgi(environ, resp.start_response)
/usr/local/lib/python3.6/cProfile.py in runcall(109)
  return func(*args, **kw)
/app/vistar/home/views.py in index(82)
  return render(request, 'home.html', context)
/usr/local/lib/python3.6/site-packages/django/shortcuts.py in render(36)
  content = loader.render_to_string(template_name, context, request, using=using)
/usr/local/lib/python3.6/site-packages/django/template/loader.py in render_to_string(62)
  return template.render(context, request)
/usr/local/lib/python3.6/site-packages/django/template/backends/django.py in render(61)
  return self.template.render(context)
/usr/local/lib/python3.6/site-packages/django/template/base.py in render(171)
  return self._render(context)
/usr/local/lib/python3.6/site-packages/django/test/utils.py in instrumented_test_render(96)
  return self.nodelist.render(context)
/usr/local/lib/python3.6/site-packages/django/template/base.py in render(937)
  bit = node.render_annotated(context)
/usr/local/lib/python3.6/site-packages/django/template/base.py in render_annotated(904)
  return self.render(context)
/usr/local/lib/python3.6/site-packages/django/template/loader_tags.py in render(150)
  return compiled_parent._render(context)
/usr/local/lib/python3.6/site-packages/django/test/utils.py in instrumented_test_render(96)
  return self.nodelist.render(context)
/usr/local/lib/python3.6/site-packages/django/template/base.py in render(937)
  bit = node.render_annotated(context)
/usr/local/lib/python3.6/site-packages/django/template/base.py in render_annotated(904)
  return self.render(context)
/usr/local/lib/python3.6/site-packages/django/template/loader_tags.py in render(62)
  result = block.nodelist.render(context)
/usr/local/lib/python3.6/site-packages/django/template/base.py in render(937)
  bit = node.render_annotated(context)
/usr/local/lib/python3.6/site-packages/django/template/base.py in render_annotated(904)
  return self.render(context)
/usr/local/lib/python3.6/site-packages/django/template/loader_tags.py in render(188)
  return template.render(context)
/usr/local/lib/python3.6/site-packages/django/template/base.py in render(173)
  return self._render(context)
/usr/local/lib/python3.6/site-packages/django/test/utils.py in instrumented_test_render(96)
  return self.nodelist.render(context)
/usr/local/lib/python3.6/site-packages/django/template/base.py in render(937)
  bit = node.render_annotated(context)
/usr/local/lib/python3.6/site-packages/django/template/base.py in render_annotated(904)
  return self.render(context)
/usr/local/lib/python3.6/site-packages/django/template/defaulttags.py in render(209)
  nodelist.append(node.render_annotated(context))
/usr/local/lib/python3.6/site-packages/django/template/base.py in render_annotated(904)
  return self.render(context)
/usr/local/lib/python3.6/site-packages/django/template/defaulttags.py in render(166)
  len_values = len(values)
1 {% extends 'base_home.html' %}
2 {% load static %}
3 {% load filters %}
4 {% block title %}{{ title }}{% endblock %}

/app/vistar/templates/home.html

  +
SELECT ••• `accounts_customuser`.`id`, `accounts_customuser`.`password`, `accounts_customuser`.`last_login`, `accounts_customuser`.`is_superuser`, `accounts_customuser`.`username`, `accounts_customuser`.`is_staff`, `accounts_customuser`.`is_active`, `accounts_customuser`.`date_joined`, `accounts_customuser`.`first_name`, `accounts_customuser`.`last_name`, `accounts_customuser`.`first_name_en`, `accounts_customuser`.`last_name_en`, `accounts_customuser`.`email`, `accounts_customuser`.`is_recommend` FROM `accounts_customuser` LEFT OUTER JOIN `accounts_user_profile` ON (`accounts_customuser`.`id` = `accounts_user_profile`.`user_id`) WHERE `accounts_customuser`.`is_superuser` = 0 ORDER BY `accounts_user_profile`.`view_count` DESC LIMIT 20
0.8471942622260664%
1.32

Connection: default

/usr/local/bin/gunicorn in <module>(11)
  sys.exit(run())
/usr/local/lib/python3.6/site-packages/gunicorn/app/wsgiapp.py in run(61)
  WSGIApplication("%(prog)s [OPTIONS] [APP_MODULE]").run()
/usr/local/lib/python3.6/site-packages/gunicorn/app/base.py in run(223)
  super(Application, self).run()
/usr/local/lib/python3.6/site-packages/gunicorn/app/base.py in run(72)
  Arbiter(self).run()
/usr/local/lib/python3.6/site-packages/gunicorn/arbiter.py in run(203)
  self.manage_workers()
/usr/local/lib/python3.6/site-packages/gunicorn/arbiter.py in manage_workers(545)
  self.spawn_workers()
/usr/local/lib/python3.6/site-packages/gunicorn/arbiter.py in spawn_workers(616)
  self.spawn_worker()
/usr/local/lib/python3.6/site-packages/gunicorn/arbiter.py in spawn_worker(583)
  worker.init_process()
/usr/local/lib/python3.6/site-packages/gunicorn/workers/base.py in init_process(134)
  self.run()
/usr/local/lib/python3.6/site-packages/gunicorn/workers/sync.py in run(124)
  self.run_for_one(timeout)
/usr/local/lib/python3.6/site-packages/gunicorn/workers/sync.py in run_for_one(68)
  self.accept(listener)
/usr/local/lib/python3.6/site-packages/gunicorn/workers/sync.py in accept(30)
  self.handle(listener, client, addr)
/usr/local/lib/python3.6/site-packages/gunicorn/workers/sync.py in handle(135)
  self.handle_request(listener, req, client, addr)
/usr/local/lib/python3.6/site-packages/gunicorn/workers/sync.py in handle_request(176)
  respiter = self.wsgi(environ, resp.start_response)
/usr/local/lib/python3.6/cProfile.py in runcall(109)
  return func(*args, **kw)
/app/vistar/home/views.py in index(82)
  return render(request, 'home.html', context)
/usr/local/lib/python3.6/site-packages/django/shortcuts.py in render(36)
  content = loader.render_to_string(template_name, context, request, using=using)
/usr/local/lib/python3.6/site-packages/django/template/loader.py in render_to_string(62)
  return template.render(context, request)
/usr/local/lib/python3.6/site-packages/django/template/backends/django.py in render(61)
  return self.template.render(context)
/usr/local/lib/python3.6/site-packages/django/template/base.py in render(171)
  return self._render(context)
/usr/local/lib/python3.6/site-packages/django/test/utils.py in instrumented_test_render(96)
  return self.nodelist.render(context)
/usr/local/lib/python3.6/site-packages/django/template/base.py in render(937)
  bit = node.render_annotated(context)
/usr/local/lib/python3.6/site-packages/django/template/base.py in render_annotated(904)
  return self.render(context)
/usr/local/lib/python3.6/site-packages/django/template/loader_tags.py in render(150)
  return compiled_parent._render(context)
/usr/local/lib/python3.6/site-packages/django/test/utils.py in instrumented_test_render(96)
  return self.nodelist.render(context)
/usr/local/lib/python3.6/site-packages/django/template/base.py in render(937)
  bit = node.render_annotated(context)
/usr/local/lib/python3.6/site-packages/django/template/base.py in render_annotated(904)
  return self.render(context)
/usr/local/lib/python3.6/site-packages/django/template/loader_tags.py in render(62)
  result = block.nodelist.render(context)
/usr/local/lib/python3.6/site-packages/django/template/base.py in render(937)
  bit = node.render_annotated(context)
/usr/local/lib/python3.6/site-packages/django/template/base.py in render_annotated(904)
  return self.render(context)
/usr/local/lib/python3.6/site-packages/django/template/defaulttags.py in render(166)
  len_values = len(values)