Time Before: 0.05720 seconds
Time After: 0.12398 seconds
Time Taken: 0.06678 seconds

Memory Before: 2,058.566 KB
Memory After: 3,603.664 KB
Memory Used: 1,545.098 KB

Time Before: 0.12430 seconds
Time After: 0.12652 seconds
Time Taken: 0.00222 seconds

Memory Before: 3,604.402 KB
Memory After: 3,606.156 KB
Memory Used: 1.754 KB

SET @@sql_mode = ''

Time Before: 0.12916 seconds
Time After: 0.12958 seconds
Time Taken: 0.00042 seconds

Memory Before: 3,605.070 KB
Memory After: 3,605.766 KB
Memory Used: 0.695 KB

SELECT *
FROM vb421_datastore
WHERE title IN ('smiliecache','bbcodecache','userstats','photoplog_dscat','navdata','options','bitfields','attachmentcache','forumcache','usergroupcache','stylecache','languagecache','products','pluginlist','cron','profilefield','loadcache','noticecache','activitystream','routes')

Time Before: 0.12980 seconds
Time After: 0.14033 seconds
Time Taken: 0.01053 seconds

Memory Before: 3,604.578 KB
Memory After: 3,926.492 KB
Memory Used: 321.914 KB

SELECT *
FROM vb421_datastore
WHERE title IN ('profilefield')

Time Before: 0.18143 seconds
Time After: 0.18293 seconds
Time Taken: 0.00150 seconds

Memory Before: 4,433.742 KB
Memory After: 4,434.336 KB
Memory Used: 0.594 KB

SELECT *
FROM vb421_session
WHERE userid = 0
	AND host = '3.138.179.119'
	AND idhash = 'e43ac18147d0ac11fb6422725c07bd12'
LIMIT 1

SELECT languageid,
			phrasegroup_global AS phrasegroup_global,
			phrasegroup_ckeditor AS phrasegroup_ckeditor,
			phrasegroup_photoplog AS phrasegroup_photoplog,
			phrasegroup_posting AS phrasegroup_posting,
			phrasegroupinfo AS lang_phrasegroupinfo,
			options AS lang_options,
			languagecode AS lang_code,
			charset AS lang_charset,
			locale AS lang_locale,
			imagesoverride AS lang_imagesoverride,
			dateoverride AS lang_dateoverride,
			timeoverride AS lang_timeoverride,
			registereddateoverride AS lang_registereddateoverride,
			calformat1override AS lang_calformat1override,
			calformat2override AS lang_calformat2override,
			logdateoverride AS lang_logdateoverride,
			decimalsep AS lang_decimalsep,
			thousandsep AS lang_thousandsep
FROM vb421_language
WHERE languageid = 1

Time Before: 0.18369 seconds
Time After: 0.19394 seconds
Time Taken: 0.01025 seconds

Memory Before: 4,436.773 KB
Memory After: 4,566.988 KB
Memory Used: 130.215 KB

SELECT MAX(permissions & 1) AS perm
FROM vb421_cms_permissions
WHERE nodeid = 1 AND usergroupid IN (1)

Time Before: 0.23128 seconds
Time After: 0.24042 seconds
Time Taken: 0.00913 seconds

Memory Before: 4,849.852 KB
Memory After: 4,850.406 KB
Memory Used: 0.555 KB

SELECT *
FROM vb421_style
WHERE (styleid = 1 AND userselect = 1)
	OR styleid = 1
ORDER BY styleid ASC
LIMIT 1

Time Before: 0.25189 seconds
Time After: 0.25423 seconds
Time Taken: 0.00234 seconds

Memory Before: 5,001.090 KB
Memory After: 5,001.621 KB
Memory Used: 0.531 KB

SELECT catid, parentid, title
		FROM plog215_photoplog_categories

Time Before: 0.32450 seconds
Time After: 0.32499 seconds
Time Taken: 0.00049 seconds

Memory Before: 6,703.223 KB
Memory After: 6,703.828 KB
Memory Used: 0.605 KB

SELECT * FROM plog215_photoplog_permissions
					WHERE usergroupid IN (1)

Time Before: 0.32781 seconds
Time After: 0.32832 seconds
Time Taken: 0.00051 seconds

Memory Before: 6,707.641 KB
Memory After: 6,708.234 KB
Memory Used: 0.594 KB

