Query time 0.00170
JSON explain
{
"query_block": {
"select_id": 1,
"cost_info": {
"query_cost": "39.73"
},
"grouping_operation": {
"using_filesort": false,
"nested_loop": [
{
"table": {
"table_name": "cscart_master_products_storefront_min_price",
"access_type": "system",
"possible_keys": [
"PRIMARY"
],
"rows_examined_per_scan": 0,
"rows_produced_per_join": 1,
"filtered": "0.00",
"const_row_not_found": true,
"cost_info": {
"read_cost": "0.00",
"eval_cost": "0.10",
"prefix_cost": "0.00",
"data_read_per_join": "16"
},
"used_columns": [
"storefront_id",
"product_id",
"price"
]
}
},
{
"table": {
"table_name": "cscart_products",
"access_type": "const",
"possible_keys": [
"PRIMARY",
"status",
"idx_products_status_company",
"idx_products_inventory",
"idx_products_status_company_master",
"idx_products_main_query",
"idx_products_composite_query"
],
"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",
"kl_erp_inventory_id",
"product_code",
"hsn_code",
"product_type",
"status",
"company_id",
"list_price",
"amount",
"kl_enable_qc",
"kl_qc_amount",
"weight",
"length",
"width",
"height",
"shipping_freight",
"low_avail_limit",
"timestamp",
"updated_timestamp",
"usergroup_ids",
"is_edp",
"edp_shipping",
"unlimited_download",
"tracking",
"free_shipping",
"zero_price_action",
"is_pbp",
"is_op",
"is_oper",
"is_returnable",
"return_period",
"avail_since",
"out_of_stock_actions",
"localization",
"min_qty",
"max_qty",
"qty_step",
"list_qty_count",
"tax_ids",
"age_verification",
"age_limit",
"options_type",
"exceptions_type",
"details_layout",
"shipping_params",
"facebook_obj_type",
"parent_product_id",
"buy_now_url",
"is_stock_split_by_warehouses",
"master_product_id",
"master_product_status",
"master_product_offers_count",
"youtube_link",
"show_youtube_video",
"replace_main_image",
"position_youtube",
"restrict_cod",
"seo_content"
]
}
},
{
"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",
"shortname",
"short_description",
"full_description",
"meta_keywords",
"meta_description",
"search_words",
"page_title",
"age_warning_message",
"promo_text",
"how_to_use",
"key_product_info",
"auto_update_inventory"
]
}
},
{
"table": {
"table_name": "companies",
"access_type": "const",
"possible_keys": [
"PRIMARY"
],
"key": "PRIMARY",
"used_key_parts": [
"company_id"
],
"key_length": "4",
"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": "6K"
},
"used_columns": [
"company_id",
"status",
"company"
]
}
},
{
"table": {
"table_name": "popularity",
"access_type": "const",
"possible_keys": [
"PRIMARY",
"total"
],
"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": "32"
},
"used_columns": [
"product_id",
"total"
]
}
},
{
"table": {
"table_name": "cscart_product_sales",
"access_type": "const",
"possible_keys": [
"PRIMARY",
"pa",
"idx_product_sales_category_amount"
],
"key": "PRIMARY",
"used_key_parts": [
"category_id",
"product_id"
],
"key_length": "6",
"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": "16"
},
"used_columns": [
"category_id",
"product_id",
"amount"
]
}
},
{
"table": {
"table_name": "cscart_products_categories",
"access_type": "ref",
"possible_keys": [
"PRIMARY",
"pt",
"idx_product_category_lookup",
"idx_products_categories_composite"
],
"key": "pt",
"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": "2.32",
"eval_cost": "0.30",
"prefix_cost": "2.62",
"data_read_per_join": "48"
},
"used_columns": [
"product_id",
"category_id",
"link_type",
"category_position"
]
}
},
{
"table": {
"table_name": "cscart_categories",
"access_type": "eq_ref",
"possible_keys": [
"PRIMARY",
"p_category_id",
"idx_categories_storefront_status",
"idx_categories_usergroup_status",
"idx_categories_status_id_path"
],
"key": "PRIMARY",
"used_key_parts": [
"category_id"
],
"key_length": "3",
"ref": [
"cscart_db.cscart_products_categories.category_id"
],
"rows_examined_per_scan": 1,
"rows_produced_per_join": 2,
"filtered": "81.96",
"cost_info": {
"read_cost": "0.00",
"eval_cost": "0.25",
"prefix_cost": "2.92",
"data_read_per_join": "6K"
},
"used_columns": [
"category_id",
"status",
"storefront_id"
],
"attached_condition": "((`cscart_db`.`cscart_categories`.`storefront_id` in (0,1)) and (`cscart_db`.`cscart_categories`.`status` in ('A','H')))"
}
},
{
"table": {
"table_name": "cscart_seo_names",
"access_type": "ref",
"possible_keys": [
"PRIMARY",
"dispatch"
],
"key": "PRIMARY",
"used_key_parts": [
"object_id",
"type",
"dispatch",
"lang_code"
],
"key_length": "206",
"ref": [
"const",
"const",
"const",
"const"
],
"rows_examined_per_scan": 1,
"rows_produced_per_join": 2,
"filtered": "100.00",
"cost_info": {
"read_cost": "0.61",
"eval_cost": "0.25",
"prefix_cost": "3.78",
"data_read_per_join": "4K"
},
"used_columns": [
"name",
"object_id",
"type",
"dispatch",
"path",
"lang_code"
]
}
},
{
"table": {
"table_name": "point_prices",
"access_type": "range",
"possible_keys": [
"unique_key",
"src_k"
],
"key": "unique_key",
"used_key_parts": [
"lower_limit",
"usergroup_id",
"product_id"
],
"key_length": "8",
"rows_examined_per_scan": 2,
"rows_produced_per_join": 4,
"filtered": "100.00",
"index_condition": "<if>(is_not_null_compl(point_prices), ((`cscart_db`.`point_prices`.`lower_limit` = 1) and (`cscart_db`.`point_prices`.`product_id` = 32163) and (`cscart_db`.`point_prices`.`usergroup_id` in (0,0,1))), true)",
"using_join_buffer": "hash join",
"cost_info": {
"read_cost": "8.65",
"eval_cost": "0.49",
"prefix_cost": "12.92",
"data_read_per_join": "118"
},
"used_columns": [
"product_id",
"point_price",
"lower_limit",
"usergroup_id"
],
"attached_condition": "<if>(found_match(point_prices), true, true)"
}
},
{
"table": {
"table_name": "cscart_product_points_and_cash",
"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": 4,
"filtered": "100.00",
"cost_info": {
"read_cost": "0.00",
"eval_cost": "0.49",
"prefix_cost": "13.41",
"data_read_per_join": "78"
},
"used_columns": [
"product_id",
"percentage_of_total_points"
]
}
},
{
"table": {
"table_name": "cscart_discussion",
"access_type": "const",
"possible_keys": [
"object_id"
],
"key": "object_id",
"used_key_parts": [
"object_id",
"object_type"
],
"key_length": "6",
"ref": [
"const",
"const"
],
"rows_examined_per_scan": 1,
"rows_produced_per_join": 4,
"filtered": "100.00",
"cost_info": {
"read_cost": "0.00",
"eval_cost": "0.49",
"prefix_cost": "13.90",
"data_read_per_join": "118"
},
"used_columns": [
"object_id",
"object_type",
"type"
]
}
},
{
"table": {
"table_name": "cscart_product_review_prepared_data",
"access_type": "const",
"possible_keys": [
"PRIMARY"
],
"key": "PRIMARY",
"used_key_parts": [
"product_id",
"storefront_id"
],
"key_length": "7",
"ref": [
"const",
"const"
],
"rows_examined_per_scan": 1,
"rows_produced_per_join": 4,
"filtered": "100.00",
"cost_info": {
"read_cost": "0.00",
"eval_cost": "0.49",
"prefix_cost": "14.39",
"data_read_per_join": "78"
},
"used_columns": [
"product_id",
"storefront_id",
"average_rating",
"reviews_count"
]
}
},
{
"table": {
"table_name": "cscart_kl_product_margin",
"access_type": "ref",
"possible_keys": [
"brand_id_composite",
"product_id"
],
"key": "brand_id_composite",
"used_key_parts": [
"product_id"
],
"key_length": "3",
"ref": [
"const"
],
"rows_examined_per_scan": 5,
"rows_produced_per_join": 24,
"filtered": "100.00",
"cost_info": {
"read_cost": "22.88",
"eval_cost": "2.46",
"prefix_cost": "39.73",
"data_read_per_join": "7K"
},
"used_columns": [
"id",
"product_id",
"base_margin",
"recurring_margin",
"effective_timestamp"
]
}
}
]
}
}
}
Result
| product_id |
kl_erp_inventory_id |
product_code |
hsn_code |
product_type |
status |
company_id |
list_price |
amount |
kl_enable_qc |
kl_qc_amount |
weight |
length |
width |
height |
shipping_freight |
low_avail_limit |
timestamp |
updated_timestamp |
usergroup_ids |
is_edp |
edp_shipping |
unlimited_download |
tracking |
free_shipping |
zero_price_action |
is_pbp |
is_op |
is_oper |
is_returnable |
return_period |
avail_since |
out_of_stock_actions |
localization |
min_qty |
max_qty |
qty_step |
list_qty_count |
tax_ids |
age_verification |
age_limit |
options_type |
exceptions_type |
details_layout |
shipping_params |
facebook_obj_type |
parent_product_id |
buy_now_url |
is_stock_split_by_warehouses |
master_product_id |
master_product_status |
master_product_offers_count |
youtube_link |
show_youtube_video |
replace_main_image |
position_youtube |
restrict_cod |
seo_content |
lang_code |
product |
shortname |
short_description |
full_description |
meta_keywords |
meta_description |
search_words |
page_title |
age_warning_message |
promo_text |
how_to_use |
key_product_info |
auto_update_inventory |
price |
category_ids |
popularity |
company_name |
sales_amount |
seo_name |
seo_path |
point_price |
percentage_of_total_points |
discussion_type |
average_rating |
product_reviews_count |
base_margin |
margin_id |
recurring_margin |
effective_timestamp |
| 32163 |
|
8809634610058 |
3304 |
P |
A |
13 |
700.00 |
208 |
0 |
0 |
0.000 |
0 |
0 |
0 |
0.00 |
0 |
1690308644 |
1772692240 |
0 |
N |
N |
N |
B |
N |
R |
Y |
N |
N |
Y |
10 |
0 |
S |
|
0 |
5 |
0 |
0 |
13 |
N |
0 |
P |
F |
default |
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;} |
|
0 |
|
N |
0 |
A |
0 |
|
Y |
|
|
N |
|
en |
The Mini Glow Set |
|
<p>Mini collection for glowing skin</p> |
<p>Quinoa One-Step balanced Gel Cleanser: A loving cleanser that clears makeup and pores in one step while delivering a gentle and hydrating wash at your skin’s natural pH. With a pH of 5.5, their Quinoa One-Step Gel Cleanser maintains the skin’s healthy pH level while effectively removing makeup, excess sebum, and the day’s build up in one wash without stripping the skin so you can have a refreshing and clarifying start to your routine. Daily Purifying Treatment Toner: Their daily toner effectively clears out bacteria and pollution stuck deep in the pores to purify the skin and reduce irritation and acne. The new and improved formula now includes a higher amount of AHA and PHA for gentle chemical exfoliation as well as a higher amount of Centella Asiatica for an increased soothing effect. <br />Artichoke Intensive Skin Barrier Ampoule: With the core ingredient of artichoke, this ampoule is specially formulated to repair and strengthen the skin’s natural barrier and prevent skin irritation. The new and improved formula now features double the amount of Hawkweed extract for more antioxidants and anti-inflammatory properties for a brighter and smoother complexion.<br />Dark Spot Correcting Glow Serum: A Niacinamide based serum that corrects dark spots and improves uneven skin tone. With the help of plant-derived Squalane, this serum retains moisture to keep your skin glowing and healthy wherever you go. Reduces pigmentation concerns including dark spots and uneven skin tone. Smoothes, brightens & deeply moisturizes skin.</p>
<p>Note: The order will be dispatched within 7 days.</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> |
<p>Dark Spot Correcting Glow Serum: Apply a small amount to entrie face or problem areas.<br>Quinoa One-Step Balanced Gel Cleanser: Apply two to three pumps onto wet face. Massage across face, especially in debris and oil prone areas. Rinse thoroughly with lukewarm water.<br>Artichoke Intensive Skin Barrier Ampoule: Apply directly onto skin after cleansing and toning. Gently pat across the face until completely absorbed.<br>Daily Purifying Treatment Toner: Apply to cotton pad after cleansing. Gently wipe the cotton pad soaked in toner over face while avoiding the area close to your eyes and areas with irritation.</p> |
|
1 |
455.000000 |
2834M,2834M,2834M,2834M,2834M,2828,2828,2828,2828,2828,2331,2331,2331,2331,2331 |
258550 |
Roadskye Tradecom Pvt. Ltd. |
709 |
the-mini-glow-set |
2685/2834 |
|
|
D |
4.57 |
21 |
0.2700 |
65514 |
0.0000 |
2024-06-01 |