mediawiki数据库研究@新建页面

来自个人维基
跳转至： 导航、 搜索

SET /* DatabaseMysql::open */ NAMES binary

SET /* DatabaseMysql::open */ sql_mode =

BEGIN /* DatabaseBase::query (LCStore_DB::get) */

SELECT /* LCStore_DB::get */ lc_value FROM `l10n_cache` WHERE lc_lang = 'zh-cn' AND lc_key = 'deps' LIMIT 1

SELECT /* LCStore_DB::get */ lc_value FROM `l10n_cache` WHERE lc_lang = 'zh-cn' AND lc_key = 'list' LIMIT 1

SELECT /* LCStore_DB::get */ lc_value FROM `l10n_cache` WHERE lc_lang = 'zh-cn' AND lc_key = 'preload' LIMIT 1

SELECT /* LCStore_DB::get */ lc_value FROM `l10n_cache` WHERE lc_lang = 'zh-cn' AND lc_key = 'preload' LIMIT 1

SELECT /* LCStore_DB::get */ lc_value FROM `l10n_cache` WHERE lc_lang = 'zh-cn' AND lc_key = 'fallback' LIMIT 1

SELECT /* LinkCache::addLinkObj */ page_id,page_len,page_is_redirect,page_latest,page_content_model FROM `page` WHERE page_namespace = '0' AND page_title = 'Aabb' LIMIT 1

SET /* DatabaseMysql::open 0:0:0:0:0:0:0:1 */ NAMES binary

SET /* DatabaseMysql::open 0:0:0:0:0:0:0:1 */ sql_mode =

SELECT /* SqlBagOStuff::getMulti 0:0:0:0:0:0:0:1 */ keyname,value,exptime FROM `objectcache` WHERE keyname = 'my_wiki:messages:zh-cn'

SELECT /* LCStore_DB::get 0:0:0:0:0:0:0:1 */ lc_value FROM `l10n_cache` WHERE lc_lang = 'zh-cn' AND lc_key = 'messages:ellipsis' LIMIT 1

SELECT /* Title::getTitleProtection 0:0:0:0:0:0:0:1 */ pt_user,pt_reason,pt_expiry,pt_create_perm FROM `protected_titles` WHERE pt_namespace = '0' AND pt_title = 'Aabb'

SELECT /* Title::getCascadeProtectionSources 0:0:0:0:0:0:0:1 */ pr_page,page_namespace,page_title,pr_expiry,pr_type,pr_level FROM `templatelinks`,`page_restrictions`,`page` WHERE tl_namespace = '0' AND tl_title = 'Aabb' AND (tl_from=pr_page) AND pr_cascade = '1' AND (page_id=pr_page)

SELECT /* Block::newLoad 0:0:0:0:0:0:0:1 */ ipb_id,ipb_address,ipb_by,ipb_by_text,ipb_reason,ipb_timestamp,ipb_auto,ipb_anon_only,ipb_create_account,ipb_enable_autoblock,ipb_expiry,ipb_deleted,ipb_block_email,ipb_allow_usertalk,ipb_parent_block_id FROM `ipblocks` WHERE ipb_address IN ('0:0:0:0:0:0:0:1','0:0:0:0:0:0:0:1') OR ((ipb_range_start LIKE 'v6-0000%' ) AND (ipb_range_start <= 'v6-00000000000000000000000000000001') AND (ipb_range_end >= 'v6-00000000000000000000000000000001'))

SELECT /* Title::isDeletedQuick 0:0:0:0:0:0:0:1 */ 1 FROM `archive` WHERE ar_namespace = '0' AND ar_title = 'Aabb' LIMIT 1

SELECT /* WikiPage::pageData 0:0:0:0:0:0:0:1 */ page_id,page_namespace,page_title,page_restrictions,page_counter,page_is_redirect,page_is_new,page_random,page_touched,page_latest,page_len,page_content_model FROM `page` WHERE page_namespace = '0' AND page_title = 'Aabb' LIMIT 1

SELECT /* LCStore_DB::get 0:0:0:0:0:0:0:1 */ lc_value FROM `l10n_cache` WHERE lc_lang = 'zh-cn' AND lc_key = 'magicWords' LIMIT 1

