Query time 0.02799
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": 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')"
}
},
{
"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 = 935"
},
"buffer_type": "flat",
"buffer_size": "126Kb",
"join_type": "BNL",
"attached_condition": "trigcond(ps.product_id = 935)",
"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 |
| 935 |
10201_16 |
P |
A |
528 |
0 |
1998 |
500.000 |
0 |
0 |
0 |
0.00 |
0 |
1655312400 |
1726252607 |
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:20;s:9:"box_width";i:10;s:10:"box_height";i:10;} |
|
0 |
|
N |
N |
en |
OM Fountain Rice Bran Cleansing Oil |
|
|
<p>With this Rice Bran Cleansing Oil from OM Fountain, your skin will be nourished and cleaned effectively.</p>
<p>Rice bran has always been a familiar ingredient in the skincare field because of its gentleness and brightening benefit. Extracted from pure rice bran, the Rice Bran Cleansing Oil from OM easily takes away all of the stubborn makeup, dirt and excessive oil without drying out the skin and gives you a radiant and soft skin.</p> |
|
|
, OM Fountain Rice Bran Cleansing Oil |
|
|
|
<p>Size: 14,5 x 8,8cm</p>
<p>Volume: 100ml</p>
<p>Ingredients: Caprylic/Capric Triglyceride, Oryza Sativa (Rice) Bran Oil, PEG-20 Glyceryl Triisostearate, Tocopheryl Acetate, Isotridecyl Isononanoate, Bis-Ethoxydiglycol Cyclohexane 1,4-Dicarboxylate.</p> |
|
Cleansing oil | Rice products | Pharmaceutical brand | Natural products | Eco-friendly | Sustainability |
|
<p>When you use cleansing oil, it is necessary to thoroughly emulsify in order not to leave excessive oil, makeup on the skin - this can cause plump skin and clogged pores.</p> |
<p>OM Fountain is a Vietnamese brand that specializes in manufacturing pharmaceutical products with natural ingredients, following the motto of enhancing a healthy and eco-friendly lifestyle.</p>
<p>The first idea behind OM Fountain's establishment came when the brand's founder learned about “Sustainable business & Eco-friendly products" after a meeting with Six Senses - one of the top groups of resorts, hotels and spas. She immediately got hooked to this alternative lifestyle and set forth to create a brand based on the idea. Since 2013, OM Fountain has made a solid reputation as a provider for eco-friendly products for 5-star resorts and hotels.</p>
<p>Products at OM Fountain are created with local partnerships, made in Vietnam and by the skillful Vietnamese artisans. These products include pure essential oils and body care items from natural ingredients, following traditional medical recipes and modern scientific methods Om works on a simple principle, that their customers “should not need to worry about their health when using the products from OM Fountain”.</p> |
a:4:{s:17:"rs_brand_producer";a:1:{i:0;s:175:"A brand specializing in making essential oil and body care products from natural ingredients, enhancing a balanced and eco-friendly lifestyle, as well as sustainable business.";}s:14:"rs_ingredients";a:1:{i:0;s:76:"Natural ingredients using both traditional and modern scientific medications";}s:14:"rs_manufacture";a:3:{i:0;s:53:"Featuring both the traditional and modern medications";i:1;s:70:"Manufacturing process with FDA standards, no silicone, parabens or SLS";i:2;s:89:"Featuring the joint of engineers from Japanese companies and the enthusiastic staff of OM";}s:17:"rs_certifications";a:0:{}} |
|
|
1 |
195000.0000 |
172M,172M,172M,172M,172M,172M,172M |
477M,418,419,420,421,490,491 |
7461 |
Om Fountain |
|
om-fountain-rice-bran-cleansing-oil |
102/172 |
D |
|
|
|