[nav] /www/wwwroot/daohw.cn/app/common/db_upgrade.php:144 SQLSTATE[42000]: Syntax error or access violation: 1061 Duplicate key name 'ux_nav_admin_username'
[nav] /www/wwwroot/daohw.cn/app/common/db_upgrade.php:144 SQLSTATE[42000]: Syntax error or access violation: 1061 Duplicate key name 'ux_nav_category_slug'
[nav] /www/wwwroot/daohw.cn/app/common/db_upgrade.php:144 SQLSTATE[42000]: Syntax error or access violation: 1061 Duplicate key name 'ux_nav_tag_slug'
[nav] /www/wwwroot/daohw.cn/app/common/db_upgrade.php:144 SQLSTATE[42000]: Syntax error or access violation: 1061 Duplicate key name 'ix_nav_tag_cat'
[nav] /www/wwwroot/daohw.cn/app/common/db_upgrade.php:144 SQLSTATE[42000]: Syntax error or access violation: 1061 Duplicate key name 'ux_nav_site_slug'
[nav] /www/wwwroot/daohw.cn/app/common/db_upgrade.php:144 SQLSTATE[42000]: Syntax error or access violation: 1061 Duplicate key name 'ix_nav_site_cat'
[nav] /www/wwwroot/daohw.cn/app/common/db_upgrade.php:144 SQLSTATE[42000]: Syntax error or access violation: 1061 Duplicate key name 'ix_nav_site_tag'
[nav] /www/wwwroot/daohw.cn/app/common/db_upgrade.php:144 SQLSTATE[42000]: Syntax error or access violation: 1061 Duplicate key name 'ix_nav_site_type'
[nav] /www/wwwroot/daohw.cn/app/common/db_upgrade.php:144 SQLSTATE[42000]: Syntax error or access violation: 1061 Duplicate key name 'ix_nav_site_create'
[nav] /www/wwwroot/daohw.cn/app/common/db_upgrade.php:144 SQLSTATE[42000]: Syntax error or access violation: 1061 Duplicate key name 'ix_nav_site_views'
[nav] /www/wwwroot/daohw.cn/app/common/db_upgrade.php:144 SQLSTATE[42000]: Syntax error or access violation: 1061 Duplicate key name 'ix_nav_site_likes'
[nav] /www/wwwroot/daohw.cn/app/common/db_upgrade.php:144 SQLSTATE[42000]: Syntax error or access violation: 1061 Duplicate key name 'ix_nav_site_views_date'
[nav] /www/wwwroot/daohw.cn/app/common/db_upgrade.php:144 SQLSTATE[42000]: Syntax error or access violation: 1061 Duplicate key name 'ix_nav_site_views_wkey'
[nav] /www/wwwroot/daohw.cn/app/common/db_upgrade.php:144 SQLSTATE[42000]: Syntax error or access violation: 1061 Duplicate key name 'ux_nav_like_ip'
[nav] /www/wwwroot/daohw.cn/app/common/db_upgrade.php:144 SQLSTATE[42000]: Syntax error or access violation: 1061 Duplicate key name 'ux_nav_svd_site_day'
[nav] /www/wwwroot/daohw.cn/app/common/db_upgrade.php:144 SQLSTATE[42000]: Syntax error or access violation: 1061 Duplicate key name 'ix_nav_svd_day'
[nav] /www/wwwroot/daohw.cn/app/common/db_upgrade.php:144 SQLSTATE[42000]: Syntax error or access violation: 1061 Duplicate key name 'ix_nav_site_health_status'
[nav] /www/wwwroot/daohw.cn/app/common/db_upgrade.php:144 SQLSTATE[42000]: Syntax error or access violation: 1061 Duplicate key name 'ux_nav_acat_slug'
[nav] /www/wwwroot/daohw.cn/app/common/db_upgrade.php:144 SQLSTATE[42000]: Syntax error or access violation: 1061 Duplicate key name 'ix_nav_acat_parent'
[nav] /www/wwwroot/daohw.cn/app/common/db_upgrade.php:144 SQLSTATE[42000]: Syntax error or access violation: 1061 Duplicate key name 'ix_nav_amenu_parent'
[nav] /www/wwwroot/daohw.cn/app/common/db_upgrade.php:144 SQLSTATE[42000]: Syntax error or access violation: 1061 Duplicate key name 'ix_nav_article_cat'
[nav] /www/wwwroot/daohw.cn/app/common/db_upgrade.php:144 SQLSTATE[42000]: Syntax error or access violation: 1061 Duplicate key name 'ix_nav_sponsor_site'
[nav] /www/wwwroot/daohw.cn/app/common/db_upgrade.php:144 SQLSTATE[42000]: Syntax error or access violation: 1061 Duplicate key name 'ux_nav_sponsor_order_no'
[nav] /www/wwwroot/daohw.cn/app/common/db_upgrade.php:144 SQLSTATE[42000]: Syntax error or access violation: 1061 Duplicate key name 'ix_nav_sponsor_order_sp'
[nav] /www/wwwroot/daohw.cn/app/common/db_upgrade.php:144 SQLSTATE[42000]: Syntax error or access violation: 1061 Duplicate key name 'ix_nav_link_pos'
[nav] /www/wwwroot/daohw.cn/app/common/db_upgrade.php:144 SQLSTATE[42000]: Syntax error or access violation: 1061 Duplicate key name 'ix_nav_link_pid'
[nav] /www/wwwroot/daohw.cn/app/common/db_upgrade.php:144 SQLSTATE[42000]: Syntax error or access violation: 1061 Duplicate key name 'ix_nav_submit_status'
[nav] /www/wwwroot/daohw.cn/app/common/db_upgrade.php:144 SQLSTATE[42000]: Syntax error or access violation: 1061 Duplicate key name 'ix_nav_submit_cat'
[nav] /www/wwwroot/daohw.cn/app/common/db_upgrade.php:144 SQLSTATE[42000]: Syntax error or access violation: 1061 Duplicate key name 'ix_nav_submit_create'
[nav] /www/wwwroot/daohw.cn/app/common/db_upgrade.php:144 SQLSTATE[42000]: Syntax error or access violation: 1061 Duplicate key name 'ix_nav_qlink_sort'
[nav] /www/wwwroot/daohw.cn/app/common/db_upgrade.php:144 SQLSTATE[42000]: Syntax error or access violation: 1061 Duplicate key name 'ux_nav_qlink_item'
[nav] /www/wwwroot/daohw.cn/app/common/db_upgrade.php:144 SQLSTATE[42000]: Syntax error or access violation: 1061 Duplicate key name 'ix_nav_qlink_item_sort'
[nav] /www/wwwroot/daohw.cn/app/common/db_upgrade.php:144 SQLSTATE[42000]: Syntax error or access violation: 1061 Duplicate key name 'ix_nav_ad_state'
[nav] /www/wwwroot/daohw.cn/app/common/db_upgrade.php:144 SQLSTATE[42000]: Syntax error or access violation: 1061 Duplicate key name 'ix_nav_ad_time'
[nav] /www/wwwroot/daohw.cn/app/common/db_upgrade.php:144 SQLSTATE[42000]: Syntax error or access violation: 1061 Duplicate key name 'ix_nav_adplan_sort'
[nav] /www/wwwroot/daohw.cn/app/common/db_upgrade.php:144 SQLSTATE[42000]: Syntax error or access violation: 1061 Duplicate key name 'ix_nav_friend_status'
[nav] /www/wwwroot/daohw.cn/app/common/db_upgrade.php:144 SQLSTATE[42000]: Syntax error or access violation: 1061 Duplicate key name 'ux_nav_friend_order'
[nav] /www/wwwroot/daohw.cn/app/common/db_upgrade.php:144 SQLSTATE[42000]: Syntax error or access violation: 1061 Duplicate key name 'ix_nav_dock_sort'
[nav] /www/wwwroot/daohw.cn/app/common/db_upgrade.php:144 SQLSTATE[42000]: Syntax error or access violation: 1061 Duplicate key name 'ux_nav_plugin_slug'
[nav] /www/wwwroot/daohw.cn/app/common/db_upgrade.php:144 SQLSTATE[42000]: Syntax error or access violation: 1061 Duplicate key name 'ix_nav_plugin_sort'
[nav] /www/wwwroot/daohw.cn/app/common/db_upgrade.php:144 SQLSTATE[42000]: Syntax error or access violation: 1061 Duplicate key name 'ix_nav_dypage_alias'
[nav] /www/wwwroot/daohw.cn/app/common/db_upgrade.php:144 SQLSTATE[42000]: Syntax error or access violation: 1061 Duplicate key name 'ix_nav_dypage_sort'
[nav] /www/wwwroot/daohw.cn/app/common/db_upgrade.php:144 SQLSTATE[42000]: Syntax error or access violation: 1061 Duplicate key name 'ix_nav_devphase_sort'
[nav] /www/wwwroot/daohw.cn/app/common/db_upgrade.php:144 SQLSTATE[42000]: Syntax error or access violation: 1061 Duplicate key name 'ix_nav_devlog_day'
[nav] /www/wwwroot/daohw.cn/app/common/db_upgrade.php:144 SQLSTATE[42000]: Syntax error or access violation: 1061 Duplicate key name 'ix_nav_api_log_channel'
[nav] /www/wwwroot/daohw.cn/app/common/db_upgrade.php:144 SQLSTATE[42000]: Syntax error or access violation: 1061 Duplicate key name 'ix_nav_api_log_status'
[nav] /www/wwwroot/daohw.cn/app/common/db_upgrade.php:144 SQLSTATE[42000]: Syntax error or access violation: 1061 Duplicate key name 'ix_nav_api_log_time'
[nav] /www/wwwroot/daohw.cn/app/common/db_upgrade.php:144 SQLSTATE[42000]: Syntax error or access violation: 1061 Duplicate key name 'ux_nav_user_name'
[nav] /www/wwwroot/daohw.cn/app/common/db_upgrade.php:144 SQLSTATE[42000]: Syntax error or access violation: 1061 Duplicate key name 'ix_nav_user_email'
[nav] /www/wwwroot/daohw.cn/app/common/db_upgrade.php:144 SQLSTATE[42000]: Syntax error or access violation: 1061 Duplicate key name 'ix_nav_user_status'
[nav] /www/wwwroot/daohw.cn/app/common/db_upgrade.php:144 SQLSTATE[42000]: Syntax error or access violation: 1061 Duplicate key name 'ix_nav_user_regip'
[nav] /www/wwwroot/daohw.cn/app/common/db_upgrade.php:144 SQLSTATE[42000]: Syntax error or access violation: 1061 Duplicate key name 'ix_nav_user_create'
[nav] /www/wwwroot/daohw.cn/app/common/db_upgrade.php:144 SQLSTATE[42000]: Syntax error or access violation: 1061 Duplicate key name 'ix_nav_user_vip_expire'
[nav] /www/wwwroot/daohw.cn/app/common/db_upgrade.php:144 SQLSTATE[42000]: Syntax error or access violation: 1061 Duplicate key name 'ix_nav_user_webmaster_expire'
[nav] /www/wwwroot/daohw.cn/app/common/db_upgrade.php:144 SQLSTATE[42000]: Syntax error or access violation: 1061 Duplicate key name 'ix_nav_user_level'
[nav] /www/wwwroot/daohw.cn/app/common/db_upgrade.php:144 SQLSTATE[42000]: Syntax error or access violation: 1061 Duplicate key name 'ux_nav_user_token'
[nav] /www/wwwroot/daohw.cn/app/common/db_upgrade.php:144 SQLSTATE[42000]: Syntax error or access violation: 1061 Duplicate key name 'ix_nav_user_token_uid'
[nav] /www/wwwroot/daohw.cn/app/common/db_upgrade.php:144 SQLSTATE[42000]: Syntax error or access violation: 1061 Duplicate key name 'ix_nav_user_token_exp'
[nav] /www/wwwroot/daohw.cn/app/common/db_upgrade.php:144 SQLSTATE[42000]: Syntax error or access violation: 1061 Duplicate key name 'ux_nav_user_fav'
[nav] /www/wwwroot/daohw.cn/app/common/db_upgrade.php:144 SQLSTATE[42000]: Syntax error or access violation: 1071 Specified key was too long; max key length is 767 bytes
[nav] /www/wwwroot/daohw.cn/app/common/db_upgrade.php:144 SQLSTATE[42000]: Syntax error or access violation: 1061 Duplicate key name 'ix_nav_user_quick_uid'
[nav] /www/wwwroot/daohw.cn/app/common/db_upgrade.php:144 SQLSTATE[42000]: Syntax error or access violation: 1071 Specified key was too long; max key length is 767 bytes
[nav] /www/wwwroot/daohw.cn/app/common/db_upgrade.php:144 SQLSTATE[42000]: Syntax error or access violation: 1061 Duplicate key name 'ix_nav_user_dock_uid'
[nav] /www/wwwroot/daohw.cn/app/common/db_upgrade.php:144 SQLSTATE[42000]: Syntax error or access violation: 1061 Duplicate key name 'ux_nav_user_note'
[nav] /www/wwwroot/daohw.cn/app/common/db_upgrade.php:144 SQLSTATE[42000]: Syntax error or access violation: 1061 Duplicate key name 'ix_nav_user_note_uid'
[nav] /www/wwwroot/daohw.cn/app/common/db_upgrade.php:144 SQLSTATE[42000]: Syntax error or access violation: 1061 Duplicate key name 'ux_nav_fx_url_slug'
[nav] /www/wwwroot/daohw.cn/app/common/db_upgrade.php:144 SQLSTATE[42000]: Syntax error or access violation: 1061 Duplicate key name 'ix_nav_fx_url_uid'
[nav] /www/wwwroot/daohw.cn/app/common/db_upgrade.php:144 SQLSTATE[42000]: Syntax error or access violation: 1061 Duplicate key name 'ix_nav_fx_url_ip'
[nav] /www/wwwroot/daohw.cn/app/common/db_upgrade.php:144 SQLSTATE[42000]: Syntax error or access violation: 1061 Duplicate key name 'ix_nav_fx_report_fx'
[nav] /www/wwwroot/daohw.cn/app/common/db_upgrade.php:144 SQLSTATE[42000]: Syntax error or access violation: 1061 Duplicate key name 'ix_nav_fx_report_ip'
[nav] /www/wwwroot/daohw.cn/app/common/db_upgrade.php:144 SQLSTATE[42000]: Syntax error or access violation: 1061 Duplicate key name 'ux_nav_user_theme'
[nav] /www/wwwroot/daohw.cn/app/common/db_upgrade.php:144 SQLSTATE[42000]: Syntax error or access violation: 1061 Duplicate key name 'ix_nav_user_theme_uid'
[nav] /www/wwwroot/daohw.cn/app/common/db_upgrade.php:144 SQLSTATE[42000]: Syntax error or access violation: 1061 Duplicate key name 'ux_nav_user_like'
[nav] /www/wwwroot/daohw.cn/app/common/db_upgrade.php:144 SQLSTATE[42000]: Syntax error or access violation: 1061 Duplicate key name 'ix_nav_user_code'
[nav] /www/wwwroot/daohw.cn/app/common/db_upgrade.php:144 SQLSTATE[42000]: Syntax error or access violation: 1061 Duplicate key name 'ix_nav_user_code_exp'
[nav] /www/wwwroot/daohw.cn/app/common/db_upgrade.php:144 SQLSTATE[42000]: Syntax error or access violation: 1061 Duplicate key name 'ux_nav_user_hist'
[nav] /www/wwwroot/daohw.cn/app/common/db_upgrade.php:144 SQLSTATE[42000]: Syntax error or access violation: 1061 Duplicate key name 'ix_nav_user_hist_time'
[nav] /www/wwwroot/daohw.cn/app/common/db_upgrade.php:144 SQLSTATE[42000]: Syntax error or access violation: 1061 Duplicate key name 'ux_nav_invite_code'
[nav] /www/wwwroot/daohw.cn/app/common/db_upgrade.php:144 SQLSTATE[42000]: Syntax error or access violation: 1061 Duplicate key name 'ix_nav_invite_status'
[nav] /www/wwwroot/daohw.cn/app/common/db_upgrade.php:144 SQLSTATE[42000]: Syntax error or access violation: 1061 Duplicate key name 'ix_nav_invite_user'
[nav] /www/wwwroot/daohw.cn/app/common/db_upgrade.php:144 SQLSTATE[42000]: Syntax error or access violation: 1061 Duplicate key name 'ux_nav_invite_order'
[nav] /www/wwwroot/daohw.cn/app/common/db_upgrade.php:144 SQLSTATE[42000]: Syntax error or access violation: 1061 Duplicate key name 'ix_nav_invite_order_st'
[nav] /www/wwwroot/daohw.cn/app/common/db_upgrade.php:144 SQLSTATE[42000]: Syntax error or access violation: 1061 Duplicate key name 'ix_nav_invite_order_ip'
[nav] /www/wwwroot/daohw.cn/app/common/db_upgrade.php:144 SQLSTATE[42000]: Syntax error or access violation: 1061 Duplicate key name 'ix_nav_invite_order_uid'
[nav] /www/wwwroot/daohw.cn/app/common/db_upgrade.php:144 SQLSTATE[42000]: Syntax error or access violation: 1061 Duplicate key name 'ix_nav_invite_order_create'
[nav] /www/wwwroot/daohw.cn/app/common/db_upgrade.php:144 SQLSTATE[42000]: Syntax error or access violation: 1061 Duplicate key name 'ix_nav_invite_order_pay'
[nav] /www/wwwroot/daohw.cn/app/common/db_upgrade.php:144 SQLSTATE[42000]: Syntax error or access violation: 1061 Duplicate key name 'ix_nav_invite_order_st_pay'
[nav] /www/wwwroot/daohw.cn/app/common/db_upgrade.php:144 SQLSTATE[42000]: Syntax error or access violation: 1061 Duplicate key name 'ix_nav_member_plan_type'
[nav] /www/wwwroot/daohw.cn/app/common/db_upgrade.php:144 SQLSTATE[42000]: Syntax error or access violation: 1061 Duplicate key name 'ix_nav_points_pack_on'
[nav] /www/wwwroot/daohw.cn/app/common/db_upgrade.php:144 SQLSTATE[42000]: Syntax error or access violation: 1061 Duplicate key name 'ux_nav_member_order'
[nav] /www/wwwroot/daohw.cn/app/common/db_upgrade.php:144 SQLSTATE[42000]: Syntax error or access violation: 1061 Duplicate key name 'ix_nav_member_order_uid'
[nav] /www/wwwroot/daohw.cn/app/common/db_upgrade.php:144 SQLSTATE[42000]: Syntax error or access violation: 1061 Duplicate key name 'ix_nav_member_order_st'
[nav] /www/wwwroot/daohw.cn/app/common/db_upgrade.php:144 SQLSTATE[42000]: Syntax error or access violation: 1061 Duplicate key name 'ix_nav_member_order_type_pay'
[nav] /www/wwwroot/daohw.cn/app/common/db_upgrade.php:144 SQLSTATE[42000]: Syntax error or access violation: 1061 Duplicate key name 'ix_nav_points_log_uid'
[nav] /www/wwwroot/daohw.cn/app/common/db_upgrade.php:144 SQLSTATE[42000]: Syntax error or access violation: 1061 Duplicate key name 'ix_nav_points_log_create'
[nav] /www/wwwroot/daohw.cn/app/common/db_upgrade.php:144 SQLSTATE[42000]: Syntax error or access violation: 1061 Duplicate key name 'ux_nav_article_points_once'
[nav] /www/wwwroot/daohw.cn/app/common/db_upgrade.php:144 SQLSTATE[42000]: Syntax error or access violation: 1061 Duplicate key name 'ix_nav_article_points_day'
[nav] /www/wwwroot/daohw.cn/app/common/db_upgrade.php:144 SQLSTATE[42000]: Syntax error or access violation: 1061 Duplicate key name 'ix_nav_article_points_ip'
[nav] /www/wwwroot/daohw.cn/app/common/db_upgrade.php:144 SQLSTATE[42000]: Syntax error or access violation: 1061 Duplicate key name 'ux_nav_points_signin_day'
[nav] /www/wwwroot/daohw.cn/app/common/db_upgrade.php:144 SQLSTATE[42000]: Syntax error or access violation: 1061 Duplicate key name 'ix_nav_points_signin_ip'
[nav] /www/wwwroot/daohw.cn/app/common/db_upgrade.php:144 SQLSTATE[42000]: Syntax error or access violation: 1061 Duplicate key name 'ix_nav_points_signin_dev'
[nav] /www/wwwroot/daohw.cn/app/common/db_upgrade.php:144 SQLSTATE[42000]: Syntax error or access violation: 1061 Duplicate key name 'ux_nav_dl_ticket_sig'
[nav] /www/wwwroot/daohw.cn/app/common/db_upgrade.php:144 SQLSTATE[42000]: Syntax error or access violation: 1061 Duplicate key name 'ix_nav_dl_ticket_exp'
[nav] /www/wwwroot/daohw.cn/app/common/db_upgrade.php:144 SQLSTATE[42000]: Syntax error or access violation: 1061 Duplicate key name 'ux_nav_pkg_key_once'
[nav] /www/wwwroot/daohw.cn/app/common/db_upgrade.php:144 SQLSTATE[42000]: Syntax error or access violation: 1061 Duplicate key name 'ix_nav_pkg_key_bucket'
[nav] /www/wwwroot/daohw.cn/app/common/db_upgrade.php:144 SQLSTATE[42000]: Syntax error or access violation: 1061 Duplicate key name 'ix_nav_pkg_key_slug'
[nav] /www/wwwroot/daohw.cn/app/common/db_upgrade.php:144 SQLSTATE[42000]: Syntax error or access violation: 1061 Duplicate key name 'ix_nav_secret_new'
[nav] /www/wwwroot/daohw.cn/app/common/db_upgrade.php:144 SQLSTATE[42000]: Syntax error or access violation: 1061 Duplicate key name 'ix_nav_secret_hot'
[nav] /www/wwwroot/daohw.cn/app/common/db_upgrade.php:144 SQLSTATE[42000]: Syntax error or access violation: 1061 Duplicate key name 'ix_nav_secret_dev'
[nav] /www/wwwroot/daohw.cn/app/common/db_upgrade.php:144 SQLSTATE[42000]: Syntax error or access violation: 1061 Duplicate key name 'ix_nav_secret_uid'
[nav] /www/wwwroot/daohw.cn/app/common/db_upgrade.php:144 SQLSTATE[42000]: Syntax error or access violation: 1061 Duplicate key name 'ix_nav_secret_ip'
[nav] /www/wwwroot/daohw.cn/app/common/db_upgrade.php:144 SQLSTATE[42000]: Syntax error or access violation: 1061 Duplicate key name 'ix_nav_secret_hash'
[nav] /www/wwwroot/daohw.cn/app/common/db_upgrade.php:144 SQLSTATE[42000]: Syntax error or access violation: 1061 Duplicate key name 'ix_nav_secret_site'
[nav] /www/wwwroot/daohw.cn/app/common/db_upgrade.php:144 SQLSTATE[42000]: Syntax error or access violation: 1061 Duplicate key name 'ix_nav_secrep_post'
[nav] /www/wwwroot/daohw.cn/app/common/db_upgrade.php:144 SQLSTATE[42000]: Syntax error or access violation: 1061 Duplicate key name 'ix_nav_secrep_state'
[nav] /www/wwwroot/daohw.cn/app/common/db_upgrade.php:144 SQLSTATE[42000]: Syntax error or access violation: 1061 Duplicate key name 'ix_nav_comment_page'
[nav] /www/wwwroot/daohw.cn/app/common/db_upgrade.php:144 SQLSTATE[42000]: Syntax error or access violation: 1061 Duplicate key name 'ix_nav_comment_root'
[nav] /www/wwwroot/daohw.cn/app/common/db_upgrade.php:144 SQLSTATE[42000]: Syntax error or access violation: 1061 Duplicate key name 'ix_nav_comment_uid'
[nav] /www/wwwroot/daohw.cn/app/common/db_upgrade.php:144 SQLSTATE[42000]: Syntax error or access violation: 1061 Duplicate key name 'ix_nav_comment_dev'
[nav] /www/wwwroot/daohw.cn/app/common/db_upgrade.php:144 SQLSTATE[42000]: Syntax error or access violation: 1061 Duplicate key name 'ix_nav_comment_time'
[nav] /www/wwwroot/daohw.cn/app/common/db_upgrade.php:144 SQLSTATE[42000]: Syntax error or access violation: 1061 Duplicate key name 'ix_nav_rm_scope'
[nav] /www/wwwroot/daohw.cn/app/common/db_upgrade.php:144 SQLSTATE[42000]: Syntax error or access violation: 1061 Duplicate key name 'ix_nav_rm_item_rid'
[nav] /www/wwwroot/daohw.cn/app/common/db_upgrade.php:144 SQLSTATE[42000]: Syntax error or access violation: 1061 Duplicate key name 'ux_nav_home_module_mkey'
[nav] /www/wwwroot/daohw.cn/app/common/db_upgrade.php:144 SQLSTATE[42000]: Syntax error or access violation: 1061 Duplicate key name 'ix_nav_home_block_sort'
[nav] /www/wwwroot/daohw.cn/app/common/db_upgrade.php:144 SQLSTATE[42000]: Syntax error or access violation: 1061 Duplicate key name 'ix_nav_home_pic_sort'
[nav] /www/wwwroot/daohw.cn/app/common/db_upgrade.php:144 SQLSTATE[42000]: Syntax error or access violation: 1061 Duplicate key name 'ix_nav_home_pic_block'
[nav] /www/wwwroot/daohw.cn/app/common/db_upgrade.php:144 SQLSTATE[42000]: Syntax error or access violation: 1061 Duplicate key name 'ux_nav_pic_stat_day'
[nav] /www/wwwroot/daohw.cn/app/common/db_upgrade.php:144 SQLSTATE[42000]: Syntax error or access violation: 1061 Duplicate key name 'ux_nav_block_stat_day'
[nav] /www/wwwroot/daohw.cn/app/common/db_upgrade.php:144 SQLSTATE[42000]: Syntax error or access violation: 1061 Duplicate key name 'ux_nav_shijuan_subject_slug'
[nav] /www/wwwroot/daohw.cn/app/common/db_upgrade.php:144 SQLSTATE[42000]: Syntax error or access violation: 1061 Duplicate key name 'ux_nav_shijuan_cat_slug'
[nav] /www/wwwroot/daohw.cn/app/common/db_upgrade.php:144 SQLSTATE[42000]: Syntax error or access violation: 1061 Duplicate key name 'ix_nav_shijuan_cat_subject'
[nav] /www/wwwroot/daohw.cn/app/common/db_upgrade.php:144 SQLSTATE[42000]: Syntax error or access violation: 1061 Duplicate key name 'ux_nav_shijuan_item_cat_id'
[nav] /www/wwwroot/daohw.cn/app/common/db_upgrade.php:144 SQLSTATE[42000]: Syntax error or access violation: 1061 Duplicate key name 'ix_nav_shijuan_item_cat_sort'
[nav] /www/wwwroot/daohw.cn/app/common/db_upgrade.php:144 SQLSTATE[42000]: Syntax error or access violation: 1061 Duplicate key name 'ix_nav_shijuan_item_date'
[nav] /www/wwwroot/daohw.cn/app/common/db_upgrade.php:144 SQLSTATE[42000]: Syntax error or access violation: 1061 Duplicate key name 'ix_nav_shijuan_dl_item'
[nav] /www/wwwroot/daohw.cn/app/common/db_upgrade.php:144 SQLSTATE[42000]: Syntax error or access violation: 1061 Duplicate key name 'ix_nav_dl_unlock_art'
[nav] /www/wwwroot/daohw.cn/app/common/db_upgrade.php:144 SQLSTATE[42000]: Syntax error or access violation: 1061 Duplicate key name 'ix_nav_dl_unlock_token'
[nav] /www/wwwroot/daohw.cn/app/common/db_upgrade.php:144 SQLSTATE[42000]: Syntax error or access violation: 1061 Duplicate key name 'ix_nav_dl_unlock_email'
[nav] /www/wwwroot/daohw.cn/app/common/db_upgrade.php:144 SQLSTATE[42000]: Syntax error or access violation: 1061 Duplicate key name 'ix_nav_dl_unlock_mt'
[nav] /www/wwwroot/daohw.cn/app/common/db_upgrade.php:144 SQLSTATE[42000]: Syntax error or access violation: 1061 Duplicate key name 'ux_nav_dl_order_no'
[nav] /www/wwwroot/daohw.cn/app/common/db_upgrade.php:144 SQLSTATE[42000]: Syntax error or access violation: 1061 Duplicate key name 'ix_nav_dl_order_email'
[nav] /www/wwwroot/daohw.cn/app/common/db_upgrade.php:144 SQLSTATE[42000]: Syntax error or access violation: 1061 Duplicate key name 'ix_nav_dl_order_art'
[nav] /www/wwwroot/daohw.cn/app/common/db_upgrade.php:144 SQLSTATE[42000]: Syntax error or access violation: 1061 Duplicate key name 'ix_nav_dl_order_ip'
[nav] /www/wwwroot/daohw.cn/app/common/db_upgrade.php:144 SQLSTATE[42000]: Syntax error or access violation: 1061 Duplicate key name 'ux_nav_dl_quota'
[nav] /www/wwwroot/daohw.cn/app/common/db_upgrade.php:144 SQLSTATE[42000]: Syntax error or access violation: 1061 Duplicate key name 'ix_nav_dl_log_art'
[nav] /www/wwwroot/daohw.cn/app/common/db_upgrade.php:144 SQLSTATE[42000]: Syntax error or access violation: 1061 Duplicate key name 'ix_nav_dl_log_user'
[nav] /www/wwwroot/daohw.cn/app/common/db_upgrade.php:144 SQLSTATE[42000]: Syntax error or access violation: 1061 Duplicate key name 'ix_nav_dl_log_ip'
SELECT `v` FROM `nav_setting` WHERE `k` = 'db_version' [ RunTime:0.000310s ]
CREATE TABLE IF NOT EXISTS `nav_setting` (
`k` varchar(64) NOT NULL COMMENT '配置键名',
`v` text COMMENT '配置值(JSON / 文本)',
`update_time` int NOT NULL DEFAULT 0 COMMENT '最后更新时间(Unix 时间戳)',
PRIMARY KEY (`k`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT '系统配置表' [ RunTime:0.000244s ]
CREATE TABLE IF NOT EXISTS `nav_admin` (
`id` int unsigned NOT NULL AUTO_INCREMENT COMMENT '主键 ID', PRIMARY KEY (`id`),
`username` varchar(50) NOT NULL COMMENT '登录账号',
`password` varchar(255) NOT NULL COMMENT '登录密码(哈希存储)',
`nickname` varchar(50) DEFAULT '' COMMENT '管理员昵称',
`status` tinyint NOT NULL DEFAULT 1 COMMENT '状态(1 启用 / 0 禁用)',
`last_login_time` int NOT NULL DEFAULT 0 COMMENT '最后登录时间(Unix 时间戳)',
`last_login_ip` varchar(64) DEFAULT '' COMMENT '最后登录 IP',
`create_time` int NOT NULL DEFAULT 0 COMMENT '创建时间(Unix 时间戳)',
`update_time` int NOT NULL DEFAULT 0 COMMENT '更新时间(Unix 时间戳)'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT '后台管理员表' [ RunTime:0.000183s ]
CREATE TABLE IF NOT EXISTS `nav_category` (
`id` int unsigned NOT NULL AUTO_INCREMENT COMMENT '主键 ID', PRIMARY KEY (`id`),
`name` varchar(50) NOT NULL COMMENT '分类名称',
`slug` varchar(64) NOT NULL COMMENT 'URL 标识(英文唯一别名)',
`icon` varchar(255) DEFAULT '' COMMENT '分类图标',
`color` varchar(64) DEFAULT '' COMMENT '分类图标颜色',
`name_color` varchar(64) DEFAULT '' COMMENT '分类名称颜色',
`sort` int NOT NULL DEFAULT 0 COMMENT '排序值(越大越靠前)',
`status` tinyint NOT NULL DEFAULT 1 COMMENT '状态(1 启用 / 0 禁用)',
`create_time` int NOT NULL DEFAULT 0 COMMENT '创建时间(Unix 时间戳)',
`update_time` int NOT NULL DEFAULT 0 COMMENT '更新时间(Unix 时间戳)'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT '站点分类表' [ RunTime:0.000208s ]
CREATE TABLE IF NOT EXISTS `nav_category_tag` (
`id` int unsigned NOT NULL AUTO_INCREMENT COMMENT '主键 ID', PRIMARY KEY (`id`),
`category_id` int NOT NULL DEFAULT 0 COMMENT '所属一级分类',
`name` varchar(50) NOT NULL COMMENT '标签名称',
`slug` varchar(64) NOT NULL COMMENT 'URL 标识',
`icon` varchar(255) DEFAULT '' COMMENT '图标',
`name_color` varchar(64) DEFAULT '' COMMENT '标签名称颜色',
`icon_color` varchar(64) DEFAULT '' COMMENT '标签图标颜色',
`sort` int NOT NULL DEFAULT 0 COMMENT '排序,越大越前',
`status` tinyint NOT NULL DEFAULT 1 COMMENT '1 显示 0 隐藏',
`create_time` int NOT NULL DEFAULT 0 COMMENT '创建时间(Unix 时间戳)',
`update_time` int NOT NULL DEFAULT 0 COMMENT '更新时间(Unix 时间戳)'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT '站点分类二级标签表' [ RunTime:0.000178s ]
CREATE TABLE IF NOT EXISTS `nav_site` (
`id` int unsigned NOT NULL AUTO_INCREMENT COMMENT '主键 ID', PRIMARY KEY (`id`),
`category_id` int NOT NULL DEFAULT 0 COMMENT '所属分类 ID',
`tag_id` int NOT NULL DEFAULT 0 COMMENT '二级标签 id',
`name` varchar(100) NOT NULL COMMENT '站点名称',
`slug` varchar(100) NOT NULL COMMENT 'URL 标识(英文唯一别名)',
`url` varchar(500) DEFAULT '' COMMENT '站点访问地址',
`icon` varchar(500) DEFAULT '' COMMENT '站点图标地址',
`cover` varchar(500) DEFAULT '' COMMENT '封面图地址',
`description` varchar(500) DEFAULT '' COMMENT '站点简介',
`content` longtext COMMENT '站点详情内容(HTML)',
`tags` varchar(255) DEFAULT '' COMMENT '标签(逗号分隔)',
`badge` varchar(200) DEFAULT '' COMMENT '角标文字(如 推荐 / 新)',
`badge_color` varchar(20) NOT NULL DEFAULT '' COMMENT '角标颜色',
`sort` int NOT NULL DEFAULT 0 COMMENT '排序值(越大越靠前)',
`views` int NOT NULL DEFAULT 0 COMMENT '总浏览次数',
`views_today` int NOT NULL DEFAULT 0 COMMENT '今日浏览次数',
`views_date` int NOT NULL DEFAULT 0 COMMENT '今日浏览统计日期(YYYYMMDD)',
`likes` int NOT NULL DEFAULT 0 COMMENT '点赞数',
`is_featured` tinyint NOT NULL DEFAULT 0 COMMENT '是否精选(1 是 / 0 否)',
`poster` tinyint NOT NULL DEFAULT 0 COMMENT '是否海报推荐位(1 是 / 0 否)',
`is_pick` tinyint NOT NULL DEFAULT 0 COMMENT '是否站长推荐(1 是 / 0 否)',
`hide_code` varchar(100) NOT NULL DEFAULT '' COMMENT '隐藏入口口令',
`password` varchar(100) NOT NULL DEFAULT '' COMMENT '访问密码(留空不限制)',
`type` varchar(50) NOT NULL DEFAULT 'web' COMMENT '站点类型(web 网站 / app 应用)',
`platforms` varchar(200) NOT NULL DEFAULT '' COMMENT '支持平台(逗号分隔)',
`downloads` longtext COMMENT '下载地址列表(JSON)',
`version` varchar(50) NOT NULL DEFAULT '' COMMENT '版本号',
`req` varchar(100) NOT NULL DEFAULT '' COMMENT '系统 / 环境要求',
`sync_note` varchar(200) NOT NULL DEFAULT '' COMMENT '补全信息说明',
`synced_at` datetime DEFAULT NULL COMMENT '最后补全信息时间',
`feedback` longtext COMMENT '站点反馈说明',
`feedback_status` tinyint NOT NULL DEFAULT 0 COMMENT '反馈处理状态 0 未处理 / 1 已处理',
`feedback_time` int NOT NULL DEFAULT 0 COMMENT '最后反馈时间',
`status` tinyint NOT NULL DEFAULT 1 COMMENT '状态(1 启用 / 0 禁用)',
`create_time` int NOT NULL DEFAULT 0 COMMENT '创建时间(Unix 时间戳)',
`update_time` int NOT NULL DEFAULT 0 COMMENT '更新时间(Unix 时间戳)'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT '站点表' [ RunTime:0.000241s ]
CREATE TABLE IF NOT EXISTS `nav_like_log` (
`id` int unsigned NOT NULL AUTO_INCREMENT COMMENT '主键 ID', PRIMARY KEY (`id`),
`type` varchar(50) NOT NULL DEFAULT 'site' COMMENT '点赞对象类型(site 站点 / article 文章 / comment 评论)',
`target_id` int NOT NULL DEFAULT 0 COMMENT '关联对象 ID',
`ip` varchar(64) NOT NULL DEFAULT '' COMMENT '点赞者 IP',
`create_time` int NOT NULL DEFAULT 0 COMMENT '创建时间(Unix 时间戳)'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT '匿名点赞日志表' [ RunTime:0.000458s ]
CREATE TABLE IF NOT EXISTS `nav_site_view_day` (
`id` int unsigned NOT NULL AUTO_INCREMENT COMMENT '主键 ID', PRIMARY KEY (`id`),
`site_id` int NOT NULL DEFAULT 0 COMMENT '站点 ID',
`day` int NOT NULL DEFAULT 0 COMMENT '统计日期(YYYYMMDD)',
`views` int NOT NULL DEFAULT 0 COMMENT '总热度(浏览 + 点击汇总)',
`pv` int NOT NULL DEFAULT 0 COMMENT '详情页访问量',
`clicks` int NOT NULL DEFAULT 0 COMMENT '外链点击次数',
`views_m` int NOT NULL DEFAULT 0 COMMENT '手机端浏览数',
`views_d` int NOT NULL DEFAULT 0 COMMENT '电脑端浏览数',
`views_p` int NOT NULL DEFAULT 0 COMMENT '平板端浏览数',
`update_time` int NOT NULL DEFAULT 0 COMMENT '更新时间(Unix 时间戳)'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT '站点每日点击统计表' [ RunTime:0.000238s ]
CREATE TABLE IF NOT EXISTS `nav_site_health` (
`site_id` int NOT NULL COMMENT '站点 ID(主键,与 site 一一对应)',
`status` tinyint NOT NULL DEFAULT 0 COMMENT '状态(0 未检测 / 1 正常 / 2 受限 / 3 异常)',
`http_code` int NOT NULL DEFAULT 0 COMMENT 'HTTP 状态码(0 表示连接失败)',
`resp_ms` int NOT NULL DEFAULT 0 COMMENT '响应耗时(毫秒)',
`checked_at` int NOT NULL DEFAULT 0 COMMENT '最后检测时间(Unix 时间戳)',
`fail_count` int NOT NULL DEFAULT 0 COMMENT '连续失败次数',
`manual_status` tinyint NOT NULL DEFAULT 0 COMMENT '人工矫正状态(0 未矫正,其余同 status)',
`manual_time` int NOT NULL DEFAULT 0 COMMENT '人工矫正时间(Unix 时间戳)',
PRIMARY KEY (`site_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT '站点连通性检测结果表' [ RunTime:0.000211s ]
CREATE TABLE IF NOT EXISTS `nav_article_cat` (
`id` int unsigned NOT NULL AUTO_INCREMENT COMMENT '主键 ID', PRIMARY KEY (`id`),
`name` varchar(50) NOT NULL COMMENT '分类名称',
`slug` varchar(64) NOT NULL COMMENT 'URL 标识(英文唯一别名)',
`parent_id` int NOT NULL DEFAULT 0 COMMENT '上级分类 id,0=一级',
`is_rec` tinyint NOT NULL DEFAULT 0 COMMENT '是否首页推荐(1 是 / 0 否)',
`is_nav` tinyint NOT NULL DEFAULT 0 COMMENT '是否显示在导航(1 是 / 0 否)',
`is_list` tinyint NOT NULL DEFAULT 0 COMMENT '是否显示在文章列表分类标签栏(1 是 / 0 否)',
`icon` varchar(255) DEFAULT '' COMMENT '分类图标',
`color` varchar(64) DEFAULT '' COMMENT '分类主题色',
`sort` int NOT NULL DEFAULT 0 COMMENT '排序值(越大越靠前)',
`status` tinyint NOT NULL DEFAULT 1 COMMENT '状态(1 启用 / 0 禁用)',
`create_time` int NOT NULL DEFAULT 0 COMMENT '创建时间(Unix 时间戳)',
`update_time` int NOT NULL DEFAULT 0 COMMENT '更新时间(Unix 时间戳)'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT '文章分类表' [ RunTime:0.000258s ]
CREATE TABLE IF NOT EXISTS `nav_article_menu` (
`id` int unsigned NOT NULL AUTO_INCREMENT, PRIMARY KEY (`id`),
`parent_id` int NOT NULL DEFAULT 0,
`type` varchar(10) NOT NULL DEFAULT 'cat',
`cat_id` int NOT NULL DEFAULT 0,
`title` varchar(50) NOT NULL DEFAULT '',
`icon` varchar(255) DEFAULT '',
`color` varchar(64) DEFAULT '',
`title_color` varchar(64) DEFAULT '',
`url` varchar(500) DEFAULT '',
`target` varchar(10) NOT NULL DEFAULT '_self',
`sort` int NOT NULL DEFAULT 0,
`status` tinyint NOT NULL DEFAULT 1,
`hide_in_parent` tinyint NOT NULL DEFAULT 0,
`create_time` int NOT NULL DEFAULT 0,
`update_time` int NOT NULL DEFAULT 0
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci [ RunTime:0.000254s ]
CREATE TABLE IF NOT EXISTS `nav_article` (
`id` int unsigned NOT NULL AUTO_INCREMENT COMMENT '主键 ID', PRIMARY KEY (`id`),
`category_id` int NOT NULL DEFAULT 0 COMMENT '所属文章分类 ID',
`title` varchar(200) NOT NULL COMMENT '文章标题',
`cover` varchar(500) DEFAULT '' COMMENT '封面图地址',
`summary` varchar(500) DEFAULT '' COMMENT '文章摘要',
`content` longtext COMMENT '正文内容(HTML)',
`tags` varchar(255) DEFAULT '' COMMENT '标签(逗号分隔)',
`password` varchar(100) NOT NULL DEFAULT '' COMMENT '访问密码(留空不限制)',
`author` varchar(50) DEFAULT '' COMMENT '作者名',
`views` int NOT NULL DEFAULT 0 COMMENT '浏览次数',
`likes` int NOT NULL DEFAULT 0 COMMENT '点赞数',
`is_top` tinyint NOT NULL DEFAULT 0 COMMENT '是否置顶(1 是 / 0 否)',
`is_recommend` tinyint NOT NULL DEFAULT 0 COMMENT '是否推荐(1 是 / 0 否)',
`is_banner` tinyint NOT NULL DEFAULT 0 COMMENT '是否进入轮播(1 是 / 0 否)',
`banner_img` varchar(500) DEFAULT '' COMMENT '轮播图地址',
`banner_sub` varchar(200) DEFAULT '' COMMENT '轮播副标题',
`banner_sort` int NOT NULL DEFAULT 0 COMMENT '轮播排序值(越大越靠前)',
`tile_sort` int NOT NULL DEFAULT 0 COMMENT '首页磁贴排序值(越大越靠前)',
`points_on` tinyint NOT NULL DEFAULT 0,
`points_price` int NOT NULL DEFAULT 0,
`dl_on` tinyint NOT NULL DEFAULT 0 COMMENT '是否开启下载区(1 开 / 0 关)',
`dl_gate` varchar(20) NOT NULL DEFAULT 'public' COMMENT '下载门槛(comment 评论可见 / public 公开 / login 登录 / points 积分 / pay 付费)',
`dl_price` varchar(20) NOT NULL DEFAULT '0' COMMENT '单篇下载价格(元)',
`dl_vip` tinyint NOT NULL DEFAULT 0 COMMENT '是否会员免费(1 是 / 0 否)',
`dl_vip_price` varchar(20) NOT NULL DEFAULT '' COMMENT '会员优惠价(元)',
`dl_hours` int NOT NULL DEFAULT 0 COMMENT '解锁有效时长(小时,0 = 永久)',
`dl_tip` varchar(200) NOT NULL DEFAULT '' COMMENT '下载区提示文案',
`downloads` longtext COMMENT '下载项列表(JSON:平台 / 地址 / 提取码等)',
`dl_count` int NOT NULL DEFAULT 0 COMMENT '下载点击次数',
`comment_count` int NOT NULL DEFAULT 0 COMMENT '评论数量',
`remark` varchar(255) DEFAULT '' COMMENT '后台备注(仅管理员可见)',
`feedback` longtext COMMENT '读者反馈内容',
`feedback_status` tinyint NOT NULL DEFAULT 0 COMMENT '反馈处理状态(0 未处理 / 1 已处理)',
`feedback_time` int NOT NULL DEFAULT 0 COMMENT '反馈提交时间(Unix 时间戳)',
`status` tinyint NOT NULL DEFAULT 1 COMMENT '状态(1 已发布 / 0 草稿 / -1 回收站)',
`create_time` int NOT NULL DEFAULT 0 COMMENT '创建时间(Unix 时间戳)',
`update_time` int NOT NULL DEFAULT 0 COMMENT '更新时间(Unix 时间戳)'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT '文章表' [ RunTime:0.000333s ]
CREATE TABLE IF NOT EXISTS `nav_micro_post` (
`id` int unsigned NOT NULL AUTO_INCREMENT COMMENT '主键 ID', PRIMARY KEY (`id`),
`content` varchar(500) NOT NULL COMMENT '微语内容',
`author` varchar(50) DEFAULT '' COMMENT '发布者署名',
`sort` int NOT NULL DEFAULT 0 COMMENT '排序值(越大越靠前)',
`status` tinyint NOT NULL DEFAULT 1 COMMENT '状态(1 启用 / 0 禁用)',
`create_time` int NOT NULL DEFAULT 0 COMMENT '创建时间(Unix 时间戳)',
`update_time` int NOT NULL DEFAULT 0 COMMENT '更新时间(Unix 时间戳)'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT '微语表' [ RunTime:0.003241s ]
CREATE TABLE IF NOT EXISTS `nav_notice` (
`id` int unsigned NOT NULL AUTO_INCREMENT COMMENT '主键 ID', PRIMARY KEY (`id`),
`title` varchar(200) NOT NULL COMMENT '公告标题',
`content` text COMMENT '公告内容',
`type` varchar(50) DEFAULT 'info' COMMENT '公告类型(info 普通 / success 成功 / warning 警告)',
`sort` int NOT NULL DEFAULT 0 COMMENT '排序值(越大越靠前)',
`status` tinyint NOT NULL DEFAULT 1 COMMENT '状态(1 启用 / 0 禁用)',
`create_time` int NOT NULL DEFAULT 0 COMMENT '创建时间(Unix 时间戳)',
`update_time` int NOT NULL DEFAULT 0 COMMENT '更新时间(Unix 时间戳)'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT '公告表' [ RunTime:0.000351s ]
CREATE TABLE IF NOT EXISTS `nav_sponsor` (
`id` int unsigned NOT NULL AUTO_INCREMENT COMMENT '主键 ID', PRIMARY KEY (`id`),
`site_id` int NOT NULL DEFAULT 0 COMMENT '关联站点 ID',
`category_id` int NOT NULL DEFAULT 0 COMMENT '关联分类 ID',
`tag_id` int NOT NULL DEFAULT 0 COMMENT '关联标签 ID',
`name` varchar(100) NOT NULL COMMENT '赞助者名称',
`url` varchar(500) DEFAULT '' COMMENT '赞助者链接',
`icon` varchar(500) DEFAULT '' COMMENT '赞助者图标',
`cover` varchar(500) DEFAULT '' COMMENT '封面图地址',
`email` varchar(100) DEFAULT '' COMMENT '赞助者邮箱',
`message` varchar(200) DEFAULT '' COMMENT '赞助留言',
`ip` varchar(64) NOT NULL DEFAULT '' COMMENT '提交者 IP',
`order_no` varchar(64) DEFAULT '' COMMENT '最近订单号',
`pay_channel` varchar(20) DEFAULT '' COMMENT '支付渠道',
`pay_trade_no` varchar(64) DEFAULT '' COMMENT '支付平台交易号',
`pay_time` int NOT NULL DEFAULT 0 COMMENT '最近支付时间(Unix 时间戳)',
`amount` int NOT NULL DEFAULT 0 COMMENT '累计赞助金额(元)',
`sort` int NOT NULL DEFAULT 0 COMMENT '排序值(越大越靠前)',
`status` tinyint NOT NULL DEFAULT 1 COMMENT '状态(1 启用 / 0 禁用)',
`create_time` int NOT NULL DEFAULT 0 COMMENT '创建时间(Unix 时间戳)',
`update_time` int NOT NULL DEFAULT 0 COMMENT '更新时间(Unix 时间戳)'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT '赞助者表' [ RunTime:0.000264s ]
CREATE TABLE IF NOT EXISTS `nav_sponsor_order` (
`id` int unsigned NOT NULL AUTO_INCREMENT COMMENT '主键 ID', PRIMARY KEY (`id`),
`order_no` varchar(64) NOT NULL COMMENT '订单号',
`sponsor_id` int NOT NULL DEFAULT 0 COMMENT '赞助者记录 ID',
`site_id` int NOT NULL DEFAULT 0 COMMENT '关联站点 ID',
`amount` int NOT NULL DEFAULT 0 COMMENT '实付金额(元)',
`base_amount` int NOT NULL DEFAULT 0 COMMENT '赞助本金(元,不含收录等附加费)',
`forever` tinyint NOT NULL DEFAULT 0 COMMENT '是否永久收录(1 是 / 0 否)',
`include_site` tinyint NOT NULL DEFAULT 0 COMMENT '是否勾选收录站点(1 是 / 0 否)',
`pay_channel` varchar(20) DEFAULT '' COMMENT '支付渠道',
`pay_trade_no` varchar(64) DEFAULT '' COMMENT '支付平台交易号',
`pay_time` int NOT NULL DEFAULT 0 COMMENT '支付时间(Unix 时间戳)',
`remark` varchar(200) DEFAULT '' COMMENT '订单备注',
`ip` varchar(64) NOT NULL DEFAULT '' COMMENT '下单 IP',
`status` tinyint NOT NULL DEFAULT 0 COMMENT '状态(0 未支付 / 1 已支付)',
`create_time` int NOT NULL DEFAULT 0 COMMENT '创建时间(Unix 时间戳)',
`update_time` int NOT NULL DEFAULT 0 COMMENT '更新时间(Unix 时间戳)'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT '赞助订单表' [ RunTime:0.000427s ]
CREATE TABLE IF NOT EXISTS `nav_link` (
`id` int unsigned NOT NULL AUTO_INCREMENT COMMENT '主键 ID', PRIMARY KEY (`id`),
`pid` int NOT NULL DEFAULT 0 COMMENT '上级链接 ID(0 = 顶级)',
`position` varchar(50) NOT NULL DEFAULT 'top' COMMENT '显示位置(top 顶部 / footer 底部 等)',
`name` varchar(50) NOT NULL COMMENT '链接名称',
`name_color` varchar(50) DEFAULT '',
`icon` varchar(255) DEFAULT '' COMMENT '链接图标',
`url` varchar(500) DEFAULT '' COMMENT '链接地址',
`description` varchar(200) DEFAULT '' COMMENT '链接描述',
`badge` varchar(50) DEFAULT '' COMMENT '角标文字',
`target` tinyint NOT NULL DEFAULT 0 COMMENT '打开方式(1 新窗口 / 0 当前窗口)',
`sort` int NOT NULL DEFAULT 0 COMMENT '排序值(越大越靠前)',
`status` tinyint NOT NULL DEFAULT 1 COMMENT '状态(1 启用 / 0 禁用)',
`create_time` int NOT NULL DEFAULT 0 COMMENT '创建时间(Unix 时间戳)',
`update_time` int NOT NULL DEFAULT 0 COMMENT '更新时间(Unix 时间戳)'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT '导航链接表' [ RunTime:0.000221s ]
CREATE TABLE IF NOT EXISTS `nav_submit` (
`id` int unsigned NOT NULL AUTO_INCREMENT COMMENT '主键 ID', PRIMARY KEY (`id`),
`name` varchar(100) NOT NULL COMMENT '站点名称',
`url` varchar(500) NOT NULL COMMENT '站点地址',
`category_id` int NOT NULL DEFAULT 0 COMMENT '申请分类 ID',
`tag_id` int NOT NULL DEFAULT 0 COMMENT '申请标签 ID',
`icon` varchar(500) DEFAULT '' COMMENT '站点图标',
`cover` varchar(500) DEFAULT '' COMMENT '封面图地址',
`description` varchar(500) DEFAULT '' COMMENT '站点简介',
`content` longtext COMMENT '站点详情内容',
`tags` varchar(255) DEFAULT '' COMMENT '标签(逗号分隔)',
`badge` varchar(200) DEFAULT '' COMMENT '角标文字',
`contact` varchar(100) NOT NULL DEFAULT '' COMMENT '提交者联系方式',
`remark` varchar(200) DEFAULT '' COMMENT '提交备注',
`status` tinyint NOT NULL DEFAULT 0 COMMENT '状态(0 待审核 / 1 已通过 / 2 已驳回)',
`amount` decimal(10,2) NOT NULL DEFAULT 0 COMMENT '收录费用(元)',
`order_no` varchar(64) DEFAULT '' COMMENT '付费订单号',
`pay_method` varchar(50) DEFAULT '' COMMENT '支付方式',
`pay_channel` varchar(20) DEFAULT '' COMMENT '支付渠道',
`pay_trade_no` varchar(64) DEFAULT '' COMMENT '支付平台交易号',
`pay_time` int NOT NULL DEFAULT 0 COMMENT '支付时间(Unix 时间戳)',
`site_id` int NOT NULL DEFAULT 0 COMMENT '审核通过后生成的站点 ID',
`audit_time` int NOT NULL DEFAULT 0 COMMENT '审核时间(Unix 时间戳)',
`ip` varchar(64) NOT NULL DEFAULT '' COMMENT '提交者 IP',
`user_id` int NOT NULL DEFAULT 0 COMMENT '提交用户 ID(0 = 游客)',
`create_time` int NOT NULL DEFAULT 0 COMMENT '创建时间(Unix 时间戳)',
`update_time` int NOT NULL DEFAULT 0 COMMENT '更新时间(Unix 时间戳)'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT '站点提交收录表' [ RunTime:0.000282s ]
CREATE TABLE IF NOT EXISTS `nav_qlink` (
`id` int unsigned NOT NULL AUTO_INCREMENT COMMENT '主键 ID', PRIMARY KEY (`id`),
`name` varchar(50) DEFAULT '' COMMENT '显示名称,留空自动取对象名称',
`subtitle` varchar(200) DEFAULT '' COMMENT '副标题',
`type` varchar(20) NOT NULL DEFAULT 'cat' COMMENT 'cat 分类 / site 站点 / url 链接',
`folder_kind` varchar(20) DEFAULT '' COMMENT '文件夹样式类型',
`folder_cats` varchar(500) DEFAULT '',
`folder_sort` varchar(20) DEFAULT 'new',
`folder_limit` int NOT NULL DEFAULT 0,
`folder_cache` int NOT NULL DEFAULT 300,
`folder_inc_sub` tinyint NOT NULL DEFAULT 0,
`cat_id` int NOT NULL DEFAULT 0 COMMENT '关联分类 ID',
`site_id` int NOT NULL DEFAULT 0 COMMENT '关联站点 ID',
`url` varchar(500) DEFAULT '' COMMENT '自定义链接地址',
`icon` varchar(500) DEFAULT '' COMMENT '图标地址',
`extra` varchar(64) DEFAULT '' COMMENT '右侧小字',
`cover` varchar(500) DEFAULT '' COMMENT '封面图地址',
`bg_style` varchar(32) DEFAULT '' COMMENT '背景样式(CSS)',
`name_color` varchar(32) DEFAULT '' COMMENT '名称文字颜色',
`extra_color` varchar(32) DEFAULT '' COMMENT '小字文字颜色',
`target` tinyint NOT NULL DEFAULT 0 COMMENT '打开方式(1 新窗口 / 0 当前窗口)',
`sort` int NOT NULL DEFAULT 0 COMMENT '排序值(越大越靠前)',
`status` tinyint NOT NULL DEFAULT 1 COMMENT '状态(1 启用 / 0 禁用)',
`create_time` int NOT NULL DEFAULT 0 COMMENT '创建时间(Unix 时间戳)',
`update_time` int NOT NULL DEFAULT 0 COMMENT '更新时间(Unix 时间戳)'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT '桌面快捷链接表' [ RunTime:0.000288s ]
CREATE TABLE IF NOT EXISTS `nav_qlink_item` (
`id` int unsigned NOT NULL AUTO_INCREMENT COMMENT '主键 ID', PRIMARY KEY (`id`),
`qlink_id` int NOT NULL DEFAULT 0 COMMENT '所属快捷链接 ID',
`kind` varchar(20) NOT NULL DEFAULT 'site' COMMENT '子项类型(site 站点 / cat 分类 / url 链接)',
`ref_id` int NOT NULL DEFAULT 0 COMMENT '子项对象 ID',
`sort` int NOT NULL DEFAULT 0 COMMENT '排序值(越大越靠前)',
`create_time` int NOT NULL DEFAULT 0 COMMENT '创建时间(Unix 时间戳)'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT '快捷链接子项表' [ RunTime:0.000200s ]
CREATE TABLE IF NOT EXISTS `nav_ad` (
`id` int unsigned NOT NULL AUTO_INCREMENT COMMENT '主键 ID', PRIMARY KEY (`id`),
`position` varchar(20) NOT NULL DEFAULT 'home_banner' COMMENT '广告位标识(如 home_banner / article_top)',
`title` varchar(100) NOT NULL COMMENT '广告标题',
`subtitle` varchar(200) DEFAULT '' COMMENT '广告副标题',
`icon` varchar(500) DEFAULT '' COMMENT '图标地址',
`image` varchar(500) DEFAULT '' COMMENT '背景图片地址',
`url` varchar(500) DEFAULT '' COMMENT '点击跳转链接',
`btn_text` varchar(50) DEFAULT '' COMMENT '按钮文字',
`theme` varchar(20) DEFAULT '' COMMENT '主题风格标识',
`badge` varchar(50) DEFAULT '' COMMENT '角标文字(如 热门 / 新)',
`plan_id` int NOT NULL DEFAULT 0 COMMENT '关联广告套餐 ID',
`months` int NOT NULL DEFAULT 1 COMMENT '购买时长(月)',
`gift_days` int NOT NULL DEFAULT 0 COMMENT '赠送天数',
`unit_price` decimal(10,2) NOT NULL DEFAULT 0 COMMENT '广告单价(元/月)',
`amount` decimal(10,2) NOT NULL DEFAULT 0 COMMENT '订单金额(元)',
`order_no` varchar(64) DEFAULT '' COMMENT '订单号',
`pay_method` varchar(50) DEFAULT '' COMMENT '支付方式',
`pay_channel` varchar(20) DEFAULT '' COMMENT '支付渠道',
`pay_trade_no` varchar(64) DEFAULT '' COMMENT '支付平台交易号',
`pay_time` int NOT NULL DEFAULT 0 COMMENT '支付时间(Unix 时间戳)',
`start_time` int NOT NULL DEFAULT 0 COMMENT '投放开始时间(Unix 时间戳)',
`end_time` int NOT NULL DEFAULT 0 COMMENT '投放结束时间(Unix 时间戳)',
`audit_time` int NOT NULL DEFAULT 0 COMMENT '审核时间(Unix 时间戳)',
`contact` varchar(100) NOT NULL DEFAULT '' COMMENT '联系人',
`company` varchar(100) DEFAULT '' COMMENT '公司 / 主体名称',
`remark` varchar(255) DEFAULT '' COMMENT '用户提交的备注',
`admin_note` varchar(255) DEFAULT '' COMMENT '管理员审核备注',
`status` tinyint NOT NULL DEFAULT 0 COMMENT '状态(0 待审核 / 1 待付款 / 2 投放中 / 3 已驳回 / 4 已到期 / 5 已下架 / 6 已付款待审核)',
`sort` int NOT NULL DEFAULT 0 COMMENT '排序值(越大越靠前)',
`views` int NOT NULL DEFAULT 0 COMMENT '广告曝光次数',
`clicks` int NOT NULL DEFAULT 0 COMMENT '广告点击次数',
`ip` varchar(64) NOT NULL DEFAULT '' COMMENT '提交者 IP',
`create_time` int NOT NULL DEFAULT 0 COMMENT '创建时间(Unix 时间戳)',
`update_time` int NOT NULL DEFAULT 0 COMMENT '更新时间(Unix 时间戳)'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT '广告位投放 / 申请记录表' [ RunTime:0.000306s ]
CREATE TABLE IF NOT EXISTS `nav_ad_plan` (
`id` int unsigned NOT NULL AUTO_INCREMENT COMMENT '主键 ID', PRIMARY KEY (`id`),
`name` varchar(50) NOT NULL COMMENT '套餐名称',
`months` int NOT NULL DEFAULT 1 COMMENT '套餐时长(月)',
`price` decimal(10,2) NOT NULL DEFAULT 0 COMMENT '套餐价格(元/月)',
`gift_days` int NOT NULL DEFAULT 0 COMMENT '赠送天数',
`position` varchar(20) NOT NULL DEFAULT 'home_banner' COMMENT '适用广告位标识',
`description` varchar(255) DEFAULT '' COMMENT '套餐说明',
`badge` varchar(50) DEFAULT '' COMMENT '角标文字',
`sort` int NOT NULL DEFAULT 0 COMMENT '排序值(越大越靠前)',
`status` tinyint NOT NULL DEFAULT 1 COMMENT '状态(1 上架 / 0 下架)',
`create_time` int NOT NULL DEFAULT 0 COMMENT '创建时间(Unix 时间戳)',
`update_time` int NOT NULL DEFAULT 0 COMMENT '更新时间(Unix 时间戳)'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT '广告投放套餐表' [ RunTime:0.000214s ]
CREATE TABLE IF NOT EXISTS `nav_friend_link` (
`id` int unsigned NOT NULL AUTO_INCREMENT COMMENT '主键 ID', PRIMARY KEY (`id`),
`name` varchar(100) NOT NULL COMMENT '网站名称',
`url` varchar(500) NOT NULL COMMENT '网站地址',
`icon` varchar(500) DEFAULT '' COMMENT '网站图标地址',
`name_color` varchar(64) DEFAULT '' COMMENT '友链名称颜色',
`icon_color` varchar(64) DEFAULT '' COMMENT '友链图标颜色',
`description` varchar(200) DEFAULT '' COMMENT '网站简介',
`contact` varchar(100) NOT NULL DEFAULT '' COMMENT '联系方式',
`remark` varchar(200) DEFAULT '' COMMENT '申请备注',
`admin_note` varchar(200) DEFAULT '' COMMENT '管理员备注',
`amount` decimal(10,2) NOT NULL DEFAULT 0 COMMENT '友链费用(元)',
`order_no` varchar(64) DEFAULT '' COMMENT '付费订单号',
`pay_method` varchar(50) DEFAULT '' COMMENT '支付方式',
`pay_channel` varchar(20) DEFAULT '' COMMENT '支付渠道',
`pay_trade_no` varchar(64) DEFAULT '' COMMENT '支付平台交易号',
`pay_time` int NOT NULL DEFAULT 0 COMMENT '支付时间(Unix 时间戳)',
`audit_time` int NOT NULL DEFAULT 0 COMMENT '审核时间(Unix 时间戳)',
`status` tinyint NOT NULL DEFAULT 0 COMMENT '状态(0 待审核 / 1 已通过 / 2 已驳回,是否付款看 pay_time)',
`sort` int NOT NULL DEFAULT 0 COMMENT '排序值(越大越靠前)',
`ip` varchar(64) NOT NULL DEFAULT '' COMMENT '申请者 IP',
`create_time` int NOT NULL DEFAULT 0 COMMENT '创建时间(Unix 时间戳)',
`update_time` int NOT NULL DEFAULT 0 COMMENT '更新时间(Unix 时间戳)'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT '友情链接申请表' [ RunTime:0.000245s ]
CREATE TABLE IF NOT EXISTS `nav_dock` (
`id` int unsigned NOT NULL AUTO_INCREMENT COMMENT '主键 ID', PRIMARY KEY (`id`),
`name` varchar(50) DEFAULT '' COMMENT '图标名称',
`type` varchar(20) NOT NULL DEFAULT 'url' COMMENT '类型(url 自定义链接 / site 站点 / cat 分类 / tag 标签)',
`site_id` int NOT NULL DEFAULT 0 COMMENT '关联站点 ID',
`cat_id` int NOT NULL DEFAULT 0 COMMENT '关联分类 ID',
`tag_id` int NOT NULL DEFAULT 0 COMMENT '关联标签 ID',
`url` varchar(500) DEFAULT '' COMMENT '自定义链接地址',
`icon` varchar(500) DEFAULT '' COMMENT '图标地址',
`image` varchar(500) DEFAULT '' COMMENT '背景图片地址',
`desc` varchar(500) DEFAULT '' COMMENT '描述文字',
`extra` varchar(64) DEFAULT '' COMMENT '右下角小字 / 角标',
`target` tinyint NOT NULL DEFAULT 0 COMMENT '打开方式(1 新窗口 / 0 当前窗口)',
`sort` int NOT NULL DEFAULT 0 COMMENT '排序值(越大越靠前)',
`status` tinyint NOT NULL DEFAULT 1 COMMENT '状态(1 启用 / 0 禁用)',
`create_time` int NOT NULL DEFAULT 0 COMMENT '创建时间(Unix 时间戳)',
`update_time` int NOT NULL DEFAULT 0 COMMENT '更新时间(Unix 时间戳)'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT '桌面 Dock / 底栏图标表' [ RunTime:0.000997s ]
CREATE TABLE IF NOT EXISTS `nav_plugin` (
`id` int unsigned NOT NULL AUTO_INCREMENT COMMENT '主键 ID', PRIMARY KEY (`id`),
`slug` varchar(64) NOT NULL DEFAULT '' COMMENT '插件标识(英文唯一 key)',
`type` varchar(20) NOT NULL DEFAULT 'local' COMMENT '插件类型(local 本地 / remote 远程)',
`name` varchar(100) NOT NULL DEFAULT '' COMMENT '插件名称',
`icon` varchar(100) NOT NULL DEFAULT '' COMMENT '插件图标(Bootstrap Icons 类名)',
`icon_url` varchar(500) NOT NULL DEFAULT '' COMMENT '图标图片外链地址',
`cover` varchar(500) NOT NULL DEFAULT '' COMMENT '封面图地址',
`url` varchar(500) NOT NULL DEFAULT '' COMMENT '插件访问链接',
`category` varchar(20) NOT NULL DEFAULT 'life' COMMENT '插件分类(life / tool 等)',
`color` varchar(20) NOT NULL DEFAULT '' COMMENT '主题色',
`badge` varchar(20) NOT NULL DEFAULT '' COMMENT '角标文字',
`description` varchar(200) NOT NULL DEFAULT '' COMMENT '插件简介',
`version` varchar(20) NOT NULL DEFAULT '' COMMENT '版本号',
`backend` tinyint NOT NULL DEFAULT 0 COMMENT '是否有后台管理入口(1 是 / 0 否)',
`need_login` tinyint NOT NULL DEFAULT 0 COMMENT '是否需要登录(1 是 / 0 否)',
`points_cost` int NOT NULL DEFAULT 0 COMMENT '每次打开消耗积分',
`sort` int NOT NULL DEFAULT 0 COMMENT '排序值(越大越靠前)',
`status` tinyint NOT NULL DEFAULT 1 COMMENT '状态(1 启用 / 0 禁用)',
`create_time` int NOT NULL DEFAULT 0 COMMENT '创建时间(Unix 时间戳)',
`update_time` int NOT NULL DEFAULT 0 COMMENT '更新时间(Unix 时间戳)'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT '插件表' [ RunTime:0.000537s ]
CREATE TABLE IF NOT EXISTS `nav_dypage` (
`id` int unsigned NOT NULL AUTO_INCREMENT COMMENT '主键 ID', PRIMARY KEY (`id`),
`title` varchar(200) NOT NULL DEFAULT '' COMMENT '单页标题(也作页面 title)',
`alias` varchar(64) NOT NULL DEFAULT '' COMMENT '别名,留空则用 id 访问',
`template` varchar(50) NOT NULL DEFAULT 'wdhkbpage' COMMENT '模板:无导航空白模板',
`content` longtext COMMENT '单页内容(HTML)',
`referer_on` tinyint NOT NULL DEFAULT 1 COMMENT '是否开启 referer 校验',
`referer_flag` varchar(255) NOT NULL DEFAULT '' COMMENT '来源判断标志(非必填)',
`pwd_fail_on` tinyint NOT NULL DEFAULT 0 COMMENT '是否开启密码错误转发',
`pwd_fail_url` varchar(500) NOT NULL DEFAULT '' COMMENT '密码错误转发链接(非必填)',
`password` varchar(100) NOT NULL DEFAULT '' COMMENT '访问密码(非必填)',
`password_tip` varchar(200) NOT NULL DEFAULT '' COMMENT '访问密码提示(非必填)',
`owner` varchar(100) NOT NULL DEFAULT '' COMMENT '单页所属用户(非必填)',
`sort` int NOT NULL DEFAULT 0 COMMENT '排序值(越大越靠前)',
`status` tinyint NOT NULL DEFAULT 1 COMMENT '状态(1 启用 / 0 禁用)',
`create_time` int NOT NULL DEFAULT 0 COMMENT '创建时间(Unix 时间戳)',
`update_time` int NOT NULL DEFAULT 0 COMMENT '更新时间(Unix 时间戳)'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT '自定义单页表' [ RunTime:0.000259s ]
CREATE TABLE IF NOT EXISTS `nav_devphase` (
`id` int unsigned NOT NULL AUTO_INCREMENT COMMENT '主键 ID', PRIMARY KEY (`id`),
`code` varchar(20) NOT NULL DEFAULT '' COMMENT '阶段标识(英文)',
`name` varchar(200) NOT NULL DEFAULT '' COMMENT '阶段名称',
`days_range` varchar(200) NOT NULL DEFAULT '' COMMENT '天数范围(如 1-30)',
`icon` varchar(200) NOT NULL DEFAULT '' COMMENT '阶段图标',
`note` varchar(500) NOT NULL DEFAULT '' COMMENT '阶段说明',
`sort` int NOT NULL DEFAULT 0 COMMENT '排序值(越大越靠前)',
`status` tinyint NOT NULL DEFAULT 1 COMMENT '状态(1 启用 / 0 禁用)',
`create_time` int NOT NULL DEFAULT 0 COMMENT '创建时间(Unix 时间戳)',
`update_time` int NOT NULL DEFAULT 0 COMMENT '更新时间(Unix 时间戳)'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT '开发阶段表' [ RunTime:0.000225s ]
CREATE TABLE IF NOT EXISTS `nav_devlog` (
`id` int unsigned NOT NULL AUTO_INCREMENT COMMENT '主键 ID', PRIMARY KEY (`id`),
`day` int NOT NULL DEFAULT 0 COMMENT '开发第几天(如 89)',
`phase` varchar(20) NOT NULL DEFAULT 'start' COMMENT '所属阶段标识(对应 nav_devphase.code)',
`title` varchar(200) NOT NULL DEFAULT '' COMMENT '日志标题',
`summary` varchar(500) NOT NULL DEFAULT '' COMMENT '日志摘要',
`items` longtext COMMENT '当日完成条目(JSON / 换行文本)',
`tags` varchar(200) NOT NULL DEFAULT '' COMMENT '标签(逗号分隔)',
`log_date` varchar(20) NOT NULL DEFAULT '' COMMENT '记录日期(Y-m-d)',
`sort` int NOT NULL DEFAULT 0 COMMENT '排序值(越大越靠前)',
`status` tinyint NOT NULL DEFAULT 1 COMMENT '状态(1 启用 / 0 禁用)',
`create_time` int NOT NULL DEFAULT 0 COMMENT '创建时间(Unix 时间戳)',
`update_time` int NOT NULL DEFAULT 0 COMMENT '更新时间(Unix 时间戳)'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT '开发日志表' [ RunTime:0.000425s ]
CREATE TABLE IF NOT EXISTS `nav_api_log` (
`id` int unsigned NOT NULL AUTO_INCREMENT COMMENT '主键 ID', PRIMARY KEY (`id`),
`user_id` int NOT NULL DEFAULT 0 COMMENT '用户ID',
`api_type` int NOT NULL DEFAULT 0 COMMENT '套餐类型:1包月 2包点',
`api_token` varchar(200) DEFAULT '' COMMENT 'API Token',
`token_id` int NOT NULL DEFAULT 0 COMMENT 'Token ID',
`token_name` varchar(200) DEFAULT '' COMMENT 'Token名称',
`channel_key` varchar(50) DEFAULT '' COMMENT '渠道标识',
`channel_name` varchar(100) DEFAULT '' COMMENT '渠道名称',
`request_ip` varchar(64) DEFAULT '' COMMENT '请求IP',
`request_data` longtext COMMENT '请求数据',
`response_data` longtext COMMENT '响应数据',
`status` tinyint NOT NULL DEFAULT 1 COMMENT '状态:0失败 1成功',
`error_msg` longtext COMMENT '错误信息',
`response_time` int NOT NULL DEFAULT 0 COMMENT '响应时间(ms)',
`remark` varchar(200) DEFAULT '' COMMENT '备注',
`create_time` int NOT NULL DEFAULT 0 COMMENT '创建时间(Unix 时间戳)',
`update_time` int NOT NULL DEFAULT 0 COMMENT '更新时间(Unix 时间戳)'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT 'API 接口调用日志表' [ RunTime:0.000236s ]
CREATE TABLE IF NOT EXISTS `nav_user` (
`id` int unsigned NOT NULL AUTO_INCREMENT COMMENT '主键 ID', PRIMARY KEY (`id`),
`username` varchar(50) NOT NULL DEFAULT '' COMMENT '用户名',
`email` varchar(100) NOT NULL DEFAULT '' COMMENT '邮箱',
`phone` varchar(20) NOT NULL DEFAULT '' COMMENT '手机号',
`password` varchar(255) NOT NULL DEFAULT '' COMMENT '登录密码(哈希存储)',
`nickname` varchar(50) NOT NULL DEFAULT '' COMMENT '昵称',
`avatar` varchar(500) NOT NULL DEFAULT '' COMMENT '头像地址',
`level` tinyint NOT NULL DEFAULT 0 COMMENT '用户等级',
`vip_expire` int NOT NULL DEFAULT 0 COMMENT '会员到期时间(Unix 时间戳,0 = 非会员)',
`webmaster_expire` int NOT NULL DEFAULT 0 COMMENT '站长认证到期时间(Unix 时间戳)',
`points` int NOT NULL DEFAULT 0 COMMENT '剩余积分',
`email_verified` tinyint NOT NULL DEFAULT 0 COMMENT '邮箱是否已验证(1 是 / 0 否)',
`status` tinyint NOT NULL DEFAULT 1 COMMENT '状态(1 正常 / 0 禁用)',
`reg_ip` varchar(64) NOT NULL DEFAULT '' COMMENT '注册 IP',
`last_login_ip` varchar(64) NOT NULL DEFAULT '' COMMENT '最后登录 IP',
`last_login_time` int NOT NULL DEFAULT 0 COMMENT '最后登录时间(Unix 时间戳)',
`create_time` int NOT NULL DEFAULT 0 COMMENT '创建时间(Unix 时间戳)',
`update_time` int NOT NULL DEFAULT 0 COMMENT '更新时间(Unix 时间戳)'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT '前台用户表' [ RunTime:0.000246s ]
CREATE TABLE IF NOT EXISTS `nav_user_token` (
`id` int unsigned NOT NULL AUTO_INCREMENT COMMENT '主键 ID', PRIMARY KEY (`id`),
`user_id` int NOT NULL DEFAULT 0 COMMENT '用户 ID',
`token_hash` varchar(64) NOT NULL DEFAULT '' COMMENT '登录令牌哈希',
`ip` varchar(64) NOT NULL DEFAULT '' COMMENT '登录 IP',
`ua` varchar(200) NOT NULL DEFAULT '' COMMENT '浏览器 UA',
`expire_time` int NOT NULL DEFAULT 0 COMMENT '过期时间(Unix 时间戳)',
`last_active` int NOT NULL DEFAULT 0 COMMENT '最后活跃时间(Unix 时间戳)',
`create_time` int NOT NULL DEFAULT 0 COMMENT '创建时间(Unix 时间戳)'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT '用户登录令牌表' [ RunTime:0.000296s ]
CREATE TABLE IF NOT EXISTS `nav_user_favorite` (
`id` int unsigned NOT NULL AUTO_INCREMENT COMMENT '主键 ID', PRIMARY KEY (`id`),
`user_id` int NOT NULL DEFAULT 0 COMMENT '用户 ID',
`type` varchar(20) NOT NULL DEFAULT 'site' COMMENT '对象类型(site 站点 / article 文章)',
`target_id` int NOT NULL DEFAULT 0 COMMENT '收藏对象 ID',
`ip` varchar(64) NOT NULL DEFAULT '' COMMENT '操作 IP',
`create_time` int NOT NULL DEFAULT 0 COMMENT '创建时间(Unix 时间戳)'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT '用户收藏表' [ RunTime:0.000287s ]
CREATE TABLE IF NOT EXISTS `nav_user_quick` (
`id` int unsigned NOT NULL AUTO_INCREMENT COMMENT '主键 ID', PRIMARY KEY (`id`),
`user_id` int NOT NULL DEFAULT 0 COMMENT '用户 ID',
`url` varchar(500) NOT NULL DEFAULT '' COMMENT '快捷入口链接',
`url_key` varchar(200) NOT NULL DEFAULT '' COMMENT '链接归一化键(去重 / 匹配用)',
`title` varchar(100) NOT NULL DEFAULT '' COMMENT '显示标题',
`icon` varchar(500) NOT NULL DEFAULT '' COMMENT '图标地址',
`description` varchar(200) NOT NULL DEFAULT '' COMMENT '描述文字',
`badge` varchar(20) NOT NULL DEFAULT '' COMMENT '角标文字',
`platforms` varchar(100) NOT NULL DEFAULT '' COMMENT '支持平台(逗号分隔)',
`sort` int NOT NULL DEFAULT 0 COMMENT '排序值(越大越靠前)',
`create_time` int NOT NULL DEFAULT 0 COMMENT '创建时间(Unix 时间戳)',
`update_time` int NOT NULL DEFAULT 0 COMMENT '更新时间(Unix 时间戳)'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT '用户快捷入口表' [ RunTime:0.000243s ]
CREATE TABLE IF NOT EXISTS `nav_user_dock` (
`id` int unsigned NOT NULL AUTO_INCREMENT COMMENT '主键 ID', PRIMARY KEY (`id`),
`user_id` int NOT NULL DEFAULT 0 COMMENT '用户 ID',
`source` varchar(20) NOT NULL DEFAULT 'custom' COMMENT '来源(custom 手动添加 / fav 收藏自动加入)',
`type` varchar(20) NOT NULL DEFAULT 'url' COMMENT '类型(url 网址 / site 站点 / article 文章)',
`target_id` int NOT NULL DEFAULT 0 COMMENT '关联对象 ID(站点 / 文章)',
`url` varchar(500) NOT NULL DEFAULT '' COMMENT '跳转链接',
`url_key` varchar(200) NOT NULL DEFAULT '' COMMENT '归一化去重键',
`name` varchar(100) NOT NULL DEFAULT '' COMMENT '显示名称',
`desc` varchar(200) NOT NULL DEFAULT '' COMMENT '描述文字',
`icon` varchar(500) NOT NULL DEFAULT '' COMMENT '图标地址',
`badge` varchar(20) NOT NULL DEFAULT '' COMMENT '角标文字',
`sort` int NOT NULL DEFAULT 0 COMMENT '排序值(升序)',
`create_time` int NOT NULL DEFAULT 0 COMMENT '创建时间(Unix 时间戳)',
`update_time` int NOT NULL DEFAULT 0 COMMENT '更新时间(Unix 时间戳)'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT '用户 Dock 表' [ RunTime:0.000269s ]
CREATE TABLE IF NOT EXISTS `nav_user_note` (
`id` int unsigned NOT NULL AUTO_INCREMENT COMMENT '主键 ID', PRIMARY KEY (`id`),
`user_id` int NOT NULL DEFAULT 0 COMMENT '用户 ID',
`note_id` varchar(50) NOT NULL DEFAULT '' COMMENT '便签唯一标识(前端生成)',
`title` varchar(200) NOT NULL DEFAULT '' COMMENT '便签标题',
`content` longtext NULL COMMENT '便签内容',
`color` varchar(64) NOT NULL DEFAULT '' COMMENT '便签颜色',
`pinned` tinyint NOT NULL DEFAULT 0 COMMENT '是否固定(1 是 / 0 否)',
`front` tinyint NOT NULL DEFAULT 0 COMMENT '是否置顶显示(1 是 / 0 否)',
`fx` varchar(20) NOT NULL DEFAULT '' COMMENT '便签横向坐标',
`fy` varchar(20) NOT NULL DEFAULT '' COMMENT '便签纵向坐标',
`w` int NOT NULL DEFAULT 0 COMMENT '便签宽度',
`h` int NOT NULL DEFAULT 0 COMMENT '便签高度',
`created` bigint NOT NULL DEFAULT 0 COMMENT '创建时间(毫秒时间戳)',
`updated` bigint NOT NULL DEFAULT 0 COMMENT '内容更新时间(毫秒时间戳)',
`layout_updated` bigint NOT NULL DEFAULT 0 COMMENT '布局最后更新时间(毫秒时间戳)',
`update_time` int NOT NULL DEFAULT 0 COMMENT '记录更新时间(Unix 时间戳)'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT '用户便签表' [ RunTime:0.000259s ]
CREATE TABLE IF NOT EXISTS `nav_fx_url` (
`id` int unsigned NOT NULL AUTO_INCREMENT COMMENT '主键 ID', PRIMARY KEY (`id`),
`slug` varchar(32) NOT NULL DEFAULT '' COMMENT '自定义地址(全局唯一)',
`title` varchar(200) NOT NULL DEFAULT '' COMMENT '标题(留空时取正文首行)',
`content` longtext NULL COMMENT '正文(Markdown / 纯文本原文)',
`fmt` varchar(10) NOT NULL DEFAULT 'md' COMMENT '格式(md / txt)',
`pass_hash` varchar(255) NOT NULL DEFAULT '' COMMENT '访问密码哈希(password_hash,空 = 公开访问)',
`pass_view` varchar(255) NOT NULL DEFAULT '' COMMENT '访问密码回显密文(AES-256-GCM / HMAC 流,仅作者可解密查看)',
`edit_key_hash` varchar(64) NOT NULL DEFAULT '' COMMENT '编辑密钥哈希(sha256,明文仅创建时返回一次)',
`user_id` int NOT NULL DEFAULT 0 COMMENT '创建者用户 ID(0 = 匿名)',
`ip` varchar(64) NOT NULL DEFAULT '' COMMENT '创建 IP',
`views` int NOT NULL DEFAULT 0 COMMENT '访问次数',
`view_time` int NOT NULL DEFAULT 0 COMMENT '最后预览时间(Unix 时间戳,0 = 还没人访问过)',
`status` tinyint NOT NULL DEFAULT 1 COMMENT '状态(1 正常 / 0 已删除)',
`notified` tinyint NOT NULL DEFAULT 0 COMMENT '发布通知标记(0 未通知 / 1 已通知,首次填写正文时通知管理员一次)',
`expire_time` int NOT NULL DEFAULT 0 COMMENT '过期时间(Unix 时间戳,0 = 永久)',
`create_time` int NOT NULL DEFAULT 0 COMMENT '创建时间',
`update_time` int NOT NULL DEFAULT 0 COMMENT '更新时间'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT '云分享表' [ RunTime:0.000267s ]
CREATE TABLE IF NOT EXISTS `nav_fx_report` (
`id` int unsigned NOT NULL AUTO_INCREMENT COMMENT '主键 ID', PRIMARY KEY (`id`),
`fx_id` int NOT NULL DEFAULT 0 COMMENT '云分享 ID',
`slug` varchar(32) NOT NULL DEFAULT '' COMMENT '云分享地址',
`reason` varchar(100) NOT NULL DEFAULT '' COMMENT '举报原因',
`note` varchar(500) NOT NULL DEFAULT '' COMMENT '补充说明',
`ip` varchar(64) NOT NULL DEFAULT '' COMMENT '举报 IP',
`status` tinyint NOT NULL DEFAULT 0 COMMENT '处理状态(0 待处理 / 1 已处理)',
`create_time` int NOT NULL DEFAULT 0 COMMENT '举报时间',
`update_time` int NOT NULL DEFAULT 0 COMMENT '处理时间'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT '云分享举报表' [ RunTime:0.000258s ]
CREATE TABLE IF NOT EXISTS `nav_user_theme` (
`id` int unsigned NOT NULL AUTO_INCREMENT COMMENT '主键 ID', PRIMARY KEY (`id`),
`user_id` int NOT NULL DEFAULT 0 COMMENT '用户 ID',
`theme_id` varchar(50) NOT NULL DEFAULT '' COMMENT '主题唯一标识',
`name` varchar(100) NOT NULL DEFAULT '' COMMENT '主题名称',
`config` longtext NULL COMMENT '主题配置(JSON)',
`created` bigint NOT NULL DEFAULT 0 COMMENT '创建时间(毫秒时间戳)',
`updated` bigint NOT NULL DEFAULT 0 COMMENT '更新时间(毫秒时间戳)',
`deleted` tinyint NOT NULL DEFAULT 0 COMMENT '是否已删除(1 已删除)',
`update_time` int NOT NULL DEFAULT 0 COMMENT '记录更新时间(Unix 时间戳)'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT '用户主题配置表' [ RunTime:0.000224s ]
CREATE TABLE IF NOT EXISTS `nav_user_like` (
`id` int unsigned NOT NULL AUTO_INCREMENT COMMENT '主键 ID', PRIMARY KEY (`id`),
`user_id` int NOT NULL DEFAULT 0 COMMENT '用户 ID',
`type` varchar(20) NOT NULL DEFAULT 'site' COMMENT '对象类型(site 站点 / article 文章 / comment 评论)',
`target_id` int NOT NULL DEFAULT 0 COMMENT '点赞对象 ID',
`ip` varchar(64) NOT NULL DEFAULT '' COMMENT '操作 IP',
`create_time` int NOT NULL DEFAULT 0 COMMENT '创建时间(Unix 时间戳)'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT '用户点赞表' [ RunTime:0.000255s ]
CREATE TABLE IF NOT EXISTS `nav_user_email_code` (
`id` int unsigned NOT NULL AUTO_INCREMENT COMMENT '主键 ID', PRIMARY KEY (`id`),
`email` varchar(100) NOT NULL DEFAULT '' COMMENT '目标邮箱',
`scene` varchar(20) NOT NULL DEFAULT 'register' COMMENT '使用场景(register 注册 / login 登录 / reset 重置密码)',
`code_hash` varchar(64) NOT NULL DEFAULT '' COMMENT '验证码哈希',
`attempts` tinyint NOT NULL DEFAULT 0 COMMENT '已尝试验证次数',
`used` tinyint NOT NULL DEFAULT 0 COMMENT '是否已使用(1 是 / 0 否)',
`ip` varchar(64) NOT NULL DEFAULT '' COMMENT '请求 IP',
`expire_time` int NOT NULL DEFAULT 0 COMMENT '过期时间(Unix 时间戳)',
`create_time` int NOT NULL DEFAULT 0 COMMENT '创建时间(Unix 时间戳)'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT '邮箱验证码表' [ RunTime:0.000214s ]
CREATE TABLE IF NOT EXISTS `nav_user_history` (
`id` int unsigned NOT NULL AUTO_INCREMENT COMMENT '主键 ID', PRIMARY KEY (`id`),
`user_id` int NOT NULL DEFAULT 0 COMMENT '用户 ID',
`type` varchar(20) NOT NULL DEFAULT 'site' COMMENT '对象类型(site 站点 / article 文章)',
`target_id` int NOT NULL DEFAULT 0 COMMENT '浏览对象 ID',
`create_time` int NOT NULL DEFAULT 0 COMMENT '创建时间(Unix 时间戳)'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT '用户浏览历史表' [ RunTime:0.000220s ]
CREATE TABLE IF NOT EXISTS `nav_invite_code` (
`id` int unsigned NOT NULL AUTO_INCREMENT COMMENT '主键 ID', PRIMARY KEY (`id`),
`code` varchar(64) NOT NULL DEFAULT '' COMMENT '邀请码',
`batch` varchar(50) NOT NULL DEFAULT '' COMMENT '生成批次号',
`remark` varchar(200) NOT NULL DEFAULT '' COMMENT '备注',
`status` tinyint NOT NULL DEFAULT 0 COMMENT '状态(0 未使用 / 1 已使用)',
`user_id` int NOT NULL DEFAULT 0 COMMENT '使用者用户 ID',
`used_time` int NOT NULL DEFAULT 0 COMMENT '使用时间(Unix 时间戳)',
`expire_time` int NOT NULL DEFAULT 0 COMMENT '过期时间(Unix 时间戳)',
`create_time` int NOT NULL DEFAULT 0 COMMENT '创建时间(Unix 时间戳)',
`update_time` int NOT NULL DEFAULT 0 COMMENT '更新时间(Unix 时间戳)'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT '邀请码表' [ RunTime:0.000229s ]
CREATE TABLE IF NOT EXISTS `nav_invite_order` (
`id` int unsigned NOT NULL AUTO_INCREMENT COMMENT '主键 ID', PRIMARY KEY (`id`),
`order_no` varchar(64) NOT NULL DEFAULT '' COMMENT '订单号',
`price` varchar(20) NOT NULL DEFAULT '0' COMMENT '订单金额(元)',
`status` tinyint NOT NULL DEFAULT 0 COMMENT '支付状态(0 未支付 / 1 已支付)',
`user_id` int NOT NULL DEFAULT 0 COMMENT '用户 ID',
`email` varchar(100) NOT NULL DEFAULT '' COMMENT '购买者邮箱',
`trade_no` varchar(100) NOT NULL DEFAULT '' COMMENT '支付平台交易号',
`pay_channel` varchar(20) NOT NULL DEFAULT '' COMMENT '支付渠道',
`invite_code` varchar(64) NOT NULL DEFAULT '' COMMENT '发放的邀请码',
`ip` varchar(64) NOT NULL DEFAULT '' COMMENT '下单 IP',
`pay_time` int NOT NULL DEFAULT 0 COMMENT '支付时间(Unix 时间戳)',
`expire_time` int NOT NULL DEFAULT 0 COMMENT '邀请码有效期(Unix 时间戳)',
`create_time` int NOT NULL DEFAULT 0 COMMENT '创建时间(Unix 时间戳)',
`update_time` int NOT NULL DEFAULT 0 COMMENT '更新时间(Unix 时间戳)'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT '邀请码购买订单表' [ RunTime:0.000892s ]
CREATE TABLE IF NOT EXISTS `nav_member_plan` (
`id` int unsigned NOT NULL AUTO_INCREMENT COMMENT '主键 ID', PRIMARY KEY (`id`),
`type` varchar(20) NOT NULL DEFAULT 'vip' COMMENT '套餐类型(vip 会员 / points 积分)',
`name` varchar(100) NOT NULL DEFAULT '' COMMENT '套餐名称',
`months` int NOT NULL DEFAULT 0 COMMENT '时长(月)',
`days` int NOT NULL DEFAULT 0 COMMENT '时长(天)',
`price` varchar(20) NOT NULL DEFAULT '0' COMMENT '价格(元)',
`gift_days` int NOT NULL DEFAULT 0 COMMENT '赠送天数',
`badge` varchar(20) NOT NULL DEFAULT '' COMMENT '角标文字',
`description` varchar(200) NOT NULL DEFAULT '' COMMENT '套餐说明',
`sort` int NOT NULL DEFAULT 0 COMMENT '排序值(越大越靠前)',
`status` tinyint NOT NULL DEFAULT 1 COMMENT '状态(1 启用 / 0 禁用)',
`create_time` int NOT NULL DEFAULT 0 COMMENT '创建时间(Unix 时间戳)',
`update_time` int NOT NULL DEFAULT 0 COMMENT '更新时间(Unix 时间戳)'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT '会员套餐表' [ RunTime:0.000286s ]
CREATE TABLE IF NOT EXISTS `nav_points_pack` (
`id` int unsigned NOT NULL AUTO_INCREMENT COMMENT '主键 ID', PRIMARY KEY (`id`),
`name` varchar(100) NOT NULL DEFAULT '' COMMENT '套餐名称',
`points` int NOT NULL DEFAULT 0 COMMENT '积分数量',
`bonus` int NOT NULL DEFAULT 0 COMMENT '赠送积分',
`price` varchar(20) NOT NULL DEFAULT '0' COMMENT '价格(元)',
`badge` varchar(20) NOT NULL DEFAULT '' COMMENT '角标文字',
`description` varchar(200) NOT NULL DEFAULT '' COMMENT '套餐说明',
`sort` int NOT NULL DEFAULT 0 COMMENT '排序值(越大越靠前)',
`status` tinyint NOT NULL DEFAULT 1 COMMENT '状态(1 启用 / 0 禁用)',
`create_time` int NOT NULL DEFAULT 0 COMMENT '创建时间(Unix 时间戳)',
`update_time` int NOT NULL DEFAULT 0 COMMENT '更新时间(Unix 时间戳)'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT '积分充值套餐表' [ RunTime:0.000265s ]
CREATE TABLE IF NOT EXISTS `nav_member_order` (
`id` int unsigned NOT NULL AUTO_INCREMENT COMMENT '主键 ID', PRIMARY KEY (`id`),
`order_no` varchar(64) NOT NULL DEFAULT '' COMMENT '订单号',
`user_id` int NOT NULL DEFAULT 0 COMMENT '用户 ID',
`type` varchar(20) NOT NULL DEFAULT 'vip' COMMENT '订单类型(vip 会员 / points 积分)',
`plan_id` int NOT NULL DEFAULT 0 COMMENT '套餐 ID',
`title` varchar(100) NOT NULL DEFAULT '' COMMENT '套餐标题快照',
`amount` varchar(20) NOT NULL DEFAULT '0' COMMENT '订单金额(元)',
`months` int NOT NULL DEFAULT 0 COMMENT '开通时长(月)',
`days` int NOT NULL DEFAULT 0 COMMENT '开通天数',
`points` int NOT NULL DEFAULT 0 COMMENT '充值积分数量',
`bonus` int NOT NULL DEFAULT 0 COMMENT '赠送积分数量',
`status` tinyint NOT NULL DEFAULT 0 COMMENT '支付状态(0 未支付 / 1 已支付 / 2 已关闭)',
`pay_channel` varchar(20) NOT NULL DEFAULT '' COMMENT '支付渠道',
`trade_no` varchar(64) NOT NULL DEFAULT '' COMMENT '支付平台交易号',
`ip` varchar(64) NOT NULL DEFAULT '' COMMENT '下单 IP',
`remark` varchar(200) NOT NULL DEFAULT '' COMMENT '备注',
`pay_time` int NOT NULL DEFAULT 0 COMMENT '支付时间(Unix 时间戳)',
`expire_time` int NOT NULL DEFAULT 0 COMMENT '会员到期时间(Unix 时间戳)',
`create_time` int NOT NULL DEFAULT 0 COMMENT '创建时间(Unix 时间戳)',
`update_time` int NOT NULL DEFAULT 0 COMMENT '更新时间(Unix 时间戳)'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT '会员 / 积分充值订单表' [ RunTime:0.000321s ]
CREATE TABLE IF NOT EXISTS `nav_points_log` (
`id` int unsigned NOT NULL AUTO_INCREMENT COMMENT '主键 ID', PRIMARY KEY (`id`),
`user_id` int NOT NULL DEFAULT 0 COMMENT '用户 ID',
`delta` int NOT NULL DEFAULT 0 COMMENT '积分变动值(正数增加 / 负数扣减)',
`before_points` int NOT NULL DEFAULT 0 COMMENT '变动前积分余额',
`after_points` int NOT NULL DEFAULT 0 COMMENT '变动后积分余额',
`type` varchar(20) NOT NULL DEFAULT '' COMMENT '变动类型(如 recharge 充值 / cost 消费 / admin 后台调整)',
`ref` varchar(64) NOT NULL DEFAULT '' COMMENT '关联业务单号 / 标识',
`remark` varchar(200) NOT NULL DEFAULT '' COMMENT '备注',
`ip` varchar(64) NOT NULL DEFAULT '' COMMENT '操作 IP',
`create_time` int NOT NULL DEFAULT 0 COMMENT '创建时间(Unix 时间戳)'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT '积分变动流水表' [ RunTime:0.000271s ]
CREATE TABLE IF NOT EXISTS `nav_article_points_unlock` (
`id` int unsigned NOT NULL AUTO_INCREMENT, PRIMARY KEY (`id`),
`user_id` int NOT NULL DEFAULT 0,
`article_id` int NOT NULL DEFAULT 0,
`points` int NOT NULL DEFAULT 0,
`ip` varchar(64) NOT NULL DEFAULT '',
`create_time` int NOT NULL DEFAULT 0
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci [ RunTime:0.000233s ]
CREATE TABLE IF NOT EXISTS `nav_points_signin` (
`id` int unsigned NOT NULL AUTO_INCREMENT, PRIMARY KEY (`id`),
`user_id` int NOT NULL DEFAULT 0,
`day` varchar(20) NOT NULL DEFAULT '',
`ip` varchar(64) NOT NULL DEFAULT '',
`device_hash` varchar(64) NOT NULL DEFAULT '',
`create_time` int NOT NULL DEFAULT 0
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci [ RunTime:0.000353s ]
CREATE TABLE IF NOT EXISTS `nav_dl_ticket` (
`id` int unsigned NOT NULL AUTO_INCREMENT, PRIMARY KEY (`id`),
`sig` varchar(64) NOT NULL DEFAULT '',
`user_id` int NOT NULL DEFAULT 0,
`article_id` int NOT NULL DEFAULT 0,
`item` int NOT NULL DEFAULT 0,
`expire_time` int NOT NULL DEFAULT 0,
`create_time` int NOT NULL DEFAULT 0
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci [ RunTime:0.000215s ]
CREATE TABLE IF NOT EXISTS `nav_pkg_key_log` (
`id` int unsigned NOT NULL AUTO_INCREMENT COMMENT '主键 ID', PRIMARY KEY (`id`),
`ticket_hash` varchar(64) NOT NULL DEFAULT '' COMMENT '访问票据哈希',
`user_id` int NOT NULL DEFAULT 0 COMMENT '用户 ID',
`slug` varchar(64) NOT NULL DEFAULT '' COMMENT '资源包标识',
`kind` varchar(20) NOT NULL DEFAULT 'anon' COMMENT '访问者类型(anon 游客 / user 登录用户)',
`bucket` varchar(64) NOT NULL DEFAULT '' COMMENT '频率限制桶标识',
`ip` varchar(64) NOT NULL DEFAULT '' COMMENT 'IP 地址',
`ip_hash` varchar(64) NOT NULL DEFAULT '' COMMENT 'IP 哈希(脱敏)',
`points` int NOT NULL DEFAULT 0 COMMENT '本次消耗积分',
`create_time` int NOT NULL DEFAULT 0 COMMENT '创建时间(Unix 时间戳)'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT '资源包访问密钥日志表' [ RunTime:0.000269s ]
CREATE TABLE IF NOT EXISTS `nav_secret_post` (
`id` int unsigned NOT NULL AUTO_INCREMENT COMMENT '主键 ID', PRIMARY KEY (`id`),
`content` varchar(500) NOT NULL DEFAULT '' COMMENT '树洞内容',
`mood` varchar(20) NOT NULL DEFAULT 'heart' COMMENT '心情标识(heart / smile 等)',
`site_id` int NOT NULL DEFAULT 0 COMMENT '关联站点 ID(0 = 全站)',
`content_hash` varchar(64) NOT NULL DEFAULT '' COMMENT '内容哈希(用于重复提交判断)',
`anon_name` varchar(50) NOT NULL DEFAULT '' COMMENT '匿名昵称',
`anon_avatar` varchar(20) NOT NULL DEFAULT '' COMMENT '匿名头像标识',
`anon_color` varchar(20) NOT NULL DEFAULT '' COMMENT '匿名头像配色',
`region` varchar(50) NOT NULL DEFAULT '' COMMENT 'IP 归属地区',
`ip_hash` varchar(64) NOT NULL DEFAULT '' COMMENT 'IP 哈希(脱敏)',
`device_hash` varchar(64) NOT NULL DEFAULT '' COMMENT '设备指纹哈希',
`user_id` int NOT NULL DEFAULT 0 COMMENT '发布者用户 ID(0 = 游客)',
`status` tinyint NOT NULL DEFAULT 0 COMMENT '状态(0 待审核 / 1 已发布 / 2 未通过 / 3 已隐藏)',
`likes` int NOT NULL DEFAULT 0 COMMENT '点赞数',
`reports` int NOT NULL DEFAULT 0 COMMENT '被举报次数',
`is_top` tinyint NOT NULL DEFAULT 0 COMMENT '是否置顶(1 是 / 0 否)',
`audit_note` varchar(200) NOT NULL DEFAULT '' COMMENT '审核备注',
`audit_time` int NOT NULL DEFAULT 0 COMMENT '审核时间(Unix 时间戳)',
`audit_admin` varchar(50) NOT NULL DEFAULT '' COMMENT '审核管理员账号',
`create_time` int NOT NULL DEFAULT 0 COMMENT '创建时间(Unix 时间戳)',
`update_time` int NOT NULL DEFAULT 0 COMMENT '更新时间(Unix 时间戳)'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT '匿名树洞内容表' [ RunTime:0.000314s ]
CREATE TABLE IF NOT EXISTS `nav_secret_report` (
`id` int unsigned NOT NULL AUTO_INCREMENT COMMENT '主键 ID', PRIMARY KEY (`id`),
`post_id` int NOT NULL DEFAULT 0 COMMENT '被举报的树洞内容 ID',
`reason` varchar(50) NOT NULL DEFAULT '' COMMENT '举报原因',
`note` varchar(255) NOT NULL DEFAULT '' COMMENT '补充说明',
`ip_hash` varchar(64) NOT NULL DEFAULT '' COMMENT 'IP 哈希(脱敏)',
`device_hash` varchar(64) NOT NULL DEFAULT '' COMMENT '设备指纹哈希',
`status` tinyint NOT NULL DEFAULT 0 COMMENT '处理状态(0 未处理 / 1 已处理)',
`create_time` int NOT NULL DEFAULT 0 COMMENT '创建时间(Unix 时间戳)'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT '树洞举报表' [ RunTime:0.000408s ]
CREATE TABLE IF NOT EXISTS `nav_comment` (
`id` int unsigned NOT NULL AUTO_INCREMENT COMMENT '主键 ID', PRIMARY KEY (`id`),
`page_key` varchar(64) NOT NULL DEFAULT '' COMMENT '评论对象标识(如 site-12 / article-8)',
`page_title` varchar(200) NOT NULL DEFAULT '' COMMENT '评论页面标题',
`root_id` int NOT NULL DEFAULT 0 COMMENT '顶级评论 ID(0 = 一级评论)',
`parent_id` int NOT NULL DEFAULT 0 COMMENT '被回复的评论 ID(0 = 直接评论)',
`user_id` int NOT NULL DEFAULT 0 COMMENT '用户 ID',
`is_admin` tinyint NOT NULL DEFAULT 0 COMMENT '是否管理员身份(1 是 / 0 否)',
`nickname` varchar(50) NOT NULL DEFAULT '' COMMENT '评论者昵称',
`email_hash` varchar(64) NOT NULL DEFAULT '' COMMENT '邮箱哈希(脱敏,用于识别同一评论者)',
`avatar` varchar(500) NOT NULL DEFAULT '' COMMENT '评论者头像地址',
`level` tinyint NOT NULL DEFAULT 1 COMMENT '评论者用户等级',
`content` longtext COMMENT '评论内容',
`reply_to_name` varchar(50) NOT NULL DEFAULT '' COMMENT '被回复者昵称',
`region` varchar(50) NOT NULL DEFAULT '' COMMENT 'IP 归属地区',
`ip_hash` varchar(64) NOT NULL DEFAULT '' COMMENT 'IP 哈希(脱敏)',
`ip` varchar(64) NOT NULL DEFAULT '' COMMENT '评论者 IP',
`device_hash` varchar(64) NOT NULL DEFAULT '' COMMENT '设备指纹哈希',
`os_name` varchar(50) NOT NULL DEFAULT '' COMMENT '操作系统名称',
`os_icon` varchar(100) NOT NULL DEFAULT '' COMMENT '操作系统图标',
`browser_name` varchar(50) NOT NULL DEFAULT '' COMMENT '浏览器名称',
`browser_icon` varchar(100) NOT NULL DEFAULT '' COMMENT '浏览器图标',
`likes` int NOT NULL DEFAULT 0 COMMENT '点赞数',
`status` tinyint NOT NULL DEFAULT 0 COMMENT '状态(0 待审核 / 1 已发布 / 2 未通过 / 3 已删除)',
`is_top` tinyint NOT NULL DEFAULT 0 COMMENT '是否置顶(1 是 / 0 否)',
`audit_note` varchar(200) NOT NULL DEFAULT '' COMMENT '审核备注',
`create_time` int NOT NULL DEFAULT 0 COMMENT '创建时间(Unix 时间戳)',
`update_time` int NOT NULL DEFAULT 0 COMMENT '更新时间(Unix 时间戳)'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT '评论表' [ RunTime:0.000327s ]
CREATE TABLE IF NOT EXISTS `nav_right_menu` (
`id` int unsigned NOT NULL AUTO_INCREMENT COMMENT '主键 ID', PRIMARY KEY (`id`),
`name` varchar(100) NOT NULL DEFAULT '' COMMENT '菜单名称',
`scope_type` varchar(50) NOT NULL DEFAULT 'site' COMMENT '作用范围类型(site 站点 / app 软件 / article 文章 / folder 文件夹 / any 兜底,多个用逗号分隔)',
`scope_value` varchar(64) NOT NULL DEFAULT '' COMMENT '作用范围取值',
`pages` varchar(200) NOT NULL DEFAULT '' COMMENT '生效页面(逗号分隔)',
`priority` int NOT NULL DEFAULT 0 COMMENT '优先级(越大越优先)',
`enabled` tinyint NOT NULL DEFAULT 1 COMMENT '是否启用(1 是 / 0 否)',
`item_count` int NOT NULL DEFAULT 0 COMMENT '菜单项数量',
`create_time` int NOT NULL DEFAULT 0 COMMENT '创建时间(Unix 时间戳)',
`update_time` int NOT NULL DEFAULT 0 COMMENT '更新时间(Unix 时间戳)'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT '右侧悬浮菜单表' [ RunTime:0.000336s ]
CREATE TABLE IF NOT EXISTS `nav_right_menu_item` (
`id` int unsigned NOT NULL AUTO_INCREMENT COMMENT '主键 ID', PRIMARY KEY (`id`),
`rid` int NOT NULL DEFAULT 0 COMMENT '所属菜单 ID',
`pid` int NOT NULL DEFAULT 0 COMMENT '上级菜单项 ID(0 = 顶级)',
`label` varchar(50) NOT NULL DEFAULT '' COMMENT '显示文字',
`icon` varchar(500) NOT NULL DEFAULT '' COMMENT '图标(类名或图片地址)',
`action` varchar(20) NOT NULL DEFAULT 'link' COMMENT '动作类型(link 链接 / js 脚本 / api 接口)',
`target` longtext COMMENT '动作目标(链接地址 / JS 代码 / 接口参数)',
`newtab` tinyint NOT NULL DEFAULT 0 COMMENT '是否新窗口打开(1 是 / 0 否)',
`roles` varchar(20) NOT NULL DEFAULT 'all' COMMENT '可见角色(all 全部 / user 登录 / vip 会员 / admin 管理员)',
`sort` int NOT NULL DEFAULT 0 COMMENT '排序值(越大越靠前)',
`enabled` tinyint NOT NULL DEFAULT 1 COMMENT '是否启用(1 是 / 0 否)',
`create_time` int NOT NULL DEFAULT 0 COMMENT '创建时间(Unix 时间戳)',
`update_time` int NOT NULL DEFAULT 0 COMMENT '更新时间(Unix 时间戳)'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT '右侧菜单项表' [ RunTime:0.000303s ]
CREATE TABLE IF NOT EXISTS `nav_home_module` (
`id` int unsigned NOT NULL AUTO_INCREMENT COMMENT '主键 ID', PRIMARY KEY (`id`),
`mkey` varchar(64) NOT NULL DEFAULT '' COMMENT '模块标识(英文 key)',
`zone` varchar(20) NOT NULL DEFAULT 'main' COMMENT '所在区域(main 主区 / side 侧栏)',
`sort` int NOT NULL DEFAULT 0 COMMENT '排序值(越大越靠前)',
`visible` tinyint NOT NULL DEFAULT 1 COMMENT '是否显示(1 是 / 0 否)',
`create_time` int NOT NULL DEFAULT 0 COMMENT '创建时间(Unix 时间戳)',
`update_time` int NOT NULL DEFAULT 0 COMMENT '更新时间(Unix 时间戳)'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT '首页模块排序 / 显示配置表' [ RunTime:0.000382s ]
CREATE TABLE IF NOT EXISTS `nav_home_block` (
`id` int unsigned NOT NULL AUTO_INCREMENT COMMENT '主键 ID', PRIMARY KEY (`id`),
`title` varchar(50) NOT NULL DEFAULT '' COMMENT '区块标题',
`icon` varchar(50) NOT NULL DEFAULT 'bi-image' COMMENT '区块图标',
`type` varchar(20) NOT NULL DEFAULT 'manual' COMMENT '内容来源(manual 手动 / auto 自动)',
`strategy` varchar(20) NOT NULL DEFAULT 'fixed' COMMENT '展示方式(fixed 固定 / scroll 自动滚动)',
`rank_type` varchar(20) NOT NULL DEFAULT 'hot' COMMENT '排行类型(hot 热门 / new 最新 / like 点赞)',
`rank_period` varchar(20) NOT NULL DEFAULT 'week' COMMENT '排行周期(day 日 / week 周 / month 月)',
`total` int NOT NULL DEFAULT 3 COMMENT '区块内容总条数',
`per_view` int NOT NULL DEFAULT 1 COMMENT '每屏显示条数',
`interval` int NOT NULL DEFAULT 5 COMMENT '自动切换间隔(秒)',
`pause_hover` tinyint NOT NULL DEFAULT 1 COMMENT '鼠标悬停是否暂停(1 是 / 0 否)',
`show_dots` tinyint NOT NULL DEFAULT 1 COMMENT '是否显示指示点(1 是 / 0 否)',
`transition` varchar(10) NOT NULL DEFAULT 'fade' COMMENT '切换动画(fade 淡入 / slide 滑动)',
`mobile_mode` varchar(20) NOT NULL DEFAULT 'auto' COMMENT '移动端展示模式(auto 自适应 等)',
`scope` varchar(20) NOT NULL DEFAULT 'all' COMMENT '作用范围(all 全站 / site 站点 / article 文章)',
`more_url` varchar(500) NOT NULL DEFAULT '' COMMENT '「更多」跳转链接',
`more_text` varchar(50) NOT NULL DEFAULT '更多' COMMENT '「更多」按钮文字',
`note_text` varchar(500) NOT NULL DEFAULT '' COMMENT '公告 / 跑马灯文字',
`note_author` varchar(50) NOT NULL DEFAULT '' COMMENT '公告署名',
`note_items` longtext DEFAULT NULL COMMENT '公告条目列表(JSON)',
`audience` varchar(20) NOT NULL DEFAULT 'all' COMMENT '展示人群(all 全部 / guest 游客 / user 登录用户 / vip 会员)',
`ab_enable` tinyint NOT NULL DEFAULT 0 COMMENT '是否开启 AB 测试(1 是 / 0 否)',
`ab_ratio` int NOT NULL DEFAULT 50 COMMENT 'AB 测试分流比例(0-100,A 组百分比)',
`status` tinyint NOT NULL DEFAULT 1 COMMENT '状态(1 启用 / 0 禁用)',
`sort` int NOT NULL DEFAULT 0 COMMENT '排序值(越大越靠前)',
`start_time` int NOT NULL DEFAULT 0 COMMENT '生效开始时间(Unix 时间戳)',
`end_time` int NOT NULL DEFAULT 0 COMMENT '生效结束时间(Unix 时间戳)',
`create_time` int NOT NULL DEFAULT 0 COMMENT '创建时间(Unix 时间戳)',
`update_time` int NOT NULL DEFAULT 0 COMMENT '更新时间(Unix 时间戳)'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT '首页区块配置表' [ RunTime:0.003104s ]
CREATE TABLE IF NOT EXISTS `nav_home_pic` (
`id` int unsigned NOT NULL AUTO_INCREMENT COMMENT '主键 ID', PRIMARY KEY (`id`),
`block_id` int NOT NULL DEFAULT 0 COMMENT '所属轮播区块 ID',
`type` varchar(20) NOT NULL DEFAULT 'manual' COMMENT '内容来源(manual 手动 / auto 自动)',
`source_id` int NOT NULL DEFAULT 0 COMMENT '关联内容 ID(自动取数时用)',
`weight` int NOT NULL DEFAULT 0 COMMENT '权重(越大越靠前)',
`title` varchar(100) NOT NULL DEFAULT '' COMMENT '标题',
`subtitle` varchar(200) NOT NULL DEFAULT '' COMMENT '副标题',
`image` varchar(500) NOT NULL DEFAULT '' COMMENT '电脑端图片地址',
`image_m` varchar(500) NOT NULL DEFAULT '' COMMENT '移动端图片地址',
`url` varchar(500) NOT NULL DEFAULT '' COMMENT '点击跳转链接',
`badge` varchar(50) NOT NULL DEFAULT '' COMMENT '角标文字',
`is_ad` tinyint NOT NULL DEFAULT 0 COMMENT '是否广告位(1 是 / 0 否)',
`scope` varchar(20) NOT NULL DEFAULT 'all' COMMENT '作用范围(all 全站 / site 站点 / article 文章)',
`target` tinyint NOT NULL DEFAULT 0 COMMENT '打开方式(1 新窗口 / 0 当前窗口)',
`status` tinyint NOT NULL DEFAULT 1 COMMENT '状态(1 启用 / 0 禁用)',
`sort` int NOT NULL DEFAULT 0 COMMENT '排序值(越大越靠前)',
`start_time` int NOT NULL DEFAULT 0 COMMENT '生效开始时间(Unix 时间戳)',
`end_time` int NOT NULL DEFAULT 0 COMMENT '生效结束时间(Unix 时间戳)',
`is_countdown` tinyint NOT NULL DEFAULT 0 COMMENT '是否显示倒计时(1 是 / 0 否)',
`is_video` tinyint NOT NULL DEFAULT 0 COMMENT '是否视频背景(1 是 / 0 否)',
`views` int NOT NULL DEFAULT 0 COMMENT '浏览次数',
`clicks` int NOT NULL DEFAULT 0 COMMENT '点击次数',
`create_time` int NOT NULL DEFAULT 0 COMMENT '创建时间(Unix 时间戳)',
`update_time` int NOT NULL DEFAULT 0 COMMENT '更新时间(Unix 时间戳)'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT '首页轮播图 / 焦点图表' [ RunTime:0.000284s ]
CREATE TABLE IF NOT EXISTS `nav_home_pic_stat` (
`id` int unsigned NOT NULL AUTO_INCREMENT COMMENT '主键 ID', PRIMARY KEY (`id`),
`pic_id` int NOT NULL DEFAULT 0 COMMENT '轮播图 ID',
`day` int NOT NULL DEFAULT 0 COMMENT '统计日期(YYYYMMDD)',
`views` int NOT NULL DEFAULT 0 COMMENT '浏览次数',
`clicks` int NOT NULL DEFAULT 0 COMMENT '点击次数',
`create_time` int NOT NULL DEFAULT 0 COMMENT '创建时间(Unix 时间戳)',
`update_time` int NOT NULL DEFAULT 0 COMMENT '更新时间(Unix 时间戳)'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT '首页轮播图统计表' [ RunTime:0.000220s ]
CREATE TABLE IF NOT EXISTS `nav_home_block_stat` (
`id` int unsigned NOT NULL AUTO_INCREMENT COMMENT '主键 ID', PRIMARY KEY (`id`),
`block_id` int NOT NULL DEFAULT 0 COMMENT '所属区块 ID',
`day` int NOT NULL DEFAULT 0 COMMENT '统计日期(YYYYMMDD)',
`grp` varchar(10) NOT NULL DEFAULT 'a' COMMENT 'AB 测试分组(a / b)',
`exposes` int NOT NULL DEFAULT 0 COMMENT '曝光次数',
`clicks` int NOT NULL DEFAULT 0 COMMENT '点击次数',
`create_time` int NOT NULL DEFAULT 0 COMMENT '创建时间(Unix 时间戳)',
`update_time` int NOT NULL DEFAULT 0 COMMENT '更新时间(Unix 时间戳)'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT '首页区块曝光 / 点击统计表' [ RunTime:0.000238s ]
CREATE TABLE IF NOT EXISTS `nav_shijuan_subject` (
`id` int unsigned NOT NULL AUTO_INCREMENT COMMENT '主键 ID', PRIMARY KEY (`id`),
`slug` varchar(50) NOT NULL COMMENT 'URL 标识(英文唯一别名)',
`name` varchar(100) NOT NULL COMMENT '科目名称',
`icon` varchar(255) NOT NULL DEFAULT '' COMMENT '科目图标',
`total` int NOT NULL DEFAULT 0 COMMENT '资源总数',
`sort` int NOT NULL DEFAULT 0 COMMENT '排序值(越大越靠前)',
`status` tinyint NOT NULL DEFAULT 1 COMMENT '状态(1 启用 / 0 禁用)',
`create_time` int NOT NULL DEFAULT 0 COMMENT '创建时间(Unix 时间戳)',
`update_time` int NOT NULL DEFAULT 0 COMMENT '更新时间(Unix 时间戳)'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT '试卷科目表' [ RunTime:0.000217s ]
CREATE TABLE IF NOT EXISTS `nav_shijuan_category` (
`id` int unsigned NOT NULL AUTO_INCREMENT COMMENT '主键 ID', PRIMARY KEY (`id`),
`subject_slug` varchar(50) NOT NULL DEFAULT '' COMMENT '所属科目标识(对应 nav_shijuan_subject.slug)',
`slug` varchar(50) NOT NULL COMMENT 'URL 标识(英文唯一别名)',
`name` varchar(100) NOT NULL COMMENT '分类名称',
`icon` varchar(255) NOT NULL DEFAULT '' COMMENT '分类图标',
`typeid` varchar(20) NOT NULL DEFAULT '' COMMENT '源站分类 ID',
`total` int NOT NULL DEFAULT 0 COMMENT '资源总数',
`meta_title` varchar(255) NOT NULL DEFAULT '' COMMENT 'SEO 标题',
`meta_keywords` varchar(255) NOT NULL DEFAULT '' COMMENT 'SEO 关键词',
`meta_description` varchar(500) NOT NULL DEFAULT '' COMMENT 'SEO 描述',
`sort` int NOT NULL DEFAULT 0 COMMENT '排序值(越大越靠前)',
`status` tinyint NOT NULL DEFAULT 1 COMMENT '状态(1 启用 / 0 禁用)',
`create_time` int NOT NULL DEFAULT 0 COMMENT '创建时间(Unix 时间戳)',
`update_time` int NOT NULL DEFAULT 0 COMMENT '更新时间(Unix 时间戳)'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT '试卷资源分类表' [ RunTime:0.000245s ]
CREATE TABLE IF NOT EXISTS `nav_shijuan_item` (
`id` int unsigned NOT NULL AUTO_INCREMENT COMMENT '主键 ID', PRIMARY KEY (`id`),
`cat` varchar(50) NOT NULL DEFAULT '' COMMENT '所属分类标识(对应 nav_shijuan_category.slug)',
`item_id` int NOT NULL DEFAULT 0 COMMENT '源站资源 ID',
`title` varchar(255) NOT NULL DEFAULT '' COMMENT '资源标题',
`type` varchar(20) NOT NULL DEFAULT '' COMMENT '资源类型',
`grade` varchar(50) NOT NULL DEFAULT '' COMMENT '适用年级',
`version` varchar(100) NOT NULL DEFAULT '' COMMENT '教材版本',
`size` varchar(20) NOT NULL DEFAULT '' COMMENT '文件大小',
`pub_date` varchar(20) NOT NULL DEFAULT '' COMMENT '发布时间',
`img` varchar(255) NOT NULL DEFAULT '' COMMENT '缩略图地址',
`file` varchar(500) NOT NULL DEFAULT '' COMMENT '文件地址',
`license` varchar(20) NOT NULL DEFAULT 'free' COMMENT '授权类型(free 免费 / vip 会员)',
`rtype` varchar(50) NOT NULL DEFAULT '试题试卷' COMMENT '资源分类名称(如 试题试卷)',
`intro` longtext COMMENT '资源简介',
`notice` longtext COMMENT '下载提示',
`feedback` longtext COMMENT '反馈内容',
`feedback_status` tinyint NOT NULL DEFAULT 0 COMMENT '反馈处理状态(0 未处理 / 1 已处理)',
`feedback_time` int NOT NULL DEFAULT 0 COMMENT '反馈提交时间(Unix 时间戳)',
`images` longtext COMMENT '图片地址列表(JSON)',
`meta_json` longtext COMMENT '扩展元数据(JSON)',
`source` varchar(255) NOT NULL DEFAULT '' COMMENT '来源站地址',
`prev_id` int NOT NULL DEFAULT 0 COMMENT '上一篇资源 ID',
`next_id` int NOT NULL DEFAULT 0 COMMENT '下一篇资源 ID',
`sort` int NOT NULL DEFAULT 0 COMMENT '排序值(越大越靠前)',
`status` tinyint NOT NULL DEFAULT 1 COMMENT '状态(1 启用 / 0 禁用)',
`create_time` int NOT NULL DEFAULT 0 COMMENT '创建时间(Unix 时间戳)',
`update_time` int NOT NULL DEFAULT 0 COMMENT '更新时间(Unix 时间戳)'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT '试卷资源表' [ RunTime:0.000289s ]
CREATE TABLE IF NOT EXISTS `nav_shijuan_download` (
`id` int unsigned NOT NULL AUTO_INCREMENT COMMENT '主键 ID', PRIMARY KEY (`id`),
`item_id` int NOT NULL DEFAULT 0 COMMENT '所属试卷资源 ID',
`name` varchar(100) NOT NULL DEFAULT '' COMMENT '下载项名称',
`url` varchar(255) NOT NULL DEFAULT '' COMMENT '下载地址',
`sort` int NOT NULL DEFAULT 0 COMMENT '排序值(越大越靠前)',
`create_time` int NOT NULL DEFAULT 0 COMMENT '创建时间(Unix 时间戳)',
`update_time` int NOT NULL DEFAULT 0 COMMENT '更新时间(Unix 时间戳)'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT '试卷下载项表' [ RunTime:0.000223s ]
CREATE TABLE IF NOT EXISTS `nav_article_dl_unlock` (
`id` int unsigned NOT NULL AUTO_INCREMENT COMMENT '主键 ID', PRIMARY KEY (`id`),
`article_id` int NOT NULL DEFAULT 0 COMMENT '文章 ID',
`user_id` int NOT NULL DEFAULT 0 COMMENT '用户 ID',
`email` varchar(100) NOT NULL DEFAULT '' COMMENT '解锁邮箱(游客解锁用)',
`method` varchar(20) NOT NULL DEFAULT '' COMMENT '解锁方式(login / email / points / pay / comment 等)',
`order_no` varchar(64) NOT NULL DEFAULT '' COMMENT '关联付费订单号',
`token` varchar(64) NOT NULL DEFAULT '' COMMENT '解锁令牌',
`ip` varchar(64) NOT NULL DEFAULT '' COMMENT '解锁 IP',
`expire_time` int NOT NULL DEFAULT 0 COMMENT '解锁过期时间(Unix 时间戳,0 = 永久)',
`create_time` int NOT NULL DEFAULT 0 COMMENT '创建时间(Unix 时间戳)'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT '文章下载解锁记录表' [ RunTime:0.000255s ]
CREATE TABLE IF NOT EXISTS `nav_article_dl_order` (
`id` int unsigned NOT NULL AUTO_INCREMENT COMMENT '主键 ID', PRIMARY KEY (`id`),
`order_no` varchar(64) NOT NULL DEFAULT '' COMMENT '订单号',
`article_id` int NOT NULL DEFAULT 0 COMMENT '文章 ID',
`user_id` int NOT NULL DEFAULT 0 COMMENT '用户 ID',
`email` varchar(100) NOT NULL DEFAULT '' COMMENT '下单邮箱(游客下单用)',
`amount` varchar(20) NOT NULL DEFAULT '0' COMMENT '订单金额(元)',
`status` tinyint NOT NULL DEFAULT 0 COMMENT '支付状态(0 未支付 / 1 已支付)',
`channel` varchar(20) NOT NULL DEFAULT '' COMMENT '支付渠道',
`trade_no` varchar(100) NOT NULL DEFAULT '' COMMENT '支付平台交易号',
`token` varchar(64) NOT NULL DEFAULT '' COMMENT '解锁令牌',
`ip` varchar(64) NOT NULL DEFAULT '' COMMENT '下单 IP',
`pay_time` int NOT NULL DEFAULT 0 COMMENT '支付时间(Unix 时间戳)',
`expire_time` int NOT NULL DEFAULT 0 COMMENT '解锁过期时间(Unix 时间戳)',
`create_time` int NOT NULL DEFAULT 0 COMMENT '创建时间(Unix 时间戳)',
`update_time` int NOT NULL DEFAULT 0 COMMENT '更新时间(Unix 时间戳)'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT '文章付费下载订单表' [ RunTime:0.005697s ]
CREATE TABLE IF NOT EXISTS `nav_article_dl_quota_log` (
`id` int unsigned NOT NULL AUTO_INCREMENT COMMENT '主键 ID', PRIMARY KEY (`id`),
`user_id` int NOT NULL DEFAULT 0 COMMENT '用户 ID',
`article_id` int NOT NULL DEFAULT 0 COMMENT '文章 ID',
`period_key` varchar(20) NOT NULL DEFAULT '' COMMENT '额度周期标识(如 2026-11 或 20261116)',
`create_time` int NOT NULL DEFAULT 0 COMMENT '创建时间(Unix 时间戳)'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT '文章下载额度日志表' [ RunTime:0.000380s ]
CREATE TABLE IF NOT EXISTS `nav_article_dl_log` (
`id` int unsigned NOT NULL AUTO_INCREMENT COMMENT '主键 ID', PRIMARY KEY (`id`),
`article_id` int NOT NULL DEFAULT 0 COMMENT '文章 ID',
`download_index` int NOT NULL DEFAULT 0 COMMENT '下载项序号(从 0 开始)',
`user_id` int NOT NULL DEFAULT 0 COMMENT '用户 ID',
`ip` varchar(64) NOT NULL DEFAULT '' COMMENT '下载者 IP',
`create_time` int NOT NULL DEFAULT 0 COMMENT '创建时间(Unix 时间戳)'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT '文章下载点击日志表' [ RunTime:0.000243s ]
SELECT COUNT(*) AS `c` FROM `nav_devphase` [ RunTime:0.000233s ]
SELECT COUNT(*) AS `c` FROM `nav_devlog` [ RunTime:0.000248s ]
SELECT `k`,`v` FROM `nav_setting` WHERE `k` IN ('ad_banner_total','ad_slots') [ RunTime:0.000276s ]
INSERT IGNORE INTO `nav_setting` (`k`,`v`,`update_time`) VALUES ('submit_on','1','1795270725') [ RunTime:0.000286s ]
INSERT IGNORE INTO `nav_setting` (`k`,`v`,`update_time`) VALUES ('submit_free_audit','0','1795270725') [ RunTime:0.000303s ]
INSERT IGNORE INTO `nav_setting` (`k`,`v`,`update_time`) VALUES ('submit_price','0','1795270725') [ RunTime:0.000206s ]
INSERT IGNORE INTO `nav_setting` (`k`,`v`,`update_time`) VALUES ('submit_force_pay','0','1795270725') [ RunTime:0.000194s ]
INSERT IGNORE INTO `nav_setting` (`k`,`v`,`update_time`) VALUES ('submit_pay_audit','0','1795270725') [ RunTime:0.000207s ]
INSERT IGNORE INTO `nav_setting` (`k`,`v`,`update_time`) VALUES ('ad_on','1','1795270725') [ RunTime:0.000220s ]
INSERT IGNORE INTO `nav_setting` (`k`,`v`,`update_time`) VALUES ('ad_price_month','0','1795270725') [ RunTime:0.000200s ]
INSERT IGNORE INTO `nav_setting` (`k`,`v`,`update_time`) VALUES ('ad_free_audit','0','1795270725') [ RunTime:0.000219s ]
INSERT IGNORE INTO `nav_setting` (`k`,`v`,`update_time`) VALUES ('ad_free_months','1','1795270725') [ RunTime:0.000198s ]
INSERT IGNORE INTO `nav_setting` (`k`,`v`,`update_time`) VALUES ('ad_require_mark','1','1795270725') [ RunTime:0.000204s ]
INSERT IGNORE INTO `nav_setting` (`k`,`v`,`update_time`) VALUES ('ad_contact','','1795270725') [ RunTime:0.000199s ]
INSERT IGNORE INTO `nav_setting` (`k`,`v`,`update_time`) VALUES ('ad_banner_rows','2','1795270725') [ RunTime:0.000222s ]
INSERT IGNORE INTO `nav_setting` (`k`,`v`,`update_time`) VALUES ('ad_banner_cols','1','1795270725') [ RunTime:0.000550s ]
INSERT IGNORE INTO `nav_setting` (`k`,`v`,`update_time`) VALUES ('ad_banner_total','24','1795270725') [ RunTime:0.000247s ]
INSERT IGNORE INTO `nav_setting` (`k`,`v`,`update_time`) VALUES ('ad_fixed_rows','2','1795270725') [ RunTime:0.000283s ]
INSERT IGNORE INTO `nav_setting` (`k`,`v`,`update_time`) VALUES ('ad_fixed_cols','9','1795270725') [ RunTime:0.000203s ]
INSERT IGNORE INTO `nav_setting` (`k`,`v`,`update_time`) VALUES ('ad_fixed_total','24','1795270725') [ RunTime:0.000199s ]
INSERT IGNORE INTO `nav_setting` (`k`,`v`,`update_time`) VALUES ('ad_fixed_price','0','1795270725') [ RunTime:0.000280s ]
INSERT IGNORE INTO `nav_setting` (`k`,`v`,`update_time`) VALUES ('featured_cols','7','1795270725') [ RunTime:0.000212s ]
INSERT IGNORE INTO `nav_setting` (`k`,`v`,`update_time`) VALUES ('featured_total','14','1795270725') [ RunTime:0.000201s ]
INSERT IGNORE INTO `nav_setting` (`k`,`v`,`update_time`) VALUES ('pick_on','1','1795270725') [ RunTime:0.000219s ]
INSERT IGNORE INTO `nav_setting` (`k`,`v`,`update_time`) VALUES ('pick_cols','5','1795270725') [ RunTime:0.000231s ]
INSERT IGNORE INTO `nav_setting` (`k`,`v`,`update_time`) VALUES ('pick_cols_m','3','1795270725') [ RunTime:0.000205s ]
INSERT IGNORE INTO `nav_setting` (`k`,`v`,`update_time`) VALUES ('quick_on','1','1795270725') [ RunTime:0.000198s ]
INSERT IGNORE INTO `nav_setting` (`k`,`v`,`update_time`) VALUES ('quick_cols','5','1795270725') [ RunTime:0.000196s ]
INSERT IGNORE INTO `nav_setting` (`k`,`v`,`update_time`) VALUES ('quick_cols_m','3','1795270725') [ RunTime:0.000217s ]
INSERT IGNORE INTO `nav_setting` (`k`,`v`,`update_time`) VALUES ('quick_rows','2','1795270725') [ RunTime:0.000196s ]
INSERT IGNORE INTO `nav_setting` (`k`,`v`,`update_time`) VALUES ('pay_on','0','1795270725') [ RunTime:0.000211s ]
INSERT IGNORE INTO `nav_setting` (`k`,`v`,`update_time`) VALUES ('pay_note','','1795270725') [ RunTime:0.000204s ]
INSERT IGNORE INTO `nav_setting` (`k`,`v`,`update_time`) VALUES ('pay_qr_on','1','1795270725') [ RunTime:0.000222s ]
INSERT IGNORE INTO `nav_setting` (`k`,`v`,`update_time`) VALUES ('pay_qr_alipay','','1795270725') [ RunTime:0.000204s ]
INSERT IGNORE INTO `nav_setting` (`k`,`v`,`update_time`) VALUES ('pay_qr_wechat','','1795270725') [ RunTime:0.000190s ]
INSERT IGNORE INTO `nav_setting` (`k`,`v`,`update_time`) VALUES ('pay_epay_alipay','0','1795270725') [ RunTime:0.000201s ]
INSERT IGNORE INTO `nav_setting` (`k`,`v`,`update_time`) VALUES ('pay_epay_wxpay','0','1795270725') [ RunTime:0.000221s ]
INSERT IGNORE INTO `nav_setting` (`k`,`v`,`update_time`) VALUES ('pay_epay_url','','1795270725') [ RunTime:0.000210s ]
INSERT IGNORE INTO `nav_setting` (`k`,`v`,`update_time`) VALUES ('pay_epay_pid','','1795270725') [ RunTime:0.003335s ]
INSERT IGNORE INTO `nav_setting` (`k`,`v`,`update_time`) VALUES ('pay_epay_key','','1795270725') [ RunTime:0.000323s ]
INSERT IGNORE INTO `nav_setting` (`k`,`v`,`update_time`) VALUES ('pay_alipay_on','0','1795270725') [ RunTime:0.000234s ]
INSERT IGNORE INTO `nav_setting` (`k`,`v`,`update_time`) VALUES ('pay_alipay_appid','','1795270725') [ RunTime:0.000208s ]
INSERT IGNORE INTO `nav_setting` (`k`,`v`,`update_time`) VALUES ('pay_alipay_private_key','','1795270725') [ RunTime:0.000204s ]
INSERT IGNORE INTO `nav_setting` (`k`,`v`,`update_time`) VALUES ('pay_alipay_public_key','','1795270725') [ RunTime:0.000255s ]
INSERT IGNORE INTO `nav_setting` (`k`,`v`,`update_time`) VALUES ('pay_wechat_on','0','1795270725') [ RunTime:0.000213s ]
INSERT IGNORE INTO `nav_setting` (`k`,`v`,`update_time`) VALUES ('pay_wechat_mchid','','1795270725') [ RunTime:0.000213s ]
INSERT IGNORE INTO `nav_setting` (`k`,`v`,`update_time`) VALUES ('pay_wechat_appid','','1795270725') [ RunTime:0.000212s ]
INSERT IGNORE INTO `nav_setting` (`k`,`v`,`update_time`) VALUES ('pay_wechat_v3key','','1795270725') [ RunTime:0.000265s ]
INSERT IGNORE INTO `nav_setting` (`k`,`v`,`update_time`) VALUES ('pay_wechat_serial','','1795270725') [ RunTime:0.000236s ]
INSERT IGNORE INTO `nav_setting` (`k`,`v`,`update_time`) VALUES ('pay_wechat_private_key','','1795270725') [ RunTime:0.000246s ]
INSERT IGNORE INTO `nav_setting` (`k`,`v`,`update_time`) VALUES ('pay_wechat_platform_cert','','1795270725') [ RunTime:0.001015s ]
INSERT IGNORE INTO `nav_setting` (`k`,`v`,`update_time`) VALUES ('friend_on','1','1795270725') [ RunTime:0.000634s ]
INSERT IGNORE INTO `nav_setting` (`k`,`v`,`update_time`) VALUES ('friend_price','0','1795270725') [ RunTime:0.001071s ]
INSERT IGNORE INTO `nav_setting` (`k`,`v`,`update_time`) VALUES ('friend_free_audit','0','1795270725') [ RunTime:0.000563s ]
INSERT IGNORE INTO `nav_setting` (`k`,`v`,`update_time`) VALUES ('friend_contact','','1795270725') [ RunTime:0.006213s ]
INSERT IGNORE INTO `nav_setting` (`k`,`v`,`update_time`) VALUES ('sponsor_on','1','1795270725') [ RunTime:0.000575s ]
INSERT IGNORE INTO `nav_setting` (`k`,`v`,`update_time`) VALUES ('sponsor_amounts','5,10,20,50,100','1795270725') [ RunTime:0.000278s ]
INSERT IGNORE INTO `nav_setting` (`k`,`v`,`update_time`) VALUES ('sponsor_min','1','1795270725') [ RunTime:0.001149s ]
INSERT IGNORE INTO `nav_setting` (`k`,`v`,`update_time`) VALUES ('sponsor_max','9999','1795270725') [ RunTime:0.000288s ]
INSERT IGNORE INTO `nav_setting` (`k`,`v`,`update_time`) VALUES ('sponsor_rules','','1795270725') [ RunTime:0.000749s ]
INSERT IGNORE INTO `nav_setting` (`k`,`v`,`update_time`) VALUES ('sponsor_audit','0','1795270725') [ RunTime:0.000283s ]
INSERT IGNORE INTO `nav_setting` (`k`,`v`,`update_time`) VALUES ('sponsor_forever_on','0','1795270725') [ RunTime:0.000226s ]
INSERT IGNORE INTO `nav_setting` (`k`,`v`,`update_time`) VALUES ('sponsor_forever_price','10','1795270725') [ RunTime:0.000231s ]
INSERT IGNORE INTO `nav_setting` (`k`,`v`,`update_time`) VALUES ('sponsor_normal_price','0','1795270725') [ RunTime:0.003824s ]
INSERT IGNORE INTO `nav_setting` (`k`,`v`,`update_time`) VALUES ('sponsor_best_price','0','1795270725') [ RunTime:0.000262s ]
INSERT IGNORE INTO `nav_setting` (`k`,`v`,`update_time`) VALUES ('sponsor_any_include','0','1795270725') [ RunTime:0.000229s ]
INSERT IGNORE INTO `nav_setting` (`k`,`v`,`update_time`) VALUES ('sponsor_top_min','0','1795270725') [ RunTime:0.000240s ]
INSERT IGNORE INTO `nav_setting` (`k`,`v`,`update_time`) VALUES ('app_debug','0','1795270725') [ RunTime:0.000193s ]
INSERT IGNORE INTO `nav_setting` (`k`,`v`,`update_time`) VALUES ('dock_on','1','1795270725') [ RunTime:0.000182s ]
INSERT IGNORE INTO `nav_setting` (`k`,`v`,`update_time`) VALUES ('member_on','1','1795270725') [ RunTime:0.000188s ]
INSERT IGNORE INTO `nav_setting` (`k`,`v`,`update_time`) VALUES ('member_pay_on','1','1795270725') [ RunTime:0.000172s ]
INSERT IGNORE INTO `nav_setting` (`k`,`v`,`update_time`) VALUES ('webmaster_on','0','1795270725') [ RunTime:0.000170s ]
INSERT IGNORE INTO `nav_setting` (`k`,`v`,`update_time`) VALUES ('points_on','1','1795270725') [ RunTime:0.000169s ]
INSERT IGNORE INTO `nav_setting` (`k`,`v`,`update_time`) VALUES ('member_note','','1795270725') [ RunTime:0.000168s ]
INSERT IGNORE INTO `nav_setting` (`k`,`v`,`update_time`) VALUES ('points_note','','1795270725') [ RunTime:0.000194s ]
INSERT IGNORE INTO `nav_setting` (`k`,`v`,`update_time`) VALUES ('pkg_gate_on','1','1795270725') [ RunTime:0.000181s ]
INSERT IGNORE INTO `nav_setting` (`k`,`v`,`update_time`) VALUES ('pkg_quota_anon','60','1795270725') [ RunTime:0.000178s ]
INSERT IGNORE INTO `nav_setting` (`k`,`v`,`update_time`) VALUES ('pkg_quota_user','300','1795270725') [ RunTime:0.000178s ]
INSERT IGNORE INTO `nav_setting` (`k`,`v`,`update_time`) VALUES ('pkg_quota_vip','0','1795270725') [ RunTime:0.000174s ]
INSERT IGNORE INTO `nav_setting` (`k`,`v`,`update_time`) VALUES ('secret_on','0','1795270725') [ RunTime:0.000187s ]
INSERT IGNORE INTO `nav_setting` (`k`,`v`,`update_time`) VALUES ('secret_audit','1','1795270725') [ RunTime:0.000172s ]
INSERT IGNORE INTO `nav_setting` (`k`,`v`,`update_time`) VALUES ('secret_max_len','300','1795270725') [ RunTime:0.000172s ]
INSERT IGNORE INTO `nav_setting` (`k`,`v`,`update_time`) VALUES ('secret_rate','60','1795270725') [ RunTime:0.000171s ]
INSERT IGNORE INTO `nav_setting` (`k`,`v`,`update_time`) VALUES ('secret_day_limit','10','1795270725') [ RunTime:0.000171s ]
INSERT IGNORE INTO `nav_setting` (`k`,`v`,`update_time`) VALUES ('secret_ip_day_limit','5','1795270725') [ RunTime:0.000184s ]
INSERT IGNORE INTO `nav_setting` (`k`,`v`,`update_time`) VALUES ('secret_region','1','1795270725') [ RunTime:0.000171s ]
INSERT IGNORE INTO `nav_setting` (`k`,`v`,`update_time`) VALUES ('secret_home','0','1795270725') [ RunTime:0.000176s ]
INSERT IGNORE INTO `nav_setting` (`k`,`v`,`update_time`) VALUES ('secret_site_login','0','1795270725') [ RunTime:0.000181s ]
INSERT IGNORE INTO `nav_setting` (`k`,`v`,`update_time`) VALUES ('comment_on','1','1795270725') [ RunTime:0.000179s ]
INSERT IGNORE INTO `nav_setting` (`k`,`v`,`update_time`) VALUES ('comment_login','0','1795270725') [ RunTime:0.000205s ]
INSERT IGNORE INTO `nav_setting` (`k`,`v`,`update_time`) VALUES ('comment_guest_reply','1','1795270725') [ RunTime:0.000181s ]
INSERT IGNORE INTO `nav_setting` (`k`,`v`,`update_time`) VALUES ('comment_audit','0','1795270725') [ RunTime:0.000180s ]
INSERT IGNORE INTO `nav_setting` (`k`,`v`,`update_time`) VALUES ('comment_max_len','500','1795270725') [ RunTime:0.000177s ]
INSERT IGNORE INTO `nav_setting` (`k`,`v`,`update_time`) VALUES ('comment_rate','30','1795270725') [ RunTime:0.000198s ]
INSERT IGNORE INTO `nav_setting` (`k`,`v`,`update_time`) VALUES ('comment_page_size','10','1795270725') [ RunTime:0.002970s ]
INSERT IGNORE INTO `nav_setting` (`k`,`v`,`update_time`) VALUES ('comment_region','1','1795270725') [ RunTime:0.000197s ]
INSERT IGNORE INTO `nav_setting` (`k`,`v`,`update_time`) VALUES ('comment_admin_badge','1','1795270725') [ RunTime:0.000179s ]
INSERT IGNORE INTO `nav_setting` (`k`,`v`,`update_time`) VALUES ('right_menu_on','1','1795270725') [ RunTime:0.000193s ]
SELECT COUNT(*) AS `c` FROM `nav_member_plan` [ RunTime:0.000222s ]
SELECT COUNT(*) AS `c` FROM `nav_points_pack` [ RunTime:0.000182s ]
SHOW COLUMNS FROM `nav_site` [ RunTime:0.001264s ]
SHOW COLUMNS FROM `nav_site` [ RunTime:0.001222s ]
SHOW COLUMNS FROM `nav_site` [ RunTime:0.001102s ]
SELECT `id`,`slug` FROM `nav_category` [ RunTime:0.000233s ]
SELECT COUNT(*) AS n FROM `nav_category_tag` [ RunTime:0.000224s ]
SELECT `id`,`category_id` FROM `nav_category_tag` ORDER BY `category_id` ASC, `sort` DESC, `id` ASC [ RunTime:0.000314s ]
UPDATE `nav_category_tag` SET `slug` = 'video-1' WHERE `id` = '1' [ RunTime:0.005748s ]
UPDATE `nav_category_tag` SET `slug` = 'video-2' WHERE `id` = '2' [ RunTime:0.008730s ]
UPDATE `nav_category_tag` SET `slug` = 'video-3' WHERE `id` = '3' [ RunTime:0.009200s ]
UPDATE `nav_category_tag` SET `slug` = 'video-4' WHERE `id` = '4' [ RunTime:0.009639s ]
UPDATE `nav_category_tag` SET `slug` = 'video-5' WHERE `id` = '5' [ RunTime:0.033655s ]
UPDATE `nav_category_tag` SET `slug` = 'video-6' WHERE `id` = '6' [ RunTime:0.019661s ]
UPDATE `nav_category_tag` SET `slug` = 'video-7' WHERE `id` = '7' [ RunTime:0.012203s ]
UPDATE `nav_category_tag` SET `slug` = 'video-8' WHERE `id` = '8' [ RunTime:0.009911s ]
UPDATE `nav_category_tag` SET `slug` = 'video-9' WHERE `id` = '9' [ RunTime:0.017799s ]
UPDATE `nav_category_tag` SET `slug` = 'anime-1' WHERE `id` = '10' [ RunTime:0.005888s ]
UPDATE `nav_category_tag` SET `slug` = 'anime-2' WHERE `id` = '11' [ RunTime:0.002083s ]
UPDATE `nav_category_tag` SET `slug` = 'anime-3' WHERE `id` = '12' [ RunTime:0.001877s ]
UPDATE `nav_category_tag` SET `slug` = 'anime-4' WHERE `id` = '13' [ RunTime:0.002019s ]
UPDATE `nav_category_tag` SET `slug` = 'anime-5' WHERE `id` = '14' [ RunTime:0.002804s ]
UPDATE `nav_category_tag` SET `slug` = 'music-1' WHERE `id` = '15' [ RunTime:0.002091s ]
UPDATE `nav_category_tag` SET `slug` = 'music-2' WHERE `id` = '16' [ RunTime:0.002732s ]
UPDATE `nav_category_tag` SET `slug` = 'music-3' WHERE `id` = '17' [ RunTime:0.003586s ]
UPDATE `nav_category_tag` SET `slug` = 'music-4' WHERE `id` = '18' [ RunTime:0.007236s ]
UPDATE `nav_category_tag` SET `slug` = 'music-5' WHERE `id` = '19' [ RunTime:0.004670s ]
UPDATE `nav_category_tag` SET `slug` = 'music-6' WHERE `id` = '20' [ RunTime:0.003013s ]
UPDATE `nav_category_tag` SET `slug` = 'music-7' WHERE `id` = '21' [ RunTime:0.002291s ]
UPDATE `nav_category_tag` SET `slug` = 'music-8' WHERE `id` = '22' [ RunTime:0.004324s ]
UPDATE `nav_category_tag` SET `slug` = 'read-1' WHERE `id` = '23' [ RunTime:0.006430s ]
UPDATE `nav_category_tag` SET `slug` = 'read-2' WHERE `id` = '166' [ RunTime:0.002986s ]
UPDATE `nav_category_tag` SET `slug` = 'read-3' WHERE `id` = '24' [ RunTime:0.001235s ]
UPDATE `nav_category_tag` SET `slug` = 'read-4' WHERE `id` = '25' [ RunTime:0.000789s ]
UPDATE `nav_category_tag` SET `slug` = 'read-5' WHERE `id` = '26' [ RunTime:0.004098s ]
UPDATE `nav_category_tag` SET `slug` = 'read-6' WHERE `id` = '27' [ RunTime:0.001955s ]
UPDATE `nav_category_tag` SET `slug` = 'read-7' WHERE `id` = '169' [ RunTime:0.003403s ]
UPDATE `nav_category_tag` SET `slug` = 'read-8' WHERE `id` = '167' [ RunTime:0.002764s ]
UPDATE `nav_category_tag` SET `slug` = 'read-9' WHERE `id` = '168' [ RunTime:0.004409s ]
UPDATE `nav_category_tag` SET `slug` = 'game-1' WHERE `id` = '28' [ RunTime:0.004671s ]
UPDATE `nav_category_tag` SET `slug` = 'game-2' WHERE `id` = '29' [ RunTime:0.009726s ]
UPDATE `nav_category_tag` SET `slug` = 'game-3' WHERE `id` = '30' [ RunTime:0.007575s ]
UPDATE `nav_category_tag` SET `slug` = 'fun-1' WHERE `id` = '31' [ RunTime:0.000968s ]
UPDATE `nav_category_tag` SET `slug` = 'fun-2' WHERE `id` = '32' [ RunTime:0.001758s ]
UPDATE `nav_category_tag` SET `slug` = 'tools-1' WHERE `id` = '33' [ RunTime:0.002177s ]
UPDATE `nav_category_tag` SET `slug` = 'tools-2' WHERE `id` = '34' [ RunTime:0.000636s ]
UPDATE `nav_category_tag` SET `slug` = 'tools-3' WHERE `id` = '35' [ RunTime:0.002056s ]
UPDATE `nav_category_tag` SET `slug` = 'tools-4' WHERE `id` = '36' [ RunTime:0.006243s ]
UPDATE `nav_category_tag` SET `slug` = 'tools-5' WHERE `id` = '37' [ RunTime:0.004552s ]
UPDATE `nav_category_tag` SET `slug` = 'tools-6' WHERE `id` = '38' [ RunTime:0.004929s ]
UPDATE `nav_category_tag` SET `slug` = 'tools-7' WHERE `id` = '39' [ RunTime:0.002509s ]
UPDATE `nav_category_tag` SET `slug` = 'tools-8' WHERE `id` = '40' [ RunTime:0.001817s ]
UPDATE `nav_category_tag` SET `slug` = 'tools-9' WHERE `id` = '41' [ RunTime:0.004599s ]
UPDATE `nav_category_tag` SET `slug` = 'tools-10' WHERE `id` = '42' [ RunTime:0.001563s ]
UPDATE `nav_category_tag` SET `slug` = 'tools-11' WHERE `id` = '43' [ RunTime:0.004147s ]
UPDATE `nav_category_tag` SET `slug` = 'githubapp-1' WHERE `id` = '203' [ RunTime:0.004159s ]
UPDATE `nav_category_tag` SET `slug` = 'githubapp-2' WHERE `id` = '165' [ RunTime:0.003097s ]
UPDATE `nav_category_tag` SET `slug` = 'learning-1' WHERE `id` = '170' [ RunTime:0.005842s ]
UPDATE `nav_category_tag` SET `slug` = 'learning-2' WHERE `id` = '171' [ RunTime:0.003794s ]
UPDATE `nav_category_tag` SET `slug` = 'learning-3' WHERE `id` = '172' [ RunTime:0.001753s ]
UPDATE `nav_category_tag` SET `slug` = 'learning-4' WHERE `id` = '173' [ RunTime:0.005368s ]
UPDATE `nav_category_tag` SET `slug` = 'learning-5' WHERE `id` = '174' [ RunTime:0.007163s ]
UPDATE `nav_category_tag` SET `slug` = 'learning-6' WHERE `id` = '175' [ RunTime:0.002043s ]
UPDATE `nav_category_tag` SET `slug` = 'learning-7' WHERE `id` = '176' [ RunTime:0.001796s ]
UPDATE `nav_category_tag` SET `slug` = 'learning-8' WHERE `id` = '177' [ RunTime:0.001809s ]
UPDATE `nav_category_tag` SET `slug` = 'learning-9' WHERE `id` = '178' [ RunTime:0.004284s ]
UPDATE `nav_category_tag` SET `slug` = 'learning-10' WHERE `id` = '216' [ RunTime:0.005980s ]
UPDATE `nav_category_tag` SET `slug` = 'learning-11' WHERE `id` = '179' [ RunTime:0.005258s ]
UPDATE `nav_category_tag` SET `slug` = 'learning-12' WHERE `id` = '180' [ RunTime:0.002112s ]
UPDATE `nav_category_tag` SET `slug` = 'mediatools-1' WHERE `id` = '181' [ RunTime:0.001770s ]
UPDATE `nav_category_tag` SET `slug` = 'mediatools-2' WHERE `id` = '182' [ RunTime:0.004312s ]
UPDATE `nav_category_tag` SET `slug` = 'mediatools-3' WHERE `id` = '183' [ RunTime:0.001963s ]
UPDATE `nav_category_tag` SET `slug` = 'mediatools-4' WHERE `id` = '184' [ RunTime:0.001440s ]
UPDATE `nav_category_tag` SET `slug` = 'mediatools-5' WHERE `id` = '185' [ RunTime:0.001469s ]
UPDATE `nav_category_tag` SET `slug` = 'mediatools-6' WHERE `id` = '186' [ RunTime:0.001589s ]
UPDATE `nav_category_tag` SET `slug` = 'mediatools-7' WHERE `id` = '187' [ RunTime:0.007831s ]
UPDATE `nav_category_tag` SET `slug` = 'mediatools-8' WHERE `id` = '188' [ RunTime:0.004627s ]
UPDATE `nav_category_tag` SET `slug` = 'searchtools-1' WHERE `id` = '189' [ RunTime:0.001960s ]
UPDATE `nav_category_tag` SET `slug` = 'searchtools-2' WHERE `id` = '190' [ RunTime:0.001719s ]
UPDATE `nav_category_tag` SET `slug` = 'searchtools-3' WHERE `id` = '191' [ RunTime:0.001872s ]
UPDATE `nav_category_tag` SET `slug` = 'searchtools-4' WHERE `id` = '192' [ RunTime:0.004882s ]
UPDATE `nav_category_tag` SET `slug` = 'searchtools-5' WHERE `id` = '193' [ RunTime:0.001779s ]
UPDATE `nav_category_tag` SET `slug` = 'searchtools-6' WHERE `id` = '194' [ RunTime:0.001792s ]
UPDATE `nav_category_tag` SET `slug` = 'searchtools-7' WHERE `id` = '195' [ RunTime:0.001762s ]
UPDATE `nav_category_tag` SET `slug` = 'searchtools-8' WHERE `id` = '196' [ RunTime:0.002880s ]
UPDATE `nav_category_tag` SET `slug` = 'resources-1' WHERE `id` = '197' [ RunTime:0.001995s ]
UPDATE `nav_category_tag` SET `slug` = 'resources-2' WHERE `id` = '198' [ RunTime:0.002366s ]
UPDATE `nav_category_tag` SET `slug` = 'resources-3' WHERE `id` = '199' [ RunTime:0.005235s ]
UPDATE `nav_category_tag` SET `slug` = 'resources-4' WHERE `id` = '200' [ RunTime:0.004664s ]
UPDATE `nav_category_tag` SET `slug` = 'resources-5' WHERE `id` = '201' [ RunTime:0.004854s ]
UPDATE `nav_category_tag` SET `slug` = 'resources-6' WHERE `id` = '202' [ RunTime:0.003160s ]
UPDATE `nav_category_tag` SET `slug` = 'itshare-1' WHERE `id` = '204' [ RunTime:0.001947s ]
UPDATE `nav_category_tag` SET `slug` = 'itshare-2' WHERE `id` = '205' [ RunTime:0.000803s ]
UPDATE `nav_category_tag` SET `slug` = 'itshare-3' WHERE `id` = '207' [ RunTime:0.004668s ]
UPDATE `nav_category_tag` SET `slug` = 'itshare-4' WHERE `id` = '211' [ RunTime:0.001657s ]
UPDATE `nav_category_tag` SET `slug` = 'itshare-5' WHERE `id` = '212' [ RunTime:0.003651s ]
UPDATE `nav_category_tag` SET `slug` = 'itshare-6' WHERE `id` = '213' [ RunTime:0.009331s ]
UPDATE `nav_category_tag` SET `slug` = 'itshare-7' WHERE `id` = '215' [ RunTime:0.002163s ]
UPDATE `nav_category_tag` SET `slug` = 'itshare-8' WHERE `id` = '229' [ RunTime:0.002983s ]
UPDATE `nav_category_tag` SET `slug` = 'webtools-1' WHERE `id` = '206' [ RunTime:0.006901s ]
UPDATE `nav_category_tag` SET `slug` = 'webtools-2' WHERE `id` = '208' [ RunTime:0.008516s ]
UPDATE `nav_category_tag` SET `slug` = 'webtools-3' WHERE `id` = '210' [ RunTime:0.005466s ]
UPDATE `nav_category_tag` SET `slug` = 'webtools-4' WHERE `id` = '218' [ RunTime:0.002091s ]
UPDATE `nav_category_tag` SET `slug` = 'webtools-5' WHERE `id` = '219' [ RunTime:0.002943s ]
UPDATE `nav_category_tag` SET `slug` = 'webtools-6' WHERE `id` = '221' [ RunTime:0.006206s ]
UPDATE `nav_category_tag` SET `slug` = 'webtools-7' WHERE `id` = '223' [ RunTime:0.002521s ]
UPDATE `nav_category_tag` SET `slug` = 'webtools-8' WHERE `id` = '224' [ RunTime:0.001965s ]
UPDATE `nav_category_tag` SET `slug` = 'webtools-9' WHERE `id` = '226' [ RunTime:0.002608s ]
UPDATE `nav_category_tag` SET `slug` = 'creator-1' WHERE `id` = '209' [ RunTime:0.001817s ]
UPDATE `nav_category_tag` SET `slug` = 'creator-2' WHERE `id` = '214' [ RunTime:0.001207s ]
UPDATE `nav_category_tag` SET `slug` = 'creator-3' WHERE `id` = '217' [ RunTime:0.001372s ]
UPDATE `nav_category_tag` SET `slug` = 'creator-4' WHERE `id` = '220' [ RunTime:0.004928s ]
UPDATE `nav_category_tag` SET `slug` = 'creator-5' WHERE `id` = '222' [ RunTime:0.004224s ]
UPDATE `nav_category_tag` SET `slug` = 'creator-6' WHERE `id` = '225' [ RunTime:0.002970s ]
UPDATE `nav_category_tag` SET `slug` = 'creator-7' WHERE `id` = '227' [ RunTime:0.001825s ]
UPDATE `nav_category_tag` SET `slug` = 'creator-8' WHERE `id` = '228' [ RunTime:0.002695s ]
UPDATE `nav_category_tag` SET `slug` = 'itlearning-1' WHERE `id` = '230' [ RunTime:0.001790s ]
UPDATE `nav_category_tag` SET `slug` = 'itlearning-2' WHERE `id` = '232' [ RunTime:0.001178s ]
UPDATE `nav_category_tag` SET `slug` = 'itlearning-3' WHERE `id` = '234' [ RunTime:0.001117s ]
UPDATE `nav_category_tag` SET `slug` = 'itlearning-4' WHERE `id` = '239' [ RunTime:0.004484s ]
UPDATE `nav_category_tag` SET `slug` = 'itlearning-5' WHERE `id` = '241' [ RunTime:0.002069s ]
UPDATE `nav_category_tag` SET `slug` = 'devtools-1' WHERE `id` = '231' [ RunTime:0.001672s ]
UPDATE `nav_category_tag` SET `slug` = 'devtools-2' WHERE `id` = '233' [ RunTime:0.005713s ]
UPDATE `nav_category_tag` SET `slug` = 'devtools-3' WHERE `id` = '235' [ RunTime:0.002116s ]
UPDATE `nav_category_tag` SET `slug` = 'devtools-4' WHERE `id` = '238' [ RunTime:0.002290s ]
UPDATE `nav_category_tag` SET `slug` = 'devtools-5' WHERE `id` = '240' [ RunTime:0.005617s ]
UPDATE `nav_category_tag` SET `slug` = 'devtools-6' WHERE `id` = '247' [ RunTime:0.007499s ]
UPDATE `nav_category_tag` SET `slug` = 'comsofts-1' WHERE `id` = '236' [ RunTime:0.001685s ]
UPDATE `nav_category_tag` SET `slug` = 'comsofts-2' WHERE `id` = '237' [ RunTime:0.001793s ]
UPDATE `nav_category_tag` SET `slug` = 'comsofts-3' WHERE `id` = '242' [ RunTime:0.002448s ]
UPDATE `nav_category_tag` SET `slug` = 'comsofts-4' WHERE `id` = '243' [ RunTime:0.004522s ]
UPDATE `nav_category_tag` SET `slug` = 'comsofts-5' WHERE `id` = '244' [ RunTime:0.001233s ]
UPDATE `nav_category_tag` SET `slug` = 'comsofts-6' WHERE `id` = '245' [ RunTime:0.002212s ]
UPDATE `nav_category_tag` SET `slug` = 'comsofts-7' WHERE `id` = '246' [ RunTime:0.001760s ]
UPDATE `nav_category_tag` SET `slug` = 'comsofts-8' WHERE `id` = '248' [ RunTime:0.005329s ]
UPDATE `nav_category_tag` SET `slug` = 'officetools-1' WHERE `id` = '249' [ RunTime:0.001596s ]
UPDATE `nav_category_tag` SET `slug` = 'officetools-2' WHERE `id` = '250' [ RunTime:0.001699s ]
UPDATE `nav_category_tag` SET `slug` = 'officetools-3' WHERE `id` = '251' [ RunTime:0.003728s ]
UPDATE `nav_category_tag` SET `slug` = 'officetools-4' WHERE `id` = '252' [ RunTime:0.001531s ]
UPDATE `nav_category_tag` SET `slug` = 'officetools-5' WHERE `id` = '253' [ RunTime:0.001932s ]
UPDATE `nav_category_tag` SET `slug` = 'officetools-6' WHERE `id` = '254' [ RunTime:0.004435s ]
UPDATE `nav_category_tag` SET `slug` = 'officetools-7' WHERE `id` = '255' [ RunTime:0.001768s ]
UPDATE `nav_category_tag` SET `slug` = 'officetools-8' WHERE `id` = '256' [ RunTime:0.001854s ]
UPDATE `nav_category_tag` SET `slug` = 'officetools-9' WHERE `id` = '257' [ RunTime:0.000975s ]
UPDATE `nav_category_tag` SET `slug` = 'officetools-10' WHERE `id` = '258' [ RunTime:0.001050s ]
UPDATE `nav_category_tag` SET `slug` = 'officetools-11' WHERE `id` = '259' [ RunTime:0.004644s ]
SELECT COUNT(*) AS n FROM `nav_link` [ RunTime:0.000273s ]
SELECT `id` FROM `nav_category` WHERE `status` = 1 ORDER BY `sort` DESC, `id` ASC [ RunTime:0.000413s ]
SELECT COUNT(*) AS n FROM `nav_site` WHERE `slug` = 'bilibili-demo' [ RunTime:0.000315s ]
SHOW COLUMNS FROM `nav_site` [ RunTime:0.001180s ]
SELECT COUNT(*) AS n FROM `nav_like_log` [ RunTime:0.000272s ]
SELECT `id` FROM `nav_link` LIMIT 1 [ RunTime:0.000230s ]
SELECT `id` FROM `nav_submit` LIMIT 1 [ RunTime:0.000162s ]
SELECT `id` FROM `nav_qlink` LIMIT 1 [ RunTime:0.000214s ]
SELECT `id` FROM `nav_ad` LIMIT 1 [ RunTime:0.000167s ]
SELECT `id` FROM `nav_ad_plan` LIMIT 1 [ RunTime:0.000247s ]
SELECT `id`,`order_no`,`pay_channel`,`pay_trade_no` FROM `nav_friend_link` LIMIT 1 [ RunTime:0.000173s ]
SELECT `id`,`type`,`tag_id` FROM `nav_dock` LIMIT 1 [ RunTime:0.000179s ]
SHOW COLUMNS FROM `nav_dock` [ RunTime:0.000747s ]
SHOW COLUMNS FROM `nav_ad` [ RunTime:0.000903s ]
SELECT `gift_days`,`pay_channel`,`pay_trade_no` FROM `nav_ad` LIMIT 1 [ RunTime:0.000178s ]
SHOW COLUMNS FROM `nav_ad_plan` [ RunTime:0.000647s ]
SELECT `position` FROM `nav_ad_plan` LIMIT 1 [ RunTime:0.000162s ]
SHOW COLUMNS FROM `nav_ad` [ RunTime:0.000718s ]
SELECT `icon` FROM `nav_ad` LIMIT 1 [ RunTime:0.000159s ]
SHOW COLUMNS FROM `nav_qlink` [ RunTime:0.000709s ]
SELECT `subtitle` FROM `nav_qlink` LIMIT 1 [ RunTime:0.000246s ]
SHOW COLUMNS FROM `nav_site` [ RunTime:0.000801s ]
SELECT `hide_code`,`password` FROM `nav_site` LIMIT 1 [ RunTime:0.000184s ]
SELECT `pv`,`clicks`,`views_m`,`views_d`,`views_p` FROM `nav_site_view_day` LIMIT 1 [ RunTime:0.000169s ]
SELECT `quick_default` FROM `nav_site` LIMIT 1 [ RunTime:0.000143s ]
SELECT `badge_color` FROM `nav_site` LIMIT 1 [ RunTime:0.000144s ]
SELECT `user_id`,`url_key`,`title`,`icon`,`description`,`badge`,`platforms` FROM `nav_user_quick` LIMIT 1 [ RunTime:0.000158s ]
SELECT `slug` FROM `nav_plugin` LIMIT 1 [ RunTime:0.000146s ]
SHOW COLUMNS FROM `nav_plugin` [ RunTime:0.000728s ]
SELECT `type`,`url`,`icon_url`,`cover`,`category`,`color`,`badge`,`need_login`,`points_cost` FROM `nav_plugin` LIMIT 1 [ RunTime:0.000187s ]
SHOW FULL COLUMNS FROM `nav_plugin` [ RunTime:0.000891s ]
SELECT * FROM `nav_plugin` [ RunTime:0.000379s ]
UPDATE `nav_plugin` SET `category` = 'plugin' WHERE `type` = 'local' AND `category` = 'life' AND `update_time` = `create_time` [ RunTime:0.000408s ]
SELECT COUNT(*) AS think_count FROM `nav_plugin` WHERE `type` = 'link' [ RunTime:0.000294s ]
SHOW FULL COLUMNS FROM `nav_setting` [ RunTime:0.003586s ]
SELECT * FROM `nav_setting` WHERE `k` = 'plugin_link_seeded' LIMIT 1 [ RunTime:0.000259s ]
UPDATE `nav_setting` SET `v` = '1' , `update_time` = 1795270725 WHERE `k` = 'plugin_link_seeded' [ RunTime:0.002268s ]
SELECT * FROM `nav_setting` [ RunTime:0.000641s ]
DELETE FROM `nav_setting` WHERE `k` = 'cache_ver' [ RunTime:0.008063s ]
INSERT INTO `nav_setting` SET `k` = 'cache_ver' , `v` = '1795270725.8634' , `update_time` = 1795270725 [ RunTime:0.001674s ]
SELECT * FROM `nav_setting` [ RunTime:0.000869s ]
SELECT `alias`,`template`,`content`,`referer_on`,`referer_flag`,`pwd_fail_on`,`pwd_fail_url`,`password`,`password_tip`,`owner` FROM `nav_dypage` LIMIT 1 [ RunTime:0.000309s ]
SHOW COLUMNS FROM `nav_sponsor` [ RunTime:0.001044s ]
SELECT `order_no`,`pay_time`,`ip` FROM `nav_sponsor` LIMIT 1 [ RunTime:0.000212s ]
SHOW COLUMNS FROM `nav_sponsor_order` [ RunTime:0.002476s ]
SELECT `order_no`,`sponsor_id`,`amount`,`base_amount`,`forever`,`include_site`,`ip` FROM `nav_sponsor_order` LIMIT 1 [ RunTime:0.000191s ]
SHOW COLUMNS FROM `nav_user_favorite` [ RunTime:0.000983s ]
SELECT `ip` FROM `nav_user_favorite` LIMIT 1 [ RunTime:0.000190s ]
SHOW COLUMNS FROM `nav_user_like` [ RunTime:0.000873s ]
SELECT `ip` FROM `nav_user_like` LIMIT 1 [ RunTime:0.000200s ]
SHOW COLUMNS FROM `nav_points_log` [ RunTime:0.000996s ]
SELECT `ip` FROM `nav_points_log` LIMIT 1 [ RunTime:0.000896s ]
SHOW COLUMNS FROM `nav_invite_order` [ RunTime:0.000949s ]
DELETE FROM `nav_sponsor` WHERE `order_no` = '' AND `pay_time` = 0 AND `name` LIKE '星友%' [ RunTime:0.003563s ]
SELECT COUNT(*) AS `c` FROM `nav_sponsor` [ RunTime:0.000228s ]
SHOW COLUMNS FROM `nav_article` [ RunTime:0.002674s ]
SELECT COUNT(*) AS `c` FROM `nav_micro_post` [ RunTime:0.000261s ]
SHOW COLUMNS FROM `nav_submit` [ RunTime:0.001860s ]
SELECT `user_id` FROM `nav_submit` LIMIT 1 [ RunTime:0.000227s ]
SHOW COLUMNS FROM `nav_submit` [ RunTime:0.000954s ]
SELECT `amount`,`order_no`,`pay_time`,`site_id` FROM `nav_submit` LIMIT 1 [ RunTime:0.000200s ]
SELECT `email`,`scene` FROM `nav_user_email_code` LIMIT 1 [ RunTime:0.000189s ]
SELECT `user_id`,`target_id` FROM `nav_user_history` LIMIT 1 [ RunTime:0.000181s ]
UPDATE `nav_user` SET `email_verified` = 1 WHERE `email` = '' [ RunTime:0.000223s ]
SELECT `code`,`status` FROM `nav_invite_code` LIMIT 1 [ RunTime:0.000200s ]
SELECT `order_no`,`status`,`invite_code` FROM `nav_invite_order` LIMIT 1 [ RunTime:0.000177s ]
SELECT `type`,`months`,`price` FROM `nav_member_plan` LIMIT 1 [ RunTime:0.000179s ]
SELECT `points`,`bonus`,`price` FROM `nav_points_pack` LIMIT 1 [ RunTime:0.000195s ]
SELECT `order_no`,`type`,`status` FROM `nav_member_order` LIMIT 1 [ RunTime:0.000202s ]
SELECT `user_id`,`delta`,`type` FROM `nav_points_log` LIMIT 1 [ RunTime:0.000208s ]
SELECT `ticket_hash`,`slug`,`bucket` FROM `nav_pkg_key_log` LIMIT 1 [ RunTime:0.000202s ]
SHOW COLUMNS FROM `nav_user` [ RunTime:0.001027s ]
SELECT `webmaster_expire` FROM `nav_user` LIMIT 1 [ RunTime:0.000185s ]
SHOW INDEX FROM `nav_site` [ RunTime:0.000428s ]
SHOW INDEX FROM `nav_article` [ RunTime:0.000307s ]
SHOW INDEX FROM `nav_submit` [ RunTime:0.000275s ]
SHOW INDEX FROM `nav_user` [ RunTime:0.000260s ]
SHOW INDEX FROM `nav_points_log` [ RunTime:0.000251s ]
SHOW INDEX FROM `nav_invite_order` [ RunTime:0.000227s ]
SHOW INDEX FROM `nav_member_order` [ RunTime:0.000235s ]
SHOW INDEX FROM `nav_ad` [ RunTime:0.000213s ]
SHOW INDEX FROM `nav_sponsor` [ RunTime:0.000183s ]
SHOW INDEX FROM `nav_sponsor_order` [ RunTime:0.000206s ]
SELECT `id`,`status`,`device_hash` FROM `nav_secret_post` LIMIT 1 [ RunTime:0.000170s ]
SELECT `id`,`post_id` FROM `nav_secret_report` LIMIT 1 [ RunTime:0.003189s ]
SELECT `id`,`page_key`,`status`,`root_id` FROM `nav_comment` LIMIT 1 [ RunTime:0.000167s ]
SHOW COLUMNS FROM `nav_comment` [ RunTime:0.000903s ]
SELECT `ip` FROM `nav_comment` LIMIT 1 [ RunTime:0.000166s ]
SHOW COLUMNS FROM `nav_qlink` [ RunTime:0.000758s ]
SELECT `folder_kind` FROM `nav_qlink` LIMIT 1 [ RunTime:0.000164s ]
SELECT `qlink_id`,`kind`,`ref_id`,`sort` FROM `nav_qlink_item` LIMIT 1 [ RunTime:0.000144s ]
SELECT COUNT(*) AS `c` FROM `nav_right_menu` [ RunTime:0.000157s ]
SELECT `id`,`scope_type`,`enabled` FROM `nav_right_menu` LIMIT 1 [ RunTime:0.000150s ]
SELECT `rid`,`label`,`action` FROM `nav_right_menu_item` LIMIT 1 [ RunTime:0.000180s ]
SELECT `id`,`rid`,`sort` FROM `nav_right_menu_item` WHERE `action` = 'fav' AND `label` = '收藏 / 屏蔽此站' [ RunTime:0.000193s ]
ALTER TABLE `nav_right_menu` MODIFY COLUMN `scope_type` varchar(50) NOT NULL DEFAULT 'site' [ RunTime:0.015859s ]
ALTER TABLE `nav_right_menu_item` MODIFY COLUMN `icon` varchar(500) NOT NULL DEFAULT '' [ RunTime:0.007065s ]
SELECT `icon` FROM `nav_right_menu_item` LIMIT 1 [ RunTime:0.000220s ]
SELECT `pid` FROM `nav_right_menu_item` LIMIT 1 [ RunTime:0.000216s ]
SELECT COUNT(*) AS `c` FROM `nav_home_module` [ RunTime:0.002834s ]
SELECT `id`,`mkey`,`zone` FROM `nav_home_module` LIMIT 1 [ RunTime:0.000216s ]
SELECT `id`,`mkey` FROM `nav_home_module` [ RunTime:0.000195s ]
SELECT `id`,`mkey`,`sort` FROM `nav_home_module` [ RunTime:0.000239s ]
SELECT `block_id`,`type`,`source_id`,`weight`,`is_ad` FROM `nav_home_pic` LIMIT 1 [ RunTime:0.000200s ]
SELECT COUNT(*) AS `c` FROM `nav_home_block` [ RunTime:0.000186s ]
SELECT `id` FROM `nav_home_block` ORDER BY `sort` ASC, `id` ASC LIMIT 1 [ RunTime:0.000218s ]
UPDATE `nav_home_pic` SET `block_id` = '3' WHERE `block_id` = 0 [ RunTime:0.000281s ]
SELECT `rank_type`,`rank_period` FROM `nav_home_block` LIMIT 1 [ RunTime:0.000209s ]
SELECT `is_countdown` FROM `nav_home_pic` LIMIT 1 [ RunTime:0.000194s ]
SELECT `note_text`,`note_author` FROM `nav_home_block` LIMIT 1 [ RunTime:0.000216s ]
SELECT `is_video` FROM `nav_home_pic` LIMIT 1 [ RunTime:0.000185s ]
SELECT `audience`,`ab_enable`,`ab_ratio` FROM `nav_home_block` LIMIT 1 [ RunTime:0.000199s ]
SELECT `pic_id`,`day`,`views`,`clicks` FROM `nav_home_pic_stat` LIMIT 1 [ RunTime:0.000195s ]
SELECT `block_id`,`day`,`grp`,`exposes`,`clicks` FROM `nav_home_block_stat` LIMIT 1 [ RunTime:0.000194s ]
SELECT `note_items` FROM `nav_home_block` LIMIT 1 [ RunTime:0.000189s ]
SELECT `cat`,`item_id` FROM `nav_shijuan_item` LIMIT 1 [ RunTime:0.000198s ]
SELECT `item_id` FROM `nav_shijuan_download` LIMIT 1 [ RunTime:0.000191s ]
SELECT `slug` FROM `nav_shijuan_category` LIMIT 1 [ RunTime:0.000168s ]
SELECT `slug` FROM `nav_shijuan_subject` LIMIT 1 [ RunTime:0.000191s ]
SELECT `file`,`license`,`rtype`,`status`,`update_time` FROM `nav_shijuan_item` LIMIT 1 [ RunTime:0.000186s ]
SELECT `icon` FROM `nav_shijuan_subject` LIMIT 1 [ RunTime:0.000175s ]
SELECT `icon` FROM `nav_shijuan_category` LIMIT 1 [ RunTime:0.000184s ]
SELECT `feedback`,`feedback_status`,`feedback_time` FROM `nav_shijuan_item` LIMIT 1 [ RunTime:0.000207s ]
SELECT `cover` FROM `nav_sponsor` LIMIT 1 [ RunTime:0.000186s ]
SELECT `feedback`,`feedback_status`,`feedback_time` FROM `nav_article` LIMIT 1 [ RunTime:0.000204s ]
SELECT `cover`,`bg_style`,`name_color`,`extra_color` FROM `nav_qlink` LIMIT 1 [ RunTime:0.000199s ]
SELECT `parent_id` FROM `nav_article_cat` LIMIT 1 [ RunTime:0.000269s ]
SELECT `is_rec` FROM `nav_article_cat` LIMIT 1 [ RunTime:0.000154s ]
SELECT `is_nav` FROM `nav_article_cat` LIMIT 1 [ RunTime:0.000177s ]
SELECT `banner_img`,`banner_sub`,`tile_sort` FROM `nav_article` LIMIT 1 [ RunTime:0.000177s ]
SELECT `dl_on`,`dl_gate`,`dl_price`,`dl_vip`,`dl_vip_price`,`dl_hours`,`dl_tip`,`downloads`,`dl_count` FROM `nav_article` LIMIT 1 [ RunTime:0.000177s ]
SELECT `remark` FROM `nav_article` LIMIT 1 [ RunTime:0.000165s ]
SELECT `points_on`,`points_price` FROM `nav_article` LIMIT 1 [ RunTime:0.000160s ]
SELECT `id` FROM `nav_article_points_unlock` LIMIT 1 [ RunTime:0.000159s ]
SELECT `id` FROM `nav_points_signin` LIMIT 1 [ RunTime:0.000196s ]
SELECT `id` FROM `nav_dl_ticket` LIMIT 1 [ RunTime:0.000202s ]
SELECT `id`,`type`,`url` FROM `nav_article_menu` LIMIT 1 [ RunTime:0.000178s ]
SELECT COUNT(*) AS `c` FROM `nav_article_menu` [ RunTime:0.000163s ]
SHOW COLUMNS FROM `nav_article_menu` [ RunTime:0.000846s ]
SELECT `hide_in_parent` FROM `nav_article_menu` LIMIT 1 [ RunTime:0.000156s ]
SHOW COLUMNS FROM `nav_article_menu` [ RunTime:0.003974s ]
SELECT `title_color` FROM `nav_article_menu` LIMIT 1 [ RunTime:0.000272s ]
SELECT `article_cfg` FROM `nav_home_block` LIMIT 1 [ RunTime:0.000177s ]
SELECT `is_list` FROM `nav_article_cat` LIMIT 1 [ RunTime:0.000174s ]
SHOW COLUMNS FROM `nav_link` [ RunTime:0.000914s ]
SELECT `name_color` FROM `nav_link` LIMIT 1 [ RunTime:0.000196s ]
SHOW COLUMNS FROM `nav_fx_url` [ RunTime:0.000976s ]
SELECT `pass_hash` FROM `nav_fx_url` LIMIT 1 [ RunTime:0.000172s ]
SHOW COLUMNS FROM `nav_fx_url` [ RunTime:0.000977s ]
SELECT `pass_view` FROM `nav_fx_url` LIMIT 1 [ RunTime:0.000182s ]
SHOW COLUMNS FROM `nav_fx_url` [ RunTime:0.001024s ]
SELECT `notified` FROM `nav_fx_url` LIMIT 1 [ RunTime:0.003139s ]
SHOW COLUMNS FROM `nav_fx_url` [ RunTime:0.000940s ]
SELECT `view_time` FROM `nav_fx_url` LIMIT 1 [ RunTime:0.000184s ]
SELECT `name_color` FROM `nav_category` LIMIT 1 [ RunTime:0.000201s ]
SELECT `name_color`,`icon_color` FROM `nav_category_tag` LIMIT 1 [ RunTime:0.000200s ]
SELECT `name_color`,`icon_color` FROM `nav_friend_link` LIMIT 1 [ RunTime:0.000144s ]
SELECT `id`,`source`,`type`,`target_id`,`url_key` FROM `nav_user_dock` LIMIT 1 [ RunTime:0.000166s ]
SELECT * FROM `nav_setting` [ RunTime:0.000516s ]
SHOW FULL COLUMNS FROM `nav_category` [ RunTime:0.000844s ]
SELECT * FROM `nav_category` WHERE `status` = 1 ORDER BY `sort` DESC,`id` ASC [ RunTime:0.000303s ]
SHOW FULL COLUMNS FROM `nav_site` [ RunTime:0.003785s ]
SELECT `hide_code` FROM `nav_site` LIMIT 1 [ RunTime:0.000175s ]
SELECT category_id, COUNT(*) AS n FROM `nav_site` WHERE `status` = 1 AND `hide_code` = '' GROUP BY `category_id` [ RunTime:0.004969s ]
SELECT SUM(`views`) AS think_sum FROM `nav_site` WHERE `status` = 1 AND `hide_code` = '' [ RunTime:0.010014s ]
SHOW FULL COLUMNS FROM `nav_article` [ RunTime:0.004281s ]
SELECT SUM(`views`) AS think_sum FROM `nav_article` WHERE `status` = 1 [ RunTime:0.003382s ]
SELECT SUM(`likes`) AS think_sum FROM `nav_site` WHERE `status` = 1 AND `hide_code` = '' [ RunTime:0.011312s ]
SHOW FULL COLUMNS FROM `nav_category_tag` [ RunTime:0.004094s ]
SELECT COUNT(*) AS think_count FROM `nav_category_tag` WHERE `status` = 1 [ RunTime:0.000242s ]
SHOW FULL COLUMNS FROM `nav_user` [ RunTime:0.000717s ]
SELECT COUNT(*) AS think_count FROM `nav_user` [ RunTime:0.000174s ]
SELECT SUM(`views_today`) AS think_sum FROM `nav_site` WHERE `status` = 1 AND `hide_code` = '' AND `views_date` = 1795190400 [ RunTime:0.011653s ]
SELECT * FROM `nav_category_tag` WHERE `status` = 1 ORDER BY `sort` DESC,`id` ASC [ RunTime:0.000967s ]
SELECT category_id, tag_id, COUNT(*) AS n FROM `nav_site` WHERE `status` = 1 AND `hide_code` = '' GROUP BY `category_id`,`tag_id` [ RunTime:0.015900s ]
SELECT * FROM `nav_site` WHERE `status` = 1 AND `hide_code` = '' AND `views_date` = 1795190400 AND `views_today` > 0 ORDER BY `views_today` DESC,`id` DESC LIMIT 8 [ RunTime:0.000775s ]
SHOW FULL COLUMNS FROM `nav_like_log` [ RunTime:0.000919s ]
SELECT `target_id` FROM `nav_like_log` WHERE `type` = 'site' AND `ip` = '216.73.216.88' [ RunTime:0.000328s ]
SELECT * FROM `nav_category` WHERE `status` = 1 ORDER BY `sort` DESC,`id` ASC [ RunTime:0.000415s ]
SELECT * FROM `nav_category_tag` WHERE `status` = 1 ORDER BY `sort` DESC,`id` ASC [ RunTime:0.000740s ]
SELECT category_id, tag_id, COUNT(*) AS n FROM `nav_site` WHERE `status` = 1 AND `hide_code` = '' GROUP BY `category_id`,`tag_id` [ RunTime:0.006490s ]
SHOW FULL COLUMNS FROM `nav_comment` [ RunTime:0.000992s ]
SELECT page_key, COUNT(*) AS n FROM `nav_comment` WHERE `status` = 1 AND ( `page_key` LIKE 'site:%' OR `page_key` LIKE 'app:%' ) GROUP BY `page_key` [ RunTime:0.000314s ]
SELECT * FROM `nav_site` WHERE `status` = 1 AND `hide_code` = '' AND `views_wkey` = '202647' AND `views_week` > 0 ORDER BY `views_week` DESC,`id` DESC LIMIT 8 [ RunTime:0.000539s ]
SELECT * FROM `nav_site` WHERE `status` = 1 AND `hide_code` = '' AND `views_mkey` = '202611' AND `views_month` > 0 ORDER BY `views_month` DESC,`id` DESC LIMIT 8 [ RunTime:0.012143s ]
SELECT * FROM `nav_site` WHERE `status` = 1 AND `hide_code` = '' ORDER BY `views` DESC,`id` DESC LIMIT 8 [ RunTime:0.000771s ]
SHOW FULL COLUMNS FROM `nav_ad` [ RunTime:0.001246s ]
SELECT * FROM `nav_ad` WHERE `status` = 2 AND `position` = 'home_banner' AND `start_time` <= 1795270726 AND `end_time` >= 1795270726 ORDER BY `sort` DESC,`id` DESC LIMIT 20 [ RunTime:0.000567s ]
SHOW FULL COLUMNS FROM `nav_notice` [ RunTime:0.000937s ]
SELECT * FROM `nav_notice` WHERE `status` = 1 ORDER BY `sort` DESC,`id` DESC LIMIT 8 [ RunTime:0.000284s ]
SELECT `cover`,`bg_style`,`name_color`,`extra_color` FROM `nav_qlink` LIMIT 1 [ RunTime:0.000229s ]
SHOW FULL COLUMNS FROM `nav_qlink` [ RunTime:0.001119s ]
SELECT * FROM `nav_qlink` WHERE `status` = 1 ORDER BY `sort` ASC,`id` ASC LIMIT 48 [ RunTime:0.000374s ]
SELECT `folder_cats`,`folder_sort`,`folder_limit`,`folder_cache`,`folder_inc_sub` FROM `nav_qlink` LIMIT 1 [ RunTime:0.004861s ]
SHOW FULL COLUMNS FROM `nav_qlink_item` [ RunTime:0.000956s ]
SELECT * FROM `nav_qlink_item` WHERE `qlink_id` = 5 AND `kind` = 'site' ORDER BY `sort` ASC,`id` ASC [ RunTime:0.000356s ]
SELECT `id` FROM `nav_site` WHERE `status` = 1 AND `category_id` = 4 AND `hide_code` = '' ORDER BY `create_time` DESC,`id` DESC LIMIT 10 [ RunTime:0.001921s ]
SELECT * FROM `nav_qlink_item` WHERE `qlink_id` = 6 AND `kind` = 'article' ORDER BY `sort` ASC,`id` ASC [ RunTime:0.000302s ]
SELECT `id` FROM `nav_article` WHERE `status` = 1 AND `category_id` = 12 ORDER BY `create_time` DESC,`id` DESC LIMIT 10 [ RunTime:0.003490s ]
SELECT * FROM `nav_qlink_item` WHERE `qlink_id` = 7 AND `kind` = 'article' ORDER BY `sort` ASC,`id` ASC [ RunTime:0.000297s ]
SELECT `id` FROM `nav_article` WHERE `status` = 1 AND `category_id` = 22 ORDER BY `create_time` DESC,`id` DESC LIMIT 10 [ RunTime:0.000681s ]
SELECT * FROM `nav_qlink_item` WHERE `qlink_id` = 3 AND `kind` = 'site' ORDER BY `sort` ASC,`id` ASC [ RunTime:0.000291s ]
SELECT `id` FROM `nav_site` WHERE `status` = 1 AND `id` IN (1082,1187,865,941,988,774,773,771,776,778,790,1011,1016,1017,763,594) AND `hide_code` = '' [ RunTime:0.000437s ]
SELECT `id` FROM `nav_site` WHERE `status` = 1 AND `category_id` = 1 AND `hide_code` = '' AND `id` NOT IN (1082,1187,865,941,988,774,773,771,776,778,790,1011,1016,1017,763,594) ORDER BY `create_time` DESC,`id` DESC LIMIT 34 [ RunTime:0.001080s ]
SELECT * FROM `nav_qlink_item` WHERE `qlink_id` = 4 AND `kind` = 'article' ORDER BY `sort` ASC,`id` ASC [ RunTime:0.000271s ]
SELECT `id` FROM `nav_article` WHERE `status` = 1 AND `id` = 5507 [ RunTime:0.000205s ]
SELECT `id` FROM `nav_article` WHERE `status` = 1 AND `category_id` = 44 AND `id` <> 5507 ORDER BY `create_time` DESC,`id` DESC LIMIT 29 [ RunTime:0.007546s ]
SHOW FULL COLUMNS FROM `nav_home_block` [ RunTime:0.001209s ]
SELECT * FROM `nav_home_block` WHERE `status` = 1 ORDER BY `sort` ASC,`id` ASC [ RunTime:0.000336s ]
SELECT `id` FROM `nav_article` WHERE `status` = 1 ORDER BY `is_top` DESC,`id` DESC LIMIT 20 [ RunTime:0.000326s ]
SELECT * FROM `nav_article` WHERE `status` = 1 AND `id` NOT IN (5507,8549,8548,8547,8546,8545,8544,8543,8542,8541,8540,8539,8538,8537,8536,8535,8534,8533,8532,8531) ORDER BY `is_top` DESC,`id` DESC LIMIT 300 [ RunTime:0.015412s ]
SHOW FULL COLUMNS FROM `nav_article_cat` [ RunTime:0.001455s ]
SELECT * FROM `nav_article_cat` WHERE `status` = 1 ORDER BY `sort` DESC,`id` ASC [ RunTime:0.000393s ]
SELECT * FROM `nav_home_block` ORDER BY `sort` ASC,`id` ASC [ RunTime:0.000354s ]
SHOW FULL COLUMNS FROM `nav_home_module` [ RunTime:0.000650s ]
SELECT * FROM `nav_home_module` WHERE `zone` = 'rail' ORDER BY `sort` ASC,`id` ASC [ RunTime:0.000260s ]
SELECT * FROM `nav_home_block` ORDER BY `sort` ASC,`id` ASC [ RunTime:0.000426s ]
SELECT * FROM `nav_home_module` WHERE `zone` = 'rail' ORDER BY `sort` ASC,`id` ASC [ RunTime:0.000245s ]
SHOW FULL COLUMNS FROM `nav_link` [ RunTime:0.003490s ]
SELECT * FROM `nav_link` WHERE `status` = 1 AND `position` = 'top' ORDER BY `sort` ASC,`id` ASC [ RunTime:0.000324s ]
SELECT * FROM `nav_link` WHERE `status` = 1 AND `position` = 'foot' ORDER BY `sort` ASC,`id` ASC [ RunTime:0.000307s ]
SHOW FULL COLUMNS FROM `nav_dock` [ RunTime:0.000922s ]
SELECT * FROM `nav_dock` WHERE `status` = 1 ORDER BY `sort` ASC,`id` ASC LIMIT 12 [ RunTime:0.000444s ]
SELECT * FROM `nav_category_tag` WHERE `status` = 1 ORDER BY `sort` DESC,`id` ASC [ RunTime:0.000494s ]
SELECT category_id, tag_id, COUNT(*) AS n FROM `nav_site` WHERE `status` = 1 AND `hide_code` = '' GROUP BY `category_id`,`tag_id` [ RunTime:0.004831s ]
SELECT * FROM `nav_article_cat` WHERE `status` = 1 ORDER BY `sort` DESC,`id` ASC [ RunTime:0.003326s ]
SHOW FULL COLUMNS FROM `nav_sponsor` [ RunTime:0.002915s ]
SELECT * FROM `nav_sponsor` WHERE `status` = 1 ORDER BY `amount` DESC,`id` ASC LIMIT 8 [ RunTime:0.000543s ]
SELECT * FROM `nav_site` WHERE `id` IN (208,97,69,152,41,124,207) [ RunTime:0.000445s ]
SELECT COUNT(*) AS think_count FROM `nav_site` WHERE `status` = 1 AND `hide_code` = '' [ RunTime:0.009036s ]
SELECT COUNT(*) AS think_count FROM `nav_article` WHERE `status` = 1 [ RunTime:0.005784s ]
SELECT COUNT(*) AS think_count FROM `nav_notice` WHERE `status` = 1 [ RunTime:0.000223s ]
SELECT COUNT(*) AS think_count FROM `nav_sponsor` WHERE `status` = 1 [ RunTime:0.000171s ]
SELECT COUNT(*) AS think_count FROM `nav_site` WHERE `status` = 1 AND `hide_code` = '' AND `create_time` >= 1795190400 [ RunTime:0.000348s ]
SELECT * FROM `nav_article_cat` WHERE `status` = 1 ORDER BY `sort` DESC,`id` ASC [ RunTime:0.000369s ]
SELECT * FROM `nav_article` WHERE `status` = 1 ORDER BY `views` DESC,`id` DESC LIMIT 6 [ RunTime:0.000431s ]
SELECT * FROM `nav_article` WHERE `status` = 1 ORDER BY `create_time` DESC,`id` DESC LIMIT 8 [ RunTime:0.000520s ]
SELECT category_id, COUNT(*) AS n FROM `nav_article` WHERE `status` = 1 GROUP BY `category_id` [ RunTime:0.022330s ]
SELECT * FROM `nav_article_cat` WHERE `status` = 1 ORDER BY `sort` DESC,`id` ASC [ RunTime:0.000464s ]
SELECT COUNT(*) AS think_count FROM `nav_article` WHERE `status` = 1 [ RunTime:0.008194s ]
SELECT MAX(`update_time`) AS think_max FROM `nav_article` WHERE `status` = 1 [ RunTime:0.015094s ]
SELECT COUNT(*) AS think_count FROM `nav_comment` WHERE `status` = 1 [ RunTime:0.002550s ]
SELECT * FROM `nav_article_cat` WHERE `status` = 1 ORDER BY `sort` DESC,`id` ASC [ RunTime:0.000374s ]
SELECT * FROM `nav_article_cat` WHERE `status` = 1 ORDER BY `sort` DESC,`id` ASC [ RunTime:0.000336s ]
SELECT `id`,`page_key`,`nickname`,`avatar`,`content`,`create_time`,`is_admin`,`user_id`,`level` FROM `nav_comment` WHERE `status` = 1 AND `page_key` LIKE 'article:%' ORDER BY `id` DESC LIMIT 30 [ RunTime:0.000431s ]
SELECT `id`,`title` FROM `nav_article` WHERE `id` IN (1504,5475,5273,3477) AND `status` = 1 [ RunTime:0.000323s ]
SELECT category_id, COUNT(*) AS n FROM `nav_article` WHERE `status` = 1 GROUP BY `category_id` [ RunTime:0.017650s ]
SHOW FULL COLUMNS FROM `nav_article_menu` [ RunTime:0.001031s ]
SELECT COUNT(*) AS think_count FROM `nav_article_menu` [ RunTime:0.000207s ]
SELECT * FROM `nav_article_menu` WHERE `status` = 1 ORDER BY `sort` DESC,`id` ASC [ RunTime:0.000301s ]
SELECT * FROM `nav_article_cat` WHERE `status` = 1 ORDER BY `sort` DESC,`id` ASC [ RunTime:0.000365s ]
SELECT `tags` FROM `nav_article` WHERE `status` = 1 ORDER BY `id` DESC LIMIT 400 [ RunTime:0.000877s ]
SHOW FULL COLUMNS FROM `nav_micro_post` [ RunTime:0.000867s ]
SELECT * FROM `nav_micro_post` WHERE `status` = 1 ORDER BY `sort` DESC,`id` DESC LIMIT 3 [ RunTime:0.000255s ]
SELECT `id`,`title`,`views` FROM `nav_article` WHERE `status` = 1 ORDER BY `views` DESC,`id` DESC LIMIT 5 [ RunTime:0.000358s ]
SELECT `tags` FROM `nav_article` WHERE `status` = 1 ORDER BY `id` DESC LIMIT 400 [ RunTime:0.001051s ]