Image
Clinical Research Updates™

Improving Outcomes in Rheumatoid Arthritis

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

Guidelines

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

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

Consensus statement on blocking the effects of interleukin-6 and in particular by interleukin-6 receptor inhibition in rheumatoid arthritis and other inflammatory conditions

Smolen JS, et al. Ann Rheum Dis. 2013;72(4):482-492.

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

Smolen JS, et al. Ann Rheum Dis. 2014;73(3):492-509.

Treating rheumatoid arthritis to target: 2014 update of the recommendations of an international task force

Smolen JS, et al. Ann Rheum Dis. 2016;75(1):3-15.

Patient Resources

American College of Rheumatology Disease Overview

The American College of Rheumatology has published a concise overview to help patients and caregivers learn more about rheumatoid arthritis and provide tips for living well with this rheumatic disease. 

American College of Rheumatology Patient Education Videos

The American College of Rheumatology 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 a rheumatic disease.

Handout on Health: Rheumatoid Arthritis

A publication 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 this disease. 

Suggested Readings

Effect of interleukin-6 receptor blockade on surrogates of vascular risk in rheumatoid arthritis: MEASURE, a randomised, placebo-controlled study

McInnes IB, et al. Ann Rheum Dis. 2015;74(4):694-702.

IL-6 inhibitors for treatment of rheumatoid arthritis: past, present, and future

Kim GW, et al. Arch Pharm Res. 2015;38(5):575-584.

IL-6 targeting compared to TNF targeting in rheumatoid arthritis: studies of olokizumab, sarilumab and sirukumab

Tanaka Y, Martin Mola E. Ann Rheum Dis. 2014;73(9):1595-1597.

Measures of rheumatoid arthritis disease activity

Anderson JK, et al. Arthritis Care Res (Hoboken). 2011;63(suppl 11):S14-S36.

The pathogenesis of rheumatoid arthritis

McInnes IB, Schett G. N Engl J Med. 2011;365(23):2205-2219.

Sarilumab plus methotrexate in patients with active rheumatoid arthritis and inadequate response to methotrexate: Results of a phase III study

Genovese MC, et al. Arthritis Rheumatol. 2015;67(6):1424-1437.

Synovial phenotypes in rheumatoid arthritis correlate with response to biologic therapeutics

Dennis G Jr, et al. Arthritis Res Ther. 2014;16(2):R90.

Tocilizumab in early progressive rheumatoid arthritis: FUNCTION, a randomised controlled trial

Burmester GR, et al. Ann Rheum Dis. 2015.

Tocilizumab inhibits structural joint damage in rheumatoid arthritis patients with inadequate responses to methotrexate: results from the double-blind treatment phase of a randomized placebo-controlled trial of tocilizumab safety and prevention of structural joint damage at one year

Kremer JM, et al. Arthritis Rheum. 2011;63(3):609-621.

Tocilizumab monotherapy versus adalimumab monotherapy for treatment of rheumatoid arthritis (ADACTA): a randomised, double-blind, controlled phase 4 trial

Gabay C, et al. Lancet. 2013;381(9877):1541-1550.

Interactive Presentation

IL-6 in Rheumatoid Arthritis

From Pathophysiology to Individualized Therapy


Activity
Improving Outcomes in Rheumatoid Arthritis

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

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

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

JAKi in RA Practice

Unpacking the Evidence for Their Use Today and Tomorrow

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 19:49:24 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 '53268'
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 '/crura'
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 1634410675.5597
REQUEST_TIME 1634410675
Request Cookies
Session Attributes
Request GET Parameters
id '46'
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.018969s)

Connection ID: db (CDbConnection)

