Time: 0.395573 / SQL: 0.06023s for 105 queries / Net Memory: 8125160 / Peak: 8697552

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

UPDATE cms_siteprefs SET sitepref_value = 1773561046 WHERE sitepref_name = 'CmsJobManager_mapi_pref_tasks_lastcheck'

SELECT sitepref_name,sitepref_value FROM cms_siteprefs

INSERT INTO cms_mod_cmsjobmgr (name,created,module,errors,start,recurs,until,data) VALUES ('CGFeedback\\CreateAlertsTask',1773561046,'CGFeedback',0,1773561046,NULL,NULL,'O:23:\"CMSMS\\Async\\RegularTask\":7:{s:30:\"\0CMSMS\\Async\\RegularTask\0_task\";O:27:\"CGFeedback\\CreateAlertsTask\":0:{}s:20:\"\0CMSMS\\Async\\Job\0_id\";N;s:22:\"\0CMSMS\\Async\\Job\0_name\";s:27:\"CGFeedback\\CreateAlertsTask\";s:25:\"\0CMSMS\\Async\\Job\0_created\";i:1773561046;s:24:\"\0CMSMS\\Async\\Job\0_module\";s:10:\"CGFeedback\";s:23:\"\0CMSMS\\Async\\Job\0_start\";i:1773561046;s:24:\"\0CMSMS\\Async\\Job\0_errors\";N;}')

INSERT INTO cms_mod_cmsjobmgr (name,created,module,errors,start,recurs,until,data) VALUES ('FrontEndUsers\\ClearExpiredAuthTokensTask',1773561046,'FrontEndUsers',0,1773561046,NULL,NULL,'O:23:\"CMSMS\\Async\\RegularTask\":7:{s:30:\"\0CMSMS\\Async\\RegularTask\0_task\";O:40:\"FrontEndUsers\\ClearExpiredAuthTokensTask\":0:{}s:20:\"\0CMSMS\\Async\\Job\0_id\";N;s:22:\"\0CMSMS\\Async\\Job\0_name\";s:40:\"FrontEndUsers\\ClearExpiredAuthTokensTask\";s:25:\"\0CMSMS\\Async\\Job\0_created\";i:1773561046;s:24:\"\0CMSMS\\Async\\Job\0_module\";s:13:\"FrontEndUsers\";s:23:\"\0CMSMS\\Async\\Job\0_start\";i:1773561046;s:24:\"\0CMSMS\\Async\\Job\0_errors\";N;}')

INSERT INTO cms_mod_cmsjobmgr (name,created,module,errors,start,recurs,until,data) VALUES ('FrontEndUsers\\ClearExpiredTempCodesTask',1773561046,'FrontEndUsers',0,1773561046,NULL,NULL,'O:23:\"CMSMS\\Async\\RegularTask\":7:{s:30:\"\0CMSMS\\Async\\RegularTask\0_task\";O:39:\"FrontEndUsers\\ClearExpiredTempCodesTask\":1:{s:11:\"expiry_days\";i:2;}s:20:\"\0CMSMS\\Async\\Job\0_id\";N;s:22:\"\0CMSMS\\Async\\Job\0_name\";s:39:\"FrontEndUsers\\ClearExpiredTempCodesTask\";s:25:\"\0CMSMS\\Async\\Job\0_created\";i:1773561046;s:24:\"\0CMSMS\\Async\\Job\0_module\";s:13:\"FrontEndUsers\";s:23:\"\0CMSMS\\Async\\Job\0_start\";i:1773561046;s:24:\"\0CMSMS\\Async\\Job\0_errors\";N;}')

SELECT * FROM cms_content WHERE content_id = 15 LIMIT  1

UPDATE cms_siteprefs SET sitepref_value = 1773561047 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

SELECT * FROM cms_content FORCE INDEX (cms_index_content_by_idhier) WHERE content_id IN (114,118,62,63,64,65,66,67,68,69,70,71,72,73,74,75,76,77,78,79,80,81,82,60,61,57,58,59,125,128,133,136,137,160,161,162,117,116,115,83,87,91,95,99,122,102,107,110,84,85,86,90,89,88,93,94,92,98,97,96,100,123,124,126,105,104,103,106,108,109,113,111,112,119,127) AND active = 1 ORDER BY hierarchy

cms_content_cache: end loading needed content objects

SELECT tpl_id,design_id FROM cms_layout_design_tplassoc
                   WHERE tpl_id IN (148,144,109,124,143,145,131,6,113) ORDER BY tpl_id

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

process template top

SELECT * FROM cms_content_props WHERE content_id = 114

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

SELECT * FROM cms_module_compdir_hier ORDER BY hierarchy

SELECT COUNT(DISTINCT C.id) AS count FROM cms_module_compdir_companies C WHERE (C.status = 'published') AND (C.hier_id IN (32,33,34,35)) LIMIT  1

SELECT DISTINCT C.* FROM cms_module_compdir_companies C WHERE (C.status = 'published') AND (C.hier_id IN (32,33,34,35)) ORDER BY fax desc,company_name ASC LIMIT 0, 21

SELECT fv.* FROM cms_module_compdir_fieldvals fv WHERE fv.company_id IN (81,301,303,377,596,606,612,616,626,627,825,826,830,944,1043,1056,1059,1060,1132,1136,1138) ORDER BY fv.company_id,fv.fielddef_id

SELECT * FROM cms_module_compdir_fielddefs ORDER BY item_order

SELECT * FROM cms_module_compdir_categories ORDER BY hierarchy ASC

