2011-03-14 04:50:33 |
Robert Collins |
description |
8 SELECT TranslationMessage.comment, TranslationMessage.date_created, TranslationMessage.date_revie ... gstr3, -$INT), COALESCE(msgstr4, -$INT), COALESCE(msgstr5, -$INT), date_created DESC ) LIMIT $INT:
GET: 8 Robots: 0 Local: 8
5 https://translations.launchpad.net/ubuntu/natty/+source/firefox/+pots/firefox/bs/+translate (POFile:+translate)
OOPS-1898C2088, OOPS-1898D1863, OOPS-1898G1843, OOPS-1898J1463, OOPS-1898L1817
2 https://translations.launchpad.net/ubuntu/natty/+source/packagekit/+pots/packagekit/bs/+translate (POFile:+translate)
OOPS-1898D776, OOPS-1898M759
1 https://translations.launchpad.net/ubuntu/maverick/+source/vorbis-tools/+pots/vorbis-tools/fr/+translate (POFile:+translate)
OOPS-1898H228 |
8 SELECT TranslationMessage.comment, TranslationMessage.date_created, TranslationMessage.date_revie ... gstr3, -$INT), COALESCE(msgstr4, -$INT), COALESCE(msgstr5, -$INT), date_created DESC ) LIMIT $INT:
GET: 8 Robots: 0 Local: 8
5 https://translations.launchpad.net/ubuntu/natty/+source/firefox/+pots/firefox/bs/+translate (POFile:+translate)
OOPS-1898C2088, OOPS-1898D1863, OOPS-1898G1843, OOPS-1898J1463, OOPS-1898L1817
2 https://translations.launchpad.net/ubuntu/natty/+source/packagekit/+pots/packagekit/bs/+translate (POFile:+translate)
OOPS-1898D776, OOPS-1898M759
1 https://translations.launchpad.net/ubuntu/maverick/+source/vorbis-tools/+pots/vorbis-tools/fr/+translate (POFile:+translate)
OOPS-1898H228
from the H228 oops:
Branch: launchpad-rev-12568
Revno: 12568
SQL time: 11916 ms
Non-sql time: 1291 ms
Total time: 13207 ms
Statement Count: 264
10 6 10902 1817 9085 SQL-launchpad-main-master
SELECT TranslationMessage.COMMENT, TranslationMessage.date_created,
TranslationMessage.date_reviewed,
TranslationMessage.id,
TranslationMessage.is_current_ubuntu,
TranslationMessage.is_current_upstream,
TranslationMessage.LANGUAGE, TranslationMessage.msgstr0,
TranslationMessage.msgstr1,
TranslationMessage.msgstr2,
TranslationMessage.msgstr3,
TranslationMessage.msgstr4,
TranslationMessage.msgstr5,
TranslationMessage.origin,
TranslationMessage.potemplate,
TranslationMessage.potmsgset,
TranslationMessage.reviewer,
TranslationMessage.submitter,
TranslationMessage.validation_status,
TranslationMessage.was_obsolete_in_last_import
FROM TranslationMessage
WHERE TranslationMessage.id IN
(SELECT DISTINCT ON (COALESCE(msgstr0, -$INT), COALESCE(msgstr1, -$INT), COALESCE(msgstr2, -$INT), COALESCE(msgstr3, -$INT), COALESCE(msgstr4, -$INT), COALESCE(msgstr5, -$INT)) TranslationMessage.id
FROM TranslationMessage
WHERE (TranslationMessage.LANGUAGE IN ($INT))
AND TranslationMessage.potmsgset <> $INT
AND potmsgset IN
(SELECT POTMsgSet.id
FROM POTMsgSet
JOIN TranslationTemplateItem ON TranslationTemplateItem.potmsgset = POTMsgSet.id
JOIN SuggestivePOTemplate ON TranslationTemplateItem.potemplate = SuggestivePOTemplate.potemplate
WHERE msgid_singular = $INT)
ORDER BY COALESCE(msgstr0, -$INT), COALESCE(msgstr1, -$INT), COALESCE(msgstr2, -$INT), COALESCE(msgstr3, -$INT), COALESCE(msgstr4, -$INT), COALESCE(msgstr5, -$INT), date_created DESC)LIMIT $INT |
|