Live Events

Your health and the needs of your patients, family and employer come first. Please know that we are keeping a close eye on the spread of the COVID-19 (Coronavirus) and we will continue to monitor the situation based on best guidance from the Centers for Disease Control and Prevention (CDC) and the World Health Organization (WHO).

For any upcoming live events offered below, all applicable safety precautions including directed current social distancing and facial coverings will be observed. Please continue to check this page and your email for updates for any live programs in which you are registered.

Clinical Issues™
Clinical Issues in COVID-19

Debates and Discussions About Monoclonal Antibody Therapies

Eric S. Daar, MD; Myron J. Levin, MD; Onyema Ogbuagu, MBBCh, FACP, FIDSA

credit amount 2.00

date 09/24/2021


Register Now
Regional Meeting Series
BLOCK HIV/HCV

Bringing Local Communities Together to Eliminate Coinfection Through Knowledge and Partnerships

David L. Wyles MD; Stuart C. Gordon, MD; Peter Gulick, DO; Teresa Juridico, MPH; Stacey B. Trooskin, MD, PhD, MPH

credit amount 6.50

date 09/27/2021

venue Radisson Hotel La...

location Lansing, MI


Register Now
Clinical Issues™
Clinical Issues in COVID-19

Debates and Discussions About Monoclonal Antibody Therapies

Eric S. Daar, MD; Myron J. Levin, MD; Onyema Ogbuagu, MBBCh, FACP, FIDSA

credit amount 2.00

date 09/29/2021


Register Now
Engaging the Patient™
Minimizing Patient Risks From COVID-19

An Update on Monoclonal Antibody Therapies

Monica Gandhi, MD, MPH; Lucy Horton, MD, MPH; Jonathan Li, MD, MMSc

credit amount 6.00

date09/29/2021-
10/06/2021

location Webcast


More Information
HIV Experts & Evidence™
The Rapid ART Standard of Care: From Evidence to Healthcare Equity

Evolving Models of HIV Care (Volume 3)

Thanes Vanig, MD

credit amount 1.50

date 10/05/2021


Register Now
Case-in-Point™
Clear Targets in Pediatric Atopic Dermatitis

A Case-Based Update

Peter A. Lio, MD; Corinna Rea, MD, MPH; Anne Marie Singh, MD

credit amount 1.50

date 10/09/2021


Register Now
Case-in-Point™
Clear Targets in Pediatric Atopic Dermatitis

A Case-Based Update

Peter A. Lio, MD; Corinna Rea, MD, MPH; Anne Marie Singh, MD

credit amount 3.00

date10/14/2021-
10/21/2021

venue Webinar


More Information
Regional Meeting Series
BRIDGE HCV

Building Bridges To Reach People Who Inject Drugs With The Goal To Eliminate HCV

Kelly Cooper, MD, MPH

credit amount 1.00

date 10/22/2021

venue In-Person Event -...

location Knoxville, TN


Register Now
A Breath of Fresh Air in Pediatric Asthma

Shared Decision-making in the Era of Biologics

Mario Castro, MD, MPH; Wanda Phipatanakul, MD, MS
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 06:17:00 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 '39266'
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 '/events'
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 1632356590.0634
REQUEST_TIME 1632356590
Request Cookies
Session Attributes
Request GET Parameters
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()
)
log array
(
'class' => 'CLogRouter'
'behaviors'
=> array()
)
viewRenderer array
(
'class' => 'YiiDebugViewRenderer'
)
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()
)
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
(
2 => array
(
'topics' => '
$(function() {
$(\'#clinical-topics\').on (\'change\', function () {
window.location.href = \'/events/index/topic/\'+$(this).val();
})
})
'
)
)
'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()
)
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'
)
)
)
themeManager array
(
'class' => 'CThemeManager'
'themeClass'
=> 'CTheme'
'behaviors'
=> array()
)
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 EventsController
Context class EventsController
Inheritance Controller » CController » CBaseController
Defined in file protected/controllers/EventsController.php
Context properties
  •  => 
  •  => 
  •  => 
  •  => 
  •  => 
Route events/index
Action CInlineAction (index)
Action params
    null
Render methodrenderPartial
View file themes/desktop/views/events/index.php
View data
  •  => 
  •  => 
Context EventsController
Context class EventsController
Inheritance Controller » CController » CBaseController
Defined in file protected/controllers/EventsController.php
Context properties
  •  => 
  •  => 
  •  => 
  •  => 
  •  => 
Route events/index
Action CInlineAction (index)
Action params
    null
Render methodrenderPartial
View file themes/desktop/views/common/_clinical_topics.php
View data
  •  => 
Context EventsController
Context class EventsController
Inheritance Controller » CController » CBaseController
Defined in file protected/controllers/EventsController.php
Context properties
  •  => 
  •  => 
  •  => 
  •  => 
  •  => 
Route events/index
Action CInlineAction (index)
Action params
    null
Render methodrenderPartial
View file themes/desktop/views/common/_event.php
View data
  •  => 
Context EventsController
Context class EventsController
Inheritance Controller » CController » CBaseController
Defined in file protected/controllers/EventsController.php
Context properties
  •  => 
  •  => 
  •  => 
  •  => 
  •  => 
Route events/index
Action CInlineAction (index)
Action params
    null
Render methodrenderPartial
View file themes/desktop/views/common/_event.php
View data
  •  => 
Context EventsController
Context class EventsController
Inheritance Controller » CController » CBaseController
Defined in file protected/controllers/EventsController.php
Context properties
  •  => 
  •  => 
  •  => 
  •  => 
  •  => 
Route events/index
Action CInlineAction (index)
Action params
    null
Render methodrenderPartial
View file themes/desktop/views/common/_event.php
View data
  •  => 
