Image
Interactive Exchange

Clinical Updates in Systemic Lupus Erythematosus

Improved Diagnostic and Management Strategies

Meeting Slides

Guidelines

The 1982 revised criteria for the classification of systemic lupus erythematosus

These guideline statements revise the original criteria from 1971 on the classification of systemic lupus erythematosus.
Tan EM, et al. Arthritis Rheum. 1982;25:1271-1277.

American College of Rheumatology guidelines for screening, treatment, and management of lupus nephritis.

ACR-recommended management strategies for lupus nephritis in adults, based on interventions that were available in the United States as of April 2011.
Hahn BH, et al. Arthritis Care Res (Hoboken). 2012;64:797-808.

Derivation and validation of the Systemic Lupus International Collaborating Clinics classification criteria for systemic lupus erythematosus

The SLICC updated and validated the 1997 revision of the ACR criteria. The classification criteria were expanded to 17, including clinical and immunologic subsets. A positive classification of SLE requires the appearance of 4 of the criteria with at least 1 clinical and 1 immunologic item.
Petri M, et al. Arthritis Rheum. 2012;64:2677-2686.

EULAR recommendations for the management of systemic lupus erythematosus. Report of a Task Force of the EULAR Standing Committee for International Clinical Studies Including Therapeutics

12 key recommendations from a EULAR task force on the diagnosis, management, and monitoring of SLE.
Bertsias G, et al. Ann Rheum Dis. 2008;67:195-205.

Tools

Systemic Lupus Erythematosus Responder Index

The evidence-based SLE Responder Index measures improvement in specific organs and overall disease activity. It is a composite of the Systemic Lupus Erythematosis Disease Activity Index, Physician’s Global Assessment, and the British Isles Lupus Assessment Group.
Furie RA, et al. Arthritis Rheum. 2009;61:1143-1151.

Patient Materials

The Lupus Companion

A free app to help people with lupus keep track of their medications, appointments, and symptoms. The Lupus Companion was developed as part of the Lupus Initiative, a program to educate healthcare professionals about diagnosing and treating lupus.

What You Should Know About Lupus

An educational brochure for patients with SLE from the S.L.E. Lupus Foundation. The pamphlet contains useful facts on disease, treatment, diagnosis, and outcomes.

Suggested Readings

Developments in the clinical understanding of lupus

Crow MK. Arthritis Res Ther. 2009;11:245.

Updating the American College of Rheumatology revised criteria for the classification of systemic lupus erythematosus

Hochberg MC. Arthritis Rheum. 1997;40:1725.

Autoantibody-dependent and autoantibody-independent roles for B cells in systemic lupus erythematosus: past, present, and future

Jacob N, Stohl W. Autoimmunity. 2010;43:84-97.

Cytokine disturbances in systemic lupus erythematosus

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

Novel therapeutic agents in clinical development for systemic lupus erythematosus

Jordan N, et al. BMC Med. 2013;11:120.

Unmet medical needs in systemic lupus erythematosus

Lateef A, Petri M. Arthritis Res Ther. 2012;14:S4.

European League Against Rheumatism recommendations for monitoring patients with systemic lupus erythematosus in clinical practice and in observational studies

Mosca M, et al. Ann Rheum Dis. 2010;69:1269-1274.

Clinical associations of the metabolic syndrome in systemic lupus erythematosus: data from an international inception cohort

Parker B, et al. Ann Rheum Dis. 2013;72:1308-1314.

Monitoring systemic lupus erythematosus in standard clinical care

Petri M. Best Pract Res Clin Rheumatol. 2007;21:687-697.

Biologic differences between various inhibitors of the BLyS/BAFF pathway: should we expect differences between Belimumab and other inhibitors in development?

Stohl W. Curr Rheumatol Rep. 2012;14:303-309.

Systemic lupus erythematosus

Tsokos GJ. N Engl J Med. 2011;365:2110-2121.

Interactive Presentation

Scientific and Clinical Insights Into the Pathophysiology of Systemic Lupus Erythematosus

William Stohl, MD, PhD


Activity
Clinical Updates In Systemic Lupus Erythematosus

Improved Diagnostic and Management Strategies

