Image
Engage the Patient

A Breath of Fresh Air in Pediatric Asthma

Shared Decision-making in the Era of Biologics

Meeting Slides

Handouts

Shared Decision-making Tool

Helping families understand biologic therapy for severe pediatric asthma

Clinical Practice Tools

Clinical tools to assess asthma control in children.

Dinakar C, et al. Pediatrics. 2017:139(1):e20163438.

Assessing Asthma Control and Adjusting Therapy in Children.

The National Asthma Education and Prevention Program Expert Panel Report provides a stepwise approach to the assessment of asthma control in children as well as in adolescents within their 2007 Full Report (Figures 12-15).

Assessing Asthma Control and Adjusting Therapy in Children

The National Asthma Education and Prevention Program Expert Panel Report provides a stepwise approach to the assessment of asthma control in children as well as in adolescents within their 2007 Full Report (Figures 12-15).

Childhood Asthma Control Test (C-ACT)

This questionnaire includes 4 pictorial items and 3 verbal items and is appropriate for helping to assess asthma control in children 4 to 11 years old. A score of <19 on the C-ACT suggests asthma that is uncontrolled.

Asthma Control Test (ACT)  

This 5-item questionnaire helps evaluate asthma control in children aged 12 years or older. A score of <20 on the ACT suggests asthma that is uncontrolled.

Asthma Control Questionnaire (ACQ-6)

This 6-item questionnaire helps assess asthma control in children aged 6 to 16 years and has a recall window of 1 week. Scores range from 1 (totally controlled) to 6 (severely uncontrolled).

Juniper EF, et al. Eur Respir J. 2010;36(6):1410-1416

Test for Respiratory and Asthma Control in Kids (TRACK)

This 5-item questionnaire helps assess asthma control in children 0 to 5 years old. A score <80 is suggestive of asthma that is uncontrolled.

American Academy of Pediatrics (AAP) Asthma Action Plan aged 0 to 5 years

These asthma action plans have been developed for children aged 0 to 5 years

American Academy of Pediatrics (AAP) Asthma Action Plan ≥6 years

These asthma action plans have been developed for children ≥6 years.

Clinical Practice Guidelines

Global Strategy for Asthma Management and Prevention.

Global Initiative for Asthma, 2021.

Management of severe asthma: a European Respiratory Society/American Thoracic Society guideline.

Holguin F, et al. Eur Respir J. 2020;55(1):1900588.

Patient Advocacy Organizations and Resources

American Academy of Pediatrics (AAP)

AAP’s healthychildren.org website is powered by pediatricians and is a trusted resource for parents of children with asthma and allergies. Resources include useful tips from pediatricians on mitigating triggers, evolving information on asthma therapies, patient education videos centered around the proper use of medication devices, and much more.

Asthma and Allergy Foundation of America (AAFA)

AAFA is dedicated to improving the quality of life for people with asthma and allergic diseases through education, advocacy, and research.

American College of Allergy, Asthma & Immunology (ACAAI)

The ACAAI fosters a culture of collaboration and congeniality in which members work toward the common goals of patient care, education, advocacy, and research.

American Lung Association

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

American Thoracic Society (ATS)

The mission of the ATS is to improve health worldwide by advancing research, clinical care, and public health in respiratory disease, critical illness, and sleep disorders.

Chest Foundation

The CHEST Foundation creates trusted patient education resources and disease awareness campaigns that empower patients to engage in better managing their health.

Suggested Readings

Asthma.

Patel SJ, Teach SJ. Pediatr Rev. 2019;40(11):549-567.

Which child with asthma is a candidate for biological therapies?

Bush A. J Clin Med. 2020;9(4):1237.

Heterogeneity of severe asthma in childhood: confirmation by cluster analysis of children in the National Institutes of Health/National Heart, Lung, and Blood Institute Severe Asthma Research Program.

Fitzpatrick AM, et al. J Allergy Clin Immunol. 2011;127(2):382-389.

Omalizumab for the treatment of exacerbations in children with inadequately controlled allergic (IgE-mediated) asthma.

Lanier B, et al. J Allergy Clin Immunol. 2009;124(6):1210-1216.

Long-term safety and pharmacodynamics of mepolizumab in children with severe asthma with an eosinophilic phenotype.

Gupta A, et al. J Allergy Clin Immunol. 2019;144(5):1336-1342.e7.

