Gefragt.net - Deutsche Fragen und Antworten Community

Neue Funktion verfügbar: Benutzergruppen!
Erstelle eigene Gruppen, teile Inhalte und vernetze dich mit anderen Mitgliedern. ➜ Jetzt ansehen

	Total		PHP			MySQL			Other		RAM
	Time (ms)	%	Time (ms)	%	File count	Time (ms)	%	Query count	Time (ms)	%	Amount	%
Setup	69.3	33%	65.5	31%	113	6.3	3%	3	0.0	0%	3003k	51%
Control	0.1	0%	0.1	0%	0	0.0	0%	0	0.0	0%	16k	0%
View	57.8	27%	57.0	27%	15	0.3	0%	1	0.5	0%	506k	8%
Theme	69.6	33%	58.7	28%	39	11.5	5%	23	0.0	0%	1971k	33%
Total	206.9	100%	185.0	89%	172	24.8	11%	33	0.0	0%	5804k	100%

werbespass.ch/httpdocs/index.php
httpdocs/qa-include/qa-index.php
httpdocs/qa-include/qa-base.php
werbespass.ch/httpdocs/qa-config.php
qa-include/vendor/password_compat.php
Q2A/Util/Usage.php
Q2A/Plugin/PluginManager.php
Q2A/Util/Metadata.php
qa-plugin/ai-integration/qa-plugin.php
qa-plugin/answer-feedback/qa-plugin.php
qa-plugin/answer-feedback/qa-feedback-util.php
qa-plugin/comment-voting/qa-plugin.php
qa-plugin/ganbox-async-adsense-master/qa-plugin.php
qa-plugin/groups/qa-plugin.php
qa-plugin/history/qa-plugin.php
qa-plugin/permission2categories-master/qa-plugin.php
qa-plugin/q2a-cat-master/qa-plugin.php
qa-plugin/q2a-close/qa-plugin.php
qa-plugin/q2a-custom-404-page-master/qa-plugin.php
qa-plugin/q2a-faq-master/qa-plugin.php
qa-plugin/q2a-featured-master/qa-plugin.php
qa-plugin/q2a-maximum-tag-length-master/qa-plugin.php
qa-plugin/q2a-newsletter-master/qa-plugin.php
qa-plugin/q2a-pm-adapter/qa-plugin.php
qa-plugin/q2a-poll-master/qa-plugin.php
qa-plugin/q2a-print-master/qa-plugin.php
qa-plugin/q2a-qnumbering-master/qa-plugin.php
qa-plugin/q2a-random-avatar-master/qa-plugin.php
qa-plugin/q2apro-email-strangulator-master/qa-plugin.php
qa-plugin/q2apro-most-active-users-master/qa-plugin.php
qa-plugin/q2apro-popular-questions-widget-master/qa-plugin.php
qa-plugin/q2apro-prevent-simultaneous-edits/qa-plugin.php
qa-plugin/q2apro-statistics-page-master/qa-plugin.php
qa-plugin/qa-user-management/qa-plugin.php
qa-plugin/show-online-user-count/qa-plugin.php
qa-plugin/tags-interface/qa-plugin.php
qa-plugin/webp-deleter/qa-plugin.php
qa-plugin/wysiwyg-editor/qa-plugin.php
httpdocs/qa-include/qa-db.php
httpdocs/qa-include/qa-page.php
qa-include/app/page.php
qa-include/app/cookies.php
qa-include/app/format.php
qa-include/app/users.php
qa-include/app/options.php
qa-include/db/options.php
qa-include/db/selects.php
qa-include/db/maxima.php
qa-plugin/permission2categories-master/p2c-module.php
qa-plugin/FS-In-List-Ads-master/qa-plugin.php
qa-plugin/Q2A-Ultimate-SEO-master/qa-plugin.php
qa-include/util/string.php
Q2A-Ultimate-SEO-master/library/functions.php
qa-plugin/basic-adsense/qa-plugin.php
qa-plugin/facebook-login/qa-plugin.php
qa-plugin/myfavs-gyzgyn-master/qa-plugin.php
qa-plugin/new-members-widget/qa-plugin.php
qa-plugin/pupi-as/qa-plugin.php
qa-plugin/pupi-jabp/qa-plugin.php
qa-plugin/pupi-jabp/PUPI_JABP_Dao.php
qa-plugin/pupi-jabp/PUPI_JABP_UserPolicy.php
qa-plugin/pupi-jabp/PUPI_JABP_PinnedPostsService.php
qa-plugin/pupi-jabp/PUPI_JABP_MultiFieldModal.php
qa-plugin/pupi-jabp/PUPI_JABP_BackwardsCompatibility.php
qa-plugin/pupi-pr/qa-plugin.php
qa-plugin/pupi-pr/PUPI_PR_Constants.php
qa-plugin/q2a-avatar-cropper/qa-plugin.php
qa-plugin/q2a-badges-master/qa-plugin.php
qa-plugin/q2a-kk-abc-master/qa-plugin.php
qa-plugin/q2a-no-self-accept-points-master/qa-plugin.php
qa-plugin/q2a-pupi-fns-master/qa-plugin.php
qa-plugin/q2a-pupi-fns-master/PUPI_FNS_Constants.php
qa-plugin/q2a-pupi-fns-master/PUPI_FNS_Plugin.php
q2a-pupi-fns-master/extensions/PUPI_FNS_ExtensionsManager.php
q2a-pupi-fns-master/extensions/PUPI_FNS_CoreExtension.php
q2a-pupi-fns-master/extensions/PUPI_FNS_IExtension.php
qa-plugin/q2a-pupi-fns-master/PUPI_FNS_NotificationTypes.php
qa-plugin/q2a-registration-blocker-1.4.0/qa-plugin.php
qa-plugin/q2a-registration-blocker-1.4.0/qa-registration-blocker-options.php
qa-plugin/q2a-report-master/qa-plugin.php
qa-plugin/q2a-role-markers-master/qa-plugin.php
qa-plugin/q2a-tagging-tools-master/qa-plugin.php
qa-plugin/q2a-toolkit/qa-plugin.php
q2a-toolkit/includes/toolkit-db.php
q2a-toolkit/includes/toolkit-actions.php
qa-include/app/posts.php
qa-include/app/post-create.php
qa-include/db/post-create.php
qa-include/db/points.php
qa-include/db/hotness.php
qa-include/app/post-update.php
qa-include/app/updates.php
qa-include/db/post-update.php
q2a-toolkit/includes/toolkit-tools.php
qa-plugin/q2a-widget-anywhere-master/qa-plugin.php
qa-plugin/qa-categories-anywhere-widget-master/qa-plugin.php
qa-plugin/share/qa-plugin.php
qa-plugin/tag-cloud-widget/qa-plugin.php
qa-plugin/title-length-counter-master/qa-plugin.php
qa-plugin/user-management/qa-plugin.php
qa-plugin/user-management/functions.php
qa-plugin/xml-sitemap/qa-plugin.php
qa-plugin/pupi-as/PUPI_AS_Plugin.php
qa-plugin/pupi-as/PUPI_AS_Util.php
qa-plugin/pupi-jabp/PUPI_JABP_Setup.php
qa-plugin/pupi-jabp/PUPI_JABP_Util.php
qa-plugin/pupi-jabp/PUPI_JABP_Constants.php
qa-plugin/pupi-jabp/PUPI_JABP_PUPI_PC_BumpPoints.php
qa-plugin/pupi-jabp/PUPI_JABP_PUPI_PR_BumpPoints.php
qa-plugin/pupi-jabp/PUPI_JABP_PUPI_PC_PinPoints.php
qa-plugin/pupi-jabp/PUPI_JABP_PUPI_PR_PinPoints.php
qa-plugin/pupi-jabp/PUPI_JABP_PUPI_PC_UnpinPoints.php
qa-plugin/pupi-pr/PUPI_PR_Plugin.php
qa-plugin/pupi-pr/PUPI_PR_Util.php
qa-plugin/q2a-pupi-fns-master/PUPI_FNS_Setup.php
qa-plugin/q2a-pupi-fns-master/PUPI_FNS_Admin.php
q2a-report-master/inc/RM_FNS_Extension.php
qa-plugin/q2a-tagging-tools-master/qa-tt-redirect.php
qa-plugin/facebook-login/qa-facebook-login.php
qa-include/pages/questions.php
qa-include/app/q-list.php
qa-include/util/sort.php
qa-include/lang/qa-lang-main.php
qa-lang/de/qa-lang-main.php
qa-include/app/limits.php
qa-plugin/qa-categories-anywhere-widget-master/qa_basic_category_anywhere.php
qa-plugin/pupi-as/PUPI_AS_Widget.php
qa-plugin/show-online-user-count/show-online-user-count-widget.php
qa-plugin/myfavs-gyzgyn-master/myfavs-widget-questions.php
qa-plugin/myfavs-gyzgyn-master/myfavs-widget-tags.php
qa-plugin/q2apro-popular-questions-widget-master/q2apro-popular-questions-widget.php
qa-plugin/pupi-jabp/PUPI_JABP_PinnedQuestionsWidget.php
qa-include/plugins/qa-widget-category-list.php
qa-include/plugins/qa-widget-activity-count.php
qa-plugin/ganbox-async-adsense-master/qa-async-adsense.php
qa-plugin/tag-cloud-widget/qa-tag-cloud.php
qa-include/lang/qa-lang-users.php
qa-lang/de/qa-lang-users.php
qa-include/util/image.php
qa-include/lang/qa-lang-misc.php
qa-lang/de/qa-lang-misc.php
httpdocs/qa-include/qa-theme-base.php
qa-theme/Polaris_modern/qa-theme.php
Polaris_modern/modules/qa-theme-head.php
Polaris_modern/modules/qa-theme-nav.php
Polaris_modern/modules/qa-theme-header.php
Polaris_modern/modules/qa-theme-body.php
Polaris_modern/modules/qa-theme-footer.php
Polaris_modern/modules/qa-theme-posts.php
Polaris_modern/modules/qa-theme-messages.php
Polaris_modern/modules/qa-theme-pages.php
Polaris_modern/modules/qa-theme-ui.php
Polaris_modern/modules/qa-theme-components.php
Polaris_modern/modules/qa-theme-errors.php
Polaris_modern/modules/qa-theme-utils.php
Polaris_modern/modules/qa-theme-admin.php
qa-include/app/blobs.php
q2a-report-master/admin/cleanup.php
qa-include/db/users.php
qa-include/plugins/qa-viewer-basic.php
pupi-jabp/lang/pupi_jabp_default.php
q2a-report-master/inc/utils.php
Polaris_modern/lang/lang-default.php
qa-include/db/metas.php
Polaris_modern/options/options-social.php
Polaris_modern/inc/og-metas.php
Polaris_modern/options/options.php
Polaris_modern/inc/svg-nav-main.php
q2a-report-master/lang/qa-lang.php
q2a-badges-master/lang/qa-badge-lang-default.php
qa-plugin/pupi-as/PUPI_AS_Templates.php
qa-plugin/pupi-as/PUPI_AS_SearchInfo.php
qa-plugin/show-online-user-count/show-online-user-count-lang.php
qa-plugin/q2apro-popular-questions-widget-master/q2apro-popular-questions-lang-default.php
qa-plugin/q2apro-popular-questions-widget-master/q2apro-popular-questions-lang-de.php
Q2A/Storage/CacheFactory.php
Q2A/Storage/FileCacheDriver.php
Q2A/Storage/CacheDriver.php

