Image
Cases & Conversations™

COPD Cases & Conversations

Preventing COPD Exacerbations to Improve Outcomes

Meeting Slides

Suggested Readings

GOLD COVID-19 guidance.

Global Initiative for Chronic Obstructive Lung Disease (GOLD).

Reducing chronic obstructive pulmonary disease hospital readmissions. An official American Thoracic Society workshop report.

Press VG, et al. Ann Am Thorac Soc. 2019;16(2):161-170.

Predicting acute exacerbations in chronic obstructive pulmonary disease.

Samp JC, et al. J Manag Care Spec Pharm. 2018;24(3):265-279.

Triple versus dual inhaler therapy in moderate‐to‐severe COPD: a systematic review and meta‐analysis of randomized controlled trials.

Zayed Y, et al. Clin Respir J. 2019;13(7):413-428.

Once-daily single-inhaler triple versus dual therapy in patients with COPD.

Lipson DA, et al. N Engl J Med. 2018; 378(18):1671-1680.

The effect of exacerbation history on outcomes in the IMPACT trial.

Halpin DMG, et al. Eur Respir J. 2020;55(5):1901921.

Triple inhaled therapy at two glucocorticoid doses in moderate-to-very-severe COPD.

Rabe KF, et al. N Engl J Med. 2020;383(1):35-48.

Reduced all-cause mortality in the ETHOS trial of budesonide/glycopyrrolate/formoterol for chronic obstructive pulmonary disease. A randomized, double-blind, multicenter, parallel-group study.

Martinez FJ, et al. Am J Respir Crit Care Med. 2021;203(5):553-564.

A new approach for identifying patients with undiagnosed chronic obstructive pulmonary disease.

Martinez FJ, et al. Am J Respir Crit Care Med. 2017;195(6):748-756.

Bringing stability to the chronic obstructive pulmonary disease patient: clinical and pharmacological considerations for frequent exacerbators.

Gulati S, Wells JM. Drugs. 2017;77(6):651-670.

Pulmonary rehabilitation following exacerbations of chronic obstructive pulmonary disease.

Puhan MA, et al. Cochrane Database Syst Rev. 2016;12:CD005305.

A score to predict short-term risk of COPD exacerbations (SCOPEX)

Make BJ, et al. Int J Chron Obstruct Pulmon Dis. 2015;10:201-209.

Clinical Practice Tools and Resources 

The COPD Foundation Pocket Consultant Guide Mobile App

The COPD Pocket Guide, provided by the COPD Foundation, contains comprehensive management information as well as resource tools. It can be downloaded onto any mobile device.

Modified Medical Research Council (mMRC) Dyspnea Scale

The mMRC scale, provided by MDCalc, allows for the baseline stratification of dyspnea in COPD, as well as other respiratory diseases.

COPD Assessment Test (CAT)

The CAT, provided by the American Academy of Family Physicians, allows assessment of the global impact of COPD (cough, sputum, dyspnea, chest tightness) on patient health status.

COPD Action Plan

The COPD Action Plan, provided by the American Lung Association, is a tool that facilitates the prevention, timely identification, and early and appropriate treatment of COPD exacerbations.

Patient Resources and Advocacy Organizations

The COPD Foundation Pocket Consultant Guide Patient-Focused Mobile App

The COPD Pocket Guide for Patients was designed to improve disease management and communication with a patient’s health care team. It includes patient resources such as inhaler and exercise videos as well as tools such as the wallet card and daily symptom tracker that help collect and share information with the health care team. It can be downloaded onto any mobile device.

American Lung Association

The American Lung Association is the leading organization working to save lives by improving lung health and preventing lung disease through education, advocacy, and research.

COPD Foundation

The COPD Foundation’s mission is to prevent and cure COPD and to improve the lives of all people affected by COPD.

Global Initiative for Chronic Obstructive Lung Disease (GOLD)

GOLD partners with health care professionals and public health officials to raise awareness of COPD and to improve prevention and treatment of this lung disease for patients around the world.

National Jewish Health

National Jewish Health integrates the latest scientific discoveries with coordinated care for lung, heart, and immune diseases. Their Patient Education Program provides many free educational opportunities and support groups to assist patients and caregivers with managing illnesses and chronic conditions, such as COPD.

Activity
Activity for event:COPD Cases and Conversations

Preventing Exacerbations to Improve Outcomes

Relevant Resources

Acute Management of Migraine Attacks

Overcoming Pain and Gastrointestinal Distress to Improve Patient Outcomes

Clinical Updates on the Management of Gout

Evidence-Based Strategies for Improved Patient Outcomes

Opioid-Induced Constipation

Proactive Diagnosis and Targeted Management

Chronic Obstructive Pulmonary Disease, Asthma, or Both

Differential Diagnosis and Comprehensive Management Strategies

Improving Outcomes in Chronic Obstructive Pulmonary Disease

