Wedding Cakes and Desserts Canadian Directory

Time: 0.359568 / SQL: 0.05191s for 60 queries / Net Memory: 8043696 / Peak: 8660656

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

SELECT * FROM cms_mod_cmsjobmgr WHERE start < UNIX_TIMESTAMP() AND created < UNIX_TIMESTAMP() ORDER BY errors ASC,created ASC LIMIT 1

SELECT * FROM cms_content WHERE content_id = 15 LIMIT  1

UPDATE cms_siteprefs SET sitepref_value = 1773561249 WHERE sitepref_name = 'CmsJobManager_mapi_pref_last_async_trigger'

Initialize Smarty

Done Initialing Smarty

SELECT sitepref_name,sitepref_value FROM cms_siteprefs

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 (147,144,145,109,143,131,6,113) ORDER BY tpl_id

SELECT * FROM cms_layout_templates WHERE id IN (147,144,145,109,143,131,6,113)

SELECT * FROM cms_content WHERE content_id = 74 LIMIT  1

process template top

SELECT * FROM cms_content_props WHERE content_id = 74

SELECT * from cms_module_templates WHERE module_name = 'CompanyDirectory' and template_name = 'summary_4BS-HP' LIMIT  1

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 (CC.category_id IN (13)) 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 (CC.category_id IN (13)) ORDER BY id desc,company_name ASC LIMIT 0, 21

SELECT fv.* FROM cms_module_compdir_fieldvals fv WHERE fv.company_id IN (1116,1117,1118,1119,1120,1121,1122,1123,1124,1125,1126,1127,1128,1129,1130,1131,1132,1133,1134,1135,1309) 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 (1116,1117,1118,1119,1120,1121,1122,1123,1124,1125,1126,1127,1128,1129,1130,1131,1132,1133,1134,1135,1309) ORDER BY C.company_id

SELECT * FROM cms_content WHERE content_id = 118 LIMIT  1

SELECT * FROM cms_module_compdir_hier ORDER BY hierarchy

SELECT * from cms_module_templates WHERE module_name = 'CompanyDirectory' and template_name = 'summary_4BS-HP' LIMIT  1

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

SELECT banner_id FROM cms_module_banners WHERE name = 'CL-CA-26' AND banner_id != '58' LIMIT  1

UPDATE cms_module_banners
                  SET category_id = '12', name = 'CL-CA-26', description = '', image = 'banners/CLCA-banner.png', url = 'https://cinchlaw.ca', text = 'cinch law Canada', href_text = 'Canadian lawyers directory',
                      start_date = '2026-02-25 00:00:00', expires = NULL, max_impressions = '0', num_impressions = 14124, last_impression = '2026-03-15 03:54:08'
                  WHERE banner_id = '58'

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

SELECT banner_id FROM cms_module_banners WHERE name = 'FHP-CA-26' AND banner_id != '59' LIMIT  1

UPDATE cms_module_banners
                  SET category_id = '12', name = 'FHP-CA-26', description = '', image = 'banners/FHPbanner.jpg', url = 'https://forhomepros.ca/', text = 'for home pros Canada', href_text = 'Canadian Real Estate Professionals Directory',
                      start_date = '2026-02-25 00:00:00', expires = NULL, max_impressions = '0', num_impressions = 13469, last_impression = '2026-03-15 03:54:08'
                  WHERE banner_id = '59'

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

SELECT banner_id FROM cms_module_banners WHERE name = 'PFH-CA-26' AND banner_id != '60' LIMIT  1

UPDATE cms_module_banners
                  SET category_id = '12', name = 'PFH-CA-26', description = '', image = 'banners/pfh-banner.jpg', url = 'https://prosforhome.ca/', text = 'pros for home Canada', href_text = 'Home Related Products & Services in Canada',
                      start_date = '2026-02-25 00:00:00', expires = NULL, max_impressions = '0', num_impressions = 12486, last_impression = '2026-03-15 03:54:08'
                  WHERE banner_id = '60'

