phpBB.de

Code: Alles auswählen

Page generated in 8.3718 seconds with 13 queries + 3 queries returning data from cache

Time spent on mysql4 queries: 0.63221s | Time spent on PHP: 7.73956s

// Removed - bantu

Code: Alles auswählen

Page generated in 1.5406 seconds with 9 queries + 3 queries returning data from cache

Time spent on mysql4 queries: 0.01843s | Time spent on PHP: 1.52213s



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 25   

Before: 0.70837s | After: 0.70948s | Elapsed: 0.00111s



Query #2 
SELECT u.*, s.*
FROM phpbb_sessions s, phpbb_users u
WHERE s.session_id = '141341e5212a55249496fd2e4c83696b'
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.85109s | After: 0.85353s | Elapsed: 0.00244s



Query #3 
UPDATE phpbb_sessions SET session_time = 1199985884, session_page = 'index.php?&explain=1'
WHERE session_id = '141341e5212a55249496fd2e4c83696b' 
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.87828s | After: 0.87987s | Elapsed: 0.00160s



Query results obtained from the cache 
SELECT s.style_id, t.template_storedb, t.template_path, t.template_id, t.bbcode_bitfield, 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 = 3
AND t.template_id = s.template_id
AND c.theme_id = s.theme_id
AND i.imageset_id = s.imageset_id 

Before: 1.16757s | After: 1.17038s | Elapsed [cache]: 0.00281s | Elapsed [db]: 0.00098s



Query results obtained from the cache 
SELECT image_name, image_filename, image_lang, image_height, image_width
FROM phpbb_styles_imageset_data
WHERE imageset_id = 3
AND image_lang IN ('de', '') 

Before: 1.22986s | After: 1.25185s | Elapsed [cache]: 0.02200s | Elapsed [db]: 0.00438s



Query #6 
SELECT f.*, ft.mark_time, t.topic_title, t.topic_id, t.topic_last_post_id FROM (phpbb_forums f) LEFT JOIN phpbb_forums_track ft ON (ft.user_id = 1015 AND ft.forum_id = f.forum_id) LEFT JOIN phpbb_topics t ON (f.forum_last_post_id = t.topic_last_post_id) ORDER BY f.left_id 
Id Select Type Table Type Possible Keys Key Key Len Ref Rows Extra 
1 SIMPLE f ALL         15 Using filesort 
1 SIMPLE ft eq_ref PRIMARY PRIMARY 6 const,DB241650.f.forum_id 1   
1 SIMPLE t ref topic_last_post_id topic_last_post_id 3 DB241650.f.forum_last_post_id 1   

Before: 1.26345s | After: 1.26512s | Elapsed: 0.00167s



Query results obtained from the cache 
SELECT m.*, u.user_colour, g.group_colour, g.group_type FROM (phpbb_moderator_cache m) LEFT JOIN phpbb_users u ON (m.user_id = u.user_id) LEFT JOIN phpbb_groups g ON (m.group_id = g.group_id) WHERE m.display_on_index = 1 AND m.forum_id IN (1, 2, 8, 6, 11, 5, 9, 7) 

Before: 1.28599s | After: 1.29430s | Elapsed [cache]: 0.00830s | Elapsed [db]: 0.00256s



Query #8 
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 group_legend 1 const 4 Using where; Using filesort 

Before: 1.38694s | After: 1.38793s | Elapsed: 0.00099s



Query #9 
SELECT user_id, username, user_colour, user_birthday
FROM phpbb_users
WHERE user_birthday LIKE '10- 1-%'
AND user_type IN (0, 3) 
Id Select Type Table Type Possible Keys Key Key Len Ref Rows Extra 
1 SIMPLE phpbb_users range user_birthday,user_type user_birthday 32   1 Using where 

Before: 1.39520s | After: 1.39837s | Elapsed: 0.00318s



Query #10 
SELECT u.username, u.username_clean, u.user_id, u.user_type, u.user_allow_viewonline, u.user_colour, s.session_ip, s.session_viewonline
FROM phpbb_users u, phpbb_sessions s
WHERE s.session_time >= 1199985585
AND u.user_id = s.session_user_id
AND (u.user_type <> 2
OR u.user_id = 1)
ORDER BY u.username_clean ASC, s.session_ip ASC 
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   7 Using where; Using temporary; Using filesort 
1 SIMPLE u eq_ref PRIMARY,user_type PRIMARY 3 DB241650.s.session_user_id 1 Using where 

Before: 1.40724s | After: 1.40895s | Elapsed: 0.00172s



Query #11 
SELECT code, ID, position FROM phpbb_ad
WHERE (max_views >= views OR max_views = '0')
AND (FIND_IN_SET(0, show_forums) > 0 OR show_all_forums = '1')
AND FIND_IN_SET(461, groups)
ORDER BY rand() 
Id Select Type Table Type Possible Keys Key Key Len Ref Rows Extra 
1 SIMPLE phpbb_ad ALL         11 Using where; Using temporary; Using filesort 

Before: 1.49293s | After: 1.49736s | Elapsed: 0.00443s



Query #12 
UPDATE phpbb_ad SET views = views +1 WHERE ID = 2 
Id Select Type Table Type Possible Keys Key Key Len Ref Rows Extra 
1 SIMPLE phpbb_ad const PRIMARY PRIMARY 4 const 1   

Affected rows: 1 | Before: 1.50386s | After: 1.50516s | Elapsed: 0.00130s