Commodore Amiga Video Games

Footer

Vizzed.com © was created, designed, coded by & is property of: David Auchampach. All Rights Reserved 2002 - 2018.
Ads:Exponential
Page rendered in 0.442 seconds. Total queries executed: 99

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 = "/videogames" /*()*/

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=2 /*()*/

Good Query! (3) Render Time: 0.001 Very 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('34.237.51.35',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_18_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('34.237.51.35') /*()*/

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_18 WHERE ip_id=1623634 AND date > 1574134531 - 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_18 WHERE ip_id=1623634 AND date > 1574134531 - 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_18 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('34.237.51.35') /*()*/

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.001 Very Fast

Rows Found: - Result Details: 1

INSERT INTO log_2019_11_18( user_id, ip_id, page_id, browser_id, device_id, os_id, unique_id, security, date ) VALUES( '', '1623634', '8', '23586', '2', '2', '82281494', '', 1574134531 ) /*()*/

Good Query! (18) Render Time: 0.000 Extremely Fast

Rows Found: - Result Details: 1

INSERT INTO log_2019_11_18_details( log_id, url, title, referral_url, variables_post, variables_get ) VALUES( 324819, '//www.vizzed.com/videogames/index.php?system=amiga&search=', 'Video Game Room', '', '', '{\"system\":\"amiga\",\"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] => 11 [lengths] => [num_rows] => 78 [type] => 0 )

SELECT type,identifier,systemName,picExt,bgimage,RGRPlugin,abbreviation,added,average_rating,game_total,company FROM game_systems WHERE systemName <> 'Flash' ORDER BY systemName ASC /*()*/

Good Query! (25) 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 searchTitle,japanName,bgimage,identifier,systemName FROM game_systems WHERE identifier='amiga' /*()*/

Good Query! (27) Render Time: 0.001 Very Fast

Rows Found: - Result Details: 1

INSERT INTO vizzed_logs.log_queries_slow (log_table,log_id,query,rendered) VALUES ('log_2019_11_18','324819','SELECT COUNT(game.id) as total FROM game FORCE INDEX (PRIMARY) WHERE active=1 AND game.type<>\'Flash\' AND hackType=\'\' AND system=\'amiga\' /*()*/ ','73') /*()*/

Good Query! (27) Render Time: 0.073 Fast

Rows Found: - Result Details: mysqli_result Object ( [current_field] => 0 [field_count] => 1 [lengths] => [num_rows] => 1 [type] => 0 )

SELECT COUNT(game.id) as total FROM game FORCE INDEX (PRIMARY) WHERE active=1 AND game.type<>'Flash' AND hackType='' AND system='amiga' /*()*/

Good Query! (29) Render Time: 0.000 Extremely Fast

Rows Found: - Result Details: 1

INSERT INTO vizzed_logs.log_queries_slow (log_table,log_id,query,rendered) VALUES ('log_2019_11_18','324819',' SELECT * FROM ( SELECT distinct substring(name,1,1) as letter FROM game WHERE active=1 AND game.type<>\'Flash\' AND hackType=\'\' AND system=\'amiga\' ORDER BY name ) game /*()*/ ','73') /*()*/

Good Query! (29) Render Time: 0.073 Fast

Rows Found: - Result Details: mysqli_result Object ( [current_field] => 0 [field_count] => 1 [lengths] => [num_rows] => 36 [type] => 0 )

SELECT * FROM ( SELECT distinct substring(name,1,1) as letter FROM game WHERE active=1 AND game.type<>'Flash' AND hackType='' AND system='amiga' ORDER BY name ) game /*()*/

Good Query! (31) Render Time: 0.005 Very Fast

Rows Found: - Result Details: 1

INSERT INTO vizzed_logs.log_queries_slow (log_table,log_id,query,rendered) VALUES ('log_2019_11_18','324819',' SELECT * FROM ( SELECT distinct system FROM game WHERE active=1 AND game.type<>\'Flash\' AND hackType=\'\' AND system=\'amiga\' ORDER BY system ) game /*()*/ ','88') /*()*/

Good Query! (31) Render Time: 0.088 Fast

Rows Found: - Result Details: mysqli_result Object ( [current_field] => 0 [field_count] => 1 [lengths] => [num_rows] => 1 [type] => 0 )

SELECT * FROM ( SELECT distinct system FROM game WHERE active=1 AND game.type<>'Flash' AND hackType='' AND system='amiga' ORDER BY system ) game /*()*/

Good Query! (33) Render Time: 0.000 Extremely Fast

Rows Found: - Result Details: 1

INSERT INTO vizzed_logs.log_queries_slow (log_table,log_id,query,rendered) VALUES ('log_2019_11_18','324819',' SELECT game.id,game.name,game.system,game.type,game.systemType ,game_games_stats.rating,game_games_stats.votes,game_games_stats.views,game_games_stats.added FROM ( SELECT game.id FROM game FORCE INDEX (PRIMARY) inner join game_games_stats ON game.id = game_games_stats.game_id WHERE active=1 AND game.type<>\'Flash\' AND hackType=\'\' AND system=\'amiga\' ORDER BY dateReleased DESC LIMIT 0, 48 ) g INNER JOIN game ON game.id = g.id inner join game_games_stats ON game.id = game_games_stats.game_id /*()*/ ','108') /*()*/

Good Query! (33) Render Time: 0.108 Medium

Rows Found: - Result Details: mysqli_result Object ( [current_field] => 0 [field_count] => 9 [lengths] => [num_rows] => 48 [type] => 0 )

SELECT game.id,game.name,game.system,game.type,game.systemType ,game_games_stats.rating,game_games_stats.votes,game_games_stats.views,game_games_stats.added FROM ( SELECT game.id FROM game FORCE INDEX (PRIMARY) inner join game_games_stats ON game.id = game_games_stats.game_id WHERE active=1 AND game.type<>'Flash' AND hackType='' AND system='amiga' ORDER BY dateReleased DESC LIMIT 0, 48 ) g INNER JOIN game ON game.id = g.id inner join game_games_stats ON game.id = game_games_stats.game_id /*()*/

Good Query! (34) Render Time: 0.001 Very Fast

Rows Found: - Result Details: mysqli_result Object ( [current_field] => 0 [field_count] => 5 [lengths] => [num_rows] => 0 [type] => 0 )

SELECT game.id,name,system,gameOfWeek, posts_text.text as text FROM game inner join game_games ON game.id = game_games.id inner join game_games_stats ON game.id = game_games_stats.game_id inner join threads ON threads.id = game_games.staffReviewThreadID inner join posts ON posts.thread=threads.id inner join posts_text ON posts_text.pid=posts.id WHERE (gameOfWeek >= 1573970400 AND gameOfWeek <= 1574134531) OR (gameOfWeek >= 1573970400-(31536000*8) AND gameOfWeek <= (1574134531-31536000*8)) ORDER BY gameOfWeek DESC LIMIT 1 /*()*/

Good Query! (35) 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 game.id,name,system,gameOfDay, posts_text.text as text FROM game inner join game_games ON game.id = game_games.id inner join game_games_stats ON game.id = game_games_stats.game_id inner join threads ON threads.id = game_games.staffReviewThreadID inner join posts ON posts.thread=threads.id inner join posts_text ON posts_text.pid=posts.id WHERE gameOfDay >= 1574048131 AND gameOfDay <= 1574134531 OR gameOfDay >= 1574048131-94608000 AND gameOfDay <= 1574134531-94608000 OR gameOfDay >= 1574048131-94604400 AND gameOfDay <= 1574134531-94604400 OR gameOfDay >= 1574048131-189216000 AND gameOfDay <= 1574134531-189216000 ORDER BY gameOfDay DESC LIMIT 1 /*()*/

Good Query! (36) 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 game_screenshot WHERE removed=0 ORDER BY time DESC LIMIT 1 /*()*/

Good Query! (37) Render Time: 0.000 Extremely Fast

Rows Found: - Result Details: mysqli_result Object ( [current_field] => 0 [field_count] => 10 [lengths] => [num_rows] => 1 [type] => 0 )

SELECT id,birthday,name,regdate,posts,postsToday,sex,powerlevel,picture,last_invizection FROM `users` LEFT JOIN users_last ON users_last.user_id = users.id WHERE `id`='218343' /*()*/

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] => 1 [type] => 0 )

SELECT name,system,esrb FROM game inner join game_games ON game.id = game_games.id WHERE game.id=8933 LIMIT 1 /*()*/

Good Query! (39) Render Time: 0.000 Extremely Fast

Rows Found: - Result Details: mysqli_result Object ( [current_field] => 0 [field_count] => 20 [lengths] => [num_rows] => 1 [type] => 0 )

SELECT * FROM game_video WHERE thumbnail <> '' ORDER BY time DESC LIMIT 1 /*()*/

Good Query! (40) Render Time: 0.000 Extremely Fast

Rows Found: - Result Details: mysqli_result Object ( [current_field] => 0 [field_count] => 10 [lengths] => [num_rows] => 1 [type] => 0 )

SELECT id,birthday,name,regdate,posts,postsToday,sex,powerlevel,picture,last_invizection FROM `users` LEFT JOIN users_last ON users_last.user_id = users.id WHERE `id`='580301' /*()*/

Good Query! (41) 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 name,system,esrb FROM game inner join game_games ON game.id = game_games.id WHERE game.id=86463 LIMIT 1 /*()*/

Good Query! (42) 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 count(userid) as total, chatroomid, name FROM `cometchat_chatrooms` INNER JOIN cometchat_chatrooms_users ON cometchat_chatrooms_users.chatroomid = cometchat_chatrooms.id WHERE cometchat_chatrooms_users.lastactivity > 1574134531-120 AND id > 4 GROUP BY chatroomid ORDER BY total DESC LIMIT 9 /*()*/

