Tuesday, October 22, 2024

Moutain Time: || Universal Time:

Select Stat:

# Member Wins -
1. admin
2. Empty -
3. Empty -
4. Empty -
5. Empty -
6. Empty -
7. Empty -
8. Empty -
9. Empty -
10. Empty -
Powered By: BlueThrust Clan Scripts v5
Based On: Bluethrust Clan Scripts v4
© Copyright 2024 Welcome to Zarks Fallen Angels :: Home of the most feared Zark fraggers around
SQL Queries: 67

Debug mode is on. To turn off these notifications, please go to My Account -> Administrator Options -> Website Settings -> Debug Mode and set to "Off"

PHP Version: 8.1.20
Queries: 67

$_SESSION

Variable Value
$_SESSION['csrfKey'] '3421f0085e3f6f7f169b4504a62751b4'
$_SESSION['appendIP'] '4e7467a892'

5 Most Repeated Queries

Count Query Stack Trace Of 1 Random Query
1 DELETE FROM ipban WHERE exptime != '0' AND exptime < '1729591234' [Click To Show]
1 OPTIMIZE TABLE `ipban` [Click To Show]
1 SELECT * FROM clocks [Click To Show]
1 SELECT * FROM console [Click To Show]
1 SELECT * FROM console [Click To Show]

5 Slowest Queries

# Seconds Query Stack Trace
1 0.001 SELECT * FROM hitcounter WHERE ipaddress = '18.222.109.79' [Click To Show]
2 0 SELECT * FROM ipban WHERE ipaddress = '18.222.109.79' [Click To Show]
3 0 SELECT * FROM ipban WHERE ipaddress LIKE '%*%' AND (exptime > '1729591234' OR exptime = '0') [Click To Show]
4 0 DELETE FROM ipban WHERE exptime != '0' AND exptime < '1729591234' [Click To Show]
5 0 OPTIMIZE TABLE `ipban` [Click To Show]

Query List - Order Of Execution

