Estate and Probate Attorneys in Texas

Time: 0.24483 / SQL: 0.06021s for 32 queries / Net Memory: 22088032 / Peak: 26619688

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 tpl_id,design_id FROM cms_layout_design_tplassoc
                   WHERE tpl_id IN (143,142,122,127,128,101,121,100) ORDER BY tpl_id

SELECT * FROM cms_layout_templates WHERE id IN (143,142,122,127,128,101,121,100)

SELECT * FROM cms_content WHERE content_id = 141 LIMIT  1

process template top

SELECT * FROM cms_content_props WHERE content_id = 141

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 INNER JOIN cms_module_compdir_company_categories CC ON CC.company_id = C.id WHERE (C.status = 'published') AND (C.hier_id IN (43) AND CC.category_id IN (10)) LIMIT  1

SELECT DISTINCT C.* FROM cms_module_compdir_companies C INNER JOIN cms_module_compdir_company_categories CC ON CC.company_id = C.id WHERE (C.status = 'published') AND (C.hier_id IN (43) AND CC.category_id IN (10)) ORDER BY fax desc,id DESC LIMIT 0, 32

SELECT fv.* FROM cms_module_compdir_fieldvals fv WHERE fv.company_id IN (1476) 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 (1476) ORDER BY C.company_id

SELECT * FROM cms_content WHERE content_id = 140 LIMIT  1

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

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

SELECT * FROM cms_module_compdir_categories WHERE id = 10 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 (43,318,317,319,315,316,318,317,319,315,316) 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

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

Start Navigator default action

SELECT * FROM cms_content FORCE INDEX (cms_index_content_by_idhier) WHERE content_id IN (176,208,402,175,207) AND active = 1 ORDER BY hierarchy

SELECT * FROM cms_content_props WHERE content_id IN (176,208,402,175,207) ORDER BY content_id

End Navigator default action

SELECT * FROM cms_content FORCE INDEX (cms_index_content_by_idhier) WHERE content_id IN (57,82,136,138,142,144,171,206,213,447,448,450,451,454,508,509,530,549,565,566) 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_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 (139,527,548,550,567) AND active = 1 ORDER BY hierarchy

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 = 21 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 (40,38)