SELECT categoryid, content FROM ge_categorymetas WHERE title='p2c_permission_level'

0.39 ms - 299 rows - 2 columns

SELECT title, content FROM ge_options

5.60 ms - 22416 rows - 2 columns

SELECT 'db_time' AS `title`, UNIX_TIMESTAMP(NOW()) AS `content`

0.29 ms - 1 row - 2 columns

SELECT ge_posts.postid, ge_posts.categoryid, ge_posts.type, LEFT(ge_posts.type, 1) AS `basetype`, INSTR(ge_posts.type, '_HIDDEN')>0 AS `hidden`, INSTR(ge_posts.type, '_QUEUED')>0 AS `queued`, ge_posts.acount, ge_posts.amaxvote, ge_posts.selchildid, ge_posts.closedbyid, ge_posts.upvotes, ge_posts.downvotes, ge_posts.netvotes, ge_posts.views, ge_posts.hotness, ge_posts.flagcount, ge_posts.title, ge_posts.tags, UNIX_TIMESTAMP(ge_posts.created) AS `created`, ge_posts.name, ge_categories.title AS `categoryname`, ge_categories.backpath AS `categorybackpath`, CONCAT_WS(',', ge_posts.catidpath1, ge_posts.catidpath2, ge_posts.catidpath3, ge_posts.categoryid) AS `categoryids`, ge_posts.userid, ge_posts.cookieid, ge_posts.createip AS `createip`, ge_userpoints.points, ge_users.flags, ge_users.level, ge_users.email AS `email`, ge_users.handle AS `handle`, BINARY ge_users.avatarblobid AS `avatarblobid`, ge_users.avatarwidth, ge_users.avatarheight FROM ge_posts LEFT JOIN ge_categories ON ge_categories.categoryid=ge_posts.categoryid LEFT JOIN ge_users ON ge_posts.userid=ge_users.userid LEFT JOIN ge_userpoints ON ge_posts.userid=ge_userpoints.userid JOIN (SELECT postid FROM ge_posts WHERE catidpath1=(SELECT categoryid FROM ge_categories WHERE backpath='finanzen-und-versicherungen' LIMIT 1) AND type='Q' ORDER BY ge_posts.created DESC LIMIT 0,50) y ON ge_posts.postid=y.postid

