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 (
    91604, 91605, 91606, 91607, 91608, 91609, 
    91625, 91551, 91552, 91553, 91554, 
    91555, 91556, 91557, 91558, 91559, 
    91560, 91597, 91623, 91561, 91562, 
    91563, 91564, 91565, 91566, 91567, 
    91568, 91569, 91570, 91628, 91629, 
    91630, 91631, 91632, 91633, 91634, 
    91635, 91636, 91637, 91638, 91639, 
    91640, 91641, 91642, 91643, 91644, 
    91645, 91646, 91647, 91688, 91689, 
    91690, 91691, 91692, 91693, 91694, 
    91695, 91696, 91697, 91678, 91679, 
    91680, 91681, 91682, 91683, 91684, 
    91685, 91686, 91687, 91590, 91591, 
    91592, 91593, 91594, 91595, 91596, 
    91598, 91599, 91600, 91649, 91650, 
    91651, 91652, 91653, 91654, 91655, 
    91656, 91657, 91659, 91660, 91661, 
    91662, 91663, 91664, 91665, 91666
  ) 
  AND cscart_seo_names.type = "p" 
  AND cscart_seo_names.dispatch = "" 
  AND cscart_seo_names.lang_code = 'en'

Query time 0.00415

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 (91604,91605,91606,91607,91608,91609,91625,91551,91552,91553,91554,91555,91556,91557,91558,91559,91560,91597,91623,91561,91562,91563,91564,91565,91566,91567,91568,91569,91570,91628,91629,91630,91631,91632,91633,91634,91635,91636,91637,91638,91639,91640,91641,91642,91643,91644,91645,91646,91647,91688,91689,91690,91691,91692,91693,91694,91695,91696,91697,91678,91679,91680,91681,91682,91683,91684,91685,91686,91687,91590,91591,91592,91593,91594,91595,91596,91598,91599,91600,91649,91650,91651,91652,91653,91654,91655,91656,91657,91659,91660,91661,91662,91663,91664,91665,91666)) 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
91551 tasse-rimless-freestanding-bath-1770mm-x-880mm-no-waste 7195
91552 tasse-rimless-freestanding-bath-1770mm-x-880mm-no-waste-en 7195
91553 tasse-rimless-freestanding-bath-1770mm-x-880mm-no-waste-en-en 7195
91554 tasse-rimless-freestanding-bath-1770mm-x-880mm-no-waste-en-en-en 7195
91555 tasse-rimless-freestanding-bath-1770mm-x-880mm-no-waste-en-en-en-en 7195
91556 tasse-rimless-freestanding-bath-1770mm-x-880mm-no-waste-en-en-en-en-en 7195
91557 tasse-rimless-freestanding-bath-1770mm-x-880mm-no-waste-en-en-en-en-en-en 7195
91558 tasse-rimless-freestanding-bath-1770mm-x-880mm-no-waste-en-en-en-en-en-en-en 7195
91559 tasse-rimless-freestanding-bath-1770mm-x-880mm-no-waste-en-en-en-en-en-en-en-en 7195
91560 tasse-rimless-freestanding-bath-1770mm-x-880mm-no-waste-en-en-en-en-en-en-en-en-en 7195
91561 delicata-minimalist-freestanding-angled-bath-1520mm-x-715mm-no-waste 7195
91562 delicata-minimalist-freestanding-angled-bath-1520mm-x-715mm-no-waste-en 7195
91563 delicata-minimalist-freestanding-angled-bath-1520mm-x-715mm-no-waste-en-en 7195
91564 delicata-minimalist-freestanding-angled-bath-1520mm-x-715mm-no-waste-en-en-en 7195
91565 delicata-minimalist-freestanding-angled-bath-1520mm-x-715mm-no-waste-en-en-en-en 7195
91566 delicata-minimalist-freestanding-angled-bath-1520mm-x-715mm-no-waste-en-en-en-en-en 7195
91567 delicata-minimalist-freestanding-angled-bath-1520mm-x-715mm-no-waste-en-en-en-en-en-en 7195
91568 delicata-minimalist-freestanding-angled-bath-1520mm-x-715mm-no-waste-en-en-en-en-en-en-en 7195
91569 delicata-minimalist-freestanding-angled-bath-1520mm-x-715mm-no-waste-en-en-en-en-en-en-en-en 7195
91570 delicata-minimalist-freestanding-angled-bath-1520mm-x-715mm-no-waste-en-en-en-en-en-en-en-en-en 7195
91590 bampton-oval-freestanding-bath-with-plinth-1555mm-x-740mm-no-waste 7195
91591 bampton-oval-freestanding-bath-with-plinth-1555mm-x-740mm-no-waste-en 7195
91592 bampton-oval-freestanding-bath-with-plinth-1555mm-x-740mm-no-waste-en-en 7195
91593 bampton-oval-freestanding-bath-with-plinth-1555mm-x-740mm-no-waste-en-en-en 7195
91594 bampton-oval-freestanding-bath-with-plinth-1555mm-x-740mm-no-waste-en-en-en-en 7195
91595 bampton-oval-freestanding-bath-with-plinth-1555mm-x-740mm-no-waste-en-en-en-en-en 7195
91596 bampton-oval-freestanding-bath-with-plinth-1555mm-x-740mm-no-waste-en-en-en-en-en-en 7195
91597 bampton-oval-freestanding-bath-with-plinth-1555mm-x-740mm-no-waste-en-en-en-en-en-en-en 7195
91598 bampton-oval-freestanding-bath-with-plinth-1555mm-x-740mm-no-waste-en-en-en-en-en-en-en-en 7195
91599 bampton-oval-freestanding-bath-with-plinth-1555mm-x-740mm-no-waste-en-en-en-en-en-en-en-en-en 7195
91600 bampton-oval-freestanding-bath-with-plinth-1555mm-x-740mm-no-waste-en-en-en-en-en-en-en-en-en-en 7195
91604 casini-round-scalloped-freestanding-bath-1680mm-x-750mm-no-waste-en-en-en 7195
91605 casini-round-scalloped-freestanding-bath-1680mm-x-750mm-no-waste-en-en-en-en 7195
91606 casini-round-scalloped-freestanding-bath-1680mm-x-750mm-no-waste-en-en-en-en-en 7195
91607 casini-round-scalloped-freestanding-bath-1680mm-x-750mm-no-waste-en-en-en-en-en-en 7195
91608 casini-round-scalloped-freestanding-bath-1680mm-x-750mm-no-waste-en-en-en-en-en-en-en 7195
91609 casini-round-scalloped-freestanding-bath-1680mm-x-750mm-no-waste-en-en-en-en-en-en-en-en 7195
91623 verdicio-freestanding-bath-1680mm-matt-white 7195
91625 wivenhoe-freestanding-bath-1800mm-matt-white 7195
91628 gio-minimalist-egg-shaped-freestanding-bath-1645mm-x-935mm-no-waste 7195
91629 gio-minimalist-egg-shaped-freestanding-bath-1645mm-x-935mm-no-waste-en 7195
91630 gio-minimalist-egg-shaped-freestanding-bath-1645mm-x-935mm-no-waste-en-en 7195
91631 gio-minimalist-egg-shaped-freestanding-bath-1645mm-x-935mm-no-waste-en-en-en 7195
91632 gio-minimalist-egg-shaped-freestanding-bath-1645mm-x-935mm-no-waste-en-en-en-en 7195
91633 gio-minimalist-egg-shaped-freestanding-bath-1645mm-x-935mm-no-waste-en-en-en-en-en 7195
91634 gio-minimalist-egg-shaped-freestanding-bath-1645mm-x-935mm-no-waste-en-en-en-en-en-en 7195
91635 gio-minimalist-egg-shaped-freestanding-bath-1645mm-x-935mm-no-waste-en-en-en-en-en-en-en 7195
91636 gio-minimalist-egg-shaped-freestanding-bath-1645mm-x-935mm-no-waste-en-en-en-en-en-en-en-en 7195
91637 gio-minimalist-egg-shaped-freestanding-bath-1645mm-x-935mm-no-waste-en-en-en-en-en-en-en-en-en 7195
91638 vive-minimalist-square-rimless-freestanding-bath-1610mm-x-750mm-no-waste 7195
91639 vive-minimalist-square-rimless-freestanding-bath-1610mm-x-750mm-no-waste-en 7195
91640 vive-minimalist-square-rimless-freestanding-bath-1610mm-x-750mm-no-waste-en-en 7195
91641 vive-minimalist-square-rimless-freestanding-bath-1610mm-x-750mm-no-waste-en-en-en 7195
91642 vive-minimalist-square-rimless-freestanding-bath-1610mm-x-750mm-no-waste-en-en-en-en 7195
91643 vive-minimalist-square-rimless-freestanding-bath-1610mm-x-750mm-no-waste-en-en-en-en-en 7195
91644 vive-minimalist-square-rimless-freestanding-bath-1610mm-x-750mm-no-waste-en-en-en-en-en-en 7195
91645 vive-minimalist-square-rimless-freestanding-bath-1610mm-x-750mm-no-waste-en-en-en-en-en-en-en 7195
91646 vive-minimalist-square-rimless-freestanding-bath-1610mm-x-750mm-no-waste-en-en-en-en-en-en-en-en 7195
91647 vive-minimalist-square-rimless-freestanding-bath-1610mm-x-750mm-no-waste-en-en-en-en-en-en-en-en-en 7195
91649 esseta-compact-oval-freestanding-bath-1510mm-x-760mm-no-waste-en 7195
91650 esseta-compact-oval-freestanding-bath-1510mm-x-760mm-no-waste-en-en 7195
91651 esseta-compact-oval-freestanding-bath-1510mm-x-760mm-no-waste-en-en-en 7195
91652 esseta-compact-oval-freestanding-bath-1510mm-x-760mm-no-waste-en-en-en-en 7195
91653 esseta-compact-oval-freestanding-bath-1510mm-x-760mm-no-waste-en-en-en-en-en 7195
91654 esseta-compact-oval-freestanding-bath-1510mm-x-760mm-no-waste-en-en-en-en-en-en 7195
91655 esseta-compact-oval-freestanding-bath-1510mm-x-760mm-no-waste-en-en-en-en-en-en-en 7195
91656 esseta-compact-oval-freestanding-bath-1510mm-x-760mm-no-waste-en-en-en-en-en-en-en-en 7195
91657 esseta-compact-oval-freestanding-bath-1510mm-x-760mm-no-waste-en-en-en-en-en-en-en-en-en 7195
91659 sorpressa-compact-round-freestanding-bath-1510mm-x-760mm-no-waste-en 7195
91660 sorpressa-compact-round-freestanding-bath-1510mm-x-760mm-no-waste-en-en 7195
91661 sorpressa-compact-round-freestanding-bath-1510mm-x-760mm-no-waste-en-en-en 7195
91662 sorpressa-compact-round-freestanding-bath-1510mm-x-760mm-no-waste-en-en-en-en 7195
91663 sorpressa-compact-round-freestanding-bath-1510mm-x-760mm-no-waste-en-en-en-en-en 7195
91664 sorpressa-compact-round-freestanding-bath-1510mm-x-760mm-no-waste-en-en-en-en-en-en 7195
91665 sorpressa-compact-round-freestanding-bath-1510mm-x-760mm-no-waste-en-en-en-en-en-en-en 7195
91666 sorpressa-compact-round-freestanding-bath-1510mm-x-760mm-no-waste-en-en-en-en-en-en-en-en 7195
91678 crea-minimalist-round-freestanding-bath-with-overflow-1665mm-x-780mm-no-waste 7195
91679 crea-minimalist-round-freestanding-bath-with-overflow-1665mm-x-780mm-no-waste-en 7195
91680 crea-minimalist-round-freestanding-bath-with-overflow-1665mm-x-780mm-no-waste-en-en 7195
91681 crea-minimalist-round-freestanding-bath-with-overflow-1665mm-x-780mm-no-waste-en-en-en 7195
91682 crea-minimalist-round-freestanding-bath-with-overflow-1665mm-x-780mm-no-waste-en-en-en-en 7195
91683 crea-minimalist-round-freestanding-bath-with-overflow-1665mm-x-780mm-no-waste-en-en-en-en-en 7195
91684 crea-minimalist-round-freestanding-bath-with-overflow-1665mm-x-780mm-no-waste-en-en-en-en-en-en 7195
91685 crea-minimalist-round-freestanding-bath-with-overflow-1665mm-x-780mm-no-waste-en-en-en-en-en-en-en 7195
91686 crea-minimalist-round-freestanding-bath-with-overflow-1665mm-x-780mm-no-waste-en-en-en-en-en-en-en-en 7195
91687 crea-minimalist-round-freestanding-bath-with-overflow-1665mm-x-780mm-no-waste-en-en-en-en-en-en-en-en-en 7195
91688 omnia-oval-rimmed-freestanding-bath-1615mm-x-760mm-no-waste 7195
91689 omnia-oval-rimmed-freestanding-bath-1615mm-x-760mm-no-waste-en 7195
91690 omnia-oval-rimmed-freestanding-bath-1615mm-x-760mm-no-waste-en-en 7195
91691 omnia-oval-rimmed-freestanding-bath-1615mm-x-760mm-no-waste-en-en-en 7195
91692 omnia-oval-rimmed-freestanding-bath-1615mm-x-760mm-no-waste-en-en-en-en 7195
91693 omnia-freestaning-bath-bath-1600mm-no-waste 7195
91694 omnia-oval-rimmed-freestanding-bath-1615mm-x-760mm-no-waste-en-en-en-en-en 7195
91695 omnia-oval-rimmed-freestanding-bath-1615mm-x-760mm-no-waste-en-en-en-en-en-en 7195
91696 omnia-oval-rimmed-freestanding-bath-1615mm-x-760mm-no-waste-en-en-en-en-en-en-en 7195
91697 omnia-oval-rimmed-freestanding-bath-1615mm-x-760mm-no-waste-en-en-en-en-en-en-en-en 7195