SELECT title, template
FROM vb421_template
WHERE templateid IN (32623,32592,32629,32616,32611,32610,1009,999,1061,32615,32614,32632,32630,32631,32583,32584,32586,32587,32605,32606,32607,32608,32609,32612,32613,32594,32617,32618,32619,32628,32627,32635,32636,32637,32638,774,1034,993,995,996,0,0,431,425,424,429,430,428,427,432,433,434,740,1025,686,690,687,688,689,1033,0,0,1047,988,710,711,713,714,937,1017,1056,1018,537,536,540,524,529,525,531,532,527,528,530,469,471,473,475,477,703,698,701,702,782,783,704,699,696,697,1005,85)

Time Before: 0.34198 seconds
Time After: 0.38205 seconds
Time Taken: 0.04007 seconds

Memory Before: 6,771.078 KB
Memory After: 6,771.215 KB
Memory Used: 0.137 KB

SELECT COUNT(fileid) AS num1, MAX(fileid) AS num2
		FROM plog215_photoplog_fileuploads

Time Before: 0.47403 seconds
Time After: 0.47943 seconds
Time Taken: 0.00539 seconds

Memory Before: 7,257.016 KB
Memory After: 7,257.594 KB
Memory Used: 0.578 KB

SELECT plog215_photoplog_fileuploads.fileid,
		plog215_photoplog_fileuploads.catid,
		plog215_photoplog_fileuploads.filename,
		plog215_photoplog_fileuploads.userid,
		plog215_photoplog_fileuploads.title,
		plog215_photoplog_fileuploads.num_comments0 AS num_comments,
					plog215_photoplog_fileuploads.num_ratings0 AS num_ratings,
					plog215_photoplog_fileuploads.sum_ratings0 AS sum_ratings,
					IF(plog215_photoplog_fileuploads.num_ratings0 > 0,plog215_photoplog_fileuploads.sum_ratings0 / plog215_photoplog_fileuploads.num_ratings0,0) AS ave_ratings,
					plog215_photoplog_fileuploads.last_comment_dateline0 AS last_comment_dateline,
					plog215_photoplog_fileuploads.last_comment_id0 AS last_comment_id
		FROM plog215_photoplog_fileuploads
		WHERE 1=1
		AND plog215_photoplog_fileuploads.fileid BETWEEN 1 AND 1
		AND plog215_photoplog_fileuploads.catid NOT IN (0)
		AND plog215_photoplog_fileuploads.moderate = 0
		ORDER BY RAND()
		LIMIT 10

Time Before: 0.48111 seconds
Time After: 0.48186 seconds
Time Taken: 0.00075 seconds

Memory Before: 7,260.730 KB
Memory After: 7,260.465 KB
Memory Used: -0.266 KB

SELECT plog215_photoplog_fileuploads.fileid,
		plog215_photoplog_fileuploads.filename,
		plog215_photoplog_fileuploads.userid,
		plog215_photoplog_fileuploads.username,
		plog215_photoplog_fileuploads.title,
		plog215_photoplog_fileuploads.catid,
		plog215_photoplog_fileuploads.dateline,
		plog215_photoplog_fileuploads.filesize,
		plog215_photoplog_fileuploads.dimensions,
		plog215_photoplog_fileuploads.views,
		plog215_photoplog_fileuploads.num_comments0 AS num_comments,
					plog215_photoplog_fileuploads.num_ratings0 AS num_ratings,
					plog215_photoplog_fileuploads.sum_ratings0 AS sum_ratings,
					IF(plog215_photoplog_fileuploads.num_ratings0 > 0,plog215_photoplog_fileuploads.sum_ratings0 / plog215_photoplog_fileuploads.num_ratings0,0) AS ave_ratings,
					plog215_photoplog_fileuploads.last_comment_dateline0 AS last_comment_dateline,
					plog215_photoplog_fileuploads.last_comment_id0 AS last_comment_id
		FROM plog215_photoplog_fileuploads
		WHERE 1=1
		AND plog215_photoplog_fileuploads.fileid >= 1
		AND plog215_photoplog_fileuploads.catid NOT IN (0)
		AND plog215_photoplog_fileuploads.moderate = 0
		ORDER BY plog215_photoplog_fileuploads.dateline DESC, plog215_photoplog_fileuploads.fileid DESC
		LIMIT 4

