Image
Coming up for Air to Manage Patients With Severe Asthma International

Ian Pavord, MBBS, MA, DM, FRCP, FERS, FMedSci; Klaus Rabe, MD

This activity is jointly provided by Global Education Group and Integritas Communications.

 

This activity is supported by an independent educational grant from Sanofi Genzyme and Regeneron Pharmaceuticals.

 

Faculty

Ian Pavord, MBBS, MA, DM, FRCP, FERS, FmedSci
Professor of Respiratory Medicine
Group Head, Oxford Respiratory
National Institute for Health Research Biomedical Research Centre
Nuffield Department of Medicine
Oxford, England

Klaus F. Rabe, MD, PhD
Professor of Pulmonary Medicine
University of Kiel
Kiel, Germany
Director, Department of Pneumology
Clinic Grosshansdorf
Grosshansdorf, Germany

Statement of Need

Disorders involving inflammation or tissue remodeling in the respiratory tract are responsible for significant burdens on patient health and health care systems.1,2 Asthma is a chronic respiratory disease that affects more than 339 million people globally.3 An outsized segment of asthma-related morbidity and mortality is borne by the 5% to 15% of patients who have more severe forms of the disease.4-6 Research has uncovered key pathophysiologic processes and other clinical parameters related to asthma severity and persistence.4,5 As a result, several biologic therapies were developed to treat patients with moderate-to-severe asthma.7,8 Clinical immunologists/allergists, pulmonologists, and other specialists who manage patients with asthma are increasingly tasked with personalizing the choice of treatment based on severity of symptoms, presence of comorbidities, and disease phenotypes and endotypes. Thus, clinicians must be vigilant about staying current on the latest clinical data, treatment recommendations, and international guidelines, including the GINA report5. During this Point-of-Care™ educational activity, expert faculty translate evidence-based management strategies and real-world experience into actionable best-practice recommendations that can shape therapeutic decision-making and improve outcomes for patients with moderate-to-severe asthma.

References

  1. Lang DM. Allergy Asthma Proc. 2015;36(6):418-424.
  2. Global Asthma Network. http://www.globalasthmanetwork.org/.
  3. World Health Organization (WHO). Asthma Fact Sheet. https://www.who.int/news-room/fact-sheets/detail/asthma. 
  4. Chung KF, et al. Eur Respir J. 2014;43(2):343-373.
  5. Global Initiative for Asthma. Global Strategy for Asthma Management and Prevention, 2020. www.ginasthma.org.
  6. Levy ML. Breathe (Sheff). 2015;11(1):14-24.
  7. Assaf SM, Hanania NA. Curr Opin Allergy Clin Immunol. 2019;19(4):379-386.
  8. Krings JG, et al. J Allergy Clin Immunol Pract. 2019;7(5):1379-1392.

Target Audience

The educational design of this activity addresses the needs of international allergists, pulmonologists, and other clinicians involved in the ongoing management of patients with severe asthma.

Educational Objectives

Upon completion of this activity, participants will be able to:

  1. Discuss asthma pathophysiology, including Th2-mediated processes and clinically relevant treatment targets
  2. Evaluate patients with severe asthma for symptom control and disease phenotypes
  3. Describe the clinical profiles and prescribing considerations for biologic therapies in the treatment of severe asthma
  4. Construct evidence-based treatment regimens for patients with severe asthma to reflect symptoms, exacerbation risks, comorbidities, and treatment responses
  5. Communicate with patients with severe asthma to provide disease state education and promote shared decision-making

Physician Accreditation Statement

This activity has been planned and implemented in accordance with the accreditation requirements and policies of the Accreditation Council for Continuing Medical Education (ACCME) through the joint providership of Global Education Group (Global) and Integritas Communications. Global is accredited by the ACCME to provide continuing medical education for physicians.

Physician Credit Designation

Global Education Group designates this enduring material for a maximum of 1.0 AMA PRA Category 1 Credit™. Physicians should claim only the credit commensurate with the extent of their participation in the activity.

Reciprocity

European Accreditation Council for Continuing Medical Education (EACCME)

