Query time 0.00937
JSON explain
{
"query_block": {
"select_id": 1,
"cost": 0.011784126,
"nested_loop": [
{
"table": {
"table_name": "tmall_master_products_storefront_min_price",
"access_type": "system",
"possible_keys": ["PRIMARY"],
"rows": 0,
"filtered": 0,
"const_row_not_found": true
}
},
{
"table": {
"table_name": "tmall_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": "tmall_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": 1,
"filtered": 100,
"unique_row_not_found": true
}
},
{
"table": {
"table_name": "tmall_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,
"unique_row_not_found": true
}
},
{
"table": {
"table_name": "tmall_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,
"unique_row_not_found": true
}
},
{
"table": {
"table_name": "tmall_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"],
"loops": 1,
"rows": 1,
"cost": 0.002024411,
"filtered": 97.28681946,
"attached_condition": "trigcond(tmall_product_prices.lower_limit = 1 and tmall_product_prices.usergroup_id in (0,0,1))"
}
},
{
"table": {
"table_name": "tmall_product_descriptions",
"access_type": "const",
"possible_keys": ["PRIMARY", "product_id"],
"key": "PRIMARY",
"key_length": "9",
"used_key_parts": ["product_id", "lang_code"],
"ref": ["const", "const"],
"loops": 1,
"rows": 1,
"cost": 0.001933826,
"filtered": 100,
"attached_condition": "trigcond(tmall_product_descriptions.lang_code = 'en')"
}
},
{
"table": {
"table_name": "company_descr",
"access_type": "eq_ref",
"possible_keys": ["PRIMARY"],
"key": "PRIMARY",
"key_length": "10",
"used_key_parts": ["company_id", "lang_code"],
"ref": ["const", "const"],
"loops": 1,
"rows": 1,
"cost": 0.001933826,
"filtered": 100,
"attached_condition": "trigcond(company_descr.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"],
"loops": 1,
"rows": 1,
"cost": 0.001933826,
"filtered": 100,
"attached_condition": "trigcond(companies.`status` = 'A')"
}
},
{
"table": {
"table_name": "tmall_products_categories",
"access_type": "ref",
"possible_keys": ["PRIMARY", "pt"],
"key": "pt",
"key_length": "3",
"used_key_parts": ["product_id"],
"ref": ["const"],
"loops": 1,
"rows": 1,
"cost": 0.002024411,
"filtered": 100
}
},
{
"table": {
"table_name": "tmall_categories",
"access_type": "eq_ref",
"possible_keys": ["PRIMARY", "c_status", "p_category_id"],
"key": "PRIMARY",
"key_length": "3",
"used_key_parts": ["category_id"],
"ref": ["tmall.tmall_products_categories.category_id"],
"loops": 1,
"rows": 1,
"cost": 0.001933826,
"filtered": 100,
"attached_condition": "tmall_categories.storefront_id in (0,1) and (tmall_categories.usergroup_ids = '' or find_in_set(0,tmall_categories.usergroup_ids) or find_in_set(1,tmall_categories.usergroup_ids)) and tmall_categories.`status` in ('A','H')"
}
}
]
}
}
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 |
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 |
show_videos_before_images |
autoplay_videos |
parent_product_id |
ab__stickers_manual_ids |
ab__stickers_generated_ids |
master_product_id |
master_product_status |
master_product_offers_count |
lang_code |
product |
shortname |
short_description |
full_description |
meta_keywords |
meta_description |
search_words |
page_title |
age_warning_message |
promo_text |
ab__emd_alternative_name |
price |
category_ids |
popularity |
company_name |
sales_amount |
discussion_type |
average_rating |
product_reviews_count |
| 17 |
G0017HS88V |
P |
A |
1 |
0.00 |
19 |
0.000 |
0 |
0 |
0 |
0.00 |
0 |
1328558400 |
1328684302 |
0 |
N |
N |
N |
|
N |
|
Y |
N |
N |
Y |
10 |
0 |
N |
|
|
|
|
|
6 |
N |
0 |
|
|
default |
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;} |
N |
N |
0 |
|
|
0 |
A |
0 |
en |
101 Things Everyone Should Know About Economics A Down and Dirty Guide to Everything from Securities and Derivatives to Interest Rates and Hedge Funds—And What They Mean For You |
|
|
<p><span style="color: #000000; font-family: Arial, sans-serif; font-size: 12px; background-color: #ffffff;">What you don't know about economics can hurt you—now more than ever. This easy-to-understand guide answers all the questions you need to know to secure your financial future, such as:</span></p>
<ul style="text-align: left; color: #000000; font-size: 12px; background-color: #ffffff;">
<li style="text-align: left;">What does it mean to my paycheck when the Fed lowers or raises interest rates?</li>
<li style="text-align: left;">What's the difference between bonds, securities, and derivatives—and which should I invest in now?</li>
<li style="text-align: left;">What does Keynesian economics have to do with my savings?</li>
</ul>
<p><span style="color: #000000; font-family: Arial, sans-serif; font-size: 12px; background-color: #ffffff;">For those people whose heads spin when reading the business pages of the newspaper, here's a roadmap through the economic jungle. In simple, plain language, Peter Sander explains how economies work, why they grow, how they contract, and what the government can and can't do to help them. Most important, he tells you how all this affects </span><em style="color: #000000; font-family: Arial, sans-serif; font-size: 12px; background-color: #ffffff;">you</em><span style="color: #000000; font-family: Arial, sans-serif; font-size: 12px; background-color: #ffffff;">—and what kind of changes you're going to see in your finances as a result.</span></p>
<p style="text-align: left; color: #000000; font-size: 12px; background-color: #ffffff;">Economics has been called the "dismal" science. But it doesn't need to be gloomy or impenetrable. This book is an essential guide for anyone who wants to understand where the economy is today, where it's going, and what it means for the rest of us.</p>
<p> </p> |
|
|
|
|
|
<p class="product-promo-text"><span class="product-promo-header">FREE US shipping over $100!</span><span class="product-promo-body">Orders within next 2 days will be shipped on Monday</span></p> |
|
11.16000000 |
222M |
24 |
CS-Cart |
|
|
|
|