Antiques Art in Delaware

Time: 0.34087 / SQL: 0.08876s for 39 queries / Net Memory: 13887608 / Peak: 16302448

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 (8) AND CC.category_id IN (1)) 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 (8) AND CC.category_id IN (1)) ORDER BY fax desc,id DESC LIMIT 0, 32

SELECT fv.* FROM cms_module_compdir_fieldvals fv WHERE fv.company_id IN (1510,1515,1519) 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 (1510,1515,1519) 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 = 1 LIMIT  1

SELECT * FROM cms_module_banners_categories WHERE name = 'delaware' LIMIT  1

SELECT * FROM cms_module_banners WHERE (start_date <= NOW()) AND (expires >= NOW() OR isnull(expires)) AND (max_impressions = 0 OR num_impressions < max_impressions) AND (category_id = '8') ORDER BY last_impression ASC LIMIT  1

SELECT banner_id FROM cms_module_banners WHERE name = 'CL-DE-26' AND banner_id != '549' LIMIT  1

UPDATE cms_module_banners
                  SET category_id = '8', name = 'CL-DE-26', description = '', image = 'banners/CLUS-banner.png', url = 'https://cinchlaw.com/delaware-lawyers?ref=pfh', text = 'attorneys directory in Delaware', href_text = 'Find attorney near  you in Delaware',
                      start_date = '2026-01-31 00:00:00', expires = NULL, max_impressions = '0', num_impressions = 3371, last_impression = '2026-09-16 12:58:40'
                  WHERE banner_id = '549'

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 (8,172,174,173,175,171,172,174,173,175,171) 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_module_compdir_categories WHERE id = 1 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,520) 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