Query time 0.02160
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 = 27293 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 = 27293 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 = 27293"
},
"buffer_type": "flat",
"buffer_size": "53Kb",
"join_type": "BNL",
"attached_condition": "trigcond(ps.product_id = 27293)",
"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 |
| 27293 |
10551_10 |
P |
A |
480 |
0 |
999 |
45.000 |
0 |
0 |
0 |
0.00 |
0 |
1655312400 |
1726252669 |
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 |
Nude Pink Lipstick, #15 Tropical Lipstick |
|
|
<p>If you’re passionate about using non-toxic makeup that doesn’t cause harm to you, animals, or the environment around you, then Fruit Skin's lipstick is for you. The lipstick contains aloe barbadensis leaf extract, shea butter and oil of nuts that nourishes and softens the lips. With this soft nude pink color, your lips will be brightened up with freshness, while being cared for in a healthy way.</p> |
|
|
, Nude Pink Lipstick, #15 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>The lipstick is ideal for women with fair to very fair skin tones. You can also use it as a lip primer so that the color of your other lipstick stands out more, making you look radiant.</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 |
4071 |
Fruit Skin |
|
son-nhiet-doi-mau-hong-nude-15-en |
102/175 |
|
D |
|
|
|