Query time 0.02591
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": 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_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": 13,
"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')"
}
},
{
"block-nl-join": {
"table": {
"table_name": "point_prices",
"access_type": "range",
"possible_keys": ["unique_key", "src_k"],
"key": "unique_key",
"key_length": "8",
"used_key_parts": ["lower_limit", "usergroup_id", "product_id"],
"rows": 1,
"filtered": 100,
"attached_condition": "point_prices.product_id = 5474 and point_prices.lower_limit = 1 and point_prices.usergroup_id in (0,0,1)"
},
"buffer_type": "flat",
"buffer_size": "255Kb",
"join_type": "BNL",
"attached_condition": "trigcond(1) and trigcond(point_prices.product_id = 5474 and point_prices.lower_limit = 1 and point_prices.usergroup_id in (0,0,1))"
}
},
{
"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": 12918,
"filtered": 100,
"attached_condition": "ps.product_id = 5474"
},
"buffer_type": "flat",
"buffer_size": "126Kb",
"join_type": "BNL",
"attached_condition": "trigcond(ps.product_id = 5474)",
"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 |
| 5474 |
10430_6A68 |
P |
A |
389 |
0 |
999 |
3000.000 |
0 |
0 |
0 |
0.00 |
0 |
1655312400 |
1726252646 |
0 |
N |
N |
N |
B |
N |
|
N |
N |
N |
Y |
10 |
Y |
1 - 3 |
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:45;s:9:"box_width";i:20;s:10:"box_height";i:50;} |
|
0 |
|
N |
N |
en |
Lucky Sailboat Model C300.T8 With Acrylic Stand & Art Silk Sail |
|
|
<p>This Lucky C300.T8 sailboat model is designed with a premium touch. The sails carry positive messages to encourage the owner to be more motivated in life.</p>
<p>When in doubt, its messages will play a part in bringing more peace and certainty like a friend. It also makes a nice decoration thanks to the premium material of composite, which is used to make real yachts.</p> |
|
|
, Lucky Sailboat Model C300.T8 With Acrylic Stand & Art Silk Sail |
|
|
|
<p>- Size: 31 x 14.6 x 41cm</p>
<p>- Weight: 1000g</p>
<p>- Materials: Composite, ash wood, art silk, plexiglass</p> |
|
Boat Model | Decorative Item | Lucky Decoration | Stationery | Gift Ideas |
<p>1. Swimmingly</p>
<p>2. Never give up</p>
<p>3. Overcome obstacles</p>
<p>4. Just do it. You can do it.</p>
<p>5. Keep dreaming. Keep working.</p> |
<p>The sailboat comes in an appropriate size of 31 cm and is suitable to be put on desks or small shelves. The solid wood stand is carved with pen holders and a name card slot, which will help your desk look neat and beautiful.</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:{}} |
|
Please fill in the box below if you want to have your customized design or messages on the sail. |
1 |
1280000.0000 |
191M,191M,191M,191M,191M,191M,191M,191M,191M,191M,191M,191M,191M |
416M,433,434,437,444,445,450,467,503,504,512,518,519 |
6489 |
HAHAWAVE |
|
lucky-sailboat-model-c300.t8-with-acrylic-stand-and-art-silk-sail |
105/191 |
|
D |
|
0 |
|