All Categories
Canonical Url: http://vanilla.local/vanilla/categories/all

5 queries in 0.0036752223968506s

UserModel->GetSession('1')0.000518s
select u.*
from GDN_User u
where u.UserID = '1';
UserModel->GetSession('1')0.001641s
set names 'utf8';
CategoryModel->GetFull()0.000721s
select c.Name as `Name`, c.CategoryID as `CategoryID`, c.TreeRight as `TreeRight`, c.TreeLeft as `TreeLeft`, c.Depth as `Depth`, c.Description as `Description`, c.CountDiscussions as `CountDiscussions`, c.CountComments as `CountComments`, c.UrlCode as `UrlCode`, c.LastCommentID as `LastCommentID`, c.PermissionCategoryID as `PermissionCategoryID`, co.DateInserted as `DateLastComment`, co.InsertUserID as `LastCommentUserID`, cu.Name as `LastCommentName`, cu.Photo as `LastCommentPhoto`, co.DiscussionID as `LastDiscussionID`, d.Name as `LastDiscussionName`
from GDN_Category c
left join GDN_Comment co on c.LastCommentID = co.CommentID
left join GDN_User cu on co.InsertUserID = cu.UserID
left join GDN_Discussion d on d.DiscussionID = co.DiscussionID
where c.AllowDiscussions = '1'
order by TreeLeft asc;
UserModel->GetApplicantCount()0.000317s
select count(u.UserID) as `ApplicantCount`
from GDN_User u
join GDN_UserRole ur on u.UserID = ur.UserID
where ur.RoleID = 4;
include('/www/vanilla/applications/dashboard/views/default.master.php')0.000478s
select DiscussionID
from GDN_UserDiscussion UserDiscussion
where UserID = '1'
 and Bookmarked = '1';

Controller Data

Title: 'All Categories'
Categories: DataSet
   Count: 4
   Fields: Name, CategoryID, TreeRight, TreeLeft, Depth, Description, CountDiscussions, CountComments, UrlCode, LastCommentID, PermissionCategoryID, DateLastComment, LastCommentUserID, LastCommentName, LastCommentPhoto, LastDiscussionID, LastDiscussionName, CountAllDiscussions, CountAllComments
CssClass: 'Vanilla Categories all '

Page completed in 0.4271s