Online 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
Image Monograph
Expanding HIV Prevention in Colorado—and Nationwide

A PEP/PrEP Training Guide for Pharmacists

Dan Scales, Pharm D, AAHIVP; Emily Zadvorny, PharmD, BCPS

credit amount 2.00

credit type ACPE

expiration 02/16/2022


More Information
Image POC201
Coming up for Air to Manage Patients With Severe Asthma

International

Ian Pavord, MBBS, MA, DM, FRCP, FERS, FMedSci; Klaus Rabe, MD

credit amount 1.00

credit type CME/CE

expiration 01/29/2022


More Information
Image Webcast
What's New in Systemic Lupus Erythematosus?

Unlocking Novel Paths to Patient Care

Richard A. Furie, MD; Elena M. Massarotti, MD; Eric Morand, MBBS (Hons), PhD, FRACP

credit amount 2.00

credit type CME/CE

expiration 12/31/2021


More Information
Image Webcast
BRIDGE HCV

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

Andrew I. Aronsohn, MD; Beth A. Dunlap, MD; Stacey B. Trooskin, MD, PhD, MPH

credit amount 1.50

credit type CME

expiration 12/07/2021


More Information
Image POC201
Updates on Chronic Rhinosinusitis With Nasal Polyps

Evolving Best Practices for Patient Management

Cecelia Damask, DO, FAAOA; Matthew W. Ryan, MD

credit amount 1.00

credit type CME

expiration 11/13/2021


More Information
Image eHealthSource
Finding the Path in Alzheimer’s Disease

Early Diagnosis to Ongoing Collaborative Care

Sharon Cohen, MD, FRCPC; R. Scott Turner, MD, PhD

credit amount 1.75

credit type CME/AANP

expiration 11/20/2021


More Information
Image Webcast
Case Challenges in HIV Medicine

Benefits, Barriers, & Best Practices in an Advancing Field

Richard A. Elion, MD; Eric S. Daar, MD; Seble G. Kassaye, MD, MS; Leandro A. Mena, MD, MPH

credit amount 1.50

credit type CME/CE

expiration 10/30/2021


More Information
Image SnapShot
Clinical SnapShots of Moderate-to-Severe Atopic Dermatitis

Pathophysiology, Multimodal Management, and Shared Clinical Decision Making

Melinda Gooderham, MSc, MD, FRCPC; Diamant Thaҫi, MD

credit amount 1.00

credit type CME/CE

expiration 10/30/2021


More Information
Image POC101
The Pharmacist’s Role in Ending the HIV Epidemic

Information You Need to Keep Your Practice Up to Date

James D. Scott, PharmD, FCCP, APh, AAHIVP; Lucas Hill, PharmD, BCACP, AAHIVP

credit amount 1.00

credit type ACPE

expiration 10/16/2021


More Information
Image POC101
HIV Updates for Pharmacy Practice

Maximizing Your Role to Impact Patient Outcomes

Jennifer Cocohoba, PharmD; Jason J. Schafer, PharmD

credit amount 2.00

credit type ACPE

expiration 10/09/2021


More Information
Image Webcast
Primary Care Is PrEP’d for Prevention

Optimizing Sexual Health and Decreasing HIV Risk

Jason Halperin, MD, MPH; Neil Skolnik, MD; Isolde Butler, MD, MPH

credit amount 1.00

credit type CME/CE

expiration 10/04/2021


More Information
Image Webcast
COPD Cases and Conversations

A Focus on Exacerbation Prevention

Charles P. Vega, MD, FAAFP

credit amount 1.00

credit type CME/AANP

expiration 10/16/2021


More Information
Image
Trending Clinical Issues Influencing HIV Practice Today

An Online and Mobile Mini-Curriculum

Jonathan A Colasanti, MD, MSPH; Richard Elion, MD; W. David Hardy, MD, AAHIVS; Glenn Jordan Treisman, M.D., Ph.D.

credit amount 1.50

credit type CME

expiration 10/01/2021


More Information
Image Webcast Series
The Role of JAK Inhibitors in Closing Gaps in RA Management

Modules 1-3

Stanley B. Cohen, MD; Madelaine A. Feldman, MD, FACR; Vibeke Strand, MD, MACR, FACP

credit amount 1.00

credit type CME/CE

expiration 09/24/2021


More Information
Image POC101
The Emerging Picture of Anemia in Chronic Kidney Disease

A Foundation for Managed Care

Bruce S. Spinowitz, MD; Wendy L. St. Peter, PharmD, FCCP, FASN, FNKF

credit amount 1.00

credit type                

CME/AANP/ACPE

expiration 09/25/2021


More Information
Image eHealthSource
HIV Prevention in Primary Care Practice

A PrEP Primer

Gregory S. Felzien, MD, AAHIVS; Andrea R. Jefferson-Saboor, FNP-C

credit amount 1.25

credit type CME/CE

expiration 10/19/2021


More Information
Image Webcast
Finding Relief in Osteoarthritis

