5.9 获取top10品类session之本地测试 top10_category_session：每个品类的top10活跃session mysql> select * from top10_category_session;
+ -- -------+-------------+----------------------------------+-------------++ -- -------+-------------+----------------------------------+-------------+1 | 80 | d7d5a0bf96b64e259f777eec2ef890e1 | 2 |
| 1 | 80 | d1f8e52f687346beaeb07c6b2c41e898 | 1 |
| 1 | 80 | 098701d10de146f3b4b148a9788837a1 | 1 |
| 1 | 80 | 6a69e98cf98a4ce495a4743743cce622 | 1 |
| 1 | 80 | 8f1a6961e8914922b5ca39831dcae9e1 | 1 |
| 1 | 80 | 820d399ac02849d0a06249ff16966613 | 1 |
| 1 | 80 | 614386f7f55a498985d7e6ef600a78e8 | 1 |
| 1 | 80 | 79b859f7debd46e6b415a7b591399fc7 | 1 |
| 1 | 80 | 9ab9005979164226878ea1e7b741e437 | 1 |
| 1 | 80 | c157870775e1448494c83f429faa7eee | 1 |
| 1 | 79 | 6b712a039ba6474d9d47a4ea0d9a7711 | 1 |
| 1 | 79 | 76cc606274d8461abdbe9b72d60e7313 | 1 |
| 1 | 79 | 3e78b7249572403a96f5f7c4f5d6023a | 1 |
| 1 | 79 | 076a5ecf750d4cceacffcb30358a28b1 | 1 |
| 1 | 79 | 77fb7bd1f49842228653fff678027763 | 1 |
| 1 | 79 | 022567f662084c3baeb04b13e2e8fdc4 | 1 |
| 1 | 79 | fb2a1dec3c0a4eb7be1bbd6270b5f176 | 1 |
| 1 | 79 | 32dbb0abeac240a88e332a51547ba3d5 | 1 |
| 1 | 79 | b9dd1b37cd614626bc46106215748c21 | 1 |
| 1 | 79 | 20a7d8796d704379ac26e4566be0e8fb | 1 |
| 1 | 14 | 2995aaa1c6c04c9db5aecd4abd3969db | 1 |
| 1 | 14 | b44e2b4467fd4f6fbf0e14f4f98bab6b | 1 |
| 1 | 14 | d5a8bbdfa070477ead74e12820b5fd60 | 1 |
| 1 | 14 | 117c6ba0590f45c7bc287c7d9d3e2232 | 1 |
| 1 | 14 | d9762c914202433687f629636205e685 | 1 |
| 1 | 14 | 04c9a9c0f0984ea7be5e4a5c871b98dc | 1 |
| 1 | 14 | b07bd8f304464b239b66c497a7fe6b50 | 1 |
| 1 | 14 | 7f0b969f608840729ca5941f4fab8f29 | 1 |
| 1 | 14 | 79b859f7debd46e6b415a7b591399fc7 | 1 |
| 1 | 14 | 4b0774d3033d4d16915f62291944f007 | 1 |
| 1 | 50 | d1f8e52f687346beaeb07c6b2c41e898 | 1 |
| 1 | 50 | 658c097544bc484d9f698629a18930cc | 1 |
| 1 | 50 | 8ba67f9687a34940a91947c250bab7dd | 1 |
| 1 | 50 | d90ddab1068f481dbdb5a6d9651c2ba2 | 1 |
| 1 | 50 | 1a5c237682e545e3a27b241b1380ad88 | 1 |
| 1 | 50 | 67e22cec422c41bda66d233df3742d09 | 1 |
| 1 | 50 | 6176c10c51544d09862aff20244af810 | 1 |
| 1 | 50 | 614386f7f55a498985d7e6ef600a78e8 | 1 |
| 1 | 50 | 460e40d5df814ed3b6ea2bce86c6dde7 | 1 |
| 1 | 50 | c157870775e1448494c83f429faa7eee | 1 |
| 1 | 62 | 677216e500f14a8ca8d7ab3d4ea99f5e | 1 |
| 1 | 62 | 830e50d75b27437fa08c7b88f959a487 | 1 |
| 1 | 62 | 693e5df05ab04b068ecd2690a901e5a5 | 1 |
| 1 | 62 | 076a5ecf750d4cceacffcb30358a28b1 | 1 |
| 1 | 62 | ff237ee2661c48529e038591894a47ec | 1 |
| 1 | 62 | 3948f5a602944a88b60dc75b69b50154 | 1 |
| 1 | 62 | 3e672376b5384186bad2d3154605a5ba | 1 |
| 1 | 62 | 20a7d8796d704379ac26e4566be0e8fb | 1 |
| 1 | 62 | d551f41aa7734cf28a81236432c28f17 | 1 |
| 1 | 62 | b0ad23f4bb6d4a7abdcaac2eb5286d8c | 1 |
| 1 | 64 | 6b712a039ba6474d9d47a4ea0d9a7711 | 1 |
| 1 | 64 | de732bb61b7440f6b361871d1d94bfdd | 1 |
| 1 | 64 | 677216e500f14a8ca8d7ab3d4ea99f5e | 1 |
| 1 | 64 | d7da9adc523444a9ba8b28a627448a9e | 1 |
| 1 | 64 | cfc3f162825d44cf9f5f5c2ac1ad9e0c | 1 |
| 1 | 64 | 2b3cc993f51f4ce19ca39168d0bb43fb | 1 |
| 1 | 64 | 4f3e464d6b4c445dabb44e1f45b2f42b | 1 |
| 1 | 64 | 77fb7bd1f49842228653fff678027763 | 1 |
| 1 | 64 | ce085aae0c5141e68db82a23ed6972a2 | 1 |
| 1 | 64 | 6121e90763194bb5a4470f66dcce27fd | 1 |
| 1 | 37 | b9489367d37249dab468576abe5eca0b | 1 |
| 1 | 37 | 40b57f8ee8b14a22b936336e565195d0 | 1 |
| 1 | 37 | 2d777efd05fb47da8d1369160a12aa30 | 1 |
| 1 | 37 | 245e98ec2bf84c7b8cefcf0a3fabce23 | 1 |
| 1 | 37 | a76edb5f4084437abfa83c29100d286f | 1 |
| 1 | 37 | 14574ba667264767b775787997366be0 | 1 |
| 1 | 37 | 499e62681bf14d04b1acee03e8de8aaf | 1 |
| 1 | 37 | 72af9d86a37c439bb6d3d5537358cfae | 1 |
| 1 | 37 | 93aa243267e34fdc9f68c5ee98a92508 | 1 |
| 1 | 37 | 7bfa6c39926b446691a02b379da94498 | 1 |
| 1 | 83 | d1f8e52f687346beaeb07c6b2c41e898 | 1 |
| 1 | 83 | cfc3f162825d44cf9f5f5c2ac1ad9e0c | 1 |
| 1 | 83 | 89bbcfc2b5cf4f40a7b1d2951f4bd2e8 | 1 |
| 1 | 83 | 8f5de2f081a1481aa1d15fa86dcc2321 | 1 |
| 1 | 83 | a16a8c74b708432daa67279e596f6675 | 1 |
| 1 | 83 | 007d308eb9d54dd5bf794d994a381809 | 1 |
| 1 | 83 | b9dd1b37cd614626bc46106215748c21 | 1 |
| 1 | 83 | d3a66182098846d28dc3e202cdcde50a | 1 |
| 1 | 83 | 79b859f7debd46e6b415a7b591399fc7 | 1 |
| 1 | 83 | 17dd6125e84646fe953011befc19ff13 | 1 |
| 1 | 91 | d7da9adc523444a9ba8b28a627448a9e | 2 |
| 1 | 91 | 044b344f0fe94cc4a39109c6fdee04a3 | 1 |
| 1 | 91 | 4ff50b036dca4b179931f2b5f410fbf1 | 1 |
| 1 | 91 | 145969c5e4564c859c955177dbc53ad0 | 1 |
| 1 | 91 | 5d2c67ff13f24e5cbed359f8dc6fd73e | 1 |
| 1 | 91 | 441d7a8ed2ab4e95a23198a3e004e4cd | 1 |
| 1 | 91 | cb5cfdd27c0146fda77711becbf2da2f | 1 |
| 1 | 91 | a4c00c2ba5b849c78184a844e6d27107 | 1 |
| 1 | 91 | 02267f6a28e2453a924c850462281ac0 | 1 |
| 1 | 91 | 98b74e35fade4269b1433eed7b3945d3 | 1 |
| 1 | 10 | 2995aaa1c6c04c9db5aecd4abd3969db | 1 |
| 1 | 10 | 549620534d304ce48d4d24d11946cdd2 | 1 |
| 1 | 10 | e4cb30554aba47d7b6699544560552d8 | 1 |
| 1 | 10 | aac18a814b5d44c583583673cbb1cfdb | 1 |
| 1 | 10 | 3fe1fb5b0b32461ab24b829d9782d94d | 1 |
| 1 | 10 | 67e22cec422c41bda66d233df3742d09 | 1 |
| 1 | 10 | b9dd1b37cd614626bc46106215748c21 | 1 |
| 1 | 10 | 2d89a5afc6a44d75aa1d45caf021372f | 1 |
| 1 | 10 | dae2d2ae31e8483397a28769e9aadeab | 1 |
| 1 | 10 | 9ab9005979164226878ea1e7b741e437 | 1 |
+ -- -------+-------------+----------------------------------+-------------+100 rows in set (0 .01 sec) mysql> select * from top10_category;
+ -- -------+-------------+-------------+-------------+-----------++ -- -------+-------------+-------------+-------------+-----------+1 | 64 | 15 | 7 | 3 |
| 1 | 79 | 14 | 8 | 14 |
| 1 | 83 | 14 | 6 | 10 |
| 1 | 37 | 13 | 10 | 9 |
| 1 | 80 | 13 | 8 | 4 |
| 1 | 10 | 13 | 7 | 8 |
| 1 | 14 | 12 | 12 | 4 |
| 1 | 62 | 12 | 9 | 2 |
| 1 | 91 | 12 | 8 | 8 |
| 1 | 50 | 12 | 6 | 4 |
+ -- -------+-------------+-------------+-------------+-----------+10 rows in set (0 .00 sec)