Services Sitemap

Open

Summary

Item	Count	Memory	Time
Files	161	1.27 MB	0.0273 s
Database	31		0.0106 s
Elasticsearch	0		0.0000 s

Timings

Reference	Memory	Peak Memory	Time (s)	Load (%)
appStart	550.64 KB	630.48 KB	0.00000000	0.00
appResolved	621.41 KB	634.41 KB	0.00341702	12.53
handlerImports	621.21 KB	634.41 KB	0.00000811	0.03
handlerSession	672.81 KB	686.13 KB	0.00522590	19.16
handlerSettingLoad	681.88 KB	686.13 KB	0.00041604	1.53
handlerAlias	682.88 KB	699.59 KB	0.00017595	0.65
handlerModuleResolved	684.62 KB	699.59 KB	0.00161409	5.92
handlerResourcesMinified	689.40 KB	699.59 KB	0.00281811	10.33
handlerModuleLoaded	710.12 KB	732.50 KB	0.00078988	2.90
handlerTemplateLoaded	1016.12 KB	1.24 MB	0.01208901	44.33
appEnd	1.23 MB	1.24 MB	0.00071907	2.64
	1.27 MB	1.25 MB	0.02727318	100.00

Logs

Reference	Data
sessionId	879362

DB Queries 31

Query	Parameters	Cardinality	Time (s)	Load (%)
SELECT w.Website_ID FROM website AS w LEFT JOIN website_alias AS wa ON wa.websiteID=w.Website_ID AND w.Domain<>:domain INNER JOIN channel AS c ON c.Channel_ID=w.Channel_ID AND c.active=TRUE WHERE w.Domain=:domain OR wa.domain=:domain GROUP BY w.Website_ID LIMIT 0, 1;	'api-sandbox.cjelectrical.co.uk'	1	0.00014400	1.35
SELECT * FROM `website` WHERE `Website_ID`=?;	'38'	1	0.00011683	1.10
SELECT * FROM channel WHERE Channel_ID=1;		1	0.00050306	4.73
SELECT p.*, c.domain AS defaultDomain, !ISNULL(w.Domain) AS hasPortalUrl FROM portal AS p LEFT JOIN website AS w ON w.portalId=p.id LEFT JOIN channel AS c ON c.`default`=TRUE;		2	0.00037098	3.48
SELECT * FROM customer_session WHERE PHP_Session_ID=?;	'793760ec4db93ecc5c6d7e5f86c74246'	0	0.00140810	13.23
SELECT * FROM `agent` WHERE `userAgent`=?;	'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)'	1	0.00077391	7.27
INSERT INTO `customer_session` (`PHP_Session_ID`, `campaignEventId`, `Referrer`, `Referrer_Search_Term`, `Referrer_Trace`, `IP_Address`, `agentId`, `Channel_ID`, `contactId`, `guestEmail`, `clickId`, `clickSource`, `Created_On`, `modifiedOn`) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?);	'793760ec4db93ecc5c6d7e5f86c74246' '3628718298' '40816' '1' '2026-06-14 18:19:11' '2026-06-14 18:19:11'	1	0.00143003	13.43
SELECT redirectUrl FROM url_alias WHERE type='Redirect' AND alias LIKE ?;	'sitemap'	0	0.00014091	1.32
INSERT INTO `customer_session_item` (`Session_ID`, `contactId`, `Page_Request`, `statusCode`, `clickId`, `Created_On`) VALUES (?, ?, ?, ?, ?, ?);	'879362' 'sitemap?id=5&type=content' '2026-06-14 18:19:11'	1	0.00136495	12.82
SELECT * FROM `content` WHERE `id`=?;	'5'	1	0.00014305	1.34
SELECT an.name FROM channel AS c INNER JOIN asset_name AS an ON an.id=c.svgAssetNameId WHERE c.Channel_ID=?;	'1'	1	0.00014591	1.37
SELECT * FROM `content` WHERE ISNULL(`parentContentId`) AND `channelId`=?;	'1'	1	0.00010204	0.96
SELECT * FROM `content` WHERE `id`=?;	'1'	1	0.00007701	0.72
SELECT c.*, (COUNT(c2.id)>0) hasChildren FROM content AS c LEFT JOIN content AS c2 ON c2.parentContentId=c.id AND c2.menuShow=TRUE WHERE c.menuShow=TRUE AND c.active=TRUE AND c.parentContentId=1 GROUP BY c.id ORDER BY c.sequence ASC;		4	0.00020099	1.89
SELECT * FROM `content` WHERE `id`=?;	'5'	1	0.00013208	1.24
SELECT * FROM `url_alias` WHERE `type`=? AND `referenceId`=? AND `isPrimary`=?;	'Content' '5' '1'	1	0.00012803	1.20
SELECT * FROM `content` WHERE `id`=?;	'5'	1	0.00006914	0.65
SELECT * FROM `url_alias` WHERE `type`=? AND `referenceId`=? AND `isPrimary`=?;	'Content' '5' '1'	1	0.00010395	0.98
SELECT * FROM `content` WHERE `id`=?;	'53'	1	0.00006986	0.66
SELECT * FROM `url_alias` WHERE `type`=? AND `referenceId`=? AND `isPrimary`=?;	'Content' '53' '1'	1	0.00010896	1.02
SELECT * FROM `content` WHERE `id`=?;	'53'	1	0.00011802	1.11
SELECT * FROM `url_alias` WHERE `type`=? AND `referenceId`=? AND `isPrimary`=?;	'Content' '53' '1'	1	0.00006700	0.63
SELECT * FROM `content` WHERE `channelId`=?;	'1'	1	0.00013399	1.26
SELECT parentContentId FROM content WHERE id=1;		1	0.00005889	0.55
SELECT * FROM `content` WHERE `id`=?;	'5'	1	0.00007987	0.75
SELECT * FROM `url_alias` WHERE `type`=? AND `referenceId`=? AND `isPrimary`=?;	'Content' '5' '1'	1	0.00006700	0.63
SELECT id, name, metaTitle FROM content WHERE active=TRUE AND parentContentId=5 ORDER BY name ASC;		16	0.00009894	0.93
SELECT b.*, an.name AS assetName FROM banner AS b INNER JOIN asset_name AS an ON an.id=b.assetNameId WHERE b.isActive=1 AND b.channelId=? AND b.section="footer"	'1'	1	0.00012994	1.22
SELECT IF(COUNT(*)>0, TRUE, FALSE) FROM users AS u WHERE u.Is_Active='Y' AND u.presence='Available' AND u.lastSeenOn>=ADDDATE(NOW(), INTERVAL -5 MINUTE);		1	0.00180101	16.92
SELECT COUNT(*) FROM customer_session_item WHERE Session_ID=879362;		1	0.00055718	5.23
SELECT c.* FROM channel AS c WHERE c.Active=TRUE ORDER BY Name ASC;		4	0.00012398	1.16
			0.01064563	100.00

