Query time 0.02636
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": 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_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_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_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')"
}
},
{
"block-nl-join": {
"table": {
"table_name": "<derived2>",
"access_type": "ALL",
"rows": 12918,
"filtered": 100,
"attached_condition": "ps.product_id = 26927"
},
"buffer_type": "flat",
"buffer_size": "125Kb",
"join_type": "BNL",
"attached_condition": "trigcond(ps.product_id = 26927)",
"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 |
discussion_type |
average_rating |
product_reviews_count |
sold |
| 26927 |
10547_02 |
P |
A |
567 |
0 |
993 |
500.000 |
0 |
0 |
0 |
0.00 |
0 |
1655312400 |
1729571160 |
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, Cashew Butter For Bread Spread, Mixed Nut Salad, Nutritious Sugar-Free Butter, Convenient Healthy Breakfast |
|
|
<p>The peanut butter from Spoon It Up has a certain smoothness that can help liven up your light meals.</p>
<p>The product is vegan so it’s great for those who don’t include meat in their diet. You can just spread some on bread or mix it with salad or cereal, and you will then have a healthy and delicious meal without spending too much time.</p> |
|
|
, Peanut Butter, Cashew Butter For Bread Spread, Mixed Nut Salad, Nutritious Sugar-Free Butter, Convenient Healthy Breakfast |
Peanut Butter - SPOON it UP | CHUS |
|
|
<p>- Net weight: 210g</p>
<p>- Ingredients: Peanuts, molasses, 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>- 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 a food that is good for cardiovascular health and is suitable to add to your daily diet. In particular, the product does not contain preservatives or any toxic chemicals, so you can rest assured of using it for the whole family.</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 |
|
19688 |
SPOON it UP |
2 |
peanut-butter-en |
95/118 |
|
D |
5.00 |
2 |
2 |