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 (
    4, 
    1, 
    5, 
    7, 
    8, 
    9, 
    10, 
    11, 
    12, 
    13, 
    14, 
    15, 
    16, 
    17, 
    18, 
    19, 
    20, 
    21, 
    22, 
    23, 
    24, 
    25, 
    26, 
    27, 
    28, 
    29, 
    30, 
    31, 
    32, 
    33, 
    34, 
    35, 
    36, 
    37, 
    38, 
    39, 
    40, 
    41, 
    42, 
    43, 
    44, 
    45, 
    46, 
    47, 
    48, 
    49, 
    50, 
    51, 
    52, 
    53, 
    54, 
    55, 
    56, 
    57, 
    58, 
    59, 
    60, 
    62, 
    63, 
    64, 
    65, 
    67, 
    68, 
    69, 
    70, 
    71, 
    72, 
    73, 
    74, 
    75, 
    76, 
    78, 
    79, 
    80, 
    81, 
    82, 
    83, 
    84, 
    85, 
    86, 
    87, 
    88, 
    89, 
    90, 
    91, 
    92, 
    93, 
    94, 
    95, 
    96, 
    97, 
    100, 
    101, 
    102, 
    103, 
    104, 
    105, 
    106, 
    107, 
    108, 
    109, 
    110, 
    111, 
    112, 
    113, 
    114, 
    115, 
    116, 
    117, 
    118, 
    119, 
    120, 
    121, 
    122, 
    123, 
    124, 
    125, 
    126, 
    127, 
    128, 
    129, 
    130, 
    131, 
    132, 
    133, 
    134, 
    135, 
    136
  ) 
  AND cscart_seo_names.type = "p" 
  AND cscart_seo_names.dispatch = "" 
  AND cscart_seo_names.lang_code = 'en'

Query time 0.00255

JSON explain

{
  "query_block": {
    "select_id": 1,
    "cost_info": {
      "query_cost": "90.36"
    },
    "table": {
      "table_name": "cscart_seo_names",
      "access_type": "ALL",
      "possible_keys": [
        "PRIMARY",
        "dispatch"
      ],
      "rows_examined_per_scan": 418,
      "rows_produced_per_join": 131,
      "filtered": "31.58",
      "cost_info": {
        "read_cost": "63.96",
        "eval_cost": "26.40",
        "prefix_cost": "90.36",
        "data_read_per_join": "223K"
      },
      "used_columns": [
        "name",
        "object_id",
        "type",
        "dispatch",
        "path",
        "lang_code"
      ],
      "attached_condition": "((`pankajecarter_systemtwo`.`cscart_seo_names`.`object_id` in (4,1,5,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50,51,52,53,54,55,56,57,58,59,60,62,63,64,65,67,68,69,70,71,72,73,74,75,76,78,79,80,81,82,83,84,85,86,87,88,89,90,91,92,93,94,95,96,97,100,101,102,103,104,105,106,107,108,109,110,111,112,113,114,115,116,117,118,119,120,121,122,123,124,125,126,127,128,129,130,131,132,133,134,135,136)) and (`pankajecarter_systemtwo`.`cscart_seo_names`.`type` = 'p') and (`pankajecarter_systemtwo`.`cscart_seo_names`.`dispatch` = '') and (`pankajecarter_systemtwo`.`cscart_seo_names`.`lang_code` = 'en'))"
    }
  }
}

Result

