Chimney Fireplace in North Carolina

Time: 0.267942 / SQL: 0.06444s for 37 queries / Net Memory: 12879016 / Peak: 13809552

Initialize Database

Done Initializing Database

initialize internal global cache

done initializing global cache

Loading Modules

SET @CG_ZEROTIME = NOW() - INTERVAL 150 YEAR,@CG_FUTURETIME = NOW() + INTERVAL 5 YEAR

SELECT id,url FROM cms_module_compdir_companies WHERE status = 'published' AND url != ''

End of Loading Modules

Initialize Smarty

Done Initialing Smarty

cms_content_cache: begin load needed content objects

cms_content_cache: end loading needed content objects

SELECT * FROM cms_content WHERE content_id = 155 LIMIT  1

process template top

SELECT * FROM cms_layout_templates WHERE id = 154 LIMIT  1

SELECT * FROM cms_content_props WHERE content_id = 155

SELECT * from cms_module_templates WHERE module_name = 'CompanyDirectory' and template_name = 'summary_5BS-summary' LIMIT  1

SELECT * FROM cms_module_compdir_hier ORDER BY hierarchy

SELECT * FROM cms_module_compdir_categories ORDER BY hierarchy ASC

SELECT COUNT(DISTINCT C.id) AS count FROM cms_module_compdir_companies C LEFT OUTER JOIN cms_module_feusers_users fu ON fu.id = C.owner_id INNER JOIN cms_module_compdir_company_categories CC ON CC.company_id = C.id WHERE (C.status = 'published' AND (COALESCE(C.owner_id,-1) < 0 OR fu.expires > NOW())) AND (C.hier_id IN (33,155,156,157,158,159) AND CC.category_id IN (7)) LIMIT  1

SELECT DISTINCT C.* FROM cms_module_compdir_companies C LEFT OUTER JOIN cms_module_feusers_users fu ON fu.id = C.owner_id INNER JOIN cms_module_compdir_company_categories CC ON CC.company_id = C.id WHERE (C.status = 'published' AND (COALESCE(C.owner_id,-1) < 0 OR fu.expires > NOW())) AND (C.hier_id IN (33,155,156,157,158,159) AND CC.category_id IN (7)) ORDER BY fax desc,id DESC LIMIT 0, 32

SELECT fv.* FROM cms_module_compdir_fieldvals fv WHERE fv.company_id IN (5555,5556) ORDER BY fv.company_id,fv.fielddef_id

SELECT * FROM cms_module_compdir_fielddefs ORDER BY item_order

SELECT * FROM cms_module_compdir_company_categories C where C.company_id IN (5555,5556) ORDER BY C.company_id

SELECT * FROM cms_content WHERE content_id = 88 LIMIT  1

SELECT * from cms_module_templates WHERE module_name = 'CompanyDirectory' and template_name = 'summary_5BS-summary' LIMIT  1

SELECT * FROM cms_module_smarty_plugins ORDER BY module

SELECT * FROM cms_module_compdir_categories WHERE id = 7 LIMIT  1

SELECT CAT.*,COALESCE(S1.count,0) AS count FROM cms_module_compdir_categories CAT

            LEFT OUTER JOIN (SELECT CC.category_id,COUNT(CC.company_id) AS count FROM cms_module_compdir_company_categories CC

                             LEFT JOIN cms_module_compdir_companies CO

                            ON CC.company_id = CO.id  WHERE CO.status = 'published' AND CO.hier_id IN (33,155,156,157,158,159,155,156,157,158,159) GROUP BY CC.category_id) AS S1

            ON CAT.id = S1.category_id 

            ORDER BY CAT.hierarchy

SELECT * FROM cms_content WHERE content_id = '15' LIMIT  1

SELECT * from cms_module_templates WHERE module_name = 'CompanyDirectory' and template_name = 'categorylist_5BS' LIMIT  1

Start Navigator default action

SELECT * FROM cms_layout_templates WHERE name = '5BS-sub-nav' LIMIT  1

SELECT * FROM cms_content FORCE INDEX (cms_index_content_by_idhier) WHERE content_id IN (223,364,224,225,226) AND active = 1 ORDER BY hierarchy

SELECT * FROM cms_content_props WHERE content_id IN (223,364,224,225,226) ORDER BY content_id

End Navigator default action

SELECT * FROM cms_module_compdir_categories WHERE id = 7 LIMIT  1

SELECT * FROM cms_layout_templates WHERE name = 'GtagNOscript' LIMIT  1

SELECT * FROM cms_layout_templates WHERE name = '5BS-header' LIMIT  1

SELECT * FROM cms_content FORCE INDEX (cms_index_content_by_idhier) WHERE content_id IN (57,58,145,148,153,154,157,222,237,460,462,464,470,473,474,475,476,477) AND active = 1 ORDER BY hierarchy

SELECT * from cms_module_templates WHERE module_name = 'CompanyDirectory' and template_name = 'newsearch_5BSsearch' LIMIT  1

SELECT * FROM cms_content FORCE INDEX (cms_index_content_by_idhier) WHERE content_id IN (149,471,472,478) AND active = 1 ORDER BY hierarchy

SELECT * FROM cms_layout_templates WHERE name = '5BS-footer' LIMIT  1

SELECT * FROM cms_layout_templates WHERE name = '4BS-meta' LIMIT  1

SELECT SQL_CALC_FOUND_ROWS S.id FROM cms_layout_stylesheets S LEFT JOIN cms_layout_design_cssassoc D ON S.id = D.css_id WHERE D.design_id = 27 ORDER BY D.item_order ASC LIMIT 0, 1000

SELECT FOUND_ROWS() LIMIT  1

SELECT id,name,content,description,media_type,media_query,created,modified FROM cms_layout_stylesheets WHERE id IN (53,54)

SELECT * FROM cms_layout_templates WHERE name = 'Gtag' LIMIT  1

SELECT * FROM cms_layout_templates WHERE name = '4BS-adsense-auto' LIMIT  1