Query time 0.03716
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_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": 4,
"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')"
}
},
{
"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 = 2694"
},
"buffer_type": "flat",
"buffer_size": "126Kb",
"join_type": "BNL",
"attached_condition": "trigcond(ps.product_id = 2694)",
"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 |
| 2694 |
10330_29 |
P |
A |
303 |
0 |
998 |
500.000 |
0 |
0 |
0 |
0.00 |
0 |
1655312400 |
1726250740 |
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:25;s:9:"box_width";i:15;s:10:"box_height";i:10;} |
|
0 |
|
N |
N |
en |
Tropical Granola, Healthy Snacks, Almond, Maccadamia, Granola, Dried Fruits, No Sugar, No Preservatives, Eat Clean, Natural Ingredients, Mango, Cranberries |
|
|
<p>Are you dieting yet craving for some snacks? You don’t know which snacks are nutritious yet still tasty?</p>
<p>Tropical Granola from Monsieur Luxe will be your answer. This product combines nutritious nuts that are full of vitamins and minerals to help take care of your health. The sweet sour taste of the tropical fruits will add some kick every time you take a bite. With Tropical Granola from Monsieur Luxe, you will have a snack that is both tasty and healthy.</p> |
|
Granola mix from natural and healthy nuts and dried fruits will be the perfect choice for a quick breakfast. Buy now at CHUS. |
, Tropical Granola, Healthy Snacks, Almond, Maccadamia, Granola, Dried Fruits, No Sugar, No Preservatives, Eat Clean, Natural Ingredients, Mango, Cranberries |
Tropical Granola, Monsieur Lux - CHUS |
|
|
<p>- Weight: 250gr</p>
<p>- Ingredient: Almond (USA), macca (Australia), pecan (USA), cashew (Vietnam), sunflower seeds (Mongolia), pumpkin seeds (Mongolia), oats (Australia), black raisin (Chile), cranberries (Canada), mango (Vietnam), apricot (Turkey), cinnamon (Vietnam), raw yellow sugar (Vietnam), cold-press organic coconut oil (Vietnam), water</p> |
<p>- Eat directly, eat with butter, breads, yoghurt, fruits or smoothies</p>
<p>- NO saccharin, NO added flavors, NO colorants</p>
<p>- To preserve, store product under 25°C</p> |
|
|
<p>A breath of fresh air for your light dishes. A more delicious, cool and special taste, making you unable to refuse.</p> |
<p>Monsieur Luxe by We Food is an organic brand from Vietnam that provides plant-based food that is good for health, is eco-friendly and full of nutrients.</p>
<p>Monsieur Luxe’s products are designed to help add vital nutrients and energy through products that are completely natural. At Monsieur Luxe they believe that Only by changing daily eating habits, one can achieve a healthier mind and body, contributing to a better world.</p>
<p>Monsieur Luxe products are produced in a closed production with high technology that is of HACCP standard. Some of the nuts and dried fruits are imported from farms in America and Australia, ensuring the quality of the ingredients.</p> |
a:4:{s:17:"rs_brand_producer";a:5:{i:0;s:25:"Healthy plant-based foods";i:1;s:21:"Sustainable packaging";i:2;s:63:"Ingredients imported from certified farms in America, Australia";i:3;s:33:"A wide range of products to offer";i:4;s:73:"Helping customers achieve healthier mind and bodies via plant-based foods";}s:14:"rs_ingredients";a:5:{i:0;s:25:"Nuts, seeds, dried fruits";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:62:"A modern closed technology, ensuring food cleanliness/ safety.";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:47:"Production with ISO 22000:2018 & HACCP standard";i:1;s:0:"";i:2;s:0:"";i:3;s:0:"";i:4;s:0:"";}} |
|
|
1 |
149000.0000 |
112M,112M,112M,112M |
445M,452,462,485 |
8060 |
MONSIEUR LUXE - Wefood |
1 |
tropical-granola |
95/112 |
D |
4.95 |
21 |
2 |