Profiling/Live aggregate 20040606
Appearance
+------------------------------------------------------------------------+------------------+--------+--------------------+---------------------+ | name | total | count | each | percent | +------------------------------------------------------------------------+------------------+--------+--------------------+---------------------+ | -total | 153914.532899876 | 455 | 338.27369868105 | 100 | | Setup.php | 37718.2647026078 | 455 | 82.897285060676 | 24.505980034481 | | Article::view | 32083.8423771857 | 323 | 99.330781353516 | 20.845232592855 | | OutputPage::output | 26036.386381723 | 454 | 57.348868682209 | 16.916132538738 | | Parser::parse | 24658.791061921 | 151 | 163.3032520657 | 16.021093393411 | | Parser::internalParse | 19239.5178952636 | 187 | 102.88512243456 | 12.500130775681 | | Skin::makeLink | 16532.9234892218 | 5597 | 2.9538902071148 | 10.741626003554 | | Setup.php-includes | 16454.8572338009 | 455 | 36.164521392969 | 10.690905480969 | | LinkCache::addLinkObj | 12739.0668339002 | 3427 | 3.7172649063029 | 8.2767147415424 | | Parser::replaceInternalLinks | 11855.9724646544 | 374 | 31.70046113544 | 7.7029584154778 | | query: SELECT cur_id FROM cur WHERE cur_namespace=N AND cur_title='X' | 11726.8168873033 | 3427 | 3.421889958361 | 7.6190445868629 | | PageHistory::history | 11532.8745602584 | 9 | 1281.4305066954 | 7.493038079621 | | Setup.php-MessageCache | 11346.7129505111 | 455 | 24.937830660464 | 7.3720867917602 | | wfMsg | 10015.1609862746 | 44826 | 0.223423035432 | 6.5069625314652 | | -overhead-total | 9585.64019203235 | 177219 | 0.054089235307909 | 6.2278980492817 | | query: SELECT old_id,old_user,old_comment,old_user_text,old_timestamp, | 8866.59810533308 | 9 | 985.17756725923 | 5.7607283329775 | | Title::secureAndSplit | 7222.66003514673 | 39703 | 0.18191723635863 | 4.6926433125358 | | query: SELECT cur_namespace,cur_title,cur_comment, cur_id, cur_user,cu | 7156.26574009 | 1 | 7156.26574009 | 4.6495061936388 | | ParserCache::get | 6623.95288747402 | 315 | 21.028421864997 | 4.3036565570991 | | Parser::tidy | 5470.2064958113 | 151 | 36.226533084843 | 3.5540545735014 | | query: SELECT LENGTH(cur_text) AS x, cur_namespace, cur_is_redirect FR | 5003.36143982873 | 3622 | 1.3813808503116 | 3.2507400994314 | | Skin::makeKnownLinkObj | 4918.46818257307 | 22288 | 0.22067786174502 | 3.1955839971087 | | Parser::replaceVariables | 4787.5895591012 | 601 | 7.9660391998356 | 3.1105506860847 | | -overhead-internal | 4632.70068168239 | 177219 | 0.02614110609857 | 3.009917643512 | | Setup.php-memcached | 4622.21873167711 | 455 | 10.158722487202 | 3.0031074029143 | | Title::newFromText | 4438.23934024867 | 31885 | 0.13919521217653 | 2.8835739267947 | | LinkCache::preFill | 3048.62646289077 | 117 | 26.056636434964 | 1.9807268394038 | | Setup.php-misc | 2547.27518920137 | 455 | 5.5984070092338 | 1.6549932882936 | | Parser::replaceExternalLinks | 2310.62575964794 | 187 | 12.356287484748 | 1.5012394970857 | | query: SELECT lcc_cacheobj FROM linkscc WHERE lcc_pageid = N | 1979.28568691788 | 109 | 18.15858428365 | 1.2859641319286 | | LinksUpdate::doUpdate | 1833.3497018634 | 5 | 366.66994037268 | 1.1911478840377 | | query: SELECT old_namespace,old_title,old_timestamp,old_comment,old_mi | 1668.94830098715 | 3 | 556.31610032905 | 1.084334448179 | | query: COMMIT | 1637.92750239433 | 368 | 4.4508899521585 | 1.0641798870675 | | Skin::outputPage | 1634.546219073 | 17 | 96.149777592529 | 1.0619830293325 | | query: UPDATE recentchanges SET rc_cur_time='X' WHERE rc_cur_id=N | 1285.24994562691 | 5 | 257.04998912538 | 0.83504131897862 | | Article::getContent | 1244.29223754316 | 148 | 8.4073799833998 | 0.80843063621068 | | query: SELECT cur_touched,cur_is_redirect FROM cur WHERE cur_id=N | 1239.94956234074 | 237 | 5.2318546934209 | 0.80560915137712 | | Parser::doBlockLevels | 1214.1776051971 | 151 | 8.040911292696 | 0.78886482148306 | | main-misc-setup | 1160.56287650258 | 455 | 2.550687640665 | 0.75403073032587 | | Skin::doAfterContent | 1097.8477481363 | 14 | 78.41769629545 | 0.71328400733313 | | query: SELECT ss_total_views, ss_total_edits, ss_good_articles FROM si | 930.715025793785 | 396 | 2.3502904691762 | 0.60469600125365 | | Setup.php-language | 922.37770918973 | 455 | 2.0272037564609 | 0.59927915305422 | | Skin::doAfterContent-3 | 800.2214911937 | 14 | 57.158677942407 | 0.519912886793 | | query: SELECT cur_id,cur_namespace,cur_title FROM cur,links WHERE cur_ | 768.6621624831 | 11 | 69.878378407555 | 0.49940843661796 | | query: SELECT cur_text,cur_timestamp,cur_user,cur_user_text,cur_commen | 726.090232929373 | 156 | 4.6544245700601 | 0.47174897603835 | | query: SHOW COLUMNS FROM cur LIKE 'X'; | 568.84777325463 | 434 | 1.3107091549646 | 0.36958678465059 | | Setup.php-User | 530.434731284554 | 455 | 1.1657906182078 | 0.34462940002528 | | query: UPDATE cur SET cur_touched='X' | 522.7615545933 | 7 | 74.680222084757 | 0.33964405098339 | | query: SELECT cur_text FROM cur WHERE cur_namespace=N AND cur_title='X | 518.040200275416 | 469 | 1.1045633268133 | 0.33657653407714 | | query: SELECT N FROM user_newtalk WHERE user_ip='X' | 486.077098595108 | 374 | 1.2996713866179 | 0.31580974807058 | | query: SELECT cur_id,cur_title FROM cur USE INDEX (cur_random) WHERE c | 464.79343598858 | 9 | 51.643715109842 | 0.30198151352669 | | query: SELECT cur_user,cur_user_text,cur_timestamp,cur_comment,cur_min | 453.797469060113 | 251 | 1.8079580440642 | 0.29483731036322 | | query: BEGIN | 422.54564166031 | 368 | 1.1482218523378 | 0.27453264724208 | | query: SELECT cur_namespace,cur_title,cur_timestamp,cur_comment,cur_mi | 420.839437156543 | 3 | 140.27981238551 | 0.27342410702068 | | query: DELETE FROM categorylinks WHERE cl_from='X' | 380.756852131941 | 5 | 76.151370426388 | 0.24738200152914 | | Setup.php-SetupSession | 330.228213111188 | 455 | 0.72577629255206 | 0.21455297748005 | | query: SELECT COUNT(*) AS n FROM cur WHERE cur_timestamp>'X' | 329.0776090947 | 5 | 65.81552181894 | 0.21380541713288 | | Parser::doAllQuotes | 324.8123803595 | 187 | 1.7369646008529 | 0.21103425013855 | | Parser::removeHTMLtags | 320.657698200262 | 187 | 1.7147470491993 | 0.20833490649571 | | query: SELECT cur_restrictions FROM cur WHERE (cur_id=N) | 296.46182832345 | 242 | 1.2250488773696 | 0.19261457819341 | | query: UPDATE LOW_PRIORITY site_stats SET ss_total_views=(ss_total_vie | 296.3108987628 | 5 | 59.26217975256 | 0.19251651756339 | | Skin::doAfterContent-4 | 293.928432798471 | 14 | 20.994888057034 | 0.19096860267878 | | Skin::quickBar | 292.871926619 | 13 | 22.528609739923 | 0.19028217875275 | | Setup.php-OutputPage | 288.586500922614 | 455 | 0.63425604598377 | 0.18749788956599 | | Skin::makeBrokenLinkObj | 260.567485604553 | 1274 | 0.20452706876339 | 0.16929362074864 | | query: INSERT IGNORE INTO categorylinks (cl_from,cl_to,cl_sortkey) VAL | 257.4182366072 | 3 | 85.806078869067 | 0.16724751831892 | | query: SELECT cur_id,cur_namespace,cur_title,cur_is_redirect FROM link | 253.146080044 | 1 | 253.146080044 | 0.16447185023696 | | Skin::doBeforeContent | 240.37461314205 | 14 | 17.169615224432 | 0.15617408480745 | | query: DELETE FROM links WHERE l_from=N AND l_to IN(N) | 212.1957064138 | 2 | 106.0978532069 | 0.13786593274583 | | query: SELECT * FROM ipblocks WHERE (ipb_address='X' OR ipb_user=N) | 206.892529858109 | 96 | 2.1551305193553 | 0.13442039939964 | | query: SELECT math_outputhash,math_html_conservativeness,math_html,mat | 202.3343235185 | 15 | 13.488954901233 | 0.13145888156651 | | Setup.php-DateFormatter | 202.155236045298 | 455 | 0.44429722207758 | 0.13134252642459 | | query: INSERT IGNORE INTO links (l_from,l_to) VALUES (N,N),(N,N) | 194.5842028124 | 2 | 97.2921014062 | 0.12642354113434 | | query: SELECT user_id FROM user WHERE user_name='X' | 188.131948117125 | 10 | 18.813194811712 | 0.12223143882034 | | query: UPDATE user SET user_name= 'X' WHERE user_id=N | 178.8529712512 | 4 | 44.7132428128 | 0.11620278337689 | | query: SELECT recentchanges.*,wl_user FROM recentchanges LEFT OUTER JO | 174.86040420632 | 2 | 87.43020210316 | 0.11360876774389 | | query: SELECT N FROM watchlist WHERE wl_user=N AND wl_namespace=N AND | 163.643528794865 | 70 | 2.3377646970695 | 0.10632103785893 | | Setup.php-extensions | 143.022183219374 | 455 | 0.31433446861401 | 0.092923118125832 | | query: SELECT bl_to FROM brokenlinks WHERE bl_from='X' | 137.757249535131 | 11 | 12.523386321376 | 0.089502431602573 | | query: SELECT oi_size AS img_size, oi_description AS img_description,o | 121.47079989691 | 7 | 17.352971413844 | 0.078920942427138 | | query: INSERT IGNORE INTO imagelinks (il_from,il_to) VALUES (N,'X') | 118.8970112801 | 2 | 59.44850564005 | 0.077248723067265 | | query: SELECT iw_url,iw_local FROM interwiki WHERE iw_prefix='X' | 104.905276907297 | 24 | 4.3710532044707 | 0.068158136162191 | | query: SELECT cur_text,cur_timestamp,cur_user,cur_counter,cur_restrict | 100.247293274325 | 33 | 3.0377967658886 | 0.065131791901378 | | query: SELECT img_size,img_description,img_user,img_user_text,img_time | 96.24301478659 | 7 | 13.74900211237 | 0.062530167212474 | | query: DELETE FROM imagelinks WHERE il_from='X' | 95.876690846405 | 5 | 19.175338169281 | 0.062292162435872 | | query: REPLACE INTO linkscc(lcc_pageid,lcc_cacheobj) VALUES(N, 'X') | 80.393500984796 | 11 | 7.3085000895269 | 0.052232560155378 | | query: SELECT old_namespace,old_title,old_timestamp,old_text,old_flags | 79.1337708947 | 3 | 26.377923631567 | 0.051414099373045 | | query: UPDATE cur SET cur_text='X' | 68.61972520908 | 5 | 13.723945041816 | 0.044583005851513 | | query: INSERT INTO old (old_namespace,old_title,old_text,old_comment,o | 67.84891794292 | 5 | 13.569783588584 | 0.044082203716953 | | query: SELECT cur_id,cur_namespace,cur_title,cur_is_redirect FROM brok | 64.54137659376 | 2 | 32.27068829688 | 0.041933256969142 | | Parser::doHeadings | 63.9078298071483 | 187 | 0.34175310057299 | 0.041521634509148 | | query: UPDATE recentchanges SET rc_this_oldid=N WHERE rc_namespace=N A | 63.03405473801 | 5 | 12.606810947602 | 0.040953933036989 | | query: SELECT cur_namespace,cur_title FROM imagelinks,cur WHERE il_to= | 62.862029526527 | 7 | 8.980289932361 | 0.040842166325788 | | Skin::initPage | 55.7963294084674 | 391 | 0.14270160974033 | 0.036251501633549 | | query: REPLACE INTO watchlist (wl_user, wl_namespace,wl_title) VALUES | 48.813994581905 | 4 | 12.203498645476 | 0.031715000307125 | | query: SELECT bl_from FROM brokenlinks WHERE bl_to='X' | 39.733407002396 | 5 | 7.9466814004792 | 0.025815240610348 | | Parser::replaceInternalLinks-setup | 38.0229311902217 | 374 | 0.10166559141771 | 0.024703925271928 | | query: SELECT COUNT(*) AS n FROM watchlist WHERE wl_user=N | 32.710440668191 | 5 | 6.5420881336382 | 0.021252340537245 | | query: INSERT INTO recentchanges (rc_timestamp,rc_cur_time,rc_namespac | 29.883143406766 | 5 | 5.9766286813532 | 0.019415413764862 | | Parser::replaceInternalLinks-prefixhandling | 27.6968458105026 | 6322 | 0.0043810259111836 | 0.017994951671341 | | query: SELECT MAX(rc_timestamp) AS lastmod FROM recentchanges | 21.964849670864 | 3 | 7.3216165569547 | 0.014270809427172 | | query: SELECT cur_namespace,cur_title FROM cur WHERE cur_id=N LIMIT N | 21.648018729497 | 6 | 3.6080031215828 | 0.014064960807554 | | query: DELETE FROM linkscc WHERE lcc_pageid='X' | 15.357014637906 | 5 | 3.0714029275812 | 0.0099776248211051 | | query: SELECT recentchanges.*,wl_user FROM recentchanges LEFT OUTER JO | 11.9856748648 | 1 | 11.9856748648 | 0.0077872275210015 | | Setup.php-BlockCache | 9.76622466225148 | 455 | 0.021464230026926 | 0.0063452258069773 | | query: SELECT COUNT(*) AS n FROM archive WHERE ar_namespace=N AND ar_t | 7.914674873347 | 2 | 3.9573374366735 | 0.0051422531220594 | | query: SELECT cur_text FROM cur WHERE cur_namespace=N AND cur_title='X | 6.90800114483 | 3 | 2.3026670482767 | 0.0044882058988697 | | query: SELECT user_name,user_password,user_newpassword,user_email,user | 4.447539638567 | 7 | 0.63536280550957 | 0.0028896164350251 | | query: SELECT N FROM user_newtalk WHERE user_id=N | 1.9088586082958 | 7 | 0.2726940868994 | 0.0012402068682738 | | query: SELECT cur_text, cur_user_text, cur_comment FROM cur WHERE cur_ | 1.75287528009 | 3 | 0.58429176003 | 0.0011388627487375 | | query: DELETE FROM user_newtalk WHERE user_id=N | 1.487668211647 | 4 | 0.37191705291175 | 0.00096655473893083 | | query: SELECT old_namespace,old_title,old_text,old_timestamp,old_user, | 1.364807465208 | 2 | 0.682403732604 | 0.00088673073263058 | | Skin::doAfterContent-2 | 0.5646232128324 | 14 | 0.040330229488029 | 0.00036684204031578 | | Skin::doAfterContent-1 | 0.05416903497609 | 14 | 0.0038692167840064 | 3.5194230171447e-05 | +------------------------------------------------------------------------+------------------+--------+--------------------+---------------------+