Image
Regional Meeting Series

BLOCK HIV/HCV

Bringing Local Communities Together to Eliminate Coinfection Through Knowledge and Partnerships.

Meeting Slides

Clinical Practice Guidelines

Considerations for Antiretroviral Use in Patients With Coinfections: Hepatitis C Virus/HIV Coinfection.

US Department of Health and Human Services (DHHS), 2017 (last updated October 2018).

Evaluation and Management of Chronic Hepatitis C Virus (HCV) Infection.

Federal Bureau of Prisons Clinical Guidance. 2018.

HCV Guidance: Recommendations for Testing, Managing, and Treating Hepatitis C.

American Association for the Study of Liver Diseases (AASLD)/Infectious Diseases Society of America (IDSA), Last updated November 2019.

Screening for Hepatitis C Virus Infection in Adolescents and Adults: US Preventive Services Task Force (USPSTF) Recommendation Statement.

USPSTF. JAMA. 2020;323(10):970-975.

Clinical Resources

A Guide to Comprehensive Hepatitis C Counseling and Testing.

Centers for Disease Control and Prevention (CDC).

Harm Reduction Coalition.

 

HEP Drug Interactions.

University of Liverpool (last reviewed May 2019).

PREP-C: Psychosocial Readiness Evaluation and Preparation for Hepatitis C Treatment.

Mount Sinai School of Medicine.

Rural Health Information Hub.

Action and Advocacy

Center for Health Law and Policy Innovation (CHLPI)

CHLPI advocates for legal, regulatory, and policy reforms to improve the health of underserved populations. It has played a pivotal role in removing Medicaid restrictions on HCV treatment.

Hepatitis Education Project (HEP)

HEP provides support, education, advocacy, and direct services for people affected by hepatitis, and works to raise hepatitis awareness among patients, medical providers, and the general public.

National Hepatitis Corrections Network (NHCN)

NHCN, managed by HEP, supports a public health approach to hepatitis education, prevention, testing, and treatment in prisons and jails.

National Viral Hepatitis Roundtable

National Viral Hepatitis Roundtable (NVHR) is a coalition working together to eliminate hepatitis B and C in the U.S. It offers practical online resources for practice management.

Project ECHO (Extension for Community Healthcare Outcomes)

Project ECHO is a collaborative, telecommunications-based model of medical education and care management designed to train primary care clinicians to provide specialty care in rural and underserved communities.

Substance Abuse and Mental Health Services Administration (SAMHSA): Locator Map

SAMHSA provides an interactive national map that facilitates identification of local resources and services for substance use and mental health disorders.

Patient Resources

Addiction Group

Addiction Group is an informational website that provides authoritative medical content and treatment resources for individuals with substance use disorders, alcohol use disorders, and/or co-occurring mental health disorders.

Hepatitis C Information Center

American Liver Foundation.
The American Liver Foundation’s Hepatitis C Information Center website is a dedicated online information and resource center created in support of individuals impacted by HCV infection.

HepatitisC.net

HepatitisC.net is a website for people living with HCV that offers education, tools, and resources. Articles are written by people living with or cured of HCV, patient advocates, and medical providers.

Hepatitis C Questions and Answers for the Public

Centers for Disease Control and Prevention (CDC; last reviewed November 2018). The CDC is a division within the US Department of Health and Human Services (DHHS), the principal agency for protecting the health of all Americans. This patient-directed website addresses basics across the HCV clinical continuum.

The BodyPro - Project Inform

Project Inform promotes the development of effective HIV and HCV therapies; supports patients’ informed choices about their health; advocates for quality, affordable health care; and addresses medical strategies that prevent new infections.

Suggested Readings

Knowledge, attitudes, and practices related to hepatitis C among gay and bisexual men in the era of direct-acting antivirals: implications for treatment and prevention.

Brener L, et al. J Cult Health Sex. 2020;22(5):551-567.

Individual and network factors associated with HCV treatment uptake among people who inject drugs.

Falade-Nwulia O, et al. Int J Drug Policy. 2020;78:102714.

“Everybody living with a chronic disease is entitled to be cured”: challenges and opportunities in scaling up access to direct-acting antiviral hepatitis C virus treatment among people who inject drugs.

