Time Before: 0.19536 seconds
Time After: 0.19550 seconds
Time Taken: 0.00014 seconds
Memory Before: 541.805 KB
Memory After: 556.020 KB
Memory Used: 14.215 KB
Time Before: 0.19555 seconds
Time After: 0.19763 seconds
Time Taken: 0.00209 seconds
Memory Before: 555.945 KB
Memory After: 557.996 KB
Memory Used: 2.051 KB
SET @@sql_mode = ''
Time Before: 0.19825 seconds
Time After: 0.19869 seconds
Time Taken: 0.00044 seconds
Memory Before: 557.957 KB
Memory After: 558.262 KB
Memory Used: 0.305 KB
SELECT * FROM datastore WHERE title IN ('smiliecache','bbcodecache','blogcategorycache','blogstats','blogfeatured_settings','blogfeatured_entries','blogtagcloud','navdata','options','bitfields','attachmentcache','forumcache','usergroupcache','stylecache','languagecache','products','pluginlist','cron','profilefield','loadcache','noticecache','activitystream','routes')
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|---|---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | datastore | range | PRIMARY | PRIMARY | 150 | 23 | 100.00 | Using index condition |
Time Before: 0.20212 seconds
Time After: 0.20638 seconds
Time Taken: 0.00427 seconds
Memory Before: 560.820 KB
Memory After: 562.195 KB
Memory Used: 1.375 KB
Time Before: 0.19871 seconds
Time After: 0.20705 seconds
Time Taken: 0.00833 seconds
Memory Before: 557.715 KB
Memory After: 1,187.043 KB
Memory Used: 629.328 KB
SELECT * FROM datastore WHERE title IN ('forumcache','usergroupcache')
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|---|---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | datastore | range | PRIMARY | PRIMARY | 150 | 2 | 100.00 | Using index condition |
Time Before: 0.20815 seconds
Time After: 0.20940 seconds
Time Taken: 0.00126 seconds
Memory Before: 1,537.734 KB
Memory After: 1,539.109 KB
Memory Used: 1.375 KB
SELECT * FROM session WHERE userid = 0 AND host = '100.28.231.85' AND idhash = '39b17777abd03b9634f47645b13681bd' LIMIT 1
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|---|---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | session | ref | guest_lookup,user_activity | guest_lookup | 145 | const,const,const | 2 | 100.00 |
Time Before: 0.21141 seconds
Time After: 0.21202 seconds
Time Taken: 0.00061 seconds
Memory Before: 1,546.707 KB
Memory After: 1,548.121 KB
Memory Used: 1.414 KB
SELECT languageid, phrasegroup_global AS phrasegroup_global, phrasegroup_posting AS phrasegroup_posting, phrasegroup_vbblogglobal AS phrasegroup_vbblogglobal, phrasegroup_postbit AS phrasegroup_postbit, phrasegroup_vbblogcat AS phrasegroup_vbblogcat, phrasegroup_inlinemod AS phrasegroup_inlinemod, 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 language WHERE languageid = 2
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|---|---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | language | const | PRIMARY | PRIMARY | 2 | const | 1 | 100.00 |
Time Before: 0.21525 seconds
Time After: 0.21693 seconds
Time Taken: 0.00168 seconds
Memory Before: 1,554.723 KB
Memory After: 1,555.402 KB
Memory Used: 0.680 KB
Time Before: 0.20955 seconds
Time After: 0.21700 seconds
Time Taken: 0.00745 seconds
Memory Before: 1,543.043 KB
Memory After: 1,673.816 KB
Memory Used: 130.773 KB
SELECT MAX(permissions & 1) AS perm FROM cms_permissions WHERE nodeid = 1 AND usergroupid IN (1)
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|---|---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | cms_permissions | const | usergroupid,nodeid | usergroupid | 8 | const,const | 1 | 100.00 |
Time Before: 0.21912 seconds
Time After: 0.21950 seconds
Time Taken: 0.00038 seconds
Memory Before: 1,589.609 KB
Memory After: 1,590.930 KB
Memory Used: 1.320 KB
SELECT reason, liftdate FROM userban WHERE userid = 0
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|---|---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | no matching row in const table |
Time Before: 0.22118 seconds
Time After: 0.22166 seconds
Time Taken: 0.00048 seconds
Memory Before: 1,592.535 KB
Memory After: 1,593.891 KB
Memory Used: 1.355 KB
SELECT text, languageid, special FROM phrase AS phrase LEFT JOIN phrasetype USING (fieldname) WHERE phrase.fieldname = 'error' AND varname = 'no_reason_specified' AND languageid IN (-1, 0, 2)
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|---|---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | phrase | range | name_lang_type,languageid | name_lang_type | 816 | 3 | 100.00 | Using index condition | ||
1 | SIMPLE | phrasetype | eq_ref | PRIMARY | PRIMARY | 60 | mediaworxwfc4d2.phrase.fieldname | 1 | 100.00 | Using where |
Time Before: 0.22438 seconds
Time After: 0.22499 seconds
Time Taken: 0.00062 seconds
Memory Before: 1,593.523 KB
Memory After: 1,594.773 KB
Memory Used: 1.250 KB
SELECT text, languageid, special FROM phrase AS phrase LEFT JOIN phrasetype USING (fieldname) WHERE phrase.fieldname = 'error' AND varname = 'nopermission_banned' AND languageid IN (-1, 0, 2)
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|---|---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | phrase | range | name_lang_type,languageid | name_lang_type | 816 | 3 | 100.00 | Using index condition | ||
1 | SIMPLE | phrasetype | eq_ref | PRIMARY | PRIMARY | 60 | mediaworxwfc4d2.phrase.fieldname | 1 | 100.00 | Using where |
Time Before: 0.22566 seconds
Time After: 0.22626 seconds
Time Taken: 0.00060 seconds
Memory Before: 1,595.082 KB
Memory After: 1,596.332 KB
Memory Used: 1.250 KB
SELECT * FROM style WHERE (styleid = 1 AND userselect = 1) OR styleid = 1 ORDER BY styleid ASC LIMIT 1
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|---|---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | style | const | PRIMARY | PRIMARY | 2 | const | 1 | 100.00 |
Time Before: 0.23054 seconds
Time After: 0.23152 seconds
Time Taken: 0.00098 seconds
Memory Before: 1,676.500 KB
Memory After: 1,677.914 KB
Memory Used: 1.414 KB
SELECT title, template FROM template WHERE templateid IN (1857,1892,1960,1909,1855,1854,1853,2376,2374,1922,1943,1895,1896,1897,1904,1937,1938,1944,1940,1941,1942,1939,1945,1946,1947,1949,1950,1951,1952,1948,1957,1954,1850,2598,2600,1912,1903,1911,980,1823,3156,2831,78,77,79,69,68,75,76,74,73,82,83,84,2575,2860,3159,2525,2522,2523,2524,2868,0,0,2882,2823,2545,2546,2548,2549,2772,2852,2891,2844,2853,2372,2371,2375,2359,2364,2360,2366,2367,2362,2363,2365,2304,2306,2308,2310,2312,2538,2533,2536,2537,2617,2618,2539,2534,2531,2532,2840,1757,0,0,0,0,1001,1195,1284,2198)
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|---|---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | template | range | PRIMARY | PRIMARY | 4 | 106 | 100.00 | Using index condition |
Time Before: 0.23448 seconds
Time After: 0.23634 seconds
Time Taken: 0.00185 seconds
Memory Before: 2,240.137 KB
Memory After: 2,242.211 KB
Memory Used: 2.074 KB
SELECT t.tabid, t.title, t.url,t.tabmode, t.script, t.target, t.pusergroup, t.nusergroup, t.position, t.enable, c.title as ctitle, c.url as curl, c.target as ctarget, c.pusergroup as cpusergroup, c.nusergroup as cnusergroup,c.tipo,c.enable as cenable FROM evbs_sstabs as t LEFT JOIN evbs_sstabs_childs as c ON t.tabid=c.tabid WHERE t.enable=1 ORDER BY t.displayorder,c.tipo, c.displayorder
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|---|---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | t | ALL | 6 | 16.67 | Using where; Using temporary; Using filesort | |||||
1 | SIMPLE | c | ALL | 6 | 100.00 | Using where; Using join buffer (hash join) |
Time Before: 0.24115 seconds
Time After: 0.24183 seconds
Time Taken: 0.00067 seconds
Memory Before: 2,540.457 KB
Memory After: 2,541.879 KB
Memory Used: 1.422 KB
UPDATE session SET lastactivity = 1730811371, location = '/blog.php?explain=1' WHERE sessionhash = '11cc9752377b2c78dde642edf36cd52c'
Time Before: 0.24424 seconds
Time After: 0.24475 seconds
Time Taken: 0.00051 seconds
Memory Before: 2,597.047 KB
Memory After: 2,597.191 KB
Memory Used: 0.145 KB