Query time 0.00094
JSON explain
{
"query_block": {
"select_id": 1,
"cost_info": {
"query_cost": "6.56"
},
"nested_loop": [
{
"table": {
"table_name": "cscart_products",
"access_type": "const",
"possible_keys": [
"PRIMARY",
"idx_products_inventory"
],
"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",
"idx_prices_discount_lookup",
"idx_prices_min_calc",
"idx_prices_usergroup_lookup",
"idx_prices_usergroup_product"
],
"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",
"idx_product_desc_lang",
"idx_product_name_search",
"idx_product_desc_sort"
],
"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": "pc",
"access_type": "ref",
"possible_keys": [
"PRIMARY",
"link_type",
"pt",
"idx_product_category_lookup",
"idx_products_categories_composite"
],
"key": "idx_products_categories_composite",
"used_key_parts": [
"product_id"
],
"key_length": "3",
"ref": [
"const"
],
"rows_examined_per_scan": 1,
"rows_produced_per_join": 0,
"filtered": "50.00",
"using_index": true,
"cost_info": {
"read_cost": "0.32",
"eval_cost": "0.05",
"prefix_cost": "0.42",
"data_read_per_join": "8"
},
"used_columns": [
"product_id",
"category_id",
"link_type"
],
"attached_condition": "(`cscart_db`.`pc`.`link_type` = 'M')"
}
},
{
"table": {
"table_name": "cc",
"access_type": "eq_ref",
"possible_keys": [
"PRIMARY",
"parent",
"p_category_id",
"idx_categories_parent_status"
],
"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": 0,
"filtered": "100.00",
"cost_info": {
"read_cost": "0.12",
"eval_cost": "0.05",
"prefix_cost": "0.59",
"data_read_per_join": "1K"
},
"used_columns": [
"category_id",
"parent_id"
]
}
},
{
"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": 1,
"rows_produced_per_join": 0,
"filtered": "100.00",
"cost_info": {
"read_cost": "0.12",
"eval_cost": "0.05",
"prefix_cost": "0.77",
"data_read_per_join": "1K"
},
"used_columns": [
"category_id",
"category"
]
}
},
{
"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": 2,
"rows_produced_per_join": 1,
"filtered": "100.00",
"cost_info": {
"read_cost": "0.32",
"eval_cost": "0.10",
"prefix_cost": "1.18",
"data_read_per_join": "16"
},
"used_columns": [
"product_id",
"average_rating"
]
}
},
{
"table": {
"table_name": "opr",
"access_type": "ref",
"possible_keys": [
"idx_product_id",
"idx_product_reviews_status"
],
"key": "idx_product_id",
"used_key_parts": [
"product_id"
],
"key_length": "3",
"ref": [
"const"
],
"rows_examined_per_scan": 3,
"rows_produced_per_join": 3,
"filtered": "100.00",
"cost_info": {
"read_cost": "1.37",
"eval_cost": "0.30",
"prefix_cost": "2.85",
"data_read_per_join": "4K"
},
"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": "idx_product_feature_variant_id",
"used_key_parts": [
"product_id",
"feature_id"
],
"key_length": "6",
"ref": [
"const",
"const"
],
"rows_examined_per_scan": 1,
"rows_produced_per_join": 3,
"filtered": "100.00",
"using_index": true,
"cost_info": {
"read_cost": "1.74",
"eval_cost": "0.30",
"prefix_cost": "4.89",
"data_read_per_join": "120"
},
"used_columns": [
"feature_id",
"product_id",
"variant_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": 3,
"filtered": "100.00",
"cost_info": {
"read_cost": "1.35",
"eval_cost": "0.32",
"prefix_cost": "6.56",
"data_read_per_join": "23K"
},
"used_columns": [
"variant_id",
"variant"
]
}
}
]
}
}
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 |
| 10869 |
8906090498982 |
A |
13 |
349.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;} |
4.67 |
Contour De Force - Mini Blush - 05 Coral Climax (Bright Coral Blush) - 12gm |
Expires in Dec 2023 |
<p>Transform your skin from forgettable to flawless with a pretty pop of colour from the SUGAR Contour De Force Mini Blush. Light and infinitely blendable, a kiss of this blush on your cheeks is all it takes to make you look radiant with minimal effort. The long-wearing colour is effortlessly buildable, which makes it easy to create the entire spectrum of looks from sheer to dramatic. Its lightweight, velvet formulation glides on smoothly to give natural looking colour that lasts the entire day. Swipe it on and score that perfectly flushed look within seconds!</p>
<p><br /></p>
<p><br /></p>
<p><br /></p>
<p><br /></p>
<p>
</p>
<p><strong>How to use:-</strong></p>
<p>You will need next to nothing of this richly pigmented blush to get a nice wash of colour. Tap the brush into the blush pan and flick the stem of the brush to knock off any excess product. Lightly tap on your cheek, and then blend using soft swirling motions.</p> |
<ul><li>Use<strong> KLOVE</strong> & Get flat 5% off orders above Rs. 999.</li><li>Use<strong> GLOW10</strong> & Get Flat 10% off on orders above Rs. 1799.</li></ul> |
4.6667 |
Cheeks |
2717 |
2718 |
28100 |
Sugar Cosmetics |
331.550000 |