Query time 0.00094
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 |
| 340 |
TINHYEU02 |
P |
A |
3 |
411000.00 |
100 |
0.000 |
0 |
0 |
0 |
0.00 |
0 |
1782533714 |
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 2 |
|
<p>Love Box 2 K Coffee 709g (bộ) – bộ quà K Black & K Morning cùng các dòng K Coffee. Quà tặng người thương ý nghĩa. Chính hãng K Coffee.</p> |
<p><span style="font-size: 40px; font-weight: 700;">K COFFEE Love Box 2 – A Premium Coffee Gift Set for Meaningful Moments</span></p>
<h2>Celebrate Every Occasion with an Elegant Vietnamese Coffee Collection</h2>
<p>The K COFFEE Love Box 2 is a thoughtfully curated premium coffee gift set designed to bring people together through exceptional Vietnamese coffee. Combining carefully selected coffee products and Cascara tea in one beautifully presented package, this collection offers a complete beverage experience suitable for every occasion.</p>
<p>Whether you're celebrating holidays, birthdays, anniversaries, or expressing appreciation to clients, colleagues, or loved ones, Love Box 2 is a sophisticated gift that reflects quality, craftsmanship, and genuine care.</p>
<h2>What's Inside the K COFFEE Love Box 2?</h2>
<h3>Premium Roasted Ground Coffee</h3>
<p>Made from high-quality Arabica and Robusta coffee beans, the roasted ground coffee delivers a rich body, balanced flavor, and a smooth finish. Expert roasting preserves the unique characteristics of Vietnamese coffee while creating a satisfying cup for everyday enjoyment.</p>
<h3>K Filter Single-Serve Drip Coffee</h3>
<p>Designed for convenience, K Filter allows coffee lovers to brew fresh coffee anytime without additional equipment. The portable drip bags are ideal for work, travel, or relaxing at home.</p>
<h3>K Delight 3-in-1 Instant Coffee</h3>
<p>A smooth combination of premium coffee, milk, and sugar creates a creamy and balanced beverage. Perfect for busy mornings or whenever you need a quick, enjoyable coffee break.</p>
<h3>Cascara Tea</h3>
<p>Made from the dried skins of carefully harvested Arabica coffee cherries, Cascara Tea offers a naturally refreshing beverage with delicate fruit notes and a clean finish. It provides a unique way to enjoy another part of the coffee plant while complementing the coffee selection in the gift box.</p>
<h2>Why Choose the K COFFEE Love Box 2?</h2>
<h3>Four Premium Beverages in One Elegant Gift</h3>
<p>Love Box 2 offers a complete tasting experience with roasted coffee, drip coffee, instant coffee, and Cascara tea, allowing recipients to enjoy different styles throughout the day.</p>
<h3>Premium Vietnamese Coffee</h3>
<p>Every product is crafted using carefully selected coffee beans sourced from Vietnam's renowned coffee-growing regions and processed under strict quality control to ensure consistent quality in every cup.</p>
<h3>Elegant Gift Packaging</h3>
<p>The sophisticated presentation makes Love Box 2 an ideal gift for both personal celebrations and professional occasions, creating a memorable impression before the first cup is brewed.</p>
<h2>Perfect for Every Occasion</h2>
<h2>The Love Box 2 is suitable for:</h2>
<ul><li>Corporate gifts</li><li>Client appreciation gifts</li><li>Holiday celebrations</li><li>Birthday gifts</li><li>Anniversary presents</li><li>Employee recognition</li><li>Housewarming gifts</li><li>Coffee enthusiasts</li></ul>
<h2>Farm-to-Cup Quality Assurance</h2>
<p>K COFFEE follows a comprehensive Farm-to-Cup production process, carefully managing every stage from coffee cultivation and harvesting to roasting, packaging, and final delivery.</p>
<p>Each product is manufactured according to internationally recognized food safety and quality standards, ensuring reliable quality and an authentic Vietnamese coffee experience.</p>
<h2>Product Information</h2>
<ul><li>Brand: K COFFEE</li><li>Country of Origin: Vietnam</li><li>Gift Box Includes<ul><li>Premium Roasted Ground Coffee</li></ul><ul><li>K Filter Single-Serve Drip Coffee</li></ul><ul><li>K Delight 3-in-1 Instant Coffee</li></ul><ul><li>Cascara Tea</li></ul></li><li>Coffee Bean Variety: Carefully selected Arabica and Robusta beans</li><li>Shelf Life: 18 months (refer to product packaging for specific details)</li></ul>
<h2>Brewing Instructions</h2>
<ul><li>Ground Coffee: Brew using a Vietnamese phin filter, French press, pour-over brewer, or espresso machine according to your preferred brewing method.</li><li>Drip Coffee: Open the drip bag, place it securely 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 150–180 ml of hot water, stir thoroughly, and enjoy.</li><li>Cascara Tea: Steep one serving in hot water (90–95°C) for 4–6 minutes before drinking. Adjust steeping time to suit your preferred taste.</li></ul>
<h2>Storage Instructions</h2>
<ul><li>Store in a cool, dry place.</li><li>Keep away from direct sunlight.</li><li>Reseal packages tightly 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 management</li><li>Multiple coffee styles in one premium gift box</li><li>Includes Cascara Tea for a unique beverage experience</li><li>Elegant packaging for personal and corporate gifting</li><li>Produced under international quality standards</li></ul>
<p></p> |
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 |
Love Box 2 K Coffee 709g (bộ) – bộ quà K Black & K Morning cùng các dòng K Coffee. Quà tặng người thương ý nghĩa. Chính hãng K Coffee. |
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 |
Hộp Quà Cà Phê K Coffee – Love Box 2 709g (bộ) | K Coffee |
|
|
|
411000.00000000 |
318M |
2071 |
K COFFEE |
|
hop-qua-ca-phe-love-box-2-709g |
318 |
|
D |
|
|