Image
Evidence-Based Best Practices

Clinical Updates on the Management of Gout

Evidence-Based Strategies for Improved Patient Outcomes

Meeting Slides

Clinical Tools

2012 American College of Rheumatology guidelines for management of gout. Part 1: systematic nonpharmacologic and pharmacologic therapeutic approaches to hyperuricemia.

Khanna D, et al. Arthritis Care Res (Hoboken). 2012;64(10):1431-1446.

2012 American College of Rheumatology guidelines for management of gout. Part 2: therapy and antiinflammatory prophylaxis of acute gouty arthritis.

Khanna D, et al. Arthritis Care Res (Hoboken). 2012;64(10):1447-1461.

Evolution of management of gout: a comparison of recent guidelines

Khanna PP, FitzGerald J. Curr Opin Rheumatol. 2015;27(2):139-146.

Educational Materials for Patients and Their Families

What Is Gout? Fast Facts: An Easy-to-Read Series of Publications for the Public

A brochure in simplified language from the National Institute of Arthritis and Musculoskeletal and Skin Diseases, National Institutes of Health

Gout

Patient brochure from the American Colllege of Rheumatology

Gout Education for Patients

Patient information from the Gout & Uric Acid Education Society

Suggested Readings

The Emerging Role of Biotechnological Drugs in the Treatment of Gout.

Cavagna L, Taylor WJ. BioMed Res Int. 2014. doi: 10.1155/2014/264859. Epub 2014 Apr 16.

Imaging in gout: a review of the recent developments.

Chowalloor PV, et al. Ther Adv Musculoskelet Dis. 2014;6(4):131-143.

New medications in development for the treatment of hyperuricemia of gout.

Diaz-Torné C, et al. Curr Opin Rheumatol. 2015;27(2):164-169.

Pharmacodynamic, pharmacokinetic and tolerability evaluation of concomitant administration of lesinurad and febuxostat in gout patients with hyperuricaemia.

Fleischmann R, et al. Rheumatology. 2014;53(12):2167-2174.

The pathophysiology of hyperuricaemia and its possible relationship to cardiovascular disease, morbidity and mortality.

Gustafsson D, Unwin R. BMC Nephrology. 2013;14:164.

Emerging therapies for gout.

Edwards NL, So A. Rheum Dis Clin North Am. 2014;40(2):375-387.

The association of gout with socioeconomic status in primary care: a cross-sectional observational study.

Hayward RA, et al. Rheumatology (Oxford). 2013;52(11):2004-2008.

The crystallization of monosodium urate.

Martillo MA, et al. Curr Rheumatol Rep. 2014;16(2):400. doi:10.1007/s11926-013-0400-9.

Racial and gender disparities in patients with gout.

Singh JA. Curr Rheumatol Rep. 2013;15(2):307. doi:10.1007/s11926-012-0307-x.

Gout and its comorbidities: implications for therapy.

Stamp LK, Chapman PT. Rheumatology (Oxford). 2013;52(1):34-44.

Improved health-related quality of life and physical function in patients with refractory chronic gout following treatment with pegloticase: evidence from phase III randomized controlled trials.

Strand V, et al. J Rheumatol. 2012;39(7):1450-1457.

Recent advances in management of gout.

Suresh E, Das P. QJM. 2012;105(5):407-417.

 

Interactive Presentation

Clinical Updates on the Management of Gout

Michael H. Pillinger, MD


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

Acute Management of Migraine Attacks

Overcoming Pain and Gastrointestinal Distress to Improve Patient Outcomes

Opioid-Induced Constipation

Proactive Diagnosis and Targeted Management

Chronic Obstructive Pulmonary Disease, Asthma, or Both

Differential Diagnosis and Comprehensive Management Strategies

Improving Outcomes in Chronic Obstructive Pulmonary Disease

Optimizing Maintenance Therapy Across Healthcare Settings

Managing Gout in Primary Care

Evolving Strategies for Diagnosis and Long-Term Management

Clinical Issues in Chronic Pain

Consensus and Controversies for Responsible Opioid Prescribing

Noninsulin Approaches to Managing Type 2 Diabetes

Best Practices in Combination Therapy

Hitting the Target in Type 2 Diabetes