# Seconds Query Stack Trace
1 0 SELECT * FROM ipban WHERE ipaddress = '18.222.109.79' [Click To Show]
2 0 SELECT * FROM ipban WHERE ipaddress LIKE '%*%' AND (exptime > '1729591234' OR exptime = '0') [Click To Show]
3 0 DELETE FROM ipban WHERE exptime != '0' AND exptime < '1729591234' [Click To Show]
4 0 OPTIMIZE TABLE `ipban` [Click To Show]
5 0 SELECT * FROM plugin_pages WHERE page = 'mods' ORDER BY sortnum [Click To Show]
6 0 SELECT * FROM clocks [Click To Show]
7 0 SELECT * FROM console [Click To Show]
8 0 SELECT * FROM consolecategory [Click To Show]
9 0 SELECT * FROM gamesplayed [Click To Show]
10 0 SELECT * FROM menu_category [Click To Show]
11 0 SELECT * FROM menu_item [Click To Show]
12 0 SELECT * FROM menuitem_link [Click To Show]
13 0 SELECT * FROM rankcategory [Click To Show]
14 0 SELECT * FROM ranks [Click To Show]
15 0 SELECT * FROM console_members [Click To Show]
16 0 SELECT * FROM rank_privileges [Click To Show]
17 0 SELECT * FROM console [Click To Show]
18 0 SELECT * FROM ipban WHERE ipaddress = '18.222.109.79' [Click To Show]
19 0 SELECT * FROM membersonlypage WHERE pageurl = 'zarksfallenangels.com/top-players/game.php?gID=5' [Click To Show]
20 0.001 SELECT * FROM hitcounter WHERE ipaddress = '18.222.109.79' [Click To Show]
21 0 SELECT * FROM hitcounter WHERE hit_id = '4972' [Click To Show]
22 0 SELECT * FROM hitcounter WHERE hit_id = '4972' [Click To Show]
23 0 SELECT tablename FROM tableupdates WHERE tablename = 'hitcounter' [Click To Show]
24 0 UPDATE tableupdates SET updatetime = '1729591234' WHERE tablename = 'hitcounter' [Click To Show]
25 0 SELECT * FROM members WHERE username = '' [Click To Show]
26 0 SELECT menucategory_id FROM menu_category WHERE (accesstype = '0' OR accesstype = '2') AND hide = '0' AND section = '2' ORDER BY sortnum [Click To Show]
27 0 SELECT menuitem_id FROM menu_item WHERE (accesstype = '0' OR accesstype = '2') AND hide = '0' AND menucategory_id = '24' ORDER BY sortnum [Click To Show]
28 0 SELECT menucategory_id FROM menu_category WHERE (accesstype = '0' OR accesstype = '2') AND hide = '0' AND section = '0' ORDER BY sortnum [Click To Show]
29 0 SELECT menuitem_id FROM menu_item WHERE (accesstype = '0' OR accesstype = '2') AND hide = '0' AND menucategory_id = '17' ORDER BY sortnum [Click To Show]
30 0 SELECT * FROM menuitem_custompage WHERE menucustompage_id = '10' [Click To Show]
31 0 SELECT * FROM custompages WHERE custompage_id = '11' [Click To Show]
32 0 SELECT * FROM menuitem_custompage WHERE menucustompage_id = '11' [Click To Show]
33 0 SELECT * FROM custompages WHERE custompage_id = '12' [Click To Show]
34 0 SELECT menuitem_id FROM menu_item WHERE (accesstype = '0' OR accesstype = '2') AND hide = '0' AND menucategory_id = '29' ORDER BY sortnum [Click To Show]
35 0 SELECT * FROM gamesplayed ORDER BY ordernum DESC [Click To Show]
36 0 SELECT menuitem_id FROM menu_item WHERE (accesstype = '0' OR accesstype = '2') AND hide = '0' AND menucategory_id = '16' ORDER BY sortnum [Click To Show]
37 0 SELECT * FROM polls WHERE poll_id = '1' [Click To Show]
38 0 SELECT menuitem_id FROM menu_item WHERE (accesstype = '0' OR accesstype = '2') AND hide = '0' AND menucategory_id = '5' ORDER BY sortnum [Click To Show]
39 0 SELECT forumpost_id FROM forum_post ORDER BY dateposted DESC [Click To Show]
40 0 SELECT * FROM forum_post WHERE forumpost_id = '4' [Click To Show]
41 0 SELECT * FROM forum_topic WHERE forumtopic_id = '4' [Click To Show]
42 0 SELECT * FROM forum_board WHERE forumboard_id = '4' [Click To Show]
43 0 SELECT * FROM forum_post WHERE forumpost_id = '4' [Click To Show]
44 0 SELECT * FROM forum_topic WHERE forumtopic_id = '4' [Click To Show]
45 0 SELECT * FROM forum_topic WHERE forumtopic_id = '4' [Click To Show]
46 0 SELECT * FROM forum_post WHERE forumpost_id = '4' [Click To Show]
47 0 SELECT * FROM forum_post WHERE forumpost_id = '4' [Click To Show]
48 0 SELECT * FROM members WHERE member_id = '1' [Click To Show]
49 0 SELECT * FROM forum_post WHERE forumtopic_id = '4' ORDER BY dateposted [Click To Show]
50 0 SELECT * FROM forum_post WHERE forumtopic_id = '4' AND dateposted <= '1705894179' [Click To Show]
51 0 SELECT menucategory_id FROM menu_category WHERE (accesstype = '0' OR accesstype = '2') AND hide = '0' AND section = '1' ORDER BY sortnum [Click To Show]
52 0 SELECT menuitem_id FROM menu_item WHERE (accesstype = '0' OR accesstype = '2') AND hide = '0' AND menucategory_id = '1' ORDER BY sortnum [Click To Show]
53 0 SELECT * FROM menuitem_shoutbox WHERE menushoutbox_id = '1' [Click To Show]
54 0 SELECT * FROM members WHERE username = '' [Click To Show]
55 0 SELECT * FROM news WHERE newstype = '3' ORDER BY dateposted [Click To Show]
56 0 SELECT menuitem_id FROM menu_item WHERE (accesstype = '0' OR accesstype = '2') AND hide = '0' AND menucategory_id = '4' ORDER BY sortnum [Click To Show]
57 0 SELECT member_id FROM members WHERE rank_id != '1' AND disabled = '0' ORDER BY datejoined DESC LIMIT 5 [Click To Show]
58 0 SELECT clock_id FROM clocks ORDER BY ordernum DESC [Click To Show]
59 0 SELECT * FROM gamestats WHERE gamesplayed_id = '5' ORDER BY ordernum [Click To Show]
60 0 SELECT * FROM gamestats WHERE gamestats_id = '4' [Click To Show]
61 0 SELECT gamesplayed_members.member_id FROM gamesplayed_members, members WHERE gamesplayed_members.member_id = members.member_id AND gamesplayed_members.gamesplayed_id = '5' AND members.disabled = '0' [Click To Show]
62 0 SELECT * FROM members WHERE member_id = '1' [Click To Show]
63 0 SELECT * FROM gamestats WHERE gamestats_id = '4' [Click To Show]
64 0 SELECT * FROM gamestats_members WHERE member_id = '1' AND gamestats_id = '4' [Click To Show]
65 0 SELECT * FROM gamestats WHERE gamestats_id = '4' [Click To Show]
66 0 SELECT * FROM gamestats WHERE gamestats_id = '5' [Click To Show]
67 0 SELECT * FROM members WHERE member_id = '1' [Click To Show]

