Ryan Drury

Time: 0.251725 / SQL: 0.03779s for 29 queries / Net Memory: 10050304 / Peak: 10711200

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 (146,122,138,137,121,96) ORDER BY tpl_id

SELECT * FROM cms_layout_templates WHERE id IN (146,122,138,137,121,96)

SELECT * FROM cms_content WHERE content_id = 23 LIMIT  1

process template top

SELECT * FROM cms_content_props WHERE content_id = 23

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

SELECT * FROM cms_module_compdir_companies WHERE id = 1725 LIMIT  1

SELECT * FROM cms_module_compdir_fielddefs ORDER BY item_order

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

SELECT * FROM cms_module_compdir_categories ORDER BY hierarchy ASC

SELECT * FROM cms_module_compdir_company_categories C where C.company_id IN (1725) ORDER BY C.company_id

SELECT * FROM cms_module_compdir_hier ORDER BY hierarchy

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

SELECT * FROM cms_module_banners_categories WHERE name = 'british-columbia' 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 = '3') ORDER BY last_impression ASC LIMIT  1

SELECT banner_id FROM cms_module_banners WHERE name = 'PFH-BC' AND banner_id != '62' LIMIT  1

UPDATE cms_module_banners
                  SET category_id = '3', name = 'PFH-BC', description = '', image = 'banners/pfh-banner.jpg', url = 'https://prosforhome.ca/british-columbia?ref=clca', text = 'British Columbia Homeowner Services Directory', href_text = 'British Columbia Homeowner Services Directory',
                      start_date = '2023-04-27 00:00:00', expires = NULL, max_impressions = '0', num_impressions = 171316, last_impression = '2026-09-16 12:53:07'
                  WHERE banner_id = '62'

SELECT * FROM cms_content FORCE INDEX (cms_index_content_by_idhier) WHERE content_id IN (44,48,52,56,60,63,66,71,74,78) AND active = 1 ORDER BY hierarchy

SELECT * FROM cms_content FORCE INDEX (cms_index_content_by_idhier) WHERE content_id IN (49,220,227,229,137,126,51,127,231) AND active = 1 ORDER BY hierarchy

SELECT * FROM cms_content FORCE INDEX (cms_index_content_by_idhier) WHERE content_id IN (248,33,294,218,211,252,278,249,215,271,95,296,250) AND active = 1 ORDER BY hierarchy

SELECT * FROM cms_content FORCE INDEX (cms_index_content_by_idhier) WHERE content_id IN (15,16,22,19,21,82,24,83,89,98,85,144,145,146,151,152,188,156,189,244,284,285,356) 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 (20,154,155,150,208,225,243,245,295) AND active = 1 ORDER BY hierarchy

SELECT * FROM cms_content FORCE INDEX (cms_index_content_by_idhier) WHERE content_id IN (204,193,198,199,192,200,201,194,190,226,222,195,202,212,191,196,203,197,207,216) 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 = 19 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 (36,34)