Case Studies Sitemap - CJ Electrical

Summary

Item	Count	Memory	Time
Files	161	1.27 MB	0.0187 s
Database	31		0.0081 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.00237107	12.70
handlerImports	621.21 KB	634.41 KB	0.00000787	0.04
handlerSession	672.81 KB	686.13 KB	0.00378013	20.24
handlerSettingLoad	681.88 KB	686.13 KB	0.00028181	1.51
handlerAlias	682.88 KB	699.59 KB	0.00012112	0.65
handlerModuleResolved	684.62 KB	699.59 KB	0.00145102	7.77
handlerResourcesMinified	689.40 KB	699.59 KB	0.00176096	9.43
handlerModuleLoaded	710.11 KB	732.49 KB	0.00056696	3.04
handlerTemplateLoaded	1018.22 KB	1.24 MB	0.00786114	42.09
appEnd	1.24 MB	1.24 MB	0.00047398	2.54
	1.27 MB	1.25 MB	0.01867606	100.00

Logs

Reference	Data
sessionId	777927

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.00014496	1.79
SELECT * FROM `website` WHERE `Website_ID`=?;	'38'	1	0.00010800	1.33
SELECT * FROM channel WHERE Channel_ID=1;		1	0.00009203	1.13
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.00008297	1.02
SELECT * FROM customer_session WHERE PHP_Session_ID=?;	'5863893abcfb9ff04ad1bfd803125a14'	0	0.00117612	14.48
SELECT * FROM `agent` WHERE `userAgent`=?;	'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)'	1	0.00007606	0.94
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 (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?);	'5863893abcfb9ff04ad1bfd803125a14' '3628718331' '40816' '1' '2026-04-20 10:47:04' '2026-04-20 10:47:04'	1	0.00131297	16.17
SELECT redirectUrl FROM url_alias WHERE type='Redirect' AND alias LIKE ?;	'sitemap'	0	0.00009108	1.12
INSERT INTO `customer_session_item` (`Session_ID`, `contactId`, `Page_Request`, `statusCode`, `clickId`, `Created_On`) VALUES (?, ?, ?, ?, ?, ?);	'777927' 'sitemap?id=60&type=content' '2026-04-20 10:47:04'	1	0.00130296	16.05
SELECT * FROM `content` WHERE `id`=?;	'60'	1	0.00014591	1.80
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.00010991	1.35
SELECT * FROM `content` WHERE ISNULL(`parentContentId`) AND `channelId`=?;	'1'	1	0.00011206	1.38
SELECT * FROM `content` WHERE `id`=?;	'1'	1	0.00007391	0.91
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.00007105	0.88
SELECT * FROM `content` WHERE `id`=?;	'5'	1	0.00007987	0.98
SELECT * FROM `url_alias` WHERE `type`=? AND `referenceId`=? AND `isPrimary`=?;	'Content' '5' '1'	1	0.00007796	0.96
SELECT * FROM `content` WHERE `id`=?;	'5'	1	0.00007010	0.86
SELECT * FROM `url_alias` WHERE `type`=? AND `referenceId`=? AND `isPrimary`=?;	'Content' '5' '1'	1	0.00010300	1.27
SELECT * FROM `content` WHERE `id`=?;	'53'	1	0.00007296	0.90
SELECT * FROM `url_alias` WHERE `type`=? AND `referenceId`=? AND `isPrimary`=?;	'Content' '53' '1'	1	0.00006604	0.81
SELECT * FROM `content` WHERE `id`=?;	'53'	1	0.00006795	0.84
SELECT * FROM `url_alias` WHERE `type`=? AND `referenceId`=? AND `isPrimary`=?;	'Content' '53' '1'	1	0.00006390	0.79
SELECT * FROM `content` WHERE `channelId`=?;	'1'	1	0.00008297	1.02
SELECT parentContentId FROM content WHERE id=1;		1	0.00007510	0.92
SELECT * FROM `content` WHERE `id`=?;	'60'	1	0.00008297	1.02
SELECT * FROM `url_alias` WHERE `type`=? AND `referenceId`=? AND `isPrimary`=?;	'Content' '60' '1'	1	0.00006700	0.83
SELECT id, name, metaTitle FROM content WHERE active=TRUE AND parentContentId=60 ORDER BY name ASC;		20	0.00141191	17.39
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.00010896	1.34
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.00054097	6.66
SELECT COUNT(*) FROM customer_session_item WHERE Session_ID=777927;		1	0.00024796	3.05
SELECT c.* FROM channel AS c WHERE c.Active=TRUE ORDER BY Name ASC;		4	0.00013804	1.70
			0.00811958	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