Featured Activities

Image SnapShot
Where Are We Now in Moderate-to-Severe Asthma?

From Comprehensive Patient Evaluations to Individualized Evidence-Based Care

Jonathan Corren, MD; Monica Kraft, MD

credit amount 1.25

credit type CME/CE

expiration 05/14/2022


More Information
Image
A Breath of Fresh Air in Pediatric Asthma

Shared Decision-making in the Era of Biologics

Mario Castro, MD, MPH; Wanda Phipatanakul, MD, MS

credit amount 1.00

credit type CME/CE

expiration 08/03/2022


More Information
Image
Swimming Upstream in Severe Asthma

New Pathways to Patient Management

Jonathan Corren, MD; Monica Kraft, MD; Reynold A. Panettieri, Jr, MD

credit amount 1.00

credit type AMA PRA

expiration 06/25/2022


More Information
Image
Evolving Approaches to Alzheimer’s Disease

Finding the Way Forward

Sharon Cohen, MD, FRCPC; Marwan N. Sabbagh, MD, FAAN

credit amount 1.50

credit type CME/AANP

expiration 04/22/2022


More Information
Image
HIV Experts & Evidence™

A Two-Part Continuing Medical Education Series on the Evolving Models of HIV Care

Jonathan A. Colasanti, MD, MSPH; Jason Halperin, MD, MPH

credit amount 1.50

credit type CME/CE

expiration 03/29/2022


More Information
Image
Expert Views on the Changing Landscape in RA

The Increasing Role of JAK Inhibitors

Leonard Calabrese, DO; Madelaine Feldman, MD, FACR; Prof Iain McInnes, CBE, FRCP, PhD, FRSE, FMedSci

credit amount 0.75

credit type CME

expiration 01/29/2022


More Information

Resources

Webcast
Clinical Issues in COVID-19

Debates and Discussions about Monoclonal Antibody Therapies

Meeting Slides

Linked Resources

Suggested Reading


Review
Engaging the Patient
MINIMIZING PATIENT RISKS FROM COVID-19

An Update on Monoclonal Antibody Therapies

Linked Resources

Suggested Reading



Review
Journal Club
IBD Journal Club:

Volume 1: A Guided Tour of the Evidence Driving Selection of First-line Advanced Therapies in Moderate to Severe IBD

Linked Resources

Suggested Reading



Review
Image
A Breath of Fresh Air in Pediatric Asthma

Shared Decision-making in the Era of Biologics

Mario Castro, MD, MPH; Wanda Phipatanakul, MD, MS
Featured Event
September 24, 2021

Clinical Issues in COVID-19

