Job Terms and Conditions Sitemap

Open

Summary

Item	Count	Memory	Time
Files	161	1.24 MB	0.0169 s
Database	26		0.0074 s
Elasticsearch	0		0.0000 s

Timings

Reference	Memory	Peak Memory	Time (s)	Load (%)
appStart	548.94 KB	659.66 KB	0.00000000	0.00
appResolved	619.10 KB	659.66 KB	0.00298810	17.69
handlerImports	618.91 KB	659.66 KB	0.00000787	0.05
handlerSession	665.76 KB	679.08 KB	0.00276113	16.35
handlerSettingLoad	678.82 KB	682.12 KB	0.00032306	1.91
handlerAlias	679.82 KB	696.53 KB	0.00022793	1.35
handlerModuleResolved	681.57 KB	696.53 KB	0.00121689	7.20
handlerResourcesMinified	686.33 KB	696.53 KB	0.00162005	9.59
handlerModuleLoaded	707.05 KB	729.44 KB	0.00059700	3.53
handlerTemplateLoaded	995.39 KB	1.22 MB	0.00670004	39.67
appEnd	1.21 MB	1.22 MB	0.00044894	2.66
	1.24 MB	1.22 MB	0.01689101	100.00

Logs

Reference	Data
sessionId	98303

DB Queries 26

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.tca-tech.co.uk'	1	0.00044608	6.04
SELECT * FROM `website` WHERE `Website_ID`=?;	'7'	1	0.00019503	2.64
SELECT * FROM channel WHERE Channel_ID=1;		1	0.00017691	2.39
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.00024700	3.34
SELECT * FROM customer_session WHERE PHP_Session_ID=?;	'c39141e781a7519b51be3f7c7e0e52cc'	0	0.00023007	3.11
SELECT * FROM `agent` WHERE `userAgent`=?;	'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)'	1	0.00019002	2.57
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 (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?);	'c39141e781a7519b51be3f7c7e0e52cc' '3628718404' '426' '1' '2026-06-18 14:21:28' '2026-06-18 14:21:28'	1	0.00118613	16.05
SELECT redirectUrl FROM url_alias WHERE type='Redirect' AND alias LIKE ?;	'sitemap'	0	0.00020695	2.80
INSERT INTO `customer_session_item` (`Session_ID`, `contactId`, `Page_Request`, `statusCode`, `clickId`, `Created_On`) VALUES (?, ?, ?, ?, ?, ?);	'98303' 'sitemap?id=7&type=content' '2026-06-18 14:21:28'	1	0.00108290	14.65
SELECT * FROM `content` WHERE `id`=?;	'7'	1	0.00024700	3.34
SELECT * FROM `asset_name` WHERE `id`=?;	'13'	1	0.00018406	2.49
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.00021100	2.86
SELECT * FROM `content` WHERE ISNULL(`parentContentId`) AND `channelId`=?;	'1'	1	0.00025105	3.40
SELECT * FROM `content` WHERE `id`=?;	'1'	1	0.00016499	2.23
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;		2	0.00063586	8.60
SELECT * FROM `content` WHERE `channelId`=?;	'1'	1	0.00019097	2.58
SELECT parentContentId FROM content WHERE id=5;		1	0.00015807	2.14
SELECT parentContentId FROM content WHERE id=1;		1	0.00011301	1.53
SELECT id, name, menuTitle FROM content WHERE id IN (5);		1	0.00011492	1.55
SELECT * FROM `content` WHERE `id`=?;	'7'	1	0.00015211	2.06
SELECT * FROM `url_alias` WHERE `type`=? AND `referenceId`=? AND `isPrimary`=?;	'Content' '7' '1'	1	0.00022912	3.10
SELECT id, name, metaTitle FROM content WHERE active=TRUE AND parentContentId=7 ORDER BY name ASC;		0	0.00017214	2.33
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'	0	0.00022292	3.02
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.00022697	3.07
SELECT COUNT(*) FROM customer_session_item WHERE Session_ID=98303;		1	0.00015497	2.10
SELECT c.* FROM channel AS c WHERE c.Active=TRUE ORDER BY Name ASC;		1	0.00020504	2.77
			0.00739026	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	50.00 B
Config/Option/tca/Dev.php	915.00 B
System/Functions.php	31.56 KB
Vendor/autoload.php	771.00 B
Vendor/composer/autoload_real.php	1.58 KB
Vendor/composer/ClassLoader.php	15.99 KB
Vendor/composer/autoload_static.php	6.07 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	14.32 KB
portal/admin/lib/classes/Person.php	7.81 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.08 KB
portal/admin/lib/classes/AddressFormat.php	607.00 B
portal/admin/lib/classes/Currency.php	2.56 KB
portal/admin/lib/classes/Organisation.php	5.58 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/tcatech/settings/config.php	710.00 B
resources/common/settings/modules.php	1.61 KB
resources/channels/tcatech/settings/modules.php	985.00 B
System/Framework/Object/CustomerSessionItem.php	950.00 B
resources/channels/tcatech/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/tcatech/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
System/Framework/Common/Asset.php	12.44 KB
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
resources/common/templates/web/modules/sitemap-head.php	38.00 B
System/Framework/Common/Channel.php	1.50 KB
resources/common/templates/web/partials/menu-content.php	2.70 KB
resources/common/templates/web/layouts/trail.php	1.42 KB
resources/common/templates/web/modules/sitemap-trail.php	801.00 B
System/Framework/Common/Content.php	5.96 KB
resources/common/templates/web/modules/sitemap.php	2.50 KB
System/Framework/Common/UrlAlias.php	2.04 KB
System/Framework/Object/UrlAlias.php	1.83 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