Query time 0.00078
JSON explain
{
"query_block": {
"select_id": 1,
"cost_info": {
"query_cost": "7.84"
},
"nested_loop": [
{
"table": {
"table_name": "cscart_products",
"access_type": "const",
"possible_keys": [
"PRIMARY"
],
"key": "PRIMARY",
"used_key_parts": [
"product_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": "5K"
},
"used_columns": [
"product_id",
"product_code",
"status",
"company_id",
"list_price",
"shipping_params"
]
}
},
{
"table": {
"table_name": "cscart_product_prices",
"access_type": "const",
"possible_keys": [
"usergroup",
"product_id",
"lower_limit",
"usergroup_id",
"idx_product_prices_usergroup_limit"
],
"key": "usergroup",
"used_key_parts": [
"product_id",
"usergroup_id",
"lower_limit"
],
"key_length": "9",
"ref": [
"const",
"const",
"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": "24"
},
"used_columns": [
"product_id",
"price",
"percentage_discount",
"lower_limit",
"usergroup_id"
]
}
},
{
"table": {
"table_name": "cscart_product_descriptions",
"access_type": "const",
"possible_keys": [
"PRIMARY",
"product_id"
],
"key": "PRIMARY",
"used_key_parts": [
"product_id",
"lang_code"
],
"key_length": "9",
"ref": [
"const",
"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": "4K"
},
"used_columns": [
"product_id",
"lang_code",
"product",
"short_description",
"full_description",
"promo_text"
]
}
},
{
"table": {
"table_name": "cscart_product_review_prepared_data",
"access_type": "ref",
"possible_keys": [
"PRIMARY"
],
"key": "PRIMARY",
"used_key_parts": [
"product_id"
],
"key_length": "3",
"ref": [
"const"
],
"rows_examined_per_scan": 1,
"rows_produced_per_join": 1,
"filtered": "100.00",
"cost_info": {
"read_cost": "0.25",
"eval_cost": "0.10",
"prefix_cost": "0.35",
"data_read_per_join": "16"
},
"used_columns": [
"product_id",
"average_rating"
]
}
},
{
"table": {
"table_name": "opr",
"access_type": "ref",
"possible_keys": [
"idx_product_id"
],
"key": "idx_product_id",
"used_key_parts": [
"product_id"
],
"key_length": "3",
"ref": [
"const"
],
"rows_examined_per_scan": 1,
"rows_produced_per_join": 1,
"filtered": "100.00",
"cost_info": {
"read_cost": "0.25",
"eval_cost": "0.10",
"prefix_cost": "0.70",
"data_read_per_join": "1K"
},
"used_columns": [
"product_id",
"rating_value",
"status"
],
"attached_condition": "<if>(is_not_null_compl(opr), (`cscart_db`.`opr`.`status` = 'A'), true)"
}
},
{
"table": {
"table_name": "pfv",
"access_type": "ref",
"possible_keys": [
"PRIMARY",
"product_id",
"fpl",
"idx_product_feature_variant_id",
"fl"
],
"key": "product_id",
"used_key_parts": [
"product_id",
"feature_id"
],
"key_length": "6",
"ref": [
"const",
"const"
],
"rows_examined_per_scan": 1,
"rows_produced_per_join": 1,
"filtered": "100.00",
"using_index": true,
"cost_info": {
"read_cost": "0.51",
"eval_cost": "0.10",
"prefix_cost": "1.31",
"data_read_per_join": "40"
},
"used_columns": [
"feature_id",
"product_id",
"variant_id"
]
}
},
{
"table": {
"table_name": "pc",
"access_type": "ref",
"possible_keys": [
"PRIMARY",
"link_type",
"pt"
],
"key": "pt",
"used_key_parts": [
"product_id",
"link_type"
],
"key_length": "6",
"ref": [
"const",
"const"
],
"rows_examined_per_scan": 1,
"rows_produced_per_join": 1,
"filtered": "100.00",
"using_index": true,
"cost_info": {
"read_cost": "0.49",
"eval_cost": "0.10",
"prefix_cost": "1.89",
"data_read_per_join": "16"
},
"used_columns": [
"product_id",
"category_id",
"link_type"
]
}
},
{
"table": {
"table_name": "cc",
"access_type": "eq_ref",
"possible_keys": [
"PRIMARY",
"parent",
"p_category_id"
],
"key": "PRIMARY",
"used_key_parts": [
"category_id"
],
"key_length": "3",
"ref": [
"cscart_db.pc.category_id"
],
"rows_examined_per_scan": 1,
"rows_produced_per_join": 1,
"filtered": "100.00",
"cost_info": {
"read_cost": "0.25",
"eval_cost": "0.10",
"prefix_cost": "2.24",
"data_read_per_join": "2K"
},
"used_columns": [
"category_id",
"parent_id"
]
}
},
{
"table": {
"table_name": "pvd",
"access_type": "ref",
"possible_keys": [
"PRIMARY"
],
"key": "PRIMARY",
"used_key_parts": [
"variant_id"
],
"key_length": "3",
"ref": [
"cscart_db.pfv.variant_id"
],
"rows_examined_per_scan": 1,
"rows_produced_per_join": 1,
"filtered": "100.00",
"cost_info": {
"read_cost": "0.25",
"eval_cost": "0.10",
"prefix_cost": "2.59",
"data_read_per_join": "7K"
},
"used_columns": [
"variant_id",
"variant"
]
}
},
{
"table": {
"table_name": "cd",
"access_type": "ref",
"possible_keys": [
"PRIMARY"
],
"key": "PRIMARY",
"used_key_parts": [
"category_id"
],
"key_length": "3",
"ref": [
"cscart_db.cc.parent_id"
],
"rows_examined_per_scan": 15,
"rows_produced_per_join": 15,
"filtered": "100.00",
"cost_info": {
"read_cost": "3.75",
"eval_cost": "1.50",
"prefix_cost": "7.84",
"data_read_per_join": "45K"
},
"used_columns": [
"category_id",
"category"
]
}
}
]
}
}
Result
| product_id |
product_code |
status |
company_id |
list_price |
shipping_params |
average_rating |
product |
short_description |
full_description |
promo_text |
actual_rating |
category |
category_id |
main_category |
variant_id |
variant |
price |
| 36193 |
CR025~old |
D |
13 |
850.00 |
a:5:{s:16:"min_items_in_box";i:0;s:16:"max_items_in_box";i:0;s:10:"box_length";i:0;s:9:"box_width";i:0;s:10:"box_height";i:0;} |
|
Special Offer -Low pH Good Morning Gel Cleanser - 150ml |
Removes skin impurities |
<p>The Good Morning Gel Cleanser is a mildly acidic cleanser with a pH level (5.30~6.30) closest to your skin's natural pH levels. Its slightly acid pH helps clean your skin without stripping it of its natural oils and restores the skin to its optimal pH. A mild yet effective cleanser, it leaves the skin feeling soft and moisturised after use. Formulated with tea tree oil and natural BHA, the Good Morning Gel Cleanser controls excess sebum production, removes dead skin cells and clears pores and minimizes their appearance. Enriched with botanical ingredients it ensures that your skin remains purified. Its gentle formula allows you to use the cleanser day and night to help your skin stay supple and clear. Its transparent gel texture lathers into a fine foam that removes any impurities, and can even be used as a body wash.</p> |
|
3.0000 |
Cleansers |
2686 |
2819 |
10451 |
COSRX |
510.000000 |