Query List - Alphabetical

# Seconds Query Stack Trace
1 0 DELETE FROM ipban WHERE exptime != '0' AND exptime < '1729591234' [Click To Show]
2 0 OPTIMIZE TABLE `ipban` [Click To Show]
3 0 SELECT * FROM clocks [Click To Show]
4 0 SELECT * FROM console [Click To Show]
5 0 SELECT * FROM console [Click To Show]
6 0 SELECT * FROM console_members [Click To Show]
7 0 SELECT * FROM consolecategory [Click To Show]
8 0 SELECT * FROM custompages WHERE custompage_id = '11' [Click To Show]
9 0 SELECT * FROM custompages WHERE custompage_id = '12' [Click To Show]
10 0 SELECT * FROM forum_board WHERE forumboard_id = '4' [Click To Show]
11 0 SELECT * FROM forum_post WHERE forumpost_id = '4' [Click To Show]
12 0 SELECT * FROM forum_post WHERE forumpost_id = '4' [Click To Show]
13 0 SELECT * FROM forum_post WHERE forumpost_id = '4' [Click To Show]
14 0 SELECT * FROM forum_post WHERE forumpost_id = '4' [Click To Show]
15 0 SELECT * FROM forum_post WHERE forumtopic_id = '4' AND dateposted <= '1705894179' [Click To Show]
16 0 SELECT * FROM forum_post WHERE forumtopic_id = '4' ORDER BY dateposted [Click To Show]
17 0 SELECT * FROM forum_topic WHERE forumtopic_id = '4' [Click To Show]
18 0 SELECT * FROM forum_topic WHERE forumtopic_id = '4' [Click To Show]
19 0 SELECT * FROM forum_topic WHERE forumtopic_id = '4' [Click To Show]
20 0 SELECT * FROM gamesplayed [Click To Show]
21 0 SELECT * FROM gamesplayed ORDER BY ordernum DESC [Click To Show]
22 0 SELECT * FROM gamestats WHERE gamesplayed_id = '5' ORDER BY ordernum [Click To Show]
23 0 SELECT * FROM gamestats WHERE gamestats_id = '4' [Click To Show]
24 0 SELECT * FROM gamestats WHERE gamestats_id = '4' [Click To Show]
25 0 SELECT * FROM gamestats WHERE gamestats_id = '4' [Click To Show]
26 0 SELECT * FROM gamestats WHERE gamestats_id = '5' [Click To Show]
27 0 SELECT * FROM gamestats_members WHERE member_id = '1' AND gamestats_id = '4' [Click To Show]
28 0 SELECT * FROM hitcounter WHERE hit_id = '4972' [Click To Show]
29 0 SELECT * FROM hitcounter WHERE hit_id = '4972' [Click To Show]
30 0.001 SELECT * FROM hitcounter WHERE ipaddress = '18.222.109.79' [Click To Show]
31 0 SELECT * FROM ipban WHERE ipaddress = '18.222.109.79' [Click To Show]
32 0 SELECT * FROM ipban WHERE ipaddress = '18.222.109.79' [Click To Show]
33 0 SELECT * FROM ipban WHERE ipaddress LIKE '%*%' AND (exptime > '1729591234' OR exptime = '0') [Click To Show]
34 0 SELECT * FROM members WHERE member_id = '1' [Click To Show]
35 0 SELECT * FROM members WHERE member_id = '1' [Click To Show]
36 0 SELECT * FROM members WHERE member_id = '1' [Click To Show]
37 0 SELECT * FROM members WHERE username = '' [Click To Show]
38 0 SELECT * FROM members WHERE username = '' [Click To Show]
39 0 SELECT * FROM membersonlypage WHERE pageurl = 'zarksfallenangels.com/top-players/game.php?gID=5' [Click To Show]
40 0 SELECT * FROM menu_category [Click To Show]
41 0 SELECT * FROM menu_item [Click To Show]
42 0 SELECT * FROM menuitem_custompage WHERE menucustompage_id = '10' [Click To Show]
43 0 SELECT * FROM menuitem_custompage WHERE menucustompage_id = '11' [Click To Show]
44 0 SELECT * FROM menuitem_link [Click To Show]
45 0 SELECT * FROM menuitem_shoutbox WHERE menushoutbox_id = '1' [Click To Show]
46 0 SELECT * FROM news WHERE newstype = '3' ORDER BY dateposted [Click To Show]
47 0 SELECT * FROM plugin_pages WHERE page = 'mods' ORDER BY sortnum [Click To Show]
48 0 SELECT * FROM polls WHERE poll_id = '1' [Click To Show]
49 0 SELECT * FROM rank_privileges [Click To Show]
50 0 SELECT * FROM rankcategory [Click To Show]
51 0 SELECT * FROM ranks [Click To Show]
52 0 SELECT clock_id FROM clocks ORDER BY ordernum DESC [Click To Show]
53 0 SELECT forumpost_id FROM forum_post ORDER BY dateposted DESC [Click To Show]
54 0 SELECT gamesplayed_members.member_id FROM gamesplayed_members, members WHERE gamesplayed_members.member_id = members.member_id AND gamesplayed_members.gamesplayed_id = '5' AND members.disabled = '0' [Click To Show]
55 0 SELECT member_id FROM members WHERE rank_id != '1' AND disabled = '0' ORDER BY datejoined DESC LIMIT 5 [Click To Show]
56 0 SELECT menucategory_id FROM menu_category WHERE (accesstype = '0' OR accesstype = '2') AND hide = '0' AND section = '0' ORDER BY sortnum [Click To Show]
57 0 SELECT menucategory_id FROM menu_category WHERE (accesstype = '0' OR accesstype = '2') AND hide = '0' AND section = '1' ORDER BY sortnum [Click To Show]
58 0 SELECT menucategory_id FROM menu_category WHERE (accesstype = '0' OR accesstype = '2') AND hide = '0' AND section = '2' ORDER BY sortnum [Click To Show]
59 0 SELECT menuitem_id FROM menu_item WHERE (accesstype = '0' OR accesstype = '2') AND hide = '0' AND menucategory_id = '1' ORDER BY sortnum [Click To Show]
60 0 SELECT menuitem_id FROM menu_item WHERE (accesstype = '0' OR accesstype = '2') AND hide = '0' AND menucategory_id = '16' ORDER BY sortnum [Click To Show]
61 0 SELECT menuitem_id FROM menu_item WHERE (accesstype = '0' OR accesstype = '2') AND hide = '0' AND menucategory_id = '17' ORDER BY sortnum [Click To Show]
62 0 SELECT menuitem_id FROM menu_item WHERE (accesstype = '0' OR accesstype = '2') AND hide = '0' AND menucategory_id = '24' ORDER BY sortnum [Click To Show]
63 0 SELECT menuitem_id FROM menu_item WHERE (accesstype = '0' OR accesstype = '2') AND hide = '0' AND menucategory_id = '29' ORDER BY sortnum [Click To Show]
64 0 SELECT menuitem_id FROM menu_item WHERE (accesstype = '0' OR accesstype = '2') AND hide = '0' AND menucategory_id = '4' ORDER BY sortnum [Click To Show]
65 0 SELECT menuitem_id FROM menu_item WHERE (accesstype = '0' OR accesstype = '2') AND hide = '0' AND menucategory_id = '5' ORDER BY sortnum [Click To Show]
66 0 SELECT tablename FROM tableupdates WHERE tablename = 'hitcounter' [Click To Show]
67 0 UPDATE tableupdates SET updatetime = '1729591234' WHERE tablename = 'hitcounter' [Click To Show]