Goodyear T, et al. Int J Drug Policy. 2020;81:102766.

Hepatitis C reinfection after successful antiviral treatment among people who inject drugs: a meta-analysis.

Hajarizadeh B, et al. J Hepatol. 2020;72(4):643-657.

Hepatitis C in pregnancy: a unique opportunity to improve the hepatitis C cascade of care.

Kushner T, Terrault NA. Hepatol Commun. 2019;3(1):20-28.

Barriers and facilitators to engaging in hepatitis C management and DAA therapy among general practitioners and drug and alcohol specialists—the practitioner experience.

Marshall AD, et al. Drug Alcohol Depend. 2020;206:107705.

Clients' perceptions of barriers and facilitators to implementing hepatitis C virus care in homeless shelters.

Masson CL, et al. BMC Infect Dis. 2020;20(1):386.

Interactive Presentation

Addressing Barriers and Challenges to HCV Elimination

Narrated by Robert Greenwald

Activity
BLOCK HIV/HCV

Bringing Local Communities Together to Eliminate Coinfection Through Knowledge and Partnerships

More information

Relevant Resources

PrEP for Your Patients’ Needs

The PCPs Role in Preventing HIV

Value-Based HIV Formularies

Optimizing Use of Clinical Evidence & Pharmacoeconomic Models in Managed Care

Targeting NASH

Advances in the Diagnosis and Treatment of Nonalcoholic Steatohepatitis

Hepatitis C is Curable

Got it? Treat it!

Real-World Issues in HIV Prevention & Treatment

The Critical Role of the Community Pharmacist

Evolving Models of HIV Care

Volume 1: Rapid ART Initiation: A New Addition to the HIV-Care Tool Box

The Nexus of NASH and Type 2 Diabetes Mellitus

The Emerging Role of the Diabetologist

Updates in HCV Screening and Treatment

Key Issues Impacting OB/GYN Practice

The Big Picture of IBD

An Interactive Experience Highlighting Recent Clinical Advances

Clinical Issues in Chronic Liver Disease

Hot Topics in HBV, HCV, and NASH

The Changing Landscape of IBD

Emerging Concepts in Patient Management

The Big (& Small) Picture of Nonalcoholic Steatohepatitis

Building Your Understanding to Combat a Growing Problem

Evolving Models of HIV Care

Volume II: Expanding Evidence for the Role of Rapid ART Initiation in HIV Practice

Assessing Your Patients for HCV and HIV

Why It Matters in OB/GYN Practice Today

HIV as a Chronic Disease

A Treater’s Guide to Optimizing Care in the Aging Patient with Comorbidities

The Pursuit of Hepatitis C Elimination

How the Pharmacist Can Make a Difference

Trends in Infectious Diseases: Updates on Treatment & Prevention Strategies for HIV and HCV

Understanding the Growing Syndemic — Opioids, HCV, and HIV

Trends and Updates in IBD

Appraising the Therapeutic Armamentarium in Moderate and Severe Disease

Stepping Up to the Challenge

The PCP’s Role in HCV Elimination

The Changing Landscape of HIV Prevention

What the Pharmacist Needs to Know about PrEP

Evolving Models of HIV Care (Volume 3)

The Rapid ART Standard of Care: From Evidence to Healthcare Equity

HIV Updates for Pharmacy Practice

Maximizing Your Role to Impact Patient Outcomes

BRIDGE HCV

Building Bridges to Reach People Who Inject Drugs With the Goal to Eliminate HCV

Case Challenges in HIV Medicine

Benefits, Barriers, & Best Practices in an Advancing Field

Challenges and Opportunities in HIV

Practical Solutions Across the Spectrum of Care

Expanding HIV Prevention in Colorado—and Nationwide

A PEP/PrEP Training Guide for Pharmacists

Setting a Course for the Optimal Management of IBD

An Interactive Learning Experience

Treating Hepatitis C in the Primary Care Setting

A Critical Step Toward HCV Elimination

Honing Clinical Skills in HIV Treatment

Considering the Patient, the Provider, and the Science

Hot Topics in HCV

A Multidisciplinary Online Mini-Curriculum

