Teste kivitendo!

kivitendo Demo mit Schweizer Kontenplan

Geld allein macht nicht glücklich - benutzt kivitendo!

Neue Fragen mit datenbank-Tag

0 Punkte

1 Antwort

DATEV Berater mit 9 Zeichen

Gefragt 31 Okt von backoffice (170 Punkte)

0 Punkte

1 Antwort

Rote Balken überall - Installation unvollständig

Gefragt 23 Mai von hedele (30 Punkte)

0 Punkte

1 Antwort

Datenbank-Update von lx-office 2.6 auf Kivitendo 3.5.1

Gefragt 18 Mär von conrad (20 Punkte)

0 Punkte

1 Antwort

DBD::Pg::st execute failed: ERROR: relation "background_jobs" does not exist

Gefragt 3, Okt 2017 von pugfis (30 Punkte)

0 Punkte

0 Antworten

Probleme beim Anlegen einer neuen Datenbank

Gefragt 6, Apr 2017 von nschulz (20 Punkte)

0 Punkte

2 Antworten

Database not up to date. Please run the datebase update. CRM->Administration->Status

Gefragt 17, Sep 2016 von kastenloch (160 Punkte)

0 Punkte

2 Antworten

Automatischen Dump der Datenbank

Gefragt 27, Aug 2014 von Marek (350 Punkte)

0 Punkte

2 Antworten

DB-Upgrade auf GIT führt zum Login-Screen

Gefragt 1, Dez 2013 von nwittje (60 Punkte)

0 Punkte

1 Antwort

DBI connect('','',...) failed: FATAL: database "www-data" does not exist at /var/www/kivitendo/SL/DBConnect.pm line 10

Gefragt 10, Nov 2013 von Simmerl (60 Punkte)

0 Punkte

1 Antwort

Wiederherstellen einer mit pgAdmin gesicherten lx-office 2.6.3 Datenbank in kivitendo 3.0

Gefragt 14, Okt 2013 von timax (40 Punkte)

0 Punkte

2 Antworten

Welches Datenbankfeld verknüft Produkte mit dem Hersteller

Gefragt 23, Apr 2012 von christian_ (160 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	19.3	49%	20.0	51%	27	1.7	4%	2	0.0	0%	1391k	58%
Control	5.9	15%	0.0	0%	4	3.5	9%	5	2.4	6%	261k	10%
View	6.4	16%	8.0	20%	7	0.5	1%	1	0.0	0%	202k	8%
Theme	7.0	18%	4.0	10%	2	0.9	2%	1	2.1	5%	542k	22%
Total	38.6	100%	32.0	82%	40	6.7	17%	9	0.0	0%	2397k	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/tag.php
qa-include/app/updates.php
qa-include/util/string.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-include/plugins/qa-widget-related-qs.php
qa-plugin/tag-cloud-widget/qa-tag-cloud.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.35 ms - 372 rows - 2 columns

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

0.37 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 posttags WHERE wordid=(SELECT wordid FROM words WHERE word='datenbank' AND word='datenbank' COLLATE utf8_bin LIMIT 1) ORDER BY postcreated DESC LIMIT 0,20) y ON posts.postid=y.postid

1.42 ms - 11 rows - 33 columns

SELECT wordid, word, tagcount FROM words WHERE word='datenbank' AND word='datenbank' COLLATE utf8_bin

0.56 ms - 1 row - 3 columns

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

0.50 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.54 ms - 0 rows - 8 columns

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

0.51 ms - 2 rows - 5 columns

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

0.47 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

0.94 ms - 18 rows - 2 columns