Evolving Approaches to Insulin Based Therapy

Improving Outcomes in Rheumatoid Arthritis

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

Clearing the Air

Improving Outcomes for Patients with COPD

Clinical Updates in Type 2 Diabetes

New Strategies for Insulin Replacement Therapy

How Low Do You Go?

Clinical Updates in LDL-C Management

Incretin-Based Therapies For Type 2 Diabetes

Improving Comprehensive Patient Care

Improving Outcomes in Non–24-Hour Sleep-Wake Disorder

Identifying Patients and Tailoring Therapy

Comprehensive Management of Chronic Obstructive Pulmonary Disease

Collaborative Approaches to Guideline-Concordant Patient Care

Clinical Updates in the Management of Severe Asthma

New Strategies for Individualizing Long-term Care

Comprehensive Chronic Pain Management

A Focus on Patients With Opioid-Induced Constipation

Clinical Issues in Bipolar Depression

Consensus and Controversies Across the Spectrum of Patient Presentations

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

Caring for Patients with Severe Asthma

Evolving Best Practices to Optimize Outcomes

Looking Beneath The Surface In Atopic Dermatitis

Targeting Immune Dysregulation and Delivering Comprehensive Care

Can You Spot Axial Spondyloarthritis?

The PCP’s Role in Timely Recognition and Referral

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

Advancing the Care of Severe Asthma

Differential Diagnosis, Multidisciplinary Management, and Patient Engagement

Updates in HCV Screening and Treatment

Key Issues Impacting OB/GYN Practice

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

Evolving Models of HIV Care

Volume II: Expanding Evidence for the Role of Rapid ART Initiation in HIV Practice

Clinical Issues in Rheumatoid Arthritis

Debates & Discussions on the Evolving Role of JAK Inhibitors

Clearing the Air in Severe Asthma Management

Improving Patient Outcomes Through Shared Clinical Decision Making

GLP-1 Receptors Agonists in Type 2 Diabetes

Mechanistic Insights and Evolving Treatment Options

Clinical Issues in Rheumatoid Arthritis

The Evolving Role of JAK Inhibitors

JAKi in RA Practice

Unpacking the Evidence for Their Use Today and Tomorrow

Airing It Out

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

COPD in Managed Care

The Clinical and Utilization Benefits of Exacerbation Prevention

Assimilating the Evidence in T2DM

Cardiovascular and Renal Outcomes With SGLT2 Inhibitors

Demystifying New Evidence for COPD Management

Best Practices for Primary Care

Finding Relief in Osteoarthritis

New Paths to Chronic Pain Management

The Changing Landscape of HIV Prevention

What the Pharmacist Needs to Know about PrEP

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

COPD Cases & Conversations

Preventing COPD Exacerbations to Improve Outcomes

Comprehensive Management in COPD

A Whole Patient Case Series

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:45:08 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 '43492'
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 '/goutpce'
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 1634406873.8651
REQUEST_TIME 1634406873
Request Cookies
Session Attributes
Request GET Parameters
id '28'
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 (23/0.031718s)

Connection ID: db (CDbConnection)