SELECT /* LCStore_DB::get 0:0:0:0:0:0:0:1 */ lc_value FROM `l10n_cache` WHERE lc_lang = 'zh-cn' AND lc_key = 'messages:autosumm-new' LIMIT 1

SELECT /* LCStore_DB::get 0:0:0:0:0:0:0:1 */ lc_value FROM `l10n_cache` WHERE lc_lang = 'zh-cn' AND lc_key = 'messages:timezone-cet' LIMIT 1

SELECT /* LCStore_DB::get 0:0:0:0:0:0:0:1 */ lc_value FROM `l10n_cache` WHERE lc_lang = 'zh-cn' AND lc_key = 'defaultDateFormat' LIMIT 1

SELECT /* LCStore_DB::get 0:0:0:0:0:0:0:1 */ lc_value FROM `l10n_cache` WHERE lc_lang = 'zh-cn' AND lc_key = 'digitTransformTable' LIMIT 1

SELECT /* LCStore_DB::get 0:0:0:0:0:0:0:1 */ lc_value FROM `l10n_cache` WHERE lc_lang = 'zh-cn' AND lc_key = 'messages:tue' LIMIT 1

SELECT /* LCStore_DB::get 0:0:0:0:0:0:0:1 */ lc_value FROM `l10n_cache` WHERE lc_lang = 'zh-cn' AND lc_key = 'messages:signature-anon' LIMIT 1

SELECT /* LCStore_DB::get 0:0:0:0:0:0:0:1 */ lc_value FROM `l10n_cache` WHERE lc_lang = 'zh-cn' AND lc_key = 'specialPageAliases' LIMIT 1

SELECT /* LCStore_DB::get 0:0:0:0:0:0:0:1 */ lc_value FROM `l10n_cache` WHERE lc_lang = 'zh-cn' AND lc_key = 'namespaceGenderAliases' LIMIT 1

SELECT /* LCStore_DB::get 0:0:0:0:0:0:0:1 */ lc_value FROM `l10n_cache` WHERE lc_lang = 'zh-cn' AND lc_key = 'linkPrefixExtension' LIMIT 1

COMMIT /* WikiPage::doEditContent 0:0:0:0:0:0:0:1 */

BEGIN /* WikiPage::doEditContent 0:0:0:0:0:0:0:1 */

INSERT /* WikiPage::insertOn 0:0:0:0:0:0:0:1 */ IGNORE INTO `page` (page_id,page_namespace,page_title,page_counter,page_restrictions,page_is_redirect,page_is_new,page_random,page_touched,page_latest,page_len) VALUES (NULL,'0','Aabb','0',,'0','1','0.552895636766','20140218030024','0','0')

INSERT /* Revision::insertOn 0:0:0:0:0:0:0:1 */ INTO `text` (old_id,old_text,old_flags) VALUES (NULL,'aaabbb','utf-8')

SELECT /* Revision::getPreviousRevisionId 0:0:0:0:0:0:0:1 */ page_latest FROM `page` WHERE page_id = '2' LIMIT 1

INSERT /* Revision::insertOn 0:0:0:0:0:0:0:1 */ INTO `revision` (rev_id,rev_page,rev_text_id,rev_comment,rev_minor_edit,rev_user,rev_user_text,rev_timestamp,rev_deleted,rev_len,rev_parent_id,rev_sha1,rev_content_model,rev_content_format) VALUES (NULL,'2','3','以“aaabbb”为内容创建页面','0','0','0:0:0:0:0:0:0:1','20140218025937','0','6','0','c8w7iygcfefljgnewsjer80pt1csh20',NULL,NULL)

UPDATE /* WikiPage::updateRevisionOn 0:0:0:0:0:0:0:1 */ `page` SET page_latest = '3',page_touched = '20140218030117',page_is_new = '1',page_is_redirect = '0',page_len = '6',page_content_model = 'wikitext' WHERE page_id = '2' AND page_latest = '0'

DELETE /* WikiPage::updateRedirectOn 0:0:0:0:0:0:0:1 */ FROM `redirect` WHERE rd_from = '2'

SELECT /* LCStore_DB::get 0:0:0:0:0:0:0:1 */ lc_value FROM `l10n_cache` WHERE lc_lang = 'zh-cn' AND lc_key = 'messages:group-bot' LIMIT 1