3.67 ms - 50 rows - 34 columns

SELECT ge_categories.categoryid, MAX(ge_categories.parentid) AS `parentid`, MAX(ge_categories.title) AS `title`, MAX(ge_categories.tags) AS `tags`, MAX(ge_categories.qcount) AS `qcount`, MAX(ge_categories.position) AS `position`, COUNT(child.categoryid) AS `childcount`, MAX(ge_categories.content) AS `content`, MAX(ge_categories.backpath) AS `backpath` FROM ge_categories JOIN (SELECT NULL AS parentkey UNION SELECT grandparent.parentid FROM ge_categories JOIN ge_categories AS parent ON ge_categories.parentid=parent.categoryid JOIN ge_categories AS grandparent ON parent.parentid=grandparent.categoryid WHERE ge_categories.backpath='finanzen-und-versicherungen' UNION SELECT parent.parentid FROM ge_categories JOIN ge_categories AS parent ON ge_categories.parentid=parent.categoryid WHERE ge_categories.backpath='finanzen-und-versicherungen' UNION SELECT parentid FROM ge_categories WHERE backpath='finanzen-und-versicherungen' UNION SELECT categoryid FROM ge_categories WHERE backpath='finanzen-und-versicherungen') y ON ge_categories.parentid<=>parentkey LEFT JOIN ge_categories AS child ON child.parentid=ge_categories.categoryid GROUP BY ge_categories.categoryid ORDER BY ge_categories.position

