Where Are We Now in Moderate-to-Severe Asthma?

From Comprehensive Patient Evaluations to Individualized Evidence-Based Care

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.

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

Image SnapShot
Evaluating Patients With Moderate-to-Severe Asthma

Module 1

Jonathan Corren, MD
MODULE 1
Begin Activity

credit amount 0.25

credit type CME/CE

expiration 06/08/2022

Image SnapShot
Biologics for Moderate-to-Severe Asthma

Module 2

Monica Kraft, MD
MODULE 2
Begin Activity

credit amount 0.25

credit type CME/CE

expiration 05/14/2022

Image SnapShot
A Case-Based Look at Managing Moderate-to-Severe Asthma

Module 3

Jonathan Corren, MD; Monica Kraft, MD
MODULE 3
Begin Activity

credit amount 0.25

credit type CME/CE

expiration 06/21/2022

Image SnapShot
Shared Decision-making in the Management of Moderate-to-Severe Asthma

Module 4

Jonathan Corren, MD; Monica Kraft, MD
MODULE 4
Begin Activity

credit amount 0.50

credit type CME/CE

expiration 07/13/2022

Resource

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

From Comprehensive Patient Evaluations to Individualized Evidence-based Care
Review

ExchangeCME is a division of InSci Productions, LLC.

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

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

Privacy Policy and Terms of Use.

TOOLBAR

Yii 1.1.12

Request
Request Server Parameters
USER 'www-data'
HOME '/var/www'
HTTP_CONNECTION 'Keep-Alive'
HTTP_HOST 'www.exchangecme.com'
HTTP_ACCEPT_ENCODING 'br,gzip'
HTTP_IF_MODIFIED_SINCE 'Mon, 02 Aug 2021 17:34:37 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 '60614'
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 '/groups/21Asthma'
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 1632350560.6225
REQUEST_TIME 1632350560
Request Cookies
Session Attributes
Request GET Parameters
group '21Asthma'
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()
)
log array
(
'class' => 'CLogRouter'
'behaviors' => array()
)
viewRenderer array
(
'class' => 'YiiDebugViewRenderer'
)
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()
)
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
(
2 => array
(
'topics' => '
$(function() {
$(\'#clinical-topics\').on (\'change\', function () {
window.location.href = \'/resources/index/topic/\'+$(this).val();
})
})
'
)
)
'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()
)
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'
)
)
)
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/group
Action CInlineAction (group)
Action params
  •  => 
Render methodrenderPartial
View file themes/desktop/views/activities/groups.php
View data
  •  => 
  •  => 
  •  => 
  •  => 
Context ActivitiesController
Context class ActivitiesController
Inheritance CommonActivitiesController » Controller » CController » CBaseController
Defined in file protected/controllers/ActivitiesController.php
Context properties
  •  => 
  •  => 
  •  => 
  •  => 
  •  => 
Route activities/group
Action CInlineAction (group)
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/group
Action CInlineAction (group)
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/group
Action CInlineAction (group)
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/group
Action CInlineAction (group)
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 (52/0.036047s)

Connection ID: db (CDbConnection)

Driver mysql
Server Version 5.5.59-0ubuntu0.14.04.1
Uptime 14w 1d 5h 42m 4s
Threads 1
Questions 40785730
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)
SELECT * FROM `user_activitiesstatus` `t` WHERE `t`.`user_id` IS NULL AND `t`.`activity_id`=:yp0 LIMIT 1
 24 0.006429 0.000268 0.000239 0.000381
UPDATE activities SET archived=1 WHERE finishDate<now();
 1 0.006011 0.006011 0.006011 0.006011
INSERT INTO `users` (`role`, `sendEmails`, `sendSms`, `source`, `session`, `lastLogin`, `phone`, `createDate`) VALUES (:yp0, :yp1, :yp2, :yp3, :yp4, :yp5, :yp6, :yp7)
 1 0.003653 0.003653 0.003653 0.003653
UPDATE `users` SET `lastLogin`=:yp0 WHERE `users`.`id`=2491748
 1 0.002959 0.002959 0.002959 0.002959
SHOW COLUMNS FROM `activities`
 1 0.001709 0.001709 0.001709 0.001709
SHOW COLUMNS FROM `events`
 1 0.001449 0.001449 0.001449 0.001449
SHOW COLUMNS FROM `users`
 1 0.001357 0.001357 0.001357 0.001357
SHOW COLUMNS FROM `activities_groups`
 1 0.001353 0.001353 0.001353 0.001353
SHOW COLUMNS FROM `resources`
 1 0.001214 0.001214 0.001214 0.001214
SHOW COLUMNS FROM `activity_topics`
 1 0.001104 0.001104 0.001104 0.001104
