Pokemon Forum - Pokemon

SELECT * FROM page LEFT JOIN page_statistics ON page_statistics.page_id = id WHERE url = "/boards/forum.php?id=95" /*()*/

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

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

/* get_browser Start /* /*()*/

SELECT id FROM vizzed_logs.log_ip WHERE ip=INET_ATON('34.204.173.36') /*()*/

SELECT count(*) AS total FROM vizzed_logs.log_2019_11_20 WHERE ip_id=1620190 AND date > 1574299620 - 3 /*()*/

SELECT count(*) AS total FROM vizzed_logs.log_2019_11_20 WHERE ip_id=1620190 AND date > 1574299620 - 60 /*()*/

SELECT id FROM log_2019_11_20 LIMIT 1 /*()*/

SELECT * FROM log_ip WHERE ip=INET_ATON('34.204.173.36') /*()*/

INSERT INTO log_2019_11_20( user_id, ip_id, page_id, browser_id, device_id, os_id, unique_id, security, date ) VALUES( '', '1620190', '287746', '23586', '2', '2', '56049043', '', 1574299620 ) /*()*/

INSERT INTO log_2019_11_20_details( log_id, url, title, referral_url, variables_post, variables_get ) VALUES( 291958, '//www.vizzed.com/boards/forum.php?id=95&sub=Polls%20and%20Question', 'Pokemon', '', '', '{\"id\":\"95\",\"sub\":\"Polls and Question\"}' ) /*()*/

SELECT * FROM forums WHERE id=95 /*()*/

INSERT INTO vizzed_logs.log_queries_slow (log_table,log_id,query,rendered) VALUES ('log_2019_11_20','291958',' SELECT COUNT(threads.user) as total, user as userid, users.birthday, users.name, users.regdate, users.posts, users.sex, users.powerlevel, users.postsToday FROM threads INNER JOIN users ON users.id=threads.user WHERE forum=95 GROUP BY user ORDER BY total DESC LIMIT 10 /*()*/ ','27') /*()*/

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

SELECT * FROM `page_variable_list` WHERE (page_id=0 OR page_id=287746 OR page_id=287729 OR page_id=7) 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 /*()*/

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

UPDATE guests SET date=1574299620, last_page_id=287746,last_parent_id=287729,last_directory_id=7 WHERE ip = '34.204.173.36' /*()*/

SELECT allkeywords,id FROM page_indexes WHERE url='/boards/forum.php?id=95&sub=Polls%20and%20Question' /*()*/

SELECT distinct keywords, SUM(total) as counttotal, searchengine FROM searchkeywords WHERE type='' AND typeid=95 AND keywords <> '' GROUP BY keywords ORDER BY counttotal DESC, date DESC LIMIT 10 /*()*/

SELECT views FROM misc /*()*/

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

SELECT page.* FROM `page` INNER JOIN page_statistics ON page_statistics.page_id = page.id WHERE page_order = 3 ORDER BY views_today DESC /*()*/

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

SELECT title FROM announcements ORDER BY date DESC LIMIT 5 /*()*/

SELECT COUNT(*) as total FROM users_last WHERE lastactivity >= 1574299620-900 AND last_page_id=287746 /*()*/

SELECT COUNT(*) as total FROM users LEFT JOIN users_last ON users_last.user_id = users.id WHERE lastactivity >= 1574299620-900 AND (last_parent_id=287746 OR last_page_id=287746 OR lastforum=95) /*()*/

SELECT COUNT(*) as total FROM guests WHERE date >= 1574299620-900 AND (last_parent_id=287746 OR last_page_id=287746 OR lastforum=95) /*()*/

SELECT COUNT(*) as total FROM users_last WHERE lastactivity >= 1574299620-900 AND (last_directory_id=7 OR last_page_id=7) /*()*/

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

SELECT COUNT(*) as total FROM users_last WHERE lastactivity >= 1574299620-900 /*()*/

SELECT COUNT(*) as total FROM guests WHERE date >= 1574299620-900 /*()*/

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=287746 OR page_id=7 OR page_id=287729 ORDER BY power DESC /*()*/

SELECT * FROM page WHERE page_order <= 2 ORDER BY page_order ASC, page_title ASC /*()*/

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

SELECT id, url, page_order, page_title, page_title_short FROM page WHERE (parent_id=287746 OR directory_id=287746 OR id=287729 OR id=7 OR parent_id=287729 OR (directory_id=7 AND directory_id <> 2) ) AND page_order <= 3 ORDER BY id = 7 DESC, page_order ASC, page_title ASC /*()*/

SELECT COUNT(*) as total FROM threads LEFT JOIN threads_keywords ON threads_keywords.thread_id = threads.id LEFT JOIN keywords ON keywords.id = threads_keywords.keyword_id LEFT JOIN forums ON forums.id=threads.forum WHERE forum=95 AND (forums.minpower <= 0 )AND keywords.keyword = 'Polls and Question' /*()*/

INSERT INTO vizzed_logs.log_queries_slow (log_table,log_id,query,rendered) VALUES ('log_2019_11_20','291958',' SELECT threads.* FROM ( SELECT threads.*, page.img_thumbnail AS img_thumbnail, minpower, forums.title as forumtitle, forums.id as forumid, users2.id as user2, users2.birthday as birthday2, users2.name as name2, users2.regdate as regdate2, users2.posts as posts2, users2.sex as sex2, users2.powerlevel as powerlevel2, users2.postsToday as postsToday2 , 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 threads INNER JOIN users ON users.id = threads.user INNER JOIN users users2 ON users2.id = threads.lastposter LEFT JOIN threads_keywords ON threads_keywords.thread_id = threads.id LEFT JOIN keywords ON keywords.id = threads_keywords.keyword_id LEFT JOIN forums ON forums.id=threads.forum LEFT JOIN page ON page.special_id = threads.id AND page.parent_id=795701 WHERE forum=95 AND (forums.minpower <= 0 )AND keywords.keyword = \'Polls and Question\' GROUP BY threads.id ORDER BY sticky DESC, lastpostdate DESC LIMIT 0,50 ) threads ORDER BY threads.sticky DESC, threads.closed ASC, threads.lastpostdate DESC /*()*/ ','26') /*()*/

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`='7061' /*()*/

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`='302825' /*()*/

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`='302825' /*()*/

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`='234873' /*()*/

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`='322478' /*()*/

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`='424513' /*()*/

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`='418885' /*()*/

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`='181120' /*()*/

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`='283175' /*()*/

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`='490614' /*()*/

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`='233750' /*()*/

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`='91435' /*()*/

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`='475945' /*()*/

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`='484926' /*()*/

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`='466558' /*()*/

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`='330678' /*()*/

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`='466369' /*()*/

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`='92806' /*()*/

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`='367570' /*()*/

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`='120456' /*()*/

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`='505301' /*()*/

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`='266993' /*()*/

INSERT INTO vizzed_logs.log_queries_slow (log_table,log_id,query,rendered) VALUES ('log_2019_11_20','291958',' SELECT COUNT(keyword) as total, keyword, keywords.id as keyword_id FROM keywords LEFT JOIN threads_keywords ON threads_keywords.keyword_id = keywords.id LEFT JOIN threads ON threads.id = threads_keywords.thread_id WHERE forum=95 GROUP BY keyword ORDER BY keyword ASC /*()*/ ','19') /*()*/

SELECT id FROM log_2019_11_20 LIMIT 1 /*()*/

UPDATE log_2019_11_20 SET rendered='226', queries='115', queries_slow='4', queries_errors='' WHERE id=291958 /*()*/