{
"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 = 64771 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 64771 | BLE-C-SBS | P | E | C | M | A | A | 0 | A | 1 | 258.00 | 1000 | 0.000 | 0 | 0 | 0 | 0.00 | 0 | 1564680998 | 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;} | 1768927885 | Price increased by $37 - DC 5/10/21 35% commercial discount to base price manually added - DC 5/10/21 Price increased by 5% from $192 to $202 - DC 5/27/21 Price increased from $202 to $209 - DC 12/10/21 Price increased by 10% from $209 to $230 - DC 5/20/22 Price decreased from $230 to $205 - DC 11/1/22 Price increased from $205 to $258 - DM 9/27/23 | Y | none | none | 332,333,334 | BLE-C | {"21943":4,"22277":7,"22163":7,"21941":8,"23857":4,"23858":4,"23859":4,"23860":4} | 1051256 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0.00 | 0 | en | Sinclair Draftsman Cord Pendant Light | <p>Influenced by authentic 20th-century designs, the Sinclair follows a simple industrial look that appeals to traditional spaces and contemporary décors. The Sinclair’s sleek shallow bowl shade establishes a straightforward aesthetic — perfect for residential and commercial settings. Thanks to the Sinclair’s cord mounting, every space can incorporate this fashionable look.</p> <p>A team of talented artisans constructs the Sinclair entirely by hand, a meticulous process that ensures a high-quality fixture. That means spinning the shade, applying finishes, and assembling the pendant are all hands-on tasks. This pendant lighting is customizable with an array of finishes, socket and cord styles, and other options!</p> <p>|break|</p> <ul> <li>Hands-on craftsmanship and high-quality materials establish a durable ceiling-mounted pendant design.</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 Sinclair Draftsman Pendant Light over on our<span> <a href="https://www.barnlight.com/inspiration/pros-corner-copper-pendants-add-warmth-to-new-kitchen/" target="_blank">blog</a></span>!</li> </ul> | barn light ceiling light, cord hung pendant, flared pendant light, vintage shallow bowl light, ceiling light fixture, gas station lighting, vintage gas station light fixture, cord hung light fixture | The Skylark Pendant Light offers a wide span of light with its flared base and looks right at home in the kitchen, dining room, or office. | Skylark, Skylark Cord Hung, Skylark pendant, shallow bowl pendant, shallow bowl cord hung, BLE-C-SBS-PC, BLE-C-SBS10-PC, BLE-C-SBS12-PC, BLE-C-SBS14-PC, BLE-C-SBS16-PC, new listing, new rlm, new skylark, Skylark Industrial Pendant, BLE-CU-SBS-PC, socket rlm pendant, skylark, shallow bowl, cord hung, cord pendant, BLE-CU-SBS10-PC, BLE-CU-SBS12-PC, BLE-CU-SBS14-PC, BLE-CU-SBS16-PC, Industrial, Ivanhoe, Sinclair, Ivanhoe Sinclair, shallow bowl, BLE-CU-SBS, BLE-CU-SBS10, BLE-CU-SBS12, BLE-CU-SBS14, BLE-CU-SBS16, flat, flat pendant, sinclair pendant, new sinclair, new rlm, new listing, BLE-C-SBS10, BLE-C-SBS12, BLE-C-SBS14, BLE-C-SBS16, Sinclaire, SPS-0155, SPS0155, SPS 0155, Sinclair Series, Sinclair Collection, The Sinclair Series, The Sinclair Collection, SPS-0373, SPS 0373, SPS0373, Sinclair Industrial Collection, Sinclair Industrial Series, corded pendant, corded pendants, corded pendant light, corded pendant lights, corded pendant lighting, corded ceiling pendant, corded ceiling pendants, corded ceiling light, corded ceiling lights, corded ceiling lighting, corded pendant light fixture, corded pendant light fixtures, corded pendant lighting fixture, corded pendant lighting fixtures, corded light fixture, corded light fixtures, corded lighting fixture, corded lighting fixtures, corded, jadeite, jadite, jadeite light, jadite light, bowl shallow, | Sinclair Draftsman Cord Pendant Light | Enameled Barn Light by BarnLightElectric.com | 258.000000 | 1522,1542,1613,1628,1701,1889M | 608229 | Barn Light Electric Company | 36 | sinclair-draftsman-pendant-light | 1887/1888/1889 | B |