一、下载Download - Neor Profile SQL

http://www.profilesql.com/files/download/sqlprofiler-4.1.1.exe

Neor Profile 这款免费的mysql 分析工具，这个工具类似于一个代理

本地启动一个mysql 代理服务，类似于MyCat

二、安装完成配置

 

 

 三、代码连接代理

using System;
using System.Collections.Generic;
using System.Linq;
using Dapper;
using mysql.demo.Entitys;
using MySql.Data.MySqlClient;namespace mysql.demo
{internal class Program{static int ownerId = 2;static void Main(string[] args){using (var connection = new MySqlConnection("Server=localhost;User ID=root;Password=123456;Database=demo;Allow User Variables=true"))//using (var connection = new MySqlConnection("Server=192.168.31.132;User ID=root;Password=123456;Database=demo;Allow User Variables=true")){connection.Open();//新增connection.Execute("INSERT  posts(Title, Content,OwnerId) VALUES (@Title, @Content,@OwnerId)", new List<Post> { new Post { Title = Guid.NewGuid().ToString(), Content = DateTime.Now.ToFileTime().ToString(), OwnerId = ownerId } });connection.Execute("INSERT  users(Name) VALUES (@Name)", new User { Name = Guid.NewGuid().ToString() });var sql2 = " select * from posts; select * from users";using (var multi = connection.QueryMultiple(sql2, new { })){var orders = multi.Read<Post>().ToList();var returns = multi.Read<User>().ToList();}var users = connection.Query<User>("select * from users;");var sql =@"select * from posts pleft join users u on u.Id = p.OwnerIdOrder by p.Id";var data = connection.Query<Post, User, Post>(sql, (post, user) => { post.Owner = user; return post; });var post = data.First();}}}
}

监控到的Sql: