Query time 0.02988
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": 10,
"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 = 4357"
},
"buffer_type": "flat",
"buffer_size": "244Kb",
"join_type": "BNL",
"attached_condition": "trigcond(ps.product_id = 4357)",
"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 |
| 4357 |
10430_6AB2 |
P |
A |
389 |
0 |
999 |
1000.000 |
0 |
0 |
0 |
0.00 |
0 |
1655312400 |
1726252638 |
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:40;s:9:"box_width";i:15;s:10:"box_height";i:35;} |
|
0 |
|
N |
N |
en |
Lucky Sailboat Model C200.T10 With Calendar |
|
|
<p>Unique in design and versatile in application are what you can find in this Sailboat Model from HAHAWAVE.</p>
<p>The sail are calendar pages for the user to easily keep track of days. Its body is made of composite combined with ash wood with delicate design. In addition, the ship has a built-in pen holder and business card holder that is very convenient. You can use them to store other personal stuff on the desk.</p> |
|
|
, Lucky Sailboat Model C200.T10 With Calendar |
|
|
|
<p>- Size: 22 x 11.5 x 31.5cm</p>
<p>- Weight: 600g</p>
<p>- Materials: Composite, ash wood, Couche paper</p> |
|
Boat Model | Decorative Item | Lucky Decoration | Stationery | Gift Ideas |
|
<p>This is a preferred product at HAHAWAVE thanks to its versatility, convenience, and especially compactness, as it is shorter in length compared to other models. You can keep track of the date with the year calendar, as well as store pens, name cards and your phone in the wooden tray. Being only 22cm, this will easily put onto your desk for decoration without taking too much space.</p> |
<p>Starting with providing maritime services, HAHAWAVE expands its business to decorative furniture with boat models as the main product. The brand name is cleverly abbreviated from the laughing sound “Haha”, which stands for the positive living attitude of the founder, and the word “wave” as it is the field they work in.</p>
<p>Materials used to make the boat models are high-quality composite and solid wood. The composite is also what HAHAWAVE uses to produce their real motorboat. Therefore, not only are the models appealing, they are also very durable. HAHAWAVE is also the leading brand in using such premium materials in producing decoration. With that given, the customers can always rely on the quality of boat models delivered by the brand, as they are made with great meticulousness and enthusiasm.</p>
<p>The boat represents adventures and explorations as how it takes people across the ocean. Therefore, giving a boat model as a gift is a wish for smooth journeys, which means success in life, whether it’s in education, profesion, or any desire of the receivers.</p> |
a:4:{s:17:"rs_brand_producer";a:2:{i:0;s:60:"Designs sailboat models with the meaning of luck and success";i:1;s:54:"Versatile stationery items with high decorative values";}s:14:"rs_ingredients";a:1:{i:0;s:65:"Composite, with natural wood, epoxy, art silk, 300gsmCouche paper";}s:14:"rs_manufacture";a:2:{i:0;s:52:"Polishing technology according to European standards";i:1;s:9:"Epoxy art";}s:17:"rs_certifications";a:0:{}} |
|
|
1 |
660000.0000 |
191M,191M,191M,191M,191M,191M,191M,191M,191M,191M |
512M,433,434,437,444,445,450,467,503,504 |
5352 |
HAHAWAVE |
|
lucky-sailboat-model-c200.t10-with-calendar |
105/191 |
D |
|
0 |
|