Query time 0.00161
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 = 229565 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": 4,
"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 |
229565 |
D20F41EB-49B3-41EB-9A6F-853E5DC9E9C2 |
P |
A |
|
1 |
0.00 |
50 |
3061.746 |
0 |
0 |
0 |
27.47 |
0 |
1616231375 |
1616231375 |
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 |
Chantal Induction 21 Stainles Steel 5 qt. Sauteuse with Glas lid |
|
|
Made from Unique Jampanese Steel, which includes copper and titanium, this cookware is nickel fee. This cookware heats evenly and can be used on all stovetops including magnetic induction. ID21 is has dripless pouring rim, ergonomic handles that are cool to the touch on most stovetops and glass lids, dishwasher safe. Oven safe to 425 degree with lid. |
|
|
Makeup Removers,Petroleum Jelly,Self Tanner,Women's Sweatshirts & Hoodies |
|
|
|
|
|
|
|
111.490000 |
350M,351,352,449 |
105 |
Simtech |
|
chantal-induction-21-stainles-steel-5-qt.-sauteuse-with-glas-lid |
2779/350 |
D |