Query time 0.00191
JSON explain
{
"query_block": {
"select_id": 1,
"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": "range",
"possible_keys": ["usergroup", "product_id", "lower_limit", "usergroup_id"],
"key": "product_id",
"key_length": "9",
"used_key_parts": ["product_id", "usergroup_id", "lower_limit"],
"rowid_filter": {
"range": {
"key": "lower_limit",
"used_key_parts": ["lower_limit", "product_id", "usergroup_id"]
},
"rows": 2,
"selectivity_pct": 5.160158e-4
},
"rows": 2,
"filtered": 100,
"attached_condition": "trigcond(1) and trigcond(cscart_product_prices.product_id = 223406 and 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": "product_id",
"key_length": "9",
"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": 3,
"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": ["staging2_wesave_com.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')"
},
"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')"
}
}
}
Result
product_id |
product_code |
product_type |
status |
old_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 |
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 |
master_product_id |
master_product_status |
master_product_offers_count |
ab__stickers_manual_ids |
ab__stickers_generated_ids |
enable_store_pickup |
store_pickup_only |
ebay_template_id |
product_hash |
ebay_price |
package_type |
ebay_status |
ebay_override_price |
vendor_product |
override_commission |
product_commission |
product_commission_fee |
affiliate_products |
amz_asin |
amz_sku |
amz_ean |
amz_upc |
amz_isbn |
amz_item_type |
amz_condition |
amz_condition_note |
amz_browse_node |
amz_price |
amz_item_is_marketplace |
amz_override_price |
amz_synchronization |
has_video |
avatax_code |
GPItemNumber |
is_stock_split_by_warehouses |
spo_vendor |
is_equity |
alt_video_id |
alt_video_filename |
alt_video_preload_filename |
lang_code |
product |
shortname |
short_description |
full_description |
meta_keywords |
meta_description |
search_words |
page_title |
age_warning_message |
promo_text |
return_policy |
ebay_title |
ebay_description |
override |
price |
category_ids |
popularity |
company_name |
sales_amount |
seo_name |
seo_path |
discussion_type |
223406 |
EE00E9EC-F078-4D2A-BD54-43A437263D50 |
P |
A |
|
19 |
0.00 |
50 |
2721.552 |
0 |
0 |
0 |
26.82 |
0 |
1616085407 |
1616085407 |
0 |
N |
N |
N |
O |
N |
|
N |
N |
N |
Y |
10 |
0 |
N |
|
|
|
|
2 |
|
N |
0 |
|
|
|
a:5:{s:16:"min_items_in_box";i:0;s:16:"max_items_in_box";i:0;s:10:"box_length";i:0;s:9:"box_width";i:0;s:10:"box_height";i:0;} |
|
0 |
|
0 |
A |
0 |
|
|
N |
N |
0 |
|
|
Letter |
|
N |
N |
no |
|
|
0 |
|
|
|
|
|
|
|
|
|
|
N |
N |
Y |
N |
|
|
N |
|
Y |
0 |
|
|
en |
Pagod Vase beige, large |
|
|
Pagod is a stylish vase that brings you back to the 60's. The vase is mouth-blown by skilled glass blowers at the glass works in Kosta. The technique is called underlay, a multi-layer glass which means that clear glass lies like a casing over the stained glass and gives a beautiful and processed expression. The playful design is the work of Anne Nilsson. She is one of Sweden's most important glass designers and can take advantage of the craftmanship, the simple language and function in an extremely elegant way. |
|
|
Women's Skirt Suits |
|
|
|
|
|
|
|
168.650000 |
436 |
66 |
Source 4 Shopping |
|
pagod-vase-beige-large |
2779/475 |
D |