HIV Experts & Evidenceā„¢

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

 

Target Audience

This two-part activity is intended for infectious diseases and human immunodeficiency virus (HIV)-specialist physicians and other clinicians and stakeholders involved in the care of patients with HIV infection.

 

Program Overview

Guideline-based rapid initiation of antiretroviral therapy (ART) for treatment of HIV is now the standard of care. Best-practice rapid ART protocols promote immediate linkage to HIV care, decreased time to ART initiation, decreased time to viral suppression (VS), and long-term VS — even within vulnerable populations. Shorter time to VS is associated with decreases in the incidence of both AIDS- and non-AIDS–related events. It further benefits the individual’s partners and at-risk populations by decreasing the period of time during which the virus is transmittable. This informs the Undetectable Equals Untransmittable (U=U) initiative, which serves not only the public health goal of ending the HIV/AIDS pandemic, but also brings equity to HIV care for vulnerable populations. Geared to the needs of HIV-specialist clinicians, this two-part HIV Experts and Evidence™ enduring activity will address rapid ART guidelines, provide practical solutions to systemic and clinical barriers that can impede access to rapid ART regimens and retention in care, and real-world approaches to enhanced patient-centered services.

This two-part activity is jointly provided by Global Education Group and Integritas Communications.

 

This two-part activity is supported by an independent educational grant from Gilead Sciences, Inc.

 

Evolving Models of HIV Care - Part 1

Rapid ART Initiation: A Key Strategy for Ending the HIV Epidemic

Jonathan A. Colasanti, MD, MSPH; Jason Halperin, MD, MPH
MODULE 1
Begin Activity

credit amount 0.75

credit type CME/CE

expiration 03/29/2022

Evolving Models of HIV Care - Part 2

Overcoming Barriers: Successful Rapid ART Initiation

Jonathan A. Colasanti, MD, MSPH; Jason Halperin, MD, MPH
MODULE 2
Begin Activity

credit amount 0.75

credit type CME/CE

expiration 03/29/2022

Resource

Evolving Models of HIV Care (Volume 3)

The Rapid ART Standard of Care: From Evidence to Healthcare Equity
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:54:13 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 '41020'
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 '/groups/RapidART'
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 1632357799.5777
REQUEST_TIME 1632357799
Request Cookies
Session Attributes
Request GET Parameters
group 'RapidART'
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 = \'/resources/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 ActivitiesController
Context class ActivitiesController
Inheritance CommonActivitiesController » Controller » CController » CBaseController
Defined in file protected/controllers/ActivitiesController.php
Context properties
  •  => 
  •  => 
  •  => 
  •  => 
  •  => 
Route activities/group
Action CInlineAction (group)
Action params
  •  => 
Render methodrenderPartial
View file themes/desktop/views/activities/groups.php
View data
  •  => 
  •  => 
  •  => 
  •  => 
Context ActivitiesController
Context class ActivitiesController
Inheritance CommonActivitiesController » Controller » CController » CBaseController
Defined in file protected/controllers/ActivitiesController.php
Context properties
  •  => 
  •  => 
  •  => 
  •  => 
  •  => 
Route activities/group
Action CInlineAction (group)
Action params
  •  => 
Render methodrender
View file protected/views/layouts/column1.php
Context ActivitiesController
Context class ActivitiesController
Inheritance CommonActivitiesController » Controller » CController » CBaseController
Defined in file protected/controllers/ActivitiesController.php
Context properties
  •  => 
  •  => 
  •  => 
  •  => 
  •  => 
Route activities/group
Action CInlineAction (group)
Action params
  •  => 
Render methodrender
View file themes/desktop/views/layouts/main.php
Context ActivitiesController
Context class ActivitiesController
Inheritance CommonActivitiesController » Controller » CController » CBaseController
Defined in file protected/controllers/ActivitiesController.php
Context properties
  •  => 
  •  => 
  •  => 
  •  => 
  •  => 
