+------+-------------+------------------------------------+--------------+----------------+------+---------------------------+------------------------------------------------------------------------------------------------------+ | Id | User | Host | db | Command | Time | State | Info | +------+-------------+------------------------------------+--------------+----------------+------+---------------------------+------------------------------------------------------------------------------------------------------+ | 287 | DELAYED | localhost | romewar_main | Delayed insert | 6 | Waiting for INSERT | | | 1269 | romewar_php | 192.168.0.1:37337 | romewar_main | Query | 14 | preparing | SELECT gp.pid, gp.owner_id, gps.skill_level, gp.operate, IF(ISNULL(gpo.pid), 0, 1) AS `online`, gpl. | | 1272 | romewar_php | 192.168.0.1:37341 | romewar_main | Query | 0 | preparing | SELECT wks.pid, wks.money, gs.skill_level, gpi.id AS pitem_id, | | 1521 | romewar_php | localhost | romewar_main | Query | 24 | | UPDATE _game_players_items SET status = 1 WHERE id IN (@head, @shoulder, @body, @hand1, @ring1, @rin | | 1545 | romewar_php | customer-5975.eserver-ru.com:62708 | romewar_main | Query | 59 | Copying to tmp table | SELECT gs.skill_level, COUNT(gw.pid) AS cnt FROM _game_workers gw LEFT JOIN _ | | 2096 | romewar_php | 192.168.0.1:38355 | romewar_main | Query | 363 | preparing | SELECT gpl.licence_copy_id, gl.town_id, gp.pid, gp.account_id, gac.helper_ | | 2376 | romewar_php | customer-5975.eserver-ru.com:65323 | romewar_main | Query | 342 | Sending data | SELECT COUNT(pid) cnt FROM _game_players_online LEFT JOIN _game_players US | | 3224 | romewar_php | customer-5975.eserver-ru.com:51322 | romewar_main | Query | 274 | Sending data | SELECT COUNT(pid) cnt FROM _game_players_online LEFT JOIN _game_players US | | 4141 | romewar_php | localhost | romewar_main | Query | 0 | Sending data | SELECT x, y, complete, rating FROM _game_battle_players INNER JOIN _game_p | | 4196 | romewar_php | customer-5975.eserver-ru.com:54097 | romewar_main | Query | 187 | Copying to tmp table | SELECT gs.skill_level, COUNT(gw.pid) AS cnt FROM _game_workers gw LEFT JOIN _ | | 5005 | romewar_php | 192.168.0.1:45872 | romewar_main | Query | 0 | Copying to tmp table | SELECT wks.pid, wks.money, gs.skill_level, gpi.id AS pitem_id, | | 5010 | romewar_php | 192.168.0.1:45876 | romewar_main | Query | 78 | preparing | SELECT gp.pid, gp.owner_id, gps.skill_level, gp.operate, IF(ISNULL(gpo.pid), 0, 1) AS `online`, gpl. | | 5376 | romewar_php | localhost | romewar_main | Query | 0 | Sending data | UPDATE _game_players_hp SET hp_max = hp_default + IFNULL(( SELECT SUM(hp) | | 5470 | romewar_php | customer-5975.eserver-ru.com:57301 | romewar_main | Query | 64 | Sending data | SELECT @pl_id := '141252', @pl_ex := (SELECT experience FROM _game_players WHERE pid = @p | | 5808 | romewar_php | customer-5975.eserver-ru.com:58167 | romewar_main | Query | 17 | Sending data | SELECT pid FROM _game_players WHERE owner_id = '18877' && pid != '18877' | | 5825 | romewar_php | customer-5975.eserver-ru.com:58228 | romewar_main | Query | 15 | Sending data | SELECT pid FROM _game_players WHERE owner_id = '67424' && pid != '67424' | | 5830 | romewar_php | customer-5975.eserver-ru.com:58245 | romewar_main | Query | 12 | Sending data | SELECT pid FROM _game_players WHERE owner_id = '56189' && pid != '56189' | | 5838 | romewar_php | customer-5975.eserver-ru.com:58279 | romewar_main | Query | 12 | Sending data | SELECT pid FROM _game_players WHERE owner_id = '119559' && pid != '119559' | | 5891 | romewar_php | customer-5975.eserver-ru.com:58412 | romewar_main | Query | 11 | Sending data | SELECT pid FROM _game_players WHERE owner_id = '1165' && pid != '1165' | | 5894 | romewar_php | customer-5975.eserver-ru.com:58417 | romewar_main | Query | 0 | Copying to tmp table | SELECT gp.pid, gp.groups_mask, gp.login, gp.model, gp.level, | | 5901 | romewar_php | customer-5975.eserver-ru.com:58443 | romewar_main | Query | 7 | Sending data | SELECT pid FROM _game_players WHERE owner_id = '22529' && pid != '22529' | | 5905 | romewar_php | customer-5975.eserver-ru.com:58456 | romewar_main | Sleep | 11 | | | | 5913 | romewar_php | customer-5975.eserver-ru.com:58474 | romewar_main | Query | 5 | Sending data | SELECT pid FROM _game_players WHERE owner_id = '15199' && pid != '15199' | | 5917 | romewar_php | customer-5975.eserver-ru.com:58484 | romewar_main | Sleep | 7 | | | | 5930 | romewar_php | customer-5975.eserver-ru.com:58515 | romewar_main | Query | 0 | statistics | SELECT abilities_access FROM _game_clans_players WHERE pid = 43813 | | 5938 | romewar_php | customer-5975.eserver-ru.com:58549 | romewar_main | Query | 0 | Sending data | SELECT pid FROM _game_players WHERE owner_id = '22601' && pid != '22601' | | 5941 | romewar_php | customer-5975.eserver-ru.com:58552 | romewar_main | Query | 2 | Sending data | SELECT pid FROM _game_players WHERE owner_id = '136593' && pid != '136593' | | 5949 | romewar_php | customer-5975.eserver-ru.com:58566 | romewar_main | Query | 1 | Sending data | SELECT pid FROM _game_players WHERE owner_id = '137625' && pid != '137625' | | 5951 | romewar_php | customer-5975.eserver-ru.com:58574 | romewar_main | Query | 0 | statistics | SELECT way, level FROM _game_players_way WHERE pid = 56383 LIMIT 1 | | 5955 | romewar_php | customer-5975.eserver-ru.com:58578 | romewar_main | Query | 0 | Copying to tmp table | SELECT name, FLOOR((UNIX_TIMESTAMP(dead_line) - UNIX_TIMESTAMP(NOW())) / 60) | | 5960 | romewar_php | 192.168.0.1:47123 | romewar_main | Query | 3 | preparing | UPDATE _game_slaves_data SET tired_pc = tired_pc + 2 WHERE tired = 0 && | | 5963 | romewar_php | 192.168.0.1:47126 | romewar_main | Query | 0 | statistics | SELECT speed, town_id, type FROM _game_gmap LEFT JOIN _game_gmap_types USING(type) WHERE x = -188 & | | 5964 | romewar_php | 192.168.0.1:47127 | romewar_main | Query | 3 | preparing | SELECT gpl.licence_copy_id, gl.town_id, gp.pid, gp.account_id, gac.helper_ | | 5976 | romewar_php | localhost | romewar_main | Query | 0 | Searching rows for update | UPDATE _game_players_hp SET hp = IFNULL(hp + hp_max * (3000 / 60 / regen_time / 100), 0) | | 5977 | root | localhost | | Query | 0 | | show processlist | +------+-------------+------------------------------------+--------------+----------------+------+---------------------------+------------------------------------------------------------------------------------------------------+ Uptime: 513 Threads: 35 Questions: 328783 Slow queries: 195 Opens: 1310 Flush tables: 1 Open tables: 256 Queries per second avg: 640.902