New Paths to Chronic Pain Management

Scott A. Rodeo, MD; Thomas J. Schnitzer, MD, PhD

credit amount 1.00

credit type CME

expiration 10/06/2021


More Information
Image POC101
COPD in Managed Care

The Clinical and Utilization Benefits of Exacerbation Prevention

Barry J. Make, MD; Richard H. Stanford, PharmD, MS; Barbara P. Yawn, MD, MSc, FAAFP

credit amount 1.25

credit type CME

expiration 09/30/2021


More Information

Archived Activities

Finding the Path in Moderate-to-Severe Asthma

Target Audience

The educational design of this activity addresses the needs of primary care providers (PCPs) and other clinicians involved in the ongoing management of patients with moderate-to-severe asthma.

Airing It Out

A Case-Based Conversation on Managing Asthma and Chronic Rhinosinusitis With Nasal Polyps

Readying for an Expanded Scope of Practice in California

Preventing HIV Infection in the Pharmacy Setting

Assimilating the Evidence in T2DM

Cardiovascular and Renal Outcomes With SGLT2 Inhibitors

Demystifying New Evidence for COPD Management

Best Practices for Primary Care

Finding the Right Path in Severe Asthma

Mechanistic Insights and Emerging Treatment Options

JAKi in RA Practice

Unpacking the Evidence for Their Use Today and Tomorrow

Marching Forward in Atopic Dermatitis

Digging Deep on Shared Decision-Making

Multidimensional Outcomes in Type 2 Diabetes

Looking Beyond Hemoglobin A1c

Managing Opioid-Induced Constipation

Translating Guidelines Into Patient Care

Focusing on Control in COPD Management

A Case-Based Look at Exacerbation Prevention

New Paths to Managing Anemia Associated With Chronic Kidney Disease

A Guide to Healthcare Advances for Specialist Clinicians

Clinical Issues in Atopic Dermatitis

Debates and Discussions About Managing Moderate-to-Severe Disease

Trends in Infectious Diseases

Catch up with experts on the latest evidence related to HIV prevention, rapid-start antiretroviral (ART) therapy, and HCV screening and treatment for people who inject drugs—the population at highest risk of transmission. These 15-minute expert interviews will provide the epidemiologic trends that underlie the imperative for HIV preexposure prophylaxis (PrEP), present HIV treatment as prevention (TasP), and emphasize the feasibility, efficacy, and ease of treating HCV-infected PWID.

HIV Waiting Room

This series of 3 unique, case-based, interactive online activities was developed to improve the care of patients with HIV. The instructional design incorporates the latest evidence-based guidelines for HIV management into clinical scenarios of different patient populations. Case topics cover treatment initiation, rapid antiretroviral therapy (ART) protocols, considerations for people with substance use, switching regimens for simplification or comorbidities, and treatment and adherence in transgender patients. 

Pharmacoeconomics and LDL-C Management

Implications for PCSK9 Inhibitors in Clinical Practice

Sharing a Breath

Interdisciplinary Management of Patients With Severe Asthma

Looking Ahead

Optimizing Management Strategies in Moderate-to-Severe Atopic Dermatitis

Trends and Updates in IBD

Physicians need further education to fully understand and implement current advanced therapies and distinguish the pathways of disease and targets addressed by newer therapies. This educational activity will provide key clinical data on new and emerging treatments, focusing on the Janus kinase (JAK)/signal transducer and activator of transcription (STAT) pathway in the context of evolving understanding of disease immunopathogenesis.

GLP-1 Receptors Agonists in Type 2 Diabetes

