Модуль JComments Latest - страница 19 - Общие вопросы

Результаты профилирования
Application 0.002 seconds (+0.002); 0.81 MB (+0.808) - afterLoad
Application 0.063 seconds (+0.062); 2.63 MB (+1.825) - afterInitialise
Application 0.111 seconds (+0.048); 4.64 MB (+2.005) - afterRoute
Application 0.249 seconds (+0.138); 8.26 MB (+3.622) - afterDispatch
Application 0.268 seconds (+0.018); 8.58 MB (+0.323) - beforeRenderModule mod_menu (Main Menu)
Application 0.324 seconds (+0.056); 8.84 MB (+0.257) - afterRenderModule mod_menu (Main Menu)
Application 0.324 seconds (+0.000); 8.83 MB (-0.010) - beforeRenderModule mod_jcomments_latest (Комментарии)
Application 20.290 seconds (+19.966); 9.07 MB (+0.236) - afterRenderModule mod_jcomments_latest (Комментарии)
Application 20.291 seconds (+0.000); 9.01 MB (-0.056) - beforeRenderModule mod_login (Login Form)
Application 20.305 seconds (+0.014); 9.11 MB (+0.098) - afterRenderModule mod_login (Login Form)
Application 20.312 seconds (+0.008); 9.21 MB (+0.101) - afterRender

$query = "SELECT c.id, c.userid, c.comment, c.title, c.name, c.username, c.email, c.date, c.object_id, c.object_group, '' as avatar"
			. ", o.title AS object_title, o.link AS object_link, o.access AS object_access, o.userid AS object_owner"
			. " FROM #__jcomments AS c"
			. " WHERE c.id in (1,5,6)"
			. " JOIN #__jcomments_objects AS o ON c.object_id = o.object_id AND c.object_group = o.object_group AND c.lang = o.lang"
			. (count($joins)? ' ' . implode(' ', $joins) : '')
			. (count($where)? ' WHERE  ' . implode(' AND ', $where) : '')
			. " ORDER BY " . $orderBy
			;

$where[] = 'c.id IN ('. $idx .')';

$db = JFactory::getDBO();
$query = $db->getQuery(true);
$query->select('c.title');
$query->from('#__categories AS c');
$query->join("INNER","#__content AS a ON c.id = a.catid");
$query->where("a.id = '$item->object_id'");
$db->setQuery($query);
$catrow = $db->loadObject();
echo $catrow->title;