Query time 0.00106
JSON explain
{
"query_block": {
"select_id": 1,
"cost_info": {
"query_cost": "3.28"
},
"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_aprilproducts",
"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",
"show_videos_before_images",
"autoplay_videos",
"facebook_obj_type",
"parent_product_id",
"buy_now_url",
"units_in_product",
"show_price_per_x_units",
"enable_print_product",
"ec_clipart_lists"
]
}
},
{
"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_aprilproduct_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_aprilproduct_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_aprilproduct_prices), ((`vishalecarter_april_setup`.`cscart_aprilproduct_prices`.`lower_limit` = 1) and (`vishalecarter_april_setup`.`cscart_aprilproduct_prices`.`usergroup_id` in (0,0,1))), true)"
}
},
{
"table": {
"table_name": "cscart_aprilproduct_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": "6K"
},
"used_columns": [
"company_id",
"status"
],
"attached_condition": "<if>(found_match(companies), ((`vishalecarter_april_setup`.`companies`.`status` = 'A') or 0), true)"
}
},
{
"table": {
"table_name": "cscart_aprilproducts_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_aprilcategories",
"access_type": "eq_ref",
"possible_keys": [
"PRIMARY",
"c_status",
"p_category_id"
],
"key": "PRIMARY",
"used_key_parts": [
"category_id"
],
"key_length": "3",
"ref": [
"vishalecarter_april_setup.cscart_aprilproducts_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": "133"
},
"used_columns": [
"category_id",
"storefront_id",
"usergroup_ids",
"status"
],
"attached_condition": "((`vishalecarter_april_setup`.`cscart_aprilcategories`.`storefront_id` in (0,1)) and ((`vishalecarter_april_setup`.`cscart_aprilcategories`.`usergroup_ids` = '') or find_in_set(0,`vishalecarter_april_setup`.`cscart_aprilcategories`.`usergroup_ids`) or find_in_set(1,`vishalecarter_april_setup`.`cscart_aprilcategories`.`usergroup_ids`)) and (`vishalecarter_april_setup`.`cscart_aprilcategories`.`status` in ('A','H')))"
}
},
{
"table": {
"table_name": "cscart_aprilseo_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": "cscart_aprildiscussion",
"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.27",
"data_read_per_join": "1"
},
"used_columns": [
"object_id",
"object_type",
"type"
]
}
},
{
"table": {
"table_name": "cscart_aprilproduct_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.28",
"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 |
show_videos_before_images |
autoplay_videos |
facebook_obj_type |
parent_product_id |
buy_now_url |
units_in_product |
show_price_per_x_units |
enable_print_product |
ec_clipart_lists |
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 |
| 212 |
P0212CTOEA |
P |
A |
1 |
0.00 |
15 |
0.000 |
0 |
0 |
0 |
0.00 |
0 |
1328731200 |
1328792641 |
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.000 |
1.000 |
N |
|
ar |
Panasonic KX-MB2000 24PPM 3-in-1 Monochrome Laser MFP |
|
|
<p> </p>
<h3 style="border-image: initial; font-size: 12px; font: inherit; vertical-align: baseline; font-family: Arial, Helvetica, sans-serif; color: #000000; line-height: 12px; padding: 0px; margin: 0px; border: 0px initial initial;">Robust Feature Set & Superior Ease of Use.</h3>
<p style="margin-top: 0px; margin-right: 0px; margin-bottom: 12px; margin-left: 0px; padding-top: 0px; padding-bottom: 0px; border-image: initial; font-size: 12px; font: inherit; vertical-align: baseline; font-family: Arial, Helvetica, sans-serif; line-height: 16px; color: #40474b; border: 0px initial initial;">The KX-MB2000 includes standard printing, color scanning, and copying capabilities to meet the demands of todays businesses. The KX-MB2000 boasts a highly reliable print engine with an easy open clam shell design which makes consumable replacement and the removal of the occasional paper jam extremely easy. In addition, the KX-MB2000 includes a 10/100 Base-TX Ethernet interface for convenient device sharing in multi-user office environments, not to mention the ability to remotely manage and configure the device using a standard internet browser.</p>
<h3 style="border-image: initial; font-size: 12px; font: inherit; vertical-align: baseline; font-family: Arial, Helvetica, sans-serif; color: #000000; line-height: 12px; padding: 0px; margin: 0px; border: 0px initial initial;">High Speed, Professional-Quality Laser Printing</h3>
<p style="margin-top: 0px; margin-right: 0px; margin-bottom: 12px; margin-left: 0px; padding-top: 0px; padding-bottom: 0px; border-image: initial; font-size: 12px; font: inherit; vertical-align: baseline; font-family: Arial, Helvetica, sans-serif; line-height: 16px; color: #40474b; border: 0px initial initial;">The KX-MB2000 is capable of outputting up to 24 professional quality documents per minute<sup style="border-image: initial; font-size: 7px; font: inherit; display: inline; line-height: 7px; padding: 0px; margin: 0px; border: 0px initial initial;">1</sup> at 600 x 600 DPI. The KX-MB2000 includes a Host Based GDI printer driver which has been optimized for maximum printing productivity. The advanced printing features of the GDI printer driver include the ability to add watermarks to printed documents, print or create document Overlays, merge up to 16 documents on a single sheet of paper, or enlarge your document to a wall size poster.</p>
<h3 style="border-image: initial; font-size: 12px; font: inherit; vertical-align: baseline; font-family: Arial, Helvetica, sans-serif; color: #000000; line-height: 12px; padding: 0px; margin: 0px; border: 0px initial initial;">PC & Network Document Scanner</h3>
<p style="margin-top: 0px; margin-right: 0px; margin-bottom: 12px; margin-left: 0px; padding-top: 0px; padding-bottom: 0px; border-image: initial; font-size: 12px; font: inherit; vertical-align: baseline; font-family: Arial, Helvetica, sans-serif; line-height: 16px; color: #40474b; border: 0px initial initial;">The built in document flatbed on the KX-MB2000, is able to scan documents directly to a PC, E-mail, shared network folder or FTP server. Scanned documents can be saved as a PDF, JPG, TIFF or BMP file. The KX-MB2000 is capable of scanning documents in full color with resolutions up to 19,200 x 19,200 dpi (Interpolated).</p>
<h3 style="border-image: initial; font-size: 12px; font: inherit; vertical-align: baseline; font-family: Arial, Helvetica, sans-serif; color: #000000; line-height: 12px; padding: 0px; margin: 0px; border: 0px initial initial;">Convenient Desktop Copier</h3>
<p style="margin-top: 0px; margin-right: 0px; margin-bottom: 12px; margin-left: 0px; padding-top: 0px; padding-bottom: 0px; border-image: initial; font-size: 12px; font: inherit; vertical-align: baseline; font-family: Arial, Helvetica, sans-serif; line-height: 16px; color: #40474b; border: 0px initial initial;">The KX-MB2000 can also be used a desktop copy machine, utilizing the standard document flatbed. The KX-MB2000 offers many convenient copy features, such as Image Repeat, N in 1 Copy, Separate N in 1 Copy, Quick ID Copy and Proof Copy.</p>
<h3 style="border-image: initial; font-size: 12px; font: inherit; vertical-align: baseline; font-family: Arial, Helvetica, sans-serif; color: #000000; line-height: 12px; padding: 0px; margin: 0px; border: 0px initial initial;">Panasonic Multifunction Station Suite Software</h3>
<p style="margin-top: 0px; margin-right: 0px; margin-bottom: 12px; margin-left: 0px; padding-top: 0px; padding-bottom: 0px; border-image: initial; font-size: 12px; font: inherit; vertical-align: baseline; font-family: Arial, Helvetica, sans-serif; line-height: 16px; color: #40474b; border: 0px initial initial;">The KX-MB2000 comes bundled with the Panasonic Multifunction Station Suite Software, which includes all the software and utilities for the device. The bundled software suite includes; Panasonic's Multi-function viewer software which allows you to view scanned documents, remotely adjust the device configuration with the Remote control utility, and the Device Manager Application which provides a real time view of the devices current state.</p>
<h3 style="border-image: initial; font-size: 12px; font: inherit; vertical-align: baseline; font-family: Arial, Helvetica, sans-serif; color: #000000; line-height: 12px; padding: 0px; margin: 0px; border: 0px initial initial;">Advanced Document Management</h3>
<p style="margin-top: 0px; margin-right: 0px; margin-bottom: 12px; margin-left: 0px; padding-top: 0px; padding-bottom: 0px; border-image: initial; font-size: 12px; font: inherit; vertical-align: baseline; font-family: Arial, Helvetica, sans-serif; line-height: 16px; color: #40474b; border: 0px initial initial;">The KX-MB2000 features Panasonic's newest software application, the Panasonic Easy Print Utility. This intuitive application allows you to merge multiple documents into a single print job, which can then be previewed from your computers monitor before actual printing, to ensure the document layout is correct without wasting paper and toner. In addition, the KX-MB2000 includes a copy of Readiris Pro 7, which will allow you to convert your digital documents into text editable file formats.</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> |
|
129.95000000 |
172M |
30 |
CS-Cart |
|
panasonic-kx-mb2000-24ppm-3-in-1-monochrome-laser-mfp |
167/172 |
|
|
|
|