| 0.0003 |
SELECT *
FROM `cle_categories`
WHERE `public` = 1
AND `slug` = 'blog'
|
| 0.0002 |
SELECT `id`
FROM `cle_categories`
WHERE `lft` >= '2'
AND `rgt` <= '19'
ORDER BY `order`
|
| 0.0017 |
SELECT `cle_relationships`.`category_id`, count( DISTINCT object_id ) as count
FROM `cle_relationships`
JOIN `cle_post` ON `cle_relationships`.`object_id` = `cle_post`.`id`
WHERE `public` = 1
AND `trash` = 0
AND `cle_relationships`.`object_type` = 'post'
AND `cle_relationships`.`category_id` IN('1', '2', '3', '4', '5', '6', '7', '8', '9')
GROUP BY `cle_relationships`.`category_id`
|
| 0.0002 |
SELECT `id`
FROM `cle_categories`
WHERE `lft` >= '2'
AND `rgt` <= '19'
ORDER BY `order`
|
| 0.0020 |
SELECT `cle_post`.*
FROM `cle_post`
JOIN `cle_relationships` ON `cle_relationships`.`object_id` = `cle_post`.`id`
WHERE `public` = 1
AND `trash` = 0
AND `cle_relationships`.`object_type` = 'post'
AND `cle_relationships`.`category_id` IN('1', '2', '3', '4', '5', '6', '7', '8', '9')
GROUP BY `cle_post`.`id`
ORDER BY `cle_post`.`order`, `cle_post`.`created` desc
LIMIT 10, 10
|
| 0.0004 |
SELECT *
FROM `cle_relationships`
WHERE `category_id` = 'main-nav'
AND `object_type` = 'menu'
|
| 0.0003 |
SELECT `cle_categories`.`id`, `cle_categories`.`name`, `cle_categories`.`slug`
FROM `cle_categories`
WHERE `public` = 1
AND `lft` <= '2'
AND `rgt` >= '19'
ORDER BY `level`
|
| 0.0006 |
SELECT *
FROM `cle_post`
WHERE `public` = 1
AND `trash` = 0
AND `post_type` = 'post'
ORDER BY `order`, `created` desc
LIMIT 5
|
| 0.0005 |
SELECT `id`
FROM `cle_categories`
WHERE `lft` >= '2'
AND `rgt` <= '19'
ORDER BY `order`
|
| 0.0017 |
SELECT `cle_post`.*
FROM `cle_post`
JOIN `cle_relationships` ON `cle_relationships`.`object_id` = `cle_post`.`id`
WHERE `public` = 1
AND `trash` = 0
AND `post_type` = 'post'
AND `status` = 1
AND `cle_relationships`.`object_type` = 'post'
AND `cle_relationships`.`category_id` IN('1', '2', '3', '4', '5', '6', '7', '8', '9')
GROUP BY `cle_post`.`id`
ORDER BY `order`, `created` desc
LIMIT 5
|
| 0.0004 |
SELECT `id`
FROM `cle_categories`
WHERE `lft` >= '17'
AND `rgt` <= '18'
ORDER BY `order`
|
| 0.0008 |
SELECT `cle_post`.*
FROM `cle_post`
JOIN `cle_relationships` ON `cle_relationships`.`object_id` = `cle_post`.`id`
WHERE `public` = 1
AND `trash` = 0
AND `post_type` = 'post'
AND `cle_relationships`.`object_type` = 'post'
AND `cle_relationships`.`category_id` IN('9')
GROUP BY `cle_post`.`id`
ORDER BY `order`, `created` desc
LIMIT 5
|
| 0.0002 |
SELECT `id`
FROM `cle_categories`
WHERE `lft` >= '15'
AND `rgt` <= '16'
ORDER BY `order`
|
| 0.0006 |
SELECT `cle_post`.*
FROM `cle_post`
JOIN `cle_relationships` ON `cle_relationships`.`object_id` = `cle_post`.`id`
WHERE `public` = 1
AND `trash` = 0
AND `post_type` = 'post'
AND `cle_relationships`.`object_type` = 'post'
AND `cle_relationships`.`category_id` IN('8')
GROUP BY `cle_post`.`id`
ORDER BY `order`, `created` desc
LIMIT 5
|
| 0.0002 |
SELECT `id`
FROM `cle_categories`
WHERE `lft` >= '13'
AND `rgt` <= '14'
ORDER BY `order`
|
| 0.0005 |
SELECT `cle_post`.*
FROM `cle_post`
JOIN `cle_relationships` ON `cle_relationships`.`object_id` = `cle_post`.`id`
WHERE `public` = 1
AND `trash` = 0
AND `post_type` = 'post'
AND `cle_relationships`.`object_type` = 'post'
AND `cle_relationships`.`category_id` IN('7')
GROUP BY `cle_post`.`id`
ORDER BY `order`, `created` desc
LIMIT 5
|
| 0.0003 |
SELECT `id`
FROM `cle_categories`
WHERE `lft` >= '11'
AND `rgt` <= '12'
ORDER BY `order`
|
| 0.0005 |
SELECT `cle_post`.*
FROM `cle_post`
JOIN `cle_relationships` ON `cle_relationships`.`object_id` = `cle_post`.`id`
WHERE `public` = 1
AND `trash` = 0
AND `post_type` = 'post'
AND `cle_relationships`.`object_type` = 'post'
AND `cle_relationships`.`category_id` IN('6')
GROUP BY `cle_post`.`id`
ORDER BY `order`, `created` desc
LIMIT 5
|
| 0.0002 |
SELECT `id`
FROM `cle_categories`
WHERE `lft` >= '9'
AND `rgt` <= '10'
ORDER BY `order`
|
| 0.0005 |
SELECT `cle_post`.*
FROM `cle_post`
JOIN `cle_relationships` ON `cle_relationships`.`object_id` = `cle_post`.`id`
WHERE `public` = 1
AND `trash` = 0
AND `post_type` = 'post'
AND `cle_relationships`.`object_type` = 'post'
AND `cle_relationships`.`category_id` IN('5')
GROUP BY `cle_post`.`id`
ORDER BY `order`, `created` desc
LIMIT 5
|
| 0.0005 |
SELECT `id`
FROM `cle_categories`
WHERE `lft` >= '7'
AND `rgt` <= '8'
ORDER BY `order`
|
| 0.0005 |
SELECT `cle_post`.*
FROM `cle_post`
JOIN `cle_relationships` ON `cle_relationships`.`object_id` = `cle_post`.`id`
WHERE `public` = 1
AND `trash` = 0
AND `post_type` = 'post'
AND `cle_relationships`.`object_type` = 'post'
AND `cle_relationships`.`category_id` IN('4')
GROUP BY `cle_post`.`id`
ORDER BY `order`, `created` desc
LIMIT 5
|
| 0.0005 |
SELECT `id`
FROM `cle_categories`
WHERE `lft` >= '5'
AND `rgt` <= '6'
ORDER BY `order`
|
| 0.0006 |
SELECT `cle_post`.*
FROM `cle_post`
JOIN `cle_relationships` ON `cle_relationships`.`object_id` = `cle_post`.`id`
WHERE `public` = 1
AND `trash` = 0
AND `post_type` = 'post'
AND `cle_relationships`.`object_type` = 'post'
AND `cle_relationships`.`category_id` IN('3')
GROUP BY `cle_post`.`id`
ORDER BY `order`, `created` desc
LIMIT 5
|
| 0.0003 |
SELECT `id`
FROM `cle_categories`
WHERE `lft` >= '3'
AND `rgt` <= '4'
ORDER BY `order`
|
| 0.0007 |
SELECT `cle_post`.*
FROM `cle_post`
JOIN `cle_relationships` ON `cle_relationships`.`object_id` = `cle_post`.`id`
WHERE `public` = 1
AND `trash` = 0
AND `post_type` = 'post'
AND `cle_relationships`.`object_type` = 'post'
AND `cle_relationships`.`category_id` IN('2')
GROUP BY `cle_post`.`id`
ORDER BY `order`, `created` desc
LIMIT 5
|
TƯ VẤN LÀM BÁNH
.jpg)
.jpg)
