Image
Biologics for Moderate-to-Severe Asthma Module 2

Monica Kraft, MD

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

 

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

Faculty

Monica Kraft, MD
Professor, Medicine
Chair, Department of Medicine
The Robert and Irene Flinn Endowed Chair in Medicine
University of Arizona (UA) College of Medicine – Tucson
Deputy Director, UA Health Sciences Asthma and Airway Disease Research Center
Tucson, Arizona

Target Audience

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

Educational Objective

After completing this activity, the participant should be better able to:

  • Describe the clinical profiles of and prescribing considerations for biologic therapies in the treatment of moderate-to-severe asthma

Statement of Need

Asthma-related symptoms and exacerbations result in almost 2 million emergency department visits each year.1,2 Importantly, severe disease accounts for an outsized proportion of asthma-related mortality, morbidity, and health care costs.3-5 Children with severe asthma, in particular, are at increased risk for recurrent, life-threatening exacerbations and medication-related adverse outcomes.6 Further, parents of children with severe disease report substantial psychosocial and quality-of-life impairments.7

In this 4-part CME SnapshotTM series, expert faculty will examine best practices for the assessment and phenotypic classification of moderate-to-severe asthma in adult and pediatric patients as well as evaluate biomarkers that may be used to distinguish disease endotypes and guide treatment selection. Following a review of the latest evidence surrounding biologic therapies for moderate-to-severe asthma and their use in targeting specific disease endotypes, expert faculty will walk participants through challenging clinical case scenarios—discussing the application of evidence to the practice of precision medicine in asthma care. Faculty will also share their clinical pearls on how to best engage patients in a shared decision-making manner when selecting among biologic treatment options. After completion of the activity, participants will be well-equipped to translate the latest evidence and expert recommendations for individualized asthma management to next-day practice.

References

  1. Centers for Disease Control and Prevention. Asthma Facts: CDC’s National Asthma Control Program Grantees, 2013. https://www.cdc.gov/asthma/pdfs/asthma_facts_program_grantees.pdf
  2. Nunes C, et al. Asthma Res Pract. 2017;3:1.
  3. Levy ML. Breathe (Sheff). 2015;11(1):14-24.
  4. Bahadori K, et al. BMC Pulm Med. 2009;9:24.
  5. Pijnenburg MW, Fleming L. Lancet Respir Med. 2020;8(10):1032-1044.
  6. Moorman JE, et al. Vital Health Stat 3. 2012;35:1-58.
  7. Boeschoten SA, et al. Pediatr Pulmonol. 2020;55(11):2883-2892.

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 designates this enduring material for a maximum of 0.25 AMA PRA Category 1 Credit™. Physicians should claim only the credit commensurate with the extent of their participation in the activity.

Global Contact Information

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

Integritas Communications Contact Information

For all other questions about this activity, please contact Integritas Communications at info@exchangecme.com.

Instructions to Receive Credit

In order to receive credit for this activity, the participant must complete the preactivity questionnaire, view the educational content, score 70% or better on the posttest, and complete the program evaluation.

Fee Information & Refund/Cancellation Policy

There is no fee for this educational activity.

Disclosure of Conflicts of Interest

Global adheres to the policies and guidelines, including the Standards for Integrity and Independence in Accredited Continuing Education (CE), set forth to providers by the Accreditation Council for Continuing Medical Education (ACCME) and all other professional organizations, as applicable, stating those activities where continuing education credits are awarded must be balanced, independent, objective, and scientifically rigorous. All persons in a position to control the content of an accredited continuing education program provided by Global are required to disclose all financial relationships with any ineligible company within the past 24 months to Global. All financial relationships reported are identified as relevant and mitigated by Global in accordance with the Standards for Integrity and Independence in Accredited CE in advance of delivery of the activity to learners. The content of this activity was vetted by Global to assure objectivity and that the activity is free of commercial bias.

All relevant financial relationships have been mitigated.

The faculty have the following relevant financial relationships with ineligible companies:

