SELECT COUNT(cid) FROM contract_module LEFT JOIN module ON module.id = contract_module.mid LEFT JOIN contract ON contract.id = contract_module.cid WHERE module.name = 'ipn' and (contract.date1 is null or contract.date1  <= now() ) and (contract.date2 is null or contract.date2 >= now() )

SELECT COUNT(cid) FROM contract_module LEFT JOIN module ON module.id = contract_module.mid LEFT JOIN contract ON contract.id = contract_module.cid WHERE module.name = 'reports' and (contract.date1 is null or contract.date1  <= now() ) and (contract.date2 is null or contract.date2 >= now() )

SELECT COUNT(cid) FROM contract_module LEFT JOIN module ON module.id = contract_module.mid LEFT JOIN contract ON contract.id = contract_module.cid WHERE module.name = 'dialup' and (contract.date1 is null or contract.date1  <= now() ) and (contract.date2 is null or contract.date2 >= now() )

EXPLAIN SELECT COUNT(cid) FROM contract_module LEFT JOIN module ON module.id = contract_module.mid LEFT JOIN contract ON contract.id = contract_module.cid WHERE module.name = 'ipn' and (contract.date1 is null or contract.date1  <= now() ) and (contract.date2 is null or contract.date2 >= now() )

SELECT COUNT(cid) FROM contract_module LEFT JOIN module ON module.id = contract_module.mid LEFT JOIN contract ON contract.id = contract_module.cid WHERE module.name = 'ipn' and (contract.date1 is null or contract.date1  <= now() ) and (contract.date2 is null or contract.date2 >= now() )

SELECT mid, COUNT(cid) FROM contract_module LEFT JOIN contract ON contract.id = contract_module.cid WHERE (contract.date1 is null or contract.date1  <= now() ) and (contract.date2 is null or contract.date2 >= now()) GROUP BY mid

SELECT SQL_CALC_FOUND_ROWS auth_error.* FROM inet_auth_error_12_201605 AS auth_error WHERE auth_error.lastTime BETWEEN '2016-05-23 00:00:00' AND '2016-05-23 00:00:00' ORDER BY auth_error.lastTime DESC LIMIT 0,30

public class testSelectAuthError
        extends GlobalScriptBase {
    @Override
    public void execute(Setup setup, ConnectionSet connectionSet)
            throws Exception {
        print("Start");
        long timeStart = System.currentTimeMillis();
        String tableName = "inet_auth_error_12_201605";
        Connection con = connectionSet.getConnection();
        int count = 0;
        String query = "";
        query = " SELECT auth_error.id FROM inet_auth_error_12_201605 AS auth_error WHERE auth_error.lastTime BETWEEN '2016-05-23 00:00:00' AND '2016-05-23 00:00:00' ";
        PreparedStatement ps = con.prepareStatement(query);
        ResultSet rs = ps.executeQuery();
        while (rs.next()) {
            count++;
        }
        rs.close();
        ps.close();

        long timeEnd = System.currentTimeMillis();
        print("count = " + count);
        print("query = " + query);
        print("Process time: " + (timeEnd - timeStart) / 1000 + " s.");

    }
}

Start count = 8 query =  SELECT auth_error.id FROM inet_auth_error_12_201605 AS auth_error WHERE auth_error.lastTime BETWEEN '2016-05-23 00:00:00' AND '2016-05-23 00:00:00'  Process time: 33 s.

SELECT * FROM inet_accounting_period_12 WHERE contractId=193734 AND (timeTo IS NULL OR timeTo>='2016-05-27 23:23:39') ORDER BY timeFrom

EXPLAIN SELECT COUNT(cid) FROM contract_module LEFT JOIN module ON module.id = contract_module.mid LEFT JOIN contract ON contract.id = contract_module.cid WHERE module.name = 'ipn' and (contract.date1 is null or contract.date1  <= now() ) and (contract.date2 is null or contract.date2 >= now() )

SELECT COUNT(cid) FROM contract_module LEFT JOIN module ON module.id = contract_module.mid LEFT JOIN contract ON contract.id = contract_module.cid WHERE module.name = 'ipn' and (contract.date1 is null or contract.date1  <= now() ) and (contract.date2 is null or contract.date2 >= now() )

SELECT mid, COUNT(cid) FROM contract_module LEFT JOIN contract ON contract.id = contract_module.cid WHERE (contract.date1 is null or contract.date1  <= now() ) and (contract.date2 is null or contract.date2 >= now()) GROUP BY mid

SELECT mid, COUNT(cid) FROM contract LEFT JOIN contract_module ON contract.id = contract_module.cid WHERE (contract.date1 is null or contract.date1  <= now() ) and (contract.date2 is null or contract.date2 >= now()) GROUP BY mid;

EXPLAIN SELECT mid, COUNT(cid) FROM contract LEFT JOIN contract_module ON contract.id = contract_module.cid WHERE (contract.date1 is null or contract.date1  <= now() ) and (contract.date2 is null or contract.date2 >= now()) GROUP BY mid;