Image
Interactive Exchange

JAKi in RA Practice

Unpacking the Evidence for Their Use Today and Tomorrow

Meeting Slides

Guidelines

2015 American College of Rheumatology guideline for the treatment of rheumatoid arthritis.

Singh JA, et al. Arthritis Rheumatol. 2016;68(1):1-26.

EULAR recommendations for the management of rheumatoid arthritis with synthetic and biological disease-modifying antirheumatic drugs: 2016 update.

Smolen JS, et al. Ann Rheum Dis. 2017;76(6):960-977.

Patient, Caregiver, and Provider Resources

American College of Rheumatology: Patient and Caregiver Resources

The ACR has produced a library of videos about the impact of rheumatic disease, what to do when diagnosed with rheumatic disease, when to see a rheumatologist, and what patients have to say about their experiences of living with rheumatic disease.

Arthritis Foundation

The Arthritis Foundation provides self-care tools and resources covering treatment options, pain management, diet and exercise, and common comorbidities associated with many different arthritic conditions.

European League Against Rheumatism

EULAR is an organization that represents people with arthritis/rheumatism, health professionals, and scientific societies of rheumatology of all the European nations.

NIH Health Topics: Rheumatoid Arthritis

A resource from the National Institute of Arthritis and Musculoskeletal and Skin Diseases for people who have rheumatoid arthritis, as well as for their family members, friends, and others who want to find out more about rheumatoid arthritis.

Suggested Readings

JAK inhibition as a therapeutic strategy for immune and inflammatory diseases.

Schwartz DM, et al. Nat Rev Drug Discov. 2017;17(1):78.

Clinical efficacy of new JAK inhibitors under development. Just more of the same?

Westhovens R. Rheumatology (Oxford). 2019;58(suppl 1):i27-i33.

Janus Kinase Inhibitors for Rheumatoid Arthritis: Effectiveness and Value.

Institute for Clinical and Economic Review. October 11, 2019.

Efficacy and safety of tofacitinib monotherapy, tofacitinib with methotrexate, and adalimumab with methotrexate in patients with rheumatoid arthritis (ORAL Strategy): a phase 3b/4, double-blind, head-to-head, randomized controlled trial.

Fleischmann R, et al. Lancet. 2017;390(10093):457-468.

Baricitinib versus placebo or adalimumab in rheumatoid arthritis.

Taylor PC, et al. N Engl J Med. 2017;376(7):652-662.

Baricitinib, methotrexate, or combination in patients with rheumatoid arthritis and no or limited prior disease‐modifying antirheumatic drug treatment.

Fleischmann R, et al. Arthritis Rheumatol. 2017;69(3):506-517.

A phase 3, randomized, controlled trial comparing upadacitinib monotherapy to MTX monotherapy in MTX-naïve patients with active rheumatoid arthritis.

van Vollenhoven R, et al. Arthritis Rheumatol. 2018;70(suppl 10). Abstract 891.

A phase 3, randomized, double-blind study comparing upadacitinib to placebo and to adalimumab, in patients with active rheumatoid arthritis with inadequate response to methotrexate.

Fleischmann R, et al. Arthritis Rheumatol. 2018;70 (suppl 10). Abstract 890.

Safety profile of upadacitinib in rheumatoid arthritis: integrated analysis from the select phase 3 clinical program.

Cohen SB, et al. Ann Rheum Dis. 2019;78(suppl 2):A357. Abstract THU0167.

Safety and efficacy of filgotinib in a phase 3 trial of patients with active rheumatoid arthritis and inadequate response or intolerance to biologic DMARDs.

Genovese MC, et al. Arthritis Rheumatol. 2018;70(suppl 10). Abstract L06.

Systematic review and meta-analysis of serious infections with tofacitinib and biologic disease-modifying antirheumatic drug treatment in rheumatoid arthritis clinical trials.

Strand V, et al. Arthritis Res Ther. 2015;17:362.

Thromboembolism with Janus kinase (JAK) inhibitors for rheumatoid arthritis: how real is the risk?