Mechanistic Insights and Evolving Treatment Options

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:24:01 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 '36114'
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 '/activities'
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 1632353346.2925
REQUEST_TIME 1632353346
Request Cookies
Session Attributes
Request GET Parameters
Request POST Parameters
Request FILES
Application Settings
Application Properties
defaultController 'site'
layout 'main'
controllerMap array
(
'debug' => array
(
'class' => 'YiiDebugController'
)
)
catchAllRequest null
controllerNamespace null
name 'ExchangeCME'
charset 'UTF-8'
sourceLanguage 'en_us'
preload array
(
0 => 'log'
)
behaviors array()
Modules
gii array
(
'class' => 'system.gii.GiiModule'
'password'
=> '123123'
'ipFilters'
=> array
(
0 => '*'
)
)
Application Params
dateFormat 'm/d/Y'
lastTimeToAttendEvent 172800
passTestLine 70
maxFileSize 1048576
imageDir '/var/www/exchangecme/files/upload/images'
linkImageDir '/files/upload/images'
linkInterDir '/files/upload/interactions'
actUpDir '/activities'
newsUpDir '/news'
resUpDir '/resources'
evUpDir '/events'
interScormDir '/scorm'
environment 'prod'
mandrillApiKey 'bOVWUkHldCbJevygSZtrVg'
rememberTime 'INTERVAL 1 DAY'
fromEmail 'support@exchangeCME.com'
fromName 'exchangeCME.com'
infoEmail 'info@exchangecme.com'
infoEmail2 'info@integritasgrp.com'
subject 'Registration'
certificates array
(
'sizes' => array
(
1 => array
(
'w' => 500
'h' => 398
)
2 => array
(
'w' => 30
'h' => 30
)
)
)
sms array
(
'api_key' => '315336da'
'api_secret'
=> 'c37c6167be626d2d'
'to'
=> '12016818114'
'from'
=> '12016958971'
)
adobeConnect array
(
'adminEmail' => ''
'adminPassword'
=> ''
)
timeZone 'America/New_York'
bigmarketWebinar array
(
'host' => 'https://www.bigmarker.com/'
'apiKey'
=> 'c76d1dea6472a01db6ca'
)
baseUrl 'https://www.exchangecme.com'
zoomWebinar array
(
'host' => 'https://api.zoom.us/'
'access_token'
=> 'eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJhdWQiOm51bGwsImlzcyI6Ikc4cEg4Vk9HVDBtMW1RRGY4SVh1MkEiLCJleHAiOjE4OTgyMzkwMjAsImlhdCI6MTYxMzYzNzQ5MX0.gRKOnZlOSWOnYgtC-BG-Sxw_x9h82TKKohotwptw-Wo'
)
Components
urlManager array
(
'class' => 'CUrlManager'
'rules'
=> array
(
'/' => 'site/index'
'<view:(terms|privacy)>'
=> 'site/page'
'admin'
=> 'backend/site/index'
'activities'
=> 'activities/index'
'groups/<group:[\w\d.-]+>'
=> 'activities/group'
'group-events/<group:[\w\d.-]+>'
=> 'events/group'
'site'
=> 'site/index'
'googleSearch'
=> 'site/googleSearch'
'search'
=> 'site/search'
'subscription'
=> 'site/subscription'
'events'
=> 'events/index'
'resources'
=> 'resources/index'
'<controller:(certificates|news|questions|site|users|activities|eventActivities|events)>/<action:\w+>'
=> '<controller>/<action>'
'<controller:(survey)>/<surveyId:\d+>/<email:[\w\d@.-]+>'
=> 'activities/survey'
0 => array
(
'class' => 'application.components.ShortLinksUrlRule'
)
'<id:[\w\d.-]+>/reportcenter/' => 'manager/viewReport'
'groups/<id:[\w\d.-]+>/reportcenter/'
=> 'manager/viewGroupReport'
'manager/activities'
=> 'manager/viewActivities'
'manager/group-activities'
=> 'manager/viewGroupActivities'
)
'urlSuffix' => ''
'showScriptName'
=> false
'appendParams' => true
'routeVar' => 'r'
'caseSensitive'
=> true
'matchValue' => false
'cacheID' => 'cache'
'useStrictParsing'
=> false
'urlRuleClass' => 'CUrlRule'
'behaviors'
=> array()
)
request array
(
'class' => 'CHttpRequest'
'enableCookieValidation'
=> false
'enableCsrfValidation' => false
'csrfTokenName' => 'YII_CSRF_TOKEN'
'csrfCookie'
=> null
'behaviors' => array()
)
log array
(
'class' => 'CLogRouter'
'behaviors'
=> array()
)
viewRenderer array
(
'class' => 'YiiDebugViewRenderer'
)
db array
(
'class' => 'CDbConnection'
'connectionString'
=> 'mysql:host=localhost;dbname=exchangeCME'
'username'
=> 'root'
'password'
=> 'wqeeqwe12123ewerwe'
'schemaCachingDuration'
=> 3600
'schemaCachingExclude' => array()
'schemaCacheID' => 'cache'
'queryCachingDuration'
=> 0
'queryCachingDependency' => null
'queryCachingCount' => 0
'queryCacheID' => 'cache'
'autoConnect'
=> true
'charset' => 'utf8'
'emulatePrepare'
=> true
'enableParamLogging' => false
'enableProfiling' => true
'tablePrefix' => null
'initSQLs' => null
'driverMap' => array
(
'pgsql' => 'CPgsqlSchema'
'mysqli'
=> 'CMysqlSchema'
'mysql'
=> 'CMysqlSchema'
'sqlite'
=> 'CSqliteSchema'
'sqlite2'
=> 'CSqliteSchema'
'mssql'
=> 'CMssqlSchema'
'dblib'
=> 'CMssqlSchema'
'sqlsrv'
=> 'CMssqlSchema'
'oci'
=> 'COciSchema'
)
'pdoClass' => 'PDO'
'behaviors'
=> array()
)
clientScript array
(
'class' => 'CClientScript'
'enableJavaScript'
=> true
'scriptMap' => array()
'packages' => array()
'corePackages' => array
(
'jquery' => array
(
'js' => array
(
0 => 'jquery.min.js'
)
)
'yii' => array
(
'js' => array
(
0 => 'jquery.yii.js'
)
'depends' => array
(
0 => 'jquery'
)
)
'yiitab' => array
(
'js' => array
(
0 => 'jquery.yiitab.js'
)
'depends' => array
(
0 => 'jquery'
)
)
'yiiactiveform' => array
(
'js' => array
(
0 => 'jquery.yiiactiveform.js'
)
'depends' => array
(
0 => 'jquery'
)
)
'jquery.ui' => array
(
'js' => array
(
0 => 'jui/js/jquery-ui.min.js'
)
'depends' => array
(
0 => 'jquery'
)
)
'bgiframe' => array
(
'js' => array
(
0 => 'jquery.bgiframe.js'
)
'depends' => array
(
0 => 'jquery'
)
)
'ajaxqueue' => array
(
'js' => array
(
0 => 'jquery.ajaxqueue.js'
)
'depends' => array
(
0 => 'jquery'
)
)
'autocomplete' => array
(
'js' => array
(
0 => 'jquery.autocomplete.js'
)
'depends' => array
(
0 => 'jquery'
1 => 'bgiframe'
2 => 'ajaxqueue'
)
)
'maskedinput' => array
(
'js' => array
(
0 => 'jquery.maskedinput.min.js'
)
'depends' => array
(
0 => 'jquery'
)
)
'cookie' => array
(
'js' => array
(
0 => 'jquery.cookie.js'
)
'depends' => array
(
0 => 'jquery'
)
)
'treeview' => array
(
'js' => array
(
0 => 'jquery.treeview.js'
1 => 'jquery.treeview.edit.js'
2 => 'jquery.treeview.async.js'
)
'depends' => array
(
0 => 'jquery'
1 => 'cookie'
)
)
'multifile' => array
(
'js' => array
(
0 => 'jquery.multifile.js'
)
'depends' => array
(
0 => 'jquery'
)
)
'rating' => array
(
'js' => array
(
0 => 'jquery.rating.js'
)
'depends' => array
(
0 => 'jquery'
1 => 'metadata'
)
)
'metadata' => array
(
'js' => array
(
0 => 'jquery.metadata.js'
)
'depends' => array
(
0 => 'jquery'
)
)
'bbq' => array
(
'js' => array
(
0 => 'jquery.ba-bbq.js'
)
'depends' => array
(
0 => 'jquery'
)
)
'history' => array
(
'js' => array
(
0 => 'jquery.history.js'
)
'depends' => array
(
0 => 'jquery'
)
)
)
'scripts' => array
(
2 => array
(
'events-topics' => '
$(function() {
$(\'#clinical-topics\').on (\'change\', function () {
window.location.href = \'/activities/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/index
Action CInlineAction (index)
Action params
    null
Render methodrenderPartial
View file themes/desktop/views/activities/index.php
View data
  •  => 
  •  => 
  •  => 
Context ActivitiesController
Context class ActivitiesController
Inheritance CommonActivitiesController » Controller » CController » CBaseController
Defined in file protected/controllers/ActivitiesController.php
Context properties
  •  => 
  •  => 
  •  => 
  •  => 
  •  => 
Route activities/index
Action CInlineAction (index)
Action params
    null
Render methodrenderPartial
View file themes/desktop/views/common/_clinical_topics.php
View data
  •  => 
Context ActivitiesController
Context class ActivitiesController
Inheritance CommonActivitiesController » Controller » CController » CBaseController
Defined in file protected/controllers/ActivitiesController.php
Context properties
  •  => 
  •  => 
  •  => 
  •  => 
  •  => 
Route activities/index
Action CInlineAction (index)
Action params
    null
Render methodrenderPartial
View file themes/desktop/views/common/_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/index
Action CInlineAction (index)
Action params
    null
Render methodrenderPartial
View file themes/desktop/views/common/_activity.php
View data
  •  => 
Context ActivitiesController
Context class ActivitiesController
Inheritance CommonActivitiesController » Controller » CController » CBaseController
Defined in file protected/controllers/ActivitiesController.php
Context properties
  •  => 
  •  => 
  •  => 
  •  => 
  •  => 
Route activities/index
Action CInlineAction (index)
Action params
    null
Render methodrenderPartial
View file themes/desktop/views/common/_activity.php
View data
  •  => 
Context ActivitiesController
Context class ActivitiesController
Inheritance CommonActivitiesController » Controller » CController » CBaseController
Defined in file protected/controllers/ActivitiesController.php
Context properties
  •  => 
  •  => 
  •  => 
  •  => 
  •  => 
Route activities/index
Action CInlineAction (index)
Action params
    null
Render methodrenderPartial
View file themes/desktop/views/common/_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/index
Action CInlineAction (index)
Action params
    null
Render methodrenderPartial
View file themes/desktop/views/common/_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/index
Action CInlineAction (index)
Action params
    null
Render methodrenderPartial
View file themes/desktop/views/common/_activity.php
View data
  •  => 
Context ActivitiesController
Context class ActivitiesController
Inheritance CommonActivitiesController » Controller » CController » CBaseController
Defined in file protected/controllers/ActivitiesController.php
Context properties
  •  => 
  •  => 
  •  => 
  •  => 
  •  => 
Route activities/index
Action CInlineAction (index)
Action params
    null
Render methodrenderPartial
View file themes/desktop/views/common/_activity.php
View data
  •  => 
Context ActivitiesController
Context class ActivitiesController
Inheritance CommonActivitiesController » Controller » CController » CBaseController
Defined in file protected/controllers/ActivitiesController.php
Context properties
  •  => 
  •  => 
  •  => 
  •  => 
  •  => 
Route activities/index
Action CInlineAction (index)
Action params
    null
Render methodrenderPartial
View file themes/desktop/views/common/_activity.php
View data
  •  => 
Context ActivitiesController
Context class ActivitiesController
Inheritance CommonActivitiesController » Controller » CController » CBaseController
Defined in file protected/controllers/ActivitiesController.php
Context properties
  •  => 
  •  => 
  •  => 
  •  => 
  •  => 
Route activities/index
Action CInlineAction (index)
Action params
    null
Render methodrenderPartial
View file themes/desktop/views/common/_activity.php
View data
  •  => 
Context ActivitiesController
Context class ActivitiesController
Inheritance CommonActivitiesController » Controller » CController » CBaseController
Defined in file protected/controllers/ActivitiesController.php
Context properties
  •  => 
  •  => 
  •  => 
  •  => 
  •  => 
Route activities/index
Action CInlineAction (index)
Action params
    null
Render methodrenderPartial
View file themes/desktop/views/common/_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/index
Action CInlineAction (index)
Action params
    null
Render methodrenderPartial
View file themes/desktop/views/common/_activity.php
View data
  •  => 
Context ActivitiesController
Context class ActivitiesController
Inheritance CommonActivitiesController » Controller » CController » CBaseController
Defined in file protected/controllers/ActivitiesController.php
Context properties
  •  => 
  •  => 
  •  => 
  •  => 
  •  => 
Route activities/index
Action CInlineAction (index)
Action params
    null
Render methodrenderPartial
View file themes/desktop/views/common/_activity.php
View data
  •  => 
Context ActivitiesController
Context class ActivitiesController
Inheritance CommonActivitiesController » Controller » CController » CBaseController
Defined in file protected/controllers/ActivitiesController.php
Context properties
  •  => 
  •  => 
  •  => 
  •  => 
  •  => 
Route activities/index
Action CInlineAction (index)
Action params
    null
Render methodrenderPartial
View file themes/desktop/views/common/_activity.php
View data
  •  => 
Context ActivitiesController
Context class ActivitiesController
Inheritance CommonActivitiesController » Controller » CController » CBaseController
Defined in file protected/controllers/ActivitiesController.php
Context properties
  •  => 
  •  => 
  •  => 
  •  => 
  •  => 
Route activities/index
Action CInlineAction (index)
Action params
    null
Render methodrenderPartial
View file themes/desktop/views/common/_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/index
Action CInlineAction (index)
Action params
    null
Render methodrenderPartial
View file themes/desktop/views/common/_activity.php
View data
  •  => 
Context ActivitiesController
Context class ActivitiesController
Inheritance CommonActivitiesController » Controller » CController » CBaseController
Defined in file protected/controllers/ActivitiesController.php
Context properties
  •  => 
  •  => 
  •  => 
  •  => 
  •  => 
Route activities/index
Action CInlineAction (index)
Action params
    null
Render methodrenderPartial
View file themes/desktop/views/common/_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/index
Action CInlineAction (index)
Action params
    null
Render methodrenderPartial
View file themes/desktop/views/common/_activity.php
View data
  •  => 
Context ActivitiesController
Context class ActivitiesController
Inheritance CommonActivitiesController » Controller » CController » CBaseController
Defined in file protected/controllers/ActivitiesController.php
Context properties
  •  => 
  •  => 
  •  => 
  •  => 
  •  => 
Route activities/index
Action CInlineAction (index)
Action params
    null
Render methodrenderPartial
View file themes/desktop/views/common/_activity.php
View data
  •  => 
Context ActivitiesController
Context class ActivitiesController
Inheritance CommonActivitiesController » Controller » CController » CBaseController
Defined in file protected/controllers/ActivitiesController.php
Context properties
  •  => 
  •  => 
  •  => 
  •  => 
  •  => 
Route activities/index
Action CInlineAction (index)
Action params
    null
Render methodrenderPartial
View file themes/desktop/views/common/_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/index
Action CInlineAction (index)
Action params
    null
Render methodrenderPartial
View file themes/desktop/views/common/_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/index
Action CInlineAction (index)
Action params
    null
Render methodrenderPartial
View file themes/desktop/views/common/_activity.php
View data
  •  => 
Context ActivitiesController
Context class ActivitiesController
Inheritance CommonActivitiesController » Controller » CController » CBaseController
Defined in file protected/controllers/ActivitiesController.php
Context properties
  •  => 
  •  => 
  •  => 
  •  => 
  •  => 
Route activities/index
Action CInlineAction (index)
Action params
    null
Render methodrenderPartial
View file themes/desktop/views/common/_activity.php
View data
  •  => 
Context ActivitiesController
Context class ActivitiesController
Inheritance CommonActivitiesController » Controller » CController » CBaseController
Defined in file protected/controllers/ActivitiesController.php
Context properties
  •  => 
  •  => 
  •  => 
  •  => 
  •  => 
Route activities/index
Action CInlineAction (index)
Action params
    null
Render methodrenderPartial
View file themes/desktop/views/common/_activity.php
View data
  •  => 
Context ActivitiesController
Context class ActivitiesController
Inheritance CommonActivitiesController » Controller » CController » CBaseController
Defined in file protected/controllers/ActivitiesController.php
Context properties
  •  => 
  •  => 
  •  => 
  •  => 
  •  => 
Route activities/index
Action CInlineAction (index)
Action params
    null
Render methodrenderPartial
View file themes/desktop/views/common/_activity.php
View data
  •  => 
Context ActivitiesController
Context class ActivitiesController
Inheritance CommonActivitiesController » Controller » CController » CBaseController
Defined in file protected/controllers/ActivitiesController.php
Context properties
  •  => 
  •  => 
  •  => 
  •  => 
  •  => 
Route activities/index
Action CInlineAction (index)
Action params
    null
Render methodrenderPartial
View file themes/desktop/views/common/_featured_event.php
View data
  •  => 
Context ActivitiesController
Context class ActivitiesController
Inheritance CommonActivitiesController » Controller » CController » CBaseController
Defined in file protected/controllers/ActivitiesController.php
Context properties
  •  => 
  •  => 
  •  => 
  •  => 
  •  => 
Route activities/index
Action CInlineAction (index)
Action params
    null
Render methodrenderPartial
View file themes/desktop/views/common/_featured_resource.php
View data
  •  => 
Context ActivitiesController
Context class ActivitiesController
Inheritance CommonActivitiesController » Controller » CController » CBaseController
Defined in file protected/controllers/ActivitiesController.php
Context properties
  •  => 
  •  => 
  •  => 
  •  => 
  •  => 
Route activities/index
Action CInlineAction (index)
Action params
    null
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/index
Action CInlineAction (index)
Action params
    null
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/index
Action CInlineAction (index)
Action params
    null
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/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 (58/0.453935s)

Connection ID: db (CDbConnection)

Driver mysql
Server Version 5.5.59-0ubuntu0.14.04.1
Uptime 14w 1d 6h 28m 30s
Threads 1
Questions 40792347
Slow queries 13
Opens 195
Flush tables 1
Open tables 167
Queries per second avg 4.756
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` 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`) WHERE ((((t.group_id IS NULL OR t.group_id ="") AND (t.status = :status_active)) AND (t.archived=1)) AND (event.id IS NULL)) ORDER BY t.finishDate DESC
1 0.397280 0.397280 0.397280 0.397280
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=1)) ORDER BY t.finishDate DESC
1 0.007033 0.007033 0.007033 0.007033
UPDATE activities SET archived=1 WHERE finishDate<now();
1 0.006141 0.006141 0.006141 0.006141
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.005512 0.005512 0.005512 0.005512
INSERT INTO `users` (`role`, `sendEmails`, `sendSms`, `source`, `session`, `lastLogin`, `phone`, `createDate`) VALUES (:yp0, :yp1, :yp2, :yp3, :yp4, :yp5, :yp6, :yp7)
1 0.004822 0.004822 0.004822 0.004822
SELECT * FROM `activities` `t` WHERE `t`.`group_id`=:yp0 LIMIT 1
16 0.004506 0.000282 0.000268 0.000301
UPDATE activities_groups SET archived=1 WHERE finishDate<now();
1 0.003001 0.003001 0.003001 0.003001
UPDATE `users` SET `lastLogin`=:yp0 WHERE `users`.`id`=2491865
1 0.002922 0.002922 0.002922 0.002922
SELECT * FROM `activities` `t` WHERE `group_id` = :id
8 0.002650 0.000331 0.000301 0.000362
SHOW COLUMNS FROM `activities`
1 0.001771 0.001771 0.001771 0.001771
SHOW COLUMNS FROM `events`
1 0.001576 0.001576 0.001576 0.001576
SHOW COLUMNS FROM `activities_groups`
1 0.001509 0.001509 0.001509 0.001509
SHOW COLUMNS FROM `resources`
1 0.001439 0.001439 0.001439 0.001439
SHOW COLUMNS FROM `users`
1 0.001242 0.001242 0.001242 0.001242
SHOW COLUMNS FROM `events_topics`
1 0.001232 0.001232 0.001232 0.001232
SHOW COLUMNS FROM `interactions`
1 0.001156 0.001156 0.001156 0.001156
SELECT * FROM `users` `t` WHERE session=:session LIMIT 1
2 0.001141 0.000570 0.000562 0.000579
SHOW COLUMNS FROM `activity_topics`
1 0.001078 0.001078 0.001078 0.001078
SHOW COLUMNS FROM `topics`
1 0.001072 0.001072 0.001072 0.001072
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 IS NULL OR t.group_id ="")) AND (event.id IS NULL)) ORDER BY t.createDate DESC
1 0.001042 0.001042 0.001042 0.001042
SHOW COLUMNS FROM `resource_topics`
1 0.001041 0.001041 0.001041 0.001041
SHOW CREATE TABLE `events`
1 0.000442 0.000442 0.000442 0.000442
SHOW CREATE TABLE `activity_topics`
1 0.000409 0.000409 0.000409 0.000409
SHOW CREATE TABLE `activities_groups`
1 0.000382 0.000382 0.000382 0.000382
SHOW CREATE TABLE `activities`
1 0.000378 0.000378 0.000378 0.000378
SELECT * FROM `topics` `t` ORDER BY title
1 0.000372 0.000372 0.000372 0.000372
SHOW CREATE TABLE `resources`
1 0.000335 0.000335 0.000335 0.000335
SHOW CREATE TABLE `resource_topics`
1 0.000333 0.000333 0.000333 0.000333
SHOW CREATE TABLE `users`
1 0.000331 0.000331 0.000331 0.000331
SHOW CREATE TABLE `events_topics`
1 0.000310 0.000310 0.000310 0.000310
SHOW CREATE TABLE `interactions`
1 0.000306 0.000306 0.000306 0.000306
SHOW CREATE TABLE `topics`
1 0.000304 0.000304 0.000304 0.000304
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.000299 0.000299 0.000299 0.000299
SELECT `t`.`id` AS `t0_c0`, `t`.`shortAddress` AS `t0_c1`, `t`.`status` AS `t0_c2`, `t`.`title` AS `t0_c3`, `t`.`type` AS `t0_c4`, `t`.`image` AS `t0_c5`, `t`.`slides` AS `t0_c6`, `t`.`linkedResources` AS `t0_c7`, `t`.`reading` AS `t0_c8`, `t`.`shortDescription` AS `t0_c9`, `t`.`fullDescription` AS `t0_c10`, `t`.`link` AS `t0_c11`, `t`.`createDate` AS `t0_c12`, `t`.`archived` AS `t0_c13`, `resourceTopics`.`id` AS `t1_c0`, `resourceTopics`.`resource_id` AS `t1_c1`, `resourceTopics`.`topic_id` AS `t1_c2`, `resourceTopics`.`isFeatured` AS `t1_c3` FROM `resources` `t` LEFT OUTER JOIN `resource_topics` `resourceTopics` ON (`resourceTopics`.`resource_id`=`t`.`id`) WHERE ((((isFeatured = 1) AND (t.status = :status_active)) AND (t.archived=0)) AND (topic_id = 0)) ORDER BY createDate DESC LIMIT 1
1 0.000292 0.000292 0.000292 0.000292
SELECT * FROM `activities` `t` WHERE `t`.`id` IS NULL LIMIT 1
1 0.000276 0.000276 0.000276 0.000276
# Query Time (s)
0
SHOW COLUMNS FROM `activities`
0.001771
1
SHOW CREATE TABLE `activities`
0.000378
2
SHOW COLUMNS FROM `users`
0.001242
3
SHOW CREATE TABLE `users`
0.000331
4
SELECT * FROM `users` `t` WHERE session=:session LIMIT 1
0.000562
5
INSERT INTO `users` (`role`, `sendEmails`, `sendSms`, `source`, `session`, `lastLogin`, `phone`, `createDate`) VALUES (:yp0, :yp1, :yp2, :yp3, :yp4, :yp5, :yp6, :yp7)
0.004822
6
SELECT * FROM `users` `t` WHERE session=:session LIMIT 1
0.000579
7
UPDATE `users` SET `lastLogin`=:yp0 WHERE `users`.`id`=2491865
0.002922
8
SELECT * FROM `activities` `t` WHERE `t`.`id` IS NULL LIMIT 1
0.000276
9
UPDATE activities SET archived=1 WHERE finishDate<now();
0.006141
10
UPDATE activities_groups SET archived=1 WHERE finishDate<now();
0.003001
11
SHOW COLUMNS FROM `activities_groups`
0.001509
12
SHOW CREATE TABLE `activities_groups`
0.000382
13
SHOW COLUMNS FROM `topics`
0.001072
14
SHOW CREATE TABLE `topics`
0.000304
15
SHOW COLUMNS FROM `activity_topics`
0.001078
16
SHOW CREATE TABLE `activity_topics`
0.000409
17
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.005512
18
SHOW COLUMNS FROM `events`
0.001576
19
SHOW CREATE TABLE `events`
0.000442
20
SHOW COLUMNS FROM `interactions`
0.001156
21
SHOW CREATE TABLE `interactions`
0.000306
22
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 IS NULL OR t.group_id ="")) AND (event.id IS NULL)) ORDER BY t.createDate DESC
0.001042
23
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=1)) ORDER BY t.finishDate DESC
0.007033
24
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` 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`) WHERE ((((t.group_id IS NULL OR t.group_id ="") AND (t.status = :status_active)) AND (t.archived=1)) AND (event.id IS NULL)) ORDER BY t.finishDate DESC
0.397280
25
SELECT * FROM `topics` `t` ORDER BY title
0.000372
26
SELECT * FROM `activities` `t` WHERE `group_id` = :id
0.000345
27
SELECT * FROM `activities` `t` WHERE `t`.`group_id`=:yp0 LIMIT 1
0.000285
28
SELECT * FROM `activities` `t` WHERE `t`.`group_id`=:yp0 LIMIT 1
0.000301
29
SELECT * FROM `activities` `t` WHERE `group_id` = :id
0.000362
30
SELECT * FROM `activities` `t` WHERE `t`.`group_id`=:yp0 LIMIT 1
0.000295
31
SELECT * FROM `activities` `t` WHERE `t`.`group_id`=:yp0 LIMIT 1
0.000279
32
SELECT * FROM `activities` `t` WHERE `group_id` = :id
0.000305
33
SELECT * FROM `activities` `t` WHERE `t`.`group_id`=:yp0 LIMIT 1
0.000273
34
SELECT * FROM `activities` `t` WHERE `t`.`group_id`=:yp0 LIMIT 1
0.000281
35
SELECT * FROM `activities` `t` WHERE `group_id` = :id
0.000301
36
SELECT * FROM `activities` `t` WHERE `t`.`group_id`=:yp0 LIMIT 1
0.000287
37
SELECT * FROM `activities` `t` WHERE `t`.`group_id`=:yp0 LIMIT 1
0.000270
38
SELECT * FROM `activities` `t` WHERE `group_id` = :id
0.000356
39
SELECT * FROM `activities` `t` WHERE `t`.`group_id`=:yp0 LIMIT 1
0.000285
40
SELECT * FROM `activities` `t` WHERE `t`.`group_id`=:yp0 LIMIT 1
0.000286
41
SELECT * FROM `activities` `t` WHERE `group_id` = :id
0.000306
42
SELECT * FROM `activities` `t` WHERE `t`.`group_id`=:yp0 LIMIT 1
0.000284
43
SELECT * FROM `activities` `t` WHERE `t`.`group_id`=:yp0 LIMIT 1
0.000273
44
SELECT * FROM `activities` `t` WHERE `group_id` = :id
0.000346
45
SELECT * FROM `activities` `t` WHERE `t`.`group_id`=:yp0 LIMIT 1
0.000275
46
SELECT * FROM `activities` `t` WHERE `t`.`group_id`=:yp0 LIMIT 1
0.000268
47
SELECT * FROM `activities` `t` WHERE `group_id` = :id
0.000329
48
SELECT * FROM `activities` `t` WHERE `t`.`group_id`=:yp0 LIMIT 1
0.000277
49
SELECT * FROM `activities` `t` WHERE `t`.`group_id`=:yp0 LIMIT 1
0.000287
50
SHOW COLUMNS FROM `events_topics`
0.001232
51
SHOW CREATE TABLE `events_topics`
0.000310
52
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.000299
53
SHOW COLUMNS FROM `resources`
0.001439
54
SHOW CREATE TABLE `resources`
0.000335
55
SHOW COLUMNS FROM `resource_topics`
0.001041
56
SHOW CREATE TABLE `resource_topics`
0.000333
57
SELECT `t`.`id` AS `t0_c0`, `t`.`shortAddress` AS `t0_c1`, `t`.`status` AS `t0_c2`, `t`.`title` AS `t0_c3`, `t`.`type` AS `t0_c4`, `t`.`image` AS `t0_c5`, `t`.`slides` AS `t0_c6`, `t`.`linkedResources` AS `t0_c7`, `t`.`reading` AS `t0_c8`, `t`.`shortDescription` AS `t0_c9`, `t`.`fullDescription` AS `t0_c10`, `t`.`link` AS `t0_c11`, `t`.`createDate` AS `t0_c12`, `t`.`archived` AS `t0_c13`, `resourceTopics`.`id` AS `t1_c0`, `resourceTopics`.`resource_id` AS `t1_c1`, `resourceTopics`.`topic_id` AS `t1_c2`, `resourceTopics`.`isFeatured` AS `t1_c3` FROM `resources` `t` LEFT OUTER JOIN `resource_topics` `resourceTopics` ON (`resourceTopics`.`resource_id`=`t`.`id`) WHERE ((((isFeatured = 1) AND (t.status = :status_active)) AND (t.archived=0)) AND (topic_id = 0)) ORDER BY createDate DESC LIMIT 1
0.000292
Log Messages
Message (details) Level Category Time