Zapytanie do 7 tabel na innoDB wykonuje się 20 sekund (!), Co robię nie tak? Opcje

[L_Devil]

Witam. Mam dwie tabele:

Kod

common_parametrs:
+-----+----------+-------------+
| Id  |   name   |    value    |
+-----+----------+-------------+

Kod

user_posters:
+-----+----------+---------
| Id  |   login  |   ...  
+-----+----------+---------

Obie tabele jako InnoDB

[SQL] pobierz, plaintext 
SELECT
p.id AS id,
c1.value AS name,
p.login AS login,
c2.value AS version,
c3.value AS pragma,
c4.value AS DATA,
c5.value AS author,
c6.value AS copyrights
FROM common_parametrs AS c1,
users_posters AS p,
common_parametrs AS c2,
common_parametrs AS c3,
common_parametrs AS c4,
common_parametrs AS c5,
common_parametrs AS c6
WHERE c1.name='name' AND c1.owner=p.id AND c2.name='version' AND c2.owner=p.id AND c3.name='pragma' AND c3.owner=c2.owner AND c4.name='data' AND c4.owner=c3.owner AND c5.name='author' AND c5.owner=c4.owner AND c6.name='copyrights' AND c6.owner=c5.owner
ORDER BY c1.value ASC;
[SQL] pobierz, plaintext 

Wykonanie tego zapytania trwa dosłownie wieki... dla 96 rekordów do pobrania

Jak temu zaradzić?

[SongoQ]

Przeciez to to samo. Coraz czesciej stosuje sie taka skladnie i to jest tylko dobry nawyk ale czy przez where czy przez join sprowadza sie do tego samego. W Oracle jeszce jest skladnia where a.pole = b.pole (+)