IBD Journal Club:

Volume 1: A Guided Tour of the Evidence Driving Selection of First-line Advanced Therapies in Moderate to Severe IBD

Clinical Issues in COVID-19

Debates and Discussions about Monoclonal Antibody Therapies

MINIMIZING PATIENT RISKS FROM COVID-19

An Update on Monoclonal Antibody Therapies

ExchangeCME is a division of InSci Productions, LLC.

2021 © InSci Productions, LLC.
Material may not be published,
broadcast, rewritten, or
redistributed in any form without
prior authorization.

Your use of this website constitutes
acceptance of InSci Productions, LLC

Privacy Policy and Terms of Use.

TOOLBAR

Yii 1.1.12

Request
Request Server Parameters
USER 'www-data'
HOME '/var/www'
HTTP_CONNECTION 'Keep-Alive'
HTTP_HOST 'www.exchangecme.com'
HTTP_ACCEPT_ENCODING 'br,gzip'
HTTP_IF_MODIFIED_SINCE 'Tue, 09 Mar 2021 01:19:41 GMT'
HTTP_ACCEPT_LANGUAGE 'en-US,en;q=0.5'
HTTP_ACCEPT 'text/html,application/xhtml+xml,application/xml;q=0.9,*/*;q=0.8'
HTTP_USER_AGENT 'CCBot/2.0 (https://commoncrawl.org/faq/)'
PATH_INFO '/index.php'
REDIRECT_STATUS '200'
HTTPS 'on'
SERVER_NAME 'exchangecme.com'
SERVER_PORT '443'
SERVER_ADDR '172.31.18.208'
REMOTE_PORT '39266'
REMOTE_ADDR '3.215.177.171'
SERVER_SOFTWARE 'nginx/1.4.6'
GATEWAY_INTERFACE 'CGI/1.1'
SERVER_PROTOCOL 'HTTP/1.1'
DOCUMENT_ROOT '/var/www/exchangecme'
DOCUMENT_URI '/index.php'
REQUEST_URI '/BLOCKHIVHCV'
SCRIPT_NAME '/index.php'
SCRIPT_FILENAME '/var/www/exchangecme/index.php'
CONTENT_LENGTH ''
CONTENT_TYPE ''
REQUEST_METHOD 'GET'
QUERY_STRING ''
FCGI_ROLE 'RESPONDER'
PHP_SELF '/index.php/index.php'
REQUEST_TIME_FLOAT 1632356551.6756
REQUEST_TIME 1632356551
Request Cookies
Session Attributes
Request GET Parameters
id '84'
Request POST Parameters
Request FILES
Application Settings
Application Properties
defaultController 'site'
layout 'main'
controllerMap array
(
'debug' => array
(
'class' => 'YiiDebugController'
)
)
catchAllRequest null
controllerNamespace null
name 'ExchangeCME'
charset 'UTF-8'
sourceLanguage 'en_us'
preload array
(
0 => 'log'
)
behaviors array()
Modules
gii array
(
'class' => 'system.gii.GiiModule'
'password' => '123123'
'ipFilters' => array
(
0 => '*'
)
)
Application Params
dateFormat 'm/d/Y'
lastTimeToAttendEvent 172800
passTestLine 70
maxFileSize 1048576
imageDir '/var/www/exchangecme/files/upload/images'
linkImageDir '/files/upload/images'
linkInterDir '/files/upload/interactions'
actUpDir '/activities'
newsUpDir '/news'
resUpDir '/resources'
evUpDir '/events'
interScormDir '/scorm'
environment 'prod'
mandrillApiKey 'bOVWUkHldCbJevygSZtrVg'
rememberTime 'INTERVAL 1 DAY'
fromEmail 'support@exchangeCME.com'
fromName 'exchangeCME.com'
infoEmail 'info@exchangecme.com'
infoEmail2 'info@integritasgrp.com'
subject 'Registration'
certificates array
(
'sizes' => array
(
1 => array
(
'w' => 500
'h' => 398
)
2 => array
(
'w' => 30
'h' => 30
)
)
)
sms array
(
'api_key' => '315336da'
'api_secret' => 'c37c6167be626d2d'
'to' => '12016818114'
'from' => '12016958971'
)
adobeConnect array
(
'adminEmail' => ''
'adminPassword' => ''
)
timeZone 'America/New_York'
bigmarketWebinar array
(
'host' => 'https://www.bigmarker.com/'
'apiKey' => 'c76d1dea6472a01db6ca'
)
baseUrl 'https://www.exchangecme.com'
zoomWebinar array
(
'host' => 'https://api.zoom.us/'
'access_token' => 'eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJhdWQiOm51bGwsImlzcyI6Ikc4cEg4Vk9HVDBtMW1RRGY4SVh1MkEiLCJleHAiOjE4OTgyMzkwMjAsImlhdCI6MTYxMzYzNzQ5MX0.gRKOnZlOSWOnYgtC-BG-Sxw_x9h82TKKohotwptw-Wo'
)
Components
urlManager array
(
'class' => 'CUrlManager'
'rules' => array
(
'/' => 'site/index'
'<view:(terms|privacy)>' => 'site/page'
'admin' => 'backend/site/index'
'activities' => 'activities/index'
'groups/<group:[\w\d.-]+>' => 'activities/group'
'group-events/<group:[\w\d.-]+>' => 'events/group'
'site' => 'site/index'
'googleSearch' => 'site/googleSearch'
'search' => 'site/search'
'subscription' => 'site/subscription'
'events' => 'events/index'
'resources' => 'resources/index'
'<controller:(certificates|news|questions|site|users|activities|eventActivities|events)>/<action:\w+>' => '<controller>/<action>'
'<controller:(survey)>/<surveyId:\d+>/<email:[\w\d@.-]+>' => 'activities/survey'
0 => array
(
'class' => 'application.components.ShortLinksUrlRule'
)
'<id:[\w\d.-]+>/reportcenter/' => 'manager/viewReport'
'groups/<id:[\w\d.-]+>/reportcenter/' => 'manager/viewGroupReport'
'manager/activities' => 'manager/viewActivities'
'manager/group-activities' => 'manager/viewGroupActivities'
)
'urlSuffix' => ''
'showScriptName' => false
'appendParams' => true
'routeVar' => 'r'
'caseSensitive' => true
'matchValue' => false
'cacheID' => 'cache'
'useStrictParsing' => false
'urlRuleClass' => 'CUrlRule'
'behaviors' => array()
)
request array
(
'class' => 'CHttpRequest'
'enableCookieValidation' => false
'enableCsrfValidation' => false
'csrfTokenName' => 'YII_CSRF_TOKEN'
'csrfCookie' => null
'behaviors' => array()
)
db array
(
'class' => 'CDbConnection'
'connectionString' => 'mysql:host=localhost;dbname=exchangeCME'
'username' => 'root'
'password' => 'wqeeqwe12123ewerwe'
'schemaCachingDuration' => 3600
'schemaCachingExclude' => array()
'schemaCacheID' => 'cache'
'queryCachingDuration' => 0
'queryCachingDependency' => null
'queryCachingCount' => 0
'queryCacheID' => 'cache'
'autoConnect' => true
'charset' => 'utf8'
'emulatePrepare' => true
'enableParamLogging' => false
'enableProfiling' => true
'tablePrefix' => null
'initSQLs' => null
'driverMap' => array
(
'pgsql' => 'CPgsqlSchema'
'mysqli' => 'CMysqlSchema'
'mysql' => 'CMysqlSchema'
'sqlite' => 'CSqliteSchema'
'sqlite2' => 'CSqliteSchema'
'mssql' => 'CMssqlSchema'
'dblib' => 'CMssqlSchema'
'sqlsrv' => 'CMssqlSchema'
'oci' => 'COciSchema'
)
'pdoClass' => 'PDO'
'behaviors' => array()
)
log array
(
'class' => 'CLogRouter'
'behaviors' => array()
)
viewRenderer array
(
'class' => 'YiiDebugViewRenderer'
)
clientScript array
(
'class' => 'CClientScript'
'enableJavaScript' => true
'scriptMap' => array()
'packages' => array()
'corePackages' => array
(
'jquery' => array
(
'js' => array
(
0 => 'jquery.min.js'
)
)
'yii' => array
(
'js' => array
(
0 => 'jquery.yii.js'
)
'depends' => array
(
0 => 'jquery'
)
)
'yiitab' => array
(
'js' => array
(
0 => 'jquery.yiitab.js'
)
'depends' => array
(
0 => 'jquery'
)
)
'yiiactiveform' => array
(
'js' => array
(
0 => 'jquery.yiiactiveform.js'
)
'depends' => array
(
0 => 'jquery'
)
)
'jquery.ui' => array
(
'js' => array
(
0 => 'jui/js/jquery-ui.min.js'
)
'depends' => array
(
0 => 'jquery'
)
)
'bgiframe' => array
(
'js' => array
(
0 => 'jquery.bgiframe.js'
)
'depends' => array
(
0 => 'jquery'
)
)
'ajaxqueue' => array
(
'js' => array
(
0 => 'jquery.ajaxqueue.js'
)
'depends' => array
(
0 => 'jquery'
)
)
'autocomplete' => array
(
'js' => array
(
0 => 'jquery.autocomplete.js'
)
'depends' => array
(
0 => 'jquery'
1 => 'bgiframe'
2 => 'ajaxqueue'
)
)
'maskedinput' => array
(
'js' => array
(
0 => 'jquery.maskedinput.min.js'
)
'depends' => array
(
0 => 'jquery'
)
)
'cookie' => array
(
'js' => array
(
0 => 'jquery.cookie.js'
)
'depends' => array
(
0 => 'jquery'
)
)
'treeview' => array
(
'js' => array
(
0 => 'jquery.treeview.js'
1 => 'jquery.treeview.edit.js'
2 => 'jquery.treeview.async.js'
)
'depends' => array
(
0 => 'jquery'
1 => 'cookie'
)
)
'multifile' => array
(
'js' => array
(
0 => 'jquery.multifile.js'
)
'depends' => array
(
0 => 'jquery'
)
)
'rating' => array
(
'js' => array
(
0 => 'jquery.rating.js'
)
'depends' => array
(
0 => 'jquery'
1 => 'metadata'
)
)
'metadata' => array
(
'js' => array
(
0 => 'jquery.metadata.js'
)
'depends' => array
(
0 => 'jquery'
)
)
'bbq' => array
(
'js' => array
(
0 => 'jquery.ba-bbq.js'
)
'depends' => array
(
0 => 'jquery'
)
)
'history' => array
(
'js' => array
(
0 => 'jquery.history.js'
)
'depends' => array
(
0 => 'jquery'
)
)
)
'scripts' => array()
'coreScriptPosition' => 0
'defaultScriptFilePosition' => 0
'defaultScriptPosition' => 4
'behaviors' => array()
)
assetManager array
(
'class' => 'CAssetManager'
'linkAssets' => false
'excludeFiles' => array
(
0 => '.svn'
1 => '.gitignore'
)
'newFileMode' => 438
'newDirMode' => 511
'forceCopy' => false
'behaviors' => array()
)
themeManager array
(
'class' => 'CThemeManager'
'themeClass' => 'CTheme'
'behaviors' => array()
)
session array
(
'class' => 'CHttpSession'
'autoStart' => true
'behaviors' => array()
)
user array
(
'class' => 'WebUser'
'allowAutoLogin' => true
'guestName' => 'Guest'
'loginUrl' => array
(
0 => '/users/personalization'
)
'identityCookie' => null
'authTimeout' => null
'autoRenewCookie' => false
'autoUpdateFlash' => true
'loginRequiredAjaxResponse' => null
'behaviors' => array
(
'botRecognizer' => array
(
'class' => 'application.extensions.botRecognizer.botRecognizer'
)
)
)
widgetFactory array
(
'class' => 'CWidgetFactory'
'enableSkin' => false
'widgets' => array()
'skinnableWidgets' => null
'skinPath' => null
'behaviors' => array()
)
messages array
(
'class' => 'CPhpMessageSource'
'cachingDuration' => 0
'cacheID' => 'cache'
'basePath' => '/var/www/exchangecme/protected/messages'
'forceTranslation' => false
'behaviors' => array()
)
Views Rendering
Context ResourcesController
Context class ResourcesController
Inheritance Controller » CController » CBaseController
Defined in file protected/controllers/ResourcesController.php
Context properties
  •  => 
  •  => 
  •  => 
  •  => 
  •  => 
