Image
Interactive Exchange

Caring For Patients With Chronic Pain

Responsible Opioid Prescribing to Achieve Individualized Functional Goals

Meeting Slides

Clinical Tools

Brief Pain Inventory (Short Form)

A multidimensional pain assessment instrument that can be used to characterize several aspects of a patient’s pain experience, the short form is also widely used for clinical trials and has been translated into multiple languages.

Opioid Risk Tool

This five-question clinical interview or patient questionnaire helps stratify patients based on their risk for opioid-related misuse and abuse.

Current Opioid Misuse Measure (COMM)®

A 17-item assessment questionnaire, the COMM focuses on current behaviors and cognition rather than character and personality traits associated with risks for substance abuse.

Pain Assessment and Documentation Tool (PADT™)

Completed via clinician-directed interview, this instrument provides a consistent and structured method to document progress with opioid therapy over time.

Guidelines

American Pain Society and American Academy of Pain Medicine: Clinical guidelines for the use of chronic opioid therapy in chronic noncancer pain

Chou R, Fanciullo GJ, Fine PG, et al. J Pain. 2009;10(2):113-130.

Department of Veterans Affairs and Department of Defense: Clinical Practice Guideline for Management of Opioid Therapy for Chronic Pain

The Management of Opioid Therapy for Chronic Pain Working Group. Washington, DC: Department of Veterans Affairs, Department of Defense; 2010.

Other Resources

A Clinical Guide to Opioid Analgesia. 2nd edition

Fine PG, Portenoy RK. New York, NY: Vendome Group, LLC; 2007.

Responsible Opioid Prescribing: A Clinician’s Guide. 2nd edition, revised and expanded

Fishman SM. Washington, DC: Waterford Life Sciences; 2012.

Suggested Readings

Abuse rates and routes of administration of reformulated extended-release oxycodone: initial findings from a sentinel surveillance sample of individuals assessed for substance abuse treatment

Butler SF, Cassidy TA, Chilcoat H, et al. J Pain. 2013;14(4):351-358.

Establishing "best practices" for opioid rotation: conclusions of an expert panel

Fine PG, Portenoy RK; Ad Hoc Expert Panel on Evidence Review and Guidelines for Opioid Rotation. J Pain Symptom Manage. 2009;38(3):418-425.

Universal precautions in pain medicine: a rational approach to the treatment of chronic pain

Gourlay DL, Heit HA, Almahrezi A. Pain Med. 2005;6(2):107-112.

Urine drug testing in pain medicine

Heit HA, Gourlay DL. J Pain Symptom Manage. 2004;27(3):260-267.

Substance misuse treatment for high-risk chronic pain patients on opioid therapy: a randomized trial

Jamison RN, Ross EL, Michna E, et al. Pain. 2010;150(3):390-400.

Assessment and treatment of abuse risk in opioid prescribing for chronic pain

Jamison RN, Serraillier J, Michna E. Pain Res Treat. 2011;2011:941808.

A review of abuse-deterrent opioids for chronic nonmalignant pain

Moorman-Li R, Motycka CA, Inge LD, et al. P T. 2012;37(7):412-418.

Abuse-deterrent formulations, an evolving technology against the abuse and misuse of opioid analgesics

Schaeffer T. J Med Toxicol. 2012;8(4):400-407.

Interactive Presentation

Long-term Opioid Therapy for Chronic Pain

Michael J. Brennan, MD


Activity
Caring for Patients With Chronic Pain

Responsible Opioid Prescribing to Achieve Individualized Functional Goals

Relevant Resources

Persistent and Breakthrough Pain

Balancing the Benefits and Risk of Opioid-Based Therapy

Improving the Care of Patients With Chronic Pain

Individualized Assessment and Mechanism-Based Multimodal Treatment

Acute Management of Migraine Attacks

Overcoming Pain and Gastrointestinal Distress to Improve Patient Outcomes

Opioid-Induced Constipation

Proactive Diagnosis and Targeted Management

Intrathecal Drug Delivery for Chronic Pain

Selecting Patients and Optimizing Long-Term Outcomes

Opioid-Induced Constipation

Proactive Diagnosis and Targeted Management

Clinical Issues in Chronic Pain

Consensus and Controversies for Responsible Opioid Prescribing

Intrathecal Drug Delivery for Chronic Pain

The Role of Nurses in Optimizing Long-term Outcomes

Intrathecal Drug Therapy for Chronic Pain

Evolving Best-Practice Strategies to Maximize Efficacy and Safety

Comprehensive Chronic Pain Management

A Focus on Patients With Opioid-Induced Constipation

Best Practices in Intrathecal Therapy for Chronic Pain

Patient Selection, Treatment Initiation, and Ongoing Monitoring

Overcoming Challenges in Cancer Pain Management

Engaging With Patients About Opioid-Induced Constipation

Can You Spot Axial Spondyloarthritis?

The PCP’s Role in Timely Recognition and Referral

Clinical Issues in Chronic Pain

Debates and Discussions About Therapeutically Targeting Nerve Growth Factor Signaling

Comprehensive Relief from Cancer Pain

Expanding the Conversation on Opioid-Induced Constipation

