Canonical Url: http://mike.sodisruptive.com/forums/discussions/p1 7 queries in 0.00554871559143s require_once('/home/missy20/public_html/mike/forums/bootstrap.php')0.000139s select u.* from GDN_User u where u.UserID = '1'; require_once('/home/missy20/public_html/mike/forums/bootstrap.php')0.003470s set names 'utf8'; CategoryModel->GetFull()0.000475s select c.Name as `Name`, c.CategoryID as `CategoryID`, c.Description as `Description`, c.CountDiscussions as `CountDiscussions`, c.UrlCode as `UrlCode`, p.CategoryID as `ParentCategoryID`, p.Name as `ParentName` from GDN_Category c left join GDN_Category p on c.ParentCategoryID = p.CategoryID where c.AllowDiscussions = '1' and 1 = 1 order by c.Sort asc; DiscussionModel->Get(0, 10, array('w.Bookmarked' => '1', 'w.UserID' => '1'))0.000486s select d.InsertUserID as `FirstUserID`, d.DateInserted as `FirstDate`, d.CountBookmarks as `CountBookmarks`, iu.Name as `FirstName`, iu.Photo as `FirstPhoto`, d.Body as `Body`, d.Format as `Format`, d.DateLastComment as `LastDate`, d.LastCommentUserID as `LastUserID`, lcu.Name as `LastName`, concat_ws(' → ', pc.Name, ca.Name) as `Category`, ca.UrlCode as `CategoryUrlCode`, d.*, w.UserID as `WatchUserID`, w.DateLastViewed as `DateLastViewed`, w.Dismissed as `Dismissed`, w.Bookmarked as `Bookmarked`, w.CountComments as `CountCommentWatch` from GDN_Discussion d left join GDN_User iu on d.InsertUserID = iu.UserID left join GDN_User lcu on d.LastCommentUserID = lcu.UserID left join GDN_Category ca on d.CategoryID = ca.CategoryID left join GDN_Category pc on ca.ParentCategoryID = pc.CategoryID left join GDN_UserDiscussion w on d.DiscussionID = w.DiscussionID and w.UserID = 1 where w.Bookmarked = '1' and w.UserID = '1' order by d.DateLastComment desc limit 10; DiscussionModel->GetCount()0.000166s select sum(c.CountDiscussions) as `CountDiscussions` from GDN_Category c; DiscussionModel->GetAnnouncements()0.000416s select d.InsertUserID as `FirstUserID`, d.DateInserted as `FirstDate`, d.CountBookmarks as `CountBookmarks`, iu.Name as `FirstName`, iu.Photo as `FirstPhoto`, d.Body as `Body`, d.Format as `Format`, d.DateLastComment as `LastDate`, d.LastCommentUserID as `LastUserID`, lcu.Name as `LastName`, concat_ws(' → ', pc.Name, ca.Name) as `Category`, ca.UrlCode as `CategoryUrlCode`, d.*, w.UserID as `WatchUserID`, w.DateLastViewed as `DateLastViewed`, w.Dismissed as `Dismissed`, w.Bookmarked as `Bookmarked`, w.CountComments as `CountCommentWatch` from GDN_Discussion d left join GDN_User iu on d.InsertUserID = iu.UserID left join GDN_User lcu on d.LastCommentUserID = lcu.UserID left join GDN_Category ca on d.CategoryID = ca.CategoryID left join GDN_Category pc on ca.ParentCategoryID = pc.CategoryID left join GDN_UserDiscussion w on d.DiscussionID = w.DiscussionID and w.UserID = 1 where d.Announce = '1' and (w.Dismissed is null or w.Dismissed = '0') order by d.DateLastComment desc limit 30; DiscussionModel->Get('0', '30')0.000397s select d.InsertUserID as `FirstUserID`, d.DateInserted as `FirstDate`, d.CountBookmarks as `CountBookmarks`, iu.Name as `FirstName`, iu.Photo as `FirstPhoto`, d.Body as `Body`, d.Format as `Format`, d.DateLastComment as `LastDate`, d.LastCommentUserID as `LastUserID`, lcu.Name as `LastName`, concat_ws(' → ', pc.Name, ca.Name) as `Category`, ca.UrlCode as `CategoryUrlCode`, d.*, w.UserID as `WatchUserID`, w.DateLastViewed as `DateLastViewed`, w.Dismissed as `Dismissed`, w.Bookmarked as `Bookmarked`, w.CountComments as `CountCommentWatch` from GDN_Discussion d left join GDN_User iu on d.InsertUserID = iu.UserID left join GDN_User lcu on d.LastCommentUserID = lcu.UserID left join GDN_Category ca on d.CategoryID = ca.CategoryID left join GDN_Category pc on ca.ParentCategoryID = pc.CategoryID left join GDN_UserDiscussion w on d.DiscussionID = w.DiscussionID and w.UserID = 1 where d.Announce <> '1' order by d.DateLastComment desc limit 30; Page completed in 1.0841s
Comments
When I login, i see these errors at the bottom
Canonical Url: http://mike.sodisruptive.com/forums/discussions/p1
7 queries in 0.00554871559143s
require_once('/home/missy20/public_html/mike/forums/bootstrap.php')0.000139s
select u.*
from GDN_User u
where u.UserID = '1';
require_once('/home/missy20/public_html/mike/forums/bootstrap.php')0.003470s
set names 'utf8';
CategoryModel->GetFull()0.000475s
select c.Name as `Name`, c.CategoryID as `CategoryID`, c.Description as `Description`, c.CountDiscussions as `CountDiscussions`, c.UrlCode as `UrlCode`, p.CategoryID as `ParentCategoryID`, p.Name as `ParentName`
from GDN_Category c
left join GDN_Category p on c.ParentCategoryID = p.CategoryID
where c.AllowDiscussions = '1'
and 1 = 1
order by c.Sort asc;
DiscussionModel->Get(0, 10, array('w.Bookmarked' => '1', 'w.UserID' => '1'))0.000486s
select d.InsertUserID as `FirstUserID`, d.DateInserted as `FirstDate`, d.CountBookmarks as `CountBookmarks`, iu.Name as `FirstName`, iu.Photo as `FirstPhoto`, d.Body as `Body`, d.Format as `Format`, d.DateLastComment as `LastDate`, d.LastCommentUserID as `LastUserID`, lcu.Name as `LastName`, concat_ws(' → ', pc.Name, ca.Name) as `Category`, ca.UrlCode as `CategoryUrlCode`, d.*, w.UserID as `WatchUserID`, w.DateLastViewed as `DateLastViewed`, w.Dismissed as `Dismissed`, w.Bookmarked as `Bookmarked`, w.CountComments as `CountCommentWatch`
from GDN_Discussion d
left join GDN_User iu on d.InsertUserID = iu.UserID
left join GDN_User lcu on d.LastCommentUserID = lcu.UserID
left join GDN_Category ca on d.CategoryID = ca.CategoryID
left join GDN_Category pc on ca.ParentCategoryID = pc.CategoryID
left join GDN_UserDiscussion w on d.DiscussionID = w.DiscussionID and w.UserID = 1
where w.Bookmarked = '1'
and w.UserID = '1'
order by d.DateLastComment desc
limit 10;
DiscussionModel->GetCount()0.000166s
select sum(c.CountDiscussions) as `CountDiscussions`
from GDN_Category c;
DiscussionModel->GetAnnouncements()0.000416s
select d.InsertUserID as `FirstUserID`, d.DateInserted as `FirstDate`, d.CountBookmarks as `CountBookmarks`, iu.Name as `FirstName`, iu.Photo as `FirstPhoto`, d.Body as `Body`, d.Format as `Format`, d.DateLastComment as `LastDate`, d.LastCommentUserID as `LastUserID`, lcu.Name as `LastName`, concat_ws(' → ', pc.Name, ca.Name) as `Category`, ca.UrlCode as `CategoryUrlCode`, d.*, w.UserID as `WatchUserID`, w.DateLastViewed as `DateLastViewed`, w.Dismissed as `Dismissed`, w.Bookmarked as `Bookmarked`, w.CountComments as `CountCommentWatch`
from GDN_Discussion d
left join GDN_User iu on d.InsertUserID = iu.UserID
left join GDN_User lcu on d.LastCommentUserID = lcu.UserID
left join GDN_Category ca on d.CategoryID = ca.CategoryID
left join GDN_Category pc on ca.ParentCategoryID = pc.CategoryID
left join GDN_UserDiscussion w on d.DiscussionID = w.DiscussionID and w.UserID = 1
where d.Announce = '1'
and (w.Dismissed is null
or w.Dismissed = '0')
order by d.DateLastComment desc
limit 30;
DiscussionModel->Get('0', '30')0.000397s
select d.InsertUserID as `FirstUserID`, d.DateInserted as `FirstDate`, d.CountBookmarks as `CountBookmarks`, iu.Name as `FirstName`, iu.Photo as `FirstPhoto`, d.Body as `Body`, d.Format as `Format`, d.DateLastComment as `LastDate`, d.LastCommentUserID as `LastUserID`, lcu.Name as `LastName`, concat_ws(' → ', pc.Name, ca.Name) as `Category`, ca.UrlCode as `CategoryUrlCode`, d.*, w.UserID as `WatchUserID`, w.DateLastViewed as `DateLastViewed`, w.Dismissed as `Dismissed`, w.Bookmarked as `Bookmarked`, w.CountComments as `CountCommentWatch`
from GDN_Discussion d
left join GDN_User iu on d.InsertUserID = iu.UserID
left join GDN_User lcu on d.LastCommentUserID = lcu.UserID
left join GDN_Category ca on d.CategoryID = ca.CategoryID
left join GDN_Category pc on ca.ParentCategoryID = pc.CategoryID
left join GDN_UserDiscussion w on d.DiscussionID = w.DiscussionID and w.UserID = 1
where d.Announce <> '1'
order by d.DateLastComment desc
limit 30;
Page completed in 1.0841s
Check that the value of `$Configuration['Garden']['Debug']` is false in your `conf/config.php` file.