| 0.0005 |
SELECT `products`.*, `categories`.`cat_name`, `sub_categories`.`sub_cat_name`, `child_categories`.`child_cat_name`, `products`.*
FROM `products`
LEFT JOIN `categories` ON `categories`.`cat_id` = `products`.`cat_id`
LEFT JOIN `sub_categories` ON `sub_categories`.`sub_cat_id` = `products`.`sub_cat_id`
LEFT JOIN `child_categories` ON `child_categories`.`child_cat_id` = `products`.`child_cat_id`
WHERE `brand_id` = '170'
AND `published` = 1
ORDER BY `name` ASC
|
| 0.0004 |
SELECT *
FROM `brands`
WHERE `active` = 1
|
| 0.0002 |
SELECT *
FROM `categories`
WHERE `active` = 1
|
| 0.0002 |
SELECT *
FROM `sub_categories`
WHERE `active` = 1
|
| 0.0006 |
SELECT *
FROM `child_categories`
WHERE `active` = 1
|
