Query time 0.00109
JSON explain
{
"query_block": {
"select_id": 1,
"nested_loop": [
{
"table": {
"table_name": "point_prices",
"access_type": "system",
"possible_keys": ["unique_key", "src_k"],
"rows": 0,
"filtered": 0,
"const_row_not_found": true
}
},
{
"table": {
"table_name": "cscart_products",
"access_type": "const",
"possible_keys": ["PRIMARY", "status"],
"key": "PRIMARY",
"key_length": "3",
"used_key_parts": ["product_id"],
"ref": ["const"],
"rows": 1,
"filtered": 100
}
},
{
"table": {
"table_name": "popularity",
"access_type": "const",
"possible_keys": ["PRIMARY", "total"],
"key": "PRIMARY",
"key_length": "3",
"used_key_parts": ["product_id"],
"ref": ["const"],
"rows": 1,
"filtered": 100
}
},
{
"table": {
"table_name": "cscart_product_sales",
"access_type": "const",
"possible_keys": ["PRIMARY", "pa"],
"key": "PRIMARY",
"key_length": "6",
"used_key_parts": ["category_id", "product_id"],
"ref": ["const", "const"],
"rows": 0,
"filtered": 0,
"unique_row_not_found": true
}
},
{
"table": {
"table_name": "cscart_discussion",
"access_type": "const",
"possible_keys": ["object_id"],
"key": "object_id",
"key_length": "6",
"used_key_parts": ["object_id", "object_type"],
"ref": ["const", "const"],
"rows": 1,
"filtered": 100
}
},
{
"table": {
"table_name": "cscart_product_review_prepared_data",
"access_type": "const",
"possible_keys": ["PRIMARY"],
"key": "PRIMARY",
"key_length": "7",
"used_key_parts": ["product_id", "storefront_id"],
"ref": ["const", "const"],
"rows": 0,
"filtered": 0,
"unique_row_not_found": true
}
},
{
"table": {
"table_name": "cscart_product_prices",
"access_type": "ref",
"possible_keys": [
"usergroup",
"product_id",
"lower_limit",
"usergroup_id"
],
"key": "product_id",
"key_length": "3",
"used_key_parts": ["product_id"],
"ref": ["const"],
"rows": 1,
"filtered": 100,
"attached_condition": "trigcond(cscart_product_prices.lower_limit = 1 and cscart_product_prices.usergroup_id in (0,0,1))"
}
},
{
"table": {
"table_name": "cscart_product_descriptions",
"access_type": "const",
"possible_keys": ["PRIMARY", "product_id"],
"key": "PRIMARY",
"key_length": "9",
"used_key_parts": ["product_id", "lang_code"],
"ref": ["const", "const"],
"rows": 1,
"filtered": 100,
"attached_condition": "trigcond(cscart_product_descriptions.lang_code = 'en')"
}
},
{
"table": {
"table_name": "company_descr",
"access_type": "eq_ref",
"possible_keys": ["PRIMARY"],
"key": "PRIMARY",
"key_length": "10",
"used_key_parts": ["company_id", "lang_code"],
"ref": ["const", "const"],
"rows": 1,
"filtered": 100,
"attached_condition": "trigcond(company_descr.lang_code = 'en')"
}
},
{
"table": {
"table_name": "companies",
"access_type": "eq_ref",
"possible_keys": ["PRIMARY"],
"key": "PRIMARY",
"key_length": "4",
"used_key_parts": ["company_id"],
"ref": ["const"],
"rows": 1,
"filtered": 100,
"attached_condition": "trigcond(companies.`status` = 'A')"
}
},
{
"table": {
"table_name": "cscart_products_categories",
"access_type": "ref",
"possible_keys": ["PRIMARY", "pt"],
"key": "pt",
"key_length": "3",
"used_key_parts": ["product_id"],
"ref": ["const"],
"rows": 1,
"filtered": 100
}
},
{
"table": {
"table_name": "cscart_categories",
"access_type": "eq_ref",
"possible_keys": ["PRIMARY", "c_status", "p_category_id"],
"key": "PRIMARY",
"key_length": "3",
"used_key_parts": ["category_id"],
"ref": ["demov2026.cscart_products_categories.category_id"],
"rows": 1,
"filtered": 100,
"attached_condition": "cscart_categories.storefront_id in (0,1) and (cscart_categories.usergroup_ids = '' or find_in_set(0,cscart_categories.usergroup_ids) or find_in_set(1,cscart_categories.usergroup_ids)) and cscart_categories.`status` in ('A','H')"
}
},
{
"table": {
"table_name": "cscart_seo_names",
"access_type": "ref",
"possible_keys": ["PRIMARY", "dispatch"],
"key": "PRIMARY",
"key_length": "206",
"used_key_parts": ["object_id", "type", "dispatch", "lang_code"],
"ref": ["const", "const", "const", "const"],
"rows": 1,
"filtered": 100,
"attached_condition": "trigcond(cscart_seo_names.`type` = 'p' and cscart_seo_names.dispatch = '' and cscart_seo_names.lang_code = 'vn')"
}
}
]
}
}
Result
| product_id |
product_code |
product_type |
status |
company_id |
list_price |
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 |
show_videos_before_images |
autoplay_videos |
facebook_obj_type |
parent_product_id |
buy_now_url |
units_in_product |
show_price_per_x_units |
ab__stickers_manual_ids |
ab__stickers_generated_ids |
lang_code |
product |
shortname |
short_description |
full_description |
meta_keywords |
meta_description |
search_words |
page_title |
age_warning_message |
promo_text |
unit_name |
price |
category_ids |
popularity |
company_name |
sales_amount |
seo_name |
seo_path |
point_price |
discussion_type |
average_rating |
product_reviews_count |
| 355 |
KFBSL450 |
P |
A |
3 |
576000.00 |
100 |
0.000 |
0 |
0 |
0 |
0.00 |
0 |
1784315866 |
1784353449 |
0 |
N |
N |
N |
|
N |
|
Y |
N |
N |
Y |
10 |
0 |
N |
|
|
|
|
|
|
N |
0 |
|
|
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;} |
N |
N |
activity |
0 |
|
0.000 |
0.000 |
|
|
en |
K COFFEE FILTER BLUE SON LA 450 |
|
|
<div><p><span style="font-size: 40px; font-weight: 700;">K COFFEE FILTER BLUE SON LA 450G PAPER DRIP COFFEE – 100% PURE ARABICA COFFEE</span></p><p><strong>Blue Son La</strong> Paper Drip Coffee – Convenient, Quick, and Pure</p><p><strong>K Coffee</strong> Filter <strong>Blue Son La</strong> 450g Paper Drip Coffee is a convenient choice for those who love pure <strong>Arabica</strong> coffee and want to enjoy a quality cup of coffee quickly in a modern lifestyle.</p><p>The product combines the traditional Vietnamese drip coffee brewing method with the convenience of a paper drip filter. In just approximately 30 seconds, you can easily brew a cup of coffee without preparing a traditional coffee filter or multiple brewing tools.</p><p>With 30 sachets x 15g, <strong>K Coffee</strong> Filter <strong>Blue Son La</strong> 450g is ideal for everyday use at home or in the office, as well as taking with you when traveling, going on business trips, or commuting regularly.</p><p><strong>100% Pure</strong> <strong>Arabica</strong> Coffee from Son La</p><p><strong>K Coffee</strong> Filter <strong>Blue Son La</strong> is made from <strong>100% pure</strong> <strong>Arabica</strong> coffee, offering a coffee experience with mild bitterness, distinctive sweetness, and a full-bodied finish characteristic of <strong>Arabica</strong> coffee.</p><p>The product is manufactured through a closed <strong>From Farm to Cup</strong> process, helping maintain quality control from the coffee-growing region to the finished product. <strong>K Coffee</strong> is committed to delivering consistent quality and a pure coffee experience in every paper drip coffee sachet.</p><p><strong>K Coffee</strong>’s 3 NO Commitments</p><p>No chemical coloring</p><p>No harmful odors</p><p>No corn or soybean blending</p><p>Convenient Paper Drip Coffee for Every Journey</p><p>With its compact design, each paper drip coffee sachet is easy to carry in a handbag, backpack, or luggage. All you need is a cup and hot water to quickly brew coffee at home, in the office, or while traveling.</p><p><strong>K Coffee</strong> Filter <strong>Blue Son La</strong> 450g is suitable for:</p><p>Busy individuals who need to brew coffee quickly</p><p>Office workers</p><p>Frequent business and leisure travelers</p><p>Lovers of pure <strong>Arabica</strong> coffee</p><p>Families who enjoy coffee every day</p><p>Outdoor activities and camping</p><p>How to Brew <strong>K Coffee</strong> Filter Paper Drip Coffee</p><p>Step 1: Tear along the pre-cut line on the coffee sachet.</p><p>Step 2: Open the two side hooks of the filter bag and place them over the rim of the cup.</p><p>Step 3: Pour approximately 20 ml of boiling water over the coffee and allow it to bloom evenly.</p><p>Step 4: Add another approximately 20 ml of boiling water, then slowly pour in approximately 80 ml more water.</p><p>Step 5: Add sugar, milk, or ice according to your preference.</p><h2>Product Information</h2><p>Product name: <strong>K Coffee</strong> Filter <strong>Blue Son La</strong> 450g</p><p>Product type: Paper Drip Coffee</p><h2>Ingredients: 100% pure Arabica coffee</h2><ul> <li>Brand: <strong>K Coffee</strong></li> <li>Origin: Vietnam</li> <li>Packaging: 30 sachets x 15g</li> <li>Shelf life: 18 months from the date of manufacture</li></ul><p>How to use: Brew directly with hot water</p><ul> <li><strong>K Coffee</strong> Filter <strong>Blue Son La</strong> 450g Paper Drip Coffee is an ideal solution for those who love pure <strong>Arabica</strong> coffee and need a quick and simple brewing method. With 30 convenient sachets, the product is suitable for everyday use at home, in the office, or for taking with you wherever your journey takes you.</li></ul><p></p></div> |
K Coffee Filter Blue Son La Paper Drip Coffee, K Coffee Filter Blue Son La 450g, K Coffee Paper Drip Coffee, Pure Arabica Coffee, Son La Arabica Coffee, Convenient Paper Drip Coffee, Quick-Brew Coffee, 100% Pure Coffee, Son La Specialty Coffee, Specialty |
K Coffee Filter Blue Son La 450g Paper Drip Coffee is made from 100% pure Arabica coffee. Brew a cup in just 30 seconds—convenient for home, the office, travel, and business trips. |
|
K COFFEE FILTER BLUE SON LA 450 | K Coffee |
|
|
|
576000.00000000 |
314M |
33 |
K COFFEE |
|
ca-phe-k-coffee-filter-blue-son-la-450 |
314 |
|
D |
|
|