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 (
    370, 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.00192

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": 115,
      "filtered": 100,
      "index_condition": "cscart_product_descriptions.product_id in (370,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	promo_text
370	bottled natural essential oils
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>
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>