Scott IC, et al. Drug Saf. 2018;41(7):645-653.

Pregnancy outcomes in the tofacitinib safety databases for rheumatoid arthritis and psoriasis.

Clowse ME, et al. Drug Saf. 2016;39(8):755-762.

Tofacitinib restores the inhibition of reverse cholesterol transport induced by inflammation: understanding the lipid paradox associated with rheumatoid arthritis.

Pérez-Baos S, et al. Br J Pharmacol. 2017:174(18):3018-3031.

Additional abstracts from the 2019 American College of Rheumatology (ACR)/Association for Rheumatology Professionals (ARP) Annual Meeting.

November 8-13, 2019; Atlanta, Georgia.

Interactive Presentation

JAK/STAT Signaling Transduction Pathways


Activity
JAKi in RA Practice

Unpacking the Evidence for Their Use Today and Tomorrow

Relevant Resources

Clinical Updates in Systemic Lupus Erythematosus

Improved Diagnostic and Management Strategies

Advances in Immunosupressive Therapy for Solid Organ Transplantation

Long-Term Management Strategies to Improve Patient Outcomes

Clinical Updates on the Management of Gout

Evidence-Based Strategies for Improved Patient Outcomes

Managing Gout in Primary Care

Evolving Strategies for Diagnosis and Long-Term Management

Improving Outcomes in Rheumatoid Arthritis

Treating to Target, IL-6-Directed Therapies, and Evolving Management Algorithms

Clinical Updates in Rheumatoid Arthritis

Evolving Treatment Algorithms and Expert Perspectives on Biosimilars

Going Deeper on Atopic Dermatitis

Pathophysiology to the Management of Moderate-to-Severe Disease

Looking Beneath The Surface In Atopic Dermatitis

Targeting Immune Dysregulation and Delivering Comprehensive Care

Evolving Treatment Paradigms For Rheumatoid Arthritis

Translating Comprehensive Patient Evaluations Into Personalized Therapy

Clinical Updates in Rheumatoid Arthritis

New Perspectives on Targeting Remission and Individualizing Therapy

A Better Look at Rheumatoid Arthritis

Using Imaging to Improve Patient Outcomes

Clinical Issues in Rheumatoid Arthritis

Discussions and Debates on the Evolving Roles of Targeted Synthetic DMARDs

Pathways to Better Outcomes in Systemic Lupus Erythematosus

Translating Pathophysiology into Targeted Treatments

The Big Picture of IBD

An Interactive Experience Highlighting Recent Clinical Advances

Clinical Issues in Rheumatoid Arthritis

Debates & Discussions on the Evolving Role of JAK Inhibitors

Clinical Issues in Rheumatoid Arthritis

The Evolving Role of JAK Inhibitors

What’s New in Systemic Lupus Erythematosus?

Unlocking Novel Paths to Patient Care

Expert Views on the Changing Landscape in RA

The Increasing Role of JAK Inhibitors

Updates in Systemic Lupus Erythematosus

Unlocking Novel Paths to Patient Care

Swimming Upstream in Severe Asthma

New Pathways to Patient Management

Optimizing Advanced Therapies in Ulcerative Colitis: Is Your Practice Up to Date?

A Focus on Clinical Evidence and Guideline Recommendations

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:56:15 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 '52060'
REMOTE_ADDR '3.236.232.99'
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 '/JAKResources19'
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 1634407458.6509
REQUEST_TIME 1634407458
Request Cookies
Session Attributes
Request GET Parameters
id '131'
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.018898s)

Connection ID: db (CDbConnection)

