SELECT 
  * 
FROM 
  kl_ingredients_master 
where 
  ingredient_id = 225

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
225 coconut <p>A coconut is the fruit of the coconut palm (Cocos nucifera). It is a large, brown, and round fruit with a hard, woody outer shell, fibrous husk, and a large seed inside. Oil extracted from the palm is called coconut oil. The seed, commonly referred to as the coconut.</p> 1 1 Fair LOW LOW LOW Coconut serves diverse functions, offering a rich and nutty flavor in culinary applications through its flesh, milk, and oil. Additionally, coconut water provides a refreshing beverage option, and coconut oil finds use in cooking and skincare due to its distinct properties. (1)Use restrictions (meets restrictions and warnings based on EWG review of company data) (2)Non-reproductive organ system toxicity (moderate) (3)Irritation (skin, eyes, or lungs) (moderate)EWG has reviewed the use of this ingredient in the product formulation and found it did not pose significant health concerns. However, there may be concerns associated with the use of the ingredient in other products or formulations. Visit the ingredient page to learn more. (1)Enhanced skin absorption (2)Use restrictions (moderate) (3)Endocrine disruption (low) (4)Non-reproductive organ system toxicity (moderate) (5)Ecotoxicology (low) (6)Contamination concerns (SALICYLIC ACID and TRIMETHYLCYCLOHEXANOL) (1)Cancer (moderate) (2)Allergies/immunotoxicity (moderate) (3)Use restrictions (high) (4)Endocrine disruption (moderate) (1)9-B -D-RIBOFURANOSYL 9H-PURIN-6AMINE (2)9-B-D-RIBOFURANOSYL-9H-PURIN-6-AMINE (3)9-B-D-RIBOFURANOSYLADENINE (4)9H-PURIN-6AMINE, 9-B -D-RIBOFURANOSYL (5)ADENINE RIBOSIDE (6)ADENINE-9 B-D-RIBOFURANOSIDE (7)ADENINE-9-B -D-RIBOFURANOSE (8)ADENOSINE (9)B-D-RIBOFURANOSIDE, ADENINE-9 (1)AMMONIUM DODECYL SULPHATE (2)AMMONIUM LAURYL SULFATE (3)AMMONIUM SALT SULFURIC ACID, MONODODECYL ESTER (4)DODECYL AMMONIUM SULFATE (5)MONODODECYL ESTER AMMONIUM SALT SULFURIC ACID (6)NEOPON LAM (7)SULFURIC ACID, MONODODECYL ESTER, AMMONIUM SALT (1)DEXTROSE (1)2-HYDROXY- 3,3,5-TRIMETHYLCYCLOHEXYL ESTER BENZOIC ACID (2)3,3,5-TRIMETHYL- SALICYLATE CYCLOHEXANOL (3)3,3,5-TRIMETHYLCYCLOHEXYL 2-HYDROXYBENZOATE (4)3,3,5-TRIMETHYLCYCLOHEXYL ESTER BENZOIC ACID, 2-HYDROXY- (5)3,3,5-TRIMETHYLCYCLOHEXYL SALICYLATE (6)BENZOIC ACID, 2-HYDROXY-, 3,3,5-TRIMETHYLCYCLOHEXYL ESTER (7)BENZOIC ACID, 2HYDROXY, 3,3,5TRIMETHYLCYCLOHEXYL ESTER (8)CASWELL NO. 482B (9)CCRIS 4885 (10)COPPERTONE (11)CYCLOHEXANOL, 3,3,5-TRIMETHYL-, SALICYLATE (12)EINECS 204-260-8 (13)EPA PESTICIDE CHEMICAL CODE 076603 (14)FILTERSOL ''A'' (15)HELIOPAN (16)HELIOPHAN (17)HOM (18)HOMOMENTHYL SALICYLATE (19)HOMOSALATE (20)HOMOSALATO (21)HOMOSALATUM (22)M-HOMOMENTHYL SALICYLATE (23)METAHOMOMENTHYL SALICYLATE (24)NSC 164918 (25)SALICYLATE CYCLOHEXANOL, 3,3,5-TRIMETHYL- (26)SALICYLIC ACID, 3,3,5-TRIMETHYLCYCLOHEXYL ESTER (8CI) (27)SALICYLIC ACID, M-HOMOMENTHYL ESTER (1)4H-PYRAN-4-ONE, 5-HYDROXY-2-(HYDROXYMETHYL)- (2)5-HYDROXY-2-(HYDROXYMETHYL)- 4H-PYRAN-4-ONE (3)5-HYDROXY-2-(HYDROXYMETHYL)-4H-PYRAN-4-ONE (4)5-HYDROXY-2-HYDROXYMETHYL-4-PYRONE (5)KOJIC ACID (1)EARTH WAX (2)FOSSIL WAX (3)OZOCERITE (4)OZOKERITE (5)OZOKERITE WAXES (6)WAXES, OZOKERITE (1)COCONUT [{"variant_id": 26792}, {"variant_id": 18350}, {"variant_id": 30841}, {"variant_id": 32316}, {"variant_id": 47592}, {"variant_id": 42798}, {"variant_id": 18346}, {"variant_id": 11495}, {"variant_id": 11571}, {"variant_id": 18348}, {"variant_id": 18349}, {"variant_id": 25900}, {"variant_id": 18342}, {"variant_id": 37441}, {"variant_id": 44019}, {"variant_id": 43454}, {"variant_id": 18601}, {"variant_id": 41751}, {"variant_id": 18623}, {"variant_id": 18347}, {"variant_id": 18591}, {"variant_id": 23599}, {"variant_id": 43049}, {"variant_id": 18343}, {"variant_id": 19234}, {"variant_id": 34195}, {"variant_id": 35563}, {"variant_id": 18340}, {"variant_id": 18341}, {"variant_id": 26092}, {"variant_id": 29922}, {"variant_id": 43520}, {"variant_id": 44741}, {"variant_id": 11983}, {"variant_id": 24871}, {"variant_id": 31333}, {"variant_id": 18344}, {"variant_id": 26679}, {"variant_id": 11984}, {"variant_id": 18345}, {"variant_id": 11985}, {"variant_id": 18590}, {"variant_id": 23774}, {"variant_id": 26861}, {"variant_id": 24581}] 1696310933 1696310933