←
+
0 Item(s)
Call Now:
1-770-957-9599
Toll-Free:
1-800-780-3776
MY ACCOUNT
Contact Us
0
0 Item(s)

Tankless Water Heater & Steam Boiler Coils

Additional Information

Tankless boiler coils provide an efficient, space-saving method for producing domestic hot water directly from a steam or hot water boiler. Installed inside the boiler, these finned copper coils act as heat exchangers—transferring heat from the boiler water to cold water flowing through the coil, delivering hot water on demand. 

 

Because water is heated only when needed, tankless coils eliminate standby heat loss associated with traditional storage tanks. This makes them especially effective in colder climates where boilers operate frequently for space heating. 

 

These coils are commonly used in oil- and gas-fired boiler systems and are available for a wide range of boiler makes and models. Proper sizing and compatibility are important to ensure adequate hot water output, as performance depends on boiler temperature and system demand.

 

Tankless coils are a practical solution for applications where space is limited or where a dedicated water heater is not required. They are also well-suited for retrofit situations, allowing replacement of existing coils without major system modifications.

 

Routine maintenance—such as cleaning or descaling—is recommended to prevent mineral buildup and maintain heat transfer efficiency over time. When properly maintained, tankless coils offer reliable, on-demand hot water with a simple and durable design.

In-stock orders eligible for small-pack shipments placed before 2:00 PM EST, Monday through Friday, will ship the same day. If ordered after 2:00PM EST, it will ship the following business day.

Items to be returned must be approved by Power Plus International, Inc. DBA Boiler USA, and may be subjected to a restocking fee

Notice: Due to the uncontrollable metal costs, all prices and delivery times are subject to change on a daily basis.

PPI™ and Power Plus International™, and related marks and logos displayed on the Site, are our trademarks and may not be used in any way without our prior express written permission. Nothing contained on the Site shall be construed as granting, by implication, estoppel or otherwise, any license or right to use any of our marks displayed on the Site without our prior express written permission. All other trademarks not owned by us that appear on this Site are the property of their respective owners.

*NOTE: The products described herein are not manufactured by Patterson-Kelley nor is Power Plus International, Inc. DBA Boiler USA in any way associated or affiliated with "PK", Patterson-Kelley, or Harsco Corporation.

Contact Us Directly:
Mailing Address:
  • Power Plus International, Inc. DBA Boiler USA
  • 143 McDonough Parkway
  • McDonough, GA 30253
Contact Us Directly:
credit_cards

© 2026 Power Plus International, Inc. d/b/a Boiler USA, All Rights Reserved.
Mailing Address:
  • Power Plus International, Inc. DBA Boiler USA
  • 143 McDonough Parkway
  • McDonough, GA 30253
 _showSql
