Query time 0.00148
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 = 229811 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 |
229811 |
FA078387-DE9C-4443-9F02-184021886B99 |
P |
A |
|
1 |
0.00 |
50 |
907.184 |
0 |
0 |
0 |
46.20 |
0 |
1616231734 |
1616231734 |
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 |
Double Diamond Earrings in 14k Yellow Gold with 24 rd br diamonds--.25 ct tw. |
|
|
Our Antwerp Double Diamond Earrings maintain a look of classic elegance while also being an ideal fashion piece. This pair is made in 14kt yellow gold and made up of 24 round brilliant cut diamonds totaling .25 carat. stunning diamond shaped classically matches the ears. Each diamond is hand-set by our master craftsman. Diamonds are hand-picked in Antwerp, Belgium- the diamond capital of the world. |
|
|
Hand Sanitizers & Wipes,Lotion & Moisturizer,Women's Activewear Tops |
|
|
|
|
|
|
|
556.330000 |
405M,280,349 |
90 |
Simtech |
|
double-diamond-earrings-in-14k-yellow-gold-with-24-rd-br-diamonds-.25-ct-tw. |
2780/405 |
D |