Route resources/view
Action CInlineAction (view)
Action params
  •  => 
Render methodrenderPartial
View file themes/desktop/views/resources/view.php
View data
  •  => 
Context ResourcesController
Context class ResourcesController
Inheritance Controller » CController » CBaseController
Defined in file protected/controllers/ResourcesController.php
Context properties
  •  => 
  •  => 
  •  => 
  •  => 
  •  => 
Route resources/view
Action CInlineAction (view)
Action params
  •  => 
Render methodrenderPartial
View file themes/desktop/views/resources/_activity.php
View data
  •  => 
Context ResourcesController
Context class ResourcesController
Inheritance Controller » CController » CBaseController
Defined in file protected/controllers/ResourcesController.php
Context properties
  •  => 
  •  => 
  •  => 
  •  => 
  •  => 
Route resources/view
Action CInlineAction (view)
Action params
  •  => 
Render methodrender
View file protected/views/layouts/column1.php
Context ResourcesController
Context class ResourcesController
Inheritance Controller » CController » CBaseController
Defined in file protected/controllers/ResourcesController.php
Context properties
  •  => 
  •  => 
  •  => 
  •  => 
  •  => 
Route resources/view
Action CInlineAction (view)
Action params
  •  => 
Render methodrender
View file themes/desktop/views/layouts/main.php
Context ResourcesController
Context class ResourcesController
Inheritance Controller » CController » CBaseController
Defined in file protected/controllers/ResourcesController.php
Context properties
  •  => 
  •  => 
  •  => 
  •  => 
  •  => 
