Navigation
Information
Search
Search functionality coming soon
Search Results
Related Content
Content Coming Soon
Song History
Radio Stream
Extend Song
Request A Song
Answer Game Trivia
Stats & Leaderboard
Schedule
Veto Song
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.090 seconds. Total queries executed: 53 - Failed Queries: 1
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.090 seconds. Total queries executed: 53 - Failed Queries: 1
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.001 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 = "/search.php"
/*()*/
Good Query! (2) Render Time: 0.001 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=2
/*()*/
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.206.194.210',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_13_19 ORDER BY id DESC LIMIT 2 /*()*/
Good Query! (9) 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 vizzed_logs.log_ip
WHERE ip=INET_ATON('18.206.194.210')
/*()*/
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_13
WHERE ip_id=1574711
AND date > 1573685641 - 3
/*()*/
Good Query! (11) 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 vizzed_logs.log_2019_11_13
WHERE ip_id=1574711
AND date > 1573685641 - 60
/*()*/
Good Query! (12) 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 log_2019_11_13
LIMIT 1
/*()*/
Good Query! (13) Render Time: 0.001 Very 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.206.194.210')
/*()*/
Good Query! (14) Render Time: 0.001 Very 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.000 Extremely Fast
Rows Found: - Result Details: 1
INSERT INTO log_2019_11_13(
user_id,
ip_id,
page_id,
browser_id,
device_id,
os_id,
unique_id,
security,
date
) VALUES(
'',
'1574711',
'11',
'23586',
'2',
'2',
'77782430',
'',
1573685641
)
/*()*/
Good Query! (18) Render Time: 0.000 Extremely Fast
Rows Found: - Result Details: 1
INSERT INTO log_2019_11_13_details(
log_id,
url,
title,
referral_url,
variables_post,
variables_get
) VALUES(
240921,
'//www.vizzed.com/search.php',
'Search',
'',
'',
''
)
/*()*/
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] => 0
[type] => 0
)
SELECT id FROM page_content WHERE widget LIKE '%search.php' /*()*/
Good Query! (26) 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_13','240921','
SELECT *
FROM (
SELECT page.*,
MATCH(page.page_title) AGAINST(\'\"\"\' IN BOOLEAN MODE) +
MATCH(directory.page_title) AGAINST(\'*\' IN BOOLEAN MODE) +
MATCH(parent.page_title) AGAINST(\'*\' IN BOOLEAN MODE) +
MATCH(page.page_title) AGAINST(\'*\' IN BOOLEAN MODE) AS relevance,
directory.url AS directory_url, directory.page_title AS directory_title,
parent.url AS parent_url, parent.page_title AS parent_title
FROM page
INNER JOIN page AS directory ON directory.id = page.directory_id
INNER JOIN page AS parent ON parent.id = page.parent_id
INNER JOIN page_statistics ON page_statistics.page_id = page.id
WHERE
MATCH(page.page_title) AGAINST(\'*\' IN BOOLEAN MODE)
ORDER BY
relevance DESC, page_statistics.views_today DESC
LIMIT 50
) as results
ORDER BY directory_title ASC, parent_title ASC, relevance DESC, page_title ASC
/*()*/ ')
/*()*/
Bad Query! (26) Render Time: 0.002 Very Fast
SELECT *
FROM (
SELECT page.*,
MATCH(page.page_title) AGAINST('""' IN BOOLEAN MODE) +
MATCH(directory.page_title) AGAINST('*' IN BOOLEAN MODE) +
MATCH(parent.page_title) AGAINST('*' IN BOOLEAN MODE) +
MATCH(page.page_title) AGAINST('*' IN BOOLEAN MODE) AS relevance,
directory.url AS directory_url, directory.page_title AS directory_title,
parent.url AS parent_url, parent.page_title AS parent_title
FROM page
INNER JOIN page AS directory ON directory.id = page.directory_id
INNER JOIN page AS parent ON parent.id = page.parent_id
INNER JOIN page_statistics ON page_statistics.page_id = page.id
WHERE
MATCH(page.page_title) AGAINST('*' IN BOOLEAN MODE)
ORDER BY
relevance DESC, page_statistics.views_today DESC
LIMIT 50
) as results
ORDER BY directory_title ASC, parent_title ASC, relevance DESC, page_title ASC
/*()*/
Good Query! (27) 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=11 /*()*/
Good Query! (28) Render Time: 0.002 Very Fast
Rows Found: - Result Details: mysqli_result Object
(
[current_field] => 0
[field_count] => 22
[lengths] =>
[num_rows] => 62
[type] => 0
)
SELECT *
FROM `page_variable_list`
WHERE (page_id=0 OR page_id=11 OR page_id=11 OR page_id=2)
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! (29) 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! (30) 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=2 /*()*/
Good Query! (31) Render Time: 0.000 Extremely Fast
Rows Found: - Result Details: mysqli_result Object
(
[current_field] => 0
[field_count] => 3
[lengths] =>
[num_rows] => 1
[type] => 0
)
SELECT * FROM `page_variables` WHERE page_id=11 /*()*/
Good Query! (32) Render Time: 0.000 Extremely Fast
Rows Found: - Result Details: mysqli_result Object
(
[current_field] => 0
[field_count] => 3
[lengths] =>
[num_rows] => 1
[type] => 0
)
SELECT * FROM `page_variables` WHERE page_id=11 /*()*/
Good Query! (33) 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=11
/*()*/
Good Query! (34) 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.206.194.210' ORDER BY date DESC LIMIT 1 /*()*/
Good Query! (35) Render Time: 0.003 Very Fast
Rows Found: - Result Details: 1
UPDATE guests SET date=1573685641, last_page_id=11,last_parent_id=11,last_directory_id=2 WHERE ip = '18.206.194.210' /*()*/
Good Query! (36) Render Time: 0.001 Very Fast
Rows Found: - Result Details: mysqli_result Object
(
[current_field] => 0
[field_count] => 2
[lengths] =>
[num_rows] => 1
[type] => 0
)
SELECT allkeywords,id FROM page_indexes WHERE url='/search.php' /*()*/
Good Query! (37) 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! (38) Render Time: 0.001 Very Fast
Rows Found: - Result Details: 1
UPDATE misc SET views=2534660832 /*()*/
Good Query! (39) 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! (40) 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! (41) 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! (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 COUNT(*) as total
FROM users_last
WHERE lastactivity >= 1573685641-900 AND last_page_id=11
/*()*/
Good Query! (43) 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 date >= 1573685641-900 AND last_page_id=11 /*()*/
Good Query! (44) 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(*) as total
FROM users_last
WHERE lastactivity >= 1573685641-900 AND (last_directory_id=2 OR last_page_id=2)
/*()*/
Good Query! (45) Render Time: 0.001 Very Fast
Rows Found: - Result Details: mysqli_result Object
(
[current_field] => 0
[field_count] => 1
[lengths] =>
[num_rows] => 139
[type] => 0
)
SELECT id FROM guests WHERE date >= 1573685641-900 AND (last_directory_id=2 OR last_page_id=2) /*()*/
Good Query! (46) 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(*) as total
FROM users_last
WHERE lastactivity >= 1573685641-900
/*()*/
Good Query! (47) 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 guests
WHERE date >= 1573685641-900
/*()*/
Good Query! (48) Render Time: 0.002 Very 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=11 OR page_id=2 OR page_id=11
ORDER BY power DESC
/*()*/
Good Query! (49) 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! (50) Render Time: 0.000 Extremely Fast
Rows Found: - Result Details: mysqli_result Object
(
[current_field] => 0
[field_count] => 5
[lengths] =>
[num_rows] => 2
[type] => 0
)
SELECT id, url, page_order, page_title, page_title_short
FROM page
WHERE (parent_id=11 OR directory_id=11 OR id=11 OR id=2 OR parent_id=11 OR (directory_id=2 AND directory_id <> 2) ) AND page_order <= 3
ORDER BY id = 2 DESC, page_order ASC, page_title ASC
/*()*/
Good Query! (51) 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 = 11
ORDER BY page_content_order ASC
/*()*/
Good Query! (52) 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 log_2019_11_13
LIMIT 1
/*()*/
Good Query! (53) Render Time: 0.001 Very Fast
Rows Found: - Result Details: 1
UPDATE log_2019_11_13
SET
rendered='90',
queries='52',
queries_slow='',
queries_errors='1'
WHERE id=240921
/*()*/
