Teste kivitendo!

kivitendo Demo mit Schweizer Kontenplan

Geld allein macht nicht glücklich - benutzt kivitendo!

Neu Aktivitäten

Neu Aktivitäten

0 Punkte

1 Antwort

DATEV Berater mit 9 Zeichen

Kommentiert 1 Nov von backoffice (170 Punkte)

0 Punkte

1 Antwort

Wo finde ich die Dokumentation zu Konteneinstellungen?

Beantwortet 26 Okt von jbueren (5.4k Punkte)

0 Punkte

3 Antworten

CRM mit kivitendo 3.5.1

Beantwortet 14 Okt von bizcom (350 Punkte)

0 Punkte

1 Antwort

kivitendo.de problem

Antwort ausgewählt 12 Okt von pseher (780 Punkte)

0 Punkte

0 Antworten

Einladung zum kivitendo Community Treffen Schweiz, 12.10.2018

Gefragt 9 Okt von arudin (2.9k Punkte)

0 Punkte

1 Antwort

Rechnungspositionen neu sortieren nach Lieferdatum [geschlossen]

geschlossen 5 Okt von nschneider (330 Punkte)

0 Punkte

0 Antworten

Bei Verkaufsberichten wird der Projektname nicht richtig ausgewertet

Gefragt 5 Okt von nschneider (330 Punkte)

0 Punkte

1 Antwort

Kubuntu 18.04.1 mit Kivitendo

Beantwortet 15 Sep von Werner Hahn (4.1k Punkte)

0 Punkte

2 Antworten

Artikelvarianten

Beantwortet 13 Sep von Werner Hahn (4.1k Punkte)

0 Punkte

1 Antwort

Fehler beim Upgrade auf 3.5.2 [geschlossen]

geschlossen 11 Sep von AEITB (290 Punkte)

0 Punkte

1 Antwort

