Image
Case-in-Point™

Case Challenges in HIV Medicine

Benefits, Barriers, & Best Practices in an Advancing Field

Meeting Slides

Clinical Practice Guidelines

Primary care guidelines for the management of persons infected with HIV: 2013 update by the HIV Medicine Association of the Infectious Diseases Society of America.

Aberg JA, Gallant JE, Ghanem KG, Emmanuel P, Zingman BS, Horberg MA. Clin Infect Dis. 2014;58(1):e1-e34.

Recommendations for evaluation and management of bone disease in HIV.

Brown TT, Hoy J, Borderi M, et al. Clin Infect Dis. 2015;60(8):1242-1251.

Antiretroviral drugs for treatment and prevention of HIV infection in adults: 2020 recommendations of the International Antiviral Society–USA panel.

Saag M, Gandhi R, Hoy J, et al. JAMA. 2020. [Epub ahead of print].

Evaluation and management of chronic kidney disease: synopsis of the kidney disease: improving global outcomes 2012 clinical practice guideline.

Stevens PE, Levin A. Ann Intern Med. 2013;158(11):825-830.

Guidelines for the use of antiretroviral agents in adults and adolescents living with HIV.

US Department of Health and Human Services

Recommendations for the use of antiretroviral drugs in pregnant women with HIV infection and interventions to reduce perinatal HIV transmission in the United States.

US Department of Health and Human Services

Guidelines for Managing Advanced HIV Disease and Rapid Initiation of Antiretroviral Therapy.

World Health Organization

Patient and Caregiver Resources

AIDSMap Resources

NAM Publications

Resources for persons living with HIV

Centers for Disease Control and Prevention

HIV resources

National Institutes of Health

Suggested Readings

Efficacy and safety of dolutegravir-rilpivirine for maintenance of virological suppression in adults with HIV-1: 100-week data from the randomised, open-label, phase 3 SWORD-1 and SWORD-2 studies.

Aboud M, Orkin C, Podzamczer D, et al. Lancet HIV. 2019;6(9):e576-e587.

Brief report: randomized, double-blind comparison of tenofovir alafenamide (TAF) vs tenofovir disoproxil fumarate (TDF), each coformulated with elvitegravir, cobicistat, and emtricitabine (E/C/F) for initial HIV-1 treatment: week 144 results.

Arribas JR, Thompson M, Sax PE, et al. J Acquir Immune Defic Syndr. 2017;75(2):211-218.

HIV and substance use disorder: role of the HIV physician.

Bositis CM, St. Louis J. Infect Dis Clin North Am. 2019;33(3):835-855.

Implementation of a rapid entry program decreases time to viral suppression among vulnerable persons living with HIV in the southern United States.

Colasanti J, Sumitani J, Mehta CC, et al. Open Forum Infect Dis. 2018;5(6):ofy104.

HIV viral load and transmissibility of HIV infection: undetectable equals untransmittable.

Eisinger RW, Dieffenbach CW, Fauci AS. JAMA. 2019;321(5):451-452.

Characteristics, prevention, and management of cardiovascular disease in people living with HIV: a scientific statement from the American Heart Association.

Feinstein MJ, Hsue PY, Benjamin LA, et al. Circulation. 2019;140(2):e98-e124.

Linkage and antiretroviral therapy within 72 hours at a Federally Qualified Health Center in New Orleans.

Halperin J, Butler I, Connor K, et al. AIDS Patient Care STDS. 2018;32(2):39-41.

A care continuum of immediate ART for newly diagnosed patients and patients presenting later to care at a Federally Qualified Health Center in New Orleans.

Halperin J, Conner K, Butler I, et al. Open Forum Infect Dis. 2019;6(4):ofz161.

Neuropsychiatric adverse events with dolutegravir and other integrase strand transfer inhibitors.

Hoffmann C, Llibre JM. AIDS Rev. 2019;21(1):4-10.

Darunavir/cobicistat/emtricitabine/tenofovir alafenamide in a rapid-initiation model of care for HIV-1 infection: primary analysis of the DIAMOND study.