Predictors of enhanced response with benralizumab for patients with severe asthma: pooled analysis of the SIROCCO and CALIMA studies.

FitzGerald JM, et al. Lancet Respir Med. 2018;6(1):51-64.

Dupilumab efficacy and safety in moderate-to-severe uncontrolled asthma.

Castro M, et al. N Engl J Med. 2018;378(26):2486-2496.

Dupilumab efficacy and safety in children with uncontrolled, moderate-to-severe asthma: the phase 3 VOYAGE study.

Bacharier LB, et al. ATS 2021. Abstract A1204.

Efficacy and safety of tezepelumab in adults and adolocesents with severe, uncontrolled asthma: results the phase 3 NAVIGATOR study.

Menzies-Gow A, et al J Allergy Clin Immunol.2021;147(2):AB249.

Interactive Presentation

A Parent’s Testimonial

Based on a true event, this video will provide the perspective of a parent whose young child experienced a severe asthma exacerbation leading to hospitalization.


Shared Decision-making in Pediatric Asthma

This short clip of a telemedicine visit between a physician and a parent of a child with severe asthma provides an example of a focused discussion on the use of biologic therapies in children.


Activity
A Breath of Fresh Air in Pediatric Asthma

Shared Decision-making in the Era of Biologics

Relevant Resources

Chronic Obstructive Pulmonary Disease, Asthma, or Both

Differential Diagnosis and Comprehensive Management Strategies

Improving Outcomes in Chronic Obstructive Pulmonary Disease

Optimizing Maintenance Therapy Across Healthcare Settings

Clearing the Air

Improving Outcomes for Patients with COPD

Comprehensive Management of Chronic Obstructive Pulmonary Disease

Collaborative Approaches to Guideline-Concordant Patient Care

Clinical Updates in the Management of Severe Asthma

New Strategies for Individualizing Long-term Care

Improving Outcomes in Severe Asthma

A New Era in Precision Medicine

Caring for Patients with Severe Asthma

Evolving Best Practices to Optimize Outcomes

Clinical Issues in Severe Asthma

Consensus and Controversies on the Road to Precision Medicine

Breathing Life Into COPD Management

Ongoing Monitoring, Pulmonary Rehabilitation, and Individualized Care

Clinical Issues in Severe Asthma

Debates and Discussions About Personalizing Patient Management

Advancing the Care of Severe Asthma

Differential Diagnosis, Multidisciplinary Management, and Patient Engagement

Focusing on Patients With Severe Asthma

From Guideline Recommendations to Daily Clinical Decision-Making

Clearing the Air in Severe Asthma Management

Improving Patient Outcomes Through Shared Clinical Decision Making

Clearing the Air in Severe Asthma Management

Improving Patient Outcomes Through Shared Clinical Decision Making

Marching Forward in Atopic Dermatitis

Digging Deep on Shared Decision-Making

Airing It Out

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

COPD in Managed Care

The Clinical and Utilization Benefits of Exacerbation Prevention

Finding the Right Path in Severe Asthma

Mechanistic Insights and Emerging Treatment Options

COPD Cases and Conversations

A Focus on Exacerbation Prevention

Demystifying New Evidence for COPD Management

Best Practices for Primary Care

Updates on Chronic Rhinosinusitis with Nasal Polyps

Evolving Best Practices for Patient Management

Swimming Upstream in Severe Asthma

New Pathways to Patient Management

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

From Comprehensive Patient Evaluations to Individualized Evidence-based Care

COPD Cases & Conversations

Preventing COPD Exacerbations to Improve Outcomes

Clinical Issues in COVID-19

Debates and Discussions about Monoclonal Antibody Therapies

MINIMIZING PATIENT RISKS FROM COVID-19

An Update on Monoclonal Antibody Therapies

TOOLBAR

Yii 1.1.12

