Sandbox

SELECT 
  cscart_product_descriptions.product_id, 
  cscart_product_descriptions.meta_keywords, 
  cscart_product_descriptions.meta_description, 
  cscart_product_descriptions.search_words, 
  cscart_product_descriptions.promo_text 
FROM 
  cscart_product_descriptions 
WHERE 
  cscart_product_descriptions.product_id IN (
    92, 
    370, 
    374, 
    376, 
    382, 
    510, 
    1610, 
    1612, 
    1613, 
    1614, 
    1615, 
    1616, 
    1617, 
    1618, 
    1626, 
    5476, 
    5473, 
    1843, 
    1841, 
    1840, 
    486, 
    3844, 
    1842, 
    3854, 
    3853, 
    3852, 
    3851, 
    3850, 
    3849, 
    3848, 
    3847, 
    3846, 
    3845, 
    3843, 
    3856, 
    3785, 
    3841, 
    3840, 
    3839, 
    3838, 
    3837, 
    3836, 
    3835, 
    3834, 
    3833, 
    3832, 
    3855, 
    3857, 
    3830, 
    3801, 
    3882, 
    3881, 
    3880, 
    3806, 
    3805, 
    3877, 
    3808, 
    3807, 
    3874, 
    3873, 
    3812, 
    3870, 
    3815, 
    3814, 
    3813, 
    3867, 
    3866, 
    3865, 
    3864, 
    3863, 
    3862, 
    3861, 
    3824, 
    3859, 
    3831, 
    3829, 
    3773, 
    3786, 
    3797, 
    3796, 
    3795, 
    3794, 
    3793, 
    3792, 
    3791, 
    3790, 
    3789, 
    3788, 
    3787, 
    3842, 
    3799, 
    3782, 
    3781, 
    3780, 
    3779, 
    3778, 
    3777, 
    3776, 
    3775, 
    3774, 
    3798, 
    3800, 
    3828, 
    3860, 
    3827, 
    3858, 
    3823, 
    3822, 
    3821, 
    3820, 
    3819, 
    3818, 
    3817, 
    3816, 
    3869, 
    3868, 
    3872, 
    3871, 
    3811, 
    3810, 
    3809, 
    3876, 
    3875, 
    3879, 
    3878, 
    3804, 
    3803, 
    3802, 
    3883, 
    3884
  ) 
  AND cscart_product_descriptions.lang_code = 'en'

Query time 0.00387

JSON explain

{
  "query_block": {
    "select_id": 1,
    "table": {
      "table_name": "cscart_product_descriptions",
      "access_type": "range",
      "possible_keys": ["PRIMARY"],
      "key": "PRIMARY",
      "key_length": "9",
      "used_key_parts": ["product_id", "lang_code"],
      "rows": 130,
      "filtered": 100,
      "index_condition": "cscart_product_descriptions.product_id in (92,370,374,376,382,510,1610,1612,1613,1614,1615,1616,1617,1618,1626,5476,5473,1843,1841,1840,486,3844,1842,3854,3853,3852,3851,3850,3849,3848,3847,3846,3845,3843,3856,3785,3841,3840,3839,3838,3837,3836,3835,3834,3833,3832,3855,3857,3830,3801,3882,3881,3880,3806,3805,3877,3808,3807,3874,3873,3812,3870,3815,3814,3813,3867,3866,3865,3864,3863,3862,3861,3824,3859,3831,3829,3773,3786,3797,3796,3795,3794,3793,3792,3791,3790,3789,3788,3787,3842,3799,3782,3781,3780,3779,3778,3777,3776,3775,3774,3798,3800,3828,3860,3827,3858,3823,3822,3821,3820,3819,3818,3817,3816,3869,3868,3872,3871,3811,3810,3809,3876,3875,3879,3878,3804,3803,3802,3883,3884) and cscart_product_descriptions.lang_code = 'en'"
    }
  }
}

Result

