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, 3844, 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.00173

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