Request
Request Server Parameters
USER 'www-data'
HOME '/var/www'
HTTP_CONNECTION 'Keep-Alive'
HTTP_HOST 'www.exchangecme.com'
HTTP_ACCEPT_ENCODING 'br,gzip'
HTTP_IF_MODIFIED_SINCE 'Wed, 23 Jun 2021 04:53:44 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 '37664'
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 '/pedsasthma'
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 1632351751.4154
REQUEST_TIME 1632351751
Request Cookies
Session Attributes
Request GET Parameters
id '168'
Request POST Parameters
Request FILES
Application Settings
Application Properties
defaultController 'site'
layout 'main'
controllerMap array
(
'debug' => array
(
'class' => 'YiiDebugController'
)
)
catchAllRequest null
controllerNamespace null
name 'ExchangeCME'
charset 'UTF-8'
sourceLanguage 'en_us'
preload array
(
0 => 'log'
)
behaviors array()
Modules
gii array
(
'class' => 'system.gii.GiiModule'
'password'
=> '123123'
'ipFilters'
=> array
(
0 => '*'
)
)
Application Params
dateFormat 'm/d/Y'
lastTimeToAttendEvent 172800
passTestLine 70
maxFileSize 1048576
imageDir '/var/www/exchangecme/files/upload/images'
linkImageDir '/files/upload/images'
linkInterDir '/files/upload/interactions'
actUpDir '/activities'
newsUpDir '/news'
resUpDir '/resources'
evUpDir '/events'
interScormDir '/scorm'
environment 'prod'
mandrillApiKey 'bOVWUkHldCbJevygSZtrVg'
rememberTime 'INTERVAL 1 DAY'
fromEmail 'support@exchangeCME.com'
fromName 'exchangeCME.com'
infoEmail 'info@exchangecme.com'
infoEmail2 'info@integritasgrp.com'
subject 'Registration'
certificates array
(
'sizes' => array
(
1 => array
(
'w' => 500
'h' => 398
)
2 => array
(
'w' => 30
'h' => 30
)
)
)
sms array
(
'api_key' => '315336da'
'api_secret'
=> 'c37c6167be626d2d'
'to'
=> '12016818114'
'from'
=> '12016958971'
)
adobeConnect array
(
'adminEmail' => ''
'adminPassword'
=> ''
)
timeZone 'America/New_York'
bigmarketWebinar array
(
'host' => 'https://www.bigmarker.com/'
'apiKey'
=> 'c76d1dea6472a01db6ca'
)
baseUrl 'https://www.exchangecme.com'
zoomWebinar array
(
'host' => 'https://api.zoom.us/'
'access_token'
=> 'eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJhdWQiOm51bGwsImlzcyI6Ikc4cEg4Vk9HVDBtMW1RRGY4SVh1MkEiLCJleHAiOjE4OTgyMzkwMjAsImlhdCI6MTYxMzYzNzQ5MX0.gRKOnZlOSWOnYgtC-BG-Sxw_x9h82TKKohotwptw-Wo'
)
Components
urlManager array
(
'class' => 'CUrlManager'
'rules'
=> array
(
'/' => 'site/index'
'<view:(terms|privacy)>'
=> 'site/page'
'admin'
=> 'backend/site/index'
'activities'
=> 'activities/index'
'groups/<group:[\w\d.-]+>'
=> 'activities/group'
'group-events/<group:[\w\d.-]+>'
=> 'events/group'
'site'
=> 'site/index'
'googleSearch'
=> 'site/googleSearch'
'search'
=> 'site/search'
'subscription'
=> 'site/subscription'
'events'
=> 'events/index'
'resources'
=> 'resources/index'
'<controller:(certificates|news|questions|site|users|activities|eventActivities|events)>/<action:\w+>'
=> '<controller>/<action>'
'<controller:(survey)>/<surveyId:\d+>/<email:[\w\d@.-]+>'
=> 'activities/survey'
0 => array
(
'class' => 'application.components.ShortLinksUrlRule'
)
'<id:[\w\d.-]+>/reportcenter/' => 'manager/viewReport'
'groups/<id:[\w\d.-]+>/reportcenter/'
=> 'manager/viewGroupReport'
'manager/activities'
=> 'manager/viewActivities'
'manager/group-activities'
=> 'manager/viewGroupActivities'
)
'urlSuffix' => ''
'showScriptName'
=> false
'appendParams' => true
'routeVar' => 'r'
'caseSensitive'
=> true
'matchValue' => false
'cacheID' => 'cache'
'useStrictParsing'
=> false
'urlRuleClass' => 'CUrlRule'
'behaviors'
=> array()
)
request array
(
'class' => 'CHttpRequest'
'enableCookieValidation'
=> false
'enableCsrfValidation' => false
'csrfTokenName' => 'YII_CSRF_TOKEN'
'csrfCookie'
=> null
'behaviors' => array()
)
db array
(
'class' => 'CDbConnection'
'connectionString'
=> 'mysql:host=localhost;dbname=exchangeCME'
'username'
=> 'root'
'password'
=> 'wqeeqwe12123ewerwe'
'schemaCachingDuration'
=> 3600
'schemaCachingExclude' => array()
'schemaCacheID' => 'cache'
'queryCachingDuration'
=> 0
'queryCachingDependency' => null
'queryCachingCount' => 0
'queryCacheID' => 'cache'
'autoConnect'
=> true
'charset' => 'utf8'
'emulatePrepare'
=> true
'enableParamLogging' => false
'enableProfiling' => true
'tablePrefix' => null
'initSQLs' => null
'driverMap' => array
(
'pgsql' => 'CPgsqlSchema'
'mysqli'
=> 'CMysqlSchema'
'mysql'
=> 'CMysqlSchema'
'sqlite'
=> 'CSqliteSchema'
'sqlite2'
=> 'CSqliteSchema'
'mssql'
=> 'CMssqlSchema'
'dblib'
=> 'CMssqlSchema'
'sqlsrv'
=> 'CMssqlSchema'
'oci'
=> 'COciSchema'
)
'pdoClass' => 'PDO'
'behaviors'
=> array()
)
log array
(
'class' => 'CLogRouter'
'behaviors'
=> array()
)
viewRenderer array
(
'class' => 'YiiDebugViewRenderer'
)
clientScript array
(
'class' => 'CClientScript'
'enableJavaScript'
=> true
'scriptMap' => array()
'packages' => array()
'corePackages' => array
(
'jquery' => array
(
'js' => array
(
0 => 'jquery.min.js'
)
)
'yii' => array
(
'js' => array
(
0 => 'jquery.yii.js'
)
'depends' => array
(
0 => 'jquery'
)
)
'yiitab' => array
(
'js' => array
(
0 => 'jquery.yiitab.js'
)
'depends' => array
(
0 => 'jquery'
)
)
'yiiactiveform' => array
(
'js' => array
(
0 => 'jquery.yiiactiveform.js'
)
'depends' => array
(
0 => 'jquery'
)
)
'jquery.ui' => array
(
'js' => array
(
0 => 'jui/js/jquery-ui.min.js'
)
'depends' => array
(
0 => 'jquery'
)
)
'bgiframe' => array
(
'js' => array
(
0 => 'jquery.bgiframe.js'
)
'depends' => array
(
0 => 'jquery'
)
)
'ajaxqueue' => array
(
'js' => array
(
0 => 'jquery.ajaxqueue.js'
)
'depends' => array
(
0 => 'jquery'
)
)
'autocomplete' => array
(
'js' => array
(
0 => 'jquery.autocomplete.js'
)
'depends' => array
(
0 => 'jquery'
1 => 'bgiframe'
2 => 'ajaxqueue'
)
)
'maskedinput' => array
(
'js' => array
(
0 => 'jquery.maskedinput.min.js'
)
'depends' => array
(
0 => 'jquery'
)
)
'cookie' => array
(
'js' => array
(
0 => 'jquery.cookie.js'
)
'depends' => array
(
0 => 'jquery'
)
)
'treeview' => array
(
'js' => array
(
0 => 'jquery.treeview.js'
1 => 'jquery.treeview.edit.js'
2 => 'jquery.treeview.async.js'
)
'depends' => array
(
0 => 'jquery'
1 => 'cookie'
)
)
'multifile' => array
(
'js' => array
(
0 => 'jquery.multifile.js'
)
'depends' => array
(
0 => 'jquery'
)
)
'rating' => array
(
'js' => array
(
0 => 'jquery.rating.js'
)
'depends' => array
(
0 => 'jquery'
1 => 'metadata'
)
)
'metadata' => array
(
'js' => array
(
0 => 'jquery.metadata.js'
)
'depends' => array
(
0 => 'jquery'
)
)
'bbq' => array
(
'js' => array
(
0 => 'jquery.ba-bbq.js'
)
'depends' => array
(
0 => 'jquery'
)
)
'history' => array
(
'js' => array
(
0 => 'jquery.history.js'
)
'depends' => array
(
0 => 'jquery'
)
)
)
'scripts' => array()
'coreScriptPosition' => 0
'defaultScriptFilePosition' => 0
'defaultScriptPosition' => 4
'behaviors' => array()
)
assetManager array
(
'class' => 'CAssetManager'
'linkAssets'
=> false
'excludeFiles' => array
(
0 => '.svn'
1 => '.gitignore'
)
'newFileMode' => 438
'newDirMode' => 511
'forceCopy' => false
'behaviors' => array()
)
themeManager array
(
'class' => 'CThemeManager'
'themeClass'
=> 'CTheme'
'behaviors'
=> array()
)
session array
(
'class' => 'CHttpSession'
'autoStart'
=> true
'behaviors' => array()
)
user array
(
'class' => 'WebUser'
'allowAutoLogin'
=> true
'guestName' => 'Guest'
'loginUrl'
=> array
(
0 => '/users/personalization'
)
'identityCookie' => null
'authTimeout' => null
'autoRenewCookie' => false
'autoUpdateFlash' => true
'loginRequiredAjaxResponse' => null
'behaviors' => array
(
'botRecognizer' => array
(
'class' => 'application.extensions.botRecognizer.botRecognizer'
)
)
)
widgetFactory array
(
'class' => 'CWidgetFactory'
'enableSkin'
=> false
'widgets' => array()
'skinnableWidgets' => null
'skinPath' => null
'behaviors' => array()
)
messages array
(
'class' => 'CPhpMessageSource'
'cachingDuration'
=> 0
'cacheID' => 'cache'
'basePath'
=> '/var/www/exchangecme/protected/messages'
'forceTranslation'
=> false
'behaviors' => array()
)
Views Rendering
Context ResourcesController
Context class ResourcesController
Inheritance Controller » CController » CBaseController
Defined in file protected/controllers/ResourcesController.php
Context properties
  •  => 
  •  => 
  •  => 
  •  => 
  •  => 