Driver mysql
Server Version 5.5.59-0ubuntu0.14.04.1
Uptime 17w 4d 1h 57m 19s
Threads 1
Questions 48195002
Slow queries 17
Opens 210
Flush tables 1
Open tables 176
Queries per second avg 4.532
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.003991 0.003991 0.003991 0.003991
UPDATE `users` SET `lastLogin`=:yp0 WHERE `users`.`id`=2540050
1 0.003398 0.003398 0.003398 0.003398
SHOW COLUMNS FROM `resources`
1 0.001496 0.001496 0.001496 0.001496
SHOW COLUMNS FROM `activities`
1 0.001302 0.001302 0.001302 0.001302
SHOW COLUMNS FROM `users`
1 0.001170 0.001170 0.001170 0.001170
SELECT * FROM `users` `t` WHERE session=:session LIMIT 1
2 0.001070 0.000535 0.000444 0.000626
SHOW COLUMNS FROM `interactions`
1 0.001017 0.001017 0.001017 0.001017
SHOW COLUMNS FROM `resource_videos`
1 0.000962 0.000962 0.000962 0.000962
SELECT * FROM `resources` `t` WHERE `t`.`id` IN (170, 169, 167, 164, 153, 149, 131, 127, 110, 98, 97, 95, 86, 82, 78, 77, 75, 67, 60, 58, 35, 28, 22, 5)
1 0.000682 0.000682 0.000682 0.000682
select id, status from activities where FIND_IN_SET(:shortAddress, shortAddress)
2 0.000591 0.000296 0.000273 0.000318
select id from resources where FIND_IN_SET(:shortAddress, shortAddress)
2 0.000511 0.000256 0.000255 0.000256
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.000412 0.000412 0.000412 0.000412
SHOW CREATE TABLE `resources`
1 0.000335 0.000335 0.000335 0.000335
SHOW CREATE TABLE `users`
1 0.000331 0.000331 0.000331 0.000331
SELECT * FROM `resources` `t` WHERE `t`.`id`=46 LIMIT 1
1 0.000304 0.000304 0.000304 0.000304
SHOW CREATE TABLE `activities`
1 0.000294 0.000294 0.000294 0.000294
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.000285 0.000285 0.000285 0.000285
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.000279 0.000279 0.000279 0.000279
SHOW CREATE TABLE `resource_videos`
1 0.000270 0.000270 0.000270 0.000270
SHOW CREATE TABLE `interactions`
1 0.000269 0.000269 0.000269 0.000269
# Query Time (s)
0
select id, status from activities where FIND_IN_SET(:shortAddress, shortAddress)
0.000318
1
select id from resources where FIND_IN_SET(:shortAddress, shortAddress)
0.000256
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.001496
5
SHOW CREATE TABLE `resources`
0.000335
6
SELECT * FROM `resources` `t` WHERE `t`.`id`=46 LIMIT 1
0.000304
7
SHOW COLUMNS FROM `resource_videos`
0.000962
8
SHOW CREATE TABLE `resource_videos`
0.000270
9
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.000279
10
SHOW COLUMNS FROM `interactions`
0.001017
11
SHOW CREATE TABLE `interactions`
0.000269
12
SHOW COLUMNS FROM `activities`
0.001302
13
SHOW CREATE TABLE `activities`
0.000294
14
SHOW COLUMNS FROM `users`
0.001170
15
SHOW CREATE TABLE `users`
0.000331
16
SELECT * FROM `users` `t` WHERE session=:session LIMIT 1
0.000626
17
INSERT INTO `users` (`role`, `sendEmails`, `sendSms`, `source`, `session`, `lastLogin`, `phone`, `createDate`) VALUES (:yp0, :yp1, :yp2, :yp3, :yp4, :yp5, :yp6, :yp7)
0.003991
18
SELECT * FROM `users` `t` WHERE session=:session LIMIT 1
0.000444
19
UPDATE `users` SET `lastLogin`=:yp0 WHERE `users`.`id`=2540050
0.003398
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.000412
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.000285
22
SELECT * FROM `resources` `t` WHERE `t`.`id` IN (170, 169, 167, 164, 153, 149, 131, 127, 110, 98, 97, 95, 86, 82, 78, 77, 75, 67, 60, 58, 35, 28, 22, 5)
0.000682
Log Messages
Message (details) Level Category Time