Query time 0.00154
JSON explain
{
"query_block": {
"select_id": 1,
"cost_info": {
"query_cost": "10.53"
},
"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.36",
"eval_cost": "0.10",
"prefix_cost": "1.23",
"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": 4,
"rows_produced_per_join": 4,
"filtered": "100.00",
"cost_info": {
"read_cost": "3.65",
"eval_cost": "0.40",
"prefix_cost": "5.27",
"data_read_per_join": "6K"
},
"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": "PRIMARY",
"used_key_parts": [
"feature_id",
"product_id"
],
"key_length": "6",
"ref": [
"const",
"const"
],
"rows_examined_per_scan": 1,
"rows_produced_per_join": 4,
"filtered": "100.00",
"using_index": true,
"cost_info": {
"read_cost": "2.70",
"eval_cost": "0.40",
"prefix_cost": "8.38",
"data_read_per_join": "160"
},
"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": 4,
"filtered": "100.00",
"cost_info": {
"read_cost": "1.72",
"eval_cost": "0.42",
"prefix_cost": "10.53",
"data_read_per_join": "31K"
},
"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 |
| 8045 |
8906121640700 |
A |
13 |
750.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.75 |
Fab 5-in-1 Nude Lipstick - 7.5gm |
Intense colour with Moisturising properties |
<p>FABULOUS EVERYDAY Wondering how to add some fun to your monotonous routines? Dont worry, weve got you! Renée is all about providing trouble-free solutions and with our 5-in-1 FAB 5 Nude lipstick, you can go from the focused boss lady in the day to the sexy enchantress by night, effortlessly. It uses the buttery soft, easy-glide formula which allows you to smoothly take up different roles, whenever you have to. From mystical mauve to pretty peach, it brings together five everyday essential shades. It makes sure you dont have to make difficult choices for everyday beauty. Whether its a last-minute meeting, a romantic date night or a spontaneous road trip with your buddies, theres nothing our FAB 5 Nude cannot fix! Well, whod say no to this pack of convenience for beautifully nourished lips? <span style="background-color:transparent;">Our FAB 5 Nude proves to be a promising addition to your makeup collection because it contains every shade that you might need throughout the day. It has got you covered for your morning work calls, evening tea-breaks and dreamy date nights. It is enriched with Jojoba Oil that gives your lips the freshness they need. Its not just your ordinary lipstick, its lip-stick by you through thick and thin!</span></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.7500 |
Lips |
2731 |
2734 |
24112 |
Renee Cosmetics |
540.000000 |