←
Call Now:
Toll-Free:

American Standard Tube Bundles

Additional Information

Cemline tube bundles are precision-engineered replacement cores for shell & tube heat exchangers, designed to restore optimal heat transfer efficiency and dependable system performance. As the removable heat exchange element inside the shell, these bundles allow for easier maintenance, inspection, and replacement—helping reduce downtime and extend equipment life. They are commonly used in steam-to-liquid and liquid-to-liquid applications across commercial and industrial systems.

 

Manufactured from high-quality materials such as copper, stainless steel, cupronickel, naval brass, and carbon steel, Cemline tube bundles are built to withstand demanding operating conditions and fluid chemistries. Standard and custom configurations are available to match existing units, with cross-reference support and measurement guidance to ensure proper fit and performance. Expedited fabrication options are also available for urgent replacement needs.

 _showSql
0.00069499015808105SET @@collation_connection = @@collation_database
0.00056600570678711SET NAMES utf8
0.0016100406646729SELECT *
FROM information_schema.tables
WHERE table_schema = 'boiler' AND table_name = 'settings'
LIMIT 1;
0.00089502334594727SELECT code, val
FROM settings
0.00047492980957031SELECT ip_address
FROM blocked_ips
0.0029671192169189SHOW COLUMNS
FROM catalog_categories
0.0039618015289307SELECT 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="american-standard-tube-bundles-shell-tube"
0.004755973815918SHOW COLUMNS
FROM content_pages
0.0017650127410889SELECT 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.0015840530395508SELECT *
FROM catalog_categories
WHERE id=227 AND status=1
ORDER BY pos
0.00070285797119141SELECT *
FROM catalog_categories
WHERE id=227 AND status=1
ORDER BY pos
0.00052618980407715SELECT *
FROM catalog_categories
WHERE id=1 AND status=1
ORDER BY pos
0.0053708553314209SHOW COLUMNS
FROM products
0.0031318664550781SHOW COLUMNS
FROM additional_categories
0.0015921592712402SHOW COLUMNS
FROM catalog_categories_groups
0.040196895599365SELECT (
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 =227 OR ((
SELECT GROUP_CONCAT(acat.category_id)
FROM additional_categories AS acat
WHERE `products`.id = acat.product_id GROUP BY acat.product_id) LIKE '227' OR (
SELECT GROUP_CONCAT(acat.category_id)
FROM additional_categories AS acat
WHERE `products`.id = acat.product_id GROUP BY acat.product_id) LIKE '227,%' OR (
SELECT GROUP_CONCAT(acat.category_id)
FROM additional_categories AS acat
WHERE `products`.id = acat.product_id GROUP BY acat.product_id) LIKE '%,227,%' OR (
SELECT GROUP_CONCAT(acat.category_id)
FROM additional_categories AS acat
WHERE `products`.id = acat.product_id GROUP BY acat.product_id) LIKE '%,227') OR ((
SELECT GROUP_CONCAT(acat.subcategory_id)
FROM additional_categories AS acat
WHERE `products`.id = acat.product_id GROUP BY acat.product_id) LIKE '227' OR (
SELECT GROUP_CONCAT(acat.subcategory_id)
FROM additional_categories AS acat
WHERE `products`.id = acat.product_id GROUP BY acat.product_id) LIKE '227,%' OR (
SELECT GROUP_CONCAT(acat.subcategory_id)
FROM additional_categories AS acat
WHERE `products`.id = acat.product_id GROUP BY acat.product_id) LIKE '%,227,%' OR (
SELECT GROUP_CONCAT(acat.subcategory_id)
FROM additional_categories AS acat
WHERE `products`.id = acat.product_id GROUP BY acat.product_id) LIKE '%,227') ) AND status =1 AND del_status =1
ORDER BY pos ASC,title ASC
0.006356954574585SHOW COLUMNS
FROM files
0.0018241405487061SELECT COUNT(*)
FROM files
WHERE 1 AND element_type =1 AND file_category =1 AND element_id =10
0.0016820430755615SELECT 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 =10
ORDER BY cdate DESC
LIMIT 1
0.0017499923706055SELECT COUNT(*)
FROM files
WHERE 1 AND element_type =1 AND file_category =1 AND element_id =9
0.0016331672668457SELECT 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 =9
ORDER BY cdate DESC
LIMIT 1
0.00042510032653809SELECT COUNT(*)
FROM files
WHERE 1 AND element_type =1 AND file_category =1 AND element_id =1073
0.00036716461181641SELECT 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 =1073
ORDER BY cdate DESC
LIMIT 1
0.00037193298339844SELECT COUNT(*)
FROM files
WHERE 1 AND element_type =1 AND file_category =1 AND element_id =966
0.00043296813964844SELECT 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 =966
ORDER BY cdate DESC
LIMIT 1
0.00038290023803711SELECT COUNT(*)
FROM files
WHERE 1 AND element_type =1 AND file_category =1 AND element_id =1141
0.00033903121948242SELECT 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 =1141
ORDER BY cdate DESC
LIMIT 1
0.0021388530731201SHOW COLUMNS
FROM product_positions
0.00057697296142578SELECT COUNT(*)
FROM product_positions
WHERE 1 AND category_id =227
0.00044107437133789SELECT id AS id, category_id AS category_id, product_id AS product_id, position AS position
FROM product_positions
WHERE 1 AND category_id =227
0.0021049976348877SHOW COLUMNS
FROM recommended_products
0.01003098487854SELECT IFNULL((
SELECT rp.id
FROM recommended_products AS rp
WHERE rp.product_id = `products`.id AND rp.for_subcategory_id = 227 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 = 227 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 = 227 AND rp.category_id = 0
LIMIT 1), 0) ASC , title ASC
0.0018749237060547SHOW COLUMNS
FROM ads
0.00038504600524902SELECT COUNT(*)
FROM ads
WHERE 1 AND status =1
0.0013079643249512SHOW COLUMNS
FROM megamenu
0.039021968841553SELECT COUNT(*)
FROM megamenu
WHERE 1
0.00055098533630371SELECT 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.00029802322387695SELECT title
FROM catalog_categories
WHERE id=227
0.00022292137145996SELECT title
FROM catalog_categories
WHERE id=227
0.00021791458129883SELECT title
FROM catalog_categories
WHERE id=227
0.00023293495178223SELECT title
FROM catalog_categories
WHERE id=227
0.00027608871459961SELECT id, parent_id, description, meta_description, short_title, url, title
FROM catalog_categories
WHERE id = '227'
LIMIT 1
Total: 0.1460428237915

 _showPOST
POST is empty