数据库查询非常多,小白不懂,请大佬指教指教

用户 juchen0314 16天前 159


id:1606591  host:10.133.210.153:36540  用户名:bzz_f  数据库名:bzz  类型:Query  执行时间:4  状态:Waiting for table level lock  详情:SELECT MIN(log_ID),MAX(log_ID) FROM zbp_post WHERE log_Type = '0' AND log_Status = '0' ORDER BY log_PostTime ASC  

id:1606525  host:10.133.210.153:36510  用户名:bzz_f  数据库名:bzz  类型:Query  执行时间:14  状态:Sending data  详情:SELECT MIN(log_ID),MAX(log_ID) FROM zbp_post WHERE log_Type = '0' AND log_Status = '0' ORDER BY log_PostTime ASC  

id:1606524  host:10.133.210.153:36508  用户名:bzz_f  数据库名:bzz  类型:Query  执行时间:14  状态:Sending data  详情:SELECT MIN(log_ID),MAX(log_ID) FROM zbp_post WHERE log_Type = '0' AND log_Status = '0' ORDER BY log_PostTime ASC  

id:1606514  host:10.133.210.153:36502  用户名:bzz_f  数据库名:bzz  类型:Query  执行时间:15  状态:Sending data  详情:SELECT MIN(log_ID),MAX(log_ID) FROM zbp_post WHERE log_Type = '0' AND log_Status = '0' ORDER BY log_PostTime ASC  

id:1606510  host:10.133.210.153:36498  用户名:bzz_f  数据库名:bzz  类型:Query  执行时间:15  状态:Sending data  详情:SELECT MIN(log_ID),MAX(log_ID) FROM zbp_post WHERE log_Type = '0' AND log_Status = '0' ORDER BY log_PostTime ASC  

id:1606497  host:10.133.210.153:36494  用户名:bzz_f  数据库名:bzz  类型:Query  执行时间:18  状态:Sending data  详情:SELECT MIN(log_ID),MAX(log_ID) FROM zbp_post WHERE log_Type = '0' AND log_Status = '0' ORDER BY log_PostTime ASC  

id:1606496  host:10.133.210.153:36492  用户名:bzz_f  数据库名:bzz  类型:Query  执行时间:18  状态:Sending data  详情:SELECT MIN(log_ID),MAX(log_ID) FROM zbp_post WHERE log_Type = '0' AND log_Status = '0' ORDER BY log_PostTime ASC  

id:1606494  host:10.133.210.153:36490  用户名:bzz_f  数据库名:bzz  类型:Query  执行时间:18  状态:Sending data  详情:SELECT MIN(log_ID),MAX(log_ID) FROM zbp_post WHERE log_Type = '0' AND log_Status = '0' ORDER BY log_PostTime ASC  

id:1606455  host:10.133.210.153:36466  用户名:bzz_f  数据库名:bzz  类型:Query  执行时间:21  状态:Sending data  详情:SELECT MIN(log_ID),MAX(log_ID) FROM zbp_post WHERE log_Type = '0' AND log_Status = '0' ORDER BY log_PostTime ASC  

id:1606447  host:10.133.210.153:36456  用户名:bzz_f  数据库名:bzz  类型:Query  执行时间:7  状态:Waiting for table level lock  详情:SELECT log_ID FROM zbp_post WHERE log_Type = '0' AND log_IsTop > '0' AND log_Status = '0'  

id:1606443  host:10.133.210.153:36450  用户名:bzz_f  数据库名:bzz  类型:Query  执行时间:25  状态:Sending data  详情:SELECT MIN(log_ID),MAX(log_ID) FROM zbp_post WHERE log_Type = '0' AND log_Status = '0' ORDER BY log_PostTime ASC  

id:1606389  host:10.133.210.153:36432  用户名:bzz_f  数据库名:bzz  类型:Query  执行时间:8  状态:Waiting for table level lock  详情:SELECT * FROM zbp_post WHERE log_ID = '139272' AND log_Status = '0' LIMIT 1  

id:1606375  host:10.133.210.153:36410  用户名:bzz_f  数据库名:bzz  类型:Query  执行时间:13  状态:Sending data  详情:SELECT * FROM zbp_post WHERE log_Type = '0' AND log_Status = '0' AND log_ID > '125504' LIMIT 10  

id:1606266  host:10.133.210.153:36372  用户名:bzz_f  数据库名:bzz  类型:Query  执行时间:8  状态:Waiting for table level lock  详情:UPDATE zbp_post SET log_ViewNums = '36' WHERE log_ID = '47956'  

id:1606242  host:10.133.210.153:36352  用户名:bzz_f  数据库名:bzz  类型:Query  执行时间:8  状态:Waiting for table level lock  详情:UPDATE zbp_post SET log_ViewNums = '14' WHERE log_ID = '103703'  

id:1606188  host:10.133.210.153:36336  用户名:bzz_f  数据库名:bzz  类型:Query  执行时间:8  状态:Waiting for table level lock  详情:UPDATE zbp_post SET log_ViewNums = '13' WHERE log_ID = '130324'  

id:1606179  host:10.133.210.153:36332  用户名:bzz_f  数据库名:bzz  类型:Query  执行时间:8  状态:Waiting for table level lock  详情:UPDATE zbp_post SET log_ViewNums = '13' WHERE log_ID = '145448'  

id:1606166  host:10.133.210.153:36320  用户名:bzz_f  数据库名:bzz  类型:Query  执行时间:8  状态:Waiting for table level lock  详情:UPDATE zbp_post SET log_ViewNums = '13' WHERE log_ID = '113707'  

