mysql> create table t1(c1 int);

Query OK, 0 rows affected (0.01 sec)

mysql> insert into t1 values(1),(2),(3),(4),(5);

Query OK, 5 rows affected (0.00 sec)

Records: 5  Duplicates: 0  Warnings: 0

mysql> select * from t1 order by c1 limit 2,1;

+------+

| c1   |

+------+

|    3 |

+------+

1 row in set (0.00 sec)

mysql> select found_rows();

+--------------+

| found_rows() |

+--------------+

|            5 |

+--------------+

1 row in set (0.00 sec)

mysql> select version();

+-----------------+

| version()       |

+-----------------+

| 10.1.10-MariaDB |

+-----------------+

1 row in set (0.00 sec)

drop table if exists t1;

create table t1(c1 int);

insert into t1 values(1),(2),(3),(4),(5);

select * from t1 order by c1 limit 2,1;

select found_rows();