1.86 ms - 37 rows - 9 columns

SELECT categoryid FROM ge_categories WHERE backpath='finanzen-und-versicherungen'

0.23 ms - 1 row - 1 column

SELECT action, period, count FROM ge_iplimits WHERE ip=UNHEX('26001f28036580b06333a944b99e9c59')

0.26 ms - 0 rows - 3 columns

SELECT pageid, title, flags, permit+0 AS `permit`, nav, tags, position, heading FROM ge_pages WHERE nav IN ('B','M','O','F') ORDER BY position

0.41 ms - 25 rows - 8 columns

SELECT widgetid, place, position, tags, title FROM ge_widgets ORDER BY position

0.28 ms - 14 rows - 5 columns

SELECT entityid, entitytype, level FROM ge_userlevels WHERE userid=NULL

0.28 ms - 0 rows - 3 columns

SELECT * FROM ge_widgetanyw ORDER BY ordering

1.34 ms - 14 rows - 6 columns

SELECT widgetid, place, position, tags, title FROM ge_widgets ORDER BY position

0.31 ms - 14 rows - 5 columns

SELECT `id`, `post_id`, `user_id`, `hours`, `state`, `points`, UNIX_TIMESTAMP(`started_at`) `started_at`, UNIX_TIMESTAMP(`created_at`) `created_at` FROM `ge_pupi_jabp_pinned_posts` WHERE `state` = 1 ORDER BY `created_at`, `id` LIMIT 15

