| 0.0006 |
SELECT `id`
FROM `cle_products_categories`
WHERE `lft` >= '37'
AND `rgt` <= '64'
ORDER BY `order`
|
| 0.0034 |
SELECT `cle_relationships`.`category_id`, count( DISTINCT object_id ) as count
FROM `cle_relationships`
JOIN `cle_products` ON `cle_relationships`.`object_id` = `cle_products`.`id`
WHERE `type` = 'product'
AND `cle_relationships`.`object_type` = 'products'
AND `cle_relationships`.`value` = 'products_categories'
AND `cle_relationships`.`category_id` IN('108', '107', '105', '106', '111', '110', '109', '112', '113', '114', '115', '116', '117', '10')
GROUP BY `cle_relationships`.`category_id`
|
| 0.0003 |
SELECT `id`
FROM `cle_products_categories`
WHERE `lft` >= '37'
AND `rgt` <= '64'
ORDER BY `order`
|
| 0.0046 |
SELECT `cle_products`.*
FROM `cle_products`
JOIN `cle_relationships` ON `cle_relationships`.`object_id` = `cle_products`.`id`
WHERE `public` = 1
AND `trash` = 0
AND `type` = 'product'
AND `cle_relationships`.`object_type` = 'products'
AND `cle_relationships`.`value` = 'products_categories'
AND `cle_relationships`.`category_id` IN('108', '107', '105', '106', '111', '110', '109', '112', '113', '114', '115', '116', '117', '10')
GROUP BY `cle_products`.`id`
ORDER BY `cle_products`.`order`, `cle_products`.`created` desc
LIMIT 160, 16
|
| 0.0004 |
SELECT *
FROM `cle_relationships`
WHERE `category_id` = 'main-nav'
AND `object_type` = 'menu'
|
| 0.0005 |
SELECT `cle_products_categories`.`id`, `cle_products_categories`.`name`, `cle_products_categories`.`slug`
FROM `cle_products_categories`
WHERE `public` = 1
AND `lft` <= '37'
AND `rgt` >= '64'
ORDER BY `level`
|
TƯ VẤN LÀM BÁNH