Route resources/view
Action CInlineAction (view)
Action params
  •  => 
Render methodrenderPartial
View file themes/desktop/views/common/_footer.php
View data
    null
Context ResourcesController
Context class ResourcesController
Inheritance Controller » CController » CBaseController
Defined in file protected/controllers/ResourcesController.php
Context properties
  •  => 
  •  => 
  •  => 
  •  => 
  •  => 
Route resources/view
Action CInlineAction (view)
Action params
  •  => 
Render methodrenderPartial
View file themes/desktop/views/common/elasticsearch.php
View data
    null
Context YiiDebugToolbarResourceUsage
Context class YiiDebugToolbarResourceUsage
Inheritance CWidget » CBaseController
Defined in file protected/extensions/malyshev/yii-debug-toolbar/widgets/YiiDebugToolbarResourceUsage.php
Context properties
  •  => 
  •  => 
  •  => 
Render methodrender
View file protected/extensions/malyshev/yii-debug-toolbar/widgets/views/resources.php
View data
  •  => 
SQL Queries from 1 connection (23/0.027221s)

Connection ID: db (CDbConnection)

Driver mysql
Server Version 5.5.59-0ubuntu0.14.04.1
Uptime 14w 1d 7h 21m 55s
Threads 1
Questions 40796496
Slow queries 13
Opens 195
Flush tables 1
Open tables 167
Queries per second avg 4.754
Query Count Total (s) Avg. (s) Min. (s) Max. (s)
SELECT r.id, COUNT(r.id) relevance FROM resources r join `resource_topics` rtj on rtj.`resource_id`=r.id WHERE rtj.`topic_id` in (SELECT topic_id from `resource_topics` rt where rt.`resource_id`=:rid AND rt.topic_id>0) AND r.id <> :rid AND r.status = 'active' Group by r.id order by relevance DESC, r.`createDate` DESC
 1 0.003841 0.003841 0.003841 0.003841
