Image
Interactive Professor

Clinical Updates on Congenital and Acquired Lipodystrophy

Translating Reseach Into Practice

Meeting Slides

Guidelines

The Clinical Approach to the Detection of Lipodystrophy—A Consensus Statement From the American Association of Clinical Endocrinologists

A consensus statement from the American Academy of Clinical Endocrinologists about the classification, detection, and diagnosis of various types of lipodystrophy. The expert task force of clinical practitioners and leaders in lipodystrophy research aims to increase awareness of these underdiagnosed disorders and provide a framework for future diagnostic criteria.
Handelsman Y, et al. Endocr Pract. 2013;19(1):107-116.

American Diabetes Association’s Standards of Medical Care in Diabetes—2014 

The American Diabetes Association’s Standards of Care provide clinicians, patients, researchers, payers, and other interested individuals with the components of good diabetes management, general treatment goals, and tools to evaluate the quality of care. Importantly, these recommendations should be adjusted based on individual preferences, comorbidities, and other patient-related factors.
American Diabetes Association. Diabetes Care. 2014;37(suppl 1):S14-S80.

American Association of Clinical Endocrinologists’ Comprehensive Diabetes Management Algorithm 2013

This algorithm from the AACE outlines a complications-centric approach to diabetes care and recommendations on evidence-based treatment approaches. The document contains sections on managing obesity, prediabetes, hyperglycemia, hypertension, and hyperlipidemia, as well as other risk-reduction strategies.
Garber AJ, et al. Endocr Pract. 2013;19(2):327-336.

Tools

Lipodystrophy Resource Center at The Endocrine Society

The Endocrine Society has created a variety of educational materials covering the pathophysiology, clinical presentations, and treatment of lipodystrophies. Particular emphasis is placed on the connections between generalized or partial adipose tissue loss and their often severe metabolic complications, including severe insulin resistance, type 2 diabetes, and hypertriglyceridemia.

Lipodystrophy United Website

Lipodystrophy United is an organization of committed individuals living strong with Lipodystrophy. Our mission is to provide an interactive community, facilitating support and education for anyone affected by this rare disease. We serve as a resource and to increase awareness in the general population as well as the medical and insurance communities. We advocate and act as a catalyst for new patient diagnosis by assisting healthcare professionals in the understanding of Lipodystrophy trends, physical attributes and clinical symptoms in order to aid in the advancement of knowledge, treatment and future research.

Lipodystrophy Connect Regisrty

Registry stores detailed information in one place making it easier for researchers to share and study information, while still protecting the privacy of those who take part. This research is being done to better understand LD, and to answer questions such as how LD is treated, and what can be done to improve care for people with LD.

Suggested Readings

Ectopic lipid storage and insulin resistance: a harmful relationship.

Borén J, et al. J Intern Med. 2013;274(1):25-40.

Clinical classification and treatment of congenital and acquired lipodystrophy.

Chan JL, Oral EA. Endocr Pract. 2010;16(2):310-323.

Clinical effects of long-term metreleptin treatment in patients with lipodystrophy.

Chan JL, et al. Endocr Pract. 2011;17(6):922-932.

Lipodystrophy: pathophysiology and advances in treatment.

Fiorenza CG, et al. Nat Rev Endocrinol. 2011;7(3):137-150.

Lipodystrophies: genetic and acquired body fat disorders.

Garg A. J Clin Endocrinol Metab. 2011;96(11):3313-3325.

Lipodystrophy: metabolic insights from a rare disorder.

Huang-Doran I, et al. J Endocrinol. 2010;207(3):245-255.

Leptin and the central nervous system control of glucose metabolism.

Morton GJ, Schwartz MW. Physiol Rev. 2011;91(2):389-411.

Exploring the pathophysiology behind the more common genetic and acquired lipodystrophies.

Nolis T. J Hum Genet. 2014;59(1):16-23.

Rationale for leptin-replacement therapy for severe lipodystrophy.

Oral EA, Chan JL. Endocr Pract. 2010;16(2):324-333.

How to diagnose a lipodystrophy syndrome.

Vantyghem MC, et al. Ann Endocrinol (Paris). 2012;73(3):170-189.

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

