SELECT 
  cscart_seo_names.object_id AS product_id, 
  cscart_seo_names.name AS seo_name, 
  cscart_seo_names.path AS seo_path 
FROM 
  cscart_seo_names 
WHERE 
  cscart_seo_names.object_id IN (
    101335, 101336, 101337, 101338, 101339, 
    101340, 101341, 101342, 101343, 101344, 
    101345, 101346, 101347, 101348, 101349, 
    101350, 101351, 101352, 101353, 101354, 
    101355, 101356, 101357, 101358, 101359, 
    101360, 101361, 101362, 101363, 101364, 
    101365, 101366, 101367, 101368, 101369, 
    101370, 101371, 101372, 101373, 101374, 
    101375, 101376, 101377, 101378, 101379, 
    101380, 101381, 101382, 101383, 101384, 
    101385, 101386, 101387, 101388, 101389, 
    101390, 101391, 101392, 101393, 101394, 
    101395, 101396, 101397, 101398, 101399, 
    101400, 101401, 101402, 101403, 101404, 
    101405, 101406, 101407, 101408, 101409, 
    101410, 101411, 101412, 101413, 101414, 
    101415, 101416, 101417, 101418, 101419, 
    101420, 101421, 101422, 101423, 101424, 
    101425, 101426, 101427, 101428, 101429, 
    101430
  ) 
  AND cscart_seo_names.type = "p" 
  AND cscart_seo_names.dispatch = "" 
  AND cscart_seo_names.lang_code = 'en'

Query time 0.00253

JSON explain

{
  "query_block": {
    "select_id": 1,
    "cost_info": {
      "query_cost": "43.23"
    },
    "table": {
      "table_name": "cscart_seo_names",
      "access_type": "range",
      "possible_keys": [
        "PRIMARY",
        "dispatch"
      ],
      "key": "PRIMARY",
      "used_key_parts": [
        "object_id",
        "type",
        "dispatch",
        "lang_code"
      ],
      "key_length": "206",
      "rows_examined_per_scan": 96,
      "rows_produced_per_join": 96,
      "filtered": "100.00",
      "cost_info": {
        "read_cost": "33.63",
        "eval_cost": "9.60",
        "prefix_cost": "43.23",
        "data_read_per_join": "162K"
      },
      "used_columns": [
        "name",
        "object_id",
        "type",
        "dispatch",
        "path",
        "lang_code"
      ],
      "attached_condition": "((`nuie_scalesta_net`.`cscart_seo_names`.`object_id` in (101335,101336,101337,101338,101339,101340,101341,101342,101343,101344,101345,101346,101347,101348,101349,101350,101351,101352,101353,101354,101355,101356,101357,101358,101359,101360,101361,101362,101363,101364,101365,101366,101367,101368,101369,101370,101371,101372,101373,101374,101375,101376,101377,101378,101379,101380,101381,101382,101383,101384,101385,101386,101387,101388,101389,101390,101391,101392,101393,101394,101395,101396,101397,101398,101399,101400,101401,101402,101403,101404,101405,101406,101407,101408,101409,101410,101411,101412,101413,101414,101415,101416,101417,101418,101419,101420,101421,101422,101423,101424,101425,101426,101427,101428,101429,101430)) and (`nuie_scalesta_net`.`cscart_seo_names`.`type` = 'p') and (`nuie_scalesta_net`.`cscart_seo_names`.`dispatch` = '') and (`nuie_scalesta_net`.`cscart_seo_names`.`lang_code` = 'en'))"
    }
  }
}

Result

product_id seo_name seo_path
101335 ffhr3103 7170/7200
101336 ffhr3104l 7170/7200
101337 ffhr3104r 7170/7200
101338 ffhr3105l 7170/7200
101339 ffhr3105r 7170/7200
101340 ffhr3106l 7170/7200
101341 ffhr3106r 7170/7200
101342 ffhr3107l 7170/7200
101343 ffhr3107r 7170/7200
101344 ffhr3108l 7170/7200
101345 ffhr3108r 7170/7200
101346 ffhr3109l 7170/7200
101347 ffhr3109r 7170/7200
101348 ffhr3110l 7170/7200
101349 ffhr3110r 7170/7200
101350 ffhr3111l 7170/7200
101351 ffhr3111r 7170/7200
101352 ffhr3112l 7170/7200
101353 ffhr3112r 7170/7200
101354 ffhr3113 7170/7200
101355 ffhr3114 7170/7200
101356 ffhr3115 7170/7200
101357 ffhr3116 7170/7200
101358 ffhr3201 7170/7200
101359 ffhr3202 7170/7200
101360 ffhr3203 7170/7200
101361 ffhr3204l 7170/7200
101362 ffhr3204r 7170/7200
101363 ffhr3205l 7170/7200
101364 ffhr3205r 7170/7200
101365 ffhr3206l 7170/7200
101366 ffhr3206r 7170/7200
101367 ffhr3207l 7170/7200
101368 ffhr3207r 7170/7200
101369 ffhr3208l 7170/7200
101370 ffhr3208r 7170/7200
101371 ffhr3209l 7170/7200
101372 ffhr3209r 7170/7200
101373 ffhr3210l 7170/7200
101374 ffhr3210r 7170/7200
101375 ffhr3211l 7170/7200
101376 ffhr3211r 7170/7200
101377 ffhr3212l 7170/7200
101378 ffhr3212r 7170/7200
101379 ffhr3213 7170/7200
101380 ffhr3214 7170/7200
101381 ffhr3215 7170/7200
101382 ffhr3216 7170/7200
101383 fflr101 7170/7200
101384 fflr102 7170/7200
101385 fflr103 7170/7200
101386 fflr104l 7170/7200
101387 fflr104r 7170/7200
101388 fflr105l 7170/7200
101389 fflr105r 7170/7200
101390 fflr106l 7170/7200
101391 fflr106r 7170/7200
101392 fflr107l 7170/7200
101393 fflr107r 7170/7200
101394 fflr108l 7170/7200
101395 fflr108r 7170/7200
101396 fflr109l 7170/7200
101397 fflr109r 7170/7200
101398 fflr110l 7170/7200
101399 fflr110r 7170/7200
101400 fflr111l 7170/7200
101401 fflr111r 7170/7200
101402 fflr112l 7170/7200
101403 fflr112r 7170/7200
101404 fflr113 7170/7200
101405 fflr114 7170/7200
101406 fflr115 7170/7200
101407 fflr116 7170/7200
101408 fflr1401 7170/7200
101409 fflr1402 7170/7200
101410 fflr1403 7170/7200
101411 fflr1404l 7170/7200
101412 fflr1404r 7170/7200
101413 fflr1405l 7170/7200
101414 fflr1405r 7170/7200
101415 fflr1406l 7170/7200
101416 fflr1406r 7170/7200
101417 fflr1407l 7170/7200
101418 fflr1407r 7170/7200
101419 fflr1408l 7170/7200
101420 fflr1408r 7170/7200
101421 fflr1409l 7170/7200
101422 fflr1409r 7170/7200
101423 fflr1410l 7170/7200
101424 fflr1410r 7170/7200
101425 fflr1411l 7170/7200
101426 fflr1411r 7170/7200
101427 fflr1412l 7170/7200
101428 fflr1412r 7170/7200
101429 fflr1413 7170/7200
101430 fflr1414 7170/7200