Image
Interactive Exchange

Restoring Balance: Advances in the Management of Opioid-Induced Constipation

Meeting Slides

Clinical Tools

Bowel Function Index

The BFI provides a numerical assessment score for prior 7 days based on ease of defecation, feeling of incomplete evacuation, and personal judgment of constipation.

Patient Assessment of Constipation (PAC-SYM) 

This 12-item questionnaire of patient-reported symptoms assesses 3 subscales of symptoms (bowel movements, rectal symptoms, and abdominal symptoms) over the 2 prior weeks.

Bristol Stool Form Scale

This visual scale is used to classify the type of stools passed.

Patient Education Tool

This patient education tool list items that patients can do at home to help ease their opioid-induced constipation and includes a list of questions to ask the doctor or clinic about constipation.

Guidelines

The functional gastrointestinal disorders and the Rome III process, 2006.

Drossman DA. Gastroenterology. 2006;130:1377-1390.

Clinical guidelines for the use of chronic opioid therapy in chronic noncancer pain.

Chou R, et al. Pain. 2009;10(2):113-130.

Clinical practice guidelines: Management of Opioid Therapy for Chronic Pain, 2010

Department of Veterans Affairs. VA/DOD Clinical Practice Guideline for Management of Opioid Therapy for Chronic Pain.

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

Fecal incontinence in the elderly.

Leung FW, et al. Gastroenterol Clin North Am. 2009

Opioid-induced constipation in patients with chronic noncancer pain in the USA, Canada, Germany, and the UK: descriptive analysis of baseline patient-reported outcomes and retrospective chart review.

Coyne KS, et al. Clinicoecon Outcomes Res. 2014;6:269-281. 

Opioids in chronic non-cancer pain: systematic review of efficacy and safety.

Kalso E, et al. Pain. 2004;112(3):372-380

Constipation in people prescribed opioids.

Ahmedzai SH, Boland J. Clin Evid (Online). 2010;pii:2407

A multi-institutional study analyzing effect of prophylactic medication for prevention of opioid-induced gastrointestinal dysfunction.

Ishihara M, et al. Clin J Pain. 2012;28(5):373-381.

A volunteer model for the comparison of laxatives in opioid-related constipation.

Sykes NP. J Pain Symptom Manage. 1996;11(6):363-369.

A Randomized Study of Lubiprostone for Opioid-Induced Constipation in Patients with Chronic Noncancer Pain.

Cryer B, et al. Pain Med. 2014; Epublished ahead of print.

Naloxegol for opioid-induced constipation in patients with noncancer pain.

Chey WD, et al. N Engl J Med. 2014;370:2387-2396.

Patient preference with respect to QoL and reduction in opioid-induced constipation (OIC) after treatment with prolonged-release (PR) oxycodone/naloxone compared with previous analgesic therapy [PREFER study].

van Dongen VC, et al. Int J Clin Pract. 2014. Epublished ahead of print.

Interactive Presentation

Introduction to Opioid-Induced Constipation

Anthony Lembo, MD


Activity
Advances in the Management of Opioid-Induced Constipation

Restoring Balance

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

Caring For Patients With Chronic Pain

Responsible Opioid Prescribing to Achieve Individualized Functional Goals

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 'Mon, 02 Aug 2021 19:44:35 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 '50954'
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 '/oicaafp'
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 1634410425.9128
REQUEST_TIME 1634410425
Request Cookies
Session Attributes
Request GET Parameters
id '21'
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.062960s)

Connection ID: db (CDbConnection)

Driver mysql
Server Version 5.5.59-0ubuntu0.14.04.1
Uptime 17w 4d 1h 53m 10s
Threads 1
Questions 48194540
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.008058 0.008058 0.008058 0.008058
select id, status from activities where FIND_IN_SET(:shortAddress, shortAddress)
2 0.007703 0.003852 0.002887 0.004816
UPDATE `users` SET `lastLogin`=:yp0 WHERE `users`.`id`=2540037
1 0.006398 0.006398 0.006398 0.006398
SELECT * FROM `users` `t` WHERE session=:session LIMIT 1
2 0.005121 0.002560 0.000510 0.004611
SHOW COLUMNS FROM `interactions`
1 0.004810 0.004810 0.004810 0.004810
SHOW CREATE TABLE `resources`
1 0.004306 0.004306 0.004306 0.004306
SHOW CREATE TABLE `users`
1 0.004301 0.004301 0.004301 0.004301
SHOW CREATE TABLE `activities`
1 0.004300 0.004300 0.004300 0.004300
SHOW CREATE TABLE `resource_videos`
1 0.004291 0.004291 0.004291 0.004291
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.003092 0.003092 0.003092 0.003092
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.001741 0.001741 0.001741 0.001741
SHOW COLUMNS FROM `activities`
1 0.001484 0.001484 0.001484 0.001484
SHOW COLUMNS FROM `resources`
1 0.001463 0.001463 0.001463 0.001463
SHOW COLUMNS FROM `users`
1 0.001281 0.001281 0.001281 0.001281
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, 17, 12, 10, 7)
1 0.001131 0.001131 0.001131 0.001131
SHOW COLUMNS FROM `resource_videos`
1 0.001056 0.001056 0.001056 0.001056
select id from resources where FIND_IN_SET(:shortAddress, shortAddress)
2 0.000981 0.000491 0.000315 0.000666
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.000563 0.000563 0.000563 0.000563
SELECT * FROM `resources` `t` WHERE `t`.`id`=21 LIMIT 1
1 0.000543 0.000543 0.000543 0.000543
SHOW CREATE TABLE `interactions`
1 0.000337 0.000337 0.000337 0.000337
# Query Time (s)
0
select id, status from activities where FIND_IN_SET(:shortAddress, shortAddress)
0.004816
1
select id from resources where FIND_IN_SET(:shortAddress, shortAddress)
0.000666
2
select id, status from activities where FIND_IN_SET(:shortAddress, shortAddress)
0.002887
3
select id from resources where FIND_IN_SET(:shortAddress, shortAddress)
0.000315
4
SHOW COLUMNS FROM `resources`
0.001463
5
SHOW CREATE TABLE `resources`
0.004306
6
SELECT * FROM `resources` `t` WHERE `t`.`id`=21 LIMIT 1
0.000543
7
SHOW COLUMNS FROM `interactions`
0.004810
8
SHOW CREATE TABLE `interactions`
0.000337
9
SHOW COLUMNS FROM `resource_videos`
0.001056
10
SHOW CREATE TABLE `resource_videos`
0.004291
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.000563
12
SHOW COLUMNS FROM `activities`
0.001484
13
SHOW CREATE TABLE `activities`
0.004300
14
SHOW COLUMNS FROM `users`
0.001281
15
SHOW CREATE TABLE `users`
0.004301
16
SELECT * FROM `users` `t` WHERE session=:session LIMIT 1
0.004611
17
INSERT INTO `users` (`role`, `sendEmails`, `sendSms`, `source`, `session`, `lastLogin`, `phone`, `createDate`) VALUES (:yp0, :yp1, :yp2, :yp3, :yp4, :yp5, :yp6, :yp7)
0.008058
18
SELECT * FROM `users` `t` WHERE session=:session LIMIT 1
0.000510
19
UPDATE `users` SET `lastLogin`=:yp0 WHERE `users`.`id`=2540037
0.006398
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.001741
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.003092
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, 17, 12, 10, 7)
0.001131
Log Messages
Message (details) Level Category Time