0.35 ms - 5 rows - 8 columns

SELECT `id`, `pp1`.`post_id`, `user_id`, `hours`, `state`, `points`, UNIX_TIMESTAMP(`started_at`) `started_at`, UNIX_TIMESTAMP(`pp1`.`created_at`) `created_at` FROM `ge_pupi_jabp_pinned_posts` `pp1` JOIN (SELECT `post_id`, MIN(`created_at`) `created_at` FROM `ge_pupi_jabp_pinned_posts` WHERE `state` = 0 AND `post_id` NOT IN (68281,68362,68366,68360,68279) GROUP BY `post_id` LIMIT 10) `pp2` ON `pp1`.`post_id` = `pp2`.`post_id` AND `pp1`.`created_at` = `pp2`.`created_at` ORDER BY `pp1`.`created_at`, `id` LIMIT 10

0.54 ms - 0 rows - 8 columns

SELECT userid, handle FROM ge_users WHERE userid IN (1,1,1,1,1)

0.22 ms - 1 row - 2 columns

SELECT ge_posts.postid, ge_posts.categoryid, ge_posts.type, LEFT(ge_posts.type, 1) AS `basetype`, INSTR(ge_posts.type, '_HIDDEN')>0 AS `hidden`, INSTR(ge_posts.type, '_QUEUED')>0 AS `queued`, ge_posts.acount, ge_posts.amaxvote, ge_posts.selchildid, ge_posts.closedbyid, ge_posts.upvotes, ge_posts.downvotes, ge_posts.netvotes, ge_posts.views, ge_posts.hotness, ge_posts.flagcount, ge_posts.title, ge_posts.tags, UNIX_TIMESTAMP(ge_posts.created) AS `created`, ge_posts.name, ge_categories.title AS `categoryname`, ge_categories.backpath AS `categorybackpath`, CONCAT_WS(',', ge_posts.catidpath1, ge_posts.catidpath2, ge_posts.catidpath3, ge_posts.categoryid) AS `categoryids`, ge_posts.content AS `content`, ge_posts.notify AS `notify`, UNIX_TIMESTAMP(ge_posts.updated) AS `updated`, ge_posts.updatetype AS `updatetype`, ge_posts.format, ge_posts.lastuserid, ge_posts.lastip AS `lastip`, ge_posts.parentid, ge_posts.lastviewip AS `lastviewip`, ge_posts.userid, ge_posts.cookieid, ge_posts.createip AS `createip`, ge_userpoints.points, ge_users.flags, ge_users.level, ge_users.email AS `email`, ge_users.handle AS `handle`, BINARY ge_users.avatarblobid AS `avatarblobid`, ge_users.avatarwidth, ge_users.avatarheight, lastusers.handle AS `lasthandle` FROM ge_posts LEFT JOIN ge_categories ON ge_categories.categoryid=ge_posts.categoryid LEFT JOIN ge_users ON ge_posts.userid=ge_users.userid LEFT JOIN ge_users AS lastusers ON ge_posts.lastuserid=lastusers.userid LEFT JOIN ge_userpoints ON ge_posts.userid=ge_userpoints.userid WHERE ge_posts.postid IN (68281,68362,68366,68360,68279)

