Table contains 5.6M rows:

MariaDB [ssb_cs]> explain select count from lineorder\G

• • • • • • • • • • • • • • • • • • • • • • • • • • • 1. row ***************************
                                                      id: 1
                                                      select_type: SIMPLE
                                                      table: lineorder
                                                      type: ALL
                                                      possible_keys: NULL
                                                      key: NULL
                                                      key_len: NULL
                                                      ref: NULL
                                                      rows: 2000
                                                      Extra:
                                                      1 row in set (0.00 sec)