SELECT * FROM `resources` `t` WHERE `t`.`id` IN (177, 156, 146, 128, 123, 124, 121, 115, 108, 99, 91, 76, 180, 181, 179, 176, 173, 165, 162, 157, 158, 154, 150, 148, 147, 140, 139, 133, 119, 114, 107, 102, 101, 100, 98, 96, 88, 87, 85, 80, 74, 71, 72, 70, 64)
 1 0.003732 0.003732 0.003732 0.003732
INSERT INTO `users` (`role`, `sendEmails`, `sendSms`, `source`, `session`, `lastLogin`, `phone`, `createDate`) VALUES (:yp0, :yp1, :yp2, :yp3, :yp4, :yp5, :yp6, :yp7)
 1 0.003679 0.003679 0.003679 0.003679
UPDATE `users` SET `lastLogin`=:yp0 WHERE `users`.`id`=2491928
 1 0.003068 0.003068 0.003068 0.003068
SELECT `activities`.`id` AS `t1_c0`, `activities`.`group_id` AS `t1_c1`, `activities`.`resource_id` AS `t1_c2`, `activities`.`title` AS `t1_c3`, `activities`.`type` AS `t1_c4`, `activities`.`facultyNames` AS `t1_c5`, `activities`.`shortDescription` AS `t1_c6`, `activities`.`fullDescription` AS `t1_c7`, `activities`.`creditAmount` AS `t1_c8`, `activities`.`shortAddress` AS `t1_c9`, `activities`.`creditType` AS `t1_c10`, `activities`.`startDate` AS `t1_c11`, `activities`.`finishDate` AS `t1_c12`, `activities`.`sponsors` AS `t1_c13`, `activities`.`status` AS `t1_c14`, `activities`.`createDate` AS `t1_c15`, `activities`.`image` AS `t1_c16`, `activities`.`image_featured` AS `t1_c17`, `activities`.`archived` AS `t1_c18`, `activities`.`managers_list` AS `t1_c19`, `activities`.`is_send_pp_email` AS `t1_c20`, `activities`.`muvi_sync_date` AS `t1_c21`, `activities`.`expert_questions` AS `t1_c22` FROM `activities` `activities` WHERE (`activities`.`resource_id`=:ypl0)
 1 0.001551 0.001551 0.001551 0.001551
