Navigation
Information
Notifcations
Filter Your Notifications
Notifications
Type
Details
Date
Related Content
Content Coming Soon
Extend Song
Stats & Leaderboard
Request A Song
Schedule
Answer Game Trivia
Radio Stream
Veto Song
Song History
User Notice Footer
Vizzed.com © was created, designed, coded by & is property of: David Auchampach. All Rights Reserved 2002 - 2018.
Ads:Exponential
Page rendered in 0.073 seconds. Total queries executed: 63 - Failed Queries: 5
Only Bad Queries | Only Good Queries | Bad and Good Queries || Only Mediam Queries | Only Slow Queries | Fast and Slow Queries
Ads:Exponential
Page rendered in 0.073 seconds. Total queries executed: 63 - Failed Queries: 5
Only Bad Queries | Only Good Queries | Bad and Good Queries || Only Mediam Queries | Only Slow Queries | Fast and Slow Queries
Good Query! (1) Render Time: 0.002 Very Fast
Rows Found: - Result Details: mysqli_result Object
(
[current_field] => 0
[field_count] => 21
[lengths] =>
[num_rows] => 1
[type] => 0
)
SELECT *
FROM page
LEFT JOIN page_statistics ON page_statistics.page_id = id
WHERE url = "/user/notifications.php"
/*()*/
Good Query! (2) Render Time: 0.002 Very Fast
Rows Found: - Result Details: mysqli_result Object
(
[current_field] => 0
[field_count] => 12
[lengths] =>
[num_rows] => 1
[type] => 0
)
SELECT id, url, url_format, directory_id, page_order, update_date, update_users, last_users, views_today, parent_id, directory_id, theme_id
FROM page
INNER JOIN page_statistics ON page_statistics.page_id = id
WHERE id=139816
/*()*/
Good Query! (3) Render Time: 0.000 Extremely Fast
Rows Found: - Result Details: 1
/* get_browser Start /* /*()*/
Good Query! (4) Render Time: 0.000 Extremely Fast
Rows Found: - Result Details: 1
/* get_browser End /* /*()*/
Good Query! (5) Render Time: 0.000 Extremely Fast
Rows Found: - Result Details: mysqli_result Object
(
[current_field] => 0
[field_count] => 1
[lengths] =>
[num_rows] => 1
[type] => 0
)
SELECT count(*) FROM ipbans WHERE INSTR('XXXXXXXXXXXXXXXXX',ip)=1 /*()*/
Good Query! (6) Render Time: 0.000 Extremely Fast
Rows Found: - Result Details: mysqli_result Object
(
[current_field] => 0
[field_count] => 1
[lengths] =>
[num_rows] => 1
[type] => 0
)
SELECT count(*) FROM ipbans WHERE INSTR('XXXXXXXXXXXXXXXXX',ip)=1 /*()*/
Good Query! (7) Render Time: 0.000 Extremely Fast
Rows Found: - Result Details: mysqli_result Object
(
[current_field] => 0
[field_count] => 1
[lengths] =>
[num_rows] => 1
[type] => 0
)
SELECT count(*) FROM ipbans WHERE INSTR('18.210.28.227',ip)=1 /*()*/
Good Query! (8) Render Time: 0.000 Extremely Fast
Rows Found: - Result Details: mysqli_result Object
(
[current_field] => 0
[field_count] => 1
[lengths] =>
[num_rows] => 2
[type] => 0
)
SELECT ip FROM logs_11_21_19 ORDER BY id DESC LIMIT 2 /*()*/
Good Query! (9) Render Time: 0.000 Extremely Fast
Rows Found: - Result Details: mysqli_result Object
(
[current_field] => 0
[field_count] => 1
[lengths] =>
[num_rows] => 1
[type] => 0
)
SELECT id
FROM vizzed_logs.log_ip
WHERE ip=INET_ATON('18.210.28.227')
/*()*/
Good Query! (10) Render Time: 0.001 Very Fast
Rows Found: - Result Details: mysqli_result Object
(
[current_field] => 0
[field_count] => 1
[lengths] =>
[num_rows] => 1
[type] => 0
)
SELECT count(*) AS total
FROM vizzed_logs.log_2019_11_21
WHERE ip_id=1629405
AND date > 1574322425 - 3
/*()*/
Good Query! (11) Render Time: 0.001 Very Fast
Rows Found: - Result Details: mysqli_result Object
(
[current_field] => 0
[field_count] => 1
[lengths] =>
[num_rows] => 1
[type] => 0
)
SELECT count(*) AS total
FROM vizzed_logs.log_2019_11_21
WHERE ip_id=1629405
AND date > 1574322425 - 60
/*()*/
Good Query! (12) Render Time: 0.000 Extremely Fast
Rows Found: - Result Details: mysqli_result Object
(
[current_field] => 0
[field_count] => 1
[lengths] =>
[num_rows] => 1
[type] => 0
)
SELECT id
FROM log_2019_11_21
LIMIT 1
/*()*/
Good Query! (13) Render Time: 0.000 Extremely Fast
Rows Found: - Result Details: mysqli_result Object
(
[current_field] => 0
[field_count] => 5
[lengths] =>
[num_rows] => 1
[type] => 0
)
SELECT *
FROM log_ip
WHERE ip=INET_ATON('18.210.28.227')
/*()*/
Good Query! (14) Render Time: 0.000 Extremely Fast
Rows Found: - Result Details: mysqli_result Object
(
[current_field] => 0
[field_count] => 5
[lengths] =>
[num_rows] => 1
[type] => 0
)
SELECT *
FROM log_browser
WHERE browser_details='CCBot/2.0 (https://commoncrawl.org/faq/)'
/*()*/
Good Query! (15) Render Time: 0.000 Extremely Fast
Rows Found: - Result Details: mysqli_result Object
(
[current_field] => 0
[field_count] => 2
[lengths] =>
[num_rows] => 1
[type] => 0
)
SELECT *
FROM log_device
WHERE device='unknown'
/*()*/
Good Query! (16) Render Time: 0.000 Extremely Fast
Rows Found: - Result Details: mysqli_result Object
(
[current_field] => 0
[field_count] => 2
[lengths] =>
[num_rows] => 1
[type] => 0
)
SELECT *
FROM log_os
WHERE os='unknown'
/*()*/
Good Query! (17) Render Time: 0.001 Very Fast
Rows Found: - Result Details: 1
INSERT INTO log_2019_11_21(
user_id,
ip_id,
page_id,
browser_id,
device_id,
os_id,
unique_id,
security,
date
) VALUES(
'',
'1629405',
'965438',
'23586',
'2',
'2',
'70706206',
'',
1574322425
)
/*()*/
Good Query! (18) Render Time: 0.000 Extremely Fast
Rows Found: - Result Details: 1
INSERT INTO log_2019_11_21_details(
log_id,
url,
title,
referral_url,
variables_post,
variables_get
) VALUES(
19641,
'//www.vizzed.com/user/notifications.php',
'Notifcations',
'',
'',
''
)
/*()*/
Good Query! (19) Render Time: 0.000 Extremely Fast
Rows Found: - Result Details: mysqli_result Object
(
[current_field] => 0
[field_count] => 11
[lengths] =>
[num_rows] => 1
[type] => 0
)
SELECT * FROM boardconfig /*()*/
Good Query! (20) Render Time: 0.000 Extremely Fast
Rows Found: - Result Details: mysqli_result Object
(
[current_field] => 0
[field_count] => 5
[lengths] =>
[num_rows] => 0
[type] => 0
)
SELECT name,posts,sex,powerlevel,id FROM users,postradar WHERE postradar.user=0 AND users.id=postradar.comp ORDER BY posts DESC /*()*/
Good Query! (21) Render Time: 0.000 Extremely Fast
Rows Found: - Result Details: mysqli_result Object
(
[current_field] => 0
[field_count] => 12
[lengths] =>
[num_rows] => 26
[type] => 0
)
SELECT *
FROM users_group
INNER JOIN users_group_user ON users_group_user.group_id = users_group.id
WHERE type=8
/*()*/
Good Query! (22) Render Time: 0.000 Extremely Fast
Rows Found: - Result Details: mysqli_result Object
(
[current_field] => 0
[field_count] => 4
[lengths] =>
[num_rows] => 34
[type] => 0
)
SELECT *
FROM users_customization
/*()*/
Good Query! (23) Render Time: 0.000 Extremely Fast
Rows Found: - Result Details: mysqli_result Object
(
[current_field] => 0
[field_count] => 11
[lengths] =>
[num_rows] => 0
[type] => 0
)
SELECT * FROM tourdevizzedmonthly WHERE year=2019 AND month=10 /*()*/
Good Query! (24) Render Time: 0.000 Extremely Fast
Rows Found: - Result Details: mysqli_result Object
(
[current_field] => 0
[field_count] => 1
[lengths] =>
[num_rows] => 1
[type] => 0
)
SELECT id FROM page_content WHERE widget LIKE '%notifications.php' /*()*/
Good Query! (26) Render Time: 0.001 Very Fast
Rows Found: - Result Details: 1
INSERT INTO
vizzed_logs.log_queries_bad
(log_table,log_id,query)
VALUES
('log_2019_11_21','19641','
UPDATE users_last
SET lastreadnotifications=1574322425
WHERE user_id=
/*()*/ ')
/*()*/
Bad Query! (26) Render Time: 0.000 Extremely Fast
UPDATE users_last
SET lastreadnotifications=1574322425
WHERE user_id=
/*()*/
Good Query! (28) Render Time: 0.000 Extremely Fast
Rows Found: - Result Details: 1
INSERT INTO
vizzed_logs.log_queries_bad
(log_table,log_id,query)
VALUES
('log_2019_11_21','19641','
SELECT distinct type, COUNT(type) as total
FROM notifications
WHERE userid=
GROUP BY type
ORDER BY type ASC
/*()*/ ')
/*()*/
Bad Query! (28) Render Time: 0.000 Extremely Fast
SELECT distinct type, COUNT(type) as total
FROM notifications
WHERE userid=
GROUP BY type
ORDER BY type ASC
/*()*/
Good Query! (30) Render Time: 0.000 Extremely Fast
Rows Found: - Result Details: 1
INSERT INTO
vizzed_logs.log_queries_bad
(log_table,log_id,query)
VALUES
('log_2019_11_21','19641','
SELECT MAX(total) AS max_total, MIN(total) AS min_total, AVG(total) AS avg_total
FROM
(
SELECT distinct type, COUNT(type) as total
FROM notifications
WHERE userid=
GROUP BY type
) AS counts
/*()*/ ')
/*()*/
Bad Query! (30) Render Time: 0.000 Extremely Fast
SELECT MAX(total) AS max_total, MIN(total) AS min_total, AVG(total) AS avg_total
FROM
(
SELECT distinct type, COUNT(type) as total
FROM notifications
WHERE userid=
GROUP BY type
) AS counts
/*()*/
Good Query! (32) Render Time: 0.000 Extremely Fast
Rows Found: - Result Details: 1
INSERT INTO
vizzed_logs.log_queries_bad
(log_table,log_id,query)
VALUES
('log_2019_11_21','19641','
SELECT *
FROM notifications
WHERE userid=
ORDER BY date DESC
/*()*/ ')
/*()*/
Bad Query! (32) Render Time: 0.000 Extremely Fast
SELECT *
FROM notifications
WHERE userid=
ORDER BY date DESC
/*()*/
Good Query! (34) Render Time: 0.000 Extremely Fast
Rows Found: - Result Details: 1
INSERT INTO
vizzed_logs.log_queries_bad
(log_table,log_id,query)
VALUES
('log_2019_11_21','19641','
DELETE FROM notifications
WHERE date <
(SELECT MIN(y.date) FROM
(SELECT date FROM notifications
WHERE userid =
ORDER BY date DESC LIMIT 250) as y)
AND userid =
/*()*/ ')
/*()*/
Bad Query! (34) Render Time: 0.000 Extremely Fast
DELETE FROM notifications
WHERE date <
(SELECT MIN(y.date) FROM
(SELECT date FROM notifications
WHERE userid =
ORDER BY date DESC LIMIT 250) as y)
AND userid =
/*()*/
Good Query! (35) Render Time: 0.001 Very Fast
Rows Found: - Result Details: 1
UPDATE page_statistics SET views_today=views_today+1, views=views+1 WHERE page_id=965438 /*()*/
Good Query! (36) Render Time: 0.002 Very Fast
Rows Found: - Result Details: mysqli_result Object
(
[current_field] => 0
[field_count] => 22
[lengths] =>
[num_rows] => 98
[type] => 0
)
SELECT *
FROM `page_variable_list`
WHERE (page_id=0 OR page_id=965438 OR page_id=965438 OR page_id=139816)
ORDER BY
page_id <> '' DESC,
category = 'Page Meta' DESC,
category = 'Page Look' DESC,
category = 'Page Detailed' DESC,
category = 'Content Disabling' ASC,
category ASC,
variableOrder ASC,
name ASC
/*()*/
Good Query! (37) Render Time: 0.000 Extremely Fast
Rows Found: - Result Details: mysqli_result Object
(
[current_field] => 0
[field_count] => 3
[lengths] =>
[num_rows] => 42
[type] => 0
)
SELECT * FROM `page_variables_theme_variables` WHERE page_variables_theme_id=1 /*()*/
Good Query! (38) Render Time: 0.000 Extremely Fast
Rows Found: - Result Details: mysqli_result Object
(
[current_field] => 0
[field_count] => 3
[lengths] =>
[num_rows] => 3
[type] => 0
)
SELECT * FROM `page_variables` WHERE page_id=139816 /*()*/
Good Query! (39) Render Time: 0.000 Extremely Fast
Rows Found: - Result Details: mysqli_result Object
(
[current_field] => 0
[field_count] => 3
[lengths] =>
[num_rows] => 0
[type] => 0
)
SELECT * FROM `page_variables` WHERE page_id=965438 /*()*/
Good Query! (40) Render Time: 0.000 Extremely Fast
Rows Found: - Result Details: mysqli_result Object
(
[current_field] => 0
[field_count] => 3
[lengths] =>
[num_rows] => 0
[type] => 0
)
SELECT * FROM `page_variables` WHERE page_id=965438 /*()*/
Good Query! (41) Render Time: 0.000 Extremely Fast
Rows Found: - Result Details: mysqli_result Object
(
[current_field] => 0
[field_count] => 1
[lengths] =>
[num_rows] => 1
[type] => 0
)
SELECT COUNT(id) as total
FROM page_content
WHERE cantremovefrompage=965438
/*()*/
Good Query! (42) Render Time: 0.001 Very Fast
Rows Found: - Result Details: mysqli_result Object
(
[current_field] => 0
[field_count] => 1
[lengths] =>
[num_rows] => 1
[type] => 0
)
SELECT id FROM guests WHERE ip = '18.210.28.227' ORDER BY date DESC LIMIT 1 /*()*/
Good Query! (43) Render Time: 0.001 Very Fast
Rows Found: - Result Details: 1
UPDATE guests SET date=1574322425, last_page_id=965438,last_parent_id=965438,last_directory_id=139816 WHERE ip = '18.210.28.227' /*()*/
Good Query! (44) Render Time: 0.000 Extremely Fast
Rows Found: - Result Details: mysqli_result Object
(
[current_field] => 0
[field_count] => 2
[lengths] =>
[num_rows] => 0
[type] => 0
)
SELECT allkeywords,id FROM page_indexes WHERE url='/user/notifications.php' /*()*/
Good Query! (45) Render Time: 0.000 Extremely Fast
Rows Found: - Result Details: mysqli_result Object
(
[current_field] => 0
[field_count] => 3
[lengths] =>
[num_rows] => 0
[type] => 0
)
SELECT distinct keywords, SUM(total) as counttotal, searchengine FROM searchkeywords WHERE url='/user/notifications.php' AND keywords <> '' GROUP BY keywords ORDER BY counttotal DESC, date DESC LIMIT 10 /*()*/
Good Query! (46) Render Time: 0.001 Very Fast
Rows Found: - Result Details: mysqli_result Object
(
[current_field] => 0
[field_count] => 1
[lengths] =>
[num_rows] => 2
[type] => 0
)
SELECT views FROM misc /*()*/
Good Query! (47) Render Time: 0.001 Very Fast
Rows Found: - Result Details: 1
UPDATE misc SET views=2536883224 /*()*/
Good Query! (48) Render Time: 0.003 Very Fast
Rows Found: - Result Details: mysqli_result Object
(
[current_field] => 0
[field_count] => 12
[lengths] =>
[num_rows] => 120
[type] => 0
)
SELECT page.*
FROM `page`
INNER JOIN page_statistics ON page_statistics.page_id = page.id
WHERE page_order = 3
ORDER BY views_today DESC
/*()*/
Good Query! (49) Render Time: 0.003 Very Fast
Rows Found: - Result Details: mysqli_result Object
(
[current_field] => 0
[field_count] => 12
[lengths] =>
[num_rows] => 10
[type] => 0
)
SELECT page.*
FROM `page`
INNER JOIN page_statistics ON page_statistics.page_id = page.id
WHERE page_order <= 3
ORDER BY page.id=2 DESC, page.id=3 DESC, page.id=7 DESC, page.id=8 DESC, page.id=141056 DESC, page.id=290325 DESC, page.id=817112 DESC, page.id=139840 DESC, page.id=980494 DESC, page.id=270457 DESC, page_order DESC, views DESC
LIMIT 10
/*()*/
Good Query! (50) Render Time: 0.000 Extremely Fast
Rows Found: - Result Details: mysqli_result Object
(
[current_field] => 0
[field_count] => 1
[lengths] =>
[num_rows] => 5
[type] => 0
)
SELECT title
FROM announcements
ORDER BY date DESC
LIMIT 5
/*()*/
Good Query! (51) Render Time: 0.002 Very Fast
Rows Found: - Result Details: mysqli_result Object
(
[current_field] => 0
[field_count] => 1
[lengths] =>
[num_rows] => 1
[type] => 0
)
SELECT COUNT(*) as total
FROM users_last
WHERE lastactivity >= 1574322425-900 AND last_page_id=965438
/*()*/
Good Query! (52) Render Time: 0.002 Very Fast
Rows Found: - Result Details: mysqli_result Object
(
[current_field] => 0
[field_count] => 1
[lengths] =>
[num_rows] => 1
[type] => 0
)
SELECT id FROM guests WHERE date >= 1574322425-900 AND last_page_id=965438 /*()*/
Good Query! (53) Render Time: 0.001 Very Fast
Rows Found: - Result Details: mysqli_result Object
(
[current_field] => 0
[field_count] => 1
[lengths] =>
[num_rows] => 1
[type] => 0
)
SELECT COUNT(*) as total
FROM users_last
WHERE lastactivity >= 1574322425-900 AND (last_directory_id=139816 OR last_page_id=139816)
/*()*/
Good Query! (54) Render Time: 0.002 Very Fast
Rows Found: - Result Details: mysqli_result Object
(
[current_field] => 0
[field_count] => 1
[lengths] =>
[num_rows] => 4
[type] => 0
)
SELECT id FROM guests WHERE date >= 1574322425-900 AND (last_directory_id=139816 OR last_page_id=139816) /*()*/
Good Query! (55) Render Time: 0.002 Very Fast
Rows Found: - Result Details: mysqli_result Object
(
[current_field] => 0
[field_count] => 1
[lengths] =>
[num_rows] => 1
[type] => 0
)
SELECT COUNT(*) as total
FROM users_last
WHERE lastactivity >= 1574322425-900
/*()*/
Good Query! (56) Render Time: 0.002 Very Fast
Rows Found: - Result Details: mysqli_result Object
(
[current_field] => 0
[field_count] => 1
[lengths] =>
[num_rows] => 1
[type] => 0
)
SELECT COUNT(*) as total
FROM guests
WHERE date >= 1574322425-900
/*()*/
Good Query! (57) Render Time: 0.001 Very Fast
Rows Found: - Result Details: mysqli_result Object
(
[current_field] => 0
[field_count] => 11
[lengths] =>
[num_rows] => 1
[type] => 0
)
SELECT users.id as userid, users.picture as userpic, users_last.last_invizection , users.birthday as userbirthday, users.name as username, users.regdate as userregdate, users.posts as userposts, users.sex as usersex, users.powerlevel as userpowerlevel, users.postsToday as userpostsToday, users.picture as userpic
FROM users
LEFT JOIN users_last ON users_last.user_id = users.id
WHERE lastactivity >= 1574322425-900 AND last_page_id=965438
ORDER BY lastactivity DESC
/*()*/
Good Query! (58) Render Time: 0.000 Extremely Fast
Rows Found: - Result Details: mysqli_result Object
(
[current_field] => 0
[field_count] => 12
[lengths] =>
[num_rows] => 0
[type] => 0
)
SELECT page_admin.power, users_group.name as group_name, group_id, user_id as userid , users.birthday as userbirthday, users.name as username, users.regdate as userregdate, users.posts as userposts, users.sex as usersex, users.powerlevel as userpowerlevel, users.postsToday as userpostsToday, users.picture as userpic
FROM `page_admin`
LEFT JOIN users ON users.id=page_admin.user_id
LEFT JOIN users_group ON users_group.id=page_admin.group_id
WHERE page_id=965438 OR page_id=139816 OR page_id=965438
ORDER BY power DESC
/*()*/
Good Query! (59) Render Time: 0.000 Extremely Fast
Rows Found: - Result Details: mysqli_result Object
(
[current_field] => 0
[field_count] => 12
[lengths] =>
[num_rows] => 12
[type] => 0
)
SELECT *
FROM page
WHERE page_order <= 2
ORDER BY page_order ASC, page_title ASC
/*()*/
Good Query! (60) Render Time: 0.000 Extremely Fast
Rows Found: - Result Details: mysqli_result Object
(
[current_field] => 0
[field_count] => 5
[lengths] =>
[num_rows] => 15
[type] => 0
)
SELECT id, url, page_order, page_title, page_title_short
FROM page
WHERE (parent_id=965438 OR directory_id=965438 OR id=965438 OR id=139816 OR parent_id=965438 OR (directory_id=139816 AND directory_id <> 2) ) AND page_order <= 3
ORDER BY id = 139816 DESC, page_order ASC, page_title ASC
/*()*/
Good Query! (61) Render Time: 0.000 Extremely Fast
Rows Found: - Result Details: mysqli_result Object
(
[current_field] => 0
[field_count] => 50
[lengths] =>
[num_rows] => 0
[type] => 0
)
SELECT *, page_content_url.id as page_content_url_id
FROM page_content_url
LEFT JOIN page_content ON page_content.id = page_content_url.page_content_id
WHERE page_id = 965438
ORDER BY page_content_order ASC
/*()*/
Good Query! (62) Render Time: 0.000 Extremely Fast
Rows Found: - Result Details: mysqli_result Object
(
[current_field] => 0
[field_count] => 1
[lengths] =>
[num_rows] => 1
[type] => 0
)
SELECT id
FROM log_2019_11_21
LIMIT 1
/*()*/
Good Query! (63) Render Time: 0.001 Very Fast
Rows Found: - Result Details: 1
UPDATE log_2019_11_21
SET
rendered='73',
queries='62',
queries_slow='',
queries_errors='5'
WHERE id=19641
/*()*/
