Image
Interactive Professor

Improving Outcomes for Women with Type 2 Diabetes

Individualizing Evidence-Based Care

Meeting Slides

Guidelines

American Diabetes Association—Standards of Medical Care in Diabetes—2015

American Diabetes Association. Diabetes Care. 2015;38(suppl 1):S1-S93.

American Diabetes Association—Diagnosis and Classification of Diabetes Mellitus

American Diabetes Association. Diabetes Care. 2014;37(suppl 1):S81-S90.

National Standards for Diabetes Self-Management Education and Support

Haas L, et al. Diabetes Care. 2014;37(suppl 1):S144-S153.

American Association of Clinical Endocrinologists and American College of Endocrinology—Clinical Practice Guidelines for Developing a Diabetes Mellitus Comprehensive Care Plan—2015

Handelsman Y, et al. Endocr Pract. 2015;21(suppl 1):1-87.

Management of Hyperglycemia in Type 2 Diabetes, 2015: A Patient-Centered Approach—Update to a Position Statement of the American Diabetes Association and the European Association for the Study of Diabetes

Inzucchi SE, et al. Diabetes Care. 2015;38(1):140-149.

Suggested Readings

Sex Differences in Type 2 Diabetes: Focus on Disease Course and Outcomes

Arnetz L, et al. Diabetes Metab Syndr and Obes. 2014;7:409-420.

Polycystic Ovary Syndrome: Important Underrecognised Cardiometabolic Risk Factor in Reproductive-Age Women

Baldani DP, et al. Int J of Endocrinol. 2015;2015:786362.

Parity and Diabetes Risk Among Hispanic Women From Colombia: Cross-sectional Evidence

Cure P, et al. Diabetol Metab Syndr. 2015;7:7.

Women Are Diagnosed With Type 2 Diabetes at Higher Body Mass Indices and Older Ages than Men: Korea National Health and Nutrition Examination Survey 2007-2010

Kwon SK. Diabetes Metab J. 2014;38(1):74-80 .

Impact of Sex on the Heart’s Metabolic and Functional Responses to Diabetic Therapies

Lyons MR, et al. Am J Physiol Heart Circ Physiol. 2013;305(11):H1584-H1591.

Diabetes Abrogates Sex Differences and Aggravates Cardiometabolic Risk in Postmenopausal Women

Mascarenhas-Melo F, et al. Cardiovasc Diabetol. 2013;12:61.

Sex Differences in the Excess Risk of Cardiovascular Diseases Associated With Type 2 Diabetes: Potential Explanations and Clinical Implications

Peters SAE, et al. Curr Cardiovasc Risk Rep. 2015;9(7):36.

Sex Differences in the Metabolic Syndrome: Implications for Cardiovascular Health in Women

Pradhan AD. Clin Chem. 2014;60(1):44-52.

Factors Associated With a Diabetes Diagnosis and Late Diabetes Diagnosis for Males and Females

Roche MM, Wang PP. J of Clin Transl Endocrinol. 2014;1(3):77-84.

Sex Differences in All-Cause and Cardiovascular Mortality, Hospitalization for Individuals With and Without Diabetes, and Patients With Diabetes Diagnosed Early and Late

Roche MM, Wang PP. Diabetes Care. 2013;36(9):2582-2590. 

Educational Materials for Patients, Family Members, and Caregivers

American Diabetes Association—Women 

WomensHealth.gov—The Healthy Woman: A Complete Guide for All Ages—Type 2 Diabetes

CDC.gov—Diabetes in Women

Interactive Presentation

Practice Pearls for Improving Outcomes for Women with T2DM

Eileen Egan, DNP, FNP-C, CDE

Activity
Improving Outcomes for Women With Type 2 Diabetes

Individualizing Evidence-Based Care

More information

Relevant Resources

Incretin-Based Therapies for Type 2 Diabetes

Mechanism-Based Strategies to Achieve Patient-Centered Care

Insulin Replacement Therapy for Type 2 Diabetes

Patient-Centered Management of Hyperglycemia in Primary Care

Improving Outcomes in Type 2 Diabetes

Integrating GLP-1 Receptor Agonists Into Multimodal Treatment Regimens

A Focus on Bipolar Depression

Overcoming Diagnostic Barriers and Optimizing Long-Term Patient Outcomes

Clinical Issues in Type 2 Diabetes

Discussions and Debates Around GLP-1 Receptor Agonists

Clinical Issues in Type 2 Diabetes

Evolving Roles of GLP-1 Receptor Agonists

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 Congenital and Acquired Lipodystrophy

Best Practices in Diagnosis and Management

Clinical Updates in Type 2 Diabetes

New Strategies for Insulin Replacement Therapy

Clinical Issues in Type 2 Diabetes

Consensus and Controversies Around Intensifying Noninsulin Therapy

How Low Do You Go?

Clinical Updates in LDL-C Management

Incretin-Based Therapies For Type 2 Diabetes

Improving Comprehensive Patient Care

Clinical Updates in Type 2 Diabetes

An Evolving Role for Combinations of Injectable Antihyperglycemic Therapies

Raising the Bar by Lowering the Target

Integrating PCSK9 Inhibitors Into Hypercholesterolemia Management

Injecting New Ideas into Managing Type 2 Diabetes

Evolving Roles of GLP-1 Receptor Agonists