The European Union of Medical Specialists (UEMS)-EACCME® and the American Medical Association (AMA) have recognized each other’s CME credits since 2000. In 2002 the UEMS-EACCME® and the AMA signed an agreement of mutual recognition of CME credits between Europe and the USA whereby European physicians attending an event in the USA have their credits recognized in Europe and American physicians attending an event in Europe have their credits recognized in the USA.

Royal College of Physicians and Surgeons of Canada

Activities held outside of Canada developed by a university, academy, specialty society, or other physician organization can be recorded as accredited group learning activities under Section 1 of the Royal College of Physician and Surgeons of Canada’s Maintenance of Certification (MOC) Program.

Disclosure of Conflicts of Interest

Global Education Group (Global) requires instructors, planners, managers, and other individuals and their spouses/life partners who are in a position to control the content of this activity to disclose any real or apparent conflict of interest they may have as related to the content of this activity. All identified conflicts of interest are thoroughly vetted by Global for fair balance, scientific objectivity of studies mentioned in the materials or used as the basis for content, and appropriateness of patient care recommendations.

The faculty reported the following financial relationships or relationships to products or devices they or their spouses/life partners have with commercial interests related to the content of this CME activity:

Ian Pavord, MBBS, MA, DM, FRCP, FERS, FMedSci: Consultant/Independent Contractor: AstraZeneca, GSK, Sanofi/Regeneron and Teva, Boehringer Ingelheim, and Chiesi; Honoraria: AstraZeneca, Boehringer Ingelheim, Aerocrine, Almirall, Novartis, Teva, Chiesi, Sanofi/Regeneron, Menarini and GSK; Advisory Board: Genentech, Sanofi/Regeneron, AstraZeneca, Boehringer Ingelheim, GSK, Novartis, Teva, Merck, Circassia, Chiesi and Knopp; Grant/Research Support: Chiesi; Other: Payments to support FDA approval meetings from GSK; Co-patent holder of the rights to the Leicester Cough Questionnaire and has received payments for its use in clinical trials from Merck, Bayer and Insmed; Expert witness for a patent dispute involving AstraZeneca and Teva.

Klaus F. Rabe, MD, PhD: Consultant/Independent Contractor: AstraZeneca, Regeneron, Sanofi. Honoraria: AstraZeneca, Boehringer Ingelheim, Novartis, Regeneron, Sanofi.

The planners and managers reported the following financial relationships or relationships to products or devices they or their spouses/life partners have with commercial interests related to the content of this CME activity:

Lindsay Borvansky: Nothing to disclose
Andrea Funk: Nothing to disclose
Liddy Knight: Nothing to disclose
Ashley Cann: Nothing to disclose
Rose O’Connor, PhD, CHCP: Nothing to disclose
Celeste Collazo, MD: Nothing to disclose

Instructions to Receive Credit

In order to receive credit for this activity, the participant must score 75% or better on the posttest and complete the program evaluation.

Fee Information & Refund/Cancellation Policy

There is no fee for this educational activity.

Global Contact Information

For information about the accreditation of this program, please contact Global at 303-395-1782 or cme@globaleducationgroup.com.

Disclosure of Unlabeled Use

This educational activity may contain discussion of published and/or investigational uses of agents that are not indicated by the US Food and Drug Administration. Global Education Group (Global) and Integritas Communications do not recommend the use of any agent outside of the labeled indications.

The opinions expressed in the educational activity are those of the faculty and do not necessarily represent the views of any organization associated with this activity. Please refer to the official prescribing information for each product for discussion of approved indications, contraindications, and warnings.

Disclaimer

Participants have an implied responsibility to use the newly acquired information to enhance patient outcomes and their own professional development. The information presented in this activity is not meant to serve as a guideline for patient management. Any procedures, medications, or other courses of diagnosis or treatment discussed in this activity should not be used by clinicians without evaluation of patient conditions and possible contraindications or dangers in use, review of any applicable manufacturer’s product information, and comparison with recommendations of other authorities.

Click "Begin Activity" to acknowledge that you have reviewed the preamble information for this activity.

Begin Activity

credit amount 1.00

credit type CME/CE