product_id seo_name seo_path
12 100g-pants 223/224
1 65-class-64-5-diag-led-8000-series-smart-tv 166/174/190
78 adizero-rush-shoes 223/226
5 46-class-45-9-diag-lcd-610-series-tv 166/174/191
23 5-1-channel-blu-ray-3d-home-theater-system 166/174/195
8 toshiba-32tl515u-32-class-1080p-3d-led-hd-tv 166/174/193
79 adizero-tempaia-shoes 223/226
11 collegiate-72-tee 223/224
41 gift-set-onesie-plus-socks 223/225
28 run-perf-7-8-ti 223/225
7 trefoil-hoodie 223/224
27 trefoil-logo-hoodie 223/225
134 creative-zen-style-m300-mp3-player-16gb-black 166/177/182
135 creative-zen-touch-2-mp3-player-8gb-black 166/177/182
133 samsung-galaxy-player-4-0 166/177/179
132 samsung-galaxy-player-5-0 166/177/182
131 catania 203/204/209
122 evolution-sst-2-xo-complete-bike-10spd12 203/204/208
115 evolve-sst-2-x9-complete-bike-10spd-12 203/204/208
129 fore-cr1 203/204/209
127 fore-cr5-sram-red 203/204/209
124 truth-sst-2-x9-complete-bike-10spd-12 203/204/208
15 nike-chambray-super-runner-mens-jacket 223/224
125 samsung-galaxy-s-ii 166/234/237
120 samsung-galaxy-s-ii-epic-4g-touch-black 166/234/237
117 sch-i515 166/234/237
113 sgh-i677 166/234/237
94 batman-arkham-city-x360 245/248
96 batman-arkham-city-x360-ce 245/248
136 blazblue-continuum-shift-extend 245/249
90 f-e-a-r-3-ps3-mx 245/247
95 game-party-in-motion-x360 245/248
89 green-lantern-rise-of-the-manhunters-ps3 245/247
82 legend-of-the-guardians-the-owls-of-gahoole-vg 245/246
84 lego-batman-wii 245/246
85 looney-tunes-acme-arsenal-wii 245/246
88 lord-of-the-rings-war-in-the-north-ps3 245/247
47 marvel-vs-capcom-3-fate-of-two-worlds-special-edition-ps3 245/247
93 scene-it-bright-lights-big-screen-x360 245/248
87 sesame-street-cookies-counting-carnival-wii 245/246
83 speed-racer-the-videogame-wii 245/246
74 droid-3 166/234/240
73 droid-bionic 166/234/240
75 droid-pro 166/234/240
72 droid-razr 166/234/240
76 flipside-with-motoblur 166/234/240
17 101-things-everyone-should-know-about-economics-a-down-and-dirty-guide-to-everything-from-securities-and-derivatives-to-interest-rates-and-hedge-fundsand-what-they-mean-for-you 219/222
20 the-abcs-of-gold-investing-how-to-protect-and-build-your-wealth-with-gold 219/222
13 your-idea-inc-12-steps-to-building-a-million-dollar-business-starting-today 219/222
108 due-date-blu-ray 241/242
104 final-destination-5-blu-ray 241/242
103 fringe-the-complete-third-season-blu-ray 241/242
97 harry-potter-and-the-deathly-hallows-part-2-blu-raydvdultraviolet-digital-copy-combo-pack 241/242
100 the-hangover-part-ii-blu-ray 241/242
4 40-class-40-0-diag-led-5003-series-tv 166/174/190
9 toshiba-42tl515u-42-class-1080p-3d-led-hd-tv 166/174/193
10 toshiba-47tl515u-47-class-1080p-3d-led-hd-tv 166/174/193
18 3d-blu-ray-disc-player-bd-d7000 166/174/194
16 3d-blu-ray-disc-player-bd-d7500 166/174/194
19 toshiba-bdx2150-blu-ray-player 166/174/194
21 toshiba-sd3300-dvd-player 166/174/194
71 droid-incredible-2 166/234/236
70 evo-design-4g 166/234/236
67 htc-wildfire-s-white-t-mobile 166/234/236
86 nokia-700 166/234/238
106 nokia-e5-00 166/234/238
105 nokia-lumia-800 166/234/238
101 nokia-x3-02 166/234/238
69 rhyme 166/234/236
68 titan 166/234/236
81 minnetonka-original-cowhide-driving-moc 223/226
80 nike-tenkay-slip-txtl-womens-shoe 223/226
24 5-1-channel-blu-ray-3d-home-theater-system-en 166/174/195
22 7-1-channel-blu-ray-3d-home-theater-system 166/174/195
59 avh-p4400bh 166/175/188
58 avh-p8400bh 166/175/188
60 avic-z130bt 166/175/176
42 deh-1300mp 166/175/185
39 deh-80prs 166/175/185
40 deh-p8400bh 166/175/185
37 dpx308u 166/175/185
56 gm-6500f 166/175/187
57 gm-d8500m 166/175/187
55 prs-d800 166/175/187
43 fh-p8000bt 166/175/185
30 go-2535-tm-wte 166/175/176
53 kfc-w3012 166/175/202
52 kfc-w3013ps 166/175/202
33 nuvi-2455lt 166/175/176
32 nuvi-3450 166/175/176
29 tomtom-go-live-top-gear-edition 166/175/176
50 ts-d1720c 166/175/186
51 ts-d6902r 166/175/186
49 ts-mr1640 166/175/186
48 ts-mr2040 166/175/186
54 ts-w3002d2d4 166/175/202
65 xrs-9370 166/175/189
64 xrs-9745 166/175/189
63 xrs-9770 166/175/189
62 xrs-9945 166/175/189
25 hw-d7000-av-receiver-with-built-in-blu-ray-disc-player 166/174/195
14 toshiba-40e220u-40-class-1080p-hd-lcd-tv 166/174/191
107 montblanc-classic-collection-money-clip 223/227
109 montblanc-contemporary-collection-key-ring-with-montblanc-emblem 223/227
91 montblanc-nicolas-rieussec-chronograph-automatic 223/227
92 montblanc-timewalker-automatic 223/227
34 nike-untouchable-womens-tank-top 223/225
31 nike-classic-solid-womens-jersey-shorts 223/225
38 nike-futura-unravel-womens-t-shirt 223/225
102 pr-100-womens-white-quartz-watch 223/227
26 mac-os-x-lion-the-missing-manual 219/220
35 managing-enterprise-content-a-unified-content-strategy-2nd-edition 219/220
36 routing-protocols-and-concepts-ccna-exploration-companion-guide 219/220
114 birds-of-prey-the-complete-series-dvd 241/243
112 gone-with-the-wind-2-disc-special-edition 241/243
116 i-am-legend-dvd-ws 241/243
111 last-samurai-the-dvd-ws 241/243
110 roots-30th-anniversary-special-edition-dvd 241/243
46 the-official-sat-study-guide-second-edition-tm 219/221
45 the-process-of-research-in-psychology 219/221
44 u-s-history-and-government-second-edition 219/221
130 casio-dr-210tm 250/251
128 casio-fx-115es 250/251
126 casio-prizm-fx-cg10 250/251
121 fringe-the-complete-third-season 241/244
118 smallville-the-complete-tenth-season 241/244
123 supernatural-the-complete-sixth-season 241/244
119 the-big-bang-theory-the-complete-fourth-season 241/244