Includes 161

Filename	Filesize
index.php	8.19 KB
System/Header.php	3.09 KB
portal/admin/lib/common/generic.php	8.82 KB
Config/Common.php	4.91 KB
Config/Deployment.php	52.00 B
Config/Option/cjecs/Dev.php	751.00 B
System/Functions.php	31.56 KB
Vendor/autoload.php	748.00 B
Vendor/composer/autoload_real.php	1.58 KB
Vendor/composer/ClassLoader.php	15.99 KB
Vendor/composer/autoload_static.php	5.70 MB
Vendor/ralouphie/getallheaders/src/getallheaders.php	1.60 KB
Vendor/symfony/deprecation-contracts/function.php	1014.00 B
Vendor/symfony/polyfill-mbstring/bootstrap.php	8.26 KB
Vendor/symfony/polyfill-mbstring/bootstrap80.php	9.78 KB
Vendor/guzzlehttp/guzzle/src/functions_include.php	160.00 B
Vendor/guzzlehttp/guzzle/src/functions.php	5.54 KB
Vendor/symfony/polyfill-php82/bootstrap.php	1.08 KB
Vendor/symfony/polyfill-php80/bootstrap.php	1.50 KB
Vendor/open-telemetry/context/fiber/initialize_fiber_handler.php	138.00 B
Vendor/open-telemetry/context/ZendObserverFiber.php	2.14 KB
Vendor/symfony/translation/Resources/functions.php	563.00 B
Vendor/illuminate/collections/helpers.php	6.02 KB
Vendor/open-telemetry/api/Trace/functions.php	1023.00 B
Vendor/ramsey/uuid/src/functions.php	4.61 KB
Vendor/google/apiclient-services/autoload.php	1.28 KB
Vendor/illuminate/support/helpers.php	10.60 KB
Vendor/mtdowling/jmespath.php/src/JmesPath.php	373.00 B
Vendor/myclabs/deep-copy/src/DeepCopy/deep_copy.php	396.00 B
Vendor/phpseclib/phpseclib/phpseclib/bootstrap.php	741.00 B
Vendor/symfony/polyfill-ctype/bootstrap.php	1.56 KB
Vendor/symfony/polyfill-ctype/bootstrap80.php	1.61 KB
Vendor/aws/aws-sdk-php/src/functions.php	15.43 KB
Vendor/google/apiclient/src/aliases.php	3.00 KB
Vendor/google/apiclient/src/Client.php	36.56 KB
Vendor/google/apiclient/src/Service.php	1.67 KB
Vendor/google/apiclient/src/AccessToken/Revoke.php	2.15 KB
Vendor/google/apiclient/src/AccessToken/Verify.php	8.35 KB
Vendor/google/apiclient/src/Model.php	8.89 KB
Vendor/google/apiclient/src/Utils/UriTemplate.php	9.24 KB
Vendor/google/apiclient/src/AuthHandler/Guzzle6AuthHandler.php	3.02 KB
Vendor/google/apiclient/src/AuthHandler/Guzzle7AuthHandler.php	722.00 B
Vendor/google/apiclient/src/AuthHandler/Guzzle5AuthHandler.php	2.72 KB
Vendor/google/apiclient/src/AuthHandler/AuthHandlerFactory.php	1.60 KB
Vendor/google/apiclient/src/Http/Batch.php	7.02 KB
Vendor/google/apiclient/src/Http/MediaFileUpload.php	9.05 KB
Vendor/google/apiclient/src/Http/REST.php	5.59 KB
Vendor/google/apiclient/src/Task/Retryable.php	751.00 B
Vendor/google/apiclient/src/Task/Exception.php	712.00 B
Vendor/google/apiclient/src/Exception.php	696.00 B
Vendor/google/apiclient/src/Task/Runner.php	7.19 KB
Vendor/google/apiclient/src/Collection.php	2.60 KB
Vendor/google/apiclient/src/Service/Exception.php	1.83 KB
Vendor/google/apiclient/src/Service/Resource.php	9.87 KB
Vendor/google/apiclient/src/Task/Composer.php	3.30 KB
Vendor/league/csv/src/functions_include.php	335.00 B
Vendor/league/csv/src/functions.php	1.21 KB
Vendor/mpdf/mpdf/src/functions.php	521.00 B
Vendor/smarty/smarty/src/functions.php	7.54 KB
System/Application.php	25.85 KB
System/Framework/Cache.php	1012.00 B
System/Library/Data/Adapter/MySql.php	779.00 B
System/Library/Data/Adapter.php	254.00 B
Vendor/vlucas/phpdotenv/src/Dotenv.php	8.06 KB
Vendor/vlucas/phpdotenv/src/Repository/RepositoryBuilder.php	8.02 KB
Vendor/vlucas/phpdotenv/src/Repository/Adapter/ServerConstAdapter.php	1.91 KB
Vendor/vlucas/phpdotenv/src/Repository/Adapter/AdapterInterface.php	346.00 B
Vendor/vlucas/phpdotenv/src/Repository/Adapter/ReaderInterface.php	300.00 B
Vendor/vlucas/phpdotenv/src/Repository/Adapter/WriterInterface.php	518.00 B
Vendor/phpoption/phpoption/src/PhpOption/Some.php	3.24 KB
Vendor/phpoption/phpoption/src/PhpOption/Option.php	13.04 KB
Vendor/vlucas/phpdotenv/src/Repository/Adapter/EnvConstAdapter.php	1.90 KB
Vendor/vlucas/phpdotenv/src/Repository/Adapter/MultiReader.php	969.00 B
Vendor/vlucas/phpdotenv/src/Repository/Adapter/MultiWriter.php	1.27 KB
Vendor/vlucas/phpdotenv/src/Repository/AdapterRepository.php	2.34 KB
Vendor/vlucas/phpdotenv/src/Repository/RepositoryInterface.php	933.00 B
Vendor/vlucas/phpdotenv/src/Store/StoreBuilder.php	3.10 KB
Vendor/vlucas/phpdotenv/src/Store/FileStore.php	1.64 KB
Vendor/vlucas/phpdotenv/src/Store/StoreInterface.php	316.00 B
Vendor/vlucas/phpdotenv/src/Store/File/Paths.php	748.00 B
Vendor/vlucas/phpdotenv/src/Parser/Parser.php	1.71 KB
Vendor/vlucas/phpdotenv/src/Parser/ParserInterface.php	334.00 B
Vendor/vlucas/phpdotenv/src/Loader/Loader.php	1.41 KB
Vendor/vlucas/phpdotenv/src/Loader/LoaderInterface.php	457.00 B
Vendor/vlucas/phpdotenv/src/Store/File/Reader.php	2.05 KB
Vendor/vlucas/phpdotenv/src/Util/Str.php	2.47 KB
Vendor/graham-campbell/result-type/src/Success.php	2.15 KB
Vendor/graham-campbell/result-type/src/Result.php	1.34 KB
Vendor/vlucas/phpdotenv/src/Util/Regex.php	3.00 KB
Vendor/vlucas/phpdotenv/src/Parser/Lines.php	3.07 KB
Vendor/phpoption/phpoption/src/PhpOption/None.php	2.46 KB
Vendor/vlucas/phpdotenv/src/Parser/EntryParser.php	12.16 KB
Vendor/vlucas/phpdotenv/src/Parser/Value.php	1.55 KB
Vendor/vlucas/phpdotenv/src/Parser/Entry.php	1014.00 B
Vendor/vlucas/phpdotenv/src/Parser/Lexer.php	1.24 KB
Vendor/vlucas/phpdotenv/src/Loader/Resolver.php	1.71 KB
System/Framework/Common/Ip.php	4.27 KB
System/Library/Request.php	5.56 KB
System/Library/ReferrerNew.php	1.60 KB
System/Library/Uri.php	1.51 KB
System/Library/Data/Settings.php	838.00 B
System/Library/Data/Connection.php	1.63 KB
System/Framework/Common/Website.php	1.08 KB
System/Library/Data/Record.php	11.47 KB
System/Library/Data/QueryNew.php	5.36 KB
System/Framework/Object/Website.php	1.38 KB
System/Library/Data/Object.php	29.37 KB
portal/admin/lib/classes/Channel.php	2.77 KB
portal/admin/lib/classes/DataQuery.php	1010.00 B
System/Framework/Object/Portal.php	2.02 KB
portal/admin/lib/classes/CustomerSession.php	11.18 KB
System/Framework/Class/Storage.php	1.72 KB
System/Framework/Object/CustomerSession.php	1.56 KB
portal/admin/lib/classes/Contact.php	15.02 KB
portal/admin/lib/classes/Person.php	8.30 KB
portal/admin/lib/classes/Address.php	4.59 KB
portal/admin/lib/classes/Region.php	2.23 KB
portal/admin/lib/classes/Country.php	3.60 KB
portal/admin/lib/classes/AddressFormat.php	607.00 B
portal/admin/lib/classes/Language.php	1.51 KB
portal/admin/lib/classes/Currency.php	2.56 KB
portal/admin/lib/classes/Organisation.php	6.06 KB
portal/admin/lib/classes/OrganisationType.php	1.32 KB
portal/admin/lib/classes/OrganisationIndustry.php	2.05 KB
portal/admin/lib/classes/User.php	3.61 KB
portal/admin/lib/classes/Branch.php	3.07 KB
portal/admin/lib/classes/LeadSource.php	1.30 KB
System/Framework/Object/Agent.php	911.00 B
System/Framework/Common/Campaign.php	15.88 KB
resources/common/settings/config.php	1.88 KB
resources/channels/cjec/settings/config.php	1.33 KB
resources/common/settings/modules.php	1.61 KB
resources/channels/cjec/settings/modules.php	912.00 B
System/Framework/Object/CustomerSessionItem.php	950.00 B
resources/channels/cjec/templates/web/layouts/default-resources.php	1.42 KB
resources/common/templates/web/layouts/head-resources.php	663.00 B
load.php	1.37 KB
resources/common/modules/sitemap.php	599.00 B
System/Framework/Object/Content.php	2.78 KB
resources/channels/cjec/templates/web/layouts/default.php	3.17 KB
resources/common/templates/web/layouts/head.php	4.47 KB
System/Framework/Object/AssetName.php	1.11 KB
resources/common/templates/web/modules/sitemap-head.php	38.00 B
System/Framework/Common/Image.php	7.71 KB
System/Framework/Packages/ImageOptimizer/Pngcrush.php	477.00 B
Vendor/spatie/image-optimizer/src/Optimizers/BaseOptimizer.php	1.26 KB
Vendor/spatie/image-optimizer/src/Optimizer.php	1.05 KB
System/Framework/Common/Channel.php	1.50 KB
resources/common/templates/web/partials/menu-content.php	2.70 KB
System/Framework/Common/Content.php	5.96 KB
System/Framework/Common/UrlAlias.php	2.04 KB
System/Framework/Object/UrlAlias.php	1.83 KB
resources/common/templates/web/layouts/trail.php	1.42 KB
resources/common/templates/web/modules/sitemap-trail.php	801.00 B
resources/common/templates/web/modules/sitemap.php	2.50 KB
resources/common/templates/web/layouts/footer.php	8.92 KB
resources/common/templates/web/partials/segment-banners.php	3.10 KB
resources/common/templates/web/layouts/body.php	10.70 KB
System/Framework/Common/Interaction.php	1.33 KB
System/Framework/Common/CustomerSession.php	2.05 KB
System/Framework/Common/Html.php	1.30 KB