Multidimensional Issues in Type 2 Diabetes

Looking Beyond Hemoglobin A1c

GLP-1 Receptors Agonists in Type 2 Diabetes

Mechanistic Insights and Evolving Treatment Options

Pharmaceutical Economics and LDL-C Management

Implications for PCSK9 Inhibitors in Clinical Practice

Assimilating the Evidence in T2DM

Cardiovascular and Renal Outcomes With SGLT2 Inhibitors

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 'Mon, 02 Aug 2021 18:11: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 '34348'
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 '/aade2015'
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 1634405015.1743
REQUEST_TIME 1634405015
Request Cookies
Session Attributes
Request GET Parameters
id '33'
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.025447s)

Connection ID: db (CDbConnection)

Driver mysql
Server Version 5.5.59-0ubuntu0.14.04.1
Uptime 17w 4d 0h 22m 59s
Threads 1
Questions 48177310
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.003975 0.003975 0.003975 0.003975
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.003602 0.003602 0.003602 0.003602
UPDATE `users` SET `lastLogin`=:yp0 WHERE `users`.`id`=2539648
 1 0.002908 0.002908 0.002908 0.002908
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.001744 0.001744 0.001744 0.001744
SHOW COLUMNS FROM `resources`
 1 0.001504 0.001504 0.001504 0.001504
SHOW COLUMNS FROM `activities`
 1 0.001321 0.001321 0.001321 0.001321
select id, status from activities where FIND_IN_SET(:shortAddress, shortAddress)
 2 0.001272 0.000636 0.000271 0.001001
SELECT * FROM `resources` `t` WHERE `t`.`id` IN (143, 132, 129, 122, 118, 109, 89, 81, 73, 51, 50, 49, 48, 45, 42, 38, 30, 29, 20, 18, 16, 14, 13, 9, 11, 4)
 1 0.001271 0.001271 0.001271 0.001271
SHOW COLUMNS FROM `users`
 1 0.001209 0.001209 0.001209 0.001209
SELECT * FROM `users` `t` WHERE session=:session LIMIT 1
 2 0.001176 0.000588 0.000497 0.000679
SHOW COLUMNS FROM `interactions`
 1 0.001030 0.001030 0.001030 0.001030
SHOW COLUMNS FROM `resource_videos`
 1 0.001011 0.001011 0.001011 0.001011
select id from resources where FIND_IN_SET(:shortAddress, shortAddress)
 2 0.000849 0.000425 0.000249 0.000600
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.000491 0.000491 0.000491 0.000491
SELECT * FROM `resources` `t` WHERE `t`.`id`=33 LIMIT 1
 1 0.000456 0.000456 0.000456 0.000456
SHOW CREATE TABLE `interactions`
 1 0.000376 0.000376 0.000376 0.000376
SHOW CREATE TABLE `resources`
 1 0.000327 0.000327 0.000327 0.000327
SHOW CREATE TABLE `users`
 1 0.000321 0.000321 0.000321 0.000321
SHOW CREATE TABLE `activities`
 1 0.000319 0.000319 0.000319 0.000319
SHOW CREATE TABLE `resource_videos`
 1 0.000286 0.000286 0.000286 0.000286
# Query Time (s)
0
select id, status from activities where FIND_IN_SET(:shortAddress, shortAddress)
 0.001001
1
select id from resources where FIND_IN_SET(:shortAddress, shortAddress)
 0.000600
2
select id, status from activities where FIND_IN_SET(:shortAddress, shortAddress)
 0.000271
3
select id from resources where FIND_IN_SET(:shortAddress, shortAddress)
 0.000249
4
SHOW COLUMNS FROM `resources`
 0.001504
5
SHOW CREATE TABLE `resources`
 0.000327
6
SELECT * FROM `resources` `t` WHERE `t`.`id`=33 LIMIT 1
 0.000456
7
SHOW COLUMNS FROM `interactions`
 0.001030
8
SHOW CREATE TABLE `interactions`
 0.000376
9
SHOW COLUMNS FROM `resource_videos`
 0.001011
10
SHOW CREATE TABLE `resource_videos`
 0.000286
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.000491
12
SHOW COLUMNS FROM `activities`
 0.001321
13
SHOW CREATE TABLE `activities`
 0.000319
14
SHOW COLUMNS FROM `users`
 0.001209
15
SHOW CREATE TABLE `users`
 0.000321
16
SELECT * FROM `users` `t` WHERE session=:session LIMIT 1
 0.000679
17
INSERT INTO `users` (`role`, `sendEmails`, `sendSms`, `source`, `session`, `lastLogin`, `phone`, `createDate`) VALUES (:yp0, :yp1, :yp2, :yp3, :yp4, :yp5, :yp6, :yp7)
 0.003975
18
SELECT * FROM `users` `t` WHERE session=:session LIMIT 1
 0.000497
19
UPDATE `users` SET `lastLogin`=:yp0 WHERE `users`.`id`=2539648
 0.002908
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.001744
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.003602
22
SELECT * FROM `resources` `t` WHERE `t`.`id` IN (143, 132, 129, 122, 118, 109, 89, 81, 73, 51, 50, 49, 48, 45, 42, 38, 30, 29, 20, 18, 16, 14, 13, 9, 11, 4)
 0.001271
Log Messages
Message (details) Level Category Time