Query time 0.02624
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": 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": "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": 2,
"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": 2,
"filtered": 100,
"attached_condition": "trigcond(cscart_seo_names.`type` = 'p' and cscart_seo_names.dispatch = '' and cscart_seo_names.lang_code = 'en')"
}
},
{
"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": 12545,
"filtered": 100,
"attached_condition": "ps.product_id = 5220"
},
"buffer_type": "flat",
"buffer_size": "126Kb",
"join_type": "BNL",
"attached_condition": "trigcond(ps.product_id = 5220)",
"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": 12545,
"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 |
discussion_type |
average_rating |
product_reviews_count |
sold |
| 5220 |
10436_16 |
P |
A |
383 |
0 |
999 |
150.000 |
0 |
0 |
0 |
0.00 |
0 |
1655312400 |
1726252644 |
0 |
N |
N |
N |
B |
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:10;s:9:"box_width";i:10;s:10:"box_height";i:10;} |
|
0 |
|
N |
N |
en |
Baby Bath Salt With Essential Oil, Soothing Essential Oils For Relaxation, Self-Care For Women, Celebrate Her, Calm & Relaxation, Mom Relaxation, 150Gr |
|
|
<p>You can use bath salt products for not only adults but also babies to take care of their sensitive skin.</p>
<p>The Baby Bath Salt from Lien Minh Xanh is made of Himalaya, Epsom, essential oil and coconut oil with great benefits to the skin. The combination of these two salts will clean and prevent many skin problems. Meanwhile, coconut oil is added to make your babies' skin soft and moisturized to make them feel comfortable after each use.</p> |
|
Transform bath time into blissful serenity. All-natural bath salts and soothing essential oils for your little one. |
, Baby Bath Salt With Essential Oil, Soothing Essential Oils For Relaxation, Self-Care For Women, Celebrate Her, Calm & Relaxation, Mom Relaxation, 150Gr |
Baby Bath Salt With Essential Oil: Soothing Essential Oils for Relaxation |
|
|
<p>- Weight: 150g</p>
<p>- Ingredients: Melaleuca Quinquenervia essential oil, coconut oil, Himalaya, Epsom salt</p> |
<p>1. Benefits:</p>
<p>- Helps clear skin</p>
<p>- Prevents heat rash, soothes itchiness and rashes on skin</p>
<p>2. Instructions:</p>
<p>- Mix 5-10g salt (about 2-3 spoons) with 10-15 liters of lukewarm water, use to bathe baby daily</p>
<p>- No need to wash with water again</p>
<p>5. Expiry date: 24 months from date of manufacture</p> |
Body Care | Healthy | Bath Salt | Essential Oil | Coconut Oil |
|
<p>Epsom salt is an inorganic mineral salt containing magnesium and sulfur. When bathing with salt, the minerals inside in Epsom salt and Himalayan pink salt will be dissolved into the water and absorbed into your skin. That way, you will be provided with a bit of minerals even during bathing time. In addition, a warm bath with salt will also help relieve muscles sore, as well as soothe redness or sunburn.</p> |
<p>Truong Son Mountain Range has a diverse floral and faunal system. The flora here takes up to half of Vietnam’s endemic plants, including precious medicinal herbs.</p>
<p>Born in Hue, the land that absorbs Truong Son’s essence through Bach Ma mountain, pharmacist Dang Binh desires to share the value of plants here by presenting quality health care and pharmaceutical cosmetics products to the customers.</p>
<p>After more than a year researching continuously, he founded Lien Minh Xanh (Green Net) to provide customers with outstanding products made from natural elements. All the ingredients come from the Hue and Truong Son area, planted, cared for and harvested by local people.</p>
<p>In addition to delivering health care and pharmaceutical cosmetics to its customers, the brand creates a stable income for many people by providing them with jobs, as well as contributes to the sustainability of the environment with relevant sourcing and production processes.</p> |
a:4:{s:17:"rs_brand_producer";a:5:{i:0;s:94:"An eco-minded local business from Hue that supports Vietnamese agriculture and sustainability.";i:1;s:59:"Provide a hugely green line of personal care and cosmetics.";i:2;s:0:"";i:3;s:0:"";i:4;s:0:"";}s:14:"rs_ingredients";a:5:{i:0;s:72:"The brand plants and harvests their own medicinal herbs for ingredients.";i:1;s:0:"";i:2;s:0:"";i:3;s:0:"";i:4;s:0:"";}s:14:"rs_manufacture";a:5:{i:0;s:38:"Modern essential oil extraction method";i:1;s:0:"";i:2;s:0:"";i:3;s:0:"";i:4;s:0:"";}s:17:"rs_certifications";a:5:{i:0;s:0:"";i:1;s:0:"";i:2;s:0:"";i:3;s:0:"";i:4;s:0:"";}} |
|
|
1 |
80000.0000 |
174M,174M |
512M,477 |
12379 |
SAOLA |
|
baby-bath-salt-with-essential-oil |
102/174 |
D |
5.00 |
1 |
|