SELECT /* LCStore_DB::get 0:0:0:0:0:0:0:1 */ lc_value FROM `l10n_cache` WHERE lc_lang = 'zh-cn' AND lc_key = 'messages:grouppage-bot' LIMIT 1

SELECT /* LCStore_DB::get 0:0:0:0:0:0:0:1 */ lc_value FROM `l10n_cache` WHERE lc_lang = 'zh-cn' AND lc_key = 'namespaceAliases' LIMIT 1

SELECT /* LCStore_DB::get 0:0:0:0:0:0:0:1 */ lc_value FROM `l10n_cache` WHERE lc_lang = 'zh-cn' AND lc_key = 'messages:group-sysop' LIMIT 1

SELECT /* LCStore_DB::get 0:0:0:0:0:0:0:1 */ lc_value FROM `l10n_cache` WHERE lc_lang = 'zh-cn' AND lc_key = 'messages:grouppage-sysop' LIMIT 1

SELECT /* LCStore_DB::get 0:0:0:0:0:0:0:1 */ lc_value FROM `l10n_cache` WHERE lc_lang = 'zh-cn' AND lc_key = 'messages:comma-separator' LIMIT 1

SELECT /* Title::loadRestrictions 0:0:0:0:0:0:0:1 */ pr_type,pr_expiry,pr_level,pr_cascade FROM `page_restrictions` WHERE pr_page = '2'

SELECT /* Title::loadRestrictionsFromRows 0:0:0:0:0:0:0:1 */ page_restrictions FROM `page` WHERE page_id = '2' LIMIT 1

INSERT /* RecentChange::save 0:0:0:0:0:0:0:1 */ INTO `recentchanges` (rc_timestamp,rc_cur_time,rc_namespace,rc_title,rc_type,rc_minor,rc_cur_id,rc_user,rc_user_text,rc_comment,rc_this_oldid,rc_last_oldid,rc_bot,rc_ip,rc_patrolled,rc_new,rc_old_len,rc_new_len,rc_deleted,rc_logid,rc_log_type,rc_log_action,rc_params,rc_id) VALUES ('20140218025937','20140218025937','0','Aabb','1','0','2','0','0:0:0:0:0:0:0:1','以“aaabbb”为内容创建页面','3','0','0','::1','0','1','0','6','0','0',NULL,,,NULL)

SELECT /* EmailNotification::notifyOnPageChange 0:0:0:0:0:0:0:1 */ wl_user FROM `watchlist` WHERE (wl_user != 0) AND wl_namespace = '0' AND wl_title = 'Aabb' AND (wl_notificationtimestamp IS NULL)

COMMIT /* WikiPage::doEditContent 0:0:0:0:0:0:0:1 */

BEGIN /* SqlBagOStuff::set 0:0:0:0:0:0:0:1 */

REPLACE /* SqlBagOStuff::set 0:0:0:0:0:0:0:1 */ INTO `objectcache` (keyname,value,exptime) VALUES ('my_wiki:pcache:idhash:2-0!*!*!*!*!*!*','uT?n\Z1�??~????H?�I0Q???�)�$h?X??t??-?@?H?~c????�Rx`u??0g?x?4Nh8a?�WNW.?i??X?a9??�{????7?16?σ?�}�??Z$x???�?�?�??`????Ze???�\'Rq ????$????s(?A?a????XY???�Xi&9�2+*/??�P�]$Q?*?$d?v`?�???�3yU?t??\rD?\0?H]?\n% �?�?c;\n?W\Z<?�D?�\"?+?9Tm??????\r6?\'??v?e� ??-?�?\\?x�KAu?S?�?.h??>?} ?s??m?R?$??Q�_Gi?v?�?�7�??z�??+???K�?�????b????\\��M\"?\nW?n???_)>^b??B?~;?&?4?!o0W?�???????E�S`&[?5N????�#Yq?�?p(=??{?�?�??9?z?3�??�\n\r=?/?(??�?�0>tP6?c?#ū�?????�?\\????Ξ\Z?�M�繹}�??�????�2?B???|υ?R3?�??4?m?51J?q�??S?q0�=`�?,??>*?�?�?�c??W?&>6�???�~]�V�U?l?(?F\'?�o>?D??�???$gf?9?U??@&?\'�0P???�?n???u(?\\|~y??[???D?\'???W??N??��c?(F???cB?q?G,�?&a??\0','20140219030354')