Good Query! (43) Render Time: 0.001 Very Fast

Rows Found: - Result Details: mysqli_result Object ( [current_field] => 0 [field_count] => 2 [lengths] => [num_rows] => 0 [type] => 0 )

SELECT a.game_id, b.name FROM game_session a inner join game b ON a.game_id = b.id ORDER BY date_created DESC LIMIT 8 /*()*/

Good Query! (44) Render Time: 0.000 Extremely Fast

Rows Found: - Result Details: mysqli_result Object ( [current_field] => 0 [field_count] => 4 [lengths] => [num_rows] => 2 [type] => 0 )

SELECT game, website, channel, user FROM game_streams WHERE active=1 AND disabled=0 ORDER BY sessiontime DESC, totaltime DESC LIMIT 6 /*()*/

Good Query! (45) Render Time: 0.000 Extremely Fast

Rows Found: - Result Details: mysqli_result Object ( [current_field] => 0 [field_count] => 10 [lengths] => [num_rows] => 1 [type] => 0 )

SELECT id,birthday,name,regdate,posts,postsToday,sex,powerlevel,picture,last_invizection FROM `users` LEFT JOIN users_last ON users_last.user_id = users.id WHERE `id`='485174' /*()*/

Good Query! (46) Render Time: 0.000 Extremely Fast

Rows Found: - Result Details: mysqli_result Object ( [current_field] => 0 [field_count] => 10 [lengths] => [num_rows] => 1 [type] => 0 )

SELECT id,birthday,name,regdate,posts,postsToday,sex,powerlevel,picture,last_invizection FROM `users` LEFT JOIN users_last ON users_last.user_id = users.id WHERE `id`='77686' /*()*/

Good Query! (47) Render Time: 0.000 Extremely Fast

Rows Found: - Result Details: mysqli_result Object ( [current_field] => 0 [field_count] => 17 [lengths] => [num_rows] => 1 [type] => 0 )

SELECT * FROM game_reviews ORDER BY time DESC LIMIT 1 /*()*/

Good Query! (48) Render Time: 0.000 Extremely Fast

Rows Found: - Result Details: mysqli_result Object ( [current_field] => 0 [field_count] => 10 [lengths] => [num_rows] => 1 [type] => 0 )

SELECT id,birthday,name,regdate,posts,postsToday,sex,powerlevel,picture,last_invizection FROM `users` LEFT JOIN users_last ON users_last.user_id = users.id WHERE `id`='108945' /*()*/

Good Query! (49) 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 name,system FROM game WHERE id=115228 LIMIT 1 /*()*/

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] => 1 [type] => 0 )

SELECT * FROM game_shouts ORDER BY time DESC LIMIT 1 /*()*/

Good Query! (51) Render Time: 0.000 Extremely Fast

Rows Found: - Result Details: mysqli_result Object ( [current_field] => 0 [field_count] => 10 [lengths] => [num_rows] => 1 [type] => 0 )

SELECT id,birthday,name,regdate,posts,postsToday,sex,powerlevel,picture,last_invizection FROM `users` LEFT JOIN users_last ON users_last.user_id = users.id WHERE `id`='231620' /*()*/

Good Query! (52) 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 name,system FROM game WHERE id=115385 LIMIT 1 /*()*/

Good Query! (53) Render Time: 0.000 Extremely Fast

Rows Found: - Result Details: mysqli_result Object ( [current_field] => 0 [field_count] => 4 [lengths] => [num_rows] => 5 [type] => 0 )

SELECT description, title, lastpostdate, threads.id FROM `threads` INNER JOIN threads_keywords ON threads_keywords.thread_id = threads.id INNER JOIN keywords ON keywords.id = threads_keywords.keyword_id WHERE forum=81 AND keyword='Retro Game Room' AND closed=0 ORDER BY lastpostdate DESC LIMIT 5 /*()*/

Good Query! (54) Render Time: 0.000 Extremely Fast

Rows Found: - Result Details: mysqli_result Object ( [current_field] => 0 [field_count] => 1 [lengths] => [num_rows] => 10 [type] => 0 )

SELECT keywords FROM `game_searchkeywords_rgrsearch` WHERE keywords NOT LIKE '%sex%' AND keywords NOT LIKE '%fuck%' ORDER BY date DESC LIMIT 10 /*()*/

Good Query! (55) Render Time: 0.002 Very Fast

Rows Found: - Result Details: mysqli_result Object ( [current_field] => 0 [field_count] => 18 [lengths] => [num_rows] => 3 [type] => 0 )

SELECT game_highscore.*, users.birthday, users.name, users.regdate, users.posts, users.sex, users.powerlevel, users.postsToday, users.id as user_id FROM game_highscore inner join users ON game_highscore.user_id = users.id WHERE score > 0 ORDER BY time DESC LIMIT 3 /*()*/

Good Query! (56) 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 name,system FROM game WHERE id = 100747 /*()*/

Good Query! (57) Render Time: 0.000 Extremely Fast

Rows Found: - Result Details: mysqli_result Object ( [current_field] => 0 [field_count] => 10 [lengths] => [num_rows] => 1 [type] => 0 )

SELECT id,birthday,name,regdate,posts,postsToday,sex,powerlevel,picture,last_invizection FROM `users` LEFT JOIN users_last ON users_last.user_id = users.id WHERE `id`='507794' /*()*/

Good Query! (58) 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 name,system FROM game WHERE id = 100747 /*()*/

Good Query! (59) Render Time: 0.000 Extremely Fast

Rows Found: - Result Details: mysqli_result Object ( [current_field] => 0 [field_count] => 10 [lengths] => [num_rows] => 1 [type] => 0 )

SELECT id,birthday,name,regdate,posts,postsToday,sex,powerlevel,picture,last_invizection FROM `users` LEFT JOIN users_last ON users_last.user_id = users.id WHERE `id`='218343' /*()*/

Good Query! (60) 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 name,system FROM game WHERE id = 86183 /*()*/

Good Query! (61) Render Time: 0.000 Extremely Fast

Rows Found: - Result Details: mysqli_result Object ( [current_field] => 0 [field_count] => 10 [lengths] => [num_rows] => 1 [type] => 0 )