release 01/29/2021

expiration 01/29/2022

type POC201


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 18:00:46 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 '32880'
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 '/ComingUpForAir'
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 1632351146.5865
REQUEST_TIME 1632351146
Request Cookies
Session Attributes
Request GET Parameters
id '236'
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()
)
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'
)
)
)
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()
)
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 ActivitiesController
Context class ActivitiesController
Inheritance CommonActivitiesController » Controller » CController » CBaseController
Defined in file protected/controllers/ActivitiesController.php
Context properties
  •  => 
  •  => 
  •  => 
  •  => 
  •  => 
Route activities/view
Action CInlineAction (view)
Action params
  •  => 
Render methodrenderPartial
View file themes/desktop/views/activities/view.php
View data
  •  => 
  •  => 
  •  => 
  •  => 
Context ActivitiesController
Context class ActivitiesController
Inheritance CommonActivitiesController » Controller » CController » CBaseController
Defined in file protected/controllers/ActivitiesController.php
Context properties
  •  => 
  •  => 
  •  => 
  •  => 
  •  => 
Route activities/view
Action CInlineAction (view)
Action params
  •  => 
Render methodrenderPartial
View file themes/desktop/views/activities/_info.php
View data
  •  => 
Context ActivitiesController
Context class ActivitiesController
Inheritance CommonActivitiesController » Controller » CController » CBaseController
Defined in file protected/controllers/ActivitiesController.php
Context properties
  •  => 
  •  => 
  •  => 
  •  => 
  •  => 
Route activities/view
Action CInlineAction (view)
Action params
  •  => 
Render methodrenderPartial
View file themes/desktop/views/activities/_menu.php
View data
  •  => 
  •  => 
Context ActivitiesController
Context class ActivitiesController
Inheritance CommonActivitiesController » Controller » CController » CBaseController
Defined in file protected/controllers/ActivitiesController.php
Context properties
  •  => 
  •  => 
  •  => 
  •  => 
  •  => 
Route activities/view
Action CInlineAction (view)
Action params
  •  => 
Render methodrenderPartial
View file themes/desktop/views/activities/_resource.php
View data
  •  => 
Context ActivitiesController
Context class ActivitiesController
Inheritance CommonActivitiesController » Controller » CController » CBaseController
Defined in file protected/controllers/ActivitiesController.php
Context properties
  •  => 
  •  => 
  •  => 
  •  => 
  •  => 
Route activities/view
Action CInlineAction (view)
Action params
  •  => 
Render methodrender
View file protected/views/layouts/column1.php
Context ActivitiesController
Context class ActivitiesController
Inheritance CommonActivitiesController » Controller » CController » CBaseController
Defined in file protected/controllers/ActivitiesController.php
Context properties
  •  => 
  •  => 
  •  => 
  •  => 
  •  => 
Route activities/view
Action CInlineAction (view)
Action params
  •  => 
Render methodrender
View file themes/desktop/views/layouts/main.php
Context ActivitiesController
Context class ActivitiesController
Inheritance CommonActivitiesController » Controller » CController » CBaseController
Defined in file protected/controllers/ActivitiesController.php
Context properties
  •  => 
  •  => 
  •  => 
  •  => 
  •  => 
Route activities/view
Action CInlineAction (view)
Action params
  •  => 
Render methodrenderPartial
View file themes/desktop/views/common/_footer.php
View data
    null
Context ActivitiesController
Context class ActivitiesController
Inheritance CommonActivitiesController » Controller » CController » CBaseController
Defined in file protected/controllers/ActivitiesController.php
Context properties
  •  => 
  •  => 
  •  => 
  •  => 
  •  => 
Route activities/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 (39/0.037979s)

Connection ID: db (CDbConnection)

