Image
Point of Care

A Better Look at Rheumatoid Arthritis

Using Imaging to Improve Patient Outcomes

Guidelines

2010 Rheumatoid arthritis classification criteria: an American College of Rheumatology/European League Against Rheumatism collaborative initiative.

Aletaha D, et al. Arthritis Rheum. 2010;62(9):2569-2581.

Rheumatoid Arthritis Disease Activity Measures: American College of Rheumatology recommendations for use in clinical practice.

Anderson J, et al. Arthritis Care Res (Hoboken). 2012;64(5):640-647.

Recommendations of the ESSR Arthritis Subcommittee on Ultrasonography in Inflammatory Joint Disease.

Plagou A, et al. Semin Musculoskelet Radiol. 2016;20(5):496-506.

American College of Rheumatology report on reasonable use of musculoskeletal ultrasonography in rheumatology clinical practice.

McAlindon T, et al. Arthritis Care Res (Hoboken). 2012;64(11):1625-1640.

Patient and Provider 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 to 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 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.

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

Rheumatoid Arthritis Support Network

The Rheumatoid Arthritis Support Network provides up-to-date information for patients with rheumatoid arthritis, including links to patient support groups, blogs written by patients with rheumatoid arthritis, resources to help pay for medications, and smart device apps to help track symptoms over time.

American College of Rheumatology Musculoskeletal Ultrasound Certification in Rheumatology

The American College of Rheumatology offers certification to individual physicians, physician assistants, and nurse practitioners who perform musculoskeletal ultrasound as part of their practice of rheumatology.

Suggested Readings

From a formal training program in musculoskeletal ultrasound (MSUS) to a high reproducibility for Doppler ultrasound in rheumatoid arthritis.

Villota O, et al. Curr Rheumatol Rev. July 2017.[Epub ahead of print.]

Rheumatoid arthritis revisited—advanced imaging review.

Vyas S, et al. Pol J Radiol. 2016;81:629-635.

Role of ultrasound in assessing remission in rheumatoid arthritis.

Ben Abdelghani K, et al. Diagn Interv Imaging. 2015;96(1):3-10.

Cytokine disturbances in systemic lupus erythematosus

Jacob N, Stohl W. Arthritis Res Ther. 2011;13:228.

Prevalence of ultrasound-detected residual synovitis and risk of relapse and structural progression in rheumatoid arthritis patients in clinical remission: a systematic review and meta-analysis.

Garrigues F, et al. Joint Bone Spine. 2013;80(6):597-603.

Role of ultrasonography in diagnosing early rheumatoid arthritis and remission of rheumatoid arthritis—a systematic review of the literature.

Ten Cate DF, et al. Arthritis Res Ther. 2013;15(1):R4.

Reliability of ultrasonography to detect synovitis in rheumatoid arthritis: a systematic literature review of 35 studies (1,415 patients).

Cheung PP, et al. Arthritis Care Res (Hoboken). 2010;62(3):323-334.

MRI-detected subclinical joint inflammation is associated with radiographic progression.

Krabben A, et al. Ann Rheum Dis. 2014;73(11):2034-2037.

Biomarkers to guide clinical therapeutics in rheumatology?

Robinson WH, Mao R. Curr Opin Rheumatol. 2016;28(2):168-175.

Quantitative power Doppler ultrasound measures of peripheral joint synovitis in poor prognosis early rheumatoid arthritis predict radiographic progression.

Sreerangaiah D, et al. Rheumatology (Oxford). 2016;55(1):89-93.

Ultrasound-guided synovial biopsy: a safe, well-tolerated and reliable technique for obtaining high-quality synovial tissue from both large and small joints in early arthritis patients.

Kelly S, et al. Ann Rheum Dis. 2015;74(3):611-617.

Intramuscular versus ultrasound-guided intratenosynovial glucocorticoid injection for tenosynovitis in patients with rheumatoid arthritis: a randomised, double-blind, controlled study.

Ammitzbøll-Danielsen M, et al. Ann Rheum Dis. 2017;76(4):666-672.

Clinical and ultrasound-based composite disease activity indices in rheumatoid arthritis: results from a multicenter, randomized study.

Mandl P, et al. Arthritis Care Res (Hoboken). 2013;65(6):879-887.

A systematic literature review analysis of ultrasound joint count and scoring systems to assess synovitis in rheumatoid arthritis according to the OMERACT filter.

Mandl P, et al. J Rheumatol. 2011;38(9):2055-2062.

Summary findings of a systematic literature review of the ultrasound assessment of bone erosions in rheumatoid arthritis.

Szkudlarek M, et al. J Rheumatol. 2017;44(1):130.

Musculoskeletal ultrasound training and competency assessment program for rheumatology fellows.

Kissin EY, et al. J Ultrasound Med. 2013;32(10):1735-1743.

Optimisation of a treat-to-target approach in rheumatoid arthritis: strategies for the 3-month time point.

