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, 
    376, 
    405, 
    1612, 
    1613, 
    1614, 
    1615, 
    1616, 
    1617, 
    1618, 
    1755, 
    1756, 
    1757, 
    1758, 
    1759, 
    1760, 
    1761, 
    1762, 
    1763, 
    1764, 
    1765, 
    1766, 
    1767, 
    1768, 
    1769, 
    1770, 
    1771, 
    3478, 
    3479, 
    3480, 
    5476, 
    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.00379

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": 139,
      "filtered": 100,
      "index_condition": "cscart_product_descriptions.product_id in (370,376,405,1612,1613,1614,1615,1616,1617,1618,1755,1756,1757,1758,1759,1760,1761,1762,1763,1764,1765,1766,1767,1768,1769,1770,1771,3478,3479,3480,5476,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
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>
405	candles, soy candles, all-natural	We are proud to offer you the finest quality hand-poured candles, sure to bring warmth and coziness to any environment. Scents are pure and natural. We use only essential oils for these alluring aromas. Our proprietary, vegan blend of soy, coconut, and ca		<span style="font-family: georgia, palatino, serif; font-size: 14pt; color: #008000;">clean, long-burning</span>
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>
1755	candles, soy candles, all-natural	We are proud to offer you the finest quality hand-poured candles, sure to bring warmth and coziness to any environment. Scents are pure and natural. We use only essential oils for these alluring aromas. Our proprietary, vegan blend of soy, coconut, and ca		<span style="font-family: georgia, palatino, serif; font-size: 14pt; color: #008000;">clean, long-burning</span>
1756	candles, soy candles, all-natural	We are proud to offer you the finest quality hand-poured candles, sure to bring warmth and coziness to any environment. Scents are pure and natural. We use only essential oils for these alluring aromas. Our proprietary, vegan blend of soy, coconut, and ca		<span style="font-family: georgia, palatino, serif; font-size: 14pt; color: #008000;">clean, long-burning</span>
1757	candles, soy candles, all-natural	We are proud to offer you the finest quality hand-poured candles, sure to bring warmth and coziness to any environment. Scents are pure and natural. We use only essential oils for these alluring aromas. Our proprietary, vegan blend of soy, coconut, and ca		<span style="font-family: georgia, palatino, serif; font-size: 14pt; color: #008000;">clean, long-burning</span>
1758	candles, soy candles, all-natural	We are proud to offer you the finest quality hand-poured candles, sure to bring warmth and coziness to any environment. Scents are pure and natural. We use only essential oils for these alluring aromas. Our proprietary, vegan blend of soy, coconut, and ca		<span style="font-family: georgia, palatino, serif; font-size: 14pt; color: #008000;">clean, long-burning</span>
1759	candles, soy candles, all-natural	We are proud to offer you the finest quality hand-poured candles, sure to bring warmth and coziness to any environment. Scents are pure and natural. We use only essential oils for these alluring aromas. Our proprietary, vegan blend of soy, coconut, and ca		<span style="font-family: georgia, palatino, serif; font-size: 14pt; color: #008000;">clean, long-burning</span>
1760	candles, soy candles, all-natural	We are proud to offer you the finest quality hand-poured candles, sure to bring warmth and coziness to any environment. Scents are pure and natural. We use only essential oils for these alluring aromas. Our proprietary, vegan blend of soy, coconut, and ca		<span style="font-family: georgia, palatino, serif; font-size: 14pt; color: #008000;">clean, long-burning</span>
1761	candles, soy candles, all-natural	We are proud to offer you the finest quality hand-poured candles, sure to bring warmth and coziness to any environment. Scents are pure and natural. We use only essential oils for these alluring aromas. Our proprietary, vegan blend of soy, coconut, and ca		<span style="font-family: georgia, palatino, serif; font-size: 14pt; color: #008000;">clean, long-burning</span>
1762	candles, soy candles, all-natural	We are proud to offer you the finest quality hand-poured candles, sure to bring warmth and coziness to any environment. Scents are pure and natural. We use only essential oils for these alluring aromas. Our proprietary, vegan blend of soy, coconut, and ca		<span style="font-family: georgia, palatino, serif; font-size: 14pt; color: #008000;">clean, long-burning</span>
1763	candles, soy candles, all-natural	We are proud to offer you the finest quality hand-poured candles, sure to bring warmth and coziness to any environment. Scents are pure and natural. We use only essential oils for these alluring aromas. Our proprietary, vegan blend of soy, coconut, and ca		<span style="font-family: georgia, palatino, serif; font-size: 14pt; color: #008000;">clean, long-burning</span>
1764	candles, soy candles, all-natural	We are proud to offer you the finest quality hand-poured candles, sure to bring warmth and coziness to any environment. Scents are pure and natural. We use only essential oils for these alluring aromas. Our proprietary, vegan blend of soy, coconut, and ca		<span style="font-family: georgia, palatino, serif; font-size: 14pt; color: #008000;">clean, long-burning</span>
1765	candles, soy candles, all-natural	We are proud to offer you the finest quality hand-poured candles, sure to bring warmth and coziness to any environment. Scents are pure and natural. We use only essential oils for these alluring aromas. Our proprietary, vegan blend of soy, coconut, and ca		<span style="font-family: georgia, palatino, serif; font-size: 14pt; color: #008000;">clean, long-burning</span>
1766	candles, soy candles, all-natural	We are proud to offer you the finest quality hand-poured candles, sure to bring warmth and coziness to any environment. Scents are pure and natural. We use only essential oils for these alluring aromas. Our proprietary, vegan blend of soy, coconut, and ca		<span style="font-family: georgia, palatino, serif; font-size: 14pt; color: #008000;">clean, long-burning</span>
1767	candles, soy candles, all-natural	We are proud to offer you the finest quality hand-poured candles, sure to bring warmth and coziness to any environment. Scents are pure and natural. We use only essential oils for these alluring aromas. Our proprietary, vegan blend of soy, coconut, and ca		<span style="font-family: georgia, palatino, serif; font-size: 14pt; color: #008000;">clean, long-burning</span>
1768	candles, soy candles, all-natural	We are proud to offer you the finest quality hand-poured candles, sure to bring warmth and coziness to any environment. Scents are pure and natural. We use only essential oils for these alluring aromas. Our proprietary, vegan blend of soy, coconut, and ca		<span style="font-family: georgia, palatino, serif; font-size: 14pt; color: #008000;">clean, long-burning</span>
1769	candles, soy candles, all-natural	We are proud to offer you the finest quality hand-poured candles, sure to bring warmth and coziness to any environment. Scents are pure and natural. We use only essential oils for these alluring aromas. Our proprietary, vegan blend of soy, coconut, and ca		<span style="font-family: georgia, palatino, serif; font-size: 14pt; color: #008000;">clean, long-burning</span>
1770	candles, soy candles, all-natural	We are proud to offer you the finest quality hand-poured candles, sure to bring warmth and coziness to any environment. Scents are pure and natural. We use only essential oils for these alluring aromas. Our proprietary, vegan blend of soy, coconut, and ca		<span style="font-family: georgia, palatino, serif; font-size: 14pt; color: #008000;">clean, long-burning</span>
1771	candles, soy candles, all-natural	We are proud to offer you the finest quality hand-poured candles, sure to bring warmth and coziness to any environment. Scents are pure and natural. We use only essential oils for these alluring aromas. Our proprietary, vegan blend of soy, coconut, and ca		<span style="font-family: georgia, palatino, serif; font-size: 14pt; color: #008000;">clean, long-burning</span>
3478	candles, soy candles, all-natural	We are proud to offer you the finest quality hand-poured candles, sure to bring warmth and coziness to any environment. Scents are pure and natural. We use only essential oils for these alluring aromas. Our proprietary, vegan blend of soy, coconut, and ca		<span style="font-family: georgia, palatino, serif; font-size: 14pt; color: #008000;">clean, long-burning</span>
3479	candles, soy candles, all-natural	We are proud to offer you the finest quality hand-poured candles, sure to bring warmth and coziness to any environment. Scents are pure and natural. We use only essential oils for these alluring aromas. Our proprietary, vegan blend of soy, coconut, and ca		<span style="font-family: georgia, palatino, serif; font-size: 14pt; color: #008000;">clean, long-burning</span>
3480	candles, soy candles, all-natural	We are proud to offer you the finest quality hand-poured candles, sure to bring warmth and coziness to any environment. Scents are pure and natural. We use only essential oils for these alluring aromas. Our proprietary, vegan blend of soy, coconut, and ca		<span style="font-family: georgia, palatino, serif; font-size: 14pt; color: #008000;">clean, long-burning</span>
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
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>