Improving Outcomes for Women with Type 2 Diabetes

Individualizing Evidence-Based Care

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

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:41:49 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 '42222'
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 '/ipeasd'
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 1632353688.8613
REQUEST_TIME 1632353688
Request Cookies
Session Attributes
Request GET Parameters
id '18'
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.024851s)

Connection ID: db (CDbConnection)

Driver mysql
Server Version 5.5.59-0ubuntu0.14.04.1
Uptime 14w 1d 6h 34m 12s
Threads 1
Questions 40792684
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.003914 0.003914 0.003914 0.003914
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.003346 0.003346 0.003346 0.003346
UPDATE `users` SET `lastLogin`=:yp0 WHERE `users`.`id`=2491875
1 0.002985 0.002985 0.002985 0.002985
SELECT * FROM `resources` `t` WHERE `t`.`id` IN (143, 132, 129, 122, 118, 109, 89, 81, 73, 51, 50, 49, 48, 45, 42, 38, 33, 30, 29, 20, 16, 14, 13, 9, 11, 4)
1 0.001918 0.001918 0.001918 0.001918
SHOW COLUMNS FROM `resources`
1 0.001433 0.001433 0.001433 0.001433
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.001419 0.001419 0.001419 0.001419
SHOW COLUMNS FROM `users`
1 0.001228 0.001228 0.001228 0.001228
SHOW COLUMNS FROM `activities`
1 0.001225 0.001225 0.001225 0.001225
select id, status from activities where FIND_IN_SET(:shortAddress, shortAddress)
2 0.001175 0.000587 0.000280 0.000895
SHOW COLUMNS FROM `resource_videos`
1 0.001088 0.001088 0.001088 0.001088
SHOW COLUMNS FROM `interactions`
1 0.000984 0.000984 0.000984 0.000984
SELECT * FROM `users` `t` WHERE session=:session LIMIT 1
2 0.000882 0.000441 0.000414 0.000468
select id from resources where FIND_IN_SET(:shortAddress, shortAddress)
2 0.000865 0.000432 0.000255 0.000610
SELECT * FROM `resources` `t` WHERE `t`.`id`=18 LIMIT 1
1 0.000475 0.000475 0.000475 0.000475
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.000335 0.000335 0.000335 0.000335
SHOW CREATE TABLE `users`
1 0.000295 0.000295 0.000295 0.000295
SHOW CREATE TABLE `activities`
1 0.000293 0.000293 0.000293 0.000293
SHOW CREATE TABLE `interactions`
1 0.000277 0.000277 0.000277 0.000277
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.000895
1
select id from resources where FIND_IN_SET(:shortAddress, shortAddress)
0.000610
2
select id, status from activities where FIND_IN_SET(:shortAddress, shortAddress)
0.000280
3
select id from resources where FIND_IN_SET(:shortAddress, shortAddress)
0.000255
4
SHOW COLUMNS FROM `resources`
0.001433
5
SHOW CREATE TABLE `resources`
0.000335
6
SELECT * FROM `resources` `t` WHERE `t`.`id`=18 LIMIT 1
0.000475
7
SHOW COLUMNS FROM `interactions`
0.000984
8
SHOW CREATE TABLE `interactions`
0.000277
9
SHOW COLUMNS FROM `resource_videos`
0.001088
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.001225
13
SHOW CREATE TABLE `activities`
0.000293
14
SHOW COLUMNS FROM `users`
0.001228
15
SHOW CREATE TABLE `users`
0.000295
16
SELECT * FROM `users` `t` WHERE session=:session LIMIT 1
0.000468
17
INSERT INTO `users` (`role`, `sendEmails`, `sendSms`, `source`, `session`, `lastLogin`, `phone`, `createDate`) VALUES (:yp0, :yp1, :yp2, :yp3, :yp4, :yp5, :yp6, :yp7)
0.003914
18
SELECT * FROM `users` `t` WHERE session=:session LIMIT 1
0.000414
19
UPDATE `users` SET `lastLogin`=:yp0 WHERE `users`.`id`=2491875
0.002985
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.001419
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.003346
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, 33, 30, 29, 20, 16, 14, 13, 9, 11, 4)
0.001918
Log Messages
Message (details) Level Category Time