Route resources/view
Action CInlineAction (view)
Action params
  •  => 
Render methodrenderPartial
View file themes/desktop/views/resources/view.php
View data
  •  => 
Context ResourcesController
Context class ResourcesController
Inheritance Controller » CController » CBaseController
Defined in file protected/controllers/ResourcesController.php
Context properties
  •  => 
  •  => 
  •  => 
  •  => 
  •  => 
Route resources/view
Action CInlineAction (view)
Action params
  •  => 
Render methodrenderPartial
View file themes/desktop/views/resources/_activity.php
View data
  •  => 
Context ResourcesController
Context class ResourcesController
Inheritance Controller » CController » CBaseController
Defined in file protected/controllers/ResourcesController.php
Context properties
  •  => 
  •  => 
  •  => 
  •  => 
  •  => 
Route resources/view
Action CInlineAction (view)
Action params
  •  => 
Render methodrender
View file protected/views/layouts/column1.php
Context ResourcesController
Context class ResourcesController
Inheritance Controller » CController » CBaseController
Defined in file protected/controllers/ResourcesController.php
Context properties
  •  => 
  •  => 
  •  => 
  •  => 
  •  => 
Route resources/view
Action CInlineAction (view)
Action params
  •  => 
Render methodrender
View file themes/desktop/views/layouts/main.php
Context ResourcesController
Context class ResourcesController
Inheritance Controller » CController » CBaseController
Defined in file protected/controllers/ResourcesController.php
Context properties
  •  => 
  •  => 
  •  => 
  •  => 
  •  => 
