Query time 0.00143
JSON explain
{
"query_block": {
"select_id": 1,
"cost_info": {
"query_cost": "4.24"
},
"grouping_operation": {
"using_filesort": false,
"nested_loop": [
{
"table": {
"table_name": "point_prices",
"access_type": "system",
"possible_keys": [
"unique_key",
"src_k"
],
"rows_examined_per_scan": 0,
"rows_produced_per_join": 1,
"filtered": "0.00",
"const_row_not_found": true,
"cost_info": {
"read_cost": "0.00",
"eval_cost": "0.20",
"prefix_cost": "0.00",
"data_read_per_join": "24"
},
"used_columns": [
"product_id",
"point_price",
"lower_limit",
"usergroup_id"
]
}
},
{
"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"
]
}
},
{
"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), ((`atulecarter_atul_demo5`.`cscart_product_prices`.`lower_limit` = 1) and (`atulecarter_atul_demo5`.`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": "shared_prices",
"access_type": "ref",
"possible_keys": [
"usergroup",
"product_id",
"company_id",
"lower_limit",
"usergroup_id"
],
"key": "usergroup",
"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": "2.60",
"data_read_per_join": "32"
},
"used_columns": [
"product_id",
"price",
"percentage_discount",
"lower_limit",
"company_id",
"usergroup_id"
],
"attached_condition": "<if>(is_not_null_compl(shared_prices), ((`atulecarter_atul_demo5`.`shared_prices`.`lower_limit` = 1) and (`atulecarter_atul_demo5`.`shared_prices`.`company_id` = 1) and (`atulecarter_atul_demo5`.`shared_prices`.`usergroup_id` in (0,0,1))), true)"
}
},
{
"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": "2.80",
"data_read_per_join": "5K"
},
"used_columns": [
"company_id",
"status",
"company"
],
"attached_condition": "<if>(found_match(companies), ((`atulecarter_atul_demo5`.`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": "4.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": [
"atulecarter_atul_demo5.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": "4.20",
"data_read_per_join": "133"
},
"used_columns": [
"category_id",
"storefront_id",
"usergroup_ids",
"status"
],
"attached_condition": "((`atulecarter_atul_demo5`.`cscart_categories`.`storefront_id` in (0,1)) and ((`atulecarter_atul_demo5`.`cscart_categories`.`usergroup_ids` = '') or find_in_set(0,`atulecarter_atul_demo5`.`cscart_categories`.`usergroup_ids`) or find_in_set(1,`atulecarter_atul_demo5`.`cscart_categories`.`usergroup_ids`)) and (`atulecarter_atul_demo5`.`cscart_categories`.`status` in ('A','H')))"
}
},
{
"table": {
"table_name": "cscart_seo_names",
"access_type": "const",
"possible_keys": [
"PRIMARY",
"dispatch"
],
"key": "PRIMARY",
"used_key_parts": [
"object_id",
"type",
"dispatch",
"lang_code",
"company_id"
],
"key_length": "210",
"ref": [
"const",
"const",
"const",
"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": "4.21",
"data_read_per_join": "86"
},
"used_columns": [
"name",
"object_id",
"company_id",
"type",
"dispatch",
"path",
"lang_code"
]
}
},
{
"table": {
"table_name": "cscart_discussion",
"access_type": "const",
"possible_keys": [
"object_id",
"idx_company_id"
],
"key": "object_id",
"used_key_parts": [
"object_id",
"object_type",
"company_id"
],
"key_length": "10",
"ref": [
"const",
"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": "4.22",
"data_read_per_join": "1"
},
"used_columns": [
"object_id",
"object_type",
"type",
"company_id"
]
}
},
{
"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": "4.23",
"data_read_per_join": "0"
},
"used_columns": [
"product_id",
"storefront_id",
"average_rating",
"reviews_count"
]
}
},
{
"table": {
"table_name": "cscart_ec_table_booking_system",
"access_type": "const",
"possible_keys": [
"PRIMARY"
],
"key": "PRIMARY",
"used_key_parts": [
"product_id"
],
"key_length": "4",
"ref": [
"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": "4.24",
"data_read_per_join": "8"
},
"used_columns": [
"product_id",
"booking_type",
"quantity_selector",
"show_price_date",
"blocked_date",
"from_date",
"to_date",
"slot_time",
"free_time",
"days_data",
"minimum_booking_time"
],
"attached_condition": "<if>(is_not_null_compl(cscart_ec_table_booking_system), <cache>((209 = 209)), true)"
}
}
]
}
}
}
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 |
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 |
booking_type |
from_date |
to_date |
slot_time |
free_time |
days_data |
quantity_selector |
show_price_date |
blocked_date |
minimum_booking_time |
| 209 |
G0209Y9N72 |
P |
A |
1 |
0.00 |
10 |
0.000 |
0 |
0 |
0 |
0.00 |
0 |
1328731200 |
1328792337 |
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 |
en |
HP Scanjet G3110 Scanner |
|
|
<p> </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;">Make your photos, documents, slides, and negatives all look great by scanning them at 4800 x 9600<a class="dotline" style="color: #003366; border-bottom-width: 1px; border-bottom-style: dashed; border-bottom-color: #003366; cursor: default;">dpi</a>resolution<sup style="font-size: 0.8em;">1</sup>. Our Scanjet G3110 Photo Scanner comes with software that removes red eye, removes dust and scratches, and restores vibrant color to your old, faded images.</div>
<div class="fl" style="float: left; 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/l2698a_open_left.jpg" alt="Top surface with slides" /></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;">Excellent quality, affordable price</h3>
<ul style="margin-top: 0px; margin-bottom: 10px; margin-left: 20px; padding: 0px;">
<li><strong>Get great scans</strong>of black-and-white and color photos with the 4800 x 9600<a class="dotline" style="color: #003366; border-bottom-width: 1px; border-bottom-style: dashed; border-bottom-color: #003366; cursor: default;">dpi</a>and 48-bit color</li>
<li><strong>Remove red eye</strong>from scanned photos</li>
<li><strong>Bring out the detail</strong>in dark photos, plus restore faded colors</li>
<li><strong>Correct most flaws</strong>and scratches from damaged photos</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;">Versatile flatbed design</h3>
<ul style="margin-top: 0px; margin-bottom: 10px; margin-left: 20px; padding: 0px;">
<li><strong>Scan four 35 mm slides,</strong>five negatives, or three 4 x 6" photos at once, then save to separate files</li>
<li><strong>Archive important records</strong>and documents: the G3110 scans sizes up to 8.5 x 11"</li>
<li><strong>Get realistic</strong>scans of 3-D items, capturing more detail and depth (ideal for photos for on-line auctions)</li>
<li><strong>Create word-processing files</strong>and PDFs from scanned documents with the included optical character recognition software</li>
<li><strong>Scan directly to e-mail</strong>for quick and easy sharing</li>
<li><strong>Print copies</strong>of scanned documents using a one-touch button and default printer</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/l2698a_portsview_right.jpg" alt="View of side ports" /></p>
</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;">Fast and easy</h3>
<ul style="margin-top: 0px; margin-bottom: 10px; margin-left: 20px; padding: 0px;">
<li><strong>Save time</strong>on common jobs with scan shortcuts</li>
<li><strong>Use four one-touch buttons</strong>for common tasks: scan, copy, scan to e-mail, scan to PDF</li>
<li><strong>Organize, edit,</strong>print, share, and save scanned photos with the included HP Photosmart Essential Software</li>
<li><strong>Connect to a PC</strong>for optimal scan transfer speeds with Hi-Speed USB 2.0</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/l2698a_top_right.jpg" alt="View of top buttons" /></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 90-day limited warranty and toll-free phone support</li>
<li><strong>Find answers</strong>to your 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;">
<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/scanner/photo/1/storefronts/L2698A%2523B1H" src="http://hpshopping.speedera.net/www.shopping.hp.com/shopping/images/products/l2698a_150.gif" border="0" alt="HP Scanjet G3110 Scanner" width="150" height="100" /></p>
</div>
<p> </p>
<table border="0" cellspacing="0" cellpadding="0" width="100%">
<tbody>
<tr>
<td width="10" valign="top">•</td>
<td>Scanner</td>
</tr>
<tr>
<td width="10" valign="top">•</td>
<td>USB cable</td>
</tr>
<tr>
<td width="10" valign="top">•</td>
<td>Power cord and supply</td>
</tr>
<tr>
<td width="10" valign="top">•</td>
<td>CDs with software and instructions</td>
</tr>
<tr>
<td width="10" valign="top">•</td>
<td>Set-up poster</td>
</tr>
<tr>
<td width="10" valign="top">•</td>
<td>IRIS registration flyer</td>
</tr>
<tr>
<td width="10" valign="top">•</td>
<td>Warranty statement</td>
</tr>
</tbody>
</table>
<p> </p>
<div class="p10" style="color: #000000; font-family: Arial, Verdana, Helvetica, sans-serif; font-size: 12px; background-color: #ffffff; margin-top: 10px; 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;">Compatible with</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;" src="http://hpshopping.speedera.net/www.shopping.hp.com/shopping/images/logos/icon_windows_compatible.gif" alt="Windows compatible" width="20" height="15" /><img style="border-style: initial; border-color: initial; display: inline; padding: 0px; margin: 0px;" src="http://hpshopping.speedera.net/www.shopping.hp.com/shopping/images/logos/icon_compatible_mac.gif" alt="Mac compatible" width="20" height="15" /></p>
</div>
<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> |
|
109.99000000 |
172M |
93 |
CS-Cart |
|
hp-scanjet-g3110-scanner |
166/167/172 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|