| 0.0223 |
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='1078' AND u.last_media_insert IS NOT NULL
ORDER BY u.last_media_insert DESC
LIMIT 0 , 6
|
| 0.0115 |
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 ='1078' AND u.username IS NOT NULL
ORDER BY s.ID_stat DESC
LIMIT 12
|
| 0.0110 |
SELECT *
FROM mm_userconf
WHERE ID_user = '0'
LIMIT 1
|
| 0.0112 |
SELECT *
FROM mm_userconf
WHERE ID_user = '0'
LIMIT 1
|
| 0.0109 |
SELECT u.username, m.plik, m.ilosc_ocen, m.czyjefoto, m.srednia_ocen, m.kod, m.plik_small, m.opis, m.typ, m.data, m.nazwa, m.ID_media AS id, k.nazwa AS nazwaKat, k.opis AS opisKat, k.ID_kategoria AS idKat, m.ID_user,
m.mms, m.views, m.exif, m.ilosc_plusow, m.ocena_z_plusow, s.nazwa_kategorii, m.ID_syskat, u.votepower FROM mm_media m
LEFT OUTER JOIN mm_users u ON u.id=m.ID_user
LEFT OUTER JOIN mm_kategoria k ON k.ID_kategoria=m.ID_kategoria
LEFT OUTER JOIN mm_syskat s ON s.ID_syskat=m.ID_syskat
WHERE m.ID_media = '0' AND m.ID_user = '1078' AND publikuj='1'
LIMIT 1
|
| 0.0105 |
SELECT nazwa_kod, nazwa FROM mm_tag
WHERE ID_media='0'
|
| 0.0107 |
SELECT * FROM mm_fotoforum_wpisy w
LEFT JOIN mm_fotoforum_tematy t ON t.ID_tematy=w.ID_tematy
WHERE w.ID_media = '0'
|
| 0.0106 |
SELECT ID_media, nazwa
FROM mm_media
WHERE `data` < (SELECT `data` FROM mm_media WHERE id_media = 0 )
AND ID_user = 1078 AND publikuj = '1'
ORDER BY `data` DESC
LIMIT 1
|
| 0.0103 |
SELECT ID_media, nazwa
FROM mm_media
WHERE `data` > (SELECT data FROM mm_media WHERE id_media = 0 )
AND ID_user = 1078 AND publikuj = '1'
ORDER BY `data` ASC
LIMIT 1
|
| 0.0102 |
UPDATE mm_media SET views = views + 1 WHERE ID_media='0'
|
| 0.0107 |
SELECT count(w.ID_wiad) as nowe FROM mm_wiadomosci w WHERE
ID_odbiorca='' AND przeczytana='0' AND
wyslana='1' AND
stan_odbiorca='0'
|
Blog na Twoje fotki
