Query time 0.04471
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": 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')"
}
},
{
"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 = 5958 and point_prices.lower_limit = 1 and point_prices.usergroup_id in (0,0,1)"
},
"buffer_type": "flat",
"buffer_size": "125Kb",
"join_type": "BNL",
"attached_condition": "trigcond(1) and trigcond(point_prices.product_id = 5958 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 = 5958"
},
"buffer_type": "flat",
"buffer_size": "53Kb",
"join_type": "BNL",
"attached_condition": "trigcond(ps.product_id = 5958)",
"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 |
| 5958 |
10430_001D |
P |
A |
389 |
0 |
999 |
1000.000 |
0 |
0 |
0 |
0.00 |
0 |
1655312400 |
1726252651 |
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:55;s:9:"box_width";i:55;s:10:"box_height";i:10;} |
|
0 |
|
N |
N |
en |
Model C250.P5, Calligraphy Printed Sail, Lucky Boat Model Wall Frame |
|
|
<p>With a unique ash wood round frame, the product will be a nice decoration that can level up the space.</p>
<p>There are familiar calligraphy inscriptions often used to attract fortune on the sails. It will be a suitable gift to give to your Vietnamese or Asian business partners or clients, expressing the wish that they achieve success in their work. Of course, you can choose your own design to print on the sail according to your preference.</p> |
|
|
, Model C250.P5, Calligraphy Printed Sail, Lucky Boat Model Wall Frame |
|
|
|
<p>- Size: 46 x 46 x 6cm</p>
<p>- Weight: 800g</p>
<p>- Materials: Composite, ash wood, art silk</p> |
|
Wall Frame | Boat Model | Decorative Item | Lucky Decoration | Gift Ideas |
<p>The calligraphy is printed in Vietnamese:</p>
<p>1. Phát (Prosperity)</p>
<p>2. Lộc (Fortune)</p>
<p>3. Tín (Trust)</p>
<p>4. Thuận (Smoothness)</p>
<p>5. Thành (Success)</p>
<p>6. Tâm (Sincerity)</p>
<p>7. Bình An (Peace)</p> |
<p>Round in shape and carrying a rustic brown color, the frame can bring an elegant look to the space with minimal effort. It is suitable to be put in an office, living room or reception room.</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 |
1350000.0000 |
191M,191M,191M,191M |
467M,433,444,450 |
12672 |
HAHAWAVE |
|
model-c250.p5-calligraphy-printed-sail-lucky-boat-model-wall-frame |
105/191 |
|
D |
5.00 |
1 |
|