{
"query_block": {
"select_id": 1,
"table": {
"table_name": "shared_prices",
"access_type": "system",
"possible_keys": [
"usergroup",
"product_id",
"company_id",
"lower_limit",
"usergroup_id"
],
"rows": 0,
"filtered": 0,
"const_row_not_found": true
},
"table": {
"table_name": "cscart_products",
"access_type": "const",
"possible_keys": ["PRIMARY", "status"],
"key": "PRIMARY",
"key_length": "3",
"used_key_parts": ["product_id"],
"ref": ["const"],
"rows": 1,
"filtered": 100
},
"table": {
"table_name": "companies",
"access_type": "const",
"possible_keys": ["PRIMARY"],
"key": "PRIMARY",
"key_length": "4",
"used_key_parts": ["company_id"],
"ref": ["const"],
"rows": 1,
"filtered": 100
},
"table": {
"table_name": "popularity",
"access_type": "const",
"possible_keys": ["PRIMARY", "total"],
"key": "PRIMARY",
"key_length": "3",
"used_key_parts": ["product_id"],
"ref": ["const"],
"rows": 1,
"filtered": 100
},
"table": {
"table_name": "cscart_product_sales",
"access_type": "const",
"possible_keys": ["PRIMARY", "pa"],
"key": "PRIMARY",
"key_length": "6",
"used_key_parts": ["category_id", "product_id"],
"ref": ["const", "const"],
"rows": 1,
"filtered": 100
},
"table": {
"table_name": "cscart_product_prices",
"access_type": "range",
"possible_keys": ["usergroup", "product_id", "lower_limit", "usergroup_id"],
"key": "product_id",
"key_length": "9",
"used_key_parts": ["product_id", "usergroup_id", "lower_limit"],
"rowid_filter": {
"range": {
"key": "lower_limit",
"used_key_parts": ["lower_limit", "product_id", "usergroup_id"]
},
"rows": 2,
"selectivity_pct": 0.074128984
},
"rows": 2,
"filtered": 100,
"attached_condition": "trigcond(1) and trigcond(cscart_product_prices.product_id = 62019 and cscart_product_prices.lower_limit = 1 and cscart_product_prices.usergroup_id in (0,0,1))"
},
"table": {
"table_name": "cscart_product_descriptions",
"access_type": "const",
"possible_keys": ["PRIMARY", "product_id"],
"key": "product_id",
"key_length": "9",
"used_key_parts": ["product_id", "lang_code"],
"ref": ["const", "const"],
"rows": 1,
"filtered": 100,
"attached_condition": "trigcond(cscart_product_descriptions.lang_code = 'en')"
},
"table": {
"table_name": "cscart_products_categories",
"access_type": "ref",
"possible_keys": ["PRIMARY", "pt"],
"key": "pt",
"key_length": "3",
"used_key_parts": ["product_id"],
"ref": ["const"],
"rows": 9,
"filtered": 100,
"using_index": true
},
"table": {
"table_name": "cscart_categories",
"access_type": "eq_ref",
"possible_keys": ["PRIMARY", "c_status", "p_category_id"],
"key": "PRIMARY",
"key_length": "3",
"used_key_parts": ["category_id"],
"ref": ["cscart_migrate.cscart_products_categories.category_id"],
"rows": 1,
"filtered": 100,
"attached_condition": "cscart_categories.company_id = 1 and (cscart_categories.usergroup_ids = '' or find_in_set(0,cscart_categories.usergroup_ids) or find_in_set(1,cscart_categories.usergroup_ids)) and cscart_categories.`status` in ('A','H')"
},
"table": {
"table_name": "cscart_seo_names",
"access_type": "const",
"possible_keys": ["PRIMARY", "dispatch"],
"key": "dispatch",
"key_length": "210",
"used_key_parts": [
"dispatch",
"object_id",
"type",
"lang_code",
"company_id"
],
"ref": ["const", "const", "const", "const", "const"],
"rows": 1,
"filtered": 100,
"attached_condition": "trigcond(cscart_seo_names.`type` = 'p' and cscart_seo_names.dispatch = '' and cscart_seo_names.lang_code = 'en')"
},
"table": {
"table_name": "cscart_discussion",
"access_type": "ref",
"possible_keys": ["object_id"],
"key": "object_id",
"key_length": "6",
"used_key_parts": ["object_id", "object_type"],
"ref": ["const", "const"],
"rows": 1,
"filtered": 100,
"attached_condition": "trigcond(cscart_discussion.object_type = 'P')"
}
}
}| product_id | product_code | product_type | trustmark_origin | trustmark_certified | trustmark_leadtime | trustmark_location | trustmark_return | owner_id | status | company_id | list_price | amount | weight | length | width | height | shipping_freight | low_avail_limit | 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 | updated_timestamp | pricing_note | use_new_layout | category_image | tax_code | upc_code | product_detail_ids | nav_sku | sku_columns | nav_review_user_id | hide_price | vendor_fulfilled | hide_commercial_price | non_returnable | ble_basics | commercial_hidden | allow_configurator | enable_customize | enable_buy_american | base_cost | redline_p | lang_code | product | shortname | short_description | full_description | meta_keywords | meta_description | search_words | page_title | age_warning_message | internal | promo_text | price | category_ids | popularity | company_name | sales_amount | seo_name | seo_path | discussion_type |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 62019 | BLE-S-CLAR | P | E | C | M | W | A | 0 | A | 1 | 295.00 | 1000 | 0.000 | 0 | 0 | 0 | 0.00 | 0 | 1336017600 | 0 | N | N | N | D | N | R | N | N | N | Y | 10 | 0 | N | 0 | 0 | 0 | 0 | 13 | N | 0 | P | F | 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;} | 1753278850 | Price increased by $39 - DC 4/19/21 36% commercial discount to base price manually added - DC 4/19/21 Price increased 5% from $235 to $247 - DC 5/27/21 Price increased 10% from $247 to $272 - DC 5/23/22 Price increased from $272 to $295 - DC 10/31/22 | Y | none | none | 568,569,570 | BLE-S | {"22117":3,"22224":10,"22028":6,"22031":9,"22030":9,"22029":9,"22695":7,"21941":11,"21970":3,"22039":7,"22034":8,"22040":8,"23551":6} | 1056013 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0.00 | 0 | en | Chestnut Stem Pendant Light | <p>Nodding to the styles of early American barn lights, the Chestnut Stem Mount Pendant showcases a truly timeless style. Suspending a stylish warehouse shade from a rugged stem mounting, the Chestnut represents the best of barn lighting: style and function. Featuring a similar look to <a title="The Laramie Stem Mount Pendant" href="/lighting/ceiling-lights/stem-mount-pendant-lighting/laramie-stem-mount-pendant-light/">the Laramie</a> — removing the decorative arms — this pendant light instills any space with a southern charm. The stem mounting adds functionality into the mix. Protecting the fixture, the Chestnut is able to stand up to installation in high traffic areas or as exterior lighting.</p> <p>Available with an assortment of customization options, the Chestnut mirrors the look of your space. Able to blend in or stand out, select the powder coat finish color best suiting your needs. Manufactured entirely by hand, the Chestnut features the high quality expected of American made lighting. Let the Chestnut become a long lasting addition to your decor!</p> <p>|break|</p> <ul> <li>Hand built with an American made RLM warehouse shade, this quality industrial pendant is a lasting stem mount option. </li> <li>Made-to-order, learn more about the process<span> </span><a href="https://www.barnlight.com/video-gallery/">here</a>.</li> </ul> | porch pendant light, industrial stem mount porch light, exterior hanging pendant, barn light ceiling pendant, suspended warehouse shade, hanging barn light, doorway lighting | Taking a nod from early American lights, the Chestnut Pendant is a period style warehouse shade suspended in a stem ceiling mount. Lovely for porch lighting! | BLE-S-CLAR-PC, Chestnut Stem Mount Pendant, stem light, stem mount light, stemmount, stem light, barn light shade pendant light, hanging pendant, ceiling pendant, stem mount pendant, chestnut stem pendant, chestnut, chestnut pendant, the chestnut, chestnuts, chestnut light, laramie, BLE-S-CLAR8-PC, BLE-S-CLAR10-PC, BLE-S-CLAR12-PC, BLE-S-CLAR14-PC, BLE-S-CLAR16-PC, new listing, chestnut, chestnut stem, chesnut, chesnut stem, chest nut, chestnut pendant, chesnut pendant, chest nut pendant, new chestnut, BLE-S-CLAR8, BLE-S-CLAR10, BLE-S-CLAR12, BLE-S-CLAR14, BLE-S-CLAR16, SPS-0063, SPS 0063, SPS0063, The Chestnut Collection, The Chestnut Series, Chestnut Collection, Chestnut Series, stems, Stem pendant lights, stem light mount, stem light mounts, stem, Outside lights, Outside light, Outside lighting, Out side lights, Out side light, Out side lighting, barn light for outside, barn lights for outside, Outside pendant, Outside pendants, Outside ceiling pendant, Outside ceiling pendants, Outside pendant light, Outside pendant lights, Outside pendant lighting, Outside ceiling pendant, Outside ceiling pendants, | Chestnut Stem Pendant Light | Barn Light Electric | 295.000000 | 1543,1603,1621,1625,1704,1708,1905,2001,1890M | 439086 | Barn Light Electric Company | 39 | chestnut-stem-mount-pendant-light | 1887/1888/1890 | B |