| 0.0115 |
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='1338' AND u.last_media_insert IS NOT NULL
ORDER BY u.last_media_insert DESC
LIMIT 0 , 6
|
| 0.0108 |
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 ='1338' AND u.username IS NOT NULL
ORDER BY s.ID_stat DESC
LIMIT 12
|
| 0.0111 |
SELECT *
FROM mm_userconf
WHERE ID_user = '0'
LIMIT 1
|
| 0.0111 |
SELECT *
FROM mm_userconf
WHERE ID_user = '0'
LIMIT 1
|
| 0.0115 |
SELECT us.username as ulubiony, us.id as ulubionyid, uc.avatar, uc.haslo_na_bloga, m.ID_media, m.nazwa, m.plik, m.opis FROM mm_ulubione u
LEFT OUTER JOIN mm_users us ON us.id=u.ID_blog
LEFT OUTER JOIN mm_media m ON m.ID_media=us.last_id_media
LEFT OUTER JOIN mm_userconf uc ON uc.ID_user=u.ID_blog
WHERE
u.ID_user = '1338'
ORDER BY us.last_media_insert DESC
LIMIT 0, 51
|
| 0.0108 |
SELECT us.username as ulubiony, us.id as ulubionyid, uc.avatar, uc.haslo_na_bloga, m.ID_media, m.nazwa, m.plik, m.opis, u.ID_uzdjecie FROM mm_ulubione_zdjecia u
LEFT OUTER JOIN mm_media m ON m.ID_media=u.ID_uwpis
LEFT OUTER JOIN mm_users us ON us.id=m.ID_user
LEFT OUTER JOIN mm_userconf uc ON uc.ID_user=us.id
WHERE
u.ID_user = '1338' AND us.id IS NOT NULL
ORDER BY `u`.`data` DESC
LIMIT 0, 51
|
| 0.0104 |
SELECT COUNT(*) as ile FROM mm_ulubione_zdjecia u
LEFT OUTER JOIN mm_media m ON m.ID_media=u.ID_uwpis
LEFT OUTER JOIN mm_users us ON us.id=m.ID_user
WHERE
u.ID_user = '1338' AND us.id IS NOT NULL
|
Blog na Twoje fotki
