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

Check & Vent Valves | Boiler Supplies

Durabla, Watson McDaniel, & Hoffman Valves
Additional Information

Durabla In-Line Check Valves are built for dependable one-way flow control in steam, liquid, and gas systems. These valves automatically prevent reverse flow to protect pumps, compressors, and critical equipment from backflow damage. With durable construction and multiple size and material options, Durabla valves provide reliable, low-maintenance performance in demanding industrial piping systems.

 

Watson McDaniel WSSCV Check Valves feature all-stainless steel construction for superior corrosion resistance and extended service life. Designed for tight shut-off, they help reduce water hammer and prevent pump recycling by stopping backflow quickly. Standard ¼ PSIG cracking pressure springs are supplied, with optional 5 PSIG springs available for applications requiring greater resistance.

 

Hoffman 62 Vacuum Breakers protect steam and condensate systems from vacuum conditions that can cause pipe damage, improper drainage, or water hammer. By allowing air to enter during low-pressure events, they maintain system balance and safeguard piping during shutdowns and cooling cycles.

 

Check All Valves Check Valves offer a wide range of compact and high-performance designs, including bushing, insert, tubing, and high-pressure models. Suitable for pneumatic, hydraulic, and process systems, these valves provide dependable backflow prevention across a variety of industrial applications.

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.00019407272338867SET @@collation_connection = @@collation_database
0.0001380443572998SET NAMES utf8
0.0013818740844727SELECT *
FROM information_schema.tables
WHERE table_schema = 'boiler' AND table_name = 'settings'
LIMIT 1;
0.0003209114074707SELECT code, val
FROM settings
0.00023889541625977SELECT ip_address
FROM blocked_ips
0.0024051666259766SHOW COLUMNS
FROM catalog_categories
0.00098395347595215SELECT 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="check-valves"
0.0019469261169434SHOW COLUMNS
FROM content_pages
0.00034999847412109SELECT 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.00031900405883789SELECT *
FROM catalog_categories
WHERE id=148 AND status=1
ORDER BY pos
0.00028705596923828SELECT *
FROM catalog_categories
WHERE id=148 AND status=1
ORDER BY pos
0.0032539367675781SHOW COLUMNS
FROM products
0.0018050670623779SHOW COLUMNS
FROM files
0.0016148090362549SHOW COLUMNS
FROM additional_categories
0.0015060901641846SHOW COLUMNS
FROM catalog_categories_groups
0.00035786628723145SELECT COUNT(*)
FROM catalog_categories
WHERE 1 AND parent_id =148 AND status ='1'
0.0009620189666748SELECT id AS id, parent_id AS parent_id, title AS title, short_title AS short_title, description AS description, meta_title AS meta_title, meta_kw AS meta_kw, template_id AS template_id, hs_list_id AS hs_list_id, url AS url, pos AS pos, meta_description AS meta_description, meta_tags AS meta_tags, status AS status, own_page AS own_page, `groups` AS "groups", img AS img, additional_info AS additional_info, image_box_text AS image_box_text, natpos AS natpos, image_box_image AS image_box_image, code AS code, shipping_length AS shipping_length, shipping_height AS shipping_height, shipping_width AS shipping_width, shipperhq_group AS shipperhq_group, vendor_id AS vendor_id, shipperhq_packing_rule AS shipperhq_packing_rule, IFNULL((
SELECT c.group_id
FROM catalog_categories_groups AS c
WHERE c.id = `groups`),"no-groups") AS groupsNumber, IFNULL((
SELECT c.title
FROM catalog_categories_groups AS c
WHERE c.id = `groups`),"no-groups") AS groupsTitle
FROM catalog_categories
WHERE 1 AND parent_id =148 AND status ='1'
ORDER BY groupsNumber ASC,pos ASC,title ASC,short_title ASC
LIMIT 0,100000
0.0002899169921875SELECT id, parent_id
FROM catalog_categories
WHERE parent_id IN ('149', '357', '352')
0.0089378356933594SELECT id, category_id
FROM products
WHERE status = '1'
0.00059413909912109SELECT COUNT(*)
FROM files
WHERE 1 AND element_type =3 AND file_category =1 AND element_id =149
0.00054812431335449SELECT 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 =3 AND file_category =1 AND element_id =149
LIMIT 1
0.0033411979675293SELECT (
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, (
SELECT nac.own_page
FROM catalog_categories AS nac
WHERE nac.id =149) AS loc_subcategory_own_page, 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 =149 OR ((
SELECT GROUP_CONCAT(acat.subcategory_id)
FROM additional_categories AS acat
WHERE `products`.id = acat.product_id GROUP BY acat.product_id) LIKE '149' OR (
SELECT GROUP_CONCAT(acat.subcategory_id)
FROM additional_categories AS acat
WHERE `products`.id = acat.product_id GROUP BY acat.product_id) LIKE '149,%' OR (
SELECT GROUP_CONCAT(acat.subcategory_id)
FROM additional_categories AS acat
WHERE `products`.id = acat.product_id GROUP BY acat.product_id) LIKE '%,149,%' OR (
SELECT GROUP_CONCAT(acat.subcategory_id)
FROM additional_categories AS acat
WHERE `products`.id = acat.product_id GROUP BY acat.product_id) LIKE '%,149') ) AND ((
SELECT nac.own_page
FROM catalog_categories AS nac
WHERE nac.id =149) != 1) AND status =1 AND del_status =1
ORDER BY subcategory_groups ASC,pos ASC,title ASC
0.00046515464782715SELECT COUNT(*)
FROM files
WHERE 1 AND element_type =3 AND file_category =1 AND element_id =357
0.00075507164001465SELECT 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 =3 AND file_category =1 AND element_id =357
LIMIT 1
0.00084590911865234SELECT (
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, (
SELECT nac.own_page
FROM catalog_categories AS nac
WHERE nac.id =357) AS loc_subcategory_own_page, 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 =357 OR ((
SELECT GROUP_CONCAT(acat.subcategory_id)
FROM additional_categories AS acat
WHERE `products`.id = acat.product_id GROUP BY acat.product_id) LIKE '357' OR (
SELECT GROUP_CONCAT(acat.subcategory_id)
FROM additional_categories AS acat
WHERE `products`.id = acat.product_id GROUP BY acat.product_id) LIKE '357,%' OR (
SELECT GROUP_CONCAT(acat.subcategory_id)
FROM additional_categories AS acat
WHERE `products`.id = acat.product_id GROUP BY acat.product_id) LIKE '%,357,%' OR (
SELECT GROUP_CONCAT(acat.subcategory_id)
FROM additional_categories AS acat
WHERE `products`.id = acat.product_id GROUP BY acat.product_id) LIKE '%,357') ) AND ((
SELECT nac.own_page
FROM catalog_categories AS nac
WHERE nac.id =357) != 1) AND status =1 AND del_status =1
ORDER BY subcategory_groups ASC,pos ASC,title ASC
0.00050997734069824SELECT COUNT(*)
FROM files
WHERE 1 AND element_type =3 AND file_category =1 AND element_id =352
0.00051999092102051SELECT 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 =3 AND file_category =1 AND element_id =352
LIMIT 1
0.00081992149353027SELECT (
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, (
SELECT nac.own_page
FROM catalog_categories AS nac
WHERE nac.id =352) AS loc_subcategory_own_page, 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 =352 OR ((
SELECT GROUP_CONCAT(acat.subcategory_id)
FROM additional_categories AS acat
WHERE `products`.id = acat.product_id GROUP BY acat.product_id) LIKE '352' OR (
SELECT GROUP_CONCAT(acat.subcategory_id)
FROM additional_categories AS acat
WHERE `products`.id = acat.product_id GROUP BY acat.product_id) LIKE '352,%' OR (
SELECT GROUP_CONCAT(acat.subcategory_id)
FROM additional_categories AS acat
WHERE `products`.id = acat.product_id GROUP BY acat.product_id) LIKE '%,352,%' OR (
SELECT GROUP_CONCAT(acat.subcategory_id)
FROM additional_categories AS acat
WHERE `products`.id = acat.product_id GROUP BY acat.product_id) LIKE '%,352') ) AND ((
SELECT nac.own_page
FROM catalog_categories AS nac
WHERE nac.id =352) != 1) AND status =1 AND del_status =1
ORDER BY subcategory_groups ASC,pos ASC,title ASC
0.0079720020294189SELECT (
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, IFNULL((
SELECT acat.category_id
FROM additional_categories AS acat
WHERE `products`.id = acat.product_id AND acat.category_id = 148 AND (acat.subcategory_id = 0 OR ISNULL(acat.subcategory_id))
LIMIT 1), "") AS additional_category, 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 =148 OR IFNULL((
SELECT acat.category_id
FROM additional_categories AS acat
WHERE `products`.id = acat.product_id AND acat.category_id = 148 AND (acat.subcategory_id = 0 OR ISNULL(acat.subcategory_id))
LIMIT 1), "")!="" ) AND status =1 AND del_status =1
ORDER BY subcategory_groups ASC,pos ASC,title ASC
0.0057649612426758SHOW COLUMNS
FROM product_positions
0.00048518180847168SELECT COUNT(*)
FROM product_positions
WHERE 1 AND category_id =149
0.00040197372436523SELECT COUNT(*)
FROM product_positions
WHERE 1 AND category_id =357
0.00039482116699219SELECT COUNT(*)
FROM product_positions
WHERE 1 AND category_id =352
0.00040507316589355SELECT COUNT(*)
FROM product_positions
WHERE 1 AND category_id =0
0.0012118816375732SHOW COLUMNS
FROM ads
0.00034213066101074SELECT COUNT(*)
FROM ads
WHERE 1 AND status =1
0.0014169216156006SHOW COLUMNS
FROM megamenu
0.0071649551391602SELECT COUNT(*)
FROM megamenu
WHERE 1
0.00036001205444336SELECT 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.00025391578674316SELECT title
FROM catalog_categories
WHERE id=148
0.00025796890258789SELECT title
FROM catalog_categories
WHERE id=148
0.00025296211242676SELECT title
FROM catalog_categories
WHERE id=148
0.00027799606323242SELECT title
FROM catalog_categories
WHERE id=148
0.00029802322387695SELECT id, parent_id, description, meta_description, short_title, url, title
FROM catalog_categories
WHERE id = '148'
LIMIT 1
Total: 0.06295371055603

 _showPOST
POST is empty