Route activities/group
Action CInlineAction (group)
Action params
  •  => 
Render methodrenderPartial
View file themes/desktop/views/common/_footer.php
View data
    null
Context ActivitiesController
Context class ActivitiesController
Inheritance CommonActivitiesController » Controller » CController » CBaseController
Defined in file protected/controllers/ActivitiesController.php
Context properties
  •  => 
  •  => 
  •  => 
  •  => 
  •  => 
Route activities/group
Action CInlineAction (group)
Action params
  •  => 
Render methodrenderPartial
View file themes/desktop/views/common/elasticsearch.php
View data
    null
Context YiiDebugToolbarResourceUsage
Context class YiiDebugToolbarResourceUsage
Inheritance CWidget » CBaseController
Defined in file protected/extensions/malyshev/yii-debug-toolbar/widgets/YiiDebugToolbarResourceUsage.php
Context properties
  •  => 
  •  => 
  •  => 
Render methodrender
View file protected/extensions/malyshev/yii-debug-toolbar/widgets/views/resources.php
View data
  •  => 
SQL Queries from 1 connection (40/0.042308s)

Connection ID: db (CDbConnection)

Driver mysql
Server Version 5.5.59-0ubuntu0.14.04.1
Uptime 14w 1d 7h 42m 43s
Threads 1
Questions 40797904
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`.`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`, `topics`.`id` AS `t1_c0`, `topics`.`title` AS `t1_c1`, `topics`.`url` AS `t1_c2`, `topics`.`sort` 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`, `interaction`.`id` AS `t3_c0`, `interaction`.`activity_id` AS `t3_c1`, `interaction`.`title` AS `t3_c2`, `interaction`.`link` AS `t3_c3`, `interaction`.`type` AS `t3_c4`, `interaction`.`status` AS `t3_c5`, `interaction`.`createDate` AS `t3_c6` FROM `activities` `t` LEFT OUTER JOIN `activity_topics` `topics_topics` ON (`t`.`id`=`topics_topics`.`activity_id`) LEFT OUTER JOIN `topics` `topics` ON (`topics`.`id`=`topics_topics`.`topic_id`) LEFT OUTER JOIN `events` `event` ON (`event`.`activity_id`=`t`.`id`) LEFT OUTER JOIN `interactions` `interaction` ON (`interaction`.`activity_id`=`t`.`id`) WHERE ((((t.status = :status_active) AND (t.archived=0)) AND (t.group_id=29)) AND (event.id IS NULL)) ORDER BY t.createDate DESC
1 0.007886 0.007886 0.007886 0.007886
UPDATE activities SET archived=1 WHERE finishDate<now();
1 0.006536 0.006536 0.006536 0.006536
INSERT INTO `users` (`role`, `sendEmails`, `sendSms`, `source`, `session`, `lastLogin`, `phone`, `createDate`) VALUES (:yp0, :yp1, :yp2, :yp3, :yp4, :yp5, :yp6, :yp7)
1 0.003978 0.003978 0.003978 0.003978
UPDATE `users` SET `lastLogin`=:yp0 WHERE `users`.`id`=2491955
1 0.003854 0.003854 0.003854 0.003854
SELECT * FROM `user_activitiesstatus` `t` WHERE `t`.`user_id` IS NULL AND `t`.`activity_id`=:yp0 LIMIT 1
12 0.003798 0.000316 0.000212 0.000845
SHOW COLUMNS FROM `activities`
1 0.001692 0.001692 0.001692 0.001692
SHOW COLUMNS FROM `events`
1 0.001407 0.001407 0.001407 0.001407
SHOW COLUMNS FROM `activities_groups`
1 0.001285 0.001285 0.001285 0.001285
SHOW COLUMNS FROM `users`
1 0.001240 0.001240 0.001240 0.001240
SHOW COLUMNS FROM `resources`
1 0.001092 0.001092 0.001092 0.001092
SHOW COLUMNS FROM `user_activitiesstatus`
1 0.001021 0.001021 0.001021 0.001021
SELECT * FROM `users` `t` WHERE session=:session LIMIT 1
2 0.000992 0.000496 0.000459 0.000533
SHOW COLUMNS FROM `topics`
1 0.000984 0.000984 0.000984 0.000984
SHOW COLUMNS FROM `interactions`
1 0.000981 0.000981 0.000981 0.000981
SHOW COLUMNS FROM `activity_topics`
1 0.000919 0.000919 0.000919 0.000919
SELECT * FROM `resources` `t` WHERE `t`.`id`=148 LIMIT 1
1 0.000621 0.000621 0.000621 0.000621
SELECT * FROM `activities_groups` `t` WHERE `t`.`id`=29 LIMIT 1
1 0.000423 0.000423 0.000423 0.000423
select id from activities_groups where FIND_IN_SET(:shortAddress, shortlink)
1 0.000414 0.000414 0.000414 0.000414
SHOW CREATE TABLE `users`
1 0.000392 0.000392 0.000392 0.000392
SHOW CREATE TABLE `activities_groups`
1 0.000375 0.000375 0.000375 0.000375
SHOW CREATE TABLE `activities`
1 0.000374 0.000374 0.000374 0.000374
SHOW CREATE TABLE `events`
1 0.000333 0.000333 0.000333 0.000333
SELECT * FROM `activities` `t` WHERE `t`.`id` IS NULL LIMIT 1
1 0.000295 0.000295 0.000295 0.000295
SHOW CREATE TABLE `activity_topics`
1 0.000295 0.000295 0.000295 0.000295
SHOW CREATE TABLE `user_activitiesstatus`
1 0.000287 0.000287 0.000287 0.000287
SHOW CREATE TABLE `resources`
1 0.000286 0.000286 0.000286 0.000286
SHOW CREATE TABLE `topics`
1 0.000275 0.000275 0.000275 0.000275
SHOW CREATE TABLE `interactions`
1 0.000273 0.000273 0.000273 0.000273
# Query Time (s)
0
SHOW COLUMNS FROM `activities`
0.001692
1
SHOW CREATE TABLE `activities`
0.000374
2
SHOW COLUMNS FROM `users`
0.001240
3
SHOW CREATE TABLE `users`
0.000392
4
SELECT * FROM `users` `t` WHERE session=:session LIMIT 1
0.000533
5
INSERT INTO `users` (`role`, `sendEmails`, `sendSms`, `source`, `session`, `lastLogin`, `phone`, `createDate`) VALUES (:yp0, :yp1, :yp2, :yp3, :yp4, :yp5, :yp6, :yp7)
0.003978
6
SELECT * FROM `users` `t` WHERE session=:session LIMIT 1
0.000459
7
UPDATE `users` SET `lastLogin`=:yp0 WHERE `users`.`id`=2491955
0.003854
8
SELECT * FROM `activities` `t` WHERE `t`.`id` IS NULL LIMIT 1
0.000295
9
UPDATE activities SET archived=1 WHERE finishDate<now();
0.006536
10
select id from activities_groups where FIND_IN_SET(:shortAddress, shortlink)
0.000414
11
SHOW COLUMNS FROM `activities_groups`
0.001285
12
SHOW CREATE TABLE `activities_groups`
0.000375
13
SELECT * FROM `activities_groups` `t` WHERE `t`.`id`=29 LIMIT 1
0.000423
14
SHOW COLUMNS FROM `resources`
0.001092
15
SHOW CREATE TABLE `resources`
0.000286
16
SELECT * FROM `resources` `t` WHERE `t`.`id`=148 LIMIT 1
0.000621
17
SHOW COLUMNS FROM `topics`
0.000984
18
SHOW CREATE TABLE `topics`
0.000275
19
SHOW COLUMNS FROM `events`
0.001407
20
SHOW CREATE TABLE `events`
0.000333
21
SHOW COLUMNS FROM `interactions`
0.000981
22
SHOW CREATE TABLE `interactions`
0.000273
23
SHOW COLUMNS FROM `activity_topics`
0.000919
24
SHOW CREATE TABLE `activity_topics`
0.000295
25
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`, `topics`.`id` AS `t1_c0`, `topics`.`title` AS `t1_c1`, `topics`.`url` AS `t1_c2`, `topics`.`sort` 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`, `interaction`.`id` AS `t3_c0`, `interaction`.`activity_id` AS `t3_c1`, `interaction`.`title` AS `t3_c2`, `interaction`.`link` AS `t3_c3`, `interaction`.`type` AS `t3_c4`, `interaction`.`status` AS `t3_c5`, `interaction`.`createDate` AS `t3_c6` FROM `activities` `t` LEFT OUTER JOIN `activity_topics` `topics_topics` ON (`t`.`id`=`topics_topics`.`activity_id`) LEFT OUTER JOIN `topics` `topics` ON (`topics`.`id`=`topics_topics`.`topic_id`) LEFT OUTER JOIN `events` `event` ON (`event`.`activity_id`=`t`.`id`) LEFT OUTER JOIN `interactions` `interaction` ON (`interaction`.`activity_id`=`t`.`id`) WHERE ((((t.status = :status_active) AND (t.archived=0)) AND (t.group_id=29)) AND (event.id IS NULL)) ORDER BY t.createDate DESC
0.007886
26
SHOW COLUMNS FROM `user_activitiesstatus`
0.001021
27
SHOW CREATE TABLE `user_activitiesstatus`
0.000287
28
SELECT * FROM `user_activitiesstatus` `t` WHERE `t`.`user_id` IS NULL AND `t`.`activity_id`=:yp0 LIMIT 1
0.000338
29
SELECT * FROM `user_activitiesstatus` `t` WHERE `t`.`user_id` IS NULL AND `t`.`activity_id`=:yp0 LIMIT 1
0.000326
30
SELECT * FROM `user_activitiesstatus` `t` WHERE `t`.`user_id` IS NULL AND `t`.`activity_id`=:yp0 LIMIT 1
0.000281
31
SELECT * FROM `user_activitiesstatus` `t` WHERE `t`.`user_id` IS NULL AND `t`.`activity_id`=:yp0 LIMIT 1
0.000214
32
SELECT * FROM `user_activitiesstatus` `t` WHERE `t`.`user_id` IS NULL AND `t`.`activity_id`=:yp0 LIMIT 1
0.000218
33
SELECT * FROM `user_activitiesstatus` `t` WHERE `t`.`user_id` IS NULL AND `t`.`activity_id`=:yp0 LIMIT 1
0.000268
34
SELECT * FROM `user_activitiesstatus` `t` WHERE `t`.`user_id` IS NULL AND `t`.`activity_id`=:yp0 LIMIT 1
0.000319
35
SELECT * FROM `user_activitiesstatus` `t` WHERE `t`.`user_id` IS NULL AND `t`.`activity_id`=:yp0 LIMIT 1
0.000845
36
SELECT * FROM `user_activitiesstatus` `t` WHERE `t`.`user_id` IS NULL AND `t`.`activity_id`=:yp0 LIMIT 1
0.000267
37
SELECT * FROM `user_activitiesstatus` `t` WHERE `t`.`user_id` IS NULL AND `t`.`activity_id`=:yp0 LIMIT 1
0.000264
38
SELECT * FROM `user_activitiesstatus` `t` WHERE `t`.`user_id` IS NULL AND `t`.`activity_id`=:yp0 LIMIT 1
0.000212
39
SELECT * FROM `user_activitiesstatus` `t` WHERE `t`.`user_id` IS NULL AND `t`.`activity_id`=:yp0 LIMIT 1
0.000245
Log Messages
Message (details) Level Category Time