| 0.0035 |
SELECT company.*,cat.name cat, cat.aname acat
FROM psu_company company
JOIN psu_category cat ON company.cat_id = cat.id
JOIN users u ON u.id = company.user_id
AND (`cat`.`id` IN (
SELECT `c1`.`id`
FROM `psu_category` `c1`
JOIN `psu_category` `c2` ON c1.parent_id = c2.id
WHERE c2.aname = 'avtohimiya')
OR `cat`.`aname` = 'avtohimiya') ORDER BY `created` desc
LIMIT 0,10
|
| 0.0005 |
SELECT COUNT(*) AS `numrows`
FROM (`psu_company` content)
JOIN `psu_category` cat ON `content`.`cat_id` = `cat`.`id`
WHERE `cat`.`aname` = 'avtohimiya'
|
| 0.0001 |
SELECT *
FROM (`psu_category`)
WHERE `parent_id` = 0
|
| 0.0004 |
SELECT `p1`.`name`, `p1`.`aname`
FROM (`psu_category` p1)
JOIN `psu_category` p2 ON `p1`.`parent_id` = `p2`.`id`
WHERE `p2`.`aname` = 'avtohimiya'
|
| 0.0003 |
SELECT `c`.`name`
FROM (`psu_category` c)
WHERE `c`.`aname` = 'avtohimiya'
|
| 0.0001 |
SELECT `c`.`name`
FROM (`psu_category` c)
WHERE `c`.`aname` = 'avtohimiya'
|
| 0.0002 |
SELECT *
FROM (`psu_category`)
WHERE `parent_id` = 0
|
