←
Call Now:
Toll-Free:

Sterling 150-G Series Heating & Cooling Valves In Stock

Item Name:

Sterling 150-G Series for Heating

Description:

Sterling/Sterlco D150-G/R150-G Series Self-modulating Temperature Control Valves are simple yet efficient designs requiring minimum maintenance. Heavy duty construction assures long valve life. Valves are temperature actuated, self-powered, fully balanced, and applicable to heating (D150-F) or cooling (R150-F) processes using water, oil, steam or other fluids

 

Note that the "150-F" series is now the "150-G" series

 

Direct Acting (Closes on rising temperature)

Pressure Rating: 0 - 125 lbs

Standard Capillary: 6 FT

 

Typical Applications:

  • Hot Water Storage Tanks, Food Processing, Pre-heater For Boiler Feed Pumps, Shrink Wrap Equipment (Meat Processing & Packaging), Bottle Washing Operations, Asphalt Processing, Cheese Factories, Dairies, Candy Operations, Degreasing Tanks

 

Shipping Time: 1-3 Business Day
Specifications
Part # Inlet
Outlet Size
Select
Temp Range
Description Price Qty  
D-150-G-55-95 1/2" 55° - 95° F 1/2" Sterling 150-G Series for Heating $803.57 Add to Cart
D-150-G-80-170 1/2" 80° - 170° F 1/2" Sterling 150-G Series for Heating $803.57 Add to Cart
D-150-G-85-125 1/2" 85° - 125° F 1/2" Sterling 150-G Series for Heating $803.57 Add to Cart
D-150-G-105-145 1/2" 105° - 145° F 1/2" Sterling 150-G Series for Heating $803.57 Add to Cart
D-150-G-130-170 1/2" 130° - 170° F 1/2" Sterling 150-G Series for Heating $803.57 Add to Cart
D-150-G-150-190 1/2" 150° - 190° F 1/2" Sterling 150-G Series for Heating $803.57 Add to Cart
D-150-G-110-190 1/2" 110° - 190° F 1/2" Sterling 150-G Series for Heating $803.57 Add to Cart
D-150-G-175-215 1/2" 175° - 215° F 1/2" Sterling 150-G Series for Heating $803.57 Add to Cart
D-151-G-55-95 3/4" 55° - 95° F 3/4" Sterling 150-G Series for Heating $819.29 Add to Cart
D-151-G-80-170 3/4" 80° - 170° F 3/4" Sterling 150-G Series for Heating $819.29 Add to Cart
D-151-G-85-125 3/4" 85° - 125° F 3/4" Sterling 150-G Series for Heating $819.29 Add to Cart
D-151-G-105-145 3/4" 105° - 145° F 3/4" Sterling 150-G Series for Heating $819.29 Add to Cart
D-151-G-130-170 3/4" 130° - 170° F 3/4" Sterling 150-G Series for Heating $819.29 Add to Cart
D-151-G-150-190 3/4" 150° - 190° F 3/4" Sterling 150-G Series for Heating $819.29 Add to Cart
D-151-G-110-190 3/4" 110° - 190° F 3/4" Sterling 150-G Series for Heating $819.29 Add to Cart
D-151-G-175-215 3/4" 175° - 215° F 3/4" Sterling 150-G Series for Heating $819.29 Add to Cart
D-152-G-55-95 1" 55° - 95° F 1" Sterling 150-G Series for Heating $862.14 Add to Cart
D-152-G-80-170 1" 80° - 170° F 1" Sterling 150-G Series for Heating $862.14 Add to Cart
D-152-G-85-125 1" 85° - 125° F 1" Sterling 150-G Series for Heating $862.14 Add to Cart
D-152-G-105-145 1" 105° - 145° F 1" Sterling 150-G Series for Heating $862.14 Add to Cart
D-152-G-130-170 1" 130° - 170° F 1" Sterling 150-G Series for Heating $862.14 Add to Cart
D-152-G-150-190 1" 150° - 190° F 1" Sterling 150-G Series for Heating $862.14 Add to Cart
D-152-G-110-190 1" 110° - 190° F 1" Sterling 150-G Series for Heating $862.14 Add to Cart
D-152-G-175-215 1" 175° - 215° F 1" Sterling 150-G Series for Heating $862.14 Add to Cart
Item Name:

Sterling 150-G Series for Cooling

Description:

Reverse Acting (Opens on rising temperature)

Pressure Rating: 0 - 125 lbs

Standard Capillary: 6 FT

 

Typical Applications:

  • Heat Exchanger Applications, Hydraulic Oil Cooling, Air Compressors, Water Cooled Aftercoolers, Vapor Type Degreasers, Liquid Cooled Electronic Units

 

