Sandbox

SELECT 
  * 
FROM 
  kl_ingredients_master 
where 
  ingredient_id = 779

Query time 0.00023

JSON explain

{
  "query_block": {
    "select_id": 1,
    "cost_info": {
      "query_cost": "1.00"
    },
    "table": {
      "table_name": "kl_ingredients_master",
      "access_type": "const",
      "possible_keys": [
        "PRIMARY"
      ],
      "key": "PRIMARY",
      "used_key_parts": [
        "ingredient_id"
      ],
      "key_length": "3",
      "ref": [
        "const"
      ],
      "rows_examined_per_scan": 1,
      "rows_produced_per_join": 1,
      "filtered": "100.00",
      "cost_info": {
        "read_cost": "0.00",
        "eval_cost": "0.10",
        "prefix_cost": "0.00",
        "data_read_per_join": "3K"
      },
      "used_columns": [
        "ingredient_id",
        "ingredient_name",
        "description",
        "ewg_score",
        "ewg_score_min",
        "ewq_data_level",
        "cancer_risk",
        "allergies_immunotoxicity_risk",
        "developmental_reproductive_risk",
        "functions",
        "concerns",
        "other_concerns",
        "synonyms",
        "ecom_variant_ids",
        "creation_timestamp",
        "update_timestamp"
      ]
    }
  }
}

Result

ingredient_id	ingredient_name	description	ewg_score	ewg_score_min	ewq_data_level	cancer_risk	allergies_immunotoxicity_risk	developmental_reproductive_risk	functions	concerns	other_concerns	synonyms	ecom_variant_ids	creation_timestamp	update_timestamp
779	retinol	<p>Retinol is a potent form of synthetic vitamin A. Data from an FDA study indicate that retinoid ingredients may speed the development of skin tumors and lesions on sun-exposed skin. FDA, Norwegian and German health agencies have raised a concern that daily skin application of vitamin A creams may contribute to excessive vitamin A intake for pregnant women and other populations.</p>	9	9	Fair	MODERATE	LOW	HIGH	It stimulates skin renewal, promotes collagen production to reduce wrinkles, addresses hyperpigmentation for an even complexion, prevents acne by unclogging pores, improves skin texture, acts as an antioxidant to combat free radicals, and supports skin hydration and barrier function. Incorporating retinol into a skincare routine can contribute to a smoother, more radiant, and healthier complexion, although caution is advised to manage potential sensitivity.		Use restrictions (high), Non-reproductive organ system toxicity (low), and Biochemical or cellular level changes (high)		[{"variant_id": 29983}, {"variant_id": 42568}, {"variant_id": 46282}, {"variant_id": 37178}, {"variant_id": 40454}, {"variant_id": 51581}, {"variant_id": 42973}, {"variant_id": 24069}, {"variant_id": 38399}, {"variant_id": 12235}, {"variant_id": 43072}]	1696310933	1696310933