SELECT * FROM `users` `t` WHERE session=:session LIMIT 1
 2 0.001044 0.000522 0.000496 0.000548
SHOW COLUMNS FROM `user_activitiesstatus`
 1 0.001041 0.001041 0.001041 0.001041
SHOW COLUMNS FROM `interactions`
 1 0.001014 0.001014 0.001014 0.001014
SHOW COLUMNS FROM `topics`
 1 0.000944 0.000944 0.000944 0.000944
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`, `topics`.`id` AS `t1_c0`, `topics`.`title` AS `t1_c1`, `topics`.`url` AS `t1_c2`, `topics`.`sort` AS `t1_c3`, `event`.`id` AS `t2_c0`, `event`.`group_id` AS `t2_c1`, `event`.`shortAddress` AS `t2_c2`, `event`.`resource_id` AS `t2_c3`, `event`.`type` AS `t2_c4`, `event`.`addType` AS `t2_c5`, `event`.`title` AS `t2_c6`, `event`.`shortDescription` AS `t2_c7`, `event`.`facultyNames` AS `t2_c8`, `event`.`faculty` AS `t2_c9`, `event`.`calendarDate` AS `t2_c10`, `event`.`creditAmount` AS `t2_c11`, `event`.`creditType` AS `t2_c12`, `event`.`shortWhen` AS `t2_c13`, `event`.`fullWhen` AS `t2_c14`, `event`.`venue` AS `t2_c15`, `event`.`shortWhere` AS `t2_c16`, `event`.`fullWhere` AS `t2_c17`, `event`.`createDate` AS `t2_c18`, `event`.`status` AS `t2_c19`, `event`.`description` AS `t2_c20`, `event`.`image` AS `t2_c21`, `event`.`linkout` AS `t2_c22`, `event`.`registrationEnabled` AS `t2_c23`, `event`.`activity_id` AS `t2_c24`, `event`.`adobe_connect_sco` AS `t2_c25`, `event`.`adobe_connect_datetime` AS `t2_c26`, `event`.`users_limit` AS `t2_c27`, `event`.`adobe_connect_duration` AS `t2_c28`, `event`.`calendar_description` AS `t2_c29`, `interaction`.`id` AS `t3_c0`, `interaction`.`activity_id` AS `t3_c1`, `interaction`.`title` AS `t3_c2`, `interaction`.`link` AS `t3_c3`, `interaction`.`type` AS `t3_c4`, `interaction`.`status` AS `t3_c5`, `interaction`.`createDate` AS `t3_c6` FROM `activities` `t` LEFT OUTER JOIN `activity_topics` `topics_topics` ON (`t`.`id`=`topics_topics`.`activity_id`) LEFT OUTER JOIN `topics` `topics` ON (`topics`.`id`=`topics_topics`.`topic_id`) LEFT OUTER JOIN `events` `event` ON (`event`.`activity_id`=`t`.`id`) LEFT OUTER JOIN `interactions` `interaction` ON (`interaction`.`activity_id`=`t`.`id`) WHERE ((((t.status = :status_active) AND (t.archived=0)) AND (t.group_id=31)) AND (event.id IS NULL)) ORDER BY t.createDate DESC
 1 0.000592 0.000592 0.000592 0.000592
SHOW CREATE TABLE `activities_groups`
 1 0.000384 0.000384 0.000384 0.000384
SHOW CREATE TABLE `activities`
 1 0.000380 0.000380 0.000380 0.000380
SHOW CREATE TABLE `interactions`
 1 0.000370 0.000370 0.000370 0.000370
SHOW CREATE TABLE `users`
 1 0.000354 0.000354 0.000354 0.000354
SHOW CREATE TABLE `events`
 1 0.000333 0.000333 0.000333 0.000333
SHOW CREATE TABLE `user_activitiesstatus`
 1 0.000309 0.000309 0.000309 0.000309
SELECT * FROM `resources` `t` WHERE `t`.`id`=171 LIMIT 1
 1 0.000307 0.000307 0.000307 0.000307
SHOW CREATE TABLE `resources`
 1 0.000304 0.000304 0.000304 0.000304
SHOW CREATE TABLE `activity_topics`
 1 0.000296 0.000296 0.000296 0.000296
SHOW CREATE TABLE `topics`
 1 0.000293 0.000293 0.000293 0.000293
SELECT * FROM `activities_groups` `t` WHERE `t`.`id`=31 LIMIT 1
 1 0.000284 0.000284 0.000284 0.000284
SELECT * FROM `activities` `t` WHERE `t`.`id` IS NULL LIMIT 1
 1 0.000280 0.000280 0.000280 0.000280
select id from activities_groups where FIND_IN_SET(:shortAddress, shortlink)
 1 0.000280 0.000280 0.000280 0.000280
# Query Time (s)
0
SHOW COLUMNS FROM `activities`
 0.001709
1
SHOW CREATE TABLE `activities`
 0.000380
2
SHOW COLUMNS FROM `users`
 0.001357
3
SHOW CREATE TABLE `users`
 0.000354
4
SELECT * FROM `users` `t` WHERE session=:session LIMIT 1
 0.000548
5
INSERT INTO `users` (`role`, `sendEmails`, `sendSms`, `source`, `session`, `lastLogin`, `phone`, `createDate`) VALUES (:yp0, :yp1, :yp2, :yp3, :yp4, :yp5, :yp6, :yp7)
 0.003653
6
SELECT * FROM `users` `t` WHERE session=:session LIMIT 1
 0.000496
7
UPDATE `users` SET `lastLogin`=:yp0 WHERE `users`.`id`=2491748
 0.002959
8
SELECT * FROM `activities` `t` WHERE `t`.`id` IS NULL LIMIT 1
 0.000280
9
UPDATE activities SET archived=1 WHERE finishDate<now();
 0.006011
10
select id from activities_groups where FIND_IN_SET(:shortAddress, shortlink)
 0.000280
11
SHOW COLUMNS FROM `activities_groups`
 0.001353
12
SHOW CREATE TABLE `activities_groups`
 0.000384
13
SELECT * FROM `activities_groups` `t` WHERE `t`.`id`=31 LIMIT 1
 0.000284
14
SHOW COLUMNS FROM `resources`
 0.001214
15
SHOW CREATE TABLE `resources`
 0.000304
16
SELECT * FROM `resources` `t` WHERE `t`.`id`=171 LIMIT 1
 0.000307
17
SHOW COLUMNS FROM `topics`
 0.000944
18
SHOW CREATE TABLE `topics`
 0.000293
19
SHOW COLUMNS FROM `events`
 0.001449
20
SHOW CREATE TABLE `events`
 0.000333
21
SHOW COLUMNS FROM `interactions`
 0.001014
22
SHOW CREATE TABLE `interactions`
 0.000370
23
SHOW COLUMNS FROM `activity_topics`
 0.001104
24
SHOW CREATE TABLE `activity_topics`
 0.000296
25
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`, `topics`.`id` AS `t1_c0`, `topics`.`title` AS `t1_c1`, `topics`.`url` AS `t1_c2`, `topics`.`sort` AS `t1_c3`, `event`.`id` AS `t2_c0`, `event`.`group_id` AS `t2_c1`, `event`.`shortAddress` AS `t2_c2`, `event`.`resource_id` AS `t2_c3`, `event`.`type` AS `t2_c4`, `event`.`addType` AS `t2_c5`, `event`.`title` AS `t2_c6`, `event`.`shortDescription` AS `t2_c7`, `event`.`facultyNames` AS `t2_c8`, `event`.`faculty` AS `t2_c9`, `event`.`calendarDate` AS `t2_c10`, `event`.`creditAmount` AS `t2_c11`, `event`.`creditType` AS `t2_c12`, `event`.`shortWhen` AS `t2_c13`, `event`.`fullWhen` AS `t2_c14`, `event`.`venue` AS `t2_c15`, `event`.`shortWhere` AS `t2_c16`, `event`.`fullWhere` AS `t2_c17`, `event`.`createDate` AS `t2_c18`, `event`.`status` AS `t2_c19`, `event`.`description` AS `t2_c20`, `event`.`image` AS `t2_c21`, `event`.`linkout` AS `t2_c22`, `event`.`registrationEnabled` AS `t2_c23`, `event`.`activity_id` AS `t2_c24`, `event`.`adobe_connect_sco` AS `t2_c25`, `event`.`adobe_connect_datetime` AS `t2_c26`, `event`.`users_limit` AS `t2_c27`, `event`.`adobe_connect_duration` AS `t2_c28`, `event`.`calendar_description` AS `t2_c29`, `interaction`.`id` AS `t3_c0`, `interaction`.`activity_id` AS `t3_c1`, `interaction`.`title` AS `t3_c2`, `interaction`.`link` AS `t3_c3`, `interaction`.`type` AS `t3_c4`, `interaction`.`status` AS `t3_c5`, `interaction`.`createDate` AS `t3_c6` FROM `activities` `t` LEFT OUTER JOIN `activity_topics` `topics_topics` ON (`t`.`id`=`topics_topics`.`activity_id`) LEFT OUTER JOIN `topics` `topics` ON (`topics`.`id`=`topics_topics`.`topic_id`) LEFT OUTER JOIN `events` `event` ON (`event`.`activity_id`=`t`.`id`) LEFT OUTER JOIN `interactions` `interaction` ON (`interaction`.`activity_id`=`t`.`id`) WHERE ((((t.status = :status_active) AND (t.archived=0)) AND (t.group_id=31)) AND (event.id IS NULL)) ORDER BY t.createDate DESC
 0.000592