Driver mysql
Server Version 5.5.59-0ubuntu0.14.04.1
Uptime 14w 1d 5h 51m 50s
Threads 1
Questions 40787590
Slow queries 13
Opens 195
Flush tables 1
Open tables 167
Queries per second avg 4.756
Query Count Total (s) Avg. (s) Min. (s) Max. (s)
UPDATE activities SET archived=1 WHERE finishDate<now();
1 0.005850 0.005850 0.005850 0.005850
INSERT INTO `users` (`role`, `sendEmails`, `sendSms`, `source`, `session`, `lastLogin`, `phone`, `createDate`) VALUES (:yp0, :yp1, :yp2, :yp3, :yp4, :yp5, :yp6, :yp7)
1 0.003761 0.003761 0.003761 0.003761
INSERT INTO `view_log` (`source`, `unique_id`, `resource_id`, `type`) VALUES (:yp0, :yp1, :yp2, :yp3)
1 0.003289 0.003289 0.003289 0.003289
UPDATE `users` SET `lastLogin`=:yp0 WHERE `users`.`id`=2491797
1 0.003109 0.003109 0.003109 0.003109
SELECT `event`.`id` AS `t1_c0`, `event`.`group_id` AS `t1_c1`, `event`.`shortAddress` AS `t1_c2`, `event`.`resource_id` AS `t1_c3`, `event`.`type` AS `t1_c4`, `event`.`addType` AS `t1_c5`, `event`.`title` AS `t1_c6`, `event`.`shortDescription` AS `t1_c7`, `event`.`facultyNames` AS `t1_c8`, `event`.`faculty` AS `t1_c9`, `event`.`calendarDate` AS `t1_c10`, `event`.`creditAmount` AS `t1_c11`, `event`.`creditType` AS `t1_c12`, `event`.`shortWhen` AS `t1_c13`, `event`.`fullWhen` AS `t1_c14`, `event`.`venue` AS `t1_c15`, `event`.`shortWhere` AS `t1_c16`, `event`.`fullWhere` AS `t1_c17`, `event`.`createDate` AS `t1_c18`, `event`.`status` AS `t1_c19`, `event`.`description` AS `t1_c20`, `event`.`image` AS `t1_c21`, `event`.`linkout` AS `t1_c22`, `event`.`registrationEnabled` AS `t1_c23`, `event`.`activity_id` AS `t1_c24`, `event`.`adobe_connect_sco` AS `t1_c25`, `event`.`adobe_connect_datetime` AS `t1_c26`, `event`.`users_limit` AS `t1_c27`, `event`.`adobe_connect_duration` AS `t1_c28`, `event`.`calendar_description` AS `t1_c29` FROM `events` `event` WHERE (`event`.`activity_id`=:ypl0)
3 0.002429 0.000810 0.000261 0.001885
SELECT * FROM `activities` `t` WHERE `t`.`id`=236 LIMIT 1
5 0.001705 0.000341 0.000281 0.000494
SHOW COLUMNS FROM `users`
1 0.001689 0.001689 0.001689 0.001689
SHOW COLUMNS FROM `activities`
1 0.001558 0.001558 0.001558 0.001558
SHOW COLUMNS FROM `events`
1 0.001549 0.001549 0.001549 0.001549
SHOW COLUMNS FROM `view_log`
1 0.001176 0.001176 0.001176 0.001176
select id, status from activities where FIND_IN_SET(:shortAddress, shortAddress)
2 0.001168 0.000584 0.000258 0.000910
SHOW COLUMNS FROM `resources`
1 0.001122 0.001122 0.001122 0.001122
SHOW COLUMNS FROM `user_activitiesstatus`
1 0.001044 0.001044 0.001044 0.001044
SHOW COLUMNS FROM `interactions`
1 0.001026 0.001026 0.001026 0.001026
SHOW COLUMNS FROM `questionnaires`
1 0.001022 0.001022 0.001022 0.001022
SELECT `activityStatus`.`id` AS `t1_c0`, `activityStatus`.`user_id` AS `t1_c1`, `activityStatus`.`activity_id` AS `t1_c2`, `activityStatus`.`current` AS `t1_c3`, `activityStatus`.`isFinished` AS `t1_c4`, `activityStatus`.`score` AS `t1_c5`, `activityStatus`.`create_date` AS `t1_c6`, `activityStatus`.`finishDate` AS `t1_c7` FROM `user_activitiesstatus` `activityStatus` WHERE (user_id=:user) AND (`activityStatus`.`activity_id`=:ypl0)
3 0.000971 0.000324 0.000244 0.000482
SELECT * FROM `users` `t` WHERE session=:session LIMIT 1
2 0.000969 0.000485 0.000483 0.000486
SELECT `t`.`id` AS `t0_c0`, `t`.`group_id` AS `t0_c1`, `t`.`resource_id` AS `t0_c2`, `t`.`title` AS `t0_c3`, `t`.`type` AS `t0_c4`, `t`.`facultyNames` AS `t0_c5`, `t`.`shortDescription` AS `t0_c6`, `t`.`fullDescription` AS `t0_c7`, `t`.`creditAmount` AS `t0_c8`, `t`.`shortAddress` AS `t0_c9`, `t`.`creditType` AS `t0_c10`, `t`.`startDate` AS `t0_c11`, `t`.`finishDate` AS `t0_c12`, `t`.`sponsors` AS `t0_c13`, `t`.`status` AS `t0_c14`, `t`.`createDate` AS `t0_c15`, `t`.`image` AS `t0_c16`, `t`.`image_featured` AS `t0_c17`, `t`.`archived` AS `t0_c18`, `t`.`managers_list` AS `t0_c19`, `t`.`is_send_pp_email` AS `t0_c20`, `t`.`muvi_sync_date` AS `t0_c21`, `t`.`expert_questions` AS `t0_c22`, `interaction`.`id` AS `t1_c0`, `interaction`.`activity_id` AS `t1_c1`, `interaction`.`title` AS `t1_c2`, `interaction`.`link` AS `t1_c3`, `interaction`.`type` AS `t1_c4`, `interaction`.`status` AS `t1_c5`, `interaction`.`createDate` AS `t1_c6` FROM `activities` `t` LEFT OUTER JOIN `interactions` `interaction` ON (`interaction`.`activity_id`=`t`.`id`) WHERE (`t`.`id`=236)
1 0.000603 0.000603 0.000603 0.000603
SELECT `activity_id` AS `c`, COUNT(*) AS `s` FROM `user_activitiesstatus` `t` WHERE (user_id=:user AND isFinished=1) AND (`t`.`activity_id`=236) GROUP BY `activity_id`
1 0.000492 0.000492 0.000492 0.000492
SELECT `resource`.`id` AS `t1_c0`, `resource`.`shortAddress` AS `t1_c1`, `resource`.`status` AS `t1_c2`, `resource`.`title` AS `t1_c3`, `resource`.`type` AS `t1_c4`, `resource`.`image` AS `t1_c5`, `resource`.`slides` AS `t1_c6`, `resource`.`linkedResources` AS `t1_c7`, `resource`.`reading` AS `t1_c8`, `resource`.`shortDescription` AS `t1_c9`, `resource`.`fullDescription` AS `t1_c10`, `resource`.`link` AS `t1_c11`, `resource`.`createDate` AS `t1_c12`, `resource`.`archived` AS `t1_c13` FROM `resources` `resource` WHERE (`resource`.`id`=:ypl0)
1 0.000457 0.000457 0.000457 0.000457
SELECT * FROM `questionnaires` `t` WHERE t.activity_id=:id AND t.type=:type LIMIT 1
1 0.000423 0.000423 0.000423 0.000423
SHOW CREATE TABLE `events`
1 0.000370 0.000370 0.000370 0.000370
SHOW CREATE TABLE `activities`
1 0.000348 0.000348 0.000348 0.000348
SHOW CREATE TABLE `users`
1 0.000336 0.000336 0.000336 0.000336
SHOW CREATE TABLE `user_activitiesstatus`
1 0.000310 0.000310 0.000310 0.000310
SHOW CREATE TABLE `view_log`
1 0.000308 0.000308 0.000308 0.000308
SHOW CREATE TABLE `resources`
1 0.000304 0.000304 0.000304 0.000304
SHOW CREATE TABLE `interactions`
1 0.000297 0.000297 0.000297 0.000297
SHOW CREATE TABLE `questionnaires`
1 0.000294 0.000294 0.000294 0.000294
# Query Time (s)
0
select id, status from activities where FIND_IN_SET(:shortAddress, shortAddress)
0.000910
1
SHOW COLUMNS FROM `activities`
0.001558
2
SHOW CREATE TABLE `activities`
0.000348
3
SHOW COLUMNS FROM `users`
0.001689
4
SHOW CREATE TABLE `users`
0.000336
5
SELECT * FROM `users` `t` WHERE session=:session LIMIT 1
0.000486
6
INSERT INTO `users` (`role`, `sendEmails`, `sendSms`, `source`, `session`, `lastLogin`, `phone`, `createDate`) VALUES (:yp0, :yp1, :yp2, :yp3, :yp4, :yp5, :yp6, :yp7)
0.003761
7
SELECT * FROM `users` `t` WHERE session=:session LIMIT 1
0.000483
8
UPDATE `users` SET `lastLogin`=:yp0 WHERE `users`.`id`=2491797
0.003109
9
SELECT * FROM `activities` `t` WHERE `t`.`id`=236 LIMIT 1
0.000494
10
SHOW COLUMNS FROM `events`
0.001549
11
SHOW CREATE TABLE `events`
0.000370
12
SELECT `event`.`id` AS `t1_c0`, `event`.`group_id` AS `t1_c1`, `event`.`shortAddress` AS `t1_c2`, `event`.`resource_id` AS `t1_c3`, `event`.`type` AS `t1_c4`, `event`.`addType` AS `t1_c5`, `event`.`title` AS `t1_c6`, `event`.`shortDescription` AS `t1_c7`, `event`.`facultyNames` AS `t1_c8`, `event`.`faculty` AS `t1_c9`, `event`.`calendarDate` AS `t1_c10`, `event`.`creditAmount` AS `t1_c11`, `event`.`creditType` AS `t1_c12`, `event`.`shortWhen` AS `t1_c13`, `event`.`fullWhen` AS `t1_c14`, `event`.`venue` AS `t1_c15`, `event`.`shortWhere` AS `t1_c16`, `event`.`fullWhere` AS `t1_c17`, `event`.`createDate` AS `t1_c18`, `event`.`status` AS `t1_c19`, `event`.`description` AS `t1_c20`, `event`.`image` AS `t1_c21`, `event`.`linkout` AS `t1_c22`, `event`.`registrationEnabled` AS `t1_c23`, `event`.`activity_id` AS `t1_c24`, `event`.`adobe_connect_sco` AS `t1_c25`, `event`.`adobe_connect_datetime` AS `t1_c26`, `event`.`users_limit` AS `t1_c27`, `event`.`adobe_connect_duration` AS `t1_c28`, `event`.`calendar_description` AS `t1_c29` FROM `events` `event` WHERE (`event`.`activity_id`=:ypl0)
0.001885
13
select id, status from activities where FIND_IN_SET(:shortAddress, shortAddress)
0.000258
14
SELECT * FROM `activities` `t` WHERE `t`.`id`=236 LIMIT 1
0.000281
15
SELECT `event`.`id` AS `t1_c0`, `event`.`group_id` AS `t1_c1`, `event`.`shortAddress` AS `t1_c2`, `event`.`resource_id` AS `t1_c3`, `event`.`type` AS `t1_c4`, `event`.`addType` AS `t1_c5`, `event`.`title` AS `t1_c6`, `event`.`shortDescription` AS `t1_c7`, `event`.`facultyNames` AS `t1_c8`, `event`.`faculty` AS `t1_c9`, `event`.`calendarDate` AS `t1_c10`, `event`.`creditAmount` AS `t1_c11`, `event`.`creditType` AS `t1_c12`, `event`.`shortWhen` AS `t1_c13`, `event`.`fullWhen` AS `t1_c14`, `event`.`venue` AS `t1_c15`, `event`.`shortWhere` AS `t1_c16`, `event`.`fullWhere` AS `t1_c17`, `event`.`createDate` AS `t1_c18`, `event`.`status` AS `t1_c19`, `event`.`description` AS `t1_c20`, `event`.`image` AS `t1_c21`, `event`.`linkout` AS `t1_c22`, `event`.`registrationEnabled` AS `t1_c23`, `event`.`activity_id` AS `t1_c24`, `event`.`adobe_connect_sco` AS `t1_c25`, `event`.`adobe_connect_datetime` AS `t1_c26`, `event`.`users_limit` AS `t1_c27`, `event`.`adobe_connect_duration` AS `t1_c28`, `event`.`calendar_description` AS `t1_c29` FROM `events` `event` WHERE (`event`.`activity_id`=:ypl0)
0.000261
16
SELECT * FROM `activities` `t` WHERE `t`.`id`=236 LIMIT 1
0.000293
17
SHOW COLUMNS FROM `user_activitiesstatus`
0.001044
18
SHOW CREATE TABLE `user_activitiesstatus`
0.000310
19
SELECT `activityStatus`.`id` AS `t1_c0`, `activityStatus`.`user_id` AS `t1_c1`, `activityStatus`.`activity_id` AS `t1_c2`, `activityStatus`.`current` AS `t1_c3`, `activityStatus`.`isFinished` AS `t1_c4`, `activityStatus`.`score` AS `t1_c5`, `activityStatus`.`create_date` AS `t1_c6`, `activityStatus`.`finishDate` AS `t1_c7` FROM `user_activitiesstatus` `activityStatus` WHERE (user_id=:user) AND (`activityStatus`.`activity_id`=:ypl0)
0.000482
20
UPDATE activities SET archived=1 WHERE finishDate<now();
0.005850
21
SHOW COLUMNS FROM `view_log`
0.001176
22
SHOW CREATE TABLE `view_log`
0.000308
23
INSERT INTO `view_log` (`source`, `unique_id`, `resource_id`, `type`) VALUES (:yp0, :yp1, :yp2, :yp3)
0.003289
24
SHOW COLUMNS FROM `interactions`
0.001026
25
SHOW CREATE TABLE `interactions`
0.000297
26
SELECT `t`.`id` AS `t0_c0`, `t`.`group_id` AS `t0_c1`, `t`.`resource_id` AS `t0_c2`, `t`.`title` AS `t0_c3`, `t`.`type` AS `t0_c4`, `t`.`facultyNames` AS `t0_c5`, `t`.`shortDescription` AS `t0_c6`, `t`.`fullDescription` AS `t0_c7`, `t`.`creditAmount` AS `t0_c8`, `t`.`shortAddress` AS `t0_c9`, `t`.`creditType` AS `t0_c10`, `t`.`startDate` AS `t0_c11`, `t`.`finishDate` AS `t0_c12`, `t`.`sponsors` AS `t0_c13`, `t`.`status` AS `t0_c14`, `t`.`createDate` AS `t0_c15`, `t`.`image` AS `t0_c16`, `t`.`image_featured` AS `t0_c17`, `t`.`archived` AS `t0_c18`, `t`.`managers_list` AS `t0_c19`, `t`.`is_send_pp_email` AS `t0_c20`, `t`.`muvi_sync_date` AS `t0_c21`, `t`.`expert_questions` AS `t0_c22`, `interaction`.`id` AS `t1_c0`, `interaction`.`activity_id` AS `t1_c1`, `interaction`.`title` AS `t1_c2`, `interaction`.`link` AS `t1_c3`, `interaction`.`type` AS `t1_c4`, `interaction`.`status` AS `t1_c5`, `interaction`.`createDate` AS `t1_c6` FROM `activities` `t` LEFT OUTER JOIN `interactions` `interaction` ON (`interaction`.`activity_id`=`t`.`id`) WHERE (`t`.`id`=236)
0.000603
27
SELECT `activity_id` AS `c`, COUNT(*) AS `s` FROM `user_activitiesstatus` `t` WHERE (user_id=:user AND isFinished=1) AND (`t`.`activity_id`=236) GROUP BY `activity_id`
0.000492
28
SELECT `event`.`id` AS `t1_c0`, `event`.`group_id` AS `t1_c1`, `event`.`shortAddress` AS `t1_c2`, `event`.`resource_id` AS `t1_c3`, `event`.`type` AS `t1_c4`, `event`.`addType` AS `t1_c5`, `event`.`title` AS `t1_c6`, `event`.`shortDescription` AS `t1_c7`, `event`.`facultyNames` AS `t1_c8`, `event`.`faculty` AS `t1_c9`, `event`.`calendarDate` AS `t1_c10`, `event`.`creditAmount` AS `t1_c11`, `event`.`creditType` AS `t1_c12`, `event`.`shortWhen` AS `t1_c13`, `event`.`fullWhen` AS `t1_c14`, `event`.`venue` AS `t1_c15`, `event`.`shortWhere` AS `t1_c16`, `event`.`fullWhere` AS `t1_c17`, `event`.`createDate` AS `t1_c18`, `event`.`status` AS `t1_c19`, `event`.`description` AS `t1_c20`, `event`.`image` AS `t1_c21`, `event`.`linkout` AS `t1_c22`, `event`.`registrationEnabled` AS `t1_c23`, `event`.`activity_id` AS `t1_c24`, `event`.`adobe_connect_sco` AS `t1_c25`, `event`.`adobe_connect_datetime` AS `t1_c26`, `event`.`users_limit` AS `t1_c27`, `event`.`adobe_connect_duration` AS `t1_c28`, `event`.`calendar_description` AS `t1_c29` FROM `events` `event` WHERE (`event`.`activity_id`=:ypl0)
0.000283
29
SELECT * FROM `activities` `t` WHERE `t`.`id`=236 LIMIT 1
0.000321
30
SELECT `activityStatus`.`id` AS `t1_c0`, `activityStatus`.`user_id` AS `t1_c1`, `activityStatus`.`activity_id` AS `t1_c2`, `activityStatus`.`current` AS `t1_c3`, `activityStatus`.`isFinished` AS `t1_c4`, `activityStatus`.`score` AS `t1_c5`, `activityStatus`.`create_date` AS `t1_c6`, `activityStatus`.`finishDate` AS `t1_c7` FROM `user_activitiesstatus` `activityStatus` WHERE (user_id=:user) AND (`activityStatus`.`activity_id`=:ypl0)
0.000245
31
SELECT * FROM `activities` `t` WHERE `t`.`id`=236 LIMIT 1
0.000316
32
SELECT `activityStatus`.`id` AS `t1_c0`, `activityStatus`.`user_id` AS `t1_c1`, `activityStatus`.`activity_id` AS `t1_c2`, `activityStatus`.`current` AS `t1_c3`, `activityStatus`.`isFinished` AS `t1_c4`, `activityStatus`.`score` AS `t1_c5`, `activityStatus`.`create_date` AS `t1_c6`, `activityStatus`.`finishDate` AS `t1_c7` FROM `user_activitiesstatus` `activityStatus` WHERE (user_id=:user) AND (`activityStatus`.`activity_id`=:ypl0)
0.000244
33
SHOW COLUMNS FROM `questionnaires`
0.001022
34
SHOW CREATE TABLE `questionnaires`
0.000294
35
SELECT * FROM `questionnaires` `t` WHERE t.activity_id=:id AND t.type=:type LIMIT 1
0.000423
36
SHOW COLUMNS FROM `resources`
0.001122
37
SHOW CREATE TABLE `resources`
0.000304
38
SELECT `resource`.`id` AS `t1_c0`, `resource`.`shortAddress` AS `t1_c1`, `resource`.`status` AS `t1_c2`, `resource`.`title` AS `t1_c3`, `resource`.`type` AS `t1_c4`, `resource`.`image` AS `t1_c5`, `resource`.`slides` AS `t1_c6`, `resource`.`linkedResources` AS `t1_c7`, `resource`.`reading` AS `t1_c8`, `resource`.`shortDescription` AS `t1_c9`, `resource`.`fullDescription` AS `t1_c10`, `resource`.`link` AS `t1_c11`, `resource`.`createDate` AS `t1_c12`, `resource`.`archived` AS `t1_c13` FROM `resources` `resource` WHERE (`resource`.`id`=:ypl0)
0.000457
Log Messages
Message (details) Level Category Time