COMMIT /* SqlBagOStuff::set 0:0:0:0:0:0:0:1 */

BEGIN /* SqlBagOStuff::set 0:0:0:0:0:0:0:1 */

REPLACE /* SqlBagOStuff::set 0:0:0:0:0:0:0:1 */ INTO `objectcache` (keyname,value,exptime) VALUES ('my_wiki:pcache:idoptions:2','E??�?0�D?e??lKA?�\rG?z???&R�?AC?w?�?m2?M?ё??g??�?*Z?\Z??�f?1???*???0???�C?Q�??�?????k?�?�?LMm�3;d6??s�?????�?;?>?J???�? i?/','20140219030527')

COMMIT /* SqlBagOStuff::set 0:0:0:0:0:0:0:1 */

BEGIN /* DatabaseBase::query (LinksUpdate::getExistingLinks) 0:0:0:0:0:0:0:1 */

SELECT /* LinksUpdate::getExistingLinks 0:0:0:0:0:0:0:1 */ pl_namespace,pl_title FROM `pagelinks` WHERE pl_from = '2' FOR UPDATE

SELECT /* LinksUpdate::getExistingImages 0:0:0:0:0:0:0:1 */ il_to FROM `imagelinks` WHERE il_from = '2' FOR UPDATE

SELECT /* LinksUpdate::getExistingExternals 0:0:0:0:0:0:0:1 */ el_to FROM `externallinks` WHERE el_from = '2' FOR UPDATE

SELECT /* LinksUpdate::getExistingInterlangs 0:0:0:0:0:0:0:1 */ ll_lang,ll_title FROM `langlinks` WHERE ll_from = '2' FOR UPDATE

SELECT /* LinksUpdate::getExistingInterwikis 0:0:0:0:0:0:0:1 */ iwl_prefix,iwl_title FROM `iwlinks` WHERE iwl_from = '2' FOR UPDATE

SELECT /* LinksUpdate::getExistingTemplates 0:0:0:0:0:0:0:1 */ tl_namespace,tl_title FROM `templatelinks` WHERE tl_from = '2' FOR UPDATE

SELECT /* LinksUpdate::getExistingCategories 0:0:0:0:0:0:0:1 */ cl_to,cl_sortkey_prefix FROM `categorylinks` WHERE cl_from = '2' FOR UPDATE

SELECT /* LinksUpdate::getExistingProperties 0:0:0:0:0:0:0:1 */ pp_propname,pp_value FROM `page_props` WHERE pp_page = '2' FOR UPDATE

SELECT /* BacklinkCache::getNumLinks 0:0:0:0:0:0:0:1 */ 1 FROM `templatelinks`,`page` WHERE tl_namespace = '0' AND tl_title = 'Aabb' AND (page_id=tl_from) LIMIT 1

UPDATE /* Title::invalidateCache 0:0:0:0:0:0:0:1 */ `page` SET page_touched = '20140218030847' WHERE page_namespace = '1' AND page_title = 'Aabb'

SELECT /* WikiPage::pageData 0:0:0:0:0:0:0:1 */ page_id,page_namespace,page_title,page_restrictions,page_counter,page_is_redirect,page_is_new,page_random,page_touched,page_latest,page_len,page_content_model FROM `page` WHERE page_namespace = '1' AND page_title = 'Aabb' LIMIT 1

SELECT /* BacklinkCache::getNumLinks 0:0:0:0:0:0:0:1 */ 1 FROM `pagelinks`,`page` WHERE pl_namespace = '0' AND pl_title = 'Aabb' AND (page_id=pl_from) LIMIT 200

SELECT /* BacklinkCache::getLinks 0:0:0:0:0:0:0:1 */ /*! STRAIGHT_JOIN */ page_namespace,page_title,page_id FROM `pagelinks`,`page` WHERE pl_namespace = '0' AND pl_title = 'Aabb' AND (page_id=pl_from) ORDER BY pl_from

UPDATE /* HTMLCacheUpdateJob::invalidateTitles 0:0:0:0:0:0:0:1 */ `page` SET page_touched = '20140218030940' WHERE page_id = '1' AND (page_touched < '20140218030914')

