SELECT 
  CONCAT(u.firstname, ' ', u.lastname) as author, 
  b.page_id 
FROM 
  cscart_blog_authors as b 
  LEFT JOIN cscart_users as u ON b.user_id = u.user_id 
WHERE 
  b.page_id IN (
    140, 141, 142, 117, 115, 114, 112, 113, 
    111, 110
  )

Query time 0.00068

Explain
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE b range PRIMARY PRIMARY 3 20 Using where; Using index
1 SIMPLE u eq_ref PRIMARY PRIMARY 3 mahm3t_cs443.b.user_id 1

Result

author page_id
Adrian Daniluk 110
110
Krzysztof Ksepko 111
Adrian Daniluk 111
Krzysztof Ksepko 112
Adrian Daniluk 112
Adrian Daniluk 113
113
Krzysztof Ksepko 114
Adrian Daniluk 114
114
Krzysztof Ksepko 115
115
Adrian Daniluk 115
115
Krzysztof Ksepko 117
Adrian Daniluk 117
Krzysztof Ksepko 140
Krzysztof Ksepko 141
Krzysztof Ksepko 142