←
Call Now:
Toll-Free:

Bell & Gossett Hoffman Steam Traps

Additional Information

Bell & Gossett - ITT Hoffman steam traps are engineered for dependable condensate removal in steam systems, combining rugged construction with proven performance. The Series H float and thermostatic steam traps utilize a dual-element design that responds quickly to changes in condensate load, ensuring efficient drainage while minimizing steam loss. Their universal four-port connection pattern allows flexible piping orientation, simplifying installation and reducing downtime.

 

Built for industrial and commercial applications, Hoffman traps deliver long service life and reliable operation across a wide range of pressures and capacities. These traps are ideal for heating coils, heat exchangers, steam headers, and other steam-using equipment where effective condensate control enhances system efficiency and reduces energy waste.

 _showSql
0.00023698806762695SET @@collation_connection = @@collation_database
0.00016593933105469SET NAMES utf8
0.0014729499816895SELECT *
FROM information_schema.tables
WHERE table_schema = 'boiler' AND table_name = 'settings'
LIMIT 1;
0.00038290023803711SELECT code, val
FROM settings
0.0003662109375SELECT ip_address
FROM blocked_ips
0.0025060176849365SHOW COLUMNS
FROM catalog_categories
0.0014901161193848SELECT id, parent_id, title, short_title, description, meta_title, meta_kw, template_id, hs_list_id, url, pos, meta_description, meta_tags, status, own_page, `groups`, img, additional_info, image_box_text, natpos, image_box_image, code, shipping_length, shipping_height, shipping_width, shipperhq_group, vendor_id, shipperhq_packing_rule
FROM catalog_categories
WHERE url="itt-hoffman-steam-traps"
0.0012309551239014SHOW COLUMNS
FROM content_pages
0.0011870861053467SELECT p.id, meta_title, meta_descr, meta_kw, p.html, t.html AS tpl, t.id AS tpl_id, p.title as title, t.title as tpl_title
FROM content_pages AS p
INNER JOIN content_templates AS t ON (p.template_id=t.id)
WHERE p.alias="products" AND p.page_type=""
LIMIT 1
0.00034499168395996SELECT *
FROM catalog_categories
WHERE id=368 AND status=1
ORDER BY pos
0.00030207633972168SELECT *
FROM catalog_categories
WHERE id=368 AND status=1
ORDER BY pos
0.00029206275939941SELECT *
FROM catalog_categories
WHERE id=164 AND status=1
ORDER BY pos
0.0021140575408936SHOW COLUMNS
FROM products
0.0049319267272949SHOW COLUMNS
FROM additional_categories
0.0010619163513184SHOW COLUMNS
FROM catalog_categories_groups
0.05485200881958SELECT (
SELECT GROUP_CONCAT(acat.category_id)
FROM additional_categories AS acat
WHERE `products`.id = acat.product_id GROUP BY acat.product_id) AS additional_categories, (
SELECT GROUP_CONCAT(acat.subcategory_id)
FROM additional_categories AS acat
WHERE `products`.id = acat.product_id GROUP BY acat.product_id) AS additional_subcategories, pos AS pos, is_glass AS is_glass, show_image_in_public AS show_image_in_public, `products`.id AS id, title AS title, `products`.category_id AS category_id, image_box_text AS image_box_text, image_box_image AS image_box_image, url AS url, is_rfq AS is_rfq, has_price AS has_price, status AS status, manufacturer_id AS manufacturer_id, del_status AS del_status, IFNULL((
SELECT c.title
FROM catalog_categories AS c
WHERE c.id = `products`.category_id),"") AS category, IFNULL((
SELECT s.title
FROM catalog_categories AS s
WHERE s.id = `products`.category_id),"") AS subcategory, IFNULL((
SELECT s.short_title
FROM catalog_categories AS s
WHERE s.id = `products`.category_id),"") AS subcategory_short_title, IFNULL((
SELECT s.url
FROM catalog_categories AS s
WHERE s.id = `products`.category_id),"") AS category_url, `products`.category_id AS subcategory_id, IFNULL((
SELECT CASE WHEN parent_id=0 THEN id WHEN parent_id > 0 THEN parent_id ELSE "no matter" END AS category
FROM catalog_categories AS d
WHERE d.id=`products`.category_id),"") AS category_id_new, IFNULL((
SELECT s.url
FROM catalog_categories AS s
WHERE s.id = IFNULL((
SELECT CASE WHEN parent_id=0 THEN id WHEN parent_id > 0 THEN parent_id ELSE "no matter" END AS category
FROM catalog_categories AS d
WHERE d.id=`products`.category_id),"")),"") AS subcategory_url, IFNULL((
SELECT k.pos
FROM catalog_categories AS k
WHERE k.id = IFNULL((
SELECT CASE WHEN parent_id=0 THEN id WHEN parent_id > 0 THEN parent_id ELSE "no matter" END AS category
FROM catalog_categories AS d
WHERE d.id=`products`.category_id),"")),"") AS category_pos, IFNULL((
SELECT c.short_title
FROM catalog_categories AS c
WHERE c.id = IFNULL((
SELECT CASE WHEN parent_id=0 THEN id WHEN parent_id > 0 THEN parent_id ELSE "no matter" END AS category
FROM catalog_categories AS d
WHERE d.id=`products`.category_id),"")),"") AS category_title, IFNULL((
SELECT c.title
FROM catalog_categories AS c
WHERE c.id = IFNULL((
SELECT CASE WHEN parent_id=0 THEN id WHEN parent_id > 0 THEN parent_id ELSE "no matter" END AS category
FROM catalog_categories AS d
WHERE d.id=`products`.category_id),"")),"") AS category_title_full, IFNULL((
SELECT k.id
FROM catalog_categories AS k
WHERE k.id = IFNULL((
SELECT CASE WHEN parent_id=0 THEN id WHEN parent_id > 0 THEN parent_id ELSE "no matter" END AS category
FROM catalog_categories AS d
WHERE d.id=`products`.category_id),"")),"") AS category_id_list, IFNULL((
SELECT CASE WHEN parent_id=0 THEN "1" WHEN parent_id > 0 THEN "0" ELSE "no matter" END AS category
FROM catalog_categories AS d
WHERE d.id=`products`.category_id),"") AS without_subcategory, IFNULL((
SELECT g.`groups`
FROM catalog_categories AS g
WHERE g.id = `products`.category_id),"") AS category_groups, IFNULL((
SELECT n.group_id
FROM catalog_categories_groups AS n
WHERE n.id = category_groups),"no-groups") AS subcategory_groups, IFNULL((
SELECT n.own_page
FROM catalog_categories AS n
WHERE n.id =`products`.category_id),"") AS subcategory_own_page