DELETE /* Title::deleteTitleProtection 0:0:0:0:0:0:0:1 */ FROM `protected_titles` WHERE pt_namespace = '0' AND pt_title = 'Aabb'

COMMIT /* LoadBalancer::commitMasterChanges 0:0:0:0:0:0:0:1 */

BEGIN /* SiteStatsUpdate::doUpdate 0:0:0:0:0:0:0:1 */

UPDATE /* SiteStatsUpdate::doUpdate 0:0:0:0:0:0:0:1 */ `site_stats` SET ss_total_edits=ss_total_edits+1,ss_total_pages=ss_total_pages+1

COMMIT /* SiteStatsUpdate::doUpdate 0:0:0:0:0:0:0:1 */

SHOW /* 0:0:0:0:0:0:0:1 */ GLOBAL VARIABLES LIKE 'ft\_min\_word\_len'

BEGIN /* DatabaseBase::query (SearchMySQL::update) 0:0:0:0:0:0:0:1 */

REPLACE /* SearchMySQL::update 0:0:0:0:0:0:0:1 */ INTO `searchindex` (si_page,si_title,si_text) VALUES ('2','aabb',' aaabbb ')

COMMIT /* DeferredUpdates::doUpdates 0:0:0:0:0:0:0:1 */

BEGIN /* DatabaseBase::query (JobQueueDB::doIsEmpty) 0:0:0:0:0:0:0:1 */

SELECT /* JobQueueDB::doIsEmpty 0:0:0:0:0:0:0:1 */ 1 FROM `job` WHERE job_cmd = 'refreshLinks' AND job_token = LIMIT 1

SELECT /* JobQueueDB::doIsEmpty 0:0:0:0:0:0:0:1 */ 1 FROM `job` WHERE job_cmd = 'refreshLinks2' AND job_token = LIMIT 1

SELECT /* JobQueueDB::doIsEmpty 0:0:0:0:0:0:0:1 */ 1 FROM `job` WHERE job_cmd = 'htmlCacheUpdate' AND job_token = LIMIT 1

SELECT /* JobQueueDB::doIsEmpty 0:0:0:0:0:0:0:1 */ 1 FROM `job` WHERE job_cmd = 'html_cache_update' AND job_token = LIMIT 1

SELECT /* JobQueueDB::doIsEmpty 0:0:0:0:0:0:0:1 */ 1 FROM `job` WHERE job_cmd = 'sendMail' AND job_token = LIMIT 1

SELECT /* JobQueueDB::doIsEmpty 0:0:0:0:0:0:0:1 */ 1 FROM `job` WHERE job_cmd = 'enotifNotify' AND job_token = LIMIT 1

SELECT /* JobQueueDB::doIsEmpty 0:0:0:0:0:0:0:1 */ 1 FROM `job` WHERE job_cmd = 'fixDoubleRedirect' AND job_token = LIMIT 1

SELECT /* JobQueueDB::doIsEmpty 0:0:0:0:0:0:0:1 */ 1 FROM `job` WHERE job_cmd = 'uploadFromUrl' AND job_token = LIMIT 1

SELECT /* JobQueueDB::doIsEmpty 0:0:0:0:0:0:0:1 */ 1 FROM `job` WHERE job_cmd = 'AssembleUploadChunks' AND job_token = LIMIT 1

SELECT /* JobQueueDB::doIsEmpty 0:0:0:0:0:0:0:1 */ 1 FROM `job` WHERE job_cmd = 'PublishStashedFile' AND job_token = LIMIT 1

SELECT /* JobQueueDB::doIsEmpty 0:0:0:0:0:0:0:1 */ 1 FROM `job` WHERE job_cmd = 'null' AND job_token = LIMIT 1

SET /* DatabaseMysql::open */ NAMES binary

SET /* DatabaseMysql::open */ sql_mode =

BEGIN /* DatabaseBase::query (LCStore_DB::get) */

SELECT /* LCStore_DB::get */ lc_value FROM `l10n_cache` WHERE lc_lang = 'zh-cn' AND lc_key = 'deps' LIMIT 1

SELECT /* LCStore_DB::get */ lc_value FROM `l10n_cache` WHERE lc_lang = 'zh-cn' AND lc_key = 'list' LIMIT 1

