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

---

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

---

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

---

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

---

SELECT
cat_id
FROM
cats
WHERE topcat_id='111'; Отне: 0.00005

---

SELECT
count(DISTINCT tc3.cat_id)
FROM
cats tc3,
cats_links tc2,
ads t1
, cats_links td1
WHERE tc2.cat_id=tc3.cat_id AND t1.ad_id=tc2.ad_id AND tc3.topcat_id='111'
AND ( td1.ad_id=t1.ad_id AND td1.cat_id='111'); Отне: 0.00044

---

SELECT
DISTINCT tc3.cat_name,
tc3.lat_name,
tc3.cat_id
FROM
cats tc3,
cats_links tc2,
ads t1
, cats_links td1
WHERE tc2.cat_id=tc3.cat_id AND t1.ad_id=tc2.ad_id AND tc3.topcat_id='111'
AND ( td1.ad_id=t1.ad_id AND td1.cat_id='111'); Отне: 0.00044

---

SELECT
DISTINCT t4.data,
t3.filter_id,
t3.fdlink_id,
t0.filter_name,
LOWER(t0.filter_name)
FROM
ads t1,
filters_links t2 USE INDEX (ad_id),
filters_data_links t3,
filters_data t4,
filters t0
, cats_links td1
WHERE
t0.filter_id=t3.filter_id AND t2.ad_id=t1.ad_id AND t3.fdlink_id=t2.fdlink_id AND t4.fdata_id=t3.fdata_id AND t0.ftype_id='2' AND t0.topfdata_id='0' AND t3.properties & 2
AND ( td1.ad_id=t1.ad_id AND td1.cat_id='111')
ORDER BY t3.filter_id; Отне: 0.03766

---

SELECT
count(td1.ad_id)
FROM
cats_links td1

WHERE
td1.cat_id='111' ; Отне: 0.00006

---

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='111')
ORDER BY td1.is_vip DESC, td1.ad_id DESC
LIMIT 0, 20; Отне: 0.00544

---