Query time 0.00027
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 |
| 104 |
18 |
|
|
0 |
Cobra |
<p></p><p>
Cobra Electronics Corporation is a leading designer of mobile
communications products in the United States, Canada, Europe and around
the world. After 50 years of innovation, the company continues to grow
by boldly entering into new product categories.</p>
<p>
Today the company's products include:</p>
<ul><li>
Mobile navigation devices</li><li>
Two-way radios</li><li>
Radar/laser detectors</li><li>
Citizens band radios</li><li>
Marine electronics</li><li>
Power inverters</li></ul>
<p>
Cobra products are available in nearly 40,000 storefronts in North
America and in a growing number of retailers throughout the world.</p>
<p>
Cobra has a significant presence in Europe through Performance Products
Limited, a United Kingdom-based wholly owned subsidiary with a
well-established network of mass merchandisers and specialty retailers.</p>
<p>
Cobra is headquartered in Chicago, Illinois with international offices in Dublin, Ireland and Hong Kong.</p><br><p></p>
|
|
|
|
en |