SELECT /* LCStore_DB::get */ lc_value FROM `l10n_cache` WHERE lc_lang = 'zh-cn' AND lc_key = 'preload' LIMIT 1

SELECT /* LCStore_DB::get */ lc_value FROM `l10n_cache` WHERE lc_lang = 'zh-cn' AND lc_key = 'preload' LIMIT 1

SELECT /* LCStore_DB::get */ lc_value FROM `l10n_cache` WHERE lc_lang = 'zh-cn' AND lc_key = 'fallback' LIMIT 1

SELECT /* LinkCache::addLinkObj */ page_id,page_len,page_is_redirect,page_latest,page_content_model FROM `page` WHERE page_namespace = '0' AND page_title = 'Aabb' LIMIT 1

SELECT /* WikiPage::pageData */ page_id,page_namespace,page_title,page_restrictions,page_counter,page_is_redirect,page_is_new,page_random,page_touched,page_latest,page_len,page_content_model FROM `page` WHERE page_namespace = '0' AND page_title = 'Aabb' LIMIT 1

SELECT /* Title::loadRestrictions */ pr_type,pr_expiry,pr_level,pr_cascade FROM `page_restrictions` WHERE pr_page = '2'

SELECT /* Revision::fetchFromConds */ rev_id,rev_page,rev_text_id,rev_timestamp,rev_comment,rev_user_text,rev_user,rev_minor_edit,rev_deleted,rev_len,rev_parent_id,rev_sha1,rev_content_format,rev_content_model,page_namespace,page_title,page_id,page_latest,page_is_redirect,page_len,user_name FROM `revision` INNER JOIN `page` ON ((page_id = rev_page)) LEFT JOIN `user` ON ((rev_user != 0) AND (user_id = rev_user)) WHERE page_id = '2' AND rev_id = '3' LIMIT 1

SELECT /* Revision::loadText */ old_text,old_flags FROM `text` WHERE old_id = '3' LIMIT 1

SELECT /* LCStore_DB::get */ lc_value FROM `l10n_cache` WHERE lc_lang = 'zh-cn' AND lc_key = 'magicWords' LIMIT 1

SET /* DatabaseMysql::open 0:0:0:0:0:0:0:1 */ NAMES binary

SET /* DatabaseMysql::open 0:0:0:0:0:0:0:1 */ sql_mode =

SELECT /* SqlBagOStuff::getMulti 0:0:0:0:0:0:0:1 */ keyname,value,exptime FROM `objectcache` WHERE keyname = 'my_wiki:messages:zh-cn'

SELECT /* SqlBagOStuff::deleteObjectsExpiringBefore 0:0:0:0:0:0:0:1 */ keyname,exptime FROM `objectcache` WHERE (exptime < '20140218031901') ORDER BY exptime LIMIT 100

SELECT /* SqlBagOStuff::getMulti 0:0:0:0:0:0:0:1 */ keyname,value,exptime FROM `objectcache` WHERE keyname = 'my_wiki:pcache:idoptions:2'

SELECT /* SqlBagOStuff::getMulti 0:0:0:0:0:0:0:1 */ keyname,value,exptime FROM `objectcache` WHERE keyname = 'my_wiki:pcache:idhash:2-0!*!*!*!*!*!*'

SELECT /* LinkBatch::doQuery (for Skin::preloadExistence) 0:0:0:0:0:0:0:1 */ page_id,page_namespace,page_title,page_len,page_is_redirect,page_latest FROM `page` WHERE (page_namespace = '2' AND page_title = '0:0:0:0:0:0:0:1') OR (page_namespace = '3' AND page_title = '0:0:0:0:0:0:0:1') OR (page_namespace = '1' AND page_title = 'Aabb')

SELECT /* LCStore_DB::get 0:0:0:0:0:0:0:1 */ lc_value FROM `l10n_cache` WHERE lc_lang = 'zh-cn' AND lc_key = 'namespaceGenderAliases' LIMIT 1

SELECT /* LCStore_DB::get 0:0:0:0:0:0:0:1 */ lc_value FROM `l10n_cache` WHERE lc_lang = 'zh-cn' AND lc_key = 'namespaceAliases' LIMIT 1

