SELECT affid, templatedir, mainpagetitle FROM affiliates WHERE subdomain='medianet'; Отне: 0.00005

---

SELECT cat_id, cat_name, level, topcat_id FROM cats WHERE lat_name='prodavam'; Отне: 0.00004

---

SELECT cat_name, lat_name, topcat_id, cat_id FROM cats WHERE cat_id='1'; Отне: 0.00009

---

SELECT
count(td1.ad_id)
FROM
cats_links td1

WHERE
td1.cat_id='1' ; Отне: 0.00007

---

SELECT
td1.ad_id,
t1.title,
t1.description,
t1.phone,
t1.contacts,
t1.haspic,
t1.city,
t1.city_fdlink_id,
t1.price,
FROM_UNIXTIME(t1.posted_time, "%H:%i / %d.%m.%Y"),
t1.is_vip

FROM
ads t1
, cats_links td1
WHERE 1
AND ( td1.ad_id=t1.ad_id AND td1.cat_id='1')
ORDER BY td1.is_vip DESC, td1.ad_id DESC
LIMIT 0, 20; Отне: 0.02255

---