{
"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 = 64974 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": 5,
"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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 64974 | BLE-G-RWS-LED | P | E | C | M | W | D | 0 | A | 1 | 435.00 | 1000 | 0.000 | 0 | 0 | 0 | 0.00 | 0 | 1578588318 | 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;} | 1769524801 | Price increased by $68 - DC 1/9/19 Price increased 5% from $463 to $486 - DC 6/1/21 Price decreased by $57 - DC 10/28/21 Price increased 10% from $429 to $472 - DC 6/2/22 Price decreased from $472 to $435 - DC 10/28/22 | Y | none | none | 1249,1250,1251 | BLE-G | {"22649":7,"22650":7,"22648":7,"22675":8,"22644":9,"22645":10} | 1056013 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 0.00 | 0 | en | Seaside LED Gooseneck Light | <p>Featuring high-performance LED components and a vintage-influenced shade, the Seaside combines the best of two worlds: classic designs and innovative technology. With its nostalgic style, the Seaside can be incorporated into décors ranging from contemporary and urban to rustic farmhouse. When installed in homes or businesses, this whimsical look gives every space a casual atmosphere and eye-catching appearance.</p> <p>By integrating LEDs into its structure, this gooseneck light is one of the most efficient lighting options for homes and businesses. Greatly reducing a building’s energy consumption, the Seaside LED gooseneck is both eco-friendly and budget-conscious.</p> <p>|break|</p> <ul> <li>Hand built with an American made RLM warehouse shade, this quality industrial wall lighting is a lasting gooseneck option. </li> <li>Made-to-order, learn more about the process<span> </span><a href="https://www.barnlight.com/video-gallery/">here</a>.</li> <li>Read more about the Seaside LED Gooseneck Light over on the <a href="https://www.barnlight.com/inspiration/gooseneck-lights-offer-attractive-upgrade-from-builder-basic-fixtures/" target="_blank">blog</a>!</li> </ul> | Classic styles with innovative technology, this LED gooseneck light reduces power consumption and gives any space a bold new look! Customizable and American made! | Goodrich Seaside, Goodrich radial wave, Goodrich radial wave reflector, Seaside gooseneck, radial wave gooseneck, radial wave reflector gooseneck, stylish lighting, beach house lighting, outdoor wall lights, outdoor wall lighting, exterior wall lights, outdoor lighting, exterior lighting, outdoor gooseneck lights, exterior gooseneck lights, outdoor goosenecks, exterior goosenecks, outdoor led lighting, exterior led lighting, exterior led goosenecks, outdoor led goosenecks, exterior led gooseneck lighting, outdoor led gooseneck lighting, goodrich seaside, seaside gooseneck led, led seaside gooseneck, seaside led gooseneck, seaside, gooseneck seaside, goodrich seaside led, led seaside, goodrich seaside led, gooseneck seaside, gooseneck seaside led, goodrich radial, radial gooseneck led, led radial gooseneck, radial led gooseneck, radial, gooseneck radial, goodrich radial led, led radial, goodrich radial led, gooseneck radial, gooseneck radial led, led sea side, sea side led, seaside, sea side, seaside gooseneck, The Starfire Radial Wave Reflector Gooseneck Light, radial wave gooseneck, starfire gooseneck, reflector gooseneck, radial wave, gooseneck, H-19008-RW, BLE-G-RWS-PC-LED, LED, Led light, LED lights, commercial lighting, BLE-G-RWS12-PC-LED, BLE-G-RWS14-PC-LED, BLE-G-RWS16-PC-LED, BLE-G-RWS12, BLE-G-RWS14, BLE-G-RWS16, Goose neck with fluted shade, Gooseneck with fluted shade, Goose neck with fluted shades, Gooseneck with fluted shades, seaside series, seaside collection, sea side series, sea side collection, the seaside series, the seaside collection, the sea side series, the sea side collection, SPS-0156, SPS0156, SPS 0156, SPS-0456, SPS 0456, SPS0456, seaside led series, seaside led collection, sea side led series, sea side led collection, the seaside led series, the seaside led collection, the sea side led series, the sea side led collection, Outside lights, Outside light, Outside lighting, Out side lights, Out side light, Out side lighting, barn light for outside, barn lights for outside, Outside gooseneck barn light, Outside gooseneck barn lights, Outside gooseneck barn lighting, Outside gooseneck light, Outside gooseneck lights, Outside gooseneck lighting, Outside gooseneck, Outside goosenecks, Out side gooseneck light, Out side gooseneck lights, Out side gooseneck lighting, Out side gooseneck, Out side goosenecks, goose neck outside lights, goose neck outside light, goose neck outside lighting, gooseneck outside lights, gooseneck outside light, gooseneck outside lighting, outdoor wall mount light, outdoor wall mount lights, outdoor wall mount lighting, bleg, fluted lights, H-19112, H-19114, H-19116, classic radial shade, classic radial shade gooseneck, | Seaside LED Gooseneck Light | Barn Light Electric | 435.000000 | 1591,1602,1861,2001,1939M | 203893 | Barn Light Electric Company | 53 | seaside-led-gooseneck-light | 1920/1938/1939 | B |