Query time 0.01860
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": 7,
"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 = 6606 and point_prices.lower_limit = 1 and point_prices.usergroup_id in (0,0,1)"
},
"buffer_type": "flat",
"buffer_size": "125Kb",
"join_type": "BNL",
"attached_condition": "trigcond(1) and trigcond(point_prices.product_id = 6606 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 = 6606"
},
"buffer_type": "flat",
"buffer_size": "53Kb",
"join_type": "BNL",
"attached_condition": "trigcond(ps.product_id = 6606)",
"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 |
| 6606 |
10541_06 |
P |
A |
476 |
0 |
999 |
500.000 |
0 |
0 |
0 |
0.00 |
0 |
1655312400 |
1726252658 |
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:15;s:9:"box_width";i:10;s:10:"box_height";i:5;} |
|
0 |
|
N |
N |
en |
Body Cream |
|
|
<p>Don't forget your body skin if you want to have a radiant and youthful appearance. With the body cream from Co Mulan, you will quickly achieve a soft and bright skin tone after only a period of use.</p>
<p>The cream is a combination of moisturizing and deep-restoring active ingredients to help smooth skin with no sign of roughness. Along with that, glutathione and vitamins A, C, and B3 have the ability to effectively tone up the skin, making it radiant and vibrant.</p> |
|
|
, Body Cream |
|
|
|
<p>- Weight: 250g</p>
<p>- Ingredients: Water, Axit Kojic, Hydroquinone, Acid Azelaic, Beta Arbutin, Vitamin A, Vitamin C, Glutathione, Licorice Root, Niacinamide-Vitamin B3</p> |
<p>1. Instructions:</p>
<p>- Clean and dry skin before using</p>
<p>- Take an appropriate amount of cream on the palm and then rub it in a spiral direction to quickly and evenly</p>
<p>- Suitable for all skin types.</p>
<p>2. Expiry date: 2 years from manufacturing date</p> |
Vietnamese Cosmetics | Skin Whitening | Anti-Aging | Acne Support | Suitable For Dry Skin | Alcohol Free | Paraben Free |
|
<p>Some people take care of their facial skin very carefully but forget about their body skin. Therefore, Co Moc Lan especially brings you this body cream with highly effective whitening and dead cell removal ingredients such as kojic acid, beta arbutin, vitamin C, vitamin B, etc. to help quickly achieve a healthy, smooth and glowing skin.</p> |
<p>Each skin type will face different troubles. Therefore, proper care and products are required. Understanding this, Co Moc Lan was born, bringing skin care products that are best for skin problems such as acne, melasma, etc.</p>
<p>With the motto of becoming the best friend of women's skin, the brand is constantly researching and improving formulas to create more effective, more suitable products. They combined the folk skincare experiences of Asians with modern skin care methods to make the products.</p>
<p>Besides, the quality of ingredients is top of mind. Therefore, Co Moc Lan carefully selects raw ingredients from extracts of precious herbs commonly used in Oriental medicine to synthetic substances.</p>
<p>Using Co Moc Lan products, you are not only supporting the development of Vietnamese cosmetics but your skin is also being cared for most.</p> |
a:4:{s:17:"rs_brand_producer";a:2:{i:0;s:25:"Vietnamese cosmetic brand";i:1;s:77:"Combination of natural ingredients, traditional formula and modern technology";}s:14:"rs_ingredients";a:3:{i:0;s:19:"Natural ingredients";i:1;s:14:"Herbal extract";i:2;s:39:"Carefully selected synthetic substances";}s:14:"rs_manufacture";a:1:{i:0;s:19:"Advanced technology";}s:17:"rs_certifications";a:1:{i:0;s:57:"Compliance to cGMP (Cosmetic Good Manufacturing Practice)";}} |
|
|
1 |
380000.0000 |
174M,174M,174M,174M,174M,174M,174M |
416M,418,420,421,477,491,515 |
10380 |
Cổ Mộc Lan |
|
body-cream-en |
102/174 |
|
D |
5.00 |
1 |
|