Query time 0.00137
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": "ref",
"possible_keys": ["PRIMARY", "product_id"],
"key": "product_id",
"key_length": "3",
"used_key_parts": ["product_id"],
"ref": ["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 |
| 342 |
TINHYEU04 |
P |
A |
3 |
396000.00 |
100 |
0.000 |
0 |
0 |
0 |
0.00 |
0 |
1782534937 |
1784353448 |
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 Love Box 4 |
|
<p>Love Box 4 K Coffee 709g (bộ) – bộ quà K Happy, K Life & Filter 3in1 hòa tan sữa. Quà tặng cà phê ý nghĩa. Chính hãng K Coffee.</p> |
<p><span style="font-size: 40px; font-weight: 700;">K COFFEE Love Box 4 – A Luxury Vietnamese Coffee Gift Set</span></p>
<p>A Thoughtful Gift for Coffee Lovers and Special Occasions</p>
<p>The K COFFEE Love Box 4 is a premium Vietnamese coffee gift set that brings together carefully selected coffee products in an elegant presentation. Designed to celebrate meaningful moments, this collection is an ideal choice for gifting family, friends, clients, business partners, or anyone who appreciates high-quality coffee.</p>
<p>Combining traditional Vietnamese coffee craftsmanship with modern brewing convenience, Love Box 4 offers a complete coffee experience that suits every lifestyle and occasion.</p>
<h2>What's Inside the K COFFEE Love Box 4?</h2>
<h3>Premium Roasted Ground Coffee</h3>
<p>Crafted from carefully selected Arabica and Robusta coffee beans, the roasted ground coffee delivers a rich body, balanced flavor, and a smooth finish. Expert roasting highlights the natural character of the beans while creating a satisfying cup suitable for daily enjoyment.</p>
<h3>K Filter Single-Serve Drip Coffee</h3>
<p>Enjoy freshly brewed coffee wherever you are with K Filter drip coffee. Each single-serve drip bag is easy to prepare and allows coffee lovers to enjoy premium coffee without additional brewing equipment.</p>
<h3>K Delight 3-in-1 Instant Coffee</h3>
<p>Perfect for busy mornings or afternoon breaks, K Delight combines premium coffee, milk, and sugar into a creamy, smooth beverage that can be prepared in just moments.</p>
<h3>Cascara Tea</h3>
<p>Made from the dried skins of carefully harvested Arabica coffee cherries, Cascara Tea provides a naturally refreshing beverage with subtle fruit notes and a clean finish. It adds another unique coffee-inspired experience to this premium gift collection.</p>
<h2>Why Choose the K COFFEE Love Box 4?</h2>
<h3>Four Premium Beverage Experiences</h3>
<p>Love Box 4 includes roasted ground coffee, drip coffee, instant coffee, and Cascara tea, allowing recipients to enjoy multiple brewing styles and discover different expressions of Vietnamese coffee.</p>
<h3>Carefully Selected Vietnamese Coffee</h3>
<p>Every coffee product is made from premium beans sourced from Vietnam's well-known coffee-growing regions. Strict production standards ensure reliable quality and consistency in every package.</p>
<h3>Elegant Gift Presentation</h3>
<p>The beautifully designed gift box creates a memorable unboxing experience, making it suitable for both personal celebrations and professional gifting.</p>
<p>Perfect for Every Occasion</p>
<h2>Love Box 4 is ideal for:</h2>
<ul><li>Corporate gifts</li><li>Client appreciation</li><li>Employee rewards</li><li>Holiday celebrations</li><li>Birthday gifts</li><li>Wedding gifts</li><li>Housewarming presents</li><li>Coffee lovers</li></ul>
<h2>Farm-to-Cup Quality Commitment</h2>
<p>K COFFEE follows a comprehensive Farm-to-Cup production process, carefully overseeing each stage from cultivation and harvesting to roasting, packaging, and distribution.</p>
<p>Manufactured under internationally recognized quality standards, every product reflects K COFFEE's commitment to consistency, quality, and authentic Vietnamese coffee.</p>
<h2>Product Information</h2>
<ul><li>Brand: K COFFEE</li><li>Country of Origin: Vietnam</li><li>Gift Box Includes</li><li>Premium Roasted Ground Coffee</li><li>K Filter Single-Serve Drip Coffee</li><li>K Delight 3-in-1 Instant Coffee</li><li>Cascara Tea</li><li>Coffee Bean Variety</li><li>Carefully selected Arabica and Robusta coffee beans</li><li>Shelf Life: 18 months (please refer to the product packaging for detailed information)</li></ul>
<h2>Brewing Instructions</h2>
<ul><li>Roasted Ground Coffee: Prepare using a Vietnamese phin filter, French press, pour-over brewer, or espresso machine according to your preferred brewing style.</li><li>Drip Coffee: Place the drip bag over your cup, slowly pour hot water (90–95°C), and allow the coffee to brew naturally.</li><li>Instant Coffee: Mix one sachet with approximately 150–180 ml of hot water, stir thoroughly, and serve immediately.</li><li>Cascara Tea: Steep in hot water (90–95°C) for 4–6 minutes before drinking.</li></ul>
<h2>Storage Instructions</h2>
<ul><li>Store in a cool, dry location.</li><li>Keep away from direct sunlight.</li><li>Reseal all packages after opening.</li><li>Avoid moisture and excessive heat.</li></ul>
<h2>Why Choose K COFFEE?</h2>
<ul><li>Premium Vietnamese Arabica and Robusta coffee</li><li>Farm-to-Cup quality assurance</li><li>Four premium beverage options in one elegant gift set</li><li>Convenient brewing methods for every lifestyle</li><li>Beautiful packaging for personal and corporate gifting</li><li>Produced under internationally recognized quality standards</li></ul>
<p></p> |
coffee gift set Love Box 4, K Coffee gift box 709g, K Happy ground coffee, K Life pure coffee, 3-in-1 instant milk coffee, premium coffee gift box, Vietnamese coffee gift set. |
K Coffee Love Box 4 Premium Coffee Gift Set (709g) | Pure Ground & 3-in-1 Instant Coffee Combo |
quà tặng cà phê, hộp quà cà phê tình yêu, set quà cà phê, quà tặng người yêu, quà tặng K Coffee |
K Coffee Love Box 4 Premium Coffee Gift Set (709g) | Pure Ground & 3-in-1 Instant Coffee Combo |
|
|
|
396000.00000000 |
318M |
2055 |
K COFFEE |
|
hop-qua-ca-phe-love-box-4-709g |
318 |
|
D |
|
|