Managing Opioid-Induced Constipation

Translating Guidelines Into Patient Care

Finding Relief in Osteoarthritis

New Paths to Chronic Pain Management

What’s New in Systemic Lupus Erythematosus?

Unlocking Novel Paths to Patient Care

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 'Tue, 09 Mar 2021 00:28:30 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 '44960'
REMOTE_ADDR '3.215.177.171'
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 '/cp2014'
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 1632352779.9429
REQUEST_TIME 1632352779
Request Cookies
Session Attributes
Request GET Parameters
id '17'
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.024653s)

Connection ID: db (CDbConnection)

Driver mysql
Server Version 5.5.59-0ubuntu0.14.04.1
Uptime 14w 1d 6h 19m 3s
Threads 1
Questions 40790927
Slow queries 13
Opens 195
Flush tables 1
Open tables 167
Queries per second avg 4.756
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.003785 0.003785 0.003785 0.003785
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.003376 0.003376 0.003376 0.003376
UPDATE `users` SET `lastLogin`=:yp0 WHERE `users`.`id`=2491847
1 0.002781 0.002781 0.002781 0.002781
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.001578 0.001578 0.001578 0.001578
SHOW COLUMNS FROM `resources`
1 0.001508 0.001508 0.001508 0.001508
SELECT * FROM `resources` `t` WHERE `t`.`id` IN (149, 145, 111, 94, 83, 69, 61, 59, 55, 44, 41, 40, 39, 36, 31, 26, 25, 23, 21, 12, 10, 7)
1 0.001488 0.001488 0.001488 0.001488
SHOW COLUMNS FROM `activities`
1 0.001265 0.001265 0.001265 0.001265
select id, status from activities where FIND_IN_SET(:shortAddress, shortAddress)
2 0.001249 0.000625 0.000276 0.000973
SHOW COLUMNS FROM `users`
1 0.001200 0.001200 0.001200 0.001200
SHOW COLUMNS FROM `interactions`
1 0.001027 0.001027 0.001027 0.001027
SHOW COLUMNS FROM `resource_videos`
1 0.001000 0.001000 0.001000 0.001000
SELECT * FROM `users` `t` WHERE session=:session LIMIT 1
2 0.000898 0.000449 0.000448 0.000450
select id from resources where FIND_IN_SET(:shortAddress, shortAddress)
2 0.000859 0.000430 0.000253 0.000606
SELECT * FROM `resources` `t` WHERE `t`.`id`=17 LIMIT 1
1 0.000510 0.000510 0.000510 0.000510
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.000484 0.000484 0.000484 0.000484
SHOW CREATE TABLE `activities`
1 0.000382 0.000382 0.000382 0.000382
SHOW CREATE TABLE `resources`
1 0.000335 0.000335 0.000335 0.000335
SHOW CREATE TABLE `users`
1 0.000328 0.000328 0.000328 0.000328
SHOW CREATE TABLE `interactions`
1 0.000305 0.000305 0.000305 0.000305
SHOW CREATE TABLE `resource_videos`
1 0.000296 0.000296 0.000296 0.000296
# Query Time (s)
0
select id, status from activities where FIND_IN_SET(:shortAddress, shortAddress)
0.000973
1
select id from resources where FIND_IN_SET(:shortAddress, shortAddress)
0.000606
2
select id, status from activities where FIND_IN_SET(:shortAddress, shortAddress)
0.000276
3
select id from resources where FIND_IN_SET(:shortAddress, shortAddress)
0.000253
4
SHOW COLUMNS FROM `resources`
0.001508
5
SHOW CREATE TABLE `resources`
0.000335
6
SELECT * FROM `resources` `t` WHERE `t`.`id`=17 LIMIT 1
0.000510
7
SHOW COLUMNS FROM `interactions`
0.001027
8
SHOW CREATE TABLE `interactions`
0.000305
9
SHOW COLUMNS FROM `resource_videos`
0.001000
10
SHOW CREATE TABLE `resource_videos`
0.000296
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.000484
12
SHOW COLUMNS FROM `activities`
0.001265
13
SHOW CREATE TABLE `activities`
0.000382
14
SHOW COLUMNS FROM `users`
0.001200
15
SHOW CREATE TABLE `users`
0.000328
16
SELECT * FROM `users` `t` WHERE session=:session LIMIT 1
0.000450
17
INSERT INTO `users` (`role`, `sendEmails`, `sendSms`, `source`, `session`, `lastLogin`, `phone`, `createDate`) VALUES (:yp0, :yp1, :yp2, :yp3, :yp4, :yp5, :yp6, :yp7)
0.003785
18
SELECT * FROM `users` `t` WHERE session=:session LIMIT 1
0.000448
19
UPDATE `users` SET `lastLogin`=:yp0 WHERE `users`.`id`=2491847
0.002781
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.001578
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.003376
22
SELECT * FROM `resources` `t` WHERE `t`.`id` IN (149, 145, 111, 94, 83, 69, 61, 59, 55, 44, 41, 40, 39, 36, 31, 26, 25, 23, 21, 12, 10, 7)
0.001488
Log Messages
Message (details) Level Category Time