Optimizing Maintenance Therapy Across Healthcare Settings

Managing Gout in Primary Care

Evolving Strategies for Diagnosis and Long-Term Management

Clinical Issues in Chronic Pain

Consensus and Controversies for Responsible Opioid Prescribing

Noninsulin Approaches to Managing Type 2 Diabetes

Best Practices in Combination Therapy

Hitting the Target in Type 2 Diabetes

Evolving Approaches to Insulin Based Therapy

Clearing the Air

Improving Outcomes for Patients with COPD

Clinical Updates in Type 2 Diabetes

New Strategies for Insulin Replacement Therapy

How Low Do You Go?

Clinical Updates in LDL-C Management

Incretin-Based Therapies For Type 2 Diabetes

Improving Comprehensive Patient Care

Improving Outcomes in Non–24-Hour Sleep-Wake Disorder

Identifying Patients and Tailoring Therapy

Comprehensive Management of Chronic Obstructive Pulmonary Disease

Collaborative Approaches to Guideline-Concordant Patient Care

Clinical Updates in the Management of Severe Asthma

New Strategies for Individualizing Long-term Care

Comprehensive Chronic Pain Management

A Focus on Patients With Opioid-Induced Constipation

Clinical Issues in Bipolar Depression

Consensus and Controversies Across the Spectrum of Patient Presentations

Improving Outcomes in Severe Asthma

A New Era in Precision Medicine

Clinical Updates in Rheumatoid Arthritis

Evolving Treatment Algorithms and Expert Perspectives on Biosimilars

Caring for Patients with Severe Asthma

Evolving Best Practices to Optimize Outcomes

Clinical Issues in Severe Asthma

Consensus and Controversies on the Road to Precision Medicine

Breathing Life Into COPD Management

Ongoing Monitoring, Pulmonary Rehabilitation, and Individualized Care

Can You Spot Axial Spondyloarthritis?

The PCP’s Role in Timely Recognition and Referral

Clinical Issues in Severe Asthma

Debates and Discussions About Personalizing Patient Management

Advancing the Care of Severe Asthma

Differential Diagnosis, Multidisciplinary Management, and Patient Engagement

Updates in HCV Screening and Treatment

Key Issues Impacting OB/GYN Practice

Focusing on Patients With Severe Asthma

From Guideline Recommendations to Daily Clinical Decision-Making

Clearing the Air in Severe Asthma Management

Improving Patient Outcomes Through Shared Clinical Decision Making

Evolving Models of HIV Care

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

Clearing the Air in Severe Asthma Management

Improving Patient Outcomes Through Shared Clinical Decision Making

Marching Forward in Atopic Dermatitis

Digging Deep on Shared Decision-Making

GLP-1 Receptors Agonists in Type 2 Diabetes

Mechanistic Insights and Evolving Treatment Options

Airing It Out

A Case-Based Conversation on Managing Asthma and Chronic Rhinosinusitis With Nasal Polyposis

COPD in Managed Care

The Clinical and Utilization Benefits of Exacerbation Prevention

Finding the Right Path in Severe Asthma

Mechanistic Insights and Emerging Treatment Options

COPD Cases and Conversations

A Focus on Exacerbation Prevention

Assimilating the Evidence in T2DM

Cardiovascular and Renal Outcomes With SGLT2 Inhibitors

Demystifying New Evidence for COPD Management

Best Practices for Primary Care

Finding Relief in Osteoarthritis

New Paths to Chronic Pain Management

The Changing Landscape of HIV Prevention

What the Pharmacist Needs to Know about PrEP

What’s New in Systemic Lupus Erythematosus?

Unlocking Novel Paths to Patient Care

Updates on Chronic Rhinosinusitis with Nasal Polyps

Evolving Best Practices for Patient Management

Expert Views on the Changing Landscape in RA

The Increasing Role of JAK Inhibitors

A Breath of Fresh Air in Pediatric Asthma

Shared Decision-making in the Era of Biologics

Swimming Upstream in Severe Asthma

New Pathways to Patient Management

Where are We Now In Moderate-to-Severe Asthma?

From Comprehensive Patient Evaluations to Individualized Evidence-based Care

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 'Mon, 02 Aug 2021 19:06:23 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 '40072'
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 '/copdresources21'
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 1632354979.0257
REQUEST_TIME 1632354979
Request Cookies
Session Attributes
Request GET Parameters
id '172'
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.029204s)

Connection ID: db (CDbConnection)

