Query time 0.00205
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 |
| 356 |
|
P |
A |
3 |
105000.00 |
100 |
0.000 |
0 |
0 |
0 |
0.00 |
0 |
1784316051 |
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 K FILTER 105G |
|
|
<div><p><span style="font-size: 40px; font-weight: 700;">K FILTER 105G PAPER DRIP COFFEE – CONVENIENT 100% PURE COFFEE</span></p><p>K Filter Paper Drip Coffee – Quick and Convenient for Everyday Enjoyment</p><p>K Filter 105g Paper Drip Coffee is a convenient solution for those who enjoy pure roasted and ground coffee but lead busy lifestyles. The product combines the traditional Vietnamese drip coffee brewing method with a compact paper drip filter design, allowing you to easily brew a cup of coffee in approximately 30 seconds.</p><p>No need to prepare a traditional coffee filter or multiple brewing tools. K Filter Paper Drip Coffee is ideal for enjoying 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> & <strong>Robusta</strong> Coffee</p><p>K Filter 105g Paper Drip Coffee is made from <strong>100% pure</strong> <strong>Arabica</strong> & <strong>Robusta</strong> coffee. The product is manufactured through a closed <strong>From Farm to Cup</strong> process, aiming to ensure consistent quality from the coffee-growing regions to the finished product.</p><p><strong>K Coffee</strong>’s 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 Busy Lifestyles</p><p>With its compact design, K Filter Paper Drip Coffee is easy to carry in a handbag, backpack, or luggage. All you need is a cup and hot water to quickly brew coffee in a variety of settings.</p><p>The product 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 roasted and ground coffee</p><p>Outdoor activities and camping</p><p>How to Brew K 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: K Filter 105g Paper Drip Coffee</p><p>Product type: Paper Drip Coffee</p><h2>Ingredients: 100% pure Arabica & Robusta coffee</h2><ul> <li>Brand: <strong>K Coffee</strong></li> <li>Origin: Vietnam</li> <li>Packaging: Box of 7 sachets x 15g</li></ul><p>How to use: Brew directly with hot water</p><ul> <li>K Filter 105g Paper Drip Coffee is an ideal choice for those who love pure coffee and need a quick and simple brewing solution. With its compact design and convenient brewing method, the product allows you to easily enjoy quality coffee at home, in the office, or wherever your journey takes you.</li></ul><p></p></div> |
K Filter Paper Drip Coffee, 105g Paper Drip Coffee, K Filter 105g Coffee, 100% Pure Coffee, Arabica & Robusta Coffee, Pure Roasted & Ground Coffee, Convenient Paper Drip Coffee, Quick-Brew Coffee, Convenient Office Coffee, and Travel-Friendly Coffee. |
K Filter 105g Paper Drip Coffee is made from 100% pure Arabica and Robusta coffee. Brew a delicious cup in just 30 seconds – convenient for the office, travel, and busy lifestyles. |
|
K COFFEE K FILTER 105G | K Coffee |
|
|
|
105000.00000000 |
314M |
27 |
K COFFEE |
|
ca-phe-phin-giay-k-filter-105-g |
314 |
|
D |
|
|