Driver mysql
Server Version 5.5.59-0ubuntu0.14.04.1
Uptime 17w 4d 0h 53m 57s
Threads 1
Questions 48190243
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)
SELECT * FROM `resources` `t` WHERE `t`.`id` IN (164, 153, 149, 58, 35, 178, 172, 170, 169, 167, 163, 154, 147, 144, 145, 143, 141, 140, 139, 137, 136, 132, 131, 127, 126, 122, 116, 114, 110, 107, 98, 97, 96, 95, 91, 90, 86, 82, 78, 77, 75, 69, 67, 62, 60, 56, 55, 54, 53, 52, 51, 50, 48, 47, 46, 42, 41, 40, 38, 36, 34, 32, 31, 23, 22, 5)
1 0.006644 0.006644 0.006644 0.006644
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.004021 0.004021 0.004021 0.004021
INSERT INTO `users` (`role`, `sendEmails`, `sendSms`, `source`, `session`, `lastLogin`, `phone`, `createDate`) VALUES (:yp0, :yp1, :yp2, :yp3, :yp4, :yp5, :yp6, :yp7)
1 0.003596 0.003596 0.003596 0.003596
SHOW COLUMNS FROM `resources`
1 0.003039 0.003039 0.003039 0.003039
UPDATE `users` SET `lastLogin`=:yp0 WHERE `users`.`id`=2539901
1 0.002804 0.002804 0.002804 0.002804
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.001676 0.001676 0.001676 0.001676
SHOW COLUMNS FROM `activities`
1 0.001294 0.001294 0.001294 0.001294
SHOW COLUMNS FROM `users`
1 0.001181 0.001181 0.001181 0.001181
select id, status from activities where FIND_IN_SET(:shortAddress, shortAddress)
2 0.001152 0.000576 0.000272 0.000880
SHOW COLUMNS FROM `interactions`
1 0.001080 0.001080 0.001080 0.001080
SHOW COLUMNS FROM `resource_videos`
1 0.000997 0.000997 0.000997 0.000997
SELECT * FROM `users` `t` WHERE session=:session LIMIT 1
2 0.000964 0.000482 0.000465 0.000499
select id from resources where FIND_IN_SET(:shortAddress, shortAddress)
2 0.000832 0.000416 0.000249 0.000583
SELECT * FROM `resources` `t` WHERE `t`.`id`=28 LIMIT 1
1 0.000483 0.000483 0.000483 0.000483
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.000462 0.000462 0.000462 0.000462
SHOW CREATE TABLE `resources`
1 0.000339 0.000339 0.000339 0.000339
SHOW CREATE TABLE `users`
1 0.000329 0.000329 0.000329 0.000329
SHOW CREATE TABLE `activities`
1 0.000289 0.000289 0.000289 0.000289
SHOW CREATE TABLE `interactions`
1 0.000274 0.000274 0.000274 0.000274
SHOW CREATE TABLE `resource_videos`
1 0.000261 0.000261 0.000261 0.000261
# Query Time (s)
0
select id, status from activities where FIND_IN_SET(:shortAddress, shortAddress)
0.000880
1
select id from resources where FIND_IN_SET(:shortAddress, shortAddress)
0.000583
2
select id, status from activities where FIND_IN_SET(:shortAddress, shortAddress)
0.000272
3
select id from resources where FIND_IN_SET(:shortAddress, shortAddress)
0.000249
4
SHOW COLUMNS FROM `resources`
0.003039
5
SHOW CREATE TABLE `resources`
0.000339
6
SELECT * FROM `resources` `t` WHERE `t`.`id`=28 LIMIT 1
0.000483
7
SHOW COLUMNS FROM `interactions`
0.001080
8
SHOW CREATE TABLE `interactions`
0.000274
9
SHOW COLUMNS FROM `resource_videos`
0.000997
10
SHOW CREATE TABLE `resource_videos`
0.000261
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.000462
12
SHOW COLUMNS FROM `activities`
0.001294
13
SHOW CREATE TABLE `activities`
0.000289
14
SHOW COLUMNS FROM `users`
0.001181
15
SHOW CREATE TABLE `users`
0.000329
16
SELECT * FROM `users` `t` WHERE session=:session LIMIT 1
0.000465
17
INSERT INTO `users` (`role`, `sendEmails`, `sendSms`, `source`, `session`, `lastLogin`, `phone`, `createDate`) VALUES (:yp0, :yp1, :yp2, :yp3, :yp4, :yp5, :yp6, :yp7)
0.003596
18
SELECT * FROM `users` `t` WHERE session=:session LIMIT 1
0.000499
19
UPDATE `users` SET `lastLogin`=:yp0 WHERE `users`.`id`=2539901
0.002804
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.001676
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.004021
22
SELECT * FROM `resources` `t` WHERE `t`.`id` IN (164, 153, 149, 58, 35, 178, 172, 170, 169, 167, 163, 154, 147, 144, 145, 143, 141, 140, 139, 137, 136, 132, 131, 127, 126, 122, 116, 114, 110, 107, 98, 97, 96, 95, 91, 90, 86, 82, 78, 77, 75, 69, 67, 62, 60, 56, 55, 54, 53, 52, 51, 50, 48, 47, 46, 42, 41, 40, 38, 36, 34, 32, 31, 23, 22, 5)
0.006644
Log Messages
Message (details) Level Category Time