How to get the SQL expression for a collection?

dmitry_fedyuk · February 4, 2016, 4:16pm

Get the corresponding \Magento\Framework\DB\Select instance with the getSelect() method, and then follow the instriction How to get the SQL expression for a \Magento\Framework\DB\Select or \Zend_Db_Select, for example:

$collection->getSelect()->assemble();

You can also use the printLogQuery() method to print or log the SQL query:

github.com

magento/magento2/blob/b3f5588/lib/internal/Magento/Framework/Data/Collection/AbstractDb.php#L710-L728


/**
 * Print and/or log query
 *
 * @param   bool $printQuery
 * @param   bool $logQuery
 * @param   string $sql
 * @return  $this
 */
public function printLogQuery($printQuery = false, $logQuery = false, $sql = null)
{
    if ($printQuery || $this->getFlag('print_query')) {
        echo $sql === null ? $this->getSelect()->__toString() : $sql;
    }


    if ($logQuery || $this->getFlag('log_query')) {
        $this->_logQuery($sql);
    }
    return $this;
}

dmitry_fedyuk · February 4, 2016, 4:43pm