26
SHOW COLUMNS FROM `user_activitiesstatus`
 0.001041
27
SHOW CREATE TABLE `user_activitiesstatus`
 0.000309
28
SELECT * FROM `user_activitiesstatus` `t` WHERE `t`.`user_id` IS NULL AND `t`.`activity_id`=:yp0 LIMIT 1
 0.000381
29
SELECT * FROM `user_activitiesstatus` `t` WHERE `t`.`user_id` IS NULL AND `t`.`activity_id`=:yp0 LIMIT 1
 0.000256
30
SELECT * FROM `user_activitiesstatus` `t` WHERE `t`.`user_id` IS NULL AND `t`.`activity_id`=:yp0 LIMIT 1
 0.000249
31
SELECT * FROM `user_activitiesstatus` `t` WHERE `t`.`user_id` IS NULL AND `t`.`activity_id`=:yp0 LIMIT 1
 0.000246
32
SELECT * FROM `user_activitiesstatus` `t` WHERE `t`.`user_id` IS NULL AND `t`.`activity_id`=:yp0 LIMIT 1
 0.000246
33
SELECT * FROM `user_activitiesstatus` `t` WHERE `t`.`user_id` IS NULL AND `t`.`activity_id`=:yp0 LIMIT 1
 0.000268
34
SELECT * FROM `user_activitiesstatus` `t` WHERE `t`.`user_id` IS NULL AND `t`.`activity_id`=:yp0 LIMIT 1
 0.000348