Kann ich Druck-Voreinstellungen für das Versenden von Dokumenten (RE's etc.) per E-Mail vornehmen?

Kommentiert 7 Sep von jbueren (5.4k Punkte)

0 Punkte

0 Antworten

CRM v2.3.1 verhindert Suchfunktion in ERP v3.5.2

Kommentiert 6 Sep von volker (60 Punkte)

0 Punkte

1 Antwort

Kleinunternehmerregelung in kivitendo

Antwort ausgewählt 5 Sep von realtkd (50 Punkte)

+1 Punkt

1 Antwort

Vorbelegte Texte für E-Mail

Kommentiert 24 Aug von jbueren (5.4k Punkte)

0 Punkte

1 Antwort

Welche Bezahldienste kann man mit Kivitendo koppeln bzw. werden unterstützt?

Kommentiert 22 Aug von MöglicherNeuerNutzer (60 Punkte)

0 Punkte

1 Antwort

gibt es bereits einen Connector zu OS: Commerce

Beantwortet 22 Aug von Werner Hahn (4.1k Punkte)

0 Punkte

1 Antwort

Lieferant im Lieferantenauftrag

Beantwortet 22 Aug von Werner Hahn (4.1k Punkte)

0 Punkte

1 Antwort

Kivitendo Rechnungsversand DSGVO

Kommentiert 16 Aug von Auge (270 Punkte)

0 Punkte

1 Antwort

Welche ERP Version läuft mit der CRM 2.2.1 [geschlossen]

geschlossen 15 Aug von nschneider (330 Punkte)

0 Punkte

1 Antwort

Lieferscheine/Aufträge werden nicht mehr gespeichert und angezeigt

Kommentiert 27 Jul von Werner Hahn (4.1k Punkte)

Alle Fragen anzeigen oder die beliebtesten Themen ansehen.

...

	Total		PHP			MySQL			Other		RAM
	Time (ms)	%	Time (ms)	%	File count	Time (ms)	%	Query count	Time (ms)	%	Amount	%
Setup	20.9	35%	16.0	27%	27	2.3	3%	2	2.7	4%	1391k	53%
Control	20.1	34%	12.0	20%	6	14.6	24%	8	0.0	0%	1865k	71%
View	10.2	17%	8.0	13%	6	0.7	1%	1	1.4	2%	0k	0%
Theme	7.5	12%	8.0	13%	2	1.0	1%	1	0.0	0%	557k	21%
Total	58.8	100%	44.0	74%	41	18.6	31%	12	0.0	0%	2606k	100%

kivitendo/forum/index.php
forum/qa-include/qa-index.php
forum/qa-include/qa-base.php
kivitendo/forum/qa-config.php
qa-include/vendor/password_compat.php
Q2A/Util/Usage.php
Q2A/Plugin/PluginManager.php
Q2A/Util/Metadata.php
qa-plugin/antibot-captcha/qa-plugin.php
qa-plugin/event-logger/qa-plugin.php
qa-plugin/q2a-markdown-editor/qa-plugin.php
qa-plugin/qa-publish-to-email/qa-plugin.php
qa-plugin/very-simple-bot-protection/qa-plugin.php
qa-plugin/wysiwyg-editor/qa-plugin.php
forum/qa-include/qa-db.php
forum/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/basic-adsense/qa-plugin.php
qa-plugin/example-page/qa-plugin.php
qa-plugin/facebook-login/qa-plugin.php
qa-plugin/mouseover-layer/qa-plugin.php
qa-plugin/opensearch-support/qa-plugin.php
qa-plugin/recaptcha-captcha/qa-plugin.php
qa-plugin/tag-cloud-widget/qa-plugin.php
qa-plugin/xml-sitemap/qa-plugin.php
qa-plugin/facebook-login/qa-facebook-login.php
qa-include/pages/activity.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/updates.php
qa-include/app/limits.php
qa-include/plugins/qa-widget-related-qs.php
qa-plugin/tag-cloud-widget/qa-tag-cloud.php
qa-include/util/string.php
qa-include/lang/qa-lang-users.php
qa-lang/de/qa-lang-users.php
forum/qa-include/qa-theme-base.php
qa-theme/kivitendo2/qa-theme.php

SELECT title, content FROM options

1.63 ms - 372 rows - 2 columns

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

0.63 ms - 1 row - 2 columns

SELECT posts.postid, posts.categoryid, posts.type, LEFT(posts.type, 1) AS basetype, INSTR(posts.type, '_HIDDEN')>0 AS hidden, INSTR(posts.type, '_QUEUED')>0 AS queued, posts.acount, posts.selchildid, posts.closedbyid, posts.upvotes, posts.downvotes, posts.netvotes, posts.views, posts.hotness, posts.flagcount, posts.title, posts.tags, UNIX_TIMESTAMP(posts.created) AS created, posts.name, categories.title AS categoryname, categories.backpath AS categorybackpath, CONCAT_WS(',', posts.catidpath1, posts.catidpath2, posts.catidpath3, posts.categoryid) AS categoryids, posts.userid, posts.cookieid, posts.createip AS createip, userpoints.points, users.flags, users.level, users.email AS email, users.handle AS handle, BINARY users.avatarblobid AS avatarblobid, users.avatarwidth, users.avatarheight FROM posts LEFT JOIN categories ON categories.categoryid=posts.categoryid LEFT JOIN users ON posts.userid=users.userid LEFT JOIN userpoints ON posts.userid=userpoints.userid JOIN (SELECT postid FROM posts WHERE type='Q' ORDER BY posts.created DESC LIMIT 0,20) y ON posts.postid=y.postid

1.80 ms - 20 rows - 33 columns

SELECT posts.postid, posts.categoryid, posts.type, LEFT(posts.type, 1) AS basetype, INSTR(posts.type, '_HIDDEN')>0 AS hidden, INSTR(posts.type, '_QUEUED')>0 AS queued, posts.acount, posts.selchildid, posts.closedbyid, posts.upvotes, posts.downvotes, posts.netvotes, posts.views, posts.hotness, posts.flagcount, posts.title, posts.tags, UNIX_TIMESTAMP(posts.created) AS created, posts.name, categories.title AS categoryname, categories.backpath AS categorybackpath, CONCAT_WS(',', posts.catidpath1, posts.catidpath2, posts.catidpath3, posts.categoryid) AS categoryids, posts.userid, posts.cookieid, posts.createip AS createip, userpoints.points, users.flags, users.level, users.email AS email, users.handle AS handle, BINARY users.avatarblobid AS avatarblobid, users.avatarwidth, users.avatarheight, LEFT(aposts.type, 1) AS obasetype, INSTR(aposts.type, '_HIDDEN')>0 AS ohidden, aposts.postid AS opostid, aposts.userid AS ouserid, aposts.cookieid AS ocookieid, aposts.name AS oname, aposts.createip AS oip, UNIX_TIMESTAMP(aposts.created) AS otime, aposts.flagcount AS oflagcount, ausers.flags AS oflags, ausers.level AS olevel, ausers.email AS oemail, ausers.handle AS ohandle, BINARY ausers.avatarblobid AS oavatarblobid, ausers.avatarwidth AS oavatarwidth, ausers.avatarheight AS oavatarheight, auserpoints.points AS opoints FROM posts LEFT JOIN categories ON categories.categoryid=posts.categoryid LEFT JOIN users ON posts.userid=users.userid LEFT JOIN userpoints ON posts.userid=userpoints.userid JOIN posts AS aposts ON posts.postid=aposts.parentid LEFT JOIN users AS ausers ON aposts.userid=ausers.userid LEFT JOIN userpoints AS auserpoints ON aposts.userid=auserpoints.userid JOIN (SELECT postid FROM posts WHERE type='A' ORDER BY posts.created DESC LIMIT 0,50) y ON aposts.postid=y.postid WHERE posts.type='Q'

2.95 ms - 50 rows - 50 columns

SELECT posts.postid, posts.categoryid, posts.type, LEFT(posts.type, 1) AS basetype, INSTR(posts.type, '_HIDDEN')>0 AS hidden, INSTR(posts.type, '_QUEUED')>0 AS queued, posts.acount, posts.selchildid, posts.closedbyid, posts.upvotes, posts.downvotes, posts.netvotes, posts.views, posts.hotness, posts.flagcount, posts.title, posts.tags, UNIX_TIMESTAMP(posts.created) AS created, posts.name, categories.title AS categoryname, categories.backpath AS categorybackpath, CONCAT_WS(',', posts.catidpath1, posts.catidpath2, posts.catidpath3, posts.categoryid) AS categoryids, posts.userid, posts.cookieid, posts.createip AS createip, userpoints.points, users.flags, users.level, users.email AS email, users.handle AS handle, BINARY users.avatarblobid AS avatarblobid, users.avatarwidth, users.avatarheight, LEFT(cposts.type, 1) AS obasetype, INSTR(cposts.type, '_HIDDEN')>0 AS ohidden, cposts.postid AS opostid, cposts.userid AS ouserid, cposts.cookieid AS ocookieid, cposts.name AS oname, cposts.createip AS oip, UNIX_TIMESTAMP(cposts.created) AS otime, cposts.flagcount AS oflagcount, cusers.flags AS oflags, cusers.level AS olevel, cusers.email AS oemail, cusers.handle AS ohandle, BINARY cusers.avatarblobid AS oavatarblobid, cusers.avatarwidth AS oavatarwidth, cusers.avatarheight AS oavatarheight, cuserpoints.points AS opoints FROM posts LEFT JOIN categories ON categories.categoryid=posts.categoryid LEFT JOIN users ON posts.userid=users.userid LEFT JOIN userpoints ON posts.userid=userpoints.userid JOIN posts AS parentposts ON posts.postid=(CASE LEFT(parentposts.type, 1) WHEN 'A' THEN parentposts.parentid ELSE parentposts.postid END) JOIN posts AS cposts ON parentposts.postid=cposts.parentid LEFT JOIN users AS cusers ON cposts.userid=cusers.userid LEFT JOIN userpoints AS cuserpoints ON cposts.userid=cuserpoints.userid JOIN (SELECT postid FROM posts WHERE type='C' ORDER BY posts.created DESC LIMIT 0,50) y ON cposts.postid=y.postid WHERE posts.type='Q' AND ((parentposts.type='Q') OR (parentposts.type='A'))

3.18 ms - 50 rows - 50 columns

SELECT posts.postid, posts.categoryid, posts.type, LEFT(posts.type, 1) AS basetype, INSTR(posts.type, '_HIDDEN')>0 AS hidden, INSTR(posts.type, '_QUEUED')>0 AS queued, posts.acount, posts.selchildid, posts.closedbyid, posts.upvotes, posts.downvotes, posts.netvotes, posts.views, posts.hotness, posts.flagcount, posts.title, posts.tags, UNIX_TIMESTAMP(posts.created) AS created, posts.name, categories.title AS categoryname, categories.backpath AS categorybackpath, CONCAT_WS(',', posts.catidpath1, posts.catidpath2, posts.catidpath3, posts.categoryid) AS categoryids, posts.userid, posts.cookieid, posts.createip AS createip, userpoints.points, users.flags, users.level, users.email AS email, users.handle AS handle, BINARY users.avatarblobid AS avatarblobid, users.avatarwidth, users.avatarheight, LEFT(editposts.type, 1) AS obasetype, INSTR(editposts.type, '_HIDDEN')>0 AS ohidden, editposts.postid AS opostid, editposts.lastuserid AS ouserid, editposts.cookieid AS ocookieid, editposts.name AS oname, editposts.lastip AS oip, UNIX_TIMESTAMP(editposts.updated) AS otime, editposts.flagcount AS oflagcount, editposts.updatetype AS oupdatetype, UNIX_TIMESTAMP(editposts.updated) AS oupdated, editusers.flags AS oflags, editusers.level AS olevel, editusers.email AS oemail, editusers.handle AS ohandle, BINARY editusers.avatarblobid AS oavatarblobid, editusers.avatarwidth AS oavatarwidth, editusers.avatarheight AS oavatarheight, edituserpoints.points AS opoints FROM posts LEFT JOIN categories ON categories.categoryid=posts.categoryid LEFT JOIN users ON posts.userid=users.userid LEFT JOIN userpoints ON posts.userid=userpoints.userid JOIN posts AS parentposts ON posts.postid=IF(LEFT(parentposts.type, 1)='Q', parentposts.postid, parentposts.parentid) JOIN posts AS editposts ON parentposts.postid=IF(LEFT(editposts.type, 1)='Q', editposts.postid, editposts.parentid) LEFT JOIN users AS editusers ON editposts.lastuserid=editusers.userid LEFT JOIN userpoints AS edituserpoints ON editposts.lastuserid=edituserpoints.userid JOIN (SELECT postid FROM posts WHERE type IN ('Q', 'A', 'C') ORDER BY posts.updated DESC LIMIT 0,50) y ON editposts.postid=y.postid WHERE parentposts.type IN ('Q', 'A', 'C') AND posts.type IN ('Q', 'A', 'C')

3.21 ms - 50 rows - 52 columns

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

1.22 ms - 0 rows - 9 columns

SELECT action, period, count FROM iplimits WHERE ip=UNHEX('22cbe14e')

0.70 ms - 0 rows - 3 columns

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

0.78 ms - 0 rows - 8 columns

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

0.75 ms - 2 rows - 5 columns

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

0.74 ms - 0 rows - 3 columns

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

1.05 ms - 18 rows - 2 columns