Katy Perry Online

#1 Source for Katy Perry!

Home
Login

Home > Public Appearances & Events > 2013 > 27th Dec | 'Britney: Piece of Me' Opening Night

Return to the thumbnail page

FILE 45239/45557

Return to start

See previous file

See next file

Skip to end

Rate this file (No vote yet)

Debug Info

Debug Output: show / hide USER: ------------------ Array ( [ID] => b149e078d24f94518c165a8119409775 [am] => 1 [liv] => Array ( [0] => 122647 [1] => 153563 [2] => 148114 [3] => 124121 [4] => 142808 ) ) ========================== USER DATA: ------------------ Array ( [user_id] => 0 [user_name] => Guest [groups] => Array ( [0] => 3 ) [group_quota] => 0 [can_rate_pictures] => 1 [can_send_ecards] => 0 [can_post_comments] => 0 [can_upload_pictures] => 0 [can_create_albums] => 0 [pub_upl_need_approval] => 1 [priv_upl_need_approval] => 1 [access_level] => 3 [disk_max] => 0 [disk_min] => 0 [has_admin_access] => 0 [group_name] => Anonymous [can_create_public_albums] => 0 [can_see_all_albums] => 0 [group_id] => 3 [allowed_albums] => Array ( ) ) ========================== Queries: ------------------ Array ( [0] => SELECT name, value FROM cpgeh_config [include/init.inc.php:177] (0.31 ms) [1] => SELECT * FROM cpgeh_plugins ORDER BY priority [include/plugin_api.inc.php:48] (0.16 ms) [2] => SELECT user_id, time FROM `katyperr_katyp`.cpgeh_sessions WHERE session_id = 'e7fb5baf6d51220c4ed57e82b00f7dc0' [bridge/coppermine.inc.php:241] (0.15 ms) [3] => SELECT MAX(group_quota) AS disk_max, MIN(group_quota) AS disk_min, MAX(can_rate_pictures) AS can_rate_pictures, MAX(can_send_ecards) AS can_send_ecards, MAX(can_post_comments) AS can_post_comments, MAX(can_upload_pictures) AS can_upload_pictures, MAX(can_create_albums) AS can_create_albums, MAX(has_admin_access) AS has_admin_access, MAX(access_level) AS access_level, MIN(pub_upl_need_approval) AS pub_upl_need_approval, MIN( priv_upl_need_approval) AS priv_upl_need_approval FROM cpgeh_usergroups WHERE group_id in (3) [bridge/udb_base.inc.php:350] (0.24 ms) [4] => SELECT group_name FROM cpgeh_usergroups WHERE group_id= 3 [bridge/udb_base.inc.php:362] (0.1 ms) [5] => SELECT COUNT() FROM cpgeh_categorymap WHERE group_id in (3) [bridge/udb_base.inc.php:375] (0.12 ms) [6] => SELECT aid FROM cpgeh_albums WHERE moderator_group IN (3) [include/init.inc.php:271] (0.14 ms) [7] => SELECT lang_id FROM cpgeh_languages WHERE enabled='YES' [include/init.inc.php:334] (0.13 ms) [8] => DELETE FROM cpgeh_banned WHERE expiry < '2025-04-07 17:44:25' [include/init.inc.php:448] (0.17 ms) [9] => SELECT null FROM cpgeh_banned WHERE ('18.119.157.234' LIKE ip_addr ) AND brute_force=0 LIMIT 1 [include/init.inc.php:464] (0.13 ms) [10] => SELECT rgt, lft, depth FROM cpgeh_categories WHERE cid = 2 LIMIT 1 [include/functions.inc.php:44] (0.13 ms) [11] => SELECT cid FROM cpgeh_categories WHERE lft BETWEEN 3 AND 48 [include/functions.inc.php:49] (0.15 ms) [12] => SELECT keyword FROM cpgeh_albums WHERE category IN (2, 102, 103, 182, 174, 166, 142, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 100, 101, 190) [include/functions.inc.php:57] (2.49 ms) [13] => SELECT mtime FROM cpgeh_pictures WHERE pid = 142808 [include/functions.inc.php:2359] (0.13 ms) [14] => SELECT COUNT() FROM cpgeh_pictures AS p INNER JOIN cpgeh_albums AS r ON r.aid = p.aid INNER JOIN cpgeh_categories AS c2 ON c2.cid = category WHERE (c2.lft BETWEEN 3 AND 48) AND (1 OR keywords like '%KatyPerry%' OR keywords like '%katyperry%' OR keywords like '%katyperry%') AND approved = 'YES' AND hits > 0 AND (mtime > '2022-06-26 15:46:50' OR mtime = '2022-06-26 15:46:50' AND pid < 142808) [include/functions.inc.php:2371] (233.53 ms) [15] => SELECT COUNT() FROM cpgeh_pictures AS r INNER JOIN cpgeh_albums AS a ON a.aid = r.aid INNER JOIN cpgeh_categories AS c2 ON c2.cid = category WHERE (c2.lft BETWEEN 3 AND 48) AND (1 OR keywords like '%KatyPerry%' OR keywords like '%katyperry%' OR keywords like '%katyperry%') AND approved = 'YES' AND hits > 0 [include/functions.inc.php:1815] (139.04 ms) [16] => SELECT r.pid, r.aid, filepath, filename, url_prefix, pwidth, pheight, filesize, ctime, r.title, r.keywords, r.votes, pic_rating, hits, caption, r.owner_id, UNIX_TIMESTAMP(mtime) AS mtime FROM cpgeh_pictures AS r INNER JOIN cpgeh_albums AS a ON a.aid = r.aid INNER JOIN cpgeh_categories AS c2 ON c2.cid = category WHERE (c2.lft BETWEEN 3 AND 48) AND (1 OR keywords like '%KatyPerry%' OR keywords like '%katyperry%' OR keywords like '%katyperry%') AND approved = 'YES' AND hits > 0 ORDER BY mtime ASC, pid DESC LIMIT 318 ,1 [include/functions.inc.php:1838] (780.09 ms) [17] => SELECT COUNT() FROM cpgeh_pictures AS r INNER JOIN cpgeh_albums AS a ON a.aid = r.aid INNER JOIN cpgeh_categories AS c2 ON c2.cid = category WHERE (c2.lft BETWEEN 3 AND 48) AND (1 OR keywords like '%KatyPerry%' OR keywords like '%katyperry%' OR keywords like '%katyperry%') AND approved = 'YES' AND hits > 0 [include/functions.inc.php:1815] (127.96 ms) [18] => SELECT r.pid, UNIX_TIMESTAMP(mtime) AS mtime FROM cpgeh_pictures AS r INNER JOIN cpgeh_albums AS a ON a.aid = r.aid INNER JOIN cpgeh_categories AS c2 ON c2.cid = category WHERE (c2.lft BETWEEN 3 AND 48) AND (1 OR keywords like '%KatyPerry%' OR keywords like '%katyperry%' OR keywords like '%katyperry%') AND approved = 'YES' AND hits > 0 ORDER BY mtime ASC, pid DESC LIMIT 319 ,1 [include/functions.inc.php:1838] (204.53 ms) [19] => SELECT COUNT() FROM cpgeh_pictures AS r INNER JOIN cpgeh_albums AS a ON a.aid = r.aid INNER JOIN cpgeh_categories AS c2 ON c2.cid = category WHERE (c2.lft BETWEEN 3 AND 48) AND (1 OR keywords like '%KatyPerry%' OR keywords like '%katyperry%' OR keywords like '%katyperry%') AND approved = 'YES' AND hits > 0 [include/functions.inc.php:1815] (137.08 ms) [20] => SELECT r.pid, UNIX_TIMESTAMP(mtime) AS mtime FROM cpgeh_pictures AS r INNER JOIN cpgeh_albums AS a ON a.aid = r.aid INNER JOIN cpgeh_categories AS c2 ON c2.cid = category WHERE (c2.lft BETWEEN 3 AND 48) AND (1 OR keywords like '%KatyPerry%' OR keywords like '%katyperry%' OR keywords like '%katyperry%') AND approved = 'YES' AND hits > 0 ORDER BY mtime ASC, pid DESC LIMIT 317 ,1 [include/functions.inc.php:1838] (452.76 ms) [21] => SELECT COUNT() FROM cpgeh_pictures AS r INNER JOIN cpgeh_albums AS a ON a.aid = r.aid INNER JOIN cpgeh_categories AS c2 ON c2.cid = category WHERE (c2.lft BETWEEN 3 AND 48) AND (1 OR keywords like '%KatyPerry%' OR keywords like '%katyperry%' OR keywords like '%katyperry%') AND approved = 'YES' AND hits > 0 [include/functions.inc.php:1815] (205.38 ms) [22] => SELECT r.pid, UNIX_TIMESTAMP(mtime) AS mtime FROM cpgeh_pictures AS r INNER JOIN cpgeh_albums AS a ON a.aid = r.aid INNER JOIN cpgeh_categories AS c2 ON c2.cid = category WHERE (c2.lft BETWEEN 3 AND 48) AND (1 OR keywords like '%KatyPerry%' OR keywords like '%katyperry%' OR keywords like '%katyperry%') AND approved = 'YES' AND hits > 0 ORDER BY mtime DESC, pid ASC LIMIT 0 ,1 [include/functions.inc.php:1838] (455.37 ms) [23] => SELECT COUNT() FROM cpgeh_pictures AS r INNER JOIN cpgeh_albums AS a ON a.aid = r.aid INNER JOIN cpgeh_categories AS c2 ON c2.cid = category WHERE (c2.lft BETWEEN 3 AND 48) AND (1 OR keywords like '%KatyPerry%' OR keywords like '%katyperry%' OR keywords like '%katyperry%') AND approved = 'YES' AND hits > 0 [include/functions.inc.php:1815] (211.41 ms) [24] => SELECT r.pid, UNIX_TIMESTAMP(mtime) AS mtime FROM cpgeh_pictures AS r INNER JOIN cpgeh_albums AS a ON a.aid = r.aid INNER JOIN cpgeh_categories AS c2 ON c2.cid = category WHERE (c2.lft BETWEEN 3 AND 48) AND (1 OR keywords like '%KatyPerry%' OR keywords like '%katyperry%' OR keywords like '%katyperry%') AND approved = 'YES' AND hits > 0 ORDER BY mtime ASC, pid DESC LIMIT 0 ,1 [include/functions.inc.php:1838] (392.29 ms) [25] => SELECT title, comments, votes, category, aid FROM cpgeh_albums WHERE aid='1573' LIMIT 1 [displayimage.php:420] (0.16 ms) [26] => SELECT p.cid, p.name FROM cpgeh_categories AS c, cpgeh_categories AS p WHERE c.lft BETWEEN p.lft AND p.rgt AND c.cid = 9 ORDER BY p.lft [include/functions.inc.php:2942] (0.25 ms) [27] => UPDATE cpgeh_pictures SET hits = hits + 1, lasthit_ip = '18.119.157.234', mtime = CURRENT_TIMESTAMP WHERE pid = 142808 [include/functions.inc.php:2844] (0.53 ms) [28] => SELECT extension, mime, content, player FROM cpgeh_filetypes [include/functions.inc.php:5955] (0.32 ms) [29] => SELECT null FROM cpgeh_votes WHERE pic_id= 142808 AND user_md5_id='b149e078d24f94518c165a8119409775' [include/themes.inc.php:3624] (0.21 ms) [30] => SELECT null FROM cpgeh_vote_stats WHERE pid = 142808 AND ip = '18.119.157.234' [include/themes.inc.php:3625] (0.14 ms) [31] => SELECT user_name as user_name FROM `katyperr_katyp`.cpgeh_users WHERE user_id = '1' [bridge/udb_base.inc.php:59] (0.16 ms) [32] => SELECT COUNT(msg_id) FROM cpgeh_comments WHERE pid='142808' [include/themes.inc.php:3757] (0.18 ms) [33] => SELECT COUNT() FROM cpgeh_pictures AS r INNER JOIN cpgeh_albums AS a ON a.aid = r.aid INNER JOIN cpgeh_categories AS c2 ON c2.cid = category WHERE (c2.lft BETWEEN 3 AND 48) AND (1 OR keywords like '%KatyPerry%' OR keywords like '%katyperry%' OR keywords like '%katyperry%') AND approved = 'YES' AND hits > 0 [include/functions.inc.php:1815] (195.41 ms) [34] => SELECT r.pid, r.aid, filepath, filename, url_prefix, pwidth, pheight, filesize, ctime, r.title, UNIX_TIMESTAMP(mtime) AS mtime FROM cpgeh_pictures AS r INNER JOIN cpgeh_albums AS a ON a.aid = r.aid INNER JOIN cpgeh_categories AS c2 ON c2.cid = category WHERE (c2.lft BETWEEN 3 AND 48) AND (1 OR keywords like '%KatyPerry%' OR keywords like '%katyperry%' OR keywords like '%katyperry%') AND approved = 'YES' AND hits > 0 ORDER BY mtime ASC, pid DESC LIMIT 316 ,5 [include/functions.inc.php:1838] (666.14 ms) ) ========================== GET : ------------------ Array ( [album] => lasthits [cat] => 2 [pid] => 142808 ) ========================== POST : ------------------ Array ( ) ========================== COOKIE : ------------------ Array ( [cpg16x_data] => YTozOntzOjI6IklEIjtzOjMyOiJiMTQ5ZTA3OGQyNGY5NDUxOGMxNjVhODExOTQwOTc3NSI7czoyOiJhbSI7aToxO3M6MzoibGl2IjthOjQ6e2k6MDtzOjY6IjEyMjY0NyI7aToxO3M6NjoiMTUzNTYzIjtpOjI7czo2OiIxNDgxMTQiO2k6MztzOjY6IjEyNDEyMSI7fX0= [f8bd9544f6ef0540952959806cd4479b] => ba949fa0388da5617cbb5f07034c0995 ) ==========================