SELECT id,birthday,name,regdate,posts,postsToday,sex,powerlevel,picture,last_invizection FROM `users` LEFT JOIN users_last ON users_last.user_id = users.id WHERE `id`='230301' /*()*/

Good Query! (62) Render Time: 0.000 Extremely Fast

Rows Found: - Result Details: mysqli_result Object ( [current_field] => 0 [field_count] => 8 [lengths] => [num_rows] => 3 [type] => 0 )

SELECT game_id,system,name,screenshot,user_id,rank,timetrialtime,comment FROM game_speedruns inner join game ON game_speedruns.game_id = game.id WHERE timetrialtime > 0 ORDER BY time DESC LIMIT 3 /*()*/

Good Query! (63) 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 name,system FROM game WHERE id = 8165 /*()*/

Good Query! (64) Render Time: 0.000 Extremely Fast

Rows Found: - Result Details: mysqli_result Object ( [current_field] => 0 [field_count] => 10 [lengths] => [num_rows] => 1 [type] => 0 )

SELECT id,birthday,name,regdate,posts,postsToday,sex,powerlevel,picture,last_invizection FROM `users` LEFT JOIN users_last ON users_last.user_id = users.id WHERE `id`='155101' /*()*/

Good Query! (65) 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 name,system FROM game WHERE id = 69789 /*()*/

Good Query! (66) Render Time: 0.000 Extremely Fast

Rows Found: - Result Details: mysqli_result Object ( [current_field] => 0 [field_count] => 10 [lengths] => [num_rows] => 1 [type] => 0 )

SELECT id,birthday,name,regdate,posts,postsToday,sex,powerlevel,picture,last_invizection FROM `users` LEFT JOIN users_last ON users_last.user_id = users.id WHERE `id`='155101' /*()*/

Good Query! (67) 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 name,system FROM game WHERE id = 238 /*()*/

Good Query! (68) Render Time: 0.000 Extremely Fast

Rows Found: - Result Details: mysqli_result Object ( [current_field] => 0 [field_count] => 10 [lengths] => [num_rows] => 1 [type] => 0 )

SELECT id,birthday,name,regdate,posts,postsToday,sex,powerlevel,picture,last_invizection FROM `users` LEFT JOIN users_last ON users_last.user_id = users.id WHERE `id`='568597' /*()*/

Good Query! (69) Render Time: 0.000 Extremely Fast

Rows Found: - Result Details: 1

UPDATE page_statistics SET views_today=views_today+1, views=views+1 WHERE page_id=8 /*()*/

Good Query! (70) Render Time: 0.001 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=8 OR page_id=8 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! (71) 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! (72) 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! (73) Render Time: 0.000 Extremely Fast

Rows Found: - Result Details: mysqli_result Object ( [current_field] => 0 [field_count] => 3 [lengths] => [num_rows] => 5 [type] => 0 )

SELECT * FROM `page_variables` WHERE page_id=8 /*()*/

Good Query! (74) Render Time: 0.000 Extremely Fast

Rows Found: - Result Details: mysqli_result Object ( [current_field] => 0 [field_count] => 3 [lengths] => [num_rows] => 5 [type] => 0 )

SELECT * FROM `page_variables` WHERE page_id=8 /*()*/

Good Query! (75) 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=8 /*()*/

Good Query! (76) Render Time: 0.001 Very Fast

Rows Found: - Result Details: mysqli_result Object ( [current_field] => 0 [field_count] => 1 [lengths] => [num_rows] => 0 [type] => 0 )

SELECT id FROM guests WHERE ip = '34.237.51.35' ORDER BY date DESC LIMIT 1 /*()*/

Good Query! (77) Render Time: 0.002 Very Fast

Rows Found: - Result Details: 1

INSERT INTO guests (ip,date,lasturl,firstURL,refURL,guestBrowser,last_page_id,last_parent_id,last_directory_id) VALUES ('34.237.51.35',1574134531,'','0','0','CCBot/2.0 (https://commoncrawl.org/faq/)',8,8,2) /*()*/

