Image
Interactive Exchange

Improving the Care of Patients With Chronic Pain

Individualized Assessment and Mechanism-Based Multimodal Treatment

Meeting Slides

Guidelines

2007 American College of Physicians and American Pain Society Guidelines on the Diagnosis and Treatment of Low Back Pain

2010 Department of Veterans Affairs and Department of Defense Guidelines on Opioid Therapy for Chronic Pain

2010 Practice Guidelines from the American Society of Anesthesiologists on Chronic Pain Management

2011 Institute for Clinical Systems Improvement Guidelines for the Assessment and Management of Chronic Pain

Suggested Readings

Mechanism-Based Diagnoses of Musculoskeletal Pain

Key questions that can be used to identify symptoms characteristic of nociceptive, neuropathic, or centrally mediated chronic low back pain
Smart KM, et al. Clin J Pain. 2011;27:655-663.

Brief Pain Inventory-Short Form

A multidimensional pain assessment tool that asks patients to rate pain levels, responses to treatment, and effects on function and quality of life
Cleeland CS, Ryan KM. Ann Acad Med Singapore. 1994;23:129-138.

Physical Exam Overview for Chronic Low Back Pain

A structured approach to the physical exam, motor strength testing, and sensory evaluation for patients presenting with low back pain
Duffy RL. Prim Care. 2010;37:729-741, vi.

Ten Principles of Multidrug Therapy for Chronic Pain

A concise list of general recommendations that can guide clinicians in the prescription of medication combinations for chronic pain
Argoff CE, et al. Curr Pain Headache Rep. 2006;10:34-38.

Pain Anxiety Symptom Scale Short Form 20

A 20-item questionnaire that assesses the patient’s cognitive thoughts, pain-associated fear, physiologic arousal, and escape or avoidance behaviors in an effort to identify maladaptive thoughts or unhelpful behaviors related to chronic pain
McCracken LM, Dhingra L. Pain Res Manag. 2002;7:45-50.

Patient Health Questionnaire-9

A brief tool that can assist in the diagnosis of depression and the selection and monitoring of treatment in patients with chronic pain
Kroenke K, et al. J Gen Intern Med. 2001;16:606-613.

Interactive Presentation

Scientific Insights Into Nociception and Chronic Pain

Charles E. Argoff, MD

Relevant Resources

Persistent and Breakthrough Pain

Balancing the Benefits and Risk of Opioid-Based Therapy

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

ExchangeCME is a division of InSci Productions, LLC.

2021 © InSci Productions, LLC.
Material may not be published,
broadcast, rewritten, or
redistributed in any form without
prior authorization.

Your use of this website constitutes
acceptance of InSci Productions, LLC

Privacy Policy and Terms of Use.

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:04:29 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 '32880'
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 '/cp2013'
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 1632350937.5115
REQUEST_TIME 1632350937
Request Cookies
Session Attributes
Request GET Parameters
id '10'
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.023934s)

Connection ID: db (CDbConnection)

Driver mysql
Server Version 5.5.59-0ubuntu0.14.04.1
Uptime 14w 1d 5h 48m 21s
Threads 1
Questions 40786664
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.003528 0.003528 0.003528 0.003528
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.003144 0.003144 0.003144 0.003144
UPDATE `users` SET `lastLogin`=:yp0 WHERE `users`.`id`=2491776
 1 0.002926 0.002926 0.002926 0.002926
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.001580 0.001580 0.001580 0.001580
SHOW COLUMNS FROM `resources`
 1 0.001427 0.001427 0.001427 0.001427
SHOW COLUMNS FROM `activities`
 1 0.001256 0.001256 0.001256 0.001256
select id, status from activities where FIND_IN_SET(:shortAddress, shortAddress)
 2 0.001175 0.000588 0.000300 0.000875
SHOW COLUMNS FROM `users`
 1 0.001175 0.001175 0.001175 0.001175
SHOW COLUMNS FROM `resource_videos`
 1 0.001167 0.001167 0.001167 0.001167
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, 17, 12, 7)
 1 0.001150 0.001150 0.001150 0.001150
SHOW COLUMNS FROM `interactions`
 1 0.000992 0.000992 0.000992 0.000992
select id from resources where FIND_IN_SET(:shortAddress, shortAddress)
 2 0.000934 0.000467 0.000253 0.000681
SELECT * FROM `users` `t` WHERE session=:session LIMIT 1
 2 0.000919 0.000460 0.000426 0.000493
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.000489 0.000489 0.000489 0.000489
SELECT * FROM `resources` `t` WHERE `t`.`id`=10 LIMIT 1
 1 0.000485 0.000485 0.000485 0.000485
SHOW CREATE TABLE `users`
 1 0.000348 0.000348 0.000348 0.000348
SHOW CREATE TABLE `resources`
 1 0.000341 0.000341 0.000341 0.000341
SHOW CREATE TABLE `activities`
 1 0.000335 0.000335 0.000335 0.000335
SHOW CREATE TABLE `resource_videos`
 1 0.000284 0.000284 0.000284 0.000284
SHOW CREATE TABLE `interactions`
 1 0.000279 0.000279 0.000279 0.000279
# Query Time (s)
0
select id, status from activities where FIND_IN_SET(:shortAddress, shortAddress)
 0.000875
1
select id from resources where FIND_IN_SET(:shortAddress, shortAddress)
 0.000681
2
select id, status from activities where FIND_IN_SET(:shortAddress, shortAddress)
 0.000300
3
select id from resources where FIND_IN_SET(:shortAddress, shortAddress)
 0.000253
4
SHOW COLUMNS FROM `resources`
 0.001427
5
SHOW CREATE TABLE `resources`
 0.000341
6
SELECT * FROM `resources` `t` WHERE `t`.`id`=10 LIMIT 1
 0.000485
7
SHOW COLUMNS FROM `interactions`
 0.000992
8
SHOW CREATE TABLE `interactions`
 0.000279
9
SHOW COLUMNS FROM `resource_videos`
 0.001167
10
SHOW CREATE TABLE `resource_videos`
 0.000284
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.000489
12
SHOW COLUMNS FROM `activities`
 0.001256
13
SHOW CREATE TABLE `activities`
 0.000335
14
SHOW COLUMNS FROM `users`
 0.001175
15
SHOW CREATE TABLE `users`
 0.000348
16
SELECT * FROM `users` `t` WHERE session=:session LIMIT 1
 0.000426
17
INSERT INTO `users` (`role`, `sendEmails`, `sendSms`, `source`, `session`, `lastLogin`, `phone`, `createDate`) VALUES (:yp0, :yp1, :yp2, :yp3, :yp4, :yp5, :yp6, :yp7)
 0.003528
18
SELECT * FROM `users` `t` WHERE session=:session LIMIT 1
 0.000493
19
UPDATE `users` SET `lastLogin`=:yp0 WHERE `users`.`id`=2491776
 0.002926
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.001580
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.003144
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, 17, 12, 7)
 0.001150
Log Messages
Message (details) Level Category Time