BRIDGE HCV

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

The BRIDGE HCV initiative encourages medical specialists, primary care clinicians, and substance use disorders (SUD)–services providers to actively expand treatment of chronic hepatitis C virus (HCV) infection to include individuals with recent or ongoing injection drug use. This can lead to substantial reductions in HCV prevalence and transmission, benefiting both the individual and the community. These benefits are especially effective when combined with harm-reduction interventions. Strong local HCV-care networks with structured collaboration further help build bridges to HCV-infected people who inject drugs (PWID) and allow these at-risk individuals access to highly effective direct-acting antiviral therapies. This 2-part educational series offers cutting-edge strategies for collaboratively reaching and treating HCV-positive PWID. Presenting the critical balance between clinical data and real-world experience and insights, these activities will give participants the opportunity to listen to nationally recognized HCV experts as they discuss these topics and offer hands-on tactics and practical resources to use in the clinical setting.

Jointly provided by Purdue University College of Pharmacy and Integritas Communications.

 

This activity is supported by independent educational grants from Gilead Sciences, Inc., and AbbVie, Inc.

Image Webcast
HCV in People Who Inject Drugs

A Call to Action for Frontline Providers

Beth A. Dunlap, MD; Stacey B. Trooskin, MD, PhD, MPH
MODULE 1
Begin Activity

credit amount 0.75

credit type CME

expiration 12/07/2021

Image Webcast
Addressing the Real-World Challenge of HCV Cure in People Who Inject Drugs

Opportunities for Current and New HCV Treaters

Andrew I. Aronsohn, MD; Stacey B. Trooskin, MD, PhD, MPH
MODULE 2
Begin Activity

credit amount 0.75

credit type CME

expiration 12/07/2021

Resource

BRIDGE HCV

Building Bridges to Reach People Who Inject Drugs With the Goal to Eliminate HCV
TOOLBAR

Yii 1.1.12

Request
Request Server Parameters
USER 'www-data'
HOME '/var/www'
HTTP_CONNECTION 'Keep-Alive'
HTTP_HOST 'www.exchangecme.com'
HTTP_ACCEPT_ENCODING 'br,gzip'
HTTP_IF_MODIFIED_SINCE 'Wed, 23 Jun 2021 05:40:39 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 '53906'
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/bridgehcvpwid'
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 1632354384.1626
REQUEST_TIME 1632354384
Request Cookies
Session Attributes
Request GET Parameters
group 'bridgehcvpwid'
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.042516s)

Connection ID: db (CDbConnection)