product_id	meta_keywords	meta_description	search_words	promo_text
92	Tea Tree Green Tea soap	Melaleuca and 2 other "tea tree essential oils." Creamy lather with moisturizing jojoba oil. With or without oatmeal. Buy 6 get 1 free. Herbaria offers a full spectrum of excellent face and body soaps plus other personal products.
370	bottled natural essential oils
374	essential oils	Here are six of our most popular essential oils. These are the same pure essential oils we use to scent our soaps and other products. You'll find many enjoyable uses for these.The set contains 10ml (.34 oz) of Eucalyptus (Eucalyptus globulus), Lavender
376	shampoo soap bars	Our Shampoo bars are handmade with moisturizing, food-grade vegetable oils and rich emollients to keep your hair and scalp healthy.	bar shampoo, natural shampoo, bar shampoo	<p><span style="font-size: 14pt; font-family: georgia, palatino, serif; color: #008000;">two formulas, four</span><span style="font-size: 14pt; font-family: georgia, palatino, serif; color: #008000;"> scents</span></p>
382	shampoo soap samples sizes	Herbaria Shampoo Cutie Bundles - All Natural - Essential Oils		<span style="font-size: 14pt; font-family: georgia, palatino, serif; color: #008000;">Finer or Thicker, all four scents</span>
486	big bars soap large bars larger	Our bestsellers are nearly twice the size of regular bars. Free shipping on $60 orders. We offer 60 soap varieties for face and body.		<p><span style="font-family: georgia, palatino, serif; font-size: 14pt; color: #008000;">five popular varieties</span></p> <p> </p>
510	Tea Tree Green Tea soap	Melaleuca and 2 other "tea tree essential oils." Creamy lather with moisturizing jojoba oil. With or without oatmeal. Buy 6 get 1 free. Herbaria offers a full spectrum of excellent face and body soaps plus other personal products.
1610	essential oils	Here are six of our most popular essential oils. These are the same pure essential oils we use to scent our soaps and other products. You'll find many enjoyable uses for these.The set contains 10ml (.34 oz) of Eucalyptus (Eucalyptus globulus), Lavender
1612	shampoo soap bars	Our Shampoo bars are handmade with moisturizing, food-grade vegetable oils and rich emollients to keep your hair and scalp healthy.	bar shampoo, natural shampoo, bar shampoo	<p><span style="font-size: 14pt; font-family: georgia, palatino, serif; color: #008000;">two formulas, four</span><span style="font-size: 14pt; font-family: georgia, palatino, serif; color: #008000;"> scents</span></p>
1613	shampoo soap bars	Our Shampoo bars are handmade with moisturizing, food-grade vegetable oils and rich emollients to keep your hair and scalp healthy.	bar shampoo, natural shampoo, bar shampoo	<p><span style="font-size: 14pt; font-family: georgia, palatino, serif; color: #008000;">two formulas, four</span><span style="font-size: 14pt; font-family: georgia, palatino, serif; color: #008000;"> scents</span></p>
1614	shampoo soap bars	Our Shampoo bars are handmade with moisturizing, food-grade vegetable oils and rich emollients to keep your hair and scalp healthy.	bar shampoo, natural shampoo, bar shampoo	<p><span style="font-size: 14pt; font-family: georgia, palatino, serif; color: #008000;">two formulas, four</span><span style="font-size: 14pt; font-family: georgia, palatino, serif; color: #008000;"> scents</span></p>
1615	shampoo soap bars	Our Shampoo bars are handmade with moisturizing, food-grade vegetable oils and rich emollients to keep your hair and scalp healthy.	bar shampoo, natural shampoo, bar shampoo	<p><span style="font-size: 14pt; font-family: georgia, palatino, serif; color: #008000;">two formulas, four</span><span style="font-size: 14pt; font-family: georgia, palatino, serif; color: #008000;"> scents</span></p>
1616	shampoo soap bars	Our Shampoo bars are handmade with moisturizing, food-grade vegetable oils and rich emollients to keep your hair and scalp healthy.	bar shampoo, natural shampoo, bar shampoo	<p><span style="font-size: 14pt; font-family: georgia, palatino, serif; color: #008000;">two formulas, four</span><span style="font-size: 14pt; font-family: georgia, palatino, serif; color: #008000;"> scents</span></p>
1617	shampoo soap bars	Our Shampoo bars are handmade with moisturizing, food-grade vegetable oils and rich emollients to keep your hair and scalp healthy.	bar shampoo, natural shampoo, bar shampoo	<p><span style="font-size: 14pt; font-family: georgia, palatino, serif; color: #008000;">two formulas, four</span><span style="font-size: 14pt; font-family: georgia, palatino, serif; color: #008000;"> scents</span></p>
1618	shampoo soap bars	Our Shampoo bars are handmade with moisturizing, food-grade vegetable oils and rich emollients to keep your hair and scalp healthy.	bar shampoo, natural shampoo, bar shampoo	<p><span style="font-size: 14pt; font-family: georgia, palatino, serif; color: #008000;">two formulas, four</span><span style="font-size: 14pt; font-family: georgia, palatino, serif; color: #008000;"> scents</span></p>
1626	shampoo soap samples sizes	Herbaria Shampoo Cutie Bundles - All Natural - Essential Oils		<span style="font-size: 14pt; font-family: georgia, palatino, serif; color: #008000;">Finer or Thicker, all four scents</span>
1840	big bars soap large bars larger	Our bestsellers are nearly twice the size of regular bars. Free shipping on $60 orders. We offer 60 soap varieties for face and body.		<p><span style="font-family: georgia, palatino, serif; font-size: 14pt; color: #008000;">five popular varieties</span></p> <p> </p>
1841	big bars soap large bars larger	Our bestsellers are nearly twice the size of regular bars. Free shipping on $60 orders. We offer 60 soap varieties for face and body.		<p><span style="font-family: georgia, palatino, serif; font-size: 14pt; color: #008000;">five popular varieties</span></p> <p> </p>
1842	big bars soap large bars larger	Our bestsellers are nearly twice the size of regular bars. Free shipping on $60 orders. We offer 60 soap varieties for face and body.		<p><span style="font-family: georgia, palatino, serif; font-size: 14pt; color: #008000;">five popular varieties</span></p> <p> </p>
1843	big bars soap large bars larger	Our bestsellers are nearly twice the size of regular bars. Free shipping on $60 orders. We offer 60 soap varieties for face and body.		<p><span style="font-family: georgia, palatino, serif; font-size: 14pt; color: #008000;">five popular varieties</span></p> <p> </p>
3773	bottled natural essential oils
3774	bottled natural essential oils
3775	bottled natural essential oils
3776	bottled natural essential oils
3777	bottled natural essential oils
3778	bottled natural essential oils
3779	bottled natural essential oils
3780	bottled natural essential oils
3781	bottled natural essential oils
3782	bottled natural essential oils
3785	bottled natural essential oils
3786	bottled natural essential oils
3787	bottled natural essential oils
3788	bottled natural essential oils
3789	bottled natural essential oils
3790	bottled natural essential oils
3791	bottled natural essential oils
3792	bottled natural essential oils
3793	bottled natural essential oils
3794	bottled natural essential oils
3795	bottled natural essential oils
3796	bottled natural essential oils
3797	bottled natural essential oils
3798	bottled natural essential oils
3799	bottled natural essential oils
3800	bottled natural essential oils
3801	bottled natural essential oils
3802	bottled natural essential oils
3803	bottled natural essential oils
3804	bottled natural essential oils
3805	bottled natural essential oils
3806	bottled natural essential oils
3807	bottled natural essential oils
3808	bottled natural essential oils
3809	bottled natural essential oils
3810	bottled natural essential oils
3811	bottled natural essential oils
3812	bottled natural essential oils
3813	bottled natural essential oils
3814	bottled natural essential oils
3815	bottled natural essential oils
3816	bottled natural essential oils
3817	bottled natural essential oils
3818	bottled natural essential oils
3819	bottled natural essential oils
3820	bottled natural essential oils
3821	bottled natural essential oils
3822	bottled natural essential oils
3823	bottled natural essential oils
3824	bottled natural essential oils
3827	bottled natural essential oils
3828	bottled natural essential oils
3829	bottled natural essential oils
3830	bottled natural essential oils
3831	bottled natural essential oils
3832	bottled natural essential oils
3833	bottled natural essential oils
3834	bottled natural essential oils
3835	bottled natural essential oils
3836	bottled natural essential oils
3837	bottled natural essential oils
3838	bottled natural essential oils
3839	bottled natural essential oils
3840	bottled natural essential oils
3841	bottled natural essential oils
3842	bottled natural essential oils
3843	bottled natural essential oils
3844	bottled natural essential oils
3845	bottled natural essential oils
3846	bottled natural essential oils
3847	bottled natural essential oils
3848	bottled natural essential oils
3849	bottled natural essential oils
3850	bottled natural essential oils
3851	bottled natural essential oils
3852	bottled natural essential oils
3853	bottled natural essential oils
3854	bottled natural essential oils
3855	bottled natural essential oils
3856	bottled natural essential oils
3857	bottled natural essential oils
3858	bottled natural essential oils
3859	bottled natural essential oils
3860	bottled natural essential oils
3861	bottled natural essential oils
3862	bottled natural essential oils
3863	bottled natural essential oils
3864	bottled natural essential oils
3865	bottled natural essential oils
3866	bottled natural essential oils
3867	bottled natural essential oils
3868	bottled natural essential oils
3869	bottled natural essential oils
3870	bottled natural essential oils
3871	bottled natural essential oils
3872	bottled natural essential oils
3873	bottled natural essential oils
3874	bottled natural essential oils
3875	bottled natural essential oils
3876	bottled natural essential oils
3877	bottled natural essential oils
3878	bottled natural essential oils
3879	bottled natural essential oils
3880	bottled natural essential oils
3881	bottled natural essential oils
3882	bottled natural essential oils
3883	bottled natural essential oils
3884	bottled natural essential oils
5473	big bars soap large bars larger	Our bestsellers are nearly twice the size of regular bars. Free shipping on $60 orders. We offer 60 soap varieties for face and body.		<p><span style="font-family: georgia, palatino, serif; font-size: 14pt; color: #008000;">five popular varieties</span></p> <p> </p>
5476	shampoo soap bars	Our Shampoo bars are handmade with moisturizing, food-grade vegetable oils and rich emollients to keep your hair and scalp healthy.	bar shampoo, natural shampoo, bar shampoo	<p><span style="font-size: 14pt; font-family: georgia, palatino, serif; color: #008000;">two formulas, four</span><span style="font-size: 14pt; font-family: georgia, palatino, serif; color: #008000;"> scents</span></p>