| 0.0012 |
SELECT `content`.*, `u`.`username`, `company`.`name`, `company`.`aname`, `company`.`tel`, `company`.`email`, `cat`.`name` cat, `cat`.`aname` acat
FROM (`psu_content` content)
JOIN `psu_category` cat ON `content`.`cat_id` = `cat`.`id`
JOIN `users` u ON `u`.`id` = `content`.`user_id`
JOIN `psu_company` company ON `u`.`id` = `company`.`user_id`
WHERE `content`.`title_alias` = 'remont-kvartir-otdelka-ofisov'
AND `content`.`type` = 'boards'
LIMIT 1
|
| 0.0001 |
SELECT *
FROM (`psu_category`)
WHERE `parent_id` = 0
|
| 0.0001 |
SELECT COUNT(*) AS `numrows`
FROM (`psu_content`)
WHERE `type` = 'boards'
|
| 0.0013 |
SELECT *, MATCH (`title`) AGAINST ('Ремонт квартир, отделка офисов')
FROM `psu_content`
WHERE `type` = 'boards'
AND MATCH (`title`) AGAINST ('Ремонт квартир, отделка офисов') > 0
AND `id` != 84
ORDER BY `created` DESC
LIMIT 5
|
| 0.0001 |
SELECT *
FROM (`psu_category`)
WHERE `parent_id` = 0
|
