Skip to content

Instantly share code, notes, and snippets.

@rubyonrailsworks

rubyonrailsworks/location.log

Last active December 27, 2015 22:18
Show Gist options
  • Save rubyonrailsworks/7397767 to your computer and use it in GitHub Desktop.
Save rubyonrailsworks/7397767 to your computer and use it in GitHub Desktop.
Download ZIP
Weixin
Raw
location.log
Started POST "/api/service?id=MTAwMDE=&signature=e9a66c8c14c88925e45dc2df11d066c34c415bd2&timestamp=1384088325&nonce=1383278484" for 101.226.33.171 at 2013-11-10 20:58:45 +0800
Processing by ApiController#service as */*
Parameters: {"xml"=>{"ToUserName"=>"gh_db4ac511bbf0", "FromUserName"=>"oZmj5jjRYwr_OkYovPdvF4ZdWcUo", "CreateTime"=>"1384088325", "MsgType"=>"text", "Content"=>"附近酒店", "MsgId"=>"5944614090650424067"}, "id"=>"MTAwMDE=", "signature"=>"e9a66c8c14c88925e45dc2df11d066c34c415bd2", "timestamp"=>"1384088325", "nonce"=>"1383278484"}
WARNING: Can't verify CSRF token authenticity
Supplier Load (2.0ms) SELECT `suppliers`.* FROM `suppliers` WHERE `suppliers`.`id` IS NULL LIMIT 1
WxMpUser Load (1.9ms) SELECT `wx_mp_users`.* FROM `wx_mp_users` WHERE `wx_mp_users`.`id` = 10001 AND (wx_mp_users.status = 1) LIMIT 1
(0.1ms) BEGIN
SQL (0.7ms) INSERT INTO `wx_messages` (`create_time`, `created_at`, `metadata`, `msg_type`, `updated_at`, `wx_mp_user_uid`, `wx_user_uid`) VALUES ('2013-11-10 20:58:45', '2013-11-10 20:58:45', '---\n:msg_id: \'5944614090650424067\'\n:content: 附近酒店\n', 'text', '2013-11-10 20:58:45', 'gh_db4ac511bbf0', 'oZmj5jjRYwr_OkYovPdvF4ZdWcUo')
(2.1ms) COMMIT
WxUser Load (2.0ms) SELECT `wx_users`.* FROM `wx_users` WHERE `wx_users`.`uid` = 'oZmj5jjRYwr_OkYovPdvF4ZdWcUo' LIMIT 1
WxRelationship Load (1.8ms) SELECT `wx_relationships`.* FROM `wx_relationships` WHERE ((`wx_relationships`.`wx_mp_user_id` = 10001 AND `wx_relationships`.`wx_user_id` = 10575)) LIMIT 1
(0.1ms) BEGIN
(0.1ms) COMMIT
Activity Load (3.7ms) SELECT `activities`.* FROM `activities` WHERE `activities`.`wx_mp_user_id` = 10001 AND (activities.status = 1) AND (lower(activities.keyword) = '附近酒店' )
the text request activity is
Assistant Load (1.8ms) SELECT `assistants`.* FROM `assistants` WHERE (assistants.status = 1)
CACHE (0.0ms) SELECT `wx_users`.* FROM `wx_users` WHERE `wx_users`.`uid` = 'oZmj5jjRYwr_OkYovPdvF4ZdWcUo' LIMIT 1
(2.0ms) SELECT COUNT(*) FROM `assistants_suppliers` WHERE `assistants_suppliers`.`assistant_id` = 17 AND `assistants_suppliers`.`supplier_id` = 10001
CACHE (0.0ms) SELECT `wx_users`.* FROM `wx_users` WHERE `wx_users`.`uid` = 'oZmj5jjRYwr_OkYovPdvF4ZdWcUo' LIMIT 1
================================================================
<xml>
<ToUserName><![CDATA[oZmj5jjRYwr_OkYovPdvF4ZdWcUo]]></ToUserName>
<FromUserName><![CDATA[gh_db4ac511bbf0]]></FromUserName>
<CreateTime>1384088325</CreateTime>
<MsgType><![CDATA[news]]></MsgType>
<ArticleCount>10</ArticleCount>
<Articles>
<item>
<Title><![CDATA[附近酒店]]></Title>
<Description><![CDATA[一共找到10个结果]]></Description>
<PicUrl><![CDATA[<PicUrl><![CDATA[http://api.map.baidu.com/staticimage?center=31.195150,121.678223&width=300&height=200&zoom=11]]></PicUrl>]]></PicUrl>
</item>
<item>
<Title><![CDATA[维也纳酒店（上海迪士尼店）]]></Title>
<Description><![CDATA[维也纳酒店（上海迪士尼店）, 地址: 上海市浦东新区华夏东路1478号, 电话: (021)20258388]]></Description>
<PicUrl><![CDATA[http://api.map.baidu.com/staticimage?center=31.203634,121.685953&width=300&height=200&zoom=11]]></PicUrl>
<Url><![CDATA[http://api.map.baidu.com/place/detail?uid=8e13bfecd125106ccf06a466&output=html&source=placeapi_v2]]></Url>
</item>
<item>
<Title><![CDATA[金钟商务酒店]]></Title>
<Description><![CDATA[金钟商务酒店, 地址: 上海浦东新区川沙镇青厦路99号(青厦路与华夏一路交汇处), 电话: (021)68911989]]></Description>
<PicUrl><![CDATA[http://api.map.baidu.com/staticimage?center=31.20348,121.693209&width=300&height=200&zoom=11]]></PicUrl>
<Url><![CDATA[http://api.map.baidu.com/place/detail?uid=a3e8341c74cb878c4bfd3fe7&output=html&source=placeapi_v2]]></Url>
</item>
<item>
<Title><![CDATA[99旅馆（浦东国际机场一店）]]></Title>
<Description><![CDATA[99旅馆（浦东国际机场一店）, 地址: 上海市浦东新区川沙镇妙境路328号, 电话: (021)58376299]]></Description>
<PicUrl><![CDATA[http://api.map.baidu.com/staticimage?center=31.200808,121.696187&width=300&height=200&zoom=11]]></PicUrl>
<Url><![CDATA[http://api.map.baidu.com/place/detail?uid=4f9bb7ebcb34c3a37adbd2cb&output=html&source=placeapi_v2]]></Url>
</item>
<item>
<Title><![CDATA[鑫悦旅馆]]></Title>
<Description><![CDATA[鑫悦旅馆, 地址: 上海川沙城丰路609号（近华东路）, 电话: (021)58929986]]></Description>
<PicUrl><![CDATA[http://api.map.baidu.com/staticimage?center=31.193287,121.686134&width=300&height=200&zoom=11]]></PicUrl>
<Url><![CDATA[http://api.map.baidu.com/place/detail?uid=d146b38821682fc774026966&output=html&source=placeapi_v2]]></Url>
</item>
<item>
<Title><![CDATA[宁泰158宾馆（上海华夏二路店）]]></Title>
<Description><![CDATA[宁泰158宾馆（上海华夏二路店）, 地址: 上海上海市浦东新区 华夏二路576号, 电话: (021)58555881]]></Description>
<PicUrl><![CDATA[http://api.map.baidu.com/staticimage?center=31.193866,121.692008&width=300&height=200&zoom=11]]></PicUrl>
<Url><![CDATA[http://api.map.baidu.com/place/detail?uid=3d0b4fc9f3dc0930db131802&output=html&source=placeapi_v2]]></Url>
</item>
<item>
<Title><![CDATA[江城宾馆]]></Title>
<Description><![CDATA[江城宾馆, 地址: 浦东新区妙境路168号4楼（新德路口）, 电话: (021)58370628]]></Description>
<PicUrl><![CDATA[http://api.map.baidu.com/staticimage?center=31.202607,121.695693&width=300&height=200&zoom=11]]></PicUrl>
<Url><![CDATA[http://api.map.baidu.com/place/detail?uid=91c13f93309140e320f017b1&output=html&source=placeapi_v2]]></Url>
</item>
<item>
<Title><![CDATA[博亚宾馆]]></Title>
<Description><![CDATA[博亚宾馆, 地址: 上海市浦东新区川沙镇华夏二路437-439号, 电话: (021)50925598]]></Description>
<PicUrl><![CDATA[http://api.map.baidu.com/staticimage?center=31.197272,121.691717&width=300&height=200&zoom=11]]></PicUrl>
<Url><![CDATA[http://api.map.baidu.com/place/detail?uid=9ee392b8e277e658bbbd6316&output=html&source=placeapi_v2]]></Url>
</item>
<item>
<Title><![CDATA[星期八假日宾馆川沙店]]></Title>
<Description><![CDATA[星期八假日宾馆川沙店, 地址: 上海市浦东新区妙境路160号, 电话: (021)50925699]]></Description>
<PicUrl><![CDATA[http://api.map.baidu.com/staticimage?center=31.20297,121.695574&width=300&height=200&zoom=11]]></PicUrl>
<Url><![CDATA[http://api.map.baidu.com/place/detail?uid=75d0881a9e4e39543a04b113&output=html&source=placeapi_v2]]></Url>
</item>
<item>
<Title><![CDATA[妙金宾馆]]></Title>
<Description><![CDATA[妙金宾馆, 地址: 上海市浦东新区妙境路49号, 电话: (021)58981789]]></Description>
<PicUrl><![CDATA[http://api.map.baidu.com/staticimage?center=31.204963,121.695455&width=300&height=200&zoom=11]]></PicUrl>
<Url><![CDATA[http://api.map.baidu.com/place/detail?uid=f60a15edf3adbcedbb17e77d&output=html&source=placeapi_v2]]></Url>
</item>
<item>
<Title><![CDATA[上海阳光花苑公寓]]></Title>
<Description><![CDATA[上海阳光花苑公寓, 地址: 利川路501弄, 电话: 18019311312]]></Description>
<PicUrl><![CDATA[http://api.map.baidu.com/staticimage?center=31.20941,121.690725&width=300&height=200&zoom=11]]></PicUrl>
<Url><![CDATA[http://api.map.baidu.com/place/detail?uid=824f43e2aff79cce095cb366&output=html&source=placeapi_v2]]></Url>
</item>
</Articles>
</xml>
Rendered text template (0.0ms)
Completed 200 OK in 345ms (Views: 1.9ms | ActiveRecord: 18.3ms)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment