Query time 0.02769
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": 19,
"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": 2,
"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 = 1762"
},
"buffer_type": "flat",
"buffer_size": "256Kb",
"join_type": "BNL",
"attached_condition": "trigcond(ps.product_id = 1762)",
"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 |
| 1762 |
10265_21 |
P |
A |
242 |
0 |
1000 |
500.000 |
0 |
0 |
0 |
0.00 |
0 |
1655312400 |
1726252613 |
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:10;s:9:"box_width";i:10;s:10:"box_height";i:10;} |
|
0 |
|
N |
N |
en |
Activated Charcoal Deodorizing Shoes, Shoe Odor Remover, Trunk Odor Remover, Antibacterial Activated Charcoal, Bamboo Charcoal Air Purifier |
|
|
<p>Activated Charcoal Deodorizing Shoes will be a secret assistant to help you beautify your feet anytime, anywhere.</p>
<p>The chemical structure of activated carbon will work strongly in an environment with an unpleasant odor, sucking away all long-term sweat odors that lead to foot odor. Helps kill mold, bacteria and other harmful substances. Besides using for shoes, you can also use charcoal bags to effectively deodorize backpacks, bags, and car trunks.</p> |
|
|
, Activated Charcoal Deodorizing Shoes, Shoe Odor Remover, Trunk Odor Remover, Antibacterial Activated Charcoal, Bamboo Charcoal Air Purifier |
Activated Charcoal Deodorizing Shoes - Hapaku | CHUS |
|
|
<p>- Size: 10.5 x 18 x 4.5cm</p>
<p>- Ingredients: 100% quality Ben Tre coconut shell activated carbon, the best ability to absorb odors.</p> |
<p>Using:</p>
<p>- Put charcoal bags in places that need to be deodorized such as shoes, slippers, cabinets, car trunks, backpacks</p>
<p>- After each month of use, expose to the sun for at least 1 hour to refresh.</p>
<p>Preservation:</p>
<p>- Store in a cool, dry place, away from direct sunlight and high temperature</p>
<p>- Keep out of reach of children</p>
<p>Expired date:</p>
<p>Coconut shell activated carbon belongs to the renewable carbon line, so it can be used for 2 consecutive years. After 2 years, use this coal to plant trees, both helping the soil to be porous and protecting the environment.</p> |
Activated Charcoal | Deodorant | Refresh Air | Natural Ingredients | Non-toxic |
|
<p>Activated charcoal is famous for its ability to effectively clean and deodorize. Let everything around you become thoroughly clean, make you confident and comfortable in life with activated carbon bags.</p> |
<p>Hapaku, an electric herbal aims belts/packs brand from Vietnam was established with an aim to help relieve people with chronic joint pain. Hapaku is a subsidiary brand and was founded by Sen Capital, a brand focused on manufacturing health care products from natural herbs.</p>
<p>Hapaku is the first brand in Vietnam to apply electric heating technology, combined with traditional natural herbs that have been used as home remedies for a long time. Through constant research and testing, Hapaku has perfected a benign herbal formula with high medicinal value. Each product is a tested solution for those who often suffer from muscle and joint pain.</p>
<p>At Hapaku, they believe that health is the foundation for a prosperous lifestyle and strive to develop solutions for better health each day.</p> |
a:4:{s:17:"rs_brand_producer";a:5:{i:0;s:61:"The first brand of electric herbal belts and packs in Vietnam";i:1;s:74:"Helps relieve pain, heal and relax mentally, considered safe and effective";i:2;s:0:"";i:3;s:0:"";i:4;s:0:"";}s:14:"rs_ingredients";a:5:{i:0;s:89:"Source of high-quality herbal ingredients, traceable herbal origin in each product batch.";i:1;s:0:"";i:2;s:0:"";i:3;s:0:"";i:4;s:0:"";}s:14:"rs_manufacture";a:5:{i:0;s:133:"Uses therapeutic methods to relieve joint pain, muscle tension quickly, safely and economically thanks to hot heat and herbal essence";i:1;s:0:"";i:2;s:0:"";i:3;s:0:"";i:4;s:0:"";}s:17:"rs_certifications";a:5:{i:0;s:0:"";i:1;s:0:"";i:2;s:0:"";i:3;s:0:"";i:4;s:0:"";}} |
|
|
1 |
130900.0000 |
182M,182M,182M,182M,182M,182M,182M,182M,182M,182M,182M,182M,182M,182M,182M,182M,182M,182M,182M |
436M,423,424,425,426,430,432,434,437,477,478,495,496,497,500,502,504,506,507 |
4008 |
Hapaku |
|
activated-charcoal-deodorizing-shoes |
103/182 |
D |
5.00 |
3 |
4 |