Query time 0.01935
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_products_tag_categories",
"access_type": "ref",
"possible_keys": ["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_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 = 3513"
},
"buffer_type": "flat",
"buffer_size": "126Kb",
"join_type": "BNL",
"attached_condition": "trigcond(ps.product_id = 3513)",
"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 |
| 3513 |
10249_11 |
P |
A |
243 |
0 |
2 |
1000.000 |
0 |
0 |
0 |
0.00 |
0 |
1655312400 |
1724830034 |
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:15;s:9:"box_width";i:20;s:10:"box_height";i:20;} |
|
0 |
|
N |
Y |
en |
N.Y Avenue Ceramic Teapot, Vietnamese Ceramics, Household Items, Ceramic, Rustic, Kitchenware, Handmade, Aesthetic, Non-toxic, Decorations, Gift Ideas |
|
|
<p>The N.Y Avenue Teapot model from Tu Hú Ceramics is the ideal choice for your kitchen or living room space to be more elegant.</p>
<p>N.Y Avenue is designed in white tones and blue stripes. High quality stoneware material has been meticulously shaped and molded by skillful artisans. This not only helps the product to be durable, but also polishes the product to be more shiny and makes the color stand out.</p> |
|
The N.Y Avenue Teapot from Tu Hu Ceramics has sophisticated beauty, the perfect choice for lovers of handmade ceramics. Buy now at CHUS. |
, N.Y Avenue Ceramic Teapot, Vietnamese Ceramics, Household Items, Ceramic, Rustic, Kitchenware, Handmade, Aesthetic, Non-toxic, Decorations, Gift Ideas |
N.Y Avenue Ceramic Teapot - Tu Hú Ceramics | CHUS |
|
|
<p>- Size: 12cm (height) x 10cm (diameter)</p>
<p>- Materials: Stoneware</p> |
<p>Preservation:</p>
<p>- Microwave safe (at low temperature only); Do not use in oven</p>
<p>- Dishwasher safe</p>
<p>- Hand-washing is recommended to prolong the shelf life of products</p>
<p>- Do not use hard, rough brushes or steel wool to clean to avoid scratches</p>
<p>- Do not use bleach, vinegar or any acid liquid while washing ceramic products to prevent scratches</p>
<p>- Dirt and stains on unglazed surfaces can be cleaned with a scrub brush and a pinch of baking soda</p>
<p>- Avoid dramatic and sudden temperature changes, such as moving the product from a hot oven into the freeze to avoid cracks or breaks.</p> |
|
|
<p>- Other items in the same collection of N.Y.Avenue, such as espresso cup, saucer, bowl or cereal bowl are recommended for a complete and uniform stoneware set.</p>
<p>- If you like the same pattern but in the opposite arrangement of colors with blue as the main color for more eye-catchiness, you might be interested in the Taylor D2 collection from Tu Hú.</p> |
<p>Tu Hú Ceramics is a Vietnamese handcrafted brand that provides high quality ceramics.</p>
<p>With the admiration for the Vietnamese ancient pottery, Tu Hú Ceramics started to pave their way into the ceramic industry with an aspiration to revive the value of ceramic in modern life.</p>
<p>They work with both traditional and modern designs. All their pieces are handmade, a perfect combination of fine craftsmanship and functionality. At Tu Hú Ceramics, you can shop for many gorgeous and stylish ceramic products that bring an aesthetic vibe to your home, and enhance the ambiance with unique art. Tu Hú Ceramics also offers customized tableware concepts to maximize your culinary experience, as well as your needs of art.</p> |
a:4:{s:17:"rs_brand_producer";a:5:{i:0;s:55:"Produces handcrafted and high-quality ceramic products.";i:1;s:140:"Promotes a zero-waste lifestyle by collecting imperfect ceramic products and offering them to customers in need, instead of destroying them.";i:2;s:0:"";i:3;s:0:"";i:4;s:0:"";}s:14:"rs_ingredients";a:5:{i:0;s:48:"Safe for health materials, lead and cadmium free";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:8:"Handmade";i:1;s:32:"Jiggering and molding technique.";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 |
329000.0000 |
313M |
|
3561 |
Tu Hú Ceramics |
|
n.y-avenue-ceramic-teapot |
101/313 |
D |
5.00 |
13 |
|