Query time 0.00021
JSON explain
{
"query_block": {
"select_id": 1,
"cost_info": {
"query_cost": "1.00"
},
"nested_loop": [
{
"table": {
"table_name": "cscart_product_feature_variants",
"access_type": "const",
"possible_keys": [
"PRIMARY"
],
"key": "PRIMARY",
"used_key_parts": [
"variant_id"
],
"key_length": "3",
"ref": [
"const"
],
"rows_examined_per_scan": 1,
"rows_produced_per_join": 1,
"filtered": "100.00",
"cost_info": {
"read_cost": "0.00",
"eval_cost": "0.20",
"prefix_cost": "0.00",
"data_read_per_join": "1K"
},
"used_columns": [
"variant_id",
"feature_id",
"url",
"color",
"position"
]
}
},
{
"table": {
"table_name": "cscart_product_feature_variant_descriptions",
"access_type": "const",
"possible_keys": [
"PRIMARY"
],
"key": "PRIMARY",
"used_key_parts": [
"variant_id",
"lang_code"
],
"key_length": "9",
"ref": [
"const",
"const"
],
"rows_examined_per_scan": 1,
"rows_produced_per_join": 1,
"filtered": "100.00",
"cost_info": {
"read_cost": "0.00",
"eval_cost": "0.20",
"prefix_cost": "0.00",
"data_read_per_join": "3K"
},
"used_columns": [
"variant_id",
"variant",
"description",
"page_title",
"meta_keywords",
"meta_description",
"lang_code"
]
}
}
]
}
}
Result
| variant_id |
feature_id |
url |
color |
position |
variant |
description |
page_title |
meta_keywords |
meta_description |
lang_code |
| 110 |
18 |
|
|
0 |
Nokia |
<p><p><b>Nokia Corporation</b> is a Finnish multinational communications and information technology corporation (originally a paper production plant) that is headquartered in Helsinki, Finland. Its principal products are mobile telephones and portable IT devices. It also offers Internet services including applications, games, music, media and messaging, and free-of-charge digital map information and navigation services through its wholly owned subsidiary Navteq. Nokia has a joint venture with Siemens, Nokia Siemens Networks, which provides telecommunications network equipment and services.</p>
<p>Nokia has around 101,982 employees across 120 countries, sales in
more than 150 countries and annual revenues of around €30 billion. It is the world's second-largest mobile phone maker by 2012 unit sales (after Samsung), with a global market share of 22.5% in the first quarter of that year. Nokia is a public limited-liability company listed on the Helsinki Stock Exchange and New York Stock Exchange. It is the world's 143rd-largest company measured by 2011 revenues according to the <i>Fortune Global 500</i>.</p>
<p>Nokia was the world's largest vendor of mobile phones from 1998 to 2012.
However, over the past five years it has suffered a declining market
share as a result of the growing use of smartphones from other vendors,
principally the Apple iPhone and devices running on Google's Android operating system. As a result, its share price has fallen from a high of US$40 in late 2007 to under US$2 in mid-2012. Since February 2011, Nokia has had a strategic partnership with Microsoft, as part of which all Nokia smartphones will incorporate Microsoft's Windows Phone operating system (replacing Symbian). Since then previously increasing smartphone sales have been collapsing and the previously profitable smart devices business unit went loss-making.</p><br></p> |
|
|
|
es |