Huhn GD, Crofoot G, Ramgopal M, et al. Clin Infect Dis. 2019. [Epub ahead of print]

Metabolic complications affecting adipose tissue, lipid and glucose metabolism associated with HIV antiretroviral treatment.

Lagathu C, Béréziat V, Gorwood J, et al. Expert Opin Drug Saf. 2019;18(9):829-840.

Long-acting cabotegravir and rilpivirine after oral induction for HIV-1 infection.

Orkin C, Arasteh K, Górgolas Hernández-Mora M, et al. N Engl J Med. 2020;382(12):1124-1135.

The effect of same-day observed initiation of antiretroviral therapy on HIV viral load and treatment outcomes in a US public health setting.

Pilcher CD, Ospina-Norvell C, Dasgupta A, et al. J Acquir Immune Defic Syndr. 2017;74(1):44-51.

Weight gain following initiation of antiretroviral therapy: risk factors in randomized comparative clinical trials.

Sax PE, Erlandson KM, Lake JE, et al. Clin Infect Dis. 2020;71(6):1379-1389.

Current challenges and solutions in research and clinical care of older persons living with HIV: findings presented at the 9th International Workshop on HIV and Aging.

Sundermann EE, Erlandson KM, Pope CN, et al. AIDS Res Hum Retroviruses. 2019;35(11-12):985-998.

Long-acting cabotegravir and rilpivirine for maintenance of HIV-1 suppression.

Swindells S, Andrade-Villanueva JF, Richmond GJ, et al. N Engl J Med. 2020;382(12):1112-1123.

Efficacy and safety of switching to dolutegravir/lamivudine fixed-dose two-drug regimen versus continuing a tenofovir alafenamide-based three- or four-drug regimen for maintenance of virologic suppression in adults with HIV-1: phase 3, randomized, non-inferiority TANGO Study.

van Wyk J, Ajana F, Bisshop F, et al. Clin Infect Dis. 2020. [Epub ahead of print].

Update on neural tube defects with antiretroviral exposure in the Tsepamo study, Botswana.

Zash R, Holmes L, Diseko M, et al. J Int AIDS Soc. 2020;23(suppl 4):183-184. Abstract OAXLB0102.

Interactive Presentation

HIV From Then to Now: A Story of Resilience

This history of HIV details the incredible journey from HIV discovery, patient resilience, and early treatment in the 1980s and 1990s to our current standard of single-tablet regimens, rapid ART initiation, and HIV as a chronic disease


Activity
Case Challenges in HIV Medicine

Benefits, Barriers, & Best Practices in an Advancing Field

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

Hepatitis C is Curable

Got it? Treat it!

Real-World Issues in HIV Prevention & Treatment

The Critical Role of the Community Pharmacist

BLOCK HIV/HCV

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

Evolving Models of HIV Care

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

Updates in HCV Screening and Treatment

Key Issues Impacting OB/GYN Practice

Clinical Issues in Chronic Liver Disease

Hot Topics in HBV, HCV, and NASH

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

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

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

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

Clinical Issues in COVID-19

Debates and Discussions about Monoclonal Antibody Therapies

MINIMIZING PATIENT RISKS FROM COVID-19

An Update on Monoclonal Antibody Therapies

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 'Wed, 23 Jun 2021 05:39:15 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 '53906'
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 '/HIVCaseResources'
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 1632354261.8845
REQUEST_TIME 1632354261
Request Cookies
Session Attributes
Request GET Parameters
id '157'
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.027684s)

Connection ID: db (CDbConnection)

