| 0.0109 |
SELECT u.username, m.plik, m.typ, m.data, m.nazwa, m.opis, m.kod, m.ID_media AS id, m.views, m.srednia_ocen, uc.avatar, uc.haslo_na_bloga FROM mm_ulubione ul
LEFT OUTER JOIN mm_users u ON u.id=ul.ID_blog
LEFT OUTER JOIN mm_media m ON m.ID_media=u.last_id_media
LEFT OUTER JOIN mm_userconf uc ON uc.ID_user = ul.ID_blog
WHERE ul.ID_user='2241' AND u.last_media_insert IS NOT NULL
ORDER BY u.last_media_insert DESC
LIMIT 0 , 6
|
| 0.0107 |
SELECT u.username, uu.avatar FROM mm_statystyki_ostatnie s
LEFT JOIN mm_users u ON u.id=s.kto
LEFT JOIN mm_userconf uu ON uu.ID_user=s.kto
WHERE kogo ='2241' AND u.username IS NOT NULL
ORDER BY s.ID_stat DESC
LIMIT 12
|
| 0.0212 |
SELECT *
FROM mm_userconf
WHERE ID_user = '0'
LIMIT 1
|
| 0.0111 |
SELECT *
FROM mm_userconf
WHERE ID_user = '0'
LIMIT 1
|
| 0.0106 |
SELECT m.ID_media, m.plik, m.plik_small, m.typ, m.nazwa as nazwawpisu, m.opis as opiswpisu,
k.nazwa as nazwakat, k.opis as opiskat, k.ilosc as iloscwpisow, k.ID_kategoria, m.kod
FROM mm_kategoria k
LEFT JOIN mm_media m ON m.ID_media = k.last_media_id
WHERE k.ID_user = '2241' AND k.ilosc > 0
ORDER BY k.ID_kategoria ASC
LIMIT 0, 1000
|
| 0.0105 |
SELECT COUNT(k.ID_kategoria) as ile
FROM mm_kategoria k
LEFT JOIN mm_media m ON m.ID_media = k.last_media_id
WHERE k.ID_user = '2241' AND k.ilosc > 0
|
Rysunki : D 
Blog na Twoje fotki
