Query time 0.02442
JSON explain
{
"query_block": {
"select_id": 1,
"nested_loop": [
{
"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_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": 99.9960556,
"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": "11",
"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": ["dev_db.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_products_tag_categories",
"access_type": "ref",
"possible_keys": ["pt"],
"key": "pt",
"key_length": "3",
"used_key_parts": ["product_id"],
"ref": ["const"],
"rows": 15,
"filtered": 100
}
},
{
"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 = 'en')"
}
},
{
"block-nl-join": {
"table": {
"table_name": "point_prices",
"access_type": "range",
"possible_keys": ["unique_key", "src_k"],
"key": "unique_key",
"key_length": "8",
"used_key_parts": ["lower_limit", "usergroup_id", "product_id"],
"rows": 1,
"filtered": 100,
"attached_condition": "point_prices.product_id = 31904 and point_prices.lower_limit = 1 and point_prices.usergroup_id in (0,0,1)"
},
"buffer_type": "flat",
"buffer_size": "184Kb",
"join_type": "BNL",
"attached_condition": "trigcond(1) and trigcond(point_prices.product_id = 31904 and point_prices.lower_limit = 1 and point_prices.usergroup_id in (0,0,1))"
}
},
{
"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,
"attached_condition": "trigcond(cscart_discussion.object_type = 'P')"
}
},
{
"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": 1,
"filtered": 100
}
},
{
"block-nl-join": {
"table": {
"table_name": "<derived2>",
"access_type": "ALL",
"rows": 12919,
"filtered": 100,
"attached_condition": "ps.product_id = 31904"
},
"buffer_type": "flat",
"buffer_size": "76Kb",
"join_type": "BNL",
"attached_condition": "trigcond(ps.product_id = 31904)",
"materialized": {
"query_block": {
"select_id": 2,
"filesort": {
"sort_key": "count(cscart_order_details.product_id) desc",
"temporary_table": {
"nested_loop": [
{
"table": {
"table_name": "cscart_order_details",
"access_type": "index",
"key": "o_k",
"key_length": "6",
"used_key_parts": ["order_id", "product_id"],
"rows": 12919,
"filtered": 100,
"using_index": true
}
}
]
}
}
}
}
}
}
]
}
}
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 |
is_make_to_order |
make_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 |
facebook_obj_type |
parent_product_id |
buy_now_url |
is_stock_split_by_warehouses |
is_fragile |
lang_code |
product |
shortname |
short_description |
full_description |
meta_keywords |
meta_description |
search_words |
page_title |
age_warning_message |
promo_text |
specification |
special_note |
punch_line |
selection |
chus_note |
about_brand |
why_chus |
purchasing_notice |
note_from_brand |
is_sync_seo_url |
price |
category_ids |
category_tag_ids |
popularity |
company_name |
sales_amount |
seo_name |
seo_path |
point_price |
discussion_type |
average_rating |
product_reviews_count |
sold |
| 31904 |
10617_06 |
P |
A |
614 |
0 |
999 |
200.000 |
0 |
0 |
0 |
0.00 |
0 |
1669197369 |
1726252679 |
0 |
N |
N |
N |
|
N |
|
N |
N |
N |
Y |
10 |
N |
|
0 |
N |
|
|
|
|
|
|
N |
0 |
|
|
default |
a:5:{s:16:"min_items_in_box";i:1;s:16:"max_items_in_box";i:1;s:10:"box_length";i:0;s:9:"box_width";i:0;s:10:"box_height";i:0;} |
|
0 |
|
N |
N |
en |
Vietnamese Ginseng Oolong Tea, Vietnamese Tea, Oolong Tea Blend, Panax Vietnamensis, Traditional Vietnamese Medicine Applications, Healthy Drink, 100G |
|
|
<p><span>Vietnamese Ginseng Oolong Tea offers a delightful fusion of traditional oolong tea with the invigorating properties of Panax vietnamensis. This unique blend begins with Vietnamese ginseng, a prized variety known for its potency. The ginseng is meticulously dried at low temperatures to preserve its full range of health benefits. These precious ginseng pieces are then artfully combined with oolong tea leaves. The oolong, partially oxidized between black and green tea, lends its characteristic floral aroma and smooth texture to the final brew.</span></p>
<p><span>The resulting Vietnamese Ginseng Oolong Tea boasts a captivating complexity. The initial notes are dominated by the oolong's delicate floral fragrance, hinting at jasmine or orchid. As the tea steeps, a subtle tartness emerges, adding an intriguing counterpoint to the floral sweetness. This delightful dance of flavors culminates in a lingering sweetness that lingers on the palate long after the last sip.</span><span></span></p> |
|
|
, Vietnamese Ginseng Oolong Tea, Vietnamese Tea, Oolong Tea Blend, Panax Vietnamensis, Traditional Vietnamese Medicine Applications, Healthy Drink, 100G |
Vietnamese Ginseng Oolong Tea - Mohodo Farmers | Chus |
|
|
<p>- Net weight: 100g</p><p>- Ingredients: Oolong tea, Ngoc Linh ginseng</p> |
<p>1. Benefits:</p><p>- Reduce fat absorption aid aid weight loss</p><p>- Good for digestive system</p><p>- Reduce risks of cancer</p><p>- Reduce symptoms of eczema and psoriasis</p><p>- Rejuvenate the body energy level </p><p>- Ginseng can help protect the liver and improve the immune system </p><p>2. Instructions: </p><p>The ideal temperature for brewing tea is 90 - 95 degrees Celsius.</p><p>- Step 1: Pour boiling water into tea cups and a teapot to heat them up. </p><p>- Step 2: Put tea into the teapot. The tea level should level to 1/5 or 1/6 of the teapot according to your liking.</p><p>- Step 3: Pour hot water into the teapot. Gently shake and pour out this water. This step is called rinsing to wake up the tea so they will release more flavor and fragrance.</p><p>- Step 4: Pour an appropriate amount of hot water into the teapot. Steep in around 30 to 45 seconds, then pour tea into tea cups and enjoy.</p><p>3. Notes:</p><p>- Do not add milk to this tea as milk protein can reduce the beneficial compounds of the tea blend.</p><p>- If you want a richer tea flavor, add more tea to the pot instead of steeping for longer.</p><p>- When brewing, if you want the tea water to be clear, pour the water into the pot gently so that the tea leaves don’t swirl too much. When pouring the tea out, also do it gently.</p><p>-It is recommended to brew it in a glass pot or porcelain pot. These are two materials that reflect the true quality of the tea and are easy to clean and do not linger the scent. They can also be used to brew different kinds of tea.</p> |
|
|
<p>Vietnamese ginseng is also called Ngoc Linh ginseng, with the name being the mountain where it was found. This is among the ginsengs of top value in the world, with a high content of various types of saponin as well as good-for-health vitamins such as vitamin B2, vitamin E, etc. Some of its benefits include improvements in resistance, reproductive health, the cardiovascular system, and mood.</p> |
|
a:4:{s:17:"rs_brand_producer";a:5:{i:0;s:27:"Clean herbal tea and coffee";i:1;s:46:"Tea blends following Oriental medicine recipes";i:2;s:58:"Aims for health safety and health improvement of consumers";i:3;s:36:"Promotes Vietnamese herbs and coffee";i:4;s:0:"";}s:14:"rs_ingredients";a:5:{i:0;s:82:"Ancient chrysanthemum, Ngoc Linh ginseng, jujube, longan, wolfberry, rock sugar…";i:1;s:28:"No artificial preservatives ";i:2;s:26:"No artificial food odorant";i:3;s:0:"";i:4;s:0:"";}s:14:"rs_manufacture";a:5:{i:0;s:72:"Natural farming that does not involve synthetic fertilizer and pesticide";i:1;s:27:"Heat pump drying technology";i:2;s:23:"Auto-packing technology";i:3;s:0:"";i:4;s:0:"";}s:17:"rs_certifications";a:5:{i:0;s:38:"Certificate of Food Hygiene and Safety";i:1;s:0:"";i:2;s:0:"";i:3;s:0:"";i:4;s:0:"";}} |
|
|
0 |
135000.0000 |
122M,122M,122M,122M,122M,122M,122M,122M,122M,122M,122M,122M,122M,122M,122M |
477M,418,419,420,421,422,434,437,474,485,490,491,492,504,507 |
9230 |
Mohodo Farmers |
|
ginseng-oolong-tea |
96/122 |
|
D |
5.00 |
14 |
|