Habe mal alles was ich unter Debug gefunden habe angemacht und habe dieses bekommen
SQL Queries:
index.php
* 0.0006 - LINE 117: SELECT mid, blocks, version FROM cms_modules WHERE title='News'
modules/News/index.php
* 0.0005 - LINE 85: SELECT COUNT(*) FROM cms_stories s WHERE s.ihome=1
* 0.0015 - LINE 125: SELECT s.*, sc.title AS cattitle, t.topicimage, t.topictext FROM cms_stories AS s LEFT JOIN cms_stories_cat AS sc ON (sc.catid=s.catid) LEFT JOIN cms_topics t ON t.topicid=s.topic WHERE s.ihome=1 ORDER BY display_order DESC, sid DESC LIMIT 0,10
includes/functions/display.php
* 0.0008 - LINE 119: SELECT bid, bposition, bkey, title, content, url, blockfile, view, refresh, time FROM cms_blocks WHERE active='1' ORDER BY weight ASC
blocks/block-CPG_Main_Menu.php
* 0.0011 - LINE 51: SELECT m.title as link, m.custom_title as title, m.view, m.active, m.inmenu, m.cat_id, c.name, c.image, c.pos AS catpos, c.link AS catlnk, c.link_type AS cattype FROM cms_modules AS m LEFT JOIN cms_modules_cat c ON (c.cid = m.cat_id)
* 0.0007 - LINE 61: SELECT l.title, l.link, l.link_type, l.view, l.active, l.cat_id, c.name, c.image, c.pos AS catpos, c.link AS catlnk, c.link_type AS cattype FROM cms_modules_links AS l LEFT JOIN cms_modules_cat c ON (c.cid = l.cat_id)
modules/Downloads/admin/adwait.inc
* 0.0005 - LINE 19: SELECT COUNT(*) FROM cms_downloads_broken
* 0.0004 - LINE 20: SELECT COUNT(*) FROM cms_downloads_downloads WHERE active=2
* 0.0006 - LINE 25: SELECT COUNT(*) FROM cms_downloads_mirrors WHERE active=0
modules/News/admin/adwait.inc
* 0.0004 - LINE 19: SELECT COUNT(*) FROM cms_queue
modules/Web_Links/admin/adwait.inc
* 0.0006 - LINE 20: SELECT COUNT(*) FROM cms_links_newlink
* 0.0004 - LINE 21: SELECT COUNT(*) FROM cms_links_modrequest WHERE brokenlink='1'
* 0.0003 - LINE 22: SELECT COUNT(*) FROM cms_links_modrequest WHERE brokenlink='0'
modules/coppermine/admin/adwait.inc
* 0.0004 - LINE 19: SELECT prefix FROM cms_cpg_installs WHERE dirname = 'coppermine'
* 0.0004 - LINE 20: SELECT dirname FROM cms_cpg_installs WHERE cpg_id=1
* 0.0005 - LINE 22: SELECT COUNT(*) FROM cms_cpg_pictures WHERE approved=0
modules/coppermine/include/load.inc
* 0.0005 - LINE 74: SELECT prefix, dirname FROM cms_cpg_installs ORDER BY cpg_id
includes/coppermine/init.inc
* 0.001 - LINE 52: SELECT * FROM cms_cpg_config
* 0.0011 - LINE 72: SELECT * FROM cms_cpg_usergroups WHERE group_id = 3
blocks/block-CPG_Stats.php
* 0.0005 - LINE 37: SELECT custom_title FROM cms_modules WHERE title='coppermine'
* 0.0003 - LINE 50: SELECT count(*) FROM cms_cpg_pictures WHERE approved=0
includes/coppermine/functions.inc
* 0.0004 - LINE 96: SELECT count(*) FROM cms_cpg_albums
* 0.0003 - LINE 96: SELECT count(*) FROM cms_cpg_pictures
* 0.0003 - LINE 96: SELECT sum(hits) FROM cms_cpg_pictures
* 0.0005 - LINE 96: SELECT sum(votes) FROM cms_cpg_pictures
* 0.0004 - LINE 96: SELECT count(*) FROM cms_cpg_comments
includes/counter.php
* 0.0006 - LINE 34: UPDATE cms_counter SET count=count+1 WHERE (var='Firefox' AND type='browser') OR (var='Windows' AND type='os')
* 0.0005 - LINE 35: UPDATE cms_stats_hour SET hits=hits+1 WHERE (year='2007') AND (month='03') AND (date='14') AND (hour='19')
includes/functions/messagebox.php
* 0.0039 - LINE 27: SELECT mid, title, content, date, expire, view FROM cms_message WHERE active='1' ORDER BY date DESC
blocks/block-ForumsPro-center-Last_5_Posted_Topics.php
* 0.0012 - LINE 63: SELECT t.*, u.username, u.user_id, u2.username as user2, u2.user_id as id2, p.post_username, p2.post_username AS post_username2, p2.post_time, pt.post_subject FROM cms_fpro_topics t, cms_users u, cms_fpro_posts p, cms_fpro_posts p2, cms_users u2, cms_fpro_posts_text pt WHERE t.forum_id IN (3, 4, 6, 1, 2, 5) AND t.topic_poster = u.user_id AND p.post_id = t.topic_first_post_id AND p2.post_id = t.topic_last_post_id AND u2.user_id = p2.poster_id AND pt.post_id = t.topic_last_post_id ORDER BY t.topic_last_post_id DESC LIMIT 0, 5
modules/News/functions.php
* 0.0011 - LINE 20: SELECT * FROM cms_autonews WHERE time<=1173893222
includes/nbbcode.php
* 0.0009 - LINE 254: SELECT * FROM cms_bbsmilies
blocks/block-User_Info.php
* 0.001 - LINE 29: SELECT s.uname, s.module, s.url, u.user_allow_viewonline FROM cms_session AS s LEFT JOIN cms_users AS u ON u.username=s.uname WHERE guest=0 OR guest=2 ORDER BY s.uname
* 0.0018 - LINE 30: SELECT uname, module, url FROM cms_session WHERE guest=1 OR guest=3
* 0.0009 - LINE 97: SELECT COUNT(*) FROM cms_users WHERE user_regdate>='1173823200'
* 0.0006 - LINE 98: SELECT COUNT(*) FROM cms_users WHERE user_regdate<'1173823200' AND user_regdate>='1173736800'
* 0.0006 - LINE 99: SELECT username FROM cms_users WHERE user_active = 1 AND user_level > 0 ORDER BY user_id DESC LIMIT 1
* 0.0006 - LINE 100: SELECT COUNT(*) FROM cms_users WHERE user_id > 1 AND user_level > 0
* 0.0008 - LINE 125: SELECT a.uname, u.user_id FROM cms_session AS a LEFT JOIN cms_users AS u ON u.username = a.uname WHERE guest = 2 ORDER BY a.uname
blocks/block-Survey.php
* 0.0007 - LINE 27: SELECT poll_id, poll_title, voters FROM cms_poll_desc WHERE artid=0 ORDER BY poll_id DESC LIMIT 0,1
blocks/block-New_Downloads.php
* 0.0008 - LINE 29: SELECT lid, title FROM cms_downloads_downloads WHERE active=1 ORDER BY date DESC LIMIT 0,10
blocks/block-ForumsPro-Last_10_Posts.php
* 0.001 - LINE 63: SELECT t.*, f.forum_id, f.forum_name, u.username, u.user_id, u2.username as user2, u2.user_id as id2, p.post_username, p2.post_username AS post_username2, p2.post_time, pt.post_subject FROM cms_fpro_topics t, cms_fpro_forums f, cms_users u, cms_fpro_posts p, cms_fpro_posts p2, cms_users u2, cms_fpro_posts_text pt WHERE t.forum_id IN (3, 4, 6, 1, 2, 5) AND t.topic_poster = u.user_id AND f.forum_id = t.forum_id AND p.post_id = t.topic_first_post_id AND p2.post_id = t.topic_last_post_id AND u2.user_id = p2.poster_id AND pt.post_id = t.topic_last_post_id ORDER BY t.topic_last_post_id DESC LIMIT 0, 10
language/german/news.php
* Notice line 114: Constant _EXTENDEDTEXT already defined
* Notice line 118: Constant _STORYTEXT already defined
* Notice line 119: Constant _ARESUREURL already defined
admin/links/adlnk_main.php
* Notice line 21: Use of undefined constant _HELP_LINK - assumed '_HELP_LINK'
blocks/block-ForumsPro-center-Last_5_Posted_Topics.php
* CMS Notice line 72: There are no forum posts
blocks/block-ForumsPro-Last_10_Posts.php
* CMS Notice line 72: There are no forum posts
nussi's Serverdaten - verwendete Vers. (Server OS / Apache / MySQL / PHP / DragonflyCMS) ftp/phpmyadmin/Mysql5.0/cpg Dragonfly 9.X |