Query time 0.04119
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": 10,
"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 = 27289 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 = 27289 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 = 27289"
},
"buffer_type": "flat",
"buffer_size": "53Kb",
"join_type": "BNL",
"attached_condition": "trigcond(ps.product_id = 27289)",
"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 |
| 27289 |
10551_05 |
P |
A |
480 |
0 |
999 |
45.000 |
0 |
0 |
0 |
0.00 |
0 |
1655312400 |
1726252663 |
0 |
N |
N |
N |
B |
N |
|
N |
N |
N |
Y |
10 |
Y |
3 - 4 |
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:2;s:9:"box_width";i:2;s:10:"box_height";i:8;} |
|
0 |
|
N |
N |
en |
Burnt Orange Lipstick, #12 Tropical Lipstick |
|
|
<p>Burnt orange goes well with almost everything, from darker to fairer skin tones. In addition, you will not have to worry about your lips being damaged when using this product from Fruit Skin. This lipstick is formulated with natural-origin ingredients like oil of nuts and aloe barbadensis leaf extract, will keep your lips soft and plump all day long.</p> |
|
|
, Burnt Orange Lipstick, #12 Tropical Lipstick |
|
|
|
<p>1. Net weight: 5g</p>
<p>2. Ingredients: Candelilla wax, aloe barbadensis leaf extract, beeswax, avocado oil, coconut oil, olive oil, almond oil, rice bran oil, shea butter, avocado butter, vitamin E, lanolin, earth pigment, phenoxyethanol, Phthalates-free fragrance</p>
<p>3. Storage:</p>
<p>- Store in temperatures below 30 degrees Celsius.</p>
<p>- Expiry date: 18 months</p>
<p>- Period after opening: 6 months</p> |
|
Lip Care | Natural Ingredients | Vietnamese Fruit | Safe For Health | Lead-Free | Paraben-Free |
|
<p>Burnt orange is always one of the favorite lipstick colors for ladies with a warm undertone and is suitable for many different purposes, such as going out or going to work. Whether the skin has a medium or fair complexion, this lipstick color will do an excellent job of helping a lady shine confidently.</p> |
<p>Fruit Skin utilizes Vietnam's abundant agricultural products to create green and clean beauty and cosmetic products. As said, this is where you should pay a visit if looking for lipstick, lip balm, and facial masks of natural origin, particularly from the wonderful fruits of Vietnam.</p>
<p>At Fruit Skin, the source of clean ingredients is always maintained because the brand is in direct cooperation with farmers and cooperatives, producing agricultural products according to VietGAP and GLOBALGAP standards. From the tropical lipstick line, and Dak Nong coffee lipstick, to facial masks, all are made from the goodness of nature after professional research by a team of doctors, pharmacists, and biotechnologists. Besides, the products at Fruit Skin are very safe for health because they contain zero parabens, lead or harmful substances.</p>
<p>Choosing a different path of using fruit as the core for beauty products like that, Fruit Skin wishes to give consumers quality beauty products made from clean fruits and vegetables grown locally by Vietnamese farmers. Allow safe ingredients derived from agricultural products to care for, style, and cherish your skin with Fruit Skin.</p> |
a:4:{s:17:"rs_brand_producer";a:1:{i:0;s:74:"Providing beauty products made from clean agricultural products in Vietnam";}s:14:"rs_ingredients";a:3:{i:0;s:111:"Main ingredients from nature: Hoa Loc mangoes, Dak Nong coffee, vegetable butters, seed oils, aloe vera extract";i:1;s:15:"Mineral pigment";i:2;s:88:"Do not contain: lead, paraben, sodium lauryl sulfate, sodium laureth sulfate, phthalates";}s:14:"rs_manufacture";a:2:{i:0;s:60:"Farming process according to VietGap and GLOBALGAP standards";i:1;s:55:"Application of machine that ensures quality and hygiene";}s:17:"rs_certifications";a:2:{i:0;s:19:"VietGAP certificate";i:1;s:33:"Global Good Agricultural Practice";}} |
|
|
0 |
150000.0000 |
175M,175M,175M,175M,175M,175M,175M,175M,175M,175M |
416M,418,420,421,444,460,477,491,514,515 |
6147 |
Fruit Skin |
|
son-nhiet-doi-mau-cam-chay-12-en |
102/175 |
|
D |
|
|
|