Aletaha D, et al. Ann Rheum Dis. 2016;75(8):1479-1485.

Increased prevalence and severity of radiographic hand osteoarthritis in patients with HIV-1 infection associated with metabolic syndrome: data from the cross-sectional METAFIB-OA study.

Tomi A, et al. Ann Rheum Dis. 2016;75(12):2101-2107.

Imaging in rheumatoid arthritis.

Tan YK, Conaghan PG. Best Pract Res Clin Rheumatol. 2011;25(4):569-584.

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

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:30:58 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 '48000'
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 '/raresources18'
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 1634409609.8034
REQUEST_TIME 1634409609
Request Cookies
Session Attributes
Request GET Parameters
id '82'
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 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 (21/0.023519s)

Connection ID: db (CDbConnection)

Driver mysql
Server Version 5.5.59-0ubuntu0.14.04.1
Uptime 17w 4d 1h 39m 33s
Threads 1
Questions 48193745
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.003820 0.003820 0.003820 0.003820
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.003239 0.003239 0.003239 0.003239
UPDATE `users` SET `lastLogin`=:yp0 WHERE `users`.`id`=2540011
1 0.002918 0.002918 0.002918 0.002918
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.001708 0.001708 0.001708 0.001708
SHOW COLUMNS FROM `resources`
1 0.001503 0.001503 0.001503 0.001503
SHOW COLUMNS FROM `activities`
1 0.001312 0.001312 0.001312 0.001312
SELECT * FROM `resources` `t` WHERE `t`.`id` IN (170, 169, 167, 164, 153, 149, 131, 127, 110, 98, 97, 95, 86, 78, 77, 75, 67, 60, 58, 46, 35, 28, 22, 5)
1 0.001289 0.001289 0.001289 0.001289
select id, status from activities where FIND_IN_SET(:shortAddress, shortAddress)
2 0.001186 0.000593 0.000294 0.000892
SHOW COLUMNS FROM `users`
1 0.001179 0.001179 0.001179 0.001179
SHOW COLUMNS FROM `resource_videos`
1 0.001084 0.001084 0.001084 0.001084
SELECT * FROM `users` `t` WHERE session=:session LIMIT 1
2 0.001078 0.000539 0.000487 0.000591
select id from resources where FIND_IN_SET(:shortAddress, shortAddress)
2 0.000849 0.000425 0.000249 0.000600
SELECT * FROM `resources` `t` WHERE `t`.`id`=82 LIMIT 1
1 0.000580 0.000580 0.000580 0.000580
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.000565 0.000565 0.000565 0.000565
SHOW CREATE TABLE `resources`
1 0.000345 0.000345 0.000345 0.000345
SHOW CREATE TABLE `users`
1 0.000295 0.000295 0.000295 0.000295
SHOW CREATE TABLE `activities`
1 0.000295 0.000295 0.000295 0.000295
SHOW CREATE TABLE `resource_videos`
1 0.000274 0.000274 0.000274 0.000274
# Query Time (s)
0
select id, status from activities where FIND_IN_SET(:shortAddress, shortAddress)
0.000892
1
select id from resources where FIND_IN_SET(:shortAddress, shortAddress)
0.000600
2
select id, status from activities where FIND_IN_SET(:shortAddress, shortAddress)
0.000294
3
select id from resources where FIND_IN_SET(:shortAddress, shortAddress)
0.000249
4
SHOW COLUMNS FROM `resources`
0.001503
5
SHOW CREATE TABLE `resources`
0.000345
6
SELECT * FROM `resources` `t` WHERE `t`.`id`=82 LIMIT 1
0.000580
7
SHOW COLUMNS FROM `resource_videos`
0.001084
8
SHOW CREATE TABLE `resource_videos`
0.000274
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.000565
10
SHOW COLUMNS FROM `activities`
0.001312
11
SHOW CREATE TABLE `activities`
0.000295
12
SHOW COLUMNS FROM `users`
0.001179
13
SHOW CREATE TABLE `users`
0.000295
14
SELECT * FROM `users` `t` WHERE session=:session LIMIT 1
0.000591
15
INSERT INTO `users` (`role`, `sendEmails`, `sendSms`, `source`, `session`, `lastLogin`, `phone`, `createDate`) VALUES (:yp0, :yp1, :yp2, :yp3, :yp4, :yp5, :yp6, :yp7)
0.003820
16
SELECT * FROM `users` `t` WHERE session=:session LIMIT 1
0.000487
17
UPDATE `users` SET `lastLogin`=:yp0 WHERE `users`.`id`=2540011
0.002918
18
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.001708
19
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.003239
20
SELECT * FROM `resources` `t` WHERE `t`.`id` IN (170, 169, 167, 164, 153, 149, 131, 127, 110, 98, 97, 95, 86, 78, 77, 75, 67, 60, 58, 46, 35, 28, 22, 5)
0.001289
Log Messages
Message (details) Level Category Time