```transaction { TransactionManager.cu...

# exposed

[douglarek]

transaction {
            TransactionManager.current().debug = true
            logger.addLogger(StdOutSqlLogger())
            val distinctName = Medicine.name.distinct()
            Medicine.slice(Medicine.id, distinctName, Medicine.company).select {
                Medicine.name like "$key%" and Medicine.deletedAt.isNull()
            }.orderBy(Medicine.id).limit(if (perPage > 25) 25 else perPage, if (page > 1) page - 1 else 0).map {
                Summary(it[Medicine.id], it[distinctName], it[Medicine.company])
            }
            println(TransactionManager.current().statements.toString())
        }