Services Sitemap

Open

Summary

Item	Count	Memory	Time
Files	161	1.27 MB	0.0244 s
Database	30		0.0066 s
Elasticsearch	0		0.0000 s

Timings

Reference	Memory	Peak Memory	Time (s)	Load (%)
appStart	551.74 KB	631.58 KB	0.00000000	0.00
appResolved	622.51 KB	635.51 KB	0.00338292	13.88
handlerImports	622.31 KB	635.51 KB	0.00001311	0.05
handlerSession	672.54 KB	684.41 KB	0.00235605	9.67
handlerSettingLoad	681.60 KB	684.91 KB	0.00040984	1.68
handlerAlias	682.60 KB	699.31 KB	0.00010514	0.43
handlerModuleResolved	684.20 KB	699.31 KB	0.00159097	6.53
handlerResourcesMinified	688.97 KB	699.31 KB	0.00285006	11.70
handlerModuleLoaded	709.84 KB	732.23 KB	0.00084400	3.46
handlerTemplateLoaded	1015.84 KB	1.24 MB	0.01108694	45.50
appEnd	1.23 MB	1.24 MB	0.00172806	7.09
	1.27 MB	1.25 MB	0.02436709	100.00

Logs

Reference	Data
sessionId	777920

DB Queries 30

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.00011706	1.78
SELECT * FROM `website` WHERE `Website_ID`=?;	'38'	1	0.00006604	1.01
SELECT * FROM channel WHERE Channel_ID=1;		1	0.00006485	0.99
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.00011206	1.71
SELECT * FROM customer_session WHERE PHP_Session_ID=?;	'a95029eff147b0f63757d9d9a69f2721'	1	0.00047493	7.24
SELECT * FROM `agent` WHERE `userAgent`=?;	'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)'	1	0.00009894	1.51
SELECT redirectUrl FROM url_alias WHERE type='Redirect' AND alias LIKE ?;	'sitemap'	0	0.00007915	1.21
INSERT INTO `customer_session_item` (`Session_ID`, `contactId`, `Page_Request`, `statusCode`, `clickId`, `Created_On`) VALUES (?, ?, ?, ?, ?, ?);	'777920' 'sitemap?id=5&type=content' '2026-04-20 10:41:43'	1	0.00138617	21.14
SELECT * FROM `content` WHERE `id`=?;	'5'	1	0.00010896	1.66
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.00011015	1.68
SELECT * FROM `content` WHERE ISNULL(`parentContentId`) AND `channelId`=?;	'1'	1	0.00010300	1.57
SELECT * FROM `content` WHERE `id`=?;	'1'	1	0.00007105	1.08
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.00007892	1.20
SELECT * FROM `content` WHERE `id`=?;	'5'	1	0.00007987	1.22
SELECT * FROM `url_alias` WHERE `type`=? AND `referenceId`=? AND `isPrimary`=?;	'Content' '5' '1'	1	0.00006199	0.95
SELECT * FROM `content` WHERE `id`=?;	'5'	1	0.00005984	0.91
SELECT * FROM `url_alias` WHERE `type`=? AND `referenceId`=? AND `isPrimary`=?;	'Content' '5' '1'	1	0.00005388	0.82
SELECT * FROM `content` WHERE `id`=?;	'53'	1	0.00005603	0.85
SELECT * FROM `url_alias` WHERE `type`=? AND `referenceId`=? AND `isPrimary`=?;	'Content' '53' '1'	1	0.00004888	0.75
SELECT * FROM `content` WHERE `id`=?;	'53'	1	0.00005507	0.84
SELECT * FROM `url_alias` WHERE `type`=? AND `referenceId`=? AND `isPrimary`=?;	'Content' '53' '1'	1	0.00009394	1.43
SELECT * FROM `content` WHERE `channelId`=?;	'1'	1	0.00143194	21.83
SELECT parentContentId FROM content WHERE id=1;		1	0.00036311	5.54
SELECT * FROM `content` WHERE `id`=?;	'5'	1	0.00008011	1.22
SELECT * FROM `url_alias` WHERE `type`=? AND `referenceId`=? AND `isPrimary`=?;	'Content' '5' '1'	1	0.00006199	0.95
SELECT id, name, metaTitle FROM content WHERE active=TRUE AND parentContentId=5 ORDER BY name ASC;		16	0.00044203	6.74
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.00008607	1.31
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.00043321	6.61
SELECT COUNT(*) FROM customer_session_item WHERE Session_ID=777920;		1	0.00027919	4.26
SELECT c.* FROM channel AS c WHERE c.Active=TRUE ORDER BY Name ASC;		4	0.00012684	1.93
			0.00655842	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