Query time 0.04809
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": 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": 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": 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 = 26926"
},
"buffer_type": "flat",
"buffer_size": "126Kb",
"join_type": "BNL",
"attached_condition": "trigcond(ps.product_id = 26926)",
"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 |
| 26926 |
10547_01 |
P |
A |
567 |
0 |
993 |
500.000 |
0 |
0 |
0 |
0.00 |
0 |
1655312400 |
1726250787 |
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:15;s:10:"box_height";i:5;} |
|
0 |
|
N |
N |
en |
Peanut Butter Crunchy, Peanut Butter For Bread Accompaniment, Protein-Rich Peanut Butter, Vegetarian Diet, Salty Peanut Salad Mix |
|
|
<p>This peanut butter from Spoon It Up has a mild salty taste and a creamy texture, with a bit of crunchiness from coarse peanut pieces.</p>
<p>The product does not contain any artificial additives, so be assured when choosing it for your family meal. If you are busy but want to stick closely to healthy diets, this Peanut Butter Crunchy will be a hard-to-miss food choice.</p> |
|
|
, Peanut Butter Crunchy, Peanut Butter For Bread Accompaniment, Protein-Rich Peanut Butter, Vegetarian Diet, Salty Peanut Salad Mix |
Peanut Butter Crunchy - SPOON it UP | CHUS |
|
|
<p>- Net weight: 210g</p>
<p>- Ingredients: Peanut (99%), sea salt</p> |
<p>- No stabilizer</p>
<p>- No artificial preservatives</p>
<p>- No artificial additives</p>
<p>- Eat with toasts, fruits, yogurt, oats, sandwiches, sauces, etc.</p>
<p>- Great for the heart, reduce the risk of diabetes, maintain healthy blood pressure, provide great source of energy</p>
<p>- Expiry: 8 months in room temperature and 10 months at 2 – 5°C (in the fridge)</p>
<p>- Store in a dry cool place</p> |
Bread Spread | Salad Dressing | Protein-Rich | Vegan | No Sugar | No Artificial Additives |
|
<p>Peanut butter is high in oleic acid, a fat that can balance cholesterol level, blood sugar level, and blood pressure. These are the three factors closely associated with heart health. Therefore, you may want to consider reducing the amount of fat and adding peanut butter rich in this helpful fat to your diet instead.</p> |
<p>As the name may have suggested, Spoon It Up offers food lovers high-quality BBQ sauces, Italian sauces and nut butters to serve with pasta and bread, or more. The brand was co-founded by Ms. Le Thi Thao - a Quang Nam-born who loves her hometown deeply, and Mr. Igor Pescarolo - a professional chef with more than ten years of experience.</p>
<p>To ensure the quality of each jar of sauce and butter, Spoon It Up only chooses fresh ingredients such as imported Roma tomatoes, Quang Nam peanuts, and other clean local herbs and spices. Everything is processed on a hygienic, modern production line. The brand is committed to not using artificial additives and GMO foods, ensuring safety. At the same time, the products here are also suitable for those who pursue vegan or clean-eating lifestyles.</p>
<p>After starting up for a while, Spoon It Up has eventually won the trust of its local and global customers. The positive feedback from buyers is the true motivation for the Spoon It Up team to continue on its journey of making quality food for everyone.</p> |
a:4:{s:17:"rs_brand_producer";a:5:{i:0;s:70:"Quality, clean BBQ sauce, pasta sauce, peanut butter and cashew butter";i:1;s:83:"Offer healthy choices for those who follow vegan diet, gluten-free diet, or gymmers";i:2;s:0:"";i:3;s:0:"";i:4;s:0:"";}s:14:"rs_ingredients";a:5:{i:0;s:150:"Roma tomatoes imported from Italy, Quang Nam peanuts, cashews, Ly Son black garlic, chili, extra virgin olive oil, black pepper, marjoram, basil, etc.";i:1;s:13:"Pork and beef";i:2;s:12:"No GMO foods";i:3;s:69:"No artificial additives (no preservatives, no fillers, no flavorings)";i:4;s:0:"";}s:14:"rs_manufacture";a:5:{i:0;s:52:"Special recipe from professional chef Igor Pescarolo";i:1;s:38:"Modern and hygienic production process";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 |
80000.0000 |
118M |
|
10565 |
SPOON it UP |
2 |
peanut-butter-crunchy |
95/118 |
D |
5.00 |
4 |
1 |