Query time 0.00208
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 |
| 365 |
PEPBC00070 |
P |
A |
3 |
173000.00 |
100 |
0.000 |
0 |
0 |
0 |
0.00 |
0 |
1784319839 |
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 Four Pepper Blend Grinder 70g |
|
|
<div><p><span style="font-size: 40px; font-weight: 700;">K PEPPER FOUR PEPPER BLEND GRINDER 70G – A PREMIUM BLEND OF FOUR EXCEPTIONAL PEPPERCORNS</span></p><p><b>K PEPPER Four Pepper Blend Grinder 70g </b>is a premium seasoning that combines four carefully selected pepper varieties: black pepper, white pepper, freeze-dried green pepper, and freeze-dried pink pepper. Each variety contributes its own unique characteristics, creating a harmonious balance of bold spiciness, subtle warmth, delicate sweetness, and vibrant natural colors to elevate a wide range of dishes.</p><p>Packaged in an elegant glass bottle with a built-in grinder, it allows you to grind fresh pepper directly before serving, ensuring maximum freshness and delivering a superior seasoning experience for every meal.</p><h2>Ingredients</h2><ul> <li>Whole black peppercorns</li> <li>Whole white peppercorns</li> <li>Freeze-dried green peppercorns</li> <li>Freeze-dried pink peppercorns</li> <li><strong>No artificial colors</strong></li> <li><strong>No preservatives</strong></li> <li>No fillers or impurities</li></ul><h2>Product Highlights</h2><ul> <li>A premium blend of four carefully selected pepper varieties.</li> <li>Combines bold, mild, fresh, and slightly sweet pepper notes in one grinder.</li> <li>Freeze-dried green and pink pepper help preserve their natural color and quality.</li> <li>Built-in grinder for freshly ground pepper anytime.</li> <li>Elegant refillable glass bottle.</li> <li>Suitable for home kitchens, restaurants, and professional chefs.</li></ul><ul> <li>International Quality Certifications</li> <li><strong>K PEPPER</strong> Four Pepper Blend Grinder is produced under the integrated manufacturing system of Phuc Sinh Corporation and meets internationally recognized quality standards, including:</li> <li><strong>Rainforest Alliance</strong></li> <li>Kosher</li> <li>Halal</li> <li>BRC Global Standard</li> <li>These certifications reflect the brand's commitment to food safety, premium quality, and sustainable production practices.</li></ul><ul> <li>Perfect for Everyday Cooking</li> <li><strong>K PEPPER</strong> Four Pepper Blend Grinder is an excellent seasoning for a variety of dishes, including:</li> <li>Steak</li> <li>Seafood</li> <li>Grilled meat</li> <li>Pasta</li> <li>Salads</li> <li>Soups</li> <li>Braised dishes</li> <li>Stir-fried dishes</li> <li>Sauces</li> <li>Asian and Western cuisine</li></ul><ul> <li>The carefully balanced blend of four pepper varieties adds greater depth and complexity to recipes, making it ideal for both marinating ingredients and finishing dishes just before serving. Peppercorns naturally contain piperine, manganese, iron, potassium, and a variety of naturally occurring antioxidants that contribute valuable nutrients to a balanced diet.</li></ul><ul> <li>Convenient Built-in Grinder</li> <li>The premium glass bottle features an integrated grinder that allows you to:</li> <li>Grind fresh pepper directly before serving.</li> <li>Easily control the amount of seasoning.</li> <li>Preserve the freshness and quality of whole peppercorns longer than pre-ground pepper.</li> <li>Refill and clean the grinder with ease.</li> <li>Its compact and modern design makes it an attractive addition to any dining table or kitchen.</li></ul><h2>Why Choose K PEPPER Four Pepper Blend Grinder 70g?</h2><p>A premium combination of black, white, freeze-dried green, and freeze-dried pink peppercorns.</p><p>Delivers a rich, well-balanced pepper profile in one convenient grinder.</p><p>Built-in grinder for freshly ground seasoning every time.</p><p><strong>No artificial colors</strong>, preservatives, or fillers.</p><p>Certified to international food safety standards.</p><p>Produced by <strong>K PEPPER</strong>, the premium spice brand of Phuc Sinh Corporation, one of Vietnam's leading pepper producers and exporters, with rigorous quality control from carefully selected raw materials to finished products.</p><p></p></div> |
K PEPPER Four Pepper Blend Grinder 70g, Four pepper blend, Mixed peppercorn grinder, Premium pepper blend, Whole mixed peppercorns, Black white green pink pepper, K PEPPER, pepper, Premium spices, Pepper grinder, Mixed pepper seasoning |
K PEPPER Four Pepper Blend Grinder 70g combines premium black, white, freeze-dried green, and freeze-dried pink peppercorns in a convenient built-in grinder, delivering a rich and well-balanced seasoning for everyday cooking. |
|
K PEPPER Four Pepper Blend Grinder 70g | K Coffee |
|
|
|
173000.00000000 |
311M |
75 |
K COFFEE |
|
tieu-bon-mua-k-pepper-70-g-coi-xay-tieu |
302/311 |
|
D |
|
|