Time Before: 0.00045 seconds
Time After: 0.00047 seconds
Time Taken: 0.00002 seconds

Memory Before: 411.852 KB
Memory After: 413.688 KB
Memory Used: 1.836 KB

Time Before: 0.00051 seconds
Time After: 0.01427 seconds
Time Taken: 0.01376 seconds

Memory Before: 413.672 KB
Memory After: 414.484 KB
Memory Used: 0.813 KB

SET @@sql_mode = ''

Time Before: 0.01487 seconds
Time After: 0.01539 seconds
Time Taken: 0.00052 seconds

Memory Before: 414.453 KB
Memory After: 414.508 KB
Memory Used: 0.055 KB

SELECT *
FROM datastore
WHERE title IN ('','options','bitfields','attachmentcache','forumcache','usergroupcache','stylecache','languagecache','products','pluginlist','cron','profilefield','loadcache','noticecache','crondata')

Time Before: 0.01547 seconds
Time After: 0.02686 seconds
Time Taken: 0.01139 seconds

Memory Before: 414.297 KB
Memory After: 1,675.375 KB
Memory Used: 1,261.078 KB

SELECT *
FROM datastore
WHERE title IN ('wol_spiders','modstats_coder','modstats_designer','modstats_motm','modtitle_coder','modtitle_designer')

Time Before: 0.02716 seconds
Time After: 0.02756 seconds
Time Taken: 0.00039 seconds

Memory Before: 1,676.914 KB
Memory After: 1,933.125 KB
Memory Used: 256.211 KB

SELECT languageid,
			phrasegroup_global AS phrasegroup_global,
			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 language
WHERE languageid = 1

Time Before: 0.02765 seconds
Time After: 0.02831 seconds
Time Taken: 0.00066 seconds

Memory Before: 1,859.758 KB
Memory After: 1,931.250 KB
Memory Used: 71.492 KB

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

Time Before: 0.02980 seconds
Time After: 0.02999 seconds
Time Taken: 0.00019 seconds

Memory Before: 2,041.203 KB
Memory After: 2,193.523 KB
Memory Used: 152.320 KB

SELECT title, template
FROM template
WHERE templateid IN (46,48,871,868,872,75,74,76,71,70,529,877,407,408,409,245,248,445,446,447,448,449,742,664,663,665,668,878,429,434,433,431,432,410,876,194,867,244,115,179,180,151,197,397,398,400,874,396,196,198,199,200,216,309,321,322,324,323,875,401,402,744,751,752,753,754,755,556,605,606,603,403,573,575)

Time Before: 0.03123 seconds
Time After: 0.03175 seconds
Time Taken: 0.00052 seconds

Memory Before: 2,228.109 KB
Memory After: 2,493.227 KB
Memory Used: 265.117 KB

SELECT cron.*
FROM cron AS cron
LEFT JOIN product AS product ON (cron.product = product.productid)
WHERE cron.nextrun <= 1789306626 AND cron.active = 1
	AND (product.productid IS NULL OR product.active = 1)
ORDER BY cron.nextrun
LIMIT 1

Time Before: 0.03399 seconds
Time After: 0.03420 seconds
Time Taken: 0.00021 seconds

Memory Before: 2,512.195 KB
Memory After: 2,528.203 KB
Memory Used: 16.008 KB

UPDATE cron
SET nextrun = 1789308600
WHERE cronid = 8 AND nextrun = 1789243800

Time Before: 0.03424 seconds
Time After: 0.06340 seconds
Time Taken: 0.02917 seconds

Memory Before: 2,513.625 KB
Memory After: 2,513.656 KB
Memory Used: 0.031 KB

SELECT MIN(nextrun) AS nextrun
FROM cron AS cron

	LEFT JOIN product AS product ON (cron.product = product.productid)
	WHERE cron.active = 1
	AND (product.productid IS NULL OR product.active = 1)

Time Before: 0.06369 seconds
Time After: 0.06390 seconds
Time Taken: 0.00021 seconds

Memory Before: 2,514.047 KB
Memory After: 2,530.117 KB
Memory Used: 16.070 KB

REPLACE INTO datastore
	(title, data, unserialize)
VALUES
	('cron', '1789244100', 0)

Time Before: 0.06393 seconds
Time After: 0.07439 seconds
Time Taken: 0.01046 seconds

Memory Before: 2,514.047 KB
Memory After: 2,514.016 KB
Memory Used: -0.031 KB

SELECT version() AS version

Time Before: 0.11311 seconds
Time After: 0.11330 seconds
Time Taken: 0.00019 seconds

Memory Before: 2,513.234 KB
Memory After: 2,529.617 KB
Memory Used: 16.383 KB

CREATE TABLE IF NOT EXISTS aaggregate_temp_1789243800 (
		attachmentid INT UNSIGNED NOT NULL DEFAULT '0',
		views INT UNSIGNED NOT NULL DEFAULT '0',
		KEY attachmentid (attachmentid)
	) ENGINE = MEMORY

Time Before: 0.11333 seconds
Time After: 0.20828 seconds
Time Taken: 0.09494 seconds

Memory Before: 2,513.867 KB
Memory After: 2,513.742 KB
Memory Used: -0.125 KB

LOCK TABLES aaggregate_temp_1789243800 WRITE, attachmentviews WRITE

Time Before: 0.20838 seconds
Time After: 0.20986 seconds
Time Taken: 0.00148 seconds

Memory Before: 2,514.016 KB
Memory After: 2,514.031 KB
Memory Used: 0.016 KB

INSERT INTO aaggregate_temp_1789243800
	SELECT attachmentid, COUNT(*) AS views
	FROM attachmentviews
	GROUP BY attachmentid

Time Before: 0.20990 seconds
Time After: 0.21009 seconds
Time Taken: 0.00019 seconds

Memory Before: 2,513.938 KB
Memory After: 2,513.977 KB
Memory Used: 0.039 KB

UNLOCK TABLES

Time Before: 0.21010 seconds
Time After: 0.21019 seconds
Time Taken: 0.00008 seconds

Memory Before: 2,513.461 KB
Memory After: 2,513.523 KB
Memory Used: 0.063 KB

TRUNCATE TABLE attachmentviews

Time Before: 0.21020 seconds
Time After: 0.39780 seconds
Time Taken: 0.18760 seconds

Memory Before: 2,513.500 KB
Memory After: 2,513.555 KB
Memory Used: 0.055 KB

UPDATE attachment AS attachment
INNER JOIN (SELECT * FROM aaggregate_temp_1789243800
ORDER BY attachmentid) AS aggregate USING (attachmentid)
SET attachment.counter = attachment.counter + aggregate.views

Time Before: 0.39783 seconds
Time After: 0.39811 seconds
Time Taken: 0.00028 seconds

Memory Before: 2,514.125 KB
Memory After: 2,514.047 KB
Memory Used: -0.078 KB

DROP TABLE IF EXISTS aaggregate_temp_1789243800

Time Before: 0.39813 seconds
Time After: 0.47738 seconds
Time Taken: 0.07925 seconds

Memory Before: 2,513.586 KB
Memory After: 2,513.555 KB
Memory Used: -0.031 KB