Image
Interactive Professor

Clinical Updates on Congenital and Acquired Lipodystrophy

Translating Research 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.

Activity
Clinical Updates on Congenital and Acquired Lipodystrophy

Translating Research Into Practice

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 'Wed, 23 Jun 2021 05:27:16 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 '33070'
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 '/iplipo'
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 1632353563.7864
REQUEST_TIME 1632353563
Request Cookies
Session Attributes
Request GET Parameters
id '16'
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.024368s)

Connection ID: db (CDbConnection)

Driver mysql
Server Version 5.5.59-0ubuntu0.14.04.1
Uptime 14w 1d 6h 32m 7s
Threads 1
Questions 40792545
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.003882 0.003882 0.003882 0.003882
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.003072 0.003072 0.003072 0.003072
UPDATE `users` SET `lastLogin`=:yp0 WHERE `users`.`id`=2491871
1 0.002812 0.002812 0.002812 0.002812
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, 18, 14, 13, 9, 11, 4)
1 0.001706 0.001706 0.001706 0.001706
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.001592 0.001592 0.001592 0.001592
SHOW COLUMNS FROM `resources`
1 0.001415 0.001415 0.001415 0.001415
SHOW COLUMNS FROM `activities`
1 0.001327 0.001327 0.001327 0.001327
select id, status from activities where FIND_IN_SET(:shortAddress, shortAddress)
2 0.001197 0.000599 0.000277 0.000920
SHOW COLUMNS FROM `users`
1 0.001167 0.001167 0.001167 0.001167
SHOW COLUMNS FROM `interactions`
1 0.001033 0.001033 0.001033 0.001033
SHOW COLUMNS FROM `resource_videos`
1 0.000997 0.000997 0.000997 0.000997
SELECT * FROM `users` `t` WHERE session=:session LIMIT 1
2 0.000890 0.000445 0.000430 0.000460
select id from resources where FIND_IN_SET(:shortAddress, shortAddress)
2 0.000867 0.000434 0.000255 0.000612
SELECT * FROM `resources` `t` WHERE `t`.`id`=16 LIMIT 1
1 0.000480 0.000480 0.000480 0.000480
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.000449 0.000449 0.000449 0.000449
SHOW CREATE TABLE `resources`
1 0.000335 0.000335 0.000335 0.000335
SHOW CREATE TABLE `activities`
1 0.000317 0.000317 0.000317 0.000317
SHOW CREATE TABLE `users`
1 0.000287 0.000287 0.000287 0.000287
SHOW CREATE TABLE `interactions`
1 0.000275 0.000275 0.000275 0.000275
SHOW CREATE TABLE `resource_videos`
1 0.000268 0.000268 0.000268 0.000268
# Query Time (s)
0
select id, status from activities where FIND_IN_SET(:shortAddress, shortAddress)
0.000920
1
select id from resources where FIND_IN_SET(:shortAddress, shortAddress)
0.000612
2
select id, status from activities where FIND_IN_SET(:shortAddress, shortAddress)
0.000277
3
select id from resources where FIND_IN_SET(:shortAddress, shortAddress)
0.000255
4
SHOW COLUMNS FROM `resources`
0.001415
5
SHOW CREATE TABLE `resources`
0.000335
6
SELECT * FROM `resources` `t` WHERE `t`.`id`=16 LIMIT 1
0.000480
7
SHOW COLUMNS FROM `interactions`
0.001033
8
SHOW CREATE TABLE `interactions`
0.000275
9
SHOW COLUMNS FROM `resource_videos`
0.000997
10
SHOW CREATE TABLE `resource_videos`
0.000268
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.000449
12
SHOW COLUMNS FROM `activities`
0.001327
13
SHOW CREATE TABLE `activities`
0.000317
14
SHOW COLUMNS FROM `users`
0.001167
15
SHOW CREATE TABLE `users`
0.000287
16
SELECT * FROM `users` `t` WHERE session=:session LIMIT 1
0.000460
17
INSERT INTO `users` (`role`, `sendEmails`, `sendSms`, `source`, `session`, `lastLogin`, `phone`, `createDate`) VALUES (:yp0, :yp1, :yp2, :yp3, :yp4, :yp5, :yp6, :yp7)
0.003882
18
SELECT * FROM `users` `t` WHERE session=:session LIMIT 1
0.000430
19
UPDATE `users` SET `lastLogin`=:yp0 WHERE `users`.`id`=2491871
0.002812
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.001592
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.003072
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, 18, 14, 13, 9, 11, 4)
0.001706
Log Messages
Message (details) Level Category Time