Profiling/Live aggregate 20040710
Run taken for a couple of hours ending at 09:00, sampling rate 1/200. Unlike all previous runs, this one includes requests which end in a redirect, for example page saving.
Sorted by total time
[edit]+------------------------------------------------------------------------+-------------+--------+----------------------+----------------------+
| name | total | count | each | percent |
+------------------------------------------------------------------------+-------------+--------+----------------------+----------------------+
| -total | 2.99557e+06 | 1199 | 2498.3880316931 | 100 |
| LinkCache::addLinkObj | 1.1166e+06 | 10574 | 105.59817713259 | 37.274914292109 |
| query: SELECT cur_id FROM cur WHERE cur_namespace=N AND cur_title='X' | 1.11246e+06 | 10574 | 105.20758464157 | 37.137039737632 |
| Article::view | 972037 | 904 | 1075.2623064159 | 32.449183873271 |
| Parser::internalParse | 872486 | 1332 | 655.01942567568 | 29.125898442106 |
| Parser::parse | 757571 | 657 | 1153.0761035008 | 25.289734356656 |
| Parser::replaceInternalLinks | 567532 | 2664 | 213.03739677177 | 18.94571470562 |
| OutputPage::output | 494470 | 1200 | 412.05799479167 | 16.506709831001 |
| query: SELECT COUNT(*) AS n FROM cur WHERE cur_timestamp>'X' | 296017 | 7 | 42288.196428571 | 9.88184708589 |
| Parser::replaceVariables | 295414 | 5677 | 52.036980359345 | 9.8617027376034 |
| ParserCache::get | 256056 | 890 | 287.70284410112 | 8.5478144832168 |
| Setup.php | 219353 | 1199 | 182.94643974145 | 7.322579095829 |
| Skin::makeLink | 129121 | 2729 | 47.314475311469 | 4.310409092802 |
| LinkCache::preFill | 107168 | 595 | 180.11397058824 | 3.5775465398081 |
| wfMsg | 106317 | 62344 | 1.7053262443058 | 3.5491394618165 |
| DifferenceEngine::showDiffPage | 105623 | 6 | 17603.897135417 | 3.5259893702103 |
| Setup.php-MessageCache | 103530 | 1201 | 86.202871305162 | 3.4560949495459 |
| Article::getContent | 89139.1 | 670 | 133.04341184701 | 2.9756997088782 |
| query: SELECT ss_total_views, ss_total_edits, ss_good_articles FROM si | 84965 | 1054 | 80.611998932638 | 2.8363591862276 |
| LinksUpdate::doUpdate | 78978.8 | 14 | 5641.3443080357 | 2.6365230262315 |
| query: SELECT cur_id,cur_namespace,cur_title,cur_text FROM cur,searchi | 77258.7 | 11 | 7023.5149147727 | 2.5790996367216 |
| query: SELECT cur_id,cur_namespace,cur_title,cur_text FROM cur,searchi | 69364.5 | 22 | 3152.9332386364 | 2.3155724929894 |
| query: UPDATE cur SET cur_text='X' | 68800.9 | 12 | 5733.408203125 | 2.296756931012 |
| query: SELECT lcc_cacheobj FROM linkscc WHERE lcc_pageid = N | 66068.9 | 570 | 115.9102933114 | 2.2055544634326 |
| query: UPDATE cur SET cur_touched='X' | 64822.1 | 21 | 3086.7648809524 | 2.1639328077178 |
| query: SELECT cur_text,cur_timestamp,cur_user,cur_user_text,cur_commen | 64691.2 | 719 | 89.97385148644 | 2.159564243425 |
| Setup.php-misc | 58154.2 | 1200 | 48.461861979167 | 1.9413429751911 |
| PageHistory::history | 49751.5 | 10 | 4975.15390625 | 1.6608386629444 |
| query: SELECT N FROM user_newtalk WHERE user_ip='X' | 47126.9 | 1042 | 45.227394733685 | 1.5732227447907 |
| query: SELECT cur_text FROM cur WHERE cur_namespace=N AND cur_title='X | 42881.9 | 1237 | 34.666055098019 | 1.4315121837525 |
| query: SELECT cur_user,cur_user_text,cur_timestamp,cur_comment,cur_min | 41541.9 | 406 | 102.3199565117 | 1.3867791598987 |
| query: SELECT cur_touched,cur_is_redirect FROM cur WHERE cur_id=N | 39546.6 | 363 | 108.94391356749 | 1.3201720183381 |
| query: SELECT cur_restrictions FROM cur WHERE (cur_id=N) | 37599.8 | 381 | 98.687120652887 | 1.2551810669165 |
| query: COMMIT | 35022.9 | 1927 | 18.174856885703 | 1.1691591707297 |
| query: SELECT cur_id,cur_namespace,cur_title FROM cur,links WHERE cur_ | 34733.6 | 28 | 1240.4874441964 | 1.1595015414026 |
| Setup.php-User | 33685.1 | 1200 | 28.070950520833 | 1.1244995626454 |
| query: SELECT recentchanges.*,wl_user FROM recentchanges LEFT OUTER JO | 33678.6 | 3 | 11226.184895833 | 1.1242797065397 |
| main-misc-setup | 32435.7 | 1199 | 27.052289668474 | 1.0827897558467 |
| query: SHOW COLUMNS FROM cur LIKE 'X'; | 30847.9 | 1162 | 26.54727167599 | 1.0297859174252 |
| query: SELECT cur_id,cur_namespace,cur_title,cur_text FROM cur,searchi | 28825.2 | 2 | 14412.583984375 | 0.96226075274224 |
| Parser::tidy | 28133.9 | 657 | 42.821828624429 | 0.93918577211879 |
| Title::secureAndSplit | 26540.4 | 82223 | 0.32278588507018 | 0.88598991820748 |
| query: SELECT old_id,old_user,old_comment,old_user_text,old_timestamp, | 25970.3 | 10 | 2597.026953125 | 0.866956651741 |
| -overhead-total | 24469.6 | 356889 | 0.068563537306067 | 0.81685938666959 |
| query: SELECT LENGTH(cur_text) AS x, cur_namespace, cur_is_redirect FR | 23143 | 839 | 27.583984375 | 0.77257363828587 |
| query: SELECT cur_text,cur_timestamp,cur_user,cur_counter,cur_restrict | 20504.2 | 552 | 37.145245980525 | 0.68448390805615 |
| Skin::outputPage | 18761 | 31 | 605.19367439516 | 0.62629219578529 |
| query: SELECT N FROM watchlist WHERE wl_user=N AND wl_namespace=N AND | 17602.1 | 147 | 119.74193505527 | 0.58760371522706 |
| query: SELECT 'X' as type, rc_namespace AS namespace, rc_title AS titl | 16271.8 | 1 | 16271.80859375 | 0.54319623749892 |
| query: SELECT N FROM user_newtalk WHERE user_id=N | 15999.3 | 20 | 799.96484375 | 0.53409907172006 |
| Parser::replaceExternalLinks | 14341.8 | 1332 | 10.76709277637 | 0.4787663364301 |
| Skin::doAfterContent | 13035.6 | 27 | 482.80085358796 | 0.43516375894666 |
| query: BEGIN | 12890.9 | 1927 | 6.6896249229696 | 0.43033276006614 |
| -overhead-internal | 11902.3 | 356855 | 0.03335327023581 | 0.39732979621806 |
| Skin::doAfterContent-3 | 11242.8 | 27 | 416.40024594907 | 0.37531478021817 |
| Title::newFromText | 10643.3 | 67958 | 0.15661580498249 | 0.35530155014881 |
| query: SELECT user_name,user_password,user_newpassword,user_email,user | 10216.5 | 20 | 510.82578125 | 0.34105445721507 |
| query: SELECT cur_namespace,cur_title FROM imagelinks,cur WHERE il_to= | 9911.83 | 16 | 619.48962402344 | 0.33088337390439 |
| Skin::makeKnownLinkObj | 8644.56 | 33972 | 0.25446127969357 | 0.28857835168781 |
| Setup.php-memcached | 7957.26 | 1201 | 6.6255309702852 | 0.26563458708238 |
| Parser::doBlockLevels | 7823.72 | 657 | 11.908247716895 | 0.26117653509531 |
| query: SELECT oi_size AS img_size, oi_description AS img_description,o | 7806.23 | 16 | 487.88925170898 | 0.26059264826532 |
| Setup.php-includes | 7776.53 | 1201 | 6.4750448031588 | 0.25960120937341 |
| query: SELECT cur_id,cur_title FROM cur USE INDEX (cur_random) WHERE c | 6847.99 | 26 | 263.38407076322 | 0.22860397608646 |
| query: SELECT img_size,img_description,img_user,img_user_text,img_time | 6574.71 | 16 | 410.91906738281 | 0.21948113760841 |
| query: SELECT * FROM ipblocks WHERE ipb_user=N | 6119.51 | 159 | 38.487510441234 | 0.20428565441675 |
| query: SELECT DISTINCT cur_title,cur_namespace,cl_sortkey FROM cur,cat | 5907.85 | 11 | 537.07737038352 | 0.1972197777973 |
| query: SELECT cur_id,cur_namespace,cur_title,cur_text FROM cur,searchi | 5579.79 | 1 | 5579.7890625 | 0.18626819553125 |
| query: INSERT INTO old (old_namespace,old_title,old_text,old_comment,o | 5071.34 | 12 | 422.61157226562 | 0.16929477604576 |
| query: SELECT cur_id,cur_namespace,cur_title,cur_user,cur_comment,cur_ | 4847.1 | 1 | 4847.1040039062 | 0.1618092200703 |
| query: SELECT iw_url,iw_local FROM interwiki WHERE iw_prefix='X' | 4724.31 | 90 | 52.492388237847 | 0.15771019466868 |
| query: SELECT bl_to FROM brokenlinks WHERE bl_from='X' | 4350.68 | 28 | 155.38150460379 | 0.14523733790007 |
| query: INSERT INTO recentchanges (rc_timestamp,rc_cur_time,rc_namespac | 4149.82 | 15 | 276.65475260417 | 0.13853206897834 |
| query: DELETE FROM brokenlinks WHERE bl_from=N AND bl_to IN('X') | 3855.72 | 2 | 1927.8608398438 | 0.12871424200834 |
| query: UPDATE recentchanges SET rc_this_oldid=N WHERE rc_namespace=N A | 3827.8 | 12 | 318.98313395182 | 0.12778206222617 |
| Skin::doBeforeContent | 3497.32 | 27 | 129.53035481771 | 0.11674982693439 |
| query: SELECT user_id FROM user WHERE user_name='X' | 2906.89 | 23 | 126.38660198709 | 0.097039779217213 |
| Setup.php-language | 2718.93 | 1201 | 2.2638851168948 | 0.090764980335214 |
| query: SELECT old_namespace,old_title,old_timestamp,old_comment,old_mi | 2684.02 | 1 | 2684.015625 | 0.089599578343634 |
| query: SELECT * FROM ipblocks WHERE (ipb_address='X' OR ipb_user=N) | 2657.16 | 35 | 75.918910435268 | 0.088703128438675 |
| query: DELETE FROM imagelinks WHERE il_from='X' | 2546.65 | 14 | 181.90384347098 | 0.085014075667764 |
| query: SELECT bl_from FROM brokenlinks WHERE bl_to='X' | 2444.36 | 14 | 174.59720284598 | 0.08159926437451 |
| query: UPDATE recentchanges SET rc_cur_time='X' WHERE rc_cur_id=N | 2433.16 | 12 | 202.76302083333 | 0.08122522537259 |
| query: DELETE FROM linkscc WHERE lcc_pageid='X' | 2309.71 | 12 | 192.47583007812 | 0.077104260000756 |
| Setup.php-SetupSession | 2031.59 | 1201 | 1.6915820881687 | 0.06781987911941 |
| query: SELECT cur_text FROM cur WHERE cur_namespace=N AND cur_title='X | 1941.51 | 5 | 388.30256347656 | 0.064812860314947 |
| query: UPDATE LOW_PRIORITY site_stats SET ss_total_views=(ss_total_vie | 1855.86 | 14 | 132.56127929688 | 0.06195347175585 |
| query: SELECT COUNT(*) AS n FROM watchlist WHERE wl_user=N | 1792.28 | 7 | 256.04068429129 | 0.059831231965801 |
| Skin::doAfterContent-4 | 1784.17 | 27 | 66.080362955729 | 0.059560332014068 |
| Skin::quickBar | 1781.63 | 26 | 68.524362417368 | 0.059475661007162 |
| query: SELECT cur_id,cur_text,cur_timestamp FROM cur WHERE cur_namespa | 1754.72 | 2 | 877.35968017578 | 0.058577198036584 |
| query: SELECT COUNT(*) AS n FROM archive WHERE ar_namespace=N AND ar_t | 1686.23 | 4 | 421.55767822266 | 0.056290864873443 |
| Parser::doAllQuotes | 1679.67 | 1332 | 1.2610137297942 | 0.056071860449334 |
| query: REPLACE INTO linkscc(lcc_pageid,lcc_cacheobj) VALUES(N, 'X') | 1557.45 | 28 | 55.623182024275 | 0.051991792094792 |
| Parser::removeHTMLtags | 1530.95 | 1332 | 1.1493592591615 | 0.05110706605579 |
| query: INSERT IGNORE INTO links (l_from,l_to) VALUES (N,N) | 1463.1 | 4 | 365.77407836914 | 0.048842045307998 |
| query: DELETE FROM categorylinks WHERE cl_from='X' | 1394.86 | 14 | 99.633082798549 | 0.046564241186029 |
| query: SELECT cur_namespace,cur_title,cur_comment, cur_id, cur_user,cu | 1325.84 | 1 | 1325.8420410156 | 0.044260132734981 |
| Setup.php-OutputPage | 1075.58 | 1201 | 0.89557042308493 | 0.035905722968663 |
| query: SELECT MAX(rc_timestamp) AS lastmod FROM recentchanges | 1049.17 | 4 | 262.29357910156 | 0.035024228429732 |
| query: SELECT cur_id,cur_namespace,cur_title,cur_is_redirect FROM link | 1048 | 3 | 349.33182779948 | 0.034984875849422 |
| query: DELETE FROM links WHERE l_from=N AND l_to IN(N,N,N,N,N,N,N,N,N, | 927.007 | 1 | 927.00738525391 | 0.030945971426744 |
| Skin::makeBrokenLinkObj | 884.287 | 3750 | 0.23580986328125 | 0.029519850949922 |
| query: INSERT IGNORE INTO links (l_from,l_to) VALUES (N,N),(N,N) | 730.944 | 2 | 365.47186279297 | 0.024400845134955 |
| Setup.php-DateFormatter | 699.087 | 1201 | 0.58208771133105 | 0.023337394321847 |
| query: INSERT INTO cur (cur_namespace,cur_title,cur_comment,cur_user,c | 687.874 | 1 | 687.87353515625 | 0.022963047655039 |
| query: INSERT IGNORE INTO categorylinks (cl_from,cl_to,cl_sortkey) VAL | 619.466 | 5 | 123.89318847656 | 0.020679420312891 |
| query: SELECT math_outputhash,math_html_conservativeness,math_html,mat | 593.409 | 56 | 10.596580505371 | 0.019809553876675 |
| Setup.php-extensions | 574.428 | 1199 | 0.47908927402067 | 0.01917593536085 |
| query: SELECT old_namespace,old_title,old_timestamp,old_text,old_flags | 554.68 | 6 | 92.446746826172 | 0.018516709346353 |
| query: UPDATE cur SET cur_timestamp='X' WHERE cur_id=N | 542.254 | 1 | 542.25366210938 | 0.018101869090383 |
| query: SELECT recentchanges.* FROM recentchanges WHERE rc_timestamp > | 452.382 | 1 | 452.38165283203 | 0.015101702451582 |
| Parser::doHeadings | 408.549 | 1332 | 0.30671852272194 | 0.013638454361711 |
| Parser::replaceInternalLinks-setup | 263.633 | 2664 | 0.098961334686738 | 0.0088007703918338 |
| query: SELECT cur_id,cur_text FROM cur WHERE cur_namespace=N AND cur_t | 246.659 | 1 | 246.65852355957 | 0.0082341173799243 |
| Skin::initPage | 228.93 | 1039 | 0.22033725184128 | 0.0076423056321999 |
| query: DELETE FROM links WHERE l_from=N AND l_to IN(N) | 193.893 | 1 | 193.89347839355 | 0.0064726798703503 |
| query: SELECT old_namespace,old_title,old_timestamp,old_text,old_flags | 187.694 | 2 | 93.84716796875 | 0.0062657360116853 |
| Setup.php-database | 184.874 | 1201 | 0.15393354811339 | 0.00617159208441 |
| query: SELECT cur_text, cur_user_text, cur_comment FROM cur WHERE cur_ | 172.254 | 4 | 43.063438415527 | 0.0057502883189189 |
| query: INSERT INTO image (img_name,img_size,img_timestamp,img_descript | 167.137 | 1 | 167.13662719727 | 0.0055794650311144 |
| query: DELETE linkscc FROM linkscc,brokenlinks WHERE lcc_pageid=bl_fro | 166.751 | 1 | 166.75134277344 | 0.0055666032125781 |
| query: DELETE FROM user_newtalk WHERE user_id=N | 138.236 | 2 | 69.117881774902 | 0.0046146773553425 |
| query: INSERT INTO cur (cur_namespace,cur_title,cur_text,cur_comment,c | 117.989 | 1 | 117.98926544189 | 0.0039387954131858 |
| query: SELECT cur_namespace,cur_title,cur_id FROM brokenlinks,cur WHER | 101.318 | 1 | 101.31832122803 | 0.0033822749673881 |
| query: SELECT old_namespace,old_title,old_timestamp,old_comment,old_mi | 58.592 | 1 | 58.591983795166 | 0.0019559562148093 |
| query: SELECT img_name,img_size,img_timestamp,img_description,img_user | 24.5928 | 1 | 24.592832565308 | 0.00082097414322138 |
| Setup.php-BlockCache | 21.9101 | 1201 | 0.018243252883644 | 0.00073141895623464 |
| query: INSERT IGNORE INTO brokenlinks (bl_from,bl_to) VALUES (N,'X') | 20.6013 | 1 | 20.601324081421 | 0.00068772697663259 |
| query: UPDATE user SET user_name= 'X' WHERE user_id=N | 17.1644 | 2 | 8.5822105407715 | 0.0005729940157926 |
| query: INSERT IGNORE INTO imagelinks (il_from,il_to) VALUES (N,'X') | 12.5366 | 4 | 3.1341509819031 | 0.00041850517385688 |
| query: INSERT IGNORE INTO links (l_from,l_to) VALUES (N,N),(N,N),(N,N) | 10.1024 | 1 | 10.102360725403 | 0.00033724366312934 |
| query: SELECT cur_namespace,cur_title,cur_timestamp,cur_comment,cur_mi | 1.38202 | 1 | 1.3820154666901 | 4.6135351048789e-05 |
| query: SELECT cur_namespace,cur_title FROM cur WHERE cur_id=N LIMIT N | 1.34893 | 3 | 0.44964277744293 | 4.5030814525322e-05 |
| Skin::doAfterContent-2 | 1.25356 | 27 | 0.046428313961735 | 4.1847315461432e-05 |
| query: SELECT cur_namespace,cur_title,cur_timestamp,cur_comment,cur_mi | 1.15758 | 1 | 1.1575754880905 | 3.8642947778606e-05 |
| query: REPLACE INTO watchlist (wl_user, wl_namespace,wl_title) VALUES | 0.548606 | 1 | 0.54860645532608 | 1.8313942219995e-05 |
| Skin::doAfterContent-1 | -0.217717 | 27 | -0.0080635762876934 | -7.2679576720477e-06 |
| Parser::replaceInternalLinks-prefixhandling | -23.8646 | 26429 | -0.00090296874951503 | -0.00079666250460351 |
+------------------------------------------------------------------------+-------------+--------+----------------------+----------------------+
Sorted by time per invocation
[edit]+------------------------------------------------------------------------+-------------+--------+----------------------+----------------------+
| name | total | count | each | percent |
+------------------------------------------------------------------------+-------------+--------+----------------------+----------------------+
| query: SELECT COUNT(*) AS n FROM cur WHERE cur_timestamp>'X' | 296017 | 7 | 42288.196428571 | 9.88184708589 |
| DifferenceEngine::showDiffPage | 105623 | 6 | 17603.897135417 | 3.5259893702103 |
| query: SELECT 'X' as type, rc_namespace AS namespace, rc_title AS titl | 16271.8 | 1 | 16271.80859375 | 0.54319623749892 |
| query: SELECT cur_id,cur_namespace,cur_title,cur_text FROM cur,searchi | 28825.2 | 2 | 14412.583984375 | 0.96226075274224 |
| query: SELECT recentchanges.*,wl_user FROM recentchanges LEFT OUTER JO | 33678.6 | 3 | 11226.184895833 | 1.1242797065397 |
| query: SELECT cur_id,cur_namespace,cur_title,cur_text FROM cur,searchi | 77258.7 | 11 | 7023.5149147727 | 2.5790996367216 |
| query: UPDATE cur SET cur_text='X' | 68800.9 | 12 | 5733.408203125 | 2.296756931012 |
| LinksUpdate::doUpdate | 78978.8 | 14 | 5641.3443080357 | 2.6365230262315 |
| query: SELECT cur_id,cur_namespace,cur_title,cur_text FROM cur,searchi | 5579.79 | 1 | 5579.7890625 | 0.18626819553125 |
| PageHistory::history | 49751.5 | 10 | 4975.15390625 | 1.6608386629444 |
| query: SELECT cur_id,cur_namespace,cur_title,cur_user,cur_comment,cur_ | 4847.1 | 1 | 4847.1040039062 | 0.1618092200703 |
| query: SELECT cur_id,cur_namespace,cur_title,cur_text FROM cur,searchi | 69364.5 | 22 | 3152.9332386364 | 2.3155724929894 |
| query: UPDATE cur SET cur_touched='X' | 64822.1 | 21 | 3086.7648809524 | 2.1639328077178 |
| query: SELECT old_namespace,old_title,old_timestamp,old_comment,old_mi | 2684.02 | 1 | 2684.015625 | 0.089599578343634 |
| query: SELECT old_id,old_user,old_comment,old_user_text,old_timestamp, | 25970.3 | 10 | 2597.026953125 | 0.866956651741 |
| -total | 2.99557e+06 | 1199 | 2498.3880316931 | 100 |
| query: DELETE FROM brokenlinks WHERE bl_from=N AND bl_to IN('X') | 3855.72 | 2 | 1927.8608398438 | 0.12871424200834 |
| query: SELECT cur_namespace,cur_title,cur_comment, cur_id, cur_user,cu | 1325.84 | 1 | 1325.8420410156 | 0.044260132734981 |
| query: SELECT cur_id,cur_namespace,cur_title FROM cur,links WHERE cur_ | 34733.6 | 28 | 1240.4874441964 | 1.1595015414026 |
| Parser::parse | 757571 | 657 | 1153.0761035008 | 25.289734356656 |
| Article::view | 972037 | 904 | 1075.2623064159 | 32.449183873271 |
| query: DELETE FROM links WHERE l_from=N AND l_to IN(N,N,N,N,N,N,N,N,N, | 927.007 | 1 | 927.00738525391 | 0.030945971426744 |
| query: SELECT cur_id,cur_text,cur_timestamp FROM cur WHERE cur_namespa | 1754.72 | 2 | 877.35968017578 | 0.058577198036584 |
| query: SELECT N FROM user_newtalk WHERE user_id=N | 15999.3 | 20 | 799.96484375 | 0.53409907172006 |
| query: INSERT INTO cur (cur_namespace,cur_title,cur_comment,cur_user,c | 687.874 | 1 | 687.87353515625 | 0.022963047655039 |
| Parser::internalParse | 872486 | 1332 | 655.01942567568 | 29.125898442106 |
| query: SELECT cur_namespace,cur_title FROM imagelinks,cur WHERE il_to= | 9911.83 | 16 | 619.48962402344 | 0.33088337390439 |
| Skin::outputPage | 18761 | 31 | 605.19367439516 | 0.62629219578529 |
| query: UPDATE cur SET cur_timestamp='X' WHERE cur_id=N | 542.254 | 1 | 542.25366210938 | 0.018101869090383 |
| query: SELECT DISTINCT cur_title,cur_namespace,cl_sortkey FROM cur,cat | 5907.85 | 11 | 537.07737038352 | 0.1972197777973 |
| query: SELECT user_name,user_password,user_newpassword,user_email,user | 10216.5 | 20 | 510.82578125 | 0.34105445721507 |
| query: SELECT oi_size AS img_size, oi_description AS img_description,o | 7806.23 | 16 | 487.88925170898 | 0.26059264826532 |
| Skin::doAfterContent | 13035.6 | 27 | 482.80085358796 | 0.43516375894666 |
| query: SELECT recentchanges.* FROM recentchanges WHERE rc_timestamp > | 452.382 | 1 | 452.38165283203 | 0.015101702451582 |
| query: INSERT INTO old (old_namespace,old_title,old_text,old_comment,o | 5071.34 | 12 | 422.61157226562 | 0.16929477604576 |
| query: SELECT COUNT(*) AS n FROM archive WHERE ar_namespace=N AND ar_t | 1686.23 | 4 | 421.55767822266 | 0.056290864873443 |
| Skin::doAfterContent-3 | 11242.8 | 27 | 416.40024594907 | 0.37531478021817 |
| OutputPage::output | 494470 | 1200 | 412.05799479167 | 16.506709831001 |
| query: SELECT img_size,img_description,img_user,img_user_text,img_time | 6574.71 | 16 | 410.91906738281 | 0.21948113760841 |
| query: SELECT cur_text FROM cur WHERE cur_namespace=N AND cur_title='X | 1941.51 | 5 | 388.30256347656 | 0.064812860314947 |
| query: INSERT IGNORE INTO links (l_from,l_to) VALUES (N,N) | 1463.1 | 4 | 365.77407836914 | 0.048842045307998 |
| query: INSERT IGNORE INTO links (l_from,l_to) VALUES (N,N),(N,N) | 730.944 | 2 | 365.47186279297 | 0.024400845134955 |
| query: SELECT cur_id,cur_namespace,cur_title,cur_is_redirect FROM link | 1048 | 3 | 349.33182779948 | 0.034984875849422 |
| query: UPDATE recentchanges SET rc_this_oldid=N WHERE rc_namespace=N A | 3827.8 | 12 | 318.98313395182 | 0.12778206222617 |
| ParserCache::get | 256056 | 890 | 287.70284410112 | 8.5478144832168 |
| query: INSERT INTO recentchanges (rc_timestamp,rc_cur_time,rc_namespac | 4149.82 | 15 | 276.65475260417 | 0.13853206897834 |
| query: SELECT cur_id,cur_title FROM cur USE INDEX (cur_random) WHERE c | 6847.99 | 26 | 263.38407076322 | 0.22860397608646 |
| query: SELECT MAX(rc_timestamp) AS lastmod FROM recentchanges | 1049.17 | 4 | 262.29357910156 | 0.035024228429732 |
| query: SELECT COUNT(*) AS n FROM watchlist WHERE wl_user=N | 1792.28 | 7 | 256.04068429129 | 0.059831231965801 |
| query: SELECT cur_id,cur_text FROM cur WHERE cur_namespace=N AND cur_t | 246.659 | 1 | 246.65852355957 | 0.0082341173799243 |
| Parser::replaceInternalLinks | 567532 | 2664 | 213.03739677177 | 18.94571470562 |
| query: UPDATE recentchanges SET rc_cur_time='X' WHERE rc_cur_id=N | 2433.16 | 12 | 202.76302083333 | 0.08122522537259 |
| query: DELETE FROM links WHERE l_from=N AND l_to IN(N) | 193.893 | 1 | 193.89347839355 | 0.0064726798703503 |
| query: DELETE FROM linkscc WHERE lcc_pageid='X' | 2309.71 | 12 | 192.47583007812 | 0.077104260000756 |
| Setup.php | 219353 | 1199 | 182.94643974145 | 7.322579095829 |
| query: DELETE FROM imagelinks WHERE il_from='X' | 2546.65 | 14 | 181.90384347098 | 0.085014075667764 |
| LinkCache::preFill | 107168 | 595 | 180.11397058824 | 3.5775465398081 |
| query: SELECT bl_from FROM brokenlinks WHERE bl_to='X' | 2444.36 | 14 | 174.59720284598 | 0.08159926437451 |
| query: INSERT INTO image (img_name,img_size,img_timestamp,img_descript | 167.137 | 1 | 167.13662719727 | 0.0055794650311144 |
| query: DELETE linkscc FROM linkscc,brokenlinks WHERE lcc_pageid=bl_fro | 166.751 | 1 | 166.75134277344 | 0.0055666032125781 |
| query: SELECT bl_to FROM brokenlinks WHERE bl_from='X' | 4350.68 | 28 | 155.38150460379 | 0.14523733790007 |
| Article::getContent | 89139.1 | 670 | 133.04341184701 | 2.9756997088782 |
| query: UPDATE LOW_PRIORITY site_stats SET ss_total_views=(ss_total_vie | 1855.86 | 14 | 132.56127929688 | 0.06195347175585 |
| Skin::doBeforeContent | 3497.32 | 27 | 129.53035481771 | 0.11674982693439 |
| query: SELECT user_id FROM user WHERE user_name='X' | 2906.89 | 23 | 126.38660198709 | 0.097039779217213 |
| query: INSERT IGNORE INTO categorylinks (cl_from,cl_to,cl_sortkey) VAL | 619.466 | 5 | 123.89318847656 | 0.020679420312891 |
| query: SELECT N FROM watchlist WHERE wl_user=N AND wl_namespace=N AND | 17602.1 | 147 | 119.74193505527 | 0.58760371522706 |
| query: INSERT INTO cur (cur_namespace,cur_title,cur_text,cur_comment,c | 117.989 | 1 | 117.98926544189 | 0.0039387954131858 |
| query: SELECT lcc_cacheobj FROM linkscc WHERE lcc_pageid = N | 66068.9 | 570 | 115.9102933114 | 2.2055544634326 |
| query: SELECT cur_touched,cur_is_redirect FROM cur WHERE cur_id=N | 39546.6 | 363 | 108.94391356749 | 1.3201720183381 |
| LinkCache::addLinkObj | 1.1166e+06 | 10574 | 105.59817713259 | 37.274914292109 |
| query: SELECT cur_id FROM cur WHERE cur_namespace=N AND cur_title='X' | 1.11246e+06 | 10574 | 105.20758464157 | 37.137039737632 |
| query: SELECT cur_user,cur_user_text,cur_timestamp,cur_comment,cur_min | 41541.9 | 406 | 102.3199565117 | 1.3867791598987 |
| query: SELECT cur_namespace,cur_title,cur_id FROM brokenlinks,cur WHER | 101.318 | 1 | 101.31832122803 | 0.0033822749673881 |
| query: DELETE FROM categorylinks WHERE cl_from='X' | 1394.86 | 14 | 99.633082798549 | 0.046564241186029 |
| query: SELECT cur_restrictions FROM cur WHERE (cur_id=N) | 37599.8 | 381 | 98.687120652887 | 1.2551810669165 |
| query: SELECT old_namespace,old_title,old_timestamp,old_text,old_flags | 187.694 | 2 | 93.84716796875 | 0.0062657360116853 |
| query: SELECT old_namespace,old_title,old_timestamp,old_text,old_flags | 554.68 | 6 | 92.446746826172 | 0.018516709346353 |
| query: SELECT cur_text,cur_timestamp,cur_user,cur_user_text,cur_commen | 64691.2 | 719 | 89.97385148644 | 2.159564243425 |
| Setup.php-MessageCache | 103530 | 1201 | 86.202871305162 | 3.4560949495459 |
| query: SELECT ss_total_views, ss_total_edits, ss_good_articles FROM si | 84965 | 1054 | 80.611998932638 | 2.8363591862276 |
| query: SELECT * FROM ipblocks WHERE (ipb_address='X' OR ipb_user=N) | 2657.16 | 35 | 75.918910435268 | 0.088703128438675 |
| query: DELETE FROM user_newtalk WHERE user_id=N | 138.236 | 2 | 69.117881774902 | 0.0046146773553425 |
| Skin::quickBar | 1781.63 | 26 | 68.524362417368 | 0.059475661007162 |
| Skin::doAfterContent-4 | 1784.17 | 27 | 66.080362955729 | 0.059560332014068 |
| query: SELECT old_namespace,old_title,old_timestamp,old_comment,old_mi | 58.592 | 1 | 58.591983795166 | 0.0019559562148093 |
| query: REPLACE INTO linkscc(lcc_pageid,lcc_cacheobj) VALUES(N, 'X') | 1557.45 | 28 | 55.623182024275 | 0.051991792094792 |
| query: SELECT iw_url,iw_local FROM interwiki WHERE iw_prefix='X' | 4724.31 | 90 | 52.492388237847 | 0.15771019466868 |
| Parser::replaceVariables | 295414 | 5677 | 52.036980359345 | 9.8617027376034 |
| Setup.php-misc | 58154.2 | 1200 | 48.461861979167 | 1.9413429751911 |
| Skin::makeLink | 129121 | 2729 | 47.314475311469 | 4.310409092802 |
| query: SELECT N FROM user_newtalk WHERE user_ip='X' | 47126.9 | 1042 | 45.227394733685 | 1.5732227447907 |
| query: SELECT cur_text, cur_user_text, cur_comment FROM cur WHERE cur_ | 172.254 | 4 | 43.063438415527 | 0.0057502883189189 |
| Parser::tidy | 28133.9 | 657 | 42.821828624429 | 0.93918577211879 |
| query: SELECT * FROM ipblocks WHERE ipb_user=N | 6119.51 | 159 | 38.487510441234 | 0.20428565441675 |
| query: SELECT cur_text,cur_timestamp,cur_user,cur_counter,cur_restrict | 20504.2 | 552 | 37.145245980525 | 0.68448390805615 |
| query: SELECT cur_text FROM cur WHERE cur_namespace=N AND cur_title='X | 42881.9 | 1237 | 34.666055098019 | 1.4315121837525 |
| Setup.php-User | 33685.1 | 1200 | 28.070950520833 | 1.1244995626454 |
| query: SELECT LENGTH(cur_text) AS x, cur_namespace, cur_is_redirect FR | 23143 | 839 | 27.583984375 | 0.77257363828587 |
| main-misc-setup | 32435.7 | 1199 | 27.052289668474 | 1.0827897558467 |
| query: SHOW COLUMNS FROM cur LIKE 'X'; | 30847.9 | 1162 | 26.54727167599 | 1.0297859174252 |
| query: SELECT img_name,img_size,img_timestamp,img_description,img_user | 24.5928 | 1 | 24.592832565308 | 0.00082097414322138 |
| query: INSERT IGNORE INTO brokenlinks (bl_from,bl_to) VALUES (N,'X') | 20.6013 | 1 | 20.601324081421 | 0.00068772697663259 |
| query: COMMIT | 35022.9 | 1927 | 18.174856885703 | 1.1691591707297 |
| Parser::doBlockLevels | 7823.72 | 657 | 11.908247716895 | 0.26117653509531 |
| Parser::replaceExternalLinks | 14341.8 | 1332 | 10.76709277637 | 0.4787663364301 |
| query: SELECT math_outputhash,math_html_conservativeness,math_html,mat | 593.409 | 56 | 10.596580505371 | 0.019809553876675 |
| query: INSERT IGNORE INTO links (l_from,l_to) VALUES (N,N),(N,N),(N,N) | 10.1024 | 1 | 10.102360725403 | 0.00033724366312934 |
| query: UPDATE user SET user_name= 'X' WHERE user_id=N | 17.1644 | 2 | 8.5822105407715 | 0.0005729940157926 |
| query: BEGIN | 12890.9 | 1927 | 6.6896249229696 | 0.43033276006614 |
| Setup.php-memcached | 7957.26 | 1201 | 6.6255309702852 | 0.26563458708238 |
| Setup.php-includes | 7776.53 | 1201 | 6.4750448031588 | 0.25960120937341 |
| query: INSERT IGNORE INTO imagelinks (il_from,il_to) VALUES (N,'X') | 12.5366 | 4 | 3.1341509819031 | 0.00041850517385688 |
| Setup.php-language | 2718.93 | 1201 | 2.2638851168948 | 0.090764980335214 |
| wfMsg | 106317 | 62344 | 1.7053262443058 | 3.5491394618165 |
| Setup.php-SetupSession | 2031.59 | 1201 | 1.6915820881687 | 0.06781987911941 |
| query: SELECT cur_namespace,cur_title,cur_timestamp,cur_comment,cur_mi | 1.38202 | 1 | 1.3820154666901 | 4.6135351048789e-05 |
| Parser::doAllQuotes | 1679.67 | 1332 | 1.2610137297942 | 0.056071860449334 |
| query: SELECT cur_namespace,cur_title,cur_timestamp,cur_comment,cur_mi | 1.15758 | 1 | 1.1575754880905 | 3.8642947778606e-05 |
| Parser::removeHTMLtags | 1530.95 | 1332 | 1.1493592591615 | 0.05110706605579 |
| Setup.php-OutputPage | 1075.58 | 1201 | 0.89557042308493 | 0.035905722968663 |
| Setup.php-DateFormatter | 699.087 | 1201 | 0.58208771133105 | 0.023337394321847 |
| query: REPLACE INTO watchlist (wl_user, wl_namespace,wl_title) VALUES | 0.548606 | 1 | 0.54860645532608 | 1.8313942219995e-05 |
| Setup.php-extensions | 574.428 | 1199 | 0.47908927402067 | 0.01917593536085 |
| query: SELECT cur_namespace,cur_title FROM cur WHERE cur_id=N LIMIT N | 1.34893 | 3 | 0.44964277744293 | 4.5030814525322e-05 |
| Title::secureAndSplit | 26540.4 | 82223 | 0.32278588507018 | 0.88598991820748 |
| Parser::doHeadings | 408.549 | 1332 | 0.30671852272194 | 0.013638454361711 |
| Skin::makeKnownLinkObj | 8644.56 | 33972 | 0.25446127969357 | 0.28857835168781 |
| Skin::makeBrokenLinkObj | 884.287 | 3750 | 0.23580986328125 | 0.029519850949922 |
| Skin::initPage | 228.93 | 1039 | 0.22033725184128 | 0.0076423056321999 |
| Title::newFromText | 10643.3 | 67958 | 0.15661580498249 | 0.35530155014881 |
| Setup.php-database | 184.874 | 1201 | 0.15393354811339 | 0.00617159208441 |
| Parser::replaceInternalLinks-setup | 263.633 | 2664 | 0.098961334686738 | 0.0088007703918338 |
| -overhead-total | 24469.6 | 356889 | 0.068563537306067 | 0.81685938666959 |
| Skin::doAfterContent-2 | 1.25356 | 27 | 0.046428313961735 | 4.1847315461432e-05 |
| -overhead-internal | 11902.3 | 356855 | 0.03335327023581 | 0.39732979621806 |
| Setup.php-BlockCache | 21.9101 | 1201 | 0.018243252883644 | 0.00073141895623464 |
| Parser::replaceInternalLinks-prefixhandling | -23.8646 | 26429 | -0.00090296874951503 | -0.00079666250460351 |
| Skin::doAfterContent-1 | -0.217717 | 27 | -0.0080635762876934 | -7.2679576720477e-06 |
+------------------------------------------------------------------------+-------------+--------+----------------------+----------------------+