Query time 0.00167
JSON explain
{
"query_block": {
"select_id": 1,
"cost_info": {
"query_cost": "23.66"
},
"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": 2,
"rows_produced_per_join": 2,
"filtered": "100.00",
"cost_info": {
"read_cost": "1.50",
"eval_cost": "0.20",
"prefix_cost": "1.70",
"data_read_per_join": "32"
},
"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": 1,
"filtered": "81.96",
"cost_info": {
"read_cost": "0.00",
"eval_cost": "0.16",
"prefix_cost": "1.90",
"data_read_per_join": "4K"
},
"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": 1,
"filtered": "100.00",
"cost_info": {
"read_cost": "0.41",
"eval_cost": "0.16",
"prefix_cost": "2.48",
"data_read_per_join": "2K"
},
"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": 3,
"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` = 66500) and (`cscart_db`.`point_prices`.`usergroup_id` in (0,0,1))), true)",
"using_join_buffer": "hash join",
"cost_info": {
"read_cost": "6.52",
"eval_cost": "0.33",
"prefix_cost": "9.33",
"data_read_per_join": "78"
},
"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": 3,
"filtered": "100.00",
"cost_info": {
"read_cost": "0.00",
"eval_cost": "0.33",
"prefix_cost": "9.66",
"data_read_per_join": "52"
},
"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": 3,
"filtered": "100.00",
"cost_info": {
"read_cost": "0.00",
"eval_cost": "0.33",
"prefix_cost": "9.98",
"data_read_per_join": "78"
},
"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": 3,
"filtered": "100.00",
"cost_info": {
"read_cost": "0.00",
"eval_cost": "0.33",
"prefix_cost": "10.31",
"data_read_per_join": "52"
},
"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": 4,
"rows_produced_per_join": 13,
"filtered": "100.00",
"cost_info": {
"read_cost": "12.03",
"eval_cost": "1.31",
"prefix_cost": "23.66",
"data_read_per_join": "4K"
},
"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 |
| 66500 |
|
8803463007317 |
3304 |
P |
A |
13 |
1249.00 |
8 |
0 |
0 |
0.000 |
0 |
0 |
0 |
0.00 |
0 |
1745564535 |
1772692240 |
0 |
N |
N |
N |
B |
N |
R |
Y |
N |
N |
Y |
10 |
0 |
N |
|
0 |
0 |
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 |
Collagen Reedle Shot 100 Stick 2ml (10ea) |
|
Firms skin, boosts collagen, and smoothens texture. |
<p>Experience a rejuvenated complexion with the VT Cosmetics Collagen Reedle Shot 100. This innovative skincare treatment combines ultra-low molecular collagen with VT's proprietary Reedle technology, delivering deep hydration and enhanced elasticity. The unique silica-based CICA REEDLE gently stimulates the skin, promoting optimal absorption of active ingredients. Enriched with Centella Asiatica Extract, Triple Hyaluronic Acid, and Green Propolis Extract, it soothes and nourishes the skin, improving texture and tone. Designed for all skin types, this 2ml stick is perfect for targeted treatment of sagging or dehydrated areas. Ideal for those seeking a firming solution without the commitment of a full-sized product, the Collagen Reedle Shot 100 offers a convenient and effective addition to your skincare routine.</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> |
To revitalize your skin with this ampoule, start by cleansing your face with a gentle face wash and patting it dry. Dispense a few drops onto your fingertips and gently massage into your face and neck using upward motions. Finish by pressing your palms gently against your skin for a few seconds to aid absorption. Use morning and night, followed by your regular moisturizer, to enhance skin hydration and glow, perfect for a busy Indian lifestyle. |
|
1 |
874.300000 |
2831M,2831M,2831M,2831M,2331,2331,2331,2331 |
27100 |
Roadskye Tradecom Pvt. Ltd. |
59 |
collagen-reedle-shot-100-stick-2ml-10ea |
2685/2827/2831 |
|
|
D |
4.00 |
1 |
0.4000 |
113561 |
0.0000 |
2025-05-01 |