SHOW COLUMNS FROM `resources`
 1 0.001418 0.001418 0.001418 0.001418
SHOW COLUMNS FROM `activities`
 1 0.001359 0.001359 0.001359 0.001359
SHOW COLUMNS FROM `users`
 1 0.001202 0.001202 0.001202 0.001202
SHOW COLUMNS FROM `interactions`
 1 0.001110 0.001110 0.001110 0.001110
select id, status from activities where FIND_IN_SET(:shortAddress, shortAddress)
 2 0.001107 0.000553 0.000273 0.000834
SELECT * FROM `users` `t` WHERE session=:session LIMIT 1
 2 0.000996 0.000498 0.000435 0.000561
SHOW COLUMNS FROM `resource_videos`
 1 0.000993 0.000993 0.000993 0.000993
select id from resources where FIND_IN_SET(:shortAddress, shortAddress)
 2 0.000851 0.000426 0.000251 0.000600
SELECT * FROM `resources` `t` WHERE `t`.`id`=84 LIMIT 1
 1 0.000477 0.000477 0.000477 0.000477
SHOW CREATE TABLE `resources`
 1 0.000333 0.000333 0.000333 0.000333
SHOW CREATE TABLE `activities`
 1 0.000316 0.000316 0.000316 0.000316
SHOW CREATE TABLE `users`
 1 0.000312 0.000312 0.000312 0.000312
SHOW CREATE TABLE `interactions`
 1 0.000298 0.000298 0.000298 0.000298
SHOW CREATE TABLE `resource_videos`
 1 0.000293 0.000293 0.000293 0.000293
SELECT `videos`.`id` AS `t1_c0`, `videos`.`vzaar_id` AS `t1_c1`, `videos`.`title` AS `t1_c2`, `videos`.`description` AS `t1_c3`, `videos`.`resource_id` AS `t1_c4`, `videos`.`type` AS `t1_c5` FROM `resource_videos` `videos` WHERE (`videos`.`resource_id`=:ypl0)
 1 0.000285 0.000285 0.000285 0.000285
# Query Time (s)
0
select id, status from activities where FIND_IN_SET(:shortAddress, shortAddress)
 0.000834
1
select id from resources where FIND_IN_SET(:shortAddress, shortAddress)
 0.000600
