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

Suggested Reading


Review
Engaging the Patient
MINIMIZING PATIENT RISKS FROM COVID-19

An Update on Monoclonal Antibody Therapies

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

Suggested Reading



Review
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 '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