0.00022602081298828SET @@collation_connection = @@collation_database
0.0001530647277832SET NAMES utf8
0.0050289630889893SELECT *
FROM information_schema.tables
WHERE table_schema = 'boiler' AND table_name = 'settings'
LIMIT 1;
0.0003969669342041SELECT code, val
FROM settings
0.0012941360473633SELECT ip_address
FROM blocked_ips
0.0026140213012695SHOW COLUMNS
FROM catalog_categories
0.0012781620025635SELECT 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="tankless-water-heater---steam-boiler-coils"
0.0030858516693115SHOW COLUMNS
FROM content_pages
0.0022010803222656SELECT 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.00043988227844238SELECT *
FROM catalog_categories
WHERE id=391 AND status=1
ORDER BY pos
0.00040507316589355SELECT *
FROM catalog_categories
WHERE id=391 AND status=1
ORDER BY pos
0.00041294097900391SELECT *
FROM catalog_categories
WHERE id=242 AND status=1
ORDER BY pos
0.0043809413909912SHOW COLUMNS
FROM products
0.001662015914917SHOW COLUMNS
FROM additional_categories
0.0015349388122559SHOW COLUMNS
FROM catalog_categories_groups
0.041530847549438SELECT (
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 =391 OR ((
SELECT GROUP_CONCAT(acat.category_id)
FROM additional_categories AS acat
WHERE `products`.id = acat.product_id GROUP BY acat.product_id) LIKE '391' OR (
SELECT GROUP_CONCAT(acat.category_id)
FROM additional_categories AS acat
WHERE `products`.id = acat.product_id GROUP BY acat.product_id) LIKE '391,%' OR (
SELECT GROUP_CONCAT(acat.category_id)
FROM additional_categories AS acat
WHERE `products`.id = acat.product_id GROUP BY acat.product_id) LIKE '%,391,%' OR (
SELECT GROUP_CONCAT(acat.category_id)
FROM additional_categories AS acat
WHERE `products`.id = acat.product_id GROUP BY acat.product_id) LIKE '%,391') OR ((
SELECT GROUP_CONCAT(acat.subcategory_id)
FROM additional_categories AS acat
WHERE `products`.id = acat.product_id GROUP BY acat.product_id) LIKE '391' OR (
SELECT GROUP_CONCAT(acat.subcategory_id)
FROM additional_categories AS acat
WHERE `products`.id = acat.product_id GROUP BY acat.product_id) LIKE '391,%' OR (
SELECT GROUP_CONCAT(acat.subcategory_id)
FROM additional_categories AS acat
WHERE `products`.id = acat.product_id GROUP BY acat.product_id) LIKE '%,391,%' OR (
SELECT GROUP_CONCAT(acat.subcategory_id)
FROM additional_categories AS acat
WHERE `products`.id = acat.product_id GROUP BY acat.product_id) LIKE '%,391') ) AND status =1 AND del_status =1
ORDER BY pos ASC,title ASC
0.0086169242858887SHOW COLUMNS
FROM files
0.00054311752319336SELECT COUNT(*)
FROM files
WHERE 1 AND element_type =1 AND file_category =1 AND element_id =669
0.00038599967956543SELECT 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 =669
ORDER BY cdate DESC
LIMIT 1
0.00033092498779297SELECT COUNT(*)
FROM files
WHERE 1 AND element_type =1 AND file_category =1 AND element_id =686
0.00038003921508789SELECT 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 =686
ORDER BY cdate DESC
LIMIT 1
0.00032806396484375SELECT COUNT(*)
FROM files
WHERE 1 AND element_type =1 AND file_category =1 AND element_id =671
0.0003972053527832SELECT 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 =671
ORDER BY cdate DESC
LIMIT 1
0.00035905838012695SELECT COUNT(*)
FROM files
WHERE 1 AND element_type =1 AND file_category =1 AND element_id =687
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 =687
ORDER BY cdate DESC
LIMIT 1
0.0003209114074707SELECT COUNT(*)
FROM files
WHERE 1 AND element_type =1 AND file_category =1 AND element_id =694
0.00035190582275391SELECT 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 =694
ORDER BY cdate DESC
LIMIT 1
0.00031208992004395SELECT COUNT(*)
FROM files
WHERE 1 AND element_type =1 AND file_category =1 AND element_id =685
0.00034999847412109SELECT 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 =685
ORDER BY cdate DESC
LIMIT 1
0.00033378601074219SELECT COUNT(*)
FROM files
WHERE 1 AND element_type =1 AND file_category =1 AND element_id =672
0.00035595893859863SELECT 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 =672
ORDER BY cdate DESC
LIMIT 1
0.00031781196594238SELECT COUNT(*)
FROM files
WHERE 1 AND element_type =1 AND file_category =1 AND element_id =693
0.00034999847412109SELECT 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 =693
ORDER BY cdate DESC
LIMIT 1
0.00031018257141113SELECT COUNT(*)
FROM files
WHERE 1 AND element_type =1 AND file_category =1 AND element_id =683
0.00039005279541016SELECT 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 =683
ORDER BY cdate DESC
LIMIT 1
0.00050997734069824SELECT COUNT(*)
FROM files
WHERE 1 AND element_type =1 AND file_category =1 AND element_id =673
0.00034785270690918SELECT 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 =673
ORDER BY cdate DESC
LIMIT 1
0.00031399726867676SELECT COUNT(*)
FROM files
WHERE 1 AND element_type =1 AND file_category =1 AND element_id =692
0.00034809112548828SELECT 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 =692
ORDER BY cdate DESC
LIMIT 1
0.00030899047851562SELECT COUNT(*)
FROM files
WHERE 1 AND element_type =1 AND file_category =1 AND element_id =679
0.00034093856811523SELECT 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 =679
ORDER BY cdate DESC
LIMIT 1
0.00031495094299316SELECT COUNT(*)
FROM files
WHERE 1 AND element_type =1 AND file_category =1 AND element_id =674
0.00035500526428223SELECT 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 =674
ORDER BY cdate DESC
LIMIT 1
0.00031781196594238SELECT COUNT(*)
FROM files
WHERE 1 AND element_type =1 AND file_category =1 AND element_id =691
0.00034809112548828SELECT 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 =691
ORDER BY cdate DESC
LIMIT 1
0.00032997131347656SELECT COUNT(*)
FROM files
WHERE 1 AND element_type =1 AND file_category =1 AND element_id =677
0.00033998489379883SELECT 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 =677
ORDER BY cdate DESC
LIMIT 1
0.00031590461730957SELECT COUNT(*)
FROM files
WHERE 1 AND element_type =1 AND file_category =1 AND element_id =678
0.00034213066101074SELECT 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 =678
ORDER BY cdate DESC
LIMIT 1
0.00031208992004395SELECT COUNT(*)
FROM files
WHERE 1 AND element_type =1 AND file_category =1 AND element_id =689
0.00035405158996582SELECT 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 =689
ORDER BY cdate DESC
LIMIT 1
0.0003199577331543SELECT COUNT(*)
FROM files
WHERE 1 AND element_type =1 AND file_category =1 AND element_id =676
0.00041103363037109SELECT 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 =676
ORDER BY cdate DESC
LIMIT 1
0.00034284591674805SELECT COUNT(*)
FROM files
WHERE 1 AND element_type =1 AND file_category =1 AND element_id =680
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 =680
ORDER BY cdate DESC
LIMIT 1
0.00039291381835938SELECT COUNT(*)
FROM files
WHERE 1 AND element_type =1 AND file_category =1 AND element_id =688
0.00047802925109863SELECT 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 =688
ORDER BY cdate DESC
LIMIT 1
0.00030899047851562SELECT COUNT(*)
FROM files
WHERE 1 AND element_type =1 AND file_category =1 AND element_id =675
0.00034189224243164SELECT 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 =675
ORDER BY cdate DESC
LIMIT 1
0.00036716461181641SELECT COUNT(*)
FROM files
WHERE 1 AND element_type =1 AND file_category =1 AND element_id =681
0.00033998489379883SELECT 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 =681
ORDER BY cdate DESC
LIMIT 1
0.00030708312988281SELECT COUNT(*)
FROM files
WHERE 1 AND element_type =1 AND file_category =1 AND element_id =682
0.00033998489379883SELECT 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 =682
ORDER BY cdate DESC
LIMIT 1
0.00031614303588867SELECT COUNT(*)
FROM files
WHERE 1 AND element_type =1 AND file_category =1 AND element_id =670
0.00034999847412109SELECT 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 =670
ORDER BY cdate DESC
LIMIT 1
0.00030517578125SELECT COUNT(*)
FROM files
WHERE 1 AND element_type =1 AND file_category =1 AND element_id =684
0.00037121772766113SELECT 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 =684
ORDER BY cdate DESC
LIMIT 1
0.0019338130950928SHOW COLUMNS
FROM product_positions
0.00051093101501465SELECT COUNT(*)
FROM product_positions
WHERE 1 AND category_id =391
0.0015900135040283SHOW COLUMNS
FROM recommended_products
0.0089011192321777SELECT IFNULL((
SELECT rp.id
FROM recommended_products AS rp
WHERE rp.product_id = `products`.id AND rp.for_subcategory_id = 391 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 = 391 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 = 391 AND rp.category_id = 0
LIMIT 1), 0) ASC , title ASC
0.0026390552520752SHOW COLUMNS
FROM ads
0.00035786628723145SELECT COUNT(*)
FROM ads
WHERE 1 AND status =1
0.0016610622406006SHOW COLUMNS
FROM megamenu
0.036992073059082SELECT COUNT(*)
FROM megamenu
WHERE 1
0.00061702728271484SELECT 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.00029897689819336SELECT title
FROM catalog_categories
WHERE id=391
0.000244140625SELECT title
FROM catalog_categories
WHERE id=391
0.00023484230041504SELECT title
FROM catalog_categories
WHERE id=391
0.00023221969604492SELECT title
FROM catalog_categories
WHERE id=391
0.00032401084899902SELECT id, parent_id, description, meta_description, short_title, url, title
FROM catalog_categories
WHERE id = '391'
LIMIT 1
Total: 0.14942836761475

 _showPOST
POST is empty