我想知道是否有一种方法可以打印出带有limit和limitstart等完整查询。我可以输出$query这一行,但是我想看看为什么限制不起作用,而且我似乎无法显示它发送到数据库的实际查询。以下是代码:
$params =& JComponentHelper::getParams('com_news');
$limit = $params->get('x_items', 5);
$limitstart = JRequest::getVar('limitstart', 0);
$query = "SELECT * FROM #__news WHERE published = 1 AND catid = ".$Itemid." ORDER BY date DESC";
$db->setQuery($query, $limitstart, $limit);
$rows = $db->loadObjectList();
$db->getQuery($query, $limitstart, $limit); 只显示了 "SELECT * FROM jos_news WHERE published = 1 AND catid = 8 ORDER BY date DESC",该查询没有在末尾包含 LIMIT 参数。请您提供帮助,感谢!