Image
Interactive Professor

Improving Outcomes in Bipolar Depression

Overcoming Diagnostic Challenges, Targeting Remission, and Optimizing Cardiometabolic Health

Meeting Slides

Tools

Depression and Bipolar Support Alliance

The Depression and Bipolar Support Alliance (DBSA) Web site offers information, education, and support for individuals suffering from bipolar depression. Tools such as the mental health screening center helps patients track and assess their symptoms. The Web site also offers a mood calendar that helps patients document their moods and may be of use to both patient and clinician when monitoring treatment efficacy.

Mood Disorder Questionnaire

The questionnaire was developed to address a critical need for timely and accurate diagnosis of bipolar disorder. A screening score of 7 or more items across 3 criteria yields a positive screen for bipolar disorder. It has very good sensitivity and specificity.
Hirschfeld RM, et al. Am J Psychiatry. 2000;157:1873-1875.

Bipolar Depression Rating Scale

The Bipolar Depression Rating Scale is designed to measure the severity of current depressive symptoms in bipolar depression. The scale contains 20 questions for a maximum score of 60. Higher scores indicate greater severity.
Berk M, et al. Bipolar Disord. 2007;9:571-579.

Guidelines

Diagnostic and Statistical Manual of Mental Disorders (Fifth Edition)

2013 version of the American Psychological Association’s diagnostic guidelines include the bipolar disorder spectrum.
American Psychological Association. Diagnostic and Statistical Manual of Mental Disorders. 5th ed. 2013: Arlington, VA, American Psychiatric Publishing.

VA/DoD Clinical Practice Guideline for Management of Bipolar Disorder in Adults

Guideline statements on the step-by-step process of clinical decision-making and intervention in the diagnosis and management of bipolar disorder. Contains best practice recommendations on general care and treatment, as well as specific recommendations for an older patient population.
VA/DoD Clinical Practice Guideline for Management of Bipolar Disorder in Adults. 2010: Washington, DC, Department of Veterans Affairs, Department of Defense.

Canadian Network for Mood and Anxiety Treatments (CANMAT) and International Society for Bipolar Disorders (ISBD) Collaborative Update of CANMAT Guidelines for the Management of Patients With Bipolar Disorder: Update 2013

The CANMAT-ISBD guidelines include instructions for the diagnosis, treatment, and management of bipolar disorder. The 2013 update contains new evidence for pharmacological treatments of bipolar depression as well as specific recommendations for bipolar II management.
Yatham LN, et al. Bipolar Disord. 2013:15:1-44.

Suggested Readings

Treatment options for acute depression in bipolar disorder.

Bauer M, et al. Bipolar Dis. 2012;14:37-50.

Subthreshold hypomanic symptoms in progression from unipolar major depression to bipolar disorder.

Fiedorowicz JG, et al. Am J Psychiatry. 2011;168:40-48.

Clinical differences between bipolar and unipolar depression.

Forty L, et al. Br J Psychiatry. 2008;19:388-389.

Clinical practice. Bipolar disorder—a focus on depression.

Frye MA. N Engl J Med. 2011;364:51-59.

Acute and maintenance treatments for bipolar depression.

Ketter TA. J Clin Psychiatry. 2014;75:e10.

Strategies for monitoring outcomes in patients with bipolar disorder.

Ketter TA. Prim Care Companion J Clin Psychiatry. 2010;12:10-16.

Clinical practice recommendations for bipolar disorder.

Malhi GS, et al. Acta Psychiatr Scand. 2009;119:27-46.

Metabolic syndrome in bipolar disorder: a review with a focus on bipolar depression.

McElroy SL, Keck PE. J Clin Psychiatry. 2014;75:46-61.

Medical comorbidity in bipolar disorder: implications for functional outcomes and health service utilization.

McIntyre RS, et al. Psychiatr Serv. 2006;57:1140-1144.

The International Society for Bipolar Disorders (ISBD) task force report on antidepressant use in bipolar disorders.

Pacchiarotti I, et al. Am J Psychiatry. 2013;170:1249-1262.

The neurobiology of the switch process in bipolar disorder: a review.

Salvadore G, et al. J Clin Psychiatry. 2010;71:1488-1501.

An update on antidepressant use in bipolar depression.

Sidor MM, MacQueen GM. Curr Psychiatry Rep. 2012;14:696-704.

Relevant Resources

Reducing the Burden of Bipolar Depression

Improved Diagnostic and Management Strategies

Comprehensive Management of Bipolar Depression

New Approaches to Optimizing Patient Outcomes

A Focus on Bipolar Depression

Overcoming Diagnostic Barriers and Optimizing Long-Term Patient Outcomes

Multidisciplinary Management of Bipolar Disorder

Accelerating Diagnosis, Achieving Remission, and Encouraging Adherence

Mixed Features in Depressive Episodes

