Profiling/Live aggregate 20040927
Taken for a short time ending 08:25 UTC. A few memcached functions are included.
+------------------------------------------------------------------------+----------+-------+---------------------+---------------------+ | name | total | count | each | percent | +------------------------------------------------------------------------+----------+-------+---------------------+---------------------+ | -total | 50400.1 | 131 | 384.73351025763 | 100 | | Setup.php | 22243.6 | 131 | 169.79842557252 | 44.134035909379 | | Parser::parse | 20449.6 | 184 | 111.13920261549 | 40.574557197512 | | Article::view | 15893.4 | 87 | 182.6824375898 | 31.53441217979 | | Parser::internalParse | 13339.2 | 184 | 72.495775305707 | 26.466664439695 | | Setup.php-MessageCache | 10042.3 | 131 | 76.658933683206 | 19.92520319633 | | MessageCache::initialise | 10032.7 | 131 | 76.585199487118 | 19.906038191431 | | memcached::get | 9160.27 | 663 | 13.816390047606 | 18.175099746768 | | Setup.php-misc | 9043.82 | 131 | 69.036781369275 | 17.944052059059 | | Parser::replaceInternalLinks | 8939.13 | 368 | 24.291105850883 | 17.736331385198 | | OutputPage::output | 6543.35 | 122 | 53.634057216957 | 12.982824040105 | | Parser::tidy | 6521.16 | 184 | 35.441061268682 | 12.938777080863 | | MessageCache::load | 6207.49 | 131 | 47.385447727815 | 12.316433703964 | | MessageCache::load-fromcache | 6194.5 | 131 | 47.28623345062 | 12.290645912012 | | ParserOptions::initialiseFromUser | 5572.32 | 397 | 14.036071316121 | 11.056171387343 | | ParserOptions::initialiseFromUser-skin | 5348.07 | 397 | 13.471207395309 | 10.611229766688 | | DifferenceEngine::showDiffPage | 4061.65 | 2 | 2030.8245849609 | 8.0588133523447 | | MessageCache::initialise-parseropt | 3806.29 | 262 | 14.527814326396 | 7.5521439848934 | | wfMsg | 2852.79 | 6262 | 0.45557124071782 | 5.6602817935825 | | LinkCache::addLinkObj | 2793.56 | 1447 | 1.9305876314681 | 5.542768497824 | | query: SELECT cur_id,cur_namespace,cur_title,cur_text FROM cur,searchi | 2513.85 | 9 | 279.31689453125 | 4.9877927967483 | | Title::secureAndSplit | 2379.89 | 7113 | 0.33458334843552 | 4.7219982440507 | | query: SELECT cur_id FROM cur WHERE cur_namespace=N AND cur_title='X' | 2369.39 | 1447 | 1.637451171875 | 4.7011659166654 | | -overhead-total | 2104.83 | 36936 | 0.056985750584626 | 4.1762339910883 | | Parser::replaceVariables | 1625.62 | 523 | 3.1082574614603 | 3.2254280843218 | | Setup.php-includes | 1392.44 | 131 | 10.629295756799 | 2.7627683769165 | | memcached::_connect_sock | 1370.96 | 608 | 2.2548739784642 | 2.7201605853412 | | ParserCache::get | 1148.96 | 74 | 15.526518950591 | 2.2796832424421 | | Parser::replaceExternalLinks | 1104.84 | 184 | 6.0045776367188 | 2.1921434834372 | | -overhead-internal | 1067.08 | 36936 | 0.028889914469877 | 2.1172142434022 | | memcached::_set | 752.784 | 167 | 4.5076875058477 | 1.4936160149919 | | Title::newFromText | 724.526 | 5883 | 0.12315591451932 | 1.4375495110492 | | main-misc-setup | 566.01 | 131 | 4.320688029282 | 1.1230339739288 | | Skin::makeKnownLinkObj | 538.828 | 2778 | 0.19396262996226 | 1.0691016379249 | | Skin::makeLink | 484.556 | 188 | 2.5774269915642 | 0.9614194655531 | | query: BEGIN | 480.978 | 174 | 2.7642401333513 | 0.95431929723588 | | query: SELECT ss_total_views, ss_total_edits, ss_good_articles FROM si | 477.249 | 131 | 3.6431204526479 | 0.94692049315078 | | query: COMMIT | 468.765 | 174 | 2.6940491774987 | 0.93008674853165 | | Setup.php-extensions | 449.115 | 131 | 3.4283575392861 | 0.89109927986007 | | Setup.php-language | 446.264 | 131 | 3.4065931480349 | 0.88544227555165 | | Parser::doBlockLevels | 381.012 | 184 | 2.0707175213358 | 0.75597489033649 | | query: SELECT cur_touched,cur_is_redirect FROM cur WHERE cur_id=N | 353.433 | 124 | 2.8502627957252 | 0.70125388221654 | | query: SHOW COLUMNS FROM cur LIKE 'X'; | 348.694 | 126 | 2.7674151223803 | 0.69185254728899 | | query: SELECT cur_text FROM cur WHERE cur_namespace='X' LIMIT N | 326.094 | 131 | 2.4892636364653 | 0.64700983150607 | | Article::getContent | 325.158 | 51 | 6.3756498448989 | 0.64515389376864 | | Parser::removeHTMLtags | 299.808 | 232 | 1.2922765797582 | 0.59485641282261 | | query: SELECT cur_id,cur_namespace,cur_title,cur_text FROM cur,searchi | 294.739 | 18 | 16.374413384332 | 0.58479943554013 | | LinkCache::preFill | 255.764 | 46 | 5.560080818508 | 0.50746678913527 | | query: SELECT LENGTH(cur_text) AS x, cur_namespace, cur_is_redirect FR | 240.401 | 93 | 2.58495929677 | 0.47698568662258 | | Setup.php-SetupSession | 234.129 | 131 | 1.7872463546636 | 0.46454137916576 | | query: SELECT lcc_cacheobj FROM linkscc WHERE lcc_pageid = N | 228.364 | 40 | 5.7090953826904 | 0.45310200044403 | | query: SELECT N FROM user_newtalk WHERE user_ip='X' | 227.871 | 119 | 1.91488173028 | 0.45212404702008 | | Setup.php-User | 218.504 | 131 | 1.6679686335207 | 0.43353869342022 | | query: SELECT cur_text,cur_timestamp,cur_user,cur_user_text,cur_commen | 196.649 | 56 | 3.5115863255092 | 0.39017556285746 | | Setup.php-OutputPage | 146.437 | 131 | 1.1178369886093 | 0.29054838188145 | | query: SELECT cur_text,cur_timestamp,cur_user,cur_counter,cur_restrict | 126.87 | 36 | 3.5241574181451 | 0.25172508113883 | | Setup.php-DateFormatter | 93.3423 | 131 | 0.712536411431 | 0.18520258631848 | | query: SELECT cur_user,cur_user_text,cur_timestamp,cur_comment,cur_min | 88.0527 | 41 | 2.147625806855 | 0.17470734348696 | | Parser::doAllQuotes | 78.4393 | 184 | 0.42630033907683 | 0.15563317968939 | | Skin::initPage | 68.6011 | 96 | 0.71459436416626 | 0.13611296958525 | | query: SELECT cur_restrictions FROM cur WHERE (cur_id=N) | 57.6924 | 38 | 1.5182211022628 | 0.1144688473073 | | Setup.php-memcached | 54.4962 | 131 | 0.41600185132209 | 0.1081272725746 | | Parser::doHeadings | 42.9342 | 184 | 0.23333810723346 | 0.085186776182466 | | PageHistory::history | 36.9642 | 1 | 36.964183807373 | 0.073341503798841 | | query: SELECT old_id,old_user,old_comment,old_user_text,old_timestamp, | 32.5384 | 1 | 32.538421630859 | 0.064560245292687 | | query: SELECT DISTINCT cur_title,cur_namespace,cl_sortkey FROM cur,cat | 28.6251 | 3 | 9.5417003631592 | 0.056795734250119 | | query: SELECT N FROM watchlist WHERE wl_user=N AND wl_namespace=N AND | 28.3628 | 10 | 2.8362762451172 | 0.05627522200675 | | Parser::replaceInternalLinks-setup | 26.2208 | 368 | 0.07125226829363 | 0.052025372997043 | | Skin::makeBrokenLinkObj | 19.3462 | 132 | 0.14656215725523 | 0.038385258474077 | | Setup.php-database | 15.2411 | 131 | 0.11634425534547 | 0.030240218812123 | | query: SELECT iw_url,iw_local FROM interwiki WHERE iw_prefix='X' | 10.5018 | 10 | 1.0501803398132 | 0.020836874360125 | | query: SELECT * FROM ipblocks WHERE ipb_user=N | 9.37169 | 12 | 0.78097446759542 | 0.018594597033853 | | query: SELECT cur_id,cur_title FROM cur USE INDEX (cur_random) WHERE c | 7.84227 | 1 | 7.8422737121582 | 0.015560039151658 | | query: SELECT cur_text, cur_user_text, cur_comment FROM cur WHERE cur_ | 6.72417 | 2 | 3.3620846271515 | 0.013341581880408 | | query: SELECT COUNT(*) AS n FROM archive WHERE ar_namespace=N AND ar_t | 5.25237 | 1 | 5.2523674964905 | 0.010421345503101 | | query: SELECT user_name,user_password,user_newpassword,user_email,user | 4.97444 | 2 | 2.4872212409973 | 0.0098699079652762 | | query: SELECT user_id FROM user WHERE user_name='X' | 4.80891 | 2 | 2.4044544696808 | 0.0095414689820397 | | query: SELECT N FROM user_newtalk WHERE user_id=N | 3.7864 | 2 | 1.8932013511658 | 0.0075126903822396 | | query: SELECT old_namespace,old_title,old_timestamp,old_text,old_flags | 2.7074 | 1 | 2.7073972225189 | 0.0053718103100855 | | query: SELECT old_namespace,old_title,old_timestamp,old_text,old_flags | 2.47897 | 1 | 2.478972196579 | 0.0049185868601907 | | Setup.php-BlockCache | 2.14262 | 131 | 0.016355898544079 | 0.0042512279559755 | | query: SELECT recentchanges.* FROM recentchanges WHERE rc_timestamp > | 1.87272 | 1 | 1.8727209568024 | 0.0037157095604555 | | query: SELECT cur_id,cur_namespace,cur_title,cur_user,cur_comment,cur_ | 1.72482 | 1 | 1.7248177528381 | 0.003422251345554 | | query: SELECT cur_text FROM cur WHERE cur_namespace=N AND cur_title='X | 1.68175 | 1 | 1.681747674942 | 0.0033367949941275 | | query: SELECT * FROM ipblocks WHERE (ipb_address='X' OR ipb_user=N) | 1.59857 | 2 | 0.79928302764893 | 0.0031717523922154 | | Parser::replaceInternalLinks-prefixhandling | 1.0839 | 2202 | 0.00049223599923296 | 0.0021505986867708 | | query: UPDATE cur SET cur_text='X' | 0.65933 | 1 | 0.65933042764664 | 0.0013081929609465 | | query: SELECT MAX(rc_timestamp) AS lastmod FROM recentchanges | 0.637713 | 1 | 0.63771265745163 | 0.0012653006362264 | | query: INSERT INTO recentchanges (rc_timestamp,rc_cur_time,rc_namespac | 0.547512 | 1 | 0.547512114048 | 0.001086331623109 | | query: INSERT INTO old (old_namespace,old_title,old_text,old_comment,o | 0.509604 | 1 | 0.50960355997086 | 0.0010111163721151 | | query: UPDATE recentchanges SET rc_cur_time='X' WHERE rc_cur_id=N | 0.433548 | 1 | 0.43354803323746 | 0.00086021281823413 | | query: SELECT cur_namespace,cur_title FROM cur WHERE cur_id='X' LIMIT | 0.421201 | 1 | 0.42120134830475 | 0.00083571547116395 | | query: DELETE FROM linkscc WHERE lcc_pageid='X' | 0.414475 | 1 | 0.41447454690933 | 0.00082236866679064 | | query: SELECT cur_id,cur_namespace,cur_title FROM cur,links WHERE cur_ | 0.407322 | 1 | 0.40732198953629 | 0.00080817710999933 | | query: UPDATE recentchanges SET rc_this_oldid=N WHERE rc_namespace=N A | 0.398262 | 1 | 0.39826208353043 | 0.00079020113806367 | | query: REPLACE INTO linkscc(lcc_pageid,lcc_cacheobj) VALUES(N, 'X') | 0.37442 | 1 | 0.37442022562027 | 0.00074289594875931 |+------------------------------------------------------------------------+----------+-------+---------------------+---------------------+ | name | total | count | each | percent | +------------------------------------------------------------------------+----------+-------+---------------------+---------------------+ | -total | 50400.1 | 131 | 384.73351025763 | 100 | | Setup.php | 22243.6 | 131 | 169.79842557252 | 44.134035909379 | | Parser::parse | 20449.6 | 184 | 111.13920261549 | 40.574557197512 | | Article::view | 15893.4 | 87 | 182.6824375898 | 31.53441217979 | | Parser::internalParse | 13339.2 | 184 | 72.495775305707 | 26.466664439695 | | Setup.php-MessageCache | 10042.3 | 131 | 76.658933683206 | 19.92520319633 | | MessageCache::initialise | 10032.7 | 131 | 76.585199487118 | 19.906038191431 | | memcached::get | 9160.27 | 663 | 13.816390047606 | 18.175099746768 | | Setup.php-misc | 9043.82 | 131 | 69.036781369275 | 17.944052059059 | | Parser::replaceInternalLinks | 8939.13 | 368 | 24.291105850883 | 17.736331385198 | | OutputPage::output | 6543.35 | 122 | 53.634057216957 | 12.982824040105 | | Parser::tidy | 6521.16 | 184 | 35.441061268682 | 12.938777080863 | | MessageCache::load | 6207.49 | 131 | 47.385447727815 | 12.316433703964 | | MessageCache::load-fromcache | 6194.5 | 131 | 47.28623345062 | 12.290645912012 | | ParserOptions::initialiseFromUser | 5572.32 | 397 | 14.036071316121 | 11.056171387343 | | ParserOptions::initialiseFromUser-skin | 5348.07 | 397 | 13.471207395309 | 10.611229766688 | | DifferenceEngine::showDiffPage | 4061.65 | 2 | 2030.8245849609 | 8.0588133523447 | | MessageCache::initialise-parseropt | 3806.29 | 262 | 14.527814326396 | 7.5521439848934 | | wfMsg | 2852.79 | 6262 | 0.45557124071782 | 5.6602817935825 | | LinkCache::addLinkObj | 2793.56 | 1447 | 1.9305876314681 | 5.542768497824 | | query: SELECT cur_id,cur_namespace,cur_title,cur_text FROM cur,searchi | 2513.85 | 9 | 279.31689453125 | 4.9877927967483 | | Title::secureAndSplit | 2379.89 | 7113 | 0.33458334843552 | 4.7219982440507 | | query: SELECT cur_id FROM cur WHERE cur_namespace=N AND cur_title='X' | 2369.39 | 1447 | 1.637451171875 | 4.7011659166654 | | -overhead-total | 2104.83 | 36936 | 0.056985750584626 | 4.1762339910883 | | Parser::replaceVariables | 1625.62 | 523 | 3.1082574614603 | 3.2254280843218 | | Setup.php-includes | 1392.44 | 131 | 10.629295756799 | 2.7627683769165 | | memcached::_connect_sock | 1370.96 | 608 | 2.2548739784642 | 2.7201605853412 | | ParserCache::get | 1148.96 | 74 | 15.526518950591 | 2.2796832424421 | | Parser::replaceExternalLinks | 1104.84 | 184 | 6.0045776367188 | 2.1921434834372 | | -overhead-internal | 1067.08 | 36936 | 0.028889914469877 | 2.1172142434022 | | memcached::_set | 752.784 | 167 | 4.5076875058477 | 1.4936160149919 | | Title::newFromText | 724.526 | 5883 | 0.12315591451932 | 1.4375495110492 | | main-misc-setup | 566.01 | 131 | 4.320688029282 | 1.1230339739288 | | Skin::makeKnownLinkObj | 538.828 | 2778 | 0.19396262996226 | 1.0691016379249 | | Skin::makeLink | 484.556 | 188 | 2.5774269915642 | 0.9614194655531 | | query: BEGIN | 480.978 | 174 | 2.7642401333513 | 0.95431929723588 | | query: SELECT ss_total_views, ss_total_edits, ss_good_articles FROM si | 477.249 | 131 | 3.6431204526479 | 0.94692049315078 | | query: COMMIT | 468.765 | 174 | 2.6940491774987 | 0.93008674853165 | | Setup.php-extensions | 449.115 | 131 | 3.4283575392861 | 0.89109927986007 | | Setup.php-language | 446.264 | 131 | 3.4065931480349 | 0.88544227555165 | | Parser::doBlockLevels | 381.012 | 184 | 2.0707175213358 | 0.75597489033649 | | query: SELECT cur_touched,cur_is_redirect FROM cur WHERE cur_id=N | 353.433 | 124 | 2.8502627957252 | 0.70125388221654 | | query: SHOW COLUMNS FROM cur LIKE 'X'; | 348.694 | 126 | 2.7674151223803 | 0.69185254728899 | | query: SELECT cur_text FROM cur WHERE cur_namespace='X' LIMIT N | 326.094 | 131 | 2.4892636364653 | 0.64700983150607 | | Article::getContent | 325.158 | 51 | 6.3756498448989 | 0.64515389376864 | | Parser::removeHTMLtags | 299.808 | 232 | 1.2922765797582 | 0.59485641282261 | | query: SELECT cur_id,cur_namespace,cur_title,cur_text FROM cur,searchi | 294.739 | 18 | 16.374413384332 | 0.58479943554013 | | LinkCache::preFill | 255.764 | 46 | 5.560080818508 | 0.50746678913527 | | query: SELECT LENGTH(cur_text) AS x, cur_namespace, cur_is_redirect FR | 240.401 | 93 | 2.58495929677 | 0.47698568662258 | | Setup.php-SetupSession | 234.129 | 131 | 1.7872463546636 | 0.46454137916576 | | query: SELECT lcc_cacheobj FROM linkscc WHERE lcc_pageid = N | 228.364 | 40 | 5.7090953826904 | 0.45310200044403 | | query: SELECT N FROM user_newtalk WHERE user_ip='X' | 227.871 | 119 | 1.91488173028 | 0.45212404702008 | | Setup.php-User | 218.504 | 131 | 1.6679686335207 | 0.43353869342022 | | query: SELECT cur_text,cur_timestamp,cur_user,cur_user_text,cur_commen | 196.649 | 56 | 3.5115863255092 | 0.39017556285746 | | Setup.php-OutputPage | 146.437 | 131 | 1.1178369886093 | 0.29054838188145 | | query: SELECT cur_text,cur_timestamp,cur_user,cur_counter,cur_restrict | 126.87 | 36 | 3.5241574181451 | 0.25172508113883 | | Setup.php-DateFormatter | 93.3423 | 131 | 0.712536411431 | 0.18520258631848 | | query: SELECT cur_user,cur_user_text,cur_timestamp,cur_comment,cur_min | 88.0527 | 41 | 2.147625806855 | 0.17470734348696 | | Parser::doAllQuotes | 78.4393 | 184 | 0.42630033907683 | 0.15563317968939 | | Skin::initPage | 68.6011 | 96 | 0.71459436416626 | 0.13611296958525 | | query: SELECT cur_restrictions FROM cur WHERE (cur_id=N) | 57.6924 | 38 | 1.5182211022628 | 0.1144688473073 | | Setup.php-memcached | 54.4962 | 131 | 0.41600185132209 | 0.1081272725746 | | Parser::doHeadings | 42.9342 | 184 | 0.23333810723346 | 0.085186776182466 | | PageHistory::history | 36.9642 | 1 | 36.964183807373 | 0.073341503798841 | | query: SELECT old_id,old_user,old_comment,old_user_text,old_timestamp, | 32.5384 | 1 | 32.538421630859 | 0.064560245292687 | | query: SELECT DISTINCT cur_title,cur_namespace,cl_sortkey FROM cur,cat | 28.6251 | 3 | 9.5417003631592 | 0.056795734250119 | | query: SELECT N FROM watchlist WHERE wl_user=N AND wl_namespace=N AND | 28.3628 | 10 | 2.8362762451172 | 0.05627522200675 | | Parser::replaceInternalLinks-setup | 26.2208 | 368 | 0.07125226829363 | 0.052025372997043 | | Skin::makeBrokenLinkObj | 19.3462 | 132 | 0.14656215725523 | 0.038385258474077 | | Setup.php-database | 15.2411 | 131 | 0.11634425534547 | 0.030240218812123 | | query: SELECT iw_url,iw_local FROM interwiki WHERE iw_prefix='X' | 10.5018 | 10 | 1.0501803398132 | 0.020836874360125 | | query: SELECT * FROM ipblocks WHERE ipb_user=N | 9.37169 | 12 | 0.78097446759542 | 0.018594597033853 | | query: SELECT cur_id,cur_title FROM cur USE INDEX (cur_random) WHERE c | 7.84227 | 1 | 7.8422737121582 | 0.015560039151658 | | query: SELECT cur_text, cur_user_text, cur_comment FROM cur WHERE cur_ | 6.72417 | 2 | 3.3620846271515 | 0.013341581880408 | | query: SELECT COUNT(*) AS n FROM archive WHERE ar_namespace=N AND ar_t | 5.25237 | 1 | 5.2523674964905 | 0.010421345503101 | | query: SELECT user_name,user_password,user_newpassword,user_email,user | 4.97444 | 2 | 2.4872212409973 | 0.0098699079652762 | | query: SELECT user_id FROM user WHERE user_name='X' | 4.80891 | 2 | 2.4044544696808 | 0.0095414689820397 | | query: SELECT N FROM user_newtalk WHERE user_id=N | 3.7864 | 2 | 1.8932013511658 | 0.0075126903822396 | | query: SELECT old_namespace,old_title,old_timestamp,old_text,old_flags | 2.7074 | 1 | 2.7073972225189 | 0.0053718103100855 | | query: SELECT old_namespace,old_title,old_timestamp,old_text,old_flags | 2.47897 | 1 | 2.478972196579 | 0.0049185868601907 | | Setup.php-BlockCache | 2.14262 | 131 | 0.016355898544079 | 0.0042512279559755 | | query: SELECT recentchanges.* FROM recentchanges WHERE rc_timestamp > | 1.87272 | 1 | 1.8727209568024 | 0.0037157095604555 | | query: SELECT cur_id,cur_namespace,cur_title,cur_user,cur_comment,cur_ | 1.72482 | 1 | 1.7248177528381 | 0.003422251345554 | | query: SELECT cur_text FROM cur WHERE cur_namespace=N AND cur_title='X | 1.68175 | 1 | 1.681747674942 | 0.0033367949941275 | | query: SELECT * FROM ipblocks WHERE (ipb_address='X' OR ipb_user=N) | 1.59857 | 2 | 0.79928302764893 | 0.0031717523922154 | | Parser::replaceInternalLinks-prefixhandling | 1.0839 | 2202 | 0.00049223599923296 | 0.0021505986867708 | | query: UPDATE cur SET cur_text='X' | 0.65933 | 1 | 0.65933042764664 | 0.0013081929609465 | | query: SELECT MAX(rc_timestamp) AS lastmod FROM recentchanges | 0.637713 | 1 | 0.63771265745163 | 0.0012653006362264 | | query: INSERT INTO recentchanges (rc_timestamp,rc_cur_time,rc_namespac | 0.547512 | 1 | 0.547512114048 | 0.001086331623109 | | query: INSERT INTO old (old_namespace,old_title,old_text,old_comment,o | 0.509604 | 1 | 0.50960355997086 | 0.0010111163721151 | | query: UPDATE recentchanges SET rc_cur_time='X' WHERE rc_cur_id=N | 0.433548 | 1 | 0.43354803323746 | 0.00086021281823413 | | query: SELECT cur_namespace,cur_title FROM cur WHERE cur_id='X' LIMIT | 0.421201 | 1 | 0.42120134830475 | 0.00083571547116395 | | query: DELETE FROM linkscc WHERE lcc_pageid='X' | 0.414475 | 1 | 0.41447454690933 | 0.00082236866679064 | | query: SELECT cur_id,cur_namespace,cur_title FROM cur,links WHERE cur_ | 0.407322 | 1 | 0.40732198953629 | 0.00080817710999933 | | query: UPDATE recentchanges SET rc_this_oldid=N WHERE rc_namespace=N A | 0.398262 | 1 | 0.39826208353043 | 0.00079020113806367 | | query: REPLACE INTO linkscc(lcc_pageid,lcc_cacheobj) VALUES(N, 'X') | 0.37442 | 1 | 0.37442022562027 | 0.00074289594875931 | | query: SELECT bl_to FROM brokenlinks WHERE bl_from='X' | 0.357493 | 1 | 0.35749250650406 | 0.00070930926435321 | +------------------------------------------------------------------------+----------+-------+---------------------+---------------------+ | query: SELECT bl_to FROM brokenlinks WHERE bl_from='X' | 0.357493 | 1 | 0.35749250650406 | 0.00070930926435321 | +------------------------------------------------------------------------+----------+-------+---------------------+---------------------+