Route resources/view
Action CInlineAction (view)
Action params
  •  => 
Render methodrenderPartial
View file themes/desktop/views/common/_footer.php
View data
    null
Context ResourcesController
Context class ResourcesController
Inheritance Controller » CController » CBaseController
Defined in file protected/controllers/ResourcesController.php
Context properties
  •  => 
  •  => 
  •  => 
  •  => 
  •  => 
Route resources/view
Action CInlineAction (view)
Action params
  •  => 
Render methodrenderPartial
View file themes/desktop/views/common/elasticsearch.php
View data
    null
Context YiiDebugToolbarResourceUsage
Context class YiiDebugToolbarResourceUsage
Inheritance CWidget » CBaseController
Defined in file protected/extensions/malyshev/yii-debug-toolbar/widgets/YiiDebugToolbarResourceUsage.php
Context properties
  •  => 
  •  => 
  •  => 
Render methodrender
View file protected/extensions/malyshev/yii-debug-toolbar/widgets/views/resources.php
View data
  •  => 
SQL Queries from 1 connection (23/0.024944s)

Connection ID: db (CDbConnection)

Driver mysql
Server Version 5.5.59-0ubuntu0.14.04.1
Uptime 14w 1d 6h 1m 55s
Threads 1
Questions 40788904
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)
INSERT INTO `users` (`role`, `sendEmails`, `sendSms`, `source`, `session`, `lastLogin`, `phone`, `createDate`) VALUES (:yp0, :yp1, :yp2, :yp3, :yp4, :yp5, :yp6, :yp7)
1 0.003897 0.003897 0.003897 0.003897
SELECT r.id, COUNT(r.id) relevance FROM resources r join `resource_topics` rtj on rtj.`resource_id`=r.id WHERE rtj.`topic_id` in (SELECT topic_id from `resource_topics` rt where rt.`resource_id`=:rid AND rt.topic_id>0) AND r.id <> :rid AND r.status = 'active' Group by r.id order by relevance DESC, r.`createDate` DESC
1 0.003433 0.003433 0.003433 0.003433
UPDATE `users` SET `lastLogin`=:yp0 WHERE `users`.`id`=2491820
1 0.002943 0.002943 0.002943 0.002943
SELECT `activities`.`id` AS `t1_c0`, `activities`.`group_id` AS `t1_c1`, `activities`.`resource_id` AS `t1_c2`, `activities`.`title` AS `t1_c3`, `activities`.`type` AS `t1_c4`, `activities`.`facultyNames` AS `t1_c5`, `activities`.`shortDescription` AS `t1_c6`, `activities`.`fullDescription` AS `t1_c7`, `activities`.`creditAmount` AS `t1_c8`, `activities`.`shortAddress` AS `t1_c9`, `activities`.`creditType` AS `t1_c10`, `activities`.`startDate` AS `t1_c11`, `activities`.`finishDate` AS `t1_c12`, `activities`.`sponsors` AS `t1_c13`, `activities`.`status` AS `t1_c14`, `activities`.`createDate` AS `t1_c15`, `activities`.`image` AS `t1_c16`, `activities`.`image_featured` AS `t1_c17`, `activities`.`archived` AS `t1_c18`, `activities`.`managers_list` AS `t1_c19`, `activities`.`is_send_pp_email` AS `t1_c20`, `activities`.`muvi_sync_date` AS `t1_c21`, `activities`.`expert_questions` AS `t1_c22` FROM `activities` `activities` WHERE (`activities`.`resource_id`=:ypl0)
1 0.001544 0.001544 0.001544 0.001544
SHOW COLUMNS FROM `resources`
1 0.001434 0.001434 0.001434 0.001434
SELECT * FROM `resources` `t` WHERE `t`.`id` IN (180, 181, 172, 171, 169, 163, 151, 144, 142, 138, 137, 136, 126, 117, 116, 104, 92, 90, 79, 68, 63, 62, 57, 54, 53, 47, 34, 32)
1 0.001406 0.001406 0.001406 0.001406
SHOW COLUMNS FROM `activities`
1 0.001372 0.001372 0.001372 0.001372
select id, status from activities where FIND_IN_SET(:shortAddress, shortAddress)
2 0.001214 0.000607 0.000284 0.000930
SHOW COLUMNS FROM `users`
1 0.001189 0.001189 0.001189 0.001189
SHOW COLUMNS FROM `interactions`
1 0.001132 0.001132 0.001132 0.001132
SHOW COLUMNS FROM `resource_videos`
1 0.000981 0.000981 0.000981 0.000981
SELECT * FROM `users` `t` WHERE session=:session LIMIT 1
2 0.000937 0.000468 0.000463 0.000474
select id from resources where FIND_IN_SET(:shortAddress, shortAddress)
2 0.000911 0.000456 0.000260 0.000651
SELECT `videos`.`id` AS `t1_c0`, `videos`.`vzaar_id` AS `t1_c1`, `videos`.`title` AS `t1_c2`, `videos`.`description` AS `t1_c3`, `videos`.`resource_id` AS `t1_c4`, `videos`.`type` AS `t1_c5` FROM `resource_videos` `videos` WHERE (`videos`.`resource_id`=:ypl0)
1 0.000498 0.000498 0.000498 0.000498
SELECT * FROM `resources` `t` WHERE `t`.`id`=168 LIMIT 1
1 0.000484 0.000484 0.000484 0.000484
SHOW CREATE TABLE `resources`
1 0.000339 0.000339 0.000339 0.000339
SHOW CREATE TABLE `users`
1 0.000318 0.000318 0.000318 0.000318
SHOW CREATE TABLE `activities`
1 0.000315 0.000315 0.000315 0.000315
SHOW CREATE TABLE `interactions`
1 0.000300 0.000300 0.000300 0.000300
SHOW CREATE TABLE `resource_videos`
1 0.000297 0.000297 0.000297 0.000297
# Query Time (s)
0
select id, status from activities where FIND_IN_SET(:shortAddress, shortAddress)
0.000930
1
select id from resources where FIND_IN_SET(:shortAddress, shortAddress)
0.000651
2
select id, status from activities where FIND_IN_SET(:shortAddress, shortAddress)
0.000284
3
select id from resources where FIND_IN_SET(:shortAddress, shortAddress)
0.000260
4
SHOW COLUMNS FROM `resources`
0.001434
5
SHOW CREATE TABLE `resources`
0.000339
6
SELECT * FROM `resources` `t` WHERE `t`.`id`=168 LIMIT 1
0.000484
7
SHOW COLUMNS FROM `interactions`
0.001132
8
SHOW CREATE TABLE `interactions`
0.000300
9
SHOW COLUMNS FROM `resource_videos`
0.000981
10
SHOW CREATE TABLE `resource_videos`
0.000297
11
SELECT `videos`.`id` AS `t1_c0`, `videos`.`vzaar_id` AS `t1_c1`, `videos`.`title` AS `t1_c2`, `videos`.`description` AS `t1_c3`, `videos`.`resource_id` AS `t1_c4`, `videos`.`type` AS `t1_c5` FROM `resource_videos` `videos` WHERE (`videos`.`resource_id`=:ypl0)
0.000498
12
SHOW COLUMNS FROM `activities`
0.001372
13
SHOW CREATE TABLE `activities`
0.000315
14
SHOW COLUMNS FROM `users`
0.001189
15
SHOW CREATE TABLE `users`
0.000318
16
SELECT * FROM `users` `t` WHERE session=:session LIMIT 1
0.000474
17
INSERT INTO `users` (`role`, `sendEmails`, `sendSms`, `source`, `session`, `lastLogin`, `phone`, `createDate`) VALUES (:yp0, :yp1, :yp2, :yp3, :yp4, :yp5, :yp6, :yp7)
0.003897
18
SELECT * FROM `users` `t` WHERE session=:session LIMIT 1
0.000463
19
UPDATE `users` SET `lastLogin`=:yp0 WHERE `users`.`id`=2491820
0.002943
20
SELECT `activities`.`id` AS `t1_c0`, `activities`.`group_id` AS `t1_c1`, `activities`.`resource_id` AS `t1_c2`, `activities`.`title` AS `t1_c3`, `activities`.`type` AS `t1_c4`, `activities`.`facultyNames` AS `t1_c5`, `activities`.`shortDescription` AS `t1_c6`, `activities`.`fullDescription` AS `t1_c7`, `activities`.`creditAmount` AS `t1_c8`, `activities`.`shortAddress` AS `t1_c9`, `activities`.`creditType` AS `t1_c10`, `activities`.`startDate` AS `t1_c11`, `activities`.`finishDate` AS `t1_c12`, `activities`.`sponsors` AS `t1_c13`, `activities`.`status` AS `t1_c14`, `activities`.`createDate` AS `t1_c15`, `activities`.`image` AS `t1_c16`, `activities`.`image_featured` AS `t1_c17`, `activities`.`archived` AS `t1_c18`, `activities`.`managers_list` AS `t1_c19`, `activities`.`is_send_pp_email` AS `t1_c20`, `activities`.`muvi_sync_date` AS `t1_c21`, `activities`.`expert_questions` AS `t1_c22` FROM `activities` `activities` WHERE (`activities`.`resource_id`=:ypl0)
0.001544
21
SELECT r.id, COUNT(r.id) relevance FROM resources r join `resource_topics` rtj on rtj.`resource_id`=r.id WHERE rtj.`topic_id` in (SELECT topic_id from `resource_topics` rt where rt.`resource_id`=:rid AND rt.topic_id>0) AND r.id <> :rid AND r.status = 'active' Group by r.id order by relevance DESC, r.`createDate` DESC
0.003433
22
SELECT * FROM `resources` `t` WHERE `t`.`id` IN (180, 181, 172, 171, 169, 163, 151, 144, 142, 138, 137, 136, 126, 117, 116, 104, 92, 90, 79, 68, 63, 62, 57, 54, 53, 47, 34, 32)
0.001406
Log Messages
Message (details) Level Category Time