MySQL 慢日志中的Query_time包含查询线程处于send to client状态的时间么?

个人观点:个人认为Query_time不包含查询线程处于send to client状态的时间,但是慢日志的结果却让我认为Query_time是包含send to client状态的时间,好矛盾,好忧伤,现在把问题发到论坛里,请求各位大神帮忙解答一下。
 
  1. 问题:MySQL 慢日志中的Query_time包含查询线程处于send to client状态的时间么?
  2. 数据库版本:MySQL 5.7
  3. 操作系统版本:CentOS Linux release 7.2.1511 
  4. 服务器配置:24核,64G内存
  5. 业务场景:自己创建加密通道,使用MySQL5.7的多源复制方法,把深圳阿里云MySQL5.6所有实例数据同步到昆明电信机房MySQL5.7,一方面实现异地容灾,另外一方面做数据统计使用。
  6. 问题起因:2017年11月25日由于昆明电信机房受到DDos攻击,导致网络异常,并持续一周 (刚开始电信不承认,后面我们给出了很多网络异常的证据,才承认已经被攻击了1个周,并且还在被攻击中,新买防DDos攻击的设备还在路上),外加自建加密通道性能不行,最后导致数据统计非常缓慢,甚至异常。在电信没有承认被攻击期间,我们发现有很多慢日志,通过show processli查看相关查询一直处于send to client状态,通过explain分析SQL语句,都命中索引和主键;使用profile查看执行耗时时间,显示该SQL语句执行时间约为0.18s,但是慢日志里相关语句的Query_time时间为60多s。
  7. show processlist 结果(注:本图片中SQL线程是本人为了重现问题,并发了500个SQL语句使加密通道堵塞)
    send_to_client.jpg
  8. 线程956189 SQL
    select                                main.*,inv.hs_cate as inv_hs_cate,inv.sale_stat as inv_sale_stat,inv.rent_stat as inv_rent_stat,                                (case when ft.favorite_id is null then 1 else 2 end ) as hsCate,ft.favorite_id,                                item.item_id,item.item_code,item.item_cnt,item.item_brand,item.item_price,item.item_type,                                dept.dept_id,dept.dept_name,emp.emp_id,emp.emp_name,emp.mobile as emp_mobile,shop.shop_name hs_key_shop_name,                                emp2.emp_name as charge_second_emp_name,dept2.dept_name as charge_second_dept_name,emp2.mobile as charge_second_emp_mobile,                                emp3.emp_name as hs_key_owner_name,dept3.dept_name as hs_key_owner_dept_name,emp3.dept_id as hs_key_owner_dept_id,                                hs_key.emp_id as hs_key_owner_emp_id,hs_key.memo as hs_key_memo,hs_key.shop_id as hs_key_shop_id,                                hs_key.key_code as hs_key_code,1511872253 now_second,if(isnull(hq.hs_high_quality_id),0,1) as hs_high_quality,                                dic.can_be_traded, dic.trade_reason                                 from base.house_info as main                                 left join base.house_item as item on `main`.`house_id` = item.house_id and item.delete_flag = 0                                 left join base.employee as emp on `main`.`charge_emp_id` = emp.emp_id                                 left join base.employee as emp2 on `main`.`charge_second_emp_id` = emp2.emp_id                                 left join base.department  as dept on `dept`.`dept_id` = emp.dept_id                                 left join base.department  as dept2 on `main`.`charge_second_dept_id` = dept2.dept_id                                 left join base.hs_key as hs_key on `hs_key`.`house_id` = main.house_id and hs_key.key_status=1                                 left join base.shop as shop on hs_key.shop_id= shop.shop_id                                 left join base.employee as emp3 on `hs_key`.`emp_id` = emp3.emp_id                                 left join base.department  as dept3 on `dept3`.`dept_id` = emp3.dept_id                                 left join base.hs_inventory inv on(inv.hs_id = main.house_id )                                 left join hs_high_quality hq ON main.house_id = hq.hs_id  and hq.delete_flag = 0 and hq.hs_high_quality_status =1                                 left join base.house_dictionary dic on dic.dic_id = main.dic_id                                 LEFT JOIN base.favorite ft on(ft.favorite_object_id=main.house_id and ft.delete_flag=0 and ft.favorite_cate= 1 and ft.emp_id=16018)                                   where main.house_id in('90b949182a7a4b97bcb8fdb3c16ebe78','cca448800f8f40a1abe5ebad2904bf03','749b831fdf3013563f1bbbd88d8c6171','78142570a1ab444f8b162932e3b477e5','bd485ef832c444ccaaa529d4eece063b','4ef1df2257f049baa9da0bd0a5ee5ddc','fe49497c82e044b4a187072c53a8ec2c','88ab05177a8ceab6ea3fd746b416c64b','96c8e0b66fa8440a8fd33c95a2e03888','4032a3acfea9d568918e890a79573502','db23c21235ad4d4d9ee667bb456451a2','502ca4f5f898485d90b7a74adca8a431','6a105a529d0b4f39aec4fde4594016e3','eeeb9891e7e7400b83373b320d9c4a42','026ffd92f753497093f721212944e92b','e5074209cc49430aa82fb7c0500191f9','0aa015c46afa4427bbbf9fbc98d62764','31e23aaf72ed42e9a0a2d175e6031b89','bd9adb968bbd4df1927d3f217e03529b','1afd0871d4f14f9e8a08bb378eb6d6e7','a253c12871179d6bbb05d1690bc2742f','806c05839b5e4ffeb192593904e7b146','b66a05ff56cc4a53b081f3f76e6e39fc','c78e0715053d338114d49f4414f8efa5','f954fce5a474457dbf9e3772741f0f01','05617b1326d64d52abae4996bd6f0176','767d289b8f7544758db3a38fbd72196c','4eb879926043408393d05df2e7becee5','25c42c6cb9c0448f8629bdac7d46151d','44c4c0759c6d4373967beb2af88aecd0','2eaa5a5024cc49f98d61ab416327f005','afaa64a34e3f56a4a46364ebb8418c23','04a264a00db47ee771116b0fe0202d9c','90ac7b09a200499585f66f8942c1bb16','ef7175a134153846b0636fc7d3445657','3ae08d37b4f14f299ddc23f888aca5d3','bc3a414002b149b8951e65e8b8eb01cf','3e73b064ea3ff62e07c7b9250ed47f50','e03bc8dddcf2df4aa74ee68368f9f176','addaa36f269d47abbbb401da31a3cd92','987544bb0e0e51d1625f28252784dc93','c26f853b01054892b68fd7cdc54753a0','dc6739070b500901ba3679fbaf1f1ea8','a5421115adb14616990843b551cab312','0d22562ee93f4c918d3ddbd7713dfe0a','69ee25e3dd56404890830bf204ed25a2','6d2960aed3eb42bc93e2392cecfdcafb','0a4f8664ed6c4f31b69089d84595f9ad','94cb54fc82724b839fde039b81bcaf3d','ae6a605bd4876747505db799ce4a965b','68c0d07f3423801061b816875979014d','7a23d051fc68410fb4a75717032657e3','881fd6f78650b9565eb955c334cc0049','c59cb75b6ccb429cb81d478e3cba206b','23913bbecd8743d58e5eed0171821d87','d3a316c1adcc4070a88bfd4609e8b8a0','054c58d847f948bcae5b1cb825bc5f29','d4e7024008c04dd48299cd65754c1a9a','f90a44ad3e664c10aa97db0f02547f2a','20d17301db454680becc194199010d70','f91020f0006377f80402838488ce6506','f6006170dbf2440ebf9c7daed095ee6c','88be43abede14545a07617baba209a87','d752a8d3f6c84b0890a3a7c22cfc47b8','a460a9e053fd487d9e1365ecf1065358','456196a97e2246ea906f6d2544b06565','13cb6a5bb62b46f7adc83967c05cd8b5','92652eb683964397921db1d91cd81a9c','09ae4f3a878c032ea3a1579977603532','3799770eff8b4254b2b2592dcd240765','8ccffd5f05a5b0a78c76c3bfcd8a736a','13970327242fba9ac8dee672a18a5c14','bde6f2a912757136b8a07a709157fb5f','5f516b3a3119dedf6864dab2550be89d','c28569faa7b4c7eaf1935450568d7314','c2b9337d9d0b52827c81f253d9d55e18','bb769d819796a021a9827d681306e65e','bbe9c982f1bedc9dc09b15ce75833f8d','f6a3c1376e2281080bc81d92704a3004','227d991ff9b2ee617364e114c8949062','47c1e3eeebe971a919822e842c822634','e79492d976a04b6184098d02309a5cd8','75faf5700bb849929debb3ed99a99a85','5c83f77eca074010b11fa75b48de5fe6','39f5dac40950d16ab9c795d29d288dd1','48036feeee344a548c663b95a501a110','e90e0b0dbf8947169e5273ce7b8de58e','f77cd7444d34422e889c4fc64f26a559','44f2b937a8654962a9ad81f175dd817f','fe3455020344416b1654d4e0ecb5ef9f','03c13f81830b4363b3a7fbd20a3ea5eb','5908796f6d9a404587734db18214883e','108504f1d8a18c36342f5bc904eaddd2','f6e20c2215fb442386f00f5c58e2238e','a418398e75684d779e04b1c8b8a622ff','97dde387179e4ddc9a90cf4ad1d96676','0a9ddc4c210e11e79f0e047d7b9c183b','c609239dc53034c00de1e47ee880867d','e0e2bb6c072442d1a0a4d522b6917ccb','d1f24e58cec944bcab09cdaa929b5643','cbbb557f59914b6f9b5bb3e3669ba3d5','90d59eafce144d70ad8875638f532951','0b98edd8560842ec8f798d80daa81f17','08fcc308889b44168632e938727b6b67','884c9c94186a42b4944463bd97f05b01','239f89b828856013d452959d9e2f7e82','8f83dc3f717849b8b1ff8b0a5ab00152','f4e54eac36574b698772bb101f6ea397','db6f172c8dc6441c945129c482c48996','e43b0767003c4c4e99bfb9e6e380e8c9','42bee4d8052346e0b38c931081a441f4','4b49c06b82734b5a825ebb6454673d27','122bd1856f0b411188182ba316020314','f1cf18cc94585959aa981ce9a2ca43fc','f35f3cdf5963ab54fff8d765575ec28d','eaa1720207c646f0900b55186d438d34','8cf0d759b99849a88346dfdcbfa9a901','0a017812788748baa5d3115e508a28fc','6ce35b5fdead43faa5aa05dab9286189','b6824000acd14605b8eaedd856f6decf','2077ac965cb740e98a27759b6aab12b7','3b8ac2bf5c844568b01d297b4051bbe5','fd4999691086ee3637430099af37db95','bd048407ec174c5196398f693cd989b9','829a6780504b73803ec3bd4c24d4f973','100121e536e24c6c8075362c336e89e8','91cde42134cf807f50d9deb8ed97331c','35359cfd6eea4749afc001aa7db2b12c','74b0c4f680664d549ee8bd47b4e7f8e6','679a6674e1bf46e488addffd2ba542d4','ee0a1ce24e9c46969553bfb4081344a0','407545fd0f394c858964cd4b564f2e74','8bbd63887e7a4c97a23ab57e6c7167db','fb319ac91ff8409e8f1373688c472aa5','fea5cce6d5834fbba1b0419bcf104c88','f3152dfa751744debd07dd01fdffb0f5','cf947b0d1939479fbd49653b262474ae','eaa8cd90a0fa4bdca699255ee346ccec','f81a44ff2d4d4b1d8fc3e7afba08511f','62f3c1e76d3e1e0f88816136d340c1d0','5325b185b506430ba2f2db78fec24790','9c2bfb25e74545c0911fd7178dd3bf0a','09220797123dc878f47145999b9efc99','7c59bf93b777b9cd01cd2dc518caebcf','f181f21b64a94855ad3a01bb620ae3ec','db60b412999bf295e8e48875feed9160','766114ab97a55fd340417b6cefef6b8f','1dd733a0789ae12dbdc57068e6010e29','9f17d6a9e7fc5e33c931dfbc6f01a62a','4c99ad1850f6c86b164e6f6b9422382d','1e24cc39d12543979b1adf285347eaec','1fb28dc0ce2b3b21f19ba75b18c02fdf','dbe0420c3f374c1b8430cf95d908b89f','fef1f3f30cdfc6f29959f68c2e773b1b','e4ca3d0815084fae8bd45baedd3d8f10','2699cc2fd636497b8134631ac3eb0f98','6a21b7deb50248f581cfcd867a7f2c89','7e9baae5e1db9ee95c704ba44312cf6a','161f0b581c5b4852e70113f795b59457','213dc7fd30804e2c82245bd8a7e0d753','00ea4605bc894eee8fbfbbc89a84e112','d3f9b4389f03aca51f171ab6e30411ff','3ab9e7e9e3839aaa6b869148081f401e','4ffea25d89ad4d08aafa751756a68e76','38d25a0654f04749ac4cb1957994f54b','ce18daa8474f5ab8fddb4fe0faee7d20','c2ff77879667665c8c2b7d1b7e46797f','101088972e106fe9ad5b879761f599a7','bde1158f20dd4897a75e6f3616dc4b90','40daf5735b914317af3b0fe9d805f9a0','3dde9b66f66441d2b8bcbb82241b30a5','f7756cade4ec0671b711c58382fbcc8d','21e861f87c5e45f4b67cbd041713b71e','2db83f177cb4b39948319124d631424f','b62edc2472a24afa9e4c13b47ecb8d37','65ee0f648e7e69b606000020e541b2e1','2d09dae921284a2ca63ef901eed40c2b','82d6c8640a0b4884dec49193659281d0','dbbf24abd4ec406bb6e3df8a8a7380a8','d650c56cc31647ac0388cd7faca3be63','1eb7f6f22c4dd411f4c2139b86496409','cef3939141504383897937011458d7c5','72e3d8c15838461c8e17eb5474c09e21','fb2bc95c046a46448e75c5a3d76deb78','3a78eeaa03dd487788d56bd78695dd4e','be37b9e3dfdb3f126eed495baaff0e1b','da6e23f6fb772326dfc6404a710cb361','5a336a279f3c461f8beb958e05290997','7ec438fa65d5435e9b03df15c545e646','eaf7127c7bf145118eac71ed309492a4','ea08cc1a4af64c55a3f8990b2d0e8508','c71efa125e6c40ce9d917b301a0c0f13','aca4fb882e314d4587edbd5e93e8bcce','5965780f2e9b4e6a97fc6502158aada7','91cc9128804d4ed1a6d82507fdaa30a6','02fec6cabe684d3a8190056bb4cc1055','e671f259cef3a507a21fcb1465bb094d','d2d74743c19a440cbe593318aa18bb54','67fc4b1ac781b5466884cbca43792a91','84b0ae2f281345b9ac684b2de5897ece','56076b477c574397bca18fdf5a7d309e','0d195b0d1d245755ce7efa2fd476f5b4','af921a05e8b8128a82c482974681407a','37ad509556744c10b37cb3e92f274e5d','9b3d180c728ae1961e298ae5e124a609','16d2171a5e4301247e634a07c8dd91a6','79879f66e1134b28931cdd30ed750d4e','044925e7a270209e7870a7d33a8e99aa','e0025b448eee4b7493b85ff75a2fd2a1','bcec0dc0dbeb23393a8483af992245e9','6c3f10905f5c4ed4af851f5ddb4d8b9a','5275033cc43a4be59b68390c66bca046','714d1b7cff3b43cead46070dd399b510','c7df822fd92d4fc1aa10e9247e13bbeb','6bc9b568d6c04431bc62a36e21c1dd64','a3c3318e54ae494c9ffc93fa5276c3f9','e65113aa15d840a88b3631603580dda8','7e18e89941844d22abd03bc527cdf059','714ab85c45e74bc3bb2131323438276f','271e642fba2748a7a7ff57e174fa136a','66b3190a83dd1ecdbc90fa2983c49075','2dd139662de648469e1fff1b00c4258b','7ad2e8e21cf2b3f6dd4fa9e235005e37','a8135af9c3b54381af1a5d5d76fd0cf3','025e796b63fa47d1842541b927e48e2e','505d2980c08631086744c8617a3fb43e','b60ada1d1525c118d2cdb3c1cd39d614','b354baf750c0d44a0410561caf71f34a','132e7bfbffdf49d38e2807e791b43563','df50534980ab4e6e92cb9fcc4150eab3','56b566e71b28420889ca8d1418179276','e3cfdbf7c836481291d1116ef8cb8836','c9ed958835aac308c3294b6c37e9ca58','b7b869659db24ab113aded8b43dd11fb','060d7683e8c48395bc14f3eadf1177af','e4bad6bc0ede4c38a0bd953f6aa51b92','8c52a86d8c59741bcd7463de3f3e9680','641d30e2674bb4291bd820011ce584de','43e174f26e1818e64fba8548cb652ba7','21faab5ec8154fb886edcd74b0410f2f','cb300d85007d409fa3fdcb95b434da6e','86d6636343e3875e0bab2e632f274b03','8eefc84fbefe43b799af254c4f2ebd4a','5072f140aa6f4bbd9870c983953e9482','6cd5b343394c1c84bd7e86f018c7285f','a3f40afe0f2346db9bc7eb30fa56bcca','5770fb35d8bd48af945fcbd401b8c0a4','d6a508021c2a129161b5fd0a61c3e44e','c521c482e6704e339ffcfd10428f81ea','edc3381eaf8141fc999a27d21d8db1a4','19a10ffcbf2343ed8b03e9ecc3911b02','73c9ee1fd32d418ea218b98ac920ceb4','bf13a02107ce4e8382d257c3f7747346','2e7563d977e7410e98eeebae1ab18c78','8503be3ea67d4264aa971f11b4ee2504','630e52020831422ea73d55b05125e6eb','14d25f48da808f6f1f3a7623257fd539','025bf73c6e7f95b8d0a64bbc22d4eb31','6be2da0bd8d7762038646fb8b48a5383','4dfa167e3ec34451905627f10561f155','2bd87fc8201c4a258354a39a6a074802','2637f443e3644f2cacf7e75e4e678fb6','ef1e6c407bc445c3bf58e1223ac614f6','9bca852f1b064fbdb72df5af238af284','7aaafbdabf764cbda09e05efdb57ccca','87bef029d7904886b14c3006942c9656','aaf4e59fd64a1eccd4f2f669356bccaa','e025c43f44454f8b9ab9ef3a3ded1323','193d18a38b4f4289b32d7f89194fc9b1','23bd27ebfedc7a5405b994ab2299b688','dc74edcb13414792ac80efc870190554','eb1f34e0acb54aa9a65c0789816e65ae','0bc9c808d8224bc3995e29dba102541d','80d4df9902ca4b8f91d00b38a0b6dd02','9db337bca7934456be28cf3c8bfca147','c8dbd10223514c13ae3541eec1013f41','ab39e6198fddbf966a62594671eacf62','c232aa430a8e4c27b56d8d7a4d3f4306','b2188cc21b0b4cecbcb203368b87b295','35036f2fd3b24fbabe44393e37f40c9b','f7b947220450475f9ecb9511ec51ac38','114ae4dc1a6449d99c9ae37c46025b04','59e211115d72462ca5cbef8f6d52fc78','3f37c45f10821c1943f29a3697e2b55f','731daa66608231751cf307c4a0723a7f','a2834abf257e4575a508c5be01dfd023','df0d315786cc4758992fedcbc58ad779','d3d475ff6b6fdea182553ccfb3105a61','268dcf4fd13448a69c3a791161052302','8cab5b4c715b4f268bfeaf8af4360b29','77e012686a294f22b6d015bedba46993','dfc4a58d2e2746dfadab819417e0a16c','169149f3a9f04aeba37d1fbddc144e13','898a2e8ea3824e8380d4e9ddb83f0240','963446e38ab24a2eb233a50f6f32e896','ce306f731b8647929a07836bfe8a57e4','5103f8cb43f843018f27edf45ffa0dfd','f9055eb1cd4049f0bdf947edeaad4ceb','0ea496aa208228e67d6ddea14505705f','2fb2b45357ab432fa256170c62832e81','33f6331866da1909d090a063234a1089','321cbef0771147d2962791131971402c','558f09f46fec46e3b7a03140fc95e3bf','bdbf890330ac4e96a6b26938ca4afae2','54c4c32c73d04b9abe4bd7263578e396','2333fede335d42f2b230b9dcdb61d238','222c8e5ddfb8438e95a0bf29bc90b2e0','ff6dc9ddb87540c89c2323cf82cda8c5','2d07b96b453e9f7d2bc28a1dfbaa3081','d336cb50afd54781b001d1f21e66205a','6d7de797f4b14520a39a6992c374d80f','6abbd76dd41b33e3f33a6ae75a67ec09','9193f86bbaf344de96dbcd0b71c4879c','4ac0743deb3242eb891183e817f6eb61','4431ece7731d4927baa4bf2c8fe15822','f46420c133514147a776774841cfa2a9','0ac16940120f45c3acb1d36a19c129ea','6565ac0fbbd148b9aa79e3a91d908373','8f0162e8c6abcbb3ec7e1c10cabeacc4','44f17f77742b46f5aeff6f6a44dc3ff8','7903275e4acb4d3faf1b251035b885d1','d9e2a9e8c5954bb08efe473bac208d98','444e7122ac4c644799110cec9db09830','966b1efd1b244f86aa4cfd4529f120fc','b4b335d87d9e4905a5f935a0d855e594','c8ce8935e283d643d1e8a0d622923492','b838f2533433458f83b363aa05fe5808','d3a11345bb89478bb09adf0fa49c288b','99f816cb8ead46fcbd154bb35c5050d3','2f0c003c78ec4c6bb56da7b8d2e5f407','d34505a8548746b7a9c24b5aea83156f','7739490c18414ea7ae81b9204a15a7f5','cd04d8abc9cf4284b41d8d83f44c6b12','238a517c0748466e8d8a81c8907cac83','6617086a024921bba11c29e4a62ab538','ae3db5cf61b0c3275d25cc3a5e326598','46c5e62e654144e282f2b90e6dcba554','1e9629c51d594c92ba47cf42c2b643df','78a4da2e931f90b9be85bc9901bde5aa','77491cd08ee0aa950524b0a8fa606dbb','bba9fc27b1934179937f8f0012125268','17ff34228855959e48379893609461ce','44b918d685d17f2584004b580bf02316','cc41d9f7979c459e82ae2be0064411c4','b3a5c8a97641fdd726d3b5868dcbc576','cd4ab2df19b34ccda3904d0ce2daf840','ac97486e53f94efb9e698f987f00225f','6d2620bb7c8942c4ab9c7fee01fad8cc','219ecb0a0a0945d8ba6b2d232421cc5f','d3b51f67c20846cd94d45558ab8f3485','0eadeb0ad7574f90a8bf61badd3aef45','f60c4b669335459f8e4ba5f6a45df6ef','46bebf6a1330448fb3a947215dbc26f5','bf090d9044df44ad9aef6d307fb620bc','c12af1d78e2c481d9ca73dcbd3891fd7','30a80e4a796358d47950b18f4199ad43','3189f0789e894f37ad5c67837a0f6898','2b2e985d710845318db4f9d0d0b1a789','bf86b36b43060043bfa77d59ed6c20f4','5281e9bfd9c82f7195f1b6dff04dfbb2','f5455bb9ecee4b5da98f37623262ae69','29afbb849ff8389ac6da077925c2cc23','5a831c4f808546719eaee384f0ac860c','c08f76382f4d4689b5bd471213571e4c','2c6f62810ab448b08f2af75a07d1f997','6cad62bc55564d8589fe119ac2b91d96','395af4da430b484b803b11741031a56f','ac62bd01e02f480c8756635cec71895b','d052bc3178524ffe93621545a694d566','b9363b3137ea4a72937a01cfa18f8eb7','3ff85a8aee8085cb7b2ebe889cf58762','05a0d6fa5dfc4f40b845fbef046d51c3','2ca3c760f8044e93a6a32539e1d27b22','4ae57b96fdda4d5aa0da45d9f1e4800c','7e59bb49c07b41f188bce5e4c5ec5e72','7dce803db35c46bda7bdf10a8b5f83d5','b1668274b6024d5385fa0121331847ad','5c769969cbbe4726838ea13a3b2bdfae','75446c8fe9b14547a48e29a416bc4d1d','61874e7082e94113bf884d9e10be7eb2','6b06e125d4474bb489464b2bf465105b','070a0d85ebc246e5841b21e540016938','7579b0b626cb44de96dbb770e73d1ed5','91b0056d2a584c309a4939278cf579bc','844d4a5bec4bb23ac49b7953301e4a86','eb6a7a9b37914befb7e73b09d07b6381','cc1e22be8a9f4f88b3ee237e2a674606','59a9767faafa42b8a80dcf856c6a1e28','efe9235867dc4d84a4b20bf5c21382ef','cbaea8ae36b34508935f3d1c8334f424','d9390224821b425794f47d1cf6b1c685','694c37dc813946518bf43d3f8ba53aa0','ec0f1cb37d894a8d9bbaa368e26cdeb3','29a8fa1084c14b6388a6a75944a2c870','a0efd707ff18499aafa5a15e837318f4','450e586551e54236af20ab9d68d3add9','98ffcd806a664ee389d2638f49571a0b','52ec6bb5dcd94301a396e1ce8ec7a8d6','1f058d46afb34b40ac4d4da4c2640ba2','ac440b545ffa426aac166797effe694e','13b1cf27701140d6aa8e6d79bb2d54f2','1053cbf9270746b0b4f859d6cccfdcd9','05238e6294eb4cab9d1a2d676af22291','18fcbe1206d14886ac725f47e0358792','bea18c79d80f44afab5a45adc2ca2162','7fb3e1775b48c8bf2959d84cdb133457','8fc5ba43026cba5d395cfd94db96b617','db9d994b81b74d4dae83574e6523f6d0','0b2b694addec445c981deb9281db52e3','4787faf19c974997ad6ea13e01d154c3','a8d0c96642f845428b6489aaa334c49f','a4fe212ff90846fc99fc9108e2b4fb32','786e5e2e72364fe2aea65d14f673ed4a','ae008a3782c04ff1a2237b5772d9de21','e6c396345c974b3d878ecbba4de62a7e','3c2b43024e39457790ae1ff101e81538','23d8b9a0fb2c378f21cf7e7a3cb74236','6c0af923b9394d8bb1b6779ec516b5ea','f6fb1fee15e76a8c693ebf6da660a80e','1a9dbb197b064f479556413a9e731e2b','155342167eb740909b7a7796f390f6b3','1792a8a32cf44f94a5c0033c65c0c55b','df3442b611c146fcafab2f97b45b83c8','97113561faff4d3899755f745adb5649','d968c9e36176cbd61bb515fd9eb2df74','31380da0a600415a946927ebe1b94af8','bdd715c09950472baee9196700900445','997c13ed40b94836b2fce3e959d94488','639f24fdfd3c47c3b025c5dce96c7f5f','e4e3f503dda04451bf1d8f2d483b147f','5e82288247394c3dba692589844b0ec8','2092f0ca4aa742eeb836cffd82dee536','4e9441da16854b72b510272cddc9588a','96611fa856604e5f82715fd7a4dd99e0','0852529c636446688edf1f308caa3453','d3954c9642624b39a0bebffaa9094574','263d359eeaf64ead9d7f2f73dc8bb9ac','b68c7a17b54825b8325ab00048be9d21','8128748e3ee6467387bd9d619dac2757','c37b0c98f6c64acbacf001d68bb919f4','af9bca7a99eb44469918976031838ff8','9ee34c0ea8ee4c1eb5465996655a5b41','2371dd2e73401a93f47910c7671f9653','bf5ec36040d540b18cd977bd75b5a97e','978580ede3c94d4994d4430d7188090b','14ea80dfedbeed176a7ca372985f611f','b95e77b35b484dc0bc08634dc3b78c97','5e755b45e6434418992741214810acc6','80ea7d218e8647a7b08897bb949022ec','25929bd67e7f426bb717df2908b459f4','9ca66980a61c46e590d907b80a0a07e8','2c6de27b74cd4954aa636ddf6f3de68b','58fb4b6184e74824a36aed467e0ba3d1','c0c4c1830e474f2195628d039964b758','52b481173d794535a0552fca7c57ec42','85b57a88c8667b9a35a9529c5eaffead','5e8aef3b5895450c8dbe6b2c4bfea080','1ee4301d303048bd878087ce43c3c140','de963b63cfbfc5ed471eb23a4f7824e6','d6116f5ef35cd0d222fad81c088e953d','039e21420b174d0ead9945d50e5cea5b','3e0f2594d03148c7a3ac410a7dc59b78','e926cab4ded94255b979ff26f5078338','0fc49e4bf0004680b1bce37958547cc3','d4ddbf5a4ef34402a9714bdd25aaafb8','eb6ea217c1d548da8211d1f4e3230f50','30396624eef44303adf9df9a593025b5','3f19a70b4da602ac6394be1151f6d1ef','07b88f699720d67067c2c46ab7b3fd5d','73879835348e5eff29bf26018249fc8b','89cf045520704c53b1cdc9ffe5b9e6d7','dc563d463050409c4584879b163664d0','9b8203ba213242eaa62e89750917668b','fff89db44a3240af8386e9a267ba8582','770ff9a9951f4e059e561d4c3e03f0ba','2a9adeda67f8c70bd48567a99dc4495d','47f9327cbd2d4f5385bbd3b81ff4bf9c','fa6fcf8b86aa4d26bcf175d6d864ce58','8f503347b74247499664d3357c4b7e50','f1221d753c3cd9c86132c47a8b9c901b','baf5d46d556b080b06b4933d8857a27a','dc92c3b4771bc6359285ec434eff670e','991df53e981a427d853125f935519bef','198fc066d98044c6bdb67bc9551d5651','e6aa1dca478d55c6bebfcbada7cbf6da','14539df0a4a943d594142da12d6f49b9','dca3f460cf0c46a4ac9e93861c0a0ff2','cfaf3ec856344d16aaf53bfe95cca3ad','0aeaa155d83b49baa1f8d5161a8f0dfe','c937de53cc4a3a3831a8f4a7677d3341','85087fd06dc40f4c2d859302c1aeb28b','84fb4707b9810c0f73d9310cf70f92d3','60d008c4464a490db23da568e0534cb7','24b73e91affc4fe49f9dc9ab2c593edd','1c98e32302f547b28207bd8fbe20710a','0d2b13539f7942a49f37c13cf1ade2de','04233ffec1da44e18ac57d031d30e7e6','2bc420c09059201c3fd6e25e1a52f4be','57f3fa99b8224ed88ffc9b3a24860b3c','04a8255f04ca542f73c241c74c2a73be','998a2cbbd22c4980a10225aaade92a0c','608e9c92c5264d3aa5cf1948ac817952','7eefa8906ec4431b85878f565fc22511','a16f53bd385244b3b20a9d23da216aed','dd715556444e01496565faa8d2e265b4','7c82999452fd4c2991d8af25c014c9d2','40a46cb012424400228ad1ebfb6c22d9','f756920368fc4316bf24b1cde50becb3','01bd80f3c79c4eb98a0c31fc435be798','6dff393bb787f97ac3ae73f0d0e31244','b046b1d473884a59924f9751b968cf82','a20109f208b347d7b2257f7a738322fe','96e4aeb011364a349fd3a9acc8392f93','1760c500947a4ff980fbe365ff184f75','6ce98b2d95774c7fac3dcf9f20de4428','74886ecdb95c5bdfe2a8b90892aec373','59f0e6d3a00c4638ba1adfbd14a9c41c','b236024442e640a992976784c74ab711','565139cfa8b04cdfaf166dba247c910a','ac0132e419e03e33ee3ab88a90eb8df0','14117e81235e414daab1d9170ed5ee42','dd9334ae0b01482b933d0dac6d89e1ef','8c77c401885d4877a75c595809ac4739','dabc80a9e3014029b7254b89dbf6133f','28d5cf89396646e3eb339140021ca96c','7d6e16eb849db3e47358620938f318b8','4c3a0db54549cf3311983af43e777e4c','2337212932de438a9a1f899064e24201','ff4a725e004228ab272679539f66f301','9f1e4d2762d541af963263bfcd44cd61','22866a36f37e43979f0a1d7ce930d2c0','3df5c7051c454bad8782b3242696e80a','fa1927c6ad574b778bbaf55f16f396bd','b17dbafcd39a6728a57cec39e2fa2aed','86bf21046e2fd2e51a2be9c0cf681269','e462329e0bf6808867da466d8fa4b3fe','cb706f46815a310814c15b4368443cd0','83c0a339088808985e96e9ef58df6984','5a8904b9372149c9884307b3658052f3','0f4bb3987cb842fba64dc1fb4de58e35','d050ef3894bb47ee895cfb8fbdf3ac7f','1eb515cd2b68436c937d3d91dba4df09','07781824606249d9b1ea5f0a134951f6','076dd0bf4e894f618e8e8dfc38d238b3','4e98ccdccc9f44368397f36f86c584ed','b1e097b857704e4c8841590ec40b848d','d9eb967fba09b27971970dfea6b8ff32','b461bd5512654bfb9d1409affdba3e94','61e62db5d8f0a2409164a060baf33b48','c3c33f00586a4cc68bde1921e1d07d9d','92f9829772bb42bd97b6ab072919d568','34c21175dcb842f295280d994c01ecf3','7de173b195e849b490e5152d42aa8124','c32162ae223a4e4f9ccd09fcdaaaa234','3afb505d18a0c16eaab2834e09872f2e','3f303b99e5f64ecb95cb5f6b19ee9dd2','237e892e972540db81d8f7670e6a7a84','d7d2ca95e9a022d8f1afa7758f063cd7','9b36abaa9b754a79bc4cc71db3df8950','835159d3897d42088b3b474e18fbcf26','5d2d89903bb444f4aa526fd9d9a6a121','c461a0beed494aab9731c33d2d8ff47f','a1a39cb2a5244057ac17e7a7bede3773','206787815c6a4d76aad9c5299691c707','c801d6492d40281eedc86b491c6ba57c','0e750ad800ec44d895967d92d8db0238','83b9919bc661492a8064c1ca733339a8','546abc3cf5ab4f270e0c0bab51954a91','89388ead79eb449db54f6f99aa1f5aad','16748da87be54533986b673b75ec2c65','966fe7927e9041a49fb8a976d057c51e','fbc651a8f99b4846a728fd08aa898210','c2415201b1b2442799b1dfb28d4a2bb7','f7b67698b0174dd081b3f559e056cdd6','86bda0c8472f42509856d12f4267fb0d','b8a165e1330f4fb78cd375712b6b7eae','ff61097efc7f4ee494c4d927e222edfa','da57bdc8f79d40129b7ba1f1cd658bf5','00b494a2c01e2b741a2fa89ed1f5166a','619f9ab273ff4527b0d377bc5095d2fa','86d0fe4dfc9c4a22bf451fbf976681f8','347496e10a60bbf2e1b02f3c167c1985','e1319d62d6014d288ade0b1b273fffb6','565c7319aa9d44b8a13ff94cdd28635e','d15ff63c4ba54a43b3ecb1feb0833292','d4bc4cfe6fb4470396be5fd889af2645','30c2d0cb38c4f555e717f762c7a27e6d','30790af29052be46f68fe4007d3bb182','7fe99d442c067e6cd205c98efc490b0d','6ef59e08652842eb837b8fed50cd06df','78f1efc5076c329d4081d0a42e5bb560','3677aaf675c99d2afbb417fc59021c33','717ccd3a063644f348deb761a50e7e34','905c1868b362c08411b0de280887254b','d9b132b9fc2e41228cafa1e98b6c6b69','11af511a00827d440abb0bfed1612df3','d5554f979f7090e3fc9fabcda94c1f99','22b8d1bd12ac8fcd6fe493dc6b04ea7c','118f4c0134e5badf51f284e021a38138','21bcf5ec0ce14d7893f72583e118a298','768c60da7fbdfe82a77fe3c77262054f','4eb719eaf32f4174818c8f689d02250a','3add89b1da8147f9b573c324f5e247f0','453bf7fbec3346ad8cf555dc912f8822','f1b56c29b1d24537905b33934e9a4f3c','97a5081536ed29b8b1e733d0415d6282','8fc3dc0eb6614c609194c7f2e1ff0d91','6e663ee7bdb54775951ad9ad87ff4dc0','c022cdf5201d33e2bd1235b6e009e7bc','c01468ee4ab1e2c664c6010f7acb119a','be3f22bfaf692c7500e7629ccbb399e6','8c41a89568904915a8c4658e22350e62','0c082592196a4581beb355b803463b2e','db46c120fdcd4efa82dfdb45103a0a63','52912c1d1a9ac81c27b2316ce0992a1d','b374624fe59846f7aedfa1b7b40675e9','f6f13917fbc644568433b9255f3aa100','70ba72c3a1c24de680092bfadba329fb','7dfa132d963b4045840a7f403d128214','209be7ed849b4e6599dc9308770191c6','31ccfea603a34a4b991eb1dc16d555ee','40cf08f37bc745678bbc7124c2a9228b','c7190314231340aa9363df3f92e2684c','05fd0089198348e6867c0d76b3532917','8ff0d80650584093bfae53d0306cac9b','f3f252df86de4c47ba96d167676a8ea8','679ca81709d1497f91235bd33cb5a24e','8afff67e69f340c0a2aac72acd5aadf9','03b3e6a69a224e9fae013bd33e613468','1da634b3103741eebd495fe413467773','85c40a0443604cf3a5afabb683774adf','6831d25fce20419aacddd1484ff83d1e','9ff3caa80211403cbc6d853fea70f235','bd54e32c05574d35841f7fef1ed3c817','4114a37fb73747708fd037d49ad3534a','6fcd2da690db438d8524a30d3c6381e7','4e8efb55882287e46fd4bbc3368fe8c9','de51ab5a2e994483ba11fddc3dda4112','c4e8894997cf4b929637471495510d74','2289891512794fc680a11d535f1045ac','8ba4c73c83884923810793bbeb4ffafc','39f820d4617844c39b0dbb98b7c1f21e','20da55359cf845b897acab9461d7761d','04625a9086e0458aa304f11135575644','854117a3c8cf4dc19681972edbcc7cb1','80ce3b05ec754c6db6deeb279bd1d123','5b233f0f6f9b84aef380cc94eec79a8f','91d9002fe172fc3c06fb006f45762f1a','7812ef245bb445a2ad5109846a9face9','32720e60ad53484086066f58a3a44307','f6ac7bdce402c0f5fb935f22328ee889','2198dd95ec8e414ea0dce39f75c588ce','6c172e6c775a4887be9e7b51c7db7cd0','bc36317f8ade4a3a97623b0e6e0affdd','73c4a92fdfd9438299b269978909b632','86b511671a7d41d5ab152b87e8944b8e','c50230db212940db87270747a1c53c63','063f25b48e997b8e4476d460a0f99732','7e54cfe3d24542c48cd16b8a99d77365','551506b290d745938716f3fd1af45f77','ec6e20d7258847fd912c23a3291e563d','48cb2d8893051a40e09d962f4606eadb','64e76aa7f6b14f393d060f12c69654a3','243d6398d672f98488daf08cfeddab61','1595f8549903421ea3e8ff428e4478ec','9cf5ef7e181e48e3a354d70c69f31a2d','d603cda039b7475490b1d140ac262f45','7bac312f64054974bdf24b3e3ef81224','04ffc9d320464a38b085af371e2644ad','6d67ba6f8a654ce397d40be6ba8d4a80','efb49b2740f44a2f850ca95d8fdbf858','a15cb36fa5cd4e4fb3fffbac0d5d2b0e','644a12f9639c409688835580fe78998a','eda4255cd284452880fd2dc00f065674','2faadc328d64431284f1d935b00c4e35','0f3ae45b68134e47b51829772b213d96','9aed92cc350d489da2aaddc3112f7225','ab607d89045a47e98dac9fe1a820f684','0e8a495f229d4f1b9d2f89744e612253','e222efee520644029f8d2dc4c1cadcb7','f3d4010dc2e342a3957f29ed07756530','dace04897c464c888e3e39a16f5302ea','08cf9f0144de4771b87ae382bf8cfd99','2083f87bbda64e5e963841498206dfd5','710aa33beee84a8db61adfabc6f2256c','51acb486310345e59c036fc8003f53dc','bd0309cb4d2c42e7b2b18d622cbb20b5','241933a6ef134684b640c32cf0fa74b8','d691593500374bf28adf7968fa161327','46b7fcb4c0684322b33ae19f9abb952d','8afea63df3814dbc8507410f0b06498b','b80e65bb1fe64a1791ee2537eabe005c','cdeb9307eddf417eb0c7d5ab3b09a8ce','7ab5f130d54e49a4bce27320d1ec3f30','92a66a878ecf4b3ab60def97410dc99e','6be01c60b6a14b22ad24694606717920','55414b76a71b4da29c68d1945f4f5920','8d88e29d17084bcbadf7ef75e55fe63c','fa5c827ae0ae4292a66cbdc80c3c564a','a7b3af91c9d74a8fa5435f03b3ffa0f9','b37890f33c154b4998523f0c352d5bc7','38f5ec661adb4f2d966f5bca6def95db','2b3e1634349c4d15af755d4d4e72f49d','28402397b47645e19173c9c5865ee58a','b52a68cbd26d466d8df4a9aa04cadcd3','c88035d09b19476c87ff935f20963ebe','2dbbb468b88c45bd89fabbbd9228147d','e9df65173b524f9eb93409a41dd92c92','5edaa203e30a470a96c29795ea225050','74641bc9ce0f4afd896423496398dfe7','dd49369137434761a418e9e63fb17031','7f85eb2ad4fd41c4b45f4d8e6fa3ce5b','3702fd998d6847038c30993eb79cfb2e','90fe34390c1e712571c334e265129d00','60210a1a52da48d7bcaf7365c60238df','6f0f0adbf6b091dba3ed3738c69156d5','18aba0ef2fed4147b89f25be3b7d9542','6e88740029b649f587b56518907a7c0a','0b760c06c16c45bf9c26cf7c356f5aa7','0e6aa2ed9cae4dd48ad9eb34ba3dfaf6','e1ff3c0b16434e0aab2831092739a142','4fc41d87457a4c1c937f65cf771bf579','6a9a8414d9fd4b999830a3f4ab2c90ea','fbb5f3433a534092a6cd71ec31b32509','ec3815bee342532f1ef0e18853925efd','fcf9b82b06214fc78e5aa9cc0064bbbe','630b097ea7284e5f9f83755a05de70c9','c6286a84ab9d47ffb33c512af6ddc3ef','b4f6af8d94ae481152b9704c860bd78e','3b9166ed477d421ab8b6ff80b2f12345','f2dfcdc38a764e9299f5131a7058e1a3','ed4ef9369f5141b38caf094bbff2dbca','4ef28dae990ef7bffc9c6003de7c7b89','1f5dd0104bfe4a5b8c400de9c9e6021d','9ac8e759511045c8b6497b0653388cc4','ed9ab44c4bcbf2af11958a6d0bb8f4e5','66d0187bc84d4775951c4f28957151bd','73b28301de0b489989dea999e6ddbeb9','b4840e522a9d48c7a34777f3ba0bd876','0ca7c8b223c74ea999d0b19112822d9c','a4028780eecd4cac91e75d8ddb8d1023','f3f71a50a551418c9590bfb958eee71b','861df6f0318a404c97b3df86954867b7','fbb12e50160044fab9d21d4a29ca7b45','d80fc072859649e6908055113484249a','b70ddc822c4042c7a8d961bbc3facf69','bb8b9a1bbbddb9ea60ef7e8f5d6987f5','517a4261bf8eba00262d3dbba22458ca','7c65d56f135a42ebb07c4374e30bbfe7','3038174ac30f4a4db2cd4798d2c9f941','ca4647543c72409ebeec431cfd87ef92','6a07ab9c1bed4a0db3110789394ad157','acd46709184d417fb9a32509c1f5fc43','30faa616f4e01a205b5ba32422a737aa','950fdc0d68a1401693fb6b6d4db3a9a8','8ee9558b31bf43e89aa969f523941807','ee0861e84296408883858f70fe716aaa','69bbccb0332948eab06721a365f436fa','1820a4d6543c35ab2ff8bce7a962ef88','4f9d72d40ff140ca86a5698c6a91390f','b31ede7032af4ab1814b7fd80f987433','932d50806f374aa7849817fd5737fecc','41443b456ab84f7e961eed8bf902f09e','73b1f774e7ef4419b2ba19ac17c82995','553ae7c1d3524a35a9eb6315a84564f9','47f60fc716b54c408976e7bdc82dff17','a527fc92944c47b985111b3b1595f652','f3848105e78848f281676161ab16e96e','af0ff81b6cd74708a5ab8bc3ebfe0b40','8ed5f1c2e13c120ccbb34d1b2efa06d1','6b66bbbd713745f7b006bbb3c10e77b4','69727744e131488e86e50d0e8db3c38b','69c83594bbfe46c39021a12e63bde36f','83d2e1e20b0e4181bd832336ba2be3b7','95369564bd124782a381bf261472a35b','2c77ec1790fb46ccb7333de07ef09e4a','6f1ba22c88b749a3b5960b13489cb93a','987a6b1ded544d4aae4765364cb6dc75','59475de5310c4726833c57506c694140','331ebf9dce42495c8cba398a66ac1172','4ec6c4aefef95841932bf38292968ed7','90cfbc4b57d71d9b2fff7b81710ea1dd','1abed1e31e5b47f9848ddf0635932cff','4d6c17e72e964f209d93e977efd5b352','7ecf4b10497243a68ca48d00d3ee90a2','90d5fbfb794f4fd2a388559349fc1df2','06c377e382fe4a2fb85adba800a76c24','cc5040ecc2d146de8d8b496577790945','6596432553da49b3800669750346b874','9acd2b3048134abdb2518d2d10574871','5c1b825d242947129d6d39af07a24d1c','6914a683a41a440cafe4377ef6c15ea6','2c8ad41aef814158ad44b502788d0a33','b208913c2ee24d2fb1c9f16f3b6b3e2a','7cf9a47758e34266965b539fdd71758a','8544d2aa2f1c4d338f37454be183e149','024dd8a5f90043c7931fcb1b79bea9fb','f477f1bd31e2a6af4f3fa1c5c220ba1e','31015bf19a194378bd30c52ef2f9d8eb','059603ef72c04cfeb7ea974ba4ad8914','33185fb8a1cd4a6fab531bc3390b9f5d','73abb3f66d1542c0b982f5874c7c6467','fcd9387ac08e487eb1ebd3623e3b741a','80106695bdb840d180b897d1b1682180','a4a660d35536999a3a8dfe6205dfc49a','c2b7867eb00d44f4afcbf5b9dab3c0a1','e522b161ae29f60546f972d66998482e','9daa8fa89afc44f485bb67eec6fc17a0','3e9f4c0cb18e45cab7f0c523caa24024','BJ_MASTER_HOUSE-0000000000052942','309f884ced7842c08d98cd85f88ce6dd','f977abf96f7bc97be3baa1d6a161cd4f','b4cc5fe77b1d47ce96a7a38c20fec6a5','e9596a8822df92bed682f90045ac901c','68f9896f8cb74658a4ada7ffaa724a24','bdc124dd3aae4ff29b0697783c3131de','dcb080790c98427aa72273395e3ee2fc','fdc147425c4b4208ad4ed163cdc2901d','1c82920a30bf4765bb170391bd64cbb1','9b0418259d1a4942a43acbae6f16d4c9','33455d188dfe477f9bdcaff0e7c85f30','09229c3ed5b17d01c02a2bd5151eede8','03a1a82e164d426499386103b6097c23','f52d91137c124dd2bc0de13e77574d99','90939d32ec8848da83d84fae3fa8b25f','b7976c9cad55405fab751d6fdc41e76c','71ba59852d3b4ea59555db953893876a','aef1d9b7999e4ac78befe584ce66596d','e0416fc08fc3476bb58f3d49659db8e7','495c026df4d64036b9d973bc36f3bec3','10e0599e507e3a839b547125257f7c21','74c65eb7b59448fdb41e59f665b30514','3b1d5cf483f74b18895c7b7c622ef621','6e1aec58a5b346b2b8711785dd2bd4f7','5aefec60349a4986a7c2bbe82045d758','eb27ef412b9e4497a5fdb16af72b55f3','0f107d57493cc025d7b1c7aaa004f590','0ba57e331c8e48839eaf47e63eaa246a','dd1bf64343fd4d85b1babffa467df266','8dd22736ca7143b8aab34918ca30b7e8','5bfde4fd35254e63ad20a7c79b58878d','40c3451a8db94606862bdd657d5f588e','ae4cc7ac6f604c57bf80212cd3597b54','526665de19a4433a927ce55473f187c0','3ad946ba38264956b93fa3e8def57e41','951a08ad24664d2184f3757489ec4284','3de208f7968247fc8cb96be1e1bcf389','97a2dc1d3f034b7791f9af488ec8447e','9fb83fde78304293a33c172355af177c','e0be691fbebe4ca3ba94a73f4e44c85c','2e597616015c447498de39ae3faa25b1','d4af2b7b4482496681fb336038a71287','548559df749a64e304efaa4a44d19ca6','f13df5e1028a44f4b1b98311170aec1c','3b96ad5f7b004a47bd5a5f2bea673858','66d324f1b8b94864bd57298d16b7e918','25b3b418b1a842b5a9c7b17b2f285c59','3349166613fc40d181a9550b890e0190','6b6d83bd02ec4b5a91ad0d20934d8343','48d7e1a483b145deb120c1893cdefc5c','c7fbfa8bd7d04c6fb842c330bb23e0b9','7d16aa59b6f14330b6d1eb75affde13e','82197df6a4cdc4ef4c640c5719c53d09','2d43411068d4a8dfba2beed240b933c6','53488eacc01e6ca8edc297c6fd85cc0a','3b6fbf29b3f228a5e879fb951a505fb2','ad3ed01be14e48119a264579a442e8a3','9dbe84bc3b1c42c2988ba5838604fe73','3bdbe22a0c204f8d83d911b0085f11d4','7b4da1d8267f4c99bade23972150116c','faca7f086fa2448ca79a2128464f1dd7','76b989870797c8f7c0dfe37e1157bd55','70d25d4a5c6e4913bd22b746840f1f67','729ec35fdb0f4392a6f7b90b1f93c745','c182d6f1ba8d403ea578b5f59b3cfd3b','0ead6b34afe549ec870c05706756476c','0b50dd0c57204854b29e078a262e9870','74da4b3833154972abcbcd666e42f5ab','fef32ff1c14a425e8bf8b76b3bd00aae','00736990bc4817180da9d4405ae58c65','96c1cbf922f04ebb9c7deb2b58416931','72b44f62a796320b27611c7f94e68427','c2e1bde2c2674436adec1b740b9761e3','ffe9fec3dfd8f8d70b9c98ac2516be61','6105ea3ec3720f2d68a9a075bf482fe9','729652082ce54106831b3d37c8f14e98','0ad54bddb91a42bfbc7831b21d46dce4','a7b5dc89e50d81c078476d89bf25ab6e','6a06d86a61b04712a13b9943bf58c775','ac8803ba49becec2f60dfe0d29f29d2e','798e7390b717fedb452276c84502fa1f','6b09fea664a84cc584759d4c1bf3de92','c706094f16b9402da153172d447ea48b','065bf958aaa244dc86117dde7bff28af','4a94631e1e6a9a1474f140faa5797e23','bc54338ad87e407681c005d96b659c2c','8d05e90c142a44d4b13047af2570e693','7b0b4f9e1c4f2a1a35a6959999d712ab','1ba60d18164a434e97855f9e729a53a9','10cfa43c5f5e41d094fb137d558a5c3d','f3c32e187fd34f789e93831d430c91e5','d5203fd32b4c411f8dea63a42e303d27','c835f74ad528437193de73f7fb778dd1','164e7ce36e844c74a53b87172580d8ef','30de9294067247f197d1df789aa2e695','3357abfd233e208c156ff2d49cb79f9e','aadb2e7c50b144e588879f11c7007c32','1e198d6c45674639bfbf0154efacfb46','fe40cc97fb88427487c73fa58ec1f7c3','bba072fb7e8448948519a5aed902ff0d','06c9633526d347b8af00c70e078700cc','475dd3babdfc49cf8107c7bd0754dc3f','bdef118246994ef69f23eb9eef7ef840','d3eb4e21401346209f0003b82507e65c','9ec628624d02455eb967dfa38e26630e','8014554a5e6746e3a8c995b514f0b198','3019cd40a1184f54b7ce11504591d281','7007748c77488e92ea7fc67a0429605c','ab1e3d8fbde64e609278757560eaeb39','1ef8436ee9d348c89e432dba0031504c','017dde97242a4e739f89ffceead2d130','64a14cf222c7447eacdedb69a87c0165','92b236bf740dc7195651ebfa7aa373d4','3ca21cbcb713466da1d4ff01c605da17','0ae52fe8367c40bfb1dec54d5d97887c','7faae7f480674cf78d52b596e5c030a8','eea46ad5c0b6442b9a2387396209cbbb','ef40ae74a6abd6977fdadad3b2dba8e4','e57920eb09ed4fbe985f0946508ab77c','4f59d987580040059e4e6f6dd49da92e','a4446706ad484f96ac9dd7dbc89dc161','e70f9ec38caf4732adb2ad45bd8e786c','04bb2f4bcb5b4a6a847ca73d3bbc4d64','1aca540862554c8f81f21d73cf58e5f5','af0a708ba3cd401ebb55b37760bca579','79e5cf6dcf474356aa7b2103f24192de','7e334f62b2824def8709cf13458bcd5d','0e86ad2d547a4901a33887df7fc4d0dc','960f852825044ffca0b27595ea66274d','b9e0e6050f3b4328897943427ab990a6','574ba24ea58f4e3ca92dd97826d7c838','31eca0102b4a4fc183584d333c858e09','bb5e0f620f15478aaade110052f55ef9','baca47fb340a42cb92812dee100d7a89','764603c5f7bb40c28b414f4d2a64cff6','b755870374474a7fa9375d15d77c079c','d76beb91a988c1b2726e31b279badc25','b144f71451279534bea649b2a998d079','fa84fef638dd4d419fa325782fcfa3a3','8e3b829d1da04fe4a9bab78cefa62487','e1735233d8364cfab7d011f6172a346d','8a7c18a475b045efb662a926a4e7708e','1441499120474fdab4de8719a73c42e2','ac3a8815e58547a1a43247ef8ce8bf6a','311e669fb5fa4efcb310d5b6cd8d09c2','868d8e40420646efb9be1b353d1b224e','ce434e5c82ca47abbbfe9164f1d10397','35be1cf21ed0417a844307ce2e75fdd6','020d6c331c9142e38db2a7958d5032ea','cfd3692acad3ef60cc0bff64ceb52c8f','9c869bfeb818b0c213aab9579f4b5ac9','753a1c155522482092b85db501679e6d','c5fac5b853243f73414eaf37d050d6a0','e0d6d5b274624accab0bafd515048932','fdbc6af3d15e448b9f378f0ed879840f','2932eebf8e124eb287a41d51548c8a25','102ea74da0c44267b3bf7d509f2f8d4f','b4c3ab1668154adaad15ffb9b33c3d38','e57b5d60b27172ef544cb773aedef688','ed43c8b2b54a49ff9887db7de2a54cec','a35333ac44a4e48496dd8cfb68ea7734','4d1f3306bddd475ebc4abb24786689a4','467fa9d0ca2e4ba7a98365f91b0df803','351da6d21410401cbb1d83a58cb08694','40b58cff020147a88368e3fbefc55cec','688f9cb0bb924af18832c93777160aec','117c8998bc9a410bb27e417067e8808d','13c44d7c87d24b6bac9c518c954c1c99','e73bd3dbcdd0c1e158be1417b4af61ff','311c397e84244fc08953590217476b06','087c71e200580ef6f11307bee0aadee7','2a8414f348dd6def26faad4b11165d48','376c67521b9f4a7eaa05270e9ed147ad','9e74da9968cf43f1b3fd794a2e819a80','0308a50f08a24afab2b7b911a191490d','be10daab518645be88472b883147c089','82d580eefb334b7ab7a639cfee97f0d4','a869a38d76294a7c92290f1ae80eaee8','1fe1807cd2d9424b85b0a7f9337e96bd','a1087e7152d173cf1ce89959bdd10c76','d97be09d3c0840789df93b8e283e1bf6','0803c1479af546469db101a2592c7ac8','43b735554a85427c8e393f2de8a1d45c','91d00b5d1cee4b2b96799b0fbef1bd6c','e2bdc7f1c4e24069b681e323141c1660','e5b00b354aba4039ae2043837ca6ef34','af146ee7866858ecc9a6cb969925bfde','b762abf8271e2a805fae9993ae798d65','c0954421590a41e783fc61f0df45b946','bd423496a2b2436890740f084ebb23a7')                                   order by  main.house_auth_date   desc;
  9. explain 线程956189 SQL 结果
    explain.jpg
  10. 使用show profile  查看 线程956189 SQL 执行各阶段花费时间:
    profile.jpg

已邀请:

yejr

赞同来自:

在有问题的网络环境里,跑一下这个sql再看profiling呢?

shenoubang - 折腾不休,奋斗不止

赞同来自:

@yejr谢谢叶老师,在您的指导下,打印出日志来发现,时间花费最大的实在创建索引上,详情如图。具体为什么创建索引时间很长的原因,我继续查。
慢查询时间:

query_time.png

 
profile时间

create_index.png

 

yejr

赞同来自:

这个就明显了,木有靠谱的索引 :)
再回头看,其实第一次的截图里已经有这个信息了,我没注意到~

要回复问题请先登录注册