Register to Attend

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 19:19:44 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 '53618'
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 '/'
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 1632355798.313
REQUEST_TIME 1632355798
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
(
3 => array
(
'topics' => '
$(\'#clinical-topics\').on(\'change\', function() {
window.location.href = \'/site/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 SiteController
Context class SiteController
Inheritance Controller » CController » CBaseController
Defined in file protected/controllers/SiteController.php
Context properties
  •  => 
  •  => 
  •  => 
  •  => 
  •  => 
Route site/index
Action CInlineAction (index)
Action params
    null
Render methodrenderPartial
View file themes/desktop/views/site/index.php
View data
  •  => 
  •  => 
  •  => 
  •  => 
Context SiteController
Context class SiteController
Inheritance Controller » CController » CBaseController
Defined in file protected/controllers/SiteController.php
Context properties
  •  => 
  •  => 
  •  => 
  •  => 
  •  => 
Route site/index
Action CInlineAction (index)
Action params
    null
Render methodrenderPartial
View file themes/desktop/views/common/_clinical_topics.php
View data
  •  => 
Context SiteController
Context class SiteController
Inheritance Controller » CController » CBaseController
Defined in file protected/controllers/SiteController.php
Context properties
  •  => 
  •  => 
  •  => 
  •  => 
  •  => 
Route site/index
Action CInlineAction (index)
Action params
    null
Render methodrenderPartial
View file themes/desktop/views/common/_groups.php
View data
  •  => 
Context SiteController
Context class SiteController
Inheritance Controller » CController » CBaseController
Defined in file protected/controllers/SiteController.php
Context properties
  •  => 
  •  => 
  •  => 
  •  => 
  •  => 
Route site/index
Action CInlineAction (index)
Action params
    null
Render methodrenderPartial
View file themes/desktop/views/common/_activity.php
View data
  •  => 
Context SiteController
Context class SiteController
Inheritance Controller » CController » CBaseController
Defined in file protected/controllers/SiteController.php
Context properties
  •  => 
  •  => 
  •  => 
  •  => 
  •  => 
Route site/index
Action CInlineAction (index)
Action params
    null
Render methodrenderPartial
View file themes/desktop/views/common/_activity.php
View data
  •  => 
Context SiteController
Context class SiteController
Inheritance Controller » CController » CBaseController
Defined in file protected/controllers/SiteController.php
Context properties
  •  => 
  •  => 
  •  => 
  •  => 
  •  => 
Route site/index
Action CInlineAction (index)
Action params
    null
Render methodrenderPartial
View file themes/desktop/views/common/_groups.php
View data
  •  => 
Context SiteController
Context class SiteController
Inheritance Controller » CController » CBaseController
Defined in file protected/controllers/SiteController.php
Context properties
  •  => 
  •  => 
  •  => 
  •  => 
  •  => 
Route site/index
Action CInlineAction (index)
Action params
    null
Render methodrenderPartial
View file themes/desktop/views/common/_groups.php
View data
  •  => 
Context SiteController
Context class SiteController
Inheritance Controller » CController » CBaseController
Defined in file protected/controllers/SiteController.php
Context properties
  •  => 
  •  => 
  •  => 
  •  => 
  •  => 
Route site/index
Action CInlineAction (index)
Action params
    null
Render methodrenderPartial
View file themes/desktop/views/common/_activity.php
View data
  •  => 
Context SiteController
Context class SiteController
Inheritance Controller » CController » CBaseController
Defined in file protected/controllers/SiteController.php
Context properties
  •  => 
  •  => 
  •  => 
  •  => 
  •  => 
Route site/index
Action CInlineAction (index)
Action params
    null
Render methodrenderPartial
View file themes/desktop/views/common/_resource.php
View data
  •  => 
Context SiteController
Context class SiteController
Inheritance Controller » CController » CBaseController
Defined in file protected/controllers/SiteController.php
Context properties
  •  => 
  •  => 
  •  => 
  •  => 
  •  => 
Route site/index
Action CInlineAction (index)
Action params
    null
Render methodrenderPartial
View file themes/desktop/views/common/_resource.php
View data
  •  => 
Context SiteController
Context class SiteController
Inheritance Controller » CController » CBaseController
Defined in file protected/controllers/SiteController.php
Context properties
  •  => 
  •  => 
  •  => 
  •  => 
  •  => 
Route site/index
Action CInlineAction (index)
Action params
    null
Render methodrenderPartial
View file themes/desktop/views/common/_resource.php
View data
  •  => 
Context SiteController
Context class SiteController
Inheritance Controller » CController » CBaseController
Defined in file protected/controllers/SiteController.php
Context properties
  •  => 
  •  => 
  •  => 
  •  => 
  •  => 
Route site/index
Action CInlineAction (index)
Action params
    null
Render methodrenderPartial
View file themes/desktop/views/common/_featured_activity.php
View data
  •  => 
Context SiteController
Context class SiteController
Inheritance Controller » CController » CBaseController
Defined in file protected/controllers/SiteController.php
Context properties
  •  => 
  •  => 
  •  => 
  •  => 
  •  => 
Route site/index
Action CInlineAction (index)
Action params
    null
Render methodrenderPartial
View file themes/desktop/views/common/_featured_event.php
View data
  •  => 
Context SiteController
Context class SiteController
Inheritance Controller » CController » CBaseController
Defined in file protected/controllers/SiteController.php
Context properties
  •  => 
  •  => 
  •  => 
  •  => 
  •  => 
Route site/index
Action CInlineAction (index)
Action params
    null
Render methodrenderPartial
View file themes/desktop/views/common/_twitter.php
View data
  •  => 
Context SiteController
Context class SiteController
Inheritance Controller » CController » CBaseController
Defined in file protected/controllers/SiteController.php
Context properties
  •  => 
  •  => 
  •  => 
  •  => 
  •  => 
Route site/index
Action CInlineAction (index)
Action params
    null
Render methodrender
View file protected/views/layouts/column1.php
Context SiteController
Context class SiteController
Inheritance Controller » CController » CBaseController
Defined in file protected/controllers/SiteController.php
Context properties
  •  => 
  •  => 
  •  => 
  •  => 
  •  => 
Route site/index
Action CInlineAction (index)
Action params
    null
Render methodrender
View file themes/desktop/views/layouts/main.php
Context SiteController
Context class SiteController
Inheritance Controller » CController » CBaseController
Defined in file protected/controllers/SiteController.php
Context properties
  •  => 
  •  => 
  •  => 
  •  => 
  •  => 
Route site/index
Action CInlineAction (index)
Action params
    null
Render methodrenderPartial
View file themes/desktop/views/common/_footer.php
View data
    null
Context SiteController
Context class SiteController
Inheritance Controller » CController » CBaseController
Defined in file protected/controllers/SiteController.php
Context properties
  •  => 
  •  => 
  •  => 
  •  => 
  •  => 
Route site/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 (51/0.073972s)

Connection ID: db (CDbConnection)

Driver mysql
Server Version 5.5.59-0ubuntu0.14.04.1
Uptime 14w 1d 7h 9m 22s
Threads 1
Questions 40795399
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)
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`, `topics`.`id` AS `t1_c0`, `topics`.`title` AS `t1_c1`, `topics`.`url` AS `t1_c2`, `topics`.`sort` AS `t1_c3` FROM `resources` `t` LEFT OUTER JOIN `resource_topics` `topics_topics` ON (`t`.`id`=`topics_topics`.`resource_id`) LEFT OUTER JOIN `topics` `topics` ON (`topics`.`id`=`topics_topics`.`topic_id`) WHERE ((t.archived=0) AND (t.status = :status_active)) ORDER BY t.createDate DESC
 1 0.028961 0.028961 0.028961 0.028961
UPDATE activities SET archived=1 WHERE finishDate<now();
 1 0.006452 0.006452 0.006452 0.006452
INSERT INTO `users` (`role`, `sendEmails`, `sendSms`, `source`, `session`, `lastLogin`, `phone`, `createDate`) VALUES (:yp0, :yp1, :yp2, :yp3, :yp4, :yp5, :yp6, :yp7)
 1 0.003644 0.003644 0.003644 0.003644
SELECT `t`.`id` AS `t0_c0`, `t`.`resources_id` AS `t0_c1`, `t`.`title` AS `t0_c2`, `t`.`sub_title` AS `t0_c3`, `t`.`description` AS `t0_c4`, `t`.`facultyNames` AS `t0_c5`, `t`.`sponsors` AS `t0_c6`, `t`.`status` AS `t0_c7`, `t`.`archived` AS `t0_c8`, `t`.`image` AS `t0_c9`, `t`.`shortlink` AS `t0_c10`, `t`.`startDate` AS `t0_c11`, `t`.`finishDate` AS `t0_c12`, `t`.`createDate` AS `t0_c13`, `t`.`newActivityAddDate` AS `t0_c14`, `t`.`type` AS `t0_c15`, `t`.`image_featured` AS `t0_c16`, `t`.`shortDescription` AS `t0_c17`, `t`.`activitiesOrdering` AS `t0_c18`, `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`, `topics`.`id` AS `t2_c0`, `topics`.`title` AS `t2_c1`, `topics`.`url` AS `t2_c2`, `topics`.`sort` AS `t2_c3` FROM `activities_groups` `t` LEFT OUTER JOIN `activities` `activities` ON (`activities`.`group_id`=`t`.`id`) LEFT OUTER JOIN `activity_topics` `topics_topics` ON (`activities`.`id`=`topics_topics`.`activity_id`) LEFT OUTER JOIN `topics` `topics` ON (`topics`.`id`=`topics_topics`.`topic_id`) WHERE ((t.status = :status_active) AND (t.archived=0)) ORDER BY t.createDate DESC
 1 0.003210 0.003210 0.003210 0.003210
UPDATE activities_groups SET archived=1 WHERE finishDate<now();
 1 0.003168 0.003168 0.003168 0.003168
UPDATE `users` SET `lastLogin`=:yp0 WHERE `users`.`id`=2491911
 1 0.002813 0.002813 0.002813 0.002813
SELECT * FROM `activities` `t` WHERE `t`.`group_id`=:yp0 LIMIT 1
 6 0.001671 0.000279 0.000274 0.000287
SHOW COLUMNS FROM `activities_groups`
 1 0.001579 0.001579 0.001579 0.001579
SHOW COLUMNS FROM `events`
 1 0.001560 0.001560 0.001560 0.001560
SHOW COLUMNS FROM `users`
 1 0.001325 0.001325 0.001325 0.001325
SELECT * FROM `activities` `t` WHERE `group_id` = :id
 3 0.001285 0.000428 0.000319 0.000630
SHOW COLUMNS FROM `activities`
 1 0.001277 0.001277 0.001277 0.001277
SHOW COLUMNS FROM `questionnaires`
 1 0.001204 0.001204 0.001204 0.001204
SHOW COLUMNS FROM `resource_videos`
 1 0.001146 0.001146 0.001146 0.001146
SHOW COLUMNS FROM `resources`
 1 0.001144 0.001144 0.001144 0.001144
SELECT * FROM `users` `t` WHERE session=:session LIMIT 1
 2 0.001105 0.000553 0.000470 0.000635
SHOW COLUMNS FROM `activity_topics`
 1 0.001066 0.001066 0.001066 0.001066
SHOW COLUMNS FROM `questions`
 1 0.001051 0.001051 0.001051 0.001051
SHOW COLUMNS FROM `answers`
 1 0.000981 0.000981 0.000981 0.000981
SHOW COLUMNS FROM `topics`
 1 0.000960 0.000960 0.000960 0.000960
SHOW COLUMNS FROM `events_topics`
 1 0.000936 0.000936 0.000936 0.000936
SHOW COLUMNS FROM `resource_topics`
 1 0.000931 0.000931 0.000931 0.000931
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)
 3 0.000797 0.000266 0.000253 0.000282
SHOW CREATE TABLE `activities_groups`
 1 0.000403 0.000403 0.000403 0.000403
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 (event.id IS NULL)) ORDER BY t.createDate DESC LIMIT 5
 1 0.000399 0.000399 0.000399 0.000399
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.000346 0.000346 0.000346 0.000346
SHOW CREATE TABLE `activities`
 1 0.000327 0.000327 0.000327 0.000327
SELECT * FROM `topics` `t` ORDER BY title
 1 0.000324 0.000324 0.000324 0.000324
SHOW CREATE TABLE `answers`
 1 0.000322 0.000322 0.000322 0.000322
SHOW CREATE TABLE `events`
 1 0.000322 0.000322 0.000322 0.000322
SHOW CREATE TABLE `resources`
 1 0.000320 0.000320 0.000320 0.000320
SHOW CREATE TABLE `users`
 1 0.000320 0.000320 0.000320 0.000320
SHOW CREATE TABLE `questions`
 1 0.000313 0.000313 0.000313 0.000313
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`, `eventTopics`.`id` AS `t1_c0`, `eventTopics`.`event_id` AS `t1_c1`, `eventTopics`.`topic_id` AS `t1_c2` FROM `events` `t` LEFT OUTER JOIN `events_topics` `eventTopics` ON (`eventTopics`.`event_id`=`t`.`id`) WHERE (((t.calendarDate>=:today) AND (t.status = :status_active)) AND (IFNULL(t.group_id, "") = "")) ORDER BY t.calendarDate ASC LIMIT 1
 1 0.000298 0.000298 0.000298 0.000298
SHOW CREATE TABLE `activity_topics`
 1 0.000296 0.000296 0.000296 0.000296
SHOW CREATE TABLE `resource_videos`
 1 0.000295 0.000295 0.000295 0.000295
SHOW CREATE TABLE `resource_topics`
 1 0.000291 0.000291 0.000291 0.000291
SHOW CREATE TABLE `topics`
 1 0.000289 0.000289 0.000289 0.000289
SHOW CREATE TABLE `events_topics`
 1 0.000284 0.000284 0.000284 0.000284
SELECT `t`.`id` AS `t0_c0`, `t`.`type` AS `t0_c1`, `t`.`surveyType` AS `t0_c2`, `t`.`activity_id` AS `t0_c3`, `t`.`title` AS `t0_c4`, `t`.`custom_section` AS `t0_c5`, `t`.`surveySendTime` AS `t0_c6`, `t`.`createDate` AS `t0_c7`, `questions`.`id` AS `t1_c0`, `questions`.`questionnaire_id` AS `t1_c1`, `questions`.`title` AS `t1_c2`, `questions`.`type` AS `t1_c3`, `questions`.`score` AS `t1_c4`, `questions`.`sort` AS `t1_c5`, `questions`.`createDate` AS `t1_c6`, `questions`.`align` AS `t1_c7`, `questions`.`is_required` AS `t1_c8`, `questions`.`special_type` AS `t1_c9`, `answers`.`id` AS `t2_c0`, `answers`.`question_id` AS `t2_c1`, `answers`.`sort` AS `t2_c2`, `answers`.`text` AS `t2_c3`, `answers`.`rationale` AS `t2_c4`, `answers`.`correct` AS `t2_c5` FROM `questionnaires` `t` LEFT OUTER JOIN `questions` `questions` ON (`questions`.`questionnaire_id`=`t`.`id`) LEFT OUTER JOIN `answers` `answers` ON (`answers`.`question_id`=`questions`.`id`) WHERE (t.type = :type AND questions.sort=0) ORDER BY answers.sort ASC, questions.sort ASC, answers.sort ASC
 1 0.000280 0.000280 0.000280 0.000280
SHOW CREATE TABLE `questionnaires`
 1 0.000276 0.000276 0.000276 0.000276
# Query Time (s)
0
UPDATE activities SET archived=1 WHERE finishDate<now();
 0.006452
1
UPDATE activities_groups SET archived=1 WHERE finishDate<now();
 0.003168
2
SHOW COLUMNS FROM `activities_groups`
 0.001579
3
SHOW CREATE TABLE `activities_groups`
 0.000403
4
SHOW COLUMNS FROM `activities`
 0.001277
5
SHOW CREATE TABLE `activities`
 0.000327
6
SHOW COLUMNS FROM `users`
 0.001325
7
SHOW CREATE TABLE `users`
 0.000320
8
SELECT * FROM `users` `t` WHERE session=:session LIMIT 1
 0.000470
9
INSERT INTO `users` (`role`, `sendEmails`, `sendSms`, `source`, `session`, `lastLogin`, `phone`, `createDate`) VALUES (:yp0, :yp1, :yp2, :yp3, :yp4, :yp5, :yp6, :yp7)
 0.003644
10
SELECT * FROM `users` `t` WHERE session=:session LIMIT 1
 0.000635
11
UPDATE `users` SET `lastLogin`=:yp0 WHERE `users`.`id`=2491911
 0.002813
12
SHOW COLUMNS FROM `topics`
 0.000960
13
SHOW CREATE TABLE `topics`
 0.000289
14
SHOW COLUMNS FROM `activity_topics`
 0.001066
15
SHOW CREATE TABLE `activity_topics`
 0.000296
16
SELECT `t`.`id` AS `t0_c0`, `t`.`resources_id` AS `t0_c1`, `t`.`title` AS `t0_c2`, `t`.`sub_title` AS `t0_c3`, `t`.`description` AS `t0_c4`, `t`.`facultyNames` AS `t0_c5`, `t`.`sponsors` AS `t0_c6`, `t`.`status` AS `t0_c7`, `t`.`archived` AS `t0_c8`, `t`.`image` AS `t0_c9`, `t`.`shortlink` AS `t0_c10`, `t`.`startDate` AS `t0_c11`, `t`.`finishDate` AS `t0_c12`, `t`.`createDate` AS `t0_c13`, `t`.`newActivityAddDate` AS `t0_c14`, `t`.`type` AS `t0_c15`, `t`.`image_featured` AS `t0_c16`, `t`.`shortDescription` AS `t0_c17`, `t`.`activitiesOrdering` AS `t0_c18`, `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`, `topics`.`id` AS `t2_c0`, `topics`.`title` AS `t2_c1`, `topics`.`url` AS `t2_c2`, `topics`.`sort` AS `t2_c3` FROM `activities_groups` `t` LEFT OUTER JOIN `activities` `activities` ON (`activities`.`group_id`=`t`.`id`) LEFT OUTER JOIN `activity_topics` `topics_topics` ON (`activities`.`id`=`topics_topics`.`activity_id`) LEFT OUTER JOIN `topics` `topics` ON (`topics`.`id`=`topics_topics`.`topic_id`) WHERE ((t.status = :status_active) AND (t.archived=0)) ORDER BY t.createDate DESC
 0.003210
17
SHOW COLUMNS FROM `events`
 0.001560
18
SHOW CREATE TABLE `events`
 0.000322
19
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 (event.id IS NULL)) ORDER BY t.createDate DESC LIMIT 5
 0.000399
20
SHOW COLUMNS FROM `resources`
 0.001144
21
SHOW CREATE TABLE `resources`
 0.000320
22
SHOW COLUMNS FROM `resource_topics`
 0.000931
23
SHOW CREATE TABLE `resource_topics`
 0.000291
24
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`, `topics`.`id` AS `t1_c0`, `topics`.`title` AS `t1_c1`, `topics`.`url` AS `t1_c2`, `topics`.`sort` AS `t1_c3` FROM `resources` `t` LEFT OUTER JOIN `resource_topics` `topics_topics` ON (`t`.`id`=`topics_topics`.`resource_id`) LEFT OUTER JOIN `topics` `topics` ON (`topics`.`id`=`topics_topics`.`topic_id`) WHERE ((t.archived=0) AND (t.status = :status_active)) ORDER BY t.createDate DESC
 0.028961
25
SHOW COLUMNS FROM `questionnaires`
 0.001204
26
SHOW CREATE TABLE `questionnaires`
 0.000276
27
SHOW COLUMNS FROM `questions`
 0.001051
28
SHOW CREATE TABLE `questions`
 0.000313
29
SHOW COLUMNS FROM `answers`
 0.000981
30
SHOW CREATE TABLE `answers`
 0.000322
31
SELECT `t`.`id` AS `t0_c0`, `t`.`type` AS `t0_c1`, `t`.`surveyType` AS `t0_c2`, `t`.`activity_id` AS `t0_c3`, `t`.`title` AS `t0_c4`, `t`.`custom_section` AS `t0_c5`, `t`.`surveySendTime` AS `t0_c6`, `t`.`createDate` AS `t0_c7`, `questions`.`id` AS `t1_c0`, `questions`.`questionnaire_id` AS `t1_c1`, `questions`.`title` AS `t1_c2`, `questions`.`type` AS `t1_c3`, `questions`.`score` AS `t1_c4`, `questions`.`sort` AS `t1_c5`, `questions`.`createDate` AS `t1_c6`, `questions`.`align` AS `t1_c7`, `questions`.`is_required` AS `t1_c8`, `questions`.`special_type` AS `t1_c9`, `answers`.`id` AS `t2_c0`, `answers`.`question_id` AS `t2_c1`, `answers`.`sort` AS `t2_c2`, `answers`.`text` AS `t2_c3`, `answers`.`rationale` AS `t2_c4`, `answers`.`correct` AS `t2_c5` FROM `questionnaires` `t` LEFT OUTER JOIN `questions` `questions` ON (`questions`.`questionnaire_id`=`t`.`id`) LEFT OUTER JOIN `answers` `answers` ON (`answers`.`question_id`=`questions`.`id`) WHERE (t.type = :type AND questions.sort=0) ORDER BY answers.sort ASC, questions.sort ASC, answers.sort ASC
 0.000280
32
SELECT * FROM `topics` `t` ORDER BY title
 0.000324
33
SELECT * FROM `activities` `t` WHERE `group_id` = :id
 0.000630
34
SELECT * FROM `activities` `t` WHERE `t`.`group_id`=:yp0 LIMIT 1
 0.000287
35
SELECT * FROM `activities` `t` WHERE `t`.`group_id`=:yp0 LIMIT 1
 0.000278
36
SELECT * FROM `activities` `t` WHERE `group_id` = :id
 0.000336
37
SELECT * FROM `activities` `t` WHERE `t`.`group_id`=:yp0 LIMIT 1
 0.000279
38
SELECT * FROM `activities` `t` WHERE `t`.`group_id`=:yp0 LIMIT 1
 0.000274
39
SELECT * FROM `activities` `t` WHERE `group_id` = :id
 0.000319
40
SELECT * FROM `activities` `t` WHERE `t`.`group_id`=:yp0 LIMIT 1
 0.000275
41
SELECT * FROM `activities` `t` WHERE `t`.`group_id`=:yp0 LIMIT 1
 0.000278
42
SHOW COLUMNS FROM `resource_videos`
 0.001146
43
SHOW CREATE TABLE `resource_videos`
 0.000295
44
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.000282
45
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.000253
46
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.000262
47
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.000346
48
SHOW COLUMNS FROM `events_topics`
 0.000936
49
SHOW CREATE TABLE `events_topics`
 0.000284
50
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`, `eventTopics`.`id` AS `t1_c0`, `eventTopics`.`event_id` AS `t1_c1`, `eventTopics`.`topic_id` AS `t1_c2` FROM `events` `t` LEFT OUTER JOIN `events_topics` `eventTopics` ON (`eventTopics`.`event_id`=`t`.`id`) WHERE (((t.calendarDate>=:today) AND (t.status = :status_active)) AND (IFNULL(t.group_id, "") = "")) ORDER BY t.calendarDate ASC LIMIT 1
 0.000298
Log Messages
Message (details) Level Category Time