{
"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 = 64979 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": 7,
"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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 64979 | BLE-G-YDM-LED | P | E | C | M | W | D | 0 | A | 1 | 405.00 | 1000 | 0.000 | 0 | 0 | 0 | 0.00 | 0 | 1579536175 | 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;} | 1775142036 | Price increased by $68 - DC 1/20/20 Price increased 5% from $418 to $439 - DC 6/1/21 Price decreased by $23 - DC 10/28/21 Price increased 10% from $416 to $458 - DC 6/2/22 Price decreased from $458 to $405 - DC 10/31/22 | Y | none | none | 1270,1271,1272 | BLE-G | {"22646":7,"22649":9,"22650":9,"22648":9,"22643":10,"22644":12,"22645":13,"23125":10,"23126":10,"23124":10,"23132":11,"22250":6,"22251":6,"22252":6,"23123":8,"22263":9,"22261":9,"22262":9,"22260":9} | 1056013 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 0.00 | 0 | en | Marathon LED Gooseneck Light | <p>Versatile and stylish, the Marathon has emerged as a favorite in homes and businesses. Vintage influences and high-tech components are central to the Marathon’s universal appeal. While the shade resembles classic 20th-century fixtures, its timeless lines and straightforward appearance still feel relevant to modern settings. Customizing options like marine grade, powder coat, and natural metal finishes establish looks tailored to individual settings.</p> <p>The powerful LED technology integrated into the Marathon’s structure produces light efficiently. LEDs, compared to incandescent bulbs, waste little energy as heat when they emit illumination, which means less electricity is needed to brighten a home or business.</p> <p>|break|</p> <ul> <li>A rugged, handcrafted gooseneck wall light, this industrial fixture is a long-lasting indoor/outdoor lighting 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> | Handcrafted, fully customizable LED gooseneck lights! The Marathon integrates powerful tech into a classic gooseneck design, the perfect option for outdoor areas! | goodrich marathon, Goodrich gooseneck, Goodrich gooseneck light, Goodrich gooseneck lighting, marathon gooseneck lighting, marathon gooseneck lights, barn lighting, warehouse lighting, exterior wall lights, exterior wall lighting, outdoor wall lights, outdoor wall lighting, exterior goosenecks, outdoor goosenecks, outdoor warehouse lighting, outdoor warehouse lights, exterior warehouse lighting, outdoor warehouse lights, porch lighting, barn lights, marathon, marathon gooseneck, goodrich marathon, marathon LED, LED marathon, Maritime Gooseneck, Maritime, Yard Light, BLE-G-YDM-PC, BLE-G-YDM12, BLE-G-YDM14, BLE-G-YDM16, gooseneck wall light, gooseneck lighting, outdoor gooseneck lighting, exterior gooseneck lighting, outdoor gooseneck, exterior gooseneck, shallow bowl gooseneck, shallow bowl lighting, shallow bowl wall mount, shallow bowl gooseneck, shallow bowl gooseneck lighting, shallow bowl lighting, exterior shallow bowl, outdoor shallow bowl, exterior gooseneck wall mount, outdoor gooseneck wall mount, indoor wall mount, interior wall mount, interior lighting, indoor lighting, maritime gooseneck light, maritime wall light, BLE-G-YDM12, BLE-G-YDM14, BLE-G-YDM16, marathon series, marathon collection, the marathon series, the marathon collection, SPS-0109, SPS 0109, SPS0109, marathon led series, marathon led collection, the marathon led series, the marathon led collection, SPS-0459, SPS 0459, SPS0459, 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, bowl shallow, | Marathon LED Gooseneck Light | Barn Light Electric | 405.000000 | 1591,1602,1857,1861,1935,2001,1939M | 217530 | Barn Light Electric Company | 175 | marathon-led-gooseneck-light | 1920/1938/1939 | B |