Driver mysql
Server Version 5.5.59-0ubuntu0.14.04.1
Uptime 17w 4d 1h 3m 42s
Threads 1
Questions 48190930
Slow queries 17
Opens 210
Flush tables 1
Open tables 176
Queries per second avg 4.533
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.003890 0.003890 0.003890 0.003890
UPDATE `users` SET `lastLogin`=:yp0 WHERE `users`.`id`=2539922
1 0.003014 0.003014 0.003014 0.003014
SHOW COLUMNS FROM `resources`
1 0.001521 0.001521 0.001521 0.001521
SHOW COLUMNS FROM `users`
1 0.001284 0.001284 0.001284 0.001284
SHOW COLUMNS FROM `activities`
1 0.001252 0.001252 0.001252 0.001252
SELECT * FROM `users` `t` WHERE session=:session LIMIT 1
2 0.001136 0.000568 0.000434 0.000702
SHOW COLUMNS FROM `interactions`
1 0.001051 0.001051 0.001051 0.001051
SHOW COLUMNS FROM `resource_videos`
1 0.001000 0.001000 0.001000 0.001000
SELECT * FROM `resources` `t` WHERE `t`.`id` IN (170, 169, 167, 164, 153, 149, 127, 110, 98, 97, 95, 86, 82, 78, 77, 75, 67, 60, 58, 46, 35, 28, 22, 5)
1 0.000785 0.000785 0.000785 0.000785
select id, status from activities where FIND_IN_SET(:shortAddress, shortAddress)
2 0.000613 0.000306 0.000273 0.000340
select id from resources where FIND_IN_SET(:shortAddress, shortAddress)
2 0.000509 0.000255 0.000254 0.000255
SHOW CREATE TABLE `users`
1 0.000398 0.000398 0.000398 0.000398
SHOW CREATE TABLE `resources`
1 0.000348 0.000348 0.000348 0.000348
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.000330 0.000330 0.000330 0.000330
SHOW CREATE TABLE `resource_videos`
1 0.000319 0.000319 0.000319 0.000319
SELECT * FROM `resources` `t` WHERE `t`.`id`=131 LIMIT 1
1 0.000302 0.000302 0.000302 0.000302
SHOW CREATE TABLE `activities`
1 0.000294 0.000294 0.000294 0.000294
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.000291 0.000291 0.000291 0.000291
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.000289 0.000289 0.000289 0.000289
SHOW CREATE TABLE `interactions`
1 0.000272 0.000272 0.000272 0.000272
# Query Time (s)
0
select id, status from activities where FIND_IN_SET(:shortAddress, shortAddress)
0.000340
1
select id from resources where FIND_IN_SET(:shortAddress, shortAddress)
0.000254
2
select id, status from activities where FIND_IN_SET(:shortAddress, shortAddress)
0.000273
3
select id from resources where FIND_IN_SET(:shortAddress, shortAddress)
0.000255
4
SHOW COLUMNS FROM `resources`
0.001521
5
SHOW CREATE TABLE `resources`
0.000348
6
SELECT * FROM `resources` `t` WHERE `t`.`id`=131 LIMIT 1
0.000302
7
SHOW COLUMNS FROM `interactions`
0.001051
8
SHOW CREATE TABLE `interactions`
0.000272
9
SHOW COLUMNS FROM `resource_videos`
0.001000
10
SHOW CREATE TABLE `resource_videos`
0.000319
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.000291
12
SHOW COLUMNS FROM `activities`
0.001252
13
SHOW CREATE TABLE `activities`
0.000294
14
SHOW COLUMNS FROM `users`
0.001284
15
SHOW CREATE TABLE `users`
0.000398
16
SELECT * FROM `users` `t` WHERE session=:session LIMIT 1
0.000702
17
INSERT INTO `users` (`role`, `sendEmails`, `sendSms`, `source`, `session`, `lastLogin`, `phone`, `createDate`) VALUES (:yp0, :yp1, :yp2, :yp3, :yp4, :yp5, :yp6, :yp7)
0.003890
18
SELECT * FROM `users` `t` WHERE session=:session LIMIT 1
0.000434
19
UPDATE `users` SET `lastLogin`=:yp0 WHERE `users`.`id`=2539922
0.003014
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.000330
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.000289
22
SELECT * FROM `resources` `t` WHERE `t`.`id` IN (170, 169, 167, 164, 153, 149, 127, 110, 98, 97, 95, 86, 82, 78, 77, 75, 67, 60, 58, 46, 35, 28, 22, 5)
0.000785
Log Messages
Message (details) Level Category Time