[Muuss]

select max(id) from doors;

will give you only one row with the biggest value of the id field

select count(id) from doors;

will give you the number of records