{"action":"reopened","issue":{"url":"https://api.github.com/repos/calvinwilliams/tcplstat/issues/3","repository_url":"https://api.github.com/repos/calvinwilliams/tcplstat","labels_url":"https://api.github.com/repos/calvinwilliams/tcplstat/issues/3/labels{/name}","comments_url":"https://api.github.com/repos/calvinwilliams/tcplstat/issues/3/comments","events_url":"https://api.github.com/repos/calvinwilliams/tcplstat/issues/3/events","html_url":"https://github.com/calvinwilliams/tcplstat/issues/3","id":304220084,"number":3,"title":"sql抓取时间是sql运行时间的两倍？？？","user":{"login":"zsyprince","id":3724601,"avatar_url":"https://avatars1.githubusercontent.com/u/3724601?v=4","gravatar_id":"","url":"https://api.github.com/users/zsyprince","html_url":"https://github.com/zsyprince","followers_url":"https://api.github.com/users/zsyprince/followers","following_url":"https://api.github.com/users/zsyprince/following{/other_user}","gists_url":"https://api.github.com/users/zsyprince/gists{/gist_id}","starred_url":"https://api.github.com/users/zsyprince/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/zsyprince/subscriptions","organizations_url":"https://api.github.com/users/zsyprince/orgs","repos_url":"https://api.github.com/users/zsyprince/repos","events_url":"https://api.github.com/users/zsyprince/events{/privacy}","received_events_url":"https://api.github.com/users/zsyprince/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":3,"created_at":"2018-03-12T02:09:43Z","updated_at":"2018-03-21T07:12:20Z","closed_at":null,"author_association":"NONE","body":"你好：\r\n    很荣幸用到这个tcplstat 工具，最近我在学习网络，看到这个工具后，操作试试，\r\n我抓取端口3306时候，发现sql时间是程序中的双倍，程序中设置是 sleep(1),以为是程序本身慢，加上sleep 1  导致 是2秒，\r\n后来改为sleep(5)仍然是双倍，请问这是什么原因，？\r\n\r\n```\r\n[root@zsy ~]# tcplstat -f \"tcp port 3306\" --sql\r\n\r\nQ | 2018-03-12T10:00:28.639011 | 2.000542 | select sleep(1) from test_user\r\n```\r\n\r\n上面是结果，下面是sql语句\r\n```\r\n//查询\r\n$sql     =\"select sleep(1) from test_user\";\r\n$stmt    = $pdo->prepare($sql);\r\n$stmt->execute();\r\n$ret = $stmt->fetchAll(PDO::FETCH_ASSOC);\r\nvar_dump($ret);\r\n\r\n```\r\n"}}
{"actor":{"display_login":"zsyprince"}}