Context EventsController
Context class EventsController
Inheritance Controller » CController » CBaseController
Defined in file protected/controllers/EventsController.php
Context properties
  •  => 
  •  => 
  •  => 
  •  => 
  •  => 
Route events/index
Action CInlineAction (index)
Action params
    null
Render methodrenderPartial
View file themes/desktop/views/common/_group_event.php
View data
  •  => 
Context EventsController
Context class EventsController
Inheritance Controller » CController » CBaseController
Defined in file protected/controllers/EventsController.php
Context properties
  •  => 
  •  => 
  •  => 
  •  => 
  •  => 
Route events/index
Action CInlineAction (index)
Action params
    null
Render methodrenderPartial
View file themes/desktop/views/common/_event.php
View data
  •  => 
Context EventsController
Context class EventsController
Inheritance Controller » CController » CBaseController
Defined in file protected/controllers/EventsController.php
Context properties
  •  => 
  •  => 
  •  => 
  •  => 
  •  => 
Route events/index
Action CInlineAction (index)
Action params
    null
Render methodrenderPartial
View file themes/desktop/views/common/_event.php
View data
  •  => 
Context EventsController
Context class EventsController
Inheritance Controller » CController » CBaseController
Defined in file protected/controllers/EventsController.php
Context properties
  •  => 
  •  => 
  •  => 
  •  => 
  •  => 
Route events/index
Action CInlineAction (index)
Action params
    null
Render methodrenderPartial
View file themes/desktop/views/common/_group_event.php
View data
  •  => 
Context EventsController
Context class EventsController
Inheritance Controller » CController » CBaseController
Defined in file protected/controllers/EventsController.php
Context properties
  •  => 
  •  => 
  •  => 
  •  => 
  •  => 
Route events/index
Action CInlineAction (index)
Action params
    null
Render methodrenderPartial
View file themes/desktop/views/common/_event.php
View data
  •  => 
Context EventsController
Context class EventsController
Inheritance Controller » CController » CBaseController
Defined in file protected/controllers/EventsController.php
Context properties
  •  => 
  •  => 
  •  => 
  •  => 
  •  => 
Route events/index
Action CInlineAction (index)
Action params
    null
Render methodrenderPartial
View file themes/desktop/views/common/_featured_activity.php
View data
  •  => 
Context EventsController
Context class EventsController
Inheritance Controller » CController » CBaseController
Defined in file protected/controllers/EventsController.php
Context properties
  •  => 
  •  => 
  •  => 
  •  => 
  •  => 
Route events/index
Action CInlineAction (index)
Action params
    null
Render methodrenderPartial
View file themes/desktop/views/common/_featured_resource.php
View data
  •  => 
Context EventsController
Context class EventsController
Inheritance Controller » CController » CBaseController
Defined in file protected/controllers/EventsController.php
Context properties
  •  => 
  •  => 
  •  => 
  •  => 
  •  => 
Route events/index
Action CInlineAction (index)
Action params
    null
Render methodrender
View file protected/views/layouts/column1.php
Context EventsController
Context class EventsController
Inheritance Controller » CController » CBaseController
Defined in file protected/controllers/EventsController.php
Context properties
  •  => 
  •  => 
  •  => 
  •  => 
  •  => 
Route events/index
Action CInlineAction (index)
Action params
    null
Render methodrender
View file themes/desktop/views/layouts/main.php
Context EventsController
Context class EventsController
Inheritance Controller » CController » CBaseController
Defined in file protected/controllers/EventsController.php
Context properties
  •  => 
  •  => 
  •  => 
  •  => 
  •  => 
Route events/index
Action CInlineAction (index)
Action params
    null
Render methodrenderPartial
View file themes/desktop/views/common/_footer.php
View data
    null
Context EventsController
Context class EventsController
Inheritance Controller » CController » CBaseController
Defined in file protected/controllers/EventsController.php
Context properties
  •  => 
  •  => 
  •  => 
  •  => 
  •  => 
Route events/index
Action CInlineAction (index)
Action params
    null
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 (35/0.048426s)

Connection ID: db (CDbConnection)