SELECT /* LCStore_DB::get 0:0:0:0:0:0:0:1 */ lc_value FROM `l10n_cache` WHERE lc_lang = 'zh-cn' AND lc_key = 'specialPageAliases' LIMIT 1

SELECT /* LCStore_DB::get 0:0:0:0:0:0:0:1 */ lc_value FROM `l10n_cache` WHERE lc_lang = 'zh-cn' AND lc_key = 'rtl' LIMIT 1

SELECT /* LCStore_DB::get 0:0:0:0:0:0:0:1 */ lc_value FROM `l10n_cache` WHERE lc_lang = 'zh-cn' AND lc_key = 'capitalizeAllNouns' LIMIT 1

SELECT /* User::checkNewtalk 0:0:0:0:0:0:0:1 */ user_ip FROM `user_newtalk` WHERE user_ip = '0:0:0:0:0:0:0:1' LIMIT 1

SELECT /* LCStore_DB::get 0:0:0:0:0:0:0:1 */ lc_value FROM `l10n_cache` WHERE lc_lang = 'zh-cn' AND lc_key = 'datePreferenceMigrationMap' LIMIT 1

SELECT /* LCStore_DB::get 0:0:0:0:0:0:0:1 */ lc_value FROM `l10n_cache` WHERE lc_lang = 'zh-cn' AND lc_key = 'defaultDateFormat' LIMIT 1

SELECT /* LCStore_DB::get 0:0:0:0:0:0:0:1 */ lc_value FROM `l10n_cache` WHERE lc_lang = 'zh-cn' AND lc_key = 'digitTransformTable' LIMIT 1

SELECT /* LCStore_DB::get 0:0:0:0:0:0:0:1 */ lc_value FROM `l10n_cache` WHERE lc_lang = 'zh-cn' AND lc_key = 'messages:tuesday' LIMIT 1

SELECT /* ResourceLoaderWikiModule::getTitleMtimes 0:0:0:0:0:0:0:1 */ page_namespace,page_title,page_touched FROM `page` WHERE (page_namespace = '8' AND page_title IN ('Common.js','Common.css','Vector.js','Vector.css','Print.css') )

SELECT /* LCStore_DB::get 0:0:0:0:0:0:0:1 */ lc_value FROM `l10n_cache` WHERE lc_lang = 'zh-cn' AND lc_key = 'messages:login' LIMIT 1

SELECT /* LCStore_DB::get 0:0:0:0:0:0:0:1 */ lc_value FROM `l10n_cache` WHERE lc_lang = 'zh-cn' AND lc_key = 'messages:createaccount' LIMIT 1

...

SELECT /* ResourceLoaderWikiModule::getTitleMtimes 0:0:0:0:0:0:0:1 */ page_namespace,page_title,page_touched FROM `page` WHERE (page_namespace = '8' AND page_title IN ('Common.js','Common.css','Vector.js','Vector.css','Print.css') )

SELECT /* ResourceLoaderWikiModule::getTitleMtimes 0:0:0:0:0:0:0:1 */ page_namespace,page_title,page_touched FROM `page` WHERE (page_namespace = '8' AND page_title = 'Noscript.css')

SELECT /* SqlBagOStuff::getMulti 0:0:0:0:0:0:0:1 */ keyname,value,exptime FROM `objectcache` WHERE keyname = 'my_wiki:resourceloader:filter:minify-css:7:7b7720b101786fdbcf4ef1bf1411215b'

SELECT /* SqlBagOStuff::getMulti 0:0:0:0:0:0:0:1 */ keyname,value,exptime FROM `objectcache` WHERE keyname = 'my_wiki:resourceloader:filter:minify-css:7:544dac5ca8aa067995965f3993c061b8'

SELECT /* LCStore_DB::get 0:0:0:0:0:0:0:1 */ lc_value FROM `l10n_cache` WHERE lc_lang = 'zh-cn' AND lc_key = 'separatorTransformTable' LIMIT 1

SELECT /* LCStore_DB::get 0:0:0:0:0:0:0:1 */ lc_value FROM `l10n_cache` WHERE lc_lang = 'zh-cn' AND lc_key = 'messages:january' LIMIT 1

...

来自“https://www.mywiki.cn/Hovercool/index.php?title=mediawiki数据库研究@新建页面&oldid=924”