0.76 ms - 5 rows - 44 columns

SELECT ge_posts.postid, ge_posts.categoryid, ge_posts.type, LEFT(ge_posts.type, 1) AS `basetype`, INSTR(ge_posts.type, '_HIDDEN')>0 AS `hidden`, INSTR(ge_posts.type, '_QUEUED')>0 AS `queued`, ge_posts.acount, ge_posts.amaxvote, ge_posts.selchildid, ge_posts.closedbyid, ge_posts.upvotes, ge_posts.downvotes, ge_posts.netvotes, ge_posts.views, ge_posts.hotness, ge_posts.flagcount, ge_posts.title, ge_posts.tags, UNIX_TIMESTAMP(ge_posts.created) AS `created`, ge_posts.name, ge_categories.title AS `categoryname`, ge_categories.backpath AS `categorybackpath`, CONCAT_WS(',', ge_posts.catidpath1, ge_posts.catidpath2, ge_posts.catidpath3, ge_posts.categoryid) AS `categoryids`, ge_posts.content AS `content`, ge_posts.notify AS `notify`, UNIX_TIMESTAMP(ge_posts.updated) AS `updated`, ge_posts.updatetype AS `updatetype`, ge_posts.format, ge_posts.lastuserid, ge_posts.lastip AS `lastip`, ge_posts.parentid, ge_posts.lastviewip AS `lastviewip`, ge_posts.userid, ge_posts.cookieid, ge_posts.createip AS `createip`, ge_userpoints.points, ge_users.flags, ge_users.level, ge_users.email AS `email`, ge_users.handle AS `handle`, BINARY ge_users.avatarblobid AS `avatarblobid`, ge_users.avatarwidth, ge_users.avatarheight, lastusers.handle AS `lasthandle` FROM ge_posts LEFT JOIN ge_categories ON ge_categories.categoryid=ge_posts.categoryid LEFT JOIN ge_users ON ge_posts.userid=ge_users.userid LEFT JOIN ge_users AS lastusers ON ge_posts.lastuserid=lastusers.userid LEFT JOIN ge_userpoints ON ge_posts.userid=ge_userpoints.userid WHERE ge_posts.postid IN (68281,68362,68366,68360,68279)

0.97 ms - 5 rows - 44 columns

SELECT * FROM ge_postmeta WHERE meta_key='is_closed'

0.43 ms - 6 rows - 4 columns

SELECT * FROM ge_postmeta WHERE meta_key='is_poll'

0.26 ms - 18 rows - 4 columns

SELECT COUNT(*) FROM ge_rm_user_reports WHERE status != "closed"

0.24 ms - 1 row - 1 column

SELECT COUNT(*) FROM ge_rm_user_reports WHERE status != "closed"

0.22 ms - 1 row - 1 column

SELECT ge_categories.categoryid, MAX(ge_categories.parentid) AS `parentid`, MAX(ge_categories.title) AS `title`, MAX(ge_categories.tags) AS `tags`, MAX(ge_categories.qcount) AS `qcount`, MAX(ge_categories.position) AS `position`, COUNT(child.categoryid) AS `childcount`, MAX(ge_categories.content) AS `content`, MAX(ge_categories.backpath) AS `backpath` FROM ge_categories JOIN (SELECT NULL AS parentkey UNION SELECT grandparent.parentid FROM ge_categories JOIN ge_categories AS parent ON ge_categories.parentid=parent.categoryid JOIN ge_categories AS grandparent ON parent.parentid=grandparent.categoryid WHERE ge_categories.categoryid=NULL UNION SELECT parent.parentid FROM ge_categories JOIN ge_categories AS parent ON ge_categories.parentid=parent.categoryid WHERE ge_categories.categoryid=NULL UNION SELECT parentid FROM ge_categories WHERE categoryid=NULL UNION SELECT categoryid FROM ge_categories WHERE categoryid=NULL) y ON ge_categories.parentid<=>parentkey LEFT JOIN ge_categories AS child ON child.parentid=ge_categories.categoryid GROUP BY ge_categories.categoryid ORDER BY ge_categories.position

