Code: Select all
[phpBB Debug] PHP Notice: in file /portal/block/user_menu.php on line 94: Undefined index: SEARCH_UNREAD
[phpBB Debug] PHP Notice: in file /portal/block/mini_cal.php on line 95: Undefined index: VIEW_PREVIOUS_MONTH
[phpBB Debug] PHP Notice: in file /portal/block/mini_cal.php on line 96: Undefined index: VIEW_NEXT_MONTH
[phpBB Debug] PHP Notice: in file /includes/functions.php on line 3853: Cannot modify header information - headers already sent by (output started at /includes/functions.php:3247)
[phpBB Debug] PHP Notice: in file /includes/functions.php on line 3855: Cannot modify header information - headers already sent by (output started at /includes/functions.php:3247)
[phpBB Debug] PHP Notice: in file /includes/functions.php on line 3856: Cannot modify header information - headers already sent by (output started at /includes/functions.php:3247)
[phpBB Debug] PHP Notice: in file /includes/functions.php on line 3857: Cannot modify header information - headers already sent by (output started at /includes/functions.php:3247)
Return to previous page
SQL Report
Page generated in 1.7905 seconds with 49 queries + 5 queries returning data from cache
Time spent on mysqli queries: 0.05348s | Time spent on PHP: 1.73705s
Query #1
SELECT config_name, config_value FROM phpbb_config WHERE is_dynamic = 1
Id Select Type Table Type Possible Keys Key Key Len Ref Rows Extra
1 SIMPLE phpbb_config ref is_dynamic is_dynamic 1 const 21
Before: 0.35737s | After: 0.35833s | Elapsed: 0.00096s
Query #2
SELECT config_name, config_value FROM phpbb_portal_config
Id Select Type Table Type Possible Keys Key Key Len Ref Rows Extra
1 SIMPLE phpbb_portal_config ALL 97
Before: 0.47152s | After: 0.47253s | Elapsed: 0.00101s
Query #3
SELECT u.*, s.* FROM phpbb_sessions s, phpbb_users u WHERE s.session_id = '2d1fbfbe7628afc6b7c3816d5cddde8a' AND u.user_id = s.session_user_id
Id Select Type Table Type Possible Keys Key Key Len Ref Rows Extra
1 SIMPLE s const PRIMARY,session_user_id PRIMARY 96 const 1
1 SIMPLE u const PRIMARY PRIMARY 3 const 1
Before: 0.48289s | After: 0.48473s | Elapsed: 0.00184s
Query #4
UPDATE phpbb_sessions SET session_time = 1274906340, session_page = 'portal.php?&explain=1', session_forum_id = 0 WHERE session_id = '2d1fbfbe7628afc6b7c3816d5cddde8a'
Id Select Type Table Type Possible Keys Key Key Len Ref Rows Extra
1 SIMPLE phpbb_sessions const PRIMARY PRIMARY 96 const 1
Affected rows: 1 | Before: 0.50148s | After: 0.50239s | Elapsed: 0.00091s
Query #5
UPDATE phpbb_users SET user_online_time = 590336 WHERE user_id = 2
Id Select Type Table Type Possible Keys Key Key Len Ref Rows Extra
1 SIMPLE phpbb_users const PRIMARY PRIMARY 3 const 1
Affected rows: 1 | Before: 0.50465s | After: 0.50545s | Elapsed: 0.00080s
Query results obtained from the cache
SELECT s.style_id, t.template_storedb, t.template_path, t.template_id, t.bbcode_bitfield, t.template_inherits_id, t.template_inherit_path, c.theme_path, c.theme_name, c.theme_storedb, c.theme_id, i.imageset_path, i.imageset_id, i.imageset_name FROM phpbb_styles s, phpbb_styles_template t, phpbb_styles_theme c, phpbb_styles_imageset i WHERE s.style_id = 23 AND t.template_id = s.template_id AND c.theme_id = s.theme_id AND i.imageset_id = s.imageset_id
Before: 0.55709s | After: 0.56193s | Elapsed [cache]: 0.00483s | Elapsed [db]: 0.00088s
Query results obtained from the cache
SELECT * FROM phpbb_styles_imageset_data WHERE imageset_id = 18 AND image_filename <> '' AND image_lang IN ('de', '')
Before: 0.57645s | After: 0.58673s | Elapsed [cache]: 0.01028s | Elapsed [db]: 0.00369s
Query #8
SELECT forum_id FROM phpbb_forums WHERE forum_id NOT IN (0, 21, 22, 23, 24, 25, 27, 28, 29, 30, 31, 32, 33, 34, 35, 36, 37, 38, 39, 40, 41, 42, 43, 44, 45, 46, 47, 48, 49, 50, 51, 52, 53, 54, 55, 62, 63, 64, 65, 66, 67, 68)
Id Select Type Table Type Possible Keys Key Key Len Ref Rows Extra
1 SIMPLE phpbb_forums index PRIMARY PRIMARY 3 41 Using where; Using index
Before: 0.60394s | After: 0.60476s | Elapsed: 0.00082s
Query #9
SELECT forum_id FROM phpbb_forums WHERE forum_type = 1 LIMIT 1
Id Select Type Table Type Possible Keys Key Key Len Ref Rows Extra
1 SIMPLE phpbb_forums ALL 41 Using where
Before: 0.61004s | After: 0.61092s | Elapsed: 0.00087s
Query #10
SELECT topic_title, forum_id, topic_id FROM phpbb_topics t WHERE topic_status <> 2 AND topic_approved = 1 AND (topic_type = 2 OR topic_type = 3) AND topic_moved_id = 0 ORDER BY topic_time DESC LIMIT 10
Id Select Type Table Type Possible Keys Key Key Len Ref Rows Extra
1 SIMPLE t ref topic_approved topic_approved 1 const 117 Using where; Using filesort
Before: 0.61360s | After: 0.61457s | Elapsed: 0.00097s
Query #11
SELECT topic_title, forum_id, topic_id FROM phpbb_topics t WHERE topic_approved = 1 AND topic_replies >=25 AND topic_moved_id = 0 ORDER BY topic_time DESC LIMIT 10
Id Select Type Table Type Possible Keys Key Key Len Ref Rows Extra
1 SIMPLE t ref topic_approved topic_approved 1 const 117 Using where; Using filesort
Before: 0.62323s | After: 0.62386s | Elapsed: 0.00063s
Query #12
SELECT topic_title, forum_id, topic_id FROM phpbb_topics t WHERE topic_status <> 2 AND topic_approved = 1 AND topic_type = 0 AND topic_moved_id = 0 ORDER BY topic_time DESC LIMIT 10
Id Select Type Table Type Possible Keys Key Key Len Ref Rows Extra
1 SIMPLE t ref topic_approved topic_approved 1 const 117 Using where; Using filesort
Before: 0.62651s | After: 0.62733s | Elapsed: 0.00082s
Query #13
SELECT t.poll_title, t.poll_start, t.topic_id, t.topic_first_post_id, t.forum_id, t.poll_length, t.poll_vote_change, t.poll_max_options, t.topic_status, f.forum_status, p.bbcode_bitfield, p.bbcode_uid FROM phpbb_topics t, phpbb_posts p, phpbb_forums f WHERE t.forum_id = f.forum_id AND t.topic_approved = 1 AND t.poll_start > 0 AND t.forum_id IN (21, 22, 23, 24, 25, 27, 28, 29, 30, 31, 32, 33, 34, 35, 36, 37, 38, 39, 40, 41, 42, 43, 44, 45, 46, 47, 48, 49, 50, 51, 52, 53, 54, 55, 62, 63, 64, 65, 66, 67, 68) AND t.topic_moved_id = 0 AND p.post_id = t.topic_first_post_id AND (t.poll_start + t.poll_length > 1274906340 OR t.poll_length = 0) ORDER BY t.poll_start DESC LIMIT 3
Id Select Type Table Type Possible Keys Key Key Len Ref Rows Extra
1 SIMPLE t ref forum_id,forum_id_type,topic_approved,forum_appr_last,fid_time_moved topic_approved 1 const 117 Using where; Using filesort
1 SIMPLE f eq_ref PRIMARY PRIMARY 3 DB556056.t.forum_id 1
1 SIMPLE p eq_ref PRIMARY PRIMARY 3 DB556056.t.topic_first_post_id 1
Before: 0.66106s | After: 0.66499s | Elapsed: 0.00393s
Query #14
UPDATE phpbb_config SET config_value = '5f10690b12083f264c4fd49de496f81b' WHERE config_name = 'rand_seed'
Id Select Type Table Type Possible Keys Key Key Len Ref Rows Extra
1 SIMPLE phpbb_config const PRIMARY PRIMARY 767 const 1
Affected rows: 1 | Before: 0.67206s | After: 0.67281s | Elapsed: 0.00075s
Query #15
UPDATE phpbb_config SET config_value = '1274906340' WHERE config_name = 'rand_seed_last_update'
Id Select Type Table Type Possible Keys Key Key Len Ref Rows Extra
1 SIMPLE phpbb_config const PRIMARY PRIMARY 767 const 1
Affected rows: 1 | Before: 0.67489s | After: 0.67572s | Elapsed: 0.00082s
Query #16
SELECT * FROM phpbb_bbcodes
Id Select Type Table Type Possible Keys Key Key Len Ref Rows Extra
1 SIMPLE phpbb_bbcodes ALL 2
Before: 0.67852s | After: 0.67932s | Elapsed: 0.00080s
Query results obtained from the cache
SELECT * FROM phpbb_smilies ORDER BY LENGTH(code) DESC
Before: 0.70929s | After: 0.71553s | Elapsed [cache]: 0.00624s | Elapsed [db]: 0.00241s
Query results obtained from the cache
SELECT * FROM phpbb_bbcodes WHERE bbcode_id = 13
Before: 1.19448s | After: 1.20283s | Elapsed [cache]: 0.00835s | Elapsed [db]: 0.00099s
Query #19
SELECT t.forum_id, t.topic_id, t.topic_last_post_id, t.topic_last_post_time, t.topic_time, t.topic_title, t.topic_attachment, t.topic_views, t.poll_title, t.topic_replies, t.topic_replies_real, t.topic_poster, t.topic_type, t.topic_status, t.topic_last_poster_name, t.topic_last_poster_id, t.topic_last_poster_colour, t.icon_id, u.username, u.user_id, u.user_type, u.user_colour, p.post_id, p.poster_id, p.post_time, p.post_text, p.post_attachment, p.post_username, p.enable_smilies, p.enable_bbcode, p.enable_magic_url, p.bbcode_bitfield, p.bbcode_uid, f.forum_name, f.enable_icons, tp.topic_posted FROM (phpbb_topics t) LEFT JOIN phpbb_users u ON (t.topic_poster = u.user_id) LEFT JOIN phpbb_forums f ON (t.forum_id=f.forum_id) LEFT JOIN phpbb_posts p ON (t.topic_first_post_id = p.post_id) LEFT JOIN phpbb_topics_posted tp ON (tp.topic_id = t.topic_id AND tp.user_id = 2) WHERE (t.topic_type <> 2) AND (t.topic_type <> 3) AND t.topic_status <> 2 AND t.topic_approved = 1 AND t.topic_moved_id = 0 AND (t.forum_id = 27 OR t.forum_id = 28 OR t.forum_id = 29 OR t.forum_id = 30 OR t.forum_id = 31 OR t.forum_id = 32 OR t.forum_id = 33 OR t.forum_id = 34 OR t.forum_id = 35 OR t.forum_id = 36 OR t.forum_id = 37 OR t.forum_id = 38 OR t.forum_id = 50 OR t.forum_id = 51 OR t.forum_id = 52 OR t.forum_id = 53 OR t.forum_id = 54 OR t.forum_id = 55) ORDER BY t.topic_last_post_time DESC LIMIT 5
Id Select Type Table Type Possible Keys Key Key Len Ref Rows Extra
1 SIMPLE t ref forum_id,forum_id_type,topic_approved,forum_appr_last,fid_time_moved topic_approved 1 const 117 Using where; Using filesort
1 SIMPLE u eq_ref PRIMARY PRIMARY 3 DB556056.t.topic_poster 1
1 SIMPLE f eq_ref PRIMARY PRIMARY 3 DB556056.t.forum_id 1
1 SIMPLE p eq_ref PRIMARY PRIMARY 3 DB556056.t.topic_first_post_id 1
1 SIMPLE tp eq_ref PRIMARY PRIMARY 6 const,DB556056.t.topic_id 1
Before: 1.23902s | After: 1.24410s | Elapsed: 0.00508s
Query #20
SELECT * FROM phpbb_attachments WHERE post_msg_id = 2131 AND in_message = 0 ORDER BY filetime DESC
Id Select Type Table Type Possible Keys Key Key Len Ref Rows Extra
1 SIMPLE Impossible WHERE noticed after reading const tables
Before: 1.24739s | After: 1.24815s | Elapsed: 0.00076s
Query #21
SELECT * FROM phpbb_attachments WHERE post_msg_id = 2099 AND in_message = 0 ORDER BY filetime DESC
Id Select Type Table Type Possible Keys Key Key Len Ref Rows Extra
1 SIMPLE Impossible WHERE noticed after reading const tables
Before: 1.25237s | After: 1.25317s | Elapsed: 0.00079s
Query #22
SELECT * FROM phpbb_attachments WHERE post_msg_id = 2102 AND in_message = 0 ORDER BY filetime DESC
Id Select Type Table Type Possible Keys Key Key Len Ref Rows Extra
1 SIMPLE Impossible WHERE noticed after reading const tables
Before: 1.27219s | After: 1.27300s | Elapsed: 0.00080s
Query #23
SELECT * FROM phpbb_attachments WHERE post_msg_id = 2118 AND in_message = 0 ORDER BY filetime DESC
Id Select Type Table Type Possible Keys Key Key Len Ref Rows Extra
1 SIMPLE Impossible WHERE noticed after reading const tables
Before: 1.28181s | After: 1.28279s | Elapsed: 0.00098s
Query #24
SELECT * FROM phpbb_attachments WHERE post_msg_id = 2103 AND in_message = 0 ORDER BY filetime DESC
Id Select Type Table Type Possible Keys Key Key Len Ref Rows Extra
1 SIMPLE Impossible WHERE noticed after reading const tables
Before: 1.29690s | After: 1.29797s | Elapsed: 0.00107s
Query #25
SELECT topic_id, mark_time FROM phpbb_topics_track WHERE user_id = 2 AND topic_id = '503'
Id Select Type Table Type Possible Keys Key Key Len Ref Rows Extra
1 SIMPLE Impossible WHERE noticed after reading const tables
Before: 1.30903s | After: 1.30977s | Elapsed: 0.00074s
Query #26
SELECT forum_id, mark_time FROM phpbb_forums_track WHERE user_id = 2 AND forum_id = 31
Id Select Type Table Type Possible Keys Key Key Len Ref Rows Extra
1 SIMPLE phpbb_forums_track const PRIMARY PRIMARY 6 const,const 1
Before: 1.31212s | After: 1.31418s | Elapsed: 0.00206s
Query #27
SELECT topic_id, mark_time FROM phpbb_topics_track WHERE user_id = 2 AND topic_id = '498'
Id Select Type Table Type Possible Keys Key Key Len Ref Rows Extra
1 SIMPLE Impossible WHERE noticed after reading const tables
Before: 1.32433s | After: 1.32528s | Elapsed: 0.00096s
Query #28
SELECT forum_id, mark_time FROM phpbb_forums_track WHERE user_id = 2 AND forum_id = 33
Id Select Type Table Type Possible Keys Key Key Len Ref Rows Extra
1 SIMPLE phpbb_forums_track const PRIMARY PRIMARY 6 const,const 1
Before: 1.32877s | After: 1.32990s | Elapsed: 0.00114s
Query #29
SELECT topic_id, mark_time FROM phpbb_topics_track WHERE user_id = 2 AND topic_id = '500'
Id Select Type Table Type Possible Keys Key Key Len Ref Rows Extra
1 SIMPLE Impossible WHERE noticed after reading const tables
Before: 1.34051s | After: 1.34111s | Elapsed: 0.00060s
Query #30
SELECT forum_id, mark_time FROM phpbb_forums_track WHERE user_id = 2 AND forum_id = 33
Id Select Type Table Type Possible Keys Key Key Len Ref Rows Extra
1 SIMPLE phpbb_forums_track const PRIMARY PRIMARY 6 const,const 1
Before: 1.34281s | After: 1.34350s | Elapsed: 0.00068s
Query #31
SELECT topic_id, mark_time FROM phpbb_topics_track WHERE user_id = 2 AND topic_id = '502'
Id Select Type Table Type Possible Keys Key Key Len Ref Rows Extra
1 SIMPLE Impossible WHERE noticed after reading const tables
Before: 1.35252s | After: 1.35343s | Elapsed: 0.00091s
Query #32
SELECT forum_id, mark_time FROM phpbb_forums_track WHERE user_id = 2 AND forum_id = 33
Id Select Type Table Type Possible Keys Key Key Len Ref Rows Extra
1 SIMPLE phpbb_forums_track const PRIMARY PRIMARY 6 const,const 1
Before: 1.35504s | After: 1.35573s | Elapsed: 0.00069s
Query #33
SELECT topic_id, mark_time FROM phpbb_topics_track WHERE user_id = 2 AND topic_id = '501'
Id Select Type Table Type Possible Keys Key Key Len Ref Rows Extra
1 SIMPLE Impossible WHERE noticed after reading const tables
Before: 1.36435s | After: 1.36502s | Elapsed: 0.00067s
Query #34
SELECT forum_id, mark_time FROM phpbb_forums_track WHERE user_id = 2 AND forum_id = 33
Id Select Type Table Type Possible Keys Key Key Len Ref Rows Extra
1 SIMPLE phpbb_forums_track const PRIMARY PRIMARY 6 const,const 1
Before: 1.36665s | After: 1.36728s | Elapsed: 0.00063s
Query #35
SELECT group_id, group_name, group_colour, group_type FROM phpbb_groups WHERE group_legend = 1 ORDER BY group_name ASC
Id Select Type Table Type Possible Keys Key Key Len Ref Rows Extra
1 SIMPLE phpbb_groups ref group_legend_name group_legend_name 1 const 2 Using where
Before: 1.38609s | After: 1.38697s | Elapsed: 0.00088s
Query #36
SELECT u.user_id, u.username, u.user_colour, u.user_birthday FROM phpbb_users u LEFT JOIN phpbb_banlist b ON (u.user_id = b.ban_userid) WHERE (b.ban_id IS NULL OR b.ban_exclude = 1) AND (u.user_birthday LIKE '26- 5-%' OR u.user_birthday LIKE ' 2- 6-%' OR u.user_birthday LIKE ' 1- 6-%' OR u.user_birthday LIKE '31- 5-%' OR u.user_birthday LIKE '30- 5-%' OR u.user_birthday LIKE '29- 5-%' OR u.user_birthday LIKE '28- 5-%' OR u.user_birthday LIKE '27- 5-%') AND u.user_type IN (0, 3) ORDER BY SUBSTRING(u.user_birthday FROM 4 FOR 2) ASC, SUBSTRING(u.user_birthday FROM 1 FOR 2) ASC, u.username_clean ASC
Id Select Type Table Type Possible Keys Key Key Len Ref Rows Extra
1 SIMPLE u range user_birthday,user_type user_birthday 32 8 Using where; Using filesort
1 SIMPLE b ref ban_user ban_user 3 DB556056.u.user_id 1 Using where
Before: 1.41562s | After: 1.41691s | Elapsed: 0.00129s
Query #37
SELECT user_id, username, user_posts, user_colour FROM phpbb_users WHERE user_type <> 2 AND user_posts <> 0 ORDER BY user_posts DESC LIMIT 8
Id Select Type Table Type Possible Keys Key Key Len Ref Rows Extra
1 SIMPLE phpbb_users range user_type user_type 1 33 Using where; Using filesort
Before: 1.42540s | After: 1.42694s | Elapsed: 0.00153s
Query #38
SELECT user_id, username, user_regdate, user_colour FROM phpbb_users WHERE user_type <> 2 AND user_inactive_time = 0 ORDER BY user_regdate DESC LIMIT 8
Id Select Type Table Type Possible Keys Key Key Len Ref Rows Extra
1 SIMPLE phpbb_users range user_type user_type 1 33 Using where; Using filesort
Before: 1.44461s | After: 1.44625s | Elapsed: 0.00163s
Query #39
SELECT style_id, style_name FROM phpbb_styles WHERE style_active = 1 ORDER BY LOWER(style_name) ASC
Id Select Type Table Type Possible Keys Key Key Len Ref Rows Extra
1 SIMPLE phpbb_styles ALL 6 Using where; Using filesort
Before: 1.46690s | After: 1.46773s | Elapsed: 0.00083s
Query #40
SELECT style_id, style_name FROM phpbb_styles WHERE style_active = 1 ORDER BY style_name
Id Select Type Table Type Possible Keys Key Key Len Ref Rows Extra
1 SIMPLE phpbb_styles ALL 6 Using where; Using filesort
Before: 1.47048s | After: 1.47120s | Elapsed: 0.00072s
Query #41
SELECT COUNT(distinct t.topic_id) as total FROM phpbb_topics t WHERE t.topic_last_post_time > 1274893343 AND t.topic_moved_id = 0
Id Select Type Table Type Possible Keys Key Key Len Ref Rows Extra
1 SIMPLE t range last_post_time last_post_time 4 8 Using where
Before: 1.48812s | After: 1.48890s | Elapsed: 0.00079s
Query #42
SELECT user_posts FROM phpbb_users WHERE user_id = 2
Id Select Type Table Type Possible Keys Key Key Len Ref Rows Extra
1 SIMPLE phpbb_users const PRIMARY PRIMARY 3 const 1
Before: 1.49113s | After: 1.49205s | Elapsed: 0.00092s
Query #43
SELECT COUNT(distinct t.topic_id) AS announcement_total FROM phpbb_topics t, phpbb_posts p WHERE t.topic_type = 2 AND p.post_id = t.topic_first_post_id
Id Select Type Table Type Possible Keys Key Key Len Ref Rows Extra
1 SIMPLE t ALL 118 Using where
1 SIMPLE p eq_ref PRIMARY PRIMARY 3 DB556056.t.topic_first_post_id 1 Using index
Before: 1.51680s | After: 1.51751s | Elapsed: 0.00071s
Query #44
SELECT COUNT(distinct t.topic_id) AS sticky_total FROM phpbb_topics t, phpbb_posts p WHERE t.topic_type = 1 AND p.post_id = t.topic_first_post_id
Id Select Type Table Type Possible Keys Key Key Len Ref Rows Extra
1 SIMPLE t ALL 118 Using where
1 SIMPLE p eq_ref PRIMARY PRIMARY 3 DB556056.t.topic_first_post_id 1 Using index
Before: 1.52008s | After: 1.52135s | Elapsed: 0.00126s
Query #45
SELECT COUNT(attach_id) AS attachments_total FROM phpbb_attachments
Id Select Type Table Type Possible Keys Key Key Len Ref Rows Extra
1 SIMPLE Select tables optimized away
Before: 1.52356s | After: 1.52437s | Elapsed: 0.00080s
Query #46
SELECT group_id, group_name, group_colour, group_type FROM phpbb_groups WHERE group_legend = 1 ORDER BY group_name ASC
Id Select Type Table Type Possible Keys Key Key Len Ref Rows Extra
1 SIMPLE phpbb_groups ref group_legend_name group_legend_name 1 const 2 Using where
Before: 1.58460s | After: 1.58542s | Elapsed: 0.00082s
Query #47
SELECT u.user_id, u.username, u.user_colour, u.group_id FROM phpbb_users AS u WHERE u.group_id IN ('4', '10') ORDER BY u.username ASC
Id Select Type Table Type Possible Keys Key Key Len Ref Rows Extra
1 SIMPLE u ALL 82 Using where; Using filesort
Before: 1.58824s | After: 1.58940s | Elapsed: 0.00116s
Query #48
SELECT DISTINCT u.user_id, u.username, u.username_clean, u.user_colour, u.user_allow_viewonline, MAX(s.session_time) as online_time, MIN(s.session_viewonline) AS viewonline FROM (phpbb_users u, phpbb_zebra z) LEFT JOIN phpbb_sessions s ON (s.session_user_id = z.zebra_id) WHERE z.user_id = 2 AND z.friend = 1 AND u.user_id = z.zebra_id GROUP BY z.zebra_id, u.user_id, u.username, u.username_clean, u.user_allow_viewonline, u.user_colour ORDER BY u.username_clean ASC LIMIT 8
Id Select Type Table Type Possible Keys Key Key Len Ref Rows Extra
1 SIMPLE Impossible WHERE noticed after reading const tables
Before: 1.59685s | After: 1.59778s | Elapsed: 0.00093s
Query #49
SELECT COUNT(DISTINCT s.session_ip) as num_guests FROM phpbb_sessions s WHERE s.session_user_id = 1 AND s.session_time >= 1274906040
Id Select Type Table Type Possible Keys Key Key Len Ref Rows Extra
1 SIMPLE s ref session_time,session_user_id session_user_id 3 const 6 Using where
Before: 1.60788s | After: 1.60899s | Elapsed: 0.00112s
Query #50
SELECT s.session_user_id, s.session_ip, s.session_viewonline FROM phpbb_sessions s WHERE s.session_time >= 1274906040 AND s.session_user_id <> 1
Id Select Type Table Type Possible Keys Key Key Len Ref Rows Extra
1 SIMPLE s range session_time,session_user_id session_time 4 5 Using where
Before: 1.61102s | After: 1.61180s | Elapsed: 0.00078s
Query #51
SELECT username, username_clean, user_id, user_type, user_allow_viewonline, user_colour FROM phpbb_users WHERE user_id IN (2, 55) ORDER BY username_clean ASC
Id Select Type Table Type Possible Keys Key Key Len Ref Rows Extra
1 SIMPLE phpbb_users range PRIMARY PRIMARY 3 2 Using where; Using filesort
Before: 1.61438s | After: 1.61544s | Elapsed: 0.00106s
Query #52
SELECT * FROM phpbb_portal_config LIMIT 1
Id Select Type Table Type Possible Keys Key Key Len Ref Rows Extra
1 SIMPLE phpbb_portal_config ALL 97
Before: 1.69975s | After: 1.70052s | Elapsed: 0.00077s
Query #53
SELECT config_name, config_value FROM phpbb_portal_config
Id Select Type Table Type Possible Keys Key Key Len Ref Rows Extra
1 SIMPLE phpbb_portal_config ALL 97
Before: 1.70252s | After: 1.70350s | Elapsed: 0.00097s
Query results obtained from the cache
SELECT forum_id, forum_name, parent_id, forum_type, left_id, right_id FROM phpbb_forums ORDER BY left_id ASC
Before: 1.74689s | After: 1.75423s | Elapsed [cache]: 0.00734s | Elapsed [db]: 0.00212s
Powered by phpBB © 2000, 2002, 2005, 2007 phpBB Group
Solltest du daraus nich schlau werden und doch nen screenshot wünschen. Bescheid sagen
Tante €dit: beim screenshot würdest du jedoch nur die ersten 5 zeilens ehen. alle anderen sachen sind NICHT sichtbar auf dem screenshot!