35
SELECT * FROM `user_activitiesstatus` `t` WHERE `t`.`user_id` IS NULL AND `t`.`activity_id`=:yp0 LIMIT 1
 0.000244
36
SELECT * FROM `user_activitiesstatus` `t` WHERE `t`.`user_id` IS NULL AND `t`.`activity_id`=:yp0 LIMIT 1
 0.000240
37
SELECT * FROM `user_activitiesstatus` `t` WHERE `t`.`user_id` IS NULL AND `t`.`activity_id`=:yp0 LIMIT 1
 0.000308
38
SELECT * FROM `user_activitiesstatus` `t` WHERE `t`.`user_id` IS NULL AND `t`.`activity_id`=:yp0 LIMIT 1
 0.000240
39
SELECT * FROM `user_activitiesstatus` `t` WHERE `t`.`user_id` IS NULL AND `t`.`activity_id`=:yp0 LIMIT 1
 0.000240
40
SELECT * FROM `user_activitiesstatus` `t` WHERE `t`.`user_id` IS NULL AND `t`.`activity_id`=:yp0 LIMIT 1
 0.000377
41
SELECT * FROM `user_activitiesstatus` `t` WHERE `t`.`user_id` IS NULL AND `t`.`activity_id`=:yp0 LIMIT 1
 0.000242
42
SELECT * FROM `user_activitiesstatus` `t` WHERE `t`.`user_id` IS NULL AND `t`.`activity_id`=:yp0 LIMIT 1
 0.000242
43
SELECT * FROM `user_activitiesstatus` `t` WHERE `t`.`user_id` IS NULL AND `t`.`activity_id`=:yp0 LIMIT 1
 0.000239
44
SELECT * FROM `user_activitiesstatus` `t` WHERE `t`.`user_id` IS NULL AND `t`.`activity_id`=:yp0 LIMIT 1
 0.000243
45
SELECT * FROM `user_activitiesstatus` `t` WHERE `t`.`user_id` IS NULL AND `t`.`activity_id`=:yp0 LIMIT 1
 0.000240
46
SELECT * FROM `user_activitiesstatus` `t` WHERE `t`.`user_id` IS NULL AND `t`.`activity_id`=:yp0 LIMIT 1
 0.000338
47
SELECT * FROM `user_activitiesstatus` `t` WHERE `t`.`user_id` IS NULL AND `t`.`activity_id`=:yp0 LIMIT 1
 0.000244
48
SELECT * FROM `user_activitiesstatus` `t` WHERE `t`.`user_id` IS NULL AND `t`.`activity_id`=:yp0 LIMIT 1
 0.000262
49
SELECT * FROM `user_activitiesstatus` `t` WHERE `t`.`user_id` IS NULL AND `t`.`activity_id`=:yp0 LIMIT 1
 0.000249
50
SELECT * FROM `user_activitiesstatus` `t` WHERE `t`.`user_id` IS NULL AND `t`.`activity_id`=:yp0 LIMIT 1
 0.000243
51
SELECT * FROM `user_activitiesstatus` `t` WHERE `t`.`user_id` IS NULL AND `t`.`activity_id`=:yp0 LIMIT 1
 0.000244
Log Messages
Message (details) Level Category Time