def get_profile(self, profile_count=50):
        """
        Get profile of query execution time.

        :param int profile_count:
            Number of profiles to retrieve,
            counted from the top query in descending order by
            the cumulative execution time.
        :return: Profile information for each query.
        :rtype: list of |namedtuple|
        :raises simplesqlite.NullDatabaseConnectionError:
            |raises_check_connection|
        :raises sqlite3.OperationalError: |raises_operational_error|
        """

        from collections import namedtuple

        TN_SQL_PROFILE = "sql_profile"

        value_matrix = [
            [query, execute_time, self.__dict_query_count.get(query, 0)]
            for query, execute_time
            in six.iteritems(self.__dict_query_totalexectime)
        ]
        attribute_name_list = ("query", "cumulative_time", "count")
        con_tmp = simplesqlite.connect_sqlite_db_mem()
        try:
            con_tmp.create_table_with_data(
                TN_SQL_PROFILE,
                attribute_name_list,
                data_matrix=value_matrix)
        except ValueError:
            return []

        try:
            result = con_tmp.select(
                select="%s,SUM(%s),SUM(%s)" % attribute_name_list,
                table_name=TN_SQL_PROFILE,
                extra="GROUP BY %s ORDER BY %s DESC LIMIT %d" % (
                    "query", "cumulative_time", profile_count))
        except sqlite3.OperationalError:
            return []
        if result is None:
            return []

        SqliteProfile = namedtuple(
            "SqliteProfile", " ".join(attribute_name_list))

        return [SqliteProfile(*profile) for profile in result.fetchall()]
dataset/ETHPy150Open thombashi/SimpleSQLite/simplesqlite/core.py/SimpleSQLite.get_profile/original