Driver mysql
Server Version 5.5.59-0ubuntu0.14.04.1
Uptime 14w 1d 7h 22m 34s
Threads 1
Questions 40796534
Slow queries 13
Opens 195
Flush tables 1
Open tables 167
Queries per second avg 4.754
Query Count Total (s) Avg. (s) Min. (s) Max. (s)
SELECT `t`.`id` AS `t0_c0`, `t`.`shortAddress` AS `t0_c1`, `t`.`resource_id` AS `t0_c2`, `t`.`type` AS `t0_c3`, `t`.`title` AS `t0_c4`, `t`.`shortDescription` AS `t0_c5`, `t`.`facultyNames` AS `t0_c6`, `t`.`faculty` AS `t0_c7`, `t`.`calendarDate` AS `t0_c8`, `t`.`creditAmount` AS `t0_c9`, `t`.`creditType` AS `t0_c10`, `t`.`shortWhen` AS `t0_c11`, `t`.`fullWhen` AS `t0_c12`, `t`.`venue` AS `t0_c13`, `t`.`shortWhere` AS `t0_c14`, `t`.`fullWhere` AS `t0_c15`, `t`.`createDate` AS `t0_c16`, `t`.`status` AS `t0_c17`, `t`.`description` AS `t0_c18`, `t`.`image` AS `t0_c19`, `t`.`eventsOrdering` AS `t0_c20`, `t`.`newEventAddDate` AS `t0_c21`, `t`.`start_date` AS `t0_c22`, `t`.`end_date` AS `t0_c23`, `t`.`sponsors` AS `t0_c24`, `events`.`id` AS `t1_c0`, `events`.`group_id` AS `t1_c1`, `events`.`shortAddress` AS `t1_c2`, `events`.`resource_id` AS `t1_c3`, `events`.`type` AS `t1_c4`, `events`.`addType` AS `t1_c5`, `events`.`title` AS `t1_c6`, `events`.`shortDescription` AS `t1_c7`, `events`.`facultyNames` AS `t1_c8`, `events`.`faculty` AS `t1_c9`, `events`.`calendarDate` AS `t1_c10`, `events`.`creditAmount` AS `t1_c11`, `events`.`creditType` AS `t1_c12`, `events`.`shortWhen` AS `t1_c13`, `events`.`fullWhen` AS `t1_c14`, `events`.`venue` AS `t1_c15`, `events`.`shortWhere` AS `t1_c16`, `events`.`fullWhere` AS `t1_c17`, `events`.`createDate` AS `t1_c18`, `events`.`status` AS `t1_c19`, `events`.`description` AS `t1_c20`, `events`.`image` AS `t1_c21`, `events`.`linkout` AS `t1_c22`, `events`.`registrationEnabled` AS `t1_c23`, `events`.`activity_id` AS `t1_c24`, `events`.`adobe_connect_sco` AS `t1_c25`, `events`.`adobe_connect_datetime` AS `t1_c26`, `events`.`users_limit` AS `t1_c27`, `events`.`adobe_connect_duration` AS `t1_c28`, `events`.`calendar_description` AS `t1_c29`, `topics`.`id` AS `t2_c0`, `topics`.`title` AS `t2_c1`, `topics`.`url` AS `t2_c2`, `topics`.`sort` AS `t2_c3` FROM `groups_events` `t` LEFT OUTER JOIN `events` `events` ON (`events`.`group_id`=`t`.`id`) LEFT OUTER JOIN `events_topics` `topics_topics` ON (`events`.`id`=`topics_topics`.`event_id`) LEFT OUTER JOIN `topics` `topics` ON (`topics`.`id`=`topics_topics`.`topic_id`) WHERE (t.status = :status_active) ORDER BY t.start_date ASC
1 0.015675 0.015675 0.015675 0.015675
INSERT INTO `users` (`role`, `sendEmails`, `sendSms`, `source`, `session`, `lastLogin`, `phone`, `createDate`) VALUES (:yp0, :yp1, :yp2, :yp3, :yp4, :yp5, :yp6, :yp7)
1 0.003760 0.003760 0.003760 0.003760
UPDATE `users` SET `lastLogin`=:yp0 WHERE `users`.`id`=2491929
1 0.003386 0.003386 0.003386 0.003386
SELECT * FROM `events` `t` WHERE `group_id` = :id
2 0.003181 0.001590 0.001546 0.001635
SELECT `t`.`id` AS `t0_c0`, `t`.`group_id` AS `t0_c1`, `t`.`shortAddress` AS `t0_c2`, `t`.`resource_id` AS `t0_c3`, `t`.`type` AS `t0_c4`, `t`.`addType` AS `t0_c5`, `t`.`title` AS `t0_c6`, `t`.`shortDescription` AS `t0_c7`, `t`.`facultyNames` AS `t0_c8`, `t`.`faculty` AS `t0_c9`, `t`.`calendarDate` AS `t0_c10`, `t`.`creditAmount` AS `t0_c11`, `t`.`creditType` AS `t0_c12`, `t`.`shortWhen` AS `t0_c13`, `t`.`fullWhen` AS `t0_c14`, `t`.`venue` AS `t0_c15`, `t`.`shortWhere` AS `t0_c16`, `t`.`fullWhere` AS `t0_c17`, `t`.`createDate` AS `t0_c18`, `t`.`status` AS `t0_c19`, `t`.`description` AS `t0_c20`, `t`.`image` AS `t0_c21`, `t`.`linkout` AS `t0_c22`, `t`.`registrationEnabled` AS `t0_c23`, `t`.`activity_id` AS `t0_c24`, `t`.`adobe_connect_sco` AS `t0_c25`, `t`.`adobe_connect_datetime` AS `t0_c26`, `t`.`users_limit` AS `t0_c27`, `t`.`adobe_connect_duration` AS `t0_c28`, `t`.`calendar_description` AS `t0_c29`, `topics`.`id` AS `t1_c0`, `topics`.`title` AS `t1_c1`, `topics`.`url` AS `t1_c2`, `topics`.`sort` AS `t1_c3` FROM `events` `t` LEFT OUTER JOIN `events_topics` `topics_topics` ON (`t`.`id`=`topics_topics`.`event_id`) LEFT OUTER JOIN `topics` `topics` ON (`topics`.`id`=`topics_topics`.`topic_id`) WHERE (((t.calendarDate>=:today) AND (t.status = :status_active)) AND (t.group_id IS NULL OR t.group_id ="")) ORDER BY t.calendarDate ASC
1 0.002740 0.002740 0.002740 0.002740
SELECT `t`.`id` AS `t0_c0`, `t`.`group_id` AS `t0_c1`, `t`.`shortAddress` AS `t0_c2`, `t`.`resource_id` AS `t0_c3`, `t`.`type` AS `t0_c4`, `t`.`addType` AS `t0_c5`, `t`.`title` AS `t0_c6`, `t`.`shortDescription` AS `t0_c7`, `t`.`facultyNames` AS `t0_c8`, `t`.`faculty` AS `t0_c9`, `t`.`calendarDate` AS `t0_c10`, `t`.`creditAmount` AS `t0_c11`, `t`.`creditType` AS `t0_c12`, `t`.`shortWhen` AS `t0_c13`, `t`.`fullWhen` AS `t0_c14`, `t`.`venue` AS `t0_c15`, `t`.`shortWhere` AS `t0_c16`, `t`.`fullWhere` AS `t0_c17`, `t`.`createDate` AS `t0_c18`, `t`.`status` AS `t0_c19`, `t`.`description` AS `t0_c20`, `t`.`image` AS `t0_c21`, `t`.`linkout` AS `t0_c22`, `t`.`registrationEnabled` AS `t0_c23`, `t`.`activity_id` AS `t0_c24`, `t`.`adobe_connect_sco` AS `t0_c25`, `t`.`adobe_connect_datetime` AS `t0_c26`, `t`.`users_limit` AS `t0_c27`, `t`.`adobe_connect_duration` AS `t0_c28`, `t`.`calendar_description` AS `t0_c29`, `userEvents`.`id` AS `t1_c0`, `userEvents`.`user_id` AS `t1_c1`, `userEvents`.`event_id` AS `t1_c2`, `userEvents`.`remindEmail` AS `t1_c3`, `userEvents`.`remindSms` AS `t1_c4`, `userEvents`.`webinar_link` AS `t1_c5` FROM `events` `t` LEFT OUTER JOIN `users_events` `userEvents` ON (`userEvents`.`event_id`=`t`.`id`) WHERE (userEvents.user_id = :uid AND t.id = :event_id)
4 0.002235 0.000559 0.000536 0.000567
SHOW COLUMNS FROM `groups_events`
1 0.001863 0.001863 0.001863 0.001863
SHOW COLUMNS FROM `events`
1 0.001436 0.001436 0.001436 0.001436
SHOW COLUMNS FROM `activities`
1 0.001385 0.001385 0.001385 0.001385
SHOW COLUMNS FROM `resources`
1 0.001290 0.001290 0.001290 0.001290
SHOW COLUMNS FROM `users`
1 0.001206 0.001206 0.001206 0.001206
SHOW COLUMNS FROM `users_events`
1 0.001181 0.001181 0.001181 0.001181
SHOW COLUMNS FROM `activity_topics`
1 0.001060 0.001060 0.001060 0.001060
SELECT * FROM `users` `t` WHERE session=:session LIMIT 1
2 0.001007 0.000504 0.000426 0.000581
SHOW COLUMNS FROM `topics`
1 0.000973 0.000973 0.000973 0.000973
SHOW COLUMNS FROM `resource_topics`
1 0.000941 0.000941 0.000941 0.000941
SHOW COLUMNS FROM `events_topics`
1 0.000927 0.000927 0.000927 0.000927
SHOW CREATE TABLE `users`
1 0.000405 0.000405 0.000405 0.000405
SHOW CREATE TABLE `groups_events`
1 0.000381 0.000381 0.000381 0.000381
SELECT `t`.`id` AS `t0_c0`, `t`.`group_id` AS `t0_c1`, `t`.`resource_id` AS `t0_c2`, `t`.`title` AS `t0_c3`, `t`.`type` AS `t0_c4`, `t`.`facultyNames` AS `t0_c5`, `t`.`shortDescription` AS `t0_c6`, `t`.`fullDescription` AS `t0_c7`, `t`.`creditAmount` AS `t0_c8`, `t`.`shortAddress` AS `t0_c9`, `t`.`creditType` AS `t0_c10`, `t`.`startDate` AS `t0_c11`, `t`.`finishDate` AS `t0_c12`, `t`.`sponsors` AS `t0_c13`, `t`.`status` AS `t0_c14`, `t`.`createDate` AS `t0_c15`, `t`.`image` AS `t0_c16`, `t`.`image_featured` AS `t0_c17`, `t`.`archived` AS `t0_c18`, `t`.`managers_list` AS `t0_c19`, `t`.`is_send_pp_email` AS `t0_c20`, `t`.`muvi_sync_date` AS `t0_c21`, `t`.`expert_questions` AS `t0_c22`, `activityTopics`.`id` AS `t1_c0`, `activityTopics`.`activity_id` AS `t1_c1`, `activityTopics`.`topic_id` AS `t1_c2`, `activityTopics`.`isFeatured` AS `t1_c3`, `event`.`id` AS `t2_c0`, `event`.`group_id` AS `t2_c1`, `event`.`shortAddress` AS `t2_c2`, `event`.`resource_id` AS `t2_c3`, `event`.`type` AS `t2_c4`, `event`.`addType` AS `t2_c5`, `event`.`title` AS `t2_c6`, `event`.`shortDescription` AS `t2_c7`, `event`.`facultyNames` AS `t2_c8`, `event`.`faculty` AS `t2_c9`, `event`.`calendarDate` AS `t2_c10`, `event`.`creditAmount` AS `t2_c11`, `event`.`creditType` AS `t2_c12`, `event`.`shortWhen` AS `t2_c13`, `event`.`fullWhen` AS `t2_c14`, `event`.`venue` AS `t2_c15`, `event`.`shortWhere` AS `t2_c16`, `event`.`fullWhere` AS `t2_c17`, `event`.`createDate` AS `t2_c18`, `event`.`status` AS `t2_c19`, `event`.`description` AS `t2_c20`, `event`.`image` AS `t2_c21`, `event`.`linkout` AS `t2_c22`, `event`.`registrationEnabled` AS `t2_c23`, `event`.`activity_id` AS `t2_c24`, `event`.`adobe_connect_sco` AS `t2_c25`, `event`.`adobe_connect_datetime` AS `t2_c26`, `event`.`users_limit` AS `t2_c27`, `event`.`adobe_connect_duration` AS `t2_c28`, `event`.`calendar_description` AS `t2_c29` FROM `activities` `t` LEFT OUTER JOIN `activity_topics` `activityTopics` ON (`activityTopics`.`activity_id`=`t`.`id`) LEFT OUTER JOIN `events` `event` ON (`event`.`activity_id`=`t`.`id`) WHERE (((((((isFeatured = 1) AND (IFNULL(t.group_id, "") = "")) AND (t.status = :status_active)) AND (topic_id = 0)) AND (t.archived=0)) AND (t.image_featured is not null)) AND (event.id IS NULL)) ORDER BY t.createDate DESC LIMIT 1
1 0.000364 0.000364 0.000364 0.000364
SHOW CREATE TABLE `events`
1 0.000338 0.000338 0.000338 0.000338
SELECT * FROM `topics` `t` ORDER BY title
1 0.000319 0.000319 0.000319 0.000319
SHOW CREATE TABLE `activities`
1 0.000317 0.000317 0.000317 0.000317
SHOW CREATE TABLE `users_events`
1 0.000303 0.000303 0.000303 0.000303
SHOW CREATE TABLE `resources`
1 0.000302 0.000302 0.000302 0.000302
SHOW CREATE TABLE `events_topics`
1 0.000295 0.000295 0.000295 0.000295
SHOW CREATE TABLE `topics`
1 0.000295 0.000295 0.000295 0.000295
SHOW CREATE TABLE `activity_topics`
1 0.000293 0.000293 0.000293 0.000293
SHOW CREATE TABLE `resource_topics`
1 0.000292 0.000292 0.000292 0.000292
SELECT `t`.`id` AS `t0_c0`, `t`.`shortAddress` AS `t0_c1`, `t`.`status` AS `t0_c2`, `t`.`title` AS `t0_c3`, `t`.`type` AS `t0_c4`, `t`.`image` AS `t0_c5`, `t`.`slides` AS `t0_c6`, `t`.`linkedResources` AS `t0_c7`, `t`.`reading` AS `t0_c8`, `t`.`shortDescription` AS `t0_c9`, `t`.`fullDescription` AS `t0_c10`, `t`.`link` AS `t0_c11`, `t`.`createDate` AS `t0_c12`, `t`.`archived` AS `t0_c13`, `resourceTopics`.`id` AS `t1_c0`, `resourceTopics`.`resource_id` AS `t1_c1`, `resourceTopics`.`topic_id` AS `t1_c2`, `resourceTopics`.`isFeatured` AS `t1_c3` FROM `resources` `t` LEFT OUTER JOIN `resource_topics` `resourceTopics` ON (`resourceTopics`.`resource_id`=`t`.`id`) WHERE ((((isFeatured = 1) AND (t.status = :status_active)) AND (t.archived=0)) AND (topic_id = 0)) ORDER BY createDate DESC LIMIT 1
1 0.000276 0.000276 0.000276 0.000276
# Query Time (s)
0
SHOW COLUMNS FROM `groups_events`
0.001863
1
SHOW CREATE TABLE `groups_events`
0.000381
2
SHOW COLUMNS FROM `events`
0.001436
3
SHOW CREATE TABLE `events`
0.000338
4
SHOW COLUMNS FROM `topics`
0.000973
5
SHOW CREATE TABLE `topics`
0.000295
6
SHOW COLUMNS FROM `events_topics`
0.000927
7
SHOW CREATE TABLE `events_topics`
0.000295
8
SELECT `t`.`id` AS `t0_c0`, `t`.`shortAddress` AS `t0_c1`, `t`.`resource_id` AS `t0_c2`, `t`.`type` AS `t0_c3`, `t`.`title` AS `t0_c4`, `t`.`shortDescription` AS `t0_c5`, `t`.`facultyNames` AS `t0_c6`, `t`.`faculty` AS `t0_c7`, `t`.`calendarDate` AS `t0_c8`, `t`.`creditAmount` AS `t0_c9`, `t`.`creditType` AS `t0_c10`, `t`.`shortWhen` AS `t0_c11`, `t`.`fullWhen` AS `t0_c12`, `t`.`venue` AS `t0_c13`, `t`.`shortWhere` AS `t0_c14`, `t`.`fullWhere` AS `t0_c15`, `t`.`createDate` AS `t0_c16`, `t`.`status` AS `t0_c17`, `t`.`description` AS `t0_c18`, `t`.`image` AS `t0_c19`, `t`.`eventsOrdering` AS `t0_c20`, `t`.`newEventAddDate` AS `t0_c21`, `t`.`start_date` AS `t0_c22`, `t`.`end_date` AS `t0_c23`, `t`.`sponsors` AS `t0_c24`, `events`.`id` AS `t1_c0`, `events`.`group_id` AS `t1_c1`, `events`.`shortAddress` AS `t1_c2`, `events`.`resource_id` AS `t1_c3`, `events`.`type` AS `t1_c4`, `events`.`addType` AS `t1_c5`, `events`.`title` AS `t1_c6`, `events`.`shortDescription` AS `t1_c7`, `events`.`facultyNames` AS `t1_c8`, `events`.`faculty` AS `t1_c9`, `events`.`calendarDate` AS `t1_c10`, `events`.`creditAmount` AS `t1_c11`, `events`.`creditType` AS `t1_c12`, `events`.`shortWhen` AS `t1_c13`, `events`.`fullWhen` AS `t1_c14`, `events`.`venue` AS `t1_c15`, `events`.`shortWhere` AS `t1_c16`, `events`.`fullWhere` AS `t1_c17`, `events`.`createDate` AS `t1_c18`, `events`.`status` AS `t1_c19`, `events`.`description` AS `t1_c20`, `events`.`image` AS `t1_c21`, `events`.`linkout` AS `t1_c22`, `events`.`registrationEnabled` AS `t1_c23`, `events`.`activity_id` AS `t1_c24`, `events`.`adobe_connect_sco` AS `t1_c25`, `events`.`adobe_connect_datetime` AS `t1_c26`, `events`.`users_limit` AS `t1_c27`, `events`.`adobe_connect_duration` AS `t1_c28`, `events`.`calendar_description` AS `t1_c29`, `topics`.`id` AS `t2_c0`, `topics`.`title` AS `t2_c1`, `topics`.`url` AS `t2_c2`, `topics`.`sort` AS `t2_c3` FROM `groups_events` `t` LEFT OUTER JOIN `events` `events` ON (`events`.`group_id`=`t`.`id`) LEFT OUTER JOIN `events_topics` `topics_topics` ON (`events`.`id`=`topics_topics`.`event_id`) LEFT OUTER JOIN `topics` `topics` ON (`topics`.`id`=`topics_topics`.`topic_id`) WHERE (t.status = :status_active) ORDER BY t.start_date ASC
0.015675
9
SELECT `t`.`id` AS `t0_c0`, `t`.`group_id` AS `t0_c1`, `t`.`shortAddress` AS `t0_c2`, `t`.`resource_id` AS `t0_c3`, `t`.`type` AS `t0_c4`, `t`.`addType` AS `t0_c5`, `t`.`title` AS `t0_c6`, `t`.`shortDescription` AS `t0_c7`, `t`.`facultyNames` AS `t0_c8`, `t`.`faculty` AS `t0_c9`, `t`.`calendarDate` AS `t0_c10`, `t`.`creditAmount` AS `t0_c11`, `t`.`creditType` AS `t0_c12`, `t`.`shortWhen` AS `t0_c13`, `t`.`fullWhen` AS `t0_c14`, `t`.`venue` AS `t0_c15`, `t`.`shortWhere` AS `t0_c16`, `t`.`fullWhere` AS `t0_c17`, `t`.`createDate` AS `t0_c18`, `t`.`status` AS `t0_c19`, `t`.`description` AS `t0_c20`, `t`.`image` AS `t0_c21`, `t`.`linkout` AS `t0_c22`, `t`.`registrationEnabled` AS `t0_c23`, `t`.`activity_id` AS `t0_c24`, `t`.`adobe_connect_sco` AS `t0_c25`, `t`.`adobe_connect_datetime` AS `t0_c26`, `t`.`users_limit` AS `t0_c27`, `t`.`adobe_connect_duration` AS `t0_c28`, `t`.`calendar_description` AS `t0_c29`, `topics`.`id` AS `t1_c0`, `topics`.`title` AS `t1_c1`, `topics`.`url` AS `t1_c2`, `topics`.`sort` AS `t1_c3` FROM `events` `t` LEFT OUTER JOIN `events_topics` `topics_topics` ON (`t`.`id`=`topics_topics`.`event_id`) LEFT OUTER JOIN `topics` `topics` ON (`topics`.`id`=`topics_topics`.`topic_id`) WHERE (((t.calendarDate>=:today) AND (t.status = :status_active)) AND (t.group_id IS NULL OR t.group_id ="")) ORDER BY t.calendarDate ASC
0.002740
10
SELECT * FROM `topics` `t` ORDER BY title
0.000319
11
SHOW COLUMNS FROM `users_events`
0.001181
12
SHOW CREATE TABLE `users_events`
0.000303
13
SELECT `t`.`id` AS `t0_c0`, `t`.`group_id` AS `t0_c1`, `t`.`shortAddress` AS `t0_c2`, `t`.`resource_id` AS `t0_c3`, `t`.`type` AS `t0_c4`, `t`.`addType` AS `t0_c5`, `t`.`title` AS `t0_c6`, `t`.`shortDescription` AS `t0_c7`, `t`.`facultyNames` AS `t0_c8`, `t`.`faculty` AS `t0_c9`, `t`.`calendarDate` AS `t0_c10`, `t`.`creditAmount` AS `t0_c11`, `t`.`creditType` AS `t0_c12`, `t`.`shortWhen` AS `t0_c13`, `t`.`fullWhen` AS `t0_c14`, `t`.`venue` AS `t0_c15`, `t`.`shortWhere` AS `t0_c16`, `t`.`fullWhere` AS `t0_c17`, `t`.`createDate` AS `t0_c18`, `t`.`status` AS `t0_c19`, `t`.`description` AS `t0_c20`, `t`.`image` AS `t0_c21`, `t`.`linkout` AS `t0_c22`, `t`.`registrationEnabled` AS `t0_c23`, `t`.`activity_id` AS `t0_c24`, `t`.`adobe_connect_sco` AS `t0_c25`, `t`.`adobe_connect_datetime` AS `t0_c26`, `t`.`users_limit` AS `t0_c27`, `t`.`adobe_connect_duration` AS `t0_c28`, `t`.`calendar_description` AS `t0_c29`, `userEvents`.`id` AS `t1_c0`, `userEvents`.`user_id` AS `t1_c1`, `userEvents`.`event_id` AS `t1_c2`, `userEvents`.`remindEmail` AS `t1_c3`, `userEvents`.`remindSms` AS `t1_c4`, `userEvents`.`webinar_link` AS `t1_c5` FROM `events` `t` LEFT OUTER JOIN `users_events` `userEvents` ON (`userEvents`.`event_id`=`t`.`id`) WHERE (userEvents.user_id = :uid AND t.id = :event_id)
0.000567
14
SELECT `t`.`id` AS `t0_c0`, `t`.`group_id` AS `t0_c1`, `t`.`shortAddress` AS `t0_c2`, `t`.`resource_id` AS `t0_c3`, `t`.`type` AS `t0_c4`, `t`.`addType` AS `t0_c5`, `t`.`title` AS `t0_c6`, `t`.`shortDescription` AS `t0_c7`, `t`.`facultyNames` AS `t0_c8`, `t`.`faculty` AS `t0_c9`, `t`.`calendarDate` AS `t0_c10`, `t`.`creditAmount` AS `t0_c11`, `t`.`creditType` AS `t0_c12`, `t`.`shortWhen` AS `t0_c13`, `t`.`fullWhen` AS `t0_c14`, `t`.`venue` AS `t0_c15`, `t`.`shortWhere` AS `t0_c16`, `t`.`fullWhere` AS `t0_c17`, `t`.`createDate` AS `t0_c18`, `t`.`status` AS `t0_c19`, `t`.`description` AS `t0_c20`, `t`.`image` AS `t0_c21`, `t`.`linkout` AS `t0_c22`, `t`.`registrationEnabled` AS `t0_c23`, `t`.`activity_id` AS `t0_c24`, `t`.`adobe_connect_sco` AS `t0_c25`, `t`.`adobe_connect_datetime` AS `t0_c26`, `t`.`users_limit` AS `t0_c27`, `t`.`adobe_connect_duration` AS `t0_c28`, `t`.`calendar_description` AS `t0_c29`, `userEvents`.`id` AS `t1_c0`, `userEvents`.`user_id` AS `t1_c1`, `userEvents`.`event_id` AS `t1_c2`, `userEvents`.`remindEmail` AS `t1_c3`, `userEvents`.`remindSms` AS `t1_c4`, `userEvents`.`webinar_link` AS `t1_c5` FROM `events` `t` LEFT OUTER JOIN `users_events` `userEvents` ON (`userEvents`.`event_id`=`t`.`id`) WHERE (userEvents.user_id = :uid AND t.id = :event_id)
0.000567
15
SELECT * FROM `events` `t` WHERE `group_id` = :id
0.001635
16
SELECT `t`.`id` AS `t0_c0`, `t`.`group_id` AS `t0_c1`, `t`.`shortAddress` AS `t0_c2`, `t`.`resource_id` AS `t0_c3`, `t`.`type` AS `t0_c4`, `t`.`addType` AS `t0_c5`, `t`.`title` AS `t0_c6`, `t`.`shortDescription` AS `t0_c7`, `t`.`facultyNames` AS `t0_c8`, `t`.`faculty` AS `t0_c9`, `t`.`calendarDate` AS `t0_c10`, `t`.`creditAmount` AS `t0_c11`, `t`.`creditType` AS `t0_c12`, `t`.`shortWhen` AS `t0_c13`, `t`.`fullWhen` AS `t0_c14`, `t`.`venue` AS `t0_c15`, `t`.`shortWhere` AS `t0_c16`, `t`.`fullWhere` AS `t0_c17`, `t`.`createDate` AS `t0_c18`, `t`.`status` AS `t0_c19`, `t`.`description` AS `t0_c20`, `t`.`image` AS `t0_c21`, `t`.`linkout` AS `t0_c22`, `t`.`registrationEnabled` AS `t0_c23`, `t`.`activity_id` AS `t0_c24`, `t`.`adobe_connect_sco` AS `t0_c25`, `t`.`adobe_connect_datetime` AS `t0_c26`, `t`.`users_limit` AS `t0_c27`, `t`.`adobe_connect_duration` AS `t0_c28`, `t`.`calendar_description` AS `t0_c29`, `userEvents`.`id` AS `t1_c0`, `userEvents`.`user_id` AS `t1_c1`, `userEvents`.`event_id` AS `t1_c2`, `userEvents`.`remindEmail` AS `t1_c3`, `userEvents`.`remindSms` AS `t1_c4`, `userEvents`.`webinar_link` AS `t1_c5` FROM `events` `t` LEFT OUTER JOIN `users_events` `userEvents` ON (`userEvents`.`event_id`=`t`.`id`) WHERE (userEvents.user_id = :uid AND t.id = :event_id)
0.000536
17
SELECT `t`.`id` AS `t0_c0`, `t`.`group_id` AS `t0_c1`, `t`.`shortAddress` AS `t0_c2`, `t`.`resource_id` AS `t0_c3`, `t`.`type` AS `t0_c4`, `t`.`addType` AS `t0_c5`, `t`.`title` AS `t0_c6`, `t`.`shortDescription` AS `t0_c7`, `t`.`facultyNames` AS `t0_c8`, `t`.`faculty` AS `t0_c9`, `t`.`calendarDate` AS `t0_c10`, `t`.`creditAmount` AS `t0_c11`, `t`.`creditType` AS `t0_c12`, `t`.`shortWhen` AS `t0_c13`, `t`.`fullWhen` AS `t0_c14`, `t`.`venue` AS `t0_c15`, `t`.`shortWhere` AS `t0_c16`, `t`.`fullWhere` AS `t0_c17`, `t`.`createDate` AS `t0_c18`, `t`.`status` AS `t0_c19`, `t`.`description` AS `t0_c20`, `t`.`image` AS `t0_c21`, `t`.`linkout` AS `t0_c22`, `t`.`registrationEnabled` AS `t0_c23`, `t`.`activity_id` AS `t0_c24`, `t`.`adobe_connect_sco` AS `t0_c25`, `t`.`adobe_connect_datetime` AS `t0_c26`, `t`.`users_limit` AS `t0_c27`, `t`.`adobe_connect_duration` AS `t0_c28`, `t`.`calendar_description` AS `t0_c29`, `userEvents`.`id` AS `t1_c0`, `userEvents`.`user_id` AS `t1_c1`, `userEvents`.`event_id` AS `t1_c2`, `userEvents`.`remindEmail` AS `t1_c3`, `userEvents`.`remindSms` AS `t1_c4`, `userEvents`.`webinar_link` AS `t1_c5` FROM `events` `t` LEFT OUTER JOIN `users_events` `userEvents` ON (`userEvents`.`event_id`=`t`.`id`) WHERE (userEvents.user_id = :uid AND t.id = :event_id)
0.000565
18
SELECT * FROM `events` `t` WHERE `group_id` = :id
0.001546
19
SHOW COLUMNS FROM `activities`
0.001385
20
SHOW CREATE TABLE `activities`
0.000317
21
SHOW COLUMNS FROM `users`
0.001206
22
SHOW CREATE TABLE `users`
0.000405
23
SELECT * FROM `users` `t` WHERE session=:session LIMIT 1
0.000426
24
INSERT INTO `users` (`role`, `sendEmails`, `sendSms`, `source`, `session`, `lastLogin`, `phone`, `createDate`) VALUES (:yp0, :yp1, :yp2, :yp3, :yp4, :yp5, :yp6, :yp7)
0.003760
25
SELECT * FROM `users` `t` WHERE session=:session LIMIT 1
0.000581
26
UPDATE `users` SET `lastLogin`=:yp0 WHERE `users`.`id`=2491929
0.003386
27
SHOW COLUMNS FROM `activity_topics`
0.001060
28
SHOW CREATE TABLE `activity_topics`
0.000293
29
SELECT `t`.`id` AS `t0_c0`, `t`.`group_id` AS `t0_c1`, `t`.`resource_id` AS `t0_c2`, `t`.`title` AS `t0_c3`, `t`.`type` AS `t0_c4`, `t`.`facultyNames` AS `t0_c5`, `t`.`shortDescription` AS `t0_c6`, `t`.`fullDescription` AS `t0_c7`, `t`.`creditAmount` AS `t0_c8`, `t`.`shortAddress` AS `t0_c9`, `t`.`creditType` AS `t0_c10`, `t`.`startDate` AS `t0_c11`, `t`.`finishDate` AS `t0_c12`, `t`.`sponsors` AS `t0_c13`, `t`.`status` AS `t0_c14`, `t`.`createDate` AS `t0_c15`, `t`.`image` AS `t0_c16`, `t`.`image_featured` AS `t0_c17`, `t`.`archived` AS `t0_c18`, `t`.`managers_list` AS `t0_c19`, `t`.`is_send_pp_email` AS `t0_c20`, `t`.`muvi_sync_date` AS `t0_c21`, `t`.`expert_questions` AS `t0_c22`, `activityTopics`.`id` AS `t1_c0`, `activityTopics`.`activity_id` AS `t1_c1`, `activityTopics`.`topic_id` AS `t1_c2`, `activityTopics`.`isFeatured` AS `t1_c3`, `event`.`id` AS `t2_c0`, `event`.`group_id` AS `t2_c1`, `event`.`shortAddress` AS `t2_c2`, `event`.`resource_id` AS `t2_c3`, `event`.`type` AS `t2_c4`, `event`.`addType` AS `t2_c5`, `event`.`title` AS `t2_c6`, `event`.`shortDescription` AS `t2_c7`, `event`.`facultyNames` AS `t2_c8`, `event`.`faculty` AS `t2_c9`, `event`.`calendarDate` AS `t2_c10`, `event`.`creditAmount` AS `t2_c11`, `event`.`creditType` AS `t2_c12`, `event`.`shortWhen` AS `t2_c13`, `event`.`fullWhen` AS `t2_c14`, `event`.`venue` AS `t2_c15`, `event`.`shortWhere` AS `t2_c16`, `event`.`fullWhere` AS `t2_c17`, `event`.`createDate` AS `t2_c18`, `event`.`status` AS `t2_c19`, `event`.`description` AS `t2_c20`, `event`.`image` AS `t2_c21`, `event`.`linkout` AS `t2_c22`, `event`.`registrationEnabled` AS `t2_c23`, `event`.`activity_id` AS `t2_c24`, `event`.`adobe_connect_sco` AS `t2_c25`, `event`.`adobe_connect_datetime` AS `t2_c26`, `event`.`users_limit` AS `t2_c27`, `event`.`adobe_connect_duration` AS `t2_c28`, `event`.`calendar_description` AS `t2_c29` FROM `activities` `t` LEFT OUTER JOIN `activity_topics` `activityTopics` ON (`activityTopics`.`activity_id`=`t`.`id`) LEFT OUTER JOIN `events` `event` ON (`event`.`activity_id`=`t`.`id`) WHERE (((((((isFeatured = 1) AND (IFNULL(t.group_id, "") = "")) AND (t.status = :status_active)) AND (topic_id = 0)) AND (t.archived=0)) AND (t.image_featured is not null)) AND (event.id IS NULL)) ORDER BY t.createDate DESC LIMIT 1
0.000364
30
SHOW COLUMNS FROM `resources`
0.001290
31
SHOW CREATE TABLE `resources`
0.000302
32
SHOW COLUMNS FROM `resource_topics`
0.000941
33
SHOW CREATE TABLE `resource_topics`
0.000292
34
SELECT `t`.`id` AS `t0_c0`, `t`.`shortAddress` AS `t0_c1`, `t`.`status` AS `t0_c2`, `t`.`title` AS `t0_c3`, `t`.`type` AS `t0_c4`, `t`.`image` AS `t0_c5`, `t`.`slides` AS `t0_c6`, `t`.`linkedResources` AS `t0_c7`, `t`.`reading` AS `t0_c8`, `t`.`shortDescription` AS `t0_c9`, `t`.`fullDescription` AS `t0_c10`, `t`.`link` AS `t0_c11`, `t`.`createDate` AS `t0_c12`, `t`.`archived` AS `t0_c13`, `resourceTopics`.`id` AS `t1_c0`, `resourceTopics`.`resource_id` AS `t1_c1`, `resourceTopics`.`topic_id` AS `t1_c2`, `resourceTopics`.`isFeatured` AS `t1_c3` FROM `resources` `t` LEFT OUTER JOIN `resource_topics` `resourceTopics` ON (`resourceTopics`.`resource_id`=`t`.`id`) WHERE ((((isFeatured = 1) AND (t.status = :status_active)) AND (t.archived=0)) AND (topic_id = 0)) ORDER BY createDate DESC LIMIT 1
0.000276
Log Messages
Message (details) Level Category Time