SELECT * FROM cms_module_compdir_company_categories C where C.company_id IN (81,301,303,377,596,606,612,616,626,627,825,826,830,944,1043,1056,1059,1060,1132,1136,1138) ORDER BY C.company_id

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

SELECT * from cms_module_templates WHERE module_name = 'CompanyDirectory' and template_name = 'summary_4BS-province' 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 = 'CWca' AND banner_id != '52' LIMIT  1

UPDATE cms_module_banners
                  SET category_id = '12', name = 'CWca', description = 'display ads', image = 'banners/displayAdvertising.jpg', url = '../banner-ads', text = 'display advertising on cinchWedding.ca', href_text = 'Display Advertising',
                      start_date = '2025-06-11 00:00:00', expires = NULL, max_impressions = '0', num_impressions = 177657, last_impression = '2026-03-15 03:50:47'
                  WHERE banner_id = '52'

SELECT * FROM cms_module_smarty_plugins ORDER BY module

Start Navigator default action

End Navigator default action

Start Navigator default action

SELECT * FROM cms_content_props WHERE content_id = 15

SELECT * FROM cms_content_props WHERE content_id = 60

SELECT * FROM cms_content_props WHERE content_id = 62

SELECT * FROM cms_content_props WHERE content_id = 63

SELECT * FROM cms_content_props WHERE content_id = 64

SELECT * FROM cms_content_props WHERE content_id = 65

SELECT * FROM cms_content_props WHERE content_id = 66

SELECT * FROM cms_content_props WHERE content_id = 67

SELECT * FROM cms_content_props WHERE content_id = 68

SELECT * FROM cms_content_props WHERE content_id = 69

SELECT * FROM cms_content_props WHERE content_id = 70

SELECT * FROM cms_content_props WHERE content_id = 71

SELECT * FROM cms_content_props WHERE content_id = 72

SELECT * FROM cms_content_props WHERE content_id = 73

SELECT * FROM cms_content_props WHERE content_id = 74

SELECT * FROM cms_content_props WHERE content_id = 75

SELECT * FROM cms_content_props WHERE content_id = 76

SELECT * FROM cms_content_props WHERE content_id = 77

SELECT * FROM cms_content_props WHERE content_id = 78

SELECT * FROM cms_content_props WHERE content_id = 79

SELECT * FROM cms_content_props WHERE content_id = 80

SELECT * FROM cms_content_props WHERE content_id = 81

SELECT * FROM cms_content_props WHERE content_id = 82

SELECT * FROM cms_content_props WHERE content_id = 61

SELECT * FROM cms_content_props WHERE content_id = 83

SELECT * FROM cms_content_props WHERE content_id = 84

SELECT * FROM cms_content_props WHERE content_id = 85

SELECT * FROM cms_content_props WHERE content_id = 86

SELECT * FROM cms_content_props WHERE content_id = 87

SELECT * FROM cms_content_props WHERE content_id = 90

SELECT * FROM cms_content_props WHERE content_id = 89

SELECT * FROM cms_content_props WHERE content_id = 88

SELECT * FROM cms_content_props WHERE content_id = 91

SELECT * FROM cms_content_props WHERE content_id = 93

SELECT * FROM cms_content_props WHERE content_id = 94

SELECT * FROM cms_content_props WHERE content_id = 92

SELECT * FROM cms_content_props WHERE content_id = 95

SELECT * FROM cms_content_props WHERE content_id = 98

SELECT * FROM cms_content_props WHERE content_id = 97

SELECT * FROM cms_content_props WHERE content_id = 96

SELECT * FROM cms_content_props WHERE content_id = 99

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

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

SELECT * FROM cms_content_props WHERE content_id = 100

SELECT * FROM cms_content_props WHERE content_id = 122

SELECT * FROM cms_content_props WHERE content_id = 123

SELECT * FROM cms_content_props WHERE content_id = 124

SELECT * FROM cms_content_props WHERE content_id = 102

SELECT * FROM cms_content_props WHERE content_id = 126

SELECT * FROM cms_content_props WHERE content_id = 105

SELECT * FROM cms_content_props WHERE content_id = 104

SELECT * FROM cms_content_props WHERE content_id = 103

SELECT * FROM cms_content_props WHERE content_id = 106

SELECT * FROM cms_content_props WHERE content_id = 107

SELECT * FROM cms_content_props WHERE content_id = 108

SELECT * FROM cms_content_props WHERE content_id = 109

SELECT * FROM cms_content_props WHERE content_id = 110

SELECT * FROM cms_content_props WHERE content_id = 113

SELECT * FROM cms_content_props WHERE content_id = 111

SELECT * FROM cms_content_props WHERE content_id = 112

SELECT * FROM cms_content_props WHERE content_id = 117

SELECT * FROM cms_content_props WHERE content_id = 116

SELECT * FROM cms_content_props WHERE content_id = 115

SELECT * FROM cms_content_props WHERE content_id = 57

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

SELECT * FROM cms_content_props WHERE content_id IN (120) ORDER BY content_id

SELECT * FROM cms_content_props WHERE content_id = 162

End Navigator default action

Start Navigator default action

End Navigator default action

Start Navigator default action

End Navigator default action

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

You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ') GROUP BY CC.category_id) AS S1

            ON CAT.id = S1.category_id 

     ' at line 7

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

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

Start Navigator default action

End Navigator default action

You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ') GROUP BY CC.category_id) AS S1

            ON CAT.id = S1.category_id 

     ' at line 7

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)