{
"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 = 60783 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 60783 | BLE-F-CGG | P | E | C | M | W | A | 0 | A | 1 | 270.00 | 1000 | 0.000 | 0 | 0 | 0 | 0.00 | 0 | 1340164800 | 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;} | 1780516490 | Price increased by $89 - DC 5/27/20 Price increased by 5% from $229 to $240 - DC 5/27/21 Price increased by $5 - DC 6/16/21 Price increased by 10% from $245 to $270 - DC 5/24/22 | Y | images/category_images/more-styles-available-flush-industrial-guard-975-galvanized.jpg | none | none | BLE-F-CGG | {"21970":1,"23015":2,"23020":3,"23018":3,"23019":3,"21941":4} | 1051256 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0.00 | 0 | en | Flush Mount Guard Sconce | <p>Influenced by classic nautical lighting, this compact fixture’s timeless profile can become an essential addition to every home or business. A versatile design, this wet-rated sconce light can be mounted to both walls and ceilings — indoors or out. By providing a touch of industrial character and ample illumination, this fixture can completely transform any décor.</p> <p>Fully customizable, a diverse assortment of finish colors and glass options determines the sconce’s aesthetic and style. Designed to fit in or stand out, create a unique look for your projects and revamp any home or business!</p> <p class="p1">|break|</p> <ul> <li><span>This compact wall sconce features a d</span><span>ie cast aluminum<span> </span></span><span>guard and customizable jelly jar glass!</span></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 Flush Mount Guard Sconce over on our<span> <a href="https://www.barnlight.com/inspiration/featured-customer-out-with-fluorescents-in-with-nautical-sconces/" target="_blank">blog</a></span>! </li> </ul> | cast guard light, cast guard & glass light fixture, cast guard unit, nautical cgu, vapor tight light fixture, vapor tight wall mount light, industrial flush mount light | The flush mount guard sconce is an industrial cast guard & glass light inspired by nautical CGUs that make a welcome addition to decorative wall and flush mount ceiling lighting. | The Bullet Flush Mount CGG,The Bullet Cast Guard & Glass, Cast Guard, Bullet, CGU, BLE-F-CGGB-PC, HB Sconce, Atomic Sconce, CGU, CGG, CGG Flush Mount, CGG Ceiling Light, CGU Flush Mount, CGU Ceiling Light, bulky, heavy duty, thick guard, Industrial, H-CGU-FB, BLE-F-CGGB-PC, The Bullet Cast Guard, the bullet light, the bullet guard light, the bullet cast light, guard light, the bullet ceiling light, the bullet flush mount light, cage guard flush mount, cast guard mount, cast guard flush mount, cast guard ceiling light, bullet ceiling light, industrial sconce, wall sconce lighting, industrial wall sconce lighting, bullet wall sconce, bullet wall light, cast guard sconce, cast guard wall sconce, flush mount, flush, guard sconce, flush mount guard sconce, flush mount, flush mount sconce, flush mount wall sconce, flush mount sconce, industrial flush mount, industrial flush mount sconce, industrial sconce, wall or ceiling sconce, ceiling sconce, rugged sconce, natuical sconce, nautical sconce, nautical wall sconce, industrial guard flush mount, flush mount, industrial, industrial guard, Rugged guard light, rugged guard lights, rugged guard lighting, rugged guard light fixture, rugged guard lighting fixture, rugged guard light fixtures, rugged guard lighting fixtures, rugged guard flush, flush rugged guard, rugged guard flush mount, flush mount rugged guard, rugged guard flush pendant, flush pendant rugged guard, rugged guard pendant, rugged guard pendant lights, rugged guard ceiling pendant, rugged guard ceiling pendants, rugged guard ceiling light, rugged guard ceiling lights, rugged guard ceiling lighting, jelly jar light, jelly jar lights, jelly jar light fixture, jelly jar light fixtures, Flush mount light, cgg, cggg, ccg, Pendent outdoor, pendant outdoor, Pendant light outdoor, pendant shade, pendant wet, pendent wet, pendant hanging lights, outdoor hanging pendant, outdoor hanging light, Outdoor ceiling mount, Outdoor semi-flush, outside barn light, outside barn lights, outside barn lighting, outdoor barn light, outdoor barn lights, outdoor barn lighting, outdoor lighting fixture, outdoor lighting fixtures, SPS-0007, SPS 0007, SPS0007, cast guard collection, cast guard series, rugged guard collection, rugged guard series, industrial guard collection, industrial guard series, cgg collection, cgg series, Small mount lighting, Small mount light, Small mount lights, foyer light, foyer lights, foyer lighting, Outside flush mount, Outside flush mounts, Outside flush mount light, Outside flush mount lights, Outside flush mount lighting, Outside flush mount light fixture, Outside flush mount light fixtures, Outside flush mount lighting fixture, Outside flush mount lighting fixtures, Outside flush mount pendant, Outside flush mount pendants, Outside lights, Outside light, Outside lighting, Out side lights, Out side light, Out side lighting, barn light for outside, barn lights for outside, ble-c-gg, ceiling flush mount, nautical sconces, nautical wall sconces, | Flush Mount Guard Sconce | Barn Light Electric | 270.000000 | 1551,1607,1609,1703,1760,1820,1892M | 1366214 | Barn Light Electric Company | 437 | flush-mount-guard-sconce | 1887/1888/1892 | B |