Query time 0.00202
JSON explain
{
"query_block": {
"select_id": 1,
"cost_info": {
"query_cost": "3.34"
},
"grouping_operation": {
"using_filesort": false,
"nested_loop": [
{
"table": {
"table_name": "cscart_products",
"access_type": "const",
"possible_keys": [
"PRIMARY",
"status"
],
"key": "PRIMARY",
"used_key_parts": [
"product_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": "4K"
},
"used_columns": [
"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",
"facebook_obj_type",
"parent_product_id",
"buy_now_url",
"units_in_product",
"show_price_per_x_units",
"is_mobilede",
"seller_id",
"mdc_product_id"
]
}
},
{
"table": {
"table_name": "popularity",
"access_type": "const",
"possible_keys": [
"PRIMARY",
"total"
],
"key": "PRIMARY",
"used_key_parts": [
"product_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": "32"
},
"used_columns": [
"product_id",
"total"
]
}
},
{
"table": {
"table_name": "cscart_product_sales",
"access_type": "const",
"possible_keys": [
"PRIMARY",
"pa"
],
"key": "PRIMARY",
"used_key_parts": [
"category_id",
"product_id"
],
"key_length": "6",
"ref": [
"const",
"const"
],
"rows_examined_per_scan": 0,
"rows_produced_per_join": 1,
"filtered": "0.00",
"unique_row_not_found": true,
"cost_info": {
"read_cost": "0.00",
"eval_cost": "0.20",
"prefix_cost": "0.00",
"data_read_per_join": "16"
},
"used_columns": [
"category_id",
"product_id",
"amount"
]
}
},
{
"table": {
"table_name": "cscart_product_prices",
"access_type": "ref",
"possible_keys": [
"usergroup",
"product_id",
"lower_limit",
"usergroup_id"
],
"key": "product_id",
"used_key_parts": [
"product_id"
],
"key_length": "3",
"ref": [
"const"
],
"rows_examined_per_scan": 1,
"rows_produced_per_join": 1,
"filtered": "100.00",
"cost_info": {
"read_cost": "1.00",
"eval_cost": "0.20",
"prefix_cost": "1.20",
"data_read_per_join": "24"
},
"used_columns": [
"product_id",
"price",
"percentage_discount",
"lower_limit",
"usergroup_id"
],
"attached_condition": "<if>(is_not_null_compl(cscart_product_prices), ((`danishecarter_latest`.`cscart_product_prices`.`lower_limit` = 1) and (`danishecarter_latest`.`cscart_product_prices`.`usergroup_id` in (0,0,1))), true)"
}
},
{
"table": {
"table_name": "cscart_product_descriptions",
"access_type": "const",
"possible_keys": [
"PRIMARY",
"product_id"
],
"key": "PRIMARY",
"used_key_parts": [
"product_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": "1.40",
"data_read_per_join": "4K"
},
"used_columns": [
"product_id",
"lang_code",
"product",
"shortname",
"short_description",
"full_description",
"meta_keywords",
"meta_description",
"search_words",
"page_title",
"age_warning_message",
"promo_text",
"unit_name"
]
}
},
{
"table": {
"table_name": "company_descr",
"access_type": "const",
"possible_keys": [
"PRIMARY"
],
"key": "PRIMARY",
"used_key_parts": [
"company_id",
"lang_code"
],
"key_length": "10",
"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": "1.60",
"data_read_per_join": "1K"
},
"used_columns": [
"company_id",
"lang_code",
"i18n_company"
]
}
},
{
"table": {
"table_name": "companies",
"access_type": "const",
"possible_keys": [
"PRIMARY"
],
"key": "PRIMARY",
"used_key_parts": [
"company_id"
],
"key_length": "4",
"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": "1.80",
"data_read_per_join": "7K"
},
"used_columns": [
"company_id",
"status"
],
"attached_condition": "<if>(found_match(companies), ((`danishecarter_latest`.`companies`.`status` = 'A') or 0), true)"
}
},
{
"table": {
"table_name": "cscart_products_categories",
"access_type": "ref",
"possible_keys": [
"PRIMARY",
"pt"
],
"key": "pt",
"used_key_parts": [
"product_id"
],
"key_length": "3",
"ref": [
"const"
],
"rows_examined_per_scan": 1,
"rows_produced_per_join": 1,
"filtered": "100.00",
"cost_info": {
"read_cost": "1.00",
"eval_cost": "0.20",
"prefix_cost": "3.00",
"data_read_per_join": "16"
},
"used_columns": [
"product_id",
"category_id",
"link_type",
"category_position"
]
}
},
{
"table": {
"table_name": "cscart_categories",
"access_type": "eq_ref",
"possible_keys": [
"PRIMARY",
"c_status",
"p_category_id"
],
"key": "PRIMARY",
"used_key_parts": [
"category_id"
],
"key_length": "3",
"ref": [
"danishecarter_latest.cscart_products_categories.category_id"
],
"rows_examined_per_scan": 1,
"rows_produced_per_join": 0,
"filtered": "5.00",
"cost_info": {
"read_cost": "0.00",
"eval_cost": "0.01",
"prefix_cost": "3.20",
"data_read_per_join": "172"
},
"used_columns": [
"category_id",
"storefront_id",
"usergroup_ids",
"status"
],
"attached_condition": "((`danishecarter_latest`.`cscart_categories`.`storefront_id` in (0,1)) and ((`danishecarter_latest`.`cscart_categories`.`usergroup_ids` = '') or find_in_set(0,`danishecarter_latest`.`cscart_categories`.`usergroup_ids`) or find_in_set(1,`danishecarter_latest`.`cscart_categories`.`usergroup_ids`)) and (`danishecarter_latest`.`cscart_categories`.`status` in ('A','H')))"
}
},
{
"table": {
"table_name": "cscart_seo_names",
"access_type": "ref",
"possible_keys": [
"PRIMARY",
"dispatch"
],
"key": "PRIMARY",
"used_key_parts": [
"object_id",
"type",
"dispatch",
"lang_code"
],
"key_length": "206",
"ref": [
"const",
"const",
"const",
"const"
],
"rows_examined_per_scan": 1,
"rows_produced_per_join": 0,
"filtered": "100.00",
"cost_info": {
"read_cost": "0.05",
"eval_cost": "0.01",
"prefix_cost": "3.26",
"data_read_per_join": "86"
},
"used_columns": [
"name",
"object_id",
"type",
"dispatch",
"path",
"lang_code"
]
}
},
{
"table": {
"table_name": "point_prices",
"access_type": "range",
"possible_keys": [
"unique_key",
"src_k"
],
"key": "unique_key",
"used_key_parts": [
"lower_limit",
"usergroup_id",
"product_id"
],
"key_length": "8",
"rows_examined_per_scan": 2,
"rows_produced_per_join": 0,
"filtered": "100.00",
"using_join_buffer": "Block Nested Loop",
"cost_info": {
"read_cost": "0.05",
"eval_cost": "0.01",
"prefix_cost": "3.32",
"data_read_per_join": "1"
},
"used_columns": [
"product_id",
"point_price",
"lower_limit",
"usergroup_id"
],
"attached_condition": "(<if>(found_match(point_prices), 1, true) and <if>(is_not_null_compl(point_prices), ((`danishecarter_latest`.`point_prices`.`lower_limit` = 1) and (`danishecarter_latest`.`point_prices`.`product_id` = 229) and (`danishecarter_latest`.`point_prices`.`usergroup_id` in (0,0,1))), true))"
}
},
{
"table": {
"table_name": "cscart_discussion",
"access_type": "const",
"possible_keys": [
"object_id"
],
"key": "object_id",
"used_key_parts": [
"object_id",
"object_type"
],
"key_length": "6",
"ref": [
"const",
"const"
],
"rows_examined_per_scan": 1,
"rows_produced_per_join": 0,
"filtered": "100.00",
"cost_info": {
"read_cost": "0.00",
"eval_cost": "0.01",
"prefix_cost": "3.33",
"data_read_per_join": "1"
},
"used_columns": [
"object_id",
"object_type",
"type"
]
}
},
{
"table": {
"table_name": "cscart_product_review_prepared_data",
"access_type": "const",
"possible_keys": [
"PRIMARY"
],
"key": "PRIMARY",
"used_key_parts": [
"product_id",
"storefront_id"
],
"key_length": "7",
"ref": [
"const",
"const"
],
"rows_examined_per_scan": 1,
"rows_produced_per_join": 0,
"filtered": "100.00",
"cost_info": {
"read_cost": "0.00",
"eval_cost": "0.01",
"prefix_cost": "3.34",
"data_read_per_join": "0"
},
"used_columns": [
"product_id",
"storefront_id",
"average_rating",
"reviews_count"
]
}
}
]
}
}
}
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 |
facebook_obj_type |
parent_product_id |
buy_now_url |
units_in_product |
show_price_per_x_units |
is_mobilede |
seller_id |
mdc_product_id |
lang_code |
product |
shortname |
short_description |
full_description |
meta_keywords |
meta_description |
search_words |
page_title |
age_warning_message |
promo_text |
unit_name |
price |
category_ids |
popularity |
company_name |
sales_amount |
seo_name |
seo_path |
point_price |
discussion_type |
average_rating |
product_reviews_count |
| 229 |
V0229W5J8F |
P |
A |
1 |
0.00 |
15 |
0.000 |
0 |
0 |
0 |
0.00 |
0 |
1328731200 |
1328786767 |
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;} |
|
0 |
|
0.000 |
1.000 |
N |
0 |
0 |
en |
HP 2711x 27" LED Monitor |
|
|
<p>
<div style="color: #000000; font-family: Arial, Verdana, Helvetica, sans-serif; font-size: 12px; background-color: #ffffff; padding-left: 10px; padding-right: 10px; padding-bottom: 10px;">Maximize your home PC experience with our 2711x 27" LED Monitor. You'll enjoy movies, photos, on-line<sup style="font-size: 0.8em;">1</sup>games, and streamed shows on your PC in brilliant color on this ultra-slim, energy-saving monitor.</div>
<div class="fl" style="color: #000000; font-family: Arial, Verdana, Helvetica, sans-serif; font-size: 12px; background-color: #ffffff;">
<p style="margin-top: 0px; margin-right: 0px; margin-bottom: 10px; margin-left: 0px;"><img style="border-style: initial; border-color: initial; padding: 0px; margin: 0px;" src="http://hpshopping.speedera.net/www.shopping.hp.com/shopping/images/overview/xp600aa_front_facing_left_cut.jpg" alt="HP 2711x 27" /></p>
</div>
<div class="col59pctL" style="color: #000000; font-family: Arial, Verdana, Helvetica, sans-serif; font-size: 12px; background-color: #ffffff; padding-left: 10px; padding-bottom: 10px;">
<h3 class="cb large mb5" style="font-size: 14px; margin-bottom: 5px; margin-top: 1px; clear: both;">Superior technology</h3>
<ul style="margin-top: 0px; margin-bottom: 10px; margin-left: 20px; padding: 0px;">
<li><strong>Go ultra-slim:</strong>LED backlighting reduces the number and overall size of the components</li>
<li><strong>See the detail:</strong>get deep blacks, brilliant color, and clarity with the ultra-high dynamic<a class="dotline" style="color: #003366; border-bottom-width: 1px; border-bottom-style: dashed; border-bottom-color: #003366; cursor: default;">contrast ratio</a></li>
<li><strong>Switch on/off</strong>faster than with a CCFL (standard) monitor</li>
</ul>
</div>
<div class="fl" style="float: left; color: #000000; font-family: Arial, Verdana, Helvetica, sans-serif; font-size: 12px; background-color: #ffffff; padding-left: 10px; padding-bottom: 10px;">
<h3 class="cb large mb5" style="font-size: 14px; margin-bottom: 5px; margin-top: 1px; clear: both;">Spacious and spectacular</h3>
<ul style="margin-top: 0px; margin-bottom: 10px; margin-left: 20px; padding: 0px;">
<li><strong>Expand your view</strong>of Web pages, videos, and documents; see two application Windows at once on the 27" LED screen</li>
<li><strong>Immerse yourself</strong>in cinema-like movies and realistic on-line gaming with the Full HD<sup style="font-size: 0.8em;">2</sup>1920 x 1080 resolution</li>
<li><strong>Minimize blur</strong>in sports broadcasts, action movies, and on-line games with the 5 ms on/off response time</li>
<li><strong>Reduce glare</strong>and sharpen images with the BrightView technology</li>
</ul>
</div>
<div class="fr" style="float: right; color: #000000; font-family: Arial, Verdana, Helvetica, sans-serif; font-size: 12px; background-color: #ffffff; padding-bottom: 10px;">
<p style="margin-top: 0px; margin-right: 0px; margin-bottom: 10px; margin-left: 0px;"><img style="border-style: initial; border-color: initial; padding: 0px; margin: 0px;" src="http://hpshopping.speedera.net/www.shopping.hp.com/shopping/images/overview/BrightView_1.jpg" alt="HP 2711x 27" /></p>
</div>
<div class="fl" style="color: #000000; font-family: Arial, Verdana, Helvetica, sans-serif; font-size: 12px; background-color: #ffffff;">
<p style="margin-top: 0px; margin-right: 0px; margin-bottom: 10px; margin-left: 0px;"><img style="border-style: initial; border-color: initial; padding: 0px; margin: 0px;" src="http://hpshopping.speedera.net/www.shopping.hp.com/shopping/images/overview/xp600aa_side_view.jpg" alt="HP 2711x 27" /></p>
</div>
<div class="col59pctL" style="color: #000000; font-family: Arial, Verdana, Helvetica, sans-serif; font-size: 12px; background-color: #ffffff; padding-left: 10px; padding-bottom: 10px;">
<h3 class="cb large mb5" style="font-size: 14px; margin-bottom: 5px; margin-top: 1px; clear: both;">Sleek design, enhanced features</h3>
<ul style="margin-top: 0px; margin-bottom: 10px; margin-left: 20px; padding: 0px;">
<li><strong>Save space</strong>and complement your HP desktop or laptop PC with the stylish, ultra-slim design (about 1" deep)</li>
<li><strong>Connect</strong>to your HP desktop or laptop via VGA, HDCP-supported<a class="dotline" style="color: #003366; border-bottom-width: 1px; border-bottom-style: dashed; border-bottom-color: #003366; cursor: default;">HDMI</a>, or DVI-D input</li>
<li><strong>Find the best</strong>viewing position with the tilt adjustment and ability to slide from left to right</li>
</ul>
</div>
<div class="fl" style="color: #000000; font-family: Arial, Verdana, Helvetica, sans-serif; font-size: 12px; background-color: #ffffff; padding-left: 10px; padding-bottom: 10px;">
<h3 class="cb large mb5" style="font-size: 14px; margin-bottom: 5px; margin-top: 1px; clear: both;">Eco highlights</h3>
<ul style="margin-top: 0px; margin-bottom: 10px; margin-left: 20px; padding: 0px;">
<li><strong>Help protect the environment:</strong>this model is ENERGY STAR<sup style="font-size: 0.8em;">®</sup>5.0 qualified and EPEAT Silver registered</li>
<li><strong>Lower your impact</strong>on the environment with the mercury-free LED backlighting</li>
<li><strong>Be eco-conscious</strong>with the arsenic-free display glass<sup style="font-size: 0.8em;">3</sup>, recyclable plastic parts, and recyclable packaging</li>
</ul>
</div>
<div class="fr" style="color: #000000; font-family: Arial, Verdana, Helvetica, sans-serif; font-size: 12px; background-color: #ffffff; padding-bottom: 10px;">
<p style="margin-top: 0px; margin-right: 0px; margin-bottom: 10px; margin-left: 0px;"><img style="border-style: initial; border-color: initial; padding: 0px; margin: 0px;" src="http://hpshopping.speedera.net/www.shopping.hp.com/shopping/images/overview/xp600aa_right_facing.jpg" alt="HP 2711x 27" /></p>
</div>
<div style="color: #000000; font-family: Arial, Verdana, Helvetica, sans-serif; font-size: 12px; background-color: #ffffff; padding-left: 10px; padding-right: 10px;">
<h3 class="cb large mb5" style="font-size: 14px; margin-bottom: 5px; margin-top: 1px; clear: both;">First-class warranty and support</h3>
<ul style="margin-top: 0px; margin-bottom: 10px; margin-left: 20px; padding: 0px;">
<li><strong>Get peace of mind</strong>with the one-year limited warranty plus real-time chat and e-mail response in about an hour</li>
<li><strong>Find answers</strong>to product questions online, 24 x 7, at our Consumer Support Forum, hp.com/support/consumer-forum</li>
</ul>
</div>
<div class="p10" style="color: #000000; font-family: Arial, Verdana, Helvetica, sans-serif; font-size: 12px; background-color: #ffffff; padding: 10px;">
<p class="tinygray" style="margin-top: 0px; margin-right: 0px; margin-bottom: 10px; margin-left: 0px; color: #666666; font-size: 10px;">1. Internet access required, sold separately.<br />2. HD content required to view HD images.<br />3. Arsenic and its compounds were not detected using US EPA Test Methods 3052 and 3052/6010b by ICP or ICP-AES.</p>
</div>
<div class="p10" style="color: #000000; font-family: Arial, Verdana, Helvetica, sans-serif; font-size: 12px; background-color: #ffffff; padding: 10px;">
<h2 class="theme_ruled" style="font-size: small; margin-bottom: 0px; margin-top: 1px; border-bottom-width: 4px; border-bottom-style: solid; padding-bottom: 1px; border-color: #000000;">What's in the box?</h2>
<p class="fl mt10 mr10" style="margin-top: 10px; margin-right: 10px; margin-bottom: 10px; margin-left: 0px; float: left;"><img style="border-style: initial; border-color: initial; display: inline; padding: 0px; margin: 0px;" longdesc="http://www.shopping.hp.com/product/display/display/1/storefronts/XP600AA%2523ABA" src="http://hpshopping.speedera.net/www.shopping.hp.com/shopping/images/products/xp600aa_150.gif" border="0" alt="HP 2711x 27" LED Monitor" width="150" height="100" /></p>
</div>
</p>
<table border="0" cellspacing="0" cellpadding="0" width="100%">
<tbody>
<tr>
<td width="10" valign="top">•</td>
<td>Monitor</td>
</tr>
<tr>
<td width="10" valign="top">•</td>
<td>External power supply</td>
</tr>
<tr>
<td width="10" valign="top">•</td>
<td>Power cable</td>
</tr>
<tr>
<td width="10" valign="top">•</td>
<td>VGA cable</td>
</tr>
<tr>
<td width="10" valign="top">•</td>
<td>DVI-D cable</td>
</tr>
<tr>
<td width="10" valign="top">•</td>
<td>Cable clip management</td>
</tr>
<tr>
<td width="10" valign="top">•</td>
<td>CD with instructions</td>
</tr>
<tr>
<td width="10" valign="top">•</td>
<td>Warranty card</td>
</tr>
</tbody>
</table> |
|
|
|
|
|
<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> |
|
299.99000000 |
170M |
30 |
CS-Cart |
|
hp-2711x-27-led-monitor |
167/170 |
|
|
|
|