multilingual_title_de
Posted: Mon Jan 11, 2016 8:31 pm
K<nn mir mal wer verraten woherdieses schript aufgerufen wird? Ih habe auf Duckhome.net kein solches Plugin in der Liste, also muss es woanders her kommen.
Das Probllem ist, das Duckhome plötzlich sehr langsam geworden ist und mein Hoster mir folgendes Mitteilte:
"Auffällig ist, dass MySQL für alle gezeigten Queries wesentlich mehr
Datensätze untersuchen musste, als es zurückgegeben hat. Das deutet auf
sog. Full Table Scans hin, wobei ich das mindestens bei einem Query
nicht nachvollziehen konnte.
Aber vielleicht ist das Produkt aus den Tabellen-Verknüpfungen auch
einfach zu groß um effektiv verarbeitet werden zu können.
Was mir spontan ins Auge gefallen ist, sind Properties mit dem Namen
"multilingual_title_de". Soweit ich weiß ist das keine Funktion die S9Y
so mitbringt, sondern per Plugin nachgerüstet wird. Sollte dem so sein,
schau doch mal, ob Du das Plugin wirklich brauchst oder eher weg tun kannst.
Wobei das natürlich nicht das einzigste ist. "
Hier der Output des Logs:
Time Id Command Argument
# Time: 160111 17:27:01
# User@Host: duckhome[duckhome] @ [127.0.0.1]
# Query_time: 6.354258 Lock_time: 0.000067 Rows_sent: 5 Rows_examined: 31268
use duckhome_db1;
SET timestamp=1452529621;
SELECT DISTINCT id,
title,
timestamp,
epm.value AS multilingual_title
FROM tb_entries AS e
LEFT OUTER JOIN tb_entrycat AS ec ON id = ec.entryid LEFT OUTER JOIN tb_category AS c ON ec.categoryid = c.categoryid
LEFT OUTER JOIN tb_entryproperties AS epm
ON (epm.entryid = e.id AND epm.property = 'multilingual_title_de')
WHERE isdraft = 'false' AND timestamp <= 1452529614
ORDER BY timestamp DESC
LIMIT 5;
# User@Host: duckhome[duckhome] @ [127.0.0.1]
# Query_time: 15.446632 Lock_time: 0.037587 Rows_sent: 25 Rows_examined: 23241
SET timestamp=1452529621;
SELECT
ep_sticky.value AS orderkey,
e.id,
e.title,
e.timestamp,
e.comments,
e.exflag,
e.authorid,
e.trackbacks,
e.isdraft,
e.allow_comments,
e.last_modified,
a.realname AS author,
a.username AS loginname,
a.email
, e.body, e.extended
FROM
tb_entries AS e
LEFT JOIN tb_authors a
ON e.authorid = a.authorid
LEFT JOIN tb_entrycat ec
ON e.id = ec.entryid
LEFT JOIN tb_category c
ON ec.categoryid = c.categoryid
LEFT OUTER JOIN tb_entryproperties ep_access
ON (e.id = ep_access.entryid AND ep_access.property = 'ep_access')
LEFT JOIN tb_entryproperties ep_sticky
ON (e.id = ep_sticky.entryid AND ep_sticky.property = 'ep_is_sticky')
WHERE isdraft = 'false' AND (e.authorid = 1) AND e.timestamp <= 1452529800 AND (ep_access.property IS NULL OR ep_access.value = 'public')
GROUP BY e.id
ORDER BY orderkey DESC, timestamp DESC
LIMIT 1675, 25;
# Time: 160111 17:27:05
# User@Host: duckhome[duckhome] @ [127.0.0.1]
# Query_time: 12.299370 Lock_time: 0.000257 Rows_sent: 1 Rows_examined: 52472
SET timestamp=1452529625;
SELECT
e.isdraft AS orderkey,
ep_cache_extended.value AS ep_cache_extended,
ep_cache_body.value AS ep_cache_body,
e.id,
e.title,
e.timestamp,
e.comments,
e.exflag,
e.authorid,
e.trackbacks,
e.isdraft,
e.allow_comments,
e.last_modified,
a.realname AS author,
a.username AS loginname,
a.email
FROM
tb_entries AS e
LEFT JOIN tb_authors a
ON e.authorid = a.authorid
LEFT JOIN tb_entrycat ec
ON e.id = ec.entryid
LEFT JOIN tb_category c
ON ec.categoryid = c.categoryid
LEFT OUTER JOIN tb_entryproperties ep_no_frontpage
ON (e.id = ep_no_frontpage.entryid AND ep_no_frontpage.property = 'ep_no_frontpage')
LEFT OUTER JOIN tb_entryproperties ep_cache_extended
ON (e.id = ep_cache_extended.entryid AND ep_cache_extended.property = 'ep_cache_extended')
LEFT OUTER JOIN tb_entryproperties ep_cache_body
ON (e.id = ep_cache_body.entryid AND ep_cache_body.property = 'ep_cache_body')
LEFT OUTER JOIN tb_entryproperties ep_access
ON (e.id = ep_access.entryid AND ep_access.property = 'ep_access')
WHERE isdraft = 'false' AND e.timestamp <= 1452529800 AND (ep_access.property IS NULL OR ep_access.value = 'public') AND (ep_no_frontpage.property IS NULL OR ep_no_frontpage.value != 'true')
GROUP BY e.id
ORDER BY orderkey DESC, last_modified DESC
LIMIT 1;
# Time: 160111 17:27:11
Query_time: 6.040128 Lock_time: 0.000123 Rows_sent: 5 Rows_examined: 31268
SET timestamp=1452529891;
SELECT DISTINCT id,
title,
timestamp,
epm.value AS multilingual_title
FROM tb_entries AS e
LEFT OUTER JOIN tb_entrycat AS ec ON id = ec.entryid LEFT OUTER JOIN tb_category AS c ON ec.categoryid = c.categoryid
LEFT OUTER JOIN tb_entryproperties AS epm
ON (epm.entryid = e.id AND epm.property = 'multilingual_title_de')
WHERE isdraft = 'false' AND timestamp <= 1452529885
ORDER BY timestamp DESC
LIMIT 5;
# Time: 160111 17:31:33
# User@Host: duckhome[duckhome] @ [127.0.0.1]
# Query_time: 5.985227 Lock_time: 0.000093 Rows_sent: 20 Rows_examined: 84846
SET timestamp=1452529893;
SELECT et.tag, count(et.tag) AS total
FROM tb_entrytags AS et
LEFT OUTER JOIN tb_entries AS e
ON et.entryid = e.id
WHERE e.isdraft = 'false' AND e.timestamp <= 1452529887
GROUP BY et.tag
HAVING count(et.tag) >= 2
ORDER BY total DESC LIMIT 20;
# Time: 160111 17:31:35
# User@Host: duckhome[duckhome] @ [127.0.0.1]
# Query_time: 5.749800 Lock_time: 0.000108 Rows_sent: 5 Rows_examined: 31268
SET timestamp=1452529895;
SELECT DISTINCT id,
title,
timestamp,
epm.value AS multilingual_title
FROM tb_entries AS e
LEFT OUTER JOIN tb_entrycat AS ec ON id = ec.entryid LEFT OUTER JOIN tb_category AS c ON ec.categoryid = c.categoryid
LEFT OUTER JOIN tb_entryproperties AS epm
ON (epm.entryid = e.id AND epm.property = 'multilingual_title_de')
WHERE isdraft = 'false' AND timestamp <= 1452529889
ORDER BY timestamp DESC
LIMIT 5;
# User@Host: duckhome[duckhome] @ [127.0.0.1]
# Query_time: 6.023760 Lock_time: 0.000106 Rows_sent: 5 Rows_examined: 31268
SET timestamp=1452529895;
SELECT DISTINCT id,
title,
timestamp,
epm.value AS multilingual_title
FROM tb_entries AS e
LEFT OUTER JOIN tb_entrycat AS ec ON id = ec.entryid LEFT OUTER JOIN tb_category AS c ON ec.categoryid = c.categoryid
LEFT OUTER JOIN tb_entryproperties AS epm
ON (epm.entryid = e.id AND epm.property = 'multilingual_title_de')
WHERE isdraft = 'false' AND timestamp <= 1452529889
ORDER BY timestamp DESC
LIMIT 5;
# Time: 160111 17:31:36
# User@Host: duckhome[duckhome] @ [127.0.0.1]
# Query_time: 6.553538 Lock_time: 0.222695 Rows_sent: 20 Rows_examined: 84846
SET timestamp=1452529896;
SELECT et.tag, count(et.tag) AS total
FROM tb_entrytags AS et
LEFT OUTER JOIN tb_entries AS e
ON et.entryid = e.id
WHERE e.isdraft = 'false' AND e.timestamp <= 1452529890
GROUP BY et.tag
HAVING count(et.tag) >= 2
ORDER BY total DESC LIMIT 20;
# User@Host: duckhome[duckhome] @ [127.0.0.1]
# Query_time: 5.584208 Lock_time: 0.000110 Rows_sent: 20 Rows_examined: 84846
SET timestamp=1452529896;
SELECT et.tag, count(et.tag) AS total
FROM tb_entrytags AS et
LEFT OUTER JOIN tb_entries AS e
ON et.entryid = e.id
WHERE e.isdraft = 'false' AND e.timestamp <= 1452529891
GROUP BY et.tag
HAVING count(et.tag) >= 2
ORDER BY total DESC LIMIT 20;
# Time: 160111 17:31:41
# User@Host: duckhome[duckhome] @ [127.0.0.1]
# Query_time: 5.779132 Lock_time: 0.000105 Rows_sent: 20 Rows_examined: 84846
SET timestamp=1452529901;
SELECT et.tag, count(et.tag) AS total
FROM tb_entrytags AS et
LEFT OUTER JOIN tb_entries AS e
ON et.entryid = e.id
WHERE e.isdraft = 'false' AND e.timestamp <= 1452529895
GROUP BY et.tag
HAVING count(et.tag) >= 2
ORDER BY total DESC LIMIT 20;
# Time: 160111 17:31:46
# User@Host: duckhome[duckhome] @ [127.0.0.1]
# Query_time: 5.342892 Lock_time: 0.000071 Rows_sent: 20 Rows_examined: 84846
SET timestamp=1452529906;
SELECT et.tag, count(et.tag) AS total
FROM tb_entrytags AS et
LEFT OUTER JOIN tb_entries AS e
ON et.entryid = e.id
WHERE e.isdraft = 'false' AND e.timestamp <= 1452529900
GROUP BY et.tag
HAVING count(et.tag) >= 2
ORDER BY total DESC LIMIT 20;
# Time: 160111 17:31:47
# User@Host: duckhome[duckhome] @ [127.0.0.1]
# Query_time: 6.038121 Lock_time: 0.000108 Rows_sent: 5 Rows_examined: 31268
SET timestamp=1452529907;
SELECT DISTINCT id,
title,
timestamp,
epm.value AS multilingual_title
FROM tb_entries AS e
LEFT OUTER JOIN tb_entrycat AS ec ON id = ec.entryid LEFT OUTER JOIN tb_category AS c ON ec.categoryid = c.categoryid
LEFT OUTER JOIN tb_entryproperties AS epm
ON (epm.entryid = e.id AND epm.property = 'multilingual_title_de')
WHERE isdraft = 'false' AND timestamp <= 1452529901
ORDER BY timestamp DESC
LIMIT 5;
# Time: 160111 17:31:48
# User@Host: duckhome[duckhome] @ [127.0.0.1]
# Query_time: 5.609230 Lock_time: 0.000136 Rows_sent: 5 Rows_examined: 31268
SET timestamp=1452529908;
SELECT DISTINCT id,
title,
timestamp,
epm.value AS multilingual_title
FROM tb_entries AS e
LEFT OUTER JOIN tb_entrycat AS ec ON id = ec.entryid LEFT OUTER JOIN tb_category AS c ON ec.categoryid = c.categoryid
LEFT OUTER JOIN tb_entryproperties AS epm
ON (epm.entryid = e.id AND epm.property = 'multilingual_title_de')
WHERE isdraft = 'false' AND timestamp <= 1452529903
ORDER BY timestamp DESC
LIMIT 5;
# Time: 160111 17:31:50
# User@Host: duckhome[duckhome] @ [127.0.0.1]
# Query_time: 5.930440 Lock_time: 0.000137 Rows_sent: 5 Rows_examined: 31268
SET timestamp=1452529910;
SELECT DISTINCT id,
title,
timestamp,
epm.value AS multilingual_title
FROM tb_entries AS e
LEFT OUTER JOIN tb_entrycat AS ec ON id = ec.entryid LEFT OUTER JOIN tb_category AS c ON ec.categoryid = c.categoryid
LEFT OUTER JOIN tb_entryproperties AS epm
ON (epm.entryid = e.id AND epm.property = 'multilingual_title_de')
WHERE isdraft = 'false' AND timestamp <= 1452529904
ORDER BY timestamp DESC
LIMIT 5;
# Time: 160111 17:31:51
# User@Host: duckhome[duckhome] @ [127.0.0.1]
# Query_time: 6.249322 Lock_time: 0.000110 Rows_sent: 5 Rows_examined: 31268
SET timestamp=1452529911;
SELECT DISTINCT id,
title,
timestamp,
epm.value AS multilingual_title
FROM tb_entries AS e
LEFT OUTER JOIN tb_entrycat AS ec ON id = ec.entryid LEFT OUTER JOIN tb_category AS c ON ec.categoryid = c.categoryid
LEFT OUTER JOIN tb_entryproperties AS epm
ON (epm.entryid = e.id AND epm.property = 'multilingual_title_de')
WHERE isdraft = 'false' AND timestamp <= 1452529905
ORDER BY timestamp DESC
LIMIT 5;
# Time: 160111 17:31:52
# User@Host: duckhome[duckhome] @ [127.0.0.1]
# Query_time: 6.438452 Lock_time: 0.000078 Rows_sent: 5 Rows_examined: 31268
SET timestamp=1452529912;
SELECT DISTINCT id,
title,
timestamp,
epm.value AS multilingual_title
FROM tb_entries AS e
LEFT OUTER JOIN tb_entrycat AS ec ON id = ec.entryid LEFT OUTER JOIN tb_category AS c ON ec.categoryid = c.categoryid
LEFT OUTER JOIN tb_entryproperties AS epm
ON (epm.entryid = e.id AND epm.property = 'multilingual_title_de')
WHERE isdraft = 'false' AND timestamp <= 1452529906
ORDER BY timestamp DESC
LIMIT 5;
# Time: 160111 17:31:53
# User@Host: duckhome[duckhome] @ [127.0.0.1]
# Query_time: 5.342757 Lock_time: 0.000091 Rows_sent: 20 Rows_examined: 84846
SET timestamp=1452529913;
SELECT et.tag, count(et.tag) AS total
FROM tb_entrytags AS et
LEFT OUTER JOIN tb_entries AS e
ON et.entryid = e.id
WHERE e.isdraft = 'false' AND e.timestamp <= 1452529907
GROUP BY et.tag
HAVING count(et.tag) >= 2
ORDER BY total DESC LIMIT 20;
# User@Host: duckhome[duckhome] @ [127.0.0.1]
# Query_time: 7.639211 Lock_time: 0.000126 Rows_sent: 5 Rows_examined: 31268
SET timestamp=1452529913;
SELECT DISTINCT id,
title,
timestamp,
epm.value AS multilingual_title
FROM tb_entries AS e
LEFT OUTER JOIN tb_entrycat AS ec ON id = ec.entryid LEFT OUTER JOIN tb_category AS c ON ec.categoryid = c.categoryid
LEFT OUTER JOIN tb_entryproperties AS epm
ON (epm.entryid = e.id AND epm.property = 'multilingual_title_de')
WHERE isdraft = 'false' AND timestamp <= 1452529906
ORDER BY timestamp DESC
LIMIT 5;
# Time: 160111 17:31:55
# User@Host: duckhome[duckhome] @ [127.0.0.1]
# Query_time: 6.529346 Lock_time: 0.000106 Rows_sent: 20 Rows_examined: 84846
SET timestamp=1452529915;
SELECT et.tag, count(et.tag) AS total
FROM tb_entrytags AS et
LEFT OUTER JOIN tb_entries AS e
ON et.entryid = e.id
WHERE e.isdraft = 'false' AND e.timestamp <= 1452529908
GROUP BY et.tag
HAVING count(et.tag) >= 2
ORDER BY total DESC LIMIT 20;
# User@Host: duckhome[duckhome] @ [127.0.0.1]
# Query_time: 5.655709 Lock_time: 0.000115 Rows_sent: 5 Rows_examined: 31268
SET timestamp=1452529915;
SELECT DISTINCT id,
title,
timestamp,
epm.value AS multilingual_title
FROM tb_entries AS e
LEFT OUTER JOIN tb_entrycat AS ec ON id = ec.entryid LEFT OUTER JOIN tb_category AS c ON ec.categoryid = c.categoryid
LEFT OUTER JOIN tb_entryproperties AS epm
ON (epm.entryid = e.id AND epm.property = 'multilingual_title_de')
WHERE isdraft = 'false' AND timestamp <= 1452529909
ORDER BY timestamp DESC
LIMIT 5;
# User@Host: duckhome[duckhome] @ [127.0.0.1]
# Query_time: 5.687785 Lock_time: 0.037317 Rows_sent: 20 Rows_examined: 84846
SET timestamp=1452529915;
SELECT et.tag, count(et.tag) AS total
FROM tb_entrytags AS et
LEFT OUTER JOIN tb_entries AS e
ON et.entryid = e.id
WHERE e.isdraft = 'false' AND e.timestamp <= 1452529910
GROUP BY et.tag
HAVING count(et.tag) >= 2
ORDER BY total DESC LIMIT 20;
# Time: 160111 17:31:57
# User@Host: duckhome[duckhome] @ [127.0.0.1]
# Query_time: 6.328910 Lock_time: 0.000106 Rows_sent: 20 Rows_examined: 84846
SET timestamp=1452529917;
SELECT et.tag, count(et.tag) AS total
FROM tb_entrytags AS et
LEFT OUTER JOIN tb_entries AS e
ON et.entryid = e.id
WHERE e.isdraft = 'false' AND e.timestamp <= 1452529911
GROUP BY et.tag
HAVING count(et.tag) >= 2
ORDER BY total DESC LIMIT 20;
# Time: 160111 17:31:58
# User@Host: duckhome[duckhome] @ [127.0.0.1]
# Query_time: 6.250560 Lock_time: 0.000118 Rows_sent: 5 Rows_examined: 31268
SET timestamp=1452529918;
SELECT DISTINCT id,
title,
timestamp,
epm.value AS multilingual_title
FROM tb_entries AS e
LEFT OUTER JOIN tb_entrycat AS ec ON id = ec.entryid LEFT OUTER JOIN tb_category AS c ON ec.categoryid = c.categoryid
LEFT OUTER JOIN tb_entryproperties AS epm
ON (epm.entryid = e.id AND epm.property = 'multilingual_title_de')
WHERE isdraft = 'false' AND timestamp <= 1452529911
ORDER BY timestamp DESC
LIMIT 5;
# User@Host: duckhome[duckhome] @ [127.0.0.1]
# Query_time: 5.532782 Lock_time: 0.000109 Rows_sent: 20 Rows_examined: 84846
SET timestamp=1452529918;
SELECT et.tag, count(et.tag) AS total
FROM tb_entrytags AS et
LEFT OUTER JOIN tb_entries AS e
ON et.entryid = e.id
WHERE e.isdraft = 'false' AND e.timestamp <= 1452529912
GROUP BY et.tag
HAVING count(et.tag) >= 2
ORDER BY total DESC LIMIT 20;
# Time: 160111 17:32:00
# User@Host: duckhome[duckhome] @ [127.0.0.1]
# Query_time: 6.548475 Lock_time: 0.000094 Rows_sent: 20 Rows_examined: 84846
SET timestamp=1452529920;
SELECT et.tag, count(et.tag) AS total
FROM tb_entrytags AS et
LEFT OUTER JOIN tb_entries AS e
ON et.entryid = e.id
WHERE e.isdraft = 'false' AND e.timestamp <= 1452529913
GROUP BY et.tag
HAVING count(et.tag) >= 2
ORDER BY total DESC LIMIT 20;
# User@Host: duckhome[duckhome] @ [127.0.0.1]
# Query_time: 5.098582 Lock_time: 0.000103 Rows_sent: 20 Rows_examined: 84846
SET timestamp=1452529920;
SELECT et.tag, count(et.tag) AS total
FROM tb_entrytags AS et
LEFT OUTER JOIN tb_entries AS e
ON et.entryid = e.id
WHERE e.isdraft = 'false' AND e.timestamp <= 1452529915
GROUP BY et.tag
HAVING count(et.tag) >= 2
ORDER BY total DESC LIMIT 20;
# Time: 160111 17:32:02
# User@Host: duckhome[duckhome] @ [127.0.0.1]
# Query_time: 5.900111 Lock_time: 0.000085 Rows_sent: 5 Rows_examined: 31268
SET timestamp=1452529922;
SELECT DISTINCT id,
title,
timestamp,
epm.value AS multilingual_title
FROM tb_entries AS e
LEFT OUTER JOIN tb_entrycat AS ec ON id = ec.entryid LEFT OUTER JOIN tb_category AS c ON ec.categoryid = c.categoryid
LEFT OUTER JOIN tb_entryproperties AS epm
ON (epm.entryid = e.id AND epm.property = 'multilingual_title_de')
WHERE isdraft = 'false' AND timestamp <= 1452529916
ORDER BY timestamp DESC
LIMIT 5;
# Time: 160111 17:32:04
# User@Host: duckhome[duckhome] @ [127.0.0.1]
# Query_time: 5.058314 Lock_time: 0.000120 Rows_sent: 5 Rows_examined: 31268
SET timestamp=1452529924;
SELECT DISTINCT id,
title,
timestamp,
epm.value AS multilingual_title
FROM tb_entries AS e
LEFT OUTER JOIN tb_entrycat AS ec ON id = ec.entryid LEFT OUTER JOIN tb_category AS c ON ec.categoryid = c.categoryid
LEFT OUTER JOIN tb_entryproperties AS epm
ON (epm.entryid = e.id AND epm.property = 'multilingual_title_de')
WHERE isdraft = 'false' AND timestamp <= 1452529919
ORDER BY timestamp DESC
LIMIT 5;
# Time: 160111 17:32:10
# User@Host: duckhome[duckhome] @ [127.0.0.1]
# Query_time: 5.377497 Lock_time: 0.000136 Rows_sent: 5 Rows_examined: 31268
SET timestamp=1452529930;
SELECT DISTINCT id,
title,
timestamp,
epm.value AS multilingual_title
FROM tb_entries AS e
LEFT OUTER JOIN tb_entrycat AS ec ON id = ec.entryid LEFT OUTER JOIN tb_category AS c ON ec.categoryid = c.categoryid
LEFT OUTER JOIN tb_entryproperties AS epm
ON (epm.entryid = e.id AND epm.property = 'multilingual_title_de')
WHERE isdraft = 'false' AND timestamp <= 1452529925
ORDER BY timestamp DESC
LIMIT 5;
# Time: 160111 17:32:13
# User@Host: duckhome[duckhome] @ [127.0.0.1]
# Query_time: 7.110090 Lock_time: 0.000102 Rows_sent: 20 Rows_examined: 84846
SET timestamp=1452529933;
SELECT et.tag, count(et.tag) AS total
FROM tb_entrytags AS et
LEFT OUTER JOIN tb_entries AS e
ON et.entryid = e.id
WHERE e.isdraft = 'false' AND e.timestamp <= 1452529926
GROUP BY et.tag
HAVING count(et.tag) >= 2
ORDER BY total DESC LIMIT 20;
# Time: 160111 17:32:17
# User@Host: duckhome[duckhome] @ [127.0.0.1]
# Query_time: 6.303260 Lock_time: 0.000119 Rows_sent: 5 Rows_examined: 31268
SET timestamp=1452529937;
SELECT DISTINCT id,
title,
timestamp,
epm.value AS multilingual_title
FROM tb_entries AS e
LEFT OUTER JOIN tb_entrycat AS ec ON id = ec.entryid LEFT OUTER JOIN tb_category AS c ON ec.categoryid = c.categoryid
LEFT OUTER JOIN tb_entryproperties AS epm
ON (epm.entryid = e.id AND epm.property = 'multilingual_title_de')
WHERE isdraft = 'false' AND timestamp <= 1452529930
ORDER BY timestamp DESC
LIMIT 5;
# Time: 160111 17:32:18
# User@Host: duckhome[duckhome] @ [127.0.0.1]
# Query_time: 6.421579 Lock_time: 0.000088 Rows_sent: 5 Rows_examined: 31268
SET timestamp=1452529938;
SELECT DISTINCT id,
title,
timestamp,
epm.value AS multilingual_title
FROM tb_entries AS e
LEFT OUTER JOIN tb_entrycat AS ec ON id = ec.entryid LEFT OUTER JOIN tb_category AS c ON ec.categoryid = c.categoryid
LEFT OUTER JOIN tb_entryproperties AS epm
ON (epm.entryid = e.id AND epm.property = 'multilingual_title_de')
WHERE isdraft = 'false' AND timestamp <= 1452529931
ORDER BY timestamp DESC
LIMIT 5;
# User@Host: duckhome[duckhome] @ [127.0.0.1]
# Query_time: 7.606196 Lock_time: 0.000083 Rows_sent: 20 Rows_examined: 84846
SET timestamp=1452529938;
SELECT et.tag, count(et.tag) AS total
FROM tb_entrytags AS et
LEFT OUTER JOIN tb_entries AS e
ON et.entryid = e.id
WHERE e.isdraft = 'false' AND e.timestamp <= 1452529930
GROUP BY et.tag
HAVING count(et.tag) >= 2
ORDER BY total DESC LIMIT 20;
# Time: 160111 17:32:21
# User@Host: duckhome[duckhome] @ [127.0.0.1]
# Query_time: 7.978071 Lock_time: 0.000174 Rows_sent: 25 Rows_examined: 21691
SET timestamp=1452529941;
SELECT
ep_sticky.value AS orderkey,
e.id,
e.title,
e.timestamp,
e.comments,
e.exflag,
e.authorid,
e.trackbacks,
e.isdraft,
e.allow_comments,
e.last_modified,
a.realname AS author,
a.username AS loginname,
a.email
, e.body, e.extended
FROM
tb_entries AS e
LEFT JOIN tb_authors a
ON e.authorid = a.authorid
LEFT JOIN tb_entrycat ec
ON e.id = ec.entryid
LEFT JOIN tb_category c
ON ec.categoryid = c.categoryid
LEFT OUTER JOIN tb_entryproperties ep_access
ON (e.id = ep_access.entryid AND ep_access.property = 'ep_access')
LEFT JOIN tb_entryproperties ep_sticky
ON (e.id = ep_sticky.entryid AND ep_sticky.property = 'ep_is_sticky')
WHERE isdraft = 'false' AND (e.authorid = 1) AND e.timestamp <= 1452530100 AND (ep_access.property IS NULL OR ep_access.value = 'public')
GROUP BY e.id
ORDER BY orderkey DESC, timestamp DESC
LIMIT 125, 25;
# Time: 160111 17:32:22
# User@Host: duckhome[duckhome] @ [127.0.0.1]
# Query_time: 5.066724 Lock_time: 0.000092 Rows_sent: 20 Rows_examined: 84846
SET timestamp=1452529942;
SELECT et.tag, count(et.tag) AS total
FROM tb_entrytags AS et
LEFT OUTER JOIN tb_entries AS e
ON et.entryid = e.id
WHERE e.isdraft = 'false' AND e.timestamp <= 1452529937
GROUP BY et.tag
HAVING count(et.tag) >= 2
ORDER BY total DESC LIMIT 20;
# Time: 160111 17:32:23
# User@Host: duckhome[duckhome] @ [127.0.0.1]
# Query_time: 5.161230 Lock_time: 0.000100 Rows_sent: 20 Rows_examined: 84846
SET timestamp=1452529943;
SELECT et.tag, count(et.tag) AS total
FROM tb_entrytags AS et
LEFT OUTER JOIN tb_entries AS e
ON et.entryid = e.id
WHERE e.isdraft = 'false' AND e.timestamp <= 1452529938
GROUP BY et.tag
HAVING count(et.tag) >= 2
ORDER BY total DESC LIMIT 20;
# User@Host: duckhome[duckhome] @ [127.0.0.1]
# Query_time: 15.087449 Lock_time: 0.000075 Rows_sent: 12373 Rows_examined: 74437
use duckhome_db2;
SET timestamp=1452529943;
select distinct ta.`action`, ta.`lastModif`, ta.`user`, ta.`ip`, ta.`object`, thf.`comment`, thf.`version`, thf.`page_id` from `tiki_actionlog` ta
inner join (select th.`version`, th.`comment`, th.`pageName`, th.`lastModif`, tp.`page_id` from `tiki_history` as th LEFT OUTER JOIN `tiki_pages` tp ON tp.`pageName` = th.`pageName` AND tp.`version` = th.`version`) as thf on ta.`object`=thf.`pageName` and ta.`lastModif`=thf.`lastModif` and ta.`objectType`='wiki page' where true order by ta.`lastModif` asc;
# Time: 160111 17:32:24
# User@Host: duckhome[duckhome] @ [127.0.0.1]
# Query_time: 6.578128 Lock_time: 0.000110 Rows_sent: 5 Rows_examined: 31268
use duckhome_db1;
SET timestamp=1452529944;
SELECT DISTINCT id,
title,
timestamp,
epm.value AS multilingual_title
FROM tb_entries AS e
LEFT OUTER JOIN tb_entrycat AS ec ON id = ec.entryid LEFT OUTER JOIN tb_category AS c ON ec.categoryid = c.categoryid
LEFT OUTER JOIN tb_entryproperties AS epm
ON (epm.entryid = e.id AND epm.property = 'multilingual_title_de')
WHERE isdraft = 'false' AND timestamp <= 1452529937
ORDER BY timestamp DESC
LIMIT 5;
# Time: 160111 17:32:28
# User@Host: duckhome[duckhome] @ [127.0.0.1]
# Query_time: 5.298866 Lock_time: 0.000096 Rows_sent: 20 Rows_examined: 84846
SET timestamp=1452529948;
SELECT et.tag, count(et.tag) AS total
FROM tb_entrytags AS et
LEFT OUTER JOIN tb_entries AS e
ON et.entryid = e.id
WHERE e.isdraft = 'false' AND e.timestamp <= 1452529943
GROUP BY et.tag
HAVING count(et.tag) >= 2
ORDER BY total DESC LIMIT 20;
# Time: 160111 17:32:29
# User@Host: duckhome[duckhome] @ [127.0.0.1]
# Query_time: 5.579969 Lock_time: 0.000111 Rows_sent: 20 Rows_examined: 84846
SET timestamp=1452529949;
SELECT et.tag, count(et.tag) AS total
FROM tb_entrytags AS et
LEFT OUTER JOIN tb_entries AS e
ON et.entryid = e.id
WHERE e.isdraft = 'false' AND e.timestamp <= 1452529944
GROUP BY et.tag
HAVING count(et.tag) >= 2
ORDER BY total DESC LIMIT 20;
# Time: 160111 17:32:35
# User@Host: duckhome[duckhome] @ [127.0.0.1]
# Query_time: 5.715054 Lock_time: 0.000073 Rows_sent: 5 Rows_examined: 31268
SET timestamp=1452529955;
SELECT DISTINCT id,
title,
timestamp,
epm.value AS multilingual_title
FROM tb_entries AS e
LEFT OUTER JOIN tb_entrycat AS ec ON id = ec.entryid LEFT OUTER JOIN tb_category AS c ON ec.categoryid = c.categoryid
LEFT OUTER JOIN tb_entryproperties AS epm
ON (epm.entryid = e.id AND epm.property = 'multilingual_title_de')
WHERE isdraft = 'false' AND timestamp <= 1452529950
ORDER BY timestamp DESC
LIMIT 5;
# Time: 160111 17:32:36
# User@Host: duckhome[duckhome] @ [127.0.0.1]
# Query_time: 6.117969 Lock_time: 0.000102 Rows_sent: 5 Rows_examined: 31268
SET timestamp=1452529956;
SELECT DISTINCT id,
title,
timestamp,
epm.value AS multilingual_title
FROM tb_entries AS e
LEFT OUTER JOIN tb_entrycat AS ec ON id = ec.entryid LEFT OUTER JOIN tb_category AS c ON ec.categoryid = c.categoryid
LEFT OUTER JOIN tb_entryproperties AS epm
ON (epm.entryid = e.id AND epm.property = 'multilingual_title_de')
WHERE isdraft = 'false' AND timestamp <= 1452529950
ORDER BY timestamp DESC
LIMIT 5;
# User@Host: duckhome[duckhome] @ [127.0.0.1]
# Query_time: 6.227077 Lock_time: 0.000098 Rows_sent: 20 Rows_examined: 84846
SET timestamp=1452529956;
SELECT et.tag, count(et.tag) AS total
FROM tb_entrytags AS et
LEFT OUTER JOIN tb_entries AS e
ON et.entryid = e.id
WHERE e.isdraft = 'false' AND e.timestamp <= 1452529950
GROUP BY et.tag
HAVING count(et.tag) >= 2
ORDER BY total DESC LIMIT 20;
# Time: 160111 17:32:38
# User@Host: duckhome[duckhome] @ [127.0.0.1]
# Query_time: 6.449672 Lock_time: 0.000110 Rows_sent: 5 Rows_examined: 31268
SET timestamp=1452529958;
SELECT DISTINCT id,
title,
timestamp,
epm.value AS multilingual_title
FROM tb_entries AS e
LEFT OUTER JOIN tb_entrycat AS ec ON id = ec.entryid LEFT OUTER JOIN tb_category AS c ON ec.categoryid = c.categoryid
LEFT OUTER JOIN tb_entryproperties AS epm
ON (epm.entryid = e.id AND epm.property = 'multilingual_title_de')
WHERE isdraft = 'false' AND timestamp <= 1452529951
ORDER BY timestamp DESC
LIMIT 5;
# Time: 160111 17:32:42
# User@Host: duckhome[duckhome] @ [127.0.0.1]
# Query_time: 5.924960 Lock_time: 0.000610 Rows_sent: 20 Rows_examined: 84846
SET timestamp=1452529962;
SELECT et.tag, count(et.tag) AS total
FROM tb_entrytags AS et
LEFT OUTER JOIN tb_entries AS e
ON et.entryid = e.id
WHERE e.isdraft = 'false' AND e.timestamp <= 1452529956
GROUP BY et.tag
HAVING count(et.tag) >= 2
ORDER BY total DESC LIMIT 20;
# User@Host: duckhome[duckhome] @ [127.0.0.1]
# Query_time: 7.356291 Lock_time: 0.000135 Rows_sent: 25 Rows_examined: 25541
SET timestamp=1452529962;
SELECT
ep_sticky.value AS orderkey,
e.id,
e.title,
e.timestamp,
e.comments,
e.exflag,
e.authorid,
e.trackbacks,
e.isdraft,
e.allow_comments,
e.last_modified,
a.realname AS author,
a.username AS loginname,
a.email
, e.body, e.extended
FROM
tb_entries AS e
LEFT JOIN tb_authors a
ON e.authorid = a.authorid
LEFT JOIN tb_entrycat ec
ON e.id = ec.entryid
LEFT JOIN tb_category c
ON ec.categoryid = c.categoryid
LEFT OUTER JOIN tb_entryproperties ep_access
ON (e.id = ep_access.entryid AND ep_access.property = 'ep_access')
LEFT JOIN tb_entryproperties ep_sticky
ON (e.id = ep_sticky.entryid AND ep_sticky.property = 'ep_is_sticky')
WHERE isdraft = 'false' AND (e.authorid = 1) AND e.timestamp <= 1452530100 AND (ep_access.property IS NULL OR ep_access.value = 'public')
GROUP BY e.id
ORDER BY orderkey DESC, timestamp DESC
LIMIT 3975, 25;
# Time: 160111 17:32:43
# User@Host: duckhome[duckhome] @ [127.0.0.1]
# Query_time: 5.417991 Lock_time: 0.000110 Rows_sent: 20 Rows_examined: 84846
SET timestamp=1452529963;
SELECT et.tag, count(et.tag) AS total
FROM tb_entrytags AS et
LEFT OUTER JOIN tb_entries AS e
ON et.entryid = e.id
WHERE e.isdraft = 'false' AND e.timestamp <= 1452529958
GROUP BY et.tag
HAVING count(et.tag) >= 2
ORDER BY total DESC LIMIT 20;
# User@Host: duckhome[duckhome] @ [127.0.0.1]
# Query_time: 5.841790 Lock_time: 0.000112 Rows_sent: 5 Rows_examined: 31268
SET timestamp=1452529963;
SELECT DISTINCT id,
title,
timestamp,
epm.value AS multilingual_title
FROM tb_entries AS e
LEFT OUTER JOIN tb_entrycat AS ec ON id = ec.entryid LEFT OUTER JOIN tb_category AS c ON ec.categoryid = c.categoryid
LEFT OUTER JOIN tb_entryproperties AS epm
ON (epm.entryid = e.id AND epm.property = 'multilingual_title_de')
WHERE isdraft = 'false' AND timestamp <= 1452529958
ORDER BY timestamp DESC
LIMIT 5;
# Time: 160111 17:32:47
# User@Host: duckhome[duckhome] @ [127.0.0.1]
# Query_time: 6.048079 Lock_time: 0.000112 Rows_sent: 5 Rows_examined: 31268
SET timestamp=1452529967;
SELECT DISTINCT id,
title,
timestamp,
epm.value AS multilingual_title
FROM tb_entries AS e
LEFT OUTER JOIN tb_entrycat AS ec ON id = ec.entryid LEFT OUTER JOIN tb_category AS c ON ec.categoryid = c.categoryid
LEFT OUTER JOIN tb_entryproperties AS epm
ON (epm.entryid = e.id AND epm.property = 'multilingual_title_de')
WHERE isdraft = 'false' AND timestamp <= 1452529961
ORDER BY timestamp DESC
LIMIT 5;
# Time: 160111 17:32:49
# User@Host: duckhome[duckhome] @ [127.0.0.1]
# Query_time: 5.027549 Lock_time: 0.000072 Rows_sent: 20 Rows_examined: 84846
SET timestamp=1452529969;
SELECT et.tag, count(et.tag) AS total
FROM tb_entrytags AS et
LEFT OUTER JOIN tb_entries AS e
ON et.entryid = e.id
WHERE e.isdraft = 'false' AND e.timestamp <= 1452529964
GROUP BY et.tag
HAVING count(et.tag) >= 2
ORDER BY total DESC LIMIT 20;
# Time: 160111 17:32:51
# User@Host: duckhome[duckhome] @ [127.0.0.1]
# Query_time: 6.411341 Lock_time: 0.000112 Rows_sent: 5 Rows_examined: 31268
SET timestamp=1452529971;
SELECT DISTINCT id,
title,
timestamp,
epm.value AS multilingual_title
FROM tb_entries AS e
LEFT OUTER JOIN tb_entrycat AS ec ON id = ec.entryid LEFT OUTER JOIN tb_category AS c ON ec.categoryid = c.categoryid
LEFT OUTER JOIN tb_entryproperties AS epm
ON (epm.entryid = e.id AND epm.property = 'multilingual_title_de')
WHERE isdraft = 'false' AND timestamp <= 1452529964
ORDER BY timestamp DESC
LIMIT 5;
# Time: 160111 17:32:53
# User@Host: duckhome[duckhome] @ [127.0.0.1]
# Query_time: 5.426847 Lock_time: 0.000101 Rows_sent: 20 Rows_examined: 84846
SET timestamp=1452529973;
SELECT et.tag, count(et.tag) AS total
FROM tb_entrytags AS et
LEFT OUTER JOIN tb_entries AS e
ON et.entryid = e.id
WHERE e.isdraft = 'false' AND e.timestamp <= 1452529967
GROUP BY et.tag
HAVING count(et.tag) >= 2
ORDER BY total DESC LIMIT 20;
# User@Host: duckhome[duckhome] @ [127.0.0.1]
# Query_time: 8.709759 Lock_time: 0.000143 Rows_sent: 25 Rows_examined: 21591
SET timestamp=1452529973;
SELECT
ep_sticky.value AS orderkey,
e.id,
e.title,
e.timestamp,
e.comments,
e.exflag,
e.authorid,
e.trackbacks,
e.isdraft,
e.allow_comments,
e.last_modified,
a.realname AS author,
a.username AS loginname,
a.email
, e.body, e.extended
FROM
tb_entries AS e
LEFT JOIN tb_authors a
ON e.authorid = a.authorid
LEFT JOIN tb_entrycat ec
ON e.id = ec.entryid
LEFT JOIN tb_category c
ON ec.categoryid = c.categoryid
LEFT OUTER JOIN tb_entryproperties ep_access
ON (e.id = ep_access.entryid AND ep_access.property = 'ep_access')
LEFT JOIN tb_entryproperties ep_sticky
ON (e.id = ep_sticky.entryid AND ep_sticky.property = 'ep_is_sticky')
WHERE isdraft = 'false' AND (e.authorid = 1) AND e.timestamp <= 1452530100 AND (ep_access.property IS NULL OR ep_access.value = 'public')
GROUP BY e.id
ORDER BY orderkey DESC, timestamp DESC
LIMIT 25, 25;
# Time: 160111 17:32:54
# User@Host: duckhome[duckhome] @ [127.0.0.1]
# Query_time: 5.023299 Lock_time: 0.000142 Rows_sent: 5 Rows_examined: 31268
SET timestamp=1452529974;
SELECT DISTINCT id,
title,
timestamp,
epm.value AS multilingual_title
FROM tb_entries AS e
LEFT OUTER JOIN tb_entrycat AS ec ON id = ec.entryid LEFT OUTER JOIN tb_category AS c ON ec.categoryid = c.categoryid
LEFT OUTER JOIN tb_entryproperties AS epm
ON (epm.entryid = e.id AND epm.property = 'multilingual_title_de')
WHERE isdraft = 'false' AND timestamp <= 1452529969
ORDER BY timestamp DESC
LIMIT 5;
# Time: 160111 17:32:59
# User@Host: duckhome[duckhome] @ [127.0.0.1]
# Query_time: 6.128092 Lock_time: 0.000116 Rows_sent: 5 Rows_examined: 31268
SET timestamp=1452529979;
SELECT DISTINCT id,
title,
timestamp,
epm.value AS multilingual_title
FROM tb_entries AS e
LEFT OUTER JOIN tb_entrycat AS ec ON id = ec.entryid LEFT OUTER JOIN tb_category AS c ON ec.categoryid = c.categoryid
LEFT OUTER JOIN tb_entryproperties AS epm
ON (epm.entryid = e.id AND epm.property = 'multilingual_title_de')
WHERE isdraft = 'false' AND timestamp <= 1452529973
ORDER BY timestamp DESC
LIMIT 5;
# User@Host: duckhome[duckhome] @ [127.0.0.1]
# Query_time: 5.357933 Lock_time: 0.000112 Rows_sent: 5 Rows_examined: 31268
SET timestamp=1452529979;
SELECT DISTINCT id,
title,
timestamp,
epm.value AS multilingual_title
FROM tb_entries AS e
LEFT OUTER JOIN tb_entrycat AS ec ON id = ec.entryid LEFT OUTER JOIN tb_category AS c ON ec.categoryid = c.categoryid
LEFT OUTER JOIN tb_entryproperties AS epm
ON (epm.entryid = e.id AND epm.property = 'multilingual_title_de')
WHERE isdraft = 'false' AND timestamp <= 1452529974
ORDER BY timestamp DESC
LIMIT 5;
# Time: 160111 17:33:00
# User@Host: duckhome[duckhome] @ [127.0.0.1]
# Query_time: 6.197549 Lock_time: 0.000107 Rows_sent: 5 Rows_examined: 31268
SET timestamp=1452529980;
SELECT DISTINCT id,
title,
timestamp,
epm.value AS multilingual_title
FROM tb_entries AS e
LEFT OUTER JOIN tb_entrycat AS ec ON id = ec.entryid LEFT OUTER JOIN tb_category AS c ON ec.categoryid = c.categoryid
LEFT OUTER JOIN tb_entryproperties AS epm
ON (epm.entryid = e.id AND epm.property = 'multilingual_title_de')
WHERE isdraft = 'false' AND timestamp <= 1452529974
ORDER BY timestamp DESC
LIMIT 5;
# Time: 160111 17:33:02
# User@Host: duckhome[duckhome] @ [127.0.0.1]
# Query_time: 5.037850 Lock_time: 0.000127 Rows_sent: 5 Rows_examined: 31268
SET timestamp=1452529982;
SELECT DISTINCT id,
title,
timestamp,
epm.value AS multilingual_title
FROM tb_entries AS e
LEFT OUTER JOIN tb_entrycat AS ec ON id = ec.entryid LEFT OUTER JOIN tb_category AS c ON ec.categoryid = c.categoryid
LEFT OUTER JOIN tb_entryproperties AS epm
ON (epm.entryid = e.id AND epm.property = 'multilingual_title_de')
WHERE isdraft = 'false' AND timestamp <= 1452529977
ORDER BY timestamp DESC
LIMIT 5;
# Time: 160111 17:33:03
# User@Host: duckhome[duckhome] @ [127.0.0.1]
# Query_time: 5.135741 Lock_time: 0.000115 Rows_sent: 5 Rows_examined: 31268
SET timestamp=1452529983;
SELECT DISTINCT id,
title,
timestamp,
epm.value AS multilingual_title
FROM tb_entries AS e
LEFT OUTER JOIN tb_entrycat AS ec ON id = ec.entryid LEFT OUTER JOIN tb_category AS c ON ec.categoryid = c.categoryid
LEFT OUTER JOIN tb_entryproperties AS epm
ON (epm.entryid = e.id AND epm.property = 'multilingual_title_de')
WHERE isdraft = 'false' AND timestamp <= 1452529978
ORDER BY timestamp DESC
LIMIT 5;
# Time: 160111 17:33:17
# User@Host: duckhome[duckhome] @ [127.0.0.1]
# Query_time: 13.262791 Lock_time: 0.000134 Rows_sent: 12373 Rows_examined: 74437
use duckhome_db2;
SET timestamp=1452529997;
select distinct ta.`action`, ta.`lastModif`, ta.`user`, ta.`ip`, ta.`object`, thf.`comment`, thf.`version`, thf.`page_id` from `tiki_actionlog` ta
inner join (select th.`version`, th.`comment`, th.`pageName`, th.`lastModif`, tp.`page_id` from `tiki_history` as th LEFT OUTER JOIN `tiki_pages` tp ON tp.`pageName` = th.`pageName` AND tp.`version` = th.`version`) as thf on ta.`object`=thf.`pageName` and ta.`lastModif`=thf.`lastModif` and ta.`objectType`='wiki page' where true order by ta.`user` desc;
# Time: 160111 17:33:18
# User@Host: duckhome[duckhome] @ [127.0.0.1]
# Query_time: 6.244533 Lock_time: 0.000097 Rows_sent: 20 Rows_examined: 84846
use duckhome_db1;
SET timestamp=1452529998;
SELECT et.tag, count(et.tag) AS total
FROM tb_entrytags AS et
LEFT OUTER JOIN tb_entries AS e
ON et.entryid = e.id
WHERE e.isdraft = 'false' AND e.timestamp <= 1452529992
GROUP BY et.tag
HAVING count(et.tag) >= 2
ORDER BY total DESC LIMIT 20;
# Time: 160111 17:33:19
# User@Host: duckhome[duckhome] @ [127.0.0.1]
# Query_time: 6.942869 Lock_time: 0.000086 Rows_sent: 20 Rows_examined: 84846
SET timestamp=1452529999;
SELECT et.tag, count(et.tag) AS total
FROM tb_entrytags AS et
LEFT OUTER JOIN tb_entries AS e
ON et.entryid = e.id
WHERE e.isdraft = 'false' AND e.timestamp <= 1452529992
GROUP BY et.tag
HAVING count(et.tag) >= 2
ORDER BY total DESC LIMIT 20;
# User@Host: duckhome[duckhome] @ [127.0.0.1]
# Query_time: 7.767833 Lock_time: 0.000178 Rows_sent: 25 Rows_examined: 21966
SET timestamp=1452529999;
SELECT
ep_sticky.value AS orderkey,
e.id,
e.title,
e.timestamp,
e.comments,
e.exflag,
e.authorid,
e.trackbacks,
e.isdraft,
e.allow_comments,
e.last_modified,
a.realname AS author,
a.username AS loginname,
a.email
, e.body, e.extended
FROM
tb_entries AS e
LEFT JOIN tb_authors a
ON e.authorid = a.authorid
LEFT JOIN tb_entrycat ec
ON e.id = ec.entryid
LEFT JOIN tb_category c
ON ec.categoryid = c.categoryid
LEFT OUTER JOIN tb_entryproperties ep_access
ON (e.id = ep_access.entryid AND ep_access.property = 'ep_access')
LEFT JOIN tb_entryproperties ep_sticky
ON (e.id = ep_sticky.entryid AND ep_sticky.property = 'ep_is_sticky')
WHERE isdraft = 'false' AND (e.authorid = 1) AND e.timestamp <= 1452530100 AND (ep_access.property IS NULL OR ep_access.value = 'public')
GROUP BY e.id
ORDER BY orderkey DESC, timestamp DESC
LIMIT 400, 25;
# Time: 160111 17:33:20
# User@Host: duckhome[duckhome] @ [127.0.0.1]
# Query_time: 6.021639 Lock_time: 0.000104 Rows_sent: 5 Rows_examined: 31268
SET timestamp=1452530000;
SELECT DISTINCT id,
title,
timestamp,
epm.value AS multilingual_title
FROM tb_entries AS e
LEFT OUTER JOIN tb_entrycat AS ec ON id = ec.entryid LEFT OUTER JOIN tb_category AS c ON ec.categoryid = c.categoryid
LEFT OUTER JOIN tb_entryproperties AS epm
ON (epm.entryid = e.id AND epm.property = 'multilingual_title_de')
WHERE isdraft = 'false' AND timestamp <= 1452529994
ORDER BY timestamp DESC
LIMIT 5;
# Time: 160111 17:33:22
# User@Host: duckhome[duckhome] @ [127.0.0.1]
# Query_time: 6.841931 Lock_time: 0.000129 Rows_sent: 5 Rows_examined: 31268
SET timestamp=1452530002;
SELECT DISTINCT id,
title,
timestamp,
epm.value AS multilingual_title
FROM tb_entries AS e
LEFT OUTER JOIN tb_entrycat AS ec ON id = ec.entryid LEFT OUTER JOIN tb_category AS c ON ec.categoryid = c.categoryid
LEFT OUTER JOIN tb_entryproperties AS epm
ON (epm.entryid = e.id AND epm.property = 'multilingual_title_de')
WHERE isdraft = 'false' AND timestamp <= 1452529995
ORDER BY timestamp DESC
LIMIT 5;
# Time: 160111 17:33:23
# User@Host: duckhome[duckhome] @ [127.0.0.1]
# Query_time: 8.053549 Lock_time: 0.000168 Rows_sent: 25 Rows_examined: 21566
SET timestamp=1452530003;
SELECT
ep_sticky.value AS orderkey,
e.id,
e.title,
e.timestamp,
e.comments,
e.exflag,
e.authorid,
e.trackbacks,
e.isdraft,
e.allow_comments,
e.last_modified,
a.realname AS author,
a.username AS loginname,
a.email
, e.body, e.extended
FROM
tb_entries AS e
LEFT JOIN tb_authors a
ON e.authorid = a.authorid
LEFT JOIN tb_entrycat ec
ON e.id = ec.entryid
LEFT JOIN tb_category c
ON ec.categoryid = c.categoryid
LEFT OUTER JOIN tb_entryproperties ep_access
ON (e.id = ep_access.entryid AND ep_access.property = 'ep_access')
LEFT JOIN tb_entryproperties ep_sticky
ON (e.id = ep_sticky.entryid AND ep_sticky.property = 'ep_is_sticky')
WHERE isdraft = 'false' AND (e.authorid = 1) AND e.timestamp <= 1452530100 AND (ep_access.property IS NULL OR ep_access.value = 'public')
GROUP BY e.id
ORDER BY orderkey DESC, timestamp DESC
LIMIT 25;
# Time: 160111 17:33:26
# User@Host: duckhome[duckhome] @ [127.0.0.1]
# Query_time: 6.206794 Lock_time: 0.000090 Rows_sent: 20 Rows_examined: 84846
SET timestamp=1452530006;
SELECT et.tag, count(et.tag) AS total
FROM tb_entrytags AS et
LEFT OUTER JOIN tb_entries AS e
ON et.entryid = e.id
WHERE e.isdraft = 'false' AND e.timestamp <= 1452530000
GROUP BY et.tag
HAVING count(et.tag) >= 2
ORDER BY total DESC LIMIT 20;
# Time: 160111 17:33:28
Das Probllem ist, das Duckhome plötzlich sehr langsam geworden ist und mein Hoster mir folgendes Mitteilte:
"Auffällig ist, dass MySQL für alle gezeigten Queries wesentlich mehr
Datensätze untersuchen musste, als es zurückgegeben hat. Das deutet auf
sog. Full Table Scans hin, wobei ich das mindestens bei einem Query
nicht nachvollziehen konnte.
Aber vielleicht ist das Produkt aus den Tabellen-Verknüpfungen auch
einfach zu groß um effektiv verarbeitet werden zu können.
Was mir spontan ins Auge gefallen ist, sind Properties mit dem Namen
"multilingual_title_de". Soweit ich weiß ist das keine Funktion die S9Y
so mitbringt, sondern per Plugin nachgerüstet wird. Sollte dem so sein,
schau doch mal, ob Du das Plugin wirklich brauchst oder eher weg tun kannst.
Wobei das natürlich nicht das einzigste ist. "
Hier der Output des Logs:
Time Id Command Argument
# Time: 160111 17:27:01
# User@Host: duckhome[duckhome] @ [127.0.0.1]
# Query_time: 6.354258 Lock_time: 0.000067 Rows_sent: 5 Rows_examined: 31268
use duckhome_db1;
SET timestamp=1452529621;
SELECT DISTINCT id,
title,
timestamp,
epm.value AS multilingual_title
FROM tb_entries AS e
LEFT OUTER JOIN tb_entrycat AS ec ON id = ec.entryid LEFT OUTER JOIN tb_category AS c ON ec.categoryid = c.categoryid
LEFT OUTER JOIN tb_entryproperties AS epm
ON (epm.entryid = e.id AND epm.property = 'multilingual_title_de')
WHERE isdraft = 'false' AND timestamp <= 1452529614
ORDER BY timestamp DESC
LIMIT 5;
# User@Host: duckhome[duckhome] @ [127.0.0.1]
# Query_time: 15.446632 Lock_time: 0.037587 Rows_sent: 25 Rows_examined: 23241
SET timestamp=1452529621;
SELECT
ep_sticky.value AS orderkey,
e.id,
e.title,
e.timestamp,
e.comments,
e.exflag,
e.authorid,
e.trackbacks,
e.isdraft,
e.allow_comments,
e.last_modified,
a.realname AS author,
a.username AS loginname,
a.email
, e.body, e.extended
FROM
tb_entries AS e
LEFT JOIN tb_authors a
ON e.authorid = a.authorid
LEFT JOIN tb_entrycat ec
ON e.id = ec.entryid
LEFT JOIN tb_category c
ON ec.categoryid = c.categoryid
LEFT OUTER JOIN tb_entryproperties ep_access
ON (e.id = ep_access.entryid AND ep_access.property = 'ep_access')
LEFT JOIN tb_entryproperties ep_sticky
ON (e.id = ep_sticky.entryid AND ep_sticky.property = 'ep_is_sticky')
WHERE isdraft = 'false' AND (e.authorid = 1) AND e.timestamp <= 1452529800 AND (ep_access.property IS NULL OR ep_access.value = 'public')
GROUP BY e.id
ORDER BY orderkey DESC, timestamp DESC
LIMIT 1675, 25;
# Time: 160111 17:27:05
# User@Host: duckhome[duckhome] @ [127.0.0.1]
# Query_time: 12.299370 Lock_time: 0.000257 Rows_sent: 1 Rows_examined: 52472
SET timestamp=1452529625;
SELECT
e.isdraft AS orderkey,
ep_cache_extended.value AS ep_cache_extended,
ep_cache_body.value AS ep_cache_body,
e.id,
e.title,
e.timestamp,
e.comments,
e.exflag,
e.authorid,
e.trackbacks,
e.isdraft,
e.allow_comments,
e.last_modified,
a.realname AS author,
a.username AS loginname,
a.email
FROM
tb_entries AS e
LEFT JOIN tb_authors a
ON e.authorid = a.authorid
LEFT JOIN tb_entrycat ec
ON e.id = ec.entryid
LEFT JOIN tb_category c
ON ec.categoryid = c.categoryid
LEFT OUTER JOIN tb_entryproperties ep_no_frontpage
ON (e.id = ep_no_frontpage.entryid AND ep_no_frontpage.property = 'ep_no_frontpage')
LEFT OUTER JOIN tb_entryproperties ep_cache_extended
ON (e.id = ep_cache_extended.entryid AND ep_cache_extended.property = 'ep_cache_extended')
LEFT OUTER JOIN tb_entryproperties ep_cache_body
ON (e.id = ep_cache_body.entryid AND ep_cache_body.property = 'ep_cache_body')
LEFT OUTER JOIN tb_entryproperties ep_access
ON (e.id = ep_access.entryid AND ep_access.property = 'ep_access')
WHERE isdraft = 'false' AND e.timestamp <= 1452529800 AND (ep_access.property IS NULL OR ep_access.value = 'public') AND (ep_no_frontpage.property IS NULL OR ep_no_frontpage.value != 'true')
GROUP BY e.id
ORDER BY orderkey DESC, last_modified DESC
LIMIT 1;
# Time: 160111 17:27:11
Query_time: 6.040128 Lock_time: 0.000123 Rows_sent: 5 Rows_examined: 31268
SET timestamp=1452529891;
SELECT DISTINCT id,
title,
timestamp,
epm.value AS multilingual_title
FROM tb_entries AS e
LEFT OUTER JOIN tb_entrycat AS ec ON id = ec.entryid LEFT OUTER JOIN tb_category AS c ON ec.categoryid = c.categoryid
LEFT OUTER JOIN tb_entryproperties AS epm
ON (epm.entryid = e.id AND epm.property = 'multilingual_title_de')
WHERE isdraft = 'false' AND timestamp <= 1452529885
ORDER BY timestamp DESC
LIMIT 5;
# Time: 160111 17:31:33
# User@Host: duckhome[duckhome] @ [127.0.0.1]
# Query_time: 5.985227 Lock_time: 0.000093 Rows_sent: 20 Rows_examined: 84846
SET timestamp=1452529893;
SELECT et.tag, count(et.tag) AS total
FROM tb_entrytags AS et
LEFT OUTER JOIN tb_entries AS e
ON et.entryid = e.id
WHERE e.isdraft = 'false' AND e.timestamp <= 1452529887
GROUP BY et.tag
HAVING count(et.tag) >= 2
ORDER BY total DESC LIMIT 20;
# Time: 160111 17:31:35
# User@Host: duckhome[duckhome] @ [127.0.0.1]
# Query_time: 5.749800 Lock_time: 0.000108 Rows_sent: 5 Rows_examined: 31268
SET timestamp=1452529895;
SELECT DISTINCT id,
title,
timestamp,
epm.value AS multilingual_title
FROM tb_entries AS e
LEFT OUTER JOIN tb_entrycat AS ec ON id = ec.entryid LEFT OUTER JOIN tb_category AS c ON ec.categoryid = c.categoryid
LEFT OUTER JOIN tb_entryproperties AS epm
ON (epm.entryid = e.id AND epm.property = 'multilingual_title_de')
WHERE isdraft = 'false' AND timestamp <= 1452529889
ORDER BY timestamp DESC
LIMIT 5;
# User@Host: duckhome[duckhome] @ [127.0.0.1]
# Query_time: 6.023760 Lock_time: 0.000106 Rows_sent: 5 Rows_examined: 31268
SET timestamp=1452529895;
SELECT DISTINCT id,
title,
timestamp,
epm.value AS multilingual_title
FROM tb_entries AS e
LEFT OUTER JOIN tb_entrycat AS ec ON id = ec.entryid LEFT OUTER JOIN tb_category AS c ON ec.categoryid = c.categoryid
LEFT OUTER JOIN tb_entryproperties AS epm
ON (epm.entryid = e.id AND epm.property = 'multilingual_title_de')
WHERE isdraft = 'false' AND timestamp <= 1452529889
ORDER BY timestamp DESC
LIMIT 5;
# Time: 160111 17:31:36
# User@Host: duckhome[duckhome] @ [127.0.0.1]
# Query_time: 6.553538 Lock_time: 0.222695 Rows_sent: 20 Rows_examined: 84846
SET timestamp=1452529896;
SELECT et.tag, count(et.tag) AS total
FROM tb_entrytags AS et
LEFT OUTER JOIN tb_entries AS e
ON et.entryid = e.id
WHERE e.isdraft = 'false' AND e.timestamp <= 1452529890
GROUP BY et.tag
HAVING count(et.tag) >= 2
ORDER BY total DESC LIMIT 20;
# User@Host: duckhome[duckhome] @ [127.0.0.1]
# Query_time: 5.584208 Lock_time: 0.000110 Rows_sent: 20 Rows_examined: 84846
SET timestamp=1452529896;
SELECT et.tag, count(et.tag) AS total
FROM tb_entrytags AS et
LEFT OUTER JOIN tb_entries AS e
ON et.entryid = e.id
WHERE e.isdraft = 'false' AND e.timestamp <= 1452529891
GROUP BY et.tag
HAVING count(et.tag) >= 2
ORDER BY total DESC LIMIT 20;
# Time: 160111 17:31:41
# User@Host: duckhome[duckhome] @ [127.0.0.1]
# Query_time: 5.779132 Lock_time: 0.000105 Rows_sent: 20 Rows_examined: 84846
SET timestamp=1452529901;
SELECT et.tag, count(et.tag) AS total
FROM tb_entrytags AS et
LEFT OUTER JOIN tb_entries AS e
ON et.entryid = e.id
WHERE e.isdraft = 'false' AND e.timestamp <= 1452529895
GROUP BY et.tag
HAVING count(et.tag) >= 2
ORDER BY total DESC LIMIT 20;
# Time: 160111 17:31:46
# User@Host: duckhome[duckhome] @ [127.0.0.1]
# Query_time: 5.342892 Lock_time: 0.000071 Rows_sent: 20 Rows_examined: 84846
SET timestamp=1452529906;
SELECT et.tag, count(et.tag) AS total
FROM tb_entrytags AS et
LEFT OUTER JOIN tb_entries AS e
ON et.entryid = e.id
WHERE e.isdraft = 'false' AND e.timestamp <= 1452529900
GROUP BY et.tag
HAVING count(et.tag) >= 2
ORDER BY total DESC LIMIT 20;
# Time: 160111 17:31:47
# User@Host: duckhome[duckhome] @ [127.0.0.1]
# Query_time: 6.038121 Lock_time: 0.000108 Rows_sent: 5 Rows_examined: 31268
SET timestamp=1452529907;
SELECT DISTINCT id,
title,
timestamp,
epm.value AS multilingual_title
FROM tb_entries AS e
LEFT OUTER JOIN tb_entrycat AS ec ON id = ec.entryid LEFT OUTER JOIN tb_category AS c ON ec.categoryid = c.categoryid
LEFT OUTER JOIN tb_entryproperties AS epm
ON (epm.entryid = e.id AND epm.property = 'multilingual_title_de')
WHERE isdraft = 'false' AND timestamp <= 1452529901
ORDER BY timestamp DESC
LIMIT 5;
# Time: 160111 17:31:48
# User@Host: duckhome[duckhome] @ [127.0.0.1]
# Query_time: 5.609230 Lock_time: 0.000136 Rows_sent: 5 Rows_examined: 31268
SET timestamp=1452529908;
SELECT DISTINCT id,
title,
timestamp,
epm.value AS multilingual_title
FROM tb_entries AS e
LEFT OUTER JOIN tb_entrycat AS ec ON id = ec.entryid LEFT OUTER JOIN tb_category AS c ON ec.categoryid = c.categoryid
LEFT OUTER JOIN tb_entryproperties AS epm
ON (epm.entryid = e.id AND epm.property = 'multilingual_title_de')
WHERE isdraft = 'false' AND timestamp <= 1452529903
ORDER BY timestamp DESC
LIMIT 5;
# Time: 160111 17:31:50
# User@Host: duckhome[duckhome] @ [127.0.0.1]
# Query_time: 5.930440 Lock_time: 0.000137 Rows_sent: 5 Rows_examined: 31268
SET timestamp=1452529910;
SELECT DISTINCT id,
title,
timestamp,
epm.value AS multilingual_title
FROM tb_entries AS e
LEFT OUTER JOIN tb_entrycat AS ec ON id = ec.entryid LEFT OUTER JOIN tb_category AS c ON ec.categoryid = c.categoryid
LEFT OUTER JOIN tb_entryproperties AS epm
ON (epm.entryid = e.id AND epm.property = 'multilingual_title_de')
WHERE isdraft = 'false' AND timestamp <= 1452529904
ORDER BY timestamp DESC
LIMIT 5;
# Time: 160111 17:31:51
# User@Host: duckhome[duckhome] @ [127.0.0.1]
# Query_time: 6.249322 Lock_time: 0.000110 Rows_sent: 5 Rows_examined: 31268
SET timestamp=1452529911;
SELECT DISTINCT id,
title,
timestamp,
epm.value AS multilingual_title
FROM tb_entries AS e
LEFT OUTER JOIN tb_entrycat AS ec ON id = ec.entryid LEFT OUTER JOIN tb_category AS c ON ec.categoryid = c.categoryid
LEFT OUTER JOIN tb_entryproperties AS epm
ON (epm.entryid = e.id AND epm.property = 'multilingual_title_de')
WHERE isdraft = 'false' AND timestamp <= 1452529905
ORDER BY timestamp DESC
LIMIT 5;
# Time: 160111 17:31:52
# User@Host: duckhome[duckhome] @ [127.0.0.1]
# Query_time: 6.438452 Lock_time: 0.000078 Rows_sent: 5 Rows_examined: 31268
SET timestamp=1452529912;
SELECT DISTINCT id,
title,
timestamp,
epm.value AS multilingual_title
FROM tb_entries AS e
LEFT OUTER JOIN tb_entrycat AS ec ON id = ec.entryid LEFT OUTER JOIN tb_category AS c ON ec.categoryid = c.categoryid
LEFT OUTER JOIN tb_entryproperties AS epm
ON (epm.entryid = e.id AND epm.property = 'multilingual_title_de')
WHERE isdraft = 'false' AND timestamp <= 1452529906
ORDER BY timestamp DESC
LIMIT 5;
# Time: 160111 17:31:53
# User@Host: duckhome[duckhome] @ [127.0.0.1]
# Query_time: 5.342757 Lock_time: 0.000091 Rows_sent: 20 Rows_examined: 84846
SET timestamp=1452529913;
SELECT et.tag, count(et.tag) AS total
FROM tb_entrytags AS et
LEFT OUTER JOIN tb_entries AS e
ON et.entryid = e.id
WHERE e.isdraft = 'false' AND e.timestamp <= 1452529907
GROUP BY et.tag
HAVING count(et.tag) >= 2
ORDER BY total DESC LIMIT 20;
# User@Host: duckhome[duckhome] @ [127.0.0.1]
# Query_time: 7.639211 Lock_time: 0.000126 Rows_sent: 5 Rows_examined: 31268
SET timestamp=1452529913;
SELECT DISTINCT id,
title,
timestamp,
epm.value AS multilingual_title
FROM tb_entries AS e
LEFT OUTER JOIN tb_entrycat AS ec ON id = ec.entryid LEFT OUTER JOIN tb_category AS c ON ec.categoryid = c.categoryid
LEFT OUTER JOIN tb_entryproperties AS epm
ON (epm.entryid = e.id AND epm.property = 'multilingual_title_de')
WHERE isdraft = 'false' AND timestamp <= 1452529906
ORDER BY timestamp DESC
LIMIT 5;
# Time: 160111 17:31:55
# User@Host: duckhome[duckhome] @ [127.0.0.1]
# Query_time: 6.529346 Lock_time: 0.000106 Rows_sent: 20 Rows_examined: 84846
SET timestamp=1452529915;
SELECT et.tag, count(et.tag) AS total
FROM tb_entrytags AS et
LEFT OUTER JOIN tb_entries AS e
ON et.entryid = e.id
WHERE e.isdraft = 'false' AND e.timestamp <= 1452529908
GROUP BY et.tag
HAVING count(et.tag) >= 2
ORDER BY total DESC LIMIT 20;
# User@Host: duckhome[duckhome] @ [127.0.0.1]
# Query_time: 5.655709 Lock_time: 0.000115 Rows_sent: 5 Rows_examined: 31268
SET timestamp=1452529915;
SELECT DISTINCT id,
title,
timestamp,
epm.value AS multilingual_title
FROM tb_entries AS e
LEFT OUTER JOIN tb_entrycat AS ec ON id = ec.entryid LEFT OUTER JOIN tb_category AS c ON ec.categoryid = c.categoryid
LEFT OUTER JOIN tb_entryproperties AS epm
ON (epm.entryid = e.id AND epm.property = 'multilingual_title_de')
WHERE isdraft = 'false' AND timestamp <= 1452529909
ORDER BY timestamp DESC
LIMIT 5;
# User@Host: duckhome[duckhome] @ [127.0.0.1]
# Query_time: 5.687785 Lock_time: 0.037317 Rows_sent: 20 Rows_examined: 84846
SET timestamp=1452529915;
SELECT et.tag, count(et.tag) AS total
FROM tb_entrytags AS et
LEFT OUTER JOIN tb_entries AS e
ON et.entryid = e.id
WHERE e.isdraft = 'false' AND e.timestamp <= 1452529910
GROUP BY et.tag
HAVING count(et.tag) >= 2
ORDER BY total DESC LIMIT 20;
# Time: 160111 17:31:57
# User@Host: duckhome[duckhome] @ [127.0.0.1]
# Query_time: 6.328910 Lock_time: 0.000106 Rows_sent: 20 Rows_examined: 84846
SET timestamp=1452529917;
SELECT et.tag, count(et.tag) AS total
FROM tb_entrytags AS et
LEFT OUTER JOIN tb_entries AS e
ON et.entryid = e.id
WHERE e.isdraft = 'false' AND e.timestamp <= 1452529911
GROUP BY et.tag
HAVING count(et.tag) >= 2
ORDER BY total DESC LIMIT 20;
# Time: 160111 17:31:58
# User@Host: duckhome[duckhome] @ [127.0.0.1]
# Query_time: 6.250560 Lock_time: 0.000118 Rows_sent: 5 Rows_examined: 31268
SET timestamp=1452529918;
SELECT DISTINCT id,
title,
timestamp,
epm.value AS multilingual_title
FROM tb_entries AS e
LEFT OUTER JOIN tb_entrycat AS ec ON id = ec.entryid LEFT OUTER JOIN tb_category AS c ON ec.categoryid = c.categoryid
LEFT OUTER JOIN tb_entryproperties AS epm
ON (epm.entryid = e.id AND epm.property = 'multilingual_title_de')
WHERE isdraft = 'false' AND timestamp <= 1452529911
ORDER BY timestamp DESC
LIMIT 5;
# User@Host: duckhome[duckhome] @ [127.0.0.1]
# Query_time: 5.532782 Lock_time: 0.000109 Rows_sent: 20 Rows_examined: 84846
SET timestamp=1452529918;
SELECT et.tag, count(et.tag) AS total
FROM tb_entrytags AS et
LEFT OUTER JOIN tb_entries AS e
ON et.entryid = e.id
WHERE e.isdraft = 'false' AND e.timestamp <= 1452529912
GROUP BY et.tag
HAVING count(et.tag) >= 2
ORDER BY total DESC LIMIT 20;
# Time: 160111 17:32:00
# User@Host: duckhome[duckhome] @ [127.0.0.1]
# Query_time: 6.548475 Lock_time: 0.000094 Rows_sent: 20 Rows_examined: 84846
SET timestamp=1452529920;
SELECT et.tag, count(et.tag) AS total
FROM tb_entrytags AS et
LEFT OUTER JOIN tb_entries AS e
ON et.entryid = e.id
WHERE e.isdraft = 'false' AND e.timestamp <= 1452529913
GROUP BY et.tag
HAVING count(et.tag) >= 2
ORDER BY total DESC LIMIT 20;
# User@Host: duckhome[duckhome] @ [127.0.0.1]
# Query_time: 5.098582 Lock_time: 0.000103 Rows_sent: 20 Rows_examined: 84846
SET timestamp=1452529920;
SELECT et.tag, count(et.tag) AS total
FROM tb_entrytags AS et
LEFT OUTER JOIN tb_entries AS e
ON et.entryid = e.id
WHERE e.isdraft = 'false' AND e.timestamp <= 1452529915
GROUP BY et.tag
HAVING count(et.tag) >= 2
ORDER BY total DESC LIMIT 20;
# Time: 160111 17:32:02
# User@Host: duckhome[duckhome] @ [127.0.0.1]
# Query_time: 5.900111 Lock_time: 0.000085 Rows_sent: 5 Rows_examined: 31268
SET timestamp=1452529922;
SELECT DISTINCT id,
title,
timestamp,
epm.value AS multilingual_title
FROM tb_entries AS e
LEFT OUTER JOIN tb_entrycat AS ec ON id = ec.entryid LEFT OUTER JOIN tb_category AS c ON ec.categoryid = c.categoryid
LEFT OUTER JOIN tb_entryproperties AS epm
ON (epm.entryid = e.id AND epm.property = 'multilingual_title_de')
WHERE isdraft = 'false' AND timestamp <= 1452529916
ORDER BY timestamp DESC
LIMIT 5;
# Time: 160111 17:32:04
# User@Host: duckhome[duckhome] @ [127.0.0.1]
# Query_time: 5.058314 Lock_time: 0.000120 Rows_sent: 5 Rows_examined: 31268
SET timestamp=1452529924;
SELECT DISTINCT id,
title,
timestamp,
epm.value AS multilingual_title
FROM tb_entries AS e
LEFT OUTER JOIN tb_entrycat AS ec ON id = ec.entryid LEFT OUTER JOIN tb_category AS c ON ec.categoryid = c.categoryid
LEFT OUTER JOIN tb_entryproperties AS epm
ON (epm.entryid = e.id AND epm.property = 'multilingual_title_de')
WHERE isdraft = 'false' AND timestamp <= 1452529919
ORDER BY timestamp DESC
LIMIT 5;
# Time: 160111 17:32:10
# User@Host: duckhome[duckhome] @ [127.0.0.1]
# Query_time: 5.377497 Lock_time: 0.000136 Rows_sent: 5 Rows_examined: 31268
SET timestamp=1452529930;
SELECT DISTINCT id,
title,
timestamp,
epm.value AS multilingual_title
FROM tb_entries AS e
LEFT OUTER JOIN tb_entrycat AS ec ON id = ec.entryid LEFT OUTER JOIN tb_category AS c ON ec.categoryid = c.categoryid
LEFT OUTER JOIN tb_entryproperties AS epm
ON (epm.entryid = e.id AND epm.property = 'multilingual_title_de')
WHERE isdraft = 'false' AND timestamp <= 1452529925
ORDER BY timestamp DESC
LIMIT 5;
# Time: 160111 17:32:13
# User@Host: duckhome[duckhome] @ [127.0.0.1]
# Query_time: 7.110090 Lock_time: 0.000102 Rows_sent: 20 Rows_examined: 84846
SET timestamp=1452529933;
SELECT et.tag, count(et.tag) AS total
FROM tb_entrytags AS et
LEFT OUTER JOIN tb_entries AS e
ON et.entryid = e.id
WHERE e.isdraft = 'false' AND e.timestamp <= 1452529926
GROUP BY et.tag
HAVING count(et.tag) >= 2
ORDER BY total DESC LIMIT 20;
# Time: 160111 17:32:17
# User@Host: duckhome[duckhome] @ [127.0.0.1]
# Query_time: 6.303260 Lock_time: 0.000119 Rows_sent: 5 Rows_examined: 31268
SET timestamp=1452529937;
SELECT DISTINCT id,
title,
timestamp,
epm.value AS multilingual_title
FROM tb_entries AS e
LEFT OUTER JOIN tb_entrycat AS ec ON id = ec.entryid LEFT OUTER JOIN tb_category AS c ON ec.categoryid = c.categoryid
LEFT OUTER JOIN tb_entryproperties AS epm
ON (epm.entryid = e.id AND epm.property = 'multilingual_title_de')
WHERE isdraft = 'false' AND timestamp <= 1452529930
ORDER BY timestamp DESC
LIMIT 5;
# Time: 160111 17:32:18
# User@Host: duckhome[duckhome] @ [127.0.0.1]
# Query_time: 6.421579 Lock_time: 0.000088 Rows_sent: 5 Rows_examined: 31268
SET timestamp=1452529938;
SELECT DISTINCT id,
title,
timestamp,
epm.value AS multilingual_title
FROM tb_entries AS e
LEFT OUTER JOIN tb_entrycat AS ec ON id = ec.entryid LEFT OUTER JOIN tb_category AS c ON ec.categoryid = c.categoryid
LEFT OUTER JOIN tb_entryproperties AS epm
ON (epm.entryid = e.id AND epm.property = 'multilingual_title_de')
WHERE isdraft = 'false' AND timestamp <= 1452529931
ORDER BY timestamp DESC
LIMIT 5;
# User@Host: duckhome[duckhome] @ [127.0.0.1]
# Query_time: 7.606196 Lock_time: 0.000083 Rows_sent: 20 Rows_examined: 84846
SET timestamp=1452529938;
SELECT et.tag, count(et.tag) AS total
FROM tb_entrytags AS et
LEFT OUTER JOIN tb_entries AS e
ON et.entryid = e.id
WHERE e.isdraft = 'false' AND e.timestamp <= 1452529930
GROUP BY et.tag
HAVING count(et.tag) >= 2
ORDER BY total DESC LIMIT 20;
# Time: 160111 17:32:21
# User@Host: duckhome[duckhome] @ [127.0.0.1]
# Query_time: 7.978071 Lock_time: 0.000174 Rows_sent: 25 Rows_examined: 21691
SET timestamp=1452529941;
SELECT
ep_sticky.value AS orderkey,
e.id,
e.title,
e.timestamp,
e.comments,
e.exflag,
e.authorid,
e.trackbacks,
e.isdraft,
e.allow_comments,
e.last_modified,
a.realname AS author,
a.username AS loginname,
a.email
, e.body, e.extended
FROM
tb_entries AS e
LEFT JOIN tb_authors a
ON e.authorid = a.authorid
LEFT JOIN tb_entrycat ec
ON e.id = ec.entryid
LEFT JOIN tb_category c
ON ec.categoryid = c.categoryid
LEFT OUTER JOIN tb_entryproperties ep_access
ON (e.id = ep_access.entryid AND ep_access.property = 'ep_access')
LEFT JOIN tb_entryproperties ep_sticky
ON (e.id = ep_sticky.entryid AND ep_sticky.property = 'ep_is_sticky')
WHERE isdraft = 'false' AND (e.authorid = 1) AND e.timestamp <= 1452530100 AND (ep_access.property IS NULL OR ep_access.value = 'public')
GROUP BY e.id
ORDER BY orderkey DESC, timestamp DESC
LIMIT 125, 25;
# Time: 160111 17:32:22
# User@Host: duckhome[duckhome] @ [127.0.0.1]
# Query_time: 5.066724 Lock_time: 0.000092 Rows_sent: 20 Rows_examined: 84846
SET timestamp=1452529942;
SELECT et.tag, count(et.tag) AS total
FROM tb_entrytags AS et
LEFT OUTER JOIN tb_entries AS e
ON et.entryid = e.id
WHERE e.isdraft = 'false' AND e.timestamp <= 1452529937
GROUP BY et.tag
HAVING count(et.tag) >= 2
ORDER BY total DESC LIMIT 20;
# Time: 160111 17:32:23
# User@Host: duckhome[duckhome] @ [127.0.0.1]
# Query_time: 5.161230 Lock_time: 0.000100 Rows_sent: 20 Rows_examined: 84846
SET timestamp=1452529943;
SELECT et.tag, count(et.tag) AS total
FROM tb_entrytags AS et
LEFT OUTER JOIN tb_entries AS e
ON et.entryid = e.id
WHERE e.isdraft = 'false' AND e.timestamp <= 1452529938
GROUP BY et.tag
HAVING count(et.tag) >= 2
ORDER BY total DESC LIMIT 20;
# User@Host: duckhome[duckhome] @ [127.0.0.1]
# Query_time: 15.087449 Lock_time: 0.000075 Rows_sent: 12373 Rows_examined: 74437
use duckhome_db2;
SET timestamp=1452529943;
select distinct ta.`action`, ta.`lastModif`, ta.`user`, ta.`ip`, ta.`object`, thf.`comment`, thf.`version`, thf.`page_id` from `tiki_actionlog` ta
inner join (select th.`version`, th.`comment`, th.`pageName`, th.`lastModif`, tp.`page_id` from `tiki_history` as th LEFT OUTER JOIN `tiki_pages` tp ON tp.`pageName` = th.`pageName` AND tp.`version` = th.`version`) as thf on ta.`object`=thf.`pageName` and ta.`lastModif`=thf.`lastModif` and ta.`objectType`='wiki page' where true order by ta.`lastModif` asc;
# Time: 160111 17:32:24
# User@Host: duckhome[duckhome] @ [127.0.0.1]
# Query_time: 6.578128 Lock_time: 0.000110 Rows_sent: 5 Rows_examined: 31268
use duckhome_db1;
SET timestamp=1452529944;
SELECT DISTINCT id,
title,
timestamp,
epm.value AS multilingual_title
FROM tb_entries AS e
LEFT OUTER JOIN tb_entrycat AS ec ON id = ec.entryid LEFT OUTER JOIN tb_category AS c ON ec.categoryid = c.categoryid
LEFT OUTER JOIN tb_entryproperties AS epm
ON (epm.entryid = e.id AND epm.property = 'multilingual_title_de')
WHERE isdraft = 'false' AND timestamp <= 1452529937
ORDER BY timestamp DESC
LIMIT 5;
# Time: 160111 17:32:28
# User@Host: duckhome[duckhome] @ [127.0.0.1]
# Query_time: 5.298866 Lock_time: 0.000096 Rows_sent: 20 Rows_examined: 84846
SET timestamp=1452529948;
SELECT et.tag, count(et.tag) AS total
FROM tb_entrytags AS et
LEFT OUTER JOIN tb_entries AS e
ON et.entryid = e.id
WHERE e.isdraft = 'false' AND e.timestamp <= 1452529943
GROUP BY et.tag
HAVING count(et.tag) >= 2
ORDER BY total DESC LIMIT 20;
# Time: 160111 17:32:29
# User@Host: duckhome[duckhome] @ [127.0.0.1]
# Query_time: 5.579969 Lock_time: 0.000111 Rows_sent: 20 Rows_examined: 84846
SET timestamp=1452529949;
SELECT et.tag, count(et.tag) AS total
FROM tb_entrytags AS et
LEFT OUTER JOIN tb_entries AS e
ON et.entryid = e.id
WHERE e.isdraft = 'false' AND e.timestamp <= 1452529944
GROUP BY et.tag
HAVING count(et.tag) >= 2
ORDER BY total DESC LIMIT 20;
# Time: 160111 17:32:35
# User@Host: duckhome[duckhome] @ [127.0.0.1]
# Query_time: 5.715054 Lock_time: 0.000073 Rows_sent: 5 Rows_examined: 31268
SET timestamp=1452529955;
SELECT DISTINCT id,
title,
timestamp,
epm.value AS multilingual_title
FROM tb_entries AS e
LEFT OUTER JOIN tb_entrycat AS ec ON id = ec.entryid LEFT OUTER JOIN tb_category AS c ON ec.categoryid = c.categoryid
LEFT OUTER JOIN tb_entryproperties AS epm
ON (epm.entryid = e.id AND epm.property = 'multilingual_title_de')
WHERE isdraft = 'false' AND timestamp <= 1452529950
ORDER BY timestamp DESC
LIMIT 5;
# Time: 160111 17:32:36
# User@Host: duckhome[duckhome] @ [127.0.0.1]
# Query_time: 6.117969 Lock_time: 0.000102 Rows_sent: 5 Rows_examined: 31268
SET timestamp=1452529956;
SELECT DISTINCT id,
title,
timestamp,
epm.value AS multilingual_title
FROM tb_entries AS e
LEFT OUTER JOIN tb_entrycat AS ec ON id = ec.entryid LEFT OUTER JOIN tb_category AS c ON ec.categoryid = c.categoryid
LEFT OUTER JOIN tb_entryproperties AS epm
ON (epm.entryid = e.id AND epm.property = 'multilingual_title_de')
WHERE isdraft = 'false' AND timestamp <= 1452529950
ORDER BY timestamp DESC
LIMIT 5;
# User@Host: duckhome[duckhome] @ [127.0.0.1]
# Query_time: 6.227077 Lock_time: 0.000098 Rows_sent: 20 Rows_examined: 84846
SET timestamp=1452529956;
SELECT et.tag, count(et.tag) AS total
FROM tb_entrytags AS et
LEFT OUTER JOIN tb_entries AS e
ON et.entryid = e.id
WHERE e.isdraft = 'false' AND e.timestamp <= 1452529950
GROUP BY et.tag
HAVING count(et.tag) >= 2
ORDER BY total DESC LIMIT 20;
# Time: 160111 17:32:38
# User@Host: duckhome[duckhome] @ [127.0.0.1]
# Query_time: 6.449672 Lock_time: 0.000110 Rows_sent: 5 Rows_examined: 31268
SET timestamp=1452529958;
SELECT DISTINCT id,
title,
timestamp,
epm.value AS multilingual_title
FROM tb_entries AS e
LEFT OUTER JOIN tb_entrycat AS ec ON id = ec.entryid LEFT OUTER JOIN tb_category AS c ON ec.categoryid = c.categoryid
LEFT OUTER JOIN tb_entryproperties AS epm
ON (epm.entryid = e.id AND epm.property = 'multilingual_title_de')
WHERE isdraft = 'false' AND timestamp <= 1452529951
ORDER BY timestamp DESC
LIMIT 5;
# Time: 160111 17:32:42
# User@Host: duckhome[duckhome] @ [127.0.0.1]
# Query_time: 5.924960 Lock_time: 0.000610 Rows_sent: 20 Rows_examined: 84846
SET timestamp=1452529962;
SELECT et.tag, count(et.tag) AS total
FROM tb_entrytags AS et
LEFT OUTER JOIN tb_entries AS e
ON et.entryid = e.id
WHERE e.isdraft = 'false' AND e.timestamp <= 1452529956
GROUP BY et.tag
HAVING count(et.tag) >= 2
ORDER BY total DESC LIMIT 20;
# User@Host: duckhome[duckhome] @ [127.0.0.1]
# Query_time: 7.356291 Lock_time: 0.000135 Rows_sent: 25 Rows_examined: 25541
SET timestamp=1452529962;
SELECT
ep_sticky.value AS orderkey,
e.id,
e.title,
e.timestamp,
e.comments,
e.exflag,
e.authorid,
e.trackbacks,
e.isdraft,
e.allow_comments,
e.last_modified,
a.realname AS author,
a.username AS loginname,
a.email
, e.body, e.extended
FROM
tb_entries AS e
LEFT JOIN tb_authors a
ON e.authorid = a.authorid
LEFT JOIN tb_entrycat ec
ON e.id = ec.entryid
LEFT JOIN tb_category c
ON ec.categoryid = c.categoryid
LEFT OUTER JOIN tb_entryproperties ep_access
ON (e.id = ep_access.entryid AND ep_access.property = 'ep_access')
LEFT JOIN tb_entryproperties ep_sticky
ON (e.id = ep_sticky.entryid AND ep_sticky.property = 'ep_is_sticky')
WHERE isdraft = 'false' AND (e.authorid = 1) AND e.timestamp <= 1452530100 AND (ep_access.property IS NULL OR ep_access.value = 'public')
GROUP BY e.id
ORDER BY orderkey DESC, timestamp DESC
LIMIT 3975, 25;
# Time: 160111 17:32:43
# User@Host: duckhome[duckhome] @ [127.0.0.1]
# Query_time: 5.417991 Lock_time: 0.000110 Rows_sent: 20 Rows_examined: 84846
SET timestamp=1452529963;
SELECT et.tag, count(et.tag) AS total
FROM tb_entrytags AS et
LEFT OUTER JOIN tb_entries AS e
ON et.entryid = e.id
WHERE e.isdraft = 'false' AND e.timestamp <= 1452529958
GROUP BY et.tag
HAVING count(et.tag) >= 2
ORDER BY total DESC LIMIT 20;
# User@Host: duckhome[duckhome] @ [127.0.0.1]
# Query_time: 5.841790 Lock_time: 0.000112 Rows_sent: 5 Rows_examined: 31268
SET timestamp=1452529963;
SELECT DISTINCT id,
title,
timestamp,
epm.value AS multilingual_title
FROM tb_entries AS e
LEFT OUTER JOIN tb_entrycat AS ec ON id = ec.entryid LEFT OUTER JOIN tb_category AS c ON ec.categoryid = c.categoryid
LEFT OUTER JOIN tb_entryproperties AS epm
ON (epm.entryid = e.id AND epm.property = 'multilingual_title_de')
WHERE isdraft = 'false' AND timestamp <= 1452529958
ORDER BY timestamp DESC
LIMIT 5;
# Time: 160111 17:32:47
# User@Host: duckhome[duckhome] @ [127.0.0.1]
# Query_time: 6.048079 Lock_time: 0.000112 Rows_sent: 5 Rows_examined: 31268
SET timestamp=1452529967;
SELECT DISTINCT id,
title,
timestamp,
epm.value AS multilingual_title
FROM tb_entries AS e
LEFT OUTER JOIN tb_entrycat AS ec ON id = ec.entryid LEFT OUTER JOIN tb_category AS c ON ec.categoryid = c.categoryid
LEFT OUTER JOIN tb_entryproperties AS epm
ON (epm.entryid = e.id AND epm.property = 'multilingual_title_de')
WHERE isdraft = 'false' AND timestamp <= 1452529961
ORDER BY timestamp DESC
LIMIT 5;
# Time: 160111 17:32:49
# User@Host: duckhome[duckhome] @ [127.0.0.1]
# Query_time: 5.027549 Lock_time: 0.000072 Rows_sent: 20 Rows_examined: 84846
SET timestamp=1452529969;
SELECT et.tag, count(et.tag) AS total
FROM tb_entrytags AS et
LEFT OUTER JOIN tb_entries AS e
ON et.entryid = e.id
WHERE e.isdraft = 'false' AND e.timestamp <= 1452529964
GROUP BY et.tag
HAVING count(et.tag) >= 2
ORDER BY total DESC LIMIT 20;
# Time: 160111 17:32:51
# User@Host: duckhome[duckhome] @ [127.0.0.1]
# Query_time: 6.411341 Lock_time: 0.000112 Rows_sent: 5 Rows_examined: 31268
SET timestamp=1452529971;
SELECT DISTINCT id,
title,
timestamp,
epm.value AS multilingual_title
FROM tb_entries AS e
LEFT OUTER JOIN tb_entrycat AS ec ON id = ec.entryid LEFT OUTER JOIN tb_category AS c ON ec.categoryid = c.categoryid
LEFT OUTER JOIN tb_entryproperties AS epm
ON (epm.entryid = e.id AND epm.property = 'multilingual_title_de')
WHERE isdraft = 'false' AND timestamp <= 1452529964
ORDER BY timestamp DESC
LIMIT 5;
# Time: 160111 17:32:53
# User@Host: duckhome[duckhome] @ [127.0.0.1]
# Query_time: 5.426847 Lock_time: 0.000101 Rows_sent: 20 Rows_examined: 84846
SET timestamp=1452529973;
SELECT et.tag, count(et.tag) AS total
FROM tb_entrytags AS et
LEFT OUTER JOIN tb_entries AS e
ON et.entryid = e.id
WHERE e.isdraft = 'false' AND e.timestamp <= 1452529967
GROUP BY et.tag
HAVING count(et.tag) >= 2
ORDER BY total DESC LIMIT 20;
# User@Host: duckhome[duckhome] @ [127.0.0.1]
# Query_time: 8.709759 Lock_time: 0.000143 Rows_sent: 25 Rows_examined: 21591
SET timestamp=1452529973;
SELECT
ep_sticky.value AS orderkey,
e.id,
e.title,
e.timestamp,
e.comments,
e.exflag,
e.authorid,
e.trackbacks,
e.isdraft,
e.allow_comments,
e.last_modified,
a.realname AS author,
a.username AS loginname,
a.email
, e.body, e.extended
FROM
tb_entries AS e
LEFT JOIN tb_authors a
ON e.authorid = a.authorid
LEFT JOIN tb_entrycat ec
ON e.id = ec.entryid
LEFT JOIN tb_category c
ON ec.categoryid = c.categoryid
LEFT OUTER JOIN tb_entryproperties ep_access
ON (e.id = ep_access.entryid AND ep_access.property = 'ep_access')
LEFT JOIN tb_entryproperties ep_sticky
ON (e.id = ep_sticky.entryid AND ep_sticky.property = 'ep_is_sticky')
WHERE isdraft = 'false' AND (e.authorid = 1) AND e.timestamp <= 1452530100 AND (ep_access.property IS NULL OR ep_access.value = 'public')
GROUP BY e.id
ORDER BY orderkey DESC, timestamp DESC
LIMIT 25, 25;
# Time: 160111 17:32:54
# User@Host: duckhome[duckhome] @ [127.0.0.1]
# Query_time: 5.023299 Lock_time: 0.000142 Rows_sent: 5 Rows_examined: 31268
SET timestamp=1452529974;
SELECT DISTINCT id,
title,
timestamp,
epm.value AS multilingual_title
FROM tb_entries AS e
LEFT OUTER JOIN tb_entrycat AS ec ON id = ec.entryid LEFT OUTER JOIN tb_category AS c ON ec.categoryid = c.categoryid
LEFT OUTER JOIN tb_entryproperties AS epm
ON (epm.entryid = e.id AND epm.property = 'multilingual_title_de')
WHERE isdraft = 'false' AND timestamp <= 1452529969
ORDER BY timestamp DESC
LIMIT 5;
# Time: 160111 17:32:59
# User@Host: duckhome[duckhome] @ [127.0.0.1]
# Query_time: 6.128092 Lock_time: 0.000116 Rows_sent: 5 Rows_examined: 31268
SET timestamp=1452529979;
SELECT DISTINCT id,
title,
timestamp,
epm.value AS multilingual_title
FROM tb_entries AS e
LEFT OUTER JOIN tb_entrycat AS ec ON id = ec.entryid LEFT OUTER JOIN tb_category AS c ON ec.categoryid = c.categoryid
LEFT OUTER JOIN tb_entryproperties AS epm
ON (epm.entryid = e.id AND epm.property = 'multilingual_title_de')
WHERE isdraft = 'false' AND timestamp <= 1452529973
ORDER BY timestamp DESC
LIMIT 5;
# User@Host: duckhome[duckhome] @ [127.0.0.1]
# Query_time: 5.357933 Lock_time: 0.000112 Rows_sent: 5 Rows_examined: 31268
SET timestamp=1452529979;
SELECT DISTINCT id,
title,
timestamp,
epm.value AS multilingual_title
FROM tb_entries AS e
LEFT OUTER JOIN tb_entrycat AS ec ON id = ec.entryid LEFT OUTER JOIN tb_category AS c ON ec.categoryid = c.categoryid
LEFT OUTER JOIN tb_entryproperties AS epm
ON (epm.entryid = e.id AND epm.property = 'multilingual_title_de')
WHERE isdraft = 'false' AND timestamp <= 1452529974
ORDER BY timestamp DESC
LIMIT 5;
# Time: 160111 17:33:00
# User@Host: duckhome[duckhome] @ [127.0.0.1]
# Query_time: 6.197549 Lock_time: 0.000107 Rows_sent: 5 Rows_examined: 31268
SET timestamp=1452529980;
SELECT DISTINCT id,
title,
timestamp,
epm.value AS multilingual_title
FROM tb_entries AS e
LEFT OUTER JOIN tb_entrycat AS ec ON id = ec.entryid LEFT OUTER JOIN tb_category AS c ON ec.categoryid = c.categoryid
LEFT OUTER JOIN tb_entryproperties AS epm
ON (epm.entryid = e.id AND epm.property = 'multilingual_title_de')
WHERE isdraft = 'false' AND timestamp <= 1452529974
ORDER BY timestamp DESC
LIMIT 5;
# Time: 160111 17:33:02
# User@Host: duckhome[duckhome] @ [127.0.0.1]
# Query_time: 5.037850 Lock_time: 0.000127 Rows_sent: 5 Rows_examined: 31268
SET timestamp=1452529982;
SELECT DISTINCT id,
title,
timestamp,
epm.value AS multilingual_title
FROM tb_entries AS e
LEFT OUTER JOIN tb_entrycat AS ec ON id = ec.entryid LEFT OUTER JOIN tb_category AS c ON ec.categoryid = c.categoryid
LEFT OUTER JOIN tb_entryproperties AS epm
ON (epm.entryid = e.id AND epm.property = 'multilingual_title_de')
WHERE isdraft = 'false' AND timestamp <= 1452529977
ORDER BY timestamp DESC
LIMIT 5;
# Time: 160111 17:33:03
# User@Host: duckhome[duckhome] @ [127.0.0.1]
# Query_time: 5.135741 Lock_time: 0.000115 Rows_sent: 5 Rows_examined: 31268
SET timestamp=1452529983;
SELECT DISTINCT id,
title,
timestamp,
epm.value AS multilingual_title
FROM tb_entries AS e
LEFT OUTER JOIN tb_entrycat AS ec ON id = ec.entryid LEFT OUTER JOIN tb_category AS c ON ec.categoryid = c.categoryid
LEFT OUTER JOIN tb_entryproperties AS epm
ON (epm.entryid = e.id AND epm.property = 'multilingual_title_de')
WHERE isdraft = 'false' AND timestamp <= 1452529978
ORDER BY timestamp DESC
LIMIT 5;
# Time: 160111 17:33:17
# User@Host: duckhome[duckhome] @ [127.0.0.1]
# Query_time: 13.262791 Lock_time: 0.000134 Rows_sent: 12373 Rows_examined: 74437
use duckhome_db2;
SET timestamp=1452529997;
select distinct ta.`action`, ta.`lastModif`, ta.`user`, ta.`ip`, ta.`object`, thf.`comment`, thf.`version`, thf.`page_id` from `tiki_actionlog` ta
inner join (select th.`version`, th.`comment`, th.`pageName`, th.`lastModif`, tp.`page_id` from `tiki_history` as th LEFT OUTER JOIN `tiki_pages` tp ON tp.`pageName` = th.`pageName` AND tp.`version` = th.`version`) as thf on ta.`object`=thf.`pageName` and ta.`lastModif`=thf.`lastModif` and ta.`objectType`='wiki page' where true order by ta.`user` desc;
# Time: 160111 17:33:18
# User@Host: duckhome[duckhome] @ [127.0.0.1]
# Query_time: 6.244533 Lock_time: 0.000097 Rows_sent: 20 Rows_examined: 84846
use duckhome_db1;
SET timestamp=1452529998;
SELECT et.tag, count(et.tag) AS total
FROM tb_entrytags AS et
LEFT OUTER JOIN tb_entries AS e
ON et.entryid = e.id
WHERE e.isdraft = 'false' AND e.timestamp <= 1452529992
GROUP BY et.tag
HAVING count(et.tag) >= 2
ORDER BY total DESC LIMIT 20;
# Time: 160111 17:33:19
# User@Host: duckhome[duckhome] @ [127.0.0.1]
# Query_time: 6.942869 Lock_time: 0.000086 Rows_sent: 20 Rows_examined: 84846
SET timestamp=1452529999;
SELECT et.tag, count(et.tag) AS total
FROM tb_entrytags AS et
LEFT OUTER JOIN tb_entries AS e
ON et.entryid = e.id
WHERE e.isdraft = 'false' AND e.timestamp <= 1452529992
GROUP BY et.tag
HAVING count(et.tag) >= 2
ORDER BY total DESC LIMIT 20;
# User@Host: duckhome[duckhome] @ [127.0.0.1]
# Query_time: 7.767833 Lock_time: 0.000178 Rows_sent: 25 Rows_examined: 21966
SET timestamp=1452529999;
SELECT
ep_sticky.value AS orderkey,
e.id,
e.title,
e.timestamp,
e.comments,
e.exflag,
e.authorid,
e.trackbacks,
e.isdraft,
e.allow_comments,
e.last_modified,
a.realname AS author,
a.username AS loginname,
a.email
, e.body, e.extended
FROM
tb_entries AS e
LEFT JOIN tb_authors a
ON e.authorid = a.authorid
LEFT JOIN tb_entrycat ec
ON e.id = ec.entryid
LEFT JOIN tb_category c
ON ec.categoryid = c.categoryid
LEFT OUTER JOIN tb_entryproperties ep_access
ON (e.id = ep_access.entryid AND ep_access.property = 'ep_access')
LEFT JOIN tb_entryproperties ep_sticky
ON (e.id = ep_sticky.entryid AND ep_sticky.property = 'ep_is_sticky')
WHERE isdraft = 'false' AND (e.authorid = 1) AND e.timestamp <= 1452530100 AND (ep_access.property IS NULL OR ep_access.value = 'public')
GROUP BY e.id
ORDER BY orderkey DESC, timestamp DESC
LIMIT 400, 25;
# Time: 160111 17:33:20
# User@Host: duckhome[duckhome] @ [127.0.0.1]
# Query_time: 6.021639 Lock_time: 0.000104 Rows_sent: 5 Rows_examined: 31268
SET timestamp=1452530000;
SELECT DISTINCT id,
title,
timestamp,
epm.value AS multilingual_title
FROM tb_entries AS e
LEFT OUTER JOIN tb_entrycat AS ec ON id = ec.entryid LEFT OUTER JOIN tb_category AS c ON ec.categoryid = c.categoryid
LEFT OUTER JOIN tb_entryproperties AS epm
ON (epm.entryid = e.id AND epm.property = 'multilingual_title_de')
WHERE isdraft = 'false' AND timestamp <= 1452529994
ORDER BY timestamp DESC
LIMIT 5;
# Time: 160111 17:33:22
# User@Host: duckhome[duckhome] @ [127.0.0.1]
# Query_time: 6.841931 Lock_time: 0.000129 Rows_sent: 5 Rows_examined: 31268
SET timestamp=1452530002;
SELECT DISTINCT id,
title,
timestamp,
epm.value AS multilingual_title
FROM tb_entries AS e
LEFT OUTER JOIN tb_entrycat AS ec ON id = ec.entryid LEFT OUTER JOIN tb_category AS c ON ec.categoryid = c.categoryid
LEFT OUTER JOIN tb_entryproperties AS epm
ON (epm.entryid = e.id AND epm.property = 'multilingual_title_de')
WHERE isdraft = 'false' AND timestamp <= 1452529995
ORDER BY timestamp DESC
LIMIT 5;
# Time: 160111 17:33:23
# User@Host: duckhome[duckhome] @ [127.0.0.1]
# Query_time: 8.053549 Lock_time: 0.000168 Rows_sent: 25 Rows_examined: 21566
SET timestamp=1452530003;
SELECT
ep_sticky.value AS orderkey,
e.id,
e.title,
e.timestamp,
e.comments,
e.exflag,
e.authorid,
e.trackbacks,
e.isdraft,
e.allow_comments,
e.last_modified,
a.realname AS author,
a.username AS loginname,
a.email
, e.body, e.extended
FROM
tb_entries AS e
LEFT JOIN tb_authors a
ON e.authorid = a.authorid
LEFT JOIN tb_entrycat ec
ON e.id = ec.entryid
LEFT JOIN tb_category c
ON ec.categoryid = c.categoryid
LEFT OUTER JOIN tb_entryproperties ep_access
ON (e.id = ep_access.entryid AND ep_access.property = 'ep_access')
LEFT JOIN tb_entryproperties ep_sticky
ON (e.id = ep_sticky.entryid AND ep_sticky.property = 'ep_is_sticky')
WHERE isdraft = 'false' AND (e.authorid = 1) AND e.timestamp <= 1452530100 AND (ep_access.property IS NULL OR ep_access.value = 'public')
GROUP BY e.id
ORDER BY orderkey DESC, timestamp DESC
LIMIT 25;
# Time: 160111 17:33:26
# User@Host: duckhome[duckhome] @ [127.0.0.1]
# Query_time: 6.206794 Lock_time: 0.000090 Rows_sent: 20 Rows_examined: 84846
SET timestamp=1452530006;
SELECT et.tag, count(et.tag) AS total
FROM tb_entrytags AS et
LEFT OUTER JOIN tb_entries AS e
ON et.entryid = e.id
WHERE e.isdraft = 'false' AND e.timestamp <= 1452530000
GROUP BY et.tag
HAVING count(et.tag) >= 2
ORDER BY total DESC LIMIT 20;
# Time: 160111 17:33:28