Time Before: 0.50289 seconds
Time After: 0.50374 seconds
Time Taken: 0.00084 seconds

Memory Before: 7,594.852 KB
Memory After: 7,594.316 KB
Memory Used: -0.535 KB

SELECT catid,
	num_uploads,num_comments,last_upload_dateline,last_comment_dateline,
	last_upload_id,last_comment_id
	FROM plog215_photoplog_catcounts
	WHERE 1=1
	
	AND plog215_photoplog_catcounts.catid NOT IN (0)
	AND plog215_photoplog_catcounts.moderate = 0
	AND num_uploads > 0

Time Before: 0.54073 seconds
Time After: 0.54142 seconds
Time Taken: 0.00069 seconds

Memory Before: 7,539.297 KB
Memory After: 7,539.688 KB
Memory Used: 0.391 KB

SELECT commentid,
			catid, fileid, userid, username, title, dateline
		FROM plog215_photoplog_ratecomment
		WHERE 1=1
		AND plog215_photoplog_ratecomment.commentid IN (2,0)
		
		AND plog215_photoplog_ratecomment.catid NOT IN (0)
		AND plog215_photoplog_ratecomment.moderate = 0
		AND comment != ''
		ORDER BY dateline DESC

Time Before: 0.54312 seconds
Time After: 0.54390 seconds
Time Taken: 0.00078 seconds

Memory Before: 7,547.973 KB
Memory After: 7,548.320 KB
Memory Used: 0.348 KB

SELECT catid,
			fileid, userid, username, title, dateline, filename,
			plog215_photoplog_fileuploads.num_comments0 AS num_comments,
					plog215_photoplog_fileuploads.num_ratings0 AS num_ratings,
					plog215_photoplog_fileuploads.sum_ratings0 AS sum_ratings,
					IF(plog215_photoplog_fileuploads.num_ratings0 > 0,plog215_photoplog_fileuploads.sum_ratings0 / plog215_photoplog_fileuploads.num_ratings0,0) AS ave_ratings,
					plog215_photoplog_fileuploads.last_comment_dateline0 AS last_comment_dateline,
					plog215_photoplog_fileuploads.last_comment_id0 AS last_comment_id
		FROM plog215_photoplog_fileuploads
		WHERE 1=1
		AND plog215_photoplog_fileuploads.fileid IN (1,0)
		
		AND plog215_photoplog_fileuploads.catid NOT IN (0)
		AND plog215_photoplog_fileuploads.moderate = 0
		ORDER BY dateline DESC

Time Before: 0.54520 seconds
Time After: 0.54809 seconds
Time Taken: 0.00289 seconds

Memory Before: 7,551.559 KB
Memory After: 7,551.438 KB
Memory Used: -0.121 KB

SELECT SUM(num_views) AS sum1,
			SUM(sum_filesize) AS sum2, SUM(num_uploads) AS sum3, SUM(num_comments) AS sum4
			FROM plog215_photoplog_catcounts
			WHERE catid IN (1,2,3)
			AND plog215_photoplog_catcounts.catid NOT IN (0)
			AND plog215_photoplog_catcounts.moderate = 0
			AND num_uploads > 0

Time Before: 0.56861 seconds
Time After: 0.56921 seconds
Time Taken: 0.00060 seconds

Memory Before: 7,442.387 KB
Memory After: 7,442.758 KB
Memory Used: 0.371 KB

INSERT IGNORE INTO vb421_session
	(sessionhash, userid, host, idhash, lastactivity, location, styleid, languageid, loggedin, inforum, inthread, incalendar, badlocation, useragent, bypass, profileupdate, apiclientid, apiaccesstoken)
VALUES
	('1711f2da464ed8b372c421564e5db3d3', 0, '3.138.179.119', 'e43ac18147d0ac11fb6422725c07bd12', 1714542488, '/gallery/index.php?explain=1', 0, 0, 0, 0, 0, 0, 0, 'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)', 0, 0, 0, '')

Time Before: 0.60851 seconds
Time After: 0.61442 seconds
Time Taken: 0.00591 seconds

Memory Before: 7,648.152 KB
Memory After: 7,648.230 KB
Memory Used: 0.078 KB