Shipping Time: 1-3 Business Day
Specifications
Part # Inlet
Outlet Size
Select
Temp Range
Description Price Qty  
R-150-G-55-95 1/2" 55° - 95° F 1/2" Sterling 150-G Series for Cooling $803.57 Add to Cart
R-150-G-80-170 1/2" 80° - 170° F 1/2" Sterling 150-G Series for Cooling $803.57 Add to Cart
R-150-G-85-125 1/2" 85° - 125° F 1/2" Sterling 150-G Series for Cooling $803.57 Add to Cart
R-150-G-105-145 1/2" 105° - 145° F 1/2" Sterling 150-G Series for Cooling $803.57 Add to Cart
R-150-G-130-170 1/2" 130° - 170° F 1/2" Sterling 150-G Series for Cooling $803.57 Add to Cart
R-150-G-150-190 1/2" 150° - 190° F 1/2" Sterling 150-G Series for Cooling $803.57 Add to Cart
R-150-G-110-190 1/2" 110° - 190° F 1/2" Sterling 150-G Series for Cooling $803.57 Add to Cart
R-150-G-175-215 1/2" 175° - 215° F 1/2" Sterling 150-G Series for Cooling $803.57 Add to Cart
R-151-G-55-95 3/4" 55° - 95° F 3/4" Sterling 150-G Series for Cooling $819.29 Add to Cart
R-151-G-80-170 3/4" 80° - 170° F 3/4" Sterling 150-G Series for Cooling $819.29 Add to Cart
R-151-G-85-125 3/4" 85° - 125° F 3/4" Sterling 150-G Series for Cooling $819.29 Add to Cart
R-151-G-105-145 3/4" 105° - 145° F 3/4" Sterling 150-G Series for Cooling $819.29 Add to Cart
R-151-G-130-170 3/4" 130° - 170° F 3/4" Sterling 150-G Series for Cooling $819.29 Add to Cart
R-151-G-150-190 3/4" 150° - 190° F 3/4" Sterling 150-G Series for Cooling $819.29 Add to Cart
R-151-G-110-190 3/4" 110° - 190° F 3/4" Sterling 150-G Series for Cooling $819.29 Add to Cart
R-151-G-175-215 3/4" 175° - 215° F 3/4" Sterling 150-G Series for Cooling $819.29 Add to Cart
R-152-G-55-95 1" 55° - 95° F 1" Sterling 150-G Series for Cooling $862.14 Add to Cart
R-152-G-80-170 1" 80° - 170° F 1" Sterling 150-G Series for Cooling $862.14 Add to Cart
R-152-G-85-125 1" 85° - 125° F 1" Sterling 150-G Series for Cooling $862.14 Add to Cart
R-152-G-105-145 1" 105° - 145° F 1" Sterling 150-G Series for Cooling $862.14 Add to Cart
R-152-G-130-170 1" 130° - 170° F 1" Sterling 150-G Series for Cooling $862.14 Add to Cart
R-152-G-150-190 1" 150° - 190° F 1" Sterling 150-G Series for Cooling $862.14 Add to Cart
R-152-G-110-190 1" 110° - 190° F 1" Sterling 150-G Series for Cooling $862.14 Add to Cart
R-152-G-175-215 1" 175° - 215° F 1" Sterling 150-G Series for Cooling $862.14 Add to Cart
Other Recommended Products:
 _showSql