Monica KraftConsultant/Independent Contractor:  AstraZeneca plc, sanofi-aventis U.S. LLC. Grant/Research Support:AstraZeneca plc, Chiesi USA, Inc., sanofi-aventis U.S. LLC

The planners and managers have the following relevant financial relationships with ineligible companies:

Lindsay Borvansky, Andrea Funk, Liddy Knight, Ashley Cann, Celeste Collazo, MD, Rose O'Connor, PhD, CHCP

Term of Offering

This activity was released on May 14, 2021 and is valid for one year. Requests for credit must be made no later than May 14, 2022.

System Requirements

PC
Microsoft Windows 2000 SE or above.
Internet Explorer (v5.5 or greater), Chrome, or Firefox

MAC
MAC OS 10.2.8
Safari
Internet Explorer is not supported on the Macintosh.

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 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 0.25

credit type CME/CE

release 05/14/2021

expiration 05/14/2022

type SnapShot


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:22:14 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 '36114'
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 '/21Asthma02'
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 1632353303.1251
REQUEST_TIME 1632353303
Request Cookies
Session Attributes
Request GET Parameters
id '272'
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.035238s)

Connection ID: db (CDbConnection)

Driver mysql
Server Version 5.5.59-0ubuntu0.14.04.1
Uptime 14w 1d 6h 27m 47s
Threads 1
Questions 40792286
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.006413 0.006413 0.006413 0.006413
INSERT INTO `users` (`role`, `sendEmails`, `sendSms`, `source`, `session`, `lastLogin`, `phone`, `createDate`) VALUES (:yp0, :yp1, :yp2, :yp3, :yp4, :yp5, :yp6, :yp7)
1 0.003732 0.003732 0.003732 0.003732
INSERT INTO `view_log` (`source`, `unique_id`, `resource_id`, `type`) VALUES (:yp0, :yp1, :yp2, :yp3)
1 0.003468 0.003468 0.003468 0.003468
UPDATE `users` SET `lastLogin`=:yp0 WHERE `users`.`id`=2491864
1 0.003035 0.003035 0.003035 0.003035
SHOW COLUMNS FROM `activities`
1 0.001752 0.001752 0.001752 0.001752
SELECT * FROM `activities` `t` WHERE `t`.`id`=272 LIMIT 1
5 0.001450 0.000290 0.000277 0.000300
SHOW COLUMNS FROM `events`
1 0.001422 0.001422 0.001422 0.001422
SHOW COLUMNS FROM `users`
1 0.001238 0.001238 0.001238 0.001238
SHOW COLUMNS FROM `view_log`
1 0.001219 0.001219 0.001219 0.001219
SHOW COLUMNS FROM `resources`
1 0.001123 0.001123 0.001123 0.001123
SHOW COLUMNS FROM `questionnaires`
1 0.001043 0.001043 0.001043 0.001043
SHOW COLUMNS FROM `user_activitiesstatus`
1 0.001023 0.001023 0.001023 0.001023
SELECT * FROM `users` `t` WHERE session=:session LIMIT 1
2 0.001020 0.000510 0.000463 0.000557
SHOW COLUMNS FROM `interactions`
1 0.001011 0.001011 0.001011 0.001011
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.000973 0.000324 0.000252 0.000465
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.000822 0.000274 0.000274 0.000274
select id, status from activities where FIND_IN_SET(:shortAddress, shortAddress)
2 0.000582 0.000291 0.000268 0.000314
SELECT `activity_id` AS `c`, COUNT(*) AS `s` FROM `user_activitiesstatus` `t` WHERE (user_id=:user AND isFinished=1) AND (`t`.`activity_id`=272) GROUP BY `activity_id`
1 0.000451 0.000451 0.000451 0.000451
SHOW CREATE TABLE `activities`
1 0.000361 0.000361 0.000361 0.000361
SHOW CREATE TABLE `events`
1 0.000338 0.000338 0.000338 0.000338
SHOW CREATE TABLE `users`
1 0.000333 0.000333 0.000333 0.000333
SHOW CREATE TABLE `view_log`
1 0.000324 0.000324 0.000324 0.000324
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`=272)
1 0.000316 0.000316 0.000316 0.000316
SHOW CREATE TABLE `user_activitiesstatus`
1 0.000313 0.000313 0.000313 0.000313
SHOW CREATE TABLE `interactions`
1 0.000308 0.000308 0.000308 0.000308
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.000306 0.000306 0.000306 0.000306
SHOW CREATE TABLE `resources`
1 0.000305 0.000305 0.000305 0.000305
SHOW CREATE TABLE `questionnaires`
1 0.000300 0.000300 0.000300 0.000300
SELECT * FROM `questionnaires` `t` WHERE t.activity_id=:id AND t.type=:type LIMIT 1
1 0.000256 0.000256 0.000256 0.000256
# Query Time (s)
0
select id, status from activities where FIND_IN_SET(:shortAddress, shortAddress)
0.000314
1
SHOW COLUMNS FROM `activities`
0.001752
2
SHOW CREATE TABLE `activities`
0.000361
3
SHOW COLUMNS FROM `users`
0.001238
4
SHOW CREATE TABLE `users`
0.000333
5
SELECT * FROM `users` `t` WHERE session=:session LIMIT 1
0.000557
6
INSERT INTO `users` (`role`, `sendEmails`, `sendSms`, `source`, `session`, `lastLogin`, `phone`, `createDate`) VALUES (:yp0, :yp1, :yp2, :yp3, :yp4, :yp5, :yp6, :yp7)
0.003732
7
SELECT * FROM `users` `t` WHERE session=:session LIMIT 1
0.000463
8
UPDATE `users` SET `lastLogin`=:yp0 WHERE `users`.`id`=2491864
0.003035
9
SELECT * FROM `activities` `t` WHERE `t`.`id`=272 LIMIT 1
0.000300
10
SHOW COLUMNS FROM `events`
0.001422
11
SHOW CREATE TABLE `events`
0.000338
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.000274
13
select id, status from activities where FIND_IN_SET(:shortAddress, shortAddress)
0.000268
14
SELECT * FROM `activities` `t` WHERE `t`.`id`=272 LIMIT 1
0.000293
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.000274
16
SELECT * FROM `activities` `t` WHERE `t`.`id`=272 LIMIT 1
0.000298
17
SHOW COLUMNS FROM `user_activitiesstatus`
0.001023
18
SHOW CREATE TABLE `user_activitiesstatus`
0.000313
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.000465
20
UPDATE activities SET archived=1 WHERE finishDate<now();
0.006413
21
SHOW COLUMNS FROM `view_log`
0.001219
22
SHOW CREATE TABLE `view_log`
0.000324
23
INSERT INTO `view_log` (`source`, `unique_id`, `resource_id`, `type`) VALUES (:yp0, :yp1, :yp2, :yp3)
0.003468
24
SHOW COLUMNS FROM `interactions`
0.001011
25
SHOW CREATE TABLE `interactions`
0.000308
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`=272)
0.000316
27
SELECT `activity_id` AS `c`, COUNT(*) AS `s` FROM `user_activitiesstatus` `t` WHERE (user_id=:user AND isFinished=1) AND (`t`.`activity_id`=272) GROUP BY `activity_id`
0.000451
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.000274
29
SELECT * FROM `activities` `t` WHERE `t`.`id`=272 LIMIT 1
0.000282
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.000252
31
SELECT * FROM `activities` `t` WHERE `t`.`id`=272 LIMIT 1
0.000277
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.000256
33
SHOW COLUMNS FROM `questionnaires`
0.001043
34
SHOW CREATE TABLE `questionnaires`
0.000300
35
SELECT * FROM `questionnaires` `t` WHERE t.activity_id=:id AND t.type=:type LIMIT 1
0.000256
36
SHOW COLUMNS FROM `resources`
0.001123
37
SHOW CREATE TABLE `resources`
0.000305
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.000306
Log Messages
Message (details) Level Category Time