| Id |
User |
Host |
db |
Command |
Time |
State |
Info |
| 11071473 |
wowcityadmin |
192.168.0.1:49965 |
wowcity |
Sleep |
69 |
|
|
| 11071501 |
wowcityadmin |
192.168.0.1:50174 |
wowcity |
Sleep |
66 |
|
|
| 11071509 |
wowcityadmin |
192.168.0.1:50237 |
wowcity |
Sleep |
64 |
|
|
| 11071589 |
wowcityadmin |
192.168.0.1:50568 |
wowcity |
Sleep |
51 |
|
|
| 11071593 |
wowcityadmin |
192.168.0.1:50597 |
wowcity |
Sleep |
52 |
|
|
| 11071670 |
wowcityadmin |
192.168.0.1:50965 |
wowcity |
Sleep |
36 |
|
|
| 11071678 |
wowcityadmin |
192.168.0.1:51014 |
wowcity |
Sleep |
33 |
|
|
| 11071700 |
wowcityadmin |
192.168.0.1:51093 |
wowcity |
Sleep |
26 |
|
|
| 11071704 |
wowcityadmin |
192.168.0.1:51109 |
wowcity |
Sleep |
29 |
|
|
| 11071799 |
wowcityadmin |
192.168.0.1:51638 |
wowcity |
Sleep |
12 |
|
|
| 11071804 |
wowcityadmin |
192.168.0.1:51653 |
wowcity |
Sleep |
11 |
|
|
| 11071845 |
wowcityadmin |
192.168.0.1:51819 |
wowcity |
Query |
0 |
Locked |
update featured_cid set views=views+1 where cid='5358455320498591388' AND city='24831' |
| 11071846 |
wowcityadmin |
192.168.0.1:51820 |
wowcity |
Query |
0 |
Locked |
update featured_cid set views=views+1 where cid='7358970255053133163' AND city='24831' |
| 11071848 |
wowcityadmin |
192.168.0.1:51843 |
wowcity |
Query |
0 |
Copying to tmp table |
SELECT * FROM uszip WHERE state='West Bengal' AND city='Kolkata' ORDER BY RAND() LIMIT 1 |
| 11071849 |
wowcityadmin |
192.168.0.1:51845 |
wowcity |
Query |
2 |
Locked |
UPDATE featured_cid SET views=views+1 WHERE cid='16060496345063938998' AND city='13082' |
| 11071850 |
wowcityadmin |
192.168.0.1:51846 |
wowcity |
Query |
0 |
Locked |
update featured_cid set views=views+1 where cid='6995684831230184566' AND city='13082' |
| 11071851 |
wowcityadmin |
192.168.0.1:51848 |
wowcity |
Sleep |
0 |
|
|
| 11071852 |
wowcityadmin |
192.168.0.1:51849 |
wowcity |
Sleep |
0 |
|
|
| 11071853 |
wowcityadmin |
192.168.0.1:51852 |
wowcity |
Query |
1 |
Locked |
update featured_cid set views=views+1 where cid='10465848202689261569' AND city='6448' |
| 11071854 |
wowcityadmin |
192.168.0.1:51855 |
wowcity |
Query |
3 |
Sorting result |
SELECT * FROM featured_cid WHERE (country = 254 AND region = 152) ORDER BY views DESC LIMIT 10 |
| 11071855 |
wowcityadmin |
192.168.0.1:51856 |
wowcity |
Sleep |
0 |
|
|
| 11071856 |
wowcityadmin |
192.168.0.1:51873 |
wowcity |
Sleep |
2 |
|
|
| 11071857 |
wowcityadmin |
192.168.0.1:51886 |
wowcity |
Query |
2 |
Locked |
SELECT * FROM featured_cid WHERE country = 175 AND region = 2989 AND city = 13283 ORDER BY views DES |
| 11071859 |
wowcityadmin |
192.168.0.1:51916 |
wowcity |
Sleep |
1 |
|
|
| 11071863 |
wowcityadmin |
192.168.0.1:51940 |
wowcity |
Query |
0 |
storing result in query cache |
SELECT
(Select Internet From location_countries Where CountryId = '15') as country,
(Select Intern |
| 11071864 |
wowcityadmin |
192.168.0.1:51942 |
wowcity |
Query |
0 |
Locked |
SELECT * FROM featured_cid WHERE country = 43 AND region = 37 AND city = 12656 ORDER BY views DESC L |
| 11071866 |
wowcityadmin |
192.168.0.1:51959 |
wowcity |
Query |
0 |
|
show processlist |