Good Query! (78) Render Time: 0.000 Extremely Fast

Rows Found: - Result Details: 1

DELETE FROM guests WHERE date<1574133631 /*()*/

Good Query! (79) Render Time: 0.002 Very 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='/videogames/index.php?system=amiga&search=' /*()*/

Good Query! (80) Render Time: 0.001 Very 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='/videogames/index.php?system=amiga&search=' AND keywords <> '' GROUP BY keywords ORDER BY counttotal DESC, date DESC LIMIT 10 /*()*/

Good Query! (81) Render Time: 0.003 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! (82) Render Time: 0.000 Extremely Fast

Rows Found: - Result Details: 1

UPDATE misc SET views=2536208485 /*()*/

Good Query! (83) Render Time: 0.002 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! (84) Render Time: 0.002 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! (85) Render Time: 0.003 Very 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! (86) 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 >= 1574134531-900 AND last_page_id=8 /*()*/

Good Query! (87) Render Time: 0.001 Very Fast

Rows Found: - Result Details: mysqli_result Object ( [current_field] => 0 [field_count] => 1 [lengths] => [num_rows] => 7 [type] => 0 )

SELECT id FROM guests WHERE date >= 1574134531-900 AND last_page_id=8 /*()*/

Good Query! (88) 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 >= 1574134531-900 AND (last_directory_id=2 OR last_page_id=2) /*()*/

Good Query! (89) Render Time: 0.003 Very Fast

Rows Found: - Result Details: mysqli_result Object ( [current_field] => 0 [field_count] => 1 [lengths] => [num_rows] => 107 [type] => 0 )

SELECT id FROM guests WHERE date >= 1574134531-900 AND (last_directory_id=2 OR last_page_id=2) /*()*/

Good Query! (90) 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 >= 1574134531-900 /*()*/

Good Query! (91) 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 >= 1574134531-900 /*()*/

Good Query! (92) 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=8 OR page_id=2 OR page_id=8 ORDER BY power DESC /*()*/

Good Query! (93) 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! (94) Render Time: 0.000 Extremely Fast

Rows Found: - Result Details: mysqli_result Object ( [current_field] => 0 [field_count] => 12 [lengths] => [num_rows] => 6 [type] => 0 )

SELECT * FROM page WHERE (directory_id=8 OR (directory_id=2 AND directory_id!=2) ) AND page_order=3 AND (page_title <> '' OR page_title_short <> '') ORDER BY page_title ASC /*()*/

Good Query! (95) Render Time: 0.000 Extremely Fast

Rows Found: - Result Details: mysqli_result Object ( [current_field] => 0 [field_count] => 5 [lengths] => [num_rows] => 8 [type] => 0 )

SELECT id, url, page_order, page_title, page_title_short FROM page WHERE (parent_id=8 OR directory_id=8 OR id=8 OR id=2 OR parent_id=8 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! (96) Render Time: 0.001 Very Fast

Rows Found: - Result Details: mysqli_result Object ( [current_field] => 0 [field_count] => 50 [lengths] => [num_rows] => 1 [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 = 8 ORDER BY page_content_order ASC /*()*/

Good Query! (97) Render Time: 0.000 Extremely Fast

Rows Found: - Result Details: mysqli_result Object ( [current_field] => 0 [field_count] => 36 [lengths] => [num_rows] => 1 [type] => 0 )

SELECT * FROM page_content WHERE title='Trending on Site' /*()*/

Good Query! (98) 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 log_2019_11_18 LIMIT 1 /*()*/

Good Query! (99) Render Time: 0.002 Very Fast

Rows Found: - Result Details: 1

UPDATE log_2019_11_18 SET rendered='442', queries='98', queries_slow='4', queries_errors='' WHERE id=324819 /*()*/

Commodore Amiga Video Games - Video Game Room

New Content Added to the Site Daily!

Search for Games

Game Results

Search Results

All Game Systems

Nintendo

Sega

Sony

Microsoft

Other Systems

Trending on Site

Related Content

Page Comments