Query time 0.00091
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": "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 |
| 363 |
PEPXC00026 |
P |
A |
3 |
188000.00 |
100 |
0.000 |
0 |
0 |
0 |
0.00 |
0 |
1784319475 |
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 Freeze-Dried Green Pepper Grinder 26g |
|
|
<div><p><span style="font-size: 40px; font-weight: 700;">K PEPPER FREEZE-DRIED GREEN PEPPER GRINDER 26G – PREMIUM WHOLE GREEN PEPPER WITH FRESH FLAVOR</span></p><p><b>K PEPPER Freeze-Dried Green Pepper Grinder 26g </b>is made from 100% carefully selected whole green peppercorns sourced from Vietnam's premium pepper-growing regions. Shortly after harvesting, the peppercorns are processed using advanced German freeze-drying technology, helping preserve their natural green color, distinctive spicy taste, and delicate sweetness found in fresh green pepper.</p><p>Packaged in a premium glass bottle with a built-in grinder, the product allows you to grind fresh pepper whenever needed, delivering exceptional freshness and convenience for every meal.</p><h2>Ingredients</h2><ul> <li>100% whole green 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>Made from carefully selected premium whole green peppercorns.</li> <li>Processed using advanced German freeze-drying technology.</li> <li>Preserves the natural green color, distinctive spicy taste, and delicate sweetness.</li> <li>Built-in grinder for freshly ground pepper anytime.</li> <li>Elegant, refillable glass bottle.</li> <li>Ideal for home kitchens, restaurants, and professional chefs.</li></ul><ul> <li>International Quality Certifications</li> <li><strong>K PEPPER</strong> Freeze-Dried Green Pepper Grinder 26g is produced under the integrated manufacturing system of Phuc Sinh Corporation and complies with internationally recognized standards, including:</li> <li><strong>Rainforest Alliance</strong></li> <li>Kosher</li> <li>Halal</li> <li>BRC Global Standard</li> <li>These certifications demonstrate the brand's commitment to premium quality, food safety, and sustainable production practices.</li> <li>Perfect for Everyday Cooking</li></ul><ul> <li><strong>K PEPPER</strong> Freeze-Dried Green Pepper Grinder is ideal for a variety of dishes, including:</li> <li>Green pepper beef steak</li> <li>Seafood</li> <li>Grilled meat</li> <li>Braised fish</li> <li>Braised dishes</li> <li>Pickled dishes</li> <li>Sauces</li> <li>Asian and Western cuisine</li> <li>Thanks to the freeze-drying process, the peppercorns retain many of the characteristics of fresh green pepper, enhancing the richness and complexity of your dishes. Green pepper naturally contains piperine, vitamin A, vitamin C, selenium, and a variety of natural 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>Better preserve the quality of whole peppercorns compared to pre-ground pepper.</li> <li>Refill and clean the bottle with ease.</li> <li>Its compact and modern design makes it a stylish addition to dining tables and contemporary kitchens.</li></ul><h2>Why Choose K PEPPER Freeze-Dried Green Pepper Grinder 26g?</h2><p>Made from 100% premium whole green peppercorns.</p><p>Advanced freeze-drying technology preserves freshness, color, and quality.</p><p>Convenient built-in grinder for freshly ground pepper.</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 producers and exporters of pepper, with a rigorous quality control process from carefully selected raw materials to finished products.</p><p></p></div> |
K PEPPER Freeze-Dried Green Pepper Grinder 26g, Freeze-dried green pepper, Green pepper grinder, Whole green peppercorns, Premium green pepper, K PEPPER, green pepper, Natural green pepper, Green pepper seasoning, Premium spices, Pepper grinder |
K PEPPER Freeze-Dried Green Pepper Grinder 26g is made from 100% premium whole green peppercorns using advanced German freeze-drying technology. Features a built-in grinder for freshly ground pepper anytime. |
|
K PEPPER Freeze-Dried Green Pepper Grinder 26g | K Coffee |
|
|
|
188000.00000000 |
311M |
66 |
K COFFEE |
|
tieu-xanh-say-lanh-k-pepper-26-g-coi-xay-tieu |
302/311 |
|
D |
|
|