Driver mysql
Server Version 5.5.59-0ubuntu0.14.04.1
Uptime 14w 1d 6h 45m 48s
Threads 1
Questions 40793811
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`.`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=28)) AND (event.id IS NULL)) ORDER BY t.createDate DESC
1 0.010300 0.010300 0.010300 0.010300
UPDATE activities SET archived=1 WHERE finishDate<now();
1 0.005828 0.005828 0.005828 0.005828
SELECT * FROM `user_activitiesstatus` `t` WHERE `t`.`user_id` IS NULL AND `t`.`activity_id`=:yp0 LIMIT 1
12 0.003679 0.000307 0.000241 0.000498
INSERT INTO `users` (`role`, `sendEmails`, `sendSms`, `source`, `session`, `lastLogin`, `phone`, `createDate`) VALUES (:yp0, :yp1, :yp2, :yp3, :yp4, :yp5, :yp6, :yp7)
1 0.003653 0.003653 0.003653 0.003653
UPDATE `users` SET `lastLogin`=:yp0 WHERE `users`.`id`=2491887
1 0.002950 0.002950 0.002950 0.002950
SHOW COLUMNS FROM `activities`
1 0.001654 0.001654 0.001654 0.001654
SHOW COLUMNS FROM `events`
1 0.001591 0.001591 0.001591 0.001591
SHOW COLUMNS FROM `users`
1 0.001223 0.001223 0.001223 0.001223
SHOW COLUMNS FROM `activities_groups`
1 0.001217 0.001217 0.001217 0.001217
SHOW COLUMNS FROM `resources`
1 0.001136 0.001136 0.001136 0.001136
SHOW COLUMNS FROM `user_activitiesstatus`
1 0.000996 0.000996 0.000996 0.000996
SELECT * FROM `users` `t` WHERE session=:session LIMIT 1
2 0.000981 0.000491 0.000462 0.000519
SHOW COLUMNS FROM `interactions`
1 0.000959 0.000959 0.000959 0.000959
SHOW COLUMNS FROM `topics`
1 0.000935 0.000935 0.000935 0.000935
SHOW COLUMNS FROM `activity_topics`
1 0.000912 0.000912 0.000912 0.000912
SELECT * FROM `activities_groups` `t` WHERE `t`.`id`=28 LIMIT 1
1 0.000457 0.000457 0.000457 0.000457
select id from activities_groups where FIND_IN_SET(:shortAddress, shortlink)
1 0.000436 0.000436 0.000436 0.000436
SELECT * FROM `resources` `t` WHERE `t`.`id`=156 LIMIT 1
1 0.000435 0.000435 0.000435 0.000435
SHOW CREATE TABLE `activities`
1 0.000375 0.000375 0.000375 0.000375
SHOW CREATE TABLE `activities_groups`
1 0.000371 0.000371 0.000371 0.000371
SHOW CREATE TABLE `events`
1 0.000369 0.000369 0.000369 0.000369
SHOW CREATE TABLE `user_activitiesstatus`
1 0.000338 0.000338 0.000338 0.000338
SHOW CREATE TABLE `users`
1 0.000330 0.000330 0.000330 0.000330
SHOW CREATE TABLE `resources`
1 0.000303 0.000303 0.000303 0.000303
SELECT * FROM `activities` `t` WHERE `t`.`id` IS NULL LIMIT 1
1 0.000278 0.000278 0.000278 0.000278
SHOW CREATE TABLE `interactions`
1 0.000272 0.000272 0.000272 0.000272
SHOW CREATE TABLE `activity_topics`
1 0.000270 0.000270 0.000270 0.000270
SHOW CREATE TABLE `topics`
1 0.000267 0.000267 0.000267 0.000267
# Query Time (s)
0
SHOW COLUMNS FROM `activities`
0.001654
1
SHOW CREATE TABLE `activities`
0.000375
2
SHOW COLUMNS FROM `users`
0.001223
3
SHOW CREATE TABLE `users`
0.000330
4
SELECT * FROM `users` `t` WHERE session=:session LIMIT 1
0.000519
5
INSERT INTO `users` (`role`, `sendEmails`, `sendSms`, `source`, `session`, `lastLogin`, `phone`, `createDate`) VALUES (:yp0, :yp1, :yp2, :yp3, :yp4, :yp5, :yp6, :yp7)
0.003653
6
SELECT * FROM `users` `t` WHERE session=:session LIMIT 1
0.000462
7
UPDATE `users` SET `lastLogin`=:yp0 WHERE `users`.`id`=2491887
0.002950
8
SELECT * FROM `activities` `t` WHERE `t`.`id` IS NULL LIMIT 1
0.000278
9
UPDATE activities SET archived=1 WHERE finishDate<now();
0.005828
10
select id from activities_groups where FIND_IN_SET(:shortAddress, shortlink)
0.000436
11
SHOW COLUMNS FROM `activities_groups`
0.001217
12
SHOW CREATE TABLE `activities_groups`
0.000371
13
SELECT * FROM `activities_groups` `t` WHERE `t`.`id`=28 LIMIT 1
0.000457
14
SHOW COLUMNS FROM `resources`
0.001136
15
SHOW CREATE TABLE `resources`
0.000303
16
SELECT * FROM `resources` `t` WHERE `t`.`id`=156 LIMIT 1
0.000435
17
SHOW COLUMNS FROM `topics`
0.000935
18
SHOW CREATE TABLE `topics`
0.000267
19
SHOW COLUMNS FROM `events`
0.001591
20
SHOW CREATE TABLE `events`
0.000369
21
SHOW COLUMNS FROM `interactions`
0.000959
22
SHOW CREATE TABLE `interactions`
0.000272
23
SHOW COLUMNS FROM `activity_topics`
0.000912
24
SHOW CREATE TABLE `activity_topics`
0.000270
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=28)) AND (event.id IS NULL)) ORDER BY t.createDate DESC
0.010300
26
SHOW COLUMNS FROM `user_activitiesstatus`
0.000996
27
SHOW CREATE TABLE `user_activitiesstatus`
0.000338
28
SELECT * FROM `user_activitiesstatus` `t` WHERE `t`.`user_id` IS NULL AND `t`.`activity_id`=:yp0 LIMIT 1
0.000344
29
SELECT * FROM `user_activitiesstatus` `t` WHERE `t`.`user_id` IS NULL AND `t`.`activity_id`=:yp0 LIMIT 1
0.000254
30
SELECT * FROM `user_activitiesstatus` `t` WHERE `t`.`user_id` IS NULL AND `t`.`activity_id`=:yp0 LIMIT 1
0.000247
31
SELECT * FROM `user_activitiesstatus` `t` WHERE `t`.`user_id` IS NULL AND `t`.`activity_id`=:yp0 LIMIT 1
0.000498
32
SELECT * FROM `user_activitiesstatus` `t` WHERE `t`.`user_id` IS NULL AND `t`.`activity_id`=:yp0 LIMIT 1
0.000348
33
SELECT * FROM `user_activitiesstatus` `t` WHERE `t`.`user_id` IS NULL AND `t`.`activity_id`=:yp0 LIMIT 1
0.000252
34
SELECT * FROM `user_activitiesstatus` `t` WHERE `t`.`user_id` IS NULL AND `t`.`activity_id`=:yp0 LIMIT 1
0.000454
35
SELECT * FROM `user_activitiesstatus` `t` WHERE `t`.`user_id` IS NULL AND `t`.`activity_id`=:yp0 LIMIT 1
0.000271
36
SELECT * FROM `user_activitiesstatus` `t` WHERE `t`.`user_id` IS NULL AND `t`.`activity_id`=:yp0 LIMIT 1
0.000243
37
SELECT * FROM `user_activitiesstatus` `t` WHERE `t`.`user_id` IS NULL AND `t`.`activity_id`=:yp0 LIMIT 1
0.000262
38
SELECT * FROM `user_activitiesstatus` `t` WHERE `t`.`user_id` IS NULL AND `t`.`activity_id`=:yp0 LIMIT 1
0.000265
39
SELECT * FROM `user_activitiesstatus` `t` WHERE `t`.`user_id` IS NULL AND `t`.`activity_id`=:yp0 LIMIT 1
0.000241
Log Messages
Message (details) Level Category Time