SELECT 
  object_id 
FROM 
  q_images_links 
WHERE 
  object_type = 'abt__yt_mwi__icon'

Query time 0.06500

JSON explain

{
  "query_block": {
    "select_id": 1,
    "cost_info": {
      "query_cost": "6355.76"
    },
    "table": {
      "table_name": "q_images_links",
      "access_type": "index",
      "key": "object_id",
      "used_key_parts": [
        "object_id",
        "object_type",
        "type"
      ],
      "key_length": "81",
      "rows_examined_per_scan": 29545,
      "rows_produced_per_join": 2954,
      "filtered": "10.00",
      "using_index": true,
      "cost_info": {
        "read_cost": "5764.87",
        "eval_cost": "590.90",
        "prefix_cost": "6355.77",
        "data_read_per_join": "276K"
      },
      "used_columns": [
        "object_id",
        "object_type"
      ],
      "attached_condition": "(`portal`.`q_images_links`.`object_type` = 'abt__yt_mwi__icon')"
    }
  }
}

Result

object_id
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
233
234
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250