Relevant Resources

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

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 17:53:32 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 '33312'
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 '/lupusresources'
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 1634404163.9643
REQUEST_TIME 1634404163
Request Cookies
Session Attributes
Request GET Parameters
id '5'
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.023924s)

Connection ID: db (CDbConnection)

Driver mysql
Server Version 5.5.59-0ubuntu0.14.04.1
Uptime 17w 4d 0h 8m 48s
Threads 1
Questions 48170939
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.003836 0.003836 0.003836 0.003836
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.003108 0.003108 0.003108 0.003108
UPDATE `users` SET `lastLogin`=:yp0 WHERE `users`.`id`=2539519
1 0.002794 0.002794 0.002794 0.002794
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.001631 0.001631 0.001631 0.001631
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, 46, 35, 28, 22)
1 0.001490 0.001490 0.001490 0.001490
SHOW COLUMNS FROM `resources`
1 0.001396 0.001396 0.001396 0.001396
SHOW COLUMNS FROM `activities`
1 0.001237 0.001237 0.001237 0.001237
SHOW COLUMNS FROM `users`
1 0.001225 0.001225 0.001225 0.001225
select id, status from activities where FIND_IN_SET(:shortAddress, shortAddress)
2 0.001143 0.000571 0.000269 0.000874
SHOW COLUMNS FROM `resource_videos`
1 0.000996 0.000996 0.000996 0.000996
SHOW COLUMNS FROM `interactions`
1 0.000988 0.000988 0.000988 0.000988
SELECT * FROM `users` `t` WHERE session=:session LIMIT 1
2 0.000948 0.000474 0.000456 0.000492
select id from resources where FIND_IN_SET(:shortAddress, shortAddress)
2 0.000842 0.000421 0.000247 0.000595
SELECT * FROM `resources` `t` WHERE `t`.`id`=5 LIMIT 1
1 0.000546 0.000546 0.000546 0.000546
SHOW CREATE TABLE `users`
1 0.000345 0.000345 0.000345 0.000345
SHOW CREATE TABLE `resources`
1 0.000331 0.000331 0.000331 0.000331
SHOW CREATE TABLE `activities`
1 0.000285 0.000285 0.000285 0.000285
SHOW CREATE TABLE `interactions`
1 0.000272 0.000272 0.000272 0.000272
SHOW CREATE TABLE `resource_videos`
1 0.000260 0.000260 0.000260 0.000260
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.000251 0.000251 0.000251 0.000251
# Query Time (s)
0
select id, status from activities where FIND_IN_SET(:shortAddress, shortAddress)
0.000874
1
select id from resources where FIND_IN_SET(:shortAddress, shortAddress)
0.000595
2
select id, status from activities where FIND_IN_SET(:shortAddress, shortAddress)
0.000269
3
select id from resources where FIND_IN_SET(:shortAddress, shortAddress)
0.000247
4
SHOW COLUMNS FROM `resources`
0.001396
5
SHOW CREATE TABLE `resources`
0.000331
6
SELECT * FROM `resources` `t` WHERE `t`.`id`=5 LIMIT 1
0.000546
7
SHOW COLUMNS FROM `interactions`
0.000988
8
SHOW CREATE TABLE `interactions`
0.000272
9
SHOW COLUMNS FROM `resource_videos`
0.000996
10
SHOW CREATE TABLE `resource_videos`
0.000260
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.000251
12
SHOW COLUMNS FROM `activities`
0.001237
13
SHOW CREATE TABLE `activities`
0.000285
14
SHOW COLUMNS FROM `users`
0.001225
15
SHOW CREATE TABLE `users`
0.000345
16
SELECT * FROM `users` `t` WHERE session=:session LIMIT 1
0.000456
17
INSERT INTO `users` (`role`, `sendEmails`, `sendSms`, `source`, `session`, `lastLogin`, `phone`, `createDate`) VALUES (:yp0, :yp1, :yp2, :yp3, :yp4, :yp5, :yp6, :yp7)
0.003836
18
SELECT * FROM `users` `t` WHERE session=:session LIMIT 1
0.000492
19
UPDATE `users` SET `lastLogin`=:yp0 WHERE `users`.`id`=2539519
0.002794
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.001631
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.003108
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, 46, 35, 28, 22)
0.001490
Log Messages
Message (details) Level Category Time