Joomla Last Database Query

Joomla Last Database Query

Joomla last database query.As we all know it is a bit difficult to find last executed query in CMS. because there are lots of internal trigger and threads are running. But there is a simple way to find last database query in joomla.

The Query

Joomla’s database querying changed with the introduction of Joomla 1.6. The recommended way of building database queries is through “query chaining” (although string queries are still supported).

Query chaining refers to a method of connecting a number of methods, one after the other, with each method returning an object that can support the next method, improving readability and simplifying code.

To obtain a new instance of the JDatabaseQuery class we use the JDatabaseDriver getQuery method:

$db = JFactory::getDbo();
echo $db->getQuery();
die();