Managing Patients Across the Disease Spectrum

Agitation and Psychiatric Disease

Best Practices for Emergency Care

Clinical Issues in Bipolar Depression

Consensus and Controversies Across the Spectrum of Patient Presentations

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 'Sun, 16 May 2021 02:50:28 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 '36800'
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 '/iprofessor'
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 1632353852.8561
REQUEST_TIME 1632353852
Request Cookies
Session Attributes
Request GET Parameters
id '15'
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.024010s)

Connection ID: db (CDbConnection)

Driver mysql
Server Version 5.5.59-0ubuntu0.14.04.1
Uptime 14w 1d 6h 36m 56s
Threads 1
Questions 40792995
Slow queries 13
Opens 195
Flush tables 1
Open tables 167
Queries per second avg 4.755
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.003752 0.003752 0.003752 0.003752
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.003465 0.003465 0.003465 0.003465
UPDATE `users` SET `lastLogin`=:yp0 WHERE `users`.`id`=2491878
1 0.003073 0.003073 0.003073 0.003073
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.001491 0.001491 0.001491 0.001491
SHOW COLUMNS FROM `resources`
1 0.001430 0.001430 0.001430 0.001430
SHOW COLUMNS FROM `activities`
1 0.001222 0.001222 0.001222 0.001222
SHOW COLUMNS FROM `users`
1 0.001208 0.001208 0.001208 0.001208
select id, status from activities where FIND_IN_SET(:shortAddress, shortAddress)
2 0.001187 0.000593 0.000274 0.000913
SELECT * FROM `users` `t` WHERE session=:session LIMIT 1
2 0.001124 0.000562 0.000498 0.000626
SHOW COLUMNS FROM `resource_videos`
1 0.001047 0.001047 0.001047 0.001047
SHOW COLUMNS FROM `interactions`
1 0.001027 0.001027 0.001027 0.001027
select id from resources where FIND_IN_SET(:shortAddress, shortAddress)
2 0.000895 0.000447 0.000253 0.000642
SELECT * FROM `resources` `t` WHERE `t`.`id` IN (166, 56, 43, 37, 27, 20, 19, 6)
1 0.000689 0.000689 0.000689 0.000689
SELECT * FROM `resources` `t` WHERE `t`.`id`=15 LIMIT 1
1 0.000472 0.000472 0.000472 0.000472
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.000450 0.000450 0.000450 0.000450
SHOW CREATE TABLE `resources`
1 0.000340 0.000340 0.000340 0.000340
SHOW CREATE TABLE `interactions`
1 0.000299 0.000299 0.000299 0.000299
SHOW CREATE TABLE `activities`
1 0.000290 0.000290 0.000290 0.000290
SHOW CREATE TABLE `users`
1 0.000286 0.000286 0.000286 0.000286
SHOW CREATE TABLE `resource_videos`
1 0.000264 0.000264 0.000264 0.000264
# Query Time (s)
0
select id, status from activities where FIND_IN_SET(:shortAddress, shortAddress)
0.000913
1
select id from resources where FIND_IN_SET(:shortAddress, shortAddress)
0.000642
2
select id, status from activities where FIND_IN_SET(:shortAddress, shortAddress)
0.000274
3
select id from resources where FIND_IN_SET(:shortAddress, shortAddress)
0.000253
4
SHOW COLUMNS FROM `resources`
0.001430
5
SHOW CREATE TABLE `resources`
0.000340
6
SELECT * FROM `resources` `t` WHERE `t`.`id`=15 LIMIT 1
0.000472
7
SHOW COLUMNS FROM `interactions`
0.001027
8
SHOW CREATE TABLE `interactions`
0.000299
9
SHOW COLUMNS FROM `resource_videos`
0.001047
10
SHOW CREATE TABLE `resource_videos`
0.000264
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.000450
12
SHOW COLUMNS FROM `activities`
0.001222
13
SHOW CREATE TABLE `activities`
0.000290
14
SHOW COLUMNS FROM `users`
0.001208
15
SHOW CREATE TABLE `users`
0.000286
16
SELECT * FROM `users` `t` WHERE session=:session LIMIT 1
0.000626
17
INSERT INTO `users` (`role`, `sendEmails`, `sendSms`, `source`, `session`, `lastLogin`, `phone`, `createDate`) VALUES (:yp0, :yp1, :yp2, :yp3, :yp4, :yp5, :yp6, :yp7)
0.003752
18
SELECT * FROM `users` `t` WHERE session=:session LIMIT 1
0.000498
19
UPDATE `users` SET `lastLogin`=:yp0 WHERE `users`.`id`=2491878
0.003073
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.001491
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.003465
22
SELECT * FROM `resources` `t` WHERE `t`.`id` IN (166, 56, 43, 37, 27, 20, 19, 6)
0.000689
Log Messages
Message (details) Level Category Time