Profiling/User time 20050421

From Meta, a Wikimedia project coordination wiki
Jump to navigation Jump to search

User time only using getrusage(). 14:47 - 15:54 at a sample rate of 300. In response to this data, Setup.php-DateFormatter was optimised away.

+------------------------------------------------------------------------+---------------------+--------+---------------------+----------------------+
| name                                                                   | total               | count  | each                | percent              |
+------------------------------------------------------------------------+---------------------+--------+---------------------+----------------------+
| -total                                                                 |       87702.5390625 |   1115 |     78.656985706278 |                  100 |
| main-action                                                            |             52269.5 |   1115 |     46.878475336323 |      59.598616595069 |
| -overhead-total                                                        |         48580.40625 | 610878 |   0.079525545608125 |      55.392246073263 |
| Parser::parse                                                          |      37295.44921875 |    605 |     61.645370609504 |      42.524936697867 |
| Article::view                                                          |       36119.5390625 |    648 |     55.740029417438 |      41.184142954812 |
| Parser::internalParse                                                  |     24357.068359375 |    605 |     40.259617122934 |      27.772363970007 |
| Setup.php                                                              |      20482.56640625 |   1115 |     18.370014714126 |      23.354587706581 |
| -overhead-internal                                                     |      20057.86328125 | 631863 |    0.03174400666165 |      22.870333625069 |
| main-cleanup                                                           |    15727.9619140625 |   1115 |     14.105795438621 |      17.933302823598 |
| OutputPage::output                                                     |      15479.05859375 |    988 |     15.667063353998 |      17.649498816356 |
| Output-skin                                                            |    15341.0888671875 |    722 |      21.24804552242 |      17.492183272203 |
| SkinTemplate::outputPage                                               |    15118.6220703125 |    715 |     21.144925972465 |      17.238522660716 |
| Parser::replaceInternalLinks                                           |       14741.8671875 |   1073 |     13.738925617428 |      16.808940020533 |
| wfMsgReal                                                              |     12668.474609375 |  98806 |    0.12821564084544 |      14.444820805412 |
| Title::newFromText                                                     |    12522.7041015625 |  51493 |    0.24319235821495 |      14.278610671281 |
| Setup.php-DateFormatter                                                |      8873.560546875 |   1045 |     8.4914454994019 |      10.117792075041 |
| Parser::replaceVariables                                               |      7649.701171875 |   3767 |     2.0307144071874 |      8.7223257771631 |
| LuceneSearch::execute                                                  |     7583.1767578125 |    254 |     29.855026605561 |      8.6464734531898 |
| Parser::replaceLinkHolders                                             |    6481.48583984375 |    605 |     10.713199735279 |      7.3903058099889 |
| Title::secureAndSplit                                                  |     5458.2939453125 |  37754 |    0.14457524885608 |      6.2236441540452 |
| memcached::get                                                         |     4886.2177734375 |   8610 |    0.56750496787892 |      5.5713526947668 |
| Parser::braceSubstitution                                              |    4875.76904296875 |   2125 |     2.2944795496324 |      5.5594388658396 |
| LinkCache::addLinkObj                                                  |    4087.30151367188 |   5349 |    0.76412441833462 |      4.6604141195492 |
| LuceneSearch::showHit                                                  |    4018.93725585938 |   1028 |     3.9094720387737 |       4.582463972902 |
| LoadBalancer::getConnection                                            |    3865.30419921875 |  21482 |    0.17993223159942 |      4.4072888202977 |
| Setup.php-includes                                                     |    3616.76123046875 |   1115 |     3.2437320452635 |      4.1238956923372 |
| SkinTemplate::outputPage-stuff4                                        |    3558.26489257812 |    715 |      4.976594255354 |      4.0571971240677 |
| Skin::makeKnownLinkObj                                                 |      3413.642578125 |  33120 |    0.10306891842165 |      3.8922961804929 |
| MessageCache::load                                                     |    3348.68676757812 |   1107 |     3.0250106301519 |      3.8182324062382 |
| MessageCache::load-fromcache                                           |    3320.51904296875 |   1107 |     2.9995655311371 |      3.7861150640148 |
| Parser::replaceLinkHolders-construct                                   |      3138.982421875 |    407 |     7.7124875230344 |      3.5791237693108 |
| Parser::replaceLinkHolders-check                                       |    3084.05712890625 |    407 |     7.5775359432586 |      3.5164969701829 |
| DifferenceEngine::showDiffPage                                         |     3029.7919921875 |      7 |     432.82742745536 |       3.454622892991 |
| Article::getContent                                                    |     2789.8115234375 |   1336 |     2.0881822780221 |      3.1809928803194 |
| Parser::internalTidy                                                   |     2779.0224609375 |    568 |     4.8926451777069 |      3.1686909987373 |
| SkinTemplate::buildNavigationUrls                                      |    2356.60400390625 |    715 |     3.2959496558129 |      2.6870419364106 |
| Title::userCanEdit                                                     |       2323.68359375 |   1371 |     1.6948822711524 |      2.6495054973198 |
| Database::query                                                        |    2192.42993164062 |  26488 |   0.082770686032944 |      2.4998477296971 |
| Parser::doBlockLevels                                                  |    2094.49145507812 |    605 |     3.4619693472366 |      2.3881765311099 |
| SkinTemplate::outputPage-stuff3                                        |    2072.20092773438 |    715 |     2.8981831157124 |      2.3627604740812 |
| Setup.php-language1                                                    |    2054.01147460938 |   1115 |     1.8421627574972 |      2.3420205350561 |
| Skin::makeLinkObj                                                      |    2025.48461914062 |  24703 |   0.081993467155432 |      2.3094937054185 |
| Setup.php-extensions                                                   |    1980.00354003906 |   1115 |     1.7757879282862 |      2.2576353674642 |
| do_html_entity_decode                                                  |    1619.68334960938 |  37338 |   0.043378953066832 |      1.8467918567958 |
| SkinTemplate::outputPage-execute                                       |     1586.9501953125 |    715 |     2.2195107626748 |      1.8094689301772 |
| ParserOptions::initialiseFromUser                                      |    1584.02990722656 |   4496 |    0.35231981922299 |      1.8061391655921 |
| parser::variableSubstitution                                           |    1526.45471191406 |   6652 |    0.22947304749159 |      1.7404909005271 |
| SkinTemplate::outputPage-stuff                                         |    1410.80651855469 |    715 |     1.9731559700066 |      1.6086267668366 |
| SkinTemplate::buildNavUrls                                             |    1408.86633300781 |    715 |     1.9704424237872 |      1.6064145326554 |
| Parser::initialiseVariables                                            |    1361.41552734375 |   2036 |    0.66867167354801 |      1.5523102773268 |
| SkinTemplate::buildContentActionUrls                                   |    1164.07177734375 |    715 |     1.6280724158654 |      1.3272954121821 |
| SkinTemplate::outputPage-stuff2                                        |    1141.46423339844 |    714 |     1.5986894025188 |      1.3015178871674 |
| Parser::replaceExternalLinks                                           |    1121.73999023438 |   1073 |     1.0454240356332 |      1.2790279531531 |
| SkinTemplate-translate                                                 |    1072.94592285156 |   9560 |    0.11223283711836 |      1.2233920868436 |
| LoadBalancer::openConnection                                           |    1062.84741210938 |  22515 |   0.047206191965773 |      1.2118775846979 |
| Setup.php-MessageCache                                                 |     991.66259765625 |   1115 |    0.88938349565583 |      1.1307113890392 |
| MessageCache::initialise                                               |    980.877197265625 |   1115 |    0.87971049082119 |      1.1184136830595 |
| Parser::replaceInternalLinks-image                                     |    973.109680175781 |    468 |     2.0792941884098 |      1.1095570214704 |
| Parser::doBlockLevels-paragraph                                        |    943.856872558594 |  24068 |   0.039216256961883 |      1.0762024482392 |
| Title::getInterwikiLink                                                |    888.594665527344 |   7280 |    0.12205970680321 |      1.0131914936854 |
| ParserOptions::initialiseFromUser-skin                                 |    872.249633789062 |   4496 |    0.19400570146554 |     0.99455459683723 |
| MessageCache::initialise-parseropt                                     |         870.3203125 |   1115 |    0.78055633408072 |      0.9923547502767 |
| Skin::makeLinkObj-immediate                                            |    839.147644042969 |   1499 |    0.55980496600598 |     0.95681111745803 |
| User::getSkin                                                          |    821.325744628906 |   3359 |    0.24451495821045 |     0.93649026973278 |
| Setup.php-misc2                                                        |    784.113159179688 |   1115 |    0.70324050150645 |     0.89405981578355 |
| Skin::makeLinkObj-postparse                                            |    715.931274414062 |  23041 |   0.031072057393953 |      0.8163176141387 |
| Parser::replaceFreeExternalLinks                                       |    708.167175292969 |   2416 |    0.29311555268749 |     0.80746484977853 |
| Parser::removeHTMLtags                                                 |    698.567321777344 |   1860 |    0.37557382891255 |     0.79651892550057 |
| Parser::doTableStuff                                                   |    673.970581054688 |    605 |      1.114000960421 |     0.76847328282525 |
| ParserCache::get                                                       |    673.815368652344 |    572 |     1.1779988962454 |     0.76829630687449 |
| main-misc-setup                                                        |     673.25634765625 |   1115 |    0.60381735215807 |     0.76765890115959 |
| query: SELECT cur_id FROM `cur` WHERE cur_namespace='X' LIMIT N        |    599.798706054688 |   5349 |    0.11213286708818 |     0.68390118742999 |
| LuceneSearch::showHit-extract                                          |    585.971130371094 |   1028 |    0.57001082720924 |     0.66813473889679 |
| Parser::doAllQuotes                                                    |          561.984375 |    605 |    0.92889979338843 |     0.64078461240388 |
| Setup.php-OutputPage                                                   |      554.3349609375 |   1115 |    0.49716139994395 |     0.63206261399395 |
| PageHistory::history                                                   |    515.272338867188 |     10 |     51.527233886719 |     0.58752271527736 |
| Setup.php-misc1                                                        |    512.227661132812 |   1115 |    0.45939700550028 |     0.58405111939551 |
| query: UPDATE `profiling` SET pf_count=pf_count+N, pf_time=pf_time + N |    427.195343017578 |   8557 |   0.049923494567907 |      0.4870957529669 |
| SkinTemplate::buildContentActionUrls-talk                              |    396.030303955078 |    633 |    0.62564029060834 |     0.45156081932001 |
| SkinTemplate::setupUserCss                                             |    385.231903076172 |    715 |    0.53878587842821 |     0.43924828995161 |
| Parser::replaceInternalLinks-category                                  |    363.236358642578 |    581 |    0.62519166719893 |     0.41416857770072 |
| LoadBalancer::getReaderIndex                                           |    363.141876220703 |   9348 |    0.03884701286058 |     0.41406084715736 |
| SkinTemplate::buildNavigationUrls-sitesupport                          |    351.065979003906 |    714 |    0.49168904622396 |      0.4002916936689 |
| CategoryPage::doCategoryMagic                                          |    334.054382324219 |     21 |     15.907351539249 |      0.3808947675804 |
| SkinTemplate::buildNavigationUrls-portal                               |     314.26611328125 |    715 |    0.43953302556818 |     0.35833183011645 |
| SkinTemplate::buildNavigationUrls-sitesupport2                         |    310.654754638672 |    471 |    0.65956423490164 |     0.35421409455123 |
| Setup.php-User                                                         |    310.222381591797 |   1115 |    0.27822635120341 |     0.35372109508793 |
| Setup.php-language2                                                    |    302.504699707031 |   1115 |    0.27130466341438 |     0.34492125648889 |
| SkinTemplate::buildNavigationUrls-help                                 |    295.436981201172 |    715 |    0.41319857510653 |     0.33686251773239 |
| SkinTemplate::buildNavigationUrls-recentchanges                        |    282.650024414062 |    715 |    0.39531471946023 |     0.32228260143373 |
| SkinTemplate::buildNavigationUrls-randompage                           |    268.498931884766 |    715 |    0.37552298165701 |     0.30614727322025 |
| SkinTemplate::buildNavigationUrls-currentevents                        |    268.452941894531 |    715 |    0.37545865999235 |     0.30609483461274 |
| Setup.php-memcached                                                    |    262.273559570312 |   1115 |    0.23522292338145 |     0.29904899262199 |
| Parser::doHeadings                                                     |     248.03108215332 |    605 |    0.40996873083193 |     0.28280946572888 |
| SkinTemplate::buildNavigationUrls-portal2                              |    247.197937011719 |    715 |    0.34573138043597 |     0.28185949877182 |
| SkinTemplate::buildPersonalUrls                                        |    233.741195678711 |    715 |    0.32691076318701 |     0.26651588218231 |
| Skin::makeBrokenLinkObj                                                |    232.577728271484 |   2387 |   0.097435160566185 |     0.26518927588372 |
| SkinTemplate::buildNavigationUrls-recentchanges2                       |    220.581466674805 |    715 |    0.30850554779693 |     0.25151092435033 |
| SkinTemplate::buildNavigationUrls-help2                                |    220.369613647461 |    715 |    0.30820924985659 |     0.25126936574826 |
| Parser::replaceLinkHolders-replace                                     |    220.109756469727 |    407 |    0.54081021245633 |     0.25097307195732 |
| SkinTemplate::buildContentActionUrls-edit                              |    215.769378662109 |    633 |    0.34086789678058 |     0.24602409573153 |
| SkinTemplate::buildNavigationUrls-currentevents2                       |    204.390563964844 |    715 |    0.28586092862216 |     0.23304976817055 |
| SkinTemplate::buildNavigationUrls-randompage2                          |    194.434539794922 |    715 |     0.2719364192936 |     0.22169773175707 |
| query: BEGIN                                                           |    193.746063232422 |   2964 |   0.065366418094609 |     0.22091271849536 |
| Title::getRestrictions                                                 |    193.424942016602 |   1171 |    0.16517928438651 |       0.220546570355 |
| User::loadDefaults3                                                    |    185.926528930664 |   1027 |    0.18103848970853 |     0.21199674595301 |
| _DiffEngine::diff                                                      |    184.613571166992 |     17 |     10.859621833352 |      0.2104996880825 |
| Parser::replaceInternalLinks-setup                                     |    172.780120849609 |   1073 |    0.16102527572191 |     0.19700697687496 |
| User::loadDefaults2                                                    |    172.293518066406 |   1115 |    0.15452333458871 |     0.19645214369863 |
| query: SELECT cur_text,cur_timestamp,cur_user,cur_user_text,cur_commen |    162.276031494141 |   1837 |   0.088337523948906 |     0.18503002675726 |
| Skin::formatComment                                                    |    157.327423095703 |    584 |    0.26939627242415 |     0.17938753515857 |
| User::loadDefaults1                                                    |    153.274520874023 |   1115 |    0.13746593800361 |     0.17476634372557 |
| Skin::outputPage                                                       |    149.319290161133 |      7 |     21.331327165876 |     0.17025651908974 |
| SkinTemplate::buildContentActionUrls-live                              |    148.766555786133 |    633 |    0.23501825558631 |     0.16962628149239 |
| _DiffEngine::_shift_boundaries                                         |    138.841949462891 |     34 |     4.0835867489085 |     0.15831006826832 |
| DiffFormatter::format                                                  |    131.899154663086 |      7 |     18.842736380441 |      0.1503937697506 |
| DiffFormatter::_block                                                  |    131.719085693359 |     13 |     10.132237361028 |     0.15018845189817 |
| TableDiffFormatter::_changed                                           |    125.719696044922 |     10 |     12.571969604492 |     0.14334784076813 |
| Skin::recentChangesLineOld                                             |    123.345367431641 |     52 |     2.3720262967623 |     0.14064058891584 |
| query: SELECT cur_text FROM `cur` WHERE cur_namespace='X' LIMIT N      |    123.088096618652 |   1645 |   0.074825590649637 |     0.14034724414414 |
| User::isAllowed                                                        |      120.0908203125 |   3690 |   0.032544937754065 |     0.13692969621657 |
| Parser::magicISBN                                                      |    117.049156188965 |    605 |    0.19346967965118 |     0.13346153650757 |
| query: SELECT cur_touched,cur_is_redirect FROM `cur` WHERE cur_id='X'  |    113.678565979004 |    992 |    0.11459532860787 |     0.12961832940548 |
| query: COMMIT                                                          |    112.316963195801 |   1808 |   0.062122214156969 |     0.12806580561568 |
| Skin::makeLink                                                         |     110.52904510498 |    138 |    0.80093510945638 |     0.12602718950499 |
| wfSpamBlacklistFilter                                                  |    108.637138366699 |     12 |     9.0530948638916 |     0.12387000368288 |
| WordLevelDiff::WordLevelDiff                                           |    99.1530990600586 |     10 |     9.9153099060059 |      0.1130561328326 |
| SkinTemplate::buildNavigationUrls-mainpage                             |    93.2277297973633 |    715 |    0.13038843328303 |     0.10629992106719 |
| Setup.php-database                                                     |    90.0240707397461 |   1115 |   0.080739076896633 |     0.10264705184372 |
| MappedDiff::MappedDiff                                                 |    88.5824890136719 |     10 |     8.8582489013672 |     0.10100333463612 |
| wfGetSiteNotice                                                        |    81.5951995849609 |    722 |    0.11301274180743 |    0.093036302548565 |
| Skin::recentChangesLineOld-rest                                        |    77.6304397583008 |     52 |      1.492893072275 |    0.088515612647176 |
| SkinStandard::doAfterContent                                           |    75.3590087890625 |      6 |     12.559834798177 |    0.085925686524718 |
| query: SELECT cur_user,cur_user_text,cur_timestamp,cur_comment,cur_min |    73.6788024902344 |    363 |     0.2029719076866 |    0.084009885321254 |
| query: SELECT cur_id, cur_namespace, cur_title FROM `cur` USE INDEX (n |    71.5360946655273 |    399 |    0.17928845780834 |    0.081566731625122 |
| MessageCache::initialise-parser                                        |    66.2925720214844 |   1115 |   0.059455221543932 |    0.075587973541156 |
| LinkCache::preFill                                                     |    58.8897743225098 |     24 |     2.4537405967712 |     0.06714717150953 |
| Setup.php-SetupSession                                                 |    53.2596778869629 |   1115 |   0.047766527252882 |    0.060727635090483 |
| SkinTemplate::outputPage-init                                          |    53.1543121337891 |    715 |   0.074341695292013 |    0.060607495178571 |
| query: SELECT cur_restrictions FROM `cur` WHERE cur_id=N LIMIT N       |    45.7675132751465 |    388 |     0.1179575084411 |    0.052184935310175 |
| SkinStandard::doAfterContent-3                                         |    45.7665977478027 |      6 |     7.6277662913005 |    0.052183891409561 |
| SkinTemplate::buildNavigationUrls-mainpage2                            |    40.1563148498535 |    715 |   0.056162678111683 |    0.045786946739634 |
| ucListEdit                                                             |    37.2154769897461 |     50 |    0.74430953979492 |    0.042433750935335 |
| query: SELECT LENGTH(cur_text) AS x,cur_namespace,cur_is_redirect FROM |    34.4610862731934 |    308 |    0.11188664374413 |    0.039293145491073 |
| Skin::doBeforeContent                                                  |    33.6489067077637 |      6 |     5.6081511179606 |    0.038367083858067 |
| LinksUpdate::doUpdate                                                  |    30.5408840179443 |     12 |      2.545073668162 |    0.034823260927691 |
| SkinTemplate::setupUserJs                                              |    30.1357116699219 |    715 |   0.042147848489401 |    0.034361276186595 |
| SkinStandard::doAfterContent-4                                         |     29.816349029541 |      6 |     4.9693915049235 |    0.033997133205337 |
| query: SELECT N FROM `user_newtalk` WHERE user_ip='X'                  |    28.5264549255371 |    656 |   0.043485449581611 |    0.032526372931128 |
| Skin::initPage                                                         |    28.1403884887695 |    766 |   0.036736799593694 |     0.03208617309097 |
| Skin::quickBar                                                         |    28.0867595672607 |      4 |     7.0216898918152 |    0.032025024437713 |
| Database::masterPosWait                                                |    28.0557994842529 |    103 |    0.27238640275974 |    0.031989723198617 |
| LuceneSearchSet::newFromQuery                                          |     27.861946105957 |     66 |    0.42215069857511 |    0.031768688117572 |
| main-updates                                                           |    26.5056781768799 |   1115 |   0.023771908678816 |    0.030222247223642 |
| User::loadFromDatabase                                                 |    25.9738388061523 |   1027 |   0.025290982284472 |    0.029615834483016 |
| Skin::recentChangesLineOld-page                                        |    24.9634628295898 |     52 |    0.48006659287673 |    0.028463785765427 |
| Parser::replaceLinkHolders-interwiki                                   |    22.7572631835938 |     37 |    0.61506116712416 |    0.025948237561715 |
| Parser::maybeDoSubpageLink                                             |    20.2765331268311 |   4830 |  0.0041980399848512 |    0.023119664884937 |
| Parser::removeHTMLcomments                                             |    19.3835334777832 |   1860 |   0.010421254557948 |    0.022101450750439 |
| MessageCache::load-fromdb                                              |    18.1588726043701 |    186 |   0.097628347335323 |    0.020705070569769 |
| WordLevelDiff::closing                                                 |    16.6475868225098 |     10 |      1.664758682251 |    0.018981875553963 |
| Setup.php-BlockCache                                                   |    16.3055534362793 |   1115 |   0.014623814741058 |    0.018591882983752 |
| query: SHOW SLAVE STATUS                                               |    14.5853586196899 |     38 |    0.38382522683395 |    0.016630486158783 |
| Article::getRevisionText                                               |    12.5058012008667 |     15 |    0.83372008005778 |    0.014259337682293 |
| SkinTemplate::getUserJs                                                |    11.9309597015381 |     27 |    0.44188739635326 |    0.013603893147307 |
| query: UPDATE `profiling` SET pf_count=pf_count+N, pf_time=pf_time + N |    10.4335565567017 |    195 |   0.053505418239496 |    0.011896527361957 |
| Parser::externalTidy                                                   |    8.63523006439209 |     37 |    0.23338459633492 |   0.0098460434061531 |
| WordLevelDiff::_split                                                  |    8.30117511749268 |     20 |    0.41505875587463 |   0.0094651479948339 |
| WordLevelDiff::orig                                                    |    7.65058755874634 |     10 |    0.76505875587463 |   0.0087233364512905 |
| query: SELECT iw_url,iw_local FROM `interwiki` WHERE iw_prefix='X'     |    7.56471967697144 |    108 |   0.070043700712698 |   0.0086254283602674 |
| User::inSorbsBlacklist                                                 |     5.9688892364502 |     33 |    0.18087543140758 |   0.0068058340160443 |
| query: SELECT N FROM `watchlist` WHERE wl_user='X'                     |    5.91221141815186 |     70 |   0.084460163116455 |   0.0067412089562636 |
| query: SHOW MASTER STATUS                                              |    5.07175779342651 |     86 |   0.058973927830541 |   0.0057829087363277 |
| MessageCache::load-error                                               |    4.55184841156006 |    374 |   0.012170717677968 |   0.0051900987818793 |
| query: SELECT cur_namespace,cur_title,cur_id FROM `cur`,`links` WHERE  |    4.29772329330444 |     22 |    0.19535105878657 |   0.0049003407874449 |
| query: SELECT N FROM `user_newtalk` WHERE user_id='X'                  |    4.27563762664795 |     66 |   0.064782388282545 |   0.0048751583162273 |
| _DiffEngine::_compareseq                                               |    4.16788959503174 |     29 |    0.14372033086316 |   0.0047523020879265 |
| query: SELECT user_name,user_password,user_newpassword,user_email,user |     4.0586633682251 |     13 |    0.31220487447885 |   0.0046277603950927 |
| query: UPDATE `recentchanges` SET rc_this_oldid='X'                    |    3.67153477668762 |     10 |    0.36715347766876 |   0.0041863494671131 |
| _DiffEngine::_diag                                                     |    3.31486392021179 |      2 |     1.6574319601059 |   0.0037796669921375 |
| query: SELECT cur_id,cur_title FROM `cur` USE INDEX (cur_random) WHERE |    3.27372884750366 |     16 |    0.20460805296898 |   0.0037327640482229 |
| query: SELECT * FROM `ipblocks` WHERE (ipb_address='X' OR ipb_user=N)  |    3.05346822738647 |     24 |    0.12722784280777 |   0.0034816189588428 |
| query: SELECT cur_namespace,cur_title FROM `imagelinks`,`cur` WHERE il |    2.93202304840088 |     33 |   0.088849183284875 |      0.0033431449987 |
| query: INSERT IGNORE INTO `profiling` (pf_name,pf_count,pf_time) VALUE |    2.91059255599976 |     96 |   0.030318672458331 |   0.0033187095688593 |
| page2xml                                                               |    2.47299122810364 |      1 |     2.4729912281036 |   0.0028197487262499 |
| pages2xml                                                              |    2.38528943061829 |      1 |     2.3852894306183 |   0.0027197495718094 |
| query: SELECT cur_title,cur_namespace,cl_sortkey FROM `cur`,`categoryl |    2.31660556793213 |     21 |    0.11031455085391 |   0.0026414350059822 |
| _DiffEngine::_diag-chunk                                               |    1.98540830612183 |     12 |    0.16545069217682 |   0.0022637979781942 |
| query: SELECT oi_size AS img_size,oi_description AS img_description,oi |    1.97238326072693 |     32 |   0.061636976897717 |   0.0022489465890165 |
| query: SELECT `recentchanges`.*,wl_user FROM `recentchanges` LEFT OUTE |    1.96050953865051 |      1 |     1.9605095386505 |   0.0022354079592307 |
| query: SELECT old_namespace,old_title,old_text,old_timestamp,old_user, |    1.95217621326447 |      5 |    0.39043524265289 |   0.0022259061529259 |
| Parser::findColonNoLinks                                               |    1.78118002414703 |      7 |    0.25445428916386 |   0.0020309332468444 |
| User::loadDefaults4                                                    |    1.71771287918091 |     10 |    0.17177128791809 |   0.0019585668756486 |
| query: SELECT COUNT(*) FROM `archive` WHERE ar_namespace='X' LIMIT N   |    1.65612697601318 |      4 |     0.4140317440033 |   0.0018883455299201 |
| query: SELECT cur_text,cur_timestamp,cur_user,cur_user_text,cur_commen |    1.60390841960907 |     12 |    0.13365903496742 |   0.0018288050001221 |
| query: DELETE FROM `imagelinks` WHERE il_from='X'                      |    1.60390830039978 |     12 |    0.13365902503332 |   0.0018288048641976 |
| query: UPDATE `cur` SET cur_text='X'                                   |    1.60190832614899 |     12 |    0.13349236051242 |   0.0018265244578694 |
| query: SELECT user_id FROM `user` WHERE user_name='X' LIMIT N          |    1.41797232627869 |      5 |    0.28359446525574 |   0.0016167973486699 |
| query: SELECT bl_to FROM `brokenlinks` WHERE bl_from='X'               |    1.20781672000885 |     24 |   0.050325696667035 |    0.001377174176392 |
| query: SELECT rc_namespace cur_namespace, rc_title cur_title, rc_comme |   0.895026624202728 |      3 |    0.29834220806758 |   0.0010205253277387 |
| xmlsafe                                                                |   0.859684228897095 |      4 |    0.21492105722427 |  0.00098022729796278 |
| query: SELECT math_outputhash,math_html_conservativeness,math_html,mat |   0.856468081474304 |      4 |    0.21411702036858 |   0.0009765601892825 |
| query: SELECT cur_text,cur_user_text,cur_comment FROM `cur` WHERE cur_ |   0.841583847999573 |      5 |    0.16831676959991 |  0.00095958892068088 |
| query: SELECT cur_id,cur_namespace,cur_title,cur_is_redirect FROM `lin |   0.823403775691986 |      6 |    0.13723396261533 |  0.00093885967783122 |
| query: SELECT cur_title FROM `cur` WHERE cur_namespace=N AND cur_title |   0.818940103054047 |      1 |    0.81894010305405 |  0.00093377011863983 |
| query: SELECT MAX(rc_timestamp) FROM `recentchanges` LIMIT N           |   0.778535008430481 |      1 |    0.77853500843048 |  0.00088769950876299 |
| query: UPDATE `cur` SET cur_touched='X'                                |   0.575458765029907 |     50 |   0.011509175300598 |  0.00065614835235251 |
| query: SELECT cur_id as id,cur_timestamp as timestamp,cur_user as user |   0.534574747085571 |      2 |    0.26728737354279 |  0.00060953166555944 |
| query: UPDATE `user` SET user_name='X'                                 |   0.492100298404694 |      6 |   0.082016716400782 |  0.00056110154126097 |
| SkinTemplate::getUserStylesheet                                        |   0.452215164899826 |     17 |   0.026600892052931 |  0.00051562380032984 |
| query: SELECT COUNT(*) AS n FROM `watchlist` WHERE wl_user=N           |   0.424384385347366 |      3 |    0.14146146178246 |   0.0004838906488727 |
| _DiffEngine::_lcs_pos                                                  |   0.330628752708435 |     18 |   0.018368264039358 |  0.00037698880356567 |
| query: SELECT cur_user,cur_user_text,cur_timestamp,cur_comment,cur_min |  0.0470148995518684 |     12 |   0.003917908295989 |  5.3607227401209e-05 |
| query: SELECT old_namespace,old_title,old_timestamp,old_comment,old_mi | -0.0336454324424267 |      1 |  -0.033645432442427 | -3.8363122438735e-05 |
| query: SELECT cur_namespace,cur_title,cur_timestamp,cur_comment,cur_mi | -0.0336454324424267 |      1 |  -0.033645432442427 | -3.8363122438735e-05 |
| query: SELECT img_size,img_description,img_user,img_user_text,img_time |  -0.066976971924305 |     33 | -0.0020296052098274 | -7.6368338522759e-05 |
| query: INSERT IGNORE INTO `brokenlinks` (bl_from,bl_to) VALUES ('X')   | -0.0676263198256493 |      2 |  -0.033813159912825 | -7.7108736586812e-05 |
| query: DELETE FROM `links` WHERE l_from=N AND l_to IN(N,N)             | -0.0676263198256493 |      2 |  -0.033813159912825 | -7.7108736586812e-05 |
| query: DELETE FROM `links` WHERE l_from=N AND l_to IN(N)               | -0.0880072116851807 |      2 |   -0.04400360584259 | -0.00010034739316095 |
| query: REPLACE INTO `watchlist` (wl_user,wl_namespace,wl_title) VALUES |   -0.12597730755806 |      4 |  -0.031494326889515 | -0.00014364157401222 |
| query: SELECT DISTINCT 'X' as type, N as namespace, cl_to as title, N  |  -0.135225415229797 |      1 |    -0.1352254152298 | -0.00015418643140244 |
| SkinStandard::doAfterContent-2                                         |  -0.137267291545868 |      6 |  -0.022877881924311 | -0.00015651461521319 |
| SkinStandard::doAfterContent-1                                         |  -0.137267291545868 |      6 |  -0.022877881924311 | -0.00015651461521319 |
| query: DELETE FROM `brokenlinks` WHERE bl_from=N AND bl_to IN('X')     |  -0.140541359782219 |      4 |  -0.035135339945555 | -0.00016024776623863 |
| query: SELECT cur_namespace,cur_title FROM `cur` WHERE cur_id='X' LIMI |   -0.15626086294651 |      1 |   -0.15626086294651 |  -0.0001781714242448 |
| query: SELECT cur_id, cur_namespace, cur_title, LENGTH(cur_text) AS cu |  -0.165710791945457 |      7 |  -0.023672970277922 | -0.00018894640191359 |
| query: SELECT user_id FROM `user_newtalk` WHERE user_id='X' LIMIT N    |  -0.179784059524536 |      6 |  -0.029964009920756 | -0.00020499299273014 |
| query: UPDATE `user_rights` SET ur_rights = 'X' WHERE (ur_user=N)      |  -0.179784059524536 |      6 |  -0.029964009920756 | -0.00020499299273014 |
| SquidUpdate::fastPurge                                                 |  -0.194724664092064 |      6 |  -0.032454110682011 | -0.00022202853665764 |
| SquidUpdate::HTCPPurge                                                 |  -0.194724664092064 |      6 |  -0.032454110682011 | -0.00022202853665764 |
| query: SELECT cur_id as id,cur_timestamp as timestamp,cur_user as user |  -0.210482463240623 |      1 |   -0.21048246324062 | -0.00023999586042843 |
| query: INSERT IGNORE INTO `categorylinks` (cl_from,cl_to,cl_sortkey) V |  -0.225366458296776 |      8 |  -0.028170807287097 | -0.00025696685718092 |
| query: INSERT IGNORE INTO `imagelinks` (il_from,il_to) VALUES ('X')    |  -0.240458145737648 |      8 |  -0.030057268217206 | -0.00027417466849653 |
| query: SELECT old_id,old_user,old_comment,old_user_text,old_timestamp, |  -0.275785863399506 |     10 |  -0.027578586339951 |  -0.0003144559625611 |
| query: SELECT old_namespace,old_title,old_timestamp,old_text,old_flags |  -0.284818649291992 |      9 |  -0.031646516587999 | -0.00032475530621641 |
| query: INSERT IGNORE INTO `links` (l_from,l_to) VALUES ('X')           |  -0.290885657072067 |      8 |  -0.036360707134008 | -0.00033167301674672 |
| query: SELECT old_id FROM `old` WHERE old_title='X' AND old_namespace= |  -0.328945755958557 |      2 |   -0.16447287797928 | -0.00037506982064013 |
| revision2xml                                                           |  -0.385885953903198 |      1 |    -0.3858859539032 | -0.00043999405037544 |
| query: REPLACE INTO `updates` (up_page,up_action,up_timestamp,up_seque |  -0.396091669797897 |     12 |  -0.033007639149825 |   -0.000451630789749 |
| query: SELECT bl_from FROM `brokenlinks` WHERE bl_to='X' FOR UPDATE    |  -0.396091669797897 |     12 |  -0.033007639149825 |   -0.000451630789749 |
| query: UPDATE LOW_PRIORITY `site_stats` SET ss_total_views=(ss_total_v |  -0.396091669797897 |     12 |  -0.033007639149825 |   -0.000451630789749 |
| query: DELETE FROM `categorylinks` WHERE cl_from='X'                   |  -0.396091669797897 |     12 |  -0.033007639149825 |   -0.000451630789749 |
| query: INSERT INTO `old` (old_id,old_namespace,old_title,old_text,old_ |  -0.396091669797897 |     12 |  -0.033007639149825 |   -0.000451630789749 |
| query: INSERT INTO `recentchanges` (rc_timestamp,rc_cur_time,rc_namesp |  -0.396091669797897 |     12 |  -0.033007639149825 |   -0.000451630789749 |
| query: UPDATE `recentchanges` SET rc_cur_time='X'                      |  -0.396091669797897 |     12 |  -0.033007639149825 |   -0.000451630789749 |
| LoadBalancer::waitFor                                                  |  -0.483496606349945 |    114 | -0.0042411983013153 | -0.00055129145805618 |
| query: SELECT cur_id,cur_namespace,cur_title FROM `cur`,`links` WHERE  |  -0.792183339595795 |     24 |  -0.033007639149825 | -0.00090326157949801 |
+------------------------------------------------------------------------+---------------------+--------+---------------------+----------------------+