Driver mysql
Server Version 5.5.59-0ubuntu0.14.04.1
Uptime 14w 1d 6h 43m 45s
Threads 1
Questions 40793607
Slow queries 13
Opens 195
Flush tables 1
Open tables 167
Queries per second avg 4.755
Query Count Total (s) Avg. (s) Min. (s) Max. (s)
SELECT * FROM `resources` `t` WHERE `t`.`id` IN (180, 181, 177, 176, 173, 162, 158, 156, 154, 150, 148, 147, 146, 140, 139, 128, 123, 124, 121, 84, 119, 115, 114, 108, 107, 100, 99, 96, 91, 87, 85, 80, 76, 74, 71, 70, 64)
1 0.004108 0.004108 0.004108 0.004108
INSERT INTO `users` (`role`, `sendEmails`, `sendSms`, `source`, `session`, `lastLogin`, `phone`, `createDate`) VALUES (:yp0, :yp1, :yp2, :yp3, :yp4, :yp5, :yp6, :yp7)
1 0.003733 0.003733 0.003733 0.003733
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.003599 0.003599 0.003599 0.003599
UPDATE `users` SET `lastLogin`=:yp0 WHERE `users`.`id`=2491883
1 0.003206 0.003206 0.003206 0.003206
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.001624 0.001624 0.001624 0.001624
SHOW COLUMNS FROM `resources`
1 0.001555 0.001555 0.001555 0.001555
SHOW COLUMNS FROM `activities`
1 0.001247 0.001247 0.001247 0.001247
SHOW COLUMNS FROM `users`
1 0.001217 0.001217 0.001217 0.001217
select id, status from activities where FIND_IN_SET(:shortAddress, shortAddress)
2 0.001195 0.000598 0.000292 0.000903
SHOW COLUMNS FROM `interactions`
1 0.001044 0.001044 0.001044 0.001044
SHOW COLUMNS FROM `resource_videos`
1 0.000990 0.000990 0.000990 0.000990
SELECT * FROM `users` `t` WHERE session=:session LIMIT 1
2 0.000918 0.000459 0.000443 0.000475
select id from resources where FIND_IN_SET(:shortAddress, shortAddress)
2 0.000852 0.000426 0.000252 0.000600
SELECT * FROM `resources` `t` WHERE `t`.`id`=157 LIMIT 1
1 0.000517 0.000517 0.000517 0.000517
SHOW CREATE TABLE `activities`
1 0.000353 0.000353 0.000353 0.000353
SHOW CREATE TABLE `resources`
1 0.000350 0.000350 0.000350 0.000350
SHOW CREATE TABLE `users`
1 0.000316 0.000316 0.000316 0.000316
SHOW CREATE TABLE `interactions`
1 0.000302 0.000302 0.000302 0.000302
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.000265 0.000265 0.000265 0.000265
# Query Time (s)
0
select id, status from activities where FIND_IN_SET(:shortAddress, shortAddress)
0.000903
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.000292
3
select id from resources where FIND_IN_SET(:shortAddress, shortAddress)
0.000252
4
SHOW COLUMNS FROM `resources`
0.001555
5
SHOW CREATE TABLE `resources`
0.000350
6
SELECT * FROM `resources` `t` WHERE `t`.`id`=157 LIMIT 1
0.000517
7
SHOW COLUMNS FROM `interactions`
0.001044
8
SHOW CREATE TABLE `interactions`
0.000302
9
SHOW COLUMNS FROM `resource_videos`
0.000990
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.000265
12
SHOW COLUMNS FROM `activities`
0.001247
13
SHOW CREATE TABLE `activities`
0.000353
14
SHOW COLUMNS FROM `users`
0.001217
15
SHOW CREATE TABLE `users`
0.000316
16
SELECT * FROM `users` `t` WHERE session=:session LIMIT 1
0.000475
17
INSERT INTO `users` (`role`, `sendEmails`, `sendSms`, `source`, `session`, `lastLogin`, `phone`, `createDate`) VALUES (:yp0, :yp1, :yp2, :yp3, :yp4, :yp5, :yp6, :yp7)
0.003733
18
SELECT * FROM `users` `t` WHERE session=:session LIMIT 1
0.000443
19
UPDATE `users` SET `lastLogin`=:yp0 WHERE `users`.`id`=2491883
0.003206
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.001624
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.003599
22
SELECT * FROM `resources` `t` WHERE `t`.`id` IN (180, 181, 177, 176, 173, 162, 158, 156, 154, 150, 148, 147, 146, 140, 139, 128, 123, 124, 121, 84, 119, 115, 114, 108, 107, 100, 99, 96, 91, 87, 85, 80, 76, 74, 71, 70, 64)
0.004108
Log Messages
Message (details) Level Category Time