Driver mysql
Server Version 5.5.59-0ubuntu0.14.04.1
Uptime 14w 1d 6h 55m 43s
Threads 1
Questions 40794655
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 (163, 144, 137, 136, 126, 116, 90, 62, 54, 53, 47, 34, 32, 181, 180, 171, 169, 168, 164, 154, 153, 151, 149, 147, 145, 143, 142, 141, 140, 139, 138, 132, 122, 117, 114, 107, 104, 96, 92, 91, 79, 69, 68, 63, 58, 57, 56, 55, 52, 51, 50, 48, 42, 41, 40, 38, 36, 35, 31, 28, 23)
1 0.005952 0.005952 0.005952 0.005952
INSERT INTO `users` (`role`, `sendEmails`, `sendSms`, `source`, `session`, `lastLogin`, `phone`, `createDate`) VALUES (:yp0, :yp1, :yp2, :yp3, :yp4, :yp5, :yp6, :yp7)
1 0.003933 0.003933 0.003933 0.003933
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.003468 0.003468 0.003468 0.003468
UPDATE `users` SET `lastLogin`=:yp0 WHERE `users`.`id`=2491897
1 0.003328 0.003328 0.003328 0.003328
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.001527 0.001527 0.001527 0.001527
SHOW COLUMNS FROM `resources`
1 0.001398 0.001398 0.001398 0.001398
SHOW COLUMNS FROM `activities`
1 0.001224 0.001224 0.001224 0.001224
SHOW COLUMNS FROM `users`
1 0.001187 0.001187 0.001187 0.001187
select id, status from activities where FIND_IN_SET(:shortAddress, shortAddress)
2 0.001144 0.000572 0.000285 0.000859
SHOW COLUMNS FROM `interactions`
1 0.001017 0.001017 0.001017 0.001017
SHOW COLUMNS FROM `resource_videos`
1 0.000956 0.000956 0.000956 0.000956
select id from resources where FIND_IN_SET(:shortAddress, shortAddress)
2 0.000895 0.000448 0.000252 0.000643
SELECT * FROM `users` `t` WHERE session=:session LIMIT 1
2 0.000870 0.000435 0.000419 0.000451
SELECT * FROM `resources` `t` WHERE `t`.`id`=172 LIMIT 1
1 0.000480 0.000480 0.000480 0.000480
SHOW CREATE TABLE `resources`
1 0.000422 0.000422 0.000422 0.000422
SHOW CREATE TABLE `resource_videos`
1 0.000313 0.000313 0.000313 0.000313
SHOW CREATE TABLE `activities`
1 0.000290 0.000290 0.000290 0.000290
SHOW CREATE TABLE `users`
1 0.000285 0.000285 0.000285 0.000285
SHOW CREATE TABLE `interactions`
1 0.000281 0.000281 0.000281 0.000281
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.000234 0.000234 0.000234 0.000234
# Query Time (s)
0
select id, status from activities where FIND_IN_SET(:shortAddress, shortAddress)
0.000859
1
select id from resources where FIND_IN_SET(:shortAddress, shortAddress)
0.000643
2
select id, status from activities where FIND_IN_SET(:shortAddress, shortAddress)
0.000285
3
select id from resources where FIND_IN_SET(:shortAddress, shortAddress)
0.000252
4
SHOW COLUMNS FROM `resources`
0.001398
5
SHOW CREATE TABLE `resources`
0.000422
6
SELECT * FROM `resources` `t` WHERE `t`.`id`=172 LIMIT 1
0.000480
7
SHOW COLUMNS FROM `interactions`
0.001017
8
SHOW CREATE TABLE `interactions`
0.000281
9
SHOW COLUMNS FROM `resource_videos`
0.000956
10
SHOW CREATE TABLE `resource_videos`
0.000313
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.000234
12
SHOW COLUMNS FROM `activities`
0.001224
13
SHOW CREATE TABLE `activities`
0.000290
14
SHOW COLUMNS FROM `users`
0.001187
15
SHOW CREATE TABLE `users`
0.000285
16
SELECT * FROM `users` `t` WHERE session=:session LIMIT 1
0.000419
17
INSERT INTO `users` (`role`, `sendEmails`, `sendSms`, `source`, `session`, `lastLogin`, `phone`, `createDate`) VALUES (:yp0, :yp1, :yp2, :yp3, :yp4, :yp5, :yp6, :yp7)
0.003933
18
SELECT * FROM `users` `t` WHERE session=:session LIMIT 1
0.000451
19
UPDATE `users` SET `lastLogin`=:yp0 WHERE `users`.`id`=2491897
0.003328
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.001527
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.003468
22
SELECT * FROM `resources` `t` WHERE `t`.`id` IN (163, 144, 137, 136, 126, 116, 90, 62, 54, 53, 47, 34, 32, 181, 180, 171, 169, 168, 164, 154, 153, 151, 149, 147, 145, 143, 142, 141, 140, 139, 138, 132, 122, 117, 114, 107, 104, 96, 92, 91, 79, 69, 68, 63, 58, 57, 56, 55, 52, 51, 50, 48, 42, 41, 40, 38, 36, 35, 31, 28, 23)
0.005952
Log Messages
Message (details) Level Category Time