FROM products
WHERE 1 AND (`products`.category_id =368 OR ((
SELECT GROUP_CONCAT(acat.category_id)
FROM additional_categories AS acat
WHERE `products`.id = acat.product_id GROUP BY acat.product_id) LIKE '368' OR (
SELECT GROUP_CONCAT(acat.category_id)
FROM additional_categories AS acat
WHERE `products`.id = acat.product_id GROUP BY acat.product_id) LIKE '368,%' OR (
SELECT GROUP_CONCAT(acat.category_id)
FROM additional_categories AS acat
WHERE `products`.id = acat.product_id GROUP BY acat.product_id) LIKE '%,368,%' OR (
SELECT GROUP_CONCAT(acat.category_id)
FROM additional_categories AS acat
WHERE `products`.id = acat.product_id GROUP BY acat.product_id) LIKE '%,368') OR ((
SELECT GROUP_CONCAT(acat.subcategory_id)
FROM additional_categories AS acat
WHERE `products`.id = acat.product_id GROUP BY acat.product_id) LIKE '368' OR (
SELECT GROUP_CONCAT(acat.subcategory_id)
FROM additional_categories AS acat
WHERE `products`.id = acat.product_id GROUP BY acat.product_id) LIKE '368,%' OR (
SELECT GROUP_CONCAT(acat.subcategory_id)
FROM additional_categories AS acat
WHERE `products`.id = acat.product_id GROUP BY acat.product_id) LIKE '%,368,%' OR (
SELECT GROUP_CONCAT(acat.subcategory_id)
FROM additional_categories AS acat
WHERE `products`.id = acat.product_id GROUP BY acat.product_id) LIKE '%,368') ) AND status =1 AND del_status =1
ORDER BY pos ASC,title ASC
0.0017421245574951SHOW COLUMNS
FROM files
0.00051498413085938SELECT COUNT(*)
FROM files
WHERE 1 AND element_type =1 AND file_category =1 AND element_id =544
0.00036001205444336SELECT id AS id, element_id AS element_id, element_type AS element_type, file_category AS file_category, title AS title, filename AS filename, repository_file_id AS repository_file_id, cdate AS cdate, description AS description, status AS status, alt_text AS alt_text, is_zoom AS is_zoom
FROM files
WHERE 1 AND element_type =1 AND file_category =1 AND element_id =544
ORDER BY cdate DESC
LIMIT 1
0.00030899047851562SELECT COUNT(*)
FROM files
WHERE 1 AND element_type =1 AND file_category =1 AND element_id =545
0.00036191940307617SELECT id AS id, element_id AS element_id, element_type AS element_type, file_category AS file_category, title AS title, filename AS filename, repository_file_id AS repository_file_id, cdate AS cdate, description AS description, status AS status, alt_text AS alt_text, is_zoom AS is_zoom
FROM files
WHERE 1 AND element_type =1 AND file_category =1 AND element_id =545
ORDER BY cdate DESC
LIMIT 1
0.0010600090026855SHOW COLUMNS
FROM product_positions
0.0004580020904541SELECT COUNT(*)
FROM product_positions
WHERE 1 AND category_id =368
0.0011718273162842SHOW COLUMNS
FROM recommended_products
0.0079081058502197SELECT IFNULL((
SELECT rp.id
FROM recommended_products AS rp
WHERE rp.product_id = `products`.id AND rp.for_subcategory_id = 368 AND rp.category_id = 0
LIMIT 1), 0) AS recommended_id, pos AS pos, is_glass AS is_glass, show_image_in_public AS show_image_in_public, `products`.id AS id, title AS title, `products`.category_id AS category_id, image_box_text AS image_box_text, image_box_image AS image_box_image, url AS url, is_rfq AS is_rfq, has_price AS has_price, status AS status, manufacturer_id AS manufacturer_id, del_status AS del_status, IFNULL((
SELECT c.title
FROM catalog_categories AS c
WHERE c.id = `products`.category_id),"") AS category, IFNULL((
SELECT s.title
FROM catalog_categories AS s
WHERE s.id = `products`.category_id),"") AS subcategory, IFNULL((
SELECT s.short_title
FROM catalog_categories AS s
WHERE s.id = `products`.category_id),"") AS subcategory_short_title, IFNULL((
SELECT s.url
FROM catalog_categories AS s
WHERE s.id = `products`.category_id),"") AS category_url, `products`.category_id AS subcategory_id, IFNULL((
SELECT CASE WHEN parent_id=0 THEN id WHEN parent_id > 0 THEN parent_id ELSE "no matter" END AS category
FROM catalog_categories AS d
WHERE d.id=`products`.category_id),"") AS category_id_new, IFNULL((
SELECT s.url
FROM catalog_categories AS s
WHERE s.id = IFNULL((
SELECT CASE WHEN parent_id=0 THEN id WHEN parent_id > 0 THEN parent_id ELSE "no matter" END AS category
FROM catalog_categories AS d
WHERE d.id=`products`.category_id),"")),"") AS subcategory_url, IFNULL((
SELECT k.pos
FROM catalog_categories AS k
WHERE k.id = IFNULL((
SELECT CASE WHEN parent_id=0 THEN id WHEN parent_id > 0 THEN parent_id ELSE "no matter" END AS category
FROM catalog_categories AS d
WHERE d.id=`products`.category_id),"")),"") AS category_pos, IFNULL((
SELECT c.short_title
FROM catalog_categories AS c
WHERE c.id = IFNULL((
SELECT CASE WHEN parent_id=0 THEN id WHEN parent_id > 0 THEN parent_id ELSE "no matter" END AS category
FROM catalog_categories AS d
WHERE d.id=`products`.category_id),"")),"") AS category_title, IFNULL((
SELECT c.title
FROM catalog_categories AS c
WHERE c.id = IFNULL((
SELECT CASE WHEN parent_id=0 THEN id WHEN parent_id > 0 THEN parent_id ELSE "no matter" END AS category
FROM catalog_categories AS d
WHERE d.id=`products`.category_id),"")),"") AS category_title_full, IFNULL((
SELECT k.id
FROM catalog_categories AS k
WHERE k.id = IFNULL((
SELECT CASE WHEN parent_id=0 THEN id WHEN parent_id > 0 THEN parent_id ELSE "no matter" END AS category
FROM catalog_categories AS d
WHERE d.id=`products`.category_id),"")),"") AS category_id_list, IFNULL((
SELECT CASE WHEN parent_id=0 THEN "1" WHEN parent_id > 0 THEN "0" ELSE "no matter" END AS category
FROM catalog_categories AS d
WHERE d.id=`products`.category_id),"") AS without_subcategory, IFNULL((
SELECT g.`groups`
FROM catalog_categories AS g
WHERE g.id = `products`.category_id),"") AS category_groups, IFNULL((
SELECT n.group_id
FROM catalog_categories_groups AS n
WHERE n.id = category_groups),"no-groups") AS subcategory_groups, IFNULL((
SELECT n.own_page
FROM catalog_categories AS n
WHERE n.id =`products`.category_id),"") AS subcategory_own_page

