←
Call Now:
Toll-Free:

Watson McDaniel

Watson McDaniel Steam Trap Series

 _showSql
0.00043606758117676SET @@collation_connection = @@collation_database
0.00050592422485352SET NAMES utf8
0.0010101795196533SELECT code, val
FROM settings
0.01621413230896SELECT ip_address
FROM blocked_ips
0.0059769153594971SHOW COLUMNS
FROM manufactures
0.0036361217498779SELECT id, title, url, status, meta_title, meta_description, meta_keywords, seo_intro_title, seo_intro_text, hide_seo_intro_mobile, hide_seo_intro_all, seo_long_form_title, seo_long_form_text, hide_seo_long_form_mobile, hide_seo_long_form_all
FROM manufactures
WHERE id="0"
0.0077691078186035SHOW COLUMNS
FROM content_pages
0.00058412551879883SELECT 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="manufactures" AND p.page_type=""
LIMIT 1
0.0047211647033691SHOW COLUMNS
FROM catalog_categories
0.011126041412354SHOW COLUMNS
FROM catalog_categories_groups
0.0085110664367676SELECT COUNT(*)
FROM catalog_categories
WHERE 1 AND url ='watson-mcdaniel-steam-trap-series' AND status ='1'
0.0084939002990723SELECT 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 url ='watson-mcdaniel-steam-trap-series' AND status ='1'
ORDER BY pos ASC
0.0039398670196533SHOW COLUMNS
FROM products
0.012892961502075SELECT id, parent_id
FROM catalog_categories
WHERE parent_id IN ('370')
0.024958848953247SELECT id, category_id
FROM products
WHERE status = '1'
0.021058082580566SELECT COUNT(*)
FROM manufactures
WHERE 1 AND url ='watson-mcdaniel'
0.00065398216247559SELECT id AS id, title AS title, url AS url, status AS status, meta_title AS meta_title, meta_description AS meta_description, meta_keywords AS meta_keywords, seo_intro_title AS seo_intro_title, seo_intro_text AS seo_intro_text, hide_seo_intro_mobile AS hide_seo_intro_mobile, hide_seo_intro_all AS hide_seo_intro_all, seo_long_form_title AS seo_long_form_title, seo_long_form_text AS seo_long_form_text, hide_seo_long_form_mobile AS hide_seo_long_form_mobile, hide_seo_long_form_all AS hide_seo_long_form_all
FROM manufactures
WHERE 1 AND url ='watson-mcdaniel'
LIMIT 1
0.0013191699981689SELECT COUNT(*)
FROM manufactures
WHERE 1 AND url ='watson-mcdaniel'
0.0021450519561768SELECT id AS id, title AS title, url AS url, status AS status, meta_title AS meta_title, meta_description AS meta_description, meta_keywords AS meta_keywords, seo_intro_title AS seo_intro_title, seo_intro_text AS seo_intro_text, hide_seo_intro_mobile AS hide_seo_intro_mobile, hide_seo_intro_all AS hide_seo_intro_all, seo_long_form_title AS seo_long_form_title, seo_long_form_text AS seo_long_form_text, hide_seo_long_form_mobile AS hide_seo_long_form_mobile, hide_seo_long_form_all AS hide_seo_long_form_all
FROM manufactures
WHERE 1 AND url ='watson-mcdaniel'
LIMIT 1
0.0028800964355469SELECT COUNT(*)
FROM catalog_categories
WHERE 1 AND url ='watson-mcdaniel-steam-trap-series' AND status ='1'
0.0069539546966553SELECT 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 url ='watson-mcdaniel-steam-trap-series' AND status ='1'
ORDER BY pos ASC
0.0028929710388184SELECT id, parent_id
FROM catalog_categories
WHERE parent_id IN ('370')
0.020726919174194SELECT id, category_id
FROM products
WHERE status = '1'
0.0011160373687744SELECT *
FROM catalog_categories
WHERE id=164 AND status=1
ORDER BY pos
0.0037829875946045SELECT 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 manufacturer_id =116 AND `products`.category_id =370 AND status =1 AND del_status !=2
ORDER BY pos ASC
0.029531955718994SHOW COLUMNS
FROM files
0.0054099559783936SELECT COUNT(*)
FROM files
WHERE 1 AND element_type =1 AND file_category =1 AND element_id =569
0.0014779567718506SELECT 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 =569
ORDER BY cdate DESC
LIMIT 1
0.0056240558624268SELECT COUNT(*)
FROM files
WHERE 1 AND element_type =1 AND file_category =1 AND element_id =571
0.0012099742889404SELECT 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 =571
ORDER BY cdate DESC
LIMIT 1
0.0036959648132324SELECT COUNT(*)
FROM files
WHERE 1 AND element_type =1 AND file_category =1 AND element_id =564
0.00056219100952148SELECT 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 =564
ORDER BY cdate DESC
LIMIT 1
0.000885009765625SELECT COUNT(*)
FROM files
WHERE 1 AND element_type =1 AND file_category =1 AND element_id =567
0.00046992301940918SELECT 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 =567
ORDER BY cdate DESC
LIMIT 1
0.0049209594726562SELECT COUNT(*)
FROM files
WHERE 1 AND element_type =1 AND file_category =1 AND element_id =566
0.00066208839416504SELECT 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 =566
ORDER BY cdate DESC
LIMIT 1
0.0020959377288818SELECT COUNT(*)
FROM files
WHERE 1 AND element_type =1 AND file_category =1 AND element_id =565
0.0035979747772217SELECT 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 =565
ORDER BY cdate DESC
LIMIT 1
0.0038390159606934SHOW COLUMNS
FROM megamenu
0.038228034973145SELECT COUNT(*)
FROM megamenu
WHERE 1
0.0043120384216309SELECT 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.0038430690765381SELECT id, Title, meta_title, meta_description, meta_keywords
FROM manufactures
WHERE url = 'watson-mcdaniel'
LIMIT 1
0.012651920318604SELECT DISTINCT category.short_title
FROM products
INNER JOIN catalog_categories AS subcategory ON (subcategory.id = products.category_id)
INNER JOIN catalog_categories AS category ON (category.id = subcategory.parent_id OR category.parent_id = products.category_id)
WHERE products.manufacturer_id = '116'
Total: 0.29732370376587

 _showPOST
POST is empty