0.00022315979003906SET @@collation_connection = @@collation_database
0.00016212463378906SET NAMES utf8
0.0018410682678223SELECT *
FROM information_schema.tables
WHERE table_schema = 'boiler' AND table_name = 'settings'
LIMIT 1;
0.0003509521484375SELECT code, val
FROM settings
0.00033807754516602SELECT ip_address
FROM blocked_ips
0.0030131340026855SHOW COLUMNS
FROM products
0.00032281875610352SELECT id
FROM products
WHERE url = 'sterling-150-f-series'
LIMIT 1
0.00039911270141602SELECT id, url, category_id
FROM products
WHERE id = '345' OR url = '345'
LIMIT 1
0.00030398368835449SELECT url, title, own_page, parent_id
FROM catalog_categories
WHERE id = '355'
LIMIT 1
0.00024914741516113SELECT url, title, own_page, parent_id
FROM catalog_categories
WHERE id = '119'
LIMIT 1
0.0037171840667725SHOW COLUMNS
FROM content_pages
0.0020039081573486SELECT 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="product" AND p.page_type=""
LIMIT 1
0.0019819736480713SHOW COLUMNS
FROM manufactures
0.0016138553619385SHOW COLUMNS
FROM catalog_categories
0.00028109550476074SELECT COUNT(*)
FROM products
WHERE 1 AND id =345
0.001060962677002SELECT id AS id, title AS title, code AS code, cdate AS cdate, category_id AS category_id, manufacturer_id AS manufacturer_id, description AS description, faq_header AS faq_header, faq_content AS faq_content, show_faq_in_detail AS show_faq_in_detail, meta_title AS meta_title, meta_description AS meta_description, meta_tags AS meta_tags, url AS url, status AS status, del_status AS del_status, request_quote AS request_quote, quote_description AS quote_description, hs_code AS hs_code, is_rfq AS is_rfq, list_id AS list_id, show_image_in_public AS show_image_in_public, has_price AS has_price, is_taxable AS is_taxable, hs_list_id AS hs_list_id, is_ups AS is_ups, vendor_id AS vendor_id, pos AS pos, natpos AS natpos, lead_time AS lead_time, image_box_text AS image_box_text, image_box_image AS image_box_image, is_glass AS is_glass, glass_increment AS glass_increment, glass_longest_length AS glass_longest_length, glass_od AS glass_od, glass_settings AS glass_settings, infusionsoft_form_id AS infusionsoft_form_id, qb_list_id AS qb_list_id, qb_log AS qb_log, qb_udate AS qb_udate, qb_error AS qb_error, product_code AS product_code, show_images_in_detail AS show_images_in_detail, show_description_in_detail AS show_description_in_detail, use_structured_data_tag AS use_structured_data_tag, discount_group_id AS discount_group_id, netsuite_id AS netsuite_id, jotform_id AS jotform_id, IFNULL((
SELECT m.title
FROM manufactures AS m
WHERE m.id = manufacturer_id ),"") AS manufacturer, 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=category_id),"") AS category_id_new, IFNULL((
SELECT s.url
FROM catalog_categories AS s
WHERE s.id = category_id_new),"") AS category_url, IFNULL((
SELECT s.url
FROM catalog_categories AS s
WHERE s.id = category_id),"") AS subcategory_url, IFNULL((
SELECT s.status
FROM catalog_categories AS s
WHERE s.id = category_id_new),"") AS category_status, IFNULL((
SELECT s.status
FROM catalog_categories AS s
WHERE s.id = category_id),"") AS subcategory_status, IFNULL((
SELECT IFNULL(s.title, s.short_title)
FROM catalog_categories AS s
WHERE s.id = category_id_new),"") AS category_title, IFNULL((
SELECT IFNULL(s.title, s.short_title)
FROM catalog_categories AS s
WHERE s.id = category_id),"") AS subcategory_title, IFNULL((
SELECT n.own_page
FROM catalog_categories AS n
WHERE n.id =category_id),"") AS subcategory_own_page
FROM products
WHERE 1 AND id =345
LIMIT 1
0.0018901824951172SHOW COLUMNS
FROM files
0.00046181678771973SELECT *
FROM files
WHERE element_type = 1 AND element_id = 345
ORDER BY file_category
0.00030112266540527SELECT *
FROM catalog_categories
WHERE id=355 AND status=1
ORDER BY pos
0.00027918815612793SELECT *
FROM catalog_categories
WHERE id=119 AND status=1
ORDER BY pos
0.0014801025390625SHOW COLUMNS
FROM recommended_products
0.0024368762969971SELECT product_id
FROM recommended_products
WHERE category_id =0 AND for_product_id=345
0.0015590190887451SHOW COLUMNS
FROM catalog_categories_groups
0.0030858516693115SELECT IFNULL((
SELECT rp.id
FROM recommended_products AS rp
WHERE rp.product_id = `products`.id AND rp.for_subcategory_id = 0 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 `products`.id IN (344, 1049, 346, 347) AND IFNULL((
SELECT rp.id
FROM recommended_products AS rp
WHERE rp.product_id = `products`.id AND rp.for_subcategory_id = 0 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 = 0 AND rp.category_id = 0
LIMIT 1), 0) ASC , title ASC
0.0026350021362305SELECT COUNT(*)
FROM files
WHERE 1 AND element_type =1 AND file_category =1 AND element_id =347
0.0013120174407959SELECT 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 =347
ORDER BY cdate DESC
LIMIT 1
0.00033187866210938SELECT COUNT(*)
FROM files
WHERE 1 AND element_type =1 AND file_category =1 AND element_id =1049
0.00034594535827637SELECT 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 =1049
ORDER BY cdate DESC
LIMIT 1
0.00031900405883789SELECT COUNT(*)
FROM files
WHERE 1 AND element_type =1 AND file_category =1 AND element_id =344
0.00033879280090332SELECT 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 =344
ORDER BY cdate DESC
LIMIT 1
0.00032186508178711SELECT COUNT(*)
FROM files
WHERE 1 AND element_type =1 AND file_category =1 AND element_id =346
0.00034713745117188SELECT 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 =346
ORDER BY cdate DESC
LIMIT 1
0.002856969833374SHOW COLUMNS
FROM items
0.0016028881072998SHOW COLUMNS
FROM custom_attributes
0.0015749931335449SHOW COLUMNS
FROM attribute_values
0.0059070587158203SHOW COLUMNS
FROM table_rows
0.001823902130127SHOW COLUMNS
FROM item2table
0.00046896934509277SELECT DISTINCT manufactures.title AS manufacturer
FROM products
INNER JOIN manufactures ON (manufactures.id = products.manufacturer_id)
WHERE products.id = '345'
LIMIT 1
0.0033700466156006SELECT it.id AS id, it.product_id AS product_id, it.title AS title, it.item_number AS item_number, it.cdate AS cdate, it.short_description AS short_description, it.description AS description, it.price AS price, it.item_weight AS item_weight, it.item_volume AS item_volume, it.status AS status, it.show_image_in_public AS show_image_in_public, it.ignore_inventory_qty AS ignore_inventory_qty, it.hs_form_guid AS hs_form_guid, it.natpos AS natpos, it.pos AS pos, it.lead_time AS lead_time, it.is_glass AS is_glass, it.shipping_length AS shipping_length, it.shipping_height AS shipping_height, it.shipping_width AS shipping_width, it.shipperhq_group AS shipperhq_group, it.vendor_id AS vendor_id, it.shipperhq_packing_rule AS shipperhq_packing_rule, it.lead_time_label AS lead_time_label, it.lead_time_option AS lead_time_option, it.netsuite_id AS netsuite_id
FROM items AS it
WHERE 1 AND it.product_id =345 AND it.status =1 AND (it.title != "" OR it.item_number != "" OR it.short_description != "" OR it.description != "" OR it.price NOT IN("0", "0.0", "0.00") OR it.item_weight !=0 OR it.item_volume != 0 OR (
SELECT count(av.id) AS count
FROM attribute_values AS av
LEFT JOIN custom_attributes AS ca ON (av.attribute_id = ca.id AND ca.status = 1)
LEFT JOIN items AS i ON (av.item_id = i.id AND i.status = 1)
WHERE av.item_id = it.id) > 0 OR (
SELECT count(tr.id) AS count
FROM table_rows AS tr
LEFT JOIN item2table AS i2t ON (tr.item_table = i2t.id AND i2t.status = 1)
LEFT JOIN items AS i2 ON (i2t.item_id = i2.id AND i2.status = 1)
WHERE i2t.item_id = it.id) > 1)
ORDER BY pos ASC, natpos ASC
0.0021319389343262SHOW COLUMNS
FROM custom_tables
0.0018608570098877SHOW COLUMNS
FROM table_field_values
0.0023908615112305SHOW COLUMNS
FROM table_field_names
0.00040698051452637SELECT id, product_id, title, item_number, cdate, short_description, description, price, item_weight, item_volume, status, show_image_in_public, ignore_inventory_qty, hs_form_guid, natpos, pos, lead_time, is_glass, shipping_length, shipping_height, shipping_width, shipperhq_group, vendor_id, shipperhq_packing_rule, lead_time_label, lead_time_option, netsuite_id
FROM items
WHERE id="535"
0.0007781982421875SELECT t.id AS id, t.product_id AS product_id, t.temp_title AS temp_title, t.title AS title, t.comment AS comment, t.status AS status, t.count_cell AS count_cell, t.is_rfq AS is_rfq, t.pos AS pos, t.uid AS uid, t.is_modal AS is_modal, t.is_grouped_by_column AS is_grouped_by_column, t.group_by_column_name AS group_by_column_name, t.form_type_input_field AS form_type_input_field, t.form_type_input_field2 AS form_type_input_field2, t.form_type_input_field3 AS form_type_input_field3, t.form_type_input_field4 AS form_type_input_field4, t.netsuite_price_level_id AS netsuite_price_level_id, it.status AS table_status, it.item_id AS item_id, it.id AS item2table_id, it.is_dropdown AS is_table_dropdown, it.is_show_qty_on_hand AS is_show_qty_on_hand, it.show_netsuite_sales_description AS show_netsuite_sales_description, it.show_netsuite_images AS show_netsuite_images
FROM custom_tables AS t
INNER JOIN item2table AS it on ( it.table_id = t.id AND it.status IN(1) )
INNER JOIN items AS i on ( it.item_id = i.id AND t.product_id = i.product_id AND i.status IN(1) )
WHERE 1 AND it.item_id =535 AND t.status IN(1) AND t.product_id =345 AND it.status IN(1) GROUP BY t.id, it.id
ORDER by t.pos ASC
0.0083839893341064SELECT tv.id AS id, tv.field_id AS field_id, tv.row_id AS row_id, tv.val AS val, tv.status AS status, tv.is_dropdown AS is_dropdown, it.table_id AS table_id, tr.cart_type AS row_cart_type, tr.pos AS row_pos, tr.qty AS qty, tr.sales_description AS sales_description, tf.pos AS col_pos, tf.title AS col_title, it.item_id AS item_id, tf.is_part_number_field AS is_part_number_field, tf.is_price_field AS is_price_field, tf.is_weight_field AS is_weight_field, tf.is_input_field AS is_input_field, tf.is_input_field2 AS is_input_field2, tf.is_input_field3 AS is_input_field3, tf.is_input_field4 AS is_input_field4, tf.input_field_options AS input_field_options, tf.input_field_options2 AS input_field_options2, tf.input_field_options3 AS input_field_options3, tf.input_field_options4 AS input_field_options4, tf.is_mandatory AS is_mandatory, tf.is_include_to_url AS is_include_to_url, tf.is_hide_
from_user AS is_hide_
from_user
FROM table_field_values AS tv
INNER JOIN table_rows AS tr ON ( tr.id = tv.row_id AND tr.status IN(1) )
INNER JOIN item2table AS it ON ( it.id = tr.item_table AND it.status IN(1) )
INNER JOIN table_field_names AS tf ON ( tf.id = tv.field_id AND tf.status IN(1) )
INNER JOIN items AS i ON ( i.id = it.item_id AND i.status IN(1) )
WHERE 1 AND it.item_id =535 AND it.table_id =502 AND tv.status IN(1)
ORDER BY it.table_id, tr.pos ASC, tv.row_id, tf.pos, tv.field_id
0.0023910999298096SHOW COLUMNS
FROM table_field_values_dropdown
0.00043582916259766SELECT COUNT(*)
FROM item2table
WHERE 1 AND item_id =535 AND table_id =502
0.00033712387084961SELECT id AS id, table_id AS table_id, item_id AS item_id, status AS status, is_dropdown AS is_dropdown, is_show_qty_on_hand AS is_show_qty_on_hand, show_netsuite_images AS show_netsuite_images, show_netsuite_sales_description AS show_netsuite_sales_description
FROM item2table
WHERE 1 AND item_id =535 AND table_id =502
LIMIT 1
0.0016510486602783SHOW COLUMNS
FROM table_row_images
0.0016679763793945SHOW COLUMNS
FROM media_files
0.0091519355773926SELECT f.id AS `file_id`, tr.id AS `id`, f.name AS `name`, f.position AS `position`
FROM table_rows AS tr
INNER JOIN table_row_images AS f ON (tr.netsuite_id = f.row_netsuite_id) AND (f.row_netsuite_id > 0)
WHERE tr.id IN (7968,7969,7970,22440,22441,22442,22443,22444,22445,22446,22447,22448,22449,22450,22451,22452,22453,22454,22455,22456,22457,22458,22459,22460)
ORDER BY f.position ASC
0.00047612190246582SELECT COUNT(*)
FROM table_field_names
WHERE 1 AND status IN(1) AND table_id =502
0.0004570484161377SELECT id AS id, temp_title AS temp_title, table_id AS table_id, title AS title, status AS status, is_price_field AS is_price_field, is_weight_field AS is_weight_field, is_input_field AS is_input_field, is_input_field2 AS is_input_field2, is_mandatory AS is_mandatory, pos AS pos, is_include_to_url AS is_include_to_url, is_hide_
from_user AS is_hide_
from_user, is_part_number_field AS is_part_number_field, is_input_field3 AS is_input_field3, is_input_field4 AS is_input_field4, input_field_options AS input_field_options, input_field_options2 AS input_field_options2, input_field_options3 AS input_field_options3, input_field_options4 AS input_field_options4, structured_data_additional_property_id AS structured_data_additional_property_id, id AS cell_id
FROM table_field_names
WHERE 1 AND status IN(1) AND table_id =502
ORDER BY pos, id
0.0013649463653564SELECT av.id AS id, ca.title AS title, av.val AS value, av.attribute_id AS attribute_id, av.item_id AS item_id, av.status AS status
FROM attribute_values AS av
INNER JOIN custom_attributes AS ca ON (av.attribute_id = ca.id AND ca.status IN(1))
INNER JOIN items AS i ON (i.id = av.item_id AND i.status IN(1) )
WHERE 1 AND av.item_id =535 AND av.status IN(1)
ORDER BY ca.element_type
0.00039815902709961SELECT *
FROM files
WHERE element_type = 2 AND element_id = 535
ORDER BY file_category
0.00033092498779297SELECT id, product_id, title, item_number, cdate, short_description, description, price, item_weight, item_volume, status, show_image_in_public, ignore_inventory_qty, hs_form_guid, natpos, pos, lead_time, is_glass, shipping_length, shipping_height, shipping_width, shipperhq_group, vendor_id, shipperhq_packing_rule, lead_time_label, lead_time_option, netsuite_id
FROM items
WHERE id="536"
0.00061988830566406SELECT t.id AS id, t.product_id AS product_id, t.temp_title AS temp_title, t.title AS title, t.comment AS comment, t.status AS status, t.count_cell AS count_cell, t.is_rfq AS is_rfq, t.pos AS pos, t.uid AS uid, t.is_modal AS is_modal, t.is_grouped_by_column AS is_grouped_by_column, t.group_by_column_name AS group_by_column_name, t.form_type_input_field AS form_type_input_field, t.form_type_input_field2 AS form_type_input_field2, t.form_type_input_field3 AS form_type_input_field3, t.form_type_input_field4 AS form_type_input_field4, t.netsuite_price_level_id AS netsuite_price_level_id, it.status AS table_status, it.item_id AS item_id, it.id AS item2table_id, it.is_dropdown AS is_table_dropdown, it.is_show_qty_on_hand AS is_show_qty_on_hand, it.show_netsuite_sales_description AS show_netsuite_sales_description, it.show_netsuite_images AS show_netsuite_images
FROM custom_tables AS t
INNER JOIN item2table AS it on ( it.table_id = t.id AND it.status IN(1) )
INNER JOIN items AS i on ( it.item_id = i.id AND t.product_id = i.product_id AND i.status IN(1) )
WHERE 1 AND it.item_id =536 AND t.status IN(1) AND t.product_id =345 AND it.status IN(1) GROUP BY t.id, it.id
ORDER by t.pos ASC
0.0037059783935547SELECT tv.id AS id, tv.field_id AS field_id, tv.row_id AS row_id, tv.val AS val, tv.status AS status, tv.is_dropdown AS is_dropdown, it.table_id AS table_id, tr.cart_type AS row_cart_type, tr.pos AS row_pos, tr.qty AS qty, tr.sales_description AS sales_description, tf.pos AS col_pos, tf.title AS col_title, it.item_id AS item_id, tf.is_part_number_field AS is_part_number_field, tf.is_price_field AS is_price_field, tf.is_weight_field AS is_weight_field, tf.is_input_field AS is_input_field, tf.is_input_field2 AS is_input_field2, tf.is_input_field3 AS is_input_field3, tf.is_input_field4 AS is_input_field4, tf.input_field_options AS input_field_options, tf.input_field_options2 AS input_field_options2, tf.input_field_options3 AS input_field_options3, tf.input_field_options4 AS input_field_options4, tf.is_mandatory AS is_mandatory, tf.is_include_to_url AS is_include_to_url, tf.is_hide_
from_user AS is_hide_
from_user
FROM table_field_values AS tv
INNER JOIN table_rows AS tr ON ( tr.id = tv.row_id AND tr.status IN(1) )
INNER JOIN item2table AS it ON ( it.id = tr.item_table AND it.status IN(1) )
INNER JOIN table_field_names AS tf ON ( tf.id = tv.field_id AND tf.status IN(1) )
INNER JOIN items AS i ON ( i.id = it.item_id AND i.status IN(1) )
WHERE 1 AND it.item_id =536 AND it.table_id =502 AND tv.status IN(1)
ORDER BY it.table_id, tr.pos ASC, tv.row_id, tf.pos, tv.field_id
0.00030708312988281SELECT COUNT(*)
FROM item2table
WHERE 1 AND item_id =536 AND table_id =502
0.00029206275939941SELECT id AS id, table_id AS table_id, item_id AS item_id, status AS status, is_dropdown AS is_dropdown, is_show_qty_on_hand AS is_show_qty_on_hand, show_netsuite_images AS show_netsuite_images, show_netsuite_sales_description AS show_netsuite_sales_description
FROM item2table
WHERE 1 AND item_id =536 AND table_id =502
LIMIT 1
0.0085251331329346SELECT f.id AS `file_id`, tr.id AS `id`, f.name AS `name`, f.position AS `position`
FROM table_rows AS tr
INNER JOIN table_row_images AS f ON (tr.netsuite_id = f.row_netsuite_id) AND (f.row_netsuite_id > 0)
WHERE tr.id IN (7971,7972,7973,22461,22462,22463,22464,22465,22466,22467,22468,22469,22470,22471,22472,22473,22474,22475,22476,22477,22478,22479,22480,22481)
ORDER BY f.position ASC
0.00042581558227539SELECT COUNT(*)
FROM table_field_names
WHERE 1 AND status IN(1) AND table_id =502
0.00041699409484863SELECT id AS id, temp_title AS temp_title, table_id AS table_id, title AS title, status AS status, is_price_field AS is_price_field, is_weight_field AS is_weight_field, is_input_field AS is_input_field, is_input_field2 AS is_input_field2, is_mandatory AS is_mandatory, pos AS pos, is_include_to_url AS is_include_to_url, is_hide_
from_user AS is_hide_
from_user, is_part_number_field AS is_part_number_field, is_input_field3 AS is_input_field3, is_input_field4 AS is_input_field4, input_field_options AS input_field_options, input_field_options2 AS input_field_options2, input_field_options3 AS input_field_options3, input_field_options4 AS input_field_options4, structured_data_additional_property_id AS structured_data_additional_property_id, id AS cell_id
FROM table_field_names
WHERE 1 AND status IN(1) AND table_id =502
ORDER BY pos, id
0.00067281723022461SELECT av.id AS id, ca.title AS title, av.val AS value, av.attribute_id AS attribute_id, av.item_id AS item_id, av.status AS status
FROM attribute_values AS av
INNER JOIN custom_attributes AS ca ON (av.attribute_id = ca.id AND ca.status IN(1))
INNER JOIN items AS i ON (i.id = av.item_id AND i.status IN(1) )
WHERE 1 AND av.item_id =536 AND av.status IN(1)
ORDER BY ca.element_type
0.00041484832763672SELECT *
FROM files
WHERE element_type = 2 AND element_id = 536
ORDER BY file_category
0.0006401538848877SELECT it.id
FROM items AS it
WHERE 1 AND it.product_id =345 AND it.status =1 AND it.title ="" AND it.item_number ="" AND it.short_description ="" AND it.description ="" AND it.price IN("0", "0.0", "0.00") AND it.item_weight =0 AND it.item_volume =0 AND (
SELECT count(av.id) AS count
FROM attribute_values AS av
LEFT JOIN custom_attributes AS ca ON (av.attribute_id = ca.id AND ca.status = 1)
LEFT JOIN items AS i ON (av.item_id = i.id AND i.status = 1)
WHERE av.item_id = it.id) =0 AND (
SELECT count(tr.id) AS count
FROM table_rows AS tr
LEFT JOIN item2table AS i2t ON (tr.item_table = i2t.id AND i2t.status = 1)
LEFT JOIN items AS i2 ON (i2t.item_id = i2.id AND i2.status = 1)
WHERE i2t.item_id = it.id) <2
0.0004420280456543SELECT t.id AS id, t.product_id AS product_id, t.temp_title AS temp_title, t.title AS title, t.comment AS comment, t.status AS status, t.count_cell AS count_cell, t.is_rfq AS is_rfq, t.pos AS pos, t.uid AS uid, t.is_modal AS is_modal, t.is_grouped_by_column AS is_grouped_by_column, t.group_by_column_name AS group_by_column_name, t.form_type_input_field AS form_type_input_field, t.form_type_input_field2 AS form_type_input_field2, t.form_type_input_field3 AS form_type_input_field3, t.form_type_input_field4 AS form_type_input_field4, t.netsuite_price_level_id AS netsuite_price_level_id, it.status AS table_status, it.item_id AS item_id, it.id AS item2table_id, it.is_dropdown AS is_table_dropdown, it.is_show_qty_on_hand AS is_show_qty_on_hand, it.show_netsuite_sales_description AS show_netsuite_sales_description, it.show_netsuite_images AS show_netsuite_images
FROM custom_tables AS t
INNER JOIN item2table AS it on ( it.table_id = t.id AND it.status IN(1) )
INNER JOIN items AS i on ( it.item_id = i.id AND t.product_id = i.product_id AND i.status IN(1) )
WHERE 1 AND it.item_id IN (0) AND t.status IN(1) AND t.product_id =345 AND it.status IN(1) GROUP BY t.id, it.id
ORDER by t.pos ASC
0.00030398368835449SELECT COUNT(*)
FROM products
WHERE 1 AND id =345
0.0013589859008789SELECT id AS id, title AS title, code AS code, cdate AS cdate, category_id AS category_id, manufacturer_id AS manufacturer_id, description AS description, faq_header AS faq_header, faq_content AS faq_content, show_faq_in_detail AS show_faq_in_detail, meta_title AS meta_title, meta_description AS meta_description, meta_tags AS meta_tags, url AS url, status AS status, del_status AS del_status, request_quote AS request_quote, quote_description AS quote_description, hs_code AS hs_code, is_rfq AS is_rfq, list_id AS list_id, show_image_in_public AS show_image_in_public, has_price AS has_price, is_taxable AS is_taxable, hs_list_id AS hs_list_id, is_ups AS is_ups, vendor_id AS vendor_id, pos AS pos, natpos AS natpos, lead_time AS lead_time, image_box_text AS image_box_text, image_box_image AS image_box_image, is_glass AS is_glass, glass_increment AS glass_increment, glass_longest_length AS glass_longest_length, glass_od AS glass_od, glass_settings AS glass_settings, infusionsoft_form_id AS infusionsoft_form_id, qb_list_id AS qb_list_id, qb_log AS qb_log, qb_udate AS qb_udate, qb_error AS qb_error, product_code AS product_code, show_images_in_detail AS show_images_in_detail, show_description_in_detail AS show_description_in_detail, use_structured_data_tag AS use_structured_data_tag, discount_group_id AS discount_group_id, netsuite_id AS netsuite_id, jotform_id AS jotform_id, IFNULL((
SELECT m.title
FROM manufactures AS m
WHERE m.id = manufacturer_id ),"") AS manufacturer, 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=category_id),"") AS category_id_new, IFNULL((
SELECT s.url
FROM catalog_categories AS s
WHERE s.id = category_id_new),"") AS category_url, IFNULL((
SELECT s.url
FROM catalog_categories AS s
WHERE s.id = category_id),"") AS subcategory_url, IFNULL((
SELECT s.status
FROM catalog_categories AS s
WHERE s.id = category_id_new),"") AS category_status, IFNULL((
SELECT s.status
FROM catalog_categories AS s
WHERE s.id = category_id),"") AS subcategory_status, IFNULL((
SELECT IFNULL(s.title, s.short_title)
FROM catalog_categories AS s
WHERE s.id = category_id_new),"") AS category_title, IFNULL((
SELECT IFNULL(s.title, s.short_title)
FROM catalog_categories AS s
WHERE s.id = category_id),"") AS subcategory_title, IFNULL((
SELECT n.own_page
FROM catalog_categories AS n
WHERE n.id =category_id),"") AS subcategory_own_page
FROM products
WHERE 1 AND id =345
LIMIT 1
0.00040817260742188SELECT *
FROM files
WHERE element_type = 1 AND element_id = 345
ORDER BY file_category
0.001291036605835SELECT code, val, validation
FROM settings
WHERE code IN ('structured_data.enable', 'structured_data.only_for_add_to_cart')
0.00042510032653809SELECT products.id, products.product_code, products.title, products.is_rfq, products.meta_description, products.use_structured_data_tag, products.manufacturer_id, catalog_categories.parent_id AS parent_category_id, manufactures.title AS manufacturer, catalog_categories.title AS category
FROM products
LEFT JOIN manufactures ON (products.manufacturer_id = manufactures.id)
LEFT JOIN catalog_categories ON (products.category_id = catalog_categories.id)
WHERE products.id = '345'
LIMIT 1
0.00024700164794922SELECT title
FROM catalog_categories
WHERE id = '119'
LIMIT 1
0.0007779598236084SELECT *
FROM structured_data_additional_properties
WHERE is_enable = '1'
0.0003359317779541SELECT items.id, items.item_number, items.title, items.short_description, items.lead_time_option, items.price, items.item_weight
FROM items
WHERE product_id = '345' AND status = '1'
0.00029110908508301SELECT id, table_id
FROM item2table
WHERE item_id = '535' AND status != '2'
0.00037503242492676SELECT *
FROM table_field_names
WHERE table_id = '502' AND status = '1'
0.0058600902557373SELECT *
FROM table_rows
WHERE table_rows.item_table = '728' AND table_rows.status != '2'
0.00058722496032715SELECT id, val, field_id
FROM table_field_values
WHERE table_field_values.row_id = '7968' AND table_field_values.status = '1'
0.00034213066101074SELECT id, val, field_id
FROM table_field_values
WHERE table_field_values.row_id = '7969' AND table_field_values.status = '1'
0.0003659725189209SELECT id, val, field_id
FROM table_field_values
WHERE table_field_values.row_id = '7970' AND table_field_values.status = '1'
0.00038290023803711SELECT id, val, field_id
FROM table_field_values
WHERE table_field_values.row_id = '22440' AND table_field_values.status = '1'
0.00038599967956543SELECT id, val, field_id
FROM table_field_values
WHERE table_field_values.row_id = '22441' AND table_field_values.status = '1'
0.00032687187194824SELECT id, val, field_id
FROM table_field_values
WHERE table_field_values.row_id = '22442' AND table_field_values.status = '1'
0.00032496452331543SELECT id, val, field_id
FROM table_field_values
WHERE table_field_values.row_id = '22443' AND table_field_values.status = '1'
0.0003659725189209SELECT id, val, field_id
FROM table_field_values
WHERE table_field_values.row_id = '22444' AND table_field_values.status = '1'
0.00034308433532715SELECT id, val, field_id
FROM table_field_values
WHERE table_field_values.row_id = '22445' AND table_field_values.status = '1'
0.00034284591674805SELECT id, val, field_id
FROM table_field_values
WHERE table_field_values.row_id = '22446' AND table_field_values.status = '1'
0.00035905838012695SELECT id, val, field_id
FROM table_field_values
WHERE table_field_values.row_id = '22447' AND table_field_values.status = '1'
0.00034809112548828SELECT id, val, field_id
FROM table_field_values
WHERE table_field_values.row_id = '22448' AND table_field_values.status = '1'
0.00038695335388184SELECT id, val, field_id
FROM table_field_values
WHERE table_field_values.row_id = '22449' AND table_field_values.status = '1'
0.00033020973205566SELECT id, val, field_id
FROM table_field_values
WHERE table_field_values.row_id = '22450' AND table_field_values.status = '1'
0.00035810470581055SELECT id, val, field_id
FROM table_field_values
WHERE table_field_values.row_id = '22451' AND table_field_values.status = '1'
0.00034904479980469SELECT id, val, field_id
FROM table_field_values
WHERE table_field_values.row_id = '22452' AND table_field_values.status = '1'
0.00032401084899902SELECT id, val, field_id
FROM table_field_values
WHERE table_field_values.row_id = '22453' AND table_field_values.status = '1'
0.00037002563476562SELECT id, val, field_id
FROM table_field_values
WHERE table_field_values.row_id = '22454' AND table_field_values.status = '1'
0.00033807754516602SELECT id, val, field_id
FROM table_field_values
WHERE table_field_values.row_id = '22455' AND table_field_values.status = '1'
0.00032210350036621SELECT id, val, field_id
FROM table_field_values
WHERE table_field_values.row_id = '22456' AND table_field_values.status = '1'
0.0003969669342041SELECT id, val, field_id
FROM table_field_values
WHERE table_field_values.row_id = '22457' AND table_field_values.status = '1'
0.00031113624572754SELECT id, val, field_id
FROM table_field_values
WHERE table_field_values.row_id = '22458' AND table_field_values.status = '1'
0.00031208992004395SELECT id, val, field_id
FROM table_field_values
WHERE table_field_values.row_id = '22459' AND table_field_values.status = '1'
0.00041413307189941SELECT id, val, field_id
FROM table_field_values
WHERE table_field_values.row_id = '22460' AND table_field_values.status = '1'
0.0003669261932373SELECT id, table_id
FROM item2table
WHERE item_id = '536' AND status != '2'
0.00040197372436523SELECT *
FROM table_field_names
WHERE table_id = '502' AND status = '1'
0.00057101249694824SELECT *
FROM table_rows
WHERE table_rows.item_table = '729' AND table_rows.status != '2'
0.00051403045654297SELECT id, val, field_id
FROM table_field_values
WHERE table_field_values.row_id = '7971' AND table_field_values.status = '1'
0.00044488906860352SELECT id, val, field_id
FROM table_field_values
WHERE table_field_values.row_id = '7972' AND table_field_values.status = '1'
0.0004429817199707SELECT id, val, field_id
FROM table_field_values
WHERE table_field_values.row_id = '7973' AND table_field_values.status = '1'
0.00043606758117676SELECT id, val, field_id
FROM table_field_values
WHERE table_field_values.row_id = '22461' AND table_field_values.status = '1'
0.00045514106750488SELECT id, val, field_id
FROM table_field_values
WHERE table_field_values.row_id = '22462' AND table_field_values.status = '1'
0.00043416023254395SELECT id, val, field_id
FROM table_field_values
WHERE table_field_values.row_id = '22463' AND table_field_values.status = '1'
0.00070595741271973SELECT id, val, field_id
FROM table_field_values
WHERE table_field_values.row_id = '22464' AND table_field_values.status = '1'
0.00041818618774414SELECT id, val, field_id
FROM table_field_values
WHERE table_field_values.row_id = '22466' AND table_field_values.status = '1'
0.00036501884460449SELECT id, val, field_id
FROM table_field_values
WHERE table_field_values.row_id = '22467' AND table_field_values.status = '1'
0.00036787986755371SELECT id, val, field_id
FROM table_field_values
WHERE table_field_values.row_id = '22468' AND table_field_values.status = '1'
0.00036501884460449SELECT id, val, field_id
FROM table_field_values
WHERE table_field_values.row_id = '22469' AND table_field_values.status = '1'
0.00049614906311035SELECT id, val, field_id
FROM table_field_values
WHERE table_field_values.row_id = '22470' AND table_field_values.status = '1'
0.00043201446533203SELECT id, val, field_id
FROM table_field_values
WHERE table_field_values.row_id = '22471' AND table_field_values.status = '1'
0.00034093856811523SELECT id, val, field_id
FROM table_field_values
WHERE table_field_values.row_id = '22472' AND table_field_values.status = '1'
0.00038385391235352SELECT id, val, field_id
FROM table_field_values
WHERE table_field_values.row_id = '22474' AND table_field_values.status = '1'
0.00034594535827637SELECT id, val, field_id
FROM table_field_values
WHERE table_field_values.row_id = '22475' AND table_field_values.status = '1'
0.00035500526428223SELECT id, val, field_id
FROM table_field_values
WHERE table_field_values.row_id = '22476' AND table_field_values.status = '1'
0.00035691261291504SELECT id, val, field_id
FROM table_field_values
WHERE table_field_values.row_id = '22477' AND table_field_values.status = '1'
0.00035405158996582SELECT id, val, field_id
FROM table_field_values
WHERE table_field_values.row_id = '22478' AND table_field_values.status = '1'
0.00034880638122559SELECT id, val, field_id
FROM table_field_values
WHERE table_field_values.row_id = '22479' AND table_field_values.status = '1'
0.00042200088500977SELECT id, val, field_id
FROM table_field_values
WHERE table_field_values.row_id = '22480' AND table_field_values.status = '1'
0.0006859302520752SELECT filename, description, alt_text
FROM files
WHERE element_id = '345' AND element_type = '1' AND file_category = '1'
ORDER BY id DESC
LIMIT 1
0.0012938976287842SELECT *
FROM structured_data_map
0.0029480457305908SHOW COLUMNS
FROM ads
0.00047612190246582SELECT COUNT(*)
FROM ads
WHERE 1 AND status =1
0.00084900856018066SELECT id, url, category_id
FROM products
WHERE id = '347' OR url = '347'
LIMIT 1
0.00032305717468262SELECT url, title, own_page, parent_id
FROM catalog_categories
WHERE id = '354'
LIMIT 1
0.00043511390686035SELECT id, url, category_id
FROM products
WHERE id = '1049' OR url = '1049'
LIMIT 1
0.0010762214660645SELECT id, url, category_id
FROM products
WHERE id = '344' OR url = '344'
LIMIT 1
0.00063204765319824SELECT id, url, category_id
FROM products
WHERE id = '346' OR url = '346'
LIMIT 1
0.0031979084014893SHOW COLUMNS
FROM megamenu
0.0012218952178955SELECT COUNT(*)
FROM megamenu
WHERE 1
0.00049901008605957SELECT 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
Total: 0.14811658859253

 _showPOST
POST is empty