Forum extension data flow

forum.tsv

# Query digest for "/extensions/wikia/Forum" path, found 296763 queries
local:wall_related_pages	getArticlesRelatedMessgesIds	WallRelatedPages	0.49	ap, median time: 73.31 ms, count: 2613800
local:revision	fetchFromConds	Revision	1.00	ap, median time: 39.20 ms, count: 5368000
local:page	newFromID	Title	0.91	ap, median time: 30.49 ms, count: 4909900
local:wikicities_cN	idFromName	User	0.64	ap, median time: 28.99 ms, count: 3424800
local:revision	getFirstRevID	ArticleComment	0.58	ap, median time: 25.01 ms, count: 3113100
local:comments_index	getTotalThreads	Forum	0.00	ap, median time: 151.40 ms, count: 21500
local:comments_index	entriesFromIds	CommentsIndex	0.21	ap, median time: 41.70 ms, count: 1136400
local:page	newFromIDs	Title	0.21	ap, median time: 35.60 ms, count: 1135400
local:comments_index	getThreads	Wall	0.05	ap, median time: 35.69 ms, count: 262100
local:comments_index	getLast7daysOrder	Wall	0.05	ap, median time: 77.51 ms, count: 271500
local:comments_index	getThreadCount	Wall	0.05	ap, median time: 34.12 ms, count: 253100
local:page	addLinkObj	LinkCache	0.14	ap, median time: 28.71 ms, count: 747500
local:ipblocks	newLoad	Block	0.05	ap, median time: 53.38 ms, count: 245300
local:page_restrictions	loadRestrictions	Title	0.09	ap, median time: 32.00 ms, count: 459900
local:text	loadText	Revision	0.05	ap, median time: 46.40 ms, count: 282800
local:page	getWikiaProperties	TitleBatch	0.04	ap, median time: 49.19 ms, count: 238500
blobs20141:blobs	fetchBlob	ExternalStoreDB	0.05	ap, median time: 47.71 ms, count: 280100
local:page	isNewPage	Title	0.06	ap, median time: 26.70 ms, count: 347500
local:page	getBoardList	Forum	0.04	ap, median time: 42.30 ms, count: 239600
local:page	loadRestrictionsFromRows	Title	0.07	ap, median time: 25.61 ms, count: 353500
local:watchlist	isWatched	WatchedItem	0.06	ap, median time: 26.39 ms, count: 334300
local:comments_index	getTotalActiveThreads	ForumBoard	0.04	ap, median time: 35.81 ms, count: 200900
local:user_groups	loadLocalGroups	Wikia\Service\User\Permissions\PermissionsServiceImpl	0.04	ap, median time: 29.11 ms, count: 218700
local:comments_index	entryFromId	CommentsIndex	0.03	ap, median time: 35.41 ms, count: 163100
local:comments_index	getBoardInfoFromMaster	ForumBoard	0.01	ap, median time: 39.70 ms, count: 45900
wikicities:user	initFromCond	ExternalUser_Wikia	0.02	ap, median time: 25.49 ms, count: 131100
local:wikicities_cN	loadFromDatabase	User	0.02	ap, median time: 31.45 ms, count: 86200
local:page	replaceInternal	LinkHolderArray	0.02	ap, median time: 33.20 ms, count: 84400
local:page	pageData	WikiPage	0.02	ap, median time: 34.50 ms, count: 82000
local:wikicities_cN	linkToLocal	ExternalUser_Wikia	0.02	ap, median time: 30.18 ms, count: 86300
local:comments_index	getLastMessage	WallThread	0.01	ap, median time: 35.19 ms, count: 67100
wikicities:user_properties	loadOptions	User	0.02	ap, median time: 27.89 ms, count: 82000
local:wikicities_cN	getNsText	GenderCache::doQuery/Title	0.01	ap, median time: 33.35 ms, count: 49200
local:page_vote	getVoteCount	VoteHelper	0.00	ap, median time: 55.00 ms, count: 18300
local:revision	calculateEditCountWiki	UserStatsService	0.00	ap, median time: 513.51 ms, count: 500
WikiFactory	log	wikicities:city_list_log	0.00	ap, median time: 16485.69 ms, count: 100
local:wikicities_cN	whoIs	User	0.01	ap, median time: 23.25 ms, count: 43800
local:redirect	checkRedirect	LocalRepo	0.00	ap, median time: 31.50 ms, count: 25500
local:page	getArticleID	LocalRepo	0.00	ap, median time: 30.49 ms, count: 26100
local:wikia_user_properties	loadUserStatsFromDB	UserStatsService	0.00	ap, median time: 129.80 ms, count: 4700
local:wikicities_cN	edits	User	0.00	ap, median time: 29.85 ms, count: 19400
local:wall_related_pages	getMessagesRelatedArticleIds	WallRelatedPages	0.00	ap, median time: 29.59 ms, count: 20300
local:image	loadFromDB	WikiaLocalFile	0.00	ap, median time: 40.75 ms, count: 6600
local:page	newFromID	Title	0.00	task, median time: 23.79 ms, count: 6400
Title	invalidateCache	local:page	0.00	ap, median time: 23.22 ms, count: 7300
local:poll_info	save	AjaxPollClass	0.00	ap, median time: 30.21 ms, count: 2900
local:page	newFromID	WikiPage	0.00	ap, median time: 28.94 ms, count: 7200
local:interwiki	load	Interwiki	0.00	ap, median time: 106.81 ms, count: 1400
local:page	loadFromDB(it)-small	MessageCache	0.00	ap, median time: 549.41 ms, count: 100
local:revision	fetchFromConds	Revision	0.00	task, median time: 35.44 ms, count: 600
local:transcache	selectRow	DatabaseBase	0.00	ap, median time: 224.30 ms, count: 200
local:archive	calculateEditCountFromWeek	UserStatsService	0.00	ap, median time: 438.31 ms, count: 100
local:category	initialize	Category	0.00	ap, median time: 115.90 ms, count: 300
wikicities:user_groups	loadGlobalUserGroups	Wikia\Service\User\Permissions\PermissionsServiceImpl	0.00	ap, median time: 18.22 ms, count: 900
local:comments_index	entryFromId	CommentsIndex	0.00	task, median time: 32.10 ms, count: 400
smw+naruto:smw_fpt_inst	getInProperties	SMWSQLStore3Readers	0.00	ap, median time: 20.50 ms, count: 500
local:page	addLinkObj	LinkCache	0.00	task, median time: 21.79 ms, count: 400
local:revision	getPreviousRevisionID	Title	0.00	ap, median time: 70.81 ms, count: 100
UserStatsService	setUserStat	local:wikia_user_properties	0.00	ap, median time: 23.01 ms, count: 300
WikiPage	doDeleteUpdates	local:langlinks	0.00	ap, median time: 67.50 ms, count: 100
local:wikicities_cN	loadFromDatabase	User	0.00	task, median time: 25.20 ms, count: 100
local:revision	getFirstRevID	ArticleComment	0.00	task, median time: 23.41 ms, count: 100