Query time 0.00188
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 |
| 366 |
PEPB000125 |
P |
A |
3 |
82000.00 |
100 |
0.000 |
0 |
0 |
0 |
0.00 |
0 |
1784319968 |
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 Pepper Black Pepper 125g |
|
|
<div><p><span style="font-size: 40px; font-weight: 700;">K PEPPER BLACK PEPPER 125G – 100% PURE VIETNAMESE BLACK PEPPER</span></p><p>Premium Black Pepper for Everyday Cooking</p><p><strong>K Pepper</strong> Black Pepper 125g is crafted from <strong>100% pure</strong> Vietnamese black pepper, carefully selected from premium pepper-growing regions renowned for producing some of the world's finest peppercorns. Harvested at peak maturity and processed under strict quality standards, this premium seasoning delivers bold flavor, balanced heat, and exceptional freshness to every meal.</p><p>Whether you're preparing home-cooked dishes or professional recipes, <strong>K Pepper</strong> Black Pepper is a versatile ingredient that enhances the natural taste of your favorite foods.</p><p>Made from Carefully Selected Vietnamese Pepper</p><p>Vietnam is one of the world's leading producers of premium black pepper, recognized for its superior quality and consistent flavor. <strong>K Pepper</strong> sources only high-quality peppercorns from trusted farms and carefully processes them to preserve their natural essential oils and distinctive taste.</p><p>Every batch undergoes strict quality control to ensure purity, freshness, and consistent performance in every package.</p><h2>Why Choose K Pepper Black Pepper 125g?</h2><p><strong>100% Pure</strong> Black Pepper</p><p>Made entirely from premium black pepper with no fillers or artificial additives, allowing you to enjoy authentic pepper flavor in every meal.</p><p>Rich, Balanced Flavor</p><p><strong>K Pepper</strong> Black Pepper delivers a bold yet well-balanced taste that complements a wide variety of ingredients without overpowering the natural character of your dishes.</p><p>Versatile for Every Kitchen</p><p>Suitable for everyday family meals as well as gourmet cooking, this premium seasoning is a must-have ingredient for home cooks and professional chefs.</p><p>Perfect for a Wide Range of Recipes</p><p><strong>K Pepper</strong> Black Pepper enhances countless dishes, including:</p><p>Meat Dishes</p><p>Perfect for beef, pork, chicken, lamb, duck, and grilled meats, adding depth and richness to every bite.</p><p>Seafood</p><p>Pairs beautifully with shrimp, salmon, tuna, scallops, squid, and other seafood dishes.</p><p>Vegetables</p><p>Season roasted vegetables, stir-fries, mashed potatoes, and fresh salads for extra flavor and complexity.</p><p>Soups and Sauces</p><p>Enhance soups, broths, gravies, cream sauces, and marinades with balanced pepper seasoning.</p><p>International and Asian Cuisine</p><p>An excellent seasoning for pasta, pizza, sandwiches, noodles, fried rice, and a variety of global recipes.</p><p>Product Features</p><p>Made from <strong>100% pure</strong> Vietnamese black pepper</p><p>Carefully selected premium peppercorns</p><p>Naturally rich flavor with balanced heat</p><p><strong>No artificial colors</strong></p><p>No artificial preservatives</p><p>No fillers or additives</p><p>Convenient 125g package</p><p>Suitable for everyday cooking and gourmet recipes</p><h2>Product Information</h2><p>Brand: <strong>K Pepper</strong></p><p>Product Name: Black Pepper</p><p>Net Weight: 125 g</p><p>Origin: Vietnam</p><h2>Ingredients: 100% Pure Black Pepper</h2><ul> <li>How to Use</li></ul><ul> <li>Use <strong>K Pepper</strong> Black Pepper to season food during cooking or after serving.</li> <li>Recommended for:</li> <li>Steaks</li> <li>Grilled meats</li> <li>Chicken</li> <li>Seafood</li> <li>Eggs</li> <li>Soups</li> <li>Pasta</li> <li>Pizza</li> <li>Salads</li> <li>Vegetables</li> <li>Marinades</li> <li>Stir-fried dishes</li> <li>Adjust the amount according to your personal taste.</li></ul><ul> <li>Storage Instructions</li> <li>Store in a cool, dry place.</li> <li>Keep the package tightly sealed after opening.</li> <li>Avoid direct sunlight.</li> <li>Protect from moisture to preserve freshness and quality.</li></ul><h2>Why Choose K Pepper?</h2><p>Premium Vietnamese black pepper sourced from trusted farms</p><p>Made from <strong>100% pure</strong> pepper with no fillers</p><p>Carefully processed to maintain quality and freshness</p><p>Versatile seasoning for a wide variety of cuisines</p><p>Suitable for home kitchens and professional chefs</p><p>Produced under strict food safety and quality standards</p><p></p></div> |
K Pepper Black Pepper 125g, black pepper, Premium black pepper, Pure black pepper, 100% black pepper, K Pepper seasoning, Black pepper for cooking, Natural black pepper, Gourmet black pepper, spices, Premium seasoning |
Discover K Pepper Black Pepper 125g, made from 100% premium Vietnamese black pepper. Ideal for seasoning meats, seafood, vegetables, soups, sauces, and everyday cooking with rich, natural flavor |
|
K Pepper Black Pepper 125g | K Coffee |
|
|
|
82000.00000000 |
313M |
63 |
K COFFEE |
|
tieu-den-k-pepper-125-g-tieu-sach-nguyen-chat |
302/313 |
|
D |
|
|