1.79 ms - 37 rows - 9 columns

DELETE FROM ge_online_user WHERE last_activity<"2026-10-07 21:13:59"

0.31 ms

INSERT INTO ge_options (title, content) VALUES ('TODAY_VISITOR_COUNT', '6855') ON DUPLICATE KEY UPDATE content = VALUES(content)

0.25 ms

INSERT INTO ge_options (title, content) VALUES ('TOTAL_VISITOR_COUNT', '27431594') ON DUPLICATE KEY UPDATE content = VALUES(content)

0.17 ms

SELECT id FROM ge_online_user WHERE ip="2600:1f28:365:80b0:6333:a944:b99e:9c59"

0.20 ms - 1 row - 1 column

UPDATE ge_online_user SET user_id='0',last_activity='2026-10-07 21:14:59' WHERE id='10823755'

0.28 ms

SELECT COUNT(*) FROM ge_online_user WHERE user_id>"0"

0.16 ms - 1 row - 1 column

SELECT COUNT(*) FROM ge_online_user WHERE user_id="0"

0.15 ms - 1 row - 1 column

SELECT ge_categories.categoryid, MAX(ge_categories.parentid) AS `parentid`, MAX(ge_categories.title) AS `title`, MAX(ge_categories.tags) AS `tags`, MAX(ge_categories.qcount) AS `qcount`, MAX(ge_categories.position) AS `position`, COUNT(child.categoryid) AS `childcount`, MAX(ge_categories.content) AS `content`, MAX(ge_categories.backpath) AS `backpath` FROM ge_categories JOIN (SELECT NULL AS parentkey UNION SELECT grandparent.parentid FROM ge_categories JOIN ge_categories AS parent ON ge_categories.parentid=parent.categoryid JOIN ge_categories AS grandparent ON parent.parentid=grandparent.categoryid WHERE ge_categories.categoryid=NULL UNION SELECT parent.parentid FROM ge_categories JOIN ge_categories AS parent ON ge_categories.parentid=parent.categoryid WHERE ge_categories.categoryid=NULL UNION SELECT parentid FROM ge_categories WHERE categoryid=NULL UNION SELECT categoryid FROM ge_categories WHERE categoryid=NULL) y ON ge_categories.parentid<=>parentkey LEFT JOIN ge_categories AS child ON child.parentid=ge_categories.categoryid GROUP BY ge_categories.categoryid ORDER BY ge_categories.position

1.59 ms - 37 rows - 9 columns

SELECT COUNT(*) FROM ge_rm_user_reports WHERE status != "closed"

0.21 ms - 1 row - 1 column

SELECT word, tagcount FROM ge_words JOIN (SELECT wordid FROM ge_words WHERE tagcount>0 ORDER BY tagcount DESC LIMIT 0,8) y ON ge_words.wordid=y.wordid

0.56 ms - 8 rows - 2 columns

SELECT COUNT(*) FROM ge_rm_user_reports WHERE status != "closed"

0.23 ms - 1 row - 1 column

Themen	thema:Hunde
Autor	autor:Martin
Titel	titel:Hund
Inhalt	inhalt:Hund
Ausschliessen	-thema:Hunde
Muss enthalten	+Hund
Ansichten (min.)	Martin ansichten:100
Antworten	Martin antworten:2

Kategorien

Uh Oh! ...