SELECT * FROM cms_module_smarty_plugins ORDER BY module

Start Navigator default action

SELECT * FROM cms_content FORCE INDEX (cms_index_content_by_idhier) WHERE content_id IN (62,63,64,65,66,67,68,69,70,71,72,73,75,76,77,78,79,80,81,82) AND active = 1 ORDER BY hierarchy

SELECT * FROM cms_content_props WHERE content_id IN (62,63,64,65,66,67,68,69,70,71,72,73,75,76,77,78,79,80,81,82) ORDER BY content_id

End Navigator default action

SELECT * FROM cms_content FORCE INDEX (cms_index_content_by_idhier) WHERE content_id IN (60,61,57,58,59,125,128,133,136,137,160,161,162) AND active = 1 ORDER BY hierarchy

SELECT * FROM cms_module_compdir_categories WHERE id = 13 LIMIT  1

SELECT * FROM cms_module_compdir_categories WHERE id = 13 LIMIT  1

Start Navigator default action

End Navigator default action

Start Navigator default action

SELECT * FROM cms_content FORCE INDEX (cms_index_content_by_idhier) WHERE content_id IN (83,87,91,95,99,122,102,107,110,114) AND active = 1 ORDER BY hierarchy

SELECT * FROM cms_content_props WHERE content_id IN (83,87,91,95,99,122,102,107,110,114) ORDER BY content_id

SELECT * FROM cms_content FORCE INDEX (cms_index_content_by_idhier) WHERE content_id IN (84,85,86) AND active = 1 ORDER BY hierarchy

SELECT * FROM cms_content FORCE INDEX (cms_index_content_by_idhier) WHERE content_id IN (90,89,88) AND active = 1 ORDER BY hierarchy

SELECT * FROM cms_content FORCE INDEX (cms_index_content_by_idhier) WHERE content_id IN (93,94,92) AND active = 1 ORDER BY hierarchy

SELECT * FROM cms_content FORCE INDEX (cms_index_content_by_idhier) WHERE content_id IN (98,97,96) AND active = 1 ORDER BY hierarchy

SELECT * FROM cms_content FORCE INDEX (cms_index_content_by_idhier) WHERE content_id IN (101,100) AND active = 1 ORDER BY hierarchy

SELECT * FROM cms_content FORCE INDEX (cms_index_content_by_idhier) WHERE content_id IN (123,124) AND active = 1 ORDER BY hierarchy

SELECT * FROM cms_content FORCE INDEX (cms_index_content_by_idhier) WHERE content_id IN (126,105,104,103,106) AND active = 1 ORDER BY hierarchy

SELECT * FROM cms_content FORCE INDEX (cms_index_content_by_idhier) WHERE content_id IN (108,109) AND active = 1 ORDER BY hierarchy

SELECT * FROM cms_content FORCE INDEX (cms_index_content_by_idhier) WHERE content_id IN (113,111,112) AND active = 1 ORDER BY hierarchy

SELECT * FROM cms_content FORCE INDEX (cms_index_content_by_idhier) WHERE content_id IN (117,116,115) AND active = 1 ORDER BY hierarchy

End Navigator default action

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 (119,127) AND active = 1 ORDER BY hierarchy

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

SELECT ch.name,ch.long_name,count(cc.id) as compcount FROM cms_module_compdir_hier ch, cms_module_compdir_companies cc, cms_module_compdir_company_categories ct

  WHERE ch.id = cc.hier_id

  AND (cc.id = ct.company_id AND ct.category_id=13) GROUP BY ch.id ORDER BY long_name

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

SELECT ch.name,ch.long_name,count(cc.id) as compcount FROM cms_module_compdir_hier ch, cms_module_compdir_companies cc, cms_module_compdir_company_categories ct

  WHERE ch.id = cc.hier_id

  AND (cc.id = ct.company_id AND ct.category_id=13) GROUP BY ch.id ORDER BY long_name

Start Navigator default action

End Navigator default action

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 = 28 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 (42,43)