N98\Util\Console\Helper\DatabaseHelper::runShowCommand PHP Метод

    private function runShowCommand($command, $variable = null)
    {
        $db = $this->getConnection();
        if (null !== $variable) {
            $statement = $db->prepare('SHOW /*!50000 GLOBAL */ ' . $command . ' LIKE :like', array(PDO::ATTR_CURSOR => PDO::CURSOR_FWDONLY));
            $statement->execute(array(':like' => $variable));
        } else {
            $statement = $db->query('SHOW /*!50000 GLOBAL */ ' . $command);
        }
        if ($statement) {
            /** @var array|string[] $result */
            $result = $statement->fetchAll(PDO::FETCH_ASSOC);
            $return = array();
            foreach ($result as $row) {
                $return[$row['Variable_name']] = $row['Value'];
            }
            return $return;
        }
        return array();
    }