id:1606165  host:10.133.210.153:36318  用户名:bzz_f  数据库名:bzz  类型:Query  执行时间:8  状态:Waiting for table level lock  详情:UPDATE zbp_post SET log_ViewNums = '11' WHERE log_ID = '90161'  

id:1606126  host:10.133.210.153:36300  用户名:bzz_f  数据库名:bzz  类型:Query  执行时间:8  状态:Waiting for table level lock  详情:UPDATE zbp_post SET log_ViewNums = '36' WHERE log_ID = '47956'  

id:1606098  host:10.133.210.153:36288  用户名:bzz_f  数据库名:bzz  类型:Query  执行时间:8  状态:Waiting for table level lock  详情:SELECT * FROM zbp_post WHERE log_Type = '0' AND log_Status = '0' AND log_PostTime < '1599761152' ORDER BY log_PostTime DESC LIMIT 1  

id:1606083  host:10.133.210.153:36276  用户名:bzz_f  数据库名:bzz  类型:Query  执行时间:8  状态:Waiting for table level lock  详情:SELECT * FROM zbp_post WHERE log_Type = '0' AND log_Status = '0' AND log_PostTime < '1597020771' ORDER BY log_PostTime DESC LIMIT 1  

id:1606081  host:10.133.210.153:36272  用户名:bzz_f  数据库名:bzz  类型:Query  执行时间:8  状态:Waiting for table level lock  详情:SELECT * FROM zbp_post WHERE log_Type = '0' AND log_Status = '0' AND log_PostTime < '1596978264' ORDER BY log_PostTime DESC LIMIT 1  

id:1606057  host:10.133.210.153:36266  用户名:bzz_f  数据库名:bzz  类型:Query  执行时间:8  状态:Waiting for table level lock  详情:SELECT * FROM zbp_post WHERE log_Type = '0' AND log_Status = '0' AND log_PostTime < '1598336049' ORDER BY log_PostTime DESC LIMIT 1  

id:1605962  host:10.133.210.153:36228  用户名:bzz_f  数据库名:bzz  类型:Query  执行时间:8  状态:Waiting for table level lock  详情:SELECT * FROM zbp_post WHERE log_Type = '0' AND log_Status = '0' AND log_PostTime < '1597155801' ORDER BY log_PostTime DESC LIMIT 1  

id:1605920  host:10.133.210.153:36216  用户名:bzz_f  数据库名:bzz  类型:Query  执行时间:8  状态:Waiting for table level lock  详情:SELECT * FROM zbp_post WHERE log_ID = '2039'  

id:1605918  host:10.133.210.153:36214  用户名:bzz_f  数据库名:bzz  类型:Query  执行时间:8  状态:Waiting for table level lock  详情:SELECT * FROM zbp_post WHERE log_Type = '0' AND log_Status = '0' AND log_Tag LIKE '%{424}%' AND log_ID <> '46319' ORDER BY rand() LIMIT 20  

id:1605907  host:10.133.210.153:36210  用户名:bzz_f  数据库名:bzz  类型:Query  执行时间:8  状态:Waiting for table level lock  详情:SELECT * FROM zbp_post WHERE log_Type = '0' AND log_Status = '0' AND log_PostTime > '1596279600' ORDER BY log_PostTime ASC LIMIT 1  

id:1605875  host:10.133.210.153:36198  用户名:bzz_f  数据库名:bzz  类型:Query  执行时间:8  状态:Waiting for table level lock  详情:SELECT * FROM zbp_post WHERE log_Type = '0' AND log_Status = '0' AND log_Tag LIKE '%{383}%' AND log_ID <> '47956' ORDER BY rand() LIMIT 20  

id:1605863  host:10.133.210.153:36190  用户名:bzz_f  数据库名:bzz  类型:Query  执行时间:8  状态:Copying to tmp table  详情:SELECT * FROM zbp_post WHERE log_Type = '0' AND log_Status = '0' AND log_Tag LIKE '%{2069}%' AND log_ID <> '31099' ORDER BY rand() LIMIT 20  

id:1605816  host:10.133.210.153:36180  用户名:bzz_f  数据库名:bzz  类型:Query  执行时间:8  状态:Copying to tmp table  详情:SELECT * FROM zbp_post WHERE log_Type = '0' AND log_Status = '0' AND log_Tag LIKE '%{788}%' AND log_ID <> '11074' ORDER BY rand() LIMIT 20  

id:1605795  host:10.133.210.153:36174  用户名:bzz_f  数据库名:bzz  类型:Query  执行时间:25  状态:Copying to tmp table  详情:SELECT * FROM zbp_post WHERE log_Type = '0' AND log_Status = '0' AND log_Tag LIKE '%{291}%' AND log_ID <> '145448' ORDER BY rand() LIMIT 20  


最新回复 (3)
全部楼主
  • 用户 juchen0314 10天前 0
    引用 2
    大佬指点一下啊
  • 应用开发者 thisexplorer 10天前 0
    引用 3
    某个插件或者主题……

    专注zblog开发,接受任意类型的主题定制和仿站、开发任意类型插件
    可风网 zblog交流群 865945543

  • 用户 lanceleeqqq 5天前 0
    引用 4
    我也遇到了同样的问题,负载过载,插件卸载完还是有这个问题 就剩下主题了
    • ZBlogger技术交流中心
      5
          
返回