{
"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 = 61051 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": 8,
"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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 61051 | BLE-G-LAR | P | E | C | M | W | A | 0 | A | 1 | 359.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;} | 1732204140 | Price updated from $169 to $237 to include G3 gooseneck arm in base price - DC 9/18/19 Price increased by $96 - DC 4/15/21 35% commercial discount to base price manually added - DC 4/15/21 Price increased 10% from $265 to $292 - DC 5/24/22 Price increased from $292 to $350 - DC 10/31/22 Price increased from $350 to $359 - DM 9/28/23 | Y | none | none | 590,591 | BLE-G | {"21970":3,"22028":6,"22029":9,"22031":9,"22030":9,"22034":8,"22345":9,"21941":11,"22040":8,"22039":7,"22035":6,"23537":10} | 1008383 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0.00 | 0 | en | Laramie Gooseneck Light | <p>An American made light with farmhouse detailing, the Laramie presents a look worthy of both residential and commercial décors. This fixture’s design features slender decorative arms reaching from the shade’s base to its neck. Affixing this shade to gooseneck arm establishes an iconic profile, one that complements the styles found in today’s décors.</p> <p>Skilled artisans hand-craft every Laramie shade from commercial grade metal. Multiple customization options, including various finishes and gooseneck arm styles, let this fixture adapt to any space’s needs. Durable and long-lasting, use the Laramie for both interior and exterior lighting applications.</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="/video-gallery/">here</a>.</li> <li>Learn more about the Laramie Gooseneck Light over on our<span> <a href="https://www.barnlight.com/inspiration/featured-customer-laramie-family-of-barn-lights-adds-traditional-touch-to-metal-barn/" target="_blank">blog</a>!</span></li> </ul> | country style gooseneck lighting, decorative exterior wall light, rlm style gooseneck light, curved arm wall light, gooseneck light outdoor, gooseneck reading light, western inspired gooseneck light, industrial farmhouse lighting | Channel the farmhouse look with this decorative RLM shade gooseneck light. Fully customizable and made in the USA! | The Laramie Gooseneck, BLE-G-LAR-PC, laramie, gooseneck, gooseneck light, amreican made, classic light, unique neck, western style, gooseneck arm,BLE-G-LAR12-PC, BLE-G-LAR14-PC, BLE-G-LAR16-PC, gooseneck lighting, gooseneck wall lights, gooseneck wall lighting, outdoor gooseneck lighting, exterior gooseneck lighting, exterior gooseneck, exterior lighting, outdoor lighting, interior lighting, interior gooseneck, wall light, wall lighting, gooseneck wall lighting, laramie gooseneck, farmhouse gooseneck, BLE-G-LAR8, BLE-G-LAR10, BLE-G-LAR12, BLE-G-LAR14, BLE-G-LAR16, KAR, SPS-0062, SPS 0062, SPS0062, The Laramie Collection, Laramie Collection, The Laramie Series, Laramie Series, Laramie gooseneck lamp, Laramie gooseneck lamps, 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, Wall mount light, wall mount lights, wall mount lighting, Wall mount light fixture, Wall mount light fixtures, Wall mount lighting fixture, Wall mount lighting fixtures, wall mounted light, wall mounted lights, wall mounted lighting, wall mounted light fixture, wall mounted light fixtures, wall mounted lighting fixture, wall mounted lighting fixtures, Wall mount gooseneck light, Wall mount gooseneck lights, Wall mount gooseneck lighting, Wall mount gooseneck, Wall mount goosenecks, Wall mounted gooseneck light, Wall mounted gooseneck lights, Wall mounted gooseneck lighting, Wall mounted gooseneck, Wall mounted goosenecks, bleg, H-70412, armed dome shade, armed dome shade gooseneck, | Laramie Gooseneck Light | Barn Light Electric | 359.000000 | 1530,1602,1621,1697,1707,1906,2001,1897M | 435722 | Barn Light Electric Company | 323 | laramie-gooseneck-light | 1887/1896/1897 | B |