←
Call Now:
Toll-Free:

Graham

Shell and Tube Heat Exchangers

  •  _showSql
    0.0031459331512451SET @@collation_connection = @@collation_database
    0.0014259815216064SET NAMES utf8
    0.002007007598877SELECT code, val
    FROM settings
    0.0020530223846436SELECT ip_address
    FROM blocked_ips
    0.0028278827667236SHOW COLUMNS
    FROM manufactures
    0.00035214424133301SELECT 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.0014748573303223SHOW COLUMNS
    FROM content_pages
    0.00037193298339844SELECT 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.0017402172088623SHOW COLUMNS
    FROM catalog_categories
    0.0014369487762451SHOW COLUMNS
    FROM catalog_categories_groups
    0.00078082084655762SELECT COUNT(*)
    FROM catalog_categories
    WHERE 1 AND url ='graham-heat-exchangers' AND status ='1'
    0.00046515464782715SELECT COUNT(*)
    FROM manufactures
    WHERE 1 AND url ='graham'
    0.00040006637573242SELECT 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 ='graham'
    LIMIT 1
    0.00045585632324219SELECT COUNT(*)
    FROM manufactures
    WHERE 1 AND url ='graham'
    0.00035214424133301SELECT 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 ='graham'
    LIMIT 1
    0.0037569999694824SHOW COLUMNS
    FROM products
    0.0018608570098877SHOW COLUMNS
    FROM files
    0.0028400421142578SELECT 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 =8 AND status =1 AND del_status =1
    ORDER BY category_pos ASC,subcategory_groups ASC,without_subcategory ASC,subcategory_own_page DESC,pos ASC,subcategory_id ASC,title ASC
    0.0017719268798828SELECT COUNT(*)
    FROM files
    WHERE 1 AND element_type =1 AND file_category =1 AND element_id =37
    0.0016040802001953SELECT 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 =37
    ORDER BY cdate DESC
    LIMIT 1
    0.0015859603881836SELECT COUNT(*)
    FROM files
    WHERE 1 AND element_type =1 AND file_category =1 AND element_id =36
    0.0015919208526611SELECT 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 =36
    ORDER BY cdate DESC
    LIMIT 1
    0.00054812431335449SELECT COUNT(*)
    FROM files
    WHERE 1 AND element_type =3 AND file_category =1 AND element_id =237
    0.00046205520629883SELECT 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 =237
    LIMIT 1
    0.0018949508666992SHOW COLUMNS
    FROM megamenu
    0.035015821456909SELECT COUNT(*)
    FROM megamenu
    WHERE 1
    0.00059103965759277SELECT 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.00033187866210938SELECT id, Title, meta_title, meta_description, meta_keywords
    FROM manufactures
    WHERE url = 'graham'
    LIMIT 1
    0.0014779567718506SELECT 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 = '8'
    Total: 0.074623584747314

     _showPOST
    POST is empty