Jump to content

Profiling/20050328

From Meta, a Wikimedia project coordination wiki

An hour or two finishing at around 10:00 UTC

+------------------------------------------------------------------------+--------------------+--------+--------------------+---------------------+
| name                                                                   | total              | count  | each               | percent             |
+------------------------------------------------------------------------+--------------------+--------+--------------------+---------------------+
| -total                                                                 |        1118524.625 |   1758 |    636.24836461889 |                 100 |
| main-action                                                            |        957830.1875 |   1758 |     544.8408347554 |     85.633357200339 |
| Article::view                                                          |        591531.3125 |    960 |    616.17845052083 |     52.884961070929 |
| Parser::parse                                                          |        587587.3125 |    787 |     746.6166613723 |     52.532353724443 |
| Parser::internalParse                                                  |        376667.6875 |    787 |    478.61205527319 |     33.675404106548 |
| Parser::replaceInternalLinks                                           |        345489.3125 |   1239 |    278.84528853914 |     30.887948711903 |
| Parser::replaceInternalLinks-image                                     |        302845.5625 |    452 |    670.01230641593 |     27.075448830642 |
| LinkCache::addLinkObj                                                  |      142981.171875 |   7847 |    18.221125509749 |     12.783015114665 |
| Setup.php                                                              |     100717.2734375 |   1758 |    57.290826756257 |     9.0044752870327 |
| Title::userCanEdit                                                     |      89133.1796875 |   2038 |    43.735613193081 |     7.9688169303827 |
| main-cleanup                                                           |      86793.1171875 |   1758 |    49.370373826792 |     7.7596071867886 |
| OutputPage::output                                                     |      78878.3515625 |   1558 |    50.627953506098 |     7.0519995536531 |
| Output-skin                                                            |      78558.6015625 |   1136 |    69.153698558539 |     7.0234127891909 |
| SkinTemplate::outputPage                                               |      76864.0703125 |   1118 |    68.751404572898 |     6.8719157892925 |
| LoadBalancer::getConnection                                            |      68142.6015625 |  24507 |    2.7805362370955 |     6.0921860850851 |
| query: SELECT cur_id FROM `cur` WHERE cur_namespace='X' LIMIT N        |        65552.78125 |   7847 |    8.3538653306996 |     5.8606471225432 |
| Parser::tidy                                                           |       55854.046875 |    787 |    70.970834656925 |     4.9935464652823 |
| -overhead-total                                                        |     51026.00390625 | 846664 |  0.060267123565251 |     4.5619025961319 |
| query: SELECT cur_namespace,cur_title,cur_comment, cur_id, cur_user,cu |      48208.0390625 |      7 |    6886.8627232143 |     4.3099667173175 |
| Parser::replaceLinkHolders                                             |     45284.44921875 |    787 |    57.540596211881 |     4.0485875953558 |
| Parser::replaceLinkHolders-check                                       |       38656.859375 |    683 |    56.598622803807 |     3.4560579634087 |
| wfMsgReal                                                              |        36271.40625 | 155516 |   0.23323263361969 |     3.2427901397343 |
| Article::getContent                                                    |     36020.76171875 |    589 |    61.155792391766 |     3.2203816450398 |
| LoadBalancer::openConnection                                           |     35636.69140625 |  26166 |    1.3619464727605 |      3.186044420457 |
| Setup.php-DateFormatter                                                |    31990.779296875 |   1758 |    18.197257848052 |      2.860087170354 |
| LoadBalancer::getReaderIndex                                           |     31855.61328125 |  11336 |    2.8101282005337 |     2.8480028574471 |
| query: SELECT COUNT(user_id) AS total FROM `user`                      |    30957.330078125 |      1 |    30957.330078125 |      2.767693208196 |
| CategoryPage::doCategoryMagic                                          |       30915.234375 |     36 |    858.75651041667 |     2.7639297056156 |
| query: SELECT cur_title,cur_namespace,cl_sortkey FROM `cur`,`categoryl |     29870.55078125 |     36 |    829.73752170139 |     2.6705313511761 |
| query: SELECT cur_touched,cur_is_redirect FROM `cur` WHERE cur_id='X'  |    28954.392578125 |   1417 |    20.433586858239 |     2.5886236146231 |
| query: SELECT cur_id, cur_namespace, cur_title FROM `cur` WHERE (cur_n |       28477.296875 |    671 |     42.44008476155 |     2.5459695958862 |
| Parser::replaceVariables                                               |     26885.03515625 |   4630 |    5.8067030575054 |     2.4036158485335 |
| Title::newFromText                                                     |     25939.31640625 |  74142 |   0.34985994991031 |     2.3190652960591 |
| Parser::braceSubstitution                                              |      22274.2109375 |   3759 |    5.9255682196063 |     1.9913920927311 |
| Database::masterPosWait                                                |    22248.587890625 |    268 |    83.017118994869 |     1.9891013030334 |
| SkinTemplate::buildContentActionUrls                                   |    21731.712890625 |   1118 |    19.438025841346 |     1.9428908765084 |
| Skin::makeLinkObj                                                      |    20921.748046875 |  36675 |   0.57046347776074 |     1.8704771964117 |
| Skin::makeLinkObj-immediate                                            |      18540.8203125 |   3905 |    4.7479693501921 |     1.6576139584321 |
| MessageCache::load                                                     |     18304.66796875 |   1758 |     10.41221158632 |     1.6365011158114 |
| MessageCache::load-fromcache                                           |       18295.609375 |   1758 |    10.407058802617 |     1.6356912459571 |
| -overhead-internal                                                     |    18190.220703125 | 874420 |  0.020802612821213 |      1.626269131368 |
| query: SELECT cur_namespace,cur_title,cur_id FROM `cur`,`links` WHERE  |      17963.5390625 |     48 |    374.24039713542 |     1.6060030026161 |
| query: SELECT cur_text,cur_timestamp,cur_user,cur_user_text,cur_commen |     17096.76953125 |   1268 |    13.483256728115 |     1.5285107854688 |
| Setup.php-includes                                                     |    16640.775390625 |   1758 |    9.4657425430176 |     1.4877433199671 |
| Title::secureAndSplit                                                  |    16386.439453125 |  54015 |   0.30336831348931 |     1.4650048006878 |
| PageHistory::history                                                   |   15180.1162109375 |     12 |    1265.0096842448 |     1.3571552982964 |
| SkinTemplate::outputPage-stuff                                         |   13568.8564453125 |   1118 |    12.136723117453 |      1.213103059337 |
| query: SELECT old_id,old_user,old_comment,old_user_text,old_timestamp, |   13329.4111328125 |     12 |    1110.7842610677 |     1.1916958138327 |
| query: SELECT DISTINCT 'X' as type, N as namespace, cl_to as title, N  |     13314.24609375 |      4 |    3328.5615234375 |      1.190340006484 |
| Setup.php-User                                                         |   12625.3740234375 |   1758 |    7.1816689553114 |     1.1287524423915 |
| SkinTemplate::outputPage-stuff2                                        |   12073.7509765625 |   1118 |    10.799419478142 |     1.0794354193644 |
| SquidUpdate::fastPurge                                                 |          11539.125 |      9 |           1282.125 |     1.0316379936651 |
| SkinTemplate::buildContentActionUrls-talk                              |    10595.904296875 |    985 |    10.757263245558 |    0.94731077528803 |
| Parser::replaceInternalLinks-category                                  |   10555.7294921875 |   1021 |    10.338618503612 |    0.94371900772301 |
| query: UPDATE `profiling` SET pf_count=pf_count+N, pf_time=pf_time + N |   10276.3759765625 |   9620 |     1.068230350994 |    0.91874382976258 |
| SkinTemplate::outputPage-stuff3                                        |          9045.5625 |   1118 |    8.0908430232558 |    0.80870481505939 |
| Skin::makeKnownLinkObj                                                 |    8561.5771484375 |  65248 |   0.13121593226517 |    0.76543483773882 |
| LinkCache::preFill                                                     |   7893.07177734375 |     36 |     219.2519938151 |     0.7056681275429 |
| Title::getInterwikiLink                                                |   7856.40576171875 |   8921 |   0.88066424859531 |    0.70239005794966 |
| query: SELECT cur_restrictions FROM `cur` WHERE cur_id=N LIMIT N       |    7745.6298828125 |    504 |    15.368313259549 |    0.69248630827529 |
| main-misc-setup                                                        |   7639.30029296875 |   1758 |    4.3454495409379 |    0.68298007234027 |
| SkinTemplate::buildContentActionUrls-edit                              |     7391.044921875 |    985 |    7.5035989054569 |    0.66078517689094 |
| ParserCache::get                                                       |   7195.72412109375 |    878 |    8.1955855593323 |    0.64332281652661 |
| SkinTemplate::outputPage-stuff4                                        |    7146.5732421875 |   1118 |     6.392283758665 |    0.63892855664108 |
| query: SELECT N FROM `user_newtalk` WHERE user_ip='X'                  |    7036.7412109375 |   1010 |    6.9670705058787 |    0.62910919023687 |
| Setup.php-language1                                                    |     7019.697265625 |   1758 |    3.9930018575796 |    0.62758540212067 |
| query: SELECT cur_id,cur_namespace,cur_title FROM `cur`,`links` WHERE  |   7014.61767578125 |     36 |    194.85049099392 |    0.62713126908415 |
| SkinTemplate::buildNavigationUrls                                      |       6710.6484375 |   1118 |    6.0023689065295 |    0.59995535972219 |
| query: SELECT cur_title FROM `cur` WHERE cur_namespace=N AND cur_title |   6146.29150390625 |     32 |    192.07160949707 |    0.54949988283953 |
| Parser::replaceLinkHolders-construct                                   |   6037.37744140625 |    683 |    8.8394984500824 |    0.53976258604108 |
| DifferenceEngine::showDiffPage                                         |    5809.3837890625 |     13 |    446.87567608173 |    0.51937915886854 |
| query: BEGIN                                                           |    5456.3212890625 |   4327 |    1.2609940580223 |    0.48781414079842 |
| query: SELECT cur_namespace,cur_title FROM `imagelinks`,`cur` WHERE il |   5435.89013671875 |     52 |    104.53634878305 |     0.4859875245678 |
| query: SELECT cur_user,cur_user_text,cur_timestamp,cur_comment,cur_min |   5341.55126953125 |    468 |    11.413571088742 |    0.47755330103092 |
| Parser::doBlockLevels                                                  |    5222.6357421875 |    787 |    6.6361318198062 |    0.46692183841616 |
| query: COMMIT                                                          |       5147.6640625 |   2684 |    1.9179076238823 |    0.46021910894452 |
| Setup.php-extensions                                                   |    4991.1884765625 |   1758 |    2.8391288262585 |      0.446229646179 |
| query: SELECT COUNT(cur_namespace) AS total FROM `cur`                 |   4835.24951171875 |      1 |    4835.2495117188 |    0.43228815920962 |
| query: SELECT cur_id, cur_namespace, cur_title, LENGTH(cur_text) AS cu |   4639.40185546875 |      7 |    662.77169363839 |    0.41477869613007 |
| ParserOptions::initialiseFromUser                                      |   4267.68310546875 |   7086 |   0.60226970159028 |    0.38154574428513 |
| SpecialSearch::showResults                                             |   3933.82470703125 |     71 |    55.405981789173 |    0.35169763982901 |
| SkinTemplate::buildNavigationUrls-sitesupport                          |   3248.25317382812 |   1118 |    2.9054142878606 |    0.29040515525781 |
| do_html_entity_decode                                                  |   3138.02270507812 |  53844 |  0.058279895718708 |    0.28055016715239 |
| SkinTemplate::buildNavigationUrls-sitesupport2                         |   3114.32934570312 |   1118 |    2.7856255328293 |    0.27843189824302 |
| Setup.php-MessageCache                                                 |   2874.83081054688 |   1758 |    1.6352848751689 |    0.25701989444773 |
| query: SELECT LENGTH(cur_text) AS x,cur_namespace,cur_is_redirect FROM |     2755.830078125 |    260 |    10.599346454327 |    0.24638081420201 |
| SkinTemplate::buildNavUrls                                             |   2699.92358398438 |   1118 |    2.4149584829914 |    0.24138257876838 |
| MessageCache::initialise                                               |     2669.419921875 |   1758 |    1.5184413662543 |    0.23865544505781 |
| ParserOptions::initialiseFromUser-skin                                 |   2629.18823242188 |   7086 |   0.37103982958254 |    0.23505859179648 |
| SkinTemplate::outputPage-execute                                       |   2553.31567382812 |   1118 |    2.2838243951951 |    0.22827532061068 |
| query: SELECT cur_id,cur_title FROM `cur` USE INDEX (cur_random) WHERE |   2552.30883789062 |     24 |    106.34620157878 |    0.22818530596862 |
| Parser::doBlockLevels-paragraph                                        |   2519.77099609375 |  52420 |  0.048068885846886 |    0.22527630950403 |
| User::getSkin                                                          |   2486.34521484375 |   5293 |   0.46974215281386 |    0.22228792815748 |
| MessageCache::initialise-parseropt                                     |    2421.9970703125 |   1758 |     1.377700267527 |    0.21653497975626 |
| Parser::replaceExternalLinks                                           |   2359.18701171875 |   1239 |     1.904105739886 |    0.21091954159872 |
| parser::variableSubstitution                                           |     2314.068359375 |   6592 |   0.35104192344888 |    0.20688577682186 |
| Setup.php-SetupSession                                                 |   2290.85278320312 |   1758 |    1.3031016969301 |    0.20481022339612 |
| Skin::formatComment                                                    |     2191.548828125 |   1195 |    1.8339320737448 |    0.19593210369642 |
| Parser::initialiseVariables                                            |   2141.63256835938 |   2596 |   0.82497402479175 |    0.19146941609438 |
| query: UPDATE `cur` SET cur_text='X'                                   |   2092.43627929688 |     14 |    149.45973423549 |     0.1870710963826 |
| Setup.php-misc2                                                        |   2080.78930664062 |   1758 |    1.1836116647558 |    0.18602981643257 |
| query: SELECT cur_id,cur_namespace,cur_title,cur_is_redirect FROM `lin |   2076.40673828125 |      7 |    296.62953404018 |    0.18563799954617 |
| query: SELECT N FROM `watchlist` WHERE wl_user='X'                     |   1982.33435058594 |    140 |    14.159531075614 |    0.17722760020468 |
| main-updates                                                           |   1790.37084960938 |   1758 |    1.0184134525651 |    0.16006539414449 |
| LinksUpdate::doUpdate                                                  |   1771.57934570312 |     18 |    98.421074761285 |    0.15838536819903 |
| SkinTemplate-translate                                                 |   1695.52307128906 |  14852 |   0.11416126254303 |    0.15158567217857 |
| query: SELECT COUNT(ur_user) AS total FROM `user_rights` WHERE ur_righ |   1671.91833496094 |      1 |    1671.9183349609 |    0.14947532647848 |
| Skin::outputPage                                                       |   1560.30676269531 |     18 |    86.683709038628 |    0.13949686290504 |
| Skin::makeLinkObj-postparse                                            |    1544.6923828125 |  32246 |  0.047903379731207 |    0.13810088292088 |
| Skin::recentChangesLineOld                                             |   1480.23913574219 |    388 |    3.8150493189232 |    0.13233853798634 |
| Parser::replaceFreeExternalLinks                                       |   1451.67358398438 |   3812 |   0.38081678488572 |    0.12978467809632 |
| Parser::doTableStuff                                                   |   1415.62683105469 |    787 |    1.7987634447963 |    0.12656197274644 |
| Parser::removeHTMLtags                                                 |   1373.87170410156 |   2224 |   0.61774806839099 |    0.12282891886279 |
| Setup.php-OutputPage                                                   |   1326.66223144531 |   1758 |   0.75464290753431 |    0.11860822746261 |
| query: SELECT old_namespace,old_title,old_timestamp,old_comment,old_mi |   1299.85168457031 |      2 |    649.92584228516 |    0.11621127112604 |
| Parser::doAllQuotes                                                    |   1282.05285644531 |    787 |    1.6290379370334 |    0.11461999385533 |
| query: INSERT INTO `old` (old_id,old_namespace,old_title,old_text,old_ |   1180.30297851562 |     14 |    84.307355608259 |    0.10552320012763 |
| SkinTemplate::buildPersonalUrls                                        |       1115.6171875 |   1118 |   0.99786868291592 |   0.099740064953867 |
| query: SELECT img_size,img_description,img_user,img_user_text,img_time |   1110.72863769531 |     52 |    21.360166109525 |   0.099303011562692 |
| Skin::recentChangesLineOld-rest                                        |   1095.62878417969 |    388 |    2.8237855262363 |   0.097953032029106 |
| Setup.php-language2                                                    |   1028.29064941406 |   1758 |    0.5849207334551 |   0.091932768079564 |
| query: SELECT user_name,user_password,user_newpassword,user_email,user |   1017.37231445312 |     29 |    35.081803946659 |   0.090956630879103 |
| query: SELECT oi_size AS img_size,oi_description AS img_description,oi |   930.304809570312 |     42 |    22.150114513579 |   0.083172492475998 |
| query: SELECT math_outputhash,math_html_conservativeness,math_html,mat |   827.358337402344 |     51 |    16.222712498085 |   0.073968719052774 |
| query: SELECT N FROM `user_newtalk` WHERE user_id='X'                  |   825.736755371094 |    123 |    6.7133069542365 |    0.07382374396729 |
| query: SELECT bl_to FROM `brokenlinks` WHERE bl_from='X'               |   809.613647460938 |     36 |    22.489267985026 |   0.072382281924364 |
| query: SELECT cur_text FROM `cur` WHERE cur_namespace='X' LIMIT N      |   795.014282226562 |     51 |    15.588515337776 |   0.071077047787532 |
| Skin::makeLink                                                         |   757.171264648438 |    245 |    3.0904949577487 |   0.067693750117342 |
| query: SELECT old_text AS text,old_timestamp AS timestamp,old_user AS  |   747.087829589844 |      7 |    106.72683279855 |   0.066792255878125 |
| Setup.php-misc1                                                        |   735.751281738281 |   1758 |   0.41851608745067 |   0.065778728987597 |
| query: UPDATE `recentchanges` SET rc_this_oldid='X'                    |    698.77685546875 |     12 |    58.231404622396 |   0.062473086407798 |
| SkinTemplate::setupUserCss                                             |   665.480163574219 |   1118 |   0.59524164899304 |   0.059496246099563 |
| pages2xml                                                              |   646.807312011719 |     21 |    30.800348191034 |   0.057826828087197 |
| page2xml                                                               |      643.126953125 |     30 |    21.437565104167 |   0.057497791175138 |
| SkinStandard::doAfterContent                                           |   643.126342773438 |     12 |    53.593861897786 |   0.057497736607581 |
| query: SELECT COUNT(*) AS n FROM `watchlist` WHERE wl_user=N           |   632.726989746094 |      7 |    90.389569963728 |   0.056567998200853 |
| Setup.php-memcached                                                    |   622.027709960938 |   1758 |   0.35382691124058 |   0.055611445296606 |
| query: DELETE FROM `categorylinks` WHERE cl_from='X'                   |   617.170104980469 |     18 |     34.28722805447 |   0.055177158480572 |
| SkinTemplate::buildNavigationUrls-portal                               |   593.292297363281 |   1118 |   0.53067289567378 |   0.053042399255473 |
| query: SELECT cur_id as id,cur_timestamp as timestamp,cur_user as user |   553.910400390625 |     30 |    18.463680013021 |   0.049521520403775 |
| SkinTemplate::buildNavigationUrls-randompage                           |   537.346252441406 |   1118 |    0.4806317105916 |   0.048040627844148 |
| User::loadDefaults2                                                    |   536.536926269531 |   1758 |   0.30519734145025 |   0.047968271263543 |
| query: SELECT old_namespace,old_title,old_timestamp,old_comment,old_mi |     514.6513671875 |      1 |     514.6513671875 |   0.046011626001305 |
| SkinTemplate::buildNavigationUrls-portal2                              |   509.671722412109 |   1118 |   0.45587810591423 |   0.045566428402245 |
| query: REPLACE INTO `updates` (up_page,up_action,up_timestamp,up_seque |   495.474090576172 |     18 |    27.526338365343 |   0.044297110631442 |
| Parser::replaceLinkHolders-replace                                     |   492.676635742188 |    683 |   0.72134207282897 |   0.044047008418987 |
| query: SHOW MASTER STATUS                                              |   475.105773925781 |    288 |    1.6496728261312 |   0.042476112130815 |
| SkinTemplate::buildNavigationUrls-help                                 |   473.850738525391 |   1118 |    0.4238378698796 |   0.042363907591698 |
| SkinStandard::doAfterContent-3                                         |   452.065460205078 |     12 |    37.672121683757 |   0.040416227779078 |
| Parser::doHeadings                                                     |   442.860290527344 |    787 |   0.56271955594326 |   0.039593253526032 |
| query: SELECT cur_user,cur_user_text,cur_timestamp,cur_comment,cur_min |   436.890960693359 |     16 |    27.305685043335 |   0.039059574633268 |
| SkinTemplate::buildNavigationUrls-randompage2                          |   435.605377197266 |   1118 |   0.38962913881687 |   0.038944638987923 |
| SkinTemplate::buildNavigationUrls-recentchanges                        |   427.069488525391 |   1118 |     0.381994175783 |   0.038181500789524 |
| query: SELECT user_id FROM `user` WHERE user_name='X' LIMIT N          |     408.2470703125 |     18 |    22.680392795139 |    0.03649871099731 |
| SkinTemplate::buildNavigationUrls-currentevents                        |   391.778717041016 |   1118 |   0.35042819055547 |   0.035026382815757 |
| SkinTemplate::buildNavigationUrls-help2                                |   362.057708740234 |   1118 |   0.32384410441881 |   0.032369221083553 |
| SkinTemplate::buildNavigationUrls-recentchanges2                       |   348.527130126953 |   1118 |   0.31174161907599 |   0.031159540195814 |
| SkinTemplate::buildContentActionUrls-live                              |   343.424011230469 |    985 |   0.34865381850809 |    0.03070330357997 |
| Skin::makeBrokenLinkObj                                                |   342.734954833984 |   2841 |   0.12063884365857 |   0.030641699536475 |
| query: SELECT bl_from FROM `brokenlinks` WHERE bl_to='X' FOR UPDATE    |   337.679565429688 |     18 |    18.759975857205 |    0.03018973010359 |
| User::loadDefaults1                                                    |   337.161926269531 |   1758 |   0.19178721630804 |   0.030143451358483 |
| query: SELECT old_id,old_namespace,old_title,old_timestamp,old_text,ol |   330.746856689453 |      8 |    41.343357086182 |    0.02956992177883 |
| User::loadDefaults3                                                    |   321.692687988281 |   1585 |   0.20296068642794 |    0.02876044753939 |
| SkinTemplate::buildNavigationUrls-currentevents2                       |   292.899597167969 |   1118 |     0.261985328415 |   0.026186244864119 |
| query: UPDATE `cur` SET cur_touched='X'                                |   281.479766845703 |     42 |     6.701899210612 |   0.025165272230435 |
| Parser::magicISBN                                                      |   274.569976806641 |    787 |   0.34888180026257 |   0.024547512917442 |
| DiffFormatter::format                                                  |   266.893829345703 |     13 |    20.530294565054 |   0.023861238579857 |
| DiffFormatter::_block                                                  |   265.081878662109 |     13 |    20.390913743239 |    0.02369924387334 |
| TableDiffFormatter::_changed                                           |    259.72314453125 |     13 |    19.978703425481 |   0.023220154364617 |
| query: SHOW SLAVE STATUS                                               |   258.826232910156 |     96 |    2.6961065928141 |    0.02313996733958 |
| Setup.php-database                                                     |   258.748443603516 |   1758 |   0.14718341501906 |   0.023133012704438 |
| query: SELECT cur_text,cur_timestamp,cur_user,cur_user_text,cur_commen |   252.270370483398 |     16 |    15.766898155212 |   0.022553850388712 |
| query: DELETE FROM `imagelinks` WHERE il_from='X'                      |   251.769744873047 |     18 |    13.987208048503 |   0.022509092714257 |
| Skin::doBeforeContent                                                  |   251.572952270508 |     12 |    20.964412689209 |   0.022491498769686 |
| query: SELECT old_id FROM `old` WHERE old_title='X' AND old_namespace= |   250.191955566406 |      1 |    250.19195556641 |   0.022368032850989 |
| Parser::replaceInternalLinks-setup                                     |   236.761657714844 |   1239 |   0.19109092632352 |   0.021167317412868 |
| SkinTemplate::buildNavigationUrls-mainpage                             |   230.081085205078 |   1118 |   0.20579703506715 |   0.020570050945913 |
| query: SELECT old_namespace,old_title,old_timestamp,old_text,old_flags |   227.928665161133 |      8 |    28.491083145142 |   0.020377617091902 |
| _DiffEngine::diff                                                      |   227.805084228516 |     26 |    8.7617340087891 |   0.020366568525795 |
| query: SELECT cur_namespace,cur_title,cur_timestamp,cur_comment,cur_mi |   221.180480957031 |      2 |    110.59024047852 |   0.019774305903818 |
| ucListEdit                                                             |   216.032638549805 |    134 |    1.6121838697747 |   0.019314070850233 |
| query: UPDATE `recentchanges` SET rc_cur_time='X'                      |    196.02912902832 |     14 |     14.00208064488 |   0.017525687378436 |
| WordLevelDiff::WordLevelDiff                                           |   194.298965454102 |     13 |      14.9460742657 |   0.017371004724559 |
| SkinStandard::doAfterContent-4                                         |   190.604293823242 |     12 |    15.883691151937 |   0.017040688203288 |
| Skin::quickBar                                                         |   186.352172851562 |     10 |    18.635217285156 |   0.016660533768004 |
| MappedDiff::MappedDiff                                                 |   184.372177124023 |     13 |    14.182475163386 |   0.016483515248851 |
| query: INSERT IGNORE INTO `links` (l_from,l_to) VALUES ('X')           |   177.336944580078 |      8 |     22.16711807251 |   0.015854540938701 |
| query: SELECT old_namespace,old_title,old_timestamp,old_comment,old_mi |   170.859649658203 |      2 |    85.429824829102 |    0.01527544819661 |
| wfSpamBlacklistFilter                                                  |   167.924667358398 |     19 |    8.8381403872841 |    0.01501305054937 |
| Skin::recentChangesLineOld-page                                        |   150.346176147461 |    388 |   0.38749014470995 |   0.013441472166736 |
| query: SELECT iw_url,iw_local FROM `interwiki` WHERE iw_prefix='X'     |   148.189376831055 |     10 |    14.818937683105 |   0.013248646790504 |
| SkinTemplate::buildNavigationUrls-mainpage2                            |   135.698196411133 |   1118 |   0.12137584652159 |   0.012131891723987 |
| query: SELECT cur_namespace,cur_title,cur_id FROM `brokenlinks`,`cur`  |   133.949340820312 |      2 |    66.974670410156 |   0.011975537938676 |
| query: SELECT * FROM `ipblocks` WHERE (ipb_address='X' OR ipb_user=N)  |   129.368804931641 |     34 |    3.8049648509306 |    0.01156602206515 |
| _DiffEngine::_shift_boundaries                                         |   129.063552856445 |     52 |    2.4819914010855 |   0.011538731465697 |
| query: SELECT old_namespace,old_title,old_text,old_timestamp,old_user, |   126.517822265625 |      6 |    21.086303710938 |   0.011311134277944 |
| MessageCache::initialise-parser                                        |   113.282997131348 |   1758 |  0.064438564921131 |   0.010127894782053 |
| query: SELECT `recentchanges`.* FROM `recentchanges` WHERE rc_timestam |   109.307807922363 |      3 |    36.435935974121 |  0.0097724990115764 |
| wfGetSiteNotice                                                        |   107.207397460938 |   1136 |  0.094372709032515 |  0.0095847149955181 |
| query: SELECT cur_namespace,cur_title FROM `cur` WHERE cur_id='X' LIMI |   104.895011901855 |     10 |    10.489501190186 |  0.0093779796669077 |
| query: UPDATE `user` SET user_name='X'                                 |   98.2138214111328 |      2 |    49.106910705566 |  0.0087806579503006 |
| SkinTemplate::outputPage-init                                          |   94.1698684692383 |   1118 |  0.084230651582503 |   0.008419114462432 |
| query: SELECT COUNT(*) FROM `archive` WHERE ar_namespace='X' LIMIT N   |   93.6968536376953 |      4 |    23.424213409424 |   0.008376825287838 |
| query: SELECT old_id FROM `old` WHERE old_title='X' AND old_namespace= |   82.3466949462891 |      2 |    41.173347473145 |  0.0073620815407876 |
| query: SELECT MAX(rc_timestamp) FROM `recentchanges` LIMIT N           |   80.2130126953125 |      4 |    20.053253173828 |  0.0071713229107774 |
| query: SELECT user_id FROM `user_newtalk` WHERE user_id='X' LIMIT N    |   68.2660217285156 |      5 |    13.653204345703 |  0.0061032202780976 |
| query: SELECT cur_namespace,cur_title,cur_timestamp,cur_comment,cur_mi |   59.1843872070312 |      1 |    59.184387207031 |  0.0052912904985915 |
| Parser::replaceLinkHolders-interwiki                                   |   57.8202285766602 |    104 |   0.55596373631404 |  0.0051693299623743 |
| query: SELECT cur_text,cur_user_text,cur_comment FROM `cur` WHERE cur_ |   56.6396293640137 |     10 |    5.6639629364014 |  0.0050637802778829 |
| query: UPDATE `cur` SET cur_touched='X' WHERE cur_id IN (N,N,N,N,N,N,N |   49.1893272399902 |      2 |    24.594663619995 |  0.0043976973005838 |
| SkinTemplate::setupUserJs                                              |   47.6853485107422 |   1118 |  0.042652368972041 |  0.0042632363601957 |
| Skin::initPage                                                         |   45.2160606384277 |   1165 |  0.038812069217535 |  0.0040424734179123 |
| query: DELETE FROM `brokenlinks` WHERE bl_from=N AND bl_to IN('X')     |   44.2299461364746 |      2 |    22.114973068237 |  0.0039543113444172 |
| Article::getRevisionText                                               |   42.6214981079102 |     53 |   0.80417920958321 |   0.003810510484551 |
| query: INSERT INTO `recentchanges` (rc_timestamp,rc_cur_time,rc_namesp |   42.4780769348145 |     16 |    2.6548798084259 |  0.0037976881317937 |
| query: SELECT cur_namespace,cur_title,cur_id FROM `cur`,`links` WHERE  |   36.3752822875977 |      2 |    18.187641143799 |  0.0032520770195469 |
| WordLevelDiff::orig                                                    |   32.7622261047363 |     13 |    2.5201712388259 |  0.0029290572037908 |
| WordLevelDiff::closing                                                 |   30.8331851959229 |     13 |    2.3717834766095 |  0.0027565942230304 |
| _DiffEngine::_compareseq                                               |   28.0013217926025 |    109 |   0.25689286048259 |  0.0025034157645481 |
| Parser::removeHTMLcomments                                             |   27.1430587768555 |   2224 |  0.012204612759377 |  0.0024266840595356 |
| Setup.php-BlockCache                                                   |   26.8380069732666 |   1758 |  0.015266215570686 |   0.002399411365062 |
| Parser::maybeDoSubpageLink                                             |   24.4527530670166 |   6447 | 0.0037928886407657 |  0.0021861613522381 |
| query: SELECT old_text,old_flags FROM `old` WHERE old_namespace='X' LI |   21.8491477966309 |      4 |    5.4622869491577 |   0.001953389966415 |
| _DiffEngine::_diag                                                     |   19.4343357086182 |     22 |   0.88337889584628 |   0.001737497349119 |
| query: UPDATE LOW_PRIORITY `site_stats` SET ss_total_views=(ss_total_v |   18.0642490386963 |     18 |    1.0035693910387 |  0.0016150068255043 |
| query: DELETE FROM `watchlist` WHERE wl_user='X'                       |   15.6131362915039 |      1 |    15.613136291504 |  0.0013958688027547 |
| query: SELECT old_flags,old_text FROM `old` WHERE old_id='X' LIMIT N   |   15.3168973922729 |      3 |     5.105632464091 |  0.0013693840126473 |
| _DiffEngine::_diag-chunk                                               |   15.2107830047607 |     92 |   0.16533459787783 |  0.0013598970165508 |
| query: DELETE FROM `user_newtalk` WHERE user_id='X'                    |   13.1018362045288 |      1 |    13.101836204529 |  0.0011713498220505 |
| query: SELECT cur_id,cur_namespace,cur_title,cur_user,cur_comment,cur_ |   10.1835746765137 |      2 |    5.0917873382568 | 0.00091044707008696 |
| WordLevelDiff::_split                                                  |    9.6605978012085 |     26 |   0.37156145389263 | 0.00086369111464207 |
| query: INSERT IGNORE INTO `profiling` (pf_name,pf_count,pf_time) VALUE |    9.3870677947998 |     30 |   0.31290225982666 | 0.00083923657870293 |
| query: UPDATE `user_rights` SET ur_rights = 'X' WHERE (ur_user=N)      |     9.209885597229 |      2 |    4.6049427986145 | 0.00082339587268622 |
| query: INSERT IGNORE INTO `categorylinks` (cl_from,cl_to,cl_sortkey) V |   7.76013517379761 |     10 |   0.77601351737976 | 0.00069378313184635 |
| revision2xml                                                           |   7.54022312164307 |     19 |   0.39685384850753 | 0.00067412222789848 |
| LoadBalancer::waitFor                                                  |   7.21201705932617 |    365 |  0.019758950847469 | 0.00064477946199228 |
| xmlsafe                                                                |   6.93870401382446 |     74 |  0.093766270457087 | 0.00062034432311443 |
| query: SELECT cur_text FROM `cur` WHERE cur_id='X'                     |   6.18958044052124 |      2 |    3.0947902202606 | 0.00055337006465291 |
| query: SELECT cur_id as id,cur_timestamp as timestamp,cur_user as user |   5.53607368469238 |      7 |   0.79086766924177 | 0.00049494428293811 |
| query: UPDATE `profiling` SET pf_count=pf_count+N, pf_time=pf_time + N |   4.37093782424927 |      6 |   0.72848963737488 | 0.00039077707602989 |
| query: SELECT ss_total_views,ss_total_edits,ss_good_articles FROM `sit |   4.31744956970215 |      2 |    2.1587247848511 | 0.00038599503964449 |
| query: SELECT cur_namespace,cur_title,cur_timestamp,cur_comment,cur_mi |   4.13497924804688 |      2 |    2.0674896240234 | 0.00036968155690331 |
| User::loadDefaults4                                                    |   3.04772591590881 |     23 |   0.13250982243082 | 0.00027247731947867 |
| _DiffEngine::_lcs_pos                                                  |   2.93045711517334 |    257 |  0.011402556868379 | 0.00026199307996222 |
| query: DELETE FROM `links` WHERE l_from=N AND l_to IN(N)               |   2.81357622146606 |      2 |     1.406788110733 | 0.00025154352068611 |
| query: SELECT `recentchanges`.*,wl_user FROM `recentchanges` LEFT OUTE |    2.5905590057373 |      1 |    2.5905590057373 | 0.00023160500429191 |
| query: INSERT IGNORE INTO `imagelinks` (il_from,il_to) VALUES ('X')    |   2.25528764724731 |      6 |   0.37588127454122 | 0.00020163057628233 |
| query: INSERT INTO `cur` (cur_id,cur_namespace,cur_title,cur_text,cur_ |   1.32656300067902 |      2 |   0.66328150033951 | 0.00011859935588624 |
| SkinTemplate::getUserJs                                                |  0.893936634063721 |     13 |   0.06876435646644 | 7.9921050827443e-05 |
| SkinStandard::doAfterContent-2                                         |  0.598278403282166 |     12 |  0.049856533606847 | 5.3488174503281e-05 |
| SkinTemplate::getUserStylesheet                                        |  0.573387503623962 |     16 |  0.035836718976498 | 5.1262841318667e-05 |
| query: SELECT ss_total_views, ss_total_edits, ss_good_articles FROM `s |  0.242416113615036 |      1 |   0.24241611361504 | 2.1672845478483e-05 |
| Parser::findColonNoLinks                                               | 0.0239106472581625 |     17 | 0.0014065086622449 | 2.1376952034617e-06 |
| SkinStandard::doAfterContent-1                                         | 0.0189212672412395 |     12 | 0.0015767722701033 | 1.6916272398777e-06 |
+------------------------------------------------------------------------+--------------------+--------+--------------------+---------------------+