Query time 0.05583
JSON explain
{
"query_block": {
"select_id": 1,
"nested_loop": [
{
"table": {
"table_name": "point_prices",
"access_type": "system",
"possible_keys": ["unique_key", "src_k"],
"rows": 0,
"filtered": 0,
"const_row_not_found": true
}
},
{
"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_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
}
},
{
"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
}
},
{
"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": 13,
"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": "<derived2>",
"access_type": "ALL",
"rows": 12918,
"filtered": 100,
"attached_condition": "ps.product_id = 6555"
},
"buffer_type": "flat",
"buffer_size": "161Kb",
"join_type": "BNL",
"attached_condition": "trigcond(ps.product_id = 6555)",
"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": 12918,
"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 |
average_rating |
product_reviews_count |
discussion_type |
sold |
| 6555 |
10539_02 |
P |
A |
473 |
0 |
999 |
2500.000 |
0 |
0 |
0 |
0.00 |
0 |
1655312400 |
1726252658 |
0 |
N |
N |
N |
B |
N |
|
N |
N |
N |
Y |
10 |
Y |
1 - 2 |
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:40;s:9:"box_width";i:20;s:10:"box_height";i:20;} |
|
0 |
|
N |
N |
en |
Zafu, Meditation Cushion Stuffed With Mung Bean Husk, Mixed Color Collection |
|
|
<p>A soft, delicately made zafu will be a meaningful gift to express your love to the recipient.</p>
<p>The zafus at La Touche are made by the hands of craftsmen with more than 30 years of experience and are filled with care. Each of them is a combination of durable canvas fabric and mung bean husk, which guarantee safety for the skin. With this meditation cushion, La Touche wishes that every consumer can find peace in their soul amidst the daily chaos.</p> |
|
|
, Zafu, Meditation Cushion Stuffed With Mung Bean Husk, Mixed Color Collection |
Zafu, Meditation Cushion Stuffed With Mung Bean Husk, Mixed Color Collection |
|
|
<p>- Size: 35 x 35 x 15cm</p>
<p>- Weight: 1.5kg</p>
<p>- Materials: Canvas, mung bean husk</p> |
<p>1. Uses:</p>
<p>- Helps you more comfort when sitting for a long time, drinking tea, or meditating</p>
<p>- Decorates the house</p>
<p>2. Preservations:</p>
<p>- Keep the product in a dry and clean place, avoid moisture, water and dust</p>
<p>- It is recommended to dry the pillow under the sun once a month. When washing the case, do not use bleach nor dry under direct sunlight to preserve the color</p>
<p>- It is recommended to replace the pillowcase every 2 years to maintain the best quality of the pillow</p>
<p>- The product has 6 months warranty for defects in seams and zippers</p> |
Meditative Postures | Natural Materials | Therapy | Healthcare | Eco-friendly | Sustainable |
<p>1. Ocean peace</p>
<p>2. Calm</p>
<p>3. Sandy</p>
<p>4. Forest sunbeam</p>
<p>5. Eclipse</p>
<p>6. My rose (Limited edition)</p> |
<p>In Buddhism, it is necessary to sit upright and in the proper position when performing rituals or meditating. This is when soft zafus comes in handy, preventing excessive pressure on the spine and lowering the risk of spinal pain.</p>
<p>In addition to use at home, the product is appropriate for use in temples or high-class meditation centers, etc.</p> |
<p>La Touche was founded by individuals who share the same wish to bring comfort and peaceful moments through relaxation and therapeutic products. The brand focuses on the inner world - where mind and soul are the main objects that influence one's cognition.</p>
<p>La Touche used natural scrap such as mung bean husks to make high-quality zafus, zabutons or yoga bolsters by hand. All of the materials are nature-based, safe to both health and the environment.</p>
<p>Not only being beneficial items for health improvement, the products that this brand provides can be considered as a way to renew your spiritual world, where everyone can have access to their peace of mind, thanks to their delicate designs and meaningful names.</p> |
a:4:{s:17:"rs_brand_producer";a:3:{i:0;s:82:"Provides relaxation, meditation, and therapeutic items made from natural materials";i:1;s:45:"Supports to improve health and spiritual life";i:2;s:49:"Utilizes mung bean husk to promote sustainability";}s:14:"rs_ingredients";a:2:{i:0;s:44:"Natural materials, harmless and eco-friendly";i:1;s:45:"Natural seeds, flower buds and essential oils";}s:14:"rs_manufacture";a:1:{i:0;s:57:"Manual sewingIndustrial drying process to prevent insects";}s:17:"rs_certifications";a:0:{}} |
|
|
1 |
590000.0000 |
183M,183M,183M,183M,183M,183M,183M,183M,183M,183M,183M,183M,183M |
416M,418,419,420,421,422,444,460,463,490,491,492,517 |
14797 |
La Touche |
|
zafu-meditation-cushion-stuffed-with-mung-bean-husk-mixed-color-collection |
103/183 |
|
5.00 |
1 |
D |
|