FROM products
WHERE 1 AND status =1 AND del_status =1 AND IFNULL((
SELECT rp.id
FROM recommended_products AS rp
WHERE rp.product_id = `products`.id AND rp.for_subcategory_id = 368 AND rp.category_id = 0
LIMIT 1), 0) > 0
ORDER BY IFNULL((
SELECT rp.id
FROM recommended_products AS rp
WHERE rp.product_id = `products`.id AND rp.for_subcategory_id = 368 AND rp.category_id = 0
LIMIT 1), 0) ASC , title ASC
0.0011091232299805SHOW COLUMNS
FROM ads
0.00030708312988281SELECT COUNT(*)
FROM ads
WHERE 1 AND status =1
0.0010859966278076SHOW COLUMNS
FROM megamenu
0.032377958297729SELECT COUNT(*)
FROM megamenu
WHERE 1
0.00052785873413086SELECT id AS id, title AS title, href AS href, type AS type, parent_id AS parent_id, pos AS pos
FROM megamenu
WHERE 1
ORDER BY id
0.00027799606323242SELECT title
FROM catalog_categories
WHERE id=368
0.00022196769714355SELECT title
FROM catalog_categories
WHERE id=368
0.00021481513977051SELECT title
FROM catalog_categories
WHERE id=368
0.00021505355834961SELECT title
FROM catalog_categories
WHERE id=368
0.00026416778564453SELECT id, parent_id, description, meta_description, short_title, url, title
FROM catalog_categories
WHERE id = '368'
LIMIT 1
Total: 0.12342619895935

 _showPOST
POST is empty