2
select id, status from activities where FIND_IN_SET(:shortAddress, shortAddress)
 0.000273
3
select id from resources where FIND_IN_SET(:shortAddress, shortAddress)
 0.000251
4
SHOW COLUMNS FROM `resources`
 0.001418
5
SHOW CREATE TABLE `resources`
 0.000333
6
SELECT * FROM `resources` `t` WHERE `t`.`id`=84 LIMIT 1
 0.000477
7
SHOW COLUMNS FROM `interactions`
 0.001110
8
SHOW CREATE TABLE `interactions`
 0.000298
9
SHOW COLUMNS FROM `resource_videos`
 0.000993
10
SHOW CREATE TABLE `resource_videos`
 0.000293
11
SELECT `videos`.`id` AS `t1_c0`, `videos`.`vzaar_id` AS `t1_c1`, `videos`.`title` AS `t1_c2`, `videos`.`description` AS `t1_c3`, `videos`.`resource_id` AS `t1_c4`, `videos`.`type` AS `t1_c5` FROM `resource_videos` `videos` WHERE (`videos`.`resource_id`=:ypl0)
 0.000285
12
SHOW COLUMNS FROM `activities`
 0.001359
13
SHOW CREATE TABLE `activities`
 0.000316
14
SHOW COLUMNS FROM `users`
 0.001202
15
SHOW CREATE TABLE `users`
 0.000312
16
SELECT * FROM `users` `t` WHERE session=:session LIMIT 1
 0.000561
17
INSERT INTO `users` (`role`, `sendEmails`, `sendSms`, `source`, `session`, `lastLogin`, `phone`, `createDate`) VALUES (:yp0, :yp1, :yp2, :yp3, :yp4, :yp5, :yp6, :yp7)
 0.003679
18
SELECT * FROM `users` `t` WHERE session=:session LIMIT 1
 0.000435
19
UPDATE `users` SET `lastLogin`=:yp0 WHERE `users`.`id`=2491928
 0.003068
20
SELECT `activities`.`id` AS `t1_c0`, `activities`.`group_id` AS `t1_c1`, `activities`.`resource_id` AS `t1_c2`, `activities`.`title` AS `t1_c3`, `activities`.`type` AS `t1_c4`, `activities`.`facultyNames` AS `t1_c5`, `activities`.`shortDescription` AS `t1_c6`, `activities`.`fullDescription` AS `t1_c7`, `activities`.`creditAmount` AS `t1_c8`, `activities`.`shortAddress` AS `t1_c9`, `activities`.`creditType` AS `t1_c10`, `activities`.`startDate` AS `t1_c11`, `activities`.`finishDate` AS `t1_c12`, `activities`.`sponsors` AS `t1_c13`, `activities`.`status` AS `t1_c14`, `activities`.`createDate` AS `t1_c15`, `activities`.`image` AS `t1_c16`, `activities`.`image_featured` AS `t1_c17`, `activities`.`archived` AS `t1_c18`, `activities`.`managers_list` AS `t1_c19`, `activities`.`is_send_pp_email` AS `t1_c20`, `activities`.`muvi_sync_date` AS `t1_c21`, `activities`.`expert_questions` AS `t1_c22` FROM `activities` `activities` WHERE (`activities`.`resource_id`=:ypl0)
 0.001551
21
SELECT r.id, COUNT(r.id) relevance FROM resources r join `resource_topics` rtj on rtj.`resource_id`=r.id WHERE rtj.`topic_id` in (SELECT topic_id from `resource_topics` rt where rt.`resource_id`=:rid AND rt.topic_id>0) AND r.id <> :rid AND r.status = 'active' Group by r.id order by relevance DESC, r.`createDate` DESC
 0.003841
22
SELECT * FROM `resources` `t` WHERE `t`.`id` IN (177, 156, 146, 128, 123, 124, 121, 115, 108, 99, 91, 76, 180, 181, 179, 176, 173, 165, 162, 157, 158, 154, 150, 148, 147, 140, 139, 133, 119, 114, 107, 102, 101, 100, 98, 